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.CSM_LOBS_EVENT_PKG dependencies on JTM_MESSAGE_LOG_PKG

Line 159: jtm_message_log_pkg.Log_Msg

155: l_run_date := SYSDATE;
156: /*** get debug level ***/
157: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
158: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
159: jtm_message_log_pkg.Log_Msg
160: ( 0
161: , g_table_name
162: , 'Entering CONC_DOWNLOAD_ATTACHMENTS'
163: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

Line 200: jtm_message_log_pkg.Log_Msg

196: p_message := 'CSM_LOBS_EVENT_PKG.CONC_DOWNLOAD_ATTACHMENTS '
197: || ' Executed successfully';
198:
199: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
200: jtm_message_log_pkg.Log_Msg
201: ( 0
202: , g_table_name
203: , 'Leaving CONC_DOWNLOAD_ATTACHMENTS - Max att download size is less than 1'
204: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

Line 212: jtm_message_log_pkg.Log_Msg

208: END IF;
209:
210:
211: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
212: jtm_message_log_pkg.Log_Msg
213: ( 0
214: , g_table_name
215: , 'Downloading Attachments for SRs'
216: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

Line 230: jtm_message_log_pkg.Log_Msg

226: CLOSE l_SRAtt_csr;
227:
228: IF l_tab_access_id.COUNT > 0 THEN
229: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
230: jtm_message_log_pkg.Log_Msg
231: ( 0
232: , g_table_name
233: , 'Pushing ' || l_tab_access_id.COUNT || ' updated record(s)'
234: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

Line 292: jtm_message_log_pkg.Log_Msg

288: CLOSE l_TaskAtt_csr;
289:
290: IF l_tab_access_id.COUNT > 0 THEN
291: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
292: jtm_message_log_pkg.Log_Msg
293: ( 0
294: , g_table_name
295: , 'Pushing ' || l_tab_access_id.COUNT || ' updated record(s)'
296: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

Line 355: jtm_message_log_pkg.Log_Msg

351: CLOSE c_Signature;
352:
353: IF l_tab_access_id.COUNT > 0 THEN
354: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
355: jtm_message_log_pkg.Log_Msg
356: ( 0
357: , g_table_name
358: , 'Pushing ' || l_tab_access_id.COUNT || ' updated record(s)'
359: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

Line 529: jtm_message_log_pkg.Log_Msg

525:
526: /*** get debug level ***/
527: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
528: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
529: jtm_message_log_pkg.Log_Msg
530: ( 0
531: , g_table_name
532: , 'Entering INSERT_ALL_ACC_RECORDS'
533: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

Line 568: jtm_message_log_pkg.Log_Msg

564: CLOSE c_Signature;
565:
566: IF l_tab_access_id.COUNT > 0 THEN
567: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
568: jtm_message_log_pkg.Log_Msg
569: ( 0
570: , g_table_name
571: , 'Pushing ' || l_tab_access_id.COUNT || ' updated record(s)'
572: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

Line 621: jtm_message_log_pkg.Log_Msg

617:
618: --If the max size of attachment is less than 1, then exit.
619: IF (TO_NUMBER(FND_PROFILE.Value('CSM_MAX_ATTACHMENT_SIZE')) < 1) THEN
620: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
621: jtm_message_log_pkg.Log_Msg
622: ( 0
623: , g_table_name
624: , 'Leaving INSERT_ALL_ACC_RECORDS - Max att download size is less than 1'
625: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

Line 634: jtm_message_log_pkg.Log_Msg

630: RETURN;
631: END IF;
632:
633: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
634: jtm_message_log_pkg.Log_Msg
635: ( 0
636: , g_table_name
637: , 'Downloading Attachments for SRs'
638: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

Line 651: jtm_message_log_pkg.Log_Msg

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

Line 683: jtm_message_log_pkg.Log_Msg

679:
680: END IF;
681:
682: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
683: jtm_message_log_pkg.Log_Msg
684: ( 0
685: , g_table_name
686: , 'Downloading Attachments for Tasks'
687: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

Line 719: jtm_message_log_pkg.Log_Msg

715: CLOSE c_TaskAtt;
716:
717: IF l_tab_access_id.COUNT > 0 THEN
718: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
719: jtm_message_log_pkg.Log_Msg
720: ( 0
721: , g_table_name
722: , 'Pushing ' || l_tab_access_id.COUNT || ' updated record(s)'
723: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

Line 752: jtm_message_log_pkg.Log_Msg

748: END IF;
749:
750:
751: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
752: jtm_message_log_pkg.Log_Msg
753: ( 0
754: , g_table_name
755: , 'Downloading Signatures'
756: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

Line 764: jtm_message_log_pkg.Log_Msg

760:
761: x_return_status := FND_API.G_RET_STS_SUCCESS;
762:
763: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
764: jtm_message_log_pkg.Log_Msg
765: ( 0
766: , g_table_name
767: , 'Leaving INSERT_ALL_ACC_RECORDS'
768: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

Line 777: jtm_message_log_pkg.Log_Msg

773:
774: WHEN OTHERS THEN
775: x_return_status := FND_API.G_RET_STS_ERROR;
776: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
777: jtm_message_log_pkg.Log_Msg
778: ( 0
779: , g_table_name
780: , 'INSERT_ALL_ACC_RECORDS'||fnd_global.local_chr(10)||
781: 'Error: '||sqlerrm

Line 953: jtm_message_log_pkg.Log_Msg

949: ---DOWNLOAD SR AND TASK Attachments
950: /*** get debug level ***/
951: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
952: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
953: jtm_message_log_pkg.Log_Msg
954: ( 0
955: , g_table_name
956: , 'Entering CSM_LOBS_EVENT_PKG.INSERT_ACC_RECORD'
957: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

Line 990: jtm_message_log_pkg.Log_Msg

986: CLOSE l_signature_csr;
987:
988: IF l_tab_access_id.COUNT > 0 THEN
989: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
990: jtm_message_log_pkg.Log_Msg
991: ( 0
992: , g_table_name
993: , 'Pushing ' || l_tab_access_id.COUNT || ' updated record(s)'
994: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

Line 1026: jtm_message_log_pkg.Log_Msg

1022: --If the max size of attachment is less than 1, then exit.(this should be done only
1023: --for SR and TASK attachments)
1024: IF (TO_NUMBER(FND_PROFILE.Value('CSM_MAX_ATTACHMENT_SIZE')) < 1) THEN
1025: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1026: jtm_message_log_pkg.Log_Msg
1027: ( 0
1028: , g_table_name
1029: , 'Leaving CSM_LOBS_EVENT_PKG.INSERT_ACC_RECORD - Max att download size is less than 1'
1030: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

Line 1038: jtm_message_log_pkg.Log_Msg

1034: END IF;
1035:
1036:
1037: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1038: jtm_message_log_pkg.Log_Msg
1039: ( 0
1040: , g_table_name
1041: , 'Downloading Attachments for SRs'
1042: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

Line 1075: jtm_message_log_pkg.Log_Msg

1071: CLOSE l_SRAtt_csr;
1072:
1073: IF l_tab_access_id.COUNT > 0 THEN
1074: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
1075: jtm_message_log_pkg.Log_Msg
1076: ( 0
1077: , g_table_name
1078: , 'Pushing ' || l_tab_access_id.COUNT || ' updated record(s)'
1079: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

Line 1137: jtm_message_log_pkg.Log_Msg

1133: CLOSE l_TaskAtt_csr;
1134:
1135: IF l_tab_access_id.COUNT > 0 THEN
1136: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
1137: jtm_message_log_pkg.Log_Msg
1138: ( 0
1139: , g_table_name
1140: , 'Pushing ' || l_tab_access_id.COUNT || ' updated record(s)'
1141: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

Line 1251: jtm_message_log_pkg.Log_Msg

1247:
1248: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
1249:
1250: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1251: jtm_message_log_pkg.Log_Msg
1252: ( p_task_assignment_id
1253: , g_table_name
1254: , 'Entering CSM_LOBS_EVENT_PKG.DELETE_ACC_RECORD'
1255: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 1266: jtm_message_log_pkg.Log_Msg

1262:
1263: --Deleting Signature attachments
1264:
1265: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
1266: jtm_message_log_pkg.Log_Msg
1267: ( p_task_assignment_id
1268: , g_table_name
1269: , 'Deleting record for CS_INCIDENTS and resource_id: ' || p_resource_id
1270: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 1279: jtm_message_log_pkg.Log_Msg

1275: CLOSE l_signature_csr;
1276:
1277: IF l_tab_access_id.COUNT > 0 THEN
1278: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
1279: jtm_message_log_pkg.Log_Msg
1280: ( 0
1281: , g_table_name
1282: , 'Pushing ' || l_tab_access_id.COUNT || ' updated record(s)'
1283: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

Line 1303: jtm_message_log_pkg.Log_Msg

1299: END IF;
1300:
1301: --SR attachment deletion
1302: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
1303: jtm_message_log_pkg.Log_Msg
1304: ( p_task_assignment_id
1305: , g_table_name
1306: , 'Deleting record for CS_INCIDENTS and resource_id: ' || p_resource_id
1307: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 1316: jtm_message_log_pkg.Log_Msg

1312: CLOSE c_SRAtt;
1313:
1314: IF l_tab_access_id.COUNT > 0 THEN
1315: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
1316: jtm_message_log_pkg.Log_Msg
1317: ( 0
1318: , g_table_name
1319: , 'Pushing ' || l_tab_access_id.COUNT || ' updated record(s)'
1320: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

Line 1342: jtm_message_log_pkg.Log_Msg

1338: ----------------------------------
1339: --Deletion for Tasks
1340: -----------------------------------
1341: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
1342: jtm_message_log_pkg.Log_Msg
1343: ( p_task_assignment_id
1344: , g_table_name
1345: , 'Deleting record for JTF_TASKS_B and resource_id: ' || p_resource_id
1346: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 1355: jtm_message_log_pkg.Log_Msg

1351: CLOSE l_TaskAtt_csr;
1352:
1353: IF l_tab_access_id.COUNT > 0 THEN
1354: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
1355: jtm_message_log_pkg.Log_Msg
1356: ( 0
1357: , g_table_name
1358: , 'Pushing ' || l_tab_access_id.COUNT || ' updated record(s)'
1359: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

Line 1378: jtm_message_log_pkg.Log_Msg

1374:
1375: END IF;
1376:
1377: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1378: jtm_message_log_pkg.Log_Msg
1379: ( p_task_assignment_id
1380: , g_table_name
1381: , 'Exiting CSM_LOBS_EVENT_PKG.DELETE_ACC_RECORD'
1382: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 1553: jtm_message_log_pkg.Log_Msg

1549: ---DOWNLOAD SR AND TASK Attachments
1550: /*** get debug level ***/
1551: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
1552: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1553: jtm_message_log_pkg.Log_Msg
1554: ( 0
1555: , g_table_name
1556: , 'Entering CSM_LOBS_EVENT_PKG.INSERT_ACC_ON_UPLOAD'
1557: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

Line 1564: jtm_message_log_pkg.Log_Msg

1560: --If the max size of attachment is less than 1, then exit.(this should be done only
1561: --for SR and TASK attachments)
1562: IF (TO_NUMBER(FND_PROFILE.Value('CSM_MAX_ATTACHMENT_SIZE')) < 1) THEN
1563: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1564: jtm_message_log_pkg.Log_Msg
1565: ( 0
1566: , g_table_name
1567: , 'Leaving CSM_LOBS_EVENT_PKG.INSERT_ACC_ON_UPLOAD - Max att download size is less than 1'
1568: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

Line 1594: jtm_message_log_pkg.Log_Msg

1590: l_tab_document_id.delete;
1591: l_tab_title.delete;
1592:
1593: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1594: jtm_message_log_pkg.Log_Msg
1595: ( 0
1596: , g_table_name
1597: , 'Downloading Attachments for SRs'
1598: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

Line 1638: jtm_message_log_pkg.Log_Msg

1634:
1635: IF l_tab_access_id.COUNT > 0 THEN
1636:
1637: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
1638: jtm_message_log_pkg.Log_Msg
1639: ( 0
1640: , g_table_name
1641: , 'Pushing ' || l_tab_access_id.COUNT || ' updated record(s)'
1642: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM