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.BEN_CWB_RSGN_EMP dependencies on HR_UTILITY

Line 29: * hr_utility.set_location for fnd_message.get string, because

25: * 115.8 16 Dec 2002 hnarayan Added NOCOPY hint
26: * 115.9 24-Dec-2002 aupadhya Modified for CWB Itemization.
27: * 115.10 20-Feb-2003 aupadhya Modified For Bug#2786444.
28: * 115.11 24-Mar-2003 aupadhya Modified For Bug#2786444, commented
29: * hr_utility.set_location for fnd_message.get string, because
30: * it is erroring out for korean;
31: * ==========================================================================+
32: * 115.12 01-Mar-2004 aupadhya Global Budgeting Changes.
33: * 115.13 15-Mar-2004 aupadhya Added summary refresh call.

Line 102: --hr_utility.trace_on (null, 'ORACLE');

98:
99: BEGIN
100: /* Added modify logic from here */
101:
102: --hr_utility.trace_on (null, 'ORACLE');
103:
104: hr_utility.set_location('Entering '||l_package ,30);
105:
106: l_requestorId:=wf_engine.GetItemAttrNumber(itemtype => itemtype,

Line 104: hr_utility.set_location('Entering '||l_package ,30);

100: /* Added modify logic from here */
101:
102: --hr_utility.trace_on (null, 'ORACLE');
103:
104: hr_utility.set_location('Entering '||l_package ,30);
105:
106: l_requestorId:=wf_engine.GetItemAttrNumber(itemtype => itemtype,
107: itemkey => itemkey,
108: aname => 'REQUESTOR_ID');

Line 109: hr_utility.set_location('in Find approver : 2',20);

105:
106: l_requestorId:=wf_engine.GetItemAttrNumber(itemtype => itemtype,
107: itemkey => itemkey,
108: aname => 'REQUESTOR_ID');
109: hr_utility.set_location('in Find approver : 2',20);
110:
111: l_flag :=wf_engine.GetItemAttrNumber(itemtype => itemtype,
112: itemkey => itemkey,
113: aname => 'REQUESTOR_FLAG');

Line 116: hr_utility.set_location('flag '||l_flag ,90);

112: itemkey => itemkey,
113: aname => 'REQUESTOR_FLAG');
114:
115:
116: hr_utility.set_location('flag '||l_flag ,90);
117:
118: hr_utility.set_location('From workflow : ' || wf_engine.GetItemAttrNumber(itemtype => itemtype,
119: itemkey => itemkey,
120: aname => 'REQUESTOR_FLAG'),90);

Line 118: hr_utility.set_location('From workflow : ' || wf_engine.GetItemAttrNumber(itemtype => itemtype,

114:
115:
116: hr_utility.set_location('flag '||l_flag ,90);
117:
118: hr_utility.set_location('From workflow : ' || wf_engine.GetItemAttrNumber(itemtype => itemtype,
119: itemkey => itemkey,
120: aname => 'REQUESTOR_FLAG'),90);
121: -- if l_flag = 1 then
122:

Line 126: hr_utility.set_location('true condition ' ,100);

122:
123: if (wf_engine.GetItemAttrNumber(itemtype => itemtype,
124: itemkey => itemkey,
125: aname => 'REQUESTOR_FLAG')) = 1 then
126: hr_utility.set_location('true condition ' ,100);
127: result:='COMPLETE:' ||'NOT FOUND';
128: else
129:
130: ame_api.getNextApprover(applicationIdIn => 805,

Line 134: hr_utility.set_location('false condition ' ,100);

130: ame_api.getNextApprover(applicationIdIn => 805,
131: transactionIdIn => itemkey,
132: transactionTypeIn => 'PROPEMPRSGN',
133: nextApproverOut => c_next_approver_out);
134: hr_utility.set_location('false condition ' ,100);
135:
136: if(c_next_approver_out.person_id is not null) then
137: wf_engine.SetItemAttrNumber( itemtype => itemtype
138: , itemkey => itemkey

Line 144: hr_utility.set_location('appr is'||l_approver_user || ' , ' || c_next_approver_out.person_id || ' , ' ||l_approver_name,100);

140: , avalue => c_next_approver_out.person_id);
141: open get_curr_approver_name(c_next_approver_out.person_id);
142: fetch get_curr_approver_name into l_approver_user,l_approver_name , l_approver_last_name;
143: If get_curr_approver_name%found Then
144: hr_utility.set_location('appr is'||l_approver_user || ' , ' || c_next_approver_out.person_id || ' , ' ||l_approver_name,100);
145:
146: Else
147: hr_utility.set_location ('No Data Found'||l_approver_user || ' , ' || c_next_approver_out.person_id || ' , ' ||l_approver_name,100);
148:

Line 147: hr_utility.set_location ('No Data Found'||l_approver_user || ' , ' || c_next_approver_out.person_id || ' , ' ||l_approver_name,100);

143: If get_curr_approver_name%found Then
144: hr_utility.set_location('appr is'||l_approver_user || ' , ' || c_next_approver_out.person_id || ' , ' ||l_approver_name,100);
145:
146: Else
147: hr_utility.set_location ('No Data Found'||l_approver_user || ' , ' || c_next_approver_out.person_id || ' , ' ||l_approver_name,100);
148:
149: End If;
150: wf_engine.SetItemAttrText( itemtype => itemtype
151: , itemkey => itemkey

Line 154: hr_utility.set_location('Approver name is: '|| l_approver_name,200);

150: wf_engine.SetItemAttrText( itemtype => itemtype
151: , itemkey => itemkey
152: , aname => 'RECEIVER_USER_NAME'
153: , avalue => l_approver_user);
154: hr_utility.set_location('Approver name is: '|| l_approver_name,200);
155:
156:
157: update ben_transaction set attribute12= l_approver_name , attribute13= l_approver_last_name
158: where attribute2= itemkey

Line 175: hr_utility.set_location('Leaving '||l_package ,30);

171: end if;
172:
173:
174:
175: hr_utility.set_location('Leaving '||l_package ,30);
176: EXCEPTION
177: when others then
178: l_error:=sqlerrm;
179: hr_utility.set_location ('exception is'||l_error , 300);

Line 179: hr_utility.set_location ('exception is'||l_error , 300);

175: hr_utility.set_location('Leaving '||l_package ,30);
176: EXCEPTION
177: when others then
178: l_error:=sqlerrm;
179: hr_utility.set_location ('exception is'||l_error , 300);
180: Wf_Core.Context('BEN_CWB_RSGN_EMP' , 'check_approver',l_error);
181: raise;
182: END check_approver;
183:

Line 199: --hr_utility.trace_on (null, 'ORACLE');

195: l_approver_id number;
196: l_package varchar2(80) := g_package||'.store_approval_details';
197: l_error varchar2(5000);
198: begin
199: --hr_utility.trace_on (null, 'ORACLE');
200:
201: hr_utility.set_location('Entering '||l_package ,30);
202:
203: l_approver_id:= wf_engine.GetItemAttrNumber(itemtype => itemtype,

Line 201: hr_utility.set_location('Entering '||l_package ,30);

197: l_error varchar2(5000);
198: begin
199: --hr_utility.trace_on (null, 'ORACLE');
200:
201: hr_utility.set_location('Entering '||l_package ,30);
202:
203: l_approver_id:= wf_engine.GetItemAttrNumber(itemtype => itemtype,
204: itemkey => itemkey,
205: aname => 'RECEIVER_USER_ID');

Line 210: hr_utility.set_location('store approver details : Reveiver user id : '|| l_approver_id,10);

206: l_approver_user := wf_engine.GetItemAttrText(itemtype => itemtype,
207: itemkey => itemkey,
208: aname => 'RECEIVER_USER_NAME');
209:
210: hr_utility.set_location('store approver details : Reveiver user id : '|| l_approver_id,10);
211:
212: wf_engine.SetItemAttrText(itemtype => itemtype
213: , itemkey => itemkey
214: , aname => 'FROM_ROLE'

Line 249: hr_utility.set_location('Leaving '||l_package ,30);

245: approvalStatusIn => ame_util.approvedStatus,
246: approverPersonIdIn=> l_approver_id,
247: transactionTypeIn=> 'PROPEMPRSGN' );
248:
249: hr_utility.set_location('Leaving '||l_package ,30);
250: result:='COMPLETE:';
251:
252: EXCEPTION
253: when others then

Line 255: hr_utility.set_location ('exception is'||l_error , 300);

251:
252: EXCEPTION
253: when others then
254: l_error:=sqlerrm;
255: hr_utility.set_location ('exception is'||l_error , 300);
256: Wf_Core.Context('BEN_CWB_RSGN_EMP' , 'store_emp_details',l_error);
257: raise;
258:
259:

Line 275: hr_utility.set_location('Entering '||l_package ,30);

271: l_requestor varchar2(240);
272: l_package varchar2(80) := g_package||'.curr_ws_mgr_check';
273: l_error varchar2(5000);
274: begin
275: hr_utility.set_location('Entering '||l_package ,30);
276: l_curr_manager_name:= wf_engine.GetItemAttrText(itemtype => itemtype,
277: itemkey => itemkey,
278: aname => 'CURRENT_WS_MANAGER');
279: l_requestor:= wf_engine.GetItemAttrText(itemtype => itemtype,

Line 287: hr_utility.set_location('Leaving '||l_package ,30);

283: result:= 'COMPLETE:' ||'YES';
284: else
285: result:= 'COMPLETE:' ||'NO';
286: end if;
287: hr_utility.set_location('Leaving '||l_package ,30);
288: EXCEPTION
289: when others then
290: l_error:=sqlerrm;
291: hr_utility.set_location ('exception is'||l_error , 300);

Line 291: hr_utility.set_location ('exception is'||l_error , 300);

287: hr_utility.set_location('Leaving '||l_package ,30);
288: EXCEPTION
289: when others then
290: l_error:=sqlerrm;
291: hr_utility.set_location ('exception is'||l_error , 300);
292: Wf_Core.Context('BEN_CWB_RSGN_EMP' , 'curr_ws_mgr_check',l_error);
293: raise;
294:
295: end curr_ws_mgr_check;

Line 310: hr_utility.set_location('Entering '||l_package ,30);

306: l_requestor varchar2(240);
307: l_package varchar2(80) := g_package||'.prop_ws_mgr_check';
308: l_error varchar2(5000);
309: begin
310: hr_utility.set_location('Entering '||l_package ,30);
311: l_prop_manager_name:= wf_engine.GetItemAttrText(itemtype => itemtype,
312: itemkey => itemkey,
313: aname => 'PROPOSED_WS_MANAGER');
314: l_requestor:= wf_engine.GetItemAttrText(itemtype => itemtype,

Line 322: hr_utility.set_location('Leaving '||l_package ,30);

318: result:= 'COMPLETE:' ||'YES';
319: else
320: result:= 'COMPLETE:' ||'NO';
321: end if;
322: hr_utility.set_location('Leaving '||l_package ,30);
323: EXCEPTION
324: when others then
325: l_error:=sqlerrm;
326: hr_utility.set_location ('exception is'||l_error , 300);

Line 326: hr_utility.set_location ('exception is'||l_error , 300);

322: hr_utility.set_location('Leaving '||l_package ,30);
323: EXCEPTION
324: when others then
325: l_error:=sqlerrm;
326: hr_utility.set_location ('exception is'||l_error , 300);
327: --Wf_Core.Context('BEN_CWB_RSGN_EMP' , 'prop_ws_mgr_check',l_error);
328: raise;
329: end prop_ws_mgr_check;
330:

Line 344: hr_utility.set_location('Entering '||l_package ,30);

340: l_error_message varchar2(2000);
341: l_package varchar2(80) := g_package||'.which_message';
342: l_error varchar2(5000);
343: begin
344: hr_utility.set_location('Entering '||l_package ,30);
345: l_message_type:= wf_engine.GetItemAttrText(itemtype => itemtype,
346: itemkey => itemkey,
347: aname => 'MESSAGE_TYPE');
348: if( l_message_type='COMPLETED') then

Line 361: hr_utility.set_location('Leaving '||l_package ,30);

357:
358: end if;
359:
360: result:='COMPLETE:'||l_message_type;
361: hr_utility.set_location('Leaving '||l_package ,30);
362:
363: EXCEPTION
364: when others then
365: l_error:=sqlerrm;

Line 366: hr_utility.set_location ('exception is'||l_error , 300);

362:
363: EXCEPTION
364: when others then
365: l_error:=sqlerrm;
366: hr_utility.set_location ('exception is'||l_error , 300);
367: Wf_Core.Context('BEN_CWB_RSGN_EMP' , 'store_emp_details',l_error);
368: raise;
369: end which_message;
370:

Line 386: hr_utility.set_location('Entering '||l_package ,30);

382: l_approver_user varchar2(240);
383: l_package varchar2(80) := g_package||'.set_rejection';
384: l_error varchar2(5000);
385: begin
386: hr_utility.set_location('Entering '||l_package ,30);
387:
388: l_approver_user := wf_engine.GetItemAttrText(itemtype => itemtype,
389: itemkey => itemkey,
390: aname => 'RECEIVER_USER_NAME');

Line 428: hr_utility.set_location('Leaving '||l_package ,30);

424: , itemkey => itemkey
425: , aname => 'MESSAGE_TYPE'
426: , avalue => 'REJECTED');
427: result:='COMPLETE:';
428: hr_utility.set_location('Leaving '||l_package ,30);
429: EXCEPTION
430: when others then
431: l_error:=sqlerrm;
432:

Line 433: hr_utility.set_location ('exception is'||l_error , 300);

429: EXCEPTION
430: when others then
431: l_error:=sqlerrm;
432:
433: hr_utility.set_location ('exception is'||l_error , 300);
434:
435: Wf_Core.Context('BEN_CWB_RSGN_EMP' , 'set_rejection',l_error);
436: raise;
437: end set_rejection;

Line 493: --hr_utility.trace_on (null, 'ORACLE');

489: and group_oipl_id=-1;
490:
491: begin
492:
493: --hr_utility.trace_on (null, 'ORACLE');
494:
495: hr_utility.set_location('Entering '||l_package ,30);
496:
497: wf_engine.SetItemAttrText( itemtype => itemtype

Line 495: hr_utility.set_location('Entering '||l_package ,30);

491: begin
492:
493: --hr_utility.trace_on (null, 'ORACLE');
494:
495: hr_utility.set_location('Entering '||l_package ,30);
496:
497: wf_engine.SetItemAttrText( itemtype => itemtype
498: , itemkey => itemkey
499: , aname => 'MESSAGE_TYPE'

Line 507: hr_utility.set_location ('Current manager choice id '||l_ws_mgr_per_in_ler_id,200);

503: fetch getEmpToReassign into l_per_in_ler_id,l_ovr_id,l_ws_mgr_id,l_prop_mgr_per_in_ler_id ,l_ws_mgr_per_in_ler_id,l_curr_ws_mgr,l_prop_ws_mgr,l_pl_id , l_ws_mgr_id_old;
504:
505: close getEmpToReassign;
506:
507: hr_utility.set_location ('Current manager choice id '||l_ws_mgr_per_in_ler_id,200);
508: hr_utility.set_location ('Proposed manager choice id '||l_prop_mgr_per_in_ler_id,200);
509:
510: open get_approval_cd(l_ws_mgr_per_in_ler_id,l_pl_id);
511: fetch get_approval_cd into l_approval_cd;

Line 508: hr_utility.set_location ('Proposed manager choice id '||l_prop_mgr_per_in_ler_id,200);

504:
505: close getEmpToReassign;
506:
507: hr_utility.set_location ('Current manager choice id '||l_ws_mgr_per_in_ler_id,200);
508: hr_utility.set_location ('Proposed manager choice id '||l_prop_mgr_per_in_ler_id,200);
509:
510: open get_approval_cd(l_ws_mgr_per_in_ler_id,l_pl_id);
511: fetch get_approval_cd into l_approval_cd;
512: close get_approval_cd;

Line 515: hr_utility.set_location ('current manager status '||l_approval_cd,200);

511: fetch get_approval_cd into l_approval_cd;
512: close get_approval_cd;
513:
514:
515: hr_utility.set_location ('current manager status '||l_approval_cd,200);
516:
517: if ( ((l_approval_cd ='AP')or(l_approval_cd='PR'))) then
518: l_flag:=1;
519: hr_utility.set_location('Current manager processed ',200);

Line 519: hr_utility.set_location('Current manager processed ',200);

515: hr_utility.set_location ('current manager status '||l_approval_cd,200);
516:
517: if ( ((l_approval_cd ='AP')or(l_approval_cd='PR'))) then
518: l_flag:=1;
519: hr_utility.set_location('Current manager processed ',200);
520:
521: fnd_message.set_name('BEN','BEN_93118_CWB_RSGN_COMPLETED');
522: fnd_message.set_token('PERSON_NAME',l_curr_ws_mgr);
523: l_message:=fnd_message.get;

Line 534: hr_utility.set_location('Proposed manager status '||l_approval_cd,200);

530: fetch get_approval_cd into l_approval_cd;
531: close get_approval_cd;
532:
533:
534: hr_utility.set_location('Proposed manager status '||l_approval_cd,200);
535:
536: if (l_flag = 0 ) then
537:
538: if ( ((l_approval_cd ='AP')or(l_approval_cd ='PR'))) then

Line 540: hr_utility.set_location ('Proposed manager processed ',200);

536: if (l_flag = 0 ) then
537:
538: if ( ((l_approval_cd ='AP')or(l_approval_cd ='PR'))) then
539: l_flag:=1;
540: hr_utility.set_location ('Proposed manager processed ',200);
541: fnd_message.set_name('BEN','BEN_93118_CWB_RSGN_COMPLETED');
542: fnd_message.set_token('PERSON_NAME',l_prop_ws_mgr);
543: l_message:=fnd_message.get;
544: end if;

Line 551: hr_utility.set_location('set Approval',200);

547: if l_flag=0 then
548:
549: for i in getEmpToReassign loop
550:
551: hr_utility.set_location('set Approval',200);
552:
553:
554:
555: l_per_in_ler_id := i.attribute3;

Line 585: hr_utility.set_location ('Current manager for summary '||l_ws_mgr_per_in_ler_id,200);

581: BEN_MANAGE_CWB_LIFE_EVENTS.rebuild_heirarchy(p_group_per_in_ler_id => l_per_in_ler_id);
582:
583: ben_cwb_summary_pkg.delete_pl_sql_tab;
584:
585: hr_utility.set_location ('Current manager for summary '||l_ws_mgr_per_in_ler_id,200);
586: hr_utility.set_location ('Proposed manager for summary '||l_prop_mgr_per_in_ler_id,200);
587:
588:
589: BEN_CWB_SUMMARY_PKG.update_summary_on_reassignment

Line 586: hr_utility.set_location ('Proposed manager for summary '||l_prop_mgr_per_in_ler_id,200);

582:
583: ben_cwb_summary_pkg.delete_pl_sql_tab;
584:
585: hr_utility.set_location ('Current manager for summary '||l_ws_mgr_per_in_ler_id,200);
586: hr_utility.set_location ('Proposed manager for summary '||l_prop_mgr_per_in_ler_id,200);
587:
588:
589: BEN_CWB_SUMMARY_PKG.update_summary_on_reassignment
590: (p_old_mgr_per_in_ler_id => l_ws_mgr_per_in_ler_id

Line 626: hr_utility.set_location('Leaving '||l_package ,30);

622:
623:
624: end if;
625: result:='COMPLETE:';
626: hr_utility.set_location('Leaving '||l_package ,30);
627: EXCEPTION
628: when others then
629: hr_utility.set_location('Leaving '||sqlerrm ,30);
630: l_error:=fnd_message.get;

Line 629: hr_utility.set_location('Leaving '||sqlerrm ,30);

625: result:='COMPLETE:';
626: hr_utility.set_location('Leaving '||l_package ,30);
627: EXCEPTION
628: when others then
629: hr_utility.set_location('Leaving '||sqlerrm ,30);
630: l_error:=fnd_message.get;
631: wf_engine.SetItemAttrText( itemtype => itemtype
632: , itemkey => itemkey
633: , aname => 'MESSAGE_TYPE'

Line 744: hr_utility.set_location('Entering '||l_package ,30);

740: Begin
741:
742: --select BEN_CWB_WF_NTF_S.NEXTVAL into l_itemkey from dual;
743:
744: hr_utility.set_location('Entering '||l_package ,30);
745:
746: hr_utility.set_location ('Seeded Rsgn Process Name'||l_process_name ,55);
747:
748: hr_utility.set_location ('Profile :: '|| fnd_profile.value('BEN_CWB_EMP_RSGN_W_PROCESS') ,55);

Line 746: hr_utility.set_location ('Seeded Rsgn Process Name'||l_process_name ,55);

742: --select BEN_CWB_WF_NTF_S.NEXTVAL into l_itemkey from dual;
743:
744: hr_utility.set_location('Entering '||l_package ,30);
745:
746: hr_utility.set_location ('Seeded Rsgn Process Name'||l_process_name ,55);
747:
748: hr_utility.set_location ('Profile :: '|| fnd_profile.value('BEN_CWB_EMP_RSGN_W_PROCESS') ,55);
749:
750: l_process_name := nvl(fnd_profile.value('BEN_CWB_EMP_RSGN_W_PROCESS'),'RSGNP');

Line 748: hr_utility.set_location ('Profile :: '|| fnd_profile.value('BEN_CWB_EMP_RSGN_W_PROCESS') ,55);

744: hr_utility.set_location('Entering '||l_package ,30);
745:
746: hr_utility.set_location ('Seeded Rsgn Process Name'||l_process_name ,55);
747:
748: hr_utility.set_location ('Profile :: '|| fnd_profile.value('BEN_CWB_EMP_RSGN_W_PROCESS') ,55);
749:
750: l_process_name := nvl(fnd_profile.value('BEN_CWB_EMP_RSGN_W_PROCESS'),'RSGNP');
751:
752: hr_utility.set_location ('Rsgn Process Name After reading profile'||l_process_name ,55);

Line 752: hr_utility.set_location ('Rsgn Process Name After reading profile'||l_process_name ,55);

748: hr_utility.set_location ('Profile :: '|| fnd_profile.value('BEN_CWB_EMP_RSGN_W_PROCESS') ,55);
749:
750: l_process_name := nvl(fnd_profile.value('BEN_CWB_EMP_RSGN_W_PROCESS'),'RSGNP');
751:
752: hr_utility.set_location ('Rsgn Process Name After reading profile'||l_process_name ,55);
753:
754: wf_engine.createProcess( ItemType => l_itemtype,
755: ItemKey => l_itemkey,
756: process => l_process_name );

Line 851: hr_utility.TRACE ('l_for_period ' || l_for_period);

847: -- No longer is use
848:
849:
850: l_for_period := get_for_period (p_prop_ws_mgr_per_in_ler_id);
851: hr_utility.TRACE ('l_for_period ' || l_for_period);
852:
853: wf_engine.setitemattrtext (itemtype => 'BENCWBFY',
854: itemkey => l_itemkey,
855: aname => 'FOR_PERIOD',

Line 862: -- hr_utility.trace_on (null,'ORACLE');

858:
859: /*wf_engine.StartProcess ( ItemType => l_itemtype,
860: ItemKey => l_itemkey ); */
861:
862: -- hr_utility.trace_on (null,'ORACLE');
863:
864:
865:
866: -- Insert Approval information record , to fetch approver list in AME

Line 918: hr_utility.set_location('in Find approver : 3.....',30);

914: -- Approver change logic
915:
916:
917:
918: hr_utility.set_location('in Find approver : 3.....',30);
919:
920: -- To check whetehr requestor comes up in hrchy of proposed manager then
921: -- approver chain won't start from propsed manager but +1 'l_flag=1'
922: -- Start

Line 931: hr_utility.set_location(l_person_id , 50);

927: exit when approver_hrchy%NOTFOUND; -- bug: 7159487
928:
929: l_recCount:=l_recCount+1; -- bug: 7159487
930:
931: hr_utility.set_location(l_person_id , 50);
932: if(l_person_id = p_requestor_id ) then
933: l_flag:=1;
934: exit;
935: end if;

Line 946: hr_utility.set_location('after looping'||l_itemkey,300);

942: l_requestor_flag:=1;
943: end if;
944:
945:
946: hr_utility.set_location('after looping'||l_itemkey,300);
947:
948: if l_flag=1 then
949:
950: open get_manager_id_from_pil(l_requestor_per_in_ler_id);

Line 961: hr_utility.set_location('flag'||l_requestor_flag,300);

957: if l_requestor_person_id is null then
958: l_requestor_flag:=1;
959:
960: end if;
961: hr_utility.set_location('flag'||l_requestor_flag,300);
962: close get_manager_id_from_pil;
963:
964:
965: if l_requestor_flag <> 1 then

Line 980: hr_utility.set_location('Requestor and proposed ws manager same .....',30);

976: -- Check if current and proposed worksheet manager both are same.
977: -- Start
978: if p_requestor_id=p_prop_ws_manager_id then
979:
980: hr_utility.set_location('Requestor and proposed ws manager same .....',30);
981:
982: --open get_popl_id_requestor(p_prop_ws_mgr_per_in_ler_id);
983: --fetch get_popl_id_requestor into l_requestor_popl_id;
984: --close get_popl_id_requestor;

Line 1000: hr_utility.set_location('flag'||l_requestor_flag,300);

996: if l_requestor_person_id is null then
997: l_requestor_flag:=1;
998:
999: end if;
1000: hr_utility.set_location('flag'||l_requestor_flag,300);
1001: close get_manager_id_from_pil;
1002:
1003: if l_requestor_flag <> 1 then
1004: update ben_transaction set attribute2=l_requestor_person_id

Line 1023: hr_utility.set_location('Leaving '||l_package ,30);

1019:
1020: wf_engine.StartProcess ( ItemType => l_itemtype,
1021: ItemKey => l_itemkey );
1022:
1023: hr_utility.set_location('Leaving '||l_package ,30);
1024:
1025: EXCEPTION
1026: when others then
1027: l_error:=sqlerrm;

Line 1029: hr_utility.set_location ('exception is'||l_error , 300);

1025: EXCEPTION
1026: when others then
1027: l_error:=sqlerrm;
1028:
1029: hr_utility.set_location ('exception is'||l_error , 300);
1030:
1031: Wf_Core.Context('BEN_CWB_RSGN_EMP', 'start_workflow',l_error);
1032: raise;
1033:

Line 1088: hr_utility.set_location('Entering '||l_package ,30);

1084: l_transaction_id number;
1085:
1086: Begin
1087: /*select BEN_CWB_WF_NTF_S.NEXTVAL into l_itemkey from dual;*/
1088: hr_utility.set_location('Entering '||l_package ,30);
1089: wf_engine.createProcess( ItemType => l_itemtype,
1090: ItemKey => l_itemkey,
1091:
1092: process => l_process_name );

Line 1171: hr_utility.TRACE ('l_for_period ' || l_for_period);

1167: -- No longer is use
1168:
1169:
1170: l_for_period := get_for_period (p_prop_mgr_per_in_ler_id);
1171: hr_utility.TRACE ('l_for_period ' || l_for_period);
1172:
1173: wf_engine.setItemattrText (itemtype => l_itemtype,
1174: itemkey => l_itemkey ,
1175: aname => 'FOR_PERIOD',

Line 1221: hr_utility.set_location('Leaving '||l_package ,30);

1217: wf_engine.StartProcess ( ItemType => l_itemtype,
1218: ItemKey => l_itemkey );
1219:
1220:
1221: hr_utility.set_location('Leaving '||l_package ,30);
1222:
1223: EXCEPTION
1224: when others then
1225: l_error:=sqlerrm;

Line 1227: hr_utility.set_location ('exception is'||l_error , 300);

1223: EXCEPTION
1224: when others then
1225: l_error:=sqlerrm;
1226:
1227: hr_utility.set_location ('exception is'||l_error , 300);
1228:
1229: Wf_Core.Context('BEN_CWB_RSGN_EMP' , 'send_fyi_notifications',l_error);
1230: raise;
1231: end send_fyi_notifications;

Line 1279: --hr_utility.trace_on (null, 'ORACLE');

1275: and trunc(sysdate) between ppf.effective_start_date and ppf.effective_end_date;
1276:
1277:
1278: begin
1279: --hr_utility.trace_on (null, 'ORACLE');
1280: hr_utility.set_location('Entering '||l_package ,30);
1281:
1282: l_emp_first_name := substr(p_emp_name,0, instr(p_emp_name,' ')-1);
1283: l_emp_last_name := substr(p_emp_name, instr(p_emp_name,' ')+1);

Line 1280: hr_utility.set_location('Entering '||l_package ,30);

1276:
1277:
1278: begin
1279: --hr_utility.trace_on (null, 'ORACLE');
1280: hr_utility.set_location('Entering '||l_package ,30);
1281:
1282: l_emp_first_name := substr(p_emp_name,0, instr(p_emp_name,' ')-1);
1283: l_emp_last_name := substr(p_emp_name, instr(p_emp_name,' ')+1);
1284:

Line 1344: hr_utility.set_location('Leaving '||l_package ,30);

1340: p_group_pl_id,
1341: p_business_group
1342: );
1343:
1344: hr_utility.set_location('Leaving '||l_package ,30);
1345:
1346: EXCEPTION
1347: when others then
1348: l_error:=sqlerrm;

Line 1350: hr_utility.set_location ('exception is'||l_error , 300);

1346: EXCEPTION
1347: when others then
1348: l_error:=sqlerrm;
1349:
1350: hr_utility.set_location ('exception is'||l_error , 300);
1351:
1352: Wf_Core.Context('BEN_CWB_RSGN_EMP' , 'store_emp_details',l_error);
1353: raise;
1354:

Line 1372: hr_utility.set_location('Entering '||l_package ,30);

1368: l_package varchar2(80) := g_package||'.remove_emp_details';
1369: l_error varchar2(5000);
1370: begin
1371:
1372: hr_utility.set_location('Entering '||l_package ,30);
1373: update ben_transaction set status='DEL'
1374: where attribute1= 'EMP'
1375: and transaction_type='CWBEMPRSGN'
1376: and attribute2=to_number(itemkey);

Line 1379: hr_utility.set_location('Leaving '||l_package ,30);

1375: and transaction_type='CWBEMPRSGN'
1376: and attribute2=to_number(itemkey);
1377:
1378: result:='COMPLETE:';
1379: hr_utility.set_location('Leaving '||l_package ,30);
1380:
1381: EXCEPTION
1382: when others then
1383: l_error:=sqlerrm;

Line 1385: hr_utility.set_location ('exception is'||l_error , 300);

1381: EXCEPTION
1382: when others then
1383: l_error:=sqlerrm;
1384:
1385: hr_utility.set_location ('exception is'||l_error , 300);
1386:
1387: Wf_Core.Context('BEN_CWB_RSGN_EMP' , 'remove_emp_details',l_error);
1388: raise;
1389: end remove_emp_details;

Line 1414: hr_utility.set_location('Entering '||l_package ,30);

1410:
1411: l_package varchar2(80) := g_package||'.is_in_comp_manager_role';
1412:
1413: begin
1414: hr_utility.set_location('Entering '||l_package ,30);
1415: for i in c2
1416: loop
1417: for j in c1(i.role_id)
1418: loop

Line 1424: hr_utility.set_location('Leaving '||l_package ,30);

1420: return 'Y';
1421: --end if;
1422: end loop;
1423: end loop;
1424: hr_utility.set_location('Leaving '||l_package ,30);
1425: return 'N';
1426: end;
1427:
1428:

Line 1439: hr_utility.set_location('Entering '||l_package ,30);

1435: )
1436: IS
1437: l_package varchar2(80) := g_package||'.generate_detail_html';
1438: BEGIN
1439: hr_utility.set_location('Entering '||l_package ,30);
1440: -- No longer is use
1441: hr_utility.set_location('Leaving '||l_package ,30);
1442: END;
1443:

Line 1441: hr_utility.set_location('Leaving '||l_package ,30);

1437: l_package varchar2(80) := g_package||'.generate_detail_html';
1438: BEGIN
1439: hr_utility.set_location('Entering '||l_package ,30);
1440: -- No longer is use
1441: hr_utility.set_location('Leaving '||l_package ,30);
1442: END;
1443:
1444: PROCEDURE generate_employee_table_html
1445: (

Line 1454: hr_utility.set_location('Entering '||l_package ,30);

1450: )
1451: IS
1452: l_package varchar2(80) := g_package||'.generate_employee_table_html';
1453: BEGIN
1454: hr_utility.set_location('Entering '||l_package ,30);
1455: -- No longer is use
1456: hr_utility.set_location('Leaving '||l_package ,30);
1457: END;
1458:

Line 1456: hr_utility.set_location('Leaving '||l_package ,30);

1452: l_package varchar2(80) := g_package||'.generate_employee_table_html';
1453: BEGIN
1454: hr_utility.set_location('Entering '||l_package ,30);
1455: -- No longer is use
1456: hr_utility.set_location('Leaving '||l_package ,30);
1457: END;
1458:
1459: /*
1460: generate_approver_table_html

Line 1473: hr_utility.set_location('Entering '||l_package ,30);

1469: )
1470: IS
1471: l_package varchar2(80) := g_package||'.generate_approver_table_html';
1472: BEGIN
1473: hr_utility.set_location('Entering '||l_package ,30);
1474: -- No longer is use
1475: hr_utility.set_location('Leaving '||l_package ,30);
1476: END;
1477:

Line 1475: hr_utility.set_location('Leaving '||l_package ,30);

1471: l_package varchar2(80) := g_package||'.generate_approver_table_html';
1472: BEGIN
1473: hr_utility.set_location('Entering '||l_package ,30);
1474: -- No longer is use
1475: hr_utility.set_location('Leaving '||l_package ,30);
1476: END;
1477:
1478: PROCEDURE generate_error_html
1479: (

Line 1488: hr_utility.set_location('Entering '||l_package ,30);

1484: )
1485: IS
1486: l_package varchar2(80) := g_package||'.generate_error_html';
1487: BEGIN
1488: hr_utility.set_location('Entering '||l_package ,30);
1489: -- No longer is use
1490: hr_utility.set_location('Leaving '||l_package ,30);
1491: END;
1492:

Line 1490: hr_utility.set_location('Leaving '||l_package ,30);

1486: l_package varchar2(80) := g_package||'.generate_error_html';
1487: BEGIN
1488: hr_utility.set_location('Entering '||l_package ,30);
1489: -- No longer is use
1490: hr_utility.set_location('Leaving '||l_package ,30);
1491: END;
1492:
1493: END BEN_CWB_RSGN_EMP;