DBA Data[Home] [Help]

APPS.WIP_DAT_DIAG_PEND 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: -- accept input

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: -- accept input
36: if (ltrim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Organization Id',inputs),'0123456789') is null) then

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

32: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
33: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
34:
35: -- accept input
36: if (ltrim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Organization Id',inputs),'0123456789') is null) then
37: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Organization Id',inputs);
38: else
39: l_org_id := null;
40: end if;

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

33: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
34:
35: -- accept input
36: if (ltrim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Organization Id',inputs),'0123456789') is null) then
37: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Organization Id',inputs);
38: else
39: l_org_id := null;
40: end if;
41:

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

49: isFatal := 'FALSE';
50:
51:
52: <>
53: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
54: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
55:
56:
57: else

Line 54: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

50:
51:
52: <>
53: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
54: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
55:
56:
57: else
58:

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

58:
59: WIP_DIAG_DATA_COLL.pending_txns(l_org_id );
60:
61: reportStr := '
The output generated gives you the details regarding Pending Transactions';
62: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
63:
64:
65: <>
66: statusStr := 'SUCCESS' ;

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

63:
64:
65: <>
66: statusStr := 'SUCCESS' ;
67: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
68: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
69: end if ;
70:
71: EXCEPTION

Line 68: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

64:
65: <>
66: statusStr := 'SUCCESS' ;
67: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
68: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
69: end if ;
70:
71: EXCEPTION
72: when others then

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

75: statusStr := 'FAILURE';
76: errStr := sqlerrm ||' occurred in script Exception handled';
77: fixInfo := 'Unexpected Exception in WIPDC05B.pls';
78: isFatal := 'FALSE';
79: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
80: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
81:
82:
83: END runTest;

Line 80: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

76: errStr := sqlerrm ||' occurred in script Exception handled';
77: fixInfo := 'Unexpected Exception in WIPDC05B.pls';
78: isFatal := 'FALSE';
79: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
80: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
81:
82:
83: END runTest;
84:

Line 105: package_names := JTF_DIAGNOSTIC_ADAPTUTIL.initDependencyTable;

101: PROCEDURE getDependencies (package_names OUT NOCOPY JTF_DIAG_DEPENDTBL) IS
102: tempDependencies JTF_DIAG_DEPENDTBL;
103:
104: BEGIN
105: package_names := JTF_DIAGNOSTIC_ADAPTUTIL.initDependencyTable;
106: END getDependencies;
107:
108: PROCEDURE isDependencyPipelined (str OUT NOCOPY VARCHAR2) IS
109: BEGIN

Line 117: tempOutput := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;

113:
114: PROCEDURE getOutputValues(outputValues OUT NOCOPY JTF_DIAG_OUTPUTTBL) IS
115: tempOutput JTF_DIAG_OUTPUTTBL;
116: BEGIN
117: tempOutput := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;
118: outputValues := tempOutput;
119: EXCEPTION
120: when others then
121: outputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;

Line 121: outputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;

117: tempOutput := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;
118: outputValues := tempOutput;
119: EXCEPTION
120: when others then
121: outputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;
122: END getOutputValues;
123:
124:
125: PROCEDURE getDefaultTestParams(defaultInputValues OUT NOCOPY JTF_DIAG_INPUTTBL) IS

Line 129: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;

125: PROCEDURE getDefaultTestParams(defaultInputValues OUT NOCOPY JTF_DIAG_INPUTTBL) IS
126: tempInput JTF_DIAG_INPUTTBL;
127: BEGIN
128:
129: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
130: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput, 'Organization Id', 'LOV-oracle.apps.inv.diag.lov.OrganizationLov');
131: defaultInputValues := tempInput;
132:
133: EXCEPTION

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

126: tempInput JTF_DIAG_INPUTTBL;
127: BEGIN
128:
129: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
130: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput, 'Organization Id', 'LOV-oracle.apps.inv.diag.lov.OrganizationLov');
131: defaultInputValues := tempInput;
132:
133: EXCEPTION
134: when others then

Line 135: defaultInputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;

131: defaultInputValues := tempInput;
132:
133: EXCEPTION
134: when others then
135: defaultInputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
136: END getDefaultTestParams;
137:
138: Function getTestMode return INTEGER IS
139: BEGIN

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

136: END getDefaultTestParams;
137:
138: Function getTestMode return INTEGER IS
139: BEGIN
140: return JTF_DIAGNOSTIC_ADAPTUTIL.ADVANCED_MODE; /* Bug 5735526 */
141:
142: END getTestMode;
143:
144: END;