eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BSC_DBI_CALENDAR dependencies on BSC_IM_UTILS

Line 186: if BSC_IM_UTILS.parse_values(p_option_string,',',g_options,g_number_options)=false then

182: l_refresh_mode number;
183: --
184: Begin
185: p_error_message:=null;
186: if BSC_IM_UTILS.parse_values(p_option_string,',',g_options,g_number_options)=false then
187: raise g_exception;
188: end if;
189: init_all;
190: if check_for_dbi then

Line 192: if BSC_IM_UTILS.get_option_value(g_options,g_number_options,'FULL REFRESH')='Y' then

188: end if;
189: init_all;
190: if check_for_dbi then
191: ----
192: if BSC_IM_UTILS.get_option_value(g_options,g_number_options,'FULL REFRESH')='Y' then
193: l_refresh_mode:=1;
194: else
195: l_refresh_mode:=check_for_inc_refresh;
196: end if;

Line 2570: l_owner:=BSC_IM_UTILS.get_bsc_owner;

2566: Begin
2567: if g_debug then
2568: write_to_log_file_n('In analyze_tables'||get_time);
2569: end if;
2570: l_owner:=BSC_IM_UTILS.get_bsc_owner;
2571: BSC_IM_UTILS.analyze_object('BSC_SYS_PERIODS',l_owner,null,null,null);
2572: BSC_IM_UTILS.analyze_object('BSC_DB_CALENDAR',l_owner,null,null,null);
2573: if g_debug then
2574: write_to_log_file_n('Done analyze_tables'||get_time);

Line 2571: BSC_IM_UTILS.analyze_object('BSC_SYS_PERIODS',l_owner,null,null,null);

2567: if g_debug then
2568: write_to_log_file_n('In analyze_tables'||get_time);
2569: end if;
2570: l_owner:=BSC_IM_UTILS.get_bsc_owner;
2571: BSC_IM_UTILS.analyze_object('BSC_SYS_PERIODS',l_owner,null,null,null);
2572: BSC_IM_UTILS.analyze_object('BSC_DB_CALENDAR',l_owner,null,null,null);
2573: if g_debug then
2574: write_to_log_file_n('Done analyze_tables'||get_time);
2575: end if;

Line 2572: BSC_IM_UTILS.analyze_object('BSC_DB_CALENDAR',l_owner,null,null,null);

2568: write_to_log_file_n('In analyze_tables'||get_time);
2569: end if;
2570: l_owner:=BSC_IM_UTILS.get_bsc_owner;
2571: BSC_IM_UTILS.analyze_object('BSC_SYS_PERIODS',l_owner,null,null,null);
2572: BSC_IM_UTILS.analyze_object('BSC_DB_CALENDAR',l_owner,null,null,null);
2573: if g_debug then
2574: write_to_log_file_n('Done analyze_tables'||get_time);
2575: end if;
2576: Exception when others then

Line 2586: if BSC_IM_UTILS.get_option_value(g_options,g_number_options,'DEBUG LOG')='Y' then

2582: procedure init_all is
2583: cursor c1 is select language_code from FND_LANGUAGES where INSTALLED_FLAG in ('I', 'B');
2584: Begin
2585: g_who:=0;
2586: if BSC_IM_UTILS.get_option_value(g_options,g_number_options,'DEBUG LOG')='Y' then
2587: g_debug:=true;
2588: BSC_IM_UTILS.open_file('TEST');
2589: end if;
2590: g_debug:=true;

Line 2588: BSC_IM_UTILS.open_file('TEST');

2584: Begin
2585: g_who:=0;
2586: if BSC_IM_UTILS.get_option_value(g_options,g_number_options,'DEBUG LOG')='Y' then
2587: g_debug:=true;
2588: BSC_IM_UTILS.open_file('TEST');
2589: end if;
2590: g_debug:=true;
2591: g_src_lang:=USERENV('LANG');
2592: g_num_lang:=1;

Line 2618: BSC_IM_UTILS.write_to_log_file(p_message);

2614: End;
2615:
2616: procedure write_to_log_file(p_message varchar2) is
2617: Begin
2618: BSC_IM_UTILS.write_to_log_file(p_message);
2619: Exception when others then
2620: BSC_IM_UTILS.g_status_message:=sqlerrm;
2621: null;
2622: End;

Line 2620: BSC_IM_UTILS.g_status_message:=sqlerrm;

2616: procedure write_to_log_file(p_message varchar2) is
2617: Begin
2618: BSC_IM_UTILS.write_to_log_file(p_message);
2619: Exception when others then
2620: BSC_IM_UTILS.g_status_message:=sqlerrm;
2621: null;
2622: End;
2623:
2624: procedure write_to_log_file_n(p_message varchar2) is

Line 2629: BSC_IM_UTILS.g_status_message:=sqlerrm;

2625: begin
2626: write_to_log_file(' ');
2627: write_to_log_file(p_message);
2628: Exception when others then
2629: BSC_IM_UTILS.g_status_message:=sqlerrm;
2630: null;
2631: end;
2632:
2633: function get_time return varchar2 is

Line 2635: return BSC_IM_UTILS.get_time;

2631: end;
2632:
2633: function get_time return varchar2 is
2634: begin
2635: return BSC_IM_UTILS.get_time;
2636: Exception when others then
2637: BSC_IM_UTILS.g_status_message:=sqlerrm;
2638: null;
2639: End;

Line 2637: BSC_IM_UTILS.g_status_message:=sqlerrm;

2633: function get_time return varchar2 is
2634: begin
2635: return BSC_IM_UTILS.get_time;
2636: Exception when others then
2637: BSC_IM_UTILS.g_status_message:=sqlerrm;
2638: null;
2639: End;
2640:
2641: function get_periodicity_nextval return number is

Line 2647: BSC_IM_UTILS.g_status_message:=sqlerrm;

2643: Begin
2644: select bsc_sys_periodicity_id_s.nextval into l_seqval from dual;
2645: return l_seqval;
2646: Exception when others then
2647: BSC_IM_UTILS.g_status_message:=sqlerrm;
2648: raise;
2649: End;
2650:
2651: function get_calendar_nextval return number is

Line 2657: BSC_IM_UTILS.g_status_message:=sqlerrm;

2653: Begin
2654: select bsc_sys_calendar_id_s.nextval into l_seqval from dual;
2655: return l_seqval;
2656: Exception when others then
2657: BSC_IM_UTILS.g_status_message:=sqlerrm;
2658: raise;
2659: End;
2660:
2661: /*

Line 2691: BSC_IM_UTILS.g_status_message:=sqlerrm;

2687: l_day365:=p_this_date-l_start_date+1;
2688: end if;
2689: return l_day365;
2690: Exception when others then
2691: BSC_IM_UTILS.g_status_message:=sqlerrm;
2692: raise;
2693: End;
2694:
2695: procedure calculate_day365(p_mode varchar2,p_cal_id number) is

Line 2973: BSC_IM_UTILS.g_status_message:=sqlerrm;

2969: write_to_log_file_n('g_ent_start_date NULL. fatal...');
2970: raise g_exception;
2971: end if;
2972: Exception when others then
2973: BSC_IM_UTILS.g_status_message:=sqlerrm;
2974: write_to_log_file_n('Error in get_ent_cal_start_date '||g_status_message||get_time);
2975: raise;
2976: End;
2977:

Line 3038: BSC_IM_UTILS.g_status_message:=sqlerrm;

3034: write_to_log_file_n('g_445_start_date NULL. fatal...');
3035: raise g_exception;
3036: end if;
3037: Exception when others then
3038: BSC_IM_UTILS.g_status_message:=sqlerrm;
3039: write_to_log_file_n('Error in get_445_cal_start_date '||g_status_message||get_time);
3040: raise;
3041: End;
3042:

Line 3098: BSC_IM_UTILS.g_status_message:=sqlerrm;

3094: write_to_log_file_n('g_greg_start_date NULL. fatal...');
3095: raise g_exception;
3096: end if;
3097: Exception when others then
3098: BSC_IM_UTILS.g_status_message:=sqlerrm;
3099: write_to_log_file_n('Error in get_greg_cal_start_date '||g_status_message||get_time);
3100: raise;
3101: End;
3102:

Line 3124: BSC_IM_UTILS.g_status_message:=sqlerrm;

3120: write_to_log_file('l_name='||l_name);
3121: end if;
3122: return l_name;
3123: Exception when others then
3124: BSC_IM_UTILS.g_status_message:=sqlerrm;
3125: write_to_log_file_n('Error in get_bis_dim_long_name '||g_status_message||get_time);
3126: raise;
3127: End;
3128:

Line 3150: BSC_IM_UTILS.g_status_message:=sqlerrm;

3146: l_var:=p_lookup_code;
3147: end if;
3148: return l_var;
3149: Exception when others then
3150: BSC_IM_UTILS.g_status_message:=sqlerrm;
3151: write_to_log_file_n('Error in get_lookup_value '||g_status_message||get_time);
3152: raise;
3153: End;
3154: