DBA Data[Home] [Help]

APPS.WIP_DAT_DIAG_FLOW dependencies on JTF_DIAGNOSTIC_ADAPTUTIL

Line 31: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;

27: l_org_id NUMBER;
28: l_schedule_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_schedule_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:

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

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

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

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

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

36:
37: if((ltrim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Organization Id',inputs),'0123456789') is null) and
38: (ltrim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Schedule Id',inputs),'0123456789') is null)) then
39:
40: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Organization Id',inputs);
41: l_schedule_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Schedule Id',inputs);
42: else
43: l_schedule_id := null;
44: end if;

Line 41: l_schedule_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Schedule Id',inputs);

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

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

54: isFatal := 'FALSE';
55:
56:
57: <>
58: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
59: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
60:
61:
62: else

Line 59: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

55:
56:
57: <>
58: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
59: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
60:
61:
62: else
63:

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

63:
64: WIP_DIAG_DATA_COLL.flow(l_schedule_id);
65:
66: reportStr := '
The output generated gives you the details regarding a particular Flow Schedule';
67: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
68:
69:
70: <>
71: statusStr := 'SUCCESS';

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

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

Line 73: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

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

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 WIPDC03B.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 WIPDC03B.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 110: package_names := JTF_DIAGNOSTIC_ADAPTUTIL.initDependencyTable;

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

Line 122: tempOutput := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;

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

Line 126: outputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;

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

Line 134: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;

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

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

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

Line 136: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'Schedule Id','LOV-oracle.apps.wip.diag.lov.FlowSchLov');

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

Line 141: defaultInputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;

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

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

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