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_ITEM_LOT_CONV_PUB dependencies on SY_UOMS_TYP

Line 90: l_sy_uoms_typ_rec_um1 sy_uoms_typ%ROWTYPE;

86: l_item_cnv_rec item_cnv_rec_typ;
87: l_ic_item_cpg_rec ic_item_cpg%ROWTYPE;
88: l_ic_lots_cpg_rec ic_lots_cpg%ROWTYPE;
89: l_sy_uoms_mst_rec_um1 sy_uoms_mst%ROWTYPE;
90: l_sy_uoms_typ_rec_um1 sy_uoms_typ%ROWTYPE;
91: l_sy_uoms_mst_rec_from sy_uoms_mst%ROWTYPE;
92: l_sy_uoms_typ_rec_from sy_uoms_typ%ROWTYPE;
93: l_sy_uoms_mst_rec_to sy_uoms_mst%ROWTYPE;
94: l_sy_uoms_typ_rec_to sy_uoms_typ%ROWTYPE;

Line 92: l_sy_uoms_typ_rec_from sy_uoms_typ%ROWTYPE;

88: l_ic_lots_cpg_rec ic_lots_cpg%ROWTYPE;
89: l_sy_uoms_mst_rec_um1 sy_uoms_mst%ROWTYPE;
90: l_sy_uoms_typ_rec_um1 sy_uoms_typ%ROWTYPE;
91: l_sy_uoms_mst_rec_from sy_uoms_mst%ROWTYPE;
92: l_sy_uoms_typ_rec_from sy_uoms_typ%ROWTYPE;
93: l_sy_uoms_mst_rec_to sy_uoms_mst%ROWTYPE;
94: l_sy_uoms_typ_rec_to sy_uoms_typ%ROWTYPE;
95: l_um_type sy_uoms_mst.um_type%TYPE;
96: l_from_um sy_uoms_mst.um_code%TYPE;

Line 94: l_sy_uoms_typ_rec_to sy_uoms_typ%ROWTYPE;

90: l_sy_uoms_typ_rec_um1 sy_uoms_typ%ROWTYPE;
91: l_sy_uoms_mst_rec_from sy_uoms_mst%ROWTYPE;
92: l_sy_uoms_typ_rec_from sy_uoms_typ%ROWTYPE;
93: l_sy_uoms_mst_rec_to sy_uoms_mst%ROWTYPE;
94: l_sy_uoms_typ_rec_to sy_uoms_typ%ROWTYPE;
95: l_um_type sy_uoms_mst.um_type%TYPE;
96: l_from_um sy_uoms_mst.um_code%TYPE;
97: l_to_um sy_uoms_mst.um_code%TYPE;
98: l_from_std_um sy_uoms_mst.um_code%TYPE;

Line 223: , x_sy_uoms_typ => l_sy_uoms_typ_rec_from

219:
220:
221: GMI_GLOBAL_GRP.Get_Um ( p_um_code => l_item_cnv_rec.from_uom
222: , x_sy_uoms_mst => l_sy_uoms_mst_rec_from
223: , x_sy_uoms_typ => l_sy_uoms_typ_rec_from
224: , x_error_code => l_error_code
225: );
226:
227: IF (l_error_code = -1)

Line 251: , x_sy_uoms_typ => l_sy_uoms_typ_rec_to

247: -- Get UOM details of the to Unit of Measure
248:
249: GMI_GLOBAL_GRP.Get_Um ( p_um_code => l_item_cnv_rec.to_uom
250: , x_sy_uoms_mst => l_sy_uoms_mst_rec_to
251: , x_sy_uoms_typ => l_sy_uoms_typ_rec_to
252: , x_error_code => l_error_code
253: );
254:
255: IF (l_error_code = -1)

Line 277: IF l_sy_uoms_typ_rec_from.um_type = l_sy_uoms_typ_rec_to.um_type

273: END IF;
274:
275: -- Check that the from UoM type differs from the to UoM type. If not then
276: -- error and exit
277: IF l_sy_uoms_typ_rec_from.um_type = l_sy_uoms_typ_rec_to.um_type
278: THEN
279: FND_MESSAGE.SET_NAME('GMI','IC_API_LOT_ITEM_UOM_MISMATCH');
280: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_item_cnv_rec.item_no);
281: FND_MESSAGE.SET_TOKEN('LOT_NO', l_item_cnv_rec.lot_no);

Line 292: , x_sy_uoms_typ => l_sy_uoms_typ_rec_um1

288: -- This should not produce any errors but we'll check for them anyway.
289:
290: GMI_GLOBAL_GRP.Get_Um ( p_um_code => l_ic_item_mst_rec.item_um
291: , x_sy_uoms_mst => l_sy_uoms_mst_rec_um1
292: , x_sy_uoms_typ => l_sy_uoms_typ_rec_um1
293: , x_error_code => l_error_code
294: );
295:
296: IF (l_error_code = -1)

Line 320: IF (l_sy_uoms_typ_rec_um1.std_um = l_sy_uoms_typ_rec_from.std_um)

316: -- Check that the unit of measure type of the from_uom or the to_uom
317: -- is the same as the unit of measure type of the item primary uom.
318: -- Adjust conversion factor as appropriate.
319:
320: IF (l_sy_uoms_typ_rec_um1.std_um = l_sy_uoms_typ_rec_from.std_um)
321: THEN
322: l_factor := 1 / l_item_cnv_rec.type_factor;
323: l_um_type := l_sy_uoms_mst_rec_to.um_type;
324: l_from_um := l_item_cnv_rec.from_uom;

Line 325: l_from_std_um := l_sy_uoms_typ_rec_from.std_um;

321: THEN
322: l_factor := 1 / l_item_cnv_rec.type_factor;
323: l_um_type := l_sy_uoms_mst_rec_to.um_type;
324: l_from_um := l_item_cnv_rec.from_uom;
325: l_from_std_um := l_sy_uoms_typ_rec_from.std_um;
326: l_to_um := l_item_cnv_rec.to_uom;
327: l_to_std_um := l_sy_uoms_typ_rec_to.std_um;
328: ELSIF (l_sy_uoms_typ_rec_um1.std_um = l_sy_uoms_typ_rec_to.std_um)
329: THEN

Line 327: l_to_std_um := l_sy_uoms_typ_rec_to.std_um;

323: l_um_type := l_sy_uoms_mst_rec_to.um_type;
324: l_from_um := l_item_cnv_rec.from_uom;
325: l_from_std_um := l_sy_uoms_typ_rec_from.std_um;
326: l_to_um := l_item_cnv_rec.to_uom;
327: l_to_std_um := l_sy_uoms_typ_rec_to.std_um;
328: ELSIF (l_sy_uoms_typ_rec_um1.std_um = l_sy_uoms_typ_rec_to.std_um)
329: THEN
330: l_factor := l_item_cnv_rec.type_factor;
331: l_um_type := l_sy_uoms_mst_rec_from.um_type;

Line 328: ELSIF (l_sy_uoms_typ_rec_um1.std_um = l_sy_uoms_typ_rec_to.std_um)

324: l_from_um := l_item_cnv_rec.from_uom;
325: l_from_std_um := l_sy_uoms_typ_rec_from.std_um;
326: l_to_um := l_item_cnv_rec.to_uom;
327: l_to_std_um := l_sy_uoms_typ_rec_to.std_um;
328: ELSIF (l_sy_uoms_typ_rec_um1.std_um = l_sy_uoms_typ_rec_to.std_um)
329: THEN
330: l_factor := l_item_cnv_rec.type_factor;
331: l_um_type := l_sy_uoms_mst_rec_from.um_type;
332: l_from_um := l_item_cnv_rec.to_uom;

Line 333: l_from_std_um := l_sy_uoms_typ_rec_to.std_um;

329: THEN
330: l_factor := l_item_cnv_rec.type_factor;
331: l_um_type := l_sy_uoms_mst_rec_from.um_type;
332: l_from_um := l_item_cnv_rec.to_uom;
333: l_from_std_um := l_sy_uoms_typ_rec_to.std_um;
334: l_to_um := l_item_cnv_rec.from_uom;
335: l_to_std_um := l_sy_uoms_typ_rec_from.std_um;
336: ELSE
337: FND_MESSAGE.SET_NAME('GMI','IC_API_LOT_ITEM_UOM_MISMATCH');

Line 335: l_to_std_um := l_sy_uoms_typ_rec_from.std_um;

331: l_um_type := l_sy_uoms_mst_rec_from.um_type;
332: l_from_um := l_item_cnv_rec.to_uom;
333: l_from_std_um := l_sy_uoms_typ_rec_to.std_um;
334: l_to_um := l_item_cnv_rec.from_uom;
335: l_to_std_um := l_sy_uoms_typ_rec_from.std_um;
336: ELSE
337: FND_MESSAGE.SET_NAME('GMI','IC_API_LOT_ITEM_UOM_MISMATCH');
338: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_item_cnv_rec.item_no);
339: FND_MESSAGE.SET_TOKEN('LOT_NO', l_item_cnv_rec.lot_no);

Line 382: IF (l_from_um <> l_sy_uoms_typ_rec_from.std_um)

378:
379: -- First convert from from_uom to std_um for item_um uom type
380: -- if required
381:
382: IF (l_from_um <> l_sy_uoms_typ_rec_from.std_um)
383: THEN
384: l_factor := GMICUOM.uom_conversion(pitem_id => l_ic_item_mst_rec.item_id
385: ,plot_id => l_ic_lots_mst_rec.lot_id
386: ,pcur_qty => l_factor

Line 398: FND_MESSAGE.SET_TOKEN('UM2', l_sy_uoms_typ_rec_from.std_um);

394: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_item_cnv_rec.item_no);
395: FND_MESSAGE.SET_TOKEN('LOT_NO', l_item_cnv_rec.lot_no);
396: FND_MESSAGE.SET_TOKEN('SUBLOT_NO', l_item_cnv_rec.sublot_no);
397: FND_MESSAGE.SET_TOKEN('UM1', l_from_um);
398: FND_MESSAGE.SET_TOKEN('UM2', l_sy_uoms_typ_rec_from.std_um);
399: FND_MSG_PUB.Add;
400: RAISE FND_API.G_EXC_ERROR;
401: END IF;
402: END IF;

Line 407: IF (l_item_cnv_rec.to_uom <> l_sy_uoms_typ_rec_to.std_um)

403:
404: -- Next convert from to_uom to std_um for to_uom uom type
405: -- if required
406:
407: IF (l_item_cnv_rec.to_uom <> l_sy_uoms_typ_rec_to.std_um)
408: THEN
409: l_factor := GMICUOM.uom_conversion(pitem_id => l_ic_item_mst_rec.item_id
410: ,plot_id => l_ic_lots_mst_rec.lot_id
411: ,pcur_qty => l_factor

Line 423: FND_MESSAGE.SET_TOKEN('UM2', l_sy_uoms_typ_rec_to.std_um);

419: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_item_cnv_rec.item_no);
420: FND_MESSAGE.SET_TOKEN('LOT_NO', l_item_cnv_rec.lot_no);
421: FND_MESSAGE.SET_TOKEN('SUBLOT_NO', l_item_cnv_rec.sublot_no);
422: FND_MESSAGE.SET_TOKEN('UM1', l_to_um);
423: FND_MESSAGE.SET_TOKEN('UM2', l_sy_uoms_typ_rec_to.std_um);
424: FND_MSG_PUB.Add;
425: RAISE FND_API.G_EXC_ERROR;
426: END IF;
427: END IF;