68: --
69: hr_utility.set_location(' Leaving:'||l_proc, 10);
70: --
71: Exception
72: When hr_api.child_integrity_violated then
73: -- Child integrity has been violated
74: irc_ias_shd.g_api_dml := false; -- Unset the dml status
75: --
76: irc_ias_shd.constraint_error
73: -- Child integrity has been violated
74: irc_ias_shd.g_api_dml := false; -- Unset the dml status
75: --
76: irc_ias_shd.constraint_error
77: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
78: When Others Then
79: --
80: irc_ias_shd.g_api_dml := false; -- Unset the dml status
81: Raise;
179: );
180: --
181: exception
182: --
183: when hr_api.cannot_find_prog_unit then
184: --
185: hr_api.cannot_find_prog_unit_error
186: (p_module_name => 'IRC_ASSIGNMENT_STATUSES'
187: ,p_hook_type => 'AD');
181: exception
182: --
183: when hr_api.cannot_find_prog_unit then
184: --
185: hr_api.cannot_find_prog_unit_error
186: (p_module_name => 'IRC_ASSIGNMENT_STATUSES'
187: ,p_hook_type => 'AD');
188: --
189: end;