APPS.BSC_INVALID_DIM_LVLS_RPT dependencies on JTF_DIAGNOSTIC_COREAPI

Line 31: dummy_v2t JTF_DIAGNOSTIC_COREAPI.v2t;

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

Line 39: h_headers JTF_DIAGNOSTIC_COREAPI.headers;

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

Line 40: h_lengths JTF_DIAGNOSTIC_COREAPI.lengths;

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

Line 57: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;

53: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
54:
55: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
56:
57: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
58:
59: IF cv%ISOPEN THEN
60: CLOSE cv;
61: END IF;

Line 80: JTF_DIAGNOSTIC_COREAPI.BRPrint;

76:
77:
78: h_count := h_pmf_count + h_bsc_count;
79: IF h_count >0 THEN
80: JTF_DIAGNOSTIC_COREAPI.BRPrint;
81: sqltxt := 'SELECT Name "Dimension Object Name", short_name, SOURCE, LEVEL_TABLE_NAME, '||
82: ' LEVEL_VIEW_NAME FROM bsc_sys_dim_levels_vl '||
83: ' WHERE TABLE_TYPE = 1 AND EXISTS (SELECT 1 FROM user_objects '||
84: ' WHERE status=''INVALID'' AND object_name = LEVEL_VIEW_NAME) ';

Line 86: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,BSC_OBJECTIVE_METADATA_SETUP.get_message_name('BSC_INVALID_DIM_LVLS'));

82: ' LEVEL_VIEW_NAME FROM bsc_sys_dim_levels_vl '||
83: ' WHERE TABLE_TYPE = 1 AND EXISTS (SELECT 1 FROM user_objects '||
84: ' WHERE status=''INVALID'' AND object_name = LEVEL_VIEW_NAME) ';
85:
86: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,BSC_OBJECTIVE_METADATA_SETUP.get_message_name('BSC_INVALID_DIM_LVLS'));
87: JTF_DIAGNOSTIC_COREAPI.BRPrint;
88: statusStr := 'FAILURE';
89: errStr := BSC_OBJECTIVE_METADATA_SETUP.get_message_name('BSC_INVALID_DIM_LVLS_F');
90: IF h_pmf_count >0 THEN

Line 87: JTF_DIAGNOSTIC_COREAPI.BRPrint;

83: ' WHERE TABLE_TYPE = 1 AND EXISTS (SELECT 1 FROM user_objects '||
84: ' WHERE status=''INVALID'' AND object_name = LEVEL_VIEW_NAME) ';
85:
86: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,BSC_OBJECTIVE_METADATA_SETUP.get_message_name('BSC_INVALID_DIM_LVLS'));
87: JTF_DIAGNOSTIC_COREAPI.BRPrint;
88: statusStr := 'FAILURE';
89: errStr := BSC_OBJECTIVE_METADATA_SETUP.get_message_name('BSC_INVALID_DIM_LVLS_F');
90: IF h_pmf_count >0 THEN
91: fixInfo := BSC_OBJECTIVE_METADATA_SETUP.get_message_name('BSC_PMF_DIM_LVLS_FIX');

Line 95: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint(fixInfo);

91: fixInfo := BSC_OBJECTIVE_METADATA_SETUP.get_message_name('BSC_PMF_DIM_LVLS_FIX');
92: END IF;
93: fixInfo := fixInfo || BSC_OBJECTIVE_METADATA_SETUP.get_message_name('BSC_BSC_DIM_LVLS_FIX');
94:
95: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint(fixInfo);
96: isFatal := 'FALSE';
97: ELSE
98: statusStr := 'SUCCESS';
99: reportStr := BSC_OBJECTIVE_METADATA_SETUP.get_message_name('BSC_NO_INVLD_VIEWS');

Line 100: JTF_DIAGNOSTIC_COREAPI.Line_out(reportStr);

96: isFatal := 'FALSE';
97: ELSE
98: statusStr := 'SUCCESS';
99: reportStr := BSC_OBJECTIVE_METADATA_SETUP.get_message_name('BSC_NO_INVLD_VIEWS');
100: JTF_DIAGNOSTIC_COREAPI.Line_out(reportStr);
101: JTF_DIAGNOSTIC_COREAPI.BRPrint;
102: END IF;
103: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
104: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;

Line 101: JTF_DIAGNOSTIC_COREAPI.BRPrint;

97: ELSE
98: statusStr := 'SUCCESS';
99: reportStr := BSC_OBJECTIVE_METADATA_SETUP.get_message_name('BSC_NO_INVLD_VIEWS');
100: JTF_DIAGNOSTIC_COREAPI.Line_out(reportStr);
101: JTF_DIAGNOSTIC_COREAPI.BRPrint;
102: END IF;
103: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
104: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
105: END runTest;