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_ITMHLCHK dependencies on JTF_DIAGNOSTIC_ADAPTUTIL

Line 65: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;

61: and owner = l_owner
62: and UNIQUENESS = 'UNIQUE';
63:
64: BEGIN
65: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
66: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
67: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
68:
69: /* Set Row Limit to 1000 (i.e.) Max Number of records to be fetched by each sql*/

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

62: and UNIQUENESS = 'UNIQUE';
63:
64: BEGIN
65: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
66: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
67: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
68:
69: /* Set Row Limit to 1000 (i.e.) Max Number of records to be fetched by each sql*/
70: row_limit :=1000;

Line 74: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrgId',inputs);

70: row_limit :=1000;
71: l_org_exists :=0; /* Initialize to zero */
72:
73: -- accept input
74: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrgId',inputs);
75: l_script := nvl(upper(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Script',inputs)),'ALL');
76:
77: -- JTF_DIAGNOSTIC_COREAPI.Line_Out('
Script Selected: '||l_script);
78:

Line 75: l_script := nvl(upper(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Script',inputs)),'ALL');

71: l_org_exists :=0; /* Initialize to zero */
72:
73: -- accept input
74: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrgId',inputs);
75: l_script := nvl(upper(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Script',inputs)),'ALL');
76:
77: -- JTF_DIAGNOSTIC_COREAPI.Line_Out('
Script Selected: '||l_script);
78:
79:

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

90: isFatal := 'TRUE';
91: fixInfo := ' Please review the error message below and take corrective action.';
92: errStr := ' Invalid value for input field Script ';
93:
94: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
95: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
96: Return;
97: End If;
98: /* End of script name validation*/

Line 95: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

91: fixInfo := ' Please review the error message below and take corrective action.';
92: errStr := ' Invalid value for input field Script ';
93:
94: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
95: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
96: Return;
97: End If;
98: /* End of script name validation*/
99:

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

114: isFatal := 'TRUE';
115: fixInfo := ' Please review the error message below and take corrective action. ';
116: errStr := ' Invalid value for input field Organization Id ';
117:
118: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
119: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
120: End;
121: End If; /* End of l_org_id is not null */
122:

Line 119: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

115: fixInfo := ' Please review the error message below and take corrective action. ';
116: errStr := ' Invalid value for input field Organization Id ';
117:
118: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
119: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
120: End;
121: End If; /* End of l_org_id is not null */
122:
123: If (l_org_id is null) or (l_org_exists = 1) Then

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

190: and inventory_item_id = :itemid;
191:
192:
Use ''Delete Items'' form to delete the renamed item.
193:
';
194: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
195: End If; /* End of Impact and Action */
196:
197: statusStr := 'SUCCESS';
198: isFatal := 'FALSE';

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

437:
For details on Item Import, please refer to
438:
''Oracle Manufacturing APIs and Open Interfaces Manual'' (Part No. A95955-03),
439:
Chapter 7 - ''Oracle Inventory Open Interfaces and APIs'', Section ''Open Item Interface''.
440:
';
441: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
442: End If; /* End of Impact and Action */
443:
444: statusStr := 'SUCCESS';
445: isFatal := 'FALSE';

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

553:
''Oracle Manufacturing APIs and Open Interfaces Manual'' (Part No. A95955-03),
554:
Chapter 7 - ''Oracle Inventory Open Interfaces and APIs'', Section ''Open Item Interface''.
555:
';
556:
557: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
558: End If; /* End of Impact and Action */
559:
560: statusStr := 'SUCCESS';
561: isFatal := 'FALSE';

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

617:
For details on Item Import, please refer to
618:
''Oracle Manufacturing APIs and Open Interfaces Manual'' (Part No. A95955-03),
619:
Chapter 7 - ''Oracle Inventory Open Interfaces and APIs'', Section ''Open Item Interface''.
620:
';
621: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
622: End If; /* End of Impact and Action */
623:
624: statusStr := 'SUCCESS';
625: isFatal := 'FALSE';

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

677:
5) Click on this field and tab out without entering any value for it.
678:
This will clear the buyer_id column.
679:
6) Save the changes to the form.
680:
';
681: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
682:
683:
684: /*

Note: If the number of items to be corrected are huge, then use Item Import in UPDATE mode to null out the buyer_id column.
685:
For nulling out numeric attributes through IOI the value -999999 has to be populated for the corresponding column in the interface record.

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

748:
For details on Item Import, please refer to
749:
''Oracle Manufacturing APIs and Open Interfaces Manual'' (Part No. A95955-03),
750:
Chapter 7 - ''Oracle Inventory Open Interfaces and APIs'', Section ''Open Item Interface''.
751:
';
752: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
753:
754:
755: End If; /* End of Impact and Action */
756:

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

840:
For details on Item Import, please refer to
841:
''Oracle Manufacturing APIs and Open Interfaces Manual'' (Part No. A95955-03),
842:
Chapter 7 - ''Oracle Inventory Open Interfaces and APIs'', Section ''Open Item Interface''.
843:
';
844: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
845: End If; /* End of Impact and Action */
846:
847: statusStr := 'SUCCESS';
848: isFatal := 'FALSE';

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

945:
''Oracle Manufacturing APIs and Open Interfaces Manual'' (Part No. A95955-03),
946:
Chapter 7 - ''Oracle Inventory Open Interfaces and APIs'', Section ''Open Item Interface''.
947:
');
948:
949: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
950: End If; /* End of Impact and Action */
951:
952: statusStr := 'SUCCESS';
953: isFatal := 'FALSE';

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

1021: update mtl_system_items_b
1022: set end_date_active = null
1023: where end_date_active is not null;
1024:
';
1025: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
1026: End If; /* End of Impact and Action */
1027:
1028: statusStr := 'SUCCESS';
1029: isFatal := 'FALSE';

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

1034:
1035: ----------------
1036: <>
1037: JTF_DIAGNOSTIC_COREAPI.Line_Out('

This Health Check Test completed as expected
');
1038: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
1039: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
1040:
1041: End If; /* End of l_org_id is null or l_org_exists=1 */
1042:

Line 1039: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

1035: ----------------
1036: <>
1037: JTF_DIAGNOSTIC_COREAPI.Line_Out('

This Health Check Test completed as expected
');
1038: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
1039: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
1040:
1041: End If; /* End of l_org_id is null or l_org_exists=1 */
1042:
1043: EXCEPTION

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

1047: statusStr := 'FAILURE';
1048: errStr := sqlerrm ||' occurred in script. ';
1049: fixInfo := 'Unexpected Exception in BOMDGITB.pls';
1050: isFatal := 'FALSE';
1051: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
1052: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
1053:
1054: END runTest;
1055:

Line 1052: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

1048: errStr := sqlerrm ||' occurred in script. ';
1049: fixInfo := 'Unexpected Exception in BOMDGITB.pls';
1050: isFatal := 'FALSE';
1051: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
1052: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
1053:
1054: END runTest;
1055:
1056: PROCEDURE getComponentName(name OUT NOCOPY VARCHAR2) IS

Line 1077: package_names := JTF_DIAGNOSTIC_ADAPTUTIL.initDependencyTable;

1073: PROCEDURE getDependencies (package_names OUT NOCOPY JTF_DIAG_DEPENDTBL) IS
1074: tempDependencies JTF_DIAG_DEPENDTBL;
1075:
1076: BEGIN
1077: package_names := JTF_DIAGNOSTIC_ADAPTUTIL.initDependencyTable;
1078: END getDependencies;
1079:
1080: PROCEDURE isDependencyPipelined (str OUT NOCOPY VARCHAR2) IS
1081: BEGIN

Line 1089: tempOutput := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;

1085:
1086: PROCEDURE getOutputValues(outputValues OUT NOCOPY JTF_DIAG_OUTPUTTBL) IS
1087: tempOutput JTF_DIAG_OUTPUTTBL;
1088: BEGIN
1089: tempOutput := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;
1090: outputValues := tempOutput;
1091: EXCEPTION
1092: when others then
1093: outputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;

Line 1093: outputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;

1089: tempOutput := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;
1090: outputValues := tempOutput;
1091: EXCEPTION
1092: when others then
1093: outputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;
1094: END getOutputValues;
1095:
1096:
1097: PROCEDURE getDefaultTestParams(defaultInputValues OUT NOCOPY JTF_DIAG_INPUTTBL) IS

Line 1100: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;

1096:
1097: PROCEDURE getDefaultTestParams(defaultInputValues OUT NOCOPY JTF_DIAG_INPUTTBL) IS
1098: tempInput JTF_DIAG_INPUTTBL;
1099: BEGIN
1100: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
1101: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'OrgId','LOV-oracle.apps.bom.diag.lov.OrganizationLov');-- Lov name modified to OrgId for bug 6412260
1102: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'Script','LOV-oracle.apps.bom.diag.lov.ItemHealthLov');
1103: defaultInputValues := tempInput;
1104: EXCEPTION

Line 1101: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'OrgId','LOV-oracle.apps.bom.diag.lov.OrganizationLov');-- Lov name modified to OrgId for bug 6412260

1097: PROCEDURE getDefaultTestParams(defaultInputValues OUT NOCOPY JTF_DIAG_INPUTTBL) IS
1098: tempInput JTF_DIAG_INPUTTBL;
1099: BEGIN
1100: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
1101: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'OrgId','LOV-oracle.apps.bom.diag.lov.OrganizationLov');-- Lov name modified to OrgId for bug 6412260
1102: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'Script','LOV-oracle.apps.bom.diag.lov.ItemHealthLov');
1103: defaultInputValues := tempInput;
1104: EXCEPTION
1105: when others then

Line 1102: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'Script','LOV-oracle.apps.bom.diag.lov.ItemHealthLov');

1098: tempInput JTF_DIAG_INPUTTBL;
1099: BEGIN
1100: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
1101: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'OrgId','LOV-oracle.apps.bom.diag.lov.OrganizationLov');-- Lov name modified to OrgId for bug 6412260
1102: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'Script','LOV-oracle.apps.bom.diag.lov.ItemHealthLov');
1103: defaultInputValues := tempInput;
1104: EXCEPTION
1105: when others then
1106: defaultInputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;

Line 1106: defaultInputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;

1102: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'Script','LOV-oracle.apps.bom.diag.lov.ItemHealthLov');
1103: defaultInputValues := tempInput;
1104: EXCEPTION
1105: when others then
1106: defaultInputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
1107: END getDefaultTestParams;
1108:
1109: Function getTestMode return INTEGER IS
1110: BEGIN

Line 1111: return JTF_DIAGNOSTIC_ADAPTUTIL.ADVANCED_MODE;

1107: END getDefaultTestParams;
1108:
1109: Function getTestMode return INTEGER IS
1110: BEGIN
1111: return JTF_DIAGNOSTIC_ADAPTUTIL.ADVANCED_MODE;
1112:
1113: END getTestMode;
1114:
1115: END BOM_DIAGUNITTEST_ITMHLCHK;