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