DBA Data[Home] [Help]

APPS.PER_PYP_INS dependencies on HR_API

Line 175: When hr_api.check_integrity_violated Then

171: per_pyp_shd.g_api_dml := false; -- Unset the api dml status
172: --
173: hr_utility.set_location(' Leaving:'||l_proc, 10);
174: Exception
175: When hr_api.check_integrity_violated Then
176: -- A check constraint has been violated
177: per_pyp_shd.g_api_dml := false; -- Unset the api dml status
178: per_pyp_shd.constraint_error
179: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

175: When hr_api.check_integrity_violated Then
176: -- A check constraint has been violated
177: per_pyp_shd.g_api_dml := false; -- Unset the api dml status
178: per_pyp_shd.constraint_error
179: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
180: When hr_api.parent_integrity_violated Then
181: -- Parent integrity has been violated
182: per_pyp_shd.g_api_dml := false; -- Unset the api dml status
183: per_pyp_shd.constraint_error

Line 180: When hr_api.parent_integrity_violated Then

176: -- A check constraint has been violated
177: per_pyp_shd.g_api_dml := false; -- Unset the api dml status
178: per_pyp_shd.constraint_error
179: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
180: When hr_api.parent_integrity_violated Then
181: -- Parent integrity has been violated
182: per_pyp_shd.g_api_dml := false; -- Unset the api dml status
183: per_pyp_shd.constraint_error
184: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

180: When hr_api.parent_integrity_violated Then
181: -- Parent integrity has been violated
182: per_pyp_shd.g_api_dml := false; -- Unset the api dml status
183: per_pyp_shd.constraint_error
184: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
185: When hr_api.unique_integrity_violated Then
186: -- Unique integrity has been violated
187: per_pyp_shd.g_api_dml := false; -- Unset the api dml status
188: per_pyp_shd.constraint_error

Line 185: When hr_api.unique_integrity_violated Then

181: -- Parent integrity has been violated
182: per_pyp_shd.g_api_dml := false; -- Unset the api dml status
183: per_pyp_shd.constraint_error
184: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
185: When hr_api.unique_integrity_violated Then
186: -- Unique integrity has been violated
187: per_pyp_shd.g_api_dml := false; -- Unset the api dml status
188: per_pyp_shd.constraint_error
189: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

185: When hr_api.unique_integrity_violated Then
186: -- Unique integrity has been violated
187: per_pyp_shd.g_api_dml := false; -- Unset the api dml status
188: per_pyp_shd.constraint_error
189: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
190: When Others Then
191: per_pyp_shd.g_api_dml := false; -- Unset the api dml status
192: Raise;
193: End insert_dml;

Line 544: when hr_api.cannot_find_prog_unit then

540: end if ;
541:
542:
543: exception
544: when hr_api.cannot_find_prog_unit then
545: hr_api.cannot_find_prog_unit_error
546: (p_module_name => 'PER_PAY_PROPOSALS'
547: ,p_hook_type => 'AI'
548: );

Line 545: hr_api.cannot_find_prog_unit_error

541:
542:
543: exception
544: when hr_api.cannot_find_prog_unit then
545: hr_api.cannot_find_prog_unit_error
546: (p_module_name => 'PER_PAY_PROPOSALS'
547: ,p_hook_type => 'AI'
548: );
549: end;

Line 617: Raise HR_Api.Validate_Enabled;

613: --
614: -- If we are validating then raise the Validate_Enabled exception
615: --
616: If p_validate then
617: Raise HR_Api.Validate_Enabled;
618: End If;
619: --
620: -- Set the out arguments
621: --

Line 629: When HR_Api.Validate_Enabled Then

625: p_payroll_warning := l_payroll_warning;
626: --
627: hr_utility.set_location(' Leaving:'||l_proc, 10);
628: Exception
629: When HR_Api.Validate_Enabled Then
630: --
631: -- As the Validate_Enabled exception has been raised
632: -- we must rollback to the savepoint
633: --