Thanks Guarddata!

The later section regarding your template seems to be the solution I need to adopt. I guess I'm still a little confused about the first, simpler question though-

In the instances where one needs just a single transaction (no nesting), there will obviously be only one each of the BEGIN, ROLLBACK and COMMIT statements. (The ROLLBACK would most probably be inside some IF condition). Now, are you saying that to avoid getting the error (Error 3902) shown earlier, I always will have to use a save point, even if it is a dummy savepoint right after my BEGIN statement?