DBA Data[Home] [Help]

APPS.INV_DIAG_MO_CAN_SO dependencies on JTF_DIAGNOSTIC_ADAPTUTIL

Line 35: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;

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:

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

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);

Line 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');

Line 41: l_line_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('LineId',inputs);

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');

Line 44: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,'Please execute the report with organization information');

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';

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

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:

Line 52: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

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 || '');

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

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:

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

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

Line 91: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

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);

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

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:

Line 102: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

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

Line 125: package_names := JTF_DIAGNOSTIC_ADAPTUTIL.initDependencyTable;

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

Line 136: tempOutput := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;

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;

Line 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;

Line 146: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;

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_

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

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;

Line 148: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'MoNumber','');

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

Line 149: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'LineId','LOV-oracle.apps.inv.diag.lov.MOLineLov');

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

Line 154: defaultInputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;

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

Line 159: return JTF_DIAGNOSTIC_ADAPTUTIL.ADVANCED_MODE;

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;