DBA Data[Home] [Help]

APPS.PER_ANC_INS dependencies on HR_API

Line 154: When hr_api.check_integrity_violated Then

150: per_anc_shd.g_api_dml := false; -- Unset the api dml status
151: --
152: hr_utility.set_location(' Leaving:'||l_proc, 10);
153: Exception
154: When hr_api.check_integrity_violated Then
155: -- A check constraint has been violated
156: per_anc_shd.g_api_dml := false; -- Unset the api dml status
157: per_anc_shd.constraint_error
158: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

154: When hr_api.check_integrity_violated Then
155: -- A check constraint has been violated
156: per_anc_shd.g_api_dml := false; -- Unset the api dml status
157: per_anc_shd.constraint_error
158: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
159: When hr_api.parent_integrity_violated Then
160: -- Parent integrity has been violated
161: per_anc_shd.g_api_dml := false; -- Unset the api dml status
162: per_anc_shd.constraint_error

Line 159: When hr_api.parent_integrity_violated Then

155: -- A check constraint has been violated
156: per_anc_shd.g_api_dml := false; -- Unset the api dml status
157: per_anc_shd.constraint_error
158: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
159: When hr_api.parent_integrity_violated Then
160: -- Parent integrity has been violated
161: per_anc_shd.g_api_dml := false; -- Unset the api dml status
162: per_anc_shd.constraint_error
163: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

159: When hr_api.parent_integrity_violated Then
160: -- Parent integrity has been violated
161: per_anc_shd.g_api_dml := false; -- Unset the api dml status
162: per_anc_shd.constraint_error
163: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
164: When hr_api.unique_integrity_violated Then
165: -- Unique integrity has been violated
166: per_anc_shd.g_api_dml := false; -- Unset the api dml status
167: per_anc_shd.constraint_error

Line 164: When hr_api.unique_integrity_violated Then

160: -- Parent integrity has been violated
161: per_anc_shd.g_api_dml := false; -- Unset the api dml status
162: per_anc_shd.constraint_error
163: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
164: When hr_api.unique_integrity_violated Then
165: -- Unique integrity has been violated
166: per_anc_shd.g_api_dml := false; -- Unset the api dml status
167: per_anc_shd.constraint_error
168: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

164: When hr_api.unique_integrity_violated Then
165: -- Unique integrity has been violated
166: per_anc_shd.g_api_dml := false; -- Unset the api dml status
167: per_anc_shd.constraint_error
168: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
169: When Others Then
170: per_anc_shd.g_api_dml := false; -- Unset the api dml status
171: Raise;
172: End insert_dml;

Line 320: Raise HR_Api.Validate_Enabled;

316: --
317: -- If we are validating then raise the Validate_Enabled exception
318: --
319: If p_validate then
320: Raise HR_Api.Validate_Enabled;
321: End If;
322: --
323: hr_utility.set_location(' Leaving:'||l_proc, 10);
324: Exception

Line 325: When HR_Api.Validate_Enabled Then

321: End If;
322: --
323: hr_utility.set_location(' Leaving:'||l_proc, 10);
324: Exception
325: When HR_Api.Validate_Enabled Then
326: --
327: -- As the Validate_Enabled exception has been raised
328: -- we must rollback to the savepoint
329: --