DBA Data[Home] [Help]

APPS.INV_TABLE_LOCK_PVT dependencies on INV_LOG_UTIL

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

42: OR p_issue_receipt = 1) then
43: get_lock_handle(p_header_id,l_lock_name,l_lock_handle);
44:
45: /* select USERENV('SESSIONID') into l_sessionid from dual;
46: inv_log_util.trace('Session is.. ' ||l_sessionid , 'INV_TABLE_LOCK_PVT', 9); */
47:
48: IF (l_debug = 1 ) THEN /* Bug#5401181*/
49: inv_log_util.trace('Lock Name is...:' ||l_lock_name , 'INV_TABLE_LOCK_PVT', 9);
50: inv_log_util.trace('Lock Handle is...:' ||l_lock_handle , 'INV_TABLE_LOCK_PVT', 9);

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

45: /* select USERENV('SESSIONID') into l_sessionid from dual;
46: inv_log_util.trace('Session is.. ' ||l_sessionid , 'INV_TABLE_LOCK_PVT', 9); */
47:
48: IF (l_debug = 1 ) THEN /* Bug#5401181*/
49: inv_log_util.trace('Lock Name is...:' ||l_lock_name , 'INV_TABLE_LOCK_PVT', 9);
50: inv_log_util.trace('Lock Handle is...:' ||l_lock_handle , 'INV_TABLE_LOCK_PVT', 9);
51: END IF;
52:
53: l_status := dbms_lock.request(

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

46: inv_log_util.trace('Session is.. ' ||l_sessionid , 'INV_TABLE_LOCK_PVT', 9); */
47:
48: IF (l_debug = 1 ) THEN /* Bug#5401181*/
49: inv_log_util.trace('Lock Name is...:' ||l_lock_name , 'INV_TABLE_LOCK_PVT', 9);
50: inv_log_util.trace('Lock Handle is...:' ||l_lock_handle , 'INV_TABLE_LOCK_PVT', 9);
51: END IF;
52:
53: l_status := dbms_lock.request(
54: lockhandle => l_lock_handle

Line 106: inv_log_util.trace('Begin release locks.. ' , 'INV_TABLE_LOCK_PVT', 9);

102: l_ret_status NUMBER;
103: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
104: BEGIN
105: IF (l_debug = 1 ) THEN /* Bug#5401181*/
106: inv_log_util.trace('Begin release locks.. ' , 'INV_TABLE_LOCK_PVT', 9);
107: END IF;
108: select lock_handle bulk collect into table_handle from mtl_onhand_lock_temp;
109: if (table_handle IS NULL OR table_handle.COUNT = 0) THEN
110: IF (l_debug = 1 ) THEN/* Bug#5401181*/

Line 111: inv_log_util.trace('No user locks to Release' , 'INV_TABLE_LOCK_PVT', 9);

107: END IF;
108: select lock_handle bulk collect into table_handle from mtl_onhand_lock_temp;
109: if (table_handle IS NULL OR table_handle.COUNT = 0) THEN
110: IF (l_debug = 1 ) THEN/* Bug#5401181*/
111: inv_log_util.trace('No user locks to Release' , 'INV_TABLE_LOCK_PVT', 9);
112: END IF;
113: else
114: for i in table_handle.FIRST .. table_handle.LAST loop
115: l_ret_status := dbms_lock.release(table_handle(i));

Line 118: inv_log_util.trace('Lock released successfully' , 'INV_TABLE_LOCK_PVT', 9);

114: for i in table_handle.FIRST .. table_handle.LAST loop
115: l_ret_status := dbms_lock.release(table_handle(i));
116: if l_ret_status = 0 then
117: IF (l_debug = 1 ) THEN /* Bug#5401181*/
118: inv_log_util.trace('Lock released successfully' , 'INV_TABLE_LOCK_PVT', 9);
119: END IF;
120: else
121: IF (l_debug = 1 ) THEN/* Bug#5401181*/
122: inv_log_util.trace('Error in releasing the lock'||l_ret_status, 'INV_TABLE_LOCK_PVT', 9);

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

118: inv_log_util.trace('Lock released successfully' , 'INV_TABLE_LOCK_PVT', 9);
119: END IF;
120: else
121: IF (l_debug = 1 ) THEN/* Bug#5401181*/
122: inv_log_util.trace('Error in releasing the lock'||l_ret_status, 'INV_TABLE_LOCK_PVT', 9);
123: END IF;
124: end if;
125: end loop;
126: DELETE MTL_ONHAND_LOCK_TEMP;

Line 142: inv_log_util.TRACE('Begin release locks for header id.. ' || p_header_id, 'INV_TABLE_LOCK_PVT', 9);

138: l_ret_status NUMBER;
139: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
140: BEGIN
141: IF (l_debug = 1 ) THEN /* Bug#5401181*/
142: inv_log_util.TRACE('Begin release locks for header id.. ' || p_header_id, 'INV_TABLE_LOCK_PVT', 9);
143: END IF;
144:
145: IF (p_commit = 1) THEN
146: -- should not delete the temp rows for wip move trx's are this will

Line 150: inv_log_util.TRACE('In rel locks,wip_move= .. ' || wip_constants.wip_move_worker, 'INV_TABLE_LOCK_PVT', 9);

146: -- should not delete the temp rows for wip move trx's are this will
147: -- be done BY wip move worker when they call the release_locks api.
148: IF (wip_constants.wip_move_worker <> 'Y') THEN
149: IF (l_debug = 1) /* Bug#5401181*/ THEN
150: inv_log_util.TRACE('In rel locks,wip_move= .. ' || wip_constants.wip_move_worker, 'INV_TABLE_LOCK_PVT', 9);
151: END IF;
152:
153: DELETE mtl_onhand_lock_temp
154: WHERE header_id = p_header_id;

Line 164: inv_log_util.TRACE('No user locks to Release', 'INV_TABLE_LOCK_PVT', 9);

160: WHERE header_id = p_header_id;
161:
162: IF (table_handle IS NULL OR table_handle.COUNT = 0) THEN
163: IF (l_debug = 1 ) THEN/* Bug#5401181*/
164: inv_log_util.TRACE('No user locks to Release', 'INV_TABLE_LOCK_PVT', 9);
165: END IF;
166: ELSE
167: FOR i IN table_handle.FIRST .. table_handle.LAST LOOP
168: l_ret_status := DBMS_LOCK.release(table_handle(i));

Line 172: inv_log_util.TRACE('Lock released successfully', 'INV_TABLE_LOCK_PVT', 9);

168: l_ret_status := DBMS_LOCK.release(table_handle(i));
169:
170: IF l_ret_status = 0 THEN
171: IF (l_debug = 1 ) THEN/* Bug#5401181*/
172: inv_log_util.TRACE('Lock released successfully', 'INV_TABLE_LOCK_PVT', 9);
173: END IF;
174: ELSE
175: IF (l_debug = 1 ) THEN /* Bug#5401181*/
176: inv_log_util.TRACE('Error in releasing the lock' || l_ret_status, 'INV_TABLE_LOCK_PVT', 9);

Line 176: inv_log_util.TRACE('Error in releasing the lock' || l_ret_status, 'INV_TABLE_LOCK_PVT', 9);

172: inv_log_util.TRACE('Lock released successfully', 'INV_TABLE_LOCK_PVT', 9);
173: END IF;
174: ELSE
175: IF (l_debug = 1 ) THEN /* Bug#5401181*/
176: inv_log_util.TRACE('Error in releasing the lock' || l_ret_status, 'INV_TABLE_LOCK_PVT', 9);
177: END IF;
178: END IF;
179: END LOOP;
180: