APPS.BSC_AW_DBMS_AW dependencies on BSC_AW_UTILITY

Line 7: bsc_aw_utility.log_s('@@ '||p_stmt);

3:
4: procedure execute(p_stmt varchar2) is
5: Begin
6: if g_debug then
7: bsc_aw_utility.log_s('@@ '||p_stmt);
8: bsc_aw_utility.log_s(' (S:'||bsc_aw_utility.get_time);
9: end if;
10: dbms_aw.interp_silent(p_stmt);
11: if g_debug then

Line 8: bsc_aw_utility.log_s(' (S:'||bsc_aw_utility.get_time);

4: procedure execute(p_stmt varchar2) is
5: Begin
6: if g_debug then
7: bsc_aw_utility.log_s('@@ '||p_stmt);
8: bsc_aw_utility.log_s(' (S:'||bsc_aw_utility.get_time);
9: end if;
10: dbms_aw.interp_silent(p_stmt);
11: if g_debug then
12: bsc_aw_utility.log(',E:'||bsc_aw_utility.get_time||')');

Line 12: bsc_aw_utility.log(',E:'||bsc_aw_utility.get_time||')');

8: bsc_aw_utility.log_s(' (S:'||bsc_aw_utility.get_time);
9: end if;
10: dbms_aw.interp_silent(p_stmt);
11: if g_debug then
12: bsc_aw_utility.log(',E:'||bsc_aw_utility.get_time||')');
13: end if;
14: Exception when others then
15: if bsc_aw_utility.is_sqlerror(sqlcode,'ignore') then
16: if g_debug then

Line 15: if bsc_aw_utility.is_sqlerror(sqlcode,'ignore') then

11: if g_debug then
12: bsc_aw_utility.log(',E:'||bsc_aw_utility.get_time||')');
13: end if;
14: Exception when others then
15: if bsc_aw_utility.is_sqlerror(sqlcode,'ignore') then
16: if g_debug then
17: bsc_aw_utility.log('Exception '||sqlcode||' ignored');
18: end if;
19: else

Line 17: bsc_aw_utility.log('Exception '||sqlcode||' ignored');

13: end if;
14: Exception when others then
15: if bsc_aw_utility.is_sqlerror(sqlcode,'ignore') then
16: if g_debug then
17: bsc_aw_utility.log('Exception '||sqlcode||' ignored');
18: end if;
19: else
20: bsc_aw_utility.log('Exception in execute '||p_stmt||' '||sqlerrm);
21: raise;

Line 20: bsc_aw_utility.log('Exception in execute '||p_stmt||' '||sqlerrm);

16: if g_debug then
17: bsc_aw_utility.log('Exception '||sqlcode||' ignored');
18: end if;
19: else
20: bsc_aw_utility.log('Exception in execute '||p_stmt||' '||sqlerrm);
21: raise;
22: end if;
23: End;
24:

Line 31: bsc_aw_utility.log('This error can be ignored');

27: Begin
28: execute(p_stmt);
29: Exception when others then
30: if g_debug then
31: bsc_aw_utility.log('This error can be ignored');
32: end if;
33: End;
34:
35: --if we need the output from aw of executing a command

Line 42: bsc_aw_utility.log_s('@@ '||p_stmt);

38: l_output varchar2(10000);
39: l_length number;
40: Begin
41: if g_debug then
42: bsc_aw_utility.log_s('@@ '||p_stmt);
43: bsc_aw_utility.log_s(' (S:'||bsc_aw_utility.get_time);
44: end if;
45: l_length:=10000;
46: l_clob:=dbms_aw.interp(p_stmt);

Line 43: bsc_aw_utility.log_s(' (S:'||bsc_aw_utility.get_time);

39: l_length number;
40: Begin
41: if g_debug then
42: bsc_aw_utility.log_s('@@ '||p_stmt);
43: bsc_aw_utility.log_s(' (S:'||bsc_aw_utility.get_time);
44: end if;
45: l_length:=10000;
46: l_clob:=dbms_aw.interp(p_stmt);
47: dbms_lob.read(l_clob,l_length,1,l_output);

Line 49: bsc_aw_utility.log(',E:'||bsc_aw_utility.get_time||'), output='||l_output);

45: l_length:=10000;
46: l_clob:=dbms_aw.interp(p_stmt);
47: dbms_lob.read(l_clob,l_length,1,l_output);
48: if g_debug then
49: bsc_aw_utility.log(',E:'||bsc_aw_utility.get_time||'), output='||l_output);
50: end if;
51: l_output:=ltrim(rtrim(l_output));
52: return l_output;
53: Exception when others then

Line 54: if bsc_aw_utility.is_sqlerror(sqlcode,'ignore') then

50: end if;
51: l_output:=ltrim(rtrim(l_output));
52: return l_output;
53: Exception when others then
54: if bsc_aw_utility.is_sqlerror(sqlcode,'ignore') then
55: if g_debug then
56: bsc_aw_utility.log('Exception '||sqlcode||' ignored');
57: end if;
58: else

Line 56: bsc_aw_utility.log('Exception '||sqlcode||' ignored');

52: return l_output;
53: Exception when others then
54: if bsc_aw_utility.is_sqlerror(sqlcode,'ignore') then
55: if g_debug then
56: bsc_aw_utility.log('Exception '||sqlcode||' ignored');
57: end if;
58: else
59: bsc_aw_utility.log('Exception in interp '||p_stmt||' '||sqlerrm);
60: raise;

Line 59: bsc_aw_utility.log('Exception in interp '||p_stmt||' '||sqlerrm);

55: if g_debug then
56: bsc_aw_utility.log('Exception '||sqlcode||' ignored');
57: end if;
58: else
59: bsc_aw_utility.log('Exception in interp '||p_stmt||' '||sqlerrm);
60: raise;
61: end if;
62: End;
63:

Line 67: g_debug:=bsc_aw_utility.g_debug;

63:
64:
65: procedure init_all is
66: Begin
67: g_debug:=bsc_aw_utility.g_debug;
68: Exception when others then
69: null;
70: End;
71: