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