DBA Data[Home] [Help]

APPS.BEN_CTP_BUS dependencies on FND_MESSAGE

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

63: open c1;
64: fetch c1 into l_dummy;
65: if c1%found then
66: close c1;
67: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
68: fnd_message.raise_error;
69: end if;
70: close c1;
71: --

Line 68: fnd_message.raise_error;

64: fetch c1 into l_dummy;
65: if c1%found then
66: close c1;
67: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
68: fnd_message.raise_error;
69: end if;
70: close c1;
71: --
72: hr_utility.set_location('Leaving:'||l_proc, 15);

Line 128: fnd_message.set_name('BEN','BEN_91722_DUP_PL_TYP_ID_IN_PGM');

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

Line 129: fnd_message.raise_error;

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

Line 201: fnd_message.set_name('BEN','BEN_92139_PLAN_MUST_B_WAIVABLE');

197: open c1;
198: fetch c1 into l_dummy;
199: if c1%found then
200: close c1;
201: fnd_message.set_name('BEN','BEN_92139_PLAN_MUST_B_WAIVABLE');
202: fnd_message.raise_error;
203: end if;
204: close c1;
205: end if;

Line 202: fnd_message.raise_error;

198: fetch c1 into l_dummy;
199: if c1%found then
200: close c1;
201: fnd_message.set_name('BEN','BEN_92139_PLAN_MUST_B_WAIVABLE');
202: fnd_message.raise_error;
203: end if;
204: close c1;
205: end if;
206: --

Line 272: fnd_message.set_name('BEN','BEN_91380_DPNT_CVG_ST_DT_1');

268: or not l_api_updating) then
269: --
270: if (p_dt_cd = 'RL' and p_dt_rl is null) then
271: --
272: fnd_message.set_name('BEN','BEN_91380_DPNT_CVG_ST_DT_1');
273: fnd_message.raise_error;
274: --
275: end if;
276: --

Line 273: fnd_message.raise_error;

269: --
270: if (p_dt_cd = 'RL' and p_dt_rl is null) then
271: --
272: fnd_message.set_name('BEN','BEN_91380_DPNT_CVG_ST_DT_1');
273: fnd_message.raise_error;
274: --
275: end if;
276: --
277: if nvl(p_dt_cd,hr_api.g_varchar2) <> 'RL'

Line 280: fnd_message.set_name('BEN','BEN_91381_DPNT_CVG_ST_DT_2');

276: --
277: if nvl(p_dt_cd,hr_api.g_varchar2) <> 'RL'
278: and p_dt_rl is not null then
279: --
280: fnd_message.set_name('BEN','BEN_91381_DPNT_CVG_ST_DT_2');
281: fnd_message.raise_error;
282: --
283: end if;
284: --

Line 281: fnd_message.raise_error;

277: if nvl(p_dt_cd,hr_api.g_varchar2) <> 'RL'
278: and p_dt_rl is not null then
279: --
280: fnd_message.set_name('BEN','BEN_91381_DPNT_CVG_ST_DT_2');
281: fnd_message.raise_error;
282: --
283: end if;
284: --
285: end if;

Line 349: fnd_message.set_name('PAY','needs a message');

345: if c1%found then
346: open c2;
347: fetch c2 into l_dummy;
348: if c2%notfound then
349: fnd_message.set_name('PAY','needs a message');
350: fnd_message.raise_error;
351: end if;
352: close c2;
353: end if;

Line 350: fnd_message.raise_error;

346: open c2;
347: fetch c2 into l_dummy;
348: if c2%notfound then
349: fnd_message.set_name('PAY','needs a message');
350: fnd_message.raise_error;
351: end if;
352: close c2;
353: end if;
354: close c1;

Line 487: fnd_message.set_name('BEN','BEN_91225_INV_RQD_ENRT_PERD_CD');

483: p_effective_date => p_effective_date) then
484: --
485: -- raise error as does not exist as lookup
486: --
487: fnd_message.set_name('BEN','BEN_91225_INV_RQD_ENRT_PERD_CD');
488: fnd_message.raise_error;
489: --
490: end if;
491: --

Line 488: fnd_message.raise_error;

484: --
485: -- raise error as does not exist as lookup
486: --
487: fnd_message.set_name('BEN','BEN_91225_INV_RQD_ENRT_PERD_CD');
488: fnd_message.raise_error;
489: --
490: end if;
491: --
492: end if;

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

530: --
531: -- raise error as does not exist as lookup
532: --
533: --
534: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
535: fnd_message.set_token('FIELD', 'p_vrfy_fmly_mmbr_cd');
536: fnd_message.set_token('TYPE','BEN_FMLY_MMBR');
537: fnd_message.raise_error;
538: --

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

531: -- raise error as does not exist as lookup
532: --
533: --
534: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
535: fnd_message.set_token('FIELD', 'p_vrfy_fmly_mmbr_cd');
536: fnd_message.set_token('TYPE','BEN_FMLY_MMBR');
537: fnd_message.raise_error;
538: --
539: end if;

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

532: --
533: --
534: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
535: fnd_message.set_token('FIELD', 'p_vrfy_fmly_mmbr_cd');
536: fnd_message.set_token('TYPE','BEN_FMLY_MMBR');
537: fnd_message.raise_error;
538: --
539: end if;
540: --

Line 537: fnd_message.raise_error;

533: --
534: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
535: fnd_message.set_token('FIELD', 'p_vrfy_fmly_mmbr_cd');
536: fnd_message.set_token('TYPE','BEN_FMLY_MMBR');
537: fnd_message.raise_error;
538: --
539: end if;
540: --
541: end if;

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

584: --
585: -- raise error
586: --
587: --
588: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
589: fnd_message.set_token('ID',p_vrfy_fmly_mmbr_rl);
590: fnd_message.set_token('TYPE_ID',-21);
591: fnd_message.raise_error;
592: --

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

585: -- raise error
586: --
587: --
588: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
589: fnd_message.set_token('ID',p_vrfy_fmly_mmbr_rl);
590: fnd_message.set_token('TYPE_ID',-21);
591: fnd_message.raise_error;
592: --
593: end if;

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

586: --
587: --
588: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
589: fnd_message.set_token('ID',p_vrfy_fmly_mmbr_rl);
590: fnd_message.set_token('TYPE_ID',-21);
591: fnd_message.raise_error;
592: --
593: end if;
594: --

Line 591: fnd_message.raise_error;

587: --
588: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
589: fnd_message.set_token('ID',p_vrfy_fmly_mmbr_rl);
590: fnd_message.set_token('TYPE_ID',-21);
591: fnd_message.raise_error;
592: --
593: end if;
594: --
595: end if;

Line 663: fnd_message.set_name('BEN','BEN_91226_INV_NO_MIN_PT_OR_FLG');

659: p_effective_date => p_effective_date) then
660: --
661: -- raise error as does not exist as lookup
662: --
663: fnd_message.set_name('BEN','BEN_91226_INV_NO_MIN_PT_OR_FLG');
664: fnd_message.raise_error;
665: --
666: end if;
667: --

Line 664: fnd_message.raise_error;

660: --
661: -- raise error as does not exist as lookup
662: --
663: fnd_message.set_name('BEN','BEN_91226_INV_NO_MIN_PT_OR_FLG');
664: fnd_message.raise_error;
665: --
666: end if;
667: --
668: end if;

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

728: p_effective_date => p_effective_date) then
729: --
730: -- raise error as does not exist as lookup
731: --
732: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
733: fnd_message.set_token('FIELD', 'p_drvbl_fctr_apls_rts_flag');
734: fnd_message.set_token('TYPE', 'YES_NO');
735: fnd_message.raise_error;
736: --

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

729: --
730: -- raise error as does not exist as lookup
731: --
732: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
733: fnd_message.set_token('FIELD', 'p_drvbl_fctr_apls_rts_flag');
734: fnd_message.set_token('TYPE', 'YES_NO');
735: fnd_message.raise_error;
736: --
737: end if;

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

730: -- raise error as does not exist as lookup
731: --
732: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
733: fnd_message.set_token('FIELD', 'p_drvbl_fctr_apls_rts_flag');
734: fnd_message.set_token('TYPE', 'YES_NO');
735: fnd_message.raise_error;
736: --
737: end if;
738: --

Line 735: fnd_message.raise_error;

731: --
732: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
733: fnd_message.set_token('FIELD', 'p_drvbl_fctr_apls_rts_flag');
734: fnd_message.set_token('TYPE', 'YES_NO');
735: fnd_message.raise_error;
736: --
737: end if;
738: --
739: end if;

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

799: p_effective_date => p_effective_date) then
800: --
801: -- raise error as does not exist as lookup
802: --
803: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
804: fnd_message.set_token('FIELD', 'p_drvbl_fctr_prtn_elig_flag');
805: fnd_message.set_token('TYPE', 'YES_NO');
806: fnd_message.raise_error;
807: --

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

800: --
801: -- raise error as does not exist as lookup
802: --
803: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
804: fnd_message.set_token('FIELD', 'p_drvbl_fctr_prtn_elig_flag');
805: fnd_message.set_token('TYPE', 'YES_NO');
806: fnd_message.raise_error;
807: --
808: end if;

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

801: -- raise error as does not exist as lookup
802: --
803: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
804: fnd_message.set_token('FIELD', 'p_drvbl_fctr_prtn_elig_flag');
805: fnd_message.set_token('TYPE', 'YES_NO');
806: fnd_message.raise_error;
807: --
808: end if;
809: --

Line 806: fnd_message.raise_error;

802: --
803: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
804: fnd_message.set_token('FIELD', 'p_drvbl_fctr_prtn_elig_flag');
805: fnd_message.set_token('TYPE', 'YES_NO');
806: fnd_message.raise_error;
807: --
808: end if;
809: --
810: end if;

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

846: hr_utility.set_location('Entering:'||l_proc, 5);
847: --
848: if ( p_vrfy_fmly_mmbr_cd <> 'RL' and p_vrfy_fmly_mmbr_rl is not null)
849: then
850: fnd_message.set_name('BEN','BEN_91730_NO_RULE');
851: fnd_message.raise_error;
852: end if;
853:
854: if ( p_vrfy_fmly_mmbr_cd = 'RL' and p_vrfy_fmly_mmbr_rl is null)

Line 851: fnd_message.raise_error;

847: --
848: if ( p_vrfy_fmly_mmbr_cd <> 'RL' and p_vrfy_fmly_mmbr_rl is not null)
849: then
850: fnd_message.set_name('BEN','BEN_91730_NO_RULE');
851: fnd_message.raise_error;
852: end if;
853:
854: if ( p_vrfy_fmly_mmbr_cd = 'RL' and p_vrfy_fmly_mmbr_rl is null)
855: then

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

852: end if;
853:
854: if ( p_vrfy_fmly_mmbr_cd = 'RL' and p_vrfy_fmly_mmbr_rl is null)
855: then
856: fnd_message.set_name('BEN','BEN_91731_RULE');
857: fnd_message.raise_error;
858: end if;
859: --
860: --leaving Procedure.

Line 857: fnd_message.raise_error;

853:
854: if ( p_vrfy_fmly_mmbr_cd = 'RL' and p_vrfy_fmly_mmbr_rl is null)
855: then
856: fnd_message.set_name('BEN','BEN_91731_RULE');
857: fnd_message.raise_error;
858: end if;
859: --
860: --leaving Procedure.
861: --

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

921: p_effective_date => p_effective_date) then
922: --
923: -- raise error as does not exist as lookup
924: --
925: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
926: fnd_message.set_token('FIELD', 'p_elig_apls_flag');
927: fnd_message.set_token('TYPE', 'YES_NO');
928: fnd_message.raise_error;
929: --

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

922: --
923: -- raise error as does not exist as lookup
924: --
925: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
926: fnd_message.set_token('FIELD', 'p_elig_apls_flag');
927: fnd_message.set_token('TYPE', 'YES_NO');
928: fnd_message.raise_error;
929: --
930: end if;

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

923: -- raise error as does not exist as lookup
924: --
925: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
926: fnd_message.set_token('FIELD', 'p_elig_apls_flag');
927: fnd_message.set_token('TYPE', 'YES_NO');
928: fnd_message.raise_error;
929: --
930: end if;
931: --

Line 928: fnd_message.raise_error;

924: --
925: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
926: fnd_message.set_token('FIELD', 'p_elig_apls_flag');
927: fnd_message.set_token('TYPE', 'YES_NO');
928: fnd_message.raise_error;
929: --
930: end if;
931: --
932: end if;

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

993: p_effective_date => p_effective_date) then
994: --
995: -- raise error as does not exist as lookup
996: --
997: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
998: fnd_message.set_token('FIELD', 'p_prtn_elig_ovrid_alwd_flag');
999: fnd_message.set_token('TYPE', 'YES_NO');
1000: fnd_message.raise_error;
1001: --

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

994: --
995: -- raise error as does not exist as lookup
996: --
997: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
998: fnd_message.set_token('FIELD', 'p_prtn_elig_ovrid_alwd_flag');
999: fnd_message.set_token('TYPE', 'YES_NO');
1000: fnd_message.raise_error;
1001: --
1002: end if;

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

995: -- raise error as does not exist as lookup
996: --
997: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
998: fnd_message.set_token('FIELD', 'p_prtn_elig_ovrid_alwd_flag');
999: fnd_message.set_token('TYPE', 'YES_NO');
1000: fnd_message.raise_error;
1001: --
1002: end if;
1003: --

Line 1000: fnd_message.raise_error;

996: --
997: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
998: fnd_message.set_token('FIELD', 'p_prtn_elig_ovrid_alwd_flag');
999: fnd_message.set_token('TYPE', 'YES_NO');
1000: fnd_message.raise_error;
1001: --
1002: end if;
1003: --
1004: end if;

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

1065: p_effective_date => p_effective_date) then
1066: --
1067: -- raise error as does not exist as lookup
1068: --
1069: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1070: fnd_message.set_token('FIELD', 'p_trk_inelig_per_flag');
1071: fnd_message.set_token('TYPE', 'YES_NO');
1072: fnd_message.raise_error;
1073: --

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

1066: --
1067: -- raise error as does not exist as lookup
1068: --
1069: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1070: fnd_message.set_token('FIELD', 'p_trk_inelig_per_flag');
1071: fnd_message.set_token('TYPE', 'YES_NO');
1072: fnd_message.raise_error;
1073: --
1074: end if;

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

1067: -- raise error as does not exist as lookup
1068: --
1069: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1070: fnd_message.set_token('FIELD', 'p_trk_inelig_per_flag');
1071: fnd_message.set_token('TYPE', 'YES_NO');
1072: fnd_message.raise_error;
1073: --
1074: end if;
1075: --

Line 1072: fnd_message.raise_error;

1068: --
1069: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1070: fnd_message.set_token('FIELD', 'p_trk_inelig_per_flag');
1071: fnd_message.set_token('TYPE', 'YES_NO');
1072: fnd_message.raise_error;
1073: --
1074: end if;
1075: --
1076: end if;

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

1136: p_effective_date => p_effective_date) then
1137: --
1138: -- raise error as does not exist as lookup
1139: --
1140: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1141: fnd_message.set_token('FIELD', 'p_sbj_to_sps_lf_ins_mx_flag');
1142: fnd_message.set_token('TYPE', 'YES_NO');
1143: fnd_message.raise_error;
1144: --

Line 1141: fnd_message.set_token('FIELD', 'p_sbj_to_sps_lf_ins_mx_flag');

1137: --
1138: -- raise error as does not exist as lookup
1139: --
1140: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1141: fnd_message.set_token('FIELD', 'p_sbj_to_sps_lf_ins_mx_flag');
1142: fnd_message.set_token('TYPE', 'YES_NO');
1143: fnd_message.raise_error;
1144: --
1145: end if;

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

1138: -- raise error as does not exist as lookup
1139: --
1140: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1141: fnd_message.set_token('FIELD', 'p_sbj_to_sps_lf_ins_mx_flag');
1142: fnd_message.set_token('TYPE', 'YES_NO');
1143: fnd_message.raise_error;
1144: --
1145: end if;
1146: --

Line 1143: fnd_message.raise_error;

1139: --
1140: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1141: fnd_message.set_token('FIELD', 'p_sbj_to_sps_lf_ins_mx_flag');
1142: fnd_message.set_token('TYPE', 'YES_NO');
1143: fnd_message.raise_error;
1144: --
1145: end if;
1146: --
1147: end if;

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

1207: p_effective_date => p_effective_date) then
1208: --
1209: -- raise error as does not exist as lookup
1210: --
1211: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1212: fnd_message.set_token('FIELD', 'p_sbj_to_dpnt_lf_ins_mx_flag');
1213: fnd_message.set_token('TYPE', 'YES_NO');
1214: fnd_message.raise_error;
1215: --

Line 1212: fnd_message.set_token('FIELD', 'p_sbj_to_dpnt_lf_ins_mx_flag');

1208: --
1209: -- raise error as does not exist as lookup
1210: --
1211: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1212: fnd_message.set_token('FIELD', 'p_sbj_to_dpnt_lf_ins_mx_flag');
1213: fnd_message.set_token('TYPE', 'YES_NO');
1214: fnd_message.raise_error;
1215: --
1216: end if;

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

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

Line 1214: fnd_message.raise_error;

1210: --
1211: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1212: fnd_message.set_token('FIELD', 'p_sbj_to_dpnt_lf_ins_mx_flag');
1213: fnd_message.set_token('TYPE', 'YES_NO');
1214: fnd_message.raise_error;
1215: --
1216: end if;
1217: --
1218: end if;

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

1278: p_effective_date => p_effective_date) then
1279: --
1280: -- raise error as does not exist as lookup
1281: --
1282: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1283: fnd_message.set_token('FIELD', 'p_use_to_sum_ee_lf_ins_flag');
1284: fnd_message.set_token('TYPE', 'YES_NO');
1285: fnd_message.raise_error;
1286: --

Line 1283: fnd_message.set_token('FIELD', 'p_use_to_sum_ee_lf_ins_flag');

1279: --
1280: -- raise error as does not exist as lookup
1281: --
1282: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1283: fnd_message.set_token('FIELD', 'p_use_to_sum_ee_lf_ins_flag');
1284: fnd_message.set_token('TYPE', 'YES_NO');
1285: fnd_message.raise_error;
1286: --
1287: end if;

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

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

Line 1285: fnd_message.raise_error;

1281: --
1282: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1283: fnd_message.set_token('FIELD', 'p_use_to_sum_ee_lf_ins_flag');
1284: fnd_message.set_token('TYPE', 'YES_NO');
1285: fnd_message.raise_error;
1286: --
1287: end if;
1288: --
1289: end if;

Line 1353: fnd_message.set_name('BEN','BEN_91228_INV_DRV_FCT_DPNT_FLG');

1349: p_effective_date => p_effective_date) then
1350: --
1351: -- raise error as does not exist as lookup
1352: --
1353: fnd_message.set_name('BEN','BEN_91228_INV_DRV_FCT_DPNT_FLG');
1354: fnd_message.raise_error;
1355: --
1356: end if;
1357: --

Line 1354: fnd_message.raise_error;

1350: --
1351: -- raise error as does not exist as lookup
1352: --
1353: fnd_message.set_name('BEN','BEN_91228_INV_DRV_FCT_DPNT_FLG');
1354: fnd_message.raise_error;
1355: --
1356: end if;
1357: --
1358: end if;

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

1418: p_effective_date => p_effective_date) then
1419: --
1420: -- raise error as does not exist as lookup
1421: --
1422: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1423: fnd_message.set_token('FIELD', 'p_dpnt_dob_rqd_flag');
1424: fnd_message.set_token('TYPE', 'YES_NO');
1425: fnd_message.raise_error;
1426: --

Line 1423: fnd_message.set_token('FIELD', 'p_dpnt_dob_rqd_flag');

1419: --
1420: -- raise error as does not exist as lookup
1421: --
1422: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1423: fnd_message.set_token('FIELD', 'p_dpnt_dob_rqd_flag');
1424: fnd_message.set_token('TYPE', 'YES_NO');
1425: fnd_message.raise_error;
1426: --
1427: end if;

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

1420: -- raise error as does not exist as lookup
1421: --
1422: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1423: fnd_message.set_token('FIELD', 'p_dpnt_dob_rqd_flag');
1424: fnd_message.set_token('TYPE', 'YES_NO');
1425: fnd_message.raise_error;
1426: --
1427: end if;
1428: --

Line 1425: fnd_message.raise_error;

1421: --
1422: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1423: fnd_message.set_token('FIELD', 'p_dpnt_dob_rqd_flag');
1424: fnd_message.set_token('TYPE', 'YES_NO');
1425: fnd_message.raise_error;
1426: --
1427: end if;
1428: --
1429: end if;

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

1490: p_effective_date => p_effective_date) then
1491: --
1492: -- raise error as does not exist as lookup
1493: --
1494: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1495: fnd_message.set_token('FIELD', 'p_dpnt_legv_id_rqd_flag');
1496: fnd_message.set_token('TYPE', 'YES_NO');
1497: fnd_message.raise_error;
1498: --

Line 1495: fnd_message.set_token('FIELD', 'p_dpnt_legv_id_rqd_flag');

1491: --
1492: -- raise error as does not exist as lookup
1493: --
1494: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1495: fnd_message.set_token('FIELD', 'p_dpnt_legv_id_rqd_flag');
1496: fnd_message.set_token('TYPE', 'YES_NO');
1497: fnd_message.raise_error;
1498: --
1499: end if;

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

1492: -- raise error as does not exist as lookup
1493: --
1494: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1495: fnd_message.set_token('FIELD', 'p_dpnt_legv_id_rqd_flag');
1496: fnd_message.set_token('TYPE', 'YES_NO');
1497: fnd_message.raise_error;
1498: --
1499: end if;
1500: --

Line 1497: fnd_message.raise_error;

1493: --
1494: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1495: fnd_message.set_token('FIELD', 'p_dpnt_legv_id_rqd_flag');
1496: fnd_message.set_token('TYPE', 'YES_NO');
1497: fnd_message.raise_error;
1498: --
1499: end if;
1500: --
1501: end if;

Line 1565: fnd_message.set_name('BEN','BEN_91229_INV_WVBL_FLAG');

1561: p_effective_date => p_effective_date) then
1562: --
1563: -- raise error as does not exist as lookup
1564: --
1565: fnd_message.set_name('BEN','BEN_91229_INV_WVBL_FLAG');
1566: fnd_message.raise_error;
1567: --
1568: end if;
1569: --

Line 1566: fnd_message.raise_error;

1562: --
1563: -- raise error as does not exist as lookup
1564: --
1565: fnd_message.set_name('BEN','BEN_91229_INV_WVBL_FLAG');
1566: fnd_message.raise_error;
1567: --
1568: end if;
1569: --
1570: end if;

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

1630: p_effective_date => p_effective_date) then
1631: --
1632: -- raise error as does not exist as lookup
1633: --
1634: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1635: fnd_message.set_token('FIELD', 'p_dpnt_adrs_rqd_flag');
1636: fnd_message.set_token('TYPE', 'YES_NO');
1637: fnd_message.raise_error;
1638: --

Line 1635: fnd_message.set_token('FIELD', 'p_dpnt_adrs_rqd_flag');

1631: --
1632: -- raise error as does not exist as lookup
1633: --
1634: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1635: fnd_message.set_token('FIELD', 'p_dpnt_adrs_rqd_flag');
1636: fnd_message.set_token('TYPE', 'YES_NO');
1637: fnd_message.raise_error;
1638: --
1639: end if;

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

1632: -- raise error as does not exist as lookup
1633: --
1634: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1635: fnd_message.set_token('FIELD', 'p_dpnt_adrs_rqd_flag');
1636: fnd_message.set_token('TYPE', 'YES_NO');
1637: fnd_message.raise_error;
1638: --
1639: end if;
1640: --

Line 1637: fnd_message.raise_error;

1633: --
1634: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1635: fnd_message.set_token('FIELD', 'p_dpnt_adrs_rqd_flag');
1636: fnd_message.set_token('TYPE', 'YES_NO');
1637: fnd_message.raise_error;
1638: --
1639: end if;
1640: --
1641: end if;

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

1702: p_effective_date => p_effective_date) then
1703: --
1704: -- raise error as does not exist as lookup
1705: --
1706: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1707: fnd_message.set_token('FIELD', 'p_dpnt_cvg_no_ctfn_rqd_flag');
1708: fnd_message.set_token('TYPE', 'YES_NO');
1709: fnd_message.raise_error;
1710: --

Line 1707: fnd_message.set_token('FIELD', 'p_dpnt_cvg_no_ctfn_rqd_flag');

1703: --
1704: -- raise error as does not exist as lookup
1705: --
1706: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1707: fnd_message.set_token('FIELD', 'p_dpnt_cvg_no_ctfn_rqd_flag');
1708: fnd_message.set_token('TYPE', 'YES_NO');
1709: fnd_message.raise_error;
1710: --
1711: end if;

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

1704: -- raise error as does not exist as lookup
1705: --
1706: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1707: fnd_message.set_token('FIELD', 'p_dpnt_cvg_no_ctfn_rqd_flag');
1708: fnd_message.set_token('TYPE', 'YES_NO');
1709: fnd_message.raise_error;
1710: --
1711: end if;
1712: --

Line 1709: fnd_message.raise_error;

1705: --
1706: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1707: fnd_message.set_token('FIELD', 'p_dpnt_cvg_no_ctfn_rqd_flag');
1708: fnd_message.set_token('TYPE', 'YES_NO');
1709: fnd_message.raise_error;
1710: --
1711: end if;
1712: --
1713: end if;

Line 1777: fnd_message.set_name('BEN','BEN_91230_INV_RQD_PRD_ENRT_UOM');

1773: p_effective_date => p_effective_date) then
1774: --
1775: -- raise error as does not exist as lookup
1776: --
1777: fnd_message.set_name('BEN','BEN_91230_INV_RQD_PRD_ENRT_UOM');
1778: fnd_message.raise_error;
1779: --
1780: end if;
1781: --

Line 1778: fnd_message.raise_error;

1774: --
1775: -- raise error as does not exist as lookup
1776: --
1777: fnd_message.set_name('BEN','BEN_91230_INV_RQD_PRD_ENRT_UOM');
1778: fnd_message.raise_error;
1779: --
1780: end if;
1781: --
1782: end if;

Line 1846: fnd_message.set_name('BEN','BEN_91231_INV_PRVDS_CR_FLAG');

1842: p_effective_date => p_effective_date) then
1843: --
1844: -- raise error as does not exist as lookup
1845: --
1846: fnd_message.set_name('BEN','BEN_91231_INV_PRVDS_CR_FLAG');
1847: fnd_message.raise_error;
1848: --
1849: end if;
1850: --

Line 1847: fnd_message.raise_error;

1843: --
1844: -- raise error as does not exist as lookup
1845: --
1846: fnd_message.set_name('BEN','BEN_91231_INV_PRVDS_CR_FLAG');
1847: fnd_message.raise_error;
1848: --
1849: end if;
1850: --
1851: end if;

Line 1915: fnd_message.set_name('BEN','BEN_91232_INV_NO_MAX_PT_OR_FLG');

1911: p_effective_date => p_effective_date) then
1912: --
1913: -- raise error as does not exist as lookup
1914: --
1915: fnd_message.set_name('BEN','BEN_91232_INV_NO_MAX_PT_OR_FLG');
1916: fnd_message.raise_error;
1917: --
1918: end if;
1919: --

Line 1916: fnd_message.raise_error;

1912: --
1913: -- raise error as does not exist as lookup
1914: --
1915: fnd_message.set_name('BEN','BEN_91232_INV_NO_MAX_PT_OR_FLG');
1916: fnd_message.raise_error;
1917: --
1918: end if;
1919: --
1920: end if;

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

1980: p_effective_date => p_effective_date) then
1981: --
1982: -- raise error as does not exist as lookup
1983: --
1984: fnd_message.set_name('BEN','BEN_91217_INVLD_STAT_CD');
1985: fnd_message.raise_error;
1986: --
1987: end if;
1988: --

Line 1985: fnd_message.raise_error;

1981: --
1982: -- raise error as does not exist as lookup
1983: --
1984: fnd_message.set_name('BEN','BEN_91217_INVLD_STAT_CD');
1985: fnd_message.raise_error;
1986: --
1987: end if;
1988: --
1989: end if;

Line 2054: fnd_message.set_name('BEN','BEN_91235_INV_CRS_THIS_PT_FLAG');

2050: p_effective_date => p_effective_date) then
2051: --
2052: -- raise error as does not exist as lookup
2053: --
2054: fnd_message.set_name('BEN','BEN_91235_INV_CRS_THIS_PT_FLAG');
2055: fnd_message.raise_error;
2056: --
2057: end if;
2058: --

Line 2055: fnd_message.raise_error;

2051: --
2052: -- raise error as does not exist as lookup
2053: --
2054: fnd_message.set_name('BEN','BEN_91235_INV_CRS_THIS_PT_FLAG');
2055: fnd_message.raise_error;
2056: --
2057: end if;
2058: --
2059: end if;

Line 2129: fnd_message.set_name('BEN','BEN_91236_INV_DPNT_DSGN_CD');

2125: p_effective_date => p_effective_date) then
2126: --
2127: -- raise error as does not exist as lookup
2128: --
2129: fnd_message.set_name('BEN','BEN_91236_INV_DPNT_DSGN_CD');
2130: fnd_message.raise_error;
2131: --
2132: end if;
2133: end if;

Line 2130: fnd_message.raise_error;

2126: --
2127: -- raise error as does not exist as lookup
2128: --
2129: fnd_message.set_name('BEN','BEN_91236_INV_DPNT_DSGN_CD');
2130: fnd_message.raise_error;
2131: --
2132: end if;
2133: end if;
2134: --

Line 2141: fnd_message.set_name('BEN','BEN_92512_DPNDNT_CVRG_DT_RQD');

2137:
2138: if ( p_dpnt_dsgn_cd is not null) and
2139: (p_dpnt_cvg_strt_dt_cd is null or p_dpnt_cvg_end_dt_cd is null) then
2140:
2141: fnd_message.set_name('BEN','BEN_92512_DPNDNT_CVRG_DT_RQD');
2142: fnd_message.raise_error;
2143: end if;
2144:
2145: --

Line 2142: fnd_message.raise_error;

2138: if ( p_dpnt_dsgn_cd is not null) and
2139: (p_dpnt_cvg_strt_dt_cd is null or p_dpnt_cvg_end_dt_cd is null) then
2140:
2141: fnd_message.set_name('BEN','BEN_92512_DPNDNT_CVRG_DT_RQD');
2142: fnd_message.raise_error;
2143: end if;
2144:
2145: --
2146: hr_utility.set_location('Leaving:'||l_proc,10);

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

2227: close c1;
2228: --
2229: -- raise error
2230: --
2231: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
2232: fnd_message.set_token('ID',p_postelcn_edit_rl);
2233: fnd_message.set_token('TYPE_ID',-215);
2234: fnd_message.raise_error;
2235: --

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

2228: --
2229: -- raise error
2230: --
2231: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
2232: fnd_message.set_token('ID',p_postelcn_edit_rl);
2233: fnd_message.set_token('TYPE_ID',-215);
2234: fnd_message.raise_error;
2235: --
2236: end if;

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

2229: -- raise error
2230: --
2231: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
2232: fnd_message.set_token('ID',p_postelcn_edit_rl);
2233: fnd_message.set_token('TYPE_ID',-215);
2234: fnd_message.raise_error;
2235: --
2236: end if;
2237: --

Line 2234: fnd_message.raise_error;

2230: --
2231: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
2232: fnd_message.set_token('ID',p_postelcn_edit_rl);
2233: fnd_message.set_token('TYPE_ID',-215);
2234: fnd_message.raise_error;
2235: --
2236: end if;
2237: --
2238: close c1;

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

2323: close c1;
2324: --
2325: -- raise error
2326: --
2327: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
2328: fnd_message.set_token('ID',p_rt_end_dt_rl);
2329: fnd_message.set_token('TYPE_ID',-67);
2330: fnd_message.raise_error;
2331: --

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

2324: --
2325: -- raise error
2326: --
2327: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
2328: fnd_message.set_token('ID',p_rt_end_dt_rl);
2329: fnd_message.set_token('TYPE_ID',-67);
2330: fnd_message.raise_error;
2331: --
2332: end if;

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

2325: -- raise error
2326: --
2327: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
2328: fnd_message.set_token('ID',p_rt_end_dt_rl);
2329: fnd_message.set_token('TYPE_ID',-67);
2330: fnd_message.raise_error;
2331: --
2332: end if;
2333: --

Line 2330: fnd_message.raise_error;

2326: --
2327: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
2328: fnd_message.set_token('ID',p_rt_end_dt_rl);
2329: fnd_message.set_token('TYPE_ID',-67);
2330: fnd_message.raise_error;
2331: --
2332: end if;
2333: --
2334: close c1;

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

2420: close c1;
2421: --
2422: -- raise error
2423: --
2424: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
2425: fnd_message.set_token('ID',p_rt_strt_dt_rl);
2426: fnd_message.set_token('TYPE_ID',-66);
2427: fnd_message.raise_error;
2428: --

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

2421: --
2422: -- raise error
2423: --
2424: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
2425: fnd_message.set_token('ID',p_rt_strt_dt_rl);
2426: fnd_message.set_token('TYPE_ID',-66);
2427: fnd_message.raise_error;
2428: --
2429: end if;

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

2422: -- raise error
2423: --
2424: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
2425: fnd_message.set_token('ID',p_rt_strt_dt_rl);
2426: fnd_message.set_token('TYPE_ID',-66);
2427: fnd_message.raise_error;
2428: --
2429: end if;
2430: --

Line 2427: fnd_message.raise_error;

2423: --
2424: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
2425: fnd_message.set_token('ID',p_rt_strt_dt_rl);
2426: fnd_message.set_token('TYPE_ID',-66);
2427: fnd_message.raise_error;
2428: --
2429: end if;
2430: --
2431: close c1;

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

2516: close c1;
2517: --
2518: -- raise error
2519: --
2520: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
2521: fnd_message.set_token('ID',p_enrt_cvg_end_dt_rl);
2522: fnd_message.set_token('TYPE_ID',-30);
2523: fnd_message.raise_error;
2524: --

Line 2521: fnd_message.set_token('ID',p_enrt_cvg_end_dt_rl);

2517: --
2518: -- raise error
2519: --
2520: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
2521: fnd_message.set_token('ID',p_enrt_cvg_end_dt_rl);
2522: fnd_message.set_token('TYPE_ID',-30);
2523: fnd_message.raise_error;
2524: --
2525: end if;

Line 2522: fnd_message.set_token('TYPE_ID',-30);

2518: -- raise error
2519: --
2520: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
2521: fnd_message.set_token('ID',p_enrt_cvg_end_dt_rl);
2522: fnd_message.set_token('TYPE_ID',-30);
2523: fnd_message.raise_error;
2524: --
2525: end if;
2526: --

Line 2523: fnd_message.raise_error;

2519: --
2520: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
2521: fnd_message.set_token('ID',p_enrt_cvg_end_dt_rl);
2522: fnd_message.set_token('TYPE_ID',-30);
2523: fnd_message.raise_error;
2524: --
2525: end if;
2526: --
2527: close c1;

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

2612: close c1;
2613: --
2614: -- raise error
2615: --
2616: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
2617: fnd_message.set_token('ID',p_enrt_cvg_strt_dt_rl);
2618: fnd_message.set_token('TYPE_ID',-29);
2619: fnd_message.raise_error;
2620: --

Line 2617: fnd_message.set_token('ID',p_enrt_cvg_strt_dt_rl);

2613: --
2614: -- raise error
2615: --
2616: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
2617: fnd_message.set_token('ID',p_enrt_cvg_strt_dt_rl);
2618: fnd_message.set_token('TYPE_ID',-29);
2619: fnd_message.raise_error;
2620: --
2621: end if;

Line 2618: fnd_message.set_token('TYPE_ID',-29);

2614: -- raise error
2615: --
2616: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
2617: fnd_message.set_token('ID',p_enrt_cvg_strt_dt_rl);
2618: fnd_message.set_token('TYPE_ID',-29);
2619: fnd_message.raise_error;
2620: --
2621: end if;
2622: --

Line 2619: fnd_message.raise_error;

2615: --
2616: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
2617: fnd_message.set_token('ID',p_enrt_cvg_strt_dt_rl);
2618: fnd_message.set_token('TYPE_ID',-29);
2619: fnd_message.raise_error;
2620: --
2621: end if;
2622: --
2623: close c1;

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

2709: close c1;
2710: --
2711: -- raise error
2712: --
2713: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
2714: fnd_message.set_token('ID',p_rqd_perd_enrt_nenrt_rl);
2715: fnd_message.set_token('TYPE_ID',-513);
2716: fnd_message.raise_error;
2717: --

Line 2714: fnd_message.set_token('ID',p_rqd_perd_enrt_nenrt_rl);

2710: --
2711: -- raise error
2712: --
2713: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
2714: fnd_message.set_token('ID',p_rqd_perd_enrt_nenrt_rl);
2715: fnd_message.set_token('TYPE_ID',-513);
2716: fnd_message.raise_error;
2717: --
2718: end if;

Line 2715: fnd_message.set_token('TYPE_ID',-513);

2711: -- raise error
2712: --
2713: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
2714: fnd_message.set_token('ID',p_rqd_perd_enrt_nenrt_rl);
2715: fnd_message.set_token('TYPE_ID',-513);
2716: fnd_message.raise_error;
2717: --
2718: end if;
2719: --

Line 2716: fnd_message.raise_error;

2712: --
2713: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
2714: fnd_message.set_token('ID',p_rqd_perd_enrt_nenrt_rl);
2715: fnd_message.set_token('TYPE_ID',-513);
2716: fnd_message.raise_error;
2717: --
2718: end if;
2719: --
2720: close c1;

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

2805: close c1;
2806: --
2807: -- raise error
2808: --
2809: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
2810: fnd_message.set_token('ID',p_auto_enrt_mthd_rl);
2811: fnd_message.set_token('TYPE_ID',-146);
2812: fnd_message.raise_error;
2813: --

Line 2810: fnd_message.set_token('ID',p_auto_enrt_mthd_rl);

2806: --
2807: -- raise error
2808: --
2809: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
2810: fnd_message.set_token('ID',p_auto_enrt_mthd_rl);
2811: fnd_message.set_token('TYPE_ID',-146);
2812: fnd_message.raise_error;
2813: --
2814: end if;

Line 2811: fnd_message.set_token('TYPE_ID',-146);

2807: -- raise error
2808: --
2809: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
2810: fnd_message.set_token('ID',p_auto_enrt_mthd_rl);
2811: fnd_message.set_token('TYPE_ID',-146);
2812: fnd_message.raise_error;
2813: --
2814: end if;
2815: --

Line 2812: fnd_message.raise_error;

2808: --
2809: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
2810: fnd_message.set_token('ID',p_auto_enrt_mthd_rl);
2811: fnd_message.set_token('TYPE_ID',-146);
2812: fnd_message.raise_error;
2813: --
2814: end if;
2815: --
2816: close c1;

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

2901: close c1;
2902: --
2903: -- raise error
2904: --
2905: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
2906: fnd_message.set_token('ID',p_enrt_rl);
2907: fnd_message.set_token('TYPE_ID',-393);
2908: fnd_message.raise_error;
2909: --

Line 2906: fnd_message.set_token('ID',p_enrt_rl);

2902: --
2903: -- raise error
2904: --
2905: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
2906: fnd_message.set_token('ID',p_enrt_rl);
2907: fnd_message.set_token('TYPE_ID',-393);
2908: fnd_message.raise_error;
2909: --
2910: end if;

Line 2907: fnd_message.set_token('TYPE_ID',-393);

2903: -- raise error
2904: --
2905: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
2906: fnd_message.set_token('ID',p_enrt_rl);
2907: fnd_message.set_token('TYPE_ID',-393);
2908: fnd_message.raise_error;
2909: --
2910: end if;
2911: --

Line 2908: fnd_message.raise_error;

2904: --
2905: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
2906: fnd_message.set_token('ID',p_enrt_rl);
2907: fnd_message.set_token('TYPE_ID',-393);
2908: fnd_message.raise_error;
2909: --
2910: end if;
2911: --
2912: close c1;

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

2997: close c1;
2998: --
2999: -- raise error
3000: --
3001: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
3002: fnd_message.set_token('ID',p_dflt_enrt_det_rl);
3003: fnd_message.set_token('TYPE_ID',-32);
3004: fnd_message.raise_error;
3005: --

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

2998: --
2999: -- raise error
3000: --
3001: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
3002: fnd_message.set_token('ID',p_dflt_enrt_det_rl);
3003: fnd_message.set_token('TYPE_ID',-32);
3004: fnd_message.raise_error;
3005: --
3006: end if;

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

2999: -- raise error
3000: --
3001: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
3002: fnd_message.set_token('ID',p_dflt_enrt_det_rl);
3003: fnd_message.set_token('TYPE_ID',-32);
3004: fnd_message.raise_error;
3005: --
3006: end if;
3007: --

Line 3004: fnd_message.raise_error;

3000: --
3001: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
3002: fnd_message.set_token('ID',p_dflt_enrt_det_rl);
3003: fnd_message.set_token('TYPE_ID',-32);
3004: fnd_message.raise_error;
3005: --
3006: end if;
3007: --
3008: close c1;

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

3071: p_effective_date => p_effective_date) then
3072: --
3073: -- raise error as does not exist as lookup
3074: --
3075: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3076: fnd_message.set_token('FIELD','p_enrt_mthd_cd');
3077: fnd_message.set_token('TYPE','BEN_ENRT_MTHD');
3078: fnd_message.raise_error;
3079: --

Line 3076: fnd_message.set_token('FIELD','p_enrt_mthd_cd');

3072: --
3073: -- raise error as does not exist as lookup
3074: --
3075: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3076: fnd_message.set_token('FIELD','p_enrt_mthd_cd');
3077: fnd_message.set_token('TYPE','BEN_ENRT_MTHD');
3078: fnd_message.raise_error;
3079: --
3080: end if;

Line 3077: fnd_message.set_token('TYPE','BEN_ENRT_MTHD');

3073: -- raise error as does not exist as lookup
3074: --
3075: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3076: fnd_message.set_token('FIELD','p_enrt_mthd_cd');
3077: fnd_message.set_token('TYPE','BEN_ENRT_MTHD');
3078: fnd_message.raise_error;
3079: --
3080: end if;
3081: end if;

Line 3078: fnd_message.raise_error;

3074: --
3075: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3076: fnd_message.set_token('FIELD','p_enrt_mthd_cd');
3077: fnd_message.set_token('TYPE','BEN_ENRT_MTHD');
3078: fnd_message.raise_error;
3079: --
3080: end if;
3081: end if;
3082: --

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

3145: p_effective_date => p_effective_date) then
3146: --
3147: -- raise error as does not exist as lookup
3148: --
3149: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3150: fnd_message.set_token('FIELD','p_enrt_cd');
3151: fnd_message.set_token('TYPE','BEN_ENRT');
3152: fnd_message.raise_error;
3153: --

Line 3150: fnd_message.set_token('FIELD','p_enrt_cd');

3146: --
3147: -- raise error as does not exist as lookup
3148: --
3149: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3150: fnd_message.set_token('FIELD','p_enrt_cd');
3151: fnd_message.set_token('TYPE','BEN_ENRT');
3152: fnd_message.raise_error;
3153: --
3154: end if;

Line 3151: fnd_message.set_token('TYPE','BEN_ENRT');

3147: -- raise error as does not exist as lookup
3148: --
3149: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3150: fnd_message.set_token('FIELD','p_enrt_cd');
3151: fnd_message.set_token('TYPE','BEN_ENRT');
3152: fnd_message.raise_error;
3153: --
3154: end if;
3155: end if;

Line 3152: fnd_message.raise_error;

3148: --
3149: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3150: fnd_message.set_token('FIELD','p_enrt_cd');
3151: fnd_message.set_token('TYPE','BEN_ENRT');
3152: fnd_message.raise_error;
3153: --
3154: end if;
3155: end if;
3156: --

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

3219: p_effective_date => p_effective_date) then
3220: --
3221: -- raise error as does not exist as lookup
3222: --
3223: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3224: fnd_message.set_token('FIELD','p_dflt_enrt_cd');
3225: fnd_message.set_token('TYPE','BEN_DFLT_ENRT');
3226: fnd_message.raise_error;
3227: --

Line 3224: fnd_message.set_token('FIELD','p_dflt_enrt_cd');

3220: --
3221: -- raise error as does not exist as lookup
3222: --
3223: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3224: fnd_message.set_token('FIELD','p_dflt_enrt_cd');
3225: fnd_message.set_token('TYPE','BEN_DFLT_ENRT');
3226: fnd_message.raise_error;
3227: --
3228: end if;

Line 3225: fnd_message.set_token('TYPE','BEN_DFLT_ENRT');

3221: -- raise error as does not exist as lookup
3222: --
3223: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3224: fnd_message.set_token('FIELD','p_dflt_enrt_cd');
3225: fnd_message.set_token('TYPE','BEN_DFLT_ENRT');
3226: fnd_message.raise_error;
3227: --
3228: end if;
3229: end if;

Line 3226: fnd_message.raise_error;

3222: --
3223: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3224: fnd_message.set_token('FIELD','p_dflt_enrt_cd');
3225: fnd_message.set_token('TYPE','BEN_DFLT_ENRT');
3226: fnd_message.raise_error;
3227: --
3228: end if;
3229: end if;
3230: --

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

3315: close c1;
3316: --
3317: -- raise error
3318: --
3319: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
3320: fnd_message.set_token('ID',p_dpnt_cvg_end_dt_rl);
3321: fnd_message.set_token('TYPE_ID',-28);
3322: fnd_message.raise_error;
3323: --

Line 3320: fnd_message.set_token('ID',p_dpnt_cvg_end_dt_rl);

3316: --
3317: -- raise error
3318: --
3319: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
3320: fnd_message.set_token('ID',p_dpnt_cvg_end_dt_rl);
3321: fnd_message.set_token('TYPE_ID',-28);
3322: fnd_message.raise_error;
3323: --
3324: end if;

Line 3321: fnd_message.set_token('TYPE_ID',-28);

3317: -- raise error
3318: --
3319: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
3320: fnd_message.set_token('ID',p_dpnt_cvg_end_dt_rl);
3321: fnd_message.set_token('TYPE_ID',-28);
3322: fnd_message.raise_error;
3323: --
3324: end if;
3325: --

Line 3322: fnd_message.raise_error;

3318: --
3319: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
3320: fnd_message.set_token('ID',p_dpnt_cvg_end_dt_rl);
3321: fnd_message.set_token('TYPE_ID',-28);
3322: fnd_message.raise_error;
3323: --
3324: end if;
3325: --
3326: close c1;

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

3412: close c1;
3413: --
3414: -- raise error
3415: --
3416: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
3417: fnd_message.set_token('ID',p_dpnt_cvg_strt_dt_rl);
3418: fnd_message.set_token('TYPE_ID',-27);
3419: fnd_message.raise_error;
3420: --

Line 3417: fnd_message.set_token('ID',p_dpnt_cvg_strt_dt_rl);

3413: --
3414: -- raise error
3415: --
3416: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
3417: fnd_message.set_token('ID',p_dpnt_cvg_strt_dt_rl);
3418: fnd_message.set_token('TYPE_ID',-27);
3419: fnd_message.raise_error;
3420: --
3421: end if;

Line 3418: fnd_message.set_token('TYPE_ID',-27);

3414: -- raise error
3415: --
3416: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
3417: fnd_message.set_token('ID',p_dpnt_cvg_strt_dt_rl);
3418: fnd_message.set_token('TYPE_ID',-27);
3419: fnd_message.raise_error;
3420: --
3421: end if;
3422: --

Line 3419: fnd_message.raise_error;

3415: --
3416: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
3417: fnd_message.set_token('ID',p_dpnt_cvg_strt_dt_rl);
3418: fnd_message.set_token('TYPE_ID',-27);
3419: fnd_message.raise_error;
3420: --
3421: end if;
3422: --
3423: close c1;

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

3486: p_effective_date => p_effective_date) then
3487: --
3488: -- raise error as does not exist as lookup
3489: --
3490: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3491: fnd_message.set_token('FIELD','p_dpnt_cvg_strt_dt_cd');
3492: fnd_message.set_token('TYPE','BEN_DPNT_CVG_STRT');
3493: fnd_message.raise_error;
3494: --

Line 3491: fnd_message.set_token('FIELD','p_dpnt_cvg_strt_dt_cd');

3487: --
3488: -- raise error as does not exist as lookup
3489: --
3490: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3491: fnd_message.set_token('FIELD','p_dpnt_cvg_strt_dt_cd');
3492: fnd_message.set_token('TYPE','BEN_DPNT_CVG_STRT');
3493: fnd_message.raise_error;
3494: --
3495: end if;

Line 3492: fnd_message.set_token('TYPE','BEN_DPNT_CVG_STRT');

3488: -- raise error as does not exist as lookup
3489: --
3490: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3491: fnd_message.set_token('FIELD','p_dpnt_cvg_strt_dt_cd');
3492: fnd_message.set_token('TYPE','BEN_DPNT_CVG_STRT');
3493: fnd_message.raise_error;
3494: --
3495: end if;
3496: end if;

Line 3493: fnd_message.raise_error;

3489: --
3490: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3491: fnd_message.set_token('FIELD','p_dpnt_cvg_strt_dt_cd');
3492: fnd_message.set_token('TYPE','BEN_DPNT_CVG_STRT');
3493: fnd_message.raise_error;
3494: --
3495: end if;
3496: end if;
3497: --

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

3559: p_effective_date => p_effective_date) then
3560: --
3561: -- raise error as does not exist as lookup
3562: --
3563: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3564: fnd_message.set_token('FIELD','p_rt_strt_dt_cd');
3565: fnd_message.set_token('TYPE','BEN_RT_STRT');
3566: fnd_message.raise_error;
3567: --

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

3560: --
3561: -- raise error as does not exist as lookup
3562: --
3563: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3564: fnd_message.set_token('FIELD','p_rt_strt_dt_cd');
3565: fnd_message.set_token('TYPE','BEN_RT_STRT');
3566: fnd_message.raise_error;
3567: --
3568: end if;

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

3561: -- raise error as does not exist as lookup
3562: --
3563: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3564: fnd_message.set_token('FIELD','p_rt_strt_dt_cd');
3565: fnd_message.set_token('TYPE','BEN_RT_STRT');
3566: fnd_message.raise_error;
3567: --
3568: end if;
3569: end if;

Line 3566: fnd_message.raise_error;

3562: --
3563: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3564: fnd_message.set_token('FIELD','p_rt_strt_dt_cd');
3565: fnd_message.set_token('TYPE','BEN_RT_STRT');
3566: fnd_message.raise_error;
3567: --
3568: end if;
3569: end if;
3570: --

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

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

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

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

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

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

Line 3639: fnd_message.raise_error;

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

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

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

Line 3710: fnd_message.set_token('FIELD','p_enrt_cvg_end_dt_cd');

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

Line 3711: fnd_message.set_token('TYPE','BEN_ENRT_CVG_END');

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

Line 3712: fnd_message.raise_error;

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

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

3778: p_effective_date => p_effective_date) then
3779: --
3780: -- raise error as does not exist as lookup
3781: --
3782: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3783: fnd_message.set_token('FIELD','p_enrt_cvg_strt_dt_cd');
3784: fnd_message.set_token('TYPE','BEN_ENRT_CVG_STRT');
3785: fnd_message.raise_error;
3786: --

Line 3783: fnd_message.set_token('FIELD','p_enrt_cvg_strt_dt_cd');

3779: --
3780: -- raise error as does not exist as lookup
3781: --
3782: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3783: fnd_message.set_token('FIELD','p_enrt_cvg_strt_dt_cd');
3784: fnd_message.set_token('TYPE','BEN_ENRT_CVG_STRT');
3785: fnd_message.raise_error;
3786: --
3787: end if;

Line 3784: fnd_message.set_token('TYPE','BEN_ENRT_CVG_STRT');

3780: -- raise error as does not exist as lookup
3781: --
3782: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3783: fnd_message.set_token('FIELD','p_enrt_cvg_strt_dt_cd');
3784: fnd_message.set_token('TYPE','BEN_ENRT_CVG_STRT');
3785: fnd_message.raise_error;
3786: --
3787: end if;
3788: end if;

Line 3785: fnd_message.raise_error;

3781: --
3782: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3783: fnd_message.set_token('FIELD','p_enrt_cvg_strt_dt_cd');
3784: fnd_message.set_token('TYPE','BEN_ENRT_CVG_STRT');
3785: fnd_message.raise_error;
3786: --
3787: end if;
3788: end if;
3789: --

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

3852: p_effective_date => p_effective_date) then
3853: --
3854: -- raise error as does not exist as lookup
3855: --
3856: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3857: fnd_message.set_token('FIELD','p_dpnt_cvg_end_dt_cd');
3858: fnd_message.set_token('TYPE','BEN_DPNT_CVG_END');
3859: fnd_message.raise_error;
3860: --

Line 3857: fnd_message.set_token('FIELD','p_dpnt_cvg_end_dt_cd');

3853: --
3854: -- raise error as does not exist as lookup
3855: --
3856: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3857: fnd_message.set_token('FIELD','p_dpnt_cvg_end_dt_cd');
3858: fnd_message.set_token('TYPE','BEN_DPNT_CVG_END');
3859: fnd_message.raise_error;
3860: --
3861: end if;

Line 3858: fnd_message.set_token('TYPE','BEN_DPNT_CVG_END');

3854: -- raise error as does not exist as lookup
3855: --
3856: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3857: fnd_message.set_token('FIELD','p_dpnt_cvg_end_dt_cd');
3858: fnd_message.set_token('TYPE','BEN_DPNT_CVG_END');
3859: fnd_message.raise_error;
3860: --
3861: end if;
3862: end if;

Line 3859: fnd_message.raise_error;

3855: --
3856: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
3857: fnd_message.set_token('FIELD','p_dpnt_cvg_end_dt_cd');
3858: fnd_message.set_token('TYPE','BEN_DPNT_CVG_END');
3859: fnd_message.raise_error;
3860: --
3861: end if;
3862: end if;
3863: --

Line 3928: fnd_message.set_name('BEN','BEN_91237_INV_COORD_CVG_FLAG');

3924: p_effective_date => p_effective_date) then
3925: --
3926: -- raise error as does not exist as lookup
3927: --
3928: fnd_message.set_name('BEN','BEN_91237_INV_COORD_CVG_FLAG');
3929: fnd_message.raise_error;
3930: --
3931: end if;
3932: --

Line 3929: fnd_message.raise_error;

3925: --
3926: -- raise error as does not exist as lookup
3927: --
3928: fnd_message.set_name('BEN','BEN_91237_INV_COORD_CVG_FLAG');
3929: fnd_message.raise_error;
3930: --
3931: end if;
3932: --
3933: end if;

Line 3998: fnd_message.set_name('BEN','BEN_91238_RQD_PERD_ENRT_DPCY');

3994: --
3995: if (p_rqd_perd_enrt_nenrt_val is null and p_rqd_perd_enrt_nenrt_tm_uom is not null) or
3996: (p_rqd_perd_enrt_nenrt_val is not null and p_rqd_perd_enrt_nenrt_tm_uom is null) then
3997: --
3998: fnd_message.set_name('BEN','BEN_91238_RQD_PERD_ENRT_DPCY');
3999: fnd_message.raise_error;
4000: --
4001: end if;
4002: --

Line 3999: fnd_message.raise_error;

3995: if (p_rqd_perd_enrt_nenrt_val is null and p_rqd_perd_enrt_nenrt_tm_uom is not null) or
3996: (p_rqd_perd_enrt_nenrt_val is not null and p_rqd_perd_enrt_nenrt_tm_uom is null) then
3997: --
3998: fnd_message.set_name('BEN','BEN_91238_RQD_PERD_ENRT_DPCY');
3999: fnd_message.raise_error;
4000: --
4001: end if;
4002: --
4003: end if;

Line 4069: fnd_message.set_name('BEN','BEN_91240_MX_OVRD_FLG_DPCY');

4065: -- If flag = 'Y' then num must be null.
4066: --
4067: if p_no_mx_pl_typ_ovrid_flag = 'Y' and p_mx_enrd_alwd_ovrid_num is not null then
4068: --
4069: fnd_message.set_name('BEN','BEN_91240_MX_OVRD_FLG_DPCY');
4070: fnd_message.raise_error;
4071: --
4072: end if;
4073: --

Line 4070: fnd_message.raise_error;

4066: --
4067: if p_no_mx_pl_typ_ovrid_flag = 'Y' and p_mx_enrd_alwd_ovrid_num is not null then
4068: --
4069: fnd_message.set_name('BEN','BEN_91240_MX_OVRD_FLG_DPCY');
4070: fnd_message.raise_error;
4071: --
4072: end if;
4073: --
4074: end if;

Line 4138: fnd_message.set_name('BEN','BEN_91241_MN_OVRD_FLG_DPCY');

4134: -- If flag = 'Y' then num must be null.
4135: --
4136: if p_no_mn_pl_typ_overid_flag = 'Y' and p_mn_enrd_rqd_ovrid_num is not null then
4137: --
4138: fnd_message.set_name('BEN','BEN_91241_MN_OVRD_FLG_DPCY');
4139: fnd_message.raise_error;
4140: --
4141: end if;
4142: --

Line 4139: fnd_message.raise_error;

4135: --
4136: if p_no_mn_pl_typ_overid_flag = 'Y' and p_mn_enrd_rqd_ovrid_num is not null then
4137: --
4138: fnd_message.set_name('BEN','BEN_91241_MN_OVRD_FLG_DPCY');
4139: fnd_message.raise_error;
4140: --
4141: end if;
4142: --
4143: end if;

Line 4219: fnd_message.set_name('BEN','BEN_91243_INV_MX_ENRT_OVRD_NUM');

4215: --
4216: if p_mx_enrd_alwd_ovrid_num < nvl(l_value,p_mx_enrd_alwd_ovrid_num) then
4217: --
4218: close c1;
4219: fnd_message.set_name('BEN','BEN_91243_INV_MX_ENRT_OVRD_NUM');
4220: fnd_message.raise_error;
4221: --
4222: end if;
4223: end if;

Line 4220: fnd_message.raise_error;

4216: if p_mx_enrd_alwd_ovrid_num < nvl(l_value,p_mx_enrd_alwd_ovrid_num) then
4217: --
4218: close c1;
4219: fnd_message.set_name('BEN','BEN_91243_INV_MX_ENRT_OVRD_NUM');
4220: fnd_message.raise_error;
4221: --
4222: end if;
4223: end if;
4224: close c1;

Line 4303: fnd_message.set_name('BEN','BEN_91244_INV_MN_ENRT_OVRD_NUM');

4299: --
4300: if p_mn_enrd_rqd_ovrid_num < nvl(l_value,p_mn_enrd_rqd_ovrid_num) then
4301: --
4302: close c1;
4303: fnd_message.set_name('BEN','BEN_91244_INV_MN_ENRT_OVRD_NUM');
4304: fnd_message.raise_error;
4305: --
4306: end if;
4307: end if;

Line 4304: fnd_message.raise_error;

4300: if p_mn_enrd_rqd_ovrid_num < nvl(l_value,p_mn_enrd_rqd_ovrid_num) then
4301: --
4302: close c1;
4303: fnd_message.set_name('BEN','BEN_91244_INV_MN_ENRT_OVRD_NUM');
4304: fnd_message.raise_error;
4305: --
4306: end if;
4307: end if;
4308: close c1;

Line 4384: fnd_message.set_name('BEN','mn_num_dpndcy_err');

4380: --
4381: if p_mn_enrd_rqd_ovrid_num is not null and p_mx_enrd_alwd_ovrid_num is null and
4382: p_no_mx_pl_typ_ovrid_flag <> 'Y' then
4383: --
4384: fnd_message.set_name('BEN','mn_num_dpndcy_err');
4385: fnd_message.raise_error;
4386: --
4387: end if;
4388: --

Line 4385: fnd_message.raise_error;

4381: if p_mn_enrd_rqd_ovrid_num is not null and p_mx_enrd_alwd_ovrid_num is null and
4382: p_no_mx_pl_typ_ovrid_flag <> 'Y' then
4383: --
4384: fnd_message.set_name('BEN','mn_num_dpndcy_err');
4385: fnd_message.raise_error;
4386: --
4387: end if;
4388: --
4389: end if;

Line 4550: fnd_message.set_name('BEN','BEN_92518_DELETE_LDC');

4546: fetch c1 into l_dummy;
4547: if c1%found then
4548: --
4549: close c1;
4550: fnd_message.set_name('BEN','BEN_92518_DELETE_LDC');
4551: fnd_message.raise_error;
4552: --
4553: else
4554: close c1;

Line 4551: fnd_message.raise_error;

4547: if c1%found then
4548: --
4549: close c1;
4550: fnd_message.set_name('BEN','BEN_92518_DELETE_LDC');
4551: fnd_message.raise_error;
4552: --
4553: else
4554: close c1;
4555: end if;

Line 4567: fnd_message.set_name('BEN','BEN_92517_DELETE_ADE');

4563: fetch c2 into l_dummy;
4564: if c2%found then
4565: --
4566: close c2;
4567: fnd_message.set_name('BEN','BEN_92517_DELETE_ADE');
4568: fnd_message.raise_error;
4569: --
4570: else
4571: close c2;

Line 4568: fnd_message.raise_error;

4564: if c2%found then
4565: --
4566: close c2;
4567: fnd_message.set_name('BEN','BEN_92517_DELETE_ADE');
4568: fnd_message.raise_error;
4569: --
4570: else
4571: close c2;
4572: end if;

Line 4584: fnd_message.set_name('BEN','BEN_92516_DELETE_PYD');

4580: fetch c3 into l_dummy;
4581: if c3%found then
4582: --
4583: close c3;
4584: fnd_message.set_name('BEN','BEN_92516_DELETE_PYD');
4585: fnd_message.raise_error;
4586: --
4587: else
4588: close c3;

Line 4585: fnd_message.raise_error;

4581: if c3%found then
4582: --
4583: close c3;
4584: fnd_message.set_name('BEN','BEN_92516_DELETE_PYD');
4585: fnd_message.raise_error;
4586: --
4587: else
4588: close c3;
4589: end if;

Line 4676: fnd_message.set_name('BEN','BEN_91248_PT_DSGN_LVL_RQD');

4672: p_drvd_fctr_dpnt_cvg_flag = 'Y' ) then
4673: --
4674: close c1;
4675: if l_value is null then
4676: fnd_message.set_name('BEN','BEN_91248_PT_DSGN_LVL_RQD');
4677: fnd_message.raise_error;
4678: else
4679: fnd_message.set_name('BEN','BEN_91249_INV_DSGN_LVL_PT');
4680: fnd_message.raise_error;

Line 4677: fnd_message.raise_error;

4673: --
4674: close c1;
4675: if l_value is null then
4676: fnd_message.set_name('BEN','BEN_91248_PT_DSGN_LVL_RQD');
4677: fnd_message.raise_error;
4678: else
4679: fnd_message.set_name('BEN','BEN_91249_INV_DSGN_LVL_PT');
4680: fnd_message.raise_error;
4681: end if;

Line 4679: fnd_message.set_name('BEN','BEN_91249_INV_DSGN_LVL_PT');

4675: if l_value is null then
4676: fnd_message.set_name('BEN','BEN_91248_PT_DSGN_LVL_RQD');
4677: fnd_message.raise_error;
4678: else
4679: fnd_message.set_name('BEN','BEN_91249_INV_DSGN_LVL_PT');
4680: fnd_message.raise_error;
4681: end if;
4682: --
4683: end if;

Line 4680: fnd_message.raise_error;

4676: fnd_message.set_name('BEN','BEN_91248_PT_DSGN_LVL_RQD');
4677: fnd_message.raise_error;
4678: else
4679: fnd_message.set_name('BEN','BEN_91249_INV_DSGN_LVL_PT');
4680: fnd_message.raise_error;
4681: end if;
4682: --
4683: end if;
4684: end if;

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

4825: --
4826: -- An unhandled or unexpected error has occurred which
4827: -- we must report
4828: --
4829: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
4830: fnd_message.set_token('PROCEDURE', l_proc);
4831: fnd_message.set_token('STEP','15');
4832: fnd_message.raise_error;
4833: End dt_update_validate;

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

4826: -- An unhandled or unexpected error has occurred which
4827: -- we must report
4828: --
4829: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
4830: fnd_message.set_token('PROCEDURE', l_proc);
4831: fnd_message.set_token('STEP','15');
4832: fnd_message.raise_error;
4833: End dt_update_validate;
4834: --

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

4827: -- we must report
4828: --
4829: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
4830: fnd_message.set_token('PROCEDURE', l_proc);
4831: fnd_message.set_token('STEP','15');
4832: fnd_message.raise_error;
4833: End dt_update_validate;
4834: --
4835: -- ----------------------------------------------------------------------------

Line 4832: fnd_message.raise_error;

4828: --
4829: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
4830: fnd_message.set_token('PROCEDURE', l_proc);
4831: fnd_message.set_token('STEP','15');
4832: fnd_message.raise_error;
4833: End dt_update_validate;
4834: --
4835: -- ----------------------------------------------------------------------------
4836: -- |--------------------------< dt_delete_validate >--------------------------|

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

4980: --
4981: -- An unhandled or unexpected error has occurred which
4982: -- we must report
4983: --
4984: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
4985: fnd_message.set_token('PROCEDURE', l_proc);
4986: fnd_message.set_token('STEP','15');
4987: fnd_message.raise_error;
4988: End dt_delete_validate;

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

4981: -- An unhandled or unexpected error has occurred which
4982: -- we must report
4983: --
4984: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
4985: fnd_message.set_token('PROCEDURE', l_proc);
4986: fnd_message.set_token('STEP','15');
4987: fnd_message.raise_error;
4988: End dt_delete_validate;
4989: --

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

4982: -- we must report
4983: --
4984: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
4985: fnd_message.set_token('PROCEDURE', l_proc);
4986: fnd_message.set_token('STEP','15');
4987: fnd_message.raise_error;
4988: End dt_delete_validate;
4989: --
4990: -- ----------------------------------------------------------------------------

Line 4987: fnd_message.raise_error;

4983: --
4984: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
4985: fnd_message.set_token('PROCEDURE', l_proc);
4986: fnd_message.set_token('STEP','15');
4987: fnd_message.raise_error;
4988: End dt_delete_validate;
4989: --
4990: -- ----------------------------------------------------------------------------
4991: -- |---------------------------< insert_validate >----------------------------|

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

6025: close csr_leg_code;
6026: --
6027: -- The primary key is invalid therefore we must error
6028: --
6029: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
6030: fnd_message.raise_error;
6031: --
6032: end if;
6033: --

Line 6030: fnd_message.raise_error;

6026: --
6027: -- The primary key is invalid therefore we must error
6028: --
6029: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
6030: fnd_message.raise_error;
6031: --
6032: end if;
6033: --
6034: close csr_leg_code;