Hi
Where do you get the data used in inserting the records?  Does it come from parameters to the stored procedure?
How do you tell if all Detail records have been input?  Are there a set number?
Or are you talking about the inserts causing an error, & trapping the error?