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

Line 35: dummy_v2t JTF_DIAGNOSTIC_COREAPI.v2t;

31: report OUT NOCOPY JTF_DIAG_REPORT,
32: reportClob OUT NOCOPY CLOB) IS
33: reportStr LONG;
34: counter NUMBER;
35: dummy_v2t JTF_DIAGNOSTIC_COREAPI.v2t;
36: c_userid VARCHAR2(50);
37: statusStr VARCHAR2(50);
38: errStr VARCHAR2(4000);
39: fixInfo VARCHAR2(4000);

Line 58: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;

54:
55: BEGIN
56: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
57: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
58: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
59:
60: l_phy_inv_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('PhyInvId',inputs);
61: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrgId',inputs);
62: l_count := 0;

Line 87: dummy_num := JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Version of Inventory Key Packages');

83: ' ''INV_TRX_MGR'', ' ||
84: ' ''INV_UI_ITEM_SUB_LOC_LOVS'' ) ' ||
85: ' ORDER BY o.name, o.type# ';
86:
87: dummy_num := JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Version of Inventory Key Packages');
88:
89: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,'
Important Notes Releated to Physical Inventory');
90: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,'
Note , 131795.1, : Inventory Product Information > Physical Inventory ');
91: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,'
Note , 69125.1, : Latest Inventory news ');

Line 110: JTF_DIAGNOSTIC_COREAPI.errorprint('Error: '|| 'Invalid Physical Inventory Item and Organization Combination');

106: END IF;
107:
108: IF l_count IS NULL OR l_count <> 1 THEN
109: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,'Please execute the report with organization and physical inventory information');
110: JTF_DIAGNOSTIC_COREAPI.errorprint('Error: '|| 'Invalid Physical Inventory Item and Organization Combination');
111: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please enter correct physical inventory and organization ids');
112: statusStr := 'FAILURE';
113: errStr := 'Invalid Physical Inventory Item and Organization Combination';
114: fixInfo := 'Please enter right combination of Physical Inventory Item and Organization';

Line 111: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please enter correct physical inventory and organization ids');

107:
108: IF l_count IS NULL OR l_count <> 1 THEN
109: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,'Please execute the report with organization and physical inventory information');
110: JTF_DIAGNOSTIC_COREAPI.errorprint('Error: '|| 'Invalid Physical Inventory Item and Organization Combination');
111: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please enter correct physical inventory and organization ids');
112: statusStr := 'FAILURE';
113: errStr := 'Invalid Physical Inventory Item and Organization Combination';
114: fixInfo := 'Please enter right combination of Physical Inventory Item and Organization';
115: isFatal := 'FALSE';

Line 153: dummy_num := JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Onhand information');

149: ' ,moq.transaction_uom_code, moq.subinventory_code, moq.locator_id ' ||
150: ' ,mil.concatenated_segments, mil.description ' ||
151: ' ,moq.revision, moq.lot_number ';
152:
153: dummy_num := JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Onhand information');
154:
155: sqltxt := ' SELECT mpa.organization_id ' ||
156: ' , mpa.physical_inventory_id ' ||
157: ' , mpa.adjustment_id ' ||

Line 179: dummy_num := JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'MPA records for serial controlled items without serial numbers');

175: ' AND mpa.serial_number IS NULL ' ||
176: ' AND ( mpa.approval_status = 1 OR mpa.approval_status IS NULL ) ' ||
177: ' ORDER BY mpa.organization_id, mpa.physical_inventory_id, mpa.adjustment_id ';
178:
179: dummy_num := JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'MPA records for serial controlled items without serial numbers');
180:
181: sqltxt := ' SELECT mpa.* ' ||
182: ' FROM mtl_physical_adjustments mpa ' ||
183: ' WHERE mpa.organization_id = ' || l_org_id ||

Line 195: dummy_num := JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'MPA records with invalid locator_id in onhand');

191: ' AND mil.subinventory_code = mpa.subinventory_name ' ||
192: ' AND mil.inventory_location_id = mpa.locator_id ) ' ||
193: ' ORDER BY mpa.adjustment_id ';
194:
195: dummy_num := JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'MPA records with invalid locator_id in onhand');
196:
197: sqltxt := ' SELECT mpa.organization_id ' ||
198: ' , mpa.physical_inventory_id ' ||
199: ' , mpa.adjustment_id ' ||

Line 221: dummy_num := JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'MPA records of lot controlled item without lot number');

217: ' AND mpa.lot_number IS NULL ' ||
218: ' AND ( mpa.approval_status = 1 OR mpa.approval_status IS NULL ) ' ||
219: ' ORDER BY mpa.organization_id, mpa.physical_inventory_id, mpa.adjustment_id ';
220:
221: dummy_num := JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'MPA records of lot controlled item without lot number');
222:
223: sqltxt := ' SELECT physical_adjustment_id ' ||
224: ' , inventory_item_id ' ||
225: ' , subinventory_code ' ||

Line 240: dummy_num := JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Duplicate Physical Adjustment transactions');

236: ' AND transaction_type_id = 8 ' ||
237: ' GROUP BY physical_adjustment_id ' ||
238: ' HAVING COUNT(*) > 1 ) ';
239:
240: dummy_num := JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Duplicate Physical Adjustment transactions');
241:
242: sqltxt := ' SELECT physical_adjustment_id ' ||
243: ' , inventory_item_id ' ||
244: ' , subinventory_code ' ||

Line 263: dummy_num := JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Duplicate Pending Physical Adjustment transactions');

259: ' AND transaction_type_id = 8 ' ||
260: ' GROUP BY physical_adjustment_id ' ||
261: ' HAVING COUNT(*) > 1 ) ';
262:
263: dummy_num := JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Duplicate Pending Physical Adjustment transactions');
264:
265: sqltxt := ' SELECT physical_adjustment_id ' ||
266: ' , transaction_source_id ' ||
267: ' , inventory_item_id ' ||

Line 288: dummy_num := JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Pending Physical Adjustment transactions duplicate of completed transaction');

284: ' AND mmt.physical_adjustment_id = mmtt.physical_adjustment_id ' ||
285: ' AND mmt.transaction_source_id = mmtt.transaction_source_id ' ||
286: ' AND mmt.transaction_action_id = mmtt.transaction_action_id ) ';
287:
288: dummy_num := JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Pending Physical Adjustment transactions duplicate of completed transaction');
289:
290: sqltxt := ' SELECT mpa.adjustment_id, mpa.physical_inventory_id ' ||
291: ' , mpa.inventory_item_id, mpa.organization_id, mpa.count_quantity ' ||
292: ' , SUM( mpit.tag_quantity_at_standard_uom ) total_tag ' ||

Line 305: dummy_num := JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Mismatch between MPA count and Standard UOM count');

301: ' GROUP BY mpa.adjustment_id, mpa.physical_inventory_id ' ||
302: ' , mpa.inventory_item_id, mpa.organization_id, mpa.count_quantity ' ||
303: ' HAVING count_quantity <> SUM( mpit.tag_quantity_at_standard_uom ) ';
304:
305: dummy_num := JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Mismatch between MPA count and Standard UOM count');
306:
307: sqltxt := ' SELECT mpi.physical_inventory_name ' ||
308: ' , mpi.description ' ||
309: ' , mpi.physical_inventory_date ' ||

Line 333: dummy_num := JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Physical inventory information');

329: ' AND mpi.physical_inventory_id = ' || l_phy_inv_id ||
330: ' AND mpi.approval_required = ml.lookup_code(+) ' ||
331: ' AND ml.lookup_type = ''MTL_APPROVAL_REQ'' ';
332:
333: dummy_num := JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Physical inventory information');
334:
335: sqltxt := ' SELECT mpit.tag_number ' ||
336: ' ,mpit.tag_id ' ||
337: ' ,mpit.void_flag ' ||

Line 360: dummy_num := JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Physical inventory tag information');

356: ' AND mpit.physical_inventory_id = ' || l_phy_inv_id ||
357: ' ORDER BY mpit.tag_number ' ||
358: ' ';
359:
360: dummy_num := JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Physical inventory tag information');
361:
362: sqltxt := ' SELECT DECODE( approval_status, 1, ''Approved'' ' ||
363: ' , 2, ''Rejected'' ' ||
364: ' , 3, ''Posted'' ' ||

Line 374: dummy_num := JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Count of distinct adjustment approval_status');

370: ' AND physical_inventory_id = ' || l_phy_inv_id ||
371: ' GROUP BY approval_status ' ||
372: ' ORDER BY approval_status ';
373:
374: dummy_num := JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Count of distinct adjustment approval_status');
375:
376: sqltxt := ' SELECT mmt.transaction_id ' ||
377: ' ,mmt.costed_flag ' ||
378: ' ,mmt.last_update_date ' ||

Line 390: dummy_num := JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Adjustment transaction information');

386: ' AND mmt.transaction_type_id = 8 ' ||
387: ' ORDER BY mmt.transaction_id ' ||
388: ' ';
389:
390: dummy_num := JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Adjustment transaction information');
391:
392: sqltxt := ' SELECT mpa.adjustment_id ' ||
393: ' ,mpa.approval_status ' ||
394: ' ,mpa.inventory_item_id ' ||

Line 417: dummy_num := JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Adjustment information');

413: ' AND mpa.physical_inventory_id = ' || l_phy_inv_id ||
414: ' ORDER BY mpa.adjustment_id ' ||
415: ' ';
416:
417: dummy_num := JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Adjustment information');
418:
419: sqltxt := ' SELECT mmtt.transaction_temp_id "Txn|Temp Id" ' ||
420: ' , transaction_header_id "Txn|Header Id" ' ||
421: ' , mmtt.source_code "Source Code" ' ||

Line 463: dummy_num := JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Pending Adjustment transactions');

459: ' AND mmtt.transaction_action_id = ml.lookup_code ' ||
460: ' AND ml.lookup_type = ''MTL_TRANSACTION_ACTION'' ' ||
461: ' ORDER BY mmtt.transaction_temp_id, transaction_header_id ';
462:
463: dummy_num := JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Pending Adjustment transactions');
464:
465: sqltxt := ' SELECT transaction_temp_id "Txn|Temp Id" ' ||
466: ' , transaction_header_id "Txn|Header Id" ' ||
467: ' , source_code "Source|Code" ' ||

Line 512: dummy_num := JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Pending Non Physical Inventory Transactions');

508: ' AND mps.physical_inventory_id = ' || l_phy_inv_id || ' ) ' ||
509: ' ORDER BY transaction_temp_id, transaction_header_id ' ||
510: ' ';
511:
512: dummy_num := JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Pending Non Physical Inventory Transactions');
513:
514: sqltxt := ' SELECT transaction_header_id "Txn|Header Id" ' ||
515: ' , mti.transaction_interface_id "Txn IntFace|Id" ' ||
516: ' , mif.item_number ||'' (''|| mti.inventory_item_id ||'')'' "Item (Id)" ' ||

Line 559: dummy_num := JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Inventory Interface Transactions');

555: ' AND mps.physical_inventory_id = ' || l_phy_inv_id || ') ' ||
556: ' ORDER BY transaction_header_id, mti.transaction_interface_id ' ||
557: ' ';
558:
559: dummy_num := JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Inventory Interface Transactions');
560:
561: sqltxt := ' SELECT COUNT(*) "Count" ' ||
562: ' , transaction_type_name ||'' ( ''||transaction_type_id||'' )'' "Txn Type (Id)" ' ||
563: ' FROM mtl_transactions_interface_v mti ' ||

Line 568: dummy_num := JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Interfaced Types of Transactions');

564: ' WHERE organization_id = ' || l_org_id ||
565: ' GROUP BY transaction_type_name, transaction_type_id ' ||
566: ' ORDER BY COUNT(*) DESC, transaction_type_name, transaction_type_id ';
567:
568: dummy_num := JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Interfaced Types of Transactions');
569:
570: sqltxt := ' SELECT COUNT(*) ' ||
571: ' FROM mtl_physical_adjustments ' ||
572: ' WHERE organization_id = ' || l_org_id ||

Line 577: dummy_num := JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Total number of unprocessed adjustments');

573: ' AND physical_inventory_id = ' || l_phy_inv_id ||
574: ' AND adjustment_quantity <> 0 ' ||
575: ' AND ( approval_status NOT IN (2, 3) OR approval_status IS NULL ) ';
576:
577: dummy_num := JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Total number of unprocessed adjustments');
578:
579: sqltxt := ' SELECT COUNT(*) ' ||
580: ' FROM mtl_material_transactions ' ||
581: ' WHERE organization_id = ' || l_org_id ||

Line 585: dummy_num := JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Total number of processed adjustments');

581: ' WHERE organization_id = ' || l_org_id ||
582: ' AND transaction_source_id = ' || l_phy_inv_id ||
583: ' AND transaction_type_id = 8 ';
584:
585: dummy_num := JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Total number of processed adjustments');
586:
587: sqltxt := ' SELECT DISTINCT mif.item_number "Item Number" ' ||
588: ' ,mmtt.inventory_item_id "Item Id" ' ||
589: ' ,primary_uom_code "Primary|UoM" ' ||

Line 631: dummy_num := JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Pending adjustment item information');

627: ' AND mif.serial_number_control_code = ml.lookup_code(+) ' ||
628: ' AND ''MTL_SERIAL_NUMBER'' = ml.lookup_type(+) ' ||
629: ' ORDER BY mif.item_number ';
630:
631: dummy_num := JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Pending adjustment item information');
632:
633: sqltxt := ' SELECT subinventory ' ||
634: ' FROM mtl_physical_subinventories ' ||
635: ' WHERE organization_id = ' || l_org_id ||

Line 639: dummy_num := JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Physical Inventory Subinventories');

635: ' WHERE organization_id = ' || l_org_id ||
636: ' AND physical_inventory_id = ' || l_phy_inv_id ||
637: ' ORDER BY subinventory ';
638:
639: dummy_num := JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Physical Inventory Subinventories');
640:
641: sqltxt := ' SELECT msi.* ' ||
642: ' FROM mtl_secondary_inventories msi ' ||
643: ' WHERE msi.organization_id = ' || l_org_id ||

Line 646: dummy_num := JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Organization Subinventories');

642: ' FROM mtl_secondary_inventories msi ' ||
643: ' WHERE msi.organization_id = ' || l_org_id ||
644: ' ORDER BY msi.secondary_inventory_name ';
645:
646: dummy_num := JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Organization Subinventories');
647:
648: sqltxt := ' SELECT msi.* ' ||
649: ' FROM mtl_secondary_inventories msi ' ||
650: ' WHERE ( msi.secondary_inventory_name, msi.organization_id ) IN ' ||

Line 657: dummy_num := JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Subinventories restricted to physical inventory');

653: ' WHERE mps.organization_id = ' || l_org_id ||
654: ' AND mps.physical_inventory_id = ' || l_phy_inv_id || ' ) ' ||
655: ' ORDER BY msi.secondary_inventory_name ';
656:
657: dummy_num := JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Subinventories restricted to physical inventory');
658:
659: reportStr := 'The test completed as expected';
660: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
661: statusStr := 'SUCCESS';

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

663: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
664:
665: EXCEPTION
666: WHEN OTHERS THEN
667: JTF_DIAGNOSTIC_COREAPI.errorprint('Error: '||sqlerrm);
668: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('This is the exception handler');
669: statusStr := 'FAILURE';
670: errStr := sqlerrm ||' occurred in script Exception handled';
671: fixInfo := 'Unexpected Exception in INVDA06B.pls';

Line 668: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('This is the exception handler');

664:
665: EXCEPTION
666: WHEN OTHERS THEN
667: JTF_DIAGNOSTIC_COREAPI.errorprint('Error: '||sqlerrm);
668: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('This is the exception handler');
669: statusStr := 'FAILURE';
670: errStr := sqlerrm ||' occurred in script Exception handled';
671: fixInfo := 'Unexpected Exception in INVDA06B.pls';
672: isFatal := 'FALSE';