232: ben_elv_shd.g_api_dml := false; -- Unset the api dml status
233: hr_utility.set_location(' Leaving:'||l_proc, 15);
234: --
235: Exception
236: When hr_api.check_integrity_violated Then
237: -- A check constraint has been violated
238: ben_elv_shd.g_api_dml := false; -- Unset the api dml status
239: ben_elv_shd.constraint_error
240: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
236: When hr_api.check_integrity_violated Then
237: -- A check constraint has been violated
238: ben_elv_shd.g_api_dml := false; -- Unset the api dml status
239: ben_elv_shd.constraint_error
240: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
241: When hr_api.unique_integrity_violated Then
242: -- Unique integrity has been violated
243: ben_elv_shd.g_api_dml := false; -- Unset the api dml status
244: ben_elv_shd.constraint_error
237: -- A check constraint has been violated
238: ben_elv_shd.g_api_dml := false; -- Unset the api dml status
239: ben_elv_shd.constraint_error
240: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
241: When hr_api.unique_integrity_violated Then
242: -- Unique integrity has been violated
243: ben_elv_shd.g_api_dml := false; -- Unset the api dml status
244: ben_elv_shd.constraint_error
245: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
241: When hr_api.unique_integrity_violated Then
242: -- Unique integrity has been violated
243: ben_elv_shd.g_api_dml := false; -- Unset the api dml status
244: ben_elv_shd.constraint_error
245: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
246: When Others Then
247: ben_elv_shd.g_api_dml := false; -- Unset the api dml status
248: Raise;
249: End dt_insert_dml;
432: );
433: --
434: exception
435: --
436: when hr_api.cannot_find_prog_unit then
437: --
438: hr_api.cannot_find_prog_unit_error
439: (p_module_name => 'ben_elig_lvg_rsn_prte_f'
440: ,p_hook_type => 'AI');
434: exception
435: --
436: when hr_api.cannot_find_prog_unit then
437: --
438: hr_api.cannot_find_prog_unit_error
439: (p_module_name => 'ben_elig_lvg_rsn_prte_f'
440: ,p_hook_type => 'AI');
441: --
442: end;
471: --
472: -- Post Failure:
473: -- The Lck process can fail for:
474: -- 1) When attempting to lock the row the row could already be locked by
475: -- another user. This will raise the HR_Api.Object_Locked exception.
476: -- 2) When attempting to the lock the parent which doesn't exist.
477: -- For the entity to be locked the parent must exist!
478: --
479: -- Developer Implementation Notes: