APPS.BIM_BUDGETS_DENORM_PKG dependencies on BIS_COLLECTION_UTILITIES

Line 22: IF NOT bis_collection_utilities.setup('BIM_BUDGET_DENORM') THEN

18: l_global_start_date := l_global_date;
19:
20: BEGIN
21: /* Set up the Object */
22: IF NOT bis_collection_utilities.setup('BIM_BUDGET_DENORM') THEN
23: bis_collection_utilities.log('Object Not Setup Properly ');
24: END IF;
25:
26: bis_collection_utilities.get_last_refresh_dates('BIM_BUDGET_DENORM'

Line 23: bis_collection_utilities.log('Object Not Setup Properly ');

19:
20: BEGIN
21: /* Set up the Object */
22: IF NOT bis_collection_utilities.setup('BIM_BUDGET_DENORM') THEN
23: bis_collection_utilities.log('Object Not Setup Properly ');
24: END IF;
25:
26: bis_collection_utilities.get_last_refresh_dates('BIM_BUDGET_DENORM'
27: ,l_start_date,l_end_date,l_period_from,l_period_to);

Line 26: bis_collection_utilities.get_last_refresh_dates('BIM_BUDGET_DENORM'

22: IF NOT bis_collection_utilities.setup('BIM_BUDGET_DENORM') THEN
23: bis_collection_utilities.log('Object Not Setup Properly ');
24: END IF;
25:
26: bis_collection_utilities.get_last_refresh_dates('BIM_BUDGET_DENORM'
27: ,l_start_date,l_end_date,l_period_from,l_period_to);
28:
29: EXCEPTION
30: WHEN NO_DATA_FOUND THEN

Line 32: bis_collection_utilities.log('First time running the concurrent program ');

28:
29: EXCEPTION
30: WHEN NO_DATA_FOUND THEN
31: l_end_date := NULL;
32: bis_collection_utilities.log('First time running the concurrent program ');
33: WHEN OTHERS THEN
34: bis_collection_utilities.log('program '|| sqlerrm(sqlcode));
35: END;
36:

Line 34: bis_collection_utilities.log('program '|| sqlerrm(sqlcode));

30: WHEN NO_DATA_FOUND THEN
31: l_end_date := NULL;
32: bis_collection_utilities.log('First time running the concurrent program ');
33: WHEN OTHERS THEN
34: bis_collection_utilities.log('program '|| sqlerrm(sqlcode));
35: END;
36:
37: /* End of the code for checking the data will be loaded for the first time or not. */
38:

Line 159: bis_collection_utilities.log('Truncating the Budget Denorm Table ');

155:
156: IF p_load_type = 'F' THEN
157:
158: --it is a call for First/Inital load, then truncate the denorm table first
159: bis_collection_utilities.log('Truncating the Budget Denorm Table ');
160:
161: l_return := fnd_installation.get_app_info('BIM', l_status, l_industry, l_schema);
162:
163: Execute Immediate 'Truncate Table '||l_schema||'.bim_i_budgets_denorm';

Line 165: BIS_COLLECTION_UTILITIES.deleteLogForObject('BIM_BUDGET_DENORM');

161: l_return := fnd_installation.get_app_info('BIM', l_status, l_industry, l_schema);
162:
163: Execute Immediate 'Truncate Table '||l_schema||'.bim_i_budgets_denorm';
164:
165: BIS_COLLECTION_UTILITIES.deleteLogForObject('BIM_BUDGET_DENORM');
166:
167: ELSE
168: /* This piece of code is for the budgets that have changed from one parent to another. */
169: DELETE bim_i_budgets_denorm

Line 287: bis_collection_utilities.log('Budget Denorm Concurrent Program Completed Succesfully ');

283: where a.object_id = b.parent_object_id
284: and a.object_type=b.object_type
285: ));
286: COMMIT;
287: bis_collection_utilities.log('Budget Denorm Concurrent Program Completed Succesfully ');
288: bis_collection_utilities.wrapup(p_status => TRUE
289: ,p_count => sql%rowcount
290: ,p_period_from => l_temp_start_date
291: ,p_period_to => sysdate

Line 288: bis_collection_utilities.wrapup(p_status => TRUE

284: and a.object_type=b.object_type
285: ));
286: COMMIT;
287: bis_collection_utilities.log('Budget Denorm Concurrent Program Completed Succesfully ');
288: bis_collection_utilities.wrapup(p_status => TRUE
289: ,p_count => sql%rowcount
290: ,p_period_from => l_temp_start_date
291: ,p_period_to => sysdate
292: );