DBA Data[Home] [Help]

APPS.BEN_DCO_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 302: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');

298: --
299: -- raise error as this Covered by Another Plan Type in Program
300: -- criteria already exists for this profile
301: --
302: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
303: fnd_message.set_token('VAR1','Covered by Another Plan Type in Program criteria',TRUE);
304: fnd_message.set_token('VAR2','Variable Rate Profile',TRUE);
305: fnd_message.raise_error;
306: --

Line 303: fnd_message.set_token('VAR1','Covered by Another Plan Type in Program criteria',TRUE);

299: -- raise error as this Covered by Another Plan Type in Program
300: -- criteria already exists for this profile
301: --
302: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
303: fnd_message.set_token('VAR1','Covered by Another Plan Type in Program criteria',TRUE);
304: fnd_message.set_token('VAR2','Variable Rate Profile',TRUE);
305: fnd_message.raise_error;
306: --
307: end if;

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

300: -- criteria already exists for this profile
301: --
302: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
303: fnd_message.set_token('VAR1','Covered by Another Plan Type in Program criteria',TRUE);
304: fnd_message.set_token('VAR2','Variable Rate Profile',TRUE);
305: fnd_message.raise_error;
306: --
307: end if;
308: close c_dup;

Line 305: fnd_message.raise_error;

301: --
302: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
303: fnd_message.set_token('VAR1','Covered by Another Plan Type in Program criteria',TRUE);
304: fnd_message.set_token('VAR2','Variable Rate Profile',TRUE);
305: fnd_message.raise_error;
306: --
307: end if;
308: close c_dup;
309: --

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

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

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

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

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

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

Line 376: fnd_message.raise_error;

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

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

442: open c1;
443: fetch c1 into l_dummy;
444: --
445: if c1%found then
446: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
447: fnd_message.raise_error;
448: end if;
449: close c1;
450: --

Line 447: fnd_message.raise_error;

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

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_update_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_update_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_update_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_update_validate;
563: --
564: -- ----------------------------------------------------------------------------
565: -- |--------------------------< dt_delete_validate >--------------------------|

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

650: --
651: -- A referential integrity check was violated therefore
652: -- we must error
653: --
654: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
655: fnd_message.set_token('TABLE_NAME', l_table_name);
656: fnd_message.raise_error;
657: When Others Then
658: --

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

651: -- A referential integrity check was violated therefore
652: -- we must error
653: --
654: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
655: fnd_message.set_token('TABLE_NAME', l_table_name);
656: fnd_message.raise_error;
657: When Others Then
658: --
659: -- An unhandled or unexpected error has occurred which

Line 656: fnd_message.raise_error;

652: -- we must error
653: --
654: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
655: fnd_message.set_token('TABLE_NAME', l_table_name);
656: fnd_message.raise_error;
657: When Others Then
658: --
659: -- An unhandled or unexpected error has occurred which
660: -- we must report

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

658: --
659: -- An unhandled or unexpected error has occurred which
660: -- we must report
661: --
662: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
663: fnd_message.set_token('PROCEDURE', l_proc);
664: fnd_message.set_token('STEP','15');
665: fnd_message.raise_error;
666: End dt_delete_validate;

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

659: -- An unhandled or unexpected error has occurred which
660: -- we must report
661: --
662: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
663: fnd_message.set_token('PROCEDURE', l_proc);
664: fnd_message.set_token('STEP','15');
665: fnd_message.raise_error;
666: End dt_delete_validate;
667: --

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

660: -- we must report
661: --
662: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
663: fnd_message.set_token('PROCEDURE', l_proc);
664: fnd_message.set_token('STEP','15');
665: fnd_message.raise_error;
666: End dt_delete_validate;
667: --
668: -- ----------------------------------------------------------------------------

Line 665: fnd_message.raise_error;

661: --
662: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
663: fnd_message.set_token('PROCEDURE', l_proc);
664: fnd_message.set_token('STEP','15');
665: fnd_message.raise_error;
666: End dt_delete_validate;
667: --
668: -- ----------------------------------------------------------------------------
669: -- |---------------------------< insert_validate >----------------------------|

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

877: close csr_leg_code;
878: --
879: -- The primary key is invalid therefore we must error
880: --
881: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
882: fnd_message.raise_error;
883: --
884: end if;
885: --

Line 882: fnd_message.raise_error;

878: --
879: -- The primary key is invalid therefore we must error
880: --
881: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
882: fnd_message.raise_error;
883: --
884: end if;
885: --
886: close csr_leg_code;