69: --
70: hr_utility.set_location(' Leaving:'||l_proc, 10);
71: --
72: Exception
73: When hr_api.child_integrity_violated then
74: -- Child integrity has been violated
75: irc_vce_shd.g_api_dml := false; -- Unset the api dml status
76: --
77: irc_vce_shd.constraint_error
74: -- Child integrity has been violated
75: irc_vce_shd.g_api_dml := false; -- Unset the api dml status
76: --
77: irc_vce_shd.constraint_error
78: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
79: When Others Then
80: --
81: irc_vce_shd.g_api_dml := false; -- Unset the api dml status
82: Raise;
174: );
175: --
176: exception
177: --
178: when hr_api.cannot_find_prog_unit then
179: --
180: hr_api.cannot_find_prog_unit_error
181: (p_module_name => 'IRC_VARIABLE_COMP_ELEMENTS'
182: ,p_hook_type => 'AD');
176: exception
177: --
178: when hr_api.cannot_find_prog_unit then
179: --
180: hr_api.cannot_find_prog_unit_error
181: (p_module_name => 'IRC_VARIABLE_COMP_ELEMENTS'
182: ,p_hook_type => 'AD');
183: --
184: end;