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

Line 46: jtm_message_log_pkg.Log_Msg

42: IS
43: BEGIN
44:
45: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
46: jtm_message_log_pkg.Log_Msg
47: ( p_incident_id
48: , g_table_name1
49: , 'Entering INSERT_TXN_TYPES_RECORD'
50: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

Line 80: jtm_message_log_pkg.Log_Msg

76: , 1
77: );
78:
79: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
80: jtm_message_log_pkg.Log_Msg
81: ( p_incident_id
82: , g_table_name1
83: , 'Leaving INSERT_TXN_TYPES_RECORD'
84: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

Line 93: jtm_message_log_pkg.Log_Msg

89:
90: EXCEPTION
91: WHEN OTHERS THEN
92: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
93: jtm_message_log_pkg.Log_Msg
94: ( p_incident_id
95: , g_table_name1
96: , 'Exception occured in INSERT_TXN_TYPES_RECORD'
97: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR

Line 144: jtm_message_log_pkg.Log_Msg

140: x_msg_data VARCHAR2(4000);
141: BEGIN
142:
143: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
144: jtm_message_log_pkg.Log_Msg
145: ( p_incident_id
146: , g_table_name1
147: , 'Entering INSERT_CONTRACT_TXN_TYPES'
148: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

Line 202: jtm_message_log_pkg.Log_Msg

198:
199: IF l_success THEN
200: -- Push record to the Resource (insert in ACC)
201: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
202: jtm_message_log_pkg.Log_Msg
203: ( l_oks_out_tbl_bt(i).txn_bt_line_id
204: , g_table_name3
205: , 'Inserting ACC record for resource_id = ' || p_resource_id
206: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

Line 230: jtm_message_log_pkg.Log_Msg

226: END LOOP;
227: END IF;
228:
229: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
230: jtm_message_log_pkg.Log_Msg
231: ( p_incident_id
232: , g_table_name1
233: , 'Leaving INSERT_CONTRACT_TXN_TYPES'
234: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

Line 243: jtm_message_log_pkg.Log_Msg

239:
240: EXCEPTION
241: WHEN OTHERS THEN
242: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
243: jtm_message_log_pkg.Log_Msg
244: ( p_incident_id
245: , g_table_name1
246: , 'Exception occured in INSERT_CONTRACT_TXN_TYPES'
247: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR

Line 265: jtm_message_log_pkg.Log_Msg

261: IS
262: BEGIN
263:
264: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
265: jtm_message_log_pkg.Log_Msg
266: ( p_incident_id
267: , g_table_name1
268: , 'Entering INSERT_BUSS_PROCESSES_RECORD'
269: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

Line 297: jtm_message_log_pkg.Log_Msg

293: , 1
294: );
295:
296: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
297: jtm_message_log_pkg.Log_Msg
298: ( p_incident_id
299: , g_table_name1
300: , 'Leaving INSERT_BUSS_PROCESSES_RECORD'
301: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

Line 310: jtm_message_log_pkg.Log_Msg

306:
307: EXCEPTION
308: WHEN OTHERS THEN
309: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
310: jtm_message_log_pkg.Log_Msg
311: ( p_incident_id
312: , g_table_name1
313: , 'Exception occured in INSERT_BUSS_PROCESSES_RECORD'
314: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR

Line 353: jtm_message_log_pkg.Log_Msg

349: x_msg_data VARCHAR2(4000);
350: BEGIN
351:
352: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
353: jtm_message_log_pkg.Log_Msg
354: ( p_incident_id
355: , g_table_name1
356: , 'Entering INSERT_CONTRACT_BUSS_PROCESSES'
357: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

Line 398: jtm_message_log_pkg.Log_Msg

394: /* Looping over the table if table contain any record(s) */
395: FOR i IN l_oks_out_tbl_bp.FIRST .. l_oks_out_tbl_bp.LAST LOOP
396:
397: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
398: jtm_message_log_pkg.Log_Msg
399: ( p_incident_id
400: , g_table_name1
401: , 'Processing business_process_id ' || l_oks_out_tbl_bp(i).bp_id
402: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

Line 438: jtm_message_log_pkg.Log_Msg

434: );
435:
436: -- Push record to the Resource (insert in ACC)
437: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
438: jtm_message_log_pkg.Log_Msg
439: ( l_oks_out_tbl_bp(i).bp_id
440: , g_table_name2
441: , 'Inserting ACC record for resource_id = ' || p_resource_id
442: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

Line 464: jtm_message_log_pkg.Log_Msg

460: END LOOP;
461: END IF;
462:
463: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
464: jtm_message_log_pkg.Log_Msg
465: ( p_incident_id
466: , g_table_name1
467: , 'Leaving INSERT_CONTRACT_BUSS_PROCESSES'
468: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

Line 477: jtm_message_log_pkg.Log_Msg

473:
474: EXCEPTION
475: WHEN OTHERS THEN
476: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
477: jtm_message_log_pkg.Log_Msg
478: ( p_incident_id
479: , g_table_name1
480: , 'Exception occured in INSERT_CONTRACT_BUSS_PROCESSES'
481: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR

Line 500: jtm_message_log_pkg.Log_Msg

496: IS
497: BEGIN
498:
499: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
500: jtm_message_log_pkg.Log_Msg
501: ( p_incident_id
502: , g_table_name1
503: , 'Entering INSERT_CONTRACT_HEADER_RECORD'
504: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

Line 534: jtm_message_log_pkg.Log_Msg

530: , 1
531: );
532:
533: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
534: jtm_message_log_pkg.Log_Msg
535: ( p_incident_id
536: , g_table_name1
537: , 'Leaving INSERT_CONTRACT_HEADER_RECORD'
538: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

Line 547: jtm_message_log_pkg.Log_Msg

543:
544: EXCEPTION
545: WHEN OTHERS THEN
546: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
547: jtm_message_log_pkg.Log_Msg
548: ( p_incident_id
549: , g_table_name1
550: , 'Exception occured in INSERT_CONTRACT_HEADER_RECORD'
551: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR

Line 612: jtm_message_log_pkg.Log_Msg

608:
609: BEGIN
610:
611: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
612: jtm_message_log_pkg.Log_Msg
613: ( p_incident_id
614: , g_table_name1
615: , 'Entering INSERT_CONTRACT_HEADER'
616: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

Line 625: jtm_message_log_pkg.Log_Msg

621: FETCH c_csl_contr_record INTO r_csl_contr_record;
622: IF c_csl_contr_record%NOTFOUND THEN
623:
624: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
625: jtm_message_log_pkg.Log_Msg
626: ( p_incident_id
627: , g_table_name1
628: , 'Contract Line for INCIDENT_ID: ' || p_incident_id || ' does not exist in CSL_SR_CONTRACT_HEADERS'
629: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

Line 632: jtm_message_log_pkg.Log_Msg

628: , 'Contract Line for INCIDENT_ID: ' || p_incident_id || ' does not exist in CSL_SR_CONTRACT_HEADERS'
629: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
630: , 'csl_contract_handling_pkg');
631:
632: jtm_message_log_pkg.Log_Msg
633: ( p_incident_id
634: , g_table_name1
635: , 'Getting the details of the Contract Line for INCIDENT_ID: ' || p_incident_id
636: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

Line 648: jtm_message_log_pkg.Log_Msg

644: , l_service_description
645: , l_amount_uom_code;
646: IF c_csl_contract_line_details%NOTFOUND THEN
647: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
648: jtm_message_log_pkg.Log_Msg
649: ( p_incident_id
650: , g_table_name1
651: , 'No data found in CURSOR Contract Line for INCIDENT_ID: ' || p_incident_id
652: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM

Line 658: jtm_message_log_pkg.Log_Msg

654: END IF;
655: ELSE
656:
657: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
658: jtm_message_log_pkg.Log_Msg
659: ( p_incident_id
660: , g_table_name1
661: , 'Details of Contract Line for INCIDENT_ID: ' || p_incident_id
662: || ', CONTRACT_SERVICE_ID: ' || l_contract_service_id

Line 703: jtm_message_log_pkg.Log_Msg

699: );
700:
701: -- Push record to the Resource (insert in ACC)
702: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
703: jtm_message_log_pkg.Log_Msg
704: ( p_incident_id
705: , g_table_name1
706: , 'Inserting ACC record for resource_id = ' || p_resource_id
707: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

Line 732: jtm_message_log_pkg.Log_Msg

728: );
729:
730: IF NOT(l_return) THEN
731: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
732: jtm_message_log_pkg.Log_Msg
733: ( l_contract_service_id
734: , g_table_name1
735: , 'Inserting Contract Notes Failed for resource_id = '
736: || p_resource_id

Line 746: jtm_message_log_pkg.Log_Msg

742: END IF;
743: END IF;
744:
745: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
746: jtm_message_log_pkg.Log_Msg
747: ( p_incident_id
748: , g_table_name1
749: , 'Leaving INSERT_CONTRACT_HEADER'
750: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

Line 759: jtm_message_log_pkg.Log_Msg

755:
756: EXCEPTION
757: WHEN OTHERS THEN
758: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
759: jtm_message_log_pkg.Log_Msg
760: ( p_incident_id
761: , g_table_name1
762: , 'Exception occured in INSERT_CONTRACT_HEADER'
763: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR

Line 782: jtm_message_log_pkg.Log_Msg

778: IS
779: BEGIN
780:
781: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
782: jtm_message_log_pkg.Log_Msg
783: ( p_incident_id
784: , g_table_name1
785: , 'Entering DELETE_SR_CONTRACT_ACC'
786: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

Line 791: jtm_message_log_pkg.Log_Msg

787: , 'csl_contract_handling_pkg');
788: END IF;
789:
790: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
791: jtm_message_log_pkg.Log_Msg
792: ( p_incident_id
793: , g_table_name1
794: , 'Deleting Header ACC record for resource_id = ' || p_resource_id || ', incident_id = ' || p_incident_id
795: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

Line 809: jtm_message_log_pkg.Log_Msg

805: ,P_RESOURCE_ID => p_resource_id
806: );
807:
808: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
809: jtm_message_log_pkg.Log_Msg
810: ( p_incident_id
811: , g_table_name2
812: , 'Deleting Buss proc ACC record for resource_id = ' || p_resource_id || ', incident_id = ' || p_incident_id
813: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

Line 826: jtm_message_log_pkg.Log_Msg

822: ,P_RESOURCE_ID => p_resource_id
823: );
824:
825: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
826: jtm_message_log_pkg.Log_Msg
827: ( p_incident_id
828: , g_table_name3
829: , 'Deleting Buss Txn type ACC record for resource_id = ' || p_resource_id || ', incident_id = ' || p_incident_id
830: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

Line 851: jtm_message_log_pkg.Log_Msg

847: , P_RESOURCE_ID => p_resource_id
848: );
849:
850: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
851: jtm_message_log_pkg.Log_Msg
852: ( p_incident_id
853: , g_table_name1
854: , 'Leaving DELETE_SR_CONTRACT_ACC'
855: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

Line 862: jtm_message_log_pkg.Log_Msg

858:
859: EXCEPTION
860: WHEN OTHERS THEN
861: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
862: jtm_message_log_pkg.Log_Msg
863: ( p_incident_id
864: , g_table_name1
865: , 'Exception occured in DELETE_SR_CONTRACT_ACC'
866: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR

Line 884: jtm_message_log_pkg.Log_Msg

880: /*** get debug level ***/
881: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
882:
883: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
884: jtm_message_log_pkg.Log_Msg
885: ( p_incident_id
886: , g_table_name1
887: , 'Entering POST_INSERT_SR_CONTRACT_ACC'
888: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

Line 904: jtm_message_log_pkg.Log_Msg

900: x_return_status := FND_API.G_RET_STS_ERROR;
901: END IF;
902:
903: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
904: jtm_message_log_pkg.Log_Msg
905: ( p_incident_id
906: , g_table_name1
907: , 'Leaving POST_INSERT_SR_CONTRACT_ACC'
908: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

Line 934: jtm_message_log_pkg.Log_Msg

930: /*** get debug level ***/
931: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
932:
933: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
934: jtm_message_log_pkg.Log_Msg
935: ( p_incident_id
936: , g_table_name1
937: , 'Entering POST_UPDATE_SR_CONTRACT_ACC'
938: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

Line 977: jtm_message_log_pkg.Log_Msg

973: );
974: END IF;
975:
976: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
977: jtm_message_log_pkg.Log_Msg
978: ( p_incident_id
979: , g_table_name1
980: , 'Leaving POST_UPDATE_SR_CONTRACT_ACC'
981: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

Line 1005: jtm_message_log_pkg.Log_Msg

1001: /*** get debug level ***/
1002: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
1003:
1004: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1005: jtm_message_log_pkg.Log_Msg
1006: ( p_incident_id
1007: , g_table_name1
1008: , 'Entering PRE_DELETE_SR_CONTRACT_ACC'
1009: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

Line 1027: jtm_message_log_pkg.Log_Msg

1023:
1024: x_return_status := FND_API.G_RET_STS_SUCCESS;
1025:
1026: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1027: jtm_message_log_pkg.Log_Msg
1028: ( p_incident_id
1029: , g_table_name1
1030: , 'Entering PRE_DELETE_SR_CONTRACT_ACC'
1031: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL