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.CSM_SERVICE_REQUESTS_PKG dependencies on CSM_UTIL_PKG

Line 179: CSM_UTIL_PKG.LOG('Entering CSM_SERVICE_REQUESTS_PKG.APPLY_INSERT for incident_id ' || p_record.incident_id ,

175: l_free_form_ser_rec C_FREE_FORM_SER_INFO%ROWTYPE;
176: l_CS_INV_ORG_ID NUMBER;
177: BEGIN
178:
179: CSM_UTIL_PKG.LOG('Entering CSM_SERVICE_REQUESTS_PKG.APPLY_INSERT for incident_id ' || p_record.incident_id ,
180: 'CSM_SERVICE_REQUESTS_PKG.APPLY_INSERT',FND_LOG.LEVEL_PROCEDURE);
181:
182: l_user_id := JTM_HOOK_UTIL_PKG.Get_User_Id( p_record.CLID$$CS );
183: l_created_by := p_record.CREATED_BY;

Line 443: CSM_UTIL_PKG.LOG('Before calling CS_ServiceRequest_PUB.Create_ServiceRequest for ' || p_record.incident_id ,

439: l_contacts_tab( l_contact_index ) := l_contact_rec;
440: END LOOP;
441:
442:
443: CSM_UTIL_PKG.LOG('Before calling CS_ServiceRequest_PUB.Create_ServiceRequest for ' || p_record.incident_id ,
444: 'CSM_SERVICE_REQUESTS_PKG.APPLY_INSERT',FND_LOG.LEVEL_EVENT);
445:
446: /* Calling CS API for actual insert */
447: CS_ServiceRequest_PUB.Create_ServiceRequest

Line 470: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

466: );
467:
468: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
469: /*** exception occurred in API -> return errmsg ***/
470: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
471: (
472: p_api_error => TRUE
473: );
474: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_INSERT:'

Line 474: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_INSERT:'

470: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
471: (
472: p_api_error => TRUE
473: );
474: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_INSERT:'
475: || ' ROOT ERROR: CS_ServiceRequest_PUB.Create_ServiceRequest ' || sqlerrm
476: || ' for incident_id ' || p_record.incident_id,'CSM_SERVICE_REQUESTS_PKG.APPLY_INSERT',FND_LOG.LEVEL_ERROR);
477: x_return_status := FND_API.G_RET_STS_ERROR;
478: return;

Line 480: CSM_UTIL_PKG.LOG('Leaving CSM_SERVICE_REQUESTS_PKG.APPLY_INSERT for incident_id ' || p_record.incident_id ,

476: || ' for incident_id ' || p_record.incident_id,'CSM_SERVICE_REQUESTS_PKG.APPLY_INSERT',FND_LOG.LEVEL_ERROR);
477: x_return_status := FND_API.G_RET_STS_ERROR;
478: return;
479: END IF;
480: CSM_UTIL_PKG.LOG('Leaving CSM_SERVICE_REQUESTS_PKG.APPLY_INSERT for incident_id ' || p_record.incident_id ,
481: 'CSM_SERVICE_REQUESTS_PKG.APPLY_INSERT',FND_LOG.LEVEL_PROCEDURE);
482:
483: EXCEPTION WHEN OTHERS THEN
484: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_INSERT', sqlerrm);

Line 485: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

481: 'CSM_SERVICE_REQUESTS_PKG.APPLY_INSERT',FND_LOG.LEVEL_PROCEDURE);
482:
483: EXCEPTION WHEN OTHERS THEN
484: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_INSERT', sqlerrm);
485: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
486: (
487: p_api_error => TRUE
488: );
489: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_INSERT: ' || sqlerrm

Line 489: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_INSERT: ' || sqlerrm

485: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
486: (
487: p_api_error => TRUE
488: );
489: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_INSERT: ' || sqlerrm
490: || ' for incident_id ' || p_record.incident_id ,'CSM_SERVICE_REQUESTS_PKG.APPLY_INSERT',FND_LOG.LEVEL_EXCEPTION);
491:
492: IF c_customer_account%ISOPEN THEN
493: CLOSE c_customer_account;

Line 553: CSM_UTIL_PKG.LOG('Entering CSM_SERVICE_REQUESTS_PKG.APPLY_UPDATE for incident_id ' || p_record.incident_id ,

549: l_CS_INV_ORG_ID NUMBER;
550: l_customer_account_id NUMBER;
551: BEGIN
552:
553: CSM_UTIL_PKG.LOG('Entering CSM_SERVICE_REQUESTS_PKG.APPLY_UPDATE for incident_id ' || p_record.incident_id ,
554: 'CSM_SERVICE_REQUESTS_PKG.APPLY_UPDATE',FND_LOG.LEVEL_PROCEDURE);
555: -- Check for Stale data
556: l_profile_value := fnd_profile.value(csm_profile_pkg.g_JTM_APPL_CONFLICT_RULE);
557: if l_profile_value = 'SERVER_WINS' AND

Line 567: csm_util_pkg.log('UPWARD SYNC CONFLICT: CLIENT LOST: CSM_SERVICE_REQUESTS_PKG.APPLY_UPDATE: Incident_id = '

563: close c_last_update_date;
564: x_return_status := FND_API.G_RET_STS_ERROR;
565: p_error_msg := 'UPWARD SYNC CONFLICT: CLIENT LOST: CSM_SERVICE_REQUESTS_PKG.APPLY_UPDATE: Incident_id = '
566: || p_record.incident_id;
567: csm_util_pkg.log('UPWARD SYNC CONFLICT: CLIENT LOST: CSM_SERVICE_REQUESTS_PKG.APPLY_UPDATE: Incident_id = '
568: || p_record.incident_id,'CSM_SERVICE_REQUESTS_PKG.APPLY_UPDATE',FND_LOG.LEVEL_ERROR);
569: return;
570: end if;
571: else

Line 572: CSM_UTIL_PKG.LOG('No record found in Apps Database for incident_id ' || p_record.incident_id ,

568: || p_record.incident_id,'CSM_SERVICE_REQUESTS_PKG.APPLY_UPDATE',FND_LOG.LEVEL_ERROR);
569: return;
570: end if;
571: else
572: CSM_UTIL_PKG.LOG('No record found in Apps Database for incident_id ' || p_record.incident_id ,
573: 'CSM_SERVICE_REQUESTS_PKG.APPLY_UPDATE',FND_LOG.LEVEL_PROCEDURE);
574: end if;
575: close c_last_update_date;
576: end if;

Line 802: CSM_UTIL_PKG.LOG('Before calling CS_ServiceRequest_PUB.Update_ServiceRequest for ' || p_record.incident_id ,

798: l_sr_rec.external_attribute_14 := p_record.EXTERNAL_ATTRIBUTE_14;
799: l_sr_rec.external_attribute_15 := p_record.EXTERNAL_ATTRIBUTE_15;
800: l_sr_rec.external_context := p_record.EXTERNAL_CONTEXT;
801:
802: CSM_UTIL_PKG.LOG('Before calling CS_ServiceRequest_PUB.Update_ServiceRequest for ' || p_record.incident_id ,
803: 'CSM_SERVICE_REQUESTS_PKG.APPLY_UPDATE',FND_LOG.LEVEL_EVENT);
804:
805: -- Finally the update itself.
806: CS_ServiceRequest_PUB.Update_ServiceRequest

Line 827: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

823: , x_interaction_id => l_interaction_id
824: );
825:
826: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
827: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
828: (
829: p_api_error => TRUE
830: );
831: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_UPDATE:'

Line 831: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_UPDATE:'

827: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
828: (
829: p_api_error => TRUE
830: );
831: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_UPDATE:'
832: || ' ROOT ERROR: CS_ServiceRequest_PUB.Update_ServiceRequest ' || sqlerrm
833: || ' for incident_id ' || p_record.incident_id ,'CSM_SERVICE_REQUESTS_PKG.APPLY_UPDATE',FND_LOG.LEVEL_ERROR);
834: x_return_status := FND_API.G_RET_STS_ERROR;
835: RETURN;

Line 838: CSM_UTIL_PKG.LOG('Leaving CSM_SERVICE_REQUESTS_PKG.APPLY_UPDATE for incident_id ' || p_record.incident_id ,

834: x_return_status := FND_API.G_RET_STS_ERROR;
835: RETURN;
836: END IF;
837:
838: CSM_UTIL_PKG.LOG('Leaving CSM_SERVICE_REQUESTS_PKG.APPLY_UPDATE for incident_id ' || p_record.incident_id ,
839: 'CSM_SERVICE_REQUESTS_PKG.APPLY_UPDATE',FND_LOG.LEVEL_PROCEDURE);
840:
841: EXCEPTION WHEN OTHERS THEN
842: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_UPDATE', sqlerrm);

Line 843: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

839: 'CSM_SERVICE_REQUESTS_PKG.APPLY_UPDATE',FND_LOG.LEVEL_PROCEDURE);
840:
841: EXCEPTION WHEN OTHERS THEN
842: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_UPDATE', sqlerrm);
843: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
844: (
845: p_api_error => TRUE
846: );
847: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_UPDATE: ' || sqlerrm

Line 847: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_UPDATE: ' || sqlerrm

843: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
844: (
845: p_api_error => TRUE
846: );
847: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_UPDATE: ' || sqlerrm
848: || ' for incident_id ' || p_record.incident_id ,'CSM_SERVICE_REQUESTS_PKG.APPLY_UPDATE',FND_LOG.LEVEL_EXCEPTION);
849:
850: x_return_status := FND_API.G_RET_STS_ERROR;
851: END APPLY_UPDATE;

Line 869: CSM_UTIL_PKG.LOG('Entering CSM_SERVICE_REQUESTS_PKG.APPLY_RECORD for incident_id ' || p_record.incident_id ,

865: /*** initialize return status and message list ***/
866: x_return_status := FND_API.G_RET_STS_SUCCESS;
867: FND_MSG_PUB.INITIALIZE;
868:
869: CSM_UTIL_PKG.LOG('Entering CSM_SERVICE_REQUESTS_PKG.APPLY_RECORD for incident_id ' || p_record.incident_id ,
870: 'CSM_SERVICE_REQUESTS_PKG.APPLY_RECORD',FND_LOG.LEVEL_PROCEDURE);
871:
872: IF p_record.dmltype$$='I' THEN
873: -- Process insert

Line 889: CSM_UTIL_PKG.LOG

885: p_error_msg,
886: x_return_status
887: );
888: ELSIF p_record.dmltype$$='D' THEN
889: CSM_UTIL_PKG.LOG
890: ( 'Delete is not supported for this entity'
891: || ' for Incident_id ' || p_record.incident_id ,'CSM_SERVICE_REQUESTS_PKG.APPLY_RECORD',FND_LOG.LEVEL_ERROR);
892:
893: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

Line 893: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

889: CSM_UTIL_PKG.LOG
890: ( 'Delete is not supported for this entity'
891: || ' for Incident_id ' || p_record.incident_id ,'CSM_SERVICE_REQUESTS_PKG.APPLY_RECORD',FND_LOG.LEVEL_ERROR);
892:
893: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
894: (
895: p_message => 'CSM_DML_OPERATION'
896: , p_token_name1 => 'DML'
897: , p_token_value1 => p_record.dmltype$$

Line 903: CSM_UTIL_PKG.LOG

899:
900: x_return_status := FND_API.G_RET_STS_ERROR;
901: ELSE
902: -- invalid dml type
903: CSM_UTIL_PKG.LOG
904: ( 'Invalid DML type: ' || p_record.dmltype$$ || ' is not supported for this entity'
905: || ' for Incident_id ' || p_record.incident_id ,'CSM_SERVICE_REQUESTS_PKG.APPLY_RECORD',FND_LOG.LEVEL_ERROR);
906:
907: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

Line 907: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

903: CSM_UTIL_PKG.LOG
904: ( 'Invalid DML type: ' || p_record.dmltype$$ || ' is not supported for this entity'
905: || ' for Incident_id ' || p_record.incident_id ,'CSM_SERVICE_REQUESTS_PKG.APPLY_RECORD',FND_LOG.LEVEL_ERROR);
906:
907: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
908: (
909: p_message => 'CSM_DML_OPERATION'
910: , p_token_name1 => 'DML'
911: , p_token_value1 => p_record.dmltype$$

Line 917: CSM_UTIL_PKG.LOG('Leaving CSM_SERVICE_REQUESTS_PKG.APPLY_RECORD for incident_id ' || p_record.incident_id ,

913:
914: x_return_status := FND_API.G_RET_STS_ERROR;
915: END IF;
916:
917: CSM_UTIL_PKG.LOG('Leaving CSM_SERVICE_REQUESTS_PKG.APPLY_RECORD for incident_id ' || p_record.incident_id ,
918: 'CSM_SERVICE_REQUESTS_PKG.APPLY_RECORD',FND_LOG.LEVEL_PROCEDURE);
919: EXCEPTION WHEN OTHERS THEN
920: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_RECORD', sqlerrm);
921: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

Line 921: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

917: CSM_UTIL_PKG.LOG('Leaving CSM_SERVICE_REQUESTS_PKG.APPLY_RECORD for incident_id ' || p_record.incident_id ,
918: 'CSM_SERVICE_REQUESTS_PKG.APPLY_RECORD',FND_LOG.LEVEL_PROCEDURE);
919: EXCEPTION WHEN OTHERS THEN
920: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_RECORD', sqlerrm);
921: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
922: (
923: p_api_error => TRUE
924: );
925: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_RECORD: ' || sqlerrm

Line 925: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_RECORD: ' || sqlerrm

921: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
922: (
923: p_api_error => TRUE
924: );
925: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_RECORD: ' || sqlerrm
926: || ' for incident_id ' || p_record.incident_id ,'CSM_SERVICE_REQUESTS_PKG.APPLY_RECORD',FND_LOG.LEVEL_EXCEPTION);
927:
928: x_return_status := FND_API.G_RET_STS_ERROR;
929:

Line 950: CSM_UTIL_PKG.LOG('Entering CSM_SERVICE_REQUESTS_PKG.APPLY_CLIENT_CHANGES ',

946: l_process_status VARCHAR2(1);
947: l_error_msg VARCHAR2(4000);
948:
949: BEGIN
950: CSM_UTIL_PKG.LOG('Entering CSM_SERVICE_REQUESTS_PKG.APPLY_CLIENT_CHANGES ',
951: 'CSM_SERVICE_REQUESTS_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_PROCEDURE);
952: g_debug_level := p_debug_level;
953: x_return_status := FND_API.G_RET_STS_SUCCESS;
954:

Line 969: CSM_UTIL_PKG.DELETE_RECORD

965:
966: /*** was record processed successfully? ***/
967: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN
968: /*** Yes -> delete record from inqueue ***/
969: CSM_UTIL_PKG.DELETE_RECORD
970: (
971: p_user_name,
972: p_tranid,
973: r_incident.seqno$$,

Line 983: CSM_UTIL_PKG.LOG

979: );
980: /*** was delete successful? ***/
981: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
982: /*** no -> rollback ***/
983: CSM_UTIL_PKG.LOG
984: ( 'Deleting from inqueue failed, rolling back to savepoint'
985: || ' for incident_id ' || r_incident.incident_id ,'CSM_SERVICE_REQUESTS_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR); -- put PK column here
986: ROLLBACK TO save_rec;
987: x_return_status := FND_API.G_RET_STS_ERROR;

Line 992: CSM_UTIL_PKG.DELETE_RECORD

988: ELSE
989: /*** Yes -> Delete contact recs */
990: FOR r_contacts IN c_contact( r_incident.incident_id, p_tranid, p_user_name ) LOOP
991: /* Delete matching contact record(s) */
992: CSM_UTIL_PKG.DELETE_RECORD
993: (
994: p_user_name,
995: p_tranid,
996: r_contacts.seqno$$,

Line 1006: CSM_UTIL_PKG.LOG

1002: );
1003: /*** was delete successful? ***/
1004: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
1005: /*** no -> rollback ***/
1006: CSM_UTIL_PKG.LOG
1007: ( 'Deleting from inqueue failed, rolling back to savepoint'
1008: || ' for incident_id ' || r_incident.incident_id ,'CSM_SERVICE_REQUESTS_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR); -- put PK column here
1009: ROLLBACK TO save_rec;
1010: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1016: csm_util_pkg.log( 'Record not processed successfully, deferring and rejecting record'

1012: END LOOP;
1013: END IF;
1014: ELSIF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN
1015: /*** Record was not applied successfully -> defer and reject records ***/
1016: csm_util_pkg.log( 'Record not processed successfully, deferring and rejecting record'
1017: || ' for PK ' || r_incident.incident_id ,'CSM_SERVICE_REQUESTS_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR); -- put PK column here
1018:
1019: CSM_UTIL_PKG.DEFER_RECORD
1020: (

Line 1019: CSM_UTIL_PKG.DEFER_RECORD

1015: /*** Record was not applied successfully -> defer and reject records ***/
1016: csm_util_pkg.log( 'Record not processed successfully, deferring and rejecting record'
1017: || ' for PK ' || r_incident.incident_id ,'CSM_SERVICE_REQUESTS_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR); -- put PK column here
1018:
1019: CSM_UTIL_PKG.DEFER_RECORD
1020: (
1021: p_user_name
1022: , p_tranid
1023: , r_incident.seqno$$

Line 1035: CSM_UTIL_PKG.LOG

1031:
1032: /*** Was defer successful? ***/
1033: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
1034: /*** no -> rollback ***/
1035: CSM_UTIL_PKG.LOG
1036: ( 'Defer record failed, rolling back to savepoint'
1037: || ' for PK ' || r_incident.incident_id ,'CSM_SERVICE_REQUESTS_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR); -- put PK column here
1038: ROLLBACK TO save_rec;
1039: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1044: CSM_UTIL_PKG.DEFER_RECORD

1040: ELSE
1041: /** Yes **/
1042: FOR r_contacts IN c_contact( r_incident.incident_id, p_tranid, p_user_name ) LOOP
1043: /* Defer matching contact record(s) */
1044: CSM_UTIL_PKG.DEFER_RECORD
1045: (
1046: p_user_name,
1047: p_tranid,
1048: r_contacts.seqno$$,

Line 1063: CSM_UTIL_PKG.LOG('Leaving CSM_SERVICE_REQUESTS_PKG.APPLY_CLIENT_CHANGES',

1059: END IF;
1060:
1061: END LOOP;
1062:
1063: CSM_UTIL_PKG.LOG('Leaving CSM_SERVICE_REQUESTS_PKG.APPLY_CLIENT_CHANGES',
1064: 'CSM_SERVICE_REQUESTS_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_PROCEDURE);
1065:
1066: EXCEPTION WHEN OTHERS THEN
1067: /*** catch and log exceptions ***/

Line 1068: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_CLIENT_CHANGES: ' || sqlerrm

1064: 'CSM_SERVICE_REQUESTS_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_PROCEDURE);
1065:
1066: EXCEPTION WHEN OTHERS THEN
1067: /*** catch and log exceptions ***/
1068: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_CLIENT_CHANGES: ' || sqlerrm
1069: ,'CSM_SERVICE_REQUESTS_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_EXCEPTION);
1070:
1071: x_return_status := FND_API.G_RET_STS_ERROR;
1072:

Line 1094: CSM_UTIL_PKG.LOG('Entering CSM_SERVICE_REQUESTS_PKG.CONFLICT_RESOLUTION_METHOD for user ' || p_user_name ,'CSM_SERVICE_REQUESTS_PKG.CONFLICT_RESOLUTION_METHOD',FND_LOG.LEVEL_PROCEDURE);

1090: AND seqno$$ = l_sequence
1091: AND a.incident_id = b.incident_id ;
1092:
1093: BEGIN
1094: CSM_UTIL_PKG.LOG('Entering CSM_SERVICE_REQUESTS_PKG.CONFLICT_RESOLUTION_METHOD for user ' || p_user_name ,'CSM_SERVICE_REQUESTS_PKG.CONFLICT_RESOLUTION_METHOD',FND_LOG.LEVEL_PROCEDURE);
1095: l_profile_value := fnd_profile.value(csm_profile_pkg.g_JTM_APPL_CONFLICT_RULE);
1096: OPEN get_user_id(p_tran_id, p_user_name, p_sequence) ;
1097: FETCH get_user_id
1098: INTO l_user_id ;