100: --
101: --
102: hr_utility.set_location(' Leaving:'||l_proc, 10);
103: Exception
104: When hr_api.check_integrity_violated Then
105: -- A check constraint has been violated
106: --
107: pqh_rha_shd.constraint_error
108: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
104: When hr_api.check_integrity_violated Then
105: -- A check constraint has been violated
106: --
107: pqh_rha_shd.constraint_error
108: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
109: When hr_api.parent_integrity_violated Then
110: -- Parent integrity has been violated
111: --
112: pqh_rha_shd.constraint_error
105: -- A check constraint has been violated
106: --
107: pqh_rha_shd.constraint_error
108: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
109: When hr_api.parent_integrity_violated Then
110: -- Parent integrity has been violated
111: --
112: pqh_rha_shd.constraint_error
113: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
109: When hr_api.parent_integrity_violated Then
110: -- Parent integrity has been violated
111: --
112: pqh_rha_shd.constraint_error
113: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
114: When hr_api.unique_integrity_violated Then
115: -- Unique integrity has been violated
116: --
117: pqh_rha_shd.constraint_error
110: -- Parent integrity has been violated
111: --
112: pqh_rha_shd.constraint_error
113: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
114: When hr_api.unique_integrity_violated Then
115: -- Unique integrity has been violated
116: --
117: pqh_rha_shd.constraint_error
118: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
114: When hr_api.unique_integrity_violated Then
115: -- Unique integrity has been violated
116: --
117: pqh_rha_shd.constraint_error
118: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
119: When Others Then
120: --
121: Raise;
122: End insert_dml;
255: );
256: --
257: exception
258: --
259: when hr_api.cannot_find_prog_unit then
260: --
261: hr_api.cannot_find_prog_unit_error
262: (p_module_name => 'PQH_ROUTING_HIST_ATTRIBS'
263: ,p_hook_type => 'AI');
257: exception
258: --
259: when hr_api.cannot_find_prog_unit then
260: --
261: hr_api.cannot_find_prog_unit_error
262: (p_module_name => 'PQH_ROUTING_HIST_ATTRIBS'
263: ,p_hook_type => 'AI');
264: --
265: end;