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.

[Home] [Help]

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 101: --hr_utility.trace_on (null, 'ORACLE');

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

502: 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;
503:
504: close getEmpToReassign;
505:
506: hr_utility.set_location ('Current manager choice id '||l_ws_mgr_per_in_ler_id,200);
507: hr_utility.set_location ('Proposed manager choice id '||l_prop_mgr_per_in_ler_id,200);
508:
509: open get_approval_cd(l_ws_mgr_per_in_ler_id,l_pl_id);
510: fetch get_approval_cd into l_approval_cd;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

1417: return 'Y';
1418: end if;
1419: end loop;
1420: end loop;
1421: hr_utility.set_location('Leaving '||l_package ,30);
1422: return 'N';
1423: end;
1424:
1425:

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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