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_MESSAGE_LOG_PKG

Line 93: jtm_message_log_pkg.Log_Msg

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

Line 153: jtm_message_log_pkg.Log_Msg

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

Line 168: jtm_message_log_pkg.Log_Msg

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

Line 207: jtm_message_log_pkg.Log_Msg

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

Line 225: jtm_message_log_pkg.Log_Msg

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

Line 244: jtm_message_log_pkg.Log_Msg

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

Line 314: jtm_message_log_pkg.Log_Msg

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 ||
318: '.APPLY_INSERT_HEADER'

Line 363: jtm_message_log_pkg.Log_Msg

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
367: inqueue'

Line 387: jtm_message_log_pkg.Log_Msg

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, '||
391: 'rolling back to savepoint'

Line 400: jtm_message_log_pkg.Log_Msg

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, '||
404: 'deferring and rejecting record'

Line 424: jtm_message_log_pkg.Log_Msg

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'
428: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 440: jtm_message_log_pkg.Log_Msg

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, '||
444: 'deferring and rejecting record'

Line 464: jtm_message_log_pkg.Log_Msg

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'
468: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 475: jtm_message_log_pkg.Log_Msg

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 ||
479: '.APPLY_INSERT_HEADER'

Line 485: jtm_message_log_pkg.Log_Msg

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:' ||
489: FND_GLOBAL.LOCAL_CHR(10) || sqlerrm

Line 500: jtm_message_log_pkg.Log_Msg

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 ||
504: '.APPLY_INSERT_HEADER'

Line 631: jtm_message_log_pkg.Log_Msg

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

Line 658: jtm_message_log_pkg.Log_Msg

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

Line 837: jtm_message_log_pkg.Log_Msg

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

Line 854: jtm_message_log_pkg.Log_Msg

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

Line 868: jtm_message_log_pkg.Log_Msg

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

Line 937: jtm_message_log_pkg.Log_Msg

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 ||
941: '.APPLY_UPDATE_HEADER'

Line 1025: jtm_message_log_pkg.Log_Msg

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, '||
1029: ' deleting from inqueue'

Line 1049: jtm_message_log_pkg.Log_Msg

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 '||
1053: ' back to savepoint'

Line 1065: jtm_message_log_pkg.Log_Msg

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
1068: , v_message => 'Record not processed successfully, '||
1069: 'deferring and rejecting record'

Line 1089: jtm_message_log_pkg.Log_Msg

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'
1093: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 1101: jtm_message_log_pkg.Log_Msg

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 ||
1105: '.APPLY_UPDATE_HEADER'

Line 1112: jtm_message_log_pkg.Log_Msg

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:' ||
1116: FND_GLOBAL.LOCAL_CHR(10) || sqlerrm

Line 1127: jtm_message_log_pkg.Log_Msg

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 ||
1131: '.APPLY_UPDATE_HEADER'

Line 1154: jtm_message_log_pkg.Log_Msg

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

Line 1173: jtm_message_log_pkg.Log_Msg

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

Line 1182: jtm_message_log_pkg.Log_Msg

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

Line 1196: jtm_message_log_pkg.Log_Msg

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

Line 1223: jtm_message_log_pkg.Log_Msg

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

Line 1265: jtm_message_log_pkg.Log_Msg

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'
1269: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 1288: jtm_message_log_pkg.Log_Msg

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'
1292: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 1302: jtm_message_log_pkg.Log_Msg

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'
1306: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 1325: jtm_message_log_pkg.Log_Msg

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'
1329: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 1357: jtm_message_log_pkg.Log_Msg

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

Line 1367: jtm_message_log_pkg.Log_Msg

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

Line 1393: jtm_message_log_pkg.Log_Msg

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

Line 1444: jtm_message_log_pkg.Log_Msg

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'
1448: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 1467: jtm_message_log_pkg.Log_Msg

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'
1471: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 1483: jtm_message_log_pkg.Log_Msg

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'
1487: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 1506: jtm_message_log_pkg.Log_Msg

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'
1510: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 1524: jtm_message_log_pkg.Log_Msg

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

Line 1539: jtm_message_log_pkg.Log_Msg

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

Line 1568: jtm_message_log_pkg.Log_Msg

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 ||
1572: '.PROCESS_DEBRIEF_NO_LINES'

Line 1613: jtm_message_log_pkg.Log_Msg

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 ||
1617: '.PROCESS_DEBRIEF_NO_LINES'

Line 1625: jtm_message_log_pkg.Log_Msg

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: '
1629: || FND_GLOBAL.LOCAL_CHR(10) || sqlerrm

Line 1657: jtm_message_log_pkg.Log_Msg

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 ||
1661: '.Apply_Client_Changes'

Line 1678: jtm_message_log_pkg.Log_Msg

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 ||
1682: '.Apply_Client_Changes'