eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ASO_COPY_QUOTE_PVT dependencies on ASO_UTILITY_PVT

Line 316: l_qte_header_rec := ASO_UTILITY_PVT.Query_Header_Row ( P_Copy_Quote_Header_Rec.Quote_Header_Id );

312: aso_debug_pub.ADD ( 'Copy_Quote - P_Copy_Quote_Header_Rec.Quote_Name ' || P_Copy_Quote_Header_Rec.Quote_Name , 1 , 'N' );
313:
314: END IF;
315:
316: l_qte_header_rec := ASO_UTILITY_PVT.Query_Header_Row ( P_Copy_Quote_Header_Rec.Quote_Header_Id );
317:
318: /* Code change for Quoting Usability Sun ER Start */
319: If P_Copy_Quote_Control_Rec.Copy_To_Same_Customer = FND_API.G_FALSE Then
320:

Line 1185: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS (

1181: );
1182:
1183: EXCEPTION
1184: WHEN FND_API.G_EXC_ERROR THEN
1185: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS (
1186: P_API_NAME => L_API_NAME
1187: , P_PKG_NAME => G_PKG_NAME
1188: , P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1189: , P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 1189: , P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

1185: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS (
1186: P_API_NAME => L_API_NAME
1187: , P_PKG_NAME => G_PKG_NAME
1188: , P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1189: , P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
1190: , X_MSG_COUNT => X_MSG_COUNT
1191: , X_MSG_DATA => X_MSG_DATA
1192: , X_RETURN_STATUS => X_RETURN_STATUS
1193: );

Line 1196: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS (

1192: , X_RETURN_STATUS => X_RETURN_STATUS
1193: );
1194:
1195: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1196: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS (
1197: P_API_NAME => L_API_NAME
1198: , P_PKG_NAME => G_PKG_NAME
1199: , P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1200: , P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 1200: , P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

1196: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS (
1197: P_API_NAME => L_API_NAME
1198: , P_PKG_NAME => G_PKG_NAME
1199: , P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1200: , P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
1201: , X_MSG_COUNT => X_MSG_COUNT
1202: , X_MSG_DATA => X_MSG_DATA
1203: , X_RETURN_STATUS => X_RETURN_STATUS
1204: );

Line 1207: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS (

1203: , X_RETURN_STATUS => X_RETURN_STATUS
1204: );
1205:
1206: WHEN OTHERS THEN
1207: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS (
1208: P_API_NAME => L_API_NAME
1209: , P_PKG_NAME => G_PKG_NAME
1210: , P_SQLCODE => SQLCODE
1211: , P_SQLERRM => SQLERRM

Line 1212: , P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS

1208: P_API_NAME => L_API_NAME
1209: , P_PKG_NAME => G_PKG_NAME
1210: , P_SQLCODE => SQLCODE
1211: , P_SQLERRM => SQLERRM
1212: , P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
1213: , P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
1214: , X_MSG_COUNT => X_MSG_COUNT
1215: , X_MSG_DATA => X_MSG_DATA
1216: , X_RETURN_STATUS => X_RETURN_STATUS

Line 1213: , P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

1209: , P_PKG_NAME => G_PKG_NAME
1210: , P_SQLCODE => SQLCODE
1211: , P_SQLERRM => SQLERRM
1212: , P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
1213: , P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
1214: , X_MSG_COUNT => X_MSG_COUNT
1215: , X_MSG_DATA => X_MSG_DATA
1216: , X_RETURN_STATUS => X_RETURN_STATUS
1217: );

Line 1362: l_shipment_tbl := ASO_UTILITY_PVT.Query_Shipment_Rows (

1358: --
1359:
1360: /* Code change for Quoting Usability Sun ER Start */
1361:
1362: l_shipment_tbl := ASO_UTILITY_PVT.Query_Shipment_Rows (
1363: p_qte_header_id => l_qte_header_id,
1364: p_qte_line_id => NULL );
1365:
1366: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 1370: l_freight_charge_tbl := ASO_UTILITY_PVT.Query_Freight_Charge_Rows (

1366: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1367: aso_debug_pub.ADD ( 'Copy_Header_Rows - l_shipment_tbl.count: ' || TO_CHAR ( l_shipment_tbl.COUNT ) , 1 , 'N' );
1368: END IF;
1369:
1370: l_freight_charge_tbl := ASO_UTILITY_PVT.Query_Freight_Charge_Rows (
1371: P_Shipment_Tbl => l_shipment_tbl );
1372:
1373: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1374: aso_debug_pub.ADD ( 'Copy_Header_Rows - l_freight_charge_tbl.count: ' || TO_CHAR ( l_freight_charge_tbl.COUNT ) , 1 , 'N' );

Line 1377: l_tax_detail_tbl := ASO_UTILITY_PVT.Query_Tax_Detail_Rows (

1373: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1374: aso_debug_pub.ADD ( 'Copy_Header_Rows - l_freight_charge_tbl.count: ' || TO_CHAR ( l_freight_charge_tbl.COUNT ) , 1 , 'N' );
1375: END IF;
1376:
1377: l_tax_detail_tbl := ASO_UTILITY_PVT.Query_Tax_Detail_Rows (
1378: p_qte_header_id => l_qte_header_id,
1379: p_qte_line_id => NULL,
1380: p_shipment_tbl => ASO_QUOTE_PUB.g_miss_shipment_tbl );
1381:

Line 1394: ASO_UTILITY_PVT.Query_Price_Adj_Rows (

1390: aso_debug_pub.ADD ( 'Copy_Header_Rows - P_Copy_Quote_Control_Rec.Copy_To_Same_Customer is True ', 1 , 'N' );
1391: END IF;
1392:
1393: l_price_adj_tbl :=
1394: ASO_UTILITY_PVT.Query_Price_Adj_Rows (
1395: p_qte_header_id => l_qte_header_id
1396: , p_qte_line_id => NULL
1397: );
1398:

Line 1402: ASO_UTILITY_PVT.Query_Price_Adj_Attr_Rows (

1398:
1399: l_dup_Price_Adj_Tbl := l_price_adj_tbl;
1400:
1401: l_price_adj_attr_tbl :=
1402: ASO_UTILITY_PVT.Query_Price_Adj_Attr_Rows (
1403: p_price_adj_tbl => l_price_adj_tbl
1404: );
1405:
1406: l_price_attr_tbl :=

Line 1407: ASO_UTILITY_PVT.Query_Price_Attr_Rows (

1403: p_price_adj_tbl => l_price_adj_tbl
1404: );
1405:
1406: l_price_attr_tbl :=
1407: ASO_UTILITY_PVT.Query_Price_Attr_Rows (
1408: p_qte_header_id => l_qte_header_id
1409: , p_qte_line_id => NULL
1410: );
1411:

Line 1413: ASO_UTILITY_PVT.Query_Payment_Rows (

1409: , p_qte_line_id => NULL
1410: );
1411:
1412: /* l_payment_tbl :=
1413: ASO_UTILITY_PVT.Query_Payment_Rows (
1414: p_qte_header_id => l_qte_header_id
1415: , p_qte_line_id => NULL
1416: );
1417:

Line 1485: l_sales_credit_tbl := ASO_UTILITY_PVT.Query_Sales_Credit_Row (

1481: l_qte_header_rec.END_CUSTOMER_CUST_PARTY_ID := Null;
1482: End If;
1483:
1484: If P_Copy_Quote_Control_Rec.Copy_Sales_Credit = FND_API.G_TRUE Then
1485: l_sales_credit_tbl := ASO_UTILITY_PVT.Query_Sales_Credit_Row (
1486: P_qte_header_Id => l_qte_header_id ,
1487: P_qte_line_id => NULL );
1488:
1489: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 1549: l_sales_credit_tbl := ASO_UTILITY_PVT.Query_Sales_Credit_Row (

1545: l_price_adj_attr_tbl := aso_quote_pub.g_miss_price_adj_attr_tbl;
1546:
1547: l_price_attr_tbl := aso_quote_pub.g_miss_price_attributes_tbl;
1548:
1549: l_sales_credit_tbl := ASO_UTILITY_PVT.Query_Sales_Credit_Row (
1550: P_qte_header_Id => l_qte_header_id ,
1551: P_qte_line_id => NULL );
1552:
1553: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 1584: ASO_UTILITY_PVT.Query_Line_Attribs_header_Rows (

1580: End If;
1581: /* Code change for Quoting Usability Sun ER End */
1582:
1583: l_Line_Attr_Ext_Tbl :=
1584: ASO_UTILITY_PVT.Query_Line_Attribs_header_Rows (
1585: P_Qte_header_Id => l_qte_header_id
1586: );
1587: /*
1588: l_sales_credit_tbl :=

Line 1589: ASO_UTILITY_PVT.Query_Sales_Credit_Row (

1585: P_Qte_header_Id => l_qte_header_id
1586: );
1587: /*
1588: l_sales_credit_tbl :=
1589: ASO_UTILITY_PVT.Query_Sales_Credit_Row (
1590: P_qte_header_Id => l_qte_header_id
1591: , P_qte_line_id => NULL
1592: );
1593: */

Line 1595: ASO_UTILITY_PVT.Query_Quote_Party_Row (

1591: , P_qte_line_id => NULL
1592: );
1593: */
1594: l_quote_party_tbl :=
1595: ASO_UTILITY_PVT.Query_Quote_Party_Row (
1596: P_Qte_header_Id => l_qte_header_id
1597: , P_qte_line_id => NULL
1598: );
1599:

Line 1758: l_payment_tbl := ASO_UTILITY_PVT.Query_Payment_Rows(p_qte_header_id =>l_qte_header_id,p_qte_line_id =>NULL);

1754:
1755: x_qte_header_id := l_qte_header_rec.quote_header_id;
1756:
1757: -- Copy the header payment record
1758: l_payment_tbl := ASO_UTILITY_PVT.Query_Payment_Rows(p_qte_header_id =>l_qte_header_id,p_qte_line_id =>NULL);
1759:
1760: IF l_payment_tbl.count > 0 then
1761:
1762: FOR j IN 1 .. l_payment_tbl.COUNT LOOP

Line 2249: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS (

2245:
2246: EXCEPTION
2247:
2248: WHEN FND_API.G_EXC_ERROR THEN
2249: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS (
2250: P_API_NAME => L_API_NAME
2251: , P_PKG_NAME => G_PKG_NAME
2252: , P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2253: , P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 2253: , P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

2249: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS (
2250: P_API_NAME => L_API_NAME
2251: , P_PKG_NAME => G_PKG_NAME
2252: , P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2253: , P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
2254: , X_MSG_COUNT => X_MSG_COUNT
2255: , X_MSG_DATA => X_MSG_DATA
2256: , X_RETURN_STATUS => X_RETURN_STATUS
2257: );

Line 2260: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS (

2256: , X_RETURN_STATUS => X_RETURN_STATUS
2257: );
2258:
2259: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2260: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS (
2261: P_API_NAME => L_API_NAME
2262: , P_PKG_NAME => G_PKG_NAME
2263: , P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2264: , P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 2264: , P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

2260: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS (
2261: P_API_NAME => L_API_NAME
2262: , P_PKG_NAME => G_PKG_NAME
2263: , P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2264: , P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
2265: , X_MSG_COUNT => X_MSG_COUNT
2266: , X_MSG_DATA => X_MSG_DATA
2267: , X_RETURN_STATUS => X_RETURN_STATUS
2268: );

Line 2271: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS (

2267: , X_RETURN_STATUS => X_RETURN_STATUS
2268: );
2269:
2270: WHEN OTHERS THEN
2271: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS (
2272: P_API_NAME => L_API_NAME
2273: , P_PKG_NAME => G_PKG_NAME
2274: , P_SQLCODE => SQLCODE
2275: , P_SQLERRM => SQLERRM

Line 2276: , P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS

2272: P_API_NAME => L_API_NAME
2273: , P_PKG_NAME => G_PKG_NAME
2274: , P_SQLCODE => SQLCODE
2275: , P_SQLERRM => SQLERRM
2276: , P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
2277: , P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
2278: , X_MSG_COUNT => X_MSG_COUNT
2279: , X_MSG_DATA => X_MSG_DATA
2280: , X_RETURN_STATUS => X_RETURN_STATUS

Line 2277: , P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

2273: , P_PKG_NAME => G_PKG_NAME
2274: , P_SQLCODE => SQLCODE
2275: , P_SQLERRM => SQLERRM
2276: , P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
2277: , P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
2278: , X_MSG_COUNT => X_MSG_COUNT
2279: , X_MSG_DATA => X_MSG_DATA
2280: , X_RETURN_STATUS => X_RETURN_STATUS
2281: );

Line 2595: ASO_UTILITY_PVT.Query_Qte_Line_Rows ( p_qte_header_id );

2591: END IF;
2592:
2593:
2594: l_qte_line_tbl :=
2595: ASO_UTILITY_PVT.Query_Qte_Line_Rows ( p_qte_header_id );
2596:
2597: /* Code change for Quoting Usability Sun ER Start */
2598:
2599: If P_Copy_Quote_Control_Rec.Copy_To_Same_Customer = FND_API.G_FALSE Then

Line 2641: l_shipment_tbl := ASO_UTILITY_PVT.Query_Shipment_Rows(l_qte_line_tbl(i).quote_header_id,l_qte_line_tbl(i).quote_line_id);

2637: l_qte_line_tbl(i).AGREEMENT_ID := Null;
2638: End If;
2639: End If;
2640:
2641: l_shipment_tbl := ASO_UTILITY_PVT.Query_Shipment_Rows(l_qte_line_tbl(i).quote_header_id,l_qte_line_tbl(i).quote_line_id);
2642:
2643: IF (l_shipment_tbl.COUNT > 0) then
2644: l_shipment_tbl(1).SHIP_TO_CUST_ACCOUNT_ID := Null;
2645: l_shipment_tbl(1).SHIP_TO_CUST_PARTY_ID := Null;

Line 2665: l_payment_tbl := ASO_UTILITY_PVT.Query_Payment_Rows(l_qte_line_tbl(i).quote_header_id,l_qte_line_tbl(i).quote_line_id);

2661: l_shipment_tbl(1).SHIP_TO_PROVINCE := Null;
2662: l_shipment_tbl(1).SHIP_TO_COUNTY := Null;
2663: END IF;
2664:
2665: l_payment_tbl := ASO_UTILITY_PVT.Query_Payment_Rows(l_qte_line_tbl(i).quote_header_id,l_qte_line_tbl(i).quote_line_id);
2666:
2667: IF (l_payment_tbl.COUNT > 0) then
2668: If l_payment_tbl(1).PAYMENT_TYPE_CODE In ('CHECK','CREDIT_CARD') Then
2669: If l_payment_tbl(1).PAYMENT_TYPE_CODE = 'CREDIT_CARD' Then

Line 2848: l_qte_line_rec := ASO_UTILITY_PVT.Query_Qte_Line_Row ( P_Qte_Line_Id );

2844:
2845:
2846:
2847: l_qte_line_tbl := ASO_QUOTE_PUB.G_MISS_QTE_LINE_TBL ;
2848: l_qte_line_rec := ASO_UTILITY_PVT.Query_Qte_Line_Row ( P_Qte_Line_Id );
2849: l_qte_line_tbl(1) := l_qte_line_rec;
2850:
2851:
2852:

Line 2854: l_qte_line_dtl_tbl := ASO_UTILITY_PVT.Query_Line_Dtl_Rows ( P_Qte_Line_Id );

2850:
2851:
2852:
2853: -- Getting the quote line detail record
2854: l_qte_line_dtl_tbl := ASO_UTILITY_PVT.Query_Line_Dtl_Rows ( P_Qte_Line_Id );
2855:
2856:
2857: IF l_qte_line_rec.line_category_code = 'RETURN' THEN
2858: IF aso_debug_pub.g_debug_flag = 'Y' THEN

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

3019: END IF;
3020:
3021: IF l_line_index_link_tbl ( l_qte_line_id ) = FND_API.G_MISS_NUM THEN
3022:
3023: l_qte_line_dtl_tbl := ASO_UTILITY_PVT.Query_Line_Dtl_Rows ( l_qte_line_id );
3024:
3025: /* Code change for Quoting Usability Sun ER Start */
3026: -- Validation check for Trade in product
3027: If P_Copy_Quote_Control_Rec.Copy_To_Same_Customer = FND_API.G_FALSE Then

Line 3237: l_line_attr_Ext_Tbl := ASO_UTILITY_PVT.Query_Line_Attribs_Ext_Rows ( l_qte_line_id );

3233: AND l_qte_line_tbl ( i ).item_type_code <> 'OPT'
3234: AND l_service_item_flag <> 'Y'
3235: AND (l_copy_flag = 'T') THEN -- Code change for Quoting Usability Sun ER
3236:
3237: l_line_attr_Ext_Tbl := ASO_UTILITY_PVT.Query_Line_Attribs_Ext_Rows ( l_qte_line_id );
3238:
3239: IF ( P_Qte_Line_Id IS NOT NULL ) AND (P_Qte_Line_Id <> FND_API.G_MISS_NUM) THEN
3240:
3241: l_price_adj_tbl := ASO_UTILITY_PVT.Query_Price_Adj_NonPRG_Rows(p_qte_header_id, l_qte_line_id);

Line 3241: l_price_adj_tbl := ASO_UTILITY_PVT.Query_Price_Adj_NonPRG_Rows(p_qte_header_id, l_qte_line_id);

3237: l_line_attr_Ext_Tbl := ASO_UTILITY_PVT.Query_Line_Attribs_Ext_Rows ( l_qte_line_id );
3238:
3239: IF ( P_Qte_Line_Id IS NOT NULL ) AND (P_Qte_Line_Id <> FND_API.G_MISS_NUM) THEN
3240:
3241: l_price_adj_tbl := ASO_UTILITY_PVT.Query_Price_Adj_NonPRG_Rows(p_qte_header_id, l_qte_line_id);
3242: ELSE
3243: l_price_adj_tbl := ASO_UTILITY_PVT.Query_Price_Adj_Rows(p_qte_header_id, l_qte_line_id);
3244: END IF;
3245:

Line 3243: l_price_adj_tbl := ASO_UTILITY_PVT.Query_Price_Adj_Rows(p_qte_header_id, l_qte_line_id);

3239: IF ( P_Qte_Line_Id IS NOT NULL ) AND (P_Qte_Line_Id <> FND_API.G_MISS_NUM) THEN
3240:
3241: l_price_adj_tbl := ASO_UTILITY_PVT.Query_Price_Adj_NonPRG_Rows(p_qte_header_id, l_qte_line_id);
3242: ELSE
3243: l_price_adj_tbl := ASO_UTILITY_PVT.Query_Price_Adj_Rows(p_qte_header_id, l_qte_line_id);
3244: END IF;
3245:
3246: l_dup_Price_Adj_Tbl := l_price_adj_tbl;
3247:

Line 3248: l_price_adj_attr_tbl := ASO_UTILITY_PVT.Query_Price_Adj_Attr_Rows( p_price_adj_tbl => l_price_adj_tbl );

3244: END IF;
3245:
3246: l_dup_Price_Adj_Tbl := l_price_adj_tbl;
3247:
3248: l_price_adj_attr_tbl := ASO_UTILITY_PVT.Query_Price_Adj_Attr_Rows( p_price_adj_tbl => l_price_adj_tbl );
3249:
3250: l_price_attr_tbl := ASO_UTILITY_PVT.Query_Price_Attr_Rows(p_qte_header_id, l_qte_line_id);
3251:
3252: --l_payment_tbl := ASO_UTILITY_PVT.Query_Payment_Rows(p_qte_header_id, L_QTE_LINE_ID);

Line 3250: l_price_attr_tbl := ASO_UTILITY_PVT.Query_Price_Attr_Rows(p_qte_header_id, l_qte_line_id);

3246: l_dup_Price_Adj_Tbl := l_price_adj_tbl;
3247:
3248: l_price_adj_attr_tbl := ASO_UTILITY_PVT.Query_Price_Adj_Attr_Rows( p_price_adj_tbl => l_price_adj_tbl );
3249:
3250: l_price_attr_tbl := ASO_UTILITY_PVT.Query_Price_Attr_Rows(p_qte_header_id, l_qte_line_id);
3251:
3252: --l_payment_tbl := ASO_UTILITY_PVT.Query_Payment_Rows(p_qte_header_id, L_QTE_LINE_ID);
3253:
3254: -- l_payment_tbl := ASO_QUOTE_PUB.g_miss_payment_tbl;

Line 3252: --l_payment_tbl := ASO_UTILITY_PVT.Query_Payment_Rows(p_qte_header_id, L_QTE_LINE_ID);

3248: l_price_adj_attr_tbl := ASO_UTILITY_PVT.Query_Price_Adj_Attr_Rows( p_price_adj_tbl => l_price_adj_tbl );
3249:
3250: l_price_attr_tbl := ASO_UTILITY_PVT.Query_Price_Attr_Rows(p_qte_header_id, l_qte_line_id);
3251:
3252: --l_payment_tbl := ASO_UTILITY_PVT.Query_Payment_Rows(p_qte_header_id, L_QTE_LINE_ID);
3253:
3254: -- l_payment_tbl := ASO_QUOTE_PUB.g_miss_payment_tbl;
3255:
3256: -- l_shipment_tbl := ASO_UTILITY_PVT.Query_Shipment_Rows(p_qte_header_id, L_QTE_LINE_ID);

Line 3256: -- l_shipment_tbl := ASO_UTILITY_PVT.Query_Shipment_Rows(p_qte_header_id, L_QTE_LINE_ID);

3252: --l_payment_tbl := ASO_UTILITY_PVT.Query_Payment_Rows(p_qte_header_id, L_QTE_LINE_ID);
3253:
3254: -- l_payment_tbl := ASO_QUOTE_PUB.g_miss_payment_tbl;
3255:
3256: -- l_shipment_tbl := ASO_UTILITY_PVT.Query_Shipment_Rows(p_qte_header_id, L_QTE_LINE_ID);
3257:
3258: /* Code change for Quoting Usability Sun ER Start */
3259: If P_Copy_Quote_Control_Rec.Copy_To_Same_Customer = FND_API.G_TRUE Then
3260:

Line 3265: l_shipment_tbl := ASO_UTILITY_PVT.Query_Shipment_Rows(p_qte_header_id,l_qte_line_id);

3261: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3262: aso_debug_pub.add('Copy_Line_Rows - P_Copy_Quote_Control_Rec.Copy_To_Same_Customer is True ', 1, 'Y');
3263: END IF ;
3264:
3265: l_shipment_tbl := ASO_UTILITY_PVT.Query_Shipment_Rows(p_qte_header_id,l_qte_line_id);
3266:
3267: If P_Copy_Quote_Control_Rec.Copy_Line_Shipping = FND_API.G_FALSE Then
3268: l_shipment_tbl(1).SHIP_TO_CUST_ACCOUNT_ID := Null;
3269: l_shipment_tbl(1).SHIP_TO_CUST_PARTY_ID := Null;

Line 3313: l_sales_credit_tbl := ASO_UTILITY_PVT.Query_Sales_Credit_Row(p_qte_header_id,l_qte_line_id);

3309: l_qte_line_tbl ( i ).END_CUSTOMER_CUST_PARTY_ID := Null;
3310: End If;
3311:
3312: If P_Copy_Quote_Control_Rec.Copy_Line_Sales_Credit = FND_API.G_TRUE Then
3313: l_sales_credit_tbl := ASO_UTILITY_PVT.Query_Sales_Credit_Row(p_qte_header_id,l_qte_line_id);
3314: End If;
3315:
3316: ElsIf P_Copy_Quote_Control_Rec.Copy_To_Same_Customer = FND_API.G_FALSE Then
3317:

Line 3334: l_sales_credit_tbl := ASO_UTILITY_PVT.Query_Sales_Credit_Row(p_qte_header_id,l_qte_line_id);

3330: l_shipment_tbl(1).SHIPPING_INSTRUCTIONS := Null;
3331: l_shipment_tbl(1).PACKING_INSTRUCTIONS := Null;
3332: End If;
3333:
3334: l_sales_credit_tbl := ASO_UTILITY_PVT.Query_Sales_Credit_Row(p_qte_header_id,l_qte_line_id);
3335: End If;
3336:
3337: If P_Copy_Quote_Control_Rec.Copy_Line_Flexfield = FND_API.G_FALSE Then
3338: l_qte_line_tbl ( i ).ATTRIBUTE1 := Null;

Line 3361: l_quote_party_tbl := ASO_UTILITY_PVT.Query_Quote_Party_Row(p_qte_header_id, L_QTE_LINE_ID);

3357: l_qte_line_tbl ( i ).ATTRIBUTE20 := Null;
3358: End If;
3359: /* Code change for Quoting Usability Sun ER End */
3360:
3361: l_quote_party_tbl := ASO_UTILITY_PVT.Query_Quote_Party_Row(p_qte_header_id, L_QTE_LINE_ID);
3362:
3363: l_freight_charge_tbl := ASO_UTILITY_PVT.Query_Freight_Charge_Rows(l_shipment_tbl);
3364:
3365: l_tax_detail_tbl := ASO_UTILITY_PVT.Query_Tax_Detail_Rows(p_qte_header_id, L_QTE_LINE_ID, l_shipment_tbl);

Line 3363: l_freight_charge_tbl := ASO_UTILITY_PVT.Query_Freight_Charge_Rows(l_shipment_tbl);

3359: /* Code change for Quoting Usability Sun ER End */
3360:
3361: l_quote_party_tbl := ASO_UTILITY_PVT.Query_Quote_Party_Row(p_qte_header_id, L_QTE_LINE_ID);
3362:
3363: l_freight_charge_tbl := ASO_UTILITY_PVT.Query_Freight_Charge_Rows(l_shipment_tbl);
3364:
3365: l_tax_detail_tbl := ASO_UTILITY_PVT.Query_Tax_Detail_Rows(p_qte_header_id, L_QTE_LINE_ID, l_shipment_tbl);
3366:
3367: l_qte_line_tbl(i).quote_line_id := NULL;

Line 3365: l_tax_detail_tbl := ASO_UTILITY_PVT.Query_Tax_Detail_Rows(p_qte_header_id, L_QTE_LINE_ID, l_shipment_tbl);

3361: l_quote_party_tbl := ASO_UTILITY_PVT.Query_Quote_Party_Row(p_qte_header_id, L_QTE_LINE_ID);
3362:
3363: l_freight_charge_tbl := ASO_UTILITY_PVT.Query_Freight_Charge_Rows(l_shipment_tbl);
3364:
3365: l_tax_detail_tbl := ASO_UTILITY_PVT.Query_Tax_Detail_Rows(p_qte_header_id, L_QTE_LINE_ID, l_shipment_tbl);
3366:
3367: l_qte_line_tbl(i).quote_line_id := NULL;
3368:
3369: l_qte_line_tbl ( i ).object_version_number := FND_API.G_MISS_NUM;

Line 3524: l_payment_tbl := ASO_UTILITY_PVT.Query_Payment_Rows(p_qte_header_id, L_QTE_LINE_ID);

3520: ato_line_id = decode(l_ato_model,fnd_api.g_true,lx_qte_line_rec.quote_line_id,null)
3521: where quote_line_id = lx_qte_line_rec.quote_line_id;
3522:
3523: -- Copy the payment record
3524: l_payment_tbl := ASO_UTILITY_PVT.Query_Payment_Rows(p_qte_header_id, L_QTE_LINE_ID);
3525:
3526: IF l_payment_tbl.count > 0 then
3527:
3528: FOR j IN 1 .. l_payment_tbl.COUNT LOOP

Line 4173: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS (

4169:
4170: EXCEPTION
4171:
4172: WHEN FND_API.G_EXC_ERROR THEN
4173: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS (
4174: P_API_NAME => L_API_NAME
4175: , P_PKG_NAME => G_PKG_NAME
4176: , P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
4177: , P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 4177: , P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

4173: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS (
4174: P_API_NAME => L_API_NAME
4175: , P_PKG_NAME => G_PKG_NAME
4176: , P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
4177: , P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
4178: , X_MSG_COUNT => X_MSG_COUNT
4179: , X_MSG_DATA => X_MSG_DATA
4180: , X_RETURN_STATUS => X_RETURN_STATUS
4181: );

Line 4184: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS (

4180: , X_RETURN_STATUS => X_RETURN_STATUS
4181: );
4182:
4183: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4184: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS (
4185: P_API_NAME => L_API_NAME
4186: , P_PKG_NAME => G_PKG_NAME
4187: , P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
4188: , P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 4188: , P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

4184: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS (
4185: P_API_NAME => L_API_NAME
4186: , P_PKG_NAME => G_PKG_NAME
4187: , P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
4188: , P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
4189: , X_MSG_COUNT => X_MSG_COUNT
4190: , X_MSG_DATA => X_MSG_DATA
4191: , X_RETURN_STATUS => X_RETURN_STATUS
4192: );

Line 4195: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS (

4191: , X_RETURN_STATUS => X_RETURN_STATUS
4192: );
4193:
4194: WHEN OTHERS THEN
4195: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS (
4196: P_API_NAME => L_API_NAME
4197: , P_PKG_NAME => G_PKG_NAME
4198: , P_SQLCODE => SQLCODE
4199: , P_SQLERRM => SQLERRM

Line 4200: , P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS

4196: P_API_NAME => L_API_NAME
4197: , P_PKG_NAME => G_PKG_NAME
4198: , P_SQLCODE => SQLCODE
4199: , P_SQLERRM => SQLERRM
4200: , P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
4201: , P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
4202: , X_MSG_COUNT => X_MSG_COUNT
4203: , X_MSG_DATA => X_MSG_DATA
4204: , X_RETURN_STATUS => X_RETURN_STATUS

Line 4201: , P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

4197: , P_PKG_NAME => G_PKG_NAME
4198: , P_SQLCODE => SQLCODE
4199: , P_SQLERRM => SQLERRM
4200: , P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
4201: , P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
4202: , X_MSG_COUNT => X_MSG_COUNT
4203: , X_MSG_DATA => X_MSG_DATA
4204: , X_RETURN_STATUS => X_RETURN_STATUS
4205: );

Line 4348: l_qte_line_rec := ASO_UTILITY_PVT.Query_Qte_Line_Row ( qte_line_id );

4344: IF aso_debug_pub.g_debug_flag = 'Y' THEN
4345: aso_debug_pub.ADD ( 'Copy_Config - inside cursor qte_line_id ' || qte_line_id , 1 , 'Y' );
4346: END IF;
4347:
4348: l_qte_line_rec := ASO_UTILITY_PVT.Query_Qte_Line_Row ( qte_line_id );
4349:
4350: IF p_new_qte_header_id = p_qte_header_id THEN
4351:
4352: OPEN get_old_line_id (

Line 4381: l_qte_line_dtl_tbl := ASO_UTILITY_PVT.Query_Line_Dtl_Rows ( qte_line_id );

4377: IF (p_line_quantity is not null ) and (p_line_quantity <> FND_API.G_MISS_NUM ) THEN
4378: l_qte_line_rec.quantity := p_line_quantity;
4379: END IF;
4380:
4381: l_qte_line_dtl_tbl := ASO_UTILITY_PVT.Query_Line_Dtl_Rows ( qte_line_id );
4382:
4383: FOR k IN 1 .. l_qte_line_dtl_tbl.COUNT LOOP
4384: l_qte_line_dtl_tbl ( k ).config_header_id := p_config_header_id;
4385: l_qte_line_dtl_tbl ( k ).config_revision_num := p_config_revision_num;

Line 4388: l_line_attr_Ext_Tbl := ASO_UTILITY_PVT.Query_Line_Attribs_Ext_Rows ( qte_line_id );

4384: l_qte_line_dtl_tbl ( k ).config_header_id := p_config_header_id;
4385: l_qte_line_dtl_tbl ( k ).config_revision_num := p_config_revision_num;
4386: END LOOP;
4387:
4388: l_line_attr_Ext_Tbl := ASO_UTILITY_PVT.Query_Line_Attribs_Ext_Rows ( qte_line_id );
4389:
4390: l_price_adj_tbl := ASO_UTILITY_PVT.Query_Price_Adj_Rows ( p_qte_header_id , qte_line_id );
4391: l_dup_price_adj_tbl := l_price_adj_tbl;
4392:

Line 4390: l_price_adj_tbl := ASO_UTILITY_PVT.Query_Price_Adj_Rows ( p_qte_header_id , qte_line_id );

4386: END LOOP;
4387:
4388: l_line_attr_Ext_Tbl := ASO_UTILITY_PVT.Query_Line_Attribs_Ext_Rows ( qte_line_id );
4389:
4390: l_price_adj_tbl := ASO_UTILITY_PVT.Query_Price_Adj_Rows ( p_qte_header_id , qte_line_id );
4391: l_dup_price_adj_tbl := l_price_adj_tbl;
4392:
4393: l_price_adj_attr_tbl := ASO_UTILITY_PVT.Query_Price_Adj_Attr_Rows(p_price_adj_tbl => l_price_adj_tbl);
4394:

Line 4393: l_price_adj_attr_tbl := ASO_UTILITY_PVT.Query_Price_Adj_Attr_Rows(p_price_adj_tbl => l_price_adj_tbl);

4389:
4390: l_price_adj_tbl := ASO_UTILITY_PVT.Query_Price_Adj_Rows ( p_qte_header_id , qte_line_id );
4391: l_dup_price_adj_tbl := l_price_adj_tbl;
4392:
4393: l_price_adj_attr_tbl := ASO_UTILITY_PVT.Query_Price_Adj_Attr_Rows(p_price_adj_tbl => l_price_adj_tbl);
4394:
4395: l_price_attr_tbl := ASO_UTILITY_PVT.Query_Price_Attr_Rows ( p_qte_header_id , qte_line_id );
4396:
4397: --l_payment_tbl := ASO_UTILITY_PVT.Query_Payment_Rows ( p_qte_header_id , qte_line_id );

Line 4395: l_price_attr_tbl := ASO_UTILITY_PVT.Query_Price_Attr_Rows ( p_qte_header_id , qte_line_id );

4391: l_dup_price_adj_tbl := l_price_adj_tbl;
4392:
4393: l_price_adj_attr_tbl := ASO_UTILITY_PVT.Query_Price_Adj_Attr_Rows(p_price_adj_tbl => l_price_adj_tbl);
4394:
4395: l_price_attr_tbl := ASO_UTILITY_PVT.Query_Price_Attr_Rows ( p_qte_header_id , qte_line_id );
4396:
4397: --l_payment_tbl := ASO_UTILITY_PVT.Query_Payment_Rows ( p_qte_header_id , qte_line_id );
4398:
4399: l_shipment_tbl := ASO_UTILITY_PVT.Query_Shipment_Rows ( p_qte_header_id , qte_line_id );

Line 4397: --l_payment_tbl := ASO_UTILITY_PVT.Query_Payment_Rows ( p_qte_header_id , qte_line_id );

4393: l_price_adj_attr_tbl := ASO_UTILITY_PVT.Query_Price_Adj_Attr_Rows(p_price_adj_tbl => l_price_adj_tbl);
4394:
4395: l_price_attr_tbl := ASO_UTILITY_PVT.Query_Price_Attr_Rows ( p_qte_header_id , qte_line_id );
4396:
4397: --l_payment_tbl := ASO_UTILITY_PVT.Query_Payment_Rows ( p_qte_header_id , qte_line_id );
4398:
4399: l_shipment_tbl := ASO_UTILITY_PVT.Query_Shipment_Rows ( p_qte_header_id , qte_line_id );
4400:
4401: l_sales_credit_tbl := ASO_UTILITY_PVT.Query_Sales_Credit_Row ( p_qte_header_id , qte_line_id );

Line 4399: l_shipment_tbl := ASO_UTILITY_PVT.Query_Shipment_Rows ( p_qte_header_id , qte_line_id );

4395: l_price_attr_tbl := ASO_UTILITY_PVT.Query_Price_Attr_Rows ( p_qte_header_id , qte_line_id );
4396:
4397: --l_payment_tbl := ASO_UTILITY_PVT.Query_Payment_Rows ( p_qte_header_id , qte_line_id );
4398:
4399: l_shipment_tbl := ASO_UTILITY_PVT.Query_Shipment_Rows ( p_qte_header_id , qte_line_id );
4400:
4401: l_sales_credit_tbl := ASO_UTILITY_PVT.Query_Sales_Credit_Row ( p_qte_header_id , qte_line_id );
4402:
4403: l_quote_party_tbl := ASO_UTILITY_PVT.Query_Quote_Party_Row ( p_qte_header_id , qte_line_id );

Line 4401: l_sales_credit_tbl := ASO_UTILITY_PVT.Query_Sales_Credit_Row ( p_qte_header_id , qte_line_id );

4397: --l_payment_tbl := ASO_UTILITY_PVT.Query_Payment_Rows ( p_qte_header_id , qte_line_id );
4398:
4399: l_shipment_tbl := ASO_UTILITY_PVT.Query_Shipment_Rows ( p_qte_header_id , qte_line_id );
4400:
4401: l_sales_credit_tbl := ASO_UTILITY_PVT.Query_Sales_Credit_Row ( p_qte_header_id , qte_line_id );
4402:
4403: l_quote_party_tbl := ASO_UTILITY_PVT.Query_Quote_Party_Row ( p_qte_header_id , qte_line_id );
4404:
4405: l_freight_charge_tbl := ASO_UTILITY_PVT.Query_Freight_Charge_Rows ( l_shipment_tbl );

Line 4403: l_quote_party_tbl := ASO_UTILITY_PVT.Query_Quote_Party_Row ( p_qte_header_id , qte_line_id );

4399: l_shipment_tbl := ASO_UTILITY_PVT.Query_Shipment_Rows ( p_qte_header_id , qte_line_id );
4400:
4401: l_sales_credit_tbl := ASO_UTILITY_PVT.Query_Sales_Credit_Row ( p_qte_header_id , qte_line_id );
4402:
4403: l_quote_party_tbl := ASO_UTILITY_PVT.Query_Quote_Party_Row ( p_qte_header_id , qte_line_id );
4404:
4405: l_freight_charge_tbl := ASO_UTILITY_PVT.Query_Freight_Charge_Rows ( l_shipment_tbl );
4406:
4407: l_tax_detail_tbl := ASO_UTILITY_PVT.Query_Tax_Detail_Rows ( p_qte_header_id , qte_line_id , l_shipment_tbl );

Line 4405: l_freight_charge_tbl := ASO_UTILITY_PVT.Query_Freight_Charge_Rows ( l_shipment_tbl );

4401: l_sales_credit_tbl := ASO_UTILITY_PVT.Query_Sales_Credit_Row ( p_qte_header_id , qte_line_id );
4402:
4403: l_quote_party_tbl := ASO_UTILITY_PVT.Query_Quote_Party_Row ( p_qte_header_id , qte_line_id );
4404:
4405: l_freight_charge_tbl := ASO_UTILITY_PVT.Query_Freight_Charge_Rows ( l_shipment_tbl );
4406:
4407: l_tax_detail_tbl := ASO_UTILITY_PVT.Query_Tax_Detail_Rows ( p_qte_header_id , qte_line_id , l_shipment_tbl );
4408:
4409: OPEN C_Serviceable_Product ( l_qte_line_rec.organization_id , l_qte_line_rec.inventory_item_id );

Line 4407: l_tax_detail_tbl := ASO_UTILITY_PVT.Query_Tax_Detail_Rows ( p_qte_header_id , qte_line_id , l_shipment_tbl );

4403: l_quote_party_tbl := ASO_UTILITY_PVT.Query_Quote_Party_Row ( p_qte_header_id , qte_line_id );
4404:
4405: l_freight_charge_tbl := ASO_UTILITY_PVT.Query_Freight_Charge_Rows ( l_shipment_tbl );
4406:
4407: l_tax_detail_tbl := ASO_UTILITY_PVT.Query_Tax_Detail_Rows ( p_qte_header_id , qte_line_id , l_shipment_tbl );
4408:
4409: OPEN C_Serviceable_Product ( l_qte_line_rec.organization_id , l_qte_line_rec.inventory_item_id );
4410: FETCH C_Serviceable_Product INTO l_serviceable_product_flag;
4411: CLOSE C_Serviceable_Product;

Line 4576: l_payment_tbl := ASO_UTILITY_PVT.Query_Payment_Rows ( p_qte_header_id , qte_line_id );

4572: RAISE FND_API.G_EXC_ERROR;
4573: END IF;
4574:
4575: -- Copy the payment record
4576: l_payment_tbl := ASO_UTILITY_PVT.Query_Payment_Rows ( p_qte_header_id , qte_line_id );
4577: IF l_payment_tbl.count > 0 then
4578:
4579: FOR j IN 1 .. l_payment_tbl.COUNT LOOP
4580: l_payment_tbl ( j ).QUOTE_HEADER_ID := p_new_qte_header_id;

Line 4832: ASO_UTILITY_PVT.Query_Qte_Line_Row ( qte_line_id );

4828: aso_debug_pub.ADD ( 'Copy_Service - inside cursor qte_line_id ' || qte_line_id , 1 , 'Y' );
4829: END IF;
4830:
4831: l_qte_line_rec :=
4832: ASO_UTILITY_PVT.Query_Qte_Line_Row ( qte_line_id );
4833:
4834: IF p_new_qte_header_id = p_qte_header_id THEN
4835:
4836: OPEN get_qte_line_number(lx_line_index_link_tbl(p_qte_line_id));

Line 4851: ASO_UTILITY_PVT.Query_Line_Dtl_Rows ( qte_line_id );

4847: END IF;
4848:
4849: l_qte_line_rec.quote_header_id := p_new_qte_header_id;
4850: l_qte_line_dtl_tbl :=
4851: ASO_UTILITY_PVT.Query_Line_Dtl_Rows ( qte_line_id );
4852:
4853: IF l_qte_line_dtl_tbl.COUNT > 0 THEN
4854:
4855: FOR k IN 1 .. l_qte_line_dtl_tbl.COUNT LOOP

Line 4880: l_line_attr_Ext_Tbl := ASO_UTILITY_PVT.Query_Line_Attribs_Ext_Rows ( qte_line_id );

4876: IF aso_debug_pub.g_debug_flag = 'Y' THEN
4877: aso_debug_pub.ADD ( 'Copy_Service - 2 l_service_ref_line_id ' || l_service_ref_line_id , 1 , 'Y' );
4878: END IF;
4879:
4880: l_line_attr_Ext_Tbl := ASO_UTILITY_PVT.Query_Line_Attribs_Ext_Rows ( qte_line_id );
4881:
4882: l_price_adj_tbl := ASO_UTILITY_PVT.Query_Price_Adj_Rows ( p_qte_header_id , qte_line_id );
4883:
4884: l_dup_price_adj_tbl := l_price_adj_tbl;

Line 4882: l_price_adj_tbl := ASO_UTILITY_PVT.Query_Price_Adj_Rows ( p_qte_header_id , qte_line_id );

4878: END IF;
4879:
4880: l_line_attr_Ext_Tbl := ASO_UTILITY_PVT.Query_Line_Attribs_Ext_Rows ( qte_line_id );
4881:
4882: l_price_adj_tbl := ASO_UTILITY_PVT.Query_Price_Adj_Rows ( p_qte_header_id , qte_line_id );
4883:
4884: l_dup_price_adj_tbl := l_price_adj_tbl;
4885:
4886: l_price_adj_attr_tbl := ASO_UTILITY_PVT.Query_Price_Adj_Attr_Rows ( p_price_adj_tbl => l_price_adj_tbl );

Line 4886: l_price_adj_attr_tbl := ASO_UTILITY_PVT.Query_Price_Adj_Attr_Rows ( p_price_adj_tbl => l_price_adj_tbl );

4882: l_price_adj_tbl := ASO_UTILITY_PVT.Query_Price_Adj_Rows ( p_qte_header_id , qte_line_id );
4883:
4884: l_dup_price_adj_tbl := l_price_adj_tbl;
4885:
4886: l_price_adj_attr_tbl := ASO_UTILITY_PVT.Query_Price_Adj_Attr_Rows ( p_price_adj_tbl => l_price_adj_tbl );
4887:
4888: l_price_attr_tbl := ASO_UTILITY_PVT.Query_Price_Attr_Rows ( p_qte_header_id , qte_line_id );
4889:
4890: --l_payment_tbl := ASO_UTILITY_PVT.Query_Payment_Rows ( p_qte_header_id , QTE_LINE_ID );

Line 4888: l_price_attr_tbl := ASO_UTILITY_PVT.Query_Price_Attr_Rows ( p_qte_header_id , qte_line_id );

4884: l_dup_price_adj_tbl := l_price_adj_tbl;
4885:
4886: l_price_adj_attr_tbl := ASO_UTILITY_PVT.Query_Price_Adj_Attr_Rows ( p_price_adj_tbl => l_price_adj_tbl );
4887:
4888: l_price_attr_tbl := ASO_UTILITY_PVT.Query_Price_Attr_Rows ( p_qte_header_id , qte_line_id );
4889:
4890: --l_payment_tbl := ASO_UTILITY_PVT.Query_Payment_Rows ( p_qte_header_id , QTE_LINE_ID );
4891:
4892: l_shipment_tbl := ASO_UTILITY_PVT.Query_Shipment_Rows ( p_qte_header_id , QTE_LINE_ID );

Line 4890: --l_payment_tbl := ASO_UTILITY_PVT.Query_Payment_Rows ( p_qte_header_id , QTE_LINE_ID );

4886: l_price_adj_attr_tbl := ASO_UTILITY_PVT.Query_Price_Adj_Attr_Rows ( p_price_adj_tbl => l_price_adj_tbl );
4887:
4888: l_price_attr_tbl := ASO_UTILITY_PVT.Query_Price_Attr_Rows ( p_qte_header_id , qte_line_id );
4889:
4890: --l_payment_tbl := ASO_UTILITY_PVT.Query_Payment_Rows ( p_qte_header_id , QTE_LINE_ID );
4891:
4892: l_shipment_tbl := ASO_UTILITY_PVT.Query_Shipment_Rows ( p_qte_header_id , QTE_LINE_ID );
4893:
4894: l_sales_credit_tbl := ASO_UTILITY_PVT.Query_Sales_Credit_Row ( p_qte_header_id , QTE_LINE_ID );

Line 4892: l_shipment_tbl := ASO_UTILITY_PVT.Query_Shipment_Rows ( p_qte_header_id , QTE_LINE_ID );

4888: l_price_attr_tbl := ASO_UTILITY_PVT.Query_Price_Attr_Rows ( p_qte_header_id , qte_line_id );
4889:
4890: --l_payment_tbl := ASO_UTILITY_PVT.Query_Payment_Rows ( p_qte_header_id , QTE_LINE_ID );
4891:
4892: l_shipment_tbl := ASO_UTILITY_PVT.Query_Shipment_Rows ( p_qte_header_id , QTE_LINE_ID );
4893:
4894: l_sales_credit_tbl := ASO_UTILITY_PVT.Query_Sales_Credit_Row ( p_qte_header_id , QTE_LINE_ID );
4895:
4896: l_quote_party_tbl := ASO_UTILITY_PVT.Query_Quote_Party_Row ( p_qte_header_id , QTE_LINE_ID );

Line 4894: l_sales_credit_tbl := ASO_UTILITY_PVT.Query_Sales_Credit_Row ( p_qte_header_id , QTE_LINE_ID );

4890: --l_payment_tbl := ASO_UTILITY_PVT.Query_Payment_Rows ( p_qte_header_id , QTE_LINE_ID );
4891:
4892: l_shipment_tbl := ASO_UTILITY_PVT.Query_Shipment_Rows ( p_qte_header_id , QTE_LINE_ID );
4893:
4894: l_sales_credit_tbl := ASO_UTILITY_PVT.Query_Sales_Credit_Row ( p_qte_header_id , QTE_LINE_ID );
4895:
4896: l_quote_party_tbl := ASO_UTILITY_PVT.Query_Quote_Party_Row ( p_qte_header_id , QTE_LINE_ID );
4897:
4898: l_freight_charge_tbl := ASO_UTILITY_PVT.Query_Freight_Charge_Rows ( l_shipment_tbl );

Line 4896: l_quote_party_tbl := ASO_UTILITY_PVT.Query_Quote_Party_Row ( p_qte_header_id , QTE_LINE_ID );

4892: l_shipment_tbl := ASO_UTILITY_PVT.Query_Shipment_Rows ( p_qte_header_id , QTE_LINE_ID );
4893:
4894: l_sales_credit_tbl := ASO_UTILITY_PVT.Query_Sales_Credit_Row ( p_qte_header_id , QTE_LINE_ID );
4895:
4896: l_quote_party_tbl := ASO_UTILITY_PVT.Query_Quote_Party_Row ( p_qte_header_id , QTE_LINE_ID );
4897:
4898: l_freight_charge_tbl := ASO_UTILITY_PVT.Query_Freight_Charge_Rows ( l_shipment_tbl );
4899:
4900: l_tax_detail_tbl := ASO_UTILITY_PVT.Query_Tax_Detail_Rows ( p_qte_header_id , QTE_LINE_ID , l_shipment_tbl );

Line 4898: l_freight_charge_tbl := ASO_UTILITY_PVT.Query_Freight_Charge_Rows ( l_shipment_tbl );

4894: l_sales_credit_tbl := ASO_UTILITY_PVT.Query_Sales_Credit_Row ( p_qte_header_id , QTE_LINE_ID );
4895:
4896: l_quote_party_tbl := ASO_UTILITY_PVT.Query_Quote_Party_Row ( p_qte_header_id , QTE_LINE_ID );
4897:
4898: l_freight_charge_tbl := ASO_UTILITY_PVT.Query_Freight_Charge_Rows ( l_shipment_tbl );
4899:
4900: l_tax_detail_tbl := ASO_UTILITY_PVT.Query_Tax_Detail_Rows ( p_qte_header_id , QTE_LINE_ID , l_shipment_tbl );
4901:
4902: l_qte_line_rec.quote_line_id := NULL;

Line 4900: l_tax_detail_tbl := ASO_UTILITY_PVT.Query_Tax_Detail_Rows ( p_qte_header_id , QTE_LINE_ID , l_shipment_tbl );

4896: l_quote_party_tbl := ASO_UTILITY_PVT.Query_Quote_Party_Row ( p_qte_header_id , QTE_LINE_ID );
4897:
4898: l_freight_charge_tbl := ASO_UTILITY_PVT.Query_Freight_Charge_Rows ( l_shipment_tbl );
4899:
4900: l_tax_detail_tbl := ASO_UTILITY_PVT.Query_Tax_Detail_Rows ( p_qte_header_id , QTE_LINE_ID , l_shipment_tbl );
4901:
4902: l_qte_line_rec.quote_line_id := NULL;
4903: l_qte_line_rec.object_version_number := FND_API.G_MISS_NUM;
4904:

Line 5034: l_payment_tbl := ASO_UTILITY_PVT.Query_Payment_Rows ( p_qte_header_id , QTE_LINE_ID );

5030: END IF;
5031:
5032:
5033: -- Copy the payment record
5034: l_payment_tbl := ASO_UTILITY_PVT.Query_Payment_Rows ( p_qte_header_id , QTE_LINE_ID );
5035:
5036: IF l_payment_tbl.count > 0 then
5037:
5038: FOR j IN 1 .. l_payment_tbl.COUNT LOOP

Line 5378: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS (

5374:
5375: EXCEPTION
5376:
5377: WHEN FND_API.G_EXC_ERROR THEN
5378: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS (
5379: P_API_NAME => L_API_NAME
5380: , P_PKG_NAME => G_PKG_NAME
5381: , P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
5382: , P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 5382: , P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

5378: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS (
5379: P_API_NAME => L_API_NAME
5380: , P_PKG_NAME => G_PKG_NAME
5381: , P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
5382: , P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
5383: , X_MSG_COUNT => X_MSG_COUNT
5384: , X_MSG_DATA => X_MSG_DATA
5385: , X_RETURN_STATUS => X_RETURN_STATUS
5386: );

Line 5389: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS (

5385: , X_RETURN_STATUS => X_RETURN_STATUS
5386: );
5387:
5388: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5389: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS (
5390: P_API_NAME => L_API_NAME
5391: , P_PKG_NAME => G_PKG_NAME
5392: , P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
5393: , P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 5393: , P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

5389: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS (
5390: P_API_NAME => L_API_NAME
5391: , P_PKG_NAME => G_PKG_NAME
5392: , P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
5393: , P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
5394: , X_MSG_COUNT => X_MSG_COUNT
5395: , X_MSG_DATA => X_MSG_DATA
5396: , X_RETURN_STATUS => X_RETURN_STATUS
5397: );

Line 5400: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS (

5396: , X_RETURN_STATUS => X_RETURN_STATUS
5397: );
5398:
5399: WHEN OTHERS THEN
5400: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS (
5401: P_API_NAME => L_API_NAME
5402: , P_PKG_NAME => G_PKG_NAME
5403: , P_SQLCODE => SQLCODE
5404: , P_SQLERRM => SQLERRM

Line 5405: , P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS

5401: P_API_NAME => L_API_NAME
5402: , P_PKG_NAME => G_PKG_NAME
5403: , P_SQLCODE => SQLCODE
5404: , P_SQLERRM => SQLERRM
5405: , P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
5406: , P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
5407: , X_MSG_COUNT => X_MSG_COUNT
5408: , X_MSG_DATA => X_MSG_DATA
5409: , X_RETURN_STATUS => X_RETURN_STATUS

Line 5406: , P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

5402: , P_PKG_NAME => G_PKG_NAME
5403: , P_SQLCODE => SQLCODE
5404: , P_SQLERRM => SQLERRM
5405: , P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
5406: , P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
5407: , X_MSG_COUNT => X_MSG_COUNT
5408: , X_MSG_DATA => X_MSG_DATA
5409: , X_RETURN_STATUS => X_RETURN_STATUS
5410: );

Line 5781: l_qte_line_rec := ASO_UTILITY_PVT.Query_Qte_Line_Row ( P_Original_Qte_Line_Rec.quote_line_id );

5777: aso_debug_pub.ADD ( 'SPLIT_MODEL_LINE - After Validating the Quote Line ' , 1 , 'N' );
5778: END IF;
5779:
5780: -- Getting the quote line record
5781: l_qte_line_rec := ASO_UTILITY_PVT.Query_Qte_Line_Row ( P_Original_Qte_Line_Rec.quote_line_id );
5782:
5783: -- Getting the quote line detail record
5784: l_qte_line_detail_tbl := ASO_UTILITY_PVT.Query_Line_Dtl_Rows ( P_Original_Qte_Line_Rec.quote_line_id );
5785:

Line 5784: l_qte_line_detail_tbl := ASO_UTILITY_PVT.Query_Line_Dtl_Rows ( P_Original_Qte_Line_Rec.quote_line_id );

5780: -- Getting the quote line record
5781: l_qte_line_rec := ASO_UTILITY_PVT.Query_Qte_Line_Row ( P_Original_Qte_Line_Rec.quote_line_id );
5782:
5783: -- Getting the quote line detail record
5784: l_qte_line_detail_tbl := ASO_UTILITY_PVT.Query_Line_Dtl_Rows ( P_Original_Qte_Line_Rec.quote_line_id );
5785:
5786: -- Getting the shipment details for the quote line
5787: l_qte_shipment_dtl_tbl := ASO_UTILITY_PVT.Query_Shipment_Rows (P_Qte_Header_Rec.quote_header_id, P_Original_Qte_Line_Rec.quote_line_id );
5788:

Line 5787: l_qte_shipment_dtl_tbl := ASO_UTILITY_PVT.Query_Shipment_Rows (P_Qte_Header_Rec.quote_header_id, P_Original_Qte_Line_Rec.quote_line_id );

5783: -- Getting the quote line detail record
5784: l_qte_line_detail_tbl := ASO_UTILITY_PVT.Query_Line_Dtl_Rows ( P_Original_Qte_Line_Rec.quote_line_id );
5785:
5786: -- Getting the shipment details for the quote line
5787: l_qte_shipment_dtl_tbl := ASO_UTILITY_PVT.Query_Shipment_Rows (P_Qte_Header_Rec.quote_header_id, P_Original_Qte_Line_Rec.quote_line_id );
5788:
5789:
5790: -- Copy the Qte line table to the local variable
5791: For i in 1..P_Qte_Line_Tbl.count LOOP

Line 5960: ASO_UTILITY_PVT.Query_Line_Dtl_Rows ( P_Original_Qte_Line_Rec.quote_line_id );

5956: l_line_index_link_tbl (P_Original_Qte_Line_Rec.quote_line_id ) := FND_API.G_MISS_NUM;
5957:
5958: IF l_line_index_link_tbl ( P_Original_Qte_Line_Rec.quote_line_id ) = FND_API.G_MISS_NUM THEN
5959: l_qte_line_detail_tbl :=
5960: ASO_UTILITY_PVT.Query_Line_Dtl_Rows ( P_Original_Qte_Line_Rec.quote_line_id );
5961:
5962: IF l_qte_line_rec.item_type_code = 'MDL' THEN
5963:
5964: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 6053: l_line_attr_Ext_Tbl := ASO_UTILITY_PVT.Query_Line_Attribs_Ext_Rows ( P_Original_Qte_Line_Rec.quote_line_id);

6049: IF l_qte_line_rec.item_type_code <> 'CFG'
6050: AND l_qte_line_rec.item_type_code <> 'OPT'
6051: AND l_service_item_flag <> 'Y' THEN
6052:
6053: l_line_attr_Ext_Tbl := ASO_UTILITY_PVT.Query_Line_Attribs_Ext_Rows ( P_Original_Qte_Line_Rec.quote_line_id);
6054:
6055: l_price_adj_tbl := ASO_UTILITY_PVT.Query_Price_Adj_NonPRG_Rows ( P_Qte_Header_Rec.quote_header_id ,
6056: P_Original_Qte_Line_Rec.quote_line_id);
6057: l_dup_Price_Adj_Tbl := l_price_adj_tbl;

Line 6055: l_price_adj_tbl := ASO_UTILITY_PVT.Query_Price_Adj_NonPRG_Rows ( P_Qte_Header_Rec.quote_header_id ,

6051: AND l_service_item_flag <> 'Y' THEN
6052:
6053: l_line_attr_Ext_Tbl := ASO_UTILITY_PVT.Query_Line_Attribs_Ext_Rows ( P_Original_Qte_Line_Rec.quote_line_id);
6054:
6055: l_price_adj_tbl := ASO_UTILITY_PVT.Query_Price_Adj_NonPRG_Rows ( P_Qte_Header_Rec.quote_header_id ,
6056: P_Original_Qte_Line_Rec.quote_line_id);
6057: l_dup_Price_Adj_Tbl := l_price_adj_tbl;
6058:
6059: l_price_adj_attr_tbl := ASO_UTILITY_PVT.Query_Price_Adj_Attr_Rows(p_price_adj_tbl => l_price_adj_tbl);

Line 6059: l_price_adj_attr_tbl := ASO_UTILITY_PVT.Query_Price_Adj_Attr_Rows(p_price_adj_tbl => l_price_adj_tbl);

6055: l_price_adj_tbl := ASO_UTILITY_PVT.Query_Price_Adj_NonPRG_Rows ( P_Qte_Header_Rec.quote_header_id ,
6056: P_Original_Qte_Line_Rec.quote_line_id);
6057: l_dup_Price_Adj_Tbl := l_price_adj_tbl;
6058:
6059: l_price_adj_attr_tbl := ASO_UTILITY_PVT.Query_Price_Adj_Attr_Rows(p_price_adj_tbl => l_price_adj_tbl);
6060:
6061: l_price_attr_tbl := ASO_UTILITY_PVT.Query_Price_Attr_Rows( P_Qte_Header_Rec.quote_header_id,
6062: P_Original_Qte_Line_Rec.quote_line_id);
6063:

Line 6061: l_price_attr_tbl := ASO_UTILITY_PVT.Query_Price_Attr_Rows( P_Qte_Header_Rec.quote_header_id,

6057: l_dup_Price_Adj_Tbl := l_price_adj_tbl;
6058:
6059: l_price_adj_attr_tbl := ASO_UTILITY_PVT.Query_Price_Adj_Attr_Rows(p_price_adj_tbl => l_price_adj_tbl);
6060:
6061: l_price_attr_tbl := ASO_UTILITY_PVT.Query_Price_Attr_Rows( P_Qte_Header_Rec.quote_header_id,
6062: P_Original_Qte_Line_Rec.quote_line_id);
6063:
6064: /* l_payment_tbl := ASO_UTILITY_PVT.Query_Payment_Rows ( P_Qte_Header_Rec.quote_header_id,
6065: P_Original_Qte_Line_Rec.quote_line_id); */

Line 6064: /* l_payment_tbl := ASO_UTILITY_PVT.Query_Payment_Rows ( P_Qte_Header_Rec.quote_header_id,

6060:
6061: l_price_attr_tbl := ASO_UTILITY_PVT.Query_Price_Attr_Rows( P_Qte_Header_Rec.quote_header_id,
6062: P_Original_Qte_Line_Rec.quote_line_id);
6063:
6064: /* l_payment_tbl := ASO_UTILITY_PVT.Query_Payment_Rows ( P_Qte_Header_Rec.quote_header_id,
6065: P_Original_Qte_Line_Rec.quote_line_id); */
6066:
6067: l_shipment_tbl := ASO_UTILITY_PVT.Query_Shipment_Rows ( P_Qte_Header_Rec.quote_header_id,
6068: P_Original_Qte_Line_Rec.quote_line_id);

Line 6067: l_shipment_tbl := ASO_UTILITY_PVT.Query_Shipment_Rows ( P_Qte_Header_Rec.quote_header_id,

6063:
6064: /* l_payment_tbl := ASO_UTILITY_PVT.Query_Payment_Rows ( P_Qte_Header_Rec.quote_header_id,
6065: P_Original_Qte_Line_Rec.quote_line_id); */
6066:
6067: l_shipment_tbl := ASO_UTILITY_PVT.Query_Shipment_Rows ( P_Qte_Header_Rec.quote_header_id,
6068: P_Original_Qte_Line_Rec.quote_line_id);
6069:
6070: l_sales_credit_tbl := ASO_UTILITY_PVT.Query_Sales_Credit_Row ( P_Qte_Header_Rec.quote_header_id,
6071: P_Original_Qte_Line_Rec.quote_line_id);

Line 6070: l_sales_credit_tbl := ASO_UTILITY_PVT.Query_Sales_Credit_Row ( P_Qte_Header_Rec.quote_header_id,

6066:
6067: l_shipment_tbl := ASO_UTILITY_PVT.Query_Shipment_Rows ( P_Qte_Header_Rec.quote_header_id,
6068: P_Original_Qte_Line_Rec.quote_line_id);
6069:
6070: l_sales_credit_tbl := ASO_UTILITY_PVT.Query_Sales_Credit_Row ( P_Qte_Header_Rec.quote_header_id,
6071: P_Original_Qte_Line_Rec.quote_line_id);
6072:
6073: l_quote_party_tbl := ASO_UTILITY_PVT.Query_Quote_Party_Row ( P_Qte_Header_Rec.quote_header_id,
6074: P_Original_Qte_Line_Rec.quote_line_id);

Line 6073: l_quote_party_tbl := ASO_UTILITY_PVT.Query_Quote_Party_Row ( P_Qte_Header_Rec.quote_header_id,

6069:
6070: l_sales_credit_tbl := ASO_UTILITY_PVT.Query_Sales_Credit_Row ( P_Qte_Header_Rec.quote_header_id,
6071: P_Original_Qte_Line_Rec.quote_line_id);
6072:
6073: l_quote_party_tbl := ASO_UTILITY_PVT.Query_Quote_Party_Row ( P_Qte_Header_Rec.quote_header_id,
6074: P_Original_Qte_Line_Rec.quote_line_id);
6075:
6076: l_freight_charge_tbl := ASO_UTILITY_PVT.Query_Freight_Charge_Rows ( l_shipment_tbl );
6077:

Line 6076: l_freight_charge_tbl := ASO_UTILITY_PVT.Query_Freight_Charge_Rows ( l_shipment_tbl );

6072:
6073: l_quote_party_tbl := ASO_UTILITY_PVT.Query_Quote_Party_Row ( P_Qte_Header_Rec.quote_header_id,
6074: P_Original_Qte_Line_Rec.quote_line_id);
6075:
6076: l_freight_charge_tbl := ASO_UTILITY_PVT.Query_Freight_Charge_Rows ( l_shipment_tbl );
6077:
6078: l_tax_detail_tbl := ASO_UTILITY_PVT.Query_Tax_Detail_Rows ( P_Qte_Header_Rec.quote_header_id,
6079: P_Original_Qte_Line_Rec.quote_line_id,
6080: l_shipment_tbl);

Line 6078: l_tax_detail_tbl := ASO_UTILITY_PVT.Query_Tax_Detail_Rows ( P_Qte_Header_Rec.quote_header_id,

6074: P_Original_Qte_Line_Rec.quote_line_id);
6075:
6076: l_freight_charge_tbl := ASO_UTILITY_PVT.Query_Freight_Charge_Rows ( l_shipment_tbl );
6077:
6078: l_tax_detail_tbl := ASO_UTILITY_PVT.Query_Tax_Detail_Rows ( P_Qte_Header_Rec.quote_header_id,
6079: P_Original_Qte_Line_Rec.quote_line_id,
6080: l_shipment_tbl);
6081:
6082: l_qte_line_rec.quote_line_id := NULL;

Line 6249: l_payment_tbl := ASO_UTILITY_PVT.Query_Payment_Rows ( P_Qte_Header_Rec.quote_header_id,

6245: END IF;
6246:
6247:
6248: -- Copy the payment record
6249: l_payment_tbl := ASO_UTILITY_PVT.Query_Payment_Rows ( P_Qte_Header_Rec.quote_header_id,
6250: P_Original_Qte_Line_Rec.quote_line_id);
6251:
6252: IF l_payment_tbl.count > 0 then
6253:

Line 6579: l_quote_header_rec := ASO_UTILITY_PVT.Query_Header_Row(P_Qte_Header_Rec.quote_header_id);

6575: IF aso_debug_pub.g_debug_flag = 'Y' THEN
6576: aso_debug_pub.ADD ( ' Getting the last update date of the quote before updating the quote ', 1 , 'N' );
6577: END IF;
6578:
6579: l_quote_header_rec := ASO_UTILITY_PVT.Query_Header_Row(P_Qte_Header_Rec.quote_header_id);
6580:
6581: OPEN get_latest_date (
6582: P_Qte_Header_Rec.quote_header_id
6583: );

Line 6727: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS (

6723: aso_debug_pub.ADD ( ' End of Split_Model_Line ', 1 , 'N' );
6724: END IF;
6725: EXCEPTION
6726: WHEN FND_API.G_EXC_ERROR THEN
6727: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS (
6728: P_API_NAME => L_API_NAME
6729: , P_PKG_NAME => G_PKG_NAME
6730: , P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
6731: , P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 6731: , P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

6727: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS (
6728: P_API_NAME => L_API_NAME
6729: , P_PKG_NAME => G_PKG_NAME
6730: , P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
6731: , P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
6732: , X_MSG_COUNT => X_MSG_COUNT
6733: , X_MSG_DATA => X_MSG_DATA
6734: , X_RETURN_STATUS => X_RETURN_STATUS
6735: );

Line 6738: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS (

6734: , X_RETURN_STATUS => X_RETURN_STATUS
6735: );
6736:
6737: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6738: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS (
6739: P_API_NAME => L_API_NAME
6740: , P_PKG_NAME => G_PKG_NAME
6741: , P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
6742: , P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 6742: , P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

6738: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS (
6739: P_API_NAME => L_API_NAME
6740: , P_PKG_NAME => G_PKG_NAME
6741: , P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
6742: , P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
6743: , X_MSG_COUNT => X_MSG_COUNT
6744: , X_MSG_DATA => X_MSG_DATA
6745: , X_RETURN_STATUS => X_RETURN_STATUS
6746: );

Line 6750: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS (

6746: );
6747:
6748:
6749: WHEN OTHERS THEN
6750: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS (
6751: P_API_NAME => L_API_NAME
6752: , P_PKG_NAME => G_PKG_NAME
6753: , P_SQLCODE => SQLCODE
6754: , P_SQLERRM => SQLERRM

Line 6755: , P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS

6751: P_API_NAME => L_API_NAME
6752: , P_PKG_NAME => G_PKG_NAME
6753: , P_SQLCODE => SQLCODE
6754: , P_SQLERRM => SQLERRM
6755: , P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
6756: , P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
6757: , X_MSG_COUNT => X_MSG_COUNT
6758: , X_MSG_DATA => X_MSG_DATA
6759: , X_RETURN_STATUS => X_RETURN_STATUS

Line 6756: , P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

6752: , P_PKG_NAME => G_PKG_NAME
6753: , P_SQLCODE => SQLCODE
6754: , P_SQLERRM => SQLERRM
6755: , P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
6756: , P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
6757: , X_MSG_COUNT => X_MSG_COUNT
6758: , X_MSG_DATA => X_MSG_DATA
6759: , X_RETURN_STATUS => X_RETURN_STATUS
6760: );

Line 6922: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS (

6918:
6919: EXCEPTION
6920:
6921: WHEN FND_API.G_EXC_ERROR THEN
6922: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS (
6923: P_API_NAME => L_API_NAME
6924: , P_PKG_NAME => G_PKG_NAME
6925: , P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
6926: , P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 6926: , P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

6922: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS (
6923: P_API_NAME => L_API_NAME
6924: , P_PKG_NAME => G_PKG_NAME
6925: , P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
6926: , P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
6927: , X_MSG_COUNT => X_MSG_COUNT
6928: , X_MSG_DATA => X_MSG_DATA
6929: , X_RETURN_STATUS => X_RETURN_STATUS
6930: );

Line 6933: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS (

6929: , X_RETURN_STATUS => X_RETURN_STATUS
6930: );
6931:
6932: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6933: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS (
6934: P_API_NAME => L_API_NAME
6935: , P_PKG_NAME => G_PKG_NAME
6936: , P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
6937: , P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 6937: , P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

6933: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS (
6934: P_API_NAME => L_API_NAME
6935: , P_PKG_NAME => G_PKG_NAME
6936: , P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
6937: , P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
6938: , X_MSG_COUNT => X_MSG_COUNT
6939: , X_MSG_DATA => X_MSG_DATA
6940: , X_RETURN_STATUS => X_RETURN_STATUS
6941: );

Line 6944: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS (

6940: , X_RETURN_STATUS => X_RETURN_STATUS
6941: );
6942:
6943: WHEN OTHERS THEN
6944: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS (
6945: P_API_NAME => L_API_NAME
6946: , P_PKG_NAME => G_PKG_NAME
6947: , P_SQLCODE => SQLCODE
6948: , P_SQLERRM => SQLERRM

Line 6949: , P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS

6945: P_API_NAME => L_API_NAME
6946: , P_PKG_NAME => G_PKG_NAME
6947: , P_SQLCODE => SQLCODE
6948: , P_SQLERRM => SQLERRM
6949: , P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
6950: , P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
6951: , X_MSG_COUNT => X_MSG_COUNT
6952: , X_MSG_DATA => X_MSG_DATA
6953: , X_RETURN_STATUS => X_RETURN_STATUS

Line 6950: , P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

6946: , P_PKG_NAME => G_PKG_NAME
6947: , P_SQLCODE => SQLCODE
6948: , P_SQLERRM => SQLERRM
6949: , P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
6950: , P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
6951: , X_MSG_COUNT => X_MSG_COUNT
6952: , X_MSG_DATA => X_MSG_DATA
6953: , X_RETURN_STATUS => X_RETURN_STATUS
6954: );

Line 7001: l_qte_header_rec := ASO_UTILITY_PVT.Query_Header_Row (l_payment_rec.Quote_Header_Id );

6997: END IF;
6998:
6999: x_return_status := FND_API.G_RET_STS_SUCCESS;
7000:
7001: l_qte_header_rec := ASO_UTILITY_PVT.Query_Header_Row (l_payment_rec.Quote_Header_Id );
7002: IF ( l_payment_rec.Quote_Line_Id IS NOT NULL and l_payment_rec.Quote_Line_Id <> fnd_api.g_miss_num) then
7003: l_qte_line_rec := ASO_UTILITY_PVT.Query_Qte_Line_Row ( l_payment_rec.Quote_Line_Id );
7004: END IF;
7005:

Line 7003: l_qte_line_rec := ASO_UTILITY_PVT.Query_Qte_Line_Row ( l_payment_rec.Quote_Line_Id );

6999: x_return_status := FND_API.G_RET_STS_SUCCESS;
7000:
7001: l_qte_header_rec := ASO_UTILITY_PVT.Query_Header_Row (l_payment_rec.Quote_Header_Id );
7002: IF ( l_payment_rec.Quote_Line_Id IS NOT NULL and l_payment_rec.Quote_Line_Id <> fnd_api.g_miss_num) then
7003: l_qte_line_rec := ASO_UTILITY_PVT.Query_Qte_Line_Row ( l_payment_rec.Quote_Line_Id );
7004: END IF;
7005:
7006: if (l_payment_rec.trxn_extension_id is not null or l_payment_rec.trxn_extension_id <> fnd_api.g_miss_num) then
7007:

Line 7204: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

7200: END IF;
7201:
7202: EXCEPTION
7203: WHEN FND_API.G_EXC_ERROR THEN
7204: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
7205: P_API_NAME => L_API_NAME
7206: ,P_PKG_NAME => G_PKG_NAME
7207: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
7208: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 7208: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

7204: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
7205: P_API_NAME => L_API_NAME
7206: ,P_PKG_NAME => G_PKG_NAME
7207: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
7208: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
7209: ,X_MSG_COUNT => X_MSG_COUNT
7210: ,X_MSG_DATA => X_MSG_DATA
7211: ,X_RETURN_STATUS => X_RETURN_STATUS);
7212:

Line 7214: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

7210: ,X_MSG_DATA => X_MSG_DATA
7211: ,X_RETURN_STATUS => X_RETURN_STATUS);
7212:
7213: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7214: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
7215: P_API_NAME => L_API_NAME
7216: ,P_PKG_NAME => G_PKG_NAME
7217: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
7218: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 7218: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

7214: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
7215: P_API_NAME => L_API_NAME
7216: ,P_PKG_NAME => G_PKG_NAME
7217: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
7218: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
7219: ,X_MSG_COUNT => X_MSG_COUNT
7220: ,X_MSG_DATA => X_MSG_DATA
7221: ,X_RETURN_STATUS => X_RETURN_STATUS);
7222:

Line 7224: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

7220: ,X_MSG_DATA => X_MSG_DATA
7221: ,X_RETURN_STATUS => X_RETURN_STATUS);
7222:
7223: WHEN OTHERS THEN
7224: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
7225: P_API_NAME => L_API_NAME
7226: ,P_PKG_NAME => G_PKG_NAME
7227: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
7228: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 7227: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS

7223: WHEN OTHERS THEN
7224: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
7225: P_API_NAME => L_API_NAME
7226: ,P_PKG_NAME => G_PKG_NAME
7227: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
7228: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
7229: ,X_MSG_COUNT => X_MSG_COUNT
7230: ,X_MSG_DATA => X_MSG_DATA
7231: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 7228: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

7224: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
7225: P_API_NAME => L_API_NAME
7226: ,P_PKG_NAME => G_PKG_NAME
7227: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
7228: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
7229: ,X_MSG_COUNT => X_MSG_COUNT
7230: ,X_MSG_DATA => X_MSG_DATA
7231: ,X_RETURN_STATUS => X_RETURN_STATUS);
7232: