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.GMI_OM_UTIL dependencies on GMI_RESERVATION_UTIL

Line 75: GMI_RESERVATION_UTIL.Println('In Procedure GMI_OM_UTIL.GMI_GET_RMA_LOTS_QTY');

71:
72:
73: BEGIN
74:
75: GMI_RESERVATION_UTIL.Println('In Procedure GMI_OM_UTIL.GMI_GET_RMA_LOTS_QTY');
76:
77: l_rma_qty := p_original_line_rec.ordered_quantity;
78:
79: /* Clear Table */

Line 84: GMI_RESERVATION_UTIL.Println('Getting item details for Apps Item ID '

80: l_Lot_serial_tbl.DELETE;
81:
82: x_return_status := FND_API.G_RET_STS_SUCCESS;
83:
84: GMI_RESERVATION_UTIL.Println('Getting item details for Apps Item ID '
85: ||to_char(p_reference_line_rec.inventory_item_id));
86: OPEN item_dtl;
87: FETCH item_dtl into rec_item_dtl;
88: CLOSE item_dtl;

Line 91: GMI_RESERVATION_UTIL.Println('Fetching lot quantities for order line id '||

87: FETCH item_dtl into rec_item_dtl;
88: CLOSE item_dtl;
89:
90: IF rec_item_dtl.lot_ctl = 1 THEN
91: GMI_RESERVATION_UTIL.Println('Fetching lot quantities for order line id '||
92: to_char(p_original_line_rec.reference_line_id));
93: FOR r_trans_dtl IN trans_dtl LOOP
94:
95:

Line 102: GMI_Reservation_Util.Get_AppsUOM_from_OPMUOM(

98: EXIT;
99: END IF;
100:
101: IF (l_number = 0) THEN /* get apps uom just once */
102: GMI_Reservation_Util.Get_AppsUOM_from_OPMUOM(
103: p_OPM_UOM => r_trans_dtl.trans_um
104: , x_Apps_UOM => l_trans_apps_um
105: , x_return_status => x_return_status
106: , x_msg_count => l_msg_count

Line 111: GMI_RESERVATION_UTIL.Println('Unable to Get_AppsUOM_from_OPMUOM');

107: , x_msg_data => l_msg_data);
108: END IF;
109:
110: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
111: GMI_RESERVATION_UTIL.Println('Unable to Get_AppsUOM_from_OPMUOM');
112: x_return_status := FND_API.G_RET_STS_ERROR;
113: EXIT;
114: END IF;
115:

Line 118: l_trans_qty := GMI_RESERVATION_UTIL.Get_Opm_converted_qty

114: END IF;
115:
116: /* if item primary uom and rma uom are different convert trans qty */
117: IF (l_trans_apps_um <> p_original_line_rec.order_quantity_uom) THEN
118: l_trans_qty := GMI_RESERVATION_UTIL.Get_Opm_converted_qty
119: ( p_apps_item_id => p_reference_line_rec.inventory_item_id
120: ,p_organization_id => p_reference_line_rec.ship_from_org_id
121: ,p_apps_from_uom => l_trans_apps_um
122: ,p_apps_to_uom => p_original_line_rec.order_quantity_uom

Line 144: l_lot_trxn_qty2 := GMI_RESERVATION_UTIL.Get_Opm_converted_qty

140:
141: /* need to derive secondary qty because partial lot qty is considered */
142: IF ( OE_CODE_CONTROL.Get_Code_Release_Level >= '110510') THEN
143: IF (rec_item_dtl.dualum_ind > 0 ) THEN
144: l_lot_trxn_qty2 := GMI_RESERVATION_UTIL.Get_Opm_converted_qty
145: ( p_apps_item_id => p_reference_line_rec.inventory_item_id
146: ,p_organization_id => p_reference_line_rec.ship_from_org_id
147: ,p_apps_from_uom => p_original_line_rec.order_quantity_uom
148: ,p_apps_to_uom => p_original_line_rec.ordered_quantity_uom2

Line 162: GMI_RESERVATION_UTIL.Println('lot_no = '||r_trans_dtl.lot_no);

158: l_lot_trxn_qty2 := l_trans_qty2;
159: END IF;
160: END IF;
161:
162: GMI_RESERVATION_UTIL.Println('lot_no = '||r_trans_dtl.lot_no);
163: GMI_RESERVATION_UTIL.Println('sublot_no = '||r_trans_dtl.sublot_no);
164: GMI_RESERVATION_UTIL.Println('lot_trxn_qty = '||to_char(l_lot_trxn_qty));
165: GMI_RESERVATION_UTIL.Println('lot_trxn_qty2 = '||to_char(l_lot_trxn_qty2));
166:

Line 163: GMI_RESERVATION_UTIL.Println('sublot_no = '||r_trans_dtl.sublot_no);

159: END IF;
160: END IF;
161:
162: GMI_RESERVATION_UTIL.Println('lot_no = '||r_trans_dtl.lot_no);
163: GMI_RESERVATION_UTIL.Println('sublot_no = '||r_trans_dtl.sublot_no);
164: GMI_RESERVATION_UTIL.Println('lot_trxn_qty = '||to_char(l_lot_trxn_qty));
165: GMI_RESERVATION_UTIL.Println('lot_trxn_qty2 = '||to_char(l_lot_trxn_qty2));
166:
167: l_lot_serial_tbl(l_number) := OE_ORDER_PUB.G_MISS_LOT_SERIAL_REC;

Line 164: GMI_RESERVATION_UTIL.Println('lot_trxn_qty = '||to_char(l_lot_trxn_qty));

160: END IF;
161:
162: GMI_RESERVATION_UTIL.Println('lot_no = '||r_trans_dtl.lot_no);
163: GMI_RESERVATION_UTIL.Println('sublot_no = '||r_trans_dtl.sublot_no);
164: GMI_RESERVATION_UTIL.Println('lot_trxn_qty = '||to_char(l_lot_trxn_qty));
165: GMI_RESERVATION_UTIL.Println('lot_trxn_qty2 = '||to_char(l_lot_trxn_qty2));
166:
167: l_lot_serial_tbl(l_number) := OE_ORDER_PUB.G_MISS_LOT_SERIAL_REC;
168: l_lot_serial_tbl(l_number).lot_number := r_trans_dtl.lot_no;

Line 165: GMI_RESERVATION_UTIL.Println('lot_trxn_qty2 = '||to_char(l_lot_trxn_qty2));

161:
162: GMI_RESERVATION_UTIL.Println('lot_no = '||r_trans_dtl.lot_no);
163: GMI_RESERVATION_UTIL.Println('sublot_no = '||r_trans_dtl.sublot_no);
164: GMI_RESERVATION_UTIL.Println('lot_trxn_qty = '||to_char(l_lot_trxn_qty));
165: GMI_RESERVATION_UTIL.Println('lot_trxn_qty2 = '||to_char(l_lot_trxn_qty2));
166:
167: l_lot_serial_tbl(l_number) := OE_ORDER_PUB.G_MISS_LOT_SERIAL_REC;
168: l_lot_serial_tbl(l_number).lot_number := r_trans_dtl.lot_no;
169: l_lot_serial_tbl(l_number).quantity := l_lot_trxn_qty;

Line 181: GMI_RESERVATION_UTIL.Println('Could not fetch lot quantities for order line id '||

177:
178: IF (l_number = 0) THEN
179: /* commenting following line because referencing unshipped line was giving errors. May be its an OM issue */
180: /* x_return_status := FND_API.G_RET_STS_ERROR; */
181: GMI_RESERVATION_UTIL.Println('Could not fetch lot quantities for order line id '||
182: to_char(p_original_line_rec.reference_line_id));
183: END IF;
184:
185: END IF; /* IF rec_item_dtl.lot_ctl = 1 */

Line 192: GMI_RESERVATION_UTIL.Println('Raised When Others in GMI_RMA_LOT_QTY');

188:
189: EXCEPTION
190: WHEN OTHERS THEN
191: x_return_status := FND_API.G_RET_STS_ERROR;
192: GMI_RESERVATION_UTIL.Println('Raised When Others in GMI_RMA_LOT_QTY');
193: err_num := SQLCODE;
194: err_msg := SUBSTRB(SQLERRM, 1, 100);
195: GMI_RESERVATION_UTIL.Println(to_char(err_num)||'=>'||err_msg);
196:

Line 195: GMI_RESERVATION_UTIL.Println(to_char(err_num)||'=>'||err_msg);

191: x_return_status := FND_API.G_RET_STS_ERROR;
192: GMI_RESERVATION_UTIL.Println('Raised When Others in GMI_RMA_LOT_QTY');
193: err_num := SQLCODE;
194: err_msg := SUBSTRB(SQLERRM, 1, 100);
195: GMI_RESERVATION_UTIL.Println(to_char(err_num)||'=>'||err_msg);
196:
197: END GMI_GET_RMA_LOTS_QTY;
198:
199: FUNCTION GMI_GET_SECONDARY_QTY

Line 254: l_converted_qty := GMI_Reservation_Util.Get_Opm_converted_qty

250: OPEN Get_lot_id;
251: FETCH Get_lot_id into l_lot_id;
252: CLOSE Get_lot_id;
253:
254: l_converted_qty := GMI_Reservation_Util.Get_Opm_converted_qty
255: (
256: l_inventory_item_id,
257: l_organization_id,
258: l_apps_from_uom,