252: ben_egr_shd.g_api_dml := false; -- Unset the api dml status
253: hr_utility.set_location(' Leaving:'||l_proc, 15);
254: --
255: Exception
256: When hr_api.check_integrity_violated Then
257: -- A check constraint has been violated
258: ben_egr_shd.g_api_dml := false; -- Unset the api dml status
259: ben_egr_shd.constraint_error
260: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
256: When hr_api.check_integrity_violated Then
257: -- A check constraint has been violated
258: ben_egr_shd.g_api_dml := false; -- Unset the api dml status
259: ben_egr_shd.constraint_error
260: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
261: When hr_api.unique_integrity_violated Then
262: -- Unique integrity has been violated
263: ben_egr_shd.g_api_dml := false; -- Unset the api dml status
264: ben_egr_shd.constraint_error
257: -- A check constraint has been violated
258: ben_egr_shd.g_api_dml := false; -- Unset the api dml status
259: ben_egr_shd.constraint_error
260: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
261: When hr_api.unique_integrity_violated Then
262: -- Unique integrity has been violated
263: ben_egr_shd.g_api_dml := false; -- Unset the api dml status
264: ben_egr_shd.constraint_error
265: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
261: When hr_api.unique_integrity_violated Then
262: -- Unique integrity has been violated
263: ben_egr_shd.g_api_dml := false; -- Unset the api dml status
264: ben_egr_shd.constraint_error
265: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
266: When Others Then
267: ben_egr_shd.g_api_dml := false; -- Unset the api dml status
268: Raise;
269: End dt_insert_dml;
489: );
490: --
491: exception
492: --
493: when hr_api.cannot_find_prog_unit then
494: --
495: hr_api.cannot_find_prog_unit_error
496: (p_module_name => 'ben_elig_grd_prte_f'
497: ,p_hook_type => 'AI');
491: exception
492: --
493: when hr_api.cannot_find_prog_unit then
494: --
495: hr_api.cannot_find_prog_unit_error
496: (p_module_name => 'ben_elig_grd_prte_f'
497: ,p_hook_type => 'AI');
498: --
499: end;
528: --
529: -- Post Failure:
530: -- The Lck process can fail for:
531: -- 1) When attempting to lock the row the row could already be locked by
532: -- another user. This will raise the HR_Api.Object_Locked exception.
533: -- 2) When attempting to the lock the parent which doesn't exist.
534: -- For the entity to be locked the parent must exist!
535: --
536: -- Developer Implementation Notes: