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: per_cel_shd.g_api_dml := false; -- Unset the api dml status
73: per_cel_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: per_cel_shd.g_api_dml := false; -- Unset the api dml status
73: per_cel_shd.constraint_error
74: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
75: When Others Then
76: per_cel_shd.g_api_dml := false; -- Unset the api dml status
77: Raise;
78: End delete_dml;
257: p_achieved_date_o => per_cel_shd.g_old_rec.achieved_date,
258: p_appr_line_score_o => per_cel_shd.g_old_rec.appr_line_score
259: );
260: exception
261: when hr_api.cannot_find_prog_unit then
262: hr_api.cannot_find_prog_unit_error
263: ( p_module_name => 'PER_COMPETENCE_ELEMENTS'
264: ,p_hook_type => 'AD'
265: );
258: p_appr_line_score_o => per_cel_shd.g_old_rec.appr_line_score
259: );
260: exception
261: when hr_api.cannot_find_prog_unit then
262: hr_api.cannot_find_prog_unit_error
263: ( p_module_name => 'PER_COMPETENCE_ELEMENTS'
264: ,p_hook_type => 'AD'
265: );
266: end;
324: --
325: -- If we are validating then raise the Validate_Enabled exception
326: --
327: If p_validate then
328: Raise HR_Api.Validate_Enabled;
329: End If;
330: --
331: hr_utility.set_location(' Leaving:'||l_proc, 10);
332: Exception
329: End If;
330: --
331: hr_utility.set_location(' Leaving:'||l_proc, 10);
332: Exception
333: When HR_Api.Validate_Enabled Then
334: --
335: -- As the Validate_Enabled exception has been raised
336: -- we must rollback to the savepoint
337: --