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.

[Home] [Help]

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 899: bis_collection_utilities.put_line('Compiled '||l_mv_rec.mview_name);

895: for l_mv_rec_bop in c_mvs_from_bop loop
896: open c_mvs_to_compile(l_mv_rec_bop.object_name);
897: fetch c_mvs_to_compile into l_mv_rec;
898: execute immediate 'alter materialized view '||l_mv_rec.mview_name||' compile ';
899: bis_collection_utilities.put_line('Compiled '||l_mv_rec.mview_name);
900: end loop;
901: bis_collection_utilities.put_line('Compiled all INVALID MVs in RSG');
902: exception
903: when others then

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

897: fetch c_mvs_to_compile into l_mv_rec;
898: execute immediate 'alter materialized view '||l_mv_rec.mview_name||' compile ';
899: bis_collection_utilities.put_line('Compiled '||l_mv_rec.mview_name);
900: end loop;
901: bis_collection_utilities.put_line('Compiled all INVALID MVs in RSG');
902: exception
903: when others then
904: bis_collection_utilities.put_line(sqlerrm);
905: RAISE;

Line 904: bis_collection_utilities.put_line(sqlerrm);

900: end loop;
901: bis_collection_utilities.put_line('Compiled all INVALID MVs in RSG');
902: exception
903: when others then
904: bis_collection_utilities.put_line(sqlerrm);
905: RAISE;
906: end;
907:
908:

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

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

Line 1133: BIS_COLLECTION_UTILITIES.put_line(' ');

1129: WHEN OTHERS THEN
1130: ROLLBACK;
1131: errbuf := sqlerrm;
1132: retcode := sqlcode;
1133: BIS_COLLECTION_UTILITIES.put_line(' ');
1134: BIS_COLLECTION_UTILITIES.put_line('Error occurred:');
1135: BIS_COLLECTION_UTILITIES.put_line(errbuf);
1136: g_program_status := fnd_concurrent.set_completion_status('ERROR' ,NULL);
1137:

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

1130: ROLLBACK;
1131: errbuf := sqlerrm;
1132: retcode := sqlcode;
1133: BIS_COLLECTION_UTILITIES.put_line(' ');
1134: BIS_COLLECTION_UTILITIES.put_line('Error occurred:');
1135: BIS_COLLECTION_UTILITIES.put_line(errbuf);
1136: g_program_status := fnd_concurrent.set_completion_status('ERROR' ,NULL);
1137:
1138: BIS_COLLECTION_UTILITIES.WRAPUP(

Line 1135: BIS_COLLECTION_UTILITIES.put_line(errbuf);

1131: errbuf := sqlerrm;
1132: retcode := sqlcode;
1133: BIS_COLLECTION_UTILITIES.put_line(' ');
1134: BIS_COLLECTION_UTILITIES.put_line('Error occurred:');
1135: BIS_COLLECTION_UTILITIES.put_line(errbuf);
1136: g_program_status := fnd_concurrent.set_completion_status('ERROR' ,NULL);
1137:
1138: BIS_COLLECTION_UTILITIES.WRAPUP(
1139: FALSE,

Line 1138: BIS_COLLECTION_UTILITIES.WRAPUP(

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

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

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

Line 1276: BIS_COLLECTION_UTILITIES.put_line(' ');

1272: WHEN OTHERS THEN
1273: ROLLBACK;
1274: errbuf := sqlerrm;
1275: retcode := sqlcode;
1276: BIS_COLLECTION_UTILITIES.put_line(' ');
1277: BIS_COLLECTION_UTILITIES.put_line('Error occurred:');
1278: BIS_COLLECTION_UTILITIES.put_line(errbuf);
1279: g_program_status := fnd_concurrent.set_completion_status('ERROR' ,NULL);
1280:

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

1273: ROLLBACK;
1274: errbuf := sqlerrm;
1275: retcode := sqlcode;
1276: BIS_COLLECTION_UTILITIES.put_line(' ');
1277: BIS_COLLECTION_UTILITIES.put_line('Error occurred:');
1278: BIS_COLLECTION_UTILITIES.put_line(errbuf);
1279: g_program_status := fnd_concurrent.set_completion_status('ERROR' ,NULL);
1280:
1281: BIS_COLLECTION_UTILITIES.WRAPUP(

Line 1278: BIS_COLLECTION_UTILITIES.put_line(errbuf);

1274: errbuf := sqlerrm;
1275: retcode := sqlcode;
1276: BIS_COLLECTION_UTILITIES.put_line(' ');
1277: BIS_COLLECTION_UTILITIES.put_line('Error occurred:');
1278: BIS_COLLECTION_UTILITIES.put_line(errbuf);
1279: g_program_status := fnd_concurrent.set_completion_status('ERROR' ,NULL);
1280:
1281: BIS_COLLECTION_UTILITIES.WRAPUP(
1282: FALSE,

Line 1281: BIS_COLLECTION_UTILITIES.WRAPUP(

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

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

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

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

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

Line 1350: BIS_COLLECTION_UTILITIES.get_last_refresh_dates(

1346: return;
1347: END IF;
1348:
1349: BIS_COLLECTION_UTILITIES.put_line('Start refreshing for ' || p_mvname || ', mode ' || P_REFRESHMODE);
1350: BIS_COLLECTION_UTILITIES.get_last_refresh_dates(
1351: p_mvname,
1352: l_start,
1353: l_end,
1354: l_period_from,

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

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

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

1365: -- a batch task at the end of resquest set will do it for
1366: -- MVs not implemented.
1367: -- CONSIDER_REFRESH(P_MVNAME);
1368: -- Added for bug 3626375 Log Messages
1369: BIS_COLLECTION_UTILITIES.put_line(p_mvname||' was not refreshed because it was not implemented. It will be marked as refreshed');
1370: 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.');
1371: -- code end for bug 3626375
1372:
1373: ---- l_mv_refresh_type := 'CONSIDER_REFRESH';

Line 1370: 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.');

1366: -- MVs not implemented.
1367: -- CONSIDER_REFRESH(P_MVNAME);
1368: -- Added for bug 3626375 Log Messages
1369: BIS_COLLECTION_UTILITIES.put_line(p_mvname||' was not refreshed because it was not implemented. It will be marked as refreshed');
1370: 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.');
1371: -- code end for bug 3626375
1372:
1373: ---- l_mv_refresh_type := 'CONSIDER_REFRESH';
1374:

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

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

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

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

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

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

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

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

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

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

Line 1425: BIS_COLLECTION_UTILITIES.WRAPUP(

1421:
1422: g_program_status := fnd_concurrent.set_completion_status(g_program_status_var ,NULL);
1423:
1424:
1425: BIS_COLLECTION_UTILITIES.WRAPUP(
1426: TRUE, -- status
1427: l_row_count, -- count
1428: NULL, -- message
1429: l_from_date, -- period_from

Line 1432: BIS_COLLECTION_UTILITIES.put_line(' ');

1428: NULL, -- message
1429: l_from_date, -- period_from
1430: l_to_date); -- period_to
1431:
1432: BIS_COLLECTION_UTILITIES.put_line(' ');
1433:
1434: EXCEPTION
1435: WHEN L_FAILURE THEN
1436: ROLLBACK;

Line 1437: BIS_COLLECTION_UTILITIES.put_line(' ');

1433:
1434: EXCEPTION
1435: WHEN L_FAILURE THEN
1436: ROLLBACK;
1437: BIS_COLLECTION_UTILITIES.put_line(' ');
1438: BIS_COLLECTION_UTILITIES.put_line('Error occurred:');
1439: BIS_COLLECTION_UTILITIES.put_line(g_errbuf);
1440: retcode := to_char(g_errcode);
1441: errbuf := g_errbuf;

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

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

Line 1439: BIS_COLLECTION_UTILITIES.put_line(g_errbuf);

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

Line 1443: BIS_COLLECTION_UTILITIES.WRAPUP(

1439: BIS_COLLECTION_UTILITIES.put_line(g_errbuf);
1440: retcode := to_char(g_errcode);
1441: errbuf := g_errbuf;
1442:
1443: BIS_COLLECTION_UTILITIES.WRAPUP(
1444: FALSE,
1445: l_row_count,
1446: g_errbuf,
1447: l_from_date,

Line 1455: BIS_COLLECTION_UTILITIES.put_line(' ');

1451: WHEN OTHERS THEN
1452: ROLLBACK;
1453: errbuf := sqlerrm;
1454: retcode := sqlcode;
1455: BIS_COLLECTION_UTILITIES.put_line(' ');
1456: BIS_COLLECTION_UTILITIES.put_line('Error occurred:');
1457: BIS_COLLECTION_UTILITIES.put_line(errbuf);
1458:
1459: BIS_COLLECTION_UTILITIES.WRAPUP(

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

1452: ROLLBACK;
1453: errbuf := sqlerrm;
1454: retcode := sqlcode;
1455: BIS_COLLECTION_UTILITIES.put_line(' ');
1456: BIS_COLLECTION_UTILITIES.put_line('Error occurred:');
1457: BIS_COLLECTION_UTILITIES.put_line(errbuf);
1458:
1459: BIS_COLLECTION_UTILITIES.WRAPUP(
1460: FALSE,

Line 1457: BIS_COLLECTION_UTILITIES.put_line(errbuf);

1453: errbuf := sqlerrm;
1454: retcode := sqlcode;
1455: BIS_COLLECTION_UTILITIES.put_line(' ');
1456: BIS_COLLECTION_UTILITIES.put_line('Error occurred:');
1457: BIS_COLLECTION_UTILITIES.put_line(errbuf);
1458:
1459: BIS_COLLECTION_UTILITIES.WRAPUP(
1460: FALSE,
1461: l_row_count,

Line 1459: BIS_COLLECTION_UTILITIES.WRAPUP(

1455: BIS_COLLECTION_UTILITIES.put_line(' ');
1456: BIS_COLLECTION_UTILITIES.put_line('Error occurred:');
1457: BIS_COLLECTION_UTILITIES.put_line(errbuf);
1458:
1459: BIS_COLLECTION_UTILITIES.WRAPUP(
1460: FALSE,
1461: l_row_count,
1462: errbuf,
1463: l_from_date,

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1508: BIS_COLLECTION_UTILITIES.put_line(' ');

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

Line 1514: BIS_COLLECTION_UTILITIES.put_line(' ');

1510: if(l_refresh_progs <> 0) then
1511: raise e_refresh_prog_running;
1512: end if;
1513: compile_mvs;
1514: BIS_COLLECTION_UTILITIES.put_line(' ');
1515: BIS_COLLECTION_UTILITIES.put_line('Completing Compiling Invalid MVs');
1516: EXCEPTION
1517: WHEN e_refresh_prog_running THEN
1518: BIS_COLLECTION_UTILITIES.put_line(' ');

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

1511: raise e_refresh_prog_running;
1512: end if;
1513: compile_mvs;
1514: BIS_COLLECTION_UTILITIES.put_line(' ');
1515: BIS_COLLECTION_UTILITIES.put_line('Completing Compiling Invalid MVs');
1516: EXCEPTION
1517: WHEN e_refresh_prog_running THEN
1518: BIS_COLLECTION_UTILITIES.put_line(' ');
1519: IF (l_refresh_progs = 1) THEN

Line 1518: BIS_COLLECTION_UTILITIES.put_line(' ');

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

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

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

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

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

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

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

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

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