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 62: hr_utility.set_location('l_proc',6);

58: aname => 'FORWARD_FROM_DISPLAY_NAME',
59: avalue => FND_GLOBAL.USER_NAME() );
60: -- Bug # 8597583 modified parameters to pass with out double quotes
61:
62: hr_utility.set_location('l_proc',6);
63: l_load_form := 'GHRWS52L:p_pa_request_id=' || l_Itemkey
64: || ' p_inbox_query_only=NO' || ' WORKFLOW_NAME=GHR_US_PA_REQUEST'
65: || ' p_wf_notification_id=&#NID';--Bug# 6923642
66: wf_engine.SetItemAttrText( itemtype => l_itemtype,

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

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

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

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

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

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

Line 269: -- hr_utility.raise_error;

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

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

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

Line 280: -- hr_utility.raise_error;

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

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

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

Line 647: -- hr_utility.raise_error;

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

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

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

Line 659: -- hr_utility.raise_error;

655: if csr_pah_details%notfound then
656: null;
657: -- ?? Check with ****
658: -- hr_utility.set_message(8301,'GHR_38211_NOA_FAMILY_NOTFOUND');
659: -- hr_utility.raise_error;
660: end if;
661: close csr_pah_details;
662: --
663: --

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

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

Line 675: -- hr_utility.raise_error;

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

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

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

Line 822: -- hr_utility.raise_error;

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

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

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

Line 855: -- hr_utility.raise_error;

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

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

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

Line 879: -- hr_utility.raise_error;

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

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

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

Line 891: -- hr_utility.raise_error;

887: fetch csr_get_routing_details into l_action_taken1;
888: if csr_get_routing_details%notfound then
889: null;
890: -- hr_utility.set_message(8301,'GHR_38211_NOA_FAMILY_NOTFOUND');
891: -- hr_utility.raise_error;
892: end if;
893: close csr_get_routing_details;
894: --
895: open csr_get_initiated_date;

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

895: open csr_get_initiated_date;
896: fetch csr_get_initiated_date into l_date_notification_sent, l_creation_date;
897: if csr_get_initiated_date%notfound then
898: null;
899: -- hr_utility.set_message(8301,'GHR_38211_NOA_FAMILY_NOTFOUND');
900: -- hr_utility.raise_error;
901: end if;
902: close csr_get_initiated_date;
903: --

Line 900: -- hr_utility.raise_error;

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

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

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

Line 929: -- hr_utility.raise_error;

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

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

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

Line 939: -- hr_utility.raise_error;

935: if csr_org_details%notfound then
936: null;
937: -- ?? Check with ****
938: -- hr_utility.set_message(8301,'GHR_38211_NOA_FAMILY_NOTFOUND');
939: -- hr_utility.raise_error;
940: end if;
941: close csr_org_details;
942: end if;
943: --

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

1149: if funcmode = 'RUN' then
1150: open csr_parh;
1151: fetch csr_parh into l_action_taken;
1152: if csr_parh%notfound then
1153: hr_utility.set_message(8301,'GHR_38154_INVALID_PRIMARY_KEY');
1154: hr_utility.raise_error;
1155: end if;
1156: close csr_parh;
1157: --

Line 1154: hr_utility.raise_error;

1150: open csr_parh;
1151: fetch csr_parh into l_action_taken;
1152: if csr_parh%notfound then
1153: hr_utility.set_message(8301,'GHR_38154_INVALID_PRIMARY_KEY');
1154: hr_utility.raise_error;
1155: end if;
1156: close csr_parh;
1157: --
1158: if l_action_taken in ('ENDED','UPDATE_HR_COMPLETE') then