137: hr_utility.set_location(l_proc, 7);
138: --
139: -- raise error as duplicate criteria has been entered
140: --
141: fnd_message.set_name('BEN','BEN_91349_DUP_ELIG_CRITERIA');
142: fnd_message.raise_error;
143: --
144: end if;
145: --
138: --
139: -- raise error as duplicate criteria has been entered
140: --
141: fnd_message.set_name('BEN','BEN_91349_DUP_ELIG_CRITERIA');
142: fnd_message.raise_error;
143: --
144: end if;
145: --
146: close c_elig_gndr_prte;
208: p_effective_date => p_effective_date) then
209: --
210: -- raise error as does not exist as lookup
211: --
212: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
213: fnd_message.raise_error;
214: --
215: end if;
216: --
209: --
210: -- raise error as does not exist as lookup
211: --
212: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
213: fnd_message.raise_error;
214: --
215: end if;
216: --
217: end if;
269: open c1;
270: fetch c1 into l_dummy;
271: if c1%found then
272: close c1;
273: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
274: fnd_message.raise_error;
275: end if;
276: close c1;
277: --
270: fetch c1 into l_dummy;
271: if c1%found then
272: close c1;
273: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
274: fnd_message.raise_error;
275: end if;
276: close c1;
277: --
278: hr_utility.set_location('Leaving:'||l_proc, 15);
335: p_effective_date => p_effective_date) then
336: --
337: -- raise error as does not exist as lookup
338: --
339: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
340: fnd_message.raise_error;
341: --
342: end if;
343: --
336: --
337: -- raise error as does not exist as lookup
338: --
339: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
340: fnd_message.raise_error;
341: --
342: end if;
343: --
344: end if;
439: --
440: -- An unhandled or unexpected error has occurred which
441: -- we must report
442: --
443: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
444: fnd_message.set_token('PROCEDURE', l_proc);
445: fnd_message.set_token('STEP','15');
446: fnd_message.raise_error;
447: End dt_update_validate;
440: -- An unhandled or unexpected error has occurred which
441: -- we must report
442: --
443: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
444: fnd_message.set_token('PROCEDURE', l_proc);
445: fnd_message.set_token('STEP','15');
446: fnd_message.raise_error;
447: End dt_update_validate;
448: --
441: -- we must report
442: --
443: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
444: fnd_message.set_token('PROCEDURE', l_proc);
445: fnd_message.set_token('STEP','15');
446: fnd_message.raise_error;
447: End dt_update_validate;
448: --
449: -- ----------------------------------------------------------------------------
442: --
443: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
444: fnd_message.set_token('PROCEDURE', l_proc);
445: fnd_message.set_token('STEP','15');
446: fnd_message.raise_error;
447: End dt_update_validate;
448: --
449: -- ----------------------------------------------------------------------------
450: -- |--------------------------< dt_delete_validate >--------------------------|
541: --
542: -- An unhandled or unexpected error has occurred which
543: -- we must report
544: --
545: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
546: fnd_message.set_token('PROCEDURE', l_proc);
547: fnd_message.set_token('STEP','15');
548: fnd_message.raise_error;
549: End dt_delete_validate;
542: -- An unhandled or unexpected error has occurred which
543: -- we must report
544: --
545: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
546: fnd_message.set_token('PROCEDURE', l_proc);
547: fnd_message.set_token('STEP','15');
548: fnd_message.raise_error;
549: End dt_delete_validate;
550: --
543: -- we must report
544: --
545: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
546: fnd_message.set_token('PROCEDURE', l_proc);
547: fnd_message.set_token('STEP','15');
548: fnd_message.raise_error;
549: End dt_delete_validate;
550: --
551: -- ----------------------------------------------------------------------------
544: --
545: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
546: fnd_message.set_token('PROCEDURE', l_proc);
547: fnd_message.set_token('STEP','15');
548: fnd_message.raise_error;
549: End dt_delete_validate;
550: --
551: -- ----------------------------------------------------------------------------
552: -- |---------------------------< insert_validate >----------------------------|
730: close csr_leg_code;
731: --
732: -- The primary key is invalid therefore we must error
733: --
734: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
735: fnd_message.raise_error;
736: --
737: end if;
738: --
731: --
732: -- The primary key is invalid therefore we must error
733: --
734: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
735: fnd_message.raise_error;
736: --
737: end if;
738: --
739: close csr_leg_code;