DBA Data[Home] [Help]

APPS.BEN_EPM_BUS dependencies on FND_MESSAGE

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

174: close c3;
175: --
176: -- raise error as this pgm already exists for this profile
177: --
178: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
179: fnd_message.set_token('VAR1','Enrolled in Another Program criteria');
180: fnd_message.set_token('VAR2','Variable Rate Profile');
181: fnd_message.raise_error;
182: --

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

175: --
176: -- raise error as this pgm already exists for this profile
177: --
178: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
179: fnd_message.set_token('VAR1','Enrolled in Another Program criteria');
180: fnd_message.set_token('VAR2','Variable Rate Profile');
181: fnd_message.raise_error;
182: --
183: end if;

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

176: -- raise error as this pgm already exists for this profile
177: --
178: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
179: fnd_message.set_token('VAR1','Enrolled in Another Program criteria');
180: fnd_message.set_token('VAR2','Variable Rate Profile');
181: fnd_message.raise_error;
182: --
183: end if;
184: close c3;

Line 181: fnd_message.raise_error;

177: --
178: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
179: fnd_message.set_token('VAR1','Enrolled in Another Program criteria');
180: fnd_message.set_token('VAR2','Variable Rate Profile');
181: fnd_message.raise_error;
182: --
183: end if;
184: close c3;
185: --

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

245: p_effective_date => p_effective_date) then
246: --
247: -- raise error as does not exist as lookup
248: --
249: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
250: fnd_message.set_token('FIELD','p_enrl_det_dt_cd');
251: fnd_message.set_token('TYPE','BEN_ENRL_DET_DT');
252: fnd_message.raise_error;
253: --

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

246: --
247: -- raise error as does not exist as lookup
248: --
249: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
250: fnd_message.set_token('FIELD','p_enrl_det_dt_cd');
251: fnd_message.set_token('TYPE','BEN_ENRL_DET_DT');
252: fnd_message.raise_error;
253: --
254: end if;

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

247: -- raise error as does not exist as lookup
248: --
249: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
250: fnd_message.set_token('FIELD','p_enrl_det_dt_cd');
251: fnd_message.set_token('TYPE','BEN_ENRL_DET_DT');
252: fnd_message.raise_error;
253: --
254: end if;
255: --

Line 252: fnd_message.raise_error;

248: --
249: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
250: fnd_message.set_token('FIELD','p_enrl_det_dt_cd');
251: fnd_message.set_token('TYPE','BEN_ENRL_DET_DT');
252: fnd_message.raise_error;
253: --
254: end if;
255: --
256: end if;

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

316: p_effective_date => p_effective_date) then
317: --
318: -- raise error as does not exist as lookup
319: --
320: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
321: fnd_message.set_token('FIELD','p_excld_flag');
322: fnd_message.set_token('TYPE','YES_NO');
323: fnd_message.raise_error;
324: --

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

317: --
318: -- raise error as does not exist as lookup
319: --
320: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
321: fnd_message.set_token('FIELD','p_excld_flag');
322: fnd_message.set_token('TYPE','YES_NO');
323: fnd_message.raise_error;
324: --
325: end if;

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

318: -- raise error as does not exist as lookup
319: --
320: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
321: fnd_message.set_token('FIELD','p_excld_flag');
322: fnd_message.set_token('TYPE','YES_NO');
323: fnd_message.raise_error;
324: --
325: end if;
326: --

Line 323: fnd_message.raise_error;

319: --
320: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
321: fnd_message.set_token('FIELD','p_excld_flag');
322: fnd_message.set_token('TYPE','YES_NO');
323: fnd_message.raise_error;
324: --
325: end if;
326: --
327: end if;

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

388: open c1;
389: fetch c1 into l_dummy;
390: --
391: if c1%found then
392: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
393: fnd_message.raise_error;
394: end if;
395: close c1;
396: --

Line 393: fnd_message.raise_error;

389: fetch c1 into l_dummy;
390: --
391: if c1%found then
392: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
393: fnd_message.raise_error;
394: end if;
395: close c1;
396: --
397: hr_utility.set_location('Leaving:'||l_proc, 15);

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

500: --
501: -- An unhandled or unexpected error has occurred which
502: -- we must report
503: --
504: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
505: fnd_message.set_token('PROCEDURE', l_proc);
506: fnd_message.set_token('STEP','15');
507: fnd_message.raise_error;
508: End dt_update_validate;

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

501: -- An unhandled or unexpected error has occurred which
502: -- we must report
503: --
504: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
505: fnd_message.set_token('PROCEDURE', l_proc);
506: fnd_message.set_token('STEP','15');
507: fnd_message.raise_error;
508: End dt_update_validate;
509: --

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

502: -- we must report
503: --
504: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
505: fnd_message.set_token('PROCEDURE', l_proc);
506: fnd_message.set_token('STEP','15');
507: fnd_message.raise_error;
508: End dt_update_validate;
509: --
510: -- ----------------------------------------------------------------------------

Line 507: fnd_message.raise_error;

503: --
504: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
505: fnd_message.set_token('PROCEDURE', l_proc);
506: fnd_message.set_token('STEP','15');
507: fnd_message.raise_error;
508: End dt_update_validate;
509: --
510: -- ----------------------------------------------------------------------------
511: -- |--------------------------< dt_delete_validate >--------------------------|

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

596: --
597: -- A referential integrity check was violated therefore
598: -- we must error
599: --
600: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
601: fnd_message.set_token('TABLE_NAME', l_table_name);
602: fnd_message.raise_error;
603: When Others Then
604: --

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

597: -- A referential integrity check was violated therefore
598: -- we must error
599: --
600: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
601: fnd_message.set_token('TABLE_NAME', l_table_name);
602: fnd_message.raise_error;
603: When Others Then
604: --
605: -- An unhandled or unexpected error has occurred which

Line 602: fnd_message.raise_error;

598: -- we must error
599: --
600: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
601: fnd_message.set_token('TABLE_NAME', l_table_name);
602: fnd_message.raise_error;
603: When Others Then
604: --
605: -- An unhandled or unexpected error has occurred which
606: -- we must report

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

604: --
605: -- An unhandled or unexpected error has occurred which
606: -- we must report
607: --
608: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
609: fnd_message.set_token('PROCEDURE', l_proc);
610: fnd_message.set_token('STEP','15');
611: fnd_message.raise_error;
612: End dt_delete_validate;

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

605: -- An unhandled or unexpected error has occurred which
606: -- we must report
607: --
608: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
609: fnd_message.set_token('PROCEDURE', l_proc);
610: fnd_message.set_token('STEP','15');
611: fnd_message.raise_error;
612: End dt_delete_validate;
613: --

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

606: -- we must report
607: --
608: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
609: fnd_message.set_token('PROCEDURE', l_proc);
610: fnd_message.set_token('STEP','15');
611: fnd_message.raise_error;
612: End dt_delete_validate;
613: --
614: -- ----------------------------------------------------------------------------

Line 611: fnd_message.raise_error;

607: --
608: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
609: fnd_message.set_token('PROCEDURE', l_proc);
610: fnd_message.set_token('STEP','15');
611: fnd_message.raise_error;
612: End dt_delete_validate;
613: --
614: -- ----------------------------------------------------------------------------
615: -- |---------------------------< insert_validate >----------------------------|

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

807: close csr_leg_code;
808: --
809: -- The primary key is invalid therefore we must error
810: --
811: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
812: fnd_message.raise_error;
813: --
814: end if;
815: --

Line 812: fnd_message.raise_error;

808: --
809: -- The primary key is invalid therefore we must error
810: --
811: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
812: fnd_message.raise_error;
813: --
814: end if;
815: --
816: close csr_leg_code;