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 WF_ENGINE

Line 601: wf_engine.createProcess(ItemType => l_itemtype,

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 );
604:
605: wf_engine.SetItemAttrText(itemtype => l_itemtype

Line 605: wf_engine.SetItemAttrText(itemtype => l_itemtype

601: wf_engine.createProcess(ItemType => l_itemtype,
602: ItemKey => l_itemkey,
603: process => l_process_name );
604:
605: wf_engine.SetItemAttrText(itemtype => l_itemtype
606: , itemkey => l_itemkey
607: , aname => 'PLAN_NAME'
608: , avalue => p_plan_name);
609: wf_engine.SetItemAttrText(itemtype => l_itemtype

Line 609: wf_engine.SetItemAttrText(itemtype => l_itemtype

605: wf_engine.SetItemAttrText(itemtype => l_itemtype
606: , itemkey => l_itemkey
607: , aname => 'PLAN_NAME'
608: , avalue => p_plan_name);
609: wf_engine.SetItemAttrText(itemtype => l_itemtype
610: , itemkey => l_itemkey
611: , aname => 'REQUESTOR_NAME'
612: , avalue => p_requestor_name);
613: wf_engine.SetItemAttrText(itemtype => l_itemtype

Line 613: wf_engine.SetItemAttrText(itemtype => l_itemtype

609: wf_engine.SetItemAttrText(itemtype => l_itemtype
610: , itemkey => l_itemkey
611: , aname => 'REQUESTOR_NAME'
612: , avalue => p_requestor_name);
613: wf_engine.SetItemAttrText(itemtype => l_itemtype
614: , itemkey => l_itemkey
615: , aname => 'WORKSHEET_MANAGER'
616: , avalue => p_worksheet_manger);
617: wf_engine.SetItemAttrText(itemtype => l_itemtype

Line 617: wf_engine.SetItemAttrText(itemtype => l_itemtype

613: wf_engine.SetItemAttrText(itemtype => l_itemtype
614: , itemkey => l_itemkey
615: , aname => 'WORKSHEET_MANAGER'
616: , avalue => p_worksheet_manger);
617: wf_engine.SetItemAttrText(itemtype => l_itemtype
618: , itemkey => l_itemkey
619: , aname => 'MANAGER_NAME'
620: , avalue => get_person_name(p_group_per_in_ler_id));
621: wf_engine.SetItemAttrText(itemtype => l_itemtype

Line 621: wf_engine.SetItemAttrText(itemtype => l_itemtype

617: wf_engine.SetItemAttrText(itemtype => l_itemtype
618: , itemkey => l_itemkey
619: , aname => 'MANAGER_NAME'
620: , avalue => get_person_name(p_group_per_in_ler_id));
621: wf_engine.SetItemAttrText(itemtype => l_itemtype
622: , itemkey => l_itemkey
623: , aname => 'FROM_ROLE'
624: , avalue => p_requestor_name);
625: wf_engine.SetItemAttrText(itemtype => l_itemtype

Line 625: wf_engine.SetItemAttrText(itemtype => l_itemtype

621: wf_engine.SetItemAttrText(itemtype => l_itemtype
622: , itemkey => l_itemkey
623: , aname => 'FROM_ROLE'
624: , avalue => p_requestor_name);
625: wf_engine.SetItemAttrText(itemtype => l_itemtype
626: , itemkey => l_itemkey
627: , aname => 'TRANSACTION_ID'
628: , avalue => p_relationship_id);
629: wf_engine.SetItemAttrText(itemtype => l_itemtype

Line 629: wf_engine.SetItemAttrText(itemtype => l_itemtype

625: wf_engine.SetItemAttrText(itemtype => l_itemtype
626: , itemkey => l_itemkey
627: , aname => 'TRANSACTION_ID'
628: , avalue => p_relationship_id);
629: wf_engine.SetItemAttrText(itemtype => l_itemtype
630: , itemkey => l_itemkey
631: , aname => 'FOR_PERIOD'
632: , avalue => get_for_period (p_group_per_in_ler_id));
633: wf_engine.SetItemOwner(itemtype => l_itemtype

Line 633: wf_engine.SetItemOwner(itemtype => l_itemtype

629: wf_engine.SetItemAttrText(itemtype => l_itemtype
630: , itemkey => l_itemkey
631: , aname => 'FOR_PERIOD'
632: , avalue => get_for_period (p_group_per_in_ler_id));
633: wf_engine.SetItemOwner(itemtype => l_itemtype
634: , itemkey => l_itemkey
635: , owner => p_requestor_name);
636: wf_engine.StartProcess ( ItemType => l_itemtype,
637: ItemKey => l_ItemKey );

Line 636: wf_engine.StartProcess ( ItemType => l_itemtype,

632: , avalue => get_for_period (p_group_per_in_ler_id));
633: wf_engine.SetItemOwner(itemtype => l_itemtype
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

Line 736: wf_engine.SetItemAttrText(itemtype => itemtype

732: FETCH approver_name INTO l_approver_name;
733: IF approver_name%NOTFOUND then
734: result := 'COMPLETE:' ||'APPROVER_NOT_FOUND';
735: ELSE
736: wf_engine.SetItemAttrText(itemtype => itemtype
737: , itemkey => itemkey
738: , aname => 'APPROVER_NAME'
739: , avalue => l_approver_name );
740: update ben_transaction

Line 747: wf_engine.SetItemAttrNumber(itemtype => itemtype

743: attribute35 = c_next_approver_out.person_id
744: where attribute1 = itemkey
745: and transaction_type = 'EMPELIGEMP';
746:
747: wf_engine.SetItemAttrNumber(itemtype => itemtype
748: , itemkey => itemkey
749: , aname => 'APPROVER_ID'
750: , avalue => c_next_approver_out.person_id );
751: result := 'COMPLETE:' ||'CWB_APPROVER_FOUND';

Line 760: wf_engine.SetItemAttrText(itemtype => itemtype

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
762: , aname => 'ERROR_OCCURED_AT'
763: , avalue => 'Select Next Approver Node');
764: wf_engine.SetItemAttrText(itemtype => itemtype

Line 764: wf_engine.SetItemAttrText(itemtype => itemtype

760: wf_engine.SetItemAttrText(itemtype => itemtype
761: , itemkey => itemkey
762: , aname => 'ERROR_OCCURED_AT'
763: , avalue => 'Select Next Approver Node');
764: wf_engine.SetItemAttrText(itemtype => itemtype
765: , itemkey => itemkey
766: , aname => 'ERROR_MESSAGE'
767: , avalue => 'Unable to get the next approver or failed to update the transaction table');
768: wf_engine.SetItemAttrText(itemtype => itemtype

Line 768: wf_engine.SetItemAttrText(itemtype => itemtype

764: wf_engine.SetItemAttrText(itemtype => itemtype
765: , itemkey => itemkey
766: , aname => 'ERROR_MESSAGE'
767: , avalue => 'Unable to get the next approver or failed to update the transaction table');
768: wf_engine.SetItemAttrText(itemtype => itemtype
769: , itemkey => itemkey
770: , aname => 'ERROR_SQLERRM'
771: , avalue => SQLERRM);
772: wf_engine.SetItemAttrText(itemtype => itemtype

Line 772: wf_engine.SetItemAttrText(itemtype => itemtype

768: wf_engine.SetItemAttrText(itemtype => itemtype
769: , itemkey => itemkey
770: , aname => 'ERROR_SQLERRM'
771: , avalue => SQLERRM);
772: wf_engine.SetItemAttrText(itemtype => itemtype
773: , itemkey => itemkey
774: , aname => 'ERROR_SQLCODE'
775: , avalue => SQLCODE);
776: result := 'COMPLETE:'||'EMP_ELIG_ERROR';

Line 800: l_approver_name :=wf_engine.getitemattrtext(itemtype => 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 ,
804: itemkey => itemkey,

Line 803: l_approver_id :=wf_engine.getitemattrNumber(itemtype => itemtype ,

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 ,
804: itemkey => itemkey,
805: aname => 'APPROVER_ID');
806: IF(l_approver_name is not null) THEN
807: OPEN employeeId(l_approver_name);

Line 819: wf_engine.SetItemAttrText(itemtype => l_itemtype

815: approverPersonIdIn => l_approver_id,
816: transactionTypeIn => 'EMPELIG');
817: END IF;
818: close employeeId;
819: wf_engine.SetItemAttrText(itemtype => l_itemtype
820: , itemkey => l_itemkey
821: , aname => 'FROM_ROLE'
822: , avalue => l_approver_name);
823: END IF;

Line 828: wf_engine.SetItemAttrText(itemtype => itemtype

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
830: , aname => 'ERROR_OCCURED_AT'
831: , avalue => 'Store transaction Node');
832: wf_engine.SetItemAttrText(itemtype => itemtype

Line 832: wf_engine.SetItemAttrText(itemtype => itemtype

828: wf_engine.SetItemAttrText(itemtype => itemtype
829: , itemkey => itemkey
830: , aname => 'ERROR_OCCURED_AT'
831: , avalue => 'Store transaction Node');
832: wf_engine.SetItemAttrText(itemtype => itemtype
833: , itemkey => itemkey
834: , aname => 'ERROR_MESSAGE'
835: , avalue => 'Unable to update ame approver status');
836: wf_engine.SetItemAttrText(itemtype => itemtype

Line 836: wf_engine.SetItemAttrText(itemtype => itemtype

832: wf_engine.SetItemAttrText(itemtype => itemtype
833: , itemkey => itemkey
834: , aname => 'ERROR_MESSAGE'
835: , avalue => 'Unable to update ame approver status');
836: wf_engine.SetItemAttrText(itemtype => itemtype
837: , itemkey => itemkey
838: , aname => 'ERROR_SQLERRM'
839: , avalue => SQLERRM);
840: wf_engine.SetItemAttrText(itemtype => itemtype

Line 840: wf_engine.SetItemAttrText(itemtype => itemtype

836: wf_engine.SetItemAttrText(itemtype => itemtype
837: , itemkey => itemkey
838: , aname => 'ERROR_SQLERRM'
839: , avalue => SQLERRM);
840: wf_engine.SetItemAttrText(itemtype => itemtype
841: , itemkey => itemkey
842: , aname => 'ERROR_SQLCODE'
843: , avalue => SQLCODE);
844: result := 'COMPLETE:'||'EMP_ELIG_ERROR';

Line 864: l_approver_id :=wf_engine.getitemattrNumber(itemtype => itemtype ,

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 ,
868: itemkey => itemkey,

Line 867: l_approver_name :=wf_engine.getitemattrtext(itemtype => itemtype ,

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 ,
868: itemkey => itemkey,
869: aname => 'APPROVER_NAME');
870: wf_engine.SetItemAttrText(itemtype => l_itemtype
871: , itemkey => l_itemkey

Line 870: wf_engine.SetItemAttrText(itemtype => l_itemtype

866: aname => 'APPROVER_ID');
867: l_approver_name :=wf_engine.getitemattrtext(itemtype => itemtype ,
868: itemkey => itemkey,
869: aname => 'APPROVER_NAME');
870: wf_engine.SetItemAttrText(itemtype => l_itemtype
871: , itemkey => l_itemkey
872: , aname => 'FROM_ROLE'
873: , avalue => l_approver_name);
874: result := 'COMPLETE:';

Line 991: wf_engine.SetItemAttrText( itemtype => itemtype

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
993: ,aname => 'ERROR_OCCURED_AT'
994: ,avalue => 'Store approval Node');
995: wf_engine.SetItemAttrText(itemtype => itemtype

Line 995: wf_engine.SetItemAttrText(itemtype => itemtype

991: wf_engine.SetItemAttrText( itemtype => itemtype
992: ,itemkey => itemkey
993: ,aname => 'ERROR_OCCURED_AT'
994: ,avalue => 'Store approval Node');
995: wf_engine.SetItemAttrText(itemtype => itemtype
996: ,itemkey => itemkey
997: ,aname => 'ERROR_MESSAGE'
998: ,avalue => l_errmsg);
999: wf_engine.SetItemAttrText(itemtype => itemtype

Line 999: wf_engine.SetItemAttrText(itemtype => itemtype

995: wf_engine.SetItemAttrText(itemtype => itemtype
996: ,itemkey => itemkey
997: ,aname => 'ERROR_MESSAGE'
998: ,avalue => l_errmsg);
999: wf_engine.SetItemAttrText(itemtype => itemtype
1000: ,itemkey => itemkey
1001: ,aname => 'ERROR_SQLERRM'
1002: ,avalue => SQLERRM);
1003: wf_engine.SetItemAttrText(itemtype => itemtype

Line 1003: wf_engine.SetItemAttrText(itemtype => itemtype

999: wf_engine.SetItemAttrText(itemtype => itemtype
1000: ,itemkey => itemkey
1001: ,aname => 'ERROR_SQLERRM'
1002: ,avalue => SQLERRM);
1003: wf_engine.SetItemAttrText(itemtype => itemtype
1004: ,itemkey => itemkey
1005: ,aname => 'ERROR_SQLCODE'
1006: ,avalue => SQLCODE);
1007: result := 'COMPLETE:'||'EMP_ELIG_ERROR';

Line 1025: l_worksheet_manager :=wf_engine.getitemattrText(itemtype => itemtype ,

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 ,
1029: itemkey => itemkey,

Line 1028: l_requestor :=wf_engine.getitemattrText(itemtype => itemtype ,

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 ,
1029: itemkey => itemkey,
1030: aname => 'REQUESTOR_NAME');
1031: IF(l_worksheet_manager = l_requestor) THEN
1032: result := 'COMPLETE:' ||'Y';