DBA Data[Home] [Help]

APPS.CSL_HZ_LOCATIONS_ACC_PKG dependencies on JTM_MESSAGE_LOG_PKG

Line 19: jtm_message_log_pkg.Log_Msg

15: BEGIN
16: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
17:
18: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
19: jtm_message_log_pkg.Log_Msg
20: ( p_location_id
21: , g_table_name
22: , 'Entering Insert_Location'
23: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 27: jtm_message_log_pkg.Log_Msg

23: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
24: END IF;
25:
26: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
27: jtm_message_log_pkg.Log_Msg
28: ( p_location_id
29: , g_table_name
30: , 'Inserting ACC record for resource_id = '||p_resource_id
31: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 43: jtm_message_log_pkg.Log_Msg

39: , P_RESOURCE_ID => p_resource_id
40: );
41:
42: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
43: jtm_message_log_pkg.Log_Msg
44: ( p_location_id
45: , g_table_name
46: , 'Leaving Insert_Location'
47: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 59: jtm_message_log_pkg.Log_Msg

55: l_tab_access_id dbms_sql.Number_Table;
56: BEGIN
57: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
58: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
59: jtm_message_log_pkg.Log_Msg
60: ( p_location_id
61: , g_table_name
62: , 'Entering Update_Location'
63: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 79: jtm_message_log_pkg.Log_Msg

75: IF l_tab_resource_id.COUNT > 0 THEN
76: FOR i IN l_tab_resource_id.FIRST .. l_tab_resource_id.LAST LOOP
77:
78: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
79: jtm_message_log_pkg.Log_Msg
80: ( p_location_id
81: , g_table_name
82: , 'Updating ACC record for resource_id = ' || l_tab_resource_id(i) || fnd_global.local_chr(10) ||
83: 'access_id = ' || l_tab_access_id(i)

Line 97: jtm_message_log_pkg.Log_Msg

93: END LOOP;
94: END IF;
95:
96: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
97: jtm_message_log_pkg.Log_Msg
98: ( p_location_id
99: , g_table_name
100: , 'Leaving Udate_Location'
101: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 112: jtm_message_log_pkg.Log_Msg

108: IS
109: BEGIN
110: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
111: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
112: jtm_message_log_pkg.Log_Msg
113: ( p_location_id
114: , g_table_name
115: , 'Entering Delete_Location'
116: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 128: jtm_message_log_pkg.Log_Msg

124: ,P_RESOURCE_ID => p_resource_id
125: );
126:
127: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
128: jtm_message_log_pkg.Log_Msg
129: ( p_location_id
130: , g_table_name
131: , 'Leaving Delete_Location'
132: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 144: jtm_message_log_pkg.Log_Msg

140: IS
141: BEGIN
142: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
143: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
144: jtm_message_log_pkg.Log_Msg
145: ( p_old_location_id
146: , g_table_name
147: , 'Entering Change_Location'
148: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 152: jtm_message_log_pkg.Log_Msg

148: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
149: END IF;
150:
151: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
152: jtm_message_log_pkg.Log_Msg
153: ( p_old_location_id
154: , g_table_name
155: , 'Change location from '||p_old_location_id||' to '||p_new_location_id
156: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 178: jtm_message_log_pkg.Log_Msg

174: , P_RESOURCE_ID => p_resource_id
175: );
176:
177: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
178: jtm_message_log_pkg.Log_Msg
179: ( p_old_location_id
180: , g_table_name
181: , 'Leaving Change_Location'
182: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 204: jtm_message_log_pkg.Log_Msg

200: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
201:
202:
203: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
204: jtm_message_log_pkg.Log_Msg
205: ( l_location_id
206: , g_table_name
207: , 'Entering UPDATE_LOCATION_WFSUB'
208: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 220: jtm_message_log_pkg.Log_Msg

216:
217: fnd_global.apps_initialize (l_user_id, l_resp_id, l_resp_appl_id, l_security_group_id);
218:
219: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
220: jtm_message_log_pkg.Log_Msg
221: ( l_location_id
222: , g_table_name
223: , 'Get parameter for hz parameter P_LOCATION_REC.LOCATION_ID'
224: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 233: jtm_message_log_pkg.Log_Msg

229: p_parameter_name => 'P_LOCATION_REC.LOCATION_ID');
230: */
231:
232: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
233: jtm_message_log_pkg.Log_Msg
234: ( l_location_id
235: , g_table_name
236: , 'Retrieved parameter for hz parameter P_LOCATION_REC.LOCATION_ID ' || l_location_id
237: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 246: jtm_message_log_pkg.Log_Msg

242: UPDATE_LOCATION(l_location_id);
243: -- END IF;
244:
245: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
246: jtm_message_log_pkg.Log_Msg
247: ( l_location_id
248: , g_table_name
249: , 'Leaving UPDATE_LOCATION_WFSUB'
250: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);