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_EUL_UTILS dependencies on EDW_LOG

Line 114: edw_log.g_debug := TRUE;

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

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

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

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

118: if l_dir is null then
119: l_dir:='/sqlcom/log';
120: end if;
121: if g_debug_flag = 'Y' then
122: edw_log.put_names(p_object_name||'.log',p_object_name||'.out',l_dir);
123: end if;
124:
125: EXCEPTION
126: WHEN OTHERS THEN

Line 235: edw_log.put_line('');

231:
232: EXCEPTION
233: WHEN OTHERS THEN
234: if g_debug_flag = 'Y' then
235: edw_log.put_line('');
236: edw_log.put_line('Error in '||g_processName);
237: edw_log.put_line('pBusAreaNamein = '||pBusAreaNamein);
238: edw_log.put_line('pTableName = '||pTableNamein);
239: edw_log.put_line('pColumnNameIn ='||pColumnNameIn);

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

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

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

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

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

234: if g_debug_flag = 'Y' then
235: edw_log.put_line('');
236: edw_log.put_line('Error in '||g_processName);
237: edw_log.put_line('pBusAreaNamein = '||pBusAreaNamein);
238: edw_log.put_line('pTableName = '||pTableNamein);
239: edw_log.put_line('pColumnNameIn ='||pColumnNameIn);
240: edw_log.put_line('pItemNameIn ='||pItemNameIn);
241: end if;
242:

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

235: edw_log.put_line('');
236: edw_log.put_line('Error in '||g_processName);
237: edw_log.put_line('pBusAreaNamein = '||pBusAreaNamein);
238: edw_log.put_line('pTableName = '||pTableNamein);
239: edw_log.put_line('pColumnNameIn ='||pColumnNameIn);
240: edw_log.put_line('pItemNameIn ='||pItemNameIn);
241: end if;
242:
243: g_errbuf:=sqlerrm;

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

236: edw_log.put_line('Error in '||g_processName);
237: edw_log.put_line('pBusAreaNamein = '||pBusAreaNamein);
238: edw_log.put_line('pTableName = '||pTableNamein);
239: edw_log.put_line('pColumnNameIn ='||pColumnNameIn);
240: edw_log.put_line('pItemNameIn ='||pItemNameIn);
241: end if;
242:
243: g_errbuf:=sqlerrm;
244: g_retcode:=sqlcode;

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

273:
274: END IF;
275:
276: if g_debug_flag = 'Y' then
277: edw_log.debug_line('Procedure hideFolderItems');
278: edw_log.debug_line('Going to execute statement:');
279: edw_log.debug_line(l_stmt);
280: end if;
281:

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

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

Line 279: edw_log.debug_line(l_stmt);

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

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

322: 'AND exp.ite_obj_id = obj.obj_id '||
323: 'AND exp.it_ext_column LIKE '''||pColumn||'''';
324:
325: if g_debug_flag = 'Y' then
326: edw_log.debug_line('Procedure hideFolderItems');
327: edw_log.debug_line('Going to execute statement:');
328: edw_log.debug_line(l_stmt);
329: end if;
330:

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

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

Line 328: edw_log.debug_line(l_stmt);

324:
325: if g_debug_flag = 'Y' then
326: edw_log.debug_line('Procedure hideFolderItems');
327: edw_log.debug_line('Going to execute statement:');
328: edw_log.debug_line(l_stmt);
329: end if;
330:
331: -- EXECUTE IMMEDIATE l_stmt INTO l_itemID ;
332:

Line 361: edw_log.put_line('');

357:
358: EXCEPTION
359: WHEN OTHERS THEN
360: if g_debug_flag = 'Y' then
361: edw_log.put_line('');
362: edw_log.put_line('Error in hideFolderItems');
363: edw_log.put_line('pBusAreaID = '||pBusAreaID);
364: edw_log.put_line('pTableName = '||pTableName);
365: edw_log.put_line('pViewName = '||pViewName);

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

358: EXCEPTION
359: WHEN OTHERS THEN
360: if g_debug_flag = 'Y' then
361: edw_log.put_line('');
362: edw_log.put_line('Error in hideFolderItems');
363: edw_log.put_line('pBusAreaID = '||pBusAreaID);
364: edw_log.put_line('pTableName = '||pTableName);
365: edw_log.put_line('pViewName = '||pViewName);
366: edw_log.put_line('pColumn LIKE '||pColumn);

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

359: WHEN OTHERS THEN
360: if g_debug_flag = 'Y' then
361: edw_log.put_line('');
362: edw_log.put_line('Error in hideFolderItems');
363: edw_log.put_line('pBusAreaID = '||pBusAreaID);
364: edw_log.put_line('pTableName = '||pTableName);
365: edw_log.put_line('pViewName = '||pViewName);
366: edw_log.put_line('pColumn LIKE '||pColumn);
367: edw_log.put_line('l_stmt '||l_stmt);

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

360: if g_debug_flag = 'Y' then
361: edw_log.put_line('');
362: edw_log.put_line('Error in hideFolderItems');
363: edw_log.put_line('pBusAreaID = '||pBusAreaID);
364: edw_log.put_line('pTableName = '||pTableName);
365: edw_log.put_line('pViewName = '||pViewName);
366: edw_log.put_line('pColumn LIKE '||pColumn);
367: edw_log.put_line('l_stmt '||l_stmt);
368: end if;

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

361: edw_log.put_line('');
362: edw_log.put_line('Error in hideFolderItems');
363: edw_log.put_line('pBusAreaID = '||pBusAreaID);
364: edw_log.put_line('pTableName = '||pTableName);
365: edw_log.put_line('pViewName = '||pViewName);
366: edw_log.put_line('pColumn LIKE '||pColumn);
367: edw_log.put_line('l_stmt '||l_stmt);
368: end if;
369:

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

362: edw_log.put_line('Error in hideFolderItems');
363: edw_log.put_line('pBusAreaID = '||pBusAreaID);
364: edw_log.put_line('pTableName = '||pTableName);
365: edw_log.put_line('pViewName = '||pViewName);
366: edw_log.put_line('pColumn LIKE '||pColumn);
367: edw_log.put_line('l_stmt '||l_stmt);
368: end if;
369:
370: g_errbuf:=sqlerrm;

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

363: edw_log.put_line('pBusAreaID = '||pBusAreaID);
364: edw_log.put_line('pTableName = '||pTableName);
365: edw_log.put_line('pViewName = '||pViewName);
366: edw_log.put_line('pColumn LIKE '||pColumn);
367: edw_log.put_line('l_stmt '||l_stmt);
368: end if;
369:
370: g_errbuf:=sqlerrm;
371: g_retcode:=sqlcode;

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

406: 'FROM '||g_EulOwner||'.EUL_BUSINESS_AREAS ba '||
407: 'WHERE ba.ba_name = '''||pBusAreaName||'''';
408:
409: if g_debug_flag = 'Y' then
410: edw_log.debug_line('Procedure initBusAreas');
411: edw_log.debug_line('Going to execute statement:');
412: edw_log.debug_line(l_stmt);
413: end if;
414:

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

407: 'WHERE ba.ba_name = '''||pBusAreaName||'''';
408:
409: if g_debug_flag = 'Y' then
410: edw_log.debug_line('Procedure initBusAreas');
411: edw_log.debug_line('Going to execute statement:');
412: edw_log.debug_line(l_stmt);
413: end if;
414:
415:

Line 412: edw_log.debug_line(l_stmt);

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

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

468: 'ORDER BY folder_items.IT_EXT_COLUMN, '||
469: ' folder_items.exp_id';
470:
471: if g_debug_flag = 'Y' then
472: edw_log.debug_line('Procedure initColumns');
473: edw_log.debug_line('Going to execute statement:');
474: edw_log.debug_line(l_stmt);
475: end if;
476:

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

469: ' folder_items.exp_id';
470:
471: if g_debug_flag = 'Y' then
472: edw_log.debug_line('Procedure initColumns');
473: edw_log.debug_line('Going to execute statement:');
474: edw_log.debug_line(l_stmt);
475: end if;
476:
477: OPEN eulCol_cv FOR l_stmt;

Line 474: edw_log.debug_line(l_stmt);

470:
471: if g_debug_flag = 'Y' then
472: edw_log.debug_line('Procedure initColumns');
473: edw_log.debug_line('Going to execute statement:');
474: edw_log.debug_line(l_stmt);
475: end if;
476:
477: OPEN eulCol_cv FOR l_stmt;
478: LOOP

Line 499: edw_log.put_line('');

495:
496: EXCEPTION
497: WHEN OTHERS THEN
498: if g_debug_flag = 'Y' then
499: edw_log.put_line('');
500: edw_log.put_line('Error in initColumns');
501: edw_log.put_line('pBusAreaName = '||pBusAreaName);
502: edw_log.put_line('pTableName = '||pTableName);
503: edw_log.put_line('l_stmt '||l_stmt);

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

496: EXCEPTION
497: WHEN OTHERS THEN
498: if g_debug_flag = 'Y' then
499: edw_log.put_line('');
500: edw_log.put_line('Error in initColumns');
501: edw_log.put_line('pBusAreaName = '||pBusAreaName);
502: edw_log.put_line('pTableName = '||pTableName);
503: edw_log.put_line('l_stmt '||l_stmt);
504: end if;

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

497: WHEN OTHERS THEN
498: if g_debug_flag = 'Y' then
499: edw_log.put_line('');
500: edw_log.put_line('Error in initColumns');
501: edw_log.put_line('pBusAreaName = '||pBusAreaName);
502: edw_log.put_line('pTableName = '||pTableName);
503: edw_log.put_line('l_stmt '||l_stmt);
504: end if;
505:

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

498: if g_debug_flag = 'Y' then
499: edw_log.put_line('');
500: edw_log.put_line('Error in initColumns');
501: edw_log.put_line('pBusAreaName = '||pBusAreaName);
502: edw_log.put_line('pTableName = '||pTableName);
503: edw_log.put_line('l_stmt '||l_stmt);
504: end if;
505:
506: g_errbuf:=sqlerrm;

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

499: edw_log.put_line('');
500: edw_log.put_line('Error in initColumns');
501: edw_log.put_line('pBusAreaName = '||pBusAreaName);
502: edw_log.put_line('pTableName = '||pTableName);
503: edw_log.put_line('l_stmt '||l_stmt);
504: end if;
505:
506: g_errbuf:=sqlerrm;
507: g_retcode:=sqlcode;

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

564:
565:
566:
567: if g_debug_flag = 'Y' then
568: edw_log.debug_line('Procedure initTables');
569: edw_log.debug_line('Going to execute statement:');
570: edw_log.debug_line(l_stmt);
571: end if;
572:

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

565:
566:
567: if g_debug_flag = 'Y' then
568: edw_log.debug_line('Procedure initTables');
569: edw_log.debug_line('Going to execute statement:');
570: edw_log.debug_line(l_stmt);
571: end if;
572:
573:

Line 570: edw_log.debug_line(l_stmt);

566:
567: if g_debug_flag = 'Y' then
568: edw_log.debug_line('Procedure initTables');
569: edw_log.debug_line('Going to execute statement:');
570: edw_log.debug_line(l_stmt);
571: end if;
572:
573:
574: -- eulTablesTab.delete;

Line 594: edw_log.put_line('');

590:
591: EXCEPTION
592: WHEN OTHERS THEN
593: if g_debug_flag = 'Y' then
594: edw_log.put_line('');
595: edw_log.put_line('Error in initTables');
596: edw_log.put_line('pBusAreaName = '||pBusAreaName);
597: edw_log.put_line('l_stmt '||l_stmt);
598: end if;

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

591: EXCEPTION
592: WHEN OTHERS THEN
593: if g_debug_flag = 'Y' then
594: edw_log.put_line('');
595: edw_log.put_line('Error in initTables');
596: edw_log.put_line('pBusAreaName = '||pBusAreaName);
597: edw_log.put_line('l_stmt '||l_stmt);
598: end if;
599:

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

592: WHEN OTHERS THEN
593: if g_debug_flag = 'Y' then
594: edw_log.put_line('');
595: edw_log.put_line('Error in initTables');
596: edw_log.put_line('pBusAreaName = '||pBusAreaName);
597: edw_log.put_line('l_stmt '||l_stmt);
598: end if;
599:
600: g_errbuf:=sqlerrm;

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

593: if g_debug_flag = 'Y' then
594: edw_log.put_line('');
595: edw_log.put_line('Error in initTables');
596: edw_log.put_line('pBusAreaName = '||pBusAreaName);
597: edw_log.put_line('l_stmt '||l_stmt);
598: end if;
599:
600: g_errbuf:=sqlerrm;
601: g_retcode:=sqlcode;

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

624:
625: IF g_Mode <> 'TEST' THEN
626:
627: if g_debug_flag = 'Y' then
628: edw_log.debug_line('Procedure hideFolders');
629: edw_log.debug_line('Going to execute statement:');
630: edw_log.debug_line(l_stmt);
631: end if;
632:

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

625: IF g_Mode <> 'TEST' THEN
626:
627: if g_debug_flag = 'Y' then
628: edw_log.debug_line('Procedure hideFolders');
629: edw_log.debug_line('Going to execute statement:');
630: edw_log.debug_line(l_stmt);
631: end if;
632:
633: EXECUTE IMMEDIATE l_stmt;

Line 630: edw_log.debug_line(l_stmt);

626:
627: if g_debug_flag = 'Y' then
628: edw_log.debug_line('Procedure hideFolders');
629: edw_log.debug_line('Going to execute statement:');
630: edw_log.debug_line(l_stmt);
631: end if;
632:
633: EXECUTE IMMEDIATE l_stmt;
634:

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

669: 'AND obj.obj_id = bol.bol_obj_id '||
670: 'AND oBj.sobj_ext_table IN ('''||pTableName||''' ,'''||pViewName||''') ';
671:
672: if g_debug_flag = 'Y' then
673: edw_log.debug_line('Procedure hideFolders');
674: edw_log.debug_line('Going to execute statement:');
675: edw_log.debug_line(l_stmt);
676: end if;
677:

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

670: 'AND oBj.sobj_ext_table IN ('''||pTableName||''' ,'''||pViewName||''') ';
671:
672: if g_debug_flag = 'Y' then
673: edw_log.debug_line('Procedure hideFolders');
674: edw_log.debug_line('Going to execute statement:');
675: edw_log.debug_line(l_stmt);
676: end if;
677:
678:

Line 675: edw_log.debug_line(l_stmt);

671:
672: if g_debug_flag = 'Y' then
673: edw_log.debug_line('Procedure hideFolders');
674: edw_log.debug_line('Going to execute statement:');
675: edw_log.debug_line(l_stmt);
676: end if;
677:
678:
679: OPEN eulFolder_cv FOR l_Stmt;

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

785: ' DECODE(MAX(DECODE(H414_NAME , H415_NAME , 0, 1)),0,'',H414'',NULL),'','') '||
786: 'FROM '||pDimTableName;
787:
788: if g_debug_flag = 'Y' then
789: edw_log.debug_line('Procedure hideEulDimLevels');
790: edw_log.debug_line('Going to execute statement:');
791: edw_log.debug_line(l_stmt);
792: end if;
793:

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

786: 'FROM '||pDimTableName;
787:
788: if g_debug_flag = 'Y' then
789: edw_log.debug_line('Procedure hideEulDimLevels');
790: edw_log.debug_line('Going to execute statement:');
791: edw_log.debug_line(l_stmt);
792: end if;
793:
794: EXECUTE IMMEDIATE l_stmt INTO levelStr;

Line 791: edw_log.debug_line(l_stmt);

787:
788: if g_debug_flag = 'Y' then
789: edw_log.debug_line('Procedure hideEulDimLevels');
790: edw_log.debug_line('Going to execute statement:');
791: edw_log.debug_line(l_stmt);
792: end if;
793:
794: EXECUTE IMMEDIATE l_stmt INTO levelStr;
795:

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

809: WHEN GL_FLEX_DIM_TAB_NF
810: THEN
811:
812: if g_debug_flag = 'Y' then
813: edw_log.put_line('GL Flex Dimension Tables not found in '||g_fiischema||' schema');
814: end if;
815:
816: WHEN OTHERS THEN
817:

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

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

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

866: 'FROM '||dimTab(ctr).table_name;
867:
868: if g_debug_flag = 'Y' then
869: edw_log.debug_line('Procedure eulGLFlexDimMaint');
870: edw_log.debug_line('Going to execute statement:');
871: edw_log.debug_line(l_stmt);
872: end if;
873:
874:

Line 871: edw_log.debug_line(l_stmt);

867:
868: if g_debug_flag = 'Y' then
869: edw_log.debug_line('Procedure eulGLFlexDimMaint');
870: edw_log.debug_line('Going to execute statement:');
871: edw_log.debug_line(l_stmt);
872: end if;
873:
874:
875: 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 878: edw_log.put_line('Table :'||dimTab(ctr).table_name);

874:
875: 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;
876:
877: if g_debug_flag = 'Y' then
878: edw_log.put_line('Table :'||dimTab(ctr).table_name);
879: -- edw_log.put_line(' View :'||dimTab(ctr).view_name);
880: edw_log.put_line(' Rows :'||dimTab(ctr).rowcnt);
881: edw_log.put_line(' Table Status :'||dimTab(ctr).table_status);
882: edw_log.put_line(' Hier 1 Status :'||dimTab(ctr).hier1_status);

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

875: 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;
876:
877: if g_debug_flag = 'Y' then
878: edw_log.put_line('Table :'||dimTab(ctr).table_name);
879: -- edw_log.put_line(' View :'||dimTab(ctr).view_name);
880: edw_log.put_line(' Rows :'||dimTab(ctr).rowcnt);
881: edw_log.put_line(' Table Status :'||dimTab(ctr).table_status);
882: edw_log.put_line(' Hier 1 Status :'||dimTab(ctr).hier1_status);
883: edw_log.put_line(' Hier 2 Status :'||dimTab(ctr).hier2_status);

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

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

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

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

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

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

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

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

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

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

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

881: edw_log.put_line(' Table Status :'||dimTab(ctr).table_status);
882: edw_log.put_line(' Hier 1 Status :'||dimTab(ctr).hier1_status);
883: edw_log.put_line(' Hier 2 Status :'||dimTab(ctr).hier2_status);
884: edw_log.put_line(' Hier 3 Status :'||dimTab(ctr).hier3_status);
885: edw_log.put_line(' Hier 4 Status :'||dimTab(ctr).hier4_status);
886: edw_log.put_line('');
887: end if;
888:
889:

Line 886: edw_log.put_line('');

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

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

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

Line 967: edw_log.put_line('');

963: end if;
964:
965: WHEN OTHERS THEN
966: if g_debug_flag = 'Y' then
967: edw_log.put_line('');
968: edw_log.put_line('Error in eulGLFlexDimMaint '||eulBusAreaTab(ba_ctr).ba_name);
969: edw_log.put_line('dimTab(ctr).table_status = '||dimTab(ctr).table_status);
970: edw_log.put_line('ctr = '||ctr);
971: edw_log.put_line('Table :'||dimTab(ctr).table_name);

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

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

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

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

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

966: if g_debug_flag = 'Y' then
967: edw_log.put_line('');
968: edw_log.put_line('Error in eulGLFlexDimMaint '||eulBusAreaTab(ba_ctr).ba_name);
969: edw_log.put_line('dimTab(ctr).table_status = '||dimTab(ctr).table_status);
970: edw_log.put_line('ctr = '||ctr);
971: edw_log.put_line('Table :'||dimTab(ctr).table_name);
972: -- edw_log.put_line(' View :'||dimTab(ctr).view_name);
973: edw_log.put_line(' Rows :'||dimTab(ctr).rowcnt);
974: edw_log.put_line(' Table Status :'||dimTab(ctr).table_status);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 979: edw_log.put_line('');

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

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

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

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

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

Line 1072: edw_log.debug_line(l_stmt);

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

Line 1111: edw_log.put_line('');

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

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

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

Line 1113: edw_log.put_line('');

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

Line 1147: edw_log.put_line('Alternative sort procedure is started...');

1143:
1144: BEGIN
1145:
1146: if g_debug_flag = 'Y' then
1147: edw_log.put_line('Alternative sort procedure is started...');
1148: end if;
1149:
1150: sql_stmt_ba := 'SELECT DISTINCT ba_id
1151: FROM '||pEulOwnerName||'.eul4_bas

Line 1249: edw_log.put_line('Business area :'||v_ba_id);

1245: WHERE exp_id = :7';
1246: EXECUTE IMMEDIATE sql_stmt_expr USING v_dom_id, v_sort_id;
1247:
1248: if g_debug_flag = 'Y' then
1249: edw_log.put_line('Business area :'||v_ba_id);
1250: edw_log.put_line('EUL Name :'||pEulOwnerName);
1251: edw_log.put_line('Obj_ID :'||v_obj_id);
1252: edw_log.put_line('Domain_ID :'||v_dom_id);
1253: edw_log.put_line('Column_to_sort :'||v_column_sorted);

Line 1250: edw_log.put_line('EUL Name :'||pEulOwnerName);

1246: EXECUTE IMMEDIATE sql_stmt_expr USING v_dom_id, v_sort_id;
1247:
1248: if g_debug_flag = 'Y' then
1249: edw_log.put_line('Business area :'||v_ba_id);
1250: edw_log.put_line('EUL Name :'||pEulOwnerName);
1251: edw_log.put_line('Obj_ID :'||v_obj_id);
1252: edw_log.put_line('Domain_ID :'||v_dom_id);
1253: edw_log.put_line('Column_to_sort :'||v_column_sorted);
1254: edw_log.put_line('Sort_by_column :'||v_column_sort);

Line 1251: edw_log.put_line('Obj_ID :'||v_obj_id);

1247:
1248: if g_debug_flag = 'Y' then
1249: edw_log.put_line('Business area :'||v_ba_id);
1250: edw_log.put_line('EUL Name :'||pEulOwnerName);
1251: edw_log.put_line('Obj_ID :'||v_obj_id);
1252: edw_log.put_line('Domain_ID :'||v_dom_id);
1253: edw_log.put_line('Column_to_sort :'||v_column_sorted);
1254: edw_log.put_line('Sort_by_column :'||v_column_sort);
1255: edw_log.put_line('*********************************');

Line 1252: edw_log.put_line('Domain_ID :'||v_dom_id);

1248: if g_debug_flag = 'Y' then
1249: edw_log.put_line('Business area :'||v_ba_id);
1250: edw_log.put_line('EUL Name :'||pEulOwnerName);
1251: edw_log.put_line('Obj_ID :'||v_obj_id);
1252: edw_log.put_line('Domain_ID :'||v_dom_id);
1253: edw_log.put_line('Column_to_sort :'||v_column_sorted);
1254: edw_log.put_line('Sort_by_column :'||v_column_sort);
1255: edw_log.put_line('*********************************');
1256: end if;

Line 1253: edw_log.put_line('Column_to_sort :'||v_column_sorted);

1249: edw_log.put_line('Business area :'||v_ba_id);
1250: edw_log.put_line('EUL Name :'||pEulOwnerName);
1251: edw_log.put_line('Obj_ID :'||v_obj_id);
1252: edw_log.put_line('Domain_ID :'||v_dom_id);
1253: edw_log.put_line('Column_to_sort :'||v_column_sorted);
1254: edw_log.put_line('Sort_by_column :'||v_column_sort);
1255: edw_log.put_line('*********************************');
1256: end if;
1257:

Line 1254: edw_log.put_line('Sort_by_column :'||v_column_sort);

1250: edw_log.put_line('EUL Name :'||pEulOwnerName);
1251: edw_log.put_line('Obj_ID :'||v_obj_id);
1252: edw_log.put_line('Domain_ID :'||v_dom_id);
1253: edw_log.put_line('Column_to_sort :'||v_column_sorted);
1254: edw_log.put_line('Sort_by_column :'||v_column_sort);
1255: edw_log.put_line('*********************************');
1256: end if;
1257:
1258: COMMIT;

Line 1255: edw_log.put_line('*********************************');

1251: edw_log.put_line('Obj_ID :'||v_obj_id);
1252: edw_log.put_line('Domain_ID :'||v_dom_id);
1253: edw_log.put_line('Column_to_sort :'||v_column_sorted);
1254: edw_log.put_line('Sort_by_column :'||v_column_sort);
1255: edw_log.put_line('*********************************');
1256: end if;
1257:
1258: COMMIT;
1259: END LOOP;

Line 1267: edw_log.put_line('Alternative sort procedure is completed');

1263:
1264: CLOSE r_business_area;
1265:
1266: if g_debug_flag = 'Y' then
1267: edw_log.put_line('Alternative sort procedure is completed');
1268: edw_log.put_line('***************************************');
1269: end if;
1270:
1271:

Line 1268: edw_log.put_line('***************************************');

1264: CLOSE r_business_area;
1265:
1266: if g_debug_flag = 'Y' then
1267: edw_log.put_line('Alternative sort procedure is completed');
1268: edw_log.put_line('***************************************');
1269: end if;
1270:
1271:
1272: END;

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

1376: IF eulColumnsTab(ctr).item_data_type = 2 AND
1377: eulColumnsTab(ctr).table_type = 'F' THEN
1378:
1379: /*
1380: edw_log.put_line('Item Name '||eulColumnsTab(ctr).item_name);
1381: edw_log.put_line('Item Heading '||eulColumnsTab(ctr).item_heading);
1382: edw_log.put_line('Item Format '||eulColumnsTab(ctr).item_format_mask);
1383: */
1384: l_stmt := 'UPDATE '||g_EulOwner||'.eul_expressions '||

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

1377: eulColumnsTab(ctr).table_type = 'F' THEN
1378:
1379: /*
1380: edw_log.put_line('Item Name '||eulColumnsTab(ctr).item_name);
1381: edw_log.put_line('Item Heading '||eulColumnsTab(ctr).item_heading);
1382: edw_log.put_line('Item Format '||eulColumnsTab(ctr).item_format_mask);
1383: */
1384: l_stmt := 'UPDATE '||g_EulOwner||'.eul_expressions '||
1385: 'SET it_heading = NVL(it_heading,exp_name) , '||

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

1378:
1379: /*
1380: edw_log.put_line('Item Name '||eulColumnsTab(ctr).item_name);
1381: edw_log.put_line('Item Heading '||eulColumnsTab(ctr).item_heading);
1382: edw_log.put_line('Item Format '||eulColumnsTab(ctr).item_format_mask);
1383: */
1384: l_stmt := 'UPDATE '||g_EulOwner||'.eul_expressions '||
1385: 'SET it_heading = NVL(it_heading,exp_name) , '||
1386: ' ite_format_mask = NVL(ite_format_mask , ''999G999G999G999'') '||

Line 1441: edw_log.put_line('');

1437: ba_ctr := eulBusAreaTab.first;
1438:
1439: FOR ba IN 1..eulBusAreaTab.count LOOP
1440: if g_debug_flag = 'Y' then
1441: edw_log.put_line('');
1442: edw_log.put_line(eulBusAreaTab(ba_ctr).ba_name);
1443: edw_log.put_line('');
1444: edw_log.put_line(' '||RPAD('Table Name',30,' ')||' '||'Folder Name');
1445: edw_log.put_line(' '||RPAD('-',30,'-')||' '||RPAD('-',30,'-'));

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

1438:
1439: FOR ba IN 1..eulBusAreaTab.count LOOP
1440: if g_debug_flag = 'Y' then
1441: edw_log.put_line('');
1442: edw_log.put_line(eulBusAreaTab(ba_ctr).ba_name);
1443: edw_log.put_line('');
1444: edw_log.put_line(' '||RPAD('Table Name',30,' ')||' '||'Folder Name');
1445: edw_log.put_line(' '||RPAD('-',30,'-')||' '||RPAD('-',30,'-'));
1446: end if;

Line 1443: edw_log.put_line('');

1439: FOR ba IN 1..eulBusAreaTab.count LOOP
1440: if g_debug_flag = 'Y' then
1441: edw_log.put_line('');
1442: edw_log.put_line(eulBusAreaTab(ba_ctr).ba_name);
1443: edw_log.put_line('');
1444: edw_log.put_line(' '||RPAD('Table Name',30,' ')||' '||'Folder Name');
1445: edw_log.put_line(' '||RPAD('-',30,'-')||' '||RPAD('-',30,'-'));
1446: end if;
1447:

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

1440: if g_debug_flag = 'Y' then
1441: edw_log.put_line('');
1442: edw_log.put_line(eulBusAreaTab(ba_ctr).ba_name);
1443: edw_log.put_line('');
1444: edw_log.put_line(' '||RPAD('Table Name',30,' ')||' '||'Folder Name');
1445: edw_log.put_line(' '||RPAD('-',30,'-')||' '||RPAD('-',30,'-'));
1446: end if;
1447:
1448: tab_ctr := eulTablesTab.first;

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

1441: edw_log.put_line('');
1442: edw_log.put_line(eulBusAreaTab(ba_ctr).ba_name);
1443: edw_log.put_line('');
1444: edw_log.put_line(' '||RPAD('Table Name',30,' ')||' '||'Folder Name');
1445: edw_log.put_line(' '||RPAD('-',30,'-')||' '||RPAD('-',30,'-'));
1446: end if;
1447:
1448: tab_ctr := eulTablesTab.first;
1449:

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

1450: FOR tab IN 1..eulTablesTab.count LOOP
1451:
1452: IF eulTablesTab(tab_ctr).bus_area_id = eulBusAreaTab(ba_ctr).ba_id THEN
1453: if g_debug_flag = 'Y' then
1454: edw_log.PUT_LINE(' '||RPAD(eulTablesTab(tab_ctr).table_name,30,' ')||' '||eulTablesTab(tab_ctr).folder_name);
1455: end if;
1456:
1457: IF eulTablesTab(tab_ctr).hidden_item_flag = 'Y' AND eulTablesTab(tab_ctr).folder_sb_hidden = 0 THEN
1458: if g_debug_flag = 'Y' then

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

1455: end if;
1456:
1457: IF eulTablesTab(tab_ctr).hidden_item_flag = 'Y' AND eulTablesTab(tab_ctr).folder_sb_hidden = 0 THEN
1458: if g_debug_flag = 'Y' then
1459: edw_log.put_line(' '||RPAD('Column Name',30,' ')||' '||'Change '||' '||'Item Name');
1460: edw_log.put_line(' '||RPAD('-',30,'-')||' '||RPAD('-',30,'-'));
1461: end if;
1462:
1463: col_ctr := eulColumnsTab.first;

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

1456:
1457: IF eulTablesTab(tab_ctr).hidden_item_flag = 'Y' AND eulTablesTab(tab_ctr).folder_sb_hidden = 0 THEN
1458: if g_debug_flag = 'Y' then
1459: edw_log.put_line(' '||RPAD('Column Name',30,' ')||' '||'Change '||' '||'Item Name');
1460: edw_log.put_line(' '||RPAD('-',30,'-')||' '||RPAD('-',30,'-'));
1461: end if;
1462:
1463: col_ctr := eulColumnsTab.first;
1464:

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

1468:
1469: IF eulColumnsTab(col_ctr).item_sb_hidden = 1 AND
1470: eulColumnsTab(col_ctr).item_hidden = 0 THEN
1471: if g_debug_flag = 'Y' then
1472: edw_log.put_line(' '||RPAD(eulColumnsTab(col_ctr).column_name,30,' ')||' '||'Hide '||' '||eulColumnsTab(col_ctr).item_name);
1473: end if;
1474:
1475: ELSIF eulColumnsTab(col_ctr).item_sb_hidden = 0 AND
1476: eulColumnsTab(col_ctr).item_hidden = 1 THEN

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

1474:
1475: ELSIF eulColumnsTab(col_ctr).item_sb_hidden = 0 AND
1476: eulColumnsTab(col_ctr).item_hidden = 1 THEN
1477: if g_debug_flag = 'Y' then
1478: edw_log.put_line(' '||RPAD(eulColumnsTab(col_ctr).column_name,30,' ')||' '||'Display'||' '||eulColumnsTab(col_ctr).item_name);
1479: end if;
1480:
1481: ELSE
1482:

Line 1494: edw_log.put_line(' ');

1490:
1491: END LOOP;
1492:
1493: if g_debug_flag = 'Y' then
1494: edw_log.put_line(' ');
1495: end if;
1496:
1497: END IF;
1498:

Line 1506: edw_log.put_line(' ');

1502:
1503: END LOOP;
1504:
1505: if g_debug_flag = 'Y' then
1506: edw_log.put_line(' ');
1507: end if;
1508: ba_ctr := eulBusAreaTab.next(ba_ctr);
1509:
1510: END LOOP;

Line 1517: edw_log.put_line('');

1513:
1514: FOR ba IN 1..eulBusAreaTab.count LOOP
1515:
1516: if g_debug_flag = 'Y' then
1517: edw_log.put_line('');
1518: edw_log.put_line(eulBusAreaTab(ba_ctr).ba_name||' - ');
1519: edw_log.put_line('Items Evaluated:'||eulBusAreaTab(ba_ctr).ba_records_evaluated);
1520: edw_log.put_line('Items Hidden:'||eulBusAreaTab(ba_ctr).ba_records_hidden);
1521: end if;

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

1514: FOR ba IN 1..eulBusAreaTab.count LOOP
1515:
1516: if g_debug_flag = 'Y' then
1517: edw_log.put_line('');
1518: edw_log.put_line(eulBusAreaTab(ba_ctr).ba_name||' - ');
1519: edw_log.put_line('Items Evaluated:'||eulBusAreaTab(ba_ctr).ba_records_evaluated);
1520: edw_log.put_line('Items Hidden:'||eulBusAreaTab(ba_ctr).ba_records_hidden);
1521: end if;
1522:

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

1515:
1516: if g_debug_flag = 'Y' then
1517: edw_log.put_line('');
1518: edw_log.put_line(eulBusAreaTab(ba_ctr).ba_name||' - ');
1519: edw_log.put_line('Items Evaluated:'||eulBusAreaTab(ba_ctr).ba_records_evaluated);
1520: edw_log.put_line('Items Hidden:'||eulBusAreaTab(ba_ctr).ba_records_hidden);
1521: end if;
1522:
1523: ba_ctr := eulBusAreaTab.next(ba_ctr);

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

1516: if g_debug_flag = 'Y' then
1517: edw_log.put_line('');
1518: edw_log.put_line(eulBusAreaTab(ba_ctr).ba_name||' - ');
1519: edw_log.put_line('Items Evaluated:'||eulBusAreaTab(ba_ctr).ba_records_evaluated);
1520: edw_log.put_line('Items Hidden:'||eulBusAreaTab(ba_ctr).ba_records_hidden);
1521: end if;
1522:
1523: ba_ctr := eulBusAreaTab.next(ba_ctr);
1524:

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

1524:
1525: END LOOP;
1526:
1527: if g_debug_flag = 'Y' then
1528: edw_log.put_line(eulColumnsTab.count||' Items Evaluated');
1529: edw_log.put_line(lFactChangeCtr||' Fact Items Hidden');
1530: edw_log.put_line(lDimChangeCtr||' Dimension Items Hidden');
1531: end if;
1532:

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

1525: END LOOP;
1526:
1527: if g_debug_flag = 'Y' then
1528: edw_log.put_line(eulColumnsTab.count||' Items Evaluated');
1529: edw_log.put_line(lFactChangeCtr||' Fact Items Hidden');
1530: edw_log.put_line(lDimChangeCtr||' Dimension Items Hidden');
1531: end if;
1532:
1533: COMMIT;

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

1526:
1527: if g_debug_flag = 'Y' then
1528: edw_log.put_line(eulColumnsTab.count||' Items Evaluated');
1529: edw_log.put_line(lFactChangeCtr||' Fact Items Hidden');
1530: edw_log.put_line(lDimChangeCtr||' Dimension Items Hidden');
1531: end if;
1532:
1533: COMMIT;
1534:

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

1544: Errbuf := g_errbuf;
1545: Retcode := g_retcode;
1546: l_exception_msg := Retcode || ':' || Errbuf;
1547: if g_debug_flag = 'Y' then
1548: edw_log.put_line('Business Area Name not found');
1549: edw_log.put_line('Process : '||g_processName);
1550: end if;
1551: raise;
1552:

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

1545: Retcode := g_retcode;
1546: l_exception_msg := Retcode || ':' || Errbuf;
1547: if g_debug_flag = 'Y' then
1548: edw_log.put_line('Business Area Name not found');
1549: edw_log.put_line('Process : '||g_processName);
1550: end if;
1551: raise;
1552:
1553: WHEN G_EUL_OWNER_DOES_NOT_EXIST THEN

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

1554: Errbuf:=g_errbuf;
1555: Retcode:=g_retcode;
1556: l_exception_msg := Retcode || ':' || Errbuf;
1557: if g_debug_flag = 'Y' then
1558: edw_log.put_line('End User Layer (EUL) Owner not found');
1559: edw_log.put_line('Process : '||g_processName);
1560: end if;
1561: raise;
1562:

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

1555: Retcode:=g_retcode;
1556: l_exception_msg := Retcode || ':' || Errbuf;
1557: if g_debug_flag = 'Y' then
1558: edw_log.put_line('End User Layer (EUL) Owner not found');
1559: edw_log.put_line('Process : '||g_processName);
1560: end if;
1561: raise;
1562:
1563: WHEN OTHERS THEN

Line 1568: edw_log.put_line(l_exception_msg);

1564: Errbuf:=g_errbuf;
1565: Retcode:=g_retcode;
1566: l_exception_msg := Retcode || ':' || Errbuf;
1567: if g_debug_flag = 'Y' then
1568: edw_log.put_line(l_exception_msg);
1569: edw_log.put_line('pAction'||pAction);
1570: edw_log.put_line('pEulOwnerName'||g_EulOwner);
1571: edw_log.put_line('pBusAreaName'||pBusAreaName);
1572: edw_log.put_line('pMode'||g_mode);

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

1565: Retcode:=g_retcode;
1566: l_exception_msg := Retcode || ':' || Errbuf;
1567: if g_debug_flag = 'Y' then
1568: edw_log.put_line(l_exception_msg);
1569: edw_log.put_line('pAction'||pAction);
1570: edw_log.put_line('pEulOwnerName'||g_EulOwner);
1571: edw_log.put_line('pBusAreaName'||pBusAreaName);
1572: edw_log.put_line('pMode'||g_mode);
1573: edw_log.put_line('Process : '||g_processName);

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

1566: l_exception_msg := Retcode || ':' || Errbuf;
1567: if g_debug_flag = 'Y' then
1568: edw_log.put_line(l_exception_msg);
1569: edw_log.put_line('pAction'||pAction);
1570: edw_log.put_line('pEulOwnerName'||g_EulOwner);
1571: edw_log.put_line('pBusAreaName'||pBusAreaName);
1572: edw_log.put_line('pMode'||g_mode);
1573: edw_log.put_line('Process : '||g_processName);
1574: edw_log.put_line('l_stmt : '||l_stmt);

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

1567: if g_debug_flag = 'Y' then
1568: edw_log.put_line(l_exception_msg);
1569: edw_log.put_line('pAction'||pAction);
1570: edw_log.put_line('pEulOwnerName'||g_EulOwner);
1571: edw_log.put_line('pBusAreaName'||pBusAreaName);
1572: edw_log.put_line('pMode'||g_mode);
1573: edw_log.put_line('Process : '||g_processName);
1574: edw_log.put_line('l_stmt : '||l_stmt);
1575: end if;

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

1568: edw_log.put_line(l_exception_msg);
1569: edw_log.put_line('pAction'||pAction);
1570: edw_log.put_line('pEulOwnerName'||g_EulOwner);
1571: edw_log.put_line('pBusAreaName'||pBusAreaName);
1572: edw_log.put_line('pMode'||g_mode);
1573: edw_log.put_line('Process : '||g_processName);
1574: edw_log.put_line('l_stmt : '||l_stmt);
1575: end if;
1576: raise;

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

1569: edw_log.put_line('pAction'||pAction);
1570: edw_log.put_line('pEulOwnerName'||g_EulOwner);
1571: edw_log.put_line('pBusAreaName'||pBusAreaName);
1572: edw_log.put_line('pMode'||g_mode);
1573: edw_log.put_line('Process : '||g_processName);
1574: edw_log.put_line('l_stmt : '||l_stmt);
1575: end if;
1576: raise;
1577:

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

1570: edw_log.put_line('pEulOwnerName'||g_EulOwner);
1571: edw_log.put_line('pBusAreaName'||pBusAreaName);
1572: edw_log.put_line('pMode'||g_mode);
1573: edw_log.put_line('Process : '||g_processName);
1574: edw_log.put_line('l_stmt : '||l_stmt);
1575: end if;
1576: raise;
1577:
1578: END EulMaint;