DBA Data[Home] [Help]

APPS.SSP_STP_INS dependencies on HR_API

Line 94: When hr_api.check_integrity_violated Then

90: ssp_stp_shd.g_api_dml := false; -- Unset the api dml status
91: --
92: hr_utility.set_location(' Leaving:'||l_proc, 10);
93: Exception
94: When hr_api.check_integrity_violated Then
95: -- A check constraint has been violated
96: ssp_stp_shd.g_api_dml := false; -- Unset the api dml status
97: ssp_stp_shd.constraint_error
98: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

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

Line 99: When hr_api.parent_integrity_violated Then

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

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

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

Line 104: When hr_api.unique_integrity_violated Then

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

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

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

Line 254: Raise HR_Api.Validate_Enabled;

250: --
251: -- If we are validating then raise the Validate_Enabled exception
252: --
253: If p_validate then
254: Raise HR_Api.Validate_Enabled;
255: End If;
256: --
257: hr_utility.set_location(' Leaving:'||l_proc, 10);
258: Exception

Line 259: When HR_Api.Validate_Enabled Then

255: End If;
256: --
257: hr_utility.set_location(' Leaving:'||l_proc, 10);
258: Exception
259: When HR_Api.Validate_Enabled Then
260: --
261: -- As the Validate_Enabled exception has been raised
262: -- we must rollback to the savepoint
263: --