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.WIP_DIAG_WOL_FLOW dependencies on JTF_DIAGNOSTIC_ADAPTUTIL

Line 19: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;

15: row_limit NUMBER;
16: l_org_id NUMBER;
17: where_clause VARCHAR2(4000) := NULL; -- where clause
18: BEGIN
19: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
20: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
21: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
22: row_limit := 1000;
23: -- accept input

Line 20: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');

16: l_org_id NUMBER;
17: where_clause VARCHAR2(4000) := NULL; -- where clause
18: BEGIN
19: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
20: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
21: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
22: row_limit := 1000;
23: -- accept input
24: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrganizationId',inputs);

Line 24: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrganizationId',inputs);

20: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
21: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
22: row_limit := 1000;
23: -- accept input
24: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrganizationId',inputs);
25:
26: If l_org_id is not null then
27: where_clause := ' and organization_id = ' || l_org_id || ' ';
28: reportStr := ' Organization Id = ' || l_org_id || '
';

Line 29: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);

25:
26: If l_org_id is not null then
27: where_clause := ' and organization_id = ' || l_org_id || ' ';
28: reportStr := ' Organization Id = ' || l_org_id || '
';
29: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
30: end if;
31: sqltxt :=
32: 'select '||
33: ' mmt1.transaction_source_id, '||

Line 387: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);

383: isFatal := 'FALSE';
384: fixInfo := 'OK';
385: errStr :='No Error!';
386: <>
387: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
388: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
389:
390: END Uncosted_mat_txn_wol;
391:

Line 388: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

384: fixInfo := 'OK';
385: errStr :='No Error!';
386: <>
387: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
388: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
389:
390: END Uncosted_mat_txn_wol;
391:
392: PROCEDURE Pending_res_txn_wol(inputs IN JTF_DIAG_INPUTTBL,

Line 407: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;

403: row_limit NUMBER;
404: l_org_id NUMBER;
405: where_clause VARCHAR2(4000) := NULL; -- where clause
406: BEGIN
407: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
408: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
409: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
410: -- accept input
411: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrganizationId',inputs);

Line 408: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');

404: l_org_id NUMBER;
405: where_clause VARCHAR2(4000) := NULL; -- where clause
406: BEGIN
407: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
408: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
409: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
410: -- accept input
411: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrganizationId',inputs);
412:

Line 411: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrganizationId',inputs);

407: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
408: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
409: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
410: -- accept input
411: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrganizationId',inputs);
412:
413: If l_org_id is not null then
414: where_clause := ' and organization_id = ' || l_org_id || ' ';
415: reportStr := ' Organization Id = ' || l_org_id || '
';

Line 416: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);

412:
413: If l_org_id is not null then
414: where_clause := ' and organization_id = ' || l_org_id || ' ';
415: reportStr := ' Organization Id = ' || l_org_id || '
';
416: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
417: end if;
418:
419: sqltxt :=
420: 'select wip_entity_id, '||

Line 507: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);

503: fixInfo := 'OK';
504: errStr :='No Error!';
505:
506: <>
507: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
508: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
509:
510: END Pending_res_txn_wol;
511:

Line 508: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

504: errStr :='No Error!';
505:
506: <>
507: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
508: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
509:
510: END Pending_res_txn_wol;
511:
512: PROCEDURE Invalid_txn_mti_wol(inputs IN JTF_DIAG_INPUTTBL,

Line 528: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;

524: l_item_id NUMBER;
525: l_org_id NUMBER;
526: where_clause VARCHAR2(4000) := NULL; -- where clause
527: BEGIN
528: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
529: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
530: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
531: -- accept input
532: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrganizationId',inputs);

Line 529: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');

525: l_org_id NUMBER;
526: where_clause VARCHAR2(4000) := NULL; -- where clause
527: BEGIN
528: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
529: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
530: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
531: -- accept input
532: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrganizationId',inputs);
533:

Line 532: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrganizationId',inputs);

528: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
529: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
530: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
531: -- accept input
532: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrganizationId',inputs);
533:
534: If l_org_id is not null then
535: where_clause := ' and organization_id = ' || l_org_id || ' ';
536: reportStr := ' Organization Id = ' || l_org_id || '
';

Line 537: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);

533:
534: If l_org_id is not null then
535: where_clause := ' and organization_id = ' || l_org_id || ' ';
536: reportStr := ' Organization Id = ' || l_org_id || '
';
537: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
538: end if;
539:
540: /* Bug 5731956: Added if condition to check existence of column COMPLETION_TRANSACTION_ID*/
541: if JTF_DIAGNOSTIC_COREAPI.Column_Exists('MTL_TRANSACTIONS_INTERFACE','COMPLETION_TRANSACTION_ID', 'INV') = 'Y' then

Line 647: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);

643: errStr :='No Error!';
644:
645:
646: <>
647: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
648: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
649:
650: END Invalid_txn_mti_wol;
651:

Line 648: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

644:
645:
646: <>
647: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
648: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
649:
650: END Invalid_txn_mti_wol;
651:
652: PROCEDURE Dup_mat_txn_mti(inputs IN JTF_DIAG_INPUTTBL,

Line 667: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;

663: row_limit NUMBER;
664: l_org_id NUMBER;
665: where_clause VARCHAR2(4000) := NULL; -- where clause
666: BEGIN
667: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
668: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
669: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
670: row_limit := 1000;
671: -- accept input

Line 668: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');

664: l_org_id NUMBER;
665: where_clause VARCHAR2(4000) := NULL; -- where clause
666: BEGIN
667: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
668: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
669: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
670: row_limit := 1000;
671: -- accept input
672: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrganizationId',inputs);

Line 672: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrganizationId',inputs);

668: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
669: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
670: row_limit := 1000;
671: -- accept input
672: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrganizationId',inputs);
673:
674: If l_org_id is not null then
675: where_clause := ' and organization_id = ' || l_org_id || ' ';
676: reportStr := ' Organization Id = ' || l_org_id || '
';

Line 677: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);

673:
674: If l_org_id is not null then
675: where_clause := ' and organization_id = ' || l_org_id || ' ';
676: reportStr := ' Organization Id = ' || l_org_id || '
';
677: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
678: end if;
679:
680: sqltxt :=
681: 'SELECT organization_id, '||

Line 727: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);

723: errStr :='No Error!';
724:
725:
726: <>
727: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
728: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
729:
730: END Dup_mat_txn_mti;
731:

Line 728: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

724:
725:
726: <>
727: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
728: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
729:
730: END Dup_mat_txn_mti;
731:
732: END;