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_HOOK_UTIL_PKG

Line 33: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

29: WHERE NOTIFICATION_ID = b_notification_id
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'

Line 38: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

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);
39: END IF;
40:
41: x_return_status := FND_API.G_RET_STS_SUCCESS;
42:

Line 63: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

59:
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'

Line 68: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

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);
69: END IF;
70:
71: EXCEPTION WHEN OTHERS THEN
72: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

Line 72: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

68: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
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

Line 77: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

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);
78: END IF;
79:
80: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_INSERT', sqlerrm);
81: p_error_msg := CSL_SERVICEL_WRAPPER_PKG.GET_ERROR_MESSAGE_TEXT

Line 86: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

82: (
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'

Line 91: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

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);
92: END IF;
93:
94: x_return_status := FND_API.G_RET_STS_ERROR;
95: END APPLY_INSERT;

Line 107: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

103: p_error_msg OUT NOCOPY VARCHAR2,
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'

Line 112: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

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);
113: END IF;
114:
115: /*** Updating is done by inserting the READ or DELETE _FLAG attribute ***/
116: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 126: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

122: p_api_error => TRUE
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'

Line 131: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

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);
132: END IF;
133:
134: EXCEPTION WHEN OTHERS THEN
135: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

Line 135: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

131: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
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

Line 140: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

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);
141: END IF;
142:
143: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_UPDATE', sqlerrm);
144: p_error_msg := CSL_SERVICEL_WRAPPER_PKG.GET_ERROR_MESSAGE_TEXT

Line 149: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

145: (
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'

Line 154: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

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);
155: END IF;
156:
157: x_return_status := FND_API.G_RET_STS_ERROR;
158: END APPLY_UPDATE;

Line 174: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

170: /*** initialize return status and message list ***/
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'

Line 179: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

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);
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

Line 182: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

178: , v_message => 'Entering ' || g_object_name || '.APPLY_RECORD'
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) ||

Line 188: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

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$$
188: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
189: END IF;
190:
191: IF p_record.dmltype$$='I' THEN
192: -- Process insert

Line 209: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

205: x_return_status
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'

Line 214: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

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);
215: END IF;
216:
217: p_error_msg := CSL_SERVICEL_WRAPPER_PKG.GET_ERROR_MESSAGE_TEXT
218: (

Line 227: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

223:
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$$

Line 232: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

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);
233: END IF;
234:
235: p_error_msg := CSL_SERVICEL_WRAPPER_PKG.GET_ERROR_MESSAGE_TEXT
236: (

Line 245: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

241:
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'

Line 250: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

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);
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

Line 254: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

250: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
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

Line 259: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

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);
260: END IF;
261:
262: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_RECORD', sqlerrm);
263: p_error_msg := CSL_SERVICEL_WRAPPER_PKG.GET_ERROR_MESSAGE_TEXT

Line 268: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

264: (
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'

Line 273: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

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);
274: END IF;
275:
276: x_return_status := FND_API.G_RET_STS_ERROR;
277: END APPLY_RECORD;

Line 299: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

295: BEGIN
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'

Line 304: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

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);
305: END IF;
306:
307: /*** loop through WF_NOTIFICATION_ATTR records in inqueue ***/
308: FOR r_not_attr IN c_not_attr( p_user_name, p_tranid) LOOP

Line 323: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

319:
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'

Line 328: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

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);
329: END IF;
330:
331: CSL_SERVICEL_WRAPPER_PKG.DELETE_RECORD
332: (

Line 346: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

342:
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'

Line 351: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

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);
352: END IF;
353: ROLLBACK TO save_rec;
354: END IF;
355: END IF;

Line 359: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

355: END IF;
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'

Line 364: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

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);
365: END IF;
366:
367: CSL_SERVICEL_WRAPPER_PKG.DEFER_RECORD
368: (

Line 382: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

378:
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'

Line 387: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

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);
388: END IF;
389: ROLLBACK TO save_rec;
390: END IF;
391: END IF;

Line 395: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

391: END IF;
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'

Line 400: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

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);
401: END IF;
402:
403: EXCEPTION WHEN OTHERS THEN
404: /*** catch and log exceptions ***/

Line 405: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

401: END IF;
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

Line 410: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

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);
411: END IF;
412: x_return_status := FND_API.G_RET_STS_ERROR;
413: END APPLY_CLIENT_CHANGES;
414: