224: ben_enp_shd.g_api_dml := false; -- Unset the api dml status
225: --
226: hr_utility.set_location(' Leaving:'||l_proc, 10);
227: Exception
228: When hr_api.check_integrity_violated Then
229: -- A check constraint has been violated
230: ben_enp_shd.g_api_dml := false; -- Unset the api dml status
231: ben_enp_shd.constraint_error
232: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
228: When hr_api.check_integrity_violated Then
229: -- A check constraint has been violated
230: ben_enp_shd.g_api_dml := false; -- Unset the api dml status
231: ben_enp_shd.constraint_error
232: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
233: When hr_api.parent_integrity_violated Then
234: -- Parent integrity has been violated
235: ben_enp_shd.g_api_dml := false; -- Unset the api dml status
236: ben_enp_shd.constraint_error
229: -- A check constraint has been violated
230: ben_enp_shd.g_api_dml := false; -- Unset the api dml status
231: ben_enp_shd.constraint_error
232: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
233: When hr_api.parent_integrity_violated Then
234: -- Parent integrity has been violated
235: ben_enp_shd.g_api_dml := false; -- Unset the api dml status
236: ben_enp_shd.constraint_error
237: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
233: When hr_api.parent_integrity_violated Then
234: -- Parent integrity has been violated
235: ben_enp_shd.g_api_dml := false; -- Unset the api dml status
236: ben_enp_shd.constraint_error
237: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
238: When hr_api.unique_integrity_violated Then
239: -- Unique integrity has been violated
240: ben_enp_shd.g_api_dml := false; -- Unset the api dml status
241: ben_enp_shd.constraint_error
234: -- Parent integrity has been violated
235: ben_enp_shd.g_api_dml := false; -- Unset the api dml status
236: ben_enp_shd.constraint_error
237: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
238: When hr_api.unique_integrity_violated Then
239: -- Unique integrity has been violated
240: ben_enp_shd.g_api_dml := false; -- Unset the api dml status
241: ben_enp_shd.constraint_error
242: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
238: When hr_api.unique_integrity_violated Then
239: -- Unique integrity has been violated
240: ben_enp_shd.g_api_dml := false; -- Unset the api dml status
241: ben_enp_shd.constraint_error
242: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
243: When Others Then
244: ben_enp_shd.g_api_dml := false; -- Unset the api dml status
245: Raise;
246: End insert_dml;
430: );
431: --
432: exception
433: --
434: when hr_api.cannot_find_prog_unit then
435: --
436: hr_api.cannot_find_prog_unit_error
437: (p_module_name => 'ben_enrt_perd'
438: ,p_hook_type => 'AI');
432: exception
433: --
434: when hr_api.cannot_find_prog_unit then
435: --
436: hr_api.cannot_find_prog_unit_error
437: (p_module_name => 'ben_enrt_perd'
438: ,p_hook_type => 'AI');
439: --
440: end;