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_MESSAGE

Line 235: l_org_col_header := FND_MESSAGE.get_string ('OPI', 'OPI_DBI_ORG_COL_HDR');

231: l_line_print := NULL;
232:
233: -- Column Headers
234: l_stmt_id := 20;
235: l_org_col_header := FND_MESSAGE.get_string ('OPI', 'OPI_DBI_ORG_COL_HDR');
236: l_org_col_header := substr (l_org_col_header, 1, l_org_col_width);
237:
238: l_item_col_header := FND_MESSAGE.get_string (
239: 'OPI', 'OPI_DBI_ITEM_COL_HDR');

Line 238: l_item_col_header := FND_MESSAGE.get_string (

234: l_stmt_id := 20;
235: l_org_col_header := FND_MESSAGE.get_string ('OPI', 'OPI_DBI_ORG_COL_HDR');
236: l_org_col_header := substr (l_org_col_header, 1, l_org_col_width);
237:
238: l_item_col_header := FND_MESSAGE.get_string (
239: 'OPI', 'OPI_DBI_ITEM_COL_HDR');
240: l_item_col_header := substr (l_item_col_header, 1, l_item_col_width);
241:
242: l_vol_col_header := FND_MESSAGE.get_string (

Line 242: l_vol_col_header := FND_MESSAGE.get_string (

238: l_item_col_header := FND_MESSAGE.get_string (
239: 'OPI', 'OPI_DBI_ITEM_COL_HDR');
240: l_item_col_header := substr (l_item_col_header, 1, l_item_col_width);
241:
242: l_vol_col_header := FND_MESSAGE.get_string (
243: 'OPI', 'OPI_DBI_VOL_SETUP_COL_HDR');
244: l_vol_col_header := substr (l_vol_col_header, 1, l_vol_col_width);
245:
246: l_wt_col_header := FND_MESSAGE.get_string (

Line 246: l_wt_col_header := FND_MESSAGE.get_string (

242: l_vol_col_header := FND_MESSAGE.get_string (
243: 'OPI', 'OPI_DBI_VOL_SETUP_COL_HDR');
244: l_vol_col_header := substr (l_vol_col_header, 1, l_vol_col_width);
245:
246: l_wt_col_header := FND_MESSAGE.get_string (
247: 'OPI', 'OPI_DBI_WT_SETUP_COL_HDR');
248: l_wt_col_header := substr (l_wt_col_header, 1, l_wt_col_width);
249:
250: --First count how many items are missing setups

Line 261: l_item_missing_header := FND_MESSAGE.get_string (

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:
265: -- Item setup missing fix message. Print it.

Line 268: l_item_missing_fix := FND_MESSAGE.get_string (

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:
272: -- If not too many rows, print out the details

Line 304: substr (FND_MESSAGE.get_string ('OPI', 'OPI_DBI_UNDEF_STR'),

300:
301: -- Markers for missing weight and volume
302: l_stmt_id := 70;
303: l_wt_missing_marker :=
304: substr (FND_MESSAGE.get_string ('OPI', 'OPI_DBI_UNDEF_STR'),
305: 1, l_wt_col_width);
306: l_wt_ok_marker :=
307: substr (FND_MESSAGE.get_string ('OPI', 'OPI_DBI_OK_STR'),
308: 1, l_vol_col_width);

Line 307: substr (FND_MESSAGE.get_string ('OPI', 'OPI_DBI_OK_STR'),

303: l_wt_missing_marker :=
304: substr (FND_MESSAGE.get_string ('OPI', 'OPI_DBI_UNDEF_STR'),
305: 1, l_wt_col_width);
306: l_wt_ok_marker :=
307: substr (FND_MESSAGE.get_string ('OPI', 'OPI_DBI_OK_STR'),
308: 1, l_vol_col_width);
309: l_vol_missing_marker :=
310: substr (FND_MESSAGE.get_string ('OPI', 'OPI_DBI_UNDEF_STR'),
311: 1, l_wt_col_width);

Line 310: substr (FND_MESSAGE.get_string ('OPI', 'OPI_DBI_UNDEF_STR'),

306: l_wt_ok_marker :=
307: substr (FND_MESSAGE.get_string ('OPI', 'OPI_DBI_OK_STR'),
308: 1, l_vol_col_width);
309: l_vol_missing_marker :=
310: substr (FND_MESSAGE.get_string ('OPI', 'OPI_DBI_UNDEF_STR'),
311: 1, l_wt_col_width);
312: l_vol_ok_marker :=
313: substr (FND_MESSAGE.get_string ('OPI', 'OPI_DBI_OK_STR'),
314: 1, l_vol_col_width);

Line 313: substr (FND_MESSAGE.get_string ('OPI', 'OPI_DBI_OK_STR'),

309: l_vol_missing_marker :=
310: substr (FND_MESSAGE.get_string ('OPI', 'OPI_DBI_UNDEF_STR'),
311: 1, l_wt_col_width);
312: l_vol_ok_marker :=
313: substr (FND_MESSAGE.get_string ('OPI', 'OPI_DBI_OK_STR'),
314: 1, l_vol_col_width);
315:
316: -- Report every missing setup.
317: l_stmt_id := 80;

Line 372: l_too_many_rows_msg := FND_MESSAGE.get_string (

368: CLOSE item_setup_missing_csr;
369:
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);

Line 553: l_sub_col_header := FND_MESSAGE.get_string ('OPI', 'OPI_DBI_SUB_COL_HDR');

549: -- Column Headers
550: l_stmt_id := 20;
551: l_org_col_header := substr ('Organization', 1, l_org_col_width);
552:
553: l_sub_col_header := FND_MESSAGE.get_string ('OPI', 'OPI_DBI_SUB_COL_HDR');
554: l_sub_col_header := substr (l_sub_col_header, 1, l_sub_col_width);
555:
556: l_loc_col_header := FND_MESSAGE.get_string (
557: 'OPI', 'OPI_DBI_LOCATOR_COL_HDR');

Line 556: l_loc_col_header := FND_MESSAGE.get_string (

552:
553: l_sub_col_header := FND_MESSAGE.get_string ('OPI', 'OPI_DBI_SUB_COL_HDR');
554: l_sub_col_header := substr (l_sub_col_header, 1, l_sub_col_width);
555:
556: l_loc_col_header := FND_MESSAGE.get_string (
557: 'OPI', 'OPI_DBI_LOCATOR_COL_HDR');
558: l_loc_col_header := substr (l_loc_col_header, 1, l_loc_col_width);
559:
560: l_vol_col_header := FND_MESSAGE.get_string (

Line 560: l_vol_col_header := FND_MESSAGE.get_string (

556: l_loc_col_header := FND_MESSAGE.get_string (
557: 'OPI', 'OPI_DBI_LOCATOR_COL_HDR');
558: l_loc_col_header := substr (l_loc_col_header, 1, l_loc_col_width);
559:
560: l_vol_col_header := FND_MESSAGE.get_string (
561: 'OPI', 'OPI_DBI_VOL_SETUP_COL_HDR');
562: l_vol_col_header := substr (l_vol_col_header, 1, l_vol_col_width);
563:
564: l_wt_col_header := FND_MESSAGE.get_string (

Line 564: l_wt_col_header := FND_MESSAGE.get_string (

560: l_vol_col_header := FND_MESSAGE.get_string (
561: 'OPI', 'OPI_DBI_VOL_SETUP_COL_HDR');
562: l_vol_col_header := substr (l_vol_col_header, 1, l_vol_col_width);
563:
564: l_wt_col_header := FND_MESSAGE.get_string (
565: 'OPI', 'OPI_DBI_WT_SETUP_COL_HDR');
566: l_wt_col_header := substr (l_wt_col_header, 1, l_wt_col_width);
567:
568: -- Check how many rows need to be fixed.

Line 580: l_loc_missing_header := FND_MESSAGE.get_string (

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);
583: -- Locator setup missing fix message. Print it.
584: l_stmt_id := 40;

Line 586: l_loc_missing_fix := FND_MESSAGE.get_string (

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:
590: -- Only print out details if not too long. Else print out SQL

Line 626: substr (FND_MESSAGE.get_string ('OPI', 'OPI_DBI_UNDEF_STR'),

622:
623: -- Markers for missing weight and volume
624: l_stmt_id := 70;
625: l_wt_missing_marker :=
626: substr (FND_MESSAGE.get_string ('OPI', 'OPI_DBI_UNDEF_STR'),
627: 1, l_wt_col_width);
628: l_wt_ok_marker :=
629: substr (FND_MESSAGE.get_string ('OPI', 'OPI_DBI_OK_STR'),
630: 1, l_vol_col_width);

Line 629: substr (FND_MESSAGE.get_string ('OPI', 'OPI_DBI_OK_STR'),

625: l_wt_missing_marker :=
626: substr (FND_MESSAGE.get_string ('OPI', 'OPI_DBI_UNDEF_STR'),
627: 1, l_wt_col_width);
628: l_wt_ok_marker :=
629: substr (FND_MESSAGE.get_string ('OPI', 'OPI_DBI_OK_STR'),
630: 1, l_vol_col_width);
631: l_vol_missing_marker :=
632: substr (FND_MESSAGE.get_string ('OPI', 'OPI_DBI_UNDEF_STR'),
633: 1, l_wt_col_width);

Line 632: substr (FND_MESSAGE.get_string ('OPI', 'OPI_DBI_UNDEF_STR'),

628: l_wt_ok_marker :=
629: substr (FND_MESSAGE.get_string ('OPI', 'OPI_DBI_OK_STR'),
630: 1, l_vol_col_width);
631: l_vol_missing_marker :=
632: substr (FND_MESSAGE.get_string ('OPI', 'OPI_DBI_UNDEF_STR'),
633: 1, l_wt_col_width);
634: l_vol_ok_marker :=
635: substr (FND_MESSAGE.get_string ('OPI', 'OPI_DBI_OK_STR'),
636: 1, l_vol_col_width);

Line 635: substr (FND_MESSAGE.get_string ('OPI', 'OPI_DBI_OK_STR'),

631: l_vol_missing_marker :=
632: substr (FND_MESSAGE.get_string ('OPI', 'OPI_DBI_UNDEF_STR'),
633: 1, l_wt_col_width);
634: l_vol_ok_marker :=
635: substr (FND_MESSAGE.get_string ('OPI', 'OPI_DBI_OK_STR'),
636: 1, l_vol_col_width);
637:
638: -- Report for every missing setup.
639: l_stmt_id := 80;

Line 696: l_too_many_rows_msg := FND_MESSAGE.get_string (

692:
693: CLOSE locator_setup_missing_csr;
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);

Line 850: l_item_col_header := FND_MESSAGE.get_string (

846: -- Column Headers
847: l_stmt_id := 20;
848: l_org_col_header := substr ('Organization', 1, l_org_col_width);
849:
850: l_item_col_header := FND_MESSAGE.get_string (
851: 'OPI', 'OPI_DBI_ITEM_COL_HDR');
852: l_item_col_header := substr (l_item_col_header, 1, l_item_col_width);
853:
854: l_vol_col_header := FND_MESSAGE.get_string (

Line 854: l_vol_col_header := FND_MESSAGE.get_string (

850: l_item_col_header := FND_MESSAGE.get_string (
851: 'OPI', 'OPI_DBI_ITEM_COL_HDR');
852: l_item_col_header := substr (l_item_col_header, 1, l_item_col_width);
853:
854: l_vol_col_header := FND_MESSAGE.get_string (
855: 'OPI', 'OPI_DBI_ITEM_VOL_UOM_COL_HDR');
856: l_vol_col_header := substr (l_vol_col_header, 1, l_vol_col_width);
857:
858: l_wt_col_header := FND_MESSAGE.get_string (

Line 858: l_wt_col_header := FND_MESSAGE.get_string (

854: l_vol_col_header := FND_MESSAGE.get_string (
855: 'OPI', 'OPI_DBI_ITEM_VOL_UOM_COL_HDR');
856: l_vol_col_header := substr (l_vol_col_header, 1, l_vol_col_width);
857:
858: l_wt_col_header := FND_MESSAGE.get_string (
859: 'OPI', 'OPI_DBI_ITEM_WT_UOM_COL_HDR');
860: l_wt_col_header := substr (l_wt_col_header, 1, l_wt_col_width);
861:
862: -- Get the volume UOM code

Line 893: FND_MESSAGE.get_string ('OPI',

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.
897: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, C_BLANK_LINE);

Line 901: FND_MESSAGE.get_string ('OPI', 'OPI_DBI_REP_UOM_VOL') ||

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:
905: -- Blank line.

Line 987: FND_MESSAGE.get_string ('OPI',

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.
991: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, C_BLANK_LINE);

Line 995: FND_MESSAGE.get_string ('OPI', 'OPI_DBI_REP_UOM_WT') ||

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.
999: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, C_BLANK_LINE);

Line 1168: l_sub_col_header := FND_MESSAGE.get_string ('OPI', 'OPI_DBI_SUB_COL_HDR');

1164: -- Column Headers
1165: l_stmt_id := 20;
1166: l_org_col_header := substr ('Organization', 1, l_org_col_width);
1167:
1168: l_sub_col_header := FND_MESSAGE.get_string ('OPI', 'OPI_DBI_SUB_COL_HDR');
1169: l_sub_col_header := substr (l_sub_col_header, 1, l_sub_col_width);
1170:
1171: l_loc_col_header := FND_MESSAGE.get_string (
1172: 'OPI', 'OPI_DBI_LOCATOR_COL_HDR');

Line 1171: l_loc_col_header := FND_MESSAGE.get_string (

1167:
1168: l_sub_col_header := FND_MESSAGE.get_string ('OPI', 'OPI_DBI_SUB_COL_HDR');
1169: l_sub_col_header := substr (l_sub_col_header, 1, l_sub_col_width);
1170:
1171: l_loc_col_header := FND_MESSAGE.get_string (
1172: 'OPI', 'OPI_DBI_LOCATOR_COL_HDR');
1173: l_loc_col_header := substr (l_loc_col_header, 1, l_loc_col_width);
1174:
1175: l_vol_col_header := FND_MESSAGE.get_string (

Line 1175: l_vol_col_header := FND_MESSAGE.get_string (

1171: l_loc_col_header := FND_MESSAGE.get_string (
1172: 'OPI', 'OPI_DBI_LOCATOR_COL_HDR');
1173: l_loc_col_header := substr (l_loc_col_header, 1, l_loc_col_width);
1174:
1175: l_vol_col_header := FND_MESSAGE.get_string (
1176: 'OPI', 'OPI_DBI_LOC_VOL_UOM_COL_HDR');
1177: l_vol_col_header := substr (l_vol_col_header, 1, l_vol_col_width);
1178:
1179: l_wt_col_header := FND_MESSAGE.get_string (

Line 1179: l_wt_col_header := FND_MESSAGE.get_string (

1175: l_vol_col_header := FND_MESSAGE.get_string (
1176: 'OPI', 'OPI_DBI_LOC_VOL_UOM_COL_HDR');
1177: l_vol_col_header := substr (l_vol_col_header, 1, l_vol_col_width);
1178:
1179: l_wt_col_header := FND_MESSAGE.get_string (
1180: 'OPI', 'OPI_DBI_LOC_WT_UOM_COL_HDR');
1181: l_wt_col_header := substr (l_wt_col_header, 1, l_wt_col_width);
1182:
1183: -- Get the volume UOM code

Line 1214: FND_MESSAGE.get_string ('OPI', 'OPI_DBI_REP_UOM_VOL') ||

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.
1218: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, C_BLANK_LINE);

Line 1222: FND_MESSAGE.get_string ('OPI',

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.
1226: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, C_BLANK_LINE);

Line 1230: FND_MESSAGE.get_string ('OPI', 'OPI_DBI_REP_UOM_VOL') ||

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.
1234: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, C_BLANK_LINE);

Line 1321: FND_MESSAGE.get_string ('OPI',

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.
1325: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, C_BLANK_LINE);

Line 1329: FND_MESSAGE.get_string ('OPI', 'OPI_DBI_REP_UOM_WT') ||

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.
1333: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, C_BLANK_LINE);

Line 1434: FND_MESSAGE.get_string (

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.
1438: -- Volume and weight should be reported in two different sections.