DBA Data[Home] [Help]

APPS.CSL_CSF_DEBRIEF_HDR_ACC_PKG dependencies on JTM_MESSAGE_LOG_PKG

Line 31: jtm_message_log_pkg.Log_Msg

27: AND dbh.debrief_header_id = b_debrief_header_id;
28: r_resource c_resource%ROWTYPE;
29: BEGIN
30: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
31: jtm_message_log_pkg.Log_Msg
32: ( p_debrief_header_id
33: , g_table_name
34: , 'Entering Get_Resource_Id function'
35: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 43: jtm_message_log_pkg.Log_Msg

39: FETCH c_resource INTO r_resource;
40: CLOSE c_resource;
41:
42: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
43: jtm_message_log_pkg.Log_Msg
44: ( p_debrief_header_id
45: , g_table_name
46: , 'Leaving Get_Resource_Id function'
47: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 72: jtm_message_log_pkg.Log_Msg

68: /*** get debug level ***/
69: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
70:
71: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
72: jtm_message_log_pkg.Log_Msg
73: ( p_debrief_header_id
74: , g_table_name
75: , 'Entering Replicate_Record'
76: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 84: jtm_message_log_pkg.Log_Msg

80: FETCH c_debrief_header INTO r_debrief_header;
81: IF c_debrief_header%NOTFOUND THEN
82: /*** could not find debrief_header record -> exit ***/
83: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
84: jtm_message_log_pkg.Log_Msg
85: ( p_debrief_header_id
86: , g_table_name
87: , 'Replicate_Record error: Could not find debrief_header_id ' ||
88: p_debrief_header_id

Line 98: jtm_message_log_pkg.Log_Msg

94: END IF;
95: CLOSE c_debrief_header;
96:
97: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
98: jtm_message_log_pkg.Log_Msg
99: ( p_debrief_header_id
100: , g_table_name
101: , 'Replicate_Record returned TRUE'
102: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 119: jtm_message_log_pkg.Log_Msg

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

Line 127: jtm_message_log_pkg.Log_Msg

123: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
124: END IF;
125:
126: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
127: jtm_message_log_pkg.Log_Msg
128: ( p_debrief_header_id
129: , g_table_name
130: , 'Inserting ACC record for resource_id = ' || p_resource_id
131: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 144: jtm_message_log_pkg.Log_Msg

140: ,P_RESOURCE_ID => p_resource_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_debrief_header_id
146: , g_table_name
147: , 'Leaving Insert_ACC_Record'
148: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 162: jtm_message_log_pkg.Log_Msg

158: )
159: IS
160: BEGIN
161: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
162: jtm_message_log_pkg.Log_Msg
163: ( p_debrief_header_id
164: , g_table_name
165: , 'Entering Update_ACC_Record'
166: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 170: jtm_message_log_pkg.Log_Msg

166: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
167: END IF;
168:
169: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
170: jtm_message_log_pkg.Log_Msg
171: ( p_debrief_header_id
172: , g_table_name
173: , 'Updating ACC record for resource_id = ' || p_resource_id
174: || fnd_global.local_chr(10) || 'access_id = ' || p_acc_id

Line 187: jtm_message_log_pkg.Log_Msg

183: ,P_ACCESS_ID => p_acc_id
184: );
185:
186: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
187: jtm_message_log_pkg.Log_Msg
188: ( p_debrief_header_id
189: , g_table_name
190: , 'Leaving Update_ACC_Record'
191: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 206: jtm_message_log_pkg.Log_Msg

202: )
203: IS
204: BEGIN
205: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
206: jtm_message_log_pkg.Log_Msg
207: ( p_debrief_header_id
208: , g_table_name
209: , 'Entering Delete_ACC_Record'
210: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 214: jtm_message_log_pkg.Log_Msg

210: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
211: END IF;
212:
213: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
214: jtm_message_log_pkg.Log_Msg
215: ( p_debrief_header_id
216: , g_table_name
217: , 'Deleting ACC record for resource_id = ' || p_resource_id
218: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 231: jtm_message_log_pkg.Log_Msg

227: ,P_RESOURCE_ID => p_resource_id
228: );
229:
230: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
231: jtm_message_log_pkg.Log_Msg
232: ( p_debrief_header_id
233: , g_table_name
234: , 'Leaving Delete_ACC_Record'
235: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 255: jtm_message_log_pkg.Log_Msg

251: /*** get debug level ***/
252: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
253:
254: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
255: jtm_message_log_pkg.Log_Msg
256: ( p_debrief_header_id
257: , g_table_name
258: , 'Entering Insert_Debrief_Header procedure'
259: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 273: jtm_message_log_pkg.Log_Msg

269:
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_debrief_header_id
275: , g_table_name
276: , 'Leaving Insert_Debrief_Header procedure'
277: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 298: jtm_message_log_pkg.Log_Msg

294: /*** get debug level ***/
295: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
296:
297: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
298: jtm_message_log_pkg.Log_Msg
299: ( p_debrief_header_id
300: , g_table_name
301: , 'Entering Update_Debrief_Header procedure'
302: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 330: jtm_message_log_pkg.Log_Msg

326: END IF;
327: END IF;
328:
329: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
330: jtm_message_log_pkg.Log_Msg
331: ( p_debrief_header_id
332: , g_table_name
333: , 'Leaving Update_Debrief_Header procedure'
334: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 355: jtm_message_log_pkg.Log_Msg

351: /*** get debug level ***/
352: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
353:
354: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
355: jtm_message_log_pkg.Log_Msg
356: ( p_debrief_header_id
357: , g_table_name
358: , 'Entering Delete_Debrief_Header'
359: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 380: jtm_message_log_pkg.Log_Msg

376:
377: END IF;
378:
379: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
380: jtm_message_log_pkg.Log_Msg
381: ( p_debrief_header_id
382: , g_table_name
383: , 'Leaving Delete_Debrief_Header'
384: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 450: jtm_message_log_pkg.Log_Msg

446: CSF_DEBRIEF_Headers_PKG.user_hooks_rec.debrief_header_id;
447: l_resource_id := Get_Resource_Id( l_debrief_header_id );
448:
449: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
450: jtm_message_log_pkg.Log_Msg
451: ( l_debrief_header_id
452: , g_table_name
453: , 'Entering POST_UPDATE hook'
454: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);