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.CSL_MTL_TRANS_LOT_NUM_ACC_PKG dependencies on JTM_MESSAGE_LOG_PKG

Line 40: jtm_message_log_pkg.Log_Msg

36: /*** get debug level ***/
37: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
38:
39: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
40: jtm_message_log_pkg.Log_Msg
41: ( v_object_id => p_transaction_id || ' , ' || p_inventory_item_id
42: , v_object_name => g_table_name
43: , v_message => 'Entering Insert_MTL_trans_lot_num'
44: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 53: jtm_message_log_pkg.Log_Msg

49: FETCH c_transaction_lot_number INTO r_transaction_lot_number;
50: IF c_transaction_lot_number%NOTFOUND THEN
51: /*** could not find assignment record -> exit ***/
52: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
53: jtm_message_log_pkg.Log_Msg
54: ( v_object_id => p_transaction_id || ' , ' || p_inventory_item_id
55: , v_object_name => g_table_name
56: , v_message => 'Insert_MTL_trans_lot_num could not find lot number transactions for transaction :' || p_transaction_id ||
57: ' , ' || p_inventory_item_id || ' for resource id ' || p_resource_id

Line 65: jtm_message_log_pkg.Log_Msg

61: CLOSE c_transaction_lot_number;
62: -- RETURN FALSE;
63: ELSE
64: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
65: jtm_message_log_pkg.Log_Msg
66: ( v_object_id => p_transaction_id || ' , ' || p_inventory_item_id
67: , v_object_name => g_table_name
68: , v_message => 'Inserting ACC record :' || p_transaction_id || ' , ' || p_inventory_item_id ||
69: ' for resource id ' || p_resource_id

Line 120: jtm_message_log_pkg.Log_Msg

116: /*** get debug level ***/
117: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
118:
119: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
120: jtm_message_log_pkg.Log_Msg
121: ( v_object_id => p_transaction_id || ' , ' || p_inventory_item_id
122: , v_object_name => g_table_name
123: , v_message => 'Entering Update_MTL_trans_lot_num'
124: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 133: jtm_message_log_pkg.Log_Msg

129: FETCH c_transaction_lot_number INTO r_transaction_lot_number;
130: IF c_transaction_lot_number%NOTFOUND THEN
131: /*** could not find assignment record -> exit ***/
132: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
133: jtm_message_log_pkg.Log_Msg
134: ( v_object_id => p_transaction_id || ' , ' || p_inventory_item_id
135: , v_object_name => g_table_name
136: , v_message => 'Update_MTL_trans_lot_num could not find lot number transactions for transaction :' || p_transaction_id ||
137: ' , ' || p_inventory_item_id || ' for resource id ' || p_resource_id

Line 144: jtm_message_log_pkg.Log_Msg

140:
141: CLOSE c_transaction_lot_number;
142: ELSE
143: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
144: jtm_message_log_pkg.Log_Msg
145: ( v_object_id => p_transaction_id || ' , ' || p_inventory_item_id
146: , v_object_name => g_table_name
147: , v_message => 'Update ACC record :' || p_transaction_id || ' , ' || p_inventory_item_id ||
148: ' for resource id ' || p_resource_id

Line 193: jtm_message_log_pkg.Log_Msg

189:
190: END IF;
191:
192: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
193: jtm_message_log_pkg.Log_Msg
194: ( v_object_id => p_transaction_id || ' , ' || p_inventory_item_id
195: , v_object_name => g_table_name
196: , v_message => 'Leaving Update_MTL_trans_lot_num'
197: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 231: jtm_message_log_pkg.Log_Msg

227: /*** get debug level ***/
228: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
229:
230: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
231: jtm_message_log_pkg.Log_Msg
232: ( v_object_id => p_transaction_id || ' , ' || p_inventory_item_id
233: , v_object_name => g_table_name
234: , v_message => 'Entering Delete_MTL_trans_lot_num'
235: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 244: jtm_message_log_pkg.Log_Msg

240: FETCH c_transaction_lot_number INTO r_transaction_lot_number;
241: IF c_transaction_lot_number%NOTFOUND THEN
242: /*** could not find assignment record -> exit ***/
243: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
244: jtm_message_log_pkg.Log_Msg
245: ( v_object_id => p_transaction_id || ' , ' || p_inventory_item_id
246: , v_object_name => g_table_name
247: , v_message => 'Delete_MTL_trans_lot_num could not find lot number transactions for transaction :' || p_transaction_id ||
248: ' , ' || p_inventory_item_id || ' for resource id ' || p_resource_id

Line 256: jtm_message_log_pkg.Log_Msg

252: CLOSE c_transaction_lot_number;
253: -- RETURN FALSE;
254: ELSE
255: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
256: jtm_message_log_pkg.Log_Msg
257: ( v_object_id => p_organization_id
258: , v_object_name => g_table_name
259: , v_message => 'Deleting ACC record :' || p_transaction_id || ' , ' || p_inventory_item_id ||
260: ' for resource id ' || p_resource_id

Line 290: jtm_message_log_pkg.Log_Msg

286: BEGIN
287: /*** get debug level ***/
288: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
289: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
290: jtm_message_log_pkg.Log_Msg
291: ( p_resource_id
292: , g_table_name
293: , 'Entering DELETE_ALL_ACC_RECORDS'
294: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

Line 304: jtm_message_log_pkg.Log_Msg

300:
301: x_return_status := FND_API.G_RET_STS_SUCCESS;
302:
303: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
304: jtm_message_log_pkg.Log_Msg
305: ( p_resource_id
306: , g_table_name
307: , 'Leaving DELETE_ALL_ACC_RECORDS'
308: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

Line 316: jtm_message_log_pkg.Log_Msg

312: /*** hook failed -> log error ***/
313: -- x_return_status := FND_API.G_RET_STS_ERROR;
314: x_return_status := FND_API.G_RET_STS_SUCCESS;
315: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
316: jtm_message_log_pkg.Log_Msg
317: ( v_object_id => 1
318: , v_object_name => g_table_name
319: , v_message => 'Caught exception in DELETE_ALL_ACC_RECORDS hook:' || fnd_global.local_chr(10) || sqlerrm
320: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);