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: BEGIN
110:
111: SAVEPOINT INVENTORY_INTERFACE;

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

110:
111: SAVEPOINT INVENTORY_INTERFACE;
112:
113: IF l_debug_level > 0 THEN
114: oe_debug_pub.add( 'INV IFACE: ENTERING INVENTORY INTERFACE' , 1 ) ;
115: END IF;
116: x_return_status := FND_API.G_RET_STS_SUCCESS;
117: x_result_out := OE_GLOBALS.G_WFR_COMPLETE;
118:

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

147: OE_MSG_PUB.ADD;
148: x_return_status := FND_API.G_RET_STS_ERROR;
149: x_result_out := OE_GLOBALS.G_WFR_ON_HOLD;
150: IF l_debug_level > 0 THEN
151: oe_debug_pub.add( 'INV IFACE: ACTIVITY ON HOLD , EXITING' , 5 ) ;
152: END IF;
153: RETURN;
154: ELSIF l_hold_return_status <> FND_API.G_RET_STS_SUCCESS THEN
155: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

153: RETURN;
154: ELSIF l_hold_return_status <> FND_API.G_RET_STS_SUCCESS THEN
155: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
156: IF l_debug_level > 0 THEN
157: oe_debug_pub.add( 'INV IFACE: CHECK HOLD API ERROR' , 5 ) ;
158: END IF;
159: RETURN;
160: END IF;
161:

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

166: , x_return_status => l_return_status
167: );
168: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
169: IF l_debug_level > 0 THEN
170: oe_debug_pub.add( 'INV IFACE: LOCK_ROW FAILED' , 5 ) ;
171: END IF;
172: x_return_status := FND_API.G_RET_STS_ERROR;
173: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
174: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

172: x_return_status := FND_API.G_RET_STS_ERROR;
173: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
174: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
175: IF l_debug_level > 0 THEN
176: oe_debug_pub.add( 'INV IFACE: LOCK_ROW FAILED' , 5 ) ;
177: END IF;
178: x_return_status := FND_API.G_RET_STS_ERROR;
179: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
180: END IF;

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

190: ,p_order_source_id => l_line_rec.order_source_id
191: ,p_source_document_type_id => l_line_rec.source_document_type_id);
192:
193: IF l_debug_level > 0 THEN
194: oe_debug_pub.add( 'INV IFACE: LOCK_ROW COMPLETED' , 5 ) ;
195: END IF;
196:
197:
198: SELECT MTL_TRANSACTIONS_ENABLED_FLAG

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

207: l_transactable_flag <> 'Y' THEN
208: x_return_status := FND_API.G_RET_STS_SUCCESS;
209: x_result_out := OE_GLOBALS.G_WFR_NOT_ELIGIBLE;
210: IF l_debug_level > 0 THEN
211: oe_debug_pub.add( 'INV IFACE: INV IFACE NOT ELIGIBLE - EXTERNAL OR NON TRANSACTABLE' , 5 ) ;
212: END IF;
213: RETURN;
214: END IF;
215:

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

214: END IF;
215:
216: IF l_line_rec.ship_from_org_id is null THEN
217: IF l_debug_level > 0 THEN
218: oe_debug_pub.add( 'INV IFACE: INV IFACE INCOMPLETE - NO WAREHOUSE' , 5 ) ;
219: END IF;
220: FND_MESSAGE.SET_NAME('ONT', 'OE_INV_NO_WAREHOUSE');
221: OE_MSG_PUB.ADD;
222: x_return_status := FND_API.G_RET_STS_ERROR;

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

258: INTO l_trx_date_for_inv_iface
259: FROM DUAL;
260:
261: IF l_debug_level > 0 THEN
262: OE_DEBUG_PUB.add('Transaction Date derived from system parameter setup is '||l_trx_date_for_inv_iface,1);
263: END IF;
264: --bug5897965, end
265:
266: IF OE_FLEX_COGS_PUB.Start_Process (

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

277: -- we will return INCOMPLETE
278:
279: l_trans_acc := NULL;
280: IF l_debug_level > 0 THEN
281: oe_debug_pub.add( 'INV IFACE: COGS FAIL' , 5 ) ;
282: END IF;
283: x_return_status := FND_API.G_RET_STS_ERROR;
284: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
285: RETURN;

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

297: AND organization_id = l_line_rec.ship_from_org_id;
298: EXCEPTION
299: WHEN OTHERS THEN
300: IF l_debug_level > 0 THEN
301: oe_debug_pub.add( 'INV IFACE: REVISION/LOT SELECT FAILURE' , 5 ) ;
302: END IF;
303: x_return_status := FND_API.G_RET_STS_ERROR;
304: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
305: RETURN;

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

307:
308: -- we dont support serial numbers
309: IF nvl(l_serial_code, 1) <> 1 THEN
310: IF l_debug_level > 0 THEN
311: oe_debug_pub.add( 'INV IFACE: ITEM UNDER SERIAL CONTORL , ERROR' , 5 ) ;
312: END IF;
313: -- give a message here
314: FND_MESSAGE.SET_NAME('ONT', 'OE_INV_IFACE_SERIAL');
315: OE_MSG_PUB.ADD;

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

319: END IF;
320:
321: IF l_revision_code = 2 THEN
322: IF l_debug_level > 0 THEN
323: oe_debug_pub.add( 'INV IFACE: ITEM UNDER REVISION CONTROL' , 5 ) ;
324: END IF;
325: l_revision := 'Y';
326: END IF;
327:

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

326: END IF;
327:
328: IF l_lot_code = 2 THEN
329: IF l_debug_level > 0 THEN
330: oe_debug_pub.add( 'INV IFACE: ITEM UNDER LOT CONTROL' , 5 ) ;
331: END IF;
332: l_lot := 'Y';
333: END IF;
334:

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

334:
335: -- HW OPM BUG#:2536589
336: IF l_lot_code = 1 THEN
337: IF l_debug_level > 0 THEN
338: oe_debug_pub.add( 'INV IFACE: ITEM UNDER NON LOT CONTROL' , 5 ) ;
339: END IF;
340: l_lot := 'N';
341: END IF;
342:

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

373: (p_header_id => l_sales_order_id,
374: p_line_id => l_line_rec.line_id,
375: p_org_id => l_line_rec.ship_from_org_id); */
376: IF l_debug_level > 0 THEN
377: oe_debug_pub.add( 'INV IFACE: RESERVED_QTY = ' || TO_CHAR ( L_LINE_REC.RESERVED_QUANTITY ) , 5 ) ;
378: END IF;
379:
380:
381: -- INVCONV

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

384: (p_header_id => l_sales_order_id,
385: p_line_id => l_line_rec.line_id,
386: p_org_id => l_line_rec.ship_from_org_id); */
387: IF l_debug_level > 0 THEN
388: oe_debug_pub.add( 'INV IFACE: RESERVED_QTY2 = ' || TO_CHAR ( L_LINE_REC.RESERVED_QUANTITY2 ) , 5 ) ;
389: END IF;
390:
391:
392:

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

404: l_process_org := 0;
405: END IF;
406:
407: IF l_debug_level > 0 THEN
408: oe_debug_pub.add( 'VALUE OF L_PROCESS_FLAG IS '||TO_CHAR ( L_PROCESS_ORG ) , 5 ) ;
409: END IF; */
410:
411:
412: /* -- HW OPM BUG#:2536589 Check if requested_qty < qty_reserved for OPM INVCONV NOT NEEDED NOW

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

413:
414: IF (l_process_org = 1 AND
415: l_line_rec.reserved_quantity > l_line_rec.ordered_quantity ) THEN
416: IF l_debug_level > 0 THEN
417: oe_debug_pub.add( 'INV IFACE FAILED: ORDERED_QTY IS < RESERVED_QTY FOR OPM' , 5 ) ;
418: END IF;
419: x_return_status := FND_API.G_RET_STS_ERROR;
420: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
421: ROLLBACK TO INVENTORY_INTERFACE;

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

437: l_rsv_rec.demand_source_line_id := l_line_rec.line_id;
438: l_rsv_rec.organization_id := l_line_rec.ship_from_org_id;
439:
440: IF l_debug_level > 0 THEN
441: oe_debug_pub.add( 'INV IFACE: CALLING INVS QUERY_RESERVATION ' , 1 ) ;
442: END IF;
443:
444: inv_reservation_pub.query_reservation
445: ( p_api_version_number => 1.0

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

454: , p_lock_records => l_lock_records
455: , p_sort_by_req_date => l_sort_by_req_date
456: );
457: IF l_debug_level > 0 THEN
458: oe_debug_pub.add( 'INV IFACE: AFTER CALLING INVS QUERY_RESERVATION: ' || L_RETURN_STATUS || ' COUNT: ' || L_RSV_TBL.COUNT , 1 ) ;
459: END IF;
460:
461: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR OR
462: l_return_status = FND_API.G_RET_STS_ERROR THEN

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

460:
461: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR OR
462: l_return_status = FND_API.G_RET_STS_ERROR THEN
463: IF l_debug_level > 0 THEN
464: oe_debug_pub.add( 'INV IFACE: QUERY_RESERVATION FAILED' , 5 ) ;
465: END IF;
466: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
467: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
468: RETURN;

Line 517: 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 ) ;

513:
514: -- This error is reported if lot_id is not found
515: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
516: IF l_debug_level > 0 THEN
517: 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 ) ;
518: END IF;
519: x_return_status := FND_API.G_RET_STS_ERROR;
520: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
521: ROLLBACK TO INVENTORY_INTERFACE;

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

540: ,opm_msg_data);
541:
542: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
543: IF l_debug_level > 0 THEN
544: oe_debug_pub.add( 'INV IFACE: FAILED TO UPDATE OPM TRXNS' , 5 ) ;
545: END IF;
546: x_return_status := FND_API.G_RET_STS_ERROR;
547: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
548: ROLLBACK TO INVENTORY_INTERFACE;

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

574:
575: EXCEPTION
576: WHEN OTHERS THEN
577: IF l_debug_level > 0 THEN
578: oe_debug_pub.add( 'INV IFACE: LOCATOR CONTROL CODE FAILURE' , 5 ) ;
579: END IF;
580: x_return_status := FND_API.G_RET_STS_ERROR;
581: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
582: ROLLBACK TO INVENTORY_INTERFACE;

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

592:
593: EXCEPTION
594: WHEN OTHERS THEN
595: IF l_debug_level > 0 THEN
596: oe_debug_pub.add( 'INV IFACE: LOCATOR TYPE FAILURE' , 5 ) ;
597: END IF;
598: x_return_status := FND_API.G_RET_STS_ERROR;
599: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
600: ROLLBACK TO INVENTORY_INTERFACE;

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

609: AND organization_id = l_line_rec.ship_from_org_id;
610: EXCEPTION
611: WHEN OTHERS THEN
612: IF l_debug_level > 0 THEN
613: oe_debug_pub.add( 'INV IFACE: LOCATION CONTROL CODE FAILURE' , 5 ) ;
614: END IF;
615: x_return_status := FND_API.G_RET_STS_ERROR;
616: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
617: ROLLBACK TO INVENTORY_INTERFACE;

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

618: RETURN;
619: END;
620:
621: IF l_debug_level > 0 THEN
622: oe_debug_pub.add( 'INV IFACE: BEFORE LOCATOR_CONTROL API CALL' , 1 ) ;
623: END IF;
624: l_locator := INV_RESERVATION_UTIL_PVT.locator_control(
625: p_org_control => l_stock_locator_control_code
626: ,p_sub_control => l_locator_type

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

625: p_org_control => l_stock_locator_control_code
626: ,p_sub_control => l_locator_type
627: ,p_item_control => l_location_control_code);
628: IF l_debug_level > 0 THEN
629: oe_debug_pub.add( 'INV IFACE: AFTER LOCATOR_CONTROL API CALL - ' || TO_CHAR ( L_LOCATOR ) , 1 ) ;
630: END IF;
631:
632:
633: IF l_locator > 1 THEN -- under locator control

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

633: IF l_locator > 1 THEN -- under locator control
634: IF l_rsv_tbl(I).locator_id is null THEN
635: -- give a message
636: IF l_debug_level > 0 THEN
637: oe_debug_pub.add( 'INV IFACE: ITEM UNDER LOCATOR CONTROL' , 5 ) ;
638: END IF;
639: FND_MESSAGE.SET_NAME('ONT', 'OE_INV_IFACE_LOCATOR');
640: OE_MSG_PUB.ADD;
641: x_return_status := FND_API.G_RET_STS_ERROR;

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

691: END IF; -- under lot control
692:
693:
694: IF l_debug_level > 0 THEN
695: oe_debug_pub.add( 'INV IFACE: INSERTING RECORD - 1' , 1 ) ;
696:
697: oe_debug_pub.add( 'SOURCE_CODE :' || FND_PROFILE.VALUE ( 'ONT_SOURCE_CODE' ) , 5 ) ;
698:
699: oe_debug_pub.add( 'SOURCE_LINE_ID :' || L_SOURCE_LINE_ID , 5 ) ;

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

693:
694: IF l_debug_level > 0 THEN
695: oe_debug_pub.add( 'INV IFACE: INSERTING RECORD - 1' , 1 ) ;
696:
697: oe_debug_pub.add( 'SOURCE_CODE :' || FND_PROFILE.VALUE ( 'ONT_SOURCE_CODE' ) , 5 ) ;
698:
699: oe_debug_pub.add( 'SOURCE_LINE_ID :' || L_SOURCE_LINE_ID , 5 ) ;
700:
701: oe_debug_pub.add( 'SOURCE_HEADER_ID :' || L_TRANSACTION_REFERENCE , 5 ) ;

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

695: oe_debug_pub.add( 'INV IFACE: INSERTING RECORD - 1' , 1 ) ;
696:
697: oe_debug_pub.add( 'SOURCE_CODE :' || FND_PROFILE.VALUE ( 'ONT_SOURCE_CODE' ) , 5 ) ;
698:
699: oe_debug_pub.add( 'SOURCE_LINE_ID :' || L_SOURCE_LINE_ID , 5 ) ;
700:
701: oe_debug_pub.add( 'SOURCE_HEADER_ID :' || L_TRANSACTION_REFERENCE , 5 ) ;
702:
703: oe_debug_pub.add( 'PROCESS_FLAG :' || 1 , 5 ) ;

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

697: oe_debug_pub.add( 'SOURCE_CODE :' || FND_PROFILE.VALUE ( 'ONT_SOURCE_CODE' ) , 5 ) ;
698:
699: oe_debug_pub.add( 'SOURCE_LINE_ID :' || L_SOURCE_LINE_ID , 5 ) ;
700:
701: oe_debug_pub.add( 'SOURCE_HEADER_ID :' || L_TRANSACTION_REFERENCE , 5 ) ;
702:
703: oe_debug_pub.add( 'PROCESS_FLAG :' || 1 , 5 ) ;
704:
705: oe_debug_pub.add( 'TRANSACTION_MODE :' || 1 , 5 ) ;

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

699: oe_debug_pub.add( 'SOURCE_LINE_ID :' || L_SOURCE_LINE_ID , 5 ) ;
700:
701: oe_debug_pub.add( 'SOURCE_HEADER_ID :' || L_TRANSACTION_REFERENCE , 5 ) ;
702:
703: oe_debug_pub.add( 'PROCESS_FLAG :' || 1 , 5 ) ;
704:
705: oe_debug_pub.add( 'TRANSACTION_MODE :' || 1 , 5 ) ;
706:
707: oe_debug_pub.add( 'LOCK_FLAG :' || 2 , 5 ) ;

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

701: oe_debug_pub.add( 'SOURCE_HEADER_ID :' || L_TRANSACTION_REFERENCE , 5 ) ;
702:
703: oe_debug_pub.add( 'PROCESS_FLAG :' || 1 , 5 ) ;
704:
705: oe_debug_pub.add( 'TRANSACTION_MODE :' || 1 , 5 ) ;
706:
707: oe_debug_pub.add( 'LOCK_FLAG :' || 2 , 5 ) ;
708:
709: oe_debug_pub.add( 'TRANSACTION_HEADER_ID :' || L_TRANSACTION_HEADER_ID , 5 ) ;

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

703: oe_debug_pub.add( 'PROCESS_FLAG :' || 1 , 5 ) ;
704:
705: oe_debug_pub.add( 'TRANSACTION_MODE :' || 1 , 5 ) ;
706:
707: oe_debug_pub.add( 'LOCK_FLAG :' || 2 , 5 ) ;
708:
709: oe_debug_pub.add( 'TRANSACTION_HEADER_ID :' || L_TRANSACTION_HEADER_ID , 5 ) ;
710:
711: oe_debug_pub.add( 'INVENTORY_ITEM_ID :' || L_LINE_REC.INVENTORY_ITEM_ID , 5 ) ;

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

705: oe_debug_pub.add( 'TRANSACTION_MODE :' || 1 , 5 ) ;
706:
707: oe_debug_pub.add( 'LOCK_FLAG :' || 2 , 5 ) ;
708:
709: oe_debug_pub.add( 'TRANSACTION_HEADER_ID :' || L_TRANSACTION_HEADER_ID , 5 ) ;
710:
711: oe_debug_pub.add( 'INVENTORY_ITEM_ID :' || L_LINE_REC.INVENTORY_ITEM_ID , 5 ) ;
712:
713: oe_debug_pub.add( 'SUBINVENTORY_CODE :' || L_RSV_TBL ( I ) .SUBINVENTORY_CODE , 5 ) ;

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

707: oe_debug_pub.add( 'LOCK_FLAG :' || 2 , 5 ) ;
708:
709: oe_debug_pub.add( 'TRANSACTION_HEADER_ID :' || L_TRANSACTION_HEADER_ID , 5 ) ;
710:
711: oe_debug_pub.add( 'INVENTORY_ITEM_ID :' || L_LINE_REC.INVENTORY_ITEM_ID , 5 ) ;
712:
713: oe_debug_pub.add( 'SUBINVENTORY_CODE :' || L_RSV_TBL ( I ) .SUBINVENTORY_CODE , 5 ) ;
714:
715: oe_debug_pub.add( 'TRANSACTION_QUANTITY :' || ( -1 * L_RSV_TBL ( I ) .RESERVATION_QUANTITY ) , 5 ) ;

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

709: oe_debug_pub.add( 'TRANSACTION_HEADER_ID :' || L_TRANSACTION_HEADER_ID , 5 ) ;
710:
711: oe_debug_pub.add( 'INVENTORY_ITEM_ID :' || L_LINE_REC.INVENTORY_ITEM_ID , 5 ) ;
712:
713: oe_debug_pub.add( 'SUBINVENTORY_CODE :' || L_RSV_TBL ( I ) .SUBINVENTORY_CODE , 5 ) ;
714:
715: oe_debug_pub.add( 'TRANSACTION_QUANTITY :' || ( -1 * L_RSV_TBL ( I ) .RESERVATION_QUANTITY ) , 5 ) ;
716:
717: oe_debug_pub.add( 'SECONDARY TRANSACTION_QUANTITY :' || ( -1 * L_RSV_TBL ( I ) .SECONDARY_RESERVATION_QUANTITY ) , 5 ) ; -- INVCONV

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

711: oe_debug_pub.add( 'INVENTORY_ITEM_ID :' || L_LINE_REC.INVENTORY_ITEM_ID , 5 ) ;
712:
713: oe_debug_pub.add( 'SUBINVENTORY_CODE :' || L_RSV_TBL ( I ) .SUBINVENTORY_CODE , 5 ) ;
714:
715: oe_debug_pub.add( 'TRANSACTION_QUANTITY :' || ( -1 * L_RSV_TBL ( I ) .RESERVATION_QUANTITY ) , 5 ) ;
716:
717: oe_debug_pub.add( 'SECONDARY TRANSACTION_QUANTITY :' || ( -1 * L_RSV_TBL ( I ) .SECONDARY_RESERVATION_QUANTITY ) , 5 ) ; -- INVCONV
718:
719:

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

713: oe_debug_pub.add( 'SUBINVENTORY_CODE :' || L_RSV_TBL ( I ) .SUBINVENTORY_CODE , 5 ) ;
714:
715: oe_debug_pub.add( 'TRANSACTION_QUANTITY :' || ( -1 * L_RSV_TBL ( I ) .RESERVATION_QUANTITY ) , 5 ) ;
716:
717: oe_debug_pub.add( 'SECONDARY TRANSACTION_QUANTITY :' || ( -1 * L_RSV_TBL ( I ) .SECONDARY_RESERVATION_QUANTITY ) , 5 ) ; -- INVCONV
718:
719:
720: oe_debug_pub.add( 'TRANSACTION_DATE :' || l_trx_date_for_inv_iface, 5 ) ; --bug5897965
721:

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

716:
717: oe_debug_pub.add( 'SECONDARY TRANSACTION_QUANTITY :' || ( -1 * L_RSV_TBL ( I ) .SECONDARY_RESERVATION_QUANTITY ) , 5 ) ; -- INVCONV
718:
719:
720: oe_debug_pub.add( 'TRANSACTION_DATE :' || l_trx_date_for_inv_iface, 5 ) ; --bug5897965
721:
722: -- bug 5897965 oe_debug_pub.add( 'TRANSACTION_DATE :' || l_ordered_date , 5 ) ;
723:
724: oe_debug_pub.add( 'ORGANIZATION_ID :' || L_RSV_TBL ( I ) .ORGANIZATION_ID , 5 ) ;

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

718:
719:
720: oe_debug_pub.add( 'TRANSACTION_DATE :' || l_trx_date_for_inv_iface, 5 ) ; --bug5897965
721:
722: -- bug 5897965 oe_debug_pub.add( 'TRANSACTION_DATE :' || l_ordered_date , 5 ) ;
723:
724: oe_debug_pub.add( 'ORGANIZATION_ID :' || L_RSV_TBL ( I ) .ORGANIZATION_ID , 5 ) ;
725:
726: oe_debug_pub.add( 'ACCT_PERIOD_ID :' || NULL , 5 ) ;

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

720: oe_debug_pub.add( 'TRANSACTION_DATE :' || l_trx_date_for_inv_iface, 5 ) ; --bug5897965
721:
722: -- bug 5897965 oe_debug_pub.add( 'TRANSACTION_DATE :' || l_ordered_date , 5 ) ;
723:
724: oe_debug_pub.add( 'ORGANIZATION_ID :' || L_RSV_TBL ( I ) .ORGANIZATION_ID , 5 ) ;
725:
726: oe_debug_pub.add( 'ACCT_PERIOD_ID :' || NULL , 5 ) ;
727:
728: oe_debug_pub.add( 'LAST_UPDATE_DATE :' || SYSDATE , 5 ) ;

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

722: -- bug 5897965 oe_debug_pub.add( 'TRANSACTION_DATE :' || l_ordered_date , 5 ) ;
723:
724: oe_debug_pub.add( 'ORGANIZATION_ID :' || L_RSV_TBL ( I ) .ORGANIZATION_ID , 5 ) ;
725:
726: oe_debug_pub.add( 'ACCT_PERIOD_ID :' || NULL , 5 ) ;
727:
728: oe_debug_pub.add( 'LAST_UPDATE_DATE :' || SYSDATE , 5 ) ;
729:
730: oe_debug_pub.add( 'LAST_UPDATED_BY :' || FND_GLOBAL.USER_ID , 5 ) ;

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

724: oe_debug_pub.add( 'ORGANIZATION_ID :' || L_RSV_TBL ( I ) .ORGANIZATION_ID , 5 ) ;
725:
726: oe_debug_pub.add( 'ACCT_PERIOD_ID :' || NULL , 5 ) ;
727:
728: oe_debug_pub.add( 'LAST_UPDATE_DATE :' || SYSDATE , 5 ) ;
729:
730: oe_debug_pub.add( 'LAST_UPDATED_BY :' || FND_GLOBAL.USER_ID , 5 ) ;
731:
732: oe_debug_pub.add( 'CREATION_DATE :' || SYSDATE , 5 ) ;

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

726: oe_debug_pub.add( 'ACCT_PERIOD_ID :' || NULL , 5 ) ;
727:
728: oe_debug_pub.add( 'LAST_UPDATE_DATE :' || SYSDATE , 5 ) ;
729:
730: oe_debug_pub.add( 'LAST_UPDATED_BY :' || FND_GLOBAL.USER_ID , 5 ) ;
731:
732: oe_debug_pub.add( 'CREATION_DATE :' || SYSDATE , 5 ) ;
733:
734: oe_debug_pub.add( 'CREATED_BY :' || FND_GLOBAL.USER_ID , 5 ) ;

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

728: oe_debug_pub.add( 'LAST_UPDATE_DATE :' || SYSDATE , 5 ) ;
729:
730: oe_debug_pub.add( 'LAST_UPDATED_BY :' || FND_GLOBAL.USER_ID , 5 ) ;
731:
732: oe_debug_pub.add( 'CREATION_DATE :' || SYSDATE , 5 ) ;
733:
734: oe_debug_pub.add( 'CREATED_BY :' || FND_GLOBAL.USER_ID , 5 ) ;
735:
736: oe_debug_pub.add( 'TRANSACTION_SOURCE_ID :' || L_SALES_ORDER_ID , 5 ) ;

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

730: oe_debug_pub.add( 'LAST_UPDATED_BY :' || FND_GLOBAL.USER_ID , 5 ) ;
731:
732: oe_debug_pub.add( 'CREATION_DATE :' || SYSDATE , 5 ) ;
733:
734: oe_debug_pub.add( 'CREATED_BY :' || FND_GLOBAL.USER_ID , 5 ) ;
735:
736: oe_debug_pub.add( 'TRANSACTION_SOURCE_ID :' || L_SALES_ORDER_ID , 5 ) ;
737:
738: oe_debug_pub.add( 'DSP_SEGMENT1 :' || L_ORDER_NUMBER , 5 ) ;

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

732: oe_debug_pub.add( 'CREATION_DATE :' || SYSDATE , 5 ) ;
733:
734: oe_debug_pub.add( 'CREATED_BY :' || FND_GLOBAL.USER_ID , 5 ) ;
735:
736: oe_debug_pub.add( 'TRANSACTION_SOURCE_ID :' || L_SALES_ORDER_ID , 5 ) ;
737:
738: oe_debug_pub.add( 'DSP_SEGMENT1 :' || L_ORDER_NUMBER , 5 ) ;
739:
740: oe_debug_pub.add( 'DSP_SEGMENT2 :' || L_ORDER_TYPE_NAME , 5 ) ;

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

734: oe_debug_pub.add( 'CREATED_BY :' || FND_GLOBAL.USER_ID , 5 ) ;
735:
736: oe_debug_pub.add( 'TRANSACTION_SOURCE_ID :' || L_SALES_ORDER_ID , 5 ) ;
737:
738: oe_debug_pub.add( 'DSP_SEGMENT1 :' || L_ORDER_NUMBER , 5 ) ;
739:
740: oe_debug_pub.add( 'DSP_SEGMENT2 :' || L_ORDER_TYPE_NAME , 5 ) ;
741:
742: oe_debug_pub.add( 'DSP_SEGMENT3 :' || FND_PROFILE.VALUE ( 'ONT_SOURCE_CODE' ) , 5 ) ;

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

736: oe_debug_pub.add( 'TRANSACTION_SOURCE_ID :' || L_SALES_ORDER_ID , 5 ) ;
737:
738: oe_debug_pub.add( 'DSP_SEGMENT1 :' || L_ORDER_NUMBER , 5 ) ;
739:
740: oe_debug_pub.add( 'DSP_SEGMENT2 :' || L_ORDER_TYPE_NAME , 5 ) ;
741:
742: oe_debug_pub.add( 'DSP_SEGMENT3 :' || FND_PROFILE.VALUE ( 'ONT_SOURCE_CODE' ) , 5 ) ;
743:
744: oe_debug_pub.add( 'TRANSACTION_SOURCE_TYPE_ID :' || TO_CHAR ( 2 ) , 5 ) ;

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

738: oe_debug_pub.add( 'DSP_SEGMENT1 :' || L_ORDER_NUMBER , 5 ) ;
739:
740: oe_debug_pub.add( 'DSP_SEGMENT2 :' || L_ORDER_TYPE_NAME , 5 ) ;
741:
742: oe_debug_pub.add( 'DSP_SEGMENT3 :' || FND_PROFILE.VALUE ( 'ONT_SOURCE_CODE' ) , 5 ) ;
743:
744: oe_debug_pub.add( 'TRANSACTION_SOURCE_TYPE_ID :' || TO_CHAR ( 2 ) , 5 ) ;
745:
746: oe_debug_pub.add( 'TRANSACTION_ACTION_ID :' || TO_CHAR ( 1 ) , 5 ) ;

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

740: oe_debug_pub.add( 'DSP_SEGMENT2 :' || L_ORDER_TYPE_NAME , 5 ) ;
741:
742: oe_debug_pub.add( 'DSP_SEGMENT3 :' || FND_PROFILE.VALUE ( 'ONT_SOURCE_CODE' ) , 5 ) ;
743:
744: oe_debug_pub.add( 'TRANSACTION_SOURCE_TYPE_ID :' || TO_CHAR ( 2 ) , 5 ) ;
745:
746: oe_debug_pub.add( 'TRANSACTION_ACTION_ID :' || TO_CHAR ( 1 ) , 5 ) ;
747:
748: oe_debug_pub.add( 'TRANSACTION_TYPE_ID :' || TO_CHAR ( 33 ) , 5 ) ;

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

742: oe_debug_pub.add( 'DSP_SEGMENT3 :' || FND_PROFILE.VALUE ( 'ONT_SOURCE_CODE' ) , 5 ) ;
743:
744: oe_debug_pub.add( 'TRANSACTION_SOURCE_TYPE_ID :' || TO_CHAR ( 2 ) , 5 ) ;
745:
746: oe_debug_pub.add( 'TRANSACTION_ACTION_ID :' || TO_CHAR ( 1 ) , 5 ) ;
747:
748: oe_debug_pub.add( 'TRANSACTION_TYPE_ID :' || TO_CHAR ( 33 ) , 5 ) ;
749:
750: oe_debug_pub.add( 'DISTRIBUTION_ACCOUNT_ID :' || L_TRANS_ACC , 5 ) ;

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

744: oe_debug_pub.add( 'TRANSACTION_SOURCE_TYPE_ID :' || TO_CHAR ( 2 ) , 5 ) ;
745:
746: oe_debug_pub.add( 'TRANSACTION_ACTION_ID :' || TO_CHAR ( 1 ) , 5 ) ;
747:
748: oe_debug_pub.add( 'TRANSACTION_TYPE_ID :' || TO_CHAR ( 33 ) , 5 ) ;
749:
750: oe_debug_pub.add( 'DISTRIBUTION_ACCOUNT_ID :' || L_TRANS_ACC , 5 ) ;
751:
752: oe_debug_pub.add( 'TRANSACTION_REFERENCE :' || L_TRANSACTION_REFERENCE , 5 ) ;

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

746: oe_debug_pub.add( 'TRANSACTION_ACTION_ID :' || TO_CHAR ( 1 ) , 5 ) ;
747:
748: oe_debug_pub.add( 'TRANSACTION_TYPE_ID :' || TO_CHAR ( 33 ) , 5 ) ;
749:
750: oe_debug_pub.add( 'DISTRIBUTION_ACCOUNT_ID :' || L_TRANS_ACC , 5 ) ;
751:
752: oe_debug_pub.add( 'TRANSACTION_REFERENCE :' || L_TRANSACTION_REFERENCE , 5 ) ;
753:
754: oe_debug_pub.add( 'TRX_SOURCE_LINE_ID :' || L_LINE_REC.LINE_ID , 5 ) ;

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

748: oe_debug_pub.add( 'TRANSACTION_TYPE_ID :' || TO_CHAR ( 33 ) , 5 ) ;
749:
750: oe_debug_pub.add( 'DISTRIBUTION_ACCOUNT_ID :' || L_TRANS_ACC , 5 ) ;
751:
752: oe_debug_pub.add( 'TRANSACTION_REFERENCE :' || L_TRANSACTION_REFERENCE , 5 ) ;
753:
754: oe_debug_pub.add( 'TRX_SOURCE_LINE_ID :' || L_LINE_REC.LINE_ID , 5 ) ;
755:
756: oe_debug_pub.add( 'TRX_SOURCE_DELIVERY_ID :' || NULL , 5 ) ;

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

750: oe_debug_pub.add( 'DISTRIBUTION_ACCOUNT_ID :' || L_TRANS_ACC , 5 ) ;
751:
752: oe_debug_pub.add( 'TRANSACTION_REFERENCE :' || L_TRANSACTION_REFERENCE , 5 ) ;
753:
754: oe_debug_pub.add( 'TRX_SOURCE_LINE_ID :' || L_LINE_REC.LINE_ID , 5 ) ;
755:
756: oe_debug_pub.add( 'TRX_SOURCE_DELIVERY_ID :' || NULL , 5 ) ;
757:
758: oe_debug_pub.add( 'REVISION :' || L_RSV_TBL ( I ) .REVISION , 5 ) ;

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

752: oe_debug_pub.add( 'TRANSACTION_REFERENCE :' || L_TRANSACTION_REFERENCE , 5 ) ;
753:
754: oe_debug_pub.add( 'TRX_SOURCE_LINE_ID :' || L_LINE_REC.LINE_ID , 5 ) ;
755:
756: oe_debug_pub.add( 'TRX_SOURCE_DELIVERY_ID :' || NULL , 5 ) ;
757:
758: oe_debug_pub.add( 'REVISION :' || L_RSV_TBL ( I ) .REVISION , 5 ) ;
759:
760: oe_debug_pub.add( 'LOCATOR_ID :' || L_RSV_TBL ( I ) .LOCATOR_ID , 5 ) ;

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

754: oe_debug_pub.add( 'TRX_SOURCE_LINE_ID :' || L_LINE_REC.LINE_ID , 5 ) ;
755:
756: oe_debug_pub.add( 'TRX_SOURCE_DELIVERY_ID :' || NULL , 5 ) ;
757:
758: oe_debug_pub.add( 'REVISION :' || L_RSV_TBL ( I ) .REVISION , 5 ) ;
759:
760: oe_debug_pub.add( 'LOCATOR_ID :' || L_RSV_TBL ( I ) .LOCATOR_ID , 5 ) ;
761:
762: oe_debug_pub.add( 'LOC_SEGMENT1 :' || NULL , 5 ) ;

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

756: oe_debug_pub.add( 'TRX_SOURCE_DELIVERY_ID :' || NULL , 5 ) ;
757:
758: oe_debug_pub.add( 'REVISION :' || L_RSV_TBL ( I ) .REVISION , 5 ) ;
759:
760: oe_debug_pub.add( 'LOCATOR_ID :' || L_RSV_TBL ( I ) .LOCATOR_ID , 5 ) ;
761:
762: oe_debug_pub.add( 'LOC_SEGMENT1 :' || NULL , 5 ) ;
763:
764: oe_debug_pub.add( 'LOC_SEGMENT2 :' || NULL , 5 ) ;

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

758: oe_debug_pub.add( 'REVISION :' || L_RSV_TBL ( I ) .REVISION , 5 ) ;
759:
760: oe_debug_pub.add( 'LOCATOR_ID :' || L_RSV_TBL ( I ) .LOCATOR_ID , 5 ) ;
761:
762: oe_debug_pub.add( 'LOC_SEGMENT1 :' || NULL , 5 ) ;
763:
764: oe_debug_pub.add( 'LOC_SEGMENT2 :' || NULL , 5 ) ;
765:
766: oe_debug_pub.add( 'LOC_SEGMENT3 :' || NULL , 5 ) ;

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

760: oe_debug_pub.add( 'LOCATOR_ID :' || L_RSV_TBL ( I ) .LOCATOR_ID , 5 ) ;
761:
762: oe_debug_pub.add( 'LOC_SEGMENT1 :' || NULL , 5 ) ;
763:
764: oe_debug_pub.add( 'LOC_SEGMENT2 :' || NULL , 5 ) ;
765:
766: oe_debug_pub.add( 'LOC_SEGMENT3 :' || NULL , 5 ) ;
767:
768: oe_debug_pub.add( 'LOC_SEGMENT4 :' || NULL , 5 ) ;

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

762: oe_debug_pub.add( 'LOC_SEGMENT1 :' || NULL , 5 ) ;
763:
764: oe_debug_pub.add( 'LOC_SEGMENT2 :' || NULL , 5 ) ;
765:
766: oe_debug_pub.add( 'LOC_SEGMENT3 :' || NULL , 5 ) ;
767:
768: oe_debug_pub.add( 'LOC_SEGMENT4 :' || NULL , 5 ) ;
769:
770: oe_debug_pub.add( 'REQUIRED_FLAG :' || NULL , 5 ) ;

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

764: oe_debug_pub.add( 'LOC_SEGMENT2 :' || NULL , 5 ) ;
765:
766: oe_debug_pub.add( 'LOC_SEGMENT3 :' || NULL , 5 ) ;
767:
768: oe_debug_pub.add( 'LOC_SEGMENT4 :' || NULL , 5 ) ;
769:
770: oe_debug_pub.add( 'REQUIRED_FLAG :' || NULL , 5 ) ;
771:
772: oe_debug_pub.add( 'PICKING_LINE_ID :' || TO_CHAR ( 0 ) , 5 ) ;

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

766: oe_debug_pub.add( 'LOC_SEGMENT3 :' || NULL , 5 ) ;
767:
768: oe_debug_pub.add( 'LOC_SEGMENT4 :' || NULL , 5 ) ;
769:
770: oe_debug_pub.add( 'REQUIRED_FLAG :' || NULL , 5 ) ;
771:
772: oe_debug_pub.add( 'PICKING_LINE_ID :' || TO_CHAR ( 0 ) , 5 ) ;
773:
774: oe_debug_pub.add( 'TRANSFER_SUBINVENTORY :' || NULL , 5 ) ;

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

768: oe_debug_pub.add( 'LOC_SEGMENT4 :' || NULL , 5 ) ;
769:
770: oe_debug_pub.add( 'REQUIRED_FLAG :' || NULL , 5 ) ;
771:
772: oe_debug_pub.add( 'PICKING_LINE_ID :' || TO_CHAR ( 0 ) , 5 ) ;
773:
774: oe_debug_pub.add( 'TRANSFER_SUBINVENTORY :' || NULL , 5 ) ;
775:
776: oe_debug_pub.add( 'TRANSFER_ORGANIZATION :' || NULL , 5 ) ;

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

770: oe_debug_pub.add( 'REQUIRED_FLAG :' || NULL , 5 ) ;
771:
772: oe_debug_pub.add( 'PICKING_LINE_ID :' || TO_CHAR ( 0 ) , 5 ) ;
773:
774: oe_debug_pub.add( 'TRANSFER_SUBINVENTORY :' || NULL , 5 ) ;
775:
776: oe_debug_pub.add( 'TRANSFER_ORGANIZATION :' || NULL , 5 ) ;
777:
778: oe_debug_pub.add( 'SHIP_TO_LOCATION_ID :' || NULL , 5 ) ;

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

772: oe_debug_pub.add( 'PICKING_LINE_ID :' || TO_CHAR ( 0 ) , 5 ) ;
773:
774: oe_debug_pub.add( 'TRANSFER_SUBINVENTORY :' || NULL , 5 ) ;
775:
776: oe_debug_pub.add( 'TRANSFER_ORGANIZATION :' || NULL , 5 ) ;
777:
778: oe_debug_pub.add( 'SHIP_TO_LOCATION_ID :' || NULL , 5 ) ;
779:
780: oe_debug_pub.add( 'REQUISITION_LINE_ID :' || NULL , 5 ) ;

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

774: oe_debug_pub.add( 'TRANSFER_SUBINVENTORY :' || NULL , 5 ) ;
775:
776: oe_debug_pub.add( 'TRANSFER_ORGANIZATION :' || NULL , 5 ) ;
777:
778: oe_debug_pub.add( 'SHIP_TO_LOCATION_ID :' || NULL , 5 ) ;
779:
780: oe_debug_pub.add( 'REQUISITION_LINE_ID :' || NULL , 5 ) ;
781:
782: oe_debug_pub.add( 'TRANSACTION_UOM :' || L_LINE_REC.ORDER_QUANTITY_UOM , 5 ) ;

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

776: oe_debug_pub.add( 'TRANSFER_ORGANIZATION :' || NULL , 5 ) ;
777:
778: oe_debug_pub.add( 'SHIP_TO_LOCATION_ID :' || NULL , 5 ) ;
779:
780: oe_debug_pub.add( 'REQUISITION_LINE_ID :' || NULL , 5 ) ;
781:
782: oe_debug_pub.add( 'TRANSACTION_UOM :' || L_LINE_REC.ORDER_QUANTITY_UOM , 5 ) ;
783:
784: oe_debug_pub.add( 'TRANS INTERFACE_ID :' || L_TRANSACTION_INTERFACE_ID , 5 ) ;

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

778: oe_debug_pub.add( 'SHIP_TO_LOCATION_ID :' || NULL , 5 ) ;
779:
780: oe_debug_pub.add( 'REQUISITION_LINE_ID :' || NULL , 5 ) ;
781:
782: oe_debug_pub.add( 'TRANSACTION_UOM :' || L_LINE_REC.ORDER_QUANTITY_UOM , 5 ) ;
783:
784: oe_debug_pub.add( 'TRANS INTERFACE_ID :' || L_TRANSACTION_INTERFACE_ID , 5 ) ;
785:
786: oe_debug_pub.add( 'DEMAND_ID :' || NULL , 5 ) ;

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

780: oe_debug_pub.add( 'REQUISITION_LINE_ID :' || NULL , 5 ) ;
781:
782: oe_debug_pub.add( 'TRANSACTION_UOM :' || L_LINE_REC.ORDER_QUANTITY_UOM , 5 ) ;
783:
784: oe_debug_pub.add( 'TRANS INTERFACE_ID :' || L_TRANSACTION_INTERFACE_ID , 5 ) ;
785:
786: oe_debug_pub.add( 'DEMAND_ID :' || NULL , 5 ) ;
787:
788: oe_debug_pub.add( 'SHIPMENT_NUMBER :' || NULL , 5 ) ;

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

782: oe_debug_pub.add( 'TRANSACTION_UOM :' || L_LINE_REC.ORDER_QUANTITY_UOM , 5 ) ;
783:
784: oe_debug_pub.add( 'TRANS INTERFACE_ID :' || L_TRANSACTION_INTERFACE_ID , 5 ) ;
785:
786: oe_debug_pub.add( 'DEMAND_ID :' || NULL , 5 ) ;
787:
788: oe_debug_pub.add( 'SHIPMENT_NUMBER :' || NULL , 5 ) ;
789:
790: oe_debug_pub.add( 'CURRENCY_CODE :' || NULL , 5 ) ;

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

784: oe_debug_pub.add( 'TRANS INTERFACE_ID :' || L_TRANSACTION_INTERFACE_ID , 5 ) ;
785:
786: oe_debug_pub.add( 'DEMAND_ID :' || NULL , 5 ) ;
787:
788: oe_debug_pub.add( 'SHIPMENT_NUMBER :' || NULL , 5 ) ;
789:
790: oe_debug_pub.add( 'CURRENCY_CODE :' || NULL , 5 ) ;
791:
792: oe_debug_pub.add( 'CURRENCY_CONVERSION_TYPE :' || NULL , 5 ) ;

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

786: oe_debug_pub.add( 'DEMAND_ID :' || NULL , 5 ) ;
787:
788: oe_debug_pub.add( 'SHIPMENT_NUMBER :' || NULL , 5 ) ;
789:
790: oe_debug_pub.add( 'CURRENCY_CODE :' || NULL , 5 ) ;
791:
792: oe_debug_pub.add( 'CURRENCY_CONVERSION_TYPE :' || NULL , 5 ) ;
793:
794: oe_debug_pub.add( 'CURRENCY_CONVERSION_DATE :' || NULL , 5 ) ;

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

788: oe_debug_pub.add( 'SHIPMENT_NUMBER :' || NULL , 5 ) ;
789:
790: oe_debug_pub.add( 'CURRENCY_CODE :' || NULL , 5 ) ;
791:
792: oe_debug_pub.add( 'CURRENCY_CONVERSION_TYPE :' || NULL , 5 ) ;
793:
794: oe_debug_pub.add( 'CURRENCY_CONVERSION_DATE :' || NULL , 5 ) ;
795:
796: oe_debug_pub.add( 'CURRENCY_CONVERSION_RATE :' || NULL , 5 ) ;

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

790: oe_debug_pub.add( 'CURRENCY_CODE :' || NULL , 5 ) ;
791:
792: oe_debug_pub.add( 'CURRENCY_CONVERSION_TYPE :' || NULL , 5 ) ;
793:
794: oe_debug_pub.add( 'CURRENCY_CONVERSION_DATE :' || NULL , 5 ) ;
795:
796: oe_debug_pub.add( 'CURRENCY_CONVERSION_RATE :' || NULL , 5 ) ;
797:
798: oe_debug_pub.add( 'ENCUMBRANCE_ACCOUNT :' || NULL , 5 ) ;

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

792: oe_debug_pub.add( 'CURRENCY_CONVERSION_TYPE :' || NULL , 5 ) ;
793:
794: oe_debug_pub.add( 'CURRENCY_CONVERSION_DATE :' || NULL , 5 ) ;
795:
796: oe_debug_pub.add( 'CURRENCY_CONVERSION_RATE :' || NULL , 5 ) ;
797:
798: oe_debug_pub.add( 'ENCUMBRANCE_ACCOUNT :' || NULL , 5 ) ;
799:
800: oe_debug_pub.add( 'ENCUMBRANCE_AMOUNT :' || NULL , 5 ) ;

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

794: oe_debug_pub.add( 'CURRENCY_CONVERSION_DATE :' || NULL , 5 ) ;
795:
796: oe_debug_pub.add( 'CURRENCY_CONVERSION_RATE :' || NULL , 5 ) ;
797:
798: oe_debug_pub.add( 'ENCUMBRANCE_ACCOUNT :' || NULL , 5 ) ;
799:
800: oe_debug_pub.add( 'ENCUMBRANCE_AMOUNT :' || NULL , 5 ) ;
801:
802: oe_debug_pub.add( 'PROJECT_ID :' || L_LINE_REC.PROJECT_ID , 5 ) ;

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

796: oe_debug_pub.add( 'CURRENCY_CONVERSION_RATE :' || NULL , 5 ) ;
797:
798: oe_debug_pub.add( 'ENCUMBRANCE_ACCOUNT :' || NULL , 5 ) ;
799:
800: oe_debug_pub.add( 'ENCUMBRANCE_AMOUNT :' || NULL , 5 ) ;
801:
802: oe_debug_pub.add( 'PROJECT_ID :' || L_LINE_REC.PROJECT_ID , 5 ) ;
803:
804: oe_debug_pub.add( 'TASK_ID :' || L_LINE_REC.TASK_ID , 5 ) ;

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

798: oe_debug_pub.add( 'ENCUMBRANCE_ACCOUNT :' || NULL , 5 ) ;
799:
800: oe_debug_pub.add( 'ENCUMBRANCE_AMOUNT :' || NULL , 5 ) ;
801:
802: oe_debug_pub.add( 'PROJECT_ID :' || L_LINE_REC.PROJECT_ID , 5 ) ;
803:
804: oe_debug_pub.add( 'TASK_ID :' || L_LINE_REC.TASK_ID , 5 ) ;
805: END IF;
806:

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

800: oe_debug_pub.add( 'ENCUMBRANCE_AMOUNT :' || NULL , 5 ) ;
801:
802: oe_debug_pub.add( 'PROJECT_ID :' || L_LINE_REC.PROJECT_ID , 5 ) ;
803:
804: oe_debug_pub.add( 'TASK_ID :' || L_LINE_REC.TASK_ID , 5 ) ;
805: END IF;
806:
807: INSERT INTO MTL_TRANSACTIONS_INTERFACE
808: (

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

1012:
1013: IF ( l_line_rec.subinventory is null or
1014: l_line_rec.subinventory = FND_API.G_MISS_CHAR ) THEN
1015: IF l_debug_level > 0 THEN
1016: oe_debug_pub.add( 'INV IFACE: SUBINV IS NULL OR MISS_CHAR FOR INSERT - 2' , 5 ) ;
1017: END IF;
1018: -- Give a message here
1019: FND_MESSAGE.SET_NAME('ONT', 'OE_INV_IFACE_SUB');
1020: -- message should say if item is under revision/lot/locator control, use the

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

1035: WHERE organization_id = l_line_rec.ship_from_org_id;
1036: EXCEPTION
1037: WHEN OTHERS THEN
1038: IF l_debug_level > 0 THEN
1039: oe_debug_pub.add( 'INV IFACE: LOCATOR CONTROL CODE SELECT FAILURE' , 5 ) ;
1040: END IF;
1041: x_return_status := FND_API.G_RET_STS_ERROR;
1042: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
1043: ROLLBACK TO INVENTORY_INTERFACE;

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

1053:
1054: EXCEPTION
1055: WHEN OTHERS THEN
1056: IF l_debug_level > 0 THEN
1057: oe_debug_pub.add( 'INV IFACE: LOCATOR TYPE SELECT FAILURE' , 5 ) ;
1058: END IF;
1059: x_return_status := FND_API.G_RET_STS_ERROR;
1060: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
1061: ROLLBACK TO INVENTORY_INTERFACE;

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

1072: -- ???? warehouse or validation org?
1073: EXCEPTION
1074: WHEN OTHERS THEN
1075: IF l_debug_level > 0 THEN
1076: oe_debug_pub.add( 'INV IFACE: LOCATION CONTROL CODE FAILURE' , 5 ) ;
1077: END IF;
1078: x_return_status := FND_API.G_RET_STS_ERROR;
1079: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
1080: ROLLBACK TO INVENTORY_INTERFACE;

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

1081: RETURN;
1082: END;
1083:
1084: IF l_debug_level > 0 THEN
1085: oe_debug_pub.add( 'INV IFACE: BEFORE LOCATOR_CONTROL API CALL' , 1 ) ;
1086: END IF;
1087:
1088: l_locator := INV_RESERVATION_UTIL_PVT.locator_control(
1089: p_org_control => l_stock_locator_control_code

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

1089: p_org_control => l_stock_locator_control_code
1090: ,p_sub_control => l_locator_type
1091: ,p_item_control => l_location_control_code);
1092: IF l_debug_level > 0 THEN
1093: oe_debug_pub.add( 'INV IFACE: AFTER LOCATOR_CONTROL API CALL - ' || TO_CHAR ( L_LOCATOR ) , 1 ) ;
1094: END IF;
1095:
1096: -- END IF; -- of branching HW OPM BUG#:2536589 INVCONV
1097:

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

1099: l_locator > 1 )THEN
1100: -- 2 == YES
1101: IF nvl(l_serial_code, 1) <> 1 THEN
1102: IF l_debug_level > 0 THEN
1103: oe_debug_pub.add( 'INV IFACE: ITEM UNDER SERIAL CONTORL , ERROR' , 5 ) ;
1104: END IF;
1105: -- give a message here
1106: FND_MESSAGE.SET_NAME('ONT', 'OE_INV_IFACE_SERIAL');
1107: OE_MSG_PUB.ADD;

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

1106: FND_MESSAGE.SET_NAME('ONT', 'OE_INV_IFACE_SERIAL');
1107: OE_MSG_PUB.ADD;
1108: ELSE
1109: IF l_debug_level > 0 THEN
1110: oe_debug_pub.add( 'INV IFACE: ITEM UNDER REVISION/LOT/LOCATOR CONTROL AND NO RESERVATION EXISTS' , 5 ) ;
1111: END IF;
1112: -- Give a message here
1113: FND_MESSAGE.SET_NAME('ONT', 'OE_INV_IFACE_NO_RSV');
1114: OE_MSG_PUB.ADD;

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

1122:
1123: /* -- HW OPm BUG#:2536589 Need to check for non-lot,non-inv OPM items. INVCONV
1124: IF ( l_process_org = 1 AND l_lot = 'N' ) THEN
1125: IF l_debug_level > 0 THEN
1126: oe_debug_pub.add( 'INV IFACE: NO DEFAULT TRXN EXISTS FOR NON-LOT , NON-INV OPM ITEM' , 5 ) ;
1127: END IF;
1128: x_return_status := FND_API.G_RET_STS_ERROR;
1129: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
1130: ROLLBACK TO INVENTORY_INTERFACE;

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

1138: INTO l_source_line_id
1139: FROM dual;
1140:
1141: IF l_debug_level > 0 THEN
1142: oe_debug_pub.add( 'INV IFACE: INSERTING RECORD - 2' , 5 ) ;
1143:
1144: oe_debug_pub.add( 'SOURCE_CODE :' || FND_PROFILE.VALUE ( 'ONT_SOURCE_CODE' ) , 5 ) ;
1145:
1146: oe_debug_pub.add( 'SOURCE_LINE_ID :' || L_SOURCE_LINE_ID , 5 ) ;

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

1140:
1141: IF l_debug_level > 0 THEN
1142: oe_debug_pub.add( 'INV IFACE: INSERTING RECORD - 2' , 5 ) ;
1143:
1144: oe_debug_pub.add( 'SOURCE_CODE :' || FND_PROFILE.VALUE ( 'ONT_SOURCE_CODE' ) , 5 ) ;
1145:
1146: oe_debug_pub.add( 'SOURCE_LINE_ID :' || L_SOURCE_LINE_ID , 5 ) ;
1147:
1148: oe_debug_pub.add( 'SOURCE_HEADER_ID :' || L_TRANSACTION_REFERENCE , 5 ) ;

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

1142: oe_debug_pub.add( 'INV IFACE: INSERTING RECORD - 2' , 5 ) ;
1143:
1144: oe_debug_pub.add( 'SOURCE_CODE :' || FND_PROFILE.VALUE ( 'ONT_SOURCE_CODE' ) , 5 ) ;
1145:
1146: oe_debug_pub.add( 'SOURCE_LINE_ID :' || L_SOURCE_LINE_ID , 5 ) ;
1147:
1148: oe_debug_pub.add( 'SOURCE_HEADER_ID :' || L_TRANSACTION_REFERENCE , 5 ) ;
1149:
1150: oe_debug_pub.add( 'PROCESS_FLAG :' || 1 , 5 ) ;

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

1144: oe_debug_pub.add( 'SOURCE_CODE :' || FND_PROFILE.VALUE ( 'ONT_SOURCE_CODE' ) , 5 ) ;
1145:
1146: oe_debug_pub.add( 'SOURCE_LINE_ID :' || L_SOURCE_LINE_ID , 5 ) ;
1147:
1148: oe_debug_pub.add( 'SOURCE_HEADER_ID :' || L_TRANSACTION_REFERENCE , 5 ) ;
1149:
1150: oe_debug_pub.add( 'PROCESS_FLAG :' || 1 , 5 ) ;
1151:
1152: oe_debug_pub.add( 'TRANSACTION_MODE :' || 1 , 5 ) ;

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

1146: oe_debug_pub.add( 'SOURCE_LINE_ID :' || L_SOURCE_LINE_ID , 5 ) ;
1147:
1148: oe_debug_pub.add( 'SOURCE_HEADER_ID :' || L_TRANSACTION_REFERENCE , 5 ) ;
1149:
1150: oe_debug_pub.add( 'PROCESS_FLAG :' || 1 , 5 ) ;
1151:
1152: oe_debug_pub.add( 'TRANSACTION_MODE :' || 1 , 5 ) ;
1153:
1154: oe_debug_pub.add( 'LOCK_FLAG :' || 2 , 5 ) ;

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

1148: oe_debug_pub.add( 'SOURCE_HEADER_ID :' || L_TRANSACTION_REFERENCE , 5 ) ;
1149:
1150: oe_debug_pub.add( 'PROCESS_FLAG :' || 1 , 5 ) ;
1151:
1152: oe_debug_pub.add( 'TRANSACTION_MODE :' || 1 , 5 ) ;
1153:
1154: oe_debug_pub.add( 'LOCK_FLAG :' || 2 , 5 ) ;
1155:
1156: oe_debug_pub.add( 'TRANSACTION_HEADER_ID :' || L_TRANSACTION_HEADER_ID , 5 ) ;

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

1150: oe_debug_pub.add( 'PROCESS_FLAG :' || 1 , 5 ) ;
1151:
1152: oe_debug_pub.add( 'TRANSACTION_MODE :' || 1 , 5 ) ;
1153:
1154: oe_debug_pub.add( 'LOCK_FLAG :' || 2 , 5 ) ;
1155:
1156: oe_debug_pub.add( 'TRANSACTION_HEADER_ID :' || L_TRANSACTION_HEADER_ID , 5 ) ;
1157:
1158: oe_debug_pub.add( 'INVENTORY_ITEM_ID :' || L_LINE_REC.INVENTORY_ITEM_ID , 5 ) ;

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

1152: oe_debug_pub.add( 'TRANSACTION_MODE :' || 1 , 5 ) ;
1153:
1154: oe_debug_pub.add( 'LOCK_FLAG :' || 2 , 5 ) ;
1155:
1156: oe_debug_pub.add( 'TRANSACTION_HEADER_ID :' || L_TRANSACTION_HEADER_ID , 5 ) ;
1157:
1158: oe_debug_pub.add( 'INVENTORY_ITEM_ID :' || L_LINE_REC.INVENTORY_ITEM_ID , 5 ) ;
1159:
1160: oe_debug_pub.add( 'SUBINVENTORY_CODE :' || L_LINE_REC.SUBINVENTORY , 5 ) ;

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

1154: oe_debug_pub.add( 'LOCK_FLAG :' || 2 , 5 ) ;
1155:
1156: oe_debug_pub.add( 'TRANSACTION_HEADER_ID :' || L_TRANSACTION_HEADER_ID , 5 ) ;
1157:
1158: oe_debug_pub.add( 'INVENTORY_ITEM_ID :' || L_LINE_REC.INVENTORY_ITEM_ID , 5 ) ;
1159:
1160: oe_debug_pub.add( 'SUBINVENTORY_CODE :' || L_LINE_REC.SUBINVENTORY , 5 ) ;
1161:
1162: oe_debug_pub.add( 'TRANSACTION_QUANTITY :' || ( -1 * L_LINE_REC.ORDERED_QUANTITY ) || ' OR ' || ( -1 * L_REMAINED_QTY ) , 5 ) ;

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

1156: oe_debug_pub.add( 'TRANSACTION_HEADER_ID :' || L_TRANSACTION_HEADER_ID , 5 ) ;
1157:
1158: oe_debug_pub.add( 'INVENTORY_ITEM_ID :' || L_LINE_REC.INVENTORY_ITEM_ID , 5 ) ;
1159:
1160: oe_debug_pub.add( 'SUBINVENTORY_CODE :' || L_LINE_REC.SUBINVENTORY , 5 ) ;
1161:
1162: oe_debug_pub.add( 'TRANSACTION_QUANTITY :' || ( -1 * L_LINE_REC.ORDERED_QUANTITY ) || ' OR ' || ( -1 * L_REMAINED_QTY ) , 5 ) ;
1163:
1164:

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

1158: oe_debug_pub.add( 'INVENTORY_ITEM_ID :' || L_LINE_REC.INVENTORY_ITEM_ID , 5 ) ;
1159:
1160: oe_debug_pub.add( 'SUBINVENTORY_CODE :' || L_LINE_REC.SUBINVENTORY , 5 ) ;
1161:
1162: oe_debug_pub.add( 'TRANSACTION_QUANTITY :' || ( -1 * L_LINE_REC.ORDERED_QUANTITY ) || ' OR ' || ( -1 * L_REMAINED_QTY ) , 5 ) ;
1163:
1164:
1165: -- (-1 * decode(reservation_flag, 'Y', l_remained_qty, l_line_rec.ordered_quantity)),1);
1166:

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

1164:
1165: -- (-1 * decode(reservation_flag, 'Y', l_remained_qty, l_line_rec.ordered_quantity)),1);
1166:
1167:
1168: -- bug 5897965 oe_debug_pub.add( 'TRANSACTION_DATE :' || l_ordered_date , 5 ) ;
1169:
1170: oe_debug_pub.add( 'TRANSACTION_DATE :' || l_trx_date_for_inv_iface , 5 ) ; --bug5897965
1171:
1172: oe_debug_pub.add( 'ORGANIZATION_ID :' || L_LINE_REC.SHIP_FROM_ORG_ID , 5 ) ;

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

1166:
1167:
1168: -- bug 5897965 oe_debug_pub.add( 'TRANSACTION_DATE :' || l_ordered_date , 5 ) ;
1169:
1170: oe_debug_pub.add( 'TRANSACTION_DATE :' || l_trx_date_for_inv_iface , 5 ) ; --bug5897965
1171:
1172: oe_debug_pub.add( 'ORGANIZATION_ID :' || L_LINE_REC.SHIP_FROM_ORG_ID , 5 ) ;
1173:
1174: oe_debug_pub.add( 'ACCT_PERIOD_ID :' || NULL , 5 ) ;

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

1168: -- bug 5897965 oe_debug_pub.add( 'TRANSACTION_DATE :' || l_ordered_date , 5 ) ;
1169:
1170: oe_debug_pub.add( 'TRANSACTION_DATE :' || l_trx_date_for_inv_iface , 5 ) ; --bug5897965
1171:
1172: oe_debug_pub.add( 'ORGANIZATION_ID :' || L_LINE_REC.SHIP_FROM_ORG_ID , 5 ) ;
1173:
1174: oe_debug_pub.add( 'ACCT_PERIOD_ID :' || NULL , 5 ) ;
1175:
1176: oe_debug_pub.add( 'LAST_UPDATE_DATE :' || SYSDATE , 5 ) ;

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

1170: oe_debug_pub.add( 'TRANSACTION_DATE :' || l_trx_date_for_inv_iface , 5 ) ; --bug5897965
1171:
1172: oe_debug_pub.add( 'ORGANIZATION_ID :' || L_LINE_REC.SHIP_FROM_ORG_ID , 5 ) ;
1173:
1174: oe_debug_pub.add( 'ACCT_PERIOD_ID :' || NULL , 5 ) ;
1175:
1176: oe_debug_pub.add( 'LAST_UPDATE_DATE :' || SYSDATE , 5 ) ;
1177:
1178: oe_debug_pub.add( 'LAST_UPDATED_BY :' || FND_GLOBAL.USER_ID , 5 ) ;

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

1172: oe_debug_pub.add( 'ORGANIZATION_ID :' || L_LINE_REC.SHIP_FROM_ORG_ID , 5 ) ;
1173:
1174: oe_debug_pub.add( 'ACCT_PERIOD_ID :' || NULL , 5 ) ;
1175:
1176: oe_debug_pub.add( 'LAST_UPDATE_DATE :' || SYSDATE , 5 ) ;
1177:
1178: oe_debug_pub.add( 'LAST_UPDATED_BY :' || FND_GLOBAL.USER_ID , 5 ) ;
1179:
1180: oe_debug_pub.add( 'CREATION_DATE :' || SYSDATE , 5 ) ;

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

1174: oe_debug_pub.add( 'ACCT_PERIOD_ID :' || NULL , 5 ) ;
1175:
1176: oe_debug_pub.add( 'LAST_UPDATE_DATE :' || SYSDATE , 5 ) ;
1177:
1178: oe_debug_pub.add( 'LAST_UPDATED_BY :' || FND_GLOBAL.USER_ID , 5 ) ;
1179:
1180: oe_debug_pub.add( 'CREATION_DATE :' || SYSDATE , 5 ) ;
1181:
1182: oe_debug_pub.add( 'CREATED_BY :' || FND_GLOBAL.USER_ID , 5 ) ;

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

1176: oe_debug_pub.add( 'LAST_UPDATE_DATE :' || SYSDATE , 5 ) ;
1177:
1178: oe_debug_pub.add( 'LAST_UPDATED_BY :' || FND_GLOBAL.USER_ID , 5 ) ;
1179:
1180: oe_debug_pub.add( 'CREATION_DATE :' || SYSDATE , 5 ) ;
1181:
1182: oe_debug_pub.add( 'CREATED_BY :' || FND_GLOBAL.USER_ID , 5 ) ;
1183:
1184: oe_debug_pub.add( 'TRANSACTION_SOURCE_ID :' || L_SALES_ORDER_ID , 5 ) ;

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

1178: oe_debug_pub.add( 'LAST_UPDATED_BY :' || FND_GLOBAL.USER_ID , 5 ) ;
1179:
1180: oe_debug_pub.add( 'CREATION_DATE :' || SYSDATE , 5 ) ;
1181:
1182: oe_debug_pub.add( 'CREATED_BY :' || FND_GLOBAL.USER_ID , 5 ) ;
1183:
1184: oe_debug_pub.add( 'TRANSACTION_SOURCE_ID :' || L_SALES_ORDER_ID , 5 ) ;
1185:
1186: oe_debug_pub.add( 'DSP_SEGMENT1 :' || L_ORDER_NUMBER , 5 ) ;

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

1180: oe_debug_pub.add( 'CREATION_DATE :' || SYSDATE , 5 ) ;
1181:
1182: oe_debug_pub.add( 'CREATED_BY :' || FND_GLOBAL.USER_ID , 5 ) ;
1183:
1184: oe_debug_pub.add( 'TRANSACTION_SOURCE_ID :' || L_SALES_ORDER_ID , 5 ) ;
1185:
1186: oe_debug_pub.add( 'DSP_SEGMENT1 :' || L_ORDER_NUMBER , 5 ) ;
1187:
1188: oe_debug_pub.add( 'DSP_SEGMENT2 :' || L_ORDER_TYPE_NAME , 5 ) ;

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

1182: oe_debug_pub.add( 'CREATED_BY :' || FND_GLOBAL.USER_ID , 5 ) ;
1183:
1184: oe_debug_pub.add( 'TRANSACTION_SOURCE_ID :' || L_SALES_ORDER_ID , 5 ) ;
1185:
1186: oe_debug_pub.add( 'DSP_SEGMENT1 :' || L_ORDER_NUMBER , 5 ) ;
1187:
1188: oe_debug_pub.add( 'DSP_SEGMENT2 :' || L_ORDER_TYPE_NAME , 5 ) ;
1189:
1190: oe_debug_pub.add( 'DSP_SEGMENT3 :' || FND_PROFILE.VALUE ( 'ONT_SOURCE_CODE' ) , 5 ) ;

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

1184: oe_debug_pub.add( 'TRANSACTION_SOURCE_ID :' || L_SALES_ORDER_ID , 5 ) ;
1185:
1186: oe_debug_pub.add( 'DSP_SEGMENT1 :' || L_ORDER_NUMBER , 5 ) ;
1187:
1188: oe_debug_pub.add( 'DSP_SEGMENT2 :' || L_ORDER_TYPE_NAME , 5 ) ;
1189:
1190: oe_debug_pub.add( 'DSP_SEGMENT3 :' || FND_PROFILE.VALUE ( 'ONT_SOURCE_CODE' ) , 5 ) ;
1191:
1192: oe_debug_pub.add( 'TRANSACTION_SOURCE_TYPE_ID :' || TO_CHAR ( 2 ) , 5 ) ;

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

1186: oe_debug_pub.add( 'DSP_SEGMENT1 :' || L_ORDER_NUMBER , 5 ) ;
1187:
1188: oe_debug_pub.add( 'DSP_SEGMENT2 :' || L_ORDER_TYPE_NAME , 5 ) ;
1189:
1190: oe_debug_pub.add( 'DSP_SEGMENT3 :' || FND_PROFILE.VALUE ( 'ONT_SOURCE_CODE' ) , 5 ) ;
1191:
1192: oe_debug_pub.add( 'TRANSACTION_SOURCE_TYPE_ID :' || TO_CHAR ( 2 ) , 5 ) ;
1193:
1194: oe_debug_pub.add( 'TRANSACTION_ACTION_ID :' || TO_CHAR ( 1 ) , 5 ) ;

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

1188: oe_debug_pub.add( 'DSP_SEGMENT2 :' || L_ORDER_TYPE_NAME , 5 ) ;
1189:
1190: oe_debug_pub.add( 'DSP_SEGMENT3 :' || FND_PROFILE.VALUE ( 'ONT_SOURCE_CODE' ) , 5 ) ;
1191:
1192: oe_debug_pub.add( 'TRANSACTION_SOURCE_TYPE_ID :' || TO_CHAR ( 2 ) , 5 ) ;
1193:
1194: oe_debug_pub.add( 'TRANSACTION_ACTION_ID :' || TO_CHAR ( 1 ) , 5 ) ;
1195:
1196: oe_debug_pub.add( 'TRANSACTION_TYPE_ID :' || TO_CHAR ( 33 ) , 5 ) ;

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

1190: oe_debug_pub.add( 'DSP_SEGMENT3 :' || FND_PROFILE.VALUE ( 'ONT_SOURCE_CODE' ) , 5 ) ;
1191:
1192: oe_debug_pub.add( 'TRANSACTION_SOURCE_TYPE_ID :' || TO_CHAR ( 2 ) , 5 ) ;
1193:
1194: oe_debug_pub.add( 'TRANSACTION_ACTION_ID :' || TO_CHAR ( 1 ) , 5 ) ;
1195:
1196: oe_debug_pub.add( 'TRANSACTION_TYPE_ID :' || TO_CHAR ( 33 ) , 5 ) ;
1197:
1198: oe_debug_pub.add( 'DISTRIBUTION_ACCOUNT_ID :' || L_TRANS_ACC , 5 ) ;

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

1192: oe_debug_pub.add( 'TRANSACTION_SOURCE_TYPE_ID :' || TO_CHAR ( 2 ) , 5 ) ;
1193:
1194: oe_debug_pub.add( 'TRANSACTION_ACTION_ID :' || TO_CHAR ( 1 ) , 5 ) ;
1195:
1196: oe_debug_pub.add( 'TRANSACTION_TYPE_ID :' || TO_CHAR ( 33 ) , 5 ) ;
1197:
1198: oe_debug_pub.add( 'DISTRIBUTION_ACCOUNT_ID :' || L_TRANS_ACC , 5 ) ;
1199:
1200: oe_debug_pub.add( 'TRANSACTION_REFERENCE :' || L_TRANSACTION_REFERENCE , 5 ) ;

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

1194: oe_debug_pub.add( 'TRANSACTION_ACTION_ID :' || TO_CHAR ( 1 ) , 5 ) ;
1195:
1196: oe_debug_pub.add( 'TRANSACTION_TYPE_ID :' || TO_CHAR ( 33 ) , 5 ) ;
1197:
1198: oe_debug_pub.add( 'DISTRIBUTION_ACCOUNT_ID :' || L_TRANS_ACC , 5 ) ;
1199:
1200: oe_debug_pub.add( 'TRANSACTION_REFERENCE :' || L_TRANSACTION_REFERENCE , 5 ) ;
1201:
1202: oe_debug_pub.add( 'TRX_SOURCE_LINE_ID :' || L_LINE_REC.LINE_ID , 5 ) ;

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

1196: oe_debug_pub.add( 'TRANSACTION_TYPE_ID :' || TO_CHAR ( 33 ) , 5 ) ;
1197:
1198: oe_debug_pub.add( 'DISTRIBUTION_ACCOUNT_ID :' || L_TRANS_ACC , 5 ) ;
1199:
1200: oe_debug_pub.add( 'TRANSACTION_REFERENCE :' || L_TRANSACTION_REFERENCE , 5 ) ;
1201:
1202: oe_debug_pub.add( 'TRX_SOURCE_LINE_ID :' || L_LINE_REC.LINE_ID , 5 ) ;
1203:
1204: oe_debug_pub.add( 'TRX_SOURCE_DELIVERY_ID :' || NULL , 5 ) ;

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

1198: oe_debug_pub.add( 'DISTRIBUTION_ACCOUNT_ID :' || L_TRANS_ACC , 5 ) ;
1199:
1200: oe_debug_pub.add( 'TRANSACTION_REFERENCE :' || L_TRANSACTION_REFERENCE , 5 ) ;
1201:
1202: oe_debug_pub.add( 'TRX_SOURCE_LINE_ID :' || L_LINE_REC.LINE_ID , 5 ) ;
1203:
1204: oe_debug_pub.add( 'TRX_SOURCE_DELIVERY_ID :' || NULL , 5 ) ;
1205:
1206: oe_debug_pub.add( 'REVISION :' || NULL , 5 ) ;

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

1200: oe_debug_pub.add( 'TRANSACTION_REFERENCE :' || L_TRANSACTION_REFERENCE , 5 ) ;
1201:
1202: oe_debug_pub.add( 'TRX_SOURCE_LINE_ID :' || L_LINE_REC.LINE_ID , 5 ) ;
1203:
1204: oe_debug_pub.add( 'TRX_SOURCE_DELIVERY_ID :' || NULL , 5 ) ;
1205:
1206: oe_debug_pub.add( 'REVISION :' || NULL , 5 ) ;
1207:
1208: oe_debug_pub.add( 'LOCATOR_ID :' || NULL , 5 ) ;

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

1202: oe_debug_pub.add( 'TRX_SOURCE_LINE_ID :' || L_LINE_REC.LINE_ID , 5 ) ;
1203:
1204: oe_debug_pub.add( 'TRX_SOURCE_DELIVERY_ID :' || NULL , 5 ) ;
1205:
1206: oe_debug_pub.add( 'REVISION :' || NULL , 5 ) ;
1207:
1208: oe_debug_pub.add( 'LOCATOR_ID :' || NULL , 5 ) ;
1209:
1210: oe_debug_pub.add( 'LOC_SEGMENT1 :' || NULL , 5 ) ;

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

1204: oe_debug_pub.add( 'TRX_SOURCE_DELIVERY_ID :' || NULL , 5 ) ;
1205:
1206: oe_debug_pub.add( 'REVISION :' || NULL , 5 ) ;
1207:
1208: oe_debug_pub.add( 'LOCATOR_ID :' || NULL , 5 ) ;
1209:
1210: oe_debug_pub.add( 'LOC_SEGMENT1 :' || NULL , 5 ) ;
1211:
1212: oe_debug_pub.add( 'LOC_SEGMENT2 :' || NULL , 5 ) ;

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

1206: oe_debug_pub.add( 'REVISION :' || NULL , 5 ) ;
1207:
1208: oe_debug_pub.add( 'LOCATOR_ID :' || NULL , 5 ) ;
1209:
1210: oe_debug_pub.add( 'LOC_SEGMENT1 :' || NULL , 5 ) ;
1211:
1212: oe_debug_pub.add( 'LOC_SEGMENT2 :' || NULL , 5 ) ;
1213:
1214: oe_debug_pub.add( 'LOC_SEGMENT3 :' || NULL , 5 ) ;

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

1208: oe_debug_pub.add( 'LOCATOR_ID :' || NULL , 5 ) ;
1209:
1210: oe_debug_pub.add( 'LOC_SEGMENT1 :' || NULL , 5 ) ;
1211:
1212: oe_debug_pub.add( 'LOC_SEGMENT2 :' || NULL , 5 ) ;
1213:
1214: oe_debug_pub.add( 'LOC_SEGMENT3 :' || NULL , 5 ) ;
1215:
1216: oe_debug_pub.add( 'LOC_SEGMENT4 :' || NULL , 5 ) ;

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

1210: oe_debug_pub.add( 'LOC_SEGMENT1 :' || NULL , 5 ) ;
1211:
1212: oe_debug_pub.add( 'LOC_SEGMENT2 :' || NULL , 5 ) ;
1213:
1214: oe_debug_pub.add( 'LOC_SEGMENT3 :' || NULL , 5 ) ;
1215:
1216: oe_debug_pub.add( 'LOC_SEGMENT4 :' || NULL , 5 ) ;
1217:
1218: oe_debug_pub.add( 'REQUIRED_FLAG :' || NULL , 5 ) ;

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

1212: oe_debug_pub.add( 'LOC_SEGMENT2 :' || NULL , 5 ) ;
1213:
1214: oe_debug_pub.add( 'LOC_SEGMENT3 :' || NULL , 5 ) ;
1215:
1216: oe_debug_pub.add( 'LOC_SEGMENT4 :' || NULL , 5 ) ;
1217:
1218: oe_debug_pub.add( 'REQUIRED_FLAG :' || NULL , 5 ) ;
1219:
1220: oe_debug_pub.add( 'PICKING_LINE_ID :' || NULL , 5 ) ;

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

1214: oe_debug_pub.add( 'LOC_SEGMENT3 :' || NULL , 5 ) ;
1215:
1216: oe_debug_pub.add( 'LOC_SEGMENT4 :' || NULL , 5 ) ;
1217:
1218: oe_debug_pub.add( 'REQUIRED_FLAG :' || NULL , 5 ) ;
1219:
1220: oe_debug_pub.add( 'PICKING_LINE_ID :' || NULL , 5 ) ;
1221:
1222: oe_debug_pub.add( 'TRANSFER_SUBINVENTORY :' || NULL , 5 ) ;

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

1216: oe_debug_pub.add( 'LOC_SEGMENT4 :' || NULL , 5 ) ;
1217:
1218: oe_debug_pub.add( 'REQUIRED_FLAG :' || NULL , 5 ) ;
1219:
1220: oe_debug_pub.add( 'PICKING_LINE_ID :' || NULL , 5 ) ;
1221:
1222: oe_debug_pub.add( 'TRANSFER_SUBINVENTORY :' || NULL , 5 ) ;
1223:
1224: oe_debug_pub.add( 'TRANSFER_ORGANIZATION :' || NULL , 5 ) ;

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

1218: oe_debug_pub.add( 'REQUIRED_FLAG :' || NULL , 5 ) ;
1219:
1220: oe_debug_pub.add( 'PICKING_LINE_ID :' || NULL , 5 ) ;
1221:
1222: oe_debug_pub.add( 'TRANSFER_SUBINVENTORY :' || NULL , 5 ) ;
1223:
1224: oe_debug_pub.add( 'TRANSFER_ORGANIZATION :' || NULL , 5 ) ;
1225:
1226: oe_debug_pub.add( 'SHIP_TO_LOCATION_ID :' || NULL , 5 ) ;

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

1220: oe_debug_pub.add( 'PICKING_LINE_ID :' || NULL , 5 ) ;
1221:
1222: oe_debug_pub.add( 'TRANSFER_SUBINVENTORY :' || NULL , 5 ) ;
1223:
1224: oe_debug_pub.add( 'TRANSFER_ORGANIZATION :' || NULL , 5 ) ;
1225:
1226: oe_debug_pub.add( 'SHIP_TO_LOCATION_ID :' || NULL , 5 ) ;
1227:
1228: oe_debug_pub.add( 'REQUISITION_LINE_ID :' || NULL , 5 ) ;

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

1222: oe_debug_pub.add( 'TRANSFER_SUBINVENTORY :' || NULL , 5 ) ;
1223:
1224: oe_debug_pub.add( 'TRANSFER_ORGANIZATION :' || NULL , 5 ) ;
1225:
1226: oe_debug_pub.add( 'SHIP_TO_LOCATION_ID :' || NULL , 5 ) ;
1227:
1228: oe_debug_pub.add( 'REQUISITION_LINE_ID :' || NULL , 5 ) ;
1229:
1230: oe_debug_pub.add( 'TRANSACTION_UOM :' || L_LINE_REC.ORDER_QUANTITY_UOM , 5 ) ;

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

1224: oe_debug_pub.add( 'TRANSFER_ORGANIZATION :' || NULL , 5 ) ;
1225:
1226: oe_debug_pub.add( 'SHIP_TO_LOCATION_ID :' || NULL , 5 ) ;
1227:
1228: oe_debug_pub.add( 'REQUISITION_LINE_ID :' || NULL , 5 ) ;
1229:
1230: oe_debug_pub.add( 'TRANSACTION_UOM :' || L_LINE_REC.ORDER_QUANTITY_UOM , 5 ) ;
1231:
1232: oe_debug_pub.add( 'TRANS INTERFACE_ID :' || L_TRANSACTION_INTERFACE_ID , 5 ) ;

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

1226: oe_debug_pub.add( 'SHIP_TO_LOCATION_ID :' || NULL , 5 ) ;
1227:
1228: oe_debug_pub.add( 'REQUISITION_LINE_ID :' || NULL , 5 ) ;
1229:
1230: oe_debug_pub.add( 'TRANSACTION_UOM :' || L_LINE_REC.ORDER_QUANTITY_UOM , 5 ) ;
1231:
1232: oe_debug_pub.add( 'TRANS INTERFACE_ID :' || L_TRANSACTION_INTERFACE_ID , 5 ) ;
1233:
1234: oe_debug_pub.add( 'DEMAND_ID :' || NULL , 5 ) ;

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

1228: oe_debug_pub.add( 'REQUISITION_LINE_ID :' || NULL , 5 ) ;
1229:
1230: oe_debug_pub.add( 'TRANSACTION_UOM :' || L_LINE_REC.ORDER_QUANTITY_UOM , 5 ) ;
1231:
1232: oe_debug_pub.add( 'TRANS INTERFACE_ID :' || L_TRANSACTION_INTERFACE_ID , 5 ) ;
1233:
1234: oe_debug_pub.add( 'DEMAND_ID :' || NULL , 5 ) ;
1235:
1236: oe_debug_pub.add( 'SHIPMENT_NUMBER :' || NULL , 5 ) ;

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

1230: oe_debug_pub.add( 'TRANSACTION_UOM :' || L_LINE_REC.ORDER_QUANTITY_UOM , 5 ) ;
1231:
1232: oe_debug_pub.add( 'TRANS INTERFACE_ID :' || L_TRANSACTION_INTERFACE_ID , 5 ) ;
1233:
1234: oe_debug_pub.add( 'DEMAND_ID :' || NULL , 5 ) ;
1235:
1236: oe_debug_pub.add( 'SHIPMENT_NUMBER :' || NULL , 5 ) ;
1237:
1238: oe_debug_pub.add( 'CURRENCY_CODE :' || NULL , 5 ) ;

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

1232: oe_debug_pub.add( 'TRANS INTERFACE_ID :' || L_TRANSACTION_INTERFACE_ID , 5 ) ;
1233:
1234: oe_debug_pub.add( 'DEMAND_ID :' || NULL , 5 ) ;
1235:
1236: oe_debug_pub.add( 'SHIPMENT_NUMBER :' || NULL , 5 ) ;
1237:
1238: oe_debug_pub.add( 'CURRENCY_CODE :' || NULL , 5 ) ;
1239:
1240: oe_debug_pub.add( 'CURRENCY_CONVERSION_TYPE :' || NULL , 5 ) ;

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

1234: oe_debug_pub.add( 'DEMAND_ID :' || NULL , 5 ) ;
1235:
1236: oe_debug_pub.add( 'SHIPMENT_NUMBER :' || NULL , 5 ) ;
1237:
1238: oe_debug_pub.add( 'CURRENCY_CODE :' || NULL , 5 ) ;
1239:
1240: oe_debug_pub.add( 'CURRENCY_CONVERSION_TYPE :' || NULL , 5 ) ;
1241:
1242: oe_debug_pub.add( 'CURRENCY_CONVERSION_DATE :' || NULL , 5 ) ;

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

1236: oe_debug_pub.add( 'SHIPMENT_NUMBER :' || NULL , 5 ) ;
1237:
1238: oe_debug_pub.add( 'CURRENCY_CODE :' || NULL , 5 ) ;
1239:
1240: oe_debug_pub.add( 'CURRENCY_CONVERSION_TYPE :' || NULL , 5 ) ;
1241:
1242: oe_debug_pub.add( 'CURRENCY_CONVERSION_DATE :' || NULL , 5 ) ;
1243:
1244: oe_debug_pub.add( 'CURRENCY_CONVERSION_RATE :' || NULL , 5 ) ;

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

1238: oe_debug_pub.add( 'CURRENCY_CODE :' || NULL , 5 ) ;
1239:
1240: oe_debug_pub.add( 'CURRENCY_CONVERSION_TYPE :' || NULL , 5 ) ;
1241:
1242: oe_debug_pub.add( 'CURRENCY_CONVERSION_DATE :' || NULL , 5 ) ;
1243:
1244: oe_debug_pub.add( 'CURRENCY_CONVERSION_RATE :' || NULL , 5 ) ;
1245:
1246: oe_debug_pub.add( 'ENCUMBRANCE_ACCOUNT :' || NULL , 5 ) ;

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

1240: oe_debug_pub.add( 'CURRENCY_CONVERSION_TYPE :' || NULL , 5 ) ;
1241:
1242: oe_debug_pub.add( 'CURRENCY_CONVERSION_DATE :' || NULL , 5 ) ;
1243:
1244: oe_debug_pub.add( 'CURRENCY_CONVERSION_RATE :' || NULL , 5 ) ;
1245:
1246: oe_debug_pub.add( 'ENCUMBRANCE_ACCOUNT :' || NULL , 5 ) ;
1247:
1248: oe_debug_pub.add( 'ENCUMBRANCE_AMOUNT :' || NULL , 5 ) ;

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

1242: oe_debug_pub.add( 'CURRENCY_CONVERSION_DATE :' || NULL , 5 ) ;
1243:
1244: oe_debug_pub.add( 'CURRENCY_CONVERSION_RATE :' || NULL , 5 ) ;
1245:
1246: oe_debug_pub.add( 'ENCUMBRANCE_ACCOUNT :' || NULL , 5 ) ;
1247:
1248: oe_debug_pub.add( 'ENCUMBRANCE_AMOUNT :' || NULL , 5 ) ;
1249:
1250: oe_debug_pub.add( 'PROJECT_ID :' || L_LINE_REC.PROJECT_ID , 5 ) ;

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

1244: oe_debug_pub.add( 'CURRENCY_CONVERSION_RATE :' || NULL , 5 ) ;
1245:
1246: oe_debug_pub.add( 'ENCUMBRANCE_ACCOUNT :' || NULL , 5 ) ;
1247:
1248: oe_debug_pub.add( 'ENCUMBRANCE_AMOUNT :' || NULL , 5 ) ;
1249:
1250: oe_debug_pub.add( 'PROJECT_ID :' || L_LINE_REC.PROJECT_ID , 5 ) ;
1251:
1252: oe_debug_pub.add( 'TASK_ID :' || L_LINE_REC.TASK_ID , 5 ) ;

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

1246: oe_debug_pub.add( 'ENCUMBRANCE_ACCOUNT :' || NULL , 5 ) ;
1247:
1248: oe_debug_pub.add( 'ENCUMBRANCE_AMOUNT :' || NULL , 5 ) ;
1249:
1250: oe_debug_pub.add( 'PROJECT_ID :' || L_LINE_REC.PROJECT_ID , 5 ) ;
1251:
1252: oe_debug_pub.add( 'TASK_ID :' || L_LINE_REC.TASK_ID , 5 ) ;
1253: END IF;
1254:

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

1248: oe_debug_pub.add( 'ENCUMBRANCE_AMOUNT :' || NULL , 5 ) ;
1249:
1250: oe_debug_pub.add( 'PROJECT_ID :' || L_LINE_REC.PROJECT_ID , 5 ) ;
1251:
1252: oe_debug_pub.add( 'TASK_ID :' || L_LINE_REC.TASK_ID , 5 ) ;
1253: END IF;
1254:
1255: INSERT INTO MTL_TRANSACTIONS_INTERFACE
1256: (

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

1424: FROM gl_code_combinations
1425: WHERE code_combination_id = l_trans_acc;
1426:
1427: IF l_debug_level > 0 THEN
1428: oe_debug_pub.add( 'INV IFACE: FINISH INSERTING - 2 , CALLING UPDATE_FLOW_STATUS_CODE' , 1 ) ;
1429: END IF;
1430:
1431: /* -- HW OPM BUG#:2536589 -- INVCONV
1432: END IF; -- of branching */

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

1439: , p_flow_status_code => 'INVENTORY_INTERFACED'
1440: , x_return_status => l_return_status);
1441: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1442: IF l_debug_level > 0 THEN
1443: oe_debug_pub.add( 'INV IFACE: UPDATE FLOW STATUS CODE FAILED' , 5 ) ;
1444: END IF;
1445: END IF;
1446:
1447: END IF; -- If line is shippable

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

1452: IF (l_line_rec.explosion_date IS NULL AND
1453: l_line_rec.top_model_line_id IS NOT NULL AND
1454: l_line_rec.ato_line_id IS NULL) THEN
1455: IF l_debug_level > 0 THEN
1456: oe_debug_pub.add( 'INV IFACE: IT IS A PTO LINE WITHOUT EXPLOSION DATE' , 3 ) ;
1457: END IF;
1458: IF l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_MODEL OR
1459: l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CLASS OR
1460: l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_KIT THEN

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

1458: IF l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_MODEL OR
1459: l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CLASS OR
1460: l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_KIT THEN
1461: IF l_debug_level > 0 THEN
1462: oe_debug_pub.add( 'INV IFACE: IT IS ITEM TYPE : '|| L_LINE_REC.ITEM_TYPE_CODE , 3 ) ;
1463: END IF;
1464: -- Do the explosion
1465: l_return_status := OE_Config_Util.Process_Included_Items(
1466: p_line_id => l_line_rec.line_id

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

1466: p_line_id => l_line_rec.line_id
1467: ,p_freeze => TRUE
1468: ,p_process_requests => TRUE);
1469: IF l_debug_level > 0 THEN
1470: oe_debug_pub.add( 'INV IFACE: AFTER CALLING EXPLOSION : '|| L_RETURN_STATUS , 3 ) ;
1471: END IF;
1472: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1473: IF l_debug_level > 0 THEN
1474: oe_debug_pub.add( 'INV IFACE: FREEZE INCLUDED ITEM FAILED - UNEXP' , 1 ) ;

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

1470: oe_debug_pub.add( 'INV IFACE: AFTER CALLING EXPLOSION : '|| L_RETURN_STATUS , 3 ) ;
1471: END IF;
1472: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1473: IF l_debug_level > 0 THEN
1474: oe_debug_pub.add( 'INV IFACE: FREEZE INCLUDED ITEM FAILED - UNEXP' , 1 ) ;
1475: END IF;
1476: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1477: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1478: IF l_debug_level > 0 THEN

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

1475: END IF;
1476: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1477: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1478: IF l_debug_level > 0 THEN
1479: oe_debug_pub.add( 'INV IFACE: FREEZE INCLUDED ITEM FAILED - EXP' , 1 ) ;
1480: END IF;
1481: RAISE FND_API.G_EXC_ERROR;
1482: END IF;
1483: END IF;

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

1485:
1486: /* bug 4659103: update of visible_demand_flag code removed */
1487:
1488: IF l_debug_level > 0 THEN
1489: oe_debug_pub.add( 'INV IFACE: EXITING INVENTORY_INTERFACE' , 1 ) ;
1490: END IF;
1491:
1492: EXCEPTION
1493: WHEN OTHERS THEN

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

1499: );
1500: END IF;
1501:
1502: IF l_debug_level > 0 THEN
1503: oe_debug_pub.add( 'INV IFACE ERROR MESSAGE : '||SUBSTR ( SQLERRM , 1 , 100 ) , 1 ) ;
1504: END IF;
1505: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1506: END Inventory_Interface;
1507: