252: ben_dce_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_dce_shd.g_api_dml := false; -- Unset the api dml status
259: ben_dce_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_dce_shd.g_api_dml := false; -- Unset the api dml status
259: ben_dce_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_dce_shd.g_api_dml := false; -- Unset the api dml status
264: ben_dce_shd.constraint_error
257: -- A check constraint has been violated
258: ben_dce_shd.g_api_dml := false; -- Unset the api dml status
259: ben_dce_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_dce_shd.g_api_dml := false; -- Unset the api dml status
264: ben_dce_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_dce_shd.g_api_dml := false; -- Unset the api dml status
264: ben_dce_shd.constraint_error
265: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
266: When Others Then
267: ben_dce_shd.g_api_dml := false; -- Unset the api dml status
268: Raise;
269: End dt_insert_dml;
467: );
468: --
469: exception
470: --
471: when hr_api.cannot_find_prog_unit then
472: --
473: hr_api.cannot_find_prog_unit_error
474: (p_module_name => 'ben_dpnt_cvg_eligy_prfl_f'
475: ,p_hook_type => 'AI');
469: exception
470: --
471: when hr_api.cannot_find_prog_unit then
472: --
473: hr_api.cannot_find_prog_unit_error
474: (p_module_name => 'ben_dpnt_cvg_eligy_prfl_f'
475: ,p_hook_type => 'AI');
476: --
477: end;
506: --
507: -- Post Failure:
508: -- The Lck process can fail for:
509: -- 1) When attempting to lock the row the row could already be locked by
510: -- another user. This will raise the HR_Api.Object_Locked exception.
511: -- 2) When attempting to the lock the parent which doesn't exist.
512: -- For the entity to be locked the parent must exist!
513: --
514: -- Developer Implementation Notes: