DBA Data[Home] [Help]

APPS.BEN_PGR_INS dependencies on HR_API

Line 232: When hr_api.check_integrity_violated Then

228: ben_pgr_shd.g_api_dml := false; -- Unset the api dml status
229: hr_utility.set_location(' Leaving:'||l_proc, 15);
230: --
231: Exception
232: When hr_api.check_integrity_violated Then
233: -- A check constraint has been violated
234: ben_pgr_shd.g_api_dml := false; -- Unset the api dml status
235: ben_pgr_shd.constraint_error
236: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 236: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

232: When hr_api.check_integrity_violated Then
233: -- A check constraint has been violated
234: ben_pgr_shd.g_api_dml := false; -- Unset the api dml status
235: ben_pgr_shd.constraint_error
236: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
237: When hr_api.unique_integrity_violated Then
238: -- Unique integrity has been violated
239: ben_pgr_shd.g_api_dml := false; -- Unset the api dml status
240: ben_pgr_shd.constraint_error

Line 237: When hr_api.unique_integrity_violated Then

233: -- A check constraint has been violated
234: ben_pgr_shd.g_api_dml := false; -- Unset the api dml status
235: ben_pgr_shd.constraint_error
236: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
237: When hr_api.unique_integrity_violated Then
238: -- Unique integrity has been violated
239: ben_pgr_shd.g_api_dml := false; -- Unset the api dml status
240: ben_pgr_shd.constraint_error
241: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 241: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

237: When hr_api.unique_integrity_violated Then
238: -- Unique integrity has been violated
239: ben_pgr_shd.g_api_dml := false; -- Unset the api dml status
240: ben_pgr_shd.constraint_error
241: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
242: When Others Then
243: ben_pgr_shd.g_api_dml := false; -- Unset the api dml status
244: Raise;
245: End dt_insert_dml;

Line 434: when hr_api.cannot_find_prog_unit then

430: );
431: --
432: exception
433: --
434: when hr_api.cannot_find_prog_unit then
435: --
436: hr_api.cannot_find_prog_unit_error
437: (p_module_name => 'ben_ppl_grp_rt_f'
438: ,p_hook_type => 'AI');

Line 436: hr_api.cannot_find_prog_unit_error

432: exception
433: --
434: when hr_api.cannot_find_prog_unit then
435: --
436: hr_api.cannot_find_prog_unit_error
437: (p_module_name => 'ben_ppl_grp_rt_f'
438: ,p_hook_type => 'AI');
439: --
440: end;

Line 473: -- another user. This will raise the HR_Api.Object_Locked exception.

469: --
470: -- Post Failure:
471: -- The Lck process can fail for:
472: -- 1) When attempting to lock the row the row could already be locked by
473: -- another user. This will raise the HR_Api.Object_Locked exception.
474: -- 2) When attempting to the lock the parent which doesn't exist.
475: -- For the entity to be locked the parent must exist!
476: --
477: -- Developer Implementation Notes: