213: close c3;
214: --
215: -- raise error as this ee status already exists for this profile
216: --
217: fnd_message.set_name('BEN', 'BEN_91349_DUP_ELIG_CRITERIA');
218: fnd_message.raise_error;
219: --
220: end if;
221: --
214: --
215: -- raise error as this ee status already exists for this profile
216: --
217: fnd_message.set_name('BEN', 'BEN_91349_DUP_ELIG_CRITERIA');
218: fnd_message.raise_error;
219: --
220: end if;
221: --
222: close c3;
230: --
231: close c2;
232: --
233: -- raise error as ee status type can not be set to Terminated
234: fnd_message.set_name('BEN', 'BEN_91388_INV_EE_STAT');
235: fnd_message.raise_error;
236: --
237: end if;
238: --
231: close c2;
232: --
233: -- raise error as ee status type can not be set to Terminated
234: fnd_message.set_name('BEN', 'BEN_91388_INV_EE_STAT');
235: fnd_message.raise_error;
236: --
237: end if;
238: --
239: close c2;
302: p_effective_date => p_effective_date) then
303: --
304: -- raise error as does not exist as lookup
305: --
306: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
307: fnd_message.raise_error;
308: --
309: end if;
310: --
303: --
304: -- raise error as does not exist as lookup
305: --
306: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
307: fnd_message.raise_error;
308: --
309: end if;
310: --
311: end if;
364: open c1;
365: fetch c1 into l_dummy;
366: if c1%found then
367: close c1;
368: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
369: fnd_message.raise_error;
370: end if;
371: close c1;
372: --
365: fetch c1 into l_dummy;
366: if c1%found then
367: close c1;
368: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
369: fnd_message.raise_error;
370: end if;
371: close c1;
372: --
373: hr_utility.set_location('Leaving:'||l_proc, 15);
464: --
465: -- An unhandled or unexpected error has occurred which
466: -- we must report
467: --
468: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
469: fnd_message.set_token('PROCEDURE', l_proc);
470: fnd_message.set_token('STEP','15');
471: fnd_message.raise_error;
472: End dt_update_validate;
465: -- An unhandled or unexpected error has occurred which
466: -- we must report
467: --
468: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
469: fnd_message.set_token('PROCEDURE', l_proc);
470: fnd_message.set_token('STEP','15');
471: fnd_message.raise_error;
472: End dt_update_validate;
473: --
466: -- we must report
467: --
468: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
469: fnd_message.set_token('PROCEDURE', l_proc);
470: fnd_message.set_token('STEP','15');
471: fnd_message.raise_error;
472: End dt_update_validate;
473: --
474: -- ----------------------------------------------------------------------------
467: --
468: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
469: fnd_message.set_token('PROCEDURE', l_proc);
470: fnd_message.set_token('STEP','15');
471: fnd_message.raise_error;
472: End dt_update_validate;
473: --
474: -- ----------------------------------------------------------------------------
475: -- |--------------------------< dt_delete_validate >--------------------------|
567: --
568: -- An unhandled or unexpected error has occurred which
569: -- we must report
570: --
571: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
572: fnd_message.set_token('PROCEDURE', l_proc);
573: fnd_message.set_token('STEP','15');
574: fnd_message.raise_error;
575: End dt_delete_validate;
568: -- An unhandled or unexpected error has occurred which
569: -- we must report
570: --
571: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
572: fnd_message.set_token('PROCEDURE', l_proc);
573: fnd_message.set_token('STEP','15');
574: fnd_message.raise_error;
575: End dt_delete_validate;
576: --
569: -- we must report
570: --
571: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
572: fnd_message.set_token('PROCEDURE', l_proc);
573: fnd_message.set_token('STEP','15');
574: fnd_message.raise_error;
575: End dt_delete_validate;
576: --
577: -- ----------------------------------------------------------------------------
570: --
571: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
572: fnd_message.set_token('PROCEDURE', l_proc);
573: fnd_message.set_token('STEP','15');
574: fnd_message.raise_error;
575: End dt_delete_validate;
576: --
577: -- ----------------------------------------------------------------------------
578: -- |---------------------------< insert_validate >----------------------------|
751: close csr_leg_code;
752: --
753: -- The primary key is invalid therefore we must error
754: --
755: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
756: fnd_message.raise_error;
757: --
758: end if;
759: --
752: --
753: -- The primary key is invalid therefore we must error
754: --
755: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
756: fnd_message.raise_error;
757: --
758: end if;
759: --
760: close csr_leg_code;