DBA Data[Home] [Help]

APPS.BEN_LNC_BUS dependencies on FND_MESSAGE

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

135: p_effective_date => p_effective_date) then
136: --
137: -- raise error
138: --
139: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
140: fnd_message.set_token('ID',p_ctfn_rqd_when_rl);
141: fnd_message.set_token('TYPE_ID',-143);
142: fnd_message.raise_error;
143: --

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

136: --
137: -- raise error
138: --
139: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
140: fnd_message.set_token('ID',p_ctfn_rqd_when_rl);
141: fnd_message.set_token('TYPE_ID',-143);
142: fnd_message.raise_error;
143: --
144: end if;

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

137: -- raise error
138: --
139: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
140: fnd_message.set_token('ID',p_ctfn_rqd_when_rl);
141: fnd_message.set_token('TYPE_ID',-143);
142: fnd_message.raise_error;
143: --
144: end if;
145: --

Line 142: fnd_message.raise_error;

138: --
139: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
140: fnd_message.set_token('ID',p_ctfn_rqd_when_rl);
141: fnd_message.set_token('TYPE_ID',-143);
142: fnd_message.raise_error;
143: --
144: end if;
145: --
146: end if;

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

205: p_effective_date => p_effective_date) then
206: --
207: -- raise error as does not exist as lookup
208: --
209: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
210: fnd_message.set_token('FIELD', 'p_enrt_ctfn_typ_cd');
211: fnd_message.set_token('TYPE','BEN_ENRT_CTFN_TYP');
212: fnd_message.raise_error;
213: --

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

206: --
207: -- raise error as does not exist as lookup
208: --
209: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
210: fnd_message.set_token('FIELD', 'p_enrt_ctfn_typ_cd');
211: fnd_message.set_token('TYPE','BEN_ENRT_CTFN_TYP');
212: fnd_message.raise_error;
213: --
214: end if;

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

207: -- raise error as does not exist as lookup
208: --
209: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
210: fnd_message.set_token('FIELD', 'p_enrt_ctfn_typ_cd');
211: fnd_message.set_token('TYPE','BEN_ENRT_CTFN_TYP');
212: fnd_message.raise_error;
213: --
214: end if;
215: --

Line 212: fnd_message.raise_error;

208: --
209: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
210: fnd_message.set_token('FIELD', 'p_enrt_ctfn_typ_cd');
211: fnd_message.set_token('TYPE','BEN_ENRT_CTFN_TYP');
212: fnd_message.raise_error;
213: --
214: end if;
215: --
216: end if;

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

275: open c1;
276: fetch c1 into l_dummy;
277: if c1%found then
278: close c1;
279: fnd_message.set_name('BEN','BEN_92248_ENRT_TYP_UNIQUE');
280: fnd_message.raise_error;
281: end if;
282: --
283: hr_utility.set_location('Leaving:'||l_proc, 15);

Line 280: fnd_message.raise_error;

276: fetch c1 into l_dummy;
277: if c1%found then
278: close c1;
279: fnd_message.set_name('BEN','BEN_92248_ENRT_TYP_UNIQUE');
280: fnd_message.raise_error;
281: end if;
282: --
283: hr_utility.set_location('Leaving:'||l_proc, 15);
284: End chk_enrt_ctfn_typ_cd_unique;

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

340: p_effective_date => p_effective_date) then
341: --
342: -- raise error as does not exist as lookup
343: --
344: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
345: fnd_message.set_token('FIELD','p_rqd_flag');
346: fnd_message.set_token('TYPE','YES_NO');
347: fnd_message.raise_error;
348: --

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

341: --
342: -- raise error as does not exist as lookup
343: --
344: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
345: fnd_message.set_token('FIELD','p_rqd_flag');
346: fnd_message.set_token('TYPE','YES_NO');
347: fnd_message.raise_error;
348: --
349: end if;

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

342: -- raise error as does not exist as lookup
343: --
344: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
345: fnd_message.set_token('FIELD','p_rqd_flag');
346: fnd_message.set_token('TYPE','YES_NO');
347: fnd_message.raise_error;
348: --
349: end if;
350: --

Line 347: fnd_message.raise_error;

343: --
344: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
345: fnd_message.set_token('FIELD','p_rqd_flag');
346: fnd_message.set_token('TYPE','YES_NO');
347: fnd_message.raise_error;
348: --
349: end if;
350: --
351: end if;

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

439: --
440: -- A referential integrity check was violated therefore
441: -- we must error
442: --
443: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
444: fnd_message.set_token('TABLE_NAME', l_table_name);
445: fnd_message.raise_error;
446: When Others Then
447: --

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

440: -- A referential integrity check was violated therefore
441: -- we must error
442: --
443: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
444: fnd_message.set_token('TABLE_NAME', l_table_name);
445: fnd_message.raise_error;
446: When Others Then
447: --
448: -- An unhandled or unexpected error has occurred which

Line 445: fnd_message.raise_error;

441: -- we must error
442: --
443: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
444: fnd_message.set_token('TABLE_NAME', l_table_name);
445: fnd_message.raise_error;
446: When Others Then
447: --
448: -- An unhandled or unexpected error has occurred which
449: -- we must report

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

447: --
448: -- An unhandled or unexpected error has occurred which
449: -- we must report
450: --
451: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
452: fnd_message.set_token('PROCEDURE', l_proc);
453: fnd_message.set_token('STEP','15');
454: fnd_message.raise_error;
455: End dt_update_validate;

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

448: -- An unhandled or unexpected error has occurred which
449: -- we must report
450: --
451: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
452: fnd_message.set_token('PROCEDURE', l_proc);
453: fnd_message.set_token('STEP','15');
454: fnd_message.raise_error;
455: End dt_update_validate;
456: --

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

449: -- we must report
450: --
451: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
452: fnd_message.set_token('PROCEDURE', l_proc);
453: fnd_message.set_token('STEP','15');
454: fnd_message.raise_error;
455: End dt_update_validate;
456: --
457: -- ----------------------------------------------------------------------------

Line 454: fnd_message.raise_error;

450: --
451: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
452: fnd_message.set_token('PROCEDURE', l_proc);
453: fnd_message.set_token('STEP','15');
454: fnd_message.raise_error;
455: End dt_update_validate;
456: --
457: -- ----------------------------------------------------------------------------
458: -- |--------------------------< dt_delete_validate >--------------------------|

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

543: --
544: -- A referential integrity check was violated therefore
545: -- we must error
546: --
547: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
548: fnd_message.set_token('TABLE_NAME', l_table_name);
549: fnd_message.raise_error;
550: When Others Then
551: --

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

544: -- A referential integrity check was violated therefore
545: -- we must error
546: --
547: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
548: fnd_message.set_token('TABLE_NAME', l_table_name);
549: fnd_message.raise_error;
550: When Others Then
551: --
552: -- An unhandled or unexpected error has occurred which

Line 549: fnd_message.raise_error;

545: -- we must error
546: --
547: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
548: fnd_message.set_token('TABLE_NAME', l_table_name);
549: fnd_message.raise_error;
550: When Others Then
551: --
552: -- An unhandled or unexpected error has occurred which
553: -- we must report

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

551: --
552: -- An unhandled or unexpected error has occurred which
553: -- we must report
554: --
555: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
556: fnd_message.set_token('PROCEDURE', l_proc);
557: fnd_message.set_token('STEP','15');
558: fnd_message.raise_error;
559: End dt_delete_validate;

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

552: -- An unhandled or unexpected error has occurred which
553: -- we must report
554: --
555: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
556: fnd_message.set_token('PROCEDURE', l_proc);
557: fnd_message.set_token('STEP','15');
558: fnd_message.raise_error;
559: End dt_delete_validate;
560: --

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

553: -- we must report
554: --
555: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
556: fnd_message.set_token('PROCEDURE', l_proc);
557: fnd_message.set_token('STEP','15');
558: fnd_message.raise_error;
559: End dt_delete_validate;
560: --
561: -- ----------------------------------------------------------------------------

Line 558: fnd_message.raise_error;

554: --
555: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
556: fnd_message.set_token('PROCEDURE', l_proc);
557: fnd_message.set_token('STEP','15');
558: fnd_message.raise_error;
559: End dt_delete_validate;
560: --
561: -- ----------------------------------------------------------------------------
562: -- |---------------------------< insert_validate >----------------------------|

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

743: close csr_leg_code;
744: --
745: -- The primary key is invalid therefore we must error
746: --
747: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
748: fnd_message.raise_error;
749: --
750: end if;
751: --

Line 748: fnd_message.raise_error;

744: --
745: -- The primary key is invalid therefore we must error
746: --
747: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
748: fnd_message.raise_error;
749: --
750: end if;
751: --
752: close csr_leg_code;