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_TIME_C dependencies on FII_UTIL

Line 297: fii_util.put_line('TRUNCATE_TABLE : '||l_stmt);

293: begin
294:
295: l_stmt := 'truncate table '||g_schema||'.'||p_table_name;
296: if g_debug_flag = 'Y' then
297: fii_util.put_line('TRUNCATE_TABLE : '||l_stmt);
298: end if;
299: execute immediate l_stmt;
300:
301: exception

Line 340: fii_util.put_line('INIT : '||'Enterprise Calendar = '||g_period_set_name||' ('||g_period_type||')');

336: if (g_all_level = 'Y') then
337: g_period_set_name := bis_common_parameters.get_period_set_name;
338: g_period_type := bis_common_parameters.get_period_type;
339: if g_debug_flag = 'Y' then
340: fii_util.put_line('INIT : '||'Enterprise Calendar = '||g_period_set_name||' ('||g_period_type||')');
341: end if;
342: g_week_start_day := bis_common_parameters.get_start_day_of_week_id;
343: if (g_period_set_name is null or g_period_type is null or g_week_start_day is null) then
344: raise G_BIS_PARAMETER_NOT_SETUP;

Line 348: fii_util.put_line('INIT : '||'Week Start Day = '||g_week_start_day);

344: raise G_BIS_PARAMETER_NOT_SETUP;
345: end if;
346:
347: if g_debug_flag = 'Y' then
348: fii_util.put_line('INIT : '||'Week Start Day = '||g_week_start_day);
349: end if;
350: g_week_offset := get_week_offset(g_week_start_day);
351: if g_debug_flag = 'Y' then
352: fii_util.put_line('INIT : '||'Week offset = '||g_week_offset);

Line 352: fii_util.put_line('INIT : '||'Week offset = '||g_week_offset);

348: fii_util.put_line('INIT : '||'Week Start Day = '||g_week_start_day);
349: end if;
350: g_week_offset := get_week_offset(g_week_start_day);
351: if g_debug_flag = 'Y' then
352: fii_util.put_line('INIT : '||'Week offset = '||g_week_offset);
353: fii_util.put_line(' ');
354: end if;
355:
356: g_global_start_date := bis_common_parameters.get_GLOBAL_START_DATE;

Line 353: fii_util.put_line(' ');

349: end if;
350: g_week_offset := get_week_offset(g_week_start_day);
351: if g_debug_flag = 'Y' then
352: fii_util.put_line('INIT : '||'Week offset = '||g_week_offset);
353: fii_util.put_line(' ');
354: end if;
355:
356: g_global_start_date := bis_common_parameters.get_GLOBAL_START_DATE;
357: if (g_global_start_date is null) then

Line 361: fii_util.put_line('INIT : '||'Global Start Date = ' ||

357: if (g_global_start_date is null) then
358: raise G_BIS_PARAMETER_NOT_SETUP;
359: end if;
360: if g_debug_flag = 'Y' then
361: fii_util.put_line('INIT : '||'Global Start Date = ' ||
362: fnd_date.date_to_displaydate(g_global_start_date));
363: fii_util.put_line(' ');
364: end if;
365: end if;

Line 363: fii_util.put_line(' ');

359: end if;
360: if g_debug_flag = 'Y' then
361: fii_util.put_line('INIT : '||'Global Start Date = ' ||
362: fnd_date.date_to_displaydate(g_global_start_date));
363: fii_util.put_line(' ');
364: end if;
365: end if;
366:
367: end INIT;

Line 607: fii_util.put_line('LOAD_DAY_INC : '||to_char(l_day_row)||' records has been populated or updated to Day Level');

603:
604: commit;
605:
606: if g_debug_flag = 'Y' then
607: fii_util.put_line('LOAD_DAY_INC : '||to_char(l_day_row)||' records has been populated or updated to Day Level');
608: end if;
609:
610: g_day_row_cnt := l_day_row;
611:

Line 731: fii_util.put_line('LOAD_DAY : '||to_char(l_day_row)||' records has been populated to Day Level');

727:
728: commit;
729:
730: if g_debug_flag = 'Y' then
731: fii_util.put_line('LOAD_DAY : '||to_char(l_day_row)||' records has been populated to Day Level');
732: end if;
733:
734: end LOAD_DAY;
735: */

Line 841: fii_util.put_line('LOAD_MONTH : '||to_char(l_month_row)||' records has been populated to Month Level');

837: end loop;
838: commit;
839:
840: if g_debug_Flag = 'Y' then
841: fii_util.put_line('LOAD_MONTH : '||to_char(l_month_row)||' records has been populated to Month Level');
842: end if;
843:
844: end LOAD_MONTH;
845:

Line 948: fii_util.put_line('LOAD_QUARTER : '||to_char(l_qtr_row)||' records has been populated to Quarter Level');

944: end loop;
945: commit;
946:
947: if g_debug_flag = 'Y' then
948: fii_util.put_line('LOAD_QUARTER : '||to_char(l_qtr_row)||' records has been populated to Quarter Level');
949: end if;
950:
951: end LOAD_QUARTER;
952:

Line 1053: fii_util.put_line('LOAD_YEAR : '||to_char(l_year_row)||' records has been populated to Year Level');

1049: end loop;
1050: commit;
1051:
1052: if g_debug_flag = 'Y' then
1053: fii_util.put_line('LOAD_YEAR : '||to_char(l_year_row)||' records has been populated to Year Level');
1054: end if;
1055:
1056: end LOAD_YEAR;
1057:

Line 1165: fii_util.put_line('LOAD_WEEK : '||to_char(l_week_row)||' records has been populated to Week Level');

1161: end loop;
1162:
1163: commit;
1164: if g_debug_flag = 'Y' then
1165: fii_util.put_line('LOAD_WEEK : '||to_char(l_week_row)||' records has been populated to Week Level');
1166: end if;
1167:
1168: -- Bug 5624487
1169: update fii_time_day

Line 1321: fii_util.put_line('LOAD_PERIOD_445 : '||to_char(l_period_row)||' records has been populated to Period 445 Level');

1317:
1318: commit;
1319:
1320: if g_debug_flag = 'Y' then
1321: fii_util.put_line('LOAD_PERIOD_445 : '||to_char(l_period_row)||' records has been populated to Period 445 Level');
1322: end if;
1323:
1324: end LOAD_PERIOD_445;
1325:

Line 1447: fii_util.put_line('LOAD_YEAR_445 : '||to_char(l_year_row)||' records has been populated to Year 445 Level');

1443:
1444: commit;
1445:
1446: if g_debug_flag = 'Y' then
1447: fii_util.put_line('LOAD_YEAR_445 : '||to_char(l_year_row)||' records has been populated to Year 445 Level');
1448: end if;
1449:
1450: end LOAD_YEAR_445;
1451:

Line 1552: fii_util.put_line('LOAD_ENT_PERIOD : '||to_char(l_period_row)||' records has been populated to Enterprise Period Level');

1548:
1549: l_period_row := sql%rowcount;
1550:
1551: if g_debug_flag = 'Y' then
1552: fii_util.put_line('LOAD_ENT_PERIOD : '||to_char(l_period_row)||' records has been populated to Enterprise Period Level');
1553: end if;
1554:
1555:
1556: for i in get_years

Line 1755: fii_util.put_line('LOAD_ENT_QUARTER : '||to_char(l_qtr_row)||' records has been populated to Enterprise Quarter Level');

1751:
1752: commit;
1753:
1754: if g_debug_flag = 'Y' then
1755: fii_util.put_line('LOAD_ENT_QUARTER : '||to_char(l_qtr_row)||' records has been populated to Enterprise Quarter Level');
1756: end if;
1757:
1758: -- Bug 5624487
1759: insert into fii_time_ent_qtr

Line 1908: fii_util.put_line('LOAD_ENT_YEAR : '||to_char(l_year_row)||' records has been populated to Enterprise Year Level');

1904:
1905: commit;
1906:
1907: if g_debug_flag = 'Y' then
1908: fii_util.put_line('LOAD_ENT_YEAR : '||to_char(l_year_row)||' records has been populated to Enterprise Year Level');
1909: end if;
1910:
1911: -- Bug 5624487
1912: insert into fii_time_ent_year

Line 2038: fii_util.put_line('LOAD_CAL_PERIOD : '||to_char(l_period_changed)||' Calendars have changed in GL');

2034: --For Bug 3640141.
2035: l_period_changed := sql%rowcount;
2036:
2037: if g_debug_flag = 'Y' then
2038: fii_util.put_line('LOAD_CAL_PERIOD : '||to_char(l_period_changed)||' Calendars have changed in GL');
2039: end if;
2040:
2041: --For Bug 3543939. If there is a difference then truncate and repopulate FII_TIME_CAL_PERIOD
2042:

Line 2058: fii_util.put_line('LOAD_CAL_PERIOD : '||'0 records has been populated to Financial Period Level');

2054: -- if there are no differences then there is no more work to do
2055: if l_diff_rows = 0 then
2056:
2057: if g_debug_flag = 'Y' then
2058: fii_util.put_line('LOAD_CAL_PERIOD : '||'0 records has been populated to Financial Period Level');
2059: end if;
2060:
2061: return;
2062:

Line 2111: fii_util.put_line('LOAD_CAL_PERIOD : '||to_char(l_period_row)||' records has been populated to Financial Period Level');

2107:
2108: commit;
2109:
2110: if g_debug_flag = 'Y' then
2111: fii_util.put_line('LOAD_CAL_PERIOD : '||to_char(l_period_row)||' records has been populated to Financial Period Level');
2112: end if;
2113:
2114: gather_table_stats('FII_TIME_CAL_PERIOD');
2115:

Line 2117: fii_util.put_line('LOAD_CAL_PERIOD : '||'Gathered statistics for Financial Period Level');

2113:
2114: gather_table_stats('FII_TIME_CAL_PERIOD');
2115:
2116: if g_debug_flag = 'Y' then
2117: fii_util.put_line('LOAD_CAL_PERIOD : '||'Gathered statistics for Financial Period Level');
2118: end if;
2119:
2120: end LOAD_CAL_PERIOD;
2121:

Line 2258: fii_util.put_line('LOAD_CAL_QUARTER : '||'0 records has been populated to Financial Quarter Level');

2254: -- if there are no differences then there is no more work to do
2255: if l_diff_rows = 0 then
2256:
2257: if g_debug_flag = 'Y' then
2258: fii_util.put_line('LOAD_CAL_QUARTER : '||'0 records has been populated to Financial Quarter Level');
2259: end if;
2260:
2261: return;
2262:

Line 2323: fii_util.put_line('LOAD_CAL_QUARTER : '||to_char(l_qtr_row)||' records has been populated to Financial Quarter Level');

2319:
2320: commit;
2321:
2322: if g_debug_flag = 'Y' then
2323: fii_util.put_line('LOAD_CAL_QUARTER : '||to_char(l_qtr_row)||' records has been populated to Financial Quarter Level');
2324: end if;
2325:
2326: gather_table_stats('FII_TIME_CAL_QTR');
2327:

Line 2329: fii_util.put_line('LOAD_CAL_QUARTER : '||'Gathered statistics for Financial Quarter Level');

2325:
2326: gather_table_stats('FII_TIME_CAL_QTR');
2327:
2328: if g_debug_flag = 'Y' then
2329: fii_util.put_line('LOAD_CAL_QUARTER : '||'Gathered statistics for Financial Quarter Level');
2330: end if;
2331:
2332: end LOAD_CAL_QUARTER;
2333:

Line 2454: fii_util.put_line('LOAD_CAL_YEAR : '||'0 records has been populated to Financial Year Level');

2450: -- if there are no differences then there is no more work to do
2451: if l_diff_rows = 0 then
2452:
2453: if g_debug_flag = 'Y' then
2454: fii_util.put_line('LOAD_CAL_YEAR : '||'0 records has been populated to Financial Year Level');
2455: end if;
2456:
2457: return;
2458:

Line 2512: fii_util.put_line('LOAD_CAL_YEAR : '||to_char(l_year_row)||' records has been populated to Financial Year Level');

2508:
2509: commit;
2510:
2511: if g_debug_flag = 'Y' then
2512: fii_util.put_line('LOAD_CAL_YEAR : '||to_char(l_year_row)||' records has been populated to Financial Year Level');
2513: end if;
2514:
2515: gather_table_stats('FII_TIME_CAL_YEAR');
2516:

Line 2518: fii_util.put_line('LOAD_CAL_YEAR : '||'Gathered statistics for Financial Year Level');

2514:
2515: gather_table_stats('FII_TIME_CAL_YEAR');
2516:
2517: if g_debug_flag = 'Y' then
2518: fii_util.put_line('LOAD_CAL_YEAR : '||'Gathered statistics for Financial Year Level');
2519: end if;
2520:
2521: end LOAD_CAL_YEAR;
2522:

Line 2559: l_dir:=FII_UTIL.get_utl_file_dir;

2555: l_year number;
2556: l_start_date date;
2557: begin
2558:
2559: l_dir:=FII_UTIL.get_utl_file_dir;
2560: FII_UTIL.initialize('FII_DBI_TIME_M.log','FII_DBI_TIME_M.out',l_dir, 'FII_DBI_TIME_M');
2561:
2562:
2563: l_from_date := trunc(to_date(p_from_date,'YYYY/MM/DD HH24:MI:SS'));

Line 2560: FII_UTIL.initialize('FII_DBI_TIME_M.log','FII_DBI_TIME_M.out',l_dir, 'FII_DBI_TIME_M');

2556: l_start_date date;
2557: begin
2558:
2559: l_dir:=FII_UTIL.get_utl_file_dir;
2560: FII_UTIL.initialize('FII_DBI_TIME_M.log','FII_DBI_TIME_M.out',l_dir, 'FII_DBI_TIME_M');
2561:
2562:
2563: l_from_date := trunc(to_date(p_from_date,'YYYY/MM/DD HH24:MI:SS'));
2564: l_to_date := trunc(to_date(p_to_date, 'YYYY/MM/DD HH24:MI:SS'));

Line 2569: fii_util.put_line('LOAD : '||'Data loads from ' ||

2565: g_all_level := nvl(p_all_level,'Y');
2566: g_load_mode := p_load_mode;
2567:
2568: if g_debug_flag = 'Y' then
2569: fii_util.put_line('LOAD : '||'Data loads from ' ||
2570: fnd_date.date_to_displaydate(l_from_date) ||
2571: ' to ' ||
2572: fnd_date.date_to_displaydate(l_to_date));
2573: end if;

Line 2615: fii_util.put_line('LOAD : '||'Time Dimension will be validated.');

2611:
2612: if l_validated = 'N' then
2613:
2614: if g_debug_flag = 'Y' then
2615: fii_util.put_line('LOAD : '||'Time Dimension will be validated.');
2616: fii_util.put_line(' ');
2617: end if;
2618:
2619: if l_from_date > g_global_start_date then

Line 2616: fii_util.put_line(' ');

2612: if l_validated = 'N' then
2613:
2614: if g_debug_flag = 'Y' then
2615: fii_util.put_line('LOAD : '||'Time Dimension will be validated.');
2616: fii_util.put_line(' ');
2617: end if;
2618:
2619: if l_from_date > g_global_start_date then
2620: l_from_date := g_global_start_date;

Line 2704: fii_util.put_line('LOAD : '||'Resetting data loads as from ' ||

2700:
2701: if g_debug_flag = 'Y' and
2702: l_from_date <> to_date(p_from_date,'YYYY/MM/DD HH24:MI:SS') or
2703: l_to_date <> to_date(p_to_date,'YYYY/MM/DD HH24:MI:SS') then
2704: fii_util.put_line('LOAD : '||'Resetting data loads as from ' ||
2705: fnd_date.date_to_displaydate(l_from_date) ||
2706: ' to ' ||
2707: fnd_date.date_to_displaydate(l_to_date));
2708: end if;

Line 2715: fii_util.put_line('LOAD : '||'This is an initial load, all tables will be truncated and re-populated.');

2711:
2712: -- if it is initial loading, all the tables will be truncated and re-populated
2713: if p_load_mode = 'INIT' then
2714: if g_debug_flag = 'Y' then
2715: fii_util.put_line('LOAD : '||'This is an initial load, all tables will be truncated and re-populated.');
2716: end if;
2717:
2718: truncate_table('FII_TIME_DAY');
2719: truncate_table('FII_TIME_MONTH');

Line 2740: fii_util.put_line('LOAD : '||'l_validated='||l_validated);

2736: else
2737: -- if it is incremental loading, check if there is any modified period
2738: -- if there is any modified period, do initial load of the enterprise tables
2739: if g_debug_flag = 'Y' then
2740: fii_util.put_line('LOAD : '||'l_validated='||l_validated);
2741: fii_util.put_line('');
2742: end if;
2743: if l_validated = 'Y' then
2744: --truncate_table('FII_TIME_GL_PERIODS');

Line 2741: fii_util.put_line('');

2737: -- if it is incremental loading, check if there is any modified period
2738: -- if there is any modified period, do initial load of the enterprise tables
2739: if g_debug_flag = 'Y' then
2740: fii_util.put_line('LOAD : '||'l_validated='||l_validated);
2741: fii_util.put_line('');
2742: end if;
2743: if l_validated = 'Y' then
2744: --truncate_table('FII_TIME_GL_PERIODS');
2745: --l_period_updated := period_updated(l_min_date, l_max_date);

Line 2747: fii_util.put_line('LOAD : '||'l_period_updated='||l_period_updated);

2743: if l_validated = 'Y' then
2744: --truncate_table('FII_TIME_GL_PERIODS');
2745: --l_period_updated := period_updated(l_min_date, l_max_date);
2746: if g_debug_flag = 'Y' then
2747: fii_util.put_line('LOAD : '||'l_period_updated='||l_period_updated);
2748: fii_util.put_line('');
2749: end if;
2750: if l_period_updated = 'Y' then
2751: truncate_table('FII_TIME_ENT_PERIOD');

Line 2748: fii_util.put_line('');

2744: --truncate_table('FII_TIME_GL_PERIODS');
2745: --l_period_updated := period_updated(l_min_date, l_max_date);
2746: if g_debug_flag = 'Y' then
2747: fii_util.put_line('LOAD : '||'l_period_updated='||l_period_updated);
2748: fii_util.put_line('');
2749: end if;
2750: if l_period_updated = 'Y' then
2751: truncate_table('FII_TIME_ENT_PERIOD');
2752: end if;

Line 2765: fii_util.put_line(' ');

2761: end if;
2762:
2763: g_phase := 'Load Day Level';
2764: if g_debug_flag = 'Y' then
2765: fii_util.put_line(' ');
2766: fii_util.start_timer;
2767: end if;
2768:
2769: -- we compare the latest end date defined in GL and the latest end date in fii_time_day

Line 2766: fii_util.start_timer;

2762:
2763: g_phase := 'Load Day Level';
2764: if g_debug_flag = 'Y' then
2765: fii_util.put_line(' ');
2766: fii_util.start_timer;
2767: end if;
2768:
2769: -- we compare the latest end date defined in GL and the latest end date in fii_time_day
2770: -- to determine if there is new gl period added or not

Line 2802: fii_util.stop_timer;

2798: else
2799: LOAD_DAY_INC(l_from_date, l_to_date); -- incremental refresh
2800: end if;
2801: if g_debug_flag = 'Y' then
2802: fii_util.stop_timer;
2803: fii_util.print_timer('Process Time');
2804: fii_util.put_line(' ');
2805: end if;
2806:

Line 2803: fii_util.print_timer('Process Time');

2799: LOAD_DAY_INC(l_from_date, l_to_date); -- incremental refresh
2800: end if;
2801: if g_debug_flag = 'Y' then
2802: fii_util.stop_timer;
2803: fii_util.print_timer('Process Time');
2804: fii_util.put_line(' ');
2805: end if;
2806:
2807: g_phase := 'Load Month Level';

Line 2804: fii_util.put_line(' ');

2800: end if;
2801: if g_debug_flag = 'Y' then
2802: fii_util.stop_timer;
2803: fii_util.print_timer('Process Time');
2804: fii_util.put_line(' ');
2805: end if;
2806:
2807: g_phase := 'Load Month Level';
2808: if g_debug_flag = 'Y' then

Line 2809: fii_util.start_timer;

2805: end if;
2806:
2807: g_phase := 'Load Month Level';
2808: if g_debug_flag = 'Y' then
2809: fii_util.start_timer;
2810: end if;
2811: LOAD_MONTH(l_from_date, l_to_date);
2812: if g_debug_flag = 'Y' then
2813: fii_util.stop_timer;

Line 2813: fii_util.stop_timer;

2809: fii_util.start_timer;
2810: end if;
2811: LOAD_MONTH(l_from_date, l_to_date);
2812: if g_debug_flag = 'Y' then
2813: fii_util.stop_timer;
2814: fii_util.print_timer('Process Time');
2815: fii_util.put_line(' ');
2816: end if;
2817:

Line 2814: fii_util.print_timer('Process Time');

2810: end if;
2811: LOAD_MONTH(l_from_date, l_to_date);
2812: if g_debug_flag = 'Y' then
2813: fii_util.stop_timer;
2814: fii_util.print_timer('Process Time');
2815: fii_util.put_line(' ');
2816: end if;
2817:
2818: g_phase := 'Load Quarter Level';

Line 2815: fii_util.put_line(' ');

2811: LOAD_MONTH(l_from_date, l_to_date);
2812: if g_debug_flag = 'Y' then
2813: fii_util.stop_timer;
2814: fii_util.print_timer('Process Time');
2815: fii_util.put_line(' ');
2816: end if;
2817:
2818: g_phase := 'Load Quarter Level';
2819: if g_debug_flag = 'Y' then

Line 2820: fii_util.start_timer;

2816: end if;
2817:
2818: g_phase := 'Load Quarter Level';
2819: if g_debug_flag = 'Y' then
2820: fii_util.start_timer;
2821: end if;
2822: LOAD_QUARTER(l_from_date, l_to_date);
2823: if g_debug_flag = 'Y' then
2824: fii_util.stop_timer;

Line 2824: fii_util.stop_timer;

2820: fii_util.start_timer;
2821: end if;
2822: LOAD_QUARTER(l_from_date, l_to_date);
2823: if g_debug_flag = 'Y' then
2824: fii_util.stop_timer;
2825: fii_util.print_timer('Process Time');
2826: fii_util.put_line(' ');
2827: end if;
2828:

Line 2825: fii_util.print_timer('Process Time');

2821: end if;
2822: LOAD_QUARTER(l_from_date, l_to_date);
2823: if g_debug_flag = 'Y' then
2824: fii_util.stop_timer;
2825: fii_util.print_timer('Process Time');
2826: fii_util.put_line(' ');
2827: end if;
2828:
2829: g_phase := 'Load Year Level';

Line 2826: fii_util.put_line(' ');

2822: LOAD_QUARTER(l_from_date, l_to_date);
2823: if g_debug_flag = 'Y' then
2824: fii_util.stop_timer;
2825: fii_util.print_timer('Process Time');
2826: fii_util.put_line(' ');
2827: end if;
2828:
2829: g_phase := 'Load Year Level';
2830: if g_debug_flag = 'Y' then

Line 2831: fii_util.start_timer;

2827: end if;
2828:
2829: g_phase := 'Load Year Level';
2830: if g_debug_flag = 'Y' then
2831: fii_util.start_timer;
2832: end if;
2833: LOAD_YEAR(l_from_date, l_to_date);
2834: if g_debug_flag = 'Y' then
2835: fii_util.stop_timer;

Line 2835: fii_util.stop_timer;

2831: fii_util.start_timer;
2832: end if;
2833: LOAD_YEAR(l_from_date, l_to_date);
2834: if g_debug_flag = 'Y' then
2835: fii_util.stop_timer;
2836: fii_util.print_timer('Process Time');
2837: fii_util.put_line(' ');
2838: end if;
2839:

Line 2836: fii_util.print_timer('Process Time');

2832: end if;
2833: LOAD_YEAR(l_from_date, l_to_date);
2834: if g_debug_flag = 'Y' then
2835: fii_util.stop_timer;
2836: fii_util.print_timer('Process Time');
2837: fii_util.put_line(' ');
2838: end if;
2839:
2840: if (g_all_level = 'Y') then

Line 2837: fii_util.put_line(' ');

2833: LOAD_YEAR(l_from_date, l_to_date);
2834: if g_debug_flag = 'Y' then
2835: fii_util.stop_timer;
2836: fii_util.print_timer('Process Time');
2837: fii_util.put_line(' ');
2838: end if;
2839:
2840: if (g_all_level = 'Y') then
2841:

Line 2844: fii_util.start_timer;

2840: if (g_all_level = 'Y') then
2841:
2842: g_phase := 'Load Week Level';
2843: if g_debug_flag = 'Y' then
2844: fii_util.start_timer;
2845: end if;
2846: LOAD_WEEK(l_from_date, l_to_date);
2847: if g_debug_flag = 'Y' then
2848: fii_util.stop_timer;

Line 2848: fii_util.stop_timer;

2844: fii_util.start_timer;
2845: end if;
2846: LOAD_WEEK(l_from_date, l_to_date);
2847: if g_debug_flag = 'Y' then
2848: fii_util.stop_timer;
2849: fii_util.print_timer('Process Time');
2850: fii_util.put_line(' ');
2851: end if;
2852:

Line 2849: fii_util.print_timer('Process Time');

2845: end if;
2846: LOAD_WEEK(l_from_date, l_to_date);
2847: if g_debug_flag = 'Y' then
2848: fii_util.stop_timer;
2849: fii_util.print_timer('Process Time');
2850: fii_util.put_line(' ');
2851: end if;
2852:
2853: g_phase := 'Load Period 445 Level';

Line 2850: fii_util.put_line(' ');

2846: LOAD_WEEK(l_from_date, l_to_date);
2847: if g_debug_flag = 'Y' then
2848: fii_util.stop_timer;
2849: fii_util.print_timer('Process Time');
2850: fii_util.put_line(' ');
2851: end if;
2852:
2853: g_phase := 'Load Period 445 Level';
2854: if g_debug_flag = 'Y' then

Line 2855: fii_util.start_timer;

2851: end if;
2852:
2853: g_phase := 'Load Period 445 Level';
2854: if g_debug_flag = 'Y' then
2855: fii_util.start_timer;
2856: end if;
2857: LOAD_PERIOD_445(l_from_date, l_to_date);
2858: if g_debug_flag = 'Y' then
2859: fii_util.stop_timer;

Line 2859: fii_util.stop_timer;

2855: fii_util.start_timer;
2856: end if;
2857: LOAD_PERIOD_445(l_from_date, l_to_date);
2858: if g_debug_flag = 'Y' then
2859: fii_util.stop_timer;
2860: fii_util.print_timer('Process Time');
2861: fii_util.put_line(' ');
2862: end if;
2863:

Line 2860: fii_util.print_timer('Process Time');

2856: end if;
2857: LOAD_PERIOD_445(l_from_date, l_to_date);
2858: if g_debug_flag = 'Y' then
2859: fii_util.stop_timer;
2860: fii_util.print_timer('Process Time');
2861: fii_util.put_line(' ');
2862: end if;
2863:
2864: g_phase := 'Load Year 445 Level';

Line 2861: fii_util.put_line(' ');

2857: LOAD_PERIOD_445(l_from_date, l_to_date);
2858: if g_debug_flag = 'Y' then
2859: fii_util.stop_timer;
2860: fii_util.print_timer('Process Time');
2861: fii_util.put_line(' ');
2862: end if;
2863:
2864: g_phase := 'Load Year 445 Level';
2865: if g_debug_flag = 'Y' then

Line 2866: fii_util.start_timer;

2862: end if;
2863:
2864: g_phase := 'Load Year 445 Level';
2865: if g_debug_flag = 'Y' then
2866: fii_util.start_timer;
2867: end if;
2868: LOAD_YEAR_445(l_from_date, l_to_date);
2869: if g_debug_flag = 'Y' then
2870: fii_util.stop_timer;

Line 2870: fii_util.stop_timer;

2866: fii_util.start_timer;
2867: end if;
2868: LOAD_YEAR_445(l_from_date, l_to_date);
2869: if g_debug_flag = 'Y' then
2870: fii_util.stop_timer;
2871: fii_util.print_timer('Process Time');
2872: fii_util.put_line(' ');
2873: end if;
2874:

Line 2871: fii_util.print_timer('Process Time');

2867: end if;
2868: LOAD_YEAR_445(l_from_date, l_to_date);
2869: if g_debug_flag = 'Y' then
2870: fii_util.stop_timer;
2871: fii_util.print_timer('Process Time');
2872: fii_util.put_line(' ');
2873: end if;
2874:
2875: g_phase := 'Load Enterprise Period Level';

Line 2872: fii_util.put_line(' ');

2868: LOAD_YEAR_445(l_from_date, l_to_date);
2869: if g_debug_flag = 'Y' then
2870: fii_util.stop_timer;
2871: fii_util.print_timer('Process Time');
2872: fii_util.put_line(' ');
2873: end if;
2874:
2875: g_phase := 'Load Enterprise Period Level';
2876: if g_debug_flag = 'Y' then

Line 2877: fii_util.start_timer;

2873: end if;
2874:
2875: g_phase := 'Load Enterprise Period Level';
2876: if g_debug_flag = 'Y' then
2877: fii_util.start_timer;
2878: end if;
2879: if l_period_updated = 'Y' then
2880: -- we populate data from the earliest date in FII_TIME_DAY or the from date parameter, see which one is the earliest
2881: -- to the latest date in FII_TIME_DAY or the to date parameter, see which one is the latest. This is to make sure

Line 2888: fii_util.stop_timer;

2884: else
2885: LOAD_ENT_PERIOD(l_from_date, l_to_date);
2886: end if;
2887: if g_debug_flag = 'Y' then
2888: fii_util.stop_timer;
2889: fii_util.print_timer('Process Time');
2890: fii_util.put_line(' ');
2891: end if;
2892:

Line 2889: fii_util.print_timer('Process Time');

2885: LOAD_ENT_PERIOD(l_from_date, l_to_date);
2886: end if;
2887: if g_debug_flag = 'Y' then
2888: fii_util.stop_timer;
2889: fii_util.print_timer('Process Time');
2890: fii_util.put_line(' ');
2891: end if;
2892:
2893: g_phase := 'Load Enterprise Quarter Level';

Line 2890: fii_util.put_line(' ');

2886: end if;
2887: if g_debug_flag = 'Y' then
2888: fii_util.stop_timer;
2889: fii_util.print_timer('Process Time');
2890: fii_util.put_line(' ');
2891: end if;
2892:
2893: g_phase := 'Load Enterprise Quarter Level';
2894: if g_debug_flag = 'Y' then

Line 2895: fii_util.start_timer;

2891: end if;
2892:
2893: g_phase := 'Load Enterprise Quarter Level';
2894: if g_debug_flag = 'Y' then
2895: fii_util.start_timer;
2896: end if;
2897: -- we populate data from the earliest date in FII_TIME_DAY or the from date parameter, see which one is the earliest
2898: -- to the latest date in FII_TIME_DAY or the to date parameter, see which one is the latest. This is to make sure
2899: -- we will insert new records as well as existing records that we have been truncated

Line 2902: fii_util.stop_timer;

2898: -- to the latest date in FII_TIME_DAY or the to date parameter, see which one is the latest. This is to make sure
2899: -- we will insert new records as well as existing records that we have been truncated
2900: LOAD_ENT_QUARTER(least(nvl(l_min_date,l_from_date),l_from_date), greatest(nvl(l_max_date,l_to_date),l_to_date));
2901: if g_debug_flag = 'Y' then
2902: fii_util.stop_timer;
2903: fii_util.print_timer('Process Time');
2904: fii_util.put_line(' ');
2905: end if;
2906:

Line 2903: fii_util.print_timer('Process Time');

2899: -- we will insert new records as well as existing records that we have been truncated
2900: LOAD_ENT_QUARTER(least(nvl(l_min_date,l_from_date),l_from_date), greatest(nvl(l_max_date,l_to_date),l_to_date));
2901: if g_debug_flag = 'Y' then
2902: fii_util.stop_timer;
2903: fii_util.print_timer('Process Time');
2904: fii_util.put_line(' ');
2905: end if;
2906:
2907: g_phase := 'Load Enterprise Year Level';

Line 2904: fii_util.put_line(' ');

2900: LOAD_ENT_QUARTER(least(nvl(l_min_date,l_from_date),l_from_date), greatest(nvl(l_max_date,l_to_date),l_to_date));
2901: if g_debug_flag = 'Y' then
2902: fii_util.stop_timer;
2903: fii_util.print_timer('Process Time');
2904: fii_util.put_line(' ');
2905: end if;
2906:
2907: g_phase := 'Load Enterprise Year Level';
2908: if g_debug_flag = 'Y' then

Line 2909: fii_util.start_timer;

2905: end if;
2906:
2907: g_phase := 'Load Enterprise Year Level';
2908: if g_debug_flag = 'Y' then
2909: fii_util.start_timer;
2910: end if;
2911: -- we populate data from the earliest date in FII_TIME_DAY or the from date parameter, see which one is the earliest
2912: -- to the latest date in FII_TIME_DAY or the to date parameter, see which one is the latest. This is to make sure
2913: -- we will insert new records as well as existing records that we have been truncated

Line 2916: fii_util.stop_timer;

2912: -- to the latest date in FII_TIME_DAY or the to date parameter, see which one is the latest. This is to make sure
2913: -- we will insert new records as well as existing records that we have been truncated
2914: LOAD_ENT_YEAR(least(nvl(l_min_date,l_from_date),l_from_date), greatest(nvl(l_max_date,l_to_date),l_to_date));
2915: if g_debug_flag = 'Y' then
2916: fii_util.stop_timer;
2917: fii_util.print_timer('Process Time');
2918: fii_util.put_line(' ');
2919: end if;
2920:

Line 2917: fii_util.print_timer('Process Time');

2913: -- we will insert new records as well as existing records that we have been truncated
2914: LOAD_ENT_YEAR(least(nvl(l_min_date,l_from_date),l_from_date), greatest(nvl(l_max_date,l_to_date),l_to_date));
2915: if g_debug_flag = 'Y' then
2916: fii_util.stop_timer;
2917: fii_util.print_timer('Process Time');
2918: fii_util.put_line(' ');
2919: end if;
2920:
2921: g_phase := 'Load Financial Calendar Level';

Line 2918: fii_util.put_line(' ');

2914: LOAD_ENT_YEAR(least(nvl(l_min_date,l_from_date),l_from_date), greatest(nvl(l_max_date,l_to_date),l_to_date));
2915: if g_debug_flag = 'Y' then
2916: fii_util.stop_timer;
2917: fii_util.print_timer('Process Time');
2918: fii_util.put_line(' ');
2919: end if;
2920:
2921: g_phase := 'Load Financial Calendar Level';
2922: if g_debug_flag = 'Y' then

Line 2923: fii_util.start_timer;

2919: end if;
2920:
2921: g_phase := 'Load Financial Calendar Level';
2922: if g_debug_flag = 'Y' then
2923: fii_util.start_timer;
2924: end if;
2925: LOAD_CAL_NAME;
2926: if g_debug_flag = 'Y' then
2927: fii_util.stop_timer;

Line 2927: fii_util.stop_timer;

2923: fii_util.start_timer;
2924: end if;
2925: LOAD_CAL_NAME;
2926: if g_debug_flag = 'Y' then
2927: fii_util.stop_timer;
2928: fii_util.print_timer('Process Time');
2929: fii_util.put_line(' ');
2930: end if;
2931:

Line 2928: fii_util.print_timer('Process Time');

2924: end if;
2925: LOAD_CAL_NAME;
2926: if g_debug_flag = 'Y' then
2927: fii_util.stop_timer;
2928: fii_util.print_timer('Process Time');
2929: fii_util.put_line(' ');
2930: end if;
2931:
2932: g_phase := 'Load Financial Period Level';

Line 2929: fii_util.put_line(' ');

2925: LOAD_CAL_NAME;
2926: if g_debug_flag = 'Y' then
2927: fii_util.stop_timer;
2928: fii_util.print_timer('Process Time');
2929: fii_util.put_line(' ');
2930: end if;
2931:
2932: g_phase := 'Load Financial Period Level';
2933: if g_debug_flag = 'Y' then

Line 2934: fii_util.start_timer;

2930: end if;
2931:
2932: g_phase := 'Load Financial Period Level';
2933: if g_debug_flag = 'Y' then
2934: fii_util.start_timer;
2935: end if;
2936: LOAD_CAL_PERIOD;
2937: if g_debug_flag = 'Y' then
2938: fii_util.stop_timer;

Line 2938: fii_util.stop_timer;

2934: fii_util.start_timer;
2935: end if;
2936: LOAD_CAL_PERIOD;
2937: if g_debug_flag = 'Y' then
2938: fii_util.stop_timer;
2939: fii_util.print_timer('Process Time');
2940: fii_util.put_line(' ');
2941: end if;
2942:

Line 2939: fii_util.print_timer('Process Time');

2935: end if;
2936: LOAD_CAL_PERIOD;
2937: if g_debug_flag = 'Y' then
2938: fii_util.stop_timer;
2939: fii_util.print_timer('Process Time');
2940: fii_util.put_line(' ');
2941: end if;
2942:
2943: g_phase := 'Load Financial Quarter Level';

Line 2940: fii_util.put_line(' ');

2936: LOAD_CAL_PERIOD;
2937: if g_debug_flag = 'Y' then
2938: fii_util.stop_timer;
2939: fii_util.print_timer('Process Time');
2940: fii_util.put_line(' ');
2941: end if;
2942:
2943: g_phase := 'Load Financial Quarter Level';
2944: if g_debug_flag = 'Y' then

Line 2945: fii_util.start_timer;

2941: end if;
2942:
2943: g_phase := 'Load Financial Quarter Level';
2944: if g_debug_flag = 'Y' then
2945: fii_util.start_timer;
2946: end if;
2947: LOAD_CAL_QUARTER;
2948: if g_debug_flag = 'Y' then
2949: fii_util.stop_timer;

Line 2949: fii_util.stop_timer;

2945: fii_util.start_timer;
2946: end if;
2947: LOAD_CAL_QUARTER;
2948: if g_debug_flag = 'Y' then
2949: fii_util.stop_timer;
2950: fii_util.print_timer('Process Time');
2951: fii_util.put_line(' ');
2952: end if;
2953:

Line 2950: fii_util.print_timer('Process Time');

2946: end if;
2947: LOAD_CAL_QUARTER;
2948: if g_debug_flag = 'Y' then
2949: fii_util.stop_timer;
2950: fii_util.print_timer('Process Time');
2951: fii_util.put_line(' ');
2952: end if;
2953:
2954: g_phase := 'Load Financial Year Level';

Line 2951: fii_util.put_line(' ');

2947: LOAD_CAL_QUARTER;
2948: if g_debug_flag = 'Y' then
2949: fii_util.stop_timer;
2950: fii_util.print_timer('Process Time');
2951: fii_util.put_line(' ');
2952: end if;
2953:
2954: g_phase := 'Load Financial Year Level';
2955: if g_debug_flag = 'Y' then

Line 2956: fii_util.start_timer;

2952: end if;
2953:
2954: g_phase := 'Load Financial Year Level';
2955: if g_debug_flag = 'Y' then
2956: fii_util.start_timer;
2957: end if;
2958: LOAD_CAL_YEAR;
2959: if g_debug_flag = 'Y' then
2960: fii_util.stop_timer;

Line 2960: fii_util.stop_timer;

2956: fii_util.start_timer;
2957: end if;
2958: LOAD_CAL_YEAR;
2959: if g_debug_flag = 'Y' then
2960: fii_util.stop_timer;
2961: fii_util.print_timer('Process Time');
2962: fii_util.put_line(' ');
2963: end if;
2964:

Line 2961: fii_util.print_timer('Process Time');

2957: end if;
2958: LOAD_CAL_YEAR;
2959: if g_debug_flag = 'Y' then
2960: fii_util.stop_timer;
2961: fii_util.print_timer('Process Time');
2962: fii_util.put_line(' ');
2963: end if;
2964:
2965: g_phase := 'Refresh Materialized View';

Line 2962: fii_util.put_line(' ');

2958: LOAD_CAL_YEAR;
2959: if g_debug_flag = 'Y' then
2960: fii_util.stop_timer;
2961: fii_util.print_timer('Process Time');
2962: fii_util.put_line(' ');
2963: end if;
2964:
2965: g_phase := 'Refresh Materialized View';
2966: if g_debug_flag = 'Y' then

Line 2967: fii_util.put_line('LOAD : '||'Refresh Materialized View');

2963: end if;
2964:
2965: g_phase := 'Refresh Materialized View';
2966: if g_debug_flag = 'Y' then
2967: fii_util.put_line('LOAD : '||'Refresh Materialized View');
2968: fii_util.start_timer;
2969: end if;
2970:
2971: commit;

Line 2968: fii_util.start_timer;

2964:
2965: g_phase := 'Refresh Materialized View';
2966: if g_debug_flag = 'Y' then
2967: fii_util.put_line('LOAD : '||'Refresh Materialized View');
2968: fii_util.start_timer;
2969: end if;
2970:
2971: commit;
2972:

Line 2981: fii_util.stop_timer;

2977: BIS_MV_REFRESH.refresh_wrapper ('FII_TIME_CAL_DAY_MV', 'C');
2978: ------------------------------------------------------------------------------
2979:
2980: if g_debug_flag = 'Y' then
2981: fii_util.stop_timer;
2982: fii_util.print_timer('Process Time');
2983: fii_util.put_line(' ');
2984: end if;
2985:

Line 2982: fii_util.print_timer('Process Time');

2978: ------------------------------------------------------------------------------
2979:
2980: if g_debug_flag = 'Y' then
2981: fii_util.stop_timer;
2982: fii_util.print_timer('Process Time');
2983: fii_util.put_line(' ');
2984: end if;
2985:
2986: g_phase := 'Load Reporting Structure Table for Financial Calendars';

Line 2983: fii_util.put_line(' ');

2979:
2980: if g_debug_flag = 'Y' then
2981: fii_util.stop_timer;
2982: fii_util.print_timer('Process Time');
2983: fii_util.put_line(' ');
2984: end if;
2985:
2986: g_phase := 'Load Reporting Structure Table for Financial Calendars';
2987: if g_debug_flag = 'Y' then

Line 2988: fii_util.start_timer;

2984: end if;
2985:
2986: g_phase := 'Load Reporting Structure Table for Financial Calendars';
2987: if g_debug_flag = 'Y' then
2988: fii_util.start_timer;
2989: end if;
2990: LOAD_TIME_CAL_RPT_STRUCT(l_from_date, l_to_date);
2991: if g_debug_flag = 'Y' then
2992: fii_util.stop_timer;

Line 2992: fii_util.stop_timer;

2988: fii_util.start_timer;
2989: end if;
2990: LOAD_TIME_CAL_RPT_STRUCT(l_from_date, l_to_date);
2991: if g_debug_flag = 'Y' then
2992: fii_util.stop_timer;
2993: fii_util.print_timer('Process Time');
2994: fii_util.put_line(' ');
2995: end if;
2996:

Line 2993: fii_util.print_timer('Process Time');

2989: end if;
2990: LOAD_TIME_CAL_RPT_STRUCT(l_from_date, l_to_date);
2991: if g_debug_flag = 'Y' then
2992: fii_util.stop_timer;
2993: fii_util.print_timer('Process Time');
2994: fii_util.put_line(' ');
2995: end if;
2996:
2997: if g_day_row_cnt > 0 or

Line 2994: fii_util.put_line(' ');

2990: LOAD_TIME_CAL_RPT_STRUCT(l_from_date, l_to_date);
2991: if g_debug_flag = 'Y' then
2992: fii_util.stop_timer;
2993: fii_util.print_timer('Process Time');
2994: fii_util.put_line(' ');
2995: end if;
2996:
2997: if g_day_row_cnt > 0 or
2998: l_validated = 'N' then

Line 3002: fii_util.start_timer;

2998: l_validated = 'N' then
2999:
3000: g_phase := 'Load Reporting Structure Table';
3001: if g_debug_flag = 'Y' then
3002: fii_util.start_timer;
3003: end if;
3004: LOAD_TIME_RPT_STRUCT;
3005: if g_debug_flag = 'Y' then
3006: fii_util.stop_timer;

Line 3006: fii_util.stop_timer;

3002: fii_util.start_timer;
3003: end if;
3004: LOAD_TIME_RPT_STRUCT;
3005: if g_debug_flag = 'Y' then
3006: fii_util.stop_timer;
3007: fii_util.print_timer('Process Time');
3008: fii_util.put_line(' ');
3009: end if;
3010:

Line 3007: fii_util.print_timer('Process Time');

3003: end if;
3004: LOAD_TIME_RPT_STRUCT;
3005: if g_debug_flag = 'Y' then
3006: fii_util.stop_timer;
3007: fii_util.print_timer('Process Time');
3008: fii_util.put_line(' ');
3009: end if;
3010:
3011: g_phase := 'Load Time Structures Table';

Line 3008: fii_util.put_line(' ');

3004: LOAD_TIME_RPT_STRUCT;
3005: if g_debug_flag = 'Y' then
3006: fii_util.stop_timer;
3007: fii_util.print_timer('Process Time');
3008: fii_util.put_line(' ');
3009: end if;
3010:
3011: g_phase := 'Load Time Structures Table';
3012: IF g_debug_flag = 'Y' THEN

Line 3013: fii_util.start_timer;

3009: end if;
3010:
3011: g_phase := 'Load Time Structures Table';
3012: IF g_debug_flag = 'Y' THEN
3013: fii_util.start_timer;
3014: END IF;
3015: FII_TIME_STRUCTURE_C.LOAD_TIME_STRUCTURES;
3016: IF g_debug_flag = 'Y' THEN
3017: fii_util.stop_timer;

Line 3017: fii_util.stop_timer;

3013: fii_util.start_timer;
3014: END IF;
3015: FII_TIME_STRUCTURE_C.LOAD_TIME_STRUCTURES;
3016: IF g_debug_flag = 'Y' THEN
3017: fii_util.stop_timer;
3018: fii_util.print_timer('Process Time');
3019: fii_util.put_line(' ');
3020: END IF;
3021:

Line 3018: fii_util.print_timer('Process Time');

3014: END IF;
3015: FII_TIME_STRUCTURE_C.LOAD_TIME_STRUCTURES;
3016: IF g_debug_flag = 'Y' THEN
3017: fii_util.stop_timer;
3018: fii_util.print_timer('Process Time');
3019: fii_util.put_line(' ');
3020: END IF;
3021:
3022: else

Line 3019: fii_util.put_line(' ');

3015: FII_TIME_STRUCTURE_C.LOAD_TIME_STRUCTURES;
3016: IF g_debug_flag = 'Y' THEN
3017: fii_util.stop_timer;
3018: fii_util.print_timer('Process Time');
3019: fii_util.put_line(' ');
3020: END IF;
3021:
3022: else
3023:

Line 3039: fii_util.start_timer;

3035: if l_count = 0 then
3036:
3037: g_phase := 'Load Time Structures Table';
3038: IF g_debug_flag = 'Y' THEN
3039: fii_util.start_timer;
3040: END IF;
3041: FII_TIME_STRUCTURE_C.LOAD_TIME_STRUCTURES;
3042: IF g_debug_flag = 'Y' THEN
3043: fii_util.stop_timer;

Line 3043: fii_util.stop_timer;

3039: fii_util.start_timer;
3040: END IF;
3041: FII_TIME_STRUCTURE_C.LOAD_TIME_STRUCTURES;
3042: IF g_debug_flag = 'Y' THEN
3043: fii_util.stop_timer;
3044: fii_util.print_timer('Process Time');
3045: fii_util.put_line(' ');
3046: END IF;
3047:

Line 3044: fii_util.print_timer('Process Time');

3040: END IF;
3041: FII_TIME_STRUCTURE_C.LOAD_TIME_STRUCTURES;
3042: IF g_debug_flag = 'Y' THEN
3043: fii_util.stop_timer;
3044: fii_util.print_timer('Process Time');
3045: fii_util.put_line(' ');
3046: END IF;
3047:
3048: end if;

Line 3045: fii_util.put_line(' ');

3041: FII_TIME_STRUCTURE_C.LOAD_TIME_STRUCTURES;
3042: IF g_debug_flag = 'Y' THEN
3043: fii_util.stop_timer;
3044: fii_util.print_timer('Process Time');
3045: fii_util.put_line(' ');
3046: END IF;
3047:
3048: end if;
3049:

Line 3066: fii_util.start_timer;

3062:
3063: if l_count = 0 then
3064: g_phase := 'Load Rolling Period Offsets Table';
3065: if g_debug_flag = 'Y' then
3066: fii_util.start_timer;
3067: end if;
3068: FII_TIME_ROLLING_PKG.Load_Rolling_Offsets(l_error_msg,l_error_code);
3069: if g_debug_flag = 'Y' then
3070: fii_util.stop_timer;

Line 3070: fii_util.stop_timer;

3066: fii_util.start_timer;
3067: end if;
3068: FII_TIME_ROLLING_PKG.Load_Rolling_Offsets(l_error_msg,l_error_code);
3069: if g_debug_flag = 'Y' then
3070: fii_util.stop_timer;
3071: fii_util.print_timer('Process Time');
3072: fii_util.put_line(' ');
3073: end if;
3074: end if;

Line 3071: fii_util.print_timer('Process Time');

3067: end if;
3068: FII_TIME_ROLLING_PKG.Load_Rolling_Offsets(l_error_msg,l_error_code);
3069: if g_debug_flag = 'Y' then
3070: fii_util.stop_timer;
3071: fii_util.print_timer('Process Time');
3072: fii_util.put_line(' ');
3073: end if;
3074: end if;
3075:

Line 3072: fii_util.put_line(' ');

3068: FII_TIME_ROLLING_PKG.Load_Rolling_Offsets(l_error_msg,l_error_code);
3069: if g_debug_flag = 'Y' then
3070: fii_util.stop_timer;
3071: fii_util.print_timer('Process Time');
3072: fii_util.put_line(' ');
3073: end if;
3074: end if;
3075:
3076: if g_day_row_cnt > 0 or

Line 3081: fii_util.start_timer;

3077: l_validated = 'N' then
3078:
3079: g_phase := 'Gather statistics';
3080: if g_debug_flag = 'Y' then
3081: fii_util.start_timer;
3082: end if;
3083:
3084: -- note: we don't gather stats on FII_TIME_DAY
3085: -- as this should be done by RSG

Line 3089: fii_util.put_line('Gathered statistics for Month Level');

3085: -- as this should be done by RSG
3086: gather_table_stats('FII_TIME_MONTH');
3087:
3088: if g_debug_flag = 'Y' then
3089: fii_util.put_line('Gathered statistics for Month Level');
3090: end if;
3091:
3092: gather_table_stats('FII_TIME_QTR');
3093:

Line 3095: fii_util.put_line('Gathered statistics for Quarter Level');

3091:
3092: gather_table_stats('FII_TIME_QTR');
3093:
3094: if g_debug_flag = 'Y' then
3095: fii_util.put_line('Gathered statistics for Quarter Level');
3096: end if;
3097:
3098: gather_table_stats('FII_TIME_YEAR445');
3099:

Line 3101: fii_util.put_line('Gathered statistics for Period 445 Level');

3097:
3098: gather_table_stats('FII_TIME_YEAR445');
3099:
3100: if g_debug_flag = 'Y' then
3101: fii_util.put_line('Gathered statistics for Period 445 Level');
3102: end if;
3103:
3104: IF g_debug_flag = 'Y' THEN
3105: fii_util.stop_timer;

Line 3105: fii_util.stop_timer;

3101: fii_util.put_line('Gathered statistics for Period 445 Level');
3102: end if;
3103:
3104: IF g_debug_flag = 'Y' THEN
3105: fii_util.stop_timer;
3106: fii_util.print_timer('Process Time');
3107: fii_util.put_line(' ');
3108: END IF;
3109:

Line 3106: fii_util.print_timer('Process Time');

3102: end if;
3103:
3104: IF g_debug_flag = 'Y' THEN
3105: fii_util.stop_timer;
3106: fii_util.print_timer('Process Time');
3107: fii_util.put_line(' ');
3108: END IF;
3109:
3110: end if;

Line 3107: fii_util.put_line(' ');

3103:
3104: IF g_debug_flag = 'Y' THEN
3105: fii_util.stop_timer;
3106: fii_util.print_timer('Process Time');
3107: fii_util.put_line(' ');
3108: END IF;
3109:
3110: end if;
3111:

Line 3127: fii_util.put_line(' ');

3123: truncate_table('FII_TIME_RPT_STRUCT');
3124: truncate_table('FII_TIME_CAL_RPT_STRUCT');
3125:
3126: if g_debug_flag = 'Y' then
3127: fii_util.put_line(' ');
3128: end if;
3129:
3130: end if;
3131:

Line 3161: fii_util.put_line(fnd_message.get_string('FII', 'FII_BIS_PARAMETER_NOT_SETUP'));

3157: end if;
3158:
3159: exception
3160: WHEN G_BIS_PARAMETER_NOT_SETUP THEN
3161: fii_util.put_line(fnd_message.get_string('FII', 'FII_BIS_PARAMETER_NOT_SETUP'));
3162: retcode := -1;
3163: rollback;
3164: if l_bis_setup = 'Y' then
3165: BIS_COLLECTION_UTILITIES.wrapup

Line 3171: fii_util.put_line('Can not get User ID and Login ID, program exit');

3167: , p_message => fnd_message.get_string('FII', 'FII_BIS_PARAMETER_NOT_SETUP')
3168: );
3169: end if;
3170: WHEN G_LOGIN_INFO_NOT_FOUND THEN
3171: fii_util.put_line('Can not get User ID and Login ID, program exit');
3172: retcode := -1;
3173: rollback;
3174: if l_bis_setup = 'Y' then
3175: BIS_COLLECTION_UTILITIES.wrapup

Line 3186: fii_util.put_line(l_mesg);

3182: --Bug 3640141. Setting token as the message text has changed.
3183: fnd_message.set_name('FII','FII_ENT_CALENDAR_NOT_FOUND');
3184: fnd_message.set_token('DATE_NOT_DEFINED', fnd_date.date_to_displaydate(g_date_not_defined));
3185: l_mesg := fnd_message.get;
3186: fii_util.put_line(l_mesg);
3187: retcode := -1;
3188: if l_bis_setup = 'Y' then
3189: BIS_COLLECTION_UTILITIES.wrapup
3190: ( p_status => FALSE , p_message => l_mesg);

Line 3200: fii_util.put_line(l_mesg);

3196: fnd_message.set_token('YEAR', l_year);
3197: fnd_message.set_token('START_DATE', fnd_date.date_to_displaydate(l_min_start_date));
3198: fnd_message.set_token('END_DATE', fnd_date.date_to_displaydate(l_max_end_date));
3199: l_mesg := fnd_message.get;
3200: fii_util.put_line(l_mesg);
3201: retcode := -1;
3202: if l_bis_setup = 'Y' then
3203: BIS_COLLECTION_UTILITIES.wrapup
3204: ( p_status => FALSE , p_message => l_mesg);

Line 3210: fii_util.put_line(retcode||' : '||errbuf);

3206: WHEN OTHERS THEN
3207: rollback;
3208: retcode := sqlcode;
3209: errbuf := sqlerrm;
3210: fii_util.put_line(retcode||' : '||errbuf);
3211: fii_util.put_line('
3212: -------------------------------------------
3213: Error occured in Procedure: LOAD
3214: Phase: ' || g_phase);

Line 3211: fii_util.put_line('

3207: rollback;
3208: retcode := sqlcode;
3209: errbuf := sqlerrm;
3210: fii_util.put_line(retcode||' : '||errbuf);
3211: fii_util.put_line('
3212: -------------------------------------------
3213: Error occured in Procedure: LOAD
3214: Phase: ' || g_phase);
3215: if l_bis_setup = 'Y' then

Line 3304: fii_util.put_line('LOAD_CAL_NAME : '||to_char(l_name_row)||' records has been populated to Calendar Name Level');

3300:
3301: commit;
3302:
3303: if g_debug_flag = 'Y' then
3304: fii_util.put_line('LOAD_CAL_NAME : '||to_char(l_name_row)||' records has been populated to Calendar Name Level');
3305: end if;
3306:
3307: if l_name_row > 0 then
3308:

Line 3312: fii_util.put_line('LOAD_CAL_NAME : '||'Gathered statistics for Calendar Name Level');

3308:
3309: gather_table_stats('FII_TIME_CAL_NAME');
3310:
3311: if g_debug_flag = 'Y' then
3312: fii_util.put_line('LOAD_CAL_NAME : '||'Gathered statistics for Calendar Name Level');
3313: end if;
3314:
3315: end if;
3316:

Line 3715: fii_util.put_line('LOAD_TIME_RPT_STRUCT :'||to_char(l_row)||' records has been populated to the Reporting Structure table');

3711:
3712: END LOOP; -- c1_rec
3713:
3714: if g_debug_flag = 'Y' then
3715: fii_util.put_line('LOAD_TIME_RPT_STRUCT :'||to_char(l_row)||' records has been populated to the Reporting Structure table');
3716: end if;
3717:
3718: gather_table_stats('FII_TIME_RPT_STRUCT');
3719:

Line 3721: fii_util.put_line('LOAD_TIME_RPT_STRUCT :'||'Gathered statistics for the Reporting Structure table');

3717:
3718: gather_table_stats('FII_TIME_RPT_STRUCT');
3719:
3720: if g_debug_flag = 'Y' then
3721: fii_util.put_line('LOAD_TIME_RPT_STRUCT :'||'Gathered statistics for the Reporting Structure table');
3722: end if;
3723:
3724: end LOAD_TIME_RPT_STRUCT;
3725:

Line 4143: fii_util.put_line('LOAD_TIME_CAL_RPT_STRUCT : '||TO_CHAR(l_row)||' records has been populated to the Reporting Structure table for Financial Calendars');

4139:
4140: END LOOP;
4141:
4142: IF g_debug_flag = 'Y' THEN
4143: fii_util.put_line('LOAD_TIME_CAL_RPT_STRUCT : '||TO_CHAR(l_row)||' records has been populated to the Reporting Structure table for Financial Calendars');
4144: END IF;
4145:
4146: if l_row > 0 then
4147:

Line 4151: fii_util.put_line('LOAD_TIME_CAL_RPT_STRUCT :'||'Gathered statistics for Financial Calendars');

4147:
4148: gather_table_stats('FII_TIME_CAL_RPT_STRUCT');
4149:
4150: if g_debug_flag = 'Y' then
4151: fii_util.put_line('LOAD_TIME_CAL_RPT_STRUCT :'||'Gathered statistics for Financial Calendars');
4152: end if;
4153:
4154: end if;
4155: