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_ORDER_SAVE_PVT dependencies on IBE_ORDER_SAVE_PVT

Line 1: PACKAGE BODY IBE_Order_Save_pvt AS

1: PACKAGE BODY IBE_Order_Save_pvt AS
2: /* $Header: IBEVORDB.pls 120.9 2010/09/09 02:00:15 scnagara ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'IBE_Order_Save_pvt';
5: l_true VARCHAR2(1) := FND_API.G_TRUE;

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

1: PACKAGE BODY IBE_Order_Save_pvt AS
2: /* $Header: IBEVORDB.pls 120.9 2010/09/09 02:00:15 scnagara ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'IBE_Order_Save_pvt';
5: l_true VARCHAR2(1) := FND_API.G_TRUE;
6:
7:
8: PROCEDURE Get_Order_Status(p_header_id IN NUMBER

Line 24: Ibe_Util.debug('Begin IBE_ORDER_SAVE_PVT:Get_Order_Status');

20:
21: BEGIN
22:
23: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
24: Ibe_Util.debug('Begin IBE_ORDER_SAVE_PVT:Get_Order_Status');
25: END IF;
26:
27: OPEN c_gethdrstatus(p_header_id);
28: FETCH c_gethdrstatus INTO l_gethdrstatus;

Line 39: Ibe_Util.debug('End IBE_ORDER_SAVE_PVT:Get_Order_Status');

35: END IF;
36: CLOSE c_gethdrstatus;
37:
38: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
39: Ibe_Util.debug('End IBE_ORDER_SAVE_PVT:Get_Order_Status');
40: END IF;
41:
42: END Get_Order_Status;
43:

Line 78: Ibe_Util.debug('Begin IBE_ORDER_SAVE_PVT:Retrieve_OE_Messages');

74:
75: BEGIN
76:
77: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
78: Ibe_Util.debug('Begin IBE_ORDER_SAVE_PVT:Retrieve_OE_Messages');
79: END IF;
80:
81: OE_MSG_PUB.Count_And_Get
82: ( p_count => l_msg_count,

Line 156: Ibe_Util.debug('End IBE_ORDER_SAVE_PVT:Retrieve_OE_Messages');

152: END LOOP;
153: END IF;
154:
155: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
156: Ibe_Util.debug('End IBE_ORDER_SAVE_PVT:Retrieve_OE_Messages');
157: END IF;
158:
159: END Retrieve_OE_Messages;
160:

Line 171: Ibe_Util.debug('Begin IBE_ORDER_SAVE_PVT:Deactivate Order: ' || p_party_id || ' : '||p_cust_account_id);

167:
168: BEGIN
169:
170: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
171: Ibe_Util.debug('Begin IBE_ORDER_SAVE_PVT:Deactivate Order: ' || p_party_id || ' : '||p_cust_account_id);
172: END IF;
173:
174:
175: IBE_ACTIVE_QUOTES_ALL_PKG.Update_row(

Line 188: Ibe_Util.debug('End IBE_ORDER_SAVE_PVT:DeactivateOrder');

184: X_RECORD_TYPE => 'ORDER');
185:
186:
187: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
188: Ibe_Util.debug('End IBE_ORDER_SAVE_PVT:DeactivateOrder');
189: END IF;
190:
191: END DeactivateOrder;
192:

Line 220: Ibe_Util.debug('Begin IBE_ORDER_SAVE_PVT:ActivateOrder');

216:
217: BEGIN
218:
219: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
220: Ibe_Util.debug('Begin IBE_ORDER_SAVE_PVT:ActivateOrder');
221: END IF;
222:
223: open c_check_pr_aqa( p_party_id,p_cust_account_id,p_currency_code);
224: fetch c_check_pr_aqa into rec_check_pr_aqa;

Line 265: Ibe_Util.debug('End IBE_ORDER_SAVE_PVT:ActivateOrder');

261:
262: END IF;
263:
264: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
265: Ibe_Util.debug('End IBE_ORDER_SAVE_PVT:ActivateOrder');
266: END IF;
267:
268: END ActivateOrder;
269:

Line 297: Ibe_Util.debug('Begin IBE_ORDER_SAVE_PVT:DefaultFromLineSiteId');

293:
294: BEGIN
295:
296: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
297: Ibe_Util.debug('Begin IBE_ORDER_SAVE_PVT:DefaultFromLineSiteId');
298: END IF;
299:
300: for lineIdx in 1..p_line_tbl.count
301: loop

Line 335: Ibe_Util.debug('End IBE_ORDER_SAVE_PVT:DefaultFromLineSiteId');

331: end if;
332: x_site_use_id := l_linesite_use_id;
333:
334: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
335: Ibe_Util.debug('End IBE_ORDER_SAVE_PVT:DefaultFromLineSiteId');
336: END IF;
337:
338: END DefaultFromLineSiteId;
339:

Line 358: IBE_Util.Debug('IBE_ORDER_SAVE_PVT:MergeLines - START');

354:
355: BEGIN
356:
357: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
358: IBE_Util.Debug('IBE_ORDER_SAVE_PVT:MergeLines - START');
359: END IF;
360: open c_get_lineInfo(p_order_line_rec.return_attribute2,
361: p_order_line_rec.return_attribute1,
362: p_header_id

Line 385: IBE_Util.Debug('End IBE_ORDER_SAVE_PVT:MergeLines');

381: end if;
382: close c_get_lineInfo;
383:
384: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
385: IBE_Util.Debug('End IBE_ORDER_SAVE_PVT:MergeLines');
386: END IF;
387: END MergeLines;
388:
389:

Line 404: IBE_Util.Debug('BEgin IBE_ORDER_SAVE_PVT:DefaultLineTypes');

400:
401: BEGIN
402:
403: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
404: IBE_Util.Debug('BEgin IBE_ORDER_SAVE_PVT:DefaultLineTypes');
405: END IF;
406: open c_linetypeInfo(p_header_type_id);
407: fetch c_linetypeinfo into l_linetypeinfo;
408: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 415: IBE_Util.Debug('End IBE_ORDER_SAVE_PVT:DefaultLineTypes');

411: x_line_type_id := l_linetypeinfo.DEFAULT_INBOUND_LINE_TYPE_ID;
412: close c_linetypeinfo;
413:
414: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
415: IBE_Util.Debug('End IBE_ORDER_SAVE_PVT:DefaultLineTypes');
416: END IF;
417:
418: END DefaultLineTypes;
419:

Line 451: Ibe_util.Debug('Begin IBE_ORDER_SAVE_PVT: DefaultLineRecord');

447:
448: BEGIN
449:
450: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
451: Ibe_util.Debug('Begin IBE_ORDER_SAVE_PVT: DefaultLineRecord');
452: END IF;
453: For j IN 1..p_order_line_tbl.COUNT
454: Loop
455: l_order_line_tbl(j) := p_order_line_tbl(j);

Line 606: Ibe_util.Debug('End IBE_ORDER_SAVE_PVT:DefaultLineRecord');

602: x_order_line_tbl(k) := l_order_line_tbl(k);
603: End Loop;
604:
605: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
606: Ibe_util.Debug('End IBE_ORDER_SAVE_PVT:DefaultLineRecord');
607: END IF;
608:
609: END DefaultLineRecord;
610:

Line 631: Ibe_util.Debug('Begin IBE_ORDER_SAVE_PVT: GetActiveReturnOrder');

627:
628: BEGIN
629:
630: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
631: Ibe_util.Debug('Begin IBE_ORDER_SAVE_PVT: GetActiveReturnOrder');
632: END IF;
633:
634: OPEN c_getactive_pendret(p_cust_acct_id,
635: p_curr_code,

Line 648: Ibe_util.Debug('End IBE_ORDER_SAVE_PVT: GetActiveReturnOrder');

644:
645: CLOSE c_getactive_pendret;
646:
647: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
648: Ibe_util.Debug('End IBE_ORDER_SAVE_PVT: GetActiveReturnOrder');
649: END IF;
650:
651: END GetActiveReturnOrder;
652:

Line 679: Ibe_util.Debug('Begin IBE_ORDER_SAVE_PVT: DefaultHeaderRecord');

675:
676: BEGIN
677:
678: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
679: Ibe_util.Debug('Begin IBE_ORDER_SAVE_PVT: DefaultHeaderRecord');
680: END IF;
681:
682: x_order_header_rec := p_order_header_rec;
683:

Line 867: Ibe_util.Debug('End IBE_ORDER_SAVE_PVT:DefaultHeaderRecord');

863: null;
864: END IF; --IF ORDER_CATEG_CODE
865:
866: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
867: Ibe_util.Debug('End IBE_ORDER_SAVE_PVT:DefaultHeaderRecord');
868: END IF;
869:
870: END DefaultHeaderRecord;
871:

Line 888: Ibe_util.Debug('Begin IBE_Order_Save_Pvt.CancelOrder');

884:
885: BEGIN
886:
887: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
888: Ibe_util.Debug('Begin IBE_Order_Save_Pvt.CancelOrder');
889: END IF;
890:
891: x_order_header_rec := p_order_header_rec;
892:

Line 921: Ibe_util.Debug('End IBE_ORDER_SAVE_PVT:CancelOrder');

917: END IF;
918:
919:
920: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
921: Ibe_util.Debug('End IBE_ORDER_SAVE_PVT:CancelOrder');
922: END IF;
923:
924: END CancelOrder;
925:

Line 960: Ibe_util.Debug('Begin IBE_ORDER_SAVE_PVT:DefaultHdrLineAddress');

956:
957: BEGIN
958:
959: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
960: Ibe_util.Debug('Begin IBE_ORDER_SAVE_PVT:DefaultHdrLineAddress');
961: end if;
962:
963: -- Initialize API return status to success
964: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1207: Ibe_util.Debug('End IBE_ORDER_SAVE_PVT:DefaultHdrLineAddress');

1203: END IF;
1204: end if;
1205:
1206: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1207: Ibe_util.Debug('End IBE_ORDER_SAVE_PVT:DefaultHdrLineAddress');
1208: END IF;
1209:
1210: FND_MSG_PUB.Count_And_Get
1211: ( p_count => x_msg_count,

Line 1222: IBE_Util.Debug('Error IBE_ORDER_SAVE_PVT:DefaultHdrLineAddress()'|| sqlerrm);

1218: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
1219: p_count => x_msg_count ,
1220: p_data => x_msg_data);
1221: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1222: IBE_Util.Debug('Error IBE_ORDER_SAVE_PVT:DefaultHdrLineAddress()'|| sqlerrm);
1223: END IF;
1224:
1225: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1226: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1231: IBE_Util.Debug('UNEXPError IBE_ORDER_SAVE_PVT:DefaultHdrLineAddress()' || sqlerrm);

1227: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
1228: p_count => x_msg_count ,
1229: p_data => x_msg_data);
1230: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1231: IBE_Util.Debug('UNEXPError IBE_ORDER_SAVE_PVT:DefaultHdrLineAddress()' || sqlerrm);
1232: END IF;
1233:
1234: WHEN OTHERS THEN
1235: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1245: IBE_Util.Debug('Other IBE_ORDER_SAVE_PVT:DefaultHdrLineAddress()' || sqlerrm);

1241: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
1242: p_count => x_msg_count ,
1243: p_data => x_msg_data);
1244: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1245: IBE_Util.Debug('Other IBE_ORDER_SAVE_PVT:DefaultHdrLineAddress()' || sqlerrm);
1246: END IF;
1247:
1248: END DefaultHdrLineAddress;
1249:

Line 1281: IBE_Util.Debug('Begin IBE_ORDER_SAVE_PVT:setlineshipinvoiceids');

1277:
1278: BEGIN
1279:
1280: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1281: IBE_Util.Debug('Begin IBE_ORDER_SAVE_PVT:setlineshipinvoiceids');
1282: IBE_Util.Debug('setlineshipinvoiceids invoicetoorgid: '|| p_order_header_rec.invoice_to_org_id);
1283: END IF;
1284:
1285: for i in 1..p_order_line_tbl.count

Line 1310: IBE_Util.Debug('Begin IBE_ORDER_SAVE_PVT:setlineshipinvoiceids');

1306: -- Uncommenting all the above lines since the bug has been fixed by OM as per Bug# 3336052
1307: -- Prereq for this is ONT.J
1308:
1309: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1310: IBE_Util.Debug('Begin IBE_ORDER_SAVE_PVT:setlineshipinvoiceids');
1311: IBE_Util.Debug('setlineshipinvoiceids invoicetoorgid: '|| p_order_header_rec.invoice_to_org_id);
1312: END IF;
1313:
1314: l_shipto_org_id := p_order_header_rec.ship_to_org_id; --Bug# 3334581

Line 1748: IBE_Util.Debug('Begin IBE_ORDER_SAVE_PVT:CheckOverReturnQty()');

1744:
1745: BEGIN
1746:
1747: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1748: IBE_Util.Debug('Begin IBE_ORDER_SAVE_PVT:CheckOverReturnQty()');
1749: IBE_Util.Debug('Incoming Order Header Id: '|| p_order_header_id);
1750: END IF;
1751:
1752: -- Initialize API return status to success

Line 2030: IBE_Util.Debug('Error IBE_ORDER_SAVE_PVT:CheckOverReturnQty()'|| sqlerrm);

2026: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
2027: p_count => x_msg_count ,
2028: p_data => x_msg_data);
2029: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2030: IBE_Util.Debug('Error IBE_ORDER_SAVE_PVT:CheckOverReturnQty()'|| sqlerrm);
2031: END IF;
2032:
2033: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2034: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2039: IBE_Util.Debug('UNEXPECTEDError IBE_ORDER_SAVE_PVT:CheckOverReturnQty()' || sqlerrm);

2035: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
2036: p_count => x_msg_count ,
2037: p_data => x_msg_data);
2038: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2039: IBE_Util.Debug('UNEXPECTEDError IBE_ORDER_SAVE_PVT:CheckOverReturnQty()' || sqlerrm);
2040: END IF;
2041: WHEN OTHERS THEN
2042: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2043:

Line 2053: IBE_Util.Debug('Other IBE_ORDER_SAVE_PVT:CheckOverReturnQty()' || sqlerrm);

2049: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
2050: p_count => x_msg_count ,
2051: p_data => x_msg_data);
2052: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2053: IBE_Util.Debug('Other IBE_ORDER_SAVE_PVT:CheckOverReturnQty()' || sqlerrm);
2054: END IF;
2055:
2056: END CheckOverReturnQty;
2057:

Line 2086: IBE_Util.debug('IBE_Order_Save_Pvt.TCA_AddressValidate BEGIN order_hdr_id: '||p_order_header_id);

2082:
2083: x_return_status := FND_API.G_RET_STS_SUCCESS;
2084:
2085: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2086: IBE_Util.debug('IBE_Order_Save_Pvt.TCA_AddressValidate BEGIN order_hdr_id: '||p_order_header_id);
2087: end if;
2088:
2089: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2090: IBE_Util.debug('IBE_Order_Save_Pvt.TCA_AddressValidate BEGIN site_use_type : '||p_site_use_type);

Line 2090: IBE_Util.debug('IBE_Order_Save_Pvt.TCA_AddressValidate BEGIN site_use_type : '||p_site_use_type);

2086: IBE_Util.debug('IBE_Order_Save_Pvt.TCA_AddressValidate BEGIN order_hdr_id: '||p_order_header_id);
2087: end if;
2088:
2089: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2090: IBE_Util.debug('IBE_Order_Save_Pvt.TCA_AddressValidate BEGIN site_use_type : '||p_site_use_type);
2091: end if;
2092:
2093:
2094: if(p_user_type = 'PARTY_RELATIONSHIP') then

Line 2237: IBE_Util.debug('IBE_Order_Save_Pvt.TCA_AddressValidate END '||x_return_status);

2233: end loop;
2234: end if;
2235:
2236: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2237: IBE_Util.debug('IBE_Order_Save_Pvt.TCA_AddressValidate END '||x_return_status);
2238: end if;
2239:
2240:
2241: END TCA_AddressValidate;

Line 2270: IBE_Util.debug('IBE_Order_Save_Pvt.TCA_AddressValidate BEGIN');

2266:
2267: x_return_status := FND_API.G_RET_STS_SUCCESS;
2268:
2269: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2270: IBE_Util.debug('IBE_Order_Save_Pvt.TCA_AddressValidate BEGIN');
2271: end if;
2272:
2273: if (p_site_use_type ='BILL_TO') then
2274: l_contact_validate_qry:='SELECT LINES.LINE_ID '||

Line 2342: IBE_Util.debug('IBE_Order_Save_Pvt.TCA_AddressValidate END '||x_return_status);

2338: end if;
2339: end if;
2340:
2341: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2342: IBE_Util.debug('IBE_Order_Save_Pvt.TCA_AddressValidate END '||x_return_status);
2343: end if;
2344:
2345: END TCA_ContactValidate;
2346:

Line 2384: IBE_Util.Debug('Begin IBE_ORDER_SAVE_PVT:Complete_RetLine_Validation()');

2380:
2381: BEGIN
2382:
2383: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2384: IBE_Util.Debug('Begin IBE_ORDER_SAVE_PVT:Complete_RetLine_Validation()');
2385: END IF;
2386:
2387: X_failed_line_ids := JTF_VARCHAR2_TABLE_300();
2388:

Line 2649: Ibe_util.Debug('End IBE_ORDER_SAVE_PVT:Complete_RetOrder_Validate');

2645: raise FND_API.G_EXC_ERROR;
2646: ENd IF;
2647:
2648: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2649: Ibe_util.Debug('End IBE_ORDER_SAVE_PVT:Complete_RetOrder_Validate');
2650: END IF;
2651:
2652: FND_MSG_PUB.Count_And_Get
2653: ( p_count => x_msg_count,

Line 2664: IBE_Util.Debug('Error IBE_ORDER_SAVE_PVT:Complete_RetOrder_Validate()'|| sqlerrm);

2660: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
2661: p_count => x_msg_count ,
2662: p_data => x_msg_data);
2663: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2664: IBE_Util.Debug('Error IBE_ORDER_SAVE_PVT:Complete_RetOrder_Validate()'|| sqlerrm);
2665: END IF;
2666:
2667: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2668: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2673: IBE_Util.Debug('UNEXPError IBE_ORDER_SAVE_PVT:Complete_RetOrder_Validate()' || sqlerrm);

2669: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
2670: p_count => x_msg_count ,
2671: p_data => x_msg_data);
2672: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2673: IBE_Util.Debug('UNEXPError IBE_ORDER_SAVE_PVT:Complete_RetOrder_Validate()' || sqlerrm);
2674: END IF;
2675:
2676: WHEN OTHERS THEN
2677: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2687: IBE_Util.Debug('Other IBE_ORDER_SAVE_PVT:Complete_RetOrder_Validate()' || sqlerrm);

2683: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
2684: p_count => x_msg_count ,
2685: p_data => x_msg_data);
2686: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2687: IBE_Util.Debug('Other IBE_ORDER_SAVE_PVT:Complete_RetOrder_Validate()' || sqlerrm);
2688: END IF;
2689:
2690: END Complete_RetOrder_Validate;
2691:

Line 2794: IBE_Util.Debug('Begin IBE_ORDER_SAVE_PVT:Save(): ' || p_save_type);

2790: /******/
2791: BEGIN
2792:
2793: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2794: IBE_Util.Debug('Begin IBE_ORDER_SAVE_PVT:Save(): ' || p_save_type);
2795: END IF;
2796:
2797:
2798: -- Standard Start of API savepoint

Line 2979: IBE_Util.Debug('ibe_order_save_pvt:cancel_flag ' ||p_submit_control_rec.cancel_flag);

2975:
2976: /************ Hard Delete logic for Pending Return ****/
2977:
2978: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2979: IBE_Util.Debug('ibe_order_save_pvt:cancel_flag ' ||p_submit_control_rec.cancel_flag);
2980: END IF;
2981:
2982: if (p_submit_control_rec.cancel_flag = 'Y') then
2983: CancelOrder(l_order_header_rec,lx_order_header_rec);

Line 3374: IBE_UTIL.debug('IBE_ORDER_SAVE_PVT: Before calling Notification API');

3370:
3371: IF (p_save_type = SAVE_NORMAL AND p_submit_control_rec.submit_flag = 'Y') THEN
3372:
3373: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3374: IBE_UTIL.debug('IBE_ORDER_SAVE_PVT: Before calling Notification API');
3375: END IF;
3376:
3377: IBE_WORKFLOW_PVT.NotifyReturnOrderStatus(
3378: p_api_version => 1,

Line 3388: IBE_UTIL.debug('IBE_ORDER_SAVE_PVT: Notification API is called');

3384: x_msg_count => x_msg_count,
3385: x_msg_data => x_msg_data
3386: );
3387: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3388: IBE_UTIL.debug('IBE_ORDER_SAVE_PVT: Notification API is called');
3389: END IF;
3390:
3391: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3392: RAISE FND_API.G_EXC_ERROR;

Line 3429: IBE_Util.Debug('Error IBE_ORDER_SAVE_PVT:Save()'|| sqlerrm);

3425: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
3426: p_count => x_msg_count ,
3427: p_data => x_msg_data);
3428: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3429: IBE_Util.Debug('Error IBE_ORDER_SAVE_PVT:Save()'|| sqlerrm);
3430: END IF;
3431:
3432: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3433: ROLLBACK TO SAVE_ORDER_SAVE_PVT;

Line 3439: IBE_Util.Debug('UNEXPECTEDError IBE_ORDER_SAVE_PVT:Save()' || sqlerrm);

3435: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
3436: p_count => x_msg_count ,
3437: p_data => x_msg_data);
3438: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3439: IBE_Util.Debug('UNEXPECTEDError IBE_ORDER_SAVE_PVT:Save()' || sqlerrm);
3440: END IF;
3441: WHEN OTHERS THEN
3442: ROLLBACK TO SAVE_ORDER_SAVE_PVT;
3443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3454: IBE_Util.Debug('Other IBE_ORDER_SAVE_PVT:Save()' || sqlerrm);

3450: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
3451: p_count => x_msg_count ,
3452: p_data => x_msg_data);
3453: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3454: IBE_Util.Debug('Other IBE_ORDER_SAVE_PVT:Save()' || sqlerrm);
3455: END IF;
3456:
3457:
3458: END Save;

Line 3556: IBE_Util.Debug('Begin IBE_ORDER_SAVE_PVT:CheckConstraints()');

3552:
3553: x_error_lineids := JTF_VARCHAR2_TABLE_300();
3554:
3555: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3556: IBE_Util.Debug('Begin IBE_ORDER_SAVE_PVT:CheckConstraints()');
3557: END IF;
3558:
3559: -- Standard Start of API savepoint
3560: SAVEPOINT ORDER_CHKCONSTRAINT;

Line 3893: IBE_Util.Debug('Error IBE_ORDER_SAVE_PVT:CHECKCONSTRAINT()'|| sqlerrm);

3889: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
3890: p_count => x_msg_count ,
3891: p_data => x_msg_data);
3892: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3893: IBE_Util.Debug('Error IBE_ORDER_SAVE_PVT:CHECKCONSTRAINT()'|| sqlerrm);
3894: END IF;
3895:
3896: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3897: ROLLBACK TO ORDER_CHKCONSTRAINT;

Line 3903: IBE_Util.Debug('UNEXPECTEDError IBE_ORDER_SAVE_PVT:CHECKCONSTRAINT()' || sqlerrm);

3899: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
3900: p_count => x_msg_count ,
3901: p_data => x_msg_data);
3902: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3903: IBE_Util.Debug('UNEXPECTEDError IBE_ORDER_SAVE_PVT:CHECKCONSTRAINT()' || sqlerrm);
3904: END IF;
3905:
3906: WHEN OTHERS THEN
3907: ROLLBACK TO ORDER_CHKCONSTRAINT;

Line 3918: IBE_Util.Debug('Other IBE_ORDER_SAVE_PVT:CHECKCONSTRAINT()' || sqlerrm);

3914: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
3915: p_count => x_msg_count ,
3916: p_data => x_msg_data);
3917: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3918: IBE_Util.Debug('Other IBE_ORDER_SAVE_PVT:CHECKCONSTRAINT()' || sqlerrm);
3919: END IF;
3920:
3921: END CheckConstraint;
3922:

Line 3986: IBE_Util.Debug('Begin IBE_ORDER_SAVE_PVT:UpdateLinebilling()');

3982:
3983: BEGIN
3984:
3985: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3986: IBE_Util.Debug('Begin IBE_ORDER_SAVE_PVT:UpdateLinebilling()');
3987: END IF;
3988:
3989: -- Standard Start of API savepoint
3990: SAVEPOINT ORDER_UPDTLINEBILL;

Line 4281: IBE_Util.Debug('End IBE_ORDER_SAVE_PVT:UpdateLinebilling()');

4277: COMMIT WORK;
4278: END IF;
4279:
4280: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
4281: IBE_Util.Debug('End IBE_ORDER_SAVE_PVT:UpdateLinebilling()');
4282: END IF;
4283:
4284: -- Standard call to get message count and if count is 1, get message info.
4285: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

Line 4296: IBE_Util.Debug('Error IBE_ORDER_SAVE_PVT:UpdateLineShippingBilling()'|| sqlerrm);

4292: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
4293: p_count => x_msg_count ,
4294: p_data => x_msg_data);
4295: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
4296: IBE_Util.Debug('Error IBE_ORDER_SAVE_PVT:UpdateLineShippingBilling()'|| sqlerrm);
4297: END IF;
4298:
4299: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4300: ROLLBACK TO ORDER_UPDTLINEBILL;

Line 4306: IBE_Util.Debug('UNEXPECTEDErr IBE_ORDER_SAVE_PVT:UpdateLineShippingBilling()' || sqlerrm);

4302: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
4303: p_count => x_msg_count ,
4304: p_data => x_msg_data);
4305: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
4306: IBE_Util.Debug('UNEXPECTEDErr IBE_ORDER_SAVE_PVT:UpdateLineShippingBilling()' || sqlerrm);
4307: END IF;
4308:
4309: WHEN OTHERS THEN
4310: ROLLBACK TO ORDER_UPDTLINEBILL;

Line 4321: IBE_Util.Debug('OtherExc IBE_ORDER_SAVE_PVT:UpdateLineShippingBilling()' || sqlerrm);

4317: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
4318: p_count => x_msg_count ,
4319: p_data => x_msg_data);
4320: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
4321: IBE_Util.Debug('OtherExc IBE_ORDER_SAVE_PVT:UpdateLineShippingBilling()' || sqlerrm);
4322: END IF;
4323:
4324: END UpdateLineShippingBilling;
4325:

Line 4326: END IBE_Order_Save_pvt;

4322: END IF;
4323:
4324: END UpdateLineShippingBilling;
4325:
4326: END IBE_Order_Save_pvt;