DBA Data[Home] [Help]

APPS.OPI_DBI_WMS_STORAGE_UTZ_PKG dependencies on OPI_DBI_REP_UOM_PKG

Line 425: OPI_DBI_REP_UOM_PKG.err_msg_header_spec ('WT', 'ITEM');

421: -- Print the header once
422: l_stmt_id := 20;
423: IF (l_header_printed = FALSE) THEN
424:
425: OPI_DBI_REP_UOM_PKG.err_msg_header_spec ('WT', 'ITEM');
426: l_header_printed := TRUE;
427:
428: END IF;
429:

Line 432: OPI_DBI_REP_UOM_PKG.err_msg_missing_uoms (

428: END IF;
429:
430: -- Print the missing rates.
431: l_stmt_id := 30;
432: OPI_DBI_REP_UOM_PKG.err_msg_missing_uoms (
433: l_err_rec.uom_code, s_wt_rep_uom_code);
434:
435: -- Found at least one bad rate
436: l_stmt_id := 40;

Line 445: OPI_DBI_REP_UOM_PKG.err_msg_footer;

441: END LOOP;
442:
443: -- Footer message.
444: IF (l_header_printed = TRUE) THEN
445: OPI_DBI_REP_UOM_PKG.err_msg_footer;
446: END IF;
447:
448: -- Print the header for volume missing rates again.
449: l_header_printed := FALSE;

Line 461: OPI_DBI_REP_UOM_PKG.err_msg_header_spec ('VOL', 'ITEM');

457: -- Print the header once
458: l_stmt_id := 20;
459: IF (l_header_printed = FALSE) THEN
460:
461: OPI_DBI_REP_UOM_PKG.err_msg_header_spec ('VOL', 'ITEM');
462: l_header_printed := TRUE;
463:
464: END IF;
465:

Line 468: OPI_DBI_REP_UOM_PKG.err_msg_missing_uoms (

464: END IF;
465:
466: -- Print the missing rates.
467: l_stmt_id := 30;
468: OPI_DBI_REP_UOM_PKG.err_msg_missing_uoms (
469: l_err_rec.uom_code, s_vol_rep_uom_code);
470:
471: -- Found at least one bad rate
472: l_stmt_id := 40;

Line 481: OPI_DBI_REP_UOM_PKG.err_msg_footer;

477: END LOOP;
478:
479: -- Footer message.
480: IF (l_header_printed = TRUE) THEN
481: OPI_DBI_REP_UOM_PKG.err_msg_footer;
482: END IF;
483:
484: -- Finally!
485: return l_missing_rates;