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

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

60: l_qty2_to_reserve NUMBER := 0;
61:
62:
63: --
64: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
65: --
66: BEGIN
67: l_header_rec := p_header_rec;
68: l_line_tbl := p_line_tbl;

Line 79: oe_debug_pub.add( 'BEFORE RESERVATION' ) ;

75:
76: p_return_status := l_return_status;
77:
78: IF l_debug_level > 0 THEN
79: oe_debug_pub.add( 'BEFORE RESERVATION' ) ;
80: END IF;
81:
82: FOR I in 1..l_reservation_tbl.count
83: LOOP

Line 85: oe_debug_pub.add( 'HEADER_ID: '|| L_HEADER_REC.HEADER_ID ) ;

81:
82: FOR I in 1..l_reservation_tbl.count
83: LOOP
84: IF l_debug_level > 0 THEN
85: oe_debug_pub.add( 'HEADER_ID: '|| L_HEADER_REC.HEADER_ID ) ;
86: END IF;
87: IF l_debug_level > 0 THEN
88: oe_debug_pub.add( 'LINE_ID: '|| L_LINE_TBL ( L_RESERVATION_TBL ( I ) .LINE_INDEX ) .LINE_ID ) ;
89: END IF;

Line 88: oe_debug_pub.add( 'LINE_ID: '|| L_LINE_TBL ( L_RESERVATION_TBL ( I ) .LINE_INDEX ) .LINE_ID ) ;

84: IF l_debug_level > 0 THEN
85: oe_debug_pub.add( 'HEADER_ID: '|| L_HEADER_REC.HEADER_ID ) ;
86: END IF;
87: IF l_debug_level > 0 THEN
88: oe_debug_pub.add( 'LINE_ID: '|| L_LINE_TBL ( L_RESERVATION_TBL ( I ) .LINE_INDEX ) .LINE_ID ) ;
89: END IF;
90: IF l_debug_level > 0 THEN
91: oe_debug_pub.add( 'ORG_ID: '|| L_LINE_TBL ( L_RESERVATION_TBL ( I ) .LINE_INDEX ) .ORG_ID ) ;
92: END IF;

Line 91: oe_debug_pub.add( 'ORG_ID: '|| L_LINE_TBL ( L_RESERVATION_TBL ( I ) .LINE_INDEX ) .ORG_ID ) ;

87: IF l_debug_level > 0 THEN
88: oe_debug_pub.add( 'LINE_ID: '|| L_LINE_TBL ( L_RESERVATION_TBL ( I ) .LINE_INDEX ) .LINE_ID ) ;
89: END IF;
90: IF l_debug_level > 0 THEN
91: oe_debug_pub.add( 'ORG_ID: '|| L_LINE_TBL ( L_RESERVATION_TBL ( I ) .LINE_INDEX ) .ORG_ID ) ;
92: END IF;
93: IF l_debug_level > 0 THEN
94: oe_debug_pub.add( 'REQUEST_DATE: '|| L_LINE_TBL ( L_RESERVATION_TBL ( I ) .LINE_INDEX ) .REQUEST_DATE ) ;
95: END IF;

Line 94: oe_debug_pub.add( 'REQUEST_DATE: '|| L_LINE_TBL ( L_RESERVATION_TBL ( I ) .LINE_INDEX ) .REQUEST_DATE ) ;

90: IF l_debug_level > 0 THEN
91: oe_debug_pub.add( 'ORG_ID: '|| L_LINE_TBL ( L_RESERVATION_TBL ( I ) .LINE_INDEX ) .ORG_ID ) ;
92: END IF;
93: IF l_debug_level > 0 THEN
94: oe_debug_pub.add( 'REQUEST_DATE: '|| L_LINE_TBL ( L_RESERVATION_TBL ( I ) .LINE_INDEX ) .REQUEST_DATE ) ;
95: END IF;
96: IF l_debug_level > 0 THEN
97: oe_debug_pub.add( 'ORD_QTY_UOM: '|| L_LINE_TBL ( L_RESERVATION_TBL ( I ) .LINE_INDEX ) .ORDER_QUANTITY_UOM ) ;
98: END IF;

Line 97: oe_debug_pub.add( 'ORD_QTY_UOM: '|| L_LINE_TBL ( L_RESERVATION_TBL ( I ) .LINE_INDEX ) .ORDER_QUANTITY_UOM ) ;

93: IF l_debug_level > 0 THEN
94: oe_debug_pub.add( 'REQUEST_DATE: '|| L_LINE_TBL ( L_RESERVATION_TBL ( I ) .LINE_INDEX ) .REQUEST_DATE ) ;
95: END IF;
96: IF l_debug_level > 0 THEN
97: oe_debug_pub.add( 'ORD_QTY_UOM: '|| L_LINE_TBL ( L_RESERVATION_TBL ( I ) .LINE_INDEX ) .ORDER_QUANTITY_UOM ) ;
98: END IF;
99: IF l_debug_level > 0 THEN
100: oe_debug_pub.add( 'ORD_QTY: '|| L_LINE_TBL ( L_RESERVATION_TBL ( I ) .LINE_INDEX ) .ORDERED_QUANTITY ) ;
101: END IF;

Line 100: oe_debug_pub.add( 'ORD_QTY: '|| L_LINE_TBL ( L_RESERVATION_TBL ( I ) .LINE_INDEX ) .ORDERED_QUANTITY ) ;

96: IF l_debug_level > 0 THEN
97: oe_debug_pub.add( 'ORD_QTY_UOM: '|| L_LINE_TBL ( L_RESERVATION_TBL ( I ) .LINE_INDEX ) .ORDER_QUANTITY_UOM ) ;
98: END IF;
99: IF l_debug_level > 0 THEN
100: oe_debug_pub.add( 'ORD_QTY: '|| L_LINE_TBL ( L_RESERVATION_TBL ( I ) .LINE_INDEX ) .ORDERED_QUANTITY ) ;
101: END IF;
102: -- Following code can be removed yet to confirm with old release
103: -- IF (nvl(l_reservation_tbl(I).revision, FND_API.G_MISS_CHAR)
104: -- <> FND_API.G_MISS_CHAR OR

Line 139: oe_debug_pub.add( 'BEFORE SETTING RESERVATION PARAMETERS' ) ;

135: FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR
136: THEN
137: BEGIN
138: IF l_debug_level > 0 THEN
139: oe_debug_pub.add( 'BEFORE SETTING RESERVATION PARAMETERS' ) ;
140: END IF;
141:
142:
143: IF l_debug_level > 0 THEN

Line 144: oe_debug_pub.add( 'REVISION: ' || L_RESERVATION_TBL ( I ) .REVISION ) ;

140: END IF;
141:
142:
143: IF l_debug_level > 0 THEN
144: oe_debug_pub.add( 'REVISION: ' || L_RESERVATION_TBL ( I ) .REVISION ) ;
145: END IF;
146: IF l_debug_level > 0 THEN
147: oe_debug_pub.add( 'LOT_NUMBER_ID: ' || L_RESERVATION_TBL ( I ) .LOT_NUMBER_ID ) ;
148: END IF;

Line 147: oe_debug_pub.add( 'LOT_NUMBER_ID: ' || L_RESERVATION_TBL ( I ) .LOT_NUMBER_ID ) ;

143: IF l_debug_level > 0 THEN
144: oe_debug_pub.add( 'REVISION: ' || L_RESERVATION_TBL ( I ) .REVISION ) ;
145: END IF;
146: IF l_debug_level > 0 THEN
147: oe_debug_pub.add( 'LOT_NUMBER_ID: ' || L_RESERVATION_TBL ( I ) .LOT_NUMBER_ID ) ;
148: END IF;
149: IF l_debug_level > 0 THEN
150: oe_debug_pub.add( 'LOT_NUMBER: ' || L_RESERVATION_VAL_TBL ( I ) .LOT_NUMBER ) ;
151: END IF;

Line 150: oe_debug_pub.add( 'LOT_NUMBER: ' || L_RESERVATION_VAL_TBL ( I ) .LOT_NUMBER ) ;

146: IF l_debug_level > 0 THEN
147: oe_debug_pub.add( 'LOT_NUMBER_ID: ' || L_RESERVATION_TBL ( I ) .LOT_NUMBER_ID ) ;
148: END IF;
149: IF l_debug_level > 0 THEN
150: oe_debug_pub.add( 'LOT_NUMBER: ' || L_RESERVATION_VAL_TBL ( I ) .LOT_NUMBER ) ;
151: END IF;
152: IF l_debug_level > 0 THEN
153: oe_debug_pub.add( 'SUBINVENTORY_ID: ' || L_RESERVATION_TBL ( I ) .SUBINVENTORY_ID ) ;
154: END IF;

Line 153: oe_debug_pub.add( 'SUBINVENTORY_ID: ' || L_RESERVATION_TBL ( I ) .SUBINVENTORY_ID ) ;

149: IF l_debug_level > 0 THEN
150: oe_debug_pub.add( 'LOT_NUMBER: ' || L_RESERVATION_VAL_TBL ( I ) .LOT_NUMBER ) ;
151: END IF;
152: IF l_debug_level > 0 THEN
153: oe_debug_pub.add( 'SUBINVENTORY_ID: ' || L_RESERVATION_TBL ( I ) .SUBINVENTORY_ID ) ;
154: END IF;
155: IF l_debug_level > 0 THEN
156: oe_debug_pub.add( 'SUBINVENTORY_CODE: '|| L_RESERVATION_VAL_TBL ( I ) .SUBINVENTORY_CODE ) ;
157: END IF;

Line 156: oe_debug_pub.add( 'SUBINVENTORY_CODE: '|| L_RESERVATION_VAL_TBL ( I ) .SUBINVENTORY_CODE ) ;

152: IF l_debug_level > 0 THEN
153: oe_debug_pub.add( 'SUBINVENTORY_ID: ' || L_RESERVATION_TBL ( I ) .SUBINVENTORY_ID ) ;
154: END IF;
155: IF l_debug_level > 0 THEN
156: oe_debug_pub.add( 'SUBINVENTORY_CODE: '|| L_RESERVATION_VAL_TBL ( I ) .SUBINVENTORY_CODE ) ;
157: END IF;
158: IF l_debug_level > 0 THEN
159: oe_debug_pub.add( 'LOCATOR_ID: ' || L_RESERVATION_TBL ( I ) .LOCATOR_ID ) ;
160: END IF;

Line 159: oe_debug_pub.add( 'LOCATOR_ID: ' || L_RESERVATION_TBL ( I ) .LOCATOR_ID ) ;

155: IF l_debug_level > 0 THEN
156: oe_debug_pub.add( 'SUBINVENTORY_CODE: '|| L_RESERVATION_VAL_TBL ( I ) .SUBINVENTORY_CODE ) ;
157: END IF;
158: IF l_debug_level > 0 THEN
159: oe_debug_pub.add( 'LOCATOR_ID: ' || L_RESERVATION_TBL ( I ) .LOCATOR_ID ) ;
160: END IF;
161: IF l_debug_level > 0 THEN
162: oe_debug_pub.add( 'QUANTITY: ' || L_RESERVATION_TBL ( I ) .QUANTITY ) ;
163: END IF;

Line 162: oe_debug_pub.add( 'QUANTITY: ' || L_RESERVATION_TBL ( I ) .QUANTITY ) ;

158: IF l_debug_level > 0 THEN
159: oe_debug_pub.add( 'LOCATOR_ID: ' || L_RESERVATION_TBL ( I ) .LOCATOR_ID ) ;
160: END IF;
161: IF l_debug_level > 0 THEN
162: oe_debug_pub.add( 'QUANTITY: ' || L_RESERVATION_TBL ( I ) .QUANTITY ) ;
163: END IF;
164:
165:
166: -- Get demand_source_header_id from mtl_sales_orders

Line 233: oe_debug_pub.add( 'DEMAND_SOURCE_HEADER_ID: '|| TO_CHAR ( L_HEADER_REC.HEADER_ID ) ) ;

229: mtl_res_rec.attribute15 := l_reservation_tbl(I).attribute15;
230:
231: -- aksingh for the bug# 1537689 and bug# 1661359
232: IF l_debug_level > 0 THEN
233: oe_debug_pub.add( 'DEMAND_SOURCE_HEADER_ID: '|| TO_CHAR ( L_HEADER_REC.HEADER_ID ) ) ;
234: END IF;
235: IF l_debug_level > 0 THEN
236: oe_debug_pub.add( 'DEMAND_SOURCE_LINE_ID: ' || TO_CHAR ( L_LINE_TBL ( L_RESERVATION_TBL ( I ) .LINE_INDEX ) .LINE_ID ) ) ;
237: END IF;

Line 236: oe_debug_pub.add( 'DEMAND_SOURCE_LINE_ID: ' || TO_CHAR ( L_LINE_TBL ( L_RESERVATION_TBL ( I ) .LINE_INDEX ) .LINE_ID ) ) ;

232: IF l_debug_level > 0 THEN
233: oe_debug_pub.add( 'DEMAND_SOURCE_HEADER_ID: '|| TO_CHAR ( L_HEADER_REC.HEADER_ID ) ) ;
234: END IF;
235: IF l_debug_level > 0 THEN
236: oe_debug_pub.add( 'DEMAND_SOURCE_LINE_ID: ' || TO_CHAR ( L_LINE_TBL ( L_RESERVATION_TBL ( I ) .LINE_INDEX ) .LINE_ID ) ) ;
237: END IF;
238: IF l_debug_level > 0 THEN
239: oe_debug_pub.add( 'ORG_ID: ' || TO_CHAR ( L_LINE_TBL ( L_RESERVATION_TBL ( I ) .LINE_INDEX ) .ORG_ID ) ) ;
240: END IF;

Line 239: oe_debug_pub.add( 'ORG_ID: ' || TO_CHAR ( L_LINE_TBL ( L_RESERVATION_TBL ( I ) .LINE_INDEX ) .ORG_ID ) ) ;

235: IF l_debug_level > 0 THEN
236: oe_debug_pub.add( 'DEMAND_SOURCE_LINE_ID: ' || TO_CHAR ( L_LINE_TBL ( L_RESERVATION_TBL ( I ) .LINE_INDEX ) .LINE_ID ) ) ;
237: END IF;
238: IF l_debug_level > 0 THEN
239: oe_debug_pub.add( 'ORG_ID: ' || TO_CHAR ( L_LINE_TBL ( L_RESERVATION_TBL ( I ) .LINE_INDEX ) .ORG_ID ) ) ;
240: END IF;
241: l_qty_already_rsv_loop := 0;
242: l_qty_to_reserve := 0;
243: -- INVCONV

Line 284: oe_debug_pub.add( 'L_QTY_ALREADY_RSV_LOOP: ' || L_QTY_ALREADY_RSV_LOOP ) ;

280: -- are some additional information about the lot,subinv or something
281: -- we have to unreserve and re-reserve otherwise if no additional information
282: -- then we will leave the reservation as it is.
283: IF l_debug_level > 0 THEN
284: oe_debug_pub.add( 'L_QTY_ALREADY_RSV_LOOP: ' || L_QTY_ALREADY_RSV_LOOP ) ;
285: oe_debug_pub.add( 'L_QTY2_ALREADY_RSV_LOOP: ' || L_QTY2_ALREADY_RSV_LOOP ) ;
286: END IF;
287:
288: --check

Line 285: oe_debug_pub.add( 'L_QTY2_ALREADY_RSV_LOOP: ' || L_QTY2_ALREADY_RSV_LOOP ) ;

281: -- we have to unreserve and re-reserve otherwise if no additional information
282: -- then we will leave the reservation as it is.
283: IF l_debug_level > 0 THEN
284: oe_debug_pub.add( 'L_QTY_ALREADY_RSV_LOOP: ' || L_QTY_ALREADY_RSV_LOOP ) ;
285: oe_debug_pub.add( 'L_QTY2_ALREADY_RSV_LOOP: ' || L_QTY2_ALREADY_RSV_LOOP ) ;
286: END IF;
287:
288: --check
289:

Line 294: oe_debug_pub.add( 'I>2' ) ;

290: if(I>1) then
291:
292: if (l_qty_already_rsv_loop >0 AND (l_reservation_tbl(I).line_index <> l_reservation_tbl(I-1).line_index) ) then
293: IF l_debug_level > 0 THEN
294: oe_debug_pub.add( 'I>2' ) ;
295: END IF;
296: IF l_debug_level > 0 THEN
297: oe_debug_pub.add( 'BEFORE CALLING UNRESERVE_LINE' ) ;
298: END IF;

Line 297: oe_debug_pub.add( 'BEFORE CALLING UNRESERVE_LINE' ) ;

293: IF l_debug_level > 0 THEN
294: oe_debug_pub.add( 'I>2' ) ;
295: END IF;
296: IF l_debug_level > 0 THEN
297: oe_debug_pub.add( 'BEFORE CALLING UNRESERVE_LINE' ) ;
298: END IF;
299: IF l_debug_level > 0 THEN
300: oe_debug_pub.add( 'RESERVED_QUANTITY ' ||L_QTY_ALREADY_RSV_LOOP ) ;
301: oe_debug_pub.add( 'RESERVED_QUANTITY2 ' ||L_QTY2_ALREADY_RSV_LOOP ) ;

Line 300: oe_debug_pub.add( 'RESERVED_QUANTITY ' ||L_QTY_ALREADY_RSV_LOOP ) ;

296: IF l_debug_level > 0 THEN
297: oe_debug_pub.add( 'BEFORE CALLING UNRESERVE_LINE' ) ;
298: END IF;
299: IF l_debug_level > 0 THEN
300: oe_debug_pub.add( 'RESERVED_QUANTITY ' ||L_QTY_ALREADY_RSV_LOOP ) ;
301: oe_debug_pub.add( 'RESERVED_QUANTITY2 ' ||L_QTY2_ALREADY_RSV_LOOP ) ;
302: END IF;
303:
304: IF l_qty2_already_rsv_loop = 0 -- INVCONV PAL

Line 301: oe_debug_pub.add( 'RESERVED_QUANTITY2 ' ||L_QTY2_ALREADY_RSV_LOOP ) ;

297: oe_debug_pub.add( 'BEFORE CALLING UNRESERVE_LINE' ) ;
298: END IF;
299: IF l_debug_level > 0 THEN
300: oe_debug_pub.add( 'RESERVED_QUANTITY ' ||L_QTY_ALREADY_RSV_LOOP ) ;
301: oe_debug_pub.add( 'RESERVED_QUANTITY2 ' ||L_QTY2_ALREADY_RSV_LOOP ) ;
302: END IF;
303:
304: IF l_qty2_already_rsv_loop = 0 -- INVCONV PAL
305: THEN

Line 314: oe_debug_pub.add( 'BEFORE CALLING OE_SCHEDULE_UTIL' ) ;

310:
311: -- 4504362
312:
313: IF l_debug_level > 0 THEN
314: oe_debug_pub.add( 'BEFORE CALLING OE_SCHEDULE_UTIL' ) ;
315: END IF;
316: --NULL; -- invconv inserted just for compile need to add qty2
317: OE_SCHEDULE_UTIL.Unreserve_Line( p_line_rec => l_line_tbl(l_reservation_tbl(I).line_index),
318: p_quantity_to_unreserve => l_qty_already_rsv_loop,

Line 324: oe_debug_pub.add( 'AFTER CALLING UNRESERVE_LINE' ) ;

320: x_return_status => l_return_status);
321:
322:
323: IF l_debug_level > 0 THEN
324: oe_debug_pub.add( 'AFTER CALLING UNRESERVE_LINE' ) ;
325: END IF;
326:
327: end if;
328:

Line 332: oe_debug_pub.add( 'I=1' ) ;

328:
329: else
330: if (l_qty_already_rsv_loop >0) then
331: IF l_debug_level > 0 THEN
332: oe_debug_pub.add( 'I=1' ) ;
333: END IF;
334: IF l_debug_level > 0 THEN
335: oe_debug_pub.add( 'BEFORE CALLING UNRESERVE_LINE' ) ;
336: END IF;

Line 335: oe_debug_pub.add( 'BEFORE CALLING UNRESERVE_LINE' ) ;

331: IF l_debug_level > 0 THEN
332: oe_debug_pub.add( 'I=1' ) ;
333: END IF;
334: IF l_debug_level > 0 THEN
335: oe_debug_pub.add( 'BEFORE CALLING UNRESERVE_LINE' ) ;
336: END IF;
337: IF l_debug_level > 0 THEN
338: oe_debug_pub.add( 'RESERVED_QUANTITY ' ||L_QTY_ALREADY_RSV_LOOP ) ;
339: oe_debug_pub.add( 'RESERVED2_QUANTITY ' ||L_QTY2_ALREADY_RSV_LOOP ) ;

Line 338: oe_debug_pub.add( 'RESERVED_QUANTITY ' ||L_QTY_ALREADY_RSV_LOOP ) ;

334: IF l_debug_level > 0 THEN
335: oe_debug_pub.add( 'BEFORE CALLING UNRESERVE_LINE' ) ;
336: END IF;
337: IF l_debug_level > 0 THEN
338: oe_debug_pub.add( 'RESERVED_QUANTITY ' ||L_QTY_ALREADY_RSV_LOOP ) ;
339: oe_debug_pub.add( 'RESERVED2_QUANTITY ' ||L_QTY2_ALREADY_RSV_LOOP ) ;
340: END IF;
341:
342: --4504362

Line 339: oe_debug_pub.add( 'RESERVED2_QUANTITY ' ||L_QTY2_ALREADY_RSV_LOOP ) ;

335: oe_debug_pub.add( 'BEFORE CALLING UNRESERVE_LINE' ) ;
336: END IF;
337: IF l_debug_level > 0 THEN
338: oe_debug_pub.add( 'RESERVED_QUANTITY ' ||L_QTY_ALREADY_RSV_LOOP ) ;
339: oe_debug_pub.add( 'RESERVED2_QUANTITY ' ||L_QTY2_ALREADY_RSV_LOOP ) ;
340: END IF;
341:
342: --4504362
343:

Line 345: oe_debug_pub.add( 'BEFORE CALLING OE_SCHEDULE_UTIL' ) ;

341:
342: --4504362
343:
344: IF l_debug_level > 0 THEN
345: oe_debug_pub.add( 'BEFORE CALLING OE_SCHEDULE_UTIL' ) ;
346: END IF;
347: OE_SCHEDULE_UTIL.Unreserve_Line(p_line_rec =>l_line_tbl(l_reservation_tbl(I).line_index),
348: p_quantity_to_unreserve => l_qty_already_rsv_loop,
349: p_quantity2_to_unreserve =>l_qty2_already_rsv_loop, -- INVCONV

Line 354: oe_debug_pub.add( 'AFTER CALLING UNRESERVE_LINE' ) ;

350: x_return_status => l_return_status);
351:
352:
353: IF l_debug_level > 0 THEN
354: oe_debug_pub.add( 'AFTER CALLING UNRESERVE_LINE' ) ;
355: END IF;
356:
357: end if;
358:

Line 362: oe_debug_pub.add( 'AFTER CHECK' ) ;

358:
359: end if;
360:
361: IF l_debug_level > 0 THEN
362: oe_debug_pub.add( 'AFTER CHECK' ) ;
363: END IF;
364:
365: -- INVCONV - MERGED CALLS FOR OE_LINE_UTIL.Get_Reserved_Quantity and OE_LINE_UTIL.Get_Reserved_Quantity2
366:

Line 384: oe_debug_pub.add( 'L_QTY_ALREADY_RSV_LOOP'||L_QTY_ALREADY_RSV_LOOP ) ;

380: p_line_id => l_line_tbl(l_reservation_tbl(I).line_index).line_id,
381: p_org_id => l_line_tbl(l_reservation_tbl(I).line_index).org_id); */
382:
383: IF l_debug_level > 0 THEN
384: oe_debug_pub.add( 'L_QTY_ALREADY_RSV_LOOP'||L_QTY_ALREADY_RSV_LOOP ) ;
385: END IF;
386: -- INVCONV
387: /*l_qty2_already_rsv_loop := OE_LINE_UTIL.get_reserved_quantity2
388: (p_header_id => OE_HEADER_UTIL.Get_Mtl_Sales_Order_Id

Line 394: oe_debug_pub.add( 'L_QTY2_ALREADY_RSV_LOOP'||L_QTY2_ALREADY_RSV_LOOP ) ;

390: p_line_id => l_line_tbl(l_reservation_tbl(I).line_index).line_id,
391: p_org_id => l_line_tbl(l_reservation_tbl(I).line_index).org_id); */
392:
393: IF l_debug_level > 0 THEN
394: oe_debug_pub.add( 'L_QTY2_ALREADY_RSV_LOOP'||L_QTY2_ALREADY_RSV_LOOP ) ;
395: END IF;
396:
397:
398: l_qty_to_reserve :=

Line 408: oe_debug_pub.add( 'L_QTY_TO_RESERVE'||L_QTY_TO_RESERVE ) ;

404: l_line_tbl(l_reservation_tbl(I).line_index).ordered_quantity2 -
405: NVL(l_qty2_already_rsv_loop,0);
406:
407: IF l_debug_level > 0 THEN
408: oe_debug_pub.add( 'L_QTY_TO_RESERVE'||L_QTY_TO_RESERVE ) ;
409: oe_debug_pub.add( 'L_QTY2_TO_RESERVE'||L_QTY2_TO_RESERVE ) ;
410: END IF;
411:
412:

Line 409: oe_debug_pub.add( 'L_QTY2_TO_RESERVE'||L_QTY2_TO_RESERVE ) ;

405: NVL(l_qty2_already_rsv_loop,0);
406:
407: IF l_debug_level > 0 THEN
408: oe_debug_pub.add( 'L_QTY_TO_RESERVE'||L_QTY_TO_RESERVE ) ;
409: oe_debug_pub.add( 'L_QTY2_TO_RESERVE'||L_QTY2_TO_RESERVE ) ;
410: END IF;
411:
412:
413: IF (l_qty_to_reserve-l_reservation_tbl(I).quantity < 0)

Line 441: oe_debug_pub.add( 'BEFORE CALLING CREATE_RESERVATION' ) ;

437: THEN
438:
439: IF(nvl(l_line_tbl(l_reservation_tbl(I).line_index).shippable_flag, 'N') = 'Y' and l_reservable_type =1) THEN
440: IF l_debug_level > 0 THEN
441: oe_debug_pub.add( 'BEFORE CALLING CREATE_RESERVATION' ) ;
442: END IF;
443: Create_Reservation (
444: p_rsv => mtl_res_rec
445: ,p_rsv_id => l_reservation_id

Line 453: oe_debug_pub.add( 'AFTER CALLING CREATE_RESERVATION' ) ;

449: END IF;
450: END IF;
451:
452: IF l_debug_level > 0 THEN
453: oe_debug_pub.add( 'AFTER CALLING CREATE_RESERVATION' ) ;
454: END IF;
455:
456: IF p_return_status NOT IN (FND_API.G_RET_STS_ERROR)
457: AND l_return_status IN (FND_API.G_RET_STS_ERROR,

Line 466: oe_debug_pub.add( 'UNEXPECTED ERROR IN RESERVE_INVENTORY: '||SQLERRM ) ;

462:
463: EXCEPTION
464: WHEN OTHERS THEN
465: IF l_debug_level > 0 THEN
466: oe_debug_pub.add( 'UNEXPECTED ERROR IN RESERVE_INVENTORY: '||SQLERRM ) ;
467: END IF;
468: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
469: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
470: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Reserve_Inventory');

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

508: l_msg_data VARCHAR2(240);
509: l_return_status VARCHAR2(1);
510:
511: --
512: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
513: --
514: BEGIN
515: --Start of Bug#7564285
516: l_rsv.secondary_reservation_quantity := NULL;

Line 521: oe_debug_pub.add( 'BEFORE CALLING RESERVATIONS API' ) ;

517: l_rsv.secondary_uom_code := NULL;
518: l_rsv.secondary_uom_id := NULL; --End of Bug#7564285
519:
520: IF l_debug_level > 0 THEN
521: oe_debug_pub.add( 'BEFORE CALLING RESERVATIONS API' ) ;
522: END IF;
523:
524: INV_RESERVATION_PUB.Create_Reservation (
525: p_api_version_number => 1.0

Line 543: oe_debug_pub.add( 'QUANTITY RESERVED: ' || TO_CHAR ( L_RSV_QTY ) ) ;

539: );
540:
541: IF l_return_status IN (FND_API.G_RET_STS_SUCCESS) THEN
542: IF l_debug_level > 0 THEN
543: oe_debug_pub.add( 'QUANTITY RESERVED: ' || TO_CHAR ( L_RSV_QTY ) ) ;
544: oe_debug_pub.add( 'QUANTITY2 RESERVED: ' || TO_CHAR ( L_RSV_QTY2 ) ) ;
545: END IF;
546: IF l_debug_level > 0 THEN
547: oe_debug_pub.add( 'RESERVATION ID: ' || TO_CHAR ( L_RSV_ID ) ) ;

Line 544: oe_debug_pub.add( 'QUANTITY2 RESERVED: ' || TO_CHAR ( L_RSV_QTY2 ) ) ;

540:
541: IF l_return_status IN (FND_API.G_RET_STS_SUCCESS) THEN
542: IF l_debug_level > 0 THEN
543: oe_debug_pub.add( 'QUANTITY RESERVED: ' || TO_CHAR ( L_RSV_QTY ) ) ;
544: oe_debug_pub.add( 'QUANTITY2 RESERVED: ' || TO_CHAR ( L_RSV_QTY2 ) ) ;
545: END IF;
546: IF l_debug_level > 0 THEN
547: oe_debug_pub.add( 'RESERVATION ID: ' || TO_CHAR ( L_RSV_ID ) ) ;
548: END IF;

Line 547: oe_debug_pub.add( 'RESERVATION ID: ' || TO_CHAR ( L_RSV_ID ) ) ;

543: oe_debug_pub.add( 'QUANTITY RESERVED: ' || TO_CHAR ( L_RSV_QTY ) ) ;
544: oe_debug_pub.add( 'QUANTITY2 RESERVED: ' || TO_CHAR ( L_RSV_QTY2 ) ) ;
545: END IF;
546: IF l_debug_level > 0 THEN
547: oe_debug_pub.add( 'RESERVATION ID: ' || TO_CHAR ( L_RSV_ID ) ) ;
548: END IF;
549: ELSE
550: IF l_debug_level > 0 THEN
551: oe_debug_pub.add( 'RESERVATION RETURN STATUS: '|| L_RETURN_STATUS || ' IF ERROR EVEN THEN THE IMPORT SHOULD NOT FAIL' ) ;

Line 551: oe_debug_pub.add( 'RESERVATION RETURN STATUS: '|| L_RETURN_STATUS || ' IF ERROR EVEN THEN THE IMPORT SHOULD NOT FAIL' ) ;

547: oe_debug_pub.add( 'RESERVATION ID: ' || TO_CHAR ( L_RSV_ID ) ) ;
548: END IF;
549: ELSE
550: IF l_debug_level > 0 THEN
551: oe_debug_pub.add( 'RESERVATION RETURN STATUS: '|| L_RETURN_STATUS || ' IF ERROR EVEN THEN THE IMPORT SHOULD NOT FAIL' ) ;
552: END IF;
553: fnd_file.put_line(FND_FILE.OUTPUT, 'Not able to reserve quantity for requisition number ' || G_ORIG_SYS_DOCUMENT_REF);
554: IF l_debug_level > 0 THEN
555: oe_debug_pub.add( 'MSG COUNT: '|| L_MSG_COUNT ) ;

Line 555: oe_debug_pub.add( 'MSG COUNT: '|| L_MSG_COUNT ) ;

551: oe_debug_pub.add( 'RESERVATION RETURN STATUS: '|| L_RETURN_STATUS || ' IF ERROR EVEN THEN THE IMPORT SHOULD NOT FAIL' ) ;
552: END IF;
553: fnd_file.put_line(FND_FILE.OUTPUT, 'Not able to reserve quantity for requisition number ' || G_ORIG_SYS_DOCUMENT_REF);
554: IF l_debug_level > 0 THEN
555: oe_debug_pub.add( 'MSG COUNT: '|| L_MSG_COUNT ) ;
556: END IF;
557:
558: IF l_msg_count = 1 THEN
559: OE_Msg_Pub.Add_Text(p_message_text => l_msg_data);

Line 561: oe_debug_pub.add( 'ERROR: '|| L_MSG_DATA ) ;

557:
558: IF l_msg_count = 1 THEN
559: OE_Msg_Pub.Add_Text(p_message_text => l_msg_data);
560: IF l_debug_level > 0 THEN
561: oe_debug_pub.add( 'ERROR: '|| L_MSG_DATA ) ;
562: END IF;
563: ELSE
564: FOR i IN 1..l_msg_count
565: LOOP

Line 574: oe_debug_pub.add( 'ERROR: '|| L_MSG_DATA ) ;

570: p_msg_index_out => l_msg_index);
571:
572: OE_Msg_Pub.Add_Text(p_message_text => l_msg_data);
573: IF l_debug_level > 0 THEN
574: oe_debug_pub.add( 'ERROR: '|| L_MSG_DATA ) ;
575: END IF;
576: END LOOP;
577: END IF;
578: END IF;

Line 587: oe_debug_pub.add( 'UNEXPECTED ERROR IN CREATE_RESERVATION: '||SQLERRM ) ;

583:
584: EXCEPTION
585: WHEN OTHERS THEN
586: IF l_debug_level > 0 THEN
587: oe_debug_pub.add( 'UNEXPECTED ERROR IN CREATE_RESERVATION: '||SQLERRM ) ;
588: END IF;
589: IF l_debug_level > 0 THEN
590: oe_debug_pub.add( 'BUT THE SUCCESS WILL BE RETURNED' ) ;
591: END IF;

Line 590: oe_debug_pub.add( 'BUT THE SUCCESS WILL BE RETURNED' ) ;

586: IF l_debug_level > 0 THEN
587: oe_debug_pub.add( 'UNEXPECTED ERROR IN CREATE_RESERVATION: '||SQLERRM ) ;
588: END IF;
589: IF l_debug_level > 0 THEN
590: oe_debug_pub.add( 'BUT THE SUCCESS WILL BE RETURNED' ) ;
591: END IF;
592: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
593: p_return_status := FND_API.G_RET_STS_SUCCESS;
594: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Create_Reservation');

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

620: l_msg_count NUMBER;
621: l_msg_data VARCHAR2(240);
622: l_return_status VARCHAR2(1);
623: --
624: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
625: --
626: BEGIN
627:
628: IF l_debug_level > 0 THEN

Line 629: oe_debug_pub.add( 'BEFORE CALLING DELETE RESERVATIONS API' ) ;

625: --
626: BEGIN
627:
628: IF l_debug_level > 0 THEN
629: oe_debug_pub.add( 'BEFORE CALLING DELETE RESERVATIONS API' ) ;
630: END IF;
631:
632: INV_RESERVATION_PUB.Delete_Reservation (
633: p_api_version_number => 1.0

Line 644: oe_debug_pub.add( 'RESERVATION DELETED' ) ;

640: );
641:
642: IF l_return_status IN (FND_API.G_RET_STS_SUCCESS) THEN
643: IF l_debug_level > 0 THEN
644: oe_debug_pub.add( 'RESERVATION DELETED' ) ;
645: END IF;
646: ELSE
647: IF l_debug_level > 0 THEN
648: oe_debug_pub.add( 'RESERVATION RETURN STATUS: '|| L_RETURN_STATUS || ' IF ERROR EVEN THEN THE IMPORT SHOULD NOT FAIL' ) ;

Line 648: oe_debug_pub.add( 'RESERVATION RETURN STATUS: '|| L_RETURN_STATUS || ' IF ERROR EVEN THEN THE IMPORT SHOULD NOT FAIL' ) ;

644: oe_debug_pub.add( 'RESERVATION DELETED' ) ;
645: END IF;
646: ELSE
647: IF l_debug_level > 0 THEN
648: oe_debug_pub.add( 'RESERVATION RETURN STATUS: '|| L_RETURN_STATUS || ' IF ERROR EVEN THEN THE IMPORT SHOULD NOT FAIL' ) ;
649: END IF;
650: fnd_file.put_line(FND_FILE.OUTPUT, 'Not able to cancel quantity for requisition number ' || G_ORIG_SYS_DOCUMENT_REF);
651: IF l_debug_level > 0 THEN
652: oe_debug_pub.add( 'MSG COUNT: '|| L_MSG_COUNT ) ;

Line 652: oe_debug_pub.add( 'MSG COUNT: '|| L_MSG_COUNT ) ;

648: oe_debug_pub.add( 'RESERVATION RETURN STATUS: '|| L_RETURN_STATUS || ' IF ERROR EVEN THEN THE IMPORT SHOULD NOT FAIL' ) ;
649: END IF;
650: fnd_file.put_line(FND_FILE.OUTPUT, 'Not able to cancel quantity for requisition number ' || G_ORIG_SYS_DOCUMENT_REF);
651: IF l_debug_level > 0 THEN
652: oe_debug_pub.add( 'MSG COUNT: '|| L_MSG_COUNT ) ;
653: END IF;
654:
655: IF l_msg_count = 1 THEN
656: OE_Msg_Pub.Add_Text(p_message_text => l_msg_data);

Line 658: oe_debug_pub.add( 'ERROR: '|| L_MSG_DATA ) ;

654:
655: IF l_msg_count = 1 THEN
656: OE_Msg_Pub.Add_Text(p_message_text => l_msg_data);
657: IF l_debug_level > 0 THEN
658: oe_debug_pub.add( 'ERROR: '|| L_MSG_DATA ) ;
659: END IF;
660: ELSE
661: FOR i IN 1..l_msg_count
662: LOOP

Line 671: oe_debug_pub.add( 'ERROR: '|| L_MSG_DATA ) ;

667: p_msg_index_out => l_msg_index);
668:
669: OE_Msg_Pub.Add_Text(p_message_text => l_msg_data);
670: IF l_debug_level > 0 THEN
671: oe_debug_pub.add( 'ERROR: '|| L_MSG_DATA ) ;
672: END IF;
673: END LOOP;
674: END IF;
675: END IF;

Line 684: oe_debug_pub.add( 'UNEXPECTED ERROR IN DELETE_RESERVATION: '||SQLERRM ) ;

680:
681: EXCEPTION
682: WHEN OTHERS THEN
683: IF l_debug_level > 0 THEN
684: oe_debug_pub.add( 'UNEXPECTED ERROR IN DELETE_RESERVATION: '||SQLERRM ) ;
685: END IF;
686: IF l_debug_level > 0 THEN
687: oe_debug_pub.add( 'BUT THE SUCCESS WILL BE RETURNED' ) ;
688: END IF;

Line 687: oe_debug_pub.add( 'BUT THE SUCCESS WILL BE RETURNED' ) ;

683: IF l_debug_level > 0 THEN
684: oe_debug_pub.add( 'UNEXPECTED ERROR IN DELETE_RESERVATION: '||SQLERRM ) ;
685: END IF;
686: IF l_debug_level > 0 THEN
687: oe_debug_pub.add( 'BUT THE SUCCESS WILL BE RETURNED' ) ;
688: END IF;
689: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
690: p_return_status := FND_API.G_RET_STS_SUCCESS;
691: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Delete_Reservation');