DBA Data[Home] [Help]

APPS.BEN_PBC_BUS dependencies on FND_MESSAGE

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

133: p_effective_date => p_effective_date) then
134: --
135: -- raise error as does not exist as lookup
136: --
137: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
138: fnd_message.raise_error;
139: --
140: end if;
141: --

Line 138: fnd_message.raise_error;

134: --
135: -- raise error as does not exist as lookup
136: --
137: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
138: fnd_message.raise_error;
139: --
140: end if;
141: --
142: end if;

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

219: p_effective_date => p_effective_date) then
220: --
221: -- raise error as does not exist as lookup
222: --
223: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
224: fnd_message.raise_error;
225: --
226: end if;
227: --

Line 224: fnd_message.raise_error;

220: --
221: -- raise error as does not exist as lookup
222: --
223: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
224: fnd_message.raise_error;
225: --
226: end if;
227: --
228: open c3;

Line 235: fnd_message.set_name('BEN', 'BEN_91655_DUP_BNF_CTFN');

231: close c3;
232: --
233: -- raise error as this ctfn row already exists for this beneficiary
234: --
235: fnd_message.set_name('BEN', 'BEN_91655_DUP_BNF_CTFN');
236: fnd_message.raise_error;
237: --
238: end if;
239: close c3;

Line 236: fnd_message.raise_error;

232: --
233: -- raise error as this ctfn row already exists for this beneficiary
234: --
235: fnd_message.set_name('BEN', 'BEN_91655_DUP_BNF_CTFN');
236: fnd_message.raise_error;
237: --
238: end if;
239: close c3;
240: --

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

341: --
342: -- A referential integrity check was violated therefore
343: -- we must error
344: --
345: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
346: fnd_message.set_token('TABLE_NAME', l_table_name);
347: fnd_message.raise_error;
348: When Others Then
349: --

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

342: -- A referential integrity check was violated therefore
343: -- we must error
344: --
345: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
346: fnd_message.set_token('TABLE_NAME', l_table_name);
347: fnd_message.raise_error;
348: When Others Then
349: --
350: -- An unhandled or unexpected error has occurred which

Line 347: fnd_message.raise_error;

343: -- we must error
344: --
345: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
346: fnd_message.set_token('TABLE_NAME', l_table_name);
347: fnd_message.raise_error;
348: When Others Then
349: --
350: -- An unhandled or unexpected error has occurred which
351: -- we must report

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

349: --
350: -- An unhandled or unexpected error has occurred which
351: -- we must report
352: --
353: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
354: fnd_message.set_token('PROCEDURE', l_proc);
355: fnd_message.set_token('STEP','15');
356: fnd_message.raise_error;
357: End dt_update_validate;

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

350: -- An unhandled or unexpected error has occurred which
351: -- we must report
352: --
353: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
354: fnd_message.set_token('PROCEDURE', l_proc);
355: fnd_message.set_token('STEP','15');
356: fnd_message.raise_error;
357: End dt_update_validate;
358: --

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

351: -- we must report
352: --
353: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
354: fnd_message.set_token('PROCEDURE', l_proc);
355: fnd_message.set_token('STEP','15');
356: fnd_message.raise_error;
357: End dt_update_validate;
358: --
359: -- ----------------------------------------------------------------------------

Line 356: fnd_message.raise_error;

352: --
353: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
354: fnd_message.set_token('PROCEDURE', l_proc);
355: fnd_message.set_token('STEP','15');
356: fnd_message.raise_error;
357: End dt_update_validate;
358: --
359: -- ----------------------------------------------------------------------------
360: -- |--------------------------< dt_delete_validate >--------------------------|

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

445: --
446: -- A referential integrity check was violated therefore
447: -- we must error
448: --
449: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
450: fnd_message.set_token('TABLE_NAME', l_table_name);
451: fnd_message.raise_error;
452: When Others Then
453: --

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

446: -- A referential integrity check was violated therefore
447: -- we must error
448: --
449: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
450: fnd_message.set_token('TABLE_NAME', l_table_name);
451: fnd_message.raise_error;
452: When Others Then
453: --
454: -- An unhandled or unexpected error has occurred which

Line 451: fnd_message.raise_error;

447: -- we must error
448: --
449: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
450: fnd_message.set_token('TABLE_NAME', l_table_name);
451: fnd_message.raise_error;
452: When Others Then
453: --
454: -- An unhandled or unexpected error has occurred which
455: -- we must report

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

453: --
454: -- An unhandled or unexpected error has occurred which
455: -- we must report
456: --
457: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
458: fnd_message.set_token('PROCEDURE', l_proc);
459: fnd_message.set_token('STEP','15');
460: fnd_message.raise_error;
461: End dt_delete_validate;

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

454: -- An unhandled or unexpected error has occurred which
455: -- we must report
456: --
457: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
458: fnd_message.set_token('PROCEDURE', l_proc);
459: fnd_message.set_token('STEP','15');
460: fnd_message.raise_error;
461: End dt_delete_validate;
462: --

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

455: -- we must report
456: --
457: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
458: fnd_message.set_token('PROCEDURE', l_proc);
459: fnd_message.set_token('STEP','15');
460: fnd_message.raise_error;
461: End dt_delete_validate;
462: --
463: -- ----------------------------------------------------------------------------

Line 460: fnd_message.raise_error;

456: --
457: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
458: fnd_message.set_token('PROCEDURE', l_proc);
459: fnd_message.set_token('STEP','15');
460: fnd_message.raise_error;
461: End dt_delete_validate;
462: --
463: -- ----------------------------------------------------------------------------
464: -- |---------------------------< insert_validate >----------------------------|

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

624: close csr_leg_code;
625: --
626: -- The primary key is invalid therefore we must error
627: --
628: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
629: fnd_message.raise_error;
630: --
631: end if;
632: --

Line 629: fnd_message.raise_error;

625: --
626: -- The primary key is invalid therefore we must error
627: --
628: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
629: fnd_message.raise_error;
630: --
631: end if;
632: --
633: close csr_leg_code;