APPS.BIX_EMAILS_SUMMARY_PKG dependencies on BIS_COLLECTION_UTILITIES

Line 63: BIS_COLLECTION_UTILITIES.log(p_msg);

59: BEGIN
60:
61:
62: IF (g_debug_flag = 'Y') THEN
63: BIS_COLLECTION_UTILITIES.log(p_msg);
64: END IF;
65: EXCEPTION
66: WHEN OTHERS THEN
67: RAISE;

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

91: l_status VARCHAR2(30);
92: l_industry VARCHAR2(30);
93: BEGIN
94:
95: IF (BIS_COLLECTION_UTILITIES.SETUP('BIX_EMAIL_DETAILS_F') = FALSE) THEN
96: RAISE_APPLICATION_ERROR(-20000, 'BIS_COLLECTION_UTILITIES.setup has failed');
97: END IF;
98:
99: write_log('Start of the procedure init at : ' || to_char(sysdate, 'mm/dd/yyyy hh24:mi:ss'));

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

92: l_industry VARCHAR2(30);
93: BEGIN
94:
95: IF (BIS_COLLECTION_UTILITIES.SETUP('BIX_EMAIL_DETAILS_F') = FALSE) THEN
96: RAISE_APPLICATION_ERROR(-20000, 'BIS_COLLECTION_UTILITIES.setup has failed');
97: END IF;
98:
99: write_log('Start of the procedure init at : ' || to_char(sysdate, 'mm/dd/yyyy hh24:mi:ss'));
100:

Line 6118: bis_collection_utilities.wrapup(

6114:
6115:
6116: /* Insert the status into collect log table */
6117: write_log('Calling procedure WRAPUP');
6118: bis_collection_utilities.wrapup(
6119: p_status => TRUE,
6120: p_count => g_rows_ins_upd,
6121: p_message => NULL,
6122: p_period_from => g_collect_start_date,

Line 6130: bis_collection_utilities.wrapup(

6126: write_log('Finished Procedure BIX_EMALS_SUMMARY_PKG with success at : ' || to_char(sysdate, 'mm/dd/yyyy hh24:mi:ss'));
6127:
6128: EXCEPTION
6129: WHEN G_PARAM_MISMATCH THEN
6130: bis_collection_utilities.wrapup(
6131: p_status => FALSE,
6132: p_count => 0,
6133: p_message => '0 rows collected : wait for at least half hour between two executions of this program',
6134: p_period_from => g_collect_start_date,

Line 6139: bis_collection_utilities.wrapup(

6135: p_period_to => g_collect_end_date);
6136: WHEN G_TIME_DIM_MISSING THEN
6137: retcode := -1;
6138: errbuf := 'Time Dimension is not populated for the entire collection range';
6139: bis_collection_utilities.wrapup(
6140: p_status => FALSE,
6141: p_count => 0,
6142: p_message => 'eMail summary package failed : Error : Time dimension is not populated',
6143: p_period_from => g_collect_start_date,

Line 6149: bis_collection_utilities.wrapup(

6145: WHEN G_CHILD_PROCESS_ISSUE THEN
6146: clean_up;
6147: retcode := SQLCODE;
6148: errbuf := SQLERRM;
6149: bis_collection_utilities.wrapup(
6150: p_status => FALSE,
6151: p_count => 0,
6152: p_message => 'eMail summary package failed : error : ' || sqlerrm,
6153: p_period_from => g_collect_start_date,

Line 6159: bis_collection_utilities.wrapup(

6155: WHEN OTHERS THEN
6156: clean_up;
6157: retcode := SQLCODE;
6158: errbuf := SQLERRM;
6159: bis_collection_utilities.wrapup(
6160: p_status => FALSE,
6161: p_count => 0,
6162: p_message => 'eMail summary package failed : error : ' || sqlerrm,
6163: p_period_from => g_collect_start_date,

Line 6257: BIS_COLLECTION_UTILITIES.get_last_refresh_dates('BIX_EMAIL_DETAILS_F',

6253:
6254:
6255:
6256:
6257: BIS_COLLECTION_UTILITIES.get_last_refresh_dates('BIX_EMAIL_DETAILS_F',
6258: l_last_start_date,
6259: l_last_end_date,
6260: l_last_period_from,
6261: l_last_period_to);