Current Position:Home > FRM-40737 Error, While using COMMIT_FORM

FRM-40737 Error, While using COMMIT_FORM

Update:10-11Source: network consolidation
Advertisement
Hi,
Please guide for the following:
In a form, I have two data blocks,namely master and detail.
In PRE-INSERT trigger of master block, I am using GO_BLOCK('detail').
The form has a SAVE_BTN also, in save_btn i am using COMMIT_FORM.
When user clicks save-btn , FRM-40737 error is generating.
Please help.
Regards,

The Best Answer

Advertisement
You can't use go_block in a pre-insert trigger - it is a restricted built-in.
When you commit, the Form will save all the changes regardless of which block they are in.
Steve
  • FRM-40737 Error, While using COMMIT_FORM Update:10-11

    Hi, Please guide for the following: In a form, I have two data blocks,namely master and detail. In PRE-INSERT trigger of master block, I am using GO_BLOCK('detail'). The form has a SAVE_BTN also, in save_btn i am using COMMIT_FORM. When user clicks s

  • Go_item(:detail.item) after query(F7) in master, frm-40737 Update:11-30

    Dear friends, I have a master block and a detail block. When the master block ist queried, I want to go to a disticnt item in detail block, if there are records. Therefore I tried to put code in the post_query of the detail_block, which caused error

  • I am getting frm :40737 because go_block Update:11-30

    Hello World, I have a form with master block and details , the detail block as a tabular. I want the detail block to track the changes on the master , like if the user updated on a particular item on the master the detail keep the username and date.

  • FRM-40737: illegal restricted procedure COMMIT in POST-TEXT-ITEM trigger Update:11-30

    Hi All, I tried to execute an insert statement in a POST-TEXT-ITEM trigger and use commit to save data in the db but this error appeared: FRM-40737: illegal restricted procedure COMMIT in POST-TEXT-ITEM trigger How to solve it? OR how to save every t

  • FRM-41839 error Update:11-30

    Hi all, I start receiving "FRM-41839: Disk I/O error on temporary record buffer file /tmp/filebfKMCw.TMP" When I hit OK, I am getting "ORA-01403 No Data Found" and "FRM-40507: Oracle error: unable to fetch next query record. $ ll

  • FRM-40737:illegal restricted procedure COMMIT in WHEN-VALID_RECORD trigger Update:11-30

    Hello, I added the following code in Custom.pll, Event procedure. When Internet Expenses responsibility is added to a user on the User form in System Administrator repsonsibility, his default account will be populated from costing. I received error,

  • ISSUE_ROLLBACK gives FRM-40737 in 10g Update:11-30

    Hi, I'm in the process of migrating to the new version of Appserver from 9.03 to 10.1.2 I got the application running fine except for this error. In a form we have ISSUE_ROLLBACK('bysave') in ON_ROLLBACK trigger. It gives the error FRM-40737 Illegal

  • FRM 40737: Illegal Restricted Procedure   in !!! HELPPP Update:11-30

    Hi: I have to use a program unit in Pre-Insert/ Pre-update triggers. That program unit calls some restricted built ins. Hence whenever I am using that program unit in validation triggers its giving FRM 40737 - Illegal restricted procedure FIRST_RECOR

  • GO_ITEM or FRM-40737 Update:11-30

    I have a field in Block A that I want it to go to another field in Block b when the user hit the TAB key. I created the WHEN-VALIDATE-ITEM on the field of block A and wrote go_item('blockB.item_name'). This did not work and I am getting the FRM-40737

  • Getting FRM-40010 Error While opening new form  .fmx Update:10-11

    Hi, Oracle apps : 11.5.10.2 Forms : Forms 6.0 I'm creating a custom form by using one oracle apps table.I created a basic form by using template.fmb and then saved it to directory "/dir1" and run this form by connecting to oracle apps database.