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_DEAL_PUB dependencies on ASO_QUOTE_PUB

Line 142: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type := ASO_QUOTE_PUB.G_Miss_Control_Rec;

138: l_operand ASO_PRICE_ADJUSTMENTS.OPERAND%TYPE;
139: ld_operand ASO_PRICE_ADJUSTMENTS.OPERAND%TYPE;
140:
141:
142: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type := ASO_QUOTE_PUB.G_Miss_Control_Rec;
143: l_qte_header_rec ASO_QUOTE_PUB.qte_Header_Rec_Type:=ASO_QUOTE_PUB.G_MISS_Qte_Header_Rec;
144:
145: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type:=ASO_QUOTE_PUB.G_MISS_Qte_Line_Rec;
146: l_qte_line_tbl ASO_QUOTE_PUB.QTE_LINE_Tbl_Type;

Line 143: l_qte_header_rec ASO_QUOTE_PUB.qte_Header_Rec_Type:=ASO_QUOTE_PUB.G_MISS_Qte_Header_Rec;

139: ld_operand ASO_PRICE_ADJUSTMENTS.OPERAND%TYPE;
140:
141:
142: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type := ASO_QUOTE_PUB.G_Miss_Control_Rec;
143: l_qte_header_rec ASO_QUOTE_PUB.qte_Header_Rec_Type:=ASO_QUOTE_PUB.G_MISS_Qte_Header_Rec;
144:
145: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type:=ASO_QUOTE_PUB.G_MISS_Qte_Line_Rec;
146: l_qte_line_tbl ASO_QUOTE_PUB.QTE_LINE_Tbl_Type;
147:

Line 145: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type:=ASO_QUOTE_PUB.G_MISS_Qte_Line_Rec;

141:
142: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type := ASO_QUOTE_PUB.G_Miss_Control_Rec;
143: l_qte_header_rec ASO_QUOTE_PUB.qte_Header_Rec_Type:=ASO_QUOTE_PUB.G_MISS_Qte_Header_Rec;
144:
145: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type:=ASO_QUOTE_PUB.G_MISS_Qte_Line_Rec;
146: l_qte_line_tbl ASO_QUOTE_PUB.QTE_LINE_Tbl_Type;
147:
148: l_ln_Payment_rec ASO_QUOTE_PUB.Payment_Rec_Type:=ASO_QUOTE_PUB.G_MISS_PAYMENT_rec;
149: l_ln_Payment_Tbl ASO_QUOTE_PUB.Payment_Tbl_Type:= ASO_QUOTE_PUB.G_MISS_PAYMENT_TBL;

Line 146: l_qte_line_tbl ASO_QUOTE_PUB.QTE_LINE_Tbl_Type;

142: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type := ASO_QUOTE_PUB.G_Miss_Control_Rec;
143: l_qte_header_rec ASO_QUOTE_PUB.qte_Header_Rec_Type:=ASO_QUOTE_PUB.G_MISS_Qte_Header_Rec;
144:
145: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type:=ASO_QUOTE_PUB.G_MISS_Qte_Line_Rec;
146: l_qte_line_tbl ASO_QUOTE_PUB.QTE_LINE_Tbl_Type;
147:
148: l_ln_Payment_rec ASO_QUOTE_PUB.Payment_Rec_Type:=ASO_QUOTE_PUB.G_MISS_PAYMENT_rec;
149: l_ln_Payment_Tbl ASO_QUOTE_PUB.Payment_Tbl_Type:= ASO_QUOTE_PUB.G_MISS_PAYMENT_TBL;
150: l_ln_Payment_Tbl1 ASO_QUOTE_PUB.Payment_Tbl_Type:= ASO_QUOTE_PUB.G_MISS_PAYMENT_TBL;

Line 148: l_ln_Payment_rec ASO_QUOTE_PUB.Payment_Rec_Type:=ASO_QUOTE_PUB.G_MISS_PAYMENT_rec;

144:
145: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type:=ASO_QUOTE_PUB.G_MISS_Qte_Line_Rec;
146: l_qte_line_tbl ASO_QUOTE_PUB.QTE_LINE_Tbl_Type;
147:
148: l_ln_Payment_rec ASO_QUOTE_PUB.Payment_Rec_Type:=ASO_QUOTE_PUB.G_MISS_PAYMENT_rec;
149: l_ln_Payment_Tbl ASO_QUOTE_PUB.Payment_Tbl_Type:= ASO_QUOTE_PUB.G_MISS_PAYMENT_TBL;
150: l_ln_Payment_Tbl1 ASO_QUOTE_PUB.Payment_Tbl_Type:= ASO_QUOTE_PUB.G_MISS_PAYMENT_TBL;
151:
152: l_ln_Shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type:=ASO_QUOTE_PUB.G_MISS_shipment_rec;

Line 149: l_ln_Payment_Tbl ASO_QUOTE_PUB.Payment_Tbl_Type:= ASO_QUOTE_PUB.G_MISS_PAYMENT_TBL;

145: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type:=ASO_QUOTE_PUB.G_MISS_Qte_Line_Rec;
146: l_qte_line_tbl ASO_QUOTE_PUB.QTE_LINE_Tbl_Type;
147:
148: l_ln_Payment_rec ASO_QUOTE_PUB.Payment_Rec_Type:=ASO_QUOTE_PUB.G_MISS_PAYMENT_rec;
149: l_ln_Payment_Tbl ASO_QUOTE_PUB.Payment_Tbl_Type:= ASO_QUOTE_PUB.G_MISS_PAYMENT_TBL;
150: l_ln_Payment_Tbl1 ASO_QUOTE_PUB.Payment_Tbl_Type:= ASO_QUOTE_PUB.G_MISS_PAYMENT_TBL;
151:
152: l_ln_Shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type:=ASO_QUOTE_PUB.G_MISS_shipment_rec;
153: l_ln_Shipment_Tbl ASO_QUOTE_PUB.Shipment_Tbl_Type:= ASO_QUOTE_PUB.G_MISS_SHIPMENT_TBL;

Line 150: l_ln_Payment_Tbl1 ASO_QUOTE_PUB.Payment_Tbl_Type:= ASO_QUOTE_PUB.G_MISS_PAYMENT_TBL;

146: l_qte_line_tbl ASO_QUOTE_PUB.QTE_LINE_Tbl_Type;
147:
148: l_ln_Payment_rec ASO_QUOTE_PUB.Payment_Rec_Type:=ASO_QUOTE_PUB.G_MISS_PAYMENT_rec;
149: l_ln_Payment_Tbl ASO_QUOTE_PUB.Payment_Tbl_Type:= ASO_QUOTE_PUB.G_MISS_PAYMENT_TBL;
150: l_ln_Payment_Tbl1 ASO_QUOTE_PUB.Payment_Tbl_Type:= ASO_QUOTE_PUB.G_MISS_PAYMENT_TBL;
151:
152: l_ln_Shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type:=ASO_QUOTE_PUB.G_MISS_shipment_rec;
153: l_ln_Shipment_Tbl ASO_QUOTE_PUB.Shipment_Tbl_Type:= ASO_QUOTE_PUB.G_MISS_SHIPMENT_TBL;
154: l_ln_Shipment_Tbl1 ASO_QUOTE_PUB.Shipment_Tbl_Type:= ASO_QUOTE_PUB.G_MISS_SHIPMENT_TBL;

Line 152: l_ln_Shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type:=ASO_QUOTE_PUB.G_MISS_shipment_rec;

148: l_ln_Payment_rec ASO_QUOTE_PUB.Payment_Rec_Type:=ASO_QUOTE_PUB.G_MISS_PAYMENT_rec;
149: l_ln_Payment_Tbl ASO_QUOTE_PUB.Payment_Tbl_Type:= ASO_QUOTE_PUB.G_MISS_PAYMENT_TBL;
150: l_ln_Payment_Tbl1 ASO_QUOTE_PUB.Payment_Tbl_Type:= ASO_QUOTE_PUB.G_MISS_PAYMENT_TBL;
151:
152: l_ln_Shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type:=ASO_QUOTE_PUB.G_MISS_shipment_rec;
153: l_ln_Shipment_Tbl ASO_QUOTE_PUB.Shipment_Tbl_Type:= ASO_QUOTE_PUB.G_MISS_SHIPMENT_TBL;
154: l_ln_Shipment_Tbl1 ASO_QUOTE_PUB.Shipment_Tbl_Type:= ASO_QUOTE_PUB.G_MISS_SHIPMENT_TBL;
155:
156: l_price_adj_rec ASO_QUOTE_PUB.Price_Adj_Rec_Type:= ASO_QUOTE_PUB.G_MISS_Price_Adj_REC ;

Line 153: l_ln_Shipment_Tbl ASO_QUOTE_PUB.Shipment_Tbl_Type:= ASO_QUOTE_PUB.G_MISS_SHIPMENT_TBL;

149: l_ln_Payment_Tbl ASO_QUOTE_PUB.Payment_Tbl_Type:= ASO_QUOTE_PUB.G_MISS_PAYMENT_TBL;
150: l_ln_Payment_Tbl1 ASO_QUOTE_PUB.Payment_Tbl_Type:= ASO_QUOTE_PUB.G_MISS_PAYMENT_TBL;
151:
152: l_ln_Shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type:=ASO_QUOTE_PUB.G_MISS_shipment_rec;
153: l_ln_Shipment_Tbl ASO_QUOTE_PUB.Shipment_Tbl_Type:= ASO_QUOTE_PUB.G_MISS_SHIPMENT_TBL;
154: l_ln_Shipment_Tbl1 ASO_QUOTE_PUB.Shipment_Tbl_Type:= ASO_QUOTE_PUB.G_MISS_SHIPMENT_TBL;
155:
156: l_price_adj_rec ASO_QUOTE_PUB.Price_Adj_Rec_Type:= ASO_QUOTE_PUB.G_MISS_Price_Adj_REC ;
157: l_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type:= ASO_QUOTE_PUB.G_Miss_Price_Adj_Tbl;

Line 154: l_ln_Shipment_Tbl1 ASO_QUOTE_PUB.Shipment_Tbl_Type:= ASO_QUOTE_PUB.G_MISS_SHIPMENT_TBL;

150: l_ln_Payment_Tbl1 ASO_QUOTE_PUB.Payment_Tbl_Type:= ASO_QUOTE_PUB.G_MISS_PAYMENT_TBL;
151:
152: l_ln_Shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type:=ASO_QUOTE_PUB.G_MISS_shipment_rec;
153: l_ln_Shipment_Tbl ASO_QUOTE_PUB.Shipment_Tbl_Type:= ASO_QUOTE_PUB.G_MISS_SHIPMENT_TBL;
154: l_ln_Shipment_Tbl1 ASO_QUOTE_PUB.Shipment_Tbl_Type:= ASO_QUOTE_PUB.G_MISS_SHIPMENT_TBL;
155:
156: l_price_adj_rec ASO_QUOTE_PUB.Price_Adj_Rec_Type:= ASO_QUOTE_PUB.G_MISS_Price_Adj_REC ;
157: l_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type:= ASO_QUOTE_PUB.G_Miss_Price_Adj_Tbl;
158:

Line 156: l_price_adj_rec ASO_QUOTE_PUB.Price_Adj_Rec_Type:= ASO_QUOTE_PUB.G_MISS_Price_Adj_REC ;

152: l_ln_Shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type:=ASO_QUOTE_PUB.G_MISS_shipment_rec;
153: l_ln_Shipment_Tbl ASO_QUOTE_PUB.Shipment_Tbl_Type:= ASO_QUOTE_PUB.G_MISS_SHIPMENT_TBL;
154: l_ln_Shipment_Tbl1 ASO_QUOTE_PUB.Shipment_Tbl_Type:= ASO_QUOTE_PUB.G_MISS_SHIPMENT_TBL;
155:
156: l_price_adj_rec ASO_QUOTE_PUB.Price_Adj_Rec_Type:= ASO_QUOTE_PUB.G_MISS_Price_Adj_REC ;
157: l_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type:= ASO_QUOTE_PUB.G_Miss_Price_Adj_Tbl;
158:
159:
160:

Line 157: l_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type:= ASO_QUOTE_PUB.G_Miss_Price_Adj_Tbl;

153: l_ln_Shipment_Tbl ASO_QUOTE_PUB.Shipment_Tbl_Type:= ASO_QUOTE_PUB.G_MISS_SHIPMENT_TBL;
154: l_ln_Shipment_Tbl1 ASO_QUOTE_PUB.Shipment_Tbl_Type:= ASO_QUOTE_PUB.G_MISS_SHIPMENT_TBL;
155:
156: l_price_adj_rec ASO_QUOTE_PUB.Price_Adj_Rec_Type:= ASO_QUOTE_PUB.G_MISS_Price_Adj_REC ;
157: l_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type:= ASO_QUOTE_PUB.G_Miss_Price_Adj_Tbl;
158:
159:
160:
161: --

Line 163: lx_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;

159:
160:
161: --
162:
163: lx_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
164: lx_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
165: lx_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
166: lx_hd_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
167: lx_hd_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;

Line 164: lx_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;

160:
161: --
162:
163: lx_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
164: lx_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
165: lx_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
166: lx_hd_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
167: lx_hd_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
168: lx_hd_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;

Line 165: lx_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;

161: --
162:
163: lx_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
164: lx_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
165: lx_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
166: lx_hd_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
167: lx_hd_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
168: lx_hd_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
169: lx_hd_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;

Line 166: lx_hd_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;

162:
163: lx_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
164: lx_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
165: lx_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
166: lx_hd_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
167: lx_hd_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
168: lx_hd_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
169: lx_hd_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
170: lx_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;

Line 167: lx_hd_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;

163: lx_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
164: lx_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
165: lx_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
166: lx_hd_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
167: lx_hd_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
168: lx_hd_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
169: lx_hd_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
170: lx_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
171:

Line 168: lx_hd_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;

164: lx_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
165: lx_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
166: lx_hd_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
167: lx_hd_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
168: lx_hd_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
169: lx_hd_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
170: lx_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
171:
172: lx_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;

Line 169: lx_hd_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;

165: lx_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
166: lx_hd_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
167: lx_hd_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
168: lx_hd_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
169: lx_hd_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
170: lx_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
171:
172: lx_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
173: lx_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;

Line 170: lx_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;

166: lx_hd_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
167: lx_hd_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
168: lx_hd_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
169: lx_hd_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
170: lx_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
171:
172: lx_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
173: lx_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
174: lx_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;

Line 172: lx_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;

168: lx_hd_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
169: lx_hd_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
170: lx_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
171:
172: lx_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
173: lx_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
174: lx_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
175: lx_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
176: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;

Line 173: lx_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;

169: lx_hd_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
170: lx_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
171:
172: lx_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
173: lx_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
174: lx_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
175: lx_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
176: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
177: lx_ln_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;

Line 174: lx_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;

170: lx_hd_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
171:
172: lx_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
173: lx_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
174: lx_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
175: lx_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
176: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
177: lx_ln_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
178: lx_ln_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;

Line 175: lx_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;

171:
172: lx_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
173: lx_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
174: lx_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
175: lx_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
176: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
177: lx_ln_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
178: lx_ln_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
179: lx_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;

Line 176: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;

172: lx_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
173: lx_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
174: lx_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
175: lx_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
176: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
177: lx_ln_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
178: lx_ln_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
179: lx_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
180: lx_ln_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;

Line 177: lx_ln_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;

173: lx_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
174: lx_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
175: lx_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
176: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
177: lx_ln_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
178: lx_ln_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
179: lx_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
180: lx_ln_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
181: lx_ln_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;

Line 178: lx_ln_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;

174: lx_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
175: lx_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
176: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
177: lx_ln_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
178: lx_ln_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
179: lx_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
180: lx_ln_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
181: lx_ln_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
182:

Line 179: lx_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;

175: lx_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
176: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
177: lx_ln_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
178: lx_ln_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
179: lx_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
180: lx_ln_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
181: lx_ln_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
182:
183: l_file VARCHAR2(200); -- for log generation

Line 180: lx_ln_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;

176: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
177: lx_ln_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
178: lx_ln_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
179: lx_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
180: lx_ln_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
181: lx_ln_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
182:
183: l_file VARCHAR2(200); -- for log generation
184:

Line 181: lx_ln_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;

177: lx_ln_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
178: lx_ln_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
179: lx_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
180: lx_ln_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
181: lx_ln_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
182:
183: l_file VARCHAR2(200); -- for log generation
184:
185: l_len_sqlerrm Number ; -- For error handling

Line 470: l_ln_shipment_Tbl(s_index):=ASO_QUOTE_PUB.G_MISS_Shipment_REC;

466: aso_debug_pub.add( 'In call update quote from deal API Before Shipment'|| l_ln_shipment_Tbl1.count , 1 ) ;
467: END IF;
468: s_index:=s_index+1;
469: if l_ln_shipment_Tbl1.count = 0 then
470: l_ln_shipment_Tbl(s_index):=ASO_QUOTE_PUB.G_MISS_Shipment_REC;
471: l_ln_shipment_Tbl(s_index).Quote_Header_Id := P_Quote_Header_Id;
472: l_ln_shipment_Tbl(s_index).Quote_line_Id := l_quote_line_id;
473: l_ln_shipment_Tbl(s_index).SHIP_METHOD_CODE := l_shipment_method_code;
474: l_ln_shipment_Tbl(s_index).operation_code := 'CREATE' ;

Line 476: l_ln_shipment_Tbl(s_index):=ASO_QUOTE_PUB.G_MISS_Shipment_REC;

472: l_ln_shipment_Tbl(s_index).Quote_line_Id := l_quote_line_id;
473: l_ln_shipment_Tbl(s_index).SHIP_METHOD_CODE := l_shipment_method_code;
474: l_ln_shipment_Tbl(s_index).operation_code := 'CREATE' ;
475: elsif l_ln_shipment_Tbl1.count > 0 then
476: l_ln_shipment_Tbl(s_index):=ASO_QUOTE_PUB.G_MISS_Shipment_REC;
477: l_ln_shipment_rec:=l_ln_shipment_Tbl1(1);
478: l_ln_shipment_rec.Quote_Header_Id := P_Quote_Header_Id;
479: l_ln_shipment_rec.Quote_line_Id := l_quote_line_id;
480: l_ln_shipment_rec.SHIP_METHOD_CODE := l_shipment_method_code;

Line 503: l_ln_Payment_Tbl(pa_index):=ASO_QUOTE_PUB.G_MISS_Payment_REC;

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;
502: if l_ln_Payment_Tbl1.count = 0 then
503: l_ln_Payment_Tbl(pa_index):=ASO_QUOTE_PUB.G_MISS_Payment_REC;
504: l_ln_Payment_Tbl(pa_index).Quote_Header_Id := P_Quote_Header_Id;
505: l_ln_Payment_Tbl(pa_index).Quote_line_Id := l_quote_line_id;
506: l_ln_Payment_Tbl(pa_index).PAYMENT_TERM_ID := l_payment_term_id;
507: l_ln_Payment_Tbl(pa_index).operation_code := 'CREATE' ;

Line 509: l_ln_Payment_Tbl(pa_index):=ASO_QUOTE_PUB.G_MISS_Payment_REC;

505: l_ln_Payment_Tbl(pa_index).Quote_line_Id := l_quote_line_id;
506: l_ln_Payment_Tbl(pa_index).PAYMENT_TERM_ID := l_payment_term_id;
507: l_ln_Payment_Tbl(pa_index).operation_code := 'CREATE' ;
508: elsif l_ln_Payment_Tbl1.count > 0 then
509: l_ln_Payment_Tbl(pa_index):=ASO_QUOTE_PUB.G_MISS_Payment_REC;
510: l_ln_Payment_rec:=l_ln_Payment_Tbl1(1);
511: IF aso_debug_pub.g_debug_flag='Y' THEN
512: aso_debug_pub.add( 'In call update quote from deal API after payment number of rows: '||l_ln_Payment_rec.payment_id, 1 ) ;
513: END IF;

Line 751: aso_debug_pub.add('ASO_DEAL_PUB before aso_quote_pub.update_quote - '||p_event, 1, 'Y');

747: END IF;
748:
749: IF P_event in ('ACCEPTED') then
750: IF aso_debug_pub.g_debug_flag = 'Y' then
751: aso_debug_pub.add('ASO_DEAL_PUB before aso_quote_pub.update_quote - '||p_event, 1, 'Y');
752: aso_debug_pub.add('ASO_DEAL_PUB:l_qte_header_rec.quote_status_id - '||l_qte_header_rec.quote_status_id, 1, 'Y');
753: aso_debug_pub.ADD ('Before calling update quote: Setting the single org context to org_id: '|| l_qte_header_rec.org_id,1,'N');
754: END IF;
755:

Line 759: aso_quote_pub.update_quote (

755:
756: -- Setting MOAC
757: mo_global.set_policy_context('S', l_qte_header_rec.org_id);
758:
759: aso_quote_pub.update_quote (
760: p_api_version_number => 1.0,
761: p_init_msg_list => fnd_api.g_false,
762: p_commit => fnd_api.g_false,
763: p_control_rec => l_control_rec,

Line 765: p_hd_price_attributes_tbl => aso_quote_pub.g_miss_price_attributes_tbl,

761: p_init_msg_list => fnd_api.g_false,
762: p_commit => fnd_api.g_false,
763: p_control_rec => l_control_rec,
764: p_qte_header_rec => l_qte_header_rec,
765: p_hd_price_attributes_tbl => aso_quote_pub.g_miss_price_attributes_tbl,
766: p_hd_payment_tbl => aso_quote_pub.g_miss_payment_tbl,
767: p_hd_shipment_tbl => aso_quote_pub.g_miss_shipment_tbl,
768: p_hd_freight_charge_tbl => aso_quote_pub.g_miss_freight_charge_tbl,
769: p_hd_tax_detail_tbl => aso_quote_pub.g_miss_tax_detail_tbl,

Line 766: p_hd_payment_tbl => aso_quote_pub.g_miss_payment_tbl,

762: p_commit => fnd_api.g_false,
763: p_control_rec => l_control_rec,
764: p_qte_header_rec => l_qte_header_rec,
765: p_hd_price_attributes_tbl => aso_quote_pub.g_miss_price_attributes_tbl,
766: p_hd_payment_tbl => aso_quote_pub.g_miss_payment_tbl,
767: p_hd_shipment_tbl => aso_quote_pub.g_miss_shipment_tbl,
768: p_hd_freight_charge_tbl => aso_quote_pub.g_miss_freight_charge_tbl,
769: p_hd_tax_detail_tbl => aso_quote_pub.g_miss_tax_detail_tbl,
770: p_qte_line_tbl => l_qte_line_tbl, -- need to change here

Line 767: p_hd_shipment_tbl => aso_quote_pub.g_miss_shipment_tbl,

763: p_control_rec => l_control_rec,
764: p_qte_header_rec => l_qte_header_rec,
765: p_hd_price_attributes_tbl => aso_quote_pub.g_miss_price_attributes_tbl,
766: p_hd_payment_tbl => aso_quote_pub.g_miss_payment_tbl,
767: p_hd_shipment_tbl => aso_quote_pub.g_miss_shipment_tbl,
768: p_hd_freight_charge_tbl => aso_quote_pub.g_miss_freight_charge_tbl,
769: p_hd_tax_detail_tbl => aso_quote_pub.g_miss_tax_detail_tbl,
770: p_qte_line_tbl => l_qte_line_tbl, -- need to change here
771: p_qte_line_dtl_tbl => aso_quote_pub.g_miss_qte_line_dtl_tbl,

Line 768: p_hd_freight_charge_tbl => aso_quote_pub.g_miss_freight_charge_tbl,

764: p_qte_header_rec => l_qte_header_rec,
765: p_hd_price_attributes_tbl => aso_quote_pub.g_miss_price_attributes_tbl,
766: p_hd_payment_tbl => aso_quote_pub.g_miss_payment_tbl,
767: p_hd_shipment_tbl => aso_quote_pub.g_miss_shipment_tbl,
768: p_hd_freight_charge_tbl => aso_quote_pub.g_miss_freight_charge_tbl,
769: p_hd_tax_detail_tbl => aso_quote_pub.g_miss_tax_detail_tbl,
770: p_qte_line_tbl => l_qte_line_tbl, -- need to change here
771: p_qte_line_dtl_tbl => aso_quote_pub.g_miss_qte_line_dtl_tbl,
772: p_line_attr_ext_tbl => aso_quote_pub.g_miss_line_attribs_ext_tbl,

Line 769: p_hd_tax_detail_tbl => aso_quote_pub.g_miss_tax_detail_tbl,

765: p_hd_price_attributes_tbl => aso_quote_pub.g_miss_price_attributes_tbl,
766: p_hd_payment_tbl => aso_quote_pub.g_miss_payment_tbl,
767: p_hd_shipment_tbl => aso_quote_pub.g_miss_shipment_tbl,
768: p_hd_freight_charge_tbl => aso_quote_pub.g_miss_freight_charge_tbl,
769: p_hd_tax_detail_tbl => aso_quote_pub.g_miss_tax_detail_tbl,
770: p_qte_line_tbl => l_qte_line_tbl, -- need to change here
771: p_qte_line_dtl_tbl => aso_quote_pub.g_miss_qte_line_dtl_tbl,
772: p_line_attr_ext_tbl => aso_quote_pub.g_miss_line_attribs_ext_tbl,
773: p_line_rltship_tbl => aso_quote_pub.g_miss_line_rltship_tbl,

Line 771: p_qte_line_dtl_tbl => aso_quote_pub.g_miss_qte_line_dtl_tbl,

767: p_hd_shipment_tbl => aso_quote_pub.g_miss_shipment_tbl,
768: p_hd_freight_charge_tbl => aso_quote_pub.g_miss_freight_charge_tbl,
769: p_hd_tax_detail_tbl => aso_quote_pub.g_miss_tax_detail_tbl,
770: p_qte_line_tbl => l_qte_line_tbl, -- need to change here
771: p_qte_line_dtl_tbl => aso_quote_pub.g_miss_qte_line_dtl_tbl,
772: p_line_attr_ext_tbl => aso_quote_pub.g_miss_line_attribs_ext_tbl,
773: p_line_rltship_tbl => aso_quote_pub.g_miss_line_rltship_tbl,
774: p_price_adjustment_tbl => l_Price_Adjustment_Tbl,
775: p_price_adj_attr_tbl => aso_quote_pub.g_miss_price_adj_attr_tbl,

Line 772: p_line_attr_ext_tbl => aso_quote_pub.g_miss_line_attribs_ext_tbl,

768: p_hd_freight_charge_tbl => aso_quote_pub.g_miss_freight_charge_tbl,
769: p_hd_tax_detail_tbl => aso_quote_pub.g_miss_tax_detail_tbl,
770: p_qte_line_tbl => l_qte_line_tbl, -- need to change here
771: p_qte_line_dtl_tbl => aso_quote_pub.g_miss_qte_line_dtl_tbl,
772: p_line_attr_ext_tbl => aso_quote_pub.g_miss_line_attribs_ext_tbl,
773: p_line_rltship_tbl => aso_quote_pub.g_miss_line_rltship_tbl,
774: p_price_adjustment_tbl => l_Price_Adjustment_Tbl,
775: p_price_adj_attr_tbl => aso_quote_pub.g_miss_price_adj_attr_tbl,
776: p_price_adj_rltship_tbl => aso_quote_pub.g_miss_price_adj_rltship_tbl,

Line 773: p_line_rltship_tbl => aso_quote_pub.g_miss_line_rltship_tbl,

769: p_hd_tax_detail_tbl => aso_quote_pub.g_miss_tax_detail_tbl,
770: p_qte_line_tbl => l_qte_line_tbl, -- need to change here
771: p_qte_line_dtl_tbl => aso_quote_pub.g_miss_qte_line_dtl_tbl,
772: p_line_attr_ext_tbl => aso_quote_pub.g_miss_line_attribs_ext_tbl,
773: p_line_rltship_tbl => aso_quote_pub.g_miss_line_rltship_tbl,
774: p_price_adjustment_tbl => l_Price_Adjustment_Tbl,
775: p_price_adj_attr_tbl => aso_quote_pub.g_miss_price_adj_attr_tbl,
776: p_price_adj_rltship_tbl => aso_quote_pub.g_miss_price_adj_rltship_tbl,
777: p_ln_price_attributes_tbl => aso_quote_pub.g_miss_price_attributes_tbl,

Line 775: p_price_adj_attr_tbl => aso_quote_pub.g_miss_price_adj_attr_tbl,

771: p_qte_line_dtl_tbl => aso_quote_pub.g_miss_qte_line_dtl_tbl,
772: p_line_attr_ext_tbl => aso_quote_pub.g_miss_line_attribs_ext_tbl,
773: p_line_rltship_tbl => aso_quote_pub.g_miss_line_rltship_tbl,
774: p_price_adjustment_tbl => l_Price_Adjustment_Tbl,
775: p_price_adj_attr_tbl => aso_quote_pub.g_miss_price_adj_attr_tbl,
776: p_price_adj_rltship_tbl => aso_quote_pub.g_miss_price_adj_rltship_tbl,
777: p_ln_price_attributes_tbl => aso_quote_pub.g_miss_price_attributes_tbl,
778: p_ln_payment_tbl => l_ln_Payment_Tbl,
779: p_ln_shipment_tbl => l_ln_shipment_Tbl,

Line 776: p_price_adj_rltship_tbl => aso_quote_pub.g_miss_price_adj_rltship_tbl,

772: p_line_attr_ext_tbl => aso_quote_pub.g_miss_line_attribs_ext_tbl,
773: p_line_rltship_tbl => aso_quote_pub.g_miss_line_rltship_tbl,
774: p_price_adjustment_tbl => l_Price_Adjustment_Tbl,
775: p_price_adj_attr_tbl => aso_quote_pub.g_miss_price_adj_attr_tbl,
776: p_price_adj_rltship_tbl => aso_quote_pub.g_miss_price_adj_rltship_tbl,
777: p_ln_price_attributes_tbl => aso_quote_pub.g_miss_price_attributes_tbl,
778: p_ln_payment_tbl => l_ln_Payment_Tbl,
779: p_ln_shipment_tbl => l_ln_shipment_Tbl,
780: p_ln_freight_charge_tbl => aso_quote_pub.g_miss_freight_charge_tbl,

Line 777: p_ln_price_attributes_tbl => aso_quote_pub.g_miss_price_attributes_tbl,

773: p_line_rltship_tbl => aso_quote_pub.g_miss_line_rltship_tbl,
774: p_price_adjustment_tbl => l_Price_Adjustment_Tbl,
775: p_price_adj_attr_tbl => aso_quote_pub.g_miss_price_adj_attr_tbl,
776: p_price_adj_rltship_tbl => aso_quote_pub.g_miss_price_adj_rltship_tbl,
777: p_ln_price_attributes_tbl => aso_quote_pub.g_miss_price_attributes_tbl,
778: p_ln_payment_tbl => l_ln_Payment_Tbl,
779: p_ln_shipment_tbl => l_ln_shipment_Tbl,
780: p_ln_freight_charge_tbl => aso_quote_pub.g_miss_freight_charge_tbl,
781: p_ln_tax_detail_tbl => aso_quote_pub.g_miss_tax_detail_tbl,

Line 780: p_ln_freight_charge_tbl => aso_quote_pub.g_miss_freight_charge_tbl,

776: p_price_adj_rltship_tbl => aso_quote_pub.g_miss_price_adj_rltship_tbl,
777: p_ln_price_attributes_tbl => aso_quote_pub.g_miss_price_attributes_tbl,
778: p_ln_payment_tbl => l_ln_Payment_Tbl,
779: p_ln_shipment_tbl => l_ln_shipment_Tbl,
780: p_ln_freight_charge_tbl => aso_quote_pub.g_miss_freight_charge_tbl,
781: p_ln_tax_detail_tbl => aso_quote_pub.g_miss_tax_detail_tbl,
782: x_qte_header_rec => lx_qte_header_rec,
783: x_qte_line_tbl => lx_qte_line_tbl,
784: x_qte_line_dtl_tbl => lx_qte_line_dtl_tbl,

Line 781: p_ln_tax_detail_tbl => aso_quote_pub.g_miss_tax_detail_tbl,

777: p_ln_price_attributes_tbl => aso_quote_pub.g_miss_price_attributes_tbl,
778: p_ln_payment_tbl => l_ln_Payment_Tbl,
779: p_ln_shipment_tbl => l_ln_shipment_Tbl,
780: p_ln_freight_charge_tbl => aso_quote_pub.g_miss_freight_charge_tbl,
781: p_ln_tax_detail_tbl => aso_quote_pub.g_miss_tax_detail_tbl,
782: x_qte_header_rec => lx_qte_header_rec,
783: x_qte_line_tbl => lx_qte_line_tbl,
784: x_qte_line_dtl_tbl => lx_qte_line_dtl_tbl,
785: x_hd_price_attributes_tbl => lx_hd_price_attr_tbl,

Line 805: --pp_debug('after calling aso_quote_pub');

801: x_msg_count => x_msg_count,
802: x_msg_data => x_msg_data
803: );
804:
805: --pp_debug('after calling aso_quote_pub');
806: IF aso_debug_pub.g_debug_flag = 'Y' THEN
807: aso_debug_pub.add('ASO_DEAL_PUB: after Update_Quote', 1, 'Y');
808: END IF;
809:

Line 818: --pp_debug('after calling aso_quote_pub error');

814: and PRICING_LINE_TYPE_INDICATOR='D';
815:
816:
817: elsIF x_return_status = FND_API.G_RET_STS_ERROR THEN
818: --pp_debug('after calling aso_quote_pub error');
819: RAISE FND_API.G_EXC_ERROR;
820: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
821: --pp_debug('after calling aso_quote_pub unerror');
822: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 821: --pp_debug('after calling aso_quote_pub unerror');

817: elsIF x_return_status = FND_API.G_RET_STS_ERROR THEN
818: --pp_debug('after calling aso_quote_pub error');
819: RAISE FND_API.G_EXC_ERROR;
820: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
821: --pp_debug('after calling aso_quote_pub unerror');
822: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
823: END IF;
824: END IF; -- end if status
825:

Line 835: --pp_debug('error aso_quote_pub');

831: );
832:
833: EXCEPTION
834: WHEN FND_API.G_EXC_ERROR THEN
835: --pp_debug('error aso_quote_pub');
836:
837:
838: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
839: aso_debug_pub.add('Exception in package : '|| G_PKG_NAME, 1, 'N');

Line 856: --pp_debug('unerror aso_quote_pub'||DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

852:
853:
854:
855: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
856: --pp_debug('unerror aso_quote_pub'||DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
857:
858: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
859: aso_debug_pub.add('Exception in package : '|| G_PKG_NAME, 1, 'N');
860: aso_debug_pub.add('Exception in API : '|| L_API_NAME, 1, 'N');

Line 871: --pp_debug('error others aso_quote_pub'||DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

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
873: aso_debug_pub.add('Exception in package : '|| G_PKG_NAME, 1, 'N');
874: aso_debug_pub.add('Exception in API : '|| L_API_NAME, 1, 'N');
875: aso_debug_pub.add('SQLCODE : '|| SQLCODE, 1, 'N');