299:
300: BEGIN
301:
302: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
303: fnd_message.get_string('OPI', 'OPI_DBI_MISSING_UOM'));
304:
305: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, NEWLINE);
306:
307: l_label1 := fnd_message.get_string('OPI', 'OPI_DBI_COL_FROM_UOM');
303: fnd_message.get_string('OPI', 'OPI_DBI_MISSING_UOM'));
304:
305: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, NEWLINE);
306:
307: l_label1 := fnd_message.get_string('OPI', 'OPI_DBI_COL_FROM_UOM');
308: l_label2 := fnd_message.get_string('OPI', 'OPI_DBI_COL_FROM_UOM_CLASS');
309: l_label3 := fnd_message.get_string('OPI', 'OPI_DBI_COL_TO_UOM');
310: l_label4 := fnd_message.get_string('OPI', 'OPI_DBI_COL_TO_UOM_CLASS');
311:
304:
305: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, NEWLINE);
306:
307: l_label1 := fnd_message.get_string('OPI', 'OPI_DBI_COL_FROM_UOM');
308: l_label2 := fnd_message.get_string('OPI', 'OPI_DBI_COL_FROM_UOM_CLASS');
309: l_label3 := fnd_message.get_string('OPI', 'OPI_DBI_COL_TO_UOM');
310: l_label4 := fnd_message.get_string('OPI', 'OPI_DBI_COL_TO_UOM_CLASS');
311:
312: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,
305: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, NEWLINE);
306:
307: l_label1 := fnd_message.get_string('OPI', 'OPI_DBI_COL_FROM_UOM');
308: l_label2 := fnd_message.get_string('OPI', 'OPI_DBI_COL_FROM_UOM_CLASS');
309: l_label3 := fnd_message.get_string('OPI', 'OPI_DBI_COL_TO_UOM');
310: l_label4 := fnd_message.get_string('OPI', 'OPI_DBI_COL_TO_UOM_CLASS');
311:
312: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,
313: rpad(l_label1, COL_WIDTH) ||
306:
307: l_label1 := fnd_message.get_string('OPI', 'OPI_DBI_COL_FROM_UOM');
308: l_label2 := fnd_message.get_string('OPI', 'OPI_DBI_COL_FROM_UOM_CLASS');
309: l_label3 := fnd_message.get_string('OPI', 'OPI_DBI_COL_TO_UOM');
310: l_label4 := fnd_message.get_string('OPI', 'OPI_DBI_COL_TO_UOM_CLASS');
311:
312: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,
313: rpad(l_label1, COL_WIDTH) ||
314: rpad(l_label2, COL_WIDTH) ||
402: rpad(l_to_class, COL_WIDTH));
403:
404: EXCEPTION
405: when invalid_from_uom then
406: BIS_COLLECTION_UTILITIES.PUT_LINE (fnd_message.get_string('OPI', 'OPI_DBI_INVALID_UOM_CODE')
407: || ' ' || p_from_uom_code);
408: when invalid_to_uom then
409: BIS_COLLECTION_UTILITIES.PUT_LINE (fnd_message.get_string('OPI', 'OPI_DBI_INVALID_UOM_CODE')
410: || ' ' || p_to_uom_code);
405: when invalid_from_uom then
406: BIS_COLLECTION_UTILITIES.PUT_LINE (fnd_message.get_string('OPI', 'OPI_DBI_INVALID_UOM_CODE')
407: || ' ' || p_from_uom_code);
408: when invalid_to_uom then
409: BIS_COLLECTION_UTILITIES.PUT_LINE (fnd_message.get_string('OPI', 'OPI_DBI_INVALID_UOM_CODE')
410: || ' ' || p_to_uom_code);
411: when others then
412: BIS_COLLECTION_UTILITIES.PUT_LINE (fnd_message.get_string('OPI', 'OPI_DBI_UOM_ERR_REPORTING_ERR'));
413:
408: when invalid_to_uom then
409: BIS_COLLECTION_UTILITIES.PUT_LINE (fnd_message.get_string('OPI', 'OPI_DBI_INVALID_UOM_CODE')
410: || ' ' || p_to_uom_code);
411: when others then
412: BIS_COLLECTION_UTILITIES.PUT_LINE (fnd_message.get_string('OPI', 'OPI_DBI_UOM_ERR_REPORTING_ERR'));
413:
414: END err_msg_missing_uoms;
415:
416:
442: CASE
443: WHEN (p_measure_code = 'WT' AND p_entity_type = 'ITEM') THEN
444:
445: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,
446: fnd_message.get_string('OPI', 'OPI_DBI_MISSING_ITEM_WT_UOM'));
447: WHEN (p_measure_code = 'VOL' AND p_entity_type = 'ITEM') THEN
448:
449: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,
450: fnd_message.get_string('OPI', 'OPI_DBI_MISSING_ITEM_VOL_UOM'));
446: fnd_message.get_string('OPI', 'OPI_DBI_MISSING_ITEM_WT_UOM'));
447: WHEN (p_measure_code = 'VOL' AND p_entity_type = 'ITEM') THEN
448:
449: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,
450: fnd_message.get_string('OPI', 'OPI_DBI_MISSING_ITEM_VOL_UOM'));
451: WHEN (p_measure_code = 'WT' AND p_entity_type = 'LOC') THEN
452:
453: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,
454: fnd_message.get_string('OPI', 'OPI_DBI_MISSING_LOC_WT_UOM'));
450: fnd_message.get_string('OPI', 'OPI_DBI_MISSING_ITEM_VOL_UOM'));
451: WHEN (p_measure_code = 'WT' AND p_entity_type = 'LOC') THEN
452:
453: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,
454: fnd_message.get_string('OPI', 'OPI_DBI_MISSING_LOC_WT_UOM'));
455: WHEN (p_measure_code = 'VOL' AND p_entity_type = 'LOC') THEN
456:
457: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,
458: fnd_message.get_string('OPI', 'OPI_DBI_MISSING_LOC_VOL_UOM'));
454: fnd_message.get_string('OPI', 'OPI_DBI_MISSING_LOC_WT_UOM'));
455: WHEN (p_measure_code = 'VOL' AND p_entity_type = 'LOC') THEN
456:
457: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,
458: fnd_message.get_string('OPI', 'OPI_DBI_MISSING_LOC_VOL_UOM'));
459: ELSE
460: -- Default to the basic message
461: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
462: fnd_message.get_string('OPI',
458: fnd_message.get_string('OPI', 'OPI_DBI_MISSING_LOC_VOL_UOM'));
459: ELSE
460: -- Default to the basic message
461: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
462: fnd_message.get_string('OPI',
463: 'OPI_DBI_MISSING_UOM'));
464: END CASE;
465:
466: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, NEWLINE);
464: END CASE;
465:
466: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, NEWLINE);
467:
468: l_label1 := fnd_message.get_string('OPI', 'OPI_DBI_COL_FROM_UOM');
469: l_label2 := fnd_message.get_string('OPI', 'OPI_DBI_COL_FROM_UOM_CLASS');
470: l_label3 := fnd_message.get_string('OPI', 'OPI_DBI_COL_TO_UOM');
471: l_label4 := fnd_message.get_string('OPI', 'OPI_DBI_COL_TO_UOM_CLASS');
472:
465:
466: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, NEWLINE);
467:
468: l_label1 := fnd_message.get_string('OPI', 'OPI_DBI_COL_FROM_UOM');
469: l_label2 := fnd_message.get_string('OPI', 'OPI_DBI_COL_FROM_UOM_CLASS');
470: l_label3 := fnd_message.get_string('OPI', 'OPI_DBI_COL_TO_UOM');
471: l_label4 := fnd_message.get_string('OPI', 'OPI_DBI_COL_TO_UOM_CLASS');
472:
473: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,
466: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, NEWLINE);
467:
468: l_label1 := fnd_message.get_string('OPI', 'OPI_DBI_COL_FROM_UOM');
469: l_label2 := fnd_message.get_string('OPI', 'OPI_DBI_COL_FROM_UOM_CLASS');
470: l_label3 := fnd_message.get_string('OPI', 'OPI_DBI_COL_TO_UOM');
471: l_label4 := fnd_message.get_string('OPI', 'OPI_DBI_COL_TO_UOM_CLASS');
472:
473: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,
474: rpad(l_label1, COL_WIDTH) ||
467:
468: l_label1 := fnd_message.get_string('OPI', 'OPI_DBI_COL_FROM_UOM');
469: l_label2 := fnd_message.get_string('OPI', 'OPI_DBI_COL_FROM_UOM_CLASS');
470: l_label3 := fnd_message.get_string('OPI', 'OPI_DBI_COL_TO_UOM');
471: l_label4 := fnd_message.get_string('OPI', 'OPI_DBI_COL_TO_UOM_CLASS');
472:
473: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,
474: rpad(l_label1, COL_WIDTH) ||
475: rpad(l_label2, COL_WIDTH) ||