DBA Data[Home] [Help]

APPS.BEN_ENT_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 Type 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 Type 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 Type 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 Type 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 Type 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 233: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');

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

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

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

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

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

Line 236: fnd_message.raise_error;

232: --
233: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
234: fnd_message.set_token('FIELD','p_only_pls_subj_cobra_flag');
235: fnd_message.set_token('TYPE','YES_NO');
236: fnd_message.raise_error;
237: --
238: end if;
239: --
240: end if;

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

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

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

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

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

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

Line 307: fnd_message.raise_error;

303: --
304: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
305: fnd_message.set_token('FIELD','p_enrl_det_dt_cd');
306: fnd_message.set_token('TYPE','BEN_ENRL_DET_DT');
307: fnd_message.raise_error;
308: --
309: end if;
310: --
311: end if;

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

371: p_effective_date => p_effective_date) then
372: --
373: -- raise error as does not exist as lookup
374: --
375: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
376: fnd_message.set_token('FIELD','p_excld_flag');
377: fnd_message.set_token('TYPE','YES_NO');
378: fnd_message.raise_error;
379: --

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

372: --
373: -- raise error as does not exist as lookup
374: --
375: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
376: fnd_message.set_token('FIELD','p_excld_flag');
377: fnd_message.set_token('TYPE','YES_NO');
378: fnd_message.raise_error;
379: --
380: end if;

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

373: -- raise error as does not exist as lookup
374: --
375: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
376: fnd_message.set_token('FIELD','p_excld_flag');
377: fnd_message.set_token('TYPE','YES_NO');
378: fnd_message.raise_error;
379: --
380: end if;
381: --

Line 378: fnd_message.raise_error;

374: --
375: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
376: fnd_message.set_token('FIELD','p_excld_flag');
377: fnd_message.set_token('TYPE','YES_NO');
378: fnd_message.raise_error;
379: --
380: end if;
381: --
382: end if;

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

446: open c1;
447: fetch c1 into l_dummy;
448: --
449: if c1%found then
450: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
451: fnd_message.raise_error;
452: end if;
453: close c1;
454: --

Line 451: fnd_message.raise_error;

447: fetch c1 into l_dummy;
448: --
449: if c1%found then
450: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
451: fnd_message.raise_error;
452: end if;
453: close c1;
454: --
455: hr_utility.set_location('Leaving:'||l_proc, 15);

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

561: --
562: -- An unhandled or unexpected error has occurred which
563: -- we must report
564: --
565: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
566: fnd_message.set_token('PROCEDURE', l_proc);
567: fnd_message.set_token('STEP','15');
568: fnd_message.raise_error;
569: End dt_update_validate;

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

562: -- An unhandled or unexpected error has occurred which
563: -- we must report
564: --
565: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
566: fnd_message.set_token('PROCEDURE', l_proc);
567: fnd_message.set_token('STEP','15');
568: fnd_message.raise_error;
569: End dt_update_validate;
570: --

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

563: -- we must report
564: --
565: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
566: fnd_message.set_token('PROCEDURE', l_proc);
567: fnd_message.set_token('STEP','15');
568: fnd_message.raise_error;
569: End dt_update_validate;
570: --
571: -- ----------------------------------------------------------------------------

Line 568: fnd_message.raise_error;

564: --
565: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
566: fnd_message.set_token('PROCEDURE', l_proc);
567: fnd_message.set_token('STEP','15');
568: fnd_message.raise_error;
569: End dt_update_validate;
570: --
571: -- ----------------------------------------------------------------------------
572: -- |--------------------------< dt_delete_validate >--------------------------|

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

657: --
658: -- A referential integrity check was violated therefore
659: -- we must error
660: --
661: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
662: fnd_message.set_token('TABLE_NAME', l_table_name);
663: fnd_message.raise_error;
664: When Others Then
665: --

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

658: -- A referential integrity check was violated therefore
659: -- we must error
660: --
661: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
662: fnd_message.set_token('TABLE_NAME', l_table_name);
663: fnd_message.raise_error;
664: When Others Then
665: --
666: -- An unhandled or unexpected error has occurred which

Line 663: fnd_message.raise_error;

659: -- we must error
660: --
661: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
662: fnd_message.set_token('TABLE_NAME', l_table_name);
663: fnd_message.raise_error;
664: When Others Then
665: --
666: -- An unhandled or unexpected error has occurred which
667: -- we must report

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

665: --
666: -- An unhandled or unexpected error has occurred which
667: -- we must report
668: --
669: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
670: fnd_message.set_token('PROCEDURE', l_proc);
671: fnd_message.set_token('STEP','15');
672: fnd_message.raise_error;
673: End dt_delete_validate;

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

666: -- An unhandled or unexpected error has occurred which
667: -- we must report
668: --
669: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
670: fnd_message.set_token('PROCEDURE', l_proc);
671: fnd_message.set_token('STEP','15');
672: fnd_message.raise_error;
673: End dt_delete_validate;
674: --

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

667: -- we must report
668: --
669: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
670: fnd_message.set_token('PROCEDURE', l_proc);
671: fnd_message.set_token('STEP','15');
672: fnd_message.raise_error;
673: End dt_delete_validate;
674: --
675: -- ----------------------------------------------------------------------------

Line 672: fnd_message.raise_error;

668: --
669: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
670: fnd_message.set_token('PROCEDURE', l_proc);
671: fnd_message.set_token('STEP','15');
672: fnd_message.raise_error;
673: End dt_delete_validate;
674: --
675: -- ----------------------------------------------------------------------------
676: -- |---------------------------< insert_validate >----------------------------|

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

886: close csr_leg_code;
887: --
888: -- The primary key is invalid therefore we must error
889: --
890: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
891: fnd_message.raise_error;
892: --
893: end if;
894: --

Line 891: fnd_message.raise_error;

887: --
888: -- The primary key is invalid therefore we must error
889: --
890: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
891: fnd_message.raise_error;
892: --
893: end if;
894: --
895: close csr_leg_code;