56: --
57: hr_utility.set_location(' Leaving:'||l_proc, 10);
58: --
59: Exception
60: When hr_api.child_integrity_violated then
61: -- Child integrity has been violated
62: ghr_pre_shd.constraint_error
63: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
64: When Others Then
59: Exception
60: When hr_api.child_integrity_violated then
61: -- Child integrity has been violated
62: ghr_pre_shd.constraint_error
63: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
64: When Others Then
65: Raise;
66: End delete_dml;
67: --
168: ghr_pre_shd.g_old_rec.object_version_number
169: );
170:
171: exception
172: when hr_api.cannot_find_prog_unit then
173: hr_api.cannot_find_prog_unit_error
174: ( p_module_name => 'GHR_PA_REMARKS'
175: ,p_hook_type => 'AD'
176: );
169: );
170:
171: exception
172: when hr_api.cannot_find_prog_unit then
173: hr_api.cannot_find_prog_unit_error
174: ( p_module_name => 'GHR_PA_REMARKS'
175: ,p_hook_type => 'AD'
176: );
177: end;
233: --
234: -- If we are validating then raise the Validate_Enabled exception
235: --
236: If p_validate then
237: Raise HR_Api.Validate_Enabled;
238: End If;
239: --
240: hr_utility.set_location(' Leaving:'||l_proc, 10);
241: Exception
238: End If;
239: --
240: hr_utility.set_location(' Leaving:'||l_proc, 10);
241: Exception
242: When HR_Api.Validate_Enabled Then
243: --
244: -- As the Validate_Enabled exception has been raised
245: -- we must rollback to the savepoint
246: --