178: --
179: --
180: hr_utility.set_location(' Leaving:'||l_proc, 10);
181: Exception
182: When hr_api.check_integrity_violated Then
183: -- A check constraint has been violated
184: --
185: pqh_rmv_shd.constraint_error
186: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
182: When hr_api.check_integrity_violated Then
183: -- A check constraint has been violated
184: --
185: pqh_rmv_shd.constraint_error
186: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
187: When hr_api.parent_integrity_violated Then
188: -- Parent integrity has been violated
189: --
190: pqh_rmv_shd.constraint_error
183: -- A check constraint has been violated
184: --
185: pqh_rmv_shd.constraint_error
186: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
187: When hr_api.parent_integrity_violated Then
188: -- Parent integrity has been violated
189: --
190: pqh_rmv_shd.constraint_error
191: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
187: When hr_api.parent_integrity_violated Then
188: -- Parent integrity has been violated
189: --
190: pqh_rmv_shd.constraint_error
191: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
192: When hr_api.unique_integrity_violated Then
193: -- Unique integrity has been violated
194: --
195: pqh_rmv_shd.constraint_error
188: -- Parent integrity has been violated
189: --
190: pqh_rmv_shd.constraint_error
191: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
192: When hr_api.unique_integrity_violated Then
193: -- Unique integrity has been violated
194: --
195: pqh_rmv_shd.constraint_error
196: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
192: When hr_api.unique_integrity_violated Then
193: -- Unique integrity has been violated
194: --
195: pqh_rmv_shd.constraint_error
196: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
197: When Others Then
198: --
199: Raise;
200: End insert_dml;
379: );
380: --
381: exception
382: --
383: when hr_api.cannot_find_prog_unit then
384: --
385: hr_api.cannot_find_prog_unit_error
386: (p_module_name => 'PQH_RT_MATRIX_NODE_VALUES'
387: ,p_hook_type => 'AI');
381: exception
382: --
383: when hr_api.cannot_find_prog_unit then
384: --
385: hr_api.cannot_find_prog_unit_error
386: (p_module_name => 'PQH_RT_MATRIX_NODE_VALUES'
387: ,p_hook_type => 'AI');
388: --
389: end;