164: per_kad_shd.g_api_dml := false; -- Unset the api dml status
165: --
166: hr_utility.set_location(' Leaving:'||l_proc, 10);
167: Exception
168: When hr_api.check_integrity_violated Then
169: -- A check constraint has been violated
170: per_kad_shd.g_api_dml := false; -- Unset the api dml status
171: per_kad_shd.constraint_error
172: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
168: When hr_api.check_integrity_violated Then
169: -- A check constraint has been violated
170: per_kad_shd.g_api_dml := false; -- Unset the api dml status
171: per_kad_shd.constraint_error
172: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
173: When hr_api.parent_integrity_violated Then
174: -- Parent integrity has been violated
175: per_kad_shd.g_api_dml := false; -- Unset the api dml status
176: per_kad_shd.constraint_error
169: -- A check constraint has been violated
170: per_kad_shd.g_api_dml := false; -- Unset the api dml status
171: per_kad_shd.constraint_error
172: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
173: When hr_api.parent_integrity_violated Then
174: -- Parent integrity has been violated
175: per_kad_shd.g_api_dml := false; -- Unset the api dml status
176: per_kad_shd.constraint_error
177: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
173: When hr_api.parent_integrity_violated Then
174: -- Parent integrity has been violated
175: per_kad_shd.g_api_dml := false; -- Unset the api dml status
176: per_kad_shd.constraint_error
177: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
178: When hr_api.unique_integrity_violated Then
179: -- Unique integrity has been violated
180: per_kad_shd.g_api_dml := false; -- Unset the api dml status
181: per_kad_shd.constraint_error
174: -- Parent integrity has been violated
175: per_kad_shd.g_api_dml := false; -- Unset the api dml status
176: per_kad_shd.constraint_error
177: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
178: When hr_api.unique_integrity_violated Then
179: -- Unique integrity has been violated
180: per_kad_shd.g_api_dml := false; -- Unset the api dml status
181: per_kad_shd.constraint_error
182: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
178: When hr_api.unique_integrity_violated Then
179: -- Unique integrity has been violated
180: per_kad_shd.g_api_dml := false; -- Unset the api dml status
181: per_kad_shd.constraint_error
182: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
183: When Others Then
184: per_kad_shd.g_api_dml := false; -- Unset the api dml status
185: Raise;
186: End insert_dml;
352: --
353: -- If we are validating then raise the Validate_Enabled exception
354: --
355: If p_validate then
356: Raise HR_Api.Validate_Enabled;
357: End If;
358: --
359: hr_utility.set_location(' Leaving:'||l_proc, 10);
360: Exception
357: End If;
358: --
359: hr_utility.set_location(' Leaving:'||l_proc, 10);
360: Exception
361: When HR_Api.Validate_Enabled Then
362: --
363: -- As the Validate_Enabled exception has been raised
364: -- we must rollback to the savepoint
365: --