When you got error from parent stored procedure after calling child stored procedure, will the child stored procedure data will be rollback if you are using transaction in both stored procedures?