894: , p_data => x_msg_data);
895:
896: EXCEPTION
897: WHEN FND_API.G_EXC_ERROR THEN
898: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
899: P_API_NAME => L_API_NAME
900: ,P_PKG_NAME => G_PKG_NAME
901: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
902: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
898: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
899: P_API_NAME => L_API_NAME
900: ,P_PKG_NAME => G_PKG_NAME
901: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
902: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
903: ,X_MSG_COUNT => X_MSG_COUNT
904: ,X_MSG_DATA => X_MSG_DATA
905: ,X_RETURN_STATUS => X_RETURN_STATUS);
906: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
903: ,X_MSG_COUNT => X_MSG_COUNT
904: ,X_MSG_DATA => X_MSG_DATA
905: ,X_RETURN_STATUS => X_RETURN_STATUS);
906: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
907: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
908: P_API_NAME => L_API_NAME
909: ,P_PKG_NAME => G_PKG_NAME
910: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
911: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
907: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
908: P_API_NAME => L_API_NAME
909: ,P_PKG_NAME => G_PKG_NAME
910: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
911: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
912: ,X_MSG_COUNT => X_MSG_COUNT
913: ,X_MSG_DATA => X_MSG_DATA
914: ,X_RETURN_STATUS => X_RETURN_STATUS);
915: WHEN OTHERS THEN
2771:
2772: END If;
2773: EXCEPTION
2774: WHEN FND_API.G_EXC_ERROR THEN
2775: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2776: P_API_NAME => L_API_NAME
2777: ,P_PKG_NAME => G_PKG_NAME
2778: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2779: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
2775: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2776: P_API_NAME => L_API_NAME
2777: ,P_PKG_NAME => G_PKG_NAME
2778: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2779: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
2780: ,X_MSG_COUNT => X_MSG_COUNT
2781: ,X_MSG_DATA => X_MSG_DATA
2782: ,X_RETURN_STATUS => X_RETURN_STATUS);
2783: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2780: ,X_MSG_COUNT => X_MSG_COUNT
2781: ,X_MSG_DATA => X_MSG_DATA
2782: ,X_RETURN_STATUS => X_RETURN_STATUS);
2783: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2784: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2785: P_API_NAME => L_API_NAME
2786: ,P_PKG_NAME => G_PKG_NAME
2787: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2788: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
2784: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
2785: P_API_NAME => L_API_NAME
2786: ,P_PKG_NAME => G_PKG_NAME
2787: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2788: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
2789: ,X_MSG_COUNT => X_MSG_COUNT
2790: ,X_MSG_DATA => X_MSG_DATA
2791: ,X_RETURN_STATUS => X_RETURN_STATUS);
2792:
3143: , p_data => x_msg_data);
3144:
3145: EXCEPTION
3146: WHEN FND_API.G_EXC_ERROR THEN
3147: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
3148: P_API_NAME => L_API_NAME
3149: ,P_PKG_NAME => G_PKG_NAME
3150: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
3151: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
3147: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
3148: P_API_NAME => L_API_NAME
3149: ,P_PKG_NAME => G_PKG_NAME
3150: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
3151: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
3152: ,X_MSG_COUNT => X_MSG_COUNT
3153: ,X_MSG_DATA => X_MSG_DATA
3154: ,X_RETURN_STATUS => X_RETURN_STATUS);
3155: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3152: ,X_MSG_COUNT => X_MSG_COUNT
3153: ,X_MSG_DATA => X_MSG_DATA
3154: ,X_RETURN_STATUS => X_RETURN_STATUS);
3155: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3156: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
3157: P_API_NAME => L_API_NAME
3158: ,P_PKG_NAME => G_PKG_NAME
3159: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
3160: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
3156: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
3157: P_API_NAME => L_API_NAME
3158: ,P_PKG_NAME => G_PKG_NAME
3159: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
3160: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
3161: ,X_MSG_COUNT => X_MSG_COUNT
3162: ,X_MSG_DATA => X_MSG_DATA
3163: ,X_RETURN_STATUS => X_RETURN_STATUS);
3164: