150: per_anc_shd.g_api_dml := false; -- Unset the api dml status
151: --
152: hr_utility.set_location(' Leaving:'||l_proc, 10);
153: Exception
154: When hr_api.check_integrity_violated Then
155: -- A check constraint has been violated
156: per_anc_shd.g_api_dml := false; -- Unset the api dml status
157: per_anc_shd.constraint_error
158: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
154: When hr_api.check_integrity_violated Then
155: -- A check constraint has been violated
156: per_anc_shd.g_api_dml := false; -- Unset the api dml status
157: per_anc_shd.constraint_error
158: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
159: When hr_api.parent_integrity_violated Then
160: -- Parent integrity has been violated
161: per_anc_shd.g_api_dml := false; -- Unset the api dml status
162: per_anc_shd.constraint_error
155: -- A check constraint has been violated
156: per_anc_shd.g_api_dml := false; -- Unset the api dml status
157: per_anc_shd.constraint_error
158: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
159: When hr_api.parent_integrity_violated Then
160: -- Parent integrity has been violated
161: per_anc_shd.g_api_dml := false; -- Unset the api dml status
162: per_anc_shd.constraint_error
163: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
159: When hr_api.parent_integrity_violated Then
160: -- Parent integrity has been violated
161: per_anc_shd.g_api_dml := false; -- Unset the api dml status
162: per_anc_shd.constraint_error
163: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
164: When hr_api.unique_integrity_violated Then
165: -- Unique integrity has been violated
166: per_anc_shd.g_api_dml := false; -- Unset the api dml status
167: per_anc_shd.constraint_error
160: -- Parent integrity has been violated
161: per_anc_shd.g_api_dml := false; -- Unset the api dml status
162: per_anc_shd.constraint_error
163: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
164: When hr_api.unique_integrity_violated Then
165: -- Unique integrity has been violated
166: per_anc_shd.g_api_dml := false; -- Unset the api dml status
167: per_anc_shd.constraint_error
168: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
164: When hr_api.unique_integrity_violated Then
165: -- Unique integrity has been violated
166: per_anc_shd.g_api_dml := false; -- Unset the api dml status
167: per_anc_shd.constraint_error
168: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
169: When Others Then
170: per_anc_shd.g_api_dml := false; -- Unset the api dml status
171: Raise;
172: End insert_dml;
316: --
317: -- If we are validating then raise the Validate_Enabled exception
318: --
319: If p_validate then
320: Raise HR_Api.Validate_Enabled;
321: End If;
322: --
323: hr_utility.set_location(' Leaving:'||l_proc, 10);
324: Exception
321: End If;
322: --
323: hr_utility.set_location(' Leaving:'||l_proc, 10);
324: Exception
325: When HR_Api.Validate_Enabled Then
326: --
327: -- As the Validate_Enabled exception has been raised
328: -- we must rollback to the savepoint
329: --