140: pay_pgp_shd.g_api_dml := false; -- Unset the api dml status
141: --
142: hr_utility.set_location(' Leaving:'||l_proc, 10);
143: Exception
144: When hr_api.check_integrity_violated Then
145: -- A check constraint has been violated
146: pay_pgp_shd.g_api_dml := false; -- Unset the api dml status
147: pay_pgp_shd.constraint_error
148: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
144: When hr_api.check_integrity_violated Then
145: -- A check constraint has been violated
146: pay_pgp_shd.g_api_dml := false; -- Unset the api dml status
147: pay_pgp_shd.constraint_error
148: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
149: When hr_api.parent_integrity_violated Then
150: -- Parent integrity has been violated
151: pay_pgp_shd.g_api_dml := false; -- Unset the api dml status
152: pay_pgp_shd.constraint_error
145: -- A check constraint has been violated
146: pay_pgp_shd.g_api_dml := false; -- Unset the api dml status
147: pay_pgp_shd.constraint_error
148: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
149: When hr_api.parent_integrity_violated Then
150: -- Parent integrity has been violated
151: pay_pgp_shd.g_api_dml := false; -- Unset the api dml status
152: pay_pgp_shd.constraint_error
153: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
149: When hr_api.parent_integrity_violated Then
150: -- Parent integrity has been violated
151: pay_pgp_shd.g_api_dml := false; -- Unset the api dml status
152: pay_pgp_shd.constraint_error
153: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
154: When hr_api.unique_integrity_violated Then
155: -- Unique integrity has been violated
156: pay_pgp_shd.g_api_dml := false; -- Unset the api dml status
157: pay_pgp_shd.constraint_error
150: -- Parent integrity has been violated
151: pay_pgp_shd.g_api_dml := false; -- Unset the api dml status
152: pay_pgp_shd.constraint_error
153: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
154: When hr_api.unique_integrity_violated Then
155: -- Unique integrity has been violated
156: pay_pgp_shd.g_api_dml := false; -- Unset the api dml status
157: pay_pgp_shd.constraint_error
158: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
154: When hr_api.unique_integrity_violated Then
155: -- Unique integrity has been violated
156: pay_pgp_shd.g_api_dml := false; -- Unset the api dml status
157: pay_pgp_shd.constraint_error
158: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
159: When Others Then
160: pay_pgp_shd.g_api_dml := false; -- Unset the api dml status
161: Raise;
162: End insert_dml;
225: -- concatenate the segments for the group_name using a period as a
226: -- separator
227: --
228: p_rec.group_name :=
229: hr_api.return_concat_kf_segments
230: (p_id_flex_num => p_rec.id_flex_num,
231: p_application_id => 801,
232: p_id_flex_code => 'GRP',
233: p_segment1 => p_rec.segment1,
347: --
348: -- If we are validating then raise the Validate_Enabled exception
349: --
350: If p_validate then
351: Raise HR_Api.Validate_Enabled;
352: End If;
353: --
354: hr_utility.set_location(' Leaving:'||l_proc, 10);
355: Exception
352: End If;
353: --
354: hr_utility.set_location(' Leaving:'||l_proc, 10);
355: Exception
356: When HR_Api.Validate_Enabled Then
357: --
358: -- As the Validate_Enabled exception has been raised
359: -- we must rollback to the savepoint
360: --