APPS.HR_SCL_INS dependencies on HR_API

Line 156: When hr_api.check_integrity_violated Then

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

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

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

Line 161: When hr_api.parent_integrity_violated Then

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

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

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

Line 166: When hr_api.unique_integrity_violated Then

162: -- Parent integrity has been violated
163: hr_scl_shd.g_api_dml := false; -- Unset the api dml status
164: hr_scl_shd.constraint_error
165: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
166: When hr_api.unique_integrity_violated Then
167: -- Unique integrity has been violated
168: hr_scl_shd.g_api_dml := false; -- Unset the api dml status
169: hr_scl_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.unique_integrity_violated Then
167: -- Unique integrity has been violated
168: hr_scl_shd.g_api_dml := false; -- Unset the api dml status
169: hr_scl_shd.constraint_error
170: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
171: When Others Then
172: hr_scl_shd.g_api_dml := false; -- Unset the api dml status
173: Raise;
174: End insert_dml;

Line 241: hr_api.return_concat_kf_segments

237: -- concatenate the segments for the group_name using a period as a
238: -- separator
239: --
240: p_rec.concatenated_segments :=
241: hr_api.return_concat_kf_segments
242: (p_id_flex_num => p_rec.id_flex_num,
243: p_application_id => 800,
244: p_id_flex_code => 'SCL',
245: p_segment1 => p_rec.segment1,

Line 361: Raise HR_Api.Validate_Enabled;

357: --
358: -- If we are validating then raise the Validate_Enabled exception
359: --
360: If p_validate then
361: Raise HR_Api.Validate_Enabled;
362: End If;
363: --
364: hr_utility.set_location(' Leaving:'||l_proc, 10);
365: Exception

Line 366: When HR_Api.Validate_Enabled Then

362: End If;
363: --
364: hr_utility.set_location(' Leaving:'||l_proc, 10);
365: Exception
366: When HR_Api.Validate_Enabled Then
367: --
368: -- As the Validate_Enabled exception has been raised
369: -- we must rollback to the savepoint
370: --