APPS.PER_ZA_AO_ASS_INS dependencies on HR_API

Line 85: When hr_api.check_integrity_violated Then

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

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

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

Line 90: When hr_api.parent_integrity_violated Then

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

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

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

Line 95: When hr_api.unique_integrity_violated Then

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

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

95: When hr_api.unique_integrity_violated Then
96: -- Unique integrity has been violated
97: per_za_ao_ass_shd.g_api_dml := false; -- Unset the api dml status
98: per_za_ao_ass_shd.constraint_error
99: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
100: When Others Then
101: per_za_ao_ass_shd.g_api_dml := false; -- Unset the api dml status
102: Raise;
103: End insert_dml;

Line 182: Raise HR_Api.Validate_Enabled;

178: --
179: -- If we are validating then raise the Validate_Enabled exception
180: --
181: If p_validate then
182: Raise HR_Api.Validate_Enabled;
183: End If;
184: --
185: hr_utility.set_location(' Leaving:'||l_proc, 10);
186: Exception

Line 187: When HR_Api.Validate_Enabled Then

183: End If;
184: --
185: hr_utility.set_location(' Leaving:'||l_proc, 10);
186: Exception
187: When HR_Api.Validate_Enabled Then
188: --
189: -- As the Validate_Enabled exception has been raised
190: -- we must rollback to the savepoint
191: --