133: p_effective_date => p_effective_date) then
134: --
135: -- raise error as does not exist as lookup
136: --
137: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
138: fnd_message.set_token('FIELD','p_excld_flag');
139: fnd_message.set_token('TYPE','YES_NO');
140: fnd_message.raise_error;
141: --
134: --
135: -- raise error as does not exist as lookup
136: --
137: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
138: fnd_message.set_token('FIELD','p_excld_flag');
139: fnd_message.set_token('TYPE','YES_NO');
140: fnd_message.raise_error;
141: --
142: end if;
135: -- raise error as does not exist as lookup
136: --
137: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
138: fnd_message.set_token('FIELD','p_excld_flag');
139: fnd_message.set_token('TYPE','YES_NO');
140: fnd_message.raise_error;
141: --
142: end if;
143: --
136: --
137: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
138: fnd_message.set_token('FIELD','p_excld_flag');
139: fnd_message.set_token('TYPE','YES_NO');
140: fnd_message.raise_error;
141: --
142: end if;
143: --
144: end if;
204: p_effective_date => p_effective_date) then
205: --
206: -- raise error as does not exist as lookup
207: --
208: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
209: fnd_message.set_token('FIELD','p_cvg_det_dt_cd');
210: fnd_message.set_token('TYPE','BEN_CVG_DET_DT');
211: fnd_message.raise_error;
212: --
205: --
206: -- raise error as does not exist as lookup
207: --
208: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
209: fnd_message.set_token('FIELD','p_cvg_det_dt_cd');
210: fnd_message.set_token('TYPE','BEN_CVG_DET_DT');
211: fnd_message.raise_error;
212: --
213: end if;
206: -- raise error as does not exist as lookup
207: --
208: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
209: fnd_message.set_token('FIELD','p_cvg_det_dt_cd');
210: fnd_message.set_token('TYPE','BEN_CVG_DET_DT');
211: fnd_message.raise_error;
212: --
213: end if;
214: --
207: --
208: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
209: fnd_message.set_token('FIELD','p_cvg_det_dt_cd');
210: fnd_message.set_token('TYPE','BEN_CVG_DET_DT');
211: fnd_message.raise_error;
212: --
213: end if;
214: --
215: end if;
272: open c1;
273: fetch c1 into dummy;
274: if c1%found then
275: close c1;
276: fnd_message.set_name('BEN','BEN_91009_NAME_NOT_UNIQUE');
277: fnd_message.raise_error;
278: end if;
279: close c1;
280: --
273: fetch c1 into dummy;
274: if c1%found then
275: close c1;
276: fnd_message.set_name('BEN','BEN_91009_NAME_NOT_UNIQUE');
277: fnd_message.raise_error;
278: end if;
279: close c1;
280: --
281: hr_utility.set_location('Leaving:'||l_proc, 10);
338: open c1;
339: fetch c1 into l_dummy;
340: --
341: if c1%found then
342: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
343: fnd_message.raise_error;
344: end if;
345: close c1;
346: --
339: fetch c1 into l_dummy;
340: --
341: if c1%found then
342: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
343: fnd_message.raise_error;
344: end if;
345: close c1;
346: --
347: hr_utility.set_location('Leaving:'||l_proc, 15);
451: --
452: -- An unhandled or unexpected error has occurred which
453: -- we must report
454: --
455: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
456: fnd_message.set_token('PROCEDURE', l_proc);
457: fnd_message.set_token('STEP','15');
458: fnd_message.raise_error;
459: End dt_update_validate;
452: -- An unhandled or unexpected error has occurred which
453: -- we must report
454: --
455: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
456: fnd_message.set_token('PROCEDURE', l_proc);
457: fnd_message.set_token('STEP','15');
458: fnd_message.raise_error;
459: End dt_update_validate;
460: --
453: -- we must report
454: --
455: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
456: fnd_message.set_token('PROCEDURE', l_proc);
457: fnd_message.set_token('STEP','15');
458: fnd_message.raise_error;
459: End dt_update_validate;
460: --
461: -- ----------------------------------------------------------------------------
454: --
455: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
456: fnd_message.set_token('PROCEDURE', l_proc);
457: fnd_message.set_token('STEP','15');
458: fnd_message.raise_error;
459: End dt_update_validate;
460: --
461: -- ----------------------------------------------------------------------------
462: -- |--------------------------< dt_delete_validate >--------------------------|
547: --
548: -- A referential integrity check was violated therefore
549: -- we must error
550: --
551: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
552: fnd_message.set_token('TABLE_NAME', l_table_name);
553: fnd_message.raise_error;
554: When Others Then
555: --
548: -- A referential integrity check was violated therefore
549: -- we must error
550: --
551: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
552: fnd_message.set_token('TABLE_NAME', l_table_name);
553: fnd_message.raise_error;
554: When Others Then
555: --
556: -- An unhandled or unexpected error has occurred which
549: -- we must error
550: --
551: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
552: fnd_message.set_token('TABLE_NAME', l_table_name);
553: fnd_message.raise_error;
554: When Others Then
555: --
556: -- An unhandled or unexpected error has occurred which
557: -- we must report
555: --
556: -- An unhandled or unexpected error has occurred which
557: -- we must report
558: --
559: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
560: fnd_message.set_token('PROCEDURE', l_proc);
561: fnd_message.set_token('STEP','15');
562: fnd_message.raise_error;
563: End dt_delete_validate;
556: -- An unhandled or unexpected error has occurred which
557: -- we must report
558: --
559: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
560: fnd_message.set_token('PROCEDURE', l_proc);
561: fnd_message.set_token('STEP','15');
562: fnd_message.raise_error;
563: End dt_delete_validate;
564: --
557: -- we must report
558: --
559: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
560: fnd_message.set_token('PROCEDURE', l_proc);
561: fnd_message.set_token('STEP','15');
562: fnd_message.raise_error;
563: End dt_delete_validate;
564: --
565: -- ----------------------------------------------------------------------------
558: --
559: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
560: fnd_message.set_token('PROCEDURE', l_proc);
561: fnd_message.set_token('STEP','15');
562: fnd_message.raise_error;
563: End dt_delete_validate;
564: --
565: -- ----------------------------------------------------------------------------
566: -- |---------------------------< insert_validate >----------------------------|
752: close csr_leg_code;
753: --
754: -- The primary key is invalid therefore we must error
755: --
756: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
757: fnd_message.raise_error;
758: --
759: end if;
760: --
753: --
754: -- The primary key is invalid therefore we must error
755: --
756: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
757: fnd_message.raise_error;
758: --
759: end if;
760: --
761: close csr_leg_code;