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

Line 43: jtm_message_log_pkg.Log_Msg

39: /*** get debug level ***/
40: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
41:
42: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
43: jtm_message_log_pkg.Log_Msg
44: ( p_incident_id
45: , g_table_name
46: , 'Entering Replicate_Record'
47: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 55: jtm_message_log_pkg.Log_Msg

51: FETCH c_incident INTO r_incident;
52: IF c_incident%NOTFOUND THEN
53: /*** could not find incident record -> exit ***/
54: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
55: jtm_message_log_pkg.Log_Msg
56: ( p_incident_id
57: , g_table_name
58: , 'Replicate_Record error: Could not find incident_id ' || p_incident_id
59: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 68: jtm_message_log_pkg.Log_Msg

64: END IF;
65: CLOSE c_incident;
66:
67: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
68: jtm_message_log_pkg.Log_Msg
69: ( p_incident_id
70: , g_table_name
71: , 'Replicate_Record returned TRUE'
72: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 103: jtm_message_log_pkg.Log_Msg

99: l_execute_status INTEGER;
100:
101: BEGIN
102: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
103: jtm_message_log_pkg.Log_Msg
104: ( p_incident_id
105: , g_table_name
106: , 'Entering Insert_ACC_Record'
107: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 111: jtm_message_log_pkg.Log_Msg

107: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
108: END IF;
109:
110: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
111: jtm_message_log_pkg.Log_Msg
112: ( p_incident_id
113: , g_table_name
114: , 'Inserting ACC record for resource_id = ' || p_resource_id
115: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 137: jtm_message_log_pkg.Log_Msg

133: OPEN c_incident( p_incident_id );
134: FETCH c_incident INTO r_incident;
135: IF c_incident%FOUND THEN
136: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
137: jtm_message_log_pkg.Log_Msg
138: ( p_incident_id
139: , g_table_name
140: , 'Inserting non-critical dependant records'
141: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 216: jtm_message_log_pkg.Log_Msg

212: DBMS_SQL.close_cursor (l_cursorid);
213:
214: /*Done, all packages are called*/
215: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
216: jtm_message_log_pkg.Log_Msg
217: ( p_incident_id
218: , g_table_name
219: , 'Leaving Insert_ACC_Record'
220: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 236: jtm_message_log_pkg.Log_Msg

232: )
233: IS
234: BEGIN
235: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
236: jtm_message_log_pkg.Log_Msg
237: ( p_incident_id
238: , g_table_name
239: , 'Entering Update_ACC_Record'
240: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 244: jtm_message_log_pkg.Log_Msg

240: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
241: END IF;
242:
243: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
244: jtm_message_log_pkg.Log_Msg
245: ( p_incident_id
246: , g_table_name
247: , 'Updating ACC record for resource_id = ' || p_resource_id || fnd_global.local_chr(10) ||
248: 'access_id = ' || p_acc_id

Line 260: jtm_message_log_pkg.Log_Msg

256: ,P_ACCESS_ID => p_acc_id
257: );
258:
259: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
260: jtm_message_log_pkg.Log_Msg
261: ( p_incident_id
262: , g_table_name
263: , 'Leaving Update_ACC_Record'
264: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 291: jtm_message_log_pkg.Log_Msg

287: l_cursorid INTEGER;
288: l_execute_status INTEGER;
289: BEGIN
290: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
291: jtm_message_log_pkg.Log_Msg
292: ( p_incident_id
293: , g_table_name
294: , 'Entering Delete_ACC_Record'
295: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 299: jtm_message_log_pkg.Log_Msg

295: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
296: END IF;
297:
298: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
299: jtm_message_log_pkg.Log_Msg
300: ( p_incident_id
301: , g_table_name
302: , 'Deleting ACC record for resource_id = ' || p_resource_id
303: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 317: jtm_message_log_pkg.Log_Msg

313: );
314:
315: /*Delete also the dependant records*/
316: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
317: jtm_message_log_pkg.Log_Msg
318: ( p_incident_id
319: , g_table_name
320: , 'Deleting child records'
321: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 402: jtm_message_log_pkg.Log_Msg

398: DBMS_SQL.close_cursor (l_cursorid);
399:
400:
401: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
402: jtm_message_log_pkg.Log_Msg
403: ( p_incident_id
404: , g_table_name
405: , 'Leaving Delete_ACC_Record'
406: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 430: jtm_message_log_pkg.Log_Msg

426: /*** get debug level ***/
427: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
428:
429: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
430: jtm_message_log_pkg.Log_Msg
431: ( p_incident_id
432: , g_table_name
433: , 'Entering Pre_Insert_Child procedure'
434: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 458: jtm_message_log_pkg.Log_Msg

454: IF FND_PROFILE.VALUE( 'JTM_SYNCHRONOUS_HISTORY') = 'Y' THEN
455: IF CSL_SERVICE_HISTORY_PKG.GET_HISTORY_COUNT( p_resource_id ) > 0 THEN
456: /*Yes create history*/
457: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
458: jtm_message_log_pkg.Log_Msg
459: ( p_incident_id
460: , g_table_name
461: , 'History should be gathered synchronously'
462: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 472: jtm_message_log_pkg.Log_Msg

468: END IF;--p_flow_type
469: END IF;--Replicate record
470:
471: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
472: jtm_message_log_pkg.Log_Msg
473: ( p_incident_id
474: , g_table_name
475: , 'Leaving Pre_Insert_Child procedure'
476: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 496: jtm_message_log_pkg.Log_Msg

492: /*** get debug level ***/
493: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
494:
495: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
496: jtm_message_log_pkg.Log_Msg
497: ( p_incident_id
498: , g_table_name
499: , 'Entering Post_Delete_Child'
500: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 506: jtm_message_log_pkg.Log_Msg

502:
503: IF p_flow_type <> G_FLOW_HISTORY THEN
504: /*Delete also the history for this SR*/
505: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
506: jtm_message_log_pkg.Log_Msg
507: ( p_incident_id
508: , g_table_name
509: , 'Delete all history records on incident id '||p_incident_id
510: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 524: jtm_message_log_pkg.Log_Msg

520: , p_flow_type );
521:
522:
523: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
524: jtm_message_log_pkg.Log_Msg
525: ( p_incident_id
526: , g_table_name
527: , 'Leaving Post_Delete_Child'
528: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 565: jtm_message_log_pkg.Log_Msg

561: END IF;
562: /*** get debug level ***/
563: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
564: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
565: jtm_message_log_pkg.Log_Msg
566: ( l_incident_id
567: , g_table_name
568: , 'Entering POST_INSERT_INCIDENT hook'
569: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 579: jtm_message_log_pkg.Log_Msg

575: FETCH c_incident INTO r_incident;
576: IF c_incident%FOUND THEN
577: IF JTM_HOOK_UTIL_PKG.isMobileFSresource(r_incident.RESOURCE_ID) THEN
578: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
579: jtm_message_log_pkg.Log_Msg
580: ( l_incident_id
581: , g_table_name
582: , 'SR is logged by mobile resource '||r_incident.RESOURCE_ID||' hence inserting record in acc table'
583: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 588: jtm_message_log_pkg.Log_Msg

584: END IF;
585: l_dummy := Pre_Insert_Child( l_incident_id, r_incident.RESOURCE_ID, G_FLOW_MOBILE_SR );
586: ELSE
587: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
588: jtm_message_log_pkg.Log_Msg
589: ( l_incident_id
590: , g_table_name
591: , r_incident.RESOURCE_ID||' is not a OMFS/Laptop resource'
592: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 597: jtm_message_log_pkg.Log_Msg

593: END IF;
594: END IF;--isMobileFSresource
595: ELSE
596: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
597: jtm_message_log_pkg.Log_Msg
598: ( l_incident_id
599: , g_table_name
600: , 'SR is not logged by a mobile resource'
601: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 607: jtm_message_log_pkg.Log_Msg

603: END IF;--c_incident%FOUND
604: CLOSE c_incident;
605:
606: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
607: jtm_message_log_pkg.Log_Msg
608: ( l_incident_id
609: , g_table_name
610: , 'Leaving POST_INSERT_INCIDENT hook'
611: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 618: jtm_message_log_pkg.Log_Msg

614: x_return_status := FND_API.G_RET_STS_SUCCESS;
615: EXCEPTION WHEN OTHERS THEN
616: /*** hook failed -> log error ***/
617: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
618: jtm_message_log_pkg.Log_Msg
619: ( l_incident_id
620: , g_table_name
621: , 'Caught exception in POST_INSERT_INCIDENT hook:' || fnd_global.local_chr(10) || sqlerrm
622: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

Line 663: jtm_message_log_pkg.Log_Msg

659: /*** get debug level ***/
660: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
661:
662: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
663: jtm_message_log_pkg.Log_Msg
664: ( l_incident_id
665: , g_table_name
666: , 'Entering PRE_UPDATE hook'
667: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 681: jtm_message_log_pkg.Log_Msg

677:
678: x_return_status := FND_API.G_RET_STS_SUCCESS;
679:
680: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
681: jtm_message_log_pkg.Log_Msg
682: ( l_incident_id
683: , g_table_name
684: , 'Leaving PRE_UPDATE hook'
685: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 691: jtm_message_log_pkg.Log_Msg

687:
688: EXCEPTION WHEN OTHERS THEN
689: /*** hook failed -> log error ***/
690: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
691: jtm_message_log_pkg.Log_Msg
692: ( l_incident_id
693: , g_table_name
694: , 'Caught exception in PRE_UPDATE hook:' || fnd_global.local_chr(10) || sqlerrm
695: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

Line 757: jtm_message_log_pkg.Log_Msg

753: /*** get debug level ***/
754: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
755:
756: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
757: jtm_message_log_pkg.Log_Msg
758: ( l_incident_id
759: , g_table_name
760: , 'Entering POST_UPDATE hook'
761: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 773: jtm_message_log_pkg.Log_Msg

769: /*** yes -> was record already replicated? ***/
770: IF g_replicate_pre_update THEN
771: /*** yes -> re-send updated task record to all resources ***/
772: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
773: jtm_message_log_pkg.Log_Msg
774: ( l_incident_id
775: , g_table_name
776: , 'Incident was replicateable before and after update. Re-sending incident record to mobile users.'
777: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 812: jtm_message_log_pkg.Log_Msg

808:
809: /*check if customer has changed ( not possible in the form , but maybe the API ? )*/
810: IF r_incident.customer_id <> g_cached_rec.customer_id THEN
811: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
812: jtm_message_log_pkg.Log_Msg
813: ( l_incident_id
814: , g_table_name
815: , 'Customer of the incident has changed.'
816: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 827: jtm_message_log_pkg.Log_Msg

823:
824: /*check if the installed at address is changed*/
825: IF NVL( r_incident.incident_location_id, FND_API.G_MISS_NUM ) <> NVL( g_cached_rec.incident_location_id, FND_API.G_MISS_NUM ) THEN
826: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
827: jtm_message_log_pkg.Log_Msg
828: ( l_incident_id
829: , g_table_name
830: , 'Installed at address of the incident has changed.'
831: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 842: jtm_message_log_pkg.Log_Msg

838:
839: /*check if the customer product is changed*/
840: IF NVL( r_incident.customer_product_id, FND_API.G_MISS_NUM ) <> NVL( g_cached_rec.customer_product_id, FND_API.G_MISS_NUM ) THEN
841: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
842: jtm_message_log_pkg.Log_Msg
843: ( l_incident_id
844: , g_table_name
845: , 'Customer product of the incident has changed.'
846: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 871: jtm_message_log_pkg.Log_Msg

867:
868: /*check if the inventory item is changed*/
869: IF NVL( r_incident.inventory_item_id, FND_API.G_MISS_NUM ) <> NVL( g_cached_rec.inventory_item_id, FND_API.G_MISS_NUM ) THEN
870: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
871: jtm_message_log_pkg.Log_Msg
872: ( l_incident_id
873: , g_table_name
874: , 'Inventory item of the incident has changed.'
875: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 894: jtm_message_log_pkg.Log_Msg

890:
891: IF NVL(r_incident.contract_service_id, FND_API.G_MISS_NUM) <> NVL( g_cached_rec.contract_service_id, FND_API.G_MISS_NUM) THEN
892: /*Delete contract record, use dynamic SQL because Contracts might not be implemented/used*/
893: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
894: jtm_message_log_pkg.Log_Msg
895: ( l_incident_id
896: , g_table_name
897: , 'Contract line of the incident has changed.'
898: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 926: jtm_message_log_pkg.Log_Msg

922: /***
923: record was not replicated before update so we don't need it
924: ***/
925: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
926: jtm_message_log_pkg.Log_Msg
927: ( l_incident_id
928: , g_table_name
929: , 'Incident was not replicated before update.'
930: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 938: jtm_message_log_pkg.Log_Msg

934: /*** record should not be replicated anymore -> was it replicated before? ***/
935: IF g_replicate_pre_update THEN
936: /*** yes -> delete record related data for all resources ***/
937: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
938: jtm_message_log_pkg.Log_Msg
939: ( l_incident_id
940: , g_table_name
941: , 'Incident was replicated before update, but should no longer be replicated.'
942: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

Line 950: jtm_message_log_pkg.Log_Msg

946:
947: x_return_status := FND_API.G_RET_STS_SUCCESS;
948:
949: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
950: jtm_message_log_pkg.Log_Msg
951: ( l_incident_id
952: , g_table_name
953: , 'Leaving POST_UPDATE hook'
954: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 960: jtm_message_log_pkg.Log_Msg

956:
957: EXCEPTION WHEN OTHERS THEN
958: /*** hook failed -> log error ***/
959: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
960: jtm_message_log_pkg.Log_Msg
961: ( l_incident_id
962: , g_table_name
963: , 'Caught exception in POST_UPDATE hook:' || fnd_global.local_chr(10) || sqlerrm
964: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);

Line 1005: jtm_message_log_pkg.Log_Msg

1001: r_incident c_incident%ROWTYPE;
1002: l_dummy BOOLEAN;
1003: BEGIN
1004: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1005: jtm_message_log_pkg.Log_Msg
1006: ( p_resource_id
1007: , g_table_name
1008: , 'Entering POST_INSERT hook'
1009: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 1018: jtm_message_log_pkg.Log_Msg

1014: l_dummy := Pre_Insert_Child( r_incident.incident_id, p_resource_id, G_FLOW_MOBILE_SR );
1015: END LOOP;
1016:
1017: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1018: jtm_message_log_pkg.Log_Msg
1019: ( p_resource_id
1020: , g_table_name
1021: , 'Leaving POST_INSERT hook'
1022: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

Line 1030: jtm_message_log_pkg.Log_Msg

1026:
1027: EXCEPTION
1028: WHEN OTHERS THEN
1029: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
1030: jtm_message_log_pkg.Log_Msg
1031: ( p_resource_id
1032: , g_table_name
1033: , 'Caught exception in INSERT_ALL_ACC_RECORDS:' || fnd_global.local_chr(10) || sqlerrm
1034: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);