eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMD_SPREADSHEET_UPDATE dependencies on GMD_DEBUG

Line 482: gmd_debug.put_line(' Inserting line for batch:'||l_material_detail.batch_id||' Item:'||l_material_detail.inventory_item_id);

478: l_material_detail.plan_qty := l_matl_rec.qty;
479: ELSIF (l_batch_row.batch_status = 2) THEN
480: l_material_detail.wip_plan_qty := l_matl_rec.qty;
481: END IF;
482: gmd_debug.put_line(' Inserting line for batch:'||l_material_detail.batch_id||' Item:'||l_material_detail.inventory_item_id);
483: gme_material_detail_pvt.insert_material_line (p_batch_header_rec => l_batch_row
484: ,p_material_detail_rec => l_material_detail
485: ,p_batch_step_rec => l_batch_step
486: ,p_trans_id => NULL

Line 491: gmd_debug.put_line(' Insert material line error: Item:'||l_material_detail.inventory_item_id);

487: ,x_transacted => l_transacted
488: ,x_return_status => l_return_status
489: ,x_material_detail_rec => l_material_out);
490: IF x_return_status <> l_return_status THEN
491: gmd_debug.put_line(' Insert material line error: Item:'||l_material_detail.inventory_item_id);
492: RAISE insert_line_err;
493: ELSE
494: l_matl_rec.material_detail_id := l_material_out.material_detail_id;
495: UPDATE gmd_material_details_gtmp

Line 519: gmd_debug.put_line(' Insert material line error: Material id:'||l_material_detail.material_detail_id);

515: ,x_transacted => l_transacted
516: ,x_return_status => l_return_status
517: ,x_material_detail_rec => l_material_out);
518: IF x_return_status <> l_return_status THEN
519: gmd_debug.put_line(' Insert material line error: Material id:'||l_material_detail.material_detail_id);
520: RAISE update_line_err;
521: END IF;
522: END IF;
523: END IF; /* IF(Cur_get_detail_id%NOTFOUND) THEN */

Line 552: gmd_debug.put_line(' Insert pending lot error: Material id:'||l_matl_rec.material_detail_id ||

548: p_org_code => NULL,
549: p_material_detail_rec => l_material_rec,
550: p_pending_product_lots_rec => l_pending_in_rec);
551: IF x_return_status <> l_return_status THEN
552: gmd_debug.put_line(' Insert pending lot error: Material id:'||l_matl_rec.material_detail_id ||
553: 'lot_number: '||l_pending_in_rec.lot_number);
554: RAISE update_line_err;
555: END IF;
556: END LOOP;

Line 592: gmd_debug.put_line(' Insert pending lot error: Material id:'||l_matl_rec.material_detail_id ||

588: p_material_detail_rec => l_material_rec,
589: p_pending_product_lots_rec => l_pending_in_rec,
590: x_pending_product_lots_rec => l_pending_out_rec);
591: IF x_return_status <> l_return_status THEN
592: gmd_debug.put_line(' Insert pending lot error: Material id:'||l_matl_rec.material_detail_id ||
593: 'lot_number: '||l_pending_in_rec.lot_number);
594: RAISE update_line_err;
595: END IF;
596: END IF;

Line 611: gmd_debug.put_line(' Insert pending lot error: Material id:'||l_matl_rec.material_detail_id ||

607: p_pending_product_lots_rec => l_pending_in_rec,
608: x_pending_product_lots_rec => l_pending_out_rec);
609:
610: IF x_return_status <> l_return_status THEN
611: gmd_debug.put_line(' Insert pending lot error: Material id:'||l_matl_rec.material_detail_id ||
612: 'lot_number: '||l_pending_in_rec.lot_number);
613: RAISE update_line_err;
614: END IF;
615: END IF;

Line 765: gmd_debug.put_line(' Material:'||P_material_detail_id||' trans:'||l_del_rec.reservation_id||' reserv qty:'||l_del_rec.reservation_quantity||' Lot:'||l_del_rec.lot_number);

761: /* First let us delete all the reservations which existed in the batch */
762: /* but was deleted from the spreadsheet. */
763: IF P_line_type <> 1 THEN
764: FOR l_del_rec IN Cur_get_del_lines (P_material_detail_id) LOOP
765: gmd_debug.put_line(' Material:'||P_material_detail_id||' trans:'||l_del_rec.reservation_id||' reserv qty:'||l_del_rec.reservation_quantity||' Lot:'||l_del_rec.lot_number);
766: gme_reservations_pvt.delete_reservation(p_reservation_id => l_del_rec.reservation_id
767: ,x_return_status => l_return_status);
768: IF X_return_status <> l_return_status THEN
769: gmd_debug.put_line('Delete allocation error:'||l_del_rec.reservation_id);

Line 769: gmd_debug.put_line('Delete allocation error:'||l_del_rec.reservation_id);

765: gmd_debug.put_line(' Material:'||P_material_detail_id||' trans:'||l_del_rec.reservation_id||' reserv qty:'||l_del_rec.reservation_quantity||' Lot:'||l_del_rec.lot_number);
766: gme_reservations_pvt.delete_reservation(p_reservation_id => l_del_rec.reservation_id
767: ,x_return_status => l_return_status);
768: IF X_return_status <> l_return_status THEN
769: gmd_debug.put_line('Delete allocation error:'||l_del_rec.reservation_id);
770: RAISE delete_alloc_err;
771: END IF;
772: END LOOP;
773: END IF;

Line 809: gmd_debug.put_line('Line:'||l_rec.line_no||' Material:'||p_material_detail_id||

805: l_material_out.revision := l_revision;
806: l_material_out.batch_id := P_batch_id;
807: l_material_out.material_requirement_date := l_requirement_date;
808: l_material_out.material_detail_id := P_material_detail_id;
809: gmd_debug.put_line('Line:'||l_rec.line_no||' Material:'||p_material_detail_id||
810: ' Lot Number:'||l_rec.lot_number||' Qty:'||l_rec.qty||
811: ' Secondary:'||l_rec.secondary_qty);
812:
813: /* Let us update the existing reservations */

Line 830: gmd_debug.put_line('Update allocation error:'||l_rec.reservation_id);

826: ,p_new_uom => l_rec.detail_uom
827: ,p_new_date => SYSDATE
828: ,x_return_status => l_return_status);
829: IF X_return_status <> l_return_status THEN
830: gmd_debug.put_line('Update allocation error:'||l_rec.reservation_id);
831: RAISE update_alloc_err;
832: END IF;
833: END IF;
834: ELSE

Line 845: gmd_debug.put_line(' Insert alloc fail'||l_return_status);

841: ,p_locator_id => l_rec.locator_id
842: ,p_lot_number => l_rec.lot_number
843: ,x_return_status => l_return_status);
844: IF X_return_status <> l_return_status THEN
845: gmd_debug.put_line(' Insert alloc fail'||l_return_status);
846: RAISE insert_alloc_err;
847: END IF;
848: END IF; /* IF l_rec.reservation_id IS NOT NULL THEN */
849: END LOOP; /* FOR l_rec IN Cur_get_lines (l_matl_rec.material_detail_id) */