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_MOVE_ORDER_LINES_PVT dependencies on GMI_RESERVATION_UTIL

Line 122: gmi_reservation_util.println('In move_order_lines_pvt');

118:
119: BEGIN
120: /* Standard Start OF API savepoint */
121: SAVEPOINT move_order_LINES;
122: gmi_reservation_util.println('In move_order_lines_pvt');
123:
124: /* DBMS_OUTPUT.PUT_LINE('IN MOVE ORDER LINES'); */
125:
126: /* Standard call to check for call compatibility. */

Line 147: gmi_reservation_util.PrintLn('Move_Order_LINES PVT COUNT=> '||p_mo_line_tbl.COUNT);

143:
144: x_return_status := FND_API.G_RET_STS_SUCCESS;
145:
146: WSH_Util_Core.PrintLn('Move_Order_LINES PVT COUNT=> '||p_mo_line_tbl.COUNT);
147: gmi_reservation_util.PrintLn('Move_Order_LINES PVT COUNT=> '||p_mo_line_tbl.COUNT);
148:
149: FOR I in 1..p_mo_line_TBL.COUNT LOOP
150: gmi_reservation_util.println('In loop');
151: l_mo_line_rec := p_mo_line_tbl(I);

Line 150: gmi_reservation_util.println('In loop');

146: WSH_Util_Core.PrintLn('Move_Order_LINES PVT COUNT=> '||p_mo_line_tbl.COUNT);
147: gmi_reservation_util.PrintLn('Move_Order_LINES PVT COUNT=> '||p_mo_line_tbl.COUNT);
148:
149: FOR I in 1..p_mo_line_TBL.COUNT LOOP
150: gmi_reservation_util.println('In loop');
151: l_mo_line_rec := p_mo_line_tbl(I);
152: WSH_Util_Core.PrintLn('move order line for source line_id > '|| l_mo_line_rec.txn_source_line_id );
153: WSH_Util_Core.PrintLn('Check Missing For Row > '|| I );
154: IF check_required( p_mo_line_rec => l_mo_line_rec) THEN

Line 168: gmi_reservation_util.println('Operation delete');

164: /* physically delete this row */
165: /* This first Queries To see If Any Reservations Exist */
166: /* ( GMI Transcations) Then deletes or Updates. */
167: /* Else it will just delete this line. */
168: gmi_reservation_util.println('Operation delete');
169: GMI_Move_Order_LINE_Util.delete_Row( l_mo_line_rec.LINE_id);
170: ELSE
171: gmi_reservation_util.println('Going to fetch opm_item');
172: Open get_opm_item;

Line 171: gmi_reservation_util.println('Going to fetch opm_item');

167: /* Else it will just delete this line. */
168: gmi_reservation_util.println('Operation delete');
169: GMI_Move_Order_LINE_Util.delete_Row( l_mo_line_rec.LINE_id);
170: ELSE
171: gmi_reservation_util.println('Going to fetch opm_item');
172: Open get_opm_item;
173: Fetch get_opm_item Into l_opm_item_id,
174: l_opm_noninv_ind,
175: l_opm_lot_ctl,

Line 180: gmi_reservation_util.println('Operation update');

176: l_opm_loct_ctl;
177: Close get_opm_item;
178:
179: IF l_mo_line_rec.operation = INV_GLOBALS.G_OPR_UPDATE THEN
180: gmi_reservation_util.println('Operation update');
181: IF (l_opm_lot_ctl <> 0 OR l_opm_loct_ctl <> 0) THEN
182: gmi_reservation_util.println('Going to fetch get_detailed_qtys ');
183: Open get_detailed_qtys;
184: Fetch get_detailed_qtys Into l_mo_line_rec.quantity_detailed,

Line 182: gmi_reservation_util.println('Going to fetch get_detailed_qtys ');

178:
179: IF l_mo_line_rec.operation = INV_GLOBALS.G_OPR_UPDATE THEN
180: gmi_reservation_util.println('Operation update');
181: IF (l_opm_lot_ctl <> 0 OR l_opm_loct_ctl <> 0) THEN
182: gmi_reservation_util.println('Going to fetch get_detailed_qtys ');
183: Open get_detailed_qtys;
184: Fetch get_detailed_qtys Into l_mo_line_rec.quantity_detailed,
185: l_mo_line_rec.secondary_quantity_detailed;
186: Close get_detailed_qtys;

Line 195: gmi_reservation_util.println('Going to fetch get_default_detailed_qtys');

191: l_mo_line_rec.quantity_delivered := l_mo_line_rec.quantity_detailed;
192: l_mo_line_rec.secondary_quantity_delivered := l_mo_line_rec.secondary_quantity_detailed;
193: END IF;
194: ELSE
195: gmi_reservation_util.println('Going to fetch get_default_detailed_qtys');
196: Open get_default_detailed_qtys;
197: Fetch get_default_detailed_qtys Into l_mo_line_rec.quantity_detailed,
198: l_mo_line_rec.secondary_quantity_detailed;
199: Close get_default_detailed_qtys;

Line 216: gmi_reservation_util.println('Going to update row');

212: /* This will first check if old_line quantity or line_status */
213: /* or quantity_detailed is different from New Then Call */
214: /* query to get reservations and do update logic. */
215: /* Else it will just update this row. */
216: gmi_reservation_util.println('Going to update row');
217: GMI_Move_Order_LINE_Util.update_Row( l_mo_line_rec);
218: ELSIF l_mo_line_rec.operation = INV_GLOBALS.G_OPR_CREATE THEN
219: /* Set create defaults */
220: gmi_reservation_util.println('Going to get get new id');

Line 220: gmi_reservation_util.println('Going to get get new id');

216: gmi_reservation_util.println('Going to update row');
217: GMI_Move_Order_LINE_Util.update_Row( l_mo_line_rec);
218: ELSIF l_mo_line_rec.operation = INV_GLOBALS.G_OPR_CREATE THEN
219: /* Set create defaults */
220: gmi_reservation_util.println('Going to get get new id');
221: l_mo_line_rec.creation_date := SYSDATE;
222: l_mo_line_rec.created_by := FND_GLOBAL.USER_ID;
223: /* Get New LINES Id Via Sequence */
224: -- BEGIN Bug 2628244 - Use of sequence MTL_TXN_REQUEST_LINES_S instead of gmi_mo_LINE_id_s

Line 232: gmi_reservation_util.println('Going to intsert line in move order ');

228: INTO l_mo_line_rec.LINE_id
229: FROM DUAL;
230:
231: WSH_Util_Core.PrintLn('Insert For Row > '|| I);
232: gmi_reservation_util.println('Going to intsert line in move order ');
233: GMI_Move_Order_LINE_Util.Insert_Row( l_mo_line_rec);
234:
235: /* Begin Bug 2973135 Uday Phadtare */
236: --Check if default transaction exists

Line 247: GMI_Reservation_Util.PrintLn('Transaction with default : NOTFOUND ');

243: OPEN get_whse_code(l_mo_line_rec.organization_id);
244: FETCH get_whse_code INTO l_whse_code;
245: CLOSE get_whse_code;
246:
247: GMI_Reservation_Util.PrintLn('Transaction with default : NOTFOUND ');
248: GMI_RESERVATION_UTIL.Create_dflt_lot_from_scratch
249: ( p_whse_code => l_whse_code
250: , p_line_id => l_mo_line_rec.txn_source_line_id
251: , p_item_id => l_opm_item_id

Line 248: GMI_RESERVATION_UTIL.Create_dflt_lot_from_scratch

244: FETCH get_whse_code INTO l_whse_code;
245: CLOSE get_whse_code;
246:
247: GMI_Reservation_Util.PrintLn('Transaction with default : NOTFOUND ');
248: GMI_RESERVATION_UTIL.Create_dflt_lot_from_scratch
249: ( p_whse_code => l_whse_code
250: , p_line_id => l_mo_line_rec.txn_source_line_id
251: , p_item_id => l_opm_item_id
252: , p_qty1 => l_mo_line_rec.primary_quantity

Line 260: GMI_reservation_Util.PrintLn('Error returned by Create_dflt_lot_from_scratch in Process_Move_Order_LINES');

256: , x_msg_data => x_msg_data
257: );
258:
259: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
260: GMI_reservation_Util.PrintLn('Error returned by Create_dflt_lot_from_scratch in Process_Move_Order_LINES');
261: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
262: FND_MESSAGE.SET_TOKEN('BY_PROC','GMI_Reservation_Util.create_dflt_lot_from_scratch');
263: FND_MESSAGE.SET_TOKEN('WHERE',G_PKG_NAME||'.'||l_api_name);
264: RAISE FND_API.G_EXC_ERROR;

Line 262: FND_MESSAGE.SET_TOKEN('BY_PROC','GMI_Reservation_Util.create_dflt_lot_from_scratch');

258:
259: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
260: GMI_reservation_Util.PrintLn('Error returned by Create_dflt_lot_from_scratch in Process_Move_Order_LINES');
261: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
262: FND_MESSAGE.SET_TOKEN('BY_PROC','GMI_Reservation_Util.create_dflt_lot_from_scratch');
263: FND_MESSAGE.SET_TOKEN('WHERE',G_PKG_NAME||'.'||l_api_name);
264: RAISE FND_API.G_EXC_ERROR;
265: END IF;
266:

Line 267: GMI_RESERVATION_UTIL.find_default_lot

263: FND_MESSAGE.SET_TOKEN('WHERE',G_PKG_NAME||'.'||l_api_name);
264: RAISE FND_API.G_EXC_ERROR;
265: END IF;
266:
267: GMI_RESERVATION_UTIL.find_default_lot
268: ( x_return_status => x_return_status,
269: x_msg_count => x_msg_count,
270: x_msg_data => x_msg_data,
271: x_reservation_id => l_trans_id,

Line 275: GMI_RESERVATION_UTIL.println('Error returned by find default lot');

271: x_reservation_id => l_trans_id,
272: p_line_id => l_mo_line_rec.txn_source_line_id
273: );
274: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
275: GMI_RESERVATION_UTIL.println('Error returned by find default lot');
276: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
277: END IF;
278:
279: l_default_tran_rec.trans_id := l_trans_id;

Line 282: GMI_RESERVATION_UTIL.PrintLn('balancing default lot for line_id '|| l_mo_line_rec.txn_source_line_id);

278:
279: l_default_tran_rec.trans_id := l_trans_id;
280:
281: IF GMI_TRAN_PND_DB_PVT.FETCH_IC_TRAN_PND(l_default_tran_rec, l_default_tran_rec) THEN
282: GMI_RESERVATION_UTIL.PrintLn('balancing default lot for line_id '|| l_mo_line_rec.txn_source_line_id);
283: GMI_RESERVATION_UTIL.balance_default_lot
284: ( p_ic_default_rec => l_default_tran_rec
285: , p_opm_item_id => l_default_tran_rec.item_id
286: , x_return_status => x_return_status

Line 283: GMI_RESERVATION_UTIL.balance_default_lot

279: l_default_tran_rec.trans_id := l_trans_id;
280:
281: IF GMI_TRAN_PND_DB_PVT.FETCH_IC_TRAN_PND(l_default_tran_rec, l_default_tran_rec) THEN
282: GMI_RESERVATION_UTIL.PrintLn('balancing default lot for line_id '|| l_mo_line_rec.txn_source_line_id);
283: GMI_RESERVATION_UTIL.balance_default_lot
284: ( p_ic_default_rec => l_default_tran_rec
285: , p_opm_item_id => l_default_tran_rec.item_id
286: , x_return_status => x_return_status
287: , x_msg_count => x_msg_count

Line 291: GMI_reservation_Util.PrintLn('Error returned by balance_default_lot in Process_Move_Order_LINES');

287: , x_msg_count => x_msg_count
288: , x_msg_data => x_msg_data
289: );
290: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
291: GMI_reservation_Util.PrintLn('Error returned by balance_default_lot in Process_Move_Order_LINES');
292: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
293: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION');
294: FND_MESSAGE.Set_Token('WHERE', 'Delete_Reservation');
295: FND_MSG_PUB.Add;

Line 306: gmi_reservation_util.println('Value of line id for l_mo_line_rec is '||l_mo_line_rec.line_id);

302: END IF;
303: END IF;
304:
305: l_mo_line_tbl(I) := l_mo_line_rec;
306: gmi_reservation_util.println('Value of line id for l_mo_line_rec is '||l_mo_line_rec.line_id);
307: END LOOP;
308:
309: /* Load Output table */
310: