Easy way to find DML operation Issues

Lets see easy method to find-out root cause of any DML operation easily by following below steps:


Requirement   is to track DML operation errors in one unique table.
Lets say i have below  table.



CREATE TABLE TRANS(T_ID INTEGER,AMOUNT NUMBER(10,2))

alter table TRANS add constraint T_ID_PK primary key(T_ID);


insert into TRANS values (1,21);
insert into TRANS values (5,5.75);

Commit;

Click on below images to get enlarged size.
 

Update Scenario: