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_LOBS_PKG dependencies on JTM_MESSAGE_LOG_PKG

Line 82: jtm_message_log_pkg.Log_Msg

78: l_error_msg := 'Entering ' || g_object_name || '.APPLY_INSERT'
79: || ' for PK ' || to_char( p_record.FILE_ID);
80:
81: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
82: jtm_message_log_pkg.Log_Msg
83: ( v_object_id => p_record.file_id
84: , v_object_name => g_object_name
85: , v_message => l_error_msg
86: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 121: jtm_message_log_pkg.Log_Msg

117: p_error_msg := 'Duplicate Record: File id ' || to_char(p_record.file_id)
118: || ' already exists in fnd_lobs table';
119:
120: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
121: jtm_message_log_pkg.Log_Msg
122: ( v_object_id => p_record.file_id
123: , v_object_name => g_object_name
124: , v_message => p_error_msg
125: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 184: jtm_message_log_pkg.Log_Msg

180: l_error_msg := 'Leaving ' || g_object_name || '.APPLY_INSERT'
181: || ' for PK ' || to_char (p_record.FILE_ID );
182:
183: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
184: jtm_message_log_pkg.Log_Msg
185: ( v_object_id => p_record.file_id
186: , v_object_name => g_object_name
187: , v_message => l_error_msg
188: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 200: jtm_message_log_pkg.Log_Msg

196: || '.APPLY_INSERT:' || ' ' || sqlerrm
197: || ' for PK ' || to_char (p_record.FILE_ID );
198:
199: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
200: jtm_message_log_pkg.Log_Msg
201: ( v_object_id => p_record.file_id
202: , v_object_name => g_object_name
203: , v_message => l_error_msg
204: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 218: jtm_message_log_pkg.Log_Msg

214: l_error_msg := 'Leaving ' || g_object_name || '.APPLY_INSERT'
215: || ' for PK ' || to_char (p_record.FILE_ID );
216:
217: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
218: jtm_message_log_pkg.Log_Msg
219: ( v_object_id => p_record.file_id
220: , v_object_name => g_object_name
221: , v_message => l_error_msg
222: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 248: jtm_message_log_pkg.Log_Msg

244: FND_MSG_PUB.INITIALIZE;
245:
246:
247: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
248: jtm_message_log_pkg.Log_Msg
249: ( v_object_id => p_record.file_id
250: , v_object_name => g_object_name
251: , v_message => 'Entering ' || g_object_name || '.APPLY_RECORD'
252: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 260: jtm_message_log_pkg.Log_Msg

256: || to_char (p_record.FILE_ID) || ' ' || 'DMLTYPE = '
257: || p_record.dmltype$$ ;
258:
259: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
260: jtm_message_log_pkg.Log_Msg
261: ( v_object_id => p_record.file_id
262: , v_object_name => g_object_name
263: , v_message => l_error_msg
264: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 281: jtm_message_log_pkg.Log_Msg

277: -- Process update; not supported for this entity
278:
279: l_error_msg := 'Update is not supported for this entity ' || g_object_name;
280:
281: jtm_message_log_pkg.Log_Msg
282: ( v_object_id => p_record.file_id
283: , v_object_name => g_object_name
284: , v_message => l_error_msg
285: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 301: jtm_message_log_pkg.Log_Msg

297: -- Process delete; not supported for this entity
298:
299: l_error_msg := 'Delete is not supported for this entity ' || g_object_name ;
300:
301: jtm_message_log_pkg.Log_Msg
302: ( v_object_id => p_record.file_id
303: , v_object_name => g_object_name
304: , v_message => l_error_msg
305: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 319: jtm_message_log_pkg.Log_Msg

315: ELSE
316: -- invalid dml type
317:
318: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
319: jtm_message_log_pkg.Log_Msg
320: ( v_object_id => p_record.task_assignment_id
321: , v_object_name => g_object_name
322: , v_message => 'Invalid DML type: ' || p_record.dmltype$$
323: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

Line 337: jtm_message_log_pkg.Log_Msg

333: x_return_status := FND_API.G_RET_STS_ERROR;
334: END IF;
335:
336: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
337: jtm_message_log_pkg.Log_Msg
338: ( v_object_id => p_record.file_id
339: , v_object_name => g_object_name
340: , v_message => 'Leaving ' || g_object_name || '.APPLY_RECORD'
341: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 349: jtm_message_log_pkg.Log_Msg

345: EXCEPTION WHEN OTHERS THEN
346: /*** defer record when any process exception occurs ***/
347:
348: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
349: jtm_message_log_pkg.Log_Msg
350: ( v_object_id => p_record.file_id
351: , v_object_name => g_object_name
352: , v_message => 'Exception occurred in APPLY_RECORD:' || fnd_global.local_chr(10) || sqlerrm
353: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

Line 363: jtm_message_log_pkg.Log_Msg

359: p_api_error => TRUE
360: );
361:
362: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
363: jtm_message_log_pkg.Log_Msg
364: ( v_object_id => p_record.file_id
365: , v_object_name => g_object_name
366: , v_message => 'Leaving ' || g_object_name || '.APPLY_RECORD'
367: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 396: jtm_message_log_pkg.Log_Msg

392: BEGIN
393: g_debug_level := p_debug_level;
394: x_return_status := FND_API.G_RET_STS_SUCCESS;
395:
396: jtm_message_log_pkg.Log_Msg
397: ( v_object_id => null
398: , v_object_name => g_object_name
399: , v_message => 'Entering ' || g_object_name || '.APPLY_INSERT'
400: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

Line 420: jtm_message_log_pkg.Log_Msg

416: /*** was record processed successfully? ***/
417: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN
418: /*** Yes -> delete record from inqueue ***/
419: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
420: jtm_message_log_pkg.Log_Msg
421: ( v_object_id => r_fnd_lobs.task_assignment_id
422: , v_object_name => g_object_name
423: , v_message => 'Record successfully processed, deleting from inqueue'
424: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 444: jtm_message_log_pkg.Log_Msg

440: /*** was delete successful? ***/
441: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
442: /*** no -> rollback ***/
443: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
444: jtm_message_log_pkg.Log_Msg
445: ( v_object_id => r_FND_LOBS.task_assignment_id
446: , v_object_name => g_object_name
447: , v_message => 'Deleting from inqueue failed, rolling back to savepoint'
448: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 460: jtm_message_log_pkg.Log_Msg

456: /*** Record was not processed successfully or delete failed
457: -> defer and reject record ***/
458:
459: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
460: jtm_message_log_pkg.Log_Msg
461: ( v_object_id => r_FND_LOBS.task_assignment_id
462: , v_object_name => g_object_name
463: , v_message => 'Deleting from inqueue failed, rolling back to savepoint'
464: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 484: jtm_message_log_pkg.Log_Msg

480: /*** Was defer successful? ***/
481: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
482: /*** no -> rollback ***/
483: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
484: jtm_message_log_pkg.Log_Msg
485: ( v_object_id => r_FND_LOBS.task_assignment_id
486: , v_object_name => g_object_name
487: , v_message => 'Defer record failed, rolling back to savepoint'
488: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 499: jtm_message_log_pkg.Log_Msg

495: END LOOP;
496:
497:
498: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
499: jtm_message_log_pkg.Log_Msg
500: ( v_object_id => null
501: , v_object_name => g_object_name
502: , v_message => 'Leaving ' || g_object_name || '.Apply_Client_Changes'
503: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 510: jtm_message_log_pkg.Log_Msg

506:
507: EXCEPTION WHEN OTHERS THEN
508: /*** catch and log exceptions ***/
509: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
510: jtm_message_log_pkg.Log_Msg
511: ( v_object_id => null
512: , v_object_name => g_object_name
513: , v_message => 'Exception occurred in APPLY_CLIENT_CHANGES:' || fnd_global.local_chr(10) || sqlerrm
514: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);