58: --
59: hr_utility.set_location(' Leaving:'||l_proc, 10);
60: --
61: Exception
62: When hr_api.child_integrity_violated then
63: -- Child integrity has been violated
64: per_cpn_shd.constraint_error
65: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
66: When Others Then
61: Exception
62: When hr_api.child_integrity_violated then
63: -- Child integrity has been violated
64: per_cpn_shd.constraint_error
65: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
66: When Others Then
67: Raise;
68: End delete_dml;
69: --
224: ,p_information19_o => per_cpn_shd.g_old_rec.information19
225: ,p_information20_o => per_cpn_shd.g_old_rec.information20
226: );
227: exception
228: when hr_api.cannot_find_prog_unit then
229: hr_api.cannot_find_prog_unit_error
230: ( p_module_name => 'PER_COMPETENCES'
231: ,p_hook_type => 'AD'
232: );
225: ,p_information20_o => per_cpn_shd.g_old_rec.information20
226: );
227: exception
228: when hr_api.cannot_find_prog_unit then
229: hr_api.cannot_find_prog_unit_error
230: ( p_module_name => 'PER_COMPETENCES'
231: ,p_hook_type => 'AD'
232: );
233: end;
285: --
286: -- If we are validating then raise the Validate_Enabled exception
287: --
288: If p_validate then
289: Raise HR_Api.Validate_Enabled;
290: End If;
291: --
292: hr_utility.set_location(' Leaving:'||l_proc, 10);
293: Exception
290: End If;
291: --
292: hr_utility.set_location(' Leaving:'||l_proc, 10);
293: Exception
294: When HR_Api.Validate_Enabled Then
295: --
296: -- As the Validate_Enabled exception has been raised
297: -- we must rollback to the savepoint
298: --