Home » Developer & Programmer » Forms » frm-40105 unable to resolve reference
frm-40105 unable to resolve reference [message #652800] Mon, 20 June 2016 03:20 Go to next message
Mraouf
Messages: 14
Registered: June 2016
Location: Egypt
Junior Member
the below code gives me this error "frm-40105 unable to resolve reference" while opening form
declare
v_user_id Number;
V_User_Name Varchar2 (80);
begin
v_user_id := fnd_profile.value('USER_ID');
select f.last_name
into V_User_Name --:XXTE_GL_REQUEST_FORM.REQUETER_NAME
from per_all_people_f f , fnd_user u
where u.employee_id = f.person_id
and sysdate between f.effective_start_date and f.effective_end_date
and u.user_id = v_user_id;
SET_ITEM_PROPERTY(:XXTE_GL_REQUEST_FORM.REQUETER_NAME,INITIAL_VALUE,V_User_Name);
go_item('XXTE_GL_REQUEST_FORM.REQUETER_NAME');
end;
Re: frm-40105 unable to resolve reference [message #652817 is a reply to message #652800] Mon, 20 June 2016 04:52 Go to previous messageGo to next message
cookiemonster
Messages: 13917
Registered: September 2008
Location: Rainy Manchester
Senior Member
Please read and follow How to use [code] tags and make your code easier to read?

I doubt you want to set the intial_value of an item whose name is stored in :XXTE_GL_REQUEST_FORM.REQUETER_NAME.


[EDITED by LF: fixed invalid link]

[Updated on: Tue, 21 June 2016 03:36] by Moderator

Report message to a moderator

Re: frm-40105 unable to resolve reference [message #652840 is a reply to message #652817] Mon, 20 June 2016 16:16 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Check whether you correctly spelled block name (XXTE_GL_REQUEST_FORM) and item name (REQUETER_NAME). Do both of them exists?

I suspect that correct item name might be REQUESTER_NAME.
Re: frm-40105 unable to resolve reference [message #652854 is a reply to message #652840] Tue, 21 June 2016 01:47 Go to previous messageGo to next message
Mraouf
Messages: 14
Registered: June 2016
Location: Egypt
Junior Member
Thanks, but the correct name is "REQUETER"..
Re: frm-40105 unable to resolve reference [message #652855 is a reply to message #652817] Tue, 21 June 2016 01:49 Go to previous messageGo to next message
Mraouf
Messages: 14
Registered: June 2016
Location: Egypt
Junior Member
Thanks, i couldn't open the link it gives the bellow:
You have followed an invalid link. Please notify the webmaster how you got here.

Re: frm-40105 unable to resolve reference [message #652861 is a reply to message #652855] Tue, 21 June 2016 02:45 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Link is this one.
Re: frm-40105 unable to resolve reference [message #652862 is a reply to message #652861] Tue, 21 June 2016 03:03 Go to previous messageGo to next message
Mraouf
Messages: 14
Registered: June 2016
Location: Egypt
Junior Member
Thanks
Re: frm-40105 unable to resolve reference [message #652876 is a reply to message #652862] Tue, 21 June 2016 07:12 Go to previous message
cookiemonster
Messages: 13917
Registered: September 2008
Location: Rainy Manchester
Senior Member
It seems both you and (surprisingly) LF have missed my point.
The first parameter for set_item_property is the name of the item you want modified.
You passed a datablock item. Consequently forms reads the value of that item as the name you want to use.
You need to pass the name of the item, not the item itself. Wrap the name in quotes.
Previous Topic: How to control editing at particular record in Detail Block
Next Topic: What Type of Trigger Required For Automatically Fire Trigger when cursor on Text Field (merged 2)
Goto Forum:
  


Current Time: Fri Mar 29 09:18:38 CDT 2024