eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSL_NOTES_PKG dependencies on JTM_MESSAGE_LOG_PKG

Line 31: jtm_message_log_pkg.Log_Msg

27: l_msg_count NUMBER;
28: l_msg_data VARCHAR2(240);
29: BEGIN
30: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
31: jtm_message_log_pkg.Log_Msg
32: ( v_object_id => p_record.jtf_note_id
33: , v_object_name => g_object_name
34: , v_message => 'Entering ' || g_object_name || '.APPLY_INSERT'
35: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 73: jtm_message_log_pkg.Log_Msg

69: );
70: END IF;
71:
72: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
73: jtm_message_log_pkg.Log_Msg
74: ( v_object_id => p_record.jtf_note_id
75: , v_object_name => g_object_name
76: , v_message => 'Leaving ' || g_object_name || '.APPLY_INSERT'
77: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 82: jtm_message_log_pkg.Log_Msg

78: END IF;
79:
80: EXCEPTION WHEN OTHERS THEN
81: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
82: jtm_message_log_pkg.Log_Msg
83: ( v_object_id => p_record.jtf_note_id
84: , v_object_name => g_object_name
85: , v_message => 'Exception occurred in APPLY_INSERT:' || fnd_global.local_chr(10) || sqlerrm
86: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

Line 96: jtm_message_log_pkg.Log_Msg

92: p_api_error => TRUE
93: );
94:
95: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
96: jtm_message_log_pkg.Log_Msg
97: ( v_object_id => p_record.jtf_note_id
98: , v_object_name => g_object_name
99: , v_message => 'Leaving ' || g_object_name || '.APPLY_INSERT'
100: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 119: jtm_message_log_pkg.Log_Msg

115: l_msg_count NUMBER;
116: l_msg_data VARCHAR2(240);
117: BEGIN
118: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
119: jtm_message_log_pkg.Log_Msg
120: ( v_object_id => p_record.jtf_note_id
121: , v_object_name => g_object_name
122: , v_message => 'Entering ' || g_object_name || '.APPLY_UPDATE'
123: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 154: jtm_message_log_pkg.Log_Msg

150: );
151: END IF;
152:
153: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
154: jtm_message_log_pkg.Log_Msg
155: ( v_object_id => p_record.jtf_note_id
156: , v_object_name => g_object_name
157: , v_message => 'Leaving ' || g_object_name || '.APPLY_UPDATE'
158: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 163: jtm_message_log_pkg.Log_Msg

159: END IF;
160:
161: EXCEPTION WHEN OTHERS THEN
162: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
163: jtm_message_log_pkg.Log_Msg
164: ( v_object_id => p_record.jtf_note_id
165: , v_object_name => g_object_name
166: , v_message => 'Exception occurred in APPLY_UPDATE:' || fnd_global.local_chr(10) || sqlerrm
167: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

Line 177: jtm_message_log_pkg.Log_Msg

173: p_api_error => TRUE
174: );
175:
176: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
177: jtm_message_log_pkg.Log_Msg
178: ( v_object_id => p_record.jtf_note_id
179: , v_object_name => g_object_name
180: , v_message => 'Leaving ' || g_object_name || '.APPLY_UPDATE'
181: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 202: jtm_message_log_pkg.Log_Msg

198: x_return_status := FND_API.G_RET_STS_SUCCESS;
199: FND_MSG_PUB.INITIALIZE;
200:
201: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
202: jtm_message_log_pkg.Log_Msg
203: ( v_object_id => p_record.jtf_note_id
204: , v_object_name => g_object_name
205: , v_message => 'Entering ' || g_object_name || '.APPLY_RECORD'
206: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 210: jtm_message_log_pkg.Log_Msg

206: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
207: END IF;
208:
209: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
210: jtm_message_log_pkg.Log_Msg
211: ( v_object_id => p_record.jtf_note_id
212: , v_object_name => g_object_name
213: , v_message => 'Processing JTF_NOTE_ID = ' || p_record.jtf_note_id || fnd_global.local_chr(10) ||
214: 'DMLTYPE = ' || p_record.dmltype$$

Line 237: jtm_message_log_pkg.Log_Msg

233: );
234: ELSIF p_record.dmltype$$='D' THEN
235: -- Process delete; not supported for this entity
236: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
237: jtm_message_log_pkg.Log_Msg
238: ( v_object_id => p_record.jtf_note_id
239: , v_object_name => g_object_name
240: , v_message => 'Delete is not supported for this entity'
241: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

Line 255: jtm_message_log_pkg.Log_Msg

251: x_return_status := FND_API.G_RET_STS_ERROR;
252: ELSE
253: -- invalid dml type
254: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
255: jtm_message_log_pkg.Log_Msg
256: ( v_object_id => p_record.jtf_note_id
257: , v_object_name => g_object_name
258: , v_message => 'Invalid DML type: ' || p_record.dmltype$$
259: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

Line 273: jtm_message_log_pkg.Log_Msg

269: x_return_status := FND_API.G_RET_STS_ERROR;
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: ( v_object_id => p_record.jtf_note_id
275: , v_object_name => g_object_name
276: , v_message => 'Leaving ' || g_object_name || '.APPLY_RECORD'
277: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 282: jtm_message_log_pkg.Log_Msg

278: END IF;
279: EXCEPTION WHEN OTHERS THEN
280: /*** defer record when any process exception occurs ***/
281: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
282: jtm_message_log_pkg.Log_Msg
283: ( v_object_id => p_record.jtf_note_id
284: , v_object_name => g_object_name
285: , v_message => 'Exception occurred in APPLY_RECORD:' || fnd_global.local_chr(10) || sqlerrm
286: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

Line 296: jtm_message_log_pkg.Log_Msg

292: p_api_error => TRUE
293: );
294:
295: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
296: jtm_message_log_pkg.Log_Msg
297: ( v_object_id => p_record.jtf_note_id
298: , v_object_name => g_object_name
299: , v_message => 'Leaving ' || g_object_name || '.APPLY_RECORD'
300: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 327: jtm_message_log_pkg.Log_Msg

323: g_debug_level := p_debug_level;
324: x_return_status := FND_API.G_RET_STS_SUCCESS;
325:
326: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
327: jtm_message_log_pkg.Log_Msg
328: ( v_object_id => null
329: , v_object_name => g_object_name
330: , v_message => 'Entering ' || g_object_name || '.Apply_Client_Changes'
331: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 351: jtm_message_log_pkg.Log_Msg

347: /*** was record processed successfully? ***/
348: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN
349: /*** Yes -> delete record from inqueue ***/
350: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
351: jtm_message_log_pkg.Log_Msg
352: ( v_object_id => r_note.jtf_note_id
353: , v_object_name => g_object_name
354: , v_message => 'Record successfully processed, deleting from inqueue'
355: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 374: jtm_message_log_pkg.Log_Msg

370: /*** was delete successful? ***/
371: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
372: /*** no -> rollback ***/
373: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
374: jtm_message_log_pkg.Log_Msg
375: ( v_object_id => r_note.jtf_note_id
376: , v_object_name => g_object_name
377: , v_message => 'Deleting from inqueue failed, rolling back to savepoint'
378: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 387: jtm_message_log_pkg.Log_Msg

383:
384: IF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN
385: /*** Record was not processed successfully or delete failed -> defer and reject record ***/
386: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
387: jtm_message_log_pkg.Log_Msg
388: ( v_object_id => r_note.jtf_note_id
389: , v_object_name => g_object_name
390: , v_message => 'Record not processed successfully, deferring and rejecting record'
391: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 410: jtm_message_log_pkg.Log_Msg

406: /*** Was defer successful? ***/
407: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
408: /*** no -> rollback ***/
409: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
410: jtm_message_log_pkg.Log_Msg
411: ( v_object_id => r_note.jtf_note_id
412: , v_object_name => g_object_name
413: , v_message => 'Defer record failed, rolling back to savepoint'
414: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 423: jtm_message_log_pkg.Log_Msg

419:
420: END LOOP;
421:
422: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
423: jtm_message_log_pkg.Log_Msg
424: ( v_object_id => null
425: , v_object_name => g_object_name
426: , v_message => 'Leaving ' || g_object_name || '.Apply_Client_Changes'
427: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 433: jtm_message_log_pkg.Log_Msg

429:
430: EXCEPTION WHEN OTHERS THEN
431: /*** catch and log exceptions ***/
432: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
433: jtm_message_log_pkg.Log_Msg
434: ( v_object_id => null
435: , v_object_name => g_object_name
436: , v_message => 'Exception occurred in APPLY_CLIENT_CHANGES:' || fnd_global.local_chr(10) || sqlerrm
437: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);