APPS.CSP_PORTAL_EXCESS_PARTS_PVT dependencies on JTF_PLSQL_API

Line 127: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

123: WHEN FND_API.G_EXC_ERROR THEN
124: retcode := 2;
125: errbuf := l_Msg_Data;
126: l_return_status := FND_API.G_RET_STS_ERROR;
127: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
128: P_API_NAME => L_API_NAME
129: ,P_PKG_NAME => G_PKG_NAME
130: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
131: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 131: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

127: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
128: P_API_NAME => L_API_NAME
129: ,P_PKG_NAME => G_PKG_NAME
130: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
131: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
132: ,X_MSG_COUNT => l_MSG_COUNT
133: ,X_MSG_DATA => l_MSG_DATA
134: ,X_RETURN_STATUS => l_RETURN_STATUS);
135:

Line 140: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

136: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
137: retcode := 2;
138: errbuf := l_Msg_Data;
139: l_return_status := FND_API.G_RET_STS_ERROR;
140: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
141: P_API_NAME => L_API_NAME
142: ,P_PKG_NAME => G_PKG_NAME
143: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
144: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 144: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

140: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
141: P_API_NAME => L_API_NAME
142: ,P_PKG_NAME => G_PKG_NAME
143: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
144: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
145: ,X_MSG_COUNT => l_MSG_COUNT
146: ,X_MSG_DATA => l_MSG_DATA
147: ,X_RETURN_STATUS => l_RETURN_STATUS);
148:

Line 157: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

153: l_sqlcode := SQLCODE;
154: l_sqlerrm := SQLERRM;
155: l_return_status := FND_API.G_RET_STS_ERROR;
156:
157: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
158: P_API_NAME => L_API_NAME
159: ,P_PKG_NAME => G_PKG_NAME
160: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
161: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

Line 160: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS

156:
157: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
158: P_API_NAME => L_API_NAME
159: ,P_PKG_NAME => G_PKG_NAME
160: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
161: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
162: ,P_SQLCODE => l_sqlcode
163: ,P_SQLERRM => l_sqlerrm
164: ,X_MSG_COUNT => l_MSG_COUNT

Line 161: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT

157: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
158: P_API_NAME => L_API_NAME
159: ,P_PKG_NAME => G_PKG_NAME
160: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
161: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PVT
162: ,P_SQLCODE => l_sqlcode
163: ,P_SQLERRM => l_sqlerrm
164: ,X_MSG_COUNT => l_MSG_COUNT
165: ,X_MSG_DATA => l_MSG_DATA