DBA Data[Home] [Help]

APPS.PER_ZA_EQT_INS dependencies on HR_API

Line 131: When hr_api.check_integrity_violated Then

127: per_za_eqt_shd.g_api_dml := false; -- Unset the api dml status
128: --
129: hr_utility.set_location(' Leaving:'||l_proc, 10);
130: Exception
131: When hr_api.check_integrity_violated Then
132: -- A check constraint has been violated
133: per_za_eqt_shd.g_api_dml := false; -- Unset the api dml status
134: per_za_eqt_shd.constraint_error
135: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

131: When hr_api.check_integrity_violated Then
132: -- A check constraint has been violated
133: per_za_eqt_shd.g_api_dml := false; -- Unset the api dml status
134: per_za_eqt_shd.constraint_error
135: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
136: When hr_api.parent_integrity_violated Then
137: -- Parent integrity has been violated
138: per_za_eqt_shd.g_api_dml := false; -- Unset the api dml status
139: per_za_eqt_shd.constraint_error

Line 136: When hr_api.parent_integrity_violated Then

132: -- A check constraint has been violated
133: per_za_eqt_shd.g_api_dml := false; -- Unset the api dml status
134: per_za_eqt_shd.constraint_error
135: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
136: When hr_api.parent_integrity_violated Then
137: -- Parent integrity has been violated
138: per_za_eqt_shd.g_api_dml := false; -- Unset the api dml status
139: per_za_eqt_shd.constraint_error
140: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

136: When hr_api.parent_integrity_violated Then
137: -- Parent integrity has been violated
138: per_za_eqt_shd.g_api_dml := false; -- Unset the api dml status
139: per_za_eqt_shd.constraint_error
140: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
141: When hr_api.unique_integrity_violated Then
142: -- Unique integrity has been violated
143: per_za_eqt_shd.g_api_dml := false; -- Unset the api dml status
144: per_za_eqt_shd.constraint_error

Line 141: When hr_api.unique_integrity_violated Then

137: -- Parent integrity has been violated
138: per_za_eqt_shd.g_api_dml := false; -- Unset the api dml status
139: per_za_eqt_shd.constraint_error
140: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
141: When hr_api.unique_integrity_violated Then
142: -- Unique integrity has been violated
143: per_za_eqt_shd.g_api_dml := false; -- Unset the api dml status
144: per_za_eqt_shd.constraint_error
145: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

141: When hr_api.unique_integrity_violated Then
142: -- Unique integrity has been violated
143: per_za_eqt_shd.g_api_dml := false; -- Unset the api dml status
144: per_za_eqt_shd.constraint_error
145: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
146: When Others Then
147: per_za_eqt_shd.g_api_dml := false; -- Unset the api dml status
148: Raise;
149: End insert_dml;

Line 293: Raise HR_Api.Validate_Enabled;

289: --
290: -- If we are validating then raise the Validate_Enabled exception
291: --
292: If p_validate then
293: Raise HR_Api.Validate_Enabled;
294: End If;
295: --
296: hr_utility.set_location(' Leaving:'||l_proc, 10);
297: Exception

Line 298: When HR_Api.Validate_Enabled Then

294: End If;
295: --
296: hr_utility.set_location(' Leaving:'||l_proc, 10);
297: Exception
298: When HR_Api.Validate_Enabled Then
299: --
300: -- As the Validate_Enabled exception has been raised
301: -- we must rollback to the savepoint
302: --