APPS.GHR_MTO_PKG dependencies on GHR_PA_REQUESTS_PKG

Line 750: ghr_pa_requests_pkg.get_SF52_loc_ddf_details

746:
747: pr('After check sel flg value is ',l_sel_flg,l_sel_status);
748: l_ind := 70;
749: begin
750: ghr_pa_requests_pkg.get_SF52_loc_ddf_details
751: (p_location_id => l_location_id
752: ,p_duty_station_id => l_duty_station_id);
753: exception
754: when others then

Line 755: pr('Error in Ghr_pa_requests_pkg.get_sf52_asg_ddf_details');

751: (p_location_id => l_location_id
752: ,p_duty_station_id => l_duty_station_id);
753: exception
754: when others then
755: pr('Error in Ghr_pa_requests_pkg.get_sf52_asg_ddf_details');
756: hr_utility.set_location('Error in Ghr_pa_requests_pkg.get_sf52_loc_ddf_details'||
757: 'Err is '||sqlerrm(sqlcode),20);
758: l_mass_errbuf := 'Error in get_sf52_loc_ddf_details Sql Err is '||
759: sqlerrm(sqlcode);

Line 756: hr_utility.set_location('Error in Ghr_pa_requests_pkg.get_sf52_loc_ddf_details'||

752: ,p_duty_station_id => l_duty_station_id);
753: exception
754: when others then
755: pr('Error in Ghr_pa_requests_pkg.get_sf52_asg_ddf_details');
756: hr_utility.set_location('Error in Ghr_pa_requests_pkg.get_sf52_loc_ddf_details'||
757: 'Err is '||sqlerrm(sqlcode),20);
758: l_mass_errbuf := 'Error in get_sf52_loc_ddf_details Sql Err is '||
759: sqlerrm(sqlcode);
760: raise mass_error;

Line 808: ghr_pa_requests_pkg.get_sf52_asg_ddf_details

804: per.person_id) then
805:
806: l_ind := 60;
807: BEGIN
808: ghr_pa_requests_pkg.get_sf52_asg_ddf_details
809: (l_assignment_id,
810: l_effective_date,
811: l_tenure,
812: l_annuitant_indicator,

Line 818: pr('Error in Ghr_pa_requests_pkg.get_sf52_asg_ddf_details');

814: l_work_schedule,
815: l_part_time_hour);
816: EXCEPTION
817: when others then
818: pr('Error in Ghr_pa_requests_pkg.get_sf52_asg_ddf_details');
819: hr_utility.set_location('Error in Ghr_pa_requests_pkg.get_sf52_asg_ddf_details'||
820: 'Err is '||sqlerrm(sqlcode),20);
821: l_mass_errbuf := 'Error in get_sf52_asgddf_details Sql Err is '||
822: sqlerrm(sqlcode);

Line 819: hr_utility.set_location('Error in Ghr_pa_requests_pkg.get_sf52_asg_ddf_details'||

815: l_part_time_hour);
816: EXCEPTION
817: when others then
818: pr('Error in Ghr_pa_requests_pkg.get_sf52_asg_ddf_details');
819: hr_utility.set_location('Error in Ghr_pa_requests_pkg.get_sf52_asg_ddf_details'||
820: 'Err is '||sqlerrm(sqlcode),20);
821: l_mass_errbuf := 'Error in get_sf52_asgddf_details Sql Err is '||
822: sqlerrm(sqlcode);
823: raise mass_error;

Line 848: ghr_pa_requests_pkg.get_duty_station_details

844: l_appropriation_code2,
845: l_pos_grp2_rec);
846: l_ind := 90;
847: BEGIN
848: ghr_pa_requests_pkg.get_duty_station_details
849: (p_duty_station_id => l_duty_station_id
850: ,p_effective_date => l_effective_date
851: ,p_duty_station_code => l_duty_station_code
852: ,p_duty_station_desc => l_duty_station_desc);

Line 855: pr('Error in Ghr_pa_requests_pkg.get_duty_station_details');

851: ,p_duty_station_code => l_duty_station_code
852: ,p_duty_station_desc => l_duty_station_desc);
853: EXCEPTION
854: when others then
855: pr('Error in Ghr_pa_requests_pkg.get_duty_station_details');
856: hr_utility.set_location('Error in Ghr_pa_requests_pkg.get_duty_station_details'||
857: 'Err is '||sqlerrm(sqlcode),20);
858: l_mass_errbuf := 'Error in get_duty_station_details Sql Err is '||
859: sqlerrm(sqlcode);

Line 856: hr_utility.set_location('Error in Ghr_pa_requests_pkg.get_duty_station_details'||

852: ,p_duty_station_desc => l_duty_station_desc);
853: EXCEPTION
854: when others then
855: pr('Error in Ghr_pa_requests_pkg.get_duty_station_details');
856: hr_utility.set_location('Error in Ghr_pa_requests_pkg.get_duty_station_details'||
857: 'Err is '||sqlerrm(sqlcode),20);
858: l_mass_errbuf := 'Error in get_duty_station_details Sql Err is '||
859: sqlerrm(sqlcode);
860: raise mass_error;

Line 1252: ghr_pa_requests_pkg.get_SF52_loc_ddf_details

1248: l_position_organization,
1249: l_pos_grp1_rec);
1250:
1251: begin
1252: ghr_pa_requests_pkg.get_SF52_loc_ddf_details
1253: (p_location_id => l_location_id
1254: ,p_duty_station_id => l_duty_station_id);
1255: end;
1256:

Line 1258: ghr_pa_requests_pkg.get_duty_station_details

1254: ,p_duty_station_id => l_duty_station_id);
1255: end;
1256:
1257: begin
1258: ghr_pa_requests_pkg.get_duty_station_details
1259: (p_duty_station_id => l_duty_station_id
1260: ,p_effective_date => l_effective_date
1261: ,p_duty_station_code => l_duty_station_code
1262: ,p_duty_station_desc => l_duty_station_desc);