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

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

26: WHERE pa_request_id =p_pa_request_id;
27:
28: BEGIN
29:
30: hr_utility.set_location('Entering ' || l_proc,5);
31: p_object_version_number := Null;
32: p_pa_notification_id := Null;
33:
34: for cur_rpa_rec in cur_rpa loop

Line 35: hr_utility.set_location( l_proc,10);

31: p_object_version_number := Null;
32: p_pa_notification_id := Null;
33:
34: for cur_rpa_rec in cur_rpa loop
35: hr_utility.set_location( l_proc,10);
36: p_object_version_number := cur_rpa_rec.object_version_number;
37: p_pa_notification_id := cur_rpa_rec.pa_notification_id;
38: p_rpa_type := cur_rpa_rec.rpa_type;
39: end loop;

Line 40: hr_utility.set_location('pa_requst_id value ' || to_char(p_pa_request_id) ,15);

36: p_object_version_number := cur_rpa_rec.object_version_number;
37: p_pa_notification_id := cur_rpa_rec.pa_notification_id;
38: p_rpa_type := cur_rpa_rec.rpa_type;
39: end loop;
40: hr_utility.set_location('pa_requst_id value ' || to_char(p_pa_request_id) ,15);
41: hr_utility.set_location('pa_notifn_id value ' || to_char(p_pa_notification_id),15);
42: hr_utility.set_location('pa_rpa_type value ' || p_rpa_type,15);
43: hr_utility.set_location('pa_ovn value ' || to_char(p_object_version_number),15);
44: hr_utility.set_location('Leaving ' || l_proc,15);

Line 41: hr_utility.set_location('pa_notifn_id value ' || to_char(p_pa_notification_id),15);

37: p_pa_notification_id := cur_rpa_rec.pa_notification_id;
38: p_rpa_type := cur_rpa_rec.rpa_type;
39: end loop;
40: hr_utility.set_location('pa_requst_id value ' || to_char(p_pa_request_id) ,15);
41: hr_utility.set_location('pa_notifn_id value ' || to_char(p_pa_notification_id),15);
42: hr_utility.set_location('pa_rpa_type value ' || p_rpa_type,15);
43: hr_utility.set_location('pa_ovn value ' || to_char(p_object_version_number),15);
44: hr_utility.set_location('Leaving ' || l_proc,15);
45:

Line 42: hr_utility.set_location('pa_rpa_type value ' || p_rpa_type,15);

38: p_rpa_type := cur_rpa_rec.rpa_type;
39: end loop;
40: hr_utility.set_location('pa_requst_id value ' || to_char(p_pa_request_id) ,15);
41: hr_utility.set_location('pa_notifn_id value ' || to_char(p_pa_notification_id),15);
42: hr_utility.set_location('pa_rpa_type value ' || p_rpa_type,15);
43: hr_utility.set_location('pa_ovn value ' || to_char(p_object_version_number),15);
44: hr_utility.set_location('Leaving ' || l_proc,15);
45:
46: EXCEPTION

Line 43: hr_utility.set_location('pa_ovn value ' || to_char(p_object_version_number),15);

39: end loop;
40: hr_utility.set_location('pa_requst_id value ' || to_char(p_pa_request_id) ,15);
41: hr_utility.set_location('pa_notifn_id value ' || to_char(p_pa_notification_id),15);
42: hr_utility.set_location('pa_rpa_type value ' || p_rpa_type,15);
43: hr_utility.set_location('pa_ovn value ' || to_char(p_object_version_number),15);
44: hr_utility.set_location('Leaving ' || l_proc,15);
45:
46: EXCEPTION
47: WHEN others THEN

Line 44: hr_utility.set_location('Leaving ' || l_proc,15);

40: hr_utility.set_location('pa_requst_id value ' || to_char(p_pa_request_id) ,15);
41: hr_utility.set_location('pa_notifn_id value ' || to_char(p_pa_notification_id),15);
42: hr_utility.set_location('pa_rpa_type value ' || p_rpa_type,15);
43: hr_utility.set_location('pa_ovn value ' || to_char(p_object_version_number),15);
44: hr_utility.set_location('Leaving ' || l_proc,15);
45:
46: EXCEPTION
47: WHEN others THEN
48: -- Reset IN OUT parameters and set OUT parameters

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

48: -- Reset IN OUT parameters and set OUT parameters
49:
50: p_pa_notification_id :=NULL;
51: p_object_version_number :=NULL;
52: hr_utility.set_location('Leaving ' || l_proc,20);
53: RAISE;
54:
55: END get_pa_request_id_ovn;
56:

Line 92: hr_utility.set_location('Entering ' || l_proc,5);

88: WHERE information_type = l_information_type
89: AND pa_request_id = p_pa_request_id;
90: l_pa_rei_id number;
91: BEGIN
92: hr_utility.set_location('Entering ' || l_proc,5);
93: IF p_noa_action ='472' THEN
94: l_information_type := 'GHR_US_PAR_LWOP_INFO';
95: l_employment_type := 'F';
96: ELSIF p_noa_action ='292' THEN

Line 106: hr_utility.set_location( l_proc,10);

102: l_employment_type := l_pei_extra_info.pei_information4;
103: END IF;
104: FOR cur_rpa_ei_rec in cur_rpa_ei(p_pa_request_id)
105: LOOP
106: hr_utility.set_location( l_proc,10);
107: l_pa_request_extra_info_id := cur_rpa_ei_rec.pa_request_extra_info_id;
108: l_pa_object_version_number := cur_rpa_ei_rec.object_version_number;
109: exit;
110: END LOOP;

Line 114: hr_utility.set_location( l_proc,11);

110: END LOOP;
111:
112: FOR cur_rpa_ei_shadow_rec in cur_rpa_ei_shadow(p_pa_request_id)
113: LOOP
114: hr_utility.set_location( l_proc,11);
115: l_pa_request_extra_info_sh_id := cur_rpa_ei_shadow_rec.pa_request_extra_info_id;
116: exit;
117: END LOOP;
118:

Line 119: hr_utility.set_location(l_proc,40);

115: l_pa_request_extra_info_sh_id := cur_rpa_ei_shadow_rec.pa_request_extra_info_id;
116: exit;
117: END LOOP;
118:
119: hr_utility.set_location(l_proc,40);
120: IF l_pa_request_extra_info_id is null then
121: hr_utility.set_location(l_proc,45);
122: IF p_noa_action ='472' THEN
123: hr_utility.set_location( l_proc,12);

Line 121: hr_utility.set_location(l_proc,45);

117: END LOOP;
118:
119: hr_utility.set_location(l_proc,40);
120: IF l_pa_request_extra_info_id is null then
121: hr_utility.set_location(l_proc,45);
122: IF p_noa_action ='472' THEN
123: hr_utility.set_location( l_proc,12);
124: ghr_par_extra_info_api.create_pa_request_extra_info
125: (p_validate => false,

Line 123: hr_utility.set_location( l_proc,12);

119: hr_utility.set_location(l_proc,40);
120: IF l_pa_request_extra_info_id is null then
121: hr_utility.set_location(l_proc,45);
122: IF p_noa_action ='472' THEN
123: hr_utility.set_location( l_proc,12);
124: ghr_par_extra_info_api.create_pa_request_extra_info
125: (p_validate => false,
126: p_pa_request_id => p_pa_request_id,
127: p_information_type => l_information_type,

Line 134: hr_utility.set_location( l_proc,13);

130: p_pa_request_extra_info_id => l_pa_rei_id,
131: p_object_version_number => l_dummy
132: );
133: ELSIF p_noa_action ='292' THEN
134: hr_utility.set_location( l_proc,13);
135: ghr_par_extra_info_api.create_pa_request_extra_info
136: (p_validate => false,
137: p_pa_request_id => p_pa_request_id,
138: p_information_type => l_information_type,

Line 146: hr_utility.set_location(l_proc,14);

142: p_object_version_number => l_dummy
143: );
144: END IF;
145: ELSE
146: hr_utility.set_location(l_proc,14);
147: IF p_noa_action ='472' THEN
148: ghr_par_extra_info_api.update_pa_request_extra_info
149: (p_validate => false,
150: p_rei_information3 => l_Employment_type,

Line 162: hr_utility.set_location( l_proc,15);

158: p_object_version_number => l_pa_object_version_number);
159: END IF;
160: END IF;
161: IF l_pa_request_extra_info_sh_id is null then
162: hr_utility.set_location( l_proc,15);
163: IF p_noa_action ='472' THEN
164: insert into ghr_pa_request_ei_shadow
165: (pa_request_extra_info_id,
166: pa_request_id,

Line 186: hr_utility.set_location( l_proc,16);

182: l_employment_type);
183: END IF;
184:
185: ELSE
186: hr_utility.set_location( l_proc,16);
187: IF p_noa_action ='472' THEN
188: update ghr_pa_request_ei_shadow
189: set rei_information3 = l_employment_type
190: where pa_request_extra_info_id = l_pa_request_extra_info_sh_id;

Line 201: hr_utility.set_location('Error in ghr_par_extra info.create pa req'||

197:
198: EXCEPTION
199:
200: when others then
201: hr_utility.set_location('Error in ghr_par_extra info.create pa req'||
202: ' Sql Err is '|| sqlerrm(sqlcode) || l_proc, 60);
203:
204: END refresh_ei_details;
205:

Line 402: hr_utility.set_location('Entering ' || l_proc,5);

398: WHERE pay_plan = p_pay_plan;
399:
400: BEGIN
401:
402: hr_utility.set_location('Entering ' || l_proc,5);
403: p_first_lac1_record := Null;
404: p_first_lac2_record := Null;
405:
406: IF p_noa_action IN ('472','772') THEN

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

418: p_first_lac1_record.first_action_la_code1 := 'CGM';
419: p_first_lac1_record.first_action_la_desc1 := ghr_pa_requests_pkg.get_lookup_description(800,'GHR_US_LEGAL_AUTHORITY','CGM');
420:
421: END IF;
422: hr_utility.set_location('Leaving ' || l_proc,20);
423:
424: EXCEPTION
425: WHEN others THEN
426: p_first_lac1_record := Null;

Line 428: hr_utility.set_location('Leaving ' || l_proc,25);

424: EXCEPTION
425: WHEN others THEN
426: p_first_lac1_record := Null;
427: p_first_lac2_record := Null;
428: hr_utility.set_location('Leaving ' || l_proc,25);
429: RAISE;
430: END get_furlough_rtd_lac;
431:
432: Procedure create_remarks

Line 457: hr_utility.set_location('Entering ' || l_proc,5);

453: l_p_pa_remark_id ghr_pa_remarks.remark_id%type;
454: l_p_object_version_number ghr_pa_remarks.object_version_number%type;
455:
456: begin
457: hr_utility.set_location('Entering ' || l_proc,5);
458: IF p_noa_action IN ('472','772') THEN
459: hr_utility.set_location('Remarks creation for 472, 772 '||l_proc,111);
460:
461: IF p_noa_action IN ('472') THEN

Line 459: hr_utility.set_location('Remarks creation for 472, 772 '||l_proc,111);

455:
456: begin
457: hr_utility.set_location('Entering ' || l_proc,5);
458: IF p_noa_action IN ('472','772') THEN
459: hr_utility.set_location('Remarks creation for 472, 772 '||l_proc,111);
460:
461: IF p_noa_action IN ('472') THEN
462: ghr_mass_actions_pkg.get_remark_id_desc
463: (p_remark_code => 'M72',

Line 549: hr_utility.set_location('Remarks creation for 292'||l_proc,111);

545: );
546:
547: END IF;
548: ELSIF p_noa_action ='292' THEN
549: hr_utility.set_location('Remarks creation for 292'||l_proc,111);
550: IF p_prd IN ('A','B','E','F','U','V') THEN
551: ghr_mass_actions_pkg.get_remark_id_desc
552: (p_remark_code => 'X45',
553: p_effective_date => p_effective_date,

Line 589: hr_utility.set_location('Leaving ' || l_proc,5);

585: ,p_object_version_number => l_p_object_version_number
586: );
587: END IF;
588: END IF;
589: hr_utility.set_location('Leaving ' || l_proc,5);
590: end create_remarks;
591:
592: procedure marpa_process
593: (

Line 634: hr_utility.set_location('Entering ...' || l_proc,120);

630:
631: l_approval_date := sysdate;
632: l_1_approval_status := 'APPROVE';
633:
634: hr_utility.set_location('Entering ...' || l_proc,120);
635: hr_utility.set_location('Noa_family_code value ' || l_pa_request_rec.noa_family_code,120);
636: get_pa_request_id_ovn
637: ( p_pa_request_id => l_pa_request_rec.pa_request_id,
638: p_effective_date => p_effective_date,

Line 635: hr_utility.set_location('Noa_family_code value ' || l_pa_request_rec.noa_family_code,120);

631: l_approval_date := sysdate;
632: l_1_approval_status := 'APPROVE';
633:
634: hr_utility.set_location('Entering ...' || l_proc,120);
635: hr_utility.set_location('Noa_family_code value ' || l_pa_request_rec.noa_family_code,120);
636: get_pa_request_id_ovn
637: ( p_pa_request_id => l_pa_request_rec.pa_request_id,
638: p_effective_date => p_effective_date,
639: p_person_id => p_person_id,

Line 647: hr_utility.set_location(l_proc,130);

643:
644:
645: IF l_pa_notification_id is null then
646: IF l_pa_request_rec.pa_request_id is null THEN
647: hr_utility.set_location(l_proc,130);
648: begin
649: l_log_text := p_noa_action || '-Error while creating the PA Request Rec. ';
650: g_log_text := p_noa_action || '-Error while creating the PA Request Rec. ';
651: ghr_sf52_api.create_sf52

Line 810: hr_utility.set_location( l_proc,131);

806: ,p_approval_date => l_approval_date
807: ,p_approving_official_work_titl => l_pa_request_rec.approving_official_work_title
808: ,p_1_approval_status => l_1_approval_status
809: );
810: hr_utility.set_location( l_proc,131);
811: exception
812: WHEN OTHERS THEN
813: hr_utility.set_location( ' create_sf52 Sql error : '||sqlerrm(sqlcode) ,132);
814: hr_utility.set_location(l_proc,132);

Line 813: hr_utility.set_location( ' create_sf52 Sql error : '||sqlerrm(sqlcode) ,132);

809: );
810: hr_utility.set_location( l_proc,131);
811: exception
812: WHEN OTHERS THEN
813: hr_utility.set_location( ' create_sf52 Sql error : '||sqlerrm(sqlcode) ,132);
814: hr_utility.set_location(l_proc,132);
815: l_log_text := substr(l_log_text || ' Sql error : '|| sqlerrm(sqlcode),1,2000);
816: g_log_text := substr(l_log_text || ' Sql error : '|| sqlerrm(sqlcode),1,2000);
817: raise ma_rpaerror;

Line 814: hr_utility.set_location(l_proc,132);

810: hr_utility.set_location( l_proc,131);
811: exception
812: WHEN OTHERS THEN
813: hr_utility.set_location( ' create_sf52 Sql error : '||sqlerrm(sqlcode) ,132);
814: hr_utility.set_location(l_proc,132);
815: l_log_text := substr(l_log_text || ' Sql error : '|| sqlerrm(sqlcode),1,2000);
816: g_log_text := substr(l_log_text || ' Sql error : '|| sqlerrm(sqlcode),1,2000);
817: raise ma_rpaerror;
818: end;

Line 820: hr_utility.set_location(l_proc,135);

816: g_log_text := substr(l_log_text || ' Sql error : '|| sqlerrm(sqlcode),1,2000);
817: raise ma_rpaerror;
818: end;
819:
820: hr_utility.set_location(l_proc,135);
821: begin
822: l_log_text := p_noa_action || '-Error After creating the RPA before upd ';
823: g_log_text := p_noa_action || '-Error After creating the RPA before upd ';
824: ghr_par_upd.upd(

Line 833: hr_utility.set_location(l_proc,136);

829: p_personnel_office_id => l_pa_request_rec.personnel_office_id,
830: p_from_office_symbol => l_pa_request_rec.from_office_symbol);
831: exception
832: WHEN OTHERS THEN
833: hr_utility.set_location(l_proc,136);
834: l_log_text := l_log_text || ' Sql error : '||sqlerrm(sqlcode);
835: g_log_text := l_log_text || ' Sql error : '||sqlerrm(sqlcode);
836: raise ma_rpaerror;
837: end;

Line 839: hr_utility.set_location(l_proc,138);

835: g_log_text := l_log_text || ' Sql error : '||sqlerrm(sqlcode);
836: raise ma_rpaerror;
837: end;
838:
839: hr_utility.set_location(l_proc,138);
840: create_shadow_row (p_rpa_data => l_pa_request_rec);
841: hr_utility.set_location(' Shadow created ...'|| l_proc,138);
842:
843: IF p_noa_action IN ('472','292') THEN

Line 841: hr_utility.set_location(' Shadow created ...'|| l_proc,138);

837: end;
838:
839: hr_utility.set_location(l_proc,138);
840: create_shadow_row (p_rpa_data => l_pa_request_rec);
841: hr_utility.set_location(' Shadow created ...'|| l_proc,138);
842:
843: IF p_noa_action IN ('472','292') THEN
844: hr_utility.set_location('Calling refresh_ei_details '||l_proc,140);
845: refresh_ei_details

Line 844: hr_utility.set_location('Calling refresh_ei_details '||l_proc,140);

840: create_shadow_row (p_rpa_data => l_pa_request_rec);
841: hr_utility.set_location(' Shadow created ...'|| l_proc,138);
842:
843: IF p_noa_action IN ('472','292') THEN
844: hr_utility.set_location('Calling refresh_ei_details '||l_proc,140);
845: refresh_ei_details
846: (
847: p_noa_action => p_noa_action,
848: p_effective_date => p_effective_date,

Line 853: hr_utility.set_location(l_proc,141);

849: p_person_id => p_person_id,
850: p_pa_request_id => l_pa_request_rec.pa_request_id );
851: END IF;
852: ELSE -- IF l_pa_request_id is null
853: hr_utility.set_location(l_proc,141);
854:
855: hr_utility.set_location(l_proc || 'pa_request_id ' || to_char(l_pa_request_id),150);
856: hr_utility.set_location(l_proc || 'Object version ' || to_char(l_object_version_number),151);
857:

Line 855: hr_utility.set_location(l_proc || 'pa_request_id ' || to_char(l_pa_request_id),150);

851: END IF;
852: ELSE -- IF l_pa_request_id is null
853: hr_utility.set_location(l_proc,141);
854:
855: hr_utility.set_location(l_proc || 'pa_request_id ' || to_char(l_pa_request_id),150);
856: hr_utility.set_location(l_proc || 'Object version ' || to_char(l_object_version_number),151);
857:
858: begin
859: l_log_text := 'Error while Updating the PA Request Rec. ';

Line 856: hr_utility.set_location(l_proc || 'Object version ' || to_char(l_object_version_number),151);

852: ELSE -- IF l_pa_request_id is null
853: hr_utility.set_location(l_proc,141);
854:
855: hr_utility.set_location(l_proc || 'pa_request_id ' || to_char(l_pa_request_id),150);
856: hr_utility.set_location(l_proc || 'Object version ' || to_char(l_object_version_number),151);
857:
858: begin
859: l_log_text := 'Error while Updating the PA Request Rec. ';
860: g_log_text := 'Error while Updating the PA Request Rec. ';

Line 861: hr_utility.set_location( l_proc,132);

857:
858: begin
859: l_log_text := 'Error while Updating the PA Request Rec. ';
860: g_log_text := 'Error while Updating the PA Request Rec. ';
861: hr_utility.set_location( l_proc,132);
862: ghr_sf52_api.update_sf52
863: (
864: p_pa_request_id => l_pa_request_id,
865: p_noa_family_code => l_pa_request_rec.noa_family_code,

Line 1049: hr_utility.set_location( l_proc,133);

1045: p_i_pa_routing_history_id => l_i_pa_routing_history_id,
1046: p_i_prh_object_version_number => l_i_prh_object_version_number,
1047: p_award_salary => l_pa_request_rec.award_salary
1048: );
1049: hr_utility.set_location( l_proc,133);
1050: exception
1051: WHEN OTHERS THEN
1052: hr_utility.set_location( l_proc,134);
1053: hr_utility.set_location(l_proc,153);

Line 1052: hr_utility.set_location( l_proc,134);

1048: );
1049: hr_utility.set_location( l_proc,133);
1050: exception
1051: WHEN OTHERS THEN
1052: hr_utility.set_location( l_proc,134);
1053: hr_utility.set_location(l_proc,153);
1054: l_log_text := l_log_text || ' update_sf52 Sql error : '||sqlerrm(sqlcode);
1055: g_log_text := l_log_text || ' update_sf52 Sql error : '||sqlerrm(sqlcode);
1056: raise ma_rpaerror;

Line 1053: hr_utility.set_location(l_proc,153);

1049: hr_utility.set_location( l_proc,133);
1050: exception
1051: WHEN OTHERS THEN
1052: hr_utility.set_location( l_proc,134);
1053: hr_utility.set_location(l_proc,153);
1054: l_log_text := l_log_text || ' update_sf52 Sql error : '||sqlerrm(sqlcode);
1055: g_log_text := l_log_text || ' update_sf52 Sql error : '||sqlerrm(sqlcode);
1056: raise ma_rpaerror;
1057: end;

Line 1059: hr_utility.set_location('u ovn ' || to_char(l_u_prh_object_version_number),154);

1055: g_log_text := l_log_text || ' update_sf52 Sql error : '||sqlerrm(sqlcode);
1056: raise ma_rpaerror;
1057: end;
1058:
1059: hr_utility.set_location('u ovn ' || to_char(l_u_prh_object_version_number),154);
1060: hr_utility.set_location('prh id ' || to_char(l_i_pa_routing_history_id),154);
1061: hr_utility.set_location('prh ovn ' || to_char(l_i_prh_object_version_number),154);
1062: hr_utility.set_location('par upd ' || to_char(l_object_version_number),154);
1063: hr_utility.set_location('par upd ' || to_char(l_pa_request_id),155);

Line 1060: hr_utility.set_location('prh id ' || to_char(l_i_pa_routing_history_id),154);

1056: raise ma_rpaerror;
1057: end;
1058:
1059: hr_utility.set_location('u ovn ' || to_char(l_u_prh_object_version_number),154);
1060: hr_utility.set_location('prh id ' || to_char(l_i_pa_routing_history_id),154);
1061: hr_utility.set_location('prh ovn ' || to_char(l_i_prh_object_version_number),154);
1062: hr_utility.set_location('par upd ' || to_char(l_object_version_number),154);
1063: hr_utility.set_location('par upd ' || to_char(l_pa_request_id),155);
1064: hr_utility.set_location(l_proc,156);

Line 1061: hr_utility.set_location('prh ovn ' || to_char(l_i_prh_object_version_number),154);

1057: end;
1058:
1059: hr_utility.set_location('u ovn ' || to_char(l_u_prh_object_version_number),154);
1060: hr_utility.set_location('prh id ' || to_char(l_i_pa_routing_history_id),154);
1061: hr_utility.set_location('prh ovn ' || to_char(l_i_prh_object_version_number),154);
1062: hr_utility.set_location('par upd ' || to_char(l_object_version_number),154);
1063: hr_utility.set_location('par upd ' || to_char(l_pa_request_id),155);
1064: hr_utility.set_location(l_proc,156);
1065: begin

Line 1062: hr_utility.set_location('par upd ' || to_char(l_object_version_number),154);

1058:
1059: hr_utility.set_location('u ovn ' || to_char(l_u_prh_object_version_number),154);
1060: hr_utility.set_location('prh id ' || to_char(l_i_pa_routing_history_id),154);
1061: hr_utility.set_location('prh ovn ' || to_char(l_i_prh_object_version_number),154);
1062: hr_utility.set_location('par upd ' || to_char(l_object_version_number),154);
1063: hr_utility.set_location('par upd ' || to_char(l_pa_request_id),155);
1064: hr_utility.set_location(l_proc,156);
1065: begin
1066: l_log_text := p_noa_action || '-Error After updating the RPA before upd ';

Line 1063: hr_utility.set_location('par upd ' || to_char(l_pa_request_id),155);

1059: hr_utility.set_location('u ovn ' || to_char(l_u_prh_object_version_number),154);
1060: hr_utility.set_location('prh id ' || to_char(l_i_pa_routing_history_id),154);
1061: hr_utility.set_location('prh ovn ' || to_char(l_i_prh_object_version_number),154);
1062: hr_utility.set_location('par upd ' || to_char(l_object_version_number),154);
1063: hr_utility.set_location('par upd ' || to_char(l_pa_request_id),155);
1064: hr_utility.set_location(l_proc,156);
1065: begin
1066: l_log_text := p_noa_action || '-Error After updating the RPA before upd ';
1067: g_log_text := p_noa_action || '-Error After updating the RPA before upd ';

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

1060: hr_utility.set_location('prh id ' || to_char(l_i_pa_routing_history_id),154);
1061: hr_utility.set_location('prh ovn ' || to_char(l_i_prh_object_version_number),154);
1062: hr_utility.set_location('par upd ' || to_char(l_object_version_number),154);
1063: hr_utility.set_location('par upd ' || to_char(l_pa_request_id),155);
1064: hr_utility.set_location(l_proc,156);
1065: begin
1066: l_log_text := p_noa_action || '-Error After updating the RPA before upd ';
1067: g_log_text := p_noa_action || '-Error After updating the RPA before upd ';
1068: ghr_par_upd.upd(

Line 1077: hr_utility.set_location(l_proc,153);

1073: p_personnel_office_id => l_pa_request_rec.personnel_office_id,
1074: p_from_office_symbol => l_pa_request_rec.from_office_symbol);
1075: exception
1076: WHEN OTHERS THEN
1077: hr_utility.set_location(l_proc,153);
1078: l_log_text := l_log_text || ' Sql error : '||sqlerrm(sqlcode);
1079: g_log_text := l_log_text || ' Sql error : '||sqlerrm(sqlcode);
1080: raise ma_rpaerror;
1081: end;

Line 1083: hr_utility.set_location(l_proc,158);

1079: g_log_text := l_log_text || ' Sql error : '||sqlerrm(sqlcode);
1080: raise ma_rpaerror;
1081: end;
1082:
1083: hr_utility.set_location(l_proc,158);
1084:
1085: l_pa_request_rec.pa_request_id := l_pa_request_id;
1086: l_pa_request_rec.object_version_number := l_object_version_number;
1087: update_shadow_row (p_rpa_data => l_pa_request_rec,

Line 1090: hr_utility.set_location('Shadow updated ..'|| l_proc,158);

1086: l_pa_request_rec.object_version_number := l_object_version_number;
1087: update_shadow_row (p_rpa_data => l_pa_request_rec,
1088: p_result => l_result);
1089: if l_result then
1090: hr_utility.set_location('Shadow updated ..'|| l_proc,158);
1091: else
1092: hr_utility.set_location('Shadow not found..'|| l_proc,158);
1093: end if;
1094:

Line 1092: hr_utility.set_location('Shadow not found..'|| l_proc,158);

1088: p_result => l_result);
1089: if l_result then
1090: hr_utility.set_location('Shadow updated ..'|| l_proc,158);
1091: else
1092: hr_utility.set_location('Shadow not found..'|| l_proc,158);
1093: end if;
1094:
1095: hr_utility.set_location(l_proc,160);
1096: IF p_noa_action IN ('472','292') THEN

Line 1095: hr_utility.set_location(l_proc,160);

1091: else
1092: hr_utility.set_location('Shadow not found..'|| l_proc,158);
1093: end if;
1094:
1095: hr_utility.set_location(l_proc,160);
1096: IF p_noa_action IN ('472','292') THEN
1097: refresh_ei_details
1098: (
1099: p_noa_action => p_noa_action,

Line 1107: hr_utility.set_location('Leaving ...' || l_proc,161);

1103: END IF;
1104: p_pa_request_rec := l_pa_request_rec;
1105: p_log_text := l_log_text;
1106:
1107: hr_utility.set_location('Leaving ...' || l_proc,161);
1108:
1109: END IF; --IF l_pa_request_id is null
1110: END IF; -- IF l_pa_notification_id is null then
1111: exception when ma_rpaerror then

Line 1118: hr_utility.set_location('Error in '||l_proc||' Err is '||sqlerrm(sqlcode),162);

1114: raise;
1115: when others then
1116: p_pa_request_rec := l_pa_request_rec;
1117: p_log_text := l_log_text;
1118: hr_utility.set_location('Error in '||l_proc||' Err is '||sqlerrm(sqlcode),162);
1119: l_log_text := p_noa_action || '-Error raised in marpa process others ';
1120: l_log_text := l_log_text || ' Sql error : '||sqlerrm(sqlcode);
1121: raise ma_rpaerror;
1122: end; --Begin 2

Line 1187: hr_utility.set_location('Entering '||l_proc ,5);

1183: WHERE prh.pa_request_id = l_pa_request_rec.pa_request_id
1184: ORDER by 1 desc;
1185:
1186: Begin
1187: hr_utility.set_location('Entering '||l_proc ,5);
1188: p_errbuf := Null;
1189: p_status := Null;
1190: p_retcode := Null;
1191:

Line 1192: hr_utility.set_location('Entering ' || l_proc,5);

1188: p_errbuf := Null;
1189: p_status := Null;
1190: p_retcode := Null;
1191:
1192: hr_utility.set_location('Entering ' || l_proc,5);
1193: l_savepoint := 'P';
1194: savepoint build_rpa_save_preview;
1195: hr_utility.set_location('savepoint build_rpa_save_preview ' || l_proc,5);
1196: -- The following would be null while creating rpa.

Line 1195: hr_utility.set_location('savepoint build_rpa_save_preview ' || l_proc,5);

1191:
1192: hr_utility.set_location('Entering ' || l_proc,5);
1193: l_savepoint := 'P';
1194: savepoint build_rpa_save_preview;
1195: hr_utility.set_location('savepoint build_rpa_save_preview ' || l_proc,5);
1196: -- The following would be null while creating rpa.
1197:
1198: l_pa_request_rec.additional_info_person_id := NULL;
1199: l_pa_request_rec.additional_info_tel_number := NULL;

Line 1221: hr_utility.set_location(l_proc,15);

1217: l_pa_request_rec.duty_station_location_id := p_location_id;
1218: l_pa_request_rec.first_noa_code := p_noa_action;
1219: l_pa_request_rec.first_noa_information1 := p_nte_date;
1220:
1221: hr_utility.set_location(l_proc,15);
1222: ghr_mass_actions_pkg.get_noa_id_desc
1223: (p_noa_code => l_pa_request_rec.first_noa_code,
1224: p_effective_date => l_pa_request_rec.effective_date,
1225: p_noa_id => l_pa_request_rec.first_noa_id,

Line 1231: hr_utility.set_location(l_proc,20);

1227: );
1228: l_pa_request_rec.noa_family_code := ghr_pa_requests_pkg.get_noa_pm_family
1229: (p_nature_of_action_id => l_pa_request_rec.first_noa_id);
1230:
1231: hr_utility.set_location(l_proc,20);
1232: ghr_pa_requests_pkg.get_person_details
1233: (p_person_id => p_person_id
1234: ,p_effective_date => p_effective_date
1235: ,p_national_identifier => l_pa_request_rec.employee_national_identifier

Line 1248: hr_utility.set_location(l_proc,25);

1244: (p_person_id => p_person_id,
1245: p_effective_date => p_effective_date);
1246: End if;
1247:
1248: hr_utility.set_location(l_proc,25);
1249: ghr_api.sf52_from_data_elements
1250: (p_person_id => p_person_id
1251: ,p_assignment_id => l_pa_request_rec.employee_assignment_id
1252: ,p_effective_date => p_effective_date

Line 1295: hr_utility.set_location(l_proc,30);

1291: ,p_pay_rate_determinant => l_pa_request_rec.pay_rate_determinant
1292: ,p_work_schedule => l_pa_request_rec.work_schedule
1293: );
1294:
1295: hr_utility.set_location(l_proc,30);
1296: l_pa_request_rec.duty_station_location_id := l_duty_station_location_id;
1297:
1298: ghr_pa_requests_pkg.get_SF52_loc_ddf_details
1299: (p_location_id => l_duty_station_location_id

Line 1360: hr_utility.set_location(l_proc,40);

1356: l_pa_request_rec.to_pay_basis := l_pa_request_rec.from_pay_basis;
1357: l_pa_request_rec.to_pay_plan := l_pa_request_rec.from_pay_plan;
1358: END IF;
1359:
1360: hr_utility.set_location(l_proc,40);
1361: ghr_pa_requests_pkg.get_sf52_pos_ddf_details
1362: (p_position_id => p_position_id
1363: ,p_date_Effective => l_pa_request_rec.effective_date
1364: ,p_flsa_category => l_pa_request_rec.flsa_category

Line 1377: hr_utility.set_location('POI ID ' || l_pa_request_rec.personnel_office_id ,42);

1373: ,p_office_symbol => l_pa_request_rec.from_office_symbol
1374: ,p_part_time_hours => l_dummy
1375: );
1376:
1377: hr_utility.set_location('POI ID ' || l_pa_request_rec.personnel_office_id ,42);
1378: hr_utility.set_location('From Pos ID ' || to_char(l_pa_request_rec.from_position_id) ,42);
1379: hr_utility.set_location('To Pos ID ' || to_char(l_pa_request_rec.to_position_id) ,42);
1380: hr_utility.set_location('Office Symbol ' || l_pa_request_rec.from_office_symbol ,42);
1381:

Line 1378: hr_utility.set_location('From Pos ID ' || to_char(l_pa_request_rec.from_position_id) ,42);

1374: ,p_part_time_hours => l_dummy
1375: );
1376:
1377: hr_utility.set_location('POI ID ' || l_pa_request_rec.personnel_office_id ,42);
1378: hr_utility.set_location('From Pos ID ' || to_char(l_pa_request_rec.from_position_id) ,42);
1379: hr_utility.set_location('To Pos ID ' || to_char(l_pa_request_rec.to_position_id) ,42);
1380: hr_utility.set_location('Office Symbol ' || l_pa_request_rec.from_office_symbol ,42);
1381:
1382: hr_utility.set_location(l_proc,45);

Line 1379: hr_utility.set_location('To Pos ID ' || to_char(l_pa_request_rec.to_position_id) ,42);

1375: );
1376:
1377: hr_utility.set_location('POI ID ' || l_pa_request_rec.personnel_office_id ,42);
1378: hr_utility.set_location('From Pos ID ' || to_char(l_pa_request_rec.from_position_id) ,42);
1379: hr_utility.set_location('To Pos ID ' || to_char(l_pa_request_rec.to_position_id) ,42);
1380: hr_utility.set_location('Office Symbol ' || l_pa_request_rec.from_office_symbol ,42);
1381:
1382: hr_utility.set_location(l_proc,45);
1383: hr_utility.set_location(l_proc,50);

Line 1380: hr_utility.set_location('Office Symbol ' || l_pa_request_rec.from_office_symbol ,42);

1376:
1377: hr_utility.set_location('POI ID ' || l_pa_request_rec.personnel_office_id ,42);
1378: hr_utility.set_location('From Pos ID ' || to_char(l_pa_request_rec.from_position_id) ,42);
1379: hr_utility.set_location('To Pos ID ' || to_char(l_pa_request_rec.to_position_id) ,42);
1380: hr_utility.set_location('Office Symbol ' || l_pa_request_rec.from_office_symbol ,42);
1381:
1382: hr_utility.set_location(l_proc,45);
1383: hr_utility.set_location(l_proc,50);
1384: l_pa_request_rec.agency_code := ghr_api.get_position_agency_code_pos

Line 1382: hr_utility.set_location(l_proc,45);

1378: hr_utility.set_location('From Pos ID ' || to_char(l_pa_request_rec.from_position_id) ,42);
1379: hr_utility.set_location('To Pos ID ' || to_char(l_pa_request_rec.to_position_id) ,42);
1380: hr_utility.set_location('Office Symbol ' || l_pa_request_rec.from_office_symbol ,42);
1381:
1382: hr_utility.set_location(l_proc,45);
1383: hr_utility.set_location(l_proc,50);
1384: l_pa_request_rec.agency_code := ghr_api.get_position_agency_code_pos
1385: (p_position_id => p_position_id
1386: ,p_business_group_id => p_business_group_id

Line 1383: hr_utility.set_location(l_proc,50);

1379: hr_utility.set_location('To Pos ID ' || to_char(l_pa_request_rec.to_position_id) ,42);
1380: hr_utility.set_location('Office Symbol ' || l_pa_request_rec.from_office_symbol ,42);
1381:
1382: hr_utility.set_location(l_proc,45);
1383: hr_utility.set_location(l_proc,50);
1384: l_pa_request_rec.agency_code := ghr_api.get_position_agency_code_pos
1385: (p_position_id => p_position_id
1386: ,p_business_group_id => p_business_group_id
1387: ,p_effective_date => p_effective_date);

Line 1389: hr_utility.set_location('Agency Code ' || l_pa_request_rec.agency_code ,52);

1385: (p_position_id => p_position_id
1386: ,p_business_group_id => p_business_group_id
1387: ,p_effective_date => p_effective_date);
1388:
1389: hr_utility.set_location('Agency Code ' || l_pa_request_rec.agency_code ,52);
1390:
1391: l_pa_request_rec.employee_dept_or_agency := ghr_pa_requests_pkg.get_lookup_meaning
1392: (800
1393: ,'GHR_US_AGENCY_CODE'

Line 1407: hr_utility.set_location(l_proc,60);

1403: p_veterans_status => l_pa_request_rec.veterans_status,
1404: p_scd_leave => l_scd_leave
1405: );
1406:
1407: hr_utility.set_location(l_proc,60);
1408: l_pa_request_rec.service_comp_date := fnd_date.canonical_to_date(l_scd_leave);
1409:
1410: -- get education details
1411: hr_utility.set_location(l_proc,70);

Line 1411: hr_utility.set_location(l_proc,70);

1407: hr_utility.set_location(l_proc,60);
1408: l_pa_request_rec.service_comp_date := fnd_date.canonical_to_date(l_scd_leave);
1409:
1410: -- get education details
1411: hr_utility.set_location(l_proc,70);
1412: ghr_api.return_education_Details
1413: (p_person_id => l_pa_request_rec.person_id,
1414: p_effective_date => l_pa_request_rec.effective_date,
1415: p_education_level => l_pa_request_rec.education_level,

Line 1420: hr_utility.set_location(l_proc,80);

1416: p_academic_discipline => l_pa_request_rec.academic_discipline,
1417: p_year_degree_attained => l_pa_request_rec.year_degree_attained
1418: );
1419:
1420: hr_utility.set_location(l_proc,80);
1421: ghr_pa_requests_pkg.get_SF52_asg_ddf_details
1422: (p_assignment_id => l_pa_request_rec.employee_assignment_id
1423: ,p_date_effective => l_pa_request_rec.effective_date
1424: ,p_tenure => l_pa_request_rec.tenure

Line 1446: hr_utility.set_location(l_proc,901);

1442: ,l_pa_request_rec.work_schedule
1443: );
1444: -- get fegli,retirement_plan
1445:
1446: hr_utility.set_location(l_proc,901);
1447: ghr_api.retrieve_element_entry_value
1448: (p_element_name => 'FEGLI'
1449: ,p_input_value_name => 'FEGLI'
1450: ,p_assignment_id => l_pa_request_rec.employee_assignment_id

Line 1462: hr_utility.set_location(l_proc,100);

1458: ,l_pa_request_rec.fegli
1459: );
1460:
1461: --retirement_plan
1462: hr_utility.set_location(l_proc,100);
1463: ghr_api.retrieve_element_entry_value
1464: (p_element_name => 'Retirement Plan'
1465: ,p_input_value_name => 'Plan'
1466: ,p_assignment_id => l_pa_request_rec.employee_assignment_id

Line 1487: hr_utility.set_location(l_proc,110);

1483: ,p_value => l_health_plan
1484: ,p_multiple_error_flag => l_multiple_error_flag
1485: );
1486: -- Descriptions for the codes passed in
1487: hr_utility.set_location(l_proc,110);
1488: ghr_mass_actions_pkg.get_personnel_officer_name
1489: (p_personnel_office_id => l_pa_request_rec.personnel_office_id,
1490: p_person_full_name => l_personnel_officer_name,
1491: p_approving_off_work_title => l_approving_off_work_title);

Line 1498: hr_utility.set_location('PA REQ ID ' || to_char(l_pa_request_rec.pa_request_id) ,110);

1494: l_pa_request_rec.approving_official_work_title := l_approving_off_work_title;
1495:
1496: l_pa_request_rec.request_number := l_pa_request_num_prefix ||to_char(l_pa_request_rec.pa_request_id);
1497:
1498: hr_utility.set_location('PA REQ ID ' || to_char(l_pa_request_rec.pa_request_id) ,110);
1499:
1500: l_pa_request_rec.sf50_approving_ofcl_full_name := l_personnel_officer_name;
1501: l_pa_request_rec.sf50_approval_date := sysdate;
1502: l_pa_request_rec.sf50_approving_ofcl_work_title := l_approving_off_work_title;

Line 1504: hr_utility.set_location('Noa_family_code value ' || l_pa_request_rec.noa_family_code,52);

1500: l_pa_request_rec.sf50_approving_ofcl_full_name := l_personnel_officer_name;
1501: l_pa_request_rec.sf50_approval_date := sysdate;
1502: l_pa_request_rec.sf50_approving_ofcl_work_title := l_approving_off_work_title;
1503:
1504: hr_utility.set_location('Noa_family_code value ' || l_pa_request_rec.noa_family_code,52);
1505: hr_utility.set_location('PA REQ ID ' || to_char(l_pa_request_rec.pa_request_id) ,52);
1506: hr_utility.set_location('PA OVN ' || to_char(l_pa_request_rec.object_version_number),52);
1507:
1508: get_furlough_rtd_lac

Line 1505: hr_utility.set_location('PA REQ ID ' || to_char(l_pa_request_rec.pa_request_id) ,52);

1501: l_pa_request_rec.sf50_approval_date := sysdate;
1502: l_pa_request_rec.sf50_approving_ofcl_work_title := l_approving_off_work_title;
1503:
1504: hr_utility.set_location('Noa_family_code value ' || l_pa_request_rec.noa_family_code,52);
1505: hr_utility.set_location('PA REQ ID ' || to_char(l_pa_request_rec.pa_request_id) ,52);
1506: hr_utility.set_location('PA OVN ' || to_char(l_pa_request_rec.object_version_number),52);
1507:
1508: get_furlough_rtd_lac
1509: (p_noa_action => p_noa_action,

Line 1506: hr_utility.set_location('PA OVN ' || to_char(l_pa_request_rec.object_version_number),52);

1502: l_pa_request_rec.sf50_approving_ofcl_work_title := l_approving_off_work_title;
1503:
1504: hr_utility.set_location('Noa_family_code value ' || l_pa_request_rec.noa_family_code,52);
1505: hr_utility.set_location('PA REQ ID ' || to_char(l_pa_request_rec.pa_request_id) ,52);
1506: hr_utility.set_location('PA OVN ' || to_char(l_pa_request_rec.object_version_number),52);
1507:
1508: get_furlough_rtd_lac
1509: (p_noa_action => p_noa_action,
1510: p_pay_plan => l_pa_request_rec.from_pay_plan,

Line 1539: hr_utility.set_location(' marpa_process calling ' || l_proc,52);

1535:
1536: l_pa_request_rec.first_noa_desc := l_first_noa_desc;
1537:
1538: begin
1539: hr_utility.set_location(' marpa_process calling ' || l_proc,52);
1540: marpa_process
1541: (p_noa_action => p_noa_action
1542: ,p_rpa_type => p_rpa_type
1543: ,p_effective_date => p_effective_date

Line 1550: hr_utility.set_location('savepoint build_rpa_save_preview - After Preview ' ,162);

1546: ,p_log_text => l_log_text
1547: );
1548: l_savepoint := 'P';
1549: savepoint build_rpa_save_preview;
1550: hr_utility.set_location('savepoint build_rpa_save_preview - After Preview ' ,162);
1551: exception
1552: when ma_rpaerror then
1553: raise;
1554: when others then

Line 1558: hr_utility.set_location(l_proc,163);

1554: when others then
1555: raise ma_rpaerror;
1556: end;
1557:
1558: hr_utility.set_location(l_proc,163);
1559:
1560: get_pa_request_id_ovn
1561: ( p_pa_request_id => l_pa_request_rec.pa_request_id,
1562: p_effective_date => p_effective_date,

Line 1568: hr_utility.set_location('PA REQ ID ' || to_char(l_pa_request_rec.pa_request_id) ,165);

1564: p_pa_notification_id => l_pa_notification_id,
1565: p_rpa_type => l_rpa_type,
1566: p_object_version_number => l_object_version_number);
1567:
1568: hr_utility.set_location('PA REQ ID ' || to_char(l_pa_request_rec.pa_request_id) ,165);
1569: hr_utility.set_location('PA OVN ' || to_char(l_pa_request_rec.object_version_number),165);
1570:
1571: IF l_pa_notification_id is null THEN
1572:

Line 1569: hr_utility.set_location('PA OVN ' || to_char(l_pa_request_rec.object_version_number),165);

1565: p_rpa_type => l_rpa_type,
1566: p_object_version_number => l_object_version_number);
1567:
1568: hr_utility.set_location('PA REQ ID ' || to_char(l_pa_request_rec.pa_request_id) ,165);
1569: hr_utility.set_location('PA OVN ' || to_char(l_pa_request_rec.object_version_number),165);
1570:
1571: IF l_pa_notification_id is null THEN
1572:
1573: if l_1_pa_routing_history_id is null then

Line 1581: hr_utility.set_location('Getting Group Box ' || l_proc,170);

1577: l_1_prh_object_version_number := l_i_prh_object_version_number;
1578: end if;
1579:
1580: begin
1581: hr_utility.set_location('Getting Group Box ' || l_proc,170);
1582:
1583: ghr_mass_actions_pkg.get_personnel_off_groupbox
1584: (p_position_id => p_position_id
1585: ,p_effective_date => p_effective_date

Line 1588: hr_utility.set_location('Getting Group Box Success ' || l_proc,170);

1584: (p_position_id => p_position_id
1585: ,p_effective_date => p_effective_date
1586: ,p_groupbox_id => l_groupbox_id
1587: ,p_routing_group_id => l_routing_group_id );
1588: hr_utility.set_location('Getting Group Box Success ' || l_proc,170);
1589: hr_utility.set_location('Routing Group Id ' || to_char(l_routing_group_id),170);
1590: hr_utility.set_location('Group Box Id' || to_char(l_groupbox_id),170);
1591:
1592: exception

Line 1589: hr_utility.set_location('Routing Group Id ' || to_char(l_routing_group_id),170);

1585: ,p_effective_date => p_effective_date
1586: ,p_groupbox_id => l_groupbox_id
1587: ,p_routing_group_id => l_routing_group_id );
1588: hr_utility.set_location('Getting Group Box Success ' || l_proc,170);
1589: hr_utility.set_location('Routing Group Id ' || to_char(l_routing_group_id),170);
1590: hr_utility.set_location('Group Box Id' || to_char(l_groupbox_id),170);
1591:
1592: exception
1593: WHEN OTHERS THEN

Line 1590: hr_utility.set_location('Group Box Id' || to_char(l_groupbox_id),170);

1586: ,p_groupbox_id => l_groupbox_id
1587: ,p_routing_group_id => l_routing_group_id );
1588: hr_utility.set_location('Getting Group Box Success ' || l_proc,170);
1589: hr_utility.set_location('Routing Group Id ' || to_char(l_routing_group_id),170);
1590: hr_utility.set_location('Group Box Id' || to_char(l_groupbox_id),170);
1591:
1592: exception
1593: WHEN OTHERS THEN
1594: hr_utility.set_location('Getting Group Box Failure ' || l_proc,170);

Line 1594: hr_utility.set_location('Getting Group Box Failure ' || l_proc,170);

1590: hr_utility.set_location('Group Box Id' || to_char(l_groupbox_id),170);
1591:
1592: exception
1593: WHEN OTHERS THEN
1594: hr_utility.set_location('Getting Group Box Failure ' || l_proc,170);
1595: l_log_text := 'Error in POI groupbox ' ||' Sql error : '||sqlerrm(sqlcode);
1596:
1597: raise groupboxerr;
1598: end;

Line 1606: hr_utility.set_location('Updating prh ' || l_proc,175);

1602: l_prh_object_version_number := routing_history_id.object_version_number;
1603: exit;
1604: end loop;
1605:
1606: hr_utility.set_location('Updating prh ' || l_proc,175);
1607: hr_utility.set_location('PA REQ ID ' || to_char(l_pa_request_rec.pa_request_id) ,175);
1608: hr_utility.set_location('PA OVN ' || to_char(l_pa_request_rec.object_version_number),175);
1609: hr_utility.set_location('RHVN ' || to_char(l_prh_object_version_number),176);
1610: hr_utility.set_location('RHID ' || to_char(l_pa_routing_history_id),177);

Line 1607: hr_utility.set_location('PA REQ ID ' || to_char(l_pa_request_rec.pa_request_id) ,175);

1603: exit;
1604: end loop;
1605:
1606: hr_utility.set_location('Updating prh ' || l_proc,175);
1607: hr_utility.set_location('PA REQ ID ' || to_char(l_pa_request_rec.pa_request_id) ,175);
1608: hr_utility.set_location('PA OVN ' || to_char(l_pa_request_rec.object_version_number),175);
1609: hr_utility.set_location('RHVN ' || to_char(l_prh_object_version_number),176);
1610: hr_utility.set_location('RHID ' || to_char(l_pa_routing_history_id),177);
1611:

Line 1608: hr_utility.set_location('PA OVN ' || to_char(l_pa_request_rec.object_version_number),175);

1604: end loop;
1605:
1606: hr_utility.set_location('Updating prh ' || l_proc,175);
1607: hr_utility.set_location('PA REQ ID ' || to_char(l_pa_request_rec.pa_request_id) ,175);
1608: hr_utility.set_location('PA OVN ' || to_char(l_pa_request_rec.object_version_number),175);
1609: hr_utility.set_location('RHVN ' || to_char(l_prh_object_version_number),176);
1610: hr_utility.set_location('RHID ' || to_char(l_pa_routing_history_id),177);
1611:
1612: ghr_prh_upd.upd(

Line 1609: hr_utility.set_location('RHVN ' || to_char(l_prh_object_version_number),176);

1605:
1606: hr_utility.set_location('Updating prh ' || l_proc,175);
1607: hr_utility.set_location('PA REQ ID ' || to_char(l_pa_request_rec.pa_request_id) ,175);
1608: hr_utility.set_location('PA OVN ' || to_char(l_pa_request_rec.object_version_number),175);
1609: hr_utility.set_location('RHVN ' || to_char(l_prh_object_version_number),176);
1610: hr_utility.set_location('RHID ' || to_char(l_pa_routing_history_id),177);
1611:
1612: ghr_prh_upd.upd(
1613: p_pa_routing_history_id => l_pa_routing_history_id,

Line 1610: hr_utility.set_location('RHID ' || to_char(l_pa_routing_history_id),177);

1606: hr_utility.set_location('Updating prh ' || l_proc,175);
1607: hr_utility.set_location('PA REQ ID ' || to_char(l_pa_request_rec.pa_request_id) ,175);
1608: hr_utility.set_location('PA OVN ' || to_char(l_pa_request_rec.object_version_number),175);
1609: hr_utility.set_location('RHVN ' || to_char(l_prh_object_version_number),176);
1610: hr_utility.set_location('RHID ' || to_char(l_pa_routing_history_id),177);
1611:
1612: ghr_prh_upd.upd(
1613: p_pa_routing_history_id => l_pa_routing_history_id,
1614: p_groupbox_id => l_groupbox_id,

Line 1617: hr_utility.set_location('Updating par ' || l_proc,180);

1613: p_pa_routing_history_id => l_pa_routing_history_id,
1614: p_groupbox_id => l_groupbox_id,
1615: p_object_version_number => l_prh_object_version_number);
1616:
1617: hr_utility.set_location('Updating par ' || l_proc,180);
1618:
1619: -- Call ghr_par_upd.upd here
1620: ghr_par_upd.upd(
1621: p_pa_request_id => l_pa_request_rec.pa_request_id,

Line 1626: hr_utility.set_location('commit(GB) build_rpa_save_preview ' || l_proc,52);

1622: p_routing_group_id => l_routing_group_id,
1623: p_object_version_number => l_pa_request_rec.object_version_number);
1624:
1625: commit;
1626: hr_utility.set_location('commit(GB) build_rpa_save_preview ' || l_proc,52);
1627: hr_utility.set_location('PA REQ ID ' || to_char(l_pa_request_rec.pa_request_id) ,52);
1628: hr_utility.set_location('PA OVN ' || to_char(l_pa_request_rec.object_version_number),52);
1629:
1630: l_savepoint := 'F';

Line 1627: hr_utility.set_location('PA REQ ID ' || to_char(l_pa_request_rec.pa_request_id) ,52);

1623: p_object_version_number => l_pa_request_rec.object_version_number);
1624:
1625: commit;
1626: hr_utility.set_location('commit(GB) build_rpa_save_preview ' || l_proc,52);
1627: hr_utility.set_location('PA REQ ID ' || to_char(l_pa_request_rec.pa_request_id) ,52);
1628: hr_utility.set_location('PA OVN ' || to_char(l_pa_request_rec.object_version_number),52);
1629:
1630: l_savepoint := 'F';
1631: savepoint build_rpa_save_final;

Line 1628: hr_utility.set_location('PA OVN ' || to_char(l_pa_request_rec.object_version_number),52);

1624:
1625: commit;
1626: hr_utility.set_location('commit(GB) build_rpa_save_preview ' || l_proc,52);
1627: hr_utility.set_location('PA REQ ID ' || to_char(l_pa_request_rec.pa_request_id) ,52);
1628: hr_utility.set_location('PA OVN ' || to_char(l_pa_request_rec.object_version_number),52);
1629:
1630: l_savepoint := 'F';
1631: savepoint build_rpa_save_final;
1632: hr_utility.set_location('savepoint build_rpa_save_final ' || l_proc,52);

Line 1632: hr_utility.set_location('savepoint build_rpa_save_final ' || l_proc,52);

1628: hr_utility.set_location('PA OVN ' || to_char(l_pa_request_rec.object_version_number),52);
1629:
1630: l_savepoint := 'F';
1631: savepoint build_rpa_save_final;
1632: hr_utility.set_location('savepoint build_rpa_save_final ' || l_proc,52);
1633: hr_utility.set_location(l_proc,52);
1634:
1635: hr_utility.set_location('Creating Remarks ' || l_proc,165);
1636: create_remarks

Line 1633: hr_utility.set_location(l_proc,52);

1629:
1630: l_savepoint := 'F';
1631: savepoint build_rpa_save_final;
1632: hr_utility.set_location('savepoint build_rpa_save_final ' || l_proc,52);
1633: hr_utility.set_location(l_proc,52);
1634:
1635: hr_utility.set_location('Creating Remarks ' || l_proc,165);
1636: create_remarks
1637: (p_noa_action => p_noa_action

Line 1635: hr_utility.set_location('Creating Remarks ' || l_proc,165);

1631: savepoint build_rpa_save_final;
1632: hr_utility.set_location('savepoint build_rpa_save_final ' || l_proc,52);
1633: hr_utility.set_location(l_proc,52);
1634:
1635: hr_utility.set_location('Creating Remarks ' || l_proc,165);
1636: create_remarks
1637: (p_noa_action => p_noa_action
1638: ,p_effective_date => p_effective_date
1639: ,p_person_id => p_person_id

Line 1645: hr_utility.set_location('Creating Remarks Over ' || l_proc,165);

1641: ,p_work_schedule => l_pa_request_rec.work_schedule
1642: ,p_fegli => l_pa_request_rec.fegli
1643: ,p_fehb_plan => l_health_plan
1644: ,p_prd => l_pa_request_rec.pay_rate_determinant);--Bug# 12334118
1645: hr_utility.set_location('Creating Remarks Over ' || l_proc,165);
1646:
1647:
1648: if p_effective_date > sysdate then
1649: l_rpa_action := 'FUTURE_ACTION';

Line 1654: hr_utility.set_location('Action before last ghr_par_upd.upd ' || l_rpa_action || ' ' || l_proc,175);

1650: else
1651: l_rpa_action := 'UPDATE_HR';
1652: end if;
1653:
1654: hr_utility.set_location('Action before last ghr_par_upd.upd ' || l_rpa_action || ' ' || l_proc,175);
1655:
1656: ghr_par_upd.upd
1657: (p_pa_request_id => l_pa_request_rec.pa_request_id,
1658: p_object_version_number => l_pa_request_rec.object_version_number,

Line 1666: hr_utility.set_location('Action after last ghr_par_upd.upd ' || l_rpa_action || ' ' || l_proc,175);

1662: p_sf50_approving_ofcl_full_nam => l_personnel_officer_name,
1663: p_sf50_approval_date => sysdate ,
1664: p_sf50_approving_ofcl_work_tit => l_approving_off_work_title
1665: );
1666: hr_utility.set_location('Action after last ghr_par_upd.upd ' || l_rpa_action || ' ' || l_proc,175);
1667:
1668: hr_utility.set_location('Action before ' || l_rpa_action || ' ' || l_proc,185);
1669: hr_utility.set_location('PA REQ ID ' || to_char(l_pa_request_rec.pa_request_id) ,185);
1670: hr_utility.set_location('PA OVN ' || to_char(l_pa_request_rec.object_version_number),185);

Line 1668: hr_utility.set_location('Action before ' || l_rpa_action || ' ' || l_proc,185);

1664: p_sf50_approving_ofcl_work_tit => l_approving_off_work_title
1665: );
1666: hr_utility.set_location('Action after last ghr_par_upd.upd ' || l_rpa_action || ' ' || l_proc,175);
1667:
1668: hr_utility.set_location('Action before ' || l_rpa_action || ' ' || l_proc,185);
1669: hr_utility.set_location('PA REQ ID ' || to_char(l_pa_request_rec.pa_request_id) ,185);
1670: hr_utility.set_location('PA OVN ' || to_char(l_pa_request_rec.object_version_number),185);
1671:
1672: begin

Line 1669: hr_utility.set_location('PA REQ ID ' || to_char(l_pa_request_rec.pa_request_id) ,185);

1665: );
1666: hr_utility.set_location('Action after last ghr_par_upd.upd ' || l_rpa_action || ' ' || l_proc,175);
1667:
1668: hr_utility.set_location('Action before ' || l_rpa_action || ' ' || l_proc,185);
1669: hr_utility.set_location('PA REQ ID ' || to_char(l_pa_request_rec.pa_request_id) ,185);
1670: hr_utility.set_location('PA OVN ' || to_char(l_pa_request_rec.object_version_number),185);
1671:
1672: begin
1673: ghr_sf52_api.update_sf52

Line 1670: hr_utility.set_location('PA OVN ' || to_char(l_pa_request_rec.object_version_number),185);

1666: hr_utility.set_location('Action after last ghr_par_upd.upd ' || l_rpa_action || ' ' || l_proc,175);
1667:
1668: hr_utility.set_location('Action before ' || l_rpa_action || ' ' || l_proc,185);
1669: hr_utility.set_location('PA REQ ID ' || to_char(l_pa_request_rec.pa_request_id) ,185);
1670: hr_utility.set_location('PA OVN ' || to_char(l_pa_request_rec.object_version_number),185);
1671:
1672: begin
1673: ghr_sf52_api.update_sf52
1674: (

Line 1688: hr_utility.set_location(sqlerrm(sqlcode),1);

1684: p_i_pa_routing_history_id => l_i_pa_routing_history_id,
1685: p_i_prh_object_version_number => l_i_prh_object_version_number);
1686: exception
1687: WHEN OTHERS THEN
1688: hr_utility.set_location(sqlerrm(sqlcode),1);
1689: hr_utility.set_location('Update sf52 Failure ' || l_proc,190);
1690: l_log_text := 'Error in Update sf52 ' ||' Sql error : '||sqlerrm(sqlcode);
1691: raise rpaerror;
1692: end;

Line 1689: hr_utility.set_location('Update sf52 Failure ' || l_proc,190);

1685: p_i_prh_object_version_number => l_i_prh_object_version_number);
1686: exception
1687: WHEN OTHERS THEN
1688: hr_utility.set_location(sqlerrm(sqlcode),1);
1689: hr_utility.set_location('Update sf52 Failure ' || l_proc,190);
1690: l_log_text := 'Error in Update sf52 ' ||' Sql error : '||sqlerrm(sqlcode);
1691: raise rpaerror;
1692: end;
1693:

Line 1694: hr_utility.set_location('Action after ' || l_rpa_action || ' ' || l_proc,200);

1690: l_log_text := 'Error in Update sf52 ' ||' Sql error : '||sqlerrm(sqlcode);
1691: raise rpaerror;
1692: end;
1693:
1694: hr_utility.set_location('Action after ' || l_rpa_action || ' ' || l_proc,200);
1695: p_status := 'SUCCESS';
1696: p_retcode := 0;
1697: l_log_text := 'Last Name: '|| l_pa_request_rec.employee_last_name ||
1698: ' Emp No: '|| l_employee_number ||

Line 1711: hr_utility.set_location('Already Processed ' || l_proc,200);

1707: p_log_date => sysdate);
1708:
1709: ELSE --IF l_pa_notification_id is null
1710:
1711: hr_utility.set_location('Already Processed ' || l_proc,200);
1712: p_status := 'PROCESSED';
1713: p_retcode := 0;
1714: END IF;
1715:

Line 1718: hr_utility.set_location('Entering Exception groupboxerr ' || l_proc , 1);

1714: END IF;
1715:
1716: Exception
1717: When groupboxerr then
1718: hr_utility.set_location('Entering Exception groupboxerr ' || l_proc , 1);
1719: rollback to build_rpa_save_preview;
1720: hr_utility.set_location('rollback grp build_rpa_save_preview ' || l_proc,1);
1721: IF l_log_text is NULL THEN
1722: l_log_text := 'Error in POI groupbox ';

Line 1720: hr_utility.set_location('rollback grp build_rpa_save_preview ' || l_proc,1);

1716: Exception
1717: When groupboxerr then
1718: hr_utility.set_location('Entering Exception groupboxerr ' || l_proc , 1);
1719: rollback to build_rpa_save_preview;
1720: hr_utility.set_location('rollback grp build_rpa_save_preview ' || l_proc,1);
1721: IF l_log_text is NULL THEN
1722: l_log_text := 'Error in POI groupbox ';
1723: END IF;
1724:

Line 1729: hr_utility.set_location('Exception groupboxerr in build_rpa before creat log ',2);

1725: p_retcode := 1;
1726: p_status := 'GROUPBOX';
1727: p_errbuf := substr(l_log_text || 'Details in GHR_PROCESS_LOG',1,2000);
1728:
1729: hr_utility.set_location('Exception groupboxerr in build_rpa before creat log ',2);
1730: l_log_text := substr(',( ' || l_pa_request_rec.employee_last_name || ', ' ||
1731: l_pa_request_rec.employee_first_name ||' '||l_pa_request_rec.employee_middle_names||
1732: '; Emp No: '||l_employee_number||
1733: ') ' || l_log_text,1,2000);

Line 1741: hr_utility.set_location('Leaving build_rpa Exception groupboxerr ',2);

1737: p_message_name => substr('Mass Furlo or RTD' || '-' || 'GB Err',1,30),
1738: p_log_text => substr('Person id : ' || to_char(p_person_id) || ' ' ||l_log_text,1,2000),
1739: p_log_date => sysdate);
1740:
1741: hr_utility.set_location('Leaving build_rpa Exception groupboxerr ',2);
1742: commit;
1743:
1744: When rpaerror then
1745: if l_savepoint = 'F' THEN

Line 1747: hr_utility.set_location('rollback rpa build_rpa_save_final ' || l_proc,1);

1743:
1744: When rpaerror then
1745: if l_savepoint = 'F' THEN
1746: rollback to build_rpa_save_final;
1747: hr_utility.set_location('rollback rpa build_rpa_save_final ' || l_proc,1);
1748: else
1749: rollback to build_rpa_save_preview;
1750: hr_utility.set_location('rollback rpa build_rpa_save_preview ' || l_proc,1);
1751: end if;

Line 1750: hr_utility.set_location('rollback rpa build_rpa_save_preview ' || l_proc,1);

1746: rollback to build_rpa_save_final;
1747: hr_utility.set_location('rollback rpa build_rpa_save_final ' || l_proc,1);
1748: else
1749: rollback to build_rpa_save_preview;
1750: hr_utility.set_location('rollback rpa build_rpa_save_preview ' || l_proc,1);
1751: end if;
1752:
1753: hr_utility.set_location('Error occured Update Sf52 Exception rpaerror ' || l_proc , 1);
1754: IF l_log_text is NULL THEN

Line 1753: hr_utility.set_location('Error occured Update Sf52 Exception rpaerror ' || l_proc , 1);

1749: rollback to build_rpa_save_preview;
1750: hr_utility.set_location('rollback rpa build_rpa_save_preview ' || l_proc,1);
1751: end if;
1752:
1753: hr_utility.set_location('Error occured Update Sf52 Exception rpaerror ' || l_proc , 1);
1754: IF l_log_text is NULL THEN
1755: l_log_text := 'Update sf52 Failure ';
1756: END IF;
1757:

Line 1762: hr_utility.set_location('Exception rpaerror before creating entry in log file',2);

1758: p_retcode := 1;
1759: p_status := 'FAILURE';
1760: p_errbuf := substr(l_log_text || 'Details in GHR_PROCESS_LOG',1,2000);
1761:
1762: hr_utility.set_location('Exception rpaerror before creating entry in log file',2);
1763: l_log_text := substr(',( ' || l_pa_request_rec.employee_last_name || ', ' ||
1764: l_pa_request_rec.employee_first_name ||' '||l_pa_request_rec.employee_middle_names||
1765: '; Emp No: '||l_employee_number||
1766: ') ' || l_log_text ,1,2000);

Line 1773: hr_utility.set_location('Leaving build_rpa Exception rpaerror ',2);

1769: p_message_name => substr('Mass Furlo or RTD' || '-' || 'RPA Err',1,30),
1770: p_log_text => substr('Person id : ' || to_char(p_person_id) || ' ' ||l_log_text,1,2000),
1771: p_log_date => sysdate);
1772:
1773: hr_utility.set_location('Leaving build_rpa Exception rpaerror ',2);
1774: commit;
1775: When ma_rpaerror then
1776: if l_savepoint = 'F' THEN
1777: rollback to build_rpa_save_final;

Line 1778: hr_utility.set_location('rollback marpa build_rpa_save_final ' || l_proc,1);

1774: commit;
1775: When ma_rpaerror then
1776: if l_savepoint = 'F' THEN
1777: rollback to build_rpa_save_final;
1778: hr_utility.set_location('rollback marpa build_rpa_save_final ' || l_proc,1);
1779: else
1780: rollback to build_rpa_save_preview;
1781: hr_utility.set_location('rollback marpa build_rpa_save_preview ' || l_proc,1);
1782: end if;

Line 1781: hr_utility.set_location('rollback marpa build_rpa_save_preview ' || l_proc,1);

1777: rollback to build_rpa_save_final;
1778: hr_utility.set_location('rollback marpa build_rpa_save_final ' || l_proc,1);
1779: else
1780: rollback to build_rpa_save_preview;
1781: hr_utility.set_location('rollback marpa build_rpa_save_preview ' || l_proc,1);
1782: end if;
1783:
1784: hr_utility.set_location('Error occured in ' || l_proc , 1);
1785: IF g_log_text is NOT NULL then

Line 1784: hr_utility.set_location('Error occured in ' || l_proc , 1);

1780: rollback to build_rpa_save_preview;
1781: hr_utility.set_location('rollback marpa build_rpa_save_preview ' || l_proc,1);
1782: end if;
1783:
1784: hr_utility.set_location('Error occured in ' || l_proc , 1);
1785: IF g_log_text is NOT NULL then
1786: l_log_text := g_log_text;
1787: END IF;
1788: IF l_log_text is NULL THEN

Line 1796: hr_utility.set_location('Exception ma_rpaerror before creating entry in log file',2);

1792: p_retcode := 1;
1793: p_status := 'FAILURE';
1794: p_errbuf := substr(l_log_text || 'Details in GHR_PROCESS_LOG',1,2000);
1795:
1796: hr_utility.set_location('Exception ma_rpaerror before creating entry in log file',2);
1797: l_log_text := substr( ',( ' || l_pa_request_rec.employee_last_name || ', ' ||
1798: l_pa_request_rec.employee_first_name ||' '||l_pa_request_rec.employee_middle_names||
1799: '; Emp No: '||l_employee_number||
1800: ') ' || l_log_text,1,2000);

Line 1807: hr_utility.set_location('Leaving build_rpa Exception ma_rpaerror ',2);

1803: p_message_name => substr('Mass Furlo or RTD' || '-' || 'RPA MA',1,30) ,
1804: p_log_text => substr('Person id : ' || to_char(p_person_id) || ' ' || l_log_text,1,2000),
1805: p_log_date => sysdate);
1806:
1807: hr_utility.set_location('Leaving build_rpa Exception ma_rpaerror ',2);
1808:
1809: commit;
1810: When others then
1811:

Line 1814: hr_utility.set_location('rollback others build_rpa_save_final ' || l_proc,1);

1810: When others then
1811:
1812: if l_savepoint = 'F' THEN
1813: rollback to build_rpa_save_final;
1814: hr_utility.set_location('rollback others build_rpa_save_final ' || l_proc,1);
1815: else
1816: rollback to build_rpa_save_preview;
1817: hr_utility.set_location('rollback others build_rpa_save_preview ' || l_proc,1);
1818: end if;

Line 1817: hr_utility.set_location('rollback others build_rpa_save_preview ' || l_proc,1);

1813: rollback to build_rpa_save_final;
1814: hr_utility.set_location('rollback others build_rpa_save_final ' || l_proc,1);
1815: else
1816: rollback to build_rpa_save_preview;
1817: hr_utility.set_location('rollback others build_rpa_save_preview ' || l_proc,1);
1818: end if;
1819:
1820: hr_utility.set_location('Error occured in ' || l_proc , 1);
1821: IF l_log_text is NULL THEN

Line 1820: hr_utility.set_location('Error occured in ' || l_proc , 1);

1816: rollback to build_rpa_save_preview;
1817: hr_utility.set_location('rollback others build_rpa_save_preview ' || l_proc,1);
1818: end if;
1819:
1820: hr_utility.set_location('Error occured in ' || l_proc , 1);
1821: IF l_log_text is NULL THEN
1822: l_log_text := 'Error while creating / Updating the PA Request Rec.';
1823: END IF;
1824:

Line 1829: hr_utility.set_location('Exception build_rpa others2 before creating entry in log file',2);

1825: p_retcode := 1;
1826: p_status := 'FAILURE';
1827: p_errbuf := substr(l_log_text || 'Details in GHR_PROCESS_LOG',1,2000);
1828:
1829: hr_utility.set_location('Exception build_rpa others2 before creating entry in log file',2);
1830: l_log_text := substr( ',( ' || l_pa_request_rec.employee_last_name || ', ' ||
1831: l_pa_request_rec.employee_first_name ||' '||l_pa_request_rec.employee_middle_names||
1832: '; Emp No: '||l_employee_number||
1833: ') ' || l_log_text,1,2000);

Line 1840: hr_utility.set_location('Leaving build_rpa Exception Others ',2);

1836: p_message_name => substr('Mass Furlo or RTD' || '-' || 'RPA Oth',1,30) ,
1837: p_log_text => substr('Person id : ' || to_char(p_person_id) || ' ' || l_log_text,1,2000),
1838: p_log_date => sysdate);
1839:
1840: hr_utility.set_location('Leaving build_rpa Exception Others ',2);
1841:
1842: commit;
1843:
1844: end build_rpa;

Line 1976: hr_utility.set_location('Entering ' || l_proc,5);

1972: and second_noa_code = par.first_noa_code)
1973: ORDER BY par.pa_request_id desc;
1974:
1975: BEGIN
1976: hr_utility.set_location('Entering ' || l_proc,5);
1977: l_errbuf := NULL;
1978: l_retcode := NULL;
1979: l_status := NULL;
1980: l_maxcheck := NULL;

Line 1988: hr_utility.set_location( l_proc,20);

1984: ghr_session.set_fnd_session_date(l_effective_date);
1985: l_prog_name := fnd_profile.VALUE ('CONC_REQUEST_ID');
1986: l_prog_name := 'GHR_CON_PGM-' || l_prog_name;
1987: g_log_name := l_prog_name;
1988: hr_utility.set_location( l_proc,20);
1989: BEGIN
1990: hr_utility.set_location( 'Checking mandatory fields '|| p_nte_date,20);
1991: IF l_noa_action IN ('772','472') AND p_nte_date IS NULL THEN
1992: hr_utility.set_location('Mandatory NTE Date not passed ',20);

Line 1990: hr_utility.set_location( 'Checking mandatory fields '|| p_nte_date,20);

1986: l_prog_name := 'GHR_CON_PGM-' || l_prog_name;
1987: g_log_name := l_prog_name;
1988: hr_utility.set_location( l_proc,20);
1989: BEGIN
1990: hr_utility.set_location( 'Checking mandatory fields '|| p_nte_date,20);
1991: IF l_noa_action IN ('772','472') AND p_nte_date IS NULL THEN
1992: hr_utility.set_location('Mandatory NTE Date not passed ',20);
1993: l_log_text := 'NTE Date is Mandatory for NOA 472 and 772 ';
1994: raise furlo_param_error;

Line 1992: hr_utility.set_location('Mandatory NTE Date not passed ',20);

1988: hr_utility.set_location( l_proc,20);
1989: BEGIN
1990: hr_utility.set_location( 'Checking mandatory fields '|| p_nte_date,20);
1991: IF l_noa_action IN ('772','472') AND p_nte_date IS NULL THEN
1992: hr_utility.set_location('Mandatory NTE Date not passed ',20);
1993: l_log_text := 'NTE Date is Mandatory for NOA 472 and 772 ';
1994: raise furlo_param_error;
1995: END IF;
1996: END;

Line 2004: hr_utility.set_location(' before SSN: '||per.national_identifier,2001);

2000: LOOP
2001: l_errbuf := NULL;
2002: FOR ast IN cur_472_ast (per.assignment_status_type_id)
2003: LOOP
2004: hr_utility.set_location(' before SSN: '||per.national_identifier,2001);
2005: l_elig_flag := FALSE;
2006: hr_utility.set_location('SSN: '||per.national_identifier,2000);
2007: hr_utility.set_location('Position Id: '||per.position_id,2000);
2008: hr_utility.set_location('BG Id: '||per.business_group_id,2000);

Line 2006: hr_utility.set_location('SSN: '||per.national_identifier,2000);

2002: FOR ast IN cur_472_ast (per.assignment_status_type_id)
2003: LOOP
2004: hr_utility.set_location(' before SSN: '||per.national_identifier,2001);
2005: l_elig_flag := FALSE;
2006: hr_utility.set_location('SSN: '||per.national_identifier,2000);
2007: hr_utility.set_location('Position Id: '||per.position_id,2000);
2008: hr_utility.set_location('BG Id: '||per.business_group_id,2000);
2009: l_full_name := per.last_name||','|| per.first_name||' '||per.middle_names;
2010: l_employee_number := ghr_pa_requests_pkg2.get_employee_number

Line 2007: hr_utility.set_location('Position Id: '||per.position_id,2000);

2003: LOOP
2004: hr_utility.set_location(' before SSN: '||per.national_identifier,2001);
2005: l_elig_flag := FALSE;
2006: hr_utility.set_location('SSN: '||per.national_identifier,2000);
2007: hr_utility.set_location('Position Id: '||per.position_id,2000);
2008: hr_utility.set_location('BG Id: '||per.business_group_id,2000);
2009: l_full_name := per.last_name||','|| per.first_name||' '||per.middle_names;
2010: l_employee_number := ghr_pa_requests_pkg2.get_employee_number
2011: (p_person_id => per.person_id,

Line 2008: hr_utility.set_location('BG Id: '||per.business_group_id,2000);

2004: hr_utility.set_location(' before SSN: '||per.national_identifier,2001);
2005: l_elig_flag := FALSE;
2006: hr_utility.set_location('SSN: '||per.national_identifier,2000);
2007: hr_utility.set_location('Position Id: '||per.position_id,2000);
2008: hr_utility.set_location('BG Id: '||per.business_group_id,2000);
2009: l_full_name := per.last_name||','|| per.first_name||' '||per.middle_names;
2010: l_employee_number := ghr_pa_requests_pkg2.get_employee_number
2011: (p_person_id => per.person_id,
2012: p_effective_date => l_effective_date);

Line 2029: hr_utility.set_location( 'Calling build_rpa '|| l_rpa_type,20);

2025: l_elig_flag := FALSE;
2026: END IF;
2027: IF l_elig_flag THEN
2028: BEGIN
2029: hr_utility.set_location( 'Calling build_rpa '|| l_rpa_type,20);
2030: build_rpa
2031: ( p_noa_action => l_noa_action,
2032: p_rpa_type => l_rpa_type,
2033: p_effective_date => l_effective_date,

Line 2046: hr_utility.set_location('Error in build_rpa call '|| 'Err is '||sqlerrm(sqlcode),20);

2042: p_retcode => l_retcode
2043: );
2044: EXCEPTION
2045: WHEN others THEN
2046: hr_utility.set_location('Error in build_rpa call '|| 'Err is '||sqlerrm(sqlcode),20);
2047: l_log_text := 'Error in build_rpa for employee with Emp No: '||l_employee_number||'; Name:'||l_full_name
2048: || '; SQL Error: '|| sqlerrm(sqlcode);
2049: raise furlo_main_error;
2050: END;

Line 2055: hr_utility.set_location( 'Calling 772 or 292 '|| l_rpa_type,20);

2051: END IF;
2052: END LOOP;
2053: END LOOP;
2054: ELSIF l_noa_action IN ('772','292') THEN
2055: hr_utility.set_location( 'Calling 772 or 292 '|| l_rpa_type,20);
2056: IF l_noa_action IN ('772') THEN
2057: l_rpa_type := 'MFL';
2058: ELSIF l_noa_action IN ('292') THEN
2059: l_rpa_type := 'MRTD';

Line 2066: hr_utility.set_location('SSN: '||per.national_identifier,2000);

2062: LOOP
2063: l_errbuf := NULL;
2064: l_elig_flag := FALSE;
2065: g_furlo_effective_date := NULL;
2066: hr_utility.set_location('SSN: '||per.national_identifier,2000);
2067: hr_utility.set_location('person Id: '|| per.person_id,2000);
2068: hr_utility.set_location('assignment Id: '||per.assignment_id,2000);
2069: BEGIN
2070: FOR l_get_rpa_type IN get_rpa_type(per.person_id,per.assignment_id) LOOP

Line 2067: hr_utility.set_location('person Id: '|| per.person_id,2000);

2063: l_errbuf := NULL;
2064: l_elig_flag := FALSE;
2065: g_furlo_effective_date := NULL;
2066: hr_utility.set_location('SSN: '||per.national_identifier,2000);
2067: hr_utility.set_location('person Id: '|| per.person_id,2000);
2068: hr_utility.set_location('assignment Id: '||per.assignment_id,2000);
2069: BEGIN
2070: FOR l_get_rpa_type IN get_rpa_type(per.person_id,per.assignment_id) LOOP
2071: l_elig_flag := TRUE;

Line 2068: hr_utility.set_location('assignment Id: '||per.assignment_id,2000);

2064: l_elig_flag := FALSE;
2065: g_furlo_effective_date := NULL;
2066: hr_utility.set_location('SSN: '||per.national_identifier,2000);
2067: hr_utility.set_location('person Id: '|| per.person_id,2000);
2068: hr_utility.set_location('assignment Id: '||per.assignment_id,2000);
2069: BEGIN
2070: FOR l_get_rpa_type IN get_rpa_type(per.person_id,per.assignment_id) LOOP
2071: l_elig_flag := TRUE;
2072: hr_utility.set_location('292 eff date: '||l_get_rpa_type.effective_date,2000);

Line 2072: hr_utility.set_location('292 eff date: '||l_get_rpa_type.effective_date,2000);

2068: hr_utility.set_location('assignment Id: '||per.assignment_id,2000);
2069: BEGIN
2070: FOR l_get_rpa_type IN get_rpa_type(per.person_id,per.assignment_id) LOOP
2071: l_elig_flag := TRUE;
2072: hr_utility.set_location('292 eff date: '||l_get_rpa_type.effective_date,2000);
2073: g_furlo_effective_date := l_get_rpa_type.effective_date;
2074: EXIT;
2075: END LOOP;
2076: EXCEPTION

Line 2078: hr_utility.set_location('292 eff date: exception ',2000);

2074: EXIT;
2075: END LOOP;
2076: EXCEPTION
2077: when others THEN
2078: hr_utility.set_location('292 eff date: exception ',2000);
2079: END;
2080: IF l_elig_flag THEN
2081: BEGIN
2082: hr_utility.set_location( 'Calling build_rpa '|| l_rpa_type,20);

Line 2082: hr_utility.set_location( 'Calling build_rpa '|| l_rpa_type,20);

2078: hr_utility.set_location('292 eff date: exception ',2000);
2079: END;
2080: IF l_elig_flag THEN
2081: BEGIN
2082: hr_utility.set_location( 'Calling build_rpa '|| l_rpa_type,20);
2083: build_rpa
2084: ( p_noa_action => l_noa_action,
2085: p_rpa_type => l_rpa_type,
2086: p_effective_date => l_effective_date,

Line 2099: hr_utility.set_location('Error in build_rpa call '|| 'Err is '||sqlerrm(sqlcode),20);

2095: p_retcode => l_retcode
2096: );
2097: EXCEPTION
2098: WHEN others THEN
2099: hr_utility.set_location('Error in build_rpa call '|| 'Err is '||sqlerrm(sqlcode),20);
2100: l_log_text := 'Error in build_rpa for employee with Emp No: '||l_employee_number||'; Name:'||l_full_name
2101: || '; SQL Error: '|| sqlerrm(sqlcode);
2102: raise furlo_main_error;
2103: END;

Line 2112: hr_utility.set_location(' Exception furlo_param_error creating entry in log file',10);

2108: p_retcode := l_retcode;
2109: EXCEPTION
2110: WHEN furlo_param_error THEN
2111: l_log_text := substr(l_log_text,1,2000);
2112: hr_utility.set_location(' Exception furlo_param_error creating entry in log file',10);
2113: p_retcode := 2;
2114: p_errbuf := substr(l_log_text ,1,2000);
2115: When furlo_main_error then
2116: hr_utility.set_location('Error occured in ' || l_proc , 1);

Line 2116: hr_utility.set_location('Error occured in ' || l_proc , 1);

2112: hr_utility.set_location(' Exception furlo_param_error creating entry in log file',10);
2113: p_retcode := 2;
2114: p_errbuf := substr(l_log_text ,1,2000);
2115: When furlo_main_error then
2116: hr_utility.set_location('Error occured in ' || l_proc , 1);
2117: IF l_log_text is NULL THEN
2118: l_log_text := 'Error while create / Update the PA Request Rec. ';
2119: l_log_text := l_log_text ||' for '||l_full_name||' Emp No: '||l_employee_number||' Sql error : '||sqlerrm(sqlcode);
2120: END IF;

Line 2124: hr_utility.set_location(' Exception furlo_main_error creating entry in log file',10);

2120: END IF;
2121:
2122: l_log_text := substr(l_log_text,1,2000);
2123:
2124: hr_utility.set_location(' Exception furlo_main_error creating entry in log file',10);
2125: ghr_mto_int.log_message( p_procedure => 'While Creating Furlo RPA'
2126: ,p_message => l_log_text);
2127:
2128: hr_utility.set_location('created entry in log file',20);

Line 2128: hr_utility.set_location('created entry in log file',20);

2124: hr_utility.set_location(' Exception furlo_main_error creating entry in log file',10);
2125: ghr_mto_int.log_message( p_procedure => 'While Creating Furlo RPA'
2126: ,p_message => l_log_text);
2127:
2128: hr_utility.set_location('created entry in log file',20);
2129: WHEN others THEN
2130:
2131: IF l_log_text is NULL THEN
2132: l_log_text := 'Error while create / Update the PA Request Rec. ';

Line 2136: hr_utility.set_location('Exception main_concurrent_program others create entry in log file',10);

2132: l_log_text := 'Error while create / Update the PA Request Rec. ';
2133: l_log_text := l_log_text ||' for '||l_full_name||' Emp No: '||l_employee_number||' Sql error : '||sqlerrm(sqlcode);
2134: END IF;
2135: l_log_text := substr(l_log_text,1,2000);
2136: hr_utility.set_location('Exception main_concurrent_program others create entry in log file',10);
2137:
2138: ghr_mto_int.log_message(p_procedure => 'While Creating Furlo RPA'
2139: ,p_message => l_log_text);
2140: hr_utility.set_location('created entry in log file',20);

Line 2140: hr_utility.set_location('created entry in log file',20);

2136: hr_utility.set_location('Exception main_concurrent_program others create entry in log file',10);
2137:
2138: ghr_mto_int.log_message(p_procedure => 'While Creating Furlo RPA'
2139: ,p_message => l_log_text);
2140: hr_utility.set_location('created entry in log file',20);
2141: END main_concurrent_program;
2142:
2143: END GHR_MASS_CON_PROGRAM;