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

Line 102: jtm_message_log_pkg.Log_Msg

98: l_sender_user := True;
99: l_recipient_user := True;
100:
101: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
102: jtm_message_log_pkg.Log_Msg
103: ( p_notification_id
104: , g_table_name
105: , 'Entering Procedure INSERT_NOTIFICATION_ATTRIBUTE'
106: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 118: jtm_message_log_pkg.Log_Msg

114: FETCH c_get_sender INTO r_get_sender;
115:
116: IF c_get_sender%NOTFOUND THEN
117: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
118: jtm_message_log_pkg.Log_Msg
119: ( p_notification_id
120: , g_table_name
121: , 'Notification is not an open CS_MSGS/FYI_MESSAGE or sender user can not be found'
122: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 134: jtm_message_log_pkg.Log_Msg

130: FETCH c_get_recipient INTO r_get_recipient;
131:
132: IF c_get_recipient%NOTFOUND THEN
133: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
134: jtm_message_log_pkg.Log_Msg
135: ( p_notification_id
136: , g_table_name2
137: , 'Notification is not an open CS_MSGS/FYI_MESSAGE or recipient user can not be found'
138: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 151: jtm_message_log_pkg.Log_Msg

147: FETCH c_get_user_resource INTO r_get_sender_resource;
148:
149: IF c_get_user_resource%NOTFOUND THEN
150: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
151: jtm_message_log_pkg.Log_Msg
152: ( p_notification_id
153: , g_table_name
154: , 'Sender of notification is not a resource.'
155: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 176: jtm_message_log_pkg.Log_Msg

172: FETCH c_get_user_resource INTO r_get_recipient_resource;
173:
174: IF c_get_user_resource%NOTFOUND THEN
175: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
176: jtm_message_log_pkg.Log_Msg
177: ( p_notification_id
178: , g_table_name
179: , 'Recipient of notification is not a resource.'
180: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 222: jtm_message_log_pkg.Log_Msg

218: , p_resource_id => r_get_recipient_resource.resource_id
219: );
220:
221: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
222: jtm_message_log_pkg.Log_Msg
223: ( p_notification_id
224: , g_table_name2
225: , 'Deleted recipient notification id from Notification Attribute ACC table.'
226: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 236: jtm_message_log_pkg.Log_Msg

232: FETCH c_recipient_attr INTO r_recipient_attr;
233: IF c_recipient_attr%NOTFOUND THEN
234: /*** could not find any notification attribute records to be deleted ***/
235: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
236: jtm_message_log_pkg.Log_Msg
237: ( p_notification_id
238: , g_table_name
239: , 'Did not find any Notification Attribute records to be deleted for recipient.'
240: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 262: jtm_message_log_pkg.Log_Msg

258: END LOOP;
259: CLOSE c_recipient_attr;
260:
261: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
262: jtm_message_log_pkg.Log_Msg
263: ( p_notification_id
264: , g_table_name
265: , 'Deleted all records for recipient from Notification Attribute ACC table.'
266: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 271: jtm_message_log_pkg.Log_Msg

267: END IF;
268: END IF;
269: ELSE
270: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
271: jtm_message_log_pkg.Log_Msg
272: ( p_notification_id
273: , g_table_name
274: , 'Recipient of notification is not a Mobile Resource: No deletion of notification from ACC table.'
275: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 302: jtm_message_log_pkg.Log_Msg

298: , p_resource_id => r_get_sender_resource.resource_id
299: );
300:
301: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
302: jtm_message_log_pkg.Log_Msg
303: ( p_notification_id
304: , g_table_name
305: , 'Inserted attributes for sender notification ' || p_notification_id|| ' + ' || p_name
306: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 332: jtm_message_log_pkg.Log_Msg

328: , p_resource_id => r_get_recipient_resource.resource_id
329: );
330:
331: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
332: jtm_message_log_pkg.Log_Msg
333: ( p_notification_id
334: , g_table_name
335: , 'Inserted recipient notification id and name into Notification Attribute ACC table.'
336: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 341: jtm_message_log_pkg.LOG_MSG

337: END IF;
338: END IF;
339:
340: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
341: jtm_message_log_pkg.LOG_MSG
342: ( p_notification_id
343: , g_table_name
344: , 'Leaving Procedure INSERT_NOTIFICATION_ATTRIBUTE'
345: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 419: jtm_message_log_pkg.Log_Msg

415:
416: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
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 => p_resource_id
421: , v_object_name => g_table_name
422: , v_message => 'Entering Insert_All_ACC_Records procedure for user: ' || p_resource_id
423: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 427: jtm_message_log_pkg.Log_Msg

423: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
424: END IF;
425: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
426:
427: jtm_message_log_pkg.Log_Msg
428: ( v_object_id => p_resource_id
429: , v_object_name => g_table_name
430: , v_message => 'Insert all Notification acc and Notification Attributes ACC records for user: '||
431: p_resource_id

Line 441: jtm_message_log_pkg.Log_Msg

437: OPEN c_notification_sender ( p_resource_id );
438: FETCH c_notification_sender INTO r_notification_sender;
439: IF c_notification_sender%NOTFOUND THEN
440: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
441: jtm_message_log_pkg.Log_Msg
442: ( v_object_id => p_resource_id
443: , v_object_name => g_table_name
444: , v_message => 'Insert all Notification ACC: no send-records found for user: ' || p_resource_id
445: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 454: jtm_message_log_pkg.Log_Msg

450: OPEN c_get_attribute_name ( r_notification_sender.notification_id );
451: FETCH c_get_attribute_name INTO r_get_attribute_name;
452: IF c_get_attribute_name%NOTFOUND THEN
453: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
454: jtm_message_log_pkg.Log_Msg
455: ( v_object_id => p_resource_id
456: , v_object_name => g_table_name
457: , v_message => 'No Attributes records found for notification: ' ||
458: r_notification_sender.notification_id

Line 478: jtm_message_log_pkg.Log_Msg

474: OPEN c_notification_receive ( p_resource_id );
475: FETCH c_notification_receive INTO r_notification_receive;
476: IF c_notification_receive%NOTFOUND THEN
477: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
478: jtm_message_log_pkg.Log_Msg
479: ( v_object_id => p_resource_id
480: , v_object_name => g_table_name
481: , v_message => 'No received records found for user : ' || p_resource_id
482: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 491: jtm_message_log_pkg.Log_Msg

487: OPEN c_get_attribute_name ( r_notification_receive.notification_id );
488: FETCH c_get_attribute_name INTO r_get_attribute_name;
489: IF c_get_attribute_name%NOTFOUND THEN
490: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
491: jtm_message_log_pkg.Log_Msg
492: ( v_object_id => p_resource_id
493: , v_object_name => g_table_name
494: , v_message => 'No received Notification Attributes records found for notification: '||
495: r_notification_receive.notification_id

Line 513: jtm_message_log_pkg.Log_Msg

509: l_return_value := FND_API.G_RET_STS_SUCCESS;
510: END IF;
511:
512: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
513: jtm_message_log_pkg.Log_Msg
514: ( v_object_id => p_resource_id
515: , v_object_name => g_table_name
516: , v_message => 'Leaving Insert_All_ACC_Records procedure for user: ' || p_resource_id
517: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 579: jtm_message_log_pkg.Log_Msg

575: /*Get the debug level*/
576: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
577:
578: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
579: jtm_message_log_pkg.Log_Msg
580: ( v_object_id => p_resource_id
581: , v_object_name => g_table_name
582: , v_message => 'Entering Delete_All_ACC_Records procedure for user: ' || p_resource_id
583: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 587: jtm_message_log_pkg.Log_Msg

583: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
584: END IF;
585:
586: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
587: jtm_message_log_pkg.Log_Msg
588: ( v_object_id => p_resource_id
589: , v_object_name => g_table_name
590: , v_message => 'Delete all Notification acc and Notification Attributes ACC records for user: '||
591: p_resource_id

Line 601: jtm_message_log_pkg.Log_Msg

597: OPEN c_notification_sender ( p_resource_id );
598: FETCH c_notification_sender INTO r_notification_sender;
599: IF c_notification_sender%NOTFOUND THEN
600: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
601: jtm_message_log_pkg.Log_Msg
602: ( v_object_id => p_resource_id
603: , v_object_name => g_table_name
604: , v_message => 'No sent record found for user: ' || p_resource_id
605: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 623: jtm_message_log_pkg.Log_Msg

619: OPEN c_get_attribute_name ( r_notification_sender.notification_id );
620: FETCH c_get_attribute_name INTO r_get_attribute_name;
621: IF c_get_attribute_name%NOTFOUND THEN
622: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
623: jtm_message_log_pkg.Log_Msg
624: ( v_object_id => p_resource_id
625: , v_object_name => g_table_name
626: , v_message => 'No notification attributes found for notification: ' ||
627: r_notification_sender.notification_id

Line 655: jtm_message_log_pkg.Log_Msg

651: OPEN c_notification_receive ( p_resource_id );
652: FETCH c_notification_receive INTO r_notification_receive;
653: IF c_notification_receive%NOTFOUND THEN
654: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
655: jtm_message_log_pkg.Log_Msg
656: ( v_object_id => p_resource_id
657: , v_object_name => g_table_name
658: , v_message => 'No received records found for user: ' || p_resource_id
659: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 677: jtm_message_log_pkg.Log_Msg

673: OPEN c_get_attribute_name ( r_notification_receive.notification_id );
674: FETCH c_get_attribute_name INTO r_get_attribute_name;
675: IF c_get_attribute_name%NOTFOUND THEN
676: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
677: jtm_message_log_pkg.Log_Msg
678: ( v_object_id => p_resource_id
679: , v_object_name => g_table_name
680: , v_message => 'No attributes found for notification ' ||
681: r_notification_receive.notification_id

Line 707: jtm_message_log_pkg.Log_Msg

703: END IF;
704: END IF;
705:
706: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
707: jtm_message_log_pkg.Log_Msg
708: ( v_object_id => p_resource_id
709: , v_object_name => g_table_name
710: , v_message => 'Leaving Delete_All_ACC_Records procedure for user: ' || p_resource_id
711: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 717: jtm_message_log_pkg.Log_Msg

713:
714: x_return_status := l_return_value;
715: EXCEPTION WHEN OTHERS THEN
716: /*** hook failed -> log error ***/
717: jtm_message_log_pkg.Log_Msg
718: ( v_object_id => p_resource_id
719: , v_object_name => g_table_name
720: , v_message => 'Error occurred in Delete_All_ACC_Records'||sqlerrm
721: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);