929: -- Check mandatory arguments first
930: -- Pension Scheme Name
931: hr_utility.set_location('Pension Scheme Name',15);
932:
933: hr_api.mandatory_arg_error (
934: p_api_name => l_proc_name
935: ,p_argument => 'Pension Scheme Name'
936: ,p_argument_value => p_pension_scheme_name
937: );
937: );
938:
939: -- Pension Year Start Date
940: hr_utility.set_location('Pension Year Start Date',15);
941: hr_api.mandatory_arg_error (
942: p_api_name => l_proc_name
943: ,p_argument => 'Pension Year Start Date'
944: ,p_argument_value => p_pension_year_start_dt
945: );
945: );
946:
947: -- Effective Start Date
948: hr_utility.set_location('Effective Start Date',15);
949: hr_api.mandatory_arg_error (
950: p_api_name => l_proc_name
951: ,p_argument => 'Effective Start Date'
952: ,p_argument_value => p_effective_start_date
953: );
953: );
954:
955: hr_utility.set_location('Pension Category',15);
956: -- Pension Category
957: hr_api.mandatory_arg_error (
958: p_api_name => l_proc_name
959: ,p_argument => 'Pension Category'
960: ,p_argument_value => p_pension_category
961: );
961: );
962:
963: hr_utility.set_location('Pension Provider ID',15);
964: -- Pension Provider
965: hr_api.mandatory_arg_error (
966: p_api_name => l_proc_name
967: ,p_argument => 'Pension Provider ID'
968: ,p_argument_value => p_pension_provider_id
969: );
969: );
970:
971: hr_utility.set_location('Pension Type ID',15);
972: -- Pension Type
973: hr_api.mandatory_arg_error (
974: p_api_name => l_proc_name
975: ,p_argument => 'Pension Type ID'
976: ,p_argument_value => p_pension_type_id
977: );
977: );
978:
979: hr_utility.set_location('Employee Deduction Method',15);
980: -- Employee Deduction Method
981: hr_api.mandatory_arg_error (
982: p_api_name => l_proc_name
983: ,p_argument => 'Employee Deduction Method'
984: ,p_argument_value => l_emp_deduction_method
985: );
985: );
986:
987: hr_utility.set_location('Scheme Prefix',15);
988: -- Element Base Name
989: hr_api.mandatory_arg_error (
990: p_api_name => l_proc_name
991: ,p_argument => 'Scheme Prefix'
992: ,p_argument_value => p_ele_base_name
993: );
993: );
994:
995: hr_utility.set_location('Reporting Name',15);
996: -- Reporting Name
997: hr_api.mandatory_arg_error (
998: p_api_name => l_proc_name
999: ,p_argument => 'Reporting Name'
1000: ,p_argument_value => p_ele_reporting_name
1001: );
1001: );
1002:
1003: hr_utility.set_location('Classification',15);
1004: -- Element Classification
1005: hr_api.mandatory_arg_error (
1006: p_api_name => l_proc_name
1007: ,p_argument => 'Classification'
1008: ,p_argument_value => p_ele_classification_id
1009: );
1010:
1011: -- For AVC p_associated_ocp_ele_id is mandatory
1012: IF p_pension_category = 'AVC'
1013: THEN
1014: hr_api.mandatory_arg_error (
1015: p_api_name => l_proc_name
1016: ,p_argument => 'Associated OCP Scheme'
1017: ,p_argument_value => p_associated_ocp_ele_id
1018: );
1024: --
1025: -- Check pension category lookup code
1026: --
1027:
1028: IF hr_api.not_exists_in_hr_lookups (
1029: p_effective_date => p_effective_start_date
1030: ,p_lookup_type => 'PQP_PENSION_CATEGORY'
1031: ,p_lookup_code => p_pension_category
1032: )
1114: --
1115: hr_utility.set_location (l_proc_name, 50);
1116:
1117: --
1118: IF hr_api.not_exists_in_hr_lookups (
1119: p_effective_date => p_effective_start_date
1120: ,p_lookup_type => 'PQP_PENSION_DEDUCTION_METHOD'
1121: ,p_lookup_code => l_emp_deduction_method
1122: )
1137:
1138: --
1139: IF p_eer_deduction_method IS NOT NULL
1140: THEN
1141: IF hr_api.not_exists_in_hr_lookups (
1142: p_effective_date => p_effective_start_date
1143: ,p_lookup_type => 'PQP_PENSION_DEDUCTION_METHOD'
1144: ,p_lookup_code => p_eer_deduction_method
1145: )
1164: --
1165: -- IF p_pension_category = 'OCP'
1166: -- THEN
1167: -- -- SCON
1168: -- hr_api.mandatory_arg_error (
1169: -- p_api_name => l_proc_name
1170: -- ,p_argument => 'SCON'
1171: -- ,p_argument_value => p_scon_number
1172: -- );
1179: --
1180:
1181: IF p_additional_contribution IS NOT NULL
1182: THEN
1183: IF hr_api.not_exists_in_hr_lookups (
1184: p_effective_date => p_effective_start_date
1185: ,p_lookup_type => 'PQP_PENSION_DEDUCTION_METHOD'
1186: ,p_lookup_code => p_additional_contribution
1187: )
1207: --
1208:
1209: IF p_added_years IS NOT NULL
1210: THEN
1211: IF hr_api.not_exists_in_hr_lookups (
1212: p_effective_date => p_effective_start_date
1213: ,p_lookup_type => 'PQP_PENSION_DEDUCTION_METHOD'
1214: ,p_lookup_code => p_added_years
1215: )
1235: --
1236:
1237: IF p_family_widower IS NOT NULL
1238: THEN
1239: IF hr_api.not_exists_in_hr_lookups (
1240: p_effective_date => p_effective_start_date
1241: ,p_lookup_type => 'PQP_PENSION_DEDUCTION_METHOD'
1242: ,p_lookup_code => p_family_widower
1243: )
1264: --
1265:
1266: IF p_fwc_added_years IS NOT NULL
1267: THEN
1268: IF hr_api.not_exists_in_hr_lookups (
1269: p_effective_date => p_effective_start_date
1270: ,p_lookup_type => 'PQP_PENSION_DEDUCTION_METHOD'
1271: ,p_lookup_code => p_fwc_added_years
1272: )
1294: --
1295:
1296: IF p_pension_scheme_type IS NOT NULL
1297: THEN
1298: IF hr_api.not_exists_in_hr_lookups (
1299: p_effective_date => p_effective_start_date
1300: ,p_lookup_type => 'PQP_PENSION_SCHEME_TYPE'
1301: ,p_lookup_code => p_pension_scheme_type
1302: )
1407: hr_utility.set_location (l_proc_name, 120);
1408:
1409: --
1410:
1411: IF hr_api.not_exists_in_hr_lookups (
1412: p_effective_date => p_effective_start_date
1413: ,p_lookup_type => 'TERMINATION_RULE'
1414: ,p_lookup_code => NVL (
1415: p_termination_rule
1412: p_effective_date => p_effective_start_date
1413: ,p_lookup_type => 'TERMINATION_RULE'
1414: ,p_lookup_code => NVL (
1415: p_termination_rule
1416: ,hr_api.g_varchar2
1417: )
1418: )
1419: THEN
1420: -- Invalid Termination Rule
1697: pay_balance_feeds_f_pkg.insert_row (
1698: x_rowid => l_row_id
1699: ,x_balance_feed_id => l_balance_feed_id
1700: ,x_effective_start_date => p_effective_start_date
1701: ,x_effective_end_date => hr_api.g_eot
1702: ,x_business_group_id => p_business_group_id
1703: ,x_legislation_code => NULL
1704: ,x_balance_type_id => p_balance_type_id
1705: ,x_input_value_id => l_input_value_id
1816: pay_sub_class_rules_pkg.insert_row (
1817: p_rowid => l_rowid
1818: ,p_sub_classification_rule_id => l_sub_class_rule_id
1819: ,p_effective_start_date => p_effective_start_date
1820: ,p_effective_end_date => hr_api.g_eot
1821: ,p_element_type_id => p_element_type_id
1822: ,p_classification_id => l_classification_id
1823: ,p_business_group_id => p_business_group_id
1824: ,p_legislation_code => NULL
3068: -- create only if it is pre tax and scheme type is comp/cosr
3069: -- and pension category is OCP
3070: IF l_ele_class_name = 'Pre Tax Deductions'
3071: AND p_pension_category = 'OCP'
3072: AND NVL (p_pension_scheme_type, hr_api.g_varchar2) IN
3073: ('COSR', 'COMP')
3074: THEN
3075: l_sub_class_name :=
3076: 'Pre Tax Employee Pension '
3761: --
3762: -- Convert constant values to their corresponding boolean value
3763: --
3764: l_validate :=
3765: hr_api.constant_to_boolean (p_constant_value => hr_api.g_false_num);
3766: --
3767: -- Register Surrogate ID or user key values
3768: --
3769: --
4156: --
4157: -- Convert constant values to their corresponding boolean value
4158: --
4159: l_validate :=
4160: hr_api.constant_to_boolean (p_constant_value => hr_api.g_false_num);
4161: --
4162: -- Register Surrogate ID or user key values
4163: --
4164: --