DBA Data[Home] [Help]

APPS.WIP_WDJ_DIAG_DUP_MAT 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:

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:
36: -- accept input

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

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

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

34:
35:
36: -- accept input
37: if (ltrim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Organization Id',inputs),'0123456789') is null ) then
38: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Organization Id',inputs);
39: WIP_DIAG_DISCRETE_LOT.dup_mat_txn_wdj(l_org_id, report, reportClob);
40:
41: <>
42: statusStr := 'SUCCESS';

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

39: WIP_DIAG_DISCRETE_LOT.dup_mat_txn_wdj(l_org_id, report, reportClob);
40:
41: <>
42: statusStr := 'SUCCESS';
43: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
44: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
45: else
46: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('
Parameter input is required.');
47: if l_org_id is null then

Line 44: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

40:
41: <>
42: statusStr := 'SUCCESS';
43: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
44: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
45: else
46: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('
Parameter input is required.');
47: if l_org_id is null then
48: fixInfo := 'Please enter the Org id for which output is desired.';

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

51: statusStr := 'FAILURE';
52: errStr := 'This test failed with : no/Incorrect input';
53:
54: <>
55: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
56: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
57: end if ;
58:
59:

Line 56: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

52: errStr := 'This test failed with : no/Incorrect input';
53:
54: <>
55: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
56: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
57: end if ;
58:
59:
60: EXCEPTION

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

64: statusStr := 'FAILURE';
65: errStr := sqlerrm ||' occurred in script Exception handled';
66: fixInfo := 'Unexpected Exception in WIPDJOBB.pls';
67: isFatal := 'FALSE';
68: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
69: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
70:
71:
72: END runTest;

Line 69: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

65: errStr := sqlerrm ||' occurred in script Exception handled';
66: fixInfo := 'Unexpected Exception in WIPDJOBB.pls';
67: isFatal := 'FALSE';
68: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
69: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
70:
71:
72: END runTest;
73:

Line 97: package_names := JTF_DIAGNOSTIC_ADAPTUTIL.initDependencyTable;

93: PROCEDURE getDependencies (package_names OUT NOCOPY JTF_DIAG_DEPENDTBL) IS
94: tempDependencies JTF_DIAG_DEPENDTBL;
95:
96: BEGIN
97: package_names := JTF_DIAGNOSTIC_ADAPTUTIL.initDependencyTable;
98: END getDependencies;
99:
100: PROCEDURE isDependencyPipelined (str OUT NOCOPY VARCHAR2) IS
101: BEGIN

Line 109: tempOutput := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;

105:
106: PROCEDURE getOutputValues(outputValues OUT NOCOPY JTF_DIAG_OUTPUTTBL) IS
107: tempOutput JTF_DIAG_OUTPUTTBL;
108: BEGIN
109: tempOutput := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;
110: outputValues := tempOutput;
111: EXCEPTION
112: when others then
113: outputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;

Line 113: outputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;

109: tempOutput := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;
110: outputValues := tempOutput;
111: EXCEPTION
112: when others then
113: outputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;
114: END getOutputValues;
115:
116:
117: PROCEDURE getDefaultTestParams(defaultInputValues OUT NOCOPY JTF_DIAG_INPUTTBL) IS

Line 121: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;

117: PROCEDURE getDefaultTestParams(defaultInputValues OUT NOCOPY JTF_DIAG_INPUTTBL) IS
118: tempInput JTF_DIAG_INPUTTBL;
119: BEGIN
120:
121: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
122: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput, 'Organization Id', 'LOV-oracle.apps.inv.diag.lov.OrganizationLov');
123: defaultInputValues := tempInput;
124:
125: EXCEPTION

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

118: tempInput JTF_DIAG_INPUTTBL;
119: BEGIN
120:
121: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
122: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput, 'Organization Id', 'LOV-oracle.apps.inv.diag.lov.OrganizationLov');
123: defaultInputValues := tempInput;
124:
125: EXCEPTION
126: when others then

Line 127: defaultInputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;

123: defaultInputValues := tempInput;
124:
125: EXCEPTION
126: when others then
127: defaultInputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
128: END getDefaultTestParams;
129:
130: Function getTestMode return INTEGER IS
131: BEGIN

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

128: END getDefaultTestParams;
129:
130: Function getTestMode return INTEGER IS
131: BEGIN
132: return JTF_DIAGNOSTIC_ADAPTUTIL.ADVANCED_MODE; /* Bug 5735526 */
133:
134:
135: END getTestMode;
136: