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

Line 37: hr_utility.set_location('l_proc',1);

33: begin
34:
35: -- Creates a new runtime process for an application item (SF-52)
36: --
37: hr_utility.set_location('l_proc',1);
38: wf_engine.createProcess( ItemType => l_ItemType,
39: ItemKey => l_ItemKey,
40: process => 'SF52_APPROVAL_PROCESS' );
41: --

Line 43: hr_utility.set_location('l_proc',2);

39: ItemKey => l_ItemKey,
40: process => 'SF52_APPROVAL_PROCESS' );
41: --
42: --
43: hr_utility.set_location('l_proc',2);
44: wf_engine.SetItemAttrNumber ( itemtype => l_ItemType,
45: itemkey => l_Itemkey,
46: aname => 'PA_REQUEST_ID',
47: avalue => p_pa_request_id );

Line 48: hr_utility.set_location('l_proc',3);

44: wf_engine.SetItemAttrNumber ( itemtype => l_ItemType,
45: itemkey => l_Itemkey,
46: aname => 'PA_REQUEST_ID',
47: avalue => p_pa_request_id );
48: hr_utility.set_location('l_proc',3);
49: wf_engine.SetItemAttrText( itemtype => l_itemtype,
50: itemkey => l_itemkey,
51: aname => 'FORWARD_TO_NAME',
52: avalue => p_forward_to_name );

Line 54: hr_utility.set_location('l_proc',4);

50: itemkey => l_itemkey,
51: aname => 'FORWARD_TO_NAME',
52: avalue => p_forward_to_name );
53:
54: hr_utility.set_location('l_proc',4);
55: hr_utility.set_location('l_proc',5);
56: wf_engine.SetItemAttrText( itemtype => l_itemtype,
57: itemkey => l_itemkey,
58: aname => 'FORWARD_FROM_DISPLAY_NAME',

Line 55: hr_utility.set_location('l_proc',5);

51: aname => 'FORWARD_TO_NAME',
52: avalue => p_forward_to_name );
53:
54: hr_utility.set_location('l_proc',4);
55: hr_utility.set_location('l_proc',5);
56: wf_engine.SetItemAttrText( itemtype => l_itemtype,
57: itemkey => l_itemkey,
58: aname => 'FORWARD_FROM_DISPLAY_NAME',
59: avalue => FND_GLOBAL.USER_NAME() );

Line 61: hr_utility.set_location('l_proc',6);

57: itemkey => l_itemkey,
58: aname => 'FORWARD_FROM_DISPLAY_NAME',
59: avalue => FND_GLOBAL.USER_NAME() );
60:
61: hr_utility.set_location('l_proc',6);
62: l_load_form := 'GHRWS52L:p_pa_request_id=' || l_Itemkey
63: || ' p_inbox_query_only="NO"' || ' WORKFLOW_NAME="GHR US PA REQUEST"'
64: || ' p_wf_notification_id=&#NID';--Bug# 6923642
65: wf_engine.SetItemAttrText( itemtype => l_itemtype,

Line 77: hr_utility.set_location('l_proc',7);

73: aname => 'LOAD_PRH',
74: avalue => l_load_prh
75: );
76: --
77: hr_utility.set_location('l_proc',7);
78: ghr_wf_pkg.SetDestinationDetails ( p_pa_request_id => l_itemkey,
79: p_subject => l_subject,
80: p_line1 => l_line1,
81: p_line2 => l_line2,

Line 177: hr_utility.set_location('l_proc',10);

173: wf_engine.StartProcess ( ItemType => l_ItemType,
174: ItemKey => l_ItemKey );
175: --
176: --
177: hr_utility.set_location('l_proc',10);
178: end StartSF52Process;
179: --
180: --
181: PROCEDURE UpdateRHistoryProcess( itemtype in varchar2,

Line 265: -- hr_utility.set_message(8301,'GHR_38211_NOA_FAMILY_NOTFOUND');

261: fetch csr_get_approver_name into l_approver_name;
262: if csr_get_approver_name%notfound then
263: null;
264: -- ?? Check with ****
265: -- hr_utility.set_message(8301,'GHR_38211_NOA_FAMILY_NOTFOUND');
266: -- hr_utility.raise_error;
267: end if;
268: close csr_get_approver_name;
269: --

Line 266: -- hr_utility.raise_error;

262: if csr_get_approver_name%notfound then
263: null;
264: -- ?? Check with ****
265: -- hr_utility.set_message(8301,'GHR_38211_NOA_FAMILY_NOTFOUND');
266: -- hr_utility.raise_error;
267: end if;
268: close csr_get_approver_name;
269: --
270: --

Line 276: -- hr_utility.set_message(8301,'GHR_38211_NOA_FAMILY_NOTFOUND');

272: fetch csr_get_upd_hr_user_name into l_upd_hr_user_name;
273: if csr_get_upd_hr_user_name%notfound then
274: null;
275: -- ?? Check with ****
276: -- hr_utility.set_message(8301,'GHR_38211_NOA_FAMILY_NOTFOUND');
277: -- hr_utility.raise_error;
278: end if;
279: close csr_get_upd_hr_user_name;
280: --

Line 277: -- hr_utility.raise_error;

273: if csr_get_upd_hr_user_name%notfound then
274: null;
275: -- ?? Check with ****
276: -- hr_utility.set_message(8301,'GHR_38211_NOA_FAMILY_NOTFOUND');
277: -- hr_utility.raise_error;
278: end if;
279: close csr_get_upd_hr_user_name;
280: --
281: if l_approver_name Is Null then

Line 642: -- hr_utility.set_message(8301,'GHR_38211_NOA_FAMILY_NOTFOUND');

638: fetch csr_pa_routing_history into l_pa_routing_history_id;
639: if csr_pa_routing_history%notfound then
640: null;
641: -- ?? Check with ****
642: -- hr_utility.set_message(8301,'GHR_38211_NOA_FAMILY_NOTFOUND');
643: -- hr_utility.raise_error;
644: end if;
645: close csr_pa_routing_history;
646: --

Line 643: -- hr_utility.raise_error;

639: if csr_pa_routing_history%notfound then
640: null;
641: -- ?? Check with ****
642: -- hr_utility.set_message(8301,'GHR_38211_NOA_FAMILY_NOTFOUND');
643: -- hr_utility.raise_error;
644: end if;
645: close csr_pa_routing_history;
646: --
647: -- Get the routing history details

Line 654: -- hr_utility.set_message(8301,'GHR_38211_NOA_FAMILY_NOTFOUND');

650: fetch csr_pah_details into l_action_taken, l_user_name, l_groupbox_id;
651: if csr_pah_details%notfound then
652: null;
653: -- ?? Check with ****
654: -- hr_utility.set_message(8301,'GHR_38211_NOA_FAMILY_NOTFOUND');
655: -- hr_utility.raise_error;
656: end if;
657: close csr_pah_details;
658: --

Line 655: -- hr_utility.raise_error;

651: if csr_pah_details%notfound then
652: null;
653: -- ?? Check with ****
654: -- hr_utility.set_message(8301,'GHR_38211_NOA_FAMILY_NOTFOUND');
655: -- hr_utility.raise_error;
656: end if;
657: close csr_pah_details;
658: --
659: --

Line 670: -- hr_utility.set_message(8301,'GHR_38211_NOA_FAMILY_NOTFOUND');

666: fetch csr_gbx_details into l_groupbox_name;
667: if csr_gbx_details%notfound then
668: null;
669: -- ?? Check with ****
670: -- hr_utility.set_message(8301,'GHR_38211_NOA_FAMILY_NOTFOUND');
671: -- hr_utility.raise_error;
672: else
673: p_groupbox_name := l_groupbox_name;
674: end if;

Line 671: -- hr_utility.raise_error;

667: if csr_gbx_details%notfound then
668: null;
669: -- ?? Check with ****
670: -- hr_utility.set_message(8301,'GHR_38211_NOA_FAMILY_NOTFOUND');
671: -- hr_utility.raise_error;
672: else
673: p_groupbox_name := l_groupbox_name;
674: end if;
675: close csr_gbx_details;

Line 817: -- hr_utility.set_message(8301,'GHR_38211_NOA_FAMILY_NOTFOUND');

813: l_personnel_office_id, l_status, l_to_position_id;
814: if csr_par_details%notfound then
815: null;
816: -- ?? Check with ****
817: -- hr_utility.set_message(8301,'GHR_38211_NOA_FAMILY_NOTFOUND');
818: -- hr_utility.raise_error;
819: end if;
820: close csr_par_details;
821: --

Line 818: -- hr_utility.raise_error;

814: if csr_par_details%notfound then
815: null;
816: -- ?? Check with ****
817: -- hr_utility.set_message(8301,'GHR_38211_NOA_FAMILY_NOTFOUND');
818: -- hr_utility.raise_error;
819: end if;
820: close csr_par_details;
821: --
822: -- Fetch POI from history

Line 850: -- hr_utility.set_message(8301,'GHR_38211_NOA_FAMILY_NOTFOUND');

846: fetch csr_ghr_families into l_noa_fam_desc;
847: if csr_ghr_families%notfound then
848: null;
849: -- ?? Check with ****
850: -- hr_utility.set_message(8301,'GHR_38211_NOA_FAMILY_NOTFOUND');
851: -- hr_utility.raise_error;
852: end if;
853: close csr_ghr_families;
854: if l_noa_fam_desc is Null then

Line 851: -- hr_utility.raise_error;

847: if csr_ghr_families%notfound then
848: null;
849: -- ?? Check with ****
850: -- hr_utility.set_message(8301,'GHR_38211_NOA_FAMILY_NOTFOUND');
851: -- hr_utility.raise_error;
852: end if;
853: close csr_ghr_families;
854: if l_noa_fam_desc is Null then
855: l_noa_fam_desc := l_noa_family_code;

Line 874: -- hr_utility.set_message(8301,'GHR_38211_NOA_FAMILY_NOTFOUND');

870: fetch csr_routing_groups into l_routing_group_name, l_description;
871: if csr_routing_groups%notfound then
872: null;
873: -- ?? Check with ****
874: -- hr_utility.set_message(8301,'GHR_38211_NOA_FAMILY_NOTFOUND');
875: -- hr_utility.raise_error;
876: end if;
877: close csr_routing_groups;
878: else

Line 875: -- hr_utility.raise_error;

871: if csr_routing_groups%notfound then
872: null;
873: -- ?? Check with ****
874: -- hr_utility.set_message(8301,'GHR_38211_NOA_FAMILY_NOTFOUND');
875: -- hr_utility.raise_error;
876: end if;
877: close csr_routing_groups;
878: else
879: l_routing_group_name := ' ';

Line 886: -- hr_utility.set_message(8301,'GHR_38211_NOA_FAMILY_NOTFOUND');

882: open csr_get_routing_details;
883: fetch csr_get_routing_details into l_action_taken1;
884: if csr_get_routing_details%notfound then
885: null;
886: -- hr_utility.set_message(8301,'GHR_38211_NOA_FAMILY_NOTFOUND');
887: -- hr_utility.raise_error;
888: end if;
889: close csr_get_routing_details;
890: --

Line 887: -- hr_utility.raise_error;

883: fetch csr_get_routing_details into l_action_taken1;
884: if csr_get_routing_details%notfound then
885: null;
886: -- hr_utility.set_message(8301,'GHR_38211_NOA_FAMILY_NOTFOUND');
887: -- hr_utility.raise_error;
888: end if;
889: close csr_get_routing_details;
890: --
891: open csr_get_initiated_date;

Line 895: -- hr_utility.set_message(8301,'GHR_38211_NOA_FAMILY_NOTFOUND');

891: open csr_get_initiated_date;
892: fetch csr_get_initiated_date into l_date_notification_sent, l_creation_date;
893: if csr_get_initiated_date%notfound then
894: null;
895: -- hr_utility.set_message(8301,'GHR_38211_NOA_FAMILY_NOTFOUND');
896: -- hr_utility.raise_error;
897: end if;
898: close csr_get_initiated_date;
899: --

Line 896: -- hr_utility.raise_error;

892: fetch csr_get_initiated_date into l_date_notification_sent, l_creation_date;
893: if csr_get_initiated_date%notfound then
894: null;
895: -- hr_utility.set_message(8301,'GHR_38211_NOA_FAMILY_NOTFOUND');
896: -- hr_utility.raise_error;
897: end if;
898: close csr_get_initiated_date;
899: --
900: if l_request_number is Null then

Line 924: -- hr_utility.set_message(8301,'GHR_38211_NOA_FAMILY_NOTFOUND');

920: fetch csr_from_org_details into l_from_organization_name;
921: if csr_from_org_details%notfound then
922: null;
923: -- ?? Check with ****
924: -- hr_utility.set_message(8301,'GHR_38211_NOA_FAMILY_NOTFOUND');
925: -- hr_utility.raise_error;
926: end if;
927: close csr_from_org_details;
928: else

Line 925: -- hr_utility.raise_error;

921: if csr_from_org_details%notfound then
922: null;
923: -- ?? Check with ****
924: -- hr_utility.set_message(8301,'GHR_38211_NOA_FAMILY_NOTFOUND');
925: -- hr_utility.raise_error;
926: end if;
927: close csr_from_org_details;
928: else
929: open csr_org_details;

Line 934: -- hr_utility.set_message(8301,'GHR_38211_NOA_FAMILY_NOTFOUND');

930: fetch csr_org_details into l_to_organization_name;
931: if csr_org_details%notfound then
932: null;
933: -- ?? Check with ****
934: -- hr_utility.set_message(8301,'GHR_38211_NOA_FAMILY_NOTFOUND');
935: -- hr_utility.raise_error;
936: end if;
937: close csr_org_details;
938: end if;

Line 935: -- hr_utility.raise_error;

931: if csr_org_details%notfound then
932: null;
933: -- ?? Check with ****
934: -- hr_utility.set_message(8301,'GHR_38211_NOA_FAMILY_NOTFOUND');
935: -- hr_utility.raise_error;
936: end if;
937: close csr_org_details;
938: end if;
939: --

Line 1133: hr_utility.set_message(8301,'GHR_38154_INVALID_PRIMARY_KEY');

1129: if funcmode = 'RUN' then
1130: open csr_parh;
1131: fetch csr_parh into l_action_taken;
1132: if csr_parh%notfound then
1133: hr_utility.set_message(8301,'GHR_38154_INVALID_PRIMARY_KEY');
1134: hr_utility.raise_error;
1135: end if;
1136: close csr_parh;
1137: --

Line 1134: hr_utility.raise_error;

1130: open csr_parh;
1131: fetch csr_parh into l_action_taken;
1132: if csr_parh%notfound then
1133: hr_utility.set_message(8301,'GHR_38154_INVALID_PRIMARY_KEY');
1134: hr_utility.raise_error;
1135: end if;
1136: close csr_parh;
1137: --
1138: if l_action_taken in ('ENDED','UPDATE_HR_COMPLETE') then