DBA Data[Home] [Help]

APPS.HR_LOC_INS dependencies on HR_API

Line 265: WHEN hr_api.check_integrity_violated THEN

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

Line 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

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

Line 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

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

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

Line 522: WHEN hr_api.cannot_find_prog_unit THEN

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

Line 523: hr_api.cannot_find_prog_unit_error

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