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

Line 1: PACKAGE BODY ASO_QUOTE_PUB as

1: PACKAGE BODY ASO_QUOTE_PUB as
2: /* $Header: asopqteb.pls 120.11 2012/03/13 05:32:42 rassharm ship $ */
3: -- Start of Comments
4: -- Package name : ASO_QUOTE_PUB
5: -- Purpose :

Line 4: -- Package name : ASO_QUOTE_PUB

1: PACKAGE BODY ASO_QUOTE_PUB as
2: /* $Header: asopqteb.pls 120.11 2012/03/13 05:32:42 rassharm ship $ */
3: -- Start of Comments
4: -- Package name : ASO_QUOTE_PUB
5: -- Purpose :
6: -- History :
7: -- 12-16-04 skulkarn: fixed bug 4046692
8: -- NOTE :

Line 12: G_PKG_NAME CONSTANT VARCHAR2(30):= 'ASO_QUOTE_PUB';

8: -- NOTE :
9: -- End of Comments
10:
11:
12: G_PKG_NAME CONSTANT VARCHAR2(30):= 'ASO_QUOTE_PUB';
13: G_FILE_NAME CONSTANT VARCHAR2(12) := 'asopqteb.pls';
14:
15:
16: x_msg_count number;

Line 275: P_hd_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type := G_Miss_Price_Attributes_Tbl,

271: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
272: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
273: P_Control_Rec IN Control_Rec_Type := G_Miss_Control_Rec,
274: P_Qte_Header_Rec IN Qte_Header_Rec_Type := G_MISS_Qte_Header_Rec,
275: P_hd_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type := G_Miss_Price_Attributes_Tbl,
276: P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type := G_MISS_PAYMENT_TBL,
277: P_hd_Shipment_Rec IN ASO_QUOTE_PUB.Shipment_Rec_Type := G_MISS_SHIPMENT_REC,
278: P_hd_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type := G_Miss_Freight_Charge_Tbl,
279: P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type := G_Miss_Tax_Detail_Tbl,

Line 276: P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type := G_MISS_PAYMENT_TBL,

272: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
273: P_Control_Rec IN Control_Rec_Type := G_Miss_Control_Rec,
274: P_Qte_Header_Rec IN Qte_Header_Rec_Type := G_MISS_Qte_Header_Rec,
275: P_hd_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type := G_Miss_Price_Attributes_Tbl,
276: P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type := G_MISS_PAYMENT_TBL,
277: P_hd_Shipment_Rec IN ASO_QUOTE_PUB.Shipment_Rec_Type := G_MISS_SHIPMENT_REC,
278: P_hd_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type := G_Miss_Freight_Charge_Tbl,
279: P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type := G_Miss_Tax_Detail_Tbl,
280: P_Qte_Line_Tbl IN Qte_Line_Tbl_Type := G_MISS_QTE_LINE_TBL,

Line 277: P_hd_Shipment_Rec IN ASO_QUOTE_PUB.Shipment_Rec_Type := G_MISS_SHIPMENT_REC,

273: P_Control_Rec IN Control_Rec_Type := G_Miss_Control_Rec,
274: P_Qte_Header_Rec IN Qte_Header_Rec_Type := G_MISS_Qte_Header_Rec,
275: P_hd_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type := G_Miss_Price_Attributes_Tbl,
276: P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type := G_MISS_PAYMENT_TBL,
277: P_hd_Shipment_Rec IN ASO_QUOTE_PUB.Shipment_Rec_Type := G_MISS_SHIPMENT_REC,
278: P_hd_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type := G_Miss_Freight_Charge_Tbl,
279: P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type := G_Miss_Tax_Detail_Tbl,
280: P_Qte_Line_Tbl IN Qte_Line_Tbl_Type := G_MISS_QTE_LINE_TBL,
281: P_Qte_Line_Dtl_Tbl IN Qte_Line_Dtl_Tbl_Type := G_MISS_QTE_LINE_DTL_TBL,

Line 278: P_hd_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type := G_Miss_Freight_Charge_Tbl,

274: P_Qte_Header_Rec IN Qte_Header_Rec_Type := G_MISS_Qte_Header_Rec,
275: P_hd_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type := G_Miss_Price_Attributes_Tbl,
276: P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type := G_MISS_PAYMENT_TBL,
277: P_hd_Shipment_Rec IN ASO_QUOTE_PUB.Shipment_Rec_Type := G_MISS_SHIPMENT_REC,
278: P_hd_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type := G_Miss_Freight_Charge_Tbl,
279: P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type := G_Miss_Tax_Detail_Tbl,
280: P_Qte_Line_Tbl IN Qte_Line_Tbl_Type := G_MISS_QTE_LINE_TBL,
281: P_Qte_Line_Dtl_Tbl IN Qte_Line_Dtl_Tbl_Type := G_MISS_QTE_LINE_DTL_TBL,
282: P_Line_Attr_Ext_Tbl IN Line_Attribs_Ext_Tbl_Type := G_MISS_Line_Attribs_Ext_TBL,

Line 279: P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type := G_Miss_Tax_Detail_Tbl,

275: P_hd_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type := G_Miss_Price_Attributes_Tbl,
276: P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type := G_MISS_PAYMENT_TBL,
277: P_hd_Shipment_Rec IN ASO_QUOTE_PUB.Shipment_Rec_Type := G_MISS_SHIPMENT_REC,
278: P_hd_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type := G_Miss_Freight_Charge_Tbl,
279: P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type := G_Miss_Tax_Detail_Tbl,
280: P_Qte_Line_Tbl IN Qte_Line_Tbl_Type := G_MISS_QTE_LINE_TBL,
281: P_Qte_Line_Dtl_Tbl IN Qte_Line_Dtl_Tbl_Type := G_MISS_QTE_LINE_DTL_TBL,
282: P_Line_Attr_Ext_Tbl IN Line_Attribs_Ext_Tbl_Type := G_MISS_Line_Attribs_Ext_TBL,
283: P_line_rltship_tbl IN Line_Rltship_Tbl_Type := G_MISS_Line_Rltship_Tbl,

Line 384: P_hd_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type := G_Miss_Price_Attributes_Tbl,

380: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
381: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
382: P_Control_Rec IN Control_Rec_Type := G_Miss_Control_Rec,
383: P_Qte_Header_Rec IN Qte_Header_Rec_Type := G_MISS_Qte_Header_Rec,
384: P_hd_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type := G_Miss_Price_Attributes_Tbl,
385: P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type := G_MISS_PAYMENT_TBL,
386: P_hd_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type := G_MISS_SHIPMENT_TBL,
387: P_hd_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type := G_Miss_Freight_Charge_Tbl,
388: P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type := G_Miss_Tax_Detail_Tbl,

Line 385: P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type := G_MISS_PAYMENT_TBL,

381: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
382: P_Control_Rec IN Control_Rec_Type := G_Miss_Control_Rec,
383: P_Qte_Header_Rec IN Qte_Header_Rec_Type := G_MISS_Qte_Header_Rec,
384: P_hd_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type := G_Miss_Price_Attributes_Tbl,
385: P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type := G_MISS_PAYMENT_TBL,
386: P_hd_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type := G_MISS_SHIPMENT_TBL,
387: P_hd_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type := G_Miss_Freight_Charge_Tbl,
388: P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type := G_Miss_Tax_Detail_Tbl,
389: P_Qte_Line_Tbl IN Qte_Line_Tbl_Type := G_MISS_QTE_LINE_TBL,

Line 386: P_hd_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type := G_MISS_SHIPMENT_TBL,

382: P_Control_Rec IN Control_Rec_Type := G_Miss_Control_Rec,
383: P_Qte_Header_Rec IN Qte_Header_Rec_Type := G_MISS_Qte_Header_Rec,
384: P_hd_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type := G_Miss_Price_Attributes_Tbl,
385: P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type := G_MISS_PAYMENT_TBL,
386: P_hd_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type := G_MISS_SHIPMENT_TBL,
387: P_hd_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type := G_Miss_Freight_Charge_Tbl,
388: P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type := G_Miss_Tax_Detail_Tbl,
389: P_Qte_Line_Tbl IN Qte_Line_Tbl_Type := G_MISS_QTE_LINE_TBL,
390: P_Qte_Line_Dtl_Tbl IN Qte_Line_Dtl_Tbl_Type := G_MISS_QTE_LINE_DTL_TBL,

Line 387: P_hd_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type := G_Miss_Freight_Charge_Tbl,

383: P_Qte_Header_Rec IN Qte_Header_Rec_Type := G_MISS_Qte_Header_Rec,
384: P_hd_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type := G_Miss_Price_Attributes_Tbl,
385: P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type := G_MISS_PAYMENT_TBL,
386: P_hd_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type := G_MISS_SHIPMENT_TBL,
387: P_hd_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type := G_Miss_Freight_Charge_Tbl,
388: P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type := G_Miss_Tax_Detail_Tbl,
389: P_Qte_Line_Tbl IN Qte_Line_Tbl_Type := G_MISS_QTE_LINE_TBL,
390: P_Qte_Line_Dtl_Tbl IN Qte_Line_Dtl_Tbl_Type := G_MISS_QTE_LINE_DTL_TBL,
391: P_Line_Attr_Ext_Tbl IN Line_Attribs_Ext_Tbl_Type := G_MISS_Line_Attribs_Ext_TBL,

Line 388: P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type := G_Miss_Tax_Detail_Tbl,

384: P_hd_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type := G_Miss_Price_Attributes_Tbl,
385: P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type := G_MISS_PAYMENT_TBL,
386: P_hd_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type := G_MISS_SHIPMENT_TBL,
387: P_hd_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type := G_Miss_Freight_Charge_Tbl,
388: P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type := G_Miss_Tax_Detail_Tbl,
389: P_Qte_Line_Tbl IN Qte_Line_Tbl_Type := G_MISS_QTE_LINE_TBL,
390: P_Qte_Line_Dtl_Tbl IN Qte_Line_Dtl_Tbl_Type := G_MISS_QTE_LINE_DTL_TBL,
391: P_Line_Attr_Ext_Tbl IN Line_Attribs_Ext_Tbl_Type := G_MISS_Line_Attribs_Ext_TBL,
392: P_line_rltship_tbl IN Line_Rltship_Tbl_Type := G_MISS_Line_Rltship_Tbl,

Line 945: l_qte_header_rec ASO_QUOTE_PUB.qte_Header_Rec_Type;

941: l_api_name CONSTANT VARCHAR2(30) := 'SUBMIT_QUOTE';
942: l_api_version_number CONSTANT NUMBER := 1.0;
943: l_control_rec Submit_Control_Rec_Type := P_control_rec;
944: l_Qte_Header_Id NUMBER;
945: l_qte_header_rec ASO_QUOTE_PUB.qte_Header_Rec_Type;
946: BEGIN
947: -- Standard Start of API savepoint
948: SAVEPOINT SUBMIT_QUOTE_PUB;
949:

Line 1159: l_control_rec ASO_QUOTE_PUB.control_rec_type := G_MISS_Control_Rec ;

1155: l_New_Version VARCHAR2(30);
1156: l_Qte_Status_Id NUMBER;
1157: l_Qte_Number NUMBER;
1158: l_NEW_Qte_Header_Id NUMBER;
1159: l_control_rec ASO_QUOTE_PUB.control_rec_type := G_MISS_Control_Rec ;
1160: BEGIN
1161: -- Standard Start of API savepoint
1162: SAVEPOINT COPY_QUOTE_PUB;
1163:

Line 1747: P_hd_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type := G_Miss_Price_Attributes_Tbl,

1743: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1744: P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1745: P_Control_Rec IN Control_Rec_Type := G_Miss_Control_Rec,
1746: P_Qte_Header_Rec IN Qte_Header_Rec_Type := G_MISS_Qte_Header_Rec,
1747: P_hd_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type := G_Miss_Price_Attributes_Tbl,
1748: P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type := G_MISS_PAYMENT_TBL,
1749: P_hd_Shipment_Rec IN ASO_QUOTE_PUB.Shipment_Rec_Type := G_MISS_SHIPMENT_REC,
1750: P_hd_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type := G_Miss_Freight_Charge_Tbl,
1751: P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type := G_Miss_Tax_Detail_Tbl,

Line 1748: P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type := G_MISS_PAYMENT_TBL,

1744: P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1745: P_Control_Rec IN Control_Rec_Type := G_Miss_Control_Rec,
1746: P_Qte_Header_Rec IN Qte_Header_Rec_Type := G_MISS_Qte_Header_Rec,
1747: P_hd_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type := G_Miss_Price_Attributes_Tbl,
1748: P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type := G_MISS_PAYMENT_TBL,
1749: P_hd_Shipment_Rec IN ASO_QUOTE_PUB.Shipment_Rec_Type := G_MISS_SHIPMENT_REC,
1750: P_hd_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type := G_Miss_Freight_Charge_Tbl,
1751: P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type := G_Miss_Tax_Detail_Tbl,
1752: P_hd_Attr_Ext_Tbl IN Line_Attribs_Ext_Tbl_Type := G_MISS_Line_Attribs_Ext_TBL,

Line 1749: P_hd_Shipment_Rec IN ASO_QUOTE_PUB.Shipment_Rec_Type := G_MISS_SHIPMENT_REC,

1745: P_Control_Rec IN Control_Rec_Type := G_Miss_Control_Rec,
1746: P_Qte_Header_Rec IN Qte_Header_Rec_Type := G_MISS_Qte_Header_Rec,
1747: P_hd_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type := G_Miss_Price_Attributes_Tbl,
1748: P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type := G_MISS_PAYMENT_TBL,
1749: P_hd_Shipment_Rec IN ASO_QUOTE_PUB.Shipment_Rec_Type := G_MISS_SHIPMENT_REC,
1750: P_hd_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type := G_Miss_Freight_Charge_Tbl,
1751: P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type := G_Miss_Tax_Detail_Tbl,
1752: P_hd_Attr_Ext_Tbl IN Line_Attribs_Ext_Tbl_Type := G_MISS_Line_Attribs_Ext_TBL,
1753: P_hd_Sales_Credit_Tbl IN Sales_Credit_Tbl_Type := G_MISS_Sales_Credit_Tbl,

Line 1750: P_hd_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type := G_Miss_Freight_Charge_Tbl,

1746: P_Qte_Header_Rec IN Qte_Header_Rec_Type := G_MISS_Qte_Header_Rec,
1747: P_hd_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type := G_Miss_Price_Attributes_Tbl,
1748: P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type := G_MISS_PAYMENT_TBL,
1749: P_hd_Shipment_Rec IN ASO_QUOTE_PUB.Shipment_Rec_Type := G_MISS_SHIPMENT_REC,
1750: P_hd_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type := G_Miss_Freight_Charge_Tbl,
1751: P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type := G_Miss_Tax_Detail_Tbl,
1752: P_hd_Attr_Ext_Tbl IN Line_Attribs_Ext_Tbl_Type := G_MISS_Line_Attribs_Ext_TBL,
1753: P_hd_Sales_Credit_Tbl IN Sales_Credit_Tbl_Type := G_MISS_Sales_Credit_Tbl,
1754: P_hd_Quote_Party_Tbl IN Quote_Party_Tbl_Type := G_MISS_Quote_Party_Tbl,

Line 1751: P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type := G_Miss_Tax_Detail_Tbl,

1747: P_hd_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type := G_Miss_Price_Attributes_Tbl,
1748: P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type := G_MISS_PAYMENT_TBL,
1749: P_hd_Shipment_Rec IN ASO_QUOTE_PUB.Shipment_Rec_Type := G_MISS_SHIPMENT_REC,
1750: P_hd_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type := G_Miss_Freight_Charge_Tbl,
1751: P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type := G_Miss_Tax_Detail_Tbl,
1752: P_hd_Attr_Ext_Tbl IN Line_Attribs_Ext_Tbl_Type := G_MISS_Line_Attribs_Ext_TBL,
1753: P_hd_Sales_Credit_Tbl IN Sales_Credit_Tbl_Type := G_MISS_Sales_Credit_Tbl,
1754: P_hd_Quote_Party_Tbl IN Quote_Party_Tbl_Type := G_MISS_Quote_Party_Tbl,
1755: P_Qte_Line_Tbl IN Qte_Line_Tbl_Type := G_MISS_QTE_LINE_TBL,

Line 1886: P_hd_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type := G_Miss_Price_Attributes_Tbl,

1882: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1883: P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1884: P_Control_Rec IN Control_Rec_Type := G_Miss_Control_Rec,
1885: P_Qte_Header_Rec IN Qte_Header_Rec_Type := G_MISS_Qte_Header_Rec,
1886: P_hd_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type := G_Miss_Price_Attributes_Tbl,
1887: P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type := G_MISS_PAYMENT_TBL,
1888: P_hd_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type := G_MISS_SHIPMENT_TBL,
1889: P_hd_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type := G_Miss_Freight_Charge_Tbl,
1890: P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type := G_Miss_Tax_Detail_Tbl,

Line 1887: P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type := G_MISS_PAYMENT_TBL,

1883: P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1884: P_Control_Rec IN Control_Rec_Type := G_Miss_Control_Rec,
1885: P_Qte_Header_Rec IN Qte_Header_Rec_Type := G_MISS_Qte_Header_Rec,
1886: P_hd_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type := G_Miss_Price_Attributes_Tbl,
1887: P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type := G_MISS_PAYMENT_TBL,
1888: P_hd_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type := G_MISS_SHIPMENT_TBL,
1889: P_hd_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type := G_Miss_Freight_Charge_Tbl,
1890: P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type := G_Miss_Tax_Detail_Tbl,
1891: P_hd_Attr_Ext_Tbl IN Line_Attribs_Ext_Tbl_Type := G_MISS_Line_Attribs_Ext_TBL,

Line 1888: P_hd_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type := G_MISS_SHIPMENT_TBL,

1884: P_Control_Rec IN Control_Rec_Type := G_Miss_Control_Rec,
1885: P_Qte_Header_Rec IN Qte_Header_Rec_Type := G_MISS_Qte_Header_Rec,
1886: P_hd_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type := G_Miss_Price_Attributes_Tbl,
1887: P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type := G_MISS_PAYMENT_TBL,
1888: P_hd_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type := G_MISS_SHIPMENT_TBL,
1889: P_hd_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type := G_Miss_Freight_Charge_Tbl,
1890: P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type := G_Miss_Tax_Detail_Tbl,
1891: P_hd_Attr_Ext_Tbl IN Line_Attribs_Ext_Tbl_Type := G_MISS_Line_Attribs_Ext_TBL,
1892: P_hd_Sales_Credit_Tbl IN Sales_Credit_Tbl_Type := G_MISS_Sales_Credit_Tbl,

Line 1889: P_hd_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type := G_Miss_Freight_Charge_Tbl,

1885: P_Qte_Header_Rec IN Qte_Header_Rec_Type := G_MISS_Qte_Header_Rec,
1886: P_hd_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type := G_Miss_Price_Attributes_Tbl,
1887: P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type := G_MISS_PAYMENT_TBL,
1888: P_hd_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type := G_MISS_SHIPMENT_TBL,
1889: P_hd_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type := G_Miss_Freight_Charge_Tbl,
1890: P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type := G_Miss_Tax_Detail_Tbl,
1891: P_hd_Attr_Ext_Tbl IN Line_Attribs_Ext_Tbl_Type := G_MISS_Line_Attribs_Ext_TBL,
1892: P_hd_Sales_Credit_Tbl IN Sales_Credit_Tbl_Type := G_MISS_Sales_Credit_Tbl,
1893: P_hd_Quote_Party_Tbl IN Quote_Party_Tbl_Type := G_MISS_Quote_Party_Tbl,

Line 1890: P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type := G_Miss_Tax_Detail_Tbl,

1886: P_hd_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type := G_Miss_Price_Attributes_Tbl,
1887: P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type := G_MISS_PAYMENT_TBL,
1888: P_hd_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type := G_MISS_SHIPMENT_TBL,
1889: P_hd_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type := G_Miss_Freight_Charge_Tbl,
1890: P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type := G_Miss_Tax_Detail_Tbl,
1891: P_hd_Attr_Ext_Tbl IN Line_Attribs_Ext_Tbl_Type := G_MISS_Line_Attribs_Ext_TBL,
1892: P_hd_Sales_Credit_Tbl IN Sales_Credit_Tbl_Type := G_MISS_Sales_Credit_Tbl,
1893: P_hd_Quote_Party_Tbl IN Quote_Party_Tbl_Type := G_MISS_Quote_Party_Tbl,
1894: P_Qte_Line_Tbl IN Qte_Line_Tbl_Type := G_MISS_QTE_LINE_TBL,

Line 3181: aso_debug_pub.add('ASO_QUOTE_PUB: Quote_Security_Check(): End: Resource_Id: '||X_Resource_Id, 1, 'Y');

3177: X_Msg_Data => X_Msg_Data
3178: );
3179:
3180: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3181: aso_debug_pub.add('ASO_QUOTE_PUB: Quote_Security_Check(): End: Resource_Id: '||X_Resource_Id, 1, 'Y');
3182: aso_debug_pub.add('ASO_QUOTE_PUB: Quote_Security_Check(): End: Security_Flag: '||X_Security_Flag, 1, 'Y');
3183: END IF;
3184:
3185: End Quote_Security_Check;

Line 3182: aso_debug_pub.add('ASO_QUOTE_PUB: Quote_Security_Check(): End: Security_Flag: '||X_Security_Flag, 1, 'Y');

3178: );
3179:
3180: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3181: aso_debug_pub.add('ASO_QUOTE_PUB: Quote_Security_Check(): End: Resource_Id: '||X_Resource_Id, 1, 'Y');
3182: aso_debug_pub.add('ASO_QUOTE_PUB: Quote_Security_Check(): End: Security_Flag: '||X_Security_Flag, 1, 'Y');
3183: END IF;
3184:
3185: End Quote_Security_Check;
3186:

Line 3203: p_control_rec IN ASO_QUOTE_PUB.Submit_Control_Rec_Type

3199: PROCEDURE Submit_quote(
3200: P_Api_Version_Number IN NUMBER,
3201: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3202: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
3203: p_control_rec IN ASO_QUOTE_PUB.Submit_Control_Rec_Type
3204: := ASO_QUOTE_PUB.G_MISS_Submit_Control_Rec,
3205: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
3206: x_order_header_rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Order_Header_Rec_Type,
3207: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 3204: := ASO_QUOTE_PUB.G_MISS_Submit_Control_Rec,

3200: P_Api_Version_Number IN NUMBER,
3201: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3202: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
3203: p_control_rec IN ASO_QUOTE_PUB.Submit_Control_Rec_Type
3204: := ASO_QUOTE_PUB.G_MISS_Submit_Control_Rec,
3205: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
3206: x_order_header_rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Order_Header_Rec_Type,
3207: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
3208: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 3205: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,

3201: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3202: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
3203: p_control_rec IN ASO_QUOTE_PUB.Submit_Control_Rec_Type
3204: := ASO_QUOTE_PUB.G_MISS_Submit_Control_Rec,
3205: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
3206: x_order_header_rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Order_Header_Rec_Type,
3207: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
3208: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
3209: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 3206: x_order_header_rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Order_Header_Rec_Type,

3202: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
3203: p_control_rec IN ASO_QUOTE_PUB.Submit_Control_Rec_Type
3204: := ASO_QUOTE_PUB.G_MISS_Submit_Control_Rec,
3205: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
3206: x_order_header_rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Order_Header_Rec_Type,
3207: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
3208: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
3209: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
3210: )

Line 3416: p_control_rec IN ASO_QUOTE_PUB.SALES_ALLOC_CONTROL_REC_TYPE

3412: (
3413: P_Api_Version_Number IN NUMBER,
3414: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3415: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
3416: p_control_rec IN ASO_QUOTE_PUB.SALES_ALLOC_CONTROL_REC_TYPE
3417: := ASO_QUOTE_PUB.G_MISS_SALES_ALLOC_CONTROL_REC,
3418: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
3419: X_Qte_Header_Rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,
3420: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 3417: := ASO_QUOTE_PUB.G_MISS_SALES_ALLOC_CONTROL_REC,

3413: P_Api_Version_Number IN NUMBER,
3414: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3415: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
3416: p_control_rec IN ASO_QUOTE_PUB.SALES_ALLOC_CONTROL_REC_TYPE
3417: := ASO_QUOTE_PUB.G_MISS_SALES_ALLOC_CONTROL_REC,
3418: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
3419: X_Qte_Header_Rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,
3420: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
3421: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 3418: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,

3414: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3415: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
3416: p_control_rec IN ASO_QUOTE_PUB.SALES_ALLOC_CONTROL_REC_TYPE
3417: := ASO_QUOTE_PUB.G_MISS_SALES_ALLOC_CONTROL_REC,
3418: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
3419: X_Qte_Header_Rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,
3420: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
3421: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
3422: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)

Line 3419: X_Qte_Header_Rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,

3415: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
3416: p_control_rec IN ASO_QUOTE_PUB.SALES_ALLOC_CONTROL_REC_TYPE
3417: := ASO_QUOTE_PUB.G_MISS_SALES_ALLOC_CONTROL_REC,
3418: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
3419: X_Qte_Header_Rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,
3420: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
3421: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
3422: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
3423: IS

Line 3780: P_hd_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type := G_Miss_Price_Attributes_Tbl,

3776: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
3777: P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3778: P_Control_Rec IN Control_Rec_Type := G_Miss_Control_Rec,
3779: P_Qte_Header_Rec IN Qte_Header_Rec_Type := G_MISS_Qte_Header_Rec,
3780: P_hd_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type := G_Miss_Price_Attributes_Tbl,
3781: P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type := G_MISS_PAYMENT_TBL,
3782: P_hd_Shipment_Rec IN ASO_QUOTE_PUB.Shipment_Rec_Type := G_MISS_SHIPMENT_REC,
3783: P_hd_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type := G_Miss_Freight_Charge_Tbl,
3784: P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type := G_Miss_Tax_Detail_Tbl,

Line 3781: P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type := G_MISS_PAYMENT_TBL,

3777: P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3778: P_Control_Rec IN Control_Rec_Type := G_Miss_Control_Rec,
3779: P_Qte_Header_Rec IN Qte_Header_Rec_Type := G_MISS_Qte_Header_Rec,
3780: P_hd_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type := G_Miss_Price_Attributes_Tbl,
3781: P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type := G_MISS_PAYMENT_TBL,
3782: P_hd_Shipment_Rec IN ASO_QUOTE_PUB.Shipment_Rec_Type := G_MISS_SHIPMENT_REC,
3783: P_hd_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type := G_Miss_Freight_Charge_Tbl,
3784: P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type := G_Miss_Tax_Detail_Tbl,
3785: P_hd_Attr_Ext_Tbl IN Line_Attribs_Ext_Tbl_Type := G_MISS_Line_Attribs_Ext_TBL,

Line 3782: P_hd_Shipment_Rec IN ASO_QUOTE_PUB.Shipment_Rec_Type := G_MISS_SHIPMENT_REC,

3778: P_Control_Rec IN Control_Rec_Type := G_Miss_Control_Rec,
3779: P_Qte_Header_Rec IN Qte_Header_Rec_Type := G_MISS_Qte_Header_Rec,
3780: P_hd_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type := G_Miss_Price_Attributes_Tbl,
3781: P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type := G_MISS_PAYMENT_TBL,
3782: P_hd_Shipment_Rec IN ASO_QUOTE_PUB.Shipment_Rec_Type := G_MISS_SHIPMENT_REC,
3783: P_hd_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type := G_Miss_Freight_Charge_Tbl,
3784: P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type := G_Miss_Tax_Detail_Tbl,
3785: P_hd_Attr_Ext_Tbl IN Line_Attribs_Ext_Tbl_Type := G_MISS_Line_Attribs_Ext_TBL,
3786: P_hd_Sales_Credit_Tbl IN Sales_Credit_Tbl_Type := G_MISS_Sales_Credit_Tbl,

Line 3783: P_hd_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type := G_Miss_Freight_Charge_Tbl,

3779: P_Qte_Header_Rec IN Qte_Header_Rec_Type := G_MISS_Qte_Header_Rec,
3780: P_hd_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type := G_Miss_Price_Attributes_Tbl,
3781: P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type := G_MISS_PAYMENT_TBL,
3782: P_hd_Shipment_Rec IN ASO_QUOTE_PUB.Shipment_Rec_Type := G_MISS_SHIPMENT_REC,
3783: P_hd_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type := G_Miss_Freight_Charge_Tbl,
3784: P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type := G_Miss_Tax_Detail_Tbl,
3785: P_hd_Attr_Ext_Tbl IN Line_Attribs_Ext_Tbl_Type := G_MISS_Line_Attribs_Ext_TBL,
3786: P_hd_Sales_Credit_Tbl IN Sales_Credit_Tbl_Type := G_MISS_Sales_Credit_Tbl,
3787: P_hd_Quote_Party_Tbl IN Quote_Party_Tbl_Type := G_MISS_Quote_Party_Tbl,

Line 3784: P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type := G_Miss_Tax_Detail_Tbl,

3780: P_hd_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type := G_Miss_Price_Attributes_Tbl,
3781: P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type := G_MISS_PAYMENT_TBL,
3782: P_hd_Shipment_Rec IN ASO_QUOTE_PUB.Shipment_Rec_Type := G_MISS_SHIPMENT_REC,
3783: P_hd_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type := G_Miss_Freight_Charge_Tbl,
3784: P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type := G_Miss_Tax_Detail_Tbl,
3785: P_hd_Attr_Ext_Tbl IN Line_Attribs_Ext_Tbl_Type := G_MISS_Line_Attribs_Ext_TBL,
3786: P_hd_Sales_Credit_Tbl IN Sales_Credit_Tbl_Type := G_MISS_Sales_Credit_Tbl,
3787: P_hd_Quote_Party_Tbl IN Quote_Party_Tbl_Type := G_MISS_Quote_Party_Tbl,
3788: P_Qte_Line_Tbl IN Qte_Line_Tbl_Type := G_MISS_QTE_LINE_TBL,

Line 4354: P_hd_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type := G_Miss_Price_Attributes_Tbl,

4350: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
4351: P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
4352: P_Control_Rec IN Control_Rec_Type := G_Miss_Control_Rec,
4353: P_Qte_Header_Rec IN Qte_Header_Rec_Type := G_MISS_Qte_Header_Rec,
4354: P_hd_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type := G_Miss_Price_Attributes_Tbl,
4355: P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type := G_MISS_PAYMENT_TBL,
4356: P_hd_Shipment_Rec IN ASO_QUOTE_PUB.Shipment_Rec_Type := G_MISS_SHIPMENT_REC,
4357: P_hd_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type := G_Miss_Freight_Charge_Tbl,
4358: P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type := G_Miss_Tax_Detail_Tbl,

Line 4355: P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type := G_MISS_PAYMENT_TBL,

4351: P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
4352: P_Control_Rec IN Control_Rec_Type := G_Miss_Control_Rec,
4353: P_Qte_Header_Rec IN Qte_Header_Rec_Type := G_MISS_Qte_Header_Rec,
4354: P_hd_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type := G_Miss_Price_Attributes_Tbl,
4355: P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type := G_MISS_PAYMENT_TBL,
4356: P_hd_Shipment_Rec IN ASO_QUOTE_PUB.Shipment_Rec_Type := G_MISS_SHIPMENT_REC,
4357: P_hd_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type := G_Miss_Freight_Charge_Tbl,
4358: P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type := G_Miss_Tax_Detail_Tbl,
4359: P_hd_Attr_Ext_Tbl IN Line_Attribs_Ext_Tbl_Type := G_MISS_Line_Attribs_Ext_TBL,

Line 4356: P_hd_Shipment_Rec IN ASO_QUOTE_PUB.Shipment_Rec_Type := G_MISS_SHIPMENT_REC,

4352: P_Control_Rec IN Control_Rec_Type := G_Miss_Control_Rec,
4353: P_Qte_Header_Rec IN Qte_Header_Rec_Type := G_MISS_Qte_Header_Rec,
4354: P_hd_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type := G_Miss_Price_Attributes_Tbl,
4355: P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type := G_MISS_PAYMENT_TBL,
4356: P_hd_Shipment_Rec IN ASO_QUOTE_PUB.Shipment_Rec_Type := G_MISS_SHIPMENT_REC,
4357: P_hd_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type := G_Miss_Freight_Charge_Tbl,
4358: P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type := G_Miss_Tax_Detail_Tbl,
4359: P_hd_Attr_Ext_Tbl IN Line_Attribs_Ext_Tbl_Type := G_MISS_Line_Attribs_Ext_TBL,
4360: P_hd_Sales_Credit_Tbl IN Sales_Credit_Tbl_Type := G_MISS_Sales_Credit_Tbl,

Line 4357: P_hd_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type := G_Miss_Freight_Charge_Tbl,

4353: P_Qte_Header_Rec IN Qte_Header_Rec_Type := G_MISS_Qte_Header_Rec,
4354: P_hd_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type := G_Miss_Price_Attributes_Tbl,
4355: P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type := G_MISS_PAYMENT_TBL,
4356: P_hd_Shipment_Rec IN ASO_QUOTE_PUB.Shipment_Rec_Type := G_MISS_SHIPMENT_REC,
4357: P_hd_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type := G_Miss_Freight_Charge_Tbl,
4358: P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type := G_Miss_Tax_Detail_Tbl,
4359: P_hd_Attr_Ext_Tbl IN Line_Attribs_Ext_Tbl_Type := G_MISS_Line_Attribs_Ext_TBL,
4360: P_hd_Sales_Credit_Tbl IN Sales_Credit_Tbl_Type := G_MISS_Sales_Credit_Tbl,
4361: P_hd_Quote_Party_Tbl IN Quote_Party_Tbl_Type := G_MISS_Quote_Party_Tbl,

Line 4358: P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type := G_Miss_Tax_Detail_Tbl,

4354: P_hd_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type := G_Miss_Price_Attributes_Tbl,
4355: P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type := G_MISS_PAYMENT_TBL,
4356: P_hd_Shipment_Rec IN ASO_QUOTE_PUB.Shipment_Rec_Type := G_MISS_SHIPMENT_REC,
4357: P_hd_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type := G_Miss_Freight_Charge_Tbl,
4358: P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type := G_Miss_Tax_Detail_Tbl,
4359: P_hd_Attr_Ext_Tbl IN Line_Attribs_Ext_Tbl_Type := G_MISS_Line_Attribs_Ext_TBL,
4360: P_hd_Sales_Credit_Tbl IN Sales_Credit_Tbl_Type := G_MISS_Sales_Credit_Tbl,
4361: P_hd_Quote_Party_Tbl IN Quote_Party_Tbl_Type := G_MISS_Quote_Party_Tbl,
4362: P_Qte_Line_Tbl IN Qte_Line_Tbl_Type := G_MISS_QTE_LINE_TBL,

Line 4882: aso_debug_pub.add('ASO_QUOTE_PUB.Create_Quote_Service: Start to prepare control record');

4878: -- call create_quote api
4879:
4880: -- Prepare Control Record
4881: IF aso_debug_pub.g_debug_flag = 'Y' THEN
4882: aso_debug_pub.add('ASO_QUOTE_PUB.Create_Quote_Service: Start to prepare control record');
4883: aso_debug_pub.add('Profile Value ASO_CALCULATE_PRICE is ' ||fnd_profile.value('ASO_CALCULATE_PRICE'), 1, 'N');
4884: aso_debug_pub.add('Profile Value ASO_CALCULATE_TAX is ' ||fnd_profile.value('ASO_CALCULATE_TAX'), 1, 'N');
4885: END IF;
4886:

Line 4970: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_PUB.Create_Quote', FALSE);

4966: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4967:
4968: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4969: FND_MESSAGE.Set_Name('ASO', 'ERROR_RETURNED');
4970: FND_MESSAGE.Set_Token('API', 'ASO_QUOTE_PUB.Create_Quote', FALSE);
4971: FND_MSG_PUB.ADD;
4972: END IF;
4973:
4974: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

Line 5054: P_hd_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type := G_Miss_Price_Attributes_Tbl,

5050: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
5051: P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
5052: P_Control_Rec IN Control_Rec_Type := G_Miss_Control_Rec,
5053: P_Qte_Header_Rec IN Qte_Header_Rec_Type := G_MISS_Qte_Header_Rec,
5054: P_hd_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type := G_Miss_Price_Attributes_Tbl,
5055: P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type := G_MISS_PAYMENT_TBL,
5056: P_hd_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type := G_MISS_SHIPMENT_TBL,
5057: P_hd_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type := G_Miss_Freight_Charge_Tbl,
5058: P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type := G_Miss_Tax_Detail_Tbl,

Line 5055: P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type := G_MISS_PAYMENT_TBL,

5051: P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
5052: P_Control_Rec IN Control_Rec_Type := G_Miss_Control_Rec,
5053: P_Qte_Header_Rec IN Qte_Header_Rec_Type := G_MISS_Qte_Header_Rec,
5054: P_hd_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type := G_Miss_Price_Attributes_Tbl,
5055: P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type := G_MISS_PAYMENT_TBL,
5056: P_hd_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type := G_MISS_SHIPMENT_TBL,
5057: P_hd_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type := G_Miss_Freight_Charge_Tbl,
5058: P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type := G_Miss_Tax_Detail_Tbl,
5059: P_hd_Attr_Ext_Tbl IN Line_Attribs_Ext_Tbl_Type := G_MISS_Line_Attribs_Ext_TBL,

Line 5056: P_hd_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type := G_MISS_SHIPMENT_TBL,

5052: P_Control_Rec IN Control_Rec_Type := G_Miss_Control_Rec,
5053: P_Qte_Header_Rec IN Qte_Header_Rec_Type := G_MISS_Qte_Header_Rec,
5054: P_hd_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type := G_Miss_Price_Attributes_Tbl,
5055: P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type := G_MISS_PAYMENT_TBL,
5056: P_hd_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type := G_MISS_SHIPMENT_TBL,
5057: P_hd_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type := G_Miss_Freight_Charge_Tbl,
5058: P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type := G_Miss_Tax_Detail_Tbl,
5059: P_hd_Attr_Ext_Tbl IN Line_Attribs_Ext_Tbl_Type := G_MISS_Line_Attribs_Ext_TBL,
5060: P_hd_Sales_Credit_Tbl IN Sales_Credit_Tbl_Type := G_MISS_Sales_Credit_Tbl,

Line 5057: P_hd_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type := G_Miss_Freight_Charge_Tbl,

5053: P_Qte_Header_Rec IN Qte_Header_Rec_Type := G_MISS_Qte_Header_Rec,
5054: P_hd_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type := G_Miss_Price_Attributes_Tbl,
5055: P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type := G_MISS_PAYMENT_TBL,
5056: P_hd_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type := G_MISS_SHIPMENT_TBL,
5057: P_hd_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type := G_Miss_Freight_Charge_Tbl,
5058: P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type := G_Miss_Tax_Detail_Tbl,
5059: P_hd_Attr_Ext_Tbl IN Line_Attribs_Ext_Tbl_Type := G_MISS_Line_Attribs_Ext_TBL,
5060: P_hd_Sales_Credit_Tbl IN Sales_Credit_Tbl_Type := G_MISS_Sales_Credit_Tbl,
5061: P_hd_Quote_Party_Tbl IN Quote_Party_Tbl_Type := G_MISS_Quote_Party_Tbl,

Line 5058: P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type := G_Miss_Tax_Detail_Tbl,

5054: P_hd_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type := G_Miss_Price_Attributes_Tbl,
5055: P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type := G_MISS_PAYMENT_TBL,
5056: P_hd_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type := G_MISS_SHIPMENT_TBL,
5057: P_hd_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type := G_Miss_Freight_Charge_Tbl,
5058: P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type := G_Miss_Tax_Detail_Tbl,
5059: P_hd_Attr_Ext_Tbl IN Line_Attribs_Ext_Tbl_Type := G_MISS_Line_Attribs_Ext_TBL,
5060: P_hd_Sales_Credit_Tbl IN Sales_Credit_Tbl_Type := G_MISS_Sales_Credit_Tbl,
5061: P_hd_Quote_Party_Tbl IN Quote_Party_Tbl_Type := G_MISS_Quote_Party_Tbl,
5062: P_Qte_Line_Tbl IN Qte_Line_Tbl_Type := G_MISS_QTE_LINE_TBL,

Line 5632: l_qte_line_rec aso_quote_pub.qte_line_rec_type;

5628: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
5629: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
5630: )
5631: as
5632: l_qte_line_rec aso_quote_pub.qte_line_rec_type;
5633: l_qte_line_tbl aso_quote_pub.qte_line_tbl_type;
5634: l_qte_line_dtl_tbl aso_quote_pub.qte_line_dtl_tbl_type;
5635: l_model_qte_line_tbl aso_quote_pub.qte_line_tbl_type;
5636: l_model_qte_line_dtl_tbl aso_quote_pub.qte_line_dtl_tbl_type;

Line 5633: l_qte_line_tbl aso_quote_pub.qte_line_tbl_type;

5629: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
5630: )
5631: as
5632: l_qte_line_rec aso_quote_pub.qte_line_rec_type;
5633: l_qte_line_tbl aso_quote_pub.qte_line_tbl_type;
5634: l_qte_line_dtl_tbl aso_quote_pub.qte_line_dtl_tbl_type;
5635: l_model_qte_line_tbl aso_quote_pub.qte_line_tbl_type;
5636: l_model_qte_line_dtl_tbl aso_quote_pub.qte_line_dtl_tbl_type;
5637: l_model_index number:=0;

Line 5634: l_qte_line_dtl_tbl aso_quote_pub.qte_line_dtl_tbl_type;

5630: )
5631: as
5632: l_qte_line_rec aso_quote_pub.qte_line_rec_type;
5633: l_qte_line_tbl aso_quote_pub.qte_line_tbl_type;
5634: l_qte_line_dtl_tbl aso_quote_pub.qte_line_dtl_tbl_type;
5635: l_model_qte_line_tbl aso_quote_pub.qte_line_tbl_type;
5636: l_model_qte_line_dtl_tbl aso_quote_pub.qte_line_dtl_tbl_type;
5637: l_model_index number:=0;
5638:

Line 5635: l_model_qte_line_tbl aso_quote_pub.qte_line_tbl_type;

5631: as
5632: l_qte_line_rec aso_quote_pub.qte_line_rec_type;
5633: l_qte_line_tbl aso_quote_pub.qte_line_tbl_type;
5634: l_qte_line_dtl_tbl aso_quote_pub.qte_line_dtl_tbl_type;
5635: l_model_qte_line_tbl aso_quote_pub.qte_line_tbl_type;
5636: l_model_qte_line_dtl_tbl aso_quote_pub.qte_line_dtl_tbl_type;
5637: l_model_index number:=0;
5638:
5639: l_config_index number:=0;

Line 5636: l_model_qte_line_dtl_tbl aso_quote_pub.qte_line_dtl_tbl_type;

5632: l_qte_line_rec aso_quote_pub.qte_line_rec_type;
5633: l_qte_line_tbl aso_quote_pub.qte_line_tbl_type;
5634: l_qte_line_dtl_tbl aso_quote_pub.qte_line_dtl_tbl_type;
5635: l_model_qte_line_tbl aso_quote_pub.qte_line_tbl_type;
5636: l_model_qte_line_dtl_tbl aso_quote_pub.qte_line_dtl_tbl_type;
5637: l_model_index number:=0;
5638:
5639: l_config_index number:=0;
5640: l_control_rec_bv ASO_QUOTE_PUB.Control_Rec_Type;

Line 5640: l_control_rec_bv ASO_QUOTE_PUB.Control_Rec_Type;

5636: l_model_qte_line_dtl_tbl aso_quote_pub.qte_line_dtl_tbl_type;
5637: l_model_index number:=0;
5638:
5639: l_config_index number:=0;
5640: l_control_rec_bv ASO_QUOTE_PUB.Control_Rec_Type;
5641:
5642: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
5643: l_api_name VARCHAR2(30) := 'VALIDATE_MODEL_CONFIGURATION'; -- removed CONSTANT as part of fix for Bug 12679929
5644: l_api_version_number CONSTANT NUMBER := 1.0;

Line 5653: G_PKG_NAME CONSTANT VARCHAR2(30):= 'ASO_QUOTE_PUB';

5649: l_config_revision_num number;
5650: l_new_config_hdr_id number;
5651:
5652:
5653: G_PKG_NAME CONSTANT VARCHAR2(30):= 'ASO_QUOTE_PUB';
5654:
5655: CURSOR c_config_exist_in_cz (p_config_hdr_id number, p_config_rev_nbr number) IS
5656: select config_hdr_id
5657: from cz_config_details_v

Line 5684: aso_debug_pub.add('ASO_QUOTE_PUB: Validate_Model_Configuration Begins', 1, 'Y');

5680: x_return_status := FND_API.G_RET_STS_SUCCESS;
5681:
5682:
5683: IF aso_debug_pub.g_debug_flag = 'Y' THEN
5684: aso_debug_pub.add('ASO_QUOTE_PUB: Validate_Model_Configuration Begins', 1, 'Y');
5685: aso_debug_pub.add('ASO_QUOTE_PUB: Validate_Model_Configuration Begins'||p_init_msg_list,1,'Y');
5686: END IF;
5687:
5688: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 5685: aso_debug_pub.add('ASO_QUOTE_PUB: Validate_Model_Configuration Begins'||p_init_msg_list,1,'Y');

5681:
5682:
5683: IF aso_debug_pub.g_debug_flag = 'Y' THEN
5684: aso_debug_pub.add('ASO_QUOTE_PUB: Validate_Model_Configuration Begins', 1, 'Y');
5685: aso_debug_pub.add('ASO_QUOTE_PUB: Validate_Model_Configuration Begins'||p_init_msg_list,1,'Y');
5686: END IF;
5687:
5688: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
5689: p_api_version_number,

Line 5698: aso_debug_pub.add('ASO_QUOTE_PUB: p_init_msg_list true', 1, 'Y');

5694:
5695: l_api_name := 'VALIDATE_MODEL_CFG'; -- Added for Bug 12679929
5696:
5697: IF FND_API.to_Boolean( p_init_msg_list ) THEN
5698: aso_debug_pub.add('ASO_QUOTE_PUB: p_init_msg_list true', 1, 'Y');
5699: FND_MSG_PUB.initialize;
5700: END IF;
5701:
5702: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 5773: l_send_qte_line_tbl := ASO_QUOTE_PUB.G_MISS_QTE_LINE_TBL;

5769: /*
5770: -- Sending modfied model line id and its details
5771: -- Discussed with CZ we need not send the line and details tables
5772:
5773: l_send_qte_line_tbl := ASO_QUOTE_PUB.G_MISS_QTE_LINE_TBL;
5774: l_send_qte_line_dtl_tbl := ASO_QUOTE_PUB.G_MISS_QTE_LINE_DTL_TBL;
5775: l_send_qte_line_tbl(1):=ASO_UTILITY_PVT.Query_Qte_Line_Row(l_model_qte_line_tbl(i).quote_line_id);
5776: l_send_qte_line_tbl(1).operation_code:='UPDATE';
5777: l_send_qte_line_dtl_tbl := ASO_UTILITY_PVT.Query_Line_Dtl_Rows(l_model_qte_line_tbl(i).quote_line_id);

Line 5774: l_send_qte_line_dtl_tbl := ASO_QUOTE_PUB.G_MISS_QTE_LINE_DTL_TBL;

5770: -- Sending modfied model line id and its details
5771: -- Discussed with CZ we need not send the line and details tables
5772:
5773: l_send_qte_line_tbl := ASO_QUOTE_PUB.G_MISS_QTE_LINE_TBL;
5774: l_send_qte_line_dtl_tbl := ASO_QUOTE_PUB.G_MISS_QTE_LINE_DTL_TBL;
5775: l_send_qte_line_tbl(1):=ASO_UTILITY_PVT.Query_Qte_Line_Row(l_model_qte_line_tbl(i).quote_line_id);
5776: l_send_qte_line_tbl(1).operation_code:='UPDATE';
5777: l_send_qte_line_dtl_tbl := ASO_UTILITY_PVT.Query_Line_Dtl_Rows(l_model_qte_line_tbl(i).quote_line_id);
5778: */

Line 5786: aso_debug_pub.add('ASO_QUOTE_PUB : Before call to ASO_BATCH_VALIDATE_CFG_PVT.Validate_Configuration'|| l_model_qte_line_tbl(i).quote_line_id,1,'N');

5782:
5783:
5784: -- Call Batch Validation procedure
5785: IF aso_debug_pub.g_debug_flag = 'Y' THEN
5786: aso_debug_pub.add('ASO_QUOTE_PUB : Before call to ASO_BATCH_VALIDATE_CFG_PVT.Validate_Configuration'|| l_model_qte_line_tbl(i).quote_line_id,1,'N');
5787: END IF;
5788:
5789: /*FND_MSG_PUB.Count_And_Get
5790: ( p_encoded => 'F',

Line 5797: aso_debug_pub.add('ASO_QUOTE_PUB: Validate_Model_Configuration Begins', 1, 'Y');

5793: );
5794: x_msg_data := fnd_msg_pub.get( p_msg_index => 1, p_encoded => 'F');
5795: */
5796: IF aso_debug_pub.g_debug_flag = 'Y' THEN
5797: aso_debug_pub.add('ASO_QUOTE_PUB: Validate_Model_Configuration Begins', 1, 'Y');
5798: -- aso_debug_pub.add('rassharm Update_Quote: ASO_VALIDATE_CFG_PVT.Validate_Configuration Begins'||x_msg_count, 1, 'Y');
5799: --aso_debug_pub.add('rassharm Update_Quote: ASO_VALIDATE_CFG_PVT.Validate_Configuration Begins'||x_msg_data, 1, 'Y');
5800: END IF;
5801:

Line 5811: P_Qte_Line_Tbl => ASO_QUOTE_PUB.G_MISS_QTE_LINE_TBL,

5807: P_Init_Msg_List => FND_API.G_FALSE,
5808: P_Commit => FND_API.G_FALSE,
5809: p_control_rec => l_control_rec_bv,
5810: P_model_line_id => l_model_qte_line_tbl(i).quote_line_id,
5811: P_Qte_Line_Tbl => ASO_QUOTE_PUB.G_MISS_QTE_LINE_TBL,
5812: P_Qte_Line_Dtl_Tbl => ASO_QUOTE_PUB.G_MISS_QTE_LINE_DTL_TBL,
5813: p_update_quote => p_update_quote,
5814: P_EFFECTIVE_DATE => P_Config_EFFECTIVE_DATE,
5815: P_model_lookup_DATE => P_Config_model_lookup_DATE,

Line 5812: P_Qte_Line_Dtl_Tbl => ASO_QUOTE_PUB.G_MISS_QTE_LINE_DTL_TBL,

5808: P_Commit => FND_API.G_FALSE,
5809: p_control_rec => l_control_rec_bv,
5810: P_model_line_id => l_model_qte_line_tbl(i).quote_line_id,
5811: P_Qte_Line_Tbl => ASO_QUOTE_PUB.G_MISS_QTE_LINE_TBL,
5812: P_Qte_Line_Dtl_Tbl => ASO_QUOTE_PUB.G_MISS_QTE_LINE_DTL_TBL,
5813: p_update_quote => p_update_quote,
5814: P_EFFECTIVE_DATE => P_Config_EFFECTIVE_DATE,
5815: P_model_lookup_DATE => P_Config_model_lookup_DATE,
5816: X_config_header_id => l_config_header_id,

Line 5838: aso_debug_pub.add('ASO_QUOTE_PUB: After call to Batch Validate_Configuration: l_return_status: '||l_return_status,1,'Y');

5834: l_return_status := FND_API.G_RET_STS_SUCCESS;
5835: end if;
5836:
5837: IF aso_debug_pub.g_debug_flag = 'Y' THEN
5838: aso_debug_pub.add('ASO_QUOTE_PUB: After call to Batch Validate_Configuration: l_return_status: '||l_return_status,1,'Y');
5839: aso_debug_pub.add('ASO_QUOTE_PUB: l_config_header_id: '|| l_config_header_id,1,'N');
5840: aso_debug_pub.add('ASO_QUOTE_PUB: l_config_revision_num: '|| l_config_revision_num,1,'N');
5841: aso_debug_pub.add('ASO_QUOTE_PUB: l_valid_configuration_flag: '|| l_valid_configuration_flag,1,'N');
5842: aso_debug_pub.add('ASO_QUOTE_PUB: l_complete_configuration_flag: '|| l_complete_configuration_flag,1,'N');

Line 5839: aso_debug_pub.add('ASO_QUOTE_PUB: l_config_header_id: '|| l_config_header_id,1,'N');

5835: end if;
5836:
5837: IF aso_debug_pub.g_debug_flag = 'Y' THEN
5838: aso_debug_pub.add('ASO_QUOTE_PUB: After call to Batch Validate_Configuration: l_return_status: '||l_return_status,1,'Y');
5839: aso_debug_pub.add('ASO_QUOTE_PUB: l_config_header_id: '|| l_config_header_id,1,'N');
5840: aso_debug_pub.add('ASO_QUOTE_PUB: l_config_revision_num: '|| l_config_revision_num,1,'N');
5841: aso_debug_pub.add('ASO_QUOTE_PUB: l_valid_configuration_flag: '|| l_valid_configuration_flag,1,'N');
5842: aso_debug_pub.add('ASO_QUOTE_PUB: l_complete_configuration_flag: '|| l_complete_configuration_flag,1,'N');
5843: aso_debug_pub.add('ASO_QUOTE_PUB: l_config_changed: '|| l_config_changed,1,'N');

Line 5840: aso_debug_pub.add('ASO_QUOTE_PUB: l_config_revision_num: '|| l_config_revision_num,1,'N');

5836:
5837: IF aso_debug_pub.g_debug_flag = 'Y' THEN
5838: aso_debug_pub.add('ASO_QUOTE_PUB: After call to Batch Validate_Configuration: l_return_status: '||l_return_status,1,'Y');
5839: aso_debug_pub.add('ASO_QUOTE_PUB: l_config_header_id: '|| l_config_header_id,1,'N');
5840: aso_debug_pub.add('ASO_QUOTE_PUB: l_config_revision_num: '|| l_config_revision_num,1,'N');
5841: aso_debug_pub.add('ASO_QUOTE_PUB: l_valid_configuration_flag: '|| l_valid_configuration_flag,1,'N');
5842: aso_debug_pub.add('ASO_QUOTE_PUB: l_complete_configuration_flag: '|| l_complete_configuration_flag,1,'N');
5843: aso_debug_pub.add('ASO_QUOTE_PUB: l_config_changed: '|| l_config_changed,1,'N');
5844: END IF;

Line 5841: aso_debug_pub.add('ASO_QUOTE_PUB: l_valid_configuration_flag: '|| l_valid_configuration_flag,1,'N');

5837: IF aso_debug_pub.g_debug_flag = 'Y' THEN
5838: aso_debug_pub.add('ASO_QUOTE_PUB: After call to Batch Validate_Configuration: l_return_status: '||l_return_status,1,'Y');
5839: aso_debug_pub.add('ASO_QUOTE_PUB: l_config_header_id: '|| l_config_header_id,1,'N');
5840: aso_debug_pub.add('ASO_QUOTE_PUB: l_config_revision_num: '|| l_config_revision_num,1,'N');
5841: aso_debug_pub.add('ASO_QUOTE_PUB: l_valid_configuration_flag: '|| l_valid_configuration_flag,1,'N');
5842: aso_debug_pub.add('ASO_QUOTE_PUB: l_complete_configuration_flag: '|| l_complete_configuration_flag,1,'N');
5843: aso_debug_pub.add('ASO_QUOTE_PUB: l_config_changed: '|| l_config_changed,1,'N');
5844: END IF;
5845: --dbms_output.put_line('ASO_QUOTE_PUB: After call to Batch Validate_Configuration: l_return_status: '||l_return_status);

Line 5842: aso_debug_pub.add('ASO_QUOTE_PUB: l_complete_configuration_flag: '|| l_complete_configuration_flag,1,'N');

5838: aso_debug_pub.add('ASO_QUOTE_PUB: After call to Batch Validate_Configuration: l_return_status: '||l_return_status,1,'Y');
5839: aso_debug_pub.add('ASO_QUOTE_PUB: l_config_header_id: '|| l_config_header_id,1,'N');
5840: aso_debug_pub.add('ASO_QUOTE_PUB: l_config_revision_num: '|| l_config_revision_num,1,'N');
5841: aso_debug_pub.add('ASO_QUOTE_PUB: l_valid_configuration_flag: '|| l_valid_configuration_flag,1,'N');
5842: aso_debug_pub.add('ASO_QUOTE_PUB: l_complete_configuration_flag: '|| l_complete_configuration_flag,1,'N');
5843: aso_debug_pub.add('ASO_QUOTE_PUB: l_config_changed: '|| l_config_changed,1,'N');
5844: END IF;
5845: --dbms_output.put_line('ASO_QUOTE_PUB: After call to Batch Validate_Configuration: l_return_status: '||l_return_status);
5846: --dbms_output.put_line('ASO_QUOTE_PUB: l_config_header_id: '|| l_config_header_id);

Line 5843: aso_debug_pub.add('ASO_QUOTE_PUB: l_config_changed: '|| l_config_changed,1,'N');

5839: aso_debug_pub.add('ASO_QUOTE_PUB: l_config_header_id: '|| l_config_header_id,1,'N');
5840: aso_debug_pub.add('ASO_QUOTE_PUB: l_config_revision_num: '|| l_config_revision_num,1,'N');
5841: aso_debug_pub.add('ASO_QUOTE_PUB: l_valid_configuration_flag: '|| l_valid_configuration_flag,1,'N');
5842: aso_debug_pub.add('ASO_QUOTE_PUB: l_complete_configuration_flag: '|| l_complete_configuration_flag,1,'N');
5843: aso_debug_pub.add('ASO_QUOTE_PUB: l_config_changed: '|| l_config_changed,1,'N');
5844: END IF;
5845: --dbms_output.put_line('ASO_QUOTE_PUB: After call to Batch Validate_Configuration: l_return_status: '||l_return_status);
5846: --dbms_output.put_line('ASO_QUOTE_PUB: l_config_header_id: '|| l_config_header_id);
5847: --dbms_output.put_line('ASO_QUOTE_PUB: l_config_revision_num: '|| l_config_revision_num);

Line 5845: --dbms_output.put_line('ASO_QUOTE_PUB: After call to Batch Validate_Configuration: l_return_status: '||l_return_status);

5841: aso_debug_pub.add('ASO_QUOTE_PUB: l_valid_configuration_flag: '|| l_valid_configuration_flag,1,'N');
5842: aso_debug_pub.add('ASO_QUOTE_PUB: l_complete_configuration_flag: '|| l_complete_configuration_flag,1,'N');
5843: aso_debug_pub.add('ASO_QUOTE_PUB: l_config_changed: '|| l_config_changed,1,'N');
5844: END IF;
5845: --dbms_output.put_line('ASO_QUOTE_PUB: After call to Batch Validate_Configuration: l_return_status: '||l_return_status);
5846: --dbms_output.put_line('ASO_QUOTE_PUB: l_config_header_id: '|| l_config_header_id);
5847: --dbms_output.put_line('ASO_QUOTE_PUB: l_config_revision_num: '|| l_config_revision_num);
5848: --dbms_output.put_line('ASO_QUOTE_PUB: l_valid_configuration_flag: '|| l_valid_configuration_flag);
5849: --dbms_output.put_line('ASO_QUOTE_PUB: l_complete_configuration_flag: '|| l_complete_configuration_flag);

Line 5846: --dbms_output.put_line('ASO_QUOTE_PUB: l_config_header_id: '|| l_config_header_id);

5842: aso_debug_pub.add('ASO_QUOTE_PUB: l_complete_configuration_flag: '|| l_complete_configuration_flag,1,'N');
5843: aso_debug_pub.add('ASO_QUOTE_PUB: l_config_changed: '|| l_config_changed,1,'N');
5844: END IF;
5845: --dbms_output.put_line('ASO_QUOTE_PUB: After call to Batch Validate_Configuration: l_return_status: '||l_return_status);
5846: --dbms_output.put_line('ASO_QUOTE_PUB: l_config_header_id: '|| l_config_header_id);
5847: --dbms_output.put_line('ASO_QUOTE_PUB: l_config_revision_num: '|| l_config_revision_num);
5848: --dbms_output.put_line('ASO_QUOTE_PUB: l_valid_configuration_flag: '|| l_valid_configuration_flag);
5849: --dbms_output.put_line('ASO_QUOTE_PUB: l_complete_configuration_flag: '|| l_complete_configuration_flag);
5850: --dbms_output.put_line('ASO_QUOTE_PUB: l_config_changed: '|| l_config_changed);

Line 5847: --dbms_output.put_line('ASO_QUOTE_PUB: l_config_revision_num: '|| l_config_revision_num);

5843: aso_debug_pub.add('ASO_QUOTE_PUB: l_config_changed: '|| l_config_changed,1,'N');
5844: END IF;
5845: --dbms_output.put_line('ASO_QUOTE_PUB: After call to Batch Validate_Configuration: l_return_status: '||l_return_status);
5846: --dbms_output.put_line('ASO_QUOTE_PUB: l_config_header_id: '|| l_config_header_id);
5847: --dbms_output.put_line('ASO_QUOTE_PUB: l_config_revision_num: '|| l_config_revision_num);
5848: --dbms_output.put_line('ASO_QUOTE_PUB: l_valid_configuration_flag: '|| l_valid_configuration_flag);
5849: --dbms_output.put_line('ASO_QUOTE_PUB: l_complete_configuration_flag: '|| l_complete_configuration_flag);
5850: --dbms_output.put_line('ASO_QUOTE_PUB: l_config_changed: '|| l_config_changed);
5851:

Line 5848: --dbms_output.put_line('ASO_QUOTE_PUB: l_valid_configuration_flag: '|| l_valid_configuration_flag);

5844: END IF;
5845: --dbms_output.put_line('ASO_QUOTE_PUB: After call to Batch Validate_Configuration: l_return_status: '||l_return_status);
5846: --dbms_output.put_line('ASO_QUOTE_PUB: l_config_header_id: '|| l_config_header_id);
5847: --dbms_output.put_line('ASO_QUOTE_PUB: l_config_revision_num: '|| l_config_revision_num);
5848: --dbms_output.put_line('ASO_QUOTE_PUB: l_valid_configuration_flag: '|| l_valid_configuration_flag);
5849: --dbms_output.put_line('ASO_QUOTE_PUB: l_complete_configuration_flag: '|| l_complete_configuration_flag);
5850: --dbms_output.put_line('ASO_QUOTE_PUB: l_config_changed: '|| l_config_changed);
5851:
5852: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

Line 5849: --dbms_output.put_line('ASO_QUOTE_PUB: l_complete_configuration_flag: '|| l_complete_configuration_flag);

5845: --dbms_output.put_line('ASO_QUOTE_PUB: After call to Batch Validate_Configuration: l_return_status: '||l_return_status);
5846: --dbms_output.put_line('ASO_QUOTE_PUB: l_config_header_id: '|| l_config_header_id);
5847: --dbms_output.put_line('ASO_QUOTE_PUB: l_config_revision_num: '|| l_config_revision_num);
5848: --dbms_output.put_line('ASO_QUOTE_PUB: l_valid_configuration_flag: '|| l_valid_configuration_flag);
5849: --dbms_output.put_line('ASO_QUOTE_PUB: l_complete_configuration_flag: '|| l_complete_configuration_flag);
5850: --dbms_output.put_line('ASO_QUOTE_PUB: l_config_changed: '|| l_config_changed);
5851:
5852: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5853: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 5850: --dbms_output.put_line('ASO_QUOTE_PUB: l_config_changed: '|| l_config_changed);

5846: --dbms_output.put_line('ASO_QUOTE_PUB: l_config_header_id: '|| l_config_header_id);
5847: --dbms_output.put_line('ASO_QUOTE_PUB: l_config_revision_num: '|| l_config_revision_num);
5848: --dbms_output.put_line('ASO_QUOTE_PUB: l_valid_configuration_flag: '|| l_valid_configuration_flag);
5849: --dbms_output.put_line('ASO_QUOTE_PUB: l_complete_configuration_flag: '|| l_complete_configuration_flag);
5850: --dbms_output.put_line('ASO_QUOTE_PUB: l_config_changed: '|| l_config_changed);
5851:
5852: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5853: IF aso_debug_pub.g_debug_flag = 'Y' THEN
5854: aso_debug_pub.add('ASO Quote Pub : Batch Validate configuration success');

Line 5854: aso_debug_pub.add('ASO Quote Pub : Batch Validate configuration success');

5850: --dbms_output.put_line('ASO_QUOTE_PUB: l_config_changed: '|| l_config_changed);
5851:
5852: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5853: IF aso_debug_pub.g_debug_flag = 'Y' THEN
5854: aso_debug_pub.add('ASO Quote Pub : Batch Validate configuration success');
5855: END IF;
5856: -- code populate the cz rec type and set the changed flag
5857: l_config_index:=l_config_index+1;
5858: X_Config_tbl(l_config_index).quote_line_id:= l_model_qte_line_tbl(i).quote_line_id;

Line 5922: aso_debug_pub.add('ASO Quote Pub1 : Batch Validate configuration success'||X_Config_tbl.count);

5918: --End if;
5919:
5920: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5921: IF aso_debug_pub.g_debug_flag = 'Y' THEN
5922: aso_debug_pub.add('ASO Quote Pub1 : Batch Validate configuration success'||X_Config_tbl.count);
5923: END IF;
5924:
5925: FOR i IN 1..X_Config_tbl.count LOOP
5926: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 5927: aso_debug_pub.add('ASO Quote Pub1 : Batch Validate configuration success X_Config_tbl('||i||').QUOTE_LINE_ID:'||X_Config_tbl(i).QUOTE_LINE_ID);

5923: END IF;
5924:
5925: FOR i IN 1..X_Config_tbl.count LOOP
5926: IF aso_debug_pub.g_debug_flag = 'Y' THEN
5927: aso_debug_pub.add('ASO Quote Pub1 : Batch Validate configuration success X_Config_tbl('||i||').QUOTE_LINE_ID:'||X_Config_tbl(i).QUOTE_LINE_ID);
5928: aso_debug_pub.add('ASO Quote Pub1 : Batch Validate configuration success X_Config_tbl('||i||').IS_CFG_CHANGED_FLAG:'||X_Config_tbl(i).IS_CFG_CHANGED_FLAG);
5929: aso_debug_pub.add('ASO Quote Pub1 : Batch Validate configuration success X_Config_tbl('||i||').IS_CFG_VALID:'||X_Config_tbl(i).IS_CFG_VALID);
5930: aso_debug_pub.add('ASO Quote Pub1 : Batch Validate configuration success X_Config_tbl('||i||').IS_CFG_COMPLETE:'||X_Config_tbl(i).IS_CFG_COMPLETE);
5931: END IF;

Line 5928: aso_debug_pub.add('ASO Quote Pub1 : Batch Validate configuration success X_Config_tbl('||i||').IS_CFG_CHANGED_FLAG:'||X_Config_tbl(i).IS_CFG_CHANGED_FLAG);

5924:
5925: FOR i IN 1..X_Config_tbl.count LOOP
5926: IF aso_debug_pub.g_debug_flag = 'Y' THEN
5927: aso_debug_pub.add('ASO Quote Pub1 : Batch Validate configuration success X_Config_tbl('||i||').QUOTE_LINE_ID:'||X_Config_tbl(i).QUOTE_LINE_ID);
5928: aso_debug_pub.add('ASO Quote Pub1 : Batch Validate configuration success X_Config_tbl('||i||').IS_CFG_CHANGED_FLAG:'||X_Config_tbl(i).IS_CFG_CHANGED_FLAG);
5929: aso_debug_pub.add('ASO Quote Pub1 : Batch Validate configuration success X_Config_tbl('||i||').IS_CFG_VALID:'||X_Config_tbl(i).IS_CFG_VALID);
5930: aso_debug_pub.add('ASO Quote Pub1 : Batch Validate configuration success X_Config_tbl('||i||').IS_CFG_COMPLETE:'||X_Config_tbl(i).IS_CFG_COMPLETE);
5931: END IF;
5932:

Line 5929: aso_debug_pub.add('ASO Quote Pub1 : Batch Validate configuration success X_Config_tbl('||i||').IS_CFG_VALID:'||X_Config_tbl(i).IS_CFG_VALID);

5925: FOR i IN 1..X_Config_tbl.count LOOP
5926: IF aso_debug_pub.g_debug_flag = 'Y' THEN
5927: aso_debug_pub.add('ASO Quote Pub1 : Batch Validate configuration success X_Config_tbl('||i||').QUOTE_LINE_ID:'||X_Config_tbl(i).QUOTE_LINE_ID);
5928: aso_debug_pub.add('ASO Quote Pub1 : Batch Validate configuration success X_Config_tbl('||i||').IS_CFG_CHANGED_FLAG:'||X_Config_tbl(i).IS_CFG_CHANGED_FLAG);
5929: aso_debug_pub.add('ASO Quote Pub1 : Batch Validate configuration success X_Config_tbl('||i||').IS_CFG_VALID:'||X_Config_tbl(i).IS_CFG_VALID);
5930: aso_debug_pub.add('ASO Quote Pub1 : Batch Validate configuration success X_Config_tbl('||i||').IS_CFG_COMPLETE:'||X_Config_tbl(i).IS_CFG_COMPLETE);
5931: END IF;
5932:
5933: If X_Config_tbl(i).IS_CFG_CHANGED_FLAG = 'Y' then

Line 5930: aso_debug_pub.add('ASO Quote Pub1 : Batch Validate configuration success X_Config_tbl('||i||').IS_CFG_COMPLETE:'||X_Config_tbl(i).IS_CFG_COMPLETE);

5926: IF aso_debug_pub.g_debug_flag = 'Y' THEN
5927: aso_debug_pub.add('ASO Quote Pub1 : Batch Validate configuration success X_Config_tbl('||i||').QUOTE_LINE_ID:'||X_Config_tbl(i).QUOTE_LINE_ID);
5928: aso_debug_pub.add('ASO Quote Pub1 : Batch Validate configuration success X_Config_tbl('||i||').IS_CFG_CHANGED_FLAG:'||X_Config_tbl(i).IS_CFG_CHANGED_FLAG);
5929: aso_debug_pub.add('ASO Quote Pub1 : Batch Validate configuration success X_Config_tbl('||i||').IS_CFG_VALID:'||X_Config_tbl(i).IS_CFG_VALID);
5930: aso_debug_pub.add('ASO Quote Pub1 : Batch Validate configuration success X_Config_tbl('||i||').IS_CFG_COMPLETE:'||X_Config_tbl(i).IS_CFG_COMPLETE);
5931: END IF;
5932:
5933: If X_Config_tbl(i).IS_CFG_CHANGED_FLAG = 'Y' then
5934: /* L_In_Line_Number_Tbl(1).Quote_Line_Id := X_Config_tbl(i).QUOTE_LINE_ID;

Line 5941: ASO_QUOTE_PUB_W.Get_UI_Line_Number(X_Config_tbl(i).QUOTE_LINE_ID,l_Line_Number);*/

5937: X_Out_Line_Number_Tbl =>l_Out_Line_Number_Tbl);
5938:
5939: l_line_number:=l_Out_Line_Number_Tbl(X_Config_tbl(i).QUOTE_LINE_ID);
5940: --l_line_number := ASO_LINE_NUM_INT.Get_UI_Line_Number (X_Config_tbl(i).QUOTE_LINE_ID);
5941: ASO_QUOTE_PUB_W.Get_UI_Line_Number(X_Config_tbl(i).QUOTE_LINE_ID,l_Line_Number);*/
5942:
5943: ASO_LINE_NUM_INT.RESET_LINE_NUM;
5944:
5945: l_In_Line_Number_Tbl(1).quote_line_id := X_Config_tbl(i).QUOTE_LINE_ID;

Line 5955: aso_debug_pub.add('ASO Quote Pub1 : Batch Validate configuration succes l_line_number'||l_line_number);

5951:
5952: L_Line_Number := ASO_LINE_NUM_INT.Get_UI_Line_Number(X_Config_tbl(i).QUOTE_LINE_ID);
5953:
5954: IF aso_debug_pub.g_debug_flag = 'Y' THEN
5955: aso_debug_pub.add('ASO Quote Pub1 : Batch Validate configuration succes l_line_number'||l_line_number);
5956: end if;
5957: If l_changed_model_line_num is Null then
5958: l_changed_model_line_num := l_line_number;
5959: Else

Line 5965: --ASO_QUOTE_PUB_W.Get_UI_Line_Number(X_Config_tbl(i).QUOTE_LINE_ID,l_Line_Number);

5961: End if;
5962: End if;
5963:
5964: If X_Config_tbl(i).IS_CFG_VALID = 'N' or X_Config_tbl(i).IS_CFG_COMPLETE = 'N' then
5965: --ASO_QUOTE_PUB_W.Get_UI_Line_Number(X_Config_tbl(i).QUOTE_LINE_ID,l_Line_Number);
5966: --l_line_number := ASO_LINE_NUM_INT.Get_UI_Line_Number (X_Config_tbl(i).QUOTE_LINE_ID);
5967: ASO_LINE_NUM_INT.RESET_LINE_NUM;
5968:
5969: l_In_Line_Number_Tbl(1).quote_line_id := X_Config_tbl(i).QUOTE_LINE_ID;

Line 5979: aso_debug_pub.add('ASO Quote Pub1 : Batch Validate configuration succes l_line_number'||l_line_number);

5975:
5976: L_Line_Number := ASO_LINE_NUM_INT.Get_UI_Line_Number(X_Config_tbl(i).QUOTE_LINE_ID);
5977:
5978: IF aso_debug_pub.g_debug_flag = 'Y' THEN
5979: aso_debug_pub.add('ASO Quote Pub1 : Batch Validate configuration succes l_line_number'||l_line_number);
5980: end if;
5981: If l_invalid_model_line_num is Null then
5982: l_invalid_model_line_num := l_line_number;
5983: Else

Line 5997: aso_debug_pub.add('ASO Quote Pub1 : Batch Validate configuration success after X_Config_tbl loop');

5993: End if;
5994: */
5995:
5996: IF aso_debug_pub.g_debug_flag = 'Y' THEN
5997: aso_debug_pub.add('ASO Quote Pub1 : Batch Validate configuration success after X_Config_tbl loop');
5998: END IF;
5999:
6000: If l_changed_model_line_num is Not Null OR l_invalid_model_line_num is Not Null then
6001: FND_MESSAGE.Set_Name('ASO', 'ASO_MODEL_LINES_VALID_NOCHANGE');

Line 6032: aso_debug_pub.add('ASO Quote Pub : End Batch Validate configuration x_return_status '|| x_return_status);

6028:
6029: x_return_status := l_return_status;
6030:
6031: IF aso_debug_pub.g_debug_flag = 'Y' THEN
6032: aso_debug_pub.add('ASO Quote Pub : End Batch Validate configuration x_return_status '|| x_return_status);
6033: aso_debug_pub.add('ASO Quote Pub : End Batch Validate configuration X_Config_tbl.count '|| X_Config_tbl.count);
6034: End if;
6035:
6036: -- Standard check for p_commit

Line 6033: aso_debug_pub.add('ASO Quote Pub : End Batch Validate configuration X_Config_tbl.count '|| X_Config_tbl.count);

6029: x_return_status := l_return_status;
6030:
6031: IF aso_debug_pub.g_debug_flag = 'Y' THEN
6032: aso_debug_pub.add('ASO Quote Pub : End Batch Validate configuration x_return_status '|| x_return_status);
6033: aso_debug_pub.add('ASO Quote Pub : End Batch Validate configuration X_Config_tbl.count '|| X_Config_tbl.count);
6034: End if;
6035:
6036: -- Standard check for p_commit
6037: IF FND_API.to_Boolean( p_commit ) THEN

Line 6045: aso_debug_pub.add('ASO Quote Pub : End Batch Validate configuration L_Return_X_Msg_data '||L_Return_X_Msg_data, 1, 'Y');

6041: /* Added this Function to return the x_msg_data */
6042: --L_Return_X_Msg_data := Return_X_Msg_data;
6043:
6044: IF aso_debug_pub.g_debug_flag = 'Y' THEN
6045: aso_debug_pub.add('ASO Quote Pub : End Batch Validate configuration L_Return_X_Msg_data '||L_Return_X_Msg_data, 1, 'Y');
6046: End if;
6047:
6048: -- Standard call to get message count and if count is 1, get message info.
6049: FND_MSG_PUB.Count_And_Get

Line 6058: aso_debug_pub.add('ASO Quote Pub : End Batch Validate configuration x_msg_count '||x_msg_count, 1, 'Y');

6054: /* Assign the L_Return_X_Msg_data to the x_msg_data that can be shown in UI directly */
6055: -- x_msg_data := L_Return_X_Msg_data;
6056:
6057: IF aso_debug_pub.g_debug_flag = 'Y' THEN
6058: aso_debug_pub.add('ASO Quote Pub : End Batch Validate configuration x_msg_count '||x_msg_count, 1, 'Y');
6059: End if;
6060:
6061:
6062: EXCEPTION

Line 6102: End ASO_QUOTE_PUB;

6098: ,X_RETURN_STATUS => X_RETURN_STATUS);
6099:
6100: end validate_model_configuration;
6101:
6102: End ASO_QUOTE_PUB;