31: l_org_id NUMBER;
32:
33: BEGIN
34:
35: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
36: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
37: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
38: --JTF_DIAGNOSTIC_COREAPI.line_out('this also writes to the clob');
39:
32:
33: BEGIN
34:
35: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
36: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
37: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
38: --JTF_DIAGNOSTIC_COREAPI.line_out('this also writes to the clob');
39:
40: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrgId',inputs);
36: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
37: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
38: --JTF_DIAGNOSTIC_COREAPI.line_out('this also writes to the clob');
39:
40: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrgId',inputs);
41: l_line_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('LineId',inputs);
42:
43: IF l_org_id IS NULL THEN
44: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,'Please execute the report with organization information');
37: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
38: --JTF_DIAGNOSTIC_COREAPI.line_out('this also writes to the clob');
39:
40: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrgId',inputs);
41: l_line_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('LineId',inputs);
42:
43: IF l_org_id IS NULL THEN
44: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,'Please execute the report with organization information');
45: JTF_DIAGNOSTIC_COREAPI.errorprint('Error: '|| 'Invalid Organization Identifier');
40: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrgId',inputs);
41: l_line_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('LineId',inputs);
42:
43: IF l_org_id IS NULL THEN
44: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,'Please execute the report with organization information');
45: JTF_DIAGNOSTIC_COREAPI.errorprint('Error: '|| 'Invalid Organization Identifier');
46: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please enter correct organization Identifier');
47: statusStr := 'FAILURE';
48: errStr := 'Invalid Organization Identifier';
47: statusStr := 'FAILURE';
48: errStr := 'Invalid Organization Identifier';
49: fixInfo := 'Please enter or choose Organization identifier';
50: isFatal := 'FALSE';
51: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
52: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
53: RETURN;
54: END IF;
55:
48: errStr := 'Invalid Organization Identifier';
49: fixInfo := 'Please enter or choose Organization identifier';
50: isFatal := 'FALSE';
51: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
52: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
53: RETURN;
54: END IF;
55:
56: FND_CLIENT_INFO.SET_ORG_CONTEXT('' || l_org_id || '');
84: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'Details of Move Order');
85:
86:
87: reportStr := 'The test completed as expected';
88: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
89: statusStr := 'SUCCESS';
90: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
91: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
92:
86:
87: reportStr := 'The test completed as expected';
88: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
89: statusStr := 'SUCCESS';
90: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
91: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
92:
93: EXCEPTION
94: when others then
87: reportStr := 'The test completed as expected';
88: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
89: statusStr := 'SUCCESS';
90: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
91: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
92:
93: EXCEPTION
94: when others then
95: JTF_DIAGNOSTIC_COREAPI.errorprint('Error: '||sqlerrm);
97: statusStr := 'FAILURE';
98: errStr := sqlerrm ||' occurred in script Exception handled';
99: fixInfo := 'Unexpected Exception in INVDM02B.pls';
100: isFatal := 'FALSE';
101: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
102: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
103: END runTest;
104:
105:
98: errStr := sqlerrm ||' occurred in script Exception handled';
99: fixInfo := 'Unexpected Exception in INVDM02B.pls';
100: isFatal := 'FALSE';
101: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
102: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
103: END runTest;
104:
105:
106: PROCEDURE getComponentName(name OUT NOCOPY VARCHAR2) IS
121: PROCEDURE getDependencies (package_names OUT NOCOPY JTF_DIAG_DEPENDTBL) IS
122: tempDependencies JTF_DIAG_DEPENDTBL;
123:
124: BEGIN
125: package_names := JTF_DIAGNOSTIC_ADAPTUTIL.initDependencyTable;
126: END getDependencies;
127:
128: PROCEDURE isDependencyPipelined (str OUT NOCOPY VARCHAR2) IS
129: BEGIN
132:
133: PROCEDURE getOutputValues(outputValues OUT NOCOPY JTF_DIAG_OUTPUTTBL) IS
134: tempOutput JTF_DIAG_OUTPUTTBL;
135: BEGIN
136: tempOutput := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;
137: outputValues := tempOutput;
138: EXCEPTION
139: when others then
140: outputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;
136: tempOutput := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;
137: outputValues := tempOutput;
138: EXCEPTION
139: when others then
140: outputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;
141: END getOutputValues;
142:
143: PROCEDURE getDefaultTestParams(defaultInputValues OUT NOCOPY JTF_DIAG_INPUTTBL) IS
144: tempInput JTF_DIAG_INPUTTBL;
142:
143: PROCEDURE getDefaultTestParams(defaultInputValues OUT NOCOPY JTF_DIAG_INPUTTBL) IS
144: tempInput JTF_DIAG_INPUTTBL;
145: BEGIN
146: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
147: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'OrgId','LOV-oracle.apps.inv.diag.lov.OrganizationLov');
148: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'MoNumber','');
149: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'LineId','LOV-oracle.apps.inv.diag.lov.MOLineLov');
150: -- tempInput := JTF_DIAGNOSTIC_
143: PROCEDURE getDefaultTestParams(defaultInputValues OUT NOCOPY JTF_DIAG_INPUTTBL) IS
144: tempInput JTF_DIAG_INPUTTBL;
145: BEGIN
146: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
147: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'OrgId','LOV-oracle.apps.inv.diag.lov.OrganizationLov');
148: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'MoNumber','');
149: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'LineId','LOV-oracle.apps.inv.diag.lov.MOLineLov');
150: -- tempInput := JTF_DIAGNOSTIC_
151: defaultInputValues := tempInput;
144: tempInput JTF_DIAG_INPUTTBL;
145: BEGIN
146: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
147: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'OrgId','LOV-oracle.apps.inv.diag.lov.OrganizationLov');
148: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'MoNumber','');
149: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'LineId','LOV-oracle.apps.inv.diag.lov.MOLineLov');
150: -- tempInput := JTF_DIAGNOSTIC_
151: defaultInputValues := tempInput;
152: EXCEPTION
145: BEGIN
146: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
147: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'OrgId','LOV-oracle.apps.inv.diag.lov.OrganizationLov');
148: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'MoNumber','');
149: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'LineId','LOV-oracle.apps.inv.diag.lov.MOLineLov');
150: -- tempInput := JTF_DIAGNOSTIC_
151: defaultInputValues := tempInput;
152: EXCEPTION
153: when others then
150: -- tempInput := JTF_DIAGNOSTIC_
151: defaultInputValues := tempInput;
152: EXCEPTION
153: when others then
154: defaultInputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
155: END getDefaultTestParams;
156:
157: Function getTestMode return INTEGER IS
158: BEGIN
155: END getDefaultTestParams;
156:
157: Function getTestMode return INTEGER IS
158: BEGIN
159: return JTF_DIAGNOSTIC_ADAPTUTIL.ADVANCED_MODE;
160: END getTestMode;
161:
162: END INV_DIAG_MO_CAN_SO;