182: --
183: --
184: hr_utility.set_location(' Leaving:'||l_proc, 10);
185: Exception
186: When hr_api.check_integrity_violated Then
187: -- A check constraint has been violated
188: --
189: pay_bld_shd.constraint_error
190: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
186: When hr_api.check_integrity_violated Then
187: -- A check constraint has been violated
188: --
189: pay_bld_shd.constraint_error
190: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
191: When hr_api.parent_integrity_violated Then
192: -- Parent integrity has been violated
193: --
194: pay_bld_shd.constraint_error
187: -- A check constraint has been violated
188: --
189: pay_bld_shd.constraint_error
190: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
191: When hr_api.parent_integrity_violated Then
192: -- Parent integrity has been violated
193: --
194: pay_bld_shd.constraint_error
195: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
191: When hr_api.parent_integrity_violated Then
192: -- Parent integrity has been violated
193: --
194: pay_bld_shd.constraint_error
195: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
196: When hr_api.unique_integrity_violated Then
197: -- Unique integrity has been violated
198: --
199: pay_bld_shd.constraint_error
192: -- Parent integrity has been violated
193: --
194: pay_bld_shd.constraint_error
195: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
196: When hr_api.unique_integrity_violated Then
197: -- Unique integrity has been violated
198: --
199: pay_bld_shd.constraint_error
200: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
196: When hr_api.unique_integrity_violated Then
197: -- Unique integrity has been violated
198: --
199: pay_bld_shd.constraint_error
200: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
201: When Others Then
202: --
203: Raise;
204: End insert_dml;
387: );
388: --
389: exception
390: --
391: when hr_api.cannot_find_prog_unit then
392: --
393: hr_api.cannot_find_prog_unit_error
394: (p_module_name => 'PAY_BALANCE_DIMENSIONS'
395: ,p_hook_type => 'AI');
389: exception
390: --
391: when hr_api.cannot_find_prog_unit then
392: --
393: hr_api.cannot_find_prog_unit_error
394: (p_module_name => 'PAY_BALANCE_DIMENSIONS'
395: ,p_hook_type => 'AI');
396: --
397: end;