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

Line 203: jtm_message_log_pkg.Log_Msg

199: END IF;
200: END IF;
201:
202: IF Get_Debug_Level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_SQL THEN
203: jtm_message_log_pkg.Log_Msg
204: ( l_merged_pk
205: , p_acc_table_name
206: , 'JTM_HOOK_UTIL_PKG.Get_Acc_Id executing:' || fnd_global.local_chr(10) ||
207: l_stmt || fnd_global.local_chr(10) ||

Line 210: , 'jtm_message_log_pkg');

206: , 'JTM_HOOK_UTIL_PKG.Get_Acc_Id executing:' || fnd_global.local_chr(10) ||
207: l_stmt || fnd_global.local_chr(10) ||
208: ':1 = ' || p_resource_id || fnd_global.local_chr(10) || l_error_msg
209: , JTM_HOOK_UTIL_PKG.g_debug_level_full
210: , 'jtm_message_log_pkg');
211: END IF;
212:
213: IF p_pk2_name IS NULL THEN
214: EXECUTE IMMEDIATE l_stmt INTO l_access_id USING p_resource_id, l_pk1_value;

Line 329: jtm_message_log_pkg.Log_Msg

325: END IF;
326: END IF;
327:
328: IF Get_Debug_Level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_SQL THEN
329: jtm_message_log_pkg.Log_Msg
330: ( l_merged_pk
331: , p_acc_table_name
332: , 'JTM_HOOK_UTIL_PKG.Get_Resource_Acc_List executing:' || fnd_global.local_chr(10) ||
333: l_stmt || fnd_global.local_chr(10) || l_error_msg

Line 335: , 'jtm_message_log_pkg');

331: , p_acc_table_name
332: , 'JTM_HOOK_UTIL_PKG.Get_Resource_Acc_List executing:' || fnd_global.local_chr(10) ||
333: l_stmt || fnd_global.local_chr(10) || l_error_msg
334: , JTM_HOOK_UTIL_PKG.g_debug_level_full
335: , 'jtm_message_log_pkg');
336: END IF;
337:
338: l_cursor := dbms_sql.open_cursor;
339: dbms_sql.parse( l_cursor, l_stmt, dbms_sql.v7);

Line 421: jtm_message_log_pkg.Log_Msg

417: ', LAST_UPDATED_BY = 1 '||
418: ' WHERE ACCESS_ID = :1 ';
419:
420: IF Get_Debug_Level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_SQL THEN
421: jtm_message_log_pkg.Log_Msg
422: ( l_access_id
423: , p_acc_table_name
424: , 'JTM_HOOK_UTIL_PKG.Insert_Acc executing:' || fnd_global.local_chr(10) || l_stmt
425: , JTM_HOOK_UTIL_PKG.g_debug_level_full

Line 426: , 'jtm_message_log_pkg');

422: ( l_access_id
423: , p_acc_table_name
424: , 'JTM_HOOK_UTIL_PKG.Insert_Acc executing:' || fnd_global.local_chr(10) || l_stmt
425: , JTM_HOOK_UTIL_PKG.g_debug_level_full
426: , 'jtm_message_log_pkg');
427: END IF;
428: EXECUTE IMMEDIATE l_stmt using l_access_id;
429:
430: ELSE

Line 506: jtm_message_log_pkg.Log_Msg

502: END IF;
503: END IF;
504:
505: IF Get_Debug_Level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_SQL THEN
506: jtm_message_log_pkg.Log_Msg
507: ( l_merged_pk
508: , p_acc_table_name
509: , 'JTM_HOOK_UTIL_PKG.Insert_Acc executing:' || fnd_global.local_chr(10) ||
510: l_stmt || fnd_global.local_chr(10) || ':1 = ' || p_resource_id

Line 513: , 'jtm_message_log_pkg');

509: , 'JTM_HOOK_UTIL_PKG.Insert_Acc executing:' || fnd_global.local_chr(10) ||
510: l_stmt || fnd_global.local_chr(10) || ':1 = ' || p_resource_id
511: || fnd_global.local_chr(10) || l_error_msg
512: , JTM_HOOK_UTIL_PKG.g_debug_level_full
513: , 'jtm_message_log_pkg');
514: END IF;
515:
516: /*We have at least one PK so get the value*/
517: IF l_pk2_value IS NULL THEN

Line 665: jtm_message_log_pkg.Log_Msg

661: dbms_sql.define_array( l_cursor, 2, l_tab_access_id, 10, l_index);
662:
663:
664: IF Get_Debug_Level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_SQL THEN
665: jtm_message_log_pkg.Log_Msg
666: ( l_pk1_value||','||l_pk2_value||','||l_pk3_value
667: , p_acc_table_name
668: , 'JTM_HOOK_UTIL_PKG.Delete_Acc executing:' || fnd_global.local_chr(10) ||
669: l_stmt || fnd_global.local_chr(10) ||

Line 675: , 'jtm_message_log_pkg');

671: ':P2 = ' || l_pk2_value || fnd_global.local_chr(10) ||
672: ':P3 = ' || l_pk3_value || fnd_global.local_chr(10) ||
673: ':P4 = ' || p_resource_id
674: , JTM_HOOK_UTIL_PKG.g_debug_level_full
675: , 'jtm_message_log_pkg');
676: END IF;
677:
678: l_count := dbms_sql.execute( l_cursor );
679: LOOP

Line 716: jtm_message_log_pkg.Log_Msg

712: l_stmt := l_stmt ||' AND RESOURCE_ID '||l_operator||' :P4';
713: END IF;
714:
715: IF Get_Debug_Level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_SQL THEN
716: jtm_message_log_pkg.Log_Msg
717: ( l_pk1_value||','||l_pk2_value||','||l_pk3_value
718: , p_acc_table_name
719: , 'JTM_HOOK_UTIL_PKG.Delete_Acc executing :' || fnd_global.local_chr(10) ||
720: l_stmt || fnd_global.local_chr(10) ||

Line 726: , 'jtm_message_log_pkg');

722: ':P2 = ' || l_pk2_value || fnd_global.local_chr(10) ||
723: ':P3 = ' || l_pk3_value || fnd_global.local_chr(10) ||
724: ':P4 = ' || p_resource_id
725: , JTM_HOOK_UTIL_PKG.g_debug_level_full
726: , 'jtm_message_log_pkg');
727: END IF;
728:
729: IF p_pk2_name IS NULL AND p_pk3_name IS NULL AND p_resource_id IS NULL THEN
730: EXECUTE IMMEDIATE l_stmt USING l_pk1_value;

Line 760: jtm_message_log_pkg.Log_Msg

756: l_stmt := l_stmt ||' AND RESOURCE_ID '|| l_operator ||' :P4';
757: END IF;
758:
759: IF Get_Debug_Level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_SQL THEN
760: jtm_message_log_pkg.Log_Msg
761: ( l_pk1_value
762: , p_acc_table_name
763: , 'JTM_HOOK_UTIL_PKG.Delete_Acc executing:' || fnd_global.local_chr(10) || l_stmt
764: , JTM_HOOK_UTIL_PKG.g_debug_level_full

Line 765: , 'jtm_message_log_pkg');

761: ( l_pk1_value
762: , p_acc_table_name
763: , 'JTM_HOOK_UTIL_PKG.Delete_Acc executing:' || fnd_global.local_chr(10) || l_stmt
764: , JTM_HOOK_UTIL_PKG.g_debug_level_full
765: , 'jtm_message_log_pkg');
766: END IF;
767:
768: IF p_pk2_name IS NULL AND p_pk3_name IS NULL AND p_resource_id IS NULL THEN
769: EXECUTE IMMEDIATE l_stmt USING l_pk1_value;

Line 799: jtm_message_log_pkg.Log_Msg

795: BEGIN
796: l_stmt := 'DELETE ' || p_acc_table_name ||' WHERE RESOURCE_ID = :P1';
797:
798: IF Get_Debug_Level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_SQL THEN
799: jtm_message_log_pkg.Log_Msg
800: ( p_resource_id
801: , p_acc_table_name
802: , 'JTM_HOOK_UTIL_PKG.Delete_Acc_4Res executing:' || fnd_global.local_chr(10) ||
803: l_stmt || fnd_global.local_chr(10)||'P1 = '||p_resource_id

Line 805: , 'jtm_message_log_pkg');

801: , p_acc_table_name
802: , 'JTM_HOOK_UTIL_PKG.Delete_Acc_4Res executing:' || fnd_global.local_chr(10) ||
803: l_stmt || fnd_global.local_chr(10)||'P1 = '||p_resource_id
804: , JTM_HOOK_UTIL_PKG.g_debug_level_full
805: , 'jtm_message_log_pkg');
806: END IF;
807:
808: EXECUTE IMMEDIATE l_stmt USING p_resource_id;
809: