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

Line 34: jtm_message_log_pkg.Log_Msg

30: AND NAME = b_name;
31: r_attr c_attr%ROWTYPE;
32: BEGIN
33: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
34: jtm_message_log_pkg.Log_Msg
35: ( v_object_id => p_record.notification_id
36: , v_object_name => g_object_name
37: , v_message => 'Entering ' || g_object_name || '.APPLY_INSERT'
38: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 64: jtm_message_log_pkg.Log_Msg

60: /*** Call Concurrent Program to push new Notification Attribute to mobile ***/
61: CSL_CONC_NOTIFICATION_PKG.RUN_CONCURRENT_NOTIFICATIONS;
62:
63: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
64: jtm_message_log_pkg.Log_Msg
65: ( v_object_id => p_record.notification_id
66: , v_object_name => g_object_name
67: , v_message => 'Leaving ' || g_object_name || '.APPLY_INSERT'
68: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 73: jtm_message_log_pkg.Log_Msg

69: END IF;
70:
71: EXCEPTION WHEN OTHERS THEN
72: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
73: jtm_message_log_pkg.Log_Msg
74: ( v_object_id => p_record.notification_id
75: , v_object_name => g_object_name
76: , v_message => 'Exception occurred in APPLY_INSERT:' || fnd_global.local_chr(10) || sqlerrm
77: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

Line 87: jtm_message_log_pkg.Log_Msg

83: p_api_error => TRUE
84: );
85:
86: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
87: jtm_message_log_pkg.Log_Msg
88: ( v_object_id => p_record.notification_id
89: , v_object_name => g_object_name
90: , v_message => 'Leaving ' || g_object_name || '.APPLY_INSERT'
91: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 108: jtm_message_log_pkg.Log_Msg

104: x_return_status IN OUT NOCOPY VARCHAR2
105: ) IS
106: BEGIN
107: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
108: jtm_message_log_pkg.Log_Msg
109: ( v_object_id => p_record.notification_id
110: , v_object_name => g_object_name
111: , v_message => 'Entering ' || g_object_name || '.APPLY_UPDATE'
112: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 127: jtm_message_log_pkg.Log_Msg

123: );
124: END IF;
125:
126: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
127: jtm_message_log_pkg.Log_Msg
128: ( v_object_id => p_record.notification_id
129: , v_object_name => g_object_name
130: , v_message => 'Leaving ' || g_object_name || '.APPLY_UPDATE'
131: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 136: jtm_message_log_pkg.Log_Msg

132: END IF;
133:
134: EXCEPTION WHEN OTHERS THEN
135: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
136: jtm_message_log_pkg.Log_Msg
137: ( v_object_id => p_record.notification_id
138: , v_object_name => g_object_name
139: , v_message => 'Exception occurred in APPLY_UPDATE:' || fnd_global.local_chr(10) || sqlerrm
140: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

Line 150: jtm_message_log_pkg.Log_Msg

146: p_api_error => TRUE
147: );
148:
149: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
150: jtm_message_log_pkg.Log_Msg
151: ( v_object_id => p_record.notification_id
152: , v_object_name => g_object_name
153: , v_message => 'Leaving ' || g_object_name || '.APPLY_UPDATE'
154: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 175: jtm_message_log_pkg.Log_Msg

171: x_return_status := FND_API.G_RET_STS_SUCCESS;
172: FND_MSG_PUB.INITIALIZE;
173:
174: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
175: jtm_message_log_pkg.Log_Msg
176: ( v_object_id => p_record.notification_id
177: , v_object_name => g_object_name
178: , v_message => 'Entering ' || g_object_name || '.APPLY_RECORD'
179: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 183: jtm_message_log_pkg.Log_Msg

179: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
180: END IF;
181:
182: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
183: jtm_message_log_pkg.Log_Msg
184: ( v_object_id => p_record.notification_id
185: , v_object_name => g_object_name
186: , v_message => 'Processing NOTIFICATION_ID = ' || p_record.notification_id || fnd_global.local_chr(10) ||
187: 'DMLTYPE = ' || p_record.dmltype$$

Line 210: jtm_message_log_pkg.Log_Msg

206: );
207: ELSIF p_record.dmltype$$='D' THEN
208: -- Process delete; not supported for this entity
209: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
210: jtm_message_log_pkg.Log_Msg
211: ( v_object_id => p_record.notification_id
212: , v_object_name => g_object_name
213: , v_message => 'Delete is not supported for this entity'
214: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

Line 228: jtm_message_log_pkg.Log_Msg

224: x_return_status := FND_API.G_RET_STS_ERROR;
225: ELSE
226: -- invalid dml type
227: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
228: jtm_message_log_pkg.Log_Msg
229: ( v_object_id => p_record.notification_id
230: , v_object_name => g_object_name
231: , v_message => 'Invalid DML type: ' || p_record.dmltype$$
232: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

Line 246: jtm_message_log_pkg.Log_Msg

242: x_return_status := FND_API.G_RET_STS_ERROR;
243: END IF;
244:
245: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
246: jtm_message_log_pkg.Log_Msg
247: ( v_object_id => p_record.notification_id
248: , v_object_name => g_object_name
249: , v_message => 'Leaving ' || g_object_name || '.APPLY_RECORD'
250: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 255: jtm_message_log_pkg.Log_Msg

251: END IF;
252: EXCEPTION WHEN OTHERS THEN
253: /*** defer record when any process exception occurs ***/
254: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
255: jtm_message_log_pkg.Log_Msg
256: ( v_object_id => p_record.notification_id
257: , v_object_name => g_object_name
258: , v_message => 'Exception occurred in APPLY_RECORD:' || fnd_global.local_chr(10) || sqlerrm
259: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

Line 269: jtm_message_log_pkg.Log_Msg

265: p_api_error => TRUE
266: );
267:
268: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
269: jtm_message_log_pkg.Log_Msg
270: ( v_object_id => p_record.notification_id
271: , v_object_name => g_object_name
272: , v_message => 'Leaving ' || g_object_name || '.APPLY_RECORD'
273: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 300: jtm_message_log_pkg.Log_Msg

296: g_debug_level := p_debug_level;
297: x_return_status := FND_API.G_RET_STS_SUCCESS;
298:
299: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
300: jtm_message_log_pkg.Log_Msg
301: ( v_object_id => null
302: , v_object_name => g_object_name
303: , v_message => 'Entering ' || g_object_name || '.Apply_Client_Changes'
304: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 324: jtm_message_log_pkg.Log_Msg

320: /*** was record processed successfully? ***/
321: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN
322: /*** Yes -> delete record from inqueue ***/
323: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
324: jtm_message_log_pkg.Log_Msg
325: ( v_object_id => r_not_attr.notification_id
326: , v_object_name => g_object_name
327: , v_message => 'Record successfully processed, deleting from inqueue'
328: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 347: jtm_message_log_pkg.Log_Msg

343: /*** was delete successful? ***/
344: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
345: /*** no -> rollback ***/
346: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
347: jtm_message_log_pkg.Log_Msg
348: ( v_object_id => r_not_attr.notification_id
349: , v_object_name => g_object_name
350: , v_message => 'Deleting from inqueue failed, rolling back to savepoint'
351: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 360: jtm_message_log_pkg.Log_Msg

356:
357: IF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN
358: /*** Record was not processed successfully or delete failed -> defer and reject record ***/
359: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
360: jtm_message_log_pkg.Log_Msg
361: ( v_object_id => r_not_attr.notification_id
362: , v_object_name => g_object_name
363: , v_message => 'Record not processed successfully, deferring and rejecting record'
364: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 383: jtm_message_log_pkg.Log_Msg

379: /*** Was defer successful? ***/
380: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
381: /*** no -> rollback ***/
382: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
383: jtm_message_log_pkg.Log_Msg
384: ( v_object_id => r_not_attr.notification_id
385: , v_object_name => g_object_name
386: , v_message => 'Defer record failed, rolling back to savepoint'
387: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 396: jtm_message_log_pkg.Log_Msg

392:
393: END LOOP;
394:
395: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
396: jtm_message_log_pkg.Log_Msg
397: ( v_object_id => null
398: , v_object_name => g_object_name
399: , v_message => 'Leaving ' || g_object_name || '.Apply_Client_Changes'
400: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 406: jtm_message_log_pkg.Log_Msg

402:
403: EXCEPTION WHEN OTHERS THEN
404: /*** catch and log exceptions ***/
405: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
406: jtm_message_log_pkg.Log_Msg
407: ( v_object_id => null
408: , v_object_name => g_object_name
409: , v_message => 'Exception occurred in APPLY_CLIENT_CHANGES:' || fnd_global.local_chr(10) || sqlerrm
410: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);