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

Line 60: jtm_message_log_pkg.Log_Msg

56: /*** get debug level ***/
57: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
58:
59: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
60: jtm_message_log_pkg.Log_Msg
61: ( p_location_id
62: , g_table_name
63: , 'Entering Replicate_Record'
64: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 72: jtm_message_log_pkg.Log_Msg

68: FETCH c_location INTO r_location;
69: IF c_location%NOTFOUND THEN
70: /*** could not find location record -> exit ***/
71: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
72: jtm_message_log_pkg.Log_Msg
73: ( p_location_id
74: , g_table_name
75: , 'Replicate_Record error: Could not find record associated with PO_LOCATION_ASSOCIATIONS_ALL.LOCATION_ID '
76: || p_location_id

Line 90: jtm_message_log_pkg.Log_Msg

86: /*** is resource a mobile user? ***/
87: IF NOT JTM_HOOK_UTIL_PKG.isMobileFSresource( r_location.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_location_id
92: , g_table_name
93: , 'Replicate_Record returned FALSE' || fnd_global.local_chr(10) ||
94: 'Resource_id ' || r_location.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_location_id
105: , g_table_name
106: , 'Replicate_Record returned TRUE'
107: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 141: jtm_message_log_pkg.Log_Msg

137: r_location_ids c_location_ids%ROWTYPE;
138: l_resource_id NUMBER;
139: BEGIN
140: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
141: jtm_message_log_pkg.Log_Msg
142: ( p_location_id
143: , g_table_name
144: , 'Entering Insert_ACC_Record'
145: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 149: jtm_message_log_pkg.Log_Msg

145: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
146: END IF;
147:
148: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
149: jtm_message_log_pkg.Log_Msg
150: ( p_location_id
151: , g_table_name
152: , 'Inserting ACC record'
153: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 162: jtm_message_log_pkg.Log_Msg

158: FETCH c_location_ids INTO r_location_ids;
159: IF c_location_ids%NOTFOUND THEN
160: /*** could not find location record -> exit ***/
161: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
162: jtm_message_log_pkg.Log_Msg
163: ( p_location_id
164: , g_table_name
165: , 'Insert ACC Record error: Could not find record associated with PO_LOCATION_ASSOCIATIONS_ALL.LOCATION_ID ' || p_location_id
166: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

Line 211: jtm_message_log_pkg.Log_Msg

207: END IF;
208: CLOSE c_location_ids;
209:
210: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
211: jtm_message_log_pkg.Log_Msg
212: ( p_location_id
213: , g_table_name
214: , 'Leaving Insert_ACC_Record'
215: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 256: jtm_message_log_pkg.Log_Msg

252: l_hzl_acc_id NUMBER;
253: l_resource_id NUMBER;
254: BEGIN
255: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
256: jtm_message_log_pkg.Log_Msg
257: ( p_location_id
258: , g_table_name
259: , 'Entering Update_ACC_Record'
260: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 264: jtm_message_log_pkg.Log_Msg

260: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
261: END IF;
262:
263: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
264: jtm_message_log_pkg.Log_Msg
265: ( p_location_id
266: , g_table_name
267: , 'Updating ACC record(s)'
268: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 277: jtm_message_log_pkg.Log_Msg

273: FETCH c_location_ids INTO r_location_ids;
274: IF c_location_ids%NOTFOUND THEN
275: /*** could not find location record -> exit ***/
276: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
277: jtm_message_log_pkg.Log_Msg
278: ( p_location_id
279: , g_table_name
280: , 'Update ACC Record error: Could not find record associated with PO_LOCATION_ASSOCIATIONS_ALL.LOCATION_ID '
281: || p_location_id

Line 345: jtm_message_log_pkg.Log_Msg

341:
342: CLOSE c_location_ids;
343:
344: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
345: jtm_message_log_pkg.Log_Msg
346: ( p_location_id
347: , g_table_name
348: , 'Leaving Update_ACC_Record'
349: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 380: jtm_message_log_pkg.Log_Msg

376: AND PLA.LOCATION_ID = b_location_id;
377: r_location_ids c_location_ids%ROWTYPE;
378: BEGIN
379: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
380: jtm_message_log_pkg.Log_Msg
381: ( p_location_id
382: , g_table_name
383: , 'Entering Delete_ACC_Record'
384: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 388: jtm_message_log_pkg.Log_Msg

384: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
385: END IF;
386:
387: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
388: jtm_message_log_pkg.Log_Msg
389: ( p_location_id
390: , g_table_name
391: , 'Deleting ACC record for resource_id = ' || p_resource_id
392: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 402: jtm_message_log_pkg.Log_Msg

398: FETCH c_location_ids INTO r_location_ids;
399: IF c_location_ids%NOTFOUND THEN
400: /*** could not find location record -> exit ***/
401: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
402: jtm_message_log_pkg.Log_Msg
403: ( p_location_id
404: , g_table_name
405: , 'Delete ACC Record error: Could not find record for LOCATION_ID ' || p_location_id
406: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

Line 410: jtm_message_log_pkg.Log_Msg

406: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
407: END IF;
408: ELSE
409: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
410: jtm_message_log_pkg.Log_Msg
411: ( p_resource_id
412: , g_table_name
413: , 'Delete CSP_RS_CUST_RELATIONS acc record for user: ' || p_resource_id
414: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 425: jtm_message_log_pkg.Log_Msg

421: , P_RESOURCE_ID => p_resource_id
422: );
423:
424: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
425: jtm_message_log_pkg.Log_Msg
426: ( p_resource_id
427: , g_table_name
428: , 'Delete HZ_CUST_ACCT_SITES_ALL acc record for user: ' || p_resource_id
429: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 440: jtm_message_log_pkg.Log_Msg

436: , P_RESOURCE_ID => p_resource_id
437: );
438:
439: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
440: jtm_message_log_pkg.Log_Msg
441: ( p_resource_id
442: , g_table_name
443: , 'Delete HZ_CUST_SITE_USES_ALL acc record for user: ' || p_resource_id
444: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 455: jtm_message_log_pkg.Log_Msg

451: , P_RESOURCE_ID => p_resource_id
452: );
453:
454: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
455: jtm_message_log_pkg.Log_Msg
456: ( p_resource_id
457: , g_table_name
458: , 'Delete PO_LOCATION_ASSOCIATIONS_ALL acc record for user: ' || p_resource_id
459: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 470: jtm_message_log_pkg.Log_Msg

466: , P_RESOURCE_ID => p_resource_id
467: );
468:
469: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
470: jtm_message_log_pkg.Log_Msg
471: ( p_resource_id
472: , g_table_name
473: , 'Calling CSL_HZ_PARTY_SITES_ACC_PKG.Delete_Party_Site'
474: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 482: jtm_message_log_pkg.Log_Msg

478: END IF;
479: CLOSE c_location_ids;
480:
481: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
482: jtm_message_log_pkg.Log_Msg
483: ( p_location_id
484: , g_table_name
485: , 'Leaving Delete_ACC_Record'
486: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 518: jtm_message_log_pkg.Log_Msg

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

Line 531: jtm_message_log_pkg.Log_Msg

527: Insert_ACC_Record(l_location_id);
528: END IF;
529:
530: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
531: jtm_message_log_pkg.Log_Msg
532: ( l_location_id
533: , g_table_name
534: , 'Leaving POST_INSERT hook'
535: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 544: jtm_message_log_pkg.Log_Msg

540:
541: EXCEPTION WHEN OTHERS THEN
542: /*** hook failed -> log error ***/
543: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
544: jtm_message_log_pkg.Log_Msg
545: ( l_location_id
546: , g_table_name
547: , 'Caught exception in POST_INSERT hook:' || fnd_global.local_chr(10) || sqlerrm
548: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

Line 590: jtm_message_log_pkg.Log_Msg

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

Line 602: jtm_message_log_pkg.Log_Msg

598: Update_ACC_Record(l_location_id);
599: END IF;
600:
601: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
602: jtm_message_log_pkg.Log_Msg
603: ( l_location_id
604: , g_table_name
605: , 'Leaving POST_UPDATE hook'
606: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 613: jtm_message_log_pkg.Log_Msg

609: x_return_status := FND_API.G_RET_STS_SUCCESS;
610: EXCEPTION WHEN OTHERS THEN
611: /*** hook failed -> log error ***/
612: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
613: jtm_message_log_pkg.Log_Msg
614: ( l_location_id
615: , g_table_name
616: , 'Caught exception in POST_UPDATE hook:' || fnd_global.local_chr(10) || sqlerrm
617: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

Line 672: jtm_message_log_pkg.Log_Msg

668: BEGIN
669: /*** get debug level ***/
670: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
671: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
672: jtm_message_log_pkg.Log_Msg
673: ( p_resource_id
674: , g_table_name
675: , 'Entering Delete_All_ACC_Records procedure for user: ' || p_resource_id
676: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 684: jtm_message_log_pkg.Log_Msg

680: Delete_ACC_Record(r_location.location_id, p_resource_id );
681: END LOOP;
682:
683: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
684: jtm_message_log_pkg.Log_Msg
685: ( p_resource_id
686: , g_table_name
687: , 'Leaving Delete_All_ACC_Records procedure for user: ' || p_resource_id
688: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 723: jtm_message_log_pkg.Log_Msg

719: BEGIN
720: /*** get debug level ***/
721: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
722: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
723: jtm_message_log_pkg.Log_Msg
724: ( p_resource_id
725: , g_table_name
726: , 'Entering Insert_All_ACC_Records procedure for user: ' || p_resource_id
727: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 737: jtm_message_log_pkg.Log_Msg

733: END IF;
734: END LOOP;
735:
736: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
737: jtm_message_log_pkg.Log_Msg
738: ( p_resource_id
739: , g_table_name
740: , 'Leaving Insert_All_ACC_Records procedure for user: ' || p_resource_id
741: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);