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

Line 62: jtm_message_log_pkg.Log_Msg

58: l_valid_receiver BOOLEAN;
59:
60: BEGIN
61: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
62: jtm_message_log_pkg.Log_Msg
63: ( v_object_id => p_record.notification_id
64: , v_object_name => g_object_name
65: , v_message => 'Entering ' || g_object_name || '.APPLY_INSERT'
66: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 181: jtm_message_log_pkg.Log_Msg

177: /*** Call Concurrent Program to push new Notification and Attributes to mobile ***/
178: CSL_CONC_NOTIFICATION_PKG.RUN_CONCURRENT_NOTIFICATIONS;
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.notification_id
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.notification_id
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.notification_id
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.notification_id
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.notification_id
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.notification_id
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.notification_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 293: jtm_message_log_pkg.Log_Msg

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

Line 301: jtm_message_log_pkg.Log_Msg

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

Line 329: jtm_message_log_pkg.Log_Msg

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

Line 347: jtm_message_log_pkg.Log_Msg

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

Line 365: jtm_message_log_pkg.Log_Msg

361: x_return_status := FND_API.G_RET_STS_ERROR;
362: END IF;
363:
364: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
365: jtm_message_log_pkg.Log_Msg
366: ( v_object_id => p_record.notification_id
367: , v_object_name => g_object_name
368: , v_message => 'Leaving ' || g_object_name || '.APPLY_RECORD'
369: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 374: jtm_message_log_pkg.Log_Msg

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

Line 388: jtm_message_log_pkg.Log_Msg

384: p_api_error => TRUE
385: );
386:
387: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
388: jtm_message_log_pkg.Log_Msg
389: ( v_object_id => p_record.notification_id
390: , v_object_name => g_object_name
391: , v_message => 'Leaving ' || g_object_name || '.APPLY_RECORD'
392: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 419: jtm_message_log_pkg.Log_Msg

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

Line 444: jtm_message_log_pkg.Log_Msg

440: /*** was record processed successfully? ***/
441: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN
442: /*** Yes -> reject record because of changed pk ***/
443: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
444: jtm_message_log_pkg.Log_Msg
445: ( v_object_id => r_notification.notification_id
446: , v_object_name => g_object_name
447: , v_message => 'Record successfully processed, rejecting record'
448: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 466: jtm_message_log_pkg.Log_Msg

462:
463: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN
464: /*** Reject successfull than reject matching attributes ***/
465: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
466: jtm_message_log_pkg.Log_Msg
467: ( v_object_id => r_notification.notification_id
468: , v_object_name => g_object_name
469: , v_message => 'Record rejected, now rejecting attributes'
470: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 490: jtm_message_log_pkg.Log_Msg

486: END LOOP;
487: END IF;
488:
489: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
490: jtm_message_log_pkg.Log_Msg
491: ( v_object_id => r_notification.notification_id
492: , v_object_name => g_object_name
493: , v_message => 'Record successfully processed, deleting from inqueue'
494: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 512: jtm_message_log_pkg.Log_Msg

508: /*** was delete successful? ***/
509: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
510: /*** no -> rollback ***/
511: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
512: jtm_message_log_pkg.Log_Msg
513: ( v_object_id => r_notification.notification_id
514: , v_object_name => g_object_name
515: , v_message => 'Deleting from inqueue failed, rolling back to savepoint'
516: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 522: jtm_message_log_pkg.Log_Msg

518: ROLLBACK TO save_rec;
519: ELSE
520: /*** Yes -> Delete Attributes ***/
521: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
522: jtm_message_log_pkg.Log_Msg
523: ( v_object_id => r_notification.notification_id
524: , v_object_name => g_object_name
525: , v_message => 'Deleting from inqueue succeeded, deleting attributes'
526: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 551: jtm_message_log_pkg.Log_Msg

547:
548: IF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN
549: /*** Record was not processed successfully or delete failed -> defer and reject record ***/
550: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
551: jtm_message_log_pkg.Log_Msg
552: ( v_object_id => r_notification.notification_id
553: , v_object_name => g_object_name
554: , v_message => 'Record not processed successfully, deferring and rejecting record'
555: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 574: jtm_message_log_pkg.Log_Msg

570: /*** Was defer successful? ***/
571: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
572: /*** no -> rollback ***/
573: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
574: jtm_message_log_pkg.Log_Msg
575: ( v_object_id => r_notification.notification_id
576: , v_object_name => g_object_name
577: , v_message => 'Defer record failed, rolling back to savepoint'
578: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 585: jtm_message_log_pkg.Log_Msg

581: END IF;
582: ELSE
583: /*** Yes -> also defer attributes ***/
584: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
585: jtm_message_log_pkg.Log_Msg
586: ( v_object_id => r_notification.notification_id
587: , v_object_name => g_object_name
588: , v_message => 'Defer record succeeded, deferring and rejecting Attribute record(s)'
589: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 612: jtm_message_log_pkg.Log_Msg

608: END IF;
609: END LOOP;
610:
611: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
612: jtm_message_log_pkg.Log_Msg
613: ( v_object_id => null
614: , v_object_name => g_object_name
615: , v_message => 'Leaving ' || g_object_name || '.Apply_Client_Changes'
616: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 622: jtm_message_log_pkg.Log_Msg

618:
619: EXCEPTION WHEN OTHERS THEN
620: /*** catch and log exceptions ***/
621: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
622: jtm_message_log_pkg.Log_Msg
623: ( v_object_id => null
624: , v_object_name => g_object_name
625: , v_message => 'Exception occurred in APPLY_CLIENT_CHANGES:' || fnd_global.local_chr(10) || sqlerrm
626: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);