DBA Data[Home] [Help]

APPS.BEN_DCL_BUS dependencies on FND_MESSAGE

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

175: close c3;
176: --
177: -- raise error as this pl already exists for this profile
178: --
179: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
180: fnd_message.set_token('VAR1','Covered by Another Plan criteria');
181: fnd_message.set_token('VAR2','Variable Rate Profile');
182: fnd_message.raise_error;
183: --

Line 180: fnd_message.set_token('VAR1','Covered by Another Plan criteria');

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

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

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

Line 182: fnd_message.raise_error;

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

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

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

Line 251: fnd_message.set_token('FIELD','p_cvg_det_dt_cd');

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

Line 252: fnd_message.set_token('TYPE','BEN_CVG_DET_DT');

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

Line 253: fnd_message.raise_error;

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

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

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

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

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

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

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

Line 324: fnd_message.raise_error;

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

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

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

Line 395: fnd_message.raise_error;

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

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

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

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

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

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

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

Line 508: fnd_message.raise_error;

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

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

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

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

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

Line 603: fnd_message.raise_error;

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

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

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

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

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

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

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

Line 612: fnd_message.raise_error;

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

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

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

Line 813: fnd_message.raise_error;

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