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

Line 54: dummy_v2t JTF_DIAGNOSTIC_COREAPI.v2t;

50: reportClob OUT NOCOPY CLOB)
51: IS
52: reportStr LONG;
53: counter NUMBER;
54: dummy_v2t JTF_DIAGNOSTIC_COREAPI.v2t;
55: c_userid VARCHAR2(50);
56: statusStr VARCHAR2(50);
57: errStr VARCHAR2(4000);
58: fixInfo VARCHAR2(4000); isFatal VARCHAR2(50);

Line 67: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;

63: l_num_rows NUMBER;
64: BEGIN
65: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
66: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
67: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
68: -- JTF_DIAGNOSTIC_COREAPI.line_out('this also writes to the clob');
69: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
70: -- JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('String into report');
71: l_apps_version := JTF_DIAGNOSTIC_COREAPI.Get_DB_Apps_Version;

Line 68: -- JTF_DIAGNOSTIC_COREAPI.line_out('this also writes to the clob');

64: BEGIN
65: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
66: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
67: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
68: -- JTF_DIAGNOSTIC_COREAPI.line_out('this also writes to the clob');
69: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
70: -- JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('String into report');
71: l_apps_version := JTF_DIAGNOSTIC_COREAPI.Get_DB_Apps_Version;
72: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(fnd_message.get_string('BIS', 'BIS_DIAG_APPS_VERSION') || ': ' || l_apps_version);

Line 71: l_apps_version := JTF_DIAGNOSTIC_COREAPI.Get_DB_Apps_Version;

67: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
68: -- JTF_DIAGNOSTIC_COREAPI.line_out('this also writes to the clob');
69: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
70: -- JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('String into report');
71: l_apps_version := JTF_DIAGNOSTIC_COREAPI.Get_DB_Apps_Version;
72: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(fnd_message.get_string('BIS', 'BIS_DIAG_APPS_VERSION') || ': ' || l_apps_version);
73: JTF_DIAGNOSTIC_COREAPI.BRPrint;
74: l_db_version := JTF_DIAGNOSTIC_COREAPI.Get_RDBMS_Header;
75: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(fnd_message.get_string('BIS', 'BIS_DIAG_DB_VERSION') || ': ' || l_db_version);

Line 73: JTF_DIAGNOSTIC_COREAPI.BRPrint;

69: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(reportClob,reportStr);
70: -- JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('String into report');
71: l_apps_version := JTF_DIAGNOSTIC_COREAPI.Get_DB_Apps_Version;
72: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(fnd_message.get_string('BIS', 'BIS_DIAG_APPS_VERSION') || ': ' || l_apps_version);
73: JTF_DIAGNOSTIC_COREAPI.BRPrint;
74: l_db_version := JTF_DIAGNOSTIC_COREAPI.Get_RDBMS_Header;
75: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(fnd_message.get_string('BIS', 'BIS_DIAG_DB_VERSION') || ': ' || l_db_version);
76: JTF_DIAGNOSTIC_COREAPI.BRPrint;
77: l_num_rows := JTF_DIAGNOSTIC_COREAPI.Display_SQL('SELECT patch_level FROM fnd_product_installations WHERE patch_level LIKE ''%BIS%''', 'BIS Version', 'Y', 'Y', null, 0);

Line 74: l_db_version := JTF_DIAGNOSTIC_COREAPI.Get_RDBMS_Header;

70: -- JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('String into report');
71: l_apps_version := JTF_DIAGNOSTIC_COREAPI.Get_DB_Apps_Version;
72: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(fnd_message.get_string('BIS', 'BIS_DIAG_APPS_VERSION') || ': ' || l_apps_version);
73: JTF_DIAGNOSTIC_COREAPI.BRPrint;
74: l_db_version := JTF_DIAGNOSTIC_COREAPI.Get_RDBMS_Header;
75: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(fnd_message.get_string('BIS', 'BIS_DIAG_DB_VERSION') || ': ' || l_db_version);
76: JTF_DIAGNOSTIC_COREAPI.BRPrint;
77: l_num_rows := JTF_DIAGNOSTIC_COREAPI.Display_SQL('SELECT patch_level FROM fnd_product_installations WHERE patch_level LIKE ''%BIS%''', 'BIS Version', 'Y', 'Y', null, 0);
78: l_num_rows := JTF_DIAGNOSTIC_COREAPI.Display_SQL('SELECT decode(bug_number,''5404886'',''DBI 7.3: 11i.BIS_PF.G: 5404886'',''5565583'',''DBI 7.4: 11i.BIS_PF.H: 5565583'',''4458359'',''DBI 8.0: R12.BIS_PF.A: 4458359'') ' ||

Line 76: JTF_DIAGNOSTIC_COREAPI.BRPrint;

72: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(fnd_message.get_string('BIS', 'BIS_DIAG_APPS_VERSION') || ': ' || l_apps_version);
73: JTF_DIAGNOSTIC_COREAPI.BRPrint;
74: l_db_version := JTF_DIAGNOSTIC_COREAPI.Get_RDBMS_Header;
75: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(fnd_message.get_string('BIS', 'BIS_DIAG_DB_VERSION') || ': ' || l_db_version);
76: JTF_DIAGNOSTIC_COREAPI.BRPrint;
77: l_num_rows := JTF_DIAGNOSTIC_COREAPI.Display_SQL('SELECT patch_level FROM fnd_product_installations WHERE patch_level LIKE ''%BIS%''', 'BIS Version', 'Y', 'Y', null, 0);
78: l_num_rows := JTF_DIAGNOSTIC_COREAPI.Display_SQL('SELECT decode(bug_number,''5404886'',''DBI 7.3: 11i.BIS_PF.G: 5404886'',''5565583'',''DBI 7.4: 11i.BIS_PF.H: 5565583'',''4458359'',''DBI 8.0: R12.BIS_PF.A: 4458359'') ' ||
79: ' "Current DBI Family Pack level:" FROM ad_bugs WHERE bug_number IN (''5404886'',''5565583'',''4458359'')', 'DBI Version', 'Y', 'Y', null, 0);
80: l_num_rows := JTF_DIAGNOSTIC_COREAPI.Display_SQL('SELECT object_name, object_type FROM user_objects WHERE object_name LIKE ''BIS%'' AND status = ''INVALID''', 'Invalid Packages', 'Y', 'Y', null, 0);

Line 77: l_num_rows := JTF_DIAGNOSTIC_COREAPI.Display_SQL('SELECT patch_level FROM fnd_product_installations WHERE patch_level LIKE ''%BIS%''', 'BIS Version', 'Y', 'Y', null, 0);

73: JTF_DIAGNOSTIC_COREAPI.BRPrint;
74: l_db_version := JTF_DIAGNOSTIC_COREAPI.Get_RDBMS_Header;
75: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(fnd_message.get_string('BIS', 'BIS_DIAG_DB_VERSION') || ': ' || l_db_version);
76: JTF_DIAGNOSTIC_COREAPI.BRPrint;
77: l_num_rows := JTF_DIAGNOSTIC_COREAPI.Display_SQL('SELECT patch_level FROM fnd_product_installations WHERE patch_level LIKE ''%BIS%''', 'BIS Version', 'Y', 'Y', null, 0);
78: l_num_rows := JTF_DIAGNOSTIC_COREAPI.Display_SQL('SELECT decode(bug_number,''5404886'',''DBI 7.3: 11i.BIS_PF.G: 5404886'',''5565583'',''DBI 7.4: 11i.BIS_PF.H: 5565583'',''4458359'',''DBI 8.0: R12.BIS_PF.A: 4458359'') ' ||
79: ' "Current DBI Family Pack level:" FROM ad_bugs WHERE bug_number IN (''5404886'',''5565583'',''4458359'')', 'DBI Version', 'Y', 'Y', null, 0);
80: l_num_rows := JTF_DIAGNOSTIC_COREAPI.Display_SQL('SELECT object_name, object_type FROM user_objects WHERE object_name LIKE ''BIS%'' AND status = ''INVALID''', 'Invalid Packages', 'Y', 'Y', null, 0);
81: JTF_DIAGNOSTIC_COREAPI.BRPrint;

Line 78: l_num_rows := JTF_DIAGNOSTIC_COREAPI.Display_SQL('SELECT decode(bug_number,''5404886'',''DBI 7.3: 11i.BIS_PF.G: 5404886'',''5565583'',''DBI 7.4: 11i.BIS_PF.H: 5565583'',''4458359'',''DBI 8.0: R12.BIS_PF.A: 4458359'') ' ||

74: l_db_version := JTF_DIAGNOSTIC_COREAPI.Get_RDBMS_Header;
75: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport(fnd_message.get_string('BIS', 'BIS_DIAG_DB_VERSION') || ': ' || l_db_version);
76: JTF_DIAGNOSTIC_COREAPI.BRPrint;
77: l_num_rows := JTF_DIAGNOSTIC_COREAPI.Display_SQL('SELECT patch_level FROM fnd_product_installations WHERE patch_level LIKE ''%BIS%''', 'BIS Version', 'Y', 'Y', null, 0);
78: l_num_rows := JTF_DIAGNOSTIC_COREAPI.Display_SQL('SELECT decode(bug_number,''5404886'',''DBI 7.3: 11i.BIS_PF.G: 5404886'',''5565583'',''DBI 7.4: 11i.BIS_PF.H: 5565583'',''4458359'',''DBI 8.0: R12.BIS_PF.A: 4458359'') ' ||
79: ' "Current DBI Family Pack level:" FROM ad_bugs WHERE bug_number IN (''5404886'',''5565583'',''4458359'')', 'DBI Version', 'Y', 'Y', null, 0);
80: l_num_rows := JTF_DIAGNOSTIC_COREAPI.Display_SQL('SELECT object_name, object_type FROM user_objects WHERE object_name LIKE ''BIS%'' AND status = ''INVALID''', 'Invalid Packages', 'Y', 'Y', null, 0);
81: JTF_DIAGNOSTIC_COREAPI.BRPrint;
82: JTF_DIAGNOSTIC_COREAPI.ActionPrint(fnd_message.get_string('BIS', 'BIS_DIAG_TESTCASE_FIX_INFO'));

Line 80: l_num_rows := JTF_DIAGNOSTIC_COREAPI.Display_SQL('SELECT object_name, object_type FROM user_objects WHERE object_name LIKE ''BIS%'' AND status = ''INVALID''', 'Invalid Packages', 'Y', 'Y', null, 0);

76: JTF_DIAGNOSTIC_COREAPI.BRPrint;
77: l_num_rows := JTF_DIAGNOSTIC_COREAPI.Display_SQL('SELECT patch_level FROM fnd_product_installations WHERE patch_level LIKE ''%BIS%''', 'BIS Version', 'Y', 'Y', null, 0);
78: l_num_rows := JTF_DIAGNOSTIC_COREAPI.Display_SQL('SELECT decode(bug_number,''5404886'',''DBI 7.3: 11i.BIS_PF.G: 5404886'',''5565583'',''DBI 7.4: 11i.BIS_PF.H: 5565583'',''4458359'',''DBI 8.0: R12.BIS_PF.A: 4458359'') ' ||
79: ' "Current DBI Family Pack level:" FROM ad_bugs WHERE bug_number IN (''5404886'',''5565583'',''4458359'')', 'DBI Version', 'Y', 'Y', null, 0);
80: l_num_rows := JTF_DIAGNOSTIC_COREAPI.Display_SQL('SELECT object_name, object_type FROM user_objects WHERE object_name LIKE ''BIS%'' AND status = ''INVALID''', 'Invalid Packages', 'Y', 'Y', null, 0);
81: JTF_DIAGNOSTIC_COREAPI.BRPrint;
82: JTF_DIAGNOSTIC_COREAPI.ActionPrint(fnd_message.get_string('BIS', 'BIS_DIAG_TESTCASE_FIX_INFO'));
83: statusStr := 'SUCCESS';
84: -- JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('You better do something!');

Line 81: JTF_DIAGNOSTIC_COREAPI.BRPrint;

77: l_num_rows := JTF_DIAGNOSTIC_COREAPI.Display_SQL('SELECT patch_level FROM fnd_product_installations WHERE patch_level LIKE ''%BIS%''', 'BIS Version', 'Y', 'Y', null, 0);
78: l_num_rows := JTF_DIAGNOSTIC_COREAPI.Display_SQL('SELECT decode(bug_number,''5404886'',''DBI 7.3: 11i.BIS_PF.G: 5404886'',''5565583'',''DBI 7.4: 11i.BIS_PF.H: 5565583'',''4458359'',''DBI 8.0: R12.BIS_PF.A: 4458359'') ' ||
79: ' "Current DBI Family Pack level:" FROM ad_bugs WHERE bug_number IN (''5404886'',''5565583'',''4458359'')', 'DBI Version', 'Y', 'Y', null, 0);
80: l_num_rows := JTF_DIAGNOSTIC_COREAPI.Display_SQL('SELECT object_name, object_type FROM user_objects WHERE object_name LIKE ''BIS%'' AND status = ''INVALID''', 'Invalid Packages', 'Y', 'Y', null, 0);
81: JTF_DIAGNOSTIC_COREAPI.BRPrint;
82: JTF_DIAGNOSTIC_COREAPI.ActionPrint(fnd_message.get_string('BIS', 'BIS_DIAG_TESTCASE_FIX_INFO'));
83: statusStr := 'SUCCESS';
84: -- JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('You better do something!');
85: errStr := '';

Line 82: JTF_DIAGNOSTIC_COREAPI.ActionPrint(fnd_message.get_string('BIS', 'BIS_DIAG_TESTCASE_FIX_INFO'));

78: l_num_rows := JTF_DIAGNOSTIC_COREAPI.Display_SQL('SELECT decode(bug_number,''5404886'',''DBI 7.3: 11i.BIS_PF.G: 5404886'',''5565583'',''DBI 7.4: 11i.BIS_PF.H: 5565583'',''4458359'',''DBI 8.0: R12.BIS_PF.A: 4458359'') ' ||
79: ' "Current DBI Family Pack level:" FROM ad_bugs WHERE bug_number IN (''5404886'',''5565583'',''4458359'')', 'DBI Version', 'Y', 'Y', null, 0);
80: l_num_rows := JTF_DIAGNOSTIC_COREAPI.Display_SQL('SELECT object_name, object_type FROM user_objects WHERE object_name LIKE ''BIS%'' AND status = ''INVALID''', 'Invalid Packages', 'Y', 'Y', null, 0);
81: JTF_DIAGNOSTIC_COREAPI.BRPrint;
82: JTF_DIAGNOSTIC_COREAPI.ActionPrint(fnd_message.get_string('BIS', 'BIS_DIAG_TESTCASE_FIX_INFO'));
83: statusStr := 'SUCCESS';
84: -- JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('You better do something!');
85: errStr := '';
86: fixInfo := '';

Line 84: -- JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('You better do something!');

80: l_num_rows := JTF_DIAGNOSTIC_COREAPI.Display_SQL('SELECT object_name, object_type FROM user_objects WHERE object_name LIKE ''BIS%'' AND status = ''INVALID''', 'Invalid Packages', 'Y', 'Y', null, 0);
81: JTF_DIAGNOSTIC_COREAPI.BRPrint;
82: JTF_DIAGNOSTIC_COREAPI.ActionPrint(fnd_message.get_string('BIS', 'BIS_DIAG_TESTCASE_FIX_INFO'));
83: statusStr := 'SUCCESS';
84: -- JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint('You better do something!');
85: errStr := '';
86: fixInfo := '';
87: isFatal := 'FALSE';
88: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);