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 192: oe_debug_pub.initialize;

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

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

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

Line 194: oe_debug_pub.debug_on;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 286: oe_debug_pub.add( 'Copying quantities into local variables') ;

282: END IF;
283:
284: --Starting of changes in bug 12798879
285: IF l_debug_level > 0 THEN
286: oe_debug_pub.add( 'Copying quantities into local variables') ;
287: END IF;
288: l_quantity := p_quantity;
289: l_quantity2 := p_quantity2;
290: --Ending of changes in bug 12798879

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

297: b_dual_qty := TRUE;
298: END IF;
299:
300: IF l_debug_level > 0 THEN
301: oe_debug_pub.add( 'The Tolerance above is '||l_tolerance_above ) ;
302: oe_debug_pub.add( 'The Tolerance below is '||l_tolerance_below ) ;
303: END IF;
304: --Starting of changes in bug 12798879
305: IF l_ship_sec_qty='Y' AND

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

298: END IF;
299:
300: IF l_debug_level > 0 THEN
301: oe_debug_pub.add( 'The Tolerance above is '||l_tolerance_above ) ;
302: oe_debug_pub.add( 'The Tolerance below is '||l_tolerance_below ) ;
303: END IF;
304: --Starting of changes in bug 12798879
305: IF l_ship_sec_qty='Y' AND
306: b_dual_qty AND

Line 312: oe_debug_pub.add( 'Planning to update shipped qty with secondary qty with qty: '||l_quantity ) ;

308:
309: l_quantity :=l_quantity2;
310:
311: IF l_debug_level > 0 THEN
312: oe_debug_pub.add( 'Planning to update shipped qty with secondary qty with qty: '||l_quantity ) ;
313: END IF;
314: END IF ;
315: --Ending of changes in bug 12798879
316: -- Fix for Bug #1140815. Receiving module passes us the string 'NO PARENT'

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

318: IF (p_parent_transaction_type is NULL OR
319: p_parent_transaction_type = OE_RMA_RECEIVING.G_RMA_NO_PARENT) THEN
320: IF (p_transaction_type = OE_RMA_RECEIVING.G_RMA_RECEIVE) THEN
321: IF l_debug_level > 0 THEN
322: oe_debug_pub.add( 'PARENT IS NULL , TRX TYPE IS RECEIVE' ) ;
323: END IF;
324:
325: -- update shipped_quantity
326: b_om_processing := TRUE;

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

354: IF (l_updated_quantity <
355: l_line_tbl(1).ordered_quantity - l_tolerance_below) then
356:
357: IF l_debug_level > 0 THEN
358: oe_debug_pub.add( 'UNDER RETURN:'||TO_CHAR ( l_quantity ) ||'<'||TO_CHAR ( L_LINE_TBL ( 1 ) .ORDERED_QUANTITY+L_TOLERANCE_BELOW ) , 1 ) ;
359: END IF;
360:
361: l_open_line_rec.db_flag := FND_API.G_FALSE;
362: l_open_line_rec.ordered_quantity

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

426: p_parent_transaction_type = OE_RMA_RECEIVING.G_RMA_MATCH) THEN
427: IF (p_transaction_type = G_RMA_DELIVER) THEN
428:
429: IF l_debug_level > 0 THEN
430: oe_debug_pub.add( 'PARENT IS RECEIVE , TRX TYPE IS ACCEPT/REJECT/DELIVER' ) ;
431: END IF;
432:
433: -- update fulfilled_quantity, and possibility to complete inspection.
434: b_om_processing := TRUE;

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

466: END IF;
467:
468: ELSIF (p_transaction_type = OE_RMA_RECEIVING.G_RMA_RETURN_TO_CUSTOMER) THEN
469: IF l_debug_level > 0 THEN
470: oe_debug_pub.add( 'PARENT IS RECEIVE , TRX TYPE IS RETURN TO CUSTOMER' ) ;
471: END IF;
472:
473: -- update shipped_quantity
474: b_om_processing := TRUE;

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

472:
473: -- update shipped_quantity
474: b_om_processing := TRUE;
475: IF l_debug_level > 0 THEN
476: oe_debug_pub.add( 'PARENT IS RECEIVE , TRX TYPE IS RETURN TO CUSTOMER' ) ;
477: END IF;
478:
479: l_updated_quantity := l_line_tbl(1).shipped_quantity - l_quantity;
480: IF b_dual_qty THEN

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

496:
497:
498: ELSIF (p_transaction_type = OE_RMA_RECEIVING.G_RMA_CORRECT) THEN
499: IF l_debug_level > 0 THEN
500: oe_debug_pub.add( 'PARENT IS RECEIVE , TRX TYPE IS CORRECT' ) ;
501: END IF;
502:
503: -- update shipped_quantity and adjust remaining open quantity
504: b_om_processing := TRUE;

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

513: l_open_line_id := Get_Open_Line_Id(l_line_tbl(1));
514:
515: IF (l_open_line_id is NOT NULL) THEN
516: IF l_debug_level > 0 THEN
517: oe_debug_pub.add('There is an Open Line Id' ) ;
518: END IF;
519: OE_Line_Util.Lock_Row
520: (p_line_id => l_open_line_id
521: ,p_x_line_rec => l_temp_open_line_rec

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

529: END IF;
530:
531: IF ( l_quantity > 0 ) THEN -- received more
532: IF l_debug_level > 0 THEN
533: oe_debug_pub.add( 'QUANTITY IS POSITIVE' ) ;
534: END IF;
535:
536: l_updated_quantity := l_line_tbl(1).shipped_quantity + l_quantity;
537: IF b_dual_qty THEN

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

541: -- Check if updated qty is within + tolerance
542: IF l_updated_quantity <=
543: (l_line_tbl(1).ordered_quantity + l_tolerance_above) THEN
544: IF l_debug_level > 0 THEN
545: oe_debug_pub.add('Change is within tolerance' ) ;
546: END IF;
547: -- adjust the shipped_quantity and ordered_quantity
548: l_line_tbl(1).shipped_quantity := l_updated_quantity;
549: IF b_dual_qty THEN

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

554: l_max_qty_to_adjust := l_line_tbl(1).ordered_quantity +
555: l_tolerance_above -
556: l_line_tbl(1).shipped_quantity;
557: IF l_debug_level > 0 THEN
558: oe_debug_pub.add( 'Above Tolerance, raise ERROR' ) ;
559: END IF;
560: IF l_open_line_id is NOT NULL THEN
561: l_line_number := l_temp_open_line_rec.line_number||'.'||
562: l_temp_open_line_rec.shipment_number;

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

582: ELSE -- received less. adjust the qty of the current line,
583: -- and adjust the quantity of the open line.
584:
585: IF l_debug_level > 0 THEN
586: oe_debug_pub.add('For -ve correction ');
587: END IF;
588: -- adjust the shipped_quantity and ordered_quantity
589: l_updated_quantity := l_line_tbl(1).shipped_quantity + l_quantity;
590: l_line_tbl(1).shipped_quantity := l_updated_quantity;

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

598:
599: IF (l_open_line_id is NULL) THEN -- no open line
600:
601: IF l_debug_level > 0 THEN
602: oe_debug_pub.add('No Open Line: l_updated QTY is '
603: ||l_updated_quantity);
604: END IF;
605: IF ( l_updated_quantity not between
606: (l_line_tbl(1).ordered_quantity - l_tolerance_below) and

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

614: l_open_line_rec.ordered_quantity2 := -l_quantity2;
615: -- 04/20/2001 OPM
616: END IF;
617: IF l_debug_level > 0 THEN
618: oe_debug_pub.add('Split the current line ' );
619: END IF;
620: l_open_line_rec.split_from_line_id := p_RMA_Line_ID;
621: l_open_line_rec.split_by := 'SYSTEM';
622: l_open_line_rec.operation := OE_GLOBALS.G_OPR_CREATE;

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

633: b_negative_correction := TRUE;
634: ELSIF l_updated_quantity = 0 THEN
635: -- Take the received line back to AWAITING_RETURN
636: IF l_debug_level > 0 THEN
637: oe_debug_pub.add('Take the line back to AWAITING_RETURN' );
638: END IF;
639: b_neg_corr_zero_qty := TRUE;
640: l_line_tbl(1).shipped_quantity := NULL;
641: IF b_dual_qty THEN

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

668: l_line_tbl(1).ordered_quantity2 := l_updated_quantity2;
669: -- 04/20/2001 OPM
670: END IF;
671: IF l_debug_level > 0 THEN
672: oe_debug_pub.add('Adjusting ordered qty on open line' );
673: END IF;
674:
675: -- adjust the open ordered_quantity
676: l_open_line_rec := l_temp_open_line_rec;

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

693: --End bug 16284063
694: ELSIF l_updated_quantity = 0 THEN
695: -- Take the received line back to AWAITING_RETURN
696: IF l_debug_level > 0 THEN
697: oe_debug_pub.add('Taking the line back to AWAITING_RETURN');
698: END IF;
699: b_neg_corr_zero_qty := TRUE;
700: l_line_tbl(1).shipped_quantity := NULL;
701: IF b_dual_qty THEN

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

716: END IF;
717: ELSIF (p_parent_transaction_type in (G_RMA_ACCEPT,G_RMA_REJECT)) THEN
718: IF ( p_transaction_type = G_RMA_DELIVER) THEN
719: IF l_debug_level > 0 THEN
720: oe_debug_pub.add( 'PARENT IS ACCEPT/REJECT , TRX TYPE IS DELIVER' ) ;
721: END IF;
722:
723: -- update fulfilled_quantity, and possibility to complete inspection.
724: b_om_processing := TRUE;

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

755:
756: l_credit_rejected_qty := nvl(FND_PROFILE.VALUE('ONT_GENERATE_CREDIT_REJECTED_RETURNS'), 'N'); -- Added for bug 6052676
757:
758: IF l_debug_level > 0 THEN
759: oe_debug_pub.add(' Profile : ONT_GENERATE_CREDIT_REJECTED_RETURNS : ' || l_credit_rejected_qty, 5);
760: END IF;
761:
762:
763: /* Modified below IF and ELSIF conditions for bug 6052676 */

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

791: END IF;
792:
793: ELSIF (p_transaction_type = G_RMA_RETURN_TO_CUSTOMER) THEN
794: IF l_debug_level > 0 THEN
795: oe_debug_pub.add( 'PARENT IS ACCEPT/REJECT , TRX TYPE IS RETURN TO CUSTOMER' ) ;
796: END IF;
797:
798: -- update shipped_quantity
799: b_om_processing := TRUE;

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

797:
798: -- update shipped_quantity
799: b_om_processing := TRUE;
800: IF l_debug_level > 0 THEN
801: oe_debug_pub.add( 'PARENT IS RECEIVE , TRX TYPE IS RETURN TO CUSTOMER' ) ;
802: END IF;
803:
804: l_updated_quantity := l_line_tbl(1).shipped_quantity - l_quantity;
805: IF b_dual_qty THEN

Line 827: oe_debug_pub.add( 'Cancelling line' ) ;

823: l_control_rec.check_security := TRUE; --Mandatory for cancelling line
824: l_line_tbl(1).change_reason := 'Not provided';
825: l_line_tbl(1).change_comments := 'Goods rejected and returned to customer';
826: IF l_debug_level > 0 THEN
827: oe_debug_pub.add( 'Cancelling line' ) ;
828: END IF;
829: --Changes ended for fix 13872015
830: END IF;
831: END IF;

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

832: ELSIF (p_parent_transaction_type = OE_RMA_RECEIVING.G_RMA_DELIVER) THEN
833:
834: IF (p_transaction_type = OE_RMA_RECEIVING.G_RMA_RETURN_TO_CUSTOMER) THEN
835: IF l_debug_level > 0 THEN
836: oe_debug_pub.add( 'PARENT IS DELIVER , TRX TYPE IS RETURN TO CUSTOMER' ) ;
837: END IF;
838:
839: -- update shipped_quantity and fulfilled_quantity
840: b_om_processing := TRUE;

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

854:
855:
856: ELSIF (p_transaction_type = OE_RMA_RECEIVING.G_RMA_RETURN_TO_RECEIVING) THEN
857: IF l_debug_level > 0 THEN
858: oe_debug_pub.add( 'PARENT IS DELIVER , TRX TYPE IS RETURN TO CUSTOMER' ) ;
859: END IF;
860:
861: -- update fulfilled_quantity
862: b_om_processing := TRUE;

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

872:
873:
874: ELSIF (p_transaction_type = OE_RMA_RECEIVING.G_RMA_CORRECT) THEN
875: IF l_debug_level > 0 THEN
876: oe_debug_pub.add( 'PARENT IS DELIVER , TRX TYPE IS RETURN TO CUSTOMER' ) ;
877: END IF;
878:
879: -- update fulfilled_quantity
880: b_om_processing := TRUE;

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

896: OE_RMA_RECEIVING.G_RMA_RETURN_TO_CUSTOMER) THEN
897:
898: IF (p_transaction_type = OE_RMA_RECEIVING.G_RMA_CORRECT) THEN
899: IF l_debug_level > 0 THEN
900: oe_debug_pub.add( 'PARENT IS RETURN TO CUST , TRX TYPE IS CORRECT' ) ;
901: END IF;
902:
903: -- update shipped_quantity and fulfilled_quantity
904: b_om_processing := TRUE;

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

948: OE_RMA_RECEIVING.G_RMA_RETURN_TO_RECEIVING) THEN
949:
950: IF (p_transaction_type = OE_RMA_RECEIVING.G_RMA_CORRECT) THEN
951: IF l_debug_level > 0 THEN
952: oe_debug_pub.add( 'PARENT IS RETURN TO RECEIVING , TRX TYPE IS CORRECT' ) ;
953: END IF;
954:
955: -- update fulfilled_quantity
956: b_om_processing := TRUE;

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

969: OE_RMA_RECEIVING.G_RMA_UNMATCHED_ORDER) THEN
970:
971: IF (p_transaction_type = OE_RMA_RECEIVING.G_RMA_MATCH) THEN
972: IF l_debug_level > 0 THEN
973: oe_debug_pub.add( 'PARENT IS UNMATCHED ORDER , TRX TYPE IS MATCH ' ) ;
974: END IF;
975:
976: -- update shipped_quantity
977: b_om_processing := TRUE;

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

1005: IF (l_updated_quantity <
1006: l_line_tbl(1).ordered_quantity - l_tolerance_below) then
1007:
1008: IF l_debug_level > 0 THEN
1009: oe_debug_pub.add( 'UNDER RETURN:'||TO_CHAR ( l_quantity ) ||'<'||TO_CHAR ( L_LINE_TBL ( 1 ) .ORDERED_QUANTITY+L_TOLERANCE_BELOW ) , 1 ) ;
1010: END IF;
1011:
1012: l_open_line_rec.db_flag := FND_API.G_FALSE;
1013: l_open_line_rec.ordered_quantity

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

1059: END IF; -- p_parent_transaction_type
1060:
1061: IF (b_om_processing) THEN
1062: IF l_debug_level > 0 THEN
1063: oe_debug_pub.add( 'OM_PROCESSING , CALLING PROCESS ORDER' ) ;
1064: END IF;
1065:
1066: IF (b_adjust_open_quantity) THEN
1067:

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

1101: , p_x_action_request_tbl => l_x_Action_Request_tbl
1102: );
1103:
1104: IF l_debug_level > 0 THEN
1105: oe_debug_pub.add( 'PROCESS ORDER Return Status IS '||x_return_status);
1106: END IF;
1107: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1108: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1109: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

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

1113: -- complete workflow activity
1114:
1115: IF (b_complete_receiving) THEN
1116: IF l_debug_level > 0 THEN
1117: oe_debug_pub.add( 'In b_complete_receiving ');
1118: END IF;
1119: BEGIN
1120: WF_ENGINE.CompleteActivityInternalName('OEOL', l_item_key,
1121: 'RMA_WAIT_FOR_RECEIVING', 'COMPLETE',true);--14599978

Line 1124: oe_debug_pub.add('Workflow complete activity failed. Raising');

1120: WF_ENGINE.CompleteActivityInternalName('OEOL', l_item_key,
1121: 'RMA_WAIT_FOR_RECEIVING', 'COMPLETE',true);--14599978
1122: EXCEPTION
1123: WHEN OTHERS THEN
1124: oe_debug_pub.add('Workflow complete activity failed. Raising');
1125: RAISE ;
1126: END ;
1127:
1128: ELSIF (b_complete_inspection) THEN

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

1127:
1128: ELSIF (b_complete_inspection) THEN
1129:
1130: IF l_debug_level > 0 THEN
1131: oe_debug_pub.add( 'In b_complete_inspection ');
1132: END IF;
1133: BEGIN
1134: WF_ENGINE.CompleteActivityInternalName('OEOL', l_item_key,
1135: 'RMA_WAIT_FOR_INSPECTION', 'COMPLETE',TRUE );--14599978

Line 1138: oe_debug_pub.add('Workflow complete activity failed. Raising');

1134: WF_ENGINE.CompleteActivityInternalName('OEOL', l_item_key,
1135: 'RMA_WAIT_FOR_INSPECTION', 'COMPLETE',TRUE );--14599978
1136: EXCEPTION
1137: WHEN OTHERS THEN
1138: oe_debug_pub.add('Workflow complete activity failed. Raising');
1139: RAISE ;
1140: END ;
1141:
1142: END IF; -- complete wf activity

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

1145: IF (b_neg_corr_zero_qty) THEN
1146: l_item_key := to_char(l_line_tbl(1).line_id);
1147:
1148: IF l_debug_level > 0 THEN
1149: oe_debug_pub.add( 'In b_neg_corr_zero_qty ');
1150: END IF;
1151: BEGIN
1152: WF_ENGINE.CompleteActivityInternalName('OEOL', l_item_key,
1153: 'RMA_WAIT_FOR_INSPECTION', 'CORRECT_RECEIVING',TRUE ); --14599978

Line 1156: oe_debug_pub.add('Workflow complete activity failed. Raising');

1152: WF_ENGINE.CompleteActivityInternalName('OEOL', l_item_key,
1153: 'RMA_WAIT_FOR_INSPECTION', 'CORRECT_RECEIVING',TRUE ); --14599978
1154: EXCEPTION
1155: WHEN OTHERS THEN
1156: oe_debug_pub.add('Workflow complete activity failed. Raising');
1157: RAISE ;
1158: END ;
1159: END IF;
1160:

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

1161: IF (b_negative_correction) THEN
1162: l_item_key := to_char(l_line_tbl(2).line_id);
1163:
1164: IF l_debug_level > 0 THEN
1165: oe_debug_pub.add( 'In b_negative_correction ');
1166: END IF;
1167: BEGIN
1168: WF_ENGINE.CompleteActivityInternalName('OEOL', l_item_key,
1169: 'RMA_WAIT_FOR_INSPECTION', 'CORRECT_RECEIVING',TRUE ); --14599978

Line 1172: oe_debug_pub.add('Workflow complete activity failed. Raising');

1168: WF_ENGINE.CompleteActivityInternalName('OEOL', l_item_key,
1169: 'RMA_WAIT_FOR_INSPECTION', 'CORRECT_RECEIVING',TRUE ); --14599978
1170: EXCEPTION
1171: WHEN OTHERS THEN
1172: oe_debug_pub.add('Workflow complete activity failed. Raising');
1173: RAISE ;
1174: END ;
1175: ELSIF (b_positive_correction) THEN
1176: IF l_debug_level > 0 THEN

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

1173: RAISE ;
1174: END ;
1175: ELSIF (b_positive_correction) THEN
1176: IF l_debug_level > 0 THEN
1177: oe_debug_pub.add( 'In b_positive_correction ');
1178: END IF;
1179: l_item_key := to_char(l_line_tbl(1).line_id);
1180: BEGIN
1181: WF_ENGINE.CompleteActivityInternalName('OEOL', l_item_key,

Line 1185: oe_debug_pub.add('Workflow complete activity failed. Raising');

1181: WF_ENGINE.CompleteActivityInternalName('OEOL', l_item_key,
1182: 'RMA_WAIT_FOR_RECEIVING', 'COMPLETE',TRUE ); --14599978
1183: EXCEPTION
1184: WHEN OTHERS THEN
1185: oe_debug_pub.add('Workflow complete activity failed. Raising');
1186: RAISE ;
1187: END ;
1188: END IF;
1189:

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

1190: -- Set the line Flow status
1191:
1192: IF b_complete_receiving or b_positive_correction THEN
1193: IF l_debug_level > 0 THEN
1194: oe_debug_pub.add( 'CALLING FLOW STATUS API 1 ' ||l_item_key ) ;
1195: END IF;
1196:
1197: OE_Order_WF_Util.Update_Flow_Status_Code
1198: (p_line_id => to_number(l_item_key),

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

1200: x_return_status => l_return_status
1201: );
1202:
1203: IF l_debug_level > 0 THEN
1204: oe_debug_pub.add( 'RETURN STATUS FROM FLOW STATUS API 1 '|| L_RETURN_STATUS , 1 ) ;
1205: END IF;
1206:
1207: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1208: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

1213: END IF;
1214: --Additional condition for bug 16284063
1215: IF b_complete_inspection AND NOT b_negative_correction THEN
1216: IF l_debug_level > 0 THEN
1217: oe_debug_pub.add( 'CALLING FLOW STATUS API 2 ' ||l_item_key);
1218: END IF;
1219:
1220: OE_Order_WF_Util.Update_Flow_Status_Code
1221: (p_line_id => to_number(l_item_key),

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

1223: x_return_status => l_return_status
1224: );
1225:
1226: IF l_debug_level > 0 THEN
1227: oe_debug_pub.add( 'RETURN STATUS FROM FLOW STATUS API 2'|| L_RETURN_STATUS , 1 ) ;
1228: END IF;
1229:
1230: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1231: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1240: oe_debug_pub.add( 'CALLING FLOW STATUS API 3 ' ||l_item_key);

1236: END IF;
1237: --Start bug 16284063
1238: IF b_complete_inspection AND b_negative_correction THEN
1239: IF l_debug_level > 0 THEN
1240: oe_debug_pub.add( 'CALLING FLOW STATUS API 3 ' ||l_item_key);
1241: END IF;
1242:
1243: OE_Order_WF_Util.Update_Flow_Status_Code
1244: (p_line_id => to_number(l_item_key),

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

1246: x_return_status => l_return_status
1247: );
1248:
1249: IF l_debug_level > 0 THEN
1250: oe_debug_pub.add( 'RETURN STATUS FROM FLOW STATUS API 3'|| L_RETURN_STATUS , 1 ) ;
1251: END IF;
1252:
1253: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1254: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

1262:
1263: END IF; -- if b_om_processing.
1264:
1265: IF l_debug_level > 0 THEN
1266: oe_debug_pub.add('Returning From Push_Receiving_Info '|| x_return_status);
1267: END IF;
1268:
1269: EXCEPTION
1270:

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

1322:
1323: l_open_line_id NUMBER;
1324:
1325: --
1326: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1327: --
1328: BEGIN
1329:
1330: SELECT l.line_id

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

1374: l_ordered_quantity NUMBER;
1375: l_shipped_quantity NUMBER;
1376: l_line_set_id NUMBER;
1377: --
1378: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1379: --
1380: BEGIN
1381: -- OE_GLOBALS.set_context; -- removed for MOAC.
1382: IF l_debug_level > 0 THEN

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

1379: --
1380: BEGIN
1381: -- OE_GLOBALS.set_context; -- removed for MOAC.
1382: IF l_debug_level > 0 THEN
1383: oe_debug_pub.add( 'G_ORG_ID='||TO_CHAR ( OE_GLOBALS.G_ORG_ID ) , 1 ) ;
1384: END IF;
1385: SELECT open_flag,
1386: invoice_interface_status_code,
1387: ordered_quantity,

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

1450:
1451: )
1452: IS
1453: --
1454: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1455: --
1456: BEGIN
1457:
1458: x_return_status := FND_API.G_RET_STS_SUCCESS;