APPS.PER_PDS_INS dependencies on HR_API

Line 242: When hr_api.check_integrity_violated Then

238: per_pds_shd.g_api_dml := false; -- Unset the api dml status
239: --
240: hr_utility.set_location(' Leaving:'||l_proc, 10);
241: Exception
242: When hr_api.check_integrity_violated Then
243: -- A check constraint has been violated
244: per_pds_shd.g_api_dml := false; -- Unset the api dml status
245: per_pds_shd.constraint_error
246: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

242: When hr_api.check_integrity_violated Then
243: -- A check constraint has been violated
244: per_pds_shd.g_api_dml := false; -- Unset the api dml status
245: per_pds_shd.constraint_error
246: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
247: When hr_api.parent_integrity_violated Then
248: -- Parent integrity has been violated
249: per_pds_shd.g_api_dml := false; -- Unset the api dml status
250: per_pds_shd.constraint_error

Line 247: When hr_api.parent_integrity_violated Then

243: -- A check constraint has been violated
244: per_pds_shd.g_api_dml := false; -- Unset the api dml status
245: per_pds_shd.constraint_error
246: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
247: When hr_api.parent_integrity_violated Then
248: -- Parent integrity has been violated
249: per_pds_shd.g_api_dml := false; -- Unset the api dml status
250: per_pds_shd.constraint_error
251: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

247: When hr_api.parent_integrity_violated Then
248: -- Parent integrity has been violated
249: per_pds_shd.g_api_dml := false; -- Unset the api dml status
250: per_pds_shd.constraint_error
251: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
252: When hr_api.unique_integrity_violated Then
253: -- Unique integrity has been violated
254: per_pds_shd.g_api_dml := false; -- Unset the api dml status
255: per_pds_shd.constraint_error

Line 252: When hr_api.unique_integrity_violated Then

248: -- Parent integrity has been violated
249: per_pds_shd.g_api_dml := false; -- Unset the api dml status
250: per_pds_shd.constraint_error
251: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
252: When hr_api.unique_integrity_violated Then
253: -- Unique integrity has been violated
254: per_pds_shd.g_api_dml := false; -- Unset the api dml status
255: per_pds_shd.constraint_error
256: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

252: When hr_api.unique_integrity_violated Then
253: -- Unique integrity has been violated
254: per_pds_shd.g_api_dml := false; -- Unset the api dml status
255: per_pds_shd.constraint_error
256: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
257: When Others Then
258: per_pds_shd.g_api_dml := false; -- Unset the api dml status
259: Raise;
260: End insert_dml;

Line 473: when hr_api.cannot_find_prog_unit then

469: ,p_pds_information29 =>p_rec.pds_information29
470: ,p_pds_information30 =>p_rec.pds_information30
471: );
472: exception
473: when hr_api.cannot_find_prog_unit then
474: hr_api.cannot_find_prog_unit_error
475: ( p_module_name => 'PER_PERIOD_OF_SERVICE',
476: p_hook_type => 'AI'
477: );

Line 474: hr_api.cannot_find_prog_unit_error

470: ,p_pds_information30 =>p_rec.pds_information30
471: );
472: exception
473: when hr_api.cannot_find_prog_unit then
474: hr_api.cannot_find_prog_unit_error
475: ( p_module_name => 'PER_PERIOD_OF_SERVICE',
476: p_hook_type => 'AI'
477: );
478: end;

Line 530: Raise HR_Api.Validate_Enabled;

526: --
527: -- If we are validating then raise the Validate_Enabled exception
528: --
529: If p_validate then
530: Raise HR_Api.Validate_Enabled;
531: End If;
532: --
533: hr_utility.set_location(' Leaving:'||l_proc, 10);
534: Exception

Line 535: When HR_Api.Validate_Enabled Then

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