Date LOV in Forms 5
From: washesh mehra washesh@yahoo.com
Date :7/10/99 6:11 AM
Subject: Date LOV in Forms 5
Hi! All,
I'm developing application in Forms 5. Has anyone tried to show
calender in the date item LOV ? Any suggestions would be appreciated..
Many Thanx
Regds
Washesh Mehra
Date: Mon, 12 Jul 1999 14:25:12 -0400
From: "Manjula Muthukumar" m_manjula@oracleassist.com
Subject: Re: Date LOV in Forms 5
Hi Washesh,
I created a custom from in 11.0.2 by copying TEMPLATE FORM.
Make sure, ENABLE_LIST_LAMP record group & lov have been attached to your
form module. Attach ENABLE_LIST_LAMP lov to your date item. And write a
trigger KEY-LISTVAL for the date item. Within the KEY-LISTVAL trigger add
"calendar.show;".
Hope this helps,
Manju
Post Button Trigger
Date: Mon, 12 Jul 1999 14:20:48 -0700
From: "Lyuh, Julia I FIN:EX" Julia.Lyuh@gems8.gov.bc.ca
To: "'OraApps-L@cpa.qc.ca'" OraApps-L@cpa.qc.ca
Subject: Post Button Trigger
Hi,
I am trying to add some custom validation on the POST button on the Journal
Entry Form (GLXJEENT), however, sometimes the edit is bypassed.
Is there somewhere else I need to apply this edit so that whenever the user
tries to Post, it will kick it off?
Thanks.
Date: Mon, 12 Jul 1999 20:10:13 EDT
From: "Suresh Pillaipakkam Bagukkudumbi" sureshpb@hotmail.com
To: oraapps-l@cpa.qc.ca
Subject: Re: Post Button Trigger
Check your when-button-pressed or when-validate trigger??
Date: Tue, 13 Jul 1999 10:01:04 -0700
From: "Lyuh, Julia I FIN:EX" Julia.Lyuh@gems8.gov.bc.ca
Subject: RE: Post Button Trigger
Thank you for your response Suresh. I was working with the
when-button-pressed trigger. I think the problem here is that I'm not
picking up the right fields from the form and therefore not getting any
matches. So, it's more of a program logic error.
Adding more options in the SPECIAL MENU of an OraApps Form
Date: Sat, 17 Jul 1999 09:46:36 -0400 (EDT)
From: Ravichandra Aithal raviaithal@yahoo.com
Subject: Adding more options in the SPECIAL MENU of an OraApps Form
Hi All!
A small question which one of U might have encountered in aby of Ur
past
projects:
In the Sales Order Form, or for that matter any OraApps Form is it
possible
to have our own option in the Special menu and perform certain actions
on
the user selecting the custom option under Special menu (say, calling
another form or perform certain sql, etc.).
E.g.: Booking of an Order is performed thru the special menu.
I checked the Oracle Application Developers' Guide and it talks of
implementing Special stuff in the Default Menu in a new customised Form
(say, after starting off from the TEMPLATE form). The documentation
talks of
certain coding in the PRE-FORM and PRE-BLOCK triggers. This will not be
possible in any of the OraApps forms as customizing a form directly is
a
taboo.
If there is some way to do this thru CUSTOM.PLL (I checked the custom
pll
documentation in the developers' guide and that is very cryptic) or
some
other means.
If yes, please send me the particulars or some place where I can find
the
documentation.
Regards
Ravi Aithal
Date: Sat, 17 Jul 1999 09:21:40 -0500
From: "Carver, Elizabeth" ecarver@MarkAndy.com
Subject: RE: Adding more options in the SPECIAL MENU of an OraApps Form
The Custom Library allows extension of Oracle Apps without modification of
existing Oracle code.
Therefore it is still supported.
I just happened to be looking into the same thing a couple of days ago I
found the Application Developer Guide on-line in metalink and found it very
helpful. I did a search on custom library and there is a whole chapter
dedicated to the custom library.
Beth Carver
Date: Sun, 18 Jul 1999 10:50:43 -0400 (EDT)
From: Ravichandra Aithal raviaithal@yahoo.com
Subject: RE: Adding more options in the SPECIAL MENU of an OraApps Form
Thanx Beth for the response.
I have read the entire chapter on CUSTOM library in the Application
Developers' Guide. But that doesn't talk abt much on adding more
options to the Special Menu. It deals with in detail abt other features
and not much abt Special Menu additions.
I checked out OEXOEMOE.fmb (Sales Order Form in Order Entry) and it
looks like most of the Special Menu options that are available
currently have been hard coded in teh Form itself. But the small
portion in CUSTOM.pll talks of possibilities of adding more options in
the Special menu - but is silent on how to do it.
Thanx for the help anyway.
Regards
Ravi
Date: Mon, 19 Jul 1999 07:14:06 -0500
From: "Carver, Elizabeth" ecarver@MarkAndy.com
Subject: RE: Adding more options in the SPECIAL MENU of an OraApps Form
Adding Custom Entries to the Special Menu
To code logic for Special menu entries into the CUSTOM library:
1. Add a branch to the CUSTOM.EVENT procedure for the
WHEN-NEW-FORM-INSTANCE event. See: CUSTOM.EVENT:
page 25 - 14
Inside that branch, specify the form and block where you want
your logic to occur. Add the logic to set up the Special menu. See:
Application-Specific Entries: The Special Menu: page 10 - 7
You should start with entry number 15 on the Special menu
(SPECIAL15) to avoid conflicting with any Special menu entries
already provided by the form or by the VERT or GLOBE libraries
(vertical and globablization routines) and work backwards towards
SPECIAL1.
2. Add a branch to the CUSTOM.EVENT procedure for the particular
SPECIALn event you want (where n is a number between 1 and
15). See: CUSTOM.EVENT: page 25 - 14
Inside that branch, specify the form and block where you want
your logic to occur. Add the logic you want to fire from the Special
menu. This is the logic that, if you were developing the form
yourself, you would put in the user-named SPECIALn trigger. See:
Application-Specific Entries: The Special Menu: page 10 - 7
At the end of your SPECIALn logic, you must include a call to
RAISE FORM_TRIGGER_FAILURE; this ensures that any
SPECIALn trigger in the form that may already exist (with the
same number) does not fire after your logic has fired, or, if there is
no corresponding trigger, that your users do not see an error
message when the form cannot find such a trigger.
I hope this helps
Beth Carver
Date: Mon, 19 Jul 1999 11:43:26 -0500
From: Shane Bentz SBentz@IVCF.ORG
Subject: RE: Adding more options in the SPECIAL MENU of an OraApps Form
Ravi...
I would check into the Oracle Apps Coding Standards manual. I have
it here in front of me and it mentions in a couple of places ( pages 4-11
and 13-26 ) of how to use the AOL built-ins to add custom functionality to
the "Special" menu option. I would just check in the back index for
"Special menu" or something like that.
Shane.
Date: Mon, 19 Jul 1999 18:43:00 -0400 (EDT)
From: Ravichandra Aithal raviaithal@yahoo.com
Subject: RE: Adding more options in the SPECIAL MENU of an OraApps Form
Thanks Beth.
I guess I would do some research on this, when the need arises.
Actually the functional guys have changed the requirement - it has
changed from the Special menu to a Zoom. Implementing Zoom is no big
deal. Havealready completed that.
Thanks again
Ravi