50: close csr_sec_grp;
51: --
52: -- The primary key is invalid therefore we must error
53: --
54: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
55: fnd_message.raise_error;
56: --
57: end if;
58: close csr_sec_grp;
51: --
52: -- The primary key is invalid therefore we must error
53: --
54: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
55: fnd_message.raise_error;
56: --
57: end if;
58: close csr_sec_grp;
59: --
329: (p_ext_dfn_id => p_ext_dfn_id,
330: p_object_version_number => p_object_version_number);
331: --
332: if p_data_typ_cd is null then
333: fnd_message.set_name('BEN','BEN_91784_DATA_NULL');
334: fnd_message.raise_error;
335: end if;
336: if (l_api_updating
337: and p_data_typ_cd
330: p_object_version_number => p_object_version_number);
331: --
332: if p_data_typ_cd is null then
333: fnd_message.set_name('BEN','BEN_91784_DATA_NULL');
334: fnd_message.raise_error;
335: end if;
336: if (l_api_updating
337: and p_data_typ_cd
338: <> nvl(ben_xdf_shd.g_old_rec.data_typ_cd,hr_api.g_varchar2)
350: p_effective_date => p_effective_date) then
351: --
352: -- raise error as does not exist as lookup
353: --
354: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
355: fnd_message.set_token('FIELD','p_data_typ_cd');
356: fnd_message.set_token('TYPE','BEN_EXT_DATA_TYP');
357: fnd_message.raise_error;
358: --
351: --
352: -- raise error as does not exist as lookup
353: --
354: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
355: fnd_message.set_token('FIELD','p_data_typ_cd');
356: fnd_message.set_token('TYPE','BEN_EXT_DATA_TYP');
357: fnd_message.raise_error;
358: --
359: end if;
352: -- raise error as does not exist as lookup
353: --
354: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
355: fnd_message.set_token('FIELD','p_data_typ_cd');
356: fnd_message.set_token('TYPE','BEN_EXT_DATA_TYP');
357: fnd_message.raise_error;
358: --
359: end if;
360: --
353: --
354: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
355: fnd_message.set_token('FIELD','p_data_typ_cd');
356: fnd_message.set_token('TYPE','BEN_EXT_DATA_TYP');
357: fnd_message.raise_error;
358: --
359: end if;
360: --
361: else
366: p_effective_date => p_effective_date) then
367: --
368: -- raise error as does not exist as lookup
369: --
370: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
371: fnd_message.set_token('FIELD','p_data_typ_cd');
372: fnd_message.set_token('TYPE','BEN_EXT_DATA_TYP');
373: fnd_message.raise_error;
374: --
367: --
368: -- raise error as does not exist as lookup
369: --
370: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
371: fnd_message.set_token('FIELD','p_data_typ_cd');
372: fnd_message.set_token('TYPE','BEN_EXT_DATA_TYP');
373: fnd_message.raise_error;
374: --
375: end if;
368: -- raise error as does not exist as lookup
369: --
370: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
371: fnd_message.set_token('FIELD','p_data_typ_cd');
372: fnd_message.set_token('TYPE','BEN_EXT_DATA_TYP');
373: fnd_message.raise_error;
374: --
375: end if;
376: --
369: --
370: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
371: fnd_message.set_token('FIELD','p_data_typ_cd');
372: fnd_message.set_token('TYPE','BEN_EXT_DATA_TYP');
373: fnd_message.raise_error;
374: --
375: end if;
376: --
377: end if;
377: end if;
378: --
379: if p_data_typ_cd = 'C' then
380: if p_ext_crit_prfl_id is null then
381: fnd_message.set_name('BEN','BEN_91782_EXT_CRIT_PRFL_NULL');
382: fnd_message.raise_error;
383: end if;
384: end if;
385: end if;
378: --
379: if p_data_typ_cd = 'C' then
380: if p_ext_crit_prfl_id is null then
381: fnd_message.set_name('BEN','BEN_91782_EXT_CRIT_PRFL_NULL');
382: fnd_message.raise_error;
383: end if;
384: end if;
385: end if;
386: --
449: p_effective_date => p_effective_date) then
450: --
451: -- raise error as does not exist as lookup
452: --
453: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
454: fnd_message.set_token('FIELD','p_apnd_rqst_id_flag');
455: fnd_message.set_token('TYPE','YES_NO');
456: fnd_message.raise_error;
457: --
450: --
451: -- raise error as does not exist as lookup
452: --
453: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
454: fnd_message.set_token('FIELD','p_apnd_rqst_id_flag');
455: fnd_message.set_token('TYPE','YES_NO');
456: fnd_message.raise_error;
457: --
458: end if;
451: -- raise error as does not exist as lookup
452: --
453: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
454: fnd_message.set_token('FIELD','p_apnd_rqst_id_flag');
455: fnd_message.set_token('TYPE','YES_NO');
456: fnd_message.raise_error;
457: --
458: end if;
459: --
452: --
453: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
454: fnd_message.set_token('FIELD','p_apnd_rqst_id_flag');
455: fnd_message.set_token('TYPE','YES_NO');
456: fnd_message.raise_error;
457: --
458: end if;
459: --
460: else
465: p_effective_date => p_effective_date) then
466: --
467: -- raise error as does not exist as lookup
468: --
469: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
470: fnd_message.set_token('FIELD','p_apnd_rqst_id_flag');
471: fnd_message.set_token('TYPE','YES_NO');
472: fnd_message.raise_error;
473: --
466: --
467: -- raise error as does not exist as lookup
468: --
469: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
470: fnd_message.set_token('FIELD','p_apnd_rqst_id_flag');
471: fnd_message.set_token('TYPE','YES_NO');
472: fnd_message.raise_error;
473: --
474: end if;
467: -- raise error as does not exist as lookup
468: --
469: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
470: fnd_message.set_token('FIELD','p_apnd_rqst_id_flag');
471: fnd_message.set_token('TYPE','YES_NO');
472: fnd_message.raise_error;
473: --
474: end if;
475: --
468: --
469: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
470: fnd_message.set_token('FIELD','p_apnd_rqst_id_flag');
471: fnd_message.set_token('TYPE','YES_NO');
472: fnd_message.raise_error;
473: --
474: end if;
475: --
476: end if;
479: end if;
480:
481: if p_apnd_rqst_id_flag = 'Y' then
482: if p_output_name is null then
483: fnd_message.set_name('BEN','BEN_91774_OUTPUT_NAME_NULL');
484: fnd_message.raise_error;
485: end if;
486: end if;
487:
480:
481: if p_apnd_rqst_id_flag = 'Y' then
482: if p_output_name is null then
483: fnd_message.set_name('BEN','BEN_91774_OUTPUT_NAME_NULL');
484: fnd_message.raise_error;
485: end if;
486: end if;
487:
488: --
548: p_effective_date => p_effective_date) then
549: --
550: -- raise error as does not exist as lookup
551: --
552: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
553: fnd_message.set_token('FIELD','p_kickoff_wrt_prc_flag');
554: fnd_message.set_token('TYPE','YES_NO');
555: fnd_message.raise_error;
556: --
549: --
550: -- raise error as does not exist as lookup
551: --
552: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
553: fnd_message.set_token('FIELD','p_kickoff_wrt_prc_flag');
554: fnd_message.set_token('TYPE','YES_NO');
555: fnd_message.raise_error;
556: --
557: end if;
550: -- raise error as does not exist as lookup
551: --
552: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
553: fnd_message.set_token('FIELD','p_kickoff_wrt_prc_flag');
554: fnd_message.set_token('TYPE','YES_NO');
555: fnd_message.raise_error;
556: --
557: end if;
558: --
551: --
552: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
553: fnd_message.set_token('FIELD','p_kickoff_wrt_prc_flag');
554: fnd_message.set_token('TYPE','YES_NO');
555: fnd_message.raise_error;
556: --
557: end if;
558: --
559: else
564: p_effective_date => p_effective_date) then
565: --
566: -- raise error as does not exist as lookup
567: --
568: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
569: fnd_message.set_token('FIELD','p_kickoff_wrt_prc_flag');
570: fnd_message.set_token('TYPE','YES_NO');
571: fnd_message.raise_error;
572: --
565: --
566: -- raise error as does not exist as lookup
567: --
568: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
569: fnd_message.set_token('FIELD','p_kickoff_wrt_prc_flag');
570: fnd_message.set_token('TYPE','YES_NO');
571: fnd_message.raise_error;
572: --
573: end if;
566: -- raise error as does not exist as lookup
567: --
568: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
569: fnd_message.set_token('FIELD','p_kickoff_wrt_prc_flag');
570: fnd_message.set_token('TYPE','YES_NO');
571: fnd_message.raise_error;
572: --
573: end if;
574: --
567: --
568: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
569: fnd_message.set_token('FIELD','p_kickoff_wrt_prc_flag');
570: fnd_message.set_token('TYPE','YES_NO');
571: fnd_message.raise_error;
572: --
573: end if;
574: --
575: end if;
637: p_effective_date => p_effective_date) then
638: --
639: -- raise error as does not exist as lookup
640: --
641: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
642: fnd_message.set_token('FIELD','p_spcl_hndl_flag');
643: fnd_message.set_token('TYPE','YES_NO');
644: fnd_message.raise_error;
645: --
638: --
639: -- raise error as does not exist as lookup
640: --
641: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
642: fnd_message.set_token('FIELD','p_spcl_hndl_flag');
643: fnd_message.set_token('TYPE','YES_NO');
644: fnd_message.raise_error;
645: --
646: end if;
639: -- raise error as does not exist as lookup
640: --
641: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
642: fnd_message.set_token('FIELD','p_spcl_hndl_flag');
643: fnd_message.set_token('TYPE','YES_NO');
644: fnd_message.raise_error;
645: --
646: end if;
647: --
640: --
641: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
642: fnd_message.set_token('FIELD','p_spcl_hndl_flag');
643: fnd_message.set_token('TYPE','YES_NO');
644: fnd_message.raise_error;
645: --
646: end if;
647: --
648: else
653: p_effective_date => p_effective_date) then
654: --
655: -- raise error as does not exist as lookup
656: --
657: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
658: fnd_message.set_token('FIELD','p_spcl_hndl_flag');
659: fnd_message.set_token('TYPE','YES_NO');
660: fnd_message.raise_error;
661: --
654: --
655: -- raise error as does not exist as lookup
656: --
657: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
658: fnd_message.set_token('FIELD','p_spcl_hndl_flag');
659: fnd_message.set_token('TYPE','YES_NO');
660: fnd_message.raise_error;
661: --
662: end if;
655: -- raise error as does not exist as lookup
656: --
657: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
658: fnd_message.set_token('FIELD','p_spcl_hndl_flag');
659: fnd_message.set_token('TYPE','YES_NO');
660: fnd_message.raise_error;
661: --
662: end if;
663: --
656: --
657: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
658: fnd_message.set_token('FIELD','p_spcl_hndl_flag');
659: fnd_message.set_token('TYPE','YES_NO');
660: fnd_message.raise_error;
661: --
662: end if;
663: --
664: end if;
704: p_effective_date => p_effective_date) then
705: --
706: -- raise error as does not exist as lookup
707: --
708: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
709: fnd_message.set_token('FIELD','p_ext_global_flag');
710: fnd_message.set_token('TYPE','YES_NO');
711: fnd_message.raise_error;
712: --
705: --
706: -- raise error as does not exist as lookup
707: --
708: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
709: fnd_message.set_token('FIELD','p_ext_global_flag');
710: fnd_message.set_token('TYPE','YES_NO');
711: fnd_message.raise_error;
712: --
713: end if;
706: -- raise error as does not exist as lookup
707: --
708: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
709: fnd_message.set_token('FIELD','p_ext_global_flag');
710: fnd_message.set_token('TYPE','YES_NO');
711: fnd_message.raise_error;
712: --
713: end if;
714: --
707: --
708: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
709: fnd_message.set_token('FIELD','p_ext_global_flag');
710: fnd_message.set_token('TYPE','YES_NO');
711: fnd_message.raise_error;
712: --
713: end if;
714: --
715: else
720: p_effective_date => p_effective_date) then
721: --
722: -- raise error as does not exist as lookup
723: --
724: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
725: fnd_message.set_token('FIELD','p_ext_global_flag');
726: fnd_message.set_token('TYPE','YES_NO');
727: fnd_message.raise_error;
728: --
721: --
722: -- raise error as does not exist as lookup
723: --
724: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
725: fnd_message.set_token('FIELD','p_ext_global_flag');
726: fnd_message.set_token('TYPE','YES_NO');
727: fnd_message.raise_error;
728: --
729: end if;
722: -- raise error as does not exist as lookup
723: --
724: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
725: fnd_message.set_token('FIELD','p_ext_global_flag');
726: fnd_message.set_token('TYPE','YES_NO');
727: fnd_message.raise_error;
728: --
729: end if;
730: --
723: --
724: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
725: fnd_message.set_token('FIELD','p_ext_global_flag');
726: fnd_message.set_token('TYPE','YES_NO');
727: fnd_message.raise_error;
728: --
729: end if;
730: --
731: end if;
771: p_effective_date => p_effective_date) then
772: --
773: -- raise error as does not exist as lookup
774: --
775: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
776: fnd_message.set_token('FIELD','p_cm_display_flag');
777: fnd_message.set_token('TYPE','YES_NO');
778: fnd_message.raise_error;
779: --
772: --
773: -- raise error as does not exist as lookup
774: --
775: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
776: fnd_message.set_token('FIELD','p_cm_display_flag');
777: fnd_message.set_token('TYPE','YES_NO');
778: fnd_message.raise_error;
779: --
780: end if;
773: -- raise error as does not exist as lookup
774: --
775: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
776: fnd_message.set_token('FIELD','p_cm_display_flag');
777: fnd_message.set_token('TYPE','YES_NO');
778: fnd_message.raise_error;
779: --
780: end if;
781: --
774: --
775: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
776: fnd_message.set_token('FIELD','p_cm_display_flag');
777: fnd_message.set_token('TYPE','YES_NO');
778: fnd_message.raise_error;
779: --
780: end if;
781: --
782: else
787: p_effective_date => p_effective_date) then
788: --
789: -- raise error as does not exist as lookup
790: --
791: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
792: fnd_message.set_token('FIELD','cm_display_flag');
793: fnd_message.set_token('TYPE','YES_NO');
794: fnd_message.raise_error;
795: --
788: --
789: -- raise error as does not exist as lookup
790: --
791: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
792: fnd_message.set_token('FIELD','cm_display_flag');
793: fnd_message.set_token('TYPE','YES_NO');
794: fnd_message.raise_error;
795: --
796: end if;
789: -- raise error as does not exist as lookup
790: --
791: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
792: fnd_message.set_token('FIELD','cm_display_flag');
793: fnd_message.set_token('TYPE','YES_NO');
794: fnd_message.raise_error;
795: --
796: end if;
797: --
790: --
791: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
792: fnd_message.set_token('FIELD','cm_display_flag');
793: fnd_message.set_token('TYPE','YES_NO');
794: fnd_message.raise_error;
795: --
796: end if;
797: --
798: end if;
861: p_effective_date => p_effective_date) then
862: --
863: -- raise error as does not exist as lookup
864: --
865: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
866: fnd_message.set_token('FIELD','p_upd_cm_sent_dt_flag');
867: fnd_message.set_token('TYPE','YES_NO');
868: fnd_message.raise_error;
869: --
862: --
863: -- raise error as does not exist as lookup
864: --
865: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
866: fnd_message.set_token('FIELD','p_upd_cm_sent_dt_flag');
867: fnd_message.set_token('TYPE','YES_NO');
868: fnd_message.raise_error;
869: --
870: end if;
863: -- raise error as does not exist as lookup
864: --
865: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
866: fnd_message.set_token('FIELD','p_upd_cm_sent_dt_flag');
867: fnd_message.set_token('TYPE','YES_NO');
868: fnd_message.raise_error;
869: --
870: end if;
871: --
864: --
865: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
866: fnd_message.set_token('FIELD','p_upd_cm_sent_dt_flag');
867: fnd_message.set_token('TYPE','YES_NO');
868: fnd_message.raise_error;
869: --
870: end if;
871: --
872: else
877: p_effective_date => p_effective_date) then
878: --
879: -- raise error as does not exist as lookup
880: --
881: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
882: fnd_message.set_token('FIELD','p_upd_cm_sent_dt_flag');
883: fnd_message.set_token('TYPE','YES_NO');
884: fnd_message.raise_error;
885: --
878: --
879: -- raise error as does not exist as lookup
880: --
881: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
882: fnd_message.set_token('FIELD','p_upd_cm_sent_dt_flag');
883: fnd_message.set_token('TYPE','YES_NO');
884: fnd_message.raise_error;
885: --
886: end if;
879: -- raise error as does not exist as lookup
880: --
881: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
882: fnd_message.set_token('FIELD','p_upd_cm_sent_dt_flag');
883: fnd_message.set_token('TYPE','YES_NO');
884: fnd_message.raise_error;
885: --
886: end if;
887: --
880: --
881: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
882: fnd_message.set_token('FIELD','p_upd_cm_sent_dt_flag');
883: fnd_message.set_token('TYPE','YES_NO');
884: fnd_message.raise_error;
885: --
886: end if;
887: --
888: end if;
951: p_effective_date => p_effective_date) then
952: --
953: -- raise error as does not exist as lookup
954: --
955: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
956: fnd_message.set_token('FIELD','p_use_eff_dt_for_chgs_flag');
957: fnd_message.set_token('TYPE','YES_NO');
958: fnd_message.raise_error;
959: --
952: --
953: -- raise error as does not exist as lookup
954: --
955: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
956: fnd_message.set_token('FIELD','p_use_eff_dt_for_chgs_flag');
957: fnd_message.set_token('TYPE','YES_NO');
958: fnd_message.raise_error;
959: --
960: end if;
953: -- raise error as does not exist as lookup
954: --
955: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
956: fnd_message.set_token('FIELD','p_use_eff_dt_for_chgs_flag');
957: fnd_message.set_token('TYPE','YES_NO');
958: fnd_message.raise_error;
959: --
960: end if;
961: --
954: --
955: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
956: fnd_message.set_token('FIELD','p_use_eff_dt_for_chgs_flag');
957: fnd_message.set_token('TYPE','YES_NO');
958: fnd_message.raise_error;
959: --
960: end if;
961: --
962: else
967: p_effective_date => p_effective_date) then
968: --
969: -- raise error as does not exist as lookup
970: --
971: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
972: fnd_message.set_token('FIELD','p_use_eff_dt_for_chgs_flag');
973: fnd_message.set_token('TYPE','YES_NO');
974: fnd_message.raise_error;
975: --
968: --
969: -- raise error as does not exist as lookup
970: --
971: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
972: fnd_message.set_token('FIELD','p_use_eff_dt_for_chgs_flag');
973: fnd_message.set_token('TYPE','YES_NO');
974: fnd_message.raise_error;
975: --
976: end if;
969: -- raise error as does not exist as lookup
970: --
971: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
972: fnd_message.set_token('FIELD','p_use_eff_dt_for_chgs_flag');
973: fnd_message.set_token('TYPE','YES_NO');
974: fnd_message.raise_error;
975: --
976: end if;
977: --
970: --
971: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
972: fnd_message.set_token('FIELD','p_use_eff_dt_for_chgs_flag');
973: fnd_message.set_token('TYPE','YES_NO');
974: fnd_message.raise_error;
975: --
976: end if;
977: --
978: end if;
1038: --
1039: if p_data_typ_cd = 'F' then
1040: if not (p_strt_dt is not null
1041: and p_end_dt is null) then
1042: fnd_message.set_name('BEN','BEN_91776_END_DT_NULL');
1043: fnd_message.raise_error;
1044: end if;
1045: end if;
1046: --
1039: if p_data_typ_cd = 'F' then
1040: if not (p_strt_dt is not null
1041: and p_end_dt is null) then
1042: fnd_message.set_name('BEN','BEN_91776_END_DT_NULL');
1043: fnd_message.raise_error;
1044: end if;
1045: end if;
1046: --
1047: if p_data_typ_cd in ('C', 'CM') then
1046: --
1047: if p_data_typ_cd in ('C', 'CM') then
1048: if not (p_strt_dt is not null
1049: and p_end_dt is not null) then
1050: fnd_message.set_name('BEN','BEN_91780_STRT_DT_NULL');
1051: fnd_message.raise_error;
1052: end if;
1053: end if;
1054: --
1047: if p_data_typ_cd in ('C', 'CM') then
1048: if not (p_strt_dt is not null
1049: and p_end_dt is not null) then
1050: fnd_message.set_name('BEN','BEN_91780_STRT_DT_NULL');
1051: fnd_message.raise_error;
1052: end if;
1053: end if;
1054: --
1055: if (l_api_updating
1064: --
1065: l_dummy := to_date(p_strt_dt,'DD/MM/YYYY');
1066: exception
1067: when others then
1068: fnd_message.set_name('BEN','BEN_91826_INVALID_DT');
1069: fnd_message.raise_error;
1070: end;
1071: else
1072: -- check if value of lookup falls within lookup type.
1065: l_dummy := to_date(p_strt_dt,'DD/MM/YYYY');
1066: exception
1067: when others then
1068: fnd_message.set_name('BEN','BEN_91826_INVALID_DT');
1069: fnd_message.raise_error;
1070: end;
1071: else
1072: -- check if value of lookup falls within lookup type.
1073: --
1080: p_effective_date => p_effective_date) then
1081: --
1082: -- raise error
1083:
1084: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1085: fnd_message.set_token('FIELD','p_strt_dt');
1086: fnd_message.set_token('TYPE','BEN_EXT_DT');
1087: fnd_message.raise_error;
1088: --
1081: --
1082: -- raise error
1083:
1084: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1085: fnd_message.set_token('FIELD','p_strt_dt');
1086: fnd_message.set_token('TYPE','BEN_EXT_DT');
1087: fnd_message.raise_error;
1088: --
1089: end if;
1082: -- raise error
1083:
1084: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1085: fnd_message.set_token('FIELD','p_strt_dt');
1086: fnd_message.set_token('TYPE','BEN_EXT_DT');
1087: fnd_message.raise_error;
1088: --
1089: end if;
1090: --
1083:
1084: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1085: fnd_message.set_token('FIELD','p_strt_dt');
1086: fnd_message.set_token('TYPE','BEN_EXT_DT');
1087: fnd_message.raise_error;
1088: --
1089: end if;
1090: --
1091: else
1096: p_effective_date => p_effective_date) then
1097: --
1098: -- raise error
1099:
1100: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1101: fnd_message.set_token('FIELD','p_strt_dt');
1102: fnd_message.set_token('TYPE','BEN_EXT_DT');
1103: fnd_message.raise_error;
1104: --
1097: --
1098: -- raise error
1099:
1100: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1101: fnd_message.set_token('FIELD','p_strt_dt');
1102: fnd_message.set_token('TYPE','BEN_EXT_DT');
1103: fnd_message.raise_error;
1104: --
1105: end if;
1098: -- raise error
1099:
1100: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1101: fnd_message.set_token('FIELD','p_strt_dt');
1102: fnd_message.set_token('TYPE','BEN_EXT_DT');
1103: fnd_message.raise_error;
1104: --
1105: end if;
1106: --
1099:
1100: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1101: fnd_message.set_token('FIELD','p_strt_dt');
1102: fnd_message.set_token('TYPE','BEN_EXT_DT');
1103: fnd_message.raise_error;
1104: --
1105: end if;
1106: --
1107: end if;
1119: --
1120: l_dummy := to_date(p_end_dt,'DD/MM/YYYY');
1121: exception
1122: when others then
1123: fnd_message.set_name('BEN','BEN_91826_INVALID_DT');
1124: fnd_message.raise_error;
1125: end;
1126:
1127: else
1120: l_dummy := to_date(p_end_dt,'DD/MM/YYYY');
1121: exception
1122: when others then
1123: fnd_message.set_name('BEN','BEN_91826_INVALID_DT');
1124: fnd_message.raise_error;
1125: end;
1126:
1127: else
1128: -- check if value of lookup falls within lookup type.
1135: p_effective_date => p_effective_date) then
1136: --
1137: -- raise error
1138:
1139: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1140: fnd_message.set_token('FIELD','p_end_dt');
1141: fnd_message.set_token('TYPE','BEN_EXT_DT');
1142: fnd_message.raise_error;
1143: --
1136: --
1137: -- raise error
1138:
1139: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1140: fnd_message.set_token('FIELD','p_end_dt');
1141: fnd_message.set_token('TYPE','BEN_EXT_DT');
1142: fnd_message.raise_error;
1143: --
1144: end if;
1137: -- raise error
1138:
1139: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1140: fnd_message.set_token('FIELD','p_end_dt');
1141: fnd_message.set_token('TYPE','BEN_EXT_DT');
1142: fnd_message.raise_error;
1143: --
1144: end if;
1145: --
1138:
1139: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1140: fnd_message.set_token('FIELD','p_end_dt');
1141: fnd_message.set_token('TYPE','BEN_EXT_DT');
1142: fnd_message.raise_error;
1143: --
1144: end if;
1145: --
1146: else
1151: p_effective_date => p_effective_date) then
1152: --
1153: -- raise error
1154:
1155: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1156: fnd_message.set_token('FIELD','p_end_dt');
1157: fnd_message.set_token('TYPE','BEN_EXT_DT');
1158: fnd_message.raise_error;
1159: --
1152: --
1153: -- raise error
1154:
1155: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1156: fnd_message.set_token('FIELD','p_end_dt');
1157: fnd_message.set_token('TYPE','BEN_EXT_DT');
1158: fnd_message.raise_error;
1159: --
1160: end if;
1153: -- raise error
1154:
1155: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1156: fnd_message.set_token('FIELD','p_end_dt');
1157: fnd_message.set_token('TYPE','BEN_EXT_DT');
1158: fnd_message.raise_error;
1159: --
1160: end if;
1161: --
1154:
1155: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1156: fnd_message.set_token('FIELD','p_end_dt');
1157: fnd_message.set_token('TYPE','BEN_EXT_DT');
1158: fnd_message.raise_error;
1159: --
1160: end if;
1161: --
1162: end if;
1203: Begin
1204: hr_utility.set_location('Entering:'||l_proc, 5);
1205: --
1206: if instr(p_output_name,' ') > 0 or instr(p_drctry_name,' ') > 0 then
1207: fnd_message.set_name('BEN','BEN_91955_NAME_HAS_SPACE');
1208: fnd_message.raise_error;
1209: end if;
1210: --
1211: hr_utility.set_location('Leaving:'||l_proc, 15);
1204: hr_utility.set_location('Entering:'||l_proc, 5);
1205: --
1206: if instr(p_output_name,' ') > 0 or instr(p_drctry_name,' ') > 0 then
1207: fnd_message.set_name('BEN','BEN_91955_NAME_HAS_SPACE');
1208: fnd_message.raise_error;
1209: end if;
1210: --
1211: hr_utility.set_location('Leaving:'||l_proc, 15);
1212: End chk_output_file;
1235: --
1236: if ( (not nvl(p_output_type,'F') in ( 'F' , 'X' ) ) and p_xdo_template_id is null )
1237: or ( p_xdo_template_id is not null and ( p_output_type in ('F' , 'X') ) )
1238: then
1239: fnd_message.set_name('BEN','BEN_94036_EXT_XDO_PDF_NULL');
1240: fnd_message.raise_error;
1241: end if;
1242:
1243: if p_xdo_template_id is not null then
1236: if ( (not nvl(p_output_type,'F') in ( 'F' , 'X' ) ) and p_xdo_template_id is null )
1237: or ( p_xdo_template_id is not null and ( p_output_type in ('F' , 'X') ) )
1238: then
1239: fnd_message.set_name('BEN','BEN_94036_EXT_XDO_PDF_NULL');
1240: fnd_message.raise_error;
1241: end if;
1242:
1243: if p_xdo_template_id is not null then
1244: open c ;
1244: open c ;
1245: fetch c into l_source_code ;
1246: if c%notfound then
1247: close c ;
1248: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
1249: fnd_message.set_token('PROCEDURE', l_proc);
1250: fnd_message.set_token('CONSTRAINT_NAME', 'XDO_TEMPLATE_ID');
1251: fnd_message.raise_error;
1252: end if ;
1245: fetch c into l_source_code ;
1246: if c%notfound then
1247: close c ;
1248: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
1249: fnd_message.set_token('PROCEDURE', l_proc);
1250: fnd_message.set_token('CONSTRAINT_NAME', 'XDO_TEMPLATE_ID');
1251: fnd_message.raise_error;
1252: end if ;
1253: close c ;
1246: if c%notfound then
1247: close c ;
1248: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
1249: fnd_message.set_token('PROCEDURE', l_proc);
1250: fnd_message.set_token('CONSTRAINT_NAME', 'XDO_TEMPLATE_ID');
1251: fnd_message.raise_error;
1252: end if ;
1253: close c ;
1254:
1247: close c ;
1248: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
1249: fnd_message.set_token('PROCEDURE', l_proc);
1250: fnd_message.set_token('CONSTRAINT_NAME', 'XDO_TEMPLATE_ID');
1251: fnd_message.raise_error;
1252: end if ;
1253: close c ;
1254:
1255: -- make sure correct template attched to correct extract defintionm
1258:
1259: if (p_cm_display_flag = 'Y' and l_source_code <> 'BENXMLWRIT' ) OR
1260: (p_cm_display_flag <> 'Y' and l_source_code = 'BENXMLWRIT' ) then
1261:
1262: fnd_message.set_name('BEN', 'BEN_94499_EXT_WRONG_XDO');
1263: fnd_message.raise_error;
1264:
1265: end if ;
1266:
1259: if (p_cm_display_flag = 'Y' and l_source_code <> 'BENXMLWRIT' ) OR
1260: (p_cm_display_flag <> 'Y' and l_source_code = 'BENXMLWRIT' ) then
1261:
1262: fnd_message.set_name('BEN', 'BEN_94499_EXT_WRONG_XDO');
1263: fnd_message.raise_error;
1264:
1265: end if ;
1266:
1267:
1319: Begin
1320: hr_utility.set_location('Entering:'||l_proc, 5);
1321: --
1322: if p_name is null then
1323: fnd_message.set_name('BEN','BEN_91783_NAME_NULL');
1324: fnd_message.raise_error;
1325: end if;
1326: open c1;
1327: fetch c1 into l_dummy;
1320: hr_utility.set_location('Entering:'||l_proc, 5);
1321: --
1322: if p_name is null then
1323: fnd_message.set_name('BEN','BEN_91783_NAME_NULL');
1324: fnd_message.raise_error;
1325: end if;
1326: open c1;
1327: fetch c1 into l_dummy;
1328: if c1%found then
1326: open c1;
1327: fetch c1 into l_dummy;
1328: if c1%found then
1329: close c1;
1330: fnd_message.set_name('BEN','BEN_91009_NAME_NOT_UNIQUE');
1331: fnd_message.raise_error;
1332: end if;
1333: --
1334: hr_utility.set_location('Leaving:'||l_proc, 15);
1327: fetch c1 into l_dummy;
1328: if c1%found then
1329: close c1;
1330: fnd_message.set_name('BEN','BEN_91009_NAME_NOT_UNIQUE');
1331: fnd_message.raise_error;
1332: end if;
1333: --
1334: hr_utility.set_location('Leaving:'||l_proc, 15);
1335: End chk_name_unique;
1409: fetch c_ext_rslt into l_dummy ;
1410: close c_ext_rslt;
1411:
1412: if l_dummy is not null then
1413: fnd_message.set_name('PER','HR_7215_DT_CHILD_EXISTS');
1414: fnd_message.set_token('TABLE_NAME','Extract Results');
1415: fnd_message.raise_error;
1416:
1417: end if;
1410: close c_ext_rslt;
1411:
1412: if l_dummy is not null then
1413: fnd_message.set_name('PER','HR_7215_DT_CHILD_EXISTS');
1414: fnd_message.set_token('TABLE_NAME','Extract Results');
1415: fnd_message.raise_error;
1416:
1417: end if;
1418:
1411:
1412: if l_dummy is not null then
1413: fnd_message.set_name('PER','HR_7215_DT_CHILD_EXISTS');
1414: fnd_message.set_token('TABLE_NAME','Extract Results');
1415: fnd_message.raise_error;
1416:
1417: end if;
1418:
1419: --