APPS.BIX_CALL_LOAD_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 589: IF (BIS_COLLECTION_UTILITIES.SETUP('BIX_CALL_DETAILS_F') = FALSE) THEN

585: --write_log('Start of the procedure init at : ' ||
586: --to_char(sysdate, 'mm/dd/yyyy hh24:mi:ss'));
587: --END IF;
588:
589: IF (BIS_COLLECTION_UTILITIES.SETUP('BIX_CALL_DETAILS_F') = FALSE) THEN
590: RAISE_APPLICATION_ERROR(-20000,
591: 'BIS_COLLECTION_UTILITIES.setup has failed');
592: END IF;
593:

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

587: --END IF;
588:
589: IF (BIS_COLLECTION_UTILITIES.SETUP('BIX_CALL_DETAILS_F') = FALSE) THEN
590: RAISE_APPLICATION_ERROR(-20000,
591: 'BIS_COLLECTION_UTILITIES.setup has failed');
592: END IF;
593:
594:
595: --IF (g_debug_flag = 'Y') THEN

Line 5675: BIS_COLLECTION_UTILITIES.deleteLogForObject('BIX_CALL_DETAILS_F');

5671:
5672: errbuf := null;
5673: retcode := 0;
5674:
5675: BIS_COLLECTION_UTILITIES.deleteLogForObject('BIX_CALL_DETAILS_F');
5676:
5677: truncate_table('bix_medias_for_worker');
5678: truncate_table('BIX_CALL_DETAILS_STG');
5679: truncate_table('BIX_CALL_DETAILS_F');

Line 6021: bis_collection_utilities.wrapup(

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

Line 6037: bis_collection_utilities.wrapup(

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

Line 6048: bis_collection_utilities.wrapup(

6044: clean_up;
6045: --retcode := SQLCODE;
6046: retcode := -1;
6047: errbuf := SQLERRM;
6048: bis_collection_utilities.wrapup(
6049: p_status => FALSE,
6050: p_count => 0,
6051: p_message => 'Load Calls summary package failed : error : ' || sqlerrm,
6052: p_period_from => g_collect_start_date,

Line 6058: bis_collection_utilities.wrapup(

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

Line 6068: bis_collection_utilities.wrapup(

6064: WHEN OTHERS THEN
6065: clean_up;
6066: retcode := SQLCODE;
6067: errbuf := SQLERRM;
6068: bis_collection_utilities.wrapup(
6069: p_status => FALSE,
6070: p_count => 0,
6071: p_message => 'Load Calls summary package failed : error : ' || sqlerrm,
6072: p_period_from => g_collect_start_date,