if u want u can use

Begin try ....End try and Begin catch...End Catch

In Try block put ur insert statament and in catch block put ur rollback and raiserror statament...

Mithun