Home » Developer & Programmer » Forms » Getting "FRM-40105: Unable to resolve reference to item" when using FND_FUNCTION.EXECUTE i (Appl 11.5.10.2 Linux X86)
Getting "FRM-40105: Unable to resolve reference to item" when using FND_FUNCTION.EXECUTE i [message #285778] Wed, 05 December 2007 10:30 Go to next message
msuphaluk
Messages: 20
Registered: December 2007
Location: BKK,Thailand
Junior Member
Dear All,
I wanna develop a function similar with "choose_org" of Inventory standard feature in order to let users choose a some specific value first before proceed the next step.
I created 'FUNCTION_B' function and placed fnd_function.execute('FUNCTION_B') in 'PRE-FORM' trigger of my form,'FORM_A' in order popup the new form,'FORM_B', and force user selects the specific value then come back to FORM_A.
But when I ran the form. I got these messages "FRM-40105: Unable to resolve reference to item" and "FRM-40738: Argument 1 to built in FND_VIEW cannot be null'.
What should I address this p/b?

Pls kindly advise me.

Note: I could ran 'FUNCTION_B'properly if I called it via the menu function or if it's placed in WHEN-NEW-FORM-INSTANCT. It always failed when I placed fnd_function.execute in PRE-FORM. After investigation, I know the choose_org function will execute USER_EXIT('FND ORG'). I am not sure I can run fnd_function.execute in PRE-FORM trigger or not?

Thank you in advanced,

Suphaluk M.
Re: Getting "FRM-40105: Unable to resolve reference to item" when using FND_FUNCTION.EXECU [message #288866 is a reply to message #285778] Wed, 19 December 2007 00:07 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
'Pre-Form' happens BEFORE the form is truly up and running. You say it works in 'When-New-Form-Instance'. If it works there then use it there. 'Pre-Form' is for determining whether the user has access rights and other environment conditions.

David
Re: Getting "FRM-40105: Unable to resolve reference to item" when using FND_FUNCTION.EXECU [message #289358 is a reply to message #288866] Thu, 20 December 2007 22:18 Go to previous message
msuphaluk
Messages: 20
Registered: December 2007
Location: BKK,Thailand
Junior Member
Thank you for your kindly reply. Now, my problem was resolved. I placed the code in WHEN-NEW-FORM-INSTANCE.

Suphaluk M.
Previous Topic: How to Re-order ?
Next Topic: Killing of user sessions in oracle
Goto Forum:
  


Current Time: Mon Feb 03 01:10:59 CST 2025