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

Line 48: jtm_message_log_pkg.Log_Msg

44: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
45:
46: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
47: THEN
48: jtm_message_log_pkg.Log_Msg
49: ( p_group_member_id
50: , g_table_name
51: , 'Entering Replicate_Record'
52: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

Line 65: jtm_message_log_pkg.Log_Msg

61: l_group_found:=TRUE;
62: ELSE
63: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
64: THEN
65: jtm_message_log_pkg.Log_Msg
66: ( p_group_member_id
67: , g_table_name
68: , 'Replicate_Record returned FALSE' || fnd_global.local_chr(10) ||
69: 'Group member record was deleted'

Line 93: jtm_message_log_pkg.Log_Msg

89: IF l_resource_is_mobile
90: THEN
91: l_replicate := TRUE;
92: ELSE
93: jtm_message_log_pkg.Log_Msg
94: ( p_group_member_id
95: , g_table_name
96: , 'No mobile resources were found for this group id: ' || r_GetGroupId.group_id
97: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

Line 124: jtm_message_log_pkg.Log_Msg

120:
121: BEGIN
122: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
123: THEN
124: jtm_message_log_pkg.Log_Msg
125: ( p_group_member_id
126: , g_table_name
127: , 'Entering Insert_ACC_Record'
128: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

Line 134: jtm_message_log_pkg.LOG_MSG

130: END IF;
131:
132: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
133: THEN
134: jtm_message_log_pkg.LOG_MSG
135: ( p_group_member_id
136: , g_table_name
137: , 'Inserting ACC record for resource id = ' || p_resource_id
138: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 171: jtm_message_log_pkg.Log_Msg

167: CLOSE c_group_member;
168:
169: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
170: THEN
171: jtm_message_log_pkg.Log_Msg
172: ( p_group_member_id
173: , g_table_name
174: , 'Leaving Insert_ACC_Record'
175: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

Line 198: jtm_message_log_pkg.Log_Msg

194: r_group_member c_group_member%ROWTYPE;
195:
196: BEGIN
197: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
198: jtm_message_log_pkg.Log_Msg
199: ( p_group_member_id
200: , g_table_name
201: ,'Entering Delete_ACC_Record'
202: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

Line 207: jtm_message_log_pkg.Log_Msg

203: );
204: END IF;
205:
206: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
207: jtm_message_log_pkg.Log_Msg
208: ( p_group_member_id
209: , g_table_name
210: , 'Deleting ACC record for p_resource_id = ' || p_resource_id
211: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

Line 244: jtm_message_log_pkg.Log_Msg

240: END IF;
241: CLOSE c_group_member;
242:
243: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
244: jtm_message_log_pkg.Log_Msg
245: ( p_group_member_id
246: , g_table_name
247: , 'Leaving Delete_ACC_Record'
248: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

Line 275: jtm_message_log_pkg.Log_Msg

271: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
272:
273: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
274: THEN
275: jtm_message_log_pkg.Log_Msg
276: ( p_group_member_id
277: , g_table_name
278: , 'Entering POST_INSERT_RS_GROUP_MEMBER hook'
279: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 287: jtm_message_log_pkg.Log_Msg

283: IF Replicate_Record( p_group_member_id ) THEN
284: /*** yes -> replicate record to mobile resources within group ***/
285: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
286: THEN
287: jtm_message_log_pkg.Log_Msg
288: ( p_group_member_id
289: , g_table_name
290: , 'Record needs to be replicated'
291: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 298: jtm_message_log_pkg.Log_Msg

294: /*** check if new member record is mobile resource ***/
295: IF JTM_HOOK_UTIL_PKG.isMobileFSresource( p_resource_id ) THEN
296: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
297: THEN
298: jtm_message_log_pkg.Log_Msg
299: ( p_group_member_id
300: , g_table_name
301: , 'New group member is mobile resource'
302: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 310: jtm_message_log_pkg.Log_Msg

306: ELSE
307:
308: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
309: THEN
310: jtm_message_log_pkg.Log_Msg
311: ( p_group_member_id
312: , g_table_name
313: , 'New group member is not a mobile resource'
314: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 334: jtm_message_log_pkg.Log_Msg

330: THEN
331: /*** yes -> replicate new record to mobile resource ***/
332: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
333: THEN
334: jtm_message_log_pkg.Log_Msg
335: ( p_group_member_id
336: , g_table_name
337: , 'Replicating new member record to mobile resource_id = ' || r_group_resources.resource_id
338: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 359: jtm_message_log_pkg.Log_Msg

355: IF r_group_resources.group_member_id <> p_group_member_id THEN
356: /*** no -> replicate existing member to new mobile group member ***/
357: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
358: THEN
359: jtm_message_log_pkg.Log_Msg
360: ( p_group_member_id
361: , g_table_name
362: , 'Replicating existing member record to new mobile resource group member. ' ||
363: fnd_global.local_chr(10) || 'group_member_id = ' || r_group_resources.group_member_id

Line 378: jtm_message_log_pkg.Log_Msg

374: END IF;
375:
376: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
377: THEN
378: jtm_message_log_pkg.Log_Msg
379: ( p_group_member_id
380: , g_table_name
381: , 'Leaving POST_INSERT_RS_GROUP_MEMBER hook'
382: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 389: jtm_message_log_pkg.Log_Msg

385:
386: EXCEPTION WHEN OTHERS THEN
387: /*** hook failed -> log error ***/
388: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
389: jtm_message_log_pkg.Log_Msg
390: ( p_group_member_id
391: , g_table_name
392: , 'Caught exception in POST_INSERT Procedure:' || fnd_global.local_chr(10) || sqlerrm
393: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

Line 428: jtm_message_log_pkg.Log_Msg

424: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
425:
426: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
427: THEN
428: jtm_message_log_pkg.Log_Msg
429: ( null
430: , g_table_name
431: , 'Entering PRE_DELETE_RS_GROUP_MEMBER hook'
432: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 442: jtm_message_log_pkg.Log_Msg

438: IF c_group_member%NOTFOUND THEN
439: /*** could not find group member -> log error and exit ***/
440: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR
441: THEN
442: jtm_message_log_pkg.Log_Msg
443: ( null
444: , g_table_name
445: , 'Could not find group member for group_id = ' || p_group_id || ', resource_id = ' || p_resource_id
446: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

Line 458: jtm_message_log_pkg.Log_Msg

454: /*** is deleted group member a mobile resource? ***/
455: IF JTM_HOOK_UTIL_PKG.isMobileFSresource( p_resource_id ) THEN
456: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
457: THEN
458: jtm_message_log_pkg.Log_Msg
459: ( l_group_member_id
460: , g_table_name
461: , 'Deleted group member is mobile resource'
462: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 468: jtm_message_log_pkg.Log_Msg

464: l_is_mobile_resource := TRUE;
465: ELSE
466: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
467: THEN
468: jtm_message_log_pkg.Log_Msg
469: ( l_group_member_id
470: , g_table_name
471: , 'Deleted group member is not a mobile resource'
472: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 482: jtm_message_log_pkg.Log_Msg

478: FOR r_group_resources IN c_group_resources ( p_group_id ) LOOP
479:
480: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
481: THEN
482: jtm_message_log_pkg.Log_Msg
483: ( l_group_member_id
484: , g_table_name
485: , 'Processing group_member_id = ' || r_group_resources.group_member_id
486: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 495: jtm_message_log_pkg.Log_Msg

491: THEN
492: /*** yes -> delete deleted member for mobile user ***/
493: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
494: THEN
495: jtm_message_log_pkg.Log_Msg
496: ( l_group_member_id
497: , g_table_name
498: , 'Deleting deleted member record for mobile resource_id = ' || r_group_resources.resource_id
499: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 515: jtm_message_log_pkg.Log_Msg

511: IF l_group_member_id <> r_group_resources.group_member_id THEN
512: /*** No -> delete existing group member for deleted mobile resource ***/
513: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
514: THEN
515: jtm_message_log_pkg.Log_Msg
516: ( l_group_member_id
517: , g_table_name
518: , 'Deleting existing member record for deleted mobile group member'
519: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 532: jtm_message_log_pkg.Log_Msg

528: END LOOP;
529:
530: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR
531: THEN
532: jtm_message_log_pkg.Log_Msg
533: ( l_group_member_id
534: , g_table_name
535: , 'Deleted group_member_id = ' || l_group_member_id
536: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

Line 541: jtm_message_log_pkg.Log_Msg

537: END IF;
538:
539: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
540: THEN
541: jtm_message_log_pkg.Log_Msg
542: ( l_group_member_id
543: , g_table_name
544: , 'Leaving PRE_DELETE_RS_GROUP_MEMBER hook'
545: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 553: jtm_message_log_pkg.Log_Msg

549:
550: EXCEPTION WHEN OTHERS THEN
551: /*** hook failed -> log error ***/
552: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
553: jtm_message_log_pkg.Log_Msg
554: ( l_group_member_id
555: , g_table_name
556: , 'Caught exception in PRE_DELETE Procedure:' || fnd_global.local_chr(10) || sqlerrm
557: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

Line 582: jtm_message_log_pkg.Log_Msg

578: /*** get debug level ***/
579: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
580:
581: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
582: jtm_message_log_pkg.Log_Msg
583: ( null
584: , g_table_name
585: , 'Entering Delete_All_ACC_Records'
586: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 592: jtm_message_log_pkg.Log_Msg

588:
589: /*** check if resource is fs laptop resource ***/
590: IF NOT JTM_HOOK_UTIL_PKG.isMobileFSresource( p_resource_id ) THEN
591: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
592: jtm_message_log_pkg.Log_Msg
593: ( null
594: , g_table_name
595: , 'Resource is not a mobile field service/laptop resource'
596: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 604: jtm_message_log_pkg.Log_Msg

600: ELSE
601: FOR r_grp_mem_acc IN c_grp_mem_acc( p_resource_id )
602: LOOP
603: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
604: jtm_message_log_pkg.Log_Msg
605: ( r_grp_mem_acc.group_member_id
606: , g_table_name
607: , 'Calling Delete_ACC_Record'
608: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 621: jtm_message_log_pkg.Log_Msg

617: x_return_status := FND_API.G_RET_STS_SUCCESS;
618: END IF;
619:
620: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
621: jtm_message_log_pkg.Log_Msg
622: ( v_object_id => null
623: , v_object_name => g_table_name
624: , v_message => 'Leaving Delete_All_ACC_Records'
625: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 631: jtm_message_log_pkg.Log_Msg

627:
628: EXCEPTION WHEN OTHERS THEN
629: /*** hook failed -> log error ***/
630: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
631: jtm_message_log_pkg.Log_Msg
632: ( null
633: , g_table_name
634: , 'Caught exception in Delete_All_ACC_Records:' || fnd_global.local_chr(10) || sqlerrm
635: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

Line 664: jtm_message_log_pkg.Log_Msg

660: /*** get debug level ***/
661: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
662:
663: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
664: jtm_message_log_pkg.Log_Msg
665: ( null
666: , g_table_name
667: , 'Entering Insert_All_ACC_Records'
668: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 674: jtm_message_log_pkg.Log_Msg

670:
671: /*** check if resource is fs laptop resource ***/
672: IF NOT JTM_HOOK_UTIL_PKG.isMobileFSresource( p_resource_id ) THEN
673: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
674: jtm_message_log_pkg.Log_Msg
675: ( null
676: , g_table_name
677: , 'Resource is not a mobile field service/laptop resource'
678: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 687: jtm_message_log_pkg.Log_Msg

683: /*** Yes -> insert all replicateable records ***/
684: FOR r_jtf_rs_group_members IN c_jtf_rs_group_members( p_resource_id )
685: LOOP
686: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
687: jtm_message_log_pkg.Log_Msg
688: ( r_jtf_rs_group_members.group_member_id
689: , g_table_name
690: , 'Calling Insert_ACC_Record'
691: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 703: jtm_message_log_pkg.Log_Msg

699: x_return_status := FND_API.G_RET_STS_SUCCESS;
700: END IF;
701:
702: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
703: jtm_message_log_pkg.Log_Msg
704: ( v_object_id => p_resource_id
705: , v_object_name => g_table_name
706: , v_message => 'Leaving Insert_All_ACC_Records procedure for user: ' || p_resource_id
707: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 713: jtm_message_log_pkg.Log_Msg

709:
710: EXCEPTION WHEN OTHERS THEN
711: /*** hook failed -> log error ***/
712: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
713: jtm_message_log_pkg.Log_Msg
714: ( null
715: , g_table_name
716: , 'Caught exception in Delete_All_ACC_Records:' || fnd_global.local_chr(10) || sqlerrm
717: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);