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.FII_MV_REFRESH dependencies on FII_UTIL

Line 7: g_apps_schema_name VARCHAR2(120) := NVL(FII_UTIL.get_apps_schema_name, 'APPS');

3:
4: g_phase VARCHAR2(50);
5: g_debug_flag VARCHAR2(1) := NVL(FND_PROFILE.value('FII_DEBUG_MODE'), 'N');
6: g_retcode VARCHAR2(20) := NULL;
7: g_apps_schema_name VARCHAR2(120) := NVL(FII_UTIL.get_apps_schema_name, 'APPS');
8:
9: ----------------------------------------------------
10: -- PROCEDURE GL_REFRESH
11: ----------------------------------------------------

Line 30: l_dir := FII_UTIL.get_utl_file_dir;

26: ------------------------------------------------------
27: -- Set default directory in case if the profile option
28: -- BIS_DEBUG_LOG_DIRECTORY is not set up
29: ------------------------------------------------------
30: l_dir := FII_UTIL.get_utl_file_dir;
31:
32: ----------------------------------------------------------------
33: -- fii_util.initialize will get profile options FII_DEBUG_MODE
34: -- and BIS_DEBUG_LOG_DIRECTORY and set up the directory where

Line 33: -- fii_util.initialize will get profile options FII_DEBUG_MODE

29: ------------------------------------------------------
30: l_dir := FII_UTIL.get_utl_file_dir;
31:
32: ----------------------------------------------------------------
33: -- fii_util.initialize will get profile options FII_DEBUG_MODE
34: -- and BIS_DEBUG_LOG_DIRECTORY and set up the directory where
35: -- the log files and output files are written to
36: ---------------------------------------------------------------
37: FII_UTIL.initialize('FII_GL_MV_REFRESH.log', 'FII_GL_MV_REFRESH.out',l_dir, 'FII_MV_REFRESH');

Line 37: FII_UTIL.initialize('FII_GL_MV_REFRESH.log', 'FII_GL_MV_REFRESH.out',l_dir, 'FII_MV_REFRESH');

33: -- fii_util.initialize will get profile options FII_DEBUG_MODE
34: -- and BIS_DEBUG_LOG_DIRECTORY and set up the directory where
35: -- the log files and output files are written to
36: ---------------------------------------------------------------
37: FII_UTIL.initialize('FII_GL_MV_REFRESH.log', 'FII_GL_MV_REFRESH.out',l_dir, 'FII_MV_REFRESH');
38:
39: l_parallel_degree := BIS_COMMON_PARAMETERS.GET_DEGREE_OF_PARALLELISM();
40: IF (l_parallel_degree =1) THEN
41: l_parallel_degree := 0;

Line 74: FII_UTIL.start_timer();

70: END IF;
71:
72: -- Refresh FII_GL_MGMT_CCC_MV
73: IF g_debug_flag = 'Y' THEN
74: FII_UTIL.start_timer();
75: END IF;
76:
77: ------------------------------------------------------------------------------
78: --Bug 3155474: call BIS wrapper to handle force parallel on MVs

Line 92: FII_UTIL.stop_timer();

88: END IF;
89: ------------------------------------------------------------------------------
90:
91: IF g_debug_flag = 'Y' THEN
92: FII_UTIL.stop_timer();
93: FII_UTIL.put_line( 'FII_GL_MGMT_CCC_MV has been refreshed successfully' );
94: FII_UTIL.print_timer();
95: END IF;
96:

Line 93: FII_UTIL.put_line( 'FII_GL_MGMT_CCC_MV has been refreshed successfully' );

89: ------------------------------------------------------------------------------
90:
91: IF g_debug_flag = 'Y' THEN
92: FII_UTIL.stop_timer();
93: FII_UTIL.put_line( 'FII_GL_MGMT_CCC_MV has been refreshed successfully' );
94: FII_UTIL.print_timer();
95: END IF;
96:
97: -- Re-create index for FII_GL_MGMT_CCC_MV in Initial Mode

Line 94: FII_UTIL.print_timer();

90:
91: IF g_debug_flag = 'Y' THEN
92: FII_UTIL.stop_timer();
93: FII_UTIL.put_line( 'FII_GL_MGMT_CCC_MV has been refreshed successfully' );
94: FII_UTIL.print_timer();
95: END IF;
96:
97: -- Re-create index for FII_GL_MGMT_CCC_MV in Initial Mode
98: IF (p_program_type = 'L') THEN

Line 108: FII_UTIL.put_line(g_phase ||' for FII_GL_MGMT_CCC_MV' );

104:
105: -- Gather statistics for FII_GL_MGMT_CCC_MV
106: g_phase := 'Calling FND_STATS API to gather table statstics';
107: IF g_debug_flag = 'Y' THEN
108: FII_UTIL.put_line(g_phase ||' for FII_GL_MGMT_CCC_MV' );
109: FII_UTIL.put_line('');
110: END IF;
111:
112: fnd_stats.gather_table_stats (ownname=>g_apps_schema_name,

Line 109: FII_UTIL.put_line('');

105: -- Gather statistics for FII_GL_MGMT_CCC_MV
106: g_phase := 'Calling FND_STATS API to gather table statstics';
107: IF g_debug_flag = 'Y' THEN
108: FII_UTIL.put_line(g_phase ||' for FII_GL_MGMT_CCC_MV' );
109: FII_UTIL.put_line('');
110: END IF;
111:
112: fnd_stats.gather_table_stats (ownname=>g_apps_schema_name,
113: tabname=>'FII_GL_MGMT_CCC_MV');

Line 131: FII_UTIL.start_timer();

127: END IF;
128:
129: -- Refresh FII_GL_MGMT_SUM_MV
130: IF g_debug_flag = 'Y' THEN
131: FII_UTIL.start_timer();
132: END IF;
133:
134: ------------------------------------------------------------------------------
135: --Bug 3155474: call BIS wrapper to handle force parallel on MVs

Line 149: FII_UTIL.stop_timer();

145: END IF;
146: ------------------------------------------------------------------------------
147:
148: IF g_debug_flag = 'Y' THEN
149: FII_UTIL.stop_timer();
150: FII_UTIL.put_line( 'FII_GL_MGMT_SUM_MV has been refreshed successfully' );
151: FII_UTIL.print_timer();
152: END IF;
153:

Line 150: FII_UTIL.put_line( 'FII_GL_MGMT_SUM_MV has been refreshed successfully' );

146: ------------------------------------------------------------------------------
147:
148: IF g_debug_flag = 'Y' THEN
149: FII_UTIL.stop_timer();
150: FII_UTIL.put_line( 'FII_GL_MGMT_SUM_MV has been refreshed successfully' );
151: FII_UTIL.print_timer();
152: END IF;
153:
154: -- Re-create index for FII_GL_MGMT_SUM_MV in Initial Mode

Line 151: FII_UTIL.print_timer();

147:
148: IF g_debug_flag = 'Y' THEN
149: FII_UTIL.stop_timer();
150: FII_UTIL.put_line( 'FII_GL_MGMT_SUM_MV has been refreshed successfully' );
151: FII_UTIL.print_timer();
152: END IF;
153:
154: -- Re-create index for FII_GL_MGMT_SUM_MV in Initial Mode
155: IF (p_program_type = 'L') THEN

Line 168: FII_UTIL.put_line('Index Exception in index drop/create');

164: WHEN index_exception THEN
165: Errbuf:= sqlerrm;
166: Retcode:=sqlcode;
167: IF g_debug_flag = 'Y' THEN
168: FII_UTIL.put_line('Index Exception in index drop/create');
169: FII_UTIL.put_line('-->'||Retcode||':'||Errbuf);
170: END IF;
171: l_ret_val := FND_CONCURRENT.Set_Completion_Status
172: (status => 'ERROR', message => substr(errbuf,1,180));

Line 169: FII_UTIL.put_line('-->'||Retcode||':'||Errbuf);

165: Errbuf:= sqlerrm;
166: Retcode:=sqlcode;
167: IF g_debug_flag = 'Y' THEN
168: FII_UTIL.put_line('Index Exception in index drop/create');
169: FII_UTIL.put_line('-->'||Retcode||':'||Errbuf);
170: END IF;
171: l_ret_val := FND_CONCURRENT.Set_Completion_Status
172: (status => 'ERROR', message => substr(errbuf,1,180));
173: rollback;

Line 179: FII_UTIL.put_line('Other error in GL_REFRESH');

175: WHEN OTHERS THEN
176: Errbuf:= sqlerrm;
177: Retcode:=sqlcode;
178: IF g_debug_flag = 'Y' THEN
179: FII_UTIL.put_line('Other error in GL_REFRESH');
180: FII_UTIL.put_line('-->'||Retcode||':'||Errbuf);
181: END IF;
182: l_ret_val := FND_CONCURRENT.Set_Completion_Status
183: (status => 'ERROR', message => substr(errbuf,1,180));

Line 180: FII_UTIL.put_line('-->'||Retcode||':'||Errbuf);

176: Errbuf:= sqlerrm;
177: Retcode:=sqlcode;
178: IF g_debug_flag = 'Y' THEN
179: FII_UTIL.put_line('Other error in GL_REFRESH');
180: FII_UTIL.put_line('-->'||Retcode||':'||Errbuf);
181: END IF;
182: l_ret_val := FND_CONCURRENT.Set_Completion_Status
183: (status => 'ERROR', message => substr(errbuf,1,180));
184: rollback;

Line 209: l_dir:= FII_UTIL.get_utl_file_dir;

205: ------------------------------------------------------
206: -- Set default directory in case if the profile option
207: -- BIS_DEBUG_LOG_DIRECTORY is not set up
208: ------------------------------------------------------
209: l_dir:= FII_UTIL.get_utl_file_dir;
210:
211: ----------------------------------------------------------------
212: -- fii_util.initialize will get profile options FII_DEBUG_MODE
213: -- and BIS_DEBUG_LOG_DIRECTORY and set up the directory where

Line 212: -- fii_util.initialize will get profile options FII_DEBUG_MODE

208: ------------------------------------------------------
209: l_dir:= FII_UTIL.get_utl_file_dir;
210:
211: ----------------------------------------------------------------
212: -- fii_util.initialize will get profile options FII_DEBUG_MODE
213: -- and BIS_DEBUG_LOG_DIRECTORY and set up the directory where
214: -- the log files and output files are written to
215: ----------------------------------------------------------------
216: FII_UTIL.initialize('FII_AR_MV_REFRESH.log', 'FII_AR_MV_REFRESH.out',l_dir, 'FII_MV_REFRESH');

Line 216: FII_UTIL.initialize('FII_AR_MV_REFRESH.log', 'FII_AR_MV_REFRESH.out',l_dir, 'FII_MV_REFRESH');

212: -- fii_util.initialize will get profile options FII_DEBUG_MODE
213: -- and BIS_DEBUG_LOG_DIRECTORY and set up the directory where
214: -- the log files and output files are written to
215: ----------------------------------------------------------------
216: FII_UTIL.initialize('FII_AR_MV_REFRESH.log', 'FII_AR_MV_REFRESH.out',l_dir, 'FII_MV_REFRESH');
217:
218:
219:
220: g_phase := 'Refreshing AR Revenue MV';

Line 222: FII_UTIL.put_line(g_phase);

218:
219:
220: g_phase := 'Refreshing AR Revenue MV';
221: if g_debug_flag = 'Y' then
222: FII_UTIL.put_line(g_phase);
223: FII_UTIL.put_line('');
224: end if;
225:
226: -----------------------------------------------------------

Line 223: FII_UTIL.put_line('');

219:
220: g_phase := 'Refreshing AR Revenue MV';
221: if g_debug_flag = 'Y' then
222: FII_UTIL.put_line(g_phase);
223: FII_UTIL.put_line('');
224: end if;
225:
226: -----------------------------------------------------------
227: -- If there are no records in the base summary table,

Line 235: FII_UTIL.put_line(g_phase);

231: -----------------------------------------------------------
232:
233: g_phase := 'Checking base table for records';
234: if g_debug_flag = 'Y' then
235: FII_UTIL.put_line(g_phase);
236: FII_UTIL.put_line('');
237: end if;
238:
239: begin

Line 236: FII_UTIL.put_line('');

232:
233: g_phase := 'Checking base table for records';
234: if g_debug_flag = 'Y' then
235: FII_UTIL.put_line(g_phase);
236: FII_UTIL.put_line('');
237: end if;
238:
239: begin
240: SELECT 1 INTO l_count FROM FII_AR_REVENUE_B

Line 265: FII_UTIL.put_line(g_phase);

261: -- status
262: -----------------------------------------------------------
263: g_phase := 'Checking time dimension';
264: if g_debug_flag = 'Y' then
265: FII_UTIL.put_line(g_phase);
266: FII_UTIL.put_line('');
267: end if;
268:
269: SELECT MIN(t.gl_date),Max(t.gl_date)

Line 266: FII_UTIL.put_line('');

262: -----------------------------------------------------------
263: g_phase := 'Checking time dimension';
264: if g_debug_flag = 'Y' then
265: FII_UTIL.put_line(g_phase);
266: FII_UTIL.put_line('');
267: end if;
268:
269: SELECT MIN(t.gl_date),Max(t.gl_date)
270: INTO l_min, l_max

Line 280: FII_UTIL.put_line('Time Dimension is not fully populated. Please populate Time

276: -- If there are missing time records
277: --------------------------------------
278: IF (l_check_time_dim) THEN
279: if g_debug_flag = 'Y' then
280: FII_UTIL.put_line('Time Dimension is not fully populated. Please populate Time
281: dimension to cover the date range you are refreshing');
282: end if;
283: retcode := 1;
284: RETURN;

Line 288: FII_UTIL.start_timer;

284: RETURN;
285:
286: END IF;
287:
288: FII_UTIL.start_timer;
289: ------------------------------------------------
290: --Begin call HRI_OPL_PER_ORGCC.Load to populate
291: ------------------------------------------------
292: HRI_OPL_PER_ORGCC.Load (errbuf,

Line 298: FII_UTIL.stop_timer;

294: NULL, --chunk_size
295: NULL, --start_date
296: NULL, --end_date
297: NULL); --full_refresh
298: FII_UTIL.stop_timer;
299: FII_UTIL.print_timer('Duration for populating table HRI_CS_PER_ORGCC_CT: ');
300:
301: g_phase := 'Refreshing MV table';
302: if g_debug_flag = 'Y' then

Line 299: FII_UTIL.print_timer('Duration for populating table HRI_CS_PER_ORGCC_CT: ');

295: NULL, --start_date
296: NULL, --end_date
297: NULL); --full_refresh
298: FII_UTIL.stop_timer;
299: FII_UTIL.print_timer('Duration for populating table HRI_CS_PER_ORGCC_CT: ');
300:
301: g_phase := 'Refreshing MV table';
302: if g_debug_flag = 'Y' then
303: FII_UTIL.put_line(g_phase);

Line 303: FII_UTIL.put_line(g_phase);

299: FII_UTIL.print_timer('Duration for populating table HRI_CS_PER_ORGCC_CT: ');
300:
301: g_phase := 'Refreshing MV table';
302: if g_debug_flag = 'Y' then
303: FII_UTIL.put_line(g_phase);
304: FII_UTIL.put_line('');
305: end if;
306:
307: l_parallel_degree := BIS_COMMON_PARAMETERS.GET_DEGREE_OF_PARALLELISM();

Line 304: FII_UTIL.put_line('');

300:
301: g_phase := 'Refreshing MV table';
302: if g_debug_flag = 'Y' then
303: FII_UTIL.put_line(g_phase);
304: FII_UTIL.put_line('');
305: end if;
306:
307: l_parallel_degree := BIS_COMMON_PARAMETERS.GET_DEGREE_OF_PARALLELISM();
308: IF (l_parallel_degree =1) THEN

Line 321: FII_UTIL.put_line(g_phase);

317: -- Gather statistics for the use of cost-based optimizer
318: --------------------------------------------------------
319: g_phase := 'Calling FND_STATS API to gather table statstics';
320: if g_debug_flag = 'Y' then
321: FII_UTIL.put_line(g_phase);
322: FII_UTIL.put_line('');
323: end if;
324:
325: fnd_stats.gather_table_stats (ownname=>g_apps_schema_name, tabname=>'FII_AR_REV_SUM_MV');

Line 322: FII_UTIL.put_line('');

318: --------------------------------------------------------
319: g_phase := 'Calling FND_STATS API to gather table statstics';
320: if g_debug_flag = 'Y' then
321: FII_UTIL.put_line(g_phase);
322: FII_UTIL.put_line('');
323: end if;
324:
325: fnd_stats.gather_table_stats (ownname=>g_apps_schema_name, tabname=>'FII_AR_REV_SUM_MV');
326:

Line 334: FII_UTIL.put_line('Other error in AR_REFRESH');

330: WHEN OTHERS THEN
331: Errbuf:= sqlerrm;
332: Retcode:=sqlcode;
333: if g_debug_flag = 'Y' then
334: FII_UTIL.put_line('Other error in AR_REFRESH');
335: FII_UTIL.put_line('-->'||Retcode||':'||Errbuf);
336: END IF;
337: l_ret_val := FND_CONCURRENT.Set_Completion_Status
338: (status => 'ERROR', message => substr(errbuf,1,180));

Line 335: FII_UTIL.put_line('-->'||Retcode||':'||Errbuf);

331: Errbuf:= sqlerrm;
332: Retcode:=sqlcode;
333: if g_debug_flag = 'Y' then
334: FII_UTIL.put_line('Other error in AR_REFRESH');
335: FII_UTIL.put_line('-->'||Retcode||':'||Errbuf);
336: END IF;
337: l_ret_val := FND_CONCURRENT.Set_Completion_Status
338: (status => 'ERROR', message => substr(errbuf,1,180));
339: rollback;