Oracle form 10g,Transaction rollback at time of failure

create a procedure and put all inside sp
it will be committed or rolled back

call this sp from app and trap exception

above behaviour is called implicit rollback...

Implicit Rollback
https://asktom.oracle.com/pls/asktom/f?p=100:11:0%3A%3A%3A%3AP11_QUESTION_ID:43818437682131

you call a stored procedure from app...
if it succeeds, it is committed
if it fails, everything will be rolled back, and exception raised so you can capture in your app and do some further processing...

The default behaviour of oracle forms will commit all data changed in the form if the  inserts,updates en deletes oracle forms issues are all succesfull.  If not all succesfull there is no commit : you can correct the data or leave the form:   if there are uncommitted changed you will be asked to commit or leave the form , normally then there is a rollback issued.
1)  be carefull if  changing (other) data with direct inserts,updates en deletes in pl/sql-procedures:   oracle forms commit processing stops succesfully if there are no changes in the blocks of the form.  (same for rollback)
2)  default behaviour can be changed : check for  on-commit and exit-form triggers.

By default, Oracle Forms will give you exactly what you as asking for.  So, unless you have forms where someone has included some non-default functionality in triggers or program units, your Oracle Forms should be doing exactly what you are asking for.

Do you have forms where you are seeing something different?  If yes, you will need to investigate the triggers and program units in the form, plus any program units in attached *.pll libraries, plus any database PL\SQL objects that are called from any of these triggers or program units to see if any of them include explicit rollback or commit statements.  One other possibility to check: look for DDL commands like: create, alter, drop, etc. in "execute immediate..." or DBMS_SQL statements in those same locations.  These are less likely, but they do include an implicit "commit" that you won't see in the code.