232: ben_eet_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_eet_shd.g_api_dml := false; -- Unset the api dml status
239: ben_eet_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_eet_shd.g_api_dml := false; -- Unset the api dml status
239: ben_eet_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_eet_shd.g_api_dml := false; -- Unset the api dml status
244: ben_eet_shd.constraint_error
237: -- A check constraint has been violated
238: ben_eet_shd.g_api_dml := false; -- Unset the api dml status
239: ben_eet_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_eet_shd.g_api_dml := false; -- Unset the api dml status
244: ben_eet_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_eet_shd.g_api_dml := false; -- Unset the api dml status
244: ben_eet_shd.constraint_error
245: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
246: When Others Then
247: ben_eet_shd.g_api_dml := false; -- Unset the api dml status
248: Raise;
249: End dt_insert_dml;
433: );
434: --
435: exception
436: --
437: when hr_api.cannot_find_prog_unit then
438: --
439: hr_api.cannot_find_prog_unit_error
440: (p_module_name => 'ben_elig_enrld_anthr_ptip_f'
441: ,p_hook_type => 'AI');
435: exception
436: --
437: when hr_api.cannot_find_prog_unit then
438: --
439: hr_api.cannot_find_prog_unit_error
440: (p_module_name => 'ben_elig_enrld_anthr_ptip_f'
441: ,p_hook_type => 'AI');
442: --
443: end;
472: --
473: -- Post Failure:
474: -- The Lck process can fail for:
475: -- 1) When attempting to lock the row the row could already be locked by
476: -- another user. This will raise the HR_Api.Object_Locked exception.
477: -- 2) When attempting to the lock the parent which doesn't exist.
478: -- For the entity to be locked the parent must exist!
479: --
480: -- Developer Implementation Notes: