| frm-40105 unable to resolve reference [message #652800] |
Mon, 20 June 2016 03:20  |
 |
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 #652876 is a reply to message #652862] |
Tue, 21 June 2016 07:12  |
cookiemonster
Messages: 13965
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
