263: ben_ecr_shd.g_api_dml := false; -- Unset the api dml status
264: --
265: hr_utility.set_location(' Leaving:'||l_proc, 10);
266: Exception
267: When hr_api.check_integrity_violated Then
268: -- A check constraint has been violated
269: ben_ecr_shd.g_api_dml := false; -- Unset the api dml status
270: ben_ecr_shd.constraint_error
271: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
267: When hr_api.check_integrity_violated Then
268: -- A check constraint has been violated
269: ben_ecr_shd.g_api_dml := false; -- Unset the api dml status
270: ben_ecr_shd.constraint_error
271: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
272: When hr_api.parent_integrity_violated Then
273: -- Parent integrity has been violated
274: ben_ecr_shd.g_api_dml := false; -- Unset the api dml status
275: ben_ecr_shd.constraint_error
268: -- A check constraint has been violated
269: ben_ecr_shd.g_api_dml := false; -- Unset the api dml status
270: ben_ecr_shd.constraint_error
271: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
272: When hr_api.parent_integrity_violated Then
273: -- Parent integrity has been violated
274: ben_ecr_shd.g_api_dml := false; -- Unset the api dml status
275: ben_ecr_shd.constraint_error
276: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
272: When hr_api.parent_integrity_violated Then
273: -- Parent integrity has been violated
274: ben_ecr_shd.g_api_dml := false; -- Unset the api dml status
275: ben_ecr_shd.constraint_error
276: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
277: When hr_api.unique_integrity_violated Then
278: -- Unique integrity has been violated
279: ben_ecr_shd.g_api_dml := false; -- Unset the api dml status
280: ben_ecr_shd.constraint_error
273: -- Parent integrity has been violated
274: ben_ecr_shd.g_api_dml := false; -- Unset the api dml status
275: ben_ecr_shd.constraint_error
276: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
277: When hr_api.unique_integrity_violated Then
278: -- Unique integrity has been violated
279: ben_ecr_shd.g_api_dml := false; -- Unset the api dml status
280: ben_ecr_shd.constraint_error
281: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
277: When hr_api.unique_integrity_violated Then
278: -- Unique integrity has been violated
279: ben_ecr_shd.g_api_dml := false; -- Unset the api dml status
280: ben_ecr_shd.constraint_error
281: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
282: When Others Then
283: ben_ecr_shd.g_api_dml := false; -- Unset the api dml status
284: Raise;
285: End insert_dml;