DBA Data[Home] [Help]

APPS.BEN_DBR_BUS dependencies on FND_MESSAGE

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

125: open c1;
126: fetch c1 into l_dummy;
127: --
128: if c1%found then
129: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
130: fnd_message.raise_error;
131: end if;
132: close c1;
133: --

Line 130: fnd_message.raise_error;

126: fetch c1 into l_dummy;
127: --
128: if c1%found then
129: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
130: fnd_message.raise_error;
131: end if;
132: close c1;
133: --
134: hr_utility.set_location('Leaving:'||l_proc, 15);

Line 196: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');

192: p_effective_date => p_effective_date) then
193: --
194: -- raise error as does not exist as lookup
195: --
196: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
197: fnd_message.raise_error;
198: --
199: end if;
200: --

Line 197: fnd_message.raise_error;

193: --
194: -- raise error as does not exist as lookup
195: --
196: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
197: fnd_message.raise_error;
198: --
199: end if;
200: --
201: end if;

Line 283: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');

279: p_effective_date => p_effective_date) then
280: --
281: -- raise error as does not exist as lookup
282: --
283: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
284: fnd_message.raise_error;
285: --
286: end if;
287: --

Line 284: fnd_message.raise_error;

280: --
281: -- raise error as does not exist as lookup
282: --
283: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
284: fnd_message.raise_error;
285: --
286: end if;
287: --
288: -- begin bug # 2452735

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

293: close c3;
294: --
295: -- raise error as this disabled criteria already exists for this profile
296: --
297: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
298: fnd_message.set_token('VAR1','Disabled criteria');
299: fnd_message.set_token('VAR2','Variable Rate Profile');
300: fnd_message.raise_error;
301: --

Line 298: fnd_message.set_token('VAR1','Disabled criteria');

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

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

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

Line 300: fnd_message.raise_error;

296: --
297: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
298: fnd_message.set_token('VAR1','Disabled criteria');
299: fnd_message.set_token('VAR2','Variable Rate Profile');
300: fnd_message.raise_error;
301: --
302: end if;
303: close c3;
304: -- end bug # 2452735

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

400: --
401: -- An unhandled or unexpected error has occurred which
402: -- we must report
403: --
404: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
405: fnd_message.set_token('PROCEDURE', l_proc);
406: fnd_message.set_token('STEP','15');
407: fnd_message.raise_error;
408: End dt_update_validate;

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

401: -- An unhandled or unexpected error has occurred which
402: -- we must report
403: --
404: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
405: fnd_message.set_token('PROCEDURE', l_proc);
406: fnd_message.set_token('STEP','15');
407: fnd_message.raise_error;
408: End dt_update_validate;
409: --

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

402: -- we must report
403: --
404: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
405: fnd_message.set_token('PROCEDURE', l_proc);
406: fnd_message.set_token('STEP','15');
407: fnd_message.raise_error;
408: End dt_update_validate;
409: --
410: -- ----------------------------------------------------------------------------

Line 407: fnd_message.raise_error;

403: --
404: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
405: fnd_message.set_token('PROCEDURE', l_proc);
406: fnd_message.set_token('STEP','15');
407: fnd_message.raise_error;
408: End dt_update_validate;
409: --
410: -- ----------------------------------------------------------------------------
411: -- |--------------------------< dt_delete_validate >--------------------------|

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

496: --
497: -- A referential integrity check was violated therefore
498: -- we must error
499: --
500: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
501: fnd_message.set_token('TABLE_NAME', l_table_name);
502: fnd_message.raise_error;
503: When Others Then
504: --

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

497: -- A referential integrity check was violated therefore
498: -- we must error
499: --
500: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
501: fnd_message.set_token('TABLE_NAME', l_table_name);
502: fnd_message.raise_error;
503: When Others Then
504: --
505: -- An unhandled or unexpected error has occurred which

Line 502: fnd_message.raise_error;

498: -- we must error
499: --
500: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
501: fnd_message.set_token('TABLE_NAME', l_table_name);
502: fnd_message.raise_error;
503: When Others Then
504: --
505: -- An unhandled or unexpected error has occurred which
506: -- we must report

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

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

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

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

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

506: -- we must report
507: --
508: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
509: fnd_message.set_token('PROCEDURE', l_proc);
510: fnd_message.set_token('STEP','15');
511: fnd_message.raise_error;
512: End dt_delete_validate;
513: --
514: -- ----------------------------------------------------------------------------

Line 511: fnd_message.raise_error;

507: --
508: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
509: fnd_message.set_token('PROCEDURE', l_proc);
510: fnd_message.set_token('STEP','15');
511: fnd_message.raise_error;
512: End dt_delete_validate;
513: --
514: -- ----------------------------------------------------------------------------
515: -- |---------------------------< insert_validate >----------------------------|

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

686: close csr_leg_code;
687: --
688: -- The primary key is invalid therefore we must error
689: --
690: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
691: fnd_message.raise_error;
692: --
693: end if;
694: --

Line 691: fnd_message.raise_error;

687: --
688: -- The primary key is invalid therefore we must error
689: --
690: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
691: fnd_message.raise_error;
692: --
693: end if;
694: --
695: close csr_leg_code;