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_pju_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_pju_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_pju_shd.constraint_error
203: -- A check constraint has been violated
204: --
205: per_pju_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_pju_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_pju_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_pju_shd.constraint_error
208: -- Parent integrity has been violated
209: --
210: per_pju_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_pju_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_pju_shd.constraint_error
216: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
217: When Others Then
218: --
219: Raise;
220: End insert_dml;
461: );
462: --
463: exception
464: --
465: when hr_api.cannot_find_prog_unit then
466: --
467: hr_api.cannot_find_prog_unit_error
468: (p_module_name => 'PER_PREVIOUS_JOB_USAGES'
469: ,p_hook_type => 'AI');
463: exception
464: --
465: when hr_api.cannot_find_prog_unit then
466: --
467: hr_api.cannot_find_prog_unit_error
468: (p_module_name => 'PER_PREVIOUS_JOB_USAGES'
469: ,p_hook_type => 'AI');
470: --
471: end;