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_MSL_PKG dependencies on GHR_PA_REQUESTS_PKG

Line 505: ghr_pa_requests_pkg.get_SF52_loc_ddf_details

501: END IF;
502: -- End of bug 3437354
503:
504: /* -- BEGIN
505: ghr_pa_requests_pkg.get_SF52_loc_ddf_details
506: (p_location_id => l_location_id
507: ,p_duty_station_id => l_duty_station_id);
508: / *exception
509: when others then

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

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);
515: raise msl_error;

Line 551: ghr_pa_requests_pkg.get_sf52_asg_ddf_details

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
551: ghr_pa_requests_pkg.get_sf52_asg_ddf_details
552: (l_assignment_id,
553: l_effective_date,
554: l_tenure,
555: l_annuitant_indicator,

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

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;

Line 620: ghr_pa_requests_pkg.get_duty_station_details

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
624: ,p_duty_station_desc => l_duty_station_desc);

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

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:

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

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

Line 2941: ghr_pa_requests_pkg.get_SF52_loc_ddf_details

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;
2945: END IF;

Line 2974: ghr_pa_requests_pkg.get_sf52_asg_ddf_details

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,
2978: l_annuitant_indicator,

Line 3080: ghr_pa_requests_pkg.get_SF52_loc_ddf_details

3076: l_pos_grp1_rec);
3077: END IF;
3078:
3079: IF NOT l_fetch_ds_data THEN
3080: ghr_pa_requests_pkg.get_SF52_loc_ddf_details
3081: (p_location_id => l_location_id
3082: ,p_duty_station_id => l_duty_station_id);
3083: END IF;
3084:

Line 3297: ghr_pa_requests_pkg.get_SF52_loc_ddf_details

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;
3301: END IF;

Line 3330: ghr_pa_requests_pkg.get_sf52_asg_ddf_details

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,
3334: l_annuitant_indicator,

Line 3430: ghr_pa_requests_pkg.get_SF52_loc_ddf_details

3426: l_pos_grp1_rec);
3427: END IF;
3428:
3429: IF NOT l_fetch_ds_data THEN
3430: ghr_pa_requests_pkg.get_SF52_loc_ddf_details
3431: (p_location_id => l_location_id
3432: ,p_duty_station_id => l_duty_station_id);
3433: END IF;
3434:

Line 5380: ghr_pa_requests_pkg.get_SF52_loc_ddf_details

5376: END IF;
5377: -- End of bug 3437354
5378:
5379: /*begin
5380: ghr_pa_requests_pkg.get_SF52_loc_ddf_details
5381: (p_location_id => l_location_id
5382: ,p_duty_station_id => l_duty_station_id);
5383: exception
5384: when others then

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

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);
5390: raise msl_error;

Line 5431: ghr_pa_requests_pkg.get_sf52_asg_ddf_details

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
5431: ghr_pa_requests_pkg.get_sf52_asg_ddf_details
5432: (l_assignment_id,
5433: l_effective_date,
5434: l_tenure,
5435: l_annuitant_indicator,

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

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;

Line 5503: ghr_pa_requests_pkg.get_duty_station_details

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);

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

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:

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

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

Line 6735: ghr_pa_requests_pkg.get_SF52_loc_ddf_details

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;
6739: END IF;

Line 6768: ghr_pa_requests_pkg.get_sf52_asg_ddf_details

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,
6772: l_annuitant_indicator,

Line 6900: ghr_pa_requests_pkg.get_SF52_loc_ddf_details

6896: l_pos_grp1_rec);
6897: END IF;
6898:
6899: IF NOT l_fetch_ds_data THEN
6900: ghr_pa_requests_pkg.get_SF52_loc_ddf_details
6901: (p_location_id => l_location_id
6902: ,p_duty_station_id => l_duty_station_id);
6903: END IF;
6904:

Line 7373: l_lac_sf52_rec.first_action_la_desc1 := ghr_pa_requests_pkg.get_lookup_description(800,'GHR_US_LEGAL_AUTHORITY','Q3C');

7369: --5470182
7370: ghr_msl_pkg.g_first_noa_code := '890';
7371: l_lac_sf52_rec.first_action_la_code1 := 'Q3C';
7372: -- l_lac_sf52_rec.first_action_la_desc1 := 'Reg. 534.404(h)';
7373: l_lac_sf52_rec.first_action_la_desc1 := ghr_pa_requests_pkg.get_lookup_description(800,'GHR_US_LEGAL_AUTHORITY','Q3C');
7374:
7375: g_proc := 'Location Validation';
7376: -- Start of Bug3437354
7377: IF l_location_id IS NULL THEN

Line 7404: ghr_pa_requests_pkg.get_SF52_loc_ddf_details

7400: END IF;
7401: -- End of bug 3437354
7402:
7403: /* -- BEGIN
7404: ghr_pa_requests_pkg.get_SF52_loc_ddf_details
7405: (p_location_id => l_location_id
7406: ,p_duty_station_id => l_duty_station_id);
7407: / *exception
7408: when others then

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

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);
7414: raise msl_error;

Line 7450: ghr_pa_requests_pkg.get_sf52_asg_ddf_details

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
7450: ghr_pa_requests_pkg.get_sf52_asg_ddf_details
7451: (l_assignment_id,
7452: l_effective_date,
7453: l_tenure,
7454: l_annuitant_indicator,

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

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;

Line 7520: ghr_pa_requests_pkg.get_duty_station_details

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
7524: ,p_duty_station_desc => l_duty_station_desc);

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

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:

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

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