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

Line 30: dummy_v2t JTF_DIAGNOSTIC_COREAPI.v2t;

26: report OUT NOCOPY JTF_DIAG_REPORT,
27: reportClob OUT NOCOPY CLOB) IS
28: reportStr LONG;
29: counter NUMBER;
30: dummy_v2t JTF_DIAGNOSTIC_COREAPI.v2t;
31: c_userid VARCHAR2(50);
32: statusStr VARCHAR2(50);
33: errStr VARCHAR2(4000);
34: fixInfo VARCHAR2(4000);

Line 38: h_headers JTF_DIAGNOSTIC_COREAPI.headers;

34: fixInfo VARCHAR2(4000);
35: isFatal VARCHAR2(50);
36: dummy_num NUMBER;
37: sqltxt VARCHAR2 (2000);
38: h_headers JTF_DIAGNOSTIC_COREAPI.headers;
39: h_lengths JTF_DIAGNOSTIC_COREAPI.lengths;
40: h_count NUMBER;
41: h_source bsc_sys_dim_levels_b.source%TYPE;
42: h_pmf_count NUMBER;

Line 39: h_lengths JTF_DIAGNOSTIC_COREAPI.lengths;

35: isFatal VARCHAR2(50);
36: dummy_num NUMBER;
37: sqltxt VARCHAR2 (2000);
38: h_headers JTF_DIAGNOSTIC_COREAPI.headers;
39: h_lengths JTF_DIAGNOSTIC_COREAPI.lengths;
40: h_count NUMBER;
41: h_source bsc_sys_dim_levels_b.source%TYPE;
42: h_pmf_count NUMBER;
43: h_bsc_count NUMBER;

Line 53: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;

49: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
50:
51: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
52:
53: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
54:
55: h_module_name := JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Module Name',inputs);
56: BEGIN
57: h_request_id := TO_NUMBER(JTF_DIAGNOSTIC_ADAPTUTIL.getInputValue('Concurrent Request ID',inputs));

Line 75: JTF_DIAGNOSTIC_COREAPI.BRPrint;

71: AND v$session.sid=v$aw_olap.session_id;
72:
73:
74: IF h_count >0 THEN
75: JTF_DIAGNOSTIC_COREAPI.BRPrint;
76: JTF_DIAGNOSTIC_COREAPI.actionprint(BSC_OBJECTIVE_METADATA_SETUP.get_message_name('BSC_AW_LOCK_MSG'));
77:
78: statusStr := 'FAILURE';
79: errStr := BSC_OBJECTIVE_METADATA_SETUP.get_message_name('BSC_AW_LOCK_MSG');

Line 76: JTF_DIAGNOSTIC_COREAPI.actionprint(BSC_OBJECTIVE_METADATA_SETUP.get_message_name('BSC_AW_LOCK_MSG'));

72:
73:
74: IF h_count >0 THEN
75: JTF_DIAGNOSTIC_COREAPI.BRPrint;
76: JTF_DIAGNOSTIC_COREAPI.actionprint(BSC_OBJECTIVE_METADATA_SETUP.get_message_name('BSC_AW_LOCK_MSG'));
77:
78: statusStr := 'FAILURE';
79: errStr := BSC_OBJECTIVE_METADATA_SETUP.get_message_name('BSC_AW_LOCK_MSG');
80:

Line 83: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint(fixInfo);

79: errStr := BSC_OBJECTIVE_METADATA_SETUP.get_message_name('BSC_AW_LOCK_MSG');
80:
81: fixInfo := BSC_OBJECTIVE_METADATA_SETUP.get_message_name('BSC_AW_LOCK_MSG');
82:
83: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint(fixInfo);
84: isFatal := 'FALSE';
85: END IF;
86:
87: IF h_module_name = 'METADATA_OPTIMIZER' THEN

Line 88: JTF_DIAGNOSTIC_COREAPI.BRPrint;

84: isFatal := 'FALSE';
85: END IF;
86:
87: IF h_module_name = 'METADATA_OPTIMIZER' THEN
88: JTF_DIAGNOSTIC_COREAPI.BRPrint;
89: sqltxt := 'SELECT * FROM bsc_tmp_opt_ui_kpis WHERE PROCESS_ID=( SELECT TO_NUMBER(argument2) FROM '||
90: ' fnd_concurrent_requests WHERE request_id ='|| h_request_id ||' )' ;
91:
92: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'BSC_TMP_OPT_UI_KPIS');

Line 92: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'BSC_TMP_OPT_UI_KPIS');

88: JTF_DIAGNOSTIC_COREAPI.BRPrint;
89: sqltxt := 'SELECT * FROM bsc_tmp_opt_ui_kpis WHERE PROCESS_ID=( SELECT TO_NUMBER(argument2) FROM '||
90: ' fnd_concurrent_requests WHERE request_id ='|| h_request_id ||' )' ;
91:
92: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'BSC_TMP_OPT_UI_KPIS');
93:
94: JTF_DIAGNOSTIC_COREAPI.BRPrint;
95: sqltxt := 'SELECT VARIABLE_ID,VALUE_N,VALUE_V FROM BSC_TMP_BIG_IN_COND WHERE VARIABLE_ID = -200 ORDER BY VALUE_N';
96:

Line 94: JTF_DIAGNOSTIC_COREAPI.BRPrint;

90: ' fnd_concurrent_requests WHERE request_id ='|| h_request_id ||' )' ;
91:
92: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'BSC_TMP_OPT_UI_KPIS');
93:
94: JTF_DIAGNOSTIC_COREAPI.BRPrint;
95: sqltxt := 'SELECT VARIABLE_ID,VALUE_N,VALUE_V FROM BSC_TMP_BIG_IN_COND WHERE VARIABLE_ID = -200 ORDER BY VALUE_N';
96:
97: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'BSC_TMP_BIG_IN_COND');
98:

Line 97: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'BSC_TMP_BIG_IN_COND');

93:
94: JTF_DIAGNOSTIC_COREAPI.BRPrint;
95: sqltxt := 'SELECT VARIABLE_ID,VALUE_N,VALUE_V FROM BSC_TMP_BIG_IN_COND WHERE VARIABLE_ID = -200 ORDER BY VALUE_N';
96:
97: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'BSC_TMP_BIG_IN_COND');
98:
99: ELSE
100: JTF_DIAGNOSTIC_COREAPI.BRPrint;
101: sqltxt := 'SELECT * FROM bsc_db_loader_control WHERE PROCESS_ID=( SELECT TO_NUMBER(argument1) FROM '||

Line 100: JTF_DIAGNOSTIC_COREAPI.BRPrint;

96:
97: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'BSC_TMP_BIG_IN_COND');
98:
99: ELSE
100: JTF_DIAGNOSTIC_COREAPI.BRPrint;
101: sqltxt := 'SELECT * FROM bsc_db_loader_control WHERE PROCESS_ID=( SELECT TO_NUMBER(argument1) FROM '||
102: ' fnd_concurrent_requests WHERE request_id ='|| h_request_id ||' )' ;
103: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'BSC_DB_LOADER_CONTROL');
104:

Line 103: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'BSC_DB_LOADER_CONTROL');

99: ELSE
100: JTF_DIAGNOSTIC_COREAPI.BRPrint;
101: sqltxt := 'SELECT * FROM bsc_db_loader_control WHERE PROCESS_ID=( SELECT TO_NUMBER(argument1) FROM '||
102: ' fnd_concurrent_requests WHERE request_id ='|| h_request_id ||' )' ;
103: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'BSC_DB_LOADER_CONTROL');
104:
105: END IF;
106:
107: JTF_DIAGNOSTIC_COREAPI.BRPrint;

Line 107: JTF_DIAGNOSTIC_COREAPI.BRPrint;

103: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,'BSC_DB_LOADER_CONTROL');
104:
105: END IF;
106:
107: JTF_DIAGNOSTIC_COREAPI.BRPrint;
108: statusStr := 'WARNING';
109: errStr := BSC_OBJECTIVE_METADATA_SETUP.get_message_name('BSC_NEED_INVESTIGATION');
110:
111: fixInfo := BSC_OBJECTIVE_METADATA_SETUP.get_message_name('BSC_GEN_CONC_TRC');

Line 112: JTF_DIAGNOSTIC_COREAPI.BRPrint;

108: statusStr := 'WARNING';
109: errStr := BSC_OBJECTIVE_METADATA_SETUP.get_message_name('BSC_NEED_INVESTIGATION');
110:
111: fixInfo := BSC_OBJECTIVE_METADATA_SETUP.get_message_name('BSC_GEN_CONC_TRC');
112: JTF_DIAGNOSTIC_COREAPI.BRPrint;
113: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint(fixInfo);
114: isFatal := 'FALSE';
115: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
116: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

Line 113: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint(fixInfo);

109: errStr := BSC_OBJECTIVE_METADATA_SETUP.get_message_name('BSC_NEED_INVESTIGATION');
110:
111: fixInfo := BSC_OBJECTIVE_METADATA_SETUP.get_message_name('BSC_GEN_CONC_TRC');
112: JTF_DIAGNOSTIC_COREAPI.BRPrint;
113: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint(fixInfo);
114: isFatal := 'FALSE';
115: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
116: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
117: EXCEPTION

Line 123: JTF_DIAGNOSTIC_COREAPI.BRPrint;

119: statusStr := 'FAILURE';
120: errStr := SQLERRM;
121:
122: fixInfo := SQLERRM;
123: JTF_DIAGNOSTIC_COREAPI.BRPrint;
124: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint(fixInfo);
125: isFatal := 'FALSE';
126: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
127: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

Line 124: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint(fixInfo);

120: errStr := SQLERRM;
121:
122: fixInfo := SQLERRM;
123: JTF_DIAGNOSTIC_COREAPI.BRPrint;
124: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint(fixInfo);
125: isFatal := 'FALSE';
126: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
127: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
128: END runTest;