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 FND_MSG_PUB

Line 120: FND_MSG_PUB.Initialize;

116:
117: -- Initialize message list if p_int_msg_list is set TRUE.
118: IF FND_API.to_boolean(p_init_msg_list)
119: THEN
120: FND_MSG_PUB.Initialize;
121: END IF;
122: -- Initialize API return status to sucess
123: x_return_status :=FND_API.G_RET_STS_SUCCESS;
124:

Line 135: FND_MSG_PUB.Add;

131: IF l_user_id = 0
132: THEN
133: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_USER_NAME');
134: FND_MESSAGE.SET_TOKEN('USER_NAME',l_user_name);
135: FND_MSG_PUB.Add;
136: RAISE FND_API.G_EXC_ERROR;
137: END IF;
138:
139: -- Ensure Upper-case columns are converted

Line 160: FND_MSG_PUB.Add;

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;
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');

Line 166: FND_MSG_PUB.Add;

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;
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');

Line 172: FND_MSG_PUB.Add;

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;
173: -- x_return_status :=FND_API.G_RET_STS_ERROR;
174: -- RAISE FND_API.G_EXC_ERROR;
175: END IF;
176:

Line 189: FND_MSG_PUB.Add;

185: IF (l_item_cnv_rec.lot_no IS NULL)
186: THEN
187: FND_MESSAGE.SET_NAME('GMI','IC_API_UNABLE_TO_GET_CONSTANT');
188: FND_MESSAGE.SET_TOKEN('CONSTANT_NAME','IC$DEFAULT_LOT');
189: FND_MSG_PUB.Add;
190: RAISE FND_API.G_EXC_ERROR;
191: END IF;
192: END IF;
193:

Line 214: FND_MSG_PUB.Add;

210: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOT_NO');
211: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_item_cnv_rec.item_no);
212: FND_MESSAGE.SET_TOKEN('LOT_NO', l_item_cnv_rec.lot_no);
213: FND_MESSAGE.SET_TOKEN('SUBLOT_NO', l_item_cnv_rec.sublot_no);
214: FND_MSG_PUB.Add;
215: RAISE FND_API.G_EXC_ERROR;
216: END IF;
217:
218: -- Get UOM details of the from Unit of Measure

Line 234: FND_MSG_PUB.Add;

230: FND_MESSAGE.SET_TOKEN('UOM', l_item_cnv_rec.from_uom);
231: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_item_cnv_rec.item_no);
232: FND_MESSAGE.SET_TOKEN('LOT_NO', l_item_cnv_rec.lot_no);
233: FND_MESSAGE.SET_TOKEN('SUBLOT_NO', l_item_cnv_rec.sublot_no);
234: FND_MSG_PUB.Add;
235: RAISE FND_API.G_EXC_ERROR;
236: ELSIF (l_error_code = -2)
237: THEN
238: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOT_UOM_TYPE');

Line 243: FND_MSG_PUB.Add;

239: FND_MESSAGE.SET_TOKEN('UOM', l_item_cnv_rec.from_uom);
240: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_item_cnv_rec.item_no);
241: FND_MESSAGE.SET_TOKEN('LOT_NO', l_item_cnv_rec.lot_no);
242: FND_MESSAGE.SET_TOKEN('SUBLOT_NO', l_item_cnv_rec.sublot_no);
243: FND_MSG_PUB.Add;
244: RAISE FND_API.G_EXC_ERROR;
245: END IF;
246:
247: -- Get UOM details of the to Unit of Measure

Line 262: FND_MSG_PUB.Add;

258: FND_MESSAGE.SET_TOKEN('UOM', l_item_cnv_rec.to_uom);
259: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_item_cnv_rec.item_no);
260: FND_MESSAGE.SET_TOKEN('LOT_NO', l_item_cnv_rec.lot_no);
261: FND_MESSAGE.SET_TOKEN('SUBLOT_NO', l_item_cnv_rec.sublot_no);
262: FND_MSG_PUB.Add;
263: RAISE FND_API.G_EXC_ERROR;
264: ELSIF (l_error_code = -2)
265: THEN
266: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOT_UOM_TYPE');

Line 271: FND_MSG_PUB.Add;

267: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_item_cnv_rec.item_no);
268: FND_MESSAGE.SET_TOKEN('LOT_NO', l_item_cnv_rec.lot_no);
269: FND_MESSAGE.SET_TOKEN('SUBLOT_NO', l_item_cnv_rec.sublot_no);
270: FND_MESSAGE.SET_TOKEN('UOM', l_item_cnv_rec.to_uom);
271: FND_MSG_PUB.Add;
272: RAISE FND_API.G_EXC_ERROR;
273: END IF;
274:
275: -- Check that the from UoM type differs from the to UoM type. If not then

Line 283: FND_MSG_PUB.Add;

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);
282: FND_MESSAGE.SET_TOKEN('SUBLOT_NO', l_item_cnv_rec.sublot_no);
283: FND_MSG_PUB.Add;
284: RAISE FND_API.G_EXC_ERROR;
285: END IF;
286:
287: -- Get UOM details of the item primary Unit of Measure

Line 303: FND_MSG_PUB.Add;

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
307: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOT_UOM_TYPE');

Line 312: FND_MSG_PUB.Add;

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:
316: -- Check that the unit of measure type of the from_uom or the to_uom

Line 341: FND_MSG_PUB.Add;

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);
340: FND_MESSAGE.SET_TOKEN('SUBLOT_NO', l_item_cnv_rec.sublot_no);
341: FND_MSG_PUB.Add;
342: RAISE FND_API.G_EXC_ERROR;
343: END IF;
344:
345: -- Check that item/lot conversion does not already exist

Line 358: FND_MSG_PUB.Add;

354: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_item_cnv_rec.item_no);
355: FND_MESSAGE.SET_TOKEN('LOT_NO', l_item_cnv_rec.lot_no);
356: FND_MESSAGE.SET_TOKEN('SUBLOT_NO', l_item_cnv_rec.sublot_no);
357: FND_MESSAGE.SET_TOKEN('UM_TYPE', l_um_type);
358: FND_MSG_PUB.Add;
359: RAISE FND_API.G_EXC_ERROR;
360: END IF;
361:
362: -- Check that conversion factor is positive value

Line 370: FND_MSG_PUB.Add;

366: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOT_TYPE_FACTOR');
367: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_item_cnv_rec.item_no);
368: FND_MESSAGE.SET_TOKEN('LOT_NO', l_item_cnv_rec.lot_no);
369: FND_MESSAGE.SET_TOKEN('SUBLOT_NO', l_item_cnv_rec.sublot_no);
370: FND_MSG_PUB.Add;
371: RAISE FND_API.G_EXC_ERROR;
372: END IF;
373:
374: -- Now we have all the data required to calculate the conversion

Line 399: FND_MSG_PUB.Add;

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;
403:

Line 424: FND_MSG_PUB.Add;

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;
428:

Line 469: FND_MSG_PUB.Add;

465: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_item_cnv_rec.item_no);
466: FND_MESSAGE.SET_TOKEN('LOT_NO', l_item_cnv_rec.lot_no);
467: FND_MESSAGE.SET_TOKEN('SUBLOT_NO', l_item_cnv_rec.sublot_no);
468: FND_MESSAGE.SET_TOKEN('UM_TYPE', l_um_type);
469: FND_MSG_PUB.Add;
470: -- Standard Call to get message count and if count is 1,
471: -- get message info.
472: FND_MSG_PUB.Count_AND_GET ( p_count => x_msg_count
473: , p_data => x_msg_data

Line 472: FND_MSG_PUB.Count_AND_GET ( p_count => x_msg_count

468: FND_MESSAGE.SET_TOKEN('UM_TYPE', l_um_type);
469: FND_MSG_PUB.Add;
470: -- Standard Call to get message count and if count is 1,
471: -- get message info.
472: FND_MSG_PUB.Count_AND_GET ( p_count => x_msg_count
473: , p_data => x_msg_data
474: );
475:
476: EXCEPTION

Line 480: FND_MSG_PUB.Count_AND_GET ( p_count => x_msg_count

476: EXCEPTION
477: WHEN FND_API.G_EXC_ERROR THEN
478: ROLLBACK TO Create_Item_Lot_Uom_Conv;
479: x_return_status := FND_API.G_RET_STS_ERROR;
480: FND_MSG_PUB.Count_AND_GET ( p_count => x_msg_count
481: , p_data => x_msg_data
482: );
483: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
484: ROLLBACK TO Create_Item_Lot_Uom_Conv;

Line 486: FND_MSG_PUB.Count_AND_GET ( p_count => x_msg_count

482: );
483: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
484: ROLLBACK TO Create_Item_Lot_Uom_Conv;
485: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
486: FND_MSG_PUB.Count_AND_GET ( p_count => x_msg_count
487: , p_data => x_msg_data
488: );
489: WHEN OTHERS THEN
490: ROLLBACK TO Create_Item_Lot_Uom_Conv;

Line 492: -- IF FND_MSG_PUB.check_msg_level

488: );
489: WHEN OTHERS THEN
490: ROLLBACK TO Create_Item_Lot_Uom_Conv;
491: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
492: -- IF FND_MSG_PUB.check_msg_level
493: -- (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
494: -- THEN
495:
496: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME

Line 493: -- (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

489: WHEN OTHERS THEN
490: ROLLBACK TO Create_Item_Lot_Uom_Conv;
491: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
492: -- IF FND_MSG_PUB.check_msg_level
493: -- (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
494: -- THEN
495:
496: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
497: , l_api_name

Line 496: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME

492: -- IF FND_MSG_PUB.check_msg_level
493: -- (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
494: -- THEN
495:
496: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
497: , l_api_name
498: );
499: -- END IF;
500: FND_MSG_PUB.Count_AND_GET ( p_count => x_msg_count

Line 500: FND_MSG_PUB.Count_AND_GET ( p_count => x_msg_count

496: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
497: , l_api_name
498: );
499: -- END IF;
500: FND_MSG_PUB.Count_AND_GET ( p_count => x_msg_count
501: , p_data => x_msg_data
502: );
503: END Create_Item_Lot_Uom_Conv;
504: