DBA Data[Home] [Help]

APPS.MSC_REFRESH_MV dependencies on FND_MESSAGE

Line 57: fnd_message.set_name('MSC','MSC_REF_MV_EXIST_PRE');

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);
61: else

Line 58: fnd_message.set_token('VIEW_NAME',l_mv_name);

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);
61: else
62: -- msc_util.msc_log(l_schema_name||'.'||l_mv_name ||' does not exist');

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 63: fnd_message.set_name('MSC','MSC_REF_MV_EXIST_ERR');

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);
67: RETCODE:= G_ERROR;

Line 64: fnd_message.set_token('VIEW_NAME',l_mv_name);

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);
67: RETCODE:= G_ERROR;
68: end if;

Line 65: fnd_message.set_token('SCHEMA_NAME',l_schema_name);

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);
67: RETCODE:= G_ERROR;
68: end if;
69:

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');