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));
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
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));
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
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));
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;
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: );
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;
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: --
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: --