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_MV_REFRESH dependencies on BIS_COLLECTION_UTILITIES

Line 17: BIS_COLLECTION_UTILITIES.debug(P_TEXT, P_IDENT);

13:
14: PROCEDURE DEBUG(P_TEXT VARCHAR2, P_IDENT NUMBER DEFAULT 0)
15: IS
16: BEGIN
17: BIS_COLLECTION_UTILITIES.debug(P_TEXT, P_IDENT);
18: END;
19:
20: procedure logmsg(P_TEXT in VARCHAR2) is
21: begin

Line 23: BIS_COLLECTION_UTILITIES.put_line(P_TEXT);

19:
20: procedure logmsg(P_TEXT in VARCHAR2) is
21: begin
22:
23: BIS_COLLECTION_UTILITIES.put_line(P_TEXT);
24: -- dbms_output.put_line(substr(P_TEXT,1,255));
25: end;
26:
27: FUNCTION duration(

Line 51: BIS_COLLECTION_UTILITIES.put_line('Process Time for '|| p_process || ' : ' || duration(l_duration));

47: IS
48: l_duration number := null;
49: BEGIN
50: l_duration := sysdate - p_log_timstamp;
51: BIS_COLLECTION_UTILITIES.put_line('Process Time for '|| p_process || ' : ' || duration(l_duration));
52: BIS_COLLECTION_UTILITIES.put_line('');
53: END;
54:
55: FUNCTION get_Table_size(p_obj_owner IN VARCHAR2

Line 52: BIS_COLLECTION_UTILITIES.put_line('');

48: l_duration number := null;
49: BEGIN
50: l_duration := sysdate - p_log_timstamp;
51: BIS_COLLECTION_UTILITIES.put_line('Process Time for '|| p_process || ' : ' || duration(l_duration));
52: BIS_COLLECTION_UTILITIES.put_line('');
53: END;
54:
55: FUNCTION get_Table_size(p_obj_owner IN VARCHAR2
56: ,p_log_table IN VARCHAR2)

Line 72: BIS_COLLECTION_UTILITIES.put_line('Error in get_Table_size('|| p_obj_owner || ',' || p_log_table || sqlerrm);

68: BEGIN
69: Dbms_Space.Unused_Space(p_obj_owner, p_log_table, 'TABLE',op1,total_bytes,op3,op4,op5,op6,op7);
70: EXCEPTION
71: WHEN OTHERS THEN
72: BIS_COLLECTION_UTILITIES.put_line('Error in get_Table_size('|| p_obj_owner || ',' || p_log_table || sqlerrm);
73: END;
74: return total_bytes;
75: END;
76:

Line 130: BIS_COLLECTION_UTILITIES.put_line('MV compile state : ' || l_compile_state || '.');

126:
127: OPEN C_MV_CSTATE(p_mvname, g_apps_schema_name);
128: fetch C_MV_CSTATE into l_compile_state;
129: CLOSE C_MV_CSTATE;
130: BIS_COLLECTION_UTILITIES.put_line('MV compile state : ' || l_compile_state || '.');
131:
132: EXCEPTION WHEN OTHERS THEN
133: l_errbuf :=sqlerrm;
134: l_retcode:=sqlcode;

Line 163: BIS_COLLECTION_UTILITIES.put_line('Before invoke custom API for MV threshold management: (' || p_mvname || ')');

159: L_CUSTOM_API bis_obj_properties.custom_api%type := NULL;
160: BEGIN
161: L_CUSTOM_API:= GET_CUSTOMAPI (p_mvname);
162: IF (L_CUSTOM_API is NOT NULL) THEN
163: BIS_COLLECTION_UTILITIES.put_line('Before invoke custom API for MV threshold management: (' || p_mvname || ')');
164: -- Now call the stored program
165: l_rtnbuf:=BIS_BIA_RSG_CUSTOM_API_MGMNT.METHOD_FAST;--added for enhancement 4423644
166: BIS_BIA_RSG_CUSTOM_API_MGMNT.INVOKE_CUSTOM_API(
167: l_rtnbuf, l_retcode,

Line 171: BIS_COLLECTION_UTILITIES.put_line('After invoke custom API for MV threshold management : (' || p_mvname ||','||l_rtnbuf|| ')');

167: l_rtnbuf, l_retcode,
168: L_CUSTOM_API, BIS_BIA_RSG_CUSTOM_API_MGMNT.TYPE_MV_THRESHOLD,
169: p_mvname, 'MV', BIS_BIA_RSG_CUSTOM_API_MGMNT.MODE_BEFORE);
170: --- BIS_BIA_RSG_CUSTOM_API_MGMNT.log( 'Got refresh threshold for ' || p_mvname || ': '|| l_rtnbuf);
171: BIS_COLLECTION_UTILITIES.put_line('After invoke custom API for MV threshold management : (' || p_mvname ||','||l_rtnbuf|| ')');
172:
173: IF ( l_rtnbuf = BIS_BIA_RSG_CUSTOM_API_MGMNT.METHOD_COMPLETE) THEN
174: RETURN 'INIT';
175: ELSIF ( l_rtnbuf = BIS_BIA_RSG_CUSTOM_API_MGMNT.METHOD_FAST) THEN

Line 183: BIS_COLLECTION_UTILITIES.put_line('Errored in BIS_MV_REFRESH.GET_MV_THRESHOLDED_AT_RUNTIME');

179: ELSE
180: RETURN NULL; -- meaning that no CUSTOME_API defined, and therefore no THRESHOLDING
181: END IF;
182: EXCEPTION WHEN OTHERS THEN
183: BIS_COLLECTION_UTILITIES.put_line('Errored in BIS_MV_REFRESH.GET_MV_THRESHOLDED_AT_RUNTIME');
184: RAISE; -- raise whatever exceptions, and fails the process.
185: END;
186:
187: -- added for enhancement 3034322, MV index management at runtime.

Line 197: BIS_COLLECTION_UTILITIES.put_line('Before invoke custom API for MV index management : (' || p_mvname || ', ' || p_mode || ')');

193: BEGIN
194: L_CUSTOM_API:= GET_CUSTOMAPI (p_mvname);
195: IF (L_CUSTOM_API is NOT NULL) THEN
196: -- Now call the stored program
197: BIS_COLLECTION_UTILITIES.put_line('Before invoke custom API for MV index management : (' || p_mvname || ', ' || p_mode || ')');
198: l_rtnbuf:= BIS_BIA_RSG_CUSTOM_API_MGMNT.METHOD_COMPLETE;
199: BIS_BIA_RSG_CUSTOM_API_MGMNT.INVOKE_CUSTOM_API(
200: l_rtnbuf, l_retcode,
201: L_CUSTOM_API, BIS_BIA_RSG_CUSTOM_API_MGMNT.TYPE_MV_INDEX_MGT,

Line 203: BIS_COLLECTION_UTILITIES.put_line('After invoke custom API for MV index management: (' || p_mvname || ', ' || p_mode || ')');

199: BIS_BIA_RSG_CUSTOM_API_MGMNT.INVOKE_CUSTOM_API(
200: l_rtnbuf, l_retcode,
201: L_CUSTOM_API, BIS_BIA_RSG_CUSTOM_API_MGMNT.TYPE_MV_INDEX_MGT,
202: p_mvname, 'MV', p_mode);
203: BIS_COLLECTION_UTILITIES.put_line('After invoke custom API for MV index management: (' || p_mvname || ', ' || p_mode || ')');
204: END IF;
205: EXCEPTION WHEN OTHERS THEN
206: BIS_COLLECTION_UTILITIES.put_line('Errored in BIS_MV_REFRESH.MV_INDEX_MANAGE');
207: RAISE; -- raise whatever exceptions, and fails the process.

Line 206: BIS_COLLECTION_UTILITIES.put_line('Errored in BIS_MV_REFRESH.MV_INDEX_MANAGE');

202: p_mvname, 'MV', p_mode);
203: BIS_COLLECTION_UTILITIES.put_line('After invoke custom API for MV index management: (' || p_mvname || ', ' || p_mode || ')');
204: END IF;
205: EXCEPTION WHEN OTHERS THEN
206: BIS_COLLECTION_UTILITIES.put_line('Errored in BIS_MV_REFRESH.MV_INDEX_MANAGE');
207: RAISE; -- raise whatever exceptions, and fails the process.
208: END;
209:
210:

Line 241: BIS_COLLECTION_UTILITIES.put_line('FND_GLOBAL.CONC_PRIORITY_REQUEST: ' || l_root_request_id);

237: and opt.option_name = 'FORCE_FULL';
238:
239: BEGIN
240: l_root_request_id := FND_GLOBAL.CONC_PRIORITY_REQUEST;
241: BIS_COLLECTION_UTILITIES.put_line('FND_GLOBAL.CONC_PRIORITY_REQUEST: ' || l_root_request_id);
242: open c_force_full(l_root_request_id);
243: fetch c_force_full into l_rs_name, l_is_force_full;
244: close c_force_full;
245: BIS_COLLECTION_UTILITIES.put_line('Request Set: ' || l_rs_name || ', ' || 'FORCE_FULL option: ' || l_is_force_full);

Line 245: BIS_COLLECTION_UTILITIES.put_line('Request Set: ' || l_rs_name || ', ' || 'FORCE_FULL option: ' || l_is_force_full);

241: BIS_COLLECTION_UTILITIES.put_line('FND_GLOBAL.CONC_PRIORITY_REQUEST: ' || l_root_request_id);
242: open c_force_full(l_root_request_id);
243: fetch c_force_full into l_rs_name, l_is_force_full;
244: close c_force_full;
245: BIS_COLLECTION_UTILITIES.put_line('Request Set: ' || l_rs_name || ', ' || 'FORCE_FULL option: ' || l_is_force_full);
246: l_schema := BIS_CREATE_REQUESTSET.get_object_owner(p_mvname, 'MV');
247:
248: if( p_mode = 'INIT' and l_is_force_full='Y' ) then
249: BIS_BIA_RSG_LOG_MGMNT.create_mv_log(p_mvname, l_schema, 'MV');

Line 251: BIS_COLLECTION_UTILITIES.put_line('No action for MV Log recreation.');

247:
248: if( p_mode = 'INIT' and l_is_force_full='Y' ) then
249: BIS_BIA_RSG_LOG_MGMNT.create_mv_log(p_mvname, l_schema, 'MV');
250: else
251: BIS_COLLECTION_UTILITIES.put_line('No action for MV Log recreation.');
252: end if;
253:
254: EXCEPTION WHEN OTHERS THEN
255: close c_force_full;

Line 256: BIS_COLLECTION_UTILITIES.put_line('Errored in BIS_MV_REFRESH.MV_LOG_RECREATE');

252: end if;
253:
254: EXCEPTION WHEN OTHERS THEN
255: close c_force_full;
256: BIS_COLLECTION_UTILITIES.put_line('Errored in BIS_MV_REFRESH.MV_LOG_RECREATE');
257: RAISE; -- raise whatever exceptions, and fails the process.
258: END;
259:
260:

Line 269: BIS_COLLECTION_UTILITIES.put_line('DB Version: ' || db_versn);

265: db_versn varchar2(100);
266: l_atomic_refresh boolean;
267: BEGIN
268: select version into db_versn from v$instance;
269: BIS_COLLECTION_UTILITIES.put_line('DB Version: ' || db_versn);
270:
271: select substr(replace(substr(version,1,instr(version,'.',1,2)-1),'.'),1,2)
272: into db_versn from v$instance;
273:

Line 278: BIS_COLLECTION_UTILITIES.put_line('Atomic refresh: true');

274:
275: if (( db_versn > 80) and (db_versn < 90)) -- 8i
276: then
277: l_atomic_refresh := true;
278: BIS_COLLECTION_UTILITIES.put_line('Atomic refresh: true');
279: elsif ( db_versn >= 90 ) -- 9i
280: then
281: l_atomic_refresh := true;
282: BIS_COLLECTION_UTILITIES.put_line('Atomic refresh: true');

Line 282: BIS_COLLECTION_UTILITIES.put_line('Atomic refresh: true');

278: BIS_COLLECTION_UTILITIES.put_line('Atomic refresh: true');
279: elsif ( db_versn >= 90 ) -- 9i
280: then
281: l_atomic_refresh := true;
282: BIS_COLLECTION_UTILITIES.put_line('Atomic refresh: true');
283: else -- 10g
284: l_atomic_refresh := false;
285: BIS_COLLECTION_UTILITIES.put_line('Atomic refresh: false');
286: end if;

Line 285: BIS_COLLECTION_UTILITIES.put_line('Atomic refresh: false');

281: l_atomic_refresh := true;
282: BIS_COLLECTION_UTILITIES.put_line('Atomic refresh: true');
283: else -- 10g
284: l_atomic_refresh := false;
285: BIS_COLLECTION_UTILITIES.put_line('Atomic refresh: false');
286: end if;
287: return l_atomic_refresh;
288: END;
289:

Line 306: BIS_COLLECTION_UTILITIES.put_line('Before INVOKE_CUSTOM_API for other custom logic : (' || p_mvname || ', ' || p_mode || ','||l_rtnbuf||')');

302: l_rtnbuf:=BIS_BIA_RSG_CUSTOM_API_MGMNT.METHOD_FAST;
303: else
304: l_rtnbuf:=BIS_BIA_RSG_CUSTOM_API_MGMNT.METHOD_COMPLETE;
305: end if;
306: BIS_COLLECTION_UTILITIES.put_line('Before INVOKE_CUSTOM_API for other custom logic : (' || p_mvname || ', ' || p_mode || ','||l_rtnbuf||')');
307: BIS_BIA_RSG_CUSTOM_API_MGMNT.INVOKE_CUSTOM_API(
308: l_rtnbuf, l_retcode,
309: L_CUSTOM_API, BIS_BIA_RSG_CUSTOM_API_MGMNT.TYPE_MV_OTHER_CUSTOM,
310: p_mvname, 'MV', p_mode);

Line 311: BIS_COLLECTION_UTILITIES.put_line('After INVOKE_CUSTOM_API for other custom logic: (' || p_mvname || ', ' || p_mode ||','||l_rtnbuf||')');

307: BIS_BIA_RSG_CUSTOM_API_MGMNT.INVOKE_CUSTOM_API(
308: l_rtnbuf, l_retcode,
309: L_CUSTOM_API, BIS_BIA_RSG_CUSTOM_API_MGMNT.TYPE_MV_OTHER_CUSTOM,
310: p_mvname, 'MV', p_mode);
311: BIS_COLLECTION_UTILITIES.put_line('After INVOKE_CUSTOM_API for other custom logic: (' || p_mvname || ', ' || p_mode ||','||l_rtnbuf||')');
312: END IF;
313: EXCEPTION WHEN OTHERS THEN
314: BIS_COLLECTION_UTILITIES.put_line('Errored in BIS_MV_REFRESH.CUSTOM_API_OTHER');
315: RAISE; -- raise whatever exceptions, and fails the process.

Line 314: BIS_COLLECTION_UTILITIES.put_line('Errored in BIS_MV_REFRESH.CUSTOM_API_OTHER');

310: p_mvname, 'MV', p_mode);
311: BIS_COLLECTION_UTILITIES.put_line('After INVOKE_CUSTOM_API for other custom logic: (' || p_mvname || ', ' || p_mode ||','||l_rtnbuf||')');
312: END IF;
313: EXCEPTION WHEN OTHERS THEN
314: BIS_COLLECTION_UTILITIES.put_line('Errored in BIS_MV_REFRESH.CUSTOM_API_OTHER');
315: RAISE; -- raise whatever exceptions, and fails the process.
316: END;
317:
318:

Line 355: BIS_COLLECTION_UTILITIES.put_line(mvname||' was altered to parallel');

351: execute immediate l_stmt;
352: ---bug 4149264
353: l_stmt:='alter table '||mvname||' parallel ';
354: execute immediate l_stmt ;
355: BIS_COLLECTION_UTILITIES.put_line(mvname||' was altered to parallel');
356: ----end of bug 4149264
357:
358: -- for bug 3668562, move before the alter session calls
359: -- MV_INDEX_MANAGE(mvname, BIS_BIA_RSG_CUSTOM_API_MGMNT.MODE_BEFORE);

Line 366: BIS_COLLECTION_UTILITIES.put_line('Setting star_transformation_enabled=TEMP_DISABLE');

362: ELSE
363: IF (method = 'F') THEN
364: l_stmt := 'ALTER SESSION SET star_transformation_enabled=TEMP_DISABLE ';
365: execute immediate l_stmt;
366: BIS_COLLECTION_UTILITIES.put_line('Setting star_transformation_enabled=TEMP_DISABLE');
367: END IF;
368: END IF;
369:
370: ---added for enhancement 4423644

Line 379: -- BIS_COLLECTION_UTILITIES.put_line('TESTING :: Value of star_transformation_enabled in V$parameter = '|| l_star_transformation);

375:
376: -- Debug for performance check; remove after testing
377: -- temp_start_refresh := sysdate;
378: -- select value into l_star_transformation from v$parameter where name = 'star_transformation_enabled';
379: -- BIS_COLLECTION_UTILITIES.put_line('TESTING :: Value of star_transformation_enabled in V$parameter = '|| l_star_transformation);
380: DBMS_MVIEW.REFRESH(
381: list => mvname,
382: method => method,
383: parallelism => 0,

Line 390: BIS_COLLECTION_UTILITIES.put_line(mvname||' was refreshed using '|| l_method || ' refresh method');

386: -- Debugging for performance check; remove after testing
387: --logtime('TESTING :: Timing for MV Refresh With STAR_TRANSFORMATION_ENABLED='|| l_star_transformation,temp_start_refresh);
388:
389: -- Added for bug 3626375 Log Messages
390: BIS_COLLECTION_UTILITIES.put_line(mvname||' was refreshed using '|| l_method || ' refresh method');
391: -- code end for bug 3626375
392:
393: ------added for enhancement 4423644
394: custom_api_other(mvname, BIS_BIA_RSG_CUSTOM_API_MGMNT.MODE_AFTER,method);

Line 401: BIS_COLLECTION_UTILITIES.put_line(mvname||' was altered to nonparallel');

397:
398: ---bug 4149264
399: l_stmt:='alter table '||mvname||' noparallel ';
400: execute immediate l_stmt;
401: BIS_COLLECTION_UTILITIES.put_line(mvname||' was altered to nonparallel');
402: ----end of bug 4149264
403:
404: l_stmt := 'alter session disable parallel query';
405: execute immediate l_stmt;

Line 420: BIS_COLLECTION_UTILITIES.put_line('Resetting star_transformation_enabled=FALSE');

416: ELSE
417: IF (method = 'F') THEN
418: l_stmt := 'ALTER SESSION SET star_transformation_enabled=FALSE ';
419: execute immediate l_stmt;
420: BIS_COLLECTION_UTILITIES.put_line('Resetting star_transformation_enabled=FALSE');
421: -- Debug
422: -- select value into l_star_transformation from v$parameter where name = 'star_transformation_enabled';
423: -- BIS_COLLECTION_UTILITIES.put_line('TESTING :: Value of star_transformation_enabled in V$parameter = '|| l_star_transformation);
424: END IF;

Line 423: -- BIS_COLLECTION_UTILITIES.put_line('TESTING :: Value of star_transformation_enabled in V$parameter = '|| l_star_transformation);

419: execute immediate l_stmt;
420: BIS_COLLECTION_UTILITIES.put_line('Resetting star_transformation_enabled=FALSE');
421: -- Debug
422: -- select value into l_star_transformation from v$parameter where name = 'star_transformation_enabled';
423: -- BIS_COLLECTION_UTILITIES.put_line('TESTING :: Value of star_transformation_enabled in V$parameter = '|| l_star_transformation);
424: END IF;
425: END IF;
426:
427: EXCEPTION

Line 445: BIS_COLLECTION_UTILITIES.put_line('Resetting star_transformation_enabled=FALSE');

441: ELSE
442: IF (method = 'F') THEN
443: l_stmt := 'ALTER SESSION SET star_transformation_enabled=FALSE ';
444: execute immediate l_stmt;
445: BIS_COLLECTION_UTILITIES.put_line('Resetting star_transformation_enabled=FALSE');
446: -- Debug
447: -- select value into l_star_transformation from v$parameter where name = 'star_transformation_enabled';
448: -- BIS_COLLECTION_UTILITIES.put_line('TESTING :: Value of star_transformation_enabled in V$parameter = '|| l_star_transformation);
449: END IF;

Line 448: -- BIS_COLLECTION_UTILITIES.put_line('TESTING :: Value of star_transformation_enabled in V$parameter = '|| l_star_transformation);

444: execute immediate l_stmt;
445: BIS_COLLECTION_UTILITIES.put_line('Resetting star_transformation_enabled=FALSE');
446: -- Debug
447: -- select value into l_star_transformation from v$parameter where name = 'star_transformation_enabled';
448: -- BIS_COLLECTION_UTILITIES.put_line('TESTING :: Value of star_transformation_enabled in V$parameter = '|| l_star_transformation);
449: END IF;
450: END IF;
451: RAISE;
452: END REFRESH_WRAPPER;

Line 483: BIS_COLLECTION_UTILITIES.put_line('BIS Force Refresh is starting');

479: IS
480:
481: BEGIN
482: if fnd_profile.value('BIS_MV_FORCE_REFRESH') = 'Y' then
483: BIS_COLLECTION_UTILITIES.put_line('BIS Force Refresh is starting');
484: BIS_COLLECTION_UTILITIES.put_line(' ');
485: RETURN TRUE;
486: else
487: BIS_COLLECTION_UTILITIES.put_line('BIS Force Refresh will not start');

Line 484: BIS_COLLECTION_UTILITIES.put_line(' ');

480:
481: BEGIN
482: if fnd_profile.value('BIS_MV_FORCE_REFRESH') = 'Y' then
483: BIS_COLLECTION_UTILITIES.put_line('BIS Force Refresh is starting');
484: BIS_COLLECTION_UTILITIES.put_line(' ');
485: RETURN TRUE;
486: else
487: BIS_COLLECTION_UTILITIES.put_line('BIS Force Refresh will not start');
488: BIS_COLLECTION_UTILITIES.put_line(' ');

Line 487: BIS_COLLECTION_UTILITIES.put_line('BIS Force Refresh will not start');

483: BIS_COLLECTION_UTILITIES.put_line('BIS Force Refresh is starting');
484: BIS_COLLECTION_UTILITIES.put_line(' ');
485: RETURN TRUE;
486: else
487: BIS_COLLECTION_UTILITIES.put_line('BIS Force Refresh will not start');
488: BIS_COLLECTION_UTILITIES.put_line(' ');
489: RETURN FALSE;
490: end if;
491:

Line 488: BIS_COLLECTION_UTILITIES.put_line(' ');

484: BIS_COLLECTION_UTILITIES.put_line(' ');
485: RETURN TRUE;
486: else
487: BIS_COLLECTION_UTILITIES.put_line('BIS Force Refresh will not start');
488: BIS_COLLECTION_UTILITIES.put_line(' ');
489: RETURN FALSE;
490: end if;
491:
492: END IS_BIS_FORCE_REFRESH;

Line 507: BIS_COLLECTION_UTILITIES.put_line('Not a valid MV Name: ' || P_MVNAME);

503: WHERE OWNER = g_apps_schema_name AND MVIEW_NAME = p_mvname;
504: IF (l_count = 0) THEN
505: -- G_ERRBUF := 'Not a valid MV Name: ' || P_MVNAME;
506: -- G_ERRCODE := -1;
507: BIS_COLLECTION_UTILITIES.put_line('Not a valid MV Name: ' || P_MVNAME);
508: -- BIS_COLLECTION_UTILITIES.put_line(' ');
509: return FALSE;
510: ELSE
511: return TRUE;

Line 508: -- BIS_COLLECTION_UTILITIES.put_line(' ');

504: IF (l_count = 0) THEN
505: -- G_ERRBUF := 'Not a valid MV Name: ' || P_MVNAME;
506: -- G_ERRCODE := -1;
507: BIS_COLLECTION_UTILITIES.put_line('Not a valid MV Name: ' || P_MVNAME);
508: -- BIS_COLLECTION_UTILITIES.put_line(' ');
509: return FALSE;
510: ELSE
511: return TRUE;
512: END IF;

Line 532: BIS_COLLECTION_UTILITIES.put_line( p_mvname || ' is not Fast Refreshable!');

528: FROM ALL_MVIEWS
529: WHERE OWNER = g_apps_schema_name AND MVIEW_NAME = p_mvname;
530:
531: IF( l_refresh_method = 'COMPLETE' OR l_fast_refreshable = 'NO' ) THEN
532: BIS_COLLECTION_UTILITIES.put_line( p_mvname || ' is not Fast Refreshable!');
533: BIS_COLLECTION_UTILITIES.put_line(' ');
534: return FALSE;
535: ELSE
536: BIS_COLLECTION_UTILITIES.put_line(p_mvname || ' is Fast Refreshable!');

Line 533: BIS_COLLECTION_UTILITIES.put_line(' ');

529: WHERE OWNER = g_apps_schema_name AND MVIEW_NAME = p_mvname;
530:
531: IF( l_refresh_method = 'COMPLETE' OR l_fast_refreshable = 'NO' ) THEN
532: BIS_COLLECTION_UTILITIES.put_line( p_mvname || ' is not Fast Refreshable!');
533: BIS_COLLECTION_UTILITIES.put_line(' ');
534: return FALSE;
535: ELSE
536: BIS_COLLECTION_UTILITIES.put_line(p_mvname || ' is Fast Refreshable!');
537: BIS_COLLECTION_UTILITIES.put_line(' ');

Line 536: BIS_COLLECTION_UTILITIES.put_line(p_mvname || ' is Fast Refreshable!');

532: BIS_COLLECTION_UTILITIES.put_line( p_mvname || ' is not Fast Refreshable!');
533: BIS_COLLECTION_UTILITIES.put_line(' ');
534: return FALSE;
535: ELSE
536: BIS_COLLECTION_UTILITIES.put_line(p_mvname || ' is Fast Refreshable!');
537: BIS_COLLECTION_UTILITIES.put_line(' ');
538: return TRUE;
539: END IF;
540: END IS_FAST_REFRESHABLE;

Line 537: BIS_COLLECTION_UTILITIES.put_line(' ');

533: BIS_COLLECTION_UTILITIES.put_line(' ');
534: return FALSE;
535: ELSE
536: BIS_COLLECTION_UTILITIES.put_line(p_mvname || ' is Fast Refreshable!');
537: BIS_COLLECTION_UTILITIES.put_line(' ');
538: return TRUE;
539: END IF;
540: END IS_FAST_REFRESHABLE;
541:

Line 554: BIS_COLLECTION_UTILITIES.put_line('Performing Fast Refresh for ' || p_mvname ||', mode Incremental Loading');

550: l_retcode number;
551: BEGIN
552:
553: BEGIN
554: BIS_COLLECTION_UTILITIES.put_line('Performing Fast Refresh for ' || p_mvname ||', mode Incremental Loading');
555: REFRESH_WRAP( p_mvname, 'F', p_degree);
556: BIS_COLLECTION_UTILITIES.put_line(' ');
557: RETURN 1;
558: EXCEPTION

Line 556: BIS_COLLECTION_UTILITIES.put_line(' ');

552:
553: BEGIN
554: BIS_COLLECTION_UTILITIES.put_line('Performing Fast Refresh for ' || p_mvname ||', mode Incremental Loading');
555: REFRESH_WRAP( p_mvname, 'F', p_degree);
556: BIS_COLLECTION_UTILITIES.put_line(' ');
557: RETURN 1;
558: EXCEPTION
559: -- ignore the following exceptions,
560: -- as they are proven to be able to be resolved by a COMPLETE REFRESH.

Line 580: BIS_COLLECTION_UTILITIES.put_line('Ignored the following error while fast-refreshing '|| p_mvname || ':');

576: l_retcode = -32320 OR -- "REFRESH FAST of \"%s\".\"%s\" unsupported after cointainer table PMOPs"
577: l_retcode = -32321 -- "REFRESH FAST of \"%s\".\"%s\" unsupported after detail table TRUNCATE"
578: --l_retcode = -23413 -- table OWNER.TABLE_NAME does not have a materialized view log
579: ) THEN
580: BIS_COLLECTION_UTILITIES.put_line('Ignored the following error while fast-refreshing '|| p_mvname || ':');
581: BIS_COLLECTION_UTILITIES.put_line(sqlerrm);
582: BIS_COLLECTION_UTILITIES.put_line(' ');
583: g_program_status_var := 'WARNING';
584: ELSE

Line 581: BIS_COLLECTION_UTILITIES.put_line(sqlerrm);

577: l_retcode = -32321 -- "REFRESH FAST of \"%s\".\"%s\" unsupported after detail table TRUNCATE"
578: --l_retcode = -23413 -- table OWNER.TABLE_NAME does not have a materialized view log
579: ) THEN
580: BIS_COLLECTION_UTILITIES.put_line('Ignored the following error while fast-refreshing '|| p_mvname || ':');
581: BIS_COLLECTION_UTILITIES.put_line(sqlerrm);
582: BIS_COLLECTION_UTILITIES.put_line(' ');
583: g_program_status_var := 'WARNING';
584: ELSE
585: BIS_COLLECTION_UTILITIES.put_line('The following error while fast-refreshing '|| p_mvname || ' is not ignorable: ');

Line 582: BIS_COLLECTION_UTILITIES.put_line(' ');

578: --l_retcode = -23413 -- table OWNER.TABLE_NAME does not have a materialized view log
579: ) THEN
580: BIS_COLLECTION_UTILITIES.put_line('Ignored the following error while fast-refreshing '|| p_mvname || ':');
581: BIS_COLLECTION_UTILITIES.put_line(sqlerrm);
582: BIS_COLLECTION_UTILITIES.put_line(' ');
583: g_program_status_var := 'WARNING';
584: ELSE
585: BIS_COLLECTION_UTILITIES.put_line('The following error while fast-refreshing '|| p_mvname || ' is not ignorable: ');
586: BIS_COLLECTION_UTILITIES.put_line(sqlerrm);

Line 585: BIS_COLLECTION_UTILITIES.put_line('The following error while fast-refreshing '|| p_mvname || ' is not ignorable: ');

581: BIS_COLLECTION_UTILITIES.put_line(sqlerrm);
582: BIS_COLLECTION_UTILITIES.put_line(' ');
583: g_program_status_var := 'WARNING';
584: ELSE
585: BIS_COLLECTION_UTILITIES.put_line('The following error while fast-refreshing '|| p_mvname || ' is not ignorable: ');
586: BIS_COLLECTION_UTILITIES.put_line(sqlerrm);
587: BIS_COLLECTION_UTILITIES.put_line(' ');
588:
589: RAISE;

Line 586: BIS_COLLECTION_UTILITIES.put_line(sqlerrm);

582: BIS_COLLECTION_UTILITIES.put_line(' ');
583: g_program_status_var := 'WARNING';
584: ELSE
585: BIS_COLLECTION_UTILITIES.put_line('The following error while fast-refreshing '|| p_mvname || ' is not ignorable: ');
586: BIS_COLLECTION_UTILITIES.put_line(sqlerrm);
587: BIS_COLLECTION_UTILITIES.put_line(' ');
588:
589: RAISE;
590: END IF;

Line 587: BIS_COLLECTION_UTILITIES.put_line(' ');

583: g_program_status_var := 'WARNING';
584: ELSE
585: BIS_COLLECTION_UTILITIES.put_line('The following error while fast-refreshing '|| p_mvname || ' is not ignorable: ');
586: BIS_COLLECTION_UTILITIES.put_line(sqlerrm);
587: BIS_COLLECTION_UTILITIES.put_line(' ');
588:
589: RAISE;
590: END IF;
591: END; -- END OF FIRST ROUND, FAST REFRESH

Line 592: BIS_COLLECTION_UTILITIES.put_line('Performing Complete Refresh for ' || p_mvname ||', mode Incremental Loading');

588:
589: RAISE;
590: END IF;
591: END; -- END OF FIRST ROUND, FAST REFRESH
592: BIS_COLLECTION_UTILITIES.put_line('Performing Complete Refresh for ' || p_mvname ||', mode Incremental Loading');
593: REFRESH_WRAP( p_mvname, 'C', p_degree);
594: BIS_COLLECTION_UTILITIES.put_line(' ');
595: return 1;
596: END BIS_FAST_REFRESH;

Line 594: BIS_COLLECTION_UTILITIES.put_line(' ');

590: END IF;
591: END; -- END OF FIRST ROUND, FAST REFRESH
592: BIS_COLLECTION_UTILITIES.put_line('Performing Complete Refresh for ' || p_mvname ||', mode Incremental Loading');
593: REFRESH_WRAP( p_mvname, 'C', p_degree);
594: BIS_COLLECTION_UTILITIES.put_line(' ');
595: return 1;
596: END BIS_FAST_REFRESH;
597:
598:

Line 619: --- BIS_COLLECTION_UTILITIES.put_line('Got refresh threshold for ' || p_mvname || ': ' || l_refreshmode );

615: -- added for enhancement 3022739, MV threshold at runtime.
616:
617: IF (p_refreshmode = 'INCR') THEN
618: l_refreshmode := GET_MV_THRESHOLDED_AT_RUNTIME(p_mvname);
619: --- BIS_COLLECTION_UTILITIES.put_line('Got refresh threshold for ' || p_mvname || ': ' || l_refreshmode );
620: IF (l_refreshmode is NULL ) THEN
621: l_refreshmode := p_refreshmode;
622: END IF;
623: ELSE

Line 632: BIS_COLLECTION_UTILITIES.put_line('Performing Initial loading');

628: -- 'INIT' LOADING MODE indicates initial loading,
629: -- meaning a COMPLETE REFRESH is necessary.
630: -- the other possible vaue is 'INCR'
631: IF (l_refreshmode = 'INIT') THEN
632: BIS_COLLECTION_UTILITIES.put_line('Performing Initial loading');
633: REFRESH_WRAP(p_mvname, 'C', l_degree);
634: p_final_refresh_mode := 'INIT';
635: RETURN 1;
636: END IF;

Line 641: BIS_COLLECTION_UTILITIES.put_line('Performing Complete Loading for ' || p_mvname );

637:
638: -- INCREMENTAL LOADING LOGIC FOR NON_FAST_REFRESHABLES
639: DEBUG('Try performing incremental loading');
640: IF ( NOT IS_FAST_REFRESHABLE(p_mvname)) THEN
641: BIS_COLLECTION_UTILITIES.put_line('Performing Complete Loading for ' || p_mvname );
642: REFRESH_WRAP( p_mvname, 'C', l_degree);
643: p_final_refresh_mode := 'INIT';
644:
645: RETURN 1;

Line 716: BIS_COLLECTION_UTILITIES.put_line( P_MVNAME || ' implemented: ' || l_impl_flag);

712: BEGIN
713: open C_IMPLEMENTATION_FLAG(P_MVNAME);
714: fetch C_IMPLEMENTATION_FLAG into l_impl_flag;
715: close C_IMPLEMENTATION_FLAG;
716: BIS_COLLECTION_UTILITIES.put_line( P_MVNAME || ' implemented: ' || l_impl_flag);
717: BIS_COLLECTION_UTILITIES.put_line( '');
718: RETURN (l_impl_flag = 'Y');
719: END;
720:

Line 717: BIS_COLLECTION_UTILITIES.put_line( '');

713: open C_IMPLEMENTATION_FLAG(P_MVNAME);
714: fetch C_IMPLEMENTATION_FLAG into l_impl_flag;
715: close C_IMPLEMENTATION_FLAG;
716: BIS_COLLECTION_UTILITIES.put_line( P_MVNAME || ' implemented: ' || l_impl_flag);
717: BIS_COLLECTION_UTILITIES.put_line( '');
718: RETURN (l_impl_flag = 'Y');
719: END;
720:
721:

Line 858: BIS_COLLECTION_UTILITIES.put_line('------------------------------------------------------------------');

854: x_object_type => 'MV',
855: x_refresh_type => 'CONSIDER_REFRESH',
856: x_set_request_id =>l_root_req_id );
857: ELSE
858: BIS_COLLECTION_UTILITIES.put_line('------------------------------------------------------------------');
859: BIS_COLLECTION_UTILITIES.put_line('Request Set History Collection Option is off for this Request Set.');
860: BIS_COLLECTION_UTILITIES.put_line('No History Collection will happen for this request set.');
861: BIS_COLLECTION_UTILITIES.put_line('------------------------------------------------------------------');
862: END IF;

Line 859: BIS_COLLECTION_UTILITIES.put_line('Request Set History Collection Option is off for this Request Set.');

855: x_refresh_type => 'CONSIDER_REFRESH',
856: x_set_request_id =>l_root_req_id );
857: ELSE
858: BIS_COLLECTION_UTILITIES.put_line('------------------------------------------------------------------');
859: BIS_COLLECTION_UTILITIES.put_line('Request Set History Collection Option is off for this Request Set.');
860: BIS_COLLECTION_UTILITIES.put_line('No History Collection will happen for this request set.');
861: BIS_COLLECTION_UTILITIES.put_line('------------------------------------------------------------------');
862: END IF;
863: end if;

Line 860: BIS_COLLECTION_UTILITIES.put_line('No History Collection will happen for this request set.');

856: x_set_request_id =>l_root_req_id );
857: ELSE
858: BIS_COLLECTION_UTILITIES.put_line('------------------------------------------------------------------');
859: BIS_COLLECTION_UTILITIES.put_line('Request Set History Collection Option is off for this Request Set.');
860: BIS_COLLECTION_UTILITIES.put_line('No History Collection will happen for this request set.');
861: BIS_COLLECTION_UTILITIES.put_line('------------------------------------------------------------------');
862: END IF;
863: end if;
864: exception

Line 861: BIS_COLLECTION_UTILITIES.put_line('------------------------------------------------------------------');

857: ELSE
858: BIS_COLLECTION_UTILITIES.put_line('------------------------------------------------------------------');
859: BIS_COLLECTION_UTILITIES.put_line('Request Set History Collection Option is off for this Request Set.');
860: BIS_COLLECTION_UTILITIES.put_line('No History Collection will happen for this request set.');
861: BIS_COLLECTION_UTILITIES.put_line('------------------------------------------------------------------');
862: END IF;
863: end if;
864: exception
865: when others then

Line 890: bis_collection_utilities.put_line(' ');

886:
887: l_mv_rec c_mvs_to_compile%rowtype;
888:
889: begin
890: bis_collection_utilities.put_line(' ');
891: bis_collection_utilities.put_line('Re-compiling INVALID MVs in RSG');
892: IF (g_apps_schema_name IS NULL) THEN
893: g_apps_schema_name := get_apps_schema_name;
894: END IF;

Line 891: bis_collection_utilities.put_line('Re-compiling INVALID MVs in RSG');

887: l_mv_rec c_mvs_to_compile%rowtype;
888:
889: begin
890: bis_collection_utilities.put_line(' ');
891: bis_collection_utilities.put_line('Re-compiling INVALID MVs in RSG');
892: IF (g_apps_schema_name IS NULL) THEN
893: g_apps_schema_name := get_apps_schema_name;
894: END IF;
895: for l_mv_rec_bop in c_mvs_from_bop loop

Line 901: bis_collection_utilities.put_line('Compiled Invalid MV - '||l_mv_rec.mview_name);

897: fetch c_mvs_to_compile into l_mv_rec;
898: -- Modified for bug#8419783
899: if(c_mvs_to_compile%FOUND) then
900: execute immediate 'alter materialized view '||l_mv_rec.mview_name||' compile ';
901: bis_collection_utilities.put_line('Compiled Invalid MV - '||l_mv_rec.mview_name);
902: end if;
903: close c_mvs_to_compile;
904: end loop;
905: bis_collection_utilities.put_line('Compiled all INVALID MVs in RSG ');

Line 905: bis_collection_utilities.put_line('Compiled all INVALID MVs in RSG ');

901: bis_collection_utilities.put_line('Compiled Invalid MV - '||l_mv_rec.mview_name);
902: end if;
903: close c_mvs_to_compile;
904: end loop;
905: bis_collection_utilities.put_line('Compiled all INVALID MVs in RSG ');
906: exception
907: when others then
908: bis_collection_utilities.put_line(sqlerrm);
909: RAISE;

Line 908: bis_collection_utilities.put_line(sqlerrm);

904: end loop;
905: bis_collection_utilities.put_line('Compiled all INVALID MVs in RSG ');
906: exception
907: when others then
908: bis_collection_utilities.put_line(sqlerrm);
909: RAISE;
910: end;
911:
912:

Line 1047: IF (Not BIS_COLLECTION_UTILITIES.setup('BIS_MV_REFRESH.CONSIDER_REFRESH')) THEN

1043: BEGIN
1044:
1045: errbuf := NULL;
1046: retcode := '0';
1047: IF (Not BIS_COLLECTION_UTILITIES.setup('BIS_MV_REFRESH.CONSIDER_REFRESH')) THEN
1048: RAISE_APPLICATION_ERROR (-20000,'Error in SETUP: ' || errbuf);
1049: return;
1050: END IF;
1051:

Line 1137: BIS_COLLECTION_UTILITIES.put_line(' ');

1133: WHEN OTHERS THEN
1134: ROLLBACK;
1135: errbuf := sqlerrm;
1136: retcode := sqlcode;
1137: BIS_COLLECTION_UTILITIES.put_line(' ');
1138: BIS_COLLECTION_UTILITIES.put_line('Error occurred:');
1139: BIS_COLLECTION_UTILITIES.put_line(errbuf);
1140: g_program_status := fnd_concurrent.set_completion_status('ERROR' ,NULL);
1141:

Line 1138: BIS_COLLECTION_UTILITIES.put_line('Error occurred:');

1134: ROLLBACK;
1135: errbuf := sqlerrm;
1136: retcode := sqlcode;
1137: BIS_COLLECTION_UTILITIES.put_line(' ');
1138: BIS_COLLECTION_UTILITIES.put_line('Error occurred:');
1139: BIS_COLLECTION_UTILITIES.put_line(errbuf);
1140: g_program_status := fnd_concurrent.set_completion_status('ERROR' ,NULL);
1141:
1142: BIS_COLLECTION_UTILITIES.WRAPUP(

Line 1139: BIS_COLLECTION_UTILITIES.put_line(errbuf);

1135: errbuf := sqlerrm;
1136: retcode := sqlcode;
1137: BIS_COLLECTION_UTILITIES.put_line(' ');
1138: BIS_COLLECTION_UTILITIES.put_line('Error occurred:');
1139: BIS_COLLECTION_UTILITIES.put_line(errbuf);
1140: g_program_status := fnd_concurrent.set_completion_status('ERROR' ,NULL);
1141:
1142: BIS_COLLECTION_UTILITIES.WRAPUP(
1143: FALSE,

Line 1142: BIS_COLLECTION_UTILITIES.WRAPUP(

1138: BIS_COLLECTION_UTILITIES.put_line('Error occurred:');
1139: BIS_COLLECTION_UTILITIES.put_line(errbuf);
1140: g_program_status := fnd_concurrent.set_completion_status('ERROR' ,NULL);
1141:
1142: BIS_COLLECTION_UTILITIES.WRAPUP(
1143: FALSE,
1144: 0,
1145: errbuf,
1146: null,

Line 1242: IF (Not BIS_COLLECTION_UTILITIES.setup('BIS_MV_REFRESH.LOG_DETAIL')) THEN

1238: BEGIN
1239:
1240: errbuf := NULL;
1241: retcode := '0';
1242: IF (Not BIS_COLLECTION_UTILITIES.setup('BIS_MV_REFRESH.LOG_DETAIL')) THEN
1243: RAISE_APPLICATION_ERROR (-20000,'Error in SETUP: ' || errbuf);
1244: return;
1245: END IF;
1246:

Line 1280: BIS_COLLECTION_UTILITIES.put_line(' ');

1276: WHEN OTHERS THEN
1277: ROLLBACK;
1278: errbuf := sqlerrm;
1279: retcode := sqlcode;
1280: BIS_COLLECTION_UTILITIES.put_line(' ');
1281: BIS_COLLECTION_UTILITIES.put_line('Error occurred:');
1282: BIS_COLLECTION_UTILITIES.put_line(errbuf);
1283: g_program_status := fnd_concurrent.set_completion_status('ERROR' ,NULL);
1284:

Line 1281: BIS_COLLECTION_UTILITIES.put_line('Error occurred:');

1277: ROLLBACK;
1278: errbuf := sqlerrm;
1279: retcode := sqlcode;
1280: BIS_COLLECTION_UTILITIES.put_line(' ');
1281: BIS_COLLECTION_UTILITIES.put_line('Error occurred:');
1282: BIS_COLLECTION_UTILITIES.put_line(errbuf);
1283: g_program_status := fnd_concurrent.set_completion_status('ERROR' ,NULL);
1284:
1285: BIS_COLLECTION_UTILITIES.WRAPUP(

Line 1282: BIS_COLLECTION_UTILITIES.put_line(errbuf);

1278: errbuf := sqlerrm;
1279: retcode := sqlcode;
1280: BIS_COLLECTION_UTILITIES.put_line(' ');
1281: BIS_COLLECTION_UTILITIES.put_line('Error occurred:');
1282: BIS_COLLECTION_UTILITIES.put_line(errbuf);
1283: g_program_status := fnd_concurrent.set_completion_status('ERROR' ,NULL);
1284:
1285: BIS_COLLECTION_UTILITIES.WRAPUP(
1286: FALSE,

Line 1285: BIS_COLLECTION_UTILITIES.WRAPUP(

1281: BIS_COLLECTION_UTILITIES.put_line('Error occurred:');
1282: BIS_COLLECTION_UTILITIES.put_line(errbuf);
1283: g_program_status := fnd_concurrent.set_completion_status('ERROR' ,NULL);
1284:
1285: BIS_COLLECTION_UTILITIES.WRAPUP(
1286: FALSE,
1287: 0,
1288: errbuf,
1289: null,

Line 1348: IF (Not BIS_COLLECTION_UTILITIES.setup(P_MVNAME)) THEN

1344:
1345: -- get current request id information from FND to put in Summary report table.
1346: prog_request_id := FND_GLOBAL.conc_request_id;
1347:
1348: IF (Not BIS_COLLECTION_UTILITIES.setup(P_MVNAME)) THEN
1349: RAISE_APPLICATION_ERROR (-20000,'Error in SETUP: ' || sqlerrm);
1350: return;
1351: END IF;
1352:

Line 1353: BIS_COLLECTION_UTILITIES.put_line('Start refreshing for ' || p_mvname || ', mode ' || P_REFRESHMODE);

1349: RAISE_APPLICATION_ERROR (-20000,'Error in SETUP: ' || sqlerrm);
1350: return;
1351: END IF;
1352:
1353: BIS_COLLECTION_UTILITIES.put_line('Start refreshing for ' || p_mvname || ', mode ' || P_REFRESHMODE);
1354: BIS_COLLECTION_UTILITIES.get_last_refresh_dates(
1355: p_mvname,
1356: l_start,
1357: l_end,

Line 1354: BIS_COLLECTION_UTILITIES.get_last_refresh_dates(

1350: return;
1351: END IF;
1352:
1353: BIS_COLLECTION_UTILITIES.put_line('Start refreshing for ' || p_mvname || ', mode ' || P_REFRESHMODE);
1354: BIS_COLLECTION_UTILITIES.get_last_refresh_dates(
1355: p_mvname,
1356: l_start,
1357: l_end,
1358: l_period_from,

Line 1363: BIS_COLLECTION_UTILITIES.put_line('Skipped refreshing for ' || P_MVNAME);

1359: l_from_date);
1360: l_to_date := sysdate;
1361:
1362: IF ( NOT VALIDATE(p_mvname)) THEN
1363: BIS_COLLECTION_UTILITIES.put_line('Skipped refreshing for ' || P_MVNAME);
1364: ELSE
1365:
1366: /** Comment out check implementation flag for bug 4532066
1367: IF( NOT IS_IMPLEMENTED(P_MVNAME)) THEN

Line 1373: BIS_COLLECTION_UTILITIES.put_line(p_mvname||' was not refreshed because it was not implemented. It will be marked as refreshed');

1369: -- a batch task at the end of resquest set will do it for
1370: -- MVs not implemented.
1371: -- CONSIDER_REFRESH(P_MVNAME);
1372: -- Added for bug 3626375 Log Messages
1373: BIS_COLLECTION_UTILITIES.put_line(p_mvname||' was not refreshed because it was not implemented. It will be marked as refreshed');
1374: BIS_COLLECTION_UTILITIES.put_line('in ''BIS Materialized View Batch Refresh Program for MVs not to implement'' at the last stage of the request set.');
1375: -- code end for bug 3626375
1376:
1377: ---- l_mv_refresh_type := 'CONSIDER_REFRESH';

Line 1374: BIS_COLLECTION_UTILITIES.put_line('in ''BIS Materialized View Batch Refresh Program for MVs not to implement'' at the last stage of the request set.');

1370: -- MVs not implemented.
1371: -- CONSIDER_REFRESH(P_MVNAME);
1372: -- Added for bug 3626375 Log Messages
1373: BIS_COLLECTION_UTILITIES.put_line(p_mvname||' was not refreshed because it was not implemented. It will be marked as refreshed');
1374: BIS_COLLECTION_UTILITIES.put_line('in ''BIS Materialized View Batch Refresh Program for MVs not to implement'' at the last stage of the request set.');
1375: -- code end for bug 3626375
1376:
1377: ---- l_mv_refresh_type := 'CONSIDER_REFRESH';
1378:

Line 1400: BIS_COLLECTION_UTILITIES.put_line('End refreshing for ' || p_mvname);

1396: l_row_count := 0;
1397:
1398: updCacheByTopPortlet(p_mvname);
1399:
1400: BIS_COLLECTION_UTILITIES.put_line('End refreshing for ' || p_mvname);
1401:
1402: -----Here we only record the MV refreshed by BIS MV refresh program
1403: -----For MVs processed by "BIS Materialized View Batch Refresh Program for MVs not to implement",
1404: -----we will record them to history table in procedure CONSIDER_REFRESH

Line 1417: BIS_COLLECTION_UTILITIES.put_line('------------------------------------------------------------------');

1413: x_object_type => 'MV',
1414: x_refresh_type => l_mv_refresh_type,
1415: x_set_request_id => FND_GLOBAL.CONC_PRIORITY_REQUEST);
1416: ELSE
1417: BIS_COLLECTION_UTILITIES.put_line('------------------------------------------------------------------');
1418: BIS_COLLECTION_UTILITIES.put_line('Request Set History Collection Option is off for this Request Set.');
1419: BIS_COLLECTION_UTILITIES.put_line('No History Collection will happen for this request set.');
1420: BIS_COLLECTION_UTILITIES.put_line('------------------------------------------------------------------');
1421: END IF;

Line 1418: BIS_COLLECTION_UTILITIES.put_line('Request Set History Collection Option is off for this Request Set.');

1414: x_refresh_type => l_mv_refresh_type,
1415: x_set_request_id => FND_GLOBAL.CONC_PRIORITY_REQUEST);
1416: ELSE
1417: BIS_COLLECTION_UTILITIES.put_line('------------------------------------------------------------------');
1418: BIS_COLLECTION_UTILITIES.put_line('Request Set History Collection Option is off for this Request Set.');
1419: BIS_COLLECTION_UTILITIES.put_line('No History Collection will happen for this request set.');
1420: BIS_COLLECTION_UTILITIES.put_line('------------------------------------------------------------------');
1421: END IF;
1422:

Line 1419: BIS_COLLECTION_UTILITIES.put_line('No History Collection will happen for this request set.');

1415: x_set_request_id => FND_GLOBAL.CONC_PRIORITY_REQUEST);
1416: ELSE
1417: BIS_COLLECTION_UTILITIES.put_line('------------------------------------------------------------------');
1418: BIS_COLLECTION_UTILITIES.put_line('Request Set History Collection Option is off for this Request Set.');
1419: BIS_COLLECTION_UTILITIES.put_line('No History Collection will happen for this request set.');
1420: BIS_COLLECTION_UTILITIES.put_line('------------------------------------------------------------------');
1421: END IF;
1422:
1423: --- END IF; -- end NOT IS_IMPLEMENTED comment out check for impl flag for bug 4532066

Line 1420: BIS_COLLECTION_UTILITIES.put_line('------------------------------------------------------------------');

1416: ELSE
1417: BIS_COLLECTION_UTILITIES.put_line('------------------------------------------------------------------');
1418: BIS_COLLECTION_UTILITIES.put_line('Request Set History Collection Option is off for this Request Set.');
1419: BIS_COLLECTION_UTILITIES.put_line('No History Collection will happen for this request set.');
1420: BIS_COLLECTION_UTILITIES.put_line('------------------------------------------------------------------');
1421: END IF;
1422:
1423: --- END IF; -- end NOT IS_IMPLEMENTED comment out check for impl flag for bug 4532066
1424: END IF; -- end NOT VALIDATE

Line 1429: BIS_COLLECTION_UTILITIES.WRAPUP(

1425:
1426: g_program_status := fnd_concurrent.set_completion_status(g_program_status_var ,NULL);
1427:
1428:
1429: BIS_COLLECTION_UTILITIES.WRAPUP(
1430: TRUE, -- status
1431: l_row_count, -- count
1432: NULL, -- message
1433: l_from_date, -- period_from

Line 1436: BIS_COLLECTION_UTILITIES.put_line(' ');

1432: NULL, -- message
1433: l_from_date, -- period_from
1434: l_to_date); -- period_to
1435:
1436: BIS_COLLECTION_UTILITIES.put_line(' ');
1437:
1438: EXCEPTION
1439: WHEN L_FAILURE THEN
1440: ROLLBACK;

Line 1441: BIS_COLLECTION_UTILITIES.put_line(' ');

1437:
1438: EXCEPTION
1439: WHEN L_FAILURE THEN
1440: ROLLBACK;
1441: BIS_COLLECTION_UTILITIES.put_line(' ');
1442: BIS_COLLECTION_UTILITIES.put_line('Error occurred:');
1443: BIS_COLLECTION_UTILITIES.put_line(g_errbuf);
1444: retcode := to_char(g_errcode);
1445: errbuf := g_errbuf;

Line 1442: BIS_COLLECTION_UTILITIES.put_line('Error occurred:');

1438: EXCEPTION
1439: WHEN L_FAILURE THEN
1440: ROLLBACK;
1441: BIS_COLLECTION_UTILITIES.put_line(' ');
1442: BIS_COLLECTION_UTILITIES.put_line('Error occurred:');
1443: BIS_COLLECTION_UTILITIES.put_line(g_errbuf);
1444: retcode := to_char(g_errcode);
1445: errbuf := g_errbuf;
1446:

Line 1443: BIS_COLLECTION_UTILITIES.put_line(g_errbuf);

1439: WHEN L_FAILURE THEN
1440: ROLLBACK;
1441: BIS_COLLECTION_UTILITIES.put_line(' ');
1442: BIS_COLLECTION_UTILITIES.put_line('Error occurred:');
1443: BIS_COLLECTION_UTILITIES.put_line(g_errbuf);
1444: retcode := to_char(g_errcode);
1445: errbuf := g_errbuf;
1446:
1447: BIS_COLLECTION_UTILITIES.WRAPUP(

Line 1447: BIS_COLLECTION_UTILITIES.WRAPUP(

1443: BIS_COLLECTION_UTILITIES.put_line(g_errbuf);
1444: retcode := to_char(g_errcode);
1445: errbuf := g_errbuf;
1446:
1447: BIS_COLLECTION_UTILITIES.WRAPUP(
1448: FALSE,
1449: l_row_count,
1450: g_errbuf,
1451: l_from_date,

Line 1459: BIS_COLLECTION_UTILITIES.put_line(' ');

1455: WHEN OTHERS THEN
1456: ROLLBACK;
1457: errbuf := sqlerrm;
1458: retcode := sqlcode;
1459: BIS_COLLECTION_UTILITIES.put_line(' ');
1460: BIS_COLLECTION_UTILITIES.put_line('Error occurred:');
1461: BIS_COLLECTION_UTILITIES.put_line(errbuf);
1462:
1463: BIS_COLLECTION_UTILITIES.WRAPUP(

Line 1460: BIS_COLLECTION_UTILITIES.put_line('Error occurred:');

1456: ROLLBACK;
1457: errbuf := sqlerrm;
1458: retcode := sqlcode;
1459: BIS_COLLECTION_UTILITIES.put_line(' ');
1460: BIS_COLLECTION_UTILITIES.put_line('Error occurred:');
1461: BIS_COLLECTION_UTILITIES.put_line(errbuf);
1462:
1463: BIS_COLLECTION_UTILITIES.WRAPUP(
1464: FALSE,

Line 1461: BIS_COLLECTION_UTILITIES.put_line(errbuf);

1457: errbuf := sqlerrm;
1458: retcode := sqlcode;
1459: BIS_COLLECTION_UTILITIES.put_line(' ');
1460: BIS_COLLECTION_UTILITIES.put_line('Error occurred:');
1461: BIS_COLLECTION_UTILITIES.put_line(errbuf);
1462:
1463: BIS_COLLECTION_UTILITIES.WRAPUP(
1464: FALSE,
1465: l_row_count,

Line 1463: BIS_COLLECTION_UTILITIES.WRAPUP(

1459: BIS_COLLECTION_UTILITIES.put_line(' ');
1460: BIS_COLLECTION_UTILITIES.put_line('Error occurred:');
1461: BIS_COLLECTION_UTILITIES.put_line(errbuf);
1462:
1463: BIS_COLLECTION_UTILITIES.WRAPUP(
1464: FALSE,
1465: l_row_count,
1466: errbuf,
1467: l_from_date,

Line 1482: BIS_COLLECTION_UTILITIES.put_line('Program to collect the data about MV refresh required by RSG Analysis Report');

1478: p_set_request_id IN NUMBER
1479: )
1480: IS
1481: BEGIN
1482: BIS_COLLECTION_UTILITIES.put_line('Program to collect the data about MV refresh required by RSG Analysis Report');
1483: BIS_COLLECTION_UTILITIES.put_line('MV Refresh Program Request Id # '|| p_request_id);
1484: BIS_COLLECTION_UTILITIES.put_line('MV Name '|| p_object_name);
1485: BIS_COLLECTION_UTILITIES.put_line('Refresh Type '|| p_refresh_type);
1486:

Line 1483: BIS_COLLECTION_UTILITIES.put_line('MV Refresh Program Request Id # '|| p_request_id);

1479: )
1480: IS
1481: BEGIN
1482: BIS_COLLECTION_UTILITIES.put_line('Program to collect the data about MV refresh required by RSG Analysis Report');
1483: BIS_COLLECTION_UTILITIES.put_line('MV Refresh Program Request Id # '|| p_request_id);
1484: BIS_COLLECTION_UTILITIES.put_line('MV Name '|| p_object_name);
1485: BIS_COLLECTION_UTILITIES.put_line('Refresh Type '|| p_refresh_type);
1486:
1487: BIS_COLL_RS_HISTORY.insert_program_object_data(x_request_id => p_request_id,

Line 1484: BIS_COLLECTION_UTILITIES.put_line('MV Name '|| p_object_name);

1480: IS
1481: BEGIN
1482: BIS_COLLECTION_UTILITIES.put_line('Program to collect the data about MV refresh required by RSG Analysis Report');
1483: BIS_COLLECTION_UTILITIES.put_line('MV Refresh Program Request Id # '|| p_request_id);
1484: BIS_COLLECTION_UTILITIES.put_line('MV Name '|| p_object_name);
1485: BIS_COLLECTION_UTILITIES.put_line('Refresh Type '|| p_refresh_type);
1486:
1487: BIS_COLL_RS_HISTORY.insert_program_object_data(x_request_id => p_request_id,
1488: x_stage_req_id => null,

Line 1485: BIS_COLLECTION_UTILITIES.put_line('Refresh Type '|| p_refresh_type);

1481: BEGIN
1482: BIS_COLLECTION_UTILITIES.put_line('Program to collect the data about MV refresh required by RSG Analysis Report');
1483: BIS_COLLECTION_UTILITIES.put_line('MV Refresh Program Request Id # '|| p_request_id);
1484: BIS_COLLECTION_UTILITIES.put_line('MV Name '|| p_object_name);
1485: BIS_COLLECTION_UTILITIES.put_line('Refresh Type '|| p_refresh_type);
1486:
1487: BIS_COLL_RS_HISTORY.insert_program_object_data(x_request_id => p_request_id,
1488: x_stage_req_id => null,
1489: x_object_name => p_object_name ,

Line 1494: BIS_COLLECTION_UTILITIES.put_line('Completed data collection about MV refresh required by RSG Analysis Report');

1490: x_object_type => 'MV',
1491: x_refresh_type => p_refresh_type,
1492: x_set_request_id => p_set_request_id);
1493:
1494: BIS_COLLECTION_UTILITIES.put_line('Completed data collection about MV refresh required by RSG Analysis Report');
1495: EXCEPTION
1496: WHEN OTHERS THEN
1497: errbuf := sqlerrm;
1498: retcode := sqlcode;

Line 1499: BIS_COLLECTION_UTILITIES.put_line('Exception in collect_mv_refresh_info :: '|| sqlcode || ' :: ' ||sqlerrm);

1495: EXCEPTION
1496: WHEN OTHERS THEN
1497: errbuf := sqlerrm;
1498: retcode := sqlcode;
1499: BIS_COLLECTION_UTILITIES.put_line('Exception in collect_mv_refresh_info :: '|| sqlcode || ' :: ' ||sqlerrm);
1500: RAISE;
1501: END;
1502: */
1503: PROCEDURE COMPILE_INVALID_MVS(

Line 1511: BIS_COLLECTION_UTILITIES.put_line('Starting Compiling Invalid MVs');

1507: l_refresh_progs number;
1508: e_refresh_prog_running EXCEPTION;
1509: l_program_status boolean := true;
1510: BEGIN
1511: BIS_COLLECTION_UTILITIES.put_line('Starting Compiling Invalid MVs');
1512: BIS_COLLECTION_UTILITIES.put_line(' ');
1513: l_refresh_progs := BIS_TRUNCATE_EMPTY_MV_LOG_PKG.Check_Refresh_Prog_running;
1514: if(l_refresh_progs <> 0) then
1515: raise e_refresh_prog_running;

Line 1512: BIS_COLLECTION_UTILITIES.put_line(' ');

1508: e_refresh_prog_running EXCEPTION;
1509: l_program_status boolean := true;
1510: BEGIN
1511: BIS_COLLECTION_UTILITIES.put_line('Starting Compiling Invalid MVs');
1512: BIS_COLLECTION_UTILITIES.put_line(' ');
1513: l_refresh_progs := BIS_TRUNCATE_EMPTY_MV_LOG_PKG.Check_Refresh_Prog_running;
1514: if(l_refresh_progs <> 0) then
1515: raise e_refresh_prog_running;
1516: end if;

Line 1518: BIS_COLLECTION_UTILITIES.put_line(' ');

1514: if(l_refresh_progs <> 0) then
1515: raise e_refresh_prog_running;
1516: end if;
1517: compile_mvs;
1518: BIS_COLLECTION_UTILITIES.put_line(' ');
1519: BIS_COLLECTION_UTILITIES.put_line('Completing Compiling Invalid MVs');
1520: EXCEPTION
1521: WHEN e_refresh_prog_running THEN
1522: BIS_COLLECTION_UTILITIES.put_line(' ');

Line 1519: BIS_COLLECTION_UTILITIES.put_line('Completing Compiling Invalid MVs');

1515: raise e_refresh_prog_running;
1516: end if;
1517: compile_mvs;
1518: BIS_COLLECTION_UTILITIES.put_line(' ');
1519: BIS_COLLECTION_UTILITIES.put_line('Completing Compiling Invalid MVs');
1520: EXCEPTION
1521: WHEN e_refresh_prog_running THEN
1522: BIS_COLLECTION_UTILITIES.put_line(' ');
1523: IF (l_refresh_progs = 1) THEN

Line 1522: BIS_COLLECTION_UTILITIES.put_line(' ');

1518: BIS_COLLECTION_UTILITIES.put_line(' ');
1519: BIS_COLLECTION_UTILITIES.put_line('Completing Compiling Invalid MVs');
1520: EXCEPTION
1521: WHEN e_refresh_prog_running THEN
1522: BIS_COLLECTION_UTILITIES.put_line(' ');
1523: IF (l_refresh_progs = 1) THEN
1524: BIS_COLLECTION_UTILITIES.put_line('Error in Compiling Invalid MVs- DBI Refresh program is running' );
1525: ELSE
1526: BIS_COLLECTION_UTILITIES.put_line('Error in Compiling Invalid MVs - MV is being refreshed' );

Line 1524: BIS_COLLECTION_UTILITIES.put_line('Error in Compiling Invalid MVs- DBI Refresh program is running' );

1520: EXCEPTION
1521: WHEN e_refresh_prog_running THEN
1522: BIS_COLLECTION_UTILITIES.put_line(' ');
1523: IF (l_refresh_progs = 1) THEN
1524: BIS_COLLECTION_UTILITIES.put_line('Error in Compiling Invalid MVs- DBI Refresh program is running' );
1525: ELSE
1526: BIS_COLLECTION_UTILITIES.put_line('Error in Compiling Invalid MVs - MV is being refreshed' );
1527: END IF;
1528: BIS_COLLECTION_UTILITIES.put_line('Please run Compiling Invalid MVs when there are no Refresh request-set/programs running');

Line 1526: BIS_COLLECTION_UTILITIES.put_line('Error in Compiling Invalid MVs - MV is being refreshed' );

1522: BIS_COLLECTION_UTILITIES.put_line(' ');
1523: IF (l_refresh_progs = 1) THEN
1524: BIS_COLLECTION_UTILITIES.put_line('Error in Compiling Invalid MVs- DBI Refresh program is running' );
1525: ELSE
1526: BIS_COLLECTION_UTILITIES.put_line('Error in Compiling Invalid MVs - MV is being refreshed' );
1527: END IF;
1528: BIS_COLLECTION_UTILITIES.put_line('Please run Compiling Invalid MVs when there are no Refresh request-set/programs running');
1529: l_program_status := fnd_concurrent.set_completion_status('Error' ,NULL);
1530: errbuf := 'DBI Refresh Program Running';

Line 1528: BIS_COLLECTION_UTILITIES.put_line('Please run Compiling Invalid MVs when there are no Refresh request-set/programs running');

1524: BIS_COLLECTION_UTILITIES.put_line('Error in Compiling Invalid MVs- DBI Refresh program is running' );
1525: ELSE
1526: BIS_COLLECTION_UTILITIES.put_line('Error in Compiling Invalid MVs - MV is being refreshed' );
1527: END IF;
1528: BIS_COLLECTION_UTILITIES.put_line('Please run Compiling Invalid MVs when there are no Refresh request-set/programs running');
1529: l_program_status := fnd_concurrent.set_completion_status('Error' ,NULL);
1530: errbuf := 'DBI Refresh Program Running';
1531: WHEN OTHERS THEN
1532: BIS_COLLECTION_UTILITIES.put_line('Error in Compiling Invalid MVs '|| sqlerrm);

Line 1532: BIS_COLLECTION_UTILITIES.put_line('Error in Compiling Invalid MVs '|| sqlerrm);

1528: BIS_COLLECTION_UTILITIES.put_line('Please run Compiling Invalid MVs when there are no Refresh request-set/programs running');
1529: l_program_status := fnd_concurrent.set_completion_status('Error' ,NULL);
1530: errbuf := 'DBI Refresh Program Running';
1531: WHEN OTHERS THEN
1532: BIS_COLLECTION_UTILITIES.put_line('Error in Compiling Invalid MVs '|| sqlerrm);
1533: l_program_status := fnd_concurrent.set_completion_status('Error' ,NULL);
1534: errbuf := sqlerrm;
1535: retcode := sqlcode;
1536: END;