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.IBE_ORD_ONECLICK_PVT dependencies on IBE_ORD_ONECLICK

Line 1: PACKAGE BODY ibe_ord_oneclick_pvt AS

1: PACKAGE BODY ibe_ord_oneclick_pvt AS
2: /* $Header: IBEVO1CB.pls 120.12.12020000.2 2012/08/14 06:35:35 amaheshw 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.12.12020000.2 2012/08/14 06:35:35 amaheshw 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 16: - retrives the foreign keys from IBE_ORD_ONECLICK

12: ) RETURN VARCHAR2;*/
13: /*-----------------------------------------------------------------------------
14:
15: Get_Settings
16: - retrives the foreign keys from IBE_ORD_ONECLICK
17: - retrives user's main email address associated with partyid in HZ_PARTIES
18: - validates the address usage via calls to IBE_ADDRESS_V2PVT.valid_usages
19:
20: Key Input: party id and account id

Line 61: FROM IBE_ORD_ONECLICK

57: payment_id,
58: bill_to_pty_site_id,
59: ship_to_pty_site_id,
60: last_update_date
61: FROM IBE_ORD_ONECLICK
62: WHERE
63: party_id = c_party_id and
64: cust_account_id = c_acct_id;
65:

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 282: update IBE_ORD_ONECLICK

278: ibe_util.debug('x_BILL_PTYSITE_ID :'||x_BILL_PTYSITE_ID);
279: ibe_util.debug('x_SHIP_PTYSITE_ID :'||x_SHIP_PTYSITE_ID);
280: END IF;
281:
282: update IBE_ORD_ONECLICK
283: set enabled_flag = x_ENABLED_FLAG,
284: bill_to_pty_site_id = x_BILL_PTYSITE_ID,
285: ship_to_pty_site_id = x_SHIP_PTYSITE_ID,
286: object_version_number = x_OBJECT_VERSION_NUMBER + 1,

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 364: - inserts/updates foreign keys into IBE_ORD_ONECLICK

360:
361: /*-----------------------------------------------------------------------------
362:
363: Save_Settings
364: - inserts/updates foreign keys into IBE_ORD_ONECLICK
365: - no longer saves user's email address associated with IBE_ORD_ONECLICK
366: - assumes address validation was done at the java layer before calling this api
367:
368: ------------------------------------------------------------------------------

Line 365: - no longer saves user's email address associated with IBE_ORD_ONECLICK

361: /*-----------------------------------------------------------------------------
362:
363: Save_Settings
364: - inserts/updates foreign keys into IBE_ORD_ONECLICK
365: - no longer saves user's email address associated with IBE_ORD_ONECLICK
366: - assumes address validation was done at the java layer before calling this api
367:
368: ------------------------------------------------------------------------------
369: */

Line 396: from IBE_ORD_ONECLICK

392: l_oneclick_id NUMBER := FND_API.g_miss_num;
393:
394: CURSOR c_oneclick_row(c_party_id NUMBER, c_acct_id NUMBER) IS
395: SELECT ord_oneclick_id
396: from IBE_ORD_ONECLICK
397: where party_id = c_party_id and cust_account_id = c_acct_id;
398:
399: begin
400: -- ibe_util.enable_debug;

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 440: insert into IBE_ORD_ONECLICK_ALL (

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,
443: party_id,
444: cust_account_id,

Line 456: IBE_ORD_ONECLICK_S1.NEXTVAL,

452: creation_date,
453: last_updated_by,
454: last_update_date)
455: values (1,
456: IBE_ORD_ONECLICK_S1.NEXTVAL,
457: p_party_id,
458: p_acct_id,
459: p_ENABLED_FLAG,
460: p_FREIGHT_CODE,

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 477: update IBE_ORD_ONECLICK

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,
480: enabled_flag = p_ENABLED_FLAG,
481: freight_code = p_FREIGHT_CODE,

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 915: 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');

911: 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));
912: END IF;
913: IF x_return_status <> FND_API.g_ret_sts_success THEN
914: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
915: 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');
916: END IF;
917: FND_MESSAGE.SET_TOKEN ( '0' , 'Express_Buy_Order - IBE_Quote_Save_pvt.SAVE' );
918: FND_MESSAGE.SET_TOKEN ( '1' , x_return_status );
919: FND_MSG_PUB.Add;

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

925: ELSE
926: IF(l_attach_contract = FND_API.G_TRUE) THEN
927: 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)
928: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
929: ibe_util.debug('ibe_ord_oneclick_pvt.Express_Buy_Order - : No contract currently attached !');
930: END IF;
931: IF (FND_Profile.Value('OKC_ENABLE_SALES_CONTRACTS') = 'Y' ) THEN --Only if contracts is enabled
932: --instantiate a contract and associate to the quote
933: /*mannamra: changes for MOAC: Bug 4682364 */

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

963: END IF; --If contract template id is not null
964: END IF; --IF (FND_Profile.Value('OKC_ENABLE_SALES_CONTRACTS')
965: ELSE
966: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
967: ibe_util.debug('ibe_ord_oneclick_pvt.Express_Buy_Order - : A contract is already instanciated for this quote');
968: END IF;
969: END IF; -- Whether there is a contract currently instanciated for this quote
970: END IF; --If l_attach_contract is true
971: END IF; -- If l_return_status is success

Line 1045: 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');

1041: END IF;
1042:
1043: IF x_return_status <> FND_API.g_ret_sts_success THEN
1044: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1045: 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');
1046: END IF;
1047: FND_MESSAGE.SET_TOKEN ( '0' , 'Express_Buy_Order - IBE_Shop_List_PVT.Save_Quote_From_Lists' );
1048: FND_MESSAGE.SET_TOKEN ( '1' , x_return_status );
1049: FND_MSG_PUB.Add;

Line 1095: 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');

1091: END IF;
1092:
1093: if x_return_status <> FND_API.g_ret_sts_success then
1094: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1095: 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');
1096: END IF;
1097: FND_MESSAGE.SET_NAME('IBE','IBE_EXPR_PLSQL_API_ERROR');
1098: FND_MESSAGE.SET_TOKEN ( '0' , 'Express_Buy_Order - IBE_Shop_List_PVT.Save_Quote_From_List_Items' );
1099: FND_MESSAGE.SET_TOKEN ( '1' , x_return_status );

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

1123: --ibe_util.disable_debug;
1124: EXCEPTION
1125: WHEN FND_API.G_EXC_ERROR THEN
1126: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1127: ibe_util.debug('ibe_ord_oneclick_pvt.Express_Buy_Order: EXPECTED ERROR EXCEPTION ' || to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS'));
1128: END IF;
1129: ROLLBACK TO Express_Buy_Order_Pvt;
1130: x_return_status := FND_API.G_RET_STS_ERROR;
1131: x_last_update_date := IBE_Quote_Misc_pvt.getQuoteLastUpdateDate(p_cart_id);

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

1136: );
1137: --ibe_util.disable_debug;
1138: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1139: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1140: ibe_util.debug('ibe_ord_oneclick_pvt.Express_Buy_Order: UNEXPECTED ERROR EXCEPTION ' || to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS'));
1141: END IF;
1142: ROLLBACK TO Express_Buy_Order_Pvt;
1143: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1144: FND_MSG_PUB.Count_And_Get

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

1148: );
1149: --ibe_util.disable_debug;
1150: WHEN OTHERS THEN
1151: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1152: ibe_util.debug('ibe_ord_oneclick_pvt.Express_Buy_Order: OTHER EXCEPTION ' || to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS'));
1153: END IF;
1154: ROLLBACK TO Express_Buy_Order_Pvt;
1155: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1156: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 1199: FROM IBE_ORD_ONECLICK

1195: bill_to_pty_site_id,
1196: ship_to_pty_site_id,
1197: last_update_date
1198:
1199: FROM IBE_ORD_ONECLICK
1200: WHERE party_id = c_party_id
1201: and cust_account_id = c_acct_id;
1202:
1203: CURSOR c_quote_date(c_qte_header_id NUMBER) IS

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

1284:
1285: --Begin API body
1286:
1287: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1288: ibe_util.debug('Starting ibe_ord_oneclick_pvt.Get_express_items_settings ');
1289: ibe_util.debug('PROCESSING FLAG : ' || p_flag);
1290: END IF;
1291:
1292: l_qte_header_rec := x_qte_header_rec;

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

1379: ibe_util.debug('Back from IBE_Quote_Save_pvt.SAVE for pushing out' );
1380: END IF;
1381: if lx_return_status <> FND_API.g_ret_sts_success then
1382: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1383: ibe_util.debug('ibe_ord_oneclick_pvt.Express_Buy_Order - non success status from IBE_Quote_Save_pvt.SAVE: ' || lx_return_status);
1384: END IF;
1385: FND_MESSAGE.SET_NAME('IBE','IBE_EXPR_PLSQL_API_ERROR');
1386: FND_MESSAGE.SET_TOKEN ( '0' , 'Get_Express_Items_Settings - IBE_Quote_Save_pvt.SAVE for nonconsolidation' );
1387: FND_MESSAGE.SET_TOKEN ( '1' , lx_return_status );

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

1398: l_curr_cart_date := FND_API.g_miss_date;
1399: else
1400: --settings have'nt changed so we should consolidate incoming items to the open express-checkout cart
1401: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1402: ibe_util.debug('ibe_ord_oneclick_pvt.Get_express_items_settings-Consolidating to: '||l_curr_cart_id);
1403: END IF;
1404: l_qte_header_rec.quote_header_id := l_curr_cart_id;
1405: end if; -- end pushing out of old cart
1406: end if; -- end checking if we can consolidate

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

1487: END IF;
1488: end if;
1489: CLOSE c_bank_acct;*/
1490:
1491: --l_credit_card_name := IBE_ORD_ONECLICK_PVT.Get_credit_card_Type(l_credit_card_num);
1492: /* If Credit Card name is ERROR raise appropriate exception */
1493: /*If l_credit_card_name = 'ERROR' Then
1494: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1495: ibe_util.debug('Invalid Credit Card');

Line 1645: from ibe_ord_oneclick

1641: IS
1642:
1643: select ord_oneclick_id, object_version_number, enabled_flag, freight_code,
1644: payment_id, bill_to_pty_site_id, ship_to_pty_site_id
1645: from ibe_ord_oneclick
1646: where party_id = c_party_id and cust_account_id = c_acct_id;
1647:
1648: Begin
1649:

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

1652: -- Initialize API rturn status to success
1653: x_return_status := FND_API.g_ret_sts_success;
1654:
1655: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1656: ibe_util.debug('------- Input to ibe_ord_oneclick_pvt.Update_Settings: -----------------');
1657: ibe_util.debug('p_party_id :'||p_party_id);
1658: ibe_util.debug('p_acct_id :'||p_acct_id);
1659: ibe_util.debug('p_assignment_id :'||p_assignment_id);
1660: END IF;

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

1692: l_payment_id := '';
1693:
1694: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1695: ibe_util.debug('Update_Settings : Deleted CC is the one selected for Express checkout');
1696: ibe_util.debug('Update_Settings : Disabling the Express checkout - Calling ibe_ord_oneclick_pvt.save_settings');
1697: END IF;
1698:
1699: ibe_ord_oneclick_pvt.save_settings(
1700: p_api_version => l_api_version,

Line 1699: ibe_ord_oneclick_pvt.save_settings(

1695: ibe_util.debug('Update_Settings : Deleted CC is the one selected for Express checkout');
1696: ibe_util.debug('Update_Settings : Disabling the Express checkout - Calling ibe_ord_oneclick_pvt.save_settings');
1697: END IF;
1698:
1699: ibe_ord_oneclick_pvt.save_settings(
1700: p_api_version => l_api_version,
1701: p_init_msg_list => FND_API.G_FALSE,
1702: p_commit => p_commit,
1703: x_return_status => x_return_status,

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

1713: p_ship_ptysite_id => l_ship_ptysite_id
1714: );
1715:
1716: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1717: ibe_util.debug('Update_Settings : After Calling ibe_ord_oneclick_pvt.save_settings');
1718: ibe_util.debug('Update_Settings : x_return_status - '||x_return_status);
1719: END IF;
1720:
1721: IF x_return_status <> FND_API.g_ret_sts_success THEN

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

1719: END IF;
1720:
1721: IF x_return_status <> FND_API.g_ret_sts_success THEN
1722: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1723: ibe_util.debug('ibe_ord_oneclick_pvt.Update_Settings - call to ibe_ord_oneclick_pvt.save_settings failed' || x_return_status);
1724: END IF;
1725: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1726: RAISE FND_API.G_EXC_ERROR;
1727: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

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

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

1765: );
1766:
1767: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1768: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1769: ibe_util.debug('ibe_ord_oneclick_pvt.Update_Settings: UNEXPECTED ERROR EXCEPTION ' || to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS'));
1770: END IF;
1771: ROLLBACK TO Update_Settings;
1772: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1773: FND_MSG_PUB.Count_And_Get

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

1777: );
1778:
1779: WHEN OTHERS THEN
1780: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1781: ibe_util.debug('ibe_ord_oneclick_pvt.Update_Settings: OTHER EXCEPTION ' || to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS'));
1782: END IF;
1783: ROLLBACK TO Update_Settings;
1784: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1785: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 1798: end ibe_ord_oneclick_pvt;

1794: p_data => x_msg_data
1795: );
1796:
1797: End Update_Settings;
1798: end ibe_ord_oneclick_pvt;