83: --
84: hr_utility.set_location(' Leaving:'||l_proc, 10);
85: --
86: Exception
87: When hr_api.child_integrity_violated then
88: -- Child integrity has been violated
89: per_ast_shd.constraint_error
90: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
91: When Others Then
86: Exception
87: When hr_api.child_integrity_violated then
88: -- Child integrity has been violated
89: per_ast_shd.constraint_error
90: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
91: When Others Then
92: Raise;
93: End delete_dml;
94: --
224: p_line_score_formula_id_o => per_ast_shd.g_old_rec.line_score_formula_id,
225: p_default_job_competencies_o => per_ast_shd.g_old_rec.default_job_competencies,
226: p_available_flag_o => per_ast_shd.g_old_rec.available_flag);
227: exception
228: when hr_api.cannot_find_prog_unit then
229: hr_api.cannot_find_prog_unit_error
230: ( p_module_name => 'PER_ASSESSMENT_TYPES'
231: ,p_hook_type => 'AD'
232: );
225: p_default_job_competencies_o => per_ast_shd.g_old_rec.default_job_competencies,
226: p_available_flag_o => per_ast_shd.g_old_rec.available_flag);
227: exception
228: when hr_api.cannot_find_prog_unit then
229: hr_api.cannot_find_prog_unit_error
230: ( p_module_name => 'PER_ASSESSMENT_TYPES'
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: --