129: hr_utility.set_location(' Leaving:'||l_proc, 10);
130: end if;
131:
132: exception
133: when hr_api.check_integrity_violated then
134: -- a check constraint has been violated
135: hxc_tbb_shd.constraint_error
136: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
137: when hr_api.parent_integrity_violated then
132: exception
133: when hr_api.check_integrity_violated then
134: -- a check constraint has been violated
135: hxc_tbb_shd.constraint_error
136: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
137: when hr_api.parent_integrity_violated then
138: -- Parent integrity has been violated
139: hxc_tbb_shd.constraint_error
140: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
133: when hr_api.check_integrity_violated then
134: -- a check constraint has been violated
135: hxc_tbb_shd.constraint_error
136: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
137: when hr_api.parent_integrity_violated then
138: -- Parent integrity has been violated
139: hxc_tbb_shd.constraint_error
140: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
141: when hr_api.unique_integrity_violated then
136: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
137: when hr_api.parent_integrity_violated then
138: -- Parent integrity has been violated
139: hxc_tbb_shd.constraint_error
140: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
141: when hr_api.unique_integrity_violated then
142: -- Unique integrity has been violated
143: hxc_tbb_shd.constraint_error
144: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
137: when hr_api.parent_integrity_violated then
138: -- Parent integrity has been violated
139: hxc_tbb_shd.constraint_error
140: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
141: when hr_api.unique_integrity_violated then
142: -- Unique integrity has been violated
143: hxc_tbb_shd.constraint_error
144: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
145: when others then
140: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
141: when hr_api.unique_integrity_violated then
142: -- Unique integrity has been violated
143: hxc_tbb_shd.constraint_error
144: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
145: when others then
146: raise;
147: end insert_dml;
148:
303: =>p_application_set_id
304: );
305: */null;
306: exception
307: when hr_api.cannot_find_prog_unit then
308: hr_api.cannot_find_prog_unit_error
309: (p_module_name => 'HXC_TIME_BUILDING_BLOCKS'
310: ,p_hook_type => 'AI');
311:
304: );
305: */null;
306: exception
307: when hr_api.cannot_find_prog_unit then
308: hr_api.cannot_find_prog_unit_error
309: (p_module_name => 'HXC_TIME_BUILDING_BLOCKS'
310: ,p_hook_type => 'AI');
311:
312: end;