APPS.BSC_AW_UTILITY dependencies on DBMS_LOCK

Line 1205: dbms_lock.sleep(p_sleep_time);

1201: sleep for 20+random(1 to 10)
1202: */
1203: procedure sleep(p_sleep_time integer,p_random_time integer) is
1204: Begin
1205: dbms_lock.sleep(p_sleep_time);
1206: if p_random_time is not null and p_random_time>0 then
1207: dbms_lock.sleep(get_random_number(p_random_time));
1208: end if;
1209: Exception when others then

Line 1207: dbms_lock.sleep(get_random_number(p_random_time));

1203: procedure sleep(p_sleep_time integer,p_random_time integer) is
1204: Begin
1205: dbms_lock.sleep(p_sleep_time);
1206: if p_random_time is not null and p_random_time>0 then
1207: dbms_lock.sleep(get_random_number(p_random_time));
1208: end if;
1209: Exception when others then
1210: log_n('Exception in sleep '||sqlerrm);
1211: raise;

Line 2015: l_flag:=dbms_lock.request(lockhandle=>l_lock_handle,timeout=>bsc_aw_utility.g_max_wait_time);

2011: l_lock_handle varchar2(200);
2012: l_flag integer;
2013: Begin
2014: l_lock_handle:=get_lock_handle(p_lock_name);
2015: l_flag:=dbms_lock.request(lockhandle=>l_lock_handle,timeout=>bsc_aw_utility.g_max_wait_time);
2016: if l_flag=1 then --timeout
2017: log('Timeout in dbms_lock.request('||p_lock_name||') ...');
2018: raise bsc_aw_utility.g_exception;
2019: end if;

Line 2017: log('Timeout in dbms_lock.request('||p_lock_name||') ...');

2013: Begin
2014: l_lock_handle:=get_lock_handle(p_lock_name);
2015: l_flag:=dbms_lock.request(lockhandle=>l_lock_handle,timeout=>bsc_aw_utility.g_max_wait_time);
2016: if l_flag=1 then --timeout
2017: log('Timeout in dbms_lock.request('||p_lock_name||') ...');
2018: raise bsc_aw_utility.g_exception;
2019: end if;
2020: Exception when others then
2021: log_n('Exception in get_db_lock '||sqlerrm);

Line 2030: l_flag:=dbms_lock.release(lockhandle=>l_lock_handle);

2026: l_lock_handle varchar2(2000);
2027: l_flag integer;
2028: Begin
2029: l_lock_handle:=get_lock_handle(p_lock_name);
2030: l_flag:=dbms_lock.release(lockhandle=>l_lock_handle);
2031: if l_flag=3 or l_flag=5 then --error
2032: log('Exception in dbms_lock.release. Return flag='||l_flag);
2033: raise bsc_aw_utility.g_exception;
2034: end if;

Line 2032: log('Exception in dbms_lock.release. Return flag='||l_flag);

2028: Begin
2029: l_lock_handle:=get_lock_handle(p_lock_name);
2030: l_flag:=dbms_lock.release(lockhandle=>l_lock_handle);
2031: if l_flag=3 or l_flag=5 then --error
2032: log('Exception in dbms_lock.release. Return flag='||l_flag);
2033: raise bsc_aw_utility.g_exception;
2034: end if;
2035: Exception when others then
2036: log_n('Exception in release_db_lock '||sqlerrm);

Line 2043: dbms_lock.allocate_unique(lockname=>p_lock_name,lockhandle=>l_lock_handle);

2039:
2040: function get_lock_handle(p_lock_name varchar2) return varchar2 is
2041: l_lock_handle varchar2(2000);
2042: Begin
2043: dbms_lock.allocate_unique(lockname=>p_lock_name,lockhandle=>l_lock_handle);
2044: return l_lock_handle;
2045: Exception when others then
2046: log_n('Exception in get_lock_handle '||sqlerrm);
2047: raise;