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.EDW_GL_ACCT_M_T dependencies on EDW_LOG

Line 35: edw_log.put_line('debug mode true');

31: PROCEDURE INITDEBUG IS
32: BEGIN
33: IF (fnd_profile.value('EDW_DEBUG') = 'Y') THEN
34: g_debug := true;
35: edw_log.put_line('debug mode true');
36: ELSE
37: g_debug := false;
38: edw_log.put_line('debug mode false');
39: END IF;

Line 38: edw_log.put_line('debug mode false');

34: g_debug := true;
35: edw_log.put_line('debug mode true');
36: ELSE
37: g_debug := false;
38: edw_log.put_line('debug mode false');
39: END IF;
40: END INITDEBUG;
41:
42: PROCEDURE VBHDEBUG(

Line 48: -- as the edw_log.put_names was never called in EDW_OWB_COLLECTION_UTIL, the debug_line won't work.

44: IS
45: BEGIN
46: if( g_debug) then
47: -- calling put_line directly,
48: -- as the edw_log.put_names was never called in EDW_OWB_COLLECTION_UTIL, the debug_line won't work.
49: edw_log.put_line(p_log);
50: end if;
51: END VBHDEBUG ;
52:

Line 49: edw_log.put_line(p_log);

45: BEGIN
46: if( g_debug) then
47: -- calling put_line directly,
48: -- as the edw_log.put_names was never called in EDW_OWB_COLLECTION_UTIL, the debug_line won't work.
49: edw_log.put_line(p_log);
50: end if;
51: END VBHDEBUG ;
52:
53: /**

Line 64: edw_log.put_line('FND_INSTALLATION.GET_APP_INFO returned with error');

60: l_prod_no VARCHAR2(30);
61: Begin
62: l_prod_no :='BIS';
63: if FND_INSTALLATION.GET_APP_INFO(l_prod_no,l_dummy1, l_dummy2,l_schema) = false then
64: edw_log.put_line('FND_INSTALLATION.GET_APP_INFO returned with error');
65: return null;
66: end if;
67: return l_schema;
68: Exception when others then

Line 69: edw_log.put_line('Error in get_schema_name '||sqlerrm);

65: return null;
66: end if;
67: return l_schema;
68: Exception when others then
69: edw_log.put_line('Error in get_schema_name '||sqlerrm);
70: return null;
71: End;
72:
73: -- -----------------------------------------------------------------------

Line 118: edw_log.put_line('Error :'||

114: p_result:=false;
115: DBMS_SQL.close_cursor(l_cursor_id);
116:
117: if(sqlcode = -1436) then
118: edw_log.put_line('Error :'||
119: 'When checking precedence between ' || p_acct_name1 || ' and ' ||
120: p_acct_name2 || ' in '|| g_vbh_temp_table_name
121: ||'. '||sqlcode||' : '||sqlerrm);
122: else

Line 123: edw_log.put_line('Error :'||

119: 'When checking precedence between ' || p_acct_name1 || ' and ' ||
120: p_acct_name2 || ' in '|| g_vbh_temp_table_name
121: ||'. '||sqlcode||' : '||sqlerrm);
122: else
123: edw_log.put_line('Error :'||
124: 'When updating the TYPE for '|| g_vbh_temp_table_name
125: ||'. '||sqlcode||' : '||sqlerrm);
126: end if;
127:

Line 161: edw_log.put_line('Error:'||

157: end loop; --for cur_edw_account_class
158: close cur_edw_account_class ;
159: exception
160: when others then
161: edw_log.put_line('Error:'||
162: 'When reading in table edw_segment_classes for '
163: ||g_dimension_name ||'. '||sqlcode||' : '||sqlerrm);
164: raise;
165: end load_type_table;

Line 211: edw_log.put_line(

207: end loop;--for while loop
208:
209: exception
210: when others then
211: edw_log.put_line(
212: 'Error: When reordering edw_segment_classes table for '|| g_dimension_name||'. '||sqlcode||' : '||sqlerrm);
213: raise;
214: end reorder_type_table;
215:

Line 250: edw_log.put_line('Error:'||

246: DBMS_SQL.CLOSE_CURSOR(l_CursorID);
247: exception
248: when others then
249: DBMS_SQL.close_cursor(l_CursorID);
250: edw_log.put_line('Error:'||
251: 'when updating table '|| g_vbh_temp_table_name||' for '||
252: p_acct_name||' '||sqlcode||' : '||sqlerrm);
253: raise;
254: END update_temp_table;

Line 292: edw_log.put_line(

288: close cur_vbh_temp;
289: end loop;
290: exception
291: when others then
292: edw_log.put_line(
293: 'Error : When updating account type in '|| g_dimension_name
294: ||' '||sqlcode||' : '||sqlerrm);
295: raise;
296: end;

Line 312: edw_Log.put_line('error happened when truncate '||g_vbh_temp_table_name||' '||sqlcode||':'||sqlerrm);

308: VBHDEBUG('finished truncate '||g_vbh_temp_table_name);
309: commit;
310: exception
311: when others then
312: edw_Log.put_line('error happened when truncate '||g_vbh_temp_table_name||' '||sqlcode||':'||sqlerrm);
313: raise;
314: end clean_up_temp_table ;
315:
316:

Line 326: edw_log.put_line('Error happened when truncating '||g_dimension_name||' '||sqlcode||':'||sqlerrm);

322: execute immediate l_truncate_sql;
323: VBHDEBUG('finished truncating '||g_dimension_name);
324: exception
325: when others then
326: edw_log.put_line('Error happened when truncating '||g_dimension_name||' '||sqlcode||':'||sqlerrm);
327: raise;
328: end clean_up_dimension_table ;
329:
330: procedure clean_up_global_temp_table as

Line 340: edw_log.put_line('Error happened when truncating table '||g_global_temp_table||' '||sqlcode||':'||sqlerrm);

336: VBHDEBUG('finished truncating '||g_global_temp_table);
337: commit;
338: exception
339: when others then
340: edw_log.put_line('Error happened when truncating table '||g_global_temp_table||' '||sqlcode||':'||sqlerrm);
341: raise;
342: end clean_up_global_temp_table ;
343:
344: -- simple timing tools, setTimer and logTime.

Line 373: VBHDEBUG('Process Time for '|| p_process || ' : ' || edw_log.duration(l_duration));

369: IS
370: l_duration number := null;
371: BEGIN
372: l_duration := sysdate - p_log_timstamp;
373: VBHDEBUG('Process Time for '|| p_process || ' : ' || edw_log.duration(l_duration));
374: VBHDEBUG(' ');
375: END;
376:
377: procedure insert_default_value(

Line 450: edw_log.put_line('Error:'||

446: l_rows_inserted :=DBMS_SQL.EXECUTE(l_cursor_id);
447: DBMS_SQL.close_cursor(l_cursor_id);
448: exception
449: when others then
450: edw_log.put_line('Error:'||
451: 'When inserting the default value into '|| g_dimension_name
452: ||' '||sqlcode ||' : '||sqlerrm);
453: raise;
454: end insert_default_value;

Line 526: edw_log.put_line('Error:'|| 'When inserting non-active default value into '|| g_dimension_name ||' '||sqlcode ||' : '||sqlerrm);

522: l_rows_inserted := sql%rowcount;
523: VBHDEBUG('Number of non-active rows inserted : ' || l_rows_inserted);
524: exception
525: when others then
526: edw_log.put_line('Error:'|| 'When inserting non-active default value into '|| g_dimension_name ||' '||sqlcode ||' : '||sqlerrm);
527: logTime('Error of non-active default values insertions to dimension star table', l_log_timestamp);
528: raise;
529:
530: end insert_non_active_values;

Line 608: edw_log.put_line('Error:'|| 'When inserting active default value into '|| g_dimension_name ||' '||sqlcode ||' : '||sqlerrm);

604: l_defaultrows_inserted:= sql%rowcount;
605: VBHDEBUG('Default rows inserted: ' || l_defaultrows_inserted);
606: exception
607: when others then
608: edw_log.put_line('Error:'|| 'When inserting active default value into '|| g_dimension_name ||' '||sqlcode ||' : '||sqlerrm);
609: logTime('Error of active default values insertions to dimension star table', l_log_timestamp);
610: raise;
611: end insert_default_values;
612:

Line 809: edw_log.put_line(

805: WHERE l1_pk= :s' using p_pk;
806: FETCH cur_check_error into l_root_name;
807:
808: if cur_check_error%NOTFOUND then
809: edw_log.put_line(
810: 'Warning : '||'Can not find '|| p_pk||' in dimension table.');
811: g_completion_status:=1;
812: logCumulatedTime( l_error_timestamp, g_err_cum_timestamp);
813: return;

Line 826: edw_log.put_line(

822: exception
823: when l_dimond_error then
824: g_diamond_output:=g_diamond_output+1;
825: if g_diamond_output < g_err_smp_size then
826: edw_log.put_line(
827: 'Warning : Dimond shape or duplicate rows.
828: '||p_pk||' rolls up to '
829: ||l_root_name||' twice in hierarchy '||p_hierachy_no||'. ');
830: end if;

Line 837: edw_log.put_line('Warning : Root setup error for '

833:
834: when l_root_setup_error then
835: g_rootsetup_error:=g_rootsetup_error+1;
836: if g_rootsetup_error< g_err_smp_size then
837: edw_log.put_line('Warning : Root setup error for '
838: ||p_pk||':'||'.
839: '||p_pk||' rolls up to '
840: ||l_root_name||' and '||p_level15||' in hierarchy '
841: ||p_hierachy_no||'.

Line 853: edw_log.put_line( 'Error: When updating the dimension table. '

849: END IF; --for p_hierachy_no <= 4 THEN
850:
851: EXCEPTION
852: WHEN OTHERS THEN
853: edw_log.put_line( 'Error: When updating the dimension table. '
854: ||sqlcode||' : '||sqlerrm);
855: raise;
856: END update_dimension;
857:

Line 892: edw_log.put_line( 'Error : When checking stand alone node. '||sqlcode||' : '||sqlerrm);

888: end loop;
889: DBMS_SQL.close_cursor(l_cursor_id);
890: exception
891: when others then
892: edw_log.put_line( 'Error : When checking stand alone node. '||sqlcode||' : '||sqlerrm);
893: raise;
894: end;
895:
896:

Line 929: edw_log.put_line( 'Error : When checking stand alone node. '||sqlcode||' : '||sqlerrm);

925: g_completion_status:=1;
926: end if;
927: exception
928: when others then
929: edw_log.put_line( 'Error : When checking stand alone node. '||sqlcode||' : '||sqlerrm);
930: raise;
931: end;
932:
933: PROCEDURE CLOSE_UPDATE( p_CursorID IN OUT NOCOPY INTEGER) IS

Line 1033: edw_log.put_line( 'Error : When looking up root set_of_books_id. '

1029: return l_root_value;
1030:
1031: exception
1032: when others then
1033: edw_log.put_line( 'Error : When looking up root set_of_books_id. '
1034: ||sqlcode||' : '||sqlerrm);
1035: raise;
1036: END GET_VBH_ROOT;
1037:

Line 1393: edw_log.put_line( 'Not Classfied Type lookup: ' || g_not_classified_type);

1389:
1390: -- FND MESSAGE LOOKUP AREA
1391: FND_MESSAGE.SET_NAME('BIS', 'EDW_DIMENSION_LEVEL_TYPE');
1392: g_not_classified_type := FND_MESSAGE.GET;
1393: edw_log.put_line( 'Not Classfied Type lookup: ' || g_not_classified_type);
1394:
1395: FND_MESSAGE.SET_NAME('BIS', 'EDW_UNASSIGNED');
1396: g_na_edw := FND_MESSAGE.GET;
1397: edw_log.put_line( 'NA_EDW lookup: ' || g_na_edw);

Line 1397: edw_log.put_line( 'NA_EDW lookup: ' || g_na_edw);

1393: edw_log.put_line( 'Not Classfied Type lookup: ' || g_not_classified_type);
1394:
1395: FND_MESSAGE.SET_NAME('BIS', 'EDW_UNASSIGNED');
1396: g_na_edw := FND_MESSAGE.GET;
1397: edw_log.put_line( 'NA_EDW lookup: ' || g_na_edw);
1398:
1399:
1400: FND_MESSAGE.SET_NAME('BIS', 'EDW_INVALID');
1401: g_na_err := FND_MESSAGE.GET;

Line 1402: edw_log.put_line( 'NA_ERR lookup: ' || g_na_err);

1398:
1399:
1400: FND_MESSAGE.SET_NAME('BIS', 'EDW_INVALID');
1401: g_na_err := FND_MESSAGE.GET;
1402: edw_log.put_line( 'NA_ERR lookup: ' || g_na_err);
1403:
1404:
1405: FND_MESSAGE.SET_NAME('BIS', 'EDW_ALL');
1406: g_all := FND_MESSAGE.GET;

Line 1407: edw_log.put_line( 'EDW_ALL lookup: ' || g_all);

1403:
1404:
1405: FND_MESSAGE.SET_NAME('BIS', 'EDW_ALL');
1406: g_all := FND_MESSAGE.GET;
1407: edw_log.put_line( 'EDW_ALL lookup: ' || g_all);
1408:
1409:
1410: select edw_load_s.nextval
1411: into l_progress_seq_id

Line 1415: edw_log.put_line( 'VBH Loading program for '|| p_dimension_name||' '||

1411: into l_progress_seq_id
1412: from dual;
1413:
1414:
1415: edw_log.put_line( 'VBH Loading program for '|| p_dimension_name||' '||
1416: to_char(sysdate));
1417:
1418: edw_log.put_line('Dimension number '|| p_dimension_no);
1419: edw_log.put_line('Dimension physical name : '|| g_dimension_name);

Line 1418: edw_log.put_line('Dimension number '|| p_dimension_no);

1414:
1415: edw_log.put_line( 'VBH Loading program for '|| p_dimension_name||' '||
1416: to_char(sysdate));
1417:
1418: edw_log.put_line('Dimension number '|| p_dimension_no);
1419: edw_log.put_line('Dimension physical name : '|| g_dimension_name);
1420: edw_log.put_line('Error Sample Display Size : '|| g_err_smp_size);
1421:
1422: edw_log.put_line('Collecting data...');

Line 1419: edw_log.put_line('Dimension physical name : '|| g_dimension_name);

1415: edw_log.put_line( 'VBH Loading program for '|| p_dimension_name||' '||
1416: to_char(sysdate));
1417:
1418: edw_log.put_line('Dimension number '|| p_dimension_no);
1419: edw_log.put_line('Dimension physical name : '|| g_dimension_name);
1420: edw_log.put_line('Error Sample Display Size : '|| g_err_smp_size);
1421:
1422: edw_log.put_line('Collecting data...');
1423: if p_dimension_no<1 or p_dimension_no>10 then

Line 1420: edw_log.put_line('Error Sample Display Size : '|| g_err_smp_size);

1416: to_char(sysdate));
1417:
1418: edw_log.put_line('Dimension number '|| p_dimension_no);
1419: edw_log.put_line('Dimension physical name : '|| g_dimension_name);
1420: edw_log.put_line('Error Sample Display Size : '|| g_err_smp_size);
1421:
1422: edw_log.put_line('Collecting data...');
1423: if p_dimension_no<1 or p_dimension_no>10 then
1424: edw_log.put_line('Error : Invalid dimension number '

Line 1422: edw_log.put_line('Collecting data...');

1418: edw_log.put_line('Dimension number '|| p_dimension_no);
1419: edw_log.put_line('Dimension physical name : '|| g_dimension_name);
1420: edw_log.put_line('Error Sample Display Size : '|| g_err_smp_size);
1421:
1422: edw_log.put_line('Collecting data...');
1423: if p_dimension_no<1 or p_dimension_no>10 then
1424: edw_log.put_line('Error : Invalid dimension number '
1425: ||p_dimension_no);
1426: g_completion_status:=2;

Line 1424: edw_log.put_line('Error : Invalid dimension number '

1420: edw_log.put_line('Error Sample Display Size : '|| g_err_smp_size);
1421:
1422: edw_log.put_line('Collecting data...');
1423: if p_dimension_no<1 or p_dimension_no>10 then
1424: edw_log.put_line('Error : Invalid dimension number '
1425: ||p_dimension_no);
1426: g_completion_status:=2;
1427: l_exe_status:=false;
1428: l_program_status:=

Line 1584: edw_log.put_line('Warning : More than 4 roots.');

1580: CLOSE_UPDATE(l_CursorID);
1581:
1582: else
1583: if l_hierachy_no >4 then
1584: edw_log.put_line('Warning : More than 4 roots.');
1585: end if;
1586: end if;
1587:
1588: edw_owb_collection_util.INSERT_INTO_LOAD_PROGRESS(

Line 1605: edw_log.put_line('Finished collecting data.');

1601: END LOOP;--for the for loop of root value
1602: END LOOP;
1603: CLOSE cur_vbh_roots;
1604:
1605: edw_log.put_line('Finished collecting data.');
1606:
1607: setTimer(l_log_timestamp);
1608: check_stand_alone_value;
1609: logTime('checking stand along values', l_log_timestamp);

Line 1615: edw_log.put_line('Normal complete.');

1611:
1612: if (g_completion_status=0) then
1613: l_program_status:=
1614: fnd_concurrent.set_completion_status('NORMAL', 'NORMAL COMPLETION');
1615: edw_log.put_line('Normal complete.');
1616: setTimer(l_log_timestamp);
1617: clean_up_temp_table;
1618: logTime('cleaning up vbh temp table', l_log_timestamp);
1619:

Line 1643: edw_log.put_line('Complete with warning.');

1639:
1640: elsif (g_completion_status=1) then
1641: l_program_status:=
1642: fnd_concurrent.set_completion_status('WARNING',NULL);
1643: edw_log.put_line('Complete with warning.');
1644: setTimer(l_log_timestamp);
1645: clean_up_temp_table;
1646: logTime('cleaning up vbh temp table', l_log_timestamp);
1647:

Line 1667: edw_log.put_line('Error.');

1663:
1664: elsif (g_completion_status=2) then
1665: l_program_status:=
1666: fnd_concurrent.set_completion_status('ERROR',NULL);
1667: edw_log.put_line('Error.');
1668: l_status:=edw_owb_collection_util.write_to_collection_log(
1669: g_dimension_name,
1670: l_element_id,
1671: 'DIMENSION',

Line 1682: edw_log.put_line('Total number of rows updated: '||g_rows_updated );

1678: 'ERROR',l_progress_seq_id);
1679:
1680: end if;
1681: COMMIT;
1682: edw_log.put_line('Total number of rows updated: '||g_rows_updated );
1683: edw_log.put_line('Total number of diamond hits: '||g_diamond_output);
1684: edw_log.put_line('Total number of standalone nodes: '||g_standalone);
1685: edw_log.put_line('Total number of root setup errors: '||g_rootsetup_error);
1686: edw_log.put_line('Total time spent on error handling : '|| edw_log.duration(g_err_cum_timestamp));

Line 1683: edw_log.put_line('Total number of diamond hits: '||g_diamond_output);

1679:
1680: end if;
1681: COMMIT;
1682: edw_log.put_line('Total number of rows updated: '||g_rows_updated );
1683: edw_log.put_line('Total number of diamond hits: '||g_diamond_output);
1684: edw_log.put_line('Total number of standalone nodes: '||g_standalone);
1685: edw_log.put_line('Total number of root setup errors: '||g_rootsetup_error);
1686: edw_log.put_line('Total time spent on error handling : '|| edw_log.duration(g_err_cum_timestamp));
1687: edw_log.put_line('finished loading VBH');

Line 1684: edw_log.put_line('Total number of standalone nodes: '||g_standalone);

1680: end if;
1681: COMMIT;
1682: edw_log.put_line('Total number of rows updated: '||g_rows_updated );
1683: edw_log.put_line('Total number of diamond hits: '||g_diamond_output);
1684: edw_log.put_line('Total number of standalone nodes: '||g_standalone);
1685: edw_log.put_line('Total number of root setup errors: '||g_rootsetup_error);
1686: edw_log.put_line('Total time spent on error handling : '|| edw_log.duration(g_err_cum_timestamp));
1687: edw_log.put_line('finished loading VBH');
1688: edw_log.put_line('current time :'||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));

Line 1685: edw_log.put_line('Total number of root setup errors: '||g_rootsetup_error);

1681: COMMIT;
1682: edw_log.put_line('Total number of rows updated: '||g_rows_updated );
1683: edw_log.put_line('Total number of diamond hits: '||g_diamond_output);
1684: edw_log.put_line('Total number of standalone nodes: '||g_standalone);
1685: edw_log.put_line('Total number of root setup errors: '||g_rootsetup_error);
1686: edw_log.put_line('Total time spent on error handling : '|| edw_log.duration(g_err_cum_timestamp));
1687: edw_log.put_line('finished loading VBH');
1688: edw_log.put_line('current time :'||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));
1689: logTime('the whole VBH Loading', l_start_date);

Line 1686: edw_log.put_line('Total time spent on error handling : '|| edw_log.duration(g_err_cum_timestamp));

1682: edw_log.put_line('Total number of rows updated: '||g_rows_updated );
1683: edw_log.put_line('Total number of diamond hits: '||g_diamond_output);
1684: edw_log.put_line('Total number of standalone nodes: '||g_standalone);
1685: edw_log.put_line('Total number of root setup errors: '||g_rootsetup_error);
1686: edw_log.put_line('Total time spent on error handling : '|| edw_log.duration(g_err_cum_timestamp));
1687: edw_log.put_line('finished loading VBH');
1688: edw_log.put_line('current time :'||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));
1689: logTime('the whole VBH Loading', l_start_date);
1690:

Line 1687: edw_log.put_line('finished loading VBH');

1683: edw_log.put_line('Total number of diamond hits: '||g_diamond_output);
1684: edw_log.put_line('Total number of standalone nodes: '||g_standalone);
1685: edw_log.put_line('Total number of root setup errors: '||g_rootsetup_error);
1686: edw_log.put_line('Total time spent on error handling : '|| edw_log.duration(g_err_cum_timestamp));
1687: edw_log.put_line('finished loading VBH');
1688: edw_log.put_line('current time :'||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));
1689: logTime('the whole VBH Loading', l_start_date);
1690:
1691: --added for bug 4124723

Line 1688: edw_log.put_line('current time :'||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));

1684: edw_log.put_line('Total number of standalone nodes: '||g_standalone);
1685: edw_log.put_line('Total number of root setup errors: '||g_rootsetup_error);
1686: edw_log.put_line('Total time spent on error handling : '|| edw_log.duration(g_err_cum_timestamp));
1687: edw_log.put_line('finished loading VBH');
1688: edw_log.put_line('current time :'||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));
1689: logTime('the whole VBH Loading', l_start_date);
1690:
1691: --added for bug 4124723
1692: -- Call Function to create level MV's

Line 1714: edw_log.put_line( 'Error : '||sqlcode||' : '||sqlerrm);

1710: 0,null,null,null,
1711: 'Error : '||sqlcode||' : '||sqlerrm ,
1712: 'ERROR',l_progress_seq_id);
1713:
1714: edw_log.put_line( 'Error : '||sqlcode||' : '||sqlerrm);
1715: l_program_status:=
1716: fnd_concurrent.set_completion_status('ERROR',NULL);
1717: rollback;
1718: END; --end collection program

Line 1774: edw_log.put_line( 'Database Version:= '||db_versn);

1770:
1771: --check database version. it should be 9i or above
1772: --get the version
1773: select version into db_versn from v$instance;
1774: edw_log.put_line( 'Database Version:= '||db_versn);
1775: select replace(substr(version,1,instr(version,'.',1,2)-1),'.') into db_versn from v$instance;
1776:
1777: l_stmt:= 'select tablespace_name from all_tables where table_name='''||g_dimension_name||''' and owner='''||get_bis_schema_name||'''';
1778: execute immediate l_stmt into l_tspace_name;

Line 1791: edw_log.put_line( 'Checking if MV ' || l_mview_name||' Exists in the Database');

1787: l_lvl_num := l_hierarchy_cnt*100+l_level_counter ;
1788:
1789: l_mview_name:= 'EDW_GLACT'||p_dim_no|| '_H'||l_lvl_num||'_MV';
1790:
1791: edw_log.put_line( 'Checking if MV ' || l_mview_name||' Exists in the Database');
1792:
1793: --check if the MV exists
1794: OPEN c_mv_exists(l_mview_Name,l_schema_name);
1795: fetch c_mv_exists into l_tmp_name;

Line 1800: edw_log.put_line( 'Refreshing MV'||l_mview_name);

1796: CLOSE c_mv_exists;
1797:
1798: --- if the mv exists refresh all the levels mv
1799: if(l_tmp_name is not null) then
1800: edw_log.put_line( 'Refreshing MV'||l_mview_name);
1801: dbms_mview.refresh (l_mview_name,'C');
1802: else -- if mv does not exist creat MV's
1803: l_stmt_mvcrt := 'CREATE MATERIALIZED VIEW '|| l_mview_name||' TABLESPACE '||l_tspace_name || ' ENABLE QUERY REWRITE AS SELECT DISTINCT '|| 'H'||l_lvl_num||'_NAME'||' FROM '||g_dimension_name;
1804: edw_log.put_line(l_stmt_mvcrt);

Line 1804: edw_log.put_line(l_stmt_mvcrt);

1800: edw_log.put_line( 'Refreshing MV'||l_mview_name);
1801: dbms_mview.refresh (l_mview_name,'C');
1802: else -- if mv does not exist creat MV's
1803: l_stmt_mvcrt := 'CREATE MATERIALIZED VIEW '|| l_mview_name||' TABLESPACE '||l_tspace_name || ' ENABLE QUERY REWRITE AS SELECT DISTINCT '|| 'H'||l_lvl_num||'_NAME'||' FROM '||g_dimension_name;
1804: edw_log.put_line(l_stmt_mvcrt);
1805: execute immediate l_stmt_mvcrt;
1806: end if;
1807:
1808: --call gather stats for the MV

Line 1816: edw_log.put_line( 'Database Version is lower than 9i dimension levls MVs won''t be created '||db_versn);

1812: END LOOP;
1813:
1814: END LOOP;
1815: else
1816: edw_log.put_line( 'Database Version is lower than 9i dimension levls MVs won''t be created '||db_versn);
1817: end if;
1818:
1819: edw_log.put_line( 'Create_dim_levelS_Mv completed successfully');
1820:

Line 1819: edw_log.put_line( 'Create_dim_levelS_Mv completed successfully');

1815: else
1816: edw_log.put_line( 'Database Version is lower than 9i dimension levls MVs won''t be created '||db_versn);
1817: end if;
1818:
1819: edw_log.put_line( 'Create_dim_levelS_Mv completed successfully');
1820:
1821: EXCEPTION
1822: WHEN OTHERS THEN
1823: edw_log.put_line( 'Error : '||sqlcode||' : '||sqlerrm);

Line 1823: edw_log.put_line( 'Error : '||sqlcode||' : '||sqlerrm);

1819: edw_log.put_line( 'Create_dim_levelS_Mv completed successfully');
1820:
1821: EXCEPTION
1822: WHEN OTHERS THEN
1823: edw_log.put_line( 'Error : '||sqlcode||' : '||sqlerrm);
1824: edw_log.put_line( 'Warning MV Creation for Dimension levels Failed! Ignorable Error');
1825: END create_dim_levels_mv;
1826:
1827: END EDW_GL_ACCT_M_T;

Line 1824: edw_log.put_line( 'Warning MV Creation for Dimension levels Failed! Ignorable Error');

1820:
1821: EXCEPTION
1822: WHEN OTHERS THEN
1823: edw_log.put_line( 'Error : '||sqlcode||' : '||sqlerrm);
1824: edw_log.put_line( 'Warning MV Creation for Dimension levels Failed! Ignorable Error');
1825: END create_dim_levels_mv;
1826:
1827: END EDW_GL_ACCT_M_T;