DBA Data[Home] [Help]

APPS.PQP_EXR_INS dependencies on HR_API

Line 201: When hr_api.check_integrity_violated Then

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

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

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

Line 206: When hr_api.parent_integrity_violated Then

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

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

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

Line 211: When hr_api.unique_integrity_violated Then

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

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

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

Line 358: when hr_api.cannot_find_prog_unit then

354: );
355: --
356: exception
357: --
358: when hr_api.cannot_find_prog_unit then
359: --
360: hr_api.cannot_find_prog_unit_error
361: (p_module_name => 'PQP_EXCEPTION_REPORTS'
362: ,p_hook_type => 'AI');

Line 360: hr_api.cannot_find_prog_unit_error

356: exception
357: --
358: when hr_api.cannot_find_prog_unit then
359: --
360: hr_api.cannot_find_prog_unit_error
361: (p_module_name => 'PQP_EXCEPTION_REPORTS'
362: ,p_hook_type => 'AI');
363: --
364: end;