163: p_data => x_msg_data);
164: --
165: EXCEPTION
166: WHEN FND_API.G_EXC_ERROR THEN
167: JTF_PLSQL_API.HANDLE_EXCEPTIONS(P_API_NAME => L_API_NAME,
168: P_PKG_NAME => G_PKG_NAME,
169: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,
170: P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB,
171: X_MSG_COUNT => X_MSG_COUNT,
166: WHEN FND_API.G_EXC_ERROR THEN
167: JTF_PLSQL_API.HANDLE_EXCEPTIONS(P_API_NAME => L_API_NAME,
168: P_PKG_NAME => G_PKG_NAME,
169: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,
170: P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB,
171: X_MSG_COUNT => X_MSG_COUNT,
172: X_MSG_DATA => X_MSG_DATA,
173: X_RETURN_STATUS => X_RETURN_STATUS);
174: -- RAISE;
173: X_RETURN_STATUS => X_RETURN_STATUS);
174: -- RAISE;
175: --
176: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
177: JTF_PLSQL_API.HANDLE_EXCEPTIONS(P_API_NAME => L_API_NAME,
178: P_PKG_NAME => G_PKG_NAME,
179: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
180: P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB,
181: X_MSG_COUNT => X_MSG_COUNT,
176: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
177: JTF_PLSQL_API.HANDLE_EXCEPTIONS(P_API_NAME => L_API_NAME,
178: P_PKG_NAME => G_PKG_NAME,
179: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
180: P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB,
181: X_MSG_COUNT => X_MSG_COUNT,
182: X_MSG_DATA => X_MSG_DATA,
183: X_RETURN_STATUS => X_RETURN_STATUS);
184: -- RAISE;
183: X_RETURN_STATUS => X_RETURN_STATUS);
184: -- RAISE;
185: --
186: WHEN OTHERS THEN
187: JTF_PLSQL_API.HANDLE_EXCEPTIONS(P_API_NAME => L_API_NAME,
188: P_PKG_NAME => G_PKG_NAME,
189: P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS,
190: P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB,
191: X_MSG_COUNT => X_MSG_COUNT,
185: --
186: WHEN OTHERS THEN
187: JTF_PLSQL_API.HANDLE_EXCEPTIONS(P_API_NAME => L_API_NAME,
188: P_PKG_NAME => G_PKG_NAME,
189: P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS,
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);
186: WHEN OTHERS THEN
187: JTF_PLSQL_API.HANDLE_EXCEPTIONS(P_API_NAME => L_API_NAME,
188: P_PKG_NAME => G_PKG_NAME,
189: P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS,
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: -- RAISE;
259: p_data => x_msg_data);
260: --
261: EXCEPTION
262: WHEN FND_API.G_EXC_ERROR THEN
263: JTF_PLSQL_API.HANDLE_EXCEPTIONS(P_API_NAME => L_API_NAME,
264: P_PKG_NAME => G_PKG_NAME,
265: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,
266: P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB,
267: X_MSG_COUNT => X_MSG_COUNT,
262: WHEN FND_API.G_EXC_ERROR THEN
263: JTF_PLSQL_API.HANDLE_EXCEPTIONS(P_API_NAME => L_API_NAME,
264: P_PKG_NAME => G_PKG_NAME,
265: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,
266: P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB,
267: X_MSG_COUNT => X_MSG_COUNT,
268: X_MSG_DATA => X_MSG_DATA,
269: X_RETURN_STATUS => X_RETURN_STATUS);
270: -- RAISE;
269: X_RETURN_STATUS => X_RETURN_STATUS);
270: -- RAISE;
271: --
272: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
273: JTF_PLSQL_API.HANDLE_EXCEPTIONS(P_API_NAME => L_API_NAME,
274: P_PKG_NAME => G_PKG_NAME,
275: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
276: P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB,
277: X_MSG_COUNT => X_MSG_COUNT,
272: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
273: JTF_PLSQL_API.HANDLE_EXCEPTIONS(P_API_NAME => L_API_NAME,
274: P_PKG_NAME => G_PKG_NAME,
275: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_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: -- RAISE;
279: X_RETURN_STATUS => X_RETURN_STATUS);
280: -- RAISE;
281: --
282: WHEN OTHERS THEN
283: JTF_PLSQL_API.HANDLE_EXCEPTIONS(P_API_NAME => L_API_NAME,
284: P_PKG_NAME => G_PKG_NAME,
285: P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS,
286: P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB,
287: X_MSG_COUNT => X_MSG_COUNT,
281: --
282: WHEN OTHERS THEN
283: JTF_PLSQL_API.HANDLE_EXCEPTIONS(P_API_NAME => L_API_NAME,
284: P_PKG_NAME => G_PKG_NAME,
285: P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS,
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);
282: WHEN OTHERS THEN
283: JTF_PLSQL_API.HANDLE_EXCEPTIONS(P_API_NAME => L_API_NAME,
284: P_PKG_NAME => G_PKG_NAME,
285: P_EXCEPTION_LEVEL => JTF_PLSQL_API.G_EXC_OTHERS,
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: -- RAISE;