DBA Data[Home] [Help]

APPS.PER_ZA_LSA_INS dependencies on HR_API

Line 105: When hr_api.check_integrity_violated Then

101: per_za_lsa_shd.g_api_dml := false; -- Unset the api dml status
102: --
103: hr_utility.set_location(' Leaving:'||l_proc, 10);
104: Exception
105: When hr_api.check_integrity_violated Then
106: -- A check constraint has been violated
107: per_za_lsa_shd.g_api_dml := false; -- Unset the api dml status
108: per_za_lsa_shd.constraint_error
109: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

105: When hr_api.check_integrity_violated Then
106: -- A check constraint has been violated
107: per_za_lsa_shd.g_api_dml := false; -- Unset the api dml status
108: per_za_lsa_shd.constraint_error
109: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
110: When hr_api.parent_integrity_violated Then
111: -- Parent integrity has been violated
112: per_za_lsa_shd.g_api_dml := false; -- Unset the api dml status
113: per_za_lsa_shd.constraint_error

Line 110: When hr_api.parent_integrity_violated Then

106: -- A check constraint has been violated
107: per_za_lsa_shd.g_api_dml := false; -- Unset the api dml status
108: per_za_lsa_shd.constraint_error
109: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
110: When hr_api.parent_integrity_violated Then
111: -- Parent integrity has been violated
112: per_za_lsa_shd.g_api_dml := false; -- Unset the api dml status
113: per_za_lsa_shd.constraint_error
114: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

110: When hr_api.parent_integrity_violated Then
111: -- Parent integrity has been violated
112: per_za_lsa_shd.g_api_dml := false; -- Unset the api dml status
113: per_za_lsa_shd.constraint_error
114: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
115: When hr_api.unique_integrity_violated Then
116: -- Unique integrity has been violated
117: per_za_lsa_shd.g_api_dml := false; -- Unset the api dml status
118: per_za_lsa_shd.constraint_error

Line 115: When hr_api.unique_integrity_violated Then

111: -- Parent integrity has been violated
112: per_za_lsa_shd.g_api_dml := false; -- Unset the api dml status
113: per_za_lsa_shd.constraint_error
114: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
115: When hr_api.unique_integrity_violated Then
116: -- Unique integrity has been violated
117: per_za_lsa_shd.g_api_dml := false; -- Unset the api dml status
118: per_za_lsa_shd.constraint_error
119: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

115: When hr_api.unique_integrity_violated Then
116: -- Unique integrity has been violated
117: per_za_lsa_shd.g_api_dml := false; -- Unset the api dml status
118: per_za_lsa_shd.constraint_error
119: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
120: When Others Then
121: per_za_lsa_shd.g_api_dml := false; -- Unset the api dml status
122: Raise;
123: End insert_dml;

Line 202: Raise HR_Api.Validate_Enabled;

198: --
199: -- If we are validating then raise the Validate_Enabled exception
200: --
201: If p_validate then
202: Raise HR_Api.Validate_Enabled;
203: End If;
204: --
205: hr_utility.set_location(' Leaving:'||l_proc, 10);
206: Exception

Line 207: When HR_Api.Validate_Enabled Then

203: End If;
204: --
205: hr_utility.set_location(' Leaving:'||l_proc, 10);
206: Exception
207: When HR_Api.Validate_Enabled Then
208: --
209: -- As the Validate_Enabled exception has been raised
210: -- we must rollback to the savepoint
211: --