[Home] [Help]
271: RAISE FND_API.G_EXC_ERROR;
272: END IF;
273:
274:
275: l_qte_header_rec := ASO_UTILITY_PVT.Query_Header_Row(P_Quote_Header_Id); -- Assigning the header record
276:
277: END IF; -- P_event in ('SUBMITTED', 'CANCELED', 'ACCEPTED')
278:
279: IF p_event = 'SUBMITTED' THEN
429:
430: i:=i+1;
431: -- Entering line level detail
432:
433: l_Qte_Line_Tbl(i) := ASO_UTILITY_PVT.Get_Qte_Line_rec;
434: l_qte_line_tbl(i).QUOTE_HEADER_ID := p_quote_header_id;
435: l_qte_line_tbl(i).QUOTE_line_id := l_quote_line_id;
436: l_qte_line_tbl(i).operation_code := 'UPDATE';
437:
459:
460:
461: -- for shipment line level changes
462: if (l_shipment_method_code is not null) and (l_shipment_method_code<>l_line_ship_method_code) then
463: l_ln_shipment_Tbl1:= ASO_UTILITY_PVT.Query_Shipment_Rows(P_Quote_Header_Id,l_quote_line_id); -- For Fetching line shipment terms
464:
465: IF aso_debug_pub.g_debug_flag='Y' THEN
466: aso_debug_pub.add( 'In call update quote from deal API Before Shipment'|| l_ln_shipment_Tbl1.count , 1 ) ;
467: END IF;
493:
494: --pp_debug('before Entered payment'|| l_payment_term_id||'line'||l_line_payment_term_id);
495: -- for payment terms line level changes
496: IF (l_payment_term_id is not NULL) and (l_payment_term_id <> l_line_payment_term_id) THEN
497: l_ln_Payment_Tbl1:= ASO_UTILITY_PVT.Query_Payment_Rows(P_Quote_Header_Id,l_quote_line_id); -- For Fetching header payment terms
498: IF aso_debug_pub.g_debug_flag='Y' THEN
499: aso_debug_pub.add( 'In call update quote from deal API payment number of rows: '||l_ln_Payment_Tbl1.count||',payment term id'||l_payment_term_id , 1 ) ;
500: END IF;
501: pa_index:=pa_index+1;
539: END IF;
540:
541: p_index:=p_index+1;
542: -- Assigning the price adjustments for line id fetched
543: l_Price_Adjustment_Tbl(p_index):= ASO_UTILITY_PVT.Get_price_adj_Rec;
544: l_Price_Adjustment_Tbl(p_index).quote_header_id:=p_quote_header_id;
545: l_Price_Adjustment_Tbl(p_index).quote_line_id:=l_quote_line_id;
546: l_Price_Adjustment_Tbl(p_index).price_adjustment_id:= cur_auto_adj.price_adjustment_id;
547: l_Price_Adjustment_Tbl(p_index).PRICE_BREAK_TYPE_CODE:= cur_auto_adj.PRICE_BREAK_TYPE_CODE;
672: --pp_debug( 'Modifier Adjustment exist ld_operand'||ld_operand);
673:
674: p_index:=p_index+1;
675: -- Assigning the price adjustments for line id fetched
676: l_Price_Adjustment_Tbl(p_index):= ASO_UTILITY_PVT.Get_price_adj_Rec;
677: l_Price_Adjustment_Tbl(p_index).quote_header_id:=p_quote_header_id;
678: l_Price_Adjustment_Tbl(p_index).quote_line_id:=l_quote_line_id;
679: l_Price_Adjustment_Tbl(p_index).price_adjustment_id:= l_price_adjustment_id;
680: l_Price_Adjustment_Tbl(p_index).applied_flag:= 'Y';
847: p_data => x_msg_data
848: );
849:
850:
851: ASO_UTILITY_PVT.Get_Messages(x_msg_count, x_msg_data);
852:
853:
854:
855: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
864: FND_MSG_PUB.Count_And_Get
865: ( p_count => x_msg_count,
866: p_data => x_msg_data
867: );
868: ASO_UTILITY_PVT.Get_Messages(x_msg_count, x_msg_data);
869:
870: WHEN OTHERS THEN
871: --pp_debug('error others aso_quote_pub'||DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
872: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
895: FND_MSG_PUB.Count_And_Get
896: ( p_count => x_msg_count,
897: p_data => x_msg_data
898: );
899: ASO_UTILITY_PVT.Get_Messages(x_msg_count, x_msg_data);
900:
901:
902: END Update_Quote_From_Deal;
903: