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

Line 92: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

88: BEGIN
89:
90: l_date := SYSDATE;
91:
92: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
93: jtm_message_log_pkg.Log_Msg
94: ( v_object_id => r_csf_debrief_headers.debrief_header_id -- put PK column here
95: , v_object_name => g_object_name
96: , v_message => 'Entering ' || g_object_name || '.CREATE_DEBRIEF_HEADER'

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

93: jtm_message_log_pkg.Log_Msg
94: ( v_object_id => r_csf_debrief_headers.debrief_header_id -- put PK column here
95: , v_object_name => g_object_name
96: , v_message => 'Entering ' || g_object_name || '.CREATE_DEBRIEF_HEADER'
97: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
98: END IF;
99:
100: -- Open cursor to retrieve debrief header for debrief line
101: OPEN c_csf_debrief_headers (p_debrief_header_id);

Line 152: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

148: p_api_error => TRUE
149: );
150: END IF;
151:
152: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
153: jtm_message_log_pkg.Log_Msg
154: ( v_object_id => r_csf_debrief_headers.debrief_header_id -- put PK column here
155: , v_object_name => g_object_name
156: , v_message => 'Leaving ' || g_object_name || '.CREATE_DEBRIEF_HEADER'

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

153: jtm_message_log_pkg.Log_Msg
154: ( v_object_id => r_csf_debrief_headers.debrief_header_id -- put PK column here
155: , v_object_name => g_object_name
156: , v_message => 'Leaving ' || g_object_name || '.CREATE_DEBRIEF_HEADER'
157: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
158: END IF;
159:
160: EXCEPTION WHEN OTHERS THEN
161: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_UPDATE', sqlerrm);

Line 167: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

163: (
164: p_api_error => TRUE
165: );
166:
167: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
168: jtm_message_log_pkg.Log_Msg
169: ( v_object_id => r_csf_debrief_headers.debrief_header_id -- put PK column here
170: , v_object_name => g_object_name
171: , v_message => 'Leaving ' || g_object_name || '.CREATE_DEBRIEF_HEADER : ' || p_error_msg

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

168: jtm_message_log_pkg.Log_Msg
169: ( v_object_id => r_csf_debrief_headers.debrief_header_id -- put PK column here
170: , v_object_name => g_object_name
171: , v_message => 'Leaving ' || g_object_name || '.CREATE_DEBRIEF_HEADER : ' || p_error_msg
172: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
173: END IF;
174:
175: x_return_status := FND_API.G_RET_STS_ERROR;
176:

Line 206: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

202: r_debrief_header_id c_debrief_header_id%ROWTYPE;
203: l_header_exists BOOLEAN;
204: BEGIN
205:
206: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
207: jtm_message_log_pkg.Log_Msg
208: ( v_object_id => null
209: , v_object_name => g_object_name
210: , v_message => 'Entering ' || g_object_name || '.Debrief_Header_Exists'

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

207: jtm_message_log_pkg.Log_Msg
208: ( v_object_id => null
209: , v_object_name => g_object_name
210: , v_message => 'Entering ' || g_object_name || '.Debrief_Header_Exists'
211: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
212: END IF;
213:
214: -- Check if a header already exists in the backend or not.
215: l_header_exists := FALSE;

Line 224: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

220: IF c_debrief_header_id%FOUND THEN
221: l_header_exists := TRUE;
222: p_debrief_header_id := r_debrief_header_id.debrief_header_id;
223: CLOSE c_debrief_header_id;
224: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
225: jtm_message_log_pkg.Log_Msg
226: ( v_object_id => null
227: , v_object_name => g_object_name
228: , v_message => 'Leaving ' || g_object_name || '.Debrief_Header_Exists'

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

225: jtm_message_log_pkg.Log_Msg
226: ( v_object_id => null
227: , v_object_name => g_object_name
228: , v_message => 'Leaving ' || g_object_name || '.Debrief_Header_Exists'
229: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
230: END IF;
231: return l_header_exists;
232: END IF;
233: CLOSE c_debrief_header_id;

Line 243: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

239: l_header_exists := TRUE;
240: END IF;
241: CLOSE c_debrief_header_exists;
242:
243: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
244: jtm_message_log_pkg.Log_Msg
245: ( v_object_id => null
246: , v_object_name => g_object_name
247: , v_message => 'Leaving ' || g_object_name || '.Debrief_Header_Exists'

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

244: jtm_message_log_pkg.Log_Msg
245: ( v_object_id => null
246: , v_object_name => g_object_name
247: , v_message => 'Leaving ' || g_object_name || '.Debrief_Header_Exists'
248: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
249: END IF;
250:
251: RETURN l_header_exists;
252: END DEBRIEF_HEADER_EXISTS;

Line 313: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

309: l_task_assignment_id NUMBER;
310: l_seqno NUMBER;
311:
312: BEGIN
313: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
314: jtm_message_log_pkg.Log_Msg
315: ( v_object_id => p_header_id
316: , v_object_name => g_object_name
317: , v_message => 'Entering ' || g_object_name ||

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

315: ( v_object_id => p_header_id
316: , v_object_name => g_object_name
317: , v_message => 'Entering ' || g_object_name ||
318: '.APPLY_INSERT_HEADER'
319: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
320: END IF;
321:
322: /***
323: First check if header already exists in the backend or not. If so

Line 362: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

358: -- Delete debrief header record from debrief header inqueue.
359: /*** was record processed successfully? ***/
360: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
361: /*** Yes -> delete record from inqueue ***/
362: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
363: jtm_message_log_pkg.Log_Msg
364: ( v_object_id => l_header_id -- put PK column here
365: , v_object_name => g_object_name
366: , v_message => 'Record successfully processed, deleting from

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

364: ( v_object_id => l_header_id -- put PK column here
365: , v_object_name => g_object_name
366: , v_message => 'Record successfully processed, deleting from
367: inqueue'
368: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
369: END IF;
370:
371: CSL_SERVICEL_WRAPPER_PKG.DELETE_RECORD
372: (

Line 386: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

382:
383: /*** was delete successful? ***/
384: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
385: /*** no -> rollback ***/
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 => p_header_id --p_record.debrief_header_id
389: , v_object_name => g_object_name
390: , v_message => 'Deleting from inqueue failed, '||

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

388: ( v_object_id => p_header_id --p_record.debrief_header_id
389: , v_object_name => g_object_name
390: , v_message => 'Deleting from inqueue failed, '||
391: 'rolling back to savepoint'
392: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
393: END IF;
394: ROLLBACK to save_rec;
395: END IF;
396: ELSE

Line 399: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

395: END IF;
396: ELSE
397: /*** Record was not processed successfully or delete failed
398: -> defer and reject record ***/
399: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
400: jtm_message_log_pkg.Log_Msg
401: ( v_object_id => p_header_id --p_record.debrief_header_id
402: , v_object_name => g_object_name
403: , v_message => 'Record not processed successfully, '||

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

401: ( v_object_id => p_header_id --p_record.debrief_header_id
402: , v_object_name => g_object_name
403: , v_message => 'Record not processed successfully, '||
404: 'deferring and rejecting record'
405: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
406: END IF;
407:
408: CSL_SERVICEL_WRAPPER_PKG.DEFER_RECORD
409: (

Line 423: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

419:
420: /*** Was defer successful? ***/
421: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
422: /*** no -> rollback ***/
423: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
424: jtm_message_log_pkg.Log_Msg
425: ( v_object_id => p_header_id --p_record.debrief_header_id
426: , v_object_name => g_object_name
427: , v_message => 'Defer record failed, rolling back to savepoint'

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

424: jtm_message_log_pkg.Log_Msg
425: ( v_object_id => p_header_id --p_record.debrief_header_id
426: , v_object_name => g_object_name
427: , v_message => 'Defer record failed, rolling back to savepoint'
428: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
429: END IF;
430: ROLLBACK to save_rec;
431: END IF;
432: END IF;

Line 439: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

435: IF p_header_id <> l_header_id THEN
436:
437: /*** Record was not processed successfully or delete failed ->
438: defer and reject record ***/
439: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
440: jtm_message_log_pkg.Log_Msg
441: ( v_object_id => p_header_id --p_record.debrief_header_id
442: , v_object_name => g_object_name
443: , v_message => 'Record not processed successfully, '||

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

441: ( v_object_id => p_header_id --p_record.debrief_header_id
442: , v_object_name => g_object_name
443: , v_message => 'Record not processed successfully, '||
444: 'deferring and rejecting record'
445: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
446: END IF;
447: p_header_id := l_header_id;
448: -- If true the header is created on the backend already.
449: -- The client header needs to be removed

Line 463: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

459: );
460: /*** Was defer successful? ***/
461: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
462: /*** no -> rollback ***/
463: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
464: jtm_message_log_pkg.Log_Msg
465: ( v_object_id => p_header_id --p_record.debrief_header_id
466: , v_object_name => g_object_name
467: , v_message => 'Defer record failed, rolling back to savepoint'

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

464: jtm_message_log_pkg.Log_Msg
465: ( v_object_id => p_header_id --p_record.debrief_header_id
466: , v_object_name => g_object_name
467: , v_message => 'Defer record failed, rolling back to savepoint'
468: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
469: END IF;
470: ROLLBACK to save_rec;
471: END IF;
472: END IF;

Line 474: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

470: ROLLBACK to save_rec;
471: END IF;
472: END IF;
473:
474: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
475: jtm_message_log_pkg.Log_Msg
476: ( v_object_id => p_header_id -- p_record.DEBRIEF_LINE_ID
477: , v_object_name => g_object_name
478: , v_message => 'Leaving ' || g_object_name ||

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

476: ( v_object_id => p_header_id -- p_record.DEBRIEF_LINE_ID
477: , v_object_name => g_object_name
478: , v_message => 'Leaving ' || g_object_name ||
479: '.APPLY_INSERT_HEADER'
480: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
481: END IF;
482:
483: EXCEPTION WHEN OTHERS THEN
484: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

Line 484: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

480: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
481: END IF;
482:
483: EXCEPTION WHEN OTHERS THEN
484: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
485: jtm_message_log_pkg.Log_Msg
486: ( v_object_id => p_header_id --p_record.DEBRIEF_LINE_ID
487: , v_object_name => g_object_name
488: , v_message => 'Exception occurred in APPLY_INSERT_HEADER:' ||

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

486: ( v_object_id => p_header_id --p_record.DEBRIEF_LINE_ID
487: , v_object_name => g_object_name
488: , v_message => 'Exception occurred in APPLY_INSERT_HEADER:' ||
489: FND_GLOBAL.LOCAL_CHR(10) || sqlerrm
490: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
491: END IF;
492:
493: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_INSERT_HEADER', sqlerrm);
494: p_error_msg := CSL_SERVICEL_WRAPPER_PKG.GET_ERROR_MESSAGE_TEXT

Line 499: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

495: (
496: p_api_error => TRUE
497: );
498:
499: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
500: jtm_message_log_pkg.Log_Msg
501: ( v_object_id => p_header_id -- p_record.DEBRIEF_LINE_ID
502: , v_object_name => g_object_name
503: , v_message => 'Leaving ' || g_object_name ||

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

501: ( v_object_id => p_header_id -- p_record.DEBRIEF_LINE_ID
502: , v_object_name => g_object_name
503: , v_message => 'Leaving ' || g_object_name ||
504: '.APPLY_INSERT_HEADER'
505: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
506: END IF;
507:
508: x_return_status := FND_API.G_RET_STS_ERROR;
509: END APPLY_INSERT_HEADER;

Line 630: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

626:
627: BEGIN
628:
629: l_date := SYSDATE;
630: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
631: jtm_message_log_pkg.Log_Msg
632: ( v_object_id => p_record.DEBRIEF_LINE_ID
633: , v_object_name => g_object_name
634: , v_message => 'Entering ' || g_object_name || '.APPLY_INSERT_LINE'

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

631: jtm_message_log_pkg.Log_Msg
632: ( v_object_id => p_record.DEBRIEF_LINE_ID
633: , v_object_name => g_object_name
634: , v_message => 'Entering ' || g_object_name || '.APPLY_INSERT_LINE'
635: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
636: END IF;
637:
638: -- Check if header_id is given or not from APPLY_INSERT_HEADER
639: IF p_header_id IS NULL THEN

Line 657: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

653: g_header_id := l_header_id;
654:
655: END IF;
656:
657: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
658: jtm_message_log_pkg.Log_Msg
659: ( v_object_id => p_record.DEBRIEF_LINE_ID
660: , v_object_name => g_object_name
661: , v_message => 'l_header_id = ' || l_header_id

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

658: jtm_message_log_pkg.Log_Msg
659: ( v_object_id => p_record.DEBRIEF_LINE_ID
660: , v_object_name => g_object_name
661: , v_message => 'l_header_id = ' || l_header_id
662: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
663: END IF;
664:
665: --Bug 3850061
666: /*

Line 836: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

832: p_api_error => TRUE
833: );
834: END IF;
835:
836: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
837: jtm_message_log_pkg.Log_Msg
838: ( v_object_id => p_record.DEBRIEF_LINE_ID -- put PK column here
839: , v_object_name => g_object_name
840: , v_message => 'Leaving ' || g_object_name || '.APPLY_INSERT_LINE'

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

837: jtm_message_log_pkg.Log_Msg
838: ( v_object_id => p_record.DEBRIEF_LINE_ID -- put PK column here
839: , v_object_name => g_object_name
840: , v_message => 'Leaving ' || g_object_name || '.APPLY_INSERT_LINE'
841: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
842: END IF;
843:
844: EXCEPTION WHEN OTHERS THEN
845:

Line 853: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

849: CLOSE c_debrief_header;
850: END IF;
851: */
852:
853: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
854: jtm_message_log_pkg.Log_Msg
855: ( v_object_id => p_record.DEBRIEF_LINE_ID -- put PK column here
856: , v_object_name => g_object_name
857: , v_message => 'Exception occurred in APPLY_INSERT:' || FND_GLOBAL.LOCAL_CHR(10) || sqlerrm

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

854: jtm_message_log_pkg.Log_Msg
855: ( v_object_id => p_record.DEBRIEF_LINE_ID -- put PK column here
856: , v_object_name => g_object_name
857: , v_message => 'Exception occurred in APPLY_INSERT:' || FND_GLOBAL.LOCAL_CHR(10) || sqlerrm
858: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
859: END IF;
860:
861: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_INSERT_LINE', sqlerrm);
862: p_error_msg := CSL_SERVICEL_WRAPPER_PKG.GET_ERROR_MESSAGE_TEXT

Line 867: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

863: (
864: p_api_error => TRUE
865: );
866:
867: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
868: jtm_message_log_pkg.Log_Msg
869: ( v_object_id => p_record.DEBRIEF_LINE_ID -- put PK column here
870: , v_object_name => g_object_name
871: , v_message => 'Leaving ' || g_object_name || '.APPLY_INSERT_LINE'

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

868: jtm_message_log_pkg.Log_Msg
869: ( v_object_id => p_record.DEBRIEF_LINE_ID -- put PK column here
870: , v_object_name => g_object_name
871: , v_message => 'Leaving ' || g_object_name || '.APPLY_INSERT_LINE'
872: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
873: END IF;
874:
875: x_return_status := FND_API.G_RET_STS_ERROR;
876: END APPLY_INSERT_LINE;

Line 936: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

932:
933: BEGIN
934: l_date := SYSDATE;
935:
936: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
937: jtm_message_log_pkg.Log_Msg
938: ( v_object_id => p_header_id -- p_record.DEBRIEF_LINE_ID
939: , v_object_name => g_object_name
940: , v_message => 'Entering ' || g_object_name ||

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

938: ( v_object_id => p_header_id -- p_record.DEBRIEF_LINE_ID
939: , v_object_name => g_object_name
940: , v_message => 'Entering ' || g_object_name ||
941: '.APPLY_UPDATE_HEADER'
942: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
943: END IF;
944:
945:
946: /***

Line 1024: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

1020:
1021: /*** was record processed successfully? ***/
1022: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1023: /*** Yes -> delete record from inqueue ***/
1024: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
1025: jtm_message_log_pkg.Log_Msg
1026: ( v_object_id => l_header_id -- put PK column here
1027: , v_object_name => g_object_name
1028: , v_message => 'Record successfully processed, '||

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

1026: ( v_object_id => l_header_id -- put PK column here
1027: , v_object_name => g_object_name
1028: , v_message => 'Record successfully processed, '||
1029: ' deleting from inqueue'
1030: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
1031: END IF;
1032:
1033: CSL_SERVICEL_WRAPPER_PKG.DELETE_RECORD
1034: (

Line 1048: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

1044:
1045: /*** was delete successful? ***/
1046: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1047: /*** no -> rollback ***/
1048: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
1049: jtm_message_log_pkg.Log_Msg
1050: ( v_object_id => p_header_id --p_record.debrief_header_id
1051: , v_object_name => g_object_name
1052: , v_message => 'Deleting from inqueue failed, rolling '||

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

1050: ( v_object_id => p_header_id --p_record.debrief_header_id
1051: , v_object_name => g_object_name
1052: , v_message => 'Deleting from inqueue failed, rolling '||
1053: ' back to savepoint'
1054: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
1055: END IF;
1056: ROLLBACK to save_rec;
1057: END IF; -- end if delete failed
1058:

Line 1063: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

1059: ELSE -- else when record was not processed successfully
1060:
1061: /*** Record was not processed successfully or delete failed
1062: -> defer and reject record ***/
1063: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
1064:
1065: jtm_message_log_pkg.Log_Msg
1066: ( v_object_id => p_header_id --p_record.debrief_header_id
1067: , v_object_name => g_object_name

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

1066: ( v_object_id => p_header_id --p_record.debrief_header_id
1067: , v_object_name => g_object_name
1068: , v_message => 'Record not processed successfully, '||
1069: 'deferring and rejecting record'
1070: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
1071: END IF;
1072:
1073: CSL_SERVICEL_WRAPPER_PKG.DEFER_RECORD
1074: (

Line 1088: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

1084:
1085: /*** Was defer successful? ***/
1086: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1087: /*** no -> rollback ***/
1088: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
1089: jtm_message_log_pkg.Log_Msg
1090: ( v_object_id => p_header_id --p_record.debrief_header_id
1091: , v_object_name => g_object_name
1092: , v_message => 'Defer record failed,rolling back to savepoint'

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

1089: jtm_message_log_pkg.Log_Msg
1090: ( v_object_id => p_header_id --p_record.debrief_header_id
1091: , v_object_name => g_object_name
1092: , v_message => 'Defer record failed,rolling back to savepoint'
1093: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
1094: ROLLBACK to save_rec;
1095: END IF;
1096: END IF; -- end of if defer failed.
1097: END IF; -- end of checking was record processed successfully

Line 1100: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

1096: END IF; -- end of if defer failed.
1097: END IF; -- end of checking was record processed successfully
1098: END IF; -- end of else DML_TYPE = 'U'
1099:
1100: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1101: jtm_message_log_pkg.Log_Msg
1102: ( v_object_id => p_header_id -- p_record.DEBRIEF_LINE_ID
1103: , v_object_name => g_object_name
1104: , v_message => 'Leaving ' || g_object_name ||

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

1102: ( v_object_id => p_header_id -- p_record.DEBRIEF_LINE_ID
1103: , v_object_name => g_object_name
1104: , v_message => 'Leaving ' || g_object_name ||
1105: '.APPLY_UPDATE_HEADER'
1106: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
1107: END IF;
1108:
1109: EXCEPTION WHEN OTHERS THEN
1110:

Line 1111: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

1107: END IF;
1108:
1109: EXCEPTION WHEN OTHERS THEN
1110:
1111: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
1112: jtm_message_log_pkg.Log_Msg
1113: ( v_object_id => p_header_id --p_record.DEBRIEF_LINE_ID
1114: , v_object_name => g_object_name
1115: , v_message => 'Exception occurred in APPLY_UPDATE_HEADER:' ||

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

1113: ( v_object_id => p_header_id --p_record.DEBRIEF_LINE_ID
1114: , v_object_name => g_object_name
1115: , v_message => 'Exception occurred in APPLY_UPDATE_HEADER:' ||
1116: FND_GLOBAL.LOCAL_CHR(10) || sqlerrm
1117: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
1118: END IF;
1119:
1120: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_UPDATE_HEADER', sqlerrm);
1121: p_error_msg := CSL_SERVICEL_WRAPPER_PKG.GET_ERROR_MESSAGE_TEXT

Line 1126: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

1122: (
1123: p_api_error => TRUE
1124: );
1125:
1126: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1127: jtm_message_log_pkg.Log_Msg
1128: ( v_object_id => p_header_id -- p_record.DEBRIEF_LINE_ID
1129: , v_object_name => g_object_name
1130: , v_message => 'Leaving ' || g_object_name ||

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

1128: ( v_object_id => p_header_id -- p_record.DEBRIEF_LINE_ID
1129: , v_object_name => g_object_name
1130: , v_message => 'Leaving ' || g_object_name ||
1131: '.APPLY_UPDATE_HEADER'
1132: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
1133: END IF;
1134:
1135: x_return_status := FND_API.G_RET_STS_ERROR;
1136: END APPLY_UPDATE_HEADER;

Line 1153: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

1149: p_error_msg OUT NOCOPY VARCHAR2,
1150: x_return_status IN OUT NOCOPY VARCHAR2
1151: ) IS
1152: BEGIN
1153: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1154: jtm_message_log_pkg.Log_Msg
1155: ( v_object_id => p_record.DEBRIEF_LINE_ID -- put PK column here
1156: , v_object_name => g_object_name
1157: , v_message => 'Entering ' || g_object_name || '.APPLY_UPDATE'

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

1154: jtm_message_log_pkg.Log_Msg
1155: ( v_object_id => p_record.DEBRIEF_LINE_ID -- put PK column here
1156: , v_object_name => g_object_name
1157: , v_message => 'Entering ' || g_object_name || '.APPLY_UPDATE'
1158: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
1159: END IF;
1160:
1161: -- For Debrief no update is possible, so return success
1162: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1172: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

1168: p_api_error => TRUE
1169: );
1170: END IF;
1171:
1172: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1173: jtm_message_log_pkg.Log_Msg
1174: ( v_object_id => p_record.DEBRIEF_LINE_ID -- put PK column here
1175: , v_object_name => g_object_name
1176: , v_message => 'Leaving ' || g_object_name || '.APPLY_UPDATE'

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

1173: jtm_message_log_pkg.Log_Msg
1174: ( v_object_id => p_record.DEBRIEF_LINE_ID -- put PK column here
1175: , v_object_name => g_object_name
1176: , v_message => 'Leaving ' || g_object_name || '.APPLY_UPDATE'
1177: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
1178: END IF;
1179:
1180: EXCEPTION WHEN OTHERS THEN
1181: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

Line 1181: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

1177: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
1178: END IF;
1179:
1180: EXCEPTION WHEN OTHERS THEN
1181: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
1182: jtm_message_log_pkg.Log_Msg
1183: ( v_object_id => p_record.DEBRIEF_LINE_ID -- put PK column here
1184: , v_object_name => g_object_name
1185: , v_message => 'Exception occurred in APPLY_UPDATE:' || FND_GLOBAL.LOCAL_CHR(10) || sqlerrm

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

1182: jtm_message_log_pkg.Log_Msg
1183: ( v_object_id => p_record.DEBRIEF_LINE_ID -- put PK column here
1184: , v_object_name => g_object_name
1185: , v_message => 'Exception occurred in APPLY_UPDATE:' || FND_GLOBAL.LOCAL_CHR(10) || sqlerrm
1186: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
1187: END IF;
1188:
1189: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_UPDATE', sqlerrm);
1190: p_error_msg := CSL_SERVICEL_WRAPPER_PKG.GET_ERROR_MESSAGE_TEXT

Line 1195: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

1191: (
1192: p_api_error => TRUE
1193: );
1194:
1195: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1196: jtm_message_log_pkg.Log_Msg
1197: ( v_object_id => p_record.DEBRIEF_LINE_ID -- put PK column here
1198: , v_object_name => g_object_name
1199: , v_message => 'Leaving ' || g_object_name || '.APPLY_UPDATE'

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

1196: jtm_message_log_pkg.Log_Msg
1197: ( v_object_id => p_record.DEBRIEF_LINE_ID -- put PK column here
1198: , v_object_name => g_object_name
1199: , v_message => 'Leaving ' || g_object_name || '.APPLY_UPDATE'
1200: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
1201: END IF;
1202:
1203: x_return_status := FND_API.G_RET_STS_ERROR;
1204: END APPLY_UPDATE;

Line 1222: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

1218: l_header_id NUMBER := 0;
1219: j NUMBER := 0;
1220: BEGIN
1221:
1222: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1223: jtm_message_log_pkg.Log_Msg
1224: ( v_object_id => null
1225: , v_object_name => g_object_name
1226: , v_message => 'Entering ' || g_object_name || '.Process_Debrief'

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

1223: jtm_message_log_pkg.Log_Msg
1224: ( v_object_id => null
1225: , v_object_name => g_object_name
1226: , v_message => 'Entering ' || g_object_name || '.Process_Debrief'
1227: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
1228: END IF;
1229:
1230: /***
1231: Loop through cursor with all debrief line records in debrief line

Line 1264: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

1260:
1261: /*** was record processed successfully? ***/
1262: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1263: /*** Yes -> delete record from inqueue ***/
1264: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
1265: jtm_message_log_pkg.Log_Msg
1266: ( v_object_id => r_debrief.DEBRIEF_LINE_ID -- put PK column here
1267: , v_object_name => g_object_name
1268: , v_message => 'Line record successfully processed, deleting from inqueue'

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

1265: jtm_message_log_pkg.Log_Msg
1266: ( v_object_id => r_debrief.DEBRIEF_LINE_ID -- put PK column here
1267: , v_object_name => g_object_name
1268: , v_message => 'Line record successfully processed, deleting from inqueue'
1269: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
1270: END IF;
1271:
1272: CSL_SERVICEL_WRAPPER_PKG.DELETE_RECORD
1273: (

Line 1287: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

1283:
1284: /*** was delete successful? ***/
1285: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1286: /*** no -> rollback ***/
1287: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
1288: jtm_message_log_pkg.Log_Msg
1289: ( v_object_id => r_debrief.DEBRIEF_LINE_ID -- put PK column here
1290: , v_object_name => g_object_name
1291: , v_message => 'Deleting line record from inqueue failed, rolling back to savepoint'

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

1288: jtm_message_log_pkg.Log_Msg
1289: ( v_object_id => r_debrief.DEBRIEF_LINE_ID -- put PK column here
1290: , v_object_name => g_object_name
1291: , v_message => 'Deleting line record from inqueue failed, rolling back to savepoint'
1292: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
1293: END IF;
1294: ROLLBACK TO save_rec;
1295: END IF;
1296: END IF;

Line 1301: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

1297:
1298: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1299: /*** Record was not processed successfully or delete failed
1300: -> defer and reject record ***/
1301: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
1302: jtm_message_log_pkg.Log_Msg
1303: ( v_object_id => r_debrief.DEBRIEF_LINE_ID -- put PK column here
1304: , v_object_name => g_object_name
1305: , v_message => 'Line record not processed successfully, deferring and rejecting record'

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

1302: jtm_message_log_pkg.Log_Msg
1303: ( v_object_id => r_debrief.DEBRIEF_LINE_ID -- put PK column here
1304: , v_object_name => g_object_name
1305: , v_message => 'Line record not processed successfully, deferring and rejecting record'
1306: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
1307: END IF;
1308:
1309: CSL_SERVICEL_WRAPPER_PKG.DEFER_RECORD
1310: (

Line 1324: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

1320:
1321: /*** Was defer successful? ***/
1322: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1323: /*** no -> rollback ***/
1324: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
1325: jtm_message_log_pkg.Log_Msg
1326: ( v_object_id => r_debrief.DEBRIEF_LINE_ID -- put PK column here
1327: , v_object_name => g_object_name
1328: , v_message => 'Defer line record failed, rolling back to savepoint'

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

1325: jtm_message_log_pkg.Log_Msg
1326: ( v_object_id => r_debrief.DEBRIEF_LINE_ID -- put PK column here
1327: , v_object_name => g_object_name
1328: , v_message => 'Defer line record failed, rolling back to savepoint'
1329: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
1330: END IF;
1331:
1332: g_deferred_line_id_tbl(j) := r_debrief.DEBRIEF_LINE_ID;
1333: j := j+1;

Line 1356: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

1352: IF ( l_header_id <> 0 ) THEN
1353: call_charges ( l_header_id );
1354: END IF;
1355:
1356: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1357: jtm_message_log_pkg.Log_Msg
1358: ( v_object_id => null
1359: , v_object_name => g_object_name
1360: , v_message => 'Leaving ' || g_object_name || '.Process_Debrief'

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

1357: jtm_message_log_pkg.Log_Msg
1358: ( v_object_id => null
1359: , v_object_name => g_object_name
1360: , v_message => 'Leaving ' || g_object_name || '.Process_Debrief'
1361: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
1362: END IF;
1363:
1364: EXCEPTION WHEN OTHERS THEN
1365: /*** catch and log exceptions ***/

Line 1366: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

1362: END IF;
1363:
1364: EXCEPTION WHEN OTHERS THEN
1365: /*** catch and log exceptions ***/
1366: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
1367: jtm_message_log_pkg.Log_Msg
1368: ( v_object_id => null
1369: , v_object_name => g_object_name
1370: , v_message => 'Exception occurred in PROCESS_DEBRIEF:' || FND_GLOBAL.LOCAL_CHR(10) || sqlerrm

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

1367: jtm_message_log_pkg.Log_Msg
1368: ( v_object_id => null
1369: , v_object_name => g_object_name
1370: , v_message => 'Exception occurred in PROCESS_DEBRIEF:' || FND_GLOBAL.LOCAL_CHR(10) || sqlerrm
1371: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
1372: END IF;
1373: x_return_status := FND_API.G_RET_STS_ERROR;
1374:
1375: END PROCESS_DEBRIEF;

Line 1392: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

1388: l_error_msg VARCHAR2(4000);
1389: l_header_id NUMBER := 0 ;
1390: BEGIN
1391:
1392: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1393: jtm_message_log_pkg.Log_Msg
1394: ( v_object_id => null
1395: , v_object_name => g_object_name
1396: , v_message => 'Entering ' || g_object_name || '.Process_Debrief_No_Headers'

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

1393: jtm_message_log_pkg.Log_Msg
1394: ( v_object_id => null
1395: , v_object_name => g_object_name
1396: , v_message => 'Entering ' || g_object_name || '.Process_Debrief_No_Headers'
1397: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
1398: END IF;
1399:
1400: /***
1401: Loop through cursor with all debrief line records in debrief line inqueue,

Line 1443: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

1439:
1440: /*** was record processed successfully? ***/
1441: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1442: /*** Yes -> delete record from inqueue ***/
1443: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
1444: jtm_message_log_pkg.Log_Msg
1445: ( v_object_id => r_debrief.DEBRIEF_LINE_ID -- put PK column here
1446: , v_object_name => g_object_name
1447: , v_message => 'Record successfully processed, deleting from inqueue'

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

1444: jtm_message_log_pkg.Log_Msg
1445: ( v_object_id => r_debrief.DEBRIEF_LINE_ID -- put PK column here
1446: , v_object_name => g_object_name
1447: , v_message => 'Record successfully processed, deleting from inqueue'
1448: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
1449: END IF;
1450:
1451: CSL_SERVICEL_WRAPPER_PKG.DELETE_RECORD
1452: (

Line 1466: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

1462:
1463: /*** was delete successful? ***/
1464: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1465: /*** no -> rollback ***/
1466: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
1467: jtm_message_log_pkg.Log_Msg
1468: ( v_object_id => r_debrief.DEBRIEF_LINE_ID -- put PK column here
1469: , v_object_name => g_object_name
1470: , v_message => 'Deleting from inqueue failed, rolling back to savepoint'

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

1467: jtm_message_log_pkg.Log_Msg
1468: ( v_object_id => r_debrief.DEBRIEF_LINE_ID -- put PK column here
1469: , v_object_name => g_object_name
1470: , v_message => 'Deleting from inqueue failed, rolling back to savepoint'
1471: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
1472: END IF;
1473: ROLLBACK TO save_rec;
1474: END IF;
1475: END IF;

Line 1482: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

1478: /*** Record was not processed successfully or delete failed -> defer and reject record ***/
1479: --Since the record was not processed successfully, rollback to the point before
1480: --calling APPLY_INSERT_LINE
1481: ROLLBACK to save_rec;
1482: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
1483: jtm_message_log_pkg.Log_Msg
1484: ( v_object_id => r_debrief.DEBRIEF_LINE_ID -- put PK column here
1485: , v_object_name => g_object_name
1486: , v_message => 'Record not processed successfully, deferring and rejecting record'

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

1483: jtm_message_log_pkg.Log_Msg
1484: ( v_object_id => r_debrief.DEBRIEF_LINE_ID -- put PK column here
1485: , v_object_name => g_object_name
1486: , v_message => 'Record not processed successfully, deferring and rejecting record'
1487: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
1488: END IF;
1489:
1490: CSL_SERVICEL_WRAPPER_PKG.DEFER_RECORD
1491: (

Line 1505: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

1501:
1502: /*** Was defer successful? ***/
1503: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1504: /*** no -> rollback ***/
1505: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
1506: jtm_message_log_pkg.Log_Msg
1507: ( v_object_id => r_debrief.DEBRIEF_LINE_ID -- put PK column here
1508: , v_object_name => g_object_name
1509: , v_message => 'Defer record failed, rolling back to savepoint'

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

1506: jtm_message_log_pkg.Log_Msg
1507: ( v_object_id => r_debrief.DEBRIEF_LINE_ID -- put PK column here
1508: , v_object_name => g_object_name
1509: , v_message => 'Defer record failed, rolling back to savepoint'
1510: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
1511: END IF;
1512: ROLLBACK TO save_rec;
1513: END IF;
1514: END IF;

Line 1523: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

1519: IF (l_header_id <> 0) THEN
1520: call_charges ( l_header_id );
1521: END IF;
1522:
1523: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1524: jtm_message_log_pkg.Log_Msg
1525: ( v_object_id => null
1526: , v_object_name => g_object_name
1527: , v_message => 'Leaving ' || g_object_name || '.Process_Debrief_No_Headers'

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

1524: jtm_message_log_pkg.Log_Msg
1525: ( v_object_id => null
1526: , v_object_name => g_object_name
1527: , v_message => 'Leaving ' || g_object_name || '.Process_Debrief_No_Headers'
1528: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
1529: END IF;
1530:
1531: /*** clear deferred_line queue ****/
1532: IF (g_deferred_line_id_tbl.COUNT > 0 ) THEN

Line 1538: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

1534: END IF;
1535:
1536: EXCEPTION WHEN OTHERS THEN
1537: /*** catch and log exceptions ***/
1538: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
1539: jtm_message_log_pkg.Log_Msg
1540: ( v_object_id => null
1541: , v_object_name => g_object_name
1542: , v_message => 'Exception occurred in Process_Debrief_No_Headers: ' || FND_GLOBAL.LOCAL_CHR(10) || sqlerrm

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

1539: jtm_message_log_pkg.Log_Msg
1540: ( v_object_id => null
1541: , v_object_name => g_object_name
1542: , v_message => 'Exception occurred in Process_Debrief_No_Headers: ' || FND_GLOBAL.LOCAL_CHR(10) || sqlerrm
1543: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
1544: END IF;
1545:
1546: x_return_status := FND_API.G_RET_STS_ERROR;
1547:

Line 1567: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

1563: l_error_msg VARCHAR2(4000);
1564: l_header_id NUMBER;
1565: BEGIN
1566:
1567: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1568: jtm_message_log_pkg.Log_Msg
1569: ( v_object_id => null
1570: , v_object_name => g_object_name
1571: , v_message => 'Entering ' || g_object_name ||

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

1569: ( v_object_id => null
1570: , v_object_name => g_object_name
1571: , v_message => 'Entering ' || g_object_name ||
1572: '.PROCESS_DEBRIEF_NO_LINES'
1573: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
1574: END IF;
1575:
1576:
1577: /***

Line 1612: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

1608: END IF;
1609:
1610: END LOOP;
1611:
1612: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1613: jtm_message_log_pkg.Log_Msg
1614: ( v_object_id => null
1615: , v_object_name => g_object_name
1616: , v_message => 'Leaving ' || g_object_name ||

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

1614: ( v_object_id => null
1615: , v_object_name => g_object_name
1616: , v_message => 'Leaving ' || g_object_name ||
1617: '.PROCESS_DEBRIEF_NO_LINES'
1618: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
1619: END IF;
1620:
1621: EXCEPTION WHEN OTHERS THEN
1622:

Line 1624: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

1620:
1621: EXCEPTION WHEN OTHERS THEN
1622:
1623: /*** catch and log exceptions ***/
1624: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
1625: jtm_message_log_pkg.Log_Msg
1626: ( v_object_id => null
1627: , v_object_name => g_object_name
1628: , v_message => 'Exception occurred in PROCESS_DEBRIEF_NO_LINES: '

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

1626: ( v_object_id => null
1627: , v_object_name => g_object_name
1628: , v_message => 'Exception occurred in PROCESS_DEBRIEF_NO_LINES: '
1629: || FND_GLOBAL.LOCAL_CHR(10) || sqlerrm
1630: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
1631: END IF;
1632:
1633: x_return_status := FND_API.G_RET_STS_ERROR;
1634:

Line 1656: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

1652: BEGIN
1653: g_debug_level := p_debug_level;
1654: x_return_status := FND_API.G_RET_STS_SUCCESS;
1655: g_header_id := NULL;
1656: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1657: jtm_message_log_pkg.Log_Msg
1658: ( v_object_id => null
1659: , v_object_name => g_object_name
1660: , v_message => 'Entering ' || g_object_name ||

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

1658: ( v_object_id => null
1659: , v_object_name => g_object_name
1660: , v_message => 'Entering ' || g_object_name ||
1661: '.Apply_Client_Changes'
1662: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
1663: END IF;
1664:
1665: -- First process all debrief lines that have a debrief header.
1666: -- Delete them after processing.

Line 1677: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

1673: -- Then process the debrief headers (no debrief lines).
1674: -- For example, DFF updates on local client etc.
1675: PROCESS_DEBRIEF_NO_LINES(p_user_name, p_tranid, x_return_status);
1676:
1677: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1678: jtm_message_log_pkg.Log_Msg
1679: ( v_object_id => null
1680: , v_object_name => g_object_name
1681: , v_message => 'Leaving ' || g_object_name ||

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

1679: ( v_object_id => null
1680: , v_object_name => g_object_name
1681: , v_message => 'Leaving ' || g_object_name ||
1682: '.Apply_Client_Changes'
1683: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
1684: END IF;
1685:
1686: END APPLY_CLIENT_CHANGES;
1687: END CSL_DEBRIEF_PKG;