APPS.BIS_MV_REFRESH dependencies on BIS_MV_REFRESH

Line 1: PACKAGE BODY BIS_MV_REFRESH AS

1: PACKAGE BODY BIS_MV_REFRESH AS
2: /* $Header: BISMVRFB.pls 120.15 2009/06/15 15:28:05 karthmoh ship $ */
3:
4: G_ERRBUF VARCHAR2(2000) := NULL;
5: G_ERRCODE NUMBER := 0;

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 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 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 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 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 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 1402: -----Here we only record the MV refreshed by BIS MV refresh program

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
1405:
1406: -- Enh#4418520-aguwalan

Line 1538: END BIS_MV_REFRESH;

1534: errbuf := sqlerrm;
1535: retcode := sqlcode;
1536: END;
1537:
1538: END BIS_MV_REFRESH;