APPS.BOM_DIAGUNITTEST_INTFDATA dependencies on JTF_DIAGNOSTIC_COREAPI

Line 38: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;

34:
35: BEGIN
36: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
37: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
38: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
39:
40: /* set limit of records to be fetched*/
41: row_limit :=1000;
42:

Line 54: JTF_DIAGNOSTIC_COREAPI.errorprint('Invalid input Type');

50: */
51:
52: /* Vaaidate input values for TYPE */
53: If (l_type is null) or ( upper(l_type) not in ('INV', 'BOM','RTG','ENG')) Then
54: JTF_DIAGNOSTIC_COREAPI.errorprint('Invalid input Type');
55: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint(' Please provide a valid value for the input field Type. ');
56: statusStr := 'FAILURE';
57: isFatal := 'TRUE';
58: fixInfo := ' Please review the error message below and take corrective action. ';

Line 55: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint(' Please provide a valid value for the input field Type. ');

51:
52: /* Vaaidate input values for TYPE */
53: If (l_type is null) or ( upper(l_type) not in ('INV', 'BOM','RTG','ENG')) Then
54: JTF_DIAGNOSTIC_COREAPI.errorprint('Invalid input Type');
55: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint(' Please provide a valid value for the input field Type. ');
56: statusStr := 'FAILURE';
57: isFatal := 'TRUE';
58: fixInfo := ' Please review the error message below and take corrective action. ';
59: errStr := ' Invalid value for input field Type. ';

Line 70: as an input parameter to JTF_DIAGNOSTIC_COREAPI.Column_Exists API. */

66: /* Items Interface Details */
67:
68: /* Get the application installation info. References to Data Dictionary Objects without schema name
69: included in WHERE predicate are not allowed (GSCC Check: file.sql.47). Schema name has to be passed
70: as an input parameter to JTF_DIAGNOSTIC_COREAPI.Column_Exists API. */
71:
72: l_ret_status := fnd_installation.get_app_info ('INV'
73: , l_status
74: , l_industry

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

74: , l_industry
75: , l_oracle_schema
76: );
77:
78: /*JTF_DIAGNOSTIC_COREAPI.Line_Out(' l_oracle_schema: '||l_oracle_schema);*/
79:
80:
81: /* SQL to fetch records from mtl_system_items_interface */
82: sqltxt := 'SELECT ' ||

Line 205: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Records in mtl_system_items_interface table ');

201:
202: sqltxt :=sqltxt||' and rownum < '||row_limit;
203: sqltxt :=sqltxt||' order by msii.inventory_item_id, msii.organization_id ';
204:
205: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Records in mtl_system_items_interface table ');
206: If (num_rows = row_limit -1 ) Then
207: 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.
');
208: End If;
209: statusStr := 'SUCCESS';

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

203: sqltxt :=sqltxt||' order by msii.inventory_item_id, msii.organization_id ';
204:
205: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Records in mtl_system_items_interface table ');
206: If (num_rows = row_limit -1 ) Then
207: 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.
');
208: End If;
209: statusStr := 'SUCCESS';
210: isFatal := 'FALSE';
211:

Line 340: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Records in mtl_system_items_interface table (Contd 1..)');

336:
337: sqltxt :=sqltxt||' and rownum < '||row_limit;
338: sqltxt :=sqltxt||' order by msii.inventory_item_id, msii.organization_id ';
339:
340: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Records in mtl_system_items_interface table (Contd 1..)');
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:

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 msii.inventory_item_id, msii.organization_id ';
339:
340: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Records in mtl_system_items_interface table (Contd 1..)');
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:
345: statusStr := 'SUCCESS';
346: isFatal := 'FALSE';

Line 477: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Records in mtl_system_items_interface table (Contd 2..) ');

473:
474: sqltxt :=sqltxt||' and rownum < '||row_limit;
475: sqltxt :=sqltxt||' order by msii.inventory_item_id, msii.organization_id ';
476:
477: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Records in mtl_system_items_interface table (Contd 2..) ');
478: If (num_rows = row_limit -1 ) Then
479: 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.
');
480: End If;
481: statusStr := 'SUCCESS';

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

475: sqltxt :=sqltxt||' order by msii.inventory_item_id, msii.organization_id ';
476:
477: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Records in mtl_system_items_interface table (Contd 2..) ');
478: If (num_rows = row_limit -1 ) Then
479: 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.
');
480: End If;
481: statusStr := 'SUCCESS';
482: isFatal := 'FALSE';
483:

Line 549: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Records in mtl_system_items_interface table (Contd 3..) ');

545:
546: sqltxt :=sqltxt||' and rownum < '||row_limit;
547: sqltxt :=sqltxt||' order by msii.inventory_item_id, msii.organization_id ';
548:
549: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Records in mtl_system_items_interface table (Contd 3..) ');
550: If (num_rows = row_limit -1 ) Then
551: 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.
');
552: End If;
553: statusStr := 'SUCCESS';

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

547: sqltxt :=sqltxt||' order by msii.inventory_item_id, msii.organization_id ';
548:
549: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Records in mtl_system_items_interface table (Contd 3..) ');
550: If (num_rows = row_limit -1 ) Then
551: 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.
');
552: End If;
553: statusStr := 'SUCCESS';
554: isFatal := 'FALSE';
555:

Line 617: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Records in mtl_item_revisions_interface table ');

613:
614: sqltxt :=sqltxt||' and rownum < '||row_limit;
615: sqltxt :=sqltxt||' order by miri.inventory_item_id, miri.organization_id, miri.revision ';
616:
617: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Records in mtl_item_revisions_interface table ');
618: If (num_rows = row_limit -1 ) Then
619: 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.
');
620: End If;
621: statusStr := 'SUCCESS';

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

615: sqltxt :=sqltxt||' order by miri.inventory_item_id, miri.organization_id, miri.revision ';
616:
617: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Records in mtl_item_revisions_interface table ');
618: If (num_rows = row_limit -1 ) Then
619: 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.
');
620: End If;
621: statusStr := 'SUCCESS';
622: isFatal := 'FALSE';
623:

Line 674: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Records in mtl_rtg_item_revs_interface table ');

670:
671: sqltxt :=sqltxt||' and rownum < '||row_limit;
672: sqltxt :=sqltxt||' order by mriri.inventory_item_id, mriri.organization_id, mriri.process_revision ';
673:
674: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Records in mtl_rtg_item_revs_interface table ');
675: If (num_rows = row_limit -1 ) Then
676: 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.
');
677: End If;
678: statusStr := 'SUCCESS';

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

672: sqltxt :=sqltxt||' order by mriri.inventory_item_id, mriri.organization_id, mriri.process_revision ';
673:
674: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Records in mtl_rtg_item_revs_interface table ');
675: If (num_rows = row_limit -1 ) Then
676: 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.
');
677: End If;
678: statusStr := 'SUCCESS';
679: isFatal := 'FALSE';
680:

Line 719: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Records in mtl_item_categories_interface table ');

715: sqltxt :=sqltxt||' and rownum < '||row_limit;
716: sqltxt :=sqltxt||' order by mici.inventory_item_id, mici.organization_id, '||
717: ' mici.category_set_id, mici.category_id ';
718:
719: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Records in mtl_item_categories_interface table ');
720: If (num_rows = row_limit -1 ) Then
721: 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: End If;
723: statusStr := 'SUCCESS';

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

717: ' mici.category_set_id, mici.category_id ';
718:
719: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Records in mtl_item_categories_interface table ');
720: If (num_rows = row_limit -1 ) Then
721: 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: End If;
723: statusStr := 'SUCCESS';
724: isFatal := 'FALSE';
725: /* End of mtl_item_categories_interface */

Line 735: as an input parameter to JTF_DIAGNOSTIC_COREAPI.Column_Exists API. */

731: /* Fetch data from tables exclusive to bom */
732:
733: /* Get the application installation info. References to Data Dictionary Objects without schema name
734: included in WHERE predicate are not allowed (GSCC Check: file.sql.47). Schema name has to be passed
735: as an input parameter to JTF_DIAGNOSTIC_COREAPI.Column_Exists API. */
736:
737: l_ret_status := fnd_installation.get_app_info ('BOM'
738: , l_status
739: , l_industry

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

739: , l_industry
740: , l_oracle_schema
741: );
742:
743: /*JTF_DIAGNOSTIC_COREAPI.Line_Out(' l_oracle_schema: '||l_oracle_schema);*/
744:
745: /* SQL to fetch from bom_bill_of_mtls_interface table */
746: sqltxt := 'SELECT ' ||
747: ' BBMI.ASSEMBLY_ITEM_ID "ASSEMBLY ITEM ID", '||

Line 827: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Records in bom_bill_of_mtls_interface table ');

823:
824: sqltxt :=sqltxt||' and rownum < '||row_limit;
825: sqltxt :=sqltxt||' order by bbmi.assembly_item_id, bbmi.organization_id, bbmi.alternate_bom_designator';
826:
827: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Records in bom_bill_of_mtls_interface table ');
828: If (num_rows = row_limit -1 ) Then
829: 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.
');
830: End If;
831: statusStr := 'SUCCESS';

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

825: sqltxt :=sqltxt||' order by bbmi.assembly_item_id, bbmi.organization_id, bbmi.alternate_bom_designator';
826:
827: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Records in bom_bill_of_mtls_interface table ');
828: If (num_rows = row_limit -1 ) Then
829: 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.
');
830: End If;
831: statusStr := 'SUCCESS';
832: isFatal := 'FALSE';
833: /* End of bom_bill_of_mtls_interface */

Line 842: as an input parameter to JTF_DIAGNOSTIC_COREAPI.Column_Exists API. */

838: /* Fetch tables exclusive to rtg */
839:
840: /* Get the application installation info. References to Data Dictionary Objects without schema name
841: included in WHERE predicate are not allowed (GSCC Check: file.sql.47). Schema name has to be passed
842: as an input parameter to JTF_DIAGNOSTIC_COREAPI.Column_Exists API. */
843:
844: l_ret_status := fnd_installation.get_app_info ('BOM'
845: , l_status
846: , l_industry

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

846: , l_industry
847: , l_oracle_schema
848: );
849:
850: /*JTF_DIAGNOSTIC_COREAPI.Line_Out(' l_oracle_schema: '||l_oracle_schema);*/
851:
852: /* SQL to fetch records from bom_op_routings_interface table */
853: sqltxt := 'SELECT ' ||
854: ' BORI.ROUTING_SEQUENCE_ID "ROUTING SEQUENCE ID", '||

Line 918: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Records in bom_op_routings_interface table ');

914:
915: sqltxt :=sqltxt||' and rownum < '||row_limit;
916: sqltxt :=sqltxt||' order by bori.assembly_item_id, bori.organization_id, bori.alternate_routing_designator';
917:
918: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Records in bom_op_routings_interface table ');
919: If (num_rows = row_limit -1 ) Then
920: 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.
');
921: End If;
922: statusStr := 'SUCCESS';

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

916: sqltxt :=sqltxt||' order by bori.assembly_item_id, bori.organization_id, bori.alternate_routing_designator';
917:
918: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Records in bom_op_routings_interface table ');
919: If (num_rows = row_limit -1 ) Then
920: 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.
');
921: End If;
922: statusStr := 'SUCCESS';
923: isFatal := 'FALSE';
924:

Line 988: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Records in bom_op_networks_interface table ');

984: sqltxt :=sqltxt||' and rownum < '||row_limit;
985: sqltxt :=sqltxt||' order by boni.assembly_item_id, boni.organization_id, boni.alternate_routing_designator,'||
986: ' boni.from_op_seq_id, boni.to_op_seq_id ';
987:
988: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Records in bom_op_networks_interface table ');
989: If (num_rows = row_limit -1 ) Then
990: 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.
');
991: End If;
992: statusStr := 'SUCCESS';

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

986: ' boni.from_op_seq_id, boni.to_op_seq_id ';
987:
988: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Records in bom_op_networks_interface table ');
989: If (num_rows = row_limit -1 ) Then
990: 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.
');
991: End If;
992: statusStr := 'SUCCESS';
993: isFatal := 'FALSE';
994:

Line 1093: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Records in eng_eng_changes_interface table ');

1089:
1090: sqltxt :=sqltxt||' and rownum < '||row_limit;
1091: sqltxt :=sqltxt||' order by eeci.change_notice, eeci.organization_id ';
1092:
1093: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Records in eng_eng_changes_interface table ');
1094: If (num_rows = row_limit -1 ) Then
1095: 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.
');
1096: End If;
1097: statusStr := 'SUCCESS';

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

1091: sqltxt :=sqltxt||' order by eeci.change_notice, eeci.organization_id ';
1092:
1093: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Records in eng_eng_changes_interface table ');
1094: If (num_rows = row_limit -1 ) Then
1095: 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.
');
1096: End If;
1097: statusStr := 'SUCCESS';
1098: isFatal := 'FALSE';
1099:

Line 1192: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Records in eng_revised_items_interface table ');

1188: sqltxt :=sqltxt||' and rownum < '||row_limit;
1189: sqltxt :=sqltxt||' order by erii.change_notice,erii.organization_id, '||
1190: ' erii.revised_item_id,erii.revised_item_sequence_id ';
1191:
1192: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Records in eng_revised_items_interface table ');
1193: If (num_rows = row_limit -1 ) Then
1194: 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.
');
1195: End If;
1196: statusStr := 'SUCCESS';

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

1190: ' erii.revised_item_id,erii.revised_item_sequence_id ';
1191:
1192: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Records in eng_revised_items_interface table ');
1193: If (num_rows = row_limit -1 ) Then
1194: 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.
');
1195: End If;
1196: statusStr := 'SUCCESS';
1197: isFatal := 'FALSE';
1198:

Line 1246: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Records in eng_eco_revisions_interface table ');

1242:
1243: sqltxt :=sqltxt||' and rownum < '||row_limit;
1244: sqltxt :=sqltxt||' order by eeri.organization_id, eeri.change_notice,eeri.revision ';
1245:
1246: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Records in eng_eco_revisions_interface table ');
1247: If (num_rows = row_limit -1 ) Then
1248: 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.
');
1249: End If;
1250: statusStr := 'SUCCESS';

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

1244: sqltxt :=sqltxt||' order by eeri.organization_id, eeri.change_notice,eeri.revision ';
1245:
1246: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Records in eng_eco_revisions_interface table ');
1247: If (num_rows = row_limit -1 ) Then
1248: 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.
');
1249: End If;
1250: statusStr := 'SUCCESS';
1251: isFatal := 'FALSE';
1252:

Line 1263: as an input parameter to JTF_DIAGNOSTIC_COREAPI.Column_Exists API. */

1259: /* Fetch tables common to bom and eng */
1260:
1261: /* Get the application installation info. References to Data Dictionary Objects without schema name
1262: included in WHERE predicate are not allowed (GSCC Check: file.sql.47). Schema name has to be passed
1263: as an input parameter to JTF_DIAGNOSTIC_COREAPI.Column_Exists API. */
1264:
1265: l_ret_status := fnd_installation.get_app_info ('BOM'
1266: , l_status
1267: , l_industry

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

1267: , l_industry
1268: , l_oracle_schema
1269: );
1270:
1271: /*JTF_DIAGNOSTIC_COREAPI.Line_Out(' l_oracle_schema: '||l_oracle_schema);*/
1272:
1273: /* SQL to fetch records from bom_inventory_comps_interface */
1274: sqltxt := 'SELECT ' ||
1275: ' BICI.OPERATION_SEQ_NUM "OPERATION SEQ NUM", '||

Line 1363: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Records in bom_inventory_comps_interface table ');

1359:
1360: sqltxt :=sqltxt||' and rownum < '||row_limit;
1361: sqltxt :=sqltxt||' order by bici.operation_seq_num, bici.component_item_id';
1362:
1363: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Records in bom_inventory_comps_interface table ');
1364: If (num_rows = row_limit -1 ) Then
1365: 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.
');
1366: End If;
1367: statusStr := 'SUCCESS';

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

1361: sqltxt :=sqltxt||' order by bici.operation_seq_num, bici.component_item_id';
1362:
1363: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Records in bom_inventory_comps_interface table ');
1364: If (num_rows = row_limit -1 ) Then
1365: 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.
');
1366: End If;
1367: statusStr := 'SUCCESS';
1368: isFatal := 'FALSE';
1369:

Line 1441: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Records in bom_inventory_comps_interface table (Contd 1..) ');

1437:
1438: sqltxt :=sqltxt||' and rownum < '||row_limit;
1439: sqltxt :=sqltxt||' order by bici.operation_seq_num, bici.component_item_id';
1440:
1441: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Records in bom_inventory_comps_interface table (Contd 1..) ');
1442: If (num_rows = row_limit -1 ) Then
1443: 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.
');
1444: End If;
1445: statusStr := 'SUCCESS';

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

1439: sqltxt :=sqltxt||' order by bici.operation_seq_num, bici.component_item_id';
1440:
1441: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Records in bom_inventory_comps_interface table (Contd 1..) ');
1442: If (num_rows = row_limit -1 ) Then
1443: 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.
');
1444: End If;
1445: statusStr := 'SUCCESS';
1446: isFatal := 'FALSE';
1447:

Line 1519: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Records in bom_ref_desgs_interface table ');

1515:
1516: sqltxt :=sqltxt||' and rownum < '||row_limit;
1517: sqltxt :=sqltxt||' order by brdi.component_reference_designator ';
1518:
1519: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Records in bom_ref_desgs_interface table ');
1520: If (num_rows = row_limit -1 ) Then
1521: 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.
');
1522: End If;
1523: statusStr := 'SUCCESS';

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

1517: sqltxt :=sqltxt||' order by brdi.component_reference_designator ';
1518:
1519: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Records in bom_ref_desgs_interface table ');
1520: If (num_rows = row_limit -1 ) Then
1521: 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.
');
1522: End If;
1523: statusStr := 'SUCCESS';
1524: isFatal := 'FALSE';
1525: /* End of bom_ref_desgs_interface */

Line 1600: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Records in bom_sub_comps_interface table ');

1596:
1597: sqltxt :=sqltxt||' and rownum < '||row_limit;
1598: sqltxt :=sqltxt||' order by bsci.substitute_component_id ';
1599:
1600: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Records in bom_sub_comps_interface table ');
1601: If (num_rows = row_limit -1 ) Then
1602: 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.
');
1603: End If;
1604: statusStr := 'SUCCESS';

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

1598: sqltxt :=sqltxt||' order by bsci.substitute_component_id ';
1599:
1600: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Records in bom_sub_comps_interface table ');
1601: If (num_rows = row_limit -1 ) Then
1602: 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.
');
1603: End If;
1604: statusStr := 'SUCCESS';
1605: isFatal := 'FALSE';
1606: /* End of bom_sub_comps_interface */

Line 1672: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Records in bom_component_ops_interface table ');

1668:
1669: sqltxt :=sqltxt||' and rownum < '||row_limit;
1670: sqltxt :=sqltxt||' order by bcoi.comp_operation_seq_id ';
1671:
1672: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Records in bom_component_ops_interface table ');
1673: If (num_rows = row_limit -1 ) Then
1674: 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.
');
1675: End If;
1676: statusStr := 'SUCCESS';

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

1670: sqltxt :=sqltxt||' order by bcoi.comp_operation_seq_id ';
1671:
1672: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Records in bom_component_ops_interface table ');
1673: If (num_rows = row_limit -1 ) Then
1674: 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.
');
1675: End If;
1676: statusStr := 'SUCCESS';
1677: isFatal := 'FALSE';
1678: /* End of bom_component_ops_interface */

Line 1688: as an input parameter to JTF_DIAGNOSTIC_COREAPI.Column_Exists API. */

1684: /* Fetch tables common to rtg and eng */
1685:
1686: /* Get the application installation info. References to Data Dictionary Objects without schema name
1687: included in WHERE predicate are not allowed (GSCC Check: file.sql.47). Schema name has to be passed
1688: as an input parameter to JTF_DIAGNOSTIC_COREAPI.Column_Exists API. */
1689:
1690: l_ret_status := fnd_installation.get_app_info ('BOM'
1691: , l_status
1692: , l_industry

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

1692: , l_industry
1693: , l_oracle_schema
1694: );
1695:
1696: /*JTF_DIAGNOSTIC_COREAPI.Line_Out(' l_oracle_schema: '||l_oracle_schema);*/
1697:
1698: /* SQL to fetch records from bom_op_sequences_interface table */
1699: sqltxt := 'SELECT ' ||
1700: ' BOSI.OPERATION_SEQUENCE_ID "OPERATION SEQUENCE ID", '||

Line 1803: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Records in bom_op_sequences_interface table ');

1799:
1800: sqltxt :=sqltxt||' and rownum < '||row_limit;
1801: sqltxt :=sqltxt||' order by bosi.operation_sequence_id ';
1802:
1803: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Records in bom_op_sequences_interface table ');
1804: If (num_rows = row_limit -1 ) Then
1805: 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.
');
1806: End If;
1807: statusStr := 'SUCCESS';

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

1801: sqltxt :=sqltxt||' order by bosi.operation_sequence_id ';
1802:
1803: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Records in bom_op_sequences_interface table ');
1804: If (num_rows = row_limit -1 ) Then
1805: 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.
');
1806: End If;
1807: statusStr := 'SUCCESS';
1808: isFatal := 'FALSE';
1809:

Line 1885: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Records in bom_op_resources_interface table ');

1881:
1882: sqltxt :=sqltxt||' and rownum < '||row_limit;
1883: sqltxt :=sqltxt||' order by bori.operation_sequence_id,bori.resource_seq_num ';
1884:
1885: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Records in bom_op_resources_interface table ');
1886: If (num_rows = row_limit -1 ) Then
1887: 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.
');
1888: End If;
1889: statusStr := 'SUCCESS';

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

1883: sqltxt :=sqltxt||' order by bori.operation_sequence_id,bori.resource_seq_num ';
1884:
1885: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Records in bom_op_resources_interface table ');
1886: If (num_rows = row_limit -1 ) Then
1887: 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.
');
1888: End If;
1889: statusStr := 'SUCCESS';
1890: isFatal := 'FALSE';
1891:

Line 1967: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Records in bom_sub_op_resources_interface table ');

1963: sqltxt :=sqltxt||' and rownum < '||row_limit;
1964: sqltxt :=sqltxt||' order by bsori.operation_sequence_id,bsori.substitute_group_num, '||
1965: ' bsori.schedule_seq_num, bsori.replacement_group_num, bsori.resource_id ';
1966:
1967: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Records in bom_sub_op_resources_interface table ');
1968: If (num_rows = row_limit -1 ) Then
1969: 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.
');
1970: End If;
1971: statusStr := 'SUCCESS';

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

1965: ' bsori.schedule_seq_num, bsori.replacement_group_num, bsori.resource_id ';
1966:
1967: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Records in bom_sub_op_resources_interface table ');
1968: If (num_rows = row_limit -1 ) Then
1969: 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.
');
1970: End If;
1971: statusStr := 'SUCCESS';
1972: isFatal := 'FALSE';
1973: /* End of bom_sub_op_resources_interface */

Line 2005: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Records in mtl_interface_errors table ');

2001:
2002: sqltxt :=sqltxt||' and rownum < '||row_limit;
2003: sqltxt :=sqltxt||' order by mie.organization_id,mie.transaction_id, mie.unique_id ';
2004:
2005: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Records in mtl_interface_errors table ');
2006: If (num_rows = row_limit -1 ) Then
2007: 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.
');
2008: End If;
2009: statusStr := 'SUCCESS';

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

2003: sqltxt :=sqltxt||' order by mie.organization_id,mie.transaction_id, mie.unique_id ';
2004:
2005: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Records in mtl_interface_errors table ');
2006: If (num_rows = row_limit -1 ) Then
2007: 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.
');
2008: End If;
2009: statusStr := 'SUCCESS';
2010: isFatal := 'FALSE';
2011:

Line 2015: JTF_DIAGNOSTIC_COREAPI.Line_Out('

This data collection script completed as expected
');

2011:
2012: /* End of mtl_interface_errors table.*/
2013:
2014: <>
2015: JTF_DIAGNOSTIC_COREAPI.Line_Out('

This data collection script completed as expected
');
2016: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
2017: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
2018: End If; /* l_type is valid */
2019:

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

2018: End If; /* l_type is valid */
2019:
2020: EXCEPTION
2021: when others then
2022: JTF_DIAGNOSTIC_COREAPI.errorprint('Error: '||sqlerrm);
2023: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('If this error repeats, please contact Oracle Support Services');
2024: statusStr := 'FAILURE';
2025: errStr := sqlerrm ||' occurred in script. ';
2026: fixInfo := 'Unexpected Exception in BOMDGINB.pls';

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

2019:
2020: EXCEPTION
2021: when others then
2022: JTF_DIAGNOSTIC_COREAPI.errorprint('Error: '||sqlerrm);
2023: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('If this error repeats, please contact Oracle Support Services');
2024: statusStr := 'FAILURE';
2025: errStr := sqlerrm ||' occurred in script. ';
2026: fixInfo := 'Unexpected Exception in BOMDGINB.pls';
2027: isFatal := 'FALSE';