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

507: END IF;
508: -- End of bug 3437354
509:
510: /* -- BEGIN
511: ghr_pa_requests_pkg.get_SF52_loc_ddf_details
512: (p_location_id => l_location_id
513: ,p_duty_station_id => l_duty_station_id);
514: / *exception
515: when others then

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

513: ,p_duty_station_id => l_duty_station_id);
514: / *exception
515: when others then
516: hr_utility.set_location(
517: 'Error in Ghr_pa_requests_pkg.get_sf52_loc_ddf_details'||
518: 'Err is '||sqlerrm(sqlcode),20);
519: l_mslerrbuf := 'Error in get_sf52_loc_ddf_details '||
520: 'Sql Err is '|| sqlerrm(sqlcode);
521: raise msl_error;

Line 557: ghr_pa_requests_pkg.get_sf52_asg_ddf_details

553: -- Bug 3457205 Filter the Pay plan table id condition also b4 checking any other thing
554: -- Moving check_eligibility to here.
555: -- Get PRD, work schedule etc form ASG EI
556: begin
557: ghr_pa_requests_pkg.get_sf52_asg_ddf_details
558: (l_assignment_id,
559: l_effective_date,
560: l_tenure,
561: l_annuitant_indicator,

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

563: l_work_schedule,
564: l_part_time_hour);
565: exception
566: when others then
567: hr_utility.set_location('Error in Ghr_pa_requests_pkg.get_sf52_asg_ddf_details'||
568: 'Err is '||sqlerrm(sqlcode),20);
569: l_mslerrbuf := 'Error in get_sf52_asgddf_details Sql Err is '|| sqlerrm(sqlcode);
570: raise msl_error;
571: end;

Line 627: ghr_pa_requests_pkg.get_duty_station_details

623: hr_utility.set_location('check_select_flg ' || l_proc,7);
624: BEGIN
625: hr_utility.set_location('The duty station name is:'||l_duty_station_code,12345);
626: hr_utility.set_location('The duty station desc is:'||l_duty_station_desc,12345);
627: ghr_pa_requests_pkg.get_duty_station_details
628: (p_duty_station_id => l_duty_station_id
629: ,p_effective_date => l_effective_date
630: ,p_duty_station_code => l_duty_station_code
631: ,p_duty_station_desc => l_duty_station_desc);

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

630: ,p_duty_station_code => l_duty_station_code
631: ,p_duty_station_desc => l_duty_station_desc);
632: EXCEPTION
633: WHEN others THEN
634: hr_utility.set_location('Error in Ghr_pa_requests_pkg.get_duty_station_details'||
635: 'Err is '||sqlerrm(sqlcode),20);
636: l_mslerrbuf := 'Error in get_duty_station_details Sql Err is '|| sqlerrm(sqlcode);
637: RAISE msl_error;
638:

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

835:
836:
837: -------------Call Pay cap Procedure
838: begin
839: l_capped_other_pay := ghr_pa_requests_pkg2.get_cop( p_assignment_id => l_assignment_id
840: ,p_effective_date => l_effective_date);
841: l_old_capped_other_pay := l_capped_other_pay;
842: -- Sundar Added the following if statement to improve performance
843: if hr_utility.debug_enabled = true then

Line 2971: ghr_pa_requests_pkg.get_SF52_loc_ddf_details

2967: NOT(l_fetch_agency_data) THEN
2968: hr_utility.set_location('Agency PASS',30);
2969: IF p_msl_duty_station_id IS NOT NULL THEN
2970: hr_utility.set_location('DS CHECK',35);
2971: ghr_pa_requests_pkg.get_SF52_loc_ddf_details
2972: (p_location_id => l_location_id
2973: ,p_duty_station_id => l_duty_station_id);
2974: l_fetch_ds_data := TRUE;
2975: END IF;

Line 3004: ghr_pa_requests_pkg.get_sf52_asg_ddf_details

3000:
3001: -- If the initial eligibility is passed then proceed further. Otherwise move to next record.
3002: IF init_elig_flag THEN
3003: hr_utility.set_location('Init Criteria Pass',95);
3004: ghr_pa_requests_pkg.get_sf52_asg_ddf_details
3005: (l_assignment_id,
3006: l_effective_date,
3007: l_tenure,
3008: l_annuitant_indicator,

Line 3111: ghr_pa_requests_pkg.get_SF52_loc_ddf_details

3107: l_pos_grp1_rec);
3108: END IF;
3109:
3110: IF NOT l_fetch_ds_data THEN
3111: ghr_pa_requests_pkg.get_SF52_loc_ddf_details
3112: (p_location_id => l_location_id
3113: ,p_duty_station_id => l_duty_station_id);
3114: END IF;
3115:

Line 3330: ghr_pa_requests_pkg.get_SF52_loc_ddf_details

3326: NOT(l_fetch_agency_data) THEN
3327: hr_utility.set_location('Agency PASS',30);
3328: IF p_msl_duty_station_id IS NOT NULL THEN
3329: hr_utility.set_location('DS CHECK',35);
3330: ghr_pa_requests_pkg.get_SF52_loc_ddf_details
3331: (p_location_id => l_location_id
3332: ,p_duty_station_id => l_duty_station_id);
3333: l_fetch_ds_data := TRUE;
3334: END IF;

Line 3363: ghr_pa_requests_pkg.get_sf52_asg_ddf_details

3359:
3360: -- If the initial eligibility is passed then proceed further. Otherwise move to next record.
3361: IF init_elig_flag THEN
3362: hr_utility.set_location('Init Criteria Pass',95);
3363: ghr_pa_requests_pkg.get_sf52_asg_ddf_details
3364: (l_assignment_id,
3365: l_effective_date,
3366: l_tenure,
3367: l_annuitant_indicator,

Line 3464: ghr_pa_requests_pkg.get_SF52_loc_ddf_details

3460: l_pos_grp1_rec);
3461: END IF;
3462:
3463: IF NOT l_fetch_ds_data THEN
3464: ghr_pa_requests_pkg.get_SF52_loc_ddf_details
3465: (p_location_id => l_location_id
3466: ,p_duty_station_id => l_duty_station_id);
3467: END IF;
3468:

Line 3791: l_employee_number := ghr_pa_requests_pkg2.get_employee_number

3787: exit;
3788: end loop;
3789: --Bug # 9329643
3790: If p_person_id is not null then
3791: l_employee_number := ghr_pa_requests_pkg2.get_employee_number
3792: (p_person_id => p_person_id,
3793: p_effective_date => p_effective_date);
3794: End if;
3795: if l_action_taken <> 'CANCELED' then

Line 3825: l_employee_number := ghr_pa_requests_pkg2.get_employee_number

3821: exit;
3822: end loop;
3823: --Bug # 9329643
3824: If p_person_id is not null then
3825: l_employee_number := ghr_pa_requests_pkg2.get_employee_number
3826: (p_person_id => p_person_id,
3827: p_effective_date => p_effective_date);
3828: End if;
3829: if l_action_taken <> 'CANCELED' then

Line 5484: ghr_pa_requests_pkg.get_SF52_loc_ddf_details

5480: END IF;
5481: -- End of bug 3437354
5482:
5483: /*begin
5484: ghr_pa_requests_pkg.get_SF52_loc_ddf_details
5485: (p_location_id => l_location_id
5486: ,p_duty_station_id => l_duty_station_id);
5487: exception
5488: when others then

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

5486: ,p_duty_station_id => l_duty_station_id);
5487: exception
5488: when others then
5489: hr_utility.set_location(
5490: 'Error in Ghr_pa_requests_pkg.get_sf52_loc_ddf_details'||
5491: 'Err is '||sqlerrm(sqlcode),20);
5492: l_mslerrbuf := 'Error in get_sf52_loc_ddf_details '||
5493: 'Sql Err is '|| sqlerrm(sqlcode);
5494: raise msl_error;

Line 5535: ghr_pa_requests_pkg.get_sf52_asg_ddf_details

5531: -- Bug 3457205 Filter the Pay plan table id condition also b4 checking any other thing
5532: -- Moving check_eligibility to here.
5533: -- Get PRD, work schedule etc form ASG EI
5534: begin
5535: ghr_pa_requests_pkg.get_sf52_asg_ddf_details
5536: (l_assignment_id,
5537: l_effective_date,
5538: l_tenure,
5539: l_annuitant_indicator,

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

5541: l_work_schedule,
5542: l_part_time_hour);
5543: exception
5544: when others then
5545: hr_utility.set_location('Error in Ghr_pa_requests_pkg.get_sf52_asg_ddf_details'||
5546: 'Err is '||sqlerrm(sqlcode),20);
5547: l_mslerrbuf := 'Error in get_sf52_asgddf_details Sql Err is '|| sqlerrm(sqlcode);
5548: raise msl_error;
5549: end;

Line 5607: ghr_pa_requests_pkg.get_duty_station_details

5603: begin
5604: hr_utility.set_location('The duty station name is:'||l_duty_station_code,12345);
5605: hr_utility.set_location('The duty station desc is:'||l_duty_station_desc,12345);
5606:
5607: ghr_pa_requests_pkg.get_duty_station_details
5608: (p_duty_station_id => l_duty_station_id
5609: ,p_effective_date => l_effective_date
5610: ,p_duty_station_code => l_duty_station_code
5611: ,p_duty_station_desc => l_duty_station_desc);

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

5610: ,p_duty_station_code => l_duty_station_code
5611: ,p_duty_station_desc => l_duty_station_desc);
5612: exception
5613: when others then
5614: hr_utility.set_location('Error in Ghr_pa_requests_pkg.get_duty_station_details'||
5615: 'Err is '||sqlerrm(sqlcode),20);
5616: l_mslerrbuf := 'Error in get_duty_station_details Sql Err is '|| sqlerrm(sqlcode);
5617: raise msl_error;
5618:

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

5865: hr_utility.set_location('Supervisory Diff Amount = ' || to_char(l_supervisory_differential),10);
5866:
5867: -------------Call Pay cap Procedure
5868: begin
5869: l_capped_other_pay := ghr_pa_requests_pkg2.get_cop( p_assignment_id => l_assignment_id
5870: ,p_effective_date => l_effective_date);
5871: l_old_capped_other_pay := l_capped_other_pay;
5872: -- Sundar Added the following if statement to improve performance
5873: if hr_utility.debug_enabled = true then

Line 6876: ghr_pa_requests_pkg.get_SF52_loc_ddf_details

6872: NOT(l_fetch_agency_data) THEN
6873: hr_utility.set_location('Agency PASS',30);
6874: IF p_msl_duty_station_id IS NOT NULL THEN
6875: hr_utility.set_location('DS CHECK',35);
6876: ghr_pa_requests_pkg.get_SF52_loc_ddf_details
6877: (p_location_id => l_location_id
6878: ,p_duty_station_id => l_duty_station_id);
6879: l_fetch_ds_data := TRUE;
6880: END IF;

Line 6909: ghr_pa_requests_pkg.get_sf52_asg_ddf_details

6905:
6906: -- If the initial eligibility is passed then proceed further. Otherwise move to next record.
6907: IF init_elig_flag THEN
6908: hr_utility.set_location('Init Criteria Pass',95);
6909: ghr_pa_requests_pkg.get_sf52_asg_ddf_details
6910: (l_assignment_id,
6911: l_effective_date,
6912: l_tenure,
6913: l_annuitant_indicator,

Line 7042: ghr_pa_requests_pkg.get_SF52_loc_ddf_details

7038: l_pos_grp1_rec);
7039: END IF;
7040:
7041: IF NOT l_fetch_ds_data THEN
7042: ghr_pa_requests_pkg.get_SF52_loc_ddf_details
7043: (p_location_id => l_location_id
7044: ,p_duty_station_id => l_duty_station_id);
7045: END IF;
7046:

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

7517: --5470182
7518: ghr_msl_pkg.g_first_noa_code := '890';
7519: l_lac_sf52_rec.first_action_la_code1 := 'Q3C';
7520: -- l_lac_sf52_rec.first_action_la_desc1 := 'Reg. 534.404(h)';
7521: l_lac_sf52_rec.first_action_la_desc1 := ghr_pa_requests_pkg.get_lookup_description(800,'GHR_US_LEGAL_AUTHORITY','Q3C');
7522:
7523: g_proc := 'Location Validation';
7524: -- Start of Bug3437354
7525: IF l_location_id IS NULL THEN

Line 7552: ghr_pa_requests_pkg.get_SF52_loc_ddf_details

7548: END IF;
7549: -- End of bug 3437354
7550:
7551: /* -- BEGIN
7552: ghr_pa_requests_pkg.get_SF52_loc_ddf_details
7553: (p_location_id => l_location_id
7554: ,p_duty_station_id => l_duty_station_id);
7555: / *exception
7556: when others then

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

7554: ,p_duty_station_id => l_duty_station_id);
7555: / *exception
7556: when others then
7557: hr_utility.set_location(
7558: 'Error in Ghr_pa_requests_pkg.get_sf52_loc_ddf_details'||
7559: 'Err is '||sqlerrm(sqlcode),20);
7560: l_mslerrbuf := 'Error in get_sf52_loc_ddf_details '||
7561: 'Sql Err is '|| sqlerrm(sqlcode);
7562: raise msl_error;

Line 7598: ghr_pa_requests_pkg.get_sf52_asg_ddf_details

7594: -- Bug 3457205 Filter the Pay plan table id condition also b4 checking any other thing
7595: -- Moving check_eligibility to here.
7596: -- Get PRD, work schedule etc form ASG EI
7597: begin
7598: ghr_pa_requests_pkg.get_sf52_asg_ddf_details
7599: (l_assignment_id,
7600: l_effective_date,
7601: l_tenure,
7602: l_annuitant_indicator,

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

7604: l_work_schedule,
7605: l_part_time_hour);
7606: exception
7607: when others then
7608: hr_utility.set_location('Error in Ghr_pa_requests_pkg.get_sf52_asg_ddf_details'||
7609: 'Err is '||sqlerrm(sqlcode),20);
7610: l_mslerrbuf := 'Error in get_sf52_asgddf_details Sql Err is '|| sqlerrm(sqlcode);
7611: raise msl_error;
7612: end;

Line 7668: ghr_pa_requests_pkg.get_duty_station_details

7664: hr_utility.set_location('check_select_flg ' || l_proc,7);
7665: BEGIN
7666: hr_utility.set_location('The duty station name is:'||l_duty_station_code,12345);
7667: hr_utility.set_location('The duty station desc is:'||l_duty_station_desc,12345);
7668: ghr_pa_requests_pkg.get_duty_station_details
7669: (p_duty_station_id => l_duty_station_id
7670: ,p_effective_date => l_effective_date
7671: ,p_duty_station_code => l_duty_station_code
7672: ,p_duty_station_desc => l_duty_station_desc);

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

7671: ,p_duty_station_code => l_duty_station_code
7672: ,p_duty_station_desc => l_duty_station_desc);
7673: EXCEPTION
7674: WHEN others THEN
7675: hr_utility.set_location('Error in Ghr_pa_requests_pkg.get_duty_station_details'||
7676: 'Err is '||sqlerrm(sqlcode),20);
7677: l_mslerrbuf := 'Error in get_duty_station_details Sql Err is '|| sqlerrm(sqlcode);
7678: RAISE msl_error;
7679:

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

7868:
7869:
7870: -------------Call Pay cap Procedure
7871: begin
7872: l_capped_other_pay := ghr_pa_requests_pkg2.get_cop( p_assignment_id => l_assignment_id
7873: ,p_effective_date => l_effective_date);
7874: l_old_capped_other_pay := l_capped_other_pay;
7875: -- Sundar Added the following if statement to improve performance
7876: if hr_utility.debug_enabled = true then