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

Line 7: g_debug boolean := hr_utility.debug_enabled;

3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := ' PER_CHECKLIST_EVENTS.';
7: g_debug boolean := hr_utility.debug_enabled;
8:
9:
10: procedure check_approvers_exist
11: (itemtype in varchar2,

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

26: --
27: begin
28:
29: l_proc := g_package||'check_process';
30: hr_utility.set_location('Entering:'|| l_proc, 10);
31: hr_utility.set_location(l_proc,1);
32:
33: l_taskin_cklid := wf_engine.GetItemAttrNumber(
34: itemtype => itemtype

Line 31: hr_utility.set_location(l_proc,1);

27: begin
28:
29: l_proc := g_package||'check_process';
30: hr_utility.set_location('Entering:'|| l_proc, 10);
31: hr_utility.set_location(l_proc,1);
32:
33: l_taskin_cklid := wf_engine.GetItemAttrNumber(
34: itemtype => itemtype
35: ,itemkey => itemkey

Line 68: hr_utility.set_location('retvalue:'|| resultout, 20);

64: else
65: resultout:='COMPLETE:Y';
66: end if;
67:
68: hr_utility.set_location('retvalue:'|| resultout, 20);
69: hr_utility.set_location('Leaving:'|| l_proc, 10);
70:
71: end;
72:

Line 69: hr_utility.set_location('Leaving:'|| l_proc, 10);

65: resultout:='COMPLETE:Y';
66: end if;
67:
68: hr_utility.set_location('retvalue:'|| resultout, 20);
69: hr_utility.set_location('Leaving:'|| l_proc, 10);
70:
71: end;
72:
73:

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

184: wfn.notification_id=wfna.notification_id and context like cur_p_context and responder is not null and name ='RESULT';
185:
186: begin
187: l_proc := g_package||'PROCESS_VOTING';
188: hr_utility.set_location('Entering:'|| l_proc, 10);
189: hr_utility.set_location(l_proc,1);
190:
191: if(funcmode='RUN') then
192: open cur_check_wf_status(itemtype||':'|| itemkey ||':%');

Line 189: hr_utility.set_location(l_proc,1);

185:
186: begin
187: l_proc := g_package||'PROCESS_VOTING';
188: hr_utility.set_location('Entering:'|| l_proc, 10);
189: hr_utility.set_location(l_proc,1);
190:
191: if(funcmode='RUN') then
192: open cur_check_wf_status(itemtype||':'|| itemkey ||':%');
193: fetch cur_check_wf_status into l_status,l_responder;

Line 211: hr_utility.set_location('result:'|| resultout, 20);

207: close cur_check_wf_status;
208: else
209: resultout:=null;
210: end if;
211: hr_utility.set_location('result:'|| resultout, 20);
212: hr_utility.set_location('Leaving:'|| l_proc, 10);
213: end;
214:
215: --

Line 212: hr_utility.set_location('Leaving:'|| l_proc, 10);

208: else
209: resultout:=null;
210: end if;
211: hr_utility.set_location('result:'|| resultout, 20);
212: hr_utility.set_location('Leaving:'|| l_proc, 10);
213: end;
214:
215: --
216: -- ------------------------------------------------------------------------

Line 243: g_debug := hr_utility.debug_enabled;

239: --
240: --
241: begin
242: --
243: g_debug := hr_utility.debug_enabled;
244: if g_debug then
245: l_proc := g_package||'create_event';
246: hr_utility.set_location('Entering:'|| l_proc, 10);
247: end if;

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

242: --
243: g_debug := hr_utility.debug_enabled;
244: if g_debug then
245: l_proc := g_package||'create_event';
246: hr_utility.set_location('Entering:'|| l_proc, 10);
247: end if;
248: --
249: open event_exists;
250: fetch event_exists into l_exists;

Line 253: hr_utility.set_location('Entering '||l_proc,20);

249: open event_exists;
250: fetch event_exists into l_exists;
251: if event_exists%notfound then
252: if g_debug then
253: hr_utility.set_location('Entering '||l_proc,20);
254: end if;
255: insert into per_ben_identified_events(
256: ben_identified_event_id,
257: event_reason_id,

Line 274: hr_utility.set_location('Leaving '||l_proc,30);

270: 1);
271: end if;
272: close event_exists;
273: if g_debug then
274: hr_utility.set_location('Leaving '||l_proc,30);
275: end if;
276: End create_event;
277: --
278:

Line 378: g_debug := hr_utility.debug_enabled;

374: --
375: begin
376: --
377: --
378: g_debug := hr_utility.debug_enabled;
379: if g_debug then
380: l_proc := g_package||'create_event';
381: hr_utility.set_location('Entering:'|| l_proc, 10);
382: hr_utility.set_location('person_id '||to_char(p_person_id),10);

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

377: --
378: g_debug := hr_utility.debug_enabled;
379: if g_debug then
380: l_proc := g_package||'create_event';
381: hr_utility.set_location('Entering:'|| l_proc, 10);
382: hr_utility.set_location('person_id '||to_char(p_person_id),10);
383: hr_utility.set_location('asg id '||to_char(p_assignment_id),10);
384: hr_utility.set_location('event reason '||to_char(p_ler_event_id),10);
385: end if;

Line 382: hr_utility.set_location('person_id '||to_char(p_person_id),10);

378: g_debug := hr_utility.debug_enabled;
379: if g_debug then
380: l_proc := g_package||'create_event';
381: hr_utility.set_location('Entering:'|| l_proc, 10);
382: hr_utility.set_location('person_id '||to_char(p_person_id),10);
383: hr_utility.set_location('asg id '||to_char(p_assignment_id),10);
384: hr_utility.set_location('event reason '||to_char(p_ler_event_id),10);
385: end if;
386: --

Line 383: hr_utility.set_location('asg id '||to_char(p_assignment_id),10);

379: if g_debug then
380: l_proc := g_package||'create_event';
381: hr_utility.set_location('Entering:'|| l_proc, 10);
382: hr_utility.set_location('person_id '||to_char(p_person_id),10);
383: hr_utility.set_location('asg id '||to_char(p_assignment_id),10);
384: hr_utility.set_location('event reason '||to_char(p_ler_event_id),10);
385: end if;
386: --
387: --loop throught the number of records fetched which are pending to process.

Line 384: hr_utility.set_location('event reason '||to_char(p_ler_event_id),10);

380: l_proc := g_package||'create_event';
381: hr_utility.set_location('Entering:'|| l_proc, 10);
382: hr_utility.set_location('person_id '||to_char(p_person_id),10);
383: hr_utility.set_location('asg id '||to_char(p_assignment_id),10);
384: hr_utility.set_location('event reason '||to_char(p_ler_event_id),10);
385: end if;
386: --
387: --loop throught the number of records fetched which are pending to process.
388: --

Line 392: hr_utility.set_location('In the first loop',20);

388: --
389:
390: for x_cur in c1(p_ler_event_id) loop
391: if g_debug then
392: hr_utility.set_location('In the first loop',20);
393: end if;
394:
395: --
396: -- if not a concurrent request ben code BEN_PER_ASG_ELIG

Line 418: hr_utility.set_location('In the first loop',30);

414: x_cur.business_group_id,
415: false)
416: then
417: if g_debug then
418: hr_utility.set_location('In the first loop',30);
419: end if;
420: --
421: open chk_exists(p_person_id,x_cur.task_in_checklist_id);
422: fetch chk_exists into l_dummy;

Line 425: hr_utility.set_location('In the first loop',40);

421: open chk_exists(p_person_id,x_cur.task_in_checklist_id);
422: fetch chk_exists into l_dummy;
423: if chk_exists%notfound then
424: if g_debug then
425: hr_utility.set_location('In the first loop',40);
426: end if;
427: --
428: if nvl(x_cur.checklist_id,-1) <> nvl(current_checklist_id,-1) then
429: --

Line 431: hr_utility.set_location('In the first loop',50);

427: --
428: if nvl(x_cur.checklist_id,-1) <> nvl(current_checklist_id,-1) then
429: --
430: if g_debug then
431: hr_utility.set_location('In the first loop',50);
432: end if;
433: --
434: open alloc_ckl_exists (p_person_id,p_assignment_id,x_cur.checklist_id);
435: fetch alloc_ckl_exists into current_alloc_ckl_id;

Line 457: hr_utility.set_location('In the first loop',80);

453: end if;
454: close alloc_ckl_exists;
455: --
456: if g_debug then
457: hr_utility.set_location('In the first loop',80);
458: end if;
459: --
460: end if;
461: if g_debug then

Line 462: hr_utility.set_location('In the first loop',90);

458: end if;
459: --
460: end if;
461: if g_debug then
462: hr_utility.set_location('In the first loop',90);
463: end if;
464: --
465: -- ---------------------------------------------------------
466: -- ---------------------------------------------------------

Line 480: hr_utility.set_location('before approver'||l_proc,75);

476: begin
477: if x_cur.ame_attribute_identifier is not null then
478:
479: if g_debug then
480: hr_utility.set_location('before approver'||l_proc,75);
481: end if;
482: --
483: -- Get All approvers
484: --

Line 494: hr_utility.set_location('after approver'||l_proc,76);

490: TRANSACTIONIDIN => l_transaction_id, -- 8861932
491: approvalProcessCompleteYNout => process_complete,
492: APPROVERSOUT => ALL_APPROVERS);
493: if g_debug then
494: hr_utility.set_location('after approver'||l_proc,76);
495: end if;
496:
497: if all_approvers.count > 0 then
498: i := 1; -- approver_count

Line 523: hr_utility.set_location('Before target date'||l_proc,200);

519: -- ==============================================================================
520:
521: begin
522: if g_debug then
523: hr_utility.set_location('Before target date'||l_proc,200);
524: end if;
525:
526: --
527: -- Calculate target end date

Line 553: hr_utility.set_location('After Target Date'||l_proc,210);

549: l_orig_system := 'PER';
550: END IF;
551: --
552: if g_debug then
553: hr_utility.set_location('After Target Date'||l_proc,210);
554: hr_utility.set_location('Target date '||to_char(l_target_end_date),210);
555: hr_utility.set_location('alloc_task_id '||to_char(l_allocated_task_id),210);
556: end if;
557: --

Line 554: hr_utility.set_location('Target date '||to_char(l_target_end_date),210);

550: END IF;
551: --
552: if g_debug then
553: hr_utility.set_location('After Target Date'||l_proc,210);
554: hr_utility.set_location('Target date '||to_char(l_target_end_date),210);
555: hr_utility.set_location('alloc_task_id '||to_char(l_allocated_task_id),210);
556: end if;
557: --
558: PER_ALLOCATED_TASK_API.CREATE_ALLOC_TASK

Line 555: hr_utility.set_location('alloc_task_id '||to_char(l_allocated_task_id),210);

551: --
552: if g_debug then
553: hr_utility.set_location('After Target Date'||l_proc,210);
554: hr_utility.set_location('Target date '||to_char(l_target_end_date),210);
555: hr_utility.set_location('alloc_task_id '||to_char(l_allocated_task_id),210);
556: end if;
557: --
558: PER_ALLOCATED_TASK_API.CREATE_ALLOC_TASK
559: ( p_validate => false

Line 577: hr_utility.set_location('In the first loop',110);

573: ,p_allocated_task_id => l_allocated_task_id
574: ,p_object_version_number => l_alloc_task_ovn
575: );
576: -- TASK_STATUS ......!!!!!
577: hr_utility.set_location('In the first loop',110);
578: end;
579: --
580: hr_utility.set_location('after insert',70);
581: --

Line 580: hr_utility.set_location('after insert',70);

576: -- TASK_STATUS ......!!!!!
577: hr_utility.set_location('In the first loop',110);
578: end;
579: --
580: hr_utility.set_location('after insert',70);
581: --
582: -- ==============================================================================
583: -- ===============Begin of start workflow if eligible ===========================
584: -- ==============================================================================

Line 590: hr_utility.set_location('Before wkflow'||l_proc,80);

586: -- call workflow only if an approver is found.
587: --
588: if l_approver_name is not null then
589: if g_debug then
590: hr_utility.set_location('Before wkflow'||l_proc,80);
591: hr_utility.set_location('approver_order num '||to_char(l_approver_order_number),999);
592: end if;
593: --
594: begin

Line 591: hr_utility.set_location('approver_order num '||to_char(l_approver_order_number),999);

587: --
588: if l_approver_name is not null then
589: if g_debug then
590: hr_utility.set_location('Before wkflow'||l_proc,80);
591: hr_utility.set_location('approver_order num '||to_char(l_approver_order_number),999);
592: end if;
593: --
594: begin
595: --

Line 614: hr_utility.set_location('After wkflow'||l_proc,80);

610: );
611:
612: --
613: if g_debug then
614: hr_utility.set_location('After wkflow'||l_proc,80);
615: end if;
616: --
617: end;
618: --

Line 635: hr_utility.set_location('In the first loop',120);

631: -- ========================= End of Workflow ====================================
632: -- ==============================================================================
633: end if; -- chk_exists
634: close chk_exists;
635: hr_utility.set_location('In the first loop',120);
636: --
637: end if; -- BEN Eligibility engine fetches an eligible object
638: --
639: hr_utility.set_location('In the first loop',130);

Line 639: hr_utility.set_location('In the first loop',130);

635: hr_utility.set_location('In the first loop',120);
636: --
637: end if; -- BEN Eligibility engine fetches an eligible object
638: --
639: hr_utility.set_location('In the first loop',130);
640: end loop;
641: --
642:
643: hr_utility.set_location('In the first loop',140);

Line 643: hr_utility.set_location('In the first loop',140);

639: hr_utility.set_location('In the first loop',130);
640: end loop;
641: --
642:
643: hr_utility.set_location('In the first loop',140);
644:
645: exception
646: when others then
647: --

Line 681: g_debug := hr_utility.debug_enabled;

677: begin
678: --
679: fnd_file.put_line(FND_FILE.LOG, ' Allocate Tasks Process Started');
680: --
681: g_debug := hr_utility.debug_enabled;
682: if g_debug then
683: l_proc := g_package||'Allocate_Tasks';
684: hr_utility.set_location('Entering:'|| l_proc, 10);
685: hr_utility.set_location('Before process call',1);

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

680: --
681: g_debug := hr_utility.debug_enabled;
682: if g_debug then
683: l_proc := g_package||'Allocate_Tasks';
684: hr_utility.set_location('Entering:'|| l_proc, 10);
685: hr_utility.set_location('Before process call',1);
686: end if;
687: --
688: FOR p_cur in pending_events loop

Line 685: hr_utility.set_location('Before process call',1);

681: g_debug := hr_utility.debug_enabled;
682: if g_debug then
683: l_proc := g_package||'Allocate_Tasks';
684: hr_utility.set_location('Entering:'|| l_proc, 10);
685: hr_utility.set_location('Before process call',1);
686: end if;
687: --
688: FOR p_cur in pending_events loop
689: if nvl(p_cur.assignment_id,-1) <> -1 then

Line 697: hr_utility.set_location(l_proc||'after process event call',2);

693: ,p_date => p_cur.effective_date
694: ,p_ler_event_id => p_cur.event_reason_id
695: );
696: if g_debug then
697: hr_utility.set_location(l_proc||'after process event call',2);
698: end if;
699: else
700: if g_debug then
701: hr_utility.set_location(l_proc||'Before Procecss with ASG',3);

Line 701: hr_utility.set_location(l_proc||'Before Procecss with ASG',3);

697: hr_utility.set_location(l_proc||'after process event call',2);
698: end if;
699: else
700: if g_debug then
701: hr_utility.set_location(l_proc||'Before Procecss with ASG',3);
702: end if;
703: --
704: per_checklist_events.process_event
705: ( p_person_id => p_cur.person_id

Line 712: hr_utility.set_location(l_proc||'After Procecss Call',4);

708: ,p_ler_event_id => p_cur.event_reason_id
709: );
710: end if;
711: if g_debug then
712: hr_utility.set_location(l_proc||'After Procecss Call',4);
713: end if;
714: --
715: -- Update the status from PENDING to Processed
716: --

Line 770: g_debug := hr_utility.debug_enabled;

766: --
767: begin
768: --
769: --
770: g_debug := hr_utility.debug_enabled;
771: if g_debug then
772: l_proc := g_package||'Allocate_person_tasks';
773: hr_utility.set_location('Entering:'|| l_proc, 10);
774: hr_utility.set_location('Before process call',1);

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

769: --
770: g_debug := hr_utility.debug_enabled;
771: if g_debug then
772: l_proc := g_package||'Allocate_person_tasks';
773: hr_utility.set_location('Entering:'|| l_proc, 10);
774: hr_utility.set_location('Before process call',1);
775: end if;
776: --
777: FOR p_cur in pending_events loop

Line 774: hr_utility.set_location('Before process call',1);

770: g_debug := hr_utility.debug_enabled;
771: if g_debug then
772: l_proc := g_package||'Allocate_person_tasks';
773: hr_utility.set_location('Entering:'|| l_proc, 10);
774: hr_utility.set_location('Before process call',1);
775: end if;
776: --
777: FOR p_cur in pending_events loop
778: if nvl(p_cur.assignment_id,-1) <> -1 then

Line 785: hr_utility.set_location('after process call',2);

781: ,p_assignment_id => p_cur.assignment_id
782: ,p_date => p_cur.effective_date
783: ,p_ler_event_id => p_cur.event_reason_id
784: );
785: hr_utility.set_location('after process call',2);
786: else
787: hr_utility.set_location('after process call',3);
788: per_checklist_events.process_event
789: ( p_person_id => p_cur.person_id

Line 787: hr_utility.set_location('after process call',3);

783: ,p_ler_event_id => p_cur.event_reason_id
784: );
785: hr_utility.set_location('after process call',2);
786: else
787: hr_utility.set_location('after process call',3);
788: per_checklist_events.process_event
789: ( p_person_id => p_cur.person_id
790: ,p_assignment_id => null
791: ,p_date => p_cur.effective_date

Line 795: hr_utility.set_location('after process call',4);

791: ,p_date => p_cur.effective_date
792: ,p_ler_event_id => p_cur.event_reason_id
793: );
794: end if;
795: hr_utility.set_location('after process call',4);
796: --
797: -- Update the status from PENDING to Processed
798: --
799: UPDATE per_ben_identified_events

Line 808: hr_utility.set_location('Leaving:'|| l_proc, 100);

804: --
805:
806: commit;
807: if g_debug then
808: hr_utility.set_location('Leaving:'|| l_proc, 100);
809: end if;
810: --
811: exception
812: when others then

Line 888: g_debug := hr_utility.debug_enabled;

884: l_performer_name varchar2(3000);
885:
886: begin
887: --
888: g_debug := hr_utility.debug_enabled;
889: if g_debug then
890: l_proc := g_package||'Start_WF_Process';
891: hr_utility.set_location('Entering:'|| l_proc, 10);
892: hr_utility.set_location('Before process call',1);

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

887: --
888: g_debug := hr_utility.debug_enabled;
889: if g_debug then
890: l_proc := g_package||'Start_WF_Process';
891: hr_utility.set_location('Entering:'|| l_proc, 10);
892: hr_utility.set_location('Before process call',1);
893: end if;
894: --
895: OPEN csr_person_name;

Line 892: hr_utility.set_location('Before process call',1);

888: g_debug := hr_utility.debug_enabled;
889: if g_debug then
890: l_proc := g_package||'Start_WF_Process';
891: hr_utility.set_location('Entering:'|| l_proc, 10);
892: hr_utility.set_location('Before process call',1);
893: end if;
894: --
895: OPEN csr_person_name;
896: FETCH csr_person_name into l_person_name;

Line 948: hr_utility.set_location('Leaving:'|| l_proc, 100);

944: ,itemkey => l_Item_Key
945: );
946: --
947: if g_debug then
948: hr_utility.set_location('Leaving:'|| l_proc, 100);
949: end if;
950: --
951: end start_wf_process;
952: --

Line 981: g_debug := hr_utility.debug_enabled;

977: -- bug 7560762
978: --
979: begin
980: --
981: g_debug := hr_utility.debug_enabled;
982: if g_debug then
983: l_proc := g_package||'APPROVE_WF_PROCESS';
984: hr_utility.set_location('Entering:'|| l_proc, 10);
985: hr_utility.set_location(l_proc,1);

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

980: --
981: g_debug := hr_utility.debug_enabled;
982: if g_debug then
983: l_proc := g_package||'APPROVE_WF_PROCESS';
984: hr_utility.set_location('Entering:'|| l_proc, 10);
985: hr_utility.set_location(l_proc,1);
986: end if;
987: -- Debug code added in 120.9 removed in 120.10
988: --my_test_pkg.ins_my_values(l_proc||'funmode',funcmode);

Line 985: hr_utility.set_location(l_proc,1);

981: g_debug := hr_utility.debug_enabled;
982: if g_debug then
983: l_proc := g_package||'APPROVE_WF_PROCESS';
984: hr_utility.set_location('Entering:'|| l_proc, 10);
985: hr_utility.set_location(l_proc,1);
986: end if;
987: -- Debug code added in 120.9 removed in 120.10
988: --my_test_pkg.ins_my_values(l_proc||'funmode',funcmode);
989: --

Line 1005: hr_utility.set_location('l_task_done_by '||l_task_done_by,99);

1001: l_task_done_by := wf_engine.GetItemAttrText(
1002: itemtype => itemtype
1003: ,itemkey => itemkey
1004: ,aname => 'TASK_DONE_BY');
1005: hr_utility.set_location('l_task_done_by '||l_task_done_by,99);
1006: open c_performer_orig_sys_id(l_task_done_by);
1007: fetch c_performer_orig_sys_id into l_PERFORMER_ORIG_SYS_ID;
1008: close c_performer_orig_sys_id;
1009: hr_utility.set_location('l_PERFORMER_ORIG_SYS_ID '||l_PERFORMER_ORIG_SYS_ID,100);

Line 1009: hr_utility.set_location('l_PERFORMER_ORIG_SYS_ID '||l_PERFORMER_ORIG_SYS_ID,100);

1005: hr_utility.set_location('l_task_done_by '||l_task_done_by,99);
1006: open c_performer_orig_sys_id(l_task_done_by);
1007: fetch c_performer_orig_sys_id into l_PERFORMER_ORIG_SYS_ID;
1008: close c_performer_orig_sys_id;
1009: hr_utility.set_location('l_PERFORMER_ORIG_SYS_ID '||l_PERFORMER_ORIG_SYS_ID,100);
1010: -- bug 7560762
1011: --
1012: update PER_ALLOCATED_TASKS
1013: set status = 'COM',

Line 1028: hr_utility.set_location('Leaving:'|| l_proc, 100);

1024: --
1025: end if;
1026: --
1027: if g_debug then
1028: hr_utility.set_location('Leaving:'|| l_proc, 100);
1029: end if;
1030: --
1031: end approve_wf_process;
1032: --

Line 1060: g_debug := hr_utility.debug_enabled;

1056:
1057: --
1058: begin
1059: --
1060: g_debug := hr_utility.debug_enabled;
1061: if g_debug then
1062: l_proc := g_package||'REJECT_WF_PROCESS';
1063: hr_utility.set_location('Entering:'|| l_proc, 10);
1064: hr_utility.set_location(l_proc,1);

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

1059: --
1060: g_debug := hr_utility.debug_enabled;
1061: if g_debug then
1062: l_proc := g_package||'REJECT_WF_PROCESS';
1063: hr_utility.set_location('Entering:'|| l_proc, 10);
1064: hr_utility.set_location(l_proc,1);
1065: end if;
1066: --
1067: if (funcmode = 'RUN')

Line 1064: hr_utility.set_location(l_proc,1);

1060: g_debug := hr_utility.debug_enabled;
1061: if g_debug then
1062: l_proc := g_package||'REJECT_WF_PROCESS';
1063: hr_utility.set_location('Entering:'|| l_proc, 10);
1064: hr_utility.set_location(l_proc,1);
1065: end if;
1066: --
1067: if (funcmode = 'RUN')
1068: then

Line 1102: hr_utility.set_location('Leaving:'|| l_proc, 100);

1098: --
1099: end if;
1100: --
1101: if g_debug then
1102: hr_utility.set_location('Leaving:'|| l_proc, 100);
1103: end if;
1104: --
1105: end rejected_wf_process;
1106: --

Line 1135: g_debug := hr_utility.debug_enabled;

1131: l_proc varchar2(72);
1132: --
1133: begin
1134: --
1135: g_debug := hr_utility.debug_enabled;
1136: if g_debug then
1137: l_proc := g_package||'PROCESS_FYI';
1138: hr_utility.set_location('Entering:'|| l_proc, 10);
1139: hr_utility.set_location(l_proc,1);

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

1134: --
1135: g_debug := hr_utility.debug_enabled;
1136: if g_debug then
1137: l_proc := g_package||'PROCESS_FYI';
1138: hr_utility.set_location('Entering:'|| l_proc, 10);
1139: hr_utility.set_location(l_proc,1);
1140: end if;
1141: --
1142: --

Line 1139: hr_utility.set_location(l_proc,1);

1135: g_debug := hr_utility.debug_enabled;
1136: if g_debug then
1137: l_proc := g_package||'PROCESS_FYI';
1138: hr_utility.set_location('Entering:'|| l_proc, 10);
1139: hr_utility.set_location(l_proc,1);
1140: end if;
1141: --
1142: --
1143: if (funcmode = 'RUN')

Line 1215: hr_utility.set_location('Leaving:'|| l_proc, 100);

1211: --
1212: end if;
1213: --
1214: if g_debug then
1215: hr_utility.set_location('Leaving:'|| l_proc, 100);
1216: end if;
1217: --
1218: end process_fyi;
1219: --

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

1288: --
1289: BEGIN
1290: --
1291: l_proc:= 'per_checklist_events.copy_tasks';
1292: hr_utility.set_location('Entering: '|| l_proc, 10);
1293: --
1294: OPEN c_tasks(p_from_ckl_id);
1295: --
1296: LOOP

Line 1376: hr_utility.set_location('Leaving: '|| l_proc, 20);

1372: END LOOP;
1373: --
1374: CLOSE c_tasks;
1375: --
1376: hr_utility.set_location('Leaving: '|| l_proc, 20);
1377: --
1378: EXCEPTION
1379: --
1380: WHEN OTHERS THEN

Line 1382: hr_utility.set_location('Leaving: '|| l_proc, 30);

1378: EXCEPTION
1379: --
1380: WHEN OTHERS THEN
1381: --
1382: hr_utility.set_location('Leaving: '|| l_proc, 30);
1383: hr_utility.set_location(SQLERRM, 35);
1384: RAISE;
1385: --
1386: END Copy_Tasks;

Line 1383: hr_utility.set_location(SQLERRM, 35);

1379: --
1380: WHEN OTHERS THEN
1381: --
1382: hr_utility.set_location('Leaving: '|| l_proc, 30);
1383: hr_utility.set_location(SQLERRM, 35);
1384: RAISE;
1385: --
1386: END Copy_Tasks;
1387: --