198: --
199: --
200: hr_utility.set_location(' leaving:'||l_proc, 10);
201: exception
202: when hr_api.check_integrity_violated then
203: -- a check constraint has been violated
204: --
205: irc_iof_shd.constraint_error
206: (p_constraint_name => hr_api.strip_constraint_name(sqlerrm));
202: when hr_api.check_integrity_violated then
203: -- a check constraint has been violated
204: --
205: irc_iof_shd.constraint_error
206: (p_constraint_name => hr_api.strip_constraint_name(sqlerrm));
207: when hr_api.parent_integrity_violated then
208: -- parent integrity has been violated
209: --
210: irc_iof_shd.constraint_error
203: -- a check constraint has been violated
204: --
205: irc_iof_shd.constraint_error
206: (p_constraint_name => hr_api.strip_constraint_name(sqlerrm));
207: when hr_api.parent_integrity_violated then
208: -- parent integrity has been violated
209: --
210: irc_iof_shd.constraint_error
211: (p_constraint_name => hr_api.strip_constraint_name(sqlerrm));
207: when hr_api.parent_integrity_violated then
208: -- parent integrity has been violated
209: --
210: irc_iof_shd.constraint_error
211: (p_constraint_name => hr_api.strip_constraint_name(sqlerrm));
212: when hr_api.unique_integrity_violated then
213: -- unique integrity has been violated
214: --
215: irc_iof_shd.constraint_error
208: -- parent integrity has been violated
209: --
210: irc_iof_shd.constraint_error
211: (p_constraint_name => hr_api.strip_constraint_name(sqlerrm));
212: when hr_api.unique_integrity_violated then
213: -- unique integrity has been violated
214: --
215: irc_iof_shd.constraint_error
216: (p_constraint_name => hr_api.strip_constraint_name(sqlerrm));
212: when hr_api.unique_integrity_violated then
213: -- unique integrity has been violated
214: --
215: irc_iof_shd.constraint_error
216: (p_constraint_name => hr_api.strip_constraint_name(sqlerrm));
217: when others then
218: --
219: raise;
220: end insert_dml;
461: );
462: --
463: exception
464: --
465: when hr_api.cannot_find_prog_unit then
466: --
467: hr_api.cannot_find_prog_unit_error
468: (p_module_name => 'irc_offers'
469: ,p_hook_type => 'ai');
463: exception
464: --
465: when hr_api.cannot_find_prog_unit then
466: --
467: hr_api.cannot_find_prog_unit_error
468: (p_module_name => 'irc_offers'
469: ,p_hook_type => 'ai');
470: --
471: end;