APPS.INV_RESERVATION_LOCK_PVT dependencies on INV_LOG_UTIL

Line 50: inv_log_util.trace('Session is.. ' ||l_sessionid , 'INV_RESERVATION_LOCK_PVT', 9); */

46:
47: get_lock_handle(l_lock_name,l_lock_handle);
48:
49: /* select USERENV('SESSIONID') into l_sessionid from dual;
50: inv_log_util.trace('Session is.. ' ||l_sessionid , 'INV_RESERVATION_LOCK_PVT', 9); */
51:
52: inv_log_util.trace('Lock Name is...:' ||l_lock_name , 'INV_RESERVATION_LOCK_PVT', 9);
53: inv_log_util.trace('Lock Handle is...:' ||l_lock_handle , 'INV_RESERVATION_LOCK_PVT', 9);
54:

Line 52: inv_log_util.trace('Lock Name is...:' ||l_lock_name , 'INV_RESERVATION_LOCK_PVT', 9);

48:
49: /* select USERENV('SESSIONID') into l_sessionid from dual;
50: inv_log_util.trace('Session is.. ' ||l_sessionid , 'INV_RESERVATION_LOCK_PVT', 9); */
51:
52: inv_log_util.trace('Lock Name is...:' ||l_lock_name , 'INV_RESERVATION_LOCK_PVT', 9);
53: inv_log_util.trace('Lock Handle is...:' ||l_lock_handle , 'INV_RESERVATION_LOCK_PVT', 9);
54:
55: l_status := dbms_lock.request
56: (

Line 53: inv_log_util.trace('Lock Handle is...:' ||l_lock_handle , 'INV_RESERVATION_LOCK_PVT', 9);

49: /* select USERENV('SESSIONID') into l_sessionid from dual;
50: inv_log_util.trace('Session is.. ' ||l_sessionid , 'INV_RESERVATION_LOCK_PVT', 9); */
51:
52: inv_log_util.trace('Lock Name is...:' ||l_lock_name , 'INV_RESERVATION_LOCK_PVT', 9);
53: inv_log_util.trace('Lock Handle is...:' ||l_lock_handle , 'INV_RESERVATION_LOCK_PVT', 9);
54:
55: l_status := dbms_lock.request
56: (
57: lockhandle => l_lock_handle

Line 65: inv_log_util.trace('l_status returns from dbms_lock.request = ' || l_status, 'INV_RESERVATION_LOCK_PVT', 9);

61: -- l_status = 4.No need to insert into temp table when lock is already
62: -- owned by this session.it will become duplicate entry if we insert
63: -- and release lock may fail in this case for the second time.
64:
65: inv_log_util.trace('l_status returns from dbms_lock.request = ' || l_status, 'INV_RESERVATION_LOCK_PVT', 9);
66:
67: if (l_status <> 0 AND l_status <> 4) then
68: if (l_status = 1 OR l_status = 2) then
69: l_lock_status := 0;

Line 75: inv_log_util.trace('l_lock_status = ' || l_lock_status, 'INV_RESERVATION_LOCK_PVT', 9);

71: ELSE
72: l_lock_status := 1;
73: END IF;
74:
75: inv_log_util.trace('l_lock_status = ' || l_lock_status, 'INV_RESERVATION_LOCK_PVT', 9);
76: x_lock_status := l_lock_status;
77: x_lock_handle := l_lock_handle;
78: EXCEPTION
79: WHEN OTHERS THEN

Line 80: inv_log_util.trace('Exception: ' || SQLERRM, 'INV_RESERVATION_LOCK_PVT', 9);

76: x_lock_status := l_lock_status;
77: x_lock_handle := l_lock_handle;
78: EXCEPTION
79: WHEN OTHERS THEN
80: inv_log_util.trace('Exception: ' || SQLERRM, 'INV_RESERVATION_LOCK_PVT', 9);
81: x_lock_status := 0;
82: END;
83:
84: PROCEDURE get_lock_handle

Line 90: inv_log_util.trace('p_lock_name = ' || p_lock_name, 'INV_RESERVATION_LOCK_PVT', 9);

86: x_lock_handle OUT NOCOPY VARCHAR2) IS
87:
88: PRAGMA AUTONOMOUS_TRANSACTION;
89: begin
90: inv_log_util.trace('p_lock_name = ' || p_lock_name, 'INV_RESERVATION_LOCK_PVT', 9);
91: dbms_lock.allocate_unique
92: (lockname => p_lock_name
93: ,lockhandle => x_lock_handle);
94: commit;

Line 101: inv_log_util.trace('Begin release locks.. ' , 'INV_RESERVATION_LOCK_PVT', 9);

97: PROCEDURE release_lock(p_lock_handle IN VARCHAR2)
98: IS
99: l_ret_status NUMBER;
100: BEGIN
101: inv_log_util.trace('Begin release locks.. ' , 'INV_RESERVATION_LOCK_PVT', 9);
102:
103: l_ret_status := dbms_lock.release(p_lock_handle);
104: if l_ret_status = 0 then
105: inv_log_util.trace('Lock released successfully' , 'INV_RESERVATION_LOCK_PVT', 9);

Line 105: inv_log_util.trace('Lock released successfully' , 'INV_RESERVATION_LOCK_PVT', 9);

101: inv_log_util.trace('Begin release locks.. ' , 'INV_RESERVATION_LOCK_PVT', 9);
102:
103: l_ret_status := dbms_lock.release(p_lock_handle);
104: if l_ret_status = 0 then
105: inv_log_util.trace('Lock released successfully' , 'INV_RESERVATION_LOCK_PVT', 9);
106: else
107: inv_log_util.trace('Error in releasing the lock'||l_ret_status, 'INV_RESERVATION_LOCK_PVT', 9);
108: end if;
109:

Line 107: inv_log_util.trace('Error in releasing the lock'||l_ret_status, 'INV_RESERVATION_LOCK_PVT', 9);

103: l_ret_status := dbms_lock.release(p_lock_handle);
104: if l_ret_status = 0 then
105: inv_log_util.trace('Lock released successfully' , 'INV_RESERVATION_LOCK_PVT', 9);
106: else
107: inv_log_util.trace('Error in releasing the lock'||l_ret_status, 'INV_RESERVATION_LOCK_PVT', 9);
108: end if;
109:
110: END;
111: