150: close chk_unique;
151: --
152: -- raise error as UK1 is violated
153: --
154: fnd_message.set_name('PAY','VALUE IS NOT UNIQUE');
155: fnd_message.raise_error;
156: --
157: end if;
158: --
151: --
152: -- raise error as UK1 is violated
153: --
154: fnd_message.set_name('PAY','VALUE IS NOT UNIQUE');
155: fnd_message.raise_error;
156: --
157: end if;
158: --
159: close chk_unique;
253: fetch c1 into l_dummy;
254: if c1%notfound then
255: close c1;
256: -- raise error
257: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
258: fnd_message.set_token('ID',p_formula_id);
259: fnd_message.set_token('TYPE_ID',-393);
260: fnd_message.raise_error;
261: --
254: if c1%notfound then
255: close c1;
256: -- raise error
257: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
258: fnd_message.set_token('ID',p_formula_id);
259: fnd_message.set_token('TYPE_ID',-393);
260: fnd_message.raise_error;
261: --
262: end if;
255: close c1;
256: -- raise error
257: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
258: fnd_message.set_token('ID',p_formula_id);
259: fnd_message.set_token('TYPE_ID',-393);
260: fnd_message.raise_error;
261: --
262: end if;
263: close c1;
256: -- raise error
257: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
258: fnd_message.set_token('ID',p_formula_id);
259: fnd_message.set_token('TYPE_ID',-393);
260: fnd_message.raise_error;
261: --
262: end if;
263: close c1;
264: --
270: close chk_unique;
271: --
272: -- raise error as UK1 is violated
273: --
274: fnd_message.set_name('PAY','VALUE IS NOT UNIQUE');
275: fnd_message.raise_error;
276: --
277: end if;
278: --
271: --
272: -- raise error as UK1 is violated
273: --
274: fnd_message.set_name('PAY','VALUE IS NOT UNIQUE');
275: fnd_message.raise_error;
276: --
277: end if;
278: --
279: close chk_unique;
387: --
388: -- An unhandled or unexpected error has occurred which
389: -- we must report
390: --
391: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
392: fnd_message.set_token('PROCEDURE', l_proc);
393: fnd_message.set_token('STEP','15');
394: fnd_message.raise_error;
395: End dt_update_validate;
388: -- An unhandled or unexpected error has occurred which
389: -- we must report
390: --
391: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
392: fnd_message.set_token('PROCEDURE', l_proc);
393: fnd_message.set_token('STEP','15');
394: fnd_message.raise_error;
395: End dt_update_validate;
396: --
389: -- we must report
390: --
391: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
392: fnd_message.set_token('PROCEDURE', l_proc);
393: fnd_message.set_token('STEP','15');
394: fnd_message.raise_error;
395: End dt_update_validate;
396: --
397: -- ----------------------------------------------------------------------------
390: --
391: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
392: fnd_message.set_token('PROCEDURE', l_proc);
393: fnd_message.set_token('STEP','15');
394: fnd_message.raise_error;
395: End dt_update_validate;
396: --
397: -- ----------------------------------------------------------------------------
398: -- |--------------------------< dt_delete_validate >--------------------------|
489: --
490: -- An unhandled or unexpected error has occurred which
491: -- we must report
492: --
493: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
494: fnd_message.set_token('PROCEDURE', l_proc);
495: fnd_message.set_token('STEP','15');
496: fnd_message.raise_error;
497: End dt_delete_validate;
490: -- An unhandled or unexpected error has occurred which
491: -- we must report
492: --
493: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
494: fnd_message.set_token('PROCEDURE', l_proc);
495: fnd_message.set_token('STEP','15');
496: fnd_message.raise_error;
497: End dt_delete_validate;
498: --
491: -- we must report
492: --
493: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
494: fnd_message.set_token('PROCEDURE', l_proc);
495: fnd_message.set_token('STEP','15');
496: fnd_message.raise_error;
497: End dt_delete_validate;
498: --
499: -- ----------------------------------------------------------------------------
492: --
493: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
494: fnd_message.set_token('PROCEDURE', l_proc);
495: fnd_message.set_token('STEP','15');
496: fnd_message.raise_error;
497: End dt_delete_validate;
498: --
499: -- ----------------------------------------------------------------------------
500: -- |---------------------------< 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;