DBA Data[Home] [Help]

APPS.MSC_REFRESH_MV dependencies on FND_MESSAGE

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

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

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

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

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

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

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

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

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

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);
54: RETCODE:= G_ERROR;
55: end if;
56:

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