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

Line 23: jtm_message_log_pkg.Log_Msg

19: l_index BINARY_INTEGER;
20: BEGIN
21:
22: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
23: jtm_message_log_pkg.Log_Msg
24: ( v_object_id => null
25: , v_object_name => g_object_name
26: , v_message => 'Entering CSL_SERVICEL_WRAPPER_PKG.ITEM_EXISTS'
27: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 41: jtm_message_log_pkg.Log_Msg

37: /*** found item -> delete from array and return TRUE ***/
38: p_pubitems_tbl.DELETE( l_index );
39:
40: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
41: jtm_message_log_pkg.Log_Msg
42: ( v_object_id => null
43: , v_object_name => g_object_name
44: , v_message => 'Leaving CSL_SERVICEL_WRAPPER_PKG.ITEM_EXISTS'
45: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 54: jtm_message_log_pkg.Log_Msg

50: END LOOP;
51: /*** item name not found ***/
52:
53: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
54: jtm_message_log_pkg.Log_Msg
55: ( v_object_id => null
56: , v_object_name => g_object_name
57: , v_message => 'Leaving CSL_SERVICEL_WRAPPER_PKG.ITEM_EXISTS'
58: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 65: jtm_message_log_pkg.Log_Msg

61: RETURN FALSE;
62: EXCEPTION WHEN OTHERS THEN
63: /*** catch and log exceptions ***/
64: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
65: jtm_message_log_pkg.Log_Msg
66: ( v_object_id => null
67: , v_object_name => g_object_name
68: , v_message => 'Exception occurred in CSL_SERVICEL_WRAPPER_PKG.ITEM_EXISTS:' || fnd_global.local_chr(10) || sqlerrm
69: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

Line 73: jtm_message_log_pkg.Log_Msg

69: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
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 => null
75: , v_object_name => g_object_name
76: , v_message => 'Leaving CSL_SERVICEL_WRAPPER_PKG.ITEM_EXISTS'
77: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 100: jtm_message_log_pkg.Log_Msg

96: BEGIN
97: x_return_status := FND_API.G_RET_STS_SUCCESS;
98:
99: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
100: jtm_message_log_pkg.Log_Msg
101: ( v_object_id => null
102: , v_object_name => g_object_name
103: , v_message => 'Entering CSL_SERVICEL_WRAPPER_PKG.APPLY_DIRTY_PUBITEMS'
104: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 110: jtm_message_log_pkg.Log_Msg

106:
107: /*** call incident wrapper ***/
108: IF ITEM_EXISTS( p_pubitems_tbl, 'CSL_CS_INCIDENTS_ALL_VL') THEN
109: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
110: jtm_message_log_pkg.Log_Msg
111: ( v_object_id => 'CSL_CS_INCIDENTS_ALL_VL'
112: , v_object_name => g_object_name
113: , v_message => 'Calling wrapper for publication item CSL_CS_INCIDENTS_ALL_VL'
114: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 129: jtm_message_log_pkg.Log_Msg

125:
126: /*** call task wrapper ***/
127: IF ITEM_EXISTS( p_pubitems_tbl, 'CSL_JTF_TASKS_VL') THEN
128: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
129: jtm_message_log_pkg.Log_Msg
130: ( v_object_id => 'CSL_JTF_TASKS_VL'
131: , v_object_name => g_object_name
132: , v_message => 'Calling wrapper for publication item CSL_JTF_TASKS_VL'
133: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 148: jtm_message_log_pkg.Log_Msg

144:
145: /*** call task assignment wrapper ***/
146: IF ITEM_EXISTS( p_pubitems_tbl, 'CSL_JTF_TASK_ASSIGNMENTS') THEN
147: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
148: jtm_message_log_pkg.Log_Msg
149: ( v_object_id => 'CSL_JTF_TASK_ASSIGNMENTS'
150: , v_object_name => g_object_name
151: , v_message => 'Calling wrapper for publication item CSL_JTF_TASK_ASSIGNMENTS'
152: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 169: jtm_message_log_pkg.Log_Msg

165: IF ITEM_EXISTS( p_pubitems_tbl, 'CSF_DEBRIEF_LINES')
166: OR ITEM_EXISTS( p_pubitems_tbl, 'CSF_DEBRIEF_HEADERS')
167: THEN
168: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
169: jtm_message_log_pkg.Log_Msg
170: ( v_object_id => 'CSF_DEBRIEF_LINES'
171: , v_object_name => g_object_name
172: , v_message => 'Calling wrapper for publication item CSF_DEBRIEF_LINES'
173: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 188: jtm_message_log_pkg.Log_Msg

184:
185: /*** call notes wrapper ***/
186: IF ITEM_EXISTS( p_pubitems_tbl, 'JTF_NOTES_VL') THEN
187: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
188: jtm_message_log_pkg.Log_Msg
189: ( v_object_id => 'JTF_NOTES_VL'
190: , v_object_name => g_object_name
191: , v_message => 'Calling wrapper for publication item JTF_NOTES_VL'
192: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 207: jtm_message_log_pkg.Log_Msg

203:
204: /*** call notifications wrapper ***/
205: IF ITEM_EXISTS( p_pubitems_tbl, 'WF_NOTIFICATIONS') THEN
206: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
207: jtm_message_log_pkg.Log_Msg
208: ( v_object_id => 'WF_NOTIFICATIONS'
209: , v_object_name => g_object_name
210: , v_message => 'Calling wrapper for publication item WF_NOTIFICATIONS'
211: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 227: jtm_message_log_pkg.Log_Msg

223:
224: /*** call lobs wrapper ***/
225: IF ITEM_EXISTS( p_pubitems_tbl, 'CSL_LOBS') THEN
226: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
227: jtm_message_log_pkg.Log_Msg
228: ( v_object_id => 'CSL_LOBS'
229: , v_object_name => g_object_name
230: , v_message => 'Calling wrapper for publication item CSL_LOBS'
231: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 247: jtm_message_log_pkg.Log_Msg

243:
244: /*** call notification attributes wrapper ***/
245: IF ITEM_EXISTS( p_pubitems_tbl, 'WF_NOTIFICATION_ATTR') THEN
246: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
247: jtm_message_log_pkg.Log_Msg
248: ( v_object_id => 'WF_NOTIFICATION_ATTR'
249: , v_object_name => g_object_name
250: , v_message => 'Calling wrapper for publication item WF_NOTIFICATION_ATTR'
251: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 266: jtm_message_log_pkg.Log_Msg

262:
263: /*** call requirements wrapper ***/
264: IF ITEM_EXISTS( p_pubitems_tbl, 'CSP_REQUIREMENT_LINES') THEN
265: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
266: jtm_message_log_pkg.Log_Msg
267: ( v_object_id => 'CSP_REQUIREMENT_LINES'
268: , v_object_name => g_object_name
269: , v_message => 'Calling wrapper for publication item CSP_REQUIREMENT_LINES'
270: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 285: jtm_message_log_pkg.Log_Msg

281:
282: /*** call counter wrapper ***/
283: IF ITEM_EXISTS( p_pubitems_tbl, 'CS_COUNTER_VALUES') THEN
284: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
285: jtm_message_log_pkg.Log_Msg
286: ( v_object_id => 'CS_COUNTER_VALUES'
287: , v_object_name => g_object_name
288: , v_message => 'Calling wrapper for publication item CS_COUNTER_VALUES'
289: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 304: jtm_message_log_pkg.Log_Msg

300:
301: /*** call counter properties wrapper ***/
302: IF ITEM_EXISTS( p_pubitems_tbl, 'CS_COUNTER_PROP_VALS') THEN
303: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
304: jtm_message_log_pkg.Log_Msg
305: ( v_object_id => 'CS_COUNTER_PROP_VALS'
306: , v_object_name => g_object_name
307: , v_message => 'Calling wrapper for publication item CS_COUNTER_PROP_VALS'
308: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 323: jtm_message_log_pkg.Log_Msg

319:
320: /*** call material transaction wrapper ***/
321: IF ITEM_EXISTS( p_pubitems_tbl, 'MTL_MAT_TRANSACTIONS') THEN
322: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
323: jtm_message_log_pkg.Log_Msg
324: ( v_object_id => 'MTL_MAT_TRANSACTIONS'
325: , v_object_name => g_object_name
326: , v_message => 'Calling wrapper for publication item MTL_MAT_TRANSACTIONS'
327: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 345: jtm_message_log_pkg.Log_Msg

341: /*** no -> print publication item names that are still dirty ***/
342: FOR l_index IN p_pubitems_tbl.FIRST..p_pubitems_tbl.LAST LOOP
343: IF p_pubitems_tbl.EXISTS( l_index) THEN
344: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
345: jtm_message_log_pkg.Log_Msg
346: ( v_object_id => p_pubitems_tbl(l_index)
347: , v_object_name => g_object_name
348: , v_message => 'No wrapper available for dirty publication item ' || p_pubitems_tbl(l_index)
349: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

Line 356: jtm_message_log_pkg.Log_Msg

352: END LOOP;
353: END IF;
354:
355: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
356: jtm_message_log_pkg.Log_Msg
357: ( v_object_id => null
358: , v_object_name => g_object_name
359: , v_message => 'Leaving CSL_SERVICEL_WRAPPER_PKG.APPLY_DIRTY_PUBITEMS'
360: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 365: jtm_message_log_pkg.Log_Msg

361: END IF;
362:
363: EXCEPTION WHEN OTHERS THEN
364: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
365: jtm_message_log_pkg.Log_Msg
366: ( v_object_id => null
367: , v_object_name => g_object_name
368: , v_message => 'Exception occurred in CSL_SERVICEL_WRAPPER_PKG.APPLY_DIRTY_PUBITEMS:' || fnd_global.local_chr(10) || sqlerrm
369: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

Line 373: jtm_message_log_pkg.Log_Msg

369: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
370: END IF;
371:
372: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
373: jtm_message_log_pkg.Log_Msg
374: ( v_object_id => null
375: , v_object_name => g_object_name
376: , v_message => 'Leaving CSL_SERVICEL_WRAPPER_PKG.APPLY_DIRTY_PUBITEMS'
377: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 399: jtm_message_log_pkg.Log_Msg

395: BEGIN
396: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
397:
398: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
399: jtm_message_log_pkg.Log_Msg
400: ( v_object_id => null
401: , v_object_name => g_object_name
402: , v_message => 'Entering CSL_SERVICEL_WRAPPER_PKG.Apply_Client_Changes'
403: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 407: jtm_message_log_pkg.Log_Msg

403: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
404: END IF;
405:
406: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
407: jtm_message_log_pkg.Log_Msg
408: ( v_object_id => null
409: , v_object_name => g_object_name
410: , v_message => 'Applying changes for user ' || p_user_name ||
411: ', tranid = ' || TO_CHAR( p_tranid )

Line 427: jtm_message_log_pkg.Log_Msg

423: /*** successfully retrieved item names? ***/
424: IF l_return_status <> FND_API.G_RET_STS_SUCCESS OR l_pubitems_tbl.COUNT = 0 THEN
425: /*** No -> log that no items were retrieved ***/
426: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
427: jtm_message_log_pkg.Log_Msg
428: ( v_object_id => null
429: , v_object_name => g_object_name
430: , v_message => 'asg_apply.get_all_dirty_pub_items didn''t return any records'
431: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 436: jtm_message_log_pkg.Log_Msg

432: END IF;
433: ELSE
434: /*** yes -> process them ***/
435: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
436: jtm_message_log_pkg.Log_Msg
437: ( v_object_id => null
438: , v_object_name => g_object_name
439: , v_message => 'Found ' || l_pubitems_tbl.COUNT || ' dirty non-deferred publication item(s)'
440: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 463: jtm_message_log_pkg.Log_Msg

459: /*** successfully retrieved item names? ***/
460: IF l_return_status <> FND_API.G_RET_STS_SUCCESS OR l_pubitems_tbl.COUNT = 0 THEN
461: /*** No -> log that no items were retrieved ***/
462: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
463: jtm_message_log_pkg.Log_Msg
464: ( v_object_id => null
465: , v_object_name => g_object_name
466: , v_message => 'asg_apply.get_all_deferred_pub_items didn''t return any records'
467: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 472: jtm_message_log_pkg.Log_Msg

468: END IF;
469: ELSE
470: /*** yes -> process them ***/
471: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
472: jtm_message_log_pkg.Log_Msg
473: ( v_object_id => null
474: , v_object_name => g_object_name
475: , v_message => 'Found ' || l_pubitems_tbl.COUNT || ' dirty deferred publication item(s)'
476: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 488: jtm_message_log_pkg.Log_Msg

484: );
485: END IF;
486:
487: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
488: jtm_message_log_pkg.Log_Msg
489: ( v_object_id => null
490: , v_object_name => g_object_name
491: , v_message => 'Leaving CSL_SERVICEL_WRAPPER_PKG.Apply_Client_Changes'
492: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 498: jtm_message_log_pkg.Log_Msg

494:
495: EXCEPTION WHEN OTHERS THEN
496: /*** catch and log exceptions ***/
497: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
498: jtm_message_log_pkg.Log_Msg
499: ( v_object_id => null
500: , v_object_name => g_object_name
501: , v_message => 'Exception occurred in CSL_SERVICEL_WRAPPER_PKG.Apply_Client_Changes:' || fnd_global.local_chr(10) || sqlerrm
502: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

Line 506: jtm_message_log_pkg.Log_Msg

502: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
503: END IF;
504:
505: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
506: jtm_message_log_pkg.Log_Msg
507: ( v_object_id => null
508: , v_object_name => g_object_name
509: , v_message => 'Leaving CSL_SERVICEL_WRAPPER_PKG.Apply_Client_Changes'
510: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 538: jtm_message_log_pkg.Log_Msg

534: l_msg_data VARCHAR2(4000);
535: l_msg_dummy NUMBER;
536: BEGIN
537: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
538: jtm_message_log_pkg.Log_Msg
539: ( v_object_id => null
540: , v_object_name => g_object_name
541: , v_message => 'Entering CSL_SERVICEL_WRAPPER_PKG.Get_error_message_text'
542: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 600: jtm_message_log_pkg.Log_Msg

596: END IF;
597: END IF;
598:
599: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
600: jtm_message_log_pkg.Log_Msg
601: ( v_object_id => null
602: , v_object_name => g_object_name
603: , v_message => 'Leaving CSL_SERVICEL_WRAPPER_PKG.Get_error_message_text'
604: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 610: jtm_message_log_pkg.Log_Msg

606: RETURN l_fnd_message;
607: EXCEPTION WHEN OTHERS THEN
608:
609: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
610: jtm_message_log_pkg.Log_Msg
611: ( v_object_id => null
612: , v_object_name => g_object_name
613: , v_message => 'Exception occurred in CSL_SERVICEL_WRAPPER_PKG.Get_error_message_text:' || fnd_global.local_chr(10) || sqlerrm
614: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

Line 618: jtm_message_log_pkg.Log_Msg

614: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
615: END IF;
616:
617: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
618: jtm_message_log_pkg.Log_Msg
619: ( v_object_id => null
620: , v_object_name => g_object_name
621: , v_message => 'Leaving CSL_SERVICEL_WRAPPER_PKG.Get_error_message_text'
622: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 647: jtm_message_log_pkg.Log_Msg

643: BEGIN
644: x_return_status := FND_API.G_RET_STS_SUCCESS;
645:
646: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
647: jtm_message_log_pkg.Log_Msg
648: ( v_object_id => p_pk
649: , v_object_name => p_object_name
650: , v_message => 'Entering ' || g_object_name || '.DELETE_RECORD'
651: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 670: jtm_message_log_pkg.Log_Msg

666: );
667: END IF;
668:
669: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
670: jtm_message_log_pkg.Log_Msg
671: ( v_object_id => p_pk
672: , v_object_name => p_object_name
673: , v_message => 'Leaving ' || g_object_name || '.DELETE_RECORD'
674: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 679: jtm_message_log_pkg.Log_Msg

675: END IF;
676:
677: EXCEPTION WHEN OTHERS THEN
678: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
679: jtm_message_log_pkg.Log_Msg
680: ( v_object_id => p_pk
681: , v_object_name => p_object_name
682: , v_message => 'Exception occurred in DELETE_RECORD:' || fnd_global.local_chr(10) || sqlerrm
683: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

Line 693: jtm_message_log_pkg.Log_Msg

689: p_api_error => TRUE
690: );
691:
692: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
693: jtm_message_log_pkg.Log_Msg
694: ( v_object_id => p_pk
695: , v_object_name => p_object_name
696: , v_message => 'Leaving ' || g_object_name || '.DELETE_RECORD'
697: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 722: jtm_message_log_pkg.Log_Msg

718: BEGIN
719: x_return_status := FND_API.G_RET_STS_SUCCESS;
720:
721: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
722: jtm_message_log_pkg.Log_Msg
723: ( v_object_id => p_pk
724: , v_object_name => p_object_name
725: , v_message => 'Entering ' || g_object_name || '.DEFER_RECORD'
726: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 739: jtm_message_log_pkg.Log_Msg

735: /*** check if defer was successfull ***/
736: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
737: /*** no -> log and return error ***/
738: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
739: jtm_message_log_pkg.Log_Msg
740: ( v_object_id => p_pk
741: , v_object_name => p_object_name
742: , v_message => 'asg_defer.defer_row failed:' || fnd_global.local_chr(10) || p_error_msg
743: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

Line 747: jtm_message_log_pkg.Log_Msg

743: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
744: END IF;
745:
746: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
747: jtm_message_log_pkg.Log_Msg
748: ( v_object_id => p_pk
749: , v_object_name => p_object_name
750: , v_message => 'Leaving ' || g_object_name || '.DEFER_RECORD'
751: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 759: jtm_message_log_pkg.Log_Msg

755:
756: /*** defer successful -> reject record except for updates ***/
757: IF p_dml_type = 'I' THEN
758: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
759: jtm_message_log_pkg.Log_Msg
760: ( v_object_id => p_pk
761: , v_object_name => p_object_name
762: , v_message => 'Rejecting record'
763: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 776: jtm_message_log_pkg.Log_Msg

772: /*** check if reject was successfull ***/
773: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
774: /*** no -> log error ***/
775: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
776: jtm_message_log_pkg.Log_Msg
777: ( v_object_id => p_pk
778: , v_object_name => p_object_name
779: , v_message => 'asg_defer.reject_row failed:' || fnd_global.local_chr(10) || p_error_msg
780: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

Line 786: jtm_message_log_pkg.Log_Msg

782: END IF;
783: END IF;
784:
785: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
786: jtm_message_log_pkg.Log_Msg
787: ( v_object_id => p_pk
788: , v_object_name => p_object_name
789: , v_message => 'Leaving ' || g_object_name || '.DEFER_RECORD'
790: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 795: jtm_message_log_pkg.Log_Msg

791: END IF;
792:
793: EXCEPTION WHEN OTHERS THEN
794: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
795: jtm_message_log_pkg.Log_Msg
796: ( v_object_id => p_pk
797: , v_object_name => p_object_name
798: , v_message => 'Exception occurred in ' || g_object_name || '.DEFER_RECORD:' || fnd_global.local_chr(10) || sqlerrm
799: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

Line 803: jtm_message_log_pkg.Log_Msg

799: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
800: END IF;
801:
802: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
803: jtm_message_log_pkg.Log_Msg
804: ( v_object_id => p_pk
805: , v_object_name => p_object_name
806: , v_message => 'Leaving ' || g_object_name || '.DEFER_RECORD'
807: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 831: jtm_message_log_pkg.Log_Msg

827: BEGIN
828: x_return_status := FND_API.G_RET_STS_SUCCESS;
829:
830: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
831: jtm_message_log_pkg.Log_Msg
832: ( v_object_id => p_pk
833: , v_object_name => p_object_name
834: , v_message => 'Entering ' || g_object_name || '.REJECT_RECORD'
835: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 850: jtm_message_log_pkg.Log_Msg

846: /*** check if reject was successfull ***/
847: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
848: /*** no -> log error ***/
849: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
850: jtm_message_log_pkg.Log_Msg
851: ( v_object_id => p_pk
852: , v_object_name => p_object_name
853: , v_message => 'asg_defer.reject_row failed:' || fnd_global.local_chr(10) || p_error_msg
854: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

Line 859: jtm_message_log_pkg.Log_Msg

855: END IF;
856: END IF;
857:
858: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
859: jtm_message_log_pkg.Log_Msg
860: ( v_object_id => p_pk
861: , v_object_name => p_object_name
862: , v_message => 'Leaving ' || g_object_name || '.REJECT_RECORD'
863: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 867: jtm_message_log_pkg.Log_Msg

863: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
864: END IF;
865: EXCEPTION WHEN OTHERS THEN
866: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
867: jtm_message_log_pkg.Log_Msg
868: ( v_object_id => p_pk
869: , v_object_name => p_object_name
870: , v_message => 'Exception occurred in ' || g_object_name || '.REJECT_RECORD:' || fnd_global.local_chr(10) || sqlerrm
871: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

Line 875: jtm_message_log_pkg.Log_Msg

871: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
872: END IF;
873:
874: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
875: jtm_message_log_pkg.Log_Msg
876: ( v_object_id => p_pk
877: , v_object_name => p_object_name
878: , v_message => 'Leaving ' || g_object_name || '.REJECT_RECORD'
879: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 960: jtm_message_log_pkg.Log_Msg

956: PRAGMA AUTONOMOUS_TRANSACTION;
957: l_rc BOOLEAN;
958: BEGIN
959: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
960: jtm_message_log_pkg.Log_Msg
961: ( v_object_id => null
962: , v_object_name => g_object_name
963: , v_message => 'Entering ' || g_object_name || '.AUTONOMOUS_MARK_DIRTY'
964: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 976: jtm_message_log_pkg.Log_Msg

972: );
973: COMMIT;
974:
975: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
976: jtm_message_log_pkg.Log_Msg
977: ( v_object_id => null
978: , v_object_name => g_object_name
979: , v_message => 'Leaving ' || g_object_name || '.AUTONOMOUS_MARK_DIRTY'
980: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 986: jtm_message_log_pkg.Log_Msg

982:
983: RETURN l_rc;
984: EXCEPTION WHEN OTHERS THEN
985: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
986: jtm_message_log_pkg.Log_Msg
987: ( v_object_id => null
988: , v_object_name => g_object_name
989: , v_message => 'Exception occurred in AUTONOMOUS_MARK_DIRTY.'
990: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

Line 1000: jtm_message_log_pkg.Log_Msg

996:
997: FUNCTION detect_conflict(p_user_name IN VARCHAR2) RETURN VARCHAR2 IS
998: BEGIN
999:
1000: jtm_message_log_pkg.Log_Msg
1001: ( v_object_id => null
1002: , v_object_name => g_object_name
1003: , v_message => 'Entering DETECT_CONFLICT : User '||p_user_name
1004: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

Line 1024: jtm_message_log_pkg.Log_Msg

1020: l_profile_value VARCHAR2(30) ;
1021:
1022: BEGIN
1023:
1024: jtm_message_log_pkg.Log_Msg
1025: ( v_object_id => null
1026: , v_object_name => g_object_name
1027: , v_message => 'Entering CONFLICT_RESOLUTION_HANDLER : User '
1028: ||p_user_name