DBA Data[Home] [Help]

APPS.BOM_DIAGUNITTEST_CATHLCHK dependencies on JTF_DIAGNOSTIC_COREAPI

Line 36: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;

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

Line 44: -- JTF_DIAGNOSTIC_COREAPI.Line_Out('
Script Selected: '||l_script);

40:
41: -- accept input
42: l_script := nvl(upper(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Script',inputs)),'ALL');
43:
44: -- JTF_DIAGNOSTIC_COREAPI.Line_Out('
Script Selected: '||l_script);
45:
46: /* l_script is NOT a mandatory input. If it is not entered, then run all the scripts.
47: However if a script name is entered, then validate it for existence. */
48:

Line 50: JTF_DIAGNOSTIC_COREAPI.errorprint('Invalid Script Name');

46: /* l_script is NOT a mandatory input. If it is not entered, then run all the scripts.
47: However if a script name is entered, then validate it for existence. */
48:
49: If l_script not in ('MULT_CAT','SEED_CAT','ALL') Then
50: JTF_DIAGNOSTIC_COREAPI.errorprint('Invalid Script Name');
51: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please choose a Script Name from the Lov or leave the field blank.');
52: statusStr := 'FAILURE';
53: isFatal := 'TRUE';
54: fixInfo := ' Please review the error message below and take corrective action.';

Line 51: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please choose a Script Name from the Lov or leave the field blank.');

47: However if a script name is entered, then validate it for existence. */
48:
49: If l_script not in ('MULT_CAT','SEED_CAT','ALL') Then
50: JTF_DIAGNOSTIC_COREAPI.errorprint('Invalid Script Name');
51: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please choose a Script Name from the Lov or leave the field blank.');
52: statusStr := 'FAILURE';
53: isFatal := 'TRUE';
54: fixInfo := ' Please review the error message below and take corrective action.';
55: errStr := ' Invalid value for input field Script ';

Line 90: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Multiple Item Category Assignments exists for Category Sets which do not allow multiple assignments.');

86: ' having count(*) > 1 '||
87: ' order by mcsv.category_set_name,mp.organization_code,mif.padded_item_number '||
88: ' ) where rownum < '||row_limit;
89:
90: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Multiple Item Category Assignments exists for Category Sets which do not allow multiple assignments.');
91:
92: If (num_rows = 0) Then /* Corrupt Data Found for this case*/
93: JTF_DIAGNOSTIC_COREAPI.Line_Out('No corrupt data found for this case.

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

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

');

89:
90: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Multiple Item Category Assignments exists for Category Sets which do not allow multiple assignments.');
91:
92: If (num_rows = 0) Then /* Corrupt Data Found for this case*/
93: JTF_DIAGNOSTIC_COREAPI.Line_Out('No corrupt data found for this case.

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

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

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

');
94: ElsIf (num_rows > 0) Then /* Show Impact and Action only if rows are returned */
95: If (num_rows = row_limit -1 ) Then
96: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output of the above table is limited to the first '||(row_limit-1)||' rows
97:
to prevent an excessively big output file.
');
98: End If;
99: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Please note that this script is run for all the organizations.
');
100: JTF_DIAGNOSTIC_COREAPI.Line_Out('
IMPACT:

Line 99: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Please note that this script is run for all the organizations.
');

95: If (num_rows = row_limit -1 ) Then
96: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output of the above table is limited to the first '||(row_limit-1)||' rows
97:
to prevent an excessively big output file.
');
98: End If;
99: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Please note that this script is run for all the organizations.
');
100: JTF_DIAGNOSTIC_COREAPI.Line_Out('
IMPACT:
101:
This affects inventory transactions , POs, Quotations, iProcurement, Costing etc
102:
as all these modules assume a single category for an item
103:
for their respective functional area category set. ');

Line 100: JTF_DIAGNOSTIC_COREAPI.Line_Out('
IMPACT:

96: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output of the above table is limited to the first '||(row_limit-1)||' rows
97:
to prevent an excessively big output file.
');
98: End If;
99: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Please note that this script is run for all the organizations.
');
100: JTF_DIAGNOSTIC_COREAPI.Line_Out('
IMPACT:
101:
This affects inventory transactions , POs, Quotations, iProcurement, Costing etc
102:
as all these modules assume a single category for an item
103:
for their respective functional area category set. ');
104:

Line 135: JTF_DIAGNOSTIC_COREAPI.BRPrint;

131:
132: statusStr := 'SUCCESS';
133: isFatal := 'FALSE';
134:
135: JTF_DIAGNOSTIC_COREAPI.BRPrint;
136: End If; /* End of l_script */
137: /* End of Script 1 */
138:
139: /* Script 2 - Check whether seeded Category set id 5,11,12 are attached to structures other than

Line 165: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Seeded Category Sets with invalid structure code ');

161: ' and fifsv.id_flex_structure_code <> ''CARTONIZATION'' '||
162: ' ) '||
163: ' ) ';
164:
165: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Seeded Category Sets with invalid structure code ');
166:
167: If (num_rows = 0) Then /* Corrupt Data Found for this case*/
168: JTF_DIAGNOSTIC_COREAPI.Line_Out('No corrupt data found for this case.

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

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

');

164:
165: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Seeded Category Sets with invalid structure code ');
166:
167: If (num_rows = 0) Then /* Corrupt Data Found for this case*/
168: JTF_DIAGNOSTIC_COREAPI.Line_Out('No corrupt data found for this case.

');
169: ElsIf (num_rows > 0) Then /* Show Impact and Action only if rows are returned */
170: /*It is not required to check if num_rows = (row_limit-1) since the output of this query
171: can atmost be 3 records only. */
172: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Seeded Category Sets -

Line 172: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Seeded Category Sets -

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

');
169: ElsIf (num_rows > 0) Then /* Show Impact and Action only if rows are returned */
170: /*It is not required to check if num_rows = (row_limit-1) since the output of this query
171: can atmost be 3 records only. */
172: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Seeded Category Sets -
173:
''Sales and Marketing'' (category set id = 5) should be attached
174:
to Structure code ''SALES_CATEGORIES'' only.
175:
''Contained Item'' (category set id = 11) and ''Container Item'' (category set id = 12)
176:
should be attached to Structure code ''CARTONIZATION'' only. ');

Line 178: JTF_DIAGNOSTIC_COREAPI.Line_Out('

IMPACT:

174:
to Structure code ''SALES_CATEGORIES'' only.
175:
''Contained Item'' (category set id = 11) and ''Container Item'' (category set id = 12)
176:
should be attached to Structure code ''CARTONIZATION'' only. ');
177:
178: JTF_DIAGNOSTIC_COREAPI.Line_Out('

IMPACT:
179:
User defined category set overwrites the seeded category set values
180:
thus causing data corruption.
181:
Some upgrade scripts fail with unique constraint violation error.');
182:

Line 264: JTF_DIAGNOSTIC_COREAPI.BRPrint;

260:
261: statusStr := 'SUCCESS';
262: isFatal := 'FALSE';
263:
264: JTF_DIAGNOSTIC_COREAPI.BRPrint;
265: End If; /* End of l_script */
266: /* End of script 2*/
267:
268: <>

Line 269: JTF_DIAGNOSTIC_COREAPI.Line_Out('

This Health Check test completed as expected
');

265: End If; /* End of l_script */
266: /* End of script 2*/
267:
268: <>
269: JTF_DIAGNOSTIC_COREAPI.Line_Out('

This Health Check test completed as expected
');
270: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
271: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
272:
273: EXCEPTION

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

271: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
272:
273: EXCEPTION
274: when others then
275: JTF_DIAGNOSTIC_COREAPI.errorprint('Error: '||sqlerrm);
276: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('If this error repeats, please contact Oracle Support Services');
277: statusStr := 'FAILURE';
278: errStr := sqlerrm ||' occurred in script. ';
279: fixInfo := 'Unexpected Exception in BOMDGICB.pls';

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

272:
273: EXCEPTION
274: when others then
275: JTF_DIAGNOSTIC_COREAPI.errorprint('Error: '||sqlerrm);
276: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('If this error repeats, please contact Oracle Support Services');
277: statusStr := 'FAILURE';
278: errStr := sqlerrm ||' occurred in script. ';
279: fixInfo := 'Unexpected Exception in BOMDGICB.pls';
280: isFatal := 'FALSE';