APPS.MSC_REFRESH_MV dependencies on MSC_UTIL

Line 29: msc_util.msc_log('Begin REFRESH_MAT_VIEWS');

25: WHERE object_name = p_mv_trim_name
26: AND owner = p_schema_name;
27:
28: BEGIN
29: msc_util.msc_log('Begin REFRESH_MAT_VIEWS');
30: RETCODE:= G_SUCCESS;
31:
32: select nvl(ltrim(rtrim(upper(p_mv_name))), '@@@') into l_mv_name from dual;
33:

Line 43: -- msc_util.msc_log('Refreshing ' || l_mv_name);

39: FETCH mv_exist INTO l_mv_exist;
40: CLOSE mv_exist;
41:
42: if (l_mv_exist = 1) then
43: -- msc_util.msc_log('Refreshing ' || l_mv_name);
44: fnd_message.set_name('MSC','MSC_REF_MV_EXIST_PRE');
45: fnd_message.set_token('VIEW_NAME',l_mv_name);
46: msc_util.msc_log(fnd_message.get);
47: DBMS_SNAPSHOT.REFRESH( l_schema_name||'.'||l_mv_name , l_complete_refresh_flag);

Line 46: msc_util.msc_log(fnd_message.get);

42: if (l_mv_exist = 1) then
43: -- msc_util.msc_log('Refreshing ' || l_mv_name);
44: fnd_message.set_name('MSC','MSC_REF_MV_EXIST_PRE');
45: fnd_message.set_token('VIEW_NAME',l_mv_name);
46: msc_util.msc_log(fnd_message.get);
47: DBMS_SNAPSHOT.REFRESH( l_schema_name||'.'||l_mv_name , l_complete_refresh_flag);
48: else
49: -- msc_util.msc_log(l_schema_name||'.'||l_mv_name ||' does not exist');
50: fnd_message.set_name('MSC','MSC_REF_MV_EXIST_ERR');

Line 49: -- msc_util.msc_log(l_schema_name||'.'||l_mv_name ||' does not exist');

45: fnd_message.set_token('VIEW_NAME',l_mv_name);
46: msc_util.msc_log(fnd_message.get);
47: DBMS_SNAPSHOT.REFRESH( l_schema_name||'.'||l_mv_name , l_complete_refresh_flag);
48: else
49: -- msc_util.msc_log(l_schema_name||'.'||l_mv_name ||' does not exist');
50: fnd_message.set_name('MSC','MSC_REF_MV_EXIST_ERR');
51: fnd_message.set_token('VIEW_NAME',l_mv_name);
52: fnd_message.set_token('SCHEMA_NAME',l_schema_name);
53: msc_util.msc_log(fnd_message.get);

Line 53: msc_util.msc_log(fnd_message.get);

49: -- msc_util.msc_log(l_schema_name||'.'||l_mv_name ||' does not exist');
50: fnd_message.set_name('MSC','MSC_REF_MV_EXIST_ERR');
51: fnd_message.set_token('VIEW_NAME',l_mv_name);
52: fnd_message.set_token('SCHEMA_NAME',l_schema_name);
53: msc_util.msc_log(fnd_message.get);
54: RETCODE:= G_ERROR;
55: end if;
56:
57: msc_util.msc_log('End REFRESH_MAT_VIEWS');

Line 57: msc_util.msc_log('End REFRESH_MAT_VIEWS');

53: msc_util.msc_log(fnd_message.get);
54: RETCODE:= G_ERROR;
55: end if;
56:
57: msc_util.msc_log('End REFRESH_MAT_VIEWS');
58:
59: EXCEPTION
60:
61: WHEN OTHERS THEN

Line 62: msc_util.msc_log(sqlerrm);

58:
59: EXCEPTION
60:
61: WHEN OTHERS THEN
62: msc_util.msc_log(sqlerrm);
63: RETCODE:= G_ERROR;
64: ERRBUF:= SQLERRM;
65:
66: END REFRESH_MAT_VIEWS;