DBA Data[Home] [Help]

APPS.BEN_DOP_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('TYPE','BEN_ENRL_DET_DT');
140: fnd_message.raise_error;
141: --

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

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

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('TYPE','BEN_ENRL_DET_DT');
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_enrl_det_dt_cd');
139: fnd_message.set_token('TYPE','BEN_ENRL_DET_DT');
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_only_pls_subj_cobra_flag');
210: fnd_message.set_token('TYPE','YES_NO');
211: fnd_message.raise_error;
212: --

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

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_only_pls_subj_cobra_flag');
210: fnd_message.set_token('TYPE','YES_NO');
211: fnd_message.raise_error;
212: --
213: end if;

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

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

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

294: close c_dup;
295: --
296: -- raise error as this Covered by Another Program criteria already exists for this profile
297: --
298: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
299: fnd_message.set_token('VAR1','Covered by Another Program criteria',TRUE);
300: fnd_message.set_token('VAR2','Variable Rate Profile',TRUE);
301: fnd_message.raise_error;
302: --

Line 299: fnd_message.set_token('VAR1','Covered by Another Program criteria',TRUE);

295: --
296: -- raise error as this Covered by Another Program criteria already exists for this profile
297: --
298: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
299: fnd_message.set_token('VAR1','Covered by Another Program criteria',TRUE);
300: fnd_message.set_token('VAR2','Variable Rate Profile',TRUE);
301: fnd_message.raise_error;
302: --
303: end if;

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

296: -- raise error as this Covered by Another Program criteria already exists for this profile
297: --
298: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
299: fnd_message.set_token('VAR1','Covered by Another Program criteria',TRUE);
300: fnd_message.set_token('VAR2','Variable Rate Profile',TRUE);
301: fnd_message.raise_error;
302: --
303: end if;
304: close c_dup;

Line 301: fnd_message.raise_error;

297: --
298: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
299: fnd_message.set_token('VAR1','Covered by Another Program criteria',TRUE);
300: fnd_message.set_token('VAR2','Variable Rate Profile',TRUE);
301: fnd_message.raise_error;
302: --
303: end if;
304: close c_dup;
305: --

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

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

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

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

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

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

Line 373: fnd_message.raise_error;

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

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

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

Line 445: fnd_message.raise_error;

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

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

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

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

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

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

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

Line 562: fnd_message.raise_error;

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

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

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

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

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

Line 657: fnd_message.raise_error;

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

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

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

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

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

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

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

Line 666: fnd_message.raise_error;

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

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

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

Line 881: fnd_message.raise_error;

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