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.OPI_DBI_WMS_UTILITY_PKG dependencies on FND_FILE

Line 260: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, C_BLANK_LINE);

256: IF (l_num_rows_missing > 0) THEN
257:
258: -- Item setup missing header message
259: l_stmt_id := 30;
260: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, C_BLANK_LINE);
261: l_item_missing_header := FND_MESSAGE.get_string (
262: 'OPI','OPI_DBI_ITEM_WT_VOL_MISSING');
263: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, l_item_missing_header);
264:

Line 263: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, l_item_missing_header);

259: l_stmt_id := 30;
260: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, C_BLANK_LINE);
261: l_item_missing_header := FND_MESSAGE.get_string (
262: 'OPI','OPI_DBI_ITEM_WT_VOL_MISSING');
263: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, l_item_missing_header);
264:
265: -- Item setup missing fix message. Print it.
266: l_stmt_id := 40;
267: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, C_BLANK_LINE);

Line 267: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, C_BLANK_LINE);

263: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, l_item_missing_header);
264:
265: -- Item setup missing fix message. Print it.
266: l_stmt_id := 40;
267: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, C_BLANK_LINE);
268: l_item_missing_fix := FND_MESSAGE.get_string (
269: 'OPI','OPI_DBI_ITEM_WT_VOL_FIX');
270: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, l_item_missing_fix);
271:

Line 270: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, l_item_missing_fix);

266: l_stmt_id := 40;
267: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, C_BLANK_LINE);
268: l_item_missing_fix := FND_MESSAGE.get_string (
269: 'OPI','OPI_DBI_ITEM_WT_VOL_FIX');
270: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, l_item_missing_fix);
271:
272: -- If not too many rows, print out the details
273: IF (l_num_rows_missing <= C_NUM_ROWS_TO_REPORT) THEN
274:

Line 278: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, C_BLANK_LINE);

274:
275: l_stmt_id := 50;
276: -- Print out the headers padded out with the right number
277: -- of spaces.
278: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, C_BLANK_LINE);
279: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,
280: rpad (l_org_col_header,
281: l_org_col_width + C_COL_SPACING) ||
282: rpad (l_item_col_header,

Line 279: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,

275: l_stmt_id := 50;
276: -- Print out the headers padded out with the right number
277: -- of spaces.
278: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, C_BLANK_LINE);
279: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,
280: rpad (l_org_col_header,
281: l_org_col_width + C_COL_SPACING) ||
282: rpad (l_item_col_header,
283: l_item_col_width + C_COL_SPACING) ||

Line 291: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,

287: l_wt_col_width + C_COL_SPACING) );
288:
289: -- Underline the header with dashes
290: l_stmt_id := 60;
291: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,
292: rpad ('-', l_org_col_width, '-') ||
293: rpad (' ', C_COL_SPACING) ||
294: rpad ('-', l_item_col_width, '-') ||
295: rpad (' ', C_COL_SPACING) ||

Line 361: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, l_line_print);

357: END IF;
358:
359: -- Print this missing rate line.
360: l_stmt_id := 120;
361: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, l_line_print);
362:
363: -- Fetch the next line
364: FETCH item_setup_missing_csr INTO l_items_setup_missing_rec;
365:

Line 374: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, l_too_many_rows_msg);

370: ELSIF (l_num_rows_missing > C_NUM_ROWS_TO_REPORT) THEN
371:
372: l_too_many_rows_msg := FND_MESSAGE.get_string (
373: 'OPI', 'OPI_DBI_WT_VOL_SETUP_TOOMANY');
374: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, l_too_many_rows_msg);
375: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, C_BLANK_LINE);
376: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, l_item_setup_missing_sql);
377: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, C_BLANK_LINE);
378:

Line 375: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, C_BLANK_LINE);

371:
372: l_too_many_rows_msg := FND_MESSAGE.get_string (
373: 'OPI', 'OPI_DBI_WT_VOL_SETUP_TOOMANY');
374: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, l_too_many_rows_msg);
375: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, C_BLANK_LINE);
376: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, l_item_setup_missing_sql);
377: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, C_BLANK_LINE);
378:
379:

Line 376: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, l_item_setup_missing_sql);

372: l_too_many_rows_msg := FND_MESSAGE.get_string (
373: 'OPI', 'OPI_DBI_WT_VOL_SETUP_TOOMANY');
374: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, l_too_many_rows_msg);
375: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, C_BLANK_LINE);
376: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, l_item_setup_missing_sql);
377: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, C_BLANK_LINE);
378:
379:
380: END IF;

Line 377: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, C_BLANK_LINE);

373: 'OPI', 'OPI_DBI_WT_VOL_SETUP_TOOMANY');
374: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, l_too_many_rows_msg);
375: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, C_BLANK_LINE);
376: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, l_item_setup_missing_sql);
377: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, C_BLANK_LINE);
378:
379:
380: END IF;
381:

Line 578: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, C_BLANK_LINE);

574: IF (l_num_rows_missing > 0) THEN
575:
576: -- Locator setup missing header message
577: l_stmt_id := 30;
578: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, C_BLANK_LINE);
579:
580: l_loc_missing_header := FND_MESSAGE.get_string (
581: 'OPI', 'OPI_DBI_LOC_WT_VOL_MISSING');
582: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, l_loc_missing_header);

Line 582: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, l_loc_missing_header);

578: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, C_BLANK_LINE);
579:
580: l_loc_missing_header := FND_MESSAGE.get_string (
581: 'OPI', 'OPI_DBI_LOC_WT_VOL_MISSING');
582: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, l_loc_missing_header);
583: -- Locator setup missing fix message. Print it.
584: l_stmt_id := 40;
585: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, C_BLANK_LINE);
586: l_loc_missing_fix := FND_MESSAGE.get_string (

Line 585: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, C_BLANK_LINE);

581: 'OPI', 'OPI_DBI_LOC_WT_VOL_MISSING');
582: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, l_loc_missing_header);
583: -- Locator setup missing fix message. Print it.
584: l_stmt_id := 40;
585: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, C_BLANK_LINE);
586: l_loc_missing_fix := FND_MESSAGE.get_string (
587: 'OPI', 'OPI_DBI_LOC_WT_VOL_FIX');
588: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, l_loc_missing_fix);
589:

Line 588: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, l_loc_missing_fix);

584: l_stmt_id := 40;
585: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, C_BLANK_LINE);
586: l_loc_missing_fix := FND_MESSAGE.get_string (
587: 'OPI', 'OPI_DBI_LOC_WT_VOL_FIX');
588: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, l_loc_missing_fix);
589:
590: -- Only print out details if not too long. Else print out SQL
591: IF (l_num_rows_missing <= C_NUM_ROWS_TO_REPORT) THEN
592:

Line 596: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, C_BLANK_LINE);

592:
593:
594: -- Print out the headers padded out with the right number of spaces
595: l_stmt_id := 50;
596: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, C_BLANK_LINE);
597: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,
598: rpad (l_org_col_header,
599: l_org_col_width + C_COL_SPACING) ||
600: rpad (l_sub_col_header,

Line 597: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,

593:
594: -- Print out the headers padded out with the right number of spaces
595: l_stmt_id := 50;
596: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, C_BLANK_LINE);
597: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,
598: rpad (l_org_col_header,
599: l_org_col_width + C_COL_SPACING) ||
600: rpad (l_sub_col_header,
601: l_sub_col_width + C_COL_SPACING) ||

Line 611: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,

607: l_wt_col_width + C_COL_SPACING) );
608:
609: -- Underline the header with dashes
610: l_stmt_id := 60;
611: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,
612: rpad ('-', l_org_col_width, '-') ||
613: rpad (' ', C_COL_SPACING) ||
614: rpad ('-', l_sub_col_width, '-') ||
615: rpad (' ', C_COL_SPACING) ||

Line 686: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, l_line_print);

682: END IF;
683:
684: -- Print this missing rate line.
685: l_stmt_id := 120;
686: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, l_line_print);
687:
688: -- Get the next row.
689: FETCH locator_setup_missing_csr INTO locator_setup_missing_rec;
690:

Line 698: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, l_too_many_rows_msg);

694:
695: ELSIF (l_num_rows_missing > C_NUM_ROWS_TO_REPORT) THEN
696: l_too_many_rows_msg := FND_MESSAGE.get_string (
697: 'OPI', 'OPI_DBI_WT_VOL_SETUP_TOOMANY');
698: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, l_too_many_rows_msg);
699: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, C_BLANK_LINE);
700: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, l_locator_setup_missing_sql);
701: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, C_BLANK_LINE);
702: END IF;

Line 699: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, C_BLANK_LINE);

695: ELSIF (l_num_rows_missing > C_NUM_ROWS_TO_REPORT) THEN
696: l_too_many_rows_msg := FND_MESSAGE.get_string (
697: 'OPI', 'OPI_DBI_WT_VOL_SETUP_TOOMANY');
698: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, l_too_many_rows_msg);
699: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, C_BLANK_LINE);
700: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, l_locator_setup_missing_sql);
701: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, C_BLANK_LINE);
702: END IF;
703:

Line 700: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, l_locator_setup_missing_sql);

696: l_too_many_rows_msg := FND_MESSAGE.get_string (
697: 'OPI', 'OPI_DBI_WT_VOL_SETUP_TOOMANY');
698: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, l_too_many_rows_msg);
699: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, C_BLANK_LINE);
700: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, l_locator_setup_missing_sql);
701: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, C_BLANK_LINE);
702: END IF;
703:
704: END IF; -- l_num_rows_to_report > 0

Line 701: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, C_BLANK_LINE);

697: 'OPI', 'OPI_DBI_WT_VOL_SETUP_TOOMANY');
698: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, l_too_many_rows_msg);
699: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, C_BLANK_LINE);
700: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, l_locator_setup_missing_sql);
701: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, C_BLANK_LINE);
702: END IF;
703:
704: END IF; -- l_num_rows_to_report > 0
705:

Line 889: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, C_BLANK_LINE);

885: l_stmt_id := 40;
886: IF (l_header_printed = FALSE) THEN
887:
888: -- Blank line.
889: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, C_BLANK_LINE);
890: -- Locator volume missing header
891: FND_FILE.PUT_LINE (
892: FND_FILE.OUTPUT,
893: FND_MESSAGE.get_string ('OPI',

Line 891: FND_FILE.PUT_LINE (

887:
888: -- Blank line.
889: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, C_BLANK_LINE);
890: -- Locator volume missing header
891: FND_FILE.PUT_LINE (
892: FND_FILE.OUTPUT,
893: FND_MESSAGE.get_string ('OPI',
894: 'OPI_DBI_ITEM_VOL_CONV_ERR_HDR'));
895:

Line 892: FND_FILE.OUTPUT,

888: -- Blank line.
889: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, C_BLANK_LINE);
890: -- Locator volume missing header
891: FND_FILE.PUT_LINE (
892: FND_FILE.OUTPUT,
893: FND_MESSAGE.get_string ('OPI',
894: 'OPI_DBI_ITEM_VOL_CONV_ERR_HDR'));
895:
896: -- Blank line.

Line 897: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, C_BLANK_LINE);

893: FND_MESSAGE.get_string ('OPI',
894: 'OPI_DBI_ITEM_VOL_CONV_ERR_HDR'));
895:
896: -- Blank line.
897: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, C_BLANK_LINE);
898: -- Volume reporting UOM.
899: FND_FILE.PUT_LINE (
900: FND_FILE.OUTPUT,
901: FND_MESSAGE.get_string ('OPI', 'OPI_DBI_REP_UOM_VOL') ||

Line 899: FND_FILE.PUT_LINE (

895:
896: -- Blank line.
897: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, C_BLANK_LINE);
898: -- Volume reporting UOM.
899: FND_FILE.PUT_LINE (
900: FND_FILE.OUTPUT,
901: FND_MESSAGE.get_string ('OPI', 'OPI_DBI_REP_UOM_VOL') ||
902: ' ' || l_uom);
903:

Line 900: FND_FILE.OUTPUT,

896: -- Blank line.
897: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, C_BLANK_LINE);
898: -- Volume reporting UOM.
899: FND_FILE.PUT_LINE (
900: FND_FILE.OUTPUT,
901: FND_MESSAGE.get_string ('OPI', 'OPI_DBI_REP_UOM_VOL') ||
902: ' ' || l_uom);
903:
904:

Line 906: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, C_BLANK_LINE);

902: ' ' || l_uom);
903:
904:
905: -- Blank line.
906: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, C_BLANK_LINE);
907: -- Table header row
908: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,
909: rpad (l_org_col_header,
910: l_org_col_width + C_COL_SPACING) ||

Line 908: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,

904:
905: -- Blank line.
906: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, C_BLANK_LINE);
907: -- Table header row
908: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,
909: rpad (l_org_col_header,
910: l_org_col_width + C_COL_SPACING) ||
911: rpad (l_item_col_header,
912: l_item_col_width + C_COL_SPACING) ||

Line 917: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,

913: rpad (l_vol_col_header,
914: l_vol_col_width + C_COL_SPACING));
915:
916: -- Table header underline
917: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,
918: rpad ('-', l_org_col_width, '-') ||
919: rpad (' ', C_COL_SPACING) ||
920: rpad ('-', l_item_col_width, '-') ||
921: rpad (' ', C_COL_SPACING) ||

Line 933: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,

929:
930:
931: -- Output every row.
932: l_stmt_id := 50;
933: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,
934: rpad (substr (missing_vol_conv_rec.org, 1,
935: l_org_col_width),
936: l_org_col_width + C_COL_SPACING) ||
937: rpad (substr (missing_vol_conv_rec.item, 1,

Line 949: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, C_BLANK_LINE);

945:
946: -- Footer for this section
947: l_stmt_id := 60;
948: IF (l_header_printed = TRUE) THEN
949: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, C_BLANK_LINE);
950: OPI_DBI_REP_UOM_PKG.err_msg_footer;
951: END IF;
952:
953: END IF;

Line 983: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, C_BLANK_LINE);

979: IF (l_header_printed = FALSE) THEN
980:
981:
982: -- Blank line.
983: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, C_BLANK_LINE);
984: -- Locator volume missing header
985: FND_FILE.PUT_LINE (
986: FND_FILE.OUTPUT,
987: FND_MESSAGE.get_string ('OPI',

Line 985: FND_FILE.PUT_LINE (

981:
982: -- Blank line.
983: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, C_BLANK_LINE);
984: -- Locator volume missing header
985: FND_FILE.PUT_LINE (
986: FND_FILE.OUTPUT,
987: FND_MESSAGE.get_string ('OPI',
988: 'OPI_DBI_ITEM_WT_CONV_ERR_HDR'));
989:

Line 986: FND_FILE.OUTPUT,

982: -- Blank line.
983: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, C_BLANK_LINE);
984: -- Locator volume missing header
985: FND_FILE.PUT_LINE (
986: FND_FILE.OUTPUT,
987: FND_MESSAGE.get_string ('OPI',
988: 'OPI_DBI_ITEM_WT_CONV_ERR_HDR'));
989:
990: -- Blank line.

Line 991: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, C_BLANK_LINE);

987: FND_MESSAGE.get_string ('OPI',
988: 'OPI_DBI_ITEM_WT_CONV_ERR_HDR'));
989:
990: -- Blank line.
991: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, C_BLANK_LINE);
992: -- Volume reporting UOM.
993: FND_FILE.PUT_LINE (
994: FND_FILE.OUTPUT,
995: FND_MESSAGE.get_string ('OPI', 'OPI_DBI_REP_UOM_WT') ||

Line 993: FND_FILE.PUT_LINE (

989:
990: -- Blank line.
991: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, C_BLANK_LINE);
992: -- Volume reporting UOM.
993: FND_FILE.PUT_LINE (
994: FND_FILE.OUTPUT,
995: FND_MESSAGE.get_string ('OPI', 'OPI_DBI_REP_UOM_WT') ||
996: ' ' || l_uom);
997:

Line 994: FND_FILE.OUTPUT,

990: -- Blank line.
991: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, C_BLANK_LINE);
992: -- Volume reporting UOM.
993: FND_FILE.PUT_LINE (
994: FND_FILE.OUTPUT,
995: FND_MESSAGE.get_string ('OPI', 'OPI_DBI_REP_UOM_WT') ||
996: ' ' || l_uom);
997:
998: -- Blank line.

Line 999: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, C_BLANK_LINE);

995: FND_MESSAGE.get_string ('OPI', 'OPI_DBI_REP_UOM_WT') ||
996: ' ' || l_uom);
997:
998: -- Blank line.
999: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, C_BLANK_LINE);
1000: -- Table header row
1001: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,
1002: rpad (l_org_col_header,
1003: l_org_col_width + C_COL_SPACING) ||

Line 1001: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,

997:
998: -- Blank line.
999: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, C_BLANK_LINE);
1000: -- Table header row
1001: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,
1002: rpad (l_org_col_header,
1003: l_org_col_width + C_COL_SPACING) ||
1004: rpad (l_item_col_header,
1005: l_item_col_width + C_COL_SPACING) ||

Line 1010: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,

1006: rpad (l_vol_col_header,
1007: l_vol_col_width + C_COL_SPACING));
1008:
1009: -- Table header underline
1010: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,
1011: rpad ('-', l_org_col_width, '-') ||
1012: rpad (' ', C_COL_SPACING) ||
1013: rpad ('-', l_item_col_width, '-') ||
1014: rpad (' ', C_COL_SPACING) ||

Line 1026: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,

1022:
1023:
1024: -- Output every row.
1025: l_stmt_id := 150;
1026: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,
1027: rpad (substr (missing_wt_conv_rec.org, 1,
1028: l_org_col_width),
1029: l_org_col_width + C_COL_SPACING) ||
1030: rpad (substr (missing_wt_conv_rec.item, 1,

Line 1042: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, C_BLANK_LINE);

1038:
1039: -- Footer for this section
1040: l_stmt_id := 160;
1041: IF (l_header_printed = TRUE) THEN
1042: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, C_BLANK_LINE);
1043: OPI_DBI_REP_UOM_PKG.err_msg_footer;
1044: END IF;
1045:
1046: END IF;

Line 1210: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, C_BLANK_LINE);

1206: l_stmt_id := 40;
1207: IF (l_header_printed = FALSE) THEN
1208:
1209: -- Blank line.
1210: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, C_BLANK_LINE);
1211: -- Volume reporting UOM.
1212: FND_FILE.PUT_LINE (
1213: FND_FILE.OUTPUT,
1214: FND_MESSAGE.get_string ('OPI', 'OPI_DBI_REP_UOM_VOL') ||

Line 1212: FND_FILE.PUT_LINE (

1208:
1209: -- Blank line.
1210: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, C_BLANK_LINE);
1211: -- Volume reporting UOM.
1212: FND_FILE.PUT_LINE (
1213: FND_FILE.OUTPUT,
1214: FND_MESSAGE.get_string ('OPI', 'OPI_DBI_REP_UOM_VOL') ||
1215: ' ' || l_uom);
1216:

Line 1213: FND_FILE.OUTPUT,

1209: -- Blank line.
1210: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, C_BLANK_LINE);
1211: -- Volume reporting UOM.
1212: FND_FILE.PUT_LINE (
1213: FND_FILE.OUTPUT,
1214: FND_MESSAGE.get_string ('OPI', 'OPI_DBI_REP_UOM_VOL') ||
1215: ' ' || l_uom);
1216:
1217: -- Blank line.

Line 1218: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, C_BLANK_LINE);

1214: FND_MESSAGE.get_string ('OPI', 'OPI_DBI_REP_UOM_VOL') ||
1215: ' ' || l_uom);
1216:
1217: -- Blank line.
1218: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, C_BLANK_LINE);
1219: -- Locator volume missing header
1220: FND_FILE.PUT_LINE (
1221: FND_FILE.OUTPUT,
1222: FND_MESSAGE.get_string ('OPI',

Line 1220: FND_FILE.PUT_LINE (

1216:
1217: -- Blank line.
1218: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, C_BLANK_LINE);
1219: -- Locator volume missing header
1220: FND_FILE.PUT_LINE (
1221: FND_FILE.OUTPUT,
1222: FND_MESSAGE.get_string ('OPI',
1223: 'OPI_DBI_LOC_VOL_CONV_ERR_HDR'));
1224:

Line 1221: FND_FILE.OUTPUT,

1217: -- Blank line.
1218: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, C_BLANK_LINE);
1219: -- Locator volume missing header
1220: FND_FILE.PUT_LINE (
1221: FND_FILE.OUTPUT,
1222: FND_MESSAGE.get_string ('OPI',
1223: 'OPI_DBI_LOC_VOL_CONV_ERR_HDR'));
1224:
1225: -- Blank line.

Line 1226: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, C_BLANK_LINE);

1222: FND_MESSAGE.get_string ('OPI',
1223: 'OPI_DBI_LOC_VOL_CONV_ERR_HDR'));
1224:
1225: -- Blank line.
1226: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, C_BLANK_LINE);
1227: -- Volume reporting UOM.
1228: FND_FILE.PUT_LINE (
1229: FND_FILE.OUTPUT,
1230: FND_MESSAGE.get_string ('OPI', 'OPI_DBI_REP_UOM_VOL') ||

Line 1228: FND_FILE.PUT_LINE (

1224:
1225: -- Blank line.
1226: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, C_BLANK_LINE);
1227: -- Volume reporting UOM.
1228: FND_FILE.PUT_LINE (
1229: FND_FILE.OUTPUT,
1230: FND_MESSAGE.get_string ('OPI', 'OPI_DBI_REP_UOM_VOL') ||
1231: ' ' || l_uom);
1232:

Line 1229: FND_FILE.OUTPUT,

1225: -- Blank line.
1226: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, C_BLANK_LINE);
1227: -- Volume reporting UOM.
1228: FND_FILE.PUT_LINE (
1229: FND_FILE.OUTPUT,
1230: FND_MESSAGE.get_string ('OPI', 'OPI_DBI_REP_UOM_VOL') ||
1231: ' ' || l_uom);
1232:
1233: -- Blank line.

Line 1234: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, C_BLANK_LINE);

1230: FND_MESSAGE.get_string ('OPI', 'OPI_DBI_REP_UOM_VOL') ||
1231: ' ' || l_uom);
1232:
1233: -- Blank line.
1234: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, C_BLANK_LINE);
1235: -- Table header row
1236: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,
1237: rpad (l_org_col_header,
1238: l_org_col_width + C_COL_SPACING) ||

Line 1236: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,

1232:
1233: -- Blank line.
1234: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, C_BLANK_LINE);
1235: -- Table header row
1236: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,
1237: rpad (l_org_col_header,
1238: l_org_col_width + C_COL_SPACING) ||
1239: rpad (l_sub_col_header,
1240: l_sub_col_width + C_COL_SPACING) ||

Line 1247: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,

1243: rpad (l_vol_col_header,
1244: l_vol_col_width + C_COL_SPACING));
1245:
1246: -- Table header underline
1247: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,
1248: rpad ('-', l_org_col_width, '-') ||
1249: rpad (' ', C_COL_SPACING) ||
1250: rpad ('-', l_sub_col_width, '-') ||
1251: rpad (' ', C_COL_SPACING) ||

Line 1265: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,

1261:
1262:
1263: -- Output every row.
1264: l_stmt_id := 50;
1265: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,
1266: rpad (substr (missing_vol_conv_rec.org, 1,
1267: l_org_col_width),
1268: l_org_col_width + C_COL_SPACING) ||
1269: rpad (substr (missing_vol_conv_rec.sub, 1,

Line 1284: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, C_BLANK_LINE);

1280:
1281: -- Footer for this section
1282: l_stmt_id := 60;
1283: IF (l_header_printed = TRUE) THEN
1284: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, C_BLANK_LINE);
1285: OPI_DBI_REP_UOM_PKG.err_msg_footer;
1286: END IF;
1287:
1288: END IF;

Line 1317: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, C_BLANK_LINE);

1313: l_stmt_id := 120;
1314: IF (l_header_printed = FALSE) THEN
1315:
1316: -- Blank line.
1317: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, C_BLANK_LINE);
1318: -- Locator weight missing header
1319: FND_FILE.PUT_LINE (
1320: FND_FILE.OUTPUT,
1321: FND_MESSAGE.get_string ('OPI',

Line 1319: FND_FILE.PUT_LINE (

1315:
1316: -- Blank line.
1317: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, C_BLANK_LINE);
1318: -- Locator weight missing header
1319: FND_FILE.PUT_LINE (
1320: FND_FILE.OUTPUT,
1321: FND_MESSAGE.get_string ('OPI',
1322: 'OPI_DBI_LOC_WT_CONV_ERR_HDR'));
1323:

Line 1320: FND_FILE.OUTPUT,

1316: -- Blank line.
1317: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, C_BLANK_LINE);
1318: -- Locator weight missing header
1319: FND_FILE.PUT_LINE (
1320: FND_FILE.OUTPUT,
1321: FND_MESSAGE.get_string ('OPI',
1322: 'OPI_DBI_LOC_WT_CONV_ERR_HDR'));
1323:
1324: -- Blank line.

Line 1325: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, C_BLANK_LINE);

1321: FND_MESSAGE.get_string ('OPI',
1322: 'OPI_DBI_LOC_WT_CONV_ERR_HDR'));
1323:
1324: -- Blank line.
1325: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, C_BLANK_LINE);
1326: -- Weight reporting UOM.
1327: FND_FILE.PUT_LINE (
1328: FND_FILE.OUTPUT,
1329: FND_MESSAGE.get_string ('OPI', 'OPI_DBI_REP_UOM_WT') ||

Line 1327: FND_FILE.PUT_LINE (

1323:
1324: -- Blank line.
1325: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, C_BLANK_LINE);
1326: -- Weight reporting UOM.
1327: FND_FILE.PUT_LINE (
1328: FND_FILE.OUTPUT,
1329: FND_MESSAGE.get_string ('OPI', 'OPI_DBI_REP_UOM_WT') ||
1330: ' ' || l_uom);
1331:

Line 1328: FND_FILE.OUTPUT,

1324: -- Blank line.
1325: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, C_BLANK_LINE);
1326: -- Weight reporting UOM.
1327: FND_FILE.PUT_LINE (
1328: FND_FILE.OUTPUT,
1329: FND_MESSAGE.get_string ('OPI', 'OPI_DBI_REP_UOM_WT') ||
1330: ' ' || l_uom);
1331:
1332: -- Blank line.

Line 1333: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, C_BLANK_LINE);

1329: FND_MESSAGE.get_string ('OPI', 'OPI_DBI_REP_UOM_WT') ||
1330: ' ' || l_uom);
1331:
1332: -- Blank line.
1333: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, C_BLANK_LINE);
1334: -- Table header row
1335: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,
1336: rpad (l_org_col_header,
1337: l_org_col_width + C_COL_SPACING) ||

Line 1335: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,

1331:
1332: -- Blank line.
1333: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, C_BLANK_LINE);
1334: -- Table header row
1335: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,
1336: rpad (l_org_col_header,
1337: l_org_col_width + C_COL_SPACING) ||
1338: rpad (l_sub_col_header,
1339: l_sub_col_width + C_COL_SPACING) ||

Line 1346: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,

1342: rpad (l_wt_col_header,
1343: l_wt_col_width + C_COL_SPACING));
1344:
1345: -- Table header underline
1346: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,
1347: rpad ('-', l_org_col_width, '-') ||
1348: rpad (' ', C_COL_SPACING) ||
1349: rpad ('-', l_sub_col_width, '-') ||
1350: rpad (' ', C_COL_SPACING) ||

Line 1362: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,

1358: END IF;
1359:
1360: -- Output every row.
1361: l_stmt_id := 130;
1362: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,
1363: rpad (substr (missing_wt_conv_rec.org, 1,
1364: l_org_col_width),
1365: l_org_col_width + C_COL_SPACING) ||
1366: rpad (substr (missing_wt_conv_rec.sub, 1,

Line 1381: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, C_BLANK_LINE);

1377:
1378: -- Footer for this section
1379: l_stmt_id := 140;
1380: IF (l_header_printed = TRUE) THEN
1381: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, C_BLANK_LINE);
1382: OPI_DBI_REP_UOM_PKG.err_msg_footer;
1383: END IF;
1384:
1385: END IF;

Line 1433: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,

1429: l_stmt_id := 0;
1430:
1431:
1432: -- print out the title
1433: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,
1434: FND_MESSAGE.get_string (
1435: 'OPI', 'OPI_DBI_ITEM_LOC_CONV_ERR_HDR'));
1436:
1437: -- Report the item level details.