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_HOOK_UTIL_PKG

Line 1: PACKAGE BODY JTM_HOOK_UTIL_PKG AS

1: PACKAGE BODY JTM_HOOK_UTIL_PKG AS
2: /* $Header: jtmhutlb.pls 120.3 2006/01/13 03:21:17 trajasek noship $ */
3:
4: /*** Globals ***/
5: g_resource_id NUMBER; -- variable used for caching current resource_id

Line 202: IF Get_Debug_Level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_SQL THEN

198: end if;
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) ||

Line 206: , 'JTM_HOOK_UTIL_PKG.Get_Acc_Id executing:' || fnd_global.local_chr(10) ||

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) ||
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');

Line 209: , JTM_HOOK_UTIL_PKG.g_debug_level_full

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) ||
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

Line 328: IF Get_Debug_Level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_SQL THEN

324: end if;
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) ||

Line 332: , 'JTM_HOOK_UTIL_PKG.Get_Resource_Acc_List executing:' || fnd_global.local_chr(10) ||

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
334: , JTM_HOOK_UTIL_PKG.g_debug_level_full
335: , 'jtm_message_log_pkg');
336: END IF;

Line 334: , JTM_HOOK_UTIL_PKG.g_debug_level_full

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
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;

Line 420: IF Get_Debug_Level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_SQL THEN

416: ', LAST_UPDATE_DATE = SYSDATE '||
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

Line 424: , 'JTM_HOOK_UTIL_PKG.Insert_Acc executing:' || fnd_global.local_chr(10) || l_stmt

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
426: , 'jtm_message_log_pkg');
427: END IF;
428: EXECUTE IMMEDIATE l_stmt using l_access_id;

Line 425: , JTM_HOOK_UTIL_PKG.g_debug_level_full

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
426: , 'jtm_message_log_pkg');
427: END IF;
428: EXECUTE IMMEDIATE l_stmt using l_access_id;
429:

Line 505: IF Get_Debug_Level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_SQL THEN

501: end if;
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) ||

Line 509: , 'JTM_HOOK_UTIL_PKG.Insert_Acc executing:' || fnd_global.local_chr(10) ||

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
511: || fnd_global.local_chr(10) || l_error_msg
512: , JTM_HOOK_UTIL_PKG.g_debug_level_full
513: , 'jtm_message_log_pkg');

Line 512: , JTM_HOOK_UTIL_PKG.g_debug_level_full

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
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*/

Line 664: IF Get_Debug_Level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_SQL THEN

660: dbms_sql.define_array( l_cursor, 1, l_tab_mobile_user_id, 10, l_index);
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) ||

Line 668: , 'JTM_HOOK_UTIL_PKG.Delete_Acc executing:' || fnd_global.local_chr(10) ||

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) ||
670: ':P1 = ' || l_pk1_value || fnd_global.local_chr(10) ||
671: ':P2 = ' || l_pk2_value || fnd_global.local_chr(10) ||
672: ':P3 = ' || l_pk3_value || fnd_global.local_chr(10) ||

Line 674: , JTM_HOOK_UTIL_PKG.g_debug_level_full

670: ':P1 = ' || l_pk1_value || fnd_global.local_chr(10) ||
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 );

Line 715: IF Get_Debug_Level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_SQL THEN

711: IF p_resource_id IS NOT NULL THEN
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) ||

Line 719: , 'JTM_HOOK_UTIL_PKG.Delete_Acc executing :' || fnd_global.local_chr(10) ||

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) ||
721: ':P1 = ' || l_pk1_value || fnd_global.local_chr(10) ||
722: ':P2 = ' || l_pk2_value || fnd_global.local_chr(10) ||
723: ':P3 = ' || l_pk3_value || fnd_global.local_chr(10) ||

Line 725: , JTM_HOOK_UTIL_PKG.g_debug_level_full

721: ':P1 = ' || l_pk1_value || fnd_global.local_chr(10) ||
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

Line 759: IF Get_Debug_Level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_SQL THEN

755: IF p_resource_id IS NOT NULL THEN
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

Line 763: , 'JTM_HOOK_UTIL_PKG.Delete_Acc executing:' || fnd_global.local_chr(10) || l_stmt

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
765: , 'jtm_message_log_pkg');
766: END IF;
767:

Line 764: , JTM_HOOK_UTIL_PKG.g_debug_level_full

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
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

Line 798: IF Get_Debug_Level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_SQL THEN

794: l_stmt VARCHAR2(1000);
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) ||

Line 802: , 'JTM_HOOK_UTIL_PKG.Delete_Acc_4Res executing:' || fnd_global.local_chr(10) ||

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
804: , JTM_HOOK_UTIL_PKG.g_debug_level_full
805: , 'jtm_message_log_pkg');
806: END IF;

Line 804: , JTM_HOOK_UTIL_PKG.g_debug_level_full

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
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;

Line 869: END JTM_HOOK_UTIL_PKG;

865: RETURN r_profile_option_value.profile_option_value;
866:
867: END Get_Profile_Value;
868:
869: END JTM_HOOK_UTIL_PKG;