eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GHR_MLC_PKG dependencies on GHR_PA_REQUESTS_PKG

Line 317: ghr_pa_requests_pkg.get_SF52_loc_ddf_details

313: ) then
314:
315: hr_utility.set_location('The location id is:'||l_location_id,12345);
316: begin
317: ghr_pa_requests_pkg.get_SF52_loc_ddf_details
318: (p_location_id => l_location_id
319: ,p_duty_station_id => l_duty_station_id);
320: exception
321: when others then

Line 323: 'Error in Ghr_pa_requests_pkg.get_sf52_loc_ddf_details'||

319: ,p_duty_station_id => l_duty_station_id);
320: exception
321: when others then
322: hr_utility.set_location(
323: 'Error in Ghr_pa_requests_pkg.get_sf52_loc_ddf_details'||
324: 'Err is '||sqlerrm(sqlcode),20);
325: l_mlcerrbuf := 'Error in get_sf52_loc_ddf_details '||
326: 'Sql Err is '|| sqlerrm(sqlcode);
327: raise mlc_error;

Line 361: ghr_pa_requests_pkg.get_sf52_asg_ddf_details

357:
358: hr_utility.set_location('check_init_eligibility ' || l_proc,6);
359:
360: begin
361: ghr_pa_requests_pkg.get_sf52_asg_ddf_details
362: (l_assignment_id,
363: l_effective_date,
364: l_tenure,
365: l_annuitant_indicator,

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

367: l_work_schedule,
368: l_part_time_hour);
369: exception
370: when others then
371: hr_utility.set_location('Error in Ghr_pa_requests_pkg.get_sf52_asg_ddf_details'||
372: 'Err is '||sqlerrm(sqlcode),20);
373: l_mlcerrbuf := 'Error in get_sf52_asgddf_details Sql Err is '|| sqlerrm(sqlcode);
374: raise mlc_error;
375: end;

Line 415: ghr_pa_requests_pkg.get_duty_station_details

411: hr_utility.set_location('check_select_flg ' || l_proc,7);
412: BEGIN
413: hr_utility.set_location('The duty station name is:'||l_duty_station_code,12345);
414: hr_utility.set_location('The duty station desc is:'||l_duty_station_desc,12345);
415: ghr_pa_requests_pkg.get_duty_station_details
416: (p_duty_station_id => l_duty_station_id
417: ,p_effective_date => l_effective_date
418: ,p_duty_station_code => l_duty_station_code
419: ,p_duty_station_desc => l_duty_station_desc);

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

418: ,p_duty_station_code => l_duty_station_code
419: ,p_duty_station_desc => l_duty_station_desc);
420: EXCEPTION
421: when others then
422: hr_utility.set_location('Error in Ghr_pa_requests_pkg.get_duty_station_details'||
423: 'Err is '||sqlerrm(sqlcode),20);
424: l_mlcerrbuf := 'Error in get_duty_station_details Sql Err is '|| sqlerrm(sqlcode);
425: raise mlc_error;
426:

Line 622: l_capped_other_pay := ghr_pa_requests_pkg2.get_cop( p_assignment_id => l_assignment_id

618: hr_utility.set_location('Supervisory Diff Amount = ' || to_char(l_supervisory_differential),10);
619:
620: -------------Call Pay cap Procedure
621: begin
622: l_capped_other_pay := ghr_pa_requests_pkg2.get_cop( p_assignment_id => l_assignment_id
623: ,p_effective_date => l_effective_date);
624: l_old_capped_other_pay := l_capped_other_pay;
625: -- Sundar Added the following if statement to improve performance
626: if hr_utility.debug_enabled = true then

Line 1531: ghr_pa_requests_pkg.get_SF52_loc_ddf_details

1527: l_location_id := p_location_id;
1528:
1529: hr_utility.set_location('The location id is:'||l_location_id,12345);
1530: begin
1531: ghr_pa_requests_pkg.get_SF52_loc_ddf_details
1532: (p_location_id => l_location_id
1533: ,p_duty_station_id => l_duty_station_id);
1534: exception
1535: when others then

Line 1537: 'Error in Ghr_pa_requests_pkg.get_sf52_loc_ddf_details'||

1533: ,p_duty_station_id => l_duty_station_id);
1534: exception
1535: when others then
1536: hr_utility.set_location(
1537: 'Error in Ghr_pa_requests_pkg.get_sf52_loc_ddf_details'||
1538: 'Err is '||sqlerrm(sqlcode),20);
1539: l_mtcerrbuf := 'Error in get_sf52_loc_ddf_details '||
1540: 'Sql Err is '|| sqlerrm(sqlcode);
1541: raise mtc_error;

Line 1591: ghr_pa_requests_pkg.get_sf52_asg_ddf_details

1587: hr_utility.set_location('check_init_eligibility ' || l_proc,6);
1588: -- Get PRD, work schedule etc form ASG EI
1589:
1590: begin
1591: ghr_pa_requests_pkg.get_sf52_asg_ddf_details
1592: (l_assignment_id,
1593: l_effective_date,
1594: l_tenure,
1595: l_annuitant_indicator,

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

1597: l_work_schedule,
1598: l_part_time_hour);
1599: exception
1600: when others then
1601: hr_utility.set_location('Error in Ghr_pa_requests_pkg.get_sf52_asg_ddf_details'||
1602: 'Err is '||sqlerrm(sqlcode),20);
1603: l_mtcerrbuf := 'Error in get_sf52_asgddf_details Sql Err is '|| sqlerrm(sqlcode);
1604: raise mtc_error;
1605: end;

Line 1655: ghr_pa_requests_pkg.get_duty_station_details

1651: hr_utility.set_location('The duty station name is:'||l_duty_station_code,12345);
1652: hr_utility.set_location('The duty station desc is:'||l_duty_station_desc,12345);
1653:
1654: begin
1655: ghr_pa_requests_pkg.get_duty_station_details
1656: (p_duty_station_id => l_duty_station_id
1657: ,p_effective_date => l_effective_date
1658: ,p_duty_station_code => l_duty_station_code
1659: ,p_duty_station_desc => l_duty_station_desc);

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

1658: ,p_duty_station_code => l_duty_station_code
1659: ,p_duty_station_desc => l_duty_station_desc);
1660: exception
1661: when others then
1662: hr_utility.set_location('Error in Ghr_pa_requests_pkg.get_duty_station_details'||
1663: 'Err is '||sqlerrm(sqlcode),20);
1664: l_mtcerrbuf := 'Error in get_duty_station_details Sql Err is '|| sqlerrm(sqlcode);
1665: raise mtc_error;
1666: end;

Line 1849: l_capped_other_pay := ghr_pa_requests_pkg2.get_cop( p_assignment_id => l_assignment_id

1845:
1846:
1847: -------------Call Pay cap Procedure
1848: begin
1849: l_capped_other_pay := ghr_pa_requests_pkg2.get_cop( p_assignment_id => l_assignment_id
1850: ,p_effective_date => l_effective_date);
1851: l_old_capped_other_pay := l_capped_other_pay;
1852: -- Sundar Added the following if statement to improve performance
1853: if hr_utility.debug_enabled = true then

Line 2420: ghr_pa_requests_pkg.get_SF52_loc_ddf_details

2416: l_location_id := un_per.location_id;
2417:
2418: hr_utility.set_location('position valid grade table id is ' || to_char(l_pay_table_id) || l_proc,45);
2419: BEGIN
2420: ghr_pa_requests_pkg.get_SF52_loc_ddf_details
2421: (p_location_id => l_location_id
2422: ,p_duty_station_id => l_duty_station_id);
2423: END;
2424:

Line 2507: ghr_pa_requests_pkg.get_duty_station_details

2503:
2504: hr_utility.set_location('check l_pay_plan ' || l_pay_plan || l_proc,58);
2505: hr_utility.set_location('check l_grade_or_level ' || l_grade_or_level || l_proc,58);
2506: BEGIN
2507: ghr_pa_requests_pkg.get_duty_station_details
2508: (p_duty_station_id => l_duty_station_id
2509: ,p_effective_DATE => l_effective_DATE
2510: ,p_duty_station_code => l_duty_station_code
2511: ,p_duty_station_desc => l_duty_station_desc);