37: BEGIN
38: ghr_mto_int.put_line (msg|| '-'|| par1|| ' -'|| par2|| '-');
39: EXCEPTION
40: WHEN others THEN
41: hr_utility.set_location ('Error in pr '|| ' Err is '|| sqlerrm (sqlcode), 20);
42: l_noaerrbuf := 'Error in pr Sql Err is '|| sqlerrm (sqlcode);
43: RAISE mnoa_error;
44: END pr;
45:
79: l_action_taken ghr_pa_routing_history.action_taken%TYPE;
80: l_proc varchar2(72) DEFAULT g_package|| '.update_sel_flg';
81: BEGIN
82: g_proc := 'chk_pa_req_already_exists';
83: hr_utility.set_location ('Entering '|| l_proc, 6);
84: FOR v_action_taken IN csr_action_taken LOOP
85: hr_utility.set_location ('Record exists '|| l_proc, 6);
86: l_pa_request_id := v_action_taken.pa_request_id;
87:
81: BEGIN
82: g_proc := 'chk_pa_req_already_exists';
83: hr_utility.set_location ('Entering '|| l_proc, 6);
84: FOR v_action_taken IN csr_action_taken LOOP
85: hr_utility.set_location ('Record exists '|| l_proc, 6);
86: l_pa_request_id := v_action_taken.pa_request_id;
87:
88: FOR v_name IN csr_name LOOP
89: l_name := v_name.fname;
102: , p_effective_date => p_effective_date);
103: END IF;
104:
105: IF l_action_taken <> 'CANCELED' THEN
106: hr_utility.set_location ('in Canceled action '|| l_proc, 6);
107: ghr_mto_int.log_message
108: (p_procedure => 'RPA Exists Already'
109: , p_message => 'Name: '
110: || l_name
132: l_ind number DEFAULT 1;
133:
134: BEGIN
135: g_proc := 'update_sel_flg';
136: hr_utility.set_location ('Entering '|| l_proc, 5);
137:
138: pr ('Inside '|| l_proc, to_char (p_person_id));
139: l_ind := 10;
140:
160: , p_pei_information10 => NULL
161: , p_pei_information_category => 'GHR_US_PER_MASS_ACTIONS');
162:
163: l_ind := 30;
164: hr_utility.set_location ('Exiting '|| l_proc, 10);
165: END IF;
166:
167: l_ind := 50;
168:
170: EXCEPTION
171: WHEN mnoa_error THEN
172: RAISE;
173: WHEN others THEN
174: hr_utility.set_location ('Error in '|| l_proc|| ' Err is '|| sqlerrm (sqlcode), 20);
175:
176: l_noaerrbuf := 'Error in '|| l_proc|| ' at '|| to_char (l_ind)|| ' Sql Err is '|| sqlerrm (sqlcode);
177: RAISE mnoa_error;
178: END update_sel_flg;
190: l_line number DEFAULT 0;
191: l_proc varchar2(72) DEFAULT g_package|| '.check_select_flg';
192: BEGIN
193: g_proc := 'check_select_flg';
194: hr_utility.set_location ('Entering '|| l_proc, 5);
195: l_line := 5;
196:
197: get_extra_info_comments (p_person_id, p_effective_date
198: , l_sel_flag, l_comments
228: EXCEPTION
229: WHEN mnoa_error THEN
230: RAISE;
231: WHEN others THEN
232: hr_utility.set_location ('Error in '|| l_proc|| ' Err is '|| sqlerrm (sqlcode), 20);
233:
234: l_noaerrbuf := 'Error in '|| l_proc|| ' @'|| to_char (l_line)|| ' Sql Err is '|| sqlerrm (sqlcode);
235:
236: RAISE mnoa_error;
266: GROUP BY information11
267: );
268: BEGIN
269: g_proc := 'get_extra_info_comments';
270: hr_utility.set_location ('Entering ' || l_proc, 5);
271: l_eff_date := p_effective_date;
272:
273: ghr_history_fetch.fetch_peopleei
274: (p_person_id => p_person_id
301: EXCEPTION
302: WHEN mnoa_error THEN
303: RAISE;
304: WHEN others THEN
305: hr_utility.set_location ('Error in '|| l_proc|| ' Err is '|| sqlerrm (sqlcode), 20);
306: l_noaerrbuf := 'Error in '|| l_proc|| ' Sql Err is '|| sqlerrm (sqlcode);
307: RAISE mnoa_error;
308: END get_extra_info_comments;
309:
355:
356: BEGIN
357: g_proc := 'refresh_ei_details';
358: l_proc := g_proc|| 'refresh_ei_details';
359: hr_utility.set_location ('Entering '|| l_proc, 5);
360:
361: IF p_noa_action IN ('280', '292') THEN
362: l_information_type := 'GHR_US_PAR_RETURN_TO_DUTY';
363: IF p_work_schedule IN ('F', 'G') THEN
367: ELSIF p_work_schedule IN ('I', 'J') THEN
368: l_employment_type := '4';
369: END IF;
370: ELSIF p_noa_action IN ('430','460','471','472') THEN
371: hr_utility.set_location ('Entering '|| l_proc||p_noa_action, 51);
372: IF p_noa_action IN ('430','460') THEN
373: l_information_type := 'GHR_US_PAR_NON_PAY_DUTY_STATUS';
374: ELSIF p_noa_action IN ('471','472') THEN
375: l_information_type := 'GHR_US_PAR_LWOP_INFO';
426: --End Bug# 14456039
427: END IF;
428:
429: FOR cur_rpa_ei_rec IN cur_rpa_ei (p_pa_request_id) LOOP
430: hr_utility.set_location (l_proc, 10);
431: l_pa_request_extra_info_id := cur_rpa_ei_rec.pa_request_extra_info_id;
432: l_pa_object_version_number := cur_rpa_ei_rec.object_version_number;
433: EXIT;
434: END LOOP;
433: EXIT;
434: END LOOP;
435:
436: FOR cur_rpa_ei_shadow_rec IN cur_rpa_ei_shadow (p_pa_request_id) LOOP
437: hr_utility.set_location (l_proc, 11);
438: l_pa_request_extra_info_sh_id := cur_rpa_ei_shadow_rec.pa_request_extra_info_id;
439: EXIT;
440: END LOOP;
441:
438: l_pa_request_extra_info_sh_id := cur_rpa_ei_shadow_rec.pa_request_extra_info_id;
439: EXIT;
440: END LOOP;
441:
442: hr_utility.set_location (l_proc, 40);
443:
444: IF l_pa_request_extra_info_id IS NULL THEN
445: hr_utility.set_location (l_proc, 45);
446:
441:
442: hr_utility.set_location (l_proc, 40);
443:
444: IF l_pa_request_extra_info_id IS NULL THEN
445: hr_utility.set_location (l_proc, 45);
446:
447: IF p_noa_action IN ('471','472', '460','430') THEN
448: hr_utility.set_location (l_proc|| p_noa_action, 12);
449:
444: IF l_pa_request_extra_info_id IS NULL THEN
445: hr_utility.set_location (l_proc, 45);
446:
447: IF p_noa_action IN ('471','472', '460','430') THEN
448: hr_utility.set_location (l_proc|| p_noa_action, 12);
449:
450: ghr_par_extra_info_api.create_pa_request_extra_info
451: (p_validate => FALSE
452: , p_pa_request_id => p_pa_request_id
455: , p_rei_information3 => l_employment_type
456: , p_pa_request_extra_info_id => l_pa_rei_id
457: , p_object_version_number => l_dummy);
458: ELSIF p_noa_action IN ('280', '292') THEN
459: hr_utility.set_location (l_proc|| p_noa_action, 13);
460:
461: ghr_par_extra_info_api.create_pa_request_extra_info
462: (p_validate => FALSE
463: , p_pa_request_id => p_pa_request_id
466: , p_rei_information8 => l_employment_type
467: , p_pa_request_extra_info_id => l_dummy
468: , p_object_version_number => l_dummy);
469: ELSIF p_noa_action IN ('800') AND l_target_agency_code_subelmt IS NOT NULL THEN
470: hr_utility.set_location (l_proc|| p_noa_action, 122);
471:
472: ghr_par_extra_info_api.create_pa_request_extra_info
473: (p_validate => FALSE
474: , p_pa_request_id => p_pa_request_id
480: , p_pa_request_extra_info_id => l_dummy
481: , p_object_version_number => l_dummy);
482: END IF;
483: ELSE
484: hr_utility.set_location (l_proc|| p_noa_action, 14);
485:
486: IF p_noa_action IN ('471','472', '460','430') THEN
487: hr_utility.set_location (l_proc|| p_noa_action, 15);
488:
483: ELSE
484: hr_utility.set_location (l_proc|| p_noa_action, 14);
485:
486: IF p_noa_action IN ('471','472', '460','430') THEN
487: hr_utility.set_location (l_proc|| p_noa_action, 15);
488:
489: ghr_par_extra_info_api.update_pa_request_extra_info
490: (p_validate => FALSE
491: , p_rei_information3 => l_employment_type
491: , p_rei_information3 => l_employment_type
492: , p_pa_request_extra_info_id => l_pa_request_extra_info_id
493: , p_object_version_number => l_pa_object_version_number);
494: ELSIF p_noa_action IN ('280', '292') THEN
495: hr_utility.set_location (l_proc|| p_noa_action, 16);
496:
497: ghr_par_extra_info_api.update_pa_request_extra_info
498: (p_validate => FALSE
499: , p_rei_information8 => l_employment_type
499: , p_rei_information8 => l_employment_type
500: , p_pa_request_extra_info_id => l_pa_request_extra_info_id
501: , p_object_version_number => l_pa_object_version_number);
502: ELSIF p_noa_action IN ('800') AND l_target_agency_code_subelmt IS NOT NULL THEN
503: hr_utility.set_location (l_proc|| p_noa_action, 16);
504:
505: ghr_par_extra_info_api.update_pa_request_extra_info
506: (p_validate => FALSE
507: , p_rei_information3 => l_eit_poi
512: END IF;
513: END IF;
514:
515: IF l_pa_request_extra_info_sh_id IS NULL THEN
516: hr_utility.set_location (l_proc, 17);
517:
518: IF p_noa_action IN ('471','472', '460','430') THEN
519: INSERT
520: INTO ghr_pa_request_ei_shadow (pa_request_extra_info_id
550: ,l_pos_agency_code
551: ,l_eit_poi_dt);
552: END IF;
553: ELSE
554: hr_utility.set_location (l_proc, 18);
555:
556: IF p_noa_action IN ('471','472', '460','430') THEN
557: UPDATE ghr_pa_request_ei_shadow
558: SET rei_information3 = l_employment_type
570: END IF;
571: END IF;
572: EXCEPTION
573: WHEN others THEN
574: hr_utility.set_location ('Error in ghr_par_extra info.create pa req'|| ' Sql Err is '|| sqlerrm (sqlcode)|| l_proc, 60);
575: RAISE mnoa_error;
576: END refresh_ei_details;
577:
578: PROCEDURE fetch_and_validate_emp
670: init_elig_flag boolean DEFAULT FALSE;
671: l_proc varchar2(72) DEFAULT g_package|| '.fetch_and_validate_emp';
672: BEGIN
673: g_proc := 'fetch_and_validate_emp';
674: hr_utility.set_location ('Entering '|| l_proc, 5);
675: l_assignment_id := p_assignment_id;
676: l_position_id := p_position_id;
677: l_grade_id := p_grade_id;
678: l_business_group_id := p_business_group_id;
686: OR p_mnoa_job_id IS NOT NULL
687: OR p_mnoa_bargaining_unit IS NOT NULL
688: OR p_mnoa_flsa_category IS NOT NULL THEN
689:
690: hr_utility.set_location ('The location id is:'|| l_location_id, 12345);
691: hr_utility.set_location ('mnoa Org ID:'|| p_mnoa_organization_id, 1111);
692: hr_utility.set_location ('Org ID:'|| p_organization_id, 2222);
693:
694: IF nvl (p_mnoa_organization_id, p_organization_id)
687: OR p_mnoa_bargaining_unit IS NOT NULL
688: OR p_mnoa_flsa_category IS NOT NULL THEN
689:
690: hr_utility.set_location ('The location id is:'|| l_location_id, 12345);
691: hr_utility.set_location ('mnoa Org ID:'|| p_mnoa_organization_id, 1111);
692: hr_utility.set_location ('Org ID:'|| p_organization_id, 2222);
693:
694: IF nvl (p_mnoa_organization_id, p_organization_id)
695: = p_organization_id THEN
688: OR p_mnoa_flsa_category IS NOT NULL THEN
689:
690: hr_utility.set_location ('The location id is:'|| l_location_id, 12345);
691: hr_utility.set_location ('mnoa Org ID:'|| p_mnoa_organization_id, 1111);
692: hr_utility.set_location ('Org ID:'|| p_organization_id, 2222);
693:
694: IF nvl (p_mnoa_organization_id, p_organization_id)
695: = p_organization_id THEN
696: hr_utility.set_location ('Org ID PASS', 10);
692: hr_utility.set_location ('Org ID:'|| p_organization_id, 2222);
693:
694: IF nvl (p_mnoa_organization_id, p_organization_id)
695: = p_organization_id THEN
696: hr_utility.set_location ('Org ID PASS', 10);
697:
698: IF p_mnoa_personnel_office_id IS NOT NULL THEN
699: hr_utility.set_location ('POID CHECK', 15);
700: ghr_msl_pkg.get_pos_grp1_ddf (l_position_id, l_effective_date
695: = p_organization_id THEN
696: hr_utility.set_location ('Org ID PASS', 10);
697:
698: IF p_mnoa_personnel_office_id IS NOT NULL THEN
699: hr_utility.set_location ('POID CHECK', 15);
700: ghr_msl_pkg.get_pos_grp1_ddf (l_position_id, l_effective_date
701: , l_pos_grp1_rec);
702: l_personnel_office_id := l_pos_grp1_rec.poei_information3;
703: l_org_structure_id := l_pos_grp1_rec.poei_information5;
705: END IF;
706:
707: IF (p_mnoa_personnel_office_id = l_personnel_office_id)
708: OR NOT (l_fetch_poid_data) THEN
709: hr_utility.set_location ('POID PASS', 20);
710: IF p_mnoa_agency_code_subelement IS NOT NULL THEN
711: hr_utility.set_location ('Agency CHECK', 25);
712: ghr_msl_pkg.get_sub_element_code_pos_title (l_position_id, p_person_id
713: , l_business_group_id, l_assignment_id
707: IF (p_mnoa_personnel_office_id = l_personnel_office_id)
708: OR NOT (l_fetch_poid_data) THEN
709: hr_utility.set_location ('POID PASS', 20);
710: IF p_mnoa_agency_code_subelement IS NOT NULL THEN
711: hr_utility.set_location ('Agency CHECK', 25);
712: ghr_msl_pkg.get_sub_element_code_pos_title (l_position_id, p_person_id
713: , l_business_group_id, l_assignment_id
714: , l_effective_date, l_sub_element_code
715: , l_position_title, l_position_number
722: = substr (l_sub_element_code, 1, 2)
723: AND nvl (substr (p_mnoa_agency_code_subelement, 3, 2), substr (l_sub_element_code, 3, 2))
724: = substr (l_sub_element_code, 3, 2))
725: OR NOT (l_fetch_agency_data) THEN
726: hr_utility.set_location ('Agency PASS', 30);
727:
728: IF p_mnoa_duty_station_id IS NOT NULL THEN
729: hr_utility.set_location ('DS CHECK', 35);
730: ghr_pa_requests_pkg.get_sf52_loc_ddf_details
725: OR NOT (l_fetch_agency_data) THEN
726: hr_utility.set_location ('Agency PASS', 30);
727:
728: IF p_mnoa_duty_station_id IS NOT NULL THEN
729: hr_utility.set_location ('DS CHECK', 35);
730: ghr_pa_requests_pkg.get_sf52_loc_ddf_details
731: (p_location_id => l_location_id
732: , p_duty_station_id => l_duty_station_id);
733: l_fetch_ds_data := TRUE;
734: END IF;
735:
736: IF (p_mnoa_duty_station_id = l_duty_station_id)
737: OR NOT (l_fetch_ds_data) THEN
738: hr_utility.set_location ('DS PASS', 40);
739: IF p_mnoa_job_id IS NOT NULL
740: OR p_mnoa_bargaining_unit IS NOT NULL
741: OR p_mnoa_flsa_category IS NOT NULL THEN
742: IF p_mnoa_job_id IS NOT NULL THEN
739: IF p_mnoa_job_id IS NOT NULL
740: OR p_mnoa_bargaining_unit IS NOT NULL
741: OR p_mnoa_flsa_category IS NOT NULL THEN
742: IF p_mnoa_job_id IS NOT NULL THEN
743: hr_utility.set_location ('OCC CODE CHECK', 35);
744:
745: l_mnoa_occ_series := ghr_api.get_job_occ_series_job
746: (p_job_id => p_mnoa_job_id
747: ,p_business_group_id => l_business_group_id);
748: l_occ_series := ghr_pa_requests_pkg.get_occ_series(l_position_id,l_effective_date,l_business_group_id);
749: l_fetch_occ_data := TRUE;
750: END IF;
751: IF (l_mnoa_occ_series = l_occ_series) OR NOT(l_fetch_occ_data) THEN
752: hr_utility.set_location ('OCC PASS', 35);
753: IF p_mnoa_bargaining_unit IS NOT NULL THEN
754: hr_utility.set_location ('Bargaining Unit CHECK', 35);
755: l_bargaining_unit:= ghr_pa_requests_pkg.get_bargaining_unit(p_position_id,l_effective_date);
756: l_fetch_bu_data := TRUE;
750: END IF;
751: IF (l_mnoa_occ_series = l_occ_series) OR NOT(l_fetch_occ_data) THEN
752: hr_utility.set_location ('OCC PASS', 35);
753: IF p_mnoa_bargaining_unit IS NOT NULL THEN
754: hr_utility.set_location ('Bargaining Unit CHECK', 35);
755: l_bargaining_unit:= ghr_pa_requests_pkg.get_bargaining_unit(p_position_id,l_effective_date);
756: l_fetch_bu_data := TRUE;
757: END IF;
758: IF (p_mnoa_bargaining_unit = l_bargaining_unit) OR NOT(l_fetch_bu_data) THEN
755: l_bargaining_unit:= ghr_pa_requests_pkg.get_bargaining_unit(p_position_id,l_effective_date);
756: l_fetch_bu_data := TRUE;
757: END IF;
758: IF (p_mnoa_bargaining_unit = l_bargaining_unit) OR NOT(l_fetch_bu_data) THEN
759: hr_utility.set_location ('BU PASS', 30);
760: IF p_mnoa_flsa_category IS NOT NULL THEN
761: hr_utility.set_location ('FLSA Category CHECK', 35);
762: l_flsa_category:= ghr_pa_requests_pkg.get_flsa_category(p_position_id,l_effective_date);
763: l_fetch_flsa_data := TRUE;
757: END IF;
758: IF (p_mnoa_bargaining_unit = l_bargaining_unit) OR NOT(l_fetch_bu_data) THEN
759: hr_utility.set_location ('BU PASS', 30);
760: IF p_mnoa_flsa_category IS NOT NULL THEN
761: hr_utility.set_location ('FLSA Category CHECK', 35);
762: l_flsa_category:= ghr_pa_requests_pkg.get_flsa_category(p_position_id,l_effective_date);
763: l_fetch_flsa_data := TRUE;
764: END IF;
765: IF (p_mnoa_flsa_category = l_flsa_category) OR NOT(l_fetch_flsa_data) THEN
762: l_flsa_category:= ghr_pa_requests_pkg.get_flsa_category(p_position_id,l_effective_date);
763: l_fetch_flsa_data := TRUE;
764: END IF;
765: IF (p_mnoa_flsa_category = l_flsa_category) OR NOT(l_fetch_flsa_data) THEN
766: hr_utility.set_location ('FLSA PASS', 40);
767: init_elig_flag := TRUE;
768: ELSE
769: hr_utility.set_location ('FLSA FAIL', 40);
770: init_elig_flag := FALSE;
765: IF (p_mnoa_flsa_category = l_flsa_category) OR NOT(l_fetch_flsa_data) THEN
766: hr_utility.set_location ('FLSA PASS', 40);
767: init_elig_flag := TRUE;
768: ELSE
769: hr_utility.set_location ('FLSA FAIL', 40);
770: init_elig_flag := FALSE;
771: END IF;
772: ELSE --IF (p_mnoa_bargaining_unit = l_bargaining_unit)
773: hr_utility.set_location ('BU FAIL', 55);
769: hr_utility.set_location ('FLSA FAIL', 40);
770: init_elig_flag := FALSE;
771: END IF;
772: ELSE --IF (p_mnoa_bargaining_unit = l_bargaining_unit)
773: hr_utility.set_location ('BU FAIL', 55);
774: init_elig_flag := FALSE;
775: END IF;--IF (p_mnoa_bargaining_unit = l_bargaining_unit)
776: ELSE--IF (l_mnoa_occ_series = l_occ_series)
777: hr_utility.set_location ('OCC FAIL', 35);
773: hr_utility.set_location ('BU FAIL', 55);
774: init_elig_flag := FALSE;
775: END IF;--IF (p_mnoa_bargaining_unit = l_bargaining_unit)
776: ELSE--IF (l_mnoa_occ_series = l_occ_series)
777: hr_utility.set_location ('OCC FAIL', 35);
778: init_elig_flag := FALSE;
779: END IF;--IF (l_mnoa_occ_series = l_occ_series)
780: ELSE --IF p_mnoa_job_id IS NOT NULL
781: hr_utility.set_location ('No Additional Selection CRITERIA', 85);
777: hr_utility.set_location ('OCC FAIL', 35);
778: init_elig_flag := FALSE;
779: END IF;--IF (l_mnoa_occ_series = l_occ_series)
780: ELSE --IF p_mnoa_job_id IS NOT NULL
781: hr_utility.set_location ('No Additional Selection CRITERIA', 85);
782: init_elig_flag := TRUE;
783: END IF; ---IF p_mnoa_job_id IS NOT NULL
784:
785: ELSE
782: init_elig_flag := TRUE;
783: END IF; ---IF p_mnoa_job_id IS NOT NULL
784:
785: ELSE
786: hr_utility.set_location ('DS FAIL', 45);
787: init_elig_flag := FALSE;
788: END IF;
789: ELSE --IF (substr (p_mnoa_agency_code_subelement, 1, 2)
790: hr_utility.set_location ('Agency FAIL', 55);
786: hr_utility.set_location ('DS FAIL', 45);
787: init_elig_flag := FALSE;
788: END IF;
789: ELSE --IF (substr (p_mnoa_agency_code_subelement, 1, 2)
790: hr_utility.set_location ('Agency FAIL', 55);
791: init_elig_flag := FALSE;
792: END IF; --IF (substr (p_mnoa_agency_code_subelement, 1, 2)
793: ELSE --IF (p_mnoa_personnel_office_id = l_personnel_office_id)
794: hr_utility.set_location ('POID FAIL', 65);
790: hr_utility.set_location ('Agency FAIL', 55);
791: init_elig_flag := FALSE;
792: END IF; --IF (substr (p_mnoa_agency_code_subelement, 1, 2)
793: ELSE --IF (p_mnoa_personnel_office_id = l_personnel_office_id)
794: hr_utility.set_location ('POID FAIL', 65);
795: init_elig_flag := FALSE;
796: END IF; --IF (p_mnoa_personnel_office_id = l_personnel_office_id)
797: ELSE --IF nvl (p_mnoa_organization_id, p_organization_id)
798: hr_utility.set_location ('Org FAIL', 75);
794: hr_utility.set_location ('POID FAIL', 65);
795: init_elig_flag := FALSE;
796: END IF; --IF (p_mnoa_personnel_office_id = l_personnel_office_id)
797: ELSE --IF nvl (p_mnoa_organization_id, p_organization_id)
798: hr_utility.set_location ('Org FAIL', 75);
799: init_elig_flag := FALSE;
800: END IF; --IF nvl (p_mnoa_organization_id, p_organization_id)
801: ELSE
802: hr_utility.set_location ('No INIT CRITERIA', 85);
798: hr_utility.set_location ('Org FAIL', 75);
799: init_elig_flag := FALSE;
800: END IF; --IF nvl (p_mnoa_organization_id, p_organization_id)
801: ELSE
802: hr_utility.set_location ('No INIT CRITERIA', 85);
803: init_elig_flag := TRUE;
804: END IF;-- IF p_mnoa_organization_id IS NOT NULL
805:
806: IF init_elig_flag THEN
845: , l_to_grade_or_level, l_step_or_rate
846: , l_pay_basis);
847: EXCEPTION
848: WHEN others THEN
849: hr_utility.set_location ('WHEN OTHERS of get_pay_plan_and_table_id ', 999);
850: END;
851:
852: p_personnel_office_id := l_personnel_office_id;
853: p_org_structure_id := l_org_structure_id;
875: p_elig_flag :=FALSE;
876: END IF;
877: --End bug# 14805985
878: END IF;--IF init_elig_flag THEN
879: hr_utility.set_location ('Leaving '|| l_proc, 184);
880: EXCEPTION
881: WHEN others THEN
882: hr_utility.set_location ('WHEN OTHERS'|| l_proc, 185);
883: RAISE;
878: END IF;--IF init_elig_flag THEN
879: hr_utility.set_location ('Leaving '|| l_proc, 184);
880: EXCEPTION
881: WHEN others THEN
882: hr_utility.set_location ('WHEN OTHERS'|| l_proc, 185);
883: RAISE;
884: END fetch_and_validate_emp;
885:
886: PROCEDURE create_mass_noa_prev
967:
968: BEGIN
969: g_proc := 'create_mass_noa_prev';
970:
971: hr_utility.set_location ('Entering '
972: || l_proc, 5);
973: l_temp_noa_code := l_noa_code;
974: l_poi_desc := ghr_mre_pkg.get_poi_name (p_personnel_office_id);
975:
992: (p_cust_in_rec => l_cust_in_rec
993: , p_cust_rec => l_cust_rec );
994: EXCEPTION
995: WHEN others THEN
996: hr_utility.set_location ('Error in Mass Act Custom '
997: || 'Err is '
998: || sqlerrm (sqlcode), 20);
999:
1000: l_noaerrbuf := 'Error in Mass Act Custom '
1295: , l_cust_rec.user_attribute18
1296: , l_cust_rec.user_attribute19
1297: , l_cust_rec.user_attribute20);
1298:
1299: hr_utility.set_location ('Exiting '
1300: || l_proc, 10);
1301: EXCEPTION
1302: WHEN mnoa_error THEN
1303: RAISE;
1301: EXCEPTION
1302: WHEN mnoa_error THEN
1303: RAISE;
1304: WHEN others THEN
1305: hr_utility.set_location ('Error in '
1306: || l_proc
1307: || ' Err is '
1308: || sqlerrm (sqlcode), 20);
1309:
1338: l_proc varchar2(72) DEFAULT g_package|| '.ins_upd_per_extra_info';
1339: l_eff_date date;
1340: BEGIN
1341: g_proc := 'ins_upd_per_extra_info';
1342: hr_utility.set_location ('Entering '|| l_proc, 5);
1343:
1344: IF p_effective_date > sysdate THEN
1345: l_eff_date := sysdate;
1346: ELSE
1384: , p_person_extra_info_id => l_person_extra_info_id
1385: , p_object_version_number => l_object_version_number);
1386: END IF;
1387:
1388: hr_utility.set_location ('Exiting '|| l_proc, 10);
1389: EXCEPTION
1390: WHEN mnoa_error THEN
1391: RAISE;
1392: WHEN others THEN
1391: RAISE;
1392: WHEN others THEN
1393: pr ('Error in '|| l_proc);
1394:
1395: hr_utility.set_location ('Error in '|| l_proc|| ' Err is '|| sqlerrm (sqlcode), 20);
1396: l_noaerrbuf := 'Error in '|| l_proc|| ' Sql Err is '|| sqlerrm (sqlcode);
1397: RAISE mnoa_error;
1398: END ins_upd_per_extra_info;
1399:
1408: WHERE pa_request_id = p_pa_request_id;
1409: BEGIN
1410: g_proc := 'get_lac_dtls';
1411:
1412: hr_utility.set_location ('Entering '|| l_proc, 5);
1413:
1414: pr ('Entering '|| l_proc|| ' Pa req id ', to_char (p_pa_request_id));
1415:
1416: IF p_pa_request_id IS NULL THEN
1420: p_sf52_rec := cur_pa_rec;
1421: EXIT;
1422: END LOOP;
1423: END IF;
1424: hr_utility.set_location ('Exiting '|| l_proc, 10);
1425: EXCEPTION
1426: WHEN others THEN
1427: hr_utility.set_location ('Error in '|| l_proc|| ' Err is '|| sqlerrm (sqlcode), 20);
1428: l_noaerrbuf := 'Error in '|| l_proc|| ' Sql Err is '|| sqlerrm (sqlcode);
1423: END IF;
1424: hr_utility.set_location ('Exiting '|| l_proc, 10);
1425: EXCEPTION
1426: WHEN others THEN
1427: hr_utility.set_location ('Error in '|| l_proc|| ' Err is '|| sqlerrm (sqlcode), 20);
1428: l_noaerrbuf := 'Error in '|| l_proc|| ' Sql Err is '|| sqlerrm (sqlcode);
1429: RAISE mnoa_error;
1430: END get_lac_dtls;
1431:
1432: PROCEDURE update_position_info
1433: (p_position_data_rec IN ghr_sf52_pos_update.position_data_rec_type) IS
1434: l_proc varchar2(30) DEFAULT 'update_position_info';
1435: BEGIN
1436: hr_utility.set_location ('Entering '|| l_proc, 10);
1437: hr_utility.set_location ('Vacant Position ID '|| to_char (p_position_data_rec.position_id), 10);
1438:
1439: ghr_session.set_session_var_for_core (p_position_data_rec.effective_end_date);
1440:
1433: (p_position_data_rec IN ghr_sf52_pos_update.position_data_rec_type) IS
1434: l_proc varchar2(30) DEFAULT 'update_position_info';
1435: BEGIN
1436: hr_utility.set_location ('Entering '|| l_proc, 10);
1437: hr_utility.set_location ('Vacant Position ID '|| to_char (p_position_data_rec.position_id), 10);
1438:
1439: ghr_session.set_session_var_for_core (p_position_data_rec.effective_end_date);
1440:
1441: ghr_sf52_pos_update.update_position_info
1440:
1441: ghr_sf52_pos_update.update_position_info
1442: (p_pos_data_rec => p_position_data_rec);
1443:
1444: hr_utility.set_location ('Calling post_update_process '|| l_proc, 50);
1445: ghr_history_api.post_update_process;
1446: hr_utility.set_location ('Leaving '|| l_proc, 100);
1447: END update_position_info;
1448:
1442: (p_pos_data_rec => p_position_data_rec);
1443:
1444: hr_utility.set_location ('Calling post_update_process '|| l_proc, 50);
1445: ghr_history_api.post_update_process;
1446: hr_utility.set_location ('Leaving '|| l_proc, 100);
1447: END update_position_info;
1448:
1449: PROCEDURE get_pos_grp1_ddf
1450: (p_position_id IN per_assignments_f.position_id%TYPE
1456: l_proc varchar2(72) DEFAULT g_package|| '.get_pos_grp1_ddf';
1457: BEGIN
1458: g_proc := 'get_pos_grp1_ddf';
1459:
1460: hr_utility.set_location ('Entering '|| l_proc, 5);
1461:
1462: ghr_history_fetch.fetch_positionei
1463: (p_position_id => p_position_id
1464: , p_information_type => 'GHR_US_POS_GRP1'
1468: p_flsa_category := p_pos_ei_data.poei_information7;
1469: p_barg_unit_status := p_pos_ei_data.poei_information8;
1470: p_functional_class := p_pos_ei_data.poei_information11;
1471:
1472: hr_utility.set_location ('Exiting '|| l_proc, 10);
1473: EXCEPTION
1474: WHEN mnoa_error THEN
1475: RAISE;
1476: WHEN others THEN
1480: p_pos_ei_data := NULL;
1481:
1482: pr ('Error in '|| l_proc);
1483:
1484: hr_utility.set_location ('Error in '|| l_proc|| ' Err is '|| sqlerrm (sqlcode), 20);
1485:
1486: l_noaerrbuf := 'Error in '|| l_proc|| ' Sql Err is '|| sqlerrm (sqlcode);
1487:
1488: RAISE mnoa_error;
2097: , p_effective_date => l_effective_date
2098: , p_duty_station_code => l_duty_station_code
2099: , p_duty_station_desc => l_duty_station_desc);
2100:
2101: hr_utility.set_location ('The duty station name is:'
2102: || l_duty_station_code, 12345);
2103: EXCEPTION
2104: WHEN others THEN
2105: hr_utility.set_location ('Error in Ghr_pa_requests_pkg.get_duty_station_details'
2101: hr_utility.set_location ('The duty station name is:'
2102: || l_duty_station_code, 12345);
2103: EXCEPTION
2104: WHEN others THEN
2105: hr_utility.set_location ('Error in Ghr_pa_requests_pkg.get_duty_station_details'
2106: || 'Err is '
2107: || sqlerrm (sqlcode), 20);
2108:
2109: l_noaerrbuf := 'Error in get_duty_station_details Sql Err is '
2117: , p_effective_date => l_effective_date
2118: , p_duty_station_code => l_vac_duty_station_code
2119: , p_duty_station_desc => l_vac_duty_station_desc);
2120:
2121: hr_utility.set_location ('The target duty station name is:'
2122: || l_vac_duty_station_code, 12345);
2123: EXCEPTION
2124: WHEN others THEN
2125: hr_utility.set_location ('Error in Target get Ghr_pa_requests_pkg.get_duty_station_details'
2121: hr_utility.set_location ('The target duty station name is:'
2122: || l_vac_duty_station_code, 12345);
2123: EXCEPTION
2124: WHEN others THEN
2125: hr_utility.set_location ('Error in Target get Ghr_pa_requests_pkg.get_duty_station_details'
2126: || 'Err is '
2127: || sqlerrm (sqlcode), 20);
2128:
2129: l_noaerrbuf := 'Error in Target get duty_station_details Sql Err is '
2214: , l_vac_flsa_category, l_vac_barg_unit_status, l_vac_functional_class
2215: , l_new_pos_grp1_rec);
2216:
2217: IF l_noa_code = '800' THEN
2218: hr_utility.set_location ('Assigning Position Elements for NOA: 800 '
2219: || l_proc, 139);
2220:
2221: IF l_target_agency_code_subelmt IS NOT NULL THEN
2222: l_position_data_rec.agency_code_subelement := l_target_agency_code_subelmt;
2279:
2280: ghr_api.g_api_dml := FALSE;
2281: END IF;
2282: ELSIF l_noa_code = '792' THEN
2283: hr_utility.set_location ('Bargaining unit for NOA: 792 '
2284: || l_target_barg_unit_status, 139);
2285:
2286: IF l_vac_barg_unit_status
2287: <> nvl (l_target_barg_unit_status, l_vac_barg_unit_status) THEN
2360: END IF;
2361: END IF;
2362: EXCEPTION
2363: WHEN mnoa_error THEN
2364: hr_utility.set_location ('Error occurred in '
2365: || l_proc
2366: || ' Sql error '
2367: || sqlerrm (sqlcode), 10);
2368:
2386: || l_position_id
2387: || ' '
2388: || l_noaerrbuf;
2389:
2390: hr_utility.set_location ('before creating entry in log file', 10);
2391:
2392: l_recs_failed := l_recs_failed + 1;
2393:
2394: BEGIN
2396: (p_procedure => g_proc
2397: , p_message => l_log_text);
2398: EXCEPTION
2399: WHEN others THEN
2400: hr_utility.set_message (8301, 'GHR_38475_ERROR_LOG_FAILURE');
2401:
2402: hr_utility.raise_error;
2403: END;
2404: WHEN others THEN
2398: EXCEPTION
2399: WHEN others THEN
2400: hr_utility.set_message (8301, 'GHR_38475_ERROR_LOG_FAILURE');
2401:
2402: hr_utility.raise_error;
2403: END;
2404: WHEN others THEN
2405: hr_utility.set_location ('Error (Others2) occurred in '
2406: || l_proc
2401:
2402: hr_utility.raise_error;
2403: END;
2404: WHEN others THEN
2405: hr_utility.set_location ('Error (Others2) occurred in '
2406: || l_proc
2407: || ' Sql error '
2408: || sqlerrm (sqlcode), 30);
2409:
2422: || sqlerrm (sqlcode);
2423:
2424: l_recs_failed := l_recs_failed + 1;
2425:
2426: hr_utility.set_location ('before creating entry in log file', 30);
2427:
2428: p_errbuf := 'Error in '
2429: || l_proc
2430: || ' Details in GHR_PROCESS_LOG';
2444: (p_procedure => g_proc
2445: , p_message => l_log_text);
2446: EXCEPTION
2447: WHEN others THEN
2448: hr_utility.set_message (8301, 'Create Error Log failed');
2449:
2450: hr_utility.raise_error;
2451: END;
2452: END vacant_pos_process;
2446: EXCEPTION
2447: WHEN others THEN
2448: hr_utility.set_message (8301, 'Create Error Log failed');
2449:
2450: hr_utility.raise_error;
2451: END;
2452: END vacant_pos_process;
2453:
2454:
2534: , p_effective_date => l_effective_date
2535: , p_duty_station_code => l_duty_station_code
2536: , p_duty_station_desc => l_duty_station_desc);
2537:
2538: hr_utility.set_location ('The duty station name is:'|| l_duty_station_code, 12345);
2539:
2540: hr_utility.set_location ('The duty station desc is:'|| l_duty_station_desc, 12345);
2541: EXCEPTION
2542: WHEN others THEN
2536: , p_duty_station_desc => l_duty_station_desc);
2537:
2538: hr_utility.set_location ('The duty station name is:'|| l_duty_station_code, 12345);
2539:
2540: hr_utility.set_location ('The duty station desc is:'|| l_duty_station_desc, 12345);
2541: EXCEPTION
2542: WHEN others THEN
2543: hr_utility.set_location ('Error in Ghr_pa_requests_pkg.get_duty_station_details'|| 'Err is '|| sqlerrm (sqlcode), 20);
2544: l_noaerrbuf := 'Error in get_duty_station_details Sql Err is '|| sqlerrm (sqlcode);
2539:
2540: hr_utility.set_location ('The duty station desc is:'|| l_duty_station_desc, 12345);
2541: EXCEPTION
2542: WHEN others THEN
2543: hr_utility.set_location ('Error in Ghr_pa_requests_pkg.get_duty_station_details'|| 'Err is '|| sqlerrm (sqlcode), 20);
2544: l_noaerrbuf := 'Error in get_duty_station_details Sql Err is '|| sqlerrm (sqlcode);
2545: RAISE mnoa_error;
2546: END;
2547: -- Begin Bug# 14751973
2552: , p_effective_date => l_effective_date
2553: , p_duty_station_code => l_target_duty_station_code
2554: , p_duty_station_desc => l_target_duty_station_desc);
2555:
2556: hr_utility.set_location ('The Target duty station name is:'|| l_target_duty_station_code, 12346);
2557: EXCEPTION
2558: WHEN others THEN
2559: hr_utility.set_location ('Error in Target Ghr_pa_requests_pkg.get_duty_station_details'|| 'Err is '|| sqlerrm (sqlcode), 20);
2560: l_noaerrbuf := 'Error in Target get_duty_station_details Sql Err is '|| sqlerrm (sqlcode);
2555:
2556: hr_utility.set_location ('The Target duty station name is:'|| l_target_duty_station_code, 12346);
2557: EXCEPTION
2558: WHEN others THEN
2559: hr_utility.set_location ('Error in Target Ghr_pa_requests_pkg.get_duty_station_details'|| 'Err is '|| sqlerrm (sqlcode), 20);
2560: l_noaerrbuf := 'Error in Target get_duty_station_details Sql Err is '|| sqlerrm (sqlcode);
2561: RAISE mnoa_error;
2562: END;
2563: END IF;
2561: RAISE mnoa_error;
2562: END;
2563: END IF;
2564: -- End Bug# 14751973
2565: hr_utility.set_location ('Before calling ghr_msl_pkg.get_from_sf52_data_elements :'|| l_proc, 70);
2566: ghr_msl_pkg.get_from_sf52_data_elements (l_assignment_id, l_effective_date
2567: , l_old_basic_pay, l_old_avail_pay
2568: , l_old_loc_diff, l_tot_old_sal
2569: , l_old_auo_pay, l_old_adj_basic_pay
2571: , l_ap_premium_pay_indicator, l_retention_allowance
2572: , l_retention_allow_perc, l_supervisory_differential
2573: , l_supervisory_diff_perc, l_staffing_differential);
2574:
2575: hr_utility.set_location ('After calling ghr_msl_pkg.get_from_sf52_data_elements :'|| l_proc, 71);
2576: --Begin Bug# 14414972, for NON_PAY_DUTY_STATION family pay calc is not required, so skipping
2577: IF l_noa_code NOT IN ('430','460','471','472') THEN
2578: l_pay_calc_in_data.person_id := p_person_id;
2579: l_pay_calc_in_data.position_id := l_position_id;
2603:
2604: l_pay_calc_in_data.pa_request_id := NULL;
2605:
2606: BEGIN
2607: hr_utility.set_location ('Pay calc Calling :'|| l_pay_calc_in_data.noa_code, 123);
2608:
2609: ghr_pay_calc.sql_main_pay_calc (l_pay_calc_in_data, l_pay_calc_out_data
2610: , l_message_set, l_calculated);
2611:
2609: ghr_pay_calc.sql_main_pay_calc (l_pay_calc_in_data, l_pay_calc_out_data
2610: , l_message_set, l_calculated);
2611:
2612: IF l_message_set THEN
2613: hr_utility.set_location (l_proc, 40);
2614: l_calculated := FALSE;
2615: l_noaerrbuf := hr_utility.get_message;
2616: END IF;
2617: EXCEPTION
2611:
2612: IF l_message_set THEN
2613: hr_utility.set_location (l_proc, 40);
2614: l_calculated := FALSE;
2615: l_noaerrbuf := hr_utility.get_message;
2616: END IF;
2617: EXCEPTION
2618: WHEN mnoa_error THEN
2619: g_proc := 'ghr_pay_calc';
2618: WHEN mnoa_error THEN
2619: g_proc := 'ghr_pay_calc';
2620: RAISE;
2621: WHEN others THEN
2622: hr_utility.set_location ('Pay Calc Exception :'|| l_pay_calc_in_data.noa_code, 124);
2623:
2624: IF ghr_pay_calc.gm_unadjusted_pay_flg = 'Y' THEN
2625: l_comment := 'MNOA:Error: Unadjusted Basic Pay must be entered in Employee record.';
2626: ELSE
2677: ins_upd_per_extra_info (p_person_id, l_effective_date
2678: , l_sel_flg, l_comment
2679: , p_mass_salary_id);
2680: l_comment := NULL;
2681: hr_utility.set_location ('Error in Ghr_pay_calc.sql_main_pay_calc '|| 'Err is '|| sqlerrm (sqlcode), 20);
2682: l_noaerrbuf := 'Error in ghr_pay_calc Sql Err is '|| sqlerrm (sqlcode);
2683: g_proc := 'ghr_pay_calc';
2684: RAISE mnoa_error;
2685: END;
2717: (p_assignment_id => l_assignment_id
2718: , p_effective_date => l_effective_date);
2719:
2720: l_old_capped_other_pay := l_capped_other_pay;
2721: IF hr_utility.debug_enabled = TRUE THEN
2722: hr_utility.set_location ('Before Pay Cap '|| l_proc, 21);
2723: hr_utility.set_location ('l_effective_date '|| l_effective_date, 21);
2724: hr_utility.set_location ('l_out_pay_rate_determinant '|| l_out_pay_rate_determinant, 21);
2725: hr_utility.set_location ('l_pay_plan '|| l_pay_plan, 21);
2718: , p_effective_date => l_effective_date);
2719:
2720: l_old_capped_other_pay := l_capped_other_pay;
2721: IF hr_utility.debug_enabled = TRUE THEN
2722: hr_utility.set_location ('Before Pay Cap '|| l_proc, 21);
2723: hr_utility.set_location ('l_effective_date '|| l_effective_date, 21);
2724: hr_utility.set_location ('l_out_pay_rate_determinant '|| l_out_pay_rate_determinant, 21);
2725: hr_utility.set_location ('l_pay_plan '|| l_pay_plan, 21);
2726: hr_utility.set_location ('l_position_id '|| to_char (l_position_id), 21);
2719:
2720: l_old_capped_other_pay := l_capped_other_pay;
2721: IF hr_utility.debug_enabled = TRUE THEN
2722: hr_utility.set_location ('Before Pay Cap '|| l_proc, 21);
2723: hr_utility.set_location ('l_effective_date '|| l_effective_date, 21);
2724: hr_utility.set_location ('l_out_pay_rate_determinant '|| l_out_pay_rate_determinant, 21);
2725: hr_utility.set_location ('l_pay_plan '|| l_pay_plan, 21);
2726: hr_utility.set_location ('l_position_id '|| to_char (l_position_id), 21);
2727: hr_utility.set_location ('l_pay_basis '|| l_pay_basis, 21);
2720: l_old_capped_other_pay := l_capped_other_pay;
2721: IF hr_utility.debug_enabled = TRUE THEN
2722: hr_utility.set_location ('Before Pay Cap '|| l_proc, 21);
2723: hr_utility.set_location ('l_effective_date '|| l_effective_date, 21);
2724: hr_utility.set_location ('l_out_pay_rate_determinant '|| l_out_pay_rate_determinant, 21);
2725: hr_utility.set_location ('l_pay_plan '|| l_pay_plan, 21);
2726: hr_utility.set_location ('l_position_id '|| to_char (l_position_id), 21);
2727: hr_utility.set_location ('l_pay_basis '|| l_pay_basis, 21);
2728: hr_utility.set_location ('person_id '|| to_char (p_person_id), 21);
2721: IF hr_utility.debug_enabled = TRUE THEN
2722: hr_utility.set_location ('Before Pay Cap '|| l_proc, 21);
2723: hr_utility.set_location ('l_effective_date '|| l_effective_date, 21);
2724: hr_utility.set_location ('l_out_pay_rate_determinant '|| l_out_pay_rate_determinant, 21);
2725: hr_utility.set_location ('l_pay_plan '|| l_pay_plan, 21);
2726: hr_utility.set_location ('l_position_id '|| to_char (l_position_id), 21);
2727: hr_utility.set_location ('l_pay_basis '|| l_pay_basis, 21);
2728: hr_utility.set_location ('person_id '|| to_char (p_person_id), 21);
2729: hr_utility.set_location ('l_new_basic_pay ' || to_char (l_new_basic_pay), 21);
2722: hr_utility.set_location ('Before Pay Cap '|| l_proc, 21);
2723: hr_utility.set_location ('l_effective_date '|| l_effective_date, 21);
2724: hr_utility.set_location ('l_out_pay_rate_determinant '|| l_out_pay_rate_determinant, 21);
2725: hr_utility.set_location ('l_pay_plan '|| l_pay_plan, 21);
2726: hr_utility.set_location ('l_position_id '|| to_char (l_position_id), 21);
2727: hr_utility.set_location ('l_pay_basis '|| l_pay_basis, 21);
2728: hr_utility.set_location ('person_id '|| to_char (p_person_id), 21);
2729: hr_utility.set_location ('l_new_basic_pay ' || to_char (l_new_basic_pay), 21);
2730: hr_utility.set_location ('l_new_locality_adj '|| to_char (l_new_locality_adj), 21);
2723: hr_utility.set_location ('l_effective_date '|| l_effective_date, 21);
2724: hr_utility.set_location ('l_out_pay_rate_determinant '|| l_out_pay_rate_determinant, 21);
2725: hr_utility.set_location ('l_pay_plan '|| l_pay_plan, 21);
2726: hr_utility.set_location ('l_position_id '|| to_char (l_position_id), 21);
2727: hr_utility.set_location ('l_pay_basis '|| l_pay_basis, 21);
2728: hr_utility.set_location ('person_id '|| to_char (p_person_id), 21);
2729: hr_utility.set_location ('l_new_basic_pay ' || to_char (l_new_basic_pay), 21);
2730: hr_utility.set_location ('l_new_locality_adj '|| to_char (l_new_locality_adj), 21);
2731: hr_utility.set_location ('l_new_adj_basic_pay '|| to_char (l_new_adj_basic_pay), 21);
2724: hr_utility.set_location ('l_out_pay_rate_determinant '|| l_out_pay_rate_determinant, 21);
2725: hr_utility.set_location ('l_pay_plan '|| l_pay_plan, 21);
2726: hr_utility.set_location ('l_position_id '|| to_char (l_position_id), 21);
2727: hr_utility.set_location ('l_pay_basis '|| l_pay_basis, 21);
2728: hr_utility.set_location ('person_id '|| to_char (p_person_id), 21);
2729: hr_utility.set_location ('l_new_basic_pay ' || to_char (l_new_basic_pay), 21);
2730: hr_utility.set_location ('l_new_locality_adj '|| to_char (l_new_locality_adj), 21);
2731: hr_utility.set_location ('l_new_adj_basic_pay '|| to_char (l_new_adj_basic_pay), 21);
2732: hr_utility.set_location ('l_new_total_salary '|| to_char (l_new_total_salary), 21);
2725: hr_utility.set_location ('l_pay_plan '|| l_pay_plan, 21);
2726: hr_utility.set_location ('l_position_id '|| to_char (l_position_id), 21);
2727: hr_utility.set_location ('l_pay_basis '|| l_pay_basis, 21);
2728: hr_utility.set_location ('person_id '|| to_char (p_person_id), 21);
2729: hr_utility.set_location ('l_new_basic_pay ' || to_char (l_new_basic_pay), 21);
2730: hr_utility.set_location ('l_new_locality_adj '|| to_char (l_new_locality_adj), 21);
2731: hr_utility.set_location ('l_new_adj_basic_pay '|| to_char (l_new_adj_basic_pay), 21);
2732: hr_utility.set_location ('l_new_total_salary '|| to_char (l_new_total_salary), 21);
2733: hr_utility.set_location ('l_entitled_other_pay '|| to_char (l_entitled_other_pay), 21);
2726: hr_utility.set_location ('l_position_id '|| to_char (l_position_id), 21);
2727: hr_utility.set_location ('l_pay_basis '|| l_pay_basis, 21);
2728: hr_utility.set_location ('person_id '|| to_char (p_person_id), 21);
2729: hr_utility.set_location ('l_new_basic_pay ' || to_char (l_new_basic_pay), 21);
2730: hr_utility.set_location ('l_new_locality_adj '|| to_char (l_new_locality_adj), 21);
2731: hr_utility.set_location ('l_new_adj_basic_pay '|| to_char (l_new_adj_basic_pay), 21);
2732: hr_utility.set_location ('l_new_total_salary '|| to_char (l_new_total_salary), 21);
2733: hr_utility.set_location ('l_entitled_other_pay '|| to_char (l_entitled_other_pay), 21);
2734: hr_utility.set_location ('l_capped_other_pay '|| to_char (l_capped_other_pay), 21);
2727: hr_utility.set_location ('l_pay_basis '|| l_pay_basis, 21);
2728: hr_utility.set_location ('person_id '|| to_char (p_person_id), 21);
2729: hr_utility.set_location ('l_new_basic_pay ' || to_char (l_new_basic_pay), 21);
2730: hr_utility.set_location ('l_new_locality_adj '|| to_char (l_new_locality_adj), 21);
2731: hr_utility.set_location ('l_new_adj_basic_pay '|| to_char (l_new_adj_basic_pay), 21);
2732: hr_utility.set_location ('l_new_total_salary '|| to_char (l_new_total_salary), 21);
2733: hr_utility.set_location ('l_entitled_other_pay '|| to_char (l_entitled_other_pay), 21);
2734: hr_utility.set_location ('l_capped_other_pay '|| to_char (l_capped_other_pay), 21);
2735: hr_utility.set_location ('l_new_retention_allowance '|| to_char (l_new_retention_allowance), 21);
2728: hr_utility.set_location ('person_id '|| to_char (p_person_id), 21);
2729: hr_utility.set_location ('l_new_basic_pay ' || to_char (l_new_basic_pay), 21);
2730: hr_utility.set_location ('l_new_locality_adj '|| to_char (l_new_locality_adj), 21);
2731: hr_utility.set_location ('l_new_adj_basic_pay '|| to_char (l_new_adj_basic_pay), 21);
2732: hr_utility.set_location ('l_new_total_salary '|| to_char (l_new_total_salary), 21);
2733: hr_utility.set_location ('l_entitled_other_pay '|| to_char (l_entitled_other_pay), 21);
2734: hr_utility.set_location ('l_capped_other_pay '|| to_char (l_capped_other_pay), 21);
2735: hr_utility.set_location ('l_new_retention_allowance '|| to_char (l_new_retention_allowance), 21);
2736: hr_utility.set_location ('l_new_supervisory_differential ' || to_char (l_new_supervisory_differential), 21);
2729: hr_utility.set_location ('l_new_basic_pay ' || to_char (l_new_basic_pay), 21);
2730: hr_utility.set_location ('l_new_locality_adj '|| to_char (l_new_locality_adj), 21);
2731: hr_utility.set_location ('l_new_adj_basic_pay '|| to_char (l_new_adj_basic_pay), 21);
2732: hr_utility.set_location ('l_new_total_salary '|| to_char (l_new_total_salary), 21);
2733: hr_utility.set_location ('l_entitled_other_pay '|| to_char (l_entitled_other_pay), 21);
2734: hr_utility.set_location ('l_capped_other_pay '|| to_char (l_capped_other_pay), 21);
2735: hr_utility.set_location ('l_new_retention_allowance '|| to_char (l_new_retention_allowance), 21);
2736: hr_utility.set_location ('l_new_supervisory_differential ' || to_char (l_new_supervisory_differential), 21);
2737: hr_utility.set_location ('l_staffing_differential '|| to_char (l_staffing_differential), 21);
2730: hr_utility.set_location ('l_new_locality_adj '|| to_char (l_new_locality_adj), 21);
2731: hr_utility.set_location ('l_new_adj_basic_pay '|| to_char (l_new_adj_basic_pay), 21);
2732: hr_utility.set_location ('l_new_total_salary '|| to_char (l_new_total_salary), 21);
2733: hr_utility.set_location ('l_entitled_other_pay '|| to_char (l_entitled_other_pay), 21);
2734: hr_utility.set_location ('l_capped_other_pay '|| to_char (l_capped_other_pay), 21);
2735: hr_utility.set_location ('l_new_retention_allowance '|| to_char (l_new_retention_allowance), 21);
2736: hr_utility.set_location ('l_new_supervisory_differential ' || to_char (l_new_supervisory_differential), 21);
2737: hr_utility.set_location ('l_staffing_differential '|| to_char (l_staffing_differential), 21);
2738: hr_utility.set_location ('l_new_au_overtime '|| to_char (l_new_au_overtime), 21);
2731: hr_utility.set_location ('l_new_adj_basic_pay '|| to_char (l_new_adj_basic_pay), 21);
2732: hr_utility.set_location ('l_new_total_salary '|| to_char (l_new_total_salary), 21);
2733: hr_utility.set_location ('l_entitled_other_pay '|| to_char (l_entitled_other_pay), 21);
2734: hr_utility.set_location ('l_capped_other_pay '|| to_char (l_capped_other_pay), 21);
2735: hr_utility.set_location ('l_new_retention_allowance '|| to_char (l_new_retention_allowance), 21);
2736: hr_utility.set_location ('l_new_supervisory_differential ' || to_char (l_new_supervisory_differential), 21);
2737: hr_utility.set_location ('l_staffing_differential '|| to_char (l_staffing_differential), 21);
2738: hr_utility.set_location ('l_new_au_overtime '|| to_char (l_new_au_overtime), 21);
2739: hr_utility.set_location ('l_new_availability_pay '|| to_char (l_new_availability_pay), 21);
2732: hr_utility.set_location ('l_new_total_salary '|| to_char (l_new_total_salary), 21);
2733: hr_utility.set_location ('l_entitled_other_pay '|| to_char (l_entitled_other_pay), 21);
2734: hr_utility.set_location ('l_capped_other_pay '|| to_char (l_capped_other_pay), 21);
2735: hr_utility.set_location ('l_new_retention_allowance '|| to_char (l_new_retention_allowance), 21);
2736: hr_utility.set_location ('l_new_supervisory_differential ' || to_char (l_new_supervisory_differential), 21);
2737: hr_utility.set_location ('l_staffing_differential '|| to_char (l_staffing_differential), 21);
2738: hr_utility.set_location ('l_new_au_overtime '|| to_char (l_new_au_overtime), 21);
2739: hr_utility.set_location ('l_new_availability_pay '|| to_char (l_new_availability_pay), 21);
2740: END IF;
2733: hr_utility.set_location ('l_entitled_other_pay '|| to_char (l_entitled_other_pay), 21);
2734: hr_utility.set_location ('l_capped_other_pay '|| to_char (l_capped_other_pay), 21);
2735: hr_utility.set_location ('l_new_retention_allowance '|| to_char (l_new_retention_allowance), 21);
2736: hr_utility.set_location ('l_new_supervisory_differential ' || to_char (l_new_supervisory_differential), 21);
2737: hr_utility.set_location ('l_staffing_differential '|| to_char (l_staffing_differential), 21);
2738: hr_utility.set_location ('l_new_au_overtime '|| to_char (l_new_au_overtime), 21);
2739: hr_utility.set_location ('l_new_availability_pay '|| to_char (l_new_availability_pay), 21);
2740: END IF;
2741:
2734: hr_utility.set_location ('l_capped_other_pay '|| to_char (l_capped_other_pay), 21);
2735: hr_utility.set_location ('l_new_retention_allowance '|| to_char (l_new_retention_allowance), 21);
2736: hr_utility.set_location ('l_new_supervisory_differential ' || to_char (l_new_supervisory_differential), 21);
2737: hr_utility.set_location ('l_staffing_differential '|| to_char (l_staffing_differential), 21);
2738: hr_utility.set_location ('l_new_au_overtime '|| to_char (l_new_au_overtime), 21);
2739: hr_utility.set_location ('l_new_availability_pay '|| to_char (l_new_availability_pay), 21);
2740: END IF;
2741:
2742: ghr_pay_caps.do_pay_caps_main
2735: hr_utility.set_location ('l_new_retention_allowance '|| to_char (l_new_retention_allowance), 21);
2736: hr_utility.set_location ('l_new_supervisory_differential ' || to_char (l_new_supervisory_differential), 21);
2737: hr_utility.set_location ('l_staffing_differential '|| to_char (l_staffing_differential), 21);
2738: hr_utility.set_location ('l_new_au_overtime '|| to_char (l_new_au_overtime), 21);
2739: hr_utility.set_location ('l_new_availability_pay '|| to_char (l_new_availability_pay), 21);
2740: END IF;
2741:
2742: ghr_pay_caps.do_pay_caps_main
2743: (p_pa_request_id => NULL
2769: , p_total_pay_check => l_total_pay_check);
2770:
2771: l_new_other_pay_amount := nvl (l_capped_other_pay, l_entitled_other_pay);
2772:
2773: IF hr_utility.debug_enabled = TRUE THEN
2774: hr_utility.set_location ('After Pay Cap '|| l_proc, 22);
2775: hr_utility.set_location ('l_effective_date '|| l_effective_date, 22);
2776: hr_utility.set_location ('l_out_pay_rate_determinant ' || l_out_pay_rate_determinant, 22);
2777: hr_utility.set_location ('l_pay_plan ' || l_pay_plan, 22);
2770:
2771: l_new_other_pay_amount := nvl (l_capped_other_pay, l_entitled_other_pay);
2772:
2773: IF hr_utility.debug_enabled = TRUE THEN
2774: hr_utility.set_location ('After Pay Cap '|| l_proc, 22);
2775: hr_utility.set_location ('l_effective_date '|| l_effective_date, 22);
2776: hr_utility.set_location ('l_out_pay_rate_determinant ' || l_out_pay_rate_determinant, 22);
2777: hr_utility.set_location ('l_pay_plan ' || l_pay_plan, 22);
2778: hr_utility.set_location ('l_position_id '|| to_char (l_position_id), 22);
2771: l_new_other_pay_amount := nvl (l_capped_other_pay, l_entitled_other_pay);
2772:
2773: IF hr_utility.debug_enabled = TRUE THEN
2774: hr_utility.set_location ('After Pay Cap '|| l_proc, 22);
2775: hr_utility.set_location ('l_effective_date '|| l_effective_date, 22);
2776: hr_utility.set_location ('l_out_pay_rate_determinant ' || l_out_pay_rate_determinant, 22);
2777: hr_utility.set_location ('l_pay_plan ' || l_pay_plan, 22);
2778: hr_utility.set_location ('l_position_id '|| to_char (l_position_id), 22);
2779: hr_utility.set_location ('l_pay_basis '|| l_pay_basis, 22);
2772:
2773: IF hr_utility.debug_enabled = TRUE THEN
2774: hr_utility.set_location ('After Pay Cap '|| l_proc, 22);
2775: hr_utility.set_location ('l_effective_date '|| l_effective_date, 22);
2776: hr_utility.set_location ('l_out_pay_rate_determinant ' || l_out_pay_rate_determinant, 22);
2777: hr_utility.set_location ('l_pay_plan ' || l_pay_plan, 22);
2778: hr_utility.set_location ('l_position_id '|| to_char (l_position_id), 22);
2779: hr_utility.set_location ('l_pay_basis '|| l_pay_basis, 22);
2780: hr_utility.set_location ('person_id '|| to_char (p_person_id), 22);
2773: IF hr_utility.debug_enabled = TRUE THEN
2774: hr_utility.set_location ('After Pay Cap '|| l_proc, 22);
2775: hr_utility.set_location ('l_effective_date '|| l_effective_date, 22);
2776: hr_utility.set_location ('l_out_pay_rate_determinant ' || l_out_pay_rate_determinant, 22);
2777: hr_utility.set_location ('l_pay_plan ' || l_pay_plan, 22);
2778: hr_utility.set_location ('l_position_id '|| to_char (l_position_id), 22);
2779: hr_utility.set_location ('l_pay_basis '|| l_pay_basis, 22);
2780: hr_utility.set_location ('person_id '|| to_char (p_person_id), 22);
2781: hr_utility.set_location ('l_new_basic_pay '|| to_char (l_new_basic_pay), 22);
2774: hr_utility.set_location ('After Pay Cap '|| l_proc, 22);
2775: hr_utility.set_location ('l_effective_date '|| l_effective_date, 22);
2776: hr_utility.set_location ('l_out_pay_rate_determinant ' || l_out_pay_rate_determinant, 22);
2777: hr_utility.set_location ('l_pay_plan ' || l_pay_plan, 22);
2778: hr_utility.set_location ('l_position_id '|| to_char (l_position_id), 22);
2779: hr_utility.set_location ('l_pay_basis '|| l_pay_basis, 22);
2780: hr_utility.set_location ('person_id '|| to_char (p_person_id), 22);
2781: hr_utility.set_location ('l_new_basic_pay '|| to_char (l_new_basic_pay), 22);
2782: hr_utility.set_location ('l_new_locality_adj '|| to_char (l_new_locality_adj), 22);
2775: hr_utility.set_location ('l_effective_date '|| l_effective_date, 22);
2776: hr_utility.set_location ('l_out_pay_rate_determinant ' || l_out_pay_rate_determinant, 22);
2777: hr_utility.set_location ('l_pay_plan ' || l_pay_plan, 22);
2778: hr_utility.set_location ('l_position_id '|| to_char (l_position_id), 22);
2779: hr_utility.set_location ('l_pay_basis '|| l_pay_basis, 22);
2780: hr_utility.set_location ('person_id '|| to_char (p_person_id), 22);
2781: hr_utility.set_location ('l_new_basic_pay '|| to_char (l_new_basic_pay), 22);
2782: hr_utility.set_location ('l_new_locality_adj '|| to_char (l_new_locality_adj), 22);
2783: hr_utility.set_location ('l_new_adj_basic_pay '|| to_char (l_new_adj_basic_pay), 22);
2776: hr_utility.set_location ('l_out_pay_rate_determinant ' || l_out_pay_rate_determinant, 22);
2777: hr_utility.set_location ('l_pay_plan ' || l_pay_plan, 22);
2778: hr_utility.set_location ('l_position_id '|| to_char (l_position_id), 22);
2779: hr_utility.set_location ('l_pay_basis '|| l_pay_basis, 22);
2780: hr_utility.set_location ('person_id '|| to_char (p_person_id), 22);
2781: hr_utility.set_location ('l_new_basic_pay '|| to_char (l_new_basic_pay), 22);
2782: hr_utility.set_location ('l_new_locality_adj '|| to_char (l_new_locality_adj), 22);
2783: hr_utility.set_location ('l_new_adj_basic_pay '|| to_char (l_new_adj_basic_pay), 22);
2784: hr_utility.set_location ('l_new_total_salary '|| to_char (l_new_total_salary), 22);
2777: hr_utility.set_location ('l_pay_plan ' || l_pay_plan, 22);
2778: hr_utility.set_location ('l_position_id '|| to_char (l_position_id), 22);
2779: hr_utility.set_location ('l_pay_basis '|| l_pay_basis, 22);
2780: hr_utility.set_location ('person_id '|| to_char (p_person_id), 22);
2781: hr_utility.set_location ('l_new_basic_pay '|| to_char (l_new_basic_pay), 22);
2782: hr_utility.set_location ('l_new_locality_adj '|| to_char (l_new_locality_adj), 22);
2783: hr_utility.set_location ('l_new_adj_basic_pay '|| to_char (l_new_adj_basic_pay), 22);
2784: hr_utility.set_location ('l_new_total_salary '|| to_char (l_new_total_salary), 22);
2785: hr_utility.set_location ('l_entitled_other_pay '|| to_char (l_entitled_other_pay), 22);
2778: hr_utility.set_location ('l_position_id '|| to_char (l_position_id), 22);
2779: hr_utility.set_location ('l_pay_basis '|| l_pay_basis, 22);
2780: hr_utility.set_location ('person_id '|| to_char (p_person_id), 22);
2781: hr_utility.set_location ('l_new_basic_pay '|| to_char (l_new_basic_pay), 22);
2782: hr_utility.set_location ('l_new_locality_adj '|| to_char (l_new_locality_adj), 22);
2783: hr_utility.set_location ('l_new_adj_basic_pay '|| to_char (l_new_adj_basic_pay), 22);
2784: hr_utility.set_location ('l_new_total_salary '|| to_char (l_new_total_salary), 22);
2785: hr_utility.set_location ('l_entitled_other_pay '|| to_char (l_entitled_other_pay), 22);
2786: hr_utility.set_location ('l_capped_other_pay '|| to_char (l_capped_other_pay), 22);
2779: hr_utility.set_location ('l_pay_basis '|| l_pay_basis, 22);
2780: hr_utility.set_location ('person_id '|| to_char (p_person_id), 22);
2781: hr_utility.set_location ('l_new_basic_pay '|| to_char (l_new_basic_pay), 22);
2782: hr_utility.set_location ('l_new_locality_adj '|| to_char (l_new_locality_adj), 22);
2783: hr_utility.set_location ('l_new_adj_basic_pay '|| to_char (l_new_adj_basic_pay), 22);
2784: hr_utility.set_location ('l_new_total_salary '|| to_char (l_new_total_salary), 22);
2785: hr_utility.set_location ('l_entitled_other_pay '|| to_char (l_entitled_other_pay), 22);
2786: hr_utility.set_location ('l_capped_other_pay '|| to_char (l_capped_other_pay), 22);
2787: hr_utility.set_location ('l_new_retention_allowance '|| to_char (l_new_retention_allowance), 22);
2780: hr_utility.set_location ('person_id '|| to_char (p_person_id), 22);
2781: hr_utility.set_location ('l_new_basic_pay '|| to_char (l_new_basic_pay), 22);
2782: hr_utility.set_location ('l_new_locality_adj '|| to_char (l_new_locality_adj), 22);
2783: hr_utility.set_location ('l_new_adj_basic_pay '|| to_char (l_new_adj_basic_pay), 22);
2784: hr_utility.set_location ('l_new_total_salary '|| to_char (l_new_total_salary), 22);
2785: hr_utility.set_location ('l_entitled_other_pay '|| to_char (l_entitled_other_pay), 22);
2786: hr_utility.set_location ('l_capped_other_pay '|| to_char (l_capped_other_pay), 22);
2787: hr_utility.set_location ('l_new_retention_allowance '|| to_char (l_new_retention_allowance), 22);
2788: hr_utility.set_location ('l_new_supervisory_differential '|| to_char (l_new_supervisory_differential), 22);
2781: hr_utility.set_location ('l_new_basic_pay '|| to_char (l_new_basic_pay), 22);
2782: hr_utility.set_location ('l_new_locality_adj '|| to_char (l_new_locality_adj), 22);
2783: hr_utility.set_location ('l_new_adj_basic_pay '|| to_char (l_new_adj_basic_pay), 22);
2784: hr_utility.set_location ('l_new_total_salary '|| to_char (l_new_total_salary), 22);
2785: hr_utility.set_location ('l_entitled_other_pay '|| to_char (l_entitled_other_pay), 22);
2786: hr_utility.set_location ('l_capped_other_pay '|| to_char (l_capped_other_pay), 22);
2787: hr_utility.set_location ('l_new_retention_allowance '|| to_char (l_new_retention_allowance), 22);
2788: hr_utility.set_location ('l_new_supervisory_differential '|| to_char (l_new_supervisory_differential), 22);
2789: hr_utility.set_location ('l_staffing_differential '|| to_char (l_staffing_differential), 22);
2782: hr_utility.set_location ('l_new_locality_adj '|| to_char (l_new_locality_adj), 22);
2783: hr_utility.set_location ('l_new_adj_basic_pay '|| to_char (l_new_adj_basic_pay), 22);
2784: hr_utility.set_location ('l_new_total_salary '|| to_char (l_new_total_salary), 22);
2785: hr_utility.set_location ('l_entitled_other_pay '|| to_char (l_entitled_other_pay), 22);
2786: hr_utility.set_location ('l_capped_other_pay '|| to_char (l_capped_other_pay), 22);
2787: hr_utility.set_location ('l_new_retention_allowance '|| to_char (l_new_retention_allowance), 22);
2788: hr_utility.set_location ('l_new_supervisory_differential '|| to_char (l_new_supervisory_differential), 22);
2789: hr_utility.set_location ('l_staffing_differential '|| to_char (l_staffing_differential), 22);
2790: hr_utility.set_location ('l_new_au_overtime '|| to_char (l_new_au_overtime), 22);
2783: hr_utility.set_location ('l_new_adj_basic_pay '|| to_char (l_new_adj_basic_pay), 22);
2784: hr_utility.set_location ('l_new_total_salary '|| to_char (l_new_total_salary), 22);
2785: hr_utility.set_location ('l_entitled_other_pay '|| to_char (l_entitled_other_pay), 22);
2786: hr_utility.set_location ('l_capped_other_pay '|| to_char (l_capped_other_pay), 22);
2787: hr_utility.set_location ('l_new_retention_allowance '|| to_char (l_new_retention_allowance), 22);
2788: hr_utility.set_location ('l_new_supervisory_differential '|| to_char (l_new_supervisory_differential), 22);
2789: hr_utility.set_location ('l_staffing_differential '|| to_char (l_staffing_differential), 22);
2790: hr_utility.set_location ('l_new_au_overtime '|| to_char (l_new_au_overtime), 22);
2791: hr_utility.set_location ('l_new_availability_pay '|| to_char (l_new_availability_pay), 22);
2784: hr_utility.set_location ('l_new_total_salary '|| to_char (l_new_total_salary), 22);
2785: hr_utility.set_location ('l_entitled_other_pay '|| to_char (l_entitled_other_pay), 22);
2786: hr_utility.set_location ('l_capped_other_pay '|| to_char (l_capped_other_pay), 22);
2787: hr_utility.set_location ('l_new_retention_allowance '|| to_char (l_new_retention_allowance), 22);
2788: hr_utility.set_location ('l_new_supervisory_differential '|| to_char (l_new_supervisory_differential), 22);
2789: hr_utility.set_location ('l_staffing_differential '|| to_char (l_staffing_differential), 22);
2790: hr_utility.set_location ('l_new_au_overtime '|| to_char (l_new_au_overtime), 22);
2791: hr_utility.set_location ('l_new_availability_pay '|| to_char (l_new_availability_pay), 22);
2792: END IF;
2785: hr_utility.set_location ('l_entitled_other_pay '|| to_char (l_entitled_other_pay), 22);
2786: hr_utility.set_location ('l_capped_other_pay '|| to_char (l_capped_other_pay), 22);
2787: hr_utility.set_location ('l_new_retention_allowance '|| to_char (l_new_retention_allowance), 22);
2788: hr_utility.set_location ('l_new_supervisory_differential '|| to_char (l_new_supervisory_differential), 22);
2789: hr_utility.set_location ('l_staffing_differential '|| to_char (l_staffing_differential), 22);
2790: hr_utility.set_location ('l_new_au_overtime '|| to_char (l_new_au_overtime), 22);
2791: hr_utility.set_location ('l_new_availability_pay '|| to_char (l_new_availability_pay), 22);
2792: END IF;
2793:
2786: hr_utility.set_location ('l_capped_other_pay '|| to_char (l_capped_other_pay), 22);
2787: hr_utility.set_location ('l_new_retention_allowance '|| to_char (l_new_retention_allowance), 22);
2788: hr_utility.set_location ('l_new_supervisory_differential '|| to_char (l_new_supervisory_differential), 22);
2789: hr_utility.set_location ('l_staffing_differential '|| to_char (l_staffing_differential), 22);
2790: hr_utility.set_location ('l_new_au_overtime '|| to_char (l_new_au_overtime), 22);
2791: hr_utility.set_location ('l_new_availability_pay '|| to_char (l_new_availability_pay), 22);
2792: END IF;
2793:
2794: IF l_pay_cap_message THEN
2787: hr_utility.set_location ('l_new_retention_allowance '|| to_char (l_new_retention_allowance), 22);
2788: hr_utility.set_location ('l_new_supervisory_differential '|| to_char (l_new_supervisory_differential), 22);
2789: hr_utility.set_location ('l_staffing_differential '|| to_char (l_staffing_differential), 22);
2790: hr_utility.set_location ('l_new_au_overtime '|| to_char (l_new_au_overtime), 22);
2791: hr_utility.set_location ('l_new_availability_pay '|| to_char (l_new_availability_pay), 22);
2792: END IF;
2793:
2794: IF l_pay_cap_message THEN
2795: IF nvl (l_temp_retention_allowance, 0) > 0 THEN
2812: IF (l_comment_sal IS NOT NULL) THEN
2813: l_comment := l_comment_sal|| ' '|| l_comment;
2814: END IF;
2815:
2816: hr_utility.set_location ('Before Calling ins_upd_per_extra_info p_mass_salary_id '|| p_mass_salary_id, 555);
2817:
2818: ins_upd_per_extra_info (p_person_id, l_effective_date
2819: , l_sel_flg, l_comment
2820: , p_mass_salary_id);
2820: , p_mass_salary_id);
2821:
2822: l_comment := NULL;
2823: ELSIF l_comment_sal IS NOT NULL THEN
2824: hr_utility.set_location (' l_comment_sal is not null '|| p_mass_salary_id, 555);
2825:
2826: ins_upd_per_extra_info (p_person_id, l_effective_date
2827: , l_sel_flg, l_comment_sal
2828: , p_mass_salary_id);
2832: EXCEPTION
2833: WHEN mnoa_error THEN
2834: RAISE;
2835: WHEN others THEN
2836: hr_utility.set_location ('Error in ghr_pay_caps.do_pay_caps_main '|| 'Err is '|| sqlerrm (sqlcode), 23);
2837: l_noaerrbuf := 'Error in do_pay_caps_main Sql Err is '|| sqlerrm (sqlcode);
2838: RAISE mnoa_error;
2839: END;
2840: --Begin Bug# 14414972, for NON_PAY_DUTY_STATION family pay calc is not required
2849:
2850: EXCEPTION
2851:
2852: WHEN OTHERS THEN
2853: hr_utility.set_location ('Error in ghr_msl_pkg.get_pay_plan_and_table_id of '|| ' Err is '|| sqlerrm (sqlcode), 20);
2854: l_pay_plan := p_pay_plan;
2855: l_to_pay_plan := p_to_pay_plan;
2856: l_pay_table_id := p_pay_table_id;
2857: l_grade_or_level := p_grade_or_level;
2863:
2864: END IF; -- IF l_noa_code NOT IN ('430','460','471','472')
2865: --End Bug# 14414972
2866: IF upper (p_action) IN ('SHOW', 'REPORT') THEN
2867: hr_utility.set_location ('Calling create_mass_noa_prev in p_action '|| p_action, 1331);
2868: -- Begin Bug# 14751973
2869: IF l_noa_code IN ('800','792') THEN
2870: ghr_pa_requests_pkg.get_sf52_pos_ddf_details
2871: (p_position_id => l_position_id
2941: , l_pay_table_id, l_grade_or_level
2942: , l_step_or_rate, l_pay_basis);
2943: EXCEPTION
2944: WHEN ghr_msl_pkg.msl_error THEN
2945: l_noaerrbuf := hr_utility.get_message;
2946: RAISE mnoa_error;
2947: END;
2948: hr_utility.set_location ('Callin ghr_msl_pkg.assign_to_sf52_rec ' || l_sf52_rec.first_noa_information1, 233);
2949: ghr_msl_pkg.assign_to_sf52_rec (p_person_id, p_first_name
2944: WHEN ghr_msl_pkg.msl_error THEN
2945: l_noaerrbuf := hr_utility.get_message;
2946: RAISE mnoa_error;
2947: END;
2948: hr_utility.set_location ('Callin ghr_msl_pkg.assign_to_sf52_rec ' || l_sf52_rec.first_noa_information1, 233);
2949: ghr_msl_pkg.assign_to_sf52_rec (p_person_id, p_first_name
2950: , p_last_name, p_middle_names
2951: , p_national_identifier, p_date_of_birth
2952: , l_effective_date, l_assignment_id
2973: BEGIN
2974: ghr_mass_actions_pkg.pay_calc_rec_to_sf52_rec (l_pay_calc_out_data, l_sf52_rec);
2975: EXCEPTION
2976: WHEN others THEN
2977: hr_utility.set_location ('Error in Ghr_mass_actions_pkg.pay_calc_rec_to_sf52_rec '|| 'Err is '|| sqlerrm (sqlcode), 20);
2978: l_noaerrbuf := 'Error in ghr_mass_act_pkg.pay_calc_to_sf52 Sql Err is '|| sqlerrm (sqlcode);
2979: RAISE mnoa_error;
2980: END;
2981:
2982: BEGIN
2983: l_sf52_rec.mass_action_id := p_mass_salary_id;
2984: l_sf52_rec.rpa_type := 'MNOA';
2985: IF l_noa_code ='800' THEN
2986: hr_utility.set_location ('Assigning RPA Elements for NOA: 800 '|| l_proc, 139);
2987: l_sf52_rec.to_occ_code := l_target_occ_code;
2988: l_sf52_rec.to_job_id := l_target_job_id;
2989: l_sf52_rec.functional_class := l_target_functional_class; --Bug# 14410401
2990: l_sf52_rec.flsa_category := l_target_flsa_category;
2990: l_sf52_rec.flsa_category := l_target_flsa_category;
2991: l_sf52_rec.bargaining_unit_status := l_target_barg_unit_status;
2992: l_sf52_rec.agency_code := l_target_agency_code_subelmt;
2993: ELSIF l_noa_code ='792' THEN
2994: hr_utility.set_location ('Assigning Duty station Details for NOA: 792 '|| l_target_duty_station_id, 139);
2995: l_sf52_rec.bargaining_unit_status := l_target_barg_unit_status;
2996: IF l_target_duty_station_id IS NOT NULL THEN
2997: FOR c_get_loc_id IN get_loc_id(l_sf52_rec.duty_station_code) LOOP
2998: l_sf52_rec.duty_station_location_id := c_get_loc_id.location_id;
3001: END IF;
3002:
3003: g_proc := 'Create_sf52_recrod';
3004:
3005: hr_utility.set_location ('Calling create_sf52_for_mass_changes '|| l_proc, 140);
3006:
3007: ghr_mass_changes.create_sf52_for_mass_changes
3008: (p_mass_action_type => 'MASS_NOA_SEL'
3009: , p_pa_request_rec => l_sf52_rec
3021: END;
3022:
3023: BEGIN
3024: IF l_noa_code IN ('472', '292','430', '460', '471','280','800') THEN
3025: hr_utility.set_location ('Calling refresh_ei_details '|| l_proc, 140);
3026:
3027: refresh_ei_details
3028: (p_noa_action => l_noa_code
3029: , p_effective_date => l_effective_date
3034: END;
3035:
3036: IF l_errbuf IS NULL THEN
3037: pr ('No error in create sf52 ');
3038: hr_utility.set_location ('Before commiting', 2);
3039:
3040: ghr_mto_int.log_message
3041: (p_procedure => 'Successful Completion'
3042: , p_message => 'Name: '
3053: update_sel_flg (p_person_id, l_effective_date);
3054: COMMIT;
3055: ELSE
3056: pr ('Error in create sf52', l_errbuf);
3057: hr_utility.set_location ('Error in '|| to_char (p_position_id), 20);
3058: RAISE mnoa_error;
3059: END IF;
3060: EXCEPTION
3061: WHEN mnoa_error THEN
3075: END IF;
3076: END IF;
3077: EXCEPTION
3078: WHEN mnoa_error THEN
3079: hr_utility.set_location ('Error occurred in ' || l_proc || ' Sql error ' || sqlerrm (sqlcode), 10);
3080:
3081: BEGIN
3082: IF upper (p_action) <> 'SHOW' THEN
3083: ROLLBACK TO execute_noa_sp;
3098: || p_employee_number
3099: || ' '
3100: || l_noaerrbuf;
3101:
3102: hr_utility.set_location ('before creating entry in log file', 10);
3103: l_recs_failed := l_recs_failed + 1;
3104: BEGIN
3105: ghr_mto_int.log_message
3106: (p_procedure => g_proc
3106: (p_procedure => g_proc
3107: , p_message => l_log_text);
3108: EXCEPTION
3109: WHEN others THEN
3110: hr_utility.set_message (8301, 'GHR_38475_ERROR_LOG_FAILURE');
3111: hr_utility.raise_error;
3112: END;
3113: WHEN others THEN
3114: hr_utility.set_location ('Error (Others2) occurred in ' || l_proc || ' Sql error ' || sqlerrm (sqlcode), 30);
3107: , p_message => l_log_text);
3108: EXCEPTION
3109: WHEN others THEN
3110: hr_utility.set_message (8301, 'GHR_38475_ERROR_LOG_FAILURE');
3111: hr_utility.raise_error;
3112: END;
3113: WHEN others THEN
3114: hr_utility.set_location ('Error (Others2) occurred in ' || l_proc || ' Sql error ' || sqlerrm (sqlcode), 30);
3115: BEGIN
3110: hr_utility.set_message (8301, 'GHR_38475_ERROR_LOG_FAILURE');
3111: hr_utility.raise_error;
3112: END;
3113: WHEN others THEN
3114: hr_utility.set_location ('Error (Others2) occurred in ' || l_proc || ' Sql error ' || sqlerrm (sqlcode), 30);
3115: BEGIN
3116: ROLLBACK TO execute_noa_sp;
3117: EXCEPTION
3118: WHEN others THEN
3126: || ' Sql Err is '
3127: || sqlerrm (sqlcode);
3128:
3129: l_recs_failed := l_recs_failed + 1;
3130: hr_utility.set_location ('before creating entry in log file', 30);
3131:
3132: p_errbuf := 'Error in '|| l_proc|| ' Details in GHR_PROCESS_LOG';
3133: p_retcode := 2;
3134:
3145: (p_procedure => g_proc
3146: , p_message => l_log_text);
3147: EXCEPTION
3148: WHEN others THEN
3149: hr_utility.set_message (8301, 'Create Error Log failed');
3150: hr_utility.raise_error;
3151: END;
3152: END mnoa_process;
3153: BEGIN
3146: , p_message => l_log_text);
3147: EXCEPTION
3148: WHEN others THEN
3149: hr_utility.set_message (8301, 'Create Error Log failed');
3150: hr_utility.raise_error;
3151: END;
3152: END mnoa_process;
3153: BEGIN
3154: hr_utility.set_location ('Entering main execute_mnoa '|| l_proc, 5);
3150: hr_utility.raise_error;
3151: END;
3152: END mnoa_process;
3153: BEGIN
3154: hr_utility.set_location ('Entering main execute_mnoa '|| l_proc, 5);
3155: p_retcode := 0;
3156:
3157: BEGIN
3158: FOR msnoa IN ghr_msnoa (p_mass_salary_id) LOOP
3155: p_retcode := 0;
3156:
3157: BEGIN
3158: FOR msnoa IN ghr_msnoa (p_mass_salary_id) LOOP
3159: hr_utility.set_location ('Mass Criteria name '|| msnoa.name, 51);
3160: p_mass_salary := msnoa.name;
3161: l_effective_date := msnoa.effective_date;
3162: l_mass_salary_id := msnoa.mass_salary_id;
3163: l_user_table_id := msnoa.user_table_id;
3190: EXIT;
3191: END LOOP;
3192: EXCEPTION
3193: WHEN rec_busy THEN
3194: hr_utility.set_location ('Mass Selectable NOA is in use', 1);
3195: l_noaerrbuf := 'Error in '
3196: || l_proc
3197: || ' Sql Err is '
3198: || sqlerrm (sqlcode);
3195: l_noaerrbuf := 'Error in '
3196: || l_proc
3197: || ' Sql Err is '
3198: || sqlerrm (sqlcode);
3199: hr_utility.set_message (8301, 'GHR_38477_LOCK_ON_MSL');
3200: hr_utility.raise_error;
3201: WHEN others THEN
3202: hr_utility.set_location ('Error in '|| l_proc || ' Sql err is ' || sqlerrm (sqlcode), 1);
3203: l_noaerrbuf := 'Error in '
3196: || l_proc
3197: || ' Sql Err is '
3198: || sqlerrm (sqlcode);
3199: hr_utility.set_message (8301, 'GHR_38477_LOCK_ON_MSL');
3200: hr_utility.raise_error;
3201: WHEN others THEN
3202: hr_utility.set_location ('Error in '|| l_proc || ' Sql err is ' || sqlerrm (sqlcode), 1);
3203: l_noaerrbuf := 'Error in '
3204: || l_proc
3198: || sqlerrm (sqlcode);
3199: hr_utility.set_message (8301, 'GHR_38477_LOCK_ON_MSL');
3200: hr_utility.raise_error;
3201: WHEN others THEN
3202: hr_utility.set_location ('Error in '|| l_proc || ' Sql err is ' || sqlerrm (sqlcode), 1);
3203: l_noaerrbuf := 'Error in '
3204: || l_proc
3205: || ' Sql Err is '
3206: || sqlerrm (sqlcode);
3214: ghr_mto_int.set_log_program_name ('MSNOA_'|| p_mass_salary);
3215: END IF;
3216: get_lac_dtls (l_pa_request_id, l_lac_sf52_rec);
3217: ghr_msl_pkg.g_first_noa_code := l_noa_code;
3218: hr_utility.set_location ('Mass Action name '|| p_action, 52);
3219: --hr_utility.trace_on (NULL, 'raju');
3220: IF l_noa_code IN ('460') THEN
3221: FOR per IN cur_active_people (l_effective_date) LOOP
3222: BEGIN
3215: END IF;
3216: get_lac_dtls (l_pa_request_id, l_lac_sf52_rec);
3217: ghr_msl_pkg.g_first_noa_code := l_noa_code;
3218: hr_utility.set_location ('Mass Action name '|| p_action, 52);
3219: --hr_utility.trace_on (NULL, 'raju');
3220: IF l_noa_code IN ('460') THEN
3221: FOR per IN cur_active_people (l_effective_date) LOOP
3222: BEGIN
3223: l_personnel_office_id := NULL;
3242: l_pay_basis := NULL;
3243: l_elig_flag := FALSE;
3244: l_org_name := ghr_mre_pkg.get_organization_name (per.organization_id);
3245: BEGIN
3246: hr_utility.set_location ('Calling fetch_and_validate_emp '|| l_noa_code, 2234);
3247:
3248: fetch_and_validate_emp
3249: (p_action => p_action
3250: , p_mass_salary_id => p_mass_salary_id
3369: p_asg_ei_data => l_asg_extra_info_rec
3370: );
3371: IF l_asg_extra_info_rec.aei_information15 IS NULL OR l_asg_extra_info_rec.aei_information15 ='F' THEN
3372: BEGIN
3373: hr_utility.set_location ('Calling fetch_and_validate_emp '|| l_noa_code, 2234);
3374:
3375: fetch_and_validate_emp
3376: (p_action => p_action
3377: , p_mass_salary_id => p_mass_salary_id
3489: l_pay_basis := NULL;
3490: l_elig_flag := FALSE;
3491: l_org_name := ghr_mre_pkg.get_organization_name (per.organization_id);
3492: BEGIN
3493: hr_utility.set_location ('Calling fetch_and_validate_emp '|| l_noa_code, 2235);
3494:
3495: fetch_and_validate_emp
3496: (p_action => p_action
3497: , p_mass_salary_id => p_mass_salary_id
3603: l_pay_basis := NULL;
3604: l_elig_flag := FALSE;
3605: l_org_name := ghr_mre_pkg.get_organization_name (per.organization_id);
3606: BEGIN
3607: hr_utility.set_location ('Calling fetch_and_validate_emp '|| l_noa_code, 2236);
3608: fetch_and_validate_emp
3609: (p_action => p_action
3610: , p_mass_salary_id => p_mass_salary_id
3611: , p_mass_salary_name => p_mass_salary
3718: l_elig_flag := FALSE;
3719: l_org_name := ghr_mre_pkg.get_organization_name (per.organization_id);
3720: IF ghr_pa_requests_pkg.get_work_schedule (per.position_id, l_effective_date) IN ('G', 'J', 'Q', 'T') THEN
3721: BEGIN
3722: hr_utility.set_location ('Calling fetch_and_validate_emp '|| l_noa_code, 2237);
3723:
3724: fetch_and_validate_emp
3725: (p_action => p_action
3726: , p_mass_salary_id => p_mass_salary_id
3834: l_elig_flag := FALSE;
3835: l_org_name := ghr_mre_pkg.get_organization_name (per.organization_id);
3836:
3837: BEGIN
3838: hr_utility.set_location ('Calling fetch_and_validate_emp '|| l_noa_code, 2238);
3839: fetch_and_validate_emp
3840: (p_action => p_action
3841: , p_mass_salary_id => p_mass_salary_id
3842: , p_mass_salary_name => p_mass_salary
3948: l_elig_flag := FALSE;
3949: l_org_name := ghr_mre_pkg.get_organization_name (per.organization_id);
3950:
3951: BEGIN
3952: hr_utility.set_location ('Calling fetch_and_validate_emp '|| l_noa_code, 2239);
3953:
3954: fetch_and_validate_emp
3955: (p_action => p_action
3956: , p_mass_salary_id => p_mass_salary_id
4063: l_pay_basis := NULL;
4064: l_elig_flag := FALSE;
4065: l_org_name := ghr_mre_pkg.get_organization_name (per.organization_id);
4066: BEGIN
4067: hr_utility.set_location ('Calling fetch_and_validate_emp '|| l_noa_code, 2240);
4068:
4069: fetch_and_validate_emp
4070: (p_action => p_action
4071: , p_mass_salary_id => p_mass_salary_id
4180: l_elig_flag := FALSE;
4181: l_org_name := ghr_mre_pkg.get_organization_name (c_vacant_pos.organization_id);
4182:
4183: BEGIN
4184: hr_utility.set_location ('Calling fetch_and_validate_emp ' || l_proc, 2240);
4185:
4186: fetch_and_validate_emp
4187: (p_action => p_action
4188: , p_mass_salary_id => p_mass_salary_id
4230: l_elig_flag := FALSE;
4231: END;
4232:
4233: IF l_elig_flag THEN
4234: hr_utility.set_location ('Calling vacant_pos_process '
4235: || l_noa_code, 2241);
4236:
4237: vacant_pos_process
4238: (p_assignment_id => c_vacant_pos.assignment_id
4273: END;
4274: END IF;
4275: END LOOP;
4276: END IF;
4277: --hr_utility.trace_off;
4278: pr ('After processing is over ', to_char (l_recs_failed));
4279:
4280: IF (l_recs_failed = 0) THEN
4281: IF upper (p_action) = 'CREATE' THEN
4284: SET submit_flag = 'P'
4285: WHERE rowid = l_rowid;
4286: EXCEPTION
4287: WHEN others THEN
4288: hr_utility.set_location ('Error in Update ghr_msl Sql error '|| sqlerrm (sqlcode), 30);
4289: hr_utility.set_message (8301, 'GHR_38476_UPD_GHR_MSL_FAILURE');
4290: hr_utility.raise_error;
4291: END;
4292: END IF;
4285: WHERE rowid = l_rowid;
4286: EXCEPTION
4287: WHEN others THEN
4288: hr_utility.set_location ('Error in Update ghr_msl Sql error '|| sqlerrm (sqlcode), 30);
4289: hr_utility.set_message (8301, 'GHR_38476_UPD_GHR_MSL_FAILURE');
4290: hr_utility.raise_error;
4291: END;
4292: END IF;
4293: ELSE
4286: EXCEPTION
4287: WHEN others THEN
4288: hr_utility.set_location ('Error in Update ghr_msl Sql error '|| sqlerrm (sqlcode), 30);
4289: hr_utility.set_message (8301, 'GHR_38476_UPD_GHR_MSL_FAILURE');
4290: hr_utility.raise_error;
4291: END;
4292: END IF;
4293: ELSE
4294: p_errbuf := 'Error in '
4307: COMMIT;
4308: pr ('After commiting.....', to_char (l_recs_failed));
4309: EXCEPTION
4310: WHEN others THEN
4311: hr_utility.set_location ('Error (Others2) occurred in '|| l_proc|| ' Sql error '|| sqlerrm (sqlcode), 30);
4312:
4313: BEGIN
4314: ROLLBACK TO execute_noa_sp;
4315: EXCEPTION
4324: || ' Sql Err is '
4325: || sqlerrm (sqlcode);
4326:
4327: l_recs_failed := l_recs_failed + 1;
4328: hr_utility.set_location ('before creating entry in log file', 30);
4329: p_errbuf := 'Error in '|| l_proc|| ' Details in GHR_PROCESS_LOG';
4330: p_retcode := 2;
4331:
4332: IF upper (p_action) = 'CREATE' THEN
4342: (p_procedure => g_proc
4343: , p_message => l_log_text);
4344: EXCEPTION
4345: WHEN others THEN
4346: hr_utility.set_message (8301, 'Create Error Log failed');
4347:
4348: hr_utility.raise_error;
4349: END;
4350: END execute_mnoa;
4344: EXCEPTION
4345: WHEN others THEN
4346: hr_utility.set_message (8301, 'Create Error Log failed');
4347:
4348: hr_utility.raise_error;
4349: END;
4350: END execute_mnoa;
4351: --Begin Bug# 14467215
4352: PROCEDURE execute_mcancel
4483: , session_id
4484: FROM fnd_sessions
4485: WHERE session_id = userenv ('sessionid');
4486: BEGIN
4487: hr_utility.set_location ('Entering mcancel_process '|| l_proc, 100);
4488:
4489: FOR l_pa_req_rec IN cur_can_records (p_target_mass_action_id, p_effective_date) LOOP
4490: BEGIN
4491: SAVEPOINT execute_mcan_sp;
4509: l_organization_id := l_pa_req_rec.to_organization_id;
4510: END IF;
4511: --End Bug# 16083971
4512: IF upper (p_action) IN ('SHOW', 'REPORT') THEN
4513: hr_utility.set_location ('Calling create_mass_noa_prev in '|| l_proc, 133);
4514: -- Bug# 14751973
4515: create_mass_noa_prev
4516: (p_effective_date => l_effective_date
4517: , p_date_of_birth => l_pa_req_rec.employee_date_of_birth
4554: , p_from_functional_class => NULL
4555: , p_to_functional_class => NULL
4556: , p_work_schedule => NULL);
4557: ELSIF upper (p_action) = 'CREATE' THEN
4558: hr_utility.set_location ('p_action= '|| p_action|| ' in '|| l_proc, 133);
4559: BEGIN
4560: l_errbuf := NULL;
4561:
4562: FOR c_pa_rowid IN cur_pa_rowid (l_pa_req_rec.pa_request_id) LOOP
4570: INTO l_sess_date
4571: , l_session_id;
4572:
4573: IF get_sess_date%NOTFOUND THEN
4574: hr_utility.set_location ('session id '|| userenv ('sessionid'), 100);
4575: l_session_id := userenv ('sessionid');
4576:
4577: INSERT
4578: INTO fnd_sessions (session_id, effective_date)
4587:
4588: BEGIN
4589: g_proc := 'Create_Mass_cancel_record ';
4590:
4591: hr_utility.set_location ('Before creating cancellation RPA '|| l_proc, 134);
4592:
4593: l_can_pa_request_id := ghr_approved_pa_requests.ghr_cancel_sf52
4594: (p_pa_request_id => l_pa_req_rec.pa_request_id
4595: , p_par_object_version_number => l_ovn
4605:
4606: DECLARE
4607: l_pa_request_number ghr_pa_requests.request_number%TYPE;
4608: BEGIN
4609: hr_utility.set_location ('Update pa_req_num '|| l_proc, 200);
4610:
4611: FOR cur_req_num IN c_req_num LOOP
4612: l_pa_request_number := cur_req_num.request_number;
4613:
4625: , p_person_full_name => l_personnel_officer_name
4626: , p_approving_off_work_title => l_approving_off_work_title);
4627: EXCEPTION
4628: WHEN others THEN
4629: hr_utility.set_location ('Getting personnel office Failure '
4630: || l_proc, 170);
4631:
4632: l_log_text := 'Error in POI Name '
4633: || ' Sql error : '
4653: , p_sf50_approving_ofcl_work_tit => l_approving_off_work_title
4654: , p_rpa_type => 'MCAN');
4655: EXCEPTION
4656: WHEN others THEN
4657: l_mcanerrbuf := hr_utility.get_message;
4658: l_errbuf := l_mcanerrbuf;
4659: RAISE mnoa_error;
4660: END;
4661:
4659: RAISE mnoa_error;
4660: END;
4661:
4662: BEGIN
4663: hr_utility.set_location ('Getting Group Box '
4664: || l_proc, 170);
4665:
4666: ghr_mass_actions_pkg.get_personnel_off_groupbox
4667: (p_position_id => nvl (l_pa_req_rec.to_position_id, l_pa_req_rec.from_position_id)
4668: , p_effective_date => l_effective_date
4669: , p_groupbox_id => l_groupbox_id
4670: , p_routing_group_id => l_routing_group_id);
4671:
4672: hr_utility.set_location ('Routing Group Id '
4673: || to_char (l_routing_group_id), 170);
4674:
4675: hr_utility.set_location ('Group Box Id'
4676: || to_char (l_groupbox_id), 170);
4671:
4672: hr_utility.set_location ('Routing Group Id '
4673: || to_char (l_routing_group_id), 170);
4674:
4675: hr_utility.set_location ('Group Box Id'
4676: || to_char (l_groupbox_id), 170);
4677: EXCEPTION
4678: WHEN others THEN
4679: hr_utility.set_location ('Getting Group Box Failure '
4675: hr_utility.set_location ('Group Box Id'
4676: || to_char (l_groupbox_id), 170);
4677: EXCEPTION
4678: WHEN others THEN
4679: hr_utility.set_location ('Getting Group Box Failure '
4680: || l_proc, 170);
4681:
4682: l_log_text := 'Error in POI groupbox '
4683: || ' Sql error : '
4691: l_prh_object_version_number := routing_history_id.object_version_number;
4692: EXIT;
4693: END LOOP;
4694:
4695: hr_utility.set_location ('Updating prh '
4696: || l_proc, 175);
4697: hr_utility.set_location ('RHVN '
4698: || to_char (l_prh_object_version_number), 176);
4699: hr_utility.set_location ('RHID '
4693: END LOOP;
4694:
4695: hr_utility.set_location ('Updating prh '
4696: || l_proc, 175);
4697: hr_utility.set_location ('RHVN '
4698: || to_char (l_prh_object_version_number), 176);
4699: hr_utility.set_location ('RHID '
4700: || to_char (l_pa_routing_history_id), 177);
4701: ghr_prh_upd.upd
4695: hr_utility.set_location ('Updating prh '
4696: || l_proc, 175);
4697: hr_utility.set_location ('RHVN '
4698: || to_char (l_prh_object_version_number), 176);
4699: hr_utility.set_location ('RHID '
4700: || to_char (l_pa_routing_history_id), 177);
4701: ghr_prh_upd.upd
4702: (p_pa_routing_history_id => l_pa_routing_history_id
4703: , p_groupbox_id => l_groupbox_id
4719: , p_i_pa_routing_history_id => l_i_pa_routing_history_id
4720: , p_i_prh_object_version_number => l_i_prh_object_version_number);
4721: EXCEPTION
4722: WHEN others THEN
4723: hr_utility.set_location (sqlerrm (sqlcode), 1);
4724: hr_utility.set_location ('Update sf52 final Failure '
4725: || l_proc, 190);
4726: l_log_text := 'Error in Update sf52 final '
4727: || ' Sql error : '
4720: , p_i_prh_object_version_number => l_i_prh_object_version_number);
4721: EXCEPTION
4722: WHEN others THEN
4723: hr_utility.set_location (sqlerrm (sqlcode), 1);
4724: hr_utility.set_location ('Update sf52 final Failure '
4725: || l_proc, 190);
4726: l_log_text := 'Error in Update sf52 final '
4727: || ' Sql error : '
4728: || sqlerrm (sqlcode);
4730: END;
4731: END;
4732: EXCEPTION
4733: WHEN others THEN
4734: l_mcanerrbuf := hr_utility.get_message;
4735: l_errbuf := l_mcanerrbuf;
4736: RAISE mnoa_error;
4737: END;
4738:
4737: END;
4738:
4739: IF l_errbuf IS NULL THEN
4740: pr ('No error in create sf52 ');
4741: hr_utility.set_location ('Before commiting', 2);
4742:
4743: ghr_mto_int.log_message
4744: (p_procedure => 'Successful Completion'
4745: , p_message => 'Name: '
4755: COMMIT;
4756: ELSE
4757: pr ('Error in create sf52', l_errbuf);
4758:
4759: hr_utility.set_location ('Error in '
4760: || to_char (l_pa_req_rec.to_position_id), 20);
4761:
4762: RAISE mnoa_error;
4763: END IF;
4784: END IF;
4785: EXCEPTION
4786: WHEN mnoa_error THEN
4787: g_mcal_flag := FALSE;-- Bug# 14751973
4788: hr_utility.set_location ('Error occurred in '
4789: || l_proc
4790: || ' Sql error '
4791: || sqlerrm (sqlcode), 10);
4792:
4810: || p_employee_number
4811: || ' '
4812: || l_mcanerrbuf;
4813:
4814: hr_utility.set_location ('before creating entry in log file', 10);
4815: l_recs_failed := l_recs_failed + 1;
4816:
4817: BEGIN
4818: ghr_mto_int.log_message
4819: (p_procedure => g_proc
4820: , p_message => l_log_text);
4821: EXCEPTION
4822: WHEN others THEN
4823: hr_utility.set_message (8301, 'GHR_38475_ERROR_LOG_FAILURE');
4824: hr_utility.raise_error;
4825: END;
4826: WHEN others THEN
4827: g_mcal_flag := FALSE;-- Bug# 14751973
4820: , p_message => l_log_text);
4821: EXCEPTION
4822: WHEN others THEN
4823: hr_utility.set_message (8301, 'GHR_38475_ERROR_LOG_FAILURE');
4824: hr_utility.raise_error;
4825: END;
4826: WHEN others THEN
4827: g_mcal_flag := FALSE;-- Bug# 14751973
4828: hr_utility.set_location ('Error (Others3) occurred in '
4824: hr_utility.raise_error;
4825: END;
4826: WHEN others THEN
4827: g_mcal_flag := FALSE;-- Bug# 14751973
4828: hr_utility.set_location ('Error (Others3) occurred in '
4829: || l_proc
4830: || ' Sql error '
4831: || sqlerrm (sqlcode), 30);
4832:
4844: || ' Sql Err is '
4845: || sqlerrm (sqlcode);
4846:
4847: l_recs_failed := l_recs_failed + 1;
4848: hr_utility.set_location ('before creating entry in log file', 30);
4849: p_errbuf := 'Error in '
4850: || l_proc
4851: || ' Details in GHR_PROCESS_LOG';
4852: p_retcode := 2;
4864: (p_procedure => g_proc
4865: , p_message => l_log_text);
4866: EXCEPTION
4867: WHEN others THEN
4868: hr_utility.set_message (8301, 'Create Error Log failed');
4869: hr_utility.raise_error;
4870: END;
4871:
4872: END;
4865: , p_message => l_log_text);
4866: EXCEPTION
4867: WHEN others THEN
4868: hr_utility.set_message (8301, 'Create Error Log failed');
4869: hr_utility.raise_error;
4870: END;
4871:
4872: END;
4873: END LOOP;--FOR l_pa_req_rec
4879: l_name := c_get_dtl.fname;
4880: l_employee_number := ghr_pa_requests_pkg2.get_employee_number
4881: (p_person_id => c_get_dtl.person_id
4882: , p_effective_date => p_effective_date);
4883: hr_utility.set_location ('Mass Cancellation already done for this ' || l_proc, 1);
4884: l_mcanerrbuf := 'Name: '
4885: || l_name
4886: || '; Emp No: '
4887: || l_employee_number
4893: END IF;--IF l_total_recs
4894: EXCEPTION
4895: WHEN others THEN
4896: g_mcal_flag := FALSE;-- Bug# 14751973
4897: hr_utility.set_location ('Error (Others3) occurred in '
4898: || l_proc
4899: || ' Sql error '
4900: || sqlerrm (sqlcode), 30);
4901:
4913: || ' Sql Err is '
4914: || sqlerrm (sqlcode);
4915:
4916: l_recs_failed := l_recs_failed + 1;
4917: hr_utility.set_location ('before creating entry in log file', 30);
4918: p_errbuf := 'Error in '
4919: || l_proc
4920: || ' Details in GHR_PROCESS_LOG';
4921: p_retcode := 2;
4933: (p_procedure => g_proc
4934: , p_message => l_log_text);
4935: EXCEPTION
4936: WHEN others THEN
4937: hr_utility.set_message (8301, 'Create Error Log failed');
4938: hr_utility.raise_error;
4939: END;
4940: END mcancel_process;
4941: BEGIN
4934: , p_message => l_log_text);
4935: EXCEPTION
4936: WHEN others THEN
4937: hr_utility.set_message (8301, 'Create Error Log failed');
4938: hr_utility.raise_error;
4939: END;
4940: END mcancel_process;
4941: BEGIN
4942: hr_utility.set_location ('Entering main execute_mcancel '
4938: hr_utility.raise_error;
4939: END;
4940: END mcancel_process;
4941: BEGIN
4942: hr_utility.set_location ('Entering main execute_mcancel '
4943: || l_proc, 5);
4944: p_retcode := 0;
4945:
4946: BEGIN
4943: || l_proc, 5);
4944: p_retcode := 0;
4945:
4946: BEGIN
4947: hr_utility.set_location ('Mass id '
4948: || p_mass_salary_id, 51);
4949:
4950: FOR mcancel IN ghr_mcancel (p_mass_salary_id) LOOP
4951: hr_utility.set_location ('Mass Criteria name '
4947: hr_utility.set_location ('Mass id '
4948: || p_mass_salary_id, 51);
4949:
4950: FOR mcancel IN ghr_mcancel (p_mass_salary_id) LOOP
4951: hr_utility.set_location ('Mass Criteria name '
4952: || mcancel.name, 51);
4953:
4954: p_mass_salary := mcancel.name;
4955: l_effective_date := mcancel.effective_date;
4964: EXIT;
4965: END LOOP;
4966: EXCEPTION
4967: WHEN rec_busy THEN
4968: hr_utility.set_location ('Mass Cancellation is in use'
4969: || l_proc, 1);
4970:
4971: l_mcanerrbuf := 'Error in '
4972: || l_proc
4972: || l_proc
4973: || ' Sql Err is '
4974: || sqlerrm (sqlcode);
4975:
4976: hr_utility.set_message (8301, 'GHR_38477_LOCK_ON_MSL');
4977:
4978: hr_utility.raise_error;
4979: WHEN others THEN
4980: hr_utility.set_location ('Error in '
4974: || sqlerrm (sqlcode);
4975:
4976: hr_utility.set_message (8301, 'GHR_38477_LOCK_ON_MSL');
4977:
4978: hr_utility.raise_error;
4979: WHEN others THEN
4980: hr_utility.set_location ('Error in '
4981: || l_proc
4982: || ' Sql err is '
4976: hr_utility.set_message (8301, 'GHR_38477_LOCK_ON_MSL');
4977:
4978: hr_utility.raise_error;
4979: WHEN others THEN
4980: hr_utility.set_location ('Error in '
4981: || l_proc
4982: || ' Sql err is '
4983: || sqlerrm (sqlcode), 1);
4984:
4999: || p_mass_salary);
5000: END IF;
5001:
5002: get_lac_dtls (l_pa_request_id, l_lac_sf52_rec);
5003: hr_utility.set_location ('Mass Action name '
5004: || p_action, 52);
5005:
5006: BEGIN
5007: mcancel_process (l_mass_salary_id, l_target_mass_action_id
5017: SET submit_flag = 'P'
5018: WHERE rowid = l_rowid;
5019: EXCEPTION
5020: WHEN others THEN
5021: hr_utility.set_location ('Error in Update ghr_msl Sql error '
5022: || sqlerrm (sqlcode), 30);
5023:
5024: hr_utility.set_message (8301, 'GHR_38476_UPD_GHR_MSL_FAILURE');
5025:
5020: WHEN others THEN
5021: hr_utility.set_location ('Error in Update ghr_msl Sql error '
5022: || sqlerrm (sqlcode), 30);
5023:
5024: hr_utility.set_message (8301, 'GHR_38476_UPD_GHR_MSL_FAILURE');
5025:
5026: hr_utility.raise_error;
5027: END;
5028: END IF;
5022: || sqlerrm (sqlcode), 30);
5023:
5024: hr_utility.set_message (8301, 'GHR_38476_UPD_GHR_MSL_FAILURE');
5025:
5026: hr_utility.raise_error;
5027: END;
5028: END IF;
5029: ELSE
5030: p_errbuf := 'Error in '
5046:
5047: pr ('After commiting.....', to_char (l_recs_failed));
5048: EXCEPTION
5049: WHEN others THEN
5050: hr_utility.set_location ('Error (Others4) occurred in '
5051: || l_proc
5052: || ' Sql error '
5053: || sqlerrm (sqlcode), 30);
5054:
5067: || sqlerrm (sqlcode);
5068:
5069: l_recs_failed := l_recs_failed + 1;
5070:
5071: hr_utility.set_location ('before creating entry in log file', 30);
5072:
5073: p_errbuf := 'Error in '
5074: || l_proc
5075: || ' Details in GHR_PROCESS_LOG';
5089: (p_procedure => g_proc
5090: , p_message => l_log_text);
5091: EXCEPTION
5092: WHEN others THEN
5093: hr_utility.set_message (8301, 'Create Error Log failed');
5094:
5095: hr_utility.raise_error;
5096: END;
5097: END execute_mcancel;
5091: EXCEPTION
5092: WHEN others THEN
5093: hr_utility.set_message (8301, 'Create Error Log failed');
5094:
5095: hr_utility.raise_error;
5096: END;
5097: END execute_mcancel;
5098: --End Bug# 14467215
5099: --Begin Bug# 14751973