I call this stored procedure from one asp.net app.

If transaction roll back, does app catch an error message?