DBA Data[Home] [Help]

APPS.ASO_PRICING_CORE_PVT dependencies on ASO_UTILITY_PVT

Line 9220: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

9216: p_data => x_msg_data
9217: );
9218: EXCEPTION
9219: WHEN FND_API.G_EXC_ERROR THEN
9220: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
9221: P_API_NAME => L_API_NAME
9222: ,P_PKG_NAME => G_PKG_NAME
9223: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
9224: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 9224: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

9220: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
9221: P_API_NAME => L_API_NAME
9222: ,P_PKG_NAME => G_PKG_NAME
9223: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
9224: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
9225: ,P_SQLCODE => SQLCODE
9226: ,P_SQLERRM => SQLERRM
9227: ,X_MSG_COUNT => X_MSG_COUNT
9228: ,X_MSG_DATA => X_MSG_DATA

Line 9232: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

9228: ,X_MSG_DATA => X_MSG_DATA
9229: ,X_RETURN_STATUS => X_RETURN_STATUS);
9230:
9231: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9232: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
9233: P_API_NAME => L_API_NAME
9234: ,P_PKG_NAME => G_PKG_NAME
9235: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
9236: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 9236: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

9232: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
9233: P_API_NAME => L_API_NAME
9234: ,P_PKG_NAME => G_PKG_NAME
9235: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
9236: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
9237: ,P_SQLCODE => SQLCODE
9238: ,P_SQLERRM => SQLERRM
9239: ,X_MSG_COUNT => X_MSG_COUNT
9240: ,X_MSG_DATA => X_MSG_DATA

Line 9244: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

9240: ,X_MSG_DATA => X_MSG_DATA
9241: ,X_RETURN_STATUS => X_RETURN_STATUS);
9242:
9243: WHEN OTHERS THEN
9244: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
9245: P_API_NAME => L_API_NAME
9246: ,P_PKG_NAME => G_PKG_NAME
9247: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
9248: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 9247: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS

9243: WHEN OTHERS THEN
9244: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
9245: P_API_NAME => L_API_NAME
9246: ,P_PKG_NAME => G_PKG_NAME
9247: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
9248: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
9249: ,P_SQLCODE => SQLCODE
9250: ,P_SQLERRM => SQLERRM
9251: ,X_MSG_COUNT => X_MSG_COUNT

Line 9248: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

9244: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
9245: P_API_NAME => L_API_NAME
9246: ,P_PKG_NAME => G_PKG_NAME
9247: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
9248: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
9249: ,P_SQLCODE => SQLCODE
9250: ,P_SQLERRM => SQLERRM
9251: ,X_MSG_COUNT => X_MSG_COUNT
9252: ,X_MSG_DATA => X_MSG_DATA

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

10570: --Should not update the line levelfeight charges as in Calculate only call we only get updated order level modifiers
10571:
10572: If p_control_rec.calculate_flag <> QP_PREQ_GRP.G_CALCULATE_ONLY then
10573: /*Query the line table to pass it to ASO_SHIPPING_INT*/
10574: ls_qte_line_tbl := ASO_UTILITY_PVT.Query_Qte_Line_Rows(p_qte_header_rec.quote_header_id);
10575: FOR i IN 1..ls_qte_line_tbl.count LOOP
10576: l_line_shipping_charge := ASO_SHIPPING_INT.get_line_freight_charges
10577: (p_qte_header_rec.quote_header_id,ls_qte_line_tbl(i).quote_line_id);
10578: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

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

11369: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
11370: aso_debug_pub.add('ASO_PRICING_CORE_PVT:Before Query_Qte_Line_Row utility lx_Qte_Line_Tbl(i).quote_line_id:'
11371: ||lx_Qte_Line_Tbl(i).quote_line_id,1,'Y');
11372: END IF;
11373: l_qte_line_rec := ASO_UTILITY_PVT.Query_Qte_Line_Row(lx_Qte_Line_Tbl(i).quote_line_id);
11374:
11375: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
11376: aso_debug_pub.add('ASO_PRICING_CORE_PVT: Start of Query_Shipment_Rows..',1,'Y');
11377: END IF;

Line 11378: l_shipment_tbl := ASO_UTILITY_PVT.Query_Shipment_Rows

11374:
11375: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
11376: aso_debug_pub.add('ASO_PRICING_CORE_PVT: Start of Query_Shipment_Rows..',1,'Y');
11377: END IF;
11378: l_shipment_tbl := ASO_UTILITY_PVT.Query_Shipment_Rows
11379: (p_qte_header_rec.quote_header_id, lx_Qte_Line_Tbl(i).quote_line_id);
11380: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
11381: aso_debug_pub.add('ASO_PRICING_CORE_PVT: l_shipment_tbl.count :'
11382: ||NVL(l_shipment_tbl.count,0),1,'Y');