DBA Data[Home] [Help]

APPS.BEN_LEN_BUS dependencies on FND_MESSAGE

Line 122: fnd_message.set_name('BEN','BEN_91618_DFLT_LS_THN_INELG');

118: --
119: -- raise error if both arguments are not null and p_dys_no_enrl_not_elig
120: -- _num is less than p_dys_aftr_end_to_dflt_num
121: --
122: fnd_message.set_name('BEN','BEN_91618_DFLT_LS_THN_INELG');
123: fnd_message.raise_error;
124: --
125: --
126: end if;

Line 123: fnd_message.raise_error;

119: -- raise error if both arguments are not null and p_dys_no_enrl_not_elig
120: -- _num is less than p_dys_aftr_end_to_dflt_num
121: --
122: fnd_message.set_name('BEN','BEN_91618_DFLT_LS_THN_INELG');
123: fnd_message.raise_error;
124: --
125: --
126: end if;
127: --

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

188: p_effective_date => p_effective_date) then
189: --
190: -- raise error
191: --
192: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
193: fnd_message.set_token('ID',p_enrt_cvg_strt_dt_rl);
194: fnd_message.set_token('TYPE_ID',-29);
195: fnd_message.raise_error;
196: --

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

189: --
190: -- raise error
191: --
192: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
193: fnd_message.set_token('ID',p_enrt_cvg_strt_dt_rl);
194: fnd_message.set_token('TYPE_ID',-29);
195: fnd_message.raise_error;
196: --
197: end if;

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

190: -- raise error
191: --
192: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
193: fnd_message.set_token('ID',p_enrt_cvg_strt_dt_rl);
194: fnd_message.set_token('TYPE_ID',-29);
195: fnd_message.raise_error;
196: --
197: end if;
198: --

Line 195: fnd_message.raise_error;

191: --
192: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
193: fnd_message.set_token('ID',p_enrt_cvg_strt_dt_rl);
194: fnd_message.set_token('TYPE_ID',-29);
195: fnd_message.raise_error;
196: --
197: end if;
198: --
199: end if;

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

261: p_effective_date => p_effective_date) then
262: --
263: -- raise error
264: --
265: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
266: fnd_message.set_token('ID',p_enrt_cvg_end_dt_rl);
267: fnd_message.set_token('TYPE_ID',-30);
268: fnd_message.raise_error;
269: --

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

262: --
263: -- raise error
264: --
265: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
266: fnd_message.set_token('ID',p_enrt_cvg_end_dt_rl);
267: fnd_message.set_token('TYPE_ID',-30);
268: fnd_message.raise_error;
269: --
270: end if;

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

263: -- raise error
264: --
265: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
266: fnd_message.set_token('ID',p_enrt_cvg_end_dt_rl);
267: fnd_message.set_token('TYPE_ID',-30);
268: fnd_message.raise_error;
269: --
270: end if;
271: --

Line 268: fnd_message.raise_error;

264: --
265: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
266: fnd_message.set_token('ID',p_enrt_cvg_end_dt_rl);
267: fnd_message.set_token('TYPE_ID',-30);
268: fnd_message.raise_error;
269: --
270: end if;
271: --
272: end if;

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

334: p_effective_date => p_effective_date) then
335: --
336: -- raise error
337: --
338: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
339: fnd_message.set_token('ID',p_rt_strt_dt_rl);
340: fnd_message.set_token('TYPE_ID',-66);
341: fnd_message.raise_error;
342: --

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

335: --
336: -- raise error
337: --
338: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
339: fnd_message.set_token('ID',p_rt_strt_dt_rl);
340: fnd_message.set_token('TYPE_ID',-66);
341: fnd_message.raise_error;
342: --
343: end if;

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

336: -- raise error
337: --
338: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
339: fnd_message.set_token('ID',p_rt_strt_dt_rl);
340: fnd_message.set_token('TYPE_ID',-66);
341: fnd_message.raise_error;
342: --
343: end if;
344: --

Line 341: fnd_message.raise_error;

337: --
338: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
339: fnd_message.set_token('ID',p_rt_strt_dt_rl);
340: fnd_message.set_token('TYPE_ID',-66);
341: fnd_message.raise_error;
342: --
343: end if;
344: --
345: end if;

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

405: p_effective_date => p_effective_date) then
406: --
407: -- raise error as does not exist as lookup
408: --
409: fnd_message.set_name('BEN', 'BEN_91628_LOOKUP_TYPE_GENERIC');
410: fnd_message.set_token('FIELD', 'p_rt_strt_dt_cd');
411: fnd_message.set_token('TYPE', 'BEN_RT_STRT');
412: fnd_message.raise_error;
413: --

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

406: --
407: -- raise error as does not exist as lookup
408: --
409: fnd_message.set_name('BEN', 'BEN_91628_LOOKUP_TYPE_GENERIC');
410: fnd_message.set_token('FIELD', 'p_rt_strt_dt_cd');
411: fnd_message.set_token('TYPE', 'BEN_RT_STRT');
412: fnd_message.raise_error;
413: --
414: end if;

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

407: -- raise error as does not exist as lookup
408: --
409: fnd_message.set_name('BEN', 'BEN_91628_LOOKUP_TYPE_GENERIC');
410: fnd_message.set_token('FIELD', 'p_rt_strt_dt_cd');
411: fnd_message.set_token('TYPE', 'BEN_RT_STRT');
412: fnd_message.raise_error;
413: --
414: end if;
415: --

Line 412: fnd_message.raise_error;

408: --
409: fnd_message.set_name('BEN', 'BEN_91628_LOOKUP_TYPE_GENERIC');
410: fnd_message.set_token('FIELD', 'p_rt_strt_dt_cd');
411: fnd_message.set_token('TYPE', 'BEN_RT_STRT');
412: fnd_message.raise_error;
413: --
414: end if;
415: --
416: end if;

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

479: p_effective_date => p_effective_date) then
480: --
481: -- raise error
482: --
483: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
484: fnd_message.set_token('ID',p_rt_end_dt_rl);
485: fnd_message.set_token('TYPE_ID',-67);
486: fnd_message.raise_error;
487: --

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

480: --
481: -- raise error
482: --
483: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
484: fnd_message.set_token('ID',p_rt_end_dt_rl);
485: fnd_message.set_token('TYPE_ID',-67);
486: fnd_message.raise_error;
487: --
488: end if;

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

481: -- raise error
482: --
483: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
484: fnd_message.set_token('ID',p_rt_end_dt_rl);
485: fnd_message.set_token('TYPE_ID',-67);
486: fnd_message.raise_error;
487: --
488: end if;
489: --

Line 486: fnd_message.raise_error;

482: --
483: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
484: fnd_message.set_token('ID',p_rt_end_dt_rl);
485: fnd_message.set_token('TYPE_ID',-67);
486: fnd_message.raise_error;
487: --
488: end if;
489: --
490: end if;

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

550: p_effective_date => p_effective_date) then
551: --
552: -- raise error as does not exist as lookup
553: --
554: fnd_message.set_name('BEN', 'BEN_91628_LOOKUP_TYPE_GENERIC');
555: fnd_message.set_token('FIELD', 'p_rt_end_dt_cd');
556: fnd_message.set_token('TYPE', 'BEN_RT_END');
557: fnd_message.raise_error;
558: --

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

551: --
552: -- raise error as does not exist as lookup
553: --
554: fnd_message.set_name('BEN', 'BEN_91628_LOOKUP_TYPE_GENERIC');
555: fnd_message.set_token('FIELD', 'p_rt_end_dt_cd');
556: fnd_message.set_token('TYPE', 'BEN_RT_END');
557: fnd_message.raise_error;
558: --
559: end if;

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

552: -- raise error as does not exist as lookup
553: --
554: fnd_message.set_name('BEN', 'BEN_91628_LOOKUP_TYPE_GENERIC');
555: fnd_message.set_token('FIELD', 'p_rt_end_dt_cd');
556: fnd_message.set_token('TYPE', 'BEN_RT_END');
557: fnd_message.raise_error;
558: --
559: end if;
560: --

Line 557: fnd_message.raise_error;

553: --
554: fnd_message.set_name('BEN', 'BEN_91628_LOOKUP_TYPE_GENERIC');
555: fnd_message.set_token('FIELD', 'p_rt_end_dt_cd');
556: fnd_message.set_token('TYPE', 'BEN_RT_END');
557: fnd_message.raise_error;
558: --
559: end if;
560: --
561: end if;

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

623: p_effective_date => p_effective_date) then
624: --
625: -- raise error
626: --
627: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
628: fnd_message.set_token('ID',p_enrt_perd_end_dt_rl);
629: fnd_message.set_token('TYPE_ID',-503);
630: fnd_message.raise_error;
631: --

Line 628: fnd_message.set_token('ID',p_enrt_perd_end_dt_rl);

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

Line 629: fnd_message.set_token('TYPE_ID',-503);

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

Line 630: fnd_message.raise_error;

626: --
627: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
628: fnd_message.set_token('ID',p_enrt_perd_end_dt_rl);
629: fnd_message.set_token('TYPE_ID',-503);
630: fnd_message.raise_error;
631: --
632: end if;
633: --
634: end if;

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

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

Line 699: fnd_message.set_token('FIELD', 'p_enrt_perd_end_dt_cd');

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

Line 700: fnd_message.set_token('TYPE', 'BEN_ENRT_PERD_END');

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

Line 701: fnd_message.raise_error;

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

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

767: p_effective_date => p_effective_date) then
768: --
769: -- raise error
770: --
771: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
772: fnd_message.set_token('ID',p_enrt_perd_strt_dt_rl);
773: fnd_message.set_token('TYPE_ID',-504);
774: fnd_message.raise_error;
775: --

Line 772: fnd_message.set_token('ID',p_enrt_perd_strt_dt_rl);

768: --
769: -- raise error
770: --
771: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
772: fnd_message.set_token('ID',p_enrt_perd_strt_dt_rl);
773: fnd_message.set_token('TYPE_ID',-504);
774: fnd_message.raise_error;
775: --
776: end if;

Line 773: fnd_message.set_token('TYPE_ID',-504);

769: -- raise error
770: --
771: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
772: fnd_message.set_token('ID',p_enrt_perd_strt_dt_rl);
773: fnd_message.set_token('TYPE_ID',-504);
774: fnd_message.raise_error;
775: --
776: end if;
777: --

Line 774: fnd_message.raise_error;

770: --
771: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
772: fnd_message.set_token('ID',p_enrt_perd_strt_dt_rl);
773: fnd_message.set_token('TYPE_ID',-504);
774: fnd_message.raise_error;
775: --
776: end if;
777: --
778: end if;

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

838: p_effective_date => p_effective_date) then
839: --
840: -- raise error as does not exist as lookup
841: --
842: fnd_message.set_name('BEN', 'BEN_91628_LOOKUP_TYPE_GENERIC');
843: fnd_message.set_token('FIELD', 'p_enrt_perd_strt_dt_cd');
844: fnd_message.set_token('TYPE', 'BEN_ENRT_PERD_STRT');
845: fnd_message.raise_error;
846: --

Line 843: fnd_message.set_token('FIELD', 'p_enrt_perd_strt_dt_cd');

839: --
840: -- raise error as does not exist as lookup
841: --
842: fnd_message.set_name('BEN', 'BEN_91628_LOOKUP_TYPE_GENERIC');
843: fnd_message.set_token('FIELD', 'p_enrt_perd_strt_dt_cd');
844: fnd_message.set_token('TYPE', 'BEN_ENRT_PERD_STRT');
845: fnd_message.raise_error;
846: --
847: end if;

Line 844: fnd_message.set_token('TYPE', 'BEN_ENRT_PERD_STRT');

840: -- raise error as does not exist as lookup
841: --
842: fnd_message.set_name('BEN', 'BEN_91628_LOOKUP_TYPE_GENERIC');
843: fnd_message.set_token('FIELD', 'p_enrt_perd_strt_dt_cd');
844: fnd_message.set_token('TYPE', 'BEN_ENRT_PERD_STRT');
845: fnd_message.raise_error;
846: --
847: end if;
848: --

Line 845: fnd_message.raise_error;

841: --
842: fnd_message.set_name('BEN', 'BEN_91628_LOOKUP_TYPE_GENERIC');
843: fnd_message.set_token('FIELD', 'p_enrt_perd_strt_dt_cd');
844: fnd_message.set_token('TYPE', 'BEN_ENRT_PERD_STRT');
845: fnd_message.raise_error;
846: --
847: end if;
848: --
849: end if;

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

909: p_effective_date => p_effective_date) then
910: --
911: -- raise error as does not exist as lookup
912: --
913: fnd_message.set_name('BEN', 'BEN_91628_LOOKUP_TYPE_GENERIC');
914: fnd_message.set_token('FIELD', 'p_enrt_cvg_strt_dt_cd');
915: fnd_message.set_token('TYPE', 'BEN_ENRT_CVG_STRT');
916: fnd_message.raise_error;
917: --

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

910: --
911: -- raise error as does not exist as lookup
912: --
913: fnd_message.set_name('BEN', 'BEN_91628_LOOKUP_TYPE_GENERIC');
914: fnd_message.set_token('FIELD', 'p_enrt_cvg_strt_dt_cd');
915: fnd_message.set_token('TYPE', 'BEN_ENRT_CVG_STRT');
916: fnd_message.raise_error;
917: --
918: end if;

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

911: -- raise error as does not exist as lookup
912: --
913: fnd_message.set_name('BEN', 'BEN_91628_LOOKUP_TYPE_GENERIC');
914: fnd_message.set_token('FIELD', 'p_enrt_cvg_strt_dt_cd');
915: fnd_message.set_token('TYPE', 'BEN_ENRT_CVG_STRT');
916: fnd_message.raise_error;
917: --
918: end if;
919: --

Line 916: fnd_message.raise_error;

912: --
913: fnd_message.set_name('BEN', 'BEN_91628_LOOKUP_TYPE_GENERIC');
914: fnd_message.set_token('FIELD', 'p_enrt_cvg_strt_dt_cd');
915: fnd_message.set_token('TYPE', 'BEN_ENRT_CVG_STRT');
916: fnd_message.raise_error;
917: --
918: end if;
919: --
920: end if;

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

981: p_effective_date => p_effective_date) then
982: --
983: -- raise error as does not exist as lookup
984: --
985: fnd_message.set_name('BEN', 'BEN_91628_LOOKUP_TYPE_GENERIC');
986: fnd_message.set_token('FIELD', 'p_reinstate_ovrdn_cd');
987: fnd_message.set_token('VALUE', p_reinstate_ovrdn_cd);
988: fnd_message.set_token('TYPE', 'BEN_REINSTATE_OVRDN');
989: fnd_message.raise_error;

Line 986: fnd_message.set_token('FIELD', 'p_reinstate_ovrdn_cd');

982: --
983: -- raise error as does not exist as lookup
984: --
985: fnd_message.set_name('BEN', 'BEN_91628_LOOKUP_TYPE_GENERIC');
986: fnd_message.set_token('FIELD', 'p_reinstate_ovrdn_cd');
987: fnd_message.set_token('VALUE', p_reinstate_ovrdn_cd);
988: fnd_message.set_token('TYPE', 'BEN_REINSTATE_OVRDN');
989: fnd_message.raise_error;
990: --

Line 987: fnd_message.set_token('VALUE', p_reinstate_ovrdn_cd);

983: -- raise error as does not exist as lookup
984: --
985: fnd_message.set_name('BEN', 'BEN_91628_LOOKUP_TYPE_GENERIC');
986: fnd_message.set_token('FIELD', 'p_reinstate_ovrdn_cd');
987: fnd_message.set_token('VALUE', p_reinstate_ovrdn_cd);
988: fnd_message.set_token('TYPE', 'BEN_REINSTATE_OVRDN');
989: fnd_message.raise_error;
990: --
991: end if;

Line 988: fnd_message.set_token('TYPE', 'BEN_REINSTATE_OVRDN');

984: --
985: fnd_message.set_name('BEN', 'BEN_91628_LOOKUP_TYPE_GENERIC');
986: fnd_message.set_token('FIELD', 'p_reinstate_ovrdn_cd');
987: fnd_message.set_token('VALUE', p_reinstate_ovrdn_cd);
988: fnd_message.set_token('TYPE', 'BEN_REINSTATE_OVRDN');
989: fnd_message.raise_error;
990: --
991: end if;
992: --

Line 989: fnd_message.raise_error;

985: fnd_message.set_name('BEN', 'BEN_91628_LOOKUP_TYPE_GENERIC');
986: fnd_message.set_token('FIELD', 'p_reinstate_ovrdn_cd');
987: fnd_message.set_token('VALUE', p_reinstate_ovrdn_cd);
988: fnd_message.set_token('TYPE', 'BEN_REINSTATE_OVRDN');
989: fnd_message.raise_error;
990: --
991: end if;
992: --
993: end if;

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

1053: p_effective_date => p_effective_date) then
1054: --
1055: -- raise error as does not exist as lookup
1056: --
1057: fnd_message.set_name('BEN', 'BEN_91628_LOOKUP_TYPE_GENERIC');
1058: fnd_message.set_token('FIELD', 'p_reinstate_cd');
1059: fnd_message.set_token('VALUE', p_reinstate_cd);
1060: fnd_message.set_token('TYPE', 'BEN_REINSTATE');
1061: fnd_message.raise_error;

Line 1058: fnd_message.set_token('FIELD', 'p_reinstate_cd');

1054: --
1055: -- raise error as does not exist as lookup
1056: --
1057: fnd_message.set_name('BEN', 'BEN_91628_LOOKUP_TYPE_GENERIC');
1058: fnd_message.set_token('FIELD', 'p_reinstate_cd');
1059: fnd_message.set_token('VALUE', p_reinstate_cd);
1060: fnd_message.set_token('TYPE', 'BEN_REINSTATE');
1061: fnd_message.raise_error;
1062: --

Line 1059: fnd_message.set_token('VALUE', p_reinstate_cd);

1055: -- raise error as does not exist as lookup
1056: --
1057: fnd_message.set_name('BEN', 'BEN_91628_LOOKUP_TYPE_GENERIC');
1058: fnd_message.set_token('FIELD', 'p_reinstate_cd');
1059: fnd_message.set_token('VALUE', p_reinstate_cd);
1060: fnd_message.set_token('TYPE', 'BEN_REINSTATE');
1061: fnd_message.raise_error;
1062: --
1063: end if;

Line 1060: fnd_message.set_token('TYPE', 'BEN_REINSTATE');

1056: --
1057: fnd_message.set_name('BEN', 'BEN_91628_LOOKUP_TYPE_GENERIC');
1058: fnd_message.set_token('FIELD', 'p_reinstate_cd');
1059: fnd_message.set_token('VALUE', p_reinstate_cd);
1060: fnd_message.set_token('TYPE', 'BEN_REINSTATE');
1061: fnd_message.raise_error;
1062: --
1063: end if;
1064: --

Line 1061: fnd_message.raise_error;

1057: fnd_message.set_name('BEN', 'BEN_91628_LOOKUP_TYPE_GENERIC');
1058: fnd_message.set_token('FIELD', 'p_reinstate_cd');
1059: fnd_message.set_token('VALUE', p_reinstate_cd);
1060: fnd_message.set_token('TYPE', 'BEN_REINSTATE');
1061: fnd_message.raise_error;
1062: --
1063: end if;
1064: --
1065: end if;

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

1124: p_effective_date => p_effective_date) then
1125: --
1126: -- raise error as does not exist as lookup
1127: --
1128: fnd_message.set_name('BEN', 'BEN_91628_LOOKUP_TYPE_GENERIC');
1129: fnd_message.set_token('FIELD', 'p_enrt_cvg_end_dt_cd');
1130: fnd_message.set_token('TYPE', 'BEN_ENRT_CVG_END');
1131: fnd_message.raise_error;
1132: --

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

1125: --
1126: -- raise error as does not exist as lookup
1127: --
1128: fnd_message.set_name('BEN', 'BEN_91628_LOOKUP_TYPE_GENERIC');
1129: fnd_message.set_token('FIELD', 'p_enrt_cvg_end_dt_cd');
1130: fnd_message.set_token('TYPE', 'BEN_ENRT_CVG_END');
1131: fnd_message.raise_error;
1132: --
1133: end if;

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

1126: -- raise error as does not exist as lookup
1127: --
1128: fnd_message.set_name('BEN', 'BEN_91628_LOOKUP_TYPE_GENERIC');
1129: fnd_message.set_token('FIELD', 'p_enrt_cvg_end_dt_cd');
1130: fnd_message.set_token('TYPE', 'BEN_ENRT_CVG_END');
1131: fnd_message.raise_error;
1132: --
1133: end if;
1134: --

Line 1131: fnd_message.raise_error;

1127: --
1128: fnd_message.set_name('BEN', 'BEN_91628_LOOKUP_TYPE_GENERIC');
1129: fnd_message.set_token('FIELD', 'p_enrt_cvg_end_dt_cd');
1130: fnd_message.set_token('TYPE', 'BEN_ENRT_CVG_END');
1131: fnd_message.raise_error;
1132: --
1133: end if;
1134: --
1135: end if;

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

1195: p_effective_date => p_effective_date) then
1196: --
1197: -- raise error as does not exist as lookup
1198: --
1199: fnd_message.set_name('BEN', 'BEN_91628_LOOKUP_TYPE_GENERIC');
1200: fnd_message.set_token('FIELD', 'p_cls_enrt_dt_to_use_cd');
1201: fnd_message.set_token('TYPE', 'BEN_CLS_ENRT_DT_TO_USE');
1202: fnd_message.raise_error;
1203: --

Line 1200: fnd_message.set_token('FIELD', 'p_cls_enrt_dt_to_use_cd');

1196: --
1197: -- raise error as does not exist as lookup
1198: --
1199: fnd_message.set_name('BEN', 'BEN_91628_LOOKUP_TYPE_GENERIC');
1200: fnd_message.set_token('FIELD', 'p_cls_enrt_dt_to_use_cd');
1201: fnd_message.set_token('TYPE', 'BEN_CLS_ENRT_DT_TO_USE');
1202: fnd_message.raise_error;
1203: --
1204: end if;

Line 1201: fnd_message.set_token('TYPE', 'BEN_CLS_ENRT_DT_TO_USE');

1197: -- raise error as does not exist as lookup
1198: --
1199: fnd_message.set_name('BEN', 'BEN_91628_LOOKUP_TYPE_GENERIC');
1200: fnd_message.set_token('FIELD', 'p_cls_enrt_dt_to_use_cd');
1201: fnd_message.set_token('TYPE', 'BEN_CLS_ENRT_DT_TO_USE');
1202: fnd_message.raise_error;
1203: --
1204: end if;
1205: --

Line 1202: fnd_message.raise_error;

1198: --
1199: fnd_message.set_name('BEN', 'BEN_91628_LOOKUP_TYPE_GENERIC');
1200: fnd_message.set_token('FIELD', 'p_cls_enrt_dt_to_use_cd');
1201: fnd_message.set_token('TYPE', 'BEN_CLS_ENRT_DT_TO_USE');
1202: fnd_message.raise_error;
1203: --
1204: end if;
1205: --
1206: end if;

Line 1249: fnd_message.set_name('BEN','BEN_91624_CD_RL_2');

1245: hr_utility.set_location('Entering:'||l_proc, 5);
1246: --
1247: if p_code <> 'RL' and p_rule is not null then
1248: --
1249: fnd_message.set_name('BEN','BEN_91624_CD_RL_2');
1250: fnd_message.raise_error;
1251: --
1252: elsif p_code = 'RL' and p_rule is null then
1253: --

Line 1250: fnd_message.raise_error;

1246: --
1247: if p_code <> 'RL' and p_rule is not null then
1248: --
1249: fnd_message.set_name('BEN','BEN_91624_CD_RL_2');
1250: fnd_message.raise_error;
1251: --
1252: elsif p_code = 'RL' and p_rule is null then
1253: --
1254: fnd_message.set_name('BEN','BEN_91623_CD_RL_1');

Line 1254: fnd_message.set_name('BEN','BEN_91623_CD_RL_1');

1250: fnd_message.raise_error;
1251: --
1252: elsif p_code = 'RL' and p_rule is null then
1253: --
1254: fnd_message.set_name('BEN','BEN_91623_CD_RL_1');
1255: fnd_message.raise_error;
1256: --
1257: end if;
1258: --

Line 1255: fnd_message.raise_error;

1251: --
1252: elsif p_code = 'RL' and p_rule is null then
1253: --
1254: fnd_message.set_name('BEN','BEN_91623_CD_RL_1');
1255: fnd_message.raise_error;
1256: --
1257: end if;
1258: --
1259: hr_utility.set_location('Leaving:'||l_proc,10);

Line 1284: fnd_message.set_name('BEN','BEN_94232_CD_NUMBER_OF_DAYS');

1280: any value ( Including zero)
1281: if p_number is not null then -- remove the condition once the plan copy is done
1282: if p_code not in ( 'NUMDOE', 'NUMDON','NUMDOEN') and nvl(p_number,0) <> 0 then
1283: --
1284: fnd_message.set_name('BEN','BEN_94232_CD_NUMBER_OF_DAYS');
1285: fnd_message.raise_error;
1286: --
1287: elsif p_code in ( 'NUMDOE', 'NUMDON','NUMDOEN') and nvl(p_number,0) = 0 then
1288: --

Line 1285: fnd_message.raise_error;

1281: if p_number is not null then -- remove the condition once the plan copy is done
1282: if p_code not in ( 'NUMDOE', 'NUMDON','NUMDOEN') and nvl(p_number,0) <> 0 then
1283: --
1284: fnd_message.set_name('BEN','BEN_94232_CD_NUMBER_OF_DAYS');
1285: fnd_message.raise_error;
1286: --
1287: elsif p_code in ( 'NUMDOE', 'NUMDON','NUMDOEN') and nvl(p_number,0) = 0 then
1288: --
1289: fnd_message.set_name('BEN','BEN_94232_CD_NUMBER_OF_DAYS');

Line 1289: fnd_message.set_name('BEN','BEN_94232_CD_NUMBER_OF_DAYS');

1285: fnd_message.raise_error;
1286: --
1287: elsif p_code in ( 'NUMDOE', 'NUMDON','NUMDOEN') and nvl(p_number,0) = 0 then
1288: --
1289: fnd_message.set_name('BEN','BEN_94232_CD_NUMBER_OF_DAYS');
1290: fnd_message.raise_error;
1291: --
1292: end if;
1293:

Line 1290: fnd_message.raise_error;

1286: --
1287: elsif p_code in ( 'NUMDOE', 'NUMDON','NUMDOEN') and nvl(p_number,0) = 0 then
1288: --
1289: fnd_message.set_name('BEN','BEN_94232_CD_NUMBER_OF_DAYS');
1290: fnd_message.raise_error;
1291: --
1292: end if;
1293:
1294: end if ;

Line 1300: fnd_message.set_name('BEN','BEN_94232_CD_NUMBER_OF_DAYS');

1296:
1297: if p_end_number is not null then -- remove the condition once the plan copy is done
1298: if p_end_code not in ( 'NUMDOE', 'NUMDON','NUMDOEN') and nvl(p_end_number,0) <> 0 then
1299: --
1300: fnd_message.set_name('BEN','BEN_94232_CD_NUMBER_OF_DAYS');
1301: fnd_message.raise_error;
1302: --
1303: elsif p_end_code in ( 'NUMDOE', 'NUMDON','NUMDOEN') and nvl(p_end_number,0) = 0 then
1304: --

Line 1301: fnd_message.raise_error;

1297: if p_end_number is not null then -- remove the condition once the plan copy is done
1298: if p_end_code not in ( 'NUMDOE', 'NUMDON','NUMDOEN') and nvl(p_end_number,0) <> 0 then
1299: --
1300: fnd_message.set_name('BEN','BEN_94232_CD_NUMBER_OF_DAYS');
1301: fnd_message.raise_error;
1302: --
1303: elsif p_end_code in ( 'NUMDOE', 'NUMDON','NUMDOEN') and nvl(p_end_number,0) = 0 then
1304: --
1305: fnd_message.set_name('BEN','BEN_94232_CD_NUMBER_OF_DAYS');

Line 1305: fnd_message.set_name('BEN','BEN_94232_CD_NUMBER_OF_DAYS');

1301: fnd_message.raise_error;
1302: --
1303: elsif p_end_code in ( 'NUMDOE', 'NUMDON','NUMDOEN') and nvl(p_end_number,0) = 0 then
1304: --
1305: fnd_message.set_name('BEN','BEN_94232_CD_NUMBER_OF_DAYS');
1306: fnd_message.raise_error;
1307: --
1308: end if ;
1309: end if;

Line 1306: fnd_message.raise_error;

1302: --
1303: elsif p_end_code in ( 'NUMDOE', 'NUMDON','NUMDOEN') and nvl(p_end_number,0) = 0 then
1304: --
1305: fnd_message.set_name('BEN','BEN_94232_CD_NUMBER_OF_DAYS');
1306: fnd_message.raise_error;
1307: --
1308: end if ;
1309: end if;
1310: */

Line 1315: fnd_message.set_name('BEN','BEN_94233_END_DT_MORE_STRT_DT');

1311: if p_code in ( 'NUMDOE', 'NUMDON','NUMDOEN')
1312: and p_end_code = p_code
1313: and nvl(p_end_number,0) < nvl(p_number,0) then
1314:
1315: fnd_message.set_name('BEN','BEN_94233_END_DT_MORE_STRT_DT');
1316: fnd_message.raise_error;
1317:
1318: end if ;
1319:

Line 1316: fnd_message.raise_error;

1312: and p_end_code = p_code
1313: and nvl(p_end_number,0) < nvl(p_number,0) then
1314:
1315: fnd_message.set_name('BEN','BEN_94233_END_DT_MORE_STRT_DT');
1316: fnd_message.raise_error;
1317:
1318: end if ;
1319:
1320:

Line 1383: fnd_message.set_name ('PAY','VALUE IS NOT UNIQUE');

1379: fetch c_duplicate_ler into l_lee_rsn_id;
1380: if c_duplicate_ler%FOUND then
1381: -- hr_utility.set_location('dupe found:', 5.53);
1382: close c_duplicate_ler;
1383: fnd_message.set_name ('PAY','VALUE IS NOT UNIQUE');
1384: fnd_message.raise_error;
1385: end if;
1386: --hr_utility.set_location('NOT found:', 5.54);
1387: close c_duplicate_ler;

Line 1384: fnd_message.raise_error;

1380: if c_duplicate_ler%FOUND then
1381: -- hr_utility.set_location('dupe found:', 5.53);
1382: close c_duplicate_ler;
1383: fnd_message.set_name ('PAY','VALUE IS NOT UNIQUE');
1384: fnd_message.raise_error;
1385: end if;
1386: --hr_utility.set_location('NOT found:', 5.54);
1387: close c_duplicate_ler;
1388: hr_utility.set_location('Leaving:'||l_proc, 10);

Line 1460: fnd_message.set_name('BEN','BEN_94880_DEFER_FLAG_VALID_LVL');

1456: if l_pl_cd = 'MSTBPGM' then
1457: --
1458: if p_defer_deenrol_flag = 'Y' then
1459: --
1460: fnd_message.set_name('BEN','BEN_94880_DEFER_FLAG_VALID_LVL');
1461: fnd_message.raise_error;
1462: --
1463: end if;
1464: --

Line 1461: fnd_message.raise_error;

1457: --
1458: if p_defer_deenrol_flag = 'Y' then
1459: --
1460: fnd_message.set_name('BEN','BEN_94880_DEFER_FLAG_VALID_LVL');
1461: fnd_message.raise_error;
1462: --
1463: end if;
1464: --
1465: end if;

Line 1526: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');

1522: p_effective_date => p_effective_date) then
1523: --
1524: -- raise error as does not exist as lookup
1525: --
1526: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
1527: fnd_message.raise_error;
1528: --
1529: end if;
1530: --

Line 1527: fnd_message.raise_error;

1523: --
1524: -- raise error as does not exist as lookup
1525: --
1526: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
1527: fnd_message.raise_error;
1528: --
1529: end if;
1530: --
1531: end if;