DBA Data[Home] [Help]

APPS.BEN_EDT_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_only_pls_subj_cobra_flag');
139: fnd_message.set_token('TYPE','YES_NO');
140: fnd_message.raise_error;
141: --

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

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_only_pls_subj_cobra_flag');
139: fnd_message.set_token('TYPE','YES_NO');
140: fnd_message.raise_error;
141: --
142: end if;

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

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_only_pls_subj_cobra_flag');
139: fnd_message.set_token('TYPE','YES_NO');
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_only_pls_subj_cobra_flag');
139: fnd_message.set_token('TYPE','YES_NO');
140: fnd_message.raise_error;
141: --
142: end if;
143: --
144: end if;

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

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

Line 209: fnd_message.set_token('FIELD','p_enrl_det_dt_cd');

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

Line 210: fnd_message.set_token('TYPE','BEN_ENRL_DET_DT');

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

Line 211: fnd_message.raise_error;

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

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

275: p_effective_date => p_effective_date) then
276: --
277: -- raise error as does not exist as lookup
278: --
279: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
280: fnd_message.set_token('FIELD','p_excld_flag');
281: fnd_message.set_token('TYPE','YES_NO');
282: fnd_message.raise_error;
283: --

Line 280: fnd_message.set_token('FIELD','p_excld_flag');

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

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

277: -- raise error as does not exist as lookup
278: --
279: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
280: fnd_message.set_token('FIELD','p_excld_flag');
281: fnd_message.set_token('TYPE','YES_NO');
282: fnd_message.raise_error;
283: --
284: end if;
285: --

Line 282: fnd_message.raise_error;

278: --
279: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
280: fnd_message.set_token('FIELD','p_excld_flag');
281: fnd_message.set_token('TYPE','YES_NO');
282: fnd_message.raise_error;
283: --
284: end if;
285: --
286: end if;

Line 343: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');

339: open c1;
340: fetch c1 into l_dummy;
341: if c1%found then
342: close c1;
343: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
344: fnd_message.raise_error;
345: end if;
346: close c1;
347: --

Line 344: fnd_message.raise_error;

340: fetch c1 into l_dummy;
341: if c1%found then
342: close c1;
343: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
344: fnd_message.raise_error;
345: end if;
346: close c1;
347: --
348: hr_utility.set_location('Leaving:'||l_proc, 15);

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

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

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

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

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

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

Line 457: fnd_message.raise_error;

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

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

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

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

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

Line 552: fnd_message.raise_error;

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

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

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

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

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

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

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

Line 561: fnd_message.raise_error;

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

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

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

Line 746: fnd_message.raise_error;

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