308: --
309: --
310: hr_utility.set_location(' Leaving:'||l_proc, 10);
311: Exception
312: When hr_api.check_integrity_violated Then
313: -- A check constraint has been violated
314: --
315: hr_icx_shd.constraint_error
316: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
312: When hr_api.check_integrity_violated Then
313: -- A check constraint has been violated
314: --
315: hr_icx_shd.constraint_error
316: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
317: When hr_api.parent_integrity_violated Then
318: -- Parent integrity has been violated
319: --
320: hr_icx_shd.constraint_error
313: -- A check constraint has been violated
314: --
315: hr_icx_shd.constraint_error
316: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
317: When hr_api.parent_integrity_violated Then
318: -- Parent integrity has been violated
319: --
320: hr_icx_shd.constraint_error
321: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
317: When hr_api.parent_integrity_violated Then
318: -- Parent integrity has been violated
319: --
320: hr_icx_shd.constraint_error
321: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
322: When hr_api.unique_integrity_violated Then
323: -- Unique integrity has been violated
324: --
325: hr_icx_shd.constraint_error
318: -- Parent integrity has been violated
319: --
320: hr_icx_shd.constraint_error
321: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
322: When hr_api.unique_integrity_violated Then
323: -- Unique integrity has been violated
324: --
325: hr_icx_shd.constraint_error
326: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
322: When hr_api.unique_integrity_violated Then
323: -- Unique integrity has been violated
324: --
325: hr_icx_shd.constraint_error
326: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
327: When Others Then
328: --
329: Raise;
330: End insert_dml;
509: );
510: --
511: exception
512: --
513: when hr_api.cannot_find_prog_unit then
514: --
515: hr_api.cannot_find_prog_unit_error
516: (p_module_name => 'HR_ITEM_CONTEXTS'
517: ,p_hook_type => 'AI');
511: exception
512: --
513: when hr_api.cannot_find_prog_unit then
514: --
515: hr_api.cannot_find_prog_unit_error
516: (p_module_name => 'HR_ITEM_CONTEXTS'
517: ,p_hook_type => 'AI');
518: --
519: end;