[Home] [Help]
446: l_grade_or_level := p_grade_or_level;
447: l_to_grade_or_level := p_to_grade_or_level;
448: l_step_or_rate := P_step_or_rate;
449: l_pay_basis := p_pay_basis;
450: hr_utility.set_location('The location id is:'||l_location_id,1);
451:
452: --------GPPA Update 46 start
453: ghr_msl_pkg.g_first_noa_code := NULL;
454: FOR cur_eq_ppl_rec IN cur_eq_ppl(l_pay_plan)
491: LOOP
492: l_ds_end_date := rec_ds.end_Date;
493: END LOOP;
494: IF l_ds_end_date IS NULL THEN
495: hr_utility.set_location('Under DS null check'||l_duty_station_id, 1);
496: l_mslerrbuf := ' Error: Duty Station associated with the location is INVALID. '||
497: 'Salary cannot be calculated correctly without valid duty station. ';
498: RAISE msl_error;
499: END IF;
506: (p_location_id => l_location_id
507: ,p_duty_station_id => l_duty_station_id);
508: / *exception
509: when others then
510: hr_utility.set_location(
511: 'Error in Ghr_pa_requests_pkg.get_sf52_loc_ddf_details'||
512: 'Err is '||sqlerrm(sqlcode),20);
513: l_mslerrbuf := 'Error in get_sf52_loc_ddf_details '||
514: 'Sql Err is '|| sqlerrm(sqlcode);
533: l_position_title,
534: l_position_number,
535: l_position_seq_no);
536:
537: hr_utility.set_location('The duty station id is:'||l_duty_station_id,12345);
538:
539: if check_init_eligibility(l_p_duty_station_id,
540: l_p_PERSONNEL_OFFICE_ID,
541: l_p_AGENCY_CODE_SUBELEMENT,
542: l_duty_station_id,
543: l_personnel_office_id,
544: l_sub_element_code) then
545:
546: hr_utility.set_location('check_init_eligibility ' || l_proc,6);
547: -- Bug 3457205 Filter the Pay plan table id condition also b4 checking any other thing
548: -- Moving check_eligibility to here.
549: -- Get PRD, work schedule etc form ASG EI
550: begin
557: l_work_schedule,
558: l_part_time_hour);
559: exception
560: when others then
561: hr_utility.set_location('Error in Ghr_pa_requests_pkg.get_sf52_asg_ddf_details'||
562: 'Err is '||sqlerrm(sqlcode),20);
563: l_mslerrbuf := 'Error in get_sf52_asgddf_details Sql Err is '|| sqlerrm(sqlcode);
564: raise msl_error;
565: end;
581: l_grade_or_level, l_to_grade_or_level, l_step_or_rate,
582: l_pay_basis);
583: EXCEPTION
584: when msl_error then
585: l_mslerrbuf := hr_utility.get_message;
586: raise;
587: END;
588:
589: IF ( nvl(rec_pp_prd(l_cnt).pay_plan,l_pay_plan) = l_pay_plan
596: l_pay_rate_determinant,
597: p_person_id,
598: l_effective_date,
599: p_action) THEN
600: hr_utility.set_location('check_eligibility ' || l_proc,8); */
601: -- Bug#5063304 Moved this call outside check_init_eligibility condition to
602: -- this location.
603: -- BUG 3377958 Madhuri
604: -- Pick the organization name
612: ELSE
613: if check_select_flg(p_person_id,upper(p_action),
614: l_effective_date,p_mass_salary_id,l_sel_flg) then
615:
616: hr_utility.set_location('check_select_flg ' || l_proc,7);
617: BEGIN
618: hr_utility.set_location('The duty station name is:'||l_duty_station_code,12345);
619: hr_utility.set_location('The duty station desc is:'||l_duty_station_desc,12345);
620: ghr_pa_requests_pkg.get_duty_station_details
614: l_effective_date,p_mass_salary_id,l_sel_flg) then
615:
616: hr_utility.set_location('check_select_flg ' || l_proc,7);
617: BEGIN
618: hr_utility.set_location('The duty station name is:'||l_duty_station_code,12345);
619: hr_utility.set_location('The duty station desc is:'||l_duty_station_desc,12345);
620: ghr_pa_requests_pkg.get_duty_station_details
621: (p_duty_station_id => l_duty_station_id
622: ,p_effective_date => l_effective_date
615:
616: hr_utility.set_location('check_select_flg ' || l_proc,7);
617: BEGIN
618: hr_utility.set_location('The duty station name is:'||l_duty_station_code,12345);
619: hr_utility.set_location('The duty station desc is:'||l_duty_station_desc,12345);
620: ghr_pa_requests_pkg.get_duty_station_details
621: (p_duty_station_id => l_duty_station_id
622: ,p_effective_date => l_effective_date
623: ,p_duty_station_code => l_duty_station_code
623: ,p_duty_station_code => l_duty_station_code
624: ,p_duty_station_desc => l_duty_station_desc);
625: EXCEPTION
626: WHEN others THEN
627: hr_utility.set_location('Error in Ghr_pa_requests_pkg.get_duty_station_details'||
628: 'Err is '||sqlerrm(sqlcode),20);
629: l_mslerrbuf := 'Error in get_duty_station_details Sql Err is '|| sqlerrm(sqlcode);
630: RAISE msl_error;
631:
698: ,l_message_set
699: ,l_calculated);
700:
701: IF l_message_set THEN
702: hr_utility.set_location( l_proc, 40);
703: l_calculated := FALSE;
704: l_mslerrbuf := hr_utility.get_message;
705: -- raise msl_error;
706: END IF;
700:
701: IF l_message_set THEN
702: hr_utility.set_location( l_proc, 40);
703: l_calculated := FALSE;
704: l_mslerrbuf := hr_utility.get_message;
705: -- raise msl_error;
706: END IF;
707: EXCEPTION
708: when msl_error then
785: ins_upd_per_extra_info
786: (p_person_id,l_effective_date, l_sel_flg, l_comment,p_mass_salary_id);
787: l_comment := NULL;
788: ------ BUG 3287299 End
789: hr_utility.set_location('Error in Ghr_pay_calc.sql_main_pay_calc '||
790: 'Err is '||sqlerrm(sqlcode),20);
791: l_mslerrbuf := 'Error in ghr_pay_calc Sql Err is '|| sqlerrm(sqlcode);
792: g_proc := 'ghr_pay_calc';
793: raise msl_error;
819: l_new_other_pay_amount := null;
820: end if;
821: l_new_total_salary := l_pay_calc_out_data.total_salary;
822:
823: hr_utility.set_location('retention_allowance = ' || to_char(l_retention_allowance),10);
824: hr_utility.set_location('Supervisory Diff Amount = ' || to_char(l_supervisory_differential),10);
825:
826:
827: -------------Call Pay cap Procedure
820: end if;
821: l_new_total_salary := l_pay_calc_out_data.total_salary;
822:
823: hr_utility.set_location('retention_allowance = ' || to_char(l_retention_allowance),10);
824: hr_utility.set_location('Supervisory Diff Amount = ' || to_char(l_supervisory_differential),10);
825:
826:
827: -------------Call Pay cap Procedure
828: begin
829: l_capped_other_pay := ghr_pa_requests_pkg2.get_cop( p_assignment_id => l_assignment_id
830: ,p_effective_date => l_effective_date);
831: l_old_capped_other_pay := l_capped_other_pay;
832: -- Sundar Added the following if statement to improve performance
833: if hr_utility.debug_enabled = true then
834: hr_utility.set_location('Before Pay Cap ' || l_proc,21);
835: hr_utility.set_location('l_effective_date ' || l_effective_date,21);
836: hr_utility.set_location('l_out_pay_rate_determinant ' || l_out_pay_rate_determinant,21);
837: hr_utility.set_location('l_pay_plan ' || l_pay_plan,21);
830: ,p_effective_date => l_effective_date);
831: l_old_capped_other_pay := l_capped_other_pay;
832: -- Sundar Added the following if statement to improve performance
833: if hr_utility.debug_enabled = true then
834: hr_utility.set_location('Before Pay Cap ' || l_proc,21);
835: hr_utility.set_location('l_effective_date ' || l_effective_date,21);
836: hr_utility.set_location('l_out_pay_rate_determinant ' || l_out_pay_rate_determinant,21);
837: hr_utility.set_location('l_pay_plan ' || l_pay_plan,21);
838: hr_utility.set_location('l_position_id ' || to_char(l_position_id),21);
831: l_old_capped_other_pay := l_capped_other_pay;
832: -- Sundar Added the following if statement to improve performance
833: if hr_utility.debug_enabled = true then
834: hr_utility.set_location('Before Pay Cap ' || l_proc,21);
835: hr_utility.set_location('l_effective_date ' || l_effective_date,21);
836: hr_utility.set_location('l_out_pay_rate_determinant ' || l_out_pay_rate_determinant,21);
837: hr_utility.set_location('l_pay_plan ' || l_pay_plan,21);
838: hr_utility.set_location('l_position_id ' || to_char(l_position_id),21);
839: hr_utility.set_location('l_pay_basis ' || l_pay_basis,21);
832: -- Sundar Added the following if statement to improve performance
833: if hr_utility.debug_enabled = true then
834: hr_utility.set_location('Before Pay Cap ' || l_proc,21);
835: hr_utility.set_location('l_effective_date ' || l_effective_date,21);
836: hr_utility.set_location('l_out_pay_rate_determinant ' || l_out_pay_rate_determinant,21);
837: hr_utility.set_location('l_pay_plan ' || l_pay_plan,21);
838: hr_utility.set_location('l_position_id ' || to_char(l_position_id),21);
839: hr_utility.set_location('l_pay_basis ' || l_pay_basis,21);
840: hr_utility.set_location('person_id ' || to_char(p_person_id),21);
833: if hr_utility.debug_enabled = true then
834: hr_utility.set_location('Before Pay Cap ' || l_proc,21);
835: hr_utility.set_location('l_effective_date ' || l_effective_date,21);
836: hr_utility.set_location('l_out_pay_rate_determinant ' || l_out_pay_rate_determinant,21);
837: hr_utility.set_location('l_pay_plan ' || l_pay_plan,21);
838: hr_utility.set_location('l_position_id ' || to_char(l_position_id),21);
839: hr_utility.set_location('l_pay_basis ' || l_pay_basis,21);
840: hr_utility.set_location('person_id ' || to_char(p_person_id),21);
841: hr_utility.set_location('l_new_basic_pay ' || to_char(l_new_basic_pay),21);
834: hr_utility.set_location('Before Pay Cap ' || l_proc,21);
835: hr_utility.set_location('l_effective_date ' || l_effective_date,21);
836: hr_utility.set_location('l_out_pay_rate_determinant ' || l_out_pay_rate_determinant,21);
837: hr_utility.set_location('l_pay_plan ' || l_pay_plan,21);
838: hr_utility.set_location('l_position_id ' || to_char(l_position_id),21);
839: hr_utility.set_location('l_pay_basis ' || l_pay_basis,21);
840: hr_utility.set_location('person_id ' || to_char(p_person_id),21);
841: hr_utility.set_location('l_new_basic_pay ' || to_char(l_new_basic_pay),21);
842: hr_utility.set_location('l_new_locality_adj ' || to_char(l_new_locality_adj),21);
835: hr_utility.set_location('l_effective_date ' || l_effective_date,21);
836: hr_utility.set_location('l_out_pay_rate_determinant ' || l_out_pay_rate_determinant,21);
837: hr_utility.set_location('l_pay_plan ' || l_pay_plan,21);
838: hr_utility.set_location('l_position_id ' || to_char(l_position_id),21);
839: hr_utility.set_location('l_pay_basis ' || l_pay_basis,21);
840: hr_utility.set_location('person_id ' || to_char(p_person_id),21);
841: hr_utility.set_location('l_new_basic_pay ' || to_char(l_new_basic_pay),21);
842: hr_utility.set_location('l_new_locality_adj ' || to_char(l_new_locality_adj),21);
843: hr_utility.set_location('l_new_adj_basic_pay ' || to_char(l_new_adj_basic_pay),21);
836: hr_utility.set_location('l_out_pay_rate_determinant ' || l_out_pay_rate_determinant,21);
837: hr_utility.set_location('l_pay_plan ' || l_pay_plan,21);
838: hr_utility.set_location('l_position_id ' || to_char(l_position_id),21);
839: hr_utility.set_location('l_pay_basis ' || l_pay_basis,21);
840: hr_utility.set_location('person_id ' || to_char(p_person_id),21);
841: hr_utility.set_location('l_new_basic_pay ' || to_char(l_new_basic_pay),21);
842: hr_utility.set_location('l_new_locality_adj ' || to_char(l_new_locality_adj),21);
843: hr_utility.set_location('l_new_adj_basic_pay ' || to_char(l_new_adj_basic_pay),21);
844: hr_utility.set_location('l_new_total_salary ' || to_char(l_new_total_salary),21);
837: hr_utility.set_location('l_pay_plan ' || l_pay_plan,21);
838: hr_utility.set_location('l_position_id ' || to_char(l_position_id),21);
839: hr_utility.set_location('l_pay_basis ' || l_pay_basis,21);
840: hr_utility.set_location('person_id ' || to_char(p_person_id),21);
841: hr_utility.set_location('l_new_basic_pay ' || to_char(l_new_basic_pay),21);
842: hr_utility.set_location('l_new_locality_adj ' || to_char(l_new_locality_adj),21);
843: hr_utility.set_location('l_new_adj_basic_pay ' || to_char(l_new_adj_basic_pay),21);
844: hr_utility.set_location('l_new_total_salary ' || to_char(l_new_total_salary),21);
845: hr_utility.set_location('l_entitled_other_pay ' || to_char(l_entitled_other_pay),21);
838: hr_utility.set_location('l_position_id ' || to_char(l_position_id),21);
839: hr_utility.set_location('l_pay_basis ' || l_pay_basis,21);
840: hr_utility.set_location('person_id ' || to_char(p_person_id),21);
841: hr_utility.set_location('l_new_basic_pay ' || to_char(l_new_basic_pay),21);
842: hr_utility.set_location('l_new_locality_adj ' || to_char(l_new_locality_adj),21);
843: hr_utility.set_location('l_new_adj_basic_pay ' || to_char(l_new_adj_basic_pay),21);
844: hr_utility.set_location('l_new_total_salary ' || to_char(l_new_total_salary),21);
845: hr_utility.set_location('l_entitled_other_pay ' || to_char(l_entitled_other_pay),21);
846: hr_utility.set_location('l_capped_other_pay ' || to_char(l_capped_other_pay),21);
839: hr_utility.set_location('l_pay_basis ' || l_pay_basis,21);
840: hr_utility.set_location('person_id ' || to_char(p_person_id),21);
841: hr_utility.set_location('l_new_basic_pay ' || to_char(l_new_basic_pay),21);
842: hr_utility.set_location('l_new_locality_adj ' || to_char(l_new_locality_adj),21);
843: hr_utility.set_location('l_new_adj_basic_pay ' || to_char(l_new_adj_basic_pay),21);
844: hr_utility.set_location('l_new_total_salary ' || to_char(l_new_total_salary),21);
845: hr_utility.set_location('l_entitled_other_pay ' || to_char(l_entitled_other_pay),21);
846: hr_utility.set_location('l_capped_other_pay ' || to_char(l_capped_other_pay),21);
847: hr_utility.set_location('l_new_retention_allowance ' || to_char(l_new_retention_allowance),21);
840: hr_utility.set_location('person_id ' || to_char(p_person_id),21);
841: hr_utility.set_location('l_new_basic_pay ' || to_char(l_new_basic_pay),21);
842: hr_utility.set_location('l_new_locality_adj ' || to_char(l_new_locality_adj),21);
843: hr_utility.set_location('l_new_adj_basic_pay ' || to_char(l_new_adj_basic_pay),21);
844: hr_utility.set_location('l_new_total_salary ' || to_char(l_new_total_salary),21);
845: hr_utility.set_location('l_entitled_other_pay ' || to_char(l_entitled_other_pay),21);
846: hr_utility.set_location('l_capped_other_pay ' || to_char(l_capped_other_pay),21);
847: hr_utility.set_location('l_new_retention_allowance ' || to_char(l_new_retention_allowance),21);
848: hr_utility.set_location('l_new_supervisory_differential ' || to_char(l_new_supervisory_differential),21);
841: hr_utility.set_location('l_new_basic_pay ' || to_char(l_new_basic_pay),21);
842: hr_utility.set_location('l_new_locality_adj ' || to_char(l_new_locality_adj),21);
843: hr_utility.set_location('l_new_adj_basic_pay ' || to_char(l_new_adj_basic_pay),21);
844: hr_utility.set_location('l_new_total_salary ' || to_char(l_new_total_salary),21);
845: hr_utility.set_location('l_entitled_other_pay ' || to_char(l_entitled_other_pay),21);
846: hr_utility.set_location('l_capped_other_pay ' || to_char(l_capped_other_pay),21);
847: hr_utility.set_location('l_new_retention_allowance ' || to_char(l_new_retention_allowance),21);
848: hr_utility.set_location('l_new_supervisory_differential ' || to_char(l_new_supervisory_differential),21);
849: hr_utility.set_location('l_staffing_differential ' || to_char(l_staffing_differential),21);
842: hr_utility.set_location('l_new_locality_adj ' || to_char(l_new_locality_adj),21);
843: hr_utility.set_location('l_new_adj_basic_pay ' || to_char(l_new_adj_basic_pay),21);
844: hr_utility.set_location('l_new_total_salary ' || to_char(l_new_total_salary),21);
845: hr_utility.set_location('l_entitled_other_pay ' || to_char(l_entitled_other_pay),21);
846: hr_utility.set_location('l_capped_other_pay ' || to_char(l_capped_other_pay),21);
847: hr_utility.set_location('l_new_retention_allowance ' || to_char(l_new_retention_allowance),21);
848: hr_utility.set_location('l_new_supervisory_differential ' || to_char(l_new_supervisory_differential),21);
849: hr_utility.set_location('l_staffing_differential ' || to_char(l_staffing_differential),21);
850: hr_utility.set_location('l_new_au_overtime ' || to_char(l_new_au_overtime),21);
843: hr_utility.set_location('l_new_adj_basic_pay ' || to_char(l_new_adj_basic_pay),21);
844: hr_utility.set_location('l_new_total_salary ' || to_char(l_new_total_salary),21);
845: hr_utility.set_location('l_entitled_other_pay ' || to_char(l_entitled_other_pay),21);
846: hr_utility.set_location('l_capped_other_pay ' || to_char(l_capped_other_pay),21);
847: hr_utility.set_location('l_new_retention_allowance ' || to_char(l_new_retention_allowance),21);
848: hr_utility.set_location('l_new_supervisory_differential ' || to_char(l_new_supervisory_differential),21);
849: hr_utility.set_location('l_staffing_differential ' || to_char(l_staffing_differential),21);
850: hr_utility.set_location('l_new_au_overtime ' || to_char(l_new_au_overtime),21);
851: hr_utility.set_location('l_new_availability_pay ' || to_char(l_new_availability_pay),21);
844: hr_utility.set_location('l_new_total_salary ' || to_char(l_new_total_salary),21);
845: hr_utility.set_location('l_entitled_other_pay ' || to_char(l_entitled_other_pay),21);
846: hr_utility.set_location('l_capped_other_pay ' || to_char(l_capped_other_pay),21);
847: hr_utility.set_location('l_new_retention_allowance ' || to_char(l_new_retention_allowance),21);
848: hr_utility.set_location('l_new_supervisory_differential ' || to_char(l_new_supervisory_differential),21);
849: hr_utility.set_location('l_staffing_differential ' || to_char(l_staffing_differential),21);
850: hr_utility.set_location('l_new_au_overtime ' || to_char(l_new_au_overtime),21);
851: hr_utility.set_location('l_new_availability_pay ' || to_char(l_new_availability_pay),21);
852:
845: hr_utility.set_location('l_entitled_other_pay ' || to_char(l_entitled_other_pay),21);
846: hr_utility.set_location('l_capped_other_pay ' || to_char(l_capped_other_pay),21);
847: hr_utility.set_location('l_new_retention_allowance ' || to_char(l_new_retention_allowance),21);
848: hr_utility.set_location('l_new_supervisory_differential ' || to_char(l_new_supervisory_differential),21);
849: hr_utility.set_location('l_staffing_differential ' || to_char(l_staffing_differential),21);
850: hr_utility.set_location('l_new_au_overtime ' || to_char(l_new_au_overtime),21);
851: hr_utility.set_location('l_new_availability_pay ' || to_char(l_new_availability_pay),21);
852:
853: end if;
846: hr_utility.set_location('l_capped_other_pay ' || to_char(l_capped_other_pay),21);
847: hr_utility.set_location('l_new_retention_allowance ' || to_char(l_new_retention_allowance),21);
848: hr_utility.set_location('l_new_supervisory_differential ' || to_char(l_new_supervisory_differential),21);
849: hr_utility.set_location('l_staffing_differential ' || to_char(l_staffing_differential),21);
850: hr_utility.set_location('l_new_au_overtime ' || to_char(l_new_au_overtime),21);
851: hr_utility.set_location('l_new_availability_pay ' || to_char(l_new_availability_pay),21);
852:
853: end if;
854:
847: hr_utility.set_location('l_new_retention_allowance ' || to_char(l_new_retention_allowance),21);
848: hr_utility.set_location('l_new_supervisory_differential ' || to_char(l_new_supervisory_differential),21);
849: hr_utility.set_location('l_staffing_differential ' || to_char(l_staffing_differential),21);
850: hr_utility.set_location('l_new_au_overtime ' || to_char(l_new_au_overtime),21);
851: hr_utility.set_location('l_new_availability_pay ' || to_char(l_new_availability_pay),21);
852:
853: end if;
854:
855:
884:
885: l_new_other_pay_amount := nvl(l_capped_other_pay,l_entitled_other_pay);
886:
887: -- Sundar Added the following statement to improve performance
888: if hr_utility.debug_enabled = true then
889: hr_utility.set_location('After Pay Cap ' || l_proc,22);
890: hr_utility.set_location('l_effective_date ' || l_effective_date,22);
891: hr_utility.set_location('l_out_pay_rate_determinant ' || l_out_pay_rate_determinant,22);
892: hr_utility.set_location('l_pay_plan ' || l_pay_plan,22);
885: l_new_other_pay_amount := nvl(l_capped_other_pay,l_entitled_other_pay);
886:
887: -- Sundar Added the following statement to improve performance
888: if hr_utility.debug_enabled = true then
889: hr_utility.set_location('After Pay Cap ' || l_proc,22);
890: hr_utility.set_location('l_effective_date ' || l_effective_date,22);
891: hr_utility.set_location('l_out_pay_rate_determinant ' || l_out_pay_rate_determinant,22);
892: hr_utility.set_location('l_pay_plan ' || l_pay_plan,22);
893: hr_utility.set_location('l_position_id ' || to_char(l_position_id),22);
886:
887: -- Sundar Added the following statement to improve performance
888: if hr_utility.debug_enabled = true then
889: hr_utility.set_location('After Pay Cap ' || l_proc,22);
890: hr_utility.set_location('l_effective_date ' || l_effective_date,22);
891: hr_utility.set_location('l_out_pay_rate_determinant ' || l_out_pay_rate_determinant,22);
892: hr_utility.set_location('l_pay_plan ' || l_pay_plan,22);
893: hr_utility.set_location('l_position_id ' || to_char(l_position_id),22);
894: hr_utility.set_location('l_pay_basis ' || l_pay_basis,22);
887: -- Sundar Added the following statement to improve performance
888: if hr_utility.debug_enabled = true then
889: hr_utility.set_location('After Pay Cap ' || l_proc,22);
890: hr_utility.set_location('l_effective_date ' || l_effective_date,22);
891: hr_utility.set_location('l_out_pay_rate_determinant ' || l_out_pay_rate_determinant,22);
892: hr_utility.set_location('l_pay_plan ' || l_pay_plan,22);
893: hr_utility.set_location('l_position_id ' || to_char(l_position_id),22);
894: hr_utility.set_location('l_pay_basis ' || l_pay_basis,22);
895: hr_utility.set_location('person_id ' || to_char(p_person_id),22);
888: if hr_utility.debug_enabled = true then
889: hr_utility.set_location('After Pay Cap ' || l_proc,22);
890: hr_utility.set_location('l_effective_date ' || l_effective_date,22);
891: hr_utility.set_location('l_out_pay_rate_determinant ' || l_out_pay_rate_determinant,22);
892: hr_utility.set_location('l_pay_plan ' || l_pay_plan,22);
893: hr_utility.set_location('l_position_id ' || to_char(l_position_id),22);
894: hr_utility.set_location('l_pay_basis ' || l_pay_basis,22);
895: hr_utility.set_location('person_id ' || to_char(p_person_id),22);
896: hr_utility.set_location('l_new_basic_pay ' || to_char(l_new_basic_pay),22);
889: hr_utility.set_location('After Pay Cap ' || l_proc,22);
890: hr_utility.set_location('l_effective_date ' || l_effective_date,22);
891: hr_utility.set_location('l_out_pay_rate_determinant ' || l_out_pay_rate_determinant,22);
892: hr_utility.set_location('l_pay_plan ' || l_pay_plan,22);
893: hr_utility.set_location('l_position_id ' || to_char(l_position_id),22);
894: hr_utility.set_location('l_pay_basis ' || l_pay_basis,22);
895: hr_utility.set_location('person_id ' || to_char(p_person_id),22);
896: hr_utility.set_location('l_new_basic_pay ' || to_char(l_new_basic_pay),22);
897: hr_utility.set_location('l_new_locality_adj ' || to_char(l_new_locality_adj),22);
890: hr_utility.set_location('l_effective_date ' || l_effective_date,22);
891: hr_utility.set_location('l_out_pay_rate_determinant ' || l_out_pay_rate_determinant,22);
892: hr_utility.set_location('l_pay_plan ' || l_pay_plan,22);
893: hr_utility.set_location('l_position_id ' || to_char(l_position_id),22);
894: hr_utility.set_location('l_pay_basis ' || l_pay_basis,22);
895: hr_utility.set_location('person_id ' || to_char(p_person_id),22);
896: hr_utility.set_location('l_new_basic_pay ' || to_char(l_new_basic_pay),22);
897: hr_utility.set_location('l_new_locality_adj ' || to_char(l_new_locality_adj),22);
898: hr_utility.set_location('l_new_adj_basic_pay ' || to_char(l_new_adj_basic_pay),22);
891: hr_utility.set_location('l_out_pay_rate_determinant ' || l_out_pay_rate_determinant,22);
892: hr_utility.set_location('l_pay_plan ' || l_pay_plan,22);
893: hr_utility.set_location('l_position_id ' || to_char(l_position_id),22);
894: hr_utility.set_location('l_pay_basis ' || l_pay_basis,22);
895: hr_utility.set_location('person_id ' || to_char(p_person_id),22);
896: hr_utility.set_location('l_new_basic_pay ' || to_char(l_new_basic_pay),22);
897: hr_utility.set_location('l_new_locality_adj ' || to_char(l_new_locality_adj),22);
898: hr_utility.set_location('l_new_adj_basic_pay ' || to_char(l_new_adj_basic_pay),22);
899: hr_utility.set_location('l_new_total_salary ' || to_char(l_new_total_salary),22);
892: hr_utility.set_location('l_pay_plan ' || l_pay_plan,22);
893: hr_utility.set_location('l_position_id ' || to_char(l_position_id),22);
894: hr_utility.set_location('l_pay_basis ' || l_pay_basis,22);
895: hr_utility.set_location('person_id ' || to_char(p_person_id),22);
896: hr_utility.set_location('l_new_basic_pay ' || to_char(l_new_basic_pay),22);
897: hr_utility.set_location('l_new_locality_adj ' || to_char(l_new_locality_adj),22);
898: hr_utility.set_location('l_new_adj_basic_pay ' || to_char(l_new_adj_basic_pay),22);
899: hr_utility.set_location('l_new_total_salary ' || to_char(l_new_total_salary),22);
900: hr_utility.set_location('l_entitled_other_pay ' || to_char(l_entitled_other_pay),22);
893: hr_utility.set_location('l_position_id ' || to_char(l_position_id),22);
894: hr_utility.set_location('l_pay_basis ' || l_pay_basis,22);
895: hr_utility.set_location('person_id ' || to_char(p_person_id),22);
896: hr_utility.set_location('l_new_basic_pay ' || to_char(l_new_basic_pay),22);
897: hr_utility.set_location('l_new_locality_adj ' || to_char(l_new_locality_adj),22);
898: hr_utility.set_location('l_new_adj_basic_pay ' || to_char(l_new_adj_basic_pay),22);
899: hr_utility.set_location('l_new_total_salary ' || to_char(l_new_total_salary),22);
900: hr_utility.set_location('l_entitled_other_pay ' || to_char(l_entitled_other_pay),22);
901: hr_utility.set_location('l_capped_other_pay ' || to_char(l_capped_other_pay),22);
894: hr_utility.set_location('l_pay_basis ' || l_pay_basis,22);
895: hr_utility.set_location('person_id ' || to_char(p_person_id),22);
896: hr_utility.set_location('l_new_basic_pay ' || to_char(l_new_basic_pay),22);
897: hr_utility.set_location('l_new_locality_adj ' || to_char(l_new_locality_adj),22);
898: hr_utility.set_location('l_new_adj_basic_pay ' || to_char(l_new_adj_basic_pay),22);
899: hr_utility.set_location('l_new_total_salary ' || to_char(l_new_total_salary),22);
900: hr_utility.set_location('l_entitled_other_pay ' || to_char(l_entitled_other_pay),22);
901: hr_utility.set_location('l_capped_other_pay ' || to_char(l_capped_other_pay),22);
902: hr_utility.set_location('l_new_retention_allowance ' || to_char(l_new_retention_allowance),22);
895: hr_utility.set_location('person_id ' || to_char(p_person_id),22);
896: hr_utility.set_location('l_new_basic_pay ' || to_char(l_new_basic_pay),22);
897: hr_utility.set_location('l_new_locality_adj ' || to_char(l_new_locality_adj),22);
898: hr_utility.set_location('l_new_adj_basic_pay ' || to_char(l_new_adj_basic_pay),22);
899: hr_utility.set_location('l_new_total_salary ' || to_char(l_new_total_salary),22);
900: hr_utility.set_location('l_entitled_other_pay ' || to_char(l_entitled_other_pay),22);
901: hr_utility.set_location('l_capped_other_pay ' || to_char(l_capped_other_pay),22);
902: hr_utility.set_location('l_new_retention_allowance ' || to_char(l_new_retention_allowance),22);
903: hr_utility.set_location('l_new_supervisory_differential ' || to_char(l_new_supervisory_differential),22);
896: hr_utility.set_location('l_new_basic_pay ' || to_char(l_new_basic_pay),22);
897: hr_utility.set_location('l_new_locality_adj ' || to_char(l_new_locality_adj),22);
898: hr_utility.set_location('l_new_adj_basic_pay ' || to_char(l_new_adj_basic_pay),22);
899: hr_utility.set_location('l_new_total_salary ' || to_char(l_new_total_salary),22);
900: hr_utility.set_location('l_entitled_other_pay ' || to_char(l_entitled_other_pay),22);
901: hr_utility.set_location('l_capped_other_pay ' || to_char(l_capped_other_pay),22);
902: hr_utility.set_location('l_new_retention_allowance ' || to_char(l_new_retention_allowance),22);
903: hr_utility.set_location('l_new_supervisory_differential ' || to_char(l_new_supervisory_differential),22);
904: hr_utility.set_location('l_staffing_differential ' || to_char(l_staffing_differential),22);
897: hr_utility.set_location('l_new_locality_adj ' || to_char(l_new_locality_adj),22);
898: hr_utility.set_location('l_new_adj_basic_pay ' || to_char(l_new_adj_basic_pay),22);
899: hr_utility.set_location('l_new_total_salary ' || to_char(l_new_total_salary),22);
900: hr_utility.set_location('l_entitled_other_pay ' || to_char(l_entitled_other_pay),22);
901: hr_utility.set_location('l_capped_other_pay ' || to_char(l_capped_other_pay),22);
902: hr_utility.set_location('l_new_retention_allowance ' || to_char(l_new_retention_allowance),22);
903: hr_utility.set_location('l_new_supervisory_differential ' || to_char(l_new_supervisory_differential),22);
904: hr_utility.set_location('l_staffing_differential ' || to_char(l_staffing_differential),22);
905: hr_utility.set_location('l_new_au_overtime ' || to_char(l_new_au_overtime),22);
898: hr_utility.set_location('l_new_adj_basic_pay ' || to_char(l_new_adj_basic_pay),22);
899: hr_utility.set_location('l_new_total_salary ' || to_char(l_new_total_salary),22);
900: hr_utility.set_location('l_entitled_other_pay ' || to_char(l_entitled_other_pay),22);
901: hr_utility.set_location('l_capped_other_pay ' || to_char(l_capped_other_pay),22);
902: hr_utility.set_location('l_new_retention_allowance ' || to_char(l_new_retention_allowance),22);
903: hr_utility.set_location('l_new_supervisory_differential ' || to_char(l_new_supervisory_differential),22);
904: hr_utility.set_location('l_staffing_differential ' || to_char(l_staffing_differential),22);
905: hr_utility.set_location('l_new_au_overtime ' || to_char(l_new_au_overtime),22);
906: hr_utility.set_location('l_new_availability_pay ' || to_char(l_new_availability_pay),22);
899: hr_utility.set_location('l_new_total_salary ' || to_char(l_new_total_salary),22);
900: hr_utility.set_location('l_entitled_other_pay ' || to_char(l_entitled_other_pay),22);
901: hr_utility.set_location('l_capped_other_pay ' || to_char(l_capped_other_pay),22);
902: hr_utility.set_location('l_new_retention_allowance ' || to_char(l_new_retention_allowance),22);
903: hr_utility.set_location('l_new_supervisory_differential ' || to_char(l_new_supervisory_differential),22);
904: hr_utility.set_location('l_staffing_differential ' || to_char(l_staffing_differential),22);
905: hr_utility.set_location('l_new_au_overtime ' || to_char(l_new_au_overtime),22);
906: hr_utility.set_location('l_new_availability_pay ' || to_char(l_new_availability_pay),22);
907: end if;
900: hr_utility.set_location('l_entitled_other_pay ' || to_char(l_entitled_other_pay),22);
901: hr_utility.set_location('l_capped_other_pay ' || to_char(l_capped_other_pay),22);
902: hr_utility.set_location('l_new_retention_allowance ' || to_char(l_new_retention_allowance),22);
903: hr_utility.set_location('l_new_supervisory_differential ' || to_char(l_new_supervisory_differential),22);
904: hr_utility.set_location('l_staffing_differential ' || to_char(l_staffing_differential),22);
905: hr_utility.set_location('l_new_au_overtime ' || to_char(l_new_au_overtime),22);
906: hr_utility.set_location('l_new_availability_pay ' || to_char(l_new_availability_pay),22);
907: end if;
908:
901: hr_utility.set_location('l_capped_other_pay ' || to_char(l_capped_other_pay),22);
902: hr_utility.set_location('l_new_retention_allowance ' || to_char(l_new_retention_allowance),22);
903: hr_utility.set_location('l_new_supervisory_differential ' || to_char(l_new_supervisory_differential),22);
904: hr_utility.set_location('l_staffing_differential ' || to_char(l_staffing_differential),22);
905: hr_utility.set_location('l_new_au_overtime ' || to_char(l_new_au_overtime),22);
906: hr_utility.set_location('l_new_availability_pay ' || to_char(l_new_availability_pay),22);
907: end if;
908:
909: IF l_pay_cap_message THEN
902: hr_utility.set_location('l_new_retention_allowance ' || to_char(l_new_retention_allowance),22);
903: hr_utility.set_location('l_new_supervisory_differential ' || to_char(l_new_supervisory_differential),22);
904: hr_utility.set_location('l_staffing_differential ' || to_char(l_staffing_differential),22);
905: hr_utility.set_location('l_new_au_overtime ' || to_char(l_new_au_overtime),22);
906: hr_utility.set_location('l_new_availability_pay ' || to_char(l_new_availability_pay),22);
907: end if;
908:
909: IF l_pay_cap_message THEN
910: IF nvl(l_temp_retention_allowance,0) > 0 THEN
947: exception
948: when msl_error then
949: raise;
950: when others then
951: hr_utility.set_location('Error in ghr_pay_caps.do_pay_caps_main ' ||
952: 'Err is '||sqlerrm(sqlcode),23);
953: l_mslerrbuf := 'Error in do_pay_caps_main Sql Err is '|| sqlerrm(sqlcode);
954: raise msl_error;
955: end;
1041: l_grade_or_level, l_to_grade_or_level, l_step_or_rate,
1042: l_pay_basis);
1043: EXCEPTION
1044: when msl_error then
1045: l_mslerrbuf := hr_utility.get_message;
1046: raise;
1047: END;
1048:
1049: --6753050 modified if user manually changes position table from special
1109: (l_pay_calc_out_data,
1110: l_sf52_rec);
1111: EXCEPTION
1112: when others then
1113: hr_utility.set_location('Error in Ghr_mass_actions_pkg.pay_calc_rec_to_sf52_rec '||
1114: 'Err is '||sqlerrm(sqlcode),20);
1115: l_mslerrbuf := 'Error in ghr_mass_act_pkg.pay_calc_to_sf52 Sql Err is '|| sqlerrm(sqlcode);
1116: raise msl_error;
1117: END;
1218: END IF;
1219: END IF;
1220: EXCEPTION
1221: WHEN MSL_ERROR THEN
1222: HR_UTILITY.SET_LOCATION('Error occurred in '||l_proc||' Sql error '||sqlerrm(sqlcode),10);
1223: begin
1224: ------ BUG 3287299 -- Not to rollback for preview.
1225: if upper(p_action) <> 'SHOW' then
1226: ROLLBACK TO EXECUTE_MSL_SP;
1231: l_log_text := 'Error in '||l_proc||' '||
1232: ' For Mass Salary Name : '||p_mass_salary||
1233: 'Name: '|| p_full_name || ' SSN: ' || p_national_identifier ||
1234: l_mslerrbuf;
1235: hr_utility.set_location('before creating entry in log file',10);
1236: l_recs_failed := l_recs_failed + 1;
1237: begin
1238: ghr_mto_int.log_message(
1239: p_procedure => g_proc,
1239: p_procedure => g_proc,
1240: p_message => l_log_text);
1241: exception
1242: when others then
1243: hr_utility.set_message(8301, 'GHR_38475_ERROR_LOG_FAILURE');
1244: hr_utility.raise_error;
1245: end;
1246: when others then
1247: HR_UTILITY.SET_LOCATION('Error (Others) occurred in '||l_proc||' Sql error '||sqlerrm(sqlcode),20);
1240: p_message => l_log_text);
1241: exception
1242: when others then
1243: hr_utility.set_message(8301, 'GHR_38475_ERROR_LOG_FAILURE');
1244: hr_utility.raise_error;
1245: end;
1246: when others then
1247: HR_UTILITY.SET_LOCATION('Error (Others) occurred in '||l_proc||' Sql error '||sqlerrm(sqlcode),20);
1248: BEGIN
1243: hr_utility.set_message(8301, 'GHR_38475_ERROR_LOG_FAILURE');
1244: hr_utility.raise_error;
1245: end;
1246: when others then
1247: HR_UTILITY.SET_LOCATION('Error (Others) occurred in '||l_proc||' Sql error '||sqlerrm(sqlcode),20);
1248: BEGIN
1249: ROLLBACK TO EXECUTE_MSL_SP;
1250: EXCEPTION
1251: WHEN OTHERS THEN NULL;
1253: l_log_text := 'Error (others) in '||l_proc||
1254: ' For Mass Salary Name : '||p_mass_salary||
1255: 'Name: '|| p_full_name || ' SSN: ' || p_national_identifier ||
1256: ' Sql Err is '||sqlerrm(sqlcode);
1257: hr_utility.set_location('before creating entry in log file',20);
1258: l_recs_failed := l_recs_failed + 1;
1259: begin
1260: ghr_mto_int.log_message(
1261: p_procedure => g_proc,
1261: p_procedure => g_proc,
1262: p_message => l_log_text);
1263: exception
1264: when others then
1265: hr_utility.set_message(8301, 'Create Error Log failed');
1266: hr_utility.raise_error;
1267: end;
1268: END;
1269:
1262: p_message => l_log_text);
1263: exception
1264: when others then
1265: hr_utility.set_message(8301, 'Create Error Log failed');
1266: hr_utility.raise_error;
1267: end;
1268: END;
1269:
1270: --
1273: --
1274: --
1275: BEGIN
1276: g_proc := 'execute_msl';
1277: hr_utility.set_location('Entering ' || l_proc,5);
1278:
1279: g_first_noa_code := null;
1280: p_retcode := 0;
1281: BEGIN
1302: exit;
1303: END LOOP;
1304: EXCEPTION
1305: when REC_BUSY then
1306: hr_utility.set_location('Mass Salary is in use',1);
1307: l_mslerrbuf := 'Error in '||l_proc||' Sql Err is '|| sqlerrm(sqlcode);
1308: -- raise error;
1309: hr_utility.set_message(8301, 'GHR_38477_LOCK_ON_MSL');
1310: hr_utility.raise_error;
1305: when REC_BUSY then
1306: hr_utility.set_location('Mass Salary is in use',1);
1307: l_mslerrbuf := 'Error in '||l_proc||' Sql Err is '|| sqlerrm(sqlcode);
1308: -- raise error;
1309: hr_utility.set_message(8301, 'GHR_38477_LOCK_ON_MSL');
1310: hr_utility.raise_error;
1311: --
1312: when others then
1313: hr_utility.set_location('Error in '||l_proc||' Sql err is '||sqlerrm(sqlcode),1);
1306: hr_utility.set_location('Mass Salary is in use',1);
1307: l_mslerrbuf := 'Error in '||l_proc||' Sql Err is '|| sqlerrm(sqlcode);
1308: -- raise error;
1309: hr_utility.set_message(8301, 'GHR_38477_LOCK_ON_MSL');
1310: hr_utility.raise_error;
1311: --
1312: when others then
1313: hr_utility.set_location('Error in '||l_proc||' Sql err is '||sqlerrm(sqlcode),1);
1314: -- raise_application_error(-20111,'Error while selecting from Ghr Mass Salaries');
1309: hr_utility.set_message(8301, 'GHR_38477_LOCK_ON_MSL');
1310: hr_utility.raise_error;
1311: --
1312: when others then
1313: hr_utility.set_location('Error in '||l_proc||' Sql err is '||sqlerrm(sqlcode),1);
1314: -- raise_application_error(-20111,'Error while selecting from Ghr Mass Salaries');
1315: l_mslerrbuf := 'Error in '||l_proc||' Sql Err is '|| sqlerrm(sqlcode);
1316: raise msl_error;
1317: END;
1323: END LOOP;
1324:
1325: IF l_process_type = 'P' THEN
1326:
1327: hr_utility.set_location('befo perc' || l_proc,5);
1328: execute_msl_perc( p_errbuf,
1329: p_retcode,
1330: p_mass_salary_id,
1331: p_action );
1344: p_mass_salary_id,
1345: p_action );
1346:
1347: ELSIF l_process_type = 'R' THEN
1348: hr_utility.set_location('befo proc' || l_proc,5);
1349: execute_msl_ses_range( p_errbuf,
1350: p_retcode,
1351: p_mass_salary_id,
1352: p_action);
1372: END IF;
1373:
1374: get_lac_dtls(l_pa_request_id, l_lac_sf52_rec);
1375:
1376: hr_utility.set_location('After fetch msl '||to_char(l_effective_date)||' '||to_char(l_user_table_id),20);
1377: IF l_p_ORGANIZATION_ID is not null then
1378: FOR per IN cur_people_org (l_effective_date,l_p_ORGANIZATION_ID)
1379: LOOP
1380:
1406: l_step_or_rate := NULL;
1407: l_pay_basis := NULL;
1408: l_elig_flag := FALSE;
1409: --
1410: hr_utility.set_location('SSN: '||per.national_identifier,1000);
1411: BEGIN
1412: fetch_and_validate_emp(
1413: p_action => p_action
1414: ,p_mass_salary_id => p_mass_salary_id
1527: l_step_or_rate := NULL;
1528: l_pay_basis := NULL;
1529: l_elig_flag := FALSE;
1530: --
1531: hr_utility.set_location('SSN: '||per.national_identifier,2000);
1532: BEGIN
1533: fetch_and_validate_emp(
1534: p_action => p_action
1535: ,p_mass_salary_id => p_mass_salary_id
1627: SET submit_flag = 'P'
1628: WHERE rowid = l_rowid;
1629: EXCEPTION
1630: WHEN others THEN
1631: HR_UTILITY.SET_LOCATION('Error in Update ghr_msl Sql error '||sqlerrm(sqlcode),30);
1632: hr_utility.set_message(8301, 'GHR_38476_UPD_GHR_MSL_FAILURE');
1633: hr_utility.raise_error;
1634: END;
1635: END IF;
1628: WHERE rowid = l_rowid;
1629: EXCEPTION
1630: WHEN others THEN
1631: HR_UTILITY.SET_LOCATION('Error in Update ghr_msl Sql error '||sqlerrm(sqlcode),30);
1632: hr_utility.set_message(8301, 'GHR_38476_UPD_GHR_MSL_FAILURE');
1633: hr_utility.raise_error;
1634: END;
1635: END IF;
1636: ELSE
1629: EXCEPTION
1630: WHEN others THEN
1631: HR_UTILITY.SET_LOCATION('Error in Update ghr_msl Sql error '||sqlerrm(sqlcode),30);
1632: hr_utility.set_message(8301, 'GHR_38476_UPD_GHR_MSL_FAILURE');
1633: hr_utility.raise_error;
1634: END;
1635: END IF;
1636: ELSE
1637: p_errbuf := 'Error in '||l_proc || ' Details in GHR_PROCESS_LOG';
1649: END IF;
1650:
1651: EXCEPTION
1652: when others then
1653: HR_UTILITY.SET_LOCATION('Error (Others2) occurred in '||l_proc||' Sql error '||sqlerrm(sqlcode),30);
1654: BEGIN
1655: ROLLBACK TO EXECUTE_MSL_SP;
1656: EXCEPTION
1657: WHEN OTHERS THEN NULL;
1659: l_log_text := 'Error in '||l_proc||
1660: ' For Mass Salary Name : '||p_mass_salary||
1661: ' Sql Err is '||sqlerrm(sqlcode);
1662: l_recs_failed := l_recs_failed + 1;
1663: hr_utility.set_location('before creating entry in log file',30);
1664:
1665: p_errbuf := 'Error in '||l_proc || ' Details in GHR_PROCESS_LOG';
1666: p_retcode := 2;
1667: IF upper(p_action) = 'CREATE' THEN
1676: p_procedure => g_proc,
1677: p_message => l_log_text);
1678: EXCEPTION
1679: WHEN others THEN
1680: hr_utility.set_message(8301, 'Create Error Log failed');
1681: hr_utility.raise_error;
1682: END;
1683:
1684:
1677: p_message => l_log_text);
1678: EXCEPTION
1679: WHEN others THEN
1680: hr_utility.set_message(8301, 'Create Error Log failed');
1681: hr_utility.raise_error;
1682: END;
1683:
1684:
1685: END EXECUTE_MSL;
1828:
1829: BEGIN
1830: g_proc := 'pop_dtls_from_pa_req';
1831:
1832: hr_utility.set_location('Entering ' || l_proc,5);
1833: FOR pa_req_rec in ghr_pa_req_cur
1834: LOOP
1835: -- To calculate percent increase from From Pay and To Pay if rpa_type = 'MPC'.
1836: IF pa_req_rec.rpa_type = 'MPC' THEN
1923: -- FWFA Changes
1924: );
1925: exit;
1926: END LOOP;
1927: hr_utility.set_location('Exiting ' || l_proc,10);
1928: exception
1929: when msl_error then raise;
1930: when others then
1931: hr_utility.set_location('Error in '||l_proc||' Err is '||sqlerrm(sqlcode),20);
1927: hr_utility.set_location('Exiting ' || l_proc,10);
1928: exception
1929: when msl_error then raise;
1930: when others then
1931: hr_utility.set_location('Error in '||l_proc||' Err is '||sqlerrm(sqlcode),20);
1932: l_mslerrbuf := 'Error in '||l_proc||' Sql Err is '|| sqlerrm(sqlcode);
1933: raise msl_error;
1934: end pop_dtls_from_pa_req;
1935:
1959:
1960: g_proc := 'check_select_flg_msl_perc';
1961: l_temp_increase_percent := p_increase_percent;
1962:
1963: hr_utility.set_location('Entering ' || l_proc,5);
1964:
1965: l_line := 5;
1966: get_extra_info_comments(p_person_id,p_effective_date,l_sel_flag,l_comments,p_mass_salary_id,l_increase_percent,l_ses_basic_pay); -- Added by Sundar 3843306
1967:
2013: exception
2014: when msl_error then raise;
2015: when others then
2016: p_increase_percent := l_temp_increase_percent ;
2017: hr_utility.set_location('Error in '||l_proc||' Err is '||sqlerrm(sqlcode),20);
2018: l_mslerrbuf := 'Error in '||l_proc||' @'||to_char(l_line)||' Sql Err is '|| sqlerrm(sqlcode);
2019: raise msl_error;
2020: end;
2021:
2041: begin
2042:
2043: g_proc := 'check_select_flg';
2044:
2045: hr_utility.set_location('Entering ' || l_proc,5);
2046:
2047: l_line := 5;
2048: get_extra_info_comments(p_person_id,p_effective_date,l_sel_flag,l_comments,p_mass_salary_id,l_temp,l_ses_basic_pay);
2049:
2083: end if;
2084: exception
2085: when msl_error then raise;
2086: when others then
2087: hr_utility.set_location('Error in '||l_proc||' Err is '||sqlerrm(sqlcode),20);
2088: l_mslerrbuf := 'Error in '||l_proc||' @'||to_char(l_line)||' Sql Err is '|| sqlerrm(sqlcode);
2089: raise msl_error;
2090: end;
2091:
2099: l_proc varchar2(72) := g_package || '.purge_old_data';
2100: BEGIN
2101: g_proc := 'purge_old_data';
2102:
2103: hr_utility.set_location('Entering ' || l_proc,5);
2104: delete from ghr_mass_actions_preview
2105: where mass_action_type = 'SALARY'
2106: and session_id = p_mass_salary_id;
2107: commit;
2104: delete from ghr_mass_actions_preview
2105: where mass_action_type = 'SALARY'
2106: and session_id = p_mass_salary_id;
2107: commit;
2108: hr_utility.set_location('Exiting ' || l_proc,10);
2109: exception
2110: when msl_error then raise;
2111: when others then
2112: hr_utility.set_location('Error in '||l_proc||' Err is '||sqlerrm(sqlcode),20);
2108: hr_utility.set_location('Exiting ' || l_proc,10);
2109: exception
2110: when msl_error then raise;
2111: when others then
2112: hr_utility.set_location('Error in '||l_proc||' Err is '||sqlerrm(sqlcode),20);
2113: l_mslerrbuf := 'Error in '||l_proc||' Sql Err is '|| sqlerrm(sqlcode);
2114: raise msl_error;
2115: END;
2116:
2150: l_line number := 0;
2151: l_check_grade_retention VARCHAR2(200);
2152: BEGIN
2153: g_proc := 'get_pay_plan_and_table_id';
2154: hr_utility.set_location('Entering ' || l_proc,5);
2155: ghr_mre_pkg.pr('Entering ',l_proc,'ACTION '||p_action);
2156: -- Bug# 4126137,4179270,4086677
2157: l_check_grade_retention := CHECK_GRADE_RETENTION(P_PRD,P_PERSON_ID,P_EFFECTIVE_DATE);
2158:
2166: exit;
2167: end loop;
2168:
2169: l_line := 20;
2170: hr_utility.set_location('Got grade or level and pay plan',2);
2171: ghr_mre_pkg.pr('Got grade or level and pay plan');
2172:
2173: ghr_history_fetch.fetch_positionei
2174: (p_position_id => p_position_id
2193: l_line := 40;
2194: p_step_or_rate := l_asg_ei_data.aei_information3;
2195:
2196: ELSIF l_check_grade_retention = 'REGULAR' THEN
2197: hr_utility.set_location('Grade retention is regular',1);
2198:
2199: ghr_mre_pkg.pr('Grade retention is regular',1);
2200:
2201: FOR c_grade_kff_rec IN c_grade_kff (p_grade_id)
2204: p_grade_or_level := c_grade_kff_rec.segment2;
2205: exit;
2206: end loop;
2207:
2208: hr_utility.set_location('Got grade or level and pay plan',2);
2209:
2210: ghr_mre_pkg.pr('Got grade or level and pay plan',2);
2211:
2212: l_line := 50;
2236: ELSIF l_check_grade_retention = 'RETAIN' THEN
2237: --
2238: -- get retained details
2239: --
2240: hr_utility.set_location('Before get retained grade',4);
2241:
2242: l_line := 80;
2243: ghr_mre_pkg.pr('Retained prd ',P_PRD);
2244:
2273: END;
2274: l_line := 90;
2275: -- Bug#4179270,4126137,4086677 Added the following ELSIF Condition.
2276: ELSIF l_check_grade_retention ='MSL_ERROR' THEN
2277: hr_utility.set_message(8301,'GHR_38927_MISSING_MA_RET_DET');
2278: raise msl_error;
2279: ELSIF l_check_grade_retention = 'OTHER_ERROR' THEN
2280: l_mslerrbuf := 'Others error in check_grade_retention function while fetching retained grade record. Please
2281: verify the retained grade record';
2280: l_mslerrbuf := 'Others error in check_grade_retention function while fetching retained grade record. Please
2281: verify the retained grade record';
2282: raise msl_error;
2283: END IF;
2284: hr_utility.set_location('Exiting ' || l_proc,10);
2285: l_line := 100;
2286: EXCEPTION
2287: when msl_error then raise;
2288: when others then
2329: l_line number := 0;
2330: l_check_grade_retention VARCHAR2(200);
2331: BEGIN
2332: g_proc := 'get_pay_plan_and_table_id';
2333: hr_utility.set_location('Entering ' || l_proc,5);
2334: ghr_mre_pkg.pr('Entering ',l_proc,'ACTION '||p_action);
2335: -- Bug# 4126137,4179270,4086677
2336: l_check_grade_retention := CHECK_GRADE_RETENTION(P_PRD,P_PERSON_ID,P_EFFECTIVE_DATE);
2337:
2345: exit;
2346: end loop;
2347:
2348: l_line := 20;
2349: hr_utility.set_location('Got grade or level and pay plan',2);
2350: ghr_mre_pkg.pr('Got grade or level and pay plan');
2351:
2352: ghr_history_fetch.fetch_positionei
2353: (p_position_id => p_position_id
2386: l_line := 40;
2387: p_step_or_rate := l_asg_ei_data.aei_information3;
2388:
2389: ELSIF l_check_grade_retention = 'REGULAR' THEN
2390: hr_utility.set_location('Grade retention is regular',1);
2391:
2392: ghr_mre_pkg.pr('Grade retention is regular',1);
2393:
2394: FOR c_grade_kff_rec IN c_grade_kff (p_grade_id)
2397: p_grade_or_level := c_grade_kff_rec.segment2;
2398: exit;
2399: end loop;
2400:
2401: hr_utility.set_location('Got grade or level and pay plan',2);
2402:
2403: ghr_mre_pkg.pr('Got grade or level and pay plan',2);
2404:
2405: l_line := 50;
2441: ELSIF l_check_grade_retention = 'RETAIN' THEN
2442: --
2443: -- get retained details
2444: --
2445: hr_utility.set_location('Before get retained grade',4);
2446:
2447: l_line := 80;
2448: ghr_mre_pkg.pr('Retained prd ',P_PRD);
2449:
2487: END LOOP;
2488: l_line := 90;
2489: -- Bug#4179270,4126137,4086677 Added the following ELSIF Condition.
2490: ELSIF l_check_grade_retention ='MSL_ERROR' THEN
2491: hr_utility.set_message(8301,'GHR_38927_MISSING_MA_RET_DET');
2492: raise msl_error;
2493: ELSIF l_check_grade_retention = 'OTHER_ERROR' THEN
2494: l_mslerrbuf := 'Others error in check_grade_retention function while fetching retained grade record. Please
2495: verify the retained grade record';
2494: l_mslerrbuf := 'Others error in check_grade_retention function while fetching retained grade record. Please
2495: verify the retained grade record';
2496: raise msl_error;
2497: END IF;
2498: hr_utility.set_location('Exiting ' || l_proc,10);
2499: l_line := 100;
2500: EXCEPTION
2501: when msl_error then raise;
2502: when others then
2514: l_proc varchar2(72) := g_package || '.update_sel_flg';
2515: l_ind number := 1;
2516: begin
2517: g_proc := 'update_sel_flg';
2518: hr_utility.set_location('Entering ' || l_proc,5);
2519: pr('Inside '||l_proc,to_char(p_person_id));
2520: l_ind := 10;
2521: ghr_history_fetch.fetch_peopleei
2522: (p_person_id => p_person_id
2540: ,p_pei_information10 => NULL
2541: ,P_PEI_INFORMATION_CATEGORY => 'GHR_US_PER_MASS_ACTIONS');
2542:
2543: l_ind := 30;
2544: hr_utility.set_location('Exiting ' || l_proc,10);
2545: -- There is a trigger on PER_PEOPLE_EXTRA_INFO to make the employee INVALID
2546: -- when there is a update done on the table.
2547: ---Commented the following three lines to remove Validation functionality on Person.
2548: --- ghr_validate_perwsepi.validate_perwsepi(p_person_id);
2554: pr('Exiting '||l_proc,to_char(p_person_id));
2555: exception
2556: when msl_error then raise;
2557: when others then
2558: hr_utility.set_location('Error in '||l_proc||
2559: ' Err is '||sqlerrm(sqlcode),20);
2560: l_mslerrbuf := 'Error in '||l_proc||' at '||to_char(l_ind)||
2561: ' Sql Err is '|| sqlerrm(sqlcode);
2562: raise msl_error;
2637: group by information11);
2638:
2639: begin
2640: g_proc := 'get_extra_info_comments';
2641: hr_utility.set_location('Entering ' || l_proc,5);
2642:
2643: l_eff_date := p_effective_date;
2644:
2645: ghr_history_fetch.fetch_peopleei
2680: when msl_error then
2681: p_increase_percent := NULL;
2682: raise;
2683: when others then
2684: hr_utility.set_location('Error in '||l_proc||' Err is '||sqlerrm(sqlcode),20);
2685: l_mslerrbuf := 'Error in '||l_proc||' Sql Err is '|| sqlerrm(sqlcode);
2686: p_increase_percent := NULL;
2687: p_ses_basic_pay := NULL;
2688: raise msl_error;
2716: l_eff_date date;
2717:
2718: begin
2719: g_proc := 'ins_upd_per_extra_info';
2720: hr_utility.set_location('Entering ' || l_proc,5);
2721: if p_effective_date > sysdate then
2722: l_eff_date := sysdate;
2723: else
2724: l_eff_date := p_effective_date;
2768: ---Commented the following two lines to remove Validation functionality on Person.
2769: -- ghr_validate_perwsepi.validate_perwsepi(p_person_id);
2770: -- ghr_validate_perwsepi.update_person_user_type(p_person_id);
2771:
2772: hr_utility.set_location('Exiting ' || l_proc,10);
2773: exception
2774: when msl_error then raise;
2775: when others then
2776: pr('Error in '||l_proc);
2773: exception
2774: when msl_error then raise;
2775: when others then
2776: pr('Error in '||l_proc);
2777: hr_utility.set_location('Error in '||l_proc||' Err is '||sqlerrm(sqlcode),20);
2778: l_mslerrbuf := 'Error in '||l_proc||' Sql Err is '|| sqlerrm(sqlcode);
2779: raise msl_error;
2780: end ins_upd_per_extra_info;
2781:
2880:
2881: BEGIN
2882:
2883: g_proc := 'fetch_and_validate_emp';
2884: hr_utility.set_location('Entering ' || l_proc,5);
2885: -- Bug#5623035 Moved the local variable assigning to here.
2886: l_assignment_id := p_assignment_id;
2887: l_position_id := p_position_id;
2888: l_grade_id := p_grade_id;
2897: p_msl_agency_code_subelement IS NOT NULL THEN
2898: -- get the values and verify whether the record meets the condition or not.
2899: -- If Yes, proceed further. Otherwise, skip the other checks for this record
2900:
2901: hr_utility.set_location('The location id is:'||l_location_id,12345);
2902: hr_utility.set_location('MSL Org ID:'||p_msl_organization_id,11111);
2903: hr_utility.set_location('Org ID:'||p_organization_id,22222);
2904: IF NVL(p_msl_organization_id,p_organization_id) = p_organization_id THEN
2905: hr_utility.set_location('Org ID PASS',10);
2898: -- get the values and verify whether the record meets the condition or not.
2899: -- If Yes, proceed further. Otherwise, skip the other checks for this record
2900:
2901: hr_utility.set_location('The location id is:'||l_location_id,12345);
2902: hr_utility.set_location('MSL Org ID:'||p_msl_organization_id,11111);
2903: hr_utility.set_location('Org ID:'||p_organization_id,22222);
2904: IF NVL(p_msl_organization_id,p_organization_id) = p_organization_id THEN
2905: hr_utility.set_location('Org ID PASS',10);
2906: IF p_msl_personnel_office_id IS NOT NULL THEN
2899: -- If Yes, proceed further. Otherwise, skip the other checks for this record
2900:
2901: hr_utility.set_location('The location id is:'||l_location_id,12345);
2902: hr_utility.set_location('MSL Org ID:'||p_msl_organization_id,11111);
2903: hr_utility.set_location('Org ID:'||p_organization_id,22222);
2904: IF NVL(p_msl_organization_id,p_organization_id) = p_organization_id THEN
2905: hr_utility.set_location('Org ID PASS',10);
2906: IF p_msl_personnel_office_id IS NOT NULL THEN
2907: hr_utility.set_location('POID CHECK',15);
2901: hr_utility.set_location('The location id is:'||l_location_id,12345);
2902: hr_utility.set_location('MSL Org ID:'||p_msl_organization_id,11111);
2903: hr_utility.set_location('Org ID:'||p_organization_id,22222);
2904: IF NVL(p_msl_organization_id,p_organization_id) = p_organization_id THEN
2905: hr_utility.set_location('Org ID PASS',10);
2906: IF p_msl_personnel_office_id IS NOT NULL THEN
2907: hr_utility.set_location('POID CHECK',15);
2908: get_pos_grp1_ddf(l_position_id,
2909: l_effective_date,
2903: hr_utility.set_location('Org ID:'||p_organization_id,22222);
2904: IF NVL(p_msl_organization_id,p_organization_id) = p_organization_id THEN
2905: hr_utility.set_location('Org ID PASS',10);
2906: IF p_msl_personnel_office_id IS NOT NULL THEN
2907: hr_utility.set_location('POID CHECK',15);
2908: get_pos_grp1_ddf(l_position_id,
2909: l_effective_date,
2910: l_pos_grp1_rec);
2911:
2914: l_fetch_poid_data := TRUE;
2915: END IF;
2916: IF (p_msl_personnel_office_id = l_personnel_office_id) OR
2917: NOT(l_fetch_poid_data) THEN
2918: hr_utility.set_location('POID PASS',20);
2919: IF p_msl_agency_code_subelement IS NOT NULL THEN
2920: hr_utility.set_location('Agency CHECK',25);
2921: get_sub_element_code_pos_title(l_position_id,
2922: p_person_id,
2916: IF (p_msl_personnel_office_id = l_personnel_office_id) OR
2917: NOT(l_fetch_poid_data) THEN
2918: hr_utility.set_location('POID PASS',20);
2919: IF p_msl_agency_code_subelement IS NOT NULL THEN
2920: hr_utility.set_location('Agency CHECK',25);
2921: get_sub_element_code_pos_title(l_position_id,
2922: p_person_id,
2923: l_business_group_id,
2924: l_assignment_id,
2934: NVL(SUBSTR(p_msl_agency_code_subelement,3,2),SUBSTR(l_sub_element_code,3,2))=
2935: SUBSTR(l_sub_element_code,3,2)
2936: ) OR
2937: NOT(l_fetch_agency_data) THEN
2938: hr_utility.set_location('Agency PASS',30);
2939: IF p_msl_duty_station_id IS NOT NULL THEN
2940: hr_utility.set_location('DS CHECK',35);
2941: ghr_pa_requests_pkg.get_SF52_loc_ddf_details
2942: (p_location_id => l_location_id
2936: ) OR
2937: NOT(l_fetch_agency_data) THEN
2938: hr_utility.set_location('Agency PASS',30);
2939: IF p_msl_duty_station_id IS NOT NULL THEN
2940: hr_utility.set_location('DS CHECK',35);
2941: ghr_pa_requests_pkg.get_SF52_loc_ddf_details
2942: (p_location_id => l_location_id
2943: ,p_duty_station_id => l_duty_station_id);
2944: l_fetch_ds_data := TRUE;
2944: l_fetch_ds_data := TRUE;
2945: END IF;
2946: IF (p_msl_duty_station_id = l_duty_station_id) OR
2947: NOT(l_fetch_ds_data)THEN
2948: hr_utility.set_location('DS PASS',40);
2949: init_elig_flag := TRUE;
2950: ELSE -- Duty Station not matching.
2951: hr_utility.set_location('DS FAIL',45);
2952: init_elig_flag := FALSE;
2947: NOT(l_fetch_ds_data)THEN
2948: hr_utility.set_location('DS PASS',40);
2949: init_elig_flag := TRUE;
2950: ELSE -- Duty Station not matching.
2951: hr_utility.set_location('DS FAIL',45);
2952: init_elig_flag := FALSE;
2953: END IF;
2954: ELSE -- Agency Code Subelement Not matching.
2955: hr_utility.set_location('Agency FAIL',55);
2951: hr_utility.set_location('DS FAIL',45);
2952: init_elig_flag := FALSE;
2953: END IF;
2954: ELSE -- Agency Code Subelement Not matching.
2955: hr_utility.set_location('Agency FAIL',55);
2956: init_elig_flag := FALSE;
2957: END IF;
2958: ELSE -- Personnel Office ID not matching
2959: hr_utility.set_location('POID FAIL',65);
2955: hr_utility.set_location('Agency FAIL',55);
2956: init_elig_flag := FALSE;
2957: END IF;
2958: ELSE -- Personnel Office ID not matching
2959: hr_utility.set_location('POID FAIL',65);
2960: init_elig_flag := FALSE;
2961: END IF;
2962: ELSE -- Organization_id is not matching.
2963: hr_utility.set_location('Org FAIL',75);
2959: hr_utility.set_location('POID FAIL',65);
2960: init_elig_flag := FALSE;
2961: END IF;
2962: ELSE -- Organization_id is not matching.
2963: hr_utility.set_location('Org FAIL',75);
2964: init_elig_flag := FALSE;
2965: END IF;
2966: ELSE -- If No value is entered for organization, Duty Station, Agency, POID of MSL Criteria.
2967: hr_utility.set_location('No INIT CRITERIA',85);
2963: hr_utility.set_location('Org FAIL',75);
2964: init_elig_flag := FALSE;
2965: END IF;
2966: ELSE -- If No value is entered for organization, Duty Station, Agency, POID of MSL Criteria.
2967: hr_utility.set_location('No INIT CRITERIA',85);
2968: init_elig_flag := TRUE;
2969: END IF;
2970:
2971: -- If the initial eligibility is passed then proceed further. Otherwise move to next record.
2969: END IF;
2970:
2971: -- If the initial eligibility is passed then proceed further. Otherwise move to next record.
2972: IF init_elig_flag THEN
2973: hr_utility.set_location('Init Criteria Pass',95);
2974: ghr_pa_requests_pkg.get_sf52_asg_ddf_details
2975: (l_assignment_id,
2976: l_effective_date,
2977: l_tenure,
2981: l_part_time_hour);
2982:
2983: FOR l_cnt in 1..p_rec_pp_prd.COUNT LOOP
2984: IF nvl(p_rec_pp_prd(l_cnt).prd,l_pay_rate_determinant) = l_pay_rate_determinant THEN
2985: hr_utility.set_location('PRD PASS',105);
2986: l_prd_matched := TRUE;
2987: exit;
2988: END IF;
2989: END LOOP;
3002: EXCEPTION
3003: WHEN OTHERS THEN
3004: -- Report the record in the process log if the pay table ID matches.
3005: BEGIN
3006: hr_utility.set_location('before calling expired_rg_det',10);
3007: l_retained_grade_rec := ghr_pc_basic_pay.get_expired_rg_details
3008: (p_person_id => p_person_id
3009: ,p_effective_date => l_effective_date);
3010: hr_utility.set_location('ret grd tableid:'||l_retained_grade_rec.user_table_id,99999);
3006: hr_utility.set_location('before calling expired_rg_det',10);
3007: l_retained_grade_rec := ghr_pc_basic_pay.get_expired_rg_details
3008: (p_person_id => p_person_id
3009: ,p_effective_date => l_effective_date);
3010: hr_utility.set_location('ret grd tableid:'||l_retained_grade_rec.user_table_id,99999);
3011: hr_utility.set_location('MSL tableid:'||p_msl_user_table_id,99999);
3012: IF l_retained_grade_rec.user_table_id = p_msl_user_table_id THEN
3013: hr_utility.set_location('Rg table matches with MSL table ID',10);
3014: l_log_text := 'Error in RG Record In Mass Salary Name: '||
3007: l_retained_grade_rec := ghr_pc_basic_pay.get_expired_rg_details
3008: (p_person_id => p_person_id
3009: ,p_effective_date => l_effective_date);
3010: hr_utility.set_location('ret grd tableid:'||l_retained_grade_rec.user_table_id,99999);
3011: hr_utility.set_location('MSL tableid:'||p_msl_user_table_id,99999);
3012: IF l_retained_grade_rec.user_table_id = p_msl_user_table_id THEN
3013: hr_utility.set_location('Rg table matches with MSL table ID',10);
3014: l_log_text := 'Error in RG Record In Mass Salary Name: '||
3015: p_mass_salary_name||'; Employee Name: '|| p_full_name ||
3009: ,p_effective_date => l_effective_date);
3010: hr_utility.set_location('ret grd tableid:'||l_retained_grade_rec.user_table_id,99999);
3011: hr_utility.set_location('MSL tableid:'||p_msl_user_table_id,99999);
3012: IF l_retained_grade_rec.user_table_id = p_msl_user_table_id THEN
3013: hr_utility.set_location('Rg table matches with MSL table ID',10);
3014: l_log_text := 'Error in RG Record In Mass Salary Name: '||
3015: p_mass_salary_name||'; Employee Name: '|| p_full_name ||
3016: '; SSN: ' || p_national_identifier || '; '||
3017: hr_utility.get_message;
3013: hr_utility.set_location('Rg table matches with MSL table ID',10);
3014: l_log_text := 'Error in RG Record In Mass Salary Name: '||
3015: p_mass_salary_name||'; Employee Name: '|| p_full_name ||
3016: '; SSN: ' || p_national_identifier || '; '||
3017: hr_utility.get_message;
3018: BEGIN
3019: ghr_mto_int.log_message(
3020: p_procedure => 'check_grade_retention',
3021: p_message => l_log_text);
3028: l_prd_pp_matched := FALSE;
3029: END IF;
3030: EXCEPTION
3031: WHEN OTHERS THEN
3032: hr_utility.set_location('WHEN OTHERS of EXPIRED RG ',999999);
3033: l_prd_pp_matched := FALSE;
3034: END;
3035: --WHEN OTHERS THEN
3036: -- Skip this record from reporting.
3040:
3041: FOR l_cnt in 1..p_rec_pp_prd.COUNT LOOP
3042: IF nvl(p_rec_pp_prd(l_cnt).prd,l_pay_rate_determinant) = l_pay_rate_determinant AND
3043: nvl(p_rec_pp_prd(l_cnt).pay_plan,l_pay_plan) = l_pay_plan THEN
3044: hr_utility.set_location('PP/PRD PASS',115);
3045: l_prd_pp_matched := TRUE;
3046: exit;
3047: END IF;
3048: END LOOP;
3048: END LOOP;
3049:
3050: IF l_prd_pp_matched THEN
3051: IF l_pay_table_id = p_msl_user_table_id THEN
3052: hr_utility.set_location('Table ID PASS',125);
3053: IF NOT (p_action = 'CREATE' AND
3054: person_in_pa_req_1noa
3055: (p_person_id => p_person_id,
3056: p_effective_date => l_effective_date,
3066: END IF;
3067: END LOOP;
3068:
3069: IF l_row_cnt <> 0 THEN
3070: hr_utility.set_location('ROW COUNT PASS',135);
3071: -- Get the required details if the related check has not been done above.
3072: IF NOT l_fetch_poid_data THEN
3073:
3074: get_pos_grp1_ddf(l_position_id,
3122: -- Raise Error
3123: NULL;
3124: END IF;
3125: ELSE -- Not (Create and RPA exists)
3126: hr_utility.set_location('ROW COUNT FAIL',145);
3127: p_elig_flag := FALSE;
3128: END IF;
3129: ELSE -- Pay table id is not matched
3130: hr_utility.set_location('Pay Table FAIL',155);
3126: hr_utility.set_location('ROW COUNT FAIL',145);
3127: p_elig_flag := FALSE;
3128: END IF;
3129: ELSE -- Pay table id is not matched
3130: hr_utility.set_location('Pay Table FAIL',155);
3131: p_elig_flag := FALSE;
3132: END IF;
3133: ELSE -- Pay Plan and PRD not matched
3134: hr_utility.set_location('PP/PRD FAIL',165);
3130: hr_utility.set_location('Pay Table FAIL',155);
3131: p_elig_flag := FALSE;
3132: END IF;
3133: ELSE -- Pay Plan and PRD not matched
3134: hr_utility.set_location('PP/PRD FAIL',165);
3135: p_elig_flag := FALSE;
3136: END IF;
3137: ELSE
3138: hr_utility.set_location('PP FAIL',175);
3134: hr_utility.set_location('PP/PRD FAIL',165);
3135: p_elig_flag := FALSE;
3136: END IF;
3137: ELSE
3138: hr_utility.set_location('PP FAIL',175);
3139: p_elig_flag := FALSE;
3140: END IF;
3141: EXCEPTION
3142: WHEN others THEN
3139: p_elig_flag := FALSE;
3140: END IF;
3141: EXCEPTION
3142: WHEN others THEN
3143: hr_utility.set_location('WHEN OTHERS',185);
3144: RAISE;
3145: END fetch_and_validate_emp;
3146: --
3147: --
3237:
3238: BEGIN
3239:
3240: g_proc := 'fetch_and_validate_emp_perc';
3241: hr_utility.set_location('Entering ' || l_proc,5);
3242: -- Bug#5623035 Moved the local variable declaratio to here.
3243: l_assignment_id := p_assignment_id;
3244: l_position_id := p_position_id;
3245: l_grade_id := p_grade_id;
3253: p_msl_agency_code_subelement IS NOT NULL THEN
3254: -- get the values and verify whether the record meets the condition or not.
3255: -- If Yes, proceed further. Otherwise, skip the other checks for this record
3256:
3257: hr_utility.set_location('The location id is:'||l_location_id,12345);
3258: hr_utility.set_location('MSL Org ID:'||p_msl_organization_id,11111);
3259: hr_utility.set_location('Org ID:'||p_organization_id,22222);
3260: IF NVL(p_msl_organization_id,p_organization_id) = p_organization_id THEN
3261: hr_utility.set_location('Org ID PASS',10);
3254: -- get the values and verify whether the record meets the condition or not.
3255: -- If Yes, proceed further. Otherwise, skip the other checks for this record
3256:
3257: hr_utility.set_location('The location id is:'||l_location_id,12345);
3258: hr_utility.set_location('MSL Org ID:'||p_msl_organization_id,11111);
3259: hr_utility.set_location('Org ID:'||p_organization_id,22222);
3260: IF NVL(p_msl_organization_id,p_organization_id) = p_organization_id THEN
3261: hr_utility.set_location('Org ID PASS',10);
3262: IF p_msl_personnel_office_id IS NOT NULL THEN
3255: -- If Yes, proceed further. Otherwise, skip the other checks for this record
3256:
3257: hr_utility.set_location('The location id is:'||l_location_id,12345);
3258: hr_utility.set_location('MSL Org ID:'||p_msl_organization_id,11111);
3259: hr_utility.set_location('Org ID:'||p_organization_id,22222);
3260: IF NVL(p_msl_organization_id,p_organization_id) = p_organization_id THEN
3261: hr_utility.set_location('Org ID PASS',10);
3262: IF p_msl_personnel_office_id IS NOT NULL THEN
3263: hr_utility.set_location('POID CHECK',15);
3257: hr_utility.set_location('The location id is:'||l_location_id,12345);
3258: hr_utility.set_location('MSL Org ID:'||p_msl_organization_id,11111);
3259: hr_utility.set_location('Org ID:'||p_organization_id,22222);
3260: IF NVL(p_msl_organization_id,p_organization_id) = p_organization_id THEN
3261: hr_utility.set_location('Org ID PASS',10);
3262: IF p_msl_personnel_office_id IS NOT NULL THEN
3263: hr_utility.set_location('POID CHECK',15);
3264: get_pos_grp1_ddf(l_position_id,
3265: l_effective_date,
3259: hr_utility.set_location('Org ID:'||p_organization_id,22222);
3260: IF NVL(p_msl_organization_id,p_organization_id) = p_organization_id THEN
3261: hr_utility.set_location('Org ID PASS',10);
3262: IF p_msl_personnel_office_id IS NOT NULL THEN
3263: hr_utility.set_location('POID CHECK',15);
3264: get_pos_grp1_ddf(l_position_id,
3265: l_effective_date,
3266: l_pos_grp1_rec);
3267:
3270: l_fetch_poid_data := TRUE;
3271: END IF;
3272: IF (p_msl_personnel_office_id = l_personnel_office_id) OR
3273: NOT(l_fetch_poid_data) THEN
3274: hr_utility.set_location('POID PASS',20);
3275: IF p_msl_agency_code_subelement IS NOT NULL THEN
3276: hr_utility.set_location('Agency CHECK',25);
3277: get_sub_element_code_pos_title(l_position_id,
3278: p_person_id,
3272: IF (p_msl_personnel_office_id = l_personnel_office_id) OR
3273: NOT(l_fetch_poid_data) THEN
3274: hr_utility.set_location('POID PASS',20);
3275: IF p_msl_agency_code_subelement IS NOT NULL THEN
3276: hr_utility.set_location('Agency CHECK',25);
3277: get_sub_element_code_pos_title(l_position_id,
3278: p_person_id,
3279: l_business_group_id,
3280: l_assignment_id,
3290: NVL(SUBSTR(p_msl_agency_code_subelement,3,2),SUBSTR(l_sub_element_code,3,2))=
3291: SUBSTR(l_sub_element_code,3,2)
3292: ) OR
3293: NOT(l_fetch_agency_data) THEN
3294: hr_utility.set_location('Agency PASS',30);
3295: IF p_msl_duty_station_id IS NOT NULL THEN
3296: hr_utility.set_location('DS CHECK',35);
3297: ghr_pa_requests_pkg.get_SF52_loc_ddf_details
3298: (p_location_id => l_location_id
3292: ) OR
3293: NOT(l_fetch_agency_data) THEN
3294: hr_utility.set_location('Agency PASS',30);
3295: IF p_msl_duty_station_id IS NOT NULL THEN
3296: hr_utility.set_location('DS CHECK',35);
3297: ghr_pa_requests_pkg.get_SF52_loc_ddf_details
3298: (p_location_id => l_location_id
3299: ,p_duty_station_id => l_duty_station_id);
3300: l_fetch_ds_data := TRUE;
3300: l_fetch_ds_data := TRUE;
3301: END IF;
3302: IF (p_msl_duty_station_id = l_duty_station_id) OR
3303: NOT(l_fetch_ds_data)THEN
3304: hr_utility.set_location('DS PASS',40);
3305: init_elig_flag := TRUE;
3306: ELSE -- Duty Station not matching.
3307: hr_utility.set_location('DS FAIL',45);
3308: init_elig_flag := FALSE;
3303: NOT(l_fetch_ds_data)THEN
3304: hr_utility.set_location('DS PASS',40);
3305: init_elig_flag := TRUE;
3306: ELSE -- Duty Station not matching.
3307: hr_utility.set_location('DS FAIL',45);
3308: init_elig_flag := FALSE;
3309: END IF;
3310: ELSE -- Agency Code Subelement Not matching.
3311: hr_utility.set_location('Agency FAIL',55);
3307: hr_utility.set_location('DS FAIL',45);
3308: init_elig_flag := FALSE;
3309: END IF;
3310: ELSE -- Agency Code Subelement Not matching.
3311: hr_utility.set_location('Agency FAIL',55);
3312: init_elig_flag := FALSE;
3313: END IF;
3314: ELSE -- Personnel Office ID not matching
3315: hr_utility.set_location('POID FAIL',65);
3311: hr_utility.set_location('Agency FAIL',55);
3312: init_elig_flag := FALSE;
3313: END IF;
3314: ELSE -- Personnel Office ID not matching
3315: hr_utility.set_location('POID FAIL',65);
3316: init_elig_flag := FALSE;
3317: END IF;
3318: ELSE -- Organization_id is not matching.
3319: hr_utility.set_location('Org FAIL',75);
3315: hr_utility.set_location('POID FAIL',65);
3316: init_elig_flag := FALSE;
3317: END IF;
3318: ELSE -- Organization_id is not matching.
3319: hr_utility.set_location('Org FAIL',75);
3320: init_elig_flag := FALSE;
3321: END IF;
3322: ELSE -- If No value is entered for organization, Duty Station, Agency, POID of MSL Criteria.
3323: hr_utility.set_location('No INIT CRITERIA',85);
3319: hr_utility.set_location('Org FAIL',75);
3320: init_elig_flag := FALSE;
3321: END IF;
3322: ELSE -- If No value is entered for organization, Duty Station, Agency, POID of MSL Criteria.
3323: hr_utility.set_location('No INIT CRITERIA',85);
3324: init_elig_flag := TRUE;
3325: END IF;
3326:
3327: -- If the initial eligibility is passed then proceed further. Otherwise move to next record.
3325: END IF;
3326:
3327: -- If the initial eligibility is passed then proceed further. Otherwise move to next record.
3328: IF init_elig_flag THEN
3329: hr_utility.set_location('Init Criteria Pass',95);
3330: ghr_pa_requests_pkg.get_sf52_asg_ddf_details
3331: (l_assignment_id,
3332: l_effective_date,
3333: l_tenure,
3337: l_part_time_hour);
3338:
3339: FOR l_cnt in 1..p_rec_pp_prd_per_gr.COUNT LOOP
3340: IF nvl(p_rec_pp_prd_per_gr(l_cnt).prd,l_pay_rate_determinant) = l_pay_rate_determinant THEN
3341: hr_utility.set_location('PRD PASS',105);
3342: l_prd_matched := TRUE;
3343: exit;
3344: END IF;
3345: END LOOP;
3364:
3365: l_log_text := 'Error in RG Record In Mass Salary Name: '||
3366: p_mass_salary_name||'; Employee Name: '|| p_full_name ||
3367: '; SSN: ' || p_national_identifier || '; '||
3368: hr_utility.get_message;
3369: BEGIN
3370: ghr_mto_int.log_message(
3371: p_procedure => 'check_grade_retention',
3372: p_message => l_log_text);
3399: END LOOP;
3400:
3401: IF l_prd_pp_matched THEN
3402: IF l_pay_table_id = p_msl_user_table_id THEN
3403: hr_utility.set_location('Table ID PASS',125);
3404: IF NOT (p_action = 'CREATE' AND
3405: person_in_pa_req_1noa
3406: (p_person_id => p_person_id,
3407: p_effective_date => l_effective_date,
3416: END IF;
3417: END LOOP;
3418:
3419: IF l_row_cnt <> 0 THEN
3420: hr_utility.set_location('ROW COUNT PASS',135);
3421: -- Get the required details if the related check has not been done above.
3422: IF NOT l_fetch_poid_data THEN
3423:
3424: get_pos_grp1_ddf(l_position_id,
3470: -- Raise Error
3471: NULL;
3472: END IF;
3473: ELSE -- Not (Create and RPA exists)
3474: hr_utility.set_location('ROW COUNT FAIL',145);
3475: p_elig_flag := FALSE;
3476: END IF;
3477: ELSE -- Pay table id is not matched
3478: hr_utility.set_location('Pay Table FAIL',155);
3474: hr_utility.set_location('ROW COUNT FAIL',145);
3475: p_elig_flag := FALSE;
3476: END IF;
3477: ELSE -- Pay table id is not matched
3478: hr_utility.set_location('Pay Table FAIL',155);
3479: p_elig_flag := FALSE;
3480: END IF;
3481: ELSE -- Pay Plan and PRD not matched
3482: hr_utility.set_location('PP/PRD FAIL',165);
3478: hr_utility.set_location('Pay Table FAIL',155);
3479: p_elig_flag := FALSE;
3480: END IF;
3481: ELSE -- Pay Plan and PRD not matched
3482: hr_utility.set_location('PP/PRD FAIL',165);
3483: p_elig_flag := FALSE;
3484: END IF;
3485: ELSE
3486: hr_utility.set_location('PP FAIL',175);
3482: hr_utility.set_location('PP/PRD FAIL',165);
3483: p_elig_flag := FALSE;
3484: END IF;
3485: ELSE
3486: hr_utility.set_location('PP FAIL',175);
3487: p_elig_flag := FALSE;
3488: END IF;
3489: EXCEPTION
3490: WHEN others THEN
3487: p_elig_flag := FALSE;
3488: END IF;
3489: EXCEPTION
3490: WHEN others THEN
3491: hr_utility.set_location('WHEN OTHERS',185);
3492: RAISE;
3493: END fetch_and_validate_emp_perc;
3494: --
3495: --
3516: l_proc varchar2(72) := g_package || '.check_init_eligibility';
3517: BEGIN
3518:
3519: g_proc := 'check_init_eligibility';
3520: hr_utility.set_location('Entering ' || l_proc,5);
3521:
3522: if p_personnel_office_id is not null then
3523: if p_personnel_office_id <> nvl(p_l_personnel_office_id,'NULL!~') then
3524: return false;
3553: l_ds_end_date := rec_ds.end_Date;
3554: END LOOP;
3555:
3556: If l_ds_end_date IS NULL THEN
3557: hr_utility.set_location('Under DS null check'||p_l_duty_station_id,12345);
3558: raise msl_error;
3559: return false;
3560: end if;
3561: -- End of bug 3437354
3563: pr('Eligible');
3564: return true;
3565: exception
3566: when msl_error then --raise;
3567: hr_utility.set_location('Error NO DUTY STATION '||l_proc||' Err is '||sqlerrm(sqlcode),20);
3568: l_mslerrbuf :=
3569: 'Error - No valid Location found, salary cannot be correctly calculated without the employee''s duty location ';
3570: raise msl_error;
3571: when others then
3568: l_mslerrbuf :=
3569: 'Error - No valid Location found, salary cannot be correctly calculated without the employee''s duty location ';
3570: raise msl_error;
3571: when others then
3572: hr_utility.set_location('Error in '||l_proc||' Err is '||sqlerrm(sqlcode),20);
3573: l_mslerrbuf := 'Error in '||l_proc||' Sql Err is '|| sqlerrm(sqlcode);
3574: raise msl_error;
3575: END check_init_eligibility;
3576:
3595: l_row_cnt number := 0;
3596: l_proc varchar2(72) := g_package || '.check_eligibility';
3597: BEGIN
3598: g_proc := 'check_eligibility';
3599: hr_utility.set_location('Entering ' || l_proc,5);
3600: --return true;
3601:
3602: if p_user_table_id is null or p_pay_table_id is null then
3603: return false;
3659: return true;
3660: exception
3661: when msl_error then raise;
3662: when others then
3663: hr_utility.set_location('Error in '||l_proc||' Err is '||sqlerrm(sqlcode),20);
3664: l_mslerrbuf := 'Error in '||l_proc||' Sql Err is '|| sqlerrm(sqlcode);
3665: raise msl_error;
3666: END check_eligibility;
3667:
3727: l_eq_pay_plan ghr_pay_plans.equivalent_pay_plan%type;
3728:
3729: begin
3730: g_proc := 'person_in_pa_req_1noa';
3731: hr_utility.set_location('Entering ' || l_proc,5);
3732: -- Bug 1631952 start
3733: for csr_eq_pay_plan_rec in csr_eq_pay_plan loop
3734: l_eq_pay_plan := csr_eq_pay_plan_rec.equivalent_pay_plan;
3735: end loop;
3822: l_action_taken ghr_pa_routing_history.action_taken%TYPE;
3823: l_proc varchar2(72) := g_package || '.person_in_pa_req_2noa';
3824: begin
3825: g_proc := 'person_in_pa_req_2noa';
3826: hr_utility.set_location('Entering ' || l_proc,5);
3827: for v_action_taken in csr_action_taken loop
3828: for pa_hist_rec in pa_hist_cur (v_action_taken.pa_routing_history_id)
3829: loop
3830: l_action_taken := pa_hist_rec.action_taken;
3851: l_proc varchar2(72) := g_package || '.check_grade_retention';
3852:
3853: BEGIN
3854: g_proc := 'check_grade_retention';
3855: hr_utility.set_location('Entering ' || l_proc,5);
3856: IF p_prd in ('A','B','E','F','U','V') THEN
3857: IF p_prd in ('A','B','E','F') THEN
3858: -- Bug#4179270,4126137,4086677 Removed the History Fetch call.
3859: -- Note: Do not use fetch_peopleei to get Retained grade details as it
3897: --l_pos_ei_data per_position_extra_info%type;
3898:
3899: begin
3900: g_proc := 'get_pos_grp1_ddf';
3901: hr_utility.set_location('Entering ' || l_proc,5);
3902: ghr_history_fetch.fetch_positionei
3903: (p_position_id => p_position_id
3904: ,p_information_type => 'GHR_US_POS_GRP1'
3905: ,p_date_effective => p_effective_date
3904: ,p_information_type => 'GHR_US_POS_GRP1'
3905: ,p_date_effective => p_effective_date
3906: ,p_pos_ei_data => p_pos_ei_data
3907: );
3908: hr_utility.set_location('Exiting ' || l_proc,10);
3909: exception
3910: when msl_error then raise;
3911: when others then
3912: hr_utility.set_location('Error in '||l_proc||' Err is '||sqlerrm(sqlcode),20);
3908: hr_utility.set_location('Exiting ' || l_proc,10);
3909: exception
3910: when msl_error then raise;
3911: when others then
3912: hr_utility.set_location('Error in '||l_proc||' Err is '||sqlerrm(sqlcode),20);
3913: l_mslerrbuf := 'Error in '||l_proc||' Sql Err is '|| sqlerrm(sqlcode);
3914: raise msl_error;
3915: END get_pos_grp1_ddf;
3916:
3954:
3955: BEGIN
3956:
3957: g_proc := 'get_from_sf52_data_elements';
3958: hr_utility.set_location('Entering ' || l_proc,5);
3959:
3960: -- Processing Total Pay and Adjusted Basic Pay
3961: -- NAME DATE BUG COMMENTS
3962: -- Ashley 17-JUL-03 Payroll Intg Modified the Input Value name
3970: ,p_effective_date => p_effective_date
3971: ,p_value => l_total_salary
3972: ,p_multiple_error_flag => l_multi_error_flag);
3973:
3974: hr_utility.set_location('Total Pay = ' || to_char(l_total_salary), 6);
3975:
3976: if l_multi_error_flag then
3977: hr_utility.set_message(8301, 'GHR_38014_API_MULTI_ELE_ENTR');
3978: hr_utility.raise_error;
3973:
3974: hr_utility.set_location('Total Pay = ' || to_char(l_total_salary), 6);
3975:
3976: if l_multi_error_flag then
3977: hr_utility.set_message(8301, 'GHR_38014_API_MULTI_ELE_ENTR');
3978: hr_utility.raise_error;
3979: end if;
3980:
3981: ghr_api.retrieve_element_entry_value
3974: hr_utility.set_location('Total Pay = ' || to_char(l_total_salary), 6);
3975:
3976: if l_multi_error_flag then
3977: hr_utility.set_message(8301, 'GHR_38014_API_MULTI_ELE_ENTR');
3978: hr_utility.raise_error;
3979: end if;
3980:
3981: ghr_api.retrieve_element_entry_value
3982: (p_element_name => 'Basic Salary Rate'
3985: ,p_effective_date => p_effective_date
3986: ,p_value => l_basic_pay
3987: ,p_multiple_error_flag => l_multi_error_flag);
3988:
3989: hr_utility.set_location('Basic Salary Rate = ' || to_char(l_basic_pay), 6);
3990:
3991: if l_multi_error_flag then
3992: hr_utility.set_message(8301, 'GHR_38014_API_MULTI_ELE_ENTR');
3993: hr_utility.raise_error;
3988:
3989: hr_utility.set_location('Basic Salary Rate = ' || to_char(l_basic_pay), 6);
3990:
3991: if l_multi_error_flag then
3992: hr_utility.set_message(8301, 'GHR_38014_API_MULTI_ELE_ENTR');
3993: hr_utility.raise_error;
3994: end if;
3995:
3996: ghr_api.retrieve_element_entry_value
3989: hr_utility.set_location('Basic Salary Rate = ' || to_char(l_basic_pay), 6);
3990:
3991: if l_multi_error_flag then
3992: hr_utility.set_message(8301, 'GHR_38014_API_MULTI_ELE_ENTR');
3993: hr_utility.raise_error;
3994: end if;
3995:
3996: ghr_api.retrieve_element_entry_value
3997: -- FWFA Changes Bug#4444609
4003: ,p_effective_date => p_effective_date
4004: ,p_value => l_locality_adj
4005: ,p_multiple_error_flag => l_multi_error_flag);
4006:
4007: hr_utility.set_location('Locality Pay = ' || to_char(l_locality_adj), 6);
4008:
4009: if l_multi_error_flag then
4010: hr_utility.set_message(8301, 'GHR_38014_API_MULTI_ELE_ENTR');
4011: hr_utility.raise_error;
4006:
4007: hr_utility.set_location('Locality Pay = ' || to_char(l_locality_adj), 6);
4008:
4009: if l_multi_error_flag then
4010: hr_utility.set_message(8301, 'GHR_38014_API_MULTI_ELE_ENTR');
4011: hr_utility.raise_error;
4012: end if;
4013:
4014: ghr_api.retrieve_element_entry_value
4007: hr_utility.set_location('Locality Pay = ' || to_char(l_locality_adj), 6);
4008:
4009: if l_multi_error_flag then
4010: hr_utility.set_message(8301, 'GHR_38014_API_MULTI_ELE_ENTR');
4011: hr_utility.raise_error;
4012: end if;
4013:
4014: ghr_api.retrieve_element_entry_value
4015: (p_element_name => 'Adjusted Basic Pay'
4018: ,p_effective_date => p_effective_date
4019: ,p_value => l_adj_basic_pay
4020: ,p_multiple_error_flag => l_multi_error_flag);
4021:
4022: hr_utility.set_location('Adjusted Basic Pay = ' || to_char(l_adj_basic_pay), 6);
4023:
4024: if l_multi_error_flag then
4025: hr_utility.set_message(8301, 'GHR_38014_API_MULTI_ELE_ENTR');
4026: hr_utility.raise_error;
4021:
4022: hr_utility.set_location('Adjusted Basic Pay = ' || to_char(l_adj_basic_pay), 6);
4023:
4024: if l_multi_error_flag then
4025: hr_utility.set_message(8301, 'GHR_38014_API_MULTI_ELE_ENTR');
4026: hr_utility.raise_error;
4027: end if;
4028:
4029: ghr_api.retrieve_element_entry_value
4022: hr_utility.set_location('Adjusted Basic Pay = ' || to_char(l_adj_basic_pay), 6);
4023:
4024: if l_multi_error_flag then
4025: hr_utility.set_message(8301, 'GHR_38014_API_MULTI_ELE_ENTR');
4026: hr_utility.raise_error;
4027: end if;
4028:
4029: ghr_api.retrieve_element_entry_value
4030: (p_element_name => 'Other Pay'
4033: ,p_effective_date => p_effective_date
4034: ,p_value => l_other_pay
4035: ,p_multiple_error_flag => l_multi_error_flag);
4036:
4037: hr_utility.set_location('Other Pay = ' || to_char(l_other_pay), 6);
4038:
4039: if l_multi_error_flag then
4040: hr_utility.set_message(8301, 'GHR_38014_API_MULTI_ELE_ENTR');
4041: hr_utility.raise_error;
4036:
4037: hr_utility.set_location('Other Pay = ' || to_char(l_other_pay), 6);
4038:
4039: if l_multi_error_flag then
4040: hr_utility.set_message(8301, 'GHR_38014_API_MULTI_ELE_ENTR');
4041: hr_utility.raise_error;
4042: end if;
4043:
4044: ghr_api.retrieve_element_entry_value
4037: hr_utility.set_location('Other Pay = ' || to_char(l_other_pay), 6);
4038:
4039: if l_multi_error_flag then
4040: hr_utility.set_message(8301, 'GHR_38014_API_MULTI_ELE_ENTR');
4041: hr_utility.raise_error;
4042: end if;
4043:
4044: ghr_api.retrieve_element_entry_value
4045: (p_element_name => 'AUO'
4048: ,p_effective_date => p_effective_date
4049: ,p_value => l_au_overtime
4050: ,p_multiple_error_flag => l_multi_error_flag);
4051:
4052: hr_utility.set_location('AUO Amount = ' || to_char(l_au_overtime), 6);
4053:
4054: if l_multi_error_flag then
4055: hr_utility.set_message(8301, 'GHR_38014_API_MULTI_ELE_ENTR');
4056: hr_utility.raise_error;
4051:
4052: hr_utility.set_location('AUO Amount = ' || to_char(l_au_overtime), 6);
4053:
4054: if l_multi_error_flag then
4055: hr_utility.set_message(8301, 'GHR_38014_API_MULTI_ELE_ENTR');
4056: hr_utility.raise_error;
4057: end if;
4058:
4059: ghr_api.retrieve_element_entry_value
4052: hr_utility.set_location('AUO Amount = ' || to_char(l_au_overtime), 6);
4053:
4054: if l_multi_error_flag then
4055: hr_utility.set_message(8301, 'GHR_38014_API_MULTI_ELE_ENTR');
4056: hr_utility.raise_error;
4057: end if;
4058:
4059: ghr_api.retrieve_element_entry_value
4060: (p_element_name => 'AUO'
4064: ,p_value => l_auo_premium_pay_indicator
4065: ,p_multiple_error_flag => l_multi_error_flag);
4066:
4067: if l_multi_error_flag then
4068: hr_utility.set_message(8301, 'GHR_38014_API_MULTI_ELE_ENTR');
4069: hr_utility.raise_error;
4070: end if;
4071:
4072: ghr_api.retrieve_element_entry_value
4065: ,p_multiple_error_flag => l_multi_error_flag);
4066:
4067: if l_multi_error_flag then
4068: hr_utility.set_message(8301, 'GHR_38014_API_MULTI_ELE_ENTR');
4069: hr_utility.raise_error;
4070: end if;
4071:
4072: ghr_api.retrieve_element_entry_value
4073: (p_element_name => 'Availability Pay'
4076: ,p_effective_date => p_effective_date
4077: ,p_value => l_availability_pay
4078: ,p_multiple_error_flag => l_multi_error_flag);
4079:
4080: hr_utility.set_location('Availability Pay Amount = ' || to_char(l_availability_pay), 6);
4081:
4082: if l_multi_error_flag then
4083: hr_utility.set_message(8301, 'GHR_38014_API_MULTI_ELE_ENTR');
4084: hr_utility.raise_error;
4079:
4080: hr_utility.set_location('Availability Pay Amount = ' || to_char(l_availability_pay), 6);
4081:
4082: if l_multi_error_flag then
4083: hr_utility.set_message(8301, 'GHR_38014_API_MULTI_ELE_ENTR');
4084: hr_utility.raise_error;
4085: end if;
4086:
4087: ghr_api.retrieve_element_entry_value
4080: hr_utility.set_location('Availability Pay Amount = ' || to_char(l_availability_pay), 6);
4081:
4082: if l_multi_error_flag then
4083: hr_utility.set_message(8301, 'GHR_38014_API_MULTI_ELE_ENTR');
4084: hr_utility.raise_error;
4085: end if;
4086:
4087: ghr_api.retrieve_element_entry_value
4088: (p_element_name => 'Availability Pay'
4092: ,p_value => l_ap_premium_pay_indicator
4093: ,p_multiple_error_flag => l_multi_error_flag);
4094:
4095: if l_multi_error_flag then
4096: hr_utility.set_message(8301, 'GHR_38014_API_MULTI_ELE_ENTR');
4097: hr_utility.raise_error;
4098: end if;
4099: --
4100: ghr_api.retrieve_element_entry_value
4093: ,p_multiple_error_flag => l_multi_error_flag);
4094:
4095: if l_multi_error_flag then
4096: hr_utility.set_message(8301, 'GHR_38014_API_MULTI_ELE_ENTR');
4097: hr_utility.raise_error;
4098: end if;
4099: --
4100: ghr_api.retrieve_element_entry_value
4101: (p_element_name => 'Retention Allowance'
4104: ,p_effective_date => p_effective_date
4105: ,p_value => l_retention_allowance
4106: ,p_multiple_error_flag => l_multi_error_flag);
4107:
4108: hr_utility.set_location('Retention Allowance Amount = ' || to_char(l_retention_allowance), 6);
4109:
4110: if l_multi_error_flag then
4111: hr_utility.set_message(8301, 'GHR_38014_API_MULTI_ELE_ENTR');
4112: hr_utility.raise_error;
4107:
4108: hr_utility.set_location('Retention Allowance Amount = ' || to_char(l_retention_allowance), 6);
4109:
4110: if l_multi_error_flag then
4111: hr_utility.set_message(8301, 'GHR_38014_API_MULTI_ELE_ENTR');
4112: hr_utility.raise_error;
4113: end if;
4114:
4115: ghr_api.retrieve_element_entry_value
4108: hr_utility.set_location('Retention Allowance Amount = ' || to_char(l_retention_allowance), 6);
4109:
4110: if l_multi_error_flag then
4111: hr_utility.set_message(8301, 'GHR_38014_API_MULTI_ELE_ENTR');
4112: hr_utility.raise_error;
4113: end if;
4114:
4115: ghr_api.retrieve_element_entry_value
4116: (p_element_name => 'Retention Allowance'
4119: ,p_effective_date => p_effective_date
4120: ,p_value => l_retention_allow_perc
4121: ,p_multiple_error_flag => l_multi_error_flag);
4122:
4123: hr_utility.set_location('Retention Allowance Percent = ' || to_char(l_retention_allow_perc), 6);
4124:
4125: if l_multi_error_flag then
4126: hr_utility.set_message(8301, 'GHR_38014_API_MULTI_ELE_ENTR');
4127: hr_utility.raise_error;
4122:
4123: hr_utility.set_location('Retention Allowance Percent = ' || to_char(l_retention_allow_perc), 6);
4124:
4125: if l_multi_error_flag then
4126: hr_utility.set_message(8301, 'GHR_38014_API_MULTI_ELE_ENTR');
4127: hr_utility.raise_error;
4128: end if;
4129:
4130: ghr_api.retrieve_element_entry_value
4123: hr_utility.set_location('Retention Allowance Percent = ' || to_char(l_retention_allow_perc), 6);
4124:
4125: if l_multi_error_flag then
4126: hr_utility.set_message(8301, 'GHR_38014_API_MULTI_ELE_ENTR');
4127: hr_utility.raise_error;
4128: end if;
4129:
4130: ghr_api.retrieve_element_entry_value
4131: (p_element_name => 'Supervisory Differential'
4134: ,p_effective_date => p_effective_date
4135: ,p_value => l_supervisory_differential
4136: ,p_multiple_error_flag => l_multi_error_flag);
4137:
4138: hr_utility.set_location('Supervisory Diff Amount = ' || to_char(l_supervisory_differential), 6);
4139:
4140: if l_multi_error_flag then
4141: hr_utility.set_message(8301, 'GHR_38014_API_MULTI_ELE_ENTR');
4142: hr_utility.raise_error;
4137:
4138: hr_utility.set_location('Supervisory Diff Amount = ' || to_char(l_supervisory_differential), 6);
4139:
4140: if l_multi_error_flag then
4141: hr_utility.set_message(8301, 'GHR_38014_API_MULTI_ELE_ENTR');
4142: hr_utility.raise_error;
4143: end if;
4144:
4145: ghr_api.retrieve_element_entry_value
4138: hr_utility.set_location('Supervisory Diff Amount = ' || to_char(l_supervisory_differential), 6);
4139:
4140: if l_multi_error_flag then
4141: hr_utility.set_message(8301, 'GHR_38014_API_MULTI_ELE_ENTR');
4142: hr_utility.raise_error;
4143: end if;
4144:
4145: ghr_api.retrieve_element_entry_value
4146: (p_element_name => 'Supervisory Differential'
4149: ,p_effective_date => p_effective_date
4150: ,p_value => l_supervisory_diff_perc
4151: ,p_multiple_error_flag => l_multi_error_flag);
4152:
4153: hr_utility.set_location('Supervisory Diff Percent = ' || to_char(l_supervisory_diff_perc), 6);
4154:
4155: if l_multi_error_flag then
4156: hr_utility.set_message(8301, 'GHR_38014_API_MULTI_ELE_ENTR');
4157: hr_utility.raise_error;
4152:
4153: hr_utility.set_location('Supervisory Diff Percent = ' || to_char(l_supervisory_diff_perc), 6);
4154:
4155: if l_multi_error_flag then
4156: hr_utility.set_message(8301, 'GHR_38014_API_MULTI_ELE_ENTR');
4157: hr_utility.raise_error;
4158: end if;
4159:
4160: --
4153: hr_utility.set_location('Supervisory Diff Percent = ' || to_char(l_supervisory_diff_perc), 6);
4154:
4155: if l_multi_error_flag then
4156: hr_utility.set_message(8301, 'GHR_38014_API_MULTI_ELE_ENTR');
4157: hr_utility.raise_error;
4158: end if;
4159:
4160: --
4161: --
4166: ,p_effective_date => p_effective_date
4167: ,p_value => l_staffing_differential
4168: ,p_multiple_error_flag => l_multi_error_flag);
4169:
4170: hr_utility.set_location('Staffing Diff Amount = ' || to_char(l_staffing_differential), 6);
4171:
4172: if l_multi_error_flag then
4173: hr_utility.set_message(8301, 'GHR_38014_API_MULTI_ELE_ENTR');
4174: hr_utility.raise_error;
4169:
4170: hr_utility.set_location('Staffing Diff Amount = ' || to_char(l_staffing_differential), 6);
4171:
4172: if l_multi_error_flag then
4173: hr_utility.set_message(8301, 'GHR_38014_API_MULTI_ELE_ENTR');
4174: hr_utility.raise_error;
4175: end if;
4176:
4177: p_tot_old_sal := round(l_total_salary,2);
4170: hr_utility.set_location('Staffing Diff Amount = ' || to_char(l_staffing_differential), 6);
4171:
4172: if l_multi_error_flag then
4173: hr_utility.set_message(8301, 'GHR_38014_API_MULTI_ELE_ENTR');
4174: hr_utility.raise_error;
4175: end if;
4176:
4177: p_tot_old_sal := round(l_total_salary,2);
4178: p_OLD_BASIC_PAY := round(l_basic_pay,2);
4188: p_supervisory_differential := l_supervisory_differential;
4189: p_supervisory_diff_perc := l_supervisory_diff_perc;
4190: p_staffing_differential := l_staffing_differential;
4191:
4192: hr_utility.set_location('Exiting ' || l_proc,10);
4193:
4194: exception
4195: when msl_error then raise;
4196: when others then
4193:
4194: exception
4195: when msl_error then raise;
4196: when others then
4197: hr_utility.set_location('Error in '||l_proc||' Err is '||sqlerrm(sqlcode),20);
4198: l_mslerrbuf := 'Error in '||l_proc||' Sql Err is '|| sqlerrm(sqlcode);
4199: raise msl_error;
4200: END GET_FROM_SF52_DATA_ELEMENTS;
4201:
4215: p_position_seq_no out nocopy varchar2) is
4216: l_proc varchar2(72) := g_package || '.get_sub_element_code_pos_title';
4217: begin
4218: g_proc := 'get_sub_element_code_pos_title';
4219: hr_utility.set_location('Entering ' || l_proc,5);
4220: p_sub_element_code := ghr_api.get_position_agency_code_pos
4221: (p_position_id,p_business_group_id,p_effective_date);
4222:
4223: p_position_title := ghr_api.get_position_title_pos
4238: ,p_effective_date => p_effective_date
4239: );
4240: end if;
4241:
4242: hr_utility.set_location('Exiting ' || l_proc,10);
4243: end get_sub_element_code_pos_title;
4244:
4245: --
4246: -- Get all details for the reporting...
4256: ) is
4257: l_proc varchar2(72) := g_package || '.get_other_dtls_for_rep';
4258: BEGIN
4259: g_proc := 'get_other_dtls_for_rep';
4260: hr_utility.set_location('Entering ' || l_proc,5);
4261: p_first_action_la_code1 := 'QWM';
4262: p_first_action_la_code2 := 'ZLM';
4263:
4264: /**
4280: p_first_action_la_code2 := 'ZLM';
4281: End if;
4282: */
4283:
4284: hr_utility.set_location('Exiting ' || l_proc,10);
4285:
4286: exception
4287: when msl_error then raise;
4288: when others then
4285:
4286: exception
4287: when msl_error then raise;
4288: when others then
4289: hr_utility.set_location('Error in '||l_proc||' Err is '||sqlerrm(sqlcode),20);
4290: l_mslerrbuf := 'Error in '||l_proc||' Sql Err is '|| sqlerrm(sqlcode);
4291: raise msl_error;
4292: END get_other_dtls_for_rep;
4293:
4372: l_check_grade_retention VARCHAR2(200);
4373:
4374: begin
4375: g_proc := 'create_mass_act_prev';
4376: hr_utility.set_location('Entering ' || l_proc,5);
4377: if p_remark_code2 is not null then
4378: l_comb_rem := p_remark_code1||', '||p_remark_code2;
4379: else
4380: l_comb_rem := p_remark_code1;
4396: p_cust_rec => l_cust_rec);
4397:
4398: exception
4399: when others then
4400: hr_utility.set_location('Error in Mass Act Custom '||
4401: 'Err is '||sqlerrm(sqlcode),20);
4402: l_mslerrbuf := 'Error in Mass Act Custom '||
4403: 'Err is '|| sqlerrm(sqlcode);
4404: raise msl_error;
4426: ghr_mre_pkg.pr('Person ID '||to_char(p_person_id),'ERROR 2',l_mslerrbuf);
4427: raise msl_error;
4428: END;
4429: ELSIF l_check_grade_retention ='MSL_ERROR' THEN
4430: hr_utility.set_message(8301,'GHR_38927_MISSING_MA_RET_DET');
4431: raise msl_error;
4432: ELSIF l_check_grade_retention = 'OTHER_ERROR' THEN
4433: l_mslerrbuf := 'Others error in check_grade_retention function while fetching retained grade record. Please
4434: verify the retained grade record';
4604: l_cust_rec.user_attribute20,
4605: p_increase_percent
4606: );
4607:
4608: hr_utility.set_location('Exiting ' || l_proc,10);
4609: exception
4610: when msl_error then raise;
4611: when others then
4612: hr_utility.set_location('Error in '||l_proc||' Err is '||sqlerrm(sqlcode),20);
4608: hr_utility.set_location('Exiting ' || l_proc,10);
4609: exception
4610: when msl_error then raise;
4611: when others then
4612: hr_utility.set_location('Error in '||l_proc||' Err is '||sqlerrm(sqlcode),20);
4613: l_mslerrbuf := 'Error in '||l_proc||' Sql Err is '|| sqlerrm(sqlcode);
4614: raise msl_error;
4615: end create_mass_act_prev;
4616:
4629: where pa_request_id = p_pa_request_id;
4630:
4631: begin
4632: g_proc := 'get_lac_dtls';
4633: hr_utility.set_location('Entering ' || l_proc,5);
4634:
4635: pr('Entering '||l_proc||' Pa req id ',to_char(p_pa_request_id));
4636: if p_pa_request_id is null then
4637: pr('PA request id is null.................');
4643: exit;
4644: end loop;
4645: end if;
4646:
4647: hr_utility.set_location('Exiting ' || l_proc,10);
4648: exception
4649: when others then
4650: hr_utility.set_location('Error in '||l_proc||' Err is '||sqlerrm(sqlcode),20);
4651: l_mslerrbuf := 'Error in '||l_proc||' Sql Err is '|| sqlerrm(sqlcode);
4646:
4647: hr_utility.set_location('Exiting ' || l_proc,10);
4648: exception
4649: when others then
4650: hr_utility.set_location('Error in '||l_proc||' Err is '||sqlerrm(sqlcode),20);
4651: l_mslerrbuf := 'Error in '||l_proc||' Sql Err is '|| sqlerrm(sqlcode);
4652: raise msl_error;
4653: end get_lac_dtls;
4654:
4669: l_remarks_rec ghr_pa_remarks%rowtype;
4670:
4671: begin
4672: g_proc := 'create_lac_remarks';
4673: hr_utility.set_location('Entering ' || l_proc,5);
4674:
4675: pr('Inside '||l_proc,to_char(p_pa_request_id),to_char(p_new_pa_request_id));
4676:
4677: FOR CUR_PA_REM_rec in cur_pa_rem_cur
4695: );
4696:
4697: end loop;
4698:
4699: hr_utility.set_location('Exiting ' || l_proc,10);
4700:
4701: exception
4702: when others then
4703: hr_utility.set_location('Error in '||l_proc||' Err is '||sqlerrm(sqlcode),20);
4699: hr_utility.set_location('Exiting ' || l_proc,10);
4700:
4701: exception
4702: when others then
4703: hr_utility.set_location('Error in '||l_proc||' Err is '||sqlerrm(sqlcode),20);
4704: l_mslerrbuf := 'Error in '||l_proc||' Sql Err is '|| sqlerrm(sqlcode);
4705: raise msl_error;
4706: end create_lac_remarks;
4707:
4722: l_proc varchar2(72) := g_package || '.upd_ext_info_to_null';
4723:
4724: begin
4725: g_proc := 'upd_ext_info_to_null';
4726: hr_utility.set_location('Entering ' || l_proc,5);
4727:
4728: pr('Inside '||l_proc);
4729:
4730: for per_ext_rec in cur1
4735:
4736: commit;
4737:
4738: pr('Exiting '||l_proc);
4739: hr_utility.set_location('Exiting ' || l_proc,10);
4740:
4741: exception
4742: when msl_error then raise;
4743: when others then
4740:
4741: exception
4742: when msl_error then raise;
4743: when others then
4744: hr_utility.set_location('Error in '||l_proc||' Err is '||sqlerrm(sqlcode),20);
4745: l_mslerrbuf := 'Error in '||l_proc||' Sql Err is '|| sqlerrm(sqlcode);
4746: raise msl_error;
4747: end;
4748:
4802: begin
4803:
4804: g_proc := 'assign_to_sf52_rec';
4805:
4806: hr_utility.set_location('Entering ' || l_proc,5);
4807:
4808: p_sf52_rec.person_id := p_person_id;
4809: p_sf52_rec.employee_first_name := p_first_name;
4810: p_sf52_rec.employee_last_name := p_last_name;
4871: p_sf52_rec.FIRST_ACTION_LA_CODE2 := p_lac_sf52_rec.FIRST_ACTION_LA_CODE2;
4872: p_sf52_rec.FIRST_ACTION_LA_DESC1 := p_lac_sf52_rec.FIRST_ACTION_LA_DESC1;
4873: p_sf52_rec.FIRST_ACTION_LA_DESC2 := p_lac_sf52_rec.FIRST_ACTION_LA_DESC2;
4874:
4875: hr_utility.set_location('Exiting ' || l_proc,10);
4876:
4877: exception
4878: when msl_error then raise;
4879: when others then
4876:
4877: exception
4878: when msl_error then raise;
4879: when others then
4880: hr_utility.set_location('Error in '||l_proc||' Err is '||sqlerrm(sqlcode),20);
4881: l_mslerrbuf := 'Error in '||l_proc||' Sql Err is '|| sqlerrm(sqlcode);
4882: raise msl_error;
4883: end assign_to_sf52_rec;
4884:
4895:
4896: ghr_mto_int.put_line(msg||'-'||par1||' -'||par2||'-');
4897: exception
4898: when others then
4899: hr_utility.set_location('Error in pr '||' Err is '||sqlerrm(sqlcode),20);
4900: l_mslerrbuf := 'Error in pr Sql Err is '|| sqlerrm(sqlcode);
4901: raise msl_error;
4902: end;
4903:
5301: l_grade_or_level := p_grade_or_level;
5302: l_step_or_rate := P_step_or_rate;
5303: l_pay_basis := p_pay_basis;
5304:
5305: hr_utility.set_location('The location id is:'||l_location_id,12345);
5306:
5307: ghr_msl_pkg.g_first_noa_code := '894';
5308: --------GPPA Update 46 start
5309: -- ghr_msl_pkg.g_first_noa_code := NULL;
5366: LOOP
5367: l_ds_end_date := rec_ds.end_Date;
5368: END LOOP;
5369: IF l_ds_end_date IS NULL THEN
5370: hr_utility.set_location('Under DS null check'||l_duty_station_id,12345);
5371: l_mslerrbuf := 'Error - Duty Station associated with the location is INVALID. '||
5372: 'Salary cannot be calculated correctly without valid duty station. ';
5373: RAISE msl_error;
5374: END IF;
5381: (p_location_id => l_location_id
5382: ,p_duty_station_id => l_duty_station_id);
5383: exception
5384: when others then
5385: hr_utility.set_location(
5386: 'Error in Ghr_pa_requests_pkg.get_sf52_loc_ddf_details'||
5387: 'Err is '||sqlerrm(sqlcode),20);
5388: l_mslerrbuf := 'Error in get_sf52_loc_ddf_details '||
5389: 'Sql Err is '|| sqlerrm(sqlcode);
5413: l_position_title,
5414: l_position_number,
5415: l_position_seq_no);
5416:
5417: hr_utility.set_location('The duty station id is:'||l_duty_station_id,12345);
5418:
5419: if check_init_eligibility(l_p_duty_station_id,
5420: l_p_PERSONNEL_OFFICE_ID,
5421: l_p_AGENCY_CODE_SUBELEMENT,
5422: l_duty_station_id,
5423: l_personnel_office_id,
5424: l_sub_element_code) then
5425:
5426: hr_utility.set_location('check_init_eligibility ' || l_proc,6);
5427: -- Bug 3457205 Filter the Pay plan table id condition also b4 checking any other thing
5428: -- Moving check_eligibility to here.
5429: -- Get PRD, work schedule etc form ASG EI
5430: begin
5437: l_work_schedule,
5438: l_part_time_hour);
5439: exception
5440: when others then
5441: hr_utility.set_location('Error in Ghr_pa_requests_pkg.get_sf52_asg_ddf_details'||
5442: 'Err is '||sqlerrm(sqlcode),20);
5443: l_mslerrbuf := 'Error in get_sf52_asgddf_details Sql Err is '|| sqlerrm(sqlcode);
5444: raise msl_error;
5445: end;
5462: l_pay_table_id,l_grade_or_level, l_step_or_rate,
5463: l_pay_basis);
5464: EXCEPTION
5465: when msl_error then
5466: l_mslerrbuf := hr_utility.get_message;
5467: raise;
5468: END;
5469:
5470: IF ( nvl(rec_pp_prd_per_gr(l_cnt).pay_plan,l_pay_plan) = l_pay_plan
5481: l_pay_rate_determinant,
5482: p_person_id,
5483: l_effective_date,
5484: p_action) THEN
5485: hr_utility.set_location('check_eligibility ' || l_proc,8);
5486:
5487: l_increase_percent := nvl(rec_pp_prd_per_gr(l_cnt).percent,0);*/
5488:
5489: if upper(p_action) = 'REPORT' AND l_submit_flag = 'P' THEN
5494: if check_select_flg_msl_perc(p_person_id,upper(p_action),
5495: l_effective_date,p_mass_salary_id,l_sel_flg,
5496: l_increase_percent ) then
5497:
5498: hr_utility.set_location('check_select_flg ' || l_proc,7);
5499: begin
5500: hr_utility.set_location('The duty station name is:'||l_duty_station_code,12345);
5501: hr_utility.set_location('The duty station desc is:'||l_duty_station_desc,12345);
5502:
5496: l_increase_percent ) then
5497:
5498: hr_utility.set_location('check_select_flg ' || l_proc,7);
5499: begin
5500: hr_utility.set_location('The duty station name is:'||l_duty_station_code,12345);
5501: hr_utility.set_location('The duty station desc is:'||l_duty_station_desc,12345);
5502:
5503: ghr_pa_requests_pkg.get_duty_station_details
5504: (p_duty_station_id => l_duty_station_id
5497:
5498: hr_utility.set_location('check_select_flg ' || l_proc,7);
5499: begin
5500: hr_utility.set_location('The duty station name is:'||l_duty_station_code,12345);
5501: hr_utility.set_location('The duty station desc is:'||l_duty_station_desc,12345);
5502:
5503: ghr_pa_requests_pkg.get_duty_station_details
5504: (p_duty_station_id => l_duty_station_id
5505: ,p_effective_date => l_effective_date
5506: ,p_duty_station_code => l_duty_station_code
5507: ,p_duty_station_desc => l_duty_station_desc);
5508: exception
5509: when others then
5510: hr_utility.set_location('Error in Ghr_pa_requests_pkg.get_duty_station_details'||
5511: 'Err is '||sqlerrm(sqlcode),20);
5512: l_mslerrbuf := 'Error in get_duty_station_details Sql Err is '|| sqlerrm(sqlcode);
5513: raise msl_error;
5514:
5633: ,l_message_set
5634: ,l_calculated);
5635:
5636: IF l_message_set THEN
5637: hr_utility.set_location( l_proc, 40);
5638: l_calculated := FALSE;
5639: l_mslerrbuf := hr_utility.get_message;
5640: -- raise msl_error;
5641: END IF;
5635:
5636: IF l_message_set THEN
5637: hr_utility.set_location( l_proc, 40);
5638: l_calculated := FALSE;
5639: l_mslerrbuf := hr_utility.get_message;
5640: -- raise msl_error;
5641: END IF;
5642: exception
5643: when msl_error then
5721: ins_upd_per_extra_info
5722: (p_person_id,l_effective_date, l_sel_flg, l_comments,p_mass_salary_id,l_cust_percent);
5723: l_comment := NULL;
5724: ------ BUG 3287299 End
5725: hr_utility.set_location('Error in Ghr_pay_calc.sql_main_pay_calc '||
5726: 'Err is '||sqlerrm(sqlcode),20);
5727: l_mslerrbuf := 'Error in ghr_pay_calc Sql Err is '|| sqlerrm(sqlcode);
5728: g_proc := 'ghr_pay_calc';
5729: raise msl_error;
5747: l_new_other_pay_amount := null;
5748: end if;
5749: l_new_total_salary := l_pay_calc_out_data.total_salary;
5750:
5751: hr_utility.set_location('retention_allowance = ' || to_char(l_retention_allowance),10);
5752: hr_utility.set_location('Supervisory Diff Amount = ' || to_char(l_supervisory_differential),10);
5753:
5754:
5755: -------------Call Pay cap Procedure
5748: end if;
5749: l_new_total_salary := l_pay_calc_out_data.total_salary;
5750:
5751: hr_utility.set_location('retention_allowance = ' || to_char(l_retention_allowance),10);
5752: hr_utility.set_location('Supervisory Diff Amount = ' || to_char(l_supervisory_differential),10);
5753:
5754:
5755: -------------Call Pay cap Procedure
5756: begin
5757: l_capped_other_pay := ghr_pa_requests_pkg2.get_cop( p_assignment_id => l_assignment_id
5758: ,p_effective_date => l_effective_date);
5759: l_old_capped_other_pay := l_capped_other_pay;
5760: -- Sundar Added the following if statement to improve performance
5761: if hr_utility.debug_enabled = true then
5762: hr_utility.set_location('Before Pay Cap ' || l_proc,21);
5763: hr_utility.set_location('l_effective_date ' || l_effective_date,21);
5764: hr_utility.set_location('l_out_pay_rate_determinant ' || l_out_pay_rate_determinant,21);
5765: hr_utility.set_location('l_pay_plan ' || l_pay_plan,21);
5758: ,p_effective_date => l_effective_date);
5759: l_old_capped_other_pay := l_capped_other_pay;
5760: -- Sundar Added the following if statement to improve performance
5761: if hr_utility.debug_enabled = true then
5762: hr_utility.set_location('Before Pay Cap ' || l_proc,21);
5763: hr_utility.set_location('l_effective_date ' || l_effective_date,21);
5764: hr_utility.set_location('l_out_pay_rate_determinant ' || l_out_pay_rate_determinant,21);
5765: hr_utility.set_location('l_pay_plan ' || l_pay_plan,21);
5766: hr_utility.set_location('l_position_id ' || to_char(l_position_id),21);
5759: l_old_capped_other_pay := l_capped_other_pay;
5760: -- Sundar Added the following if statement to improve performance
5761: if hr_utility.debug_enabled = true then
5762: hr_utility.set_location('Before Pay Cap ' || l_proc,21);
5763: hr_utility.set_location('l_effective_date ' || l_effective_date,21);
5764: hr_utility.set_location('l_out_pay_rate_determinant ' || l_out_pay_rate_determinant,21);
5765: hr_utility.set_location('l_pay_plan ' || l_pay_plan,21);
5766: hr_utility.set_location('l_position_id ' || to_char(l_position_id),21);
5767: hr_utility.set_location('l_pay_basis ' || l_pay_basis,21);
5760: -- Sundar Added the following if statement to improve performance
5761: if hr_utility.debug_enabled = true then
5762: hr_utility.set_location('Before Pay Cap ' || l_proc,21);
5763: hr_utility.set_location('l_effective_date ' || l_effective_date,21);
5764: hr_utility.set_location('l_out_pay_rate_determinant ' || l_out_pay_rate_determinant,21);
5765: hr_utility.set_location('l_pay_plan ' || l_pay_plan,21);
5766: hr_utility.set_location('l_position_id ' || to_char(l_position_id),21);
5767: hr_utility.set_location('l_pay_basis ' || l_pay_basis,21);
5768: hr_utility.set_location('person_id ' || to_char(p_person_id),21);
5761: if hr_utility.debug_enabled = true then
5762: hr_utility.set_location('Before Pay Cap ' || l_proc,21);
5763: hr_utility.set_location('l_effective_date ' || l_effective_date,21);
5764: hr_utility.set_location('l_out_pay_rate_determinant ' || l_out_pay_rate_determinant,21);
5765: hr_utility.set_location('l_pay_plan ' || l_pay_plan,21);
5766: hr_utility.set_location('l_position_id ' || to_char(l_position_id),21);
5767: hr_utility.set_location('l_pay_basis ' || l_pay_basis,21);
5768: hr_utility.set_location('person_id ' || to_char(p_person_id),21);
5769: hr_utility.set_location('l_new_basic_pay ' || to_char(l_new_basic_pay),21);
5762: hr_utility.set_location('Before Pay Cap ' || l_proc,21);
5763: hr_utility.set_location('l_effective_date ' || l_effective_date,21);
5764: hr_utility.set_location('l_out_pay_rate_determinant ' || l_out_pay_rate_determinant,21);
5765: hr_utility.set_location('l_pay_plan ' || l_pay_plan,21);
5766: hr_utility.set_location('l_position_id ' || to_char(l_position_id),21);
5767: hr_utility.set_location('l_pay_basis ' || l_pay_basis,21);
5768: hr_utility.set_location('person_id ' || to_char(p_person_id),21);
5769: hr_utility.set_location('l_new_basic_pay ' || to_char(l_new_basic_pay),21);
5770: hr_utility.set_location('l_new_locality_adj ' || to_char(l_new_locality_adj),21);
5763: hr_utility.set_location('l_effective_date ' || l_effective_date,21);
5764: hr_utility.set_location('l_out_pay_rate_determinant ' || l_out_pay_rate_determinant,21);
5765: hr_utility.set_location('l_pay_plan ' || l_pay_plan,21);
5766: hr_utility.set_location('l_position_id ' || to_char(l_position_id),21);
5767: hr_utility.set_location('l_pay_basis ' || l_pay_basis,21);
5768: hr_utility.set_location('person_id ' || to_char(p_person_id),21);
5769: hr_utility.set_location('l_new_basic_pay ' || to_char(l_new_basic_pay),21);
5770: hr_utility.set_location('l_new_locality_adj ' || to_char(l_new_locality_adj),21);
5771: hr_utility.set_location('l_new_adj_basic_pay ' || to_char(l_new_adj_basic_pay),21);
5764: hr_utility.set_location('l_out_pay_rate_determinant ' || l_out_pay_rate_determinant,21);
5765: hr_utility.set_location('l_pay_plan ' || l_pay_plan,21);
5766: hr_utility.set_location('l_position_id ' || to_char(l_position_id),21);
5767: hr_utility.set_location('l_pay_basis ' || l_pay_basis,21);
5768: hr_utility.set_location('person_id ' || to_char(p_person_id),21);
5769: hr_utility.set_location('l_new_basic_pay ' || to_char(l_new_basic_pay),21);
5770: hr_utility.set_location('l_new_locality_adj ' || to_char(l_new_locality_adj),21);
5771: hr_utility.set_location('l_new_adj_basic_pay ' || to_char(l_new_adj_basic_pay),21);
5772: hr_utility.set_location('l_new_total_salary ' || to_char(l_new_total_salary),21);
5765: hr_utility.set_location('l_pay_plan ' || l_pay_plan,21);
5766: hr_utility.set_location('l_position_id ' || to_char(l_position_id),21);
5767: hr_utility.set_location('l_pay_basis ' || l_pay_basis,21);
5768: hr_utility.set_location('person_id ' || to_char(p_person_id),21);
5769: hr_utility.set_location('l_new_basic_pay ' || to_char(l_new_basic_pay),21);
5770: hr_utility.set_location('l_new_locality_adj ' || to_char(l_new_locality_adj),21);
5771: hr_utility.set_location('l_new_adj_basic_pay ' || to_char(l_new_adj_basic_pay),21);
5772: hr_utility.set_location('l_new_total_salary ' || to_char(l_new_total_salary),21);
5773: hr_utility.set_location('l_entitled_other_pay ' || to_char(l_entitled_other_pay),21);
5766: hr_utility.set_location('l_position_id ' || to_char(l_position_id),21);
5767: hr_utility.set_location('l_pay_basis ' || l_pay_basis,21);
5768: hr_utility.set_location('person_id ' || to_char(p_person_id),21);
5769: hr_utility.set_location('l_new_basic_pay ' || to_char(l_new_basic_pay),21);
5770: hr_utility.set_location('l_new_locality_adj ' || to_char(l_new_locality_adj),21);
5771: hr_utility.set_location('l_new_adj_basic_pay ' || to_char(l_new_adj_basic_pay),21);
5772: hr_utility.set_location('l_new_total_salary ' || to_char(l_new_total_salary),21);
5773: hr_utility.set_location('l_entitled_other_pay ' || to_char(l_entitled_other_pay),21);
5774: hr_utility.set_location('l_capped_other_pay ' || to_char(l_capped_other_pay),21);
5767: hr_utility.set_location('l_pay_basis ' || l_pay_basis,21);
5768: hr_utility.set_location('person_id ' || to_char(p_person_id),21);
5769: hr_utility.set_location('l_new_basic_pay ' || to_char(l_new_basic_pay),21);
5770: hr_utility.set_location('l_new_locality_adj ' || to_char(l_new_locality_adj),21);
5771: hr_utility.set_location('l_new_adj_basic_pay ' || to_char(l_new_adj_basic_pay),21);
5772: hr_utility.set_location('l_new_total_salary ' || to_char(l_new_total_salary),21);
5773: hr_utility.set_location('l_entitled_other_pay ' || to_char(l_entitled_other_pay),21);
5774: hr_utility.set_location('l_capped_other_pay ' || to_char(l_capped_other_pay),21);
5775: hr_utility.set_location('l_new_retention_allowance ' || to_char(l_new_retention_allowance),21);
5768: hr_utility.set_location('person_id ' || to_char(p_person_id),21);
5769: hr_utility.set_location('l_new_basic_pay ' || to_char(l_new_basic_pay),21);
5770: hr_utility.set_location('l_new_locality_adj ' || to_char(l_new_locality_adj),21);
5771: hr_utility.set_location('l_new_adj_basic_pay ' || to_char(l_new_adj_basic_pay),21);
5772: hr_utility.set_location('l_new_total_salary ' || to_char(l_new_total_salary),21);
5773: hr_utility.set_location('l_entitled_other_pay ' || to_char(l_entitled_other_pay),21);
5774: hr_utility.set_location('l_capped_other_pay ' || to_char(l_capped_other_pay),21);
5775: hr_utility.set_location('l_new_retention_allowance ' || to_char(l_new_retention_allowance),21);
5776: hr_utility.set_location('l_new_supervisory_differential ' || to_char(l_new_supervisory_differential),21);
5769: hr_utility.set_location('l_new_basic_pay ' || to_char(l_new_basic_pay),21);
5770: hr_utility.set_location('l_new_locality_adj ' || to_char(l_new_locality_adj),21);
5771: hr_utility.set_location('l_new_adj_basic_pay ' || to_char(l_new_adj_basic_pay),21);
5772: hr_utility.set_location('l_new_total_salary ' || to_char(l_new_total_salary),21);
5773: hr_utility.set_location('l_entitled_other_pay ' || to_char(l_entitled_other_pay),21);
5774: hr_utility.set_location('l_capped_other_pay ' || to_char(l_capped_other_pay),21);
5775: hr_utility.set_location('l_new_retention_allowance ' || to_char(l_new_retention_allowance),21);
5776: hr_utility.set_location('l_new_supervisory_differential ' || to_char(l_new_supervisory_differential),21);
5777: hr_utility.set_location('l_staffing_differential ' || to_char(l_staffing_differential),21);
5770: hr_utility.set_location('l_new_locality_adj ' || to_char(l_new_locality_adj),21);
5771: hr_utility.set_location('l_new_adj_basic_pay ' || to_char(l_new_adj_basic_pay),21);
5772: hr_utility.set_location('l_new_total_salary ' || to_char(l_new_total_salary),21);
5773: hr_utility.set_location('l_entitled_other_pay ' || to_char(l_entitled_other_pay),21);
5774: hr_utility.set_location('l_capped_other_pay ' || to_char(l_capped_other_pay),21);
5775: hr_utility.set_location('l_new_retention_allowance ' || to_char(l_new_retention_allowance),21);
5776: hr_utility.set_location('l_new_supervisory_differential ' || to_char(l_new_supervisory_differential),21);
5777: hr_utility.set_location('l_staffing_differential ' || to_char(l_staffing_differential),21);
5778: hr_utility.set_location('l_new_au_overtime ' || to_char(l_new_au_overtime),21);
5771: hr_utility.set_location('l_new_adj_basic_pay ' || to_char(l_new_adj_basic_pay),21);
5772: hr_utility.set_location('l_new_total_salary ' || to_char(l_new_total_salary),21);
5773: hr_utility.set_location('l_entitled_other_pay ' || to_char(l_entitled_other_pay),21);
5774: hr_utility.set_location('l_capped_other_pay ' || to_char(l_capped_other_pay),21);
5775: hr_utility.set_location('l_new_retention_allowance ' || to_char(l_new_retention_allowance),21);
5776: hr_utility.set_location('l_new_supervisory_differential ' || to_char(l_new_supervisory_differential),21);
5777: hr_utility.set_location('l_staffing_differential ' || to_char(l_staffing_differential),21);
5778: hr_utility.set_location('l_new_au_overtime ' || to_char(l_new_au_overtime),21);
5779: hr_utility.set_location('l_new_availability_pay ' || to_char(l_new_availability_pay),21);
5772: hr_utility.set_location('l_new_total_salary ' || to_char(l_new_total_salary),21);
5773: hr_utility.set_location('l_entitled_other_pay ' || to_char(l_entitled_other_pay),21);
5774: hr_utility.set_location('l_capped_other_pay ' || to_char(l_capped_other_pay),21);
5775: hr_utility.set_location('l_new_retention_allowance ' || to_char(l_new_retention_allowance),21);
5776: hr_utility.set_location('l_new_supervisory_differential ' || to_char(l_new_supervisory_differential),21);
5777: hr_utility.set_location('l_staffing_differential ' || to_char(l_staffing_differential),21);
5778: hr_utility.set_location('l_new_au_overtime ' || to_char(l_new_au_overtime),21);
5779: hr_utility.set_location('l_new_availability_pay ' || to_char(l_new_availability_pay),21);
5780: end if;
5773: hr_utility.set_location('l_entitled_other_pay ' || to_char(l_entitled_other_pay),21);
5774: hr_utility.set_location('l_capped_other_pay ' || to_char(l_capped_other_pay),21);
5775: hr_utility.set_location('l_new_retention_allowance ' || to_char(l_new_retention_allowance),21);
5776: hr_utility.set_location('l_new_supervisory_differential ' || to_char(l_new_supervisory_differential),21);
5777: hr_utility.set_location('l_staffing_differential ' || to_char(l_staffing_differential),21);
5778: hr_utility.set_location('l_new_au_overtime ' || to_char(l_new_au_overtime),21);
5779: hr_utility.set_location('l_new_availability_pay ' || to_char(l_new_availability_pay),21);
5780: end if;
5781:
5774: hr_utility.set_location('l_capped_other_pay ' || to_char(l_capped_other_pay),21);
5775: hr_utility.set_location('l_new_retention_allowance ' || to_char(l_new_retention_allowance),21);
5776: hr_utility.set_location('l_new_supervisory_differential ' || to_char(l_new_supervisory_differential),21);
5777: hr_utility.set_location('l_staffing_differential ' || to_char(l_staffing_differential),21);
5778: hr_utility.set_location('l_new_au_overtime ' || to_char(l_new_au_overtime),21);
5779: hr_utility.set_location('l_new_availability_pay ' || to_char(l_new_availability_pay),21);
5780: end if;
5781:
5782:
5775: hr_utility.set_location('l_new_retention_allowance ' || to_char(l_new_retention_allowance),21);
5776: hr_utility.set_location('l_new_supervisory_differential ' || to_char(l_new_supervisory_differential),21);
5777: hr_utility.set_location('l_staffing_differential ' || to_char(l_staffing_differential),21);
5778: hr_utility.set_location('l_new_au_overtime ' || to_char(l_new_au_overtime),21);
5779: hr_utility.set_location('l_new_availability_pay ' || to_char(l_new_availability_pay),21);
5780: end if;
5781:
5782:
5783: ghr_pay_caps.do_pay_caps_main
5811:
5812: l_new_other_pay_amount := nvl(l_capped_other_pay,l_entitled_other_pay);
5813:
5814: -- Sundar Added the following statement to improve performance
5815: if hr_utility.debug_enabled = true then
5816: hr_utility.set_location('After Pay Cap ' || l_proc,22);
5817: hr_utility.set_location('l_effective_date ' || l_effective_date,22);
5818: hr_utility.set_location('l_out_pay_rate_determinant ' || l_out_pay_rate_determinant,22);
5819: hr_utility.set_location('l_pay_plan ' || l_pay_plan,22);
5812: l_new_other_pay_amount := nvl(l_capped_other_pay,l_entitled_other_pay);
5813:
5814: -- Sundar Added the following statement to improve performance
5815: if hr_utility.debug_enabled = true then
5816: hr_utility.set_location('After Pay Cap ' || l_proc,22);
5817: hr_utility.set_location('l_effective_date ' || l_effective_date,22);
5818: hr_utility.set_location('l_out_pay_rate_determinant ' || l_out_pay_rate_determinant,22);
5819: hr_utility.set_location('l_pay_plan ' || l_pay_plan,22);
5820: hr_utility.set_location('l_position_id ' || to_char(l_position_id),22);
5813:
5814: -- Sundar Added the following statement to improve performance
5815: if hr_utility.debug_enabled = true then
5816: hr_utility.set_location('After Pay Cap ' || l_proc,22);
5817: hr_utility.set_location('l_effective_date ' || l_effective_date,22);
5818: hr_utility.set_location('l_out_pay_rate_determinant ' || l_out_pay_rate_determinant,22);
5819: hr_utility.set_location('l_pay_plan ' || l_pay_plan,22);
5820: hr_utility.set_location('l_position_id ' || to_char(l_position_id),22);
5821: hr_utility.set_location('l_pay_basis ' || l_pay_basis,22);
5814: -- Sundar Added the following statement to improve performance
5815: if hr_utility.debug_enabled = true then
5816: hr_utility.set_location('After Pay Cap ' || l_proc,22);
5817: hr_utility.set_location('l_effective_date ' || l_effective_date,22);
5818: hr_utility.set_location('l_out_pay_rate_determinant ' || l_out_pay_rate_determinant,22);
5819: hr_utility.set_location('l_pay_plan ' || l_pay_plan,22);
5820: hr_utility.set_location('l_position_id ' || to_char(l_position_id),22);
5821: hr_utility.set_location('l_pay_basis ' || l_pay_basis,22);
5822: hr_utility.set_location('person_id ' || to_char(p_person_id),22);
5815: if hr_utility.debug_enabled = true then
5816: hr_utility.set_location('After Pay Cap ' || l_proc,22);
5817: hr_utility.set_location('l_effective_date ' || l_effective_date,22);
5818: hr_utility.set_location('l_out_pay_rate_determinant ' || l_out_pay_rate_determinant,22);
5819: hr_utility.set_location('l_pay_plan ' || l_pay_plan,22);
5820: hr_utility.set_location('l_position_id ' || to_char(l_position_id),22);
5821: hr_utility.set_location('l_pay_basis ' || l_pay_basis,22);
5822: hr_utility.set_location('person_id ' || to_char(p_person_id),22);
5823: hr_utility.set_location('l_new_basic_pay ' || to_char(l_new_basic_pay),22);
5816: hr_utility.set_location('After Pay Cap ' || l_proc,22);
5817: hr_utility.set_location('l_effective_date ' || l_effective_date,22);
5818: hr_utility.set_location('l_out_pay_rate_determinant ' || l_out_pay_rate_determinant,22);
5819: hr_utility.set_location('l_pay_plan ' || l_pay_plan,22);
5820: hr_utility.set_location('l_position_id ' || to_char(l_position_id),22);
5821: hr_utility.set_location('l_pay_basis ' || l_pay_basis,22);
5822: hr_utility.set_location('person_id ' || to_char(p_person_id),22);
5823: hr_utility.set_location('l_new_basic_pay ' || to_char(l_new_basic_pay),22);
5824: hr_utility.set_location('l_new_locality_adj ' || to_char(l_new_locality_adj),22);
5817: hr_utility.set_location('l_effective_date ' || l_effective_date,22);
5818: hr_utility.set_location('l_out_pay_rate_determinant ' || l_out_pay_rate_determinant,22);
5819: hr_utility.set_location('l_pay_plan ' || l_pay_plan,22);
5820: hr_utility.set_location('l_position_id ' || to_char(l_position_id),22);
5821: hr_utility.set_location('l_pay_basis ' || l_pay_basis,22);
5822: hr_utility.set_location('person_id ' || to_char(p_person_id),22);
5823: hr_utility.set_location('l_new_basic_pay ' || to_char(l_new_basic_pay),22);
5824: hr_utility.set_location('l_new_locality_adj ' || to_char(l_new_locality_adj),22);
5825: hr_utility.set_location('l_new_adj_basic_pay ' || to_char(l_new_adj_basic_pay),22);
5818: hr_utility.set_location('l_out_pay_rate_determinant ' || l_out_pay_rate_determinant,22);
5819: hr_utility.set_location('l_pay_plan ' || l_pay_plan,22);
5820: hr_utility.set_location('l_position_id ' || to_char(l_position_id),22);
5821: hr_utility.set_location('l_pay_basis ' || l_pay_basis,22);
5822: hr_utility.set_location('person_id ' || to_char(p_person_id),22);
5823: hr_utility.set_location('l_new_basic_pay ' || to_char(l_new_basic_pay),22);
5824: hr_utility.set_location('l_new_locality_adj ' || to_char(l_new_locality_adj),22);
5825: hr_utility.set_location('l_new_adj_basic_pay ' || to_char(l_new_adj_basic_pay),22);
5826: hr_utility.set_location('l_new_total_salary ' || to_char(l_new_total_salary),22);
5819: hr_utility.set_location('l_pay_plan ' || l_pay_plan,22);
5820: hr_utility.set_location('l_position_id ' || to_char(l_position_id),22);
5821: hr_utility.set_location('l_pay_basis ' || l_pay_basis,22);
5822: hr_utility.set_location('person_id ' || to_char(p_person_id),22);
5823: hr_utility.set_location('l_new_basic_pay ' || to_char(l_new_basic_pay),22);
5824: hr_utility.set_location('l_new_locality_adj ' || to_char(l_new_locality_adj),22);
5825: hr_utility.set_location('l_new_adj_basic_pay ' || to_char(l_new_adj_basic_pay),22);
5826: hr_utility.set_location('l_new_total_salary ' || to_char(l_new_total_salary),22);
5827: hr_utility.set_location('l_entitled_other_pay ' || to_char(l_entitled_other_pay),22);
5820: hr_utility.set_location('l_position_id ' || to_char(l_position_id),22);
5821: hr_utility.set_location('l_pay_basis ' || l_pay_basis,22);
5822: hr_utility.set_location('person_id ' || to_char(p_person_id),22);
5823: hr_utility.set_location('l_new_basic_pay ' || to_char(l_new_basic_pay),22);
5824: hr_utility.set_location('l_new_locality_adj ' || to_char(l_new_locality_adj),22);
5825: hr_utility.set_location('l_new_adj_basic_pay ' || to_char(l_new_adj_basic_pay),22);
5826: hr_utility.set_location('l_new_total_salary ' || to_char(l_new_total_salary),22);
5827: hr_utility.set_location('l_entitled_other_pay ' || to_char(l_entitled_other_pay),22);
5828: hr_utility.set_location('l_capped_other_pay ' || to_char(l_capped_other_pay),22);
5821: hr_utility.set_location('l_pay_basis ' || l_pay_basis,22);
5822: hr_utility.set_location('person_id ' || to_char(p_person_id),22);
5823: hr_utility.set_location('l_new_basic_pay ' || to_char(l_new_basic_pay),22);
5824: hr_utility.set_location('l_new_locality_adj ' || to_char(l_new_locality_adj),22);
5825: hr_utility.set_location('l_new_adj_basic_pay ' || to_char(l_new_adj_basic_pay),22);
5826: hr_utility.set_location('l_new_total_salary ' || to_char(l_new_total_salary),22);
5827: hr_utility.set_location('l_entitled_other_pay ' || to_char(l_entitled_other_pay),22);
5828: hr_utility.set_location('l_capped_other_pay ' || to_char(l_capped_other_pay),22);
5829: hr_utility.set_location('l_new_retention_allowance ' || to_char(l_new_retention_allowance),22);
5822: hr_utility.set_location('person_id ' || to_char(p_person_id),22);
5823: hr_utility.set_location('l_new_basic_pay ' || to_char(l_new_basic_pay),22);
5824: hr_utility.set_location('l_new_locality_adj ' || to_char(l_new_locality_adj),22);
5825: hr_utility.set_location('l_new_adj_basic_pay ' || to_char(l_new_adj_basic_pay),22);
5826: hr_utility.set_location('l_new_total_salary ' || to_char(l_new_total_salary),22);
5827: hr_utility.set_location('l_entitled_other_pay ' || to_char(l_entitled_other_pay),22);
5828: hr_utility.set_location('l_capped_other_pay ' || to_char(l_capped_other_pay),22);
5829: hr_utility.set_location('l_new_retention_allowance ' || to_char(l_new_retention_allowance),22);
5830: hr_utility.set_location('l_new_supervisory_differential ' || to_char(l_new_supervisory_differential),22);
5823: hr_utility.set_location('l_new_basic_pay ' || to_char(l_new_basic_pay),22);
5824: hr_utility.set_location('l_new_locality_adj ' || to_char(l_new_locality_adj),22);
5825: hr_utility.set_location('l_new_adj_basic_pay ' || to_char(l_new_adj_basic_pay),22);
5826: hr_utility.set_location('l_new_total_salary ' || to_char(l_new_total_salary),22);
5827: hr_utility.set_location('l_entitled_other_pay ' || to_char(l_entitled_other_pay),22);
5828: hr_utility.set_location('l_capped_other_pay ' || to_char(l_capped_other_pay),22);
5829: hr_utility.set_location('l_new_retention_allowance ' || to_char(l_new_retention_allowance),22);
5830: hr_utility.set_location('l_new_supervisory_differential ' || to_char(l_new_supervisory_differential),22);
5831: hr_utility.set_location('l_staffing_differential ' || to_char(l_staffing_differential),22);
5824: hr_utility.set_location('l_new_locality_adj ' || to_char(l_new_locality_adj),22);
5825: hr_utility.set_location('l_new_adj_basic_pay ' || to_char(l_new_adj_basic_pay),22);
5826: hr_utility.set_location('l_new_total_salary ' || to_char(l_new_total_salary),22);
5827: hr_utility.set_location('l_entitled_other_pay ' || to_char(l_entitled_other_pay),22);
5828: hr_utility.set_location('l_capped_other_pay ' || to_char(l_capped_other_pay),22);
5829: hr_utility.set_location('l_new_retention_allowance ' || to_char(l_new_retention_allowance),22);
5830: hr_utility.set_location('l_new_supervisory_differential ' || to_char(l_new_supervisory_differential),22);
5831: hr_utility.set_location('l_staffing_differential ' || to_char(l_staffing_differential),22);
5832: hr_utility.set_location('l_new_au_overtime ' || to_char(l_new_au_overtime),22);
5825: hr_utility.set_location('l_new_adj_basic_pay ' || to_char(l_new_adj_basic_pay),22);
5826: hr_utility.set_location('l_new_total_salary ' || to_char(l_new_total_salary),22);
5827: hr_utility.set_location('l_entitled_other_pay ' || to_char(l_entitled_other_pay),22);
5828: hr_utility.set_location('l_capped_other_pay ' || to_char(l_capped_other_pay),22);
5829: hr_utility.set_location('l_new_retention_allowance ' || to_char(l_new_retention_allowance),22);
5830: hr_utility.set_location('l_new_supervisory_differential ' || to_char(l_new_supervisory_differential),22);
5831: hr_utility.set_location('l_staffing_differential ' || to_char(l_staffing_differential),22);
5832: hr_utility.set_location('l_new_au_overtime ' || to_char(l_new_au_overtime),22);
5833: hr_utility.set_location('l_new_availability_pay ' || to_char(l_new_availability_pay),22);
5826: hr_utility.set_location('l_new_total_salary ' || to_char(l_new_total_salary),22);
5827: hr_utility.set_location('l_entitled_other_pay ' || to_char(l_entitled_other_pay),22);
5828: hr_utility.set_location('l_capped_other_pay ' || to_char(l_capped_other_pay),22);
5829: hr_utility.set_location('l_new_retention_allowance ' || to_char(l_new_retention_allowance),22);
5830: hr_utility.set_location('l_new_supervisory_differential ' || to_char(l_new_supervisory_differential),22);
5831: hr_utility.set_location('l_staffing_differential ' || to_char(l_staffing_differential),22);
5832: hr_utility.set_location('l_new_au_overtime ' || to_char(l_new_au_overtime),22);
5833: hr_utility.set_location('l_new_availability_pay ' || to_char(l_new_availability_pay),22);
5834: end if;
5827: hr_utility.set_location('l_entitled_other_pay ' || to_char(l_entitled_other_pay),22);
5828: hr_utility.set_location('l_capped_other_pay ' || to_char(l_capped_other_pay),22);
5829: hr_utility.set_location('l_new_retention_allowance ' || to_char(l_new_retention_allowance),22);
5830: hr_utility.set_location('l_new_supervisory_differential ' || to_char(l_new_supervisory_differential),22);
5831: hr_utility.set_location('l_staffing_differential ' || to_char(l_staffing_differential),22);
5832: hr_utility.set_location('l_new_au_overtime ' || to_char(l_new_au_overtime),22);
5833: hr_utility.set_location('l_new_availability_pay ' || to_char(l_new_availability_pay),22);
5834: end if;
5835:
5828: hr_utility.set_location('l_capped_other_pay ' || to_char(l_capped_other_pay),22);
5829: hr_utility.set_location('l_new_retention_allowance ' || to_char(l_new_retention_allowance),22);
5830: hr_utility.set_location('l_new_supervisory_differential ' || to_char(l_new_supervisory_differential),22);
5831: hr_utility.set_location('l_staffing_differential ' || to_char(l_staffing_differential),22);
5832: hr_utility.set_location('l_new_au_overtime ' || to_char(l_new_au_overtime),22);
5833: hr_utility.set_location('l_new_availability_pay ' || to_char(l_new_availability_pay),22);
5834: end if;
5835:
5836: IF l_pay_cap_message THEN
5829: hr_utility.set_location('l_new_retention_allowance ' || to_char(l_new_retention_allowance),22);
5830: hr_utility.set_location('l_new_supervisory_differential ' || to_char(l_new_supervisory_differential),22);
5831: hr_utility.set_location('l_staffing_differential ' || to_char(l_staffing_differential),22);
5832: hr_utility.set_location('l_new_au_overtime ' || to_char(l_new_au_overtime),22);
5833: hr_utility.set_location('l_new_availability_pay ' || to_char(l_new_availability_pay),22);
5834: end if;
5835:
5836: IF l_pay_cap_message THEN
5837: IF nvl(l_temp_retention_allowance,0) > 0 THEN
5873: exception
5874: when msl_error then
5875: raise;
5876: when others then
5877: hr_utility.set_location('Error in ghr_pay_caps.do_pay_caps_main ' ||
5878: 'Err is '||sqlerrm(sqlcode),23);
5879: l_mslerrbuf := 'Error in do_pay_caps_main Sql Err is '|| sqlerrm(sqlcode);
5880: raise msl_error;
5881: end;
5957: l_grade_or_level, l_step_or_rate,
5958: l_pay_basis);
5959: EXCEPTION
5960: when msl_error then
5961: l_mslerrbuf := hr_utility.get_message;
5962: raise;
5963: END;
5964: assign_to_sf52_rec(
5965: p_person_id,
6086:
6087: COMMIT;
6088: ELSE
6089: pr('Error in create sf52',l_errbuf);
6090: hr_utility.set_location('Error in '||to_char(p_position_id),20);
6091: l_recs_failed := l_recs_failed + 1;
6092: -- Error raising is not required as the error is written to process
6093: -- log in the create_sf52_for_mass_changes procedure.
6094: --raise msl_error;
6112: END IF;
6113: END IF;
6114: EXCEPTION
6115: WHEN MSL_ERROR THEN
6116: HR_UTILITY.SET_LOCATION('Error occurred in '||l_proc||' Sql error '||sqlerrm(sqlcode),10);
6117: begin
6118: ------ BUG 3287299 -- Not to rollback for preview.
6119: if upper(p_action) <> 'SHOW' then
6120: ROLLBACK TO execute_msl_perc_SP;
6125: l_log_text := 'Error in '||l_proc||' '||
6126: ' For Mass Salary Name : '||p_mass_salary||
6127: 'Name: '|| p_full_name || ' SSN: ' || p_national_identifier ||' '||
6128: l_mslerrbuf;
6129: hr_utility.set_location('before creating entry in log file',10);
6130: l_recs_failed := l_recs_failed + 1;
6131: begin
6132: ghr_mto_int.log_message(
6133: p_procedure => g_proc,
6134: p_message => l_log_text);
6135:
6136: exception
6137: when others then
6138: hr_utility.set_message(8301, 'GHR_38475_ERROR_LOG_FAILURE');
6139: hr_utility.raise_error;
6140: end;
6141: when others then
6142: HR_UTILITY.SET_LOCATION('Error (Others) occurred in '||l_proc||' Sql error '||sqlerrm(sqlcode),20);
6135:
6136: exception
6137: when others then
6138: hr_utility.set_message(8301, 'GHR_38475_ERROR_LOG_FAILURE');
6139: hr_utility.raise_error;
6140: end;
6141: when others then
6142: HR_UTILITY.SET_LOCATION('Error (Others) occurred in '||l_proc||' Sql error '||sqlerrm(sqlcode),20);
6143: BEGIN
6138: hr_utility.set_message(8301, 'GHR_38475_ERROR_LOG_FAILURE');
6139: hr_utility.raise_error;
6140: end;
6141: when others then
6142: HR_UTILITY.SET_LOCATION('Error (Others) occurred in '||l_proc||' Sql error '||sqlerrm(sqlcode),20);
6143: BEGIN
6144: ROLLBACK TO execute_msl_perc_SP;
6145: EXCEPTION
6146: WHEN OTHERS THEN NULL;
6148: l_log_text := 'Error (others) in '||l_proc||
6149: ' For Mass Salary Name : '||p_mass_salary||
6150: 'Name: '|| p_full_name || ' SSN: ' || p_national_identifier ||
6151: ' Sql Err is '||sqlerrm(sqlcode);
6152: hr_utility.set_location('before creating entry in log file',20);
6153: l_recs_failed := l_recs_failed + 1;
6154: begin
6155: ghr_mto_int.log_message(
6156: p_procedure => g_proc,
6157: p_message => l_log_text);
6158:
6159: exception
6160: when others then
6161: hr_utility.set_message(8301, 'Create Error Log failed');
6162: hr_utility.raise_error;
6163: end;
6164:
6165:
6158:
6159: exception
6160: when others then
6161: hr_utility.set_message(8301, 'Create Error Log failed');
6162: hr_utility.raise_error;
6163: end;
6164:
6165:
6166: END msl_perc_process;
6167:
6168: BEGIN
6169:
6170: g_proc := 'execute_msl_perc';
6171: hr_utility.set_location('Entering ' || l_proc,5);
6172: p_retcode := 0;
6173:
6174: g_first_noa_code := null;
6175: BEGIN
6195: exit;
6196: END LOOP;
6197: EXCEPTION
6198: when REC_BUSY then
6199: hr_utility.set_location('Mass Salary is in use',1);
6200: l_mslerrbuf := 'Error in '||l_proc||' Sql Err is '|| sqlerrm(sqlcode);
6201: -- raise error;
6202: hr_utility.set_message(8301, 'GHR_38477_LOCK_ON_MSL');
6203: hr_utility.raise_error;
6198: when REC_BUSY then
6199: hr_utility.set_location('Mass Salary is in use',1);
6200: l_mslerrbuf := 'Error in '||l_proc||' Sql Err is '|| sqlerrm(sqlcode);
6201: -- raise error;
6202: hr_utility.set_message(8301, 'GHR_38477_LOCK_ON_MSL');
6203: hr_utility.raise_error;
6204: --
6205: when others then
6206: hr_utility.set_location('Error in '||l_proc||' Sql err is '||sqlerrm(sqlcode),1);
6199: hr_utility.set_location('Mass Salary is in use',1);
6200: l_mslerrbuf := 'Error in '||l_proc||' Sql Err is '|| sqlerrm(sqlcode);
6201: -- raise error;
6202: hr_utility.set_message(8301, 'GHR_38477_LOCK_ON_MSL');
6203: hr_utility.raise_error;
6204: --
6205: when others then
6206: hr_utility.set_location('Error in '||l_proc||' Sql err is '||sqlerrm(sqlcode),1);
6207: -- raise_application_error(-20111,'Error while selecting from Ghr Mass Salaries');
6202: hr_utility.set_message(8301, 'GHR_38477_LOCK_ON_MSL');
6203: hr_utility.raise_error;
6204: --
6205: when others then
6206: hr_utility.set_location('Error in '||l_proc||' Sql err is '||sqlerrm(sqlcode),1);
6207: -- raise_application_error(-20111,'Error while selecting from Ghr Mass Salaries');
6208: l_mslerrbuf := 'Error in '||l_proc||' Sql Err is '|| sqlerrm(sqlcode);
6209: raise msl_error;
6210: END;
6236:
6237: -- Commented out by Edward Nunez. It's not needed anymore with 894 rules
6238: -- IF upper(p_action) = 'CREATE' then
6239: -- if l_pa_request_id is null then
6240: -- hr_utility.set_message(8301, 'GHR_99999_SELECT_LAC_REMARKS');
6241: -- hr_utility.raise_error;
6242: -- END IF;
6243: -- END IF;
6244:
6237: -- Commented out by Edward Nunez. It's not needed anymore with 894 rules
6238: -- IF upper(p_action) = 'CREATE' then
6239: -- if l_pa_request_id is null then
6240: -- hr_utility.set_message(8301, 'GHR_99999_SELECT_LAC_REMARKS');
6241: -- hr_utility.raise_error;
6242: -- END IF;
6243: -- END IF;
6244:
6245: get_lac_dtls(l_pa_request_id,
6246: l_lac_sf52_rec);
6247:
6248: --purge_old_data(l_mass_salary_id);
6249:
6250: hr_utility.set_location('After fetch msl '||to_char(l_effective_date)
6251: ||' '||to_char(l_user_table_id),20);
6252:
6253: IF l_p_ORGANIZATION_ID is not null then
6254: FOR per IN cur_people_org (l_effective_date,l_p_ORGANIZATION_ID)
6492: set submit_flag = 'P'
6493: where rowid = l_rowid;
6494: EXCEPTION
6495: when others then
6496: HR_UTILITY.SET_LOCATION('Error in Update ghr_msl Sql error '||sqlerrm(sqlcode),30);
6497: hr_utility.set_message(8301, 'GHR_38476_UPD_GHR_MSL_FAILURE');
6498: hr_utility.raise_error;
6499: END;
6500: -----Bug 2849262. Updating extra info to null is already done by Update_sel_flg in the main loop.
6493: where rowid = l_rowid;
6494: EXCEPTION
6495: when others then
6496: HR_UTILITY.SET_LOCATION('Error in Update ghr_msl Sql error '||sqlerrm(sqlcode),30);
6497: hr_utility.set_message(8301, 'GHR_38476_UPD_GHR_MSL_FAILURE');
6498: hr_utility.raise_error;
6499: END;
6500: -----Bug 2849262. Updating extra info to null is already done by Update_sel_flg in the main loop.
6501: ----- So it is not required to do in global if you see the procedure upd_ext_info_to_null
6494: EXCEPTION
6495: when others then
6496: HR_UTILITY.SET_LOCATION('Error in Update ghr_msl Sql error '||sqlerrm(sqlcode),30);
6497: hr_utility.set_message(8301, 'GHR_38476_UPD_GHR_MSL_FAILURE');
6498: hr_utility.raise_error;
6499: END;
6500: -----Bug 2849262. Updating extra info to null is already done by Update_sel_flg in the main loop.
6501: ----- So it is not required to do in global if you see the procedure upd_ext_info_to_null
6502: ----- Commenting the following line. Dated 14-OCT-2003.
6519:
6520: EXCEPTION
6521: when others then
6522: -- raise_application_error(-20121,'Error in execute_msl_perc Err is '||sqlerrm(sqlcode));
6523: HR_UTILITY.SET_LOCATION('Error (Others2) occurred in '||l_proc||' Sql error '||sqlerrm(sqlcode),30);
6524: BEGIN
6525: ROLLBACK TO execute_msl_perc_SP;
6526: EXCEPTION
6527: WHEN OTHERS THEN NULL;
6529: l_log_text := 'Error in '||l_proc||
6530: ' For Mass Salary Name : '||p_mass_salary||
6531: ' Sql Err is '||sqlerrm(sqlcode);
6532: l_recs_failed := l_recs_failed + 1;
6533: hr_utility.set_location('before creating entry in log file',30);
6534:
6535: p_errbuf := 'Error in '||l_proc || ' Details in GHR_PROCESS_LOG';
6536: p_retcode := 2;
6537: IF upper(p_action) = 'CREATE' THEN
6547: p_message => l_log_text);
6548:
6549: exception
6550: when others then
6551: hr_utility.set_message(8301, 'Create Error Log failed');
6552: hr_utility.raise_error;
6553: end;
6554:
6555: END execute_msl_perc;
6548:
6549: exception
6550: when others then
6551: hr_utility.set_message(8301, 'Create Error Log failed');
6552: hr_utility.raise_error;
6553: end;
6554:
6555: END execute_msl_perc;
6556: -- 3843306
6672:
6673: BEGIN
6674:
6675: g_proc := 'fetch_and_validate_emp_ses';
6676: hr_utility.set_location('Entering ' || l_proc,5);
6677:
6678: -- Bug#5623035 Moved the local variable assigning to here.
6679: l_assignment_id := p_assignment_id;
6680: l_position_id := p_position_id;
6690: p_msl_agency_code_subelement IS NOT NULL THEN
6691: -- get the values and verify whether the record meets the condition or not.
6692: -- If Yes, proceed further. Otherwise, skip the other checks for this record
6693:
6694: hr_utility.set_location('The location id is:'||l_location_id,12345);
6695: hr_utility.set_location('MSL Org ID:'||p_msl_organization_id,11111);
6696: hr_utility.set_location('Org ID:'||p_organization_id,22222);
6697: IF NVL(p_msl_organization_id,p_organization_id) = p_organization_id THEN
6698: hr_utility.set_location('Org ID PASS',10);
6691: -- get the values and verify whether the record meets the condition or not.
6692: -- If Yes, proceed further. Otherwise, skip the other checks for this record
6693:
6694: hr_utility.set_location('The location id is:'||l_location_id,12345);
6695: hr_utility.set_location('MSL Org ID:'||p_msl_organization_id,11111);
6696: hr_utility.set_location('Org ID:'||p_organization_id,22222);
6697: IF NVL(p_msl_organization_id,p_organization_id) = p_organization_id THEN
6698: hr_utility.set_location('Org ID PASS',10);
6699: IF p_msl_personnel_office_id IS NOT NULL THEN
6692: -- If Yes, proceed further. Otherwise, skip the other checks for this record
6693:
6694: hr_utility.set_location('The location id is:'||l_location_id,12345);
6695: hr_utility.set_location('MSL Org ID:'||p_msl_organization_id,11111);
6696: hr_utility.set_location('Org ID:'||p_organization_id,22222);
6697: IF NVL(p_msl_organization_id,p_organization_id) = p_organization_id THEN
6698: hr_utility.set_location('Org ID PASS',10);
6699: IF p_msl_personnel_office_id IS NOT NULL THEN
6700: hr_utility.set_location('POID CHECK',15);
6694: hr_utility.set_location('The location id is:'||l_location_id,12345);
6695: hr_utility.set_location('MSL Org ID:'||p_msl_organization_id,11111);
6696: hr_utility.set_location('Org ID:'||p_organization_id,22222);
6697: IF NVL(p_msl_organization_id,p_organization_id) = p_organization_id THEN
6698: hr_utility.set_location('Org ID PASS',10);
6699: IF p_msl_personnel_office_id IS NOT NULL THEN
6700: hr_utility.set_location('POID CHECK',15);
6701: get_pos_grp1_ddf(l_position_id,
6702: l_effective_date,
6696: hr_utility.set_location('Org ID:'||p_organization_id,22222);
6697: IF NVL(p_msl_organization_id,p_organization_id) = p_organization_id THEN
6698: hr_utility.set_location('Org ID PASS',10);
6699: IF p_msl_personnel_office_id IS NOT NULL THEN
6700: hr_utility.set_location('POID CHECK',15);
6701: get_pos_grp1_ddf(l_position_id,
6702: l_effective_date,
6703: l_pos_grp1_rec);
6704:
6708: END IF;
6709: IF (p_msl_personnel_office_id = l_personnel_office_id) OR
6710: NOT(l_fetch_poid_data) THEN
6711:
6712: hr_utility.set_location('POID PASS',20);
6713: IF p_msl_agency_code_subelement IS NOT NULL THEN
6714: hr_utility.set_location('Agency CHECK',25);
6715: get_sub_element_code_pos_title(l_position_id,
6716: p_person_id,
6710: NOT(l_fetch_poid_data) THEN
6711:
6712: hr_utility.set_location('POID PASS',20);
6713: IF p_msl_agency_code_subelement IS NOT NULL THEN
6714: hr_utility.set_location('Agency CHECK',25);
6715: get_sub_element_code_pos_title(l_position_id,
6716: p_person_id,
6717: l_business_group_id,
6718: l_assignment_id,
6728: NVL(SUBSTR(p_msl_agency_code_subelement,3,2),SUBSTR(l_sub_element_code,3,2))=
6729: SUBSTR(l_sub_element_code,3,2)
6730: ) OR
6731: NOT(l_fetch_agency_data) THEN
6732: hr_utility.set_location('Agency PASS',30);
6733: IF p_msl_duty_station_id IS NOT NULL THEN
6734: hr_utility.set_location('DS CHECK',35);
6735: ghr_pa_requests_pkg.get_SF52_loc_ddf_details
6736: (p_location_id => l_location_id
6730: ) OR
6731: NOT(l_fetch_agency_data) THEN
6732: hr_utility.set_location('Agency PASS',30);
6733: IF p_msl_duty_station_id IS NOT NULL THEN
6734: hr_utility.set_location('DS CHECK',35);
6735: ghr_pa_requests_pkg.get_SF52_loc_ddf_details
6736: (p_location_id => l_location_id
6737: ,p_duty_station_id => l_duty_station_id);
6738: l_fetch_ds_data := TRUE;
6738: l_fetch_ds_data := TRUE;
6739: END IF;
6740: IF (p_msl_duty_station_id = l_duty_station_id) OR
6741: NOT(l_fetch_ds_data)THEN
6742: hr_utility.set_location('DS PASS',40);
6743: init_elig_flag := TRUE;
6744: ELSE -- Duty Station not matching.
6745: hr_utility.set_location('DS FAIL',45);
6746: init_elig_flag := FALSE;
6741: NOT(l_fetch_ds_data)THEN
6742: hr_utility.set_location('DS PASS',40);
6743: init_elig_flag := TRUE;
6744: ELSE -- Duty Station not matching.
6745: hr_utility.set_location('DS FAIL',45);
6746: init_elig_flag := FALSE;
6747: END IF;
6748: ELSE -- Agency Code Subelement Not matching.
6749: hr_utility.set_location('Agency FAIL',55);
6745: hr_utility.set_location('DS FAIL',45);
6746: init_elig_flag := FALSE;
6747: END IF;
6748: ELSE -- Agency Code Subelement Not matching.
6749: hr_utility.set_location('Agency FAIL',55);
6750: init_elig_flag := FALSE;
6751: END IF;
6752: ELSE -- Personnel Office ID not matching
6753: hr_utility.set_location('POID FAIL',65);
6749: hr_utility.set_location('Agency FAIL',55);
6750: init_elig_flag := FALSE;
6751: END IF;
6752: ELSE -- Personnel Office ID not matching
6753: hr_utility.set_location('POID FAIL',65);
6754: init_elig_flag := FALSE;
6755: END IF;
6756: ELSE -- Organization_id is not matching.
6757: hr_utility.set_location('Org FAIL',75);
6753: hr_utility.set_location('POID FAIL',65);
6754: init_elig_flag := FALSE;
6755: END IF;
6756: ELSE -- Organization_id is not matching.
6757: hr_utility.set_location('Org FAIL',75);
6758: init_elig_flag := FALSE;
6759: END IF;
6760: ELSE -- If No value is entered for organization, Duty Station, Agency, POID of MSL Criteria.
6761: hr_utility.set_location('No INIT CRITERIA',85);
6757: hr_utility.set_location('Org FAIL',75);
6758: init_elig_flag := FALSE;
6759: END IF;
6760: ELSE -- If No value is entered for organization, Duty Station, Agency, POID of MSL Criteria.
6761: hr_utility.set_location('No INIT CRITERIA',85);
6762: init_elig_flag := TRUE;
6763: END IF;
6764:
6765: -- If the initial eligibility is passed then proceed further. Otherwise move to next record.
6763: END IF;
6764:
6765: -- If the initial eligibility is passed then proceed further. Otherwise move to next record.
6766: IF init_elig_flag THEN
6767: hr_utility.set_location('Init Criteria Pass',95);
6768: ghr_pa_requests_pkg.get_sf52_asg_ddf_details
6769: (l_assignment_id,
6770: l_effective_date,
6771: l_tenure,
6775: l_part_time_hour);
6776:
6777: FOR l_cnt in 1..p_rec_pp_prd.COUNT LOOP
6778: IF nvl(p_rec_pp_prd(l_cnt).prd,l_pay_rate_determinant) = l_pay_rate_determinant THEN
6779: hr_utility.set_location('PRD PASS',105);
6780: l_prd_matched := TRUE;
6781: exit;
6782: END IF;
6783: END LOOP;
6796: EXCEPTION
6797: WHEN OTHERS THEN
6798: -- Report the record in the process log if the pay table ID matches.
6799: BEGIN
6800: hr_utility.set_location('before calling expired_rg_det',10);
6801: l_retained_grade_rec := ghr_pc_basic_pay.get_expired_rg_details
6802: (p_person_id => p_person_id
6803: ,p_effective_date => l_effective_date);
6804: hr_utility.set_location('ret grd tableid:'||l_retained_grade_rec.user_table_id,99999);
6800: hr_utility.set_location('before calling expired_rg_det',10);
6801: l_retained_grade_rec := ghr_pc_basic_pay.get_expired_rg_details
6802: (p_person_id => p_person_id
6803: ,p_effective_date => l_effective_date);
6804: hr_utility.set_location('ret grd tableid:'||l_retained_grade_rec.user_table_id,99999);
6805: hr_utility.set_location('MSL tableid:'||p_msl_user_table_id,99999);
6806: IF l_retained_grade_rec.user_table_id = p_msl_user_table_id THEN
6807: hr_utility.set_location('Rg table matches with MSL table ID',10);
6808: l_log_text := 'Error in RG Record In Mass Salary Name: '||
6801: l_retained_grade_rec := ghr_pc_basic_pay.get_expired_rg_details
6802: (p_person_id => p_person_id
6803: ,p_effective_date => l_effective_date);
6804: hr_utility.set_location('ret grd tableid:'||l_retained_grade_rec.user_table_id,99999);
6805: hr_utility.set_location('MSL tableid:'||p_msl_user_table_id,99999);
6806: IF l_retained_grade_rec.user_table_id = p_msl_user_table_id THEN
6807: hr_utility.set_location('Rg table matches with MSL table ID',10);
6808: l_log_text := 'Error in RG Record In Mass Salary Name: '||
6809: p_mass_salary_name||'; Employee Name: '|| p_full_name ||
6803: ,p_effective_date => l_effective_date);
6804: hr_utility.set_location('ret grd tableid:'||l_retained_grade_rec.user_table_id,99999);
6805: hr_utility.set_location('MSL tableid:'||p_msl_user_table_id,99999);
6806: IF l_retained_grade_rec.user_table_id = p_msl_user_table_id THEN
6807: hr_utility.set_location('Rg table matches with MSL table ID',10);
6808: l_log_text := 'Error in RG Record In Mass Salary Name: '||
6809: p_mass_salary_name||'; Employee Name: '|| p_full_name ||
6810: '; SSN: ' || p_national_identifier || '; '||
6811: hr_utility.get_message;
6807: hr_utility.set_location('Rg table matches with MSL table ID',10);
6808: l_log_text := 'Error in RG Record In Mass Salary Name: '||
6809: p_mass_salary_name||'; Employee Name: '|| p_full_name ||
6810: '; SSN: ' || p_national_identifier || '; '||
6811: hr_utility.get_message;
6812: BEGIN
6813: ghr_mto_int.log_message(
6814: p_procedure => 'check_grade_retention',
6815: p_message => l_log_text);
6822: l_prd_pp_matched := FALSE;
6823: END IF;
6824: EXCEPTION
6825: WHEN OTHERS THEN
6826: hr_utility.set_location('WHEN OTHERS of EXPIRED RG ',999999);
6827: l_prd_pp_matched := FALSE;
6828: END;
6829: --WHEN OTHERS THEN
6830: -- Skip this record from reporting.
6834:
6835: FOR l_cnt in 1..p_rec_pp_prd.COUNT LOOP
6836: IF nvl(p_rec_pp_prd(l_cnt).prd,l_pay_rate_determinant) = l_pay_rate_determinant AND
6837: nvl(p_rec_pp_prd(l_cnt).pay_plan,l_pay_plan) = l_pay_plan THEN
6838: hr_utility.set_location('PP/PRD PASS',115);
6839: l_prd_pp_matched := TRUE;
6840: exit;
6841: END IF;
6842: END LOOP;
6868: --5470182
6869:
6870: IF l_rat_matched THEN
6871: IF l_pay_table_id = p_msl_user_table_id THEN
6872: hr_utility.set_location('Table ID PASS',125);
6873: IF NOT (p_action = 'CREATE' AND
6874: person_in_pa_req_1noa
6875: (p_person_id => p_person_id,
6876: p_effective_date => l_effective_date,
6886: END IF;
6887: END LOOP;
6888:
6889: IF l_row_cnt <> 0 THEN
6890: hr_utility.set_location('ROW COUNT PASS',135);
6891: -- Get the required details if the related check has not been done above.
6892: IF NOT l_fetch_poid_data THEN
6893:
6894: get_pos_grp1_ddf(l_position_id,
6942: -- Raise Error
6943: NULL;
6944: END IF;
6945: ELSE -- Not (Create and RPA exists)
6946: hr_utility.set_location('ROW COUNT FAIL',145);
6947: p_elig_flag := FALSE;
6948: END IF;
6949: ELSE -- Pay table id is not matched
6950: hr_utility.set_location('Pay Table FAIL',155);
6946: hr_utility.set_location('ROW COUNT FAIL',145);
6947: p_elig_flag := FALSE;
6948: END IF;
6949: ELSE -- Pay table id is not matched
6950: hr_utility.set_location('Pay Table FAIL',155);
6951: p_elig_flag := FALSE;
6952: END IF;
6953: ELSE -- Pay Plan and PRD not matched
6954: hr_utility.set_location('PP/PRD FAIL',165);
6950: hr_utility.set_location('Pay Table FAIL',155);
6951: p_elig_flag := FALSE;
6952: END IF;
6953: ELSE -- Pay Plan and PRD not matched
6954: hr_utility.set_location('PP/PRD FAIL',165);
6955: p_elig_flag := FALSE;
6956: END IF;
6957: ELSE
6958: hr_utility.set_location('PP FAIL',175);
6954: hr_utility.set_location('PP/PRD FAIL',165);
6955: p_elig_flag := FALSE;
6956: END IF;
6957: ELSE
6958: hr_utility.set_location('PP FAIL',175);
6959: p_elig_flag := FALSE;
6960: END IF;
6961: EXCEPTION
6962: WHEN others THEN
6959: p_elig_flag := FALSE;
6960: END IF;
6961: EXCEPTION
6962: WHEN others THEN
6963: hr_utility.set_location('WHEN OTHERS',185);
6964: RAISE;
6965: END fetch_and_validate_emp_ses;
6966:
6967: PROCEDURE execute_msl_ses_range (p_errbuf out nocopy varchar2,
7339: l_grade_or_level := p_grade_or_level;
7340: l_to_grade_or_level := p_to_grade_or_level;
7341: l_step_or_rate := P_step_or_rate;
7342: l_pay_basis := p_pay_basis;
7343: hr_utility.set_location('The location id is:'||l_location_id,1);
7344: /*5470182 need to be commented
7345: --------GPPA Update 46 start
7346: ghr_msl_pkg.g_first_noa_code := NULL;
7347: FOR cur_eq_ppl_rec IN cur_eq_ppl(l_pay_plan)
7390: LOOP
7391: l_ds_end_date := rec_ds.end_Date;
7392: END LOOP;
7393: IF l_ds_end_date IS NULL THEN
7394: hr_utility.set_location('Under DS null check'||l_duty_station_id, 1);
7395: l_mslerrbuf := ' Error: Duty Station associated with the location is INVALID. '||
7396: 'Salary cannot be calculated correctly without valid duty station. ';
7397: RAISE msl_error;
7398: END IF;
7405: (p_location_id => l_location_id
7406: ,p_duty_station_id => l_duty_station_id);
7407: / *exception
7408: when others then
7409: hr_utility.set_location(
7410: 'Error in Ghr_pa_requests_pkg.get_sf52_loc_ddf_details'||
7411: 'Err is '||sqlerrm(sqlcode),20);
7412: l_mslerrbuf := 'Error in get_sf52_loc_ddf_details '||
7413: 'Sql Err is '|| sqlerrm(sqlcode);
7432: l_position_title,
7433: l_position_number,
7434: l_position_seq_no);
7435:
7436: hr_utility.set_location('The duty station id is:'||l_duty_station_id,12345);
7437:
7438: if check_init_eligibility(l_p_duty_station_id,
7439: l_p_PERSONNEL_OFFICE_ID,
7440: l_p_AGENCY_CODE_SUBELEMENT,
7441: l_duty_station_id,
7442: l_personnel_office_id,
7443: l_sub_element_code) then
7444:
7445: hr_utility.set_location('check_init_eligibility ' || l_proc,6);
7446: -- Bug 3457205 Filter the Pay plan table id condition also b4 checking any other thing
7447: -- Moving check_eligibility to here.
7448: -- Get PRD, work schedule etc form ASG EI
7449: begin
7456: l_work_schedule,
7457: l_part_time_hour);
7458: exception
7459: when others then
7460: hr_utility.set_location('Error in Ghr_pa_requests_pkg.get_sf52_asg_ddf_details'||
7461: 'Err is '||sqlerrm(sqlcode),20);
7462: l_mslerrbuf := 'Error in get_sf52_asgddf_details Sql Err is '|| sqlerrm(sqlcode);
7463: raise msl_error;
7464: end;
7480: l_grade_or_level, l_to_grade_or_level, l_step_or_rate,
7481: l_pay_basis);
7482: EXCEPTION
7483: when msl_error then
7484: l_mslerrbuf := hr_utility.get_message;
7485: raise;
7486: END;
7487:
7488: IF ( nvl(rec_pp_prd(l_cnt).pay_plan,l_pay_plan) = l_pay_plan
7495: l_pay_rate_determinant,
7496: p_person_id,
7497: l_effective_date,
7498: p_action) THEN
7499: hr_utility.set_location('check_eligibility ' || l_proc,8); */
7500: -- Bug#5063304 Moved this call outside check_init_eligibility condition to
7501: -- this location.
7502: -- BUG 3377958 Madhuri
7503: -- Pick the organization name
7512: ELSE
7513: if check_select_flg_ses(p_person_id,upper(p_action),
7514: l_effective_date,p_mass_salary_id,l_sel_flg,l_ses_basic_pay) then
7515:
7516: hr_utility.set_location('check_select_flg ' || l_proc,7);
7517: BEGIN
7518: hr_utility.set_location('The duty station name is:'||l_duty_station_code,12345);
7519: hr_utility.set_location('The duty station desc is:'||l_duty_station_desc,12345);
7520: ghr_pa_requests_pkg.get_duty_station_details
7514: l_effective_date,p_mass_salary_id,l_sel_flg,l_ses_basic_pay) then
7515:
7516: hr_utility.set_location('check_select_flg ' || l_proc,7);
7517: BEGIN
7518: hr_utility.set_location('The duty station name is:'||l_duty_station_code,12345);
7519: hr_utility.set_location('The duty station desc is:'||l_duty_station_desc,12345);
7520: ghr_pa_requests_pkg.get_duty_station_details
7521: (p_duty_station_id => l_duty_station_id
7522: ,p_effective_date => l_effective_date
7515:
7516: hr_utility.set_location('check_select_flg ' || l_proc,7);
7517: BEGIN
7518: hr_utility.set_location('The duty station name is:'||l_duty_station_code,12345);
7519: hr_utility.set_location('The duty station desc is:'||l_duty_station_desc,12345);
7520: ghr_pa_requests_pkg.get_duty_station_details
7521: (p_duty_station_id => l_duty_station_id
7522: ,p_effective_date => l_effective_date
7523: ,p_duty_station_code => l_duty_station_code
7523: ,p_duty_station_code => l_duty_station_code
7524: ,p_duty_station_desc => l_duty_station_desc);
7525: EXCEPTION
7526: WHEN others THEN
7527: hr_utility.set_location('Error in Ghr_pa_requests_pkg.get_duty_station_details'||
7528: 'Err is '||sqlerrm(sqlcode),20);
7529: l_mslerrbuf := 'Error in get_duty_station_details Sql Err is '|| sqlerrm(sqlcode);
7530: RAISE msl_error;
7531:
7593: ,l_message_set
7594: ,l_calculated);
7595:
7596: IF l_message_set THEN
7597: hr_utility.set_location( l_proc, 40);
7598: l_calculated := FALSE;
7599: l_mslerrbuf := hr_utility.get_message;
7600: -- raise msl_error;
7601: END IF;
7595:
7596: IF l_message_set THEN
7597: hr_utility.set_location( l_proc, 40);
7598: l_calculated := FALSE;
7599: l_mslerrbuf := hr_utility.get_message;
7600: -- raise msl_error;
7601: END IF;
7602: EXCEPTION
7603: when msl_error then
7680: ins_upd_per_ses_extra_info
7681: (p_person_id,l_effective_date, l_sel_flg, l_comment,p_mass_salary_id);
7682: l_comment := NULL;
7683: ------ BUG 3287299 End
7684: hr_utility.set_location('Error in Ghr_pay_calc.sql_main_pay_calc '||
7685: 'Err is '||sqlerrm(sqlcode),20);
7686: l_mslerrbuf := 'Error in ghr_pay_calc Sql Err is '|| sqlerrm(sqlcode);
7687: g_proc := 'ghr_pay_calc';
7688: raise msl_error;
7712: l_new_other_pay_amount := null;
7713: end if;
7714: l_new_total_salary := l_pay_calc_out_data.total_salary;
7715:
7716: hr_utility.set_location('retention_allowance = ' || to_char(l_retention_allowance),10);
7717: hr_utility.set_location('Supervisory Diff Amount = ' || to_char(l_supervisory_differential),10);
7718:
7719:
7720: -------------Call Pay cap Procedure
7713: end if;
7714: l_new_total_salary := l_pay_calc_out_data.total_salary;
7715:
7716: hr_utility.set_location('retention_allowance = ' || to_char(l_retention_allowance),10);
7717: hr_utility.set_location('Supervisory Diff Amount = ' || to_char(l_supervisory_differential),10);
7718:
7719:
7720: -------------Call Pay cap Procedure
7721: begin
7722: l_capped_other_pay := ghr_pa_requests_pkg2.get_cop( p_assignment_id => l_assignment_id
7723: ,p_effective_date => l_effective_date);
7724: l_old_capped_other_pay := l_capped_other_pay;
7725: -- Sundar Added the following if statement to improve performance
7726: if hr_utility.debug_enabled = true then
7727: hr_utility.set_location('Before Pay Cap ' || l_proc,21);
7728: hr_utility.set_location('l_effective_date ' || l_effective_date,21);
7729: hr_utility.set_location('l_out_pay_rate_determinant ' || l_out_pay_rate_determinant,21);
7730: hr_utility.set_location('l_pay_plan ' || l_pay_plan,21);
7723: ,p_effective_date => l_effective_date);
7724: l_old_capped_other_pay := l_capped_other_pay;
7725: -- Sundar Added the following if statement to improve performance
7726: if hr_utility.debug_enabled = true then
7727: hr_utility.set_location('Before Pay Cap ' || l_proc,21);
7728: hr_utility.set_location('l_effective_date ' || l_effective_date,21);
7729: hr_utility.set_location('l_out_pay_rate_determinant ' || l_out_pay_rate_determinant,21);
7730: hr_utility.set_location('l_pay_plan ' || l_pay_plan,21);
7731: hr_utility.set_location('l_position_id ' || to_char(l_position_id),21);
7724: l_old_capped_other_pay := l_capped_other_pay;
7725: -- Sundar Added the following if statement to improve performance
7726: if hr_utility.debug_enabled = true then
7727: hr_utility.set_location('Before Pay Cap ' || l_proc,21);
7728: hr_utility.set_location('l_effective_date ' || l_effective_date,21);
7729: hr_utility.set_location('l_out_pay_rate_determinant ' || l_out_pay_rate_determinant,21);
7730: hr_utility.set_location('l_pay_plan ' || l_pay_plan,21);
7731: hr_utility.set_location('l_position_id ' || to_char(l_position_id),21);
7732: hr_utility.set_location('l_pay_basis ' || l_pay_basis,21);
7725: -- Sundar Added the following if statement to improve performance
7726: if hr_utility.debug_enabled = true then
7727: hr_utility.set_location('Before Pay Cap ' || l_proc,21);
7728: hr_utility.set_location('l_effective_date ' || l_effective_date,21);
7729: hr_utility.set_location('l_out_pay_rate_determinant ' || l_out_pay_rate_determinant,21);
7730: hr_utility.set_location('l_pay_plan ' || l_pay_plan,21);
7731: hr_utility.set_location('l_position_id ' || to_char(l_position_id),21);
7732: hr_utility.set_location('l_pay_basis ' || l_pay_basis,21);
7733: hr_utility.set_location('person_id ' || to_char(p_person_id),21);
7726: if hr_utility.debug_enabled = true then
7727: hr_utility.set_location('Before Pay Cap ' || l_proc,21);
7728: hr_utility.set_location('l_effective_date ' || l_effective_date,21);
7729: hr_utility.set_location('l_out_pay_rate_determinant ' || l_out_pay_rate_determinant,21);
7730: hr_utility.set_location('l_pay_plan ' || l_pay_plan,21);
7731: hr_utility.set_location('l_position_id ' || to_char(l_position_id),21);
7732: hr_utility.set_location('l_pay_basis ' || l_pay_basis,21);
7733: hr_utility.set_location('person_id ' || to_char(p_person_id),21);
7734: hr_utility.set_location('l_new_basic_pay ' || to_char(l_new_basic_pay),21);
7727: hr_utility.set_location('Before Pay Cap ' || l_proc,21);
7728: hr_utility.set_location('l_effective_date ' || l_effective_date,21);
7729: hr_utility.set_location('l_out_pay_rate_determinant ' || l_out_pay_rate_determinant,21);
7730: hr_utility.set_location('l_pay_plan ' || l_pay_plan,21);
7731: hr_utility.set_location('l_position_id ' || to_char(l_position_id),21);
7732: hr_utility.set_location('l_pay_basis ' || l_pay_basis,21);
7733: hr_utility.set_location('person_id ' || to_char(p_person_id),21);
7734: hr_utility.set_location('l_new_basic_pay ' || to_char(l_new_basic_pay),21);
7735: hr_utility.set_location('l_new_locality_adj ' || to_char(l_new_locality_adj),21);
7728: hr_utility.set_location('l_effective_date ' || l_effective_date,21);
7729: hr_utility.set_location('l_out_pay_rate_determinant ' || l_out_pay_rate_determinant,21);
7730: hr_utility.set_location('l_pay_plan ' || l_pay_plan,21);
7731: hr_utility.set_location('l_position_id ' || to_char(l_position_id),21);
7732: hr_utility.set_location('l_pay_basis ' || l_pay_basis,21);
7733: hr_utility.set_location('person_id ' || to_char(p_person_id),21);
7734: hr_utility.set_location('l_new_basic_pay ' || to_char(l_new_basic_pay),21);
7735: hr_utility.set_location('l_new_locality_adj ' || to_char(l_new_locality_adj),21);
7736: hr_utility.set_location('l_new_adj_basic_pay ' || to_char(l_new_adj_basic_pay),21);
7729: hr_utility.set_location('l_out_pay_rate_determinant ' || l_out_pay_rate_determinant,21);
7730: hr_utility.set_location('l_pay_plan ' || l_pay_plan,21);
7731: hr_utility.set_location('l_position_id ' || to_char(l_position_id),21);
7732: hr_utility.set_location('l_pay_basis ' || l_pay_basis,21);
7733: hr_utility.set_location('person_id ' || to_char(p_person_id),21);
7734: hr_utility.set_location('l_new_basic_pay ' || to_char(l_new_basic_pay),21);
7735: hr_utility.set_location('l_new_locality_adj ' || to_char(l_new_locality_adj),21);
7736: hr_utility.set_location('l_new_adj_basic_pay ' || to_char(l_new_adj_basic_pay),21);
7737: hr_utility.set_location('l_new_total_salary ' || to_char(l_new_total_salary),21);
7730: hr_utility.set_location('l_pay_plan ' || l_pay_plan,21);
7731: hr_utility.set_location('l_position_id ' || to_char(l_position_id),21);
7732: hr_utility.set_location('l_pay_basis ' || l_pay_basis,21);
7733: hr_utility.set_location('person_id ' || to_char(p_person_id),21);
7734: hr_utility.set_location('l_new_basic_pay ' || to_char(l_new_basic_pay),21);
7735: hr_utility.set_location('l_new_locality_adj ' || to_char(l_new_locality_adj),21);
7736: hr_utility.set_location('l_new_adj_basic_pay ' || to_char(l_new_adj_basic_pay),21);
7737: hr_utility.set_location('l_new_total_salary ' || to_char(l_new_total_salary),21);
7738: hr_utility.set_location('l_entitled_other_pay ' || to_char(l_entitled_other_pay),21);
7731: hr_utility.set_location('l_position_id ' || to_char(l_position_id),21);
7732: hr_utility.set_location('l_pay_basis ' || l_pay_basis,21);
7733: hr_utility.set_location('person_id ' || to_char(p_person_id),21);
7734: hr_utility.set_location('l_new_basic_pay ' || to_char(l_new_basic_pay),21);
7735: hr_utility.set_location('l_new_locality_adj ' || to_char(l_new_locality_adj),21);
7736: hr_utility.set_location('l_new_adj_basic_pay ' || to_char(l_new_adj_basic_pay),21);
7737: hr_utility.set_location('l_new_total_salary ' || to_char(l_new_total_salary),21);
7738: hr_utility.set_location('l_entitled_other_pay ' || to_char(l_entitled_other_pay),21);
7739: hr_utility.set_location('l_capped_other_pay ' || to_char(l_capped_other_pay),21);
7732: hr_utility.set_location('l_pay_basis ' || l_pay_basis,21);
7733: hr_utility.set_location('person_id ' || to_char(p_person_id),21);
7734: hr_utility.set_location('l_new_basic_pay ' || to_char(l_new_basic_pay),21);
7735: hr_utility.set_location('l_new_locality_adj ' || to_char(l_new_locality_adj),21);
7736: hr_utility.set_location('l_new_adj_basic_pay ' || to_char(l_new_adj_basic_pay),21);
7737: hr_utility.set_location('l_new_total_salary ' || to_char(l_new_total_salary),21);
7738: hr_utility.set_location('l_entitled_other_pay ' || to_char(l_entitled_other_pay),21);
7739: hr_utility.set_location('l_capped_other_pay ' || to_char(l_capped_other_pay),21);
7740: hr_utility.set_location('l_new_retention_allowance ' || to_char(l_new_retention_allowance),21);
7733: hr_utility.set_location('person_id ' || to_char(p_person_id),21);
7734: hr_utility.set_location('l_new_basic_pay ' || to_char(l_new_basic_pay),21);
7735: hr_utility.set_location('l_new_locality_adj ' || to_char(l_new_locality_adj),21);
7736: hr_utility.set_location('l_new_adj_basic_pay ' || to_char(l_new_adj_basic_pay),21);
7737: hr_utility.set_location('l_new_total_salary ' || to_char(l_new_total_salary),21);
7738: hr_utility.set_location('l_entitled_other_pay ' || to_char(l_entitled_other_pay),21);
7739: hr_utility.set_location('l_capped_other_pay ' || to_char(l_capped_other_pay),21);
7740: hr_utility.set_location('l_new_retention_allowance ' || to_char(l_new_retention_allowance),21);
7741: hr_utility.set_location('l_new_supervisory_differential ' || to_char(l_new_supervisory_differential),21);
7734: hr_utility.set_location('l_new_basic_pay ' || to_char(l_new_basic_pay),21);
7735: hr_utility.set_location('l_new_locality_adj ' || to_char(l_new_locality_adj),21);
7736: hr_utility.set_location('l_new_adj_basic_pay ' || to_char(l_new_adj_basic_pay),21);
7737: hr_utility.set_location('l_new_total_salary ' || to_char(l_new_total_salary),21);
7738: hr_utility.set_location('l_entitled_other_pay ' || to_char(l_entitled_other_pay),21);
7739: hr_utility.set_location('l_capped_other_pay ' || to_char(l_capped_other_pay),21);
7740: hr_utility.set_location('l_new_retention_allowance ' || to_char(l_new_retention_allowance),21);
7741: hr_utility.set_location('l_new_supervisory_differential ' || to_char(l_new_supervisory_differential),21);
7742: hr_utility.set_location('l_staffing_differential ' || to_char(l_staffing_differential),21);
7735: hr_utility.set_location('l_new_locality_adj ' || to_char(l_new_locality_adj),21);
7736: hr_utility.set_location('l_new_adj_basic_pay ' || to_char(l_new_adj_basic_pay),21);
7737: hr_utility.set_location('l_new_total_salary ' || to_char(l_new_total_salary),21);
7738: hr_utility.set_location('l_entitled_other_pay ' || to_char(l_entitled_other_pay),21);
7739: hr_utility.set_location('l_capped_other_pay ' || to_char(l_capped_other_pay),21);
7740: hr_utility.set_location('l_new_retention_allowance ' || to_char(l_new_retention_allowance),21);
7741: hr_utility.set_location('l_new_supervisory_differential ' || to_char(l_new_supervisory_differential),21);
7742: hr_utility.set_location('l_staffing_differential ' || to_char(l_staffing_differential),21);
7743: hr_utility.set_location('l_new_au_overtime ' || to_char(l_new_au_overtime),21);
7736: hr_utility.set_location('l_new_adj_basic_pay ' || to_char(l_new_adj_basic_pay),21);
7737: hr_utility.set_location('l_new_total_salary ' || to_char(l_new_total_salary),21);
7738: hr_utility.set_location('l_entitled_other_pay ' || to_char(l_entitled_other_pay),21);
7739: hr_utility.set_location('l_capped_other_pay ' || to_char(l_capped_other_pay),21);
7740: hr_utility.set_location('l_new_retention_allowance ' || to_char(l_new_retention_allowance),21);
7741: hr_utility.set_location('l_new_supervisory_differential ' || to_char(l_new_supervisory_differential),21);
7742: hr_utility.set_location('l_staffing_differential ' || to_char(l_staffing_differential),21);
7743: hr_utility.set_location('l_new_au_overtime ' || to_char(l_new_au_overtime),21);
7744: hr_utility.set_location('l_new_availability_pay ' || to_char(l_new_availability_pay),21);
7737: hr_utility.set_location('l_new_total_salary ' || to_char(l_new_total_salary),21);
7738: hr_utility.set_location('l_entitled_other_pay ' || to_char(l_entitled_other_pay),21);
7739: hr_utility.set_location('l_capped_other_pay ' || to_char(l_capped_other_pay),21);
7740: hr_utility.set_location('l_new_retention_allowance ' || to_char(l_new_retention_allowance),21);
7741: hr_utility.set_location('l_new_supervisory_differential ' || to_char(l_new_supervisory_differential),21);
7742: hr_utility.set_location('l_staffing_differential ' || to_char(l_staffing_differential),21);
7743: hr_utility.set_location('l_new_au_overtime ' || to_char(l_new_au_overtime),21);
7744: hr_utility.set_location('l_new_availability_pay ' || to_char(l_new_availability_pay),21);
7745:
7738: hr_utility.set_location('l_entitled_other_pay ' || to_char(l_entitled_other_pay),21);
7739: hr_utility.set_location('l_capped_other_pay ' || to_char(l_capped_other_pay),21);
7740: hr_utility.set_location('l_new_retention_allowance ' || to_char(l_new_retention_allowance),21);
7741: hr_utility.set_location('l_new_supervisory_differential ' || to_char(l_new_supervisory_differential),21);
7742: hr_utility.set_location('l_staffing_differential ' || to_char(l_staffing_differential),21);
7743: hr_utility.set_location('l_new_au_overtime ' || to_char(l_new_au_overtime),21);
7744: hr_utility.set_location('l_new_availability_pay ' || to_char(l_new_availability_pay),21);
7745:
7746: end if;
7739: hr_utility.set_location('l_capped_other_pay ' || to_char(l_capped_other_pay),21);
7740: hr_utility.set_location('l_new_retention_allowance ' || to_char(l_new_retention_allowance),21);
7741: hr_utility.set_location('l_new_supervisory_differential ' || to_char(l_new_supervisory_differential),21);
7742: hr_utility.set_location('l_staffing_differential ' || to_char(l_staffing_differential),21);
7743: hr_utility.set_location('l_new_au_overtime ' || to_char(l_new_au_overtime),21);
7744: hr_utility.set_location('l_new_availability_pay ' || to_char(l_new_availability_pay),21);
7745:
7746: end if;
7747:
7740: hr_utility.set_location('l_new_retention_allowance ' || to_char(l_new_retention_allowance),21);
7741: hr_utility.set_location('l_new_supervisory_differential ' || to_char(l_new_supervisory_differential),21);
7742: hr_utility.set_location('l_staffing_differential ' || to_char(l_staffing_differential),21);
7743: hr_utility.set_location('l_new_au_overtime ' || to_char(l_new_au_overtime),21);
7744: hr_utility.set_location('l_new_availability_pay ' || to_char(l_new_availability_pay),21);
7745:
7746: end if;
7747:
7748:
7777:
7778: l_new_other_pay_amount := nvl(l_capped_other_pay,l_entitled_other_pay);
7779:
7780: -- Sundar Added the following statement to improve performance
7781: if hr_utility.debug_enabled = true then
7782: hr_utility.set_location('After Pay Cap ' || l_proc,22);
7783: hr_utility.set_location('l_effective_date ' || l_effective_date,22);
7784: hr_utility.set_location('l_out_pay_rate_determinant ' || l_out_pay_rate_determinant,22);
7785: hr_utility.set_location('l_pay_plan ' || l_pay_plan,22);
7778: l_new_other_pay_amount := nvl(l_capped_other_pay,l_entitled_other_pay);
7779:
7780: -- Sundar Added the following statement to improve performance
7781: if hr_utility.debug_enabled = true then
7782: hr_utility.set_location('After Pay Cap ' || l_proc,22);
7783: hr_utility.set_location('l_effective_date ' || l_effective_date,22);
7784: hr_utility.set_location('l_out_pay_rate_determinant ' || l_out_pay_rate_determinant,22);
7785: hr_utility.set_location('l_pay_plan ' || l_pay_plan,22);
7786: hr_utility.set_location('l_position_id ' || to_char(l_position_id),22);
7779:
7780: -- Sundar Added the following statement to improve performance
7781: if hr_utility.debug_enabled = true then
7782: hr_utility.set_location('After Pay Cap ' || l_proc,22);
7783: hr_utility.set_location('l_effective_date ' || l_effective_date,22);
7784: hr_utility.set_location('l_out_pay_rate_determinant ' || l_out_pay_rate_determinant,22);
7785: hr_utility.set_location('l_pay_plan ' || l_pay_plan,22);
7786: hr_utility.set_location('l_position_id ' || to_char(l_position_id),22);
7787: hr_utility.set_location('l_pay_basis ' || l_pay_basis,22);
7780: -- Sundar Added the following statement to improve performance
7781: if hr_utility.debug_enabled = true then
7782: hr_utility.set_location('After Pay Cap ' || l_proc,22);
7783: hr_utility.set_location('l_effective_date ' || l_effective_date,22);
7784: hr_utility.set_location('l_out_pay_rate_determinant ' || l_out_pay_rate_determinant,22);
7785: hr_utility.set_location('l_pay_plan ' || l_pay_plan,22);
7786: hr_utility.set_location('l_position_id ' || to_char(l_position_id),22);
7787: hr_utility.set_location('l_pay_basis ' || l_pay_basis,22);
7788: hr_utility.set_location('person_id ' || to_char(p_person_id),22);
7781: if hr_utility.debug_enabled = true then
7782: hr_utility.set_location('After Pay Cap ' || l_proc,22);
7783: hr_utility.set_location('l_effective_date ' || l_effective_date,22);
7784: hr_utility.set_location('l_out_pay_rate_determinant ' || l_out_pay_rate_determinant,22);
7785: hr_utility.set_location('l_pay_plan ' || l_pay_plan,22);
7786: hr_utility.set_location('l_position_id ' || to_char(l_position_id),22);
7787: hr_utility.set_location('l_pay_basis ' || l_pay_basis,22);
7788: hr_utility.set_location('person_id ' || to_char(p_person_id),22);
7789: hr_utility.set_location('l_new_basic_pay ' || to_char(l_new_basic_pay),22);
7782: hr_utility.set_location('After Pay Cap ' || l_proc,22);
7783: hr_utility.set_location('l_effective_date ' || l_effective_date,22);
7784: hr_utility.set_location('l_out_pay_rate_determinant ' || l_out_pay_rate_determinant,22);
7785: hr_utility.set_location('l_pay_plan ' || l_pay_plan,22);
7786: hr_utility.set_location('l_position_id ' || to_char(l_position_id),22);
7787: hr_utility.set_location('l_pay_basis ' || l_pay_basis,22);
7788: hr_utility.set_location('person_id ' || to_char(p_person_id),22);
7789: hr_utility.set_location('l_new_basic_pay ' || to_char(l_new_basic_pay),22);
7790: hr_utility.set_location('l_new_locality_adj ' || to_char(l_new_locality_adj),22);
7783: hr_utility.set_location('l_effective_date ' || l_effective_date,22);
7784: hr_utility.set_location('l_out_pay_rate_determinant ' || l_out_pay_rate_determinant,22);
7785: hr_utility.set_location('l_pay_plan ' || l_pay_plan,22);
7786: hr_utility.set_location('l_position_id ' || to_char(l_position_id),22);
7787: hr_utility.set_location('l_pay_basis ' || l_pay_basis,22);
7788: hr_utility.set_location('person_id ' || to_char(p_person_id),22);
7789: hr_utility.set_location('l_new_basic_pay ' || to_char(l_new_basic_pay),22);
7790: hr_utility.set_location('l_new_locality_adj ' || to_char(l_new_locality_adj),22);
7791: hr_utility.set_location('l_new_adj_basic_pay ' || to_char(l_new_adj_basic_pay),22);
7784: hr_utility.set_location('l_out_pay_rate_determinant ' || l_out_pay_rate_determinant,22);
7785: hr_utility.set_location('l_pay_plan ' || l_pay_plan,22);
7786: hr_utility.set_location('l_position_id ' || to_char(l_position_id),22);
7787: hr_utility.set_location('l_pay_basis ' || l_pay_basis,22);
7788: hr_utility.set_location('person_id ' || to_char(p_person_id),22);
7789: hr_utility.set_location('l_new_basic_pay ' || to_char(l_new_basic_pay),22);
7790: hr_utility.set_location('l_new_locality_adj ' || to_char(l_new_locality_adj),22);
7791: hr_utility.set_location('l_new_adj_basic_pay ' || to_char(l_new_adj_basic_pay),22);
7792: hr_utility.set_location('l_new_total_salary ' || to_char(l_new_total_salary),22);
7785: hr_utility.set_location('l_pay_plan ' || l_pay_plan,22);
7786: hr_utility.set_location('l_position_id ' || to_char(l_position_id),22);
7787: hr_utility.set_location('l_pay_basis ' || l_pay_basis,22);
7788: hr_utility.set_location('person_id ' || to_char(p_person_id),22);
7789: hr_utility.set_location('l_new_basic_pay ' || to_char(l_new_basic_pay),22);
7790: hr_utility.set_location('l_new_locality_adj ' || to_char(l_new_locality_adj),22);
7791: hr_utility.set_location('l_new_adj_basic_pay ' || to_char(l_new_adj_basic_pay),22);
7792: hr_utility.set_location('l_new_total_salary ' || to_char(l_new_total_salary),22);
7793: hr_utility.set_location('l_entitled_other_pay ' || to_char(l_entitled_other_pay),22);
7786: hr_utility.set_location('l_position_id ' || to_char(l_position_id),22);
7787: hr_utility.set_location('l_pay_basis ' || l_pay_basis,22);
7788: hr_utility.set_location('person_id ' || to_char(p_person_id),22);
7789: hr_utility.set_location('l_new_basic_pay ' || to_char(l_new_basic_pay),22);
7790: hr_utility.set_location('l_new_locality_adj ' || to_char(l_new_locality_adj),22);
7791: hr_utility.set_location('l_new_adj_basic_pay ' || to_char(l_new_adj_basic_pay),22);
7792: hr_utility.set_location('l_new_total_salary ' || to_char(l_new_total_salary),22);
7793: hr_utility.set_location('l_entitled_other_pay ' || to_char(l_entitled_other_pay),22);
7794: hr_utility.set_location('l_capped_other_pay ' || to_char(l_capped_other_pay),22);
7787: hr_utility.set_location('l_pay_basis ' || l_pay_basis,22);
7788: hr_utility.set_location('person_id ' || to_char(p_person_id),22);
7789: hr_utility.set_location('l_new_basic_pay ' || to_char(l_new_basic_pay),22);
7790: hr_utility.set_location('l_new_locality_adj ' || to_char(l_new_locality_adj),22);
7791: hr_utility.set_location('l_new_adj_basic_pay ' || to_char(l_new_adj_basic_pay),22);
7792: hr_utility.set_location('l_new_total_salary ' || to_char(l_new_total_salary),22);
7793: hr_utility.set_location('l_entitled_other_pay ' || to_char(l_entitled_other_pay),22);
7794: hr_utility.set_location('l_capped_other_pay ' || to_char(l_capped_other_pay),22);
7795: hr_utility.set_location('l_new_retention_allowance ' || to_char(l_new_retention_allowance),22);
7788: hr_utility.set_location('person_id ' || to_char(p_person_id),22);
7789: hr_utility.set_location('l_new_basic_pay ' || to_char(l_new_basic_pay),22);
7790: hr_utility.set_location('l_new_locality_adj ' || to_char(l_new_locality_adj),22);
7791: hr_utility.set_location('l_new_adj_basic_pay ' || to_char(l_new_adj_basic_pay),22);
7792: hr_utility.set_location('l_new_total_salary ' || to_char(l_new_total_salary),22);
7793: hr_utility.set_location('l_entitled_other_pay ' || to_char(l_entitled_other_pay),22);
7794: hr_utility.set_location('l_capped_other_pay ' || to_char(l_capped_other_pay),22);
7795: hr_utility.set_location('l_new_retention_allowance ' || to_char(l_new_retention_allowance),22);
7796: hr_utility.set_location('l_new_supervisory_differential ' || to_char(l_new_supervisory_differential),22);
7789: hr_utility.set_location('l_new_basic_pay ' || to_char(l_new_basic_pay),22);
7790: hr_utility.set_location('l_new_locality_adj ' || to_char(l_new_locality_adj),22);
7791: hr_utility.set_location('l_new_adj_basic_pay ' || to_char(l_new_adj_basic_pay),22);
7792: hr_utility.set_location('l_new_total_salary ' || to_char(l_new_total_salary),22);
7793: hr_utility.set_location('l_entitled_other_pay ' || to_char(l_entitled_other_pay),22);
7794: hr_utility.set_location('l_capped_other_pay ' || to_char(l_capped_other_pay),22);
7795: hr_utility.set_location('l_new_retention_allowance ' || to_char(l_new_retention_allowance),22);
7796: hr_utility.set_location('l_new_supervisory_differential ' || to_char(l_new_supervisory_differential),22);
7797: hr_utility.set_location('l_staffing_differential ' || to_char(l_staffing_differential),22);
7790: hr_utility.set_location('l_new_locality_adj ' || to_char(l_new_locality_adj),22);
7791: hr_utility.set_location('l_new_adj_basic_pay ' || to_char(l_new_adj_basic_pay),22);
7792: hr_utility.set_location('l_new_total_salary ' || to_char(l_new_total_salary),22);
7793: hr_utility.set_location('l_entitled_other_pay ' || to_char(l_entitled_other_pay),22);
7794: hr_utility.set_location('l_capped_other_pay ' || to_char(l_capped_other_pay),22);
7795: hr_utility.set_location('l_new_retention_allowance ' || to_char(l_new_retention_allowance),22);
7796: hr_utility.set_location('l_new_supervisory_differential ' || to_char(l_new_supervisory_differential),22);
7797: hr_utility.set_location('l_staffing_differential ' || to_char(l_staffing_differential),22);
7798: hr_utility.set_location('l_new_au_overtime ' || to_char(l_new_au_overtime),22);
7791: hr_utility.set_location('l_new_adj_basic_pay ' || to_char(l_new_adj_basic_pay),22);
7792: hr_utility.set_location('l_new_total_salary ' || to_char(l_new_total_salary),22);
7793: hr_utility.set_location('l_entitled_other_pay ' || to_char(l_entitled_other_pay),22);
7794: hr_utility.set_location('l_capped_other_pay ' || to_char(l_capped_other_pay),22);
7795: hr_utility.set_location('l_new_retention_allowance ' || to_char(l_new_retention_allowance),22);
7796: hr_utility.set_location('l_new_supervisory_differential ' || to_char(l_new_supervisory_differential),22);
7797: hr_utility.set_location('l_staffing_differential ' || to_char(l_staffing_differential),22);
7798: hr_utility.set_location('l_new_au_overtime ' || to_char(l_new_au_overtime),22);
7799: hr_utility.set_location('l_new_availability_pay ' || to_char(l_new_availability_pay),22);
7792: hr_utility.set_location('l_new_total_salary ' || to_char(l_new_total_salary),22);
7793: hr_utility.set_location('l_entitled_other_pay ' || to_char(l_entitled_other_pay),22);
7794: hr_utility.set_location('l_capped_other_pay ' || to_char(l_capped_other_pay),22);
7795: hr_utility.set_location('l_new_retention_allowance ' || to_char(l_new_retention_allowance),22);
7796: hr_utility.set_location('l_new_supervisory_differential ' || to_char(l_new_supervisory_differential),22);
7797: hr_utility.set_location('l_staffing_differential ' || to_char(l_staffing_differential),22);
7798: hr_utility.set_location('l_new_au_overtime ' || to_char(l_new_au_overtime),22);
7799: hr_utility.set_location('l_new_availability_pay ' || to_char(l_new_availability_pay),22);
7800: end if;
7793: hr_utility.set_location('l_entitled_other_pay ' || to_char(l_entitled_other_pay),22);
7794: hr_utility.set_location('l_capped_other_pay ' || to_char(l_capped_other_pay),22);
7795: hr_utility.set_location('l_new_retention_allowance ' || to_char(l_new_retention_allowance),22);
7796: hr_utility.set_location('l_new_supervisory_differential ' || to_char(l_new_supervisory_differential),22);
7797: hr_utility.set_location('l_staffing_differential ' || to_char(l_staffing_differential),22);
7798: hr_utility.set_location('l_new_au_overtime ' || to_char(l_new_au_overtime),22);
7799: hr_utility.set_location('l_new_availability_pay ' || to_char(l_new_availability_pay),22);
7800: end if;
7801:
7794: hr_utility.set_location('l_capped_other_pay ' || to_char(l_capped_other_pay),22);
7795: hr_utility.set_location('l_new_retention_allowance ' || to_char(l_new_retention_allowance),22);
7796: hr_utility.set_location('l_new_supervisory_differential ' || to_char(l_new_supervisory_differential),22);
7797: hr_utility.set_location('l_staffing_differential ' || to_char(l_staffing_differential),22);
7798: hr_utility.set_location('l_new_au_overtime ' || to_char(l_new_au_overtime),22);
7799: hr_utility.set_location('l_new_availability_pay ' || to_char(l_new_availability_pay),22);
7800: end if;
7801:
7802: IF l_pay_cap_message THEN
7795: hr_utility.set_location('l_new_retention_allowance ' || to_char(l_new_retention_allowance),22);
7796: hr_utility.set_location('l_new_supervisory_differential ' || to_char(l_new_supervisory_differential),22);
7797: hr_utility.set_location('l_staffing_differential ' || to_char(l_staffing_differential),22);
7798: hr_utility.set_location('l_new_au_overtime ' || to_char(l_new_au_overtime),22);
7799: hr_utility.set_location('l_new_availability_pay ' || to_char(l_new_availability_pay),22);
7800: end if;
7801:
7802: IF l_pay_cap_message THEN
7803: IF nvl(l_temp_retention_allowance,0) > 0 THEN
7849: ins_upd_per_extra_info
7850: (p_person_id,l_effective_date, l_sel_flg, l_comment,p_mass_salary_id);
7851: l_comment := NULL;
7852: ELSE
7853: hr_utility.set_location('Error in ghr_pay_caps.do_pay_caps_main ' ||
7854: 'Err is '||sqlerrm(sqlcode),23);
7855: l_mslerrbuf := 'Error in do_pay_caps_main Sql Err is '|| sqlerrm(sqlcode);
7856: raise msl_error;
7857: END IF;
7935: l_grade_or_level, l_to_grade_or_level, l_step_or_rate,
7936: l_pay_basis);
7937: EXCEPTION
7938: when msl_error then
7939: l_mslerrbuf := hr_utility.get_message;
7940: raise;
7941: END;
7942:
7943: assign_to_sf52_rec(
7995: (l_pay_calc_out_data,
7996: l_sf52_rec);
7997: EXCEPTION
7998: when others then
7999: hr_utility.set_location('Error in Ghr_mass_actions_pkg.pay_calc_rec_to_sf52_rec '||
8000: 'Err is '||sqlerrm(sqlcode),20);
8001: l_mslerrbuf := 'Error in ghr_mass_act_pkg.pay_calc_to_sf52 Sql Err is '|| sqlerrm(sqlcode);
8002: raise msl_error;
8003: END;
8105: END IF;
8106: END IF;
8107: EXCEPTION
8108: WHEN MSL_ERROR THEN
8109: HR_UTILITY.SET_LOCATION('Error occurred in '||l_proc||' Sql error '||sqlerrm(sqlcode),10);
8110: begin
8111: ------ BUG 3287299 -- Not to rollback for preview.
8112: if upper(p_action) <> 'SHOW' then
8113: ROLLBACK TO EXECUTE_MSL_SP;
8118: l_log_text := 'Error in '||l_proc||' '||
8119: ' For Mass Salary Name : '||p_mass_salary||
8120: 'Name: '|| p_full_name || ' SSN: ' || p_national_identifier ||
8121: l_mslerrbuf;
8122: hr_utility.set_location('before creating entry in log file',10);
8123: l_recs_failed := l_recs_failed + 1;
8124: begin
8125: ghr_mto_int.log_message(
8126: p_procedure => g_proc,
8126: p_procedure => g_proc,
8127: p_message => l_log_text);
8128: exception
8129: when others then
8130: hr_utility.set_message(8301, 'GHR_38475_ERROR_LOG_FAILURE');
8131: hr_utility.raise_error;
8132: end;
8133: when others then
8134: HR_UTILITY.SET_LOCATION('Error (Others) occurred in '||l_proc||' Sql error '||sqlerrm(sqlcode),20);
8127: p_message => l_log_text);
8128: exception
8129: when others then
8130: hr_utility.set_message(8301, 'GHR_38475_ERROR_LOG_FAILURE');
8131: hr_utility.raise_error;
8132: end;
8133: when others then
8134: HR_UTILITY.SET_LOCATION('Error (Others) occurred in '||l_proc||' Sql error '||sqlerrm(sqlcode),20);
8135: BEGIN
8130: hr_utility.set_message(8301, 'GHR_38475_ERROR_LOG_FAILURE');
8131: hr_utility.raise_error;
8132: end;
8133: when others then
8134: HR_UTILITY.SET_LOCATION('Error (Others) occurred in '||l_proc||' Sql error '||sqlerrm(sqlcode),20);
8135: BEGIN
8136: ROLLBACK TO EXECUTE_MSL_SP;
8137: EXCEPTION
8138: WHEN OTHERS THEN NULL;
8140: l_log_text := 'Error (others) in '||l_proc||
8141: ' For Mass Salary Name : '||p_mass_salary||
8142: 'Name: '|| p_full_name || ' SSN: ' || p_national_identifier ||
8143: ' Sql Err is '||sqlerrm(sqlcode);
8144: hr_utility.set_location('before creating entry in log file',20);
8145: l_recs_failed := l_recs_failed + 1;
8146: begin
8147: ghr_mto_int.log_message(
8148: p_procedure => g_proc,
8148: p_procedure => g_proc,
8149: p_message => l_log_text);
8150: exception
8151: when others then
8152: hr_utility.set_message(8301, 'Create Error Log failed');
8153: hr_utility.raise_error;
8154: end;
8155: END msl_ses_process;
8156:
8149: p_message => l_log_text);
8150: exception
8151: when others then
8152: hr_utility.set_message(8301, 'Create Error Log failed');
8153: hr_utility.raise_error;
8154: end;
8155: END msl_ses_process;
8156:
8157: BEGIN
8156:
8157: BEGIN
8158:
8159: g_proc := 'execute_msl_ses_range';
8160: hr_utility.set_location('Entering ' || l_proc,5);
8161: p_retcode := 0;
8162:
8163: g_first_noa_code := null;
8164: BEGIN
8187: exit;
8188: END LOOP;
8189: EXCEPTION
8190: when REC_BUSY then
8191: hr_utility.set_location('Mass Salary is in use',1);
8192: l_mslerrbuf := 'Error in '||l_proc||' Sql Err is '|| sqlerrm(sqlcode);
8193: -- raise error;
8194: hr_utility.set_message(8301, 'GHR_38477_LOCK_ON_MSL');
8195: hr_utility.raise_error;
8190: when REC_BUSY then
8191: hr_utility.set_location('Mass Salary is in use',1);
8192: l_mslerrbuf := 'Error in '||l_proc||' Sql Err is '|| sqlerrm(sqlcode);
8193: -- raise error;
8194: hr_utility.set_message(8301, 'GHR_38477_LOCK_ON_MSL');
8195: hr_utility.raise_error;
8196: --
8197: when others then
8198: hr_utility.set_location('Error in '||l_proc||' Sql err is '||sqlerrm(sqlcode),1);
8191: hr_utility.set_location('Mass Salary is in use',1);
8192: l_mslerrbuf := 'Error in '||l_proc||' Sql Err is '|| sqlerrm(sqlcode);
8193: -- raise error;
8194: hr_utility.set_message(8301, 'GHR_38477_LOCK_ON_MSL');
8195: hr_utility.raise_error;
8196: --
8197: when others then
8198: hr_utility.set_location('Error in '||l_proc||' Sql err is '||sqlerrm(sqlcode),1);
8199: -- raise_application_error(-20111,'Error while selecting from Ghr Mass Salaries');
8194: hr_utility.set_message(8301, 'GHR_38477_LOCK_ON_MSL');
8195: hr_utility.raise_error;
8196: --
8197: when others then
8198: hr_utility.set_location('Error in '||l_proc||' Sql err is '||sqlerrm(sqlcode),1);
8199: -- raise_application_error(-20111,'Error while selecting from Ghr Mass Salaries');
8200: l_mslerrbuf := 'Error in '||l_proc||' Sql Err is '|| sqlerrm(sqlcode);
8201: raise msl_error;
8202: END;
8237:
8238: -- Commented out by Edward Nunez. It's not needed anymore with 894 rules
8239: -- IF upper(p_action) = 'CREATE' then
8240: -- if l_pa_request_id is null then
8241: -- hr_utility.set_message(8301, 'GHR_99999_SELECT_LAC_REMARKS');
8242: -- hr_utility.raise_error;
8243: -- END IF;
8244: -- END IF;
8245:
8238: -- Commented out by Edward Nunez. It's not needed anymore with 894 rules
8239: -- IF upper(p_action) = 'CREATE' then
8240: -- if l_pa_request_id is null then
8241: -- hr_utility.set_message(8301, 'GHR_99999_SELECT_LAC_REMARKS');
8242: -- hr_utility.raise_error;
8243: -- END IF;
8244: -- END IF;
8245:
8246: get_lac_dtls(l_pa_request_id,
8247: l_lac_sf52_rec);
8248:
8249: --purge_old_data(l_mass_salary_id);
8250:
8251: hr_utility.set_location('After fetch msl '||to_char(l_effective_date)
8252: ||' '||to_char(l_user_table_id),20);
8253:
8254: IF l_p_ORGANIZATION_ID is not null then
8255: FOR per IN cur_people_org (l_effective_date,l_p_ORGANIZATION_ID)
8503: set submit_flag = 'P'
8504: where rowid = l_rowid;
8505: EXCEPTION
8506: when others then
8507: HR_UTILITY.SET_LOCATION('Error in Update ghr_msl Sql error '||sqlerrm(sqlcode),30);
8508: hr_utility.set_message(8301, 'GHR_38476_UPD_GHR_MSL_FAILURE');
8509: hr_utility.raise_error;
8510: END;
8511: -----Bug 2849262. Updating extra info to null is already done by Update_sel_flg in the main loop.
8504: where rowid = l_rowid;
8505: EXCEPTION
8506: when others then
8507: HR_UTILITY.SET_LOCATION('Error in Update ghr_msl Sql error '||sqlerrm(sqlcode),30);
8508: hr_utility.set_message(8301, 'GHR_38476_UPD_GHR_MSL_FAILURE');
8509: hr_utility.raise_error;
8510: END;
8511: -----Bug 2849262. Updating extra info to null is already done by Update_sel_flg in the main loop.
8512: ----- So it is not required to do in global if you see the procedure upd_ext_info_to_null
8505: EXCEPTION
8506: when others then
8507: HR_UTILITY.SET_LOCATION('Error in Update ghr_msl Sql error '||sqlerrm(sqlcode),30);
8508: hr_utility.set_message(8301, 'GHR_38476_UPD_GHR_MSL_FAILURE');
8509: hr_utility.raise_error;
8510: END;
8511: -----Bug 2849262. Updating extra info to null is already done by Update_sel_flg in the main loop.
8512: ----- So it is not required to do in global if you see the procedure upd_ext_info_to_null
8513: ----- Commenting the following line. Dated 14-OCT-2003.
8530:
8531: EXCEPTION
8532: when others then
8533: -- raise_application_error(-20121,'Error in execute_msl_ses Err is '||sqlerrm(sqlcode));
8534: HR_UTILITY.SET_LOCATION('Error (Others2) occurred in '||l_proc||' Sql error '||sqlerrm(sqlcode),30);
8535: BEGIN
8536: ROLLBACK TO execute_msl_ses_sp;
8537: EXCEPTION
8538: WHEN OTHERS THEN NULL;
8540: l_log_text := 'Error in '||l_proc||
8541: ' For Mass Salary Name : '||p_mass_salary||
8542: ' Sql Err is '||sqlerrm(sqlcode);
8543: l_recs_failed := l_recs_failed + 1;
8544: hr_utility.set_location('before creating entry in log file',30);
8545:
8546: p_errbuf := 'Error in '||l_proc || ' Details in GHR_PROCESS_LOG';
8547: p_retcode := 2;
8548: IF upper(p_action) = 'CREATE' THEN
8558: p_message => l_log_text);
8559:
8560: exception
8561: when others then
8562: hr_utility.set_message(8301, 'Create Error Log failed');
8563: hr_utility.raise_error;
8564: end;
8565:
8566: END execute_msl_ses_range;
8559:
8560: exception
8561: when others then
8562: hr_utility.set_message(8301, 'Create Error Log failed');
8563: hr_utility.raise_error;
8564: end;
8565:
8566: END execute_msl_ses_range;
8567:
8588: l_eff_date date;
8589:
8590: begin
8591: g_proc := 'ins_upd_per_ses_extra_info';
8592: hr_utility.set_location('Entering ' || l_proc,5);
8593: if p_effective_date > sysdate then
8594: l_eff_date := sysdate;
8595: else
8596: l_eff_date := p_effective_date;
8642: ---Commented the following two lines to remove Validation functionality on Person.
8643: -- ghr_validate_perwsepi.validate_perwsepi(p_person_id);
8644: -- ghr_validate_perwsepi.update_person_user_type(p_person_id);
8645:
8646: hr_utility.set_location('Exiting ' || l_proc,10);
8647: exception
8648: when msl_error then raise;
8649: when others then
8650: pr('Error in '||l_proc);
8647: exception
8648: when msl_error then raise;
8649: when others then
8650: pr('Error in '||l_proc);
8651: hr_utility.set_location('Error in '||l_proc||' Err is '||sqlerrm(sqlcode),20);
8652: l_mslerrbuf := 'Error in '||l_proc||' Sql Err is '|| sqlerrm(sqlcode);
8653: raise msl_error;
8654: end ins_upd_per_ses_extra_info;
8655:
8675:
8676: g_proc := 'check_select_flg_ses';
8677: l_temp_ses_basic_pay := p_ses_basic_pay;
8678:
8679: hr_utility.set_location('Entering ' || l_proc,5);
8680:
8681: get_extra_info_comments(p_person_id,p_effective_date,l_sel_flag,l_comments,p_mass_salary_id,l_increase_percent,l_ses_basic_pay); -- Added by Sundar 3843306
8682:
8683: -------- Initialize the comments
8723: exception
8724: when msl_error then raise;
8725: when others then
8726: p_ses_basic_pay := l_temp_ses_basic_pay ;
8727: hr_utility.set_location('Error in '||l_proc||' Err is '||sqlerrm(sqlcode),20);
8728: l_mslerrbuf := 'Error in '||l_proc||' @'||to_char(l_line)||' Sql Err is '|| sqlerrm(sqlcode);
8729: raise msl_error;
8730: end check_select_flg_ses;
8731: