DBA Data[Home] [Help]

APPS.BEN_EAR_BUS dependencies on FND_MESSAGE

Line 161: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');

157: close c_dup;
158: --
159: -- raise error as this < > criteria already exists for this profile
160: --
161: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
162: fnd_message.set_token('VAR1','Enrolled in Another Plan in Program criteria',TRUE);
163: fnd_message.set_token('VAR2','Variable Rate Profile',TRUE);
164: fnd_message.raise_error;
165: --

Line 162: fnd_message.set_token('VAR1','Enrolled in Another Plan in Program criteria',TRUE);

158: --
159: -- raise error as this < > criteria already exists for this profile
160: --
161: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
162: fnd_message.set_token('VAR1','Enrolled in Another Plan in Program criteria',TRUE);
163: fnd_message.set_token('VAR2','Variable Rate Profile',TRUE);
164: fnd_message.raise_error;
165: --
166: end if;

Line 163: fnd_message.set_token('VAR2','Variable Rate Profile',TRUE);

159: -- raise error as this < > criteria already exists for this profile
160: --
161: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
162: fnd_message.set_token('VAR1','Enrolled in Another Plan in Program criteria',TRUE);
163: fnd_message.set_token('VAR2','Variable Rate Profile',TRUE);
164: fnd_message.raise_error;
165: --
166: end if;
167: close c_dup;

Line 164: fnd_message.raise_error;

160: --
161: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
162: fnd_message.set_token('VAR1','Enrolled in Another Plan in Program criteria',TRUE);
163: fnd_message.set_token('VAR2','Variable Rate Profile',TRUE);
164: fnd_message.raise_error;
165: --
166: end if;
167: close c_dup;
168: --

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

231: p_effective_date => p_effective_date) then
232: --
233: -- raise error as does not exist as lookup
234: --
235: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
236: fnd_message.set_token('FIELD','p_enrl_det_dt_cd');
237: fnd_message.set_token('TYPE','BEN_ENRL_DET_DT');
238: fnd_message.raise_error;
239: --

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

232: --
233: -- raise error as does not exist as lookup
234: --
235: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
236: fnd_message.set_token('FIELD','p_enrl_det_dt_cd');
237: fnd_message.set_token('TYPE','BEN_ENRL_DET_DT');
238: fnd_message.raise_error;
239: --
240: end if;

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

233: -- raise error as does not exist as lookup
234: --
235: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
236: fnd_message.set_token('FIELD','p_enrl_det_dt_cd');
237: fnd_message.set_token('TYPE','BEN_ENRL_DET_DT');
238: fnd_message.raise_error;
239: --
240: end if;
241: --

Line 238: fnd_message.raise_error;

234: --
235: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
236: fnd_message.set_token('FIELD','p_enrl_det_dt_cd');
237: fnd_message.set_token('TYPE','BEN_ENRL_DET_DT');
238: fnd_message.raise_error;
239: --
240: end if;
241: --
242: end if;

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

302: p_effective_date => p_effective_date) then
303: --
304: -- raise error as does not exist as lookup
305: --
306: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
307: fnd_message.set_token('FIELD','p_excld_flag');
308: fnd_message.set_token('TYPE','YES_NO');
309: fnd_message.raise_error;
310: --

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

303: --
304: -- raise error as does not exist as lookup
305: --
306: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
307: fnd_message.set_token('FIELD','p_excld_flag');
308: fnd_message.set_token('TYPE','YES_NO');
309: fnd_message.raise_error;
310: --
311: end if;

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

304: -- raise error as does not exist as lookup
305: --
306: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
307: fnd_message.set_token('FIELD','p_excld_flag');
308: fnd_message.set_token('TYPE','YES_NO');
309: fnd_message.raise_error;
310: --
311: end if;
312: --

Line 309: fnd_message.raise_error;

305: --
306: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
307: fnd_message.set_token('FIELD','p_excld_flag');
308: fnd_message.set_token('TYPE','YES_NO');
309: fnd_message.raise_error;
310: --
311: end if;
312: --
313: end if;

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

376: open c1;
377: fetch c1 into l_dummy;
378: --
379: if c1%found then
380: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
381: fnd_message.raise_error;
382: end if;
383: close c1;
384: --

Line 381: fnd_message.raise_error;

377: fetch c1 into l_dummy;
378: --
379: if c1%found then
380: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
381: fnd_message.raise_error;
382: end if;
383: close c1;
384: --
385: hr_utility.set_location('Leaving:'||l_proc, 15);

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

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

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

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

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

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

Line 495: fnd_message.raise_error;

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

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

584: --
585: -- A referential integrity check was violated therefore
586: -- we must error
587: --
588: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
589: fnd_message.set_token('TABLE_NAME', l_table_name);
590: fnd_message.raise_error;
591: When Others Then
592: --

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

585: -- A referential integrity check was violated therefore
586: -- we must error
587: --
588: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
589: fnd_message.set_token('TABLE_NAME', l_table_name);
590: fnd_message.raise_error;
591: When Others Then
592: --
593: -- An unhandled or unexpected error has occurred which

Line 590: fnd_message.raise_error;

586: -- we must error
587: --
588: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
589: fnd_message.set_token('TABLE_NAME', l_table_name);
590: fnd_message.raise_error;
591: When Others Then
592: --
593: -- An unhandled or unexpected error has occurred which
594: -- we must report

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

592: --
593: -- An unhandled or unexpected error has occurred which
594: -- we must report
595: --
596: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
597: fnd_message.set_token('PROCEDURE', l_proc);
598: fnd_message.set_token('STEP','15');
599: fnd_message.raise_error;
600: End dt_delete_validate;

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

593: -- An unhandled or unexpected error has occurred which
594: -- we must report
595: --
596: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
597: fnd_message.set_token('PROCEDURE', l_proc);
598: fnd_message.set_token('STEP','15');
599: fnd_message.raise_error;
600: End dt_delete_validate;
601: --

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

594: -- we must report
595: --
596: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
597: fnd_message.set_token('PROCEDURE', l_proc);
598: fnd_message.set_token('STEP','15');
599: fnd_message.raise_error;
600: End dt_delete_validate;
601: --
602: -- ----------------------------------------------------------------------------

Line 599: fnd_message.raise_error;

595: --
596: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
597: fnd_message.set_token('PROCEDURE', l_proc);
598: fnd_message.set_token('STEP','15');
599: fnd_message.raise_error;
600: End dt_delete_validate;
601: --
602: -- ----------------------------------------------------------------------------
603: -- |---------------------------< insert_validate >----------------------------|

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

800: close csr_leg_code;
801: --
802: -- The primary key is invalid therefore we must error
803: --
804: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
805: fnd_message.raise_error;
806: --
807: end if;
808: --

Line 805: fnd_message.raise_error;

801: --
802: -- The primary key is invalid therefore we must error
803: --
804: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
805: fnd_message.raise_error;
806: --
807: end if;
808: --
809: close csr_leg_code;