391: --
392: --
393: hr_utility.set_location(' Leaving:'||l_proc, 10);
394: Exception
395: When hr_api.check_integrity_violated Then
396: -- A check constraint has been violated
397: --
398: ghr_cmp_shd.constraint_error
399: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
395: When hr_api.check_integrity_violated Then
396: -- A check constraint has been violated
397: --
398: ghr_cmp_shd.constraint_error
399: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
400: When hr_api.parent_integrity_violated Then
401: -- Parent integrity has been violated
402: --
403: ghr_cmp_shd.constraint_error
396: -- A check constraint has been violated
397: --
398: ghr_cmp_shd.constraint_error
399: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
400: When hr_api.parent_integrity_violated Then
401: -- Parent integrity has been violated
402: --
403: ghr_cmp_shd.constraint_error
404: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
400: When hr_api.parent_integrity_violated Then
401: -- Parent integrity has been violated
402: --
403: ghr_cmp_shd.constraint_error
404: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
405: When hr_api.unique_integrity_violated Then
406: -- Unique integrity has been violated
407: --
408: ghr_cmp_shd.constraint_error
401: -- Parent integrity has been violated
402: --
403: ghr_cmp_shd.constraint_error
404: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
405: When hr_api.unique_integrity_violated Then
406: -- Unique integrity has been violated
407: --
408: ghr_cmp_shd.constraint_error
409: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
405: When hr_api.unique_integrity_violated Then
406: -- Unique integrity has been violated
407: --
408: ghr_cmp_shd.constraint_error
409: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
410: When Others Then
411: --
412: Raise;
413: End insert_dml;
678: );
679: --
680: exception
681: --
682: when hr_api.cannot_find_prog_unit then
683: --
684: hr_api.cannot_find_prog_unit_error
685: (p_module_name => 'GHR_COMPLAINTS2'
686: ,p_hook_type => 'AI');
680: exception
681: --
682: when hr_api.cannot_find_prog_unit then
683: --
684: hr_api.cannot_find_prog_unit_error
685: (p_module_name => 'GHR_COMPLAINTS2'
686: ,p_hook_type => 'AI');
687: --
688: end;