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_RMA_RECEIVING dependencies on OE_DEBUG_PUB

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

173: l_x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
174: l_x_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
175: --serla end
176: --
177: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
178: --
179: l_max_qty_to_adjust NUMBER;
180: l_line_number VARCHAR2(30);
181: l_credit_rejected_qty VARCHAR2(1); -- Added for bug 6052676

Line 189: oe_debug_pub.initialize;

185: x_return_status := FND_API.G_RET_STS_SUCCESS;
186:
187: -- OM: Debug Level. Just remove the comments
188: IF To_number(Nvl(fnd_profile.value('ONT_DEBUG_LEVEL'), '0')) > 0 THEN
189: oe_debug_pub.initialize;
190: l_temp_var := oe_debug_pub.set_debug_mode('FILE');
191: oe_debug_pub.debug_on;
192: END IF;
193:

Line 190: l_temp_var := oe_debug_pub.set_debug_mode('FILE');

186:
187: -- OM: Debug Level. Just remove the comments
188: IF To_number(Nvl(fnd_profile.value('ONT_DEBUG_LEVEL'), '0')) > 0 THEN
189: oe_debug_pub.initialize;
190: l_temp_var := oe_debug_pub.set_debug_mode('FILE');
191: oe_debug_pub.debug_on;
192: END IF;
193:
194: -- Return success if there is no parent and unordered receipt

Line 191: oe_debug_pub.debug_on;

187: -- OM: Debug Level. Just remove the comments
188: IF To_number(Nvl(fnd_profile.value('ONT_DEBUG_LEVEL'), '0')) > 0 THEN
189: oe_debug_pub.initialize;
190: l_temp_var := oe_debug_pub.set_debug_mode('FILE');
191: oe_debug_pub.debug_on;
192: END IF;
193:
194: -- Return success if there is no parent and unordered receipt
195: IF (p_parent_transaction_type is NULL OR

Line 199: oe_debug_pub.add( 'PARENT IS NULL OR NO PARENT , TRX TYPE IS UNORDERED' ) ;

195: IF (p_parent_transaction_type is NULL OR
196: p_parent_transaction_type = OE_RMA_RECEIVING.G_RMA_NO_PARENT) AND
197: (p_transaction_type = OE_RMA_RECEIVING.G_RMA_UNMATCHED_ORDER) THEN
198: IF l_debug_level > 0 THEN
199: oe_debug_pub.add( 'PARENT IS NULL OR NO PARENT , TRX TYPE IS UNORDERED' ) ;
200: END IF;
201: return;
202: END IF;
203:

Line 210: oe_debug_pub.add( 'ENTERING OE_RMA_RECEIVING.PUSH_RECEIVING_INFO' , 1 ) ;

206:
207: -- This if statement is to allow debug generation by setting the profile option
208:
209: IF l_debug_level > 0 THEN
210: oe_debug_pub.add( 'ENTERING OE_RMA_RECEIVING.PUSH_RECEIVING_INFO' , 1 ) ;
211: END IF;
212: IF l_debug_level > 0 THEN
213: oe_debug_pub.add( 'RMA_LINE_ID: ' || P_RMA_LINE_ID , 1 ) ;
214: END IF;

Line 213: oe_debug_pub.add( 'RMA_LINE_ID: ' || P_RMA_LINE_ID , 1 ) ;

209: IF l_debug_level > 0 THEN
210: oe_debug_pub.add( 'ENTERING OE_RMA_RECEIVING.PUSH_RECEIVING_INFO' , 1 ) ;
211: END IF;
212: IF l_debug_level > 0 THEN
213: oe_debug_pub.add( 'RMA_LINE_ID: ' || P_RMA_LINE_ID , 1 ) ;
214: END IF;
215: IF l_debug_level > 0 THEN
216: oe_debug_pub.add( 'QUANTITY: ' || P_QUANTITY , 1 ) ;
217: END IF;

Line 216: oe_debug_pub.add( 'QUANTITY: ' || P_QUANTITY , 1 ) ;

212: IF l_debug_level > 0 THEN
213: oe_debug_pub.add( 'RMA_LINE_ID: ' || P_RMA_LINE_ID , 1 ) ;
214: END IF;
215: IF l_debug_level > 0 THEN
216: oe_debug_pub.add( 'QUANTITY: ' || P_QUANTITY , 1 ) ;
217: END IF;
218: IF l_debug_level > 0 THEN
219: oe_debug_pub.add( 'PARENT_TRANSACTION_TYPE: ' || P_PARENT_TRANSACTION_TYPE , 1 ) ;
220: END IF;

Line 219: oe_debug_pub.add( 'PARENT_TRANSACTION_TYPE: ' || P_PARENT_TRANSACTION_TYPE , 1 ) ;

215: IF l_debug_level > 0 THEN
216: oe_debug_pub.add( 'QUANTITY: ' || P_QUANTITY , 1 ) ;
217: END IF;
218: IF l_debug_level > 0 THEN
219: oe_debug_pub.add( 'PARENT_TRANSACTION_TYPE: ' || P_PARENT_TRANSACTION_TYPE , 1 ) ;
220: END IF;
221: IF l_debug_level > 0 THEN
222: oe_debug_pub.add( 'TRANSACTION_TYPE: ' || P_TRANSACTION_TYPE , 1 ) ;
223: END IF;

Line 222: oe_debug_pub.add( 'TRANSACTION_TYPE: ' || P_TRANSACTION_TYPE , 1 ) ;

218: IF l_debug_level > 0 THEN
219: oe_debug_pub.add( 'PARENT_TRANSACTION_TYPE: ' || P_PARENT_TRANSACTION_TYPE , 1 ) ;
220: END IF;
221: IF l_debug_level > 0 THEN
222: oe_debug_pub.add( 'TRANSACTION_TYPE: ' || P_TRANSACTION_TYPE , 1 ) ;
223: END IF;
224: IF l_debug_level > 0 THEN
225: oe_debug_pub.add( 'MISMATCH_FLAG: ' || P_MISMATCH_FLAG , 1 ) ;
226: END IF;

Line 225: oe_debug_pub.add( 'MISMATCH_FLAG: ' || P_MISMATCH_FLAG , 1 ) ;

221: IF l_debug_level > 0 THEN
222: oe_debug_pub.add( 'TRANSACTION_TYPE: ' || P_TRANSACTION_TYPE , 1 ) ;
223: END IF;
224: IF l_debug_level > 0 THEN
225: oe_debug_pub.add( 'MISMATCH_FLAG: ' || P_MISMATCH_FLAG , 1 ) ;
226: END IF;
227:
228:
229: l_item_key := to_char(p_RMA_Line_id);

Line 292: oe_debug_pub.add( 'The Tolerance above is '||l_tolerance_above ) ;

288: b_dual_qty := TRUE;
289: END IF;
290:
291: IF l_debug_level > 0 THEN
292: oe_debug_pub.add( 'The Tolerance above is '||l_tolerance_above ) ;
293: oe_debug_pub.add( 'The Tolerance below is '||l_tolerance_below ) ;
294: END IF;
295:
296: -- Fix for Bug #1140815. Receiving module passes us the string 'NO PARENT'

Line 293: oe_debug_pub.add( 'The Tolerance below is '||l_tolerance_below ) ;

289: END IF;
290:
291: IF l_debug_level > 0 THEN
292: oe_debug_pub.add( 'The Tolerance above is '||l_tolerance_above ) ;
293: oe_debug_pub.add( 'The Tolerance below is '||l_tolerance_below ) ;
294: END IF;
295:
296: -- Fix for Bug #1140815. Receiving module passes us the string 'NO PARENT'
297: -- when receiving goods for the first time

Line 302: oe_debug_pub.add( 'PARENT IS NULL , TRX TYPE IS RECEIVE' ) ;

298: IF (p_parent_transaction_type is NULL OR
299: p_parent_transaction_type = OE_RMA_RECEIVING.G_RMA_NO_PARENT) THEN
300: IF (p_transaction_type = OE_RMA_RECEIVING.G_RMA_RECEIVE) THEN
301: IF l_debug_level > 0 THEN
302: oe_debug_pub.add( 'PARENT IS NULL , TRX TYPE IS RECEIVE' ) ;
303: END IF;
304:
305: -- update shipped_quantity
306: b_om_processing := TRUE;

Line 338: oe_debug_pub.add( 'UNDER RETURN:'||TO_CHAR ( P_QUANTITY ) ||'<'||TO_CHAR ( L_LINE_TBL ( 1 ) .ORDERED_QUANTITY+L_TOLERANCE_BELOW ) , 1 ) ;

334: IF (l_updated_quantity <
335: l_line_tbl(1).ordered_quantity - l_tolerance_below) then
336:
337: IF l_debug_level > 0 THEN
338: oe_debug_pub.add( 'UNDER RETURN:'||TO_CHAR ( P_QUANTITY ) ||'<'||TO_CHAR ( L_LINE_TBL ( 1 ) .ORDERED_QUANTITY+L_TOLERANCE_BELOW ) , 1 ) ;
339: END IF;
340:
341: l_open_line_rec.db_flag := FND_API.G_FALSE;
342: l_open_line_rec.ordered_quantity

Line 396: oe_debug_pub.add( 'PARENT IS RECEIVE , TRX TYPE IS ACCEPT/REJECT/DELIVER' ) ;

392: p_parent_transaction_type = OE_RMA_RECEIVING.G_RMA_MATCH) THEN
393: IF (p_transaction_type = G_RMA_DELIVER) THEN
394:
395: IF l_debug_level > 0 THEN
396: oe_debug_pub.add( 'PARENT IS RECEIVE , TRX TYPE IS ACCEPT/REJECT/DELIVER' ) ;
397: END IF;
398:
399: -- update fulfilled_quantity, and possibility to complete inspection.
400: b_om_processing := TRUE;

Line 436: oe_debug_pub.add( 'PARENT IS RECEIVE , TRX TYPE IS RETURN TO CUSTOMER' ) ;

432: END IF;
433:
434: ELSIF (p_transaction_type = OE_RMA_RECEIVING.G_RMA_RETURN_TO_CUSTOMER) THEN
435: IF l_debug_level > 0 THEN
436: oe_debug_pub.add( 'PARENT IS RECEIVE , TRX TYPE IS RETURN TO CUSTOMER' ) ;
437: END IF;
438:
439: -- update shipped_quantity
440: b_om_processing := TRUE;

Line 442: oe_debug_pub.add( 'PARENT IS RECEIVE , TRX TYPE IS RETURN TO CUSTOMER' ) ;

438:
439: -- update shipped_quantity
440: b_om_processing := TRUE;
441: IF l_debug_level > 0 THEN
442: oe_debug_pub.add( 'PARENT IS RECEIVE , TRX TYPE IS RETURN TO CUSTOMER' ) ;
443: END IF;
444:
445: l_updated_quantity := l_line_tbl(1).shipped_quantity - p_quantity;
446: IF b_dual_qty THEN

Line 462: oe_debug_pub.add( 'PARENT IS RECEIVE , TRX TYPE IS CORRECT' ) ;

458:
459:
460: ELSIF (p_transaction_type = OE_RMA_RECEIVING.G_RMA_CORRECT) THEN
461: IF l_debug_level > 0 THEN
462: oe_debug_pub.add( 'PARENT IS RECEIVE , TRX TYPE IS CORRECT' ) ;
463: END IF;
464:
465: -- update shipped_quantity and adjust remaining open quantity
466: b_om_processing := TRUE;

Line 479: oe_debug_pub.add('There is an Open Line Id' ) ;

475: l_open_line_id := Get_Open_Line_Id(l_line_tbl(1));
476:
477: IF (l_open_line_id is NOT NULL) THEN
478: IF l_debug_level > 0 THEN
479: oe_debug_pub.add('There is an Open Line Id' ) ;
480: END IF;
481: OE_Line_Util.Lock_Row
482: (p_line_id => l_open_line_id
483: ,p_x_line_rec => l_temp_open_line_rec

Line 495: oe_debug_pub.add( 'QUANTITY IS POSITIVE' ) ;

491: END IF;
492:
493: IF ( p_quantity > 0 ) THEN -- received more
494: IF l_debug_level > 0 THEN
495: oe_debug_pub.add( 'QUANTITY IS POSITIVE' ) ;
496: END IF;
497:
498: l_updated_quantity := l_line_tbl(1).shipped_quantity + p_quantity;
499: IF b_dual_qty THEN

Line 507: oe_debug_pub.add('Change is within tolerance' ) ;

503: -- Check if updated qty is within + tolerance
504: IF l_updated_quantity <=
505: (l_line_tbl(1).ordered_quantity + l_tolerance_above) THEN
506: IF l_debug_level > 0 THEN
507: oe_debug_pub.add('Change is within tolerance' ) ;
508: END IF;
509: -- adjust the shipped_quantity and ordered_quantity
510: l_line_tbl(1).shipped_quantity := l_updated_quantity;
511: IF b_dual_qty THEN

Line 520: oe_debug_pub.add( 'Above Tolerance, raise ERROR' ) ;

516: l_max_qty_to_adjust := l_line_tbl(1).ordered_quantity +
517: l_tolerance_above -
518: l_line_tbl(1).shipped_quantity;
519: IF l_debug_level > 0 THEN
520: oe_debug_pub.add( 'Above Tolerance, raise ERROR' ) ;
521: END IF;
522: IF l_open_line_id is NOT NULL THEN
523: l_line_number := l_temp_open_line_rec.line_number||'.'||
524: l_temp_open_line_rec.shipment_number;

Line 548: oe_debug_pub.add('For -ve correction ');

544: ELSE -- received less. adjust the qty of the current line,
545: -- and adjust the quantity of the open line.
546:
547: IF l_debug_level > 0 THEN
548: oe_debug_pub.add('For -ve correction ');
549: END IF;
550: -- adjust the shipped_quantity and ordered_quantity
551: l_updated_quantity := l_line_tbl(1).shipped_quantity + p_quantity;
552: l_line_tbl(1).shipped_quantity := l_updated_quantity;

Line 564: oe_debug_pub.add('No Open Line: l_updated QTY is '

560:
561: IF (l_open_line_id is NULL) THEN -- no open line
562:
563: IF l_debug_level > 0 THEN
564: oe_debug_pub.add('No Open Line: l_updated QTY is '
565: ||l_updated_quantity);
566: END IF;
567: IF ( l_updated_quantity not between
568: (l_line_tbl(1).ordered_quantity - l_tolerance_below) and

Line 580: oe_debug_pub.add('Split the current line ' );

576: l_open_line_rec.ordered_quantity2 := -p_quantity2;
577: -- 04/20/2001 OPM
578: END IF;
579: IF l_debug_level > 0 THEN
580: oe_debug_pub.add('Split the current line ' );
581: END IF;
582: l_open_line_rec.split_from_line_id := p_RMA_Line_ID;
583: l_open_line_rec.split_by := 'SYSTEM';
584: l_open_line_rec.operation := OE_GLOBALS.G_OPR_CREATE;

Line 599: oe_debug_pub.add('Take the line back to AWAITING_RETURN' );

595: b_negative_correction := TRUE;
596: ELSIF l_updated_quantity = 0 THEN
597: -- Take the received line back to AWAITING_RETURN
598: IF l_debug_level > 0 THEN
599: oe_debug_pub.add('Take the line back to AWAITING_RETURN' );
600: END IF;
601: b_neg_corr_zero_qty := TRUE;
602: l_line_tbl(1).shipped_quantity := NULL;
603: IF b_dual_qty THEN

Line 634: oe_debug_pub.add('Adjusting ordered qty on open line' );

630: l_line_tbl(1).ordered_quantity2 := l_updated_quantity2;
631: -- 04/20/2001 OPM
632: END IF;
633: IF l_debug_level > 0 THEN
634: oe_debug_pub.add('Adjusting ordered qty on open line' );
635: END IF;
636:
637: -- adjust the open ordered_quantity
638: l_open_line_rec := l_temp_open_line_rec;

Line 652: oe_debug_pub.add('Taking the line back to AWAITING_RETURN');

648: b_adjust_open_quantity := TRUE;
649: ELSIF l_updated_quantity = 0 THEN
650: -- Take the received line back to AWAITING_RETURN
651: IF l_debug_level > 0 THEN
652: oe_debug_pub.add('Taking the line back to AWAITING_RETURN');
653: END IF;
654: b_neg_corr_zero_qty := TRUE;
655: l_line_tbl(1).shipped_quantity := NULL;
656: IF b_dual_qty THEN

Line 675: oe_debug_pub.add( 'PARENT IS ACCEPT/REJECT , TRX TYPE IS DELIVER' ) ;

671: END IF;
672: ELSIF (p_parent_transaction_type in (G_RMA_ACCEPT,G_RMA_REJECT)) THEN
673: IF ( p_transaction_type = G_RMA_DELIVER) THEN
674: IF l_debug_level > 0 THEN
675: oe_debug_pub.add( 'PARENT IS ACCEPT/REJECT , TRX TYPE IS DELIVER' ) ;
676: END IF;
677:
678: -- update fulfilled_quantity, and possibility to complete inspection.
679: b_om_processing := TRUE;

Line 714: oe_debug_pub.add(' Profile : ONT_GENERATE_CREDIT_REJECTED_RETURNS : ' || l_credit_rejected_qty, 5);

710:
711: l_credit_rejected_qty := nvl(FND_PROFILE.VALUE('ONT_GENERATE_CREDIT_REJECTED_RETURNS'), 'N'); -- Added for bug 6052676
712:
713: IF l_debug_level > 0 THEN
714: oe_debug_pub.add(' Profile : ONT_GENERATE_CREDIT_REJECTED_RETURNS : ' || l_credit_rejected_qty, 5);
715: END IF;
716:
717:
718: /* Modified below IF and ELSIF conditions for bug 6052676 */

Line 750: oe_debug_pub.add( 'PARENT IS ACCEPT/REJECT , TRX TYPE IS RETURN TO CUSTOMER' ) ;

746: END IF;
747:
748: ELSIF (p_transaction_type = G_RMA_RETURN_TO_CUSTOMER) THEN
749: IF l_debug_level > 0 THEN
750: oe_debug_pub.add( 'PARENT IS ACCEPT/REJECT , TRX TYPE IS RETURN TO CUSTOMER' ) ;
751: END IF;
752:
753: -- update shipped_quantity
754: b_om_processing := TRUE;

Line 756: oe_debug_pub.add( 'PARENT IS RECEIVE , TRX TYPE IS RETURN TO CUSTOMER' ) ;

752:
753: -- update shipped_quantity
754: b_om_processing := TRUE;
755: IF l_debug_level > 0 THEN
756: oe_debug_pub.add( 'PARENT IS RECEIVE , TRX TYPE IS RETURN TO CUSTOMER' ) ;
757: END IF;
758:
759: l_updated_quantity := l_line_tbl(1).shipped_quantity - p_quantity;
760: IF b_dual_qty THEN

Line 780: oe_debug_pub.add( 'PARENT IS DELIVER , TRX TYPE IS RETURN TO CUSTOMER' ) ;

776: ELSIF (p_parent_transaction_type = OE_RMA_RECEIVING.G_RMA_DELIVER) THEN
777:
778: IF (p_transaction_type = OE_RMA_RECEIVING.G_RMA_RETURN_TO_CUSTOMER) THEN
779: IF l_debug_level > 0 THEN
780: oe_debug_pub.add( 'PARENT IS DELIVER , TRX TYPE IS RETURN TO CUSTOMER' ) ;
781: END IF;
782:
783: -- update shipped_quantity and fulfilled_quantity
784: b_om_processing := TRUE;

Line 802: oe_debug_pub.add( 'PARENT IS DELIVER , TRX TYPE IS RETURN TO CUSTOMER' ) ;

798:
799:
800: ELSIF (p_transaction_type = OE_RMA_RECEIVING.G_RMA_RETURN_TO_RECEIVING) THEN
801: IF l_debug_level > 0 THEN
802: oe_debug_pub.add( 'PARENT IS DELIVER , TRX TYPE IS RETURN TO CUSTOMER' ) ;
803: END IF;
804:
805: -- update fulfilled_quantity
806: b_om_processing := TRUE;

Line 820: oe_debug_pub.add( 'PARENT IS DELIVER , TRX TYPE IS RETURN TO CUSTOMER' ) ;

816:
817:
818: ELSIF (p_transaction_type = OE_RMA_RECEIVING.G_RMA_CORRECT) THEN
819: IF l_debug_level > 0 THEN
820: oe_debug_pub.add( 'PARENT IS DELIVER , TRX TYPE IS RETURN TO CUSTOMER' ) ;
821: END IF;
822:
823: -- update fulfilled_quantity
824: b_om_processing := TRUE;

Line 844: oe_debug_pub.add( 'PARENT IS RETURN TO CUST , TRX TYPE IS CORRECT' ) ;

840: OE_RMA_RECEIVING.G_RMA_RETURN_TO_CUSTOMER) THEN
841:
842: IF (p_transaction_type = OE_RMA_RECEIVING.G_RMA_CORRECT) THEN
843: IF l_debug_level > 0 THEN
844: oe_debug_pub.add( 'PARENT IS RETURN TO CUST , TRX TYPE IS CORRECT' ) ;
845: END IF;
846:
847: -- update shipped_quantity and fulfilled_quantity
848: b_om_processing := TRUE;

Line 896: oe_debug_pub.add( 'PARENT IS RETURN TO RECEIVING , TRX TYPE IS CORRECT' ) ;

892: OE_RMA_RECEIVING.G_RMA_RETURN_TO_RECEIVING) THEN
893:
894: IF (p_transaction_type = OE_RMA_RECEIVING.G_RMA_CORRECT) THEN
895: IF l_debug_level > 0 THEN
896: oe_debug_pub.add( 'PARENT IS RETURN TO RECEIVING , TRX TYPE IS CORRECT' ) ;
897: END IF;
898:
899: -- update fulfilled_quantity
900: b_om_processing := TRUE;

Line 917: oe_debug_pub.add( 'PARENT IS UNMATCHED ORDER , TRX TYPE IS MATCH ' ) ;

913: OE_RMA_RECEIVING.G_RMA_UNMATCHED_ORDER) THEN
914:
915: IF (p_transaction_type = OE_RMA_RECEIVING.G_RMA_MATCH) THEN
916: IF l_debug_level > 0 THEN
917: oe_debug_pub.add( 'PARENT IS UNMATCHED ORDER , TRX TYPE IS MATCH ' ) ;
918: END IF;
919:
920: -- update shipped_quantity
921: b_om_processing := TRUE;

Line 953: oe_debug_pub.add( 'UNDER RETURN:'||TO_CHAR ( P_QUANTITY ) ||'<'||TO_CHAR ( L_LINE_TBL ( 1 ) .ORDERED_QUANTITY+L_TOLERANCE_BELOW ) , 1 ) ;

949: IF (l_updated_quantity <
950: l_line_tbl(1).ordered_quantity - l_tolerance_below) then
951:
952: IF l_debug_level > 0 THEN
953: oe_debug_pub.add( 'UNDER RETURN:'||TO_CHAR ( P_QUANTITY ) ||'<'||TO_CHAR ( L_LINE_TBL ( 1 ) .ORDERED_QUANTITY+L_TOLERANCE_BELOW ) , 1 ) ;
954: END IF;
955:
956: l_open_line_rec.db_flag := FND_API.G_FALSE;
957: l_open_line_rec.ordered_quantity

Line 1007: oe_debug_pub.add( 'OM_PROCESSING , CALLING PROCESS ORDER' ) ;

1003: END IF; -- p_parent_transaction_type
1004:
1005: IF (b_om_processing) THEN
1006: IF l_debug_level > 0 THEN
1007: oe_debug_pub.add( 'OM_PROCESSING , CALLING PROCESS ORDER' ) ;
1008: END IF;
1009:
1010: IF (b_adjust_open_quantity) THEN
1011:

Line 1049: oe_debug_pub.add( 'PROCESS ORDER Return Status IS '||x_return_status);

1045: , p_x_action_request_tbl => l_x_Action_Request_tbl
1046: );
1047:
1048: IF l_debug_level > 0 THEN
1049: oe_debug_pub.add( 'PROCESS ORDER Return Status IS '||x_return_status);
1050: END IF;
1051: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1052: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1053: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

Line 1061: oe_debug_pub.add( 'In b_complete_receiving ');

1057: -- complete workflow activity
1058:
1059: IF (b_complete_receiving) THEN
1060: IF l_debug_level > 0 THEN
1061: oe_debug_pub.add( 'In b_complete_receiving ');
1062: END IF;
1063:
1064: WF_ENGINE.CompleteActivityInternalName('OEOL', l_item_key,
1065: 'RMA_WAIT_FOR_RECEIVING', 'COMPLETE');

Line 1070: oe_debug_pub.add( 'In b_complete_inspection ');

1066:
1067: ELSIF (b_complete_inspection) THEN
1068:
1069: IF l_debug_level > 0 THEN
1070: oe_debug_pub.add( 'In b_complete_inspection ');
1071: END IF;
1072: WF_ENGINE.CompleteActivityInternalName('OEOL', l_item_key,
1073: 'RMA_WAIT_FOR_INSPECTION', 'COMPLETE');
1074:

Line 1082: oe_debug_pub.add( 'In b_neg_corr_zero_qty ');

1078: IF (b_neg_corr_zero_qty) THEN
1079: l_item_key := to_char(l_line_tbl(1).line_id);
1080:
1081: IF l_debug_level > 0 THEN
1082: oe_debug_pub.add( 'In b_neg_corr_zero_qty ');
1083: END IF;
1084: WF_ENGINE.CompleteActivityInternalName('OEOL', l_item_key,
1085: 'RMA_WAIT_FOR_INSPECTION', 'CORRECT_RECEIVING');
1086: END IF;

Line 1092: oe_debug_pub.add( 'In b_negative_correction ');

1088: IF (b_negative_correction) THEN
1089: l_item_key := to_char(l_line_tbl(2).line_id);
1090:
1091: IF l_debug_level > 0 THEN
1092: oe_debug_pub.add( 'In b_negative_correction ');
1093: END IF;
1094: WF_ENGINE.CompleteActivityInternalName('OEOL', l_item_key,
1095: 'RMA_WAIT_FOR_INSPECTION', 'CORRECT_RECEIVING');
1096: ELSIF (b_positive_correction) THEN

Line 1098: oe_debug_pub.add( 'In b_positive_correction ');

1094: WF_ENGINE.CompleteActivityInternalName('OEOL', l_item_key,
1095: 'RMA_WAIT_FOR_INSPECTION', 'CORRECT_RECEIVING');
1096: ELSIF (b_positive_correction) THEN
1097: IF l_debug_level > 0 THEN
1098: oe_debug_pub.add( 'In b_positive_correction ');
1099: END IF;
1100: l_item_key := to_char(l_line_tbl(1).line_id);
1101:
1102: WF_ENGINE.CompleteActivityInternalName('OEOL', l_item_key,

Line 1110: oe_debug_pub.add( 'CALLING FLOW STATUS API 1 ' ||l_item_key ) ;

1106: -- Set the line Flow status
1107:
1108: IF b_complete_receiving or b_positive_correction THEN
1109: IF l_debug_level > 0 THEN
1110: oe_debug_pub.add( 'CALLING FLOW STATUS API 1 ' ||l_item_key ) ;
1111: END IF;
1112:
1113: OE_Order_WF_Util.Update_Flow_Status_Code
1114: (p_line_id => to_number(l_item_key),

Line 1120: oe_debug_pub.add( 'RETURN STATUS FROM FLOW STATUS API 1 '|| L_RETURN_STATUS , 1 ) ;

1116: x_return_status => l_return_status
1117: );
1118:
1119: IF l_debug_level > 0 THEN
1120: oe_debug_pub.add( 'RETURN STATUS FROM FLOW STATUS API 1 '|| L_RETURN_STATUS , 1 ) ;
1121: END IF;
1122:
1123: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1124: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1133: oe_debug_pub.add( 'CALLING FLOW STATUS API 2 ' ||l_item_key);

1129: END IF;
1130:
1131: IF b_complete_inspection THEN
1132: IF l_debug_level > 0 THEN
1133: oe_debug_pub.add( 'CALLING FLOW STATUS API 2 ' ||l_item_key);
1134: END IF;
1135:
1136: OE_Order_WF_Util.Update_Flow_Status_Code
1137: (p_line_id => to_number(l_item_key),

Line 1143: oe_debug_pub.add( 'RETURN STATUS FROM FLOW STATUS API 2'|| L_RETURN_STATUS , 1 ) ;

1139: x_return_status => l_return_status
1140: );
1141:
1142: IF l_debug_level > 0 THEN
1143: oe_debug_pub.add( 'RETURN STATUS FROM FLOW STATUS API 2'|| L_RETURN_STATUS , 1 ) ;
1144: END IF;
1145:
1146: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1147: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1157: oe_debug_pub.add('Returning From Push_Receiving_Info '|| x_return_status);

1153:
1154: END IF; -- if b_om_processing.
1155:
1156: IF l_debug_level > 0 THEN
1157: oe_debug_pub.add('Returning From Push_Receiving_Info '|| x_return_status);
1158: END IF;
1159:
1160: EXCEPTION
1161:

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

1213:
1214: l_open_line_id NUMBER;
1215:
1216: --
1217: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1218: --
1219: BEGIN
1220:
1221: SELECT l.line_id

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

1265: l_ordered_quantity NUMBER;
1266: l_shipped_quantity NUMBER;
1267: l_line_set_id NUMBER;
1268: --
1269: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1270: --
1271: BEGIN
1272: -- OE_GLOBALS.set_context; -- removed for MOAC.
1273: IF l_debug_level > 0 THEN

Line 1274: oe_debug_pub.add( 'G_ORG_ID='||TO_CHAR ( OE_GLOBALS.G_ORG_ID ) , 1 ) ;

1270: --
1271: BEGIN
1272: -- OE_GLOBALS.set_context; -- removed for MOAC.
1273: IF l_debug_level > 0 THEN
1274: oe_debug_pub.add( 'G_ORG_ID='||TO_CHAR ( OE_GLOBALS.G_ORG_ID ) , 1 ) ;
1275: END IF;
1276: SELECT open_flag,
1277: invoice_interface_status_code,
1278: ordered_quantity,

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

1341:
1342: )
1343: IS
1344: --
1345: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1346: --
1347: BEGIN
1348:
1349: x_return_status := FND_API.G_RET_STS_SUCCESS;