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

Line 76: jtm_message_log_pkg.Log_Msg

72: l_msg_count NUMBER;
73: l_msg_data VARCHAR2(240);
74: BEGIN
75: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
76: jtm_message_log_pkg.Log_Msg
77: ( v_object_id => p_record.COUNTER_PROP_VALUE_ID -- put PK column here
78: , v_object_name => g_object_name
79: , v_message => 'Entering ' || g_object_name || '.APPLY_INSERT'
80: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 180: jtm_message_log_pkg.Log_Msg

176: );
177: END IF;
178:
179: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
180: jtm_message_log_pkg.Log_Msg
181: ( v_object_id => p_record.COUNTER_PROP_VALUE_ID -- put PK column here
182: , v_object_name => g_object_name
183: , v_message => 'Leaving ' || g_object_name || '.APPLY_INSERT'
184: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 189: jtm_message_log_pkg.Log_Msg

185: END IF;
186:
187: EXCEPTION WHEN OTHERS THEN
188: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
189: jtm_message_log_pkg.Log_Msg
190: ( v_object_id => p_record.COUNTER_PROP_VALUE_ID -- put PK column here
191: , v_object_name => g_object_name
192: , v_message => 'Exception occurred in APPLY_INSERT:' || fnd_global.local_chr(10) || sqlerrm
193: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

Line 203: jtm_message_log_pkg.Log_Msg

199: p_api_error => TRUE
200: );
201:
202: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
203: jtm_message_log_pkg.Log_Msg
204: ( v_object_id => p_record.COUNTER_PROP_VALUE_ID -- put PK column here
205: , v_object_name => g_object_name
206: , v_message => 'Leaving ' || g_object_name || '.APPLY_INSERT'
207: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 247: jtm_message_log_pkg.Log_Msg

243: l_msg_count NUMBER;
244: l_msg_data VARCHAR2(240);
245: BEGIN
246: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
247: jtm_message_log_pkg.Log_Msg
248: ( v_object_id => p_record.COUNTER_PROP_VALUE_ID -- put PK column here
249: , v_object_name => g_object_name
250: , v_message => 'Entering ' || g_object_name || '.APPLY_UPDATE'
251: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 302: jtm_message_log_pkg.Log_Msg

298: );
299: END IF;
300:
301: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
302: jtm_message_log_pkg.Log_Msg
303: ( v_object_id => p_record.COUNTER_PROP_VALUE_ID -- put PK column here
304: , v_object_name => g_object_name
305: , v_message => 'Leaving ' || g_object_name || '.APPLY_UPDATE'
306: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 311: jtm_message_log_pkg.Log_Msg

307: END IF;
308:
309: EXCEPTION WHEN OTHERS THEN
310: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
311: jtm_message_log_pkg.Log_Msg
312: ( v_object_id => p_record.COUNTER_PROP_VALUE_ID -- put PK column here
313: , v_object_name => g_object_name
314: , v_message => 'Exception occurred in APPLY_UPDATE:' || fnd_global.local_chr(10) || sqlerrm
315: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

Line 325: jtm_message_log_pkg.Log_Msg

321: p_api_error => TRUE
322: );
323:
324: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
325: jtm_message_log_pkg.Log_Msg
326: ( v_object_id => p_record.COUNTER_PROP_VALUE_ID -- put PK column here
327: , v_object_name => g_object_name
328: , v_message => 'Leaving ' || g_object_name || '.APPLY_UPDATE'
329: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 350: jtm_message_log_pkg.Log_Msg

346: x_return_status := FND_API.G_RET_STS_SUCCESS;
347: FND_MSG_PUB.INITIALIZE;
348:
349: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
350: jtm_message_log_pkg.Log_Msg
351: ( v_object_id => p_record.COUNTER_PROP_VALUE_ID -- put PK column here
352: , v_object_name => g_object_name
353: , v_message => 'Entering ' || g_object_name || '.APPLY_RECORD'
354: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 358: jtm_message_log_pkg.Log_Msg

354: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
355: END IF;
356:
357: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
358: jtm_message_log_pkg.Log_Msg
359: ( v_object_id => p_record.COUNTER_PROP_VALUE_ID -- put PK column here
360: , v_object_name => g_object_name
361: , v_message => 'Processing CS_COUNTER_PROP_VALS = ' || p_record.COUNTER_PROP_VALUE_ID /* put PK column here */ || fnd_global.local_chr(10) ||
362: 'DMLTYPE = ' || p_record.dmltype$$

Line 385: jtm_message_log_pkg.Log_Msg

381: );
382: ELSIF p_record.dmltype$$='D' THEN
383: -- Process delete; not supported for this entity
384: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
385: jtm_message_log_pkg.Log_Msg
386: ( v_object_id => p_record.COUNTER_PROP_VALUE_ID -- put PK column here
387: , v_object_name => g_object_name
388: , v_message => 'Delete is not supported for this entity'
389: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

Line 403: jtm_message_log_pkg.Log_Msg

399: x_return_status := FND_API.G_RET_STS_ERROR;
400: ELSE
401: -- invalid dml type
402: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
403: jtm_message_log_pkg.Log_Msg
404: ( v_object_id => p_record.COUNTER_PROP_VALUE_ID -- put PK column here
405: , v_object_name => g_object_name
406: , v_message => 'Invalid DML type: ' || p_record.dmltype$$
407: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

Line 421: jtm_message_log_pkg.Log_Msg

417: x_return_status := FND_API.G_RET_STS_ERROR;
418: END IF;
419:
420: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
421: jtm_message_log_pkg.Log_Msg
422: ( v_object_id => p_record.COUNTER_PROP_VALUE_ID -- put PK column here
423: , v_object_name => g_object_name
424: , v_message => 'Leaving ' || g_object_name || '.APPLY_RECORD'
425: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 430: jtm_message_log_pkg.Log_Msg

426: END IF;
427: EXCEPTION WHEN OTHERS THEN
428: /*** defer record when any process exception occurs ***/
429: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
430: jtm_message_log_pkg.Log_Msg
431: ( v_object_id => p_record.COUNTER_PROP_VALUE_ID -- put PK column here
432: , v_object_name => g_object_name
433: , v_message => 'Exception occurred in APPLY_RECORD:' || fnd_global.local_chr(10) || sqlerrm
434: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

Line 444: jtm_message_log_pkg.Log_Msg

440: p_api_error => TRUE
441: );
442:
443: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
444: jtm_message_log_pkg.Log_Msg
445: ( v_object_id => p_record.COUNTER_PROP_VALUE_ID -- put PK column here
446: , v_object_name => g_object_name
447: , v_message => 'Leaving ' || g_object_name || '.APPLY_RECORD'
448: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 475: jtm_message_log_pkg.Log_Msg

471: g_debug_level := p_debug_level;
472: x_return_status := FND_API.G_RET_STS_SUCCESS;
473:
474: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
475: jtm_message_log_pkg.Log_Msg
476: ( v_object_id => null
477: , v_object_name => g_object_name
478: , v_message => 'Entering ' || g_object_name || '.Apply_Client_Changes'
479: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 499: jtm_message_log_pkg.Log_Msg

495: /*** was record processed successfully? ***/
496: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN
497: /*** Yes -> delete record from inqueue ***/
498: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
499: jtm_message_log_pkg.Log_Msg
500: ( v_object_id => r_CS_COUNTER_PROP_VALS.COUNTER_PROP_VALUE_ID -- put PK column here
501: , v_object_name => g_object_name
502: , v_message => 'Record successfully processed, deleting from inqueue'
503: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 522: jtm_message_log_pkg.Log_Msg

518: /*** was delete successful? ***/
519: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
520: /*** no -> rollback ***/
521: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
522: jtm_message_log_pkg.Log_Msg
523: ( v_object_id => r_CS_COUNTER_PROP_VALS.COUNTER_PROP_VALUE_ID -- put PK column here
524: , v_object_name => g_object_name
525: , v_message => 'Deleting from inqueue failed, rolling back to savepoint'
526: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 535: jtm_message_log_pkg.Log_Msg

531:
532: IF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN
533: /*** Record was not processed successfully or delete failed -> defer and reject record ***/
534: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
535: jtm_message_log_pkg.Log_Msg
536: ( v_object_id => r_CS_COUNTER_PROP_VALS.COUNTER_PROP_VALUE_ID -- put PK column here
537: , v_object_name => g_object_name
538: , v_message => 'Record not processed successfully, deferring and rejecting record'
539: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 558: jtm_message_log_pkg.Log_Msg

554: /*** Was defer successful? ***/
555: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
556: /*** no -> rollback ***/
557: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
558: jtm_message_log_pkg.Log_Msg
559: ( v_object_id => r_CS_COUNTER_PROP_VALS.COUNTER_PROP_VALUE_ID -- put PK column here
560: , v_object_name => g_object_name
561: , v_message => 'Defer record failed, rolling back to savepoint'
562: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 571: jtm_message_log_pkg.Log_Msg

567:
568: END LOOP;
569:
570: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
571: jtm_message_log_pkg.Log_Msg
572: ( v_object_id => null
573: , v_object_name => g_object_name
574: , v_message => 'Leaving ' || g_object_name || '.Apply_Client_Changes'
575: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 581: jtm_message_log_pkg.Log_Msg

577:
578: EXCEPTION WHEN OTHERS THEN
579: /*** catch and log exceptions ***/
580: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
581: jtm_message_log_pkg.Log_Msg
582: ( v_object_id => null
583: , v_object_name => g_object_name
584: , v_message => 'Exception occurred in APPLY_CLIENT_CHANGES:' || fnd_global.local_chr(10) || sqlerrm
585: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);