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_MMTT dependencies on JTF_DIAGNOSTIC_COREAPI

Line 37: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;

33:
34: BEGIN
35: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
36: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
37: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
38: -- accept input
39: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrgId',inputs);
40: l_acct_period :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('AcctPeriod',inputs);
41: l_proc_flag :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('ErrorFlag',inputs);

Line 69: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Invalid Input Parameters. ');

65: WHERE organization_id = l_org_id
66: AND period_name = l_acct_period;
67: exception
68: when others then
69: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Invalid Input Parameters. ');
70: errStr := 'Invalid Account period '||SQLCODE||' '||substrb(sqlerrm,1,1000);
71: fixInfo := 'Enter a valid account period';
72: statusStr := 'FAILURE';
73: isFatal := 'SUCCESS';

Line 79: JTF_DIAGNOSTIC_COREAPI.BRPrint;

75: end;
76: end if;
77:
78: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('OrgID input :'||l_org_id||' Account Period: '||l_acct_period||'('||l_acct_period_id||')');
79: JTF_DIAGNOSTIC_COREAPI.BRPrint;
80:
81: sqltxt := 'SELECT fa.application_name "Application Name" '||
82: ' , fa.application_short_name "Application|Shortname" '||
83: ' , fcp.concurrent_processor_name "Name" '||

Line 99: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Concurrent Managers related to Inventory');

95: 'ORDER BY fcp.application_id DESC '||
96: ', fcp.concurrent_processor_id '||
97: ', fcp.concurrent_processor_name';
98:
99: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Concurrent Managers related to Inventory');
100: statusStr := 'SUCCESS';
101: isFatal := 'FALSE';
102:
103:

Line 131: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Period Information ');

127: end if;
128:
129: sqltxt := sqltxt||' ORDER BY mp.organization_code, oap.acct_period_id ';
130:
131: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Period Information ');
132: statusStr := 'SUCCESS';
133: isFatal := 'FALSE';
134:
135: sqltxt := 'SELECT ';

Line 219: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Pending Material Transactions '||reportStr);

215: if l_proc_flag is not null then
216: sqltxt := sqltxt||' AND process_flag= '''||l_proc_flag||''' ';
217: end if;
218:
219: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Pending Material Transactions '||reportStr);
220: statusStr := 'SUCCESS';
221: isFatal := 'FALSE';
222:
223:

Line 250: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Pending Txns with Transaction or Primary Quantity Below Minimum'||reportStr);

246: end if;
247:
248: sqltxt :=sqltxt||' ORDER BY transaction_temp_id';
249:
250: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Pending Txns with Transaction or Primary Quantity Below Minimum'||reportStr);
251: statusStr := 'SUCCESS';
252: isFatal := 'FALSE';
253:
254: sqltxt := 'SELECT mmtt.transaction_temp_id "Txn|Temp Id" '||

Line 273: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Items with Trailing Spaces in Description'||reportStr);

269: if l_proc_flag is not null then
270: sqltxt := sqltxt||' AND process_flag= '''||l_proc_flag||''' ';
271: end if;
272:
273: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Items with Trailing Spaces in Description'||reportStr);
274: statusStr := 'SUCCESS';
275: isFatal := 'FALSE';
276:
277: sqltxt := 'SELECT mif.item_number "Item" '||

Line 323: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'On-hand Quantities of Items Associated with Pending Txns in MMTT'||reportStr);

319: ' , moq.subinventory_code, moq.locator_id '||
320: ' , mil.concatenated_segments, mil.description '||
321: ' , moq.revision, moq.lot_number';
322:
323: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'On-hand Quantities of Items Associated with Pending Txns in MMTT'||reportStr);
324: statusStr := 'SUCCESS';
325: isFatal := 'FALSE';
326:
327: sqltxt := 'SELECT DISTINCT( msi.secondary_inventory_name ) "Name" '||

Line 377: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Subinventories Associated with Pending Txns in MMTT'||reportStr);

373: end if;
374: sqltxt := sqltxt||' ) '||
375: ' ORDER BY secondary_inventory_name';
376:
377: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Subinventories Associated with Pending Txns in MMTT'||reportStr);
378: statusStr := 'SUCCESS';
379: isFatal := 'FALSE';
380:
381: sqltxt := 'SELECT mp.organization_code "Organization|Code" '||

Line 407: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Over view of All Pending Material Transactions');

403: ' , mmtt.process_flag, mmtt.lock_flag '||
404: 'ORDER BY mp.organization_code, mmtt.organization_id '||
405: ' , mmtt.acct_period_id, mmtt.process_flag';
406:
407: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Over view of All Pending Material Transactions');
408: statusStr := 'SUCCESS';
409: isFatal := 'FALSE';
410:
411: sqltxt :='SELECT process_flag "Process Flag" '||

Line 425: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Distinct process_flag for All Pending Txns'||reportStr);

421: end if;
422: sqltxt := sqltxt||'GROUP BY process_flag '||
423: 'ORDER BY process_flag ';
424:
425: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Distinct process_flag for All Pending Txns'||reportStr);
426: statusStr := 'SUCCESS';
427: isFatal := 'FALSE';
428:
429:

Line 444: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Distinct lock_flag for All Pending Txns'||reportStr);

440:
441: sqltxt := sqltxt||'GROUP BY lock_flag '||
442: 'ORDER BY lock_flag ';
443:
444: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Distinct lock_flag for All Pending Txns'||reportStr);
445: statusStr := 'SUCCESS';
446: isFatal := 'FALSE';
447:
448: sqltxt := 'SELECT process_flag "Process Flag" '||

Line 469: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Distinct process_flag, transaction_status for All Pending Txns'||reportStr);

465:
466: sqltxt := sqltxt||'GROUP BY process_flag, transaction_status '||
467: 'ORDER BY process_flag, transaction_status ';
468:
469: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Distinct process_flag, transaction_status for All Pending Txns'||reportStr);
470: statusStr := 'SUCCESS';
471: isFatal := 'FALSE';
472:
473: sqltxt := 'SELECT process_flag "Process Flag" '||

Line 491: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Distinct process_flag, transaction_mode for All Pending Txns');

487: end if;
488: sqltxt := sqltxt||'GROUP BY process_flag, ml.meaning, mmtt.transaction_mode '||
489: 'ORDER BY process_flag, ml.meaning, mmtt.transaction_mode ';
490:
491: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Distinct process_flag, transaction_mode for All Pending Txns');
492: statusStr := 'SUCCESS';
493: isFatal := 'FALSE';
494:
495:

Line 529: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Distinct process_flag, transaction_type for All Pending Txns'||reportStr);

525: ' ||'' ( ''||mmtt.transaction_type_id||'' )'' '||
526: ' , ml.meaning '||
527: ' ||'' ( ''||mmtt.transaction_action_id||'' )'' ';
528:
529: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Distinct process_flag, transaction_type for All Pending Txns'||reportStr);
530: statusStr := 'SUCCESS';
531: isFatal := 'FALSE';
532:
533: sqltxt := 'SELECT COUNT(*) '||

Line 548: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Number of Pending txns that refer to a serial-controlled item'||reportStr);

544: if l_acct_period_id is not null then
545: sqltxt := sqltxt||' and mmtt.acct_period_id = '||l_acct_period_id;
546: end if;
547:
548: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Number of Pending txns that refer to a serial-controlled item'||reportStr);
549: statusStr := 'SUCCESS';
550: isFatal := 'FALSE';
551:
552: sqltxt := 'SELECT mmtt.transaction_temp_id "Txn|Temp Id" '||

Line 585: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Serial Number Information from Table MSNT');

581: sqltxt := sqltxt||' and mmtt.acct_period_id = '||l_acct_period_id;
582: end if;
583: sqltxt := sqltxt||' AND mmtt.transaction_temp_id = msnt.transaction_temp_id'||
584: ' ORDER BY mmtt.transaction_temp_id';
585: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Serial Number Information from Table MSNT');
586: statusStr := 'SUCCESS';
587: isFatal := 'FALSE';
588:
589: sqltxt := 'SELECT mif.item_number '||

Line 631: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Serial Number Information from MSN for Pending Txns'||reportStr);

627: end if;
628:
629: sqltxt := sqltxt|| ') ORDER BY mif.item_number, msn.serial_number';
630:
631: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Serial Number Information from MSN for Pending Txns'||reportStr);
632: statusStr := 'SUCCESS';
633: isFatal := 'FALSE';
634:
635: sqltxt := 'SELECT COUNT(*) '||

Line 649: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Number of Pending txns that refer to a lot-controlled item'||reportStr );

645: if l_acct_period_id is not null then
646: sqltxt := sqltxt||' and mmtt.acct_period_id = '||l_acct_period_id;
647: end if;
648:
649: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Number of Pending txns that refer to a lot-controlled item'||reportStr );
650: statusStr := 'SUCCESS';
651: isFatal := 'FALSE';
652:
653: sqltxt := 'SELECT mmtt.transaction_temp_id "Txn|Temp Id" '||

Line 680: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Lot Information from MTLT for Pending Txns'||reportStr);

676: sqltxt := sqltxt||' AND mmtt.process_flag= '''||l_proc_flag||''' ';
677: end if;
678: sqltxt := sqltxt||' ORDER BY mmtt.transaction_temp_id';
679:
680: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Lot Information from MTLT for Pending Txns'||reportStr);
681: statusStr := 'SUCCESS';
682: isFatal := 'FALSE';
683:
684: sqltxt := 'SELECT COUNT(*) '||

Line 698: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Number of Pending txns that refer to a revision-controlled item'||reportStr );

694: if l_acct_period_id is not null then
695: sqltxt := sqltxt||' and mmtt.acct_period_id = '||l_acct_period_id;
696: end if;
697:
698: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Number of Pending txns that refer to a revision-controlled item'||reportStr );
699: statusStr := 'SUCCESS';
700: isFatal := 'FALSE';
701:
702: sqltxt := 'SELECT mif.item_number "Item|Number" '||

Line 735: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Revision Information for Pending Txns'||reportStr);

731:
732: sqltxt := sqltxt||') '||
733: ' ORDER BY mif.item_number, mir.revision';
734:
735: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Revision Information for Pending Txns'||reportStr);
736: statusStr := 'SUCCESS';
737: isFatal := 'FALSE';
738:
739: sqltxt := 'SELECT DISTINCT mif.item_number "Item Number" '||

Line 787: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Item Associated with Pending Txns in MMTT'||reportStr);

783: end if;
784:
785: sqltxt := sqltxt||' ORDER BY mif.item_number';
786:
787: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Item Associated with Pending Txns in MMTT'||reportStr);
788: statusStr := 'SUCCESS';
789: isFatal := 'FALSE';
790:
791: sqltxt := 'SELECT process_flag "Process Flag" '||

Line 812: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Distinct Types of Errors in MMTT');

808:
809: sqltxt := sqltxt||'GROUP BY process_flag, error_code, error_explanation '||
810: ' ORDER BY process_flag ';
811:
812: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Distinct Types of Errors in MMTT');
813: statusStr := 'SUCCESS';
814: isFatal := 'FALSE';
815:
816:

Line 819: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Invalid Input parameters');

815:
816:
817: /**
818: else
819: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Invalid Input parameters');
820: statusStr := 'FAILURE';
821: errStr := 'org_id null';
822: fixInfo := 'Org or OrdID input is required ';
823: isFatal := 'SUCCESS';