DBA Data[Home] [Help]

APPS.WIP_DAT_DIAG_JOB dependencies on JTF_DIAGNOSTIC_ADAPTUTIL

Line 31: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;

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

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

28: l_job_id NUMBER;
29: BEGIN
30:
31: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
32: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
33: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
34:
35: l_org_id := null ;
36: l_job_id := null ;

Line 39: if ((ltrim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Job Id',inputs),'0123456789') is null) and

35: l_org_id := null ;
36: l_job_id := null ;
37:
38: -- accept input
39: if ((ltrim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Job Id',inputs),'0123456789') is null) and
40: (ltrim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Organization Id',inputs),'0123456789') is null)) then
41: l_job_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Job Id',inputs);
42: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Organization Id',inputs);
43: else

Line 40: (ltrim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Organization Id',inputs),'0123456789') is null)) then

36: l_job_id := null ;
37:
38: -- accept input
39: if ((ltrim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Job Id',inputs),'0123456789') is null) and
40: (ltrim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Organization Id',inputs),'0123456789') is null)) then
41: l_job_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Job Id',inputs);
42: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Organization Id',inputs);
43: else
44: l_job_id := null;

Line 41: l_job_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Job Id',inputs);

37:
38: -- accept input
39: if ((ltrim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Job Id',inputs),'0123456789') is null) and
40: (ltrim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Organization Id',inputs),'0123456789') is null)) then
41: l_job_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Job Id',inputs);
42: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Organization Id',inputs);
43: else
44: l_job_id := null;
45: end if;

Line 42: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Organization Id',inputs);

38: -- accept input
39: if ((ltrim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Job Id',inputs),'0123456789') is null) and
40: (ltrim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Organization Id',inputs),'0123456789') is null)) then
41: l_job_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Job Id',inputs);
42: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Organization Id',inputs);
43: else
44: l_job_id := null;
45: end if;
46:

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

54: statusStr := 'FAILURE';
55: errStr := 'This test failed with : no/incorrect input';
56:
57: <>
58: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
59: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
60:
61: else
62:

Line 59: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

55: errStr := 'This test failed with : no/incorrect input';
56:
57: <>
58: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
59: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
60:
61: else
62:
63: WIP_DIAG_DATA_COLL.disc_lot_job(l_job_id);

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

62:
63: WIP_DIAG_DATA_COLL.disc_lot_job(l_job_id);
64:
65: reportStr := '
The output generated gives you the details regarding a particular discrete job or a lot-based job. ';
66: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
67:
68:
69: <>
70: statusStr := 'SUCCESS';

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

67:
68:
69: <>
70: statusStr := 'SUCCESS';
71: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
72: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
73:
74: end if ;
75:

Line 72: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

68:
69: <>
70: statusStr := 'SUCCESS';
71: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
72: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
73:
74: end if ;
75:
76: EXCEPTION

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

80: statusStr := 'FAILURE';
81: errStr := sqlerrm ||' occurred in script Exception handled';
82: fixInfo := 'Unexpected Exception in WIPDC01B.pls';
83: isFatal := 'FALSE';
84: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
85: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
86:
87:
88: END runTest;

Line 85: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

81: errStr := sqlerrm ||' occurred in script Exception handled';
82: fixInfo := 'Unexpected Exception in WIPDC01B.pls';
83: isFatal := 'FALSE';
84: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
85: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
86:
87:
88: END runTest;
89:

Line 111: package_names := JTF_DIAGNOSTIC_ADAPTUTIL.initDependencyTable;

107: PROCEDURE getDependencies (package_names OUT NOCOPY JTF_DIAG_DEPENDTBL) IS
108: tempDependencies JTF_DIAG_DEPENDTBL;
109:
110: BEGIN
111: package_names := JTF_DIAGNOSTIC_ADAPTUTIL.initDependencyTable;
112: END getDependencies;
113:
114: PROCEDURE isDependencyPipelined (str OUT NOCOPY VARCHAR2) IS
115: BEGIN

Line 123: tempOutput := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;

119:
120: PROCEDURE getOutputValues(outputValues OUT NOCOPY JTF_DIAG_OUTPUTTBL) IS
121: tempOutput JTF_DIAG_OUTPUTTBL;
122: BEGIN
123: tempOutput := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;
124: outputValues := tempOutput;
125: EXCEPTION
126: when others then
127: outputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;

Line 127: outputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;

123: tempOutput := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;
124: outputValues := tempOutput;
125: EXCEPTION
126: when others then
127: outputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;
128: END getOutputValues;
129:
130:
131: PROCEDURE getDefaultTestParams(defaultInputValues OUT NOCOPY JTF_DIAG_INPUTTBL) IS

Line 135: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;

131: PROCEDURE getDefaultTestParams(defaultInputValues OUT NOCOPY JTF_DIAG_INPUTTBL) IS
132: tempInput JTF_DIAG_INPUTTBL;
133: BEGIN
134:
135: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
136: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput, 'Organization Id', 'LOV-oracle.apps.inv.diag.lov.OrganizationLov');
137: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'Job Id','LOV-oracle.apps.wip.diag.lov.JobLov');
138: defaultInputValues := tempInput;
139:

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

132: tempInput JTF_DIAG_INPUTTBL;
133: BEGIN
134:
135: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
136: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput, 'Organization Id', 'LOV-oracle.apps.inv.diag.lov.OrganizationLov');
137: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'Job Id','LOV-oracle.apps.wip.diag.lov.JobLov');
138: defaultInputValues := tempInput;
139:
140: EXCEPTION

Line 137: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'Job Id','LOV-oracle.apps.wip.diag.lov.JobLov');

133: BEGIN
134:
135: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
136: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput, 'Organization Id', 'LOV-oracle.apps.inv.diag.lov.OrganizationLov');
137: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'Job Id','LOV-oracle.apps.wip.diag.lov.JobLov');
138: defaultInputValues := tempInput;
139:
140: EXCEPTION
141: when others then

Line 142: defaultInputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;

138: defaultInputValues := tempInput;
139:
140: EXCEPTION
141: when others then
142: defaultInputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
143: END getDefaultTestParams;
144:
145: Function getTestMode return INTEGER IS
146: BEGIN

Line 147: return JTF_DIAGNOSTIC_ADAPTUTIL.ADVANCED_MODE; /* Bug 5735526 */

143: END getDefaultTestParams;
144:
145: Function getTestMode return INTEGER IS
146: BEGIN
147: return JTF_DIAGNOSTIC_ADAPTUTIL.ADVANCED_MODE; /* Bug 5735526 */
148:
149: END getTestMode;
150:
151: END;