DBA Data[Home] [Help]

APPS.MTL_LOT_UOM_CONV_PUB dependencies on FND_MESSAGE

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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