The network will lock you out of making CC transactions after 3 failed attempts. you will have to wait till the lock is up. I believe it is 24 to 48 hrs? Mean while check that your address is the same on PSN as it is with your bank other wise it wont go through do to AVS.
Other than that you can always Buy PSN cards and use those.