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

Line 116: edw_log.g_debug := TRUE;

112: dbms_session.set_sql_trace(FALSE);
113: END IF; */ --Commented for bug 3304365
114:
115: IF (fnd_profile.value('EDW_DEBUG') = 'Y') THEN
116: edw_log.g_debug := TRUE;
117: END IF;
118:
119: l_dir:=fnd_profile.value('EDW_LOGFILE_DIR');
120:

Line 119: l_dir:=fnd_profile.value('EDW_LOGFILE_DIR');

115: IF (fnd_profile.value('EDW_DEBUG') = 'Y') THEN
116: edw_log.g_debug := TRUE;
117: END IF;
118:
119: l_dir:=fnd_profile.value('EDW_LOGFILE_DIR');
120:
121: if l_dir is null then
122: l_dir:='/sqlcom/log';
123: end if;

Line 126: edw_log.put_names(p_object_name||'.log',p_object_name||'.out',l_dir);

122: l_dir:='/sqlcom/log';
123: end if;
124:
125: if g_debug_flag = 'Y' then
126: edw_log.put_names(p_object_name||'.log',p_object_name||'.out',l_dir);
127: end if;
128:
129: EXCEPTION
130: WHEN OTHERS THEN

Line 239: edw_log.put_line('');

235:
236: EXCEPTION
237: WHEN OTHERS THEN
238: if g_debug_flag = 'Y' then
239: edw_log.put_line('');
240: edw_log.put_line('Error in '||g_processName);
241: edw_log.put_line('pBusAreaNamein = '||pBusAreaNamein);
242: edw_log.put_line('pTableName = '||pTableNamein);
243: edw_log.put_line('pColumnNameIn ='||pColumnNameIn);

Line 240: edw_log.put_line('Error in '||g_processName);

236: EXCEPTION
237: WHEN OTHERS THEN
238: if g_debug_flag = 'Y' then
239: edw_log.put_line('');
240: edw_log.put_line('Error in '||g_processName);
241: edw_log.put_line('pBusAreaNamein = '||pBusAreaNamein);
242: edw_log.put_line('pTableName = '||pTableNamein);
243: edw_log.put_line('pColumnNameIn ='||pColumnNameIn);
244: edw_log.put_line('pItemNameIn ='||pItemNameIn);

Line 241: edw_log.put_line('pBusAreaNamein = '||pBusAreaNamein);

237: WHEN OTHERS THEN
238: if g_debug_flag = 'Y' then
239: edw_log.put_line('');
240: edw_log.put_line('Error in '||g_processName);
241: edw_log.put_line('pBusAreaNamein = '||pBusAreaNamein);
242: edw_log.put_line('pTableName = '||pTableNamein);
243: edw_log.put_line('pColumnNameIn ='||pColumnNameIn);
244: edw_log.put_line('pItemNameIn ='||pItemNameIn);
245: end if;

Line 242: edw_log.put_line('pTableName = '||pTableNamein);

238: if g_debug_flag = 'Y' then
239: edw_log.put_line('');
240: edw_log.put_line('Error in '||g_processName);
241: edw_log.put_line('pBusAreaNamein = '||pBusAreaNamein);
242: edw_log.put_line('pTableName = '||pTableNamein);
243: edw_log.put_line('pColumnNameIn ='||pColumnNameIn);
244: edw_log.put_line('pItemNameIn ='||pItemNameIn);
245: end if;
246:

Line 243: edw_log.put_line('pColumnNameIn ='||pColumnNameIn);

239: edw_log.put_line('');
240: edw_log.put_line('Error in '||g_processName);
241: edw_log.put_line('pBusAreaNamein = '||pBusAreaNamein);
242: edw_log.put_line('pTableName = '||pTableNamein);
243: edw_log.put_line('pColumnNameIn ='||pColumnNameIn);
244: edw_log.put_line('pItemNameIn ='||pItemNameIn);
245: end if;
246:
247: g_errbuf:=sqlerrm;

Line 244: edw_log.put_line('pItemNameIn ='||pItemNameIn);

240: edw_log.put_line('Error in '||g_processName);
241: edw_log.put_line('pBusAreaNamein = '||pBusAreaNamein);
242: edw_log.put_line('pTableName = '||pTableNamein);
243: edw_log.put_line('pColumnNameIn ='||pColumnNameIn);
244: edw_log.put_line('pItemNameIn ='||pItemNameIn);
245: end if;
246:
247: g_errbuf:=sqlerrm;
248: g_retcode:=sqlcode;

Line 281: edw_log.debug_line('Procedure hideFolderItems');

277:
278: END IF;
279:
280: if g_debug_flag = 'Y' then
281: edw_log.debug_line('Procedure hideFolderItems');
282: edw_log.debug_line('Going to execute statement:');
283: edw_log.debug_line(l_stmt);
284: end if;
285:

Line 282: edw_log.debug_line('Going to execute statement:');

278: END IF;
279:
280: if g_debug_flag = 'Y' then
281: edw_log.debug_line('Procedure hideFolderItems');
282: edw_log.debug_line('Going to execute statement:');
283: edw_log.debug_line(l_stmt);
284: end if;
285:
286:

Line 283: edw_log.debug_line(l_stmt);

279:
280: if g_debug_flag = 'Y' then
281: edw_log.debug_line('Procedure hideFolderItems');
282: edw_log.debug_line('Going to execute statement:');
283: edw_log.debug_line(l_stmt);
284: end if;
285:
286:
287: EXCEPTION

Line 330: edw_log.debug_line('Procedure hideFolderItems');

326: 'AND exp.it_obj_id = obj.obj_id '||
327: 'AND exp.it_ext_column LIKE '''||pColumn||'''';
328:
329: if g_debug_flag = 'Y' then
330: edw_log.debug_line('Procedure hideFolderItems');
331: edw_log.debug_line('Going to execute statement:');
332: edw_log.debug_line(l_stmt);
333: end if;
334:

Line 331: edw_log.debug_line('Going to execute statement:');

327: 'AND exp.it_ext_column LIKE '''||pColumn||'''';
328:
329: if g_debug_flag = 'Y' then
330: edw_log.debug_line('Procedure hideFolderItems');
331: edw_log.debug_line('Going to execute statement:');
332: edw_log.debug_line(l_stmt);
333: end if;
334:
335: -- EXECUTE IMMEDIATE l_stmt INTO l_itemID ;

Line 332: edw_log.debug_line(l_stmt);

328:
329: if g_debug_flag = 'Y' then
330: edw_log.debug_line('Procedure hideFolderItems');
331: edw_log.debug_line('Going to execute statement:');
332: edw_log.debug_line(l_stmt);
333: end if;
334:
335: -- EXECUTE IMMEDIATE l_stmt INTO l_itemID ;
336:

Line 365: edw_log.put_line('');

361:
362: EXCEPTION
363: WHEN OTHERS THEN
364: if g_debug_flag = 'Y' then
365: edw_log.put_line('');
366: edw_log.put_line('Error in hideFolderItems');
367: edw_log.put_line('pBusAreaID = '||pBusAreaID);
368: edw_log.put_line('pTableName = '||pTableName);
369: edw_log.put_line('pViewName = '||pViewName);

Line 366: edw_log.put_line('Error in hideFolderItems');

362: EXCEPTION
363: WHEN OTHERS THEN
364: if g_debug_flag = 'Y' then
365: edw_log.put_line('');
366: edw_log.put_line('Error in hideFolderItems');
367: edw_log.put_line('pBusAreaID = '||pBusAreaID);
368: edw_log.put_line('pTableName = '||pTableName);
369: edw_log.put_line('pViewName = '||pViewName);
370: edw_log.put_line('pColumn LIKE '||pColumn);

Line 367: edw_log.put_line('pBusAreaID = '||pBusAreaID);

363: WHEN OTHERS THEN
364: if g_debug_flag = 'Y' then
365: edw_log.put_line('');
366: edw_log.put_line('Error in hideFolderItems');
367: edw_log.put_line('pBusAreaID = '||pBusAreaID);
368: edw_log.put_line('pTableName = '||pTableName);
369: edw_log.put_line('pViewName = '||pViewName);
370: edw_log.put_line('pColumn LIKE '||pColumn);
371: edw_log.put_line('l_stmt '||l_stmt);

Line 368: edw_log.put_line('pTableName = '||pTableName);

364: if g_debug_flag = 'Y' then
365: edw_log.put_line('');
366: edw_log.put_line('Error in hideFolderItems');
367: edw_log.put_line('pBusAreaID = '||pBusAreaID);
368: edw_log.put_line('pTableName = '||pTableName);
369: edw_log.put_line('pViewName = '||pViewName);
370: edw_log.put_line('pColumn LIKE '||pColumn);
371: edw_log.put_line('l_stmt '||l_stmt);
372: end if ;

Line 369: edw_log.put_line('pViewName = '||pViewName);

365: edw_log.put_line('');
366: edw_log.put_line('Error in hideFolderItems');
367: edw_log.put_line('pBusAreaID = '||pBusAreaID);
368: edw_log.put_line('pTableName = '||pTableName);
369: edw_log.put_line('pViewName = '||pViewName);
370: edw_log.put_line('pColumn LIKE '||pColumn);
371: edw_log.put_line('l_stmt '||l_stmt);
372: end if ;
373:

Line 370: edw_log.put_line('pColumn LIKE '||pColumn);

366: edw_log.put_line('Error in hideFolderItems');
367: edw_log.put_line('pBusAreaID = '||pBusAreaID);
368: edw_log.put_line('pTableName = '||pTableName);
369: edw_log.put_line('pViewName = '||pViewName);
370: edw_log.put_line('pColumn LIKE '||pColumn);
371: edw_log.put_line('l_stmt '||l_stmt);
372: end if ;
373:
374: g_errbuf:=sqlerrm;

Line 371: edw_log.put_line('l_stmt '||l_stmt);

367: edw_log.put_line('pBusAreaID = '||pBusAreaID);
368: edw_log.put_line('pTableName = '||pTableName);
369: edw_log.put_line('pViewName = '||pViewName);
370: edw_log.put_line('pColumn LIKE '||pColumn);
371: edw_log.put_line('l_stmt '||l_stmt);
372: end if ;
373:
374: g_errbuf:=sqlerrm;
375: g_retcode:=sqlcode;

Line 414: edw_log.debug_line('Procedure initBusAreas');

410: 'FROM '||g_EulOwner||'.eul4_bas ba '||
411: 'WHERE ba.ba_name = '''||pBusAreaName||'''';
412:
413: if g_debug_flag = 'Y' then
414: edw_log.debug_line('Procedure initBusAreas');
415: edw_log.debug_line('Going to execute statement:');
416: edw_log.debug_line(l_stmt);
417: end if;
418:

Line 415: edw_log.debug_line('Going to execute statement:');

411: 'WHERE ba.ba_name = '''||pBusAreaName||'''';
412:
413: if g_debug_flag = 'Y' then
414: edw_log.debug_line('Procedure initBusAreas');
415: edw_log.debug_line('Going to execute statement:');
416: edw_log.debug_line(l_stmt);
417: end if;
418:
419:

Line 416: edw_log.debug_line(l_stmt);

412:
413: if g_debug_flag = 'Y' then
414: edw_log.debug_line('Procedure initBusAreas');
415: edw_log.debug_line('Going to execute statement:');
416: edw_log.debug_line(l_stmt);
417: end if;
418:
419:
420: EXECUTE IMMEDIATE l_stmt INTO lEulBA_ID, lEulBA_Name, lEulBA_DEVELOPER_KEY;

Line 477: edw_log.debug_line('Procedure initColumns');

473: 'ORDER BY folder_items.IT_EXT_COLUMN, '||
474: ' folder_items.exp_id';
475:
476: if g_debug_flag = 'Y' then
477: edw_log.debug_line('Procedure initColumns');
478: edw_log.debug_line('Going to execute statement:');
479: edw_log.debug_line(l_stmt);
480: end if;
481:

Line 478: edw_log.debug_line('Going to execute statement:');

474: ' folder_items.exp_id';
475:
476: if g_debug_flag = 'Y' then
477: edw_log.debug_line('Procedure initColumns');
478: edw_log.debug_line('Going to execute statement:');
479: edw_log.debug_line(l_stmt);
480: end if;
481:
482: OPEN eulCol_cv FOR l_stmt;

Line 479: edw_log.debug_line(l_stmt);

475:
476: if g_debug_flag = 'Y' then
477: edw_log.debug_line('Procedure initColumns');
478: edw_log.debug_line('Going to execute statement:');
479: edw_log.debug_line(l_stmt);
480: end if;
481:
482: OPEN eulCol_cv FOR l_stmt;
483: LOOP

Line 504: edw_log.put_line('');

500:
501: EXCEPTION
502: WHEN OTHERS THEN
503: if g_debug_flag = 'Y' then
504: edw_log.put_line('');
505: edw_log.put_line('Error in initColumns');
506: edw_log.put_line('pBusAreaName = '||pBusAreaName);
507: edw_log.put_line('pTableName = '||pTableName);
508: edw_log.put_line('l_stmt '||l_stmt);

Line 505: edw_log.put_line('Error in initColumns');

501: EXCEPTION
502: WHEN OTHERS THEN
503: if g_debug_flag = 'Y' then
504: edw_log.put_line('');
505: edw_log.put_line('Error in initColumns');
506: edw_log.put_line('pBusAreaName = '||pBusAreaName);
507: edw_log.put_line('pTableName = '||pTableName);
508: edw_log.put_line('l_stmt '||l_stmt);
509: end if;

Line 506: edw_log.put_line('pBusAreaName = '||pBusAreaName);

502: WHEN OTHERS THEN
503: if g_debug_flag = 'Y' then
504: edw_log.put_line('');
505: edw_log.put_line('Error in initColumns');
506: edw_log.put_line('pBusAreaName = '||pBusAreaName);
507: edw_log.put_line('pTableName = '||pTableName);
508: edw_log.put_line('l_stmt '||l_stmt);
509: end if;
510:

Line 507: edw_log.put_line('pTableName = '||pTableName);

503: if g_debug_flag = 'Y' then
504: edw_log.put_line('');
505: edw_log.put_line('Error in initColumns');
506: edw_log.put_line('pBusAreaName = '||pBusAreaName);
507: edw_log.put_line('pTableName = '||pTableName);
508: edw_log.put_line('l_stmt '||l_stmt);
509: end if;
510:
511: g_errbuf:=sqlerrm;

Line 508: edw_log.put_line('l_stmt '||l_stmt);

504: edw_log.put_line('');
505: edw_log.put_line('Error in initColumns');
506: edw_log.put_line('pBusAreaName = '||pBusAreaName);
507: edw_log.put_line('pTableName = '||pTableName);
508: edw_log.put_line('l_stmt '||l_stmt);
509: end if;
510:
511: g_errbuf:=sqlerrm;
512: g_retcode:=sqlcode;

Line 573: edw_log.debug_line('Procedure initTables');

569: ' folders.OBJ_ID ';
570:
571:
572: if g_debug_flag = 'Y' then
573: edw_log.debug_line('Procedure initTables');
574: edw_log.debug_line('Going to execute statement:');
575: edw_log.debug_line(l_stmt);
576: end if;
577:

Line 574: edw_log.debug_line('Going to execute statement:');

570:
571:
572: if g_debug_flag = 'Y' then
573: edw_log.debug_line('Procedure initTables');
574: edw_log.debug_line('Going to execute statement:');
575: edw_log.debug_line(l_stmt);
576: end if;
577:
578:

Line 575: edw_log.debug_line(l_stmt);

571:
572: if g_debug_flag = 'Y' then
573: edw_log.debug_line('Procedure initTables');
574: edw_log.debug_line('Going to execute statement:');
575: edw_log.debug_line(l_stmt);
576: end if;
577:
578:
579: -- eulTablesTab.delete;

Line 599: edw_log.put_line('');

595:
596: EXCEPTION
597: WHEN OTHERS THEN
598: if g_debug_flag = 'Y' then
599: edw_log.put_line('');
600: edw_log.put_line('Error in initTables');
601: edw_log.put_line('pBusAreaName = '||pBusAreaName);
602: edw_log.put_line('l_stmt '||l_stmt);
603: end if;

Line 600: edw_log.put_line('Error in initTables');

596: EXCEPTION
597: WHEN OTHERS THEN
598: if g_debug_flag = 'Y' then
599: edw_log.put_line('');
600: edw_log.put_line('Error in initTables');
601: edw_log.put_line('pBusAreaName = '||pBusAreaName);
602: edw_log.put_line('l_stmt '||l_stmt);
603: end if;
604:

Line 601: edw_log.put_line('pBusAreaName = '||pBusAreaName);

597: WHEN OTHERS THEN
598: if g_debug_flag = 'Y' then
599: edw_log.put_line('');
600: edw_log.put_line('Error in initTables');
601: edw_log.put_line('pBusAreaName = '||pBusAreaName);
602: edw_log.put_line('l_stmt '||l_stmt);
603: end if;
604:
605: g_errbuf:=sqlerrm;

Line 602: edw_log.put_line('l_stmt '||l_stmt);

598: if g_debug_flag = 'Y' then
599: edw_log.put_line('');
600: edw_log.put_line('Error in initTables');
601: edw_log.put_line('pBusAreaName = '||pBusAreaName);
602: edw_log.put_line('l_stmt '||l_stmt);
603: end if;
604:
605: g_errbuf:=sqlerrm;
606: g_retcode:=sqlcode;

Line 633: edw_log.debug_line('Procedure hideFolders');

629:
630: IF g_Mode <> 'TEST' THEN
631:
632: if g_debug_flag = 'Y' then
633: edw_log.debug_line('Procedure hideFolders');
634: edw_log.debug_line('Going to execute statement:');
635: edw_log.debug_line(l_stmt);
636: end if;
637:

Line 634: edw_log.debug_line('Going to execute statement:');

630: IF g_Mode <> 'TEST' THEN
631:
632: if g_debug_flag = 'Y' then
633: edw_log.debug_line('Procedure hideFolders');
634: edw_log.debug_line('Going to execute statement:');
635: edw_log.debug_line(l_stmt);
636: end if;
637:
638: EXECUTE IMMEDIATE l_stmt;

Line 635: edw_log.debug_line(l_stmt);

631:
632: if g_debug_flag = 'Y' then
633: edw_log.debug_line('Procedure hideFolders');
634: edw_log.debug_line('Going to execute statement:');
635: edw_log.debug_line(l_stmt);
636: end if;
637:
638: EXECUTE IMMEDIATE l_stmt;
639:

Line 678: edw_log.debug_line('Procedure hideFolders');

674: 'AND obj.obj_id = bol.bol_obj_id '||
675: 'AND oBj.sobj_ext_table IN ('''||pTableName||''' ,'''||pViewName||''') ';
676:
677: if g_debug_flag = 'Y' then
678: edw_log.debug_line('Procedure hideFolders');
679: edw_log.debug_line('Going to execute statement:');
680: edw_log.debug_line(l_stmt);
681: end if;
682:

Line 679: edw_log.debug_line('Going to execute statement:');

675: 'AND oBj.sobj_ext_table IN ('''||pTableName||''' ,'''||pViewName||''') ';
676:
677: if g_debug_flag = 'Y' then
678: edw_log.debug_line('Procedure hideFolders');
679: edw_log.debug_line('Going to execute statement:');
680: edw_log.debug_line(l_stmt);
681: end if;
682:
683:

Line 680: edw_log.debug_line(l_stmt);

676:
677: if g_debug_flag = 'Y' then
678: edw_log.debug_line('Procedure hideFolders');
679: edw_log.debug_line('Going to execute statement:');
680: edw_log.debug_line(l_stmt);
681: end if;
682:
683:
684: OPEN eulFolder_cv FOR l_Stmt;

Line 794: edw_log.debug_line('Procedure hideEulDimLevels');

790: ' DECODE(MAX(DECODE(H414_NAME , H415_NAME , 0, 1)),0,'',H414'',NULL),'','') '||
791: 'FROM '||pDimTableName;
792:
793: if g_debug_flag = 'Y' then
794: edw_log.debug_line('Procedure hideEulDimLevels');
795: edw_log.debug_line('Going to execute statement:');
796: edw_log.debug_line(l_stmt);
797: end if;
798:

Line 795: edw_log.debug_line('Going to execute statement:');

791: 'FROM '||pDimTableName;
792:
793: if g_debug_flag = 'Y' then
794: edw_log.debug_line('Procedure hideEulDimLevels');
795: edw_log.debug_line('Going to execute statement:');
796: edw_log.debug_line(l_stmt);
797: end if;
798:
799: EXECUTE IMMEDIATE l_stmt INTO levelStr;

Line 796: edw_log.debug_line(l_stmt);

792:
793: if g_debug_flag = 'Y' then
794: edw_log.debug_line('Procedure hideEulDimLevels');
795: edw_log.debug_line('Going to execute statement:');
796: edw_log.debug_line(l_stmt);
797: end if;
798:
799: EXECUTE IMMEDIATE l_stmt INTO levelStr;
800:

Line 817: edw_log.put_line('GL Flex Dimension Tables not found in '||g_fiischema||' schema');

813: EXCEPTION
814: WHEN GL_FLEX_DIM_TAB_NF
815: THEN
816: if g_debug_flag = 'Y' then
817: edw_log.put_line('GL Flex Dimension Tables not found in '||g_fiischema||' schema');
818: end if;
819:
820: WHEN OTHERS THEN
821:

Line 873: edw_log.debug_line('Procedure eulGLFlexDimMaint');

869: 'DECODE(LEAST(COUNT(DISTINCT DECODE(H415_NAME , ''NA_EDW'' , NULL , ''NA_ERR'' , NULL , H415_NAME)),1),1,''Used'',''Not Used'') H415_NAME '||
870: 'FROM '||dimTab(ctr).table_name;
871:
872: if g_debug_flag = 'Y' then
873: edw_log.debug_line('Procedure eulGLFlexDimMaint');
874: edw_log.debug_line('Going to execute statement:');
875: edw_log.debug_line(l_stmt);
876: end if;
877:

Line 874: edw_log.debug_line('Going to execute statement:');

870: 'FROM '||dimTab(ctr).table_name;
871:
872: if g_debug_flag = 'Y' then
873: edw_log.debug_line('Procedure eulGLFlexDimMaint');
874: edw_log.debug_line('Going to execute statement:');
875: edw_log.debug_line(l_stmt);
876: end if;
877:
878:

Line 875: edw_log.debug_line(l_stmt);

871:
872: if g_debug_flag = 'Y' then
873: edw_log.debug_line('Procedure eulGLFlexDimMaint');
874: edw_log.debug_line('Going to execute statement:');
875: edw_log.debug_line(l_stmt);
876: end if;
877:
878:
879: EXECUTE IMMEDIATE l_stmt INTO dimTab(ctr).rowcnt , dimTab(ctr).table_status , dimTab(ctr).hier1_status , dimTab(ctr).hier2_status , dimTab(ctr).hier3_status , dimTab(ctr).hier4_status;

Line 882: edw_log.put_line('Table :'||dimTab(ctr).table_name);

878:
879: EXECUTE IMMEDIATE l_stmt INTO dimTab(ctr).rowcnt , dimTab(ctr).table_status , dimTab(ctr).hier1_status , dimTab(ctr).hier2_status , dimTab(ctr).hier3_status , dimTab(ctr).hier4_status;
880:
881: if g_debug_flag = 'Y' then
882: edw_log.put_line('Table :'||dimTab(ctr).table_name);
883: -- edw_log.put_line(' View :'||dimTab(ctr).view_name);
884: edw_log.put_line(' Rows :'||dimTab(ctr).rowcnt);
885: edw_log.put_line(' Table Status :'||dimTab(ctr).table_status);
886: edw_log.put_line(' Hier 1 Status :'||dimTab(ctr).hier1_status);

Line 883: -- edw_log.put_line(' View :'||dimTab(ctr).view_name);

879: EXECUTE IMMEDIATE l_stmt INTO dimTab(ctr).rowcnt , dimTab(ctr).table_status , dimTab(ctr).hier1_status , dimTab(ctr).hier2_status , dimTab(ctr).hier3_status , dimTab(ctr).hier4_status;
880:
881: if g_debug_flag = 'Y' then
882: edw_log.put_line('Table :'||dimTab(ctr).table_name);
883: -- edw_log.put_line(' View :'||dimTab(ctr).view_name);
884: edw_log.put_line(' Rows :'||dimTab(ctr).rowcnt);
885: edw_log.put_line(' Table Status :'||dimTab(ctr).table_status);
886: edw_log.put_line(' Hier 1 Status :'||dimTab(ctr).hier1_status);
887: edw_log.put_line(' Hier 2 Status :'||dimTab(ctr).hier2_status);

Line 884: edw_log.put_line(' Rows :'||dimTab(ctr).rowcnt);

880:
881: if g_debug_flag = 'Y' then
882: edw_log.put_line('Table :'||dimTab(ctr).table_name);
883: -- edw_log.put_line(' View :'||dimTab(ctr).view_name);
884: edw_log.put_line(' Rows :'||dimTab(ctr).rowcnt);
885: edw_log.put_line(' Table Status :'||dimTab(ctr).table_status);
886: edw_log.put_line(' Hier 1 Status :'||dimTab(ctr).hier1_status);
887: edw_log.put_line(' Hier 2 Status :'||dimTab(ctr).hier2_status);
888: edw_log.put_line(' Hier 3 Status :'||dimTab(ctr).hier3_status);

Line 885: edw_log.put_line(' Table Status :'||dimTab(ctr).table_status);

881: if g_debug_flag = 'Y' then
882: edw_log.put_line('Table :'||dimTab(ctr).table_name);
883: -- edw_log.put_line(' View :'||dimTab(ctr).view_name);
884: edw_log.put_line(' Rows :'||dimTab(ctr).rowcnt);
885: edw_log.put_line(' Table Status :'||dimTab(ctr).table_status);
886: edw_log.put_line(' Hier 1 Status :'||dimTab(ctr).hier1_status);
887: edw_log.put_line(' Hier 2 Status :'||dimTab(ctr).hier2_status);
888: edw_log.put_line(' Hier 3 Status :'||dimTab(ctr).hier3_status);
889: edw_log.put_line(' Hier 4 Status :'||dimTab(ctr).hier4_status);

Line 886: edw_log.put_line(' Hier 1 Status :'||dimTab(ctr).hier1_status);

882: edw_log.put_line('Table :'||dimTab(ctr).table_name);
883: -- edw_log.put_line(' View :'||dimTab(ctr).view_name);
884: edw_log.put_line(' Rows :'||dimTab(ctr).rowcnt);
885: edw_log.put_line(' Table Status :'||dimTab(ctr).table_status);
886: edw_log.put_line(' Hier 1 Status :'||dimTab(ctr).hier1_status);
887: edw_log.put_line(' Hier 2 Status :'||dimTab(ctr).hier2_status);
888: edw_log.put_line(' Hier 3 Status :'||dimTab(ctr).hier3_status);
889: edw_log.put_line(' Hier 4 Status :'||dimTab(ctr).hier4_status);
890: edw_log.put_line('');

Line 887: edw_log.put_line(' Hier 2 Status :'||dimTab(ctr).hier2_status);

883: -- edw_log.put_line(' View :'||dimTab(ctr).view_name);
884: edw_log.put_line(' Rows :'||dimTab(ctr).rowcnt);
885: edw_log.put_line(' Table Status :'||dimTab(ctr).table_status);
886: edw_log.put_line(' Hier 1 Status :'||dimTab(ctr).hier1_status);
887: edw_log.put_line(' Hier 2 Status :'||dimTab(ctr).hier2_status);
888: edw_log.put_line(' Hier 3 Status :'||dimTab(ctr).hier3_status);
889: edw_log.put_line(' Hier 4 Status :'||dimTab(ctr).hier4_status);
890: edw_log.put_line('');
891: end if;

Line 888: edw_log.put_line(' Hier 3 Status :'||dimTab(ctr).hier3_status);

884: edw_log.put_line(' Rows :'||dimTab(ctr).rowcnt);
885: edw_log.put_line(' Table Status :'||dimTab(ctr).table_status);
886: edw_log.put_line(' Hier 1 Status :'||dimTab(ctr).hier1_status);
887: edw_log.put_line(' Hier 2 Status :'||dimTab(ctr).hier2_status);
888: edw_log.put_line(' Hier 3 Status :'||dimTab(ctr).hier3_status);
889: edw_log.put_line(' Hier 4 Status :'||dimTab(ctr).hier4_status);
890: edw_log.put_line('');
891: end if;
892:

Line 889: edw_log.put_line(' Hier 4 Status :'||dimTab(ctr).hier4_status);

885: edw_log.put_line(' Table Status :'||dimTab(ctr).table_status);
886: edw_log.put_line(' Hier 1 Status :'||dimTab(ctr).hier1_status);
887: edw_log.put_line(' Hier 2 Status :'||dimTab(ctr).hier2_status);
888: edw_log.put_line(' Hier 3 Status :'||dimTab(ctr).hier3_status);
889: edw_log.put_line(' Hier 4 Status :'||dimTab(ctr).hier4_status);
890: edw_log.put_line('');
891: end if;
892:
893:

Line 890: edw_log.put_line('');

886: edw_log.put_line(' Hier 1 Status :'||dimTab(ctr).hier1_status);
887: edw_log.put_line(' Hier 2 Status :'||dimTab(ctr).hier2_status);
888: edw_log.put_line(' Hier 3 Status :'||dimTab(ctr).hier3_status);
889: edw_log.put_line(' Hier 4 Status :'||dimTab(ctr).hier4_status);
890: edw_log.put_line('');
891: end if;
892:
893:
894: -- Hide Unused dimensions and hier

Line 965: edw_log.put_line('GL Flex Dimension Tables not found in '||g_fiischema||' schema');

961: EXCEPTION
962: WHEN GL_FLEX_DIM_TAB_NF
963: THEN
964: if g_debug_flag = 'Y' then
965: edw_log.put_line('GL Flex Dimension Tables not found in '||g_fiischema||' schema');
966: end if;
967:
968: WHEN OTHERS THEN
969: edw_log.put_line('');

Line 969: edw_log.put_line('');

965: edw_log.put_line('GL Flex Dimension Tables not found in '||g_fiischema||' schema');
966: end if;
967:
968: WHEN OTHERS THEN
969: edw_log.put_line('');
970: edw_log.put_line('Error in eulGLFlexDimMaint '||eulBusAreaTab(ba_ctr).ba_name);
971: edw_log.put_line('dimTab(ctr).table_status = '||dimTab(ctr).table_status);
972: edw_log.put_line('ctr = '||ctr);
973: edw_log.put_line('Table :'||dimTab(ctr).table_name);

Line 970: edw_log.put_line('Error in eulGLFlexDimMaint '||eulBusAreaTab(ba_ctr).ba_name);

966: end if;
967:
968: WHEN OTHERS THEN
969: edw_log.put_line('');
970: edw_log.put_line('Error in eulGLFlexDimMaint '||eulBusAreaTab(ba_ctr).ba_name);
971: edw_log.put_line('dimTab(ctr).table_status = '||dimTab(ctr).table_status);
972: edw_log.put_line('ctr = '||ctr);
973: edw_log.put_line('Table :'||dimTab(ctr).table_name);
974: -- edw_log.put_line(' View :'||dimTab(ctr).view_name);

Line 971: edw_log.put_line('dimTab(ctr).table_status = '||dimTab(ctr).table_status);

967:
968: WHEN OTHERS THEN
969: edw_log.put_line('');
970: edw_log.put_line('Error in eulGLFlexDimMaint '||eulBusAreaTab(ba_ctr).ba_name);
971: edw_log.put_line('dimTab(ctr).table_status = '||dimTab(ctr).table_status);
972: edw_log.put_line('ctr = '||ctr);
973: edw_log.put_line('Table :'||dimTab(ctr).table_name);
974: -- edw_log.put_line(' View :'||dimTab(ctr).view_name);
975: edw_log.put_line(' Rows :'||dimTab(ctr).rowcnt);

Line 972: edw_log.put_line('ctr = '||ctr);

968: WHEN OTHERS THEN
969: edw_log.put_line('');
970: edw_log.put_line('Error in eulGLFlexDimMaint '||eulBusAreaTab(ba_ctr).ba_name);
971: edw_log.put_line('dimTab(ctr).table_status = '||dimTab(ctr).table_status);
972: edw_log.put_line('ctr = '||ctr);
973: edw_log.put_line('Table :'||dimTab(ctr).table_name);
974: -- edw_log.put_line(' View :'||dimTab(ctr).view_name);
975: edw_log.put_line(' Rows :'||dimTab(ctr).rowcnt);
976: edw_log.put_line(' Table Status :'||dimTab(ctr).table_status);

Line 973: edw_log.put_line('Table :'||dimTab(ctr).table_name);

969: edw_log.put_line('');
970: edw_log.put_line('Error in eulGLFlexDimMaint '||eulBusAreaTab(ba_ctr).ba_name);
971: edw_log.put_line('dimTab(ctr).table_status = '||dimTab(ctr).table_status);
972: edw_log.put_line('ctr = '||ctr);
973: edw_log.put_line('Table :'||dimTab(ctr).table_name);
974: -- edw_log.put_line(' View :'||dimTab(ctr).view_name);
975: edw_log.put_line(' Rows :'||dimTab(ctr).rowcnt);
976: edw_log.put_line(' Table Status :'||dimTab(ctr).table_status);
977: edw_log.put_line(' Hier 1 Status :'||dimTab(ctr).hier1_status);

Line 974: -- edw_log.put_line(' View :'||dimTab(ctr).view_name);

970: edw_log.put_line('Error in eulGLFlexDimMaint '||eulBusAreaTab(ba_ctr).ba_name);
971: edw_log.put_line('dimTab(ctr).table_status = '||dimTab(ctr).table_status);
972: edw_log.put_line('ctr = '||ctr);
973: edw_log.put_line('Table :'||dimTab(ctr).table_name);
974: -- edw_log.put_line(' View :'||dimTab(ctr).view_name);
975: edw_log.put_line(' Rows :'||dimTab(ctr).rowcnt);
976: edw_log.put_line(' Table Status :'||dimTab(ctr).table_status);
977: edw_log.put_line(' Hier 1 Status :'||dimTab(ctr).hier1_status);
978: edw_log.put_line(' Hier 2 Status :'||dimTab(ctr).hier2_status);

Line 975: edw_log.put_line(' Rows :'||dimTab(ctr).rowcnt);

971: edw_log.put_line('dimTab(ctr).table_status = '||dimTab(ctr).table_status);
972: edw_log.put_line('ctr = '||ctr);
973: edw_log.put_line('Table :'||dimTab(ctr).table_name);
974: -- edw_log.put_line(' View :'||dimTab(ctr).view_name);
975: edw_log.put_line(' Rows :'||dimTab(ctr).rowcnt);
976: edw_log.put_line(' Table Status :'||dimTab(ctr).table_status);
977: edw_log.put_line(' Hier 1 Status :'||dimTab(ctr).hier1_status);
978: edw_log.put_line(' Hier 2 Status :'||dimTab(ctr).hier2_status);
979: edw_log.put_line(' Hier 3 Status :'||dimTab(ctr).hier3_status);

Line 976: edw_log.put_line(' Table Status :'||dimTab(ctr).table_status);

972: edw_log.put_line('ctr = '||ctr);
973: edw_log.put_line('Table :'||dimTab(ctr).table_name);
974: -- edw_log.put_line(' View :'||dimTab(ctr).view_name);
975: edw_log.put_line(' Rows :'||dimTab(ctr).rowcnt);
976: edw_log.put_line(' Table Status :'||dimTab(ctr).table_status);
977: edw_log.put_line(' Hier 1 Status :'||dimTab(ctr).hier1_status);
978: edw_log.put_line(' Hier 2 Status :'||dimTab(ctr).hier2_status);
979: edw_log.put_line(' Hier 3 Status :'||dimTab(ctr).hier3_status);
980: edw_log.put_line(' Hier 4 Status :'||dimTab(ctr).hier4_status);

Line 977: edw_log.put_line(' Hier 1 Status :'||dimTab(ctr).hier1_status);

973: edw_log.put_line('Table :'||dimTab(ctr).table_name);
974: -- edw_log.put_line(' View :'||dimTab(ctr).view_name);
975: edw_log.put_line(' Rows :'||dimTab(ctr).rowcnt);
976: edw_log.put_line(' Table Status :'||dimTab(ctr).table_status);
977: edw_log.put_line(' Hier 1 Status :'||dimTab(ctr).hier1_status);
978: edw_log.put_line(' Hier 2 Status :'||dimTab(ctr).hier2_status);
979: edw_log.put_line(' Hier 3 Status :'||dimTab(ctr).hier3_status);
980: edw_log.put_line(' Hier 4 Status :'||dimTab(ctr).hier4_status);
981: edw_log.put_line('');

Line 978: edw_log.put_line(' Hier 2 Status :'||dimTab(ctr).hier2_status);

974: -- edw_log.put_line(' View :'||dimTab(ctr).view_name);
975: edw_log.put_line(' Rows :'||dimTab(ctr).rowcnt);
976: edw_log.put_line(' Table Status :'||dimTab(ctr).table_status);
977: edw_log.put_line(' Hier 1 Status :'||dimTab(ctr).hier1_status);
978: edw_log.put_line(' Hier 2 Status :'||dimTab(ctr).hier2_status);
979: edw_log.put_line(' Hier 3 Status :'||dimTab(ctr).hier3_status);
980: edw_log.put_line(' Hier 4 Status :'||dimTab(ctr).hier4_status);
981: edw_log.put_line('');
982:

Line 979: edw_log.put_line(' Hier 3 Status :'||dimTab(ctr).hier3_status);

975: edw_log.put_line(' Rows :'||dimTab(ctr).rowcnt);
976: edw_log.put_line(' Table Status :'||dimTab(ctr).table_status);
977: edw_log.put_line(' Hier 1 Status :'||dimTab(ctr).hier1_status);
978: edw_log.put_line(' Hier 2 Status :'||dimTab(ctr).hier2_status);
979: edw_log.put_line(' Hier 3 Status :'||dimTab(ctr).hier3_status);
980: edw_log.put_line(' Hier 4 Status :'||dimTab(ctr).hier4_status);
981: edw_log.put_line('');
982:
983: g_errbuf:=sqlerrm;

Line 980: edw_log.put_line(' Hier 4 Status :'||dimTab(ctr).hier4_status);

976: edw_log.put_line(' Table Status :'||dimTab(ctr).table_status);
977: edw_log.put_line(' Hier 1 Status :'||dimTab(ctr).hier1_status);
978: edw_log.put_line(' Hier 2 Status :'||dimTab(ctr).hier2_status);
979: edw_log.put_line(' Hier 3 Status :'||dimTab(ctr).hier3_status);
980: edw_log.put_line(' Hier 4 Status :'||dimTab(ctr).hier4_status);
981: edw_log.put_line('');
982:
983: g_errbuf:=sqlerrm;
984: g_retcode:=sqlcode;

Line 981: edw_log.put_line('');

977: edw_log.put_line(' Hier 1 Status :'||dimTab(ctr).hier1_status);
978: edw_log.put_line(' Hier 2 Status :'||dimTab(ctr).hier2_status);
979: edw_log.put_line(' Hier 3 Status :'||dimTab(ctr).hier3_status);
980: edw_log.put_line(' Hier 4 Status :'||dimTab(ctr).hier4_status);
981: edw_log.put_line('');
982:
983: g_errbuf:=sqlerrm;
984: g_retcode:=sqlcode;
985:

Line 1071: edw_log.debug_line('Procedure eulHierDelete');

1067: 'AND hier_segments.ihs_hn_id_child = hier_nodes.hn_id '||
1068: 'AND hier_nodes.hn_hi_id = hier.hi_id';
1069:
1070: if g_debug_flag = 'Y' then
1071: edw_log.debug_line('Procedure eulHierDelete');
1072: edw_log.debug_line('Going to execute statement:');
1073: edw_log.debug_line(l_stmt);
1074: end if;
1075:

Line 1072: edw_log.debug_line('Going to execute statement:');

1068: 'AND hier_nodes.hn_hi_id = hier.hi_id';
1069:
1070: if g_debug_flag = 'Y' then
1071: edw_log.debug_line('Procedure eulHierDelete');
1072: edw_log.debug_line('Going to execute statement:');
1073: edw_log.debug_line(l_stmt);
1074: end if;
1075:
1076: IF g_mode <> 'TEST' THEN

Line 1073: edw_log.debug_line(l_stmt);

1069:
1070: if g_debug_flag = 'Y' then
1071: edw_log.debug_line('Procedure eulHierDelete');
1072: edw_log.debug_line('Going to execute statement:');
1073: edw_log.debug_line(l_stmt);
1074: end if;
1075:
1076: IF g_mode <> 'TEST' THEN
1077:

Line 1112: edw_log.put_line('');

1108:
1109: CLOSE eulHier_cv;
1110:
1111: if g_debug_flag = 'Y' then
1112: edw_log.put_line('');
1113: edw_log.put_line('Deleted Unused time hierarchies from FII Business Areas.');
1114: edw_log.put_line('');
1115: end if;
1116:

Line 1113: edw_log.put_line('Deleted Unused time hierarchies from FII Business Areas.');

1109: CLOSE eulHier_cv;
1110:
1111: if g_debug_flag = 'Y' then
1112: edw_log.put_line('');
1113: edw_log.put_line('Deleted Unused time hierarchies from FII Business Areas.');
1114: edw_log.put_line('');
1115: end if;
1116:
1117: END IF;

Line 1114: edw_log.put_line('');

1110:
1111: if g_debug_flag = 'Y' then
1112: edw_log.put_line('');
1113: edw_log.put_line('Deleted Unused time hierarchies from FII Business Areas.');
1114: edw_log.put_line('');
1115: end if;
1116:
1117: END IF;
1118:

Line 1202: edw_log.put_line('Item Name '||eulColumnsTab(ctr).item_name);

1198: IF eulColumnsTab(ctr).item_data_type = 2 AND
1199: eulColumnsTab(ctr).table_type = 'F' THEN
1200:
1201: /*
1202: edw_log.put_line('Item Name '||eulColumnsTab(ctr).item_name);
1203: edw_log.put_line('Item Heading '||eulColumnsTab(ctr).item_heading);
1204: edw_log.put_line('Item Format '||eulColumnsTab(ctr).item_format_mask);
1205: */
1206: l_stmt := 'UPDATE '||g_EulOwner||'.eul4_expressions '||

Line 1203: edw_log.put_line('Item Heading '||eulColumnsTab(ctr).item_heading);

1199: eulColumnsTab(ctr).table_type = 'F' THEN
1200:
1201: /*
1202: edw_log.put_line('Item Name '||eulColumnsTab(ctr).item_name);
1203: edw_log.put_line('Item Heading '||eulColumnsTab(ctr).item_heading);
1204: edw_log.put_line('Item Format '||eulColumnsTab(ctr).item_format_mask);
1205: */
1206: l_stmt := 'UPDATE '||g_EulOwner||'.eul4_expressions '||
1207: 'SET it_heading = NVL(it_heading,exp_name) , '||

Line 1204: edw_log.put_line('Item Format '||eulColumnsTab(ctr).item_format_mask);

1200:
1201: /*
1202: edw_log.put_line('Item Name '||eulColumnsTab(ctr).item_name);
1203: edw_log.put_line('Item Heading '||eulColumnsTab(ctr).item_heading);
1204: edw_log.put_line('Item Format '||eulColumnsTab(ctr).item_format_mask);
1205: */
1206: l_stmt := 'UPDATE '||g_EulOwner||'.eul4_expressions '||
1207: 'SET it_heading = NVL(it_heading,exp_name) , '||
1208: ' it_format_mask = NVL(it_format_mask , ''999G999G999G999'') '||

Line 1264: edw_log.put_line('');

1260:
1261: FOR ba IN 1..eulBusAreaTab.count LOOP
1262:
1263: if g_debug_flag = 'Y' then
1264: edw_log.put_line('');
1265: edw_log.put_line(eulBusAreaTab(ba_ctr).ba_name);
1266: edw_log.put_line('');
1267: edw_log.put_line(' '||RPAD('Table Name',30,' ')||' '||'Folder Name');
1268: edw_log.put_line(' '||RPAD('-',30,'-')||' '||RPAD('-',30,'-'));

Line 1265: edw_log.put_line(eulBusAreaTab(ba_ctr).ba_name);

1261: FOR ba IN 1..eulBusAreaTab.count LOOP
1262:
1263: if g_debug_flag = 'Y' then
1264: edw_log.put_line('');
1265: edw_log.put_line(eulBusAreaTab(ba_ctr).ba_name);
1266: edw_log.put_line('');
1267: edw_log.put_line(' '||RPAD('Table Name',30,' ')||' '||'Folder Name');
1268: edw_log.put_line(' '||RPAD('-',30,'-')||' '||RPAD('-',30,'-'));
1269: end if;

Line 1266: edw_log.put_line('');

1262:
1263: if g_debug_flag = 'Y' then
1264: edw_log.put_line('');
1265: edw_log.put_line(eulBusAreaTab(ba_ctr).ba_name);
1266: edw_log.put_line('');
1267: edw_log.put_line(' '||RPAD('Table Name',30,' ')||' '||'Folder Name');
1268: edw_log.put_line(' '||RPAD('-',30,'-')||' '||RPAD('-',30,'-'));
1269: end if;
1270:

Line 1267: edw_log.put_line(' '||RPAD('Table Name',30,' ')||' '||'Folder Name');

1263: if g_debug_flag = 'Y' then
1264: edw_log.put_line('');
1265: edw_log.put_line(eulBusAreaTab(ba_ctr).ba_name);
1266: edw_log.put_line('');
1267: edw_log.put_line(' '||RPAD('Table Name',30,' ')||' '||'Folder Name');
1268: edw_log.put_line(' '||RPAD('-',30,'-')||' '||RPAD('-',30,'-'));
1269: end if;
1270:
1271: tab_ctr := eulTablesTab.first;

Line 1268: edw_log.put_line(' '||RPAD('-',30,'-')||' '||RPAD('-',30,'-'));

1264: edw_log.put_line('');
1265: edw_log.put_line(eulBusAreaTab(ba_ctr).ba_name);
1266: edw_log.put_line('');
1267: edw_log.put_line(' '||RPAD('Table Name',30,' ')||' '||'Folder Name');
1268: edw_log.put_line(' '||RPAD('-',30,'-')||' '||RPAD('-',30,'-'));
1269: end if;
1270:
1271: tab_ctr := eulTablesTab.first;
1272:

Line 1277: edw_log.PUT_LINE(' '||RPAD(eulTablesTab(tab_ctr).table_name,30,' ')||' '||eulTablesTab(tab_ctr).folder_name);

1273: FOR tab IN 1..eulTablesTab.count LOOP
1274:
1275: IF eulTablesTab(tab_ctr).BA_ID = eulBusAreaTab(ba_ctr).ba_id THEN
1276: if g_debug_flag = 'Y' then
1277: edw_log.PUT_LINE(' '||RPAD(eulTablesTab(tab_ctr).table_name,30,' ')||' '||eulTablesTab(tab_ctr).folder_name);
1278: end if;
1279: IF eulTablesTab(tab_ctr).hidden_item_flag = 'Y' AND eulTablesTab(tab_ctr).folder_sb_hidden = 0 THEN
1280:
1281: if g_debug_flag = 'Y' then

Line 1282: edw_log.put_line(' '||RPAD('Column Name',30,' ')||' '||'Change '||' '||'Item Name');

1278: end if;
1279: IF eulTablesTab(tab_ctr).hidden_item_flag = 'Y' AND eulTablesTab(tab_ctr).folder_sb_hidden = 0 THEN
1280:
1281: if g_debug_flag = 'Y' then
1282: edw_log.put_line(' '||RPAD('Column Name',30,' ')||' '||'Change '||' '||'Item Name');
1283: edw_log.put_line(' '||RPAD('-',30,'-')||' '||RPAD('-',30,'-'));
1284: end if;
1285:
1286: col_ctr := eulColumnsTab.first;

Line 1283: edw_log.put_line(' '||RPAD('-',30,'-')||' '||RPAD('-',30,'-'));

1279: IF eulTablesTab(tab_ctr).hidden_item_flag = 'Y' AND eulTablesTab(tab_ctr).folder_sb_hidden = 0 THEN
1280:
1281: if g_debug_flag = 'Y' then
1282: edw_log.put_line(' '||RPAD('Column Name',30,' ')||' '||'Change '||' '||'Item Name');
1283: edw_log.put_line(' '||RPAD('-',30,'-')||' '||RPAD('-',30,'-'));
1284: end if;
1285:
1286: col_ctr := eulColumnsTab.first;
1287:

Line 1296: edw_log.put_line(' '||RPAD(eulColumnsTab(col_ctr).column_name,30,' ')||' '||'Hide '||' '||eulColumnsTab(col_ctr).item_name);

1292: IF eulColumnsTab(col_ctr).item_sb_hidden = 1 AND
1293: eulColumnsTab(col_ctr).item_hidden = 0 THEN
1294:
1295: if g_debug_flag = 'Y' then
1296: edw_log.put_line(' '||RPAD(eulColumnsTab(col_ctr).column_name,30,' ')||' '||'Hide '||' '||eulColumnsTab(col_ctr).item_name);
1297: end if;
1298:
1299: ELSIF eulColumnsTab(col_ctr).item_sb_hidden = 0 AND
1300: eulColumnsTab(col_ctr).item_hidden = 1 THEN

Line 1303: edw_log.put_line(' '||RPAD(eulColumnsTab(col_ctr).column_name,30,' ')||' '||'Display'||' '||eulColumnsTab(col_ctr).item_name);

1299: ELSIF eulColumnsTab(col_ctr).item_sb_hidden = 0 AND
1300: eulColumnsTab(col_ctr).item_hidden = 1 THEN
1301:
1302: if g_debug_flag = 'Y' then
1303: edw_log.put_line(' '||RPAD(eulColumnsTab(col_ctr).column_name,30,' ')||' '||'Display'||' '||eulColumnsTab(col_ctr).item_name);
1304: end if;
1305: ELSE
1306:
1307: NULL;

Line 1317: edw_log.put_line(' ');

1313: col_ctr := eulColumnsTab.next(col_ctr);
1314:
1315: END LOOP;
1316: if g_debug_flag = 'Y' then
1317: edw_log.put_line(' ');
1318: end if;
1319:
1320: END IF;
1321:

Line 1328: edw_log.put_line(' ');

1324: tab_ctr := eulTablesTab.next(tab_ctr);
1325:
1326: END LOOP;
1327: if g_debug_flag = 'Y' then
1328: edw_log.put_line(' ');
1329: end if;
1330: ba_ctr := eulBusAreaTab.next(ba_ctr);
1331:
1332: END LOOP;

Line 1339: edw_log.put_line('');

1335:
1336: FOR ba IN 1..eulBusAreaTab.count LOOP
1337:
1338: if g_debug_flag = 'Y' then
1339: edw_log.put_line('');
1340: edw_log.put_line(eulBusAreaTab(ba_ctr).ba_name||' - ');
1341: edw_log.put_line('Items Evaluated:'||eulBusAreaTab(ba_ctr).ba_records_evaluated);
1342: edw_log.put_line('Items Hidden:'||eulBusAreaTab(ba_ctr).ba_records_hidden);
1343: end if;

Line 1340: edw_log.put_line(eulBusAreaTab(ba_ctr).ba_name||' - ');

1336: FOR ba IN 1..eulBusAreaTab.count LOOP
1337:
1338: if g_debug_flag = 'Y' then
1339: edw_log.put_line('');
1340: edw_log.put_line(eulBusAreaTab(ba_ctr).ba_name||' - ');
1341: edw_log.put_line('Items Evaluated:'||eulBusAreaTab(ba_ctr).ba_records_evaluated);
1342: edw_log.put_line('Items Hidden:'||eulBusAreaTab(ba_ctr).ba_records_hidden);
1343: end if;
1344: ba_ctr := eulBusAreaTab.next(ba_ctr);

Line 1341: edw_log.put_line('Items Evaluated:'||eulBusAreaTab(ba_ctr).ba_records_evaluated);

1337:
1338: if g_debug_flag = 'Y' then
1339: edw_log.put_line('');
1340: edw_log.put_line(eulBusAreaTab(ba_ctr).ba_name||' - ');
1341: edw_log.put_line('Items Evaluated:'||eulBusAreaTab(ba_ctr).ba_records_evaluated);
1342: edw_log.put_line('Items Hidden:'||eulBusAreaTab(ba_ctr).ba_records_hidden);
1343: end if;
1344: ba_ctr := eulBusAreaTab.next(ba_ctr);
1345:

Line 1342: edw_log.put_line('Items Hidden:'||eulBusAreaTab(ba_ctr).ba_records_hidden);

1338: if g_debug_flag = 'Y' then
1339: edw_log.put_line('');
1340: edw_log.put_line(eulBusAreaTab(ba_ctr).ba_name||' - ');
1341: edw_log.put_line('Items Evaluated:'||eulBusAreaTab(ba_ctr).ba_records_evaluated);
1342: edw_log.put_line('Items Hidden:'||eulBusAreaTab(ba_ctr).ba_records_hidden);
1343: end if;
1344: ba_ctr := eulBusAreaTab.next(ba_ctr);
1345:
1346: END LOOP;

Line 1348: edw_log.put_line(eulColumnsTab.count||' Items Evaluated');

1344: ba_ctr := eulBusAreaTab.next(ba_ctr);
1345:
1346: END LOOP;
1347: if g_debug_flag = 'Y' then
1348: edw_log.put_line(eulColumnsTab.count||' Items Evaluated');
1349: edw_log.put_line(lFactChangeCtr||' Fact Items Hidden');
1350: edw_log.put_line(lDimChangeCtr||' Dimension Items Hidden');
1351:
1352: end if;

Line 1349: edw_log.put_line(lFactChangeCtr||' Fact Items Hidden');

1345:
1346: END LOOP;
1347: if g_debug_flag = 'Y' then
1348: edw_log.put_line(eulColumnsTab.count||' Items Evaluated');
1349: edw_log.put_line(lFactChangeCtr||' Fact Items Hidden');
1350: edw_log.put_line(lDimChangeCtr||' Dimension Items Hidden');
1351:
1352: end if;
1353:

Line 1350: edw_log.put_line(lDimChangeCtr||' Dimension Items Hidden');

1346: END LOOP;
1347: if g_debug_flag = 'Y' then
1348: edw_log.put_line(eulColumnsTab.count||' Items Evaluated');
1349: edw_log.put_line(lFactChangeCtr||' Fact Items Hidden');
1350: edw_log.put_line(lDimChangeCtr||' Dimension Items Hidden');
1351:
1352: end if;
1353:
1354: COMMIT;

Line 1363: edw_log.put_line('Business Area Name not found');

1359: Errbuf := g_errbuf;
1360: Retcode := g_retcode;
1361: l_exception_msg := Retcode || ':' || Errbuf;
1362: if g_debug_flag = 'Y' then
1363: edw_log.put_line('Business Area Name not found');
1364: edw_log.put_line('Process : '||g_processName);
1365: end if;
1366: raise;
1367:

Line 1364: edw_log.put_line('Process : '||g_processName);

1360: Retcode := g_retcode;
1361: l_exception_msg := Retcode || ':' || Errbuf;
1362: if g_debug_flag = 'Y' then
1363: edw_log.put_line('Business Area Name not found');
1364: edw_log.put_line('Process : '||g_processName);
1365: end if;
1366: raise;
1367:
1368: WHEN G_EUL_OWNER_DOES_NOT_EXIST THEN

Line 1373: edw_log.put_line('End User Layer (EUL) Owner not found');

1369: Errbuf:=g_errbuf;
1370: Retcode:=g_retcode;
1371: l_exception_msg := Retcode || ':' || Errbuf;
1372: if g_debug_flag = 'Y' then
1373: edw_log.put_line('End User Layer (EUL) Owner not found');
1374: edw_log.put_line('Process : '||g_processName);
1375: end if;
1376: raise;
1377:

Line 1374: edw_log.put_line('Process : '||g_processName);

1370: Retcode:=g_retcode;
1371: l_exception_msg := Retcode || ':' || Errbuf;
1372: if g_debug_flag = 'Y' then
1373: edw_log.put_line('End User Layer (EUL) Owner not found');
1374: edw_log.put_line('Process : '||g_processName);
1375: end if;
1376: raise;
1377:
1378: WHEN OTHERS THEN

Line 1383: edw_log.put_line(l_exception_msg);

1379: Errbuf:=g_errbuf;
1380: Retcode:=g_retcode;
1381: l_exception_msg := Retcode || ':' || Errbuf;
1382: if g_debug_flag = 'Y' then
1383: edw_log.put_line(l_exception_msg);
1384: edw_log.put_line('pAction'||pAction);
1385: edw_log.put_line('pEulOwnerName'||g_EulOwner);
1386: edw_log.put_line('pBusAreaName'||pBusAreaName);
1387: edw_log.put_line('pMode'||g_mode);

Line 1384: edw_log.put_line('pAction'||pAction);

1380: Retcode:=g_retcode;
1381: l_exception_msg := Retcode || ':' || Errbuf;
1382: if g_debug_flag = 'Y' then
1383: edw_log.put_line(l_exception_msg);
1384: edw_log.put_line('pAction'||pAction);
1385: edw_log.put_line('pEulOwnerName'||g_EulOwner);
1386: edw_log.put_line('pBusAreaName'||pBusAreaName);
1387: edw_log.put_line('pMode'||g_mode);
1388: edw_log.put_line('Process : '||g_processName);

Line 1385: edw_log.put_line('pEulOwnerName'||g_EulOwner);

1381: l_exception_msg := Retcode || ':' || Errbuf;
1382: if g_debug_flag = 'Y' then
1383: edw_log.put_line(l_exception_msg);
1384: edw_log.put_line('pAction'||pAction);
1385: edw_log.put_line('pEulOwnerName'||g_EulOwner);
1386: edw_log.put_line('pBusAreaName'||pBusAreaName);
1387: edw_log.put_line('pMode'||g_mode);
1388: edw_log.put_line('Process : '||g_processName);
1389: edw_log.put_line('l_stmt : '||l_stmt);

Line 1386: edw_log.put_line('pBusAreaName'||pBusAreaName);

1382: if g_debug_flag = 'Y' then
1383: edw_log.put_line(l_exception_msg);
1384: edw_log.put_line('pAction'||pAction);
1385: edw_log.put_line('pEulOwnerName'||g_EulOwner);
1386: edw_log.put_line('pBusAreaName'||pBusAreaName);
1387: edw_log.put_line('pMode'||g_mode);
1388: edw_log.put_line('Process : '||g_processName);
1389: edw_log.put_line('l_stmt : '||l_stmt);
1390: end if;

Line 1387: edw_log.put_line('pMode'||g_mode);

1383: edw_log.put_line(l_exception_msg);
1384: edw_log.put_line('pAction'||pAction);
1385: edw_log.put_line('pEulOwnerName'||g_EulOwner);
1386: edw_log.put_line('pBusAreaName'||pBusAreaName);
1387: edw_log.put_line('pMode'||g_mode);
1388: edw_log.put_line('Process : '||g_processName);
1389: edw_log.put_line('l_stmt : '||l_stmt);
1390: end if;
1391: raise;

Line 1388: edw_log.put_line('Process : '||g_processName);

1384: edw_log.put_line('pAction'||pAction);
1385: edw_log.put_line('pEulOwnerName'||g_EulOwner);
1386: edw_log.put_line('pBusAreaName'||pBusAreaName);
1387: edw_log.put_line('pMode'||g_mode);
1388: edw_log.put_line('Process : '||g_processName);
1389: edw_log.put_line('l_stmt : '||l_stmt);
1390: end if;
1391: raise;
1392:

Line 1389: edw_log.put_line('l_stmt : '||l_stmt);

1385: edw_log.put_line('pEulOwnerName'||g_EulOwner);
1386: edw_log.put_line('pBusAreaName'||pBusAreaName);
1387: edw_log.put_line('pMode'||g_mode);
1388: edw_log.put_line('Process : '||g_processName);
1389: edw_log.put_line('l_stmt : '||l_stmt);
1390: end if;
1391: raise;
1392:
1393: END EulMaint;