364: p_effective_date => p_effective_date) then
365: --
366: -- raise error as does not exist as lookup
367: --
368: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
369: fnd_message.set_token('FIELD','p_dltd_flag');
370: fnd_message.set_token('TYPE','YES_NO');
371: fnd_message.raise_error;
372: --
365: --
366: -- raise error as does not exist as lookup
367: --
368: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
369: fnd_message.set_token('FIELD','p_dltd_flag');
370: fnd_message.set_token('TYPE','YES_NO');
371: fnd_message.raise_error;
372: --
373: end if;
366: -- raise error as does not exist as lookup
367: --
368: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
369: fnd_message.set_token('FIELD','p_dltd_flag');
370: fnd_message.set_token('TYPE','YES_NO');
371: fnd_message.raise_error;
372: --
373: end if;
374: --
367: --
368: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
369: fnd_message.set_token('FIELD','p_dltd_flag');
370: fnd_message.set_token('TYPE','YES_NO');
371: fnd_message.raise_error;
372: --
373: end if;
374: --
375: end if;
434: p_effective_date => p_effective_date) then
435: --
436: -- raise error as does not exist as lookup
437: --
438: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
439: fnd_message.set_token('FIELD','p_tmprl_flag');
440: fnd_message.set_token('TYPE','YES_NO');
441: fnd_message.raise_error;
442: --
435: --
436: -- raise error as does not exist as lookup
437: --
438: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
439: fnd_message.set_token('FIELD','p_tmprl_flag');
440: fnd_message.set_token('TYPE','YES_NO');
441: fnd_message.raise_error;
442: --
443: end if;
436: -- raise error as does not exist as lookup
437: --
438: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
439: fnd_message.set_token('FIELD','p_tmprl_flag');
440: fnd_message.set_token('TYPE','YES_NO');
441: fnd_message.raise_error;
442: --
443: end if;
444: --
437: --
438: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
439: fnd_message.set_token('FIELD','p_tmprl_flag');
440: fnd_message.set_token('TYPE','YES_NO');
441: fnd_message.raise_error;
442: --
443: end if;
444: --
445: end if;
504: p_effective_date => p_effective_date) then
505: --
506: -- raise error as does not exist as lookup
507: --
508: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
509: fnd_message.set_token('FIELD','p_crtd_flag');
510: fnd_message.set_token('TYPE','YES_NO');
511: fnd_message.raise_error;
512: --
505: --
506: -- raise error as does not exist as lookup
507: --
508: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
509: fnd_message.set_token('FIELD','p_crtd_flag');
510: fnd_message.set_token('TYPE','YES_NO');
511: fnd_message.raise_error;
512: --
513: end if;
506: -- raise error as does not exist as lookup
507: --
508: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
509: fnd_message.set_token('FIELD','p_crtd_flag');
510: fnd_message.set_token('TYPE','YES_NO');
511: fnd_message.raise_error;
512: --
513: end if;
514: --
507: --
508: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
509: fnd_message.set_token('FIELD','p_crtd_flag');
510: fnd_message.set_token('TYPE','YES_NO');
511: fnd_message.raise_error;
512: --
513: end if;
514: --
515: end if;
574: p_effective_date => p_effective_date) then
575: --
576: -- raise error as does not exist as lookup
577: --
578: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
579: fnd_message.set_token('FIELD','p_clpsd_flag');
580: fnd_message.set_token('TYPE','YES_NO');
581: fnd_message.raise_error;
582: --
575: --
576: -- raise error as does not exist as lookup
577: --
578: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
579: fnd_message.set_token('FIELD','p_clpsd_flag');
580: fnd_message.set_token('TYPE','YES_NO');
581: fnd_message.raise_error;
582: --
583: end if;
576: -- raise error as does not exist as lookup
577: --
578: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
579: fnd_message.set_token('FIELD','p_clpsd_flag');
580: fnd_message.set_token('TYPE','YES_NO');
581: fnd_message.raise_error;
582: --
583: end if;
584: --
577: --
578: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
579: fnd_message.set_token('FIELD','p_clpsd_flag');
580: fnd_message.set_token('TYPE','YES_NO');
581: fnd_message.raise_error;
582: --
583: end if;
584: --
585: end if;
643: p_effective_date => p_effective_date) then
644: --
645: -- raise error as does not exist as lookup
646: --
647: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
648: fnd_message.set_token('FIELD','p_clsn_flag');
649: fnd_message.set_token('TYPE','YES_NO');
650: fnd_message.raise_error;
651: --
644: --
645: -- raise error as does not exist as lookup
646: --
647: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
648: fnd_message.set_token('FIELD','p_clsn_flag');
649: fnd_message.set_token('TYPE','YES_NO');
650: fnd_message.raise_error;
651: --
652: end if;
645: -- raise error as does not exist as lookup
646: --
647: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
648: fnd_message.set_token('FIELD','p_clsn_flag');
649: fnd_message.set_token('TYPE','YES_NO');
650: fnd_message.raise_error;
651: --
652: end if;
653: --
646: --
647: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
648: fnd_message.set_token('FIELD','p_clsn_flag');
649: fnd_message.set_token('TYPE','YES_NO');
650: fnd_message.raise_error;
651: --
652: end if;
653: --
654: end if;
712: p_effective_date => p_effective_date) then
713: --
714: -- raise error as does not exist as lookup
715: --
716: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
717: fnd_message.set_token('FIELD','p_no_effect_flag');
718: fnd_message.set_token('TYPE','YES_NO');
719: fnd_message.raise_error;
720: --
713: --
714: -- raise error as does not exist as lookup
715: --
716: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
717: fnd_message.set_token('FIELD','p_no_effect_flag');
718: fnd_message.set_token('TYPE','YES_NO');
719: fnd_message.raise_error;
720: --
721: end if;
714: -- raise error as does not exist as lookup
715: --
716: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
717: fnd_message.set_token('FIELD','p_no_effect_flag');
718: fnd_message.set_token('TYPE','YES_NO');
719: fnd_message.raise_error;
720: --
721: end if;
722: --
715: --
716: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
717: fnd_message.set_token('FIELD','p_no_effect_flag');
718: fnd_message.set_token('TYPE','YES_NO');
719: fnd_message.raise_error;
720: --
721: end if;
722: --
723: end if;
781: p_effective_date => p_effective_date) then
782: --
783: -- raise error as does not exist as lookup
784: --
785: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
786: fnd_message.set_token('FIELD','p_cvrge_rt_prem_flag');
787: fnd_message.set_token('TYPE','YES_NO');
788: fnd_message.raise_error;
789: --
782: --
783: -- raise error as does not exist as lookup
784: --
785: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
786: fnd_message.set_token('FIELD','p_cvrge_rt_prem_flag');
787: fnd_message.set_token('TYPE','YES_NO');
788: fnd_message.raise_error;
789: --
790: end if;
783: -- raise error as does not exist as lookup
784: --
785: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
786: fnd_message.set_token('FIELD','p_cvrge_rt_prem_flag');
787: fnd_message.set_token('TYPE','YES_NO');
788: fnd_message.raise_error;
789: --
790: end if;
791: --
784: --
785: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
786: fnd_message.set_token('FIELD','p_cvrge_rt_prem_flag');
787: fnd_message.set_token('TYPE','YES_NO');
788: fnd_message.raise_error;
789: --
790: end if;
791: --
792: end if;
850: p_effective_date => p_effective_date) then
851: --
852: -- raise error as does not exist as lookup
853: --
854: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
855: fnd_message.set_token('FIELD','p_replcd_flag');
856: fnd_message.set_token('TYPE','YES_NO');
857: fnd_message.raise_error;
858: --
851: --
852: -- raise error as does not exist as lookup
853: --
854: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
855: fnd_message.set_token('FIELD','p_replcd_flag');
856: fnd_message.set_token('TYPE','YES_NO');
857: fnd_message.raise_error;
858: --
859: end if;
852: -- raise error as does not exist as lookup
853: --
854: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
855: fnd_message.set_token('FIELD','p_replcd_flag');
856: fnd_message.set_token('TYPE','YES_NO');
857: fnd_message.raise_error;
858: --
859: end if;
860: --
853: --
854: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
855: fnd_message.set_token('FIELD','p_replcd_flag');
856: fnd_message.set_token('TYPE','YES_NO');
857: fnd_message.raise_error;
858: --
859: end if;
860: --
861: end if;
920: p_effective_date => p_effective_date) then
921: --
922: -- raise error as does not exist as lookup
923: --
924: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
925: fnd_message.set_token('FIELD','p_open_and_clsd_flag');
926: fnd_message.set_token('TYPE','YES_NO');
927: fnd_message.raise_error;
928: --
921: --
922: -- raise error as does not exist as lookup
923: --
924: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
925: fnd_message.set_token('FIELD','p_open_and_clsd_flag');
926: fnd_message.set_token('TYPE','YES_NO');
927: fnd_message.raise_error;
928: --
929: end if;
922: -- raise error as does not exist as lookup
923: --
924: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
925: fnd_message.set_token('FIELD','p_open_and_clsd_flag');
926: fnd_message.set_token('TYPE','YES_NO');
927: fnd_message.raise_error;
928: --
929: end if;
930: --
923: --
924: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
925: fnd_message.set_token('FIELD','p_open_and_clsd_flag');
926: fnd_message.set_token('TYPE','YES_NO');
927: fnd_message.raise_error;
928: --
929: end if;
930: --
931: end if;
989: p_effective_date => p_effective_date) then
990: --
991: -- raise error as does not exist as lookup
992: --
993: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
994: fnd_message.set_token('FIELD','p_clsd_flag');
995: fnd_message.set_token('TYPE','YES_NO');
996: fnd_message.raise_error;
997: --
990: --
991: -- raise error as does not exist as lookup
992: --
993: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
994: fnd_message.set_token('FIELD','p_clsd_flag');
995: fnd_message.set_token('TYPE','YES_NO');
996: fnd_message.raise_error;
997: --
998: end if;
991: -- raise error as does not exist as lookup
992: --
993: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
994: fnd_message.set_token('FIELD','p_clsd_flag');
995: fnd_message.set_token('TYPE','YES_NO');
996: fnd_message.raise_error;
997: --
998: end if;
999: --
992: --
993: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
994: fnd_message.set_token('FIELD','p_clsd_flag');
995: fnd_message.set_token('TYPE','YES_NO');
996: fnd_message.raise_error;
997: --
998: end if;
999: --
1000: end if;
1058: p_effective_date => p_effective_date) then
1059: --
1060: -- raise error as does not exist as lookup
1061: --
1062: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1063: fnd_message.set_token('FIELD','p_not_crtd_flag');
1064: fnd_message.set_token('TYPE','YES_NO');
1065: fnd_message.raise_error;
1066: --
1059: --
1060: -- raise error as does not exist as lookup
1061: --
1062: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1063: fnd_message.set_token('FIELD','p_not_crtd_flag');
1064: fnd_message.set_token('TYPE','YES_NO');
1065: fnd_message.raise_error;
1066: --
1067: end if;
1060: -- raise error as does not exist as lookup
1061: --
1062: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1063: fnd_message.set_token('FIELD','p_not_crtd_flag');
1064: fnd_message.set_token('TYPE','YES_NO');
1065: fnd_message.raise_error;
1066: --
1067: end if;
1068: --
1061: --
1062: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1063: fnd_message.set_token('FIELD','p_not_crtd_flag');
1064: fnd_message.set_token('TYPE','YES_NO');
1065: fnd_message.raise_error;
1066: --
1067: end if;
1068: --
1069: end if;
1127: p_effective_date => p_effective_date) then
1128: --
1129: -- raise error as does not exist as lookup
1130: --
1131: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1132: fnd_message.set_token('FIELD','p_stl_actv_flag');
1133: fnd_message.set_token('TYPE','YES_NO');
1134: fnd_message.raise_error;
1135: --
1128: --
1129: -- raise error as does not exist as lookup
1130: --
1131: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1132: fnd_message.set_token('FIELD','p_stl_actv_flag');
1133: fnd_message.set_token('TYPE','YES_NO');
1134: fnd_message.raise_error;
1135: --
1136: end if;
1129: -- raise error as does not exist as lookup
1130: --
1131: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1132: fnd_message.set_token('FIELD','p_stl_actv_flag');
1133: fnd_message.set_token('TYPE','YES_NO');
1134: fnd_message.raise_error;
1135: --
1136: end if;
1137: --
1130: --
1131: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1132: fnd_message.set_token('FIELD','p_stl_actv_flag');
1133: fnd_message.set_token('TYPE','YES_NO');
1134: fnd_message.raise_error;
1135: --
1136: end if;
1137: --
1138: end if;