Home » Developer & Programmer » Forms » Custom Message Popping Multiple times- Form Personalization (R12)
Custom Message Popping Multiple times- Form Personalization [message #683772] Fri, 19 February 2021 16:02 Go to next message
vharish006
Messages: 70
Registered: August 2015
Location: Chicago
Member
Hi All,

I have a requirement to Pop up a custom message when the User forgets to enter 3 DFF field Values. So when they try to save after rest of the details except these 3 a message should show up.

I tried below but it keeps popping up multiple times even when we open the form.

Condition:
-------------
(:OKS_HEADER.ATTRIBUTE40 IS NULL OR :OKS_HEADER.ATTRIBUTE41 IS NULL OR :OKS_HEADER.ATTRIBUTE42 IS NULL) AND :OKS_HEADER.ORG_ID=206

Uploaded the Image for your reference. Please provide some guidance.
Re: Custom Message Popping Multiple times- Form Personalization [message #683778 is a reply to message #683772] Sun, 21 February 2021 02:05 Go to previous messageGo to next message
Littlefoot
Messages: 21675
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
What other options does the "Processing mode" property offer?
Re: Custom Message Popping Multiple times- Form Personalization [message #683798 is a reply to message #683778] Mon, 22 February 2021 10:54 Go to previous messageGo to next message
vharish006
Messages: 70
Registered: August 2015
Location: Chicago
Member
Processing Mode Property Offers 3 properties
1.Not in Enter-Query Mode
2.Only in Enter Query Mode
3.Both
Re: Custom Message Popping Multiple times- Form Personalization [message #683805 is a reply to message #683798] Mon, 22 February 2021 13:22 Go to previous message
Littlefoot
Messages: 21675
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Quote:
it keeps popping up multiple times even when we open the form.
Right; it looks as if the trigger is firing on fetch. I hoped for more options in the "Processing mode" property, but ... apparently, that won't happen.

Sorry, I don't use Oracle Apps. and I wouldn't know what to do in this case. I hope someone else will be able to assist.
Previous Topic: how to Import specific columns from Excel to form
Next Topic: Filter a LOV that has AUTO_REFRESH set to FALSE
Goto Forum:
  


Current Time: Sun Jun 13 14:49:43 CDT 2021