DBA Data[Home] [Help]

APPS.HR_LOC_INS dependencies on HR_API

Line 267: WHEN hr_api.check_integrity_violated THEN

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));

Line 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

Line 272: WHEN hr_api.parent_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
276: (p_constraint_name => hr_api.strip_constraint_name(sqlerrm));

Line 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

Line 277: WHEN hr_api.unique_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
281: (p_constraint_name => hr_api.strip_constraint_name(sqlerrm));

Line 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;

Line 524: WHEN hr_api.cannot_find_prog_unit THEN

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: );

Line 525: hr_api.cannot_find_prog_unit_error

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: --