79: --
80: hr_utility.set_location(' Leaving:'||l_proc, 10);
81: --
82: Exception
83: When hr_api.child_integrity_violated then
84: -- Child integrity has been violated
85: ota_evt_shd.g_api_dml := false; -- Unset the api dml status
86: ota_evt_shd.constraint_error
87: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
83: When hr_api.child_integrity_violated then
84: -- Child integrity has been violated
85: ota_evt_shd.g_api_dml := false; -- Unset the api dml status
86: ota_evt_shd.constraint_error
87: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
88: When Others Then
89: ota_evt_shd.g_api_dml := false; -- Unset the api dml status
90: Raise;
91: End delete_dml;
231: --
232: -- If we are validating then raise the Validate_Enabled exception
233: --
234: If p_validate then
235: Raise HR_Api.Validate_Enabled;
236: End If;
237: --
238: hr_utility.set_location(' Leaving:'||l_proc, 10);
239: Exception
236: End If;
237: --
238: hr_utility.set_location(' Leaving:'||l_proc, 10);
239: Exception
240: When HR_Api.Validate_Enabled Then
241: --
242: -- As the Validate_Enabled exception has been raised
243: -- we must rollback to the savepoint
244: --