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 310: ghr_pa_requests_pkg.get_SF52_loc_ddf_details

306: l_location_id := per.location_id;
307:
308: hr_utility.set_location('The location id is:'||l_location_id,12345);
309: begin
310: ghr_pa_requests_pkg.get_SF52_loc_ddf_details
311: (p_location_id => l_location_id
312: ,p_duty_station_id => l_duty_station_id);
313: exception
314: when others then

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

312: ,p_duty_station_id => l_duty_station_id);
313: exception
314: when others then
315: hr_utility.set_location(
316: 'Error in Ghr_pa_requests_pkg.get_sf52_loc_ddf_details'||
317: 'Err is '||sqlerrm(sqlcode),20);
318: l_mlcerrbuf := 'Error in get_sf52_loc_ddf_details '||
319: 'Sql Err is '|| sqlerrm(sqlcode);
320: raise mlc_error;

Line 354: ghr_pa_requests_pkg.get_sf52_asg_ddf_details

350:
351: hr_utility.set_location('check_init_eligibility ' || l_proc,6);
352:
353: begin
354: ghr_pa_requests_pkg.get_sf52_asg_ddf_details
355: (l_assignment_id,
356: l_effective_date,
357: l_tenure,
358: l_annuitant_indicator,

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

360: l_work_schedule,
361: l_part_time_hour);
362: exception
363: when others then
364: hr_utility.set_location('Error in Ghr_pa_requests_pkg.get_sf52_asg_ddf_details'||
365: 'Err is '||sqlerrm(sqlcode),20);
366: l_mlcerrbuf := 'Error in get_sf52_asgddf_details Sql Err is '|| sqlerrm(sqlcode);
367: raise mlc_error;
368: end;

Line 406: ghr_pa_requests_pkg.get_duty_station_details

402: hr_utility.set_location('check_select_flg ' || l_proc,7);
403: BEGIN
404: hr_utility.set_location('The duty station name is:'||l_duty_station_code,12345);
405: hr_utility.set_location('The duty station desc is:'||l_duty_station_desc,12345);
406: ghr_pa_requests_pkg.get_duty_station_details
407: (p_duty_station_id => l_duty_station_id
408: ,p_effective_date => l_effective_date
409: ,p_duty_station_code => l_duty_station_code
410: ,p_duty_station_desc => l_duty_station_desc);

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

409: ,p_duty_station_code => l_duty_station_code
410: ,p_duty_station_desc => l_duty_station_desc);
411: EXCEPTION
412: when others then
413: hr_utility.set_location('Error in Ghr_pa_requests_pkg.get_duty_station_details'||
414: 'Err is '||sqlerrm(sqlcode),20);
415: l_mlcerrbuf := 'Error in get_duty_station_details Sql Err is '|| sqlerrm(sqlcode);
416: raise mlc_error;
417:

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

607: hr_utility.set_location('Supervisory Diff Amount = ' || to_char(l_supervisory_differential),10);
608:
609: -------------Call Pay cap Procedure
610: begin
611: l_capped_other_pay := ghr_pa_requests_pkg2.get_cop( p_assignment_id => l_assignment_id
612: ,p_effective_date => l_effective_date);
613: l_old_capped_other_pay := l_capped_other_pay;
614: -- Sundar Added the following if statement to improve performance
615: if hr_utility.debug_enabled = true then

Line 1503: ghr_pa_requests_pkg.get_SF52_loc_ddf_details

1499: l_location_id := p_location_id;
1500:
1501: hr_utility.set_location('The location id is:'||l_location_id,12345);
1502: begin
1503: ghr_pa_requests_pkg.get_SF52_loc_ddf_details
1504: (p_location_id => l_location_id
1505: ,p_duty_station_id => l_duty_station_id);
1506: exception
1507: when others then

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

1505: ,p_duty_station_id => l_duty_station_id);
1506: exception
1507: when others then
1508: hr_utility.set_location(
1509: 'Error in Ghr_pa_requests_pkg.get_sf52_loc_ddf_details'||
1510: 'Err is '||sqlerrm(sqlcode),20);
1511: l_mtcerrbuf := 'Error in get_sf52_loc_ddf_details '||
1512: 'Sql Err is '|| sqlerrm(sqlcode);
1513: raise mtc_error;

Line 1563: ghr_pa_requests_pkg.get_sf52_asg_ddf_details

1559: hr_utility.set_location('check_init_eligibility ' || l_proc,6);
1560: -- Get PRD, work schedule etc form ASG EI
1561:
1562: begin
1563: ghr_pa_requests_pkg.get_sf52_asg_ddf_details
1564: (l_assignment_id,
1565: l_effective_date,
1566: l_tenure,
1567: l_annuitant_indicator,

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

1569: l_work_schedule,
1570: l_part_time_hour);
1571: exception
1572: when others then
1573: hr_utility.set_location('Error in Ghr_pa_requests_pkg.get_sf52_asg_ddf_details'||
1574: 'Err is '||sqlerrm(sqlcode),20);
1575: l_mtcerrbuf := 'Error in get_sf52_asgddf_details Sql Err is '|| sqlerrm(sqlcode);
1576: raise mtc_error;
1577: end;

Line 1626: ghr_pa_requests_pkg.get_duty_station_details

1622: hr_utility.set_location('The duty station name is:'||l_duty_station_code,12345);
1623: hr_utility.set_location('The duty station desc is:'||l_duty_station_desc,12345);
1624:
1625: begin
1626: ghr_pa_requests_pkg.get_duty_station_details
1627: (p_duty_station_id => l_duty_station_id
1628: ,p_effective_date => l_effective_date
1629: ,p_duty_station_code => l_duty_station_code
1630: ,p_duty_station_desc => l_duty_station_desc);

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

1629: ,p_duty_station_code => l_duty_station_code
1630: ,p_duty_station_desc => l_duty_station_desc);
1631: exception
1632: when others then
1633: hr_utility.set_location('Error in Ghr_pa_requests_pkg.get_duty_station_details'||
1634: 'Err is '||sqlerrm(sqlcode),20);
1635: l_mtcerrbuf := 'Error in get_duty_station_details Sql Err is '|| sqlerrm(sqlcode);
1636: raise mtc_error;
1637: end;

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

1814:
1815:
1816: -------------Call Pay cap Procedure
1817: begin
1818: l_capped_other_pay := ghr_pa_requests_pkg2.get_cop( p_assignment_id => l_assignment_id
1819: ,p_effective_date => l_effective_date);
1820: l_old_capped_other_pay := l_capped_other_pay;
1821: -- Sundar Added the following if statement to improve performance
1822: if hr_utility.debug_enabled = true then

Line 2380: ghr_pa_requests_pkg.get_SF52_loc_ddf_details

2376: l_location_id := un_per.location_id;
2377:
2378: hr_utility.set_location('position valid grade table id is ' || to_char(l_pay_table_id) || l_proc,45);
2379: BEGIN
2380: ghr_pa_requests_pkg.get_SF52_loc_ddf_details
2381: (p_location_id => l_location_id
2382: ,p_duty_station_id => l_duty_station_id);
2383: END;
2384:

Line 2467: ghr_pa_requests_pkg.get_duty_station_details

2463:
2464: hr_utility.set_location('check l_pay_plan ' || l_pay_plan || l_proc,58);
2465: hr_utility.set_location('check l_grade_or_level ' || l_grade_or_level || l_proc,58);
2466: BEGIN
2467: ghr_pa_requests_pkg.get_duty_station_details
2468: (p_duty_station_id => l_duty_station_id
2469: ,p_effective_DATE => l_effective_DATE
2470: ,p_duty_station_code => l_duty_station_code
2471: ,p_duty_station_desc => l_duty_station_desc);