133: p_effective_date => p_effective_date) then
134: --
135: -- raise error as does not exist as lookup
136: --
137: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
138: fnd_message.raise_error;
139: --
140: end if;
141: --
134: --
135: -- raise error as does not exist as lookup
136: --
137: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
138: fnd_message.raise_error;
139: --
140: end if;
141: --
142: end if;
199: open c1;
200: fetch c1 into dummy;
201: if c1%found then
202: close c1;
203: fnd_message.set_name('BEN','BEN_91009_NAME_NOT_UNIQUE');
204: fnd_message.raise_error;
205: end if;
206: close c1;
207: --
200: fetch c1 into dummy;
201: if c1%found then
202: close c1;
203: fnd_message.set_name('BEN','BEN_91009_NAME_NOT_UNIQUE');
204: fnd_message.raise_error;
205: end if;
206: close c1;
207: --
208: hr_utility.set_location('Leaving:'||l_proc, 10);
266: open c1;
267: fetch c1 into l_dummy;
268: --
269: if c1%found then
270: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
271: fnd_message.raise_error;
272: end if;
273: close c1;
274: --
267: fetch c1 into l_dummy;
268: --
269: if c1%found then
270: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
271: fnd_message.raise_error;
272: end if;
273: close c1;
274: --
275: hr_utility.set_location('Leaving:'||l_proc, 15);
380: --
381: -- An unhandled or unexpected error has occurred which
382: -- we must report
383: --
384: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
385: fnd_message.set_token('PROCEDURE', l_proc);
386: fnd_message.set_token('STEP','15');
387: fnd_message.raise_error;
388: End dt_update_validate;
381: -- An unhandled or unexpected error has occurred which
382: -- we must report
383: --
384: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
385: fnd_message.set_token('PROCEDURE', l_proc);
386: fnd_message.set_token('STEP','15');
387: fnd_message.raise_error;
388: End dt_update_validate;
389: --
382: -- we must report
383: --
384: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
385: fnd_message.set_token('PROCEDURE', l_proc);
386: fnd_message.set_token('STEP','15');
387: fnd_message.raise_error;
388: End dt_update_validate;
389: --
390: -- ----------------------------------------------------------------------------
383: --
384: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
385: fnd_message.set_token('PROCEDURE', l_proc);
386: fnd_message.set_token('STEP','15');
387: fnd_message.raise_error;
388: End dt_update_validate;
389: --
390: -- ----------------------------------------------------------------------------
391: -- |--------------------------< dt_delete_validate >--------------------------|
482: --
483: -- An unhandled or unexpected error has occurred which
484: -- we must report
485: --
486: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
487: fnd_message.set_token('PROCEDURE', l_proc);
488: fnd_message.set_token('STEP','15');
489: fnd_message.raise_error;
490: End dt_delete_validate;
483: -- An unhandled or unexpected error has occurred which
484: -- we must report
485: --
486: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
487: fnd_message.set_token('PROCEDURE', l_proc);
488: fnd_message.set_token('STEP','15');
489: fnd_message.raise_error;
490: End dt_delete_validate;
491: --
484: -- we must report
485: --
486: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
487: fnd_message.set_token('PROCEDURE', l_proc);
488: fnd_message.set_token('STEP','15');
489: fnd_message.raise_error;
490: End dt_delete_validate;
491: --
492: -- ----------------------------------------------------------------------------
485: --
486: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
487: fnd_message.set_token('PROCEDURE', l_proc);
488: fnd_message.set_token('STEP','15');
489: fnd_message.raise_error;
490: End dt_delete_validate;
491: --
492: -- ----------------------------------------------------------------------------
493: -- |---------------------------< insert_validate >----------------------------|
668: close csr_leg_code;
669: --
670: -- The primary key is invalid therefore we must error
671: --
672: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
673: fnd_message.raise_error;
674: --
675: end if;
676: --
669: --
670: -- The primary key is invalid therefore we must error
671: --
672: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
673: fnd_message.raise_error;
674: --
675: end if;
676: --
677: close csr_leg_code;