APPS.CSM_HZ_LOCATIONS_EVENT_PKG dependencies on JTM_HOOK_UTIL_PKG

Line 22: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;

18: l_sqlerrno VARCHAR2(20);
19: l_sqlerrmsg varchar2(2000);
20:
21: BEGIN
22: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
23:
24: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
25: jtm_message_log_pkg.Log_Msg
26: ( p_location_id

Line 24: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

20:
21: BEGIN
22: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
23:
24: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
25: jtm_message_log_pkg.Log_Msg
26: ( p_location_id
27: , g_table_name
28: , 'Entering Insert_Location'

Line 29: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

25: jtm_message_log_pkg.Log_Msg
26: ( p_location_id
27: , g_table_name
28: , 'Entering Insert_Location'
29: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
30: END IF;
31:
32: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
33: jtm_message_log_pkg.Log_Msg

Line 32: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

28: , 'Entering Insert_Location'
29: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
30: END IF;
31:
32: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
33: jtm_message_log_pkg.Log_Msg
34: ( p_location_id
35: , g_table_name
36: , 'Inserting ACC record for user_id = '||p_user_id || 'for location id' ||p_location_id

Line 37: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

33: jtm_message_log_pkg.Log_Msg
34: ( p_location_id
35: , g_table_name
36: , 'Inserting ACC record for user_id = '||p_user_id || 'for location id' ||p_location_id
37: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
38: END IF;
39:
40: CSM_ACC_PKG.Insert_Acc
41: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name,

Line 48: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

44: P_USER_ID => p_user_id,
45: P_PK1_NAME => g_pk1_name,
46: P_PK1_NUM_VALUE => p_location_id);
47:
48: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
49: jtm_message_log_pkg.Log_Msg
50: ( p_location_id
51: , g_table_name
52: , 'Leaving Insert_Location'

Line 53: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

49: jtm_message_log_pkg.Log_Msg
50: ( p_location_id
51: , g_table_name
52: , 'Leaving Insert_Location'
53: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
54: END IF;
55:
56: EXCEPTION
57: WHEN others THEN

Line 74: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;

70: l_sqlerrno VARCHAR2(20);
71: l_sqlerrmsg varchar2(2000);
72:
73: BEGIN
74: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
75: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
76: jtm_message_log_pkg.Log_Msg
77: ( p_location_id
78: , g_table_name

Line 75: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

71: l_sqlerrmsg varchar2(2000);
72:
73: BEGIN
74: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
75: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
76: jtm_message_log_pkg.Log_Msg
77: ( p_location_id
78: , g_table_name
79: , 'Deleting ACC record for user_id = '||p_user_id || 'for location id' ||p_location_id

Line 80: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

76: jtm_message_log_pkg.Log_Msg
77: ( p_location_id
78: , g_table_name
79: , 'Deleting ACC record for user_id = '||p_user_id || 'for location id' ||p_location_id
80: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
81: END IF;
82:
83: CSM_ACC_PKG.Delete_Acc
84: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name

Line 92: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

88: ,P_USER_ID => p_user_id
89: );
90:
91:
92: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
93: jtm_message_log_pkg.Log_Msg
94: ( p_location_id
95: , g_table_name
96: , 'Leaving Delete_Location'

Line 97: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

93: jtm_message_log_pkg.Log_Msg
94: ( p_location_id
95: , g_table_name
96: , 'Leaving Delete_Location'
97: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
98: END IF;
99:
100: EXCEPTION
101: WHEN others THEN