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 FND_GLOBAL

Line 50: ' and resource '||p_resource_id || ':' || fnd_global.local_chr(10) || sqlerrm

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
52: , 'csl_service_history_pkg');
53: RAISE;
54: END INSERT_MAPPING_RECORD;

Line 92: ' and resource '||p_resource_id||':'|| fnd_global.local_chr(10) || sqlerrm

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
94: , 'csl_service_history_pkg');
95: RAISE;
96: END DELETE_MAPPING_RECORD;

Line 154: || fnd_global.local_chr(10) || sqlerrm

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
156: , 'csl_service_history_pkg');
157: RETURN 0;
158: END GET_HISTORY_COUNT;

Line 235: ' and resource '||p_resource_id||':'|| fnd_global.local_chr(10) || sqlerrm

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
236: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR
237: , 'csl_service_history_pkg');
238: RAISE;
239: END DELETE_HISTORY_SR_RECORD;

Line 333: ' and resource '||p_resource_id||':'|| fnd_global.local_chr(10) || sqlerrm

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
334: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR
335: , 'csl_service_history_pkg');
336: RAISE;
337: END CREATE_HISTORY_SR_RECORD;

Line 388: ' and resource '||p_resource_id||':'|| fnd_global.local_chr(10) || sqlerrm

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
389: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR
390: , 'csl_service_history_pkg');
391: END DELETE_HISTORY;
392:

Line 590: fnd_global.local_chr(10) || 'task time = ' || to_char(r_task_time.TASK_TIME, 'DD-MON-YYYY HH24:MI') ||

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') ||
591: fnd_global.local_chr(10) || 'customer_id = ' || r_sr_type.CUSTOMER_ID ||
592: fnd_global.local_chr(10) || 'incident_location_id = ' || r_sr_type.incident_location_id
593: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
594: , 'csl_service_history_pkg');

Line 591: fnd_global.local_chr(10) || 'customer_id = ' || r_sr_type.CUSTOMER_ID ||

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') ||
591: fnd_global.local_chr(10) || 'customer_id = ' || r_sr_type.CUSTOMER_ID ||
592: fnd_global.local_chr(10) || 'incident_location_id = ' || r_sr_type.incident_location_id
593: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
594: , 'csl_service_history_pkg');
595: END IF;

Line 592: fnd_global.local_chr(10) || 'incident_location_id = ' || r_sr_type.incident_location_id

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') ||
591: fnd_global.local_chr(10) || 'customer_id = ' || r_sr_type.CUSTOMER_ID ||
592: fnd_global.local_chr(10) || 'incident_location_id = ' || r_sr_type.incident_location_id
593: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
594: , 'csl_service_history_pkg');
595: END IF;
596:

Line 691: ' and resource '||p_resource_id||':'|| fnd_global.local_chr(10) || sqlerrm

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
692: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR
693: , 'csl_service_history_pkg');
694: END CALCULATE_HISTORY;
695:

Line 751: || fnd_global.local_chr(10) || sqlerrm

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
752: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR
753: , 'csl_service_history_pkg');
754: END CONCURRENT_HISTORY;
755: