DBA Data[Home] [Help]

APPS.BEN_EDI_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_enrl_det_dt_cd');
139: fnd_message.set_token('VALUE',p_enrl_det_dt_cd);
140: fnd_message.set_token('TYPE','BEN_ENRL_DET_DT');
141: fnd_message.raise_error;

Line 138: fnd_message.set_token('FIELD','p_enrl_det_dt_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_enrl_det_dt_cd');
139: fnd_message.set_token('VALUE',p_enrl_det_dt_cd);
140: fnd_message.set_token('TYPE','BEN_ENRL_DET_DT');
141: fnd_message.raise_error;
142: --

Line 139: fnd_message.set_token('VALUE',p_enrl_det_dt_cd);

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_enrl_det_dt_cd');
139: fnd_message.set_token('VALUE',p_enrl_det_dt_cd);
140: fnd_message.set_token('TYPE','BEN_ENRL_DET_DT');
141: fnd_message.raise_error;
142: --
143: end if;

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

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

Line 141: fnd_message.raise_error;

137: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
138: fnd_message.set_token('FIELD','p_enrl_det_dt_cd');
139: fnd_message.set_token('VALUE',p_enrl_det_dt_cd);
140: fnd_message.set_token('TYPE','BEN_ENRL_DET_DT');
141: fnd_message.raise_error;
142: --
143: end if;
144: --
145: 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_excld_flag');
211: fnd_message.set_token('VALUE',p_excld_flag);
212: fnd_message.set_token('TYPE','YES_NO');
213: fnd_message.raise_error;

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

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_excld_flag');
211: fnd_message.set_token('VALUE',p_excld_flag);
212: fnd_message.set_token('TYPE','YES_NO');
213: fnd_message.raise_error;
214: --

Line 211: fnd_message.set_token('VALUE',p_excld_flag);

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_excld_flag');
211: fnd_message.set_token('VALUE',p_excld_flag);
212: fnd_message.set_token('TYPE','YES_NO');
213: fnd_message.raise_error;
214: --
215: end if;

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

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

Line 213: fnd_message.raise_error;

209: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
210: fnd_message.set_token('FIELD','p_excld_flag');
211: fnd_message.set_token('VALUE',p_excld_flag);
212: fnd_message.set_token('TYPE','YES_NO');
213: fnd_message.raise_error;
214: --
215: end if;
216: --
217: end if;

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

270: open c1;
271: fetch c1 into l_dummy;
272: if c1%found then
273: close c1;
274: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
275: fnd_message.raise_error;
276: end if;
277: close c1;
278: --

Line 275: fnd_message.raise_error;

271: fetch c1 into l_dummy;
272: if c1%found then
273: close c1;
274: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
275: fnd_message.raise_error;
276: end if;
277: close c1;
278: --
279: hr_utility.set_location('Leaving:'||l_proc, 15);

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

374: --
375: -- A referential integrity check was violated therefore
376: -- we must error
377: --
378: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
379: fnd_message.set_token('TABLE_NAME', l_table_name);
380: fnd_message.raise_error;
381: When Others Then
382: --

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

375: -- A referential integrity check was violated therefore
376: -- we must error
377: --
378: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
379: fnd_message.set_token('TABLE_NAME', l_table_name);
380: fnd_message.raise_error;
381: When Others Then
382: --
383: -- An unhandled or unexpected error has occurred which

Line 380: fnd_message.raise_error;

376: -- we must error
377: --
378: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
379: fnd_message.set_token('TABLE_NAME', l_table_name);
380: fnd_message.raise_error;
381: When Others Then
382: --
383: -- An unhandled or unexpected error has occurred which
384: -- we must report

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

382: --
383: -- An unhandled or unexpected error has occurred which
384: -- we must report
385: --
386: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
387: fnd_message.set_token('PROCEDURE', l_proc);
388: fnd_message.set_token('STEP','15');
389: fnd_message.raise_error;
390: End dt_update_validate;

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

383: -- An unhandled or unexpected error has occurred which
384: -- we must report
385: --
386: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
387: fnd_message.set_token('PROCEDURE', l_proc);
388: fnd_message.set_token('STEP','15');
389: fnd_message.raise_error;
390: End dt_update_validate;
391: --

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

384: -- we must report
385: --
386: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
387: fnd_message.set_token('PROCEDURE', l_proc);
388: fnd_message.set_token('STEP','15');
389: fnd_message.raise_error;
390: End dt_update_validate;
391: --
392: -- ----------------------------------------------------------------------------

Line 389: fnd_message.raise_error;

385: --
386: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
387: fnd_message.set_token('PROCEDURE', l_proc);
388: fnd_message.set_token('STEP','15');
389: fnd_message.raise_error;
390: End dt_update_validate;
391: --
392: -- ----------------------------------------------------------------------------
393: -- |--------------------------< dt_delete_validate >--------------------------|

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

478: --
479: -- A referential integrity check was violated therefore
480: -- we must error
481: --
482: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
483: fnd_message.set_token('TABLE_NAME', l_table_name);
484: fnd_message.raise_error;
485: When Others Then
486: --

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

479: -- A referential integrity check was violated therefore
480: -- we must error
481: --
482: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
483: fnd_message.set_token('TABLE_NAME', l_table_name);
484: fnd_message.raise_error;
485: When Others Then
486: --
487: -- An unhandled or unexpected error has occurred which

Line 484: fnd_message.raise_error;

480: -- we must error
481: --
482: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
483: fnd_message.set_token('TABLE_NAME', l_table_name);
484: fnd_message.raise_error;
485: When Others Then
486: --
487: -- An unhandled or unexpected error has occurred which
488: -- we must report

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

486: --
487: -- An unhandled or unexpected error has occurred which
488: -- we must report
489: --
490: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
491: fnd_message.set_token('PROCEDURE', l_proc);
492: fnd_message.set_token('STEP','15');
493: fnd_message.raise_error;
494: End dt_delete_validate;

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

487: -- An unhandled or unexpected error has occurred which
488: -- we must report
489: --
490: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
491: fnd_message.set_token('PROCEDURE', l_proc);
492: fnd_message.set_token('STEP','15');
493: fnd_message.raise_error;
494: End dt_delete_validate;
495: --

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

488: -- we must report
489: --
490: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
491: fnd_message.set_token('PROCEDURE', l_proc);
492: fnd_message.set_token('STEP','15');
493: fnd_message.raise_error;
494: End dt_delete_validate;
495: --
496: -- ----------------------------------------------------------------------------

Line 493: fnd_message.raise_error;

489: --
490: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
491: fnd_message.set_token('PROCEDURE', l_proc);
492: fnd_message.set_token('STEP','15');
493: fnd_message.raise_error;
494: End dt_delete_validate;
495: --
496: -- ----------------------------------------------------------------------------
497: -- |---------------------------< insert_validate >----------------------------|

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

659: close csr_leg_code;
660: --
661: -- The primary key is invalid therefore we must error
662: --
663: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
664: fnd_message.raise_error;
665: --
666: end if;
667: --

Line 664: fnd_message.raise_error;

660: --
661: -- The primary key is invalid therefore we must error
662: --
663: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
664: fnd_message.raise_error;
665: --
666: end if;
667: --
668: close csr_leg_code;