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 IC_ITEM_MST

Line 84: l_ic_item_mst_rec ic_item_mst%ROWTYPE;

80: l_error_code NUMBER;
81: l_factor NUMBER;
82: l_type_factorrev NUMBER;
83: l_ic_item_cnv_rec ic_item_cnv%ROWTYPE;
84: l_ic_item_mst_rec ic_item_mst%ROWTYPE;
85: l_ic_lots_mst_rec ic_lots_mst%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;

Line 148: , x_ic_item_mst => l_ic_item_mst_rec

144:
145: -- Get the item details ensuring that the item is active and not deleted
146:
147: GMI_GLOBAL_GRP.Get_Item ( p_item_no => l_item_cnv_rec.item_no
148: , x_ic_item_mst => l_ic_item_mst_rec
149: , x_ic_item_cpg => l_ic_item_cpg_rec
150: );
151:
152: IF (l_ic_item_mst_rec.item_id < 0)

Line 152: IF (l_ic_item_mst_rec.item_id < 0)

148: , x_ic_item_mst => l_ic_item_mst_rec
149: , x_ic_item_cpg => l_ic_item_cpg_rec
150: );
151:
152: IF (l_ic_item_mst_rec.item_id < 0)
153: THEN
154: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
155: ELSIF (l_ic_item_mst_rec.item_id = 0) OR
156: (l_ic_item_mst_rec.delete_mark = 1)

Line 155: ELSIF (l_ic_item_mst_rec.item_id = 0) OR

151:
152: IF (l_ic_item_mst_rec.item_id < 0)
153: THEN
154: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
155: ELSIF (l_ic_item_mst_rec.item_id = 0) OR
156: (l_ic_item_mst_rec.delete_mark = 1)
157: THEN
158: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_ITEM_NO');
159: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_cnv_rec.item_no);

Line 156: (l_ic_item_mst_rec.delete_mark = 1)

152: IF (l_ic_item_mst_rec.item_id < 0)
153: THEN
154: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
155: ELSIF (l_ic_item_mst_rec.item_id = 0) OR
156: (l_ic_item_mst_rec.delete_mark = 1)
157: THEN
158: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_ITEM_NO');
159: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_cnv_rec.item_no);
160: FND_MSG_PUB.Add;

Line 162: ELSIF (l_ic_item_mst_rec.noninv_ind = 1)

158: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_ITEM_NO');
159: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_cnv_rec.item_no);
160: FND_MSG_PUB.Add;
161: RAISE FND_API.G_EXC_ERROR;
162: ELSIF (l_ic_item_mst_rec.noninv_ind = 1)
163: THEN
164: FND_MESSAGE.SET_NAME('GMI','IC_API_NONINV_ITEM_NO');
165: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_cnv_rec.item_no);
166: FND_MSG_PUB.Add;

Line 168: ELSIF (l_ic_item_mst_rec.inactive_ind = 1)

164: FND_MESSAGE.SET_NAME('GMI','IC_API_NONINV_ITEM_NO');
165: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_cnv_rec.item_no);
166: FND_MSG_PUB.Add;
167: RAISE FND_API.G_EXC_ERROR;
168: ELSIF (l_ic_item_mst_rec.inactive_ind = 1)
169: THEN
170: FND_MESSAGE.SET_NAME('GMI','IC_API_INACTIVE_ITEM_NO');
171: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_cnv_rec.item_no);
172: FND_MSG_PUB.Add;

Line 199: GMI_GLOBAL_GRP.Get_Lot ( p_item_id => l_ic_item_mst_rec.item_id

195: -- Get the lot details ensuring that the lot is not deleted.
196: -- This may be the default lot for the item.
197:
198:
199: GMI_GLOBAL_GRP.Get_Lot ( p_item_id => l_ic_item_mst_rec.item_id
200: , p_lot_no => l_item_cnv_rec.lot_no
201: , p_sublot_no => l_item_cnv_rec.sublot_no
202: , x_ic_lots_mst => l_ic_lots_mst_rec
203: , x_ic_lots_cpg => l_ic_lots_cpg_rec

Line 290: GMI_GLOBAL_GRP.Get_Um ( p_um_code => l_ic_item_mst_rec.item_um

286:
287: -- Get UOM details of the item primary Unit of Measure
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: );

Line 302: FND_MESSAGE.SET_TOKEN('UOM', l_ic_item_mst_rec.item_um);

298: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOT_UOM');
299: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_item_cnv_rec.item_no);
300: FND_MESSAGE.SET_TOKEN('LOT_NO', l_item_cnv_rec.lot_no);
301: FND_MESSAGE.SET_TOKEN('SUBLOT_NO', l_item_cnv_rec.sublot_no);
302: FND_MESSAGE.SET_TOKEN('UOM', l_ic_item_mst_rec.item_um);
303: FND_MSG_PUB.Add;
304: RAISE FND_API.G_EXC_ERROR;
305: ELSIF (l_error_code = -2)
306: THEN

Line 311: FND_MESSAGE.SET_TOKEN('UOM', l_ic_item_mst_rec.item_um);

307: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOT_UOM_TYPE');
308: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_item_cnv_rec.item_no);
309: FND_MESSAGE.SET_TOKEN('LOT_NO', l_item_cnv_rec.lot_no);
310: FND_MESSAGE.SET_TOKEN('SUBLOT_NO', l_item_cnv_rec.sublot_no);
311: FND_MESSAGE.SET_TOKEN('UOM', l_ic_item_mst_rec.item_um);
312: FND_MSG_PUB.Add;
313: RAISE FND_API.G_EXC_ERROR;
314: END IF;
315:

Line 384: l_factor := GMICUOM.uom_conversion(pitem_id => l_ic_item_mst_rec.item_id

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
387: ,pcur_uom => l_from_um
388: ,pnew_uom => l_from_std_um

Line 409: l_factor := GMICUOM.uom_conversion(pitem_id => l_ic_item_mst_rec.item_id

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
412: ,pcur_uom => l_to_std_um
413: ,pnew_uom => l_to_um

Line 435: l_ic_item_cnv_rec.item_id := l_ic_item_mst_rec.item_id;

431: l_type_factorrev := 1 / l_factor;
432:
433: -- Set up PL/SQL record and insert item/lot conversion into IC_ITEM_CNV
434:
435: l_ic_item_cnv_rec.item_id := l_ic_item_mst_rec.item_id;
436: l_ic_item_cnv_rec.lot_id := l_ic_lots_mst_rec.lot_id;
437: l_ic_item_cnv_rec.um_type := l_um_type;
438: l_ic_item_cnv_rec.type_factor := l_factor;
439: l_ic_item_cnv_rec.last_update_date := SYSDATE;