eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WMS_PURGE_PVT dependencies on INV_TRX_UTIL_PUB

Line 35: inv_trx_util_pub.trace(l_api_name || ' Entered ' || g_pkg_version, l_api_name, 4);

31: l_valid_lpns WMS_DATA_TYPE_DEFINITIONS_PUB.NumberTableType;
32:
33: BEGIN
34: IF (l_debug = 1) THEN
35: inv_trx_util_pub.trace(l_api_name || ' Entered ' || g_pkg_version, l_api_name, 4);
36: inv_trx_util_pub.trace('ver='||p_api_version||' initmsg='||p_init_msg_list||' commit='||p_commit||' caller='||p_caller||' tabfst='||p_lpn_id_table.first||' tablst='||p_lpn_id_table.last, l_api_name, 4);
37: END IF;
38:
39: -- Standard Start of API savepoint

Line 36: inv_trx_util_pub.trace('ver='||p_api_version||' initmsg='||p_init_msg_list||' commit='||p_commit||' caller='||p_caller||' tabfst='||p_lpn_id_table.first||' tablst='||p_lpn_id_table.last, l_api_name, 4);

32:
33: BEGIN
34: IF (l_debug = 1) THEN
35: inv_trx_util_pub.trace(l_api_name || ' Entered ' || g_pkg_version, l_api_name, 4);
36: inv_trx_util_pub.trace('ver='||p_api_version||' initmsg='||p_init_msg_list||' commit='||p_commit||' caller='||p_caller||' tabfst='||p_lpn_id_table.first||' tablst='||p_lpn_id_table.last, l_api_name, 4);
37: END IF;
38:
39: -- Standard Start of API savepoint
40: SAVEPOINT Check_Purge_LPN_PVT;

Line 102: inv_trx_util_pub.trace(l_api_name || ' Exit tblcnt='||p_lpn_id_table.last, l_api_name, 4);

98: l_progress := 'Replace LPNS in rec with only valid lpn_ids';
99: p_lpn_id_table := l_valid_lpns;
100:
101: IF (l_debug = 1) THEN
102: inv_trx_util_pub.trace(l_api_name || ' Exit tblcnt='||p_lpn_id_table.last, l_api_name, 4);
103: END IF;
104:
105: IF ( p_lock_flag <> 'Y' ) THEN
106: -- Undo select for update

Line 117: inv_trx_util_pub.trace(l_api_name ||' Error progress='||l_progress||' SQL error: '|| SQLERRM(SQLCODE), l_api_name, 1);

113: WHEN OTHERS THEN
114: x_return_status := fnd_api.g_ret_sts_unexp_error;
115: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
116: IF (l_debug = 1) THEN
117: inv_trx_util_pub.trace(l_api_name ||' Error progress='||l_progress||' SQL error: '|| SQLERRM(SQLCODE), l_api_name, 1);
118: END IF;
119: ROLLBACK TO Check_Purge_LPN_PVT;
120: END Check_Purge_LPNs;
121:

Line 140: inv_trx_util_pub.trace(l_api_name || ' Entered ' || g_pkg_version, l_api_name, 4);

136: l_progress VARCHAR2(500) := 'Entered API';
137:
138: BEGIN
139: IF (l_debug = 1) THEN
140: inv_trx_util_pub.trace(l_api_name || ' Entered ' || g_pkg_version, l_api_name, 4);
141: inv_trx_util_pub.trace('ver='||p_api_version||' initmsg='||p_init_msg_list||' commit='||p_commit||' caller='||p_caller||' tabfst='||p_lpn_id_table.first||' tablst='||p_lpn_id_table.last, l_api_name, 4);
142: END IF;
143:
144: -- Standard Start of API savepoint

Line 141: inv_trx_util_pub.trace('ver='||p_api_version||' initmsg='||p_init_msg_list||' commit='||p_commit||' caller='||p_caller||' tabfst='||p_lpn_id_table.first||' tablst='||p_lpn_id_table.last, l_api_name, 4);

137:
138: BEGIN
139: IF (l_debug = 1) THEN
140: inv_trx_util_pub.trace(l_api_name || ' Entered ' || g_pkg_version, l_api_name, 4);
141: inv_trx_util_pub.trace('ver='||p_api_version||' initmsg='||p_init_msg_list||' commit='||p_commit||' caller='||p_caller||' tabfst='||p_lpn_id_table.first||' tablst='||p_lpn_id_table.last, l_api_name, 4);
142: END IF;
143:
144: -- Standard Start of API savepoint
145: SAVEPOINT PURGE_LPNS_PVT;

Line 228: inv_trx_util_pub.trace(l_api_name ||' Error progress='||l_progress||' SQL error: '|| SQLERRM(SQLCODE), l_api_name, 1);

224: WHEN OTHERS THEN
225: x_return_status := fnd_api.g_ret_sts_unexp_error;
226: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
227: IF (l_debug = 1) THEN
228: inv_trx_util_pub.trace(l_api_name ||' Error progress='||l_progress||' SQL error: '|| SQLERRM(SQLCODE), l_api_name, 1);
229: END IF;
230: ROLLBACK TO PURGE_LPNS_PVT;
231: END Purge_LPNs;
232:

Line 308: inv_trx_util_pub.trace('Fecthed LPNs based on date and context first='||l_lpn_tbl.first||' last='||l_lpn_tbl.last, l_api_name, 4);

304: INTO l_lpn_tbl
305: LIMIT l_max_batch_size;
306:
307: IF ( l_debug = 1 ) THEN
308: inv_trx_util_pub.trace('Fecthed LPNs based on date and context first='||l_lpn_tbl.first||' last='||l_lpn_tbl.last, l_api_name, 4);
309: END IF;
310:
311: -- If no more LPNs to purge, exit loop, otherwise if there were LPNs deleted
312: -- in the previous iteration, commit those

Line 336: inv_trx_util_pub.trace('WMS validation done first='||l_lpn_tbl.first||' last='||l_lpn_tbl.last, l_api_name, 4);

332: FND_MESSAGE.SET_TOKEN('API', 'Check_Purge_LPNs');
333: FND_MSG_PUB.ADD;
334: EXIT;
335: ELSIF ( l_debug = 1 ) THEN
336: inv_trx_util_pub.trace('WMS validation done first='||l_lpn_tbl.first||' last='||l_lpn_tbl.last, l_api_name, 4);
337: END IF;
338:
339: IF ( l_lpn_tbl.exists(1) AND NVL(l_lpn_tbl.last, 0) > 0 ) THEN
340: -- Call shipping to check if ther LPNs are elegible for purge

Line 362: inv_trx_util_pub.trace('WSH validation done first='||l_wsh_lpn_rec.lpn_ids.first||' last='||l_wsh_lpn_rec.lpn_ids.last, l_api_name, 4);

358: FND_MESSAGE.SET_TOKEN('API', 'WSH_WMS_LPN_GRP.Check_purge');
359: FND_MSG_PUB.ADD;
360: EXIT;
361: ELSIF ( l_debug = 1 ) THEN
362: inv_trx_util_pub.trace('WSH validation done first='||l_wsh_lpn_rec.lpn_ids.first||' last='||l_wsh_lpn_rec.lpn_ids.last, l_api_name, 4);
363: END IF;
364:
365: -- Put WSH approved lpn id list back in to lpn_rec type
366: l_lpn_tbl.delete;

Line 507: INV_TRX_UTIL_PUB.TRACE (

503:
504: FOR i in 1..x_msg_count LOOP
505: p_message := fnd_msg_pub.get(i,'F');
506: IF (l_debug = 1) THEN
507: INV_TRX_UTIL_PUB.TRACE (
508: p_mesg => p_message
509: , p_mod => p_module
510: , p_level => p_level );
511: END IF;