DBA Data[Home] [Help]

APPS.PER_VAC_INS dependencies on HR_API

Line 200: When hr_api.check_integrity_violated then

196: per_vac_shd.g_api_dml := false; -- Unset the api dml status
197: --
198: hr_utility.set_location(' Leaving:'||l_proc, 10);
199: Exception
200: When hr_api.check_integrity_violated then
201: -- A check constraint has been violated
202: per_vac_shd.g_api_dml := false; -- Unset the api dml status
203: per_vac_shd.constraint_error
204: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 204: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

200: When hr_api.check_integrity_violated then
201: -- A check constraint has been violated
202: per_vac_shd.g_api_dml := false; -- Unset the api dml status
203: per_vac_shd.constraint_error
204: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
205: When hr_api.parent_integrity_violated then
206: -- Parent integrity has been violated
207: per_vac_shd.g_api_dml := false; -- Unset the api dml status
208: per_vac_shd.constraint_error

Line 205: When hr_api.parent_integrity_violated then

201: -- A check constraint has been violated
202: per_vac_shd.g_api_dml := false; -- Unset the api dml status
203: per_vac_shd.constraint_error
204: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
205: When hr_api.parent_integrity_violated then
206: -- Parent integrity has been violated
207: per_vac_shd.g_api_dml := false; -- Unset the api dml status
208: per_vac_shd.constraint_error
209: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 209: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

205: When hr_api.parent_integrity_violated then
206: -- Parent integrity has been violated
207: per_vac_shd.g_api_dml := false; -- Unset the api dml status
208: per_vac_shd.constraint_error
209: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
210: When hr_api.unique_integrity_violated then
211: -- Unique integrity has been violated
212: per_vac_shd.g_api_dml := false; -- Unset the api dml status
213: per_vac_shd.constraint_error

Line 210: When hr_api.unique_integrity_violated then

206: -- Parent integrity has been violated
207: per_vac_shd.g_api_dml := false; -- Unset the api dml status
208: per_vac_shd.constraint_error
209: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
210: When hr_api.unique_integrity_violated then
211: -- Unique integrity has been violated
212: per_vac_shd.g_api_dml := false; -- Unset the api dml status
213: per_vac_shd.constraint_error
214: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 214: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

210: When hr_api.unique_integrity_violated then
211: -- Unique integrity has been violated
212: per_vac_shd.g_api_dml := false; -- Unset the api dml status
213: per_vac_shd.constraint_error
214: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
215: When Others then
216: per_vac_shd.g_api_dml := false; -- Unset the api dml status
217: Raise;
218: End insert_dml;

Line 465: when hr_api.cannot_find_prog_unit then

461: );
462: --
463: exception
464: --
465: when hr_api.cannot_find_prog_unit then
466: --
467: hr_api.cannot_find_prog_unit_error
468: (p_module_name => 'PER_ALL_VACANCIES'
469: ,p_hook_type => 'AI');

Line 467: hr_api.cannot_find_prog_unit_error

463: exception
464: --
465: when hr_api.cannot_find_prog_unit then
466: --
467: hr_api.cannot_find_prog_unit_error
468: (p_module_name => 'PER_ALL_VACANCIES'
469: ,p_hook_type => 'AI');
470: --
471: end;