Ric,

Simp[le really, ROLLBACK ends the transaction so if you hit that the following END TRANSACTION will casue your error since the ROLLBACK already ended the transaction. You need either ROLLBACK or END TRANSACTION but not both.