172: irc_ilp_shd.g_api_dml := false; -- Unset the api dml status
173: --
174: hr_utility.set_location(' Leaving:'||l_proc, 10);
175: Exception
176: When hr_api.check_integrity_violated Then
177: -- A check constraint has been violated
178: irc_ilp_shd.g_api_dml := false; -- Unset the api dml status
179: irc_ilp_shd.constraint_error
180: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
176: When hr_api.check_integrity_violated Then
177: -- A check constraint has been violated
178: irc_ilp_shd.g_api_dml := false; -- Unset the api dml status
179: irc_ilp_shd.constraint_error
180: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
181: When hr_api.parent_integrity_violated Then
182: -- Parent integrity has been violated
183: irc_ilp_shd.g_api_dml := false; -- Unset the api dml status
184: irc_ilp_shd.constraint_error
177: -- A check constraint has been violated
178: irc_ilp_shd.g_api_dml := false; -- Unset the api dml status
179: irc_ilp_shd.constraint_error
180: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
181: When hr_api.parent_integrity_violated Then
182: -- Parent integrity has been violated
183: irc_ilp_shd.g_api_dml := false; -- Unset the api dml status
184: irc_ilp_shd.constraint_error
185: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
181: When hr_api.parent_integrity_violated Then
182: -- Parent integrity has been violated
183: irc_ilp_shd.g_api_dml := false; -- Unset the api dml status
184: irc_ilp_shd.constraint_error
185: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
186: When hr_api.unique_integrity_violated Then
187: -- Unique integrity has been violated
188: irc_ilp_shd.g_api_dml := false; -- Unset the api dml status
189: irc_ilp_shd.constraint_error
182: -- Parent integrity has been violated
183: irc_ilp_shd.g_api_dml := false; -- Unset the api dml status
184: irc_ilp_shd.constraint_error
185: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
186: When hr_api.unique_integrity_violated Then
187: -- Unique integrity has been violated
188: irc_ilp_shd.g_api_dml := false; -- Unset the api dml status
189: irc_ilp_shd.constraint_error
190: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
186: When hr_api.unique_integrity_violated Then
187: -- Unique integrity has been violated
188: irc_ilp_shd.g_api_dml := false; -- Unset the api dml status
189: irc_ilp_shd.constraint_error
190: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
191: When Others Then
192: irc_ilp_shd.g_api_dml := false; -- Unset the api dml status
193: Raise;
194: End insert_dml;
411: );
412: --
413: exception
414: --
415: when hr_api.cannot_find_prog_unit then
416: --
417: hr_api.cannot_find_prog_unit_error
418: (p_module_name => 'IRC_LOCATION_PREFERENCES'
419: ,p_hook_type => 'AI');
413: exception
414: --
415: when hr_api.cannot_find_prog_unit then
416: --
417: hr_api.cannot_find_prog_unit_error
418: (p_module_name => 'IRC_LOCATION_PREFERENCES'
419: ,p_hook_type => 'AI');
420: --
421: end;