APPS.BIX_CALL_UPDATE_PKG dependencies on BIS_COLLECTION_UTILITIES

Line 47: BIS_COLLECTION_UTILITIES.log(p_msg);

43: ) IS
44: BEGIN
45:
46: --IF (g_debug_flag = 'Y') THEN
47: BIS_COLLECTION_UTILITIES.log(p_msg);
48: --BIS_COLLECTION_UTILITIES.log(to_char(sysdate, 'mm/dd/yyyy hh24:mi:ss: ')||
49: --p_msg);
50:
51: --fnd_file.put_line(fnd_file.log,TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')|| ' : '||p_msg);

Line 48: --BIS_COLLECTION_UTILITIES.log(to_char(sysdate, 'mm/dd/yyyy hh24:mi:ss: ')||

44: BEGIN
45:
46: --IF (g_debug_flag = 'Y') THEN
47: BIS_COLLECTION_UTILITIES.log(p_msg);
48: --BIS_COLLECTION_UTILITIES.log(to_char(sysdate, 'mm/dd/yyyy hh24:mi:ss: ')||
49: --p_msg);
50:
51: --fnd_file.put_line(fnd_file.log,TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')|| ' : '||p_msg);
52:

Line 582: IF (BIS_COLLECTION_UTILITIES.SETUP('BIX_CALL_DETAILS_F') = FALSE) THEN

578: --write_log('Start of the procedure init at : ' ||
579: --to_char(sysdate, 'mm/dd/yyyy hh24:mi:ss'));
580: --END IF;
581:
582: IF (BIS_COLLECTION_UTILITIES.SETUP('BIX_CALL_DETAILS_F') = FALSE) THEN
583: RAISE_APPLICATION_ERROR(-20000,
584: 'BIS_COLLECTION_UTILITIES.setup has failed');
585: END IF;
586:

Line 584: 'BIS_COLLECTION_UTILITIES.setup has failed');

580: --END IF;
581:
582: IF (BIS_COLLECTION_UTILITIES.SETUP('BIX_CALL_DETAILS_F') = FALSE) THEN
583: RAISE_APPLICATION_ERROR(-20000,
584: 'BIS_COLLECTION_UTILITIES.setup has failed');
585: END IF;
586:
587:
588: --IF (g_debug_flag = 'Y') THEN

Line 5667: BIS_COLLECTION_UTILITIES.get_last_refresh_dates('BIX_CALL_DETAILS_F',

5663:
5664:
5665: init;
5666:
5667: BIS_COLLECTION_UTILITIES.get_last_refresh_dates('BIX_CALL_DETAILS_F',
5668: l_last_start_date,
5669: l_last_end_date,
5670: l_last_period_from,
5671: l_last_period_to);

Line 6017: bis_collection_utilities.wrapup(

6013: --write_log('Done truncating bix_call_details_stg and bix_call_procesed_recs');
6014: --
6015: --write_log('Calling procedure WRAPUP');
6016: --END IF;
6017: bis_collection_utilities.wrapup(
6018: p_status => TRUE,
6019: p_count => g_rows_ins_upd,
6020: p_message => NULL,
6021: p_period_from => g_collect_start_date,

Line 6033: bis_collection_utilities.wrapup(

6029: EXCEPTION
6030: WHEN G_TIME_DIM_MISSING THEN
6031: retcode := -1;
6032: errbuf := 'Time Dimension is not populated for the entire collection range';
6033: bis_collection_utilities.wrapup(
6034: p_status => FALSE,
6035: p_count => 0,
6036: p_message => 'Load Calls summary package failed : Error : Time dimension is not populated',
6037: p_period_from => g_collect_start_date,

Line 6043: bis_collection_utilities.wrapup(

6039: WHEN G_CHILD_PROCESS_ISSUE THEN
6040: clean_up;
6041: retcode := SQLCODE;
6042: errbuf := SQLERRM;
6043: bis_collection_utilities.wrapup(
6044: p_status => FALSE,
6045: p_count => 0,
6046: p_message => 'Load Calls summary package failed : error : ' || sqlerrm,
6047: p_period_from => g_collect_start_date,

Line 6053: bis_collection_utilities.wrapup(

6049: WHEN G_OLTP_CLEANUP_ISSUE THEN
6050: clean_up;
6051: --retcode := SQLCODE;
6052: --errbuf := SQLERRM;
6053: bis_collection_utilities.wrapup(
6054: p_status => FALSE,
6055: p_count => 0,
6056: p_message => 'Update Calls summary package failed in OLTP cleanup : error : ' || g_errbuf,
6057: p_period_from => g_collect_start_date,

Line 6063: bis_collection_utilities.wrapup(

6059: WHEN OTHERS THEN
6060: clean_up;
6061: retcode := SQLCODE;
6062: errbuf := SQLERRM;
6063: bis_collection_utilities.wrapup(
6064: p_status => FALSE,
6065: p_count => 0,
6066: p_message => 'Load Calls summary package failed : error : ' || sqlerrm,
6067: p_period_from => g_collect_start_date,