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

Line 30: jtm_message_log_pkg.Log_Msg

26: /*** get debug level ***/
27: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
28:
29: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
30: jtm_message_log_pkg.Log_Msg
31: ( p_jtf_note_id
32: , g_table_name
33: , 'Entering Replicate_Record'
34: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 42: jtm_message_log_pkg.Log_Msg

38: FETCH c_jtf_note INTO r_jtf_note;
39: IF c_jtf_note%NOTFOUND THEN
40: /*** could not find jtf_note record -> exit ***/
41: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
42: jtm_message_log_pkg.Log_Msg
43: ( p_jtf_note_id
44: , g_table_name
45: , 'Replicate_Record error: Could not find jtf_note_id ' || p_jtf_note_id
46: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 55: jtm_message_log_pkg.Log_Msg

51: END IF;
52: CLOSE c_jtf_note;
53:
54: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
55: jtm_message_log_pkg.Log_Msg
56: ( p_jtf_note_id
57: , g_table_name
58: , 'Replicate_Record returned TRUE'
59: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 82: jtm_message_log_pkg.Log_Msg

78: /*** get debug level ***/
79: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
80:
81: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
82: jtm_message_log_pkg.Log_Msg
83: ( p_jtf_note_id
84: , g_table_name
85: , 'Entering Get_User_Id'
86: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 94: jtm_message_log_pkg.Log_Msg

90: FETCH c_jtf_note INTO r_jtf_note;
91: IF c_jtf_note%NOTFOUND THEN
92: /*** could not find jtf_note record -> exit ***/
93: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
94: jtm_message_log_pkg.Log_Msg
95: ( p_jtf_note_id
96: , g_table_name
97: , 'Get_User_Id error: Could not find jtf_note_id ' || p_jtf_note_id
98: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 107: jtm_message_log_pkg.Log_Msg

103: END IF;
104: CLOSE c_jtf_note;
105:
106: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
107: jtm_message_log_pkg.Log_Msg
108: ( p_jtf_note_id
109: , g_table_name
110: , 'Get_User_Id returned TRUE'
111: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 134: jtm_message_log_pkg.Log_Msg

130: /*** get debug level ***/
131: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
132:
133: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
134: jtm_message_log_pkg.Log_Msg
135: ( p_user_id
136: , g_table_name
137: , 'Entering Get_Resource_Extn_Id'
138: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 146: jtm_message_log_pkg.Log_Msg

142: FETCH c_jtf_rs_resource_extns INTO r_jtf_rs_resource_extns;
143: IF c_jtf_rs_resource_extns%NOTFOUND THEN
144: /*** could not find jtf_rs_resource_extns record -> exit ***/
145: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
146: jtm_message_log_pkg.Log_Msg
147: ( p_user_id
148: , g_table_name
149: , 'Get_Resource_Extn_Id error: Could not find p_user_id ' || p_user_id
150: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 159: jtm_message_log_pkg.Log_Msg

155: END IF;
156: CLOSE c_jtf_rs_resource_extns;
157:
158: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
159: jtm_message_log_pkg.Log_Msg
160: ( p_user_id
161: , g_table_name
162: , 'Get_Resource_Extn_Id returned TRUE'
163: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 178: jtm_message_log_pkg.Log_Msg

174: )
175: IS
176: BEGIN
177: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
178: jtm_message_log_pkg.Log_Msg
179: ( p_jtf_note_id
180: , g_table_name
181: , 'Entering Insert_ACC_Record'
182: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 186: jtm_message_log_pkg.Log_Msg

182: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
183: END IF;
184:
185: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
186: jtm_message_log_pkg.Log_Msg
187: ( p_jtf_note_id
188: , g_table_name
189: , 'Inserting ACC record for resource_id = ' || p_resource_id
190: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 203: jtm_message_log_pkg.Log_Msg

199: ,P_RESOURCE_ID => p_resource_id
200: );
201:
202: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
203: jtm_message_log_pkg.Log_Msg
204: ( p_jtf_note_id
205: , g_table_name
206: , 'Leaving Insert_ACC_Record'
207: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 220: jtm_message_log_pkg.Log_Msg

216: )
217: IS
218: BEGIN
219: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
220: jtm_message_log_pkg.Log_Msg
221: ( p_jtf_note_id
222: , g_table_name
223: , 'Entering Update_ACC_Record'
224: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 228: jtm_message_log_pkg.Log_Msg

224: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
225: END IF;
226:
227: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
228: jtm_message_log_pkg.Log_Msg
229: ( p_jtf_note_id
230: , g_table_name
231: , 'Updating ACC record for resource_id = ' || p_resource_id || fnd_global.local_chr(10) || 'access_id = ' || p_acc_id
232: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 244: jtm_message_log_pkg.Log_Msg

240: ,P_ACCESS_ID => p_acc_id
241: );
242:
243: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
244: jtm_message_log_pkg.Log_Msg
245: ( p_jtf_note_id
246: , g_table_name
247: , 'Leaving Update_ACC_Record'
248: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 260: jtm_message_log_pkg.Log_Msg

256: )
257: IS
258: BEGIN
259: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
260: jtm_message_log_pkg.Log_Msg
261: ( p_jtf_note_id
262: , g_table_name
263: , 'Entering Delete_ACC_Record'
264: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 268: jtm_message_log_pkg.Log_Msg

264: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
265: END IF;
266:
267: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
268: jtm_message_log_pkg.Log_Msg
269: ( p_jtf_note_id
270: , g_table_name
271: , 'Deleting ACC record for resource_id = ' || p_resource_id
272: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 285: jtm_message_log_pkg.Log_Msg

281: ,P_RESOURCE_ID => p_resource_id
282: );
283:
284: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
285: jtm_message_log_pkg.Log_Msg
286: ( p_jtf_note_id
287: , g_table_name
288: , 'Leaving Delete_ACC_Record'
289: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 312: jtm_message_log_pkg.Log_Msg

308: /*** get debug level ***/
309: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
310:
311: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
312: jtm_message_log_pkg.Log_Msg
313: ( p_jtf_note_id
314: , g_table_name
315: , 'Entering Pre_Insert_Child procedure'
316: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 353: jtm_message_log_pkg.Log_Msg

349: l_success := TRUE;
350: END IF;
351:
352: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
353: jtm_message_log_pkg.Log_Msg
354: ( p_jtf_note_id
355: , g_table_name
356: , 'Leaving Pre_Insert_Child procedure'
357: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 388: jtm_message_log_pkg.Log_Msg

384: /*** get debug level ***/
385: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
386:
387: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
388: jtm_message_log_pkg.Log_Msg
389: ( p_source_obj_id
390: , g_table_name
391: , 'Entering Pre_Insert_Children procedure'
392: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 405: jtm_message_log_pkg.Log_Msg

401: );
402:
403: IF l_dummy = FALSE THEN
404: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
405: jtm_message_log_pkg.Log_Msg
406: ( p_source_obj_id
407: , g_table_name
408: , 'Pre_Insert_Children: note was not insertable.'
409: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

Line 415: jtm_message_log_pkg.Log_Msg

411: END IF;
412: END LOOP;
413:
414: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
415: jtm_message_log_pkg.Log_Msg
416: ( p_source_obj_id
417: , g_table_name
418: , 'Leaving Pre_Insert_Children procedure'
419: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 442: jtm_message_log_pkg.Log_Msg

438: /*** get debug level ***/
439: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
440:
441: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
442: jtm_message_log_pkg.Log_Msg
443: ( p_jtf_note_id
444: , g_table_name
445: , 'Entering Post_Delete_Child'
446: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 476: jtm_message_log_pkg.Log_Msg

472: );
473: END IF;
474:
475: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
476: jtm_message_log_pkg.Log_Msg
477: ( p_jtf_note_id
478: , g_table_name
479: , 'Leaving Post_Delete_Child'
480: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 506: jtm_message_log_pkg.Log_Msg

502: /*** get debug level ***/
503: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
504:
505: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
506: jtm_message_log_pkg.Log_Msg
507: ( p_source_obj_id
508: , g_table_name
509: , 'Entering Post_Delete_Children procedure'
510: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 523: jtm_message_log_pkg.Log_Msg

519: );
520: END LOOP;
521:
522: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
523: jtm_message_log_pkg.Log_Msg
524: ( p_source_obj_id
525: , g_table_name
526: , 'Leaving Post_Delete_Children procedure'
527: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 601: jtm_message_log_pkg.Log_Msg

597: /*** get debug level ***/
598: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
599:
600: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
601: jtm_message_log_pkg.Log_Msg
602: ( p_jtf_note_id
603: , g_table_name
604: , 'Entering POST_INSERT hook'
605: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 613: jtm_message_log_pkg.Log_Msg

609: OPEN c_object( p_jtf_note_id );
610: FETCH c_object INTO r_object;
611: IF c_object%NOTFOUND THEN
612: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
613: jtm_message_log_pkg.Log_Msg
614: ( p_jtf_note_id
615: , g_table_name
616: , 'Objects for note '||p_jtf_note_id||' not found'
617: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 657: jtm_message_log_pkg.Log_Msg

653: END LOOP;
654: ELSE
655: /*Note is of not supported type*/
656: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
657: jtm_message_log_pkg.Log_Msg
658: ( p_jtf_note_id
659: , g_table_name
660: , 'Source_Object_Code '||r_object.SOURCE_OBJECT_CODE||' is not supported'
661: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 668: jtm_message_log_pkg.Log_Msg

664:
665: /*** Insert record if applicable ***/
666: IF l_replicate = FALSE THEN
667: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
668: jtm_message_log_pkg.Log_Msg
669: ( p_jtf_note_id
670: , g_table_name
671: , 'Note '||p_jtf_note_id||' did not match the criteria to be replicated'||fnd_global.local_chr(10)||
672: 'Object id = '||r_object.SOURCE_OBJECT_ID||fnd_global.local_chr(10)||

Line 681: jtm_message_log_pkg.Log_Msg

677: END IF; --c_object%NOTFOUND
678: CLOSE c_object;
679:
680: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
681: jtm_message_log_pkg.Log_Msg
682: ( p_jtf_note_id
683: , g_table_name
684: , 'Leaving POST_INSERT hook'
685: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 692: jtm_message_log_pkg.Log_Msg

688: x_return_status := FND_API.G_RET_STS_SUCCESS;
689: EXCEPTION WHEN OTHERS THEN
690: /*** hook failed -> log error ***/
691: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
692: jtm_message_log_pkg.Log_Msg
693: ( p_jtf_note_id
694: , g_table_name
695: , 'Caught exception in POST_INSERT hook:' || fnd_global.local_chr(10) || sqlerrm
696: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

Line 737: jtm_message_log_pkg.Log_Msg

733: /*** get debug level ***/
734: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
735:
736: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
737: jtm_message_log_pkg.Log_Msg
738: ( l_jtf_note_id
739: , g_table_name
740: , 'Entering POST_UPDATE hook'
741: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 751: jtm_message_log_pkg.Log_Msg

747: /*** replicate record after update? ***/
748: IF NOT l_replicate THEN
749: /*** yes -> re-send updated jtf_note record to all resources ***/
750: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
751: jtm_message_log_pkg.Log_Msg
752: ( l_jtf_note_id
753: , g_table_name
754: , 'Note was not replicateable after update.'
755: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 761: jtm_message_log_pkg.Log_Msg

757:
758: ELSE
759: /*** yes -> re-send updated note record to all resources ***/
760: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
761: jtm_message_log_pkg.Log_Msg
762: ( l_jtf_note_id
763: , g_table_name
764: , 'Note being re-sent to mobile users.'
765: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 792: jtm_message_log_pkg.Log_Msg

788: /*** is resource a mobile user? ***/
789: IF NOT JTM_HOOK_UTIL_PKG.isMobileFSresource( l_tab_resource_id(i) ) THEN
790: /*** No -> exit ***/
791: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
792: jtm_message_log_pkg.Log_Msg
793: ( l_tab_resource_id(i)
794: , g_table_name
795: , 'POST_UPDATE_DEBRIEF_LINE' || fnd_global.local_chr(10) ||
796: 'Resource_id ' || l_tab_resource_id(i) || ' is not a mobile user.'

Line 815: jtm_message_log_pkg.Log_Msg

811:
812: x_return_status := FND_API.G_RET_STS_SUCCESS;
813:
814: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
815: jtm_message_log_pkg.Log_Msg
816: ( l_jtf_note_id
817: , g_table_name
818: , 'Leaving POST_UPDATE hook'
819: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 825: jtm_message_log_pkg.Log_Msg

821:
822: EXCEPTION WHEN OTHERS THEN
823: /*** hook failed -> log error ***/
824: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
825: jtm_message_log_pkg.Log_Msg
826: ( l_jtf_note_id
827: , g_table_name
828: , 'Caught exception in POST_UPDATE hook:' || fnd_global.local_chr(10) || sqlerrm
829: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);