DBA Data[Home] [Help]

APPS.BEN_PDL_BUS dependencies on FND_MESSAGE

Line 143: fnd_message.set_name('BEN','BEN_91009_NAME_NOT_UNIQUE');

139: open c1;
140: fetch c1 into l_dummy;
141: if c1%found then
142: close c1;
143: fnd_message.set_name('BEN','BEN_91009_NAME_NOT_UNIQUE');
144: fnd_message.raise_error;
145: end if;
146: end if;
147: --

Line 144: fnd_message.raise_error;

140: fetch c1 into l_dummy;
141: if c1%found then
142: close c1;
143: fnd_message.set_name('BEN','BEN_91009_NAME_NOT_UNIQUE');
144: fnd_message.raise_error;
145: end if;
146: end if;
147: --
148: hr_utility.set_location('Leaving:'||l_proc, 15);

Line 297: fnd_message.set_name('BEN','BEN_91770_BAL_TYPE_NOT_EXIST');

293: --
294: -- raise error as FK does not relate to PK in pay_balance_types
295: -- table.
296: --
297: fnd_message.set_name('BEN','BEN_91770_BAL_TYPE_NOT_EXIST');
298: fnd_message.raise_error;
299: --
300: end if;
301: --

Line 298: fnd_message.raise_error;

294: -- raise error as FK does not relate to PK in pay_balance_types
295: -- table.
296: --
297: fnd_message.set_name('BEN','BEN_91770_BAL_TYPE_NOT_EXIST');
298: fnd_message.raise_error;
299: --
300: end if;
301: --
302: close c1;

Line 368: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');

364: p_effective_date => p_effective_date) then
365: --
366: -- raise error as does not exist as lookup
367: --
368: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
369: fnd_message.set_token('FIELD','p_lmt_det_cd');
370: fnd_message.set_token('TYPE','BEN_LMT_DET');
371: fnd_message.raise_error;
372: --

Line 369: fnd_message.set_token('FIELD','p_lmt_det_cd');

365: --
366: -- raise error as does not exist as lookup
367: --
368: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
369: fnd_message.set_token('FIELD','p_lmt_det_cd');
370: fnd_message.set_token('TYPE','BEN_LMT_DET');
371: fnd_message.raise_error;
372: --
373: end if;

Line 370: fnd_message.set_token('TYPE','BEN_LMT_DET');

366: -- raise error as does not exist as lookup
367: --
368: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
369: fnd_message.set_token('FIELD','p_lmt_det_cd');
370: fnd_message.set_token('TYPE','BEN_LMT_DET');
371: fnd_message.raise_error;
372: --
373: end if;
374: --

Line 371: fnd_message.raise_error;

367: --
368: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
369: fnd_message.set_token('FIELD','p_lmt_det_cd');
370: fnd_message.set_token('TYPE','BEN_LMT_DET');
371: fnd_message.raise_error;
372: --
373: end if;
374: --
375: end if;

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

457: close c1;
458: --
459: -- raise error
460: --
461: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
462: fnd_message.set_token('ID',p_ptd_lmt_calc_rl);
463: fnd_message.set_token('TYPE_ID',-167);
464: fnd_message.raise_error;
465: --

Line 462: fnd_message.set_token('ID',p_ptd_lmt_calc_rl);

458: --
459: -- raise error
460: --
461: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
462: fnd_message.set_token('ID',p_ptd_lmt_calc_rl);
463: fnd_message.set_token('TYPE_ID',-167);
464: fnd_message.raise_error;
465: --
466: end if;

Line 463: fnd_message.set_token('TYPE_ID',-167);

459: -- raise error
460: --
461: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
462: fnd_message.set_token('ID',p_ptd_lmt_calc_rl);
463: fnd_message.set_token('TYPE_ID',-167);
464: fnd_message.raise_error;
465: --
466: end if;
467: --

Line 464: fnd_message.raise_error;

460: --
461: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
462: fnd_message.set_token('ID',p_ptd_lmt_calc_rl);
463: fnd_message.set_token('TYPE_ID',-167);
464: fnd_message.raise_error;
465: --
466: end if;
467: --
468: close c1;

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

556: --
557: -- An unhandled or unexpected error has occurred which
558: -- we must report
559: --
560: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
561: fnd_message.set_token('PROCEDURE', l_proc);
562: fnd_message.set_token('STEP','15');
563: fnd_message.raise_error;
564: End dt_update_validate;

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

557: -- An unhandled or unexpected error has occurred which
558: -- we must report
559: --
560: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
561: fnd_message.set_token('PROCEDURE', l_proc);
562: fnd_message.set_token('STEP','15');
563: fnd_message.raise_error;
564: End dt_update_validate;
565: --

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

558: -- we must report
559: --
560: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
561: fnd_message.set_token('PROCEDURE', l_proc);
562: fnd_message.set_token('STEP','15');
563: fnd_message.raise_error;
564: End dt_update_validate;
565: --
566: -- ----------------------------------------------------------------------------

Line 563: fnd_message.raise_error;

559: --
560: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
561: fnd_message.set_token('PROCEDURE', l_proc);
562: fnd_message.set_token('STEP','15');
563: fnd_message.raise_error;
564: End dt_update_validate;
565: --
566: -- ----------------------------------------------------------------------------
567: -- |--------------------------< dt_delete_validate >--------------------------|

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

667: --
668: -- An unhandled or unexpected error has occurred which
669: -- we must report
670: --
671: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
672: fnd_message.set_token('PROCEDURE', l_proc);
673: fnd_message.set_token('STEP','15');
674: fnd_message.raise_error;
675: End dt_delete_validate;

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

668: -- An unhandled or unexpected error has occurred which
669: -- we must report
670: --
671: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
672: fnd_message.set_token('PROCEDURE', l_proc);
673: fnd_message.set_token('STEP','15');
674: fnd_message.raise_error;
675: End dt_delete_validate;
676: --

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

669: -- we must report
670: --
671: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
672: fnd_message.set_token('PROCEDURE', l_proc);
673: fnd_message.set_token('STEP','15');
674: fnd_message.raise_error;
675: End dt_delete_validate;
676: --
677: -- ----------------------------------------------------------------------------

Line 674: fnd_message.raise_error;

670: --
671: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
672: fnd_message.set_token('PROCEDURE', l_proc);
673: fnd_message.set_token('STEP','15');
674: fnd_message.raise_error;
675: End dt_delete_validate;
676: --
677: -- ----------------------------------------------------------------------------
678: -- |---------------------------< insert_validate >----------------------------|

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

865: close csr_leg_code;
866: --
867: -- The primary key is invalid therefore we must error
868: --
869: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
870: fnd_message.raise_error;
871: --
872: end if;
873: --

Line 870: fnd_message.raise_error;

866: --
867: -- The primary key is invalid therefore we must error
868: --
869: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
870: fnd_message.raise_error;
871: --
872: end if;
873: --
874: close csr_leg_code;