110:
111: if p_enrt_ctfn_recd_dt is not null then
112: if
113: p_enrt_ctfn_dnd_dt is not null then
114: fnd_message.set_name('BEN','BEN_92335_RECD_DND_DATES');
115: fnd_message.raise_error;
116: end if;
117: end if;
118: --
111: if p_enrt_ctfn_recd_dt is not null then
112: if
113: p_enrt_ctfn_dnd_dt is not null then
114: fnd_message.set_name('BEN','BEN_92335_RECD_DND_DATES');
115: fnd_message.raise_error;
116: end if;
117: end if;
118: --
119: hr_utility.set_location('Leaving:'||l_proc, 10);
177: p_effective_date => p_effective_date) then
178: --
179: -- raise error as does not exist as lookup
180: --
181: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
182: fnd_message.set_token('FIELD','p_enrt_r_bnft_ctfn_cd');
183: fnd_message.set_token('TYPE','BEN_ENRT_R_BNFT_CTFN');
184: fnd_message.raise_error;
185: --
178: --
179: -- raise error as does not exist as lookup
180: --
181: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
182: fnd_message.set_token('FIELD','p_enrt_r_bnft_ctfn_cd');
183: fnd_message.set_token('TYPE','BEN_ENRT_R_BNFT_CTFN');
184: fnd_message.raise_error;
185: --
186: end if;
179: -- raise error as does not exist as lookup
180: --
181: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
182: fnd_message.set_token('FIELD','p_enrt_r_bnft_ctfn_cd');
183: fnd_message.set_token('TYPE','BEN_ENRT_R_BNFT_CTFN');
184: fnd_message.raise_error;
185: --
186: end if;
187: --
180: --
181: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
182: fnd_message.set_token('FIELD','p_enrt_r_bnft_ctfn_cd');
183: fnd_message.set_token('TYPE','BEN_ENRT_R_BNFT_CTFN');
184: fnd_message.raise_error;
185: --
186: end if;
187: --
188: end if;
249: p_effective_date => p_effective_date) then
250: --
251: -- raise error as does not exist as lookup
252: --
253: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
254: fnd_message.set_token('FIELD','p_enrt_ctfn_typ_cd');
255: fnd_message.set_token('TYPE','BEN_ENRT_CTFN_TYP');
256: fnd_message.raise_error;
257: --
250: --
251: -- raise error as does not exist as lookup
252: --
253: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
254: fnd_message.set_token('FIELD','p_enrt_ctfn_typ_cd');
255: fnd_message.set_token('TYPE','BEN_ENRT_CTFN_TYP');
256: fnd_message.raise_error;
257: --
258: end if;
251: -- raise error as does not exist as lookup
252: --
253: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
254: fnd_message.set_token('FIELD','p_enrt_ctfn_typ_cd');
255: fnd_message.set_token('TYPE','BEN_ENRT_CTFN_TYP');
256: fnd_message.raise_error;
257: --
258: end if;
259: --
252: --
253: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
254: fnd_message.set_token('FIELD','p_enrt_ctfn_typ_cd');
255: fnd_message.set_token('TYPE','BEN_ENRT_CTFN_TYP');
256: fnd_message.raise_error;
257: --
258: end if;
259: --
260: end if;
339: if p_enrt_ctfn_recd_dt > l_due_dt then
340: --
341: -- raise error as does not satisfy the condition
342: --
343: fnd_message.set_name('BEN','BEN_91601_ENRT_VOID_DT');
344: fnd_message.raise_error;
345: --
346: end if;
347: --
340: --
341: -- raise error as does not satisfy the condition
342: --
343: fnd_message.set_name('BEN','BEN_91601_ENRT_VOID_DT');
344: fnd_message.raise_error;
345: --
346: end if;
347: --
348: end if;
410: p_effective_date => p_effective_date) then
411: --
412: -- raise error as does not exist as lookup
413: --
414: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
415: fnd_message.set_token('FIELD','p_enrt_ctfn_rqd_flag');
416: fnd_message.set_token('TYPE','YES_NO');
417: fnd_message.raise_error;
418: --
411: --
412: -- raise error as does not exist as lookup
413: --
414: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
415: fnd_message.set_token('FIELD','p_enrt_ctfn_rqd_flag');
416: fnd_message.set_token('TYPE','YES_NO');
417: fnd_message.raise_error;
418: --
419: end if;
412: -- raise error as does not exist as lookup
413: --
414: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
415: fnd_message.set_token('FIELD','p_enrt_ctfn_rqd_flag');
416: fnd_message.set_token('TYPE','YES_NO');
417: fnd_message.raise_error;
418: --
419: end if;
420: --
413: --
414: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
415: fnd_message.set_token('FIELD','p_enrt_ctfn_rqd_flag');
416: fnd_message.set_token('TYPE','YES_NO');
417: fnd_message.raise_error;
418: --
419: end if;
420: --
421: end if;
520: --
521: -- A referential integrity check was violated therefore
522: -- we must error
523: --
524: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
525: fnd_message.set_token('TABLE_NAME', l_table_name);
526: fnd_message.raise_error;
527: When Others Then
528: --
521: -- A referential integrity check was violated therefore
522: -- we must error
523: --
524: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
525: fnd_message.set_token('TABLE_NAME', l_table_name);
526: fnd_message.raise_error;
527: When Others Then
528: --
529: -- An unhandled or unexpected error has occurred which
522: -- we must error
523: --
524: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
525: fnd_message.set_token('TABLE_NAME', l_table_name);
526: fnd_message.raise_error;
527: When Others Then
528: --
529: -- An unhandled or unexpected error has occurred which
530: -- we must report
528: --
529: -- An unhandled or unexpected error has occurred which
530: -- we must report
531: --
532: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
533: fnd_message.set_token('PROCEDURE', l_proc);
534: fnd_message.set_token('STEP','15');
535: fnd_message.raise_error;
536: End dt_update_validate;
529: -- An unhandled or unexpected error has occurred which
530: -- we must report
531: --
532: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
533: fnd_message.set_token('PROCEDURE', l_proc);
534: fnd_message.set_token('STEP','15');
535: fnd_message.raise_error;
536: End dt_update_validate;
537: --
530: -- we must report
531: --
532: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
533: fnd_message.set_token('PROCEDURE', l_proc);
534: fnd_message.set_token('STEP','15');
535: fnd_message.raise_error;
536: End dt_update_validate;
537: --
538: -- ----------------------------------------------------------------------------
531: --
532: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
533: fnd_message.set_token('PROCEDURE', l_proc);
534: fnd_message.set_token('STEP','15');
535: fnd_message.raise_error;
536: End dt_update_validate;
537: --
538: -- ----------------------------------------------------------------------------
539: -- |--------------------------< dt_delete_validate >--------------------------|
624: --
625: -- A referential integrity check was violated therefore
626: -- we must error
627: --
628: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
629: fnd_message.set_token('TABLE_NAME', l_table_name);
630: fnd_message.raise_error;
631: When Others Then
632: --
625: -- A referential integrity check was violated therefore
626: -- we must error
627: --
628: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
629: fnd_message.set_token('TABLE_NAME', l_table_name);
630: fnd_message.raise_error;
631: When Others Then
632: --
633: -- An unhandled or unexpected error has occurred which
626: -- we must error
627: --
628: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
629: fnd_message.set_token('TABLE_NAME', l_table_name);
630: fnd_message.raise_error;
631: When Others Then
632: --
633: -- An unhandled or unexpected error has occurred which
634: -- we must report
632: --
633: -- An unhandled or unexpected error has occurred which
634: -- we must report
635: --
636: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
637: fnd_message.set_token('PROCEDURE', l_proc);
638: fnd_message.set_token('STEP','15');
639: fnd_message.raise_error;
640: End dt_delete_validate;
633: -- An unhandled or unexpected error has occurred which
634: -- we must report
635: --
636: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
637: fnd_message.set_token('PROCEDURE', l_proc);
638: fnd_message.set_token('STEP','15');
639: fnd_message.raise_error;
640: End dt_delete_validate;
641: --
634: -- we must report
635: --
636: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
637: fnd_message.set_token('PROCEDURE', l_proc);
638: fnd_message.set_token('STEP','15');
639: fnd_message.raise_error;
640: End dt_delete_validate;
641: --
642: -- ----------------------------------------------------------------------------
635: --
636: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
637: fnd_message.set_token('PROCEDURE', l_proc);
638: fnd_message.set_token('STEP','15');
639: fnd_message.raise_error;
640: End dt_delete_validate;
641: --
642: -- ----------------------------------------------------------------------------
643: -- |---------------------------< insert_validate >----------------------------|
836: close csr_leg_code;
837: --
838: -- The primary key is invalid therefore we must error
839: --
840: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
841: fnd_message.raise_error;
842: --
843: end if;
844: --
837: --
838: -- The primary key is invalid therefore we must error
839: --
840: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
841: fnd_message.raise_error;
842: --
843: end if;
844: --
845: close csr_leg_code;