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_enrl_det_dt_cd');
139: fnd_message.set_token('TYPE','BEN_ENRL_DET_DT');
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_enrl_det_dt_cd');
139: fnd_message.set_token('TYPE','BEN_ENRL_DET_DT');
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_enrl_det_dt_cd');
139: fnd_message.set_token('TYPE','BEN_ENRL_DET_DT');
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_enrl_det_dt_cd');
139: fnd_message.set_token('TYPE','BEN_ENRL_DET_DT');
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_excld_flag');
210: fnd_message.set_token('TYPE','YES_NO');
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_excld_flag');
210: fnd_message.set_token('TYPE','YES_NO');
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_excld_flag');
210: fnd_message.set_token('TYPE','YES_NO');
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_excld_flag');
210: fnd_message.set_token('TYPE','YES_NO');
211: fnd_message.raise_error;
212: --
213: end if;
214: --
215: end if;
268: open c1;
269: fetch c1 into l_dummy;
270: if c1%found then
271: close c1;
272: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
273: fnd_message.raise_error;
274: end if;
275: close c1;
276: --
269: fetch c1 into l_dummy;
270: if c1%found then
271: close c1;
272: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
273: fnd_message.raise_error;
274: end if;
275: close c1;
276: --
277: hr_utility.set_location('Leaving:'||l_proc, 15);
379: --
380: -- An unhandled or unexpected error has occurred which
381: -- we must report
382: --
383: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
384: fnd_message.set_token('PROCEDURE', l_proc);
385: fnd_message.set_token('STEP','15');
386: fnd_message.raise_error;
387: End dt_update_validate;
380: -- An unhandled or unexpected error has occurred which
381: -- we must report
382: --
383: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
384: fnd_message.set_token('PROCEDURE', l_proc);
385: fnd_message.set_token('STEP','15');
386: fnd_message.raise_error;
387: End dt_update_validate;
388: --
381: -- we must report
382: --
383: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
384: fnd_message.set_token('PROCEDURE', l_proc);
385: fnd_message.set_token('STEP','15');
386: fnd_message.raise_error;
387: End dt_update_validate;
388: --
389: -- ----------------------------------------------------------------------------
382: --
383: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
384: fnd_message.set_token('PROCEDURE', l_proc);
385: fnd_message.set_token('STEP','15');
386: fnd_message.raise_error;
387: End dt_update_validate;
388: --
389: -- ----------------------------------------------------------------------------
390: -- |--------------------------< dt_delete_validate >--------------------------|
475: --
476: -- A referential integrity check was violated therefore
477: -- we must error
478: --
479: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
480: fnd_message.set_token('TABLE_NAME', l_table_name);
481: fnd_message.raise_error;
482: When Others Then
483: --
476: -- A referential integrity check was violated therefore
477: -- we must error
478: --
479: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
480: fnd_message.set_token('TABLE_NAME', l_table_name);
481: fnd_message.raise_error;
482: When Others Then
483: --
484: -- An unhandled or unexpected error has occurred which
477: -- we must error
478: --
479: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
480: fnd_message.set_token('TABLE_NAME', l_table_name);
481: fnd_message.raise_error;
482: When Others Then
483: --
484: -- An unhandled or unexpected error has occurred which
485: -- we must report
483: --
484: -- An unhandled or unexpected error has occurred which
485: -- we must report
486: --
487: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
488: fnd_message.set_token('PROCEDURE', l_proc);
489: fnd_message.set_token('STEP','15');
490: fnd_message.raise_error;
491: End dt_delete_validate;
484: -- An unhandled or unexpected error has occurred which
485: -- we must report
486: --
487: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
488: fnd_message.set_token('PROCEDURE', l_proc);
489: fnd_message.set_token('STEP','15');
490: fnd_message.raise_error;
491: End dt_delete_validate;
492: --
485: -- we must report
486: --
487: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
488: fnd_message.set_token('PROCEDURE', l_proc);
489: fnd_message.set_token('STEP','15');
490: fnd_message.raise_error;
491: End dt_delete_validate;
492: --
493: -- ----------------------------------------------------------------------------
486: --
487: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
488: fnd_message.set_token('PROCEDURE', l_proc);
489: fnd_message.set_token('STEP','15');
490: fnd_message.raise_error;
491: End dt_delete_validate;
492: --
493: -- ----------------------------------------------------------------------------
494: -- |---------------------------< insert_validate >----------------------------|
658: close csr_leg_code;
659: --
660: -- The primary key is invalid therefore we must error
661: --
662: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
663: fnd_message.raise_error;
664: --
665: end if;
666: --
659: --
660: -- The primary key is invalid therefore we must error
661: --
662: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
663: fnd_message.raise_error;
664: --
665: end if;
666: --
667: close csr_leg_code;