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

Line 20: jtm_message_log_pkg.Log_Msg

16: , p_resource_id NUMBER )
17: IS
18: BEGIN
19: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
20: jtm_message_log_pkg.Log_Msg
21: ( null
22: , g_table_name
23: , 'Entering INSERT_MAPPING_RECORD for incident '||p_incident_id
24: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

Line 39: jtm_message_log_pkg.Log_Msg

35: ,P_PK2_NUM_VALUE => p_history_id
36: );
37:
38: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
39: jtm_message_log_pkg.Log_Msg
40: ( null
41: , g_table_name
42: , 'Leaving INSERT_MAPPING_RECORD for incident '||p_incident_id
43: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

Line 47: jtm_message_log_pkg.Log_Msg( null

43: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
44: , 'csl_service_history_pkg');
45: END IF;
46: EXCEPTION WHEN OTHERS THEN
47: jtm_message_log_pkg.Log_Msg( null
48: , g_table_name
49: , 'Exception in CSL_SERVICE_HISTORY_PKG.INSERT_MAPPING_RECORD for incident '||p_incident_id||
50: ' and resource '||p_resource_id || ':' || fnd_global.local_chr(10) || sqlerrm
51: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR

Line 62: jtm_message_log_pkg.Log_Msg

58: , p_resource_id NUMBER )
59: IS
60: BEGIN
61: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
62: jtm_message_log_pkg.Log_Msg
63: ( null
64: , g_table_name
65: , 'Entering DELETE_MAPPING_RECORD for incident '||p_incident_id
66: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

Line 81: jtm_message_log_pkg.Log_Msg

77: ,P_PK2_NUM_VALUE => p_history_id
78: );
79:
80: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
81: jtm_message_log_pkg.Log_Msg
82: ( null
83: , g_table_name
84: , 'Leaving DELETE_MAPPING_RECORD for incident '||p_incident_id
85: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

Line 89: jtm_message_log_pkg.Log_Msg( null

85: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
86: , 'csl_service_history_pkg');
87: END IF;
88: EXCEPTION WHEN OTHERS THEN
89: jtm_message_log_pkg.Log_Msg( null
90: , g_table_name
91: , 'Exception in CSL_SERVICE_HISTORY_PKG.DELETE_MAPPING_RECORD for incident '||p_incident_id||
92: ' and resource '||p_resource_id||':'|| fnd_global.local_chr(10) || sqlerrm
93: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR

Line 117: jtm_message_log_pkg.Log_Msg

113: AND TRUNC(NVL(fur.end_date,sysdate));
114:
115: BEGIN
116: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
117: jtm_message_log_pkg.Log_Msg
118: ( null
119: , g_table_name
120: , 'Entering GET_HISTORY_COUNT for resource '||p_resource_id
121: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

Line 141: jtm_message_log_pkg.Log_Msg

137: END IF;
138: END LOOP;
139:
140: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
141: jtm_message_log_pkg.Log_Msg
142: ( null
143: , g_table_name
144: , 'Leaving GET_HISTORY_COUNT for for resource '||p_resource_id||
145: ' with value '||l_max_count

Line 151: jtm_message_log_pkg.Log_Msg( null

147: , 'csl_service_history_pkg');
148: END IF;
149: RETURN l_max_count;
150: EXCEPTION WHEN OTHERS THEN
151: jtm_message_log_pkg.Log_Msg( null
152: , g_table_name
153: , 'Exception in CSL_SERVICE_HISTORY_PKG.GET_HISTORY_COUNT for resource '||p_resource_id||':'
154: || fnd_global.local_chr(10) || sqlerrm
155: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR

Line 190: jtm_message_log_pkg.Log_Msg

186: AND NVL(ts.CANCELLED_FLAG,'N') <> 'Y'
187: AND NVL(ts.REJECTED_FLAG, 'N') <> 'Y';
188: BEGIN
189: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
190: jtm_message_log_pkg.Log_Msg
191: ( null
192: , g_table_name
193: , 'Entering DELETE_HISTORY_SR_RECORD for incident '||p_incident_id
194: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

Line 223: jtm_message_log_pkg.Log_Msg

219: END LOOP;
220: END LOOP;
221: DELETE_MAPPING_RECORD( p_incident_id, p_history_id, p_resource_id );
222: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
223: jtm_message_log_pkg.Log_Msg
224: ( null
225: , g_table_name
226: , 'Leaving DELETE_HISTORY_SR_RECORD for incident '||p_incident_id
227: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

Line 231: jtm_message_log_pkg.Log_Msg

227: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
228: , 'csl_service_history_pkg');
229: END IF;
230: EXCEPTION WHEN OTHERS THEN
231: jtm_message_log_pkg.Log_Msg
232: ( null
233: , g_table_name
234: , 'Exception in CSL_SERVICE_HISTORY_PKG.DELETE_HISTORY_SR_RECORD for incident '||p_incident_id||
235: ' and resource '||p_resource_id||':'|| fnd_global.local_chr(10) || sqlerrm

Line 275: jtm_message_log_pkg.Log_Msg

271: AND NVL(ts.REJECTED_FLAG,'N') <> 'Y';
272:
273: BEGIN
274: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
275: jtm_message_log_pkg.Log_Msg
276: ( null
277: , g_table_name
278: , 'Entering CREATE_HISTORY_SR_RECORD for incident '||p_incident_id
279: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

Line 284: jtm_message_log_pkg.Log_Msg

280: , 'csl_service_history_pkg');
281: END IF;
282:
283: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
284: jtm_message_log_pkg.Log_Msg
285: ( null
286: , g_table_name
287: , 'Inserting history record '||p_history_id||' for incident '||
288: p_incident_id||' and resource '||p_resource_id

Line 321: jtm_message_log_pkg.Log_Msg

317: END LOOP;
318: END LOOP;
319:
320: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
321: jtm_message_log_pkg.Log_Msg
322: ( null
323: , g_table_name
324: , 'Leaving CREATE_HISTORY_SR_RECORD for incident '||p_incident_id
325: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

Line 329: jtm_message_log_pkg.Log_Msg

325: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
326: , 'csl_service_history_pkg');
327: END IF;
328: EXCEPTION WHEN OTHERS THEN
329: jtm_message_log_pkg.Log_Msg
330: ( null
331: , g_table_name
332: , 'Exception in CSL_SERVICE_HISTORY_PKG.CREATE_HISTORY_SR_RECORD for incident '||p_incident_id||
333: ' and resource '||p_resource_id||':'|| fnd_global.local_chr(10) || sqlerrm

Line 354: jtm_message_log_pkg.Log_Msg

350: /*** get debug level ***/
351: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
352:
353: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
354: jtm_message_log_pkg.Log_Msg
355: ( null
356: , g_table_name
357: , 'Entering DELETE_HISTORY for incident '||p_incident_id
358: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

Line 364: jtm_message_log_pkg.Log_Msg

360: END IF;
361:
362: FOR r_history IN c_history( p_incident_id, p_resource_id ) LOOP
363: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
364: jtm_message_log_pkg.Log_Msg
365: ( null
366: , g_table_name
367: , 'Calling delete history record for incident id '||p_incident_id||
368: ' and history id '||r_history.HISTORY_INCIDENT_ID||' and resource id '||p_resource_id

Line 376: jtm_message_log_pkg.Log_Msg

372: DELETE_HISTORY_SR_RECORD( p_incident_id, r_history.HISTORY_INCIDENT_ID, p_resource_id );
373: END LOOP;
374:
375: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
376: jtm_message_log_pkg.Log_Msg
377: ( null
378: , g_table_name
379: , 'Leaving DELETE_HISTORY for incident '||p_incident_id
380: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

Line 384: jtm_message_log_pkg.Log_Msg

380: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
381: , 'csl_service_history_pkg');
382: END IF;
383: EXCEPTION WHEN OTHERS THEN
384: jtm_message_log_pkg.Log_Msg
385: ( null
386: , g_table_name
387: , 'Exception in CSL_SERVICE_HISTORY_PKG.DELETE_HISTORY for incident '||p_incident_id||
388: ' and resource '||p_resource_id||':'|| fnd_global.local_chr(10) || sqlerrm

Line 504: jtm_message_log_pkg.Log_Msg

500: /*** get debug level ***/
501: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
502:
503: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
504: jtm_message_log_pkg.Log_Msg
505: ( null
506: , g_table_name
507: , 'Entering CALCULATE_HISTORY for incident '||p_incident_id
508: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

Line 533: jtm_message_log_pkg.Log_Msg

529: /*Check for sr type ( on CP or not )*/
530: IF r_sr_type.CUSTOMER_PRODUCT_ID IS NOT NULL THEN
531: /*Only history for CP product*/
532: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
533: jtm_message_log_pkg.Log_Msg
534: ( null
535: , g_table_name
536: , 'Service request is based on a customer product'
537: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

Line 586: jtm_message_log_pkg.Log_Msg

582: END IF;
583: ELSE
584: /*SR history for cust/install site*/
585: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
586: jtm_message_log_pkg.Log_Msg
587: ( null
588: , g_table_name
589: , 'Service request is not based on a customer product, retrieving history for' ||
590: fnd_global.local_chr(10) || 'task time = ' || to_char(r_task_time.TASK_TIME, 'DD-MON-YYYY HH24:MI') ||

Line 606: jtm_message_log_pkg.Log_Msg

602: IF l_history_table.COUNT > 0 THEN
603: l_not_exists := TRUE;
604: /*Check if record exists*/
605: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
606: jtm_message_log_pkg.Log_Msg
607: ( null
608: , g_table_name
609: , 'Checking if incident_id ' || r_get_non_cp_history.incident_id ||' needs to be replicated'
610: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

Line 619: jtm_message_log_pkg.Log_Msg

615: IF l_history_table.EXISTS(i) THEN
616: IF l_history_table(i) = r_get_non_cp_history.incident_id THEN
617: /*Record does exist do not insert but remove reference from list*/
618: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
619: jtm_message_log_pkg.Log_Msg
620: ( null
621: , g_table_name
622: , 'Already replicated, deleting from PL/SQL table'
623: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

Line 634: jtm_message_log_pkg.Log_Msg

630: END LOOP;
631: IF l_not_exists THEN
632: /*Record does not yet exists so insert*/
633: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
634: jtm_message_log_pkg.Log_Msg
635: ( null
636: , g_table_name
637: , 'Record not replicated yet; push it to client(s)'
638: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

Line 667: jtm_message_log_pkg.Log_Msg

663: END IF;
664: END IF;
665: ELSE
666: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
667: jtm_message_log_pkg.Log_Msg
668: ( null
669: , g_table_name
670: , 'Could not find data for incident id '||p_incident_id
671: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

Line 678: jtm_message_log_pkg.Log_Msg

674: END IF;
675: CLOSE c_sr_type;
676:
677: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
678: jtm_message_log_pkg.Log_Msg
679: ( null
680: , g_table_name
681: , 'Leaving CALCULATE_HISTORY for incident '||p_incident_id
682: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

Line 687: jtm_message_log_pkg.Log_Msg

683: , 'csl_service_history_pkg');
684: END IF;
685:
686: EXCEPTION WHEN OTHERS THEN
687: jtm_message_log_pkg.Log_Msg
688: ( null
689: , g_table_name
690: , 'Exception in CSL_SERVICE_HISTORY_PKG.CALCULATE_HISTORY for incident '||p_incident_id||
691: ' and resource '||p_resource_id||':'|| fnd_global.local_chr(10) || sqlerrm

Line 716: jtm_message_log_pkg.Log_Msg

712: AND NVL(inc.CLOSE_DATE, SYSDATE ) >= SYSDATE;
713:
714: BEGIN
715: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
716: jtm_message_log_pkg.Log_Msg
717: ( null
718: , g_table_name
719: , 'Entering CONCURRENT_HISTORY'
720: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

Line 737: jtm_message_log_pkg.Log_Msg

733: AND PROCEDURE_NAME = 'CONCURRENT_HISTORY';
734:
735:
736: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
737: jtm_message_log_pkg.Log_Msg
738: ( null
739: , g_table_name
740: , 'Leaving CONCURRENT_HISTORY'
741: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

Line 747: jtm_message_log_pkg.Log_Msg

743: END IF;
744: COMMIT;
745: EXCEPTION WHEN OTHERS THEN
746: ROLLBACK;
747: jtm_message_log_pkg.Log_Msg
748: ( null
749: , g_table_name
750: , 'Exception in CSL_SERVICE_HISTORY_PKG.CONCURRENT_HISTORY'||':'
751: || fnd_global.local_chr(10) || sqlerrm