DBA Data[Home] [Help]

APPS.BEN_ECF_BUS dependencies on FND_MESSAGE

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

133: p_effective_date => p_effective_date) then
134: --
135: -- raise error as does not exist as lookup
136: --
137: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
138: fnd_message.set_token('FIELD', 'p_enrt_ctfn_typ_cd');
139: fnd_message.set_token('TYPE','BEN_ENRT_CTFN_TYP');
140: fnd_message.raise_error;
141: --

Line 138: fnd_message.set_token('FIELD', 'p_enrt_ctfn_typ_cd');

134: --
135: -- raise error as does not exist as lookup
136: --
137: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
138: fnd_message.set_token('FIELD', 'p_enrt_ctfn_typ_cd');
139: fnd_message.set_token('TYPE','BEN_ENRT_CTFN_TYP');
140: fnd_message.raise_error;
141: --
142: end if;

Line 139: fnd_message.set_token('TYPE','BEN_ENRT_CTFN_TYP');

135: -- raise error as does not exist as lookup
136: --
137: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
138: fnd_message.set_token('FIELD', 'p_enrt_ctfn_typ_cd');
139: fnd_message.set_token('TYPE','BEN_ENRT_CTFN_TYP');
140: fnd_message.raise_error;
141: --
142: end if;
143: --

Line 140: fnd_message.raise_error;

136: --
137: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
138: fnd_message.set_token('FIELD', 'p_enrt_ctfn_typ_cd');
139: fnd_message.set_token('TYPE','BEN_ENRT_CTFN_TYP');
140: fnd_message.raise_error;
141: --
142: end if;
143: --
144: end if;

Line 210: fnd_message.set_name('BEN','BEN_92248_ENRT_TYP_UNIQUE');

206: open c1;
207: fetch c1 into l_dummy;
208: if c1%found then
209: close c1;
210: fnd_message.set_name('BEN','BEN_92248_ENRT_TYP_UNIQUE');
211: fnd_message.raise_error;
212: end if;
213: --
214: hr_utility.set_location('Leaving:'||l_proc, 15);

Line 211: fnd_message.raise_error;

207: fetch c1 into l_dummy;
208: if c1%found then
209: close c1;
210: fnd_message.set_name('BEN','BEN_92248_ENRT_TYP_UNIQUE');
211: fnd_message.raise_error;
212: end if;
213: --
214: hr_utility.set_location('Leaving:'||l_proc, 15);
215: End chk_enrt_ctfn_typ_cd_unique;

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

271: p_effective_date => p_effective_date) then
272: --
273: -- raise error as does not exist as lookup
274: --
275: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
276: fnd_message.set_token('FIELD','p_rqd_flag');
277: fnd_message.set_token('TYPE','YES_NO');
278: fnd_message.raise_error;
279: --

Line 276: fnd_message.set_token('FIELD','p_rqd_flag');

272: --
273: -- raise error as does not exist as lookup
274: --
275: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
276: fnd_message.set_token('FIELD','p_rqd_flag');
277: fnd_message.set_token('TYPE','YES_NO');
278: fnd_message.raise_error;
279: --
280: end if;

Line 277: fnd_message.set_token('TYPE','YES_NO');

273: -- raise error as does not exist as lookup
274: --
275: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
276: fnd_message.set_token('FIELD','p_rqd_flag');
277: fnd_message.set_token('TYPE','YES_NO');
278: fnd_message.raise_error;
279: --
280: end if;
281: --

Line 278: fnd_message.raise_error;

274: --
275: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
276: fnd_message.set_token('FIELD','p_rqd_flag');
277: fnd_message.set_token('TYPE','YES_NO');
278: fnd_message.raise_error;
279: --
280: end if;
281: --
282: end if;

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

344: p_effective_date => p_effective_date) then
345: --
346: -- raise error
347: --
348: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
349: fnd_message.set_token('ID',p_ctfn_rqd_when_rl);
350: fnd_message.set_token('TYPE_ID',-143);
351: fnd_message.raise_error;
352: --

Line 349: fnd_message.set_token('ID',p_ctfn_rqd_when_rl);

345: --
346: -- raise error
347: --
348: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
349: fnd_message.set_token('ID',p_ctfn_rqd_when_rl);
350: fnd_message.set_token('TYPE_ID',-143);
351: fnd_message.raise_error;
352: --
353: end if;

Line 350: fnd_message.set_token('TYPE_ID',-143);

346: -- raise error
347: --
348: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
349: fnd_message.set_token('ID',p_ctfn_rqd_when_rl);
350: fnd_message.set_token('TYPE_ID',-143);
351: fnd_message.raise_error;
352: --
353: end if;
354: --

Line 351: fnd_message.raise_error;

347: --
348: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
349: fnd_message.set_token('ID',p_ctfn_rqd_when_rl);
350: fnd_message.set_token('TYPE_ID',-143);
351: fnd_message.raise_error;
352: --
353: end if;
354: --
355: end if;

Line 458: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');

454: --
455: -- A referential integrity check was violated therefore
456: -- we must error
457: --
458: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
459: fnd_message.set_token('TABLE_NAME', l_table_name);
460: fnd_message.raise_error;
461: When Others Then
462: --

Line 459: fnd_message.set_token('TABLE_NAME', l_table_name);

455: -- A referential integrity check was violated therefore
456: -- we must error
457: --
458: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
459: fnd_message.set_token('TABLE_NAME', l_table_name);
460: fnd_message.raise_error;
461: When Others Then
462: --
463: -- An unhandled or unexpected error has occurred which

Line 460: fnd_message.raise_error;

456: -- we must error
457: --
458: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
459: fnd_message.set_token('TABLE_NAME', l_table_name);
460: fnd_message.raise_error;
461: When Others Then
462: --
463: -- An unhandled or unexpected error has occurred which
464: -- we must report

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

462: --
463: -- An unhandled or unexpected error has occurred which
464: -- we must report
465: --
466: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
467: fnd_message.set_token('PROCEDURE', l_proc);
468: fnd_message.set_token('STEP','15');
469: fnd_message.raise_error;
470: End dt_update_validate;

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

463: -- An unhandled or unexpected error has occurred which
464: -- we must report
465: --
466: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
467: fnd_message.set_token('PROCEDURE', l_proc);
468: fnd_message.set_token('STEP','15');
469: fnd_message.raise_error;
470: End dt_update_validate;
471: --

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

464: -- we must report
465: --
466: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
467: fnd_message.set_token('PROCEDURE', l_proc);
468: fnd_message.set_token('STEP','15');
469: fnd_message.raise_error;
470: End dt_update_validate;
471: --
472: -- ----------------------------------------------------------------------------

Line 469: fnd_message.raise_error;

465: --
466: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
467: fnd_message.set_token('PROCEDURE', l_proc);
468: fnd_message.set_token('STEP','15');
469: fnd_message.raise_error;
470: End dt_update_validate;
471: --
472: -- ----------------------------------------------------------------------------
473: -- |--------------------------< dt_delete_validate >--------------------------|

Line 562: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');

558: --
559: -- A referential integrity check was violated therefore
560: -- we must error
561: --
562: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
563: fnd_message.set_token('TABLE_NAME', l_table_name);
564: fnd_message.raise_error;
565: When Others Then
566: --

Line 563: fnd_message.set_token('TABLE_NAME', l_table_name);

559: -- A referential integrity check was violated therefore
560: -- we must error
561: --
562: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
563: fnd_message.set_token('TABLE_NAME', l_table_name);
564: fnd_message.raise_error;
565: When Others Then
566: --
567: -- An unhandled or unexpected error has occurred which

Line 564: fnd_message.raise_error;

560: -- we must error
561: --
562: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
563: fnd_message.set_token('TABLE_NAME', l_table_name);
564: fnd_message.raise_error;
565: When Others Then
566: --
567: -- An unhandled or unexpected error has occurred which
568: -- we must report

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

566: --
567: -- An unhandled or unexpected error has occurred which
568: -- we must report
569: --
570: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
571: fnd_message.set_token('PROCEDURE', l_proc);
572: fnd_message.set_token('STEP','15');
573: fnd_message.raise_error;
574: End dt_delete_validate;

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

567: -- An unhandled or unexpected error has occurred which
568: -- we must report
569: --
570: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
571: fnd_message.set_token('PROCEDURE', l_proc);
572: fnd_message.set_token('STEP','15');
573: fnd_message.raise_error;
574: End dt_delete_validate;
575: --

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

568: -- we must report
569: --
570: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
571: fnd_message.set_token('PROCEDURE', l_proc);
572: fnd_message.set_token('STEP','15');
573: fnd_message.raise_error;
574: End dt_delete_validate;
575: --
576: -- ----------------------------------------------------------------------------

Line 573: fnd_message.raise_error;

569: --
570: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
571: fnd_message.set_token('PROCEDURE', l_proc);
572: fnd_message.set_token('STEP','15');
573: fnd_message.raise_error;
574: End dt_delete_validate;
575: --
576: -- ----------------------------------------------------------------------------
577: -- |---------------------------< insert_validate >----------------------------|

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

761: close csr_leg_code;
762: --
763: -- The primary key is invalid therefore we must error
764: --
765: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
766: fnd_message.raise_error;
767: --
768: end if;
769: --

Line 766: fnd_message.raise_error;

762: --
763: -- The primary key is invalid therefore we must error
764: --
765: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
766: fnd_message.raise_error;
767: --
768: end if;
769: --
770: close csr_leg_code;