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_VALUES_PKG dependencies on JTM_HOOK_UTIL_PKG

Line 66: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

62: l_msg_data VARCHAR2(240);
63:
64: BEGIN
65:
66: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
67: jtm_message_log_pkg.Log_Msg
68: ( v_object_id => p_record.COUNTER_VALUE_ID -- put PK column here
69: , v_object_name => g_object_name
70: , v_message => 'Entering ' || g_object_name || '.APPLY_INSERT'

Line 71: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

67: jtm_message_log_pkg.Log_Msg
68: ( v_object_id => p_record.COUNTER_VALUE_ID -- put PK column here
69: , v_object_name => g_object_name
70: , v_message => 'Entering ' || g_object_name || '.APPLY_INSERT'
71: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
72: END IF;
73:
74: --Bug 4496299
75:

Line 212: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

208: p_api_error => TRUE
209: );
210: END IF;
211:
212: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
213: jtm_message_log_pkg.Log_Msg
214: ( v_object_id => p_record.COUNTER_VALUE_ID -- put PK column here
215: , v_object_name => g_object_name
216: , v_message => 'Leaving ' || g_object_name || '.APPLY_INSERT'

Line 217: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

213: jtm_message_log_pkg.Log_Msg
214: ( v_object_id => p_record.COUNTER_VALUE_ID -- put PK column here
215: , v_object_name => g_object_name
216: , v_message => 'Leaving ' || g_object_name || '.APPLY_INSERT'
217: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
218: END IF;
219:
220: EXCEPTION WHEN OTHERS THEN
221: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

Line 221: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

217: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
218: END IF;
219:
220: EXCEPTION WHEN OTHERS THEN
221: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
222: jtm_message_log_pkg.Log_Msg
223: ( v_object_id => p_record.COUNTER_VALUE_ID -- put PK column here
224: , v_object_name => g_object_name
225: , v_message => 'Exception occurred in APPLY_INSERT:' || fnd_global.local_chr(10) || sqlerrm

Line 226: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

222: jtm_message_log_pkg.Log_Msg
223: ( v_object_id => p_record.COUNTER_VALUE_ID -- put PK column here
224: , v_object_name => g_object_name
225: , v_message => 'Exception occurred in APPLY_INSERT:' || fnd_global.local_chr(10) || sqlerrm
226: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
227: END IF;
228:
229: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_INSERT', sqlerrm);
230: p_error_msg := CSL_SERVICEL_WRAPPER_PKG.GET_ERROR_MESSAGE_TEXT

Line 235: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

231: (
232: p_api_error => TRUE
233: );
234:
235: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
236: jtm_message_log_pkg.Log_Msg
237: ( v_object_id => p_record.COUNTER_VALUE_ID -- put PK column here
238: , v_object_name => g_object_name
239: , v_message => 'Leaving ' || g_object_name || '.APPLY_INSERT'

Line 240: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

236: jtm_message_log_pkg.Log_Msg
237: ( v_object_id => p_record.COUNTER_VALUE_ID -- put PK column here
238: , v_object_name => g_object_name
239: , v_message => 'Leaving ' || g_object_name || '.APPLY_INSERT'
240: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
241: END IF;
242:
243: x_return_status := FND_API.G_RET_STS_ERROR;
244: END APPLY_INSERT;

Line 296: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

292:
293: l_msg_count NUMBER;
294: l_msg_data VARCHAR2(240);
295: BEGIN
296: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
297: jtm_message_log_pkg.Log_Msg
298: ( v_object_id => p_record.COUNTER_VALUE_ID -- put PK column here
299: , v_object_name => g_object_name
300: , v_message => 'Entering ' || g_object_name || '.APPLY_UPDATE'

Line 301: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

297: jtm_message_log_pkg.Log_Msg
298: ( v_object_id => p_record.COUNTER_VALUE_ID -- put PK column here
299: , v_object_name => g_object_name
300: , v_message => 'Entering ' || g_object_name || '.APPLY_UPDATE'
301: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
302: END IF;
303:
304: --Bug 4496299
305: /*

Line 385: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

381: p_api_error => TRUE
382: );
383: END IF;
384:
385: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
386: jtm_message_log_pkg.Log_Msg
387: ( v_object_id => p_record.COUNTER_VALUE_ID -- put PK column here
388: , v_object_name => g_object_name
389: , v_message => 'Leaving ' || g_object_name || '.APPLY_UPDATE'

Line 390: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

386: jtm_message_log_pkg.Log_Msg
387: ( v_object_id => p_record.COUNTER_VALUE_ID -- put PK column here
388: , v_object_name => g_object_name
389: , v_message => 'Leaving ' || g_object_name || '.APPLY_UPDATE'
390: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
391: END IF;
392:
393: EXCEPTION WHEN OTHERS THEN
394: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

Line 394: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

390: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
391: END IF;
392:
393: EXCEPTION WHEN OTHERS THEN
394: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
395: jtm_message_log_pkg.Log_Msg
396: ( v_object_id => p_record.COUNTER_VALUE_ID -- put PK column here
397: , v_object_name => g_object_name
398: , v_message => 'Exception occurred in APPLY_UPDATE:' || fnd_global.local_chr(10) || sqlerrm

Line 399: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

395: jtm_message_log_pkg.Log_Msg
396: ( v_object_id => p_record.COUNTER_VALUE_ID -- put PK column here
397: , v_object_name => g_object_name
398: , v_message => 'Exception occurred in APPLY_UPDATE:' || fnd_global.local_chr(10) || sqlerrm
399: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
400: END IF;
401:
402: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_UPDATE', sqlerrm);
403: p_error_msg := CSL_SERVICEL_WRAPPER_PKG.GET_ERROR_MESSAGE_TEXT

Line 408: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

404: (
405: p_api_error => TRUE
406: );
407:
408: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
409: jtm_message_log_pkg.Log_Msg
410: ( v_object_id => p_record.COUNTER_VALUE_ID -- put PK column here
411: , v_object_name => g_object_name
412: , v_message => 'Leaving ' || g_object_name || '.APPLY_UPDATE'

Line 413: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

409: jtm_message_log_pkg.Log_Msg
410: ( v_object_id => p_record.COUNTER_VALUE_ID -- put PK column here
411: , v_object_name => g_object_name
412: , v_message => 'Leaving ' || g_object_name || '.APPLY_UPDATE'
413: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
414: END IF;
415:
416: x_return_status := FND_API.G_RET_STS_ERROR;
417: END APPLY_UPDATE;

Line 433: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

429: /*** initialize return status and message list ***/
430: x_return_status := FND_API.G_RET_STS_SUCCESS;
431: FND_MSG_PUB.INITIALIZE;
432:
433: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
434: jtm_message_log_pkg.Log_Msg
435: ( v_object_id => p_record.COUNTER_VALUE_ID-- put PK column here
436: , v_object_name => g_object_name
437: , v_message => 'Entering ' || g_object_name || '.APPLY_RECORD'

Line 438: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

434: jtm_message_log_pkg.Log_Msg
435: ( v_object_id => p_record.COUNTER_VALUE_ID-- put PK column here
436: , v_object_name => g_object_name
437: , v_message => 'Entering ' || g_object_name || '.APPLY_RECORD'
438: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
439: END IF;
440:
441: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
442: jtm_message_log_pkg.Log_Msg

Line 441: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

437: , v_message => 'Entering ' || g_object_name || '.APPLY_RECORD'
438: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
439: END IF;
440:
441: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
442: jtm_message_log_pkg.Log_Msg
443: ( v_object_id => p_record.COUNTER_VALUE_ID -- put PK column here
444: , v_object_name => g_object_name
445: , v_message => 'Processing CS_COUNTER_VALUE = ' || p_record.COUNTER_VALUE_ID /* put PK column here */ || fnd_global.local_chr(10) ||

Line 447: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

443: ( v_object_id => p_record.COUNTER_VALUE_ID -- put PK column here
444: , v_object_name => g_object_name
445: , v_message => 'Processing CS_COUNTER_VALUE = ' || p_record.COUNTER_VALUE_ID /* put PK column here */ || fnd_global.local_chr(10) ||
446: 'DMLTYPE = ' || p_record.dmltype$$
447: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
448: END IF;
449:
450: IF p_record.dmltype$$='I' THEN
451: -- Process insert

Line 468: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

464: x_return_status
465: );
466: ELSIF p_record.dmltype$$='D' THEN
467: -- Process delete; not supported for this entity
468: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
469: jtm_message_log_pkg.Log_Msg
470: ( v_object_id => p_record.COUNTER_VALUE_ID -- put PK column here
471: , v_object_name => g_object_name
472: , v_message => 'Delete is not supported for this entity'

Line 473: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

469: jtm_message_log_pkg.Log_Msg
470: ( v_object_id => p_record.COUNTER_VALUE_ID -- put PK column here
471: , v_object_name => g_object_name
472: , v_message => 'Delete is not supported for this entity'
473: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
474: END IF;
475:
476: p_error_msg := CSL_SERVICEL_WRAPPER_PKG.GET_ERROR_MESSAGE_TEXT
477: (

Line 486: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

482:
483: x_return_status := FND_API.G_RET_STS_ERROR;
484: ELSE
485: -- invalid dml type
486: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
487: jtm_message_log_pkg.Log_Msg
488: ( v_object_id => p_record.COUNTER_VALUE_ID -- put PK column here
489: , v_object_name => g_object_name
490: , v_message => 'Invalid DML type: ' || p_record.dmltype$$

Line 491: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

487: jtm_message_log_pkg.Log_Msg
488: ( v_object_id => p_record.COUNTER_VALUE_ID -- put PK column here
489: , v_object_name => g_object_name
490: , v_message => 'Invalid DML type: ' || p_record.dmltype$$
491: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
492: END IF;
493:
494: p_error_msg := CSL_SERVICEL_WRAPPER_PKG.GET_ERROR_MESSAGE_TEXT
495: (

Line 504: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

500:
501: x_return_status := FND_API.G_RET_STS_ERROR;
502: END IF;
503:
504: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
505: jtm_message_log_pkg.Log_Msg
506: ( v_object_id => p_record.COUNTER_VALUE_ID -- put PK column here
507: , v_object_name => g_object_name
508: , v_message => 'Leaving ' || g_object_name || '.APPLY_RECORD'

Line 509: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

505: jtm_message_log_pkg.Log_Msg
506: ( v_object_id => p_record.COUNTER_VALUE_ID -- put PK column here
507: , v_object_name => g_object_name
508: , v_message => 'Leaving ' || g_object_name || '.APPLY_RECORD'
509: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
510: END IF;
511: EXCEPTION WHEN OTHERS THEN
512: /*** defer record when any process exception occurs ***/
513: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

Line 513: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

509: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
510: END IF;
511: EXCEPTION WHEN OTHERS THEN
512: /*** defer record when any process exception occurs ***/
513: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
514: jtm_message_log_pkg.Log_Msg
515: ( v_object_id => p_record.COUNTER_VALUE_ID -- put PK column here
516: , v_object_name => g_object_name
517: , v_message => 'Exception occurred in APPLY_RECORD:' || fnd_global.local_chr(10) || sqlerrm

Line 518: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

514: jtm_message_log_pkg.Log_Msg
515: ( v_object_id => p_record.COUNTER_VALUE_ID -- put PK column here
516: , v_object_name => g_object_name
517: , v_message => 'Exception occurred in APPLY_RECORD:' || fnd_global.local_chr(10) || sqlerrm
518: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
519: END IF;
520:
521: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_RECORD', sqlerrm);
522: p_error_msg := CSL_SERVICEL_WRAPPER_PKG.GET_ERROR_MESSAGE_TEXT

Line 527: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

523: (
524: p_api_error => TRUE
525: );
526:
527: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
528: jtm_message_log_pkg.Log_Msg
529: ( v_object_id => p_record.COUNTER_VALUE_ID -- put PK column here
530: , v_object_name => g_object_name
531: , v_message => 'Leaving ' || g_object_name || '.APPLY_RECORD'

Line 532: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

528: jtm_message_log_pkg.Log_Msg
529: ( v_object_id => p_record.COUNTER_VALUE_ID -- put PK column here
530: , v_object_name => g_object_name
531: , v_message => 'Leaving ' || g_object_name || '.APPLY_RECORD'
532: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
533: END IF;
534:
535: x_return_status := FND_API.G_RET_STS_ERROR;
536: END APPLY_RECORD;

Line 558: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

554: BEGIN
555: g_debug_level := p_debug_level;
556: x_return_status := FND_API.G_RET_STS_SUCCESS;
557:
558: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
559: jtm_message_log_pkg.Log_Msg
560: ( v_object_id => null
561: , v_object_name => g_object_name
562: , v_message => 'Entering ' || g_object_name || '.Apply_Client_Changes'

Line 563: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

559: jtm_message_log_pkg.Log_Msg
560: ( v_object_id => null
561: , v_object_name => g_object_name
562: , v_message => 'Entering ' || g_object_name || '.Apply_Client_Changes'
563: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
564: END IF;
565:
566: /*** loop through CS_COUNTER_VALUES records in inqueue ***/
567: FOR r_CS_COUNTER_VALUES IN c_CS_COUNTER_VALUES( p_user_name, p_tranid) LOOP

Line 582: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

578:
579: /*** was record processed successfully? ***/
580: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN
581: /*** Yes -> delete record from inqueue ***/
582: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
583: jtm_message_log_pkg.Log_Msg
584: ( v_object_id => r_CS_COUNTER_VALUES.COUNTER_VALUE_ID -- put PK column here
585: , v_object_name => g_object_name
586: , v_message => 'Record successfully processed, deleting from inqueue'

Line 587: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

583: jtm_message_log_pkg.Log_Msg
584: ( v_object_id => r_CS_COUNTER_VALUES.COUNTER_VALUE_ID -- put PK column here
585: , v_object_name => g_object_name
586: , v_message => 'Record successfully processed, deleting from inqueue'
587: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
588: END IF;
589:
590: CSL_SERVICEL_WRAPPER_PKG.DELETE_RECORD
591: (

Line 605: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

601:
602: /*** was delete successful? ***/
603: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
604: /*** no -> rollback ***/
605: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
606: jtm_message_log_pkg.Log_Msg
607: ( v_object_id => r_CS_COUNTER_VALUES.COUNTER_VALUE_ID -- put PK column here
608: , v_object_name => g_object_name
609: , v_message => 'Deleting from inqueue failed, rolling back to savepoint'

Line 610: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

606: jtm_message_log_pkg.Log_Msg
607: ( v_object_id => r_CS_COUNTER_VALUES.COUNTER_VALUE_ID -- put PK column here
608: , v_object_name => g_object_name
609: , v_message => 'Deleting from inqueue failed, rolling back to savepoint'
610: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
611: END IF;
612: ROLLBACK TO save_rec;
613: END IF;
614: END IF;

Line 618: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

614: END IF;
615:
616: IF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN
617: /*** Record was not processed successfully or delete failed -> defer and reject record ***/
618: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
619: jtm_message_log_pkg.Log_Msg
620: ( v_object_id => r_CS_COUNTER_VALUES.COUNTER_VALUE_ID -- put PK column here
621: , v_object_name => g_object_name
622: , v_message => 'Record not processed successfully, deferring and rejecting record'

Line 623: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

619: jtm_message_log_pkg.Log_Msg
620: ( v_object_id => r_CS_COUNTER_VALUES.COUNTER_VALUE_ID -- put PK column here
621: , v_object_name => g_object_name
622: , v_message => 'Record not processed successfully, deferring and rejecting record'
623: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
624: END IF;
625:
626: CSL_SERVICEL_WRAPPER_PKG.DEFER_RECORD
627: (

Line 641: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

637:
638: /*** Was defer successful? ***/
639: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
640: /*** no -> rollback ***/
641: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
642: jtm_message_log_pkg.Log_Msg
643: ( v_object_id => r_CS_COUNTER_VALUES.COUNTER_VALUE_ID -- put PK column here
644: , v_object_name => g_object_name
645: , v_message => 'Defer record failed, rolling back to savepoint'

Line 646: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

642: jtm_message_log_pkg.Log_Msg
643: ( v_object_id => r_CS_COUNTER_VALUES.COUNTER_VALUE_ID -- put PK column here
644: , v_object_name => g_object_name
645: , v_message => 'Defer record failed, rolling back to savepoint'
646: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
647: END IF;
648: ROLLBACK TO save_rec;
649: END IF;
650: END IF;

Line 654: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

650: END IF;
651:
652: END LOOP;
653:
654: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
655: jtm_message_log_pkg.Log_Msg
656: ( v_object_id => null
657: , v_object_name => g_object_name
658: , v_message => 'Leaving ' || g_object_name || '.Apply_Client_Changes'

Line 659: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

655: jtm_message_log_pkg.Log_Msg
656: ( v_object_id => null
657: , v_object_name => g_object_name
658: , v_message => 'Leaving ' || g_object_name || '.Apply_Client_Changes'
659: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
660: END IF;
661:
662: EXCEPTION WHEN OTHERS THEN
663: /*** catch and log exceptions ***/

Line 664: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

660: END IF;
661:
662: EXCEPTION WHEN OTHERS THEN
663: /*** catch and log exceptions ***/
664: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
665: jtm_message_log_pkg.Log_Msg
666: ( v_object_id => null
667: , v_object_name => g_object_name
668: , v_message => 'Exception occurred in APPLY_CLIENT_CHANGES:' || fnd_global.local_chr(10) || sqlerrm

Line 669: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

665: jtm_message_log_pkg.Log_Msg
666: ( v_object_id => null
667: , v_object_name => g_object_name
668: , v_message => 'Exception occurred in APPLY_CLIENT_CHANGES:' || fnd_global.local_chr(10) || sqlerrm
669: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
670: END IF;
671: x_return_status := FND_API.G_RET_STS_ERROR;
672: END APPLY_CLIENT_CHANGES;
673: