[Home] [Help]
130: SAVEPOINT process_backorders;
131: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
132:
133:
134: GMI_RESERVATION_UTIL.println('Start Of OPM BackOrder Routine');
135:
136: /* Try and retrieve the original transaction. To do this we need */
137: /* to determine a number of keys so that we can locate the correct */
138: /* row in ic_tran_pnd. If any of these retrievals fails there is no */
137: /* to determine a number of keys so that we can locate the correct */
138: /* row in ic_tran_pnd. If any of these retrievals fails there is no */
139: /* point in continuing, so let the exception raised take over. */
140:
141: GMI_reservation_Util.PrintLn('Find OPM Item ID');
142:
143: SELECT iim.item_id INTO l_item_id
144: FROM ic_item_mst iim,
145: mtl_system_items msi
179: /* With the above retrievals successfully done we can */
180: /* try to locate the transaction we need. Again, if this fails */
181: /* we cannot proceed so let the exception raised take over. */
182:
183: GMI_reservation_Util.PrintLn('Find OPM Original Transaction');
184:
185: /* Could Select More than one Line With Matching Keys */
186: /* We do not care which matching record we select */
187: /* since we are ordering by trans_id, therefore */
186: /* We do not care which matching record we select */
187: /* since we are ordering by trans_id, therefore */
188: /* Exit after First Select. */
189:
190: GMI_RESERVATION_UTIL.println('LINE_ID => ' || p_shipping_line.source_line_id);
191: GMI_RESERVATION_UTIL.println('ITEM_ID => ' || l_item_id);
192: GMI_RESERVATION_UTIL.println('LOT_ID => ' || l_lot_id);
193: GMI_RESERVATION_UTIL.println('Location => ' || l_location);
194:
187: /* since we are ordering by trans_id, therefore */
188: /* Exit after First Select. */
189:
190: GMI_RESERVATION_UTIL.println('LINE_ID => ' || p_shipping_line.source_line_id);
191: GMI_RESERVATION_UTIL.println('ITEM_ID => ' || l_item_id);
192: GMI_RESERVATION_UTIL.println('LOT_ID => ' || l_lot_id);
193: GMI_RESERVATION_UTIL.println('Location => ' || l_location);
194:
195: OPEN get_opm_transaction_c;
188: /* Exit after First Select. */
189:
190: GMI_RESERVATION_UTIL.println('LINE_ID => ' || p_shipping_line.source_line_id);
191: GMI_RESERVATION_UTIL.println('ITEM_ID => ' || l_item_id);
192: GMI_RESERVATION_UTIL.println('LOT_ID => ' || l_lot_id);
193: GMI_RESERVATION_UTIL.println('Location => ' || l_location);
194:
195: OPEN get_opm_transaction_c;
196: LOOP
189:
190: GMI_RESERVATION_UTIL.println('LINE_ID => ' || p_shipping_line.source_line_id);
191: GMI_RESERVATION_UTIL.println('ITEM_ID => ' || l_item_id);
192: GMI_RESERVATION_UTIL.println('LOT_ID => ' || l_lot_id);
193: GMI_RESERVATION_UTIL.println('Location => ' || l_location);
194:
195: OPEN get_opm_transaction_c;
196: LOOP
197: FETCH get_opm_transaction_c INTO l_old_transaction_rec.trans_id;
198: IF get_opm_transaction_c%NOTFOUND THEN
199: /* B1504749, 21-Nov-2000 odaboval : added CLOSE cursor here. */
200: --CLOSE get_opm_transaction_c;
201:
202: GMI_RESERVATION_UTIL.println('OPM Transaction Not Found');
203: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
204: END IF;
205: EXIT; /* Exit after First Select */
206: END LOOP;
206: END LOOP;
207:
208: --CLOSE get_opm_transaction_c;
209:
210: GMI_RESERVATION_UTIL.println('TRANS_ID => ' || l_old_transaction_rec.trans_id);
211: GMI_RESERVATION_UTIL.println('Cycle_count => ' || p_shipping_line.cycle_count_quantity);
212:
213: IF get_opm_transaction_c%NOTFOUND THEN
214: CLOSE get_opm_transaction_c;
207:
208: --CLOSE get_opm_transaction_c;
209:
210: GMI_RESERVATION_UTIL.println('TRANS_ID => ' || l_old_transaction_rec.trans_id);
211: GMI_RESERVATION_UTIL.println('Cycle_count => ' || p_shipping_line.cycle_count_quantity);
212:
213: IF get_opm_transaction_c%NOTFOUND THEN
214: CLOSE get_opm_transaction_c;
215: GMI_RESERVATION_UTIL.println('l_return_status => ' || x_return_status);
211: GMI_RESERVATION_UTIL.println('Cycle_count => ' || p_shipping_line.cycle_count_quantity);
212:
213: IF get_opm_transaction_c%NOTFOUND THEN
214: CLOSE get_opm_transaction_c;
215: GMI_RESERVATION_UTIL.println('l_return_status => ' || x_return_status);
216: ELSE
217: CLOSE get_opm_transaction_c;
218: /* original hwahdani IF ( l_lot_id = 0 and l_location is NULL) THEN */
219: /* BUG#:1495550 check if l_location is not NULL */
218: /* original hwahdani IF ( l_lot_id = 0 and l_location is NULL) THEN */
219: /* BUG#:1495550 check if l_location is not NULL */
220: IF ( l_lot_id = 0 and l_location = FND_PROFILE.VALUE('IC$DEFAULT_LOCT'))
221: THEN
222: GMI_reservation_Util.PrintLn('Default Transaction Is Not LOT/LOC controlled');
223: GMI_reservation_Util.PrintLn('Action is => Revert staged_ind to zero');
224: /* BUG 1577035 BEGIN Set staged_ind = 0 in backorder scenario
225: ============================================================= */
226: /* BUG 1575873 the qty becomes 0 when back order is created, the
219: /* BUG#:1495550 check if l_location is not NULL */
220: IF ( l_lot_id = 0 and l_location = FND_PROFILE.VALUE('IC$DEFAULT_LOCT'))
221: THEN
222: GMI_reservation_Util.PrintLn('Default Transaction Is Not LOT/LOC controlled');
223: GMI_reservation_Util.PrintLn('Action is => Revert staged_ind to zero');
224: /* BUG 1577035 BEGIN Set staged_ind = 0 in backorder scenario
225: ============================================================= */
226: /* BUG 1575873 the qty becomes 0 when back order is created, the
227: default qty should be the cycle count qty */
251: -- PK Bug 3527599 No need to lock IC_LOCT_INV when deleting pending txn.
252:
253: IF ABS(l_old_transaction_rec.trans_qty) = p_shipping_line.cycle_count_quantity
254: THEN
255: GMI_RESERVATION_UTIL.println('BackOrder Full Staged Qty');
256:
257: /* Delete Original Tranaction */
258:
259: GMI_RESERVATION_UTIL.println('Delete Original Transaction');
255: GMI_RESERVATION_UTIL.println('BackOrder Full Staged Qty');
256:
257: /* Delete Original Tranaction */
258:
259: GMI_RESERVATION_UTIL.println('Delete Original Transaction');
260:
261: GMI_TRANS_ENGINE_PUB.DELETE_PENDING_TRANSACTION
262: ( 1
263: , FND_API.G_FALSE
271: );
272:
273: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
274: THEN
275: GMI_RESERVATION_UTIL.PrintLn('Error returned by Delete_Pending_Transaction');
276: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
277: END IF;
278:
279: /* I am Assuming That There Will Always Be A Default Transaction. */
288: OPEN default_transaction_c;
289: FETCH default_transaction_c INTO l_trans_id, l_staged_ind;
290: IF default_transaction_c%NOTFOUND THEN
291: Close default_transaction_c;
292: GMI_RESERVATION_UTIL.println('Default Transaction Not Found');
293: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
294: END IF;
295: Close default_transaction_c;
296:
300:
301: IF GMI_TRAN_PND_DB_PVT.FETCH_IC_TRAN_PND
302: (l_old_transaction_rec, l_old_transaction_rec )
303: THEN
304: GMI_RESERVATION_UTIL.println('Found Transaction ID => '|| l_old_transaction_rec.trans_id);
305:
306: l_new_transaction_rec := l_old_transaction_rec;
307: l_new_transaction_rec.trans_qty := -1 * (p_shipping_line.cycle_count_quantity + ABS(l_old_transaction_rec.trans_qty));
308: l_new_transaction_rec.trans_qty2 := -1 * (p_shipping_line.cycle_count_quantity2 + ABS(l_old_transaction_rec.trans_qty2));
322: );
323:
324: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
325: THEN
326: GMI_RESERVATION_UTIL.println('Error returned by Update_Pending_Transaction');
327: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
328: END IF;
329: END IF;
330:
329: END IF;
330:
331: ELSE
332:
333: GMI_RESERVATION_UTIL.println('Start Of OPM Partial BackOrder Routine');
334:
335: /* We are creating a partial back order. In a similar way */
336: /* to above, reverse out the existing allocations and then */
337: /* post a new one with amounts reduced by the back order */
338: /* quantity. */
339:
340:
341:
342: GMI_RESERVATION_UTIL.println('Backout Original Staged Qty ' || l_old_transaction_rec.trans_qty);
343:
344: GMI_TRANS_ENGINE_PUB.DELETE_PENDING_TRANSACTION
345: ( 1
346: , FND_API.G_FALSE
354: );
355:
356: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
357: THEN
358: GMI_RESERVATION_UTIL.println('Error returned by Delete_Pending_Transaction');
359: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
360: END IF;
361:
362: /* Reduce the existing transaction quantity by the amount */
373: l_reduction_factor := NULL;
374: ELSE
375: l_reduction_factor := ABS(l_new_transaction_rec.trans_qty2)/ ABS(l_new_transaction_rec.trans_qty);
376: END IF;
377: GMI_RESERVATION_UTIL.println('Reduction Factor => ' || l_reduction_factor);
378: l_new_transaction_rec.trans_qty := -1 * (ABS(l_new_transaction_rec.trans_qty) - p_shipping_line.cycle_count_quantity);
379: l_new_transaction_rec.trans_qty2 := -1 * (ABS(l_new_transaction_rec.trans_qty)) * l_reduction_factor;
380: /* Bug 1503309 End of New l_reduction_factor Logic */
381:
381:
382: /* NC Added line_detail_id Bug#1675561 */
383: l_new_transaction_rec.line_detail_id := p_shipping_line.delivery_detail_id;
384:
385: GMI_RESERVATION_UTIL.println('line_detail_id ' || p_shipping_line.delivery_detail_id);
386: GMI_RESERVATION_UTIL.println('Back Qty ' || p_shipping_line.cycle_count_quantity);
387: GMI_RESERVATION_UTIL.println('Back Qty2 ' || p_shipping_line.cycle_count_quantity2);
388: GMI_RESERVATION_UTIL.println('Write New Staged Qty ' || l_new_transaction_rec.trans_qty);
389: GMI_RESERVATION_UTIL.println('Write New Staged Qty2 ' || l_new_transaction_rec.trans_qty2);
382: /* NC Added line_detail_id Bug#1675561 */
383: l_new_transaction_rec.line_detail_id := p_shipping_line.delivery_detail_id;
384:
385: GMI_RESERVATION_UTIL.println('line_detail_id ' || p_shipping_line.delivery_detail_id);
386: GMI_RESERVATION_UTIL.println('Back Qty ' || p_shipping_line.cycle_count_quantity);
387: GMI_RESERVATION_UTIL.println('Back Qty2 ' || p_shipping_line.cycle_count_quantity2);
388: GMI_RESERVATION_UTIL.println('Write New Staged Qty ' || l_new_transaction_rec.trans_qty);
389: GMI_RESERVATION_UTIL.println('Write New Staged Qty2 ' || l_new_transaction_rec.trans_qty2);
390:
383: l_new_transaction_rec.line_detail_id := p_shipping_line.delivery_detail_id;
384:
385: GMI_RESERVATION_UTIL.println('line_detail_id ' || p_shipping_line.delivery_detail_id);
386: GMI_RESERVATION_UTIL.println('Back Qty ' || p_shipping_line.cycle_count_quantity);
387: GMI_RESERVATION_UTIL.println('Back Qty2 ' || p_shipping_line.cycle_count_quantity2);
388: GMI_RESERVATION_UTIL.println('Write New Staged Qty ' || l_new_transaction_rec.trans_qty);
389: GMI_RESERVATION_UTIL.println('Write New Staged Qty2 ' || l_new_transaction_rec.trans_qty2);
390:
391: GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION
384:
385: GMI_RESERVATION_UTIL.println('line_detail_id ' || p_shipping_line.delivery_detail_id);
386: GMI_RESERVATION_UTIL.println('Back Qty ' || p_shipping_line.cycle_count_quantity);
387: GMI_RESERVATION_UTIL.println('Back Qty2 ' || p_shipping_line.cycle_count_quantity2);
388: GMI_RESERVATION_UTIL.println('Write New Staged Qty ' || l_new_transaction_rec.trans_qty);
389: GMI_RESERVATION_UTIL.println('Write New Staged Qty2 ' || l_new_transaction_rec.trans_qty2);
390:
391: GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION
392: ( 1
385: GMI_RESERVATION_UTIL.println('line_detail_id ' || p_shipping_line.delivery_detail_id);
386: GMI_RESERVATION_UTIL.println('Back Qty ' || p_shipping_line.cycle_count_quantity);
387: GMI_RESERVATION_UTIL.println('Back Qty2 ' || p_shipping_line.cycle_count_quantity2);
388: GMI_RESERVATION_UTIL.println('Write New Staged Qty ' || l_new_transaction_rec.trans_qty);
389: GMI_RESERVATION_UTIL.println('Write New Staged Qty2 ' || l_new_transaction_rec.trans_qty2);
390:
391: GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION
392: ( 1
393: , FND_API.G_FALSE
401: );
402:
403: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
404: THEN
405: GMI_RESERVATION_UTIL.println('Error returned by Create_Pending_Transaction');
406: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
407: END IF;
408:
409: /* We now need to sort out the transaction for the default lot. */
432: THEN
433: CLOSE default_transaction_c;
434: /* We need to create the default, unstaged row */
435:
436: gmi_reservation_util.println('Creating Default Row Transaction For Back Ordered Qty');
437:
438: l_new_transaction_rec.trans_id := NULL;
439: l_new_transaction_rec.trans_qty := - p_shipping_line.cycle_count_quantity;
440: l_new_transaction_rec.trans_qty2:= - p_shipping_line.cycle_count_quantity2;
460: THEN
461: /* B1504749, 21-Nov-2000 odaboval : removed CLOSE cursor here. */
462: /* CLOSE default_transaction_c; */
463:
464: GMI_RESERVATION_UTIL.println('Error returned by Create_Pending_Transaction');
465: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
466: END IF;
467:
468: ELSE
495: THEN
496: /* B1504749, 21-Nov-2000 odaboval : removed CLOSE cursor here. */
497: /* CLOSE default_transaction_c; */
498:
499: GMI_RESERVATION_UTIL.println('Error returned by Update_Pending_Transaction');
500: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
501: END IF;
502: END IF;
503: END IF;
503: END IF;
504:
505: END IF;
506: ELSE
507: GMI_RESERVATION_UTIL.println('could not locate the original transaction');
508: /* We could not locate the original transaction. */
509: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
510: END IF;
511:
557: BEGIN
558:
559: /* Standard Start OF API savepoint */
560:
561: GMI_RESERVATION_UTIL.println('deleting trans ');
562: SAVEPOINT process_backorders;
563: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
564:
565: l_transaction_rec.trans_id := p_trans_id;
565: l_transaction_rec.trans_id := p_trans_id;
566: IF GMI_TRAN_PND_DB_PVT.FETCH_IC_TRAN_PND
567: (l_transaction_rec, l_transaction_rec )
568: THEN
569: GMI_reservation_Util.PrintLn('Find OPM Item ID');
570:
571: l_item_id := l_transaction_rec.item_id;
572: l_location := l_transaction_rec.location;
573: GMI_RESERVATION_UTIL.println('LINE_ID => ' || l_transaction_rec.line_id);
569: GMI_reservation_Util.PrintLn('Find OPM Item ID');
570:
571: l_item_id := l_transaction_rec.item_id;
572: l_location := l_transaction_rec.location;
573: GMI_RESERVATION_UTIL.println('LINE_ID => ' || l_transaction_rec.line_id);
574: GMI_RESERVATION_UTIL.println('ITEM_ID => ' || l_item_id);
575: GMI_RESERVATION_UTIL.println('LOT_ID => ' || l_lot_id);
576: GMI_RESERVATION_UTIL.println('Location => ' || l_location);
577:
570:
571: l_item_id := l_transaction_rec.item_id;
572: l_location := l_transaction_rec.location;
573: GMI_RESERVATION_UTIL.println('LINE_ID => ' || l_transaction_rec.line_id);
574: GMI_RESERVATION_UTIL.println('ITEM_ID => ' || l_item_id);
575: GMI_RESERVATION_UTIL.println('LOT_ID => ' || l_lot_id);
576: GMI_RESERVATION_UTIL.println('Location => ' || l_location);
577:
578: -- PK Bug 3527599 No need to lock IC_LOCT_INV when deleting pending txn.
571: l_item_id := l_transaction_rec.item_id;
572: l_location := l_transaction_rec.location;
573: GMI_RESERVATION_UTIL.println('LINE_ID => ' || l_transaction_rec.line_id);
574: GMI_RESERVATION_UTIL.println('ITEM_ID => ' || l_item_id);
575: GMI_RESERVATION_UTIL.println('LOT_ID => ' || l_lot_id);
576: GMI_RESERVATION_UTIL.println('Location => ' || l_location);
577:
578: -- PK Bug 3527599 No need to lock IC_LOCT_INV when deleting pending txn.
579:
572: l_location := l_transaction_rec.location;
573: GMI_RESERVATION_UTIL.println('LINE_ID => ' || l_transaction_rec.line_id);
574: GMI_RESERVATION_UTIL.println('ITEM_ID => ' || l_item_id);
575: GMI_RESERVATION_UTIL.println('LOT_ID => ' || l_lot_id);
576: GMI_RESERVATION_UTIL.println('Location => ' || l_location);
577:
578: -- PK Bug 3527599 No need to lock IC_LOCT_INV when deleting pending txn.
579:
580: GMI_TRANS_ENGINE_PUB.DELETE_PENDING_TRANSACTION
590: );
591:
592: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
593: THEN
594: GMI_RESERVATION_UTIL.PrintLn('Error returned by Delete_Pending_Transaction');
595: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
596: END IF;
597:
598: END IF;
598: END IF;
599: /* hwahdani BUG#:1495550 get proper value of default location from profile */
600: l_location := FND_PROFILE.VALUE('IC$DEFAULT_LOCT');
601:
602: GMI_RESERVATION_UTIL.find_default_lot
603: ( x_return_status => x_return_status,
604: x_msg_count => l_msg_count,
605: x_msg_data => l_msg_data,
606: x_reservation_id => l_trans_id,
607: p_line_id => l_transaction_rec.line_id
608: );
609:
610: IF nvl(l_trans_id,0) = 0 THEN
611: GMI_RESERVATION_UTIL.println('Default Transaction Not Found');
612: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
613: /* create a default lot, in case we are backordering */
614: l_transaction_rec.location := l_location;
615: l_transaction_rec.lot_id := 0;
629: , x_msg_data => l_msg_data
630: );
631: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
632: THEN
633: GMI_RESERVATION_UTIL.PrintLn('Error returned by creating pending default lot');
634: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
635: END IF;
636: l_trans_id := l_transaction_row.trans_id;
637: GMI_RESERVATION_UTIL.println('created Default Transaction trans_id '||l_trans_id);
633: GMI_RESERVATION_UTIL.PrintLn('Error returned by creating pending default lot');
634: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
635: END IF;
636: l_trans_id := l_transaction_row.trans_id;
637: GMI_RESERVATION_UTIL.println('created Default Transaction trans_id '||l_trans_id);
638: END IF;
639:
640: l_transaction_rec.trans_id := l_trans_id;
641:
642: IF GMI_TRAN_PND_DB_PVT.FETCH_IC_TRAN_PND
643: (l_transaction_rec, l_transaction_rec )
644: THEN
645: /* balance the default lot */
646: GMI_RESERVATION_UTIL.balance_default_lot
647: ( p_ic_default_rec => l_transaction_rec
648: , p_opm_item_id => l_transaction_rec.item_id
649: , x_return_status => x_return_status
650: , x_msg_count => l_msg_count
651: , x_msg_data => l_msg_data
652: );
653: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
654: THEN
655: GMI_RESERVATION_UTIL.PrintLn('Error returned by balancing default lot');
656: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
657: END IF;
658: END IF;
659:
814: from fnd_oracle_userid
815: where read_only_flag = 'U';
816:
817:
818: gmi_reservation_util.println('Value of schema name is '||l_schema);
819: -- HW 3385851. Added this fix for Pushkar
820: BEGIN
821: l_allowneginv := nvl(fnd_profile.value('IC$ALLOWNEGINV'),0);
822: EXCEPTION
820: BEGIN
821: l_allowneginv := nvl(fnd_profile.value('IC$ALLOWNEGINV'),0);
822: EXCEPTION
823: WHEN OTHERS THEN
824: gmi_reservation_util.println('Error in reading PROFILE: Allow Negative Inventory');
825: l_allowneginv := 0;
826: END;
827: -- end of 3385851
828: GMI_RESERVATION_UTIL.println('Start Of OPM Inventory Interface Routine');
824: gmi_reservation_util.println('Error in reading PROFILE: Allow Negative Inventory');
825: l_allowneginv := 0;
826: END;
827: -- end of 3385851
828: GMI_RESERVATION_UTIL.println('Start Of OPM Inventory Interface Routine');
829: GMI_RESERVATION_UTIL.println('delivery_detail_id '||p_shipping_line.delivery_detail_id);
830:
831: /* check to see if WSH G is installed, the file WSHUSAIB.pls is new introduced in G
832: so check the object exsits or not would do*/
825: l_allowneginv := 0;
826: END;
827: -- end of 3385851
828: GMI_RESERVATION_UTIL.println('Start Of OPM Inventory Interface Routine');
829: GMI_RESERVATION_UTIL.println('delivery_detail_id '||p_shipping_line.delivery_detail_id);
830:
831: /* check to see if WSH G is installed, the file WSHUSAIB.pls is new introduced in G
832: so check the object exsits or not would do*/
833: -- HW BUG 3434884- Added parameter l_schema parameter
833: -- HW BUG 3434884- Added parameter l_schema parameter
834: Open check_wsh(l_schema);
835: Fetch check_wsh INTO l_dummy;
836: IF check_wsh%FOUND THEN
837: GMI_RESERVATION_UTIL.println('calling GMI_UPDATE_SHIPMENT_TXN_NEW');
838: GMI_UPDATE_SHIPMENT_TXN_NEW
839: ( p_shipping_line => p_shipping_line
840: , p_actual_ship_date => p_actual_ship_date
841: , x_return_status => x_return_status
841: , x_return_status => x_return_status
842: , x_msg_count => x_msg_count
843: , x_msg_data => x_msg_data
844: );
845: GMI_RESERVATION_UTIL.println('Finished calling GMI_Shipping_Util.GMI_UPDATE _SHIPMENT_TXN');
846: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
847: THEN
848: GMI_RESERVATION_UTIL.println('Error Could Not Complete');
849: Close check_wsh; /* B2886561 close cursor before exception */
844: );
845: GMI_RESERVATION_UTIL.println('Finished calling GMI_Shipping_Util.GMI_UPDATE _SHIPMENT_TXN');
846: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
847: THEN
848: GMI_RESERVATION_UTIL.println('Error Could Not Complete');
849: Close check_wsh; /* B2886561 close cursor before exception */
850: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
851: END IF;
852: IF check_wsh%ISOPEN THEN
879: FROM ic_loct_mst
880: WHERE inventory_location_id = p_shipping_line.locator_id;
881: END IF;
882:
883: GMI_RESERVATION_UTIL.println('LOT_NUMBER => ' || p_shipping_line.lot_number);
884: GMI_RESERVATION_UTIL.println('SUBLOT_NUMBER => ' || p_shipping_line.sublot_number);
885:
886: IF p_shipping_line.lot_number IS NULL
887: THEN
880: WHERE inventory_location_id = p_shipping_line.locator_id;
881: END IF;
882:
883: GMI_RESERVATION_UTIL.println('LOT_NUMBER => ' || p_shipping_line.lot_number);
884: GMI_RESERVATION_UTIL.println('SUBLOT_NUMBER => ' || p_shipping_line.sublot_number);
885:
886: IF p_shipping_line.lot_number IS NULL
887: THEN
888: l_lot_id := 0;
905: /* With the above retrievals successfully done we can */
906: /* try to locate the transaction we need. Again, if this fails */
907: /* we cannot proceed so let the exception raised take over. */
908:
909: GMI_RESERVATION_UTIL.println('OPM Trying To Retrieve the Correct old Transaction');
910: GMI_RESERVATION_UTIL.println('LINE_ID => ' || p_shipping_line.source_line_id);
911: GMI_RESERVATION_UTIL.println('ITEM_ID => ' || l_item_id);
912: GMI_RESERVATION_UTIL.println('LOT_ID => ' || l_lot_id);
913: GMI_RESERVATION_UTIL.println('Location => ' || l_location);
906: /* try to locate the transaction we need. Again, if this fails */
907: /* we cannot proceed so let the exception raised take over. */
908:
909: GMI_RESERVATION_UTIL.println('OPM Trying To Retrieve the Correct old Transaction');
910: GMI_RESERVATION_UTIL.println('LINE_ID => ' || p_shipping_line.source_line_id);
911: GMI_RESERVATION_UTIL.println('ITEM_ID => ' || l_item_id);
912: GMI_RESERVATION_UTIL.println('LOT_ID => ' || l_lot_id);
913: GMI_RESERVATION_UTIL.println('Location => ' || l_location);
914:
907: /* we cannot proceed so let the exception raised take over. */
908:
909: GMI_RESERVATION_UTIL.println('OPM Trying To Retrieve the Correct old Transaction');
910: GMI_RESERVATION_UTIL.println('LINE_ID => ' || p_shipping_line.source_line_id);
911: GMI_RESERVATION_UTIL.println('ITEM_ID => ' || l_item_id);
912: GMI_RESERVATION_UTIL.println('LOT_ID => ' || l_lot_id);
913: GMI_RESERVATION_UTIL.println('Location => ' || l_location);
914:
915: /* NC - Added the following code. Bug#1675561 and Bug#1794681 */
908:
909: GMI_RESERVATION_UTIL.println('OPM Trying To Retrieve the Correct old Transaction');
910: GMI_RESERVATION_UTIL.println('LINE_ID => ' || p_shipping_line.source_line_id);
911: GMI_RESERVATION_UTIL.println('ITEM_ID => ' || l_item_id);
912: GMI_RESERVATION_UTIL.println('LOT_ID => ' || l_lot_id);
913: GMI_RESERVATION_UTIL.println('Location => ' || l_location);
914:
915: /* NC - Added the following code. Bug#1675561 and Bug#1794681 */
916: Open get_whse;
909: GMI_RESERVATION_UTIL.println('OPM Trying To Retrieve the Correct old Transaction');
910: GMI_RESERVATION_UTIL.println('LINE_ID => ' || p_shipping_line.source_line_id);
911: GMI_RESERVATION_UTIL.println('ITEM_ID => ' || l_item_id);
912: GMI_RESERVATION_UTIL.println('LOT_ID => ' || l_lot_id);
913: GMI_RESERVATION_UTIL.println('Location => ' || l_location);
914:
915: /* NC - Added the following code. Bug#1675561 and Bug#1794681 */
916: Open get_whse;
917: Fetch get_whse into l_whse_ctl;
936: LOOP
937: FETCH get_opm_transaction_c2 INTO l_old_transaction_rec.trans_id;
938: IF get_opm_transaction_c2%NOTFOUND THEN
939: Close get_opm_transaction_c2;
940: GMI_RESERVATION_UTIL.println('OPM Transaction Not Found: get_opm_transaction_c2');
941: /* Begin B2547509 */
942: /* Check if this transaction is deleted by chance */
943: OPEN get_opm_transaction_cnt;
944: FETCH get_opm_transaction_cnt into l_cnt_trans;
943: OPEN get_opm_transaction_cnt;
944: FETCH get_opm_transaction_cnt into l_cnt_trans;
945: CLOSE get_opm_transaction_cnt;
946: IF (l_cnt_trans > 1) THEN
947: GMI_RESERVATION_UTIL.println('Multiple deleted transactions found - Manual updates are necessary');
948: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
949: ELSIF (l_cnt_trans = 1) THEN
950: /* update the transaction's delete mark to 0 and proceed */
951: UPDATE ic_tran_pnd
954: AND line_id = p_shipping_line.source_line_id
955: AND line_detail_id = p_shipping_line.delivery_detail_id
956: AND delete_mark = 1
957: returning trans_id into l_old_transaction_rec.trans_id;
958: GMI_RESERVATION_UTIL.println('Undeleted transaction '||to_char(l_old_transaction_rec.trans_id));
959: ELSE
960: GMI_RESERVATION_UTIL.println('Transaction for the line_id/line_detail_id not found or');
961: GMI_RESERVATION_UTIL.println(' the shipped quantity and transaction quantity do not match');
962: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
956: AND delete_mark = 1
957: returning trans_id into l_old_transaction_rec.trans_id;
958: GMI_RESERVATION_UTIL.println('Undeleted transaction '||to_char(l_old_transaction_rec.trans_id));
959: ELSE
960: GMI_RESERVATION_UTIL.println('Transaction for the line_id/line_detail_id not found or');
961: GMI_RESERVATION_UTIL.println(' the shipped quantity and transaction quantity do not match');
962: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
963: END IF;
964: /* End B2547509 */
957: returning trans_id into l_old_transaction_rec.trans_id;
958: GMI_RESERVATION_UTIL.println('Undeleted transaction '||to_char(l_old_transaction_rec.trans_id));
959: ELSE
960: GMI_RESERVATION_UTIL.println('Transaction for the line_id/line_detail_id not found or');
961: GMI_RESERVATION_UTIL.println(' the shipped quantity and transaction quantity do not match');
962: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
963: END IF;
964: /* End B2547509 */
965: END IF;
971: CLOSE get_opm_transaction_c2;
972: END IF;
973:
974: /*ELSE
975: GMI_RESERVATION_UTIL.println('OPM Transaction Not Found');
976: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;*/
977: END IF;
978: END IF;
979:
977: END IF;
978: END IF;
979:
980:
981: GMI_RESERVATION_UTIL.println('Retrieve OPM Transaction => ' ||l_old_transaction_rec.trans_id );
982: IF GMI_TRAN_PND_DB_PVT.FETCH_IC_TRAN_PND
983: (l_old_transaction_rec, l_old_transaction_rec )
984: THEN
985:
982: IF GMI_TRAN_PND_DB_PVT.FETCH_IC_TRAN_PND
983: (l_old_transaction_rec, l_old_transaction_rec )
984: THEN
985:
986: l_src_qty := GMI_RESERVATION_UTIL.Get_Opm_converted_qty
987: (
988: p_apps_item_id => p_shipping_line.inventory_item_id,
989: p_organization_id => p_shipping_line.organization_id,
990: p_apps_from_uom => p_shipping_line.src_requested_quantity_uom,
992: p_original_qty => p_shipping_line.src_requested_quantity
993: ) ;
994: l_ship_qty_above := p_shipping_line.ship_tolerance_above * abs(l_src_qty) /100;
995: l_ship_qty_below := p_shipping_line.ship_tolerance_below * abs(l_src_qty) /100;
996: GMI_RESERVATION_UTIL.println('shipping tolerance above %' ||p_shipping_line.ship_tolerance_above);
997: GMI_RESERVATION_UTIL.println('shipping tolerance below %' ||p_shipping_line.ship_tolerance_below);
998: GMI_RESERVATION_UTIL.println('shipping tolerance above qty' ||l_ship_qty_above);
999: GMI_RESERVATION_UTIL.println('shipping tolerance below qty' ||l_ship_qty_below);
1000:
993: ) ;
994: l_ship_qty_above := p_shipping_line.ship_tolerance_above * abs(l_src_qty) /100;
995: l_ship_qty_below := p_shipping_line.ship_tolerance_below * abs(l_src_qty) /100;
996: GMI_RESERVATION_UTIL.println('shipping tolerance above %' ||p_shipping_line.ship_tolerance_above);
997: GMI_RESERVATION_UTIL.println('shipping tolerance below %' ||p_shipping_line.ship_tolerance_below);
998: GMI_RESERVATION_UTIL.println('shipping tolerance above qty' ||l_ship_qty_above);
999: GMI_RESERVATION_UTIL.println('shipping tolerance below qty' ||l_ship_qty_below);
1000:
1001: /* We have the transaction we need. See if we are shipping within */
994: l_ship_qty_above := p_shipping_line.ship_tolerance_above * abs(l_src_qty) /100;
995: l_ship_qty_below := p_shipping_line.ship_tolerance_below * abs(l_src_qty) /100;
996: GMI_RESERVATION_UTIL.println('shipping tolerance above %' ||p_shipping_line.ship_tolerance_above);
997: GMI_RESERVATION_UTIL.println('shipping tolerance below %' ||p_shipping_line.ship_tolerance_below);
998: GMI_RESERVATION_UTIL.println('shipping tolerance above qty' ||l_ship_qty_above);
999: GMI_RESERVATION_UTIL.println('shipping tolerance below qty' ||l_ship_qty_below);
1000:
1001: /* We have the transaction we need. See if we are shipping within */
1002: /* the permitted tolerance. If we are, then we reverse out the */
995: l_ship_qty_below := p_shipping_line.ship_tolerance_below * abs(l_src_qty) /100;
996: GMI_RESERVATION_UTIL.println('shipping tolerance above %' ||p_shipping_line.ship_tolerance_above);
997: GMI_RESERVATION_UTIL.println('shipping tolerance below %' ||p_shipping_line.ship_tolerance_below);
998: GMI_RESERVATION_UTIL.println('shipping tolerance above qty' ||l_ship_qty_above);
999: GMI_RESERVATION_UTIL.println('shipping tolerance below qty' ||l_ship_qty_below);
1000:
1001: /* We have the transaction we need. See if we are shipping within */
1002: /* the permitted tolerance. If we are, then we reverse out the */
1003: /* existing transaction, insert a new transaction for the */
1009:
1010: -- PK Bug 3527599 Moving Lock_Inventory call from here to just before
1011: -- UPDATE_PENDING_TO_COMPLETED call.
1012:
1013: GMI_RESERVATION_UTIL.println('Correct Transaction Found');
1014: PRINT_DEBUG (l_old_transaction_rec,'FETCH RECORD');
1015:
1016: /* Note That OPM Trans Qtys Are Negative and that the shipped qtys */
1017: /* Are Positive. Therefore For Checks Convert the Trans_qty to a positive */
1016: /* Note That OPM Trans Qtys Are Negative and that the shipped qtys */
1017: /* Are Positive. Therefore For Checks Convert the Trans_qty to a positive */
1018: /* Value Using ABS() rather than ( -1 * variable). */
1019:
1020: GMI_RESERVATION_UTIL.println('Shipped Qty => ' || p_shipping_line.shipped_quantity);
1021: GMI_RESERVATION_UTIL.println('Transaction Qty => ' || ABS(l_old_transaction_rec.trans_qty));
1022:
1023:
1024: PRINT_DEBUG (l_old_transaction_rec,'Original Transaction');
1017: /* Are Positive. Therefore For Checks Convert the Trans_qty to a positive */
1018: /* Value Using ABS() rather than ( -1 * variable). */
1019:
1020: GMI_RESERVATION_UTIL.println('Shipped Qty => ' || p_shipping_line.shipped_quantity);
1021: GMI_RESERVATION_UTIL.println('Transaction Qty => ' || ABS(l_old_transaction_rec.trans_qty));
1022:
1023:
1024: PRINT_DEBUG (l_old_transaction_rec,'Original Transaction');
1025:
1025:
1026: IF p_shipping_line.shipped_quantity = ABS(l_src_qty)
1027: THEN
1028:
1029: GMI_RESERVATION_UTIL.println('Ship Qty = Trans Qty');
1030: GMI_RESERVATION_UTIL.println('Completing existing transaction');
1031: PRINT_DEBUG (l_old_transaction_rec,'COMPLETE RECORD');
1032:
1033: /* Need To Update The Actual Shipment Date */
1026: IF p_shipping_line.shipped_quantity = ABS(l_src_qty)
1027: THEN
1028:
1029: GMI_RESERVATION_UTIL.println('Ship Qty = Trans Qty');
1030: GMI_RESERVATION_UTIL.println('Completing existing transaction');
1031: PRINT_DEBUG (l_old_transaction_rec,'COMPLETE RECORD');
1032:
1033: /* Need To Update The Actual Shipment Date */
1034:
1039: l_old_transaction_rec.whse_code);
1040: /* Bug 2775197 */
1041: IF l_allowneginv <> 1 THEN
1042: IF INVENTORY_GOING_NEG(l_old_transaction_rec) THEN
1043: GMI_RESERVATION_UTIL.println('Profile GMI: Allow Negative Inventory = '||to_char(l_allowneginv));
1044: GMI_RESERVATION_UTIL.println('WARNING:Inventory going negative. Transaction not completed for Trans ID '||
1045: to_char(l_old_transaction_rec.trans_id));
1046: rollback to process_shipments;
1047: RAISE INVENTORY_NEG_WARNING;
1040: /* Bug 2775197 */
1041: IF l_allowneginv <> 1 THEN
1042: IF INVENTORY_GOING_NEG(l_old_transaction_rec) THEN
1043: GMI_RESERVATION_UTIL.println('Profile GMI: Allow Negative Inventory = '||to_char(l_allowneginv));
1044: GMI_RESERVATION_UTIL.println('WARNING:Inventory going negative. Transaction not completed for Trans ID '||
1045: to_char(l_old_transaction_rec.trans_id));
1046: rollback to process_shipments;
1047: RAISE INVENTORY_NEG_WARNING;
1048: END IF;
1050:
1051: /* NC Added line_detail_id. Bug#1675561 */
1052:
1053: -- PK Bug 3527599 Moving Lock_Inventory call here from above.
1054: GMI_reservation_Util.PrintLn('Attempt to Lock Inventory');
1055:
1056: GMI_Locks.Lock_Inventory
1057: (
1058: i_item_id => l_old_transaction_rec.item_id
1063: , o_lock_status => l_lock_status
1064: );
1065:
1066: IF (l_lock_status = FALSE) THEN
1067: GMI_reservation_Util.PrintLn('Lock_Inventory Failed');
1068: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
1069: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Locks.Lock_Inventory');
1070: FND_MESSAGE.Set_Token('WHERE', 'GMI_UPDATE_SHIPMENT_TXN');
1071: FND_MSG_PUB.Add;
1085: );
1086:
1087: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
1088: THEN
1089: GMI_RESERVATION_UTIL.println('Error Could Not Complete');
1090: GMI_RESERVATION_UTIL.println('Inv Eng Msg:'||x_msg_data);
1091: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1092: END IF;
1093:
1086:
1087: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
1088: THEN
1089: GMI_RESERVATION_UTIL.println('Error Could Not Complete');
1090: GMI_RESERVATION_UTIL.println('Inv Eng Msg:'||x_msg_data);
1091: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1092: END IF;
1093:
1094: ELSIF p_shipping_line.shipped_quantity <= ABS(l_src_qty)
1096: AND p_shipping_line.shipped_quantity >= ABS(l_src_qty)
1097: - l_ship_qty_below
1098: THEN
1099:
1100: GMI_RESERVATION_UTIL.println('Shipping Within Tolerance');
1101:
1102: GMI_RESERVATION_UTIL.println('Delete Original Transaction');
1103: PRINT_DEBUG (l_old_transaction_rec, 'DELETE RECORD');
1104:
1098: THEN
1099:
1100: GMI_RESERVATION_UTIL.println('Shipping Within Tolerance');
1101:
1102: GMI_RESERVATION_UTIL.println('Delete Original Transaction');
1103: PRINT_DEBUG (l_old_transaction_rec, 'DELETE RECORD');
1104:
1105: GMI_TRANS_ENGINE_PUB.DELETE_PENDING_TRANSACTION
1106: ( 1
1115: );
1116:
1117: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
1118: THEN
1119: GMI_RESERVATION_UTIL.println('Error returned by Delete_Pending_Transaction');
1120: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1121: END IF;
1122:
1123: l_new_transaction_rec := l_old_transaction_rec;
1128: /* NC Added line_detail_id. Bug1675561 */
1129: l_new_transaction_rec.line_detail_id := p_shipping_line.delivery_detail_id;
1130:
1131:
1132: GMI_RESERVATION_UTIL.println('Write New Transaction');
1133: PRINT_DEBUG (l_new_transaction_rec,'CREATE NEW');
1134:
1135: GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION
1136: ( 1
1145: );
1146:
1147: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
1148: THEN
1149: GMI_RESERVATION_UTIL.println('Error returned by Create_Pending_Transaction');
1150: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1151: END IF;
1152:
1153: l_new_transaction_rec.trans_id := l_new_transaction_row.trans_id;
1161: l_new_transaction_rec.whse_code);
1162: /* Bug 2775197 */
1163: IF l_allowneginv <> 1 THEN
1164: IF INVENTORY_GOING_NEG(l_new_transaction_rec) THEN
1165: GMI_RESERVATION_UTIL.println('Profile GMI: Allow Negative Inventory = '||to_char(l_allowneginv));
1166: GMI_RESERVATION_UTIL.println('WARNING:Inventory going negative. Transaction not completed for Trans ID '||
1167: to_char(l_new_transaction_rec.trans_id));
1168: rollback to process_shipments;
1169: RAISE INVENTORY_NEG_WARNING;
1162: /* Bug 2775197 */
1163: IF l_allowneginv <> 1 THEN
1164: IF INVENTORY_GOING_NEG(l_new_transaction_rec) THEN
1165: GMI_RESERVATION_UTIL.println('Profile GMI: Allow Negative Inventory = '||to_char(l_allowneginv));
1166: GMI_RESERVATION_UTIL.println('WARNING:Inventory going negative. Transaction not completed for Trans ID '||
1167: to_char(l_new_transaction_rec.trans_id));
1168: rollback to process_shipments;
1169: RAISE INVENTORY_NEG_WARNING;
1170: END IF;
1169: RAISE INVENTORY_NEG_WARNING;
1170: END IF;
1171: END IF;
1172:
1173: GMI_RESERVATION_UTIL.println('Update New Transaction => Completed');
1174:
1175: PRINT_DEBUG (l_new_transaction_rec,'UPDATE TO COMPLETE');
1176:
1177: GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TO_COMPLETED
1187: );
1188:
1189: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
1190: THEN
1191: GMI_RESERVATION_UTIL.println('Error Could Not Complete');
1192: GMI_RESERVATION_UTIL.println('Inv Eng Msg:'||x_msg_data);
1193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1194: END IF;
1195: GMI_RESERVATION_UTIL.find_default_lot
1188:
1189: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
1190: THEN
1191: GMI_RESERVATION_UTIL.println('Error Could Not Complete');
1192: GMI_RESERVATION_UTIL.println('Inv Eng Msg:'||x_msg_data);
1193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1194: END IF;
1195: GMI_RESERVATION_UTIL.find_default_lot
1196: ( x_return_status => x_return_status,
1191: GMI_RESERVATION_UTIL.println('Error Could Not Complete');
1192: GMI_RESERVATION_UTIL.println('Inv Eng Msg:'||x_msg_data);
1193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1194: END IF;
1195: GMI_RESERVATION_UTIL.find_default_lot
1196: ( x_return_status => x_return_status,
1197: x_msg_count => x_msg_count,
1198: x_msg_data => x_msg_data,
1199: x_reservation_id => l_trans_id,
1206: THEN
1207: l_new_transaction_rec.trans_qty := 0;
1208: l_new_transaction_rec.trans_qty2 := 0;
1209:
1210: GMI_RESERVATION_UTIL.println('shipping within tolerance ');
1211: PRINT_DEBUG (l_new_transaction_rec,' 0 out Default Transaction');
1212:
1213: GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION
1214: ( 1
1221: , x_msg_count
1222: , x_msg_data
1223: );
1224: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1225: GMI_RESERVATION_UTIL.println('Error returned by Update_Pending_Transaction');
1226: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1227: END IF;
1228: END IF;
1229: END IF;
1229: END IF;
1230: ELSIF p_shipping_line.shipped_quantity >
1231: ABS(l_src_qty) + l_ship_qty_above
1232: THEN
1233: GMI_RESERVATION_UTIL.println('Shipping More Than Tolerance');
1234: /* Complain. We are not allowed to overship */
1235: NULL;
1236: ELSE
1237: /* the split of inv for lot controled item is done in ship confirm */
1236: ELSE
1237: /* the split of inv for lot controled item is done in ship confirm */
1238: /* so this portion of the code is only applicable for non-controled items or over pick */
1239: IF l_lot_ctl = 0 and l_loct_ctl * l_whse_ctl = 0 THEN
1240: GMI_RESERVATION_UTIL.println('Creating Partial Shipment');
1241:
1242: l_new_transaction_rec := l_old_transaction_rec;
1243:
1244: GMI_RESERVATION_UTIL.println('Delete Original Transaction');
1240: GMI_RESERVATION_UTIL.println('Creating Partial Shipment');
1241:
1242: l_new_transaction_rec := l_old_transaction_rec;
1243:
1244: GMI_RESERVATION_UTIL.println('Delete Original Transaction');
1245: PRINT_DEBUG (l_old_transaction_rec,'Delete Original');
1246:
1247: GMI_TRANS_ENGINE_PUB.DELETE_PENDING_TRANSACTION
1248: ( 1
1257: );
1258:
1259: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
1260: THEN
1261: GMI_RESERVATION_UTIL.println('Error returned by Delete_Pending_Transaction');
1262: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1263: END IF;
1264:
1265: /* Create a new transaction for the shipped quantity */
1274: /* NC - Added line_detail_id. Bug1675561 */
1275: l_new_transaction_rec.line_detail_id := p_shipping_line.delivery_detail_id;
1276:
1277:
1278: GMI_RESERVATION_UTIL.println('Create New Transaction For Shipped Qty');
1279: PRINT_DEBUG (l_new_transaction_rec,'Create NEW');
1280:
1281: GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION
1282: ( 1
1291: );
1292:
1293: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
1294: THEN
1295: GMI_RESERVATION_UTIL.println('Error returned by Create_Pending_Transaction');
1296: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1297: END IF;
1298:
1299: l_new_transaction_rec.trans_id := l_new_transaction_row.trans_id;
1305: l_new_transaction_rec.whse_code);
1306: /* Bug 2775197 */
1307: IF l_allowneginv <> 1 THEN
1308: IF INVENTORY_GOING_NEG(l_new_transaction_rec) THEN
1309: GMI_RESERVATION_UTIL.println('Profile GMI: Allow Negative Inventory = '||to_char(l_allowneginv));
1310: GMI_RESERVATION_UTIL.println('WARNING:Inventory going negative. Transaction not completed for Trans ID '||
1311: to_char(l_new_transaction_rec.trans_id));
1312: rollback to process_shipments;
1313: RAISE INVENTORY_NEG_WARNING;
1306: /* Bug 2775197 */
1307: IF l_allowneginv <> 1 THEN
1308: IF INVENTORY_GOING_NEG(l_new_transaction_rec) THEN
1309: GMI_RESERVATION_UTIL.println('Profile GMI: Allow Negative Inventory = '||to_char(l_allowneginv));
1310: GMI_RESERVATION_UTIL.println('WARNING:Inventory going negative. Transaction not completed for Trans ID '||
1311: to_char(l_new_transaction_rec.trans_id));
1312: rollback to process_shipments;
1313: RAISE INVENTORY_NEG_WARNING;
1314: END IF;
1313: RAISE INVENTORY_NEG_WARNING;
1314: END IF;
1315: END IF;
1316:
1317: GMI_RESERVATION_UTIL.println('Update New Transaction to Completed');
1318: PRINT_DEBUG (l_new_transaction_rec,'UPDATE NEW');
1319:
1320: GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TO_COMPLETED
1321: ( 1
1330: );
1331:
1332: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
1333: THEN
1334: GMI_RESERVATION_UTIL.println('Error : Cannot Complete the transaction.');
1335: GMI_RESERVATION_UTIL.println('Inv Eng Msg:'||x_msg_data);
1336: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1337: END IF;
1338:
1331:
1332: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
1333: THEN
1334: GMI_RESERVATION_UTIL.println('Error : Cannot Complete the transaction.');
1335: GMI_RESERVATION_UTIL.println('Inv Eng Msg:'||x_msg_data);
1336: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1337: END IF;
1338:
1339: GMI_RESERVATION_UTIL.println('Handle Split');
1335: GMI_RESERVATION_UTIL.println('Inv Eng Msg:'||x_msg_data);
1336: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1337: END IF;
1338:
1339: GMI_RESERVATION_UTIL.println('Handle Split');
1340: GMI_RESERVATION_UTIL.println('OLD QTY = > ' || l_old_transaction_rec.trans_qty);
1341: GMI_RESERVATION_UTIL.println('NEW QTY = > ' || l_new_transaction_rec.trans_qty);
1342: GMI_RESERVATION_UTIL.println('BACK QTY = > ' || p_shipping_line.cycle_count_quantity);
1343:
1336: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1337: END IF;
1338:
1339: GMI_RESERVATION_UTIL.println('Handle Split');
1340: GMI_RESERVATION_UTIL.println('OLD QTY = > ' || l_old_transaction_rec.trans_qty);
1341: GMI_RESERVATION_UTIL.println('NEW QTY = > ' || l_new_transaction_rec.trans_qty);
1342: GMI_RESERVATION_UTIL.println('BACK QTY = > ' || p_shipping_line.cycle_count_quantity);
1343:
1344: /* We now need to sort out the transaction for the default lot. */
1337: END IF;
1338:
1339: GMI_RESERVATION_UTIL.println('Handle Split');
1340: GMI_RESERVATION_UTIL.println('OLD QTY = > ' || l_old_transaction_rec.trans_qty);
1341: GMI_RESERVATION_UTIL.println('NEW QTY = > ' || l_new_transaction_rec.trans_qty);
1342: GMI_RESERVATION_UTIL.println('BACK QTY = > ' || p_shipping_line.cycle_count_quantity);
1343:
1344: /* We now need to sort out the transaction for the default lot. */
1345: /* There are two cases to consider and the cursor will retrieve */
1338:
1339: GMI_RESERVATION_UTIL.println('Handle Split');
1340: GMI_RESERVATION_UTIL.println('OLD QTY = > ' || l_old_transaction_rec.trans_qty);
1341: GMI_RESERVATION_UTIL.println('NEW QTY = > ' || l_new_transaction_rec.trans_qty);
1342: GMI_RESERVATION_UTIL.println('BACK QTY = > ' || p_shipping_line.cycle_count_quantity);
1343:
1344: /* We now need to sort out the transaction for the default lot. */
1345: /* There are two cases to consider and the cursor will retrieve */
1346: /* the characteristics of the row we need (if it exists) */
1364: l_delta_trans_qty2 := l_delta_trans_qty2 * -1;
1365: END IF;
1366:
1367: /* End Logic To Get Correct TXN Qty's */
1368: GMI_RESERVATION_UTIL.println('delta Qty = > ' || l_delta_trans_qty1);
1369: GMI_RESERVATION_UTIL.println('delta Qty2 = > ' || l_delta_trans_qty2);
1370:
1371: /* get the defualt trans */
1372: OPEN default_transaction_c;
1365: END IF;
1366:
1367: /* End Logic To Get Correct TXN Qty's */
1368: GMI_RESERVATION_UTIL.println('delta Qty = > ' || l_delta_trans_qty1);
1369: GMI_RESERVATION_UTIL.println('delta Qty2 = > ' || l_delta_trans_qty2);
1370:
1371: /* get the defualt trans */
1372: OPEN default_transaction_c;
1373: FETCH default_transaction_c INTO l_trans_id;
1375: THEN
1376: /* B1504749, 21-Nov-2000 odaboval : added CLOSE cursor here. */
1377: CLOSE default_transaction_c;
1378:
1379: GMI_RESERVATION_UTIL.println('Create New Transaction For Staged');
1380: /* We need to create the default, staged row */
1381:
1382: l_new_transaction_rec.trans_id := NULL;
1383: l_new_transaction_rec.trans_qty := l_delta_trans_qty1;
1404: );
1405:
1406: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
1407: THEN
1408: GMI_RESERVATION_UTIL.println('Error returned by Create_Pending_Transaction');
1409: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1410: END IF;
1411:
1412: GMI_RESERVATION_UTIL.println('created trans_id='||l_new_transaction_row.trans_id);
1408: GMI_RESERVATION_UTIL.println('Error returned by Create_Pending_Transaction');
1409: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1410: END IF;
1411:
1412: GMI_RESERVATION_UTIL.println('created trans_id='||l_new_transaction_row.trans_id);
1413: GMI_RESERVATION_UTIL.println('and its staged_ind='||l_new_transaction_row.staged_ind);
1414:
1415: ELSE
1416: /* B1504749, 21-Nov-2000 odaboval : added CLOSE cursor here. */
1409: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1410: END IF;
1411:
1412: GMI_RESERVATION_UTIL.println('created trans_id='||l_new_transaction_row.trans_id);
1413: GMI_RESERVATION_UTIL.println('and its staged_ind='||l_new_transaction_row.staged_ind);
1414:
1415: ELSE
1416: /* B1504749, 21-Nov-2000 odaboval : added CLOSE cursor here. */
1417: CLOSE default_transaction_c;
1425: l_delta_trans_qty1;
1426: l_old_transaction_rec.trans_qty2:= l_old_transaction_rec.trans_qty2 +
1427: l_delta_trans_qty2;
1428:
1429: GMI_RESERVATION_UTIL.println('Update Default For Staged');
1430:
1431: GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION
1432: ( 1
1433: , FND_API.G_FALSE
1441: );
1442:
1443: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
1444: THEN
1445: GMI_RESERVATION_UTIL.println('Error returned by Update_Pending_Transaction');
1446: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1447: END IF;
1448: END IF;
1449: END IF;
1451: /* over picking but shipped less than picked */
1452: /* keep in mind that the inv split is done in ship confirm */
1453: /* do 2 things here, complete the inv with the shipped qty
1454: then balance the default */
1455: GMI_RESERVATION_UTIL.println('overpicked, but shipping < picked ');
1456: l_new_transaction_rec := l_old_transaction_rec;
1457: l_new_transaction_rec.trans_qty2:= -1 * p_shipping_line.shipped_quantity2;
1458: l_new_transaction_rec.trans_qty := -1 * p_shipping_line.shipped_quantity;
1459: /* l_new_transaction_rec.trans_date := p_actual_ship_date; */
1463: l_new_transaction_rec.whse_code);
1464: /* Bug 2775197 */
1465: IF l_allowneginv <> 1 THEN
1466: IF INVENTORY_GOING_NEG(l_new_transaction_rec) THEN
1467: GMI_RESERVATION_UTIL.println('Profile GMI: Allow Negative Inventory = '||to_char(l_allowneginv));
1468: GMI_RESERVATION_UTIL.println('WARNING:Inventory going negative. Transaction not completed for Trans ID '||
1469: to_char(l_new_transaction_rec.trans_id));
1470: rollback to process_shipments;
1471: RAISE INVENTORY_NEG_WARNING;
1464: /* Bug 2775197 */
1465: IF l_allowneginv <> 1 THEN
1466: IF INVENTORY_GOING_NEG(l_new_transaction_rec) THEN
1467: GMI_RESERVATION_UTIL.println('Profile GMI: Allow Negative Inventory = '||to_char(l_allowneginv));
1468: GMI_RESERVATION_UTIL.println('WARNING:Inventory going negative. Transaction not completed for Trans ID '||
1469: to_char(l_new_transaction_rec.trans_id));
1470: rollback to process_shipments;
1471: RAISE INVENTORY_NEG_WARNING;
1472: END IF;
1485: );
1486:
1487: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
1488: THEN
1489: GMI_RESERVATION_UTIL.println('Error : Cannot Complete the transaction.');
1490: GMI_RESERVATION_UTIL.println('Inv Eng Msg:'||x_msg_data);
1491: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1492: END IF;
1493: /* find the default transaction */
1486:
1487: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
1488: THEN
1489: GMI_RESERVATION_UTIL.println('Error : Cannot Complete the transaction.');
1490: GMI_RESERVATION_UTIL.println('Inv Eng Msg:'||x_msg_data);
1491: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1492: END IF;
1493: /* find the default transaction */
1494: OPEN default_transaction_c;
1497: l_new_transaction_rec.trans_id := l_trans_id;
1498: IF GMI_TRAN_PND_DB_PVT.FETCH_IC_TRAN_PND
1499: (l_new_transaction_rec, l_new_transaction_rec )
1500: THEN
1501: GMI_RESERVATION_UTIL.println('balancing default lot.');
1502: GMI_RESERVATION_UTIL.balance_default_lot
1503: ( p_ic_default_rec => l_new_transaction_rec
1504: , p_opm_item_id => l_new_transaction_rec.item_id
1505: , x_return_status => x_return_status
1498: IF GMI_TRAN_PND_DB_PVT.FETCH_IC_TRAN_PND
1499: (l_new_transaction_rec, l_new_transaction_rec )
1500: THEN
1501: GMI_RESERVATION_UTIL.println('balancing default lot.');
1502: GMI_RESERVATION_UTIL.balance_default_lot
1503: ( p_ic_default_rec => l_new_transaction_rec
1504: , p_opm_item_id => l_new_transaction_rec.item_id
1505: , x_return_status => x_return_status
1506: , x_msg_count => x_msg_count
1507: , x_msg_data => x_msg_data
1508: );
1509: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
1510: THEN
1511: GMI_RESERVATION_UTIL.PrintLn('Error returned by balancing default lot');
1512: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1513: END IF;
1514: END IF;
1515: END IF;
1517: /* B1504749, 21-Nov-2000 odaboval : removed CLOSE cursor here. */
1518: /* CLOSE default_transaction_c; */
1519: END IF;
1520: ELSE
1521: GMI_RESERVATION_UTIL.println('could not locate the original transaction');
1522: /* We could not locate the original transaction. */
1523: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1524: END IF;
1525:
1530:
1531: WHEN NO_DATA_FOUND THEN
1532: rollback to process_shipments;
1533: x_return_status := FND_API.G_RET_STS_ERROR;
1534: GMI_RESERVATION_UTIL.Println('Raised No Data Found');
1535:
1536: WHEN OTHERS
1537: THEN
1538: rollback to process_shipments;
1536: WHEN OTHERS
1537: THEN
1538: rollback to process_shipments;
1539: x_return_status := FND_API.G_RET_STS_ERROR;
1540: GMI_RESERVATION_UTIL.Println('Raised When Others');
1541:
1542: /* B1504749, 21-Nov-2000 odaboval : removed CLOSE cursor here. */
1543: /* CLOSE default_transaction_c; */
1544: END GMI_UPDATE_SHIPMENT_TXN;
1609:
1610: SAVEPOINT process_shipments;
1611: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1612:
1613: GMI_RESERVATION_UTIL.println('Start Of OPM Inventory Interface Routine');
1614: GMI_RESERVATION_UTIL.println('delivery_detail_id '||p_shipping_line.delivery_detail_id);
1615: GMI_RESERVATION_UTIL.println('shipped_qty '||p_shipping_line.shipped_quantity);
1616:
1617: OPEN get_opm_transaction_c;
1610: SAVEPOINT process_shipments;
1611: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1612:
1613: GMI_RESERVATION_UTIL.println('Start Of OPM Inventory Interface Routine');
1614: GMI_RESERVATION_UTIL.println('delivery_detail_id '||p_shipping_line.delivery_detail_id);
1615: GMI_RESERVATION_UTIL.println('shipped_qty '||p_shipping_line.shipped_quantity);
1616:
1617: OPEN get_opm_transaction_c;
1618: FETCH get_opm_transaction_c INTO l_old_transaction_rec.trans_id;
1611: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1612:
1613: GMI_RESERVATION_UTIL.println('Start Of OPM Inventory Interface Routine');
1614: GMI_RESERVATION_UTIL.println('delivery_detail_id '||p_shipping_line.delivery_detail_id);
1615: GMI_RESERVATION_UTIL.println('shipped_qty '||p_shipping_line.shipped_quantity);
1616:
1617: OPEN get_opm_transaction_c;
1618: FETCH get_opm_transaction_c INTO l_old_transaction_rec.trans_id;
1619: IF get_opm_transaction_c%NOTFOUND THEN
1617: OPEN get_opm_transaction_c;
1618: FETCH get_opm_transaction_c INTO l_old_transaction_rec.trans_id;
1619: IF get_opm_transaction_c%NOTFOUND THEN
1620: Close get_opm_transaction_c;
1621: GMI_RESERVATION_UTIL.println('OPM Transaction Not Found: get_opm_transaction_c');
1622: /* Begin B2547509 */
1623: /* Check if this transaction is deleted by chance */
1624: OPEN get_opm_transaction_cnt;
1625: FETCH get_opm_transaction_cnt into l_cnt_trans;
1624: OPEN get_opm_transaction_cnt;
1625: FETCH get_opm_transaction_cnt into l_cnt_trans;
1626: CLOSE get_opm_transaction_cnt;
1627: IF (l_cnt_trans > 1) THEN
1628: GMI_RESERVATION_UTIL.println('Multiple deleted transactions found - Manual updates are necessary');
1629: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1630: ELSIF (l_cnt_trans = 1) THEN
1631: /* update the transaction's delete mark to 0 and proceed */
1632: UPDATE ic_tran_pnd
1635: AND line_id = p_shipping_line.source_line_id
1636: AND line_detail_id = p_shipping_line.delivery_detail_id
1637: AND delete_mark = 1
1638: returning trans_id into l_old_transaction_rec.trans_id;
1639: GMI_RESERVATION_UTIL.println('Undeleted transaction '||to_char(l_old_transaction_rec.trans_id));
1640: ELSE
1641: GMI_RESERVATION_UTIL.println('Transaction for the line_id/line_detail_id not found or');
1642: GMI_RESERVATION_UTIL.println(' the shipped quantity and transaction quantity do not match');
1643: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1637: AND delete_mark = 1
1638: returning trans_id into l_old_transaction_rec.trans_id;
1639: GMI_RESERVATION_UTIL.println('Undeleted transaction '||to_char(l_old_transaction_rec.trans_id));
1640: ELSE
1641: GMI_RESERVATION_UTIL.println('Transaction for the line_id/line_detail_id not found or');
1642: GMI_RESERVATION_UTIL.println(' the shipped quantity and transaction quantity do not match');
1643: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1644: END IF;
1645: /* End B2547509 */
1638: returning trans_id into l_old_transaction_rec.trans_id;
1639: GMI_RESERVATION_UTIL.println('Undeleted transaction '||to_char(l_old_transaction_rec.trans_id));
1640: ELSE
1641: GMI_RESERVATION_UTIL.println('Transaction for the line_id/line_detail_id not found or');
1642: GMI_RESERVATION_UTIL.println(' the shipped quantity and transaction quantity do not match');
1643: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1644: END IF;
1645: /* End B2547509 */
1646: END IF;
1648: IF get_opm_transaction_c%ISOPEN THEN
1649: CLOSE get_opm_transaction_c;
1650: END IF;
1651:
1652: GMI_RESERVATION_UTIL.println('Retrieve OPM Transaction => ' ||l_old_transaction_rec.trans_id );
1653: IF GMI_TRAN_PND_DB_PVT.FETCH_IC_TRAN_PND
1654: (l_old_transaction_rec, l_old_transaction_rec )
1655: THEN
1656: -- PK Bug 3527599 Moving Lock_Inventory call from here to just before
1655: THEN
1656: -- PK Bug 3527599 Moving Lock_Inventory call from here to just before
1657: -- UPDATE_PENDING_TO_COMPLETED call.
1658:
1659: GMI_RESERVATION_UTIL.println('Correct Transaction Found');
1660:
1661: GMI_RESERVATION_UTIL.println('Shipped Qty => ' || p_shipping_line.shipped_quantity);
1662: GMI_RESERVATION_UTIL.println('Transaction Qty => ' || ABS(l_old_transaction_rec.trans_qty));
1663: GMI_RESERVATION_UTIL.println('Completing existing transaction');
1657: -- UPDATE_PENDING_TO_COMPLETED call.
1658:
1659: GMI_RESERVATION_UTIL.println('Correct Transaction Found');
1660:
1661: GMI_RESERVATION_UTIL.println('Shipped Qty => ' || p_shipping_line.shipped_quantity);
1662: GMI_RESERVATION_UTIL.println('Transaction Qty => ' || ABS(l_old_transaction_rec.trans_qty));
1663: GMI_RESERVATION_UTIL.println('Completing existing transaction');
1664:
1665: l_new_transaction_rec := l_old_transaction_rec;
1658:
1659: GMI_RESERVATION_UTIL.println('Correct Transaction Found');
1660:
1661: GMI_RESERVATION_UTIL.println('Shipped Qty => ' || p_shipping_line.shipped_quantity);
1662: GMI_RESERVATION_UTIL.println('Transaction Qty => ' || ABS(l_old_transaction_rec.trans_qty));
1663: GMI_RESERVATION_UTIL.println('Completing existing transaction');
1664:
1665: l_new_transaction_rec := l_old_transaction_rec;
1666: l_new_transaction_rec.trans_qty2:= -1 * p_shipping_line.shipped_quantity2;
1659: GMI_RESERVATION_UTIL.println('Correct Transaction Found');
1660:
1661: GMI_RESERVATION_UTIL.println('Shipped Qty => ' || p_shipping_line.shipped_quantity);
1662: GMI_RESERVATION_UTIL.println('Transaction Qty => ' || ABS(l_old_transaction_rec.trans_qty));
1663: GMI_RESERVATION_UTIL.println('Completing existing transaction');
1664:
1665: l_new_transaction_rec := l_old_transaction_rec;
1666: l_new_transaction_rec.trans_qty2:= -1 * p_shipping_line.shipped_quantity2;
1667: l_new_transaction_rec.trans_qty := -1 * p_shipping_line.shipped_quantity;
1675: BEGIN
1676: l_allowneginv := nvl(fnd_profile.value('IC$ALLOWNEGINV'),0);
1677: EXCEPTION
1678: WHEN OTHERS THEN
1679: gmi_reservation_util.println('Error in reading PROFILE: Allow Negative Inventory');
1680: l_allowneginv := 0;
1681: END;
1682: -- end of 3385851
1683: IF l_allowneginv <> 1 THEN
1681: END;
1682: -- end of 3385851
1683: IF l_allowneginv <> 1 THEN
1684: IF INVENTORY_GOING_NEG(l_new_transaction_rec) THEN
1685: GMI_RESERVATION_UTIL.println('Profile GMI: Allow Negative Inventory = '||to_char(l_allowneginv));
1686: GMI_RESERVATION_UTIL.println('WARNING:Inventory going negative. Transaction not completed for Trans ID '||
1687: to_char(l_new_transaction_rec.trans_id));
1688: rollback to process_shipments;
1689: RAISE INVENTORY_NEG_WARNING;
1682: -- end of 3385851
1683: IF l_allowneginv <> 1 THEN
1684: IF INVENTORY_GOING_NEG(l_new_transaction_rec) THEN
1685: GMI_RESERVATION_UTIL.println('Profile GMI: Allow Negative Inventory = '||to_char(l_allowneginv));
1686: GMI_RESERVATION_UTIL.println('WARNING:Inventory going negative. Transaction not completed for Trans ID '||
1687: to_char(l_new_transaction_rec.trans_id));
1688: rollback to process_shipments;
1689: RAISE INVENTORY_NEG_WARNING;
1690: END IF;
1690: END IF;
1691: END IF;
1692:
1693: -- PK Bug 3527599 Moving Lock_Inventory call here from above.
1694: GMI_reservation_Util.PrintLn('Attempt to Lock Inventory');
1695: GMI_Locks.Lock_Inventory
1696: (
1697: i_item_id => l_old_transaction_rec.item_id
1698: , i_whse_code => l_old_transaction_rec.whse_code
1702: , o_lock_status => l_lock_status
1703: );
1704:
1705: IF (l_lock_status = FALSE) THEN
1706: GMI_reservation_Util.PrintLn('Lock_Inventory Failed');
1707: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
1708: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Locks.Lock_Inventory');
1709: FND_MESSAGE.Set_Token('WHERE', 'GMI_UPDATE_SHIPMENT_TXN');
1710: FND_MSG_PUB.Add;
1726: );
1727:
1728: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
1729: THEN
1730: GMI_RESERVATION_UTIL.println('Error Could Not Complete');
1731: GMI_RESERVATION_UTIL.println('Inv Eng Msg:'||x_msg_data);
1732: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1733: END IF;
1734: /* only need to balance default lot for overpickiing */
1727:
1728: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
1729: THEN
1730: GMI_RESERVATION_UTIL.println('Error Could Not Complete');
1731: GMI_RESERVATION_UTIL.println('Inv Eng Msg:'||x_msg_data);
1732: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1733: END IF;
1734: /* only need to balance default lot for overpickiing */
1735: GMI_RESERVATION_UTIL.println('find_deafult_lot ');
1731: GMI_RESERVATION_UTIL.println('Inv Eng Msg:'||x_msg_data);
1732: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1733: END IF;
1734: /* only need to balance default lot for overpickiing */
1735: GMI_RESERVATION_UTIL.println('find_deafult_lot ');
1736: /* find the default transaction */
1737: GMI_RESERVATION_UTIL.find_default_lot
1738: ( x_return_status => x_return_status,
1739: x_msg_count => x_msg_count,
1733: END IF;
1734: /* only need to balance default lot for overpickiing */
1735: GMI_RESERVATION_UTIL.println('find_deafult_lot ');
1736: /* find the default transaction */
1737: GMI_RESERVATION_UTIL.find_default_lot
1738: ( x_return_status => x_return_status,
1739: x_msg_count => x_msg_count,
1740: x_msg_data => x_msg_data,
1741: x_reservation_id => l_trans_id,
1748: (l_new_transaction_rec, l_new_transaction_rec )
1749: THEN
1750: l_ship_qty_above := p_shipping_line.ship_tolerance_above * abs(l_old_transaction_rec.trans_qty) /100;
1751: l_ship_qty_below := p_shipping_line.ship_tolerance_below * abs(l_old_transaction_rec.trans_qty) /100;
1752: GMI_RESERVATION_UTIL.println('shipping tolerance above %' ||p_shipping_line.ship_tolerance_above/100);
1753: GMI_RESERVATION_UTIL.println('shipping tolerance below %' ||p_shipping_line.ship_tolerance_below/100);
1754: GMI_RESERVATION_UTIL.println('shipping tolerance above qty' ||l_ship_qty_above);
1755: GMI_RESERVATION_UTIL.println('shipping tolerance below qty' ||l_ship_qty_below);
1756: /* if ship within tolerance, 0 out the default lot */
1749: THEN
1750: l_ship_qty_above := p_shipping_line.ship_tolerance_above * abs(l_old_transaction_rec.trans_qty) /100;
1751: l_ship_qty_below := p_shipping_line.ship_tolerance_below * abs(l_old_transaction_rec.trans_qty) /100;
1752: GMI_RESERVATION_UTIL.println('shipping tolerance above %' ||p_shipping_line.ship_tolerance_above/100);
1753: GMI_RESERVATION_UTIL.println('shipping tolerance below %' ||p_shipping_line.ship_tolerance_below/100);
1754: GMI_RESERVATION_UTIL.println('shipping tolerance above qty' ||l_ship_qty_above);
1755: GMI_RESERVATION_UTIL.println('shipping tolerance below qty' ||l_ship_qty_below);
1756: /* if ship within tolerance, 0 out the default lot */
1757: IF p_shipping_line.shipped_quantity <= ABS(p_shipping_line.requested_quantity )
1750: l_ship_qty_above := p_shipping_line.ship_tolerance_above * abs(l_old_transaction_rec.trans_qty) /100;
1751: l_ship_qty_below := p_shipping_line.ship_tolerance_below * abs(l_old_transaction_rec.trans_qty) /100;
1752: GMI_RESERVATION_UTIL.println('shipping tolerance above %' ||p_shipping_line.ship_tolerance_above/100);
1753: GMI_RESERVATION_UTIL.println('shipping tolerance below %' ||p_shipping_line.ship_tolerance_below/100);
1754: GMI_RESERVATION_UTIL.println('shipping tolerance above qty' ||l_ship_qty_above);
1755: GMI_RESERVATION_UTIL.println('shipping tolerance below qty' ||l_ship_qty_below);
1756: /* if ship within tolerance, 0 out the default lot */
1757: IF p_shipping_line.shipped_quantity <= ABS(p_shipping_line.requested_quantity )
1758: + l_ship_qty_above
1751: l_ship_qty_below := p_shipping_line.ship_tolerance_below * abs(l_old_transaction_rec.trans_qty) /100;
1752: GMI_RESERVATION_UTIL.println('shipping tolerance above %' ||p_shipping_line.ship_tolerance_above/100);
1753: GMI_RESERVATION_UTIL.println('shipping tolerance below %' ||p_shipping_line.ship_tolerance_below/100);
1754: GMI_RESERVATION_UTIL.println('shipping tolerance above qty' ||l_ship_qty_above);
1755: GMI_RESERVATION_UTIL.println('shipping tolerance below qty' ||l_ship_qty_below);
1756: /* if ship within tolerance, 0 out the default lot */
1757: IF p_shipping_line.shipped_quantity <= ABS(p_shipping_line.requested_quantity )
1758: + l_ship_qty_above
1759: AND p_shipping_line.shipped_quantity >= ABS(p_shipping_line.requested_quantity)
1761: THEN
1762: l_new_transaction_rec.trans_qty := 0;
1763: l_new_transaction_rec.trans_qty2 := 0;
1764:
1765: GMI_RESERVATION_UTIL.println('shipping within tolerance ');
1766: PRINT_DEBUG (l_new_transaction_rec,' 0 out Default Transaction');
1767:
1768: GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION
1769: ( 1
1776: , x_msg_count
1777: , x_msg_data
1778: );
1779: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1780: GMI_RESERVATION_UTIL.println('Error returned by Update_Pending_Transaction');
1781: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1782: END IF;
1783: ELSE
1784: GMI_RESERVATION_UTIL.println('balancing default lot.');
1780: GMI_RESERVATION_UTIL.println('Error returned by Update_Pending_Transaction');
1781: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1782: END IF;
1783: ELSE
1784: GMI_RESERVATION_UTIL.println('balancing default lot.');
1785: GMI_RESERVATION_UTIL.balance_default_lot
1786: ( p_ic_default_rec => l_new_transaction_rec
1787: , p_opm_item_id => l_new_transaction_rec.item_id
1788: , x_return_status => x_return_status
1781: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1782: END IF;
1783: ELSE
1784: GMI_RESERVATION_UTIL.println('balancing default lot.');
1785: GMI_RESERVATION_UTIL.balance_default_lot
1786: ( p_ic_default_rec => l_new_transaction_rec
1787: , p_opm_item_id => l_new_transaction_rec.item_id
1788: , x_return_status => x_return_status
1789: , x_msg_count => x_msg_count
1790: , x_msg_data => x_msg_data
1791: );
1792: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
1793: THEN
1794: GMI_RESERVATION_UTIL.PrintLn('Error returned by balancing default lot');
1795: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1796: END IF;
1797: END IF;
1798: END IF;
1806:
1807: WHEN NO_DATA_FOUND THEN
1808: rollback to process_shipments;
1809: x_return_status := FND_API.G_RET_STS_ERROR;
1810: GMI_RESERVATION_UTIL.Println('Raised No Data Found');
1811:
1812: WHEN OTHERS
1813: THEN
1814: rollback to process_shipments;
1812: WHEN OTHERS
1813: THEN
1814: rollback to process_shipments;
1815: x_return_status := FND_API.G_RET_STS_ERROR;
1816: GMI_RESERVATION_UTIL.Println('Raised When Others');
1817:
1818: END GMI_UPDATE_SHIPMENT_TXN_new;
1819:
1820: PROCEDURE GMI_APPLY_BACKORDER_UPDATES
1862: /* Not Pick Confirmed). */
1863:
1864: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1865:
1866: GMI_RESERVATION_UTIL.println('In GMI BACKORDER UPDATE');
1867: GMI_RESERVATION_UTIL.println('P_source_line_id => ' || p_source_line_id);
1868: GMI_RESERVATION_UTIL.println('Original SOURCE => ' || p_original_source_line_id );
1869:
1870: Open get_move_order;
1863:
1864: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1865:
1866: GMI_RESERVATION_UTIL.println('In GMI BACKORDER UPDATE');
1867: GMI_RESERVATION_UTIL.println('P_source_line_id => ' || p_source_line_id);
1868: GMI_RESERVATION_UTIL.println('Original SOURCE => ' || p_original_source_line_id );
1869:
1870: Open get_move_order;
1871:
1864: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1865:
1866: GMI_RESERVATION_UTIL.println('In GMI BACKORDER UPDATE');
1867: GMI_RESERVATION_UTIL.println('P_source_line_id => ' || p_source_line_id);
1868: GMI_RESERVATION_UTIL.println('Original SOURCE => ' || p_original_source_line_id );
1869:
1870: Open get_move_order;
1871:
1872: LOOP
1872: LOOP
1873: FETCH get_move_order into l_move_order;
1874: EXIT WHEN get_move_order%NOTFOUND;
1875:
1876: GMI_RESERVATION_UTIL.println('Mo_ID=' || l_move_order.move_order_line_id ||', txn_source_line_id='||p_source_line_id ||', Status='|| l_move_order.released_status);
1877:
1878: Update IC_TXN_REQUEST_LINES
1879: SET TXN_SOURCE_LINE_ID = p_source_line_id
1880: WHERE line_id = l_move_order.move_order_line_id;
1880: WHERE line_id = l_move_order.move_order_line_id;
1881:
1882: IF (SQL%NOTFOUND) THEN
1883: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1884: GMI_RESERVATION_UTIL.println('Error In Updating MO LINE');
1885: Close get_move_order; /* B2886561 close cursor before exception */
1886: RAISE NO_DATA_FOUND;
1887: END IF;
1888:
1897: LOOP
1898: FETCH get_bad_delivery into l_delivery_detail_id,
1899: l_source_line_id, l_released_status,l_lot_number,l_sublot_number;
1900: EXIT WHEN get_bad_delivery%NOTFOUND;
1901: GMI_RESERVATION_UTIL.println('Clearing out information for:');
1902: GMI_RESERVATION_UTIL.println('++++++++++ ');
1903: GMI_RESERVATION_UTIL.println('Delivery_detail_id '||l_delivery_detail_id);
1904: GMI_RESERVATION_UTIL.println('Source_line_id '||l_source_line_id);
1905: GMI_RESERVATION_UTIL.println('Released_status '||l_released_status);
1898: FETCH get_bad_delivery into l_delivery_detail_id,
1899: l_source_line_id, l_released_status,l_lot_number,l_sublot_number;
1900: EXIT WHEN get_bad_delivery%NOTFOUND;
1901: GMI_RESERVATION_UTIL.println('Clearing out information for:');
1902: GMI_RESERVATION_UTIL.println('++++++++++ ');
1903: GMI_RESERVATION_UTIL.println('Delivery_detail_id '||l_delivery_detail_id);
1904: GMI_RESERVATION_UTIL.println('Source_line_id '||l_source_line_id);
1905: GMI_RESERVATION_UTIL.println('Released_status '||l_released_status);
1906: GMI_RESERVATION_UTIL.println('Lot_number '||l_lot_number);
1899: l_source_line_id, l_released_status,l_lot_number,l_sublot_number;
1900: EXIT WHEN get_bad_delivery%NOTFOUND;
1901: GMI_RESERVATION_UTIL.println('Clearing out information for:');
1902: GMI_RESERVATION_UTIL.println('++++++++++ ');
1903: GMI_RESERVATION_UTIL.println('Delivery_detail_id '||l_delivery_detail_id);
1904: GMI_RESERVATION_UTIL.println('Source_line_id '||l_source_line_id);
1905: GMI_RESERVATION_UTIL.println('Released_status '||l_released_status);
1906: GMI_RESERVATION_UTIL.println('Lot_number '||l_lot_number);
1907: GMI_RESERVATION_UTIL.println('Sublot_number '||l_sublot_number);
1900: EXIT WHEN get_bad_delivery%NOTFOUND;
1901: GMI_RESERVATION_UTIL.println('Clearing out information for:');
1902: GMI_RESERVATION_UTIL.println('++++++++++ ');
1903: GMI_RESERVATION_UTIL.println('Delivery_detail_id '||l_delivery_detail_id);
1904: GMI_RESERVATION_UTIL.println('Source_line_id '||l_source_line_id);
1905: GMI_RESERVATION_UTIL.println('Released_status '||l_released_status);
1906: GMI_RESERVATION_UTIL.println('Lot_number '||l_lot_number);
1907: GMI_RESERVATION_UTIL.println('Sublot_number '||l_sublot_number);
1908: GMI_RESERVATION_UTIL.println('++++++++++ ');
1901: GMI_RESERVATION_UTIL.println('Clearing out information for:');
1902: GMI_RESERVATION_UTIL.println('++++++++++ ');
1903: GMI_RESERVATION_UTIL.println('Delivery_detail_id '||l_delivery_detail_id);
1904: GMI_RESERVATION_UTIL.println('Source_line_id '||l_source_line_id);
1905: GMI_RESERVATION_UTIL.println('Released_status '||l_released_status);
1906: GMI_RESERVATION_UTIL.println('Lot_number '||l_lot_number);
1907: GMI_RESERVATION_UTIL.println('Sublot_number '||l_sublot_number);
1908: GMI_RESERVATION_UTIL.println('++++++++++ ');
1909: END LOOP;
1902: GMI_RESERVATION_UTIL.println('++++++++++ ');
1903: GMI_RESERVATION_UTIL.println('Delivery_detail_id '||l_delivery_detail_id);
1904: GMI_RESERVATION_UTIL.println('Source_line_id '||l_source_line_id);
1905: GMI_RESERVATION_UTIL.println('Released_status '||l_released_status);
1906: GMI_RESERVATION_UTIL.println('Lot_number '||l_lot_number);
1907: GMI_RESERVATION_UTIL.println('Sublot_number '||l_sublot_number);
1908: GMI_RESERVATION_UTIL.println('++++++++++ ');
1909: END LOOP;
1910: CLOSE get_bad_delivery;
1903: GMI_RESERVATION_UTIL.println('Delivery_detail_id '||l_delivery_detail_id);
1904: GMI_RESERVATION_UTIL.println('Source_line_id '||l_source_line_id);
1905: GMI_RESERVATION_UTIL.println('Released_status '||l_released_status);
1906: GMI_RESERVATION_UTIL.println('Lot_number '||l_lot_number);
1907: GMI_RESERVATION_UTIL.println('Sublot_number '||l_sublot_number);
1908: GMI_RESERVATION_UTIL.println('++++++++++ ');
1909: END LOOP;
1910: CLOSE get_bad_delivery;
1911: -- HW END OF BUG#:1826752
1904: GMI_RESERVATION_UTIL.println('Source_line_id '||l_source_line_id);
1905: GMI_RESERVATION_UTIL.println('Released_status '||l_released_status);
1906: GMI_RESERVATION_UTIL.println('Lot_number '||l_lot_number);
1907: GMI_RESERVATION_UTIL.println('Sublot_number '||l_sublot_number);
1908: GMI_RESERVATION_UTIL.println('++++++++++ ');
1909: END LOOP;
1910: CLOSE get_bad_delivery;
1911: -- HW END OF BUG#:1826752
1912:
1930: /* HAM RE_CHECK */
1931: /* and ship_confirm_action_flag = 'B'; */
1932: IF (SQL%NOTFOUND)
1933: THEN
1934: GMI_RESERVATION_UTIL.println('No Update in wsh_delivery_details, line_id='||p_source_line_id);
1935:
1936: -- x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1937: -- RAISE NO_DATA_FOUND;
1938: END IF;
1936: -- x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1937: -- RAISE NO_DATA_FOUND;
1938: END IF;
1939:
1940: GMI_RESERVATION_UTIL.println('New Line Id => '|| p_source_line_id );
1941: GMI_RESERVATION_UTIL.println('Orig Line Id => '|| p_original_source_line_id);
1942:
1943:
1944:
1937: -- RAISE NO_DATA_FOUND;
1938: END IF;
1939:
1940: GMI_RESERVATION_UTIL.println('New Line Id => '|| p_source_line_id );
1941: GMI_RESERVATION_UTIL.println('Orig Line Id => '|| p_original_source_line_id);
1942:
1943:
1944:
1945: /* this only happens for non control item where the shared default lot is not good */
1961: --END IF;
1962: IF (SQL%NOTFOUND) THEN
1963: /* bug 1783859 */
1964: /*for a pure back order line, this trans may not exsit, no error should be returned*/
1965: GMI_RESERVATION_UTIL.println('No Update in ic_tran_pnd, line_id='||p_source_line_id);
1966: --x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1967: --RAISE NO_DATA_FOUND;
1968: END IF;
1969:
1967: --RAISE NO_DATA_FOUND;
1968: END IF;
1969:
1970:
1971: GMI_RESERVATION_UTIL.println('At the end of GMI_Apply_BacKOrder_Updated, No Error.');
1972:
1973: EXCEPTION
1974: WHEN NO_DATA_FOUND
1975: THEN
1972:
1973: EXCEPTION
1974: WHEN NO_DATA_FOUND
1975: THEN
1976: GMI_RESERVATION_UTIL.println('No Data Found raised');
1977: WHEN OTHERS
1978: THEN
1979: x_return_status := FND_API.G_RET_STS_ERROR;
1980: GMI_RESERVATION_UTIL.println('RAISE WHEN OTHERS');
1976: GMI_RESERVATION_UTIL.println('No Data Found raised');
1977: WHEN OTHERS
1978: THEN
1979: x_return_status := FND_API.G_RET_STS_ERROR;
1980: GMI_RESERVATION_UTIL.println('RAISE WHEN OTHERS');
1981: END GMI_APPLY_BACKORDER_UPDATES;
1982:
1983: /* NC Added the following two procedures. Bug#1675561 */
1984: PROCEDURE UPDATE_OPM_TRANSACTION
2096: FROM ic_loct_mst
2097: WHERE inventory_location_id = p_locator_id;
2098: END IF;
2099:
2100: GMI_RESERVATION_UTIL.println('LOT_NUMBER => ' || p_lot_number);
2101: GMI_RESERVATION_UTIL.println('SUBLOT_NUMBER => ' || p_sublot_number);
2102:
2103: IF p_lot_number IS NULL
2104: THEN
2097: WHERE inventory_location_id = p_locator_id;
2098: END IF;
2099:
2100: GMI_RESERVATION_UTIL.println('LOT_NUMBER => ' || p_lot_number);
2101: GMI_RESERVATION_UTIL.println('SUBLOT_NUMBER => ' || p_sublot_number);
2102:
2103: IF p_lot_number IS NULL
2104: THEN
2105: l_lot_id := 0;
2121: /* With the above retrievals successfully done we can */
2122: /* try to locate the transaction we need. Again, if this fails */
2123: /* we cannot proceed so let the exception raised take over. */
2124:
2125: GMI_RESERVATION_UTIL.println('Retrieving OLD TRX in UPDATE_OPM_TRANSACTION ');
2126: GMI_RESERVATION_UTIL.println('LINE_ID => ' || p_old_source_line_id);
2127: GMI_RESERVATION_UTIL.println('LINE_DETAIL_ID => ' || p_old_delivery_detail_id);
2128: GMI_RESERVATION_UTIL.println('ITEM_ID => ' || l_item_id);
2129: GMI_RESERVATION_UTIL.println('LOT_ID => ' || l_lot_id);
2122: /* try to locate the transaction we need. Again, if this fails */
2123: /* we cannot proceed so let the exception raised take over. */
2124:
2125: GMI_RESERVATION_UTIL.println('Retrieving OLD TRX in UPDATE_OPM_TRANSACTION ');
2126: GMI_RESERVATION_UTIL.println('LINE_ID => ' || p_old_source_line_id);
2127: GMI_RESERVATION_UTIL.println('LINE_DETAIL_ID => ' || p_old_delivery_detail_id);
2128: GMI_RESERVATION_UTIL.println('ITEM_ID => ' || l_item_id);
2129: GMI_RESERVATION_UTIL.println('LOT_ID => ' || l_lot_id);
2130: GMI_RESERVATION_UTIL.println('Location => ' || l_location);
2123: /* we cannot proceed so let the exception raised take over. */
2124:
2125: GMI_RESERVATION_UTIL.println('Retrieving OLD TRX in UPDATE_OPM_TRANSACTION ');
2126: GMI_RESERVATION_UTIL.println('LINE_ID => ' || p_old_source_line_id);
2127: GMI_RESERVATION_UTIL.println('LINE_DETAIL_ID => ' || p_old_delivery_detail_id);
2128: GMI_RESERVATION_UTIL.println('ITEM_ID => ' || l_item_id);
2129: GMI_RESERVATION_UTIL.println('LOT_ID => ' || l_lot_id);
2130: GMI_RESERVATION_UTIL.println('Location => ' || l_location);
2131:
2124:
2125: GMI_RESERVATION_UTIL.println('Retrieving OLD TRX in UPDATE_OPM_TRANSACTION ');
2126: GMI_RESERVATION_UTIL.println('LINE_ID => ' || p_old_source_line_id);
2127: GMI_RESERVATION_UTIL.println('LINE_DETAIL_ID => ' || p_old_delivery_detail_id);
2128: GMI_RESERVATION_UTIL.println('ITEM_ID => ' || l_item_id);
2129: GMI_RESERVATION_UTIL.println('LOT_ID => ' || l_lot_id);
2130: GMI_RESERVATION_UTIL.println('Location => ' || l_location);
2131:
2132: OPEN fetch_opm_transaction(p_old_delivery_detail_id,
2125: GMI_RESERVATION_UTIL.println('Retrieving OLD TRX in UPDATE_OPM_TRANSACTION ');
2126: GMI_RESERVATION_UTIL.println('LINE_ID => ' || p_old_source_line_id);
2127: GMI_RESERVATION_UTIL.println('LINE_DETAIL_ID => ' || p_old_delivery_detail_id);
2128: GMI_RESERVATION_UTIL.println('ITEM_ID => ' || l_item_id);
2129: GMI_RESERVATION_UTIL.println('LOT_ID => ' || l_lot_id);
2130: GMI_RESERVATION_UTIL.println('Location => ' || l_location);
2131:
2132: OPEN fetch_opm_transaction(p_old_delivery_detail_id,
2133: p_old_source_line_id
2126: GMI_RESERVATION_UTIL.println('LINE_ID => ' || p_old_source_line_id);
2127: GMI_RESERVATION_UTIL.println('LINE_DETAIL_ID => ' || p_old_delivery_detail_id);
2128: GMI_RESERVATION_UTIL.println('ITEM_ID => ' || l_item_id);
2129: GMI_RESERVATION_UTIL.println('LOT_ID => ' || l_lot_id);
2130: GMI_RESERVATION_UTIL.println('Location => ' || l_location);
2131:
2132: OPEN fetch_opm_transaction(p_old_delivery_detail_id,
2133: p_old_source_line_id
2134: );
2134: );
2135: FETCH fetch_opm_transaction INTO l_old_transaction_rec.trans_id;
2136: IF(fetch_opm_transaction%NOTFOUND) THEN
2137: CLOSE fetch_opm_transaction;
2138: GMI_RESERVATION_UTIL.println('Transaction Not Found in UPDATE_OPM_TRXS');
2139: RAISE NO_DATA_FOUND;
2140: END IF;
2141:
2142: CLOSE fetch_opm_transaction;
2140: END IF;
2141:
2142: CLOSE fetch_opm_transaction;
2143:
2144: GMI_RESERVATION_UTIL.println('Retrieve OPM Transaction => ' ||l_old_transaction_rec.trans_id );
2145: IF GMI_TRAN_PND_DB_PVT.FETCH_IC_TRAN_PND (l_old_transaction_rec, l_old_transaction_rec )
2146: THEN
2147: GMI_reservation_Util.printLn('OPM Transaction found in OPM_UPDATE_TRXS');
2148: -- PK Bug 3527599 No need to lock IC_LOCT_INV when updating / creating pending txn.
2143:
2144: GMI_RESERVATION_UTIL.println('Retrieve OPM Transaction => ' ||l_old_transaction_rec.trans_id );
2145: IF GMI_TRAN_PND_DB_PVT.FETCH_IC_TRAN_PND (l_old_transaction_rec, l_old_transaction_rec )
2146: THEN
2147: GMI_reservation_Util.printLn('OPM Transaction found in OPM_UPDATE_TRXS');
2148: -- PK Bug 3527599 No need to lock IC_LOCT_INV when updating / creating pending txn.
2149:
2150: GMI_RESERVATION_UTIL.println('Correct Transaction Found');
2151:
2146: THEN
2147: GMI_reservation_Util.printLn('OPM Transaction found in OPM_UPDATE_TRXS');
2148: -- PK Bug 3527599 No need to lock IC_LOCT_INV when updating / creating pending txn.
2149:
2150: GMI_RESERVATION_UTIL.println('Correct Transaction Found');
2151:
2152: PRINT_DEBUG (l_old_transaction_rec,'FETCH RECORD');
2153:
2154: l_old_transaction_rec.trans_qty := -1 * (p_old_req_quantity - p_req_quantity);
2167: );
2168:
2169: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
2170: THEN
2171: GMI_RESERVATION_UTIL.println('Error returned by Update_Pending_Transaction');
2172: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2173: END IF;
2174:
2175: l_new_transaction_rec := l_old_transaction_rec;
2191: );
2192:
2193: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
2194: THEN
2195: GMI_RESERVATION_UTIL.println('Error returned by Create_Pending_Transaction');
2196: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2197: END IF;
2198:
2199: END IF;
2202: WHEN NO_DATA_FOUND THEN
2203: rollback to update_txn;
2204: x_return_status := FND_API.G_RET_STS_ERROR;
2205: RAISE NO_DATA_FOUND;
2206: GMI_RESERVATION_UTIL.Println('Raised When No Data Found in UPDATE_OPM_TRANSACTION');
2207:
2208: WHEN OTHERS THEN
2209: rollback to update_txn;
2210: x_return_status := FND_API.G_RET_STS_ERROR;
2207:
2208: WHEN OTHERS THEN
2209: rollback to update_txn;
2210: x_return_status := FND_API.G_RET_STS_ERROR;
2211: GMI_RESERVATION_UTIL.Println('Raised When Others in UPDATE_OPM_TRANSACTION');
2212: END UPDATE_OPM_TRANSACTION;
2213:
2214: PROCEDURE UPDATE_OPM_IC_TRAN_PND
2215: ( p_delivery_detail_id IN NUMBER,
2233: END IF;
2234:
2235: EXCEPTION
2236: WHEN OTHERS THEN
2237: GMI_RESERVATION_UTIL.println('*** In update_opm_ic_tran_pnd');
2238: GMI_RESERVATION_UTIL.println('*** When Others exception raised');
2239: END UPDATE_OPM_IC_TRAN_PND;
2240:
2241: PROCEDURE PRINT_DEBUG
2234:
2235: EXCEPTION
2236: WHEN OTHERS THEN
2237: GMI_RESERVATION_UTIL.println('*** In update_opm_ic_tran_pnd');
2238: GMI_RESERVATION_UTIL.println('*** When Others exception raised');
2239: END UPDATE_OPM_IC_TRAN_PND;
2240:
2241: PROCEDURE PRINT_DEBUG
2242: (
2245: )
2246: IS
2247: BEGIN
2248:
2249: GMI_RESERVATION_UTIL.println(' *** Called From -> ' || p_routine );
2250: GMI_RESERVATION_UTIL.println(' TRANS_ID -> ' || p_tran_rec.trans_id);
2251: GMI_RESERVATION_UTIL.println(' ITEM_ID -> ' || p_tran_rec.item_id);
2252: GMI_RESERVATION_UTIL.println(' LINE_ID -> ' || p_tran_rec.line_id);
2253: GMI_RESERVATION_UTIL.println(' CO_CODE -> ' || p_tran_rec.co_code);
2246: IS
2247: BEGIN
2248:
2249: GMI_RESERVATION_UTIL.println(' *** Called From -> ' || p_routine );
2250: GMI_RESERVATION_UTIL.println(' TRANS_ID -> ' || p_tran_rec.trans_id);
2251: GMI_RESERVATION_UTIL.println(' ITEM_ID -> ' || p_tran_rec.item_id);
2252: GMI_RESERVATION_UTIL.println(' LINE_ID -> ' || p_tran_rec.line_id);
2253: GMI_RESERVATION_UTIL.println(' CO_CODE -> ' || p_tran_rec.co_code);
2254: GMI_RESERVATION_UTIL.println(' ORGN_CODE -> ' || p_tran_rec.orgn_code);
2247: BEGIN
2248:
2249: GMI_RESERVATION_UTIL.println(' *** Called From -> ' || p_routine );
2250: GMI_RESERVATION_UTIL.println(' TRANS_ID -> ' || p_tran_rec.trans_id);
2251: GMI_RESERVATION_UTIL.println(' ITEM_ID -> ' || p_tran_rec.item_id);
2252: GMI_RESERVATION_UTIL.println(' LINE_ID -> ' || p_tran_rec.line_id);
2253: GMI_RESERVATION_UTIL.println(' CO_CODE -> ' || p_tran_rec.co_code);
2254: GMI_RESERVATION_UTIL.println(' ORGN_CODE -> ' || p_tran_rec.orgn_code);
2255: GMI_RESERVATION_UTIL.println(' WHSE_CODE -> ' || p_tran_rec.whse_code);
2248:
2249: GMI_RESERVATION_UTIL.println(' *** Called From -> ' || p_routine );
2250: GMI_RESERVATION_UTIL.println(' TRANS_ID -> ' || p_tran_rec.trans_id);
2251: GMI_RESERVATION_UTIL.println(' ITEM_ID -> ' || p_tran_rec.item_id);
2252: GMI_RESERVATION_UTIL.println(' LINE_ID -> ' || p_tran_rec.line_id);
2253: GMI_RESERVATION_UTIL.println(' CO_CODE -> ' || p_tran_rec.co_code);
2254: GMI_RESERVATION_UTIL.println(' ORGN_CODE -> ' || p_tran_rec.orgn_code);
2255: GMI_RESERVATION_UTIL.println(' WHSE_CODE -> ' || p_tran_rec.whse_code);
2256: GMI_RESERVATION_UTIL.println(' LOT_ID -> ' || p_tran_rec.lot_id);
2249: GMI_RESERVATION_UTIL.println(' *** Called From -> ' || p_routine );
2250: GMI_RESERVATION_UTIL.println(' TRANS_ID -> ' || p_tran_rec.trans_id);
2251: GMI_RESERVATION_UTIL.println(' ITEM_ID -> ' || p_tran_rec.item_id);
2252: GMI_RESERVATION_UTIL.println(' LINE_ID -> ' || p_tran_rec.line_id);
2253: GMI_RESERVATION_UTIL.println(' CO_CODE -> ' || p_tran_rec.co_code);
2254: GMI_RESERVATION_UTIL.println(' ORGN_CODE -> ' || p_tran_rec.orgn_code);
2255: GMI_RESERVATION_UTIL.println(' WHSE_CODE -> ' || p_tran_rec.whse_code);
2256: GMI_RESERVATION_UTIL.println(' LOT_ID -> ' || p_tran_rec.lot_id);
2257: GMI_RESERVATION_UTIL.println(' LOCATION -> ' || p_tran_rec.location);
2250: GMI_RESERVATION_UTIL.println(' TRANS_ID -> ' || p_tran_rec.trans_id);
2251: GMI_RESERVATION_UTIL.println(' ITEM_ID -> ' || p_tran_rec.item_id);
2252: GMI_RESERVATION_UTIL.println(' LINE_ID -> ' || p_tran_rec.line_id);
2253: GMI_RESERVATION_UTIL.println(' CO_CODE -> ' || p_tran_rec.co_code);
2254: GMI_RESERVATION_UTIL.println(' ORGN_CODE -> ' || p_tran_rec.orgn_code);
2255: GMI_RESERVATION_UTIL.println(' WHSE_CODE -> ' || p_tran_rec.whse_code);
2256: GMI_RESERVATION_UTIL.println(' LOT_ID -> ' || p_tran_rec.lot_id);
2257: GMI_RESERVATION_UTIL.println(' LOCATION -> ' || p_tran_rec.location);
2258: GMI_RESERVATION_UTIL.println(' DOC_ID -> ' || p_tran_rec.doc_id);
2251: GMI_RESERVATION_UTIL.println(' ITEM_ID -> ' || p_tran_rec.item_id);
2252: GMI_RESERVATION_UTIL.println(' LINE_ID -> ' || p_tran_rec.line_id);
2253: GMI_RESERVATION_UTIL.println(' CO_CODE -> ' || p_tran_rec.co_code);
2254: GMI_RESERVATION_UTIL.println(' ORGN_CODE -> ' || p_tran_rec.orgn_code);
2255: GMI_RESERVATION_UTIL.println(' WHSE_CODE -> ' || p_tran_rec.whse_code);
2256: GMI_RESERVATION_UTIL.println(' LOT_ID -> ' || p_tran_rec.lot_id);
2257: GMI_RESERVATION_UTIL.println(' LOCATION -> ' || p_tran_rec.location);
2258: GMI_RESERVATION_UTIL.println(' DOC_ID -> ' || p_tran_rec.doc_id);
2259: GMI_RESERVATION_UTIL.println(' DOC_TYPE -> ' || p_tran_rec.doc_type);
2252: GMI_RESERVATION_UTIL.println(' LINE_ID -> ' || p_tran_rec.line_id);
2253: GMI_RESERVATION_UTIL.println(' CO_CODE -> ' || p_tran_rec.co_code);
2254: GMI_RESERVATION_UTIL.println(' ORGN_CODE -> ' || p_tran_rec.orgn_code);
2255: GMI_RESERVATION_UTIL.println(' WHSE_CODE -> ' || p_tran_rec.whse_code);
2256: GMI_RESERVATION_UTIL.println(' LOT_ID -> ' || p_tran_rec.lot_id);
2257: GMI_RESERVATION_UTIL.println(' LOCATION -> ' || p_tran_rec.location);
2258: GMI_RESERVATION_UTIL.println(' DOC_ID -> ' || p_tran_rec.doc_id);
2259: GMI_RESERVATION_UTIL.println(' DOC_TYPE -> ' || p_tran_rec.doc_type);
2260: GMI_RESERVATION_UTIL.println(' DOC_LINE -> ' || p_tran_rec.doc_line);
2253: GMI_RESERVATION_UTIL.println(' CO_CODE -> ' || p_tran_rec.co_code);
2254: GMI_RESERVATION_UTIL.println(' ORGN_CODE -> ' || p_tran_rec.orgn_code);
2255: GMI_RESERVATION_UTIL.println(' WHSE_CODE -> ' || p_tran_rec.whse_code);
2256: GMI_RESERVATION_UTIL.println(' LOT_ID -> ' || p_tran_rec.lot_id);
2257: GMI_RESERVATION_UTIL.println(' LOCATION -> ' || p_tran_rec.location);
2258: GMI_RESERVATION_UTIL.println(' DOC_ID -> ' || p_tran_rec.doc_id);
2259: GMI_RESERVATION_UTIL.println(' DOC_TYPE -> ' || p_tran_rec.doc_type);
2260: GMI_RESERVATION_UTIL.println(' DOC_LINE -> ' || p_tran_rec.doc_line);
2261: GMI_RESERVATION_UTIL.println(' LINE_TYPE -> ' || p_tran_rec.line_type);
2254: GMI_RESERVATION_UTIL.println(' ORGN_CODE -> ' || p_tran_rec.orgn_code);
2255: GMI_RESERVATION_UTIL.println(' WHSE_CODE -> ' || p_tran_rec.whse_code);
2256: GMI_RESERVATION_UTIL.println(' LOT_ID -> ' || p_tran_rec.lot_id);
2257: GMI_RESERVATION_UTIL.println(' LOCATION -> ' || p_tran_rec.location);
2258: GMI_RESERVATION_UTIL.println(' DOC_ID -> ' || p_tran_rec.doc_id);
2259: GMI_RESERVATION_UTIL.println(' DOC_TYPE -> ' || p_tran_rec.doc_type);
2260: GMI_RESERVATION_UTIL.println(' DOC_LINE -> ' || p_tran_rec.doc_line);
2261: GMI_RESERVATION_UTIL.println(' LINE_TYPE -> ' || p_tran_rec.line_type);
2262: GMI_RESERVATION_UTIL.println(' REAS_CODE -> ' || p_tran_rec.reason_code);
2255: GMI_RESERVATION_UTIL.println(' WHSE_CODE -> ' || p_tran_rec.whse_code);
2256: GMI_RESERVATION_UTIL.println(' LOT_ID -> ' || p_tran_rec.lot_id);
2257: GMI_RESERVATION_UTIL.println(' LOCATION -> ' || p_tran_rec.location);
2258: GMI_RESERVATION_UTIL.println(' DOC_ID -> ' || p_tran_rec.doc_id);
2259: GMI_RESERVATION_UTIL.println(' DOC_TYPE -> ' || p_tran_rec.doc_type);
2260: GMI_RESERVATION_UTIL.println(' DOC_LINE -> ' || p_tran_rec.doc_line);
2261: GMI_RESERVATION_UTIL.println(' LINE_TYPE -> ' || p_tran_rec.line_type);
2262: GMI_RESERVATION_UTIL.println(' REAS_CODE -> ' || p_tran_rec.reason_code);
2263: GMI_RESERVATION_UTIL.println(' TRANS_DATE -> ' || p_tran_rec.trans_date);
2256: GMI_RESERVATION_UTIL.println(' LOT_ID -> ' || p_tran_rec.lot_id);
2257: GMI_RESERVATION_UTIL.println(' LOCATION -> ' || p_tran_rec.location);
2258: GMI_RESERVATION_UTIL.println(' DOC_ID -> ' || p_tran_rec.doc_id);
2259: GMI_RESERVATION_UTIL.println(' DOC_TYPE -> ' || p_tran_rec.doc_type);
2260: GMI_RESERVATION_UTIL.println(' DOC_LINE -> ' || p_tran_rec.doc_line);
2261: GMI_RESERVATION_UTIL.println(' LINE_TYPE -> ' || p_tran_rec.line_type);
2262: GMI_RESERVATION_UTIL.println(' REAS_CODE -> ' || p_tran_rec.reason_code);
2263: GMI_RESERVATION_UTIL.println(' TRANS_DATE -> ' || p_tran_rec.trans_date);
2264: GMI_RESERVATION_UTIL.println(' TRANS_QTY -> ' || p_tran_rec.trans_qty);
2257: GMI_RESERVATION_UTIL.println(' LOCATION -> ' || p_tran_rec.location);
2258: GMI_RESERVATION_UTIL.println(' DOC_ID -> ' || p_tran_rec.doc_id);
2259: GMI_RESERVATION_UTIL.println(' DOC_TYPE -> ' || p_tran_rec.doc_type);
2260: GMI_RESERVATION_UTIL.println(' DOC_LINE -> ' || p_tran_rec.doc_line);
2261: GMI_RESERVATION_UTIL.println(' LINE_TYPE -> ' || p_tran_rec.line_type);
2262: GMI_RESERVATION_UTIL.println(' REAS_CODE -> ' || p_tran_rec.reason_code);
2263: GMI_RESERVATION_UTIL.println(' TRANS_DATE -> ' || p_tran_rec.trans_date);
2264: GMI_RESERVATION_UTIL.println(' TRANS_QTY -> ' || p_tran_rec.trans_qty);
2265: GMI_RESERVATION_UTIL.println(' TRANS_QTY2 -> ' || p_tran_rec.trans_qty2);
2258: GMI_RESERVATION_UTIL.println(' DOC_ID -> ' || p_tran_rec.doc_id);
2259: GMI_RESERVATION_UTIL.println(' DOC_TYPE -> ' || p_tran_rec.doc_type);
2260: GMI_RESERVATION_UTIL.println(' DOC_LINE -> ' || p_tran_rec.doc_line);
2261: GMI_RESERVATION_UTIL.println(' LINE_TYPE -> ' || p_tran_rec.line_type);
2262: GMI_RESERVATION_UTIL.println(' REAS_CODE -> ' || p_tran_rec.reason_code);
2263: GMI_RESERVATION_UTIL.println(' TRANS_DATE -> ' || p_tran_rec.trans_date);
2264: GMI_RESERVATION_UTIL.println(' TRANS_QTY -> ' || p_tran_rec.trans_qty);
2265: GMI_RESERVATION_UTIL.println(' TRANS_QTY2 -> ' || p_tran_rec.trans_qty2);
2266: GMI_RESERVATION_UTIL.println(' QC_GRADE -> ' || p_tran_rec.qc_grade);
2259: GMI_RESERVATION_UTIL.println(' DOC_TYPE -> ' || p_tran_rec.doc_type);
2260: GMI_RESERVATION_UTIL.println(' DOC_LINE -> ' || p_tran_rec.doc_line);
2261: GMI_RESERVATION_UTIL.println(' LINE_TYPE -> ' || p_tran_rec.line_type);
2262: GMI_RESERVATION_UTIL.println(' REAS_CODE -> ' || p_tran_rec.reason_code);
2263: GMI_RESERVATION_UTIL.println(' TRANS_DATE -> ' || p_tran_rec.trans_date);
2264: GMI_RESERVATION_UTIL.println(' TRANS_QTY -> ' || p_tran_rec.trans_qty);
2265: GMI_RESERVATION_UTIL.println(' TRANS_QTY2 -> ' || p_tran_rec.trans_qty2);
2266: GMI_RESERVATION_UTIL.println(' QC_GRADE -> ' || p_tran_rec.qc_grade);
2267: GMI_RESERVATION_UTIL.println(' LOT_STATUS -> ' || p_tran_rec.lot_status);
2260: GMI_RESERVATION_UTIL.println(' DOC_LINE -> ' || p_tran_rec.doc_line);
2261: GMI_RESERVATION_UTIL.println(' LINE_TYPE -> ' || p_tran_rec.line_type);
2262: GMI_RESERVATION_UTIL.println(' REAS_CODE -> ' || p_tran_rec.reason_code);
2263: GMI_RESERVATION_UTIL.println(' TRANS_DATE -> ' || p_tran_rec.trans_date);
2264: GMI_RESERVATION_UTIL.println(' TRANS_QTY -> ' || p_tran_rec.trans_qty);
2265: GMI_RESERVATION_UTIL.println(' TRANS_QTY2 -> ' || p_tran_rec.trans_qty2);
2266: GMI_RESERVATION_UTIL.println(' QC_GRADE -> ' || p_tran_rec.qc_grade);
2267: GMI_RESERVATION_UTIL.println(' LOT_STATUS -> ' || p_tran_rec.lot_status);
2268: GMI_RESERVATION_UTIL.println(' TRANS_STAT -> ' || p_tran_rec.trans_stat);
2261: GMI_RESERVATION_UTIL.println(' LINE_TYPE -> ' || p_tran_rec.line_type);
2262: GMI_RESERVATION_UTIL.println(' REAS_CODE -> ' || p_tran_rec.reason_code);
2263: GMI_RESERVATION_UTIL.println(' TRANS_DATE -> ' || p_tran_rec.trans_date);
2264: GMI_RESERVATION_UTIL.println(' TRANS_QTY -> ' || p_tran_rec.trans_qty);
2265: GMI_RESERVATION_UTIL.println(' TRANS_QTY2 -> ' || p_tran_rec.trans_qty2);
2266: GMI_RESERVATION_UTIL.println(' QC_GRADE -> ' || p_tran_rec.qc_grade);
2267: GMI_RESERVATION_UTIL.println(' LOT_STATUS -> ' || p_tran_rec.lot_status);
2268: GMI_RESERVATION_UTIL.println(' TRANS_STAT -> ' || p_tran_rec.trans_stat);
2269: GMI_RESERVATION_UTIL.println(' TRANS_UM -> ' || p_tran_rec.trans_um);
2262: GMI_RESERVATION_UTIL.println(' REAS_CODE -> ' || p_tran_rec.reason_code);
2263: GMI_RESERVATION_UTIL.println(' TRANS_DATE -> ' || p_tran_rec.trans_date);
2264: GMI_RESERVATION_UTIL.println(' TRANS_QTY -> ' || p_tran_rec.trans_qty);
2265: GMI_RESERVATION_UTIL.println(' TRANS_QTY2 -> ' || p_tran_rec.trans_qty2);
2266: GMI_RESERVATION_UTIL.println(' QC_GRADE -> ' || p_tran_rec.qc_grade);
2267: GMI_RESERVATION_UTIL.println(' LOT_STATUS -> ' || p_tran_rec.lot_status);
2268: GMI_RESERVATION_UTIL.println(' TRANS_STAT -> ' || p_tran_rec.trans_stat);
2269: GMI_RESERVATION_UTIL.println(' TRANS_UM -> ' || p_tran_rec.trans_um);
2270: GMI_RESERVATION_UTIL.println(' TRANS_UM2 -> ' || p_tran_rec.trans_um2);
2263: GMI_RESERVATION_UTIL.println(' TRANS_DATE -> ' || p_tran_rec.trans_date);
2264: GMI_RESERVATION_UTIL.println(' TRANS_QTY -> ' || p_tran_rec.trans_qty);
2265: GMI_RESERVATION_UTIL.println(' TRANS_QTY2 -> ' || p_tran_rec.trans_qty2);
2266: GMI_RESERVATION_UTIL.println(' QC_GRADE -> ' || p_tran_rec.qc_grade);
2267: GMI_RESERVATION_UTIL.println(' LOT_STATUS -> ' || p_tran_rec.lot_status);
2268: GMI_RESERVATION_UTIL.println(' TRANS_STAT -> ' || p_tran_rec.trans_stat);
2269: GMI_RESERVATION_UTIL.println(' TRANS_UM -> ' || p_tran_rec.trans_um);
2270: GMI_RESERVATION_UTIL.println(' TRANS_UM2 -> ' || p_tran_rec.trans_um2);
2271: GMI_RESERVATION_UTIL.println(' USER_ID -> ' || p_tran_rec.user_id);
2264: GMI_RESERVATION_UTIL.println(' TRANS_QTY -> ' || p_tran_rec.trans_qty);
2265: GMI_RESERVATION_UTIL.println(' TRANS_QTY2 -> ' || p_tran_rec.trans_qty2);
2266: GMI_RESERVATION_UTIL.println(' QC_GRADE -> ' || p_tran_rec.qc_grade);
2267: GMI_RESERVATION_UTIL.println(' LOT_STATUS -> ' || p_tran_rec.lot_status);
2268: GMI_RESERVATION_UTIL.println(' TRANS_STAT -> ' || p_tran_rec.trans_stat);
2269: GMI_RESERVATION_UTIL.println(' TRANS_UM -> ' || p_tran_rec.trans_um);
2270: GMI_RESERVATION_UTIL.println(' TRANS_UM2 -> ' || p_tran_rec.trans_um2);
2271: GMI_RESERVATION_UTIL.println(' USER_ID -> ' || p_tran_rec.user_id);
2272: GMI_RESERVATION_UTIL.println(' TEXT_CODE -> ' || p_tran_rec.text_code);
2265: GMI_RESERVATION_UTIL.println(' TRANS_QTY2 -> ' || p_tran_rec.trans_qty2);
2266: GMI_RESERVATION_UTIL.println(' QC_GRADE -> ' || p_tran_rec.qc_grade);
2267: GMI_RESERVATION_UTIL.println(' LOT_STATUS -> ' || p_tran_rec.lot_status);
2268: GMI_RESERVATION_UTIL.println(' TRANS_STAT -> ' || p_tran_rec.trans_stat);
2269: GMI_RESERVATION_UTIL.println(' TRANS_UM -> ' || p_tran_rec.trans_um);
2270: GMI_RESERVATION_UTIL.println(' TRANS_UM2 -> ' || p_tran_rec.trans_um2);
2271: GMI_RESERVATION_UTIL.println(' USER_ID -> ' || p_tran_rec.user_id);
2272: GMI_RESERVATION_UTIL.println(' TEXT_CODE -> ' || p_tran_rec.text_code);
2273: GMI_RESERVATION_UTIL.println(' NON_INV -> ' || p_tran_rec.non_inv);
2266: GMI_RESERVATION_UTIL.println(' QC_GRADE -> ' || p_tran_rec.qc_grade);
2267: GMI_RESERVATION_UTIL.println(' LOT_STATUS -> ' || p_tran_rec.lot_status);
2268: GMI_RESERVATION_UTIL.println(' TRANS_STAT -> ' || p_tran_rec.trans_stat);
2269: GMI_RESERVATION_UTIL.println(' TRANS_UM -> ' || p_tran_rec.trans_um);
2270: GMI_RESERVATION_UTIL.println(' TRANS_UM2 -> ' || p_tran_rec.trans_um2);
2271: GMI_RESERVATION_UTIL.println(' USER_ID -> ' || p_tran_rec.user_id);
2272: GMI_RESERVATION_UTIL.println(' TEXT_CODE -> ' || p_tran_rec.text_code);
2273: GMI_RESERVATION_UTIL.println(' NON_INV -> ' || p_tran_rec.non_inv);
2274: GMI_RESERVATION_UTIL.println(' STAGED_IND -> ' || p_tran_rec.staged_ind);
2267: GMI_RESERVATION_UTIL.println(' LOT_STATUS -> ' || p_tran_rec.lot_status);
2268: GMI_RESERVATION_UTIL.println(' TRANS_STAT -> ' || p_tran_rec.trans_stat);
2269: GMI_RESERVATION_UTIL.println(' TRANS_UM -> ' || p_tran_rec.trans_um);
2270: GMI_RESERVATION_UTIL.println(' TRANS_UM2 -> ' || p_tran_rec.trans_um2);
2271: GMI_RESERVATION_UTIL.println(' USER_ID -> ' || p_tran_rec.user_id);
2272: GMI_RESERVATION_UTIL.println(' TEXT_CODE -> ' || p_tran_rec.text_code);
2273: GMI_RESERVATION_UTIL.println(' NON_INV -> ' || p_tran_rec.non_inv);
2274: GMI_RESERVATION_UTIL.println(' STAGED_IND -> ' || p_tran_rec.staged_ind);
2275:
2268: GMI_RESERVATION_UTIL.println(' TRANS_STAT -> ' || p_tran_rec.trans_stat);
2269: GMI_RESERVATION_UTIL.println(' TRANS_UM -> ' || p_tran_rec.trans_um);
2270: GMI_RESERVATION_UTIL.println(' TRANS_UM2 -> ' || p_tran_rec.trans_um2);
2271: GMI_RESERVATION_UTIL.println(' USER_ID -> ' || p_tran_rec.user_id);
2272: GMI_RESERVATION_UTIL.println(' TEXT_CODE -> ' || p_tran_rec.text_code);
2273: GMI_RESERVATION_UTIL.println(' NON_INV -> ' || p_tran_rec.non_inv);
2274: GMI_RESERVATION_UTIL.println(' STAGED_IND -> ' || p_tran_rec.staged_ind);
2275:
2276: END PRINT_DEBUG;
2269: GMI_RESERVATION_UTIL.println(' TRANS_UM -> ' || p_tran_rec.trans_um);
2270: GMI_RESERVATION_UTIL.println(' TRANS_UM2 -> ' || p_tran_rec.trans_um2);
2271: GMI_RESERVATION_UTIL.println(' USER_ID -> ' || p_tran_rec.user_id);
2272: GMI_RESERVATION_UTIL.println(' TEXT_CODE -> ' || p_tran_rec.text_code);
2273: GMI_RESERVATION_UTIL.println(' NON_INV -> ' || p_tran_rec.non_inv);
2274: GMI_RESERVATION_UTIL.println(' STAGED_IND -> ' || p_tran_rec.staged_ind);
2275:
2276: END PRINT_DEBUG;
2277:
2270: GMI_RESERVATION_UTIL.println(' TRANS_UM2 -> ' || p_tran_rec.trans_um2);
2271: GMI_RESERVATION_UTIL.println(' USER_ID -> ' || p_tran_rec.user_id);
2272: GMI_RESERVATION_UTIL.println(' TEXT_CODE -> ' || p_tran_rec.text_code);
2273: GMI_RESERVATION_UTIL.println(' NON_INV -> ' || p_tran_rec.non_inv);
2274: GMI_RESERVATION_UTIL.println(' STAGED_IND -> ' || p_tran_rec.staged_ind);
2275:
2276: END PRINT_DEBUG;
2277:
2278: /* this procedure creates a row in rcv_transaction_interface and calls the
2391: FETCH c_order_line_info into l_order_line_info;
2392: if (c_order_line_info%NOTFOUND) THEN
2393: CLOSE c_order_line_info;
2394: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2395: GMI_RESERVATION_UTIL.Println('Sales order not valid');
2396: return;
2397: END if;
2398: CLOSE c_order_line_info;
2399:
2399:
2400: IF (l_order_line_info.source_document_type_id <> 10) THEN /* internal order */
2401: RETURN;
2402: ELSE
2403: GMI_RESERVATION_UTIL.Println('This line is part of an OPM internal order');
2404:
2405: OPEN c_delivery_info;
2406: FETCH c_delivery_info
2407: into l_delivery_id
2410: ;
2411: if (c_delivery_info%NOTFOUND) THEN
2412: CLOSE c_delivery_info;
2413: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2414: GMI_RESERVATION_UTIL.Println('Delivery Detail is not assigned to any delivery');
2415: return;
2416: -- raise NOT_ASSIGNED_TO_DEL_ERROR;
2417: END if;
2418: CLOSE c_delivery_info;
2427: WSH_UTIL_CORE.Println('Requisition line not found');
2428: return;
2429: end if;
2430: CLOSE c_po_info;
2431: GMI_RESERVATION_UTIL.Println('Requisition line id:' || l_order_line_info.source_document_line_id);
2432: GMI_RESERVATION_UTIL.Println('Destination_type_code:' ||l_po_info.destination_type_code );
2433: GMI_RESERVATION_UTIL.Println('Source organization id:' ||l_po_info.source_organization_id );
2434: GMI_RESERVATION_UTIL.Println('Destination organization id:' ||l_po_info.destination_organization_id );
2435:
2428: return;
2429: end if;
2430: CLOSE c_po_info;
2431: GMI_RESERVATION_UTIL.Println('Requisition line id:' || l_order_line_info.source_document_line_id);
2432: GMI_RESERVATION_UTIL.Println('Destination_type_code:' ||l_po_info.destination_type_code );
2433: GMI_RESERVATION_UTIL.Println('Source organization id:' ||l_po_info.source_organization_id );
2434: GMI_RESERVATION_UTIL.Println('Destination organization id:' ||l_po_info.destination_organization_id );
2435:
2436: l_transfer_subinventory := l_po_info.destination_subinventory;
2429: end if;
2430: CLOSE c_po_info;
2431: GMI_RESERVATION_UTIL.Println('Requisition line id:' || l_order_line_info.source_document_line_id);
2432: GMI_RESERVATION_UTIL.Println('Destination_type_code:' ||l_po_info.destination_type_code );
2433: GMI_RESERVATION_UTIL.Println('Source organization id:' ||l_po_info.source_organization_id );
2434: GMI_RESERVATION_UTIL.Println('Destination organization id:' ||l_po_info.destination_organization_id );
2435:
2436: l_transfer_subinventory := l_po_info.destination_subinventory;
2437: l_transfer_organization := l_po_info.destination_organization_id;
2430: CLOSE c_po_info;
2431: GMI_RESERVATION_UTIL.Println('Requisition line id:' || l_order_line_info.source_document_line_id);
2432: GMI_RESERVATION_UTIL.Println('Destination_type_code:' ||l_po_info.destination_type_code );
2433: GMI_RESERVATION_UTIL.Println('Source organization id:' ||l_po_info.source_organization_id );
2434: GMI_RESERVATION_UTIL.Println('Destination organization id:' ||l_po_info.destination_organization_id );
2435:
2436: l_transfer_subinventory := l_po_info.destination_subinventory;
2437: l_transfer_organization := l_po_info.destination_organization_id;
2438: l_requisition_line_id := l_po_info.requisition_line_id;
2439: l_ship_to_location_id := l_po_info.deliver_to_location_id;
2440: l_req_distribution_id := l_po_info.distribution_id;
2441:
2442: IF (l_po_info.destination_type_code = 'EXPENSE') THEN
2443: GMI_RESERVATION_UTIL.println('Store issue');
2444: l_trx_source_type_id := 8;
2445: l_trx_action_id := 1;
2446: l_trx_type_code := 34 /* Store_issue */;
2447: ELSIF (l_po_info.destination_type_code = 'INVENTORY') AND
2445: l_trx_action_id := 1;
2446: l_trx_type_code := 34 /* Store_issue */;
2447: ELSIF (l_po_info.destination_type_code = 'INVENTORY') AND
2448: (l_po_info.source_organization_id = l_po_info.destination_organization_id) THEN
2449: GMI_RESERVATION_UTIL.println('Sub inventory transfer');
2450: l_trx_source_type_id := 8;
2451: l_trx_action_id := 2;
2452: l_trx_type_code := 50 /* Subinv_xfer */;
2453: ELSIF (l_po_info.destination_organization_id <> l_po_info.source_organization_id) THEN
2456: l_po_info.destination_organization_id);
2457: FETCH c_mtl_interorg_parameters INTO l_intransit_type;
2458: IF c_mtl_interorg_parameters%NOTFOUND THEN
2459: /* default to intransit */
2460: GMI_RESERVATION_UTIL.println('In transit shipment');
2461: l_trx_source_type_id := 8;
2462: l_trx_action_id := 21;
2463: l_trx_type_code := 62; /* intransit_shpmnt */
2464: ELSE
2462: l_trx_action_id := 21;
2463: l_trx_type_code := 62; /* intransit_shpmnt */
2464: ELSE
2465: IF l_intransit_type = 1 THEN
2466: GMI_RESERVATION_UTIL.println('In direct shipment');
2467: l_trx_source_type_id := 8;
2468: l_trx_action_id := 3;
2469: l_trx_type_code := 54; /* direct shipment */
2470: ELSE
2467: l_trx_source_type_id := 8;
2468: l_trx_action_id := 3;
2469: l_trx_type_code := 54; /* direct shipment */
2470: ELSE
2471: GMI_RESERVATION_UTIL.println('In transit shipment');
2472: l_trx_source_type_id := 8;
2473: l_trx_action_id := 21;
2474: l_trx_type_code := 62; /* intransit_shpmnt */
2475: END IF;
2490: Open get_default_loct(l_po_info.destination_organization_id) ;
2491: Fetch get_default_loct into l_locator_id, l_subinventory;
2492: IF get_default_loct%NOTFOUND THEN
2493: /* check to see the item is location ctl, if not, raise error */
2494: GMI_RESERVATION_UTIL.println('Item and the dest Org are location controlled,
2495: but no default location setup');
2496: FND_MESSAGE.Set_Name('GMI','GMI_LOCATION_ERROR');
2497: FND_MESSAGE.Set_Token('BY_PROC', 'NO DESTINATION DEFAULT_LOC SETUP');
2498: FND_MESSAGE.Set_Token('WHERE', 'GMI_Create_rcv_trans');
2507: Open get_default_sub(l_po_info.destination_organization_id) ;
2508: Fetch get_default_sub into l_subinventory;
2509: IF get_default_sub%NOTFOUND THEN
2510: /* check to see the item is location ctl, if not, raise error */
2511: GMI_RESERVATION_UTIL.println('no default subinventory setup for direct receipt');
2512: FND_MESSAGE.Set_Name('GMI','GMI_LOCATION_ERROR');
2513: FND_MESSAGE.Set_Token('BY_PROC', 'NO DESTINATION DEFAULT_SUB SETUP');
2514: FND_MESSAGE.Set_Token('WHERE', 'GMI_Create_rcv_trans');
2515: FND_MSG_PUB.Add;
2549: l_source_code := WSH_SHIP_CONFIRM_ACTIONS.ont_source_code;
2550: else
2551: l_source_code := 'OKE';
2552: end if;
2553: GMI_RESERVATION_UTIL.get_OPM_account
2554: (
2555: v_dest_org_id => l_po_info.destination_organization_id,
2556: v_apps_item_id => l_detail_rec.inventory_item_id,
2557: v_vendor_site_id => l_detail_rec.org_id ,
2558: x_cc_id => l_charge_account_id,
2559: x_ac_id => l_accrual_account_id
2560: );
2561:
2562: GMI_RESERVATION_UTIL.println('Source_code:'|| l_source_code);
2563: GMI_RESERVATION_UTIL.println('charge_account_id:'|| l_charge_account_id);
2564:
2565: Open get_item_desc;
2566: Fetch get_item_desc INTO l_item_desc;
2559: x_ac_id => l_accrual_account_id
2560: );
2561:
2562: GMI_RESERVATION_UTIL.println('Source_code:'|| l_source_code);
2563: GMI_RESERVATION_UTIL.println('charge_account_id:'|| l_charge_account_id);
2564:
2565: Open get_item_desc;
2566: Fetch get_item_desc INTO l_item_desc;
2567: Close get_item_desc;
2565: Open get_item_desc;
2566: Fetch get_item_desc INTO l_item_desc;
2567: Close get_item_desc;
2568:
2569: GMI_RESERVATION_UTIL.println('Inserting Detail ' || l_detail_rec.delivery_detail_id || ' into RCV_TRANSACTIONS_INTERFACE ');
2570: select RCV_TRANSACTIONS_INTERFACE_S.NEXTVAL into l_transaction_id from dual;
2571: l_group_id := p_group_id;
2572:
2573: l_secondary_unit_of_measure := null;
2600: END IF;
2601: -- PK End Bug 3925583
2602: -- PK Also changed values to these local variable for Insert into rcv_transactions_interface
2603:
2604: GMI_RESERVATION_UTIL.println('transaction_id ' || l_transaction_id);
2605: GMI_RESERVATION_UTIL.println('group_id ' || l_group_id);
2606: GMI_RESERVATION_UTIL.println('interface_source_code ' || l_source_code);
2607: GMI_RESERVATION_UTIL.println('interface_source_line_id ' || l_detail_rec.source_line_id);
2608: GMI_RESERVATION_UTIL.println('last_update_date ' || sysdate);
2601: -- PK End Bug 3925583
2602: -- PK Also changed values to these local variable for Insert into rcv_transactions_interface
2603:
2604: GMI_RESERVATION_UTIL.println('transaction_id ' || l_transaction_id);
2605: GMI_RESERVATION_UTIL.println('group_id ' || l_group_id);
2606: GMI_RESERVATION_UTIL.println('interface_source_code ' || l_source_code);
2607: GMI_RESERVATION_UTIL.println('interface_source_line_id ' || l_detail_rec.source_line_id);
2608: GMI_RESERVATION_UTIL.println('last_update_date ' || sysdate);
2609: GMI_RESERVATION_UTIL.println('last_updated_by ' || FND_GLOBAL.user_id);
2602: -- PK Also changed values to these local variable for Insert into rcv_transactions_interface
2603:
2604: GMI_RESERVATION_UTIL.println('transaction_id ' || l_transaction_id);
2605: GMI_RESERVATION_UTIL.println('group_id ' || l_group_id);
2606: GMI_RESERVATION_UTIL.println('interface_source_code ' || l_source_code);
2607: GMI_RESERVATION_UTIL.println('interface_source_line_id ' || l_detail_rec.source_line_id);
2608: GMI_RESERVATION_UTIL.println('last_update_date ' || sysdate);
2609: GMI_RESERVATION_UTIL.println('last_updated_by ' || FND_GLOBAL.user_id);
2610: GMI_RESERVATION_UTIL.println('creation_date ' || sysdate);
2603:
2604: GMI_RESERVATION_UTIL.println('transaction_id ' || l_transaction_id);
2605: GMI_RESERVATION_UTIL.println('group_id ' || l_group_id);
2606: GMI_RESERVATION_UTIL.println('interface_source_code ' || l_source_code);
2607: GMI_RESERVATION_UTIL.println('interface_source_line_id ' || l_detail_rec.source_line_id);
2608: GMI_RESERVATION_UTIL.println('last_update_date ' || sysdate);
2609: GMI_RESERVATION_UTIL.println('last_updated_by ' || FND_GLOBAL.user_id);
2610: GMI_RESERVATION_UTIL.println('creation_date ' || sysdate);
2611: GMI_RESERVATION_UTIL.println('created_by ' || FND_GLOBAL.user_id);
2604: GMI_RESERVATION_UTIL.println('transaction_id ' || l_transaction_id);
2605: GMI_RESERVATION_UTIL.println('group_id ' || l_group_id);
2606: GMI_RESERVATION_UTIL.println('interface_source_code ' || l_source_code);
2607: GMI_RESERVATION_UTIL.println('interface_source_line_id ' || l_detail_rec.source_line_id);
2608: GMI_RESERVATION_UTIL.println('last_update_date ' || sysdate);
2609: GMI_RESERVATION_UTIL.println('last_updated_by ' || FND_GLOBAL.user_id);
2610: GMI_RESERVATION_UTIL.println('creation_date ' || sysdate);
2611: GMI_RESERVATION_UTIL.println('created_by ' || FND_GLOBAL.user_id);
2612: GMI_RESERVATION_UTIL.println('item_id ' || l_detail_rec.inventory_item_id);
2605: GMI_RESERVATION_UTIL.println('group_id ' || l_group_id);
2606: GMI_RESERVATION_UTIL.println('interface_source_code ' || l_source_code);
2607: GMI_RESERVATION_UTIL.println('interface_source_line_id ' || l_detail_rec.source_line_id);
2608: GMI_RESERVATION_UTIL.println('last_update_date ' || sysdate);
2609: GMI_RESERVATION_UTIL.println('last_updated_by ' || FND_GLOBAL.user_id);
2610: GMI_RESERVATION_UTIL.println('creation_date ' || sysdate);
2611: GMI_RESERVATION_UTIL.println('created_by ' || FND_GLOBAL.user_id);
2612: GMI_RESERVATION_UTIL.println('item_id ' || l_detail_rec.inventory_item_id);
2613: GMI_RESERVATION_UTIL.println('item_revision ' || l_detail_rec.revision);
2606: GMI_RESERVATION_UTIL.println('interface_source_code ' || l_source_code);
2607: GMI_RESERVATION_UTIL.println('interface_source_line_id ' || l_detail_rec.source_line_id);
2608: GMI_RESERVATION_UTIL.println('last_update_date ' || sysdate);
2609: GMI_RESERVATION_UTIL.println('last_updated_by ' || FND_GLOBAL.user_id);
2610: GMI_RESERVATION_UTIL.println('creation_date ' || sysdate);
2611: GMI_RESERVATION_UTIL.println('created_by ' || FND_GLOBAL.user_id);
2612: GMI_RESERVATION_UTIL.println('item_id ' || l_detail_rec.inventory_item_id);
2613: GMI_RESERVATION_UTIL.println('item_revision ' || l_detail_rec.revision);
2614: GMI_RESERVATION_UTIL.println('from_org_id ' || l_detail_rec.organization_id);
2607: GMI_RESERVATION_UTIL.println('interface_source_line_id ' || l_detail_rec.source_line_id);
2608: GMI_RESERVATION_UTIL.println('last_update_date ' || sysdate);
2609: GMI_RESERVATION_UTIL.println('last_updated_by ' || FND_GLOBAL.user_id);
2610: GMI_RESERVATION_UTIL.println('creation_date ' || sysdate);
2611: GMI_RESERVATION_UTIL.println('created_by ' || FND_GLOBAL.user_id);
2612: GMI_RESERVATION_UTIL.println('item_id ' || l_detail_rec.inventory_item_id);
2613: GMI_RESERVATION_UTIL.println('item_revision ' || l_detail_rec.revision);
2614: GMI_RESERVATION_UTIL.println('from_org_id ' || l_detail_rec.organization_id);
2615: GMI_RESERVATION_UTIL.println('to_org_id ' || l_transfer_organization);
2608: GMI_RESERVATION_UTIL.println('last_update_date ' || sysdate);
2609: GMI_RESERVATION_UTIL.println('last_updated_by ' || FND_GLOBAL.user_id);
2610: GMI_RESERVATION_UTIL.println('creation_date ' || sysdate);
2611: GMI_RESERVATION_UTIL.println('created_by ' || FND_GLOBAL.user_id);
2612: GMI_RESERVATION_UTIL.println('item_id ' || l_detail_rec.inventory_item_id);
2613: GMI_RESERVATION_UTIL.println('item_revision ' || l_detail_rec.revision);
2614: GMI_RESERVATION_UTIL.println('from_org_id ' || l_detail_rec.organization_id);
2615: GMI_RESERVATION_UTIL.println('to_org_id ' || l_transfer_organization);
2616: GMI_RESERVATION_UTIL.println('intrasit_owning_org_id ' || l_transfer_organization);
2609: GMI_RESERVATION_UTIL.println('last_updated_by ' || FND_GLOBAL.user_id);
2610: GMI_RESERVATION_UTIL.println('creation_date ' || sysdate);
2611: GMI_RESERVATION_UTIL.println('created_by ' || FND_GLOBAL.user_id);
2612: GMI_RESERVATION_UTIL.println('item_id ' || l_detail_rec.inventory_item_id);
2613: GMI_RESERVATION_UTIL.println('item_revision ' || l_detail_rec.revision);
2614: GMI_RESERVATION_UTIL.println('from_org_id ' || l_detail_rec.organization_id);
2615: GMI_RESERVATION_UTIL.println('to_org_id ' || l_transfer_organization);
2616: GMI_RESERVATION_UTIL.println('intrasit_owning_org_id ' || l_transfer_organization);
2617: GMI_RESERVATION_UTIL.println('quantity ' || l_del_ship_qty);
2610: GMI_RESERVATION_UTIL.println('creation_date ' || sysdate);
2611: GMI_RESERVATION_UTIL.println('created_by ' || FND_GLOBAL.user_id);
2612: GMI_RESERVATION_UTIL.println('item_id ' || l_detail_rec.inventory_item_id);
2613: GMI_RESERVATION_UTIL.println('item_revision ' || l_detail_rec.revision);
2614: GMI_RESERVATION_UTIL.println('from_org_id ' || l_detail_rec.organization_id);
2615: GMI_RESERVATION_UTIL.println('to_org_id ' || l_transfer_organization);
2616: GMI_RESERVATION_UTIL.println('intrasit_owning_org_id ' || l_transfer_organization);
2617: GMI_RESERVATION_UTIL.println('quantity ' || l_del_ship_qty);
2618: GMI_RESERVATION_UTIL.println('unit_of_measure ' || l_detail_rec.requested_quantity_uom);
2611: GMI_RESERVATION_UTIL.println('created_by ' || FND_GLOBAL.user_id);
2612: GMI_RESERVATION_UTIL.println('item_id ' || l_detail_rec.inventory_item_id);
2613: GMI_RESERVATION_UTIL.println('item_revision ' || l_detail_rec.revision);
2614: GMI_RESERVATION_UTIL.println('from_org_id ' || l_detail_rec.organization_id);
2615: GMI_RESERVATION_UTIL.println('to_org_id ' || l_transfer_organization);
2616: GMI_RESERVATION_UTIL.println('intrasit_owning_org_id ' || l_transfer_organization);
2617: GMI_RESERVATION_UTIL.println('quantity ' || l_del_ship_qty);
2618: GMI_RESERVATION_UTIL.println('unit_of_measure ' || l_detail_rec.requested_quantity_uom);
2619: GMI_RESERVATION_UTIL.println('uom_code ' || l_del_ship_qty_uom);
2612: GMI_RESERVATION_UTIL.println('item_id ' || l_detail_rec.inventory_item_id);
2613: GMI_RESERVATION_UTIL.println('item_revision ' || l_detail_rec.revision);
2614: GMI_RESERVATION_UTIL.println('from_org_id ' || l_detail_rec.organization_id);
2615: GMI_RESERVATION_UTIL.println('to_org_id ' || l_transfer_organization);
2616: GMI_RESERVATION_UTIL.println('intrasit_owning_org_id ' || l_transfer_organization);
2617: GMI_RESERVATION_UTIL.println('quantity ' || l_del_ship_qty);
2618: GMI_RESERVATION_UTIL.println('unit_of_measure ' || l_detail_rec.requested_quantity_uom);
2619: GMI_RESERVATION_UTIL.println('uom_code ' || l_del_ship_qty_uom);
2620: GMI_RESERVATION_UTIL.println('secondary_quantity ' || l_detail_rec.shipped_quantity2);
2613: GMI_RESERVATION_UTIL.println('item_revision ' || l_detail_rec.revision);
2614: GMI_RESERVATION_UTIL.println('from_org_id ' || l_detail_rec.organization_id);
2615: GMI_RESERVATION_UTIL.println('to_org_id ' || l_transfer_organization);
2616: GMI_RESERVATION_UTIL.println('intrasit_owning_org_id ' || l_transfer_organization);
2617: GMI_RESERVATION_UTIL.println('quantity ' || l_del_ship_qty);
2618: GMI_RESERVATION_UTIL.println('unit_of_measure ' || l_detail_rec.requested_quantity_uom);
2619: GMI_RESERVATION_UTIL.println('uom_code ' || l_del_ship_qty_uom);
2620: GMI_RESERVATION_UTIL.println('secondary_quantity ' || l_detail_rec.shipped_quantity2);
2621: GMI_RESERVATION_UTIL.println('secondary_uom_code ' || l_detail_rec.requested_quantity_uom2);
2614: GMI_RESERVATION_UTIL.println('from_org_id ' || l_detail_rec.organization_id);
2615: GMI_RESERVATION_UTIL.println('to_org_id ' || l_transfer_organization);
2616: GMI_RESERVATION_UTIL.println('intrasit_owning_org_id ' || l_transfer_organization);
2617: GMI_RESERVATION_UTIL.println('quantity ' || l_del_ship_qty);
2618: GMI_RESERVATION_UTIL.println('unit_of_measure ' || l_detail_rec.requested_quantity_uom);
2619: GMI_RESERVATION_UTIL.println('uom_code ' || l_del_ship_qty_uom);
2620: GMI_RESERVATION_UTIL.println('secondary_quantity ' || l_detail_rec.shipped_quantity2);
2621: GMI_RESERVATION_UTIL.println('secondary_uom_code ' || l_detail_rec.requested_quantity_uom2);
2622: GMI_RESERVATION_UTIL.println('secondary_unit_of_measure ' || l_secondary_unit_of_measure);
2615: GMI_RESERVATION_UTIL.println('to_org_id ' || l_transfer_organization);
2616: GMI_RESERVATION_UTIL.println('intrasit_owning_org_id ' || l_transfer_organization);
2617: GMI_RESERVATION_UTIL.println('quantity ' || l_del_ship_qty);
2618: GMI_RESERVATION_UTIL.println('unit_of_measure ' || l_detail_rec.requested_quantity_uom);
2619: GMI_RESERVATION_UTIL.println('uom_code ' || l_del_ship_qty_uom);
2620: GMI_RESERVATION_UTIL.println('secondary_quantity ' || l_detail_rec.shipped_quantity2);
2621: GMI_RESERVATION_UTIL.println('secondary_uom_code ' || l_detail_rec.requested_quantity_uom2);
2622: GMI_RESERVATION_UTIL.println('secondary_unit_of_measure ' || l_secondary_unit_of_measure);
2623: GMI_RESERVATION_UTIL.println('primary_qty ' || null);
2616: GMI_RESERVATION_UTIL.println('intrasit_owning_org_id ' || l_transfer_organization);
2617: GMI_RESERVATION_UTIL.println('quantity ' || l_del_ship_qty);
2618: GMI_RESERVATION_UTIL.println('unit_of_measure ' || l_detail_rec.requested_quantity_uom);
2619: GMI_RESERVATION_UTIL.println('uom_code ' || l_del_ship_qty_uom);
2620: GMI_RESERVATION_UTIL.println('secondary_quantity ' || l_detail_rec.shipped_quantity2);
2621: GMI_RESERVATION_UTIL.println('secondary_uom_code ' || l_detail_rec.requested_quantity_uom2);
2622: GMI_RESERVATION_UTIL.println('secondary_unit_of_measure ' || l_secondary_unit_of_measure);
2623: GMI_RESERVATION_UTIL.println('primary_qty ' || null);
2624: GMI_RESERVATION_UTIL.println('primary_uom ' || null);
2617: GMI_RESERVATION_UTIL.println('quantity ' || l_del_ship_qty);
2618: GMI_RESERVATION_UTIL.println('unit_of_measure ' || l_detail_rec.requested_quantity_uom);
2619: GMI_RESERVATION_UTIL.println('uom_code ' || l_del_ship_qty_uom);
2620: GMI_RESERVATION_UTIL.println('secondary_quantity ' || l_detail_rec.shipped_quantity2);
2621: GMI_RESERVATION_UTIL.println('secondary_uom_code ' || l_detail_rec.requested_quantity_uom2);
2622: GMI_RESERVATION_UTIL.println('secondary_unit_of_measure ' || l_secondary_unit_of_measure);
2623: GMI_RESERVATION_UTIL.println('primary_qty ' || null);
2624: GMI_RESERVATION_UTIL.println('primary_uom ' || null);
2625: GMI_RESERVATION_UTIL.println('transaction_type ' || 'SHIP');
2618: GMI_RESERVATION_UTIL.println('unit_of_measure ' || l_detail_rec.requested_quantity_uom);
2619: GMI_RESERVATION_UTIL.println('uom_code ' || l_del_ship_qty_uom);
2620: GMI_RESERVATION_UTIL.println('secondary_quantity ' || l_detail_rec.shipped_quantity2);
2621: GMI_RESERVATION_UTIL.println('secondary_uom_code ' || l_detail_rec.requested_quantity_uom2);
2622: GMI_RESERVATION_UTIL.println('secondary_unit_of_measure ' || l_secondary_unit_of_measure);
2623: GMI_RESERVATION_UTIL.println('primary_qty ' || null);
2624: GMI_RESERVATION_UTIL.println('primary_uom ' || null);
2625: GMI_RESERVATION_UTIL.println('transaction_type ' || 'SHIP');
2626: GMI_RESERVATION_UTIL.println('transaction_date ' || l_trip_stop_rec.actual_departure_date);
2619: GMI_RESERVATION_UTIL.println('uom_code ' || l_del_ship_qty_uom);
2620: GMI_RESERVATION_UTIL.println('secondary_quantity ' || l_detail_rec.shipped_quantity2);
2621: GMI_RESERVATION_UTIL.println('secondary_uom_code ' || l_detail_rec.requested_quantity_uom2);
2622: GMI_RESERVATION_UTIL.println('secondary_unit_of_measure ' || l_secondary_unit_of_measure);
2623: GMI_RESERVATION_UTIL.println('primary_qty ' || null);
2624: GMI_RESERVATION_UTIL.println('primary_uom ' || null);
2625: GMI_RESERVATION_UTIL.println('transaction_type ' || 'SHIP');
2626: GMI_RESERVATION_UTIL.println('transaction_date ' || l_trip_stop_rec.actual_departure_date);
2627: GMI_RESERVATION_UTIL.println('shipment_num ' || l_delivery_id);
2620: GMI_RESERVATION_UTIL.println('secondary_quantity ' || l_detail_rec.shipped_quantity2);
2621: GMI_RESERVATION_UTIL.println('secondary_uom_code ' || l_detail_rec.requested_quantity_uom2);
2622: GMI_RESERVATION_UTIL.println('secondary_unit_of_measure ' || l_secondary_unit_of_measure);
2623: GMI_RESERVATION_UTIL.println('primary_qty ' || null);
2624: GMI_RESERVATION_UTIL.println('primary_uom ' || null);
2625: GMI_RESERVATION_UTIL.println('transaction_type ' || 'SHIP');
2626: GMI_RESERVATION_UTIL.println('transaction_date ' || l_trip_stop_rec.actual_departure_date);
2627: GMI_RESERVATION_UTIL.println('shipment_num ' || l_delivery_id);
2628: GMI_RESERVATION_UTIL.println('freight_carrier_code ' || null);
2621: GMI_RESERVATION_UTIL.println('secondary_uom_code ' || l_detail_rec.requested_quantity_uom2);
2622: GMI_RESERVATION_UTIL.println('secondary_unit_of_measure ' || l_secondary_unit_of_measure);
2623: GMI_RESERVATION_UTIL.println('primary_qty ' || null);
2624: GMI_RESERVATION_UTIL.println('primary_uom ' || null);
2625: GMI_RESERVATION_UTIL.println('transaction_type ' || 'SHIP');
2626: GMI_RESERVATION_UTIL.println('transaction_date ' || l_trip_stop_rec.actual_departure_date);
2627: GMI_RESERVATION_UTIL.println('shipment_num ' || l_delivery_id);
2628: GMI_RESERVATION_UTIL.println('freight_carrier_code ' || null);
2629: GMI_RESERVATION_UTIL.println('transfer_cost ' || null);
2622: GMI_RESERVATION_UTIL.println('secondary_unit_of_measure ' || l_secondary_unit_of_measure);
2623: GMI_RESERVATION_UTIL.println('primary_qty ' || null);
2624: GMI_RESERVATION_UTIL.println('primary_uom ' || null);
2625: GMI_RESERVATION_UTIL.println('transaction_type ' || 'SHIP');
2626: GMI_RESERVATION_UTIL.println('transaction_date ' || l_trip_stop_rec.actual_departure_date);
2627: GMI_RESERVATION_UTIL.println('shipment_num ' || l_delivery_id);
2628: GMI_RESERVATION_UTIL.println('freight_carrier_code ' || null);
2629: GMI_RESERVATION_UTIL.println('transfer_cost ' || null);
2630: GMI_RESERVATION_UTIL.println('transportation_cost ' || null);
2623: GMI_RESERVATION_UTIL.println('primary_qty ' || null);
2624: GMI_RESERVATION_UTIL.println('primary_uom ' || null);
2625: GMI_RESERVATION_UTIL.println('transaction_type ' || 'SHIP');
2626: GMI_RESERVATION_UTIL.println('transaction_date ' || l_trip_stop_rec.actual_departure_date);
2627: GMI_RESERVATION_UTIL.println('shipment_num ' || l_delivery_id);
2628: GMI_RESERVATION_UTIL.println('freight_carrier_code ' || null);
2629: GMI_RESERVATION_UTIL.println('transfer_cost ' || null);
2630: GMI_RESERVATION_UTIL.println('transportation_cost ' || null);
2631: GMI_RESERVATION_UTIL.println('transportation_account ' || null);
2624: GMI_RESERVATION_UTIL.println('primary_uom ' || null);
2625: GMI_RESERVATION_UTIL.println('transaction_type ' || 'SHIP');
2626: GMI_RESERVATION_UTIL.println('transaction_date ' || l_trip_stop_rec.actual_departure_date);
2627: GMI_RESERVATION_UTIL.println('shipment_num ' || l_delivery_id);
2628: GMI_RESERVATION_UTIL.println('freight_carrier_code ' || null);
2629: GMI_RESERVATION_UTIL.println('transfer_cost ' || null);
2630: GMI_RESERVATION_UTIL.println('transportation_cost ' || null);
2631: GMI_RESERVATION_UTIL.println('transportation_account ' || null);
2632: GMI_RESERVATION_UTIL.println('number_of_containers ' || null);
2625: GMI_RESERVATION_UTIL.println('transaction_type ' || 'SHIP');
2626: GMI_RESERVATION_UTIL.println('transaction_date ' || l_trip_stop_rec.actual_departure_date);
2627: GMI_RESERVATION_UTIL.println('shipment_num ' || l_delivery_id);
2628: GMI_RESERVATION_UTIL.println('freight_carrier_code ' || null);
2629: GMI_RESERVATION_UTIL.println('transfer_cost ' || null);
2630: GMI_RESERVATION_UTIL.println('transportation_cost ' || null);
2631: GMI_RESERVATION_UTIL.println('transportation_account ' || null);
2632: GMI_RESERVATION_UTIL.println('number_of_containers ' || null);
2633: GMI_RESERVATION_UTIL.println('waybill ' || l_waybill);
2626: GMI_RESERVATION_UTIL.println('transaction_date ' || l_trip_stop_rec.actual_departure_date);
2627: GMI_RESERVATION_UTIL.println('shipment_num ' || l_delivery_id);
2628: GMI_RESERVATION_UTIL.println('freight_carrier_code ' || null);
2629: GMI_RESERVATION_UTIL.println('transfer_cost ' || null);
2630: GMI_RESERVATION_UTIL.println('transportation_cost ' || null);
2631: GMI_RESERVATION_UTIL.println('transportation_account ' || null);
2632: GMI_RESERVATION_UTIL.println('number_of_containers ' || null);
2633: GMI_RESERVATION_UTIL.println('waybill ' || l_waybill);
2634: GMI_RESERVATION_UTIL.println('inventory_transaction_id ' || null);
2627: GMI_RESERVATION_UTIL.println('shipment_num ' || l_delivery_id);
2628: GMI_RESERVATION_UTIL.println('freight_carrier_code ' || null);
2629: GMI_RESERVATION_UTIL.println('transfer_cost ' || null);
2630: GMI_RESERVATION_UTIL.println('transportation_cost ' || null);
2631: GMI_RESERVATION_UTIL.println('transportation_account ' || null);
2632: GMI_RESERVATION_UTIL.println('number_of_containers ' || null);
2633: GMI_RESERVATION_UTIL.println('waybill ' || l_waybill);
2634: GMI_RESERVATION_UTIL.println('inventory_transaction_id ' || null);
2635: GMI_RESERVATION_UTIL.println('destination_type_code ' || l_po_info.destination_type_code);
2628: GMI_RESERVATION_UTIL.println('freight_carrier_code ' || null);
2629: GMI_RESERVATION_UTIL.println('transfer_cost ' || null);
2630: GMI_RESERVATION_UTIL.println('transportation_cost ' || null);
2631: GMI_RESERVATION_UTIL.println('transportation_account ' || null);
2632: GMI_RESERVATION_UTIL.println('number_of_containers ' || null);
2633: GMI_RESERVATION_UTIL.println('waybill ' || l_waybill);
2634: GMI_RESERVATION_UTIL.println('inventory_transaction_id ' || null);
2635: GMI_RESERVATION_UTIL.println('destination_type_code ' || l_po_info.destination_type_code);
2636: --GMI_RESERVATION_UTIL.println('transaction_action_id ' || decode(l_trx_action_id,2,'DELIVER',3,'DELIVER',1,'DELIVER','SHIP'));
2629: GMI_RESERVATION_UTIL.println('transfer_cost ' || null);
2630: GMI_RESERVATION_UTIL.println('transportation_cost ' || null);
2631: GMI_RESERVATION_UTIL.println('transportation_account ' || null);
2632: GMI_RESERVATION_UTIL.println('number_of_containers ' || null);
2633: GMI_RESERVATION_UTIL.println('waybill ' || l_waybill);
2634: GMI_RESERVATION_UTIL.println('inventory_transaction_id ' || null);
2635: GMI_RESERVATION_UTIL.println('destination_type_code ' || l_po_info.destination_type_code);
2636: --GMI_RESERVATION_UTIL.println('transaction_action_id ' || decode(l_trx_action_id,2,'DELIVER',3,'DELIVER',1,'DELIVER','SHIP'));
2637: GMI_RESERVATION_UTIL.println('receipt_source_code ' || 'INTERNAL ORDER');
2630: GMI_RESERVATION_UTIL.println('transportation_cost ' || null);
2631: GMI_RESERVATION_UTIL.println('transportation_account ' || null);
2632: GMI_RESERVATION_UTIL.println('number_of_containers ' || null);
2633: GMI_RESERVATION_UTIL.println('waybill ' || l_waybill);
2634: GMI_RESERVATION_UTIL.println('inventory_transaction_id ' || null);
2635: GMI_RESERVATION_UTIL.println('destination_type_code ' || l_po_info.destination_type_code);
2636: --GMI_RESERVATION_UTIL.println('transaction_action_id ' || decode(l_trx_action_id,2,'DELIVER',3,'DELIVER',1,'DELIVER','SHIP'));
2637: GMI_RESERVATION_UTIL.println('receipt_source_code ' || 'INTERNAL ORDER');
2638: GMI_RESERVATION_UTIL.println('source_document_code ' || 'REQ');
2631: GMI_RESERVATION_UTIL.println('transportation_account ' || null);
2632: GMI_RESERVATION_UTIL.println('number_of_containers ' || null);
2633: GMI_RESERVATION_UTIL.println('waybill ' || l_waybill);
2634: GMI_RESERVATION_UTIL.println('inventory_transaction_id ' || null);
2635: GMI_RESERVATION_UTIL.println('destination_type_code ' || l_po_info.destination_type_code);
2636: --GMI_RESERVATION_UTIL.println('transaction_action_id ' || decode(l_trx_action_id,2,'DELIVER',3,'DELIVER',1,'DELIVER','SHIP'));
2637: GMI_RESERVATION_UTIL.println('receipt_source_code ' || 'INTERNAL ORDER');
2638: GMI_RESERVATION_UTIL.println('source_document_code ' || 'REQ');
2639: GMI_RESERVATION_UTIL.println('processing_status_code ' || 'RUNNING');
2632: GMI_RESERVATION_UTIL.println('number_of_containers ' || null);
2633: GMI_RESERVATION_UTIL.println('waybill ' || l_waybill);
2634: GMI_RESERVATION_UTIL.println('inventory_transaction_id ' || null);
2635: GMI_RESERVATION_UTIL.println('destination_type_code ' || l_po_info.destination_type_code);
2636: --GMI_RESERVATION_UTIL.println('transaction_action_id ' || decode(l_trx_action_id,2,'DELIVER',3,'DELIVER',1,'DELIVER','SHIP'));
2637: GMI_RESERVATION_UTIL.println('receipt_source_code ' || 'INTERNAL ORDER');
2638: GMI_RESERVATION_UTIL.println('source_document_code ' || 'REQ');
2639: GMI_RESERVATION_UTIL.println('processing_status_code ' || 'RUNNING');
2640: GMI_RESERVATION_UTIL.println('transaction_status_code ' || 'PENDING');
2633: GMI_RESERVATION_UTIL.println('waybill ' || l_waybill);
2634: GMI_RESERVATION_UTIL.println('inventory_transaction_id ' || null);
2635: GMI_RESERVATION_UTIL.println('destination_type_code ' || l_po_info.destination_type_code);
2636: --GMI_RESERVATION_UTIL.println('transaction_action_id ' || decode(l_trx_action_id,2,'DELIVER',3,'DELIVER',1,'DELIVER','SHIP'));
2637: GMI_RESERVATION_UTIL.println('receipt_source_code ' || 'INTERNAL ORDER');
2638: GMI_RESERVATION_UTIL.println('source_document_code ' || 'REQ');
2639: GMI_RESERVATION_UTIL.println('processing_status_code ' || 'RUNNING');
2640: GMI_RESERVATION_UTIL.println('transaction_status_code ' || 'PENDING');
2641: GMI_RESERVATION_UTIL.println('processing_code_mode ' || 'ONLINE');
2634: GMI_RESERVATION_UTIL.println('inventory_transaction_id ' || null);
2635: GMI_RESERVATION_UTIL.println('destination_type_code ' || l_po_info.destination_type_code);
2636: --GMI_RESERVATION_UTIL.println('transaction_action_id ' || decode(l_trx_action_id,2,'DELIVER',3,'DELIVER',1,'DELIVER','SHIP'));
2637: GMI_RESERVATION_UTIL.println('receipt_source_code ' || 'INTERNAL ORDER');
2638: GMI_RESERVATION_UTIL.println('source_document_code ' || 'REQ');
2639: GMI_RESERVATION_UTIL.println('processing_status_code ' || 'RUNNING');
2640: GMI_RESERVATION_UTIL.println('transaction_status_code ' || 'PENDING');
2641: GMI_RESERVATION_UTIL.println('processing_code_mode ' || 'ONLINE');
2642: GMI_RESERVATION_UTIL.println('from_subinventory ' || l_detail_rec.subinventory);
2635: GMI_RESERVATION_UTIL.println('destination_type_code ' || l_po_info.destination_type_code);
2636: --GMI_RESERVATION_UTIL.println('transaction_action_id ' || decode(l_trx_action_id,2,'DELIVER',3,'DELIVER',1,'DELIVER','SHIP'));
2637: GMI_RESERVATION_UTIL.println('receipt_source_code ' || 'INTERNAL ORDER');
2638: GMI_RESERVATION_UTIL.println('source_document_code ' || 'REQ');
2639: GMI_RESERVATION_UTIL.println('processing_status_code ' || 'RUNNING');
2640: GMI_RESERVATION_UTIL.println('transaction_status_code ' || 'PENDING');
2641: GMI_RESERVATION_UTIL.println('processing_code_mode ' || 'ONLINE');
2642: GMI_RESERVATION_UTIL.println('from_subinventory ' || l_detail_rec.subinventory);
2643: GMI_RESERVATION_UTIL.println('subinventory ' || l_transfer_subinventory);
2636: --GMI_RESERVATION_UTIL.println('transaction_action_id ' || decode(l_trx_action_id,2,'DELIVER',3,'DELIVER',1,'DELIVER','SHIP'));
2637: GMI_RESERVATION_UTIL.println('receipt_source_code ' || 'INTERNAL ORDER');
2638: GMI_RESERVATION_UTIL.println('source_document_code ' || 'REQ');
2639: GMI_RESERVATION_UTIL.println('processing_status_code ' || 'RUNNING');
2640: GMI_RESERVATION_UTIL.println('transaction_status_code ' || 'PENDING');
2641: GMI_RESERVATION_UTIL.println('processing_code_mode ' || 'ONLINE');
2642: GMI_RESERVATION_UTIL.println('from_subinventory ' || l_detail_rec.subinventory);
2643: GMI_RESERVATION_UTIL.println('subinventory ' || l_transfer_subinventory);
2644: GMI_RESERVATION_UTIL.println('locator_id ' || l_detail_rec.locator_id);
2637: GMI_RESERVATION_UTIL.println('receipt_source_code ' || 'INTERNAL ORDER');
2638: GMI_RESERVATION_UTIL.println('source_document_code ' || 'REQ');
2639: GMI_RESERVATION_UTIL.println('processing_status_code ' || 'RUNNING');
2640: GMI_RESERVATION_UTIL.println('transaction_status_code ' || 'PENDING');
2641: GMI_RESERVATION_UTIL.println('processing_code_mode ' || 'ONLINE');
2642: GMI_RESERVATION_UTIL.println('from_subinventory ' || l_detail_rec.subinventory);
2643: GMI_RESERVATION_UTIL.println('subinventory ' || l_transfer_subinventory);
2644: GMI_RESERVATION_UTIL.println('locator_id ' || l_detail_rec.locator_id);
2645: GMI_RESERVATION_UTIL.println('category_id ' || null);
2638: GMI_RESERVATION_UTIL.println('source_document_code ' || 'REQ');
2639: GMI_RESERVATION_UTIL.println('processing_status_code ' || 'RUNNING');
2640: GMI_RESERVATION_UTIL.println('transaction_status_code ' || 'PENDING');
2641: GMI_RESERVATION_UTIL.println('processing_code_mode ' || 'ONLINE');
2642: GMI_RESERVATION_UTIL.println('from_subinventory ' || l_detail_rec.subinventory);
2643: GMI_RESERVATION_UTIL.println('subinventory ' || l_transfer_subinventory);
2644: GMI_RESERVATION_UTIL.println('locator_id ' || l_detail_rec.locator_id);
2645: GMI_RESERVATION_UTIL.println('category_id ' || null);
2646: GMI_RESERVATION_UTIL.println('expected_receipt_date ' || l_ultimate_dropoff_date);
2639: GMI_RESERVATION_UTIL.println('processing_status_code ' || 'RUNNING');
2640: GMI_RESERVATION_UTIL.println('transaction_status_code ' || 'PENDING');
2641: GMI_RESERVATION_UTIL.println('processing_code_mode ' || 'ONLINE');
2642: GMI_RESERVATION_UTIL.println('from_subinventory ' || l_detail_rec.subinventory);
2643: GMI_RESERVATION_UTIL.println('subinventory ' || l_transfer_subinventory);
2644: GMI_RESERVATION_UTIL.println('locator_id ' || l_detail_rec.locator_id);
2645: GMI_RESERVATION_UTIL.println('category_id ' || null);
2646: GMI_RESERVATION_UTIL.println('expected_receipt_date ' || l_ultimate_dropoff_date);
2647: GMI_RESERVATION_UTIL.println('currency_code ' || null);
2640: GMI_RESERVATION_UTIL.println('transaction_status_code ' || 'PENDING');
2641: GMI_RESERVATION_UTIL.println('processing_code_mode ' || 'ONLINE');
2642: GMI_RESERVATION_UTIL.println('from_subinventory ' || l_detail_rec.subinventory);
2643: GMI_RESERVATION_UTIL.println('subinventory ' || l_transfer_subinventory);
2644: GMI_RESERVATION_UTIL.println('locator_id ' || l_detail_rec.locator_id);
2645: GMI_RESERVATION_UTIL.println('category_id ' || null);
2646: GMI_RESERVATION_UTIL.println('expected_receipt_date ' || l_ultimate_dropoff_date);
2647: GMI_RESERVATION_UTIL.println('currency_code ' || null);
2648: GMI_RESERVATION_UTIL.println('currency_conversion_rate ' || null);
2641: GMI_RESERVATION_UTIL.println('processing_code_mode ' || 'ONLINE');
2642: GMI_RESERVATION_UTIL.println('from_subinventory ' || l_detail_rec.subinventory);
2643: GMI_RESERVATION_UTIL.println('subinventory ' || l_transfer_subinventory);
2644: GMI_RESERVATION_UTIL.println('locator_id ' || l_detail_rec.locator_id);
2645: GMI_RESERVATION_UTIL.println('category_id ' || null);
2646: GMI_RESERVATION_UTIL.println('expected_receipt_date ' || l_ultimate_dropoff_date);
2647: GMI_RESERVATION_UTIL.println('currency_code ' || null);
2648: GMI_RESERVATION_UTIL.println('currency_conversion_rate ' || null);
2649: GMI_RESERVATION_UTIL.println('currency_conversion_date ' || SYSDATE);
2642: GMI_RESERVATION_UTIL.println('from_subinventory ' || l_detail_rec.subinventory);
2643: GMI_RESERVATION_UTIL.println('subinventory ' || l_transfer_subinventory);
2644: GMI_RESERVATION_UTIL.println('locator_id ' || l_detail_rec.locator_id);
2645: GMI_RESERVATION_UTIL.println('category_id ' || null);
2646: GMI_RESERVATION_UTIL.println('expected_receipt_date ' || l_ultimate_dropoff_date);
2647: GMI_RESERVATION_UTIL.println('currency_code ' || null);
2648: GMI_RESERVATION_UTIL.println('currency_conversion_rate ' || null);
2649: GMI_RESERVATION_UTIL.println('currency_conversion_date ' || SYSDATE);
2650: GMI_RESERVATION_UTIL.println('currency_conversion_type ' || null);
2643: GMI_RESERVATION_UTIL.println('subinventory ' || l_transfer_subinventory);
2644: GMI_RESERVATION_UTIL.println('locator_id ' || l_detail_rec.locator_id);
2645: GMI_RESERVATION_UTIL.println('category_id ' || null);
2646: GMI_RESERVATION_UTIL.println('expected_receipt_date ' || l_ultimate_dropoff_date);
2647: GMI_RESERVATION_UTIL.println('currency_code ' || null);
2648: GMI_RESERVATION_UTIL.println('currency_conversion_rate ' || null);
2649: GMI_RESERVATION_UTIL.println('currency_conversion_date ' || SYSDATE);
2650: GMI_RESERVATION_UTIL.println('currency_conversion_type ' || null);
2651: GMI_RESERVATION_UTIL.println('ussgl_transaction_code ' || null);
2644: GMI_RESERVATION_UTIL.println('locator_id ' || l_detail_rec.locator_id);
2645: GMI_RESERVATION_UTIL.println('category_id ' || null);
2646: GMI_RESERVATION_UTIL.println('expected_receipt_date ' || l_ultimate_dropoff_date);
2647: GMI_RESERVATION_UTIL.println('currency_code ' || null);
2648: GMI_RESERVATION_UTIL.println('currency_conversion_rate ' || null);
2649: GMI_RESERVATION_UTIL.println('currency_conversion_date ' || SYSDATE);
2650: GMI_RESERVATION_UTIL.println('currency_conversion_type ' || null);
2651: GMI_RESERVATION_UTIL.println('ussgl_transaction_code ' || null);
2652: GMI_RESERVATION_UTIL.println('ship_to_location_id ' || l_ship_to_location_id);
2645: GMI_RESERVATION_UTIL.println('category_id ' || null);
2646: GMI_RESERVATION_UTIL.println('expected_receipt_date ' || l_ultimate_dropoff_date);
2647: GMI_RESERVATION_UTIL.println('currency_code ' || null);
2648: GMI_RESERVATION_UTIL.println('currency_conversion_rate ' || null);
2649: GMI_RESERVATION_UTIL.println('currency_conversion_date ' || SYSDATE);
2650: GMI_RESERVATION_UTIL.println('currency_conversion_type ' || null);
2651: GMI_RESERVATION_UTIL.println('ussgl_transaction_code ' || null);
2652: GMI_RESERVATION_UTIL.println('ship_to_location_id ' || l_ship_to_location_id);
2653: GMI_RESERVATION_UTIL.println('requisition_line_id ' || l_requisition_line_id);
2646: GMI_RESERVATION_UTIL.println('expected_receipt_date ' || l_ultimate_dropoff_date);
2647: GMI_RESERVATION_UTIL.println('currency_code ' || null);
2648: GMI_RESERVATION_UTIL.println('currency_conversion_rate ' || null);
2649: GMI_RESERVATION_UTIL.println('currency_conversion_date ' || SYSDATE);
2650: GMI_RESERVATION_UTIL.println('currency_conversion_type ' || null);
2651: GMI_RESERVATION_UTIL.println('ussgl_transaction_code ' || null);
2652: GMI_RESERVATION_UTIL.println('ship_to_location_id ' || l_ship_to_location_id);
2653: GMI_RESERVATION_UTIL.println('requisition_line_id ' || l_requisition_line_id);
2654: GMI_RESERVATION_UTIL.println('req_distribution_id ' || l_req_distribution_id);
2647: GMI_RESERVATION_UTIL.println('currency_code ' || null);
2648: GMI_RESERVATION_UTIL.println('currency_conversion_rate ' || null);
2649: GMI_RESERVATION_UTIL.println('currency_conversion_date ' || SYSDATE);
2650: GMI_RESERVATION_UTIL.println('currency_conversion_type ' || null);
2651: GMI_RESERVATION_UTIL.println('ussgl_transaction_code ' || null);
2652: GMI_RESERVATION_UTIL.println('ship_to_location_id ' || l_ship_to_location_id);
2653: GMI_RESERVATION_UTIL.println('requisition_line_id ' || l_requisition_line_id);
2654: GMI_RESERVATION_UTIL.println('req_distribution_id ' || l_req_distribution_id);
2655: GMI_RESERVATION_UTIL.println('item_description ' || l_item_desc);
2648: GMI_RESERVATION_UTIL.println('currency_conversion_rate ' || null);
2649: GMI_RESERVATION_UTIL.println('currency_conversion_date ' || SYSDATE);
2650: GMI_RESERVATION_UTIL.println('currency_conversion_type ' || null);
2651: GMI_RESERVATION_UTIL.println('ussgl_transaction_code ' || null);
2652: GMI_RESERVATION_UTIL.println('ship_to_location_id ' || l_ship_to_location_id);
2653: GMI_RESERVATION_UTIL.println('requisition_line_id ' || l_requisition_line_id);
2654: GMI_RESERVATION_UTIL.println('req_distribution_id ' || l_req_distribution_id);
2655: GMI_RESERVATION_UTIL.println('item_description ' || l_item_desc);
2656: GMI_RESERVATION_UTIL.println('shipped_date ' || l_trip_stop_rec.actual_departure_date);
2649: GMI_RESERVATION_UTIL.println('currency_conversion_date ' || SYSDATE);
2650: GMI_RESERVATION_UTIL.println('currency_conversion_type ' || null);
2651: GMI_RESERVATION_UTIL.println('ussgl_transaction_code ' || null);
2652: GMI_RESERVATION_UTIL.println('ship_to_location_id ' || l_ship_to_location_id);
2653: GMI_RESERVATION_UTIL.println('requisition_line_id ' || l_requisition_line_id);
2654: GMI_RESERVATION_UTIL.println('req_distribution_id ' || l_req_distribution_id);
2655: GMI_RESERVATION_UTIL.println('item_description ' || l_item_desc);
2656: GMI_RESERVATION_UTIL.println('shipped_date ' || l_trip_stop_rec.actual_departure_date);
2657: GMI_RESERVATION_UTIL.println('routing_header_id ' || null);
2650: GMI_RESERVATION_UTIL.println('currency_conversion_type ' || null);
2651: GMI_RESERVATION_UTIL.println('ussgl_transaction_code ' || null);
2652: GMI_RESERVATION_UTIL.println('ship_to_location_id ' || l_ship_to_location_id);
2653: GMI_RESERVATION_UTIL.println('requisition_line_id ' || l_requisition_line_id);
2654: GMI_RESERVATION_UTIL.println('req_distribution_id ' || l_req_distribution_id);
2655: GMI_RESERVATION_UTIL.println('item_description ' || l_item_desc);
2656: GMI_RESERVATION_UTIL.println('shipped_date ' || l_trip_stop_rec.actual_departure_date);
2657: GMI_RESERVATION_UTIL.println('routing_header_id ' || null);
2658: GMI_RESERVATION_UTIL.println('reason_id ' || null);
2651: GMI_RESERVATION_UTIL.println('ussgl_transaction_code ' || null);
2652: GMI_RESERVATION_UTIL.println('ship_to_location_id ' || l_ship_to_location_id);
2653: GMI_RESERVATION_UTIL.println('requisition_line_id ' || l_requisition_line_id);
2654: GMI_RESERVATION_UTIL.println('req_distribution_id ' || l_req_distribution_id);
2655: GMI_RESERVATION_UTIL.println('item_description ' || l_item_desc);
2656: GMI_RESERVATION_UTIL.println('shipped_date ' || l_trip_stop_rec.actual_departure_date);
2657: GMI_RESERVATION_UTIL.println('routing_header_id ' || null);
2658: GMI_RESERVATION_UTIL.println('reason_id ' || null);
2659: GMI_RESERVATION_UTIL.println('movement_id ' || null);
2652: GMI_RESERVATION_UTIL.println('ship_to_location_id ' || l_ship_to_location_id);
2653: GMI_RESERVATION_UTIL.println('requisition_line_id ' || l_requisition_line_id);
2654: GMI_RESERVATION_UTIL.println('req_distribution_id ' || l_req_distribution_id);
2655: GMI_RESERVATION_UTIL.println('item_description ' || l_item_desc);
2656: GMI_RESERVATION_UTIL.println('shipped_date ' || l_trip_stop_rec.actual_departure_date);
2657: GMI_RESERVATION_UTIL.println('routing_header_id ' || null);
2658: GMI_RESERVATION_UTIL.println('reason_id ' || null);
2659: GMI_RESERVATION_UTIL.println('movement_id ' || null);
2660: GMI_RESERVATION_UTIL.println('transfer_percentage ' || null);
2653: GMI_RESERVATION_UTIL.println('requisition_line_id ' || l_requisition_line_id);
2654: GMI_RESERVATION_UTIL.println('req_distribution_id ' || l_req_distribution_id);
2655: GMI_RESERVATION_UTIL.println('item_description ' || l_item_desc);
2656: GMI_RESERVATION_UTIL.println('shipped_date ' || l_trip_stop_rec.actual_departure_date);
2657: GMI_RESERVATION_UTIL.println('routing_header_id ' || null);
2658: GMI_RESERVATION_UTIL.println('reason_id ' || null);
2659: GMI_RESERVATION_UTIL.println('movement_id ' || null);
2660: GMI_RESERVATION_UTIL.println('transfer_percentage ' || null);
2661:
2654: GMI_RESERVATION_UTIL.println('req_distribution_id ' || l_req_distribution_id);
2655: GMI_RESERVATION_UTIL.println('item_description ' || l_item_desc);
2656: GMI_RESERVATION_UTIL.println('shipped_date ' || l_trip_stop_rec.actual_departure_date);
2657: GMI_RESERVATION_UTIL.println('routing_header_id ' || null);
2658: GMI_RESERVATION_UTIL.println('reason_id ' || null);
2659: GMI_RESERVATION_UTIL.println('movement_id ' || null);
2660: GMI_RESERVATION_UTIL.println('transfer_percentage ' || null);
2661:
2662: /* Bug # 3363725 , punkumar , modified insert sql to insert delivery_detail_id in comments column */
2655: GMI_RESERVATION_UTIL.println('item_description ' || l_item_desc);
2656: GMI_RESERVATION_UTIL.println('shipped_date ' || l_trip_stop_rec.actual_departure_date);
2657: GMI_RESERVATION_UTIL.println('routing_header_id ' || null);
2658: GMI_RESERVATION_UTIL.println('reason_id ' || null);
2659: GMI_RESERVATION_UTIL.println('movement_id ' || null);
2660: GMI_RESERVATION_UTIL.println('transfer_percentage ' || null);
2661:
2662: /* Bug # 3363725 , punkumar , modified insert sql to insert delivery_detail_id in comments column */
2663:
2656: GMI_RESERVATION_UTIL.println('shipped_date ' || l_trip_stop_rec.actual_departure_date);
2657: GMI_RESERVATION_UTIL.println('routing_header_id ' || null);
2658: GMI_RESERVATION_UTIL.println('reason_id ' || null);
2659: GMI_RESERVATION_UTIL.println('movement_id ' || null);
2660: GMI_RESERVATION_UTIL.println('transfer_percentage ' || null);
2661:
2662: /* Bug # 3363725 , punkumar , modified insert sql to insert delivery_detail_id in comments column */
2663:
2664: INSERT INTO RCV_TRANSACTIONS_INTERFACE
2788: 'OPM WDD:' || to_char(l_detail_rec.delivery_detail_id )
2789: );
2790: --decode(l_trx_action_id,3,l_transfer_organization,l_detail_rec.organization_id), /* from_organization_id */
2791: --decode(l_trx_action_id,3,l_detail_rec.organization_id,l_transfer_organization), /* to_organization_id */
2792: GMI_reservation_Util.PrintLn(
2793: 'in create_rcv_transaction: for inserting in RCV_TRANSACTIONS_INTERFACE, sqlcode is '||SQLCODE||'.');
2794: End if;
2795: EXCEPTION
2796: WHEN OTHERS THEN
2793: 'in create_rcv_transaction: for inserting in RCV_TRANSACTIONS_INTERFACE, sqlcode is '||SQLCODE||'.');
2794: End if;
2795: EXCEPTION
2796: WHEN OTHERS THEN
2797: GMI_reservation_Util.PrintLn(
2798: 'in create_rcv_transaction: for inserting in RCV_TRANSACTIONS_INTERFACE, sqlcode is '||SQLCODE||'.');
2799:
2800: END create_rcv_transaction;
2801:
2873:
2874: l_if_internal := 0 ;
2875:
2876:
2877: GMI_RESERVATION_UTIL.Println ('in GMI process_OPM_orders for stop '||p_stop_id );
2878:
2879: FOR del IN pickup_deliveries LOOP
2880: l_delivery_id := del.delivery_id;
2881: GMI_RESERVATION_UTIL.Println ('in GMI found delivery' || l_delivery_id);
2877: GMI_RESERVATION_UTIL.Println ('in GMI process_OPM_orders for stop '||p_stop_id );
2878:
2879: FOR del IN pickup_deliveries LOOP
2880: l_delivery_id := del.delivery_id;
2881: GMI_RESERVATION_UTIL.Println ('in GMI found delivery' || l_delivery_id);
2882: OPEN c_detail_in_delivery ;
2883: LOOP
2884: FETCH c_detail_in_delivery into l_detail_in_delivery;
2885: EXIT WHEN c_detail_in_delivery%NOTFOUND;
2888: FETCH c_order_line_info into l_order_line_info;
2889: if (c_order_line_info%NOTFOUND) THEN
2890: CLOSE c_order_line_info;
2891: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2892: GMI_RESERVATION_UTIL.Println('Warning, Sales order not valid');
2893: CLOSE c_detail_in_delivery; /* B2886561 close this cursor before return */
2894: return;
2895: END if;
2896: CLOSE c_order_line_info;
2930: end if;
2931: oe_debug_pub.add('Found Trip Stop '|| p_stop_id);
2932: CLOSE c_trip_stop;
2933:
2934: GMI_RESERVATION_UTIL.Println ('found internal order line in this delivery ' || l_delivery_id);
2935: -- internal orders, insert into rcv_transactions_interface
2936: Oe_Debug_Pub.Add('This line is part of an internal order');
2937: GMI_SHIPPING_UTIL.create_rcv_transaction
2938: ( p_shipping_line => l_detail_rec
3429: l_new_delivery_detail_id := p_new_delivery_detail_id;
3430: IF ( p_released_status = 'Y' )
3431: THEN
3432: oe_debug_pub.add('Calling update_opm_transaction.',2);
3433: GMI_RESERVATION_UTIL.println('splitting the OPM inv, update_opm_transaction', 'opm.log');
3434:
3435: GMI_SHIPPING_UTIL.update_opm_transaction(
3436: p_old_delivery_detail_id => p_old_delivery_detail_id,
3437: p_lot_number => p_lot_number,
3475: WHEN NO_DATA_FOUND THEN
3476: rollback to update_txn;
3477: x_return_status := FND_API.G_RET_STS_ERROR;
3478: RAISE NO_DATA_FOUND;
3479: GMI_RESERVATION_UTIL.Println('Raised When No Data Found in split_opm_trans');
3480:
3481: WHEN OTHERS THEN
3482: rollback to split_txn;
3483: x_return_status := FND_API.G_RET_STS_ERROR;
3480:
3481: WHEN OTHERS THEN
3482: rollback to split_txn;
3483: x_return_status := FND_API.G_RET_STS_ERROR;
3484: GMI_RESERVATION_UTIL.Println('Raised When Others in split_opm_trans');
3485: END split_opm_trans;
3486:
3487: /* this procedure fulfills the trans for the old dd and updates the rest of
3488: trans for the new dd
3569: AND staged_ind = 1
3570: AND trans_qty <> 0;
3571:
3572: BEGIN
3573: GMI_RESERVATION_UTIL.Println(' in split_trans');
3574: GMI_RESERVATION_UTIL.Println(' p_old_delivery_detail_id '||p_old_delivery_detail_id);
3575: GMI_RESERVATION_UTIL.Println(' p_new_delivery_detail_id '||p_new_delivery_detail_id);
3576: GMI_RESERVATION_UTIL.Println(' p_old_source_line_id '||p_old_source_line_id);
3577: GMI_RESERVATION_UTIL.Println(' p_new_source_line_id '||p_new_source_line_id);
3570: AND trans_qty <> 0;
3571:
3572: BEGIN
3573: GMI_RESERVATION_UTIL.Println(' in split_trans');
3574: GMI_RESERVATION_UTIL.Println(' p_old_delivery_detail_id '||p_old_delivery_detail_id);
3575: GMI_RESERVATION_UTIL.Println(' p_new_delivery_detail_id '||p_new_delivery_detail_id);
3576: GMI_RESERVATION_UTIL.Println(' p_old_source_line_id '||p_old_source_line_id);
3577: GMI_RESERVATION_UTIL.Println(' p_new_source_line_id '||p_new_source_line_id);
3578: l_fulfilled_qty := 0;
3571:
3572: BEGIN
3573: GMI_RESERVATION_UTIL.Println(' in split_trans');
3574: GMI_RESERVATION_UTIL.Println(' p_old_delivery_detail_id '||p_old_delivery_detail_id);
3575: GMI_RESERVATION_UTIL.Println(' p_new_delivery_detail_id '||p_new_delivery_detail_id);
3576: GMI_RESERVATION_UTIL.Println(' p_old_source_line_id '||p_old_source_line_id);
3577: GMI_RESERVATION_UTIL.Println(' p_new_source_line_id '||p_new_source_line_id);
3578: l_fulfilled_qty := 0;
3579:
3572: BEGIN
3573: GMI_RESERVATION_UTIL.Println(' in split_trans');
3574: GMI_RESERVATION_UTIL.Println(' p_old_delivery_detail_id '||p_old_delivery_detail_id);
3575: GMI_RESERVATION_UTIL.Println(' p_new_delivery_detail_id '||p_new_delivery_detail_id);
3576: GMI_RESERVATION_UTIL.Println(' p_old_source_line_id '||p_old_source_line_id);
3577: GMI_RESERVATION_UTIL.Println(' p_new_source_line_id '||p_new_source_line_id);
3578: l_fulfilled_qty := 0;
3579:
3580: Open get_original_qty;
3573: GMI_RESERVATION_UTIL.Println(' in split_trans');
3574: GMI_RESERVATION_UTIL.Println(' p_old_delivery_detail_id '||p_old_delivery_detail_id);
3575: GMI_RESERVATION_UTIL.Println(' p_new_delivery_detail_id '||p_new_delivery_detail_id);
3576: GMI_RESERVATION_UTIL.Println(' p_old_source_line_id '||p_old_source_line_id);
3577: GMI_RESERVATION_UTIL.Println(' p_new_source_line_id '||p_new_source_line_id);
3578: l_fulfilled_qty := 0;
3579:
3580: Open get_original_qty;
3581: Fetch get_original_qty
3606:
3607: l_qty_to_fulfil := l_orig_qty - p_qty_to_split;
3608: l_qty2_to_fulfil := l_orig_qty2 - p_qty2_to_split;
3609:
3610: GMI_RESERVATION_UTIL.Println('in split_trans');
3611: GMI_RESERVATION_UTIL.Println('in split_trans, relased_status '||l_released_status);
3612: GMI_RESERVATION_UTIL.Println('in split_trans, qty to split'||p_qty_to_split);
3613: GMI_RESERVATION_UTIL.Println('in split_trans, qty2 to split'||p_qty2_to_split);
3614: GMI_RESERVATION_UTIL.Println('in split_trans, qty to fulfil'||l_qty_to_fulfil);
3607: l_qty_to_fulfil := l_orig_qty - p_qty_to_split;
3608: l_qty2_to_fulfil := l_orig_qty2 - p_qty2_to_split;
3609:
3610: GMI_RESERVATION_UTIL.Println('in split_trans');
3611: GMI_RESERVATION_UTIL.Println('in split_trans, relased_status '||l_released_status);
3612: GMI_RESERVATION_UTIL.Println('in split_trans, qty to split'||p_qty_to_split);
3613: GMI_RESERVATION_UTIL.Println('in split_trans, qty2 to split'||p_qty2_to_split);
3614: GMI_RESERVATION_UTIL.Println('in split_trans, qty to fulfil'||l_qty_to_fulfil);
3615: IF l_released_status = 'B' THEN /* back orders*/
3608: l_qty2_to_fulfil := l_orig_qty2 - p_qty2_to_split;
3609:
3610: GMI_RESERVATION_UTIL.Println('in split_trans');
3611: GMI_RESERVATION_UTIL.Println('in split_trans, relased_status '||l_released_status);
3612: GMI_RESERVATION_UTIL.Println('in split_trans, qty to split'||p_qty_to_split);
3613: GMI_RESERVATION_UTIL.Println('in split_trans, qty2 to split'||p_qty2_to_split);
3614: GMI_RESERVATION_UTIL.Println('in split_trans, qty to fulfil'||l_qty_to_fulfil);
3615: IF l_released_status = 'B' THEN /* back orders*/
3616: IF (l_noninv_ind = 1 OR (l_lot_ctl = 0 AND l_loct_ctl * l_whse_ctl = 0)) THEN
3609:
3610: GMI_RESERVATION_UTIL.Println('in split_trans');
3611: GMI_RESERVATION_UTIL.Println('in split_trans, relased_status '||l_released_status);
3612: GMI_RESERVATION_UTIL.Println('in split_trans, qty to split'||p_qty_to_split);
3613: GMI_RESERVATION_UTIL.Println('in split_trans, qty2 to split'||p_qty2_to_split);
3614: GMI_RESERVATION_UTIL.Println('in split_trans, qty to fulfil'||l_qty_to_fulfil);
3615: IF l_released_status = 'B' THEN /* back orders*/
3616: IF (l_noninv_ind = 1 OR (l_lot_ctl = 0 AND l_loct_ctl * l_whse_ctl = 0)) THEN
3617: -- null;
3610: GMI_RESERVATION_UTIL.Println('in split_trans');
3611: GMI_RESERVATION_UTIL.Println('in split_trans, relased_status '||l_released_status);
3612: GMI_RESERVATION_UTIL.Println('in split_trans, qty to split'||p_qty_to_split);
3613: GMI_RESERVATION_UTIL.Println('in split_trans, qty2 to split'||p_qty2_to_split);
3614: GMI_RESERVATION_UTIL.Println('in split_trans, qty to fulfil'||l_qty_to_fulfil);
3615: IF l_released_status = 'B' THEN /* back orders*/
3616: IF (l_noninv_ind = 1 OR (l_lot_ctl = 0 AND l_loct_ctl * l_whse_ctl = 0)) THEN
3617: -- null;
3618: /* Bug2901317 */
3620: FETCH nonctl_reservation INTO l_trans_id;
3621: CLOSE nonctl_reservation;
3622: /* End Bug2901317 */
3623: ELSE
3624: GMI_RESERVATION_UTIL.Println('in split_trans, updating the trans for new line_id');
3625: OPEN c_reservations;
3626: LOOP
3627: FETCH c_reservations INTO l_trans_id, l_doc_id;
3628: EXIT WHEN c_reservations%NOTFOUND;
3628: EXIT WHEN c_reservations%NOTFOUND;
3629: Update ic_tran_pnd
3630: Set line_id = p_new_source_line_id
3631: Where trans_id = l_trans_id;
3632: GMI_RESERVATION_UTIL.Println('l_trans_id is '||l_trans_id);
3633: END LOOP;
3634: END IF;
3635:
3636: /* update the default lot to the new line_id */
3642: Where trans_id = l_trans_id;
3643: END IF;
3644:
3645: oe_debug_pub.add('Going to find old default lot in split_reservation',2);
3646: GMI_RESERVATION_UTIL.find_default_lot
3647: ( x_return_status => x_return_status,
3648: x_msg_count => x_msg_count,
3649: x_msg_data => x_msg_data,
3650: x_reservation_id => l_trans_id,
3650: x_reservation_id => l_trans_id,
3651: p_line_id => p_old_source_line_id
3652: );
3653: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
3654: GMI_RESERVATION_UTIL.println('Error returned by find default lot');
3655: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3656: END IF;
3657:
3658: l_old_transaction_rec.trans_id := l_trans_id;
3659: IF GMI_TRAN_PND_DB_PVT.FETCH_IC_TRAN_PND
3660: (l_old_transaction_rec, l_old_transaction_rec )
3661: THEN
3662: l_orig_txn_exists := 1; --Bug3149635
3663: GMI_RESERVATION_UTIL.PrintLn('balancing default lot for line_id '|| p_old_source_line_id);
3664: GMI_RESERVATION_UTIL.balance_default_lot
3665: ( p_ic_default_rec => l_old_transaction_rec
3666: , p_opm_item_id => l_old_transaction_rec.item_id
3667: , x_return_status => x_return_status
3660: (l_old_transaction_rec, l_old_transaction_rec )
3661: THEN
3662: l_orig_txn_exists := 1; --Bug3149635
3663: GMI_RESERVATION_UTIL.PrintLn('balancing default lot for line_id '|| p_old_source_line_id);
3664: GMI_RESERVATION_UTIL.balance_default_lot
3665: ( p_ic_default_rec => l_old_transaction_rec
3666: , p_opm_item_id => l_old_transaction_rec.item_id
3667: , x_return_status => x_return_status
3668: , x_msg_count => x_msg_count
3669: , x_msg_data => x_msg_data
3670: );
3671: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
3672: THEN
3673: GMI_RESERVATION_UTIL.PrintLn('Error returned by balancing default lot');
3674: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3675: END IF;
3676: ELSE
3677: l_orig_txn_exists := 0; --Bug3149635
3678: END IF;
3679:
3680: oe_debug_pub.add('Going to find new default lot in split_reservation',2);
3681:
3682: GMI_RESERVATION_UTIL.find_default_lot
3683: ( x_return_status => x_return_status,
3684: x_msg_count => x_msg_count,
3685: x_msg_data => x_msg_data,
3686: x_reservation_id => l_trans_id,
3687: p_line_id => p_new_source_line_id
3688: );
3689:
3690: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
3691: GMI_RESERVATION_UTIL.println('Error returned by find default lot');
3692: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3693: END IF;
3694:
3695: --Bug3149635 (added AND condition below)
3708: ,x_return_status => x_return_status
3709: ,x_msg_count => x_msg_count
3710: ,x_msg_data => x_msg_data);
3711:
3712: GMI_reservation_Util.PrintLn('created new default lot with trans_id '||l_new_transaction_row.trans_id);
3713: GMI_reservation_Util.PrintLn('created new default lot with line_detail_id '||l_new_transaction_row.line_detail_id);
3714: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
3715: THEN
3716: GMI_reservation_Util.PrintLn('(opm_dbg) in Create_Empty_Default_Lot (Create DefaultLot): Error returned by GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION.');
3709: ,x_msg_count => x_msg_count
3710: ,x_msg_data => x_msg_data);
3711:
3712: GMI_reservation_Util.PrintLn('created new default lot with trans_id '||l_new_transaction_row.trans_id);
3713: GMI_reservation_Util.PrintLn('created new default lot with line_detail_id '||l_new_transaction_row.line_detail_id);
3714: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
3715: THEN
3716: GMI_reservation_Util.PrintLn('(opm_dbg) in Create_Empty_Default_Lot (Create DefaultLot): Error returned by GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION.');
3717: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
3712: GMI_reservation_Util.PrintLn('created new default lot with trans_id '||l_new_transaction_row.trans_id);
3713: GMI_reservation_Util.PrintLn('created new default lot with line_detail_id '||l_new_transaction_row.line_detail_id);
3714: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
3715: THEN
3716: GMI_reservation_Util.PrintLn('(opm_dbg) in Create_Empty_Default_Lot (Create DefaultLot): Error returned by GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION.');
3717: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
3718: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION');
3719: FND_MESSAGE.Set_Token('WHERE', 'Create_Empty_Default_Lot');
3720: FND_MSG_PUB.Add;
3726: END IF;
3727: IF GMI_TRAN_PND_DB_PVT.FETCH_IC_TRAN_PND
3728: (l_old_transaction_rec, l_old_transaction_rec )
3729: THEN
3730: GMI_RESERVATION_UTIL.PrintLn('balancing default lot for line_id '|| p_new_source_line_id);
3731: GMI_RESERVATION_UTIL.balance_default_lot
3732: ( p_ic_default_rec => l_old_transaction_rec
3733: , p_opm_item_id => l_old_transaction_rec.item_id
3734: , x_return_status => x_return_status
3727: IF GMI_TRAN_PND_DB_PVT.FETCH_IC_TRAN_PND
3728: (l_old_transaction_rec, l_old_transaction_rec )
3729: THEN
3730: GMI_RESERVATION_UTIL.PrintLn('balancing default lot for line_id '|| p_new_source_line_id);
3731: GMI_RESERVATION_UTIL.balance_default_lot
3732: ( p_ic_default_rec => l_old_transaction_rec
3733: , p_opm_item_id => l_old_transaction_rec.item_id
3734: , x_return_status => x_return_status
3735: , x_msg_count => x_msg_count
3736: , x_msg_data => x_msg_data
3737: );
3738: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
3739: THEN
3740: GMI_RESERVATION_UTIL.PrintLn('Error returned by balancing default lot');
3741: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3742: END IF;
3743: END IF;
3744: /* split reservations if neccessary */
3765: Update ic_tran_pnd
3766: Set line_id = p_new_source_line_id
3767: Where line_id = p_old_source_line_id
3768: and line_detail_id = p_new_delivery_detail_id;
3769: GMI_RESERVATION_UTIL.PrintLn('Updated Here');
3770: END IF;
3771: /* End Bug2901317 */
3772: ELSE
3773: OPEN c_reservations;
3779:
3780: IF GMI_TRAN_PND_DB_PVT.FETCH_IC_TRAN_PND
3781: (l_old_transaction_rec, l_old_transaction_rec )
3782: THEN
3783: GMI_RESERVATION_UTIL.Println('got trans for trans_id '||l_trans_id);
3784: GMI_RESERVATION_UTIL.Println('l_qty_to_fulfil '||l_qty_to_fulfil);
3785: GMI_RESERVATION_UTIL.Println('l_qty2_to_fulfil '||l_qty2_to_fulfil);
3786: IF abs(l_old_transaction_rec.trans_qty) < l_qty_to_fulfil THEN
3787: /* do nothing for the tran */
3780: IF GMI_TRAN_PND_DB_PVT.FETCH_IC_TRAN_PND
3781: (l_old_transaction_rec, l_old_transaction_rec )
3782: THEN
3783: GMI_RESERVATION_UTIL.Println('got trans for trans_id '||l_trans_id);
3784: GMI_RESERVATION_UTIL.Println('l_qty_to_fulfil '||l_qty_to_fulfil);
3785: GMI_RESERVATION_UTIL.Println('l_qty2_to_fulfil '||l_qty2_to_fulfil);
3786: IF abs(l_old_transaction_rec.trans_qty) < l_qty_to_fulfil THEN
3787: /* do nothing for the tran */
3788: GMI_RESERVATION_UTIL.Println('in split_trans, keep trans the same for trans_id '||l_trans_id);
3781: (l_old_transaction_rec, l_old_transaction_rec )
3782: THEN
3783: GMI_RESERVATION_UTIL.Println('got trans for trans_id '||l_trans_id);
3784: GMI_RESERVATION_UTIL.Println('l_qty_to_fulfil '||l_qty_to_fulfil);
3785: GMI_RESERVATION_UTIL.Println('l_qty2_to_fulfil '||l_qty2_to_fulfil);
3786: IF abs(l_old_transaction_rec.trans_qty) < l_qty_to_fulfil THEN
3787: /* do nothing for the tran */
3788: GMI_RESERVATION_UTIL.Println('in split_trans, keep trans the same for trans_id '||l_trans_id);
3789: GMI_RESERVATION_UTIL.Println('in split_trans, trans_qty '||l_old_transaction_rec.trans_qty);
3784: GMI_RESERVATION_UTIL.Println('l_qty_to_fulfil '||l_qty_to_fulfil);
3785: GMI_RESERVATION_UTIL.Println('l_qty2_to_fulfil '||l_qty2_to_fulfil);
3786: IF abs(l_old_transaction_rec.trans_qty) < l_qty_to_fulfil THEN
3787: /* do nothing for the tran */
3788: GMI_RESERVATION_UTIL.Println('in split_trans, keep trans the same for trans_id '||l_trans_id);
3789: GMI_RESERVATION_UTIL.Println('in split_trans, trans_qty '||l_old_transaction_rec.trans_qty);
3790: l_qty_to_fulfil := l_qty_to_fulfil - abs(l_old_transaction_rec.trans_qty);
3791: l_qty2_to_fulfil := l_qty2_to_fulfil - abs(l_old_transaction_rec.trans_qty2);
3792: ELSIF abs(l_old_transaction_rec.trans_qty) > l_qty_to_fulfil
3785: GMI_RESERVATION_UTIL.Println('l_qty2_to_fulfil '||l_qty2_to_fulfil);
3786: IF abs(l_old_transaction_rec.trans_qty) < l_qty_to_fulfil THEN
3787: /* do nothing for the tran */
3788: GMI_RESERVATION_UTIL.Println('in split_trans, keep trans the same for trans_id '||l_trans_id);
3789: GMI_RESERVATION_UTIL.Println('in split_trans, trans_qty '||l_old_transaction_rec.trans_qty);
3790: l_qty_to_fulfil := l_qty_to_fulfil - abs(l_old_transaction_rec.trans_qty);
3791: l_qty2_to_fulfil := l_qty2_to_fulfil - abs(l_old_transaction_rec.trans_qty2);
3792: ELSIF abs(l_old_transaction_rec.trans_qty) > l_qty_to_fulfil
3793: AND l_qty_to_fulfil > 0 THEN
3823: );
3824:
3825: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
3826: THEN
3827: GMI_RESERVATION_UTIL.println('Error returned by Create_Pending_Transaction');
3828: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3829: END IF;
3830: /* qty filfilled*/
3831: l_qty_to_fulfil := 0;
3840: END IF;
3841: END LOOP;
3842: CLOSE c_reservations;
3843: /* need to balance default lot for both new sol and old sol */
3844: GMI_RESERVATION_UTIL.find_default_lot
3845: ( x_return_status => x_return_status,
3846: x_msg_count => x_msg_count,
3847: x_msg_data => x_msg_data,
3848: x_reservation_id => l_trans_id,
3856:
3857: IF GMI_TRAN_PND_DB_PVT.FETCH_IC_TRAN_PND
3858: (l_old_transaction_rec, l_old_transaction_rec )
3859: THEN
3860: GMI_RESERVATION_UTIL.PrintLn('balancing default lot for line_id '|| p_old_source_line_id);
3861: GMI_RESERVATION_UTIL.balance_default_lot
3862: ( p_ic_default_rec => l_old_transaction_rec
3863: , p_opm_item_id => l_old_transaction_rec.item_id
3864: , x_return_status => x_return_status
3857: IF GMI_TRAN_PND_DB_PVT.FETCH_IC_TRAN_PND
3858: (l_old_transaction_rec, l_old_transaction_rec )
3859: THEN
3860: GMI_RESERVATION_UTIL.PrintLn('balancing default lot for line_id '|| p_old_source_line_id);
3861: GMI_RESERVATION_UTIL.balance_default_lot
3862: ( p_ic_default_rec => l_old_transaction_rec
3863: , p_opm_item_id => l_old_transaction_rec.item_id
3864: , x_return_status => x_return_status
3865: , x_msg_count => x_msg_count
3866: , x_msg_data => x_msg_data
3867: );
3868: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
3869: THEN
3870: GMI_RESERVATION_UTIL.PrintLn('Error returned by balancing default lot');
3871: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3872: END IF;
3873: END IF;
3874: END IF;
3871: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3872: END IF;
3873: END IF;
3874: END IF;
3875: GMI_RESERVATION_UTIL.find_default_lot
3876: ( x_return_status => x_return_status,
3877: x_msg_count => x_msg_count,
3878: x_msg_data => x_msg_data,
3879: x_reservation_id => l_trans_id,
3885:
3886: IF GMI_TRAN_PND_DB_PVT.FETCH_IC_TRAN_PND
3887: (l_old_transaction_rec, l_old_transaction_rec )
3888: THEN
3889: GMI_RESERVATION_UTIL.PrintLn('balancing default lot for line_id '|| p_new_source_line_id);
3890: GMI_RESERVATION_UTIL.balance_default_lot
3891: ( p_ic_default_rec => l_old_transaction_rec
3892: , p_opm_item_id => l_old_transaction_rec.item_id
3893: , x_return_status => x_return_status
3886: IF GMI_TRAN_PND_DB_PVT.FETCH_IC_TRAN_PND
3887: (l_old_transaction_rec, l_old_transaction_rec )
3888: THEN
3889: GMI_RESERVATION_UTIL.PrintLn('balancing default lot for line_id '|| p_new_source_line_id);
3890: GMI_RESERVATION_UTIL.balance_default_lot
3891: ( p_ic_default_rec => l_old_transaction_rec
3892: , p_opm_item_id => l_old_transaction_rec.item_id
3893: , x_return_status => x_return_status
3894: , x_msg_count => x_msg_count
3895: , x_msg_data => x_msg_data
3896: );
3897: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
3898: THEN
3899: GMI_RESERVATION_UTIL.PrintLn('Error returned by balancing default lot');
3900: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3901: END IF;
3902: END IF;
3903: -- Begin Bug 2985470
3923: );
3924:
3925: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
3926: THEN
3927: GMI_RESERVATION_UTIL.println('Error returned by Create_Pending_Transaction');
3928: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3929: END IF;
3930: /* qty filfilled*/
3931: l_qty_to_fulfil := 0;
3931: l_qty_to_fulfil := 0;
3932: l_qty2_to_fulfil := 0;
3933:
3934: -- PK added
3935: GMI_RESERVATION_UTIL.find_default_lot
3936: ( x_return_status => x_return_status,
3937: x_msg_count => x_msg_count,
3938: x_msg_data => x_msg_data,
3939: x_reservation_id => l_trans_id,
3945:
3946: IF GMI_TRAN_PND_DB_PVT.FETCH_IC_TRAN_PND
3947: (l_old_transaction_rec, l_old_transaction_rec )
3948: THEN
3949: GMI_RESERVATION_UTIL.PrintLn('balancing default lot for line_id '|| p_new_source_line_id);
3950: GMI_RESERVATION_UTIL.balance_default_lot
3951: ( p_ic_default_rec => l_old_transaction_rec
3952: , p_opm_item_id => l_old_transaction_rec.item_id
3953: , x_return_status => x_return_status
3946: IF GMI_TRAN_PND_DB_PVT.FETCH_IC_TRAN_PND
3947: (l_old_transaction_rec, l_old_transaction_rec )
3948: THEN
3949: GMI_RESERVATION_UTIL.PrintLn('balancing default lot for line_id '|| p_new_source_line_id);
3950: GMI_RESERVATION_UTIL.balance_default_lot
3951: ( p_ic_default_rec => l_old_transaction_rec
3952: , p_opm_item_id => l_old_transaction_rec.item_id
3953: , x_return_status => x_return_status
3954: , x_msg_count => x_msg_count
3955: , x_msg_data => x_msg_data
3956: );
3957: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
3958: THEN
3959: GMI_RESERVATION_UTIL.PrintLn('Error returned by balancing default lot');
3960: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3961: END IF;
3962: END IF;
3963: END IF;
4043:
4044: BEGIN
4045:
4046: RETURN; /* Bug 2901317 and Enhancement 2320442 */
4047: GMI_RESERVATION_UTIL.println('in check_non_ctl NON ctl item');
4048: Open get_wdd_info;
4049: Fetch get_wdd_info
4050: Into l_source_line_id
4051: , l_organization_id
4071: set delete_mark=1
4072: Where trans_id=l_trans_id;
4073: END IF;
4074:
4075: GMI_RESERVATION_UTIL.find_default_lot
4076: ( x_return_status => x_return_status,
4077: x_msg_count => l_msg_count,
4078: x_msg_data => l_msg_data,
4079: x_reservation_id => l_trans_id,
4087: l_get_trans := 1;
4088: END IF;
4089: IF l_been_there = 1 AND l_get_trans = 1 THEN
4090: /* need to balance defualt lot */
4091: GMI_RESERVATION_UTIL.balance_default_lot
4092: ( p_ic_default_rec => l_old_transaction_rec
4093: , p_opm_item_id => l_old_transaction_rec.item_id
4094: , x_return_status => x_return_status
4095: , x_msg_count => l_msg_count
4096: , x_msg_data => l_msg_data
4097: );
4098: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
4099: THEN
4100: GMI_RESERVATION_UTIL.PrintLn('Error returned by balancing default lot');
4101: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4102: END IF;
4103: l_get_trans := 0;
4104: /* need to fetch it again */
4109: END IF;
4110: END IF;
4111:
4112: IF l_get_trans = 1 THEN
4113: GMI_RESERVATION_UTIL.println('will update ictranpndNON ctl item','opm.log');
4114: IF p_shipped_quantity >= abs(l_old_transaction_rec.trans_qty) THEN -- ship the whole thing and more
4115: /* this line is no longer default trans */
4116: l_old_transaction_rec.trans_qty := -1 * (p_shipped_quantity);
4117: l_old_transaction_rec.trans_qty2 := -1 * (p_shipped_quantity2);
4122: , staged_ind = 1
4123: Where trans_id = l_trans_id;
4124:
4125: ELSE -- partial ship
4126: GMI_RESERVATION_UTIL.println('split the default lot ','opm.log');
4127: update ic_tran_pnd
4128: set trans_qty = -1 * p_shipped_quantity
4129: , trans_qty2 = -1 * p_shipped_quantity2
4130: , line_detail_id = p_delivery_detail_id
4138: l_new_transaction_rec.trans_qty2 := -1 * (abs(l_new_transaction_rec.trans_qty2)
4139: - p_shipped_quantity2);
4140: l_new_transaction_rec.line_detail_id := null;
4141:
4142: GMI_RESERVATION_UTIL.println('create trans '||l_trans_id );
4143: GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION
4144: ( 1
4145: , FND_API.G_FALSE
4146: , FND_API.G_FALSE
4153: );
4154:
4155: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
4156: THEN
4157: GMI_RESERVATION_UTIL.println('Error returned by Create_Pending_Transaction');
4158: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4159: END IF;
4160: GMI_RESERVATION_UTIL.println('create trans '||l_new_transaction_row.trans_id );
4161: END IF;
4156: THEN
4157: GMI_RESERVATION_UTIL.println('Error returned by Create_Pending_Transaction');
4158: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4159: END IF;
4160: GMI_RESERVATION_UTIL.println('create trans '||l_new_transaction_row.trans_id );
4161: END IF;
4162: END IF;
4163: END IF;
4164: END check_non_ctl;
4197:
4198: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4199:
4200: OPEN c_get_opm_txn;
4201: GMI_RESERVATION_UTIL.println('unreserve wdd ' || p_delivery_detail_id);
4202: --GMI_RESERVATION_UTIL.println('unreserve line_id ' || p_source_line_id);
4203: l_quantity_to_unreserve := p_quantity_to_unreserve;
4204: l_quantity_to_unreserve2 := p_quantity_to_unreserve2;
4205: --LOOP
4198: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4199:
4200: OPEN c_get_opm_txn;
4201: GMI_RESERVATION_UTIL.println('unreserve wdd ' || p_delivery_detail_id);
4202: --GMI_RESERVATION_UTIL.println('unreserve line_id ' || p_source_line_id);
4203: l_quantity_to_unreserve := p_quantity_to_unreserve;
4204: l_quantity_to_unreserve2 := p_quantity_to_unreserve2;
4205: --LOOP
4206: FETCH c_get_opm_txn
4219: , x_return_status => x_return_status
4220: );
4221: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
4222: THEN
4223: GMI_RESERVATION_UTIL.println('Error returned by Delete_Pending_Transaction');
4224: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4225: END IF;
4226: ELSE
4227: GMI_RESERVATION_UTIL.println('update the ic_tran_pnd');
4223: GMI_RESERVATION_UTIL.println('Error returned by Delete_Pending_Transaction');
4224: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4225: END IF;
4226: ELSE
4227: GMI_RESERVATION_UTIL.println('update the ic_tran_pnd');
4228: Update ic_tran_pnd
4229: Set trans_qty = -1 * (abs(l_trans_qty) - l_quantity_to_unreserve)
4230: , trans_qty2 = -1 * (abs(l_trans_qty2) - l_quantity_to_unreserve2)
4231: Where trans_id = l_trans_id;
4257: IF (v_retval IN (-23, -25)) THEN
4258: /* -23 = Date is within a closed Inventory calendar period */
4259: /* -25 = Warehouse has been closed for the period */
4260: l_trans_date := SYSDATE;
4261: GMI_RESERVATION_UTIL.println('Completing existing transaction in current open inventory period '||
4262: to_char(l_trans_date));
4263: END IF;
4264: return l_trans_date;
4265: END GMI_TRANS_DATE;
4333:
4334:
4335: BEGIN
4336: /* get lot_ctl and loct_ctl */
4337: GMI_reservation_Util.PrintLn('check_loct_ctl for item_id '|| p_inventory_item_id
4338: ||' for org '||p_mtl_organization_id);
4339: Open get_item_info;
4340: Fetch get_item_info
4341: Into l_item_id
4353: x_ctl_ind := 'N';
4354: ElSE
4355: x_ctl_ind := 'Y';
4356: END IF;
4357: GMI_reservation_Util.PrintLn('check_loct_ctl returning '|| x_ctl_ind);
4358: End check_loct_ctl;
4359:
4360: -- HW 3388186
4361: -- This procedure is introduced because of WSH Consolidate backorder Line Project in 11510
4408:
4409: BEGIN
4410:
4411: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4412: gmi_reservation_util.println('In GMI_SHIPPING_UTIL.UPDATE_NEW_LINE_DETAIL_ID');
4413: gmi_reservation_util.println('Value of p_cons_dd_id is '||p_cons_dd_id);
4414:
4415: -- Find the source_line_id associated with the new consolidated
4416: -- backorder line from WSH
4409: BEGIN
4410:
4411: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4412: gmi_reservation_util.println('In GMI_SHIPPING_UTIL.UPDATE_NEW_LINE_DETAIL_ID');
4413: gmi_reservation_util.println('Value of p_cons_dd_id is '||p_cons_dd_id);
4414:
4415: -- Find the source_line_id associated with the new consolidated
4416: -- backorder line from WSH
4417:
4419:
4420: FETCH find_new_source_line into l_new_source_line_id;
4421: IF ( find_new_source_line%NOTFOUND) THEN
4422: CLOSE find_new_source_line;
4423: gmi_reservation_util.println('Can not find source_line from WSH_DELIVERY_DETAILS for source_line'||p_cons_dd_id);
4424: x_return_status := FND_API.G_RET_STS_ERROR;
4425: RETURN;
4426: END IF;
4427: CLOSE find_new_source_line;
4426: END IF;
4427: CLOSE find_new_source_line;
4428:
4429: IF ( l_new_source_line_id is NOT NULL ) THEN -- source_line_id is found
4430: gmi_reservation_util.println('Found new line_id and it is '||l_new_source_line_id);
4431:
4432: -- Loop through the old delivery_detail_ids to update them
4433: -- with the new values
4434: for i IN p_old_dd_ids.FIRST .. p_old_dd_ids.LAST LOOP --{
4438:
4439: OPEN GET_IC_RECORDS(l_new_source_line_id, l_wdd_id);
4440: FETCH GET_IC_RECORDS into l_line_id,l_ic_dd;
4441:
4442: gmi_reservation_util.println('Value of l_line_id is '||l_new_source_line_id);
4443: gmi_reservation_util.println('Value of l_icc_dd is '||l_ic_dd);
4444: gmi_reservation_util.println('Value of old dd is '||p_old_dd_ids(i));
4445:
4446:
4439: OPEN GET_IC_RECORDS(l_new_source_line_id, l_wdd_id);
4440: FETCH GET_IC_RECORDS into l_line_id,l_ic_dd;
4441:
4442: gmi_reservation_util.println('Value of l_line_id is '||l_new_source_line_id);
4443: gmi_reservation_util.println('Value of l_icc_dd is '||l_ic_dd);
4444: gmi_reservation_util.println('Value of old dd is '||p_old_dd_ids(i));
4445:
4446:
4447: -- Make sure values are not null and match old dd_id in IC_TRAN_PND
4440: FETCH GET_IC_RECORDS into l_line_id,l_ic_dd;
4441:
4442: gmi_reservation_util.println('Value of l_line_id is '||l_new_source_line_id);
4443: gmi_reservation_util.println('Value of l_icc_dd is '||l_ic_dd);
4444: gmi_reservation_util.println('Value of old dd is '||p_old_dd_ids(i));
4445:
4446:
4447: -- Make sure values are not null and match old dd_id in IC_TRAN_PND
4448: IF ( ( nvl(l_line_id, 0) <> 0) AND ( p_old_dd_ids(i) = l_ic_dd )
4448: IF ( ( nvl(l_line_id, 0) <> 0) AND ( p_old_dd_ids(i) = l_ic_dd )
4449: AND ( ( nvl(l_ic_dd, 0) <> 0) )) THEN
4450:
4451: -- Update Inventoryu with new delivery_detail_id
4452: gmi_reservation_util.println('Update ic_tran_pnd with new line_detail_id '||p_cons_dd_id);
4453: UPDATE IC_TRAN_PND IC
4454: SET IC.line_detail_id = p_cons_dd_id
4455: WHERE IC.line_detail_id = l_ic_dd
4456: AND IC.line_id = l_line_id ;
4455: WHERE IC.line_detail_id = l_ic_dd
4456: AND IC.line_id = l_line_id ;
4457:
4458: IF (SQL%NOTFOUND) THEN
4459: GMI_RESERVATION_UTIL.println('Error In Updating IC_TRAN_PND');
4460: RAISE NO_DATA_FOUND;
4461: END IF; -- of error updating
4462:
4463: END IF; -- of line_id and old_dd_id
4467: END IF;
4468:
4469: END LOOP; -- of old_dd_ids
4470: ELSE
4471: gmi_reservation_util.println('Cannot find source_line_id');
4472: END IF; -- of source_line_id
4473:
4474:
4475:
4485:
4486:
4487: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4488:
4489: gmi_reservation_util.println('Done calling GMI_SHIPPING_UTIL.UPDATE_NEW_LINE_DETAIL_ID');
4490:
4491: EXCEPTION
4492:
4493: WHEN NO_DATA_FOUND THEN
4492:
4493: WHEN NO_DATA_FOUND THEN
4494: x_return_status := FND_API.G_RET_STS_ERROR;
4495: RAISE NO_DATA_FOUND;
4496: GMI_RESERVATION_UTIL.Println('Raised When No Data Found in GMI_SHIPPING_UTIL.UPDATE_NEW_LINE_DETAIL_ID');
4497:
4498: WHEN OTHERS THEN
4499:
4500: IF GET_IC_RECORDS%ISOPEN THEN