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: --
76: irc_irt_shd.constraint_error
77: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
73: When hr_api.child_integrity_violated then
74: -- Child integrity has been violated
75: --
76: irc_irt_shd.constraint_error
77: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
78: When Others Then
79: --
80: Raise;
81: End delete_dml;
178: );
179: --
180: exception
181: --
182: when hr_api.cannot_find_prog_unit then
183: --
184: hr_api.cannot_find_prog_unit_error
185: (p_module_name => 'IRC_ALL_RECRUITING_SITES_TL'
186: ,p_hook_type => 'AD');
180: exception
181: --
182: when hr_api.cannot_find_prog_unit then
183: --
184: hr_api.cannot_find_prog_unit_error
185: (p_module_name => 'IRC_ALL_RECRUITING_SITES_TL'
186: ,p_hook_type => 'AD');
187: --
188: end;