226: ben_omr_shd.g_api_dml := false; -- Unset the api dml status
227: hr_utility.set_location(' Leaving:'||l_proc, 15);
228: --
229: Exception
230: When hr_api.check_integrity_violated Then
231: -- A check constraint has been violated
232: ben_omr_shd.g_api_dml := false; -- Unset the api dml status
233: ben_omr_shd.constraint_error
234: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
230: When hr_api.check_integrity_violated Then
231: -- A check constraint has been violated
232: ben_omr_shd.g_api_dml := false; -- Unset the api dml status
233: ben_omr_shd.constraint_error
234: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
235: When hr_api.unique_integrity_violated Then
236: -- Unique integrity has been violated
237: ben_omr_shd.g_api_dml := false; -- Unset the api dml status
238: ben_omr_shd.constraint_error
231: -- A check constraint has been violated
232: ben_omr_shd.g_api_dml := false; -- Unset the api dml status
233: ben_omr_shd.constraint_error
234: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
235: When hr_api.unique_integrity_violated Then
236: -- Unique integrity has been violated
237: ben_omr_shd.g_api_dml := false; -- Unset the api dml status
238: ben_omr_shd.constraint_error
239: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
235: When hr_api.unique_integrity_violated Then
236: -- Unique integrity has been violated
237: ben_omr_shd.g_api_dml := false; -- Unset the api dml status
238: ben_omr_shd.constraint_error
239: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
240: When Others Then
241: ben_omr_shd.g_api_dml := false; -- Unset the api dml status
242: Raise;
243: End dt_insert_dml;
423: );
424: --
425: exception
426: --
427: when hr_api.cannot_find_prog_unit then
428: --
429: hr_api.cannot_find_prog_unit_error
430: (p_module_name => 'ben_OPTD_MDCR_RT_f'
431: ,p_hook_type => 'AI');
425: exception
426: --
427: when hr_api.cannot_find_prog_unit then
428: --
429: hr_api.cannot_find_prog_unit_error
430: (p_module_name => 'ben_OPTD_MDCR_RT_f'
431: ,p_hook_type => 'AI');
432: --
433: end;
462: --
463: -- Post Failure:
464: -- The Lck process can fail for:
465: -- 1) When attempting to lock the row the row could already be locked by
466: -- another user. This will raise the HR_Api.Object_Locked exception.
467: -- 2) When attempting to the lock the parent which doesn't exist.
468: -- For the entity to be locked the parent must exist!
469: --
470: -- Developer Implementation Notes: