[Home] [Help]
429: rec_term_id c_term_id%rowtype;
430: rec_payment_id c_payment_id%rowtype;
431:
432: begin
433: -- Standard Start of API savepoint
434: SAVEPOINT handle_header_agreements_pvt;
435: -- Standard call to check for call compatibility.
436: IF NOT FND_API.Compatible_API_Call(L_API_VERSION,
437: p_api_version,
431:
432: begin
433: -- Standard Start of API savepoint
434: SAVEPOINT handle_header_agreements_pvt;
435: -- Standard call to check for call compatibility.
436: IF NOT FND_API.Compatible_API_Call(L_API_VERSION,
437: p_api_version,
438: L_API_NAME ,
439: G_PKG_NAME )
527: x_hdr_payment_tbl := l_hdr_payment_tbl;
528:
529: -- End of API body.
530:
531: -- Standard check of p_commit.
532: IF FND_API.To_Boolean(p_commit) THEN
533: COMMIT WORK;
534: END IF;
535: -- Standard call to get message count and if count is 1, get message info.
531: -- Standard check of p_commit.
532: IF FND_API.To_Boolean(p_commit) THEN
533: COMMIT WORK;
534: END IF;
535: -- Standard call to get message count and if count is 1, get message info.
536: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
537: p_count => x_msg_count ,
538: p_data => x_msg_data);
539:
1090: and ((l_item_type_code = 'STD') or ((l_item_type_code = 'SVA') and (l_line_level_services <> 'Y')) )
1091: and (l_quote_line_id is not null) ) THEN
1092:
1093: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1094: IBE_Util.Debug('Dealing with a standard item');
1095: END IF;
1096: x_qte_line_tbl(i).operation_code := 'UPDATE';
1097: x_qte_line_tbl(i).quantity := x_qte_line_tbl(i).quantity
1098: + nvl(l_quantity,0);
1189: l_qte_access_rec IBE_QUOTE_SAVESHARE_pvt.quote_access_rec_type
1190: := IBE_QUOTE_SAVESHARE_pvt.G_MISS_QUOTE_ACCESS_REC;
1191:
1192: BEGIN
1193: -- Standard Start of API savepoint
1194: SAVEPOINT DELETESHAREES_pvt;
1195: -- Standard call to check for call compatibility.
1196: IF NOT FND_API.Compatible_API_Call (l_api_version,
1197: P_Api_Version_Number,
1191:
1192: BEGIN
1193: -- Standard Start of API savepoint
1194: SAVEPOINT DELETESHAREES_pvt;
1195: -- Standard call to check for call compatibility.
1196: IF NOT FND_API.Compatible_API_Call (l_api_version,
1197: P_Api_Version_Number,
1198: l_api_name,
1199: G_PKG_NAME )
1252: EXIT when c_get_recipients%notfound;
1253: END LOOP;
1254:
1255: -- End of API body.
1256: -- Standard check of p_commit.
1257: IF FND_API.To_Boolean( p_commit ) THEN
1258: COMMIT WORK;
1259: END IF;
1260:
1257: IF FND_API.To_Boolean( p_commit ) THEN
1258: COMMIT WORK;
1259: END IF;
1260:
1261: -- Standard call to get message count and if count is 1, get message info.
1262: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
1263: p_count => x_msg_count ,
1264: p_data => x_msg_data);
1265: EXCEPTION
1356: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1357: IBE_Util.Debug('START IBE_Quote_Save_pvt.Delete()');
1358: END IF;
1359: --DBMS_OUTPUT.PUT_line('Begin IBE_Quote_Save_pvt.Delete()');
1360: -- Standard Start of API savepoint
1361: SAVEPOINT DELETE_pvt;
1362: -- Standard call to check for call compatibility.
1363: IF NOT FND_API.Compatible_API_Call (l_api_version,
1364: P_Api_Version_Number,
1358: END IF;
1359: --DBMS_OUTPUT.PUT_line('Begin IBE_Quote_Save_pvt.Delete()');
1360: -- Standard Start of API savepoint
1361: SAVEPOINT DELETE_pvt;
1362: -- Standard call to check for call compatibility.
1363: IF NOT FND_API.Compatible_API_Call (l_api_version,
1364: P_Api_Version_Number,
1365: l_api_name,
1366: G_PKG_NAME )
1603: END IF; --expunge_flag check
1604:
1605: -- End of API body.
1606:
1607: -- Standard check of p_commit.
1608: IF FND_API.To_Boolean( p_commit ) THEN
1609: COMMIT WORK;
1610: END IF;
1611:
1608: IF FND_API.To_Boolean( p_commit ) THEN
1609: COMMIT WORK;
1610: END IF;
1611:
1612: -- Standard call to get message count and if count is 1, get message info.
1613: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
1614: p_count => x_msg_count ,
1615: p_data => x_msg_data);
1616: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1687: select quote_line_id
1688: from aso_quote_lines
1689: where quote_header_id = p_quote_header_id;
1690: BEGIN
1691: -- Standard Start of API savepoint
1692: SAVEPOINT DELETEALLLINES_pvt;
1693: -- Standard call to check for call compatibility.
1694: IF NOT FND_API.Compatible_API_Call (l_api_version,
1695: P_Api_Version_Number,
1689: where quote_header_id = p_quote_header_id;
1690: BEGIN
1691: -- Standard Start of API savepoint
1692: SAVEPOINT DELETEALLLINES_pvt;
1693: -- Standard call to check for call compatibility.
1694: IF NOT FND_API.Compatible_API_Call (l_api_version,
1695: P_Api_Version_Number,
1696: l_api_name,
1697: G_PKG_NAME )
1766: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1767: END IF;
1768:
1769: -- End of API body.
1770: -- Standard check of p_commit.
1771: IF FND_API.To_Boolean( p_commit ) THEN
1772: COMMIT WORK;
1773: END IF;
1774:
1771: IF FND_API.To_Boolean( p_commit ) THEN
1772: COMMIT WORK;
1773: END IF;
1774:
1775: -- Standard call to get message count and if count is 1, get message info.
1776:
1777: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
1778: p_count => x_msg_count ,
1779: p_data => x_msg_data);
2019:
2020:
2021: BEGIN
2022:
2023: -- Standard Start of API savepoint
2024: SAVEPOINT AddItemsToCartorig_pvt;
2025:
2026: -- Standard call to check for call compatibility.
2027: IF NOT FND_API.Compatible_API_Call(L_API_VERSION,
2022:
2023: -- Standard Start of API savepoint
2024: SAVEPOINT AddItemsToCartorig_pvt;
2025:
2026: -- Standard call to check for call compatibility.
2027: IF NOT FND_API.Compatible_API_Call(L_API_VERSION,
2028: P_Api_Version_Number,
2029: L_API_NAME ,
2030: G_PKG_NAME )
2726: END IF;
2727: END IF; --if l_attach_contract is true;
2728:
2729: -- End of API body.
2730: -- Standard check of p_commit.
2731: IF FND_API.To_Boolean( p_commit ) THEN
2732: COMMIT WORK;
2733: END IF;
2734:
2731: IF FND_API.To_Boolean( p_commit ) THEN
2732: COMMIT WORK;
2733: END IF;
2734:
2735: -- Standard call to get message count and if count is 1, get message info.
2736: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
2737: p_count => x_msg_count ,
2738: p_data => x_msg_data);
2739:
2963: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2964: IBE_Util.Debug('Begin IBE_Quote_Save_pvt.AddItemsToCart() (new one)');
2965: END IF;
2966:
2967: -- Standard Start of API savepoint
2968: SAVEPOINT ADDITEMSTOCART_pvt;
2969: -- Standard call to check for call compatibility.
2970: IF NOT FND_API.Compatible_API_Call (l_api_version,
2971: P_Api_Version_Number,
2965: END IF;
2966:
2967: -- Standard Start of API savepoint
2968: SAVEPOINT ADDITEMSTOCART_pvt;
2969: -- Standard call to check for call compatibility.
2970: IF NOT FND_API.Compatible_API_Call (l_api_version,
2971: P_Api_Version_Number,
2972: l_api_name,
2973: G_PKG_NAME )
3035: l_control_rec.Calculate_tax_flag := 'N';
3036: l_control_rec.Calculate_freight_charge_flag := 'N';
3037: end if;
3038: -- Compulsory call to AddItemsToCart_orig - this call will take care of all
3039: -- standard, service, ui model, and model of the bundle items
3040: /*wrt to model bundles: Pass model_item_ids(p_Qte_line_Tbl) to AddItemsToCart and receive the table of model quote_line_ids returned by AddModelsToCart*/
3041: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3042: IBE_Util.Debug('Begin IBE_Quote_Save_pvt.AddItemsToCart_orig()');
3043: END IF;
3449: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3450: ibe_util.debug('Begin IEB_QUOTE_SAVE_pvt.GET_QUOTE_EXPIRATION_DATE()');
3451: END IF;
3452:
3453: -- Standard Start of API savepoint
3454: SAVEPOINT Get_quote_exp_date_pvt;
3455:
3456: -- Standard call to check for call compatibility.
3457: IF NOT FND_API.Compatible_API_Call(L_API_VERSION,
3452:
3453: -- Standard Start of API savepoint
3454: SAVEPOINT Get_quote_exp_date_pvt;
3455:
3456: -- Standard call to check for call compatibility.
3457: IF NOT FND_API.Compatible_API_Call(L_API_VERSION,
3458: p_api_version,
3459: L_API_NAME ,
3460: G_PKG_NAME )
3523: END IF;
3524: End if;
3525: End if;
3526:
3527: -- Standard check of p_commit.
3528: IF FND_API.To_Boolean(p_commit) THEN
3529: COMMIT WORK;
3530: END IF;
3531:
3528: IF FND_API.To_Boolean(p_commit) THEN
3529: COMMIT WORK;
3530: END IF;
3531:
3532: -- Standard call to get message count and if count is 1, get message info.
3533: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
3534: p_count => x_msg_count ,
3535: p_data => x_msg_data);
3536:
3670: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3671: ibe_util.debug('Start IBE_Quote_Save_pvt.REQUEST_FOR_SALES_ASSISTANCE()');
3672: END IF;
3673:
3674: -- Standard Start of API savepoint
3675: SAVEPOINT Req_for_sales_asst_pvt;
3676:
3677: -- Standard call to check for call compatibility.
3678: IF NOT FND_API.Compatible_API_Call(L_API_VERSION,
3673:
3674: -- Standard Start of API savepoint
3675: SAVEPOINT Req_for_sales_asst_pvt;
3676:
3677: -- Standard call to check for call compatibility.
3678: IF NOT FND_API.Compatible_API_Call(L_API_VERSION,
3679: p_api_version,
3680: L_API_NAME ,
3681: G_PKG_NAME )
4049: END IF;
4050: END IF;
4051: --Bug 3204942 End
4052:
4053: -- Standard check of p_commit.
4054: IF FND_API.To_Boolean(p_commit) THEN
4055: COMMIT WORK;
4056: END IF;
4057:
4054: IF FND_API.To_Boolean(p_commit) THEN
4055: COMMIT WORK;
4056: END IF;
4057:
4058: -- Standard call to get message count and if count is 1, get message info.
4059: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
4060: p_count => lx_msg_count ,
4061: p_data => lx_msg_data);
4062:
4415: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
4416: IBE_UTIL.DEBUG('After calling mo_global.init)');
4417: END IF;
4418:
4419: -- Standard Start of API savepoint
4420: SAVEPOINT SAVE_pvt;
4421: -- Standard call to check for call compatibility.
4422: IF NOT FND_API.Compatible_API_Call (l_api_version,
4423: P_Api_Version_Number,
4417: END IF;
4418:
4419: -- Standard Start of API savepoint
4420: SAVEPOINT SAVE_pvt;
4421: -- Standard call to check for call compatibility.
4422: IF NOT FND_API.Compatible_API_Call (l_api_version,
4423: P_Api_Version_Number,
4424: l_api_name,
4425: G_PKG_NAME )
5111: x_quote_header_id := x_qte_header_rec.quote_header_id;
5112: x_last_update_date := x_qte_header_rec.last_update_date;
5113:
5114: -- End of API body.
5115: -- Standard check of p_commit.
5116: IF FND_API.To_Boolean( p_commit ) THEN
5117: COMMIT WORK;
5118: END IF;
5119:
5116: IF FND_API.To_Boolean( p_commit ) THEN
5117: COMMIT WORK;
5118: END IF;
5119:
5120: -- Standard call to get message count and if count is 1, get message info.
5121: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
5122: p_count => x_msg_count ,
5123: p_data => x_msg_data);
5124: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
5259: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
5260: IBE_Util.Debug('Begin IBE_Quote_Save_pvt.UpdateQuoteForSharee()');
5261: END IF;
5262:
5263: -- Standard Start of API savepoint
5264: SAVEPOINT UpdateQuoteForSharee_pvt;
5265: -- Standard call to check for call compatibility.
5266: IF NOT FND_API.Compatible_API_Call (l_api_version,
5267: P_Api_Version_Number,
5261: END IF;
5262:
5263: -- Standard Start of API savepoint
5264: SAVEPOINT UpdateQuoteForSharee_pvt;
5265: -- Standard call to check for call compatibility.
5266: IF NOT FND_API.Compatible_API_Call (l_api_version,
5267: P_Api_Version_Number,
5268: l_api_name,
5269: G_PKG_NAME )
5419: END IF;
5420: END IF;
5421:
5422: -- End of API body.
5423: -- Standard check of p_commit.
5424: IF FND_API.To_Boolean( p_commit ) THEN
5425: COMMIT WORK;
5426: END IF;
5427:
5424: IF FND_API.To_Boolean( p_commit ) THEN
5425: COMMIT WORK;
5426: END IF;
5427:
5428: -- Standard call to get message count and if count is 1, get message info.
5429: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
5430: p_count => x_msg_count ,
5431: p_data => x_msg_data);
5432: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
5539: l_cvv2_setup VARCHAR2(1);
5540: l_statement_address_setup VARCHAR2(1);
5541: BEGIN
5542:
5543: -- Standard Start of API savepoint
5544: SAVEPOINT getHdrDefaultValues_PVT;
5545:
5546: -- Standard call to check for call compatibility.
5547: IF NOT FND_API.Compatible_API_Call(L_API_VERSION,
5542:
5543: -- Standard Start of API savepoint
5544: SAVEPOINT getHdrDefaultValues_PVT;
5545:
5546: -- Standard call to check for call compatibility.
5547: IF NOT FND_API.Compatible_API_Call(L_API_VERSION,
5548: P_Api_Version_Number,
5549: L_API_NAME ,
5550: G_PKG_NAME )
5884: x_hd_Tax_Detail_Tbl := lx_hd_Tax_Detail_Tbl;
5885: --maithili added for R12, for creating header level offer codes
5886: x_hd_Price_Attributes_Tbl := p_hd_Price_Attributes_Tbl;
5887: -- End of API body.
5888: -- Standard check of p_commit.
5889: IF FND_API.To_Boolean( p_commit ) THEN
5890: COMMIT WORK;
5891: END IF;
5892:
5889: IF FND_API.To_Boolean( p_commit ) THEN
5890: COMMIT WORK;
5891: END IF;
5892:
5893: -- Standard call to get message count and if count is 1, get message info.
5894: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
5895: p_count => x_msg_count ,
5896: p_data => x_msg_data);
5897: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
5988: rec_billTo_partyId c_check_billTo_partyId%rowtype;
5989:
5990: begin
5991:
5992: -- Standard Start of API savepoint
5993: SAVEPOINT getHdrDefaultAddress_pvt;
5994:
5995: -- Standard call to check for call compatibility.
5996: IF NOT FND_API.Compatible_API_Call(L_API_VERSION,
5991:
5992: -- Standard Start of API savepoint
5993: SAVEPOINT getHdrDefaultAddress_pvt;
5994:
5995: -- Standard call to check for call compatibility.
5996: IF NOT FND_API.Compatible_API_Call(L_API_VERSION,
5997: P_Api_Version_Number,
5998: L_API_NAME ,
5999: G_PKG_NAME )
6200:
6201: end if; -- if (l_isDone <> 'Y')
6202:
6203: -- End of API body.
6204: -- Standard check of p_commit.
6205: IF FND_API.To_Boolean( p_commit ) THEN
6206: COMMIT WORK;
6207: END IF;
6208:
6205: IF FND_API.To_Boolean( p_commit ) THEN
6206: COMMIT WORK;
6207: END IF;
6208:
6209: -- Standard call to get message count and if count is 1, get message info.
6210: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
6211: p_count => x_msg_count ,
6212: p_data => x_msg_data);
6213: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
6292: rec_MiniSiteOrg_ShipMethod c_get_MiniSiteOrg_ShipMethod%rowtype;
6293:
6294: begin
6295:
6296: -- Standard Start of API savepoint
6297: SAVEPOINT getHdrDefaultShipMethod_pvt;
6298:
6299: -- Standard call to check for call compatibility.
6300: IF NOT FND_API.Compatible_API_Call(L_API_VERSION,
6295:
6296: -- Standard Start of API savepoint
6297: SAVEPOINT getHdrDefaultShipMethod_pvt;
6298:
6299: -- Standard call to check for call compatibility.
6300: IF NOT FND_API.Compatible_API_Call(L_API_VERSION,
6301: P_Api_Version_Number,
6302: L_API_NAME ,
6303: G_PKG_NAME )
6442:
6443: end if; -- if (l_isDone <> 'Y')
6444:
6445: -- End of API body.
6446: -- Standard check of p_commit.
6447: IF FND_API.To_Boolean( p_commit ) THEN
6448: COMMIT WORK;
6449: END IF;
6450:
6447: IF FND_API.To_Boolean( p_commit ) THEN
6448: COMMIT WORK;
6449: END IF;
6450:
6451: -- Standard call to get message count and if count is 1, get message info.
6452: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
6453: p_count => x_msg_count ,
6454: p_data => x_msg_data);
6455: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
6547: rec_next_payment_type c_get_next_payment_type%rowtype;
6548:
6549: begin
6550:
6551: -- Standard Start of API savepoint
6552: SAVEPOINT getHdrDefPmtMethod_pvt;
6553:
6554: -- Standard call to check for call compatibility.
6555: IF NOT FND_API.Compatible_API_Call(L_API_VERSION,
6550:
6551: -- Standard Start of API savepoint
6552: SAVEPOINT getHdrDefPmtMethod_pvt;
6553:
6554: -- Standard call to check for call compatibility.
6555: IF NOT FND_API.Compatible_API_Call(L_API_VERSION,
6556: P_Api_Version_Number,
6557: L_API_NAME ,
6558: G_PKG_NAME )
6768:
6769: end if; -- if (l_isDone <> 'Y')
6770:
6771: -- End of API body.
6772: -- Standard check of p_commit.
6773: IF FND_API.To_Boolean( p_commit ) THEN
6774: COMMIT WORK;
6775: END IF;
6776:
6773: IF FND_API.To_Boolean( p_commit ) THEN
6774: COMMIT WORK;
6775: END IF;
6776:
6777: -- Standard call to get message count and if count is 1, get message info.
6778: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
6779: p_count => x_msg_count ,
6780: p_data => x_msg_data);
6781: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
6839: rec_tax_rec_exist c_check_tax_rec_exist%rowtype;
6840:
6841: begin
6842:
6843: -- Standard Start of API savepoint
6844: SAVEPOINT getHdrDefTaxExmpt_pvt;
6845:
6846: -- Standard call to check for call compatibility.
6847: IF NOT FND_API.Compatible_API_Call(L_API_VERSION,
6842:
6843: -- Standard Start of API savepoint
6844: SAVEPOINT getHdrDefTaxExmpt_pvt;
6845:
6846: -- Standard call to check for call compatibility.
6847: IF NOT FND_API.Compatible_API_Call(L_API_VERSION,
6848: P_Api_Version_Number,
6849: L_API_NAME ,
6850: G_PKG_NAME )
6894: -- px_hd_Tax_Detail_Tbl(1).quote_shipment_index := 1; // no need
6895: px_hd_Tax_Detail_Tbl(1).tax_exempt_flag := 'S';
6896: end if;
6897:
6898: -- Standard call to get message count and if count is 1, get message info.
6899: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
6900: p_count => x_msg_count ,
6901: p_data => x_msg_data);
6902: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
6962: rec_shipTo_info c_get_shipTo_info%rowtype;
6963:
6964: begin
6965:
6966: -- Standard Start of API savepoint
6967: SAVEPOINT getHdrDefaultEndCustomer_pvt;
6968:
6969: -- Standard call to check for call compatibility.
6970: IF NOT FND_API.Compatible_API_Call(L_API_VERSION,
6965:
6966: -- Standard Start of API savepoint
6967: SAVEPOINT getHdrDefaultEndCustomer_pvt;
6968:
6969: -- Standard call to check for call compatibility.
6970: IF NOT FND_API.Compatible_API_Call(L_API_VERSION,
6971: P_Api_Version_Number,
6972: L_API_NAME ,
6973: G_PKG_NAME )
7036: IBE_Util.Debug('getHdrDefaultEndCustomer: px_qte_header_rec.end_customer_party_site_id ='||px_qte_header_rec.end_customer_party_site_id);
7037: END IF;
7038:
7039: -- End of API body.
7040: -- Standard check of p_commit.
7041: IF FND_API.To_Boolean( p_commit ) THEN
7042: COMMIT WORK;
7043: END IF;
7044:
7041: IF FND_API.To_Boolean( p_commit ) THEN
7042: COMMIT WORK;
7043: END IF;
7044:
7045: -- Standard call to get message count and if count is 1, get message info.
7046: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
7047: p_count => x_msg_count ,
7048: p_data => x_msg_data);
7049: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
7103: l_api_version CONSTANT NUMBER := 1.0;
7104:
7105: BEGIN
7106:
7107: -- Standard Start of API savepoint
7108: SAVEPOINT CREATECONTRACTFORQUOTE_pvt;
7109:
7110: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
7111: IBE_UTIL.DEBUG('REACHED CREATE_CONTRACT_FOR_QUOTE' || to_char(sysdate, 'mm/dd/yyyy:hh24:MI:SS'));
7111: IBE_UTIL.DEBUG('REACHED CREATE_CONTRACT_FOR_QUOTE' || to_char(sysdate, 'mm/dd/yyyy:hh24:MI:SS'));
7112: END IF;
7113:
7114:
7115: -- Standard call to check for call compatibility.
7116: IF NOT FND_API.Compatible_API_Call(l_api_version,
7117: P_Api_Version_Number,
7118: l_api_name ,
7119: G_PKG_NAME )
7246: END IF;
7247:
7248:
7249:
7250: -- Standard call to get message count and if count is 1, get message info.
7251: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
7252: p_count => x_msg_count ,
7253: p_data => x_msg_data);
7254: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
7382: IBE_UTIL.DEBUG('DUPLICATE_CART: p_retrieval_number = '||p_retrieval_number);
7383: IBE_UTIL.DEBUG('DUPLICATE_CART: p_minisite_id = '||p_minisite_id);
7384: END IF;
7385:
7386: -- Standard Start of API savepoint
7387: SAVEPOINT Duplicate_Cart;
7388:
7389: -- Standard call to check for call compatibility.
7390: IF NOT FND_API.Compatible_API_Call(L_API_VERSION,
7385:
7386: -- Standard Start of API savepoint
7387: SAVEPOINT Duplicate_Cart;
7388:
7389: -- Standard call to check for call compatibility.
7390: IF NOT FND_API.Compatible_API_Call(L_API_VERSION,
7391: p_api_version,
7392: L_API_NAME ,
7393: G_PKG_NAME )
7610:
7611: END IF;
7612: x_quote_header_id := lx_quote_header_id;
7613:
7614: -- Standard call to get message count and if count is 1, get message info.
7615: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
7616: p_count => x_msg_count ,
7617: p_data => x_msg_data);
7618: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
7709: lx_Price_Adj_Attr_Tbl ASO_Quote_Pub.Price_Adj_Attr_Tbl_Type;
7710: lx_Price_Adj_Rltship_Tbl ASO_Quote_Pub.Price_Adj_Rltship_Tbl_Type;
7711:
7712: BEGIN
7713: -- Standard Start of API savepoint
7714: SAVEPOINT Reconfigure_From_Ib;
7715:
7716: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
7717: IBE_UTIL.DEBUG('Begin Reconfigure_Form_IB');
7716: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
7717: IBE_UTIL.DEBUG('Begin Reconfigure_Form_IB');
7718: END IF;
7719:
7720: -- Standard call to check for call compatibility.
7721: IF NOT FND_API.Compatible_API_Call(L_API_VERSION,
7722: P_Api_Version_Number,
7723: L_API_NAME ,
7724: G_PKG_NAME )
7876: IBE_UTIL.DEBUG('Ref cursor x_config_line begin');
7877: END IF;
7878: open x_config_line for l_refcursor_query using l_Qte_Header_Rec.quote_header_id;
7879: -- End of API body.
7880: -- Standard check of p_commit.
7881: IF FND_API.To_Boolean( p_commit ) THEN
7882: COMMIT WORK;
7883: END IF;
7884:
7881: IF FND_API.To_Boolean( p_commit ) THEN
7882: COMMIT WORK;
7883: END IF;
7884:
7885: -- Standard call to get message count and if count is 1, get message info.
7886: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
7887: p_count => x_msg_count ,
7888: p_data => x_msg_data);
7889: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
8109: CURSOR c_get_line_qty(p_quote_line_id NUMBER) IS
8110: SELECT quantity FROM aso_quote_lines_all
8111: WHERE quote_line_id = p_quote_line_id;
8112: BEGIN
8113: -- Standard Start of API savepoint
8114: SAVEPOINT UPDATE_SUPPORT_LEVEL_AND_QTY;
8115:
8116: -- Standard initialization tasks
8117: -- Standard call to check for call compatibility.
8112: BEGIN
8113: -- Standard Start of API savepoint
8114: SAVEPOINT UPDATE_SUPPORT_LEVEL_AND_QTY;
8115:
8116: -- Standard initialization tasks
8117: -- Standard call to check for call compatibility.
8118: IF NOT FND_API.Compatible_API_Call (l_api_version,p_api_version,l_api_name,G_PKG_NAME) THEN
8119: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8120: END IF;
8113: -- Standard Start of API savepoint
8114: SAVEPOINT UPDATE_SUPPORT_LEVEL_AND_QTY;
8115:
8116: -- Standard initialization tasks
8117: -- Standard call to check for call compatibility.
8118: IF NOT FND_API.Compatible_API_Call (l_api_version,p_api_version,l_api_name,G_PKG_NAME) THEN
8119: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8120: END IF;
8121: