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

Line 163: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

159: l_ship_to_site_use_id NUMBER;
160: l_customer_account_id NUMBER;
161:
162: BEGIN
163: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
164: jtm_message_log_pkg.Log_Msg
165: ( v_object_id => p_record.incident_id
166: , v_object_name => g_object_name
167: , v_message => 'Entering ' || g_object_name || '.APPLY_INSERT'

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

164: jtm_message_log_pkg.Log_Msg
165: ( v_object_id => p_record.incident_id
166: , v_object_name => g_object_name
167: , v_message => 'Entering ' || g_object_name || '.APPLY_INSERT'
168: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
169: END IF;
170:
171: -- Lookup the user_id
172: l_user_id := JTM_HOOK_UTIL_PKG.Get_User_Id( p_record.CLID$$CS );

Line 172: l_user_id := JTM_HOOK_UTIL_PKG.Get_User_Id( p_record.CLID$$CS );

168: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
169: END IF;
170:
171: -- Lookup the user_id
172: l_user_id := JTM_HOOK_UTIL_PKG.Get_User_Id( p_record.CLID$$CS );
173:
174: -- Initialization
175: CS_ServiceRequest_PUB.INITIALIZE_REC
176: ( p_sr_record => l_sr_rec

Line 393: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

389: p_api_error => TRUE
390: );
391: END IF;
392:
393: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
394: jtm_message_log_pkg.Log_Msg
395: ( v_object_id => p_record.incident_id
396: , v_object_name => g_object_name
397: , v_message => 'Leaving ' || g_object_name || '.APPLY_INSERT'

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

394: jtm_message_log_pkg.Log_Msg
395: ( v_object_id => p_record.incident_id
396: , v_object_name => g_object_name
397: , v_message => 'Leaving ' || g_object_name || '.APPLY_INSERT'
398: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
399: END IF;
400:
401: EXCEPTION WHEN OTHERS THEN
402: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

Line 402: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

398: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
399: END IF;
400:
401: EXCEPTION WHEN OTHERS THEN
402: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
403: jtm_message_log_pkg.Log_Msg
404: ( v_object_id => p_record.incident_id
405: , v_object_name => g_object_name
406: , v_message => 'Exception occurred in APPLY_INSERT:' || fnd_global.local_chr(10) || sqlerrm

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

403: jtm_message_log_pkg.Log_Msg
404: ( v_object_id => p_record.incident_id
405: , v_object_name => g_object_name
406: , v_message => 'Exception occurred in APPLY_INSERT:' || fnd_global.local_chr(10) || sqlerrm
407: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
408: END IF;
409:
410: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_INSERT', sqlerrm);
411: p_error_msg := CSL_SERVICEL_WRAPPER_PKG.GET_ERROR_MESSAGE_TEXT

Line 416: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

412: (
413: p_api_error => TRUE
414: );
415:
416: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
417: jtm_message_log_pkg.Log_Msg
418: ( v_object_id => p_record.incident_id
419: , v_object_name => g_object_name
420: , v_message => 'Leaving ' || g_object_name || '.APPLY_INSERT'

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

417: jtm_message_log_pkg.Log_Msg
418: ( v_object_id => p_record.incident_id
419: , v_object_name => g_object_name
420: , v_message => 'Leaving ' || g_object_name || '.APPLY_INSERT'
421: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
422: END IF;
423:
424: x_return_status := FND_API.G_RET_STS_ERROR;
425: END APPLY_INSERT;

Line 484: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

480: l_profile_value VARCHAR2(240);
481: l_decript_value VARCHAR2(250);
482:
483: BEGIN
484: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
485: jtm_message_log_pkg.Log_Msg
486: ( v_object_id => p_record.incident_id
487: , v_object_name => g_object_name
488: , v_message => 'Entering ' || g_object_name || '.APPLY_UPDATE'

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

485: jtm_message_log_pkg.Log_Msg
486: ( v_object_id => p_record.incident_id
487: , v_object_name => g_object_name
488: , v_message => 'Entering ' || g_object_name || '.APPLY_UPDATE'
489: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
490: END IF;
491:
492: -- Check for Stale data
493: l_profile_value := fnd_profile.value('JTM_APPL_CONFLICT_RULE');

Line 501: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

497: fetch c_last_update_date into r_last_update_date;
498: if c_last_update_date%found then
499: if r_last_update_date.last_update_date <> p_record.last_update_date then
500: close c_last_update_date;
501: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
502: jtm_message_log_pkg.Log_Msg
503: ( v_object_id => p_record.incident_id
504: , v_object_name => g_object_name
505: , v_message => 'Record is stale data'

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

502: jtm_message_log_pkg.Log_Msg
503: ( v_object_id => p_record.incident_id
504: , v_object_name => g_object_name
505: , v_message => 'Record is stale data'
506: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
507: END IF;
508: fnd_message.set_name
509: ( 'JTM'
510: , 'JTM_STALE_DATA'

Line 514: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

510: , 'JTM_STALE_DATA'
511: );
512: fnd_msg_pub.add;
513:
514: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
515: jtm_message_log_pkg.Log_Msg
516: ( v_object_id => p_record.incident_id
517: , v_object_name => g_object_name
518: , v_message => 'Leaving ' || g_object_name || '.APPLY_UPDATE'

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

515: jtm_message_log_pkg.Log_Msg
516: ( v_object_id => p_record.incident_id
517: , v_object_name => g_object_name
518: , v_message => 'Leaving ' || g_object_name || '.APPLY_UPDATE'
519: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
520: END IF;
521:
522: x_return_status := FND_API.G_RET_STS_SUCCESS;
523: return;

Line 526: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

522: x_return_status := FND_API.G_RET_STS_SUCCESS;
523: return;
524: end if;
525: else
526: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
527: jtm_message_log_pkg.Log_Msg
528: ( v_object_id => p_record.incident_id
529: , v_object_name => g_object_name
530: , v_message => 'No record found in Apps Database.'

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

527: jtm_message_log_pkg.Log_Msg
528: ( v_object_id => p_record.incident_id
529: , v_object_name => g_object_name
530: , v_message => 'No record found in Apps Database.'
531: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
532: END IF;
533: end if;
534: close c_last_update_date;
535: end if;

Line 543: l_user_id := JTM_HOOK_UTIL_PKG.Get_User_Id( p_record.CLID$$CS );

539: ( p_sr_record => l_sr_rec
540: );
541:
542: -- Lookup the user_id
543: l_user_id := JTM_HOOK_UTIL_PKG.Get_User_Id( p_record.CLID$$CS );
544:
545: -- Retrieve the required object_version_number.
546: open c_ovn
547: ( b_incident_id => p_record.incident_id

Line 684: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

680: p_error_msg := CSL_SERVICEL_WRAPPER_PKG.GET_ERROR_MESSAGE_TEXT
681: (
682: p_api_error => TRUE
683: );
684: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
685: jtm_message_log_pkg.Log_Msg
686: ( v_object_id => p_record.incident_id
687: , v_object_name => g_object_name
688: , v_message => 'Leaving ' || g_object_name || '.APPLY_UPDATE'

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

685: jtm_message_log_pkg.Log_Msg
686: ( v_object_id => p_record.incident_id
687: , v_object_name => g_object_name
688: , v_message => 'Leaving ' || g_object_name || '.APPLY_UPDATE'
689: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
690: END IF;
691: RETURN;
692: END IF;
693:

Line 694: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

690: END IF;
691: RETURN;
692: END IF;
693:
694: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
695: jtm_message_log_pkg.Log_Msg
696: ( v_object_id => p_record.incident_id
697: , v_object_name => g_object_name
698: , v_message => 'Leaving ' || g_object_name || '.APPLY_UPDATE'

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

695: jtm_message_log_pkg.Log_Msg
696: ( v_object_id => p_record.incident_id
697: , v_object_name => g_object_name
698: , v_message => 'Leaving ' || g_object_name || '.APPLY_UPDATE'
699: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
700: END IF;
701:
702: EXCEPTION WHEN OTHERS THEN
703: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

Line 703: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

699: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
700: END IF;
701:
702: EXCEPTION WHEN OTHERS THEN
703: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
704: jtm_message_log_pkg.Log_Msg
705: ( v_object_id => p_record.incident_id
706: , v_object_name => g_object_name
707: , v_message => 'Exception occurred in APPLY_UPDATE:' || fnd_global.local_chr(10) || sqlerrm

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

704: jtm_message_log_pkg.Log_Msg
705: ( v_object_id => p_record.incident_id
706: , v_object_name => g_object_name
707: , v_message => 'Exception occurred in APPLY_UPDATE:' || fnd_global.local_chr(10) || sqlerrm
708: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
709: END IF;
710:
711: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_UPDATE', sqlerrm);
712: p_error_msg := CSL_SERVICEL_WRAPPER_PKG.GET_ERROR_MESSAGE_TEXT

Line 717: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

713: (
714: p_api_error => TRUE
715: );
716:
717: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
718: jtm_message_log_pkg.Log_Msg
719: ( v_object_id => p_record.incident_id
720: , v_object_name => g_object_name
721: , v_message => 'Leaving ' || g_object_name || '.APPLY_UPDATE'

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

718: jtm_message_log_pkg.Log_Msg
719: ( v_object_id => p_record.incident_id
720: , v_object_name => g_object_name
721: , v_message => 'Leaving ' || g_object_name || '.APPLY_UPDATE'
722: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
723: END IF;
724:
725: x_return_status := FND_API.G_RET_STS_ERROR;
726: END APPLY_UPDATE;

Line 744: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

740: /*** initialize return status and message list ***/
741: x_return_status := FND_API.G_RET_STS_SUCCESS;
742: FND_MSG_PUB.INITIALIZE;
743:
744: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
745: jtm_message_log_pkg.Log_Msg
746: ( v_object_id => p_record.incident_id
747: , v_object_name => g_object_name
748: , v_message => 'Entering ' || g_object_name || '.APPLY_RECORD'

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

745: jtm_message_log_pkg.Log_Msg
746: ( v_object_id => p_record.incident_id
747: , v_object_name => g_object_name
748: , v_message => 'Entering ' || g_object_name || '.APPLY_RECORD'
749: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
750: END IF;
751:
752: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
753: jtm_message_log_pkg.Log_Msg

Line 752: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

748: , v_message => 'Entering ' || g_object_name || '.APPLY_RECORD'
749: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
750: END IF;
751:
752: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
753: jtm_message_log_pkg.Log_Msg
754: ( v_object_id => p_record.incident_id
755: , v_object_name => g_object_name
756: , v_message => 'Processing INCIDENT_ID = ' || p_record.incident_id || fnd_global.local_chr(10) ||

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

754: ( v_object_id => p_record.incident_id
755: , v_object_name => g_object_name
756: , v_message => 'Processing INCIDENT_ID = ' || p_record.incident_id || fnd_global.local_chr(10) ||
757: 'DMLTYPE = ' || p_record.dmltype$$
758: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
759: END IF;
760:
761: IF p_record.dmltype$$='I' THEN
762: -- Process insert

Line 779: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

775: x_return_status
776: );
777: ELSIF p_record.dmltype$$='D' THEN
778: -- Process delete; not supported for this entity
779: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
780: jtm_message_log_pkg.Log_Msg
781: ( v_object_id => p_record.incident_id
782: , v_object_name => g_object_name
783: , v_message => 'Delete is not supported for this entity'

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

780: jtm_message_log_pkg.Log_Msg
781: ( v_object_id => p_record.incident_id
782: , v_object_name => g_object_name
783: , v_message => 'Delete is not supported for this entity'
784: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
785: END IF;
786:
787: p_error_msg := CSL_SERVICEL_WRAPPER_PKG.GET_ERROR_MESSAGE_TEXT
788: (

Line 797: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

793:
794: x_return_status := FND_API.G_RET_STS_ERROR;
795: ELSE
796: -- invalid dml type
797: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
798: jtm_message_log_pkg.Log_Msg
799: ( v_object_id => p_record.incident_id
800: , v_object_name => g_object_name
801: , v_message => 'Invalid DML type: ' || p_record.dmltype$$

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

798: jtm_message_log_pkg.Log_Msg
799: ( v_object_id => p_record.incident_id
800: , v_object_name => g_object_name
801: , v_message => 'Invalid DML type: ' || p_record.dmltype$$
802: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
803: END IF;
804:
805: p_error_msg := CSL_SERVICEL_WRAPPER_PKG.GET_ERROR_MESSAGE_TEXT
806: (

Line 816: l_access_id := jtm_hook_util_pkg.get_acc_id(

812: x_return_status := FND_API.G_RET_STS_ERROR;
813: END IF;
814:
815: IF p_record.dmltype$$ = 'U' AND x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
816: l_access_id := jtm_hook_util_pkg.get_acc_id(
817: p_acc_table_name => 'CSL_CS_INCIDENTS_ALL_ACC',
818: p_resource_id => JTM_HOOK_UTIL_PKG.get_resource_id( p_record.clid$$cs ),
819: p_pk1_name => 'INCIDENT_ID',
820: p_pk1_num_value => p_record.INCIDENT_ID

Line 818: p_resource_id => JTM_HOOK_UTIL_PKG.get_resource_id( p_record.clid$$cs ),

814:
815: IF p_record.dmltype$$ = 'U' AND x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
816: l_access_id := jtm_hook_util_pkg.get_acc_id(
817: p_acc_table_name => 'CSL_CS_INCIDENTS_ALL_ACC',
818: p_resource_id => JTM_HOOK_UTIL_PKG.get_resource_id( p_record.clid$$cs ),
819: p_pk1_name => 'INCIDENT_ID',
820: p_pk1_num_value => p_record.INCIDENT_ID
821: );
822: l_rc := CSL_SERVICEL_WRAPPER_PKG.AUTONOMOUS_MARK_DIRTY(

Line 825: P_RESOURCEID => JTM_HOOK_UTIL_PKG.get_resource_id( p_record.clid$$cs ),

821: );
822: l_rc := CSL_SERVICEL_WRAPPER_PKG.AUTONOMOUS_MARK_DIRTY(
823: P_PUB_ITEM => g_pub_name,
824: P_ACCESSID => l_access_id,
825: P_RESOURCEID => JTM_HOOK_UTIL_PKG.get_resource_id( p_record.clid$$cs ),
826: P_DML => 'U',
827: P_TIMESTAMP => sysdate
828: );
829: END IF;

Line 831: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

827: P_TIMESTAMP => sysdate
828: );
829: END IF;
830:
831: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
832: jtm_message_log_pkg.Log_Msg
833: ( v_object_id => p_record.incident_id
834: , v_object_name => g_object_name
835: , v_message => 'Leaving ' || g_object_name || '.APPLY_RECORD'

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

832: jtm_message_log_pkg.Log_Msg
833: ( v_object_id => p_record.incident_id
834: , v_object_name => g_object_name
835: , v_message => 'Leaving ' || g_object_name || '.APPLY_RECORD'
836: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
837: END IF;
838: EXCEPTION WHEN OTHERS THEN
839: /*** defer record when any process exception occurs ***/
840: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

Line 840: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

836: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
837: END IF;
838: EXCEPTION WHEN OTHERS THEN
839: /*** defer record when any process exception occurs ***/
840: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
841: jtm_message_log_pkg.Log_Msg
842: ( v_object_id => p_record.incident_id
843: , v_object_name => g_object_name
844: , v_message => 'Exception occurred in APPLY_RECORD:' || fnd_global.local_chr(10) || sqlerrm

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

841: jtm_message_log_pkg.Log_Msg
842: ( v_object_id => p_record.incident_id
843: , v_object_name => g_object_name
844: , v_message => 'Exception occurred in APPLY_RECORD:' || fnd_global.local_chr(10) || sqlerrm
845: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
846: END IF;
847:
848: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_RECORD', sqlerrm);
849: p_error_msg := CSL_SERVICEL_WRAPPER_PKG.GET_ERROR_MESSAGE_TEXT

Line 854: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

850: (
851: p_api_error => TRUE
852: );
853:
854: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
855: jtm_message_log_pkg.Log_Msg
856: ( v_object_id => p_record.incident_id
857: , v_object_name => g_object_name
858: , v_message => 'Leaving ' || g_object_name || '.APPLY_RECORD'

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

855: jtm_message_log_pkg.Log_Msg
856: ( v_object_id => p_record.incident_id
857: , v_object_name => g_object_name
858: , v_message => 'Leaving ' || g_object_name || '.APPLY_RECORD'
859: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
860: END IF;
861:
862: x_return_status := FND_API.G_RET_STS_ERROR;
863: END APPLY_RECORD;

Line 885: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

881: BEGIN
882: g_debug_level := p_debug_level;
883: x_return_status := FND_API.G_RET_STS_SUCCESS;
884:
885: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
886: jtm_message_log_pkg.Log_Msg
887: ( v_object_id => null
888: , v_object_name => g_object_name
889: , v_message => 'Entering ' || g_object_name || '.Apply_Client_Changes'

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

886: jtm_message_log_pkg.Log_Msg
887: ( v_object_id => null
888: , v_object_name => g_object_name
889: , v_message => 'Entering ' || g_object_name || '.Apply_Client_Changes'
890: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
891: END IF;
892:
893: /*** loop through CSL_CS_INCIDENTS_ALL_VL records in inqueue ***/
894: FOR r_incident IN c_incident( p_user_name, p_tranid) LOOP

Line 907: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

903:
904: /*** was record processed successfully? ***/
905: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN
906: /*** Yes -> delete record from inqueue ***/
907: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
908: jtm_message_log_pkg.Log_Msg
909: ( v_object_id => r_incident.incident_id
910: , v_object_name => g_object_name
911: , v_message => 'Record successfully processed, deleting from inqueue'

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

908: jtm_message_log_pkg.Log_Msg
909: ( v_object_id => r_incident.incident_id
910: , v_object_name => g_object_name
911: , v_message => 'Record successfully processed, deleting from inqueue'
912: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
913: END IF;
914:
915: CSL_SERVICEL_WRAPPER_PKG.DELETE_RECORD
916: (

Line 928: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

924: l_process_status
925: );
926: /*** was delete successful? ***/
927: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
928: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
929: jtm_message_log_pkg.Log_Msg
930: ( v_object_id => r_incident.incident_id
931: , v_object_name => g_object_name
932: , v_message => 'Deleting from inqueue failed'

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

929: jtm_message_log_pkg.Log_Msg
930: ( v_object_id => r_incident.incident_id
931: , v_object_name => g_object_name
932: , v_message => 'Deleting from inqueue failed'
933: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
934: END IF;
935: END IF;
936:
937:

Line 953: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

949: l_process_status
950: );
951: /*** was delete successful? ***/
952: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
953: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
954: jtm_message_log_pkg.Log_Msg
955: ( v_object_id => r_contacts.SR_CONTACT_POINT_ID
956: , v_object_name => g_object_name
957: , v_message => 'Deleting from inqueue failed'

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

954: jtm_message_log_pkg.Log_Msg
955: ( v_object_id => r_contacts.SR_CONTACT_POINT_ID
956: , v_object_name => g_object_name
957: , v_message => 'Deleting from inqueue failed'
958: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
959: END IF;
960: END IF;
961: END LOOP;
962: ELSIF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN

Line 964: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

960: END IF;
961: END LOOP;
962: ELSIF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN
963: /*** Record was not applied successfully -> defer and reject records ***/
964: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
965: jtm_message_log_pkg.Log_Msg
966: ( v_object_id => r_incident.incident_id
967: , v_object_name => g_object_name
968: , v_message => 'Record not processed successfully, deferring and rejecting records'

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

965: jtm_message_log_pkg.Log_Msg
966: ( v_object_id => r_incident.incident_id
967: , v_object_name => g_object_name
968: , v_message => 'Record not processed successfully, deferring and rejecting records'
969: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
970: END IF;
971:
972: CSL_SERVICEL_WRAPPER_PKG.DEFER_RECORD
973: (

Line 1004: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

1000: END IF;
1001:
1002: END LOOP;
1003:
1004: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1005: jtm_message_log_pkg.Log_Msg
1006: ( v_object_id => null
1007: , v_object_name => g_object_name
1008: , v_message => 'Leaving ' || g_object_name || '.Apply_Client_Changes'

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

1005: jtm_message_log_pkg.Log_Msg
1006: ( v_object_id => null
1007: , v_object_name => g_object_name
1008: , v_message => 'Leaving ' || g_object_name || '.Apply_Client_Changes'
1009: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
1010: END IF;
1011:
1012: EXCEPTION WHEN OTHERS THEN
1013: /*** catch and log exceptions ***/

Line 1014: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

1010: END IF;
1011:
1012: EXCEPTION WHEN OTHERS THEN
1013: /*** catch and log exceptions ***/
1014: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
1015: jtm_message_log_pkg.Log_Msg
1016: ( v_object_id => null
1017: , v_object_name => g_object_name
1018: , v_message => 'Exception occurred in APPLY_CLIENT_CHANGES:' || fnd_global.local_chr(10) || sqlerrm

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

1015: jtm_message_log_pkg.Log_Msg
1016: ( v_object_id => null
1017: , v_object_name => g_object_name
1018: , v_message => 'Exception occurred in APPLY_CLIENT_CHANGES:' || fnd_global.local_chr(10) || sqlerrm
1019: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
1020: END IF;
1021: x_return_status := FND_API.G_RET_STS_ERROR;
1022: END APPLY_CLIENT_CHANGES;
1023: