268: --for debugging purpose
269: -- x_msg_data := l_msg_data;
270:
271: WHEN FND_API.G_EXC_ERROR THEN
272: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
273: P_API_NAME => L_API_NAME
274: ,P_PKG_NAME => G_PKG_NAME
275: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
276: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
272: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
273: P_API_NAME => L_API_NAME
274: ,P_PKG_NAME => G_PKG_NAME
275: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
276: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
277: ,X_MSG_COUNT => X_MSG_COUNT
278: ,X_MSG_DATA => X_MSG_DATA
279: ,X_RETURN_STATUS => X_RETURN_STATUS);
280:
278: ,X_MSG_DATA => X_MSG_DATA
279: ,X_RETURN_STATUS => X_RETURN_STATUS);
280:
281: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
282: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
283: P_API_NAME => L_API_NAME
284: ,P_PKG_NAME => G_PKG_NAME
285: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
286: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
282: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
283: P_API_NAME => L_API_NAME
284: ,P_PKG_NAME => G_PKG_NAME
285: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
286: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
287: ,X_MSG_COUNT => X_MSG_COUNT
288: ,X_MSG_DATA => X_MSG_DATA
289: ,X_RETURN_STATUS => X_RETURN_STATUS);
290:
288: ,X_MSG_DATA => X_MSG_DATA
289: ,X_RETURN_STATUS => X_RETURN_STATUS);
290:
291: WHEN OTHERS THEN
292: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
293: P_API_NAME => L_API_NAME
294: ,P_PKG_NAME => G_PKG_NAME
295: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
296: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
291: WHEN OTHERS THEN
292: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
293: P_API_NAME => L_API_NAME
294: ,P_PKG_NAME => G_PKG_NAME
295: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
296: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
297: ,X_MSG_COUNT => X_MSG_COUNT
298: ,X_MSG_DATA => X_MSG_DATA
299: ,X_RETURN_STATUS => X_RETURN_STATUS);
292: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
293: P_API_NAME => L_API_NAME
294: ,P_PKG_NAME => G_PKG_NAME
295: ,P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS
296: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
297: ,X_MSG_COUNT => X_MSG_COUNT
298: ,X_MSG_DATA => X_MSG_DATA
299: ,X_RETURN_STATUS => X_RETURN_STATUS);
300: