APPS.INV_RESERVATION_LOCK_PVT dependencies on INV_LOG_UTIL

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

54:
55: get_lock_handle(l_lock_name,l_lock_handle);
56:
57: /* select USERENV('SESSIONID') into l_sessionid from dual;
58: inv_log_util.trace('Session is.. ' ||l_sessionid , 'INV_RESERVATION_LOCK_PVT', 9); */
59:
60: inv_log_util.trace('Lock Name is...:' ||l_lock_name , 'INV_RESERVATION_LOCK_PVT', 9);
61: inv_log_util.trace('Lock Handle is...:' ||l_lock_handle , 'INV_RESERVATION_LOCK_PVT', 9);
62:

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

56:
57: /* select USERENV('SESSIONID') into l_sessionid from dual;
58: inv_log_util.trace('Session is.. ' ||l_sessionid , 'INV_RESERVATION_LOCK_PVT', 9); */
59:
60: inv_log_util.trace('Lock Name is...:' ||l_lock_name , 'INV_RESERVATION_LOCK_PVT', 9);
61: inv_log_util.trace('Lock Handle is...:' ||l_lock_handle , 'INV_RESERVATION_LOCK_PVT', 9);
62:
63: l_status := dbms_lock.request
64: (

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

57: /* select USERENV('SESSIONID') into l_sessionid from dual;
58: inv_log_util.trace('Session is.. ' ||l_sessionid , 'INV_RESERVATION_LOCK_PVT', 9); */
59:
60: inv_log_util.trace('Lock Name is...:' ||l_lock_name , 'INV_RESERVATION_LOCK_PVT', 9);
61: inv_log_util.trace('Lock Handle is...:' ||l_lock_handle , 'INV_RESERVATION_LOCK_PVT', 9);
62:
63: l_status := dbms_lock.request
64: (
65: lockhandle => l_lock_handle

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

69: -- l_status = 4.No need to insert into temp table when lock is already
70: -- owned by this session.it will become duplicate entry if we insert
71: -- and release lock may fail in this case for the second time.
72:
73: inv_log_util.trace('l_status returns from dbms_lock.request = ' || l_status, 'INV_RESERVATION_LOCK_PVT', 9);
74:
75: if (l_status <> 0 AND l_status <> 4) then
76: if (l_status = 1 OR l_status = 2) then
77: l_lock_status := 0;

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

79: ELSE
80: l_lock_status := 1;
81: END IF;
82:
83: inv_log_util.trace('l_lock_status = ' || l_lock_status, 'INV_RESERVATION_LOCK_PVT', 9);
84: x_lock_status := l_lock_status;
85: x_lock_handle := l_lock_handle;
86: EXCEPTION
87: WHEN OTHERS THEN

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

84: x_lock_status := l_lock_status;
85: x_lock_handle := l_lock_handle;
86: EXCEPTION
87: WHEN OTHERS THEN
88: inv_log_util.trace('Exception: ' || SQLERRM, 'INV_RESERVATION_LOCK_PVT', 9);
89: x_lock_status := 0;
90: END;
91:
92: PROCEDURE get_lock_handle

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

94: x_lock_handle OUT NOCOPY VARCHAR2) IS
95:
96: PRAGMA AUTONOMOUS_TRANSACTION;
97: begin
98: inv_log_util.trace('p_lock_name = ' || p_lock_name, 'INV_RESERVATION_LOCK_PVT', 9);
99: dbms_lock.allocate_unique
100: (lockname => p_lock_name
101: ,lockhandle => x_lock_handle);
102: commit;

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

105: PROCEDURE release_lock(p_lock_handle IN VARCHAR2)
106: IS
107: l_ret_status NUMBER;
108: BEGIN
109: inv_log_util.trace('Begin release locks.. ' , 'INV_RESERVATION_LOCK_PVT', 9);
110:
111: l_ret_status := dbms_lock.release(p_lock_handle);
112: if l_ret_status = 0 then
113: inv_log_util.trace('Lock released successfully' , 'INV_RESERVATION_LOCK_PVT', 9);

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

109: inv_log_util.trace('Begin release locks.. ' , 'INV_RESERVATION_LOCK_PVT', 9);
110:
111: l_ret_status := dbms_lock.release(p_lock_handle);
112: if l_ret_status = 0 then
113: inv_log_util.trace('Lock released successfully' , 'INV_RESERVATION_LOCK_PVT', 9);
114: else
115: inv_log_util.trace('Error in releasing the lock'||l_ret_status, 'INV_RESERVATION_LOCK_PVT', 9);
116: end if;
117:

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

111: l_ret_status := dbms_lock.release(p_lock_handle);
112: if l_ret_status = 0 then
113: inv_log_util.trace('Lock released successfully' , 'INV_RESERVATION_LOCK_PVT', 9);
114: else
115: inv_log_util.trace('Error in releasing the lock'||l_ret_status, 'INV_RESERVATION_LOCK_PVT', 9);
116: end if;
117:
118: END;
119: