272: ben_epe_shd.g_api_dml := false; -- Unset the api dml status
273: --
274: hr_utility.set_location(' Leaving:'||l_proc, 10);
275: Exception
276: When hr_api.check_integrity_violated Then
277: -- A check constraint has been violated
278: ben_epe_shd.g_api_dml := false; -- Unset the api dml status
279: ben_epe_shd.constraint_error
280: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
276: When hr_api.check_integrity_violated Then
277: -- A check constraint has been violated
278: ben_epe_shd.g_api_dml := false; -- Unset the api dml status
279: ben_epe_shd.constraint_error
280: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
281: When hr_api.parent_integrity_violated Then
282: -- Parent integrity has been violated
283: ben_epe_shd.g_api_dml := false; -- Unset the api dml status
284: ben_epe_shd.constraint_error
277: -- A check constraint has been violated
278: ben_epe_shd.g_api_dml := false; -- Unset the api dml status
279: ben_epe_shd.constraint_error
280: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
281: When hr_api.parent_integrity_violated Then
282: -- Parent integrity has been violated
283: ben_epe_shd.g_api_dml := false; -- Unset the api dml status
284: ben_epe_shd.constraint_error
285: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
281: When hr_api.parent_integrity_violated Then
282: -- Parent integrity has been violated
283: ben_epe_shd.g_api_dml := false; -- Unset the api dml status
284: ben_epe_shd.constraint_error
285: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
286: When hr_api.unique_integrity_violated Then
287: -- Unique integrity has been violated
288: ben_epe_shd.g_api_dml := false; -- Unset the api dml status
289: ben_epe_shd.constraint_error
282: -- Parent integrity has been violated
283: ben_epe_shd.g_api_dml := false; -- Unset the api dml status
284: ben_epe_shd.constraint_error
285: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
286: When hr_api.unique_integrity_violated Then
287: -- Unique integrity has been violated
288: ben_epe_shd.g_api_dml := false; -- Unset the api dml status
289: ben_epe_shd.constraint_error
290: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
286: When hr_api.unique_integrity_violated Then
287: -- Unique integrity has been violated
288: ben_epe_shd.g_api_dml := false; -- Unset the api dml status
289: ben_epe_shd.constraint_error
290: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
291: When Others Then
292: ben_epe_shd.g_api_dml := false; -- Unset the api dml status
293: Raise;
294: End insert_dml;