APPS.BIX_SESSION_SUMMARY_PKG dependencies on BIS_COLLECTION_UTILITIES

Line 45: BIS_COLLECTION_UTILITIES.log(p_msg);

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

Line 76: IF (BIS_COLLECTION_UTILITIES.SETUP('BIX_AGENT_SESSION_F') = FALSE) THEN

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

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

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

Line 1827: bis_collection_utilities.wrapup(

1823: Truncate_Table('BIX_AGENT_SESSION_STG');
1824: write_log('Done truncating the table bix_agent_session_stg');
1825:
1826: write_log('Calling procedure WRAPUP');
1827: bis_collection_utilities.wrapup(
1828: p_status => TRUE,
1829: p_count => g_rows_ins_upd,
1830: p_message => NULL,
1831: p_period_from => g_collect_start_date,

Line 1836: bis_collection_utilities.wrapup(

1832: p_period_to => g_collect_end_date);
1833:
1834: EXCEPTION
1835: WHEN G_PARAM_MISMATCH THEN
1836: bis_collection_utilities.wrapup(
1837: p_status => FALSE,
1838: p_count => 0,
1839: p_message => '0 rows collected : collect start date cannot be greater than collection end date',
1840: p_period_from => g_collect_start_date,

Line 1845: bis_collection_utilities.wrapup(

1841: p_period_to => g_collect_end_date);
1842: WHEN G_TIME_DIM_MISSING THEN
1843: retcode := -1;
1844: errbuf := 'Time Dimension is not populated for the entire collection range';
1845: bis_collection_utilities.wrapup(
1846: p_status => FALSE,
1847: p_count => 0,
1848: p_message => 'eMail summary package failed : Error : Time dimension is not populated',
1849: p_period_from => g_collect_start_date,

Line 1855: bis_collection_utilities.wrapup(

1851: WHEN G_CHILD_PROCESS_ISSUE THEN
1852: clean_up;
1853: retcode := SQLCODE;
1854: errbuf := SQLERRM;
1855: bis_collection_utilities.wrapup(
1856: p_status => FALSE,
1857: p_count => 0,
1858: p_message => 'eMail summary package failed : error : ' || sqlerrm,
1859: p_period_from => g_collect_start_date,

Line 1865: bis_collection_utilities.wrapup(

1861: WHEN OTHERS THEN
1862: clean_up;
1863: retcode := SQLCODE;
1864: errbuf := SQLERRM;
1865: bis_collection_utilities.wrapup(
1866: p_status => FALSE,
1867: p_count => 0,
1868: p_message => 'eMail summary package failed : error : ' || sqlerrm,
1869: p_period_from => g_collect_start_date,

Line 1885: BIS_COLLECTION_UTILITIES.get_last_refresh_dates('BIX_AGENT_SESSION_F',

1881: BEGIN
1882: init;
1883: write_log('End procedure init');
1884:
1885: BIS_COLLECTION_UTILITIES.get_last_refresh_dates('BIX_AGENT_SESSION_F',
1886: l_last_start_date,
1887: l_last_end_date,
1888: l_last_period_from,
1889: l_last_period_to);