form_trigger_failure rollback
It appears that raising form_trigger_failure rolls back any database changes which have been posted by the form UNLESS there has been an explicit call to POST. I cannot find this documented and wonder whether this is what actually happens. The following scenarios demonstrate this:
Create a new record.
Press Commit.
Raise form_trigger_failure in POST-INSERT.
Correct the Data.
Press Commit.
-Forms performs an INSERT
Create a new record.
Press a Button which does POST;
Raise form_trigger_failure in POST-INSERT.
Correct the Data.
Press Commit.
-Forms performs an UPDATE