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

Line 39: jtm_message_log_pkg.Log_Msg

35: /*** get debug level ***/
36: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
37:
38: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
39: jtm_message_log_pkg.Log_Msg
40: ( p_req_header_id
41: , g_table_name
42: , 'Entering Replicate_Record'
43: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 60: jtm_message_log_pkg.Log_Msg

56: CLOSE c_req_resource;
57:
58: IF l_resource_id < 0 THEN
59: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
60: jtm_message_log_pkg.Log_Msg
61: ( p_req_header_id
62: , g_table_name
63: , 'Replicate_Record error: Could not find resource for requirement '|| p_req_header_id
64: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

Line 73: jtm_message_log_pkg.Log_Msg

69: /*** is resource a mobile user? ***/
70: IF NOT JTM_HOOK_UTIL_PKG.isMobileFSresource( l_resource_id ) THEN
71: /*** No -> exit ***/
72: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
73: jtm_message_log_pkg.Log_Msg
74: ( p_req_header_id
75: , g_table_name
76: , 'Replicate_Record returned FALSE' || fnd_global.local_chr(10) ||
77: 'Resource_id ' || l_resource_id || ' is not a mobile user.'

Line 85: jtm_message_log_pkg.Log_Msg

81: RETURN FALSE;
82: END IF;
83:
84: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
85: jtm_message_log_pkg.Log_Msg
86: ( p_req_header_id
87: , g_table_name
88: , 'Replicate_Record returned TRUE'
89: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 117: jtm_message_log_pkg.Log_Msg

113:
114: l_resource_id NUMBER;
115: BEGIN
116: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
117: jtm_message_log_pkg.Log_Msg
118: ( p_req_header_id
119: , g_table_name
120: , 'Entering Insert_ACC_Record'
121: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 125: jtm_message_log_pkg.Log_Msg

121: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
122: END IF;
123:
124: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
125: jtm_message_log_pkg.Log_Msg
126: ( p_req_header_id
127: , g_table_name
128: , 'Inserting ACC record'
129: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 146: jtm_message_log_pkg.Log_Msg

142: CLOSE c_req_resource;
143:
144: IF l_resource_id < 0 THEN
145: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
146: jtm_message_log_pkg.Log_Msg
147: ( p_req_header_id
148: , g_table_name
149: , 'Insert ACC Record error: Could not find a resource for requirement ' || p_req_header_id
150: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

Line 163: jtm_message_log_pkg.Log_Msg

159: );
160: END IF;
161:
162: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
163: jtm_message_log_pkg.Log_Msg
164: ( p_req_header_id
165: , g_table_name
166: , 'Leaving Insert_ACC_Record'
167: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 192: jtm_message_log_pkg.Log_Msg

188:
189: l_resource_id NUMBER;
190: BEGIN
191: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
192: jtm_message_log_pkg.Log_Msg
193: ( p_req_header_id
194: , g_table_name
195: , 'Entering Update_ACC_Record'
196: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 200: jtm_message_log_pkg.Log_Msg

196: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
197: END IF;
198:
199: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
200: jtm_message_log_pkg.Log_Msg
201: ( p_req_header_id
202: , g_table_name
203: , 'Updating ACC record(s)'
204: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 221: jtm_message_log_pkg.Log_Msg

217: CLOSE c_req_resource;
218:
219: IF l_resource_id < 0 THEN
220: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
221: jtm_message_log_pkg.Log_Msg
222: ( p_req_header_id
223: , g_table_name
224: , 'Update ACC Record error: Could not find resource for requirement '|| p_req_header_id
225: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

Line 237: jtm_message_log_pkg.Log_Msg

233: );
234: END IF;
235:
236: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
237: jtm_message_log_pkg.Log_Msg
238: ( p_req_header_id
239: , g_table_name
240: , 'Leaving Update_ACC_Record'
241: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 253: jtm_message_log_pkg.Log_Msg

249: )
250: IS
251: BEGIN
252: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
253: jtm_message_log_pkg.Log_Msg
254: ( p_req_header_id
255: , g_table_name
256: , 'Entering Delete_ACC_Record'
257: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 261: jtm_message_log_pkg.Log_Msg

257: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
258: END IF;
259:
260: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
261: jtm_message_log_pkg.Log_Msg
262: ( p_req_header_id
263: , g_table_name
264: , 'Deleting ACC record for resource_id = ' || p_resource_id
265: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 278: jtm_message_log_pkg.Log_Msg

274: , P_RESOURCE_ID => p_resource_id
275: );
276:
277: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
278: jtm_message_log_pkg.Log_Msg
279: ( p_req_header_id
280: , g_table_name
281: , 'Leaving Delete_ACC_Record'
282: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 309: jtm_message_log_pkg.Log_Msg

305: END IF;
306: /*** get debug level ***/
307: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
308: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
309: jtm_message_log_pkg.Log_Msg
310: ( l_req_header_id
311: , g_table_name
312: , 'Entering POST_INSERT hook'
313: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 324: jtm_message_log_pkg.Log_Msg

320: Insert_ACC_Record(l_req_header_id);
321: END IF;
322:
323: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
324: jtm_message_log_pkg.Log_Msg
325: ( l_req_header_id
326: , g_table_name
327: , 'Leaving POST_INSERT hook'
328: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 337: jtm_message_log_pkg.Log_Msg

333:
334: EXCEPTION WHEN OTHERS THEN
335: /*** hook failed -> log error ***/
336: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
337: jtm_message_log_pkg.Log_Msg
338: ( l_req_header_id
339: , g_table_name
340: , 'Caught exception in POST_INSERT hook:' || fnd_global.local_chr(10) || sqlerrm
341: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

Line 378: jtm_message_log_pkg.Log_Msg

374: /*** get debug level ***/
375: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
376:
377: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
378: jtm_message_log_pkg.Log_Msg
379: ( l_req_header_id
380: , g_table_name
381: , 'Entering POST_UPDATE hook'
382: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 392: jtm_message_log_pkg.Log_Msg

388: Update_ACC_Record(l_req_header_id);
389: END IF;
390:
391: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
392: jtm_message_log_pkg.Log_Msg
393: ( l_req_header_id
394: , g_table_name
395: , 'Leaving POST_UPDATE hook'
396: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 403: jtm_message_log_pkg.Log_Msg

399: x_return_status := FND_API.G_RET_STS_SUCCESS;
400: EXCEPTION WHEN OTHERS THEN
401: /*** hook failed -> log error ***/
402: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
403: jtm_message_log_pkg.Log_Msg
404: ( l_req_header_id
405: , g_table_name
406: , 'Caught exception in POST_UPDATE hook:' || fnd_global.local_chr(10) || sqlerrm
407: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

Line 461: jtm_message_log_pkg.Log_Msg

457:
458: BEGIN
459:
460: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
461: jtm_message_log_pkg.Log_Msg
462: ( p_resource_id
463: , g_table_name
464: , 'Entering Delete_All_ACC_Records procedure for user: ' || p_resource_id
465: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 479: jtm_message_log_pkg.Log_Msg

475: -- Delete_Acc_Record( r_req_task_ass.requirement_header_id, p_resource_id );
476: -- END LOOP;
477:
478: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
479: jtm_message_log_pkg.Log_Msg
480: ( p_resource_id
481: , g_table_name
482: , 'Leaving Delete_All_ACC_Records procedure for user: ' || p_resource_id
483: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 516: jtm_message_log_pkg.Log_Msg

512:
513: BEGIN
514:
515: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
516: jtm_message_log_pkg.Log_Msg
517: ( p_resource_id
518: , g_table_name
519: , 'Entering Insert_All_ACC_Records procedure for user: ' || p_resource_id
520: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 538: jtm_message_log_pkg.Log_Msg

534: -- END IF;
535: -- END LOOP;
536:
537: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
538: jtm_message_log_pkg.Log_Msg
539: ( p_resource_id
540: , g_table_name
541: , 'Leaving Insert_All_ACC_Records procedure for user: ' || p_resource_id
542: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);