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 141: inv_log_util.trace('Begin release locks.. ' , 'INV_TABLE_LOCK_PVT', 9);

137: l_ret_status NUMBER;
138: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
139: BEGIN
140: IF (l_debug = 1 ) THEN /* Bug#5401181*/
141: inv_log_util.trace('Begin release locks.. ' , 'INV_TABLE_LOCK_PVT', 9);
142: END IF;
143: select lock_handle bulk collect into table_handle from mtl_onhand_lock_temp;
144: if (table_handle IS NULL OR table_handle.COUNT = 0) THEN
145: IF (l_debug = 1 ) THEN/* Bug#5401181*/

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

142: END IF;
143: select lock_handle bulk collect into table_handle from mtl_onhand_lock_temp;
144: if (table_handle IS NULL OR table_handle.COUNT = 0) THEN
145: IF (l_debug = 1 ) THEN/* Bug#5401181*/
146: inv_log_util.trace('No user locks to Release' , 'INV_TABLE_LOCK_PVT', 9);
147: END IF;
148: else
149: for i in table_handle.FIRST .. table_handle.LAST loop
150: l_ret_status := dbms_lock.release(table_handle(i));

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

149: for i in table_handle.FIRST .. table_handle.LAST loop
150: l_ret_status := dbms_lock.release(table_handle(i));
151: if l_ret_status = 0 then
152: IF (l_debug = 1 ) THEN /* Bug#5401181*/
153: inv_log_util.trace('Lock released successfully' , 'INV_TABLE_LOCK_PVT', 9);
154: END IF;
155: else
156: IF (l_debug = 1 ) THEN/* Bug#5401181*/
157: inv_log_util.trace('Error in releasing the lock'||l_ret_status, 'INV_TABLE_LOCK_PVT', 9);

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

153: inv_log_util.trace('Lock released successfully' , 'INV_TABLE_LOCK_PVT', 9);
154: END IF;
155: else
156: IF (l_debug = 1 ) THEN/* Bug#5401181*/
157: inv_log_util.trace('Error in releasing the lock'||l_ret_status, 'INV_TABLE_LOCK_PVT', 9);
158: END IF;
159: end if;
160: end loop;
161: DELETE MTL_ONHAND_LOCK_TEMP;

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

173: l_ret_status NUMBER;
174: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
175: BEGIN
176: IF (l_debug = 1 ) THEN /* Bug#5401181*/
177: inv_log_util.TRACE('Begin release locks for header id.. ' || p_header_id, 'INV_TABLE_LOCK_PVT', 9);
178: END IF;
179:
180: IF (p_commit = 1) THEN
181: -- should not delete the temp rows for wip move trx's are this will

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

181: -- should not delete the temp rows for wip move trx's are this will
182: -- be done BY wip move worker when they call the release_locks api.
183: IF (wip_constants.wip_move_worker <> 'Y') THEN
184: IF (l_debug = 1) /* Bug#5401181*/ THEN
185: inv_log_util.TRACE('In rel locks,wip_move= .. ' || wip_constants.wip_move_worker, 'INV_TABLE_LOCK_PVT', 9);
186: END IF;
187:
188: DELETE mtl_onhand_lock_temp
189: WHERE header_id = p_header_id;

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

195: WHERE header_id = p_header_id;
196:
197: IF (table_handle IS NULL OR table_handle.COUNT = 0) THEN
198: IF (l_debug = 1 ) THEN/* Bug#5401181*/
199: inv_log_util.TRACE('No user locks to Release', 'INV_TABLE_LOCK_PVT', 9);
200: END IF;
201: ELSE
202: FOR i IN table_handle.FIRST .. table_handle.LAST LOOP
203: l_ret_status := DBMS_LOCK.release(table_handle(i));

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

203: l_ret_status := DBMS_LOCK.release(table_handle(i));
204:
205: IF l_ret_status = 0 THEN
206: IF (l_debug = 1 ) THEN/* Bug#5401181*/
207: inv_log_util.TRACE('Lock released successfully', 'INV_TABLE_LOCK_PVT', 9);
208: END IF;
209: ELSE
210: IF (l_debug = 1 ) THEN /* Bug#5401181*/
211: inv_log_util.TRACE('Error in releasing the lock' || l_ret_status, 'INV_TABLE_LOCK_PVT', 9);

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

207: inv_log_util.TRACE('Lock released successfully', 'INV_TABLE_LOCK_PVT', 9);
208: END IF;
209: ELSE
210: IF (l_debug = 1 ) THEN /* Bug#5401181*/
211: inv_log_util.TRACE('Error in releasing the lock' || l_ret_status, 'INV_TABLE_LOCK_PVT', 9);
212: END IF;
213: END IF;
214: END LOOP;
215: