eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQH_FR_WF_NTF dependencies on HR_UTILITY

Line 17: hr_utility.set_location('employee search failed',10);

13: OPEN csr_person_name;
14: FETCH csr_person_name INTO l_person_name;
15: CLOSE csr_person_name;
16: IF l_person_name IS NULL THEN
17: hr_utility.set_location('employee search failed',10);
18: END IF;
19: return l_person_name;
20: end get_person_name;
21:

Line 104: hr_utility.set_location(l_proc || ' Entering',10);

100: l_person_name per_all_people_f.full_name%TYPE;
101: l_url Varchar2(2000);
102: l_user_role Varchar2(200);
103: Begin
104: hr_utility.set_location(l_proc || ' Entering',10);
105: hr_utility.set_location(l_proc || ' Params - l_itemtype '|| l_itemtype,15);
106: hr_utility.set_location(l_proc || ' Params - l_process name '|| l_process_name,15);
107: select PQH_FR_WF_NOTIFICATION_S.NEXTVAL into l_itemkey from dual;
108: hr_utility.set_location(l_proc || ' Params - l_itemkey '|| l_itemkey,35);

Line 105: hr_utility.set_location(l_proc || ' Params - l_itemtype '|| l_itemtype,15);

101: l_url Varchar2(2000);
102: l_user_role Varchar2(200);
103: Begin
104: hr_utility.set_location(l_proc || ' Entering',10);
105: hr_utility.set_location(l_proc || ' Params - l_itemtype '|| l_itemtype,15);
106: hr_utility.set_location(l_proc || ' Params - l_process name '|| l_process_name,15);
107: select PQH_FR_WF_NOTIFICATION_S.NEXTVAL into l_itemkey from dual;
108: hr_utility.set_location(l_proc || ' Params - l_itemkey '|| l_itemkey,35);
109:

Line 106: hr_utility.set_location(l_proc || ' Params - l_process name '|| l_process_name,15);

102: l_user_role Varchar2(200);
103: Begin
104: hr_utility.set_location(l_proc || ' Entering',10);
105: hr_utility.set_location(l_proc || ' Params - l_itemtype '|| l_itemtype,15);
106: hr_utility.set_location(l_proc || ' Params - l_process name '|| l_process_name,15);
107: select PQH_FR_WF_NOTIFICATION_S.NEXTVAL into l_itemkey from dual;
108: hr_utility.set_location(l_proc || ' Params - l_itemkey '|| l_itemkey,35);
109:
110: wf_engine.createProcess( ItemType => l_itemtype,

Line 108: hr_utility.set_location(l_proc || ' Params - l_itemkey '|| l_itemkey,35);

104: hr_utility.set_location(l_proc || ' Entering',10);
105: hr_utility.set_location(l_proc || ' Params - l_itemtype '|| l_itemtype,15);
106: hr_utility.set_location(l_proc || ' Params - l_process name '|| l_process_name,15);
107: select PQH_FR_WF_NOTIFICATION_S.NEXTVAL into l_itemkey from dual;
108: hr_utility.set_location(l_proc || ' Params - l_itemkey '|| l_itemkey,35);
109:
110: wf_engine.createProcess( ItemType => l_itemtype,
111: ItemKey => l_ItemKey,
112: process => l_process_name );

Line 137: hr_utility.set_location(l_proc || 'User /Role Not Entered for PSV',40);

133: p_role_name => p_role_name,
134: p_role_id => p_role_id,
135: p_user_name => p_user_name);
136: IF l_user_role IS NULL THEN
137: hr_utility.set_location(l_proc || 'User /Role Not Entered for PSV',40);
138: RETURN;
139: END IF;
140: hr_utility.set_location(l_proc || 'User /Role '||l_user_role,40);
141: wf_engine.SetItemAttrText( itemtype => l_itemtype

Line 140: hr_utility.set_location(l_proc || 'User /Role '||l_user_role,40);

136: IF l_user_role IS NULL THEN
137: hr_utility.set_location(l_proc || 'User /Role Not Entered for PSV',40);
138: RETURN;
139: END IF;
140: hr_utility.set_location(l_proc || 'User /Role '||l_user_role,40);
141: wf_engine.SetItemAttrText( itemtype => l_itemtype
142: , itemkey => l_itemkey
143: , aname => 'PSV_USER_ROLE'
144: , avalue => l_user_role);

Line 312: hr_utility.set_location(l_proc || ' Start Process',15);

308: , aname => 'PARAMETER10_VALUE'
309: , avalue => p_param10_value);
310: end if;
311:
312: hr_utility.set_location(l_proc || ' Start Process',15);
313:
314: wf_engine.StartProcess ( ItemType => l_itemtype,
315: ItemKey => l_ItemKey );
316: hr_utility.set_location(l_proc || ' Exiting ',100);

Line 316: hr_utility.set_location(l_proc || ' Exiting ',100);

312: hr_utility.set_location(l_proc || ' Start Process',15);
313:
314: wf_engine.StartProcess ( ItemType => l_itemtype,
315: ItemKey => l_ItemKey );
316: hr_utility.set_location(l_proc || ' Exiting ',100);
317: End psv_ntf_api;
318:
319: PROCEDURE WHICH_MESSAGE (
320: itemtype in varchar2

Line 357: hr_utility.set_location(l_proc || ' Exiting with result '||result,100);

353: result := 'DEDUCTION_DEFINED';
354: ELSE
355: result := 'FR_PQH_PSV_NOTIFY';
356: END IF;
357: hr_utility.set_location(l_proc || ' Exiting with result '||result,100);
358: end which_message;
359: END PQH_FR_WF_NTF;