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