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.JTM_CON_QUERY_REQUEST_PKG dependencies on FND_GLOBAL

Line 637: fnd_global.local_chr(10) || 'Ignoring this query.'

633: ( v_object_id => r_query_request.acc_table_name
634: , v_object_name => G_PACKAGE_NAME
635: , v_message => 'No application subscribed to query ' ||
636: r_query_request.con_query_id || '.' ||
637: fnd_global.local_chr(10) || 'Ignoring this query.'
638: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
639: , v_module => 'jtm_message_log_pkg');
640: END IF;
641:

Line 679: , v_message => 'Executing:' || fnd_global.local_chr(10) || l_dynamic_stmt || fnd_global.local_chr(10) ||

675: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_SQL THEN
676: JTM_message_log_pkg.Log_Msg
677: ( v_object_id => r_query_request.acc_table_name
678: , v_object_name => G_PACKAGE_NAME
679: , v_message => 'Executing:' || fnd_global.local_chr(10) || l_dynamic_stmt || fnd_global.local_chr(10) ||
680: 'LAST_RUN_DATE = ' || to_char(r_query_request.last_run_date)
681: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_SQL
682: , v_module => 'jtm_message_log_pkg');
683: END IF;

Line 775: , v_message => 'Executing:' || fnd_global.local_chr(10) || l_dynamic_stmt

771: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_SQL THEN
772: JTM_message_log_pkg.Log_Msg
773: ( v_object_id => r_query_request.acc_table_name
774: , v_object_name => G_PACKAGE_NAME
775: , v_message => 'Executing:' || fnd_global.local_chr(10) || l_dynamic_stmt
776: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_SQL
777: , v_module => 'jtm_message_log_pkg');
778:
779: END IF;

Line 789: , v_message => 'Executing:' || fnd_global.local_chr(10) || l_dynamic_stmt

785: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_SQL THEN
786: JTM_message_log_pkg.Log_Msg
787: ( v_object_id => r_query_request.acc_table_name
788: , v_object_name => G_PACKAGE_NAME
789: , v_message => 'Executing:' || fnd_global.local_chr(10) || l_dynamic_stmt
790: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_SQL
791: , v_module => 'jtm_message_log_pkg');
792: END IF;
793: l_cursor := dbms_sql.open_cursor;

Line 834: , v_message => 'Executing:' || fnd_global.local_chr(10) || l_dynamic_stmt

830: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_SQL THEN
831: JTM_message_log_pkg.Log_Msg
832: ( v_object_id => r_query_request.acc_table_name
833: , v_object_name => G_PACKAGE_NAME
834: , v_message => 'Executing:' || fnd_global.local_chr(10) || l_dynamic_stmt
835: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_SQL
836: , v_module => 'jtm_message_log_pkg');
837: END IF;
838: EXECUTE IMMEDIATE l_dynamic_stmt;

Line 921: , v_message => 'Executing:' || fnd_global.local_chr(10) || l_dynamic_stmt

917: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_SQL THEN
918: JTM_message_log_pkg.Log_Msg
919: ( v_object_id => r_query_request.acc_table_name
920: , v_object_name => G_PACKAGE_NAME
921: , v_message => 'Executing:' || fnd_global.local_chr(10) || l_dynamic_stmt
922: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_SQL
923: , v_module => 'jtm_message_log_pkg');
924: END IF;
925:

Line 1051: fnd_global.local_chr(10) || 'Ignoring this query.'

1047: JTM_message_log_pkg.Log_Msg
1048: ( v_object_id => r_query_request.acc_table_name
1049: , v_object_name => G_PACKAGE_NAME
1050: , v_message => 'No application subscribed to query ' || r_query_request.con_query_id || '.' ||
1051: fnd_global.local_chr(10) || 'Ignoring this query.'
1052: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
1053: , v_module => 'jtm_message_log_pkg');
1054: END IF;
1055:

Line 1094: , v_message => 'Executing:' || fnd_global.local_chr(10) || l_dynamic_stmt || fnd_global.local_chr(10) ||

1090: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_SQL THEN
1091: JTM_message_log_pkg.Log_Msg
1092: ( v_object_id => r_query_request.acc_table_name
1093: , v_object_name => G_PACKAGE_NAME
1094: , v_message => 'Executing:' || fnd_global.local_chr(10) || l_dynamic_stmt || fnd_global.local_chr(10) ||
1095: 'LAST_RUN_DATE = ' || to_char(r_query_request.last_run_date)
1096: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_SQL
1097: , v_module => 'jtm_message_log_pkg');
1098: END IF;

Line 1163: , v_message => 'Executing:' || fnd_global.local_chr(10) || l_dynamic_stmt

1159: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_SQL THEN
1160: JTM_message_log_pkg.Log_Msg
1161: ( v_object_id => r_query_request.acc_table_name
1162: , v_object_name => G_PACKAGE_NAME
1163: , v_message => 'Executing:' || fnd_global.local_chr(10) || l_dynamic_stmt
1164: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_SQL
1165: , v_module => 'jtm_message_log_pkg');
1166:
1167: END IF;

Line 1177: , v_message => 'Executing:' || fnd_global.local_chr(10) || l_dynamic_stmt

1173: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_SQL THEN
1174: JTM_message_log_pkg.Log_Msg
1175: ( v_object_id => r_query_request.acc_table_name
1176: , v_object_name => G_PACKAGE_NAME
1177: , v_message => 'Executing:' || fnd_global.local_chr(10) || l_dynamic_stmt
1178: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_SQL
1179: , v_module => 'jtm_message_log_pkg');
1180: END IF;
1181: l_cursor := dbms_sql.open_cursor;

Line 1224: , v_message => 'Executing:' || fnd_global.local_chr(10) || l_dynamic_stmt

1220: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_SQL THEN
1221: JTM_message_log_pkg.Log_Msg
1222: ( v_object_id => r_query_request.acc_table_name
1223: , v_object_name => G_PACKAGE_NAME
1224: , v_message => 'Executing:' || fnd_global.local_chr(10) || l_dynamic_stmt
1225: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_SQL
1226: , v_module => 'jtm_message_log_pkg');
1227: END IF;
1228: EXECUTE IMMEDIATE l_dynamic_stmt;

Line 1295: , v_message => 'Executing:' || fnd_global.local_chr(10) || l_dynamic_stmt

1291: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_SQL THEN
1292: JTM_message_log_pkg.Log_Msg
1293: ( v_object_id => r_query_request.acc_table_name
1294: , v_object_name => G_PACKAGE_NAME
1295: , v_message => 'Executing:' || fnd_global.local_chr(10) || l_dynamic_stmt
1296: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_SQL
1297: , v_module => 'jtm_message_log_pkg');
1298: END IF;
1299:

Line 1447: , v_message => 'Unexpected error encountered in Process_Request: ' || fnd_global.local_chr(10) || sqlerrm

1443: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
1444: JTM_message_log_pkg.Log_Msg
1445: ( v_object_id => r_query_request.acc_table_name
1446: , v_object_name => G_PACKAGE_NAME
1447: , v_message => 'Unexpected error encountered in Process_Request: ' || fnd_global.local_chr(10) || sqlerrm
1448: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR
1449: , v_module => 'jtm_message_log_pkg');
1450: END IF;
1451: END;

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

1501: JTM_message_log_pkg.Log_Msg
1502: (v_object_id => null
1503: ,v_object_name => G_PACKAGE_NAME
1504: ,v_message => 'Unexpected error encountered in RUN_QUERY_REQUESTS:'
1505: || fnd_global.local_chr(10) || sqlerrm
1506: ,v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR
1507: ,v_module => 'jtm_message_log_pkg');
1508: END IF;
1509: