DBA Data[Home] [Help]

APPS.MTL_LOT_UOM_CONV_PUB dependencies on FND_MESSAGE

Line 250: FND_MESSAGE.SET_NAME('INV','INV_LOTC_ACTIONTYPE_INVALID');

246: Validate Action Type
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:

Line 263: FND_MESSAGE.SET_NAME('INV','INV_LOTC_ORG_INVALID');

259: ==============================*/
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:

Line 276: FND_MESSAGE.SET_NAME('INV','INV_LOTC_ITEM_INVALID');

272: l_item.organization_id := p_lot_uom_conv_rec.organization_id;
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:

Line 289: FND_MESSAGE.SET_NAME('INV','INV_LOTC_LOT_INVALID');

285: l_lot.organization_id := p_lot_uom_conv_rec.organization_id;
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:

Line 309: FND_MESSAGE.SET_NAME('INV','INV_LOTC_SOURCE_UOM_REQD');

305:
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:

Line 317: FND_MESSAGE.SET_NAME('INV','INV_LOTC_TARGET_UOM_REQD');

313:
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:

Line 333: FND_MESSAGE.SET_NAME('INV','INV_GET_UOM_ERR');

329: OPEN get_uom_code_values(l_from_uom_code);
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;

Line 344: FND_MESSAGE.SET_NAME('INV','INV_GET_UNITOFMEASURE_ERR');

340: OPEN get_unit_of_meas_values(l_from_unit_of_measure);
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;

Line 355: FND_MESSAGE.SET_NAME('INV','INV_GET_UOM_CLASS_ERR');

351: OPEN get_uom_class_values(l_from_uom_class);
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;

Line 374: FND_MESSAGE.SET_NAME('INV','INV_GET_UOM_ERR');

370: OPEN get_uom_code_values(l_to_uom_code);
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;

Line 385: FND_MESSAGE.SET_NAME('INV','INV_GET_UNITOFMEASURE_ERR');

381: OPEN get_unit_of_meas_values(l_to_unit_of_measure);
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;

Line 396: FND_MESSAGE.SET_NAME('INV','INV_GET_UOM_CLASS_ERR');

392: OPEN get_uom_class_values(l_to_uom_class);
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;

Line 422: FND_MESSAGE.SET_NAME('INV','INV_ITEMUOM');

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

Line 435: FND_MESSAGE.SET_NAME('INV','INV_ITEMUOM_CLASS');

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

Line 448: FND_MESSAGE.SET_NAME('INV','INV_CLASSMISMATCH');

444: ==========================================*/
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:

Line 461: FND_MESSAGE.SET_NAME('INV','INV_FROMBASE_ERROR');

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

Line 490: FND_MESSAGE.SET_NAME('INV','INV_FROMBASE_CONV_ERROR');

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

Line 508: FND_MESSAGE.SET_NAME('INV','INV_TOBASE_ERROR');

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

Line 537: FND_MESSAGE.SET_NAME('INV','INV_TOBASE_CONV_ERROR');

533: TO_NAME => l_to_base_unit_of_measure
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;

Line 571: FND_MESSAGE.SET_NAME('INV','INV_LOTC_CONVRATE_INVALID');

567: -- and is greater than zero.
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:

Line 760: FND_MESSAGE.SET_NAME('GMI','GMI_DEBUG_API');

756:
757: PROCEDURE log_msg(p_msg_text IN VARCHAR2) IS
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 ;

Line 761: FND_MESSAGE.SET_TOKEN('MSG',p_msg_text);

757: PROCEDURE log_msg(p_msg_text IN VARCHAR2) IS
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: