DBA Data[Home] [Help]

APPS.FII_TIME_C dependencies on BIS_COLLECTION_UTILITIES

Line 179: BIS_COLLECTION_UTILITIES.GET_LAST_USER_ATTRIBUTES

175: l_validated varchar2(1) := 'N';
176:
177: begin
178:
179: BIS_COLLECTION_UTILITIES.GET_LAST_USER_ATTRIBUTES
180: ( P_OBJECT_NAME => 'FII_DBI_TIME_M'
181: , P_ATTRIBUTE_TABLE => l_att_tbl
182: , P_COUNT => l_att_cnt
183: );

Line 2584: ELSIF (NOT BIS_COLLECTION_UTILITIES.setup('FII_DBI_TIME_M')) THEN

2580: l_global_param_list(1) := 'BIS_GLOBAL_START_DATE';
2581: IF (NOT bis_common_parameters.check_global_parameters(l_global_param_list)) THEN
2582: retcode := 1;
2583: raise G_BIS_PARAMETER_NOT_SETUP;
2584: ELSIF (NOT BIS_COLLECTION_UTILITIES.setup('FII_DBI_TIME_M')) THEN
2585: errbuf := sqlerrm;
2586: raise_application_error(-20000, 'Error for Time setup: ' || errbuf);
2587: END IF;
2588:

Line 3138: BIS_COLLECTION_UTILITIES.wrapup

3134: -- when we have a successful loading
3135: ----------------------------------------------------------------
3136: if g_all_level = 'Y' then
3137:
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

Line 3143: ( bis_collection_utilities.get_last_refresh_period

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: )
3147: , p_attribute1 => 'Y'

Line 3152: BIS_COLLECTION_UTILITIES.wrapup (p_status => TRUE,

3148: );
3149:
3150: else
3151:
3152: BIS_COLLECTION_UTILITIES.wrapup (p_status => TRUE,
3153: p_period_from => l_from_date,
3154: p_period_to => l_to_date);
3155:
3156:

Line 3165: BIS_COLLECTION_UTILITIES.wrapup

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
3166: ( p_status => FALSE
3167: , p_message => fnd_message.get_string('FII', 'FII_BIS_PARAMETER_NOT_SETUP')
3168: );
3169: end if;

Line 3175: BIS_COLLECTION_UTILITIES.wrapup

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
3176: ( p_status => FALSE
3177: , p_message => 'Can not get User ID and Login ID, program exit'
3178: );
3179: end if;

Line 3189: BIS_COLLECTION_UTILITIES.wrapup

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);
3191: end if;
3192: WHEN G_YEAR_NOT_DEFINED THEN
3193: --Added for bug 4454026

Line 3203: BIS_COLLECTION_UTILITIES.wrapup

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);
3205: end if;
3206: WHEN OTHERS THEN
3207: rollback;

Line 3216: BIS_COLLECTION_UTILITIES.wrapup

3212: -------------------------------------------
3213: Error occured in Procedure: LOAD
3214: Phase: ' || g_phase);
3215: if l_bis_setup = 'Y' then
3216: BIS_COLLECTION_UTILITIES.wrapup
3217: ( p_status => FALSE
3218: , p_message => substr(sqlerrm,1,4000)
3219: );
3220: end if;

Line 4174: ( bis_collection_utilities.get_last_refresh_period

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
4178: l_return_date := bis_common_parameters.get_global_start_date;