172: --
173: --
174: hr_utility.set_location(' Leaving:'||l_proc, 10);
175: Exception
176: When hr_api.check_integrity_violated Then
177: -- A check constraint has been violated
178: -- Bug#885806
179: -- dbms_output.put_line('A check constraint has been violated insert-dml');
180: hr_utility.trace('A check constraint has been violated insert-dml');
180: hr_utility.trace('A check constraint has been violated insert-dml');
181: -- dbms_output.put_line('p_rec.rating_scale_id is :'|| p_rec.rating_scale_id);
182: hr_utility.trace('p_rec.rating_scale_id is :'|| p_rec.rating_scale_id);
183: per_ast_shd.constraint_error
184: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
185: When hr_api.parent_integrity_violated Then
186: -- Bug#885806
187: -- dbms_output.put_line('Parent integrity has been violated insert-dml');
188: hr_utility.trace('Parent integrity has been violated insert-dml');
181: -- dbms_output.put_line('p_rec.rating_scale_id is :'|| p_rec.rating_scale_id);
182: hr_utility.trace('p_rec.rating_scale_id is :'|| p_rec.rating_scale_id);
183: per_ast_shd.constraint_error
184: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
185: When hr_api.parent_integrity_violated Then
186: -- Bug#885806
187: -- dbms_output.put_line('Parent integrity has been violated insert-dml');
188: hr_utility.trace('Parent integrity has been violated insert-dml');
189: -- Parent integrity has been violated
187: -- dbms_output.put_line('Parent integrity has been violated insert-dml');
188: hr_utility.trace('Parent integrity has been violated insert-dml');
189: -- Parent integrity has been violated
190: per_ast_shd.constraint_error
191: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
192: When hr_api.unique_integrity_violated Then
193: -- Bug#885806
194: -- dbms_output.put_line('Unique integrity has been violated insert-dml');
195: hr_utility.trace('Unique integrity has been violated insert-dml');
188: hr_utility.trace('Parent integrity has been violated insert-dml');
189: -- Parent integrity has been violated
190: per_ast_shd.constraint_error
191: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
192: When hr_api.unique_integrity_violated Then
193: -- Bug#885806
194: -- dbms_output.put_line('Unique integrity has been violated insert-dml');
195: hr_utility.trace('Unique integrity has been violated insert-dml');
196: -- Unique integrity has been violated
194: -- dbms_output.put_line('Unique integrity has been violated insert-dml');
195: hr_utility.trace('Unique integrity has been violated insert-dml');
196: -- Unique integrity has been violated
197: per_ast_shd.constraint_error
198: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
199: When Others Then
200: -- Bug#885806
201: -- dbms_output.put_line('Something else has been violated insert-dml');
202: hr_utility.trace('Something else has been violated insert-dml');
376: p_default_job_competencies => p_rec.default_job_competencies,
377: p_available_flag => p_rec.available_flag
378: );
379: exception
380: when hr_api.cannot_find_prog_unit then
381: hr_api.cannot_find_prog_unit_error
382: ( p_module_name => 'PER_ASSESSMENT_TYPES'
383: ,p_hook_type => 'AI'
384: );
377: p_available_flag => p_rec.available_flag
378: );
379: exception
380: when hr_api.cannot_find_prog_unit then
381: hr_api.cannot_find_prog_unit_error
382: ( p_module_name => 'PER_ASSESSMENT_TYPES'
383: ,p_hook_type => 'AI'
384: );
385: end;
436: --
437: -- If we are validating then raise the Validate_Enabled exception
438: --
439: If p_validate then
440: Raise HR_Api.Validate_Enabled;
441: End If;
442: --
443: hr_utility.set_location(' Leaving:'||l_proc, 10);
444: Exception
441: End If;
442: --
443: hr_utility.set_location(' Leaving:'||l_proc, 10);
444: Exception
445: When HR_Api.Validate_Enabled Then
446: --
447: -- As the Validate_Enabled exception has been raised
448: -- we must rollback to the savepoint
449: --