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_MATERIAL_TRANSACTION_PKG dependencies on JTM_MESSAGE_LOG_PKG

Line 68: jtm_message_log_pkg.Log_Msg

64: l_pub_item_name_mat CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
65: JTM_HOOK_UTIL_PKG.t_publication_item_list('MTL_MAT_TRANSACTIONS');
66: BEGIN
67: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
68: jtm_message_log_pkg.Log_Msg
69: ( v_object_id => p_record.TRANSACTION_ID
70: , v_object_name => g_object_name
71: , v_message => 'Entering ' || g_object_name || '.APPLY_INSERT'
72: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 139: jtm_message_log_pkg.Log_Msg

135: /*** Use the transaction_set_id (px_transaction_header_id) because the
136: transaction_id is not returned by the INV API ***/
137: FOR r_transaction IN c_transactions( l_mat_txn_transfer_id ) LOOP
138: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
139: jtm_message_log_pkg.Log_Msg
140: ( v_object_id => p_record.TRANSACTION_ID -- put PK column here
141: , v_object_name => g_object_name
142: , v_message => 'Found new transaction_id ' || r_transaction.transaction_id||
143: ', Pushing these to the client'

Line 181: jtm_message_log_pkg.Log_Msg

177: END LOOP;
178: END IF;
179:
180: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
181: jtm_message_log_pkg.Log_Msg
182: ( v_object_id => p_record.TRANSACTION_ID -- put PK column here
183: , v_object_name => g_object_name
184: , v_message => 'Leaving ' || g_object_name || '.APPLY_INSERT'
185: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 190: jtm_message_log_pkg.Log_Msg

186: END IF;
187:
188: EXCEPTION WHEN OTHERS THEN
189: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
190: jtm_message_log_pkg.Log_Msg
191: ( v_object_id => p_record.TRANSACTION_ID -- put PK column here
192: , v_object_name => g_object_name
193: , v_message => 'Exception occurred in APPLY_INSERT:' || fnd_global.local_chr(10) || sqlerrm
194: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

Line 204: jtm_message_log_pkg.Log_Msg

200: p_api_error => TRUE
201: );
202:
203: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
204: jtm_message_log_pkg.Log_Msg
205: ( v_object_id => p_record.TRANSACTION_ID -- put PK column here
206: , v_object_name => g_object_name
207: , v_message => 'Leaving ' || g_object_name || '.APPLY_INSERT'
208: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 225: jtm_message_log_pkg.Log_Msg

221: x_return_status IN OUT NOCOPY VARCHAR2
222: ) IS
223: BEGIN
224: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
225: jtm_message_log_pkg.Log_Msg
226: ( v_object_id => p_record.TRANSACTION_ID -- put PK column here
227: , v_object_name => g_object_name
228: , v_message => 'Entering ' || g_object_name || '.APPLY_UPDATE'
229: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 244: jtm_message_log_pkg.Log_Msg

240: );
241: END IF;
242:
243: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
244: jtm_message_log_pkg.Log_Msg
245: ( v_object_id => p_record.TRANSACTION_ID -- put PK column here
246: , v_object_name => g_object_name
247: , v_message => 'Leaving ' || g_object_name || '.APPLY_UPDATE'
248: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 253: jtm_message_log_pkg.Log_Msg

249: END IF;
250:
251: EXCEPTION WHEN OTHERS THEN
252: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
253: jtm_message_log_pkg.Log_Msg
254: ( v_object_id => p_record.TRANSACTION_ID -- put PK column here
255: , v_object_name => g_object_name
256: , v_message => 'Exception occurred in APPLY_UPDATE:' || fnd_global.local_chr(10) || sqlerrm
257: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

Line 267: jtm_message_log_pkg.Log_Msg

263: p_api_error => TRUE
264: );
265:
266: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
267: jtm_message_log_pkg.Log_Msg
268: ( v_object_id => p_record.TRANSACTION_ID -- put PK column here
269: , v_object_name => g_object_name
270: , v_message => 'Leaving ' || g_object_name || '.APPLY_UPDATE'
271: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 292: jtm_message_log_pkg.Log_Msg

288: x_return_status := FND_API.G_RET_STS_SUCCESS;
289: FND_MSG_PUB.INITIALIZE;
290:
291: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
292: jtm_message_log_pkg.Log_Msg
293: ( v_object_id => p_record.TRANSACTION_ID -- put PK column here
294: , v_object_name => g_object_name
295: , v_message => 'Entering ' || g_object_name || '.APPLY_RECORD'
296: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 300: jtm_message_log_pkg.Log_Msg

296: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
297: END IF;
298:
299: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
300: jtm_message_log_pkg.Log_Msg
301: ( v_object_id => p_record.TRANSACTION_ID -- put PK column here
302: , v_object_name => g_object_name
303: , v_message => 'Processing TRANSACTION_ID = ' || p_record.TRANSACTION_ID || fnd_global.local_chr(10) ||
304: 'DMLTYPE = ' || p_record.dmltype$$

Line 327: jtm_message_log_pkg.Log_Msg

323: );
324: ELSIF p_record.dmltype$$='D' THEN
325: -- Process delete; not supported for this entity
326: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
327: jtm_message_log_pkg.Log_Msg
328: ( v_object_id => p_record.TRANSACTION_ID -- put PK column here
329: , v_object_name => g_object_name
330: , v_message => 'Delete is not supported for this entity'
331: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

Line 345: jtm_message_log_pkg.Log_Msg

341: x_return_status := FND_API.G_RET_STS_ERROR;
342: ELSE
343: -- invalid dml type
344: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
345: jtm_message_log_pkg.Log_Msg
346: ( v_object_id => p_record.TRANSACTION_ID -- put PK column here
347: , v_object_name => g_object_name
348: , v_message => 'Invalid DML type: ' || p_record.dmltype$$
349: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

Line 363: jtm_message_log_pkg.Log_Msg

359: x_return_status := FND_API.G_RET_STS_ERROR;
360: END IF;
361:
362: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
363: jtm_message_log_pkg.Log_Msg
364: ( v_object_id => p_record.TRANSACTION_ID -- put PK column here
365: , v_object_name => g_object_name
366: , v_message => 'Leaving ' || g_object_name || '.APPLY_RECORD'
367: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 372: jtm_message_log_pkg.Log_Msg

368: END IF;
369: EXCEPTION WHEN OTHERS THEN
370: /*** defer record when any process exception occurs ***/
371: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
372: jtm_message_log_pkg.Log_Msg
373: ( v_object_id => p_record.TRANSACTION_ID -- put PK column here
374: , v_object_name => g_object_name
375: , v_message => 'Exception occurred in APPLY_RECORD:' || fnd_global.local_chr(10) || sqlerrm
376: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

Line 386: jtm_message_log_pkg.Log_Msg

382: p_api_error => TRUE
383: );
384:
385: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
386: jtm_message_log_pkg.Log_Msg
387: ( v_object_id => p_record.TRANSACTION_ID -- put PK column here
388: , v_object_name => g_object_name
389: , v_message => 'Leaving ' || g_object_name || '.APPLY_RECORD'
390: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 417: jtm_message_log_pkg.Log_Msg

413: g_debug_level := p_debug_level;
414: x_return_status := FND_API.G_RET_STS_SUCCESS;
415:
416: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
417: jtm_message_log_pkg.Log_Msg
418: ( v_object_id => null
419: , v_object_name => g_object_name
420: , v_message => 'Entering ' || g_object_name || '.Apply_Client_Changes'
421: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 440: jtm_message_log_pkg.Log_Msg

436:
437: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN
438: /*** Yes -> reject record because of changed pk ***/
439: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
440: jtm_message_log_pkg.Log_Msg
441: ( v_object_id => r_material_transaction.transaction_id
442: , v_object_name => g_object_name
443: , v_message => 'Record successfully processed, rejecting record because pk is changed'
444: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 462: jtm_message_log_pkg.Log_Msg

458:
459: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN
460: /*** Reject successfull now rejecting matching serial/lotnumber records ***/
461: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
462: jtm_message_log_pkg.Log_Msg
463: ( v_object_id => r_material_transaction.transaction_id
464: , v_object_name => g_object_name
465: , v_message => 'Record rejected, now rejecting available matching lot-/serialnumber records'
466: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 506: jtm_message_log_pkg.Log_Msg

502: /*** was record processed successfully? ***/
503: /*IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN*/
504: /*** Yes -> delete record from inqueue ***/
505: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
506: jtm_message_log_pkg.Log_Msg
507: ( v_object_id => r_material_transaction.TRANSACTION_ID
508: , v_object_name => g_object_name
509: , v_message => 'Record successfully processed, deleting from inqueue'
510: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 529: jtm_message_log_pkg.Log_Msg

525: /*** was delete successful? ***/
526: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
527: /*** no -> rollback ***/
528: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
529: jtm_message_log_pkg.Log_Msg
530: ( v_object_id => r_material_transaction.TRANSACTION_ID
531: , v_object_name => g_object_name
532: , v_message => 'Deleting from inqueue failed, rolling back to savepoint'
533: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 554: jtm_message_log_pkg.Log_Msg

550: );
551: /*** was delete successful? ***/
552: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
553: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
554: jtm_message_log_pkg.Log_Msg
555: ( v_object_id => r_lot_number.tranid$$
556: , v_object_name => g_object_name || 'MTL_TRANS_LOT_NUMBERS'
557: , v_message => 'Deleting from inqueue failed, Defer and reject record'
558: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 592: jtm_message_log_pkg.Log_Msg

588: );
589: /*** was delete successful? ***/
590: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
591: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
592: jtm_message_log_pkg.Log_Msg
593: ( v_object_id => r_unit_transaction.tranid$$
594: , v_object_name => g_object_name || 'MTL_UNIT_TRANSACTIONS'
595: , v_message => 'Deleting from inqueue failed, Defer and reject record'
596: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 617: jtm_message_log_pkg.Log_Msg

613:
614: IF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN
615: /*** Record was not processed successfully or delete failed -> defer and reject record ***/
616: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
617: jtm_message_log_pkg.Log_Msg
618: ( v_object_id => r_material_transaction.TRANSACTION_ID
619: , v_object_name => g_object_name
620: , v_message => 'Record not processed successfully, deferring and rejecting record'
621: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 640: jtm_message_log_pkg.Log_Msg

636: /*** Was defer successful? ***/
637: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
638: /*** no -> rollback ***/
639: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
640: jtm_message_log_pkg.Log_Msg
641: ( v_object_id => r_material_transaction.TRANSACTION_ID
642: , v_object_name => g_object_name
643: , v_message => 'Defer record failed, rolling back to savepoint'
644: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 684: jtm_message_log_pkg.Log_Msg

680: END IF;
681: END LOOP;
682:
683: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
684: jtm_message_log_pkg.Log_Msg
685: ( v_object_id => null
686: , v_object_name => g_object_name
687: , v_message => 'Leaving ' || g_object_name || '.Apply_Client_Changes'
688: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 694: jtm_message_log_pkg.Log_Msg

690:
691: EXCEPTION WHEN OTHERS THEN
692: /*** catch and log exceptions ***/
693: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
694: jtm_message_log_pkg.Log_Msg
695: ( v_object_id => null
696: , v_object_name => g_object_name
697: , v_message => 'Exception occurred in APPLY_CLIENT_CHANGES:' || fnd_global.local_chr(10) || sqlerrm
698: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);