257: --
258: --
259: hr_utility.set_location(' Leaving:'||l_proc, 10);
260: Exception
261: When hr_api.check_integrity_violated Then
262: -- A check constraint has been violated
263: --
264: hr_itp_shd.constraint_error
265: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
261: When hr_api.check_integrity_violated Then
262: -- A check constraint has been violated
263: --
264: hr_itp_shd.constraint_error
265: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
266: When hr_api.parent_integrity_violated Then
267: -- Parent integrity has been violated
268: --
269: hr_itp_shd.constraint_error
262: -- A check constraint has been violated
263: --
264: hr_itp_shd.constraint_error
265: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
266: When hr_api.parent_integrity_violated Then
267: -- Parent integrity has been violated
268: --
269: hr_itp_shd.constraint_error
270: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
266: When hr_api.parent_integrity_violated Then
267: -- Parent integrity has been violated
268: --
269: hr_itp_shd.constraint_error
270: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
271: When hr_api.unique_integrity_violated Then
272: -- Unique integrity has been violated
273: --
274: hr_itp_shd.constraint_error
267: -- Parent integrity has been violated
268: --
269: hr_itp_shd.constraint_error
270: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
271: When hr_api.unique_integrity_violated Then
272: -- Unique integrity has been violated
273: --
274: hr_itp_shd.constraint_error
275: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
271: When hr_api.unique_integrity_violated Then
272: -- Unique integrity has been violated
273: --
274: hr_itp_shd.constraint_error
275: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
276: When Others Then
277: --
278: Raise;
279: End insert_dml;
524: );
525: --
526: exception
527: --
528: when hr_api.cannot_find_prog_unit then
529: --
530: hr_api.cannot_find_prog_unit_error
531: (p_module_name => 'HR_ITEM_PROPERTIES_B'
532: ,p_hook_type => 'AI');
526: exception
527: --
528: when hr_api.cannot_find_prog_unit then
529: --
530: hr_api.cannot_find_prog_unit_error
531: (p_module_name => 'HR_ITEM_PROPERTIES_B'
532: ,p_hook_type => 'AI');
533: --
534: end;