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.10.12000000.5 2007/10/10 10:13:30 phattarg 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 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 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 1398: -----Here we only record the MV refreshed by BIS MV refresh program

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
1401:
1402: -- Enh#4418520-aguwalan

Line 1534: END BIS_MV_REFRESH;

1530: errbuf := sqlerrm;
1531: retcode := sqlcode;
1532: END;
1533:
1534: END BIS_MV_REFRESH;