APPS.INV_DIAG_OH_STATUS_CONTROL dependencies on JTF_DIAGNOSTIC_ADAPTUTIL

Line 30: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;

26: row_limit NUMBER;
27: l_org_id NUMBER;
28:
29: BEGIN
30: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
31: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
32: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
33:
34: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrgId',inputs);

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

27: l_org_id NUMBER;
28:
29: BEGIN
30: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
31: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
32: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
33:
34: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrgId',inputs);
35:

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

30: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
31: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
32: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
33:
34: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrgId',inputs);
35:
36: sqltxt := ' SELECT mtsv.status_code' ||
37: ' || '' (''' ||
38: ' ||mtsv.status_id' ||

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

50:
51: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Statuses with Onhand control as No when any of the organization is onhand status enabled');
52:
53: reportStr := 'The test completed as expected';
54: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
55: statusStr := 'SUCCESS';
56: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
57: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
58:

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

52:
53: reportStr := 'The test completed as expected';
54: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
55: statusStr := 'SUCCESS';
56: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
57: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
58:
59: EXCEPTION
60: when others then

Line 57: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

53: reportStr := 'The test completed as expected';
54: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
55: statusStr := 'SUCCESS';
56: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
57: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
58:
59: EXCEPTION
60: when others then
61: JTF_DIAGNOSTIC_COREAPI.errorprint('Error: '||sqlerrm);

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

63: statusStr := 'FAILURE';
64: errStr := sqlerrm ||' occurred in script Exception handled';
65: fixInfo := 'Unexpected Exception in INVDOH3B.pls';
66: isFatal := 'FALSE';
67: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
68: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
69: END runTest;
70:
71: PROCEDURE getComponentName(name OUT NOCOPY VARCHAR2) IS

Line 68: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

64: errStr := sqlerrm ||' occurred in script Exception handled';
65: fixInfo := 'Unexpected Exception in INVDOH3B.pls';
66: isFatal := 'FALSE';
67: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
68: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
69: END runTest;
70:
71: PROCEDURE getComponentName(name OUT NOCOPY VARCHAR2) IS
72: BEGIN

Line 91: package_names := JTF_DIAGNOSTIC_ADAPTUTIL.initDependencyTable;

87: PROCEDURE getDependencies (package_names OUT NOCOPY JTF_DIAG_DEPENDTBL) IS
88: tempDependencies JTF_DIAG_DEPENDTBL;
89:
90: BEGIN
91: package_names := JTF_DIAGNOSTIC_ADAPTUTIL.initDependencyTable;
92: END getDependencies;
93:
94: PROCEDURE isDependencyPipelined (str OUT NOCOPY VARCHAR2) IS
95: BEGIN

Line 102: tempOutput := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;

98:
99: PROCEDURE getOutputValues(outputValues OUT NOCOPY JTF_DIAG_OUTPUTTBL) IS
100: tempOutput JTF_DIAG_OUTPUTTBL;
101: BEGIN
102: tempOutput := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;
103: outputValues := tempOutput;
104: EXCEPTION
105: when others then
106: outputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;

Line 106: outputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;

102: tempOutput := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;
103: outputValues := tempOutput;
104: EXCEPTION
105: when others then
106: outputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;
107: END getOutputValues;
108:
109:
110: /*PROCEDURE getDefaultTestParams(defaultInputValues OUT NOCOPY JTF_DIAG_INPUTTBL) IS

Line 113: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;

109:
110: /*PROCEDURE getDefaultTestParams(defaultInputValues OUT NOCOPY JTF_DIAG_INPUTTBL) IS
111: tempInput JTF_DIAG_INPUTTBL;
112: BEGIN
113: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
114: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'OrgId','LOV-oracle.apps.inv.diag.lov.OrganizationLov');
115: defaultInputValues := tempInput;
116:
117: EXCEPTION

Line 114: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'OrgId','LOV-oracle.apps.inv.diag.lov.OrganizationLov');

110: /*PROCEDURE getDefaultTestParams(defaultInputValues OUT NOCOPY JTF_DIAG_INPUTTBL) IS
111: tempInput JTF_DIAG_INPUTTBL;
112: BEGIN
113: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
114: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'OrgId','LOV-oracle.apps.inv.diag.lov.OrganizationLov');
115: defaultInputValues := tempInput;
116:
117: EXCEPTION
118: when others then

Line 119: defaultInputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;

115: defaultInputValues := tempInput;
116:
117: EXCEPTION
118: when others then
119: defaultInputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
120: END getDefaultTestParams;*/
121:
122: Function getTestMode return INTEGER IS
123: BEGIN

Line 124: return JTF_DIAGNOSTIC_ADAPTUTIL.ADVANCED_MODE;

120: END getDefaultTestParams;*/
121:
122: Function getTestMode return INTEGER IS
123: BEGIN
124: return JTF_DIAGNOSTIC_ADAPTUTIL.ADVANCED_MODE;
125: END getTestMode;
126: END INV_DIAG_OH_STATUS_CONTROL;