240: irc_ipc_shd.g_api_dml := false; -- Unset the api dml status
241: --
242: hr_utility.set_location(' Leaving:'||l_proc, 10);
243: Exception
244: When hr_api.check_integrity_violated Then
245: -- A check constraint has been violated
246: irc_ipc_shd.g_api_dml := false; -- Unset the api dml status
247: --
248: irc_ipc_shd.constraint_error
245: -- A check constraint has been violated
246: irc_ipc_shd.g_api_dml := false; -- Unset the api dml status
247: --
248: irc_ipc_shd.constraint_error
249: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
250: When hr_api.parent_integrity_violated Then
251: -- Parent integrity has been violated
252: irc_ipc_shd.g_api_dml := false; -- Unset the api dml status
253: --
246: irc_ipc_shd.g_api_dml := false; -- Unset the api dml status
247: --
248: irc_ipc_shd.constraint_error
249: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
250: When hr_api.parent_integrity_violated Then
251: -- Parent integrity has been violated
252: irc_ipc_shd.g_api_dml := false; -- Unset the api dml status
253: --
254: irc_ipc_shd.constraint_error
251: -- Parent integrity has been violated
252: irc_ipc_shd.g_api_dml := false; -- Unset the api dml status
253: --
254: irc_ipc_shd.constraint_error
255: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
256: When hr_api.unique_integrity_violated Then
257: -- Unique integrity has been violated
258: irc_ipc_shd.g_api_dml := false; -- Unset the api dml status
259: --
252: irc_ipc_shd.g_api_dml := false; -- Unset the api dml status
253: --
254: irc_ipc_shd.constraint_error
255: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
256: When hr_api.unique_integrity_violated Then
257: -- Unique integrity has been violated
258: irc_ipc_shd.g_api_dml := false; -- Unset the api dml status
259: --
260: irc_ipc_shd.constraint_error
257: -- Unique integrity has been violated
258: irc_ipc_shd.g_api_dml := false; -- Unset the api dml status
259: --
260: irc_ipc_shd.constraint_error
261: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
262: When Others Then
263: irc_ipc_shd.g_api_dml := false; -- Unset the api dml status
264: --
265: Raise;
549: );
550: --
551: exception
552: --
553: when hr_api.cannot_find_prog_unit then
554: --
555: hr_api.cannot_find_prog_unit_error
556: (p_module_name => 'IRC_POSTING_CONTENTS'
557: ,p_hook_type => 'AI');
551: exception
552: --
553: when hr_api.cannot_find_prog_unit then
554: --
555: hr_api.cannot_find_prog_unit_error
556: (p_module_name => 'IRC_POSTING_CONTENTS'
557: ,p_hook_type => 'AI');
558: --
559: end;