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 585: fnd_message.set_name ('PQP', 'PQP_230923_SCHEME_PREFIX_ERR');

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

Line 586: fnd_message.raise_error;

582: EXCEPTION
583: WHEN OTHERS
584: THEN
585: fnd_message.set_name ('PQP', 'PQP_230923_SCHEME_PREFIX_ERR');
586: fnd_message.raise_error;
587: END chk_scheme_prefix;
588:
589: --
590:

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

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

Line 632: fnd_message.raise_error;

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

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

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

Line 798: fnd_message.raise_error;

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

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

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

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

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

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

1037: THEN
1038: -- Invalid Pension Category
1039: fnd_message.set_name ('PAY', 'HR_52966_INVALID_LOOKUP');
1040: fnd_message.set_token ('COLUMN', 'Pension Category');
1041: fnd_message.set_token ('LOOKUP_TYPE', 'PQP_PENSION_CATEGORY');
1042:
1043: hr_utility.set_location (l_proc_name, 25);
1044:
1045: fnd_message.raise_error;

Line 1045: fnd_message.raise_error;

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

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

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

Line 1060: fnd_message.raise_error;

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

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

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

Line 1091: fnd_message.set_token (

1087: IF g_tab_pension_types_info (p_pension_type_id).pension_category <>
1088: p_pension_category
1089: THEN
1090: fnd_message.set_name ('PQP', 'PQP_230938_PEN_TYP_CAT_NOTSUP');
1091: fnd_message.set_token (
1092: 'PENSION_CATEGORY'
1093: ,hr_general.decode_lookup (
1094: 'PQP_PENSION_CATEGORY'
1095: ,p_pension_category

Line 1098: fnd_message.raise_error;

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

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

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

Line 1113: fnd_message.raise_error;

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

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

1125: ,p_lookup_code => l_emp_deduction_method
1126: )
1127: THEN
1128: -- Invalid Deduction Method
1129: fnd_message.set_name ('PAY', 'HR_52966_INVALID_LOOKUP');
1130: fnd_message.set_token ('COLUMN', 'Employee Deduction Method');
1131: fnd_message.set_token (
1132: 'LOOKUP_TYPE'
1133: ,'PQP_PENSION_DEDUCTION_METHOD'

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

1126: )
1127: THEN
1128: -- Invalid Deduction Method
1129: fnd_message.set_name ('PAY', 'HR_52966_INVALID_LOOKUP');
1130: fnd_message.set_token ('COLUMN', 'Employee Deduction Method');
1131: fnd_message.set_token (
1132: 'LOOKUP_TYPE'
1133: ,'PQP_PENSION_DEDUCTION_METHOD'
1134: );

Line 1131: fnd_message.set_token (

1127: THEN
1128: -- Invalid Deduction Method
1129: fnd_message.set_name ('PAY', 'HR_52966_INVALID_LOOKUP');
1130: fnd_message.set_token ('COLUMN', 'Employee Deduction Method');
1131: fnd_message.set_token (
1132: 'LOOKUP_TYPE'
1133: ,'PQP_PENSION_DEDUCTION_METHOD'
1134: );
1135: fnd_message.raise_error;

Line 1135: fnd_message.raise_error;

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

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

1148: ,p_lookup_code => p_eer_deduction_method
1149: )
1150: THEN
1151: -- Invalid Deduction Method
1152: fnd_message.set_name ('PAY', 'HR_52966_INVALID_LOOKUP');
1153: fnd_message.set_token ('COLUMN', 'Employer Deduction Method');
1154: fnd_message.set_token (
1155: 'LOOKUP_TYPE'
1156: ,'PQP_PENSION_DEDUCTION_METHOD'

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

1149: )
1150: THEN
1151: -- Invalid Deduction Method
1152: fnd_message.set_name ('PAY', 'HR_52966_INVALID_LOOKUP');
1153: fnd_message.set_token ('COLUMN', 'Employer Deduction Method');
1154: fnd_message.set_token (
1155: 'LOOKUP_TYPE'
1156: ,'PQP_PENSION_DEDUCTION_METHOD'
1157: );

Line 1154: fnd_message.set_token (

1150: THEN
1151: -- Invalid Deduction Method
1152: fnd_message.set_name ('PAY', 'HR_52966_INVALID_LOOKUP');
1153: fnd_message.set_token ('COLUMN', 'Employer Deduction Method');
1154: fnd_message.set_token (
1155: 'LOOKUP_TYPE'
1156: ,'PQP_PENSION_DEDUCTION_METHOD'
1157: );
1158: fnd_message.raise_error;

Line 1158: fnd_message.raise_error;

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

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

1190: ,p_lookup_code => p_additional_contribution
1191: )
1192: THEN
1193: -- Invalid Deduction Method
1194: fnd_message.set_name ('PAY', 'HR_52966_INVALID_LOOKUP');
1195: fnd_message.set_token (
1196: 'COLUMN'
1197: ,'Additional Contribution Deduction Method'
1198: );

Line 1195: fnd_message.set_token (

1191: )
1192: THEN
1193: -- Invalid Deduction Method
1194: fnd_message.set_name ('PAY', 'HR_52966_INVALID_LOOKUP');
1195: fnd_message.set_token (
1196: 'COLUMN'
1197: ,'Additional Contribution Deduction Method'
1198: );
1199: fnd_message.set_token (

Line 1199: fnd_message.set_token (

1195: fnd_message.set_token (
1196: 'COLUMN'
1197: ,'Additional Contribution Deduction Method'
1198: );
1199: fnd_message.set_token (
1200: 'LOOKUP_TYPE'
1201: ,'PQP_PENSION_DEDUCTION_METHOD'
1202: );
1203: fnd_message.raise_error;

Line 1203: fnd_message.raise_error;

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

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

1218: ,p_lookup_code => p_added_years
1219: )
1220: THEN
1221: -- Invalid Deduction Method
1222: fnd_message.set_name ('PAY', 'HR_52966_INVALID_LOOKUP');
1223: fnd_message.set_token (
1224: 'COLUMN'
1225: ,'Added Years Deduction Method'
1226: );

Line 1223: fnd_message.set_token (

1219: )
1220: THEN
1221: -- Invalid Deduction Method
1222: fnd_message.set_name ('PAY', 'HR_52966_INVALID_LOOKUP');
1223: fnd_message.set_token (
1224: 'COLUMN'
1225: ,'Added Years Deduction Method'
1226: );
1227: fnd_message.set_token (

Line 1227: fnd_message.set_token (

1223: fnd_message.set_token (
1224: 'COLUMN'
1225: ,'Added Years Deduction Method'
1226: );
1227: fnd_message.set_token (
1228: 'LOOKUP_TYPE'
1229: ,'PQP_PENSION_DEDUCTION_METHOD'
1230: );
1231: fnd_message.raise_error;

Line 1231: fnd_message.raise_error;

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

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

1246: ,p_lookup_code => p_family_widower
1247: )
1248: THEN
1249: -- Invalid Deduction Method
1250: fnd_message.set_name ('PAY', 'HR_52966_INVALID_LOOKUP');
1251: fnd_message.set_token (
1252: 'COLUMN'
1253: ,'Family Widower Deduction Method'
1254: );

Line 1251: fnd_message.set_token (

1247: )
1248: THEN
1249: -- Invalid Deduction Method
1250: fnd_message.set_name ('PAY', 'HR_52966_INVALID_LOOKUP');
1251: fnd_message.set_token (
1252: 'COLUMN'
1253: ,'Family Widower Deduction Method'
1254: );
1255: fnd_message.set_token (

Line 1255: fnd_message.set_token (

1251: fnd_message.set_token (
1252: 'COLUMN'
1253: ,'Family Widower Deduction Method'
1254: );
1255: fnd_message.set_token (
1256: 'LOOKUP_TYPE'
1257: ,'PQP_PENSION_DEDUCTION_METHOD'
1258: );
1259: fnd_message.raise_error;

Line 1259: fnd_message.raise_error;

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

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

1275: ,p_lookup_code => p_fwc_added_years
1276: )
1277: THEN
1278: -- Invalid Deduction Method
1279: fnd_message.set_name ('PAY', 'HR_52966_INVALID_LOOKUP');
1280: fnd_message.set_token (
1281: 'COLUMN'
1282: ,'Family Widower Added Years Deduction Method'
1283: );

Line 1280: fnd_message.set_token (

1276: )
1277: THEN
1278: -- Invalid Deduction Method
1279: fnd_message.set_name ('PAY', 'HR_52966_INVALID_LOOKUP');
1280: fnd_message.set_token (
1281: 'COLUMN'
1282: ,'Family Widower Added Years Deduction Method'
1283: );
1284: fnd_message.set_token (

Line 1284: fnd_message.set_token (

1280: fnd_message.set_token (
1281: 'COLUMN'
1282: ,'Family Widower Added Years Deduction Method'
1283: );
1284: fnd_message.set_token (
1285: 'LOOKUP_TYPE'
1286: ,'PQP_PENSION_DEDUCTION_METHOD'
1287: );
1288: fnd_message.raise_error;

Line 1288: fnd_message.raise_error;

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

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

1305: ,p_lookup_code => p_pension_scheme_type
1306: )
1307: THEN
1308: -- Invalid Pension Scheme Type
1309: fnd_message.set_name ('PAY', 'HR_52966_INVALID_LOOKUP');
1310: fnd_message.set_token ('COLUMN', 'Pension Scheme Type');
1311: fnd_message.set_token (
1312: 'LOOKUP_TYPE'
1313: ,'PQP_PENSION_SCHEME_TYPE'

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

1306: )
1307: THEN
1308: -- Invalid Pension Scheme Type
1309: fnd_message.set_name ('PAY', 'HR_52966_INVALID_LOOKUP');
1310: fnd_message.set_token ('COLUMN', 'Pension Scheme Type');
1311: fnd_message.set_token (
1312: 'LOOKUP_TYPE'
1313: ,'PQP_PENSION_SCHEME_TYPE'
1314: );

Line 1311: fnd_message.set_token (

1307: THEN
1308: -- Invalid Pension Scheme Type
1309: fnd_message.set_name ('PAY', 'HR_52966_INVALID_LOOKUP');
1310: fnd_message.set_token ('COLUMN', 'Pension Scheme Type');
1311: fnd_message.set_token (
1312: 'LOOKUP_TYPE'
1313: ,'PQP_PENSION_SCHEME_TYPE'
1314: );
1315: fnd_message.raise_error;

Line 1315: fnd_message.raise_error;

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

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

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

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

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

Line 1360: fnd_message.raise_error;

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

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

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

Line 1383: fnd_message.raise_error;

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

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

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

Line 1403: fnd_message.raise_error;

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

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

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

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

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

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

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

Line 1428: fnd_message.raise_error;

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

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

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

Line 1474: fnd_message.raise_error;

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

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

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

Line 1521: fnd_message.raise_error;

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

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

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

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

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

Line 1601: fnd_message.raise_error;

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

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

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

Line 1751: fnd_message.raise_error;

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

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

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

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

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

Line 1809: fnd_message.raise_error;

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

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

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

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

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

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

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

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

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

Line 1968: fnd_message.set_token (

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

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

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

Line 1977: fnd_message.set_token (

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

Line 1981: fnd_message.set_token (

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

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

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

Line 2000: fnd_message.set_token (

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

Line 2004: fnd_message.set_token (

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

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

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

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

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

Line 2028: fnd_message.set_token (

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

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

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

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

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

Line 2059: fnd_message.set_token (

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

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

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

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

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

Line 2078: fnd_message.set_token (

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

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

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

Line 2096: fnd_message.set_token (

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

Line 2100: fnd_message.set_token (

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

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

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

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

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

Line 2114: fnd_message.set_token (

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

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

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

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

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

Line 2128: fnd_message.set_token (

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

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

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

Line 2921: fnd_message.set_token (

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

Line 2926: fnd_message.raise_error;

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

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

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

Line 2971: fnd_message.set_token (

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

Line 2976: fnd_message.raise_error;

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

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

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

Line 3017: fnd_message.set_token (

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

Line 3022: fnd_message.raise_error;

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

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

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

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

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

Line 3066: fnd_message.raise_error;

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

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

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

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

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

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

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