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.MTL_LOT_UOM_CONV_PUB dependencies on FND_MSG_PUB

Line 44: G_tmp BOOLEAN := FND_MSG_PUB.Check_Msg_Level(0) ; -- temp call to initialize the

40: PROCEDURE log_msg(p_msg_text IN VARCHAR2);
41:
42: /* Global variables */
43: G_PKG_NAME CONSTANT VARCHAR2(30):='MTL_LOT_UOM_CONV_PUB';
44: G_tmp BOOLEAN := FND_MSG_PUB.Check_Msg_Level(0) ; -- temp call to initialize the
45: -- msg level threshhold gobal
46: -- variable.
47: G_debug_level NUMBER(2) := FND_MSG_PUB.G_Msg_Level_Threshold; -- Use this variable everywhere
48: -- to decide to log a debug msg.

Line 47: G_debug_level NUMBER(2) := FND_MSG_PUB.G_Msg_Level_Threshold; -- Use this variable everywhere

43: G_PKG_NAME CONSTANT VARCHAR2(30):='MTL_LOT_UOM_CONV_PUB';
44: G_tmp BOOLEAN := FND_MSG_PUB.Check_Msg_Level(0) ; -- temp call to initialize the
45: -- msg level threshhold gobal
46: -- variable.
47: G_debug_level NUMBER(2) := FND_MSG_PUB.G_Msg_Level_Threshold; -- Use this variable everywhere
48: -- to decide to log a debug msg.
49:
50:
51: /*===========================================================================

Line 230: FND_MSG_PUB.Initialize;

226: /*================================
227: Initialize Message List Logic
228: ================================*/
229: IF FND_API.to_boolean(p_init_msg_list) THEN
230: FND_MSG_PUB.Initialize;
231: END IF;
232:
233: /*==================================================
234: Standard call to check for call compatibility.

Line 251: FND_MSG_PUB.Add;

247: ==============================*/
248:
249: IF (p_action_type <> 'I' AND p_action_type <> 'U') THEN
250: FND_MESSAGE.SET_NAME('INV','INV_LOTC_ACTIONTYPE_INVALID');
251: FND_MSG_PUB.Add;
252: RAISE FND_API.G_EXC_ERROR;
253: END IF;
254:
255: l_update_type_indicator := p_update_type_indicator;

Line 264: FND_MSG_PUB.Add;

260: l_org.organization_id := p_lot_uom_conv_rec.organization_id;
261: l_ret := INV_VALIDATE.organization(l_org);
262: IF (l_ret = INV_VALIDATE.F) THEN
263: FND_MESSAGE.SET_NAME('INV','INV_LOTC_ORG_INVALID');
264: FND_MSG_PUB.Add;
265: RAISE FND_API.G_EXC_ERROR;
266: END IF;
267:
268: /*===============================

Line 277: FND_MSG_PUB.Add;

273:
274: l_ret := INV_VALIDATE.inventory_item(l_item, l_org);
275: IF (l_ret = INV_VALIDATE.F) THEN
276: FND_MESSAGE.SET_NAME('INV','INV_LOTC_ITEM_INVALID');
277: FND_MSG_PUB.Add;
278: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
279: END IF;
280:
281: /*===============================

Line 290: FND_MSG_PUB.Add;

286: l_lot.lot_number := p_lot_uom_conv_rec.lot_number;
287: l_ret := INV_VALIDATE.lot_number(l_lot, l_org, l_item);
288: IF (l_ret = INV_VALIDATE.F) THEN
289: FND_MESSAGE.SET_NAME('INV','INV_LOTC_LOT_INVALID');
290: FND_MSG_PUB.Add;
291: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
292: END IF;
293:
294:

Line 310: FND_MSG_PUB.Add;

306: IF ( l_from_uom_code IS NULL AND
307: l_from_unit_of_measure IS NULL AND
308: l_from_uom_class IS NULL ) THEN
309: FND_MESSAGE.SET_NAME('INV','INV_LOTC_SOURCE_UOM_REQD');
310: FND_MSG_PUB.Add;
311: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
312: END IF;
313:
314: IF ( l_to_uom_code IS NULL AND

Line 318: FND_MSG_PUB.Add;

314: IF ( l_to_uom_code IS NULL AND
315: l_to_unit_of_measure IS NULL AND
316: l_to_uom_class IS NULL) THEN
317: FND_MESSAGE.SET_NAME('INV','INV_LOTC_TARGET_UOM_REQD');
318: FND_MSG_PUB.Add;
319: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
320: END IF;
321:
322:

Line 334: FND_MSG_PUB.Add;

330: FETCH get_uom_code_values INTO l_from_unit_of_measure,l_from_uom_class;
331: IF (get_uom_code_values%NOTFOUND) THEN
332: CLOSE get_uom_code_values;
333: FND_MESSAGE.SET_NAME('INV','INV_GET_UOM_ERR');
334: FND_MSG_PUB.Add;
335: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
336: END IF;
337: CLOSE get_uom_code_values;
338:

Line 345: FND_MSG_PUB.Add;

341: FETCH get_unit_of_meas_values INTO l_from_uom_code,l_from_uom_class;
342: IF (get_unit_of_meas_values%NOTFOUND) THEN
343: CLOSE get_unit_of_meas_values;
344: FND_MESSAGE.SET_NAME('INV','INV_GET_UNITOFMEASURE_ERR');
345: FND_MSG_PUB.Add;
346: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
347: END IF;
348: CLOSE get_unit_of_meas_values;
349:

Line 356: FND_MSG_PUB.Add;

352: FETCH get_uom_class_values INTO l_from_unit_of_measure,l_from_uom_code;
353: IF (get_uom_class_values%NOTFOUND) THEN
354: CLOSE get_uom_class_values;
355: FND_MESSAGE.SET_NAME('INV','INV_GET_UOM_CLASS_ERR');
356: FND_MSG_PUB.Add;
357: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
358: END IF;
359: CLOSE get_uom_class_values;
360:

Line 375: FND_MSG_PUB.Add;

371: FETCH get_uom_code_values INTO l_to_unit_of_measure,l_to_uom_class;
372: IF (get_uom_code_values%NOTFOUND) THEN
373: CLOSE get_uom_code_values;
374: FND_MESSAGE.SET_NAME('INV','INV_GET_UOM_ERR');
375: FND_MSG_PUB.Add;
376: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
377: END IF;
378: CLOSE get_uom_code_values;
379:

Line 386: FND_MSG_PUB.Add;

382: FETCH get_unit_of_meas_values INTO l_to_uom_code,l_to_uom_class;
383: IF (get_unit_of_meas_values%NOTFOUND) THEN
384: CLOSE get_unit_of_meas_values;
385: FND_MESSAGE.SET_NAME('INV','INV_GET_UNITOFMEASURE_ERR');
386: FND_MSG_PUB.Add;
387: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
388: END IF;
389: CLOSE get_unit_of_meas_values;
390:

Line 397: FND_MSG_PUB.Add;

393: FETCH get_uom_class_values INTO l_to_unit_of_measure,l_to_uom_code;
394: IF (get_uom_class_values%NOTFOUND) THEN
395: CLOSE get_uom_class_values;
396: FND_MESSAGE.SET_NAME('INV','INV_GET_UOM_CLASS_ERR');
397: FND_MSG_PUB.Add;
398: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
399: END IF;
400: CLOSE get_uom_class_values;
401:

Line 423: FND_MSG_PUB.Add;

419: OPEN get_item_uom;
420: FETCH get_item_uom INTO l_item_uom_code;
421: IF (get_item_uom%NOTFOUND) THEN
422: FND_MESSAGE.SET_NAME('INV','INV_ITEMUOM');
423: FND_MSG_PUB.Add;
424: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
425: END IF;
426: CLOSE get_item_uom;
427:

Line 436: FND_MSG_PUB.Add;

432: OPEN get_item_uom_class;
433: FETCH get_item_uom_class INTO l_item_uom_class;
434: IF (get_item_uom_class%NOTFOUND) THEN
435: FND_MESSAGE.SET_NAME('INV','INV_ITEMUOM_CLASS');
436: FND_MSG_PUB.Add;
437: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
438: END IF;
439: CLOSE get_item_uom_class;
440:

Line 449: FND_MSG_PUB.Add;

445:
446:
447: IF (l_item_uom_class <> l_from_uom_class) THEN
448: FND_MESSAGE.SET_NAME('INV','INV_CLASSMISMATCH');
449: FND_MSG_PUB.Add;
450: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
451: END IF;
452:
453:

Line 462: FND_MSG_PUB.Add;

458: OPEN get_base_values(l_from_uom_class);
459: FETCH get_base_values INTO l_from_base_unit_of_measure, l_from_base_uom_code;
460: IF (get_base_values%NOTFOUND) THEN
461: FND_MESSAGE.SET_NAME('INV','INV_FROMBASE_ERROR');
462: FND_MSG_PUB.Add;
463: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
464: END IF;
465: CLOSE get_base_values;
466:

Line 491: FND_MSG_PUB.Add;

487:
488:
489: IF (l_ret = -99999) THEN
490: FND_MESSAGE.SET_NAME('INV','INV_FROMBASE_CONV_ERROR');
491: FND_MSG_PUB.Add;
492: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
493: ELSE
494: p_lot_uom_conv_rec.conversion_rate := l_from_rate;
495: l_from_uom_code := l_from_base_uom_code;

Line 509: FND_MSG_PUB.Add;

505: OPEN get_base_values(l_to_uom_class);
506: FETCH get_base_values INTO l_to_base_unit_of_measure, l_to_base_uom_code;
507: IF (get_base_values%NOTFOUND) THEN
508: FND_MESSAGE.SET_NAME('INV','INV_TOBASE_ERROR');
509: FND_MSG_PUB.Add;
510: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
511: END IF;
512: CLOSE get_base_values;
513:

Line 538: FND_MSG_PUB.Add;

534: );
535:
536: IF (l_ret = -99999) THEN
537: FND_MESSAGE.SET_NAME('INV','INV_TOBASE_CONV_ERROR');
538: FND_MSG_PUB.Add;
539: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
540: ELSE
541: p_lot_uom_conv_rec.conversion_rate := p_lot_uom_conv_rec.conversion_rate/l_factor;
542: l_to_uom_code := l_to_base_uom_code;

Line 572: FND_MSG_PUB.Add;

568: ==============================*/
569: IF (p_lot_uom_conv_rec.conversion_rate <= 0 OR
570: p_lot_uom_conv_rec.conversion_rate IS NULL) THEN
571: FND_MESSAGE.SET_NAME('INV','INV_LOTC_CONVRATE_INVALID');
572: FND_MSG_PUB.Add;
573: RAISE FND_API.G_EXC_ERROR;
574: END IF;
575:
576: /*===============================

Line 602: FND_MSG_PUB.Add;

598: IF (p_reason_id IS NOT NULL) THEN
599: l_reason_id := p_reason_id;
600: l_ret := INV_VALIDATE.reason(l_reason_id);
601: IF (l_ret = INV_VALIDATE.F) THEN
602: FND_MSG_PUB.Add;
603: RAISE FND_API.G_EXC_ERROR;
604: END IF;
605: END IF;
606:

Line 616: FND_MSG_PUB.Add;

612:
613: l_ret := mtl_lot_uom_conv_pvt.validate_update_type(
614: l_update_type_indicator);
615: IF (l_ret = G_FALSE) THEN
616: FND_MSG_PUB.Add;
617: RAISE FND_API.G_EXC_ERROR;
618: END IF;
619:
620: /*===============================

Line 688: FND_MSG_PUB.Count_AND_GET

684: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
685: END IF;
686:
687:
688: FND_MSG_PUB.Count_AND_GET
689: (p_count => x_msg_count, p_data => x_msg_data);
690:
691: END IF; -- process data check
692:

Line 733: FND_MSG_PUB.Count_AND_GET

729:
730: WHEN DO_CHECK_ERROR THEN
731: ROLLBACK TO SAVEPOINT LOT_UOM_CONVERSION;
732: x_return_status := FND_API.G_RET_STS_ERROR;
733: FND_MSG_PUB.Count_AND_GET
734: (p_count => x_msg_count, p_data => x_msg_data);
735:
736: WHEN FND_API.G_EXC_ERROR THEN
737: ROLLBACK TO SAVEPOINT LOT_UOM_CONVERSION;

Line 739: FND_MSG_PUB.Count_AND_GET

735:
736: WHEN FND_API.G_EXC_ERROR THEN
737: ROLLBACK TO SAVEPOINT LOT_UOM_CONVERSION;
738: x_return_status := FND_API.G_RET_STS_ERROR;
739: FND_MSG_PUB.Count_AND_GET
740: (p_count => x_msg_count, p_data => x_msg_data);
741:
742: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
743: ROLLBACK TO SAVEPOINT LOT_UOM_CONVERSION;

Line 745: FND_MSG_PUB.Count_AND_GET

741:
742: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
743: ROLLBACK TO SAVEPOINT LOT_UOM_CONVERSION;
744: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
745: FND_MSG_PUB.Count_AND_GET
746: (p_count => x_msg_count, p_data => x_msg_data);
747:
748: WHEN OTHERS THEN
749: ROLLBACK TO SAVEPOINT LOT_UOM_CONVERSION;

Line 751: FND_MSG_PUB.Count_AND_GET

747:
748: WHEN OTHERS THEN
749: ROLLBACK TO SAVEPOINT LOT_UOM_CONVERSION;
750: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
751: FND_MSG_PUB.Count_AND_GET
752: (p_count => x_msg_count, p_data => x_msg_data);
753:
754: END create_lot_uom_conversion;
755:

Line 762: FND_MSG_PUB.Add;

758: BEGIN
759:
760: FND_MESSAGE.SET_NAME('GMI','GMI_DEBUG_API');
761: FND_MESSAGE.SET_TOKEN('MSG',p_msg_text);
762: FND_MSG_PUB.Add;
763:
764: END log_msg ;
765:
766: END MTL_LOT_UOM_CONV_PUB;