I checked fuses 49, 52, and 59 tonight which are all related to the windshield washer system. They all looked intact and I tested each one with the correct amperage spare fuse and none of them would fix my windshield washer issue. Since I can't find any other obvious causes for my problem, I decided I'll buy a new windshield fluid pump (part no. 67128362154), along with the pump's strainer (part no. 61667006063) and wheel bolt pin (part no. 71111093774) to go in the trunk toolkit.
The guide here looks pretty straight forward:
http://www.zhpmafia.com/forums/showt...Y-doityourself
Only question I have is that he states that the grommet/strainer is part no. 89606011001, while according to RealOEM.com using my VIN, it should be 61667006063, which looks to be the same. Not sure what's going on there.