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

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

103: x_reservation_id NUMBER;
104:
105: -- HW end of chanegs for 2536589 */
106: --
107: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
108: l_trx_date_for_inv_iface DATE; --bug5897965
109: --10295156
110: l_qty_to_reserve NUMBER;
111: l_primary_uom VARCHAR2(3);

Line 127: oe_debug_pub.add( 'INV IFACE: ENTERING INVENTORY INTERFACE' , 1 ) ;

123:
124: SAVEPOINT INVENTORY_INTERFACE;
125:
126: IF l_debug_level > 0 THEN
127: oe_debug_pub.add( 'INV IFACE: ENTERING INVENTORY INTERFACE' , 1 ) ;
128: END IF;
129: x_return_status := FND_API.G_RET_STS_SUCCESS;
130: x_result_out := OE_GLOBALS.G_WFR_COMPLETE;
131:

Line 164: oe_debug_pub.add( 'INV IFACE: ACTIVITY ON HOLD , EXITING' , 5 ) ;

160: OE_MSG_PUB.ADD;
161: x_return_status := FND_API.G_RET_STS_ERROR;
162: x_result_out := OE_GLOBALS.G_WFR_ON_HOLD;
163: IF l_debug_level > 0 THEN
164: oe_debug_pub.add( 'INV IFACE: ACTIVITY ON HOLD , EXITING' , 5 ) ;
165: END IF;
166: RETURN;
167: ELSIF l_hold_return_status <> FND_API.G_RET_STS_SUCCESS THEN
168: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 170: oe_debug_pub.add( 'INV IFACE: CHECK HOLD API ERROR' , 5 ) ;

166: RETURN;
167: ELSIF l_hold_return_status <> FND_API.G_RET_STS_SUCCESS THEN
168: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
169: IF l_debug_level > 0 THEN
170: oe_debug_pub.add( 'INV IFACE: CHECK HOLD API ERROR' , 5 ) ;
171: END IF;
172: RETURN;
173: END IF;
174:

Line 183: oe_debug_pub.add( 'INV IFACE: LOCK_ROW FAILED' , 5 ) ;

179: , x_return_status => l_return_status
180: );
181: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
182: IF l_debug_level > 0 THEN
183: oe_debug_pub.add( 'INV IFACE: LOCK_ROW FAILED' , 5 ) ;
184: END IF;
185: x_return_status := FND_API.G_RET_STS_ERROR;
186: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
187: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 189: oe_debug_pub.add( 'INV IFACE: LOCK_ROW FAILED' , 5 ) ;

185: x_return_status := FND_API.G_RET_STS_ERROR;
186: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
187: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
188: IF l_debug_level > 0 THEN
189: oe_debug_pub.add( 'INV IFACE: LOCK_ROW FAILED' , 5 ) ;
190: END IF;
191: x_return_status := FND_API.G_RET_STS_ERROR;
192: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
193: END IF;

Line 207: oe_debug_pub.add( 'INV IFACE: LOCK_ROW COMPLETED' , 5 ) ;

203: ,p_order_source_id => l_line_rec.order_source_id
204: ,p_source_document_type_id => l_line_rec.source_document_type_id);
205:
206: IF l_debug_level > 0 THEN
207: oe_debug_pub.add( 'INV IFACE: LOCK_ROW COMPLETED' , 5 ) ;
208: END IF;
209:
210:
211: SELECT MTL_TRANSACTIONS_ENABLED_FLAG

Line 224: oe_debug_pub.add( 'INV IFACE: INV IFACE NOT ELIGIBLE - EXTERNAL OR NON TRANSACTABLE' , 5 ) ;

220: l_transactable_flag <> 'Y' THEN
221: x_return_status := FND_API.G_RET_STS_SUCCESS;
222: x_result_out := OE_GLOBALS.G_WFR_NOT_ELIGIBLE;
223: IF l_debug_level > 0 THEN
224: oe_debug_pub.add( 'INV IFACE: INV IFACE NOT ELIGIBLE - EXTERNAL OR NON TRANSACTABLE' , 5 ) ;
225: END IF;
226: RETURN;
227: END IF;
228:

Line 231: oe_debug_pub.add( 'INV IFACE: INV IFACE INCOMPLETE - NO WAREHOUSE' , 5 ) ;

227: END IF;
228:
229: IF l_line_rec.ship_from_org_id is null THEN
230: IF l_debug_level > 0 THEN
231: oe_debug_pub.add( 'INV IFACE: INV IFACE INCOMPLETE - NO WAREHOUSE' , 5 ) ;
232: END IF;
233: FND_MESSAGE.SET_NAME('ONT', 'OE_INV_NO_WAREHOUSE');
234: OE_MSG_PUB.ADD;
235: x_return_status := FND_API.G_RET_STS_ERROR;

Line 275: OE_DEBUG_PUB.add('Transaction Date derived from system parameter setup is '||l_trx_date_for_inv_iface,1);

271: INTO l_trx_date_for_inv_iface
272: FROM DUAL;
273:
274: IF l_debug_level > 0 THEN
275: OE_DEBUG_PUB.add('Transaction Date derived from system parameter setup is '||l_trx_date_for_inv_iface,1);
276: END IF;
277: --bug5897965, end
278:
279: IF OE_FLEX_COGS_PUB.Start_Process (

Line 294: oe_debug_pub.add( 'INV IFACE: COGS FAIL' , 5 ) ;

290: -- we will return INCOMPLETE
291:
292: l_trans_acc := NULL;
293: IF l_debug_level > 0 THEN
294: oe_debug_pub.add( 'INV IFACE: COGS FAIL' , 5 ) ;
295: END IF;
296: x_return_status := FND_API.G_RET_STS_ERROR;
297: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
298: RETURN;

Line 314: oe_debug_pub.add( 'INV IFACE: REVISION/LOT SELECT FAILURE' , 5 ) ;

310: AND organization_id = l_line_rec.ship_from_org_id;
311: EXCEPTION
312: WHEN OTHERS THEN
313: IF l_debug_level > 0 THEN
314: oe_debug_pub.add( 'INV IFACE: REVISION/LOT SELECT FAILURE' , 5 ) ;
315: END IF;
316: x_return_status := FND_API.G_RET_STS_ERROR;
317: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
318: RETURN;

Line 324: oe_debug_pub.add( 'INV IFACE: ITEM UNDER SERIAL CONTORL: ' || l_serial_code , 5 ) ;

320:
321: -- After ER 8419373 we support serial numbers
322: IF nvl(l_serial_code, 1) <> 1 THEN
323: IF l_debug_level > 0 THEN
324: oe_debug_pub.add( 'INV IFACE: ITEM UNDER SERIAL CONTORL: ' || l_serial_code , 5 ) ;
325: END IF;
326: /* ER 8419373
327: -- give a message here
328: FND_MESSAGE.SET_NAME('ONT', 'OE_INV_IFACE_SERIAL');

Line 349: oe_debug_pub.add( 'INV IFACE: ITEM UNDER REVISION CONTROL' , 5 ) ;

345: END IF;
346:
347: IF l_revision_code = 2 THEN
348: IF l_debug_level > 0 THEN
349: oe_debug_pub.add( 'INV IFACE: ITEM UNDER REVISION CONTROL' , 5 ) ;
350: END IF;
351: l_revision := 'Y';
352: END IF;
353:

Line 356: oe_debug_pub.add( 'INV IFACE: ITEM UNDER LOT CONTROL' , 5 ) ;

352: END IF;
353:
354: IF l_lot_code = 2 THEN
355: IF l_debug_level > 0 THEN
356: oe_debug_pub.add( 'INV IFACE: ITEM UNDER LOT CONTROL' , 5 ) ;
357: END IF;
358: l_lot := 'Y';
359: END IF;
360:

Line 364: oe_debug_pub.add( 'INV IFACE: ITEM UNDER NON LOT CONTROL' , 5 ) ;

360:
361: -- HW OPM BUG#:2536589
362: IF l_lot_code = 1 THEN
363: IF l_debug_level > 0 THEN
364: oe_debug_pub.add( 'INV IFACE: ITEM UNDER NON LOT CONTROL' , 5 ) ;
365: END IF;
366: l_lot := 'N';
367: END IF;
368:

Line 403: oe_debug_pub.add( 'INV IFACE: RESERVED_QTY = ' || TO_CHAR ( L_LINE_REC.RESERVED_QUANTITY ) , 5 ) ;

399: (p_header_id => l_sales_order_id,
400: p_line_id => l_line_rec.line_id,
401: p_org_id => l_line_rec.ship_from_org_id); */
402: IF l_debug_level > 0 THEN
403: oe_debug_pub.add( 'INV IFACE: RESERVED_QTY = ' || TO_CHAR ( L_LINE_REC.RESERVED_QUANTITY ) , 5 ) ;
404: END IF;
405:
406:
407: -- INVCONV

Line 414: oe_debug_pub.add( 'INV IFACE: RESERVED_QTY2 = ' || TO_CHAR ( L_LINE_REC.RESERVED_QUANTITY2 ) , 5 ) ;

410: (p_header_id => l_sales_order_id,
411: p_line_id => l_line_rec.line_id,
412: p_org_id => l_line_rec.ship_from_org_id); */
413: IF l_debug_level > 0 THEN
414: oe_debug_pub.add( 'INV IFACE: RESERVED_QTY2 = ' || TO_CHAR ( L_LINE_REC.RESERVED_QUANTITY2 ) , 5 ) ;
415: END IF;
416:
417:
418:

Line 434: oe_debug_pub.add( 'VALUE OF L_PROCESS_FLAG IS '||TO_CHAR ( L_PROCESS_ORG ) , 5 ) ;

430: l_process_org := 0;
431: END IF;
432:
433: IF l_debug_level > 0 THEN
434: oe_debug_pub.add( 'VALUE OF L_PROCESS_FLAG IS '||TO_CHAR ( L_PROCESS_ORG ) , 5 ) ;
435: END IF; */
436:
437:
438: /* -- HW OPM BUG#:2536589 Check if requested_qty < qty_reserved for OPM INVCONV NOT NEEDED NOW

Line 443: oe_debug_pub.add( 'INV IFACE FAILED: ORDERED_QTY IS < RESERVED_QTY FOR OPM' , 5 ) ;

439:
440: IF (l_process_org = 1 AND
441: l_line_rec.reserved_quantity > l_line_rec.ordered_quantity ) THEN
442: IF l_debug_level > 0 THEN
443: oe_debug_pub.add( 'INV IFACE FAILED: ORDERED_QTY IS < RESERVED_QTY FOR OPM' , 5 ) ;
444: END IF;
445: x_return_status := FND_API.G_RET_STS_ERROR;
446: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
447: ROLLBACK TO INVENTORY_INTERFACE;

Line 466: OE_DEBUG_PUB.Add('Error in selecting Primary UOM code',1);

462: AND organization_id = l_line_rec.ship_from_org_id;
463: EXCEPTION
464: WHEN OTHERS THEN
465: IF l_debug_level > 0 THEN
466: OE_DEBUG_PUB.Add('Error in selecting Primary UOM code',1);
467: END IF;
468: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
469:
470: END;

Line 483: OE_DEBUG_PUB.Add('Quantity to reserve after convert '||l_qty_to_reserve,1);

479: , from_name => NULL -- from uom name
480: , to_name => NULL -- to uom name
481: );
482: IF l_debug_level > 0 THEN
483: OE_DEBUG_PUB.Add('Quantity to reserve after convert '||l_qty_to_reserve,1);
484: END IF;
485: ELSE
486: l_qty_to_reserve := l_line_rec.ordered_quantity - l_line_rec.reserved_quantity;
487: END IF;

Line 502: oe_debug_pub.add( 'INV IFACE: CALLING INVS QUERY_RESERVATION ' , 1 ) ;

498: l_rsv_rec.demand_source_line_id := l_line_rec.line_id;
499: l_rsv_rec.organization_id := l_line_rec.ship_from_org_id;
500:
501: IF l_debug_level > 0 THEN
502: oe_debug_pub.add( 'INV IFACE: CALLING INVS QUERY_RESERVATION ' , 1 ) ;
503: END IF;
504: /*ER 8419373
505: inv_reservation_pub.query_reservation
506: ( p_api_version_number => 1.0

Line 538: oe_debug_pub.add( 'INV IFACE: AFTER CALLING INVS QUERY_RESERVATION: ' || L_RETURN_STATUS , 1 ) ;

534: , x_error_code => l_x_error_code
535: );
536:
537: IF l_debug_level > 0 THEN
538: oe_debug_pub.add( 'INV IFACE: AFTER CALLING INVS QUERY_RESERVATION: ' || L_RETURN_STATUS , 1 ) ;
539: oe_debug_pub.add( 'RESERVATION COUNT: ' || L_RSV_TBL.COUNT , 1 ) ;
540: oe_debug_pub.add( 'SERIAL TABLE COUNT: ' || l_serial_number_tbl.COUNT , 1 ) ;
541: oe_debug_pub.add( 'SERIAL COUNT: ' || l_serial_tbl_count , 1 ) ;
542: END IF;

Line 539: oe_debug_pub.add( 'RESERVATION COUNT: ' || L_RSV_TBL.COUNT , 1 ) ;

535: );
536:
537: IF l_debug_level > 0 THEN
538: oe_debug_pub.add( 'INV IFACE: AFTER CALLING INVS QUERY_RESERVATION: ' || L_RETURN_STATUS , 1 ) ;
539: oe_debug_pub.add( 'RESERVATION COUNT: ' || L_RSV_TBL.COUNT , 1 ) ;
540: oe_debug_pub.add( 'SERIAL TABLE COUNT: ' || l_serial_number_tbl.COUNT , 1 ) ;
541: oe_debug_pub.add( 'SERIAL COUNT: ' || l_serial_tbl_count , 1 ) ;
542: END IF;
543:

Line 540: oe_debug_pub.add( 'SERIAL TABLE COUNT: ' || l_serial_number_tbl.COUNT , 1 ) ;

536:
537: IF l_debug_level > 0 THEN
538: oe_debug_pub.add( 'INV IFACE: AFTER CALLING INVS QUERY_RESERVATION: ' || L_RETURN_STATUS , 1 ) ;
539: oe_debug_pub.add( 'RESERVATION COUNT: ' || L_RSV_TBL.COUNT , 1 ) ;
540: oe_debug_pub.add( 'SERIAL TABLE COUNT: ' || l_serial_number_tbl.COUNT , 1 ) ;
541: oe_debug_pub.add( 'SERIAL COUNT: ' || l_serial_tbl_count , 1 ) ;
542: END IF;
543:
544: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR OR

Line 541: oe_debug_pub.add( 'SERIAL COUNT: ' || l_serial_tbl_count , 1 ) ;

537: IF l_debug_level > 0 THEN
538: oe_debug_pub.add( 'INV IFACE: AFTER CALLING INVS QUERY_RESERVATION: ' || L_RETURN_STATUS , 1 ) ;
539: oe_debug_pub.add( 'RESERVATION COUNT: ' || L_RSV_TBL.COUNT , 1 ) ;
540: oe_debug_pub.add( 'SERIAL TABLE COUNT: ' || l_serial_number_tbl.COUNT , 1 ) ;
541: oe_debug_pub.add( 'SERIAL COUNT: ' || l_serial_tbl_count , 1 ) ;
542: END IF;
543:
544: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR OR
545: l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 547: oe_debug_pub.add( 'INV IFACE: QUERY_RESERVATION FAILED' , 5 ) ;

543:
544: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR OR
545: l_return_status = FND_API.G_RET_STS_ERROR THEN
546: IF l_debug_level > 0 THEN
547: oe_debug_pub.add( 'INV IFACE: QUERY_RESERVATION FAILED' , 5 ) ;
548: END IF;
549: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
550: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
551: RETURN;

Line 610: oe_debug_pub.add( 'INV IFACE: FAILED TO FETCH LOT_ID INFORMATION FOR OPM TRXN FOR TRANS_ID' || TO_CHAR ( L_RSV_TBL ( I ) .RESERVATION_ID ) , 5 ) ;

606:
607: -- This error is reported if lot_id is not found
608: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
609: IF l_debug_level > 0 THEN
610: oe_debug_pub.add( 'INV IFACE: FAILED TO FETCH LOT_ID INFORMATION FOR OPM TRXN FOR TRANS_ID' || TO_CHAR ( L_RSV_TBL ( I ) .RESERVATION_ID ) , 5 ) ;
611: END IF;
612: x_return_status := FND_API.G_RET_STS_ERROR;
613: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
614: ROLLBACK TO INVENTORY_INTERFACE;

Line 637: oe_debug_pub.add( 'INV IFACE: FAILED TO UPDATE OPM TRXNS' , 5 ) ;

633: ,opm_msg_data);
634:
635: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
636: IF l_debug_level > 0 THEN
637: oe_debug_pub.add( 'INV IFACE: FAILED TO UPDATE OPM TRXNS' , 5 ) ;
638: END IF;
639: x_return_status := FND_API.G_RET_STS_ERROR;
640: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
641: ROLLBACK TO INVENTORY_INTERFACE;

Line 671: oe_debug_pub.add( 'INV IFACE: LOCATOR CONTROL CODE FAILURE' , 5 ) ;

667:
668: EXCEPTION
669: WHEN OTHERS THEN
670: IF l_debug_level > 0 THEN
671: oe_debug_pub.add( 'INV IFACE: LOCATOR CONTROL CODE FAILURE' , 5 ) ;
672: END IF;
673: x_return_status := FND_API.G_RET_STS_ERROR;
674: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
675: ROLLBACK TO INVENTORY_INTERFACE;

Line 689: oe_debug_pub.add( 'INV IFACE: LOCATOR TYPE FAILURE' , 5 ) ;

685:
686: EXCEPTION
687: WHEN OTHERS THEN
688: IF l_debug_level > 0 THEN
689: oe_debug_pub.add( 'INV IFACE: LOCATOR TYPE FAILURE' , 5 ) ;
690: END IF;
691: x_return_status := FND_API.G_RET_STS_ERROR;
692: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
693: ROLLBACK TO INVENTORY_INTERFACE;

Line 706: oe_debug_pub.add( 'INV IFACE: LOCATION CONTROL CODE FAILURE' , 5 ) ;

702: AND organization_id = l_line_rec.ship_from_org_id;
703: EXCEPTION
704: WHEN OTHERS THEN
705: IF l_debug_level > 0 THEN
706: oe_debug_pub.add( 'INV IFACE: LOCATION CONTROL CODE FAILURE' , 5 ) ;
707: END IF;
708: x_return_status := FND_API.G_RET_STS_ERROR;
709: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
710: ROLLBACK TO INVENTORY_INTERFACE;

Line 715: oe_debug_pub.add( 'INV IFACE: BEFORE LOCATOR_CONTROL API CALL' , 1 ) ;

711: RETURN;
712: END;
713:
714: IF l_debug_level > 0 THEN
715: oe_debug_pub.add( 'INV IFACE: BEFORE LOCATOR_CONTROL API CALL' , 1 ) ;
716: END IF;
717: l_locator := INV_RESERVATION_UTIL_PVT.locator_control(
718: p_org_control => l_stock_locator_control_code
719: ,p_sub_control => l_locator_type

Line 722: oe_debug_pub.add( 'INV IFACE: AFTER LOCATOR_CONTROL API CALL - ' || TO_CHAR ( L_LOCATOR ) , 1 ) ;

718: p_org_control => l_stock_locator_control_code
719: ,p_sub_control => l_locator_type
720: ,p_item_control => l_location_control_code);
721: IF l_debug_level > 0 THEN
722: oe_debug_pub.add( 'INV IFACE: AFTER LOCATOR_CONTROL API CALL - ' || TO_CHAR ( L_LOCATOR ) , 1 ) ;
723: END IF;
724:
725:
726: IF l_locator > 1 THEN -- under locator control

Line 730: oe_debug_pub.add( 'INV IFACE: ITEM UNDER LOCATOR CONTROL' , 5 ) ;

726: IF l_locator > 1 THEN -- under locator control
727: IF l_rsv_tbl(I).locator_id is null THEN
728: -- give a message
729: IF l_debug_level > 0 THEN
730: oe_debug_pub.add( 'INV IFACE: ITEM UNDER LOCATOR CONTROL' , 5 ) ;
731: END IF;
732: FND_MESSAGE.SET_NAME('ONT', 'OE_INV_IFACE_LOCATOR');
733: OE_MSG_PUB.ADD;
734: x_return_status := FND_API.G_RET_STS_ERROR;

Line 762: oe_debug_pub.add( 'l_serial_transaction_temp_id: ' || l_serial_transaction_temp_id , 5 ) ;

758: l_serial_transaction_temp_id := null;
759: END IF;
760:
761: IF l_debug_level > 0 THEN
762: oe_debug_pub.add( 'l_serial_transaction_temp_id: ' || l_serial_transaction_temp_id , 5 ) ;
763: END IF;
764:
765: --ER 8419373 END
766:

Line 847: oe_debug_pub.add( 'l_rsv_serial_count: ' || l_rsv_serial_count , 5 ) ;

843:
844: END LOOP;
845:
846: IF l_debug_level > 0 THEN
847: oe_debug_pub.add( 'l_rsv_serial_count: ' || l_rsv_serial_count , 5 ) ;
848: oe_debug_pub.add( 'l_rsv_tbl(I).reservation_quantity: ' || l_rsv_tbl(I).reservation_quantity , 5 ) ;
849: END IF;
850:
851: --Bug 13690325

Line 848: oe_debug_pub.add( 'l_rsv_tbl(I).reservation_quantity: ' || l_rsv_tbl(I).reservation_quantity , 5 ) ;

844: END LOOP;
845:
846: IF l_debug_level > 0 THEN
847: oe_debug_pub.add( 'l_rsv_serial_count: ' || l_rsv_serial_count , 5 ) ;
848: oe_debug_pub.add( 'l_rsv_tbl(I).reservation_quantity: ' || l_rsv_tbl(I).reservation_quantity , 5 ) ;
849: END IF;
850:
851: --Bug 13690325
852: --check for the reservation quantity if partial serial number have been entered

Line 868: oe_debug_pub.add( 'INV IFACE: INSERTING RECORD - 1' , 1 ) ;

864: END IF; --under serial control
865: --ER 8419373 END
866:
867: IF l_debug_level > 0 THEN
868: oe_debug_pub.add( 'INV IFACE: INSERTING RECORD - 1' , 1 ) ;
869:
870: oe_debug_pub.add( 'SOURCE_CODE :' || FND_PROFILE.VALUE ( 'ONT_SOURCE_CODE' ) , 5 ) ;
871:
872: oe_debug_pub.add( 'SOURCE_LINE_ID :' || L_SOURCE_LINE_ID , 5 ) ;

Line 870: oe_debug_pub.add( 'SOURCE_CODE :' || FND_PROFILE.VALUE ( 'ONT_SOURCE_CODE' ) , 5 ) ;

866:
867: IF l_debug_level > 0 THEN
868: oe_debug_pub.add( 'INV IFACE: INSERTING RECORD - 1' , 1 ) ;
869:
870: oe_debug_pub.add( 'SOURCE_CODE :' || FND_PROFILE.VALUE ( 'ONT_SOURCE_CODE' ) , 5 ) ;
871:
872: oe_debug_pub.add( 'SOURCE_LINE_ID :' || L_SOURCE_LINE_ID , 5 ) ;
873:
874: oe_debug_pub.add( 'SOURCE_HEADER_ID :' || L_TRANSACTION_REFERENCE , 5 ) ;

Line 872: oe_debug_pub.add( 'SOURCE_LINE_ID :' || L_SOURCE_LINE_ID , 5 ) ;

868: oe_debug_pub.add( 'INV IFACE: INSERTING RECORD - 1' , 1 ) ;
869:
870: oe_debug_pub.add( 'SOURCE_CODE :' || FND_PROFILE.VALUE ( 'ONT_SOURCE_CODE' ) , 5 ) ;
871:
872: oe_debug_pub.add( 'SOURCE_LINE_ID :' || L_SOURCE_LINE_ID , 5 ) ;
873:
874: oe_debug_pub.add( 'SOURCE_HEADER_ID :' || L_TRANSACTION_REFERENCE , 5 ) ;
875:
876: oe_debug_pub.add( 'PROCESS_FLAG :' || 1 , 5 ) ;

Line 874: oe_debug_pub.add( 'SOURCE_HEADER_ID :' || L_TRANSACTION_REFERENCE , 5 ) ;

870: oe_debug_pub.add( 'SOURCE_CODE :' || FND_PROFILE.VALUE ( 'ONT_SOURCE_CODE' ) , 5 ) ;
871:
872: oe_debug_pub.add( 'SOURCE_LINE_ID :' || L_SOURCE_LINE_ID , 5 ) ;
873:
874: oe_debug_pub.add( 'SOURCE_HEADER_ID :' || L_TRANSACTION_REFERENCE , 5 ) ;
875:
876: oe_debug_pub.add( 'PROCESS_FLAG :' || 1 , 5 ) ;
877:
878: oe_debug_pub.add( 'TRANSACTION_MODE :' || 1 , 5 ) ;

Line 876: oe_debug_pub.add( 'PROCESS_FLAG :' || 1 , 5 ) ;

872: oe_debug_pub.add( 'SOURCE_LINE_ID :' || L_SOURCE_LINE_ID , 5 ) ;
873:
874: oe_debug_pub.add( 'SOURCE_HEADER_ID :' || L_TRANSACTION_REFERENCE , 5 ) ;
875:
876: oe_debug_pub.add( 'PROCESS_FLAG :' || 1 , 5 ) ;
877:
878: oe_debug_pub.add( 'TRANSACTION_MODE :' || 1 , 5 ) ;
879:
880: oe_debug_pub.add( 'LOCK_FLAG :' || 2 , 5 ) ;

Line 878: oe_debug_pub.add( 'TRANSACTION_MODE :' || 1 , 5 ) ;

874: oe_debug_pub.add( 'SOURCE_HEADER_ID :' || L_TRANSACTION_REFERENCE , 5 ) ;
875:
876: oe_debug_pub.add( 'PROCESS_FLAG :' || 1 , 5 ) ;
877:
878: oe_debug_pub.add( 'TRANSACTION_MODE :' || 1 , 5 ) ;
879:
880: oe_debug_pub.add( 'LOCK_FLAG :' || 2 , 5 ) ;
881:
882: oe_debug_pub.add( 'TRANSACTION_HEADER_ID :' || L_TRANSACTION_HEADER_ID , 5 ) ;

Line 880: oe_debug_pub.add( 'LOCK_FLAG :' || 2 , 5 ) ;

876: oe_debug_pub.add( 'PROCESS_FLAG :' || 1 , 5 ) ;
877:
878: oe_debug_pub.add( 'TRANSACTION_MODE :' || 1 , 5 ) ;
879:
880: oe_debug_pub.add( 'LOCK_FLAG :' || 2 , 5 ) ;
881:
882: oe_debug_pub.add( 'TRANSACTION_HEADER_ID :' || L_TRANSACTION_HEADER_ID , 5 ) ;
883:
884: oe_debug_pub.add( 'INVENTORY_ITEM_ID :' || L_LINE_REC.INVENTORY_ITEM_ID , 5 ) ;

Line 882: oe_debug_pub.add( 'TRANSACTION_HEADER_ID :' || L_TRANSACTION_HEADER_ID , 5 ) ;

878: oe_debug_pub.add( 'TRANSACTION_MODE :' || 1 , 5 ) ;
879:
880: oe_debug_pub.add( 'LOCK_FLAG :' || 2 , 5 ) ;
881:
882: oe_debug_pub.add( 'TRANSACTION_HEADER_ID :' || L_TRANSACTION_HEADER_ID , 5 ) ;
883:
884: oe_debug_pub.add( 'INVENTORY_ITEM_ID :' || L_LINE_REC.INVENTORY_ITEM_ID , 5 ) ;
885:
886: oe_debug_pub.add( 'SUBINVENTORY_CODE :' || L_RSV_TBL ( I ) .SUBINVENTORY_CODE , 5 ) ;

Line 884: oe_debug_pub.add( 'INVENTORY_ITEM_ID :' || L_LINE_REC.INVENTORY_ITEM_ID , 5 ) ;

880: oe_debug_pub.add( 'LOCK_FLAG :' || 2 , 5 ) ;
881:
882: oe_debug_pub.add( 'TRANSACTION_HEADER_ID :' || L_TRANSACTION_HEADER_ID , 5 ) ;
883:
884: oe_debug_pub.add( 'INVENTORY_ITEM_ID :' || L_LINE_REC.INVENTORY_ITEM_ID , 5 ) ;
885:
886: oe_debug_pub.add( 'SUBINVENTORY_CODE :' || L_RSV_TBL ( I ) .SUBINVENTORY_CODE , 5 ) ;
887:
888: oe_debug_pub.add( 'TRANSACTION_QUANTITY :' || ( -1 * L_RSV_TBL ( I ) .RESERVATION_QUANTITY ) , 5 ) ;

Line 886: oe_debug_pub.add( 'SUBINVENTORY_CODE :' || L_RSV_TBL ( I ) .SUBINVENTORY_CODE , 5 ) ;

882: oe_debug_pub.add( 'TRANSACTION_HEADER_ID :' || L_TRANSACTION_HEADER_ID , 5 ) ;
883:
884: oe_debug_pub.add( 'INVENTORY_ITEM_ID :' || L_LINE_REC.INVENTORY_ITEM_ID , 5 ) ;
885:
886: oe_debug_pub.add( 'SUBINVENTORY_CODE :' || L_RSV_TBL ( I ) .SUBINVENTORY_CODE , 5 ) ;
887:
888: oe_debug_pub.add( 'TRANSACTION_QUANTITY :' || ( -1 * L_RSV_TBL ( I ) .RESERVATION_QUANTITY ) , 5 ) ;
889:
890: oe_debug_pub.add( 'SECONDARY TRANSACTION_QUANTITY :' || ( -1 * L_RSV_TBL ( I ) .SECONDARY_RESERVATION_QUANTITY ) , 5 ) ; -- INVCONV

Line 888: oe_debug_pub.add( 'TRANSACTION_QUANTITY :' || ( -1 * L_RSV_TBL ( I ) .RESERVATION_QUANTITY ) , 5 ) ;

884: oe_debug_pub.add( 'INVENTORY_ITEM_ID :' || L_LINE_REC.INVENTORY_ITEM_ID , 5 ) ;
885:
886: oe_debug_pub.add( 'SUBINVENTORY_CODE :' || L_RSV_TBL ( I ) .SUBINVENTORY_CODE , 5 ) ;
887:
888: oe_debug_pub.add( 'TRANSACTION_QUANTITY :' || ( -1 * L_RSV_TBL ( I ) .RESERVATION_QUANTITY ) , 5 ) ;
889:
890: oe_debug_pub.add( 'SECONDARY TRANSACTION_QUANTITY :' || ( -1 * L_RSV_TBL ( I ) .SECONDARY_RESERVATION_QUANTITY ) , 5 ) ; -- INVCONV
891:
892:

Line 890: oe_debug_pub.add( 'SECONDARY TRANSACTION_QUANTITY :' || ( -1 * L_RSV_TBL ( I ) .SECONDARY_RESERVATION_QUANTITY ) , 5 ) ; -- INVCONV

886: oe_debug_pub.add( 'SUBINVENTORY_CODE :' || L_RSV_TBL ( I ) .SUBINVENTORY_CODE , 5 ) ;
887:
888: oe_debug_pub.add( 'TRANSACTION_QUANTITY :' || ( -1 * L_RSV_TBL ( I ) .RESERVATION_QUANTITY ) , 5 ) ;
889:
890: oe_debug_pub.add( 'SECONDARY TRANSACTION_QUANTITY :' || ( -1 * L_RSV_TBL ( I ) .SECONDARY_RESERVATION_QUANTITY ) , 5 ) ; -- INVCONV
891:
892:
893: oe_debug_pub.add( 'TRANSACTION_DATE :' || l_trx_date_for_inv_iface, 5 ) ; --bug5897965
894:

Line 893: oe_debug_pub.add( 'TRANSACTION_DATE :' || l_trx_date_for_inv_iface, 5 ) ; --bug5897965

889:
890: oe_debug_pub.add( 'SECONDARY TRANSACTION_QUANTITY :' || ( -1 * L_RSV_TBL ( I ) .SECONDARY_RESERVATION_QUANTITY ) , 5 ) ; -- INVCONV
891:
892:
893: oe_debug_pub.add( 'TRANSACTION_DATE :' || l_trx_date_for_inv_iface, 5 ) ; --bug5897965
894:
895: -- bug 5897965 oe_debug_pub.add( 'TRANSACTION_DATE :' || l_ordered_date , 5 ) ;
896:
897: oe_debug_pub.add( 'ORGANIZATION_ID :' || L_RSV_TBL ( I ) .ORGANIZATION_ID , 5 ) ;

Line 895: -- bug 5897965 oe_debug_pub.add( 'TRANSACTION_DATE :' || l_ordered_date , 5 ) ;

891:
892:
893: oe_debug_pub.add( 'TRANSACTION_DATE :' || l_trx_date_for_inv_iface, 5 ) ; --bug5897965
894:
895: -- bug 5897965 oe_debug_pub.add( 'TRANSACTION_DATE :' || l_ordered_date , 5 ) ;
896:
897: oe_debug_pub.add( 'ORGANIZATION_ID :' || L_RSV_TBL ( I ) .ORGANIZATION_ID , 5 ) ;
898:
899: oe_debug_pub.add( 'ACCT_PERIOD_ID :' || NULL , 5 ) ;

Line 897: oe_debug_pub.add( 'ORGANIZATION_ID :' || L_RSV_TBL ( I ) .ORGANIZATION_ID , 5 ) ;

893: oe_debug_pub.add( 'TRANSACTION_DATE :' || l_trx_date_for_inv_iface, 5 ) ; --bug5897965
894:
895: -- bug 5897965 oe_debug_pub.add( 'TRANSACTION_DATE :' || l_ordered_date , 5 ) ;
896:
897: oe_debug_pub.add( 'ORGANIZATION_ID :' || L_RSV_TBL ( I ) .ORGANIZATION_ID , 5 ) ;
898:
899: oe_debug_pub.add( 'ACCT_PERIOD_ID :' || NULL , 5 ) ;
900:
901: oe_debug_pub.add( 'LAST_UPDATE_DATE :' || SYSDATE , 5 ) ;

Line 899: oe_debug_pub.add( 'ACCT_PERIOD_ID :' || NULL , 5 ) ;

895: -- bug 5897965 oe_debug_pub.add( 'TRANSACTION_DATE :' || l_ordered_date , 5 ) ;
896:
897: oe_debug_pub.add( 'ORGANIZATION_ID :' || L_RSV_TBL ( I ) .ORGANIZATION_ID , 5 ) ;
898:
899: oe_debug_pub.add( 'ACCT_PERIOD_ID :' || NULL , 5 ) ;
900:
901: oe_debug_pub.add( 'LAST_UPDATE_DATE :' || SYSDATE , 5 ) ;
902:
903: oe_debug_pub.add( 'LAST_UPDATED_BY :' || FND_GLOBAL.USER_ID , 5 ) ;

Line 901: oe_debug_pub.add( 'LAST_UPDATE_DATE :' || SYSDATE , 5 ) ;

897: oe_debug_pub.add( 'ORGANIZATION_ID :' || L_RSV_TBL ( I ) .ORGANIZATION_ID , 5 ) ;
898:
899: oe_debug_pub.add( 'ACCT_PERIOD_ID :' || NULL , 5 ) ;
900:
901: oe_debug_pub.add( 'LAST_UPDATE_DATE :' || SYSDATE , 5 ) ;
902:
903: oe_debug_pub.add( 'LAST_UPDATED_BY :' || FND_GLOBAL.USER_ID , 5 ) ;
904:
905: oe_debug_pub.add( 'CREATION_DATE :' || SYSDATE , 5 ) ;

Line 903: oe_debug_pub.add( 'LAST_UPDATED_BY :' || FND_GLOBAL.USER_ID , 5 ) ;

899: oe_debug_pub.add( 'ACCT_PERIOD_ID :' || NULL , 5 ) ;
900:
901: oe_debug_pub.add( 'LAST_UPDATE_DATE :' || SYSDATE , 5 ) ;
902:
903: oe_debug_pub.add( 'LAST_UPDATED_BY :' || FND_GLOBAL.USER_ID , 5 ) ;
904:
905: oe_debug_pub.add( 'CREATION_DATE :' || SYSDATE , 5 ) ;
906:
907: oe_debug_pub.add( 'CREATED_BY :' || FND_GLOBAL.USER_ID , 5 ) ;

Line 905: oe_debug_pub.add( 'CREATION_DATE :' || SYSDATE , 5 ) ;

901: oe_debug_pub.add( 'LAST_UPDATE_DATE :' || SYSDATE , 5 ) ;
902:
903: oe_debug_pub.add( 'LAST_UPDATED_BY :' || FND_GLOBAL.USER_ID , 5 ) ;
904:
905: oe_debug_pub.add( 'CREATION_DATE :' || SYSDATE , 5 ) ;
906:
907: oe_debug_pub.add( 'CREATED_BY :' || FND_GLOBAL.USER_ID , 5 ) ;
908:
909: oe_debug_pub.add( 'TRANSACTION_SOURCE_ID :' || L_SALES_ORDER_ID , 5 ) ;

Line 907: oe_debug_pub.add( 'CREATED_BY :' || FND_GLOBAL.USER_ID , 5 ) ;

903: oe_debug_pub.add( 'LAST_UPDATED_BY :' || FND_GLOBAL.USER_ID , 5 ) ;
904:
905: oe_debug_pub.add( 'CREATION_DATE :' || SYSDATE , 5 ) ;
906:
907: oe_debug_pub.add( 'CREATED_BY :' || FND_GLOBAL.USER_ID , 5 ) ;
908:
909: oe_debug_pub.add( 'TRANSACTION_SOURCE_ID :' || L_SALES_ORDER_ID , 5 ) ;
910:
911: oe_debug_pub.add( 'DSP_SEGMENT1 :' || L_ORDER_NUMBER , 5 ) ;

Line 909: oe_debug_pub.add( 'TRANSACTION_SOURCE_ID :' || L_SALES_ORDER_ID , 5 ) ;

905: oe_debug_pub.add( 'CREATION_DATE :' || SYSDATE , 5 ) ;
906:
907: oe_debug_pub.add( 'CREATED_BY :' || FND_GLOBAL.USER_ID , 5 ) ;
908:
909: oe_debug_pub.add( 'TRANSACTION_SOURCE_ID :' || L_SALES_ORDER_ID , 5 ) ;
910:
911: oe_debug_pub.add( 'DSP_SEGMENT1 :' || L_ORDER_NUMBER , 5 ) ;
912:
913: oe_debug_pub.add( 'DSP_SEGMENT2 :' || L_ORDER_TYPE_NAME , 5 ) ;

Line 911: oe_debug_pub.add( 'DSP_SEGMENT1 :' || L_ORDER_NUMBER , 5 ) ;

907: oe_debug_pub.add( 'CREATED_BY :' || FND_GLOBAL.USER_ID , 5 ) ;
908:
909: oe_debug_pub.add( 'TRANSACTION_SOURCE_ID :' || L_SALES_ORDER_ID , 5 ) ;
910:
911: oe_debug_pub.add( 'DSP_SEGMENT1 :' || L_ORDER_NUMBER , 5 ) ;
912:
913: oe_debug_pub.add( 'DSP_SEGMENT2 :' || L_ORDER_TYPE_NAME , 5 ) ;
914:
915: oe_debug_pub.add( 'DSP_SEGMENT3 :' || FND_PROFILE.VALUE ( 'ONT_SOURCE_CODE' ) , 5 ) ;

Line 913: oe_debug_pub.add( 'DSP_SEGMENT2 :' || L_ORDER_TYPE_NAME , 5 ) ;

909: oe_debug_pub.add( 'TRANSACTION_SOURCE_ID :' || L_SALES_ORDER_ID , 5 ) ;
910:
911: oe_debug_pub.add( 'DSP_SEGMENT1 :' || L_ORDER_NUMBER , 5 ) ;
912:
913: oe_debug_pub.add( 'DSP_SEGMENT2 :' || L_ORDER_TYPE_NAME , 5 ) ;
914:
915: oe_debug_pub.add( 'DSP_SEGMENT3 :' || FND_PROFILE.VALUE ( 'ONT_SOURCE_CODE' ) , 5 ) ;
916:
917: oe_debug_pub.add( 'TRANSACTION_SOURCE_TYPE_ID :' || TO_CHAR ( 2 ) , 5 ) ;

Line 915: oe_debug_pub.add( 'DSP_SEGMENT3 :' || FND_PROFILE.VALUE ( 'ONT_SOURCE_CODE' ) , 5 ) ;

911: oe_debug_pub.add( 'DSP_SEGMENT1 :' || L_ORDER_NUMBER , 5 ) ;
912:
913: oe_debug_pub.add( 'DSP_SEGMENT2 :' || L_ORDER_TYPE_NAME , 5 ) ;
914:
915: oe_debug_pub.add( 'DSP_SEGMENT3 :' || FND_PROFILE.VALUE ( 'ONT_SOURCE_CODE' ) , 5 ) ;
916:
917: oe_debug_pub.add( 'TRANSACTION_SOURCE_TYPE_ID :' || TO_CHAR ( 2 ) , 5 ) ;
918:
919: oe_debug_pub.add( 'TRANSACTION_ACTION_ID :' || TO_CHAR ( 1 ) , 5 ) ;

Line 917: oe_debug_pub.add( 'TRANSACTION_SOURCE_TYPE_ID :' || TO_CHAR ( 2 ) , 5 ) ;

913: oe_debug_pub.add( 'DSP_SEGMENT2 :' || L_ORDER_TYPE_NAME , 5 ) ;
914:
915: oe_debug_pub.add( 'DSP_SEGMENT3 :' || FND_PROFILE.VALUE ( 'ONT_SOURCE_CODE' ) , 5 ) ;
916:
917: oe_debug_pub.add( 'TRANSACTION_SOURCE_TYPE_ID :' || TO_CHAR ( 2 ) , 5 ) ;
918:
919: oe_debug_pub.add( 'TRANSACTION_ACTION_ID :' || TO_CHAR ( 1 ) , 5 ) ;
920:
921: oe_debug_pub.add( 'TRANSACTION_TYPE_ID :' || TO_CHAR ( 33 ) , 5 ) ;

Line 919: oe_debug_pub.add( 'TRANSACTION_ACTION_ID :' || TO_CHAR ( 1 ) , 5 ) ;

915: oe_debug_pub.add( 'DSP_SEGMENT3 :' || FND_PROFILE.VALUE ( 'ONT_SOURCE_CODE' ) , 5 ) ;
916:
917: oe_debug_pub.add( 'TRANSACTION_SOURCE_TYPE_ID :' || TO_CHAR ( 2 ) , 5 ) ;
918:
919: oe_debug_pub.add( 'TRANSACTION_ACTION_ID :' || TO_CHAR ( 1 ) , 5 ) ;
920:
921: oe_debug_pub.add( 'TRANSACTION_TYPE_ID :' || TO_CHAR ( 33 ) , 5 ) ;
922:
923: oe_debug_pub.add( 'DISTRIBUTION_ACCOUNT_ID :' || L_TRANS_ACC , 5 ) ;

Line 921: oe_debug_pub.add( 'TRANSACTION_TYPE_ID :' || TO_CHAR ( 33 ) , 5 ) ;

917: oe_debug_pub.add( 'TRANSACTION_SOURCE_TYPE_ID :' || TO_CHAR ( 2 ) , 5 ) ;
918:
919: oe_debug_pub.add( 'TRANSACTION_ACTION_ID :' || TO_CHAR ( 1 ) , 5 ) ;
920:
921: oe_debug_pub.add( 'TRANSACTION_TYPE_ID :' || TO_CHAR ( 33 ) , 5 ) ;
922:
923: oe_debug_pub.add( 'DISTRIBUTION_ACCOUNT_ID :' || L_TRANS_ACC , 5 ) ;
924:
925: oe_debug_pub.add( 'TRANSACTION_REFERENCE :' || L_TRANSACTION_REFERENCE , 5 ) ;

Line 923: oe_debug_pub.add( 'DISTRIBUTION_ACCOUNT_ID :' || L_TRANS_ACC , 5 ) ;

919: oe_debug_pub.add( 'TRANSACTION_ACTION_ID :' || TO_CHAR ( 1 ) , 5 ) ;
920:
921: oe_debug_pub.add( 'TRANSACTION_TYPE_ID :' || TO_CHAR ( 33 ) , 5 ) ;
922:
923: oe_debug_pub.add( 'DISTRIBUTION_ACCOUNT_ID :' || L_TRANS_ACC , 5 ) ;
924:
925: oe_debug_pub.add( 'TRANSACTION_REFERENCE :' || L_TRANSACTION_REFERENCE , 5 ) ;
926:
927: oe_debug_pub.add( 'TRX_SOURCE_LINE_ID :' || L_LINE_REC.LINE_ID , 5 ) ;

Line 925: oe_debug_pub.add( 'TRANSACTION_REFERENCE :' || L_TRANSACTION_REFERENCE , 5 ) ;

921: oe_debug_pub.add( 'TRANSACTION_TYPE_ID :' || TO_CHAR ( 33 ) , 5 ) ;
922:
923: oe_debug_pub.add( 'DISTRIBUTION_ACCOUNT_ID :' || L_TRANS_ACC , 5 ) ;
924:
925: oe_debug_pub.add( 'TRANSACTION_REFERENCE :' || L_TRANSACTION_REFERENCE , 5 ) ;
926:
927: oe_debug_pub.add( 'TRX_SOURCE_LINE_ID :' || L_LINE_REC.LINE_ID , 5 ) ;
928:
929: oe_debug_pub.add( 'TRX_SOURCE_DELIVERY_ID :' || NULL , 5 ) ;

Line 927: oe_debug_pub.add( 'TRX_SOURCE_LINE_ID :' || L_LINE_REC.LINE_ID , 5 ) ;

923: oe_debug_pub.add( 'DISTRIBUTION_ACCOUNT_ID :' || L_TRANS_ACC , 5 ) ;
924:
925: oe_debug_pub.add( 'TRANSACTION_REFERENCE :' || L_TRANSACTION_REFERENCE , 5 ) ;
926:
927: oe_debug_pub.add( 'TRX_SOURCE_LINE_ID :' || L_LINE_REC.LINE_ID , 5 ) ;
928:
929: oe_debug_pub.add( 'TRX_SOURCE_DELIVERY_ID :' || NULL , 5 ) ;
930:
931: oe_debug_pub.add( 'REVISION :' || L_RSV_TBL ( I ) .REVISION , 5 ) ;

Line 929: oe_debug_pub.add( 'TRX_SOURCE_DELIVERY_ID :' || NULL , 5 ) ;

925: oe_debug_pub.add( 'TRANSACTION_REFERENCE :' || L_TRANSACTION_REFERENCE , 5 ) ;
926:
927: oe_debug_pub.add( 'TRX_SOURCE_LINE_ID :' || L_LINE_REC.LINE_ID , 5 ) ;
928:
929: oe_debug_pub.add( 'TRX_SOURCE_DELIVERY_ID :' || NULL , 5 ) ;
930:
931: oe_debug_pub.add( 'REVISION :' || L_RSV_TBL ( I ) .REVISION , 5 ) ;
932:
933: oe_debug_pub.add( 'LOCATOR_ID :' || L_RSV_TBL ( I ) .LOCATOR_ID , 5 ) ;

Line 931: oe_debug_pub.add( 'REVISION :' || L_RSV_TBL ( I ) .REVISION , 5 ) ;

927: oe_debug_pub.add( 'TRX_SOURCE_LINE_ID :' || L_LINE_REC.LINE_ID , 5 ) ;
928:
929: oe_debug_pub.add( 'TRX_SOURCE_DELIVERY_ID :' || NULL , 5 ) ;
930:
931: oe_debug_pub.add( 'REVISION :' || L_RSV_TBL ( I ) .REVISION , 5 ) ;
932:
933: oe_debug_pub.add( 'LOCATOR_ID :' || L_RSV_TBL ( I ) .LOCATOR_ID , 5 ) ;
934:
935: oe_debug_pub.add( 'LOC_SEGMENT1 :' || NULL , 5 ) ;

Line 933: oe_debug_pub.add( 'LOCATOR_ID :' || L_RSV_TBL ( I ) .LOCATOR_ID , 5 ) ;

929: oe_debug_pub.add( 'TRX_SOURCE_DELIVERY_ID :' || NULL , 5 ) ;
930:
931: oe_debug_pub.add( 'REVISION :' || L_RSV_TBL ( I ) .REVISION , 5 ) ;
932:
933: oe_debug_pub.add( 'LOCATOR_ID :' || L_RSV_TBL ( I ) .LOCATOR_ID , 5 ) ;
934:
935: oe_debug_pub.add( 'LOC_SEGMENT1 :' || NULL , 5 ) ;
936:
937: oe_debug_pub.add( 'LOC_SEGMENT2 :' || NULL , 5 ) ;

Line 935: oe_debug_pub.add( 'LOC_SEGMENT1 :' || NULL , 5 ) ;

931: oe_debug_pub.add( 'REVISION :' || L_RSV_TBL ( I ) .REVISION , 5 ) ;
932:
933: oe_debug_pub.add( 'LOCATOR_ID :' || L_RSV_TBL ( I ) .LOCATOR_ID , 5 ) ;
934:
935: oe_debug_pub.add( 'LOC_SEGMENT1 :' || NULL , 5 ) ;
936:
937: oe_debug_pub.add( 'LOC_SEGMENT2 :' || NULL , 5 ) ;
938:
939: oe_debug_pub.add( 'LOC_SEGMENT3 :' || NULL , 5 ) ;

Line 937: oe_debug_pub.add( 'LOC_SEGMENT2 :' || NULL , 5 ) ;

933: oe_debug_pub.add( 'LOCATOR_ID :' || L_RSV_TBL ( I ) .LOCATOR_ID , 5 ) ;
934:
935: oe_debug_pub.add( 'LOC_SEGMENT1 :' || NULL , 5 ) ;
936:
937: oe_debug_pub.add( 'LOC_SEGMENT2 :' || NULL , 5 ) ;
938:
939: oe_debug_pub.add( 'LOC_SEGMENT3 :' || NULL , 5 ) ;
940:
941: oe_debug_pub.add( 'LOC_SEGMENT4 :' || NULL , 5 ) ;

Line 939: oe_debug_pub.add( 'LOC_SEGMENT3 :' || NULL , 5 ) ;

935: oe_debug_pub.add( 'LOC_SEGMENT1 :' || NULL , 5 ) ;
936:
937: oe_debug_pub.add( 'LOC_SEGMENT2 :' || NULL , 5 ) ;
938:
939: oe_debug_pub.add( 'LOC_SEGMENT3 :' || NULL , 5 ) ;
940:
941: oe_debug_pub.add( 'LOC_SEGMENT4 :' || NULL , 5 ) ;
942:
943: oe_debug_pub.add( 'REQUIRED_FLAG :' || NULL , 5 ) ;

Line 941: oe_debug_pub.add( 'LOC_SEGMENT4 :' || NULL , 5 ) ;

937: oe_debug_pub.add( 'LOC_SEGMENT2 :' || NULL , 5 ) ;
938:
939: oe_debug_pub.add( 'LOC_SEGMENT3 :' || NULL , 5 ) ;
940:
941: oe_debug_pub.add( 'LOC_SEGMENT4 :' || NULL , 5 ) ;
942:
943: oe_debug_pub.add( 'REQUIRED_FLAG :' || NULL , 5 ) ;
944:
945: oe_debug_pub.add( 'PICKING_LINE_ID :' || TO_CHAR ( 0 ) , 5 ) ;

Line 943: oe_debug_pub.add( 'REQUIRED_FLAG :' || NULL , 5 ) ;

939: oe_debug_pub.add( 'LOC_SEGMENT3 :' || NULL , 5 ) ;
940:
941: oe_debug_pub.add( 'LOC_SEGMENT4 :' || NULL , 5 ) ;
942:
943: oe_debug_pub.add( 'REQUIRED_FLAG :' || NULL , 5 ) ;
944:
945: oe_debug_pub.add( 'PICKING_LINE_ID :' || TO_CHAR ( 0 ) , 5 ) ;
946:
947: oe_debug_pub.add( 'TRANSFER_SUBINVENTORY :' || NULL , 5 ) ;

Line 945: oe_debug_pub.add( 'PICKING_LINE_ID :' || TO_CHAR ( 0 ) , 5 ) ;

941: oe_debug_pub.add( 'LOC_SEGMENT4 :' || NULL , 5 ) ;
942:
943: oe_debug_pub.add( 'REQUIRED_FLAG :' || NULL , 5 ) ;
944:
945: oe_debug_pub.add( 'PICKING_LINE_ID :' || TO_CHAR ( 0 ) , 5 ) ;
946:
947: oe_debug_pub.add( 'TRANSFER_SUBINVENTORY :' || NULL , 5 ) ;
948:
949: oe_debug_pub.add( 'TRANSFER_ORGANIZATION :' || NULL , 5 ) ;

Line 947: oe_debug_pub.add( 'TRANSFER_SUBINVENTORY :' || NULL , 5 ) ;

943: oe_debug_pub.add( 'REQUIRED_FLAG :' || NULL , 5 ) ;
944:
945: oe_debug_pub.add( 'PICKING_LINE_ID :' || TO_CHAR ( 0 ) , 5 ) ;
946:
947: oe_debug_pub.add( 'TRANSFER_SUBINVENTORY :' || NULL , 5 ) ;
948:
949: oe_debug_pub.add( 'TRANSFER_ORGANIZATION :' || NULL , 5 ) ;
950:
951: oe_debug_pub.add( 'SHIP_TO_LOCATION_ID :' || NULL , 5 ) ;

Line 949: oe_debug_pub.add( 'TRANSFER_ORGANIZATION :' || NULL , 5 ) ;

945: oe_debug_pub.add( 'PICKING_LINE_ID :' || TO_CHAR ( 0 ) , 5 ) ;
946:
947: oe_debug_pub.add( 'TRANSFER_SUBINVENTORY :' || NULL , 5 ) ;
948:
949: oe_debug_pub.add( 'TRANSFER_ORGANIZATION :' || NULL , 5 ) ;
950:
951: oe_debug_pub.add( 'SHIP_TO_LOCATION_ID :' || NULL , 5 ) ;
952:
953: oe_debug_pub.add( 'REQUISITION_LINE_ID :' || NULL , 5 ) ;

Line 951: oe_debug_pub.add( 'SHIP_TO_LOCATION_ID :' || NULL , 5 ) ;

947: oe_debug_pub.add( 'TRANSFER_SUBINVENTORY :' || NULL , 5 ) ;
948:
949: oe_debug_pub.add( 'TRANSFER_ORGANIZATION :' || NULL , 5 ) ;
950:
951: oe_debug_pub.add( 'SHIP_TO_LOCATION_ID :' || NULL , 5 ) ;
952:
953: oe_debug_pub.add( 'REQUISITION_LINE_ID :' || NULL , 5 ) ;
954:
955: oe_debug_pub.add( 'TRANSACTION_UOM :' || L_RSV_TBL ( I).reservation_uom_code , 5 ); -- 9743423

Line 953: oe_debug_pub.add( 'REQUISITION_LINE_ID :' || NULL , 5 ) ;

949: oe_debug_pub.add( 'TRANSFER_ORGANIZATION :' || NULL , 5 ) ;
950:
951: oe_debug_pub.add( 'SHIP_TO_LOCATION_ID :' || NULL , 5 ) ;
952:
953: oe_debug_pub.add( 'REQUISITION_LINE_ID :' || NULL , 5 ) ;
954:
955: oe_debug_pub.add( 'TRANSACTION_UOM :' || L_RSV_TBL ( I).reservation_uom_code , 5 ); -- 9743423
956:
957: oe_debug_pub.add( 'TRANS INTERFACE_ID :' || L_TRANSACTION_INTERFACE_ID , 5 ) ;

Line 955: oe_debug_pub.add( 'TRANSACTION_UOM :' || L_RSV_TBL ( I).reservation_uom_code , 5 ); -- 9743423

951: oe_debug_pub.add( 'SHIP_TO_LOCATION_ID :' || NULL , 5 ) ;
952:
953: oe_debug_pub.add( 'REQUISITION_LINE_ID :' || NULL , 5 ) ;
954:
955: oe_debug_pub.add( 'TRANSACTION_UOM :' || L_RSV_TBL ( I).reservation_uom_code , 5 ); -- 9743423
956:
957: oe_debug_pub.add( 'TRANS INTERFACE_ID :' || L_TRANSACTION_INTERFACE_ID , 5 ) ;
958:
959: oe_debug_pub.add( 'DEMAND_ID :' || NULL , 5 ) ;

Line 957: oe_debug_pub.add( 'TRANS INTERFACE_ID :' || L_TRANSACTION_INTERFACE_ID , 5 ) ;

953: oe_debug_pub.add( 'REQUISITION_LINE_ID :' || NULL , 5 ) ;
954:
955: oe_debug_pub.add( 'TRANSACTION_UOM :' || L_RSV_TBL ( I).reservation_uom_code , 5 ); -- 9743423
956:
957: oe_debug_pub.add( 'TRANS INTERFACE_ID :' || L_TRANSACTION_INTERFACE_ID , 5 ) ;
958:
959: oe_debug_pub.add( 'DEMAND_ID :' || NULL , 5 ) ;
960:
961: oe_debug_pub.add( 'SHIPMENT_NUMBER :' || NULL , 5 ) ;

Line 959: oe_debug_pub.add( 'DEMAND_ID :' || NULL , 5 ) ;

955: oe_debug_pub.add( 'TRANSACTION_UOM :' || L_RSV_TBL ( I).reservation_uom_code , 5 ); -- 9743423
956:
957: oe_debug_pub.add( 'TRANS INTERFACE_ID :' || L_TRANSACTION_INTERFACE_ID , 5 ) ;
958:
959: oe_debug_pub.add( 'DEMAND_ID :' || NULL , 5 ) ;
960:
961: oe_debug_pub.add( 'SHIPMENT_NUMBER :' || NULL , 5 ) ;
962:
963: oe_debug_pub.add( 'CURRENCY_CODE :' || NULL , 5 ) ;

Line 961: oe_debug_pub.add( 'SHIPMENT_NUMBER :' || NULL , 5 ) ;

957: oe_debug_pub.add( 'TRANS INTERFACE_ID :' || L_TRANSACTION_INTERFACE_ID , 5 ) ;
958:
959: oe_debug_pub.add( 'DEMAND_ID :' || NULL , 5 ) ;
960:
961: oe_debug_pub.add( 'SHIPMENT_NUMBER :' || NULL , 5 ) ;
962:
963: oe_debug_pub.add( 'CURRENCY_CODE :' || NULL , 5 ) ;
964:
965: oe_debug_pub.add( 'CURRENCY_CONVERSION_TYPE :' || NULL , 5 ) ;

Line 963: oe_debug_pub.add( 'CURRENCY_CODE :' || NULL , 5 ) ;

959: oe_debug_pub.add( 'DEMAND_ID :' || NULL , 5 ) ;
960:
961: oe_debug_pub.add( 'SHIPMENT_NUMBER :' || NULL , 5 ) ;
962:
963: oe_debug_pub.add( 'CURRENCY_CODE :' || NULL , 5 ) ;
964:
965: oe_debug_pub.add( 'CURRENCY_CONVERSION_TYPE :' || NULL , 5 ) ;
966:
967: oe_debug_pub.add( 'CURRENCY_CONVERSION_DATE :' || NULL , 5 ) ;

Line 965: oe_debug_pub.add( 'CURRENCY_CONVERSION_TYPE :' || NULL , 5 ) ;

961: oe_debug_pub.add( 'SHIPMENT_NUMBER :' || NULL , 5 ) ;
962:
963: oe_debug_pub.add( 'CURRENCY_CODE :' || NULL , 5 ) ;
964:
965: oe_debug_pub.add( 'CURRENCY_CONVERSION_TYPE :' || NULL , 5 ) ;
966:
967: oe_debug_pub.add( 'CURRENCY_CONVERSION_DATE :' || NULL , 5 ) ;
968:
969: oe_debug_pub.add( 'CURRENCY_CONVERSION_RATE :' || NULL , 5 ) ;

Line 967: oe_debug_pub.add( 'CURRENCY_CONVERSION_DATE :' || NULL , 5 ) ;

963: oe_debug_pub.add( 'CURRENCY_CODE :' || NULL , 5 ) ;
964:
965: oe_debug_pub.add( 'CURRENCY_CONVERSION_TYPE :' || NULL , 5 ) ;
966:
967: oe_debug_pub.add( 'CURRENCY_CONVERSION_DATE :' || NULL , 5 ) ;
968:
969: oe_debug_pub.add( 'CURRENCY_CONVERSION_RATE :' || NULL , 5 ) ;
970:
971: oe_debug_pub.add( 'ENCUMBRANCE_ACCOUNT :' || NULL , 5 ) ;

Line 969: oe_debug_pub.add( 'CURRENCY_CONVERSION_RATE :' || NULL , 5 ) ;

965: oe_debug_pub.add( 'CURRENCY_CONVERSION_TYPE :' || NULL , 5 ) ;
966:
967: oe_debug_pub.add( 'CURRENCY_CONVERSION_DATE :' || NULL , 5 ) ;
968:
969: oe_debug_pub.add( 'CURRENCY_CONVERSION_RATE :' || NULL , 5 ) ;
970:
971: oe_debug_pub.add( 'ENCUMBRANCE_ACCOUNT :' || NULL , 5 ) ;
972:
973: oe_debug_pub.add( 'ENCUMBRANCE_AMOUNT :' || NULL , 5 ) ;

Line 971: oe_debug_pub.add( 'ENCUMBRANCE_ACCOUNT :' || NULL , 5 ) ;

967: oe_debug_pub.add( 'CURRENCY_CONVERSION_DATE :' || NULL , 5 ) ;
968:
969: oe_debug_pub.add( 'CURRENCY_CONVERSION_RATE :' || NULL , 5 ) ;
970:
971: oe_debug_pub.add( 'ENCUMBRANCE_ACCOUNT :' || NULL , 5 ) ;
972:
973: oe_debug_pub.add( 'ENCUMBRANCE_AMOUNT :' || NULL , 5 ) ;
974:
975: oe_debug_pub.add( 'PROJECT_ID :' || L_LINE_REC.PROJECT_ID , 5 ) ;

Line 973: oe_debug_pub.add( 'ENCUMBRANCE_AMOUNT :' || NULL , 5 ) ;

969: oe_debug_pub.add( 'CURRENCY_CONVERSION_RATE :' || NULL , 5 ) ;
970:
971: oe_debug_pub.add( 'ENCUMBRANCE_ACCOUNT :' || NULL , 5 ) ;
972:
973: oe_debug_pub.add( 'ENCUMBRANCE_AMOUNT :' || NULL , 5 ) ;
974:
975: oe_debug_pub.add( 'PROJECT_ID :' || L_LINE_REC.PROJECT_ID , 5 ) ;
976:
977: oe_debug_pub.add( 'TASK_ID :' || L_LINE_REC.TASK_ID , 5 ) ;

Line 975: oe_debug_pub.add( 'PROJECT_ID :' || L_LINE_REC.PROJECT_ID , 5 ) ;

971: oe_debug_pub.add( 'ENCUMBRANCE_ACCOUNT :' || NULL , 5 ) ;
972:
973: oe_debug_pub.add( 'ENCUMBRANCE_AMOUNT :' || NULL , 5 ) ;
974:
975: oe_debug_pub.add( 'PROJECT_ID :' || L_LINE_REC.PROJECT_ID , 5 ) ;
976:
977: oe_debug_pub.add( 'TASK_ID :' || L_LINE_REC.TASK_ID , 5 ) ;
978: END IF;
979:

Line 977: oe_debug_pub.add( 'TASK_ID :' || L_LINE_REC.TASK_ID , 5 ) ;

973: oe_debug_pub.add( 'ENCUMBRANCE_AMOUNT :' || NULL , 5 ) ;
974:
975: oe_debug_pub.add( 'PROJECT_ID :' || L_LINE_REC.PROJECT_ID , 5 ) ;
976:
977: oe_debug_pub.add( 'TASK_ID :' || L_LINE_REC.TASK_ID , 5 ) ;
978: END IF;
979:
980: INSERT INTO MTL_TRANSACTIONS_INTERFACE
981: (

Line 1190: oe_debug_pub.add( 'INV IFACE: SUBINV IS NULL OR MISS_CHAR FOR INSERT - 2' , 5 ) ;

1186:
1187: IF ( l_line_rec.subinventory is null or
1188: l_line_rec.subinventory = FND_API.G_MISS_CHAR ) THEN
1189: IF l_debug_level > 0 THEN
1190: oe_debug_pub.add( 'INV IFACE: SUBINV IS NULL OR MISS_CHAR FOR INSERT - 2' , 5 ) ;
1191: END IF;
1192: -- Give a message here
1193: FND_MESSAGE.SET_NAME('ONT', 'OE_INV_IFACE_SUB');
1194: -- message should say if item is under revision/lot/locator control, use the

Line 1213: oe_debug_pub.add( 'INV IFACE: LOCATOR CONTROL CODE SELECT FAILURE' , 5 ) ;

1209: WHERE organization_id = l_line_rec.ship_from_org_id;
1210: EXCEPTION
1211: WHEN OTHERS THEN
1212: IF l_debug_level > 0 THEN
1213: oe_debug_pub.add( 'INV IFACE: LOCATOR CONTROL CODE SELECT FAILURE' , 5 ) ;
1214: END IF;
1215: x_return_status := FND_API.G_RET_STS_ERROR;
1216: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
1217: ROLLBACK TO INVENTORY_INTERFACE;

Line 1231: oe_debug_pub.add( 'INV IFACE: LOCATOR TYPE SELECT FAILURE' , 5 ) ;

1227:
1228: EXCEPTION
1229: WHEN OTHERS THEN
1230: IF l_debug_level > 0 THEN
1231: oe_debug_pub.add( 'INV IFACE: LOCATOR TYPE SELECT FAILURE' , 5 ) ;
1232: END IF;
1233: x_return_status := FND_API.G_RET_STS_ERROR;
1234: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
1235: ROLLBACK TO INVENTORY_INTERFACE;

Line 1250: oe_debug_pub.add( 'INV IFACE: LOCATION CONTROL CODE FAILURE' , 5 ) ;

1246: -- ???? warehouse or validation org?
1247: EXCEPTION
1248: WHEN OTHERS THEN
1249: IF l_debug_level > 0 THEN
1250: oe_debug_pub.add( 'INV IFACE: LOCATION CONTROL CODE FAILURE' , 5 ) ;
1251: END IF;
1252: x_return_status := FND_API.G_RET_STS_ERROR;
1253: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
1254: ROLLBACK TO INVENTORY_INTERFACE;

Line 1259: oe_debug_pub.add( 'INV IFACE: BEFORE LOCATOR_CONTROL API CALL' , 1 ) ;

1255: RETURN;
1256: END;
1257:
1258: IF l_debug_level > 0 THEN
1259: oe_debug_pub.add( 'INV IFACE: BEFORE LOCATOR_CONTROL API CALL' , 1 ) ;
1260: END IF;
1261:
1262: l_locator := INV_RESERVATION_UTIL_PVT.locator_control(
1263: p_org_control => l_stock_locator_control_code

Line 1267: oe_debug_pub.add( 'INV IFACE: AFTER LOCATOR_CONTROL API CALL - ' || TO_CHAR ( L_LOCATOR ) , 1 ) ;

1263: p_org_control => l_stock_locator_control_code
1264: ,p_sub_control => l_locator_type
1265: ,p_item_control => l_location_control_code);
1266: IF l_debug_level > 0 THEN
1267: oe_debug_pub.add( 'INV IFACE: AFTER LOCATOR_CONTROL API CALL - ' || TO_CHAR ( L_LOCATOR ) , 1 ) ;
1268: END IF;
1269:
1270: -- END IF; -- of branching HW OPM BUG#:2536589 INVCONV
1271:

Line 1278: oe_debug_pub.add( 'INV IFACE: ITEM UNDER SERIAL CONTORL , ERROR' , 5 ) ;

1274: -- 2 == YES
1275: /*ER 8419373
1276: IF nvl(l_serial_code, 1) <> 1 THEN
1277: IF l_debug_level > 0 THEN
1278: oe_debug_pub.add( 'INV IFACE: ITEM UNDER SERIAL CONTORL , ERROR' , 5 ) ;
1279: END IF;
1280: -- give a message here
1281: FND_MESSAGE.SET_NAME('ONT', 'OE_INV_IFACE_SERIAL');
1282: OE_MSG_PUB.ADD;

Line 1285: oe_debug_pub.add( 'INV IFACE: ITEM UNDER REVISION/LOT/LOCATOR/SERIAL CONTROL AND NO RESERVATION EXISTS' , 5 ) ;

1281: FND_MESSAGE.SET_NAME('ONT', 'OE_INV_IFACE_SERIAL');
1282: OE_MSG_PUB.ADD;
1283: ELSE*/
1284: IF l_debug_level > 0 THEN
1285: oe_debug_pub.add( 'INV IFACE: ITEM UNDER REVISION/LOT/LOCATOR/SERIAL CONTROL AND NO RESERVATION EXISTS' , 5 ) ;
1286: END IF;
1287: -- Give a message here
1288: FND_MESSAGE.SET_NAME('ONT', 'OE_INV_IFACE_NO_RSV');
1289: OE_MSG_PUB.ADD;

Line 1301: oe_debug_pub.add( 'INV IFACE: NO DEFAULT TRXN EXISTS FOR NON-LOT , NON-INV OPM ITEM' , 5 ) ;

1297:
1298: /* -- HW OPm BUG#:2536589 Need to check for non-lot,non-inv OPM items. INVCONV
1299: IF ( l_process_org = 1 AND l_lot = 'N' ) THEN
1300: IF l_debug_level > 0 THEN
1301: oe_debug_pub.add( 'INV IFACE: NO DEFAULT TRXN EXISTS FOR NON-LOT , NON-INV OPM ITEM' , 5 ) ;
1302: END IF;
1303: x_return_status := FND_API.G_RET_STS_ERROR;
1304: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
1305: ROLLBACK TO INVENTORY_INTERFACE;

Line 1317: oe_debug_pub.add( 'INV IFACE: INSERTING RECORD - 2' , 5 ) ;

1313: INTO l_source_line_id
1314: FROM dual;
1315:
1316: IF l_debug_level > 0 THEN
1317: oe_debug_pub.add( 'INV IFACE: INSERTING RECORD - 2' , 5 ) ;
1318:
1319: oe_debug_pub.add( 'SOURCE_CODE :' || FND_PROFILE.VALUE ( 'ONT_SOURCE_CODE' ) , 5 ) ;
1320:
1321: oe_debug_pub.add( 'SOURCE_LINE_ID :' || L_SOURCE_LINE_ID , 5 ) ;

Line 1319: oe_debug_pub.add( 'SOURCE_CODE :' || FND_PROFILE.VALUE ( 'ONT_SOURCE_CODE' ) , 5 ) ;

1315:
1316: IF l_debug_level > 0 THEN
1317: oe_debug_pub.add( 'INV IFACE: INSERTING RECORD - 2' , 5 ) ;
1318:
1319: oe_debug_pub.add( 'SOURCE_CODE :' || FND_PROFILE.VALUE ( 'ONT_SOURCE_CODE' ) , 5 ) ;
1320:
1321: oe_debug_pub.add( 'SOURCE_LINE_ID :' || L_SOURCE_LINE_ID , 5 ) ;
1322:
1323: oe_debug_pub.add( 'SOURCE_HEADER_ID :' || L_TRANSACTION_REFERENCE , 5 ) ;

Line 1321: oe_debug_pub.add( 'SOURCE_LINE_ID :' || L_SOURCE_LINE_ID , 5 ) ;

1317: oe_debug_pub.add( 'INV IFACE: INSERTING RECORD - 2' , 5 ) ;
1318:
1319: oe_debug_pub.add( 'SOURCE_CODE :' || FND_PROFILE.VALUE ( 'ONT_SOURCE_CODE' ) , 5 ) ;
1320:
1321: oe_debug_pub.add( 'SOURCE_LINE_ID :' || L_SOURCE_LINE_ID , 5 ) ;
1322:
1323: oe_debug_pub.add( 'SOURCE_HEADER_ID :' || L_TRANSACTION_REFERENCE , 5 ) ;
1324:
1325: oe_debug_pub.add( 'PROCESS_FLAG :' || 1 , 5 ) ;

Line 1323: oe_debug_pub.add( 'SOURCE_HEADER_ID :' || L_TRANSACTION_REFERENCE , 5 ) ;

1319: oe_debug_pub.add( 'SOURCE_CODE :' || FND_PROFILE.VALUE ( 'ONT_SOURCE_CODE' ) , 5 ) ;
1320:
1321: oe_debug_pub.add( 'SOURCE_LINE_ID :' || L_SOURCE_LINE_ID , 5 ) ;
1322:
1323: oe_debug_pub.add( 'SOURCE_HEADER_ID :' || L_TRANSACTION_REFERENCE , 5 ) ;
1324:
1325: oe_debug_pub.add( 'PROCESS_FLAG :' || 1 , 5 ) ;
1326:
1327: oe_debug_pub.add( 'TRANSACTION_MODE :' || 1 , 5 ) ;

Line 1325: oe_debug_pub.add( 'PROCESS_FLAG :' || 1 , 5 ) ;

1321: oe_debug_pub.add( 'SOURCE_LINE_ID :' || L_SOURCE_LINE_ID , 5 ) ;
1322:
1323: oe_debug_pub.add( 'SOURCE_HEADER_ID :' || L_TRANSACTION_REFERENCE , 5 ) ;
1324:
1325: oe_debug_pub.add( 'PROCESS_FLAG :' || 1 , 5 ) ;
1326:
1327: oe_debug_pub.add( 'TRANSACTION_MODE :' || 1 , 5 ) ;
1328:
1329: oe_debug_pub.add( 'LOCK_FLAG :' || 2 , 5 ) ;

Line 1327: oe_debug_pub.add( 'TRANSACTION_MODE :' || 1 , 5 ) ;

1323: oe_debug_pub.add( 'SOURCE_HEADER_ID :' || L_TRANSACTION_REFERENCE , 5 ) ;
1324:
1325: oe_debug_pub.add( 'PROCESS_FLAG :' || 1 , 5 ) ;
1326:
1327: oe_debug_pub.add( 'TRANSACTION_MODE :' || 1 , 5 ) ;
1328:
1329: oe_debug_pub.add( 'LOCK_FLAG :' || 2 , 5 ) ;
1330:
1331: oe_debug_pub.add( 'TRANSACTION_HEADER_ID :' || L_TRANSACTION_HEADER_ID , 5 ) ;

Line 1329: oe_debug_pub.add( 'LOCK_FLAG :' || 2 , 5 ) ;

1325: oe_debug_pub.add( 'PROCESS_FLAG :' || 1 , 5 ) ;
1326:
1327: oe_debug_pub.add( 'TRANSACTION_MODE :' || 1 , 5 ) ;
1328:
1329: oe_debug_pub.add( 'LOCK_FLAG :' || 2 , 5 ) ;
1330:
1331: oe_debug_pub.add( 'TRANSACTION_HEADER_ID :' || L_TRANSACTION_HEADER_ID , 5 ) ;
1332:
1333: oe_debug_pub.add( 'INVENTORY_ITEM_ID :' || L_LINE_REC.INVENTORY_ITEM_ID , 5 ) ;

Line 1331: oe_debug_pub.add( 'TRANSACTION_HEADER_ID :' || L_TRANSACTION_HEADER_ID , 5 ) ;

1327: oe_debug_pub.add( 'TRANSACTION_MODE :' || 1 , 5 ) ;
1328:
1329: oe_debug_pub.add( 'LOCK_FLAG :' || 2 , 5 ) ;
1330:
1331: oe_debug_pub.add( 'TRANSACTION_HEADER_ID :' || L_TRANSACTION_HEADER_ID , 5 ) ;
1332:
1333: oe_debug_pub.add( 'INVENTORY_ITEM_ID :' || L_LINE_REC.INVENTORY_ITEM_ID , 5 ) ;
1334:
1335: oe_debug_pub.add( 'SUBINVENTORY_CODE :' || L_LINE_REC.SUBINVENTORY , 5 ) ;

Line 1333: oe_debug_pub.add( 'INVENTORY_ITEM_ID :' || L_LINE_REC.INVENTORY_ITEM_ID , 5 ) ;

1329: oe_debug_pub.add( 'LOCK_FLAG :' || 2 , 5 ) ;
1330:
1331: oe_debug_pub.add( 'TRANSACTION_HEADER_ID :' || L_TRANSACTION_HEADER_ID , 5 ) ;
1332:
1333: oe_debug_pub.add( 'INVENTORY_ITEM_ID :' || L_LINE_REC.INVENTORY_ITEM_ID , 5 ) ;
1334:
1335: oe_debug_pub.add( 'SUBINVENTORY_CODE :' || L_LINE_REC.SUBINVENTORY , 5 ) ;
1336:
1337: oe_debug_pub.add( 'TRANSACTION_QUANTITY :' || ( -1 * L_LINE_REC.ORDERED_QUANTITY ) || ' OR ' || ( -1 * L_REMAINED_QTY ) , 5 ) ;

Line 1335: oe_debug_pub.add( 'SUBINVENTORY_CODE :' || L_LINE_REC.SUBINVENTORY , 5 ) ;

1331: oe_debug_pub.add( 'TRANSACTION_HEADER_ID :' || L_TRANSACTION_HEADER_ID , 5 ) ;
1332:
1333: oe_debug_pub.add( 'INVENTORY_ITEM_ID :' || L_LINE_REC.INVENTORY_ITEM_ID , 5 ) ;
1334:
1335: oe_debug_pub.add( 'SUBINVENTORY_CODE :' || L_LINE_REC.SUBINVENTORY , 5 ) ;
1336:
1337: oe_debug_pub.add( 'TRANSACTION_QUANTITY :' || ( -1 * L_LINE_REC.ORDERED_QUANTITY ) || ' OR ' || ( -1 * L_REMAINED_QTY ) , 5 ) ;
1338:
1339:

Line 1337: oe_debug_pub.add( 'TRANSACTION_QUANTITY :' || ( -1 * L_LINE_REC.ORDERED_QUANTITY ) || ' OR ' || ( -1 * L_REMAINED_QTY ) , 5 ) ;

1333: oe_debug_pub.add( 'INVENTORY_ITEM_ID :' || L_LINE_REC.INVENTORY_ITEM_ID , 5 ) ;
1334:
1335: oe_debug_pub.add( 'SUBINVENTORY_CODE :' || L_LINE_REC.SUBINVENTORY , 5 ) ;
1336:
1337: oe_debug_pub.add( 'TRANSACTION_QUANTITY :' || ( -1 * L_LINE_REC.ORDERED_QUANTITY ) || ' OR ' || ( -1 * L_REMAINED_QTY ) , 5 ) ;
1338:
1339:
1340: -- (-1 * decode(reservation_flag, 'Y', l_remained_qty, l_line_rec.ordered_quantity)),1);
1341:

Line 1343: -- bug 5897965 oe_debug_pub.add( 'TRANSACTION_DATE :' || l_ordered_date , 5 ) ;

1339:
1340: -- (-1 * decode(reservation_flag, 'Y', l_remained_qty, l_line_rec.ordered_quantity)),1);
1341:
1342:
1343: -- bug 5897965 oe_debug_pub.add( 'TRANSACTION_DATE :' || l_ordered_date , 5 ) ;
1344:
1345: oe_debug_pub.add( 'TRANSACTION_DATE :' || l_trx_date_for_inv_iface , 5 ) ; --bug5897965
1346:
1347: oe_debug_pub.add( 'ORGANIZATION_ID :' || L_LINE_REC.SHIP_FROM_ORG_ID , 5 ) ;

Line 1345: oe_debug_pub.add( 'TRANSACTION_DATE :' || l_trx_date_for_inv_iface , 5 ) ; --bug5897965

1341:
1342:
1343: -- bug 5897965 oe_debug_pub.add( 'TRANSACTION_DATE :' || l_ordered_date , 5 ) ;
1344:
1345: oe_debug_pub.add( 'TRANSACTION_DATE :' || l_trx_date_for_inv_iface , 5 ) ; --bug5897965
1346:
1347: oe_debug_pub.add( 'ORGANIZATION_ID :' || L_LINE_REC.SHIP_FROM_ORG_ID , 5 ) ;
1348:
1349: oe_debug_pub.add( 'ACCT_PERIOD_ID :' || NULL , 5 ) ;

Line 1347: oe_debug_pub.add( 'ORGANIZATION_ID :' || L_LINE_REC.SHIP_FROM_ORG_ID , 5 ) ;

1343: -- bug 5897965 oe_debug_pub.add( 'TRANSACTION_DATE :' || l_ordered_date , 5 ) ;
1344:
1345: oe_debug_pub.add( 'TRANSACTION_DATE :' || l_trx_date_for_inv_iface , 5 ) ; --bug5897965
1346:
1347: oe_debug_pub.add( 'ORGANIZATION_ID :' || L_LINE_REC.SHIP_FROM_ORG_ID , 5 ) ;
1348:
1349: oe_debug_pub.add( 'ACCT_PERIOD_ID :' || NULL , 5 ) ;
1350:
1351: oe_debug_pub.add( 'LAST_UPDATE_DATE :' || SYSDATE , 5 ) ;

Line 1349: oe_debug_pub.add( 'ACCT_PERIOD_ID :' || NULL , 5 ) ;

1345: oe_debug_pub.add( 'TRANSACTION_DATE :' || l_trx_date_for_inv_iface , 5 ) ; --bug5897965
1346:
1347: oe_debug_pub.add( 'ORGANIZATION_ID :' || L_LINE_REC.SHIP_FROM_ORG_ID , 5 ) ;
1348:
1349: oe_debug_pub.add( 'ACCT_PERIOD_ID :' || NULL , 5 ) ;
1350:
1351: oe_debug_pub.add( 'LAST_UPDATE_DATE :' || SYSDATE , 5 ) ;
1352:
1353: oe_debug_pub.add( 'LAST_UPDATED_BY :' || FND_GLOBAL.USER_ID , 5 ) ;

Line 1351: oe_debug_pub.add( 'LAST_UPDATE_DATE :' || SYSDATE , 5 ) ;

1347: oe_debug_pub.add( 'ORGANIZATION_ID :' || L_LINE_REC.SHIP_FROM_ORG_ID , 5 ) ;
1348:
1349: oe_debug_pub.add( 'ACCT_PERIOD_ID :' || NULL , 5 ) ;
1350:
1351: oe_debug_pub.add( 'LAST_UPDATE_DATE :' || SYSDATE , 5 ) ;
1352:
1353: oe_debug_pub.add( 'LAST_UPDATED_BY :' || FND_GLOBAL.USER_ID , 5 ) ;
1354:
1355: oe_debug_pub.add( 'CREATION_DATE :' || SYSDATE , 5 ) ;

Line 1353: oe_debug_pub.add( 'LAST_UPDATED_BY :' || FND_GLOBAL.USER_ID , 5 ) ;

1349: oe_debug_pub.add( 'ACCT_PERIOD_ID :' || NULL , 5 ) ;
1350:
1351: oe_debug_pub.add( 'LAST_UPDATE_DATE :' || SYSDATE , 5 ) ;
1352:
1353: oe_debug_pub.add( 'LAST_UPDATED_BY :' || FND_GLOBAL.USER_ID , 5 ) ;
1354:
1355: oe_debug_pub.add( 'CREATION_DATE :' || SYSDATE , 5 ) ;
1356:
1357: oe_debug_pub.add( 'CREATED_BY :' || FND_GLOBAL.USER_ID , 5 ) ;

Line 1355: oe_debug_pub.add( 'CREATION_DATE :' || SYSDATE , 5 ) ;

1351: oe_debug_pub.add( 'LAST_UPDATE_DATE :' || SYSDATE , 5 ) ;
1352:
1353: oe_debug_pub.add( 'LAST_UPDATED_BY :' || FND_GLOBAL.USER_ID , 5 ) ;
1354:
1355: oe_debug_pub.add( 'CREATION_DATE :' || SYSDATE , 5 ) ;
1356:
1357: oe_debug_pub.add( 'CREATED_BY :' || FND_GLOBAL.USER_ID , 5 ) ;
1358:
1359: oe_debug_pub.add( 'TRANSACTION_SOURCE_ID :' || L_SALES_ORDER_ID , 5 ) ;

Line 1357: oe_debug_pub.add( 'CREATED_BY :' || FND_GLOBAL.USER_ID , 5 ) ;

1353: oe_debug_pub.add( 'LAST_UPDATED_BY :' || FND_GLOBAL.USER_ID , 5 ) ;
1354:
1355: oe_debug_pub.add( 'CREATION_DATE :' || SYSDATE , 5 ) ;
1356:
1357: oe_debug_pub.add( 'CREATED_BY :' || FND_GLOBAL.USER_ID , 5 ) ;
1358:
1359: oe_debug_pub.add( 'TRANSACTION_SOURCE_ID :' || L_SALES_ORDER_ID , 5 ) ;
1360:
1361: oe_debug_pub.add( 'DSP_SEGMENT1 :' || L_ORDER_NUMBER , 5 ) ;

Line 1359: oe_debug_pub.add( 'TRANSACTION_SOURCE_ID :' || L_SALES_ORDER_ID , 5 ) ;

1355: oe_debug_pub.add( 'CREATION_DATE :' || SYSDATE , 5 ) ;
1356:
1357: oe_debug_pub.add( 'CREATED_BY :' || FND_GLOBAL.USER_ID , 5 ) ;
1358:
1359: oe_debug_pub.add( 'TRANSACTION_SOURCE_ID :' || L_SALES_ORDER_ID , 5 ) ;
1360:
1361: oe_debug_pub.add( 'DSP_SEGMENT1 :' || L_ORDER_NUMBER , 5 ) ;
1362:
1363: oe_debug_pub.add( 'DSP_SEGMENT2 :' || L_ORDER_TYPE_NAME , 5 ) ;

Line 1361: oe_debug_pub.add( 'DSP_SEGMENT1 :' || L_ORDER_NUMBER , 5 ) ;

1357: oe_debug_pub.add( 'CREATED_BY :' || FND_GLOBAL.USER_ID , 5 ) ;
1358:
1359: oe_debug_pub.add( 'TRANSACTION_SOURCE_ID :' || L_SALES_ORDER_ID , 5 ) ;
1360:
1361: oe_debug_pub.add( 'DSP_SEGMENT1 :' || L_ORDER_NUMBER , 5 ) ;
1362:
1363: oe_debug_pub.add( 'DSP_SEGMENT2 :' || L_ORDER_TYPE_NAME , 5 ) ;
1364:
1365: oe_debug_pub.add( 'DSP_SEGMENT3 :' || FND_PROFILE.VALUE ( 'ONT_SOURCE_CODE' ) , 5 ) ;

Line 1363: oe_debug_pub.add( 'DSP_SEGMENT2 :' || L_ORDER_TYPE_NAME , 5 ) ;

1359: oe_debug_pub.add( 'TRANSACTION_SOURCE_ID :' || L_SALES_ORDER_ID , 5 ) ;
1360:
1361: oe_debug_pub.add( 'DSP_SEGMENT1 :' || L_ORDER_NUMBER , 5 ) ;
1362:
1363: oe_debug_pub.add( 'DSP_SEGMENT2 :' || L_ORDER_TYPE_NAME , 5 ) ;
1364:
1365: oe_debug_pub.add( 'DSP_SEGMENT3 :' || FND_PROFILE.VALUE ( 'ONT_SOURCE_CODE' ) , 5 ) ;
1366:
1367: oe_debug_pub.add( 'TRANSACTION_SOURCE_TYPE_ID :' || TO_CHAR ( 2 ) , 5 ) ;

Line 1365: oe_debug_pub.add( 'DSP_SEGMENT3 :' || FND_PROFILE.VALUE ( 'ONT_SOURCE_CODE' ) , 5 ) ;

1361: oe_debug_pub.add( 'DSP_SEGMENT1 :' || L_ORDER_NUMBER , 5 ) ;
1362:
1363: oe_debug_pub.add( 'DSP_SEGMENT2 :' || L_ORDER_TYPE_NAME , 5 ) ;
1364:
1365: oe_debug_pub.add( 'DSP_SEGMENT3 :' || FND_PROFILE.VALUE ( 'ONT_SOURCE_CODE' ) , 5 ) ;
1366:
1367: oe_debug_pub.add( 'TRANSACTION_SOURCE_TYPE_ID :' || TO_CHAR ( 2 ) , 5 ) ;
1368:
1369: oe_debug_pub.add( 'TRANSACTION_ACTION_ID :' || TO_CHAR ( 1 ) , 5 ) ;

Line 1367: oe_debug_pub.add( 'TRANSACTION_SOURCE_TYPE_ID :' || TO_CHAR ( 2 ) , 5 ) ;

1363: oe_debug_pub.add( 'DSP_SEGMENT2 :' || L_ORDER_TYPE_NAME , 5 ) ;
1364:
1365: oe_debug_pub.add( 'DSP_SEGMENT3 :' || FND_PROFILE.VALUE ( 'ONT_SOURCE_CODE' ) , 5 ) ;
1366:
1367: oe_debug_pub.add( 'TRANSACTION_SOURCE_TYPE_ID :' || TO_CHAR ( 2 ) , 5 ) ;
1368:
1369: oe_debug_pub.add( 'TRANSACTION_ACTION_ID :' || TO_CHAR ( 1 ) , 5 ) ;
1370:
1371: oe_debug_pub.add( 'TRANSACTION_TYPE_ID :' || TO_CHAR ( 33 ) , 5 ) ;

Line 1369: oe_debug_pub.add( 'TRANSACTION_ACTION_ID :' || TO_CHAR ( 1 ) , 5 ) ;

1365: oe_debug_pub.add( 'DSP_SEGMENT3 :' || FND_PROFILE.VALUE ( 'ONT_SOURCE_CODE' ) , 5 ) ;
1366:
1367: oe_debug_pub.add( 'TRANSACTION_SOURCE_TYPE_ID :' || TO_CHAR ( 2 ) , 5 ) ;
1368:
1369: oe_debug_pub.add( 'TRANSACTION_ACTION_ID :' || TO_CHAR ( 1 ) , 5 ) ;
1370:
1371: oe_debug_pub.add( 'TRANSACTION_TYPE_ID :' || TO_CHAR ( 33 ) , 5 ) ;
1372:
1373: oe_debug_pub.add( 'DISTRIBUTION_ACCOUNT_ID :' || L_TRANS_ACC , 5 ) ;

Line 1371: oe_debug_pub.add( 'TRANSACTION_TYPE_ID :' || TO_CHAR ( 33 ) , 5 ) ;

1367: oe_debug_pub.add( 'TRANSACTION_SOURCE_TYPE_ID :' || TO_CHAR ( 2 ) , 5 ) ;
1368:
1369: oe_debug_pub.add( 'TRANSACTION_ACTION_ID :' || TO_CHAR ( 1 ) , 5 ) ;
1370:
1371: oe_debug_pub.add( 'TRANSACTION_TYPE_ID :' || TO_CHAR ( 33 ) , 5 ) ;
1372:
1373: oe_debug_pub.add( 'DISTRIBUTION_ACCOUNT_ID :' || L_TRANS_ACC , 5 ) ;
1374:
1375: oe_debug_pub.add( 'TRANSACTION_REFERENCE :' || L_TRANSACTION_REFERENCE , 5 ) ;

Line 1373: oe_debug_pub.add( 'DISTRIBUTION_ACCOUNT_ID :' || L_TRANS_ACC , 5 ) ;

1369: oe_debug_pub.add( 'TRANSACTION_ACTION_ID :' || TO_CHAR ( 1 ) , 5 ) ;
1370:
1371: oe_debug_pub.add( 'TRANSACTION_TYPE_ID :' || TO_CHAR ( 33 ) , 5 ) ;
1372:
1373: oe_debug_pub.add( 'DISTRIBUTION_ACCOUNT_ID :' || L_TRANS_ACC , 5 ) ;
1374:
1375: oe_debug_pub.add( 'TRANSACTION_REFERENCE :' || L_TRANSACTION_REFERENCE , 5 ) ;
1376:
1377: oe_debug_pub.add( 'TRX_SOURCE_LINE_ID :' || L_LINE_REC.LINE_ID , 5 ) ;

Line 1375: oe_debug_pub.add( 'TRANSACTION_REFERENCE :' || L_TRANSACTION_REFERENCE , 5 ) ;

1371: oe_debug_pub.add( 'TRANSACTION_TYPE_ID :' || TO_CHAR ( 33 ) , 5 ) ;
1372:
1373: oe_debug_pub.add( 'DISTRIBUTION_ACCOUNT_ID :' || L_TRANS_ACC , 5 ) ;
1374:
1375: oe_debug_pub.add( 'TRANSACTION_REFERENCE :' || L_TRANSACTION_REFERENCE , 5 ) ;
1376:
1377: oe_debug_pub.add( 'TRX_SOURCE_LINE_ID :' || L_LINE_REC.LINE_ID , 5 ) ;
1378:
1379: oe_debug_pub.add( 'TRX_SOURCE_DELIVERY_ID :' || NULL , 5 ) ;

Line 1377: oe_debug_pub.add( 'TRX_SOURCE_LINE_ID :' || L_LINE_REC.LINE_ID , 5 ) ;

1373: oe_debug_pub.add( 'DISTRIBUTION_ACCOUNT_ID :' || L_TRANS_ACC , 5 ) ;
1374:
1375: oe_debug_pub.add( 'TRANSACTION_REFERENCE :' || L_TRANSACTION_REFERENCE , 5 ) ;
1376:
1377: oe_debug_pub.add( 'TRX_SOURCE_LINE_ID :' || L_LINE_REC.LINE_ID , 5 ) ;
1378:
1379: oe_debug_pub.add( 'TRX_SOURCE_DELIVERY_ID :' || NULL , 5 ) ;
1380:
1381: oe_debug_pub.add( 'REVISION :' || NULL , 5 ) ;

Line 1379: oe_debug_pub.add( 'TRX_SOURCE_DELIVERY_ID :' || NULL , 5 ) ;

1375: oe_debug_pub.add( 'TRANSACTION_REFERENCE :' || L_TRANSACTION_REFERENCE , 5 ) ;
1376:
1377: oe_debug_pub.add( 'TRX_SOURCE_LINE_ID :' || L_LINE_REC.LINE_ID , 5 ) ;
1378:
1379: oe_debug_pub.add( 'TRX_SOURCE_DELIVERY_ID :' || NULL , 5 ) ;
1380:
1381: oe_debug_pub.add( 'REVISION :' || NULL , 5 ) ;
1382:
1383: oe_debug_pub.add( 'LOCATOR_ID :' || NULL , 5 ) ;

Line 1381: oe_debug_pub.add( 'REVISION :' || NULL , 5 ) ;

1377: oe_debug_pub.add( 'TRX_SOURCE_LINE_ID :' || L_LINE_REC.LINE_ID , 5 ) ;
1378:
1379: oe_debug_pub.add( 'TRX_SOURCE_DELIVERY_ID :' || NULL , 5 ) ;
1380:
1381: oe_debug_pub.add( 'REVISION :' || NULL , 5 ) ;
1382:
1383: oe_debug_pub.add( 'LOCATOR_ID :' || NULL , 5 ) ;
1384:
1385: oe_debug_pub.add( 'LOC_SEGMENT1 :' || NULL , 5 ) ;

Line 1383: oe_debug_pub.add( 'LOCATOR_ID :' || NULL , 5 ) ;

1379: oe_debug_pub.add( 'TRX_SOURCE_DELIVERY_ID :' || NULL , 5 ) ;
1380:
1381: oe_debug_pub.add( 'REVISION :' || NULL , 5 ) ;
1382:
1383: oe_debug_pub.add( 'LOCATOR_ID :' || NULL , 5 ) ;
1384:
1385: oe_debug_pub.add( 'LOC_SEGMENT1 :' || NULL , 5 ) ;
1386:
1387: oe_debug_pub.add( 'LOC_SEGMENT2 :' || NULL , 5 ) ;

Line 1385: oe_debug_pub.add( 'LOC_SEGMENT1 :' || NULL , 5 ) ;

1381: oe_debug_pub.add( 'REVISION :' || NULL , 5 ) ;
1382:
1383: oe_debug_pub.add( 'LOCATOR_ID :' || NULL , 5 ) ;
1384:
1385: oe_debug_pub.add( 'LOC_SEGMENT1 :' || NULL , 5 ) ;
1386:
1387: oe_debug_pub.add( 'LOC_SEGMENT2 :' || NULL , 5 ) ;
1388:
1389: oe_debug_pub.add( 'LOC_SEGMENT3 :' || NULL , 5 ) ;

Line 1387: oe_debug_pub.add( 'LOC_SEGMENT2 :' || NULL , 5 ) ;

1383: oe_debug_pub.add( 'LOCATOR_ID :' || NULL , 5 ) ;
1384:
1385: oe_debug_pub.add( 'LOC_SEGMENT1 :' || NULL , 5 ) ;
1386:
1387: oe_debug_pub.add( 'LOC_SEGMENT2 :' || NULL , 5 ) ;
1388:
1389: oe_debug_pub.add( 'LOC_SEGMENT3 :' || NULL , 5 ) ;
1390:
1391: oe_debug_pub.add( 'LOC_SEGMENT4 :' || NULL , 5 ) ;

Line 1389: oe_debug_pub.add( 'LOC_SEGMENT3 :' || NULL , 5 ) ;

1385: oe_debug_pub.add( 'LOC_SEGMENT1 :' || NULL , 5 ) ;
1386:
1387: oe_debug_pub.add( 'LOC_SEGMENT2 :' || NULL , 5 ) ;
1388:
1389: oe_debug_pub.add( 'LOC_SEGMENT3 :' || NULL , 5 ) ;
1390:
1391: oe_debug_pub.add( 'LOC_SEGMENT4 :' || NULL , 5 ) ;
1392:
1393: oe_debug_pub.add( 'REQUIRED_FLAG :' || NULL , 5 ) ;

Line 1391: oe_debug_pub.add( 'LOC_SEGMENT4 :' || NULL , 5 ) ;

1387: oe_debug_pub.add( 'LOC_SEGMENT2 :' || NULL , 5 ) ;
1388:
1389: oe_debug_pub.add( 'LOC_SEGMENT3 :' || NULL , 5 ) ;
1390:
1391: oe_debug_pub.add( 'LOC_SEGMENT4 :' || NULL , 5 ) ;
1392:
1393: oe_debug_pub.add( 'REQUIRED_FLAG :' || NULL , 5 ) ;
1394:
1395: oe_debug_pub.add( 'PICKING_LINE_ID :' || NULL , 5 ) ;

Line 1393: oe_debug_pub.add( 'REQUIRED_FLAG :' || NULL , 5 ) ;

1389: oe_debug_pub.add( 'LOC_SEGMENT3 :' || NULL , 5 ) ;
1390:
1391: oe_debug_pub.add( 'LOC_SEGMENT4 :' || NULL , 5 ) ;
1392:
1393: oe_debug_pub.add( 'REQUIRED_FLAG :' || NULL , 5 ) ;
1394:
1395: oe_debug_pub.add( 'PICKING_LINE_ID :' || NULL , 5 ) ;
1396:
1397: oe_debug_pub.add( 'TRANSFER_SUBINVENTORY :' || NULL , 5 ) ;

Line 1395: oe_debug_pub.add( 'PICKING_LINE_ID :' || NULL , 5 ) ;

1391: oe_debug_pub.add( 'LOC_SEGMENT4 :' || NULL , 5 ) ;
1392:
1393: oe_debug_pub.add( 'REQUIRED_FLAG :' || NULL , 5 ) ;
1394:
1395: oe_debug_pub.add( 'PICKING_LINE_ID :' || NULL , 5 ) ;
1396:
1397: oe_debug_pub.add( 'TRANSFER_SUBINVENTORY :' || NULL , 5 ) ;
1398:
1399: oe_debug_pub.add( 'TRANSFER_ORGANIZATION :' || NULL , 5 ) ;

Line 1397: oe_debug_pub.add( 'TRANSFER_SUBINVENTORY :' || NULL , 5 ) ;

1393: oe_debug_pub.add( 'REQUIRED_FLAG :' || NULL , 5 ) ;
1394:
1395: oe_debug_pub.add( 'PICKING_LINE_ID :' || NULL , 5 ) ;
1396:
1397: oe_debug_pub.add( 'TRANSFER_SUBINVENTORY :' || NULL , 5 ) ;
1398:
1399: oe_debug_pub.add( 'TRANSFER_ORGANIZATION :' || NULL , 5 ) ;
1400:
1401: oe_debug_pub.add( 'SHIP_TO_LOCATION_ID :' || NULL , 5 ) ;

Line 1399: oe_debug_pub.add( 'TRANSFER_ORGANIZATION :' || NULL , 5 ) ;

1395: oe_debug_pub.add( 'PICKING_LINE_ID :' || NULL , 5 ) ;
1396:
1397: oe_debug_pub.add( 'TRANSFER_SUBINVENTORY :' || NULL , 5 ) ;
1398:
1399: oe_debug_pub.add( 'TRANSFER_ORGANIZATION :' || NULL , 5 ) ;
1400:
1401: oe_debug_pub.add( 'SHIP_TO_LOCATION_ID :' || NULL , 5 ) ;
1402:
1403: oe_debug_pub.add( 'REQUISITION_LINE_ID :' || NULL , 5 ) ;

Line 1401: oe_debug_pub.add( 'SHIP_TO_LOCATION_ID :' || NULL , 5 ) ;

1397: oe_debug_pub.add( 'TRANSFER_SUBINVENTORY :' || NULL , 5 ) ;
1398:
1399: oe_debug_pub.add( 'TRANSFER_ORGANIZATION :' || NULL , 5 ) ;
1400:
1401: oe_debug_pub.add( 'SHIP_TO_LOCATION_ID :' || NULL , 5 ) ;
1402:
1403: oe_debug_pub.add( 'REQUISITION_LINE_ID :' || NULL , 5 ) ;
1404:
1405: oe_debug_pub.add( 'TRANSACTION_UOM :' || L_LINE_REC.ORDER_QUANTITY_UOM , 5 ) ;

Line 1403: oe_debug_pub.add( 'REQUISITION_LINE_ID :' || NULL , 5 ) ;

1399: oe_debug_pub.add( 'TRANSFER_ORGANIZATION :' || NULL , 5 ) ;
1400:
1401: oe_debug_pub.add( 'SHIP_TO_LOCATION_ID :' || NULL , 5 ) ;
1402:
1403: oe_debug_pub.add( 'REQUISITION_LINE_ID :' || NULL , 5 ) ;
1404:
1405: oe_debug_pub.add( 'TRANSACTION_UOM :' || L_LINE_REC.ORDER_QUANTITY_UOM , 5 ) ;
1406:
1407: oe_debug_pub.add( 'TRANS INTERFACE_ID :' || L_TRANSACTION_INTERFACE_ID , 5 ) ;

Line 1405: oe_debug_pub.add( 'TRANSACTION_UOM :' || L_LINE_REC.ORDER_QUANTITY_UOM , 5 ) ;

1401: oe_debug_pub.add( 'SHIP_TO_LOCATION_ID :' || NULL , 5 ) ;
1402:
1403: oe_debug_pub.add( 'REQUISITION_LINE_ID :' || NULL , 5 ) ;
1404:
1405: oe_debug_pub.add( 'TRANSACTION_UOM :' || L_LINE_REC.ORDER_QUANTITY_UOM , 5 ) ;
1406:
1407: oe_debug_pub.add( 'TRANS INTERFACE_ID :' || L_TRANSACTION_INTERFACE_ID , 5 ) ;
1408:
1409: oe_debug_pub.add( 'DEMAND_ID :' || NULL , 5 ) ;

Line 1407: oe_debug_pub.add( 'TRANS INTERFACE_ID :' || L_TRANSACTION_INTERFACE_ID , 5 ) ;

1403: oe_debug_pub.add( 'REQUISITION_LINE_ID :' || NULL , 5 ) ;
1404:
1405: oe_debug_pub.add( 'TRANSACTION_UOM :' || L_LINE_REC.ORDER_QUANTITY_UOM , 5 ) ;
1406:
1407: oe_debug_pub.add( 'TRANS INTERFACE_ID :' || L_TRANSACTION_INTERFACE_ID , 5 ) ;
1408:
1409: oe_debug_pub.add( 'DEMAND_ID :' || NULL , 5 ) ;
1410:
1411: oe_debug_pub.add( 'SHIPMENT_NUMBER :' || NULL , 5 ) ;

Line 1409: oe_debug_pub.add( 'DEMAND_ID :' || NULL , 5 ) ;

1405: oe_debug_pub.add( 'TRANSACTION_UOM :' || L_LINE_REC.ORDER_QUANTITY_UOM , 5 ) ;
1406:
1407: oe_debug_pub.add( 'TRANS INTERFACE_ID :' || L_TRANSACTION_INTERFACE_ID , 5 ) ;
1408:
1409: oe_debug_pub.add( 'DEMAND_ID :' || NULL , 5 ) ;
1410:
1411: oe_debug_pub.add( 'SHIPMENT_NUMBER :' || NULL , 5 ) ;
1412:
1413: oe_debug_pub.add( 'CURRENCY_CODE :' || NULL , 5 ) ;

Line 1411: oe_debug_pub.add( 'SHIPMENT_NUMBER :' || NULL , 5 ) ;

1407: oe_debug_pub.add( 'TRANS INTERFACE_ID :' || L_TRANSACTION_INTERFACE_ID , 5 ) ;
1408:
1409: oe_debug_pub.add( 'DEMAND_ID :' || NULL , 5 ) ;
1410:
1411: oe_debug_pub.add( 'SHIPMENT_NUMBER :' || NULL , 5 ) ;
1412:
1413: oe_debug_pub.add( 'CURRENCY_CODE :' || NULL , 5 ) ;
1414:
1415: oe_debug_pub.add( 'CURRENCY_CONVERSION_TYPE :' || NULL , 5 ) ;

Line 1413: oe_debug_pub.add( 'CURRENCY_CODE :' || NULL , 5 ) ;

1409: oe_debug_pub.add( 'DEMAND_ID :' || NULL , 5 ) ;
1410:
1411: oe_debug_pub.add( 'SHIPMENT_NUMBER :' || NULL , 5 ) ;
1412:
1413: oe_debug_pub.add( 'CURRENCY_CODE :' || NULL , 5 ) ;
1414:
1415: oe_debug_pub.add( 'CURRENCY_CONVERSION_TYPE :' || NULL , 5 ) ;
1416:
1417: oe_debug_pub.add( 'CURRENCY_CONVERSION_DATE :' || NULL , 5 ) ;

Line 1415: oe_debug_pub.add( 'CURRENCY_CONVERSION_TYPE :' || NULL , 5 ) ;

1411: oe_debug_pub.add( 'SHIPMENT_NUMBER :' || NULL , 5 ) ;
1412:
1413: oe_debug_pub.add( 'CURRENCY_CODE :' || NULL , 5 ) ;
1414:
1415: oe_debug_pub.add( 'CURRENCY_CONVERSION_TYPE :' || NULL , 5 ) ;
1416:
1417: oe_debug_pub.add( 'CURRENCY_CONVERSION_DATE :' || NULL , 5 ) ;
1418:
1419: oe_debug_pub.add( 'CURRENCY_CONVERSION_RATE :' || NULL , 5 ) ;

Line 1417: oe_debug_pub.add( 'CURRENCY_CONVERSION_DATE :' || NULL , 5 ) ;

1413: oe_debug_pub.add( 'CURRENCY_CODE :' || NULL , 5 ) ;
1414:
1415: oe_debug_pub.add( 'CURRENCY_CONVERSION_TYPE :' || NULL , 5 ) ;
1416:
1417: oe_debug_pub.add( 'CURRENCY_CONVERSION_DATE :' || NULL , 5 ) ;
1418:
1419: oe_debug_pub.add( 'CURRENCY_CONVERSION_RATE :' || NULL , 5 ) ;
1420:
1421: oe_debug_pub.add( 'ENCUMBRANCE_ACCOUNT :' || NULL , 5 ) ;

Line 1419: oe_debug_pub.add( 'CURRENCY_CONVERSION_RATE :' || NULL , 5 ) ;

1415: oe_debug_pub.add( 'CURRENCY_CONVERSION_TYPE :' || NULL , 5 ) ;
1416:
1417: oe_debug_pub.add( 'CURRENCY_CONVERSION_DATE :' || NULL , 5 ) ;
1418:
1419: oe_debug_pub.add( 'CURRENCY_CONVERSION_RATE :' || NULL , 5 ) ;
1420:
1421: oe_debug_pub.add( 'ENCUMBRANCE_ACCOUNT :' || NULL , 5 ) ;
1422:
1423: oe_debug_pub.add( 'ENCUMBRANCE_AMOUNT :' || NULL , 5 ) ;

Line 1421: oe_debug_pub.add( 'ENCUMBRANCE_ACCOUNT :' || NULL , 5 ) ;

1417: oe_debug_pub.add( 'CURRENCY_CONVERSION_DATE :' || NULL , 5 ) ;
1418:
1419: oe_debug_pub.add( 'CURRENCY_CONVERSION_RATE :' || NULL , 5 ) ;
1420:
1421: oe_debug_pub.add( 'ENCUMBRANCE_ACCOUNT :' || NULL , 5 ) ;
1422:
1423: oe_debug_pub.add( 'ENCUMBRANCE_AMOUNT :' || NULL , 5 ) ;
1424:
1425: oe_debug_pub.add( 'PROJECT_ID :' || L_LINE_REC.PROJECT_ID , 5 ) ;

Line 1423: oe_debug_pub.add( 'ENCUMBRANCE_AMOUNT :' || NULL , 5 ) ;

1419: oe_debug_pub.add( 'CURRENCY_CONVERSION_RATE :' || NULL , 5 ) ;
1420:
1421: oe_debug_pub.add( 'ENCUMBRANCE_ACCOUNT :' || NULL , 5 ) ;
1422:
1423: oe_debug_pub.add( 'ENCUMBRANCE_AMOUNT :' || NULL , 5 ) ;
1424:
1425: oe_debug_pub.add( 'PROJECT_ID :' || L_LINE_REC.PROJECT_ID , 5 ) ;
1426:
1427: oe_debug_pub.add( 'TASK_ID :' || L_LINE_REC.TASK_ID , 5 ) ;

Line 1425: oe_debug_pub.add( 'PROJECT_ID :' || L_LINE_REC.PROJECT_ID , 5 ) ;

1421: oe_debug_pub.add( 'ENCUMBRANCE_ACCOUNT :' || NULL , 5 ) ;
1422:
1423: oe_debug_pub.add( 'ENCUMBRANCE_AMOUNT :' || NULL , 5 ) ;
1424:
1425: oe_debug_pub.add( 'PROJECT_ID :' || L_LINE_REC.PROJECT_ID , 5 ) ;
1426:
1427: oe_debug_pub.add( 'TASK_ID :' || L_LINE_REC.TASK_ID , 5 ) ;
1428: END IF;
1429:

Line 1427: oe_debug_pub.add( 'TASK_ID :' || L_LINE_REC.TASK_ID , 5 ) ;

1423: oe_debug_pub.add( 'ENCUMBRANCE_AMOUNT :' || NULL , 5 ) ;
1424:
1425: oe_debug_pub.add( 'PROJECT_ID :' || L_LINE_REC.PROJECT_ID , 5 ) ;
1426:
1427: oe_debug_pub.add( 'TASK_ID :' || L_LINE_REC.TASK_ID , 5 ) ;
1428: END IF;
1429:
1430: INSERT INTO MTL_TRANSACTIONS_INTERFACE
1431: (

Line 1603: oe_debug_pub.add( 'INV IFACE: FINISH INSERTING - 2 , CALLING UPDATE_FLOW_STATUS_CODE' , 1 ) ;

1599: FROM gl_code_combinations
1600: WHERE code_combination_id = l_trans_acc;
1601:
1602: IF l_debug_level > 0 THEN
1603: oe_debug_pub.add( 'INV IFACE: FINISH INSERTING - 2 , CALLING UPDATE_FLOW_STATUS_CODE' , 1 ) ;
1604: END IF;
1605:
1606: /* -- HW OPM BUG#:2536589 -- INVCONV
1607: END IF; -- of branching */

Line 1618: oe_debug_pub.add( 'INV IFACE: UPDATE FLOW STATUS CODE FAILED' , 5 ) ;

1614: , p_flow_status_code => 'INVENTORY_INTERFACED'
1615: , x_return_status => l_return_status);
1616: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1617: IF l_debug_level > 0 THEN
1618: oe_debug_pub.add( 'INV IFACE: UPDATE FLOW STATUS CODE FAILED' , 5 ) ;
1619: END IF;
1620: END IF;
1621:
1622: END IF; -- If line is shippable

Line 1631: oe_debug_pub.add( 'INV IFACE: IT IS A PTO LINE WITHOUT EXPLOSION DATE' , 3 ) ;

1627: IF (l_line_rec.explosion_date IS NULL AND
1628: l_line_rec.top_model_line_id IS NOT NULL AND
1629: l_line_rec.ato_line_id IS NULL) THEN
1630: IF l_debug_level > 0 THEN
1631: oe_debug_pub.add( 'INV IFACE: IT IS A PTO LINE WITHOUT EXPLOSION DATE' , 3 ) ;
1632: END IF;
1633: IF l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_MODEL OR
1634: l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CLASS OR
1635: l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_KIT THEN

Line 1637: oe_debug_pub.add( 'INV IFACE: IT IS ITEM TYPE : '|| L_LINE_REC.ITEM_TYPE_CODE , 3 ) ;

1633: IF l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_MODEL OR
1634: l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CLASS OR
1635: l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_KIT THEN
1636: IF l_debug_level > 0 THEN
1637: oe_debug_pub.add( 'INV IFACE: IT IS ITEM TYPE : '|| L_LINE_REC.ITEM_TYPE_CODE , 3 ) ;
1638: END IF;
1639: -- Do the explosion
1640: l_return_status := OE_Config_Util.Process_Included_Items(
1641: p_line_id => l_line_rec.line_id

Line 1645: oe_debug_pub.add( 'INV IFACE: AFTER CALLING EXPLOSION : '|| L_RETURN_STATUS , 3 ) ;

1641: p_line_id => l_line_rec.line_id
1642: ,p_freeze => TRUE
1643: ,p_process_requests => TRUE);
1644: IF l_debug_level > 0 THEN
1645: oe_debug_pub.add( 'INV IFACE: AFTER CALLING EXPLOSION : '|| L_RETURN_STATUS , 3 ) ;
1646: END IF;
1647: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1648: IF l_debug_level > 0 THEN
1649: oe_debug_pub.add( 'INV IFACE: FREEZE INCLUDED ITEM FAILED - UNEXP' , 1 ) ;

Line 1649: oe_debug_pub.add( 'INV IFACE: FREEZE INCLUDED ITEM FAILED - UNEXP' , 1 ) ;

1645: oe_debug_pub.add( 'INV IFACE: AFTER CALLING EXPLOSION : '|| L_RETURN_STATUS , 3 ) ;
1646: END IF;
1647: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1648: IF l_debug_level > 0 THEN
1649: oe_debug_pub.add( 'INV IFACE: FREEZE INCLUDED ITEM FAILED - UNEXP' , 1 ) ;
1650: END IF;
1651: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1652: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1653: IF l_debug_level > 0 THEN

Line 1654: oe_debug_pub.add( 'INV IFACE: FREEZE INCLUDED ITEM FAILED - EXP' , 1 ) ;

1650: END IF;
1651: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1652: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1653: IF l_debug_level > 0 THEN
1654: oe_debug_pub.add( 'INV IFACE: FREEZE INCLUDED ITEM FAILED - EXP' , 1 ) ;
1655: END IF;
1656: RAISE FND_API.G_EXC_ERROR;
1657: END IF;
1658: END IF;

Line 1664: oe_debug_pub.add( 'INV IFACE: EXITING INVENTORY_INTERFACE' , 1 ) ;

1660:
1661: /* bug 4659103: update of visible_demand_flag code removed */
1662:
1663: IF l_debug_level > 0 THEN
1664: oe_debug_pub.add( 'INV IFACE: EXITING INVENTORY_INTERFACE' , 1 ) ;
1665: END IF;
1666:
1667: EXCEPTION
1668: WHEN OTHERS THEN

Line 1678: oe_debug_pub.add( 'INV IFACE ERROR MESSAGE : '||SUBSTR ( SQLERRM , 1 , 100 ) , 1 ) ;

1674: );
1675: END IF;
1676:
1677: IF l_debug_level > 0 THEN
1678: oe_debug_pub.add( 'INV IFACE ERROR MESSAGE : '||SUBSTR ( SQLERRM , 1 , 100 ) , 1 ) ;
1679: END IF;
1680: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1681: END Inventory_Interface;
1682: