282: p_effective_date => p_effective_date) then
283: --
284: -- raise error
285: --
286: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
287: fnd_message.set_token('ID',p_rt_strt_dt_rl);
288: fnd_message.set_token('TYPE_ID',-66);
289: fnd_message.raise_error;
290: --
283: --
284: -- raise error
285: --
286: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
287: fnd_message.set_token('ID',p_rt_strt_dt_rl);
288: fnd_message.set_token('TYPE_ID',-66);
289: fnd_message.raise_error;
290: --
291: end if;
284: -- raise error
285: --
286: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
287: fnd_message.set_token('ID',p_rt_strt_dt_rl);
288: fnd_message.set_token('TYPE_ID',-66);
289: fnd_message.raise_error;
290: --
291: end if;
292: --
285: --
286: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
287: fnd_message.set_token('ID',p_rt_strt_dt_rl);
288: fnd_message.set_token('TYPE_ID',-66);
289: fnd_message.raise_error;
290: --
291: end if;
292: --
293: end if;
368: p_effective_date => p_effective_date) then
369: --
370: -- raise error as does not exist as lookup
371: --
372: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
373: fnd_message.set_token('FIELD', p_entr_ann_val_flag);
374: fnd_message.set_token('TYPE','YES_NO');
375: fnd_message.raise_error;
376: --
369: --
370: -- raise error as does not exist as lookup
371: --
372: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
373: fnd_message.set_token('FIELD', p_entr_ann_val_flag);
374: fnd_message.set_token('TYPE','YES_NO');
375: fnd_message.raise_error;
376: --
377: end if;
370: -- raise error as does not exist as lookup
371: --
372: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
373: fnd_message.set_token('FIELD', p_entr_ann_val_flag);
374: fnd_message.set_token('TYPE','YES_NO');
375: fnd_message.raise_error;
376: --
377: end if;
378: --
371: --
372: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
373: fnd_message.set_token('FIELD', p_entr_ann_val_flag);
374: fnd_message.set_token('TYPE','YES_NO');
375: fnd_message.raise_error;
376: --
377: end if;
378: --
379: end if;
392: p_effective_date => p_effective_date) then
393: --
394: -- raise error as does not exist as lookup
395: --
396: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
397: fnd_message.set_token('FIELD', p_ctfn_rqd_flag);
398: fnd_message.set_token('TYPE','YES_NO');
399: fnd_message.raise_error;
400: --
393: --
394: -- raise error as does not exist as lookup
395: --
396: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
397: fnd_message.set_token('FIELD', p_ctfn_rqd_flag);
398: fnd_message.set_token('TYPE','YES_NO');
399: fnd_message.raise_error;
400: --
401: end if;
394: -- raise error as does not exist as lookup
395: --
396: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
397: fnd_message.set_token('FIELD', p_ctfn_rqd_flag);
398: fnd_message.set_token('TYPE','YES_NO');
399: fnd_message.raise_error;
400: --
401: end if;
402: --
395: --
396: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
397: fnd_message.set_token('FIELD', p_ctfn_rqd_flag);
398: fnd_message.set_token('TYPE','YES_NO');
399: fnd_message.raise_error;
400: --
401: end if;
402: --
403: end if;
416: p_effective_date => p_effective_date) then
417: --
418: -- raise error as does not exist as lookup
419: --
420: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
421: fnd_message.set_token('FIELD', p_dflt_flag);
422: fnd_message.set_token('TYPE','YES_NO');
423: fnd_message.raise_error;
424: --
417: --
418: -- raise error as does not exist as lookup
419: --
420: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
421: fnd_message.set_token('FIELD', p_dflt_flag);
422: fnd_message.set_token('TYPE','YES_NO');
423: fnd_message.raise_error;
424: --
425: end if;
418: -- raise error as does not exist as lookup
419: --
420: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
421: fnd_message.set_token('FIELD', p_dflt_flag);
422: fnd_message.set_token('TYPE','YES_NO');
423: fnd_message.raise_error;
424: --
425: end if;
426: --
419: --
420: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
421: fnd_message.set_token('FIELD', p_dflt_flag);
422: fnd_message.set_token('TYPE','YES_NO');
423: fnd_message.raise_error;
424: --
425: end if;
426: --
427: end if;
440: p_effective_date => p_effective_date) then
441: --
442: -- raise error as does not exist as lookup
443: --
444: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
445: fnd_message.set_token('FIELD', p_dflt_pndg_ctfn_flag);
446: fnd_message.set_token('TYPE','YES_NO');
447: fnd_message.raise_error;
448: --
441: --
442: -- raise error as does not exist as lookup
443: --
444: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
445: fnd_message.set_token('FIELD', p_dflt_pndg_ctfn_flag);
446: fnd_message.set_token('TYPE','YES_NO');
447: fnd_message.raise_error;
448: --
449: end if;
442: -- raise error as does not exist as lookup
443: --
444: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
445: fnd_message.set_token('FIELD', p_dflt_pndg_ctfn_flag);
446: fnd_message.set_token('TYPE','YES_NO');
447: fnd_message.raise_error;
448: --
449: end if;
450: --
443: --
444: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
445: fnd_message.set_token('FIELD', p_dflt_pndg_ctfn_flag);
446: fnd_message.set_token('TYPE','YES_NO');
447: fnd_message.raise_error;
448: --
449: end if;
450: --
451: end if;
464: p_effective_date => p_effective_date) then
465: --
466: -- raise error as does not exist as lookup
467: --
468: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
469: fnd_message.set_token('FIELD', p_dsply_on_enrt_flag);
470: fnd_message.set_token('TYPE','YES_NO');
471: fnd_message.raise_error;
472: --
465: --
466: -- raise error as does not exist as lookup
467: --
468: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
469: fnd_message.set_token('FIELD', p_dsply_on_enrt_flag);
470: fnd_message.set_token('TYPE','YES_NO');
471: fnd_message.raise_error;
472: --
473: end if;
466: -- raise error as does not exist as lookup
467: --
468: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
469: fnd_message.set_token('FIELD', p_dsply_on_enrt_flag);
470: fnd_message.set_token('TYPE','YES_NO');
471: fnd_message.raise_error;
472: --
473: end if;
474: --
467: --
468: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
469: fnd_message.set_token('FIELD', p_dsply_on_enrt_flag);
470: fnd_message.set_token('TYPE','YES_NO');
471: fnd_message.raise_error;
472: --
473: end if;
474: --
475: end if;
488: p_effective_date => p_effective_date) then
489: --
490: -- raise error as does not exist as lookup
491: --
492: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
493: fnd_message.set_token('FIELD', p_use_to_calc_net_flx_cr_flag);
494: fnd_message.set_token('TYPE','YES_NO');
495: fnd_message.raise_error;
496: --
489: --
490: -- raise error as does not exist as lookup
491: --
492: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
493: fnd_message.set_token('FIELD', p_use_to_calc_net_flx_cr_flag);
494: fnd_message.set_token('TYPE','YES_NO');
495: fnd_message.raise_error;
496: --
497: end if;
490: -- raise error as does not exist as lookup
491: --
492: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
493: fnd_message.set_token('FIELD', p_use_to_calc_net_flx_cr_flag);
494: fnd_message.set_token('TYPE','YES_NO');
495: fnd_message.raise_error;
496: --
497: end if;
498: --
491: --
492: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
493: fnd_message.set_token('FIELD', p_use_to_calc_net_flx_cr_flag);
494: fnd_message.set_token('TYPE','YES_NO');
495: fnd_message.raise_error;
496: --
497: end if;
498: --
499: end if;
512: p_effective_date => p_effective_date) then
513: --
514: -- raise error as does not exist as lookup
515: --
516: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
517: fnd_message.set_token('FIELD', p_entr_val_at_enrt_flag);
518: fnd_message.set_token('TYPE','YES_NO');
519: fnd_message.raise_error;
520: --
513: --
514: -- raise error as does not exist as lookup
515: --
516: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
517: fnd_message.set_token('FIELD', p_entr_val_at_enrt_flag);
518: fnd_message.set_token('TYPE','YES_NO');
519: fnd_message.raise_error;
520: --
521: end if;
514: -- raise error as does not exist as lookup
515: --
516: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
517: fnd_message.set_token('FIELD', p_entr_val_at_enrt_flag);
518: fnd_message.set_token('TYPE','YES_NO');
519: fnd_message.raise_error;
520: --
521: end if;
522: --
515: --
516: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
517: fnd_message.set_token('FIELD', p_entr_val_at_enrt_flag);
518: fnd_message.set_token('TYPE','YES_NO');
519: fnd_message.raise_error;
520: --
521: end if;
522: --
523: end if;
536: p_effective_date => p_effective_date) then
537: --
538: -- raise error as does not exist as lookup
539: --
540: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
541: fnd_message.set_token('FIELD', p_asn_on_enrt_flag);
542: fnd_message.set_token('TYPE','YES_NO');
543: fnd_message.raise_error;
544: --
537: --
538: -- raise error as does not exist as lookup
539: --
540: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
541: fnd_message.set_token('FIELD', p_asn_on_enrt_flag);
542: fnd_message.set_token('TYPE','YES_NO');
543: fnd_message.raise_error;
544: --
545: end if;
538: -- raise error as does not exist as lookup
539: --
540: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
541: fnd_message.set_token('FIELD', p_asn_on_enrt_flag);
542: fnd_message.set_token('TYPE','YES_NO');
543: fnd_message.raise_error;
544: --
545: end if;
546: --
539: --
540: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
541: fnd_message.set_token('FIELD', p_asn_on_enrt_flag);
542: fnd_message.set_token('TYPE','YES_NO');
543: fnd_message.raise_error;
544: --
545: end if;
546: --
547: end if;
560: p_effective_date => p_effective_date) then
561: --
562: -- raise error as does not exist as lookup
563: --
564: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
565: fnd_message.set_token('FIELD', p_rl_crs_only_flag);
566: fnd_message.set_token('TYPE','YES_NO');
567: fnd_message.raise_error;
568: --
561: --
562: -- raise error as does not exist as lookup
563: --
564: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
565: fnd_message.set_token('FIELD', p_rl_crs_only_flag);
566: fnd_message.set_token('TYPE','YES_NO');
567: fnd_message.raise_error;
568: --
569: end if;
562: -- raise error as does not exist as lookup
563: --
564: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
565: fnd_message.set_token('FIELD', p_rl_crs_only_flag);
566: fnd_message.set_token('TYPE','YES_NO');
567: fnd_message.raise_error;
568: --
569: end if;
570: --
563: --
564: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
565: fnd_message.set_token('FIELD', p_rl_crs_only_flag);
566: fnd_message.set_token('TYPE','YES_NO');
567: fnd_message.raise_error;
568: --
569: end if;
570: --
571: end if;
635: p_effective_date => p_effective_date) then
636: --
637: -- raise error as does not exist as lookup
638: --
639: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
640: fnd_message.set_token('FIELD', p_acty_typ_cd);
641: fnd_message.set_token('TYPE','BEN_ACTY_TYP');
642: fnd_message.raise_error;
643: --
636: --
637: -- raise error as does not exist as lookup
638: --
639: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
640: fnd_message.set_token('FIELD', p_acty_typ_cd);
641: fnd_message.set_token('TYPE','BEN_ACTY_TYP');
642: fnd_message.raise_error;
643: --
644: end if;
637: -- raise error as does not exist as lookup
638: --
639: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
640: fnd_message.set_token('FIELD', p_acty_typ_cd);
641: fnd_message.set_token('TYPE','BEN_ACTY_TYP');
642: fnd_message.raise_error;
643: --
644: end if;
645: --
638: --
639: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
640: fnd_message.set_token('FIELD', p_acty_typ_cd);
641: fnd_message.set_token('TYPE','BEN_ACTY_TYP');
642: fnd_message.raise_error;
643: --
644: end if;
645: --
646: end if;
658: p_effective_date => p_effective_date) then
659: --
660: -- raise error as does not exist as lookup
661: --
662: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
663: fnd_message.set_token('FIELD', p_tx_typ_cd);
664: fnd_message.set_token('TYPE','BEN_TX_TYP');
665: fnd_message.raise_error;
666: --
659: --
660: -- raise error as does not exist as lookup
661: --
662: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
663: fnd_message.set_token('FIELD', p_tx_typ_cd);
664: fnd_message.set_token('TYPE','BEN_TX_TYP');
665: fnd_message.raise_error;
666: --
667: end if;
660: -- raise error as does not exist as lookup
661: --
662: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
663: fnd_message.set_token('FIELD', p_tx_typ_cd);
664: fnd_message.set_token('TYPE','BEN_TX_TYP');
665: fnd_message.raise_error;
666: --
667: end if;
668: --
661: --
662: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
663: fnd_message.set_token('FIELD', p_tx_typ_cd);
664: fnd_message.set_token('TYPE','BEN_TX_TYP');
665: fnd_message.raise_error;
666: --
667: end if;
668: --
669: end if;
682: p_effective_date => p_effective_date) then
683: --
684: -- raise error as does not exist as lookup
685: --
686: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
687: fnd_message.set_token('FIELD', p_nnmntry_uom);
688: fnd_message.set_token('TYPE','BEN_NNMNTRY_UOM');
689: fnd_message.raise_error;
690: --
683: --
684: -- raise error as does not exist as lookup
685: --
686: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
687: fnd_message.set_token('FIELD', p_nnmntry_uom);
688: fnd_message.set_token('TYPE','BEN_NNMNTRY_UOM');
689: fnd_message.raise_error;
690: --
691: end if;
684: -- raise error as does not exist as lookup
685: --
686: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
687: fnd_message.set_token('FIELD', p_nnmntry_uom);
688: fnd_message.set_token('TYPE','BEN_NNMNTRY_UOM');
689: fnd_message.raise_error;
690: --
691: end if;
692: --
685: --
686: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
687: fnd_message.set_token('FIELD', p_nnmntry_uom);
688: fnd_message.set_token('TYPE','BEN_NNMNTRY_UOM');
689: fnd_message.raise_error;
690: --
691: end if;
692: --
693: end if;
706: p_effective_date => p_effective_date) then
707: --
708: -- raise error as does not exist as lookup
709: --
710: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
711: fnd_message.set_token('FIELD', p_cmcd_acty_ref_perd_cd);
712: fnd_message.set_token('TYPE','BEN_ENRT_INFO_RT_FREQ');
713: fnd_message.raise_error;
714: --
707: --
708: -- raise error as does not exist as lookup
709: --
710: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
711: fnd_message.set_token('FIELD', p_cmcd_acty_ref_perd_cd);
712: fnd_message.set_token('TYPE','BEN_ENRT_INFO_RT_FREQ');
713: fnd_message.raise_error;
714: --
715: end if;
708: -- raise error as does not exist as lookup
709: --
710: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
711: fnd_message.set_token('FIELD', p_cmcd_acty_ref_perd_cd);
712: fnd_message.set_token('TYPE','BEN_ENRT_INFO_RT_FREQ');
713: fnd_message.raise_error;
714: --
715: end if;
716: --
709: --
710: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
711: fnd_message.set_token('FIELD', p_cmcd_acty_ref_perd_cd);
712: fnd_message.set_token('TYPE','BEN_ENRT_INFO_RT_FREQ');
713: fnd_message.raise_error;
714: --
715: end if;
716: --
717: end if;
922: close csr_leg_code;
923: --
924: -- The primary key is invalid therefore we must error
925: --
926: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
927: fnd_message.raise_error;
928: --
929: end if;
930: --
923: --
924: -- The primary key is invalid therefore we must error
925: --
926: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
927: fnd_message.raise_error;
928: --
929: end if;
930: --
931: close csr_leg_code;