66: --
67: hr_utility.set_location(' Leaving:'||l_proc, 10);
68: --
69: Exception
70: When hr_api.child_integrity_violated then
71: -- Child integrity has been violated
72: ota_tea_shd.g_api_dml := false; -- Unset the api dml status
73: ota_tea_shd.constraint_error
74: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
70: When hr_api.child_integrity_violated then
71: -- Child integrity has been violated
72: ota_tea_shd.g_api_dml := false; -- Unset the api dml status
73: ota_tea_shd.constraint_error
74: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
75: When Others Then
76: ota_tea_shd.g_api_dml := false; -- Unset the api dml status
77: Raise;
78: End delete_dml;
213: --
214: -- If we are validating then raise the Validate_Enabled exception
215: --
216: If p_validate then
217: Raise HR_Api.Validate_Enabled;
218: End If;
219: --
220: hr_utility.set_location(' Leaving:'||l_proc, 10);
221: Exception
218: End If;
219: --
220: hr_utility.set_location(' Leaving:'||l_proc, 10);
221: Exception
222: When HR_Api.Validate_Enabled Then
223: --
224: -- As the Validate_Enabled exception has been raised
225: -- we must rollback to the savepoint
226: --