[Home] [Help]
410: rec_term_id c_term_id%rowtype;
411: rec_payment_id c_payment_id%rowtype;
412:
413: begin
414: -- Standard Start of API savepoint
415: SAVEPOINT handle_header_agreements_pvt;
416: -- Standard call to check for call compatibility.
417: IF NOT FND_API.Compatible_API_Call(L_API_VERSION,
418: p_api_version,
412:
413: begin
414: -- Standard Start of API savepoint
415: SAVEPOINT handle_header_agreements_pvt;
416: -- Standard call to check for call compatibility.
417: IF NOT FND_API.Compatible_API_Call(L_API_VERSION,
418: p_api_version,
419: L_API_NAME ,
420: G_PKG_NAME )
508: x_hdr_payment_tbl := l_hdr_payment_tbl;
509:
510: -- End of API body.
511:
512: -- Standard check of p_commit.
513: IF FND_API.To_Boolean(p_commit) THEN
514: COMMIT WORK;
515: END IF;
516: -- Standard call to get message count and if count is 1, get message info.
512: -- Standard check of p_commit.
513: IF FND_API.To_Boolean(p_commit) THEN
514: COMMIT WORK;
515: END IF;
516: -- Standard call to get message count and if count is 1, get message info.
517: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
518: p_count => x_msg_count ,
519: p_data => x_msg_data);
520:
1071: and ((l_item_type_code = 'STD') or ((l_item_type_code = 'SVA') and (l_line_level_services <> 'Y')) )
1072: and (l_quote_line_id is not null) ) THEN
1073:
1074: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1075: IBE_Util.Debug('Dealing with a standard item');
1076: END IF;
1077: x_qte_line_tbl(i).operation_code := 'UPDATE';
1078: x_qte_line_tbl(i).quantity := x_qte_line_tbl(i).quantity
1079: + nvl(l_quantity,0);
1170: l_qte_access_rec IBE_QUOTE_SAVESHARE_pvt.quote_access_rec_type
1171: := IBE_QUOTE_SAVESHARE_pvt.G_MISS_QUOTE_ACCESS_REC;
1172:
1173: BEGIN
1174: -- Standard Start of API savepoint
1175: SAVEPOINT DELETESHAREES_pvt;
1176: -- Standard call to check for call compatibility.
1177: IF NOT FND_API.Compatible_API_Call (l_api_version,
1178: P_Api_Version_Number,
1172:
1173: BEGIN
1174: -- Standard Start of API savepoint
1175: SAVEPOINT DELETESHAREES_pvt;
1176: -- Standard call to check for call compatibility.
1177: IF NOT FND_API.Compatible_API_Call (l_api_version,
1178: P_Api_Version_Number,
1179: l_api_name,
1180: G_PKG_NAME )
1233: EXIT when c_get_recipients%notfound;
1234: END LOOP;
1235:
1236: -- End of API body.
1237: -- Standard check of p_commit.
1238: IF FND_API.To_Boolean( p_commit ) THEN
1239: COMMIT WORK;
1240: END IF;
1241:
1238: IF FND_API.To_Boolean( p_commit ) THEN
1239: COMMIT WORK;
1240: END IF;
1241:
1242: -- Standard call to get message count and if count is 1, get message info.
1243: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
1244: p_count => x_msg_count ,
1245: p_data => x_msg_data);
1246: EXCEPTION
1337: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1338: IBE_Util.Debug('START IBE_Quote_Save_pvt.Delete()');
1339: END IF;
1340: --DBMS_OUTPUT.PUT_line('Begin IBE_Quote_Save_pvt.Delete()');
1341: -- Standard Start of API savepoint
1342: SAVEPOINT DELETE_pvt;
1343: -- Standard call to check for call compatibility.
1344: IF NOT FND_API.Compatible_API_Call (l_api_version,
1345: P_Api_Version_Number,
1339: END IF;
1340: --DBMS_OUTPUT.PUT_line('Begin IBE_Quote_Save_pvt.Delete()');
1341: -- Standard Start of API savepoint
1342: SAVEPOINT DELETE_pvt;
1343: -- Standard call to check for call compatibility.
1344: IF NOT FND_API.Compatible_API_Call (l_api_version,
1345: P_Api_Version_Number,
1346: l_api_name,
1347: G_PKG_NAME )
1584: END IF; --expunge_flag check
1585:
1586: -- End of API body.
1587:
1588: -- Standard check of p_commit.
1589: IF FND_API.To_Boolean( p_commit ) THEN
1590: COMMIT WORK;
1591: END IF;
1592:
1589: IF FND_API.To_Boolean( p_commit ) THEN
1590: COMMIT WORK;
1591: END IF;
1592:
1593: -- Standard call to get message count and if count is 1, get message info.
1594: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
1595: p_count => x_msg_count ,
1596: p_data => x_msg_data);
1597: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1668: select quote_line_id
1669: from aso_quote_lines
1670: where quote_header_id = p_quote_header_id;
1671: BEGIN
1672: -- Standard Start of API savepoint
1673: SAVEPOINT DELETEALLLINES_pvt;
1674: -- Standard call to check for call compatibility.
1675: IF NOT FND_API.Compatible_API_Call (l_api_version,
1676: P_Api_Version_Number,
1670: where quote_header_id = p_quote_header_id;
1671: BEGIN
1672: -- Standard Start of API savepoint
1673: SAVEPOINT DELETEALLLINES_pvt;
1674: -- Standard call to check for call compatibility.
1675: IF NOT FND_API.Compatible_API_Call (l_api_version,
1676: P_Api_Version_Number,
1677: l_api_name,
1678: G_PKG_NAME )
1747: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1748: END IF;
1749:
1750: -- End of API body.
1751: -- Standard check of p_commit.
1752: IF FND_API.To_Boolean( p_commit ) THEN
1753: COMMIT WORK;
1754: END IF;
1755:
1752: IF FND_API.To_Boolean( p_commit ) THEN
1753: COMMIT WORK;
1754: END IF;
1755:
1756: -- Standard call to get message count and if count is 1, get message info.
1757:
1758: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
1759: p_count => x_msg_count ,
1760: p_data => x_msg_data);
2000:
2001:
2002: BEGIN
2003:
2004: -- Standard Start of API savepoint
2005: SAVEPOINT AddItemsToCartorig_pvt;
2006:
2007: -- Standard call to check for call compatibility.
2008: IF NOT FND_API.Compatible_API_Call(L_API_VERSION,
2003:
2004: -- Standard Start of API savepoint
2005: SAVEPOINT AddItemsToCartorig_pvt;
2006:
2007: -- Standard call to check for call compatibility.
2008: IF NOT FND_API.Compatible_API_Call(L_API_VERSION,
2009: P_Api_Version_Number,
2010: L_API_NAME ,
2011: G_PKG_NAME )
2707: END IF;
2708: END IF; --if l_attach_contract is true;
2709:
2710: -- End of API body.
2711: -- Standard check of p_commit.
2712: IF FND_API.To_Boolean( p_commit ) THEN
2713: COMMIT WORK;
2714: END IF;
2715:
2712: IF FND_API.To_Boolean( p_commit ) THEN
2713: COMMIT WORK;
2714: END IF;
2715:
2716: -- Standard call to get message count and if count is 1, get message info.
2717: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
2718: p_count => x_msg_count ,
2719: p_data => x_msg_data);
2720:
2944: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2945: IBE_Util.Debug('Begin IBE_Quote_Save_pvt.AddItemsToCart() (new one)');
2946: END IF;
2947:
2948: -- Standard Start of API savepoint
2949: SAVEPOINT ADDITEMSTOCART_pvt;
2950: -- Standard call to check for call compatibility.
2951: IF NOT FND_API.Compatible_API_Call (l_api_version,
2952: P_Api_Version_Number,
2946: END IF;
2947:
2948: -- Standard Start of API savepoint
2949: SAVEPOINT ADDITEMSTOCART_pvt;
2950: -- Standard call to check for call compatibility.
2951: IF NOT FND_API.Compatible_API_Call (l_api_version,
2952: P_Api_Version_Number,
2953: l_api_name,
2954: G_PKG_NAME )
3016: l_control_rec.Calculate_tax_flag := 'N';
3017: l_control_rec.Calculate_freight_charge_flag := 'N';
3018: end if;
3019: -- Compulsory call to AddItemsToCart_orig - this call will take care of all
3020: -- standard, service, ui model, and model of the bundle items
3021: /*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*/
3022: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3023: IBE_Util.Debug('Begin IBE_Quote_Save_pvt.AddItemsToCart_orig()');
3024: END IF;
3430: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3431: ibe_util.debug('Begin IEB_QUOTE_SAVE_pvt.GET_QUOTE_EXPIRATION_DATE()');
3432: END IF;
3433:
3434: -- Standard Start of API savepoint
3435: SAVEPOINT Get_quote_exp_date_pvt;
3436:
3437: -- Standard call to check for call compatibility.
3438: IF NOT FND_API.Compatible_API_Call(L_API_VERSION,
3433:
3434: -- Standard Start of API savepoint
3435: SAVEPOINT Get_quote_exp_date_pvt;
3436:
3437: -- Standard call to check for call compatibility.
3438: IF NOT FND_API.Compatible_API_Call(L_API_VERSION,
3439: p_api_version,
3440: L_API_NAME ,
3441: G_PKG_NAME )
3504: END IF;
3505: End if;
3506: End if;
3507:
3508: -- Standard check of p_commit.
3509: IF FND_API.To_Boolean(p_commit) THEN
3510: COMMIT WORK;
3511: END IF;
3512:
3509: IF FND_API.To_Boolean(p_commit) THEN
3510: COMMIT WORK;
3511: END IF;
3512:
3513: -- Standard call to get message count and if count is 1, get message info.
3514: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
3515: p_count => x_msg_count ,
3516: p_data => x_msg_data);
3517:
3651: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3652: ibe_util.debug('Start IBE_Quote_Save_pvt.REQUEST_FOR_SALES_ASSISTANCE()');
3653: END IF;
3654:
3655: -- Standard Start of API savepoint
3656: SAVEPOINT Req_for_sales_asst_pvt;
3657:
3658: -- Standard call to check for call compatibility.
3659: IF NOT FND_API.Compatible_API_Call(L_API_VERSION,
3654:
3655: -- Standard Start of API savepoint
3656: SAVEPOINT Req_for_sales_asst_pvt;
3657:
3658: -- Standard call to check for call compatibility.
3659: IF NOT FND_API.Compatible_API_Call(L_API_VERSION,
3660: p_api_version,
3661: L_API_NAME ,
3662: G_PKG_NAME )
4030: END IF;
4031: END IF;
4032: --Bug 3204942 End
4033:
4034: -- Standard check of p_commit.
4035: IF FND_API.To_Boolean(p_commit) THEN
4036: COMMIT WORK;
4037: END IF;
4038:
4035: IF FND_API.To_Boolean(p_commit) THEN
4036: COMMIT WORK;
4037: END IF;
4038:
4039: -- Standard call to get message count and if count is 1, get message info.
4040: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
4041: p_count => lx_msg_count ,
4042: p_data => lx_msg_data);
4043:
4371: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
4372: IBE_Util.Debug('Begin IBE_Quote_Save_pvt.Save()');
4373: END IF;
4374:
4375: -- Standard Start of API savepoint
4376: SAVEPOINT SAVE_pvt;
4377: -- Standard call to check for call compatibility.
4378: IF NOT FND_API.Compatible_API_Call (l_api_version,
4379: P_Api_Version_Number,
4373: END IF;
4374:
4375: -- Standard Start of API savepoint
4376: SAVEPOINT SAVE_pvt;
4377: -- Standard call to check for call compatibility.
4378: IF NOT FND_API.Compatible_API_Call (l_api_version,
4379: P_Api_Version_Number,
4380: l_api_name,
4381: G_PKG_NAME )
5007: x_quote_header_id := x_qte_header_rec.quote_header_id;
5008: x_last_update_date := x_qte_header_rec.last_update_date;
5009:
5010: -- End of API body.
5011: -- Standard check of p_commit.
5012: IF FND_API.To_Boolean( p_commit ) THEN
5013: COMMIT WORK;
5014: END IF;
5015:
5012: IF FND_API.To_Boolean( p_commit ) THEN
5013: COMMIT WORK;
5014: END IF;
5015:
5016: -- Standard call to get message count and if count is 1, get message info.
5017: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
5018: p_count => x_msg_count ,
5019: p_data => x_msg_data);
5020: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
5155: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
5156: IBE_Util.Debug('Begin IBE_Quote_Save_pvt.UpdateQuoteForSharee()');
5157: END IF;
5158:
5159: -- Standard Start of API savepoint
5160: SAVEPOINT UpdateQuoteForSharee_pvt;
5161: -- Standard call to check for call compatibility.
5162: IF NOT FND_API.Compatible_API_Call (l_api_version,
5163: P_Api_Version_Number,
5157: END IF;
5158:
5159: -- Standard Start of API savepoint
5160: SAVEPOINT UpdateQuoteForSharee_pvt;
5161: -- Standard call to check for call compatibility.
5162: IF NOT FND_API.Compatible_API_Call (l_api_version,
5163: P_Api_Version_Number,
5164: l_api_name,
5165: G_PKG_NAME )
5315: END IF;
5316: END IF;
5317:
5318: -- End of API body.
5319: -- Standard check of p_commit.
5320: IF FND_API.To_Boolean( p_commit ) THEN
5321: COMMIT WORK;
5322: END IF;
5323:
5320: IF FND_API.To_Boolean( p_commit ) THEN
5321: COMMIT WORK;
5322: END IF;
5323:
5324: -- Standard call to get message count and if count is 1, get message info.
5325: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
5326: p_count => x_msg_count ,
5327: p_data => x_msg_data);
5328: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
5435: l_cvv2_setup VARCHAR2(1);
5436: l_statement_address_setup VARCHAR2(1);
5437: BEGIN
5438:
5439: -- Standard Start of API savepoint
5440: SAVEPOINT getHdrDefaultValues_PVT;
5441:
5442: -- Standard call to check for call compatibility.
5443: IF NOT FND_API.Compatible_API_Call(L_API_VERSION,
5438:
5439: -- Standard Start of API savepoint
5440: SAVEPOINT getHdrDefaultValues_PVT;
5441:
5442: -- Standard call to check for call compatibility.
5443: IF NOT FND_API.Compatible_API_Call(L_API_VERSION,
5444: P_Api_Version_Number,
5445: L_API_NAME ,
5446: G_PKG_NAME )
5780: x_hd_Tax_Detail_Tbl := lx_hd_Tax_Detail_Tbl;
5781: --maithili added for R12, for creating header level offer codes
5782: x_hd_Price_Attributes_Tbl := p_hd_Price_Attributes_Tbl;
5783: -- End of API body.
5784: -- Standard check of p_commit.
5785: IF FND_API.To_Boolean( p_commit ) THEN
5786: COMMIT WORK;
5787: END IF;
5788:
5785: IF FND_API.To_Boolean( p_commit ) THEN
5786: COMMIT WORK;
5787: END IF;
5788:
5789: -- Standard call to get message count and if count is 1, get message info.
5790: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
5791: p_count => x_msg_count ,
5792: p_data => x_msg_data);
5793: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
5884: rec_billTo_partyId c_check_billTo_partyId%rowtype;
5885:
5886: begin
5887:
5888: -- Standard Start of API savepoint
5889: SAVEPOINT getHdrDefaultAddress_pvt;
5890:
5891: -- Standard call to check for call compatibility.
5892: IF NOT FND_API.Compatible_API_Call(L_API_VERSION,
5887:
5888: -- Standard Start of API savepoint
5889: SAVEPOINT getHdrDefaultAddress_pvt;
5890:
5891: -- Standard call to check for call compatibility.
5892: IF NOT FND_API.Compatible_API_Call(L_API_VERSION,
5893: P_Api_Version_Number,
5894: L_API_NAME ,
5895: G_PKG_NAME )
6096:
6097: end if; -- if (l_isDone <> 'Y')
6098:
6099: -- End of API body.
6100: -- Standard check of p_commit.
6101: IF FND_API.To_Boolean( p_commit ) THEN
6102: COMMIT WORK;
6103: END IF;
6104:
6101: IF FND_API.To_Boolean( p_commit ) THEN
6102: COMMIT WORK;
6103: END IF;
6104:
6105: -- Standard call to get message count and if count is 1, get message info.
6106: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
6107: p_count => x_msg_count ,
6108: p_data => x_msg_data);
6109: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
6188: rec_MiniSiteOrg_ShipMethod c_get_MiniSiteOrg_ShipMethod%rowtype;
6189:
6190: begin
6191:
6192: -- Standard Start of API savepoint
6193: SAVEPOINT getHdrDefaultShipMethod_pvt;
6194:
6195: -- Standard call to check for call compatibility.
6196: IF NOT FND_API.Compatible_API_Call(L_API_VERSION,
6191:
6192: -- Standard Start of API savepoint
6193: SAVEPOINT getHdrDefaultShipMethod_pvt;
6194:
6195: -- Standard call to check for call compatibility.
6196: IF NOT FND_API.Compatible_API_Call(L_API_VERSION,
6197: P_Api_Version_Number,
6198: L_API_NAME ,
6199: G_PKG_NAME )
6338:
6339: end if; -- if (l_isDone <> 'Y')
6340:
6341: -- End of API body.
6342: -- Standard check of p_commit.
6343: IF FND_API.To_Boolean( p_commit ) THEN
6344: COMMIT WORK;
6345: END IF;
6346:
6343: IF FND_API.To_Boolean( p_commit ) THEN
6344: COMMIT WORK;
6345: END IF;
6346:
6347: -- Standard call to get message count and if count is 1, get message info.
6348: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
6349: p_count => x_msg_count ,
6350: p_data => x_msg_data);
6351: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
6440: rec_next_payment_type c_get_next_payment_type%rowtype;
6441:
6442: begin
6443:
6444: -- Standard Start of API savepoint
6445: SAVEPOINT getHdrDefPmtMethod_pvt;
6446:
6447: -- Standard call to check for call compatibility.
6448: IF NOT FND_API.Compatible_API_Call(L_API_VERSION,
6443:
6444: -- Standard Start of API savepoint
6445: SAVEPOINT getHdrDefPmtMethod_pvt;
6446:
6447: -- Standard call to check for call compatibility.
6448: IF NOT FND_API.Compatible_API_Call(L_API_VERSION,
6449: P_Api_Version_Number,
6450: L_API_NAME ,
6451: G_PKG_NAME )
6632:
6633: end if; -- if (l_isDone <> 'Y')
6634:
6635: -- End of API body.
6636: -- Standard check of p_commit.
6637: IF FND_API.To_Boolean( p_commit ) THEN
6638: COMMIT WORK;
6639: END IF;
6640:
6637: IF FND_API.To_Boolean( p_commit ) THEN
6638: COMMIT WORK;
6639: END IF;
6640:
6641: -- Standard call to get message count and if count is 1, get message info.
6642: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
6643: p_count => x_msg_count ,
6644: p_data => x_msg_data);
6645: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
6703: rec_tax_rec_exist c_check_tax_rec_exist%rowtype;
6704:
6705: begin
6706:
6707: -- Standard Start of API savepoint
6708: SAVEPOINT getHdrDefTaxExmpt_pvt;
6709:
6710: -- Standard call to check for call compatibility.
6711: IF NOT FND_API.Compatible_API_Call(L_API_VERSION,
6706:
6707: -- Standard Start of API savepoint
6708: SAVEPOINT getHdrDefTaxExmpt_pvt;
6709:
6710: -- Standard call to check for call compatibility.
6711: IF NOT FND_API.Compatible_API_Call(L_API_VERSION,
6712: P_Api_Version_Number,
6713: L_API_NAME ,
6714: G_PKG_NAME )
6758: -- px_hd_Tax_Detail_Tbl(1).quote_shipment_index := 1; // no need
6759: px_hd_Tax_Detail_Tbl(1).tax_exempt_flag := 'S';
6760: end if;
6761:
6762: -- Standard call to get message count and if count is 1, get message info.
6763: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
6764: p_count => x_msg_count ,
6765: p_data => x_msg_data);
6766: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
6826: rec_shipTo_info c_get_shipTo_info%rowtype;
6827:
6828: begin
6829:
6830: -- Standard Start of API savepoint
6831: SAVEPOINT getHdrDefaultEndCustomer_pvt;
6832:
6833: -- Standard call to check for call compatibility.
6834: IF NOT FND_API.Compatible_API_Call(L_API_VERSION,
6829:
6830: -- Standard Start of API savepoint
6831: SAVEPOINT getHdrDefaultEndCustomer_pvt;
6832:
6833: -- Standard call to check for call compatibility.
6834: IF NOT FND_API.Compatible_API_Call(L_API_VERSION,
6835: P_Api_Version_Number,
6836: L_API_NAME ,
6837: G_PKG_NAME )
6900: IBE_Util.Debug('getHdrDefaultEndCustomer: px_qte_header_rec.end_customer_party_site_id ='||px_qte_header_rec.end_customer_party_site_id);
6901: END IF;
6902:
6903: -- End of API body.
6904: -- Standard check of p_commit.
6905: IF FND_API.To_Boolean( p_commit ) THEN
6906: COMMIT WORK;
6907: END IF;
6908:
6905: IF FND_API.To_Boolean( p_commit ) THEN
6906: COMMIT WORK;
6907: END IF;
6908:
6909: -- Standard call to get message count and if count is 1, get message info.
6910: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
6911: p_count => x_msg_count ,
6912: p_data => x_msg_data);
6913: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
6967: l_api_version CONSTANT NUMBER := 1.0;
6968:
6969: BEGIN
6970:
6971: -- Standard Start of API savepoint
6972: SAVEPOINT CREATECONTRACTFORQUOTE_pvt;
6973:
6974: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
6975: IBE_UTIL.DEBUG('REACHED CREATE_CONTRACT_FOR_QUOTE' || to_char(sysdate, 'mm/dd/yyyy:hh24:MI:SS'));
6975: IBE_UTIL.DEBUG('REACHED CREATE_CONTRACT_FOR_QUOTE' || to_char(sysdate, 'mm/dd/yyyy:hh24:MI:SS'));
6976: END IF;
6977:
6978:
6979: -- Standard call to check for call compatibility.
6980: IF NOT FND_API.Compatible_API_Call(l_api_version,
6981: P_Api_Version_Number,
6982: l_api_name ,
6983: G_PKG_NAME )
7110: END IF;
7111:
7112:
7113:
7114: -- Standard call to get message count and if count is 1, get message info.
7115: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
7116: p_count => x_msg_count ,
7117: p_data => x_msg_data);
7118: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
7245: IBE_UTIL.DEBUG('DUPLICATE_CART: p_retrieval_number = '||p_retrieval_number);
7246: IBE_UTIL.DEBUG('DUPLICATE_CART: p_minisite_id = '||p_minisite_id);
7247: END IF;
7248:
7249: -- Standard Start of API savepoint
7250: SAVEPOINT Duplicate_Cart;
7251:
7252: -- Standard call to check for call compatibility.
7253: IF NOT FND_API.Compatible_API_Call(L_API_VERSION,
7248:
7249: -- Standard Start of API savepoint
7250: SAVEPOINT Duplicate_Cart;
7251:
7252: -- Standard call to check for call compatibility.
7253: IF NOT FND_API.Compatible_API_Call(L_API_VERSION,
7254: p_api_version,
7255: L_API_NAME ,
7256: G_PKG_NAME )
7468:
7469: END IF;
7470: x_quote_header_id := lx_quote_header_id;
7471:
7472: -- Standard call to get message count and if count is 1, get message info.
7473: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
7474: p_count => x_msg_count ,
7475: p_data => x_msg_data);
7476: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
7567: lx_Price_Adj_Attr_Tbl ASO_Quote_Pub.Price_Adj_Attr_Tbl_Type;
7568: lx_Price_Adj_Rltship_Tbl ASO_Quote_Pub.Price_Adj_Rltship_Tbl_Type;
7569:
7570: BEGIN
7571: -- Standard Start of API savepoint
7572: SAVEPOINT Reconfigure_From_Ib;
7573:
7574: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
7575: IBE_UTIL.DEBUG('Begin Reconfigure_Form_IB');
7574: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
7575: IBE_UTIL.DEBUG('Begin Reconfigure_Form_IB');
7576: END IF;
7577:
7578: -- Standard call to check for call compatibility.
7579: IF NOT FND_API.Compatible_API_Call(L_API_VERSION,
7580: P_Api_Version_Number,
7581: L_API_NAME ,
7582: G_PKG_NAME )
7734: IBE_UTIL.DEBUG('Ref cursor x_config_line begin');
7735: END IF;
7736: open x_config_line for l_refcursor_query using l_Qte_Header_Rec.quote_header_id;
7737: -- End of API body.
7738: -- Standard check of p_commit.
7739: IF FND_API.To_Boolean( p_commit ) THEN
7740: COMMIT WORK;
7741: END IF;
7742:
7739: IF FND_API.To_Boolean( p_commit ) THEN
7740: COMMIT WORK;
7741: END IF;
7742:
7743: -- Standard call to get message count and if count is 1, get message info.
7744: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
7745: p_count => x_msg_count ,
7746: p_data => x_msg_data);
7747: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
7967: CURSOR c_get_line_qty(p_quote_line_id NUMBER) IS
7968: SELECT quantity FROM aso_quote_lines_all
7969: WHERE quote_line_id = p_quote_line_id;
7970: BEGIN
7971: -- Standard Start of API savepoint
7972: SAVEPOINT UPDATE_SUPPORT_LEVEL_AND_QTY;
7973:
7974: -- Standard initialization tasks
7975: -- Standard call to check for call compatibility.
7970: BEGIN
7971: -- Standard Start of API savepoint
7972: SAVEPOINT UPDATE_SUPPORT_LEVEL_AND_QTY;
7973:
7974: -- Standard initialization tasks
7975: -- Standard call to check for call compatibility.
7976: IF NOT FND_API.Compatible_API_Call (l_api_version,p_api_version,l_api_name,G_PKG_NAME) THEN
7977: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7978: END IF;
7971: -- Standard Start of API savepoint
7972: SAVEPOINT UPDATE_SUPPORT_LEVEL_AND_QTY;
7973:
7974: -- Standard initialization tasks
7975: -- Standard call to check for call compatibility.
7976: IF NOT FND_API.Compatible_API_Call (l_api_version,p_api_version,l_api_name,G_PKG_NAME) THEN
7977: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7978: END IF;
7979: