APPS.PER_AST_INS dependencies on HR_API

Line 176: When hr_api.check_integrity_violated Then

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');

Line 184: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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');

Line 185: When hr_api.parent_integrity_violated Then

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

Line 191: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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');

Line 192: When hr_api.unique_integrity_violated Then

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

Line 198: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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');

Line 380: when hr_api.cannot_find_prog_unit then

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: );

Line 381: hr_api.cannot_find_prog_unit_error

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;

Line 440: Raise HR_Api.Validate_Enabled;

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

Line 445: When HR_Api.Validate_Enabled Then

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: --