DBA Data[Home] [Help]

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

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

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

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

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

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

Line 304: fnd_message.raise_error;

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

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

370: open c1;
371: fetch c1 into l_dummy;
372: --
373: if c1%found then
374: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
375: fnd_message.raise_error;
376: end if;
377: close c1;
378: --

Line 375: fnd_message.raise_error;

371: fetch c1 into l_dummy;
372: --
373: if c1%found then
374: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
375: fnd_message.raise_error;
376: end if;
377: close c1;
378: --
379: hr_utility.set_location('Leaving:'||l_proc, 15);

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

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

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

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

Line 482: fnd_message.raise_error;

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

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

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

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

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

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

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

Line 491: fnd_message.raise_error;

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

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

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

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

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

Line 586: fnd_message.raise_error;

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

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

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

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

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

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

590: -- we must report
591: --
592: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
593: fnd_message.set_token('PROCEDURE', l_proc);
594: fnd_message.set_token('STEP','15');
595: fnd_message.raise_error;
596: End dt_delete_validate;
597: --
598: -- ----------------------------------------------------------------------------

Line 595: fnd_message.raise_error;

591: --
592: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
593: fnd_message.set_token('PROCEDURE', l_proc);
594: fnd_message.set_token('STEP','15');
595: fnd_message.raise_error;
596: End dt_delete_validate;
597: --
598: -- ----------------------------------------------------------------------------
599: -- |---------------------------< insert_validate >----------------------------|

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

790: close csr_leg_code;
791: --
792: -- The primary key is invalid therefore we must error
793: --
794: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
795: fnd_message.raise_error;
796: --
797: end if;
798: --

Line 795: fnd_message.raise_error;

791: --
792: -- The primary key is invalid therefore we must error
793: --
794: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
795: fnd_message.raise_error;
796: --
797: end if;
798: --
799: close csr_leg_code;