DBA Data[Home] [Help]

APPS.BEN_CPP_BUS dependencies on FND_MESSAGE

Line 63: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');

59: --
60: open c1;
61: fetch c1 into l_dummy;
62: if c1%found then
63: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
64: fnd_message.raise_error;
65: end if;
66: close c1;
67: --

Line 64: fnd_message.raise_error;

60: open c1;
61: fetch c1 into l_dummy;
62: if c1%found then
63: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
64: fnd_message.raise_error;
65: end if;
66: close c1;
67: --
68: hr_utility.set_location('Leaving:'||l_proc, 15);

Line 126: fnd_message.set_name('BEN','BEN_91721_DUP_PL_ID_IN_PGM');

122: hr_utility.set_location('p_validation_end_date:'||p_validation_end_date, 5);
123: open c1;
124: fetch c1 into l_dummy;
125: if c1%found then
126: fnd_message.set_name('BEN','BEN_91721_DUP_PL_ID_IN_PGM');
127: fnd_message.raise_error;
128: end if;
129: close c1;
130: hr_utility.set_location('Leaving:'||l_proc, 15);

Line 127: fnd_message.raise_error;

123: open c1;
124: fetch c1 into l_dummy;
125: if c1%found then
126: fnd_message.set_name('BEN','BEN_91721_DUP_PL_ID_IN_PGM');
127: fnd_message.raise_error;
128: end if;
129: close c1;
130: hr_utility.set_location('Leaving:'||l_proc, 15);
131: End chk_duplicate_pl_id_in_pgm;

Line 176: fnd_message.set_name('BEN','BEN_91787_PL_ALWD_IN_PGM');

172: open c1;
173: fetch c1 into l_pl_cd;
174: close c1;
175: if l_pl_cd = 'MYNTBPGM' then
176: fnd_message.set_name('BEN','BEN_91787_PL_ALWD_IN_PGM');
177: fnd_message.raise_error;
178: end if;
179: hr_utility.set_location('Leaving:'||l_proc, 15);
180: End chk_plan_allowed_in_pgm;

Line 177: fnd_message.raise_error;

173: fetch c1 into l_pl_cd;
174: close c1;
175: if l_pl_cd = 'MYNTBPGM' then
176: fnd_message.set_name('BEN','BEN_91787_PL_ALWD_IN_PGM');
177: fnd_message.raise_error;
178: end if;
179: hr_utility.set_location('Leaving:'||l_proc, 15);
180: End chk_plan_allowed_in_pgm;
181: --

Line 216: fnd_message.set_name('BEN','BEN_91730_NO_RULE');

212: hr_utility.set_location('Entering:'||l_proc, 5);
213: --
214: if ( p_vrfy_fmly_mmbr_cd <> 'RL' and p_vrfy_fmly_mmbr_rl is not null)
215: then
216: fnd_message.set_name('BEN','BEN_91730_NO_RULE');
217: fnd_message.raise_error;
218: end if;
219:
220: if ( p_vrfy_fmly_mmbr_cd = 'RL' and p_vrfy_fmly_mmbr_rl is null)

Line 217: fnd_message.raise_error;

213: --
214: if ( p_vrfy_fmly_mmbr_cd <> 'RL' and p_vrfy_fmly_mmbr_rl is not null)
215: then
216: fnd_message.set_name('BEN','BEN_91730_NO_RULE');
217: fnd_message.raise_error;
218: end if;
219:
220: if ( p_vrfy_fmly_mmbr_cd = 'RL' and p_vrfy_fmly_mmbr_rl is null)
221: then

Line 222: fnd_message.set_name('BEN','BEN_91731_RULE');

218: end if;
219:
220: if ( p_vrfy_fmly_mmbr_cd = 'RL' and p_vrfy_fmly_mmbr_rl is null)
221: then
222: fnd_message.set_name('BEN','BEN_91731_RULE');
223: fnd_message.raise_error;
224: end if;
225: --
226: --leaving Procedure.

Line 223: fnd_message.raise_error;

219:
220: if ( p_vrfy_fmly_mmbr_cd = 'RL' and p_vrfy_fmly_mmbr_rl is null)
221: then
222: fnd_message.set_name('BEN','BEN_91731_RULE');
223: fnd_message.raise_error;
224: end if;
225: --
226: --leaving Procedure.
227: --

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

379: close c1;
380: --
381: -- raise error
382: --
383: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
384: fnd_message.set_token('ID',p_dflt_enrt_det_rl);
385: fnd_message.set_token('TYPE_ID',-32);
386: fnd_message.raise_error;
387: --

Line 384: fnd_message.set_token('ID',p_dflt_enrt_det_rl);

380: --
381: -- raise error
382: --
383: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
384: fnd_message.set_token('ID',p_dflt_enrt_det_rl);
385: fnd_message.set_token('TYPE_ID',-32);
386: fnd_message.raise_error;
387: --
388: end if;

Line 385: fnd_message.set_token('TYPE_ID',-32);

381: -- raise error
382: --
383: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
384: fnd_message.set_token('ID',p_dflt_enrt_det_rl);
385: fnd_message.set_token('TYPE_ID',-32);
386: fnd_message.raise_error;
387: --
388: end if;
389: --

Line 386: fnd_message.raise_error;

382: --
383: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
384: fnd_message.set_token('ID',p_dflt_enrt_det_rl);
385: fnd_message.set_token('TYPE_ID',-32);
386: fnd_message.raise_error;
387: --
388: end if;
389: --
390: close c1;

Line 479: fnd_message.set_name('BEN','BEN_91953_NVLD_AUTO_ENR_MTH_RL');

475: close c1;
476: --
477: -- raise error
478: --
479: fnd_message.set_name('BEN','BEN_91953_NVLD_AUTO_ENR_MTH_RL');
480: fnd_message.raise_error;
481: --
482: end if;
483: --

Line 480: fnd_message.raise_error;

476: --
477: -- raise error
478: --
479: fnd_message.set_name('BEN','BEN_91953_NVLD_AUTO_ENR_MTH_RL');
480: fnd_message.raise_error;
481: --
482: end if;
483: --
484: close c1;

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

524: p_effective_date => p_effective_date) then
525: --
526: -- raise error as does not exist as lookup
527: --
528: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
529: fnd_message.set_token('FIELD', 'p_vrfy_fmly_mmbr_cd');
530: fnd_message.set_token('TYPE','BEN_FMLY_MMBR');
531: fnd_message.raise_error;
532: --

Line 529: fnd_message.set_token('FIELD', 'p_vrfy_fmly_mmbr_cd');

525: --
526: -- raise error as does not exist as lookup
527: --
528: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
529: fnd_message.set_token('FIELD', 'p_vrfy_fmly_mmbr_cd');
530: fnd_message.set_token('TYPE','BEN_FMLY_MMBR');
531: fnd_message.raise_error;
532: --
533: end if;

Line 530: fnd_message.set_token('TYPE','BEN_FMLY_MMBR');

526: -- raise error as does not exist as lookup
527: --
528: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
529: fnd_message.set_token('FIELD', 'p_vrfy_fmly_mmbr_cd');
530: fnd_message.set_token('TYPE','BEN_FMLY_MMBR');
531: fnd_message.raise_error;
532: --
533: end if;
534: --

Line 531: fnd_message.raise_error;

527: --
528: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
529: fnd_message.set_token('FIELD', 'p_vrfy_fmly_mmbr_cd');
530: fnd_message.set_token('TYPE','BEN_FMLY_MMBR');
531: fnd_message.raise_error;
532: --
533: end if;
534: --
535: end if;

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

574: p_effective_date => p_effective_date) then
575: --
576: -- raise error as does not exist as lookup
577: --
578: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
579: fnd_message.set_token('FIELD', 'p_use_csd_rsd_prccng_cd');
580: fnd_message.set_token('TYPE','BEN_USE_CSD_RSD_PRCCNG');
581: fnd_message.raise_error;
582: --

Line 579: fnd_message.set_token('FIELD', 'p_use_csd_rsd_prccng_cd');

575: --
576: -- raise error as does not exist as lookup
577: --
578: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
579: fnd_message.set_token('FIELD', 'p_use_csd_rsd_prccng_cd');
580: fnd_message.set_token('TYPE','BEN_USE_CSD_RSD_PRCCNG');
581: fnd_message.raise_error;
582: --
583: end if;

Line 580: fnd_message.set_token('TYPE','BEN_USE_CSD_RSD_PRCCNG');

576: -- raise error as does not exist as lookup
577: --
578: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
579: fnd_message.set_token('FIELD', 'p_use_csd_rsd_prccng_cd');
580: fnd_message.set_token('TYPE','BEN_USE_CSD_RSD_PRCCNG');
581: fnd_message.raise_error;
582: --
583: end if;
584: --

Line 581: fnd_message.raise_error;

577: --
578: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
579: fnd_message.set_token('FIELD', 'p_use_csd_rsd_prccng_cd');
580: fnd_message.set_token('TYPE','BEN_USE_CSD_RSD_PRCCNG');
581: fnd_message.raise_error;
582: --
583: end if;
584: --
585: end if;

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

626: p_effective_date => p_effective_date) then
627: --
628: -- raise error
629: --
630: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
631: fnd_message.set_token('ID',p_vrfy_fmly_mmbr_rl);
632: fnd_message.set_token('TYPE_ID',-21);
633: fnd_message.raise_error;
634: --

Line 631: fnd_message.set_token('ID',p_vrfy_fmly_mmbr_rl);

627: --
628: -- raise error
629: --
630: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
631: fnd_message.set_token('ID',p_vrfy_fmly_mmbr_rl);
632: fnd_message.set_token('TYPE_ID',-21);
633: fnd_message.raise_error;
634: --
635: end if;

Line 632: fnd_message.set_token('TYPE_ID',-21);

628: -- raise error
629: --
630: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
631: fnd_message.set_token('ID',p_vrfy_fmly_mmbr_rl);
632: fnd_message.set_token('TYPE_ID',-21);
633: fnd_message.raise_error;
634: --
635: end if;
636: --

Line 633: fnd_message.raise_error;

629: --
630: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
631: fnd_message.set_token('ID',p_vrfy_fmly_mmbr_rl);
632: fnd_message.set_token('TYPE_ID',-21);
633: fnd_message.raise_error;
634: --
635: end if;
636: --
637: end if;

Line 727: fnd_message.set_name('BEN','BEN_91952_INVLD_ENRT_RL');

723: close c1;
724: --
725: -- raise error
726: --
727: fnd_message.set_name('BEN','BEN_91952_INVLD_ENRT_RL');
728: fnd_message.raise_error;
729: --
730: end if;
731: --

Line 728: fnd_message.raise_error;

724: --
725: -- raise error
726: --
727: fnd_message.set_name('BEN','BEN_91952_INVLD_ENRT_RL');
728: fnd_message.raise_error;
729: --
730: end if;
731: --
732: close c1;

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

817: close c1;
818: --
819: -- raise error
820: --
821: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
822: fnd_message.set_token('ID',p_dflt_to_asn_pndg_ctfn_rl);
823: fnd_message.set_token('TYPE_ID',-454);
824: fnd_message.raise_error;
825: --

Line 822: fnd_message.set_token('ID',p_dflt_to_asn_pndg_ctfn_rl);

818: --
819: -- raise error
820: --
821: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
822: fnd_message.set_token('ID',p_dflt_to_asn_pndg_ctfn_rl);
823: fnd_message.set_token('TYPE_ID',-454);
824: fnd_message.raise_error;
825: --
826: end if;

Line 823: fnd_message.set_token('TYPE_ID',-454);

819: -- raise error
820: --
821: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
822: fnd_message.set_token('ID',p_dflt_to_asn_pndg_ctfn_rl);
823: fnd_message.set_token('TYPE_ID',-454);
824: fnd_message.raise_error;
825: --
826: end if;
827: --

Line 824: fnd_message.raise_error;

820: --
821: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
822: fnd_message.set_token('ID',p_dflt_to_asn_pndg_ctfn_rl);
823: fnd_message.set_token('TYPE_ID',-454);
824: fnd_message.raise_error;
825: --
826: end if;
827: --
828: close c1;

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

913: close c1;
914: --
915: -- raise error
916: --
917: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
918: fnd_message.set_token('ID',p_mn_cvg_rl);
919: fnd_message.set_token('TYPE_ID',-164);
920: fnd_message.raise_error;
921: --

Line 918: fnd_message.set_token('ID',p_mn_cvg_rl);

914: --
915: -- raise error
916: --
917: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
918: fnd_message.set_token('ID',p_mn_cvg_rl);
919: fnd_message.set_token('TYPE_ID',-164);
920: fnd_message.raise_error;
921: --
922: end if;

Line 919: fnd_message.set_token('TYPE_ID',-164);

915: -- raise error
916: --
917: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
918: fnd_message.set_token('ID',p_mn_cvg_rl);
919: fnd_message.set_token('TYPE_ID',-164);
920: fnd_message.raise_error;
921: --
922: end if;
923: --

Line 920: fnd_message.raise_error;

916: --
917: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
918: fnd_message.set_token('ID',p_mn_cvg_rl);
919: fnd_message.set_token('TYPE_ID',-164);
920: fnd_message.raise_error;
921: --
922: end if;
923: --
924: close c1;

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

1009: close c1;
1010: --
1011: -- raise error
1012: --
1013: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
1014: fnd_message.set_token('ID',p_mx_cvg_rl);
1015: fnd_message.set_token('TYPE_ID',-161);
1016: fnd_message.raise_error;
1017: --

Line 1014: fnd_message.set_token('ID',p_mx_cvg_rl);

1010: --
1011: -- raise error
1012: --
1013: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
1014: fnd_message.set_token('ID',p_mx_cvg_rl);
1015: fnd_message.set_token('TYPE_ID',-161);
1016: fnd_message.raise_error;
1017: --
1018: end if;

Line 1015: fnd_message.set_token('TYPE_ID',-161);

1011: -- raise error
1012: --
1013: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
1014: fnd_message.set_token('ID',p_mx_cvg_rl);
1015: fnd_message.set_token('TYPE_ID',-161);
1016: fnd_message.raise_error;
1017: --
1018: end if;
1019: --

Line 1016: fnd_message.raise_error;

1012: --
1013: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
1014: fnd_message.set_token('ID',p_mx_cvg_rl);
1015: fnd_message.set_token('TYPE_ID',-161);
1016: fnd_message.raise_error;
1017: --
1018: end if;
1019: --
1020: close c1;

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

1105: close c1;
1106: --
1107: -- raise error
1108: --
1109: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
1110: fnd_message.set_token('ID',p_prort_prtl_yr_cvg_rstrn_rl);
1111: fnd_message.set_token('TYPE_ID',-166);
1112: fnd_message.raise_error;
1113: --

Line 1110: fnd_message.set_token('ID',p_prort_prtl_yr_cvg_rstrn_rl);

1106: --
1107: -- raise error
1108: --
1109: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
1110: fnd_message.set_token('ID',p_prort_prtl_yr_cvg_rstrn_rl);
1111: fnd_message.set_token('TYPE_ID',-166);
1112: fnd_message.raise_error;
1113: --
1114: end if;

Line 1111: fnd_message.set_token('TYPE_ID',-166);

1107: -- raise error
1108: --
1109: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
1110: fnd_message.set_token('ID',p_prort_prtl_yr_cvg_rstrn_rl);
1111: fnd_message.set_token('TYPE_ID',-166);
1112: fnd_message.raise_error;
1113: --
1114: end if;
1115: --

Line 1112: fnd_message.raise_error;

1108: --
1109: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
1110: fnd_message.set_token('ID',p_prort_prtl_yr_cvg_rstrn_rl);
1111: fnd_message.set_token('TYPE_ID',-166);
1112: fnd_message.raise_error;
1113: --
1114: end if;
1115: --
1116: close c1;

Line 1182: fnd_message.set_name('BEN','BEN_91216_INV_DFLT_ENRT_MTHD');

1178: p_effective_date => p_effective_date) then
1179: --
1180: -- raise error as does not exist as lookup
1181: --
1182: fnd_message.set_name('BEN','BEN_91216_INV_DFLT_ENRT_MTHD');
1183: fnd_message.raise_error;
1184: --
1185: end if;
1186: --

Line 1183: fnd_message.raise_error;

1179: --
1180: -- raise error as does not exist as lookup
1181: --
1182: fnd_message.set_name('BEN','BEN_91216_INV_DFLT_ENRT_MTHD');
1183: fnd_message.raise_error;
1184: --
1185: end if;
1186: --
1187: end if;

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

1247: p_effective_date => p_effective_date) then
1248: --
1249: -- raise error as does not exist as lookup
1250: --
1251: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1252: fnd_message.set_token('FIELD', 'p_dflt_to_asn_pndg_ctfn_cd');
1253: fnd_message.set_token('TYPE', 'BEN_DFLT_TO_ASN_PNDG_CTFN');
1254: fnd_message.raise_error;
1255: --

Line 1252: fnd_message.set_token('FIELD', 'p_dflt_to_asn_pndg_ctfn_cd');

1248: --
1249: -- raise error as does not exist as lookup
1250: --
1251: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1252: fnd_message.set_token('FIELD', 'p_dflt_to_asn_pndg_ctfn_cd');
1253: fnd_message.set_token('TYPE', 'BEN_DFLT_TO_ASN_PNDG_CTFN');
1254: fnd_message.raise_error;
1255: --
1256: end if;

Line 1253: fnd_message.set_token('TYPE', 'BEN_DFLT_TO_ASN_PNDG_CTFN');

1249: -- raise error as does not exist as lookup
1250: --
1251: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1252: fnd_message.set_token('FIELD', 'p_dflt_to_asn_pndg_ctfn_cd');
1253: fnd_message.set_token('TYPE', 'BEN_DFLT_TO_ASN_PNDG_CTFN');
1254: fnd_message.raise_error;
1255: --
1256: end if;
1257: --

Line 1254: fnd_message.raise_error;

1250: --
1251: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1252: fnd_message.set_token('FIELD', 'p_dflt_to_asn_pndg_ctfn_cd');
1253: fnd_message.set_token('TYPE', 'BEN_DFLT_TO_ASN_PNDG_CTFN');
1254: fnd_message.raise_error;
1255: --
1256: end if;
1257: --
1258: end if;

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

1318: p_effective_date => p_effective_date) then
1319: --
1320: -- raise error as does not exist as lookup
1321: --
1322: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1323: fnd_message.set_token('FIELD', 'p_unsspnd_enrt_cd');
1324: fnd_message.set_token('TYPE', 'BEN_UNSSPND_ENRT');
1325: fnd_message.raise_error;
1326: --

Line 1323: fnd_message.set_token('FIELD', 'p_unsspnd_enrt_cd');

1319: --
1320: -- raise error as does not exist as lookup
1321: --
1322: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1323: fnd_message.set_token('FIELD', 'p_unsspnd_enrt_cd');
1324: fnd_message.set_token('TYPE', 'BEN_UNSSPND_ENRT');
1325: fnd_message.raise_error;
1326: --
1327: end if;

Line 1324: fnd_message.set_token('TYPE', 'BEN_UNSSPND_ENRT');

1320: -- raise error as does not exist as lookup
1321: --
1322: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1323: fnd_message.set_token('FIELD', 'p_unsspnd_enrt_cd');
1324: fnd_message.set_token('TYPE', 'BEN_UNSSPND_ENRT');
1325: fnd_message.raise_error;
1326: --
1327: end if;
1328: --

Line 1325: fnd_message.raise_error;

1321: --
1322: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1323: fnd_message.set_token('FIELD', 'p_unsspnd_enrt_cd');
1324: fnd_message.set_token('TYPE', 'BEN_UNSSPND_ENRT');
1325: fnd_message.raise_error;
1326: --
1327: end if;
1328: --
1329: end if;

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

1389: p_effective_date => p_effective_date) then
1390: --
1391: -- raise error as does not exist as lookup
1392: --
1393: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1394: fnd_message.set_token('FIELD', 'p_prort_prtl_yr_cvg_rstrn_cd');
1395: fnd_message.set_token('TYPE', 'BEN_PRORT_PRTL_YR_CVG_RSTRN');
1396: fnd_message.raise_error;
1397: --

Line 1394: fnd_message.set_token('FIELD', 'p_prort_prtl_yr_cvg_rstrn_cd');

1390: --
1391: -- raise error as does not exist as lookup
1392: --
1393: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1394: fnd_message.set_token('FIELD', 'p_prort_prtl_yr_cvg_rstrn_cd');
1395: fnd_message.set_token('TYPE', 'BEN_PRORT_PRTL_YR_CVG_RSTRN');
1396: fnd_message.raise_error;
1397: --
1398: end if;

Line 1395: fnd_message.set_token('TYPE', 'BEN_PRORT_PRTL_YR_CVG_RSTRN');

1391: -- raise error as does not exist as lookup
1392: --
1393: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1394: fnd_message.set_token('FIELD', 'p_prort_prtl_yr_cvg_rstrn_cd');
1395: fnd_message.set_token('TYPE', 'BEN_PRORT_PRTL_YR_CVG_RSTRN');
1396: fnd_message.raise_error;
1397: --
1398: end if;
1399: --

Line 1396: fnd_message.raise_error;

1392: --
1393: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1394: fnd_message.set_token('FIELD', 'p_prort_prtl_yr_cvg_rstrn_cd');
1395: fnd_message.set_token('TYPE', 'BEN_PRORT_PRTL_YR_CVG_RSTRN');
1396: fnd_message.raise_error;
1397: --
1398: end if;
1399: --
1400: end if;

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

1460: p_effective_date => p_effective_date) then
1461: --
1462: -- raise error as does not exist as lookup
1463: --
1464: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1465: fnd_message.set_token('FIELD','p_cvg_incr_r_decr_only_cd');
1466: fnd_message.set_token('TYPE','YES_NO');
1467: fnd_message.raise_error;
1468: --

Line 1465: fnd_message.set_token('FIELD','p_cvg_incr_r_decr_only_cd');

1461: --
1462: -- raise error as does not exist as lookup
1463: --
1464: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1465: fnd_message.set_token('FIELD','p_cvg_incr_r_decr_only_cd');
1466: fnd_message.set_token('TYPE','YES_NO');
1467: fnd_message.raise_error;
1468: --
1469: end if;

Line 1466: fnd_message.set_token('TYPE','YES_NO');

1462: -- raise error as does not exist as lookup
1463: --
1464: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1465: fnd_message.set_token('FIELD','p_cvg_incr_r_decr_only_cd');
1466: fnd_message.set_token('TYPE','YES_NO');
1467: fnd_message.raise_error;
1468: --
1469: end if;
1470: --

Line 1467: fnd_message.raise_error;

1463: --
1464: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1465: fnd_message.set_token('FIELD','p_cvg_incr_r_decr_only_cd');
1466: fnd_message.set_token('TYPE','YES_NO');
1467: fnd_message.raise_error;
1468: --
1469: end if;
1470: --
1471: end if;

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

1531: p_effective_date => p_effective_date) then
1532: --
1533: -- raise error as does not exist as lookup
1534: --
1535: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1536: fnd_message.set_token('FIELD','p_bnft_or_option_rstrctn_cd');
1537: fnd_message.set_token('TYPE','BEN_BNFT_R_OPT_RSTRN');
1538: fnd_message.raise_error;
1539: --

Line 1536: fnd_message.set_token('FIELD','p_bnft_or_option_rstrctn_cd');

1532: --
1533: -- raise error as does not exist as lookup
1534: --
1535: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1536: fnd_message.set_token('FIELD','p_bnft_or_option_rstrctn_cd');
1537: fnd_message.set_token('TYPE','BEN_BNFT_R_OPT_RSTRN');
1538: fnd_message.raise_error;
1539: --
1540: end if;

Line 1537: fnd_message.set_token('TYPE','BEN_BNFT_R_OPT_RSTRN');

1533: -- raise error as does not exist as lookup
1534: --
1535: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1536: fnd_message.set_token('FIELD','p_bnft_or_option_rstrctn_cd');
1537: fnd_message.set_token('TYPE','BEN_BNFT_R_OPT_RSTRN');
1538: fnd_message.raise_error;
1539: --
1540: end if;
1541: --

Line 1538: fnd_message.raise_error;

1534: --
1535: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1536: fnd_message.set_token('FIELD','p_bnft_or_option_rstrctn_cd');
1537: fnd_message.set_token('TYPE','BEN_BNFT_R_OPT_RSTRN');
1538: fnd_message.raise_error;
1539: --
1540: end if;
1541: --
1542: end if;

Line 1606: fnd_message.set_name('BEN','BEN_91951_INVLD_ENRT_MTHD_CD');

1602: p_effective_date => p_effective_date) then
1603: --
1604: -- raise error as does not exist as lookup
1605: --
1606: fnd_message.set_name('BEN','BEN_91951_INVLD_ENRT_MTHD_CD');
1607: fnd_message.raise_error;
1608: --
1609: end if;
1610: --

Line 1607: fnd_message.raise_error;

1603: --
1604: -- raise error as does not exist as lookup
1605: --
1606: fnd_message.set_name('BEN','BEN_91951_INVLD_ENRT_MTHD_CD');
1607: fnd_message.raise_error;
1608: --
1609: end if;
1610: --
1611: end if;

Line 1675: fnd_message.set_name('BEN','BEN_91950_INVALID_ENRT_CD');

1671: p_effective_date => p_effective_date) then
1672: --
1673: -- raise error as does not exist as lookup
1674: --
1675: fnd_message.set_name('BEN','BEN_91950_INVALID_ENRT_CD');
1676: fnd_message.raise_error;
1677: --
1678: end if;
1679: --

Line 1676: fnd_message.raise_error;

1672: --
1673: -- raise error as does not exist as lookup
1674: --
1675: fnd_message.set_name('BEN','BEN_91950_INVALID_ENRT_CD');
1676: fnd_message.raise_error;
1677: --
1678: end if;
1679: --
1680: end if;

Line 1744: fnd_message.set_name('BEN','BEN_91217_INVLD_STAT_CD');

1740: p_effective_date => p_effective_date) then
1741: --
1742: -- raise error as does not exist as lookup
1743: --
1744: fnd_message.set_name('BEN','BEN_91217_INVLD_STAT_CD');
1745: fnd_message.raise_error;
1746: --
1747: end if;
1748: --

Line 1745: fnd_message.raise_error;

1741: --
1742: -- raise error as does not exist as lookup
1743: --
1744: fnd_message.set_name('BEN','BEN_91217_INVLD_STAT_CD');
1745: fnd_message.raise_error;
1746: --
1747: end if;
1748: --
1749: end if;

Line 1813: fnd_message.set_name('BEN','BEN_91210_INVLD_DFLT_FLAG');

1809: p_effective_date => p_effective_date) then
1810: --
1811: -- raise error as does not exist as lookup
1812: --
1813: fnd_message.set_name('BEN','BEN_91210_INVLD_DFLT_FLAG');
1814: fnd_message.raise_error;
1815: --
1816: end if;
1817: --

Line 1814: fnd_message.raise_error;

1810: --
1811: -- raise error as does not exist as lookup
1812: --
1813: fnd_message.set_name('BEN','BEN_91210_INVLD_DFLT_FLAG');
1814: fnd_message.raise_error;
1815: --
1816: end if;
1817: --
1818: end if;

Line 1882: fnd_message.set_name('BEN','BEN_91949_ALWS_UNRSTR_ENRT_FLAG');

1878: p_effective_date => p_effective_date) then
1879: --
1880: -- raise error as does not exist as lookup
1881: --
1882: fnd_message.set_name('BEN','BEN_91949_ALWS_UNRSTR_ENRT_FLAG');
1883: fnd_message.raise_error;
1884: --
1885: end if;
1886: --

Line 1883: fnd_message.raise_error;

1879: --
1880: -- raise error as does not exist as lookup
1881: --
1882: fnd_message.set_name('BEN','BEN_91949_ALWS_UNRSTR_ENRT_FLAG');
1883: fnd_message.raise_error;
1884: --
1885: end if;
1886: --
1887: end if;

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

1947: p_effective_date => p_effective_date) then
1948: --
1949: -- raise error as does not exist as lookup
1950: --
1951: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1952: fnd_message.set_token('FIELD','p_no_mn_cvg_amt_apls_flag');
1953: fnd_message.set_token('TYPE','YES_NO');
1954: fnd_message.raise_error;
1955: --

Line 1952: fnd_message.set_token('FIELD','p_no_mn_cvg_amt_apls_flag');

1948: --
1949: -- raise error as does not exist as lookup
1950: --
1951: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1952: fnd_message.set_token('FIELD','p_no_mn_cvg_amt_apls_flag');
1953: fnd_message.set_token('TYPE','YES_NO');
1954: fnd_message.raise_error;
1955: --
1956: end if;

Line 1953: fnd_message.set_token('TYPE','YES_NO');

1949: -- raise error as does not exist as lookup
1950: --
1951: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1952: fnd_message.set_token('FIELD','p_no_mn_cvg_amt_apls_flag');
1953: fnd_message.set_token('TYPE','YES_NO');
1954: fnd_message.raise_error;
1955: --
1956: end if;
1957: --

Line 1954: fnd_message.raise_error;

1950: --
1951: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1952: fnd_message.set_token('FIELD','p_no_mn_cvg_amt_apls_flag');
1953: fnd_message.set_token('TYPE','YES_NO');
1954: fnd_message.raise_error;
1955: --
1956: end if;
1957: --
1958: end if;

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

2018: p_effective_date => p_effective_date) then
2019: --
2020: -- raise error as does not exist as lookup
2021: --
2022: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
2023: fnd_message.set_token('FIELD','p_no_mn_cvg_incr_apls_flag');
2024: fnd_message.set_token('TYPE','YES_NO');
2025: fnd_message.raise_error;
2026: --

Line 2023: fnd_message.set_token('FIELD','p_no_mn_cvg_incr_apls_flag');

2019: --
2020: -- raise error as does not exist as lookup
2021: --
2022: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
2023: fnd_message.set_token('FIELD','p_no_mn_cvg_incr_apls_flag');
2024: fnd_message.set_token('TYPE','YES_NO');
2025: fnd_message.raise_error;
2026: --
2027: end if;

Line 2024: fnd_message.set_token('TYPE','YES_NO');

2020: -- raise error as does not exist as lookup
2021: --
2022: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
2023: fnd_message.set_token('FIELD','p_no_mn_cvg_incr_apls_flag');
2024: fnd_message.set_token('TYPE','YES_NO');
2025: fnd_message.raise_error;
2026: --
2027: end if;
2028: --

Line 2025: fnd_message.raise_error;

2021: --
2022: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
2023: fnd_message.set_token('FIELD','p_no_mn_cvg_incr_apls_flag');
2024: fnd_message.set_token('TYPE','YES_NO');
2025: fnd_message.raise_error;
2026: --
2027: end if;
2028: --
2029: end if;

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

2089: p_effective_date => p_effective_date) then
2090: --
2091: -- raise error as does not exist as lookup
2092: --
2093: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
2094: fnd_message.set_token('FIELD','p_no_mx_cvg_amt_apls_flag');
2095: fnd_message.set_token('TYPE','YES_NO');
2096: fnd_message.raise_error;
2097: --

Line 2094: fnd_message.set_token('FIELD','p_no_mx_cvg_amt_apls_flag');

2090: --
2091: -- raise error as does not exist as lookup
2092: --
2093: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
2094: fnd_message.set_token('FIELD','p_no_mx_cvg_amt_apls_flag');
2095: fnd_message.set_token('TYPE','YES_NO');
2096: fnd_message.raise_error;
2097: --
2098: end if;

Line 2095: fnd_message.set_token('TYPE','YES_NO');

2091: -- raise error as does not exist as lookup
2092: --
2093: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
2094: fnd_message.set_token('FIELD','p_no_mx_cvg_amt_apls_flag');
2095: fnd_message.set_token('TYPE','YES_NO');
2096: fnd_message.raise_error;
2097: --
2098: end if;
2099: --

Line 2096: fnd_message.raise_error;

2092: --
2093: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
2094: fnd_message.set_token('FIELD','p_no_mx_cvg_amt_apls_flag');
2095: fnd_message.set_token('TYPE','YES_NO');
2096: fnd_message.raise_error;
2097: --
2098: end if;
2099: --
2100: end if;

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

2160: p_effective_date => p_effective_date) then
2161: --
2162: -- raise error as does not exist as lookup
2163: --
2164: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
2165: fnd_message.set_token('FIELD','p_no_mx_cvg_incr_apls_flag');
2166: fnd_message.set_token('TYPE','YES_NO');
2167: fnd_message.raise_error;
2168: --

Line 2165: fnd_message.set_token('FIELD','p_no_mx_cvg_incr_apls_flag');

2161: --
2162: -- raise error as does not exist as lookup
2163: --
2164: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
2165: fnd_message.set_token('FIELD','p_no_mx_cvg_incr_apls_flag');
2166: fnd_message.set_token('TYPE','YES_NO');
2167: fnd_message.raise_error;
2168: --
2169: end if;

Line 2166: fnd_message.set_token('TYPE','YES_NO');

2162: -- raise error as does not exist as lookup
2163: --
2164: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
2165: fnd_message.set_token('FIELD','p_no_mx_cvg_incr_apls_flag');
2166: fnd_message.set_token('TYPE','YES_NO');
2167: fnd_message.raise_error;
2168: --
2169: end if;
2170: --

Line 2167: fnd_message.raise_error;

2163: --
2164: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
2165: fnd_message.set_token('FIELD','p_no_mx_cvg_incr_apls_flag');
2166: fnd_message.set_token('TYPE','YES_NO');
2167: fnd_message.raise_error;
2168: --
2169: end if;
2170: --
2171: end if;

Line 2222: fnd_message.set_name('BEN','BEN_91150_NO_MIN_CVG_APLS_FLAG');

2218: (p_no_mn_cvg_amt_apls_flag='N' and p_mn_cvg_amt=0)) then
2219: --
2220: -- raise error as is not a valid combination
2221: --
2222: fnd_message.set_name('BEN','BEN_91150_NO_MIN_CVG_APLS_FLAG');
2223: fnd_message.raise_error;
2224: --
2225: end if;
2226: --

Line 2223: fnd_message.raise_error;

2219: --
2220: -- raise error as is not a valid combination
2221: --
2222: fnd_message.set_name('BEN','BEN_91150_NO_MIN_CVG_APLS_FLAG');
2223: fnd_message.raise_error;
2224: --
2225: end if;
2226: --
2227: -- check if it is a valid combination

Line 2234: fnd_message.set_name('BEN','BEN_91149_NO_MAX_CVG_APLS_FLAG');

2230: (p_no_mx_cvg_amt_apls_flag='N' and p_mx_cvg_alwd_amt=0)) then
2231: --
2232: -- raise error as is not a valid combination
2233: --
2234: fnd_message.set_name('BEN','BEN_91149_NO_MAX_CVG_APLS_FLAG');
2235: fnd_message.raise_error;
2236: --
2237: end if;
2238: --

Line 2235: fnd_message.raise_error;

2231: --
2232: -- raise error as is not a valid combination
2233: --
2234: fnd_message.set_name('BEN','BEN_91149_NO_MAX_CVG_APLS_FLAG');
2235: fnd_message.raise_error;
2236: --
2237: end if;
2238: --
2239: hr_utility.set_location('Leaving:'||l_proc,10);

Line 2282: fnd_message.set_name('BEN','BEN_91945_MN_VAL_FLAG_RULE');

2278: --
2279: if p_mn_cvg_amt is not null and (p_no_mn_cvg_amt_apls_flag = 'Y' or
2280: p_mn_cvg_rl is not null) then
2281: --
2282: fnd_message.set_name('BEN','BEN_91945_MN_VAL_FLAG_RULE');
2283: fnd_message.raise_error;
2284: --
2285: elsif p_mn_cvg_rl is not null and (p_no_mn_cvg_amt_apls_flag = 'Y' or
2286: p_mn_cvg_amt is not null) then

Line 2283: fnd_message.raise_error;

2279: if p_mn_cvg_amt is not null and (p_no_mn_cvg_amt_apls_flag = 'Y' or
2280: p_mn_cvg_rl is not null) then
2281: --
2282: fnd_message.set_name('BEN','BEN_91945_MN_VAL_FLAG_RULE');
2283: fnd_message.raise_error;
2284: --
2285: elsif p_mn_cvg_rl is not null and (p_no_mn_cvg_amt_apls_flag = 'Y' or
2286: p_mn_cvg_amt is not null) then
2287: --

Line 2288: fnd_message.set_name('BEN','BEN_91945_MN_VAL_FLAG_RULE');

2284: --
2285: elsif p_mn_cvg_rl is not null and (p_no_mn_cvg_amt_apls_flag = 'Y' or
2286: p_mn_cvg_amt is not null) then
2287: --
2288: fnd_message.set_name('BEN','BEN_91945_MN_VAL_FLAG_RULE');
2289: fnd_message.raise_error;
2290: --
2291: elsif p_no_mn_cvg_amt_apls_flag = 'Y' and (p_mn_cvg_amt is not null or
2292: p_mn_cvg_rl is not null) then

Line 2289: fnd_message.raise_error;

2285: elsif p_mn_cvg_rl is not null and (p_no_mn_cvg_amt_apls_flag = 'Y' or
2286: p_mn_cvg_amt is not null) then
2287: --
2288: fnd_message.set_name('BEN','BEN_91945_MN_VAL_FLAG_RULE');
2289: fnd_message.raise_error;
2290: --
2291: elsif p_no_mn_cvg_amt_apls_flag = 'Y' and (p_mn_cvg_amt is not null or
2292: p_mn_cvg_rl is not null) then
2293: --

Line 2294: fnd_message.set_name('BEN','BEN_91945_MN_VAL_FLAG_RULE');

2290: --
2291: elsif p_no_mn_cvg_amt_apls_flag = 'Y' and (p_mn_cvg_amt is not null or
2292: p_mn_cvg_rl is not null) then
2293: --
2294: fnd_message.set_name('BEN','BEN_91945_MN_VAL_FLAG_RULE');
2295: fnd_message.raise_error;
2296: --
2297: end if;
2298: --

Line 2295: fnd_message.raise_error;

2291: elsif p_no_mn_cvg_amt_apls_flag = 'Y' and (p_mn_cvg_amt is not null or
2292: p_mn_cvg_rl is not null) then
2293: --
2294: fnd_message.set_name('BEN','BEN_91945_MN_VAL_FLAG_RULE');
2295: fnd_message.raise_error;
2296: --
2297: end if;
2298: --
2299: hr_utility.set_location('Leaving:'||l_proc,10);

Line 2342: fnd_message.set_name('BEN','BEN_91946_MX_VAL_FLAG_RULE');

2338: --
2339: if p_mx_cvg_alwd_amt is not null and (p_no_mx_cvg_amt_apls_flag = 'Y' or
2340: p_mx_cvg_rl is not null) then
2341: --
2342: fnd_message.set_name('BEN','BEN_91946_MX_VAL_FLAG_RULE');
2343: fnd_message.raise_error;
2344: --
2345: elsif p_mx_cvg_rl is not null and (p_no_mx_cvg_amt_apls_flag = 'Y' or
2346: p_mx_cvg_alwd_amt is not null) then

Line 2343: fnd_message.raise_error;

2339: if p_mx_cvg_alwd_amt is not null and (p_no_mx_cvg_amt_apls_flag = 'Y' or
2340: p_mx_cvg_rl is not null) then
2341: --
2342: fnd_message.set_name('BEN','BEN_91946_MX_VAL_FLAG_RULE');
2343: fnd_message.raise_error;
2344: --
2345: elsif p_mx_cvg_rl is not null and (p_no_mx_cvg_amt_apls_flag = 'Y' or
2346: p_mx_cvg_alwd_amt is not null) then
2347: --

Line 2348: fnd_message.set_name('BEN','BEN_91946_MX_VAL_FLAG_RULE');

2344: --
2345: elsif p_mx_cvg_rl is not null and (p_no_mx_cvg_amt_apls_flag = 'Y' or
2346: p_mx_cvg_alwd_amt is not null) then
2347: --
2348: fnd_message.set_name('BEN','BEN_91946_MX_VAL_FLAG_RULE');
2349: fnd_message.raise_error;
2350: --
2351: elsif p_no_mx_cvg_amt_apls_flag = 'Y' and (p_mx_cvg_alwd_amt is not null or
2352: p_mx_cvg_rl is not null) then

Line 2349: fnd_message.raise_error;

2345: elsif p_mx_cvg_rl is not null and (p_no_mx_cvg_amt_apls_flag = 'Y' or
2346: p_mx_cvg_alwd_amt is not null) then
2347: --
2348: fnd_message.set_name('BEN','BEN_91946_MX_VAL_FLAG_RULE');
2349: fnd_message.raise_error;
2350: --
2351: elsif p_no_mx_cvg_amt_apls_flag = 'Y' and (p_mx_cvg_alwd_amt is not null or
2352: p_mx_cvg_rl is not null) then
2353: --

Line 2354: fnd_message.set_name('BEN','BEN_91946_MX_VAL_FLAG_RULE');

2350: --
2351: elsif p_no_mx_cvg_amt_apls_flag = 'Y' and (p_mx_cvg_alwd_amt is not null or
2352: p_mx_cvg_rl is not null) then
2353: --
2354: fnd_message.set_name('BEN','BEN_91946_MX_VAL_FLAG_RULE');
2355: fnd_message.raise_error;
2356: --
2357: end if;
2358: --

Line 2355: fnd_message.raise_error;

2351: elsif p_no_mx_cvg_amt_apls_flag = 'Y' and (p_mx_cvg_alwd_amt is not null or
2352: p_mx_cvg_rl is not null) then
2353: --
2354: fnd_message.set_name('BEN','BEN_91946_MX_VAL_FLAG_RULE');
2355: fnd_message.raise_error;
2356: --
2357: end if;
2358: --
2359: hr_utility.set_location('Leaving:'||l_proc,10);

Line 2437: fnd_message.set_name('BEN','BEN_91219_DFLT_ENRT_MTHD_DPNDC');

2433: if c1%found then
2434: if l_value = 'Y' and p_dflt_enrt_cd = 'A' then
2435: --
2436: close c1;
2437: fnd_message.set_name('BEN','BEN_91219_DFLT_ENRT_MTHD_DPNDC');
2438: fnd_message.raise_error;
2439: --
2440: end if;
2441: end if;

Line 2438: fnd_message.raise_error;

2434: if l_value = 'Y' and p_dflt_enrt_cd = 'A' then
2435: --
2436: close c1;
2437: fnd_message.set_name('BEN','BEN_91219_DFLT_ENRT_MTHD_DPNDC');
2438: fnd_message.raise_error;
2439: --
2440: end if;
2441: end if;
2442: close c1;

Line 2537: fnd_message.set_name('BEN','BEN_91224_DFLT_FLAG_DPNDCY');

2533: p_dflt_enrt_det_rl is not null or
2534: p_dflt_flag = 'Y' ) then -- Bug 2717870
2535: --
2536: close c1;
2537: fnd_message.set_name('BEN','BEN_91224_DFLT_FLAG_DPNDCY');
2538: fnd_message.raise_error;
2539: --
2540: end if;
2541: end if;

Line 2538: fnd_message.raise_error;

2534: p_dflt_flag = 'Y' ) then -- Bug 2717870
2535: --
2536: close c1;
2537: fnd_message.set_name('BEN','BEN_91224_DFLT_FLAG_DPNDCY');
2538: fnd_message.raise_error;
2539: --
2540: end if;
2541: end if;
2542: close c1;

Line 2608: fnd_message.set_name('BEN','BEN_91221_DFLT_FLAG_DPNDCY2');

2604: -- check dependency
2605: --
2606: if p_dflt_flag = 'Y' and p_dflt_enrt_cd is null then
2607: --
2608: fnd_message.set_name('BEN','BEN_91221_DFLT_FLAG_DPNDCY2');
2609: fnd_message.raise_error;
2610: --
2611: end if;
2612: --

Line 2609: fnd_message.raise_error;

2605: --
2606: if p_dflt_flag = 'Y' and p_dflt_enrt_cd is null then
2607: --
2608: fnd_message.set_name('BEN','BEN_91221_DFLT_FLAG_DPNDCY2');
2609: fnd_message.raise_error;
2610: --
2611: end if;
2612: --
2613: end if;

Line 2676: fnd_message.set_name('BEN','BEN_91222_DFLT_ENRT_MTHD_CWOR');

2672: or not l_api_updating) then
2673: --
2674: if (p_dflt_enrt_cd = 'RL' and p_dflt_enrt_det_rl is null) then
2675: --
2676: fnd_message.set_name('BEN','BEN_91222_DFLT_ENRT_MTHD_CWOR');
2677: fnd_message.raise_error;
2678: --
2679: end if;
2680: --

Line 2677: fnd_message.raise_error;

2673: --
2674: if (p_dflt_enrt_cd = 'RL' and p_dflt_enrt_det_rl is null) then
2675: --
2676: fnd_message.set_name('BEN','BEN_91222_DFLT_ENRT_MTHD_CWOR');
2677: fnd_message.raise_error;
2678: --
2679: end if;
2680: --
2681: if nvl(p_dflt_enrt_cd,hr_api.g_varchar2) <> 'RL' and p_dflt_enrt_det_rl is not null then

Line 2683: fnd_message.set_name('BEN','BEN_91223_DFLT_ENRT_MTHD_RWOC');

2679: end if;
2680: --
2681: if nvl(p_dflt_enrt_cd,hr_api.g_varchar2) <> 'RL' and p_dflt_enrt_det_rl is not null then
2682: --
2683: fnd_message.set_name('BEN','BEN_91223_DFLT_ENRT_MTHD_RWOC');
2684: fnd_message.raise_error;
2685: --
2686: end if;
2687: --

Line 2684: fnd_message.raise_error;

2680: --
2681: if nvl(p_dflt_enrt_cd,hr_api.g_varchar2) <> 'RL' and p_dflt_enrt_det_rl is not null then
2682: --
2683: fnd_message.set_name('BEN','BEN_91223_DFLT_ENRT_MTHD_RWOC');
2684: fnd_message.raise_error;
2685: --
2686: end if;
2687: --
2688: end if;

Line 2772: fnd_message.set_name('BEN','BEN_91763_INVK_IMPTD_FLAG_PGM');

2768: --
2769: -- Raise error as there is a different Plan with the Invoke
2770: -- Imputed Plan set to ON for this Program
2771: --
2772: fnd_message.set_name('BEN','BEN_91763_INVK_IMPTD_FLAG_PGM');
2773: fnd_message.raise_error;
2774: --
2775: --
2776: end if;

Line 2773: fnd_message.raise_error;

2769: -- Raise error as there is a different Plan with the Invoke
2770: -- Imputed Plan set to ON for this Program
2771: --
2772: fnd_message.set_name('BEN','BEN_91763_INVK_IMPTD_FLAG_PGM');
2773: fnd_message.raise_error;
2774: --
2775: --
2776: end if;
2777: end if;

Line 2872: fnd_message.set_name('BEN','BEN_93224_FLXCR_PL_NONFLX_PGM');

2868: --
2869: -- Raise error as Flex plans can only be included into
2870: -- programs that are set up as Flex Credit Programs
2871: --
2872: fnd_message.set_name('BEN','BEN_93224_FLXCR_PL_NONFLX_PGM');
2873: fnd_message.raise_error;
2874: end if;
2875: --
2876: open count_plans;

Line 2873: fnd_message.raise_error;

2869: -- Raise error as Flex plans can only be included into
2870: -- programs that are set up as Flex Credit Programs
2871: --
2872: fnd_message.set_name('BEN','BEN_93224_FLXCR_PL_NONFLX_PGM');
2873: fnd_message.raise_error;
2874: end if;
2875: --
2876: open count_plans;
2877: fetch count_plans into l_count;

Line 2884: fnd_message.set_name('BEN','BEN_91764_INVK_FLXCR_FLAG_PGM_');

2880: --
2881: -- Raise error as there is a different Plan with the Flex
2882: -- Credit Plan set to ON for this Program
2883: --
2884: fnd_message.set_name('BEN','BEN_91764_INVK_FLXCR_FLAG_PGM_');
2885: fnd_message.raise_error;
2886: --
2887: --
2888: end if;

Line 2885: fnd_message.raise_error;

2881: -- Raise error as there is a different Plan with the Flex
2882: -- Credit Plan set to ON for this Program
2883: --
2884: fnd_message.set_name('BEN','BEN_91764_INVK_FLXCR_FLAG_PGM_');
2885: fnd_message.raise_error;
2886: --
2887: --
2888: end if;
2889: end if;

Line 2975: fnd_message.set_name('BEN','BEN_91251_INV_ENRT_START_DT_RL');

2971: close c1;
2972: --
2973: -- raise error
2974: --
2975: fnd_message.set_name('BEN','BEN_91251_INV_ENRT_START_DT_RL');
2976: fnd_message.raise_error;
2977: --
2978: end if;
2979: --

Line 2976: fnd_message.raise_error;

2972: --
2973: -- raise error
2974: --
2975: fnd_message.set_name('BEN','BEN_91251_INV_ENRT_START_DT_RL');
2976: fnd_message.raise_error;
2977: --
2978: end if;
2979: --
2980: close c1;

Line 3068: fnd_message.set_name('BEN','BEN_91250_INV_ENRT_END_DT_RL');

3064: close c1;
3065: --
3066: -- raise error
3067: --
3068: fnd_message.set_name('BEN','BEN_91250_INV_ENRT_END_DT_RL');
3069: fnd_message.raise_error;
3070: --
3071: end if;
3072: --

Line 3069: fnd_message.raise_error;

3065: --
3066: -- raise error
3067: --
3068: fnd_message.set_name('BEN','BEN_91250_INV_ENRT_END_DT_RL');
3069: fnd_message.raise_error;
3070: --
3071: end if;
3072: --
3073: close c1;

Line 3140: fnd_message.set_name('BEN','BEN_91300_INV_ENRT_STRT_DT_CD');

3136: p_effective_date => p_effective_date) then
3137: --
3138: -- raise error as does not exist as lookup
3139: --
3140: fnd_message.set_name('BEN','BEN_91300_INV_ENRT_STRT_DT_CD');
3141: fnd_message.raise_error;
3142: --
3143: end if;
3144: end if;

Line 3141: fnd_message.raise_error;

3137: --
3138: -- raise error as does not exist as lookup
3139: --
3140: fnd_message.set_name('BEN','BEN_91300_INV_ENRT_STRT_DT_CD');
3141: fnd_message.raise_error;
3142: --
3143: end if;
3144: end if;
3145: --

Line 3211: fnd_message.set_name('BEN','BEN_91301_INV_ENRT_END_DT_CD');

3207: p_effective_date => p_effective_date) then
3208: --
3209: -- raise error as does not exist as lookup
3210: --
3211: fnd_message.set_name('BEN','BEN_91301_INV_ENRT_END_DT_CD');
3212: fnd_message.raise_error;
3213: --
3214: end if;
3215: end if;

Line 3212: fnd_message.raise_error;

3208: --
3209: -- raise error as does not exist as lookup
3210: --
3211: fnd_message.set_name('BEN','BEN_91301_INV_ENRT_END_DT_CD');
3212: fnd_message.raise_error;
3213: --
3214: end if;
3215: end if;
3216: --

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

3299: close c1;
3300: --
3301: -- raise error
3302: --
3303: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
3304: fnd_message.set_token('ID',p_rt_strt_dt_rl);
3305: fnd_message.set_token('TYPE_ID',-66);
3306: fnd_message.raise_error;
3307: --

Line 3304: fnd_message.set_token('ID',p_rt_strt_dt_rl);

3300: --
3301: -- raise error
3302: --
3303: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
3304: fnd_message.set_token('ID',p_rt_strt_dt_rl);
3305: fnd_message.set_token('TYPE_ID',-66);
3306: fnd_message.raise_error;
3307: --
3308: end if;

Line 3305: fnd_message.set_token('TYPE_ID',-66);

3301: -- raise error
3302: --
3303: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
3304: fnd_message.set_token('ID',p_rt_strt_dt_rl);
3305: fnd_message.set_token('TYPE_ID',-66);
3306: fnd_message.raise_error;
3307: --
3308: end if;
3309: --

Line 3306: fnd_message.raise_error;

3302: --
3303: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
3304: fnd_message.set_token('ID',p_rt_strt_dt_rl);
3305: fnd_message.set_token('TYPE_ID',-66);
3306: fnd_message.raise_error;
3307: --
3308: end if;
3309: --
3310: close c1;

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

3372: p_effective_date => p_effective_date) then
3373: --
3374: -- raise error as does not exist as lookup
3375: --
3376: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3377: fnd_message.set_token('FIELD','p_rt_strt_dt_cd');
3378: fnd_message.set_token('TYPE','BEN_RT_STRT');
3379: fnd_message.raise_error;
3380: --

Line 3377: fnd_message.set_token('FIELD','p_rt_strt_dt_cd');

3373: --
3374: -- raise error as does not exist as lookup
3375: --
3376: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3377: fnd_message.set_token('FIELD','p_rt_strt_dt_cd');
3378: fnd_message.set_token('TYPE','BEN_RT_STRT');
3379: fnd_message.raise_error;
3380: --
3381: end if;

Line 3378: fnd_message.set_token('TYPE','BEN_RT_STRT');

3374: -- raise error as does not exist as lookup
3375: --
3376: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3377: fnd_message.set_token('FIELD','p_rt_strt_dt_cd');
3378: fnd_message.set_token('TYPE','BEN_RT_STRT');
3379: fnd_message.raise_error;
3380: --
3381: end if;
3382: --

Line 3379: fnd_message.raise_error;

3375: --
3376: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3377: fnd_message.set_token('FIELD','p_rt_strt_dt_cd');
3378: fnd_message.set_token('TYPE','BEN_RT_STRT');
3379: fnd_message.raise_error;
3380: --
3381: end if;
3382: --
3383: end if;

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

3465: close c1;
3466: --
3467: -- raise error
3468: --
3469: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
3470: fnd_message.set_token('ID',p_rt_end_dt_rl);
3471: fnd_message.set_token('TYPE_ID',-67);
3472: fnd_message.raise_error;
3473: --

Line 3470: fnd_message.set_token('ID',p_rt_end_dt_rl);

3466: --
3467: -- raise error
3468: --
3469: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
3470: fnd_message.set_token('ID',p_rt_end_dt_rl);
3471: fnd_message.set_token('TYPE_ID',-67);
3472: fnd_message.raise_error;
3473: --
3474: end if;

Line 3471: fnd_message.set_token('TYPE_ID',-67);

3467: -- raise error
3468: --
3469: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
3470: fnd_message.set_token('ID',p_rt_end_dt_rl);
3471: fnd_message.set_token('TYPE_ID',-67);
3472: fnd_message.raise_error;
3473: --
3474: end if;
3475: --

Line 3472: fnd_message.raise_error;

3468: --
3469: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
3470: fnd_message.set_token('ID',p_rt_end_dt_rl);
3471: fnd_message.set_token('TYPE_ID',-67);
3472: fnd_message.raise_error;
3473: --
3474: end if;
3475: --
3476: close c1;

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

3560: close c1;
3561: --
3562: -- raise error
3563: --
3564: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
3565: fnd_message.set_token('ID',p_postelcn_edit_rl);
3566: fnd_message.set_token('TYPE_ID',-215);
3567: fnd_message.raise_error;
3568: --

Line 3565: fnd_message.set_token('ID',p_postelcn_edit_rl);

3561: --
3562: -- raise error
3563: --
3564: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
3565: fnd_message.set_token('ID',p_postelcn_edit_rl);
3566: fnd_message.set_token('TYPE_ID',-215);
3567: fnd_message.raise_error;
3568: --
3569: end if;

Line 3566: fnd_message.set_token('TYPE_ID',-215);

3562: -- raise error
3563: --
3564: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
3565: fnd_message.set_token('ID',p_postelcn_edit_rl);
3566: fnd_message.set_token('TYPE_ID',-215);
3567: fnd_message.raise_error;
3568: --
3569: end if;
3570: --

Line 3567: fnd_message.raise_error;

3563: --
3564: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
3565: fnd_message.set_token('ID',p_postelcn_edit_rl);
3566: fnd_message.set_token('TYPE_ID',-215);
3567: fnd_message.raise_error;
3568: --
3569: end if;
3570: --
3571: close c1;

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

3633: p_effective_date => p_effective_date) then
3634: --
3635: -- raise error as does not exist as lookup
3636: --
3637: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3638: fnd_message.set_token('FIELD','p_rt_end_dt_cd');
3639: fnd_message.set_token('TYPE','BEN_RT_END');
3640: fnd_message.raise_error;
3641: --

Line 3638: fnd_message.set_token('FIELD','p_rt_end_dt_cd');

3634: --
3635: -- raise error as does not exist as lookup
3636: --
3637: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3638: fnd_message.set_token('FIELD','p_rt_end_dt_cd');
3639: fnd_message.set_token('TYPE','BEN_RT_END');
3640: fnd_message.raise_error;
3641: --
3642: end if;

Line 3639: fnd_message.set_token('TYPE','BEN_RT_END');

3635: -- raise error as does not exist as lookup
3636: --
3637: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3638: fnd_message.set_token('FIELD','p_rt_end_dt_cd');
3639: fnd_message.set_token('TYPE','BEN_RT_END');
3640: fnd_message.raise_error;
3641: --
3642: end if;
3643: --

Line 3640: fnd_message.raise_error;

3636: --
3637: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3638: fnd_message.set_token('FIELD','p_rt_end_dt_cd');
3639: fnd_message.set_token('TYPE','BEN_RT_END');
3640: fnd_message.raise_error;
3641: --
3642: end if;
3643: --
3644: end if;

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

3704: p_effective_date => p_effective_date) then
3705: --
3706: -- raise error as does not exist as lookup
3707: --
3708: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3709: fnd_message.set_token('FIELD', 'p_drvbl_fctr_apls_rts_flag');
3710: fnd_message.set_token('TYPE', 'YES_NO');
3711: fnd_message.raise_error;
3712: --

Line 3709: fnd_message.set_token('FIELD', 'p_drvbl_fctr_apls_rts_flag');

3705: --
3706: -- raise error as does not exist as lookup
3707: --
3708: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3709: fnd_message.set_token('FIELD', 'p_drvbl_fctr_apls_rts_flag');
3710: fnd_message.set_token('TYPE', 'YES_NO');
3711: fnd_message.raise_error;
3712: --
3713: end if;

Line 3710: fnd_message.set_token('TYPE', 'YES_NO');

3706: -- raise error as does not exist as lookup
3707: --
3708: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3709: fnd_message.set_token('FIELD', 'p_drvbl_fctr_apls_rts_flag');
3710: fnd_message.set_token('TYPE', 'YES_NO');
3711: fnd_message.raise_error;
3712: --
3713: end if;
3714: --

Line 3711: fnd_message.raise_error;

3707: --
3708: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3709: fnd_message.set_token('FIELD', 'p_drvbl_fctr_apls_rts_flag');
3710: fnd_message.set_token('TYPE', 'YES_NO');
3711: fnd_message.raise_error;
3712: --
3713: end if;
3714: --
3715: end if;

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

3774: p_effective_date => p_effective_date) then
3775: --
3776: -- raise error as does not exist as lookup
3777: --
3778: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3779: fnd_message.set_token('FIELD', 'p_drvbl_fctr_prtn_elig_flag');
3780: fnd_message.set_token('TYPE', 'YES_NO');
3781: fnd_message.raise_error;
3782: --

Line 3779: fnd_message.set_token('FIELD', 'p_drvbl_fctr_prtn_elig_flag');

3775: --
3776: -- raise error as does not exist as lookup
3777: --
3778: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3779: fnd_message.set_token('FIELD', 'p_drvbl_fctr_prtn_elig_flag');
3780: fnd_message.set_token('TYPE', 'YES_NO');
3781: fnd_message.raise_error;
3782: --
3783: end if;

Line 3780: fnd_message.set_token('TYPE', 'YES_NO');

3776: -- raise error as does not exist as lookup
3777: --
3778: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3779: fnd_message.set_token('FIELD', 'p_drvbl_fctr_prtn_elig_flag');
3780: fnd_message.set_token('TYPE', 'YES_NO');
3781: fnd_message.raise_error;
3782: --
3783: end if;
3784: --

Line 3781: fnd_message.raise_error;

3777: --
3778: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3779: fnd_message.set_token('FIELD', 'p_drvbl_fctr_prtn_elig_flag');
3780: fnd_message.set_token('TYPE', 'YES_NO');
3781: fnd_message.raise_error;
3782: --
3783: end if;
3784: --
3785: end if;

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

3845: p_effective_date => p_effective_date) then
3846: --
3847: -- raise error as does not exist as lookup
3848: --
3849: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3850: fnd_message.set_token('FIELD', 'p_elig_apls_flag');
3851: fnd_message.set_token('TYPE', 'YES_NO');
3852: fnd_message.raise_error;
3853: --

Line 3850: fnd_message.set_token('FIELD', 'p_elig_apls_flag');

3846: --
3847: -- raise error as does not exist as lookup
3848: --
3849: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3850: fnd_message.set_token('FIELD', 'p_elig_apls_flag');
3851: fnd_message.set_token('TYPE', 'YES_NO');
3852: fnd_message.raise_error;
3853: --
3854: end if;

Line 3851: fnd_message.set_token('TYPE', 'YES_NO');

3847: -- raise error as does not exist as lookup
3848: --
3849: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3850: fnd_message.set_token('FIELD', 'p_elig_apls_flag');
3851: fnd_message.set_token('TYPE', 'YES_NO');
3852: fnd_message.raise_error;
3853: --
3854: end if;
3855: --

Line 3852: fnd_message.raise_error;

3848: --
3849: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3850: fnd_message.set_token('FIELD', 'p_elig_apls_flag');
3851: fnd_message.set_token('TYPE', 'YES_NO');
3852: fnd_message.raise_error;
3853: --
3854: end if;
3855: --
3856: end if;

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

3917: p_effective_date => p_effective_date) then
3918: --
3919: -- raise error as does not exist as lookup
3920: --
3921: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3922: fnd_message.set_token('FIELD', 'p_prtn_elig_ovrid_alwd_flag');
3923: fnd_message.set_token('TYPE', 'YES_NO');
3924: fnd_message.raise_error;
3925: --

Line 3922: fnd_message.set_token('FIELD', 'p_prtn_elig_ovrid_alwd_flag');

3918: --
3919: -- raise error as does not exist as lookup
3920: --
3921: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3922: fnd_message.set_token('FIELD', 'p_prtn_elig_ovrid_alwd_flag');
3923: fnd_message.set_token('TYPE', 'YES_NO');
3924: fnd_message.raise_error;
3925: --
3926: end if;

Line 3923: fnd_message.set_token('TYPE', 'YES_NO');

3919: -- raise error as does not exist as lookup
3920: --
3921: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3922: fnd_message.set_token('FIELD', 'p_prtn_elig_ovrid_alwd_flag');
3923: fnd_message.set_token('TYPE', 'YES_NO');
3924: fnd_message.raise_error;
3925: --
3926: end if;
3927: --

Line 3924: fnd_message.raise_error;

3920: --
3921: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3922: fnd_message.set_token('FIELD', 'p_prtn_elig_ovrid_alwd_flag');
3923: fnd_message.set_token('TYPE', 'YES_NO');
3924: fnd_message.raise_error;
3925: --
3926: end if;
3927: --
3928: end if;

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

3989: p_effective_date => p_effective_date) then
3990: --
3991: -- raise error as does not exist as lookup
3992: --
3993: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3994: fnd_message.set_token('FIELD', 'p_trk_inelig_per_flag');
3995: fnd_message.set_token('TYPE', 'YES_NO');
3996: fnd_message.raise_error;
3997: --

Line 3994: fnd_message.set_token('FIELD', 'p_trk_inelig_per_flag');

3990: --
3991: -- raise error as does not exist as lookup
3992: --
3993: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3994: fnd_message.set_token('FIELD', 'p_trk_inelig_per_flag');
3995: fnd_message.set_token('TYPE', 'YES_NO');
3996: fnd_message.raise_error;
3997: --
3998: end if;

Line 3995: fnd_message.set_token('TYPE', 'YES_NO');

3991: -- raise error as does not exist as lookup
3992: --
3993: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3994: fnd_message.set_token('FIELD', 'p_trk_inelig_per_flag');
3995: fnd_message.set_token('TYPE', 'YES_NO');
3996: fnd_message.raise_error;
3997: --
3998: end if;
3999: --

Line 3996: fnd_message.raise_error;

3992: --
3993: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3994: fnd_message.set_token('FIELD', 'p_trk_inelig_per_flag');
3995: fnd_message.set_token('TYPE', 'YES_NO');
3996: fnd_message.raise_error;
3997: --
3998: end if;
3999: --
4000: end if;

Line 4080: fnd_message.set_name('BEN', 'BEN_93113_CD_CANNOT_NEXTLOWER');

4076: if c1%found then
4077: --
4078: close c1;
4079: hr_utility.set_location(l_proc, 35);
4080: fnd_message.set_name('BEN', 'BEN_93113_CD_CANNOT_NEXTLOWER');
4081: fnd_message.raise_error;
4082: --
4083: else
4084: --

Line 4081: fnd_message.raise_error;

4077: --
4078: close c1;
4079: hr_utility.set_location(l_proc, 35);
4080: fnd_message.set_name('BEN', 'BEN_93113_CD_CANNOT_NEXTLOWER');
4081: fnd_message.raise_error;
4082: --
4083: else
4084: --
4085: close c1;

Line 4186: fnd_message.set_name('BEN','BEN_94109_DELETE_PL_ID');

4182: if c1%found then
4183:
4184: close c1;
4185:
4186: fnd_message.set_name('BEN','BEN_94109_DELETE_PL_ID');
4187: fnd_message.raise_error;
4188:
4189: end if;
4190: close c1;

Line 4187: fnd_message.raise_error;

4183:
4184: close c1;
4185:
4186: fnd_message.set_name('BEN','BEN_94109_DELETE_PL_ID');
4187: fnd_message.raise_error;
4188:
4189: end if;
4190: close c1;
4191: hr_utility.set_location('Leaving:'||l_proc, 15);

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

4304: --
4305: -- An unhandled or unexpected error has occurred which
4306: -- we must report
4307: --
4308: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
4309: fnd_message.set_token('PROCEDURE', l_proc);
4310: fnd_message.set_token('STEP','15');
4311: fnd_message.raise_error;
4312: End dt_update_validate;

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

4305: -- An unhandled or unexpected error has occurred which
4306: -- we must report
4307: --
4308: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
4309: fnd_message.set_token('PROCEDURE', l_proc);
4310: fnd_message.set_token('STEP','15');
4311: fnd_message.raise_error;
4312: End dt_update_validate;
4313: --

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

4306: -- we must report
4307: --
4308: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
4309: fnd_message.set_token('PROCEDURE', l_proc);
4310: fnd_message.set_token('STEP','15');
4311: fnd_message.raise_error;
4312: End dt_update_validate;
4313: --
4314: -- ----------------------------------------------------------------------------

Line 4311: fnd_message.raise_error;

4307: --
4308: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
4309: fnd_message.set_token('PROCEDURE', l_proc);
4310: fnd_message.set_token('STEP','15');
4311: fnd_message.raise_error;
4312: End dt_update_validate;
4313: --
4314: -- ----------------------------------------------------------------------------
4315: -- |--------------------------< dt_delete_validate >--------------------------|

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

4423: --
4424: -- An unhandled or unexpected error has occurred which
4425: -- we must report
4426: --
4427: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
4428: fnd_message.set_token('PROCEDURE', l_proc);
4429: fnd_message.set_token('STEP','15');
4430: fnd_message.raise_error;
4431: End dt_delete_validate;

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

4424: -- An unhandled or unexpected error has occurred which
4425: -- we must report
4426: --
4427: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
4428: fnd_message.set_token('PROCEDURE', l_proc);
4429: fnd_message.set_token('STEP','15');
4430: fnd_message.raise_error;
4431: End dt_delete_validate;
4432: --

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

4425: -- we must report
4426: --
4427: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
4428: fnd_message.set_token('PROCEDURE', l_proc);
4429: fnd_message.set_token('STEP','15');
4430: fnd_message.raise_error;
4431: End dt_delete_validate;
4432: --
4433: -- ----------------------------------------------------------------------------

Line 4430: fnd_message.raise_error;

4426: --
4427: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
4428: fnd_message.set_token('PROCEDURE', l_proc);
4429: fnd_message.set_token('STEP','15');
4430: fnd_message.raise_error;
4431: End dt_delete_validate;
4432: --
4433: -- ----------------------------------------------------------------------------
4434: -- |---------------------------< insert_validate >----------------------------|

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

5279: close csr_leg_code;
5280: --
5281: -- The primary key is invalid therefore we must error
5282: --
5283: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
5284: fnd_message.raise_error;
5285: --
5286: end if;
5287: --

Line 5284: fnd_message.raise_error;

5280: --
5281: -- The primary key is invalid therefore we must error
5282: --
5283: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
5284: fnd_message.raise_error;
5285: --
5286: end if;
5287: --
5288: close csr_leg_code;