300: irc_isc_shd.g_api_dml := false; -- Unset the api dml status
301: --
302: hr_utility.set_location(' Leaving:'||l_proc, 20);
303: Exception
304: When hr_api.check_integrity_violated Then
305: -- A check constraint has been violated
306: irc_isc_shd.g_api_dml := false; -- Unset the api dml status
307: --
308: irc_isc_shd.constraint_error
305: -- A check constraint has been violated
306: irc_isc_shd.g_api_dml := false; -- Unset the api dml status
307: --
308: irc_isc_shd.constraint_error
309: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
310: When hr_api.parent_integrity_violated Then
311: -- Parent integrity has been violated
312: irc_isc_shd.g_api_dml := false; -- Unset the api dml status
313: --
306: irc_isc_shd.g_api_dml := false; -- Unset the api dml status
307: --
308: irc_isc_shd.constraint_error
309: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
310: When hr_api.parent_integrity_violated Then
311: -- Parent integrity has been violated
312: irc_isc_shd.g_api_dml := false; -- Unset the api dml status
313: --
314: irc_isc_shd.constraint_error
311: -- Parent integrity has been violated
312: irc_isc_shd.g_api_dml := false; -- Unset the api dml status
313: --
314: irc_isc_shd.constraint_error
315: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
316: When hr_api.unique_integrity_violated Then
317: -- Unique integrity has been violated
318: irc_isc_shd.g_api_dml := false; -- Unset the api dml status
319: --
312: irc_isc_shd.g_api_dml := false; -- Unset the api dml status
313: --
314: irc_isc_shd.constraint_error
315: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
316: When hr_api.unique_integrity_violated Then
317: -- Unique integrity has been violated
318: irc_isc_shd.g_api_dml := false; -- Unset the api dml status
319: --
320: irc_isc_shd.constraint_error
317: -- Unique integrity has been violated
318: irc_isc_shd.g_api_dml := false; -- Unset the api dml status
319: --
320: irc_isc_shd.constraint_error
321: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
322: When Others Then
323: irc_isc_shd.g_api_dml := false; -- Unset the api dml status
324: --
325: Raise;
657: );
658: --
659: exception
660: --
661: when hr_api.cannot_find_prog_unit then
662: --
663: hr_api.cannot_find_prog_unit_error
664: (p_module_name => 'IRC_SEARCH_CRITERIA'
665: ,p_hook_type => 'AI');
659: exception
660: --
661: when hr_api.cannot_find_prog_unit then
662: --
663: hr_api.cannot_find_prog_unit_error
664: (p_module_name => 'IRC_SEARCH_CRITERIA'
665: ,p_hook_type => 'AI');
666: --
667: end;