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_EMP_ELIG dependencies on HR_UTILITY

Line 73: hr_utility.set_location ('Entering '||l_proc,15);

69: from pqh_roles
70: where role_type_cd ='CWB';
71: l_proc varchar2(80) := g_package||'.isCompManagerRole';
72: BEGIN
73: hr_utility.set_location ('Entering '||l_proc,15);
74: retValue := 'N';
75: FOR rl in c2
76: LOOP
77: FOR person_in_role IN c1(rl.role_id)

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

80: retValue := 'Y';
81: END IF;
82: END LOOP;
83: END LOOP;
84: hr_utility.set_location ('Leaving '||l_proc,20);
85: exception
86: when others then
87: retValue := null;
88: raise;

Line 140: hr_utility.set_location ('Entering '||l_proc,40);

136: FROM ben_cwb_person_rates
137: WHERE person_rate_id = v_person_rate_id;
138:
139: BEGIN
140: hr_utility.set_location ('Entering '||l_proc,40);
141:
142: IF p_o1_elig_change_status = 'O1Y' THEN
143:
144: IF p_o1_elig_flag = 'N' THEN

Line 569: hr_utility.set_location ('Leaving '||l_proc,45);

565: END IF;
566:
567: END IF;
568:
569: hr_utility.set_location ('Leaving '||l_proc,45);
570: END;
571: /*******************************************************************************************/
572:
573: /*******************************************************************************************/

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

585: l_process_name varchar2(60) := 'CWB_EMP_ELIG';
586: l_process_name_c varchar2(60);
587: Begin
588:
589: -- hr_utility.trace_on (null, 'ORACLE');
590:
591: hr_utility.set_location ('Entering '||l_proc,50);
592:
593: hr_utility.set_location ('Seeded Elig Process Name'||l_process_name ,55);

Line 591: hr_utility.set_location ('Entering '||l_proc,50);

587: Begin
588:
589: -- hr_utility.trace_on (null, 'ORACLE');
590:
591: hr_utility.set_location ('Entering '||l_proc,50);
592:
593: hr_utility.set_location ('Seeded Elig Process Name'||l_process_name ,55);
594:
595: hr_utility.set_location ('Profile :: '|| fnd_profile.value('BEN_CWB_EMP_ELIG_W_PROCESS') ,55);

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

589: -- hr_utility.trace_on (null, 'ORACLE');
590:
591: hr_utility.set_location ('Entering '||l_proc,50);
592:
593: hr_utility.set_location ('Seeded Elig Process Name'||l_process_name ,55);
594:
595: hr_utility.set_location ('Profile :: '|| fnd_profile.value('BEN_CWB_EMP_ELIG_W_PROCESS') ,55);
596:
597: l_process_name := nvl(fnd_profile.value('BEN_CWB_EMP_ELIG_W_PROCESS'),'CWB_EMP_ELIG');

Line 595: hr_utility.set_location ('Profile :: '|| fnd_profile.value('BEN_CWB_EMP_ELIG_W_PROCESS') ,55);

591: hr_utility.set_location ('Entering '||l_proc,50);
592:
593: hr_utility.set_location ('Seeded Elig Process Name'||l_process_name ,55);
594:
595: hr_utility.set_location ('Profile :: '|| fnd_profile.value('BEN_CWB_EMP_ELIG_W_PROCESS') ,55);
596:
597: l_process_name := nvl(fnd_profile.value('BEN_CWB_EMP_ELIG_W_PROCESS'),'CWB_EMP_ELIG');
598:
599: hr_utility.set_location ('Elig Process Name After reading profile'||l_process_name ,55);

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

595: hr_utility.set_location ('Profile :: '|| fnd_profile.value('BEN_CWB_EMP_ELIG_W_PROCESS') ,55);
596:
597: l_process_name := nvl(fnd_profile.value('BEN_CWB_EMP_ELIG_W_PROCESS'),'CWB_EMP_ELIG');
598:
599: hr_utility.set_location ('Elig Process Name After reading profile'||l_process_name ,55);
600:
601: wf_engine.createProcess(ItemType => l_itemtype,
602: ItemKey => l_itemkey,
603: process => l_process_name );

Line 638: hr_utility.set_location ('Leaving '||l_proc,55);

634: , itemkey => l_itemkey
635: , owner => p_requestor_name);
636: wf_engine.StartProcess ( ItemType => l_itemtype,
637: ItemKey => l_ItemKey );
638: hr_utility.set_location ('Leaving '||l_proc,55);
639: exception
640: when others then
641: hr_utility.set_location ('Error occured cwb_emp_elig_start_process',60);
642: END;

Line 641: hr_utility.set_location ('Error occured cwb_emp_elig_start_process',60);

637: ItemKey => l_ItemKey );
638: hr_utility.set_location ('Leaving '||l_proc,55);
639: exception
640: when others then
641: hr_utility.set_location ('Error occured cwb_emp_elig_start_process',60);
642: END;
643: /*******************************************************************************************/
644:
645: /*******************************************************************************************/

Line 666: hr_utility.set_location ('Entering '||l_proc,85);

662: where employee_id = p_rcvr_person_id;
663: cursor c2 is select user_name from fnd_user
664: where employee_id = p_ws_person_id;
665: BEGIN
666: hr_utility.set_location ('Entering '||l_proc,85);
667: if p_rcvr_person_id is null then
668: hr_utility.set_location ('receiver person id to be passed ',90);
669: else
670: open c1;

Line 668: hr_utility.set_location ('receiver person id to be passed ',90);

664: where employee_id = p_ws_person_id;
665: BEGIN
666: hr_utility.set_location ('Entering '||l_proc,85);
667: if p_rcvr_person_id is null then
668: hr_utility.set_location ('receiver person id to be passed ',90);
669: else
670: open c1;
671: fetch c1 into l_rcvr_user_name;
672: if c1%notfound then

Line 673: hr_utility.set_location ('fnd user does not exist'||p_rcvr_person_id,95);

669: else
670: open c1;
671: fetch c1 into l_rcvr_user_name;
672: if c1%notfound then
673: hr_utility.set_location ('fnd user does not exist'||p_rcvr_person_id,95);
674: else
675: l_start_process := 'Y' ;
676: end if;
677: close c1;

Line 680: hr_utility.set_location ('wroksheet manager person id to be passed ',95);

676: end if;
677: close c1;
678: end if;
679: if p_ws_person_id is null then
680: hr_utility.set_location ('wroksheet manager person id to be passed ',95);
681: else
682: open c2;
683: fetch c2 into l_ws_user_name;
684: if c2%notfound then

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

696: , p_relationship_id => p_relationship_id
697: , p_group_per_in_ler_id => p_group_per_in_ler_id
698: );
699: end if;
700: hr_utility.set_location ('Leaving '||l_proc,100);
701: exception
702: when others then
703: hr_utility.set_location ('Error occured cwb_emp_elig_appr_api',105);
704: END;

Line 703: hr_utility.set_location ('Error occured cwb_emp_elig_appr_api',105);

699: end if;
700: hr_utility.set_location ('Leaving '||l_proc,100);
701: exception
702: when others then
703: hr_utility.set_location ('Error occured cwb_emp_elig_appr_api',105);
704: END;
705: /*******************************************************************************************/
706:
707: /*******************************************************************************************/

Line 723: hr_utility.set_location ('Entering '||l_proc,110);

719: l_is_ame_used VARCHAR2(240) := 'Y';
720: c_next_approver_out ame_util.approverRecord;
721: l_approver_name VARCHAR2(240);
722: BEGIN
723: hr_utility.set_location ('Entering '||l_proc,110);
724: ame_api.getnextapprover
725: (
726: applicationIdIn =>805,
727: transactionIdIn =>itemkey,

Line 757: hr_utility.set_location ('Leaving '||l_proc,115);

753: close approver_name;
754: ELSE
755: result := 'COMPLETE:' ||'APPROVER_NOT_FOUND';
756: END IF;
757: hr_utility.set_location ('Leaving '||l_proc,115);
758: exception
759: when others then
760: wf_engine.SetItemAttrText(itemtype => itemtype
761: , itemkey => itemkey

Line 799: hr_utility.set_location ('Entering '||l_proc,135);

795: l_itemtype VARCHAR(240) := itemtype;
796: cursor employeeId (c_approver_name IN VARCHAR2) is select employee_id from fnd_user
797: where user_name = l_approver_name;
798: BEGIN
799: hr_utility.set_location ('Entering '||l_proc,135);
800: l_approver_name :=wf_engine.getitemattrtext(itemtype => itemtype ,
801: itemkey => itemkey,
802: aname => 'APPROVER_NAME');
803: l_approver_id :=wf_engine.getitemattrNumber(itemtype => itemtype ,

Line 810: hr_utility.set_location ('Was not able to get the approver name in store transaction',145);

806: IF(l_approver_name is not null) THEN
807: OPEN employeeId(l_approver_name);
808: FETCH employeeId INTO l_approver_id;
809: IF employeeId%NOTFOUND then
810: hr_utility.set_location ('Was not able to get the approver name in store transaction',145);
811: ELSE
812: ame_api.updateApprovalStatus2(applicationIdIn => 805,
813: transactionIdIn => itemkey,
814: approvalStatusIn => ame_util.approvedStatus,

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

821: , aname => 'FROM_ROLE'
822: , avalue => l_approver_name);
823: END IF;
824: result := 'COMPLETE:'||'EMP_ELIG_SUCCESS' ;
825: hr_utility.set_location ('Leaving '||l_proc,10);
826: exception
827: when others then
828: wf_engine.SetItemAttrText(itemtype => itemtype
829: , itemkey => itemkey

Line 863: hr_utility.set_location ('Entering '||l_proc,150);

859: l_approver_name VARCHAR2(1000);
860: l_itemkey VARCHAR(240) := itemkey;
861: l_itemtype VARCHAR(240) := itemtype;
862: BEGIN
863: hr_utility.set_location ('Entering '||l_proc,150);
864: l_approver_id :=wf_engine.getitemattrNumber(itemtype => itemtype ,
865: itemkey => itemkey,
866: aname => 'APPROVER_ID');
867: l_approver_name :=wf_engine.getitemattrtext(itemtype => itemtype ,

Line 875: hr_utility.set_location ('Leaving '||l_proc,155);

871: , itemkey => l_itemkey
872: , aname => 'FROM_ROLE'
873: , avalue => l_approver_name);
874: result := 'COMPLETE:';
875: hr_utility.set_location ('Leaving '||l_proc,155);
876: exception
877: when others then
878: result := null;
879: END;

Line 935: hr_utility.set_location ('Entering '||l_proc,160);

931: where tran_tbl.attribute1 = itemkey
932: and tran_tbl.transaction_type = 'EMPELIGEMP'
933: and to_number(tran_tbl.attribute2) = pil.per_in_ler_id;
934: BEGIN
935: hr_utility.set_location ('Entering '||l_proc,160);
936:
937: ben_cwb_summary_pkg.delete_pl_sql_tab;
938:
939: for emp_elig in upd_emp_elig

Line 988: hr_utility.set_location ('Leaving '||l_proc,165);

984:
985: ben_cwb_summary_pkg.save_pl_sql_tab;
986:
987: result := 'COMPLETE:'||'EMP_ELIG_SUCCESS' ;
988: hr_utility.set_location ('Leaving '||l_proc,165);
989: exception
990: when others then
991: wf_engine.SetItemAttrText( itemtype => itemtype
992: ,itemkey => itemkey

Line 1024: hr_utility.set_location ('Entering '||l_proc,170);

1020: l_proc varchar2(61) := g_package||':'||'is_req_wsmgr_same';
1021: l_worksheet_manager VARCHAR2(240);
1022: l_requestor VARCHAR2(240);
1023: BEGIN
1024: hr_utility.set_location ('Entering '||l_proc,170);
1025: l_worksheet_manager :=wf_engine.getitemattrText(itemtype => itemtype ,
1026: itemkey => itemkey,
1027: aname => 'WORKSHEET_MANAGER');
1028: l_requestor :=wf_engine.getitemattrText(itemtype => itemtype ,

Line 1036: hr_utility.set_location ('Leaving '||l_proc,175);

1032: result := 'COMPLETE:' ||'Y';
1033: ELSE
1034: result := 'COMPLETE:' ||'N';
1035: END IF;
1036: hr_utility.set_location ('Leaving '||l_proc,175);
1037: exception
1038: when others then
1039: result := null;
1040: END;

Line 1054: hr_utility.set_location ('Entering '||l_proc,180);

1050: )
1051: IS
1052: l_proc varchar2(61) := g_package||':'||'remove_transaction';
1053: BEGIN
1054: hr_utility.set_location ('Entering '||l_proc,180);
1055: update ben_transaction
1056: set STATUS='PROCESSED'
1057: where attribute1 = itemkey
1058: and transaction_type='EMPELIGHDR';

Line 1064: hr_utility.set_location ('Leaving '||l_proc,185);

1060: set STATUS='PROCESSED'
1061: where transaction_type = 'EMPELIGEMP'
1062: and attribute1 = itemkey;
1063: result := 'COMPLETE:';
1064: hr_utility.set_location ('Leaving '||l_proc,185);
1065: exception
1066: when others then
1067: result := null;
1068: END;