183: ); */
184:
185: EXCEPTION
186: WHEN FND_API.G_EXC_ERROR THEN
187: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
188: P_API_NAME => L_API_NAME
189: ,P_PKG_NAME => G_PKG_NAME
190: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
191: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
187: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
188: P_API_NAME => L_API_NAME
189: ,P_PKG_NAME => G_PKG_NAME
190: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
191: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
192: ,X_MSG_COUNT => X_MSG_COUNT
193: ,X_MSG_DATA => X_MSG_DATA
194: ,X_RETURN_STATUS => X_RETURN_STATUS);
195: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
192: ,X_MSG_COUNT => X_MSG_COUNT
193: ,X_MSG_DATA => X_MSG_DATA
194: ,X_RETURN_STATUS => X_RETURN_STATUS);
195: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
196: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
197: P_API_NAME => L_API_NAME
198: ,P_PKG_NAME => G_PKG_NAME
199: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
200: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
196: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
197: P_API_NAME => L_API_NAME
198: ,P_PKG_NAME => G_PKG_NAME
199: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
200: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
201: ,X_MSG_COUNT => X_MSG_COUNT
202: ,X_MSG_DATA => X_MSG_DATA
203: ,X_RETURN_STATUS => X_RETURN_STATUS);
204: WHEN OTHERS THEN
486: );
487:
488: EXCEPTION
489: WHEN FND_API.G_EXC_ERROR THEN
490: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
491: P_API_NAME => L_API_NAME
492: ,P_PKG_NAME => G_PKG_NAME
493: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
494: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
490: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
491: P_API_NAME => L_API_NAME
492: ,P_PKG_NAME => G_PKG_NAME
493: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
494: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
495: ,X_MSG_COUNT => X_MSG_COUNT
496: ,X_MSG_DATA => X_MSG_DATA
497: ,X_RETURN_STATUS => X_RETURN_STATUS);
498: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
495: ,X_MSG_COUNT => X_MSG_COUNT
496: ,X_MSG_DATA => X_MSG_DATA
497: ,X_RETURN_STATUS => X_RETURN_STATUS);
498: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
499: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
500: P_API_NAME => L_API_NAME
501: ,P_PKG_NAME => G_PKG_NAME
502: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
503: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
499: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
500: P_API_NAME => L_API_NAME
501: ,P_PKG_NAME => G_PKG_NAME
502: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
503: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
504: ,X_MSG_COUNT => X_MSG_COUNT
505: ,X_MSG_DATA => X_MSG_DATA
506: ,X_RETURN_STATUS => X_RETURN_STATUS);
507: WHEN OTHERS THEN
597: );
598:
599: EXCEPTION
600: WHEN FND_API.G_EXC_ERROR THEN
601: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
602: P_API_NAME => L_API_NAME
603: ,P_PKG_NAME => G_PKG_NAME
604: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
605: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
601: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
602: P_API_NAME => L_API_NAME
603: ,P_PKG_NAME => G_PKG_NAME
604: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
605: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
606: ,X_MSG_COUNT => X_MSG_COUNT
607: ,X_MSG_DATA => X_MSG_DATA
608: ,X_RETURN_STATUS => X_RETURN_STATUS);
609: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
606: ,X_MSG_COUNT => X_MSG_COUNT
607: ,X_MSG_DATA => X_MSG_DATA
608: ,X_RETURN_STATUS => X_RETURN_STATUS);
609: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
610: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
611: P_API_NAME => L_API_NAME
612: ,P_PKG_NAME => G_PKG_NAME
613: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
614: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
610: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
611: P_API_NAME => L_API_NAME
612: ,P_PKG_NAME => G_PKG_NAME
613: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
614: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
615: ,X_MSG_COUNT => X_MSG_COUNT
616: ,X_MSG_DATA => X_MSG_DATA
617: ,X_RETURN_STATUS => X_RETURN_STATUS);
618: WHEN OTHERS THEN