DBA Data[Home] [Help]

APPS.BEN_BPP_BUS dependencies on FND_MESSAGE

Line 142: fnd_message.set_name('BEN','BEN_91009_NAME_NOT_UNIQUE');

138: open c1;
139: fetch c1 into l_dummy;
140: if c1%found then
141: close c1;
142: fnd_message.set_name('BEN','BEN_91009_NAME_NOT_UNIQUE');
143: fnd_message.raise_error;
144: end if;
145: end if;
146: --

Line 143: fnd_message.raise_error;

139: fetch c1 into l_dummy;
140: if c1%found then
141: close c1;
142: fnd_message.set_name('BEN','BEN_91009_NAME_NOT_UNIQUE');
143: fnd_message.raise_error;
144: end if;
145: end if;
146: --
147: hr_utility.set_location('Leaving:'||l_proc, 15);

Line 202: fnd_message.set_name('BEN','BEN_91714_MUT_EXLSV_MN_VAL_FLG');

198: p_mn_dstrbl_val is not null) then
199: --
200: -- OK fields are not mutaully exclusive so raise an error
201: --
202: fnd_message.set_name('BEN','BEN_91714_MUT_EXLSV_MN_VAL_FLG');
203: fnd_message.raise_error;
204: --
205: end if;
206: --

Line 203: fnd_message.raise_error;

199: --
200: -- OK fields are not mutaully exclusive so raise an error
201: --
202: fnd_message.set_name('BEN','BEN_91714_MUT_EXLSV_MN_VAL_FLG');
203: fnd_message.raise_error;
204: --
205: end if;
206: --
207: hr_utility.set_location('Leaving:'||l_proc, 10);

Line 263: fnd_message.set_name('BEN','BEN_91715_MUT_EXLSV_MX_VAL_FLG');

259: p_mx_dstrbl_val is not null) then
260: --
261: -- OK fields are not mutaully exclusive so raise an error
262: --
263: fnd_message.set_name('BEN','BEN_91715_MUT_EXLSV_MX_VAL_FLG');
264: fnd_message.raise_error;
265: --
266: end if;
267: --

Line 264: fnd_message.raise_error;

260: --
261: -- OK fields are not mutaully exclusive so raise an error
262: --
263: fnd_message.set_name('BEN','BEN_91715_MUT_EXLSV_MX_VAL_FLG');
264: fnd_message.raise_error;
265: --
266: end if;
267: --
268: hr_utility.set_location('Leaving:'||l_proc, 10);

Line 324: fnd_message.set_name('BEN','BEN_91716_MUT_EXLSV_MN_PCT_FLG');

320: p_mn_dstrbl_pct_num is not null) then
321: --
322: -- OK fields are not mutaully exclusive so raise an error
323: --
324: fnd_message.set_name('BEN','BEN_91716_MUT_EXLSV_MN_PCT_FLG');
325: fnd_message.raise_error;
326: --
327: end if;
328: --

Line 325: fnd_message.raise_error;

321: --
322: -- OK fields are not mutaully exclusive so raise an error
323: --
324: fnd_message.set_name('BEN','BEN_91716_MUT_EXLSV_MN_PCT_FLG');
325: fnd_message.raise_error;
326: --
327: end if;
328: --
329: hr_utility.set_location('Leaving:'||l_proc, 10);

Line 385: fnd_message.set_name('BEN','BEN_91717_MUT_EXLSV_MX_PCT_FLG');

381: p_mx_dstrbl_pct_num is not null) then
382: --
383: -- OK fields are not mutaully exclusive so raise an error
384: --
385: fnd_message.set_name('BEN','BEN_91717_MUT_EXLSV_MX_PCT_FLG');
386: fnd_message.raise_error;
387: --
388: end if;
389: --

Line 386: fnd_message.raise_error;

382: --
383: -- OK fields are not mutaully exclusive so raise an error
384: --
385: fnd_message.set_name('BEN','BEN_91717_MUT_EXLSV_MX_PCT_FLG');
386: fnd_message.raise_error;
387: --
388: end if;
389: --
390: hr_utility.set_location('Leaving:'||l_proc, 10);

Line 452: fnd_message.set_name('BEN','BEN_91019_RULE_REQUIRED');

448: or not l_api_updating) then
449: --
450: if (p_pct_rndg_cd = 'RL' and p_pct_rndg_rl is null) then
451: --
452: fnd_message.set_name('BEN','BEN_91019_RULE_REQUIRED');
453: fnd_message.raise_error;
454: --
455: end if;
456: --

Line 453: fnd_message.raise_error;

449: --
450: if (p_pct_rndg_cd = 'RL' and p_pct_rndg_rl is null) then
451: --
452: fnd_message.set_name('BEN','BEN_91019_RULE_REQUIRED');
453: fnd_message.raise_error;
454: --
455: end if;
456: --
457: if nvl(p_pct_rndg_cd,hr_api.g_varchar2) <> 'RL' and p_pct_rndg_rl is not null then

Line 459: fnd_message.set_name('BEN','BEN_91713_CODE_NOT_RULE');

455: end if;
456: --
457: if nvl(p_pct_rndg_cd,hr_api.g_varchar2) <> 'RL' and p_pct_rndg_rl is not null then
458: --
459: fnd_message.set_name('BEN','BEN_91713_CODE_NOT_RULE');
460: fnd_message.raise_error;
461: --
462: end if;
463: --

Line 460: fnd_message.raise_error;

456: --
457: if nvl(p_pct_rndg_cd,hr_api.g_varchar2) <> 'RL' and p_pct_rndg_rl is not null then
458: --
459: fnd_message.set_name('BEN','BEN_91713_CODE_NOT_RULE');
460: fnd_message.raise_error;
461: --
462: end if;
463: --
464: end if;

Line 528: fnd_message.set_name('BEN','BEN_91019_RULE_REQUIRED');

524: or not l_api_updating) then
525: --
526: if (p_val_rndg_cd = 'RL' and p_val_rndg_rl is null) then
527: --
528: fnd_message.set_name('BEN','BEN_91019_RULE_REQUIRED');
529: fnd_message.raise_error;
530: --
531: end if;
532: --

Line 529: fnd_message.raise_error;

525: --
526: if (p_val_rndg_cd = 'RL' and p_val_rndg_rl is null) then
527: --
528: fnd_message.set_name('BEN','BEN_91019_RULE_REQUIRED');
529: fnd_message.raise_error;
530: --
531: end if;
532: --
533: if nvl(p_val_rndg_cd,hr_api.g_varchar2) <> 'RL' and p_val_rndg_rl is not null then

Line 535: fnd_message.set_name('BEN','BEN_91713_CODE_NOT_RULE');

531: end if;
532: --
533: if nvl(p_val_rndg_cd,hr_api.g_varchar2) <> 'RL' and p_val_rndg_rl is not null then
534: --
535: fnd_message.set_name('BEN','BEN_91713_CODE_NOT_RULE');
536: fnd_message.raise_error;
537: --
538: end if;
539: --

Line 536: fnd_message.raise_error;

532: --
533: if nvl(p_val_rndg_cd,hr_api.g_varchar2) <> 'RL' and p_val_rndg_rl is not null then
534: --
535: fnd_message.set_name('BEN','BEN_91713_CODE_NOT_RULE');
536: fnd_message.raise_error;
537: --
538: end if;
539: --
540: end if;

Line 626: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');

622: close c1;
623: --
624: -- raise error
625: --
626: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
627: fnd_message.set_token('ID',p_val_rndg_rl);
628: fnd_message.set_token('TYPE_ID',-169);
629: fnd_message.raise_error;
630: --

Line 627: fnd_message.set_token('ID',p_val_rndg_rl);

623: --
624: -- raise error
625: --
626: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
627: fnd_message.set_token('ID',p_val_rndg_rl);
628: fnd_message.set_token('TYPE_ID',-169);
629: fnd_message.raise_error;
630: --
631: end if;

Line 628: fnd_message.set_token('TYPE_ID',-169);

624: -- raise error
625: --
626: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
627: fnd_message.set_token('ID',p_val_rndg_rl);
628: fnd_message.set_token('TYPE_ID',-169);
629: fnd_message.raise_error;
630: --
631: end if;
632: --

Line 629: fnd_message.raise_error;

625: --
626: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
627: fnd_message.set_token('ID',p_val_rndg_rl);
628: fnd_message.set_token('TYPE_ID',-169);
629: fnd_message.raise_error;
630: --
631: end if;
632: --
633: close c1;

Line 699: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');

695: p_effective_date => p_effective_date) then
696: --
697: -- raise error as does not exist as lookup
698: --
699: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
700: fnd_message.set_token('FIELD','p_val_rndg_cd');
701: fnd_message.set_token('TYPE','BEN_RNDG');
702: fnd_message.raise_error;
703: --

Line 700: fnd_message.set_token('FIELD','p_val_rndg_cd');

696: --
697: -- raise error as does not exist as lookup
698: --
699: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
700: fnd_message.set_token('FIELD','p_val_rndg_cd');
701: fnd_message.set_token('TYPE','BEN_RNDG');
702: fnd_message.raise_error;
703: --
704: end if;

Line 701: fnd_message.set_token('TYPE','BEN_RNDG');

697: -- raise error as does not exist as lookup
698: --
699: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
700: fnd_message.set_token('FIELD','p_val_rndg_cd');
701: fnd_message.set_token('TYPE','BEN_RNDG');
702: fnd_message.raise_error;
703: --
704: end if;
705: --

Line 702: fnd_message.raise_error;

698: --
699: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
700: fnd_message.set_token('FIELD','p_val_rndg_cd');
701: fnd_message.set_token('TYPE','BEN_RNDG');
702: fnd_message.raise_error;
703: --
704: end if;
705: --
706: end if;

Line 792: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');

788: close c1;
789: --
790: -- raise error
791: --
792: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
793: fnd_message.set_token('ID',p_pct_rndg_rl);
794: fnd_message.set_token('TYPE_ID',-169);
795: fnd_message.raise_error;
796: --

Line 793: fnd_message.set_token('ID',p_pct_rndg_rl);

789: --
790: -- raise error
791: --
792: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
793: fnd_message.set_token('ID',p_pct_rndg_rl);
794: fnd_message.set_token('TYPE_ID',-169);
795: fnd_message.raise_error;
796: --
797: end if;

Line 794: fnd_message.set_token('TYPE_ID',-169);

790: -- raise error
791: --
792: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
793: fnd_message.set_token('ID',p_pct_rndg_rl);
794: fnd_message.set_token('TYPE_ID',-169);
795: fnd_message.raise_error;
796: --
797: end if;
798: --

Line 795: fnd_message.raise_error;

791: --
792: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
793: fnd_message.set_token('ID',p_pct_rndg_rl);
794: fnd_message.set_token('TYPE_ID',-169);
795: fnd_message.raise_error;
796: --
797: end if;
798: --
799: close c1;

Line 865: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');

861: p_effective_date => p_effective_date) then
862: --
863: -- raise error as does not exist as lookup
864: --
865: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
866: fnd_message.set_token('FIELD','p_pct_rndg_cd');
867: fnd_message.set_token('TYPE','BEN_RNDG');
868: fnd_message.raise_error;
869: --

Line 866: fnd_message.set_token('FIELD','p_pct_rndg_cd');

862: --
863: -- raise error as does not exist as lookup
864: --
865: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
866: fnd_message.set_token('FIELD','p_pct_rndg_cd');
867: fnd_message.set_token('TYPE','BEN_RNDG');
868: fnd_message.raise_error;
869: --
870: end if;

Line 867: fnd_message.set_token('TYPE','BEN_RNDG');

863: -- raise error as does not exist as lookup
864: --
865: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
866: fnd_message.set_token('FIELD','p_pct_rndg_cd');
867: fnd_message.set_token('TYPE','BEN_RNDG');
868: fnd_message.raise_error;
869: --
870: end if;
871: --

Line 868: fnd_message.raise_error;

864: --
865: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
866: fnd_message.set_token('FIELD','p_pct_rndg_cd');
867: fnd_message.set_token('TYPE','BEN_RNDG');
868: fnd_message.raise_error;
869: --
870: end if;
871: --
872: end if;

Line 936: fnd_message.set_name('BEN','BEN_91006_INVALID_FLAG');

932: p_effective_date => p_effective_date) then
933: --
934: -- raise error as does not exist as lookup
935: --
936: fnd_message.set_name('BEN','BEN_91006_INVALID_FLAG');
937: fnd_message.raise_error;
938: --
939: end if;
940: --

Line 937: fnd_message.raise_error;

933: --
934: -- raise error as does not exist as lookup
935: --
936: fnd_message.set_name('BEN','BEN_91006_INVALID_FLAG');
937: fnd_message.raise_error;
938: --
939: end if;
940: --
941: end if;

Line 1005: fnd_message.set_name('BEN','BEN_91006_INVALID_FLAG');

1001: p_effective_date => p_effective_date) then
1002: --
1003: -- raise error as does not exist as lookup
1004: --
1005: fnd_message.set_name('BEN','BEN_91006_INVALID_FLAG');
1006: fnd_message.raise_error;
1007: --
1008: end if;
1009: --

Line 1006: fnd_message.raise_error;

1002: --
1003: -- raise error as does not exist as lookup
1004: --
1005: fnd_message.set_name('BEN','BEN_91006_INVALID_FLAG');
1006: fnd_message.raise_error;
1007: --
1008: end if;
1009: --
1010: end if;

Line 1074: fnd_message.set_name('BEN','BEN_91006_INVALID_FLAG');

1070: p_effective_date => p_effective_date) then
1071: --
1072: -- raise error as does not exist as lookup
1073: --
1074: fnd_message.set_name('BEN','BEN_91006_INVALID_FLAG');
1075: fnd_message.raise_error;
1076: --
1077: end if;
1078: --

Line 1075: fnd_message.raise_error;

1071: --
1072: -- raise error as does not exist as lookup
1073: --
1074: fnd_message.set_name('BEN','BEN_91006_INVALID_FLAG');
1075: fnd_message.raise_error;
1076: --
1077: end if;
1078: --
1079: end if;

Line 1143: fnd_message.set_name('BEN','BEN_91006_INVALID_FLAG');

1139: p_effective_date => p_effective_date) then
1140: --
1141: -- raise error as does not exist as lookup
1142: --
1143: fnd_message.set_name('BEN','BEN_91006_INVALID_FLAG');
1144: fnd_message.raise_error;
1145: --
1146: end if;
1147: --

Line 1144: fnd_message.raise_error;

1140: --
1141: -- raise error as does not exist as lookup
1142: --
1143: fnd_message.set_name('BEN','BEN_91006_INVALID_FLAG');
1144: fnd_message.raise_error;
1145: --
1146: end if;
1147: --
1148: end if;

Line 1212: fnd_message.set_name('BEN','BEN_91006_INVALID_FLAG');

1208: p_effective_date => p_effective_date) then
1209: --
1210: -- raise error as does not exist as lookup
1211: --
1212: fnd_message.set_name('BEN','BEN_91006_INVALID_FLAG');
1213: fnd_message.raise_error;
1214: --
1215: end if;
1216: --

Line 1213: fnd_message.raise_error;

1209: --
1210: -- raise error as does not exist as lookup
1211: --
1212: fnd_message.set_name('BEN','BEN_91006_INVALID_FLAG');
1213: fnd_message.raise_error;
1214: --
1215: end if;
1216: --
1217: end if;

Line 1283: fnd_message.set_name('BEN','BEN_91006_INVALID_FLAG');

1279: p_effective_date => p_effective_date) then
1280: --
1281: -- raise error as does not exist as lookup
1282: --
1283: fnd_message.set_name('BEN','BEN_91006_INVALID_FLAG');
1284: fnd_message.raise_error;
1285: --
1286: end if;
1287: --

Line 1284: fnd_message.raise_error;

1280: --
1281: -- raise error as does not exist as lookup
1282: --
1283: fnd_message.set_name('BEN','BEN_91006_INVALID_FLAG');
1284: fnd_message.raise_error;
1285: --
1286: end if;
1287: --
1288: end if;

Line 1378: fnd_message.set_name('BEN','BEN_92624_PCT_COMP_REQUIRED');

1374: end if;
1375: --Validating for percent num is null and factor also null or percnt has value and factor als has value
1376: If (p_mx_dfcit_pct_comp_num is null and p_comp_lvl_fctr_id is not null ) or
1377: (p_mx_dfcit_pct_comp_num is not null and p_comp_lvl_fctr_id is null ) then
1378: fnd_message.set_name('BEN','BEN_92624_PCT_COMP_REQUIRED');
1379: fnd_message.raise_error;
1380: End if;
1381: hr_utility.set_location('Leaving:'||l_proc,10);
1382: --

Line 1379: fnd_message.raise_error;

1375: --Validating for percent num is null and factor also null or percnt has value and factor als has value
1376: If (p_mx_dfcit_pct_comp_num is null and p_comp_lvl_fctr_id is not null ) or
1377: (p_mx_dfcit_pct_comp_num is not null and p_comp_lvl_fctr_id is null ) then
1378: fnd_message.set_name('BEN','BEN_92624_PCT_COMP_REQUIRED');
1379: fnd_message.raise_error;
1380: End if;
1381: hr_utility.set_location('Leaving:'||l_proc,10);
1382: --
1383: End chk_comp_lvl_fctr_id;

Line 1442: fnd_message.set_name('BEN','BEN_91006_INVALID_FLAG');

1438: p_effective_date => p_effective_date) then
1439: --
1440: -- raise error as does not exist as lookup
1441: --
1442: fnd_message.set_name('BEN','BEN_91006_INVALID_FLAG');
1443: fnd_message.raise_error;
1444: --
1445: end if;
1446: --

Line 1443: fnd_message.raise_error;

1439: --
1440: -- raise error as does not exist as lookup
1441: --
1442: fnd_message.set_name('BEN','BEN_91006_INVALID_FLAG');
1443: fnd_message.raise_error;
1444: --
1445: end if;
1446: --
1447: end if;

Line 1528: fnd_message.set_name('BEN','BEN_91006_INVALID_FLAG');

1524: p_effective_date => p_effective_date) then
1525: --
1526: -- raise error as does not exist as lookup
1527: --
1528: fnd_message.set_name('BEN','BEN_91006_INVALID_FLAG');
1529: fnd_message.raise_error;
1530: --
1531: end if;
1532:

Line 1529: fnd_message.raise_error;

1525: --
1526: -- raise error as does not exist as lookup
1527: --
1528: fnd_message.set_name('BEN','BEN_91006_INVALID_FLAG');
1529: fnd_message.raise_error;
1530: --
1531: end if;
1532:
1533: -- when the value us 'Y' and theres is value on other region (cash and percent )

Line 1546: fnd_message.set_name('BEN','BEN_92625_USES_NET_CRED_CHKD');

1542: or nvl(p_no_mx_dstrbl_pct_flag,'N') = 'Y'
1543: or nvl(p_mn_dstrbl_pct_num,0) <> 0
1544: or nvl(p_mx_dstrbl_pct_num,0) <> 0
1545: or p_pct_rndg_cd is not null) then
1546: fnd_message.set_name('BEN','BEN_92625_USES_NET_CRED_CHKD');
1547: fnd_message.raise_error;
1548:
1549: end if;
1550: --

Line 1547: fnd_message.raise_error;

1543: or nvl(p_mn_dstrbl_pct_num,0) <> 0
1544: or nvl(p_mx_dstrbl_pct_num,0) <> 0
1545: or p_pct_rndg_cd is not null) then
1546: fnd_message.set_name('BEN','BEN_92625_USES_NET_CRED_CHKD');
1547: fnd_message.raise_error;
1548:
1549: end if;
1550: --
1551: end if;

Line 1616: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');

1612: p_effective_date => p_effective_date) then
1613: --
1614: -- raise error as does not exist as lookup
1615: --
1616: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1617: fnd_message.set_token('FIELD','p_excs_trtmt_cd');
1618: fnd_message.set_token('TYPE','BEN_EXCS_TRTMT');
1619: fnd_message.raise_error;
1620: --

Line 1617: fnd_message.set_token('FIELD','p_excs_trtmt_cd');

1613: --
1614: -- raise error as does not exist as lookup
1615: --
1616: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1617: fnd_message.set_token('FIELD','p_excs_trtmt_cd');
1618: fnd_message.set_token('TYPE','BEN_EXCS_TRTMT');
1619: fnd_message.raise_error;
1620: --
1621: end if;

Line 1618: fnd_message.set_token('TYPE','BEN_EXCS_TRTMT');

1614: -- raise error as does not exist as lookup
1615: --
1616: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1617: fnd_message.set_token('FIELD','p_excs_trtmt_cd');
1618: fnd_message.set_token('TYPE','BEN_EXCS_TRTMT');
1619: fnd_message.raise_error;
1620: --
1621: end if;
1622: --

Line 1619: fnd_message.raise_error;

1615: --
1616: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1617: fnd_message.set_token('FIELD','p_excs_trtmt_cd');
1618: fnd_message.set_token('TYPE','BEN_EXCS_TRTMT');
1619: fnd_message.raise_error;
1620: --
1621: end if;
1622: --
1623: end if;

Line 1689: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');

1685: p_effective_date => p_effective_date) then
1686: --
1687: -- raise error as does not exist as lookup
1688: --
1689: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1690: fnd_message.set_token('FIELD','p_dflt_excs_trtmt_cd');
1691: fnd_message.set_token('TYPE','BEN_DFLT_EXCS_TRTMT');
1692: fnd_message.raise_error;
1693: --

Line 1690: fnd_message.set_token('FIELD','p_dflt_excs_trtmt_cd');

1686: --
1687: -- raise error as does not exist as lookup
1688: --
1689: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1690: fnd_message.set_token('FIELD','p_dflt_excs_trtmt_cd');
1691: fnd_message.set_token('TYPE','BEN_DFLT_EXCS_TRTMT');
1692: fnd_message.raise_error;
1693: --
1694: end if;

Line 1691: fnd_message.set_token('TYPE','BEN_DFLT_EXCS_TRTMT');

1687: -- raise error as does not exist as lookup
1688: --
1689: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1690: fnd_message.set_token('FIELD','p_dflt_excs_trtmt_cd');
1691: fnd_message.set_token('TYPE','BEN_DFLT_EXCS_TRTMT');
1692: fnd_message.raise_error;
1693: --
1694: end if;
1695: --

Line 1692: fnd_message.raise_error;

1688: --
1689: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1690: fnd_message.set_token('FIELD','p_dflt_excs_trtmt_cd');
1691: fnd_message.set_token('TYPE','BEN_DFLT_EXCS_TRTMT');
1692: fnd_message.raise_error;
1693: --
1694: end if;
1695: --
1696: end if;

Line 1785: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');

1781: close c1;
1782: --
1783: -- raise error
1784: --
1785: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
1786: fnd_message.set_token('ID',p_dflt_excs_trtmt_rl);
1787: fnd_message.set_token('TYPE_ID',-533);
1788: fnd_message.raise_error;
1789: --

Line 1786: fnd_message.set_token('ID',p_dflt_excs_trtmt_rl);

1782: --
1783: -- raise error
1784: --
1785: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
1786: fnd_message.set_token('ID',p_dflt_excs_trtmt_rl);
1787: fnd_message.set_token('TYPE_ID',-533);
1788: fnd_message.raise_error;
1789: --
1790: end if;

Line 1787: fnd_message.set_token('TYPE_ID',-533);

1783: -- raise error
1784: --
1785: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
1786: fnd_message.set_token('ID',p_dflt_excs_trtmt_rl);
1787: fnd_message.set_token('TYPE_ID',-533);
1788: fnd_message.raise_error;
1789: --
1790: end if;
1791: --

Line 1788: fnd_message.raise_error;

1784: --
1785: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
1786: fnd_message.set_token('ID',p_dflt_excs_trtmt_rl);
1787: fnd_message.set_token('TYPE_ID',-533);
1788: fnd_message.raise_error;
1789: --
1790: end if;
1791: --
1792: close c1;

Line 1857: fnd_message.set_name('BEN','BEN_91019_RULE_REQUIRED');

1853: or not l_api_updating) then
1854: --
1855: if (p_dflt_excs_trtmt_cd = 'RL' and p_dflt_excs_trtmt_rl is null) then
1856: --
1857: fnd_message.set_name('BEN','BEN_91019_RULE_REQUIRED');
1858: fnd_message.raise_error;
1859: --
1860: end if;
1861: --

Line 1858: fnd_message.raise_error;

1854: --
1855: if (p_dflt_excs_trtmt_cd = 'RL' and p_dflt_excs_trtmt_rl is null) then
1856: --
1857: fnd_message.set_name('BEN','BEN_91019_RULE_REQUIRED');
1858: fnd_message.raise_error;
1859: --
1860: end if;
1861: --
1862: if nvl(p_dflt_excs_trtmt_cd,hr_api.g_varchar2) <> 'RL'

Line 1865: fnd_message.set_name('BEN','BEN_91713_CODE_NOT_RULE');

1861: --
1862: if nvl(p_dflt_excs_trtmt_cd,hr_api.g_varchar2) <> 'RL'
1863: and p_dflt_excs_trtmt_rl is not null then
1864: --
1865: fnd_message.set_name('BEN','BEN_91713_CODE_NOT_RULE');
1866: fnd_message.raise_error;
1867: --
1868: end if;
1869: --

Line 1866: fnd_message.raise_error;

1862: if nvl(p_dflt_excs_trtmt_cd,hr_api.g_varchar2) <> 'RL'
1863: and p_dflt_excs_trtmt_rl is not null then
1864: --
1865: fnd_message.set_name('BEN','BEN_91713_CODE_NOT_RULE');
1866: fnd_message.raise_error;
1867: --
1868: end if;
1869: --
1870: end if;

Line 2036: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

2032: --
2033: -- An unhandled or unexpected error has occurred which
2034: -- we must report
2035: --
2036: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2037: fnd_message.set_token('PROCEDURE', l_proc);
2038: fnd_message.set_token('STEP','15');
2039: fnd_message.raise_error;
2040: End dt_update_validate;

Line 2037: fnd_message.set_token('PROCEDURE', l_proc);

2033: -- An unhandled or unexpected error has occurred which
2034: -- we must report
2035: --
2036: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2037: fnd_message.set_token('PROCEDURE', l_proc);
2038: fnd_message.set_token('STEP','15');
2039: fnd_message.raise_error;
2040: End dt_update_validate;
2041: --

Line 2038: fnd_message.set_token('STEP','15');

2034: -- we must report
2035: --
2036: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2037: fnd_message.set_token('PROCEDURE', l_proc);
2038: fnd_message.set_token('STEP','15');
2039: fnd_message.raise_error;
2040: End dt_update_validate;
2041: --
2042: -- ----------------------------------------------------------------------------

Line 2039: fnd_message.raise_error;

2035: --
2036: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2037: fnd_message.set_token('PROCEDURE', l_proc);
2038: fnd_message.set_token('STEP','15');
2039: fnd_message.raise_error;
2040: End dt_update_validate;
2041: --
2042: -- ----------------------------------------------------------------------------
2043: -- |--------------------------< dt_delete_validate >--------------------------|

Line 2165: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

2161: --
2162: -- An unhandled or unexpected error has occurred which
2163: -- we must report
2164: --
2165: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2166: fnd_message.set_token('PROCEDURE', l_proc);
2167: fnd_message.set_token('STEP','15');
2168: fnd_message.raise_error;
2169: End dt_delete_validate;

Line 2166: fnd_message.set_token('PROCEDURE', l_proc);

2162: -- An unhandled or unexpected error has occurred which
2163: -- we must report
2164: --
2165: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2166: fnd_message.set_token('PROCEDURE', l_proc);
2167: fnd_message.set_token('STEP','15');
2168: fnd_message.raise_error;
2169: End dt_delete_validate;
2170: --

Line 2167: fnd_message.set_token('STEP','15');

2163: -- we must report
2164: --
2165: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2166: fnd_message.set_token('PROCEDURE', l_proc);
2167: fnd_message.set_token('STEP','15');
2168: fnd_message.raise_error;
2169: End dt_delete_validate;
2170: --
2171: -- ----------------------------------------------------------------------------

Line 2168: fnd_message.raise_error;

2164: --
2165: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2166: fnd_message.set_token('PROCEDURE', l_proc);
2167: fnd_message.set_token('STEP','15');
2168: fnd_message.raise_error;
2169: End dt_delete_validate;
2170: --
2171: -- ----------------------------------------------------------------------------
2172: -- |---------------------------< insert_validate >----------------------------|

Line 2652: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');

2648: close csr_leg_code;
2649: --
2650: -- The primary key is invalid therefore we must error
2651: --
2652: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
2653: fnd_message.raise_error;
2654: --
2655: end if;
2656: --

Line 2653: fnd_message.raise_error;

2649: --
2650: -- The primary key is invalid therefore we must error
2651: --
2652: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
2653: fnd_message.raise_error;
2654: --
2655: end if;
2656: --
2657: close csr_leg_code;