DBA Data[Home] [Help]

APPS.PAY_PPM_INS dependencies on HR_API

Line 287: When hr_api.check_integrity_violated Then

283: pay_ppm_shd.g_api_dml := false; -- Unset the api dml status
284: hr_utility.set_location(' Leaving:'||l_proc, 15);
285: --
286: Exception
287: When hr_api.check_integrity_violated Then
288: -- A check constraint has been violated
289: pay_ppm_shd.g_api_dml := false; -- Unset the api dml status
290: pay_ppm_shd.constraint_error
291: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

287: When hr_api.check_integrity_violated Then
288: -- A check constraint has been violated
289: pay_ppm_shd.g_api_dml := false; -- Unset the api dml status
290: pay_ppm_shd.constraint_error
291: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
292: When hr_api.unique_integrity_violated Then
293: -- Unique integrity has been violated
294: pay_ppm_shd.g_api_dml := false; -- Unset the api dml status
295: pay_ppm_shd.constraint_error

Line 292: When hr_api.unique_integrity_violated Then

288: -- A check constraint has been violated
289: pay_ppm_shd.g_api_dml := false; -- Unset the api dml status
290: pay_ppm_shd.constraint_error
291: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
292: When hr_api.unique_integrity_violated Then
293: -- Unique integrity has been violated
294: pay_ppm_shd.g_api_dml := false; -- Unset the api dml status
295: pay_ppm_shd.constraint_error
296: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

292: When hr_api.unique_integrity_violated Then
293: -- Unique integrity has been violated
294: pay_ppm_shd.g_api_dml := false; -- Unset the api dml status
295: pay_ppm_shd.constraint_error
296: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
297: When Others Then
298: pay_ppm_shd.g_api_dml := false; -- Unset the api dml status
299: Raise;
300: End dt_insert_dml;

Line 515: when hr_api.cannot_find_prog_unit then

511: ,p_ppm_information29 => p_rec.ppm_information29
512: ,p_ppm_information30 => p_rec.ppm_information30
513: );
514: exception
515: when hr_api.cannot_find_prog_unit then
516: hr_api.cannot_find_prog_unit_error
517: (p_module_name => 'PAY_PERSONAL_PAYMENT_METHODS_F'
518: ,p_hook_type => 'AI'
519: );

Line 516: hr_api.cannot_find_prog_unit_error

512: ,p_ppm_information30 => p_rec.ppm_information30
513: );
514: exception
515: when hr_api.cannot_find_prog_unit then
516: hr_api.cannot_find_prog_unit_error
517: (p_module_name => 'PAY_PERSONAL_PAYMENT_METHODS_F'
518: ,p_hook_type => 'AI'
519: );
520: end;

Line 560: When HR_Api.Object_Locked then

556: --
557: l_lock_table := 'pay_org_pay_method_usages_f';
558: lock table pay_org_pay_method_usages_f in share mode nowait;
559: exception
560: When HR_Api.Object_Locked then
561: --
562: -- The object is locked therefore we need to supply a meaningful
563: -- error message.
564: --

Line 711: Raise HR_Api.Validate_Enabled;

707: --
708: -- If we are validating then raise the Validate_Enabled exception
709: --
710: If p_validate then
711: Raise HR_Api.Validate_Enabled;
712: End If;
713: --
714: hr_utility.set_location(' Leaving:'||l_proc, 10);
715: Exception

Line 716: When HR_Api.Validate_Enabled Then

712: End If;
713: --
714: hr_utility.set_location(' Leaving:'||l_proc, 10);
715: Exception
716: When HR_Api.Validate_Enabled Then
717: --
718: -- As the Validate_Enabled exception has been raised
719: -- we must rollback to the savepoint
720: --