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 232: FND_MSG_PUB.Initialize;

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

Line 253: FND_MSG_PUB.Add;

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

Line 266: FND_MSG_PUB.Add;

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

Line 279: FND_MSG_PUB.Add;

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

Line 292: FND_MSG_PUB.Add;

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

Line 312: FND_MSG_PUB.Add;

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

Line 320: FND_MSG_PUB.Add;

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

Line 336: FND_MSG_PUB.Add;

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

Line 347: FND_MSG_PUB.Add;

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

Line 358: FND_MSG_PUB.Add;

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

Line 377: FND_MSG_PUB.Add;

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

Line 388: FND_MSG_PUB.Add;

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

Line 399: FND_MSG_PUB.Add;

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

Line 425: FND_MSG_PUB.Add;

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

Line 438: FND_MSG_PUB.Add;

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

Line 451: FND_MSG_PUB.Add;

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

Line 464: FND_MSG_PUB.Add;

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

Line 493: FND_MSG_PUB.Add;

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

Line 511: FND_MSG_PUB.Add;

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

Line 540: FND_MSG_PUB.Add;

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

Line 574: FND_MSG_PUB.Add;

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

Line 604: FND_MSG_PUB.Add;

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

Line 618: FND_MSG_PUB.Add;

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

Line 710: FND_MSG_PUB.Count_AND_GET

706: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
707: END IF;
708:
709:
710: FND_MSG_PUB.Count_AND_GET
711: (p_count => x_msg_count, p_data => x_msg_data);
712:
713: END IF; -- process data check
714:

Line 755: FND_MSG_PUB.Count_AND_GET

751:
752: WHEN DO_CHECK_ERROR THEN
753: ROLLBACK TO SAVEPOINT LOT_UOM_CONVERSION;
754: x_return_status := FND_API.G_RET_STS_ERROR;
755: FND_MSG_PUB.Count_AND_GET
756: (p_count => x_msg_count, p_data => x_msg_data);
757:
758: WHEN FND_API.G_EXC_ERROR THEN
759: ROLLBACK TO SAVEPOINT LOT_UOM_CONVERSION;

Line 761: FND_MSG_PUB.Count_AND_GET

757:
758: WHEN FND_API.G_EXC_ERROR THEN
759: ROLLBACK TO SAVEPOINT LOT_UOM_CONVERSION;
760: x_return_status := FND_API.G_RET_STS_ERROR;
761: FND_MSG_PUB.Count_AND_GET
762: (p_count => x_msg_count, p_data => x_msg_data);
763:
764: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
765: ROLLBACK TO SAVEPOINT LOT_UOM_CONVERSION;

Line 767: FND_MSG_PUB.Count_AND_GET

763:
764: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
765: ROLLBACK TO SAVEPOINT LOT_UOM_CONVERSION;
766: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
767: FND_MSG_PUB.Count_AND_GET
768: (p_count => x_msg_count, p_data => x_msg_data);
769:
770: WHEN OTHERS THEN
771: ROLLBACK TO SAVEPOINT LOT_UOM_CONVERSION;

Line 773: FND_MSG_PUB.Count_AND_GET

769:
770: WHEN OTHERS THEN
771: ROLLBACK TO SAVEPOINT LOT_UOM_CONVERSION;
772: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
773: FND_MSG_PUB.Count_AND_GET
774: (p_count => x_msg_count, p_data => x_msg_data);
775:
776: END create_lot_uom_conversion;
777:

Line 784: FND_MSG_PUB.Add;

780: BEGIN
781:
782: FND_MESSAGE.SET_NAME('GMI','GMI_DEBUG_API');
783: FND_MESSAGE.SET_TOKEN('MSG',p_msg_text);
784: FND_MSG_PUB.Add;
785:
786: END log_msg ;
787:
788: END MTL_LOT_UOM_CONV_PUB;