364:
365: WHEN FND_API.G_EXC_ERROR THEN
366: x_return_status := FND_API.G_RET_STS_ERROR;
367:
368: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
369: P_API_NAME => L_API_NAME
370: ,P_PKG_NAME => G_PKG_NAME
371: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
372: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT
368: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
369: P_API_NAME => L_API_NAME
370: ,P_PKG_NAME => G_PKG_NAME
371: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
372: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT
373: ,X_MSG_COUNT => X_MSG_COUNT
374: ,X_MSG_DATA => X_MSG_DATA
375: ,X_RETURN_STATUS => X_RETURN_STATUS);
376:
377: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
378: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
379:
380:
381: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
382: P_API_NAME => L_API_NAME
383: ,P_PKG_NAME => G_PKG_NAME
384: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
385: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT
381: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
382: P_API_NAME => L_API_NAME
383: ,P_PKG_NAME => G_PKG_NAME
384: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
385: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT
386: ,X_MSG_COUNT => X_MSG_COUNT
387: ,X_MSG_DATA => X_MSG_DATA
388: ,X_RETURN_STATUS => X_RETURN_STATUS);
389:
389:
390: WHEN OTHERS THEN
391: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
392:
393: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
394: P_API_NAME => L_API_NAME
395: ,P_PKG_NAME => G_PKG_NAME
396: ,P_SQLERRM => sqlerrm
397: ,P_SQLCODE => sqlcode
394: P_API_NAME => L_API_NAME
395: ,P_PKG_NAME => G_PKG_NAME
396: ,P_SQLERRM => sqlerrm
397: ,P_SQLCODE => sqlcode
398: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
399: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT
400: ,X_MSG_COUNT => X_MSG_COUNT
401: ,X_MSG_DATA => X_MSG_DATA
402: ,X_RETURN_STATUS => X_RETURN_STATUS);
395: ,P_PKG_NAME => G_PKG_NAME
396: ,P_SQLERRM => sqlerrm
397: ,P_SQLCODE => sqlcode
398: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
399: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT
400: ,X_MSG_COUNT => X_MSG_COUNT
401: ,X_MSG_DATA => X_MSG_DATA
402: ,X_RETURN_STATUS => X_RETURN_STATUS);
403:
644: EXCEPTION
645: WHEN FND_API.G_EXC_ERROR THEN
646: x_return_status := FND_API.G_RET_STS_ERROR;
647:
648: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
649: P_API_NAME => L_API_NAME
650: ,P_PKG_NAME => G_PKG_NAME
651: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
652: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT
648: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
649: P_API_NAME => L_API_NAME
650: ,P_PKG_NAME => G_PKG_NAME
651: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
652: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT
653: ,X_MSG_COUNT => X_MSG_COUNT
654: ,X_MSG_DATA => X_MSG_DATA
655: ,X_RETURN_STATUS => X_RETURN_STATUS);
656:
657: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
658: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
659:
660:
661: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
662: P_API_NAME => L_API_NAME
663: ,P_PKG_NAME => G_PKG_NAME
664: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
665: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT
661: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
662: P_API_NAME => L_API_NAME
663: ,P_PKG_NAME => G_PKG_NAME
664: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
665: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT
666: ,X_MSG_COUNT => X_MSG_COUNT
667: ,X_MSG_DATA => X_MSG_DATA
668: ,X_RETURN_STATUS => X_RETURN_STATUS);
669:
669:
670: WHEN OTHERS THEN
671: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
672:
673: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
674: P_API_NAME => L_API_NAME
675: ,P_PKG_NAME => G_PKG_NAME
676: ,P_SQLERRM => sqlerrm
677: ,P_SQLCODE => sqlcode
674: P_API_NAME => L_API_NAME
675: ,P_PKG_NAME => G_PKG_NAME
676: ,P_SQLERRM => sqlerrm
677: ,P_SQLCODE => sqlcode
678: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
679: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT
680: ,X_MSG_COUNT => X_MSG_COUNT
681: ,X_MSG_DATA => X_MSG_DATA
682: ,X_RETURN_STATUS => X_RETURN_STATUS);
675: ,P_PKG_NAME => G_PKG_NAME
676: ,P_SQLERRM => sqlerrm
677: ,P_SQLCODE => sqlcode
678: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
679: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT
680: ,X_MSG_COUNT => X_MSG_COUNT
681: ,X_MSG_DATA => X_MSG_DATA
682: ,X_RETURN_STATUS => X_RETURN_STATUS);
683: end batch_pricing;
794: EXCEPTION
795: WHEN FND_API.G_EXC_ERROR THEN
796: x_return_status := FND_API.G_RET_STS_ERROR;
797:
798: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
799: P_API_NAME => L_API_NAME
800: ,P_PKG_NAME => G_PKG_NAME
801: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
802: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT
798: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
799: P_API_NAME => L_API_NAME
800: ,P_PKG_NAME => G_PKG_NAME
801: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
802: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT
803: ,X_MSG_COUNT => X_MSG_COUNT
804: ,X_MSG_DATA => X_MSG_DATA
805: ,X_RETURN_STATUS => X_RETURN_STATUS);
806:
806:
807: WHEN OTHERS THEN
808: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
809:
810: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
811: P_API_NAME => L_API_NAME
812: ,P_PKG_NAME => G_PKG_NAME
813: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
814: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT
810: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
811: P_API_NAME => L_API_NAME
812: ,P_PKG_NAME => G_PKG_NAME
813: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
814: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT
815: ,X_MSG_COUNT => X_MSG_COUNT
816: ,X_MSG_DATA => X_MSG_DATA
817: ,X_RETURN_STATUS => X_RETURN_STATUS);
818: