APPS.BIS_COLLECTION_UTILITIES dependencies on BIS_COLLECTION_UTILITIES

Line 1: package body BIS_COLLECTION_UTILITIES AS

1: package body BIS_COLLECTION_UTILITIES AS
2: /*$Header: BISDBUTB.pls 120.4 2006/09/07 14:38:26 amitgupt noship $*/
3:
4: PROCEDURE UPDATE_DATE IS
5: l_count number;

Line 305: BIS_COLLECTION_UTILITIES.put_line('calling "Import BIS Time Dimension into BSC program"');

301: ---call "Import BIS Time Dimension into BSC" so that whenever time dimension
302: ---is updated, this program is also being called to make data consistent
303: if g_object_name='FII_DBI_TIME_M' and program_exist('BSC_IMP_BIS_TIME_BSC',271)='Y' then
304: begin
305: BIS_COLLECTION_UTILITIES.put_line('calling "Import BIS Time Dimension into BSC program"');
306: if g_debug then
307: l_option_string:='DEBUG LOG';
308: else
309: l_option_string:=null;

Line 323: BIS_COLLECTION_UTILITIES.put_line('Done ' || 'BSC_DBI_CALENDAR.load_dbi_cal_into_bsc');

319: DBMS_SQL.close_cursor(l_cursor_id);
320: **/
321: l_stmt := 'BEGIN BSC_DBI_CALENDAR.load_dbi_cal_into_bsc(:1, :2,:3); END;';
322: execute immediate l_stmt using OUT errbuf,OUT retcode,IN l_option_string;
323: BIS_COLLECTION_UTILITIES.put_line('Done ' || 'BSC_DBI_CALENDAR.load_dbi_cal_into_bsc');
324: BIS_COLLECTION_UTILITIES.put_line('********************************************************');
325: exception
326: when others then
327: BIS_COLLECTION_UTILITIES.put_line('Exception happens in BSC_DBI_CALENDAR.load_dbi_cal_into_bsc '||sqlerrm);

Line 324: BIS_COLLECTION_UTILITIES.put_line('********************************************************');

320: **/
321: l_stmt := 'BEGIN BSC_DBI_CALENDAR.load_dbi_cal_into_bsc(:1, :2,:3); END;';
322: execute immediate l_stmt using OUT errbuf,OUT retcode,IN l_option_string;
323: BIS_COLLECTION_UTILITIES.put_line('Done ' || 'BSC_DBI_CALENDAR.load_dbi_cal_into_bsc');
324: BIS_COLLECTION_UTILITIES.put_line('********************************************************');
325: exception
326: when others then
327: BIS_COLLECTION_UTILITIES.put_line('Exception happens in BSC_DBI_CALENDAR.load_dbi_cal_into_bsc '||sqlerrm);
328: l_temp:=fnd_concurrent.set_completion_status('WARNING' ,NULL);

Line 327: BIS_COLLECTION_UTILITIES.put_line('Exception happens in BSC_DBI_CALENDAR.load_dbi_cal_into_bsc '||sqlerrm);

323: BIS_COLLECTION_UTILITIES.put_line('Done ' || 'BSC_DBI_CALENDAR.load_dbi_cal_into_bsc');
324: BIS_COLLECTION_UTILITIES.put_line('********************************************************');
325: exception
326: when others then
327: BIS_COLLECTION_UTILITIES.put_line('Exception happens in BSC_DBI_CALENDAR.load_dbi_cal_into_bsc '||sqlerrm);
328: l_temp:=fnd_concurrent.set_completion_status('WARNING' ,NULL);
329: end;
330: end if;
331:

Line 1074: l_proc VARCHAR2(100) := 'BIS.BIS_COLLECTION_UTILITIES.get_last_failure_period';

1070: */
1071: function get_last_failure_period(p_object_name in varchar2) return varchar2 is
1072: l_date date;
1073: l_date_disp varchar2(100);
1074: l_proc VARCHAR2(100) := 'BIS.BIS_COLLECTION_UTILITIES.get_last_failure_period';
1075: begin
1076: SELECT MAX(period_to) INTO l_date
1077: FROM bis_refresh_log
1078: WHERE object_name = p_object_name AND

Line 1113: l_proc VARCHAR2(100) := 'BIS.BIS_COLLECTION_UTILITIES.get_last_failure_period';

1109: ) is
1110: l_date_from date;
1111: l_date_to date;
1112:
1113: l_proc VARCHAR2(100) := 'BIS.BIS_COLLECTION_UTILITIES.get_last_failure_period';
1114: begin
1115: SELECT period_to, period_from INTO l_date_to,l_date_from
1116: FROM bis_refresh_log
1117: WHERE object_name = p_object_name AND

Line 1144: END BIS_COLLECTION_UTILITIES;

1140: put_line(fnd_message.get, fnd_log.LEVEL_UNEXPECTED);
1141: RAISE;
1142: end get_last_failure_period;
1143:
1144: END BIS_COLLECTION_UTILITIES;