DBA Data[Home] [Help]

APPS.PER_ZA_TRA_INS dependencies on HR_API

Line 95: When hr_api.check_integrity_violated Then

91: per_za_tra_shd.g_api_dml := false; -- Unset the api dml status
92: --
93: hr_utility.set_location(' Leaving:'||l_proc, 10);
94: Exception
95: When hr_api.check_integrity_violated Then
96: -- A check constraint has been violated
97: per_za_tra_shd.g_api_dml := false; -- Unset the api dml status
98: per_za_tra_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.check_integrity_violated Then
96: -- A check constraint has been violated
97: per_za_tra_shd.g_api_dml := false; -- Unset the api dml status
98: per_za_tra_shd.constraint_error
99: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
100: When hr_api.parent_integrity_violated Then
101: -- Parent integrity has been violated
102: per_za_tra_shd.g_api_dml := false; -- Unset the api dml status
103: per_za_tra_shd.constraint_error

Line 100: When hr_api.parent_integrity_violated Then

96: -- A check constraint has been violated
97: per_za_tra_shd.g_api_dml := false; -- Unset the api dml status
98: per_za_tra_shd.constraint_error
99: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
100: When hr_api.parent_integrity_violated Then
101: -- Parent integrity has been violated
102: per_za_tra_shd.g_api_dml := false; -- Unset the api dml status
103: per_za_tra_shd.constraint_error
104: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

100: When hr_api.parent_integrity_violated Then
101: -- Parent integrity has been violated
102: per_za_tra_shd.g_api_dml := false; -- Unset the api dml status
103: per_za_tra_shd.constraint_error
104: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
105: When hr_api.unique_integrity_violated Then
106: -- Unique integrity has been violated
107: per_za_tra_shd.g_api_dml := false; -- Unset the api dml status
108: per_za_tra_shd.constraint_error

Line 105: When hr_api.unique_integrity_violated Then

101: -- Parent integrity has been violated
102: per_za_tra_shd.g_api_dml := false; -- Unset the api dml status
103: per_za_tra_shd.constraint_error
104: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
105: When hr_api.unique_integrity_violated Then
106: -- Unique integrity has been violated
107: per_za_tra_shd.g_api_dml := false; -- Unset the api dml status
108: per_za_tra_shd.constraint_error
109: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

105: When hr_api.unique_integrity_violated Then
106: -- Unique integrity has been violated
107: per_za_tra_shd.g_api_dml := false; -- Unset the api dml status
108: per_za_tra_shd.constraint_error
109: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
110: When Others Then
111: per_za_tra_shd.g_api_dml := false; -- Unset the api dml status
112: Raise;
113: End insert_dml;

Line 192: Raise HR_Api.Validate_Enabled;

188: --
189: -- If we are validating then raise the Validate_Enabled exception
190: --
191: If p_validate then
192: Raise HR_Api.Validate_Enabled;
193: End If;
194: --
195: hr_utility.set_location(' Leaving:'||l_proc, 10);
196: Exception

Line 197: When HR_Api.Validate_Enabled Then

193: End If;
194: --
195: hr_utility.set_location(' Leaving:'||l_proc, 10);
196: Exception
197: When HR_Api.Validate_Enabled Then
198: --
199: -- As the Validate_Enabled exception has been raised
200: -- we must rollback to the savepoint
201: --