DBA Data[Home] [Help]

APPS.HR_PAP_INS dependencies on HR_API

Line 82: When hr_api.check_integrity_violated Then

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

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

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

Line 87: When hr_api.parent_integrity_violated Then

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

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

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

Line 92: When hr_api.unique_integrity_violated Then

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

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

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

Line 242: Raise HR_Api.Validate_Enabled;

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

Line 247: When HR_Api.Validate_Enabled Then

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