DBA Data[Home] [Help]

APPS.IBE_ORD_ONECLICK_PVT dependencies on IBE_ORD_ONECLICK_PVT

Line 1: PACKAGE BODY ibe_ord_oneclick_pvt AS

1: PACKAGE BODY ibe_ord_oneclick_pvt AS
2: /* $Header: IBEVO1CB.pls 120.10 2006/06/20 19:59:39 apilpre ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ibe_ord_oneclick_pvt';
5: l_true VARCHAR2(1) := FND_API.G_TRUE;

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ibe_ord_oneclick_pvt';

1: PACKAGE BODY ibe_ord_oneclick_pvt AS
2: /* $Header: IBEVO1CB.pls 120.10 2006/06/20 19:59:39 apilpre ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ibe_ord_oneclick_pvt';
5: l_true VARCHAR2(1) := FND_API.G_TRUE;
6:
7: /* Local function to Get Credit Card Type Given The Number
8: hekkiral - 21-DEC-2000 */

Line 86: ibe_util.debug('Starting ibe_ord_oneclick_pvt.Get_Settings ' || to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS'));

82:
83: begin
84: --ibe_util.enable_debug;
85: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
86: ibe_util.debug('Starting ibe_ord_oneclick_pvt.Get_Settings ' || to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS'));
87: END IF;
88: SAVEPOINT Get_Settings_Pvt;
89: -- Standard call to check for call compatibility.
90: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

Line 124: ibe_util.debug('ibe_ord_oneclick_pvt.Get_Settings - IBY_PAYMENT_INT_PVT.check_Payment_channel_setups ' || x_return_status);

120: ,x_msg_data => x_msg_data);
121:
122: if x_return_status <> FND_API.g_ret_sts_success then
123: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
124: ibe_util.debug('ibe_ord_oneclick_pvt.Get_Settings - IBY_PAYMENT_INT_PVT.check_Payment_channel_setups ' || x_return_status);
125: END IF;
126: if x_return_status = FND_API.G_RET_STS_ERROR then
127: RAISE FND_API.G_EXC_ERROR;
128: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

Line 207: ibe_util.debug('ibe_ord_oneclick_pvt.Get_Settings - non success status from IBE_ADDRESS_V2PVT.valid_usages: ' || x_return_status);

203: END IF;
204:
205: if x_return_status <> FND_API.g_ret_sts_success then
206: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
207: ibe_util.debug('ibe_ord_oneclick_pvt.Get_Settings - non success status from IBE_ADDRESS_V2PVT.valid_usages: ' || x_return_status);
208: END IF;
209: FND_MESSAGE.SET_NAME('IBE','IBE_EXPR_PLSQL_API_ERROR');
210: FND_MESSAGE.SET_TOKEN ( '0' , 'Get_Settings - IBE_ADDRESS_V2PVT.valid_usages' );
211: FND_MESSAGE.SET_TOKEN ( '1' , x_return_status );

Line 253: ibe_util.debug('ibe_ord_oneclick_pvt.Get_Settings - non success status from IBE_ADDRESS_V2PVT.valid_usages: ' || x_return_status);

249: END IF;
250:
251: if x_return_status <> FND_API.g_ret_sts_success then
252: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
253: ibe_util.debug('ibe_ord_oneclick_pvt.Get_Settings - non success status from IBE_ADDRESS_V2PVT.valid_usages: ' || x_return_status);
254: END IF;
255: FND_MESSAGE.SET_NAME('IBE','IBE_EXPR_PLSQL_API_ERROR');
256: FND_MESSAGE.SET_TOKEN ( '0' , 'Get_Settings - IBE_ADDRESS_V2PVT.valid_usages' );
257: FND_MESSAGE.SET_TOKEN ( '1' , x_return_status );

Line 302: ibe_util.debug('Done with ibe_ord_oneclick_pvt.Get_Settings ' || to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS'));

298:
299: end if ; --if l_cvv2_setup
300:
301: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
302: ibe_util.debug('Done with ibe_ord_oneclick_pvt.Get_Settings ' || to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS'));
303: END IF;
304:
305: IF FND_API.To_Boolean( p_commit ) THEN
306: COMMIT WORK;

Line 318: ibe_util.debug('ibe_ord_oneclick_pvt.Get_Settings: EXPECTED ERROR EXCEPTION ' || to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS'));

314:
315: EXCEPTION
316: WHEN FND_API.G_EXC_ERROR THEN
317: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
318: ibe_util.debug('ibe_ord_oneclick_pvt.Get_Settings: EXPECTED ERROR EXCEPTION ' || to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS'));
319: END IF;
320: ROLLBACK TO Get_Settings_Pvt;
321: x_return_status := FND_API.G_RET_STS_ERROR ;
322: FND_MSG_PUB.Count_And_Get

Line 330: ibe_util.debug('ibe_ord_oneclick_pvt.Get_Settings: UNEXPECTED ERROR EXCEPTION ' || to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS'));

326: );
327: --ibe_util.disable_debug;
328: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
329: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
330: ibe_util.debug('ibe_ord_oneclick_pvt.Get_Settings: UNEXPECTED ERROR EXCEPTION ' || to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS'));
331: END IF;
332: ROLLBACK TO Get_Settings_Pvt;
333: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
334: FND_MSG_PUB.Count_And_Get

Line 342: ibe_util.debug('ibe_ord_oneclick_pvt.Get_Settings: OTHER EXCEPTION ' || to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS'));

338: );
339: --ibe_util.disable_debug;
340: WHEN OTHERS THEN
341: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
342: ibe_util.debug('ibe_ord_oneclick_pvt.Get_Settings: OTHER EXCEPTION ' || to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS'));
343: END IF;
344: ROLLBACK TO Get_Settings_Pvt;
345: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
346: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 402: ibe_util.debug('Starting ibe_ord_oneclick_pvt.Save_Settings ' || to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS'));

398:
399: begin
400: -- ibe_util.enable_debug;
401: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
402: ibe_util.debug('Starting ibe_ord_oneclick_pvt.Save_Settings ' || to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS'));
403: END IF;
404: SAVEPOINT Save_Settings_Pvt;
405: -- Standard call to check for call compatibility.
406: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

Line 438: ibe_util.debug('ibe_ord_oneclick_pvt.Save_Settings - inserting new row');

434: fetch c_oneclick_row into l_oneclick_id;
435:
436: if c_oneclick_row%NOTFOUND then
437: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
438: ibe_util.debug('ibe_ord_oneclick_pvt.Save_Settings - inserting new row');
439: END IF;
440: insert into IBE_ORD_ONECLICK_ALL (
441: object_version_number,
442: ord_oneclick_id,

Line 471: ibe_util.debug('ibe_ord_oneclick_pvt.Save_Settings - new ord_oneclick_id: ' || to_char(l_oneclick_id));

467: FND_GLOBAL.user_id,
468: SYSDATE)
469: returning ord_oneclick_id into l_oneclick_id;
470: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
471: ibe_util.debug('ibe_ord_oneclick_pvt.Save_Settings - new ord_oneclick_id: ' || to_char(l_oneclick_id));
472: END IF;
473: else
474: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
475: ibe_util.debug('ibe_ord_oneclick_pvt.Save_Settings - updating row');

Line 475: ibe_util.debug('ibe_ord_oneclick_pvt.Save_Settings - updating row');

471: ibe_util.debug('ibe_ord_oneclick_pvt.Save_Settings - new ord_oneclick_id: ' || to_char(l_oneclick_id));
472: END IF;
473: else
474: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
475: ibe_util.debug('ibe_ord_oneclick_pvt.Save_Settings - updating row');
476: END IF;
477: update IBE_ORD_ONECLICK
478: set
479: object_version_number = p_OBJECT_VERSION_NUMBER + 1,

Line 502: ibe_util.debug('Done with ibe_ord_oneclick_pvt.Save_Settings ' || to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS'));

498: end if;
499: close c_oneclick_row;
500:
501: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
502: ibe_util.debug('Done with ibe_ord_oneclick_pvt.Save_Settings ' || to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS'));
503: END IF;
504: IF FND_API.To_Boolean( p_commit ) THEN
505: COMMIT WORK;
506: END IF;

Line 517: ibe_util.debug('ibe_ord_oneclick_pvt.Save_Settings: EXPECTED ERROR EXCEPTION ' || to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS'));

513: --ibe_util.disable_debug;
514: EXCEPTION
515: WHEN FND_API.G_EXC_ERROR THEN
516: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
517: ibe_util.debug('ibe_ord_oneclick_pvt.Save_Settings: EXPECTED ERROR EXCEPTION ' || to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS'));
518: END IF;
519: ROLLBACK TO Save_Settings_Pvt;
520: x_return_status := FND_API.G_RET_STS_ERROR ;
521: FND_MSG_PUB.Count_And_Get

Line 529: ibe_util.debug('ibe_ord_oneclick_pvt.Save_Settings: UNEXPECTED ERROR EXCEPTION ' || to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS'));

525: );
526: --ibe_util.disable_debug;
527: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
528: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
529: ibe_util.debug('ibe_ord_oneclick_pvt.Save_Settings: UNEXPECTED ERROR EXCEPTION ' || to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS'));
530: END IF;
531: ROLLBACK TO Save_Settings_Pvt;
532: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
533: FND_MSG_PUB.Count_And_Get

Line 541: ibe_util.debug('ibe_ord_oneclick_pvt.Save_Settings: OTHER EXCEPTION ' || to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS'));

537: );
538: --ibe_util.disable_debug;
539: WHEN OTHERS THEN
540: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
541: ibe_util.debug('ibe_ord_oneclick_pvt.Save_Settings: OTHER EXCEPTION ' || to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS'));
542: END IF;
543: ROLLBACK TO Save_Settings_Pvt;
544: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
545: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 690: ibe_util.debug('Starting ibe_ord_oneclick_pvt.Express_Buy_Order ' || to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS'));

686:
687: BEGIN
688: --ibe_util.enable_debug;
689: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
690: ibe_util.debug('Starting ibe_ord_oneclick_pvt.Express_Buy_Order ' || to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS'));
691: ibe_util.debug('PROCESSING FLAG : ' || p_flag);
692: END IF;
693: SAVEPOINT Express_Buy_Order_Pvt;
694: -- Standard call to check for call compatibility.

Line 755: ibe_util.debug('Starting ibe_ord_oneclick_pvt.Get_Express_items_settings ' );

751:
752: END IF; -- IF(p_flag = 'CART') THEN
753:
754: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
755: ibe_util.debug('Starting ibe_ord_oneclick_pvt.Get_Express_items_settings ' );
756: ibe_util.debug('Input Cartid: '||p_cart_id);
757: ibe_util.debug('Input Partyid: '||p_party_id);
758: ibe_util.debug('Input Accountid: '||p_acct_id);
759: ibe_util.debug('Input p_flag: '||p_flag);

Line 763: IBE_ORD_ONECLICK_PVT.Get_Express_items_settings(

759: ibe_util.debug('Input p_flag: '||p_flag);
760: ibe_util.debug('Input p_last_update_date: '||p_last_update_date);
761: END IF;
762:
763: IBE_ORD_ONECLICK_PVT.Get_Express_items_settings(
764: x_qte_header_rec => l_qte_header_rec
765: ,p_flag => p_flag
766: ,x_payment_tbl => l_hd_payment_tbl
767: ,x_hd_shipment_tbl => l_hd_shipment_tbl

Line 908: ibe_util.debug('ibe_ord_oneclick_pvt.Express_Buy_Order - non success status from IBE_Quote_Save_pvt.SAVE: ' || x_return_status); FND_MESSAGE.SET_NAME('IBE','IBE_EXPR_PLSQL_API_ERROR');

904: ibe_util.debug('Back from IBE_Quote_Save_pvt.SAVE ' || to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS') || ' quote_header_id: ' || to_char(lx_quote_header_id));
905: END IF;
906: IF x_return_status <> FND_API.g_ret_sts_success THEN
907: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
908: ibe_util.debug('ibe_ord_oneclick_pvt.Express_Buy_Order - non success status from IBE_Quote_Save_pvt.SAVE: ' || x_return_status); FND_MESSAGE.SET_NAME('IBE','IBE_EXPR_PLSQL_API_ERROR');
909: END IF;
910: FND_MESSAGE.SET_TOKEN ( '0' , 'Express_Buy_Order - IBE_Quote_Save_pvt.SAVE' );
911: FND_MESSAGE.SET_TOKEN ( '1' , x_return_status );
912: FND_MSG_PUB.Add;

Line 922: ibe_util.debug('ibe_ord_oneclick_pvt.Express_Buy_Order - : No contract currently attached !');

918: ELSE
919: IF(l_attach_contract = FND_API.G_TRUE) THEN
920: IF (OKC_TERMS_UTIL_GRP.Get_Terms_Template('QUOTE', p_cart_id) IS NULL) THEN -- Checking whether a contract has already been attached (Bug 5260372)
921: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
922: ibe_util.debug('ibe_ord_oneclick_pvt.Express_Buy_Order - : No contract currently attached !');
923: END IF;
924: IF (FND_Profile.Value('OKC_ENABLE_SALES_CONTRACTS') = 'Y' ) THEN --Only if contracts is enabled
925: --instantiate a contract and associate to the quote
926: /*mannamra: changes for MOAC: Bug 4682364 */

Line 960: ibe_util.debug('ibe_ord_oneclick_pvt.Express_Buy_Order - : A contract is already instanciated for this quote');

956: END IF; --If contract template id is not null
957: END IF; --IF (FND_Profile.Value('OKC_ENABLE_SALES_CONTRACTS')
958: ELSE
959: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
960: ibe_util.debug('ibe_ord_oneclick_pvt.Express_Buy_Order - : A contract is already instanciated for this quote');
961: END IF;
962: END IF; -- Whether there is a contract currently instanciated for this quote
963: END IF; --If l_attach_contract is true
964: END IF; -- If l_return_status is success

Line 1038: ibe_util.debug('ibe_ord_oneclick_pvt.Express_Buy_Order - non success status from IBE_Shop_List_PVT.Save_Quote_From_Lists: ' || x_return_status); FND_MESSAGE.SET_NAME('IBE','IBE_EXPR_PLSQL_API_ERROR');

1034: END IF;
1035:
1036: IF x_return_status <> FND_API.g_ret_sts_success THEN
1037: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1038: ibe_util.debug('ibe_ord_oneclick_pvt.Express_Buy_Order - non success status from IBE_Shop_List_PVT.Save_Quote_From_Lists: ' || x_return_status); FND_MESSAGE.SET_NAME('IBE','IBE_EXPR_PLSQL_API_ERROR');
1039: END IF;
1040: FND_MESSAGE.SET_TOKEN ( '0' , 'Express_Buy_Order - IBE_Shop_List_PVT.Save_Quote_From_Lists' );
1041: FND_MESSAGE.SET_TOKEN ( '1' , x_return_status );
1042: FND_MSG_PUB.Add;

Line 1088: ibe_util.debug('ibe_ord_oneclick_pvt.Express_Buy_Order - non success status from IBE_Shop_List_PVT.Save_Quote_From_List_Items: ' || x_return_status); FND_MESSAGE.SET_NAME('IBE','IBE_EXPR_PLSQL_API_ERROR');

1084: END IF;
1085:
1086: if x_return_status <> FND_API.g_ret_sts_success then
1087: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1088: ibe_util.debug('ibe_ord_oneclick_pvt.Express_Buy_Order - non success status from IBE_Shop_List_PVT.Save_Quote_From_List_Items: ' || x_return_status); FND_MESSAGE.SET_NAME('IBE','IBE_EXPR_PLSQL_API_ERROR');
1089: END IF;
1090: FND_MESSAGE.SET_NAME('IBE','IBE_EXPR_PLSQL_API_ERROR');
1091: FND_MESSAGE.SET_TOKEN ( '0' , 'Express_Buy_Order - IBE_Shop_List_PVT.Save_Quote_From_List_Items' );
1092: FND_MESSAGE.SET_TOKEN ( '1' , x_return_status );

Line 1120: ibe_util.debug('ibe_ord_oneclick_pvt.Express_Buy_Order: EXPECTED ERROR EXCEPTION ' || to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS'));

1116: --ibe_util.disable_debug;
1117: EXCEPTION
1118: WHEN FND_API.G_EXC_ERROR THEN
1119: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1120: ibe_util.debug('ibe_ord_oneclick_pvt.Express_Buy_Order: EXPECTED ERROR EXCEPTION ' || to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS'));
1121: END IF;
1122: ROLLBACK TO Express_Buy_Order_Pvt;
1123: x_return_status := FND_API.G_RET_STS_ERROR;
1124: x_last_update_date := IBE_Quote_Misc_pvt.getQuoteLastUpdateDate(p_cart_id);

Line 1133: ibe_util.debug('ibe_ord_oneclick_pvt.Express_Buy_Order: UNEXPECTED ERROR EXCEPTION ' || to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS'));

1129: );
1130: --ibe_util.disable_debug;
1131: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1132: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1133: ibe_util.debug('ibe_ord_oneclick_pvt.Express_Buy_Order: UNEXPECTED ERROR EXCEPTION ' || to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS'));
1134: END IF;
1135: ROLLBACK TO Express_Buy_Order_Pvt;
1136: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1137: FND_MSG_PUB.Count_And_Get

Line 1145: ibe_util.debug('ibe_ord_oneclick_pvt.Express_Buy_Order: OTHER EXCEPTION ' || to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS'));

1141: );
1142: --ibe_util.disable_debug;
1143: WHEN OTHERS THEN
1144: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1145: ibe_util.debug('ibe_ord_oneclick_pvt.Express_Buy_Order: OTHER EXCEPTION ' || to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS'));
1146: END IF;
1147: ROLLBACK TO Express_Buy_Order_Pvt;
1148: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1149: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 1281: ibe_util.debug('Starting ibe_ord_oneclick_pvt.Get_express_items_settings ');

1277:
1278: --Begin API body
1279:
1280: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1281: ibe_util.debug('Starting ibe_ord_oneclick_pvt.Get_express_items_settings ');
1282: ibe_util.debug('PROCESSING FLAG : ' || p_flag);
1283: END IF;
1284:
1285: l_qte_header_rec := x_qte_header_rec;

Line 1376: ibe_util.debug('ibe_ord_oneclick_pvt.Express_Buy_Order - non success status from IBE_Quote_Save_pvt.SAVE: ' || lx_return_status);

1372: ibe_util.debug('Back from IBE_Quote_Save_pvt.SAVE for pushing out' );
1373: END IF;
1374: if lx_return_status <> FND_API.g_ret_sts_success then
1375: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1376: ibe_util.debug('ibe_ord_oneclick_pvt.Express_Buy_Order - non success status from IBE_Quote_Save_pvt.SAVE: ' || lx_return_status);
1377: END IF;
1378: FND_MESSAGE.SET_NAME('IBE','IBE_EXPR_PLSQL_API_ERROR');
1379: FND_MESSAGE.SET_TOKEN ( '0' , 'Get_Express_Items_Settings - IBE_Quote_Save_pvt.SAVE for nonconsolidation' );
1380: FND_MESSAGE.SET_TOKEN ( '1' , lx_return_status );

Line 1395: ibe_util.debug('ibe_ord_oneclick_pvt.Get_express_items_settings-Consolidating to: '||l_curr_cart_id);

1391: l_curr_cart_date := FND_API.g_miss_date;
1392: else
1393: --settings have'nt changed so we should consolidate incoming items to the open express-checkout cart
1394: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1395: ibe_util.debug('ibe_ord_oneclick_pvt.Get_express_items_settings-Consolidating to: '||l_curr_cart_id);
1396: END IF;
1397: l_qte_header_rec.quote_header_id := l_curr_cart_id;
1398: end if; -- end pushing out of old cart
1399: end if; -- end checking if we can consolidate

Line 1484: --l_credit_card_name := IBE_ORD_ONECLICK_PVT.Get_credit_card_Type(l_credit_card_num);

1480: END IF;
1481: end if;
1482: CLOSE c_bank_acct;*/
1483:
1484: --l_credit_card_name := IBE_ORD_ONECLICK_PVT.Get_credit_card_Type(l_credit_card_num);
1485: /* If Credit Card name is ERROR raise appropriate exception */
1486: /*If l_credit_card_name = 'ERROR' Then
1487: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1488: ibe_util.debug('Invalid Credit Card');

Line 1646: ibe_util.debug('------- Input to ibe_ord_oneclick_pvt.Update_Settings: -----------------');

1642:
1643: SAVEPOINT Update_Settings;
1644:
1645: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1646: ibe_util.debug('------- Input to ibe_ord_oneclick_pvt.Update_Settings: -----------------');
1647: ibe_util.debug('p_party_id :'||p_party_id);
1648: ibe_util.debug('p_acct_id :'||p_acct_id);
1649: ibe_util.debug('p_assignment_id :'||p_assignment_id);
1650: END IF;

Line 1686: ibe_util.debug('Update_Settings : Disabling the Express checkout - Calling ibe_ord_oneclick_pvt.save_settings');

1682: l_payment_id := '';
1683:
1684: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1685: ibe_util.debug('Update_Settings : Deleted CC is the one selected for Express checkout');
1686: ibe_util.debug('Update_Settings : Disabling the Express checkout - Calling ibe_ord_oneclick_pvt.save_settings');
1687: END IF;
1688:
1689: ibe_ord_oneclick_pvt.save_settings(
1690: p_api_version => l_api_version,

Line 1689: ibe_ord_oneclick_pvt.save_settings(

1685: ibe_util.debug('Update_Settings : Deleted CC is the one selected for Express checkout');
1686: ibe_util.debug('Update_Settings : Disabling the Express checkout - Calling ibe_ord_oneclick_pvt.save_settings');
1687: END IF;
1688:
1689: ibe_ord_oneclick_pvt.save_settings(
1690: p_api_version => l_api_version,
1691: p_init_msg_list => FND_API.G_FALSE,
1692: p_commit => p_commit,
1693: x_return_status => x_return_status,

Line 1707: ibe_util.debug('Update_Settings : After Calling ibe_ord_oneclick_pvt.save_settings');

1703: p_ship_ptysite_id => l_ship_ptysite_id
1704: );
1705:
1706: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1707: ibe_util.debug('Update_Settings : After Calling ibe_ord_oneclick_pvt.save_settings');
1708: ibe_util.debug('Update_Settings : x_return_status - '||x_return_status);
1709: END IF;
1710:
1711: IF x_return_status <> FND_API.g_ret_sts_success THEN

Line 1713: ibe_util.debug('ibe_ord_oneclick_pvt.Update_Settings - call to ibe_ord_oneclick_pvt.save_settings failed' || x_return_status);

1709: END IF;
1710:
1711: IF x_return_status <> FND_API.g_ret_sts_success THEN
1712: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1713: ibe_util.debug('ibe_ord_oneclick_pvt.Update_Settings - call to ibe_ord_oneclick_pvt.save_settings failed' || x_return_status);
1714: END IF;
1715: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1716: RAISE FND_API.G_EXC_ERROR;
1717: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1747: ibe_util.debug('ibe_ord_oneclick_pvt.Update_Settings: EXPECTED ERROR EXCEPTION ' || to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS'));

1743:
1744: EXCEPTION
1745: WHEN FND_API.G_EXC_ERROR THEN
1746: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1747: ibe_util.debug('ibe_ord_oneclick_pvt.Update_Settings: EXPECTED ERROR EXCEPTION ' || to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS'));
1748: END IF;
1749: ROLLBACK TO Update_Settings;
1750: x_return_status := FND_API.G_RET_STS_ERROR ;
1751: FND_MSG_PUB.Count_And_Get

Line 1759: ibe_util.debug('ibe_ord_oneclick_pvt.Update_Settings: UNEXPECTED ERROR EXCEPTION ' || to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS'));

1755: );
1756:
1757: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1758: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1759: ibe_util.debug('ibe_ord_oneclick_pvt.Update_Settings: UNEXPECTED ERROR EXCEPTION ' || to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS'));
1760: END IF;
1761: ROLLBACK TO Update_Settings;
1762: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1763: FND_MSG_PUB.Count_And_Get

Line 1771: ibe_util.debug('ibe_ord_oneclick_pvt.Update_Settings: OTHER EXCEPTION ' || to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS'));

1767: );
1768:
1769: WHEN OTHERS THEN
1770: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1771: ibe_util.debug('ibe_ord_oneclick_pvt.Update_Settings: OTHER EXCEPTION ' || to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS'));
1772: END IF;
1773: ROLLBACK TO Update_Settings;
1774: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1775: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 1788: end ibe_ord_oneclick_pvt;

1784: p_data => x_msg_data
1785: );
1786:
1787: End Update_Settings;
1788: end ibe_ord_oneclick_pvt;