SPL and transaction question

Problem: I have 4 tables A, B, C, D I want to call a stored procedure (search) to search on A for a particular column, pass the last row found from that search to procedure (put) that puts each column into separate B, C tables. After the insert I want to call another procedure (delete) to delete the row from D that matches our insert. Then go back to original search for the second to last row found in A until I reach the 1st row of the search. But, What if an error occured in Delete and I want to cancel all calls.