139: --
140: hr_utility.set_location(' Leaving:'||l_proc, 10);
141: hr_utility.set_location(' Num:'|| to_char(num), 20);
142: Exception
143: When hr_api.check_integrity_violated Then
144: -- A check constraint has been violated
145: --
146: pay_txr_shd.constraint_error
147: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
143: When hr_api.check_integrity_violated Then
144: -- A check constraint has been violated
145: --
146: pay_txr_shd.constraint_error
147: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
148: When hr_api.parent_integrity_violated Then
149: -- Parent integrity has been violated
150: --
151: pay_txr_shd.constraint_error
144: -- A check constraint has been violated
145: --
146: pay_txr_shd.constraint_error
147: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
148: When hr_api.parent_integrity_violated Then
149: -- Parent integrity has been violated
150: --
151: pay_txr_shd.constraint_error
152: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
148: When hr_api.parent_integrity_violated Then
149: -- Parent integrity has been violated
150: --
151: pay_txr_shd.constraint_error
152: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
153: When hr_api.unique_integrity_violated Then
154: -- Unique integrity has been violated
155: --
156: pay_txr_shd.constraint_error
149: -- Parent integrity has been violated
150: --
151: pay_txr_shd.constraint_error
152: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
153: When hr_api.unique_integrity_violated Then
154: -- Unique integrity has been violated
155: --
156: pay_txr_shd.constraint_error
157: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
153: When hr_api.unique_integrity_violated Then
154: -- Unique integrity has been violated
155: --
156: pay_txr_shd.constraint_error
157: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
158: When Others Then
159: --
160: hr_utility.trace('Exception in '||SQLERRM);
161: Raise;
444: );
445: --
446: exception
447: --
448: when hr_api.cannot_find_prog_unit then
449: --
450: hr_api.cannot_find_prog_unit_error
451: (p_module_name => 'PAY_TAXABILITY_RULES'
452: ,p_hook_type => 'AI');
446: exception
447: --
448: when hr_api.cannot_find_prog_unit then
449: --
450: hr_api.cannot_find_prog_unit_error
451: (p_module_name => 'PAY_TAXABILITY_RULES'
452: ,p_hook_type => 'AI');
453: --
454: end;