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_TIME_DIM_TEST dependencies on BSC_OBJECTIVE_METADATA_SETUP

Line 65: JTF_DIAGNOSTIC_COREAPI.Line_out(BSC_OBJECTIVE_METADATA_SETUP.get_message_name('BSC_FII_DATA_CHK'));

61: JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;
62:
63: --Check FII tables first, if there is any data
64: SELECT COUNT(1) INTO h_fii_cnt FROM FII_TIME_DAY;
65: JTF_DIAGNOSTIC_COREAPI.Line_out(BSC_OBJECTIVE_METADATA_SETUP.get_message_name('BSC_FII_DATA_CHK'));
66:
67: IF h_fii_cnt = 0 THEN
68: JTF_DIAGNOSTIC_COREAPI.BRPrint;
69:

Line 70: errStr := BSC_OBJECTIVE_METADATA_SETUP.get_message_name('BSC_FII_NO_DATA');

66:
67: IF h_fii_cnt = 0 THEN
68: JTF_DIAGNOSTIC_COREAPI.BRPrint;
69:
70: errStr := BSC_OBJECTIVE_METADATA_SETUP.get_message_name('BSC_FII_NO_DATA');
71:
72: JTF_DIAGNOSTIC_COREAPI.actionerrorprint(errStr);
73:
74: statusStr := 'FAILURE';

Line 81: JTF_DIAGNOSTIC_COREAPI.Line_out(BSC_OBJECTIVE_METADATA_SETUP.get_message_name('BSC_PER_DANG_CHK'));

77:
78: isFatal := 'FALSE';
79: END IF;
80: JTF_DIAGNOSTIC_COREAPI.BRPrint;
81: JTF_DIAGNOSTIC_COREAPI.Line_out(BSC_OBJECTIVE_METADATA_SETUP.get_message_name('BSC_PER_DANG_CHK'));
82:
83: IF check_dangling_records THEN
84: JTF_DIAGNOSTIC_COREAPI.BRPrint;
85: JTF_DIAGNOSTIC_COREAPI.Line_out(BSC_OBJECTIVE_METADATA_SETUP.get_message_name('BSC_PER_DANG_CORRECT'));

Line 85: JTF_DIAGNOSTIC_COREAPI.Line_out(BSC_OBJECTIVE_METADATA_SETUP.get_message_name('BSC_PER_DANG_CORRECT'));

81: JTF_DIAGNOSTIC_COREAPI.Line_out(BSC_OBJECTIVE_METADATA_SETUP.get_message_name('BSC_PER_DANG_CHK'));
82:
83: IF check_dangling_records THEN
84: JTF_DIAGNOSTIC_COREAPI.BRPrint;
85: JTF_DIAGNOSTIC_COREAPI.Line_out(BSC_OBJECTIVE_METADATA_SETUP.get_message_name('BSC_PER_DANG_CORRECT'));
86: correct_dangling_records;
87: JTF_DIAGNOSTIC_COREAPI.BRPrint;
88: errStr := BSC_OBJECTIVE_METADATA_SETUP.get_message_name('BSC_PER_DANG_FOUND');
89: statusStr := 'FAILURE';

Line 88: errStr := BSC_OBJECTIVE_METADATA_SETUP.get_message_name('BSC_PER_DANG_FOUND');

84: JTF_DIAGNOSTIC_COREAPI.BRPrint;
85: JTF_DIAGNOSTIC_COREAPI.Line_out(BSC_OBJECTIVE_METADATA_SETUP.get_message_name('BSC_PER_DANG_CORRECT'));
86: correct_dangling_records;
87: JTF_DIAGNOSTIC_COREAPI.BRPrint;
88: errStr := BSC_OBJECTIVE_METADATA_SETUP.get_message_name('BSC_PER_DANG_FOUND');
89: statusStr := 'FAILURE';
90: fixInfo := BSC_OBJECTIVE_METADATA_SETUP.get_message_name('BSC_PER_DANG_FIX');
91: isFatal := 'FALSE';
92: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);

Line 90: fixInfo := BSC_OBJECTIVE_METADATA_SETUP.get_message_name('BSC_PER_DANG_FIX');

86: correct_dangling_records;
87: JTF_DIAGNOSTIC_COREAPI.BRPrint;
88: errStr := BSC_OBJECTIVE_METADATA_SETUP.get_message_name('BSC_PER_DANG_FOUND');
89: statusStr := 'FAILURE';
90: fixInfo := BSC_OBJECTIVE_METADATA_SETUP.get_message_name('BSC_PER_DANG_FIX');
91: isFatal := 'FALSE';
92: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
93: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
94: RETURN ;

Line 97: JTF_DIAGNOSTIC_COREAPI.Line_out(BSC_OBJECTIVE_METADATA_SETUP.get_message_name('BSC_TIME_DIM_INDEX'));

93: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
94: RETURN ;
95: END IF;
96: JTF_DIAGNOSTIC_COREAPI.BRPrint;
97: JTF_DIAGNOSTIC_COREAPI.Line_out(BSC_OBJECTIVE_METADATA_SETUP.get_message_name('BSC_TIME_DIM_INDEX'));
98:
99: SELECT COUNT(1) INTO h_count FROM all_indexes
100: WHERE index_name = 'BSC_DB_CALENDAR_U1'
101: AND OWNER = l_oracle_schema;

Line 104: JTF_DIAGNOSTIC_COREAPI.Line_out(BSC_OBJECTIVE_METADATA_SETUP.get_message_name('BSC_TIMED_IND_FOUND'));

100: WHERE index_name = 'BSC_DB_CALENDAR_U1'
101: AND OWNER = l_oracle_schema;
102:
103: IF h_count > 0 THEN
104: JTF_DIAGNOSTIC_COREAPI.Line_out(BSC_OBJECTIVE_METADATA_SETUP.get_message_name('BSC_TIMED_IND_FOUND'));
105: JTF_DIAGNOSTIC_COREAPI.BRPrint;
106: errStr := BSC_OBJECTIVE_METADATA_SETUP.get_message_name('BSC_TIMED_IND_FOUND');
107: statusStr := 'FAILURE';
108: fixInfo := BSC_OBJECTIVE_METADATA_SETUP.get_message_name('BSC_TIMED_IND_FIX');

Line 106: errStr := BSC_OBJECTIVE_METADATA_SETUP.get_message_name('BSC_TIMED_IND_FOUND');

102:
103: IF h_count > 0 THEN
104: JTF_DIAGNOSTIC_COREAPI.Line_out(BSC_OBJECTIVE_METADATA_SETUP.get_message_name('BSC_TIMED_IND_FOUND'));
105: JTF_DIAGNOSTIC_COREAPI.BRPrint;
106: errStr := BSC_OBJECTIVE_METADATA_SETUP.get_message_name('BSC_TIMED_IND_FOUND');
107: statusStr := 'FAILURE';
108: fixInfo := BSC_OBJECTIVE_METADATA_SETUP.get_message_name('BSC_TIMED_IND_FIX');
109: isFatal := 'FALSE';
110: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);

Line 108: fixInfo := BSC_OBJECTIVE_METADATA_SETUP.get_message_name('BSC_TIMED_IND_FIX');

104: JTF_DIAGNOSTIC_COREAPI.Line_out(BSC_OBJECTIVE_METADATA_SETUP.get_message_name('BSC_TIMED_IND_FOUND'));
105: JTF_DIAGNOSTIC_COREAPI.BRPrint;
106: errStr := BSC_OBJECTIVE_METADATA_SETUP.get_message_name('BSC_TIMED_IND_FOUND');
107: statusStr := 'FAILURE';
108: fixInfo := BSC_OBJECTIVE_METADATA_SETUP.get_message_name('BSC_TIMED_IND_FIX');
109: isFatal := 'FALSE';
110: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);
111: reportClob := JTF_DIAGNOSTIC_ADAPTUTIL.getReportClob;
112: RETURN ;

Line 117: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,BSC_OBJECTIVE_METADATA_SETUP.get_message_name('BSC_DBI_CAL_METADATA'));

113: END IF;
114:
115: sqltxt := 'SELECT start_month||''/''||start_day||''/''||current_year "START_DATE",edw_calendar_id FROM'||
116: ' bsc_sys_calendars_b WHERE edw_calendar_type_id=1 AND edw_calendar_id IN (1001,1002,1003)';
117: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,BSC_OBJECTIVE_METADATA_SETUP.get_message_name('BSC_DBI_CAL_METADATA'));
118:
119: statusStr := 'WARNING';
120: errStr := BSC_OBJECTIVE_METADATA_SETUP.get_message_name('BSC_NEED_INVESTIGATION');
121:

Line 120: errStr := BSC_OBJECTIVE_METADATA_SETUP.get_message_name('BSC_NEED_INVESTIGATION');

116: ' bsc_sys_calendars_b WHERE edw_calendar_type_id=1 AND edw_calendar_id IN (1001,1002,1003)';
117: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt,BSC_OBJECTIVE_METADATA_SETUP.get_message_name('BSC_DBI_CAL_METADATA'));
118:
119: statusStr := 'WARNING';
120: errStr := BSC_OBJECTIVE_METADATA_SETUP.get_message_name('BSC_NEED_INVESTIGATION');
121:
122: fixInfo := BSC_OBJECTIVE_METADATA_SETUP.get_message_name('BSC_TIMED_DATA_UPLOAD');
123: JTF_DIAGNOSTIC_COREAPI.BRPrint;
124: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint(fixInfo);

Line 122: fixInfo := BSC_OBJECTIVE_METADATA_SETUP.get_message_name('BSC_TIMED_DATA_UPLOAD');

118:
119: statusStr := 'WARNING';
120: errStr := BSC_OBJECTIVE_METADATA_SETUP.get_message_name('BSC_NEED_INVESTIGATION');
121:
122: fixInfo := BSC_OBJECTIVE_METADATA_SETUP.get_message_name('BSC_TIMED_DATA_UPLOAD');
123: JTF_DIAGNOSTIC_COREAPI.BRPrint;
124: JTF_DIAGNOSTIC_COREAPI.ActionErrorPrint(fixInfo);
125: isFatal := 'FALSE';
126: report := JTF_DIAGNOSTIC_ADAPTUTIL.constructReport(statusStr,errStr,fixInfo,isFatal);

Line 135: name := BSC_OBJECTIVE_METADATA_SETUP.get_message_name('BSC_GEN_HEALTH_CHECK');

131: -- procedure to report name back to framework
132: ------------------------------------------------------------
133: PROCEDURE getComponentName(name OUT NOCOPY VARCHAR2) IS
134: BEGIN
135: name := BSC_OBJECTIVE_METADATA_SETUP.get_message_name('BSC_GEN_HEALTH_CHECK');
136: END getComponentName;
137:
138: ------------------------------------------------------------
139: -- procedure to report test description back to framework

Line 143: descStr := BSC_OBJECTIVE_METADATA_SETUP.get_message_name('BSC_TIME_DIM_TDESC');

139: -- procedure to report test description back to framework
140: ------------------------------------------------------------
141: PROCEDURE getTestDesc(descStr OUT NOCOPY VARCHAR2) IS
142: BEGIN
143: descStr := BSC_OBJECTIVE_METADATA_SETUP.get_message_name('BSC_TIME_DIM_TDESC');
144: END getTestDesc;
145:
146: ------------------------------------------------------------
147: -- procedure to report test name back to framework

Line 151: name := BSC_OBJECTIVE_METADATA_SETUP.get_message_name('BSC_TIME_DIM_TNAME');

147: -- procedure to report test name back to framework
148: ------------------------------------------------------------
149: PROCEDURE getTestName(name OUT NOCOPY VARCHAR2) IS
150: BEGIN
151: name := BSC_OBJECTIVE_METADATA_SETUP.get_message_name('BSC_TIME_DIM_TNAME');
152: END getTestName;
153:
154:
155: ------------------------------------------------------------