eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WIP_DAT_DIAG_REP dependencies on JTF_DIAGNOSTIC_ADAPTUTIL

Line 33: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;

29: l_line_id NUMBER;
30: l_rep_schedule_id NUMBER;
31: BEGIN
32:
33: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
34: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
35: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
36:
37: -- accept input

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

30: l_rep_schedule_id NUMBER;
31: BEGIN
32:
33: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
34: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
35: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
36:
37: -- accept input
38: if ((ltrim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Organization Id',inputs),'0123456789') is null) and

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

34: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
35: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
36:
37: -- accept input
38: if ((ltrim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Organization Id',inputs),'0123456789') is null) and
39: (ltrim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Assembly Id',inputs),'0123456789') is null) and
40: (ltrim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Line Id',inputs),'0123456789') is null) and
41: (ltrim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Repetitive Id',inputs),'0123456789')is null)) then
42:

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

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

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

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

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

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

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

39: (ltrim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Assembly Id',inputs),'0123456789') is null) and
40: (ltrim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Line Id',inputs),'0123456789') is null) and
41: (ltrim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Repetitive Id',inputs),'0123456789')is null)) then
42:
43: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Organization Id',inputs);
44: l_job_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Assembly Id',inputs);
45: l_line_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Line Id',inputs);
46: l_rep_schedule_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Repetitive Id',inputs);
47:

Line 44: l_job_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Assembly Id',inputs);

40: (ltrim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Line Id',inputs),'0123456789') is null) and
41: (ltrim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Repetitive Id',inputs),'0123456789')is null)) then
42:
43: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Organization Id',inputs);
44: l_job_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Assembly Id',inputs);
45: l_line_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Line Id',inputs);
46: l_rep_schedule_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Repetitive Id',inputs);
47:
48: else

Line 45: l_line_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Line Id',inputs);

41: (ltrim(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Repetitive Id',inputs),'0123456789')is null)) then
42:
43: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Organization Id',inputs);
44: l_job_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Assembly Id',inputs);
45: l_line_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Line Id',inputs);
46: l_rep_schedule_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Repetitive Id',inputs);
47:
48: else
49: l_rep_schedule_id := null;

Line 46: l_rep_schedule_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Repetitive Id',inputs);

42:
43: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Organization Id',inputs);
44: l_job_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Assembly Id',inputs);
45: l_line_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Line Id',inputs);
46: l_rep_schedule_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Repetitive Id',inputs);
47:
48: else
49: l_rep_schedule_id := null;
50:

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

63: fixInfo := 'Please select Repetitive Line for which output is desired.';
64: end if ;
65: isFatal := 'FALSE';
66: <>
67: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
68: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
69:
70: else
71:

Line 68: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

64: end if ;
65: isFatal := 'FALSE';
66: <>
67: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
68: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
69:
70: else
71:
72: WIP_DIAG_DATA_COLL.repetitive(l_job_id, l_line_id, l_rep_schedule_id);

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

71:
72: WIP_DIAG_DATA_COLL.repetitive(l_job_id, l_line_id, l_rep_schedule_id);
73:
74: reportStr := '
The output generated gives you the details regarding a Repetitive Item';
75: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
76:
77:
78: <>
79: statusStr := 'SUCCESS';

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

76:
77:
78: <>
79: statusStr := 'SUCCESS';
80: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
81: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
82: end if ;
83:
84: EXCEPTION

Line 81: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

77:
78: <>
79: statusStr := 'SUCCESS';
80: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
81: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
82: end if ;
83:
84: EXCEPTION
85: when others then

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

88: statusStr := 'FAILURE';
89: errStr := sqlerrm ||' occurred in script Exception handled';
90: fixInfo := 'Unexpected Exception in WIPDC02B.pls';
91: isFatal := 'FALSE';
92: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
93: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
94:
95:
96: END runTest;

Line 93: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

89: errStr := sqlerrm ||' occurred in script Exception handled';
90: fixInfo := 'Unexpected Exception in WIPDC02B.pls';
91: isFatal := 'FALSE';
92: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
93: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
94:
95:
96: END runTest;
97:

Line 119: package_names := JTF_DIAGNOSTIC_ADAPTUTIL.initDependencyTable;

115: PROCEDURE getDependencies (package_names OUT NOCOPY JTF_DIAG_DEPENDTBL) IS
116: tempDependencies JTF_DIAG_DEPENDTBL;
117:
118: BEGIN
119: package_names := JTF_DIAGNOSTIC_ADAPTUTIL.initDependencyTable;
120: END getDependencies;
121:
122: PROCEDURE isDependencyPipelined (str OUT NOCOPY VARCHAR2) IS
123: BEGIN

Line 131: tempOutput := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;

127:
128: PROCEDURE getOutputValues(outputValues OUT NOCOPY JTF_DIAG_OUTPUTTBL) IS
129: tempOutput JTF_DIAG_OUTPUTTBL;
130: BEGIN
131: tempOutput := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;
132: outputValues := tempOutput;
133: EXCEPTION
134: when others then
135: outputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;

Line 135: outputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;

131: tempOutput := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;
132: outputValues := tempOutput;
133: EXCEPTION
134: when others then
135: outputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initOutputTable;
136: END getOutputValues;
137:
138:
139: PROCEDURE getDefaultTestParams(defaultInputValues OUT NOCOPY JTF_DIAG_INPUTTBL) IS

Line 143: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;

139: PROCEDURE getDefaultTestParams(defaultInputValues OUT NOCOPY JTF_DIAG_INPUTTBL) IS
140: tempInput JTF_DIAG_INPUTTBL;
141: BEGIN
142:
143: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
144: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput, 'Organization Id', 'LOV-oracle.apps.inv.diag.lov.OrganizationLov');
145: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'Assembly Id','LOV-oracle.apps.wip.diag.lov.RepAssyLov');
146: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput, 'Line Id', 'LOV-oracle.apps.wip.diag.lov.LineLov');
147: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput, 'Repetitive Id', 'LOV-oracle.apps.wip.diag.lov.RepSchLov');

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

140: tempInput JTF_DIAG_INPUTTBL;
141: BEGIN
142:
143: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
144: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput, 'Organization Id', 'LOV-oracle.apps.inv.diag.lov.OrganizationLov');
145: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'Assembly Id','LOV-oracle.apps.wip.diag.lov.RepAssyLov');
146: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput, 'Line Id', 'LOV-oracle.apps.wip.diag.lov.LineLov');
147: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput, 'Repetitive Id', 'LOV-oracle.apps.wip.diag.lov.RepSchLov');
148: defaultInputValues := tempInput;

Line 145: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'Assembly Id','LOV-oracle.apps.wip.diag.lov.RepAssyLov');

141: BEGIN
142:
143: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
144: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput, 'Organization Id', 'LOV-oracle.apps.inv.diag.lov.OrganizationLov');
145: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'Assembly Id','LOV-oracle.apps.wip.diag.lov.RepAssyLov');
146: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput, 'Line Id', 'LOV-oracle.apps.wip.diag.lov.LineLov');
147: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput, 'Repetitive Id', 'LOV-oracle.apps.wip.diag.lov.RepSchLov');
148: defaultInputValues := tempInput;
149:

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

142:
143: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
144: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput, 'Organization Id', 'LOV-oracle.apps.inv.diag.lov.OrganizationLov');
145: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'Assembly Id','LOV-oracle.apps.wip.diag.lov.RepAssyLov');
146: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput, 'Line Id', 'LOV-oracle.apps.wip.diag.lov.LineLov');
147: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput, 'Repetitive Id', 'LOV-oracle.apps.wip.diag.lov.RepSchLov');
148: defaultInputValues := tempInput;
149:
150: EXCEPTION

Line 147: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput, 'Repetitive Id', 'LOV-oracle.apps.wip.diag.lov.RepSchLov');

143: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
144: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput, 'Organization Id', 'LOV-oracle.apps.inv.diag.lov.OrganizationLov');
145: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput,'Assembly Id','LOV-oracle.apps.wip.diag.lov.RepAssyLov');
146: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput, 'Line Id', 'LOV-oracle.apps.wip.diag.lov.LineLov');
147: tempInput := JTF_DIAGNOSTIC_ADAPTUTIL.addInput(tempInput, 'Repetitive Id', 'LOV-oracle.apps.wip.diag.lov.RepSchLov');
148: defaultInputValues := tempInput;
149:
150: EXCEPTION
151: when others then

Line 152: defaultInputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;

148: defaultInputValues := tempInput;
149:
150: EXCEPTION
151: when others then
152: defaultInputValues := JTF_DIAGNOSTIC_ADAPTUTIL.initinputtable;
153: END getDefaultTestParams;
154:
155: Function getTestMode return INTEGER IS
156: BEGIN

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

153: END getDefaultTestParams;
154:
155: Function getTestMode return INTEGER IS
156: BEGIN
157: return JTF_DIAGNOSTIC_ADAPTUTIL.ADVANCED_MODE; /* Bug 5735526 */
158:
159: END getTestMode;
160:
161: END;