APPS.PER_ZA_AO_ASS_UPD dependencies on HR_API

Line 81: When hr_api.check_integrity_violated Then

77: --
78: hr_utility.set_location(' Leaving:'||l_proc, 10);
79: --
80: Exception
81: When hr_api.check_integrity_violated Then
82: -- A check constraint has been violated
83: per_za_ao_ass_shd.g_api_dml := false; -- Unset the api dml status
84: per_za_ao_ass_shd.constraint_error
85: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

81: When hr_api.check_integrity_violated Then
82: -- A check constraint has been violated
83: per_za_ao_ass_shd.g_api_dml := false; -- Unset the api dml status
84: per_za_ao_ass_shd.constraint_error
85: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
86: When hr_api.parent_integrity_violated Then
87: -- Parent integrity has been violated
88: per_za_ao_ass_shd.g_api_dml := false; -- Unset the api dml status
89: per_za_ao_ass_shd.constraint_error

Line 86: When hr_api.parent_integrity_violated Then

82: -- A check constraint has been violated
83: per_za_ao_ass_shd.g_api_dml := false; -- Unset the api dml status
84: per_za_ao_ass_shd.constraint_error
85: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
86: When hr_api.parent_integrity_violated Then
87: -- Parent integrity has been violated
88: per_za_ao_ass_shd.g_api_dml := false; -- Unset the api dml status
89: per_za_ao_ass_shd.constraint_error
90: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

86: When hr_api.parent_integrity_violated Then
87: -- Parent integrity has been violated
88: per_za_ao_ass_shd.g_api_dml := false; -- Unset the api dml status
89: per_za_ao_ass_shd.constraint_error
90: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
91: When hr_api.unique_integrity_violated Then
92: -- Unique integrity has been violated
93: per_za_ao_ass_shd.g_api_dml := false; -- Unset the api dml status
94: per_za_ao_ass_shd.constraint_error

Line 91: When hr_api.unique_integrity_violated Then

87: -- Parent integrity has been violated
88: per_za_ao_ass_shd.g_api_dml := false; -- Unset the api dml status
89: per_za_ao_ass_shd.constraint_error
90: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
91: When hr_api.unique_integrity_violated Then
92: -- Unique integrity has been violated
93: per_za_ao_ass_shd.g_api_dml := false; -- Unset the api dml status
94: per_za_ao_ass_shd.constraint_error
95: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

91: When hr_api.unique_integrity_violated Then
92: -- Unique integrity has been violated
93: per_za_ao_ass_shd.g_api_dml := false; -- Unset the api dml status
94: per_za_ao_ass_shd.constraint_error
95: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
96: When Others Then
97: per_za_ao_ass_shd.g_api_dml := false; -- Unset the api dml status
98: Raise;
99: End update_dml;

Line 239: Raise HR_Api.Validate_Enabled;

235: --
236: -- If we are validating then raise the Validate_Enabled exception
237: --
238: If p_validate then
239: Raise HR_Api.Validate_Enabled;
240: End If;
241: --
242: hr_utility.set_location(' Leaving:'||l_proc, 10);
243: Exception

Line 244: When HR_Api.Validate_Enabled Then

240: End If;
241: --
242: hr_utility.set_location(' Leaving:'||l_proc, 10);
243: Exception
244: When HR_Api.Validate_Enabled Then
245: --
246: -- As the Validate_Enabled exception has been raised
247: -- we must rollback to the savepoint
248: --