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