175: close c3;
176: --
177: -- raise error as this pl already exists for this profile
178: --
179: fnd_message.set_name('BEN', 'BEN_91349_DUP_ELIG_CRITERIA');
180: fnd_message.raise_error;
181: --
182: end if;
183: close c3;
176: --
177: -- raise error as this pl already exists for this profile
178: --
179: fnd_message.set_name('BEN', 'BEN_91349_DUP_ELIG_CRITERIA');
180: fnd_message.raise_error;
181: --
182: end if;
183: close c3;
184: --
244: p_effective_date => p_effective_date) then
245: --
246: -- raise error as does not exist as lookup
247: --
248: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
249: fnd_message.set_token('FIELD','p_cvg_det_dt_cd');
250: fnd_message.set_token('TYPE','BEN_CVG_DET_DT');
251: fnd_message.raise_error;
252: --
245: --
246: -- raise error as does not exist as lookup
247: --
248: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
249: fnd_message.set_token('FIELD','p_cvg_det_dt_cd');
250: fnd_message.set_token('TYPE','BEN_CVG_DET_DT');
251: fnd_message.raise_error;
252: --
253: end if;
246: -- raise error as does not exist as lookup
247: --
248: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
249: fnd_message.set_token('FIELD','p_cvg_det_dt_cd');
250: fnd_message.set_token('TYPE','BEN_CVG_DET_DT');
251: fnd_message.raise_error;
252: --
253: end if;
254: --
247: --
248: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
249: fnd_message.set_token('FIELD','p_cvg_det_dt_cd');
250: fnd_message.set_token('TYPE','BEN_CVG_DET_DT');
251: fnd_message.raise_error;
252: --
253: end if;
254: --
255: end if;
315: p_effective_date => p_effective_date) then
316: --
317: -- raise error as does not exist as lookup
318: --
319: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
320: fnd_message.set_token('FIELD','p_excld_flag');
321: fnd_message.set_token('TYPE','YES_NO');
322: fnd_message.raise_error;
323: --
316: --
317: -- raise error as does not exist as lookup
318: --
319: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
320: fnd_message.set_token('FIELD','p_excld_flag');
321: fnd_message.set_token('TYPE','YES_NO');
322: fnd_message.raise_error;
323: --
324: end if;
317: -- raise error as does not exist as lookup
318: --
319: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
320: fnd_message.set_token('FIELD','p_excld_flag');
321: fnd_message.set_token('TYPE','YES_NO');
322: fnd_message.raise_error;
323: --
324: end if;
325: --
318: --
319: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
320: fnd_message.set_token('FIELD','p_excld_flag');
321: fnd_message.set_token('TYPE','YES_NO');
322: fnd_message.raise_error;
323: --
324: end if;
325: --
326: end if;
379: open c1;
380: fetch c1 into l_dummy;
381: if c1%found then
382: close c1;
383: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
384: fnd_message.raise_error;
385: end if;
386: close c1;
387: --
380: fetch c1 into l_dummy;
381: if c1%found then
382: close c1;
383: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
384: fnd_message.raise_error;
385: end if;
386: close c1;
387: --
388: hr_utility.set_location('Leaving:'||l_proc, 15);
489: --
490: -- An unhandled or unexpected error has occurred which
491: -- we must report
492: --
493: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
494: fnd_message.set_token('PROCEDURE', l_proc);
495: fnd_message.set_token('STEP','15');
496: fnd_message.raise_error;
497: End dt_update_validate;
490: -- An unhandled or unexpected error has occurred which
491: -- we must report
492: --
493: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
494: fnd_message.set_token('PROCEDURE', l_proc);
495: fnd_message.set_token('STEP','15');
496: fnd_message.raise_error;
497: End dt_update_validate;
498: --
491: -- we must report
492: --
493: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
494: fnd_message.set_token('PROCEDURE', l_proc);
495: fnd_message.set_token('STEP','15');
496: fnd_message.raise_error;
497: End dt_update_validate;
498: --
499: -- ----------------------------------------------------------------------------
492: --
493: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
494: fnd_message.set_token('PROCEDURE', l_proc);
495: fnd_message.set_token('STEP','15');
496: fnd_message.raise_error;
497: End dt_update_validate;
498: --
499: -- ----------------------------------------------------------------------------
500: -- |--------------------------< dt_delete_validate >--------------------------|
585: --
586: -- A referential integrity check was violated therefore
587: -- we must error
588: --
589: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
590: fnd_message.set_token('TABLE_NAME', l_table_name);
591: fnd_message.raise_error;
592: When Others Then
593: --
586: -- A referential integrity check was violated therefore
587: -- we must error
588: --
589: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
590: fnd_message.set_token('TABLE_NAME', l_table_name);
591: fnd_message.raise_error;
592: When Others Then
593: --
594: -- An unhandled or unexpected error has occurred which
587: -- we must error
588: --
589: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
590: fnd_message.set_token('TABLE_NAME', l_table_name);
591: fnd_message.raise_error;
592: When Others Then
593: --
594: -- An unhandled or unexpected error has occurred which
595: -- we must report
593: --
594: -- An unhandled or unexpected error has occurred which
595: -- we must report
596: --
597: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
598: fnd_message.set_token('PROCEDURE', l_proc);
599: fnd_message.set_token('STEP','15');
600: fnd_message.raise_error;
601: End dt_delete_validate;
594: -- An unhandled or unexpected error has occurred which
595: -- we must report
596: --
597: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
598: fnd_message.set_token('PROCEDURE', l_proc);
599: fnd_message.set_token('STEP','15');
600: fnd_message.raise_error;
601: End dt_delete_validate;
602: --
595: -- we must report
596: --
597: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
598: fnd_message.set_token('PROCEDURE', l_proc);
599: fnd_message.set_token('STEP','15');
600: fnd_message.raise_error;
601: End dt_delete_validate;
602: --
603: -- ----------------------------------------------------------------------------
596: --
597: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
598: fnd_message.set_token('PROCEDURE', l_proc);
599: fnd_message.set_token('STEP','15');
600: fnd_message.raise_error;
601: End dt_delete_validate;
602: --
603: -- ----------------------------------------------------------------------------
604: -- |---------------------------< insert_validate >----------------------------|
788: close csr_leg_code;
789: --
790: -- The primary key is invalid therefore we must error
791: --
792: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
793: fnd_message.raise_error;
794: --
795: end if;
796: --
789: --
790: -- The primary key is invalid therefore we must error
791: --
792: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
793: fnd_message.raise_error;
794: --
795: end if;
796: --
797: close csr_leg_code;