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.PQP_GB_PENSION_SCHEME_TEMPLATE dependencies on FND_MESSAGE

Line 360: fnd_message.set_name ('PQP', 'PQP_230933_ELE_TYPE_NOTFOUND');

356:
357: IF csr_get_ele_id%NOTFOUND
358: THEN
359: CLOSE csr_get_ele_id;
360: fnd_message.set_name ('PQP', 'PQP_230933_ELE_TYPE_NOTFOUND');
361: fnd_message.set_token ('ELEMENT_TYPE', p_object_name);
362: fnd_message.raise_error;
363: END IF; -- End if of csr ele id row not found check ...
364: hr_utility.set_location ( 'l_object_id (ELE) : '||l_object_id, 15);

Line 361: fnd_message.set_token ('ELEMENT_TYPE', p_object_name);

357: IF csr_get_ele_id%NOTFOUND
358: THEN
359: CLOSE csr_get_ele_id;
360: fnd_message.set_name ('PQP', 'PQP_230933_ELE_TYPE_NOTFOUND');
361: fnd_message.set_token ('ELEMENT_TYPE', p_object_name);
362: fnd_message.raise_error;
363: END IF; -- End if of csr ele id row not found check ...
364: hr_utility.set_location ( 'l_object_id (ELE) : '||l_object_id, 15);
365:

Line 362: fnd_message.raise_error;

358: THEN
359: CLOSE csr_get_ele_id;
360: fnd_message.set_name ('PQP', 'PQP_230933_ELE_TYPE_NOTFOUND');
361: fnd_message.set_token ('ELEMENT_TYPE', p_object_name);
362: fnd_message.raise_error;
363: END IF; -- End if of csr ele id row not found check ...
364: hr_utility.set_location ( 'l_object_id (ELE) : '||l_object_id, 15);
365:
366: CLOSE csr_get_ele_id;

Line 375: fnd_message.set_name ('PQP', 'PQP_230932_BAL_TYPE_NOTFOUND');

371:
372: IF csr_get_bal_id%NOTFOUND
373: THEN
374: CLOSE csr_get_bal_id;
375: fnd_message.set_name ('PQP', 'PQP_230932_BAL_TYPE_NOTFOUND');
376: fnd_message.set_token ('BALANCE_TYPE', p_object_name);
377: fnd_message.raise_error;
378: END IF; -- End if of csr bal id row not found check ...
379: hr_utility.set_location ( 'l_object_id (BAL) : '||l_object_id, 15);

Line 376: fnd_message.set_token ('BALANCE_TYPE', p_object_name);

372: IF csr_get_bal_id%NOTFOUND
373: THEN
374: CLOSE csr_get_bal_id;
375: fnd_message.set_name ('PQP', 'PQP_230932_BAL_TYPE_NOTFOUND');
376: fnd_message.set_token ('BALANCE_TYPE', p_object_name);
377: fnd_message.raise_error;
378: END IF; -- End if of csr bal id row not found check ...
379: hr_utility.set_location ( 'l_object_id (BAL) : '||l_object_id, 15);
380:

Line 377: fnd_message.raise_error;

373: THEN
374: CLOSE csr_get_bal_id;
375: fnd_message.set_name ('PQP', 'PQP_230932_BAL_TYPE_NOTFOUND');
376: fnd_message.set_token ('BALANCE_TYPE', p_object_name);
377: fnd_message.raise_error;
378: END IF; -- End if of csr bal id row not found check ...
379: hr_utility.set_location ( 'l_object_id (BAL) : '||l_object_id, 15);
380:
381: CLOSE csr_get_bal_id;

Line 581: fnd_message.set_name ('PQP', 'PQP_230923_SCHEME_PREFIX_ERR');

577:
578: EXCEPTION
579: WHEN OTHERS
580: THEN
581: fnd_message.set_name ('PQP', 'PQP_230923_SCHEME_PREFIX_ERR');
582: fnd_message.raise_error;
583: END chk_scheme_prefix;
584:
585: --

Line 582: fnd_message.raise_error;

578: EXCEPTION
579: WHEN OTHERS
580: THEN
581: fnd_message.set_name ('PQP', 'PQP_230923_SCHEME_PREFIX_ERR');
582: fnd_message.raise_error;
583: END chk_scheme_prefix;
584:
585: --
586:

Line 627: fnd_message.set_name ('PQP', 'PQP_230549_BAL_TYPE_NOT_FOUND');

623:
624: IF csr_get_bal_info%NOTFOUND
625: THEN
626: CLOSE csr_get_bal_info;
627: fnd_message.set_name ('PQP', 'PQP_230549_BAL_TYPE_NOT_FOUND');
628: fnd_message.raise_error;
629: END IF; -- End if of row found check ...
630:
631: hr_utility.set_location ( 'l_balance_name : '|| l_balance_name, 20);

Line 628: fnd_message.raise_error;

624: IF csr_get_bal_info%NOTFOUND
625: THEN
626: CLOSE csr_get_bal_info;
627: fnd_message.set_name ('PQP', 'PQP_230549_BAL_TYPE_NOT_FOUND');
628: fnd_message.raise_error;
629: END IF; -- End if of row found check ...
630:
631: hr_utility.set_location ( 'l_balance_name : '|| l_balance_name, 20);
632:

Line 793: fnd_message.set_name ('PQP', 'PQP_230934_PEN_TYPE_ID_INVALID');

789:
790: IF csr_get_pension_type_info%NOTFOUND
791: THEN
792: CLOSE csr_get_pension_type_info;
793: fnd_message.set_name ('PQP', 'PQP_230934_PEN_TYPE_ID_INVALID');
794: fnd_message.raise_error;
795: END IF; -- End if of pension type row found check ...
796:
797: CLOSE csr_get_pension_type_info;

Line 794: fnd_message.raise_error;

790: IF csr_get_pension_type_info%NOTFOUND
791: THEN
792: CLOSE csr_get_pension_type_info;
793: fnd_message.set_name ('PQP', 'PQP_230934_PEN_TYPE_ID_INVALID');
794: fnd_message.raise_error;
795: END IF; -- End if of pension type row found check ...
796:
797: CLOSE csr_get_pension_type_info;
798:

Line 1035: fnd_message.set_name ('PAY', 'HR_52966_INVALID_LOOKUP');

1031: ,p_lookup_code => p_pension_category
1032: )
1033: THEN
1034: -- Invalid Pension Category
1035: fnd_message.set_name ('PAY', 'HR_52966_INVALID_LOOKUP');
1036: fnd_message.set_token ('COLUMN', 'Pension Category');
1037: fnd_message.set_token ('LOOKUP_TYPE', 'PQP_PENSION_CATEGORY');
1038:
1039: hr_utility.set_location (l_proc_name, 25);

Line 1036: fnd_message.set_token ('COLUMN', 'Pension Category');

1032: )
1033: THEN
1034: -- Invalid Pension Category
1035: fnd_message.set_name ('PAY', 'HR_52966_INVALID_LOOKUP');
1036: fnd_message.set_token ('COLUMN', 'Pension Category');
1037: fnd_message.set_token ('LOOKUP_TYPE', 'PQP_PENSION_CATEGORY');
1038:
1039: hr_utility.set_location (l_proc_name, 25);
1040:

Line 1037: fnd_message.set_token ('LOOKUP_TYPE', 'PQP_PENSION_CATEGORY');

1033: THEN
1034: -- Invalid Pension Category
1035: fnd_message.set_name ('PAY', 'HR_52966_INVALID_LOOKUP');
1036: fnd_message.set_token ('COLUMN', 'Pension Category');
1037: fnd_message.set_token ('LOOKUP_TYPE', 'PQP_PENSION_CATEGORY');
1038:
1039: hr_utility.set_location (l_proc_name, 25);
1040:
1041: fnd_message.raise_error;

Line 1041: fnd_message.raise_error;

1037: fnd_message.set_token ('LOOKUP_TYPE', 'PQP_PENSION_CATEGORY');
1038:
1039: hr_utility.set_location (l_proc_name, 25);
1040:
1041: fnd_message.raise_error;
1042: END IF; -- End if of not exists in lookup check ...
1043:
1044: -- Check Pension Provider exists for this BG
1045: --

Line 1055: fnd_message.set_name ('PQP', 'PQP_230936_PEN_PROV_ID_INVALID');

1051:
1052: IF csr_chk_provider_exists%NOTFOUND
1053: THEN
1054: CLOSE csr_chk_provider_exists;
1055: fnd_message.set_name ('PQP', 'PQP_230936_PEN_PROV_ID_INVALID');
1056: fnd_message.raise_error;
1057: END IF; -- End if of provider exists row not found check ...
1058:
1059: CLOSE csr_chk_provider_exists;

Line 1056: fnd_message.raise_error;

1052: IF csr_chk_provider_exists%NOTFOUND
1053: THEN
1054: CLOSE csr_chk_provider_exists;
1055: fnd_message.set_name ('PQP', 'PQP_230936_PEN_PROV_ID_INVALID');
1056: fnd_message.raise_error;
1057: END IF; -- End if of provider exists row not found check ...
1058:
1059: CLOSE csr_chk_provider_exists;
1060: -- Get Pension Type Info

Line 1086: fnd_message.set_name ('PQP', 'PQP_230938_PEN_TYP_CAT_NOTSUP');

1082: -- Validate whether the pension type supports the pension category
1083: IF g_tab_pension_types_info (p_pension_type_id).pension_category <>
1084: p_pension_category
1085: THEN
1086: fnd_message.set_name ('PQP', 'PQP_230938_PEN_TYP_CAT_NOTSUP');
1087: fnd_message.set_token (
1088: 'PENSION_CATEGORY'
1089: ,hr_general.decode_lookup (
1090: 'PQP_PENSION_CATEGORY'

Line 1087: fnd_message.set_token (

1083: IF g_tab_pension_types_info (p_pension_type_id).pension_category <>
1084: p_pension_category
1085: THEN
1086: fnd_message.set_name ('PQP', 'PQP_230938_PEN_TYP_CAT_NOTSUP');
1087: fnd_message.set_token (
1088: 'PENSION_CATEGORY'
1089: ,hr_general.decode_lookup (
1090: 'PQP_PENSION_CATEGORY'
1091: ,p_pension_category

Line 1094: fnd_message.raise_error;

1090: 'PQP_PENSION_CATEGORY'
1091: ,p_pension_category
1092: )
1093: );
1094: fnd_message.raise_error;
1095: END IF; -- End if of pension category in pension type matches with parameter check ...
1096:
1097: -- Check pension type is supported by this pension provider
1098: --

Line 1108: fnd_message.set_name ('PQP', 'PQP_230937_PEN_TYP_NOTIN_PROV');

1104:
1105: IF csr_chk_pens_type_in_prov%NOTFOUND
1106: THEN
1107: CLOSE csr_chk_pens_type_in_prov;
1108: fnd_message.set_name ('PQP', 'PQP_230937_PEN_TYP_NOTIN_PROV');
1109: fnd_message.raise_error;
1110: END IF; -- End if of pension type in provider not found check ...
1111:
1112: CLOSE csr_chk_pens_type_in_prov;

Line 1109: fnd_message.raise_error;

1105: IF csr_chk_pens_type_in_prov%NOTFOUND
1106: THEN
1107: CLOSE csr_chk_pens_type_in_prov;
1108: fnd_message.set_name ('PQP', 'PQP_230937_PEN_TYP_NOTIN_PROV');
1109: fnd_message.raise_error;
1110: END IF; -- End if of pension type in provider not found check ...
1111:
1112: CLOSE csr_chk_pens_type_in_prov;
1113: -- Check employee deduction method in lookup

Line 1125: fnd_message.set_name ('PAY', 'HR_52966_INVALID_LOOKUP');

1121: ,p_lookup_code => l_emp_deduction_method
1122: )
1123: THEN
1124: -- Invalid Deduction Method
1125: fnd_message.set_name ('PAY', 'HR_52966_INVALID_LOOKUP');
1126: fnd_message.set_token ('COLUMN', 'Employee Deduction Method');
1127: fnd_message.set_token (
1128: 'LOOKUP_TYPE'
1129: ,'PQP_PENSION_DEDUCTION_METHOD'

Line 1126: fnd_message.set_token ('COLUMN', 'Employee Deduction Method');

1122: )
1123: THEN
1124: -- Invalid Deduction Method
1125: fnd_message.set_name ('PAY', 'HR_52966_INVALID_LOOKUP');
1126: fnd_message.set_token ('COLUMN', 'Employee Deduction Method');
1127: fnd_message.set_token (
1128: 'LOOKUP_TYPE'
1129: ,'PQP_PENSION_DEDUCTION_METHOD'
1130: );

Line 1127: fnd_message.set_token (

1123: THEN
1124: -- Invalid Deduction Method
1125: fnd_message.set_name ('PAY', 'HR_52966_INVALID_LOOKUP');
1126: fnd_message.set_token ('COLUMN', 'Employee Deduction Method');
1127: fnd_message.set_token (
1128: 'LOOKUP_TYPE'
1129: ,'PQP_PENSION_DEDUCTION_METHOD'
1130: );
1131: fnd_message.raise_error;

Line 1131: fnd_message.raise_error;

1127: fnd_message.set_token (
1128: 'LOOKUP_TYPE'
1129: ,'PQP_PENSION_DEDUCTION_METHOD'
1130: );
1131: fnd_message.raise_error;
1132: END IF; -- End if of not exists in lookup check ...
1133:
1134: -- Check employer deduction method in lookup
1135: --

Line 1148: fnd_message.set_name ('PAY', 'HR_52966_INVALID_LOOKUP');

1144: ,p_lookup_code => p_eer_deduction_method
1145: )
1146: THEN
1147: -- Invalid Deduction Method
1148: fnd_message.set_name ('PAY', 'HR_52966_INVALID_LOOKUP');
1149: fnd_message.set_token ('COLUMN', 'Employer Deduction Method');
1150: fnd_message.set_token (
1151: 'LOOKUP_TYPE'
1152: ,'PQP_PENSION_DEDUCTION_METHOD'

Line 1149: fnd_message.set_token ('COLUMN', 'Employer Deduction Method');

1145: )
1146: THEN
1147: -- Invalid Deduction Method
1148: fnd_message.set_name ('PAY', 'HR_52966_INVALID_LOOKUP');
1149: fnd_message.set_token ('COLUMN', 'Employer Deduction Method');
1150: fnd_message.set_token (
1151: 'LOOKUP_TYPE'
1152: ,'PQP_PENSION_DEDUCTION_METHOD'
1153: );

Line 1150: fnd_message.set_token (

1146: THEN
1147: -- Invalid Deduction Method
1148: fnd_message.set_name ('PAY', 'HR_52966_INVALID_LOOKUP');
1149: fnd_message.set_token ('COLUMN', 'Employer Deduction Method');
1150: fnd_message.set_token (
1151: 'LOOKUP_TYPE'
1152: ,'PQP_PENSION_DEDUCTION_METHOD'
1153: );
1154: fnd_message.raise_error;

Line 1154: fnd_message.raise_error;

1150: fnd_message.set_token (
1151: 'LOOKUP_TYPE'
1152: ,'PQP_PENSION_DEDUCTION_METHOD'
1153: );
1154: fnd_message.raise_error;
1155: END IF; -- End if of not exists in lookup check ...
1156: END IF; -- End if of employer deduction method specified check ...
1157:
1158: -- NOT required now

Line 1190: fnd_message.set_name ('PAY', 'HR_52966_INVALID_LOOKUP');

1186: ,p_lookup_code => p_additional_contribution
1187: )
1188: THEN
1189: -- Invalid Deduction Method
1190: fnd_message.set_name ('PAY', 'HR_52966_INVALID_LOOKUP');
1191: fnd_message.set_token (
1192: 'COLUMN'
1193: ,'Additional Contribution Deduction Method'
1194: );

Line 1191: fnd_message.set_token (

1187: )
1188: THEN
1189: -- Invalid Deduction Method
1190: fnd_message.set_name ('PAY', 'HR_52966_INVALID_LOOKUP');
1191: fnd_message.set_token (
1192: 'COLUMN'
1193: ,'Additional Contribution Deduction Method'
1194: );
1195: fnd_message.set_token (

Line 1195: fnd_message.set_token (

1191: fnd_message.set_token (
1192: 'COLUMN'
1193: ,'Additional Contribution Deduction Method'
1194: );
1195: fnd_message.set_token (
1196: 'LOOKUP_TYPE'
1197: ,'PQP_PENSION_DEDUCTION_METHOD'
1198: );
1199: fnd_message.raise_error;

Line 1199: fnd_message.raise_error;

1195: fnd_message.set_token (
1196: 'LOOKUP_TYPE'
1197: ,'PQP_PENSION_DEDUCTION_METHOD'
1198: );
1199: fnd_message.raise_error;
1200: END IF; -- End if of not exists in lookup check ...
1201: END IF; -- End if of additional contribution deduction method specified check ...
1202:
1203: -- Check deduction method codes for Addded Years contributions

Line 1218: fnd_message.set_name ('PAY', 'HR_52966_INVALID_LOOKUP');

1214: ,p_lookup_code => p_added_years
1215: )
1216: THEN
1217: -- Invalid Deduction Method
1218: fnd_message.set_name ('PAY', 'HR_52966_INVALID_LOOKUP');
1219: fnd_message.set_token (
1220: 'COLUMN'
1221: ,'Added Years Deduction Method'
1222: );

Line 1219: fnd_message.set_token (

1215: )
1216: THEN
1217: -- Invalid Deduction Method
1218: fnd_message.set_name ('PAY', 'HR_52966_INVALID_LOOKUP');
1219: fnd_message.set_token (
1220: 'COLUMN'
1221: ,'Added Years Deduction Method'
1222: );
1223: fnd_message.set_token (

Line 1223: fnd_message.set_token (

1219: fnd_message.set_token (
1220: 'COLUMN'
1221: ,'Added Years Deduction Method'
1222: );
1223: fnd_message.set_token (
1224: 'LOOKUP_TYPE'
1225: ,'PQP_PENSION_DEDUCTION_METHOD'
1226: );
1227: fnd_message.raise_error;

Line 1227: fnd_message.raise_error;

1223: fnd_message.set_token (
1224: 'LOOKUP_TYPE'
1225: ,'PQP_PENSION_DEDUCTION_METHOD'
1226: );
1227: fnd_message.raise_error;
1228: END IF; -- End if of not exists in lookup check ...
1229: END IF; -- End if of added years deduction method specified check ...
1230:
1231: -- Check deduction method codes for Family Widower

Line 1246: fnd_message.set_name ('PAY', 'HR_52966_INVALID_LOOKUP');

1242: ,p_lookup_code => p_family_widower
1243: )
1244: THEN
1245: -- Invalid Deduction Method
1246: fnd_message.set_name ('PAY', 'HR_52966_INVALID_LOOKUP');
1247: fnd_message.set_token (
1248: 'COLUMN'
1249: ,'Family Widower Deduction Method'
1250: );

Line 1247: fnd_message.set_token (

1243: )
1244: THEN
1245: -- Invalid Deduction Method
1246: fnd_message.set_name ('PAY', 'HR_52966_INVALID_LOOKUP');
1247: fnd_message.set_token (
1248: 'COLUMN'
1249: ,'Family Widower Deduction Method'
1250: );
1251: fnd_message.set_token (

Line 1251: fnd_message.set_token (

1247: fnd_message.set_token (
1248: 'COLUMN'
1249: ,'Family Widower Deduction Method'
1250: );
1251: fnd_message.set_token (
1252: 'LOOKUP_TYPE'
1253: ,'PQP_PENSION_DEDUCTION_METHOD'
1254: );
1255: fnd_message.raise_error;

Line 1255: fnd_message.raise_error;

1251: fnd_message.set_token (
1252: 'LOOKUP_TYPE'
1253: ,'PQP_PENSION_DEDUCTION_METHOD'
1254: );
1255: fnd_message.raise_error;
1256: END IF; -- End if of not exists in lookup check ...
1257: END IF; -- End if of family widower contribution deduction method specified check ...
1258:
1259:

Line 1275: fnd_message.set_name ('PAY', 'HR_52966_INVALID_LOOKUP');

1271: ,p_lookup_code => p_fwc_added_years
1272: )
1273: THEN
1274: -- Invalid Deduction Method
1275: fnd_message.set_name ('PAY', 'HR_52966_INVALID_LOOKUP');
1276: fnd_message.set_token (
1277: 'COLUMN'
1278: ,'Family Widower Added Years Deduction Method'
1279: );

Line 1276: fnd_message.set_token (

1272: )
1273: THEN
1274: -- Invalid Deduction Method
1275: fnd_message.set_name ('PAY', 'HR_52966_INVALID_LOOKUP');
1276: fnd_message.set_token (
1277: 'COLUMN'
1278: ,'Family Widower Added Years Deduction Method'
1279: );
1280: fnd_message.set_token (

Line 1280: fnd_message.set_token (

1276: fnd_message.set_token (
1277: 'COLUMN'
1278: ,'Family Widower Added Years Deduction Method'
1279: );
1280: fnd_message.set_token (
1281: 'LOOKUP_TYPE'
1282: ,'PQP_PENSION_DEDUCTION_METHOD'
1283: );
1284: fnd_message.raise_error;

Line 1284: fnd_message.raise_error;

1280: fnd_message.set_token (
1281: 'LOOKUP_TYPE'
1282: ,'PQP_PENSION_DEDUCTION_METHOD'
1283: );
1284: fnd_message.raise_error;
1285: END IF; -- End if of not exists in lookup check ...
1286: END IF; -- End if of added years deduction method specified check ...
1287:
1288:

Line 1305: fnd_message.set_name ('PAY', 'HR_52966_INVALID_LOOKUP');

1301: ,p_lookup_code => p_pension_scheme_type
1302: )
1303: THEN
1304: -- Invalid Pension Scheme Type
1305: fnd_message.set_name ('PAY', 'HR_52966_INVALID_LOOKUP');
1306: fnd_message.set_token ('COLUMN', 'Pension Scheme Type');
1307: fnd_message.set_token (
1308: 'LOOKUP_TYPE'
1309: ,'PQP_PENSION_SCHEME_TYPE'

Line 1306: fnd_message.set_token ('COLUMN', 'Pension Scheme Type');

1302: )
1303: THEN
1304: -- Invalid Pension Scheme Type
1305: fnd_message.set_name ('PAY', 'HR_52966_INVALID_LOOKUP');
1306: fnd_message.set_token ('COLUMN', 'Pension Scheme Type');
1307: fnd_message.set_token (
1308: 'LOOKUP_TYPE'
1309: ,'PQP_PENSION_SCHEME_TYPE'
1310: );

Line 1307: fnd_message.set_token (

1303: THEN
1304: -- Invalid Pension Scheme Type
1305: fnd_message.set_name ('PAY', 'HR_52966_INVALID_LOOKUP');
1306: fnd_message.set_token ('COLUMN', 'Pension Scheme Type');
1307: fnd_message.set_token (
1308: 'LOOKUP_TYPE'
1309: ,'PQP_PENSION_SCHEME_TYPE'
1310: );
1311: fnd_message.raise_error;

Line 1311: fnd_message.raise_error;

1307: fnd_message.set_token (
1308: 'LOOKUP_TYPE'
1309: ,'PQP_PENSION_SCHEME_TYPE'
1310: );
1311: fnd_message.raise_error;
1312: END IF; -- End if of not exists in lookup check ...
1313:
1314: -- Check whether ECON and SCON values are entered
1315: -- Ideally for a scheme of this type should have these

Line 1330: -- fnd_message.set_name ('PQP', 'PQP_230983_PEN_SCON_ECON_NULL');

1326: -- IF p_scon_number IS NULL
1327: -- OR l_econ_number IS NULL
1328: -- THEN
1329: -- -- Raise an error
1330: -- fnd_message.set_name ('PQP', 'PQP_230983_PEN_SCON_ECON_NULL');
1331: -- hr_multi_message.add
1332: -- (p_associated_column4
1333: -- => 'PQP_GB_PENSION_SCHEMES_V.SCON'
1334: -- );

Line 1355: fnd_message.set_name ('PQP', 'PQP_230984_SCON_INVALID_FORMAT');

1351:
1352: IF l_scon_number <> l_scon_format
1353: THEN
1354: -- Raise an error
1355: fnd_message.set_name ('PQP', 'PQP_230984_SCON_INVALID_FORMAT');
1356: fnd_message.raise_error;
1357: END IF; -- End if of scon number in invalid check ...
1358: END IF; -- End if of scon number entered check ...
1359:

Line 1356: fnd_message.raise_error;

1352: IF l_scon_number <> l_scon_format
1353: THEN
1354: -- Raise an error
1355: fnd_message.set_name ('PQP', 'PQP_230984_SCON_INVALID_FORMAT');
1356: fnd_message.raise_error;
1357: END IF; -- End if of scon number in invalid check ...
1358: END IF; -- End if of scon number entered check ...
1359:
1360: --

Line 1378: fnd_message.set_name ('PQP', 'PQP_230172_ECON_INVALID_FORMAT');

1374:
1375: IF l_econ_number <> l_econ_format
1376: THEN
1377: -- Raise an error
1378: fnd_message.set_name ('PQP', 'PQP_230172_ECON_INVALID_FORMAT');
1379: fnd_message.raise_error;
1380: END IF; -- End if of econ number in invalid check ...
1381: END IF; -- End if of econ number entered check ...
1382:

Line 1379: fnd_message.raise_error;

1375: IF l_econ_number <> l_econ_format
1376: THEN
1377: -- Raise an error
1378: fnd_message.set_name ('PQP', 'PQP_230172_ECON_INVALID_FORMAT');
1379: fnd_message.raise_error;
1380: END IF; -- End if of econ number in invalid check ...
1381: END IF; -- End if of econ number entered check ...
1382:
1383: --

Line 1398: fnd_message.set_name ('PQP', 'PQP_230944_PEN_OCP_SCH_INVALID');

1394: IF csr_chk_ocp_ele_info%NOTFOUND
1395: THEN
1396: -- Raise error
1397: CLOSE csr_chk_ocp_ele_info;
1398: fnd_message.set_name ('PQP', 'PQP_230944_PEN_OCP_SCH_INVALID');
1399: fnd_message.raise_error;
1400: END IF; -- End if of ocp ele not found check ...
1401:
1402: CLOSE csr_chk_ocp_ele_info;

Line 1399: fnd_message.raise_error;

1395: THEN
1396: -- Raise error
1397: CLOSE csr_chk_ocp_ele_info;
1398: fnd_message.set_name ('PQP', 'PQP_230944_PEN_OCP_SCH_INVALID');
1399: fnd_message.raise_error;
1400: END IF; -- End if of ocp ele not found check ...
1401:
1402: CLOSE csr_chk_ocp_ele_info;
1403: END IF; -- End if of associated ocp ele id not null check ...

Line 1421: fnd_message.set_name ('PAY', 'HR_52966_INVALID_LOOKUP');

1417: )
1418: )
1419: THEN
1420: -- Invalid Termination Rule
1421: fnd_message.set_name ('PAY', 'HR_52966_INVALID_LOOKUP');
1422: fnd_message.set_token ('COLUMN', 'Termination Rule');
1423: fnd_message.set_token ('LOOKUP_TYPE', 'TERMINATION_RULE');
1424: fnd_message.raise_error;
1425: END IF; -- End if of not exists in lookup check ...

Line 1422: fnd_message.set_token ('COLUMN', 'Termination Rule');

1418: )
1419: THEN
1420: -- Invalid Termination Rule
1421: fnd_message.set_name ('PAY', 'HR_52966_INVALID_LOOKUP');
1422: fnd_message.set_token ('COLUMN', 'Termination Rule');
1423: fnd_message.set_token ('LOOKUP_TYPE', 'TERMINATION_RULE');
1424: fnd_message.raise_error;
1425: END IF; -- End if of not exists in lookup check ...
1426:

Line 1423: fnd_message.set_token ('LOOKUP_TYPE', 'TERMINATION_RULE');

1419: THEN
1420: -- Invalid Termination Rule
1421: fnd_message.set_name ('PAY', 'HR_52966_INVALID_LOOKUP');
1422: fnd_message.set_token ('COLUMN', 'Termination Rule');
1423: fnd_message.set_token ('LOOKUP_TYPE', 'TERMINATION_RULE');
1424: fnd_message.raise_error;
1425: END IF; -- End if of not exists in lookup check ...
1426:
1427: --

Line 1424: fnd_message.raise_error;

1420: -- Invalid Termination Rule
1421: fnd_message.set_name ('PAY', 'HR_52966_INVALID_LOOKUP');
1422: fnd_message.set_token ('COLUMN', 'Termination Rule');
1423: fnd_message.set_token ('LOOKUP_TYPE', 'TERMINATION_RULE');
1424: fnd_message.raise_error;
1425: END IF; -- End if of not exists in lookup check ...
1426:
1427: --
1428: hr_utility.set_location ( 'Leaving: '

Line 1469: fnd_message.set_name ('PER', 'HR_289263_FORMULA_ID_INVALID');

1465:
1466: IF csr_get_formula_info%NOTFOUND
1467: THEN
1468: CLOSE csr_get_formula_info;
1469: fnd_message.set_name ('PER', 'HR_289263_FORMULA_ID_INVALID');
1470: fnd_message.raise_error;
1471: END IF; -- End if of csr row not found check ...
1472:
1473: CLOSE csr_get_formula_info;

Line 1470: fnd_message.raise_error;

1466: IF csr_get_formula_info%NOTFOUND
1467: THEN
1468: CLOSE csr_get_formula_info;
1469: fnd_message.set_name ('PER', 'HR_289263_FORMULA_ID_INVALID');
1470: fnd_message.raise_error;
1471: END IF; -- End if of csr row not found check ...
1472:
1473: CLOSE csr_get_formula_info;
1474: --

Line 1518: fnd_message.set_name ('PER', 'HR_289263_FORMULA_ID_INVALID');

1514:
1515: IF csr_get_formula_info%NOTFOUND
1516: THEN
1517: CLOSE csr_get_formula_info;
1518: fnd_message.set_name ('PER', 'HR_289263_FORMULA_ID_INVALID');
1519: fnd_message.raise_error;
1520: END IF; -- End if of csr row not found check ...
1521:
1522: CLOSE csr_get_formula_info;

Line 1519: fnd_message.raise_error;

1515: IF csr_get_formula_info%NOTFOUND
1516: THEN
1517: CLOSE csr_get_formula_info;
1518: fnd_message.set_name ('PER', 'HR_289263_FORMULA_ID_INVALID');
1519: fnd_message.raise_error;
1520: END IF; -- End if of csr row not found check ...
1521:
1522: CLOSE csr_get_formula_info;
1523: l_formula_text :=

Line 1597: fnd_message.set_name ('PQP', 'PQP_230935_INPUT_VAL_NOTFOUND');

1593:
1594: IF csr_get_ipv_info%NOTFOUND
1595: THEN
1596: CLOSE csr_get_ipv_info;
1597: fnd_message.set_name ('PQP', 'PQP_230935_INPUT_VAL_NOTFOUND');
1598: fnd_message.set_token ('INPUT_VALUE', p_input_value_name);
1599: fnd_message.raise_error;
1600: END IF; -- End if of csr row not found check ...
1601:

Line 1598: fnd_message.set_token ('INPUT_VALUE', p_input_value_name);

1594: IF csr_get_ipv_info%NOTFOUND
1595: THEN
1596: CLOSE csr_get_ipv_info;
1597: fnd_message.set_name ('PQP', 'PQP_230935_INPUT_VAL_NOTFOUND');
1598: fnd_message.set_token ('INPUT_VALUE', p_input_value_name);
1599: fnd_message.raise_error;
1600: END IF; -- End if of csr row not found check ...
1601:
1602: CLOSE csr_get_ipv_info;

Line 1599: fnd_message.raise_error;

1595: THEN
1596: CLOSE csr_get_ipv_info;
1597: fnd_message.set_name ('PQP', 'PQP_230935_INPUT_VAL_NOTFOUND');
1598: fnd_message.set_token ('INPUT_VALUE', p_input_value_name);
1599: fnd_message.raise_error;
1600: END IF; -- End if of csr row not found check ...
1601:
1602: CLOSE csr_get_ipv_info;
1603:

Line 1748: fnd_message.set_name ('PQP', 'PQP_230944_PEN_OCP_SCH_INVALID');

1744:
1745: IF csr_get_scheme_prefix%NOTFOUND
1746: THEN
1747: CLOSE csr_get_scheme_prefix;
1748: fnd_message.set_name ('PQP', 'PQP_230944_PEN_OCP_SCH_INVALID');
1749: fnd_message.raise_error;
1750: END IF; -- End if of row not found check ...
1751:
1752: CLOSE csr_get_scheme_prefix;

Line 1749: fnd_message.raise_error;

1745: IF csr_get_scheme_prefix%NOTFOUND
1746: THEN
1747: CLOSE csr_get_scheme_prefix;
1748: fnd_message.set_name ('PQP', 'PQP_230944_PEN_OCP_SCH_INVALID');
1749: fnd_message.raise_error;
1750: END IF; -- End if of row not found check ...
1751:
1752: CLOSE csr_get_scheme_prefix;
1753: --

Line 1805: fnd_message.set_name ('PAY', 'PAY_50060_ETM_BAD_ELE_CLASS');

1801:
1802: IF csr_get_class_id%NOTFOUND
1803: THEN
1804: CLOSE csr_get_class_id;
1805: fnd_message.set_name ('PAY', 'PAY_50060_ETM_BAD_ELE_CLASS');
1806: fnd_message.set_token ('CLASSIFICATION', p_classification_name);
1807: fnd_message.raise_error;
1808: END IF; -- End if of csr class id not found check ...
1809:

Line 1806: fnd_message.set_token ('CLASSIFICATION', p_classification_name);

1802: IF csr_get_class_id%NOTFOUND
1803: THEN
1804: CLOSE csr_get_class_id;
1805: fnd_message.set_name ('PAY', 'PAY_50060_ETM_BAD_ELE_CLASS');
1806: fnd_message.set_token ('CLASSIFICATION', p_classification_name);
1807: fnd_message.raise_error;
1808: END IF; -- End if of csr class id not found check ...
1809:
1810: CLOSE csr_get_class_id;

Line 1807: fnd_message.raise_error;

1803: THEN
1804: CLOSE csr_get_class_id;
1805: fnd_message.set_name ('PAY', 'PAY_50060_ETM_BAD_ELE_CLASS');
1806: fnd_message.set_token ('CLASSIFICATION', p_classification_name);
1807: fnd_message.raise_error;
1808: END IF; -- End if of csr class id not found check ...
1809:
1810: CLOSE csr_get_class_id;
1811: -- Insert sub classification rule

Line 1861: fnd_message.set_name ('PAY', 'PAY_50076_ETM_BASE_NAME_EXISTS');

1857:
1858: IF csr_chk_uniq_base_name%FOUND
1859: THEN
1860: -- Raise error
1861: fnd_message.set_name ('PAY', 'PAY_50076_ETM_BASE_NAME_EXISTS');
1862: fnd_message.set_token ('BASE_NAME', p_ele_base_name);
1863: CLOSE csr_chk_uniq_base_name;
1864: hr_multi_message.add
1865: (p_associated_column4

Line 1862: fnd_message.set_token ('BASE_NAME', p_ele_base_name);

1858: IF csr_chk_uniq_base_name%FOUND
1859: THEN
1860: -- Raise error
1861: fnd_message.set_name ('PAY', 'PAY_50076_ETM_BASE_NAME_EXISTS');
1862: fnd_message.set_token ('BASE_NAME', p_ele_base_name);
1863: CLOSE csr_chk_uniq_base_name;
1864: hr_multi_message.add
1865: (p_associated_column4
1866: => 'PQP_GB_PENSION_SCHEMES_V.SCHEME_PREFIX'

Line 1964: fnd_message.set_name ('PQP', 'PQP_230931_PEN_INVALID_DED_MTH');

1960: OR l_emp_deduction_method = 'PEFR'
1961: THEN
1962: IF g_tab_pension_types_info (p_pension_type_id).ee_contribution_percent IS NULL
1963: THEN
1964: fnd_message.set_name ('PQP', 'PQP_230931_PEN_INVALID_DED_MTH');
1965: fnd_message.set_token ('DEDUCTION_METHOD', 'Employee Percentage');
1966: fnd_message.set_token (
1967: 'PENSION_TYPE'
1968: ,g_tab_pension_types_info (p_pension_type_id).pension_type_name

Line 1965: fnd_message.set_token ('DEDUCTION_METHOD', 'Employee Percentage');

1961: THEN
1962: IF g_tab_pension_types_info (p_pension_type_id).ee_contribution_percent IS NULL
1963: THEN
1964: fnd_message.set_name ('PQP', 'PQP_230931_PEN_INVALID_DED_MTH');
1965: fnd_message.set_token ('DEDUCTION_METHOD', 'Employee Percentage');
1966: fnd_message.set_token (
1967: 'PENSION_TYPE'
1968: ,g_tab_pension_types_info (p_pension_type_id).pension_type_name
1969: );

Line 1966: fnd_message.set_token (

1962: IF g_tab_pension_types_info (p_pension_type_id).ee_contribution_percent IS NULL
1963: THEN
1964: fnd_message.set_name ('PQP', 'PQP_230931_PEN_INVALID_DED_MTH');
1965: fnd_message.set_token ('DEDUCTION_METHOD', 'Employee Percentage');
1966: fnd_message.set_token (
1967: 'PENSION_TYPE'
1968: ,g_tab_pension_types_info (p_pension_type_id).pension_type_name
1969: );
1970: IF l_emp_deduction_method = 'PEFR'

Line 1974: fnd_message.set_name ('PQP', 'PQP_230931_PEN_INVALID_DED_MTH');

1970: IF l_emp_deduction_method = 'PEFR'
1971: THEN
1972: IF g_tab_pension_types_info (p_pension_type_id).ee_contribution_fixed_rate IS NULL
1973: THEN
1974: fnd_message.set_name ('PQP', 'PQP_230931_PEN_INVALID_DED_MTH');
1975: fnd_message.set_token (
1976: 'DEDUCTION_METHOD'
1977: ,'Employee Percentage and Fixed Rate'
1978: );

Line 1975: fnd_message.set_token (

1971: THEN
1972: IF g_tab_pension_types_info (p_pension_type_id).ee_contribution_fixed_rate IS NULL
1973: THEN
1974: fnd_message.set_name ('PQP', 'PQP_230931_PEN_INVALID_DED_MTH');
1975: fnd_message.set_token (
1976: 'DEDUCTION_METHOD'
1977: ,'Employee Percentage and Fixed Rate'
1978: );
1979: fnd_message.set_token (

Line 1979: fnd_message.set_token (

1975: fnd_message.set_token (
1976: 'DEDUCTION_METHOD'
1977: ,'Employee Percentage and Fixed Rate'
1978: );
1979: fnd_message.set_token (
1980: 'PENSION_TYPE'
1981: ,g_tab_pension_types_info (p_pension_type_id).pension_type_name
1982: );
1983: END IF; -- End if of pension type support FR deduction method check ...

Line 1997: fnd_message.set_name ('PQP', 'PQP_230931_PEN_INVALID_DED_MTH');

1993: IF l_emp_deduction_method = 'PEFR'
1994: THEN
1995: IF g_tab_pension_types_info (p_pension_type_id).ee_contribution_fixed_rate IS NULL
1996: THEN
1997: fnd_message.set_name ('PQP', 'PQP_230931_PEN_INVALID_DED_MTH');
1998: fnd_message.set_token (
1999: 'DEDUCTION_METHOD'
2000: ,'Employee Fixed Rate'
2001: );

Line 1998: fnd_message.set_token (

1994: THEN
1995: IF g_tab_pension_types_info (p_pension_type_id).ee_contribution_fixed_rate IS NULL
1996: THEN
1997: fnd_message.set_name ('PQP', 'PQP_230931_PEN_INVALID_DED_MTH');
1998: fnd_message.set_token (
1999: 'DEDUCTION_METHOD'
2000: ,'Employee Fixed Rate'
2001: );
2002: fnd_message.set_token (

Line 2002: fnd_message.set_token (

1998: fnd_message.set_token (
1999: 'DEDUCTION_METHOD'
2000: ,'Employee Fixed Rate'
2001: );
2002: fnd_message.set_token (
2003: 'PENSION_TYPE'
2004: ,g_tab_pension_types_info (p_pension_type_id).pension_type_name
2005: );
2006: hr_multi_message.add

Line 2024: fnd_message.set_name ('PQP', 'PQP_230931_PEN_INVALID_DED_MTH');

2020: ELSIF l_emp_deduction_method = 'FR'
2021: THEN
2022: IF g_tab_pension_types_info (p_pension_type_id).ee_contribution_fixed_rate IS NULL
2023: THEN
2024: fnd_message.set_name ('PQP', 'PQP_230931_PEN_INVALID_DED_MTH');
2025: fnd_message.set_token ('DEDUCTION_METHOD', 'Employee Fixed Rate');
2026: fnd_message.set_token (
2027: 'PENSION_TYPE'
2028: ,g_tab_pension_types_info (p_pension_type_id).pension_type_name

Line 2025: fnd_message.set_token ('DEDUCTION_METHOD', 'Employee Fixed Rate');

2021: THEN
2022: IF g_tab_pension_types_info (p_pension_type_id).ee_contribution_fixed_rate IS NULL
2023: THEN
2024: fnd_message.set_name ('PQP', 'PQP_230931_PEN_INVALID_DED_MTH');
2025: fnd_message.set_token ('DEDUCTION_METHOD', 'Employee Fixed Rate');
2026: fnd_message.set_token (
2027: 'PENSION_TYPE'
2028: ,g_tab_pension_types_info (p_pension_type_id).pension_type_name
2029: );

Line 2026: fnd_message.set_token (

2022: IF g_tab_pension_types_info (p_pension_type_id).ee_contribution_fixed_rate IS NULL
2023: THEN
2024: fnd_message.set_name ('PQP', 'PQP_230931_PEN_INVALID_DED_MTH');
2025: fnd_message.set_token ('DEDUCTION_METHOD', 'Employee Fixed Rate');
2026: fnd_message.set_token (
2027: 'PENSION_TYPE'
2028: ,g_tab_pension_types_info (p_pension_type_id).pension_type_name
2029: );
2030: hr_multi_message.add

Line 2055: fnd_message.set_name ('PQP', 'PQP_230931_PEN_INVALID_DED_MTH');

2051: IF p_eer_deduction_method = 'PE'
2052: THEN
2053: IF g_tab_pension_types_info (p_pension_type_id).er_contribution_percent IS NULL
2054: THEN
2055: fnd_message.set_name ('PQP', 'PQP_230931_PEN_INVALID_DED_MTH');
2056: fnd_message.set_token ('DEDUCTION_METHOD', 'Employer Percentage');
2057: fnd_message.set_token (
2058: 'PENSION_TYPE'
2059: ,g_tab_pension_types_info (p_pension_type_id).pension_type_name

Line 2056: fnd_message.set_token ('DEDUCTION_METHOD', 'Employer Percentage');

2052: THEN
2053: IF g_tab_pension_types_info (p_pension_type_id).er_contribution_percent IS NULL
2054: THEN
2055: fnd_message.set_name ('PQP', 'PQP_230931_PEN_INVALID_DED_MTH');
2056: fnd_message.set_token ('DEDUCTION_METHOD', 'Employer Percentage');
2057: fnd_message.set_token (
2058: 'PENSION_TYPE'
2059: ,g_tab_pension_types_info (p_pension_type_id).pension_type_name
2060: );

Line 2057: fnd_message.set_token (

2053: IF g_tab_pension_types_info (p_pension_type_id).er_contribution_percent IS NULL
2054: THEN
2055: fnd_message.set_name ('PQP', 'PQP_230931_PEN_INVALID_DED_MTH');
2056: fnd_message.set_token ('DEDUCTION_METHOD', 'Employer Percentage');
2057: fnd_message.set_token (
2058: 'PENSION_TYPE'
2059: ,g_tab_pension_types_info (p_pension_type_id).pension_type_name
2060: );
2061: hr_multi_message.add

Line 2074: fnd_message.set_name ('PQP', 'PQP_230931_PEN_INVALID_DED_MTH');

2070: ELSIF p_eer_deduction_method = 'FR'
2071: THEN
2072: IF g_tab_pension_types_info (p_pension_type_id).er_contribution_fixed_rate IS NULL
2073: THEN
2074: fnd_message.set_name ('PQP', 'PQP_230931_PEN_INVALID_DED_MTH');
2075: fnd_message.set_token ('DEDUCTION_METHOD', 'Employer Fixed Rate');
2076: fnd_message.set_token (
2077: 'PENSION_TYPE'
2078: ,g_tab_pension_types_info (p_pension_type_id).pension_type_name

Line 2075: fnd_message.set_token ('DEDUCTION_METHOD', 'Employer Fixed Rate');

2071: THEN
2072: IF g_tab_pension_types_info (p_pension_type_id).er_contribution_fixed_rate IS NULL
2073: THEN
2074: fnd_message.set_name ('PQP', 'PQP_230931_PEN_INVALID_DED_MTH');
2075: fnd_message.set_token ('DEDUCTION_METHOD', 'Employer Fixed Rate');
2076: fnd_message.set_token (
2077: 'PENSION_TYPE'
2078: ,g_tab_pension_types_info (p_pension_type_id).pension_type_name
2079: );

Line 2076: fnd_message.set_token (

2072: IF g_tab_pension_types_info (p_pension_type_id).er_contribution_fixed_rate IS NULL
2073: THEN
2074: fnd_message.set_name ('PQP', 'PQP_230931_PEN_INVALID_DED_MTH');
2075: fnd_message.set_token ('DEDUCTION_METHOD', 'Employer Fixed Rate');
2076: fnd_message.set_token (
2077: 'PENSION_TYPE'
2078: ,g_tab_pension_types_info (p_pension_type_id).pension_type_name
2079: );
2080: hr_multi_message.add

Line 2093: fnd_message.set_name ('PQP', 'PQP_230931_PEN_INVALID_DED_MTH');

2089: THEN
2090: IF g_tab_pension_types_info (p_pension_type_id).er_contribution_percent IS NULL
2091: AND g_tab_pension_types_info (p_pension_type_id).er_contribution_fixed_rate IS NULL
2092: THEN
2093: fnd_message.set_name ('PQP', 'PQP_230931_PEN_INVALID_DED_MTH');
2094: fnd_message.set_token (
2095: 'DEDUCTION_METHOD'
2096: ,'Employer Percentage and Fixed Rate'
2097: );

Line 2094: fnd_message.set_token (

2090: IF g_tab_pension_types_info (p_pension_type_id).er_contribution_percent IS NULL
2091: AND g_tab_pension_types_info (p_pension_type_id).er_contribution_fixed_rate IS NULL
2092: THEN
2093: fnd_message.set_name ('PQP', 'PQP_230931_PEN_INVALID_DED_MTH');
2094: fnd_message.set_token (
2095: 'DEDUCTION_METHOD'
2096: ,'Employer Percentage and Fixed Rate'
2097: );
2098: fnd_message.set_token (

Line 2098: fnd_message.set_token (

2094: fnd_message.set_token (
2095: 'DEDUCTION_METHOD'
2096: ,'Employer Percentage and Fixed Rate'
2097: );
2098: fnd_message.set_token (
2099: 'PENSION_TYPE'
2100: ,g_tab_pension_types_info (p_pension_type_id).pension_type_name
2101: );
2102: hr_multi_message.add

Line 2110: fnd_message.set_name ('PQP', 'PQP_230931_PEN_INVALID_DED_MTH');

2106: END IF; -- End if of pension type support % and FR deduction method check ...
2107:
2108: IF g_tab_pension_types_info (p_pension_type_id).er_contribution_fixed_rate IS NULL
2109: THEN
2110: fnd_message.set_name ('PQP', 'PQP_230931_PEN_INVALID_DED_MTH');
2111: fnd_message.set_token ('DEDUCTION_METHOD', 'Employer Fixed Rate');
2112: fnd_message.set_token (
2113: 'PENSION_TYPE'
2114: ,g_tab_pension_types_info (p_pension_type_id).pension_type_name

Line 2111: fnd_message.set_token ('DEDUCTION_METHOD', 'Employer Fixed Rate');

2107:
2108: IF g_tab_pension_types_info (p_pension_type_id).er_contribution_fixed_rate IS NULL
2109: THEN
2110: fnd_message.set_name ('PQP', 'PQP_230931_PEN_INVALID_DED_MTH');
2111: fnd_message.set_token ('DEDUCTION_METHOD', 'Employer Fixed Rate');
2112: fnd_message.set_token (
2113: 'PENSION_TYPE'
2114: ,g_tab_pension_types_info (p_pension_type_id).pension_type_name
2115: );

Line 2112: fnd_message.set_token (

2108: IF g_tab_pension_types_info (p_pension_type_id).er_contribution_fixed_rate IS NULL
2109: THEN
2110: fnd_message.set_name ('PQP', 'PQP_230931_PEN_INVALID_DED_MTH');
2111: fnd_message.set_token ('DEDUCTION_METHOD', 'Employer Fixed Rate');
2112: fnd_message.set_token (
2113: 'PENSION_TYPE'
2114: ,g_tab_pension_types_info (p_pension_type_id).pension_type_name
2115: );
2116: hr_multi_message.add

Line 2124: fnd_message.set_name ('PQP', 'PQP_230931_PEN_INVALID_DED_MTH');

2120: END IF; -- End if of fixed rate is null check ...
2121:
2122: IF g_tab_pension_types_info (p_pension_type_id).er_contribution_percent IS NULL
2123: THEN
2124: fnd_message.set_name ('PQP', 'PQP_230931_PEN_INVALID_DED_MTH');
2125: fnd_message.set_token ('DEDUCTION_METHOD', 'Employer Percentage');
2126: fnd_message.set_token (
2127: 'PENSION_TYPE'
2128: ,g_tab_pension_types_info (p_pension_type_id).pension_type_name

Line 2125: fnd_message.set_token ('DEDUCTION_METHOD', 'Employer Percentage');

2121:
2122: IF g_tab_pension_types_info (p_pension_type_id).er_contribution_percent IS NULL
2123: THEN
2124: fnd_message.set_name ('PQP', 'PQP_230931_PEN_INVALID_DED_MTH');
2125: fnd_message.set_token ('DEDUCTION_METHOD', 'Employer Percentage');
2126: fnd_message.set_token (
2127: 'PENSION_TYPE'
2128: ,g_tab_pension_types_info (p_pension_type_id).pension_type_name
2129: );

Line 2126: fnd_message.set_token (

2122: IF g_tab_pension_types_info (p_pension_type_id).er_contribution_percent IS NULL
2123: THEN
2124: fnd_message.set_name ('PQP', 'PQP_230931_PEN_INVALID_DED_MTH');
2125: fnd_message.set_token ('DEDUCTION_METHOD', 'Employer Percentage');
2126: fnd_message.set_token (
2127: 'PENSION_TYPE'
2128: ,g_tab_pension_types_info (p_pension_type_id).pension_type_name
2129: );
2130: hr_multi_message.add

Line 2918: fnd_message.set_name ('PQP', 'PQP_230932_BAL_TYPE_NOTFOUND');

2914:
2915: -- Create balance feeds for EE Contribution balance
2916: IF g_tab_pension_types_info (p_pension_type_id).ee_contribution_bal_type_id IS NULL
2917: THEN
2918: fnd_message.set_name ('PQP', 'PQP_230932_BAL_TYPE_NOTFOUND');
2919: fnd_message.set_token (
2920: 'BALANCE_TYPE'
2921: , g_tab_pension_types_info (p_pension_type_id).pension_type_name
2922: || ' EE Contribution'

Line 2919: fnd_message.set_token (

2915: -- Create balance feeds for EE Contribution balance
2916: IF g_tab_pension_types_info (p_pension_type_id).ee_contribution_bal_type_id IS NULL
2917: THEN
2918: fnd_message.set_name ('PQP', 'PQP_230932_BAL_TYPE_NOTFOUND');
2919: fnd_message.set_token (
2920: 'BALANCE_TYPE'
2921: , g_tab_pension_types_info (p_pension_type_id).pension_type_name
2922: || ' EE Contribution'
2923: );

Line 2924: fnd_message.raise_error;

2920: 'BALANCE_TYPE'
2921: , g_tab_pension_types_info (p_pension_type_id).pension_type_name
2922: || ' EE Contribution'
2923: );
2924: fnd_message.raise_error;
2925: END IF; -- End if of ee contribution balance is null check ...
2926:
2927: --
2928: hr_utility.set_location (l_proc_name, 240);

Line 2968: fnd_message.set_name ('PQP', 'PQP_230932_BAL_TYPE_NOTFOUND');

2964:
2965: -- Create balance feeds for ER Contribution balance
2966: IF g_tab_pension_types_info (p_pension_type_id).er_contribution_bal_type_id IS NULL
2967: THEN
2968: fnd_message.set_name ('PQP', 'PQP_230932_BAL_TYPE_NOTFOUND');
2969: fnd_message.set_token (
2970: 'BALANCE_TYPE'
2971: , g_tab_pension_types_info (p_pension_type_id).pension_type_name
2972: || ' ER Contribution'

Line 2969: fnd_message.set_token (

2965: -- Create balance feeds for ER Contribution balance
2966: IF g_tab_pension_types_info (p_pension_type_id).er_contribution_bal_type_id IS NULL
2967: THEN
2968: fnd_message.set_name ('PQP', 'PQP_230932_BAL_TYPE_NOTFOUND');
2969: fnd_message.set_token (
2970: 'BALANCE_TYPE'
2971: , g_tab_pension_types_info (p_pension_type_id).pension_type_name
2972: || ' ER Contribution'
2973: );

Line 2974: fnd_message.raise_error;

2970: 'BALANCE_TYPE'
2971: , g_tab_pension_types_info (p_pension_type_id).pension_type_name
2972: || ' ER Contribution'
2973: );
2974: fnd_message.raise_error;
2975: END IF; -- End if of er contribution balance is null check ...
2976:
2977: --
2978: hr_utility.set_location (l_proc_name, 260);

Line 3014: fnd_message.set_name ('PQP', 'PQP_230932_BAL_TYPE_NOTFOUND');

3010:
3011: -- Create balance feeds for ER Contribution balance
3012: IF g_tab_pension_types_info (p_pension_type_id).er_contribution_bal_type_id IS NULL
3013: THEN
3014: fnd_message.set_name ('PQP', 'PQP_230932_BAL_TYPE_NOTFOUND');
3015: fnd_message.set_token (
3016: 'BALANCE_TYPE'
3017: , g_tab_pension_types_info (p_pension_type_id).pension_type_name
3018: || ' ER Contribution'

Line 3015: fnd_message.set_token (

3011: -- Create balance feeds for ER Contribution balance
3012: IF g_tab_pension_types_info (p_pension_type_id).er_contribution_bal_type_id IS NULL
3013: THEN
3014: fnd_message.set_name ('PQP', 'PQP_230932_BAL_TYPE_NOTFOUND');
3015: fnd_message.set_token (
3016: 'BALANCE_TYPE'
3017: , g_tab_pension_types_info (p_pension_type_id).pension_type_name
3018: || ' ER Contribution'
3019: );

Line 3020: fnd_message.raise_error;

3016: 'BALANCE_TYPE'
3017: , g_tab_pension_types_info (p_pension_type_id).pension_type_name
3018: || ' ER Contribution'
3019: );
3020: fnd_message.raise_error;
3021: END IF; -- End if of er contribution balance is null check ...
3022:
3023: --
3024: hr_utility.set_location (l_proc_name, 280);

Line 3062: fnd_message.set_name ('PQP', 'PQP_230932_BAL_TYPE_NOTFOUND');

3058: END IF; -- End if of pensionable sal is null check ...
3059:
3060: IF l_pensionable_sal_bal_id IS NULL
3061: THEN
3062: fnd_message.set_name ('PQP', 'PQP_230932_BAL_TYPE_NOTFOUND');
3063: fnd_message.set_token ('BALANCE_TYPE', 'Superannuable Salary');
3064: fnd_message.raise_error;
3065: END IF; -- End if of local pensionable sal id is null check ...
3066:

Line 3063: fnd_message.set_token ('BALANCE_TYPE', 'Superannuable Salary');

3059:
3060: IF l_pensionable_sal_bal_id IS NULL
3061: THEN
3062: fnd_message.set_name ('PQP', 'PQP_230932_BAL_TYPE_NOTFOUND');
3063: fnd_message.set_token ('BALANCE_TYPE', 'Superannuable Salary');
3064: fnd_message.raise_error;
3065: END IF; -- End if of local pensionable sal id is null check ...
3066:
3067: -- Create sub classification rule for the company pension base element

Line 3064: fnd_message.raise_error;

3060: IF l_pensionable_sal_bal_id IS NULL
3061: THEN
3062: fnd_message.set_name ('PQP', 'PQP_230932_BAL_TYPE_NOTFOUND');
3063: fnd_message.set_token ('BALANCE_TYPE', 'Superannuable Salary');
3064: fnd_message.raise_error;
3065: END IF; -- End if of local pensionable sal id is null check ...
3066:
3067: -- Create sub classification rule for the company pension base element
3068: -- create only if it is pre tax and scheme type is comp/cosr

Line 3449: fnd_message.set_name ('PQP', 'PQP_230924_SCHEME_NAME_ERR');

3445:
3446: IF csr_chk_uniq_sch_name%FOUND
3447: THEN
3448: CLOSE csr_chk_uniq_sch_name;
3449: fnd_message.set_name ('PQP', 'PQP_230924_SCHEME_NAME_ERR');
3450: hr_multi_message.add
3451: (p_associated_column1
3452: => 'PQP_GB_PENSION_SCHEMES_V.PENSION_SCHEME_NAME'
3453: );

Line 4013: fnd_message.set_name ('PQP', 'PQP_230981_PEN_FR_DED_EXISTS');

4009:
4010: IF csr_chk_fr_exists%FOUND
4011: THEN
4012: CLOSE csr_chk_fr_exists;
4013: fnd_message.set_name ('PQP', 'PQP_230981_PEN_FR_DED_EXISTS');
4014: hr_multi_message.add
4015: (p_associated_column1
4016: => 'PQP_GB_PENSION_SCHEMES_V.EMPLOYEE_DEDUCTION_METHOD'
4017: );

Line 4034: fnd_message.set_name ('PQP', 'PQP_230945_PEN_AVC_CHILD_EXIST');

4030:
4031: IF csr_chk_ocp_asoc_avc%FOUND
4032: THEN
4033: CLOSE csr_chk_ocp_asoc_avc;
4034: fnd_message.set_name ('PQP', 'PQP_230945_PEN_AVC_CHILD_EXIST');
4035: hr_multi_message.add
4036: (p_associated_column2
4037: => 'PQP_GB_PENSION_SCHEMES_V.ELEMENT_TYPE_ID'
4038: );