207: and p_to_be_sent_dt is not null then
208: --
209: if p_to_be_sent_dt < p_effective_date then
210: --
211: fnd_message.set_name('BEN','BEN_91882_TO_BE_SENT_DT_ERR');
212: fnd_message.raise_error;
213: --
214: end if;
215: --
208: --
209: if p_to_be_sent_dt < p_effective_date then
210: --
211: fnd_message.set_name('BEN','BEN_91882_TO_BE_SENT_DT_ERR');
212: fnd_message.raise_error;
213: --
214: end if;
215: --
216: end if;
276: p_effective_date => p_effective_date) then
277: --
278: -- raise error as does not exist as lookup
279: --
280: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
281: fnd_message.set_token('FIELD','p_cm_dlvry_mthd_cd');
282: fnd_message.set_token('TYPE','BEN_DLVRY_MTHD');
283: fnd_message.raise_error;
284: --
277: --
278: -- raise error as does not exist as lookup
279: --
280: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
281: fnd_message.set_token('FIELD','p_cm_dlvry_mthd_cd');
282: fnd_message.set_token('TYPE','BEN_DLVRY_MTHD');
283: fnd_message.raise_error;
284: --
285: end if;
278: -- raise error as does not exist as lookup
279: --
280: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
281: fnd_message.set_token('FIELD','p_cm_dlvry_mthd_cd');
282: fnd_message.set_token('TYPE','BEN_DLVRY_MTHD');
283: fnd_message.raise_error;
284: --
285: end if;
286: --
279: --
280: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
281: fnd_message.set_token('FIELD','p_cm_dlvry_mthd_cd');
282: fnd_message.set_token('TYPE','BEN_DLVRY_MTHD');
283: fnd_message.raise_error;
284: --
285: end if;
286: --
287: end if;
348: p_effective_date => p_effective_date) then
349: --
350: -- raise error as does not exist as lookup
351: --
352: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
353: fnd_message.set_token('FIELD','p_cm_dlvry_med_cd');
354: fnd_message.set_token('TYPE','BEN_DLVRY_MED');
355: fnd_message.raise_error;
356: --
349: --
350: -- raise error as does not exist as lookup
351: --
352: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
353: fnd_message.set_token('FIELD','p_cm_dlvry_med_cd');
354: fnd_message.set_token('TYPE','BEN_DLVRY_MED');
355: fnd_message.raise_error;
356: --
357: end if;
350: -- raise error as does not exist as lookup
351: --
352: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
353: fnd_message.set_token('FIELD','p_cm_dlvry_med_cd');
354: fnd_message.set_token('TYPE','BEN_DLVRY_MED');
355: fnd_message.raise_error;
356: --
357: end if;
358: --
351: --
352: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
353: fnd_message.set_token('FIELD','p_cm_dlvry_med_cd');
354: fnd_message.set_token('TYPE','BEN_DLVRY_MED');
355: fnd_message.raise_error;
356: --
357: end if;
358: --
359: end if;
419: p_effective_date => p_effective_date) then
420: --
421: -- raise error as does not exist as lookup
422: --
423: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
424: fnd_message.set_token('FIELD','p_per_cm_prvdd_stat_cd');
425: fnd_message.set_token('TYPE','BEN_PER_CM_PRVDD_STAT');
426: fnd_message.raise_error;
427: --
420: --
421: -- raise error as does not exist as lookup
422: --
423: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
424: fnd_message.set_token('FIELD','p_per_cm_prvdd_stat_cd');
425: fnd_message.set_token('TYPE','BEN_PER_CM_PRVDD_STAT');
426: fnd_message.raise_error;
427: --
428: end if;
421: -- raise error as does not exist as lookup
422: --
423: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
424: fnd_message.set_token('FIELD','p_per_cm_prvdd_stat_cd');
425: fnd_message.set_token('TYPE','BEN_PER_CM_PRVDD_STAT');
426: fnd_message.raise_error;
427: --
428: end if;
429: --
422: --
423: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
424: fnd_message.set_token('FIELD','p_per_cm_prvdd_stat_cd');
425: fnd_message.set_token('TYPE','BEN_PER_CM_PRVDD_STAT');
426: fnd_message.raise_error;
427: --
428: end if;
429: --
430: end if;
491: p_effective_date => p_effective_date) then
492: --
493: -- raise error as does not exist as lookup
494: --
495: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
496: fnd_message.set_token('FIELD','p_resnd_rsn_cd');
497: fnd_message.set_token('TYPE','BEN_RESND_RSN');
498: fnd_message.raise_error;
499: --
492: --
493: -- raise error as does not exist as lookup
494: --
495: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
496: fnd_message.set_token('FIELD','p_resnd_rsn_cd');
497: fnd_message.set_token('TYPE','BEN_RESND_RSN');
498: fnd_message.raise_error;
499: --
500: end if;
493: -- raise error as does not exist as lookup
494: --
495: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
496: fnd_message.set_token('FIELD','p_resnd_rsn_cd');
497: fnd_message.set_token('TYPE','BEN_RESND_RSN');
498: fnd_message.raise_error;
499: --
500: end if;
501: --
494: --
495: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
496: fnd_message.set_token('FIELD','p_resnd_rsn_cd');
497: fnd_message.set_token('TYPE','BEN_RESND_RSN');
498: fnd_message.raise_error;
499: --
500: end if;
501: --
502: end if;
561: p_effective_date => p_effective_date) then
562: --
563: -- raise error as does not exist as lookup
564: --
565: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
566: fnd_message.set_token('FIELD','p_inspn_rqd_flag');
567: fnd_message.set_token('TYPE','YES_NO');
568: fnd_message.raise_error;
569: --
562: --
563: -- raise error as does not exist as lookup
564: --
565: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
566: fnd_message.set_token('FIELD','p_inspn_rqd_flag');
567: fnd_message.set_token('TYPE','YES_NO');
568: fnd_message.raise_error;
569: --
570: end if;
563: -- raise error as does not exist as lookup
564: --
565: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
566: fnd_message.set_token('FIELD','p_inspn_rqd_flag');
567: fnd_message.set_token('TYPE','YES_NO');
568: fnd_message.raise_error;
569: --
570: end if;
571: --
564: --
565: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
566: fnd_message.set_token('FIELD','p_inspn_rqd_flag');
567: fnd_message.set_token('TYPE','YES_NO');
568: fnd_message.raise_error;
569: --
570: end if;
571: --
572: end if;
632: p_effective_date => p_effective_date) then
633: --
634: -- raise error as does not exist as lookup
635: --
636: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
637: fnd_message.set_token('FIELD','p_inspn_rqd_flag');
638: fnd_message.set_token('TYPE','YES_NO');
639: fnd_message.raise_error;
640: --
633: --
634: -- raise error as does not exist as lookup
635: --
636: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
637: fnd_message.set_token('FIELD','p_inspn_rqd_flag');
638: fnd_message.set_token('TYPE','YES_NO');
639: fnd_message.raise_error;
640: --
641: end if;
634: -- raise error as does not exist as lookup
635: --
636: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
637: fnd_message.set_token('FIELD','p_inspn_rqd_flag');
638: fnd_message.set_token('TYPE','YES_NO');
639: fnd_message.raise_error;
640: --
641: end if;
642: --
635: --
636: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
637: fnd_message.set_token('FIELD','p_inspn_rqd_flag');
638: fnd_message.set_token('TYPE','YES_NO');
639: fnd_message.raise_error;
640: --
641: end if;
642: --
643: end if;
738: --
739: -- An unhandled or unexpected error has occurred which
740: -- we must report
741: --
742: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
743: fnd_message.set_token('PROCEDURE', l_proc);
744: fnd_message.set_token('STEP','15');
745: fnd_message.raise_error;
746: End dt_update_validate;
739: -- An unhandled or unexpected error has occurred which
740: -- we must report
741: --
742: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
743: fnd_message.set_token('PROCEDURE', l_proc);
744: fnd_message.set_token('STEP','15');
745: fnd_message.raise_error;
746: End dt_update_validate;
747: --
740: -- we must report
741: --
742: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
743: fnd_message.set_token('PROCEDURE', l_proc);
744: fnd_message.set_token('STEP','15');
745: fnd_message.raise_error;
746: End dt_update_validate;
747: --
748: -- ----------------------------------------------------------------------------
741: --
742: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
743: fnd_message.set_token('PROCEDURE', l_proc);
744: fnd_message.set_token('STEP','15');
745: fnd_message.raise_error;
746: End dt_update_validate;
747: --
748: -- ----------------------------------------------------------------------------
749: -- |--------------------------< dt_delete_validate >--------------------------|
840: --
841: -- An unhandled or unexpected error has occurred which
842: -- we must report
843: --
844: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
845: fnd_message.set_token('PROCEDURE', l_proc);
846: fnd_message.set_token('STEP','15');
847: fnd_message.raise_error;
848: End dt_delete_validate;
841: -- An unhandled or unexpected error has occurred which
842: -- we must report
843: --
844: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
845: fnd_message.set_token('PROCEDURE', l_proc);
846: fnd_message.set_token('STEP','15');
847: fnd_message.raise_error;
848: End dt_delete_validate;
849: --
842: -- we must report
843: --
844: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
845: fnd_message.set_token('PROCEDURE', l_proc);
846: fnd_message.set_token('STEP','15');
847: fnd_message.raise_error;
848: End dt_delete_validate;
849: --
850: -- ----------------------------------------------------------------------------
843: --
844: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
845: fnd_message.set_token('PROCEDURE', l_proc);
846: fnd_message.set_token('STEP','15');
847: fnd_message.raise_error;
848: End dt_delete_validate;
849: --
850: -- ----------------------------------------------------------------------------
851: -- |---------------------------< insert_validate >----------------------------|
1075: close csr_leg_code;
1076: --
1077: -- The primary key is invalid therefore we must error
1078: --
1079: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
1080: fnd_message.raise_error;
1081: --
1082: end if;
1083: --
1076: --
1077: -- The primary key is invalid therefore we must error
1078: --
1079: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
1080: fnd_message.raise_error;
1081: --
1082: end if;
1083: --
1084: close csr_leg_code;