128: end if;
129: --
130: hr_utility.set_location(' Leaving:'||l_proc, 20);
131: Exception
132: When hr_api.check_integrity_violated Then
133: -- A check constraint has been violated
134: pqh_fyn_shd.constraint_error
135: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
136: When hr_api.parent_integrity_violated Then
131: Exception
132: When hr_api.check_integrity_violated Then
133: -- A check constraint has been violated
134: pqh_fyn_shd.constraint_error
135: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
136: When hr_api.parent_integrity_violated Then
137: -- Parent integrity has been violated
138: pqh_fyn_shd.constraint_error
139: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
132: When hr_api.check_integrity_violated Then
133: -- A check constraint has been violated
134: pqh_fyn_shd.constraint_error
135: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
136: When hr_api.parent_integrity_violated Then
137: -- Parent integrity has been violated
138: pqh_fyn_shd.constraint_error
139: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
140: When hr_api.unique_integrity_violated Then
135: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
136: When hr_api.parent_integrity_violated Then
137: -- Parent integrity has been violated
138: pqh_fyn_shd.constraint_error
139: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
140: When hr_api.unique_integrity_violated Then
141: -- Unique integrity has been violated
142: pqh_fyn_shd.constraint_error
143: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
136: When hr_api.parent_integrity_violated Then
137: -- Parent integrity has been violated
138: pqh_fyn_shd.constraint_error
139: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
140: When hr_api.unique_integrity_violated Then
141: -- Unique integrity has been violated
142: pqh_fyn_shd.constraint_error
143: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
144: When Others Then
139: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
140: When hr_api.unique_integrity_violated Then
141: -- Unique integrity has been violated
142: pqh_fyn_shd.constraint_error
143: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
144: When Others Then
145: Raise;
146: End insert_dml;
147: --
261: );
262: --
263: exception
264: --
265: when hr_api.cannot_find_prog_unit then
266: --
267: hr_api.cannot_find_prog_unit_error
268: (p_module_name => 'pqh_fyi_notify'
269: ,p_hook_type => 'AI');
263: exception
264: --
265: when hr_api.cannot_find_prog_unit then
266: --
267: hr_api.cannot_find_prog_unit_error
268: (p_module_name => 'pqh_fyi_notify'
269: ,p_hook_type => 'AI');
270: --
271: end;