186: --
187: irc_rse_shd.g_api_dml := false; -- Unset the api dml status
188: hr_utility.set_location(' Leaving:'||l_proc, 10);
189: Exception
190: When hr_api.check_integrity_violated Then
191: -- A check constraint has been violated
192: irc_rse_shd.g_api_dml := false; -- Unset the api dml status
193: --
194: irc_rse_shd.constraint_error
191: -- A check constraint has been violated
192: irc_rse_shd.g_api_dml := false; -- Unset the api dml status
193: --
194: irc_rse_shd.constraint_error
195: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
196: When hr_api.parent_integrity_violated Then
197: -- Parent integrity has been violated
198: irc_rse_shd.g_api_dml := false; -- Unset the api dml status
199: --
192: irc_rse_shd.g_api_dml := false; -- Unset the api dml status
193: --
194: irc_rse_shd.constraint_error
195: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
196: When hr_api.parent_integrity_violated Then
197: -- Parent integrity has been violated
198: irc_rse_shd.g_api_dml := false; -- Unset the api dml status
199: --
200: irc_rse_shd.constraint_error
197: -- Parent integrity has been violated
198: irc_rse_shd.g_api_dml := false; -- Unset the api dml status
199: --
200: irc_rse_shd.constraint_error
201: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
202: When hr_api.unique_integrity_violated Then
203: -- Unique integrity has been violated
204: irc_rse_shd.g_api_dml := false; -- Unset the api dml status
205: --
198: irc_rse_shd.g_api_dml := false; -- Unset the api dml status
199: --
200: irc_rse_shd.constraint_error
201: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
202: When hr_api.unique_integrity_violated Then
203: -- Unique integrity has been violated
204: irc_rse_shd.g_api_dml := false; -- Unset the api dml status
205: --
206: irc_rse_shd.constraint_error
203: -- Unique integrity has been violated
204: irc_rse_shd.g_api_dml := false; -- Unset the api dml status
205: --
206: irc_rse_shd.constraint_error
207: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
208: When Others Then
209: irc_rse_shd.g_api_dml := false; -- Unset the api dml status
210: --
211: Raise;
443: );
444: --
445: exception
446: --
447: when hr_api.cannot_find_prog_unit then
448: --
449: hr_api.cannot_find_prog_unit_error
450: (p_module_name => 'IRC_ALL_RECRUITING_SITES'
451: ,p_hook_type => 'AI');
445: exception
446: --
447: when hr_api.cannot_find_prog_unit then
448: --
449: hr_api.cannot_find_prog_unit_error
450: (p_module_name => 'IRC_ALL_RECRUITING_SITES'
451: ,p_hook_type => 'AI');
452: --
453: end;