APPS.PER_EST_INS dependencies on HR_API

Line 166: When hr_api.check_integrity_violated Then

162: per_est_shd.g_api_dml := false; -- Unset the api dml status
163: --
164: hr_utility.set_location(' Leaving:'||l_proc, 10);
165: Exception
166: When hr_api.check_integrity_violated Then
167: -- A check constraint has been violated
168: per_est_shd.g_api_dml := false; -- Unset the api dml status
169: per_est_shd.constraint_error
170: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

166: When hr_api.check_integrity_violated Then
167: -- A check constraint has been violated
168: per_est_shd.g_api_dml := false; -- Unset the api dml status
169: per_est_shd.constraint_error
170: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
171: When hr_api.parent_integrity_violated Then
172: -- Parent integrity has been violated
173: per_est_shd.g_api_dml := false; -- Unset the api dml status
174: per_est_shd.constraint_error

Line 171: When hr_api.parent_integrity_violated Then

167: -- A check constraint has been violated
168: per_est_shd.g_api_dml := false; -- Unset the api dml status
169: per_est_shd.constraint_error
170: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
171: When hr_api.parent_integrity_violated Then
172: -- Parent integrity has been violated
173: per_est_shd.g_api_dml := false; -- Unset the api dml status
174: per_est_shd.constraint_error
175: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

171: When hr_api.parent_integrity_violated Then
172: -- Parent integrity has been violated
173: per_est_shd.g_api_dml := false; -- Unset the api dml status
174: per_est_shd.constraint_error
175: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
176: When hr_api.unique_integrity_violated Then
177: -- Unique integrity has been violated
178: per_est_shd.g_api_dml := false; -- Unset the api dml status
179: per_est_shd.constraint_error

Line 176: When hr_api.unique_integrity_violated Then

172: -- Parent integrity has been violated
173: per_est_shd.g_api_dml := false; -- Unset the api dml status
174: per_est_shd.constraint_error
175: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
176: When hr_api.unique_integrity_violated Then
177: -- Unique integrity has been violated
178: per_est_shd.g_api_dml := false; -- Unset the api dml status
179: per_est_shd.constraint_error
180: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

176: When hr_api.unique_integrity_violated Then
177: -- Unique integrity has been violated
178: per_est_shd.g_api_dml := false; -- Unset the api dml status
179: per_est_shd.constraint_error
180: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
181: When Others Then
182: per_est_shd.g_api_dml := false; -- Unset the api dml status
183: Raise;
184: End insert_dml;

Line 333: when hr_api.cannot_find_prog_unit then

329: p_est_information20 => p_rec.est_information20,
330: p_object_version_number =>p_rec.object_version_number
331: );
332: exception
333: when hr_api.cannot_find_prog_unit then
334: hr_api.cannot_find_prog_unit_error
335: ( P_MODULE_NAME => 'PER_ESTABLISHMENTS',
336: p_hook_type => 'AI'
337: );

Line 334: hr_api.cannot_find_prog_unit_error

330: p_object_version_number =>p_rec.object_version_number
331: );
332: exception
333: when hr_api.cannot_find_prog_unit then
334: hr_api.cannot_find_prog_unit_error
335: ( P_MODULE_NAME => 'PER_ESTABLISHMENTS',
336: p_hook_type => 'AI'
337: );
338: end;

Line 386: Raise HR_Api.Validate_Enabled;

382: --
383: -- If we are validating then raise the Validate_Enabled exception
384: --
385: If p_validate then
386: Raise HR_Api.Validate_Enabled;
387: End If;
388: --
389: hr_utility.set_location(' Leaving:'||l_proc, 10);
390: Exception

Line 391: When HR_Api.Validate_Enabled Then

387: End If;
388: --
389: hr_utility.set_location(' Leaving:'||l_proc, 10);
390: Exception
391: When HR_Api.Validate_Enabled Then
392: --
393: -- As the Validate_Enabled exception has been raised
394: -- we must rollback to the savepoint
395: --