171: close c3;
172: --
173: -- raise error as this comp lvl already exists for this profile
174: --
175: fnd_message.set_name('BEN', 'BEN_91349_DUP_ELIG_CRITERIA');
176: fnd_message.raise_error;
177: --
178: end if;
179: close c3;
172: --
173: -- raise error as this comp lvl already exists for this profile
174: --
175: fnd_message.set_name('BEN', 'BEN_91349_DUP_ELIG_CRITERIA');
176: fnd_message.raise_error;
177: --
178: end if;
179: close c3;
180: --
248: --
249: -- raise error as this eligibility factor is invalid
250: -- create generic message here
251: --
252: fnd_message.set_name('BEN', 'BEN_91389_INV_FCTR');
253: --fnd_message.set_token('PROCEDURE', l_proc);
254: --fnd_message.set_token('STEP','5');
255: fnd_message.raise_error;
256: --
249: -- raise error as this eligibility factor is invalid
250: -- create generic message here
251: --
252: fnd_message.set_name('BEN', 'BEN_91389_INV_FCTR');
253: --fnd_message.set_token('PROCEDURE', l_proc);
254: --fnd_message.set_token('STEP','5');
255: fnd_message.raise_error;
256: --
257: end if;
250: -- create generic message here
251: --
252: fnd_message.set_name('BEN', 'BEN_91389_INV_FCTR');
253: --fnd_message.set_token('PROCEDURE', l_proc);
254: --fnd_message.set_token('STEP','5');
255: fnd_message.raise_error;
256: --
257: end if;
258: --
251: --
252: fnd_message.set_name('BEN', 'BEN_91389_INV_FCTR');
253: --fnd_message.set_token('PROCEDURE', l_proc);
254: --fnd_message.set_token('STEP','5');
255: fnd_message.raise_error;
256: --
257: end if;
258: --
259: close c1;
314: --
315: -- raise error as this eligibility factor is invalid
316: -- create generic message here
317: --
318: fnd_message.set_name('BEN', 'BEN_91390_INV_FCTR_FOR_STAT');
319: --fnd_message.set_token('PROCEDURE', l_proc);
320: --fnd_message.set_token('STEP','5');
321: fnd_message.raise_error;
322: --
315: -- raise error as this eligibility factor is invalid
316: -- create generic message here
317: --
318: fnd_message.set_name('BEN', 'BEN_91390_INV_FCTR_FOR_STAT');
319: --fnd_message.set_token('PROCEDURE', l_proc);
320: --fnd_message.set_token('STEP','5');
321: fnd_message.raise_error;
322: --
323: end if;
316: -- create generic message here
317: --
318: fnd_message.set_name('BEN', 'BEN_91390_INV_FCTR_FOR_STAT');
319: --fnd_message.set_token('PROCEDURE', l_proc);
320: --fnd_message.set_token('STEP','5');
321: fnd_message.raise_error;
322: --
323: end if;
324: --
317: --
318: fnd_message.set_name('BEN', 'BEN_91390_INV_FCTR_FOR_STAT');
319: --fnd_message.set_token('PROCEDURE', l_proc);
320: --fnd_message.set_token('STEP','5');
321: fnd_message.raise_error;
322: --
323: end if;
324: --
325: close c1;
387: p_effective_date => p_effective_date) then
388: --
389: -- raise error as does not exist as lookup
390: --
391: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
392: fnd_message.raise_error;
393: --
394: end if;
395: --
388: --
389: -- raise error as does not exist as lookup
390: --
391: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
392: fnd_message.raise_error;
393: --
394: end if;
395: --
396: end if;
449: open c1;
450: fetch c1 into l_dummy;
451: if c1%found then
452: close c1;
453: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
454: fnd_message.raise_error;
455: end if;
456: close c1;
457: --
450: fetch c1 into l_dummy;
451: if c1%found then
452: close c1;
453: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
454: fnd_message.raise_error;
455: end if;
456: close c1;
457: --
458: hr_utility.set_location('Leaving:'||l_proc, 15);
549: --
550: -- An unhandled or unexpected error has occurred which
551: -- we must report
552: --
553: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
554: fnd_message.set_token('PROCEDURE', l_proc);
555: fnd_message.set_token('STEP','15');
556: fnd_message.raise_error;
557: End dt_update_validate;
550: -- An unhandled or unexpected error has occurred which
551: -- we must report
552: --
553: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
554: fnd_message.set_token('PROCEDURE', l_proc);
555: fnd_message.set_token('STEP','15');
556: fnd_message.raise_error;
557: End dt_update_validate;
558: --
551: -- we must report
552: --
553: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
554: fnd_message.set_token('PROCEDURE', l_proc);
555: fnd_message.set_token('STEP','15');
556: fnd_message.raise_error;
557: End dt_update_validate;
558: --
559: -- ----------------------------------------------------------------------------
552: --
553: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
554: fnd_message.set_token('PROCEDURE', l_proc);
555: fnd_message.set_token('STEP','15');
556: fnd_message.raise_error;
557: End dt_update_validate;
558: --
559: -- ----------------------------------------------------------------------------
560: -- |--------------------------< dt_delete_validate >--------------------------|
652: --
653: -- An unhandled or unexpected error has occurred which
654: -- we must report
655: --
656: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
657: fnd_message.set_token('PROCEDURE', l_proc);
658: fnd_message.set_token('STEP','15');
659: fnd_message.raise_error;
660: End dt_delete_validate;
653: -- An unhandled or unexpected error has occurred which
654: -- we must report
655: --
656: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
657: fnd_message.set_token('PROCEDURE', l_proc);
658: fnd_message.set_token('STEP','15');
659: fnd_message.raise_error;
660: End dt_delete_validate;
661: --
654: -- we must report
655: --
656: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
657: fnd_message.set_token('PROCEDURE', l_proc);
658: fnd_message.set_token('STEP','15');
659: fnd_message.raise_error;
660: End dt_delete_validate;
661: --
662: -- ----------------------------------------------------------------------------
655: --
656: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
657: fnd_message.set_token('PROCEDURE', l_proc);
658: fnd_message.set_token('STEP','15');
659: fnd_message.raise_error;
660: End dt_delete_validate;
661: --
662: -- ----------------------------------------------------------------------------
663: -- |---------------------------< insert_validate >----------------------------|
838: close csr_leg_code;
839: --
840: -- The primary key is invalid therefore we must error
841: --
842: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
843: fnd_message.raise_error;
844: --
845: end if;
846: --
839: --
840: -- The primary key is invalid therefore we must error
841: --
842: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
843: fnd_message.raise_error;
844: --
845: end if;
846: --
847: close csr_leg_code;