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

Line 21: jtm_message_log_pkg.Log_Msg

17: /*** get debug level ***/
18: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
19:
20: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
21: jtm_message_log_pkg.Log_Msg
22: ( null
23: , g_table_name
24: , 'Entering CREATE_USER'
25: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 54: jtm_message_log_pkg.Log_Msg

50: ,P_RESOURCE_ID => P_RESOURCE_ID
51: );
52:
53: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
54: jtm_message_log_pkg.Log_Msg
55: ( null
56: , g_table_name
57: , 'Calling CSL_JTF_TASK_ASS_ACC_PKG.INSERT_ALL_ACC_RECORDS'
58: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 69: jtm_message_log_pkg.Log_Msg

65: COMMIT;
66:
67: /*** insert SRs created by mobile resource ***/
68: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
69: jtm_message_log_pkg.Log_Msg
70: ( null
71: , g_table_name
72: , 'Calling CSL_CS_INCIDENTS_ALL_ACC_PKG.INSERT_ALL_ACC_RECORDS'
73: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 86: jtm_message_log_pkg.Log_Msg

82: COMMIT;
83:
84: /*** insert tasks created by mobile resource ***/
85: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
86: jtm_message_log_pkg.Log_Msg
87: ( null
88: , g_table_name
89: , 'Calling CSL_JTF_TASKS_ACC_PKG.INSERT_ALL_ACC_RECORDS'
90: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 102: jtm_message_log_pkg.Log_Msg

98:
99: COMMIT;
100:
101: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
102: jtm_message_log_pkg.Log_Msg
103: ( null
104: , g_table_name
105: , 'Calling CSL_CSP_INV_LOC_ASS_ACC_PKG.INSERT_ALL_ACC_RECORDS'
106: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 116: jtm_message_log_pkg.Log_Msg

112:
113: COMMIT;
114:
115: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
116: jtm_message_log_pkg.Log_Msg
117: ( null
118: , g_table_name
119: , 'Calling CSL_CSP_LOCATIONS_ACC_PKG.INSERT_ALL_ACC_RECORDS'
120: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 130: jtm_message_log_pkg.Log_Msg

126:
127: COMMIT;
128:
129: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
130: jtm_message_log_pkg.Log_Msg
131: ( null
132: , g_table_name
133: , 'Calling CSL_CSP_REQ_HEADERS_ACC_PKG.INSERT_ALL_ACC_RECORDS'
134: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 144: jtm_message_log_pkg.Log_Msg

140:
141: COMMIT;
142:
143: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
144: jtm_message_log_pkg.Log_Msg
145: ( null
146: , g_table_name
147: , 'Calling CSL_CSP_REQ_LINES_ACC_PKG.INSERT_ALL_ACC_RECORDS'
148: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 158: jtm_message_log_pkg.Log_Msg

154:
155: COMMIT;
156:
157: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
158: jtm_message_log_pkg.Log_Msg
159: ( null
160: , g_table_name
161: , 'Calling CSL_WF_NOTIFICATION_AT_ACC_PKG.INSERT_ALL_ACC_RECORDS'
162: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 172: jtm_message_log_pkg.Log_Msg

168:
169: COMMIT;
170:
171: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
172: jtm_message_log_pkg.Log_Msg
173: ( null
174: , g_table_name
175: , 'Calling CSL_JTF_RS_GRP_MEM_ACC_PKG.INSERT_ALL_ACC_RECORDS'
176: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 186: jtm_message_log_pkg.Log_Msg

182:
183: COMMIT;
184:
185: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
186: jtm_message_log_pkg.Log_Msg
187: ( null
188: , g_table_name
189: , 'Calling CSL_MTL_SYSTEM_ITEMS_ACC_PKG.INSERT_ALL_ACC_RECORDS'
190: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 203: jtm_message_log_pkg.Log_Msg

199: /*** fix for bug 2457810 (deadlock issue), now doing commit before running autonomous inserts ***/
200: COMMIT;
201:
202: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
203: jtm_message_log_pkg.Log_Msg
204: ( null
205: , g_table_name
206: , 'Calling CSL_MTL_ONHAND_QTY_ACC_PKG.REFRESH_ONHAND_QTY'
207: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 214: jtm_message_log_pkg.Log_Msg

210:
211: COMMIT;
212:
213: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
214: jtm_message_log_pkg.Log_Msg
215: ( null
216: , g_table_name
217: , 'Calling CSL_JTF_TASK_REFS_ACC_PKG.CON_REQUEST_TASK_REFERENCES'
218: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 225: jtm_message_log_pkg.Log_Msg

221:
222: COMMIT;
223:
224: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
225: jtm_message_log_pkg.Log_Msg
226: ( null
227: , g_table_name
228: , 'Calling CSL_MTL_SERIAL_NUMBERS_ACC_PKG.INSERT_SERIAL_NUMBERS'
229: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 236: jtm_message_log_pkg.Log_Msg

232:
233: COMMIT;
234:
235: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
236: jtm_message_log_pkg.Log_Msg
237: ( null
238: , g_table_name
239: , 'Leaving CREATE_USER'
240: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 250: jtm_message_log_pkg.Log_Msg

246: /*** api call failed -> rolback and log error ***/
247: ROLLBACK ;
248:
249: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
250: jtm_message_log_pkg.Log_Msg
251: ( null
252: , g_table_name
253: , 'Exception occurred in CREATE_USER when calling API'
254: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

Line 264: jtm_message_log_pkg.Log_Msg

260: /*** uncaught exception -> rollback and log sql error ***/
261: ROLLBACK;
262:
263: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
264: jtm_message_log_pkg.Log_Msg
265: ( null
266: , g_table_name
267: , 'Caught exception in CREATE_USER:' || fnd_global.local_chr(10) || sqlerrm
268: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

Line 284: jtm_message_log_pkg.Log_Msg

280: /*** get debug level ***/
281: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
282:
283: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
284: jtm_message_log_pkg.Log_Msg
285: ( null
286: , g_table_name
287: , 'Entering DELETE_USER'
288: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

Line 293: jtm_message_log_pkg.Log_Msg

289: , 'csl_user_pkg');
290: END IF;
291:
292: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
293: jtm_message_log_pkg.Log_Msg
294: ( null
295: , g_table_name
296: , 'Delete from CSL_CONTR_BUSS_PROCESSES_ACC for resource '||p_resource_id
297: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

Line 305: jtm_message_log_pkg.Log_Msg

301: WHERE RESOURCE_ID = p_resource_id;
302: COMMIT;
303:
304: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
305: jtm_message_log_pkg.Log_Msg
306: ( null
307: , g_table_name
308: , 'Delete from CSL_CONTR_BUSS_TXN_TYPES_ACC for resource '||p_resource_id
309: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

Line 317: jtm_message_log_pkg.Log_Msg

313: WHERE RESOURCE_ID = p_resource_id;
314: COMMIT;
315:
316: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
317: jtm_message_log_pkg.Log_Msg
318: ( null
319: , g_table_name
320: , 'Delete from CSL_CSI_ITEM_INSTANCES_ACC for resource '||p_resource_id
321: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

Line 329: jtm_message_log_pkg.Log_Msg

325: WHERE RESOURCE_ID = p_resource_id;
326: COMMIT;
327:
328: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
329: jtm_message_log_pkg.Log_Msg
330: ( null
331: , g_table_name
332: , 'Delete from CSL_CS_INCIDENTS_ALL_ACC for resource '||p_resource_id
333: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

Line 341: jtm_message_log_pkg.Log_Msg

337: WHERE RESOURCE_ID = p_resource_id;
338: COMMIT;
339:
340: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
341: jtm_message_log_pkg.Log_Msg
342: ( null
343: , g_table_name
344: , 'Delete from CSL_CS_HZ_SR_CONTACT_PTS_ACC for resource '||p_resource_id
345: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

Line 353: jtm_message_log_pkg.Log_Msg

349: WHERE RESOURCE_ID = p_resource_id;
350: COMMIT;
351:
352: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
353: jtm_message_log_pkg.Log_Msg
354: ( null
355: , g_table_name
356: , 'Delete from CSL_HZ_CONTACT_POINTS_ACC for resource '||p_resource_id
357: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

Line 365: jtm_message_log_pkg.Log_Msg

361: WHERE RESOURCE_ID = p_resource_id;
362: COMMIT;
363:
364: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
365: jtm_message_log_pkg.Log_Msg
366: ( null
367: , g_table_name
368: , 'Delete from CSL_HZ_CUST_ACCT_SITES_ALL_ACC for resource '||p_resource_id
369: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

Line 377: jtm_message_log_pkg.Log_Msg

373: WHERE RESOURCE_ID = p_resource_id;
374: COMMIT;
375:
376: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
377: jtm_message_log_pkg.Log_Msg
378: ( null
379: , g_table_name
380: , 'Delete from CSL_HZ_CUST_SITE_USES_ALL_ACC for resource '||p_resource_id
381: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

Line 389: jtm_message_log_pkg.Log_Msg

385: WHERE RESOURCE_ID = p_resource_id;
386: COMMIT;
387:
388: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
389: jtm_message_log_pkg.Log_Msg
390: ( null
391: , g_table_name
392: , 'Delete from CSL_HZ_LOCATIONS_ACC for resource '||p_resource_id
393: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

Line 402: jtm_message_log_pkg.Log_Msg

398: COMMIT;
399:
400:
401: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
402: jtm_message_log_pkg.Log_Msg
403: ( null
404: , g_table_name
405: , 'Delete from CSL_HZ_PARTIES_ACC for resource '||p_resource_id
406: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

Line 414: jtm_message_log_pkg.Log_Msg

410: WHERE RESOURCE_ID = p_resource_id;
411: COMMIT;
412:
413: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
414: jtm_message_log_pkg.Log_Msg
415: ( null
416: , g_table_name
417: , 'Delete from CSL_HZ_PARTY_SITES_ACC for resource '||p_resource_id
418: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

Line 426: jtm_message_log_pkg.Log_Msg

422: WHERE RESOURCE_ID = p_resource_id;
423: COMMIT;
424:
425: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
426: jtm_message_log_pkg.Log_Msg
427: ( null
428: , g_table_name
429: , 'Delete from CSL_HZ_RELATIONSHIPS_ACC for resource '||p_resource_id
430: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

Line 438: jtm_message_log_pkg.Log_Msg

434: WHERE RESOURCE_ID = p_resource_id;
435: COMMIT;
436:
437: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
438: jtm_message_log_pkg.Log_Msg
439: ( null
440: , g_table_name
441: , 'Delete from CSL_JTF_TASKS_ACC for resource '||p_resource_id
442: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

Line 450: jtm_message_log_pkg.Log_Msg

446: WHERE RESOURCE_ID = p_resource_id;
447: COMMIT;
448:
449: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
450: jtm_message_log_pkg.Log_Msg
451: ( null
452: , g_table_name
453: , 'Delete from CSL_JTF_TASK_ASS_ACC for resource '||p_resource_id
454: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

Line 462: jtm_message_log_pkg.Log_Msg

458: WHERE RESOURCE_ID = p_resource_id;
459: COMMIT;
460:
461: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
462: jtm_message_log_pkg.Log_Msg
463: ( null
464: , g_table_name
465: , 'Delete from CSL_MTL_ONHAND_QTY_ACC for resource '||p_resource_id
466: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

Line 474: jtm_message_log_pkg.Log_Msg

470: WHERE RESOURCE_ID = p_resource_id;
471: COMMIT;
472:
473: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
474: jtm_message_log_pkg.Log_Msg
475: ( null
476: , g_table_name
477: , 'Delete from CSL_SR_CONTRACT_HEADERS_ACC for resource '||p_resource_id
478: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

Line 486: jtm_message_log_pkg.Log_Msg

482: WHERE RESOURCE_ID = p_resource_id;
483: COMMIT;
484:
485: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
486: jtm_message_log_pkg.Log_Msg
487: ( null
488: , g_table_name
489: , 'Delete from JTM_CSF_DEBRIEF_HEADERS_ACC for resource '||p_resource_id
490: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

Line 498: jtm_message_log_pkg.Log_Msg

494: WHERE RESOURCE_ID = p_resource_id;
495: COMMIT;
496:
497: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
498: jtm_message_log_pkg.Log_Msg
499: ( null
500: , g_table_name
501: , 'Delete from JTM_CSF_DEBRIEF_LINES_ACC for resource '||p_resource_id
502: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

Line 510: jtm_message_log_pkg.Log_Msg

506: WHERE RESOURCE_ID = p_resource_id;
507: COMMIT;
508:
509: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
510: jtm_message_log_pkg.Log_Msg
511: ( null
512: , g_table_name
513: , 'Delete from JTM_CSP_INV_LOC_ASS_ACC for resource '||p_resource_id
514: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

Line 522: jtm_message_log_pkg.Log_Msg

518: WHERE RESOURCE_ID = p_resource_id;
519: COMMIT;
520:
521: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
522: jtm_message_log_pkg.Log_Msg
523: ( null
524: , g_table_name
525: , 'Delete from JTM_CSP_REQ_HEADERS_ACC for resource '||p_resource_id
526: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

Line 534: jtm_message_log_pkg.Log_Msg

530: WHERE RESOURCE_ID = p_resource_id;
531: COMMIT;
532:
533: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
534: jtm_message_log_pkg.Log_Msg
535: ( null
536: , g_table_name
537: , 'Delete from JTM_CSP_REQ_LINES_ACC for resource '||p_resource_id
538: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

Line 546: jtm_message_log_pkg.Log_Msg

542: WHERE RESOURCE_ID = p_resource_id;
543: COMMIT;
544:
545: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
546: jtm_message_log_pkg.Log_Msg
547: ( null
548: , g_table_name
549: , 'Delete from JTM_CSP_RS_CUST_RELATIONS_ACC for resource '||p_resource_id
550: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

Line 558: jtm_message_log_pkg.Log_Msg

554: WHERE RESOURCE_ID = p_resource_id;
555: COMMIT;
556:
557: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
558: jtm_message_log_pkg.Log_Msg
559: ( null
560: , g_table_name
561: , 'Delete from JTM_CSP_SEC_INV_ACC for resource '||p_resource_id
562: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

Line 571: jtm_message_log_pkg.Log_Msg

567: COMMIT;
568:
569:
570: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
571: jtm_message_log_pkg.Log_Msg
572: ( null
573: , g_table_name
574: , 'Delete from JTM_CS_COUNTERS_ACC for resource '||p_resource_id
575: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

Line 583: jtm_message_log_pkg.Log_Msg

579: WHERE RESOURCE_ID = p_resource_id;
580: COMMIT;
581:
582: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
583: jtm_message_log_pkg.Log_Msg
584: ( null
585: , g_table_name
586: , 'Delete from JTM_CS_COUNTER_GROUPS_ACC for resource '||p_resource_id
587: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

Line 595: jtm_message_log_pkg.Log_Msg

591: WHERE RESOURCE_ID = p_resource_id;
592: COMMIT;
593:
594: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
595: jtm_message_log_pkg.Log_Msg
596: ( null
597: , g_table_name
598: , 'Delete from JTM_CS_COUNTER_PROPS_ACC for resource '||p_resource_id
599: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

Line 607: jtm_message_log_pkg.Log_Msg

603: WHERE RESOURCE_ID = p_resource_id;
604: COMMIT;
605:
606: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
607: jtm_message_log_pkg.Log_Msg
608: ( null
609: , g_table_name
610: , 'Delete from JTM_CS_COUNTER_PROP_VALS_ACC for resource '||p_resource_id
611: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

Line 619: jtm_message_log_pkg.Log_Msg

615: WHERE RESOURCE_ID = p_resource_id;
616: COMMIT;
617:
618: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
619: jtm_message_log_pkg.Log_Msg
620: ( null
621: , g_table_name
622: , 'Delete from JTM_CS_COUNTER_VALUES_ACC for resource '||p_resource_id
623: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

Line 631: jtm_message_log_pkg.Log_Msg

627: WHERE RESOURCE_ID = p_resource_id;
628: COMMIT;
629:
630: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
631: jtm_message_log_pkg.Log_Msg
632: ( null
633: , g_table_name
634: , 'Delete from JTM_JTF_NOTES_ACC for resource '||p_resource_id
635: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

Line 643: jtm_message_log_pkg.Log_Msg

639: WHERE RESOURCE_ID = p_resource_id;
640: COMMIT;
641:
642: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
643: jtm_message_log_pkg.Log_Msg
644: ( null
645: , g_table_name
646: , 'Delete from JTM_JTF_TASK_REFERENCES_ACC for resource '||p_resource_id
647: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

Line 655: jtm_message_log_pkg.Log_Msg

651: WHERE RESOURCE_ID = p_resource_id;
652: COMMIT;
653:
654: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
655: jtm_message_log_pkg.Log_Msg
656: ( null
657: , g_table_name
658: , 'Delete from JTM_MTL_SEC_INV_ACC for resource '||p_resource_id
659: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

Line 667: jtm_message_log_pkg.Log_Msg

663: WHERE RESOURCE_ID = p_resource_id;
664: COMMIT;
665:
666: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
667: jtm_message_log_pkg.Log_Msg
668: ( null
669: , g_table_name
670: , 'Delete from JTM_MTL_SERIAL_NUMBERS_ACC for resource '||p_resource_id
671: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

Line 679: jtm_message_log_pkg.Log_Msg

675: WHERE RESOURCE_ID = p_resource_id;
676: COMMIT;
677:
678: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
679: jtm_message_log_pkg.Log_Msg
680: ( null
681: , g_table_name
682: , 'Delete from JTM_MTL_SYSTEM_ITEMS_ACC for resource '||p_resource_id
683: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

Line 691: jtm_message_log_pkg.Log_Msg

687: WHERE RESOURCE_ID = p_resource_id;
688: COMMIT;
689:
690: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
691: jtm_message_log_pkg.Log_Msg
692: ( null
693: , g_table_name
694: , 'Delete from CSL_RESOURCE_INVENTORY_ORG for resource '||p_resource_id
695: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

Line 703: jtm_message_log_pkg.Log_Msg

699: WHERE RESOURCE_ID = p_resource_id;
700: COMMIT;
701:
702: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
703: jtm_message_log_pkg.Log_Msg
704: ( null
705: , g_table_name
706: , 'Delete from JTM_MTL_TRANS_LOT_NUM_ACC for resource '||p_resource_id
707: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

Line 715: jtm_message_log_pkg.Log_Msg

711: WHERE RESOURCE_ID = p_resource_id;
712: COMMIT;
713:
714: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
715: jtm_message_log_pkg.Log_Msg
716: ( null
717: , g_table_name
718: , 'Delete from JTM_MTL_UNIT_TRANS_ACC for resource '||p_resource_id
719: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

Line 727: jtm_message_log_pkg.Log_Msg

723: WHERE RESOURCE_ID = p_resource_id;
724: COMMIT;
725:
726: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
727: jtm_message_log_pkg.Log_Msg
728: ( null
729: , g_table_name
730: , 'Delete from JTM_OE_ORDER_HEADERS_ALL_ACC for resource '||p_resource_id
731: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

Line 739: jtm_message_log_pkg.Log_Msg

735: WHERE RESOURCE_ID = p_resource_id;
736: COMMIT;
737:
738: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
739: jtm_message_log_pkg.Log_Msg
740: ( null
741: , g_table_name
742: , 'Delete from JTM_OE_ORDER_LINES_ALL_ACC for resource '||p_resource_id
743: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

Line 751: jtm_message_log_pkg.Log_Msg

747: WHERE RESOURCE_ID = p_resource_id;
748: COMMIT;
749:
750: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
751: jtm_message_log_pkg.Log_Msg
752: ( null
753: , g_table_name
754: , 'Delete from JTM_PER_ALL_PEOPLE_F_ACC for resource '||p_resource_id
755: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

Line 763: jtm_message_log_pkg.Log_Msg

759: WHERE RESOURCE_ID = p_resource_id;
760: COMMIT;
761:
762: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
763: jtm_message_log_pkg.Log_Msg
764: ( null
765: , g_table_name
766: , 'Delete from JTM_PO_LOC_ASS_ALL_ACC for resource '||p_resource_id
767: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

Line 775: jtm_message_log_pkg.Log_Msg

771: WHERE RESOURCE_ID = p_resource_id;
772: COMMIT;
773:
774: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
775: jtm_message_log_pkg.Log_Msg
776: ( null
777: , g_table_name
778: , 'Delete from JTM_WF_NOTIFICATIONS_ACC for resource '||p_resource_id
779: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

Line 787: jtm_message_log_pkg.Log_Msg

783: WHERE RESOURCE_ID = p_resource_id;
784: COMMIT;
785:
786: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
787: jtm_message_log_pkg.Log_Msg
788: ( null
789: , g_table_name
790: , 'Delete from JTM_WF_NOTIFICATION_AT_ACC for resource '||p_resource_id
791: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

Line 799: jtm_message_log_pkg.Log_Msg

795: WHERE RESOURCE_ID = p_resource_id;
796: COMMIT;
797:
798: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
799: jtm_message_log_pkg.Log_Msg
800: ( null
801: , g_table_name
802: , 'Delete from JTM_FND_USER_ACC for resource '||p_resource_id
803: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

Line 811: jtm_message_log_pkg.Log_Msg

807: WHERE RESOURCE_ID = p_resource_id;
808: COMMIT;
809:
810: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
811: jtm_message_log_pkg.Log_Msg
812: ( null
813: , g_table_name
814: , 'Delete from JTM_JTF_RS_RESOURCE_EXTNS_ACC for resource '||p_resource_id
815: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

Line 823: jtm_message_log_pkg.Log_Msg

819: WHERE RESOURCE_ID = p_resource_id;
820: COMMIT;
821:
822: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
823: jtm_message_log_pkg.Log_Msg
824: ( null
825: , g_table_name
826: , 'Delete from JTM_JTF_RS_GROUP_MEMBERS_ACC for resource '||p_resource_id
827: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

Line 835: jtm_message_log_pkg.Log_Msg

831: WHERE RESOURCE_ID = p_resource_id;
832: COMMIT;
833:
834: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
835: jtm_message_log_pkg.Log_Msg
836: ( null
837: , g_table_name
838: , 'Delete from CSL_SERVICE_HISTORY for resource '||p_resource_id
839: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

Line 847: jtm_message_log_pkg.Log_Msg

843: WHERE RESOURCE_ID = p_resource_id;
844: COMMIT;
845:
846: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
847: jtm_message_log_pkg.Log_Msg
848: ( null
849: , g_table_name
850: , 'Leaving DELETE_USER'
851: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

Line 862: jtm_message_log_pkg.Log_Msg

858: /*** api call failed -> rolback and log error ***/
859: ROLLBACK;
860:
861: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
862: jtm_message_log_pkg.Log_Msg
863: ( null
864: , g_table_name
865: , 'Exception occurred in DELETE_USER when calling API'
866: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR

Line 877: jtm_message_log_pkg.Log_Msg

873: /*** uncaught exception -> rollback and log sql error ***/
874: ROLLBACK;
875:
876: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
877: jtm_message_log_pkg.Log_Msg
878: ( null
879: , g_table_name
880: , 'Caught exception in DELETE_USER:' || fnd_global.local_chr(10) || sqlerrm
881: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR