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_NOTES_PKG dependencies on JTM_HOOK_UTIL_PKG

Line 30: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

26: l_note_id NUMBER;
27: l_msg_count NUMBER;
28: l_msg_data VARCHAR2(240);
29: BEGIN
30: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
31: jtm_message_log_pkg.Log_Msg
32: ( v_object_id => p_record.jtf_note_id
33: , v_object_name => g_object_name
34: , v_message => 'Entering ' || g_object_name || '.APPLY_INSERT'

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

31: jtm_message_log_pkg.Log_Msg
32: ( v_object_id => p_record.jtf_note_id
33: , v_object_name => g_object_name
34: , v_message => 'Entering ' || g_object_name || '.APPLY_INSERT'
35: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
36: END IF;
37:
38: -- Create a note
39: jtf_notes_pub.Create_note

Line 72: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

68: p_api_error => TRUE
69: );
70: END IF;
71:
72: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
73: jtm_message_log_pkg.Log_Msg
74: ( v_object_id => p_record.jtf_note_id
75: , v_object_name => g_object_name
76: , v_message => 'Leaving ' || g_object_name || '.APPLY_INSERT'

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

73: jtm_message_log_pkg.Log_Msg
74: ( v_object_id => p_record.jtf_note_id
75: , v_object_name => g_object_name
76: , v_message => 'Leaving ' || g_object_name || '.APPLY_INSERT'
77: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
78: END IF;
79:
80: EXCEPTION WHEN OTHERS THEN
81: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

Line 81: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

77: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
78: END IF;
79:
80: EXCEPTION WHEN OTHERS THEN
81: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
82: jtm_message_log_pkg.Log_Msg
83: ( v_object_id => p_record.jtf_note_id
84: , v_object_name => g_object_name
85: , v_message => 'Exception occurred in APPLY_INSERT:' || fnd_global.local_chr(10) || sqlerrm

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

82: jtm_message_log_pkg.Log_Msg
83: ( v_object_id => p_record.jtf_note_id
84: , v_object_name => g_object_name
85: , v_message => 'Exception occurred in APPLY_INSERT:' || fnd_global.local_chr(10) || sqlerrm
86: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
87: END IF;
88:
89: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_INSERT', sqlerrm);
90: p_error_msg := CSL_SERVICEL_WRAPPER_PKG.GET_ERROR_MESSAGE_TEXT

Line 95: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

91: (
92: p_api_error => TRUE
93: );
94:
95: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
96: jtm_message_log_pkg.Log_Msg
97: ( v_object_id => p_record.jtf_note_id
98: , v_object_name => g_object_name
99: , v_message => 'Leaving ' || g_object_name || '.APPLY_INSERT'

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

96: jtm_message_log_pkg.Log_Msg
97: ( v_object_id => p_record.jtf_note_id
98: , v_object_name => g_object_name
99: , v_message => 'Leaving ' || g_object_name || '.APPLY_INSERT'
100: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
101: END IF;
102:
103: x_return_status := FND_API.G_RET_STS_ERROR;
104: END APPLY_INSERT;

Line 118: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

114: ) IS
115: l_msg_count NUMBER;
116: l_msg_data VARCHAR2(240);
117: BEGIN
118: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
119: jtm_message_log_pkg.Log_Msg
120: ( v_object_id => p_record.jtf_note_id
121: , v_object_name => g_object_name
122: , v_message => 'Entering ' || g_object_name || '.APPLY_UPDATE'

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

119: jtm_message_log_pkg.Log_Msg
120: ( v_object_id => p_record.jtf_note_id
121: , v_object_name => g_object_name
122: , v_message => 'Entering ' || g_object_name || '.APPLY_UPDATE'
123: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
124: END IF;
125:
126: -- Update the note
127: jtf_notes_pub.Update_note

Line 153: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

149: p_api_error => TRUE
150: );
151: END IF;
152:
153: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
154: jtm_message_log_pkg.Log_Msg
155: ( v_object_id => p_record.jtf_note_id
156: , v_object_name => g_object_name
157: , v_message => 'Leaving ' || g_object_name || '.APPLY_UPDATE'

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

154: jtm_message_log_pkg.Log_Msg
155: ( v_object_id => p_record.jtf_note_id
156: , v_object_name => g_object_name
157: , v_message => 'Leaving ' || g_object_name || '.APPLY_UPDATE'
158: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
159: END IF;
160:
161: EXCEPTION WHEN OTHERS THEN
162: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

Line 162: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

158: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
159: END IF;
160:
161: EXCEPTION WHEN OTHERS THEN
162: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
163: jtm_message_log_pkg.Log_Msg
164: ( v_object_id => p_record.jtf_note_id
165: , v_object_name => g_object_name
166: , v_message => 'Exception occurred in APPLY_UPDATE:' || fnd_global.local_chr(10) || sqlerrm

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

163: jtm_message_log_pkg.Log_Msg
164: ( v_object_id => p_record.jtf_note_id
165: , v_object_name => g_object_name
166: , v_message => 'Exception occurred in APPLY_UPDATE:' || fnd_global.local_chr(10) || sqlerrm
167: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
168: END IF;
169:
170: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_UPDATE', sqlerrm);
171: p_error_msg := CSL_SERVICEL_WRAPPER_PKG.GET_ERROR_MESSAGE_TEXT

Line 176: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

172: (
173: p_api_error => TRUE
174: );
175:
176: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
177: jtm_message_log_pkg.Log_Msg
178: ( v_object_id => p_record.jtf_note_id
179: , v_object_name => g_object_name
180: , v_message => 'Leaving ' || g_object_name || '.APPLY_UPDATE'

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

177: jtm_message_log_pkg.Log_Msg
178: ( v_object_id => p_record.jtf_note_id
179: , v_object_name => g_object_name
180: , v_message => 'Leaving ' || g_object_name || '.APPLY_UPDATE'
181: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
182: END IF;
183:
184: x_return_status := FND_API.G_RET_STS_ERROR;
185: END APPLY_UPDATE;

Line 201: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

197: /*** initialize return status and message list ***/
198: x_return_status := FND_API.G_RET_STS_SUCCESS;
199: FND_MSG_PUB.INITIALIZE;
200:
201: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
202: jtm_message_log_pkg.Log_Msg
203: ( v_object_id => p_record.jtf_note_id
204: , v_object_name => g_object_name
205: , v_message => 'Entering ' || g_object_name || '.APPLY_RECORD'

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

202: jtm_message_log_pkg.Log_Msg
203: ( v_object_id => p_record.jtf_note_id
204: , v_object_name => g_object_name
205: , v_message => 'Entering ' || g_object_name || '.APPLY_RECORD'
206: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
207: END IF;
208:
209: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
210: jtm_message_log_pkg.Log_Msg

Line 209: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

205: , v_message => 'Entering ' || g_object_name || '.APPLY_RECORD'
206: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
207: END IF;
208:
209: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
210: jtm_message_log_pkg.Log_Msg
211: ( v_object_id => p_record.jtf_note_id
212: , v_object_name => g_object_name
213: , v_message => 'Processing JTF_NOTE_ID = ' || p_record.jtf_note_id || fnd_global.local_chr(10) ||

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

211: ( v_object_id => p_record.jtf_note_id
212: , v_object_name => g_object_name
213: , v_message => 'Processing JTF_NOTE_ID = ' || p_record.jtf_note_id || fnd_global.local_chr(10) ||
214: 'DMLTYPE = ' || p_record.dmltype$$
215: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
216: END IF;
217:
218: IF p_record.dmltype$$='I' THEN
219: -- Process insert

Line 236: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

232: x_return_status
233: );
234: ELSIF p_record.dmltype$$='D' THEN
235: -- Process delete; not supported for this entity
236: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
237: jtm_message_log_pkg.Log_Msg
238: ( v_object_id => p_record.jtf_note_id
239: , v_object_name => g_object_name
240: , v_message => 'Delete is not supported for this entity'

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

237: jtm_message_log_pkg.Log_Msg
238: ( v_object_id => p_record.jtf_note_id
239: , v_object_name => g_object_name
240: , v_message => 'Delete is not supported for this entity'
241: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
242: END IF;
243:
244: p_error_msg := CSL_SERVICEL_WRAPPER_PKG.GET_ERROR_MESSAGE_TEXT
245: (

Line 254: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

250:
251: x_return_status := FND_API.G_RET_STS_ERROR;
252: ELSE
253: -- invalid dml type
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.jtf_note_id
257: , v_object_name => g_object_name
258: , v_message => 'Invalid DML type: ' || p_record.dmltype$$

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.jtf_note_id
257: , v_object_name => g_object_name
258: , v_message => 'Invalid DML type: ' || p_record.dmltype$$
259: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
260: END IF;
261:
262: p_error_msg := CSL_SERVICEL_WRAPPER_PKG.GET_ERROR_MESSAGE_TEXT
263: (

Line 272: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

268:
269: x_return_status := FND_API.G_RET_STS_ERROR;
270: END IF;
271:
272: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
273: jtm_message_log_pkg.Log_Msg
274: ( v_object_id => p_record.jtf_note_id
275: , v_object_name => g_object_name
276: , v_message => 'Leaving ' || g_object_name || '.APPLY_RECORD'

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

273: jtm_message_log_pkg.Log_Msg
274: ( v_object_id => p_record.jtf_note_id
275: , v_object_name => g_object_name
276: , v_message => 'Leaving ' || g_object_name || '.APPLY_RECORD'
277: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
278: END IF;
279: EXCEPTION WHEN OTHERS THEN
280: /*** defer record when any process exception occurs ***/
281: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

Line 281: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

277: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
278: END IF;
279: EXCEPTION WHEN OTHERS THEN
280: /*** defer record when any process exception occurs ***/
281: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
282: jtm_message_log_pkg.Log_Msg
283: ( v_object_id => p_record.jtf_note_id
284: , v_object_name => g_object_name
285: , v_message => 'Exception occurred in APPLY_RECORD:' || fnd_global.local_chr(10) || sqlerrm

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

282: jtm_message_log_pkg.Log_Msg
283: ( v_object_id => p_record.jtf_note_id
284: , v_object_name => g_object_name
285: , v_message => 'Exception occurred in APPLY_RECORD:' || fnd_global.local_chr(10) || sqlerrm
286: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
287: END IF;
288:
289: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_RECORD', sqlerrm);
290: p_error_msg := CSL_SERVICEL_WRAPPER_PKG.GET_ERROR_MESSAGE_TEXT

Line 295: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

291: (
292: p_api_error => TRUE
293: );
294:
295: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
296: jtm_message_log_pkg.Log_Msg
297: ( v_object_id => p_record.jtf_note_id
298: , v_object_name => g_object_name
299: , v_message => 'Leaving ' || g_object_name || '.APPLY_RECORD'

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

296: jtm_message_log_pkg.Log_Msg
297: ( v_object_id => p_record.jtf_note_id
298: , v_object_name => g_object_name
299: , v_message => 'Leaving ' || g_object_name || '.APPLY_RECORD'
300: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
301: END IF;
302:
303: x_return_status := FND_API.G_RET_STS_ERROR;
304: END APPLY_RECORD;

Line 326: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

322: BEGIN
323: g_debug_level := p_debug_level;
324: x_return_status := FND_API.G_RET_STS_SUCCESS;
325:
326: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
327: jtm_message_log_pkg.Log_Msg
328: ( v_object_id => null
329: , v_object_name => g_object_name
330: , v_message => 'Entering ' || g_object_name || '.Apply_Client_Changes'

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

327: jtm_message_log_pkg.Log_Msg
328: ( v_object_id => null
329: , v_object_name => g_object_name
330: , v_message => 'Entering ' || g_object_name || '.Apply_Client_Changes'
331: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
332: END IF;
333:
334: /*** loop through jtf_notes_vl records in inqueue ***/
335: FOR r_note IN c_note( p_user_name, p_tranid) LOOP

Line 350: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

346:
347: /*** was record processed successfully? ***/
348: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN
349: /*** Yes -> delete record from inqueue ***/
350: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
351: jtm_message_log_pkg.Log_Msg
352: ( v_object_id => r_note.jtf_note_id
353: , v_object_name => g_object_name
354: , v_message => 'Record successfully processed, deleting from inqueue'

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

351: jtm_message_log_pkg.Log_Msg
352: ( v_object_id => r_note.jtf_note_id
353: , v_object_name => g_object_name
354: , v_message => 'Record successfully processed, deleting from inqueue'
355: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
356: END IF;
357:
358: CSL_SERVICEL_WRAPPER_PKG.DELETE_RECORD
359: (

Line 373: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

369:
370: /*** was delete successful? ***/
371: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
372: /*** no -> rollback ***/
373: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
374: jtm_message_log_pkg.Log_Msg
375: ( v_object_id => r_note.jtf_note_id
376: , v_object_name => g_object_name
377: , v_message => 'Deleting from inqueue failed, rolling back to savepoint'

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

374: jtm_message_log_pkg.Log_Msg
375: ( v_object_id => r_note.jtf_note_id
376: , v_object_name => g_object_name
377: , v_message => 'Deleting from inqueue failed, rolling back to savepoint'
378: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
379: END IF;
380: ROLLBACK TO save_rec;
381: END IF;
382: END IF;

Line 386: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

382: END IF;
383:
384: IF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN
385: /*** Record was not processed successfully or delete failed -> defer and reject record ***/
386: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
387: jtm_message_log_pkg.Log_Msg
388: ( v_object_id => r_note.jtf_note_id
389: , v_object_name => g_object_name
390: , v_message => 'Record not processed successfully, deferring and rejecting record'

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

387: jtm_message_log_pkg.Log_Msg
388: ( v_object_id => r_note.jtf_note_id
389: , v_object_name => g_object_name
390: , v_message => 'Record not processed successfully, deferring and rejecting record'
391: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
392: END IF;
393:
394: CSL_SERVICEL_WRAPPER_PKG.DEFER_RECORD
395: (

Line 409: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

405:
406: /*** Was defer successful? ***/
407: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
408: /*** no -> rollback ***/
409: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
410: jtm_message_log_pkg.Log_Msg
411: ( v_object_id => r_note.jtf_note_id
412: , v_object_name => g_object_name
413: , v_message => 'Defer record failed, rolling back to savepoint'

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

410: jtm_message_log_pkg.Log_Msg
411: ( v_object_id => r_note.jtf_note_id
412: , v_object_name => g_object_name
413: , v_message => 'Defer record failed, rolling back to savepoint'
414: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
415: END IF;
416: ROLLBACK TO save_rec;
417: END IF;
418: END IF;

Line 422: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

418: END IF;
419:
420: END LOOP;
421:
422: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
423: jtm_message_log_pkg.Log_Msg
424: ( v_object_id => null
425: , v_object_name => g_object_name
426: , v_message => 'Leaving ' || g_object_name || '.Apply_Client_Changes'

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

423: jtm_message_log_pkg.Log_Msg
424: ( v_object_id => null
425: , v_object_name => g_object_name
426: , v_message => 'Leaving ' || g_object_name || '.Apply_Client_Changes'
427: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
428: END IF;
429:
430: EXCEPTION WHEN OTHERS THEN
431: /*** catch and log exceptions ***/

Line 432: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

428: END IF;
429:
430: EXCEPTION WHEN OTHERS THEN
431: /*** catch and log exceptions ***/
432: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
433: jtm_message_log_pkg.Log_Msg
434: ( v_object_id => null
435: , v_object_name => g_object_name
436: , v_message => 'Exception occurred in APPLY_CLIENT_CHANGES:' || fnd_global.local_chr(10) || sqlerrm

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

433: jtm_message_log_pkg.Log_Msg
434: ( v_object_id => null
435: , v_object_name => g_object_name
436: , v_message => 'Exception occurred in APPLY_CLIENT_CHANGES:' || fnd_global.local_chr(10) || sqlerrm
437: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
438: END IF;
439: x_return_status := FND_API.G_RET_STS_ERROR;
440: END APPLY_CLIENT_CHANGES;
441: