APPS.CSL_JTF_RESOURCE_EXTNS_ACC_PKG dependencies on JTM_MESSAGE_LOG_PKG

Line 34: jtm_message_log_pkg.Log_Msg

30: /*** get debug level ***/
31: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
32:
33: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
34: jtm_message_log_pkg.Log_Msg
35: ( p_resource_extn_id
36: , g_table_name
37: , 'Entering Replicate_Record'
38: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 46: jtm_message_log_pkg.Log_Msg

42: FETCH c_user INTO r_user;
43: IF c_user%NOTFOUND THEN
44: /*** could not find user record -> exit ***/
45: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
46: jtm_message_log_pkg.Log_Msg
47: ( p_resource_extn_id
48: , g_table_name
49: , 'Replicate_Record error: Could not find resource_extn_id ' || p_resource_extn_id
50: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 58: jtm_message_log_pkg.Log_Msg

54: END IF;
55: CLOSE c_user;
56:
57: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
58: jtm_message_log_pkg.Log_Msg
59: ( p_resource_extn_id
60: , g_table_name
61: , 'Replicate_Record returned TRUE'
62: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 78: jtm_message_log_pkg.Log_Msg

74: )
75: IS
76: BEGIN
77: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
78: jtm_message_log_pkg.Log_Msg
79: ( p_resource_extn_id
80: , g_table_name
81: , 'Entering Insert_ACC_Record'
82: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 86: jtm_message_log_pkg.Log_Msg

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

Line 103: jtm_message_log_pkg.Log_Msg

99: ,P_RESOURCE_ID => p_resource_id
100: );
101:
102: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
103: jtm_message_log_pkg.Log_Msg
104: ( p_resource_extn_id
105: , g_table_name
106: , 'Leaving Insert_ACC_Record'
107: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 120: jtm_message_log_pkg.Log_Msg

116: )
117: IS
118: BEGIN
119: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
120: jtm_message_log_pkg.Log_Msg
121: ( p_resource_extn_id
122: , g_table_name
123: , 'Entering Update_ACC_Record'
124: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 128: jtm_message_log_pkg.Log_Msg

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

Line 144: jtm_message_log_pkg.Log_Msg

140: ,P_ACCESS_ID => p_acc_id
141: );
142:
143: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
144: jtm_message_log_pkg.Log_Msg
145: ( p_resource_extn_id
146: , g_table_name
147: , 'Leaving Update_ACC_Record'
148: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 160: jtm_message_log_pkg.Log_Msg

156: )
157: IS
158: BEGIN
159: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
160: jtm_message_log_pkg.Log_Msg
161: ( p_resource_extn_id
162: , g_table_name
163: , 'Entering Delete_ACC_Record'
164: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 168: jtm_message_log_pkg.Log_Msg

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

Line 189: jtm_message_log_pkg.Log_Msg

185: );
186: */
187:
188: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
189: jtm_message_log_pkg.Log_Msg
190: ( p_resource_extn_id
191: , g_table_name
192: , 'Leaving Delete_ACC_Record'
193: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 210: jtm_message_log_pkg.Log_Msg

206: /*** get debug level ***/
207: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
208:
209: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
210: jtm_message_log_pkg.Log_Msg
211: ( p_resource_extn_id
212: , g_table_name
213: , 'Entering Insert_Resource_Extns procedure'
214: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 228: jtm_message_log_pkg.Log_Msg

224:
225: END IF;
226:
227: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
228: jtm_message_log_pkg.Log_Msg
229: ( p_resource_extn_id
230: , g_table_name
231: , 'Leaving Insert_Resource_Extns procedure'
232: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 251: jtm_message_log_pkg.Log_Msg

247: /*** get debug level ***/
248: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
249:
250: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
251: jtm_message_log_pkg.Log_Msg
252: ( p_resource_extn_id
253: , g_table_name
254: , 'Entering Update_Resource_Extns procedure'
255: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 279: jtm_message_log_pkg.Log_Msg

275: END IF;
276: END IF;
277:
278: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
279: jtm_message_log_pkg.Log_Msg
280: ( p_resource_extn_id
281: , g_table_name
282: , 'Leaving Update_Resource_Extns procedure'
283: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 303: jtm_message_log_pkg.Log_Msg

299: /*** get debug level ***/
300: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
301:
302: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
303: jtm_message_log_pkg.Log_Msg
304: ( p_resource_extn_id
305: , g_table_name
306: , 'Entering Delete_Resource_Extns'
307: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 326: jtm_message_log_pkg.Log_Msg

322:
323: END IF;
324:
325: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
326: jtm_message_log_pkg.Log_Msg
327: ( p_resource_extn_id
328: , g_table_name
329: , 'Leaving Delete_Resource_Extns'
330: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);