180: p_data => x_msg_data);
181:
182: EXCEPTION
183: WHEN FND_API.G_EXC_ERROR THEN
184: JTF_DEBUG_PUB.HANDLE_EXCEPTIONS(
185: P_API_NAME => L_API_NAME
186: ,P_PKG_NAME => G_PKG_NAME
187: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
188: ,P_SQLCODE => SQLCODE
191: ,X_MSG_DATA => X_MSG_DATA
192: ,X_RETURN_STATUS => X_RETURN_STATUS);
193:
194: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
195: JTF_DEBUG_PUB.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_UNEXP_ERROR
199: ,P_SQLCODE => SQLCODE
202: ,X_MSG_DATA => X_MSG_DATA
203: ,X_RETURN_STATUS => X_RETURN_STATUS);
204:
205: WHEN OTHERS THEN
206: JTF_DEBUG_PUB.HANDLE_EXCEPTIONS(
207: P_API_NAME => L_API_NAME
208: ,P_PKG_NAME => G_PKG_NAME
209: ,P_EXCEPTION_LEVEL => JTF_DEBUG_PUB.G_EXC_OTHERS
210: ,P_SQLCODE => SQLCODE
205: WHEN OTHERS THEN
206: JTF_DEBUG_PUB.HANDLE_EXCEPTIONS(
207: P_API_NAME => L_API_NAME
208: ,P_PKG_NAME => G_PKG_NAME
209: ,P_EXCEPTION_LEVEL => JTF_DEBUG_PUB.G_EXC_OTHERS
210: ,P_SQLCODE => SQLCODE
211: ,P_SQLERRM => SQLERRM
212: ,X_MSG_COUNT => X_MSG_COUNT
213: ,X_MSG_DATA => X_MSG_DATA