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

Line 55: jtm_message_log_pkg.Log_Msg

51: /*** get debug level ***/
52: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
53:
54: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
55: jtm_message_log_pkg.Log_Msg
56: ( p_req_line_id
57: , g_table_name
58: , 'Entering Replicate_Record'
59: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 77: jtm_message_log_pkg.Log_Msg

73:
74: IF l_resource_id < 0 THEN
75: /*** could not find requirement record -> exit ***/
76: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
77: jtm_message_log_pkg.Log_Msg
78: ( p_req_line_id
79: , g_table_name
80: , 'Requirement not created for specific resource; not replicating record'
81: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 90: jtm_message_log_pkg.Log_Msg

86: /*** is resource a mobile user? ***/
87: IF NOT JTM_HOOK_UTIL_PKG.isMobileFSresource( l_resource_id ) THEN
88: /*** No -> exit ***/
89: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
90: jtm_message_log_pkg.Log_Msg
91: ( p_req_line_id
92: , g_table_name
93: , 'Replicate_Record returned FALSE' || fnd_global.local_chr(10) ||
94: 'Resource_id ' || l_resource_id || ' is not a mobile user.'

Line 103: jtm_message_log_pkg.Log_Msg

99: END IF;
100:
101:
102: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
103: jtm_message_log_pkg.Log_Msg
104: ( p_req_line_id
105: , g_table_name
106: , 'Replicate_Record returned TRUE'
107: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 159: jtm_message_log_pkg.Log_Msg

155: l_header_id NUMBER;
156: l_line_id NUMBER;
157: BEGIN
158: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
159: jtm_message_log_pkg.Log_Msg
160: ( p_req_line_id
161: , g_table_name
162: , 'Entering Insert_ACC_Record'
163: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 167: jtm_message_log_pkg.Log_Msg

163: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
164: END IF;
165:
166: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
167: jtm_message_log_pkg.Log_Msg
168: ( p_req_line_id
169: , g_table_name
170: , 'Inserting ACC record'
171: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 197: jtm_message_log_pkg.Log_Msg

193: CLOSE c_req_info;
194:
195: IF l_resource_id < 0 THEN
196: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
197: jtm_message_log_pkg.Log_Msg
198: ( p_req_line_id
199: , g_table_name
200: , 'Requirement not created for specific resource; not replicating record'
201: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 243: jtm_message_log_pkg.Log_Msg

239: END IF;
240: END IF;
241:
242: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
243: jtm_message_log_pkg.Log_Msg
244: ( p_req_line_id
245: , g_table_name
246: , 'Leaving Insert_ACC_Record'
247: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 296: jtm_message_log_pkg.Log_Msg

292: l_header_id NUMBER;
293: l_line_id NUMBER;
294: BEGIN
295: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
296: jtm_message_log_pkg.Log_Msg
297: ( p_req_line_id
298: , g_table_name
299: , 'Entering Update_ACC_Record'
300: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 304: jtm_message_log_pkg.Log_Msg

300: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
301: END IF;
302:
303: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
304: jtm_message_log_pkg.Log_Msg
305: ( p_req_line_id
306: , g_table_name
307: , 'Updating ACC record(s)'
308: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 334: jtm_message_log_pkg.Log_Msg

330:
331: IF l_resource_id < 0 THEN
332: /*** could not find requirement record -> exit ***/
333: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
334: jtm_message_log_pkg.Log_Msg
335: ( p_req_line_id
336: , g_table_name
337: , 'Update ACC Record error: Could not find resource for requirement line '|| p_req_line_id
338: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

Line 379: jtm_message_log_pkg.Log_Msg

375: END IF;
376: END IF;
377:
378: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
379: jtm_message_log_pkg.Log_Msg
380: ( p_req_line_id
381: , g_table_name
382: , 'Leaving Update_ACC_Record'
383: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 413: jtm_message_log_pkg.Log_Msg

409: l_line_id NUMBER;
410:
411: BEGIN
412: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
413: jtm_message_log_pkg.Log_Msg
414: ( p_req_line_id
415: , g_table_name
416: , 'Entering Delete_ACC_Record'
417: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 425: jtm_message_log_pkg.Log_Msg

421: FETCH c_req_line_id INTO r_req_line_id;
422: IF c_req_line_id%NOTFOUND THEN
423: /*** could not find requirement record -> exit ***/
424: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
425: jtm_message_log_pkg.Log_Msg
426: ( p_req_line_id
427: , g_table_name
428: , 'Could not find record associated with CSP_REQUIREMENT_LINES.REQUIREMENT_LINE_ID ' || p_req_line_id
429: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

Line 433: jtm_message_log_pkg.Log_Msg

429: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
430: END IF;
431: ELSE
432: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
433: jtm_message_log_pkg.Log_Msg
434: ( p_req_line_id
435: , g_table_name
436: , 'Deleting ACC record for resource_id = ' || p_resource_id
437: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 454: jtm_message_log_pkg.Log_Msg

450: l_line_id := r_req_line_id.LINE_ID;
451: IF (l_header_id IS NOT NULL) THEN
452:
453: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
454: jtm_message_log_pkg.Log_Msg
455: ( p_resource_id
456: , g_table_name
457: , 'Delete Order Header acc record for user: ' || p_resource_id
458: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 469: jtm_message_log_pkg.Log_Msg

465: , P_RESOURCE_ID => p_resource_id
466: );
467:
468: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
469: jtm_message_log_pkg.Log_Msg
470: ( p_resource_id
471: , g_table_name
472: , 'Delete Order Line acc record for user: ' || p_resource_id
473: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 487: jtm_message_log_pkg.Log_Msg

483: END IF;
484: CLOSE c_req_line_id;
485:
486: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
487: jtm_message_log_pkg.Log_Msg
488: ( p_req_line_id
489: , g_table_name
490: , 'Leaving Delete_ACC_Record'
491: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 520: jtm_message_log_pkg.Log_Msg

516: END IF;
517: /*** get debug level ***/
518: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
519: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
520: jtm_message_log_pkg.Log_Msg
521: ( l_req_line_id
522: , g_table_name
523: , 'Entering POST_INSERT hook'
524: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 536: jtm_message_log_pkg.Log_Msg

532: Insert_ACC_Record(l_req_line_id);
533: END IF;
534:
535: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
536: jtm_message_log_pkg.Log_Msg
537: ( l_req_line_id
538: , g_table_name
539: , 'Leaving POST_INSERT hook'
540: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 549: jtm_message_log_pkg.Log_Msg

545:
546: EXCEPTION WHEN OTHERS THEN
547: /*** hook failed -> log error ***/
548: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
549: jtm_message_log_pkg.Log_Msg
550: ( l_req_line_id
551: , g_table_name
552: , 'Caught exception in POST_INSERT hook:' || fnd_global.local_chr(10) || sqlerrm
553: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

Line 592: jtm_message_log_pkg.Log_Msg

588: /*** get debug level ***/
589: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
590:
591: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
592: jtm_message_log_pkg.Log_Msg
593: ( l_req_line_id
594: , g_table_name
595: , 'Entering POST_UPDATE hook'
596: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 607: jtm_message_log_pkg.Log_Msg

603: Update_ACC_Record(l_req_line_id);
604: END IF;
605:
606: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
607: jtm_message_log_pkg.Log_Msg
608: ( l_req_line_id
609: , g_table_name
610: , 'Leaving POST_UPDATE hook'
611: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 618: jtm_message_log_pkg.Log_Msg

614: x_return_status := FND_API.G_RET_STS_SUCCESS;
615: EXCEPTION WHEN OTHERS THEN
616: /*** hook failed -> log error ***/
617: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
618: jtm_message_log_pkg.Log_Msg
619: ( l_req_line_id
620: , g_table_name
621: , 'Caught exception in POST_UPDATE hook:' || fnd_global.local_chr(10) || sqlerrm
622: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

Line 682: jtm_message_log_pkg.Log_Msg

678:
679: BEGIN
680:
681: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
682: jtm_message_log_pkg.Log_Msg
683: ( p_resource_id
684: , g_table_name
685: , 'Entering Delete_All_ACC_Records procedure for user: ' || p_resource_id
686: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 700: jtm_message_log_pkg.Log_Msg

696: -- Delete_Acc_Record( r_req_task_ass.requirement_line_id, p_resource_id );
697: -- END LOOP;
698:
699: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
700: jtm_message_log_pkg.Log_Msg
701: ( p_resource_id
702: , g_table_name
703: , 'Leaving Delete_All_ACC_Records procedure for user: ' || p_resource_id
704: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 742: jtm_message_log_pkg.Log_Msg

738:
739: BEGIN
740:
741: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
742: jtm_message_log_pkg.Log_Msg
743: ( p_resource_id
744: , g_table_name
745: , 'Entering Insert_All_ACC_Records procedure for user: ' || p_resource_id
746: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 764: jtm_message_log_pkg.Log_Msg

760: -- END IF;
761: -- END LOOP;
762:
763: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
764: jtm_message_log_pkg.Log_Msg
765: ( p_resource_id
766: , g_table_name
767: , 'Leaving Insert_All_ACC_Records procedure for user: ' || p_resource_id
768: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);