194: per_cpo_shd.g_api_dml := false; -- Unset the api dml status
195: --
196: hr_utility.set_location(' Leaving:'||l_proc, 10);
197: Exception
198: When hr_api.check_integrity_violated Then
199: -- A check constraint has been violated
200: per_cpo_shd.g_api_dml := false; -- Unset the api dml status
201: per_cpo_shd.constraint_error
202: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
198: When hr_api.check_integrity_violated Then
199: -- A check constraint has been violated
200: per_cpo_shd.g_api_dml := false; -- Unset the api dml status
201: per_cpo_shd.constraint_error
202: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
203: When hr_api.parent_integrity_violated Then
204: -- Parent integrity has been violated
205: per_cpo_shd.g_api_dml := false; -- Unset the api dml status
206: per_cpo_shd.constraint_error
199: -- A check constraint has been violated
200: per_cpo_shd.g_api_dml := false; -- Unset the api dml status
201: per_cpo_shd.constraint_error
202: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
203: When hr_api.parent_integrity_violated Then
204: -- Parent integrity has been violated
205: per_cpo_shd.g_api_dml := false; -- Unset the api dml status
206: per_cpo_shd.constraint_error
207: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
203: When hr_api.parent_integrity_violated Then
204: -- Parent integrity has been violated
205: per_cpo_shd.g_api_dml := false; -- Unset the api dml status
206: per_cpo_shd.constraint_error
207: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
208: When hr_api.unique_integrity_violated Then
209: -- Unique integrity has been violated
210: per_cpo_shd.g_api_dml := false; -- Unset the api dml status
211: per_cpo_shd.constraint_error
204: -- Parent integrity has been violated
205: per_cpo_shd.g_api_dml := false; -- Unset the api dml status
206: per_cpo_shd.constraint_error
207: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
208: When hr_api.unique_integrity_violated Then
209: -- Unique integrity has been violated
210: per_cpo_shd.g_api_dml := false; -- Unset the api dml status
211: per_cpo_shd.constraint_error
212: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
208: When hr_api.unique_integrity_violated Then
209: -- Unique integrity has been violated
210: per_cpo_shd.g_api_dml := false; -- Unset the api dml status
211: per_cpo_shd.constraint_error
212: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
213: When Others Then
214: per_cpo_shd.g_api_dml := false; -- Unset the api dml status
215: Raise;
216: End insert_dml;
457: );
458: --
459: exception
460: --
461: when hr_api.cannot_find_prog_unit then
462: --
463: hr_api.cannot_find_prog_unit_error
464: (p_module_name => 'PER_COMPETENCE_OUTCOMES'
465: ,p_hook_type => 'AI');
459: exception
460: --
461: when hr_api.cannot_find_prog_unit then
462: --
463: hr_api.cannot_find_prog_unit_error
464: (p_module_name => 'PER_COMPETENCE_OUTCOMES'
465: ,p_hook_type => 'AI');
466: --
467: end;