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

Line 164: jtm_message_log_pkg.Log_Msg

160: l_customer_account_id NUMBER;
161:
162: BEGIN
163: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
164: jtm_message_log_pkg.Log_Msg
165: ( v_object_id => p_record.incident_id
166: , v_object_name => g_object_name
167: , v_message => 'Entering ' || g_object_name || '.APPLY_INSERT'
168: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 394: jtm_message_log_pkg.Log_Msg

390: );
391: END IF;
392:
393: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
394: jtm_message_log_pkg.Log_Msg
395: ( v_object_id => p_record.incident_id
396: , v_object_name => g_object_name
397: , v_message => 'Leaving ' || g_object_name || '.APPLY_INSERT'
398: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 403: jtm_message_log_pkg.Log_Msg

399: END IF;
400:
401: EXCEPTION WHEN OTHERS THEN
402: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
403: jtm_message_log_pkg.Log_Msg
404: ( v_object_id => p_record.incident_id
405: , v_object_name => g_object_name
406: , v_message => 'Exception occurred in APPLY_INSERT:' || fnd_global.local_chr(10) || sqlerrm
407: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

Line 417: jtm_message_log_pkg.Log_Msg

413: p_api_error => TRUE
414: );
415:
416: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
417: jtm_message_log_pkg.Log_Msg
418: ( v_object_id => p_record.incident_id
419: , v_object_name => g_object_name
420: , v_message => 'Leaving ' || g_object_name || '.APPLY_INSERT'
421: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 485: jtm_message_log_pkg.Log_Msg

481: l_decript_value VARCHAR2(250);
482:
483: BEGIN
484: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
485: jtm_message_log_pkg.Log_Msg
486: ( v_object_id => p_record.incident_id
487: , v_object_name => g_object_name
488: , v_message => 'Entering ' || g_object_name || '.APPLY_UPDATE'
489: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 502: jtm_message_log_pkg.Log_Msg

498: if c_last_update_date%found then
499: if r_last_update_date.last_update_date <> p_record.last_update_date then
500: close c_last_update_date;
501: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
502: jtm_message_log_pkg.Log_Msg
503: ( v_object_id => p_record.incident_id
504: , v_object_name => g_object_name
505: , v_message => 'Record is stale data'
506: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 515: jtm_message_log_pkg.Log_Msg

511: );
512: fnd_msg_pub.add;
513:
514: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
515: jtm_message_log_pkg.Log_Msg
516: ( v_object_id => p_record.incident_id
517: , v_object_name => g_object_name
518: , v_message => 'Leaving ' || g_object_name || '.APPLY_UPDATE'
519: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 527: jtm_message_log_pkg.Log_Msg

523: return;
524: end if;
525: else
526: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
527: jtm_message_log_pkg.Log_Msg
528: ( v_object_id => p_record.incident_id
529: , v_object_name => g_object_name
530: , v_message => 'No record found in Apps Database.'
531: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 685: jtm_message_log_pkg.Log_Msg

681: (
682: p_api_error => TRUE
683: );
684: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
685: jtm_message_log_pkg.Log_Msg
686: ( v_object_id => p_record.incident_id
687: , v_object_name => g_object_name
688: , v_message => 'Leaving ' || g_object_name || '.APPLY_UPDATE'
689: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 695: jtm_message_log_pkg.Log_Msg

691: RETURN;
692: END IF;
693:
694: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
695: jtm_message_log_pkg.Log_Msg
696: ( v_object_id => p_record.incident_id
697: , v_object_name => g_object_name
698: , v_message => 'Leaving ' || g_object_name || '.APPLY_UPDATE'
699: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 704: jtm_message_log_pkg.Log_Msg

700: END IF;
701:
702: EXCEPTION WHEN OTHERS THEN
703: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
704: jtm_message_log_pkg.Log_Msg
705: ( v_object_id => p_record.incident_id
706: , v_object_name => g_object_name
707: , v_message => 'Exception occurred in APPLY_UPDATE:' || fnd_global.local_chr(10) || sqlerrm
708: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

Line 718: jtm_message_log_pkg.Log_Msg

714: p_api_error => TRUE
715: );
716:
717: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
718: jtm_message_log_pkg.Log_Msg
719: ( v_object_id => p_record.incident_id
720: , v_object_name => g_object_name
721: , v_message => 'Leaving ' || g_object_name || '.APPLY_UPDATE'
722: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 745: jtm_message_log_pkg.Log_Msg

741: x_return_status := FND_API.G_RET_STS_SUCCESS;
742: FND_MSG_PUB.INITIALIZE;
743:
744: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
745: jtm_message_log_pkg.Log_Msg
746: ( v_object_id => p_record.incident_id
747: , v_object_name => g_object_name
748: , v_message => 'Entering ' || g_object_name || '.APPLY_RECORD'
749: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 753: jtm_message_log_pkg.Log_Msg

749: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
750: END IF;
751:
752: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
753: jtm_message_log_pkg.Log_Msg
754: ( v_object_id => p_record.incident_id
755: , v_object_name => g_object_name
756: , v_message => 'Processing INCIDENT_ID = ' || p_record.incident_id || fnd_global.local_chr(10) ||
757: 'DMLTYPE = ' || p_record.dmltype$$

Line 780: jtm_message_log_pkg.Log_Msg

776: );
777: ELSIF p_record.dmltype$$='D' THEN
778: -- Process delete; not supported for this entity
779: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
780: jtm_message_log_pkg.Log_Msg
781: ( v_object_id => p_record.incident_id
782: , v_object_name => g_object_name
783: , v_message => 'Delete is not supported for this entity'
784: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

Line 798: jtm_message_log_pkg.Log_Msg

794: x_return_status := FND_API.G_RET_STS_ERROR;
795: ELSE
796: -- invalid dml type
797: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
798: jtm_message_log_pkg.Log_Msg
799: ( v_object_id => p_record.incident_id
800: , v_object_name => g_object_name
801: , v_message => 'Invalid DML type: ' || p_record.dmltype$$
802: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

Line 832: jtm_message_log_pkg.Log_Msg

828: );
829: END IF;
830:
831: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
832: jtm_message_log_pkg.Log_Msg
833: ( v_object_id => p_record.incident_id
834: , v_object_name => g_object_name
835: , v_message => 'Leaving ' || g_object_name || '.APPLY_RECORD'
836: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 841: jtm_message_log_pkg.Log_Msg

837: END IF;
838: EXCEPTION WHEN OTHERS THEN
839: /*** defer record when any process exception occurs ***/
840: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
841: jtm_message_log_pkg.Log_Msg
842: ( v_object_id => p_record.incident_id
843: , v_object_name => g_object_name
844: , v_message => 'Exception occurred in APPLY_RECORD:' || fnd_global.local_chr(10) || sqlerrm
845: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

Line 855: jtm_message_log_pkg.Log_Msg

851: p_api_error => TRUE
852: );
853:
854: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
855: jtm_message_log_pkg.Log_Msg
856: ( v_object_id => p_record.incident_id
857: , v_object_name => g_object_name
858: , v_message => 'Leaving ' || g_object_name || '.APPLY_RECORD'
859: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 886: jtm_message_log_pkg.Log_Msg

882: g_debug_level := p_debug_level;
883: x_return_status := FND_API.G_RET_STS_SUCCESS;
884:
885: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
886: jtm_message_log_pkg.Log_Msg
887: ( v_object_id => null
888: , v_object_name => g_object_name
889: , v_message => 'Entering ' || g_object_name || '.Apply_Client_Changes'
890: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 908: jtm_message_log_pkg.Log_Msg

904: /*** was record processed successfully? ***/
905: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN
906: /*** Yes -> delete record from inqueue ***/
907: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
908: jtm_message_log_pkg.Log_Msg
909: ( v_object_id => r_incident.incident_id
910: , v_object_name => g_object_name
911: , v_message => 'Record successfully processed, deleting from inqueue'
912: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 929: jtm_message_log_pkg.Log_Msg

925: );
926: /*** was delete successful? ***/
927: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
928: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
929: jtm_message_log_pkg.Log_Msg
930: ( v_object_id => r_incident.incident_id
931: , v_object_name => g_object_name
932: , v_message => 'Deleting from inqueue failed'
933: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 954: jtm_message_log_pkg.Log_Msg

950: );
951: /*** was delete successful? ***/
952: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
953: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
954: jtm_message_log_pkg.Log_Msg
955: ( v_object_id => r_contacts.SR_CONTACT_POINT_ID
956: , v_object_name => g_object_name
957: , v_message => 'Deleting from inqueue failed'
958: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 965: jtm_message_log_pkg.Log_Msg

961: END LOOP;
962: ELSIF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN
963: /*** Record was not applied successfully -> defer and reject records ***/
964: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
965: jtm_message_log_pkg.Log_Msg
966: ( v_object_id => r_incident.incident_id
967: , v_object_name => g_object_name
968: , v_message => 'Record not processed successfully, deferring and rejecting records'
969: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 1005: jtm_message_log_pkg.Log_Msg

1001:
1002: END LOOP;
1003:
1004: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1005: jtm_message_log_pkg.Log_Msg
1006: ( v_object_id => null
1007: , v_object_name => g_object_name
1008: , v_message => 'Leaving ' || g_object_name || '.Apply_Client_Changes'
1009: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 1015: jtm_message_log_pkg.Log_Msg

1011:
1012: EXCEPTION WHEN OTHERS THEN
1013: /*** catch and log exceptions ***/
1014: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
1015: jtm_message_log_pkg.Log_Msg
1016: ( v_object_id => null
1017: , v_object_name => g_object_name
1018: , v_message => 'Exception occurred in APPLY_CLIENT_CHANGES:' || fnd_global.local_chr(10) || sqlerrm
1019: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);