DBA Data[Home] [Help]

APPS.PER_EQT_INS dependencies on HR_API

Line 210: When hr_api.check_integrity_violated Then

206: per_eqt_shd.g_api_dml := false; -- Unset the api dml status
207: --
208: hr_utility.set_location(' Leaving:'||l_proc, 10);
209: Exception
210: When hr_api.check_integrity_violated Then
211: -- A check constraint has been violated
212: per_eqt_shd.g_api_dml := false; -- Unset the api dml status
213: per_eqt_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.check_integrity_violated Then
211: -- A check constraint has been violated
212: per_eqt_shd.g_api_dml := false; -- Unset the api dml status
213: per_eqt_shd.constraint_error
214: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
215: When hr_api.parent_integrity_violated Then
216: -- Parent integrity has been violated
217: per_eqt_shd.g_api_dml := false; -- Unset the api dml status
218: per_eqt_shd.constraint_error

Line 215: When hr_api.parent_integrity_violated Then

211: -- A check constraint has been violated
212: per_eqt_shd.g_api_dml := false; -- Unset the api dml status
213: per_eqt_shd.constraint_error
214: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
215: When hr_api.parent_integrity_violated Then
216: -- Parent integrity has been violated
217: per_eqt_shd.g_api_dml := false; -- Unset the api dml status
218: per_eqt_shd.constraint_error
219: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

215: When hr_api.parent_integrity_violated Then
216: -- Parent integrity has been violated
217: per_eqt_shd.g_api_dml := false; -- Unset the api dml status
218: per_eqt_shd.constraint_error
219: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
220: When hr_api.unique_integrity_violated Then
221: -- Unique integrity has been violated
222: per_eqt_shd.g_api_dml := false; -- Unset the api dml status
223: per_eqt_shd.constraint_error

Line 220: When hr_api.unique_integrity_violated Then

216: -- Parent integrity has been violated
217: per_eqt_shd.g_api_dml := false; -- Unset the api dml status
218: per_eqt_shd.constraint_error
219: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
220: When hr_api.unique_integrity_violated Then
221: -- Unique integrity has been violated
222: per_eqt_shd.g_api_dml := false; -- Unset the api dml status
223: per_eqt_shd.constraint_error
224: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

220: When hr_api.unique_integrity_violated Then
221: -- Unique integrity has been violated
222: per_eqt_shd.g_api_dml := false; -- Unset the api dml status
223: per_eqt_shd.constraint_error
224: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
225: When Others Then
226: per_eqt_shd.g_api_dml := false; -- Unset the api dml status
227: Raise;
228: End insert_dml;

Line 403: when hr_api.cannot_find_prog_unit then

399: ,p_provider => p_rec.provider
400: ,p_qa_organization => p_rec.qa_organization
401: );
402: exception
403: when hr_api.cannot_find_prog_unit then
404: hr_api.cannot_find_prog_unit_error
405: (p_module_name => 'PER_QUALIFICATION_TYPES'
406: ,p_hook_type => 'AI'
407: );

Line 404: hr_api.cannot_find_prog_unit_error

400: ,p_qa_organization => p_rec.qa_organization
401: );
402: exception
403: when hr_api.cannot_find_prog_unit then
404: hr_api.cannot_find_prog_unit_error
405: (p_module_name => 'PER_QUALIFICATION_TYPES'
406: ,p_hook_type => 'AI'
407: );
408: end;

Line 459: Raise HR_Api.Validate_Enabled;

455: --
456: -- If we are validating then raise the Validate_Enabled exception
457: --
458: If p_validate then
459: Raise HR_Api.Validate_Enabled;
460: End If;
461: --
462: hr_utility.set_location(' Leaving:'||l_proc, 10);
463: Exception

Line 464: When HR_Api.Validate_Enabled Then

460: End If;
461: --
462: hr_utility.set_location(' Leaving:'||l_proc, 10);
463: Exception
464: When HR_Api.Validate_Enabled Then
465: --
466: -- As the Validate_Enabled exception has been raised
467: -- we must rollback to the savepoint
468: --