261: hr_loc_shd.g_api_dml := false; -- Unset the api dml status
262: --
263: hr_utility.set_location(' Leaving:'||l_proc, 10);
264: EXCEPTION
265: WHEN hr_api.check_integrity_violated THEN
266: -- A check constraint has been violated
267: hr_loc_shd.g_api_dml := false; -- Unset the api dml status
268: hr_loc_shd.constraint_error
269: (p_constraint_name => hr_api.strip_constraint_name(sqlerrm));
265: WHEN hr_api.check_integrity_violated THEN
266: -- A check constraint has been violated
267: hr_loc_shd.g_api_dml := false; -- Unset the api dml status
268: hr_loc_shd.constraint_error
269: (p_constraint_name => hr_api.strip_constraint_name(sqlerrm));
270: WHEN hr_api.parent_integrity_violated THEN
271: -- Parent integrity has been violated
272: hr_loc_shd.g_api_dml := false; -- Unset the api dml status
273: hr_loc_shd.constraint_error
266: -- A check constraint has been violated
267: hr_loc_shd.g_api_dml := false; -- Unset the api dml status
268: hr_loc_shd.constraint_error
269: (p_constraint_name => hr_api.strip_constraint_name(sqlerrm));
270: WHEN hr_api.parent_integrity_violated THEN
271: -- Parent integrity has been violated
272: hr_loc_shd.g_api_dml := false; -- Unset the api dml status
273: hr_loc_shd.constraint_error
274: (p_constraint_name => hr_api.strip_constraint_name(sqlerrm));
270: WHEN hr_api.parent_integrity_violated THEN
271: -- Parent integrity has been violated
272: hr_loc_shd.g_api_dml := false; -- Unset the api dml status
273: hr_loc_shd.constraint_error
274: (p_constraint_name => hr_api.strip_constraint_name(sqlerrm));
275: WHEN hr_api.unique_integrity_violated THEN
276: -- Unique integrity has been violated
277: hr_loc_shd.g_api_dml := false; -- Unset the api dml status
278: hr_loc_shd.constraint_error
271: -- Parent integrity has been violated
272: hr_loc_shd.g_api_dml := false; -- Unset the api dml status
273: hr_loc_shd.constraint_error
274: (p_constraint_name => hr_api.strip_constraint_name(sqlerrm));
275: WHEN hr_api.unique_integrity_violated THEN
276: -- Unique integrity has been violated
277: hr_loc_shd.g_api_dml := false; -- Unset the api dml status
278: hr_loc_shd.constraint_error
279: (p_constraint_name => hr_api.strip_constraint_name(sqlerrm));
275: WHEN hr_api.unique_integrity_violated THEN
276: -- Unique integrity has been violated
277: hr_loc_shd.g_api_dml := false; -- Unset the api dml status
278: hr_loc_shd.constraint_error
279: (p_constraint_name => hr_api.strip_constraint_name(sqlerrm));
280: WHEN OTHERS THEN
281: hr_loc_shd.g_api_dml := false; -- Unset the api dml status
282: RAISE;
283: END insert_dml;
518: ,p_object_version_number => p_rec.object_version_number
519: ,p_business_group_id => p_rec.business_group_id
520: );
521: EXCEPTION
522: WHEN hr_api.cannot_find_prog_unit THEN
523: hr_api.cannot_find_prog_unit_error
524: (p_module_name => 'HR_LOCATIONS_ALL'
525: ,p_hook_type => 'AI'
526: );
519: ,p_business_group_id => p_rec.business_group_id
520: );
521: EXCEPTION
522: WHEN hr_api.cannot_find_prog_unit THEN
523: hr_api.cannot_find_prog_unit_error
524: (p_module_name => 'HR_LOCATIONS_ALL'
525: ,p_hook_type => 'AI'
526: );
527: --