DBA Data[Home] [Help]

APPS.BEN_LRR_BUS dependencies on FND_MESSAGE

Line 154: fnd_message.set_name('PAY','VALUE IS NOT UNIQUE');

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: --

Line 155: fnd_message.raise_error;

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;

Line 257: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');

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: --

Line 258: fnd_message.set_token('ID',p_formula_id);

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;

Line 259: fnd_message.set_token('TYPE_ID',-393);

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;

Line 260: fnd_message.raise_error;

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: --

Line 274: fnd_message.set_name('PAY','VALUE IS NOT UNIQUE');

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: --

Line 275: fnd_message.raise_error;

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;

Line 391: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

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;

Line 392: fnd_message.set_token('PROCEDURE', l_proc);

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: --

Line 393: fnd_message.set_token('STEP','15');

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: -- ----------------------------------------------------------------------------

Line 394: fnd_message.raise_error;

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 >--------------------------|

Line 493: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

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;

Line 494: fnd_message.set_token('PROCEDURE', l_proc);

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: --

Line 495: fnd_message.set_token('STEP','15');

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: -- ----------------------------------------------------------------------------

Line 496: fnd_message.raise_error;

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 >----------------------------|

Line 672: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');

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: --

Line 673: fnd_message.raise_error;

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;