APPS.BIX_EMAILS_LOAD_PKG dependencies on BIS_COLLECTION_UTILITIES

Line 43: BIS_COLLECTION_UTILITIES.log(p_msg);

39: PROCEDURE Write_Log (p_msg IN VARCHAR2) IS
40: BEGIN
41:
42: IF (g_debug_flag = 'Y') THEN
43: BIS_COLLECTION_UTILITIES.log(p_msg);
44:
45: END IF;
46: EXCEPTION
47: WHEN OTHERS THEN

Line 77: IF (BIS_COLLECTION_UTILITIES.SETUP('BIX_EMAIL_DETAILS_F') = FALSE) THEN

73: l_status VARCHAR2(30);
74: l_industry VARCHAR2(30);
75: BEGIN
76:
77: IF (BIS_COLLECTION_UTILITIES.SETUP('BIX_EMAIL_DETAILS_F') = FALSE) THEN
78: RAISE_APPLICATION_ERROR(-20000, 'BIS_COLLECTION_UTILITIES.setup has failed');
79: END IF;
80:
81: write_log('Start of the procedure init at : ' || to_char(sysdate, 'mm/dd/yyyy hh24:mi:ss'));

Line 78: RAISE_APPLICATION_ERROR(-20000, 'BIS_COLLECTION_UTILITIES.setup has failed');

74: l_industry VARCHAR2(30);
75: BEGIN
76:
77: IF (BIS_COLLECTION_UTILITIES.SETUP('BIX_EMAIL_DETAILS_F') = FALSE) THEN
78: RAISE_APPLICATION_ERROR(-20000, 'BIS_COLLECTION_UTILITIES.setup has failed');
79: END IF;
80:
81: write_log('Start of the procedure init at : ' || to_char(sysdate, 'mm/dd/yyyy hh24:mi:ss'));
82:

Line 118: BIS_COLLECTION_UTILITIES.deleteLogForObject('BIX_EMAIL_DETAILS_F');

114:
115: write_log('BIX Schema : ' || g_bix_schema);
116:
117: write_log('Truncating the table bix_email_details_f and bix_interactions_temp');
118: BIS_COLLECTION_UTILITIES.deleteLogForObject('BIX_EMAIL_DETAILS_F');
119: Truncate_Table('BIX_EMAIL_DETAILS_F');
120: Truncate_Table('BIX_INTERACTIONS_TEMP');
121: write_log('Done truncating the table bix_email_details_f and bix_interactions_temp');
122:

Line 530: BIS_COLLECTION_UTILITIES.deleteLogForObject('BIX_EMAIL_DETAILS_F');

526: BEGIN
527: write_log('Start of the procedure clean_up at ' || to_char(sysdate,'mm/dd/yyyy hh24:mi:ss'));
528:
529: write_log('Truncating the table bix_email_details_f and bix_interactions_temp');
530: BIS_COLLECTION_UTILITIES.deleteLogForObject('BIX_EMAIL_DETAILS_F');
531: Truncate_Table('BIX_EMAIL_DETAILS_F');
532: Truncate_Table('BIX_INTERACTIONS_TEMP');
533: write_log('Done truncating the table bix_email_details_f and bix_interactions_temp');
534:

Line 3046: bis_collection_utilities.wrapup(

3042: granularity => 'GLOBAL');
3043:
3044: /* Insert the status into collect log table */
3045: write_log('Calling procedure WRAPUP');
3046: bis_collection_utilities.wrapup(
3047: p_status => TRUE,
3048: p_count => g_rows_ins_upd,
3049: p_message => NULL,
3050: p_period_from => g_collect_start_date,

Line 3060: bis_collection_utilities.wrapup(

3056: EXCEPTION
3057: WHEN G_TIME_DIM_MISSING THEN
3058: retcode := -1;
3059: errbuf := 'Time Dimension is not populated for the entire collection range';
3060: bis_collection_utilities.wrapup(
3061: p_status => FALSE,
3062: p_count => 0,
3063: p_message => 'eMail summary package failed : Error : Time dimension is not populated',
3064: p_period_from => g_collect_start_date,

Line 3070: bis_collection_utilities.wrapup(

3066: WHEN OTHERS THEN
3067: clean_up;
3068: retcode := SQLCODE;
3069: errbuf := SQLERRM;
3070: bis_collection_utilities.wrapup(
3071: p_status => FALSE,
3072: p_count => 0,
3073: p_message => 'eMail summary package failed : error : ' || sqlerrm,
3074: p_period_from => g_collect_start_date,