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