DBA Data[Home] [Help]

APPS.FII_TIME_C dependencies on FND_DATE

Line 362: fnd_date.date_to_displaydate(g_global_start_date));

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;
366:

Line 2570: fnd_date.date_to_displaydate(l_from_date) ||

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;
2574:

Line 2572: fnd_date.date_to_displaydate(l_to_date));

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;
2574:
2575: -----------------------------------------------------
2576: -- Calling BIS API to do common set ups

Line 2705: fnd_date.date_to_displaydate(l_from_date) ||

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;
2709:

Line 2707: fnd_date.date_to_displaydate(l_to_date));

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;
2709:
2710: end if; --if g_all_level = 'Y'
2711:

Line 3142: , fnd_date.displaydt_to_date

3138: BIS_COLLECTION_UTILITIES.wrapup
3139: ( p_status => TRUE
3140: , p_period_from => l_from_date
3141: , p_period_to => greatest( l_to_date
3142: , fnd_date.displaydt_to_date
3143: ( bis_collection_utilities.get_last_refresh_period
3144: ('FII_DBI_TIME_M_F')
3145: )
3146: )

Line 3184: fnd_message.set_token('DATE_NOT_DEFINED', fnd_date.date_to_displaydate(g_date_not_defined));

3180: WHEN G_ENT_CALENDAR_NOT_FOUND THEN
3181: rollback;
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

Line 3197: fnd_message.set_token('START_DATE', fnd_date.date_to_displaydate(l_min_start_date));

3193: --Added for bug 4454026
3194: rollback;
3195: fnd_message.set_name('FII','FII_FISCAL_YEAR_NOT_DEFINED');
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;

Line 3198: fnd_message.set_token('END_DATE', fnd_date.date_to_displaydate(l_max_end_date));

3194: rollback;
3195: fnd_message.set_name('FII','FII_FISCAL_YEAR_NOT_DEFINED');
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

Line 4173: l_return_date := least(fnd_date.displaydt_to_date

4169: begin
4170:
4171: if p_load_mode = 'INCRE' then
4172: if check_validated = 'Y' then
4173: l_return_date := least(fnd_date.displaydt_to_date
4174: ( bis_collection_utilities.get_last_refresh_period
4175: ('FII_DBI_TIME_M')
4176: ) +1, fnd_date.displaydt_to_date(DEFAULT_LOAD_TO_DATE));
4177: else

Line 4176: ) +1, fnd_date.displaydt_to_date(DEFAULT_LOAD_TO_DATE));

4172: if check_validated = 'Y' then
4173: l_return_date := least(fnd_date.displaydt_to_date
4174: ( bis_collection_utilities.get_last_refresh_period
4175: ('FII_DBI_TIME_M')
4176: ) +1, fnd_date.displaydt_to_date(DEFAULT_LOAD_TO_DATE));
4177: else
4178: l_return_date := bis_common_parameters.get_global_start_date;
4179: end if;
4180: else

Line 4185: return fnd_date.date_to_displaydt(l_return_date);

4181: select least(nvl(min(start_date),bis_common_parameters.get_global_start_date) , bis_common_parameters.get_global_start_date) into l_return_date
4182: from fii_time_day;
4183: end if;
4184:
4185: return fnd_date.date_to_displaydt(l_return_date);
4186:
4187: end DEFAULT_LOAD_FROM_DATE;
4188:
4189: ---------------------------------------------------

Line 4211: return fnd_date.date_to_displaydt(l_return_date);

4207: where adjustment_period_flag = 'N'
4208: and period_set_name = l_period_set_name
4209: and period_type = l_period_type;
4210:
4211: return fnd_date.date_to_displaydt(l_return_date);
4212:
4213: end DEFAULT_LOAD_TO_DATE;
4214:
4215: END FII_TIME_C;