DBA Data[Home] [Help]

APPS.ASO_PRICING_CORE_PVT dependencies on ASO_UTILITY_PVT

Line 9204: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

9200: p_data => x_msg_data
9201: );
9202: EXCEPTION
9203: WHEN FND_API.G_EXC_ERROR THEN
9204: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
9205: P_API_NAME => L_API_NAME
9206: ,P_PKG_NAME => G_PKG_NAME
9207: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
9208: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 9208: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

9204: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
9205: P_API_NAME => L_API_NAME
9206: ,P_PKG_NAME => G_PKG_NAME
9207: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
9208: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
9209: ,P_SQLCODE => SQLCODE
9210: ,P_SQLERRM => SQLERRM
9211: ,X_MSG_COUNT => X_MSG_COUNT
9212: ,X_MSG_DATA => X_MSG_DATA

Line 9216: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

9212: ,X_MSG_DATA => X_MSG_DATA
9213: ,X_RETURN_STATUS => X_RETURN_STATUS);
9214:
9215: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9216: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
9217: P_API_NAME => L_API_NAME
9218: ,P_PKG_NAME => G_PKG_NAME
9219: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
9220: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 9220: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

9216: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
9217: P_API_NAME => L_API_NAME
9218: ,P_PKG_NAME => G_PKG_NAME
9219: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
9220: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
9221: ,P_SQLCODE => SQLCODE
9222: ,P_SQLERRM => SQLERRM
9223: ,X_MSG_COUNT => X_MSG_COUNT
9224: ,X_MSG_DATA => X_MSG_DATA

Line 9228: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

9224: ,X_MSG_DATA => X_MSG_DATA
9225: ,X_RETURN_STATUS => X_RETURN_STATUS);
9226:
9227: WHEN OTHERS THEN
9228: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
9229: P_API_NAME => L_API_NAME
9230: ,P_PKG_NAME => G_PKG_NAME
9231: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
9232: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 9231: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS

9227: WHEN OTHERS THEN
9228: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
9229: P_API_NAME => L_API_NAME
9230: ,P_PKG_NAME => G_PKG_NAME
9231: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
9232: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
9233: ,P_SQLCODE => SQLCODE
9234: ,P_SQLERRM => SQLERRM
9235: ,X_MSG_COUNT => X_MSG_COUNT

Line 9232: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

9228: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
9229: P_API_NAME => L_API_NAME
9230: ,P_PKG_NAME => G_PKG_NAME
9231: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
9232: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
9233: ,P_SQLCODE => SQLCODE
9234: ,P_SQLERRM => SQLERRM
9235: ,X_MSG_COUNT => X_MSG_COUNT
9236: ,X_MSG_DATA => X_MSG_DATA

Line 10557: ls_qte_line_tbl := ASO_UTILITY_PVT.Query_Qte_Line_Rows(p_qte_header_rec.quote_header_id);

10553: --Should not update the line levelfeight charges as in Calculate only call we only get updated order level modifiers
10554:
10555: If p_control_rec.calculate_flag <> QP_PREQ_GRP.G_CALCULATE_ONLY then
10556: /*Query the line table to pass it to ASO_SHIPPING_INT*/
10557: ls_qte_line_tbl := ASO_UTILITY_PVT.Query_Qte_Line_Rows(p_qte_header_rec.quote_header_id);
10558: FOR i IN 1..ls_qte_line_tbl.count LOOP
10559: l_line_shipping_charge := ASO_SHIPPING_INT.get_line_freight_charges
10560: (p_qte_header_rec.quote_header_id,ls_qte_line_tbl(i).quote_line_id);
10561: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

Line 11356: l_qte_line_rec := ASO_UTILITY_PVT.Query_Qte_Line_Row(lx_Qte_Line_Tbl(i).quote_line_id);

11352: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
11353: aso_debug_pub.add('ASO_PRICING_CORE_PVT:Before Query_Qte_Line_Row utility lx_Qte_Line_Tbl(i).quote_line_id:'
11354: ||lx_Qte_Line_Tbl(i).quote_line_id,1,'Y');
11355: END IF;
11356: l_qte_line_rec := ASO_UTILITY_PVT.Query_Qte_Line_Row(lx_Qte_Line_Tbl(i).quote_line_id);
11357:
11358: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
11359: aso_debug_pub.add('ASO_PRICING_CORE_PVT: Start of Query_Shipment_Rows..',1,'Y');
11360: END IF;

Line 11361: l_shipment_tbl := ASO_UTILITY_PVT.Query_Shipment_Rows

11357:
11358: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
11359: aso_debug_pub.add('ASO_PRICING_CORE_PVT: Start of Query_Shipment_Rows..',1,'Y');
11360: END IF;
11361: l_shipment_tbl := ASO_UTILITY_PVT.Query_Shipment_Rows
11362: (p_qte_header_rec.quote_header_id, lx_Qte_Line_Tbl(i).quote_line_id);
11363: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
11364: aso_debug_pub.add('ASO_PRICING_CORE_PVT: l_shipment_tbl.count :'
11365: ||NVL(l_shipment_tbl.count,0),1,'Y');