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 53: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 110: JTF_DIAGNOSTIC_COREAPI.Line_Out('

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

IMPACT:

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

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

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

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

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

202:
203: sqltxt := sqltxt || ' and rownum< '||row_limit;
204: sqltxt :=sqltxt||' order by inventory_item_id, organization_id,char_col1';
205:
206: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Columns containing Trailing Spaces in mtl_system_items_b table ');
207: If (num_rows = row_limit -1 ) Then
208: 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.
');
209: End If;
210: statusStr := 'SUCCESS';

Line 208: 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.
');

204: sqltxt :=sqltxt||' order by inventory_item_id, organization_id,char_col1';
205:
206: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Columns containing Trailing Spaces in mtl_system_items_b table ');
207: If (num_rows = row_limit -1 ) Then
208: 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.
');
209: End If;
210: statusStr := 'SUCCESS';
211: isFatal := 'FALSE';
212:

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

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

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

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

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

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

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

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

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

287:
288: sqltxt := sqltxt || ' and rownum< '||row_limit;
289: sqltxt :=sqltxt||' order by inventory_item_id, organization_id,char_col3,char_col1';
290:
291: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Columns containing Trailing Spaces in mtl_system_items_tl table ');
292: If (num_rows = row_limit -1 ) Then
293: 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.
');
294: End If;
295: statusStr := 'SUCCESS';

Line 293: 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.
');

289: sqltxt :=sqltxt||' order by inventory_item_id, organization_id,char_col3,char_col1';
290:
291: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Columns containing Trailing Spaces in mtl_system_items_tl table ');
292: If (num_rows = row_limit -1 ) Then
293: 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.
');
294: End If;
295: statusStr := 'SUCCESS';
296: isFatal := 'FALSE';
297:

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

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

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

336:
337: sqltxt := sqltxt || ' and rownum< '||row_limit;
338: sqltxt :=sqltxt||' order by inventory_item_id, organization_id, char_col3,char_col1';
339:
340: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Columns containing Trailing Spaces in mtl_item_revisions_b table ');
341: If (num_rows = row_limit -1 ) Then
342: 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.
');
343: End If;
344: statusStr := 'SUCCESS';

Line 342: 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.
');

338: sqltxt :=sqltxt||' order by inventory_item_id, organization_id, char_col3,char_col1';
339:
340: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Columns containing Trailing Spaces in mtl_item_revisions_b table ');
341: If (num_rows = row_limit -1 ) Then
342: 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.
');
343: End If;
344: statusStr := 'SUCCESS';
345: isFatal := 'FALSE';
346:

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

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

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

385:
386: sqltxt := sqltxt || ' and rownum< '||row_limit;
387: sqltxt :=sqltxt||' order by inventory_item_id, organization_id, num_col1,char_col3,char_col1';
388:
389: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Columns containing Trailing Spaces in mtl_item_revisions_tl table ');
390: If (num_rows = row_limit -1 ) Then
391: 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.
');
392: End If;
393: statusStr := 'SUCCESS';

Line 391: 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.
');

387: sqltxt :=sqltxt||' order by inventory_item_id, organization_id, num_col1,char_col3,char_col1';
388:
389: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Columns containing Trailing Spaces in mtl_item_revisions_tl table ');
390: If (num_rows = row_limit -1 ) Then
391: 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.
');
392: End If;
393: statusStr := 'SUCCESS';
394: isFatal := 'FALSE';
395:

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

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

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

431:
432: sqltxt := sqltxt || ' and rownum< '||row_limit;
433: sqltxt :=sqltxt||' order by inventory_item_id, organization_id, char_col3,char_col1';
434:
435: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Columns containing Trailing Spaces in mtl_descr_element_values table ');
436: If (num_rows = row_limit -1 ) Then
437: 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.
');
438: End If;
439: statusStr := 'SUCCESS';

Line 437: 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.
');

433: sqltxt :=sqltxt||' order by inventory_item_id, organization_id, char_col3,char_col1';
434:
435: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Columns containing Trailing Spaces in mtl_descr_element_values table ');
436: If (num_rows = row_limit -1 ) Then
437: 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.
');
438: End If;
439: statusStr := 'SUCCESS';
440: isFatal := 'FALSE';
441: End;

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

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

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

479:
480: sqltxt := sqltxt || ' and rownum< '||row_limit;
481: sqltxt :=sqltxt||' order by inventory_item_id, organization_id, char_col3,Date_col1,char_col1';
482:
483: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Columns containing Trailing Spaces in mtl_pending_item_status table ');
484: If (num_rows = row_limit -1 ) Then
485: 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.
');
486: End If;
487: statusStr := 'SUCCESS';

Line 485: 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.
');

481: sqltxt :=sqltxt||' order by inventory_item_id, organization_id, char_col3,Date_col1,char_col1';
482:
483: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Columns containing Trailing Spaces in mtl_pending_item_status table ');
484: If (num_rows = row_limit -1 ) Then
485: 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.
');
486: End If;
487: statusStr := 'SUCCESS';
488: isFatal := 'FALSE';
489: End;

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

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

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

529:
530: sqltxt := sqltxt || ' and rownum< '||row_limit;
531: sqltxt :=sqltxt||' order by inventory_item_id, organization_id, char_col3,char_col4,char_col1';
532:
533: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Columns containing Trailing Spaces in mtl_cross_references_b table ');
534: If (num_rows = row_limit -1 ) Then
535: 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.
');
536: End If;
537: statusStr := 'SUCCESS';

Line 535: 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.
');

531: sqltxt :=sqltxt||' order by inventory_item_id, organization_id, char_col3,char_col4,char_col1';
532:
533: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Columns containing Trailing Spaces in mtl_cross_references_b table ');
534: If (num_rows = row_limit -1 ) Then
535: 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.
');
536: End If;
537: statusStr := 'SUCCESS';
538: isFatal := 'FALSE';
539: End;

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

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

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

575:
576: sqltxt := sqltxt || ' and rownum< '||row_limit;
577: sqltxt :=sqltxt||' order by num_col1,char_col4,char_col1';
578:
579: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Columns containing Trailing Spaces in mtl_cross_references_tl table ');
580: If (num_rows = row_limit -1 ) Then
581: 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.
');
582: End If;
583: statusStr := 'SUCCESS';

Line 581: 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.
');

577: sqltxt :=sqltxt||' order by num_col1,char_col4,char_col1';
578:
579: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Columns containing Trailing Spaces in mtl_cross_references_tl table ');
580: If (num_rows = row_limit -1 ) Then
581: 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.
');
582: End If;
583: statusStr := 'SUCCESS';
584: isFatal := 'FALSE';
585: End;

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

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

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

623:
624: sqltxt := sqltxt || ' and rownum< '||row_limit;
625: sqltxt :=sqltxt||' order by inventory_item_id, organization_id, Num_col1,char_col1';
626:
627: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Columns containing Trailing Spaces in mtl_customer_item_xrefs table ');
628: If (num_rows = row_limit -1 ) Then
629: 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.
');
630: End If;
631: statusStr := 'SUCCESS';

Line 629: 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.
');

625: sqltxt :=sqltxt||' order by inventory_item_id, organization_id, Num_col1,char_col1';
626:
627: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Columns containing Trailing Spaces in mtl_customer_item_xrefs table ');
628: If (num_rows = row_limit -1 ) Then
629: 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.
');
630: End If;
631: statusStr := 'SUCCESS';
632: isFatal := 'FALSE';
633: End;

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

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

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

673:
674: sqltxt := sqltxt || ' and rownum< '||row_limit;
675: sqltxt :=sqltxt||' order by inventory_item_id, organization_id, Num_col1,char_col3,char_col1';
676:
677: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Columns containing Trailing Spaces in mtl_mfg_part_numbers table ');
678: If (num_rows = row_limit -1 ) Then
679: 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.
');
680: End If;
681: statusStr := 'SUCCESS';

Line 679: 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.
');

675: sqltxt :=sqltxt||' order by inventory_item_id, organization_id, Num_col1,char_col3,char_col1';
676:
677: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Columns containing Trailing Spaces in mtl_mfg_part_numbers table ');
678: If (num_rows = row_limit -1 ) Then
679: 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.
');
680: End If;
681: statusStr := 'SUCCESS';
682: isFatal := 'FALSE';
683: End;

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

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

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

719:
720: sqltxt := sqltxt || ' and rownum< '||row_limit;
721: sqltxt :=sqltxt||' order by inventory_item_id, organization_id, char_col3,char_col1';
722:
723: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Columns containing Trailing Spaces in mtl_rtg_item_revisions table ');
724: If (num_rows = row_limit -1 ) Then
725: 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.
');
726: End If;
727: statusStr := 'SUCCESS';

Line 725: 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.
');

721: sqltxt :=sqltxt||' order by inventory_item_id, organization_id, char_col3,char_col1';
722:
723: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Columns containing Trailing Spaces in mtl_rtg_item_revisions table ');
724: If (num_rows = row_limit -1 ) Then
725: 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.
');
726: End If;
727: statusStr := 'SUCCESS';
728: isFatal := 'FALSE';
729:

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

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

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

770:
771: sqltxt := sqltxt || ' and rownum< '||row_limit;
772: sqltxt :=sqltxt||' order by inventory_item_id, organization_id, Num_col1,Num_col2,char_col1';
773:
774: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Columns containing Trailing Spaces in mtl_related_items table ');
775: If (num_rows = row_limit -1 ) Then
776: 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.
');
777: End If;
778: statusStr := 'SUCCESS';

Line 776: 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.
');

772: sqltxt :=sqltxt||' order by inventory_item_id, organization_id, Num_col1,Num_col2,char_col1';
773:
774: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Columns containing Trailing Spaces in mtl_related_items table ');
775: If (num_rows = row_limit -1 ) Then
776: 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.
');
777: End If;
778: statusStr := 'SUCCESS';
779: isFatal := 'FALSE';
780: End;

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

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

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

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

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

835:
836: sqltxt := sqltxt || ' and rownum< '||row_limit;
837: sqltxt :=sqltxt||' order by inventory_item_id, organization_id, char_col3,Num_col1,char_col1';
838:
839: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Columns containing Trailing Spaces in bom_structures_b table ');
840: If (num_rows = row_limit -1 ) Then
841: 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.
');
842: End If;
843: statusStr := 'SUCCESS';

Line 841: 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.
');

837: sqltxt :=sqltxt||' order by inventory_item_id, organization_id, char_col3,Num_col1,char_col1';
838:
839: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Columns containing Trailing Spaces in bom_structures_b table ');
840: If (num_rows = row_limit -1 ) Then
841: 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.
');
842: End If;
843: statusStr := 'SUCCESS';
844: isFatal := 'FALSE';
845: End;

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

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

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

891:
892: sqltxt := sqltxt || ' and rownum< '||row_limit;
893: sqltxt :=sqltxt||' order by inventory_item_id, organization_id, char_col3,Num_col1,Num_col2,Num_col3,char_col1';
894:
895: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Columns containing Trailing Spaces in bom_components_b table ');
896: If (num_rows = row_limit -1 ) Then
897: 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.
');
898: End If;
899: statusStr := 'SUCCESS';

Line 897: 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.
');

893: sqltxt :=sqltxt||' order by inventory_item_id, organization_id, char_col3,Num_col1,Num_col2,Num_col3,char_col1';
894:
895: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Columns containing Trailing Spaces in bom_components_b table ');
896: If (num_rows = row_limit -1 ) Then
897: 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.
');
898: End If;
899: statusStr := 'SUCCESS';
900: isFatal := 'FALSE';
901: End;

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

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

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

946:
947: sqltxt := sqltxt || ' and rownum< '||row_limit;
948: sqltxt :=sqltxt||' order by inventory_item_id, organization_id, char_col3,Num_col1,Num_col2,char_col1';
949:
950: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Columns containing Trailing Spaces in bom_reference_designators table ');
951: If (num_rows = row_limit -1 ) Then
952: 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.
');
953: End If;
954: statusStr := 'SUCCESS';

Line 952: 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.
');

948: sqltxt :=sqltxt||' order by inventory_item_id, organization_id, char_col3,Num_col1,Num_col2,char_col1';
949:
950: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Columns containing Trailing Spaces in bom_reference_designators table ');
951: If (num_rows = row_limit -1 ) Then
952: 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.
');
953: End If;
954: statusStr := 'SUCCESS';
955: isFatal := 'FALSE';
956: End;

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

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

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

1001:
1002: sqltxt := sqltxt || ' and rownum< '||row_limit;
1003: sqltxt :=sqltxt||' order by inventory_item_id, organization_id, char_col3,Num_col1,Num_col2,char_col1';
1004:
1005: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Columns containing Trailing Spaces in bom_substitute_components table ');
1006: If (num_rows = row_limit -1 ) Then
1007: 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.
');
1008: End If;
1009: statusStr := 'SUCCESS';

Line 1007: 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.
');

1003: sqltxt :=sqltxt||' order by inventory_item_id, organization_id, char_col3,Num_col1,Num_col2,char_col1';
1004:
1005: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Columns containing Trailing Spaces in bom_substitute_components table ');
1006: If (num_rows = row_limit -1 ) Then
1007: 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.
');
1008: End If;
1009: statusStr := 'SUCCESS';
1010: isFatal := 'FALSE';
1011: End;

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

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

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

1054:
1055: sqltxt := sqltxt || ' and rownum< '||row_limit;
1056: sqltxt :=sqltxt||' order by inventory_item_id, organization_id, char_col3,char_col1';
1057:
1058: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Columns containing Trailing Spaces in bom_operational_routings table ');
1059: If (num_rows = row_limit -1 ) Then
1060: 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.
');
1061: End If;
1062: statusStr := 'SUCCESS';

Line 1060: 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.
');

1056: sqltxt :=sqltxt||' order by inventory_item_id, organization_id, char_col3,char_col1';
1057:
1058: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Columns containing Trailing Spaces in bom_operational_routings table ');
1059: If (num_rows = row_limit -1 ) Then
1060: 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.
');
1061: End If;
1062: statusStr := 'SUCCESS';
1063: isFatal := 'FALSE';
1064: End;

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

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

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

1106:
1107: sqltxt := sqltxt || ' and rownum< '||row_limit;
1108: sqltxt :=sqltxt||' order by inventory_item_id, organization_id, char_col3,char_col1';
1109:
1110: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Columns containing Trailing Spaces in bom_operation_sequences table ');
1111: If (num_rows = row_limit -1 ) Then
1112: 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.
');
1113: End If;
1114: statusStr := 'SUCCESS';

Line 1112: 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.
');

1108: sqltxt :=sqltxt||' order by inventory_item_id, organization_id, char_col3,char_col1';
1109:
1110: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Columns containing Trailing Spaces in bom_operation_sequences table ');
1111: If (num_rows = row_limit -1 ) Then
1112: 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.
');
1113: End If;
1114: statusStr := 'SUCCESS';
1115: isFatal := 'FALSE';
1116: End;

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

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

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

1164:
1165: sqltxt := sqltxt || ' and rownum< '||row_limit;
1166: sqltxt :=sqltxt||' order by inventory_item_id, organization_id, char_col3,Num_col2,Num_col3,char_col1';
1167:
1168: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Columns containing Trailing Spaces in bom_operation_resources table ');
1169: If (num_rows = row_limit -1 ) Then
1170: 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.
');
1171: End If;
1172: statusStr := 'SUCCESS';

Line 1170: 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.
');

1166: sqltxt :=sqltxt||' order by inventory_item_id, organization_id, char_col3,Num_col2,Num_col3,char_col1';
1167:
1168: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Columns containing Trailing Spaces in bom_operation_resources table ');
1169: If (num_rows = row_limit -1 ) Then
1170: 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.
');
1171: End If;
1172: statusStr := 'SUCCESS';
1173: isFatal := 'FALSE';
1174: End;

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

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

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

1226:
1227: sqltxt := sqltxt || ' and rownum< '||row_limit;
1228: sqltxt :=sqltxt||' order by inventory_item_id, organization_id, char_col3,Num_col2,Num_col3,Num_col6,char_col1';
1229:
1230: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Columns containing Trailing Spaces in bom_sub_operation_resources table ');
1231: If (num_rows = row_limit -1 ) Then
1232: 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.
');
1233: End If;
1234: statusStr := 'SUCCESS';

Line 1232: 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.
');

1228: sqltxt :=sqltxt||' order by inventory_item_id, organization_id, char_col3,Num_col2,Num_col3,Num_col6,char_col1';
1229:
1230: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Columns containing Trailing Spaces in bom_sub_operation_resources table ');
1231: If (num_rows = row_limit -1 ) Then
1232: 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.
');
1233: End If;
1234: statusStr := 'SUCCESS';
1235: isFatal := 'FALSE';
1236: End;

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

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

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

1285:
1286: sqltxt := sqltxt || ' and rownum< '||row_limit;
1287: sqltxt :=sqltxt||' order by inventory_item_id, organization_id, char_col3,Num_col2,Num_col3,char_col1';
1288:
1289: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Columns containing Trailing Spaces in bom_operation_networks table ');
1290: If (num_rows = row_limit -1 ) Then
1291: 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.
');
1292: End If;
1293: statusStr := 'SUCCESS';

Line 1291: 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.
');

1287: sqltxt :=sqltxt||' order by inventory_item_id, organization_id, char_col3,Num_col2,Num_col3,char_col1';
1288:
1289: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Columns containing Trailing Spaces in bom_operation_networks table ');
1290: If (num_rows = row_limit -1 ) Then
1291: 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.
');
1292: End If;
1293: statusStr := 'SUCCESS';
1294: isFatal := 'FALSE';
1295: End;

Line 1301: JTF_DIAGNOSTIC_COREAPI.Line_Out('

This data collection script completed as expected
');

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

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

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

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

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

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