DBA Data[Home] [Help]

APPS.BEN_ECR_INS dependencies on HR_API

Line 267: When hr_api.check_integrity_violated Then

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));

Line 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

Line 272: When hr_api.parent_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
276: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 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

Line 277: When hr_api.unique_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
281: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 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;