226: ben_ser_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_ser_shd.g_api_dml := false; -- Unset the api dml status
233: ben_ser_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_ser_shd.g_api_dml := false; -- Unset the api dml status
233: ben_ser_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_ser_shd.g_api_dml := false; -- Unset the api dml status
238: ben_ser_shd.constraint_error
231: -- A check constraint has been violated
232: ben_ser_shd.g_api_dml := false; -- Unset the api dml status
233: ben_ser_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_ser_shd.g_api_dml := false; -- Unset the api dml status
238: ben_ser_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_ser_shd.g_api_dml := false; -- Unset the api dml status
238: ben_ser_shd.constraint_error
239: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
240: When Others Then
241: ben_ser_shd.g_api_dml := false; -- Unset the api dml status
242: Raise;
243: End dt_insert_dml;
425: );
426: --
427: exception
428: --
429: when hr_api.cannot_find_prog_unit then
430: --
431: hr_api.cannot_find_prog_unit_error
432: (p_module_name => 'ben_schedd_enrt_rl_f'
433: ,p_hook_type => 'AI');
427: exception
428: --
429: when hr_api.cannot_find_prog_unit then
430: --
431: hr_api.cannot_find_prog_unit_error
432: (p_module_name => 'ben_schedd_enrt_rl_f'
433: ,p_hook_type => 'AI');
434: --
435: end;
464: --
465: -- Post Failure:
466: -- The Lck process can fail for:
467: -- 1) When attempting to lock the row the row could already be locked by
468: -- another user. This will raise the HR_Api.Object_Locked exception.
469: -- 2) When attempting to the lock the parent which doesn't exist.
470: -- For the entity to be locked the parent must exist!
471: --
472: -- Developer Implementation Notes: