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.BOM_DIAGUNITTEST_EXPDATA dependencies on JTF_DIAGNOSTIC_COREAPI

Line 43: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;

39:
40: BEGIN
41: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
42: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
43: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
44:
45: /*Initializing local vars */
46: row_limit :=1000; /* Set Row Limit to 1000 (i.e.) Max Number of records to be fetched by each sql*/
47: l_count := 0;

Line 54: JTF_DIAGNOSTIC_COREAPI.errorprint('Input Item Id is mandatory.');

50: l_org_id := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('OrgId',inputs);
51: l_item_id :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('ItemId',inputs);
52:
53: If l_item_id is NULL then
54: JTF_DIAGNOSTIC_COREAPI.errorprint('Input Item Id is mandatory.');
55: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint(' Please provide a valid value for the Item Id.');
56: statusStr := 'FAILURE';
57: isFatal := 'TRUE';
58: fixInfo := ' Please review the error message below and take corrective action. ';

Line 55: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint(' Please provide a valid value for the Item Id.');

51: l_item_id :=JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('ItemId',inputs);
52:
53: If l_item_id is NULL then
54: JTF_DIAGNOSTIC_COREAPI.errorprint('Input Item Id is mandatory.');
55: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint(' Please provide a valid value for the Item Id.');
56: statusStr := 'FAILURE';
57: isFatal := 'TRUE';
58: fixInfo := ' Please review the error message below and take corrective action. ';
59: errStr := ' Invalid value for input field Item Id. It is a mandatory input.';

Line 70: JTF_DIAGNOSTIC_COREAPI.errorprint('Invalid Item and Organization Combination');

66: FETCH c_item_valid INTO l_count;
67: CLOSE c_item_valid;
68:
69: IF (l_count IS NULL) OR (l_count = 0) THEN
70: JTF_DIAGNOSTIC_COREAPI.errorprint('Invalid Item and Organization Combination');
71: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please enter right combination of Item and Organization ');
72: statusStr := 'FAILURE';
73: errStr := 'Invalid Item and Organization Combination';
74: fixInfo := ' Please review the error message below and take corrective action. ';

Line 71: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please enter right combination of Item and Organization ');

67: CLOSE c_item_valid;
68:
69: IF (l_count IS NULL) OR (l_count = 0) THEN
70: JTF_DIAGNOSTIC_COREAPI.errorprint('Invalid Item and Organization Combination');
71: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('Please enter right combination of Item and Organization ');
72: statusStr := 'FAILURE';
73: errStr := 'Invalid Item and Organization Combination';
74: fixInfo := ' Please review the error message below and take corrective action. ';
75: isFatal := 'TRUE';

Line 85: as an input parameter to JTF_DIAGNOSTIC_COREAPI.Column_Exists API. */

81:
82: /* Start of the diagnostic test script */
83: /* Get the application installation info. References to Data Dictionary Objects without schema name
84: included in WHERE predicate are not allowed (GSCC Check: file.sql.47). Schema name has to be passed
85: as an input parameter to JTF_DIAGNOSTIC_COREAPI.Column_Exists API. */
86:
87: l_ret_status := fnd_installation.get_app_info ('BOM'
88: , l_status
89: , l_industry

Line 93: /JTF_DIAGNOSTIC_COREAPI.Line_Out(' l_oracle_schema: '||l_oracle_schema);/

89: , l_industry
90: , l_oracle_schema
91: );
92:
93: /*JTF_DIAGNOSTIC_COREAPI.Line_Out(' l_oracle_schema: '||l_oracle_schema);*/
94:
95: sqltxt := ' Select '||
96: ' BE.TOP_BILL_SEQUENCE_ID "TOP BILL SEQUENCE ID", '||
97: ' BE.BILL_SEQUENCE_ID "BILL SEQUENCE ID", '||

Line 203: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Bom Explosions Data ');

199: end if;
200:
201: sqltxt := sqltxt || ' and rownum< '||row_limit;
202: sqltxt := sqltxt || ' order by be.organization_id,be.sort_order ';
203: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Bom Explosions Data ');
204: If (num_rows = row_limit -1 ) Then
205: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output of the above table is limited to the first '||(row_limit-1)||' rows to prevent an excessively big output file.
');
206: End If;
207: statusStr := 'SUCCESS';

Line 205: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output of the above table is limited to the first '||(row_limit-1)||' rows to prevent an excessively big output file.
');

201: sqltxt := sqltxt || ' and rownum< '||row_limit;
202: sqltxt := sqltxt || ' order by be.organization_id,be.sort_order ';
203: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Bom Explosions Data ');
204: If (num_rows = row_limit -1 ) Then
205: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output of the above table is limited to the first '||(row_limit-1)||' rows to prevent an excessively big output file.
');
206: End If;
207: statusStr := 'SUCCESS';
208: isFatal := 'FALSE';
209:

Line 211: JTF_DIAGNOSTIC_COREAPI.Line_Out('

This data collection script completed as expected
');

207: statusStr := 'SUCCESS';
208: isFatal := 'FALSE';
209:
210: <>
211: JTF_DIAGNOSTIC_COREAPI.Line_Out('

This data collection script completed as expected
');
212: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
213: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
214:
215: EXCEPTION

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

213: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
214:
215: EXCEPTION
216: when others then
217: JTF_DIAGNOSTIC_COREAPI.errorprint('Error: '||sqlerrm);
218: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('If this error repeats, please contact Oracle Support Services');
219: statusStr := 'FAILURE';
220: errStr := sqlerrm ||' occurred in script. ';
221: fixInfo := 'Unexpected Exception in BOMDGEXB.pls';

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

214:
215: EXCEPTION
216: when others then
217: JTF_DIAGNOSTIC_COREAPI.errorprint('Error: '||sqlerrm);
218: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('If this error repeats, please contact Oracle Support Services');
219: statusStr := 'FAILURE';
220: errStr := sqlerrm ||' occurred in script. ';
221: fixInfo := 'Unexpected Exception in BOMDGEXB.pls';
222: isFatal := 'FALSE';