182: END IF;
183:
184: EXCEPTION
185: WHEN FND_API.G_EXC_ERROR THEN
186: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
187: P_API_NAME => L_API_NAME
188: ,P_PKG_NAME => G_PKG_NAME
189: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
190: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
186: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
187: P_API_NAME => L_API_NAME
188: ,P_PKG_NAME => G_PKG_NAME
189: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
190: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
191: ,X_MSG_COUNT => X_MSG_COUNT
192: ,X_MSG_DATA => X_MSG_DATA
193: ,X_RETURN_STATUS => X_RETURN_STATUS);
194: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
191: ,X_MSG_COUNT => X_MSG_COUNT
192: ,X_MSG_DATA => X_MSG_DATA
193: ,X_RETURN_STATUS => X_RETURN_STATUS);
194: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
195: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
196: P_API_NAME => L_API_NAME
197: ,P_PKG_NAME => G_PKG_NAME
198: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
199: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
195: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
196: P_API_NAME => L_API_NAME
197: ,P_PKG_NAME => G_PKG_NAME
198: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
199: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
200: ,X_MSG_COUNT => X_MSG_COUNT
201: ,X_MSG_DATA => X_MSG_DATA
202: ,X_RETURN_STATUS => X_RETURN_STATUS);
203: WHEN OTHERS THEN