DBA Data[Home] [Help]

APPS.CSL_FND_USER_ACC_PKG dependencies on JTM_MESSAGE_LOG_PKG

Line 30: jtm_message_log_pkg.Log_Msg

26: /*** get debug level ***/
27: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
28:
29: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
30: jtm_message_log_pkg.Log_Msg
31: ( p_user_id
32: , g_table_name
33: , 'Entering Replicate_Record'
34: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 42: jtm_message_log_pkg.Log_Msg

38: FETCH c_user INTO r_user;
39: IF c_user%NOTFOUND THEN
40: /*** could not find user record -> exit ***/
41: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
42: jtm_message_log_pkg.Log_Msg
43: ( p_user_id
44: , g_table_name
45: , 'Replicate_Record error: Could not find user_id ' || p_user_id
46: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 55: jtm_message_log_pkg.Log_Msg

51: END IF;
52: CLOSE c_user;
53:
54: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
55: jtm_message_log_pkg.Log_Msg
56: ( p_user_id
57: , g_table_name
58: , 'Replicate_Record returned TRUE'
59: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 75: jtm_message_log_pkg.Log_Msg

71: )
72: IS
73: BEGIN
74: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
75: jtm_message_log_pkg.Log_Msg
76: ( p_user_id
77: , g_table_name
78: , 'Entering Insert_ACC_Record'
79: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 83: jtm_message_log_pkg.Log_Msg

79: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
80: END IF;
81:
82: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
83: jtm_message_log_pkg.Log_Msg
84: ( p_user_id
85: , g_table_name
86: , 'Inserting ACC record for resource_id = ' || p_resource_id
87: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 100: jtm_message_log_pkg.Log_Msg

96: ,P_RESOURCE_ID => p_resource_id
97: );
98:
99: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
100: jtm_message_log_pkg.Log_Msg
101: ( p_user_id
102: , g_table_name
103: , 'Leaving Insert_ACC_Record'
104: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 117: jtm_message_log_pkg.Log_Msg

113: )
114: IS
115: BEGIN
116: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
117: jtm_message_log_pkg.Log_Msg
118: ( p_user_id
119: , g_table_name
120: , 'Entering Update_ACC_Record'
121: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 125: jtm_message_log_pkg.Log_Msg

121: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
122: END IF;
123:
124: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
125: jtm_message_log_pkg.Log_Msg
126: ( p_user_id
127: , g_table_name
128: , 'Updating ACC record for resource_id = ' || p_resource_id || fnd_global.local_chr(10) || 'access_id = ' || p_acc_id
129: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 141: jtm_message_log_pkg.Log_Msg

137: ,P_ACCESS_ID => p_acc_id
138: );
139:
140: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
141: jtm_message_log_pkg.Log_Msg
142: ( p_user_id
143: , g_table_name
144: , 'Leaving Update_ACC_Record'
145: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 157: jtm_message_log_pkg.Log_Msg

153: )
154: IS
155: BEGIN
156: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
157: jtm_message_log_pkg.Log_Msg
158: ( p_user_id
159: , g_table_name
160: , 'Entering Delete_ACC_Record'
161: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 165: jtm_message_log_pkg.Log_Msg

161: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
162: END IF;
163:
164: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
165: jtm_message_log_pkg.Log_Msg
166: ( p_user_id
167: , g_table_name
168: , 'Deleting ACC record for resource_id = ' || p_resource_id
169: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 182: jtm_message_log_pkg.Log_Msg

178: ,P_RESOURCE_ID => p_resource_id
179: );
180:
181: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
182: jtm_message_log_pkg.Log_Msg
183: ( p_user_id
184: , g_table_name
185: , 'Leaving Delete_ACC_Record'
186: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 203: jtm_message_log_pkg.Log_Msg

199: /*** get debug level ***/
200: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
201:
202: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
203: jtm_message_log_pkg.Log_Msg
204: ( p_user_id
205: , g_table_name
206: , 'Entering Insert_User procedure'
207: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 221: jtm_message_log_pkg.Log_Msg

217:
218: END IF;
219:
220: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
221: jtm_message_log_pkg.Log_Msg
222: ( p_user_id
223: , g_table_name
224: , 'Leaving Insert_User procedure'
225: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 245: jtm_message_log_pkg.Log_Msg

241: /*** get debug level ***/
242: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
243:
244: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
245: jtm_message_log_pkg.Log_Msg
246: ( p_user_id
247: , g_table_name
248: , 'Entering Update_User'
249: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 273: jtm_message_log_pkg.Log_Msg

269: END IF;
270: END IF;
271:
272: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
273: jtm_message_log_pkg.Log_Msg
274: ( p_user_id
275: , g_table_name
276: , 'Leaving Update_User'
277: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 296: jtm_message_log_pkg.Log_Msg

292: /*** get debug level ***/
293: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
294:
295: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
296: jtm_message_log_pkg.Log_Msg
297: ( p_user_id
298: , g_table_name
299: , 'Entering Delete_User'
300: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 320: jtm_message_log_pkg.Log_Msg

316:
317: END IF;
318:
319: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
320: jtm_message_log_pkg.Log_Msg
321: ( p_user_id
322: , g_table_name
323: , 'Leaving Delete_User'
324: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);