APPS.BIM_KPI_FACT dependencies on AMS_UTILITY_PVT

Line 195: ams_utility_pvt.write_conc_log('BIM_R_KPI_FACT: POPULATE START');

191: l_month_code := 'MONTH';
192: l_quarter_code := 'QUARTER';
193: l_year_code := 'YEAR';
194:
195: ams_utility_pvt.write_conc_log('BIM_R_KPI_FACT: POPULATE START');
196: l_return := fnd_installation.get_app_info('BIM', l_status, l_industry, l_schema);
197: l_date := sysdate - 1;
198: l_org_id := 204;
199: l_cur_year_start_date := BIM_SET_OF_BOOKS.GET_FISCAL_YEAR_START(l_date, l_org_id);

Line 218: ams_utility_pvt.write_conc_log('BIM_R_KPI_FACT: INSERT START');

214: --l_days := l_days+1;
215: select next_day(trunc(l_date)-14, TO_NUMBER(to_char(to_date('01/09/2004', 'DD/MM/RRRR'), 'DD'))) into l_pre_week_start_date from dual;
216: l_pre_week_end_date := l_pre_week_start_date+l_days;
217:
218: ams_utility_pvt.write_conc_log('BIM_R_KPI_FACT: INSERT START');
219:
220: ams_utility_pvt.debug_message('POPULATE BIM_R_KPI_FACT START');
221:
222: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_schema||'.bim_r_kpi_facts';

Line 220: ams_utility_pvt.debug_message('POPULATE BIM_R_KPI_FACT START');

216: l_pre_week_end_date := l_pre_week_start_date+l_days;
217:
218: ams_utility_pvt.write_conc_log('BIM_R_KPI_FACT: INSERT START');
219:
220: ams_utility_pvt.debug_message('POPULATE BIM_R_KPI_FACT START');
221:
222: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_schema||'.bim_r_kpi_facts';
223:
224:

Line 2390: ams_utility_pvt.write_conc_log('BIM_R_KPI_FACT: INSERT END');

2386: a.status
2387: ) inner;
2388: COMMIT;
2389:
2390: ams_utility_pvt.write_conc_log('BIM_R_KPI_FACT: INSERT END');
2391:
2392: UPDATE bim_r_kpi_facts
2393: SET cost_cur_period=0
2394: ,cost_pre_period=0

Line 2398: ams_utility_pvt.debug_message('POPULATE BIM_R_KPI_FACT END');

2394: ,cost_pre_period=0
2395: WHERE status = 'CANCELLED';
2396: COMMIT;
2397:
2398: ams_utility_pvt.debug_message('POPULATE BIM_R_KPI_FACT END');
2399:
2400: DELETE FROM bim_rep_history
2401: WHERE object='KPILD';
2402: INSERT INTO

Line 2419: ams_utility_pvt.write_conc_log('BIM_R_KPI_FACT: POPULATE END');

2415: 'KPILD',
2416: sysdate);
2417: COMMIT;
2418:
2419: ams_utility_pvt.write_conc_log('BIM_R_KPI_FACT: POPULATE END');
2420:
2421: ams_utility_pvt.write_conc_log('End of KPI Facts Program');
2422:
2423: EXCEPTION

Line 2421: ams_utility_pvt.write_conc_log('End of KPI Facts Program');

2417: COMMIT;
2418:
2419: ams_utility_pvt.write_conc_log('BIM_R_KPI_FACT: POPULATE END');
2420:
2421: ams_utility_pvt.write_conc_log('End of KPI Facts Program');
2422:
2423: EXCEPTION
2424:
2425: WHEN OTHERS THEN

Line 2426: ams_utility_pvt.write_conc_log('BIM_R_KPI_FACT--POPULATE: Error occured '||sqlerrm(sqlcode));

2422:
2423: EXCEPTION
2424:
2425: WHEN OTHERS THEN
2426: ams_utility_pvt.write_conc_log('BIM_R_KPI_FACT--POPULATE: Error occured '||sqlerrm(sqlcode));
2427: ERRBUF := sqlerrm(sqlcode);
2428: RETCODE := sqlcode;
2429:
2430: -- dbms_output.put_line('END OF POPULATING BIM_R_KPI_FACT');