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.OE_SALES_CAN_UTIL dependencies on OE_DEBUG_PUB

Line 49: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

45: l_return_status VARCHAR2(1);
46: l_line_rec OE_Order_PUB.Line_Rec_Type;
47:
48: --
49: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
50: --
51: Begin
52:
53: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 56: oe_debug_pub.add( 'ENTERING OE_SALES_CAN_UTIL.UPDATE_LINE' ) ;

52:
53: x_return_status := FND_API.G_RET_STS_SUCCESS;
54:
55: IF l_debug_level > 0 THEN
56: oe_debug_pub.add( 'ENTERING OE_SALES_CAN_UTIL.UPDATE_LINE' ) ;
57: END IF;
58:
59: -- Set control flags.
60:

Line 76: oe_debug_pub.add( 'BEFORE CALLING LOCK ROW' ) ;

72:
73: -- Read line from cache
74:
75: IF l_debug_level > 0 THEN
76: oe_debug_pub.add( 'BEFORE CALLING LOCK ROW' ) ;
77: END IF;
78:
79: /* Fix for Bug 1763178. Passing line record instead of table. */
80:

Line 88: oe_debug_pub.add( 'AFTER CALLING LOCK ROW' ) ;

84: ,x_return_status => l_return_status
85: );
86:
87: IF l_debug_level > 0 THEN
88: oe_debug_pub.add( 'AFTER CALLING LOCK ROW' ) ;
89: END IF;
90:
91: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
92: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 118: oe_debug_pub.add( 'BEFORE CALLING PROCESS ORDER' ) ;

114: -- Call OE_Order_PVT.Process_order
115: g_ser_cascade := TRUE;
116:
117: IF l_debug_level > 0 THEN
118: oe_debug_pub.add( 'BEFORE CALLING PROCESS ORDER' ) ;
119: END IF;
120:
121: oe_order_pvt.Lines
122: ( p_validation_level => FND_API.G_VALID_LEVEL_NONE

Line 136: oe_debug_pub.add( 'AFTER CALLING PROCESS ORDER' ) ;

132: RAISE FND_API.G_EXC_ERROR;
133: END IF;
134:
135: IF l_debug_level > 0 THEN
136: oe_debug_pub.add( 'AFTER CALLING PROCESS ORDER' ) ;
137: END IF;
138:
139: /* jolin start comment out nocopy for notification project
140:

Line 151: oe_debug_pub.ADD('Update Line Process Order return UNEXP_ERROR');

147: , p_old_line_tbl => l_old_line_tbl
148: );
149:
150: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
151: oe_debug_pub.ADD('Update Line Process Order return UNEXP_ERROR');
152: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
153: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
154: oe_debug_pub.ADD('Update Line Process Order return RET_STS_ERROR');
155: RAISE FND_API.G_EXC_ERROR;

Line 154: oe_debug_pub.ADD('Update Line Process Order return RET_STS_ERROR');

150: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
151: oe_debug_pub.ADD('Update Line Process Order return UNEXP_ERROR');
152: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
153: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
154: oe_debug_pub.ADD('Update Line Process Order return RET_STS_ERROR');
155: RAISE FND_API.G_EXC_ERROR;
156: END IF;
157: jolin end */
158:

Line 162: oe_debug_pub.add( 'EXITING OE_SALES_CAN_UTIL.UPDATE_LINE' ) ;

158:
159: g_ser_cascade := FALSE;
160:
161: IF l_debug_level > 0 THEN
162: oe_debug_pub.add( 'EXITING OE_SALES_CAN_UTIL.UPDATE_LINE' ) ;
163: END IF;
164:
165: EXCEPTION
166: WHEN FND_API.G_EXC_ERROR THEN

Line 180: oe_debug_pub.add( 'UNEXPECTED ERROR IN ' || G_PKG_NAME || ':' || L_API_NAME ) ;

176: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
177: WHEN OTHERS THEN
178: g_ser_cascade := FALSE;
179: IF l_debug_level > 0 THEN
180: oe_debug_pub.add( 'UNEXPECTED ERROR IN ' || G_PKG_NAME || ':' || L_API_NAME ) ;
181: END IF;
182: IF oe_msg_pub.Check_MSg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
183: oe_msg_pub.Add_Exc_Msg
184: (G_PKG_NAME

Line 242: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

238:
239: l_require_reason BOOLEAN;
240:
241: --
242: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
243: --
244: BEGIN
245:
246: -- bug2743789 if cancellation is defined at entered level and audit parameter

Line 251: OE_DEBUG_PUB.add('Entering perform_line_change() with reason required flag : '||OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG,1);

247: -- defined at booked orders only, then cancel history record would be inserted
248: -- without reason code.
249:
250: IF l_debug_level > 0 THEN
251: OE_DEBUG_PUB.add('Entering perform_line_change() with reason required flag : '||OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG,1);
252: END IF;
253:
254: l_order_quantity_uom := p_line_rec.order_quantity_uom; --bug 5702849
255: oe_debug_pub.add('5702849: Value of l_order_quantity_uom :'||l_order_quantity_uom);

Line 255: oe_debug_pub.add('5702849: Value of l_order_quantity_uom :'||l_order_quantity_uom);

251: OE_DEBUG_PUB.add('Entering perform_line_change() with reason required flag : '||OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG,1);
252: END IF;
253:
254: l_order_quantity_uom := p_line_rec.order_quantity_uom; --bug 5702849
255: oe_debug_pub.add('5702849: Value of l_order_quantity_uom :'||l_order_quantity_uom);
256:
257: IF (p_line_rec.operation <> oe_globals.g_opr_create AND
258: p_line_rec.split_action_code <> 'SPLIT') THEN
259:

Line 261: oe_debug_pub.add('Entering oe_sales_can_util.perform_line_change' ) ;

257: IF (p_line_rec.operation <> oe_globals.g_opr_create AND
258: p_line_rec.split_action_code <> 'SPLIT') THEN
259:
260: IF l_debug_level > 0 THEN
261: oe_debug_pub.add('Entering oe_sales_can_util.perform_line_change' ) ;
262: END IF;
263:
264: x_return_status := FND_API.G_RET_STS_SUCCESS;
265:

Line 305: oe_debug_pub.add('Before calling update_service()',1) ;

301: */
302: l_require_reason := oe_sales_can_util.g_require_reason;
303:
304: IF l_debug_level > 0 THEN
305: oe_debug_pub.add('Before calling update_service()',1) ;
306: END IF;
307:
308: update_service(p_line_rec, p_old_line_rec, x_return_status);
309:

Line 311: oe_debug_pub.add('After calling update_service , return status : '||x_return_status,1) ;

307:
308: update_service(p_line_rec, p_old_line_rec, x_return_status);
309:
310: IF l_debug_level > 0 THEN
311: oe_debug_pub.add('After calling update_service , return status : '||x_return_status,1) ;
312: END IF;
313:
314: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
315: if x_return_status = FND_API.G_RET_STS_ERROR then

Line 349: oe_debug_pub.add('Qty reduced on internal order',1);

345:
346: IF p_line_rec.source_document_type_id = 10 THEN
347: IF (nvl(p_line_rec.ordered_quantity,0) < nvl(p_old_line_rec.ordered_quantity,0)) THEN
348: IF l_debug_level > 0 THEN
349: oe_debug_pub.add('Qty reduced on internal order',1);
350: END IF;
351:
352: po_supply_id := p_line_rec.source_document_line_id;
353: po_header_id := p_line_rec.source_document_id; --Bug 5335066

Line 359: oe_debug_pub.add( 'SUPPLY ID EXISTS , BEFORE CALLING PO_SUPPLY.PO_REQ_SUPPLY ( ) ' ) ;

355:
356: IF po_supply_id IS NOT NULL THEN
357:
358: IF l_debug_level > 0 THEN
359: oe_debug_pub.add( 'SUPPLY ID EXISTS , BEFORE CALLING PO_SUPPLY.PO_REQ_SUPPLY ( ) ' ) ;
360: END IF;
361: -- INVCONV no requirement to change this
362:
363: IF p_line_rec.split_from_line_id IS NOT NULL THEN -- 6710187 start

Line 403: oe_debug_pub.add('After calling po_supply.po_req_supply()',1);

399: p_ordered_uom => l_order_quantity_uom);
400: --p_reservation_action added for bug4277603
401:
402: IF l_debug_level > 0 THEN
403: oe_debug_pub.add('After calling po_supply.po_req_supply()',1);
404: END IF;
405:
406: END IF;
407:

Line 421: OE_DEBUG_PUB.add('Audit Trail Reason Required Flag : '||OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG,1);

417: /* IR ISO Change Management project End */
418:
419:
420: IF l_debug_level > 0 THEN
421: OE_DEBUG_PUB.add('Audit Trail Reason Required Flag : '||OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG,1);
422: oe_debug_pub.add('Line change reason : '||p_line_rec.change_reason,1);
423: END IF;
424:
425: -- #2743789 changes

Line 422: oe_debug_pub.add('Line change reason : '||p_line_rec.change_reason,1);

418:
419:
420: IF l_debug_level > 0 THEN
421: OE_DEBUG_PUB.add('Audit Trail Reason Required Flag : '||OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG,1);
422: oe_debug_pub.add('Line change reason : '||p_line_rec.change_reason,1);
423: END IF;
424:
425: -- #2743789 changes
426: IF oe_sales_can_util.G_REQUIRE_REASON THEN

Line 429: oe_debug_pub.add('Change reason required',1);

425: -- #2743789 changes
426: IF oe_sales_can_util.G_REQUIRE_REASON THEN
427:
428: IF l_debug_level > 0 THEN
429: oe_debug_pub.add('Change reason required',1);
430: END IF;
431:
432: --Commented out hre following block of code for bug #3665150
433: /* IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110508' THEN -- reinstated for 2653505

Line 439: oe_debug_pub.add('Cancellation Reason is Not Provided',1);

435: IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG <> 'N' THEN
436: IF p_line_rec.change_reason IS NULL OR
437: p_line_rec.change_reason = FND_API.G_MISS_CHAR THEN
438: IF l_debug_level > 0 THEN
439: oe_debug_pub.add('Cancellation Reason is Not Provided',1);
440: END IF;
441: fnd_message.set_name('ONT','OE_CAN_REASON_NOT');
442: oe_msg_pub.add;
443: raise FND_API.G_EXC_ERROR;

Line 451: oe_debug_pub.add('Cancellation Reason is Not Provided',1);

447: ELSE.*/
448: IF p_line_rec.change_reason IS NULL OR
449: p_line_rec.change_reason = FND_API.G_MISS_CHAR THEN
450: IF l_debug_level > 0 THEN
451: oe_debug_pub.add('Cancellation Reason is Not Provided',1);
452: END IF;
453: fnd_message.set_name('ONT','OE_CAN_REASON_NOT');
454: oe_msg_pub.add;
455: raise FND_API.G_EXC_ERROR;

Line 463: oe_debug_pub.add('Before calling record line history',5);

459:
460: IF p_line_rec.change_reason IS NOT NULL AND p_line_rec.change_reason <> FND_API.G_MISS_CHAR THEN
461:
462: IF l_debug_level > 0 THEN
463: oe_debug_pub.add('Before calling record line history',5);
464: END IF;
465:
466: --11.5.10 Versioning/Audit Trail updates
467: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' THEN

Line 500: oe_debug_pub.add('After calling record line history',5);

496: END IF;
497: END IF;
498:
499: IF l_debug_level > 0 THEN
500: oe_debug_pub.add('After calling record line history',5);
501: END IF;
502:
503: END IF;
504:

Line 512: oe_debug_pub.add( 'JPN: IT IS A OTA LINE' , 1 ) ;

508: l_is_ota_line := OE_OTA_UTIL.Is_OTA_Line(l_order_quantity_uom);
509:
510: If (l_is_ota_line) THEN
511: IF l_debug_level > 0 THEN
512: oe_debug_pub.add( 'JPN: IT IS A OTA LINE' , 1 ) ;
513: END IF;
514:
515: IF p_line_rec.ordered_quantity = 0 THEN
516: IF l_debug_level > 0 THEN

Line 517: oe_debug_pub.add( 'JPN: BEFORE CALLING NOTIFY_OTA' , 1 ) ;

513: END IF;
514:
515: IF p_line_rec.ordered_quantity = 0 THEN
516: IF l_debug_level > 0 THEN
517: oe_debug_pub.add( 'JPN: BEFORE CALLING NOTIFY_OTA' , 1 ) ;
518: END IF;
519:
520: oe_ota_util.Notify_OTA(
521: p_line_id => p_line_rec.line_id,

Line 528: oe_debug_pub.add( 'JPN: AFTER CALLING NOTIFY_OTA' , 1 ) ;

524: p_daemon_type => 'C',
525: x_return_status => l_return_status);
526:
527: IF l_debug_level > 0 THEN
528: oe_debug_pub.add( 'JPN: AFTER CALLING NOTIFY_OTA' , 1 ) ;
529: END IF;
530:
531: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
532: if l_return_status = FND_API.G_RET_STS_ERROR then

Line 541: oe_debug_pub.add( 'JPN: NOT A OTA LINE' , 1 ) ;

537: end if;
538: end if;
539:
540: IF l_debug_level > 0 THEN
541: oe_debug_pub.add( 'JPN: NOT A OTA LINE' , 1 ) ;
542: END IF;
543: end if;
544:
545: -- Call to Remove from fullfillment sets

Line 556: oe_debug_pub.add( 'BEFORE CALLING OE_LINE_FULLFILL.CANCEL_LINE ( ) ' ) ;

552: -- added the following IF condition to fix bug 2230777
553: -- using OE_OE_FORM_CANCEL_LINE.g_ord_lvl_can for bug# 2922468
554: if NOT(OE_OE_FORM_CANCEL_LINE.g_ord_lvl_can) and NOT(g_par_ord_lvl_can)then
555: IF l_debug_level > 0 THEN
556: oe_debug_pub.add( 'BEFORE CALLING OE_LINE_FULLFILL.CANCEL_LINE ( ) ' ) ;
557: END IF;
558:
559: oe_line_fullfill.cancel_line(p_line_id => p_line_rec.line_id,
560: x_return_status => l_return_status);

Line 586: OE_DEBUG_PUB.ADD('Calling Wf Handle Error ');

582: If p_line_rec.ordered_quantity = 0 then
583: wf_engine.abortprocess(OE_Globals.G_WFI_LIN
584: ,to_char(p_line_rec.line_id)
585: ,l_line_process_name);
586: OE_DEBUG_PUB.ADD('Calling Wf Handle Error ');
587: Using Retry option to run close activity
588: OE_GLOBALS.G_RECURSION_MODE := 'Y';
589: wf_engine.handleerror(OE_Globals.G_WFI_LIN
590: ,to_char(p_line_rec.line_id)

Line 593: OE_DEBUG_PUB.ADD('After Calling Wf Handle Error ');

589: wf_engine.handleerror(OE_Globals.G_WFI_LIN
590: ,to_char(p_line_rec.line_id)
591: ,'CLOSE_LINE',
592: 'RETRY','CANCEL');
593: OE_DEBUG_PUB.ADD('After Calling Wf Handle Error ');
594: NULL;
595: OE_GLOBALS.G_RECURSION_MODE := 'N';
596: end if;
597: */

Line 607: oe_debug_pub.add( 'BEFORE CALLING RELEASE HOLDS' ) ;

603: l_order_tbl(1).line_id := p_line_rec.line_id;
604: l_release_reason_code := 'OM_CANCEL';
605:
606: IF l_debug_level > 0 THEN
607: oe_debug_pub.add( 'BEFORE CALLING RELEASE HOLDS' ) ;
608: END IF;
609:
610: OE_Holds_pub.release_holds(
611: p_order_tbl => l_order_tbl,

Line 620: oe_debug_pub.add( 'AFTER CALLING RELEASE HOLDS :' || L_RETURN_STATUS ) ;

616: x_msg_count => l_msg_count,
617: x_msg_data => l_msg_data);
618:
619: IF l_debug_level > 0 THEN
620: oe_debug_pub.add( 'AFTER CALLING RELEASE HOLDS :' || L_RETURN_STATUS ) ;
621: END IF;
622:
623: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
624: if l_return_status = FND_API.G_RET_STS_ERROR then

Line 652: oe_debug_pub.add( 'EXITING OE_SALES_CAN_UTIL.PERFORM_LINE_CHANGE' ) ;

648:
649: End if;
650:
651: IF l_debug_level > 0 THEN
652: oe_debug_pub.add( 'EXITING OE_SALES_CAN_UTIL.PERFORM_LINE_CHANGE' ) ;
653: END IF;
654:
655: EXCEPTION
656: WHEN FND_API.G_EXC_ERROR THEN

Line 667: oe_debug_pub.add( 'UNEXPECTED ERROR IN ' || G_PKG_NAME || ':' || 'PERFORM_LINE_CHANGE' ) ;

663: END IF;
664: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
665: WHEN OTHERS THEN
666: IF l_debug_level > 0 THEN
667: oe_debug_pub.add( 'UNEXPECTED ERROR IN ' || G_PKG_NAME || ':' || 'PERFORM_LINE_CHANGE' ) ;
668: END IF;
669: IF oe_msg_pub.Check_MSg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
670: oe_msg_pub.Add_Exc_Msg
671: (G_PKG_NAME

Line 693: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

689: l_api_name VARCHAR2(30):= 'Check_Constraints';
690:
691: l_item_rec OE_ORDER_CACHE.item_rec_type; -- INVCONV
692: --
693: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
694: --
695: BEGIN
696: -- x_line_Rec := p_line_Rec;
697: IF (p_x_line_rec.operation <> oe_globals.g_opr_create AND

Line 702: oe_debug_pub.add( 'ENTERING OE_SALES_CAN_UTIL.CHECK_CONSTRAINTS' ) ;

698: nvl(p_x_line_rec.split_action_code,'X') <> 'SPLIT') THEN
699: -- OE_SALES_CAN_UTIL.G_REQUIRE_REASON := FALSE;
700:
701: IF l_debug_level > 0 THEN
702: oe_debug_pub.add( 'ENTERING OE_SALES_CAN_UTIL.CHECK_CONSTRAINTS' ) ;
703: END IF;
704: -- initialize API return status to success
705: l_return_status := FND_API.G_RET_STS_SUCCESS;
706:

Line 708: oe_debug_pub.add( 'CHECKING CONSTRAINTS FOR LINE ID '|| TO_CHAR ( P_X_LINE_REC.LINE_ID ) ) ;

704: -- initialize API return status to success
705: l_return_status := FND_API.G_RET_STS_SUCCESS;
706:
707: IF l_debug_level > 0 THEN
708: oe_debug_pub.add( 'CHECKING CONSTRAINTS FOR LINE ID '|| TO_CHAR ( P_X_LINE_REC.LINE_ID ) ) ;
709: END IF;
710:
711: if ( p_old_line_rec.cancelled_flag = 'Y') then
712: fnd_message.set_name('ONT', 'OE_CANCEL_NOTHING');

Line 771: oe_debug_pub.add(' Get dual uom - tracking in P and S ');

767: IF oe_line_util.dual_uom_control -- INVCONV Process_Characteristics
768: (p_x_line_rec.inventory_item_id,p_X_line_rec.ship_from_org_id,l_item_rec) THEN
769: IF l_item_rec.tracking_quantity_ind = 'PS' THEN -- INVCONV
770: if l_debug_level > 0 then
771: oe_debug_pub.add(' Get dual uom - tracking in P and S ');
772: end if;
773:
774:
775: IF l_debug_level > 0 THEN

Line 776: oe_debug_pub.add( 'BEFORE CALLING CAL_CANCELLED_QTY2' ) ;

772: end if;
773:
774:
775: IF l_debug_level > 0 THEN
776: oe_debug_pub.add( 'BEFORE CALLING CAL_CANCELLED_QTY2' ) ;
777: END IF;
778:
779: p_x_line_rec.cancelled_quantity2 :=oe_sales_can_util.Cal_cancelled_qty2(
780: p_x_line_rec,

Line 784: oe_debug_pub.add( 'CANCELLED QUANTITY2 IS '||P_X_LINE_REC.CANCELLED_QUANTITY2 ) ;

780: p_x_line_rec,
781: p_old_line_rec);
782:
783: IF l_debug_level > 0 THEN
784: oe_debug_pub.add( 'CANCELLED QUANTITY2 IS '||P_X_LINE_REC.CANCELLED_QUANTITY2 ) ;
785: END IF;
786:
787: END IF; -- IF l_item_rec.tracking_quantity_ind = 'PS'
788:

Line 795: oe_debug_pub.add( 'IN CHANGE REASON REQUIRED' ) ;

791: IF OE_SALES_CAN_UTIL.G_REQUIRE_REASON THEN
792:
793:
794: IF l_debug_level > 0 THEN
795: oe_debug_pub.add( 'IN CHANGE REASON REQUIRED' ) ;
796: END IF;
797:
798: IF p_x_line_rec.change_reason IS NULL THEN
799: /*fnd_message.set_name('ONT','OE_CAN_REASON_NOT');

Line 805: oe_debug_pub.add( 'BEFORE CALLING CAL_CANCELLED_QTY' ) ;

801: NULL;
802: END IF;
803:
804: IF l_debug_level > 0 THEN
805: oe_debug_pub.add( 'BEFORE CALLING CAL_CANCELLED_QTY' ) ;
806: END IF;
807:
808: p_x_line_rec.cancelled_quantity :=oe_sales_can_util.Cal_cancelled_qty(
809: p_x_line_rec,

Line 813: oe_debug_pub.add( 'CANCELLED QUANTITY IS '||P_X_LINE_REC.CANCELLED_QUANTITY ) ;

809: p_x_line_rec,
810: p_old_line_rec);
811:
812: IF l_debug_level > 0 THEN
813: oe_debug_pub.add( 'CANCELLED QUANTITY IS '||P_X_LINE_REC.CANCELLED_QUANTITY ) ;
814: END IF;
815:
816:
817:

Line 853: oe_debug_pub.add( 'CHECKING ORIGINAL CANCELLED_QUANTITY' ) ;

849:
850: -- bug 3542477, must calculate cancelled quantity in case user
851: -- reverts their selection
852: IF l_debug_level > 0 THEN
853: oe_debug_pub.add( 'CHECKING ORIGINAL CANCELLED_QUANTITY' ) ;
854: END IF;
855:
856: p_x_line_rec.cancelled_quantity :=oe_sales_can_util.Cal_cancelled_qty(
857: p_x_line_rec,

Line 866: oe_debug_pub.add(' Get dual uom - tracking in P and S ');

862: IF oe_line_util.dual_uom_control -- INVCONV Process_Characteristics
863: (p_x_line_rec.inventory_item_id,p_X_line_rec.ship_from_org_id,l_item_rec) THEN
864: IF l_item_rec.tracking_quantity_ind = 'PS' THEN -- INVCONV
865: if l_debug_level > 0 then
866: oe_debug_pub.add(' Get dual uom - tracking in P and S ');
867: end if;
868:
869:
870: IF l_debug_level > 0 THEN

Line 871: oe_debug_pub.add( 'BEFORE CALLING CAL_CANCELLED_QTY2' ) ;

867: end if;
868:
869:
870: IF l_debug_level > 0 THEN
871: oe_debug_pub.add( 'BEFORE CALLING CAL_CANCELLED_QTY2' ) ;
872: END IF;
873:
874: p_x_line_rec.cancelled_quantity2 :=oe_sales_can_util.Cal_cancelled_qty2(
875: p_x_line_rec,

Line 879: oe_debug_pub.add( 'CANCELLED QUANTITY2 IS '||P_X_LINE_REC.CANCELLED_QUANTITY2 ) ;

875: p_x_line_rec,
876: p_old_line_rec);
877:
878: IF l_debug_level > 0 THEN
879: oe_debug_pub.add( 'CANCELLED QUANTITY2 IS '||P_X_LINE_REC.CANCELLED_QUANTITY2 ) ;
880: END IF;
881:
882: END IF; -- IF l_item_rec.tracking_quantity_ind = 'PS'
883:

Line 893: oe_debug_pub.add( 'EXITING OE_SALES_CAN_UTIL.CHECK_CONSTRAINTS' ) ;

889:
890: END IF;
891:
892: IF l_debug_level > 0 THEN
893: oe_debug_pub.add( 'EXITING OE_SALES_CAN_UTIL.CHECK_CONSTRAINTS' ) ;
894: END IF;
895:
896: END IF;
897:

Line 910: oe_debug_pub.add( 'UNEXPECTED ERROR IN ' || G_PKG_NAME || ':' || L_API_NAME ) ;

906: END IF;
907: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
908: WHEN OTHERS THEN
909: IF l_debug_level > 0 THEN
910: oe_debug_pub.add( 'UNEXPECTED ERROR IN ' || G_PKG_NAME || ':' || L_API_NAME ) ;
911: END IF;
912: IF oe_msg_pub.Check_MSg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
913: oe_msg_pub.Add_Exc_Msg
914: (G_PKG_NAME

Line 948: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

944: AND service_reference_type_code = 'ORDER' -- these two conditions added for bug 2946327
945: AND nvl(cancelled_flag, 'N') <> 'Y';
946:
947: --
948: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
949: --
950: BEGIN
951:
952: IF l_debug_level > 0 THEN

Line 953: oe_debug_pub.add( 'ENTERING OE_SALES_CAN_UTIL.UPDATE_SERVICE' ) ;

949: --
950: BEGIN
951:
952: IF l_debug_level > 0 THEN
953: oe_debug_pub.add( 'ENTERING OE_SALES_CAN_UTIL.UPDATE_SERVICE' ) ;
954: END IF;
955:
956: for Serrec in get_service loop
957: l_line_id := serrec.line_id;

Line 966: oe_debug_pub.add( 'BEFORE CALLING UPDATELINE FOR LINE ID: '|| L_LINE_ID ) ;

962: l_change_reason := p_line_rec.change_reason;
963: l_change_comments := p_line_rec.change_comments;
964:
965: IF l_debug_level > 0 THEN
966: oe_debug_pub.add( 'BEFORE CALLING UPDATELINE FOR LINE ID: '|| L_LINE_ID ) ;
967: END IF;
968:
969: /* Call the UpdateLine only if ordered_quantity is greater than zero */
970: IF( l_service_quantity <> 0 )then

Line 981: oe_debug_pub.add( 'AFTER CALLING UPDATELINE , RETURN STATUS: '|| L_RETURN_STATUS ) ;

977: x_msg_data);
978: END IF;
979:
980: IF l_debug_level > 0 THEN
981: oe_debug_pub.add( 'AFTER CALLING UPDATELINE , RETURN STATUS: '|| L_RETURN_STATUS ) ;
982: END IF;
983:
984: end loop;
985:

Line 995: oe_debug_pub.add( 'EXITING OE_SALES_CAN_UTIL.UPDATE_SERVICE' ) ;

991: end if;
992: end if;
993:
994: IF l_debug_level > 0 THEN
995: oe_debug_pub.add( 'EXITING OE_SALES_CAN_UTIL.UPDATE_SERVICE' ) ;
996: END IF;
997:
998: EXCEPTION
999: WHEN FND_API.G_EXC_ERROR THEN

Line 1010: oe_debug_pub.add( 'UNEXPECTED ERROR IN ' || G_PKG_NAME || ':' || L_API_NAME ) ;

1006: END IF;
1007: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1008: WHEN OTHERS THEN
1009: IF l_debug_level > 0 THEN
1010: oe_debug_pub.add( 'UNEXPECTED ERROR IN ' || G_PKG_NAME || ':' || L_API_NAME ) ;
1011: END IF;
1012: IF oe_msg_pub.Check_MSg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1013: oe_msg_pub.Add_Exc_Msg
1014: (G_PKG_NAME

Line 1031: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

1027: l_old_ord_quantity number;
1028: l_old_can_quantity number;
1029: l_new_can_quantity number;
1030: --
1031: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1032: --
1033: begin
1034: IF NOT OE_GLOBALS.Equal(p_line_rec.ordered_quantity,p_old_line_rec.ordered_quantity)
1035: THEN

Line 1047: oe_debug_pub.add( 'NEW ORDERED QUANTITY IS: '||P_LINE_REC.ORDERED_QUANTITY ) ;

1043: from oe_order_lines
1044: where line_id = p_line_rec.line_id;
1045:
1046: IF l_debug_level > 0 THEN
1047: oe_debug_pub.add( 'NEW ORDERED QUANTITY IS: '||P_LINE_REC.ORDERED_QUANTITY ) ;
1048: END IF;
1049: IF l_debug_level > 0 THEN
1050: oe_debug_pub.add( 'OLD ORDERED QUANTITY IS: '||L_OLD_ORD_QUANTITY ) ;
1051: END IF;

Line 1050: oe_debug_pub.add( 'OLD ORDERED QUANTITY IS: '||L_OLD_ORD_QUANTITY ) ;

1046: IF l_debug_level > 0 THEN
1047: oe_debug_pub.add( 'NEW ORDERED QUANTITY IS: '||P_LINE_REC.ORDERED_QUANTITY ) ;
1048: END IF;
1049: IF l_debug_level > 0 THEN
1050: oe_debug_pub.add( 'OLD ORDERED QUANTITY IS: '||L_OLD_ORD_QUANTITY ) ;
1051: END IF;
1052: IF l_debug_level > 0 THEN
1053: oe_debug_pub.add( 'OLD CANCELLED QUANTITY IS: '||L_OLD_CAN_QUANTITY ) ;
1054: END IF;

Line 1053: oe_debug_pub.add( 'OLD CANCELLED QUANTITY IS: '||L_OLD_CAN_QUANTITY ) ;

1049: IF l_debug_level > 0 THEN
1050: oe_debug_pub.add( 'OLD ORDERED QUANTITY IS: '||L_OLD_ORD_QUANTITY ) ;
1051: END IF;
1052: IF l_debug_level > 0 THEN
1053: oe_debug_pub.add( 'OLD CANCELLED QUANTITY IS: '||L_OLD_CAN_QUANTITY ) ;
1054: END IF;
1055:
1056: IF (l_old_ord_quantity > p_line_rec.ordered_quantity)
1057: and nvl(oe_globals.g_pricing_recursion, 'N') = 'N' THEN

Line 1065: oe_debug_pub.add( 'NEW CANCELLED QUANTITY IS: '||L_NEW_CAN_QUANTITY ) ;

1061: l_new_can_quantity := l_old_can_quantity;
1062: END IF;
1063:
1064: IF l_debug_level > 0 THEN
1065: oe_debug_pub.add( 'NEW CANCELLED QUANTITY IS: '||L_NEW_CAN_QUANTITY ) ;
1066: END IF;
1067:
1068: RETURN l_new_can_quantity;
1069:

Line 1084: oe_debug_pub.add('Line Ord Qty already 0, Returning 0 as Cancelled Qty');

1080:
1081: RETURN 0;
1082:
1083: IF l_debug_level > 0 THEN
1084: oe_debug_pub.add('Line Ord Qty already 0, Returning 0 as Cancelled Qty');
1085: END IF;
1086: END IF;
1087:
1088: /* Following commented code has been replaced as fix for bug # 2136529

Line 1096: oe_debug_pub.ADD('rajeevcancell');

1092: (p_old_line_rec.ordered_quantity - p_line_rec.ordered_quantity);
1093:
1094: IF p_old_line_rec.cancelled_quantity = FND_API.G_MISS_NUM OR
1095: p_old_line_rec.cancelled_quantity is NULL THEN
1096: oe_debug_pub.ADD('rajeevcancell');
1097: RETURN l_ordered_quantity;
1098: ELSE
1099: oe_debug_pub.ADD('rajeevcancel2');
1100: RETURN (l_ordered_quantity +

Line 1099: oe_debug_pub.ADD('rajeevcancel2');

1095: p_old_line_rec.cancelled_quantity is NULL THEN
1096: oe_debug_pub.ADD('rajeevcancell');
1097: RETURN l_ordered_quantity;
1098: ELSE
1099: oe_debug_pub.ADD('rajeevcancel2');
1100: RETURN (l_ordered_quantity +
1101: p_old_line_rec.cancelled_quantity) ;
1102: END IF;
1103: ELSE

Line 1104: oe_debug_pub.ADD('rajeevcancel3');

1100: RETURN (l_ordered_quantity +
1101: p_old_line_rec.cancelled_quantity) ;
1102: END IF;
1103: ELSE
1104: oe_debug_pub.ADD('rajeevcancel3');
1105: RETURN p_line_rec.cancelled_quantity;
1106: END IF;
1107: END IF;
1108: ELSE

Line 1123: oe_debug_pub.ADD('rajeevcancelsecond');

1119: END IF;
1120: ELSE
1121: RETURN p_line_rec.cancelled_quantity;
1122: END IF;
1123: oe_debug_pub.ADD('rajeevcancelsecond');
1124:
1125: END IF;
1126: END IF;
1127: RETURN p_line_rec.cancelled_quantity;

Line 1132: oe_debug_pub.add('New ordered_quantity and Old ordered_quantity are equal ');

1128: */
1129:
1130: --Bug# 4009268
1131: IF OE_GLOBALS.Equal(p_line_rec.ordered_quantity,p_old_line_rec.ordered_quantity) THEN
1132: oe_debug_pub.add('New ordered_quantity and Old ordered_quantity are equal ');
1133: RETURN nvl(p_line_rec.cancelled_quantity,0);
1134: END IF;
1135:
1136: IF l_debug_level > 0 THEN

Line 1137: oe_debug_pub.add('Cal_Cancelled_qty - Returning 0 as Cancelled Qty at end ');

1133: RETURN nvl(p_line_rec.cancelled_quantity,0);
1134: END IF;
1135:
1136: IF l_debug_level > 0 THEN
1137: oe_debug_pub.add('Cal_Cancelled_qty - Returning 0 as Cancelled Qty at end ');
1138: END IF;
1139:
1140: return 0; -- INVCONV
1141:

Line 1165: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

1161: x_msg_data varchar2(255);
1162: l_on_operation_action varchar2(255);
1163: l_resp_id number := nvl(fnd_global.resp_id,-1);
1164: --
1165: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1166: --
1167: BEGIN
1168: IF l_debug_level > 0 THEN
1169: oe_debug_pub.add( 'IN CHECK CONSTRAINS FOR CANCELLATION' ) ;

Line 1169: oe_debug_pub.add( 'IN CHECK CONSTRAINS FOR CANCELLATION' ) ;

1165: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1166: --
1167: BEGIN
1168: IF l_debug_level > 0 THEN
1169: oe_debug_pub.add( 'IN CHECK CONSTRAINS FOR CANCELLATION' ) ;
1170: END IF;
1171: -- initialize API return status to success
1172: x_return_status := FND_API.G_RET_STS_SUCCESS;
1173: -- Prepare security record

Line 1187: oe_debug_pub.add( 'UNEXPECTED ERROR IN ' || G_PKG_NAME || ':' || L_API_NAME ) ;

1183: END IF;
1184: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1185: WHEN OTHERS THEN
1186: IF l_debug_level > 0 THEN
1187: oe_debug_pub.add( 'UNEXPECTED ERROR IN ' || G_PKG_NAME || ':' || L_API_NAME ) ;
1188: END IF;
1189: IF oe_msg_pub.Check_MSg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1190: oe_msg_pub.Add_Exc_Msg
1191: (G_PKG_NAME

Line 1226: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

1222: i NUMBER := 0;
1223: l_prg_line_count NUMBER;
1224:
1225: --
1226: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1227: --
1228: Begin
1229:
1230: IF l_debug_level > 0 THEN

Line 1231: OE_DEBUG_PUB.ADD('Entering oe_sales_can_util.perform_cancel_order',5);

1227: --
1228: Begin
1229:
1230: IF l_debug_level > 0 THEN
1231: OE_DEBUG_PUB.ADD('Entering oe_sales_can_util.perform_cancel_order',5);
1232: OE_DEBUG_PUB.ADD('perform cancel order header id : '||p_header_rec.header_id,5);
1233: OE_DEBUG_PUB.add('Reason Required Flag : '||OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG,1);
1234: OE_DEBUG_PUB.add('Reason provided is : '||p_header_rec.change_reason,1);
1235: END IF;

Line 1232: OE_DEBUG_PUB.ADD('perform cancel order header id : '||p_header_rec.header_id,5);

1228: Begin
1229:
1230: IF l_debug_level > 0 THEN
1231: OE_DEBUG_PUB.ADD('Entering oe_sales_can_util.perform_cancel_order',5);
1232: OE_DEBUG_PUB.ADD('perform cancel order header id : '||p_header_rec.header_id,5);
1233: OE_DEBUG_PUB.add('Reason Required Flag : '||OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG,1);
1234: OE_DEBUG_PUB.add('Reason provided is : '||p_header_rec.change_reason,1);
1235: END IF;
1236:

Line 1233: OE_DEBUG_PUB.add('Reason Required Flag : '||OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG,1);

1229:
1230: IF l_debug_level > 0 THEN
1231: OE_DEBUG_PUB.ADD('Entering oe_sales_can_util.perform_cancel_order',5);
1232: OE_DEBUG_PUB.ADD('perform cancel order header id : '||p_header_rec.header_id,5);
1233: OE_DEBUG_PUB.add('Reason Required Flag : '||OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG,1);
1234: OE_DEBUG_PUB.add('Reason provided is : '||p_header_rec.change_reason,1);
1235: END IF;
1236:
1237: --g_ord_lvl_can := TRUE; Commented for bug# 2922468

Line 1234: OE_DEBUG_PUB.add('Reason provided is : '||p_header_rec.change_reason,1);

1230: IF l_debug_level > 0 THEN
1231: OE_DEBUG_PUB.ADD('Entering oe_sales_can_util.perform_cancel_order',5);
1232: OE_DEBUG_PUB.ADD('perform cancel order header id : '||p_header_rec.header_id,5);
1233: OE_DEBUG_PUB.add('Reason Required Flag : '||OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG,1);
1234: OE_DEBUG_PUB.add('Reason provided is : '||p_header_rec.change_reason,1);
1235: END IF;
1236:
1237: --g_ord_lvl_can := TRUE; Commented for bug# 2922468
1238:

Line 1241: oe_debug_pub.add( 'CHANGE REASON IS REQUIRED' ) ;

1237: --g_ord_lvl_can := TRUE; Commented for bug# 2922468
1238:
1239: IF (oe_sales_can_util.G_REQUIRE_REASON AND OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG <> 'N') THEN
1240: IF l_debug_level > 0 THEN
1241: oe_debug_pub.add( 'CHANGE REASON IS REQUIRED' ) ;
1242: END IF;
1243: IF p_header_rec.change_reason IS NULL THEN
1244: fnd_message.set_name('ONT','OE_CAN_REASON_NOT');
1245: oe_msg_pub.add;

Line 1270: oe_debug_pub.add( 'LINE SELECTED FOR CANCELLATION , ID: '|| L_LINE_OLD_TBL ( J ) .LINE_ID , 1 ) ;

1266: IF nvl(l_line_old_tbl(j).top_model_line_id, l_line_old_tbl(j).line_id) = l_line_old_tbl(j).line_id OR
1267: nvl(l_line_old_tbl(j).model_remnant_flag, 'N') = 'Y' THEN
1268:
1269: IF l_debug_level > 0 THEN
1270: oe_debug_pub.add( 'LINE SELECTED FOR CANCELLATION , ID: '|| L_LINE_OLD_TBL ( J ) .LINE_ID , 1 ) ;
1271: END IF;
1272:
1273: /* Fix for bug # 2126033 */
1274: IF l_line_old_tbl(j).item_type_code = OE_Globals.G_ITEM_SERVICE AND

Line 1292: oe_debug_pub.add( 'SKIP , PARENT OF THIS SERVICE LINE EXISTS IN THE SAME ORDER' ) ;

1288: end;
1289:
1290: IF l_service_parent_exists = 'Y' THEN
1291: IF l_debug_level > 0 THEN
1292: oe_debug_pub.add( 'SKIP , PARENT OF THIS SERVICE LINE EXISTS IN THE SAME ORDER' ) ;
1293: END IF;
1294: goto end_loop;
1295: END IF;
1296: END IF;

Line 1313: oe_debug_pub.add( 'SKIP , THIS IS A PROMOTIONAL LINE' ) ;

1309: end;
1310:
1311: IF l_prg_line_count > 0 THEN
1312: IF l_debug_level > 0 THEN
1313: oe_debug_pub.add( 'SKIP , THIS IS A PROMOTIONAL LINE' ) ;
1314: END IF;
1315: goto end_loop;
1316: END IF;
1317:

Line 1319: oe_debug_pub.add( 'ADDING FOR CANCELLATION , LINE ID: '||L_LINE_OLD_TBL ( J ) .LINE_ID ) ;

1315: goto end_loop;
1316: END IF;
1317:
1318: IF l_debug_level > 0 THEN
1319: oe_debug_pub.add( 'ADDING FOR CANCELLATION , LINE ID: '||L_LINE_OLD_TBL ( J ) .LINE_ID ) ;
1320: END IF;
1321:
1322: i := i + 1;
1323:

Line 1337: oe_debug_pub.add( 'SKIPPING LINE ID: '||L_LINE_OLD_TBL ( J ) .LINE_ID||'-'|| L_LINE_OLD_TBL ( J ) .ITEM_TYPE_CODE ) ;

1333: l_line_tbl(i).flow_status_code := 'CANCELLED';
1334: l_line_tbl(i).open_flag := 'N'; */
1335: ELSE
1336: IF l_debug_level > 0 THEN
1337: oe_debug_pub.add( 'SKIPPING LINE ID: '||L_LINE_OLD_TBL ( J ) .LINE_ID||'-'|| L_LINE_OLD_TBL ( J ) .ITEM_TYPE_CODE ) ;
1338: END IF;
1339: END IF;
1340: ELSE
1341: IF l_debug_level > 0 THEN

Line 1342: oe_debug_pub.add( 'SKIPPING CANCELLED LINE ID: '||L_LINE_OLD_TBL ( J ) .LINE_ID||'-'|| L_LINE_OLD_TBL ( J ) .ITEM_TYPE_CODE ) ;

1338: END IF;
1339: END IF;
1340: ELSE
1341: IF l_debug_level > 0 THEN
1342: oe_debug_pub.add( 'SKIPPING CANCELLED LINE ID: '||L_LINE_OLD_TBL ( J ) .LINE_ID||'-'|| L_LINE_OLD_TBL ( J ) .ITEM_TYPE_CODE ) ;
1343: END IF;
1344: END IF; -- line not cancelled?
1345: <>
1346: null;

Line 1362: oe_debug_pub.add( 'UPDATE LINE PROCESS ORDER RETURN UNEXP_ERROR' ) ;

1358: END IF;
1359:
1360: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1361: IF l_debug_level > 0 THEN
1362: oe_debug_pub.add( 'UPDATE LINE PROCESS ORDER RETURN UNEXP_ERROR' ) ;
1363: END IF;
1364: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1365: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1366: IF l_debug_level > 0 THEN

Line 1367: oe_debug_pub.add( 'UPDATE LINE PROCESS ORDER RETURN RET_STS_ERROR' ) ;

1363: END IF;
1364: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1365: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1366: IF l_debug_level > 0 THEN
1367: oe_debug_pub.add( 'UPDATE LINE PROCESS ORDER RETURN RET_STS_ERROR' ) ;
1368: END IF;
1369: RAISE FND_API.G_EXC_ERROR;
1370: END IF;
1371:

Line 1376: oe_debug_pub.ADD('Calling Payment Refund for multiple payments.');

1372:
1373: -- Need to process payment refund if there is any prepayment.
1374: IF OE_PREPAYMENT_UTIL.IS_MULTIPLE_PAYMENTS_ENABLED THEN
1375: IF l_debug_level > 0 THEN
1376: oe_debug_pub.ADD('Calling Payment Refund for multiple payments.');
1377: END IF;
1378:
1379: OE_Prepayment_PVT.Process_Payment_Refund
1380: ( p_header_rec => p_header_rec

Line 1386: oe_debug_pub.add('return status after calling process_payment_refund is: '||x_return_status, 3);

1382: , x_msg_data => l_msg_data
1383: , x_return_status => x_return_status
1384: );
1385: IF l_debug_level > 0 THEN
1386: oe_debug_pub.add('return status after calling process_payment_refund is: '||x_return_status, 3);
1387: END IF;
1388:
1389: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1390: RAISE FND_API.G_EXC_ERROR;

Line 1397: oe_debug_pub.ADD('Calling Payment Refund.');

1393: END IF;
1394: ELSIF NVL(p_header_rec.payment_type_code,'NULL') = 'CREDIT_CARD'
1395: AND OE_PrePayment_UTIL.is_prepaid_order(p_header_rec) = 'Y'
1396: THEN
1397: oe_debug_pub.ADD('Calling Payment Refund.');
1398: OE_PrePayment_PVT.Process_PrePayment_Order
1399: ( p_header_rec => p_header_rec
1400: , p_calling_action => NULL
1401: , p_delayed_request => FND_API.G_FALSE

Line 1407: oe_debug_pub.add('return status after calling process_prepayment_order is: '||x_return_status, 3);

1403: , x_msg_data => l_msg_data
1404: , x_return_status => x_return_status
1405: );
1406: IF l_debug_level > 0 THEN
1407: oe_debug_pub.add('return status after calling process_prepayment_order is: '||x_return_status, 3);
1408: END IF;
1409:
1410: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1411: RAISE FND_API.G_EXC_ERROR;

Line 1420: oe_debug_pub.add( 'CALLING RELEASE HOLD API RELEASE HOLD' ) ;

1416:
1417: -- Release Holds
1418:
1419: IF l_debug_level > 0 THEN
1420: oe_debug_pub.add( 'CALLING RELEASE HOLD API RELEASE HOLD' ) ;
1421: END IF;
1422:
1423: l_order_tbl(1).header_id := p_header_rec.header_id;
1424: l_release_reason_code := 'OM_CANCEL';

Line 1437: oe_debug_pub.add( 'THE HOLD RELEASED WITH STATUS :'|| L_RETURN_STATUS ) ;

1433: x_msg_data => l_msg_data
1434: );
1435:
1436: IF l_debug_level > 0 THEN
1437: oe_debug_pub.add( 'THE HOLD RELEASED WITH STATUS :'|| L_RETURN_STATUS ) ;
1438: END IF;
1439:
1440: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1441: if l_return_status = FND_API.G_RET_STS_ERROR then

Line 1457: oe_debug_pub.ADD('Before calling Payment Request');

1453: -- If Order has Credit Card approval, then Void the Authorization
1454: IF p_header_rec.credit_card_approval_code is NOT NULL THEN
1455:
1456: -- Call Payment Request to Void any existing Authorizations
1457: oe_debug_pub.ADD('Before calling Payment Request');
1458:
1459: OE_Verify_Payment_PUB.Payment_Request
1460: ( p_header_rec => p_header_rec
1461: , p_trxn_type => 'VOIDAUTHONLY'

Line 1492: oe_debug_pub.add( 'EXITING OE_SALES_CAN_UTIL.PERFORM_CANCEL_ORDER' ) ;

1488:
1489: --g_ord_lvl_can := FALSE; Commented for bug# 2922468
1490:
1491: IF l_debug_level > 0 THEN
1492: oe_debug_pub.add( 'EXITING OE_SALES_CAN_UTIL.PERFORM_CANCEL_ORDER' ) ;
1493: END IF;
1494:
1495: EXCEPTION
1496: WHEN FND_API.G_EXC_ERROR THEN

Line 1527: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

1523: x_msg_count NUMBER;
1524: x_msg_data VARCHAR2(30);
1525:
1526: --
1527: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1528: --
1529: BEGIN
1530:
1531: IF l_debug_level > 0 THEN

Line 1532: oe_debug_pub.add( 'ENTERING OE_SALES_CAN_UTIL.PERFORMLINECANCELLATION' ) ;

1528: --
1529: BEGIN
1530:
1531: IF l_debug_level > 0 THEN
1532: oe_debug_pub.add( 'ENTERING OE_SALES_CAN_UTIL.PERFORMLINECANCELLATION' ) ;
1533: END IF;
1534:
1535: l_control_rec.controlled_operation := TRUE;
1536: l_control_rec.change_attributes := TRUE;

Line 1553: oe_debug_pub.add( 'BEFORE CALLING PROCESS ORDER' ) ;

1549: l_line_tbl := p_line_tbl;
1550: l_old_line_tbl := p_line_old_tbl;
1551:
1552: IF l_debug_level > 0 THEN
1553: oe_debug_pub.add( 'BEFORE CALLING PROCESS ORDER' ) ;
1554: END IF;
1555:
1556: oe_order_pvt.Lines
1557: ( p_validation_level => FND_API.G_VALID_LEVEL_NONE

Line 1565: oe_debug_pub.add( 'AFTER CALLING PROCESS ORDER' ) ;

1561: , x_return_status => x_return_status
1562: );
1563:
1564: IF l_debug_level > 0 THEN
1565: oe_debug_pub.add( 'AFTER CALLING PROCESS ORDER' ) ;
1566: END IF;
1567:
1568: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1569: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1594: oe_debug_pub.add( 'EXITING OE_SALES_CAN_UTIL.PERFORMLINECANCELLATION' ) ;

1590: end loop;
1591: END IF; -- 2653505
1592:
1593: IF l_debug_level > 0 THEN
1594: oe_debug_pub.add( 'EXITING OE_SALES_CAN_UTIL.PERFORMLINECANCELLATION' ) ;
1595: END IF;
1596:
1597: EXCEPTION
1598: WHEN FND_API.G_EXC_ERROR THEN

Line 1623: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

1619: l_line_rec OE_Order_PUB.Line_Rec_Type;
1620: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
1621:
1622: --
1623: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1624: --
1625: BEGIN
1626:
1627: IF l_debug_level > 0 THEN

Line 1628: oe_debug_pub.add( 'ENTERING OE_LINE_UTIL.QUERY_ROWS' , 1 ) ;

1624: --
1625: BEGIN
1626:
1627: IF l_debug_level > 0 THEN
1628: oe_debug_pub.add( 'ENTERING OE_LINE_UTIL.QUERY_ROWS' , 1 ) ;
1629: END IF;
1630:
1631:
1632: -- Return fetched table

Line 1634: oe_debug_pub.add( 'EXITING OE_LINE_UTIL.QUERY_ROWS' , 1 ) ;

1630:
1631:
1632: -- Return fetched table
1633: IF l_debug_level > 0 THEN
1634: oe_debug_pub.add( 'EXITING OE_LINE_UTIL.QUERY_ROWS' , 1 ) ;
1635: END IF;
1636:
1637: RETURN l_line_tbl;
1638:

Line 1668: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

1664: -- then those sets should be processed for fulfillment logic.
1665:
1666: PROCEDURE Call_Process_Fulfillment(p_header_id IN NUMBER)
1667: IS
1668: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1669: l_result_out VARCHAR2(240);
1670: l_return_status VARCHAR2(30);
1671: l_activity_result VARCHAR2(30) := 'NO_RESULT';
1672: l_activity_status VARCHAR2(8);

Line 1696: oe_debug_pub.add('Entering Oe_sales_can_util.Call_Process_Fulfillment API',2);

1692: and ol.open_flag = 'Y';
1693:
1694: BEGIN
1695: IF l_debug_level > 0 THEN
1696: oe_debug_pub.add('Entering Oe_sales_can_util.Call_Process_Fulfillment API',2);
1697: END IF;
1698:
1699: SAVEPOINT Process_Set;
1700:

Line 1714: oe_debug_pub.add('Fulfillment Set_id='||C_Set.set_id||',No. of lines='||l_lines_in_set,2);

1710: AND ol.cancelled_flag <> 'Y'
1711: AND ol.open_flag = 'Y';
1712:
1713: IF l_debug_level > 0 THEN
1714: oe_debug_pub.add('Fulfillment Set_id='||C_Set.set_id||',No. of lines='||l_lines_in_set,2);
1715: END IF;
1716:
1717: -- Count the lines that are awaiting fulfillment for this set
1718: IF l_lines_in_set > 0 THEN

Line 1733: oe_debug_pub.add('No. of lines in Fulfill:NOTIFIED ='||l_lines_awaiting,2);

1729: AND WIAS.activity_status = 'NOTIFIED'
1730: AND WIAS.Process_Activity = WPA.instance_id;
1731:
1732: IF l_debug_level > 0 THEN
1733: oe_debug_pub.add('No. of lines in Fulfill:NOTIFIED ='||l_lines_awaiting,2);
1734: END IF;
1735:
1736: IF l_lines_awaiting = l_lines_in_set THEN
1737: -- This is to pick up 1 line in the set in Fulfill:Notified

Line 1754: oe_debug_pub.add('All lines in fulfill:notified, hence calling OE_Line_Fullfill.Process_Fulfillment for line_id='||l_line_id||' , p_activity_id='||l_activity_id,2);

1750: AND WIAS.Process_Activity = WPA.instance_id
1751: AND ROWNUM = 1;
1752:
1753: IF l_debug_level > 0 THEN
1754: oe_debug_pub.add('All lines in fulfill:notified, hence calling OE_Line_Fullfill.Process_Fulfillment for line_id='||l_line_id||' , p_activity_id='||l_activity_id,2);
1755: END IF;
1756:
1757: OE_Line_Fullfill.Process_Fulfillment
1758: ( p_api_version_number => 1.0

Line 1768: oe_debug_pub.add('Exception from Process_Fulfillment:'||l_result_out,2);

1764: , x_msg_data => l_msg_data);
1765:
1766: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1767: IF l_debug_level > 0 THEN
1768: oe_debug_pub.add('Exception from Process_Fulfillment:'||l_result_out,2);
1769: END IF;
1770: OE_MSG_PUB.Add_Text(p_message_text => l_msg_data);
1771: OE_MSG_PUB.Save_API_Messages;
1772:

Line 1788: oe_debug_pub.add('After Get_Activity_Result, ret status:'||l_return_status||' ,Fulfill:'||l_activity_status,3);

1784: ,x_activity_status_code => l_activity_status
1785: ,x_activity_id => l_activity_id );
1786:
1787: IF l_debug_level > 0 THEN
1788: oe_debug_pub.add('After Get_Activity_Result, ret status:'||l_return_status||' ,Fulfill:'||l_activity_status,3);
1789: END IF;
1790:
1791: IF l_return_status = FND_API.G_RET_STS_SUCCESS AND
1792: l_activity_status = 'NOTIFIED' THEN

Line 1794: oe_debug_pub.add('Calling wf_engine.CompleteActivityInternalName for lineID='||l_item_key,2);

1790:
1791: IF l_return_status = FND_API.G_RET_STS_SUCCESS AND
1792: l_activity_status = 'NOTIFIED' THEN
1793: IF l_debug_level > 0 THEN
1794: oe_debug_pub.add('Calling wf_engine.CompleteActivityInternalName for lineID='||l_item_key,2);
1795: END IF;
1796:
1797: Wf_Engine.CompleteActivityInternalName('OEOL', l_item_key, 'FULFILL_LINE', '#NULL');
1798:

Line 1800: oe_debug_pub.add('After calling wf_engine.CompleteActivityInternalName for lineID='||l_item_key,2);

1796:
1797: Wf_Engine.CompleteActivityInternalName('OEOL', l_item_key, 'FULFILL_LINE', '#NULL');
1798:
1799: IF l_debug_level > 0 THEN
1800: oe_debug_pub.add('After calling wf_engine.CompleteActivityInternalName for lineID='||l_item_key,2);
1801: END IF;
1802: END IF;
1803: END IF;
1804: END IF; -- l_lines_awaiting = l_lines_in_set check

Line 1812: oe_debug_pub.add('Exiting from Oe_sales_can_util.Call_Process_Fulfillment API',2);

1808: l_lines_in_set := NULL;
1809: END LOOP; -- Non closed fulfillment sets
1810:
1811: IF l_debug_level > 0 THEN
1812: oe_debug_pub.add('Exiting from Oe_sales_can_util.Call_Process_Fulfillment API',2);
1813: END IF;
1814: EXCEPTION
1815: WHEN Others THEN
1816: IF l_debug_level > 0 THEN

Line 1817: oe_debug_pub.add('OTHERS EXCEPTION in Oe_sales_can_util.Call_Process_Fulfillment API',2);

1813: END IF;
1814: EXCEPTION
1815: WHEN Others THEN
1816: IF l_debug_level > 0 THEN
1817: oe_debug_pub.add('OTHERS EXCEPTION in Oe_sales_can_util.Call_Process_Fulfillment API',2);
1818: END IF;
1819: END Call_Process_Fulfillment;
1820:
1821: PROCEDURE Cancel_Remaining_Order

Line 1849: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

1845: l_service_parent_exists VARCHAR2(1) := 'N';
1846: l_prg_line_count NUMBER;
1847:
1848: --
1849: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1850: --
1851: Begin
1852:
1853: IF l_debug_level > 0 THEN

Line 1854: oe_debug_pub.add( 'ENTERING OE_SALES_CAN_UTIL.CANCEL_REMAINING_ORDER' ) ;

1850: --
1851: Begin
1852:
1853: IF l_debug_level > 0 THEN
1854: oe_debug_pub.add( 'ENTERING OE_SALES_CAN_UTIL.CANCEL_REMAINING_ORDER' ) ;
1855: END IF;
1856:
1857: x_return_status := FND_API.G_RET_STS_SUCCESS;
1858:

Line 1871: oe_debug_pub.add( 'CANCEL REMAINING ORDER HEADER ID: '||L_HEADER_ID ) ;

1867: l_header_id := p_header_rec.header_id;
1868: END IF;
1869:
1870: IF l_debug_level > 0 THEN
1871: oe_debug_pub.add( 'CANCEL REMAINING ORDER HEADER ID: '||L_HEADER_ID ) ;
1872: END IF;
1873:
1874: oe_line_util.Query_Rows( p_header_id => l_header_id
1875: , x_line_tbl => l_line_old_tbl

Line 1902: oe_debug_pub.add( 'LINE SELECTED FOR CANCELLATION , ID: '|| L_LINE_OLD_TBL ( I ) .LINE_ID , 1 ) ;

1898: IF nvl(l_line_old_tbl(i).top_model_line_id, l_line_old_tbl(i).line_id) = l_line_old_tbl(i).line_id OR
1899: nvl(l_line_old_tbl(i).model_remnant_flag, 'N') = 'Y' THEN
1900:
1901: IF l_debug_level > 0 THEN
1902: oe_debug_pub.add( 'LINE SELECTED FOR CANCELLATION , ID: '|| L_LINE_OLD_TBL ( I ) .LINE_ID , 1 ) ;
1903: END IF;
1904:
1905: /* Fix for bug # 2126033 */
1906: IF l_line_old_tbl(i).item_type_code = OE_Globals.G_ITEM_SERVICE AND

Line 1924: oe_debug_pub.add( 'SKIP , PARENT OF THIS SERVICE LINE EXISTS IN THE SAME ORDER' ) ;

1920: end;
1921:
1922: IF l_service_parent_exists = 'Y' THEN
1923: IF l_debug_level > 0 THEN
1924: oe_debug_pub.add( 'SKIP , PARENT OF THIS SERVICE LINE EXISTS IN THE SAME ORDER' ) ;
1925: END IF;
1926: goto end_loop;
1927: END IF;
1928: END IF;

Line 1949: oe_debug_pub.add( 'SKIP , THIS IS A PROMOTIONAL GOODS LINE' ) ;

1945: end;
1946:
1947: IF l_prg_line_count > 0 THEN
1948: IF l_debug_level > 0 THEN
1949: oe_debug_pub.add( 'SKIP , THIS IS A PROMOTIONAL GOODS LINE' ) ;
1950: END IF;
1951: goto end_loop;
1952: END IF;
1953:

Line 1955: oe_debug_pub.add( 'ADDING FOR CANCELLATION , LINE ID: '|| L_LINE_OLD_TBL ( I ) .LINE_ID ) ;

1951: goto end_loop;
1952: END IF;
1953:
1954: IF l_debug_level > 0 THEN
1955: oe_debug_pub.add( 'ADDING FOR CANCELLATION , LINE ID: '|| L_LINE_OLD_TBL ( I ) .LINE_ID ) ;
1956: END IF;
1957:
1958: J := J + 1;
1959:

Line 1982: oe_debug_pub.add( 'SKIPPING LINE ID: '||L_LINE_OLD_TBL ( I ) .LINE_ID||'-'|| L_LINE_OLD_TBL ( I ) .ITEM_TYPE_CODE ) ;

1978: --l_line_tbl(j).flow_status_code := 'CANCELLED';
1979: --l_line_tbl(j).open_flag := 'N';
1980: ELSE
1981: IF l_debug_level > 0 THEN
1982: oe_debug_pub.add( 'SKIPPING LINE ID: '||L_LINE_OLD_TBL ( I ) .LINE_ID||'-'|| L_LINE_OLD_TBL ( I ) .ITEM_TYPE_CODE ) ;
1983: END IF;
1984: END IF;
1985: ELSE
1986: IF l_debug_level > 0 THEN

Line 1987: oe_debug_pub.add( 'SKIPPING ALREADY SHIPPED OR CLOSED/CANCELLED LINE ID: '||L_LINE_OLD_TBL ( I ) .LINE_ID ) ;

1983: END IF;
1984: END IF;
1985: ELSE
1986: IF l_debug_level > 0 THEN
1987: oe_debug_pub.add( 'SKIPPING ALREADY SHIPPED OR CLOSED/CANCELLED LINE ID: '||L_LINE_OLD_TBL ( I ) .LINE_ID ) ;
1988: END IF;
1989: END If;
1990: <>
1991: null;

Line 1995: oe_debug_pub.add( 'CANCEL REMAINING ORDER - LINE COUNT '|| L_LINE_TBL.COUNT ) ;

1991: null;
1992: End Loop;
1993:
1994: IF l_debug_level > 0 THEN
1995: oe_debug_pub.add( 'CANCEL REMAINING ORDER - LINE COUNT '|| L_LINE_TBL.COUNT ) ;
1996: END IF;
1997:
1998: IF l_line_tbl.count = 0 THEN
1999: FND_MESSAGE.SET_NAME('ONT','OE_NO_ELIGIBLE_LINES');

Line 2006: oe_debug_pub.add( 'BEFORE CALLING PERFORM LINE CANCELLATION' ) ;

2002: RAISE FND_API.G_EXC_ERROR;
2003: END IF;
2004:
2005: IF l_debug_level > 0 THEN
2006: oe_debug_pub.add( 'BEFORE CALLING PERFORM LINE CANCELLATION' ) ;
2007: END IF;
2008:
2009: -- Call PeformLinecancellation to cancel each line
2010: PerformLinecancellation(l_line_tbl,

Line 2016: oe_debug_pub.add( 'PERFORM LINE CANCELLATION UNEXP_ERROR' ) ;

2012: x_return_status => l_return_status);
2013:
2014: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2015: IF l_debug_level > 0 THEN
2016: oe_debug_pub.add( 'PERFORM LINE CANCELLATION UNEXP_ERROR' ) ;
2017: END IF;
2018: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2019: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2020: IF l_debug_level > 0 THEN

Line 2021: oe_debug_pub.add( 'PERFORM LINE CANCELLATION RET_STS_ERROR' ) ;

2017: END IF;
2018: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2019: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2020: IF l_debug_level > 0 THEN
2021: oe_debug_pub.add( 'PERFORM LINE CANCELLATION RET_STS_ERROR' ) ;
2022: END IF;
2023: RAISE FND_API.G_EXC_ERROR;
2024: END IF;
2025:

Line 2038: oe_debug_pub.add( 'Process_requests_and_notify UNEXP_ERROR' ) ;

2034: , p_old_line_tbl => l_x_line_old_tbl
2035: );
2036: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2037: IF l_debug_level > 0 THEN
2038: oe_debug_pub.add( 'Process_requests_and_notify UNEXP_ERROR' ) ;
2039: END IF;
2040: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2041: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2042: IF l_debug_level > 0 THEN

Line 2043: oe_debug_pub.add( 'Process_requests_and_notify RET_STS_ERROR' ) ;

2039: END IF;
2040: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2041: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2042: IF l_debug_level > 0 THEN
2043: oe_debug_pub.add( 'Process_requests_and_notify RET_STS_ERROR' ) ;
2044: END IF;
2045: RAISE FND_API.G_EXC_ERROR;
2046: END IF;
2047: --end bug 4567339

Line 2053: oe_debug_pub.add( 'EXITING OE_SALES_CAN_UTIL.CANCEL_REMAINING_ORDER' ) ;

2049: -- bug 4887806
2050: OE_SALES_CAN_UTIL.Call_Process_Fulfillment(p_header_id => p_header_id);
2051:
2052: IF l_debug_level > 0 THEN
2053: oe_debug_pub.add( 'EXITING OE_SALES_CAN_UTIL.CANCEL_REMAINING_ORDER' ) ;
2054: END IF;
2055:
2056: EXCEPTION
2057: WHEN FND_API.G_EXC_ERROR THEN

Line 2089: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

2085: select ordered_quantity from
2086: oe_order_lines_all
2087: where header_id = x_request_rec.entity_id
2088: and ordered_quantity <> 0;
2089: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2090:
2091: BEGIN
2092: if l_debug_level > 0 then
2093: OE_DEBUG_PUB.ADD('Enter Cancel Workflow API - OEXUCANB ');

Line 2093: OE_DEBUG_PUB.ADD('Enter Cancel Workflow API - OEXUCANB ');

2089: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2090:
2091: BEGIN
2092: if l_debug_level > 0 then
2093: OE_DEBUG_PUB.ADD('Enter Cancel Workflow API - OEXUCANB ');
2094: OE_DEBUG_PUB.ADD('Entity:' || x_request_rec.param1 );
2095: OE_DEBUG_PUB.ADD('Entity id:' || x_request_rec.entity_id );
2096: end if;
2097:

Line 2094: OE_DEBUG_PUB.ADD('Entity:' || x_request_rec.param1 );

2090:
2091: BEGIN
2092: if l_debug_level > 0 then
2093: OE_DEBUG_PUB.ADD('Enter Cancel Workflow API - OEXUCANB ');
2094: OE_DEBUG_PUB.ADD('Entity:' || x_request_rec.param1 );
2095: OE_DEBUG_PUB.ADD('Entity id:' || x_request_rec.entity_id );
2096: end if;
2097:
2098: IF x_request_rec.param1 = OE_GLOBALS.G_ENTITY_HEADER

Line 2095: OE_DEBUG_PUB.ADD('Entity id:' || x_request_rec.entity_id );

2091: BEGIN
2092: if l_debug_level > 0 then
2093: OE_DEBUG_PUB.ADD('Enter Cancel Workflow API - OEXUCANB ');
2094: OE_DEBUG_PUB.ADD('Entity:' || x_request_rec.param1 );
2095: OE_DEBUG_PUB.ADD('Entity id:' || x_request_rec.entity_id );
2096: end if;
2097:
2098: IF x_request_rec.param1 = OE_GLOBALS.G_ENTITY_HEADER
2099: THEN

Line 2102: OE_DEBUG_PUB.ADD('Before select ');

2098: IF x_request_rec.param1 = OE_GLOBALS.G_ENTITY_HEADER
2099: THEN
2100:
2101: if l_debug_level > 0 then
2102: OE_DEBUG_PUB.ADD('Before select ');
2103: end if;
2104: OPEN C2;
2105: FETCH C2 INTO l_ordered_quantity;
2106: CLOSE C2;

Line 2109: OE_DEBUG_PUB.ADD('Before cancelling header flow ');

2105: FETCH C2 INTO l_ordered_quantity;
2106: CLOSE C2;
2107: IF l_ordered_quantity IS NULL THEN
2108: if l_debug_level > 0 then
2109: OE_DEBUG_PUB.ADD('Before cancelling header flow ');
2110: end if;
2111:
2112: wf_engine.handleerror(OE_Globals.G_WFI_HDR
2113: ,to_char(x_request_rec.entity_id)

Line 2120: OE_DEBUG_PUB.ADD('after cancelling header flow ');

2116:
2117: END IF; -- Ordered quantity
2118:
2119: if l_debug_level > 0 then
2120: OE_DEBUG_PUB.ADD('after cancelling header flow ');
2121: end if;
2122:
2123: ELSIF x_request_rec.param1 = OE_GLOBALS.G_ENTITY_LINE
2124: THEN

Line 2127: OE_DEBUG_PUB.ADD('before select Cursoer C1 ');

2123: ELSIF x_request_rec.param1 = OE_GLOBALS.G_ENTITY_LINE
2124: THEN
2125:
2126: if l_debug_level > 0 then
2127: OE_DEBUG_PUB.ADD('before select Cursoer C1 ');
2128: end if;
2129: OPEN C1;
2130: FETCH C1 INTO l_ordered_quantity;
2131: CLOSE C1;

Line 2134: OE_DEBUG_PUB.ADD('Before cancelling line flow ');

2130: FETCH C1 INTO l_ordered_quantity;
2131: CLOSE C1;
2132: IF l_ordered_quantity = 0 THEN
2133: if l_debug_level > 0 then
2134: OE_DEBUG_PUB.ADD('Before cancelling line flow ');
2135: end if;
2136: Update oe_order_lines_all
2137: set cancelled_flag = 'Y' where
2138: line_id = x_request_rec.entity_id;

Line 2147: OE_DEBUG_PUB.ADD('after cancelling line flow ');

2143: 'RETRY','CANCEL');
2144: End if; -- Ordered quantity
2145:
2146: if l_debug_level > 0 then
2147: OE_DEBUG_PUB.ADD('after cancelling line flow ');
2148: end if;
2149:
2150: END IF;
2151:

Line 2188: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

2184: l_old_ord_quantity2 number;
2185: l_old_can_quantity2 number;
2186: l_new_can_quantity2 number;
2187: --
2188: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2189: --
2190: begin
2191:
2192: IF l_debug_level > 0 THEN

Line 2193: oe_debug_pub.add( 'entering Cal_Cancelled_Qty2') ;

2189: --
2190: begin
2191:
2192: IF l_debug_level > 0 THEN
2193: oe_debug_pub.add( 'entering Cal_Cancelled_Qty2') ;
2194: END IF;
2195: IF NOT OE_GLOBALS.Equal(p_line_rec.ordered_quantity2,p_old_line_rec.ordered_quantity2)
2196: THEN
2197: IF l_debug_level > 0 THEN

Line 2198: oe_debug_pub.add( 'in Cal_Cancelled_Qty2 1 ') ;

2194: END IF;
2195: IF NOT OE_GLOBALS.Equal(p_line_rec.ordered_quantity2,p_old_line_rec.ordered_quantity2)
2196: THEN
2197: IF l_debug_level > 0 THEN
2198: oe_debug_pub.add( 'in Cal_Cancelled_Qty2 1 ') ;
2199: END IF;
2200:
2201: --IF (nvl(p_line_rec.line_category_code,' ') <> 'RETURN') THEN
2202:

Line 2212: oe_debug_pub.add( 'NEW ORDERED QUANTITY2 IS: '||P_LINE_REC.ORDERED_QUANTITY2 ) ;

2208: from oe_order_lines
2209: where line_id = p_line_rec.line_id;
2210:
2211: IF l_debug_level > 0 THEN
2212: oe_debug_pub.add( 'NEW ORDERED QUANTITY2 IS: '||P_LINE_REC.ORDERED_QUANTITY2 ) ;
2213: END IF;
2214: IF l_debug_level > 0 THEN
2215: oe_debug_pub.add( 'OLD ORDERED QUANTITY2 IS: '||L_OLD_ORD_QUANTITY2 ) ;
2216: END IF;

Line 2215: oe_debug_pub.add( 'OLD ORDERED QUANTITY2 IS: '||L_OLD_ORD_QUANTITY2 ) ;

2211: IF l_debug_level > 0 THEN
2212: oe_debug_pub.add( 'NEW ORDERED QUANTITY2 IS: '||P_LINE_REC.ORDERED_QUANTITY2 ) ;
2213: END IF;
2214: IF l_debug_level > 0 THEN
2215: oe_debug_pub.add( 'OLD ORDERED QUANTITY2 IS: '||L_OLD_ORD_QUANTITY2 ) ;
2216: END IF;
2217: IF l_debug_level > 0 THEN
2218: oe_debug_pub.add( 'OLD CANCELLED QUANTITY2 IS: '||L_OLD_CAN_QUANTITY2 ) ;
2219: END IF;

Line 2218: oe_debug_pub.add( 'OLD CANCELLED QUANTITY2 IS: '||L_OLD_CAN_QUANTITY2 ) ;

2214: IF l_debug_level > 0 THEN
2215: oe_debug_pub.add( 'OLD ORDERED QUANTITY2 IS: '||L_OLD_ORD_QUANTITY2 ) ;
2216: END IF;
2217: IF l_debug_level > 0 THEN
2218: oe_debug_pub.add( 'OLD CANCELLED QUANTITY2 IS: '||L_OLD_CAN_QUANTITY2 ) ;
2219: END IF;
2220:
2221: IF (l_old_ord_quantity2 > p_line_rec.ordered_quantity2)
2222: and nvl(oe_globals.g_pricing_recursion, 'N') = 'N' THEN

Line 2230: oe_debug_pub.add( 'NEW CANCELLED QUANTITY2 IS: '||L_NEW_CAN_QUANTITY2 ) ;

2226: l_new_can_quantity2 := l_old_can_quantity2;
2227: END IF;
2228:
2229: IF l_debug_level > 0 THEN
2230: oe_debug_pub.add( 'NEW CANCELLED QUANTITY2 IS: '||L_NEW_CAN_QUANTITY2 ) ;
2231: END IF;
2232:
2233: RETURN l_new_can_quantity2;
2234:

Line 2243: oe_debug_pub.add( 'in Cal_Cancelled_Qty2 2 ') ;

2239: ** order right after quantity on the lines was updated to 0.
2240: ** Need to send the Cancelled Qty as Zero in such instances.
2241: */
2242: IF l_debug_level > 0 THEN
2243: oe_debug_pub.add( 'in Cal_Cancelled_Qty2 2 ') ;
2244: END IF;
2245:
2246: IF p_line_rec.ordered_quantity2 = 0 AND
2247: p_old_line_rec.ordered_quantity2 = 0 AND

Line 2253: oe_debug_pub.add('Line Ord Qty2 already 0, Returning 0 as Cancelled Qty2');

2249:
2250: RETURN 0;
2251:
2252: IF l_debug_level > 0 THEN
2253: oe_debug_pub.add('Line Ord Qty2 already 0, Returning 0 as Cancelled Qty2');
2254: END IF;
2255: END IF;
2256:
2257: IF l_debug_level > 0 THEN

Line 2258: oe_debug_pub.add( 'in Cal_Cancelled_Qty2 3 ') ;

2254: END IF;
2255: END IF;
2256:
2257: IF l_debug_level > 0 THEN
2258: oe_debug_pub.add( 'in Cal_Cancelled_Qty2 3 ') ;
2259: END IF;
2260:
2261: /* Following commented code has been replaced as fix for bug # 2136529
2262:

Line 2269: oe_debug_pub.ADD('rajeevcancell');

2265: (p_old_line_rec.ordered_quantity - p_line_rec.ordered_quantity);
2266:
2267: IF p_old_line_rec.cancelled_quantity = FND_API.G_MISS_NUM OR
2268: p_old_line_rec.cancelled_quantity is NULL THEN
2269: oe_debug_pub.ADD('rajeevcancell');
2270: RETURN l_ordered_quantity;
2271: ELSE
2272: oe_debug_pub.ADD('rajeevcancel2');
2273: RETURN (l_ordered_quantity +

Line 2272: oe_debug_pub.ADD('rajeevcancel2');

2268: p_old_line_rec.cancelled_quantity is NULL THEN
2269: oe_debug_pub.ADD('rajeevcancell');
2270: RETURN l_ordered_quantity;
2271: ELSE
2272: oe_debug_pub.ADD('rajeevcancel2');
2273: RETURN (l_ordered_quantity +
2274: p_old_line_rec.cancelled_quantity) ;
2275: END IF;
2276: ELSE

Line 2277: oe_debug_pub.ADD('rajeevcancel3');

2273: RETURN (l_ordered_quantity +
2274: p_old_line_rec.cancelled_quantity) ;
2275: END IF;
2276: ELSE
2277: oe_debug_pub.ADD('rajeevcancel3');
2278: RETURN p_line_rec.cancelled_quantity;
2279: END IF;
2280: END IF;
2281: ELSE

Line 2296: oe_debug_pub.ADD('rajeevcancelsecond');

2292: END IF;
2293: ELSE
2294: RETURN p_line_rec.cancelled_quantity;
2295: END IF;
2296: oe_debug_pub.ADD('rajeevcancelsecond');
2297:
2298: END IF;
2299: END IF;
2300: RETURN p_line_rec.cancelled_quantity;

Line 2305: oe_debug_pub.add('New ordered_quantity2 and Old ordered_quantity2 are equal ');

2301: */
2302:
2303: --Bug# 4009268
2304: IF OE_GLOBALS.Equal(p_line_rec.ordered_quantity2,p_old_line_rec.ordered_quantity2) THEN
2305: oe_debug_pub.add('New ordered_quantity2 and Old ordered_quantity2 are equal ');
2306: RETURN p_line_rec.cancelled_quantity2;
2307: END IF;
2308:
2309: IF l_debug_level > 0 THEN

Line 2310: oe_debug_pub.add( 'in Cal_Cancelled_Qty2 4 ') ;

2306: RETURN p_line_rec.cancelled_quantity2;
2307: END IF;
2308:
2309: IF l_debug_level > 0 THEN
2310: oe_debug_pub.add( 'in Cal_Cancelled_Qty2 4 ') ;
2311: END IF;
2312: RETURN 0;
2313:
2314: end Cal_Cancelled_qty2;