I can help you, if you provide me the log

Amit, excellent posting!!!!

I am in same kind of situation.. by setting Xact_abort off you are loosing transaction control.

BTW, I could not able to find your code snippet.

Can you please...