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.MSC_REFRESH_MV dependencies on MSC_UTIL

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

26: WHERE object_name = p_mv_trim_name
27: AND owner = p_schema_name;
28:
29: BEGIN
30: msc_util.msc_log('Begin REFRESH_MAT_VIEWS');
31: RETCODE:= G_SUCCESS;
32:
33: select oracle_username
34: into l_apps_schema

Line 39: msc_util.msc_log('Snapshot is :'||l_mv_name);

35: from fnd_oracle_userid
36: where read_only_flag = 'U';
37:
38: select nvl(ltrim(rtrim(upper(p_mv_name))), '@@@') into l_mv_name from dual;
39: msc_util.msc_log('Snapshot is :'||l_mv_name);
40:
41: --Bug#12964070
42: IF l_mv_name = 'MSC_ATP_PLAN_SN' THEN
43: l_schema_name := l_apps_schema;

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

52: FETCH mv_exist INTO l_mv_exist;
53: CLOSE mv_exist;
54:
55: if (l_mv_exist = 1) then
56: -- msc_util.msc_log('Refreshing ' || l_mv_name);
57: fnd_message.set_name('MSC','MSC_REF_MV_EXIST_PRE');
58: fnd_message.set_token('VIEW_NAME',l_mv_name);
59: msc_util.msc_log(fnd_message.get);
60: DBMS_SNAPSHOT.REFRESH( l_schema_name||'.'||l_mv_name , l_complete_refresh_flag);

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

55: if (l_mv_exist = 1) then
56: -- msc_util.msc_log('Refreshing ' || l_mv_name);
57: fnd_message.set_name('MSC','MSC_REF_MV_EXIST_PRE');
58: fnd_message.set_token('VIEW_NAME',l_mv_name);
59: msc_util.msc_log(fnd_message.get);
60: DBMS_SNAPSHOT.REFRESH( l_schema_name||'.'||l_mv_name , l_complete_refresh_flag);
61: else
62: -- msc_util.msc_log(l_schema_name||'.'||l_mv_name ||' does not exist');
63: fnd_message.set_name('MSC','MSC_REF_MV_EXIST_ERR');

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

58: fnd_message.set_token('VIEW_NAME',l_mv_name);
59: msc_util.msc_log(fnd_message.get);
60: DBMS_SNAPSHOT.REFRESH( l_schema_name||'.'||l_mv_name , l_complete_refresh_flag);
61: else
62: -- msc_util.msc_log(l_schema_name||'.'||l_mv_name ||' does not exist');
63: fnd_message.set_name('MSC','MSC_REF_MV_EXIST_ERR');
64: fnd_message.set_token('VIEW_NAME',l_mv_name);
65: fnd_message.set_token('SCHEMA_NAME',l_schema_name);
66: msc_util.msc_log(fnd_message.get);

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

62: -- msc_util.msc_log(l_schema_name||'.'||l_mv_name ||' does not exist');
63: fnd_message.set_name('MSC','MSC_REF_MV_EXIST_ERR');
64: fnd_message.set_token('VIEW_NAME',l_mv_name);
65: fnd_message.set_token('SCHEMA_NAME',l_schema_name);
66: msc_util.msc_log(fnd_message.get);
67: RETCODE:= G_ERROR;
68: end if;
69:
70: msc_util.msc_log('End REFRESH_MAT_VIEWS');

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

66: msc_util.msc_log(fnd_message.get);
67: RETCODE:= G_ERROR;
68: end if;
69:
70: msc_util.msc_log('End REFRESH_MAT_VIEWS');
71:
72: EXCEPTION
73:
74: WHEN OTHERS THEN

Line 75: msc_util.msc_log(sqlerrm);

71:
72: EXCEPTION
73:
74: WHEN OTHERS THEN
75: msc_util.msc_log(sqlerrm);
76: RETCODE:= G_ERROR;
77: ERRBUF:= SQLERRM;
78:
79: END REFRESH_MAT_VIEWS;