Current Position:Home > frm-40737 illegal next_record

frm-40737 illegal next_record

  • FRM-40737: illegal restricted procedure COMMIT in POST-TEXT-ITEM trigger Updated: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-40737:illegal restricted procedure COMMIT in WHEN-VALID_RECORD trigger Updated: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,

  • FRM 40737: Illegal Restricted Procedure   in !!! HELPPP Updated: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

  • FRM:40737 Illegal restricted procedure ERASE in WHEN VALDATE-RECORD trigger Updated:11-30

    Hi I am getting this error when I enter the Sales Order and try to save it sometimes. Can anyone please tell me how I can avoid this and what is the reason for this error? Sachinok, then it is an apps problem. can you copy the question in the EBS-For

  • FRM-40737: Illegal restricted procedure (Ver Updated:11-30

    My form updates State code data. I get state from the from, perform query and populate the form myself. After the last field is entered I perform the update query, then a commit. This error is on the commit. Help!Jose, Some built-ins cannot be called

  • I am getting frm :40737 because go_block Updated: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.

  • ISSUE_ROLLBACK gives FRM-40737 in 10g Updated: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 Error, While using COMMIT_FORM Updated: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 Updated: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

  • FRM-40735: illegal restricted procedure COMMIT in POST-CHANGE trigger Updated:11-30

    I am using forms6i. I have three text fields FL1 ,*FL2* , FL3 in a form. Cursor passes from FL1 to FL2 and FL2 to FL3. I want when cursor transfers from FL1 to FL2 the form should be saved(commit). On FL1 i put COMMIT; in post-change. But when I pres

  • 'CLOSED'-MSCFNSCW.fmx-FRM-40742 illegal status conversion on record9:INSERT Updated:11-30

    Hi, I am currently dealing with a Forms error on MSCFNSCW.fmx. When attempting to manually insert supply for any item, the record is saved but the following error occurs: "FRM-40742 illegal status conversion on record 9:INSERT to CHANGED" ASCP =

  • ON-VALIDATE-ITEM 40737: Illegal restricted procedure COMMIT in WHEN-VALIDAT Updated:11-30

    Dear All Expersts, In a form we want to update another table ON-VALIDATE-ITEM Or POST-UPDATE or POST-INSERT Event Could you please guide us can we do this without any error message i.e ON-VALIDATE-ITEM 40737: Illegal restricted procedure COMMIT in WH

  • GO_ITEM or FRM-40737 Updated: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

  • FRM-40737  How can I execute a query in a post block ? Updated:10-11

    Hi, I have two blocks based on the same table. Then it is not a 'real' master detail case. The first block contains two fields who are the values in the where clause of the second block. In which trigger or where do I place the EXECUTE-QUERY ? I can'

  • Illegal restricted procedure Synchronize - error in webforms Updated:11-30

    Hi All, When trying to open a webform (Oracle 9i/10g) with a field having synchronize built-in in the when-validate-item trigger, I am getting an error "Frm-40737:Illegal restricted procedure SYNCHRONIZE in WHEN-VALIDATE-ITEM trigger". Is Synchr

  • How to display records into a non table base block.. Updated:10-11

    Hi, Can anybody help me how to display records into a non table base block.... Find below is my coding but it only display the last record in the first line in the block. PROCEDURE CREATE_CARTON_QUESTION IS CURSOR car_c IS select /*+ rule */ question

  • Post Query Trigger with cursor Updated:11-30

    Good afternoon to all of you! I need your help. I create a master detail form. I created also a post quey trigger, inside I wrote the code below. A cursor looks to another table and returns to the form some values i need! declare cursor C1 is select

  • Error from Pre-Insert Trigger Updated:11-30

    I am using the following code in Pre-insert trigger purpose is that all the record which do not click by mouse (check box) should be cleared on the screen when commit/save. declare begin go_block('Bl'); first_record; loop if :kcheck is null then clea

  • How to get the original record Number in Multi-Record Block Updated:11-30

    Hello Everyone, I know how to find the duplicate item in the multi-Record block, For Ex: Line_Num            Item_Name             Quantity 1                           AA                      10 2                           BB                      20

  • When-validate-item trigger restriction on open form or call form Updated:10-11

    W have when-validate-item trigger. I need to place a code here that will bring up a form when the "valid entry" on the item has been made. I am getting a frm-40737:Illegal restricted procedure COMMIT... Code snippet on the procedure that I am ca