198: --
199: --
200: hr_utility.set_location(' Leaving:'||l_proc, 10);
201: Exception
202: When hr_api.check_integrity_violated Then
203: -- A check constraint has been violated
204: --
205: per_pml_shd.constraint_error
206: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
202: When hr_api.check_integrity_violated Then
203: -- A check constraint has been violated
204: --
205: per_pml_shd.constraint_error
206: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
207: When hr_api.parent_integrity_violated Then
208: -- Parent integrity has been violated
209: --
210: per_pml_shd.constraint_error
203: -- A check constraint has been violated
204: --
205: per_pml_shd.constraint_error
206: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
207: When hr_api.parent_integrity_violated Then
208: -- Parent integrity has been violated
209: --
210: per_pml_shd.constraint_error
211: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
207: When hr_api.parent_integrity_violated Then
208: -- Parent integrity has been violated
209: --
210: per_pml_shd.constraint_error
211: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
212: When hr_api.unique_integrity_violated Then
213: -- Unique integrity has been violated
214: --
215: per_pml_shd.constraint_error
208: -- Parent integrity has been violated
209: --
210: per_pml_shd.constraint_error
211: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
212: When hr_api.unique_integrity_violated Then
213: -- Unique integrity has been violated
214: --
215: per_pml_shd.constraint_error
216: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
212: When hr_api.unique_integrity_violated Then
213: -- Unique integrity has been violated
214: --
215: per_pml_shd.constraint_error
216: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
217: When Others Then
218: --
219: Raise;
220: End insert_dml;
472: );
473: --
474: exception
475: --
476: when hr_api.cannot_find_prog_unit then
477: --
478: hr_api.cannot_find_prog_unit_error
479: (p_module_name => 'PER_OBJECTIVES_LIBRARY'
480: ,p_hook_type => 'AI');
474: exception
475: --
476: when hr_api.cannot_find_prog_unit then
477: --
478: hr_api.cannot_find_prog_unit_error
479: (p_module_name => 'PER_OBJECTIVES_LIBRARY'
480: ,p_hook_type => 'AI');
481: --
482: end;