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_VALIDATE_CHECK dependencies on HR_API

Line 5: ,p_per_group1 IN ghr_api.per_group1_type

1: package body GHR_Validate_CHECK AS
2: /* $Header: ghrvalid.pkb 120.46.12020000.11 2013/02/15 09:06:23 utokachi ship $ */
3:
4: procedure Validate_CHECK(p_pa_request_rec IN ghr_pa_requests%ROWTYPE
5: ,p_per_group1 IN ghr_api.per_group1_type
6: ,p_per_retained_grade IN ghr_api.per_retained_grade_type
7: ,p_per_sep_retire in ghr_api.per_sep_retire_type
8: ,p_per_conversions in ghr_api.per_conversions_type
9: ,p_per_uniformed_services in ghr_api.per_uniformed_services_type

Line 6: ,p_per_retained_grade IN ghr_api.per_retained_grade_type

2: /* $Header: ghrvalid.pkb 120.46.12020000.11 2013/02/15 09:06:23 utokachi ship $ */
3:
4: procedure Validate_CHECK(p_pa_request_rec IN ghr_pa_requests%ROWTYPE
5: ,p_per_group1 IN ghr_api.per_group1_type
6: ,p_per_retained_grade IN ghr_api.per_retained_grade_type
7: ,p_per_sep_retire in ghr_api.per_sep_retire_type
8: ,p_per_conversions in ghr_api.per_conversions_type
9: ,p_per_uniformed_services in ghr_api.per_uniformed_services_type
10: ,p_pos_grp1 in ghr_api.pos_grp1_type

Line 7: ,p_per_sep_retire in ghr_api.per_sep_retire_type

3:
4: procedure Validate_CHECK(p_pa_request_rec IN ghr_pa_requests%ROWTYPE
5: ,p_per_group1 IN ghr_api.per_group1_type
6: ,p_per_retained_grade IN ghr_api.per_retained_grade_type
7: ,p_per_sep_retire in ghr_api.per_sep_retire_type
8: ,p_per_conversions in ghr_api.per_conversions_type
9: ,p_per_uniformed_services in ghr_api.per_uniformed_services_type
10: ,p_pos_grp1 in ghr_api.pos_grp1_type
11: ,p_pos_valid_grade in ghr_api.pos_valid_grade_type

Line 8: ,p_per_conversions in ghr_api.per_conversions_type

4: procedure Validate_CHECK(p_pa_request_rec IN ghr_pa_requests%ROWTYPE
5: ,p_per_group1 IN ghr_api.per_group1_type
6: ,p_per_retained_grade IN ghr_api.per_retained_grade_type
7: ,p_per_sep_retire in ghr_api.per_sep_retire_type
8: ,p_per_conversions in ghr_api.per_conversions_type
9: ,p_per_uniformed_services in ghr_api.per_uniformed_services_type
10: ,p_pos_grp1 in ghr_api.pos_grp1_type
11: ,p_pos_valid_grade in ghr_api.pos_valid_grade_type
12: ,p_loc_info in ghr_api.loc_info_type

Line 9: ,p_per_uniformed_services in ghr_api.per_uniformed_services_type

5: ,p_per_group1 IN ghr_api.per_group1_type
6: ,p_per_retained_grade IN ghr_api.per_retained_grade_type
7: ,p_per_sep_retire in ghr_api.per_sep_retire_type
8: ,p_per_conversions in ghr_api.per_conversions_type
9: ,p_per_uniformed_services in ghr_api.per_uniformed_services_type
10: ,p_pos_grp1 in ghr_api.pos_grp1_type
11: ,p_pos_valid_grade in ghr_api.pos_valid_grade_type
12: ,p_loc_info in ghr_api.loc_info_type
13: ,p_sf52_from_data in ghr_api.prior_sf52_data_type

Line 10: ,p_pos_grp1 in ghr_api.pos_grp1_type

6: ,p_per_retained_grade IN ghr_api.per_retained_grade_type
7: ,p_per_sep_retire in ghr_api.per_sep_retire_type
8: ,p_per_conversions in ghr_api.per_conversions_type
9: ,p_per_uniformed_services in ghr_api.per_uniformed_services_type
10: ,p_pos_grp1 in ghr_api.pos_grp1_type
11: ,p_pos_valid_grade in ghr_api.pos_valid_grade_type
12: ,p_loc_info in ghr_api.loc_info_type
13: ,p_sf52_from_data in ghr_api.prior_sf52_data_type
14: ,p_personal_info in ghr_api.personal_info_type

Line 11: ,p_pos_valid_grade in ghr_api.pos_valid_grade_type

7: ,p_per_sep_retire in ghr_api.per_sep_retire_type
8: ,p_per_conversions in ghr_api.per_conversions_type
9: ,p_per_uniformed_services in ghr_api.per_uniformed_services_type
10: ,p_pos_grp1 in ghr_api.pos_grp1_type
11: ,p_pos_valid_grade in ghr_api.pos_valid_grade_type
12: ,p_loc_info in ghr_api.loc_info_type
13: ,p_sf52_from_data in ghr_api.prior_sf52_data_type
14: ,p_personal_info in ghr_api.personal_info_type
15: ,p_agency_code in varchar2

Line 12: ,p_loc_info in ghr_api.loc_info_type

8: ,p_per_conversions in ghr_api.per_conversions_type
9: ,p_per_uniformed_services in ghr_api.per_uniformed_services_type
10: ,p_pos_grp1 in ghr_api.pos_grp1_type
11: ,p_pos_valid_grade in ghr_api.pos_valid_grade_type
12: ,p_loc_info in ghr_api.loc_info_type
13: ,p_sf52_from_data in ghr_api.prior_sf52_data_type
14: ,p_personal_info in ghr_api.personal_info_type
15: ,p_agency_code in varchar2
16: ,p_gov_awards_type in ghr_api.government_awards_type

Line 13: ,p_sf52_from_data in ghr_api.prior_sf52_data_type

9: ,p_per_uniformed_services in ghr_api.per_uniformed_services_type
10: ,p_pos_grp1 in ghr_api.pos_grp1_type
11: ,p_pos_valid_grade in ghr_api.pos_valid_grade_type
12: ,p_loc_info in ghr_api.loc_info_type
13: ,p_sf52_from_data in ghr_api.prior_sf52_data_type
14: ,p_personal_info in ghr_api.personal_info_type
15: ,p_agency_code in varchar2
16: ,p_gov_awards_type in ghr_api.government_awards_type
17: ,p_perf_appraisal_type in ghr_api.performance_appraisal_type

Line 14: ,p_personal_info in ghr_api.personal_info_type

10: ,p_pos_grp1 in ghr_api.pos_grp1_type
11: ,p_pos_valid_grade in ghr_api.pos_valid_grade_type
12: ,p_loc_info in ghr_api.loc_info_type
13: ,p_sf52_from_data in ghr_api.prior_sf52_data_type
14: ,p_personal_info in ghr_api.personal_info_type
15: ,p_agency_code in varchar2
16: ,p_gov_awards_type in ghr_api.government_awards_type
17: ,p_perf_appraisal_type in ghr_api.performance_appraisal_type
18: ,p_health_plan in varchar2

Line 16: ,p_gov_awards_type in ghr_api.government_awards_type

12: ,p_loc_info in ghr_api.loc_info_type
13: ,p_sf52_from_data in ghr_api.prior_sf52_data_type
14: ,p_personal_info in ghr_api.personal_info_type
15: ,p_agency_code in varchar2
16: ,p_gov_awards_type in ghr_api.government_awards_type
17: ,p_perf_appraisal_type in ghr_api.performance_appraisal_type
18: ,p_health_plan in varchar2
19: ,p_asg_non_sf52 in ghr_api.asg_non_sf52_type
20: --Pradeep

Line 17: ,p_perf_appraisal_type in ghr_api.performance_appraisal_type

13: ,p_sf52_from_data in ghr_api.prior_sf52_data_type
14: ,p_personal_info in ghr_api.personal_info_type
15: ,p_agency_code in varchar2
16: ,p_gov_awards_type in ghr_api.government_awards_type
17: ,p_perf_appraisal_type in ghr_api.performance_appraisal_type
18: ,p_health_plan in varchar2
19: ,p_asg_non_sf52 in ghr_api.asg_non_sf52_type
20: --Pradeep
21: ,p_premium_pay in ghr_api.premium_pay_type

Line 19: ,p_asg_non_sf52 in ghr_api.asg_non_sf52_type

15: ,p_agency_code in varchar2
16: ,p_gov_awards_type in ghr_api.government_awards_type
17: ,p_perf_appraisal_type in ghr_api.performance_appraisal_type
18: ,p_health_plan in varchar2
19: ,p_asg_non_sf52 in ghr_api.asg_non_sf52_type
20: --Pradeep
21: ,p_premium_pay in ghr_api.premium_pay_type
22: --Bug#5036370
23: ,p_per_service_oblig in ghr_api.per_service_oblig_type

Line 21: ,p_premium_pay in ghr_api.premium_pay_type

17: ,p_perf_appraisal_type in ghr_api.performance_appraisal_type
18: ,p_health_plan in varchar2
19: ,p_asg_non_sf52 in ghr_api.asg_non_sf52_type
20: --Pradeep
21: ,p_premium_pay in ghr_api.premium_pay_type
22: --Bug#5036370
23: ,p_per_service_oblig in ghr_api.per_service_oblig_type
24: ,p_within_grade_incr in ghr_api.within_grade_increase_type --Bug 5527363
25: ) IS

Line 23: ,p_per_service_oblig in ghr_api.per_service_oblig_type

19: ,p_asg_non_sf52 in ghr_api.asg_non_sf52_type
20: --Pradeep
21: ,p_premium_pay in ghr_api.premium_pay_type
22: --Bug#5036370
23: ,p_per_service_oblig in ghr_api.per_service_oblig_type
24: ,p_within_grade_incr in ghr_api.within_grade_increase_type --Bug 5527363
25: ) IS
26: l_assignment_found boolean := FALSE;
27: l_per_system_status VARCHAR2(30);

Line 24: ,p_within_grade_incr in ghr_api.within_grade_increase_type --Bug 5527363

20: --Pradeep
21: ,p_premium_pay in ghr_api.premium_pay_type
22: --Bug#5036370
23: ,p_per_service_oblig in ghr_api.per_service_oblig_type
24: ,p_within_grade_incr in ghr_api.within_grade_increase_type --Bug 5527363
25: ) IS
26: l_assignment_found boolean := FALSE;
27: l_per_system_status VARCHAR2(30);
28:

Line 204: l_temp_step per_people_extra_info.pei_information9%type := hr_api.g_varchar2;

200: SELECT rei_information3 temp_step
201: FROM ghr_pa_request_extra_info
202: WHERE pa_request_id = p_pa_request_rec.pa_request_id
203: AND information_type = 'GHR_US_PAR_RG_TEMP_PROMO';
204: l_temp_step per_people_extra_info.pei_information9%type := hr_api.g_varchar2;
205:
206: -- Family Code
207: -- Bug # 1145963
208: -- Bug#3941541 Added effective date condition.

Line 535: l_special_info_type ghr_api.special_information_type;

531: /* Bug#5132121 Service Obligation for Student Loan and MD/DDS */
532:
533: --8528195
534: l_adj_basic_pay_amt NUMBER;
535: l_special_info_type ghr_api.special_information_type;
536: l_value VARCHAR2(60);
537: l_multi_error_flag BOOLEAN;
538: --8528195
539: --Begin Bug# 12557463

Line 1031: ghr_api.retrieve_element_entry_value

1027:
1028:
1029: If p_pa_request_rec.first_noa_code = '818' then -- if AUo
1030: -- check if the person already gets an AP
1031: ghr_api.retrieve_element_entry_value
1032: (P_ELEMENT_NAME => 'Availability Pay',
1033: P_INPUT_VALUE_NAME => 'Premium Pay Ind',
1034: P_ASSIGNMENT_ID => p_pa_request_rec.employee_assignment_id,
1035: P_EFFECTIVE_DATE => p_pa_request_rec.effective_date,

Line 1040: ghr_api.retrieve_element_entry_value

1036: P_VALUE => l_Prem_pay,
1037: P_MULTIPLE_ERROR_FLAG => l_multiple_error_flag
1038: );
1039:
1040: ghr_api.retrieve_element_entry_value
1041: (P_ELEMENT_NAME => 'Availability Pay',
1042: P_INPUT_VALUE_NAME => 'Amount',
1043: P_ASSIGNMENT_ID => p_pa_request_rec.employee_assignment_id,
1044: P_EFFECTIVE_DATE => p_pa_request_rec.effective_date,

Line 1057: ghr_api.retrieve_element_entry_value

1053: End if;
1054:
1055: Elsif p_pa_request_rec.first_noa_code = '819' then -- if AP
1056: -- check if the person already gets an AUO
1057: ghr_api.retrieve_element_entry_value
1058: (P_ELEMENT_NAME => 'AUO',
1059: P_INPUT_VALUE_NAME => 'Premium Pay Ind',
1060: P_ASSIGNMENT_ID => p_pa_request_rec.employee_assignment_id,
1061: P_EFFECTIVE_DATE => p_pa_request_rec.effective_date,

Line 1066: ghr_api.retrieve_element_entry_value

1062: P_VALUE => l_Prem_pay,
1063: P_MULTIPLE_ERROR_FLAG => l_multiple_error_flag
1064: );
1065:
1066: ghr_api.retrieve_element_entry_value
1067: (P_ELEMENT_NAME => 'AUO',
1068: P_INPUT_VALUE_NAME => 'Amount',
1069: P_ASSIGNMENT_ID => p_pa_request_rec.employee_assignment_id,
1070: P_EFFECTIVE_DATE => p_pa_request_rec.effective_date,

Line 1138: ghr_api.retrieve_element_entry_value (p_element_name => 'Adjusted Basic Pay'

1134: p_effective_date => p_pa_request_rec.effective_date,
1135: p_special_info => l_special_info_type
1136: );
1137: if l_special_info_type.segment6 is not null then
1138: ghr_api.retrieve_element_entry_value (p_element_name => 'Adjusted Basic Pay'
1139: ,p_input_value_name => 'Amount'
1140: ,p_assignment_id => p_pa_request_rec.employee_assignment_id
1141: ,p_effective_date => fnd_date.canonical_to_date(l_special_info_type.segment6)
1142: ,p_value => l_value

Line 1462: ghr_api.retrieve_element_entry_value (p_element_name => 'Student Loan Repayment'

1458: END IF;
1459: END IF;
1460:
1461: IF l_repay_sch = 'L' THEN
1462: ghr_api.retrieve_element_entry_value (p_element_name => 'Student Loan Repayment'
1463: ,p_input_value_name => 'Amount'
1464: ,p_assignment_id => p_pa_request_rec.employee_assignment_id
1465: ,p_effective_date => p_pa_request_rec.effective_date
1466: ,p_value => l_slr_recur_amount

Line 1473: ghr_api.retrieve_element_entry_value (p_element_name => 'Student Loan Repayment LumpSum'

1469: hr_utility.set_message(8301,'GHR_38864_ERR_CHG_REPAYMNT');
1470: hr_utility.raise_error;
1471: end if;
1472: else
1473: ghr_api.retrieve_element_entry_value (p_element_name => 'Student Loan Repayment LumpSum'
1474: ,p_input_value_name => 'Amount'
1475: ,p_assignment_id => p_pa_request_rec.employee_assignment_id
1476: ,p_effective_date => p_pa_request_rec.effective_date
1477: ,p_value => l_slr_lumpsum

Line 1505: ghr_api.retrieve_element_entry_value

1501: --- check for other pay null for first time 810,818,819 actions
1502:
1503: IF p_pa_request_rec.first_noa_code = '810'
1504: and l_session.noa_id_correct is NULL THEN
1505: ghr_api.retrieve_element_entry_value
1506: (p_element_name => 'Retention Allowance',
1507: p_input_value_name => 'Amount',
1508: p_assignment_id => p_pa_request_rec.employee_assignment_id,
1509: p_effective_date => p_pa_request_rec.effective_date,

Line 1513: ghr_api.retrieve_element_entry_value

1509: p_effective_date => p_pa_request_rec.effective_date,
1510: p_value => l_reta_amount,
1511: p_multiple_error_flag => l_multiple_error_flag
1512: );
1513: ghr_api.retrieve_element_entry_value
1514: (p_element_name => 'Supervisory Differential',
1515: p_input_value_name => 'Amount',
1516: p_assignment_id => p_pa_request_rec.employee_assignment_id,
1517: p_effective_date => p_pa_request_rec.effective_date,

Line 1521: ghr_api.retrieve_element_entry_value

1517: p_effective_date => p_pa_request_rec.effective_date,
1518: p_value => l_supv_amount,
1519: p_multiple_error_flag => l_multiple_error_flag
1520: );
1521: ghr_api.retrieve_element_entry_value
1522: (p_element_name => 'Staffing Differential',
1523: p_input_value_name => 'Amount',
1524: p_assignment_id => p_pa_request_rec.employee_assignment_id,
1525: p_effective_date => p_pa_request_rec.effective_date,

Line 1559: ghr_api.retrieve_element_entry_value

1555: END LOOP;
1556:
1557: IF l_premium_pay_ind IS NULL THEN
1558:
1559: ghr_api.retrieve_element_entry_value
1560: (p_element_name => 'Premium Pay',
1561: p_input_value_name => 'Premium Pay Ind',
1562: p_assignment_id => p_pa_request_rec.employee_assignment_id,
1563: p_effective_date => p_pa_request_rec.effective_date,

Line 1632: ghr_api.retrieve_element_entry_value

1628: hr_utility.raise_error;
1629:
1630: End If;
1631:
1632: ghr_api.retrieve_element_entry_value
1633: (P_ELEMENT_NAME => 'Availability Pay',
1634: P_INPUT_VALUE_NAME => 'Amount',
1635: P_ASSIGNMENT_ID => p_pa_request_rec.employee_assignment_id,
1636: P_EFFECTIVE_DATE => p_pa_request_rec.effective_date,

Line 1642: ghr_api.retrieve_element_entry_value

1638: P_MULTIPLE_ERROR_FLAG => l_multiple_error_flag
1639: );
1640: hr_utility.set_location('AP Amount '||l_ap_amount,7);
1641:
1642: ghr_api.retrieve_element_entry_value
1643: (P_ELEMENT_NAME => 'AUO',
1644: P_INPUT_VALUE_NAME => 'Amount',
1645: P_ASSIGNMENT_ID => p_pa_request_rec.employee_assignment_id,
1646: P_EFFECTIVE_DATE => p_pa_request_rec.effective_date,

Line 1743: ghr_api.retrieve_element_entry_value

1739: l_null_list := null;
1740:
1741: If l_mddds_special_pay_amount is NULL or l_mddds_special_pay_amount = 0 THEN
1742:
1743: ghr_api.retrieve_element_entry_value
1744: (p_element_name => 'MDDDS Special Pay',
1745: p_input_value_name => 'Amount',
1746: p_assignment_id => p_pa_request_rec.employee_assignment_id,
1747: p_effective_date => p_pa_request_rec.effective_date,

Line 1760: ghr_api.retrieve_element_entry_value

1756: END IF;
1757:
1758: If l_mddds_specia_pay_nte_date is NULL THEN
1759:
1760: ghr_api.retrieve_element_entry_value
1761: (p_element_name => 'MDDDS Special Pay',
1762: p_input_value_name => 'MDDDS Special Pay NTE Date',
1763: p_assignment_id => p_pa_request_rec.employee_assignment_id,
1764: p_effective_date => p_pa_request_rec.effective_date,

Line 1902: ghr_api.retrieve_element_entry_value

1898: END LOOP;
1899:
1900: hr_utility.set_location('Premium Pay Ind '|| l_premium_pay_ind,3);
1901: IF l_premium_pay_ind IS NULL THEN
1902: ghr_api.retrieve_element_entry_value
1903: (p_element_name => 'Premium Pay',
1904: p_input_value_name => 'Premium Pay Ind',
1905: p_assignment_id => p_pa_request_rec.employee_assignment_id,
1906: p_effective_date => p_pa_request_rec.effective_date,

Line 1944: ghr_api.retrieve_element_entry_value

1940: hr_utility.set_location('Premium Pay Ind '|| l_premium_pay_ind,3);
1941:
1942: IF l_premium_pay_ind IS NULL THEN
1943: --Bug#3579579
1944: ghr_api.retrieve_element_entry_value
1945: (p_element_name => 'Premium Pay',
1946: p_input_value_name => 'Premium Pay Ind',
1947: p_assignment_id => p_pa_request_rec.employee_assignment_id,
1948: p_effective_date => p_pa_request_rec.effective_date,

Line 2003: ghr_api.retrieve_element_entry_value

1999: -- END IF;
2000:
2001: IF p_pa_request_rec.first_noa_code = '819'
2002: and l_session.noa_id_correct is NULL THEN
2003: ghr_api.retrieve_element_entry_value
2004: (P_ELEMENT_NAME => 'Availability Pay',
2005: P_INPUT_VALUE_NAME => 'Amount',
2006: P_ASSIGNMENT_ID => p_pa_request_rec.employee_assignment_id,
2007: P_EFFECTIVE_DATE => p_pa_request_rec.effective_date,

Line 2021: ghr_api.retrieve_element_entry_value

2017: END IF;
2018:
2019: --Pradeep
2020: --Title 38 Employess should not get Avaialability Pay.
2021: ghr_api.retrieve_element_entry_value
2022: (p_element_name => 'Premium Pay',
2023: p_input_value_name => 'Premium Pay Ind',
2024: p_assignment_id => p_pa_request_rec.employee_assignment_id,
2025: p_effective_date => p_pa_request_rec.effective_date,

Line 2059: ghr_api.retrieve_element_entry_value

2055: END IF;
2056:
2057: IF p_pa_request_rec.first_noa_code = '818'
2058: and l_session.noa_id_correct is NULL THEN
2059: ghr_api.retrieve_element_entry_value
2060: (P_ELEMENT_NAME => 'AUO',
2061: P_INPUT_VALUE_NAME => 'Amount',
2062: P_ASSIGNMENT_ID => p_pa_request_rec.employee_assignment_id,
2063: P_EFFECTIVE_DATE => p_pa_request_rec.effective_date,

Line 2077: ghr_api.retrieve_element_entry_value

2073: END IF;
2074:
2075: --Pradeep
2076: --Title 38 Employess should not get AUO.
2077: ghr_api.retrieve_element_entry_value
2078: (p_element_name => 'Premium Pay',
2079: p_input_value_name => 'Premium Pay Ind',
2080: p_assignment_id => p_pa_request_rec.employee_assignment_id,
2081: p_effective_date => p_pa_request_rec.effective_date,

Line 2173: ghr_api.retrieve_element_entry_value

2169: -- check whether more than one other pay is changed for NOA 810
2170: --
2171: if p_pa_request_rec.first_noa_code = '810' then
2172: l_for_810_count := 0;
2173: ghr_api.retrieve_element_entry_value
2174: (p_element_name => 'Retention Allowance',
2175: p_input_value_name => 'Amount',
2176: p_assignment_id => p_pa_request_rec.employee_assignment_id,
2177: p_effective_date => p_pa_request_rec.effective_date,

Line 2184: ghr_api.retrieve_element_entry_value

2180: );
2181: if NVL(p_pa_request_rec.to_retention_allowance,0) <> NVL(l_amount,0) then
2182: l_for_810_count := l_for_810_count + 1;
2183: end if;
2184: ghr_api.retrieve_element_entry_value
2185: (p_element_name => 'Supervisory Differential',
2186: p_input_value_name => 'Amount',
2187: p_assignment_id => p_pa_request_rec.employee_assignment_id,
2188: p_effective_date => p_pa_request_rec.effective_date,

Line 2195: ghr_api.retrieve_element_entry_value

2191: );
2192: if NVL(p_pa_request_rec.to_supervisory_differential,0) <> NVL(l_amount,0) then
2193: l_for_810_count := l_for_810_count + 1;
2194: end if;
2195: ghr_api.retrieve_element_entry_value
2196: (p_element_name => 'Staffing Differential',
2197: p_input_value_name => 'Amount',
2198: p_assignment_id => p_pa_request_rec.employee_assignment_id,
2199: p_effective_date => p_pa_request_rec.effective_date,

Line 2529: IF NOT(p_pa_request_rec.retirement_plan = '4' AND NVL(p_pa_request_rec.annuitant_indicator,hr_api.g_varchar2) NOT IN ('2','3','9')) THEN --Bug# 11808857

2525: END IF;
2526: --Bug# 15941036 added Retirement codes DR,KR,LR,MR,NR,PR
2527: IF p_pa_request_rec.retirement_plan IS NOT NULL AND p_pa_request_rec.retirement_plan NOT IN ('D','K','L','M','N','P','DR','KR','LR','MR','NR','PR')
2528: AND l_tsp_scd IS NOT NULL THEN
2529: IF NOT(p_pa_request_rec.retirement_plan = '4' AND NVL(p_pa_request_rec.annuitant_indicator,hr_api.g_varchar2) NOT IN ('2','3','9')) THEN --Bug# 11808857
2530: hr_utility.set_message(8301,'GHR_38392_NON_TSP_FERS');
2531: hr_utility.raise_error;
2532: END IF;
2533: END IF;

Line 2553: IF NOT(p_pa_request_rec.retirement_plan = '4' AND NVL(p_pa_request_rec.annuitant_indicator,hr_api.g_varchar2) NOT IN ('2','3','9')) THEN

2549: END IF;
2550: --Bug# 15941036 added Retirement codes DR,KR,LR,MR,NR,PR
2551: IF p_pa_request_rec.retirement_plan IS NOT NULL AND p_pa_request_rec.retirement_plan NOT IN ('D','K','L','M','N','P','DR','KR','LR','MR','NR','PR')
2552: AND l_tsp_scd IS NOT NULL THEN
2553: IF NOT(p_pa_request_rec.retirement_plan = '4' AND NVL(p_pa_request_rec.annuitant_indicator,hr_api.g_varchar2) NOT IN ('2','3','9')) THEN
2554: hr_utility.set_message(8301,'GHR_38392_NON_TSP_FERS');
2555: hr_utility.raise_error;
2556: END IF;
2557: END IF;