Hi Jurij,
Thanks for your feedback, but I can commit within the trigger. So, if the trigger fails, I will not have any info in the table.

ERROR at line 1:
ORA-04092: cannot COMMIT in a trigger
ORA-06512: at "QIS.T_WARR_BASED_ON_CARTID", line 61
ORA-04088: error during execution of trigger 'QIS.T_WARR_BASED_ON_CARTID'

Ramesh