APPS.PQP_SHP_INS dependencies on HR_API

Line 190: When hr_api.check_integrity_violated Then

186: pqp_shp_shd.g_api_dml := false; -- Unset the api dml status
187: --
188: hr_utility.set_location(' Leaving:'||l_proc, 10);
189: Exception
190: When hr_api.check_integrity_violated Then
191: -- A check constraint has been violated
192: pqp_shp_shd.g_api_dml := false; -- Unset the api dml status
193: pqp_shp_shd.constraint_error
194: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

190: When hr_api.check_integrity_violated Then
191: -- A check constraint has been violated
192: pqp_shp_shd.g_api_dml := false; -- Unset the api dml status
193: pqp_shp_shd.constraint_error
194: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
195: When hr_api.parent_integrity_violated Then
196: -- Parent integrity has been violated
197: pqp_shp_shd.g_api_dml := false; -- Unset the api dml status
198: pqp_shp_shd.constraint_error

Line 195: When hr_api.parent_integrity_violated Then

191: -- A check constraint has been violated
192: pqp_shp_shd.g_api_dml := false; -- Unset the api dml status
193: pqp_shp_shd.constraint_error
194: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
195: When hr_api.parent_integrity_violated Then
196: -- Parent integrity has been violated
197: pqp_shp_shd.g_api_dml := false; -- Unset the api dml status
198: pqp_shp_shd.constraint_error
199: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

195: When hr_api.parent_integrity_violated Then
196: -- Parent integrity has been violated
197: pqp_shp_shd.g_api_dml := false; -- Unset the api dml status
198: pqp_shp_shd.constraint_error
199: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
200: When hr_api.unique_integrity_violated Then
201: -- Unique integrity has been violated
202: pqp_shp_shd.g_api_dml := false; -- Unset the api dml status
203: pqp_shp_shd.constraint_error

Line 200: When hr_api.unique_integrity_violated Then

196: -- Parent integrity has been violated
197: pqp_shp_shd.g_api_dml := false; -- Unset the api dml status
198: pqp_shp_shd.constraint_error
199: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
200: When hr_api.unique_integrity_violated Then
201: -- Unique integrity has been violated
202: pqp_shp_shd.g_api_dml := false; -- Unset the api dml status
203: pqp_shp_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.unique_integrity_violated Then
201: -- Unique integrity has been violated
202: pqp_shp_shd.g_api_dml := false; -- Unset the api dml status
203: pqp_shp_shd.constraint_error
204: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
205: When Others Then
206: pqp_shp_shd.g_api_dml := false; -- Unset the api dml status
207: Raise;
208: End insert_dml;

Line 431: when hr_api.cannot_find_prog_unit then

427: );
428: --
429: exception
430: --
431: when hr_api.cannot_find_prog_unit then
432: --
433: hr_api.cannot_find_prog_unit_error
434: (p_module_name => 'PQP_SERVICE_HISTORY_PERIODS'
435: ,p_hook_type => 'AI');

Line 433: hr_api.cannot_find_prog_unit_error

429: exception
430: --
431: when hr_api.cannot_find_prog_unit then
432: --
433: hr_api.cannot_find_prog_unit_error
434: (p_module_name => 'PQP_SERVICE_HISTORY_PERIODS'
435: ,p_hook_type => 'AI');
436: --
437: end;