DBA Data[Home] [Help]

APPS.PQP_GB_PENSION_SCHEME_TEMPLATE dependencies on HR_API

Line 933: hr_api.mandatory_arg_error (

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

Line 941: hr_api.mandatory_arg_error (

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

Line 949: hr_api.mandatory_arg_error (

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

Line 957: hr_api.mandatory_arg_error (

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

Line 965: hr_api.mandatory_arg_error (

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

Line 973: hr_api.mandatory_arg_error (

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

Line 981: hr_api.mandatory_arg_error (

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

Line 989: hr_api.mandatory_arg_error (

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

Line 997: hr_api.mandatory_arg_error (

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

Line 1005: hr_api.mandatory_arg_error (

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

Line 1014: hr_api.mandatory_arg_error (

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

Line 1028: IF hr_api.not_exists_in_hr_lookups (

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

Line 1118: IF hr_api.not_exists_in_hr_lookups (

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

Line 1141: IF hr_api.not_exists_in_hr_lookups (

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

Line 1168: -- hr_api.mandatory_arg_error (

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

Line 1183: IF hr_api.not_exists_in_hr_lookups (

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

Line 1211: IF hr_api.not_exists_in_hr_lookups (

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

Line 1239: IF hr_api.not_exists_in_hr_lookups (

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

Line 1268: IF hr_api.not_exists_in_hr_lookups (

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

Line 1298: IF hr_api.not_exists_in_hr_lookups (

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

Line 1411: IF hr_api.not_exists_in_hr_lookups (

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

Line 1416: ,hr_api.g_varchar2

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

Line 1701: ,x_effective_end_date => hr_api.g_eot

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

Line 1820: ,p_effective_end_date => hr_api.g_eot

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

Line 3072: AND NVL (p_pension_scheme_type, hr_api.g_varchar2) IN

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 '

Line 3765: hr_api.constant_to_boolean (p_constant_value => hr_api.g_false_num);

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: --

Line 4160: hr_api.constant_to_boolean (p_constant_value => hr_api.g_false_num);

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: --