51: PROCEDURE debug( debug_str VARCHAR2) IS
52: BEGIN
53: g_debug := fnd_profile.value('BIC_DEBUG');
54: FND_LOG.G_CURRENT_RUNTIME_LEVEL := 1;
55: FND_GLOBAL.APPS_INITIALIZE (fnd_global.user_id,fnd_global.resp_id,fnd_global.prog_appl_id);
56: if g_debug = 'Y' then
57: --This is to meet 11.5.10 logging standards
58: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
59:
2222: end if;
2223: write_log('after set_periods_exist ' || g_period_start_date || ' ' || g_period_end_date );
2224: ----------------------------------------------------------------------------
2225: -- initialize global variables for who columns
2226: g_last_updated_by := fnd_global.user_id ;
2227: g_created_by := fnd_global.user_id ;
2228: g_last_update_login := fnd_global.login_id ;
2229: g_request_id := fnd_global.conc_request_id;
2230: g_program_application_id := fnd_global.prog_appl_id ;
2223: write_log('after set_periods_exist ' || g_period_start_date || ' ' || g_period_end_date );
2224: ----------------------------------------------------------------------------
2225: -- initialize global variables for who columns
2226: g_last_updated_by := fnd_global.user_id ;
2227: g_created_by := fnd_global.user_id ;
2228: g_last_update_login := fnd_global.login_id ;
2229: g_request_id := fnd_global.conc_request_id;
2230: g_program_application_id := fnd_global.prog_appl_id ;
2231: g_program_id := fnd_global.conc_program_id;
2224: ----------------------------------------------------------------------------
2225: -- initialize global variables for who columns
2226: g_last_updated_by := fnd_global.user_id ;
2227: g_created_by := fnd_global.user_id ;
2228: g_last_update_login := fnd_global.login_id ;
2229: g_request_id := fnd_global.conc_request_id;
2230: g_program_application_id := fnd_global.prog_appl_id ;
2231: g_program_id := fnd_global.conc_program_id;
2232: -- global variables initialization complete
2225: -- initialize global variables for who columns
2226: g_last_updated_by := fnd_global.user_id ;
2227: g_created_by := fnd_global.user_id ;
2228: g_last_update_login := fnd_global.login_id ;
2229: g_request_id := fnd_global.conc_request_id;
2230: g_program_application_id := fnd_global.prog_appl_id ;
2231: g_program_id := fnd_global.conc_program_id;
2232: -- global variables initialization complete
2233: g_proc_name := 'Extract_Main';
2226: g_last_updated_by := fnd_global.user_id ;
2227: g_created_by := fnd_global.user_id ;
2228: g_last_update_login := fnd_global.login_id ;
2229: g_request_id := fnd_global.conc_request_id;
2230: g_program_application_id := fnd_global.prog_appl_id ;
2231: g_program_id := fnd_global.conc_program_id;
2232: -- global variables initialization complete
2233: g_proc_name := 'Extract_Main';
2234: -- extracting periods for all measures
2227: g_created_by := fnd_global.user_id ;
2228: g_last_update_login := fnd_global.login_id ;
2229: g_request_id := fnd_global.conc_request_id;
2230: g_program_application_id := fnd_global.prog_appl_id ;
2231: g_program_id := fnd_global.conc_program_id;
2232: -- global variables initialization complete
2233: g_proc_name := 'Extract_Main';
2234: -- extracting periods for all measures
2235: if nvl(g_delete_flag,'N') = 'Y' then