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

Line 99: jtm_message_log_pkg.Log_Msg (

95: WHEN l_excep_markdirty_failed THEN
96:
97: l_err_mesg := 'EXCEPTION IN CSL_LOBS_PKG.INSERT_ACC_RECORD :'
98: || to_char(p_task_assignment_id);
99: jtm_message_log_pkg.Log_Msg (
100: p_task_assignment_id
101: , 'LOBS_ACC_PKG.INSERT_ACC'
102: , l_err_mesg
103: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 110: jtm_message_log_pkg.Log_Msg (

106:
107: WHEN OTHERS THEN
108: l_err_mesg := 'EXCEPTION IN CSL_LOBS_PKG.INSERT_ACC_RECORD : '
109: || to_char(p_task_assignment_id);
110: jtm_message_log_pkg.Log_Msg (
111: p_task_assignment_id
112: , 'LOBS_ACC_PKG.INSERT_ACC'
113: , l_err_mesg
114: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 207: jtm_message_log_pkg.Log_Msg (

203: EXCEPTION
204: WHEN l_excep_markdirty_failed then
205: l_err_mesg := 'EXCEPTION IN CSL_LOBS_PKG.DELETE_ACC_RECORD :'
206: || to_char(p_task_assignment_id);
207: jtm_message_log_pkg.Log_Msg (
208: p_task_assignment_id
209: , 'LOBS_ACC_PKG.INSERT_ACC'
210: , l_err_mesg
211: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 217: jtm_message_log_pkg.Log_Msg (

213:
214: WHEN OTHERS THEN
215: l_err_mesg := 'EXCEPTION IN CSL_LOBS_PKG.DELETE_ACC_RECORD :'
216: || to_char(p_task_assignment_id);
217: jtm_message_log_pkg.Log_Msg (
218: p_task_assignment_id
219: , 'LOBS_ACC_PKG.INSERT_ACC'
220: , l_err_mesg
221: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 356: jtm_message_log_pkg.Log_Msg

352:
353: /*** get debug level ***/
354: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
355: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
356: jtm_message_log_pkg.Log_Msg
357: ( 0
358: , g_table_name
359: , 'Entering CONC_DOWNLOAD_ATTACHMENTS'
360: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

Line 390: jtm_message_log_pkg.Log_Msg

386: p_message := 'CSL_LOBS_ACC_PKG.CONC_DOWNLOAD_ATTACHMENTS '
387: || ' Executed successfully';
388:
389: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
390: jtm_message_log_pkg.Log_Msg
391: ( 0
392: , g_table_name
393: , 'Leaving CONC_DOWNLOAD_ATTACHMENTS - Max att download size is less than 1'
394: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

Line 407: jtm_message_log_pkg.Log_Msg

403: CLOSE c_SRAtt;
404:
405: IF l_tab_access_id.COUNT > 0 THEN
406: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
407: jtm_message_log_pkg.Log_Msg
408: ( 0
409: , g_table_name
410: , 'Pushing ' || l_tab_access_id.COUNT || ' updated record(s)'
411: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

Line 435: jtm_message_log_pkg.Log_Msg

431: CLOSE c_TaskAtt;
432:
433: IF l_tab_access_id.COUNT > 0 THEN
434: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
435: jtm_message_log_pkg.Log_Msg
436: ( 0
437: , g_table_name
438: , 'Pushing ' || l_tab_access_id.COUNT || ' updated record(s)'
439: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

Line 463: jtm_message_log_pkg.Log_Msg

459: CLOSE c_PartyAtt;
460:
461: IF l_tab_access_id.COUNT > 0 THEN
462: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
463: jtm_message_log_pkg.Log_Msg
464: ( 0
465: , g_table_name
466: , 'Pushing ' || l_tab_access_id.COUNT || ' updated record(s)'
467: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

Line 490: jtm_message_log_pkg.Log_Msg

486: CLOSE c_IBItemAtt;
487:
488: IF l_tab_access_id.COUNT > 0 THEN
489: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
490: jtm_message_log_pkg.Log_Msg
491: ( 0
492: , g_table_name
493: , 'Pushing ' || l_tab_access_id.COUNT || ' updated record(s)'
494: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

Line 518: jtm_message_log_pkg.Log_Msg

514: CLOSE c_DebriefAtt;
515:
516: IF l_tab_access_id.COUNT > 0 THEN
517: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
518: jtm_message_log_pkg.Log_Msg
519: ( 0
520: , g_table_name
521: , 'Pushing ' || l_tab_access_id.COUNT || ' updated record(s)'
522: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

Line 548: jtm_message_log_pkg.Log_Msg

544: p_message := 'CSL_LOBS_ACC_PKG.CONC_DOWNLOAD_ATTACHMENTS '
545: || ' Executed successfully';
546:
547: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
548: jtm_message_log_pkg.Log_Msg
549: ( 0
550: , g_table_name
551: , 'Leaving CONC_DOWNLOAD_ATTACHMENTS'
552: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

Line 566: jtm_message_log_pkg.Log_Msg

562: || substr(SQLERRM, 1, 2000);
563:
564:
565: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
566: jtm_message_log_pkg.Log_Msg
567: ( 0
568: , g_table_name
569: , 'CONC_DOWNLOAD_ATTACHMENTS'||fnd_global.local_chr(10)||
570: 'Error: '||sqlerrm

Line 612: jtm_message_log_pkg.Log_Msg

608:
609: /*** get debug level ***/
610: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
611: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
612: jtm_message_log_pkg.Log_Msg
613: ( 0
614: , g_table_name
615: , 'Entering DOWNLOAD_SR_ATTACHMENTS'
616: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

Line 630: jtm_message_log_pkg.Log_Msg

626: IF (TO_NUMBER(FND_PROFILE.Value('CSM_MAX_ATTACHMENT_SIZE')) < 1) THEN
627: /*Update the last run date*/
628:
629: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
630: jtm_message_log_pkg.Log_Msg
631: ( 0
632: , g_table_name
633: , 'Leaving DOWNLOAD_SR_ATTACHMENTS - Max att download size is less than 1'
634: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

Line 647: jtm_message_log_pkg.Log_Msg

643: CLOSE c_SRAtt;
644:
645: IF l_tab_access_id.COUNT > 0 THEN
646: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
647: jtm_message_log_pkg.Log_Msg
648: ( 0
649: , g_table_name
650: , 'Pushing ' || l_tab_access_id.COUNT || ' updated record(s)'
651: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

Line 666: jtm_message_log_pkg.Log_Msg

662: END IF;
663:
664:
665: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
666: jtm_message_log_pkg.Log_Msg
667: ( 0
668: , g_table_name
669: , 'Leaving DOWNLOAD_SR_ATTACHMENTS'
670: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

Line 678: jtm_message_log_pkg.Log_Msg

674: EXCEPTION
675:
676: WHEN OTHERS THEN
677: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
678: jtm_message_log_pkg.Log_Msg
679: ( 0
680: , g_table_name
681: , 'DOWNLOAD_SR_ATTACHMENTS'||fnd_global.local_chr(10)||
682: 'Error: '||sqlerrm

Line 725: jtm_message_log_pkg.Log_Msg

721:
722: /*** get debug level ***/
723: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
724: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
725: jtm_message_log_pkg.Log_Msg
726: ( 0
727: , g_table_name
728: , 'Entering DOWNLOAD_TASK_ATTACHMENTS'
729: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

Line 737: jtm_message_log_pkg.Log_Msg

733: --If the max size of attachment is less than 1, then exit.
734: IF (TO_NUMBER(FND_PROFILE.Value('CSM_MAX_ATTACHMENT_SIZE')) < 1) THEN
735:
736: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
737: jtm_message_log_pkg.Log_Msg
738: ( 0
739: , g_table_name
740: , 'Leaving DOWNLOAD_TASK_ATTACHMENTS - Max att download size is less than 1'
741: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

Line 758: jtm_message_log_pkg.Log_Msg

754: CLOSE c_TaskAtt;
755:
756: IF l_tab_access_id.COUNT > 0 THEN
757: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
758: jtm_message_log_pkg.Log_Msg
759: ( 0
760: , g_table_name
761: , 'Pushing ' || l_tab_access_id.COUNT || ' updated record(s)'
762: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

Line 776: jtm_message_log_pkg.Log_Msg

772:
773: END IF;
774:
775: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
776: jtm_message_log_pkg.Log_Msg
777: ( 0
778: , g_table_name
779: , 'Leaving DOWNLOAD_TASK_ATTACHMENTS'
780: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

Line 788: jtm_message_log_pkg.Log_Msg

784: EXCEPTION
785:
786: WHEN OTHERS THEN
787: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
788: jtm_message_log_pkg.Log_Msg
789: ( 0
790: , g_table_name
791: , 'DOWNLOAD_TASK_ATTACHMENTS'||fnd_global.local_chr(10)||
792: 'Error: '||sqlerrm

Line 858: jtm_message_log_pkg.Log_Msg

854:
855: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
856:
857: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
858: jtm_message_log_pkg.Log_Msg
859: ( p_primary_key
860: , g_table_name
861: , 'Entering Delete_Attachments'
862: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 868: jtm_message_log_pkg.Log_Msg

864:
865: IF (p_entity_name = 'CS_INCIDENTS') THEN
866:
867: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
868: jtm_message_log_pkg.Log_Msg
869: ( p_primary_key
870: , g_table_name
871: , 'Deleting record for CS_INCIDENTS and resource_id: ' || p_resource_id
872: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 881: jtm_message_log_pkg.Log_Msg

877: CLOSE c_SRAtt;
878:
879: IF l_tab_access_id.COUNT > 0 THEN
880: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
881: jtm_message_log_pkg.Log_Msg
882: ( 0
883: , g_table_name
884: , 'Pushing ' || l_tab_access_id.COUNT || ' updated record(s)'
885: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

Line 904: jtm_message_log_pkg.Log_Msg

900:
901: IF (p_entity_name = 'JTF_TASKS_B') THEN
902:
903: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
904: jtm_message_log_pkg.Log_Msg
905: ( p_primary_key
906: , g_table_name
907: , 'Deleting record for JTF_TASKS_B and resource_id: ' || p_resource_id
908: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 917: jtm_message_log_pkg.Log_Msg

913: CLOSE c_TaskAtt;
914:
915: IF l_tab_access_id.COUNT > 0 THEN
916: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
917: jtm_message_log_pkg.Log_Msg
918: ( 0
919: , g_table_name
920: , 'Pushing ' || l_tab_access_id.COUNT || ' updated record(s)'
921: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

Line 936: jtm_message_log_pkg.Log_Msg

932: END IF;
933: END IF; --IF (p_entity_name = 'JTF_TASKS_B') THEN
934:
935: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
936: jtm_message_log_pkg.Log_Msg
937: ( p_primary_key
938: , g_table_name
939: , 'Exiting Delete_Attachments'
940: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 948: jtm_message_log_pkg.Log_Msg (

944:
945: WHEN OTHERS THEN
946: l_err_mesg := 'EXCEPTION IN ' || p_entity_name
947: || ' '|| substr(sqlerrm, 0 , 255);
948: jtm_message_log_pkg.Log_Msg (
949: p_primary_key
950: , 'LOBS_ACC_PKG.DELETE_ATTACHMENTS'
951: , l_err_mesg
952: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);