APPS.ASO_VALIDATE_PRICING_PVT dependencies on ASO_UTILITY_PVT

Line 379: l_qte_line_tbl := ASO_UTILITY_PVT.Query_Qte_Line_Rows(p_qte_header_rec.quote_header_id);

375: aso_debug_pub.add('p_qte_header_rec.quote_header_id:'||p_qte_header_rec.quote_header_id,1,'N');
376: END IF;
377:
378: If p_qte_line_tbl.count = 0 then
379: l_qte_line_tbl := ASO_UTILITY_PVT.Query_Qte_Line_Rows(p_qte_header_rec.quote_header_id);
380: Else
381: l_qte_line_tbl := p_qte_line_tbl;
382: End If;
383:

Line 413: l_qte_line_dtl_tbl := ASO_UTILITY_PVT.Query_Line_Dtl_Rows(l_qte_line_id);

409: End if;
410:
411: /*Query Detail Line tbl and shipment*/
412: If l_call_flg = 'Q' then
413: l_qte_line_dtl_tbl := ASO_UTILITY_PVT.Query_Line_Dtl_Rows(l_qte_line_id);
414: If l_qte_line_dtl_tbl.count >0 then
415: l_srv_line_dtl_tbl(l_srv_line_dtl_tbl.count+1):= l_qte_line_dtl_tbl(1);
416: end if;
417:

Line 423: l_shipment_tbl := ASO_UTILITY_PVT.Query_Shipment_Rows(p_qte_header_rec.quote_header_id,

419: IF l_qte_line_dtl_tbl.count = 1 THEN
420: l_qte_line_dtl_rec := l_qte_line_dtl_tbl(1);
421: END IF;
422:
423: l_shipment_tbl := ASO_UTILITY_PVT.Query_Shipment_Rows(p_qte_header_rec.quote_header_id,
424: l_qte_line_id);
425: l_shipment_rec := ASO_QUOTE_PUB.G_Miss_Shipment_rec;
426: IF l_shipment_tbl.count = 1 THEN
427: l_shipment_rec := l_shipment_tbl(1);

Line 683: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

679: WHEN FND_API.G_EXC_ERROR THEN
680: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
681: aso_debug_pub.add('after inside EXCEPTION return status'||x_return_status, 1, 'Y');
682: END IF;
683: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
684: P_API_NAME => L_API_NAME
685: ,P_PKG_NAME => G_PKG_NAME
686: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
687: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 687: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

683: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
684: P_API_NAME => L_API_NAME
685: ,P_PKG_NAME => G_PKG_NAME
686: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
687: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
688: ,P_SQLCODE => SQLCODE
689: ,P_SQLERRM => SQLERRM
690: ,X_MSG_COUNT => X_MSG_COUNT
691: ,X_MSG_DATA => X_MSG_DATA

Line 695: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

691: ,X_MSG_DATA => X_MSG_DATA
692: ,X_RETURN_STATUS => X_RETURN_STATUS);
693:
694: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
695: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
696: P_API_NAME => L_API_NAME
697: ,P_PKG_NAME => G_PKG_NAME
698: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
699: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 699: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

695: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
696: P_API_NAME => L_API_NAME
697: ,P_PKG_NAME => G_PKG_NAME
698: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
699: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
700: ,P_SQLCODE => SQLCODE
701: ,P_SQLERRM => SQLERRM
702: ,X_MSG_COUNT => X_MSG_COUNT
703: ,X_MSG_DATA => X_MSG_DATA

Line 707: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

703: ,X_MSG_DATA => X_MSG_DATA
704: ,X_RETURN_STATUS => X_RETURN_STATUS);
705:
706: WHEN OTHERS THEN
707: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
708: P_API_NAME => L_API_NAME
709: ,P_PKG_NAME => G_PKG_NAME
710: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
711: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 710: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS

706: WHEN OTHERS THEN
707: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
708: P_API_NAME => L_API_NAME
709: ,P_PKG_NAME => G_PKG_NAME
710: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
711: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
712: ,P_SQLCODE => SQLCODE
713: ,P_SQLERRM => SQLERRM
714: ,X_MSG_COUNT => X_MSG_COUNT

Line 711: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

707: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
708: P_API_NAME => L_API_NAME
709: ,P_PKG_NAME => G_PKG_NAME
710: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
711: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
712: ,P_SQLCODE => SQLCODE
713: ,P_SQLERRM => SQLERRM
714: ,X_MSG_COUNT => X_MSG_COUNT
715: ,X_MSG_DATA => X_MSG_DATA