This discussion is archived
2 Replies Latest reply: Apr 12, 2013 11:16 AM by 951168 RSS

What trigger is called?

951168 Newbie
Currently Being Moderated
While navigating through my form I get a message

"One or more blocks have changed would you like to save your changes?"
I choose [Yes]

Then another message pops up
"FRM-40400: Transaction complete: 1 records applied and saved."
I choose [Ok]

Then I loose focus on the form. I want to know what trigger is called after those events so I can set the focus back to where I was so I do not need to use the mouse to regain focus.

Thanks
  • 1. Re: What trigger is called?
    Michael Ferrante (Oracle) Guru Moderator
    Currently Being Moderated
    If the last thing to happen is a "Save" then likely Post-Database-Commit occurs either during or after that dialog is presented. Refer to the Builder Online Help for details on how it works, as it may also fire during Posts.

    That said, the real question is your suggestion of a "focus" loss. Because you did not provide any version details it will be hard to offer anything specific. If you are uncontrollably losing focus you may be hitting a bug. I would recommend that you ensure that you are using the latest patched versions of whatever major version you are using. The latest of the supported versions is 11.1.1.7 and 11.1.2.1
  • 2. Re: What trigger is called?
    951168 Newbie
    Currently Being Moderated
    When they were running from Oracle Applications 11.5.10.2 - Forms Server 6.0.8.28.0, the focus would return to the field that was selected when the messages popped up.

    Now we are on Oracle Applications 12.1.3 - Forms Server 10.1.2.3.0 and the focus does not return to the field that was selected when the messages pop up.

    I am going to try the trigger you mentioned and report back, let me know if any more information is required.

    EDIT: Adding go_item to the trigger is not giving me any results. I even included a message box to see if the trigger was being executed and nothing happened.

    Thank you.

    Edited by: 948165 on Apr 12, 2013 11:15 AM

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points