DBA Data[Home] [Help]

APPS.PQH_REI_INS dependencies on HR_API

Line 238: When hr_api.check_integrity_violated Then

234: --
235: --
236: hr_utility.set_location(' Leaving:'||l_proc, 10);
237: Exception
238: When hr_api.check_integrity_violated Then
239: -- A check constraint has been violated
240: --
241: pqh_rei_shd.constraint_error
242: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

238: When hr_api.check_integrity_violated Then
239: -- A check constraint has been violated
240: --
241: pqh_rei_shd.constraint_error
242: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
243: When hr_api.parent_integrity_violated Then
244: -- Parent integrity has been violated
245: --
246: pqh_rei_shd.constraint_error

Line 243: When hr_api.parent_integrity_violated Then

239: -- A check constraint has been violated
240: --
241: pqh_rei_shd.constraint_error
242: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
243: When hr_api.parent_integrity_violated Then
244: -- Parent integrity has been violated
245: --
246: pqh_rei_shd.constraint_error
247: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

243: When hr_api.parent_integrity_violated Then
244: -- Parent integrity has been violated
245: --
246: pqh_rei_shd.constraint_error
247: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
248: When hr_api.unique_integrity_violated Then
249: -- Unique integrity has been violated
250: --
251: pqh_rei_shd.constraint_error

Line 248: When hr_api.unique_integrity_violated Then

244: -- Parent integrity has been violated
245: --
246: pqh_rei_shd.constraint_error
247: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
248: When hr_api.unique_integrity_violated Then
249: -- Unique integrity has been violated
250: --
251: pqh_rei_shd.constraint_error
252: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

248: When hr_api.unique_integrity_violated Then
249: -- Unique integrity has been violated
250: --
251: pqh_rei_shd.constraint_error
252: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
253: When Others Then
254: --
255: Raise;
256: End insert_dml;

Line 468: when hr_api.cannot_find_prog_unit then

464: );
465: --
466: exception
467: --
468: when hr_api.cannot_find_prog_unit then
469: --
470: hr_api.cannot_find_prog_unit_error
471: (p_module_name => 'PQH_ROLE_EXTRA_INFO'
472: ,p_hook_type => 'AI');

Line 470: hr_api.cannot_find_prog_unit_error

466: exception
467: --
468: when hr_api.cannot_find_prog_unit then
469: --
470: hr_api.cannot_find_prog_unit_error
471: (p_module_name => 'PQH_ROLE_EXTRA_INFO'
472: ,p_hook_type => 'AI');
473: --
474: end;

Line 528: Raise HR_Api.Validate_Enabled;

524: --
525: -- If we are validating then raise the Validate_Enabled exception
526: --
527: If p_validate then
528: Raise HR_Api.Validate_Enabled;
529: End If;
530: --
531: -- Call to raise any errors on multi-message list
532: hr_multi_message.end_validation_set;

Line 536: When HR_Api.Validate_Enabled Then

532: hr_multi_message.end_validation_set;
533: --
534: hr_utility.set_location('Leaving:'||l_proc, 20);
535: Exception
536: When HR_Api.Validate_Enabled Then
537: --
538: -- As the Validate_Enabled exception has been raised
539: -- we must rollback to the savepoint
540: --