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.BOM_DIAGUNITTEST_TSDATA dependencies on JTF_DIAGNOSTIC_COREAPI

Line 54: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;

50:
51: BEGIN
52: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
53: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
54: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
55:
56: /*Initializing local vars */
57: row_limit :=1000; /* Set Row Limit to 1000 (i.e.) Max Number of records to be fetched by each sql*/
58: ln_rows_proc :=0;

Line 65: JTF_DIAGNOSTIC_COREAPI.errorprint('Input Item Id is mandatory.');

61: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrgId',inputs);
62: l_item_id :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('ItemId',inputs);
63:
64: If l_item_id is NULL then
65: JTF_DIAGNOSTIC_COREAPI.errorprint('Input Item Id is mandatory.');
66: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint(' Please provide a valid value for the Item Id.');
67: statusStr := 'FAILURE';
68: isFatal := 'TRUE';
69: fixInfo := ' Please review the error message below and take corrective action. ';

Line 66: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint(' Please provide a valid value for the Item Id.');

62: l_item_id :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('ItemId',inputs);
63:
64: If l_item_id is NULL then
65: JTF_DIAGNOSTIC_COREAPI.errorprint('Input Item Id is mandatory.');
66: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint(' Please provide a valid value for the Item Id.');
67: statusStr := 'FAILURE';
68: isFatal := 'TRUE';
69: fixInfo := ' Please review the error message below and take corrective action. ';
70: errStr := ' Invalid value for input field ItemId. It is a mandatory input.';

Line 78: JTF_DIAGNOSTIC_COREAPI.errorprint('Input Organization Id is mandatory.');

74: Return;
75: End If;
76:
77: If l_org_id is NULL then
78: JTF_DIAGNOSTIC_COREAPI.errorprint('Input Organization Id is mandatory.');
79: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint(' Please provide a valid value for the Organization Id.');
80: statusStr := 'FAILURE';
81: isFatal := 'TRUE';
82: fixInfo := ' Please review the error message below and take corrective action. ';

Line 79: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint(' Please provide a valid value for the Organization Id.');

75: End If;
76:
77: If l_org_id is NULL then
78: JTF_DIAGNOSTIC_COREAPI.errorprint('Input Organization Id is mandatory.');
79: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint(' Please provide a valid value for the Organization Id.');
80: statusStr := 'FAILURE';
81: isFatal := 'TRUE';
82: fixInfo := ' Please review the error message below and take corrective action. ';
83: errStr := ' Invalid value for input field Organization Id. It is a mandatory input.';

Line 96: JTF_DIAGNOSTIC_COREAPI.errorprint('Invalid Item and Organization Combination');

92: FETCH c_item_valid INTO l_count;
93: CLOSE c_item_valid;
94:
95: IF (l_count IS NULL) OR (l_count = 0) THEN
96: JTF_DIAGNOSTIC_COREAPI.errorprint('Invalid Item and Organization Combination');
97: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please enter right combination of Item and Organization ');
98: statusStr := 'FAILURE';
99: errStr := 'Invalid Item and Organization Combination';
100: fixInfo := ' Please review the error message below and take corrective action. ';

Line 97: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please enter right combination of Item and Organization ');

93: CLOSE c_item_valid;
94:
95: IF (l_count IS NULL) OR (l_count = 0) THEN
96: JTF_DIAGNOSTIC_COREAPI.errorprint('Invalid Item and Organization Combination');
97: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please enter right combination of Item and Organization ');
98: statusStr := 'FAILURE';
99: errStr := 'Invalid Item and Organization Combination';
100: fixInfo := ' Please review the error message below and take corrective action. ';
101: isFatal := 'TRUE';

Line 111: JTF_DIAGNOSTIC_COREAPI.Line_Out('

107:
108:
109: /* Start of Scripts to check for trailing spaces in Item Tables */
110:
111: JTF_DIAGNOSTIC_COREAPI.Line_Out('
112:
This script will report the records in Items,Bills,
113:
Routings related tables that contain trailing spaces
114:
in any of their column values.
115:

IMPACT:

Line 170: /JTF_DIAGNOSTIC_COREAPI.Line_Out(' l_oracle_schema: '||l_oracle_schema);/

166: , l_industry
167: , l_oracle_schema
168: );
169:
170: /*JTF_DIAGNOSTIC_COREAPI.Line_Out(' l_oracle_schema: '||l_oracle_schema);*/
171:
172: /* Script to verify records in mtl_system_items_b table */
173: Begin
174: delete from bom_diag_temp_tab; -- Clear the temporary tables

Line 176: --JTF_DIAGNOSTIC_COREAPI.Line_Out('Column: '||l_varchar_col_rec.column_name);

172: /* Script to verify records in mtl_system_items_b table */
173: Begin
174: delete from bom_diag_temp_tab; -- Clear the temporary tables
175: For l_varchar_col_rec in c_varchar_cols_cur('MTL_SYSTEM_ITEMS_B',l_oracle_schema) Loop
176: --JTF_DIAGNOSTIC_COREAPI.Line_Out('Column: '||l_varchar_col_rec.column_name);
177:
178: sql_stmt := '';
179: sql_stmt :=' Insert into bom_diag_temp_tab (Inventory_item_id, organization_id, '||
180: ' char_col1,char_col2) '||

Line 207: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Columns containing Trailing Spaces in mtl_system_items_b table ');

203:
204: sqltxt := sqltxt || ' and rownum< '||row_limit;
205: sqltxt :=sqltxt||' order by inventory_item_id, organization_id,char_col1';
206:
207: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Columns containing Trailing Spaces in mtl_system_items_b table ');
208: If (num_rows = row_limit -1 ) Then
209: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output of the above table is limited to the first '||(row_limit-1)||' rows to prevent an excessively big output file.
');
210: End If;
211: statusStr := 'SUCCESS';

Line 209: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output of the above table is limited to the first '||(row_limit-1)||' rows to prevent an excessively big output file.
');

205: sqltxt :=sqltxt||' order by inventory_item_id, organization_id,char_col1';
206:
207: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Columns containing Trailing Spaces in mtl_system_items_b table ');
208: If (num_rows = row_limit -1 ) Then
209: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output of the above table is limited to the first '||(row_limit-1)||' rows to prevent an excessively big output file.
');
210: End If;
211: statusStr := 'SUCCESS';
212: isFatal := 'FALSE';
213:

Line 221: --JTF_DIAGNOSTIC_COREAPI.Line_Out('Column: '||l_varchar_col_rec.column_name);

217: /* Script to verify records in mtl_system_items_tl table */
218: Begin
219: delete from bom_diag_temp_tab; -- Clear the temporary tables
220: For l_varchar_col_rec in c_varchar_cols_cur('MTL_SYSTEM_ITEMS_TL',l_oracle_schema) Loop
221: --JTF_DIAGNOSTIC_COREAPI.Line_Out('Column: '||l_varchar_col_rec.column_name);
222:
223: sql_stmt := '';
224:
225: /* If (upper(l_varchar_col_rec.column_name) NOT IN ('DESCRIPTION','LONG_DESCRIPTION')) Then

Line 226: -- JTF_DIAGNOSTIC_COREAPI.Line_Out('
not description, long description');

222:
223: sql_stmt := '';
224:
225: /* If (upper(l_varchar_col_rec.column_name) NOT IN ('DESCRIPTION','LONG_DESCRIPTION')) Then
226: -- JTF_DIAGNOSTIC_COREAPI.Line_Out('
not description, long description');
227: sql_stmt :=' Insert into bom_diag_temp_tab (Inventory_item_id, organization_id, '||
228: ' char_col3,char_col1,char_col2) '||
229: ' SELECT msitl.inventory_item_id '||
230: ' ,msitl.organization_id '||

Line 242: /JTF_DIAGNOSTIC_COREAPI.Line_Out('
description '); /

238: ' AND rownum < '||(row_limit/25);
239: */
240: If (upper(l_varchar_col_rec.column_name) IN ('DESCRIPTION','LONG_DESCRIPTION')) Then
241: If (upper(l_varchar_col_rec.column_name)='DESCRIPTION') Then
242: /*JTF_DIAGNOSTIC_COREAPI.Line_Out('
description '); */
243: sql_stmt :=' Insert into bom_diag_temp_tab (Inventory_item_id, organization_id, '||
244: ' char_col3,char_col1,description) '||
245: ' SELECT msitl.inventory_item_id '||
246: ' ,msitl.organization_id '||

Line 257: /JTF_DIAGNOSTIC_COREAPI.Line_Out('
long description');/

253: ' AND msitl.'||l_varchar_col_rec.column_name||' LIKE ''% '' '||
254: ' AND rownum < '||(row_limit/25);
255:
256: ElsIf (upper(l_varchar_col_rec.column_name)='LONG_DESCRIPTION') Then
257: /*JTF_DIAGNOSTIC_COREAPI.Line_Out('
long description');*/
258: sql_stmt :=' Insert into bom_diag_temp_tab (Inventory_item_id, organization_id, '||
259: ' char_col3,char_col1,Long_Description) '||
260: ' SELECT msitl.inventory_item_id '||
261: ' ,msitl.organization_id '||

Line 292: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Columns containing Trailing Spaces in mtl_system_items_tl table ');

288:
289: sqltxt := sqltxt || ' and rownum< '||row_limit;
290: sqltxt :=sqltxt||' order by inventory_item_id, organization_id,char_col3,char_col1';
291:
292: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Columns containing Trailing Spaces in mtl_system_items_tl table ');
293: If (num_rows = row_limit -1 ) Then
294: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output of the above table is limited to the first '||(row_limit-1)||' rows to prevent an excessively big output file.
');
295: End If;
296: statusStr := 'SUCCESS';

Line 294: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output of the above table is limited to the first '||(row_limit-1)||' rows to prevent an excessively big output file.
');

290: sqltxt :=sqltxt||' order by inventory_item_id, organization_id,char_col3,char_col1';
291:
292: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Columns containing Trailing Spaces in mtl_system_items_tl table ');
293: If (num_rows = row_limit -1 ) Then
294: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output of the above table is limited to the first '||(row_limit-1)||' rows to prevent an excessively big output file.
');
295: End If;
296: statusStr := 'SUCCESS';
297: isFatal := 'FALSE';
298:

Line 306: --JTF_DIAGNOSTIC_COREAPI.Line_Out('Column: '||l_varchar_col_rec.column_name);

302: /* Script to verify records in mtl_item_revisions_b table */
303: Begin
304: delete from bom_diag_temp_tab; -- Clear the temporary tables
305: For l_varchar_col_rec in c_varchar_cols_cur('MTL_ITEM_REVISIONS_B',l_oracle_schema) Loop
306: --JTF_DIAGNOSTIC_COREAPI.Line_Out('Column: '||l_varchar_col_rec.column_name);
307:
308: sql_stmt := '';
309: sql_stmt :=' Insert into bom_diag_temp_tab (Inventory_item_id, organization_id, '||
310: ' char_col3,num_col1,char_col1,char_col2) '||

Line 341: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Columns containing Trailing Spaces in mtl_item_revisions_b table ');

337:
338: sqltxt := sqltxt || ' and rownum< '||row_limit;
339: sqltxt :=sqltxt||' order by inventory_item_id, organization_id, char_col3,char_col1';
340:
341: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Columns containing Trailing Spaces in mtl_item_revisions_b table ');
342: If (num_rows = row_limit -1 ) Then
343: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output of the above table is limited to the first '||(row_limit-1)||' rows to prevent an excessively big output file.
');
344: End If;
345: statusStr := 'SUCCESS';

Line 343: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output of the above table is limited to the first '||(row_limit-1)||' rows to prevent an excessively big output file.
');

339: sqltxt :=sqltxt||' order by inventory_item_id, organization_id, char_col3,char_col1';
340:
341: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Columns containing Trailing Spaces in mtl_item_revisions_b table ');
342: If (num_rows = row_limit -1 ) Then
343: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output of the above table is limited to the first '||(row_limit-1)||' rows to prevent an excessively big output file.
');
344: End If;
345: statusStr := 'SUCCESS';
346: isFatal := 'FALSE';
347:

Line 355: --JTF_DIAGNOSTIC_COREAPI.Line_Out('Column: '||l_varchar_col_rec.column_name);

351: /* Script to verify records in mtl_item_revisions_tl table */
352: Begin
353: delete from bom_diag_temp_tab; -- Clear the temporary tables
354: For l_varchar_col_rec in c_varchar_cols_cur('MTL_ITEM_REVISIONS_TL',l_oracle_schema) Loop
355: --JTF_DIAGNOSTIC_COREAPI.Line_Out('Column: '||l_varchar_col_rec.column_name);
356:
357: sql_stmt := '';
358: sql_stmt :=' Insert into bom_diag_temp_tab (Inventory_item_id, organization_id, '||
359: ' num_col1,char_col3,char_col1,char_col2) '||

Line 390: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Columns containing Trailing Spaces in mtl_item_revisions_tl table ');

386:
387: sqltxt := sqltxt || ' and rownum< '||row_limit;
388: sqltxt :=sqltxt||' order by inventory_item_id, organization_id, num_col1,char_col3,char_col1';
389:
390: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Columns containing Trailing Spaces in mtl_item_revisions_tl table ');
391: If (num_rows = row_limit -1 ) Then
392: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output of the above table is limited to the first '||(row_limit-1)||' rows to prevent an excessively big output file.
');
393: End If;
394: statusStr := 'SUCCESS';

Line 392: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output of the above table is limited to the first '||(row_limit-1)||' rows to prevent an excessively big output file.
');

388: sqltxt :=sqltxt||' order by inventory_item_id, organization_id, num_col1,char_col3,char_col1';
389:
390: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Columns containing Trailing Spaces in mtl_item_revisions_tl table ');
391: If (num_rows = row_limit -1 ) Then
392: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output of the above table is limited to the first '||(row_limit-1)||' rows to prevent an excessively big output file.
');
393: End If;
394: statusStr := 'SUCCESS';
395: isFatal := 'FALSE';
396:

Line 404: --JTF_DIAGNOSTIC_COREAPI.Line_Out('Column: '||l_varchar_col_rec.column_name);

400: /* Script to verify records in mtl_descr_element_values table */
401: Begin
402: delete from bom_diag_temp_tab; -- Clear the temporary tables
403: For l_varchar_col_rec in c_varchar_cols_cur('MTL_DESCR_ELEMENT_VALUES',l_oracle_schema) Loop
404: --JTF_DIAGNOSTIC_COREAPI.Line_Out('Column: '||l_varchar_col_rec.column_name);
405:
406: sql_stmt := '';
407: sql_stmt :=' Insert into bom_diag_temp_tab (Inventory_item_id, '||
408: ' char_col3,num_col1,char_col1,char_col2) '||

Line 436: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Columns containing Trailing Spaces in mtl_descr_element_values table ');

432:
433: sqltxt := sqltxt || ' and rownum< '||row_limit;
434: sqltxt :=sqltxt||' order by inventory_item_id, organization_id, char_col3,char_col1';
435:
436: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Columns containing Trailing Spaces in mtl_descr_element_values table ');
437: If (num_rows = row_limit -1 ) Then
438: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output of the above table is limited to the first '||(row_limit-1)||' rows to prevent an excessively big output file.
');
439: End If;
440: statusStr := 'SUCCESS';

Line 438: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output of the above table is limited to the first '||(row_limit-1)||' rows to prevent an excessively big output file.
');

434: sqltxt :=sqltxt||' order by inventory_item_id, organization_id, char_col3,char_col1';
435:
436: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Columns containing Trailing Spaces in mtl_descr_element_values table ');
437: If (num_rows = row_limit -1 ) Then
438: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output of the above table is limited to the first '||(row_limit-1)||' rows to prevent an excessively big output file.
');
439: End If;
440: statusStr := 'SUCCESS';
441: isFatal := 'FALSE';
442: End;

Line 449: --JTF_DIAGNOSTIC_COREAPI.Line_Out('Column: '||l_varchar_col_rec.column_name);

445: /* Script to verify records in mtl_pending_item_status table */
446: Begin
447: delete from bom_diag_temp_tab; -- Clear the temporary tables
448: For l_varchar_col_rec in c_varchar_cols_cur('MTL_PENDING_ITEM_STATUS',l_oracle_schema) Loop
449: --JTF_DIAGNOSTIC_COREAPI.Line_Out('Column: '||l_varchar_col_rec.column_name);
450:
451: sql_stmt := '';
452: sql_stmt :=' Insert into bom_diag_temp_tab (Inventory_item_id,Organization_id, '||
453: ' char_col3,Date_col1,char_col1,char_col2) '||

Line 484: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Columns containing Trailing Spaces in mtl_pending_item_status table ');

480:
481: sqltxt := sqltxt || ' and rownum< '||row_limit;
482: sqltxt :=sqltxt||' order by inventory_item_id, organization_id, char_col3,Date_col1,char_col1';
483:
484: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Columns containing Trailing Spaces in mtl_pending_item_status table ');
485: If (num_rows = row_limit -1 ) Then
486: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output of the above table is limited to the first '||(row_limit-1)||' rows to prevent an excessively big output file.
');
487: End If;
488: statusStr := 'SUCCESS';

Line 486: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output of the above table is limited to the first '||(row_limit-1)||' rows to prevent an excessively big output file.
');

482: sqltxt :=sqltxt||' order by inventory_item_id, organization_id, char_col3,Date_col1,char_col1';
483:
484: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Columns containing Trailing Spaces in mtl_pending_item_status table ');
485: If (num_rows = row_limit -1 ) Then
486: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output of the above table is limited to the first '||(row_limit-1)||' rows to prevent an excessively big output file.
');
487: End If;
488: statusStr := 'SUCCESS';
489: isFatal := 'FALSE';
490: End;

Line 498: --JTF_DIAGNOSTIC_COREAPI.Line_Out('Column: '||l_varchar_col_rec.column_name);

494: /* Script to verify records in mtl_cross_references_b table */
495: Begin
496: delete from bom_diag_temp_tab; -- Clear the temporary tables
497: For l_varchar_col_rec in c_varchar_cols_cur('MTL_CROSS_REFERENCES_B',l_oracle_schema) Loop
498: --JTF_DIAGNOSTIC_COREAPI.Line_Out('Column: '||l_varchar_col_rec.column_name);
499:
500: sql_stmt := '';
501: sql_stmt :=' Insert into bom_diag_temp_tab (Inventory_item_id,Organization_id, '||
502: ' char_col3,char_col4,char_col1,char_col2) '||

Line 534: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Columns containing Trailing Spaces in mtl_cross_references_b table ');

530:
531: sqltxt := sqltxt || ' and rownum< '||row_limit;
532: sqltxt :=sqltxt||' order by inventory_item_id, organization_id, char_col3,char_col4,char_col1';
533:
534: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Columns containing Trailing Spaces in mtl_cross_references_b table ');
535: If (num_rows = row_limit -1 ) Then
536: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output of the above table is limited to the first '||(row_limit-1)||' rows to prevent an excessively big output file.
');
537: End If;
538: statusStr := 'SUCCESS';

Line 536: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output of the above table is limited to the first '||(row_limit-1)||' rows to prevent an excessively big output file.
');

532: sqltxt :=sqltxt||' order by inventory_item_id, organization_id, char_col3,char_col4,char_col1';
533:
534: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Columns containing Trailing Spaces in mtl_cross_references_b table ');
535: If (num_rows = row_limit -1 ) Then
536: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output of the above table is limited to the first '||(row_limit-1)||' rows to prevent an excessively big output file.
');
537: End If;
538: statusStr := 'SUCCESS';
539: isFatal := 'FALSE';
540: End;

Line 547: --JTF_DIAGNOSTIC_COREAPI.Line_Out('Column: '||l_varchar_col_rec.column_name);

543: /* Script to verify records in mtl_cross_references_tl table */
544: Begin
545: delete from bom_diag_temp_tab; -- Clear the temporary tables
546: For l_varchar_col_rec in c_varchar_cols_cur('MTL_CROSS_REFERENCES_TL',l_oracle_schema) Loop
547: --JTF_DIAGNOSTIC_COREAPI.Line_Out('Column: '||l_varchar_col_rec.column_name);
548:
549: sql_stmt := '';
550: sql_stmt :=' Insert into bom_diag_temp_tab (num_col1, '||
551: ' char_col4,char_col1,char_col2) '||

Line 580: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Columns containing Trailing Spaces in mtl_cross_references_tl table ');

576:
577: sqltxt := sqltxt || ' and rownum< '||row_limit;
578: sqltxt :=sqltxt||' order by num_col1,char_col4,char_col1';
579:
580: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Columns containing Trailing Spaces in mtl_cross_references_tl table ');
581: If (num_rows = row_limit -1 ) Then
582: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output of the above table is limited to the first '||(row_limit-1)||' rows to prevent an excessively big output file.
');
583: End If;
584: statusStr := 'SUCCESS';

Line 582: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output of the above table is limited to the first '||(row_limit-1)||' rows to prevent an excessively big output file.
');

578: sqltxt :=sqltxt||' order by num_col1,char_col4,char_col1';
579:
580: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Columns containing Trailing Spaces in mtl_cross_references_tl table ');
581: If (num_rows = row_limit -1 ) Then
582: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output of the above table is limited to the first '||(row_limit-1)||' rows to prevent an excessively big output file.
');
583: End If;
584: statusStr := 'SUCCESS';
585: isFatal := 'FALSE';
586: End;

Line 593: --JTF_DIAGNOSTIC_COREAPI.Line_Out('Column: '||l_varchar_col_rec.column_name);

589: /* Script to verify records in mtl_customer_item_xrefs table */
590: Begin
591: delete from bom_diag_temp_tab; -- Clear the temporary tables
592: For l_varchar_col_rec in c_varchar_cols_cur('MTL_CUSTOMER_ITEM_XREFS',l_oracle_schema) Loop
593: --JTF_DIAGNOSTIC_COREAPI.Line_Out('Column: '||l_varchar_col_rec.column_name);
594:
595: sql_stmt := '';
596: sql_stmt :=' Insert into bom_diag_temp_tab (Inventory_item_id,Organization_id, '||
597: ' Num_col1,char_col1,char_col2) '||

Line 628: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Columns containing Trailing Spaces in mtl_customer_item_xrefs table ');

624:
625: sqltxt := sqltxt || ' and rownum< '||row_limit;
626: sqltxt :=sqltxt||' order by inventory_item_id, organization_id, Num_col1,char_col1';
627:
628: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Columns containing Trailing Spaces in mtl_customer_item_xrefs table ');
629: If (num_rows = row_limit -1 ) Then
630: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output of the above table is limited to the first '||(row_limit-1)||' rows to prevent an excessively big output file.
');
631: End If;
632: statusStr := 'SUCCESS';

Line 630: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output of the above table is limited to the first '||(row_limit-1)||' rows to prevent an excessively big output file.
');

626: sqltxt :=sqltxt||' order by inventory_item_id, organization_id, Num_col1,char_col1';
627:
628: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Columns containing Trailing Spaces in mtl_customer_item_xrefs table ');
629: If (num_rows = row_limit -1 ) Then
630: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output of the above table is limited to the first '||(row_limit-1)||' rows to prevent an excessively big output file.
');
631: End If;
632: statusStr := 'SUCCESS';
633: isFatal := 'FALSE';
634: End;

Line 641: --JTF_DIAGNOSTIC_COREAPI.Line_Out('Column: '||l_varchar_col_rec.column_name);

637: /* Script to verify records in mtl_mfg_part_numbers table */
638: Begin
639: delete from bom_diag_temp_tab; -- Clear the temporary tables
640: For l_varchar_col_rec in c_varchar_cols_cur('MTL_MFG_PART_NUMBERS',l_oracle_schema) Loop
641: --JTF_DIAGNOSTIC_COREAPI.Line_Out('Column: '||l_varchar_col_rec.column_name);
642:
643: sql_stmt := '';
644: sql_stmt :=' Insert into bom_diag_temp_tab (Inventory_item_id,Organization_id, '||
645: ' Num_col1,char_col3,char_col1,char_col2) '||

Line 678: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Columns containing Trailing Spaces in mtl_mfg_part_numbers table ');

674:
675: sqltxt := sqltxt || ' and rownum< '||row_limit;
676: sqltxt :=sqltxt||' order by inventory_item_id, organization_id, Num_col1,char_col3,char_col1';
677:
678: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Columns containing Trailing Spaces in mtl_mfg_part_numbers table ');
679: If (num_rows = row_limit -1 ) Then
680: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output of the above table is limited to the first '||(row_limit-1)||' rows to prevent an excessively big output file.
');
681: End If;
682: statusStr := 'SUCCESS';

Line 680: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output of the above table is limited to the first '||(row_limit-1)||' rows to prevent an excessively big output file.
');

676: sqltxt :=sqltxt||' order by inventory_item_id, organization_id, Num_col1,char_col3,char_col1';
677:
678: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Columns containing Trailing Spaces in mtl_mfg_part_numbers table ');
679: If (num_rows = row_limit -1 ) Then
680: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output of the above table is limited to the first '||(row_limit-1)||' rows to prevent an excessively big output file.
');
681: End If;
682: statusStr := 'SUCCESS';
683: isFatal := 'FALSE';
684: End;

Line 691: --JTF_DIAGNOSTIC_COREAPI.Line_Out('Column: '||l_varchar_col_rec.column_name);

687: /* Script to verify records in mtl_rtg_item_revisions table */
688: Begin
689: delete from bom_diag_temp_tab; -- Clear the temporary tables
690: For l_varchar_col_rec in c_varchar_cols_cur('MTL_RTG_ITEM_REVISIONS',l_oracle_schema) Loop
691: --JTF_DIAGNOSTIC_COREAPI.Line_Out('Column: '||l_varchar_col_rec.column_name);
692:
693: sql_stmt := '';
694: sql_stmt :=' Insert into bom_diag_temp_tab (Inventory_item_id, organization_id, '||
695: ' char_col3,char_col1,char_col2) '||

Line 724: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Columns containing Trailing Spaces in mtl_rtg_item_revisions table ');

720:
721: sqltxt := sqltxt || ' and rownum< '||row_limit;
722: sqltxt :=sqltxt||' order by inventory_item_id, organization_id, char_col3,char_col1';
723:
724: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Columns containing Trailing Spaces in mtl_rtg_item_revisions table ');
725: If (num_rows = row_limit -1 ) Then
726: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output of the above table is limited to the first '||(row_limit-1)||' rows to prevent an excessively big output file.
');
727: End If;
728: statusStr := 'SUCCESS';

Line 726: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output of the above table is limited to the first '||(row_limit-1)||' rows to prevent an excessively big output file.
');

722: sqltxt :=sqltxt||' order by inventory_item_id, organization_id, char_col3,char_col1';
723:
724: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Columns containing Trailing Spaces in mtl_rtg_item_revisions table ');
725: If (num_rows = row_limit -1 ) Then
726: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output of the above table is limited to the first '||(row_limit-1)||' rows to prevent an excessively big output file.
');
727: End If;
728: statusStr := 'SUCCESS';
729: isFatal := 'FALSE';
730:

Line 738: --JTF_DIAGNOSTIC_COREAPI.Line_Out('Column: '||l_varchar_col_rec.column_name);

734: /* Script to verify records in mtl_related_items table */
735: Begin
736: delete from bom_diag_temp_tab; -- Clear the temporary tables
737: For l_varchar_col_rec in c_varchar_cols_cur('MTL_RELATED_ITEMS',l_oracle_schema) Loop
738: --JTF_DIAGNOSTIC_COREAPI.Line_Out('Column: '||l_varchar_col_rec.column_name);
739:
740: sql_stmt := '';
741: sql_stmt :=' Insert into bom_diag_temp_tab (Inventory_item_id,Organization_id, '||
742: ' Num_col1,Num_col2,char_col1,char_col2) '||

Line 775: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Columns containing Trailing Spaces in mtl_related_items table ');

771:
772: sqltxt := sqltxt || ' and rownum< '||row_limit;
773: sqltxt :=sqltxt||' order by inventory_item_id, organization_id, Num_col1,Num_col2,char_col1';
774:
775: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Columns containing Trailing Spaces in mtl_related_items table ');
776: If (num_rows = row_limit -1 ) Then
777: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output of the above table is limited to the first '||(row_limit-1)||' rows to prevent an excessively big output file.
');
778: End If;
779: statusStr := 'SUCCESS';

Line 777: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output of the above table is limited to the first '||(row_limit-1)||' rows to prevent an excessively big output file.
');

773: sqltxt :=sqltxt||' order by inventory_item_id, organization_id, Num_col1,Num_col2,char_col1';
774:
775: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Columns containing Trailing Spaces in mtl_related_items table ');
776: If (num_rows = row_limit -1 ) Then
777: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output of the above table is limited to the first '||(row_limit-1)||' rows to prevent an excessively big output file.
');
778: End If;
779: statusStr := 'SUCCESS';
780: isFatal := 'FALSE';
781: End;

Line 799: /JTF_DIAGNOSTIC_COREAPI.Line_Out(' l_oracle_schema: '||l_oracle_schema);/

795: , l_industry
796: , l_oracle_schema
797: );
798:
799: /*JTF_DIAGNOSTIC_COREAPI.Line_Out(' l_oracle_schema: '||l_oracle_schema);*/
800:
801: /* Script to verify records in BOM_STRUCTURES_B table */
802: Begin
803: delete from bom_diag_temp_tab; -- Clear the temporary tables

Line 805: --JTF_DIAGNOSTIC_COREAPI.Line_Out('Column: '||l_varchar_col_rec.column_name);

801: /* Script to verify records in BOM_STRUCTURES_B table */
802: Begin
803: delete from bom_diag_temp_tab; -- Clear the temporary tables
804: For l_varchar_col_rec in c_varchar_cols_cur('BOM_STRUCTURES_B',l_oracle_schema) Loop
805: --JTF_DIAGNOSTIC_COREAPI.Line_Out('Column: '||l_varchar_col_rec.column_name);
806:
807: sql_stmt := '';
808: sql_stmt :=' Insert into bom_diag_temp_tab (Inventory_item_id,Organization_id, '||
809: ' char_col3,Num_col1,char_col1,char_col2) '||

Line 840: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Columns containing Trailing Spaces in bom_structures_b table ');

836:
837: sqltxt := sqltxt || ' and rownum< '||row_limit;
838: sqltxt :=sqltxt||' order by inventory_item_id, organization_id, char_col3,Num_col1,char_col1';
839:
840: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Columns containing Trailing Spaces in bom_structures_b table ');
841: If (num_rows = row_limit -1 ) Then
842: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output of the above table is limited to the first '||(row_limit-1)||' rows to prevent an excessively big output file.
');
843: End If;
844: statusStr := 'SUCCESS';

Line 842: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output of the above table is limited to the first '||(row_limit-1)||' rows to prevent an excessively big output file.
');

838: sqltxt :=sqltxt||' order by inventory_item_id, organization_id, char_col3,Num_col1,char_col1';
839:
840: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Columns containing Trailing Spaces in bom_structures_b table ');
841: If (num_rows = row_limit -1 ) Then
842: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output of the above table is limited to the first '||(row_limit-1)||' rows to prevent an excessively big output file.
');
843: End If;
844: statusStr := 'SUCCESS';
845: isFatal := 'FALSE';
846: End;

Line 853: --JTF_DIAGNOSTIC_COREAPI.Line_Out('Column: '||l_varchar_col_rec.column_name);

849: /* Script to verify records in BOM_COMPONENTS_B table */
850: Begin
851: delete from bom_diag_temp_tab; -- Clear the temporary tables
852: For l_varchar_col_rec in c_varchar_cols_cur('BOM_COMPONENTS_B',l_oracle_schema) Loop
853: --JTF_DIAGNOSTIC_COREAPI.Line_Out('Column: '||l_varchar_col_rec.column_name);
854:
855: sql_stmt := '';
856: sql_stmt :=' Insert into bom_diag_temp_tab (Inventory_item_id,Organization_id, '||
857: ' char_col3,Num_col1,Num_col2,Num_col3,num_col4,char_col1,char_col2)'||

Line 896: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Columns containing Trailing Spaces in bom_components_b table ');

892:
893: sqltxt := sqltxt || ' and rownum< '||row_limit;
894: sqltxt :=sqltxt||' order by inventory_item_id, organization_id, char_col3,Num_col1,Num_col2,Num_col3,char_col1';
895:
896: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Columns containing Trailing Spaces in bom_components_b table ');
897: If (num_rows = row_limit -1 ) Then
898: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output of the above table is limited to the first '||(row_limit-1)||' rows to prevent an excessively big output file.
');
899: End If;
900: statusStr := 'SUCCESS';

Line 898: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output of the above table is limited to the first '||(row_limit-1)||' rows to prevent an excessively big output file.
');

894: sqltxt :=sqltxt||' order by inventory_item_id, organization_id, char_col3,Num_col1,Num_col2,Num_col3,char_col1';
895:
896: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Columns containing Trailing Spaces in bom_components_b table ');
897: If (num_rows = row_limit -1 ) Then
898: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output of the above table is limited to the first '||(row_limit-1)||' rows to prevent an excessively big output file.
');
899: End If;
900: statusStr := 'SUCCESS';
901: isFatal := 'FALSE';
902: End;

Line 909: --JTF_DIAGNOSTIC_COREAPI.Line_Out('Column: '||l_varchar_col_rec.column_name);

905: /* Script to verify records in bom_reference_designators table */
906: Begin
907: delete from bom_diag_temp_tab; -- Clear the temporary tables
908: For l_varchar_col_rec in c_varchar_cols_cur('BOM_REFERENCE_DESIGNATORS',l_oracle_schema) Loop
909: --JTF_DIAGNOSTIC_COREAPI.Line_Out('Column: '||l_varchar_col_rec.column_name);
910:
911: sql_stmt := '';
912: sql_stmt :=' Insert into bom_diag_temp_tab (Inventory_item_id,Organization_id, '||
913: ' char_col3,Num_col1,Num_col2,char_col4,char_col1,char_col2) '||

Line 951: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Columns containing Trailing Spaces in bom_reference_designators table ');

947:
948: sqltxt := sqltxt || ' and rownum< '||row_limit;
949: sqltxt :=sqltxt||' order by inventory_item_id, organization_id, char_col3,Num_col1,Num_col2,char_col1';
950:
951: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Columns containing Trailing Spaces in bom_reference_designators table ');
952: If (num_rows = row_limit -1 ) Then
953: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output of the above table is limited to the first '||(row_limit-1)||' rows to prevent an excessively big output file.
');
954: End If;
955: statusStr := 'SUCCESS';

Line 953: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output of the above table is limited to the first '||(row_limit-1)||' rows to prevent an excessively big output file.
');

949: sqltxt :=sqltxt||' order by inventory_item_id, organization_id, char_col3,Num_col1,Num_col2,char_col1';
950:
951: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Columns containing Trailing Spaces in bom_reference_designators table ');
952: If (num_rows = row_limit -1 ) Then
953: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output of the above table is limited to the first '||(row_limit-1)||' rows to prevent an excessively big output file.
');
954: End If;
955: statusStr := 'SUCCESS';
956: isFatal := 'FALSE';
957: End;

Line 964: --JTF_DIAGNOSTIC_COREAPI.Line_Out('Column: '||l_varchar_col_rec.column_name);

960: /* Script to verify records in bom_substitute_components table */
961: Begin
962: delete from bom_diag_temp_tab; -- Clear the temporary tables
963: For l_varchar_col_rec in c_varchar_cols_cur('BOM_SUBSTITUTE_COMPONENTS',l_oracle_schema) Loop
964: --JTF_DIAGNOSTIC_COREAPI.Line_Out('Column: '||l_varchar_col_rec.column_name);
965:
966: sql_stmt := '';
967: sql_stmt :=' Insert into bom_diag_temp_tab (Inventory_item_id,Organization_id, '||
968: ' char_col3,Num_col1,Num_col2,Num_col3,char_col1,char_col2) '||

Line 1006: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Columns containing Trailing Spaces in bom_substitute_components table ');

1002:
1003: sqltxt := sqltxt || ' and rownum< '||row_limit;
1004: sqltxt :=sqltxt||' order by inventory_item_id, organization_id, char_col3,Num_col1,Num_col2,char_col1';
1005:
1006: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Columns containing Trailing Spaces in bom_substitute_components table ');
1007: If (num_rows = row_limit -1 ) Then
1008: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output of the above table is limited to the first '||(row_limit-1)||' rows to prevent an excessively big output file.
');
1009: End If;
1010: statusStr := 'SUCCESS';

Line 1008: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output of the above table is limited to the first '||(row_limit-1)||' rows to prevent an excessively big output file.
');

1004: sqltxt :=sqltxt||' order by inventory_item_id, organization_id, char_col3,Num_col1,Num_col2,char_col1';
1005:
1006: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Columns containing Trailing Spaces in bom_substitute_components table ');
1007: If (num_rows = row_limit -1 ) Then
1008: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output of the above table is limited to the first '||(row_limit-1)||' rows to prevent an excessively big output file.
');
1009: End If;
1010: statusStr := 'SUCCESS';
1011: isFatal := 'FALSE';
1012: End;

Line 1023: --JTF_DIAGNOSTIC_COREAPI.Line_Out('Column: '||l_varchar_col_rec.column_name);

1019: /* Script to verify records in bom_operational_routings table */
1020: Begin
1021: delete from bom_diag_temp_tab; -- Clear the temporary tables
1022: For l_varchar_col_rec in c_varchar_cols_cur('BOM_OPERATIONAL_ROUTINGS',l_oracle_schema) Loop
1023: --JTF_DIAGNOSTIC_COREAPI.Line_Out('Column: '||l_varchar_col_rec.column_name);
1024:
1025: sql_stmt := '';
1026: sql_stmt :=' Insert into bom_diag_temp_tab (Inventory_item_id,Organization_id, '||
1027: ' char_col3,Num_col1,char_col1,char_col2) '||

Line 1059: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Columns containing Trailing Spaces in bom_operational_routings table ');

1055:
1056: sqltxt := sqltxt || ' and rownum< '||row_limit;
1057: sqltxt :=sqltxt||' order by inventory_item_id, organization_id, char_col3,char_col1';
1058:
1059: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Columns containing Trailing Spaces in bom_operational_routings table ');
1060: If (num_rows = row_limit -1 ) Then
1061: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output of the above table is limited to the first '||(row_limit-1)||' rows to prevent an excessively big output file.
');
1062: End If;
1063: statusStr := 'SUCCESS';

Line 1061: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output of the above table is limited to the first '||(row_limit-1)||' rows to prevent an excessively big output file.
');

1057: sqltxt :=sqltxt||' order by inventory_item_id, organization_id, char_col3,char_col1';
1058:
1059: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Columns containing Trailing Spaces in bom_operational_routings table ');
1060: If (num_rows = row_limit -1 ) Then
1061: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output of the above table is limited to the first '||(row_limit-1)||' rows to prevent an excessively big output file.
');
1062: End If;
1063: statusStr := 'SUCCESS';
1064: isFatal := 'FALSE';
1065: End;

Line 1072: --JTF_DIAGNOSTIC_COREAPI.Line_Out('Column: '||l_varchar_col_rec.column_name);

1068: /* Script to verify records in bom_operation_sequences table */
1069: Begin
1070: delete from bom_diag_temp_tab; -- Clear the temporary tables
1071: For l_varchar_col_rec in c_varchar_cols_cur('BOM_OPERATION_SEQUENCES',l_oracle_schema) Loop
1072: --JTF_DIAGNOSTIC_COREAPI.Line_Out('Column: '||l_varchar_col_rec.column_name);
1073:
1074: sql_stmt := '';
1075: sql_stmt :=' Insert into bom_diag_temp_tab (Inventory_item_id,Organization_id, '||
1076: ' char_col3,Num_col1,Num_col2,char_col1,char_col2) '||

Line 1111: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Columns containing Trailing Spaces in bom_operation_sequences table ');

1107:
1108: sqltxt := sqltxt || ' and rownum< '||row_limit;
1109: sqltxt :=sqltxt||' order by inventory_item_id, organization_id, char_col3,char_col1';
1110:
1111: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Columns containing Trailing Spaces in bom_operation_sequences table ');
1112: If (num_rows = row_limit -1 ) Then
1113: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output of the above table is limited to the first '||(row_limit-1)||' rows to prevent an excessively big output file.
');
1114: End If;
1115: statusStr := 'SUCCESS';

Line 1113: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output of the above table is limited to the first '||(row_limit-1)||' rows to prevent an excessively big output file.
');

1109: sqltxt :=sqltxt||' order by inventory_item_id, organization_id, char_col3,char_col1';
1110:
1111: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Columns containing Trailing Spaces in bom_operation_sequences table ');
1112: If (num_rows = row_limit -1 ) Then
1113: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output of the above table is limited to the first '||(row_limit-1)||' rows to prevent an excessively big output file.
');
1114: End If;
1115: statusStr := 'SUCCESS';
1116: isFatal := 'FALSE';
1117: End;

Line 1124: --JTF_DIAGNOSTIC_COREAPI.Line_Out('Column: '||l_varchar_col_rec.column_name);

1120: /* Script to verify records in bom_operation_resources table */
1121: Begin
1122: delete from bom_diag_temp_tab; -- Clear the temporary tables
1123: For l_varchar_col_rec in c_varchar_cols_cur('BOM_OPERATION_RESOURCES',l_oracle_schema) Loop
1124: --JTF_DIAGNOSTIC_COREAPI.Line_Out('Column: '||l_varchar_col_rec.column_name);
1125:
1126: sql_stmt := '';
1127: sql_stmt :=' Insert into bom_diag_temp_tab (Inventory_item_id,Organization_id, '||
1128: ' char_col3,Num_col1,Num_col2,Num_col3,Num_col4,char_col1,char_col2)'||

Line 1169: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Columns containing Trailing Spaces in bom_operation_resources table ');

1165:
1166: sqltxt := sqltxt || ' and rownum< '||row_limit;
1167: sqltxt :=sqltxt||' order by inventory_item_id, organization_id, char_col3,Num_col2,Num_col3,char_col1';
1168:
1169: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Columns containing Trailing Spaces in bom_operation_resources table ');
1170: If (num_rows = row_limit -1 ) Then
1171: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output of the above table is limited to the first '||(row_limit-1)||' rows to prevent an excessively big output file.
');
1172: End If;
1173: statusStr := 'SUCCESS';

Line 1171: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output of the above table is limited to the first '||(row_limit-1)||' rows to prevent an excessively big output file.
');

1167: sqltxt :=sqltxt||' order by inventory_item_id, organization_id, char_col3,Num_col2,Num_col3,char_col1';
1168:
1169: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Columns containing Trailing Spaces in bom_operation_resources table ');
1170: If (num_rows = row_limit -1 ) Then
1171: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output of the above table is limited to the first '||(row_limit-1)||' rows to prevent an excessively big output file.
');
1172: End If;
1173: statusStr := 'SUCCESS';
1174: isFatal := 'FALSE';
1175: End;

Line 1182: --JTF_DIAGNOSTIC_COREAPI.Line_Out('Column: '||l_varchar_col_rec.column_name);

1178: /* Script to verify records in bom_sub_operation_resources table */
1179: Begin
1180: delete from bom_diag_temp_tab; -- Clear the temporary tables
1181: For l_varchar_col_rec in c_varchar_cols_cur('BOM_SUB_OPERATION_RESOURCES',l_oracle_schema) Loop
1182: --JTF_DIAGNOSTIC_COREAPI.Line_Out('Column: '||l_varchar_col_rec.column_name);
1183:
1184: sql_stmt := '';
1185: sql_stmt :=' Insert into bom_diag_temp_tab (Inventory_item_id,Organization_id, '||
1186: ' char_col3,Num_col1,Num_col2,Num_col3,Num_col4,Num_col5,Num_col6,char_col1,char_col2)'||

Line 1231: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Columns containing Trailing Spaces in bom_sub_operation_resources table ');

1227:
1228: sqltxt := sqltxt || ' and rownum< '||row_limit;
1229: sqltxt :=sqltxt||' order by inventory_item_id, organization_id, char_col3,Num_col2,Num_col3,Num_col6,char_col1';
1230:
1231: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Columns containing Trailing Spaces in bom_sub_operation_resources table ');
1232: If (num_rows = row_limit -1 ) Then
1233: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output of the above table is limited to the first '||(row_limit-1)||' rows to prevent an excessively big output file.
');
1234: End If;
1235: statusStr := 'SUCCESS';

Line 1233: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output of the above table is limited to the first '||(row_limit-1)||' rows to prevent an excessively big output file.
');

1229: sqltxt :=sqltxt||' order by inventory_item_id, organization_id, char_col3,Num_col2,Num_col3,Num_col6,char_col1';
1230:
1231: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Columns containing Trailing Spaces in bom_sub_operation_resources table ');
1232: If (num_rows = row_limit -1 ) Then
1233: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output of the above table is limited to the first '||(row_limit-1)||' rows to prevent an excessively big output file.
');
1234: End If;
1235: statusStr := 'SUCCESS';
1236: isFatal := 'FALSE';
1237: End;

Line 1245: --JTF_DIAGNOSTIC_COREAPI.Line_Out('Column: '||l_varchar_col_rec.column_name);

1241: /* Script to verify records in bom_operation_networks table */
1242: Begin
1243: delete from bom_diag_temp_tab; -- Clear the temporary tables
1244: For l_varchar_col_rec in c_varchar_cols_cur('BOM_OPERATION_NETWORKS',l_oracle_schema) Loop
1245: --JTF_DIAGNOSTIC_COREAPI.Line_Out('Column: '||l_varchar_col_rec.column_name);
1246:
1247: sql_stmt := '';
1248: sql_stmt :=' Insert into bom_diag_temp_tab (Inventory_item_id,Organization_id, '||
1249: ' char_col3,Num_col1,Num_col2,Num_col3,Num_col4,char_col1,char_col2)'||

Line 1290: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Columns containing Trailing Spaces in bom_operation_networks table ');

1286:
1287: sqltxt := sqltxt || ' and rownum< '||row_limit;
1288: sqltxt :=sqltxt||' order by inventory_item_id, organization_id, char_col3,Num_col2,Num_col3,char_col1';
1289:
1290: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Columns containing Trailing Spaces in bom_operation_networks table ');
1291: If (num_rows = row_limit -1 ) Then
1292: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output of the above table is limited to the first '||(row_limit-1)||' rows to prevent an excessively big output file.
');
1293: End If;
1294: statusStr := 'SUCCESS';

Line 1292: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output of the above table is limited to the first '||(row_limit-1)||' rows to prevent an excessively big output file.
');

1288: sqltxt :=sqltxt||' order by inventory_item_id, organization_id, char_col3,Num_col2,Num_col3,char_col1';
1289:
1290: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Columns containing Trailing Spaces in bom_operation_networks table ');
1291: If (num_rows = row_limit -1 ) Then
1292: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output of the above table is limited to the first '||(row_limit-1)||' rows to prevent an excessively big output file.
');
1293: End If;
1294: statusStr := 'SUCCESS';
1295: isFatal := 'FALSE';
1296: End;

Line 1302: JTF_DIAGNOSTIC_COREAPI.Line_Out('

This data collection script completed as expected
');

1298:
1299: /* End of Scripts to check for trailing spaces in Rtg Tables */
1300:
1301: <>
1302: JTF_DIAGNOSTIC_COREAPI.Line_Out('

This data collection script completed as expected
');
1303: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
1304: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
1305:
1306: EXCEPTION

Line 1308: JTF_DIAGNOSTIC_COREAPI.errorprint('Error: '||sqlerrm);

1304: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
1305:
1306: EXCEPTION
1307: when others then
1308: JTF_DIAGNOSTIC_COREAPI.errorprint('Error: '||sqlerrm);
1309: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('If this error repeats, please contact Oracle Support Services');
1310: statusStr := 'FAILURE';
1311: errStr := sqlerrm ||' occurred in script. ';
1312: fixInfo := 'Unexpected Exception in BOMDGTSB.pls';

Line 1309: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('If this error repeats, please contact Oracle Support Services');

1305:
1306: EXCEPTION
1307: when others then
1308: JTF_DIAGNOSTIC_COREAPI.errorprint('Error: '||sqlerrm);
1309: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('If this error repeats, please contact Oracle Support Services');
1310: statusStr := 'FAILURE';
1311: errStr := sqlerrm ||' occurred in script. ';
1312: fixInfo := 'Unexpected Exception in BOMDGTSB.pls';
1313: isFatal := 'FALSE';