290: --
291: --
292: hr_utility.set_location(' Leaving:'||l_proc, 10);
293: Exception
294: When hr_api.check_integrity_violated Then
295: -- A check constraint has been violated
296: --
297: pay_prf_shd.constraint_error
298: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
294: When hr_api.check_integrity_violated Then
295: -- A check constraint has been violated
296: --
297: pay_prf_shd.constraint_error
298: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
299: When hr_api.parent_integrity_violated Then
300: -- Parent integrity has been violated
301: --
302: pay_prf_shd.constraint_error
295: -- A check constraint has been violated
296: --
297: pay_prf_shd.constraint_error
298: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
299: When hr_api.parent_integrity_violated Then
300: -- Parent integrity has been violated
301: --
302: pay_prf_shd.constraint_error
303: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
299: When hr_api.parent_integrity_violated Then
300: -- Parent integrity has been violated
301: --
302: pay_prf_shd.constraint_error
303: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
304: When hr_api.unique_integrity_violated Then
305: -- Unique integrity has been violated
306: --
307: pay_prf_shd.constraint_error
300: -- Parent integrity has been violated
301: --
302: pay_prf_shd.constraint_error
303: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
304: When hr_api.unique_integrity_violated Then
305: -- Unique integrity has been violated
306: --
307: pay_prf_shd.constraint_error
308: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
304: When hr_api.unique_integrity_violated Then
305: -- Unique integrity has been violated
306: --
307: pay_prf_shd.constraint_error
308: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
309: When Others Then
310: --
311: Raise;
312: End insert_dml;
603: );
604: --
605: exception
606: --
607: when hr_api.cannot_find_prog_unit then
608: --
609: hr_api.cannot_find_prog_unit_error
610: (p_module_name => 'PAY_RANGE_TABLES_F'
611: ,p_hook_type => 'AI');
605: exception
606: --
607: when hr_api.cannot_find_prog_unit then
608: --
609: hr_api.cannot_find_prog_unit_error
610: (p_module_name => 'PAY_RANGE_TABLES_F'
611: ,p_hook_type => 'AI');
612: --
613: end;