Leaky Wall?

Who knows where the water's coming in from.  According to another contractor, when Michelle's old door was cut out with an electric saw, the vibrating in the wall could have broke the seal of the caulk inside the wall, and that's why water is coming in now.  He recommended that I just buy a can of water sealer and seal all the seams along the exterior of the wall.  I went to Bed Bath and Beyond and bought two cans of spray on water seal (Flex Seal).  I sprayed three coats along the bottom and top of the wall where there were cracks along the course of the day.  There's still some more left in the can, so I'll probably use up the rest of it later today by applying another coat.  What sucks is the only way to see if this works is to either hose it down myself (in which case if it fails, I'm going to have a ton of water in my kitchen), or wait for it to rain (and if it fails, same thing).  Either way, there's no sense in opening up the wall in my kitchen to fix anything until I know this is water tight.