The trick is to get to it as quickly as possible. Unfortunately in your case I think the best option is to replace the carpet.
I've never seen anything that
completely removes urine stains.
This is my spot cleaner. I've used it recently to clean up my W140 but it often comes out when I have people over and they spill something on my carpet.
Suck up that red wine in an instant.
