APPS.BOM_DIAGUNITTEST_ECOHLCHK dependencies on JTF_DIAGNOSTIC_COREAPI

Line 33: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;

29:
30: BEGIN
31: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
32: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
33: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
34:
35: /* Set Row Limit to 1000 (i.e.) Max Number of records to be fetched by each sql*/
36: row_limit :=1000;
37: l_org_exists :=0; /* Initialize to zero */

Line 53: JTF_DIAGNOSTIC_COREAPI.errorprint('Invalid Organization Id');

49: where organization_id=l_org_id;
50: Exception
51: When others Then
52: l_org_exists :=0;
53: JTF_DIAGNOSTIC_COREAPI.errorprint('Invalid Organization Id');
54: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint(' Please either provide a valid value for the Organization Id or leave it blank. ');
55: statusStr := 'FAILURE';
56: isFatal := 'TRUE';
57: fixInfo := ' Please review the error message below and take corrective action.';

Line 54: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint(' Please either provide a valid value for the Organization Id or leave it blank. ');

50: Exception
51: When others Then
52: l_org_exists :=0;
53: JTF_DIAGNOSTIC_COREAPI.errorprint('Invalid Organization Id');
54: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint(' Please either provide a valid value for the Organization Id or leave it blank. ');
55: statusStr := 'FAILURE';
56: isFatal := 'TRUE';
57: fixInfo := ' Please review the error message below and take corrective action.';
58: errStr := ' Invalid value for input field Organization Id ';

Line 98: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' ECOs with non ''Implemented'' Status though all their Revised Items are in ''Implemented'' Status');

94:
95: sqltxt :=sqltxt||' and rownum< '||row_limit;
96: sqltxt :=sqltxt||' order by mp.organization_code, eec.change_notice';
97:
98: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' ECOs with non ''Implemented'' Status though all their Revised Items are in ''Implemented'' Status');
99:
100: If (num_rows = 0) Then /* Corrupt Data Not Found for this case*/
101: JTF_DIAGNOSTIC_COREAPI.Line_Out('No corrupt data found for this case.

');
102: ElsIf (num_rows > 0) Then /* Show Impact and Action only if rows are returned */

Line 101: JTF_DIAGNOSTIC_COREAPI.Line_Out('No corrupt data found for this case.

');

97:
98: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' ECOs with non ''Implemented'' Status though all their Revised Items are in ''Implemented'' Status');
99:
100: If (num_rows = 0) Then /* Corrupt Data Not Found for this case*/
101: JTF_DIAGNOSTIC_COREAPI.Line_Out('No corrupt data found for this case.

');
102: ElsIf (num_rows > 0) Then /* Show Impact and Action only if rows are returned */
103: If (num_rows = row_limit -1 ) Then
104: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output of the above table is limited to the first '||(row_limit-1)||' rows
105:
to prevent an excessively big output file.
');

Line 104: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output of the above table is limited to the first '||(row_limit-1)||' rows

100: If (num_rows = 0) Then /* Corrupt Data Not Found for this case*/
101: JTF_DIAGNOSTIC_COREAPI.Line_Out('No corrupt data found for this case.

');
102: ElsIf (num_rows > 0) Then /* Show Impact and Action only if rows are returned */
103: If (num_rows = row_limit -1 ) Then
104: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output of the above table is limited to the first '||(row_limit-1)||' rows
105:
to prevent an excessively big output file.
');
106: End If;
107: JTF_DIAGNOSTIC_COREAPI.Line_Out('
IMPACT:
108:
The discrepency between the ECO Header Status and

Line 107: JTF_DIAGNOSTIC_COREAPI.Line_Out('
IMPACT:

103: If (num_rows = row_limit -1 ) Then
104: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output of the above table is limited to the first '||(row_limit-1)||' rows
105:
to prevent an excessively big output file.
');
106: End If;
107: JTF_DIAGNOSTIC_COREAPI.Line_Out('
IMPACT:
108:
The discrepency between the ECO Header Status and
109:
its Revised Items Statuses can mislead the users.
110:
Any reports based on the Eco Header status will report wrong data.

');
111:

Line 112: JTF_DIAGNOSTIC_COREAPI.ActionErrorLink('
Please apply appropriate patches suggested in metalink note : ' , '393085.1', '' );

108:
The discrepency between the ECO Header Status and
109:
its Revised Items Statuses can mislead the users.
110:
Any reports based on the Eco Header status will report wrong data.

');
111:
112: JTF_DIAGNOSTIC_COREAPI.ActionErrorLink('
Please apply appropriate patches suggested in metalink note : ' , '393085.1', '' );
113:
114: reportStr := '
If any ECOs are fetched above,
115:
then please follow the below steps to correct them.
116:
(1) Please apply the patch suggested in above metalink Note.

Line 145: JTF_DIAGNOSTIC_COREAPI.Line_Out('

This Health Check test completed as expected
');

141: isFatal := 'FALSE';
142: /* End of Script 1 */
143:
144: <>
145: JTF_DIAGNOSTIC_COREAPI.Line_Out('

This Health Check test completed as expected
');
146: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
147: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
148:
149: End If; /* End of l_org_id is null or l_org_exists=1 */

Line 153: JTF_DIAGNOSTIC_COREAPI.errorprint('Error: '||sqlerrm);

149: End If; /* End of l_org_id is null or l_org_exists=1 */
150:
151: EXCEPTION
152: when others then
153: JTF_DIAGNOSTIC_COREAPI.errorprint('Error: '||sqlerrm);
154: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('If this error repeats, please contact Oracle Support Services');
155: statusStr := 'FAILURE';
156: errStr := sqlerrm ||' occurred in script. ';
157: fixInfo := 'Unexpected Exception in BOMDGECB.pls';

Line 154: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('If this error repeats, please contact Oracle Support Services');

150:
151: EXCEPTION
152: when others then
153: JTF_DIAGNOSTIC_COREAPI.errorprint('Error: '||sqlerrm);
154: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('If this error repeats, please contact Oracle Support Services');
155: statusStr := 'FAILURE';
156: errStr := sqlerrm ||' occurred in script. ';
157: fixInfo := 'Unexpected Exception in BOMDGECB.pls';
158: isFatal := 'FALSE';