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