DBA Data[Home] [Help]

APPS.PQP_GB_PENSION_SCHEME_TEMPLATE dependencies on HR_API

Line 937: hr_api.mandatory_arg_error (

933: -- Check mandatory arguments first
934: -- Pension Scheme Name
935: hr_utility.set_location('Pension Scheme Name',15);
936:
937: hr_api.mandatory_arg_error (
938: p_api_name => l_proc_name
939: ,p_argument => 'Pension Scheme Name'
940: ,p_argument_value => p_pension_scheme_name
941: );

Line 945: hr_api.mandatory_arg_error (

941: );
942:
943: -- Pension Year Start Date
944: hr_utility.set_location('Pension Year Start Date',15);
945: hr_api.mandatory_arg_error (
946: p_api_name => l_proc_name
947: ,p_argument => 'Pension Year Start Date'
948: ,p_argument_value => p_pension_year_start_dt
949: );

Line 953: hr_api.mandatory_arg_error (

949: );
950:
951: -- Effective Start Date
952: hr_utility.set_location('Effective Start Date',15);
953: hr_api.mandatory_arg_error (
954: p_api_name => l_proc_name
955: ,p_argument => 'Effective Start Date'
956: ,p_argument_value => p_effective_start_date
957: );

Line 961: hr_api.mandatory_arg_error (

957: );
958:
959: hr_utility.set_location('Pension Category',15);
960: -- Pension Category
961: hr_api.mandatory_arg_error (
962: p_api_name => l_proc_name
963: ,p_argument => 'Pension Category'
964: ,p_argument_value => p_pension_category
965: );

Line 969: hr_api.mandatory_arg_error (

965: );
966:
967: hr_utility.set_location('Pension Provider ID',15);
968: -- Pension Provider
969: hr_api.mandatory_arg_error (
970: p_api_name => l_proc_name
971: ,p_argument => 'Pension Provider ID'
972: ,p_argument_value => p_pension_provider_id
973: );

Line 977: hr_api.mandatory_arg_error (

973: );
974:
975: hr_utility.set_location('Pension Type ID',15);
976: -- Pension Type
977: hr_api.mandatory_arg_error (
978: p_api_name => l_proc_name
979: ,p_argument => 'Pension Type ID'
980: ,p_argument_value => p_pension_type_id
981: );

Line 985: hr_api.mandatory_arg_error (

981: );
982:
983: hr_utility.set_location('Employee Deduction Method',15);
984: -- Employee Deduction Method
985: hr_api.mandatory_arg_error (
986: p_api_name => l_proc_name
987: ,p_argument => 'Employee Deduction Method'
988: ,p_argument_value => l_emp_deduction_method
989: );

Line 993: hr_api.mandatory_arg_error (

989: );
990:
991: hr_utility.set_location('Scheme Prefix',15);
992: -- Element Base Name
993: hr_api.mandatory_arg_error (
994: p_api_name => l_proc_name
995: ,p_argument => 'Scheme Prefix'
996: ,p_argument_value => p_ele_base_name
997: );

Line 1001: hr_api.mandatory_arg_error (

997: );
998:
999: hr_utility.set_location('Reporting Name',15);
1000: -- Reporting Name
1001: hr_api.mandatory_arg_error (
1002: p_api_name => l_proc_name
1003: ,p_argument => 'Reporting Name'
1004: ,p_argument_value => p_ele_reporting_name
1005: );

Line 1009: hr_api.mandatory_arg_error (

1005: );
1006:
1007: hr_utility.set_location('Classification',15);
1008: -- Element Classification
1009: hr_api.mandatory_arg_error (
1010: p_api_name => l_proc_name
1011: ,p_argument => 'Classification'
1012: ,p_argument_value => p_ele_classification_id
1013: );

Line 1018: hr_api.mandatory_arg_error (

1014:
1015: -- For AVC p_associated_ocp_ele_id is mandatory
1016: IF p_pension_category = 'AVC'
1017: THEN
1018: hr_api.mandatory_arg_error (
1019: p_api_name => l_proc_name
1020: ,p_argument => 'Associated OCP Scheme'
1021: ,p_argument_value => p_associated_ocp_ele_id
1022: );

Line 1032: IF hr_api.not_exists_in_hr_lookups (

1028: --
1029: -- Check pension category lookup code
1030: --
1031:
1032: IF hr_api.not_exists_in_hr_lookups (
1033: p_effective_date => p_effective_start_date
1034: ,p_lookup_type => 'PQP_PENSION_CATEGORY'
1035: ,p_lookup_code => p_pension_category
1036: )

Line 1122: IF hr_api.not_exists_in_hr_lookups (

1118: --
1119: hr_utility.set_location (l_proc_name, 50);
1120:
1121: --
1122: IF hr_api.not_exists_in_hr_lookups (
1123: p_effective_date => p_effective_start_date
1124: ,p_lookup_type => 'PQP_PENSION_DEDUCTION_METHOD'
1125: ,p_lookup_code => l_emp_deduction_method
1126: )

Line 1145: IF hr_api.not_exists_in_hr_lookups (

1141:
1142: --
1143: IF p_eer_deduction_method IS NOT NULL
1144: THEN
1145: IF hr_api.not_exists_in_hr_lookups (
1146: p_effective_date => p_effective_start_date
1147: ,p_lookup_type => 'PQP_PENSION_DEDUCTION_METHOD'
1148: ,p_lookup_code => p_eer_deduction_method
1149: )

Line 1172: -- hr_api.mandatory_arg_error (

1168: --
1169: -- IF p_pension_category = 'OCP'
1170: -- THEN
1171: -- -- SCON
1172: -- hr_api.mandatory_arg_error (
1173: -- p_api_name => l_proc_name
1174: -- ,p_argument => 'SCON'
1175: -- ,p_argument_value => p_scon_number
1176: -- );

Line 1187: IF hr_api.not_exists_in_hr_lookups (

1183: --
1184:
1185: IF p_additional_contribution IS NOT NULL
1186: THEN
1187: IF hr_api.not_exists_in_hr_lookups (
1188: p_effective_date => p_effective_start_date
1189: ,p_lookup_type => 'PQP_PENSION_DEDUCTION_METHOD'
1190: ,p_lookup_code => p_additional_contribution
1191: )

Line 1215: IF hr_api.not_exists_in_hr_lookups (

1211: --
1212:
1213: IF p_added_years IS NOT NULL
1214: THEN
1215: IF hr_api.not_exists_in_hr_lookups (
1216: p_effective_date => p_effective_start_date
1217: ,p_lookup_type => 'PQP_PENSION_DEDUCTION_METHOD'
1218: ,p_lookup_code => p_added_years
1219: )

Line 1243: IF hr_api.not_exists_in_hr_lookups (

1239: --
1240:
1241: IF p_family_widower IS NOT NULL
1242: THEN
1243: IF hr_api.not_exists_in_hr_lookups (
1244: p_effective_date => p_effective_start_date
1245: ,p_lookup_type => 'PQP_PENSION_DEDUCTION_METHOD'
1246: ,p_lookup_code => p_family_widower
1247: )

Line 1272: IF hr_api.not_exists_in_hr_lookups (

1268: --
1269:
1270: IF p_fwc_added_years IS NOT NULL
1271: THEN
1272: IF hr_api.not_exists_in_hr_lookups (
1273: p_effective_date => p_effective_start_date
1274: ,p_lookup_type => 'PQP_PENSION_DEDUCTION_METHOD'
1275: ,p_lookup_code => p_fwc_added_years
1276: )

Line 1302: IF hr_api.not_exists_in_hr_lookups (

1298: --
1299:
1300: IF p_pension_scheme_type IS NOT NULL
1301: THEN
1302: IF hr_api.not_exists_in_hr_lookups (
1303: p_effective_date => p_effective_start_date
1304: ,p_lookup_type => 'PQP_PENSION_SCHEME_TYPE'
1305: ,p_lookup_code => p_pension_scheme_type
1306: )

Line 1415: IF hr_api.not_exists_in_hr_lookups (

1411: hr_utility.set_location (l_proc_name, 120);
1412:
1413: --
1414:
1415: IF hr_api.not_exists_in_hr_lookups (
1416: p_effective_date => p_effective_start_date
1417: ,p_lookup_type => 'TERMINATION_RULE'
1418: ,p_lookup_code => NVL (
1419: p_termination_rule

Line 1420: ,hr_api.g_varchar2

1416: p_effective_date => p_effective_start_date
1417: ,p_lookup_type => 'TERMINATION_RULE'
1418: ,p_lookup_code => NVL (
1419: p_termination_rule
1420: ,hr_api.g_varchar2
1421: )
1422: )
1423: THEN
1424: -- Invalid Termination Rule

Line 1703: ,x_effective_end_date => hr_api.g_eot

1699: pay_balance_feeds_f_pkg.insert_row (
1700: x_rowid => l_row_id
1701: ,x_balance_feed_id => l_balance_feed_id
1702: ,x_effective_start_date => p_effective_start_date
1703: ,x_effective_end_date => hr_api.g_eot
1704: ,x_business_group_id => p_business_group_id
1705: ,x_legislation_code => NULL
1706: ,x_balance_type_id => p_balance_type_id
1707: ,x_input_value_id => l_input_value_id

Line 1822: ,p_effective_end_date => hr_api.g_eot

1818: pay_sub_class_rules_pkg.insert_row (
1819: p_rowid => l_rowid
1820: ,p_sub_classification_rule_id => l_sub_class_rule_id
1821: ,p_effective_start_date => p_effective_start_date
1822: ,p_effective_end_date => hr_api.g_eot
1823: ,p_element_type_id => p_element_type_id
1824: ,p_classification_id => l_classification_id
1825: ,p_business_group_id => p_business_group_id
1826: ,p_legislation_code => NULL

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

3070: -- create only if it is pre tax and scheme type is comp/cosr
3071: -- and pension category is OCP
3072: IF l_ele_class_name = 'Pre Tax Deductions'
3073: AND p_pension_category = 'OCP'
3074: AND NVL (p_pension_scheme_type, hr_api.g_varchar2) IN
3075: ('COSR', 'COMP')
3076: THEN
3077: l_sub_class_name :=
3078: 'Pre Tax Employee Pension '

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

3764: --
3765: -- Convert constant values to their corresponding boolean value
3766: --
3767: l_validate :=
3768: hr_api.constant_to_boolean (p_constant_value => hr_api.g_false_num);
3769: --
3770: -- Register Surrogate ID or user key values
3771: --
3772: --

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

4159: --
4160: -- Convert constant values to their corresponding boolean value
4161: --
4162: l_validate :=
4163: hr_api.constant_to_boolean (p_constant_value => hr_api.g_false_num);
4164: --
4165: -- Register Surrogate ID or user key values
4166: --
4167: --