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 148: CSM_UTIL_PKG.LOG('Entering CSM_SERVICE_REQUESTS_PKG.APPLY_INSERT for incident_id ' || p_record.incident_id ,

144: l_auto_generate_task VARCHAR2(255);
145:
146: BEGIN
147:
148: CSM_UTIL_PKG.LOG('Entering CSM_SERVICE_REQUESTS_PKG.APPLY_INSERT for incident_id ' || p_record.incident_id ,
149: 'CSM_SERVICE_REQUESTS_PKG.APPLY_INSERT',FND_LOG.LEVEL_PROCEDURE);
150:
151: l_user_id := JTM_HOOK_UTIL_PKG.Get_User_Id( p_record.CLID$$CS );
152: l_created_by := p_record.CREATED_BY;

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

331: l_contacts_tab( l_contact_index ) := l_contact_rec;
332: END LOOP;
333:
334:
335: CSM_UTIL_PKG.LOG('Before calling CS_ServiceRequest_PUB.Create_ServiceRequest for ' || p_record.incident_id ,
336: 'CSM_SERVICE_REQUESTS_PKG.APPLY_INSERT',FND_LOG.LEVEL_EVENT);
337:
338: /* Calling CS API for actual insert */
339: CS_ServiceRequest_PUB.Create_ServiceRequest

Line 362: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

358: );
359:
360: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
361: /*** exception occurred in API -> return errmsg ***/
362: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
363: (
364: p_api_error => TRUE
365: );
366: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_INSERT:'

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

362: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
363: (
364: p_api_error => TRUE
365: );
366: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_INSERT:'
367: || ' ROOT ERROR: CS_ServiceRequest_PUB.Create_ServiceRequest ' || sqlerrm
368: || ' for incident_id ' || p_record.incident_id,'CSM_SERVICE_REQUESTS_PKG.APPLY_INSERT',FND_LOG.LEVEL_ERROR);
369: x_return_status := FND_API.G_RET_STS_ERROR;
370: return;

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

368: || ' for incident_id ' || p_record.incident_id,'CSM_SERVICE_REQUESTS_PKG.APPLY_INSERT',FND_LOG.LEVEL_ERROR);
369: x_return_status := FND_API.G_RET_STS_ERROR;
370: return;
371: END IF;
372: CSM_UTIL_PKG.LOG('Leaving CSM_SERVICE_REQUESTS_PKG.APPLY_INSERT for incident_id ' || p_record.incident_id ,
373: 'CSM_SERVICE_REQUESTS_PKG.APPLY_INSERT',FND_LOG.LEVEL_PROCEDURE);
374:
375: EXCEPTION WHEN OTHERS THEN
376: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_INSERT', sqlerrm);

Line 377: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

373: 'CSM_SERVICE_REQUESTS_PKG.APPLY_INSERT',FND_LOG.LEVEL_PROCEDURE);
374:
375: EXCEPTION WHEN OTHERS THEN
376: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_INSERT', sqlerrm);
377: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
378: (
379: p_api_error => TRUE
380: );
381: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_INSERT: ' || sqlerrm

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

377: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
378: (
379: p_api_error => TRUE
380: );
381: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_INSERT: ' || sqlerrm
382: || ' for incident_id ' || p_record.incident_id ,'CSM_SERVICE_REQUESTS_PKG.APPLY_INSERT',FND_LOG.LEVEL_EXCEPTION);
383:
384: IF c_customer_account%ISOPEN THEN
385: CLOSE c_customer_account;

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

451: l_party_type VARCHAR2(30);
452:
453: BEGIN
454:
455: CSM_UTIL_PKG.LOG('Entering CSM_SERVICE_REQUESTS_PKG.APPLY_UPDATE for incident_id ' || p_record.incident_id ,
456: 'CSM_SERVICE_REQUESTS_PKG.APPLY_UPDATE',FND_LOG.LEVEL_PROCEDURE);
457: -- Check for Stale data
458: l_profile_value := fnd_profile.value(csm_profile_pkg.g_JTM_APPL_CONFLICT_RULE);
459: if l_profile_value = 'SERVER_WINS' AND

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

465: close c_last_update_date;
466: x_return_status := FND_API.G_RET_STS_ERROR;
467: p_error_msg := 'UPWARD SYNC CONFLICT: CLIENT LOST: CSM_SERVICE_REQUESTS_PKG.APPLY_UPDATE: Incident_id = '
468: || p_record.incident_id;
469: csm_util_pkg.log('UPWARD SYNC CONFLICT: CLIENT LOST: CSM_SERVICE_REQUESTS_PKG.APPLY_UPDATE: Incident_id = '
470: || p_record.incident_id,'CSM_SERVICE_REQUESTS_PKG.APPLY_UPDATE',FND_LOG.LEVEL_ERROR);
471: return;
472: end if;
473: else

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

470: || p_record.incident_id,'CSM_SERVICE_REQUESTS_PKG.APPLY_UPDATE',FND_LOG.LEVEL_ERROR);
471: return;
472: end if;
473: else
474: CSM_UTIL_PKG.LOG('No record found in Apps Database for incident_id ' || p_record.incident_id ,
475: 'CSM_SERVICE_REQUESTS_PKG.APPLY_UPDATE',FND_LOG.LEVEL_PROCEDURE);
476: end if;
477: close c_last_update_date;
478: end if;

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

659: --added for CS 11.5.10
660: l_sr_rec.incident_location_id := p_record.incident_location_id;
661: l_sr_rec.incident_location_type := nvl(p_record.incident_location_type, 'HZ_PARTY_SITE');
662:
663: CSM_UTIL_PKG.LOG('Before calling CS_ServiceRequest_PUB.Update_ServiceRequest for ' || p_record.incident_id ,
664: 'CSM_SERVICE_REQUESTS_PKG.APPLY_UPDATE',FND_LOG.LEVEL_EVENT);
665:
666: -- Finally the update itself.
667: CS_ServiceRequest_PUB.Update_ServiceRequest

Line 688: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

684: , x_interaction_id => l_interaction_id
685: );
686:
687: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
688: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
689: (
690: p_api_error => TRUE
691: );
692: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_UPDATE:'

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

688: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
689: (
690: p_api_error => TRUE
691: );
692: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_UPDATE:'
693: || ' ROOT ERROR: CS_ServiceRequest_PUB.Update_ServiceRequest ' || sqlerrm
694: || ' for incident_id ' || p_record.incident_id ,'CSM_SERVICE_REQUESTS_PKG.APPLY_UPDATE',FND_LOG.LEVEL_ERROR);
695: x_return_status := FND_API.G_RET_STS_ERROR;
696: RETURN;

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

695: x_return_status := FND_API.G_RET_STS_ERROR;
696: RETURN;
697: END IF;
698:
699: CSM_UTIL_PKG.LOG('Leaving CSM_SERVICE_REQUESTS_PKG.APPLY_UPDATE for incident_id ' || p_record.incident_id ,
700: 'CSM_SERVICE_REQUESTS_PKG.APPLY_UPDATE',FND_LOG.LEVEL_PROCEDURE);
701:
702: EXCEPTION WHEN OTHERS THEN
703: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_UPDATE', sqlerrm);

Line 704: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

700: 'CSM_SERVICE_REQUESTS_PKG.APPLY_UPDATE',FND_LOG.LEVEL_PROCEDURE);
701:
702: EXCEPTION WHEN OTHERS THEN
703: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_UPDATE', sqlerrm);
704: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
705: (
706: p_api_error => TRUE
707: );
708: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_UPDATE: ' || sqlerrm

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

704: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
705: (
706: p_api_error => TRUE
707: );
708: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_UPDATE: ' || sqlerrm
709: || ' for incident_id ' || p_record.incident_id ,'CSM_SERVICE_REQUESTS_PKG.APPLY_UPDATE',FND_LOG.LEVEL_EXCEPTION);
710:
711: x_return_status := FND_API.G_RET_STS_ERROR;
712: END APPLY_UPDATE;

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

726: /*** initialize return status and message list ***/
727: x_return_status := FND_API.G_RET_STS_SUCCESS;
728: FND_MSG_PUB.INITIALIZE;
729:
730: CSM_UTIL_PKG.LOG('Entering CSM_SERVICE_REQUESTS_PKG.APPLY_RECORD for incident_id ' || p_record.incident_id ,
731: 'CSM_SERVICE_REQUESTS_PKG.APPLY_RECORD',FND_LOG.LEVEL_PROCEDURE);
732:
733: IF p_record.dmltype$$='I' THEN
734: -- Process insert

Line 750: CSM_UTIL_PKG.LOG

746: p_error_msg,
747: x_return_status
748: );
749: ELSIF p_record.dmltype$$='D' THEN
750: CSM_UTIL_PKG.LOG
751: ( 'Delete is not supported for this entity'
752: || ' for Incident_id ' || p_record.incident_id ,'CSM_SERVICE_REQUESTS_PKG.APPLY_RECORD',FND_LOG.LEVEL_ERROR);
753:
754: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

Line 754: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

750: CSM_UTIL_PKG.LOG
751: ( 'Delete is not supported for this entity'
752: || ' for Incident_id ' || p_record.incident_id ,'CSM_SERVICE_REQUESTS_PKG.APPLY_RECORD',FND_LOG.LEVEL_ERROR);
753:
754: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
755: (
756: p_message => 'CSM_DML_OPERATION'
757: , p_token_name1 => 'DML'
758: , p_token_value1 => p_record.dmltype$$

Line 764: CSM_UTIL_PKG.LOG

760:
761: x_return_status := FND_API.G_RET_STS_ERROR;
762: ELSE
763: -- invalid dml type
764: CSM_UTIL_PKG.LOG
765: ( 'Invalid DML type: ' || p_record.dmltype$$ || ' is not supported for this entity'
766: || ' for Incident_id ' || p_record.incident_id ,'CSM_SERVICE_REQUESTS_PKG.APPLY_RECORD',FND_LOG.LEVEL_ERROR);
767:
768: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

Line 768: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

764: CSM_UTIL_PKG.LOG
765: ( 'Invalid DML type: ' || p_record.dmltype$$ || ' is not supported for this entity'
766: || ' for Incident_id ' || p_record.incident_id ,'CSM_SERVICE_REQUESTS_PKG.APPLY_RECORD',FND_LOG.LEVEL_ERROR);
767:
768: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
769: (
770: p_message => 'CSM_DML_OPERATION'
771: , p_token_name1 => 'DML'
772: , p_token_value1 => p_record.dmltype$$

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

774:
775: x_return_status := FND_API.G_RET_STS_ERROR;
776: END IF;
777:
778: CSM_UTIL_PKG.LOG('Leaving CSM_SERVICE_REQUESTS_PKG.APPLY_RECORD for incident_id ' || p_record.incident_id ,
779: 'CSM_SERVICE_REQUESTS_PKG.APPLY_RECORD',FND_LOG.LEVEL_PROCEDURE);
780: EXCEPTION WHEN OTHERS THEN
781: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_RECORD', sqlerrm);
782: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

Line 782: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

778: CSM_UTIL_PKG.LOG('Leaving CSM_SERVICE_REQUESTS_PKG.APPLY_RECORD for incident_id ' || p_record.incident_id ,
779: 'CSM_SERVICE_REQUESTS_PKG.APPLY_RECORD',FND_LOG.LEVEL_PROCEDURE);
780: EXCEPTION WHEN OTHERS THEN
781: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_RECORD', sqlerrm);
782: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
783: (
784: p_api_error => TRUE
785: );
786: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_RECORD: ' || sqlerrm

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

782: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
783: (
784: p_api_error => TRUE
785: );
786: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_RECORD: ' || sqlerrm
787: || ' for incident_id ' || p_record.incident_id ,'CSM_SERVICE_REQUESTS_PKG.APPLY_RECORD',FND_LOG.LEVEL_EXCEPTION);
788:
789: x_return_status := FND_API.G_RET_STS_ERROR;
790:

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

807: l_process_status VARCHAR2(1);
808: l_error_msg VARCHAR2(4000);
809:
810: BEGIN
811: CSM_UTIL_PKG.LOG('Entering CSM_SERVICE_REQUESTS_PKG.APPLY_CLIENT_CHANGES ',
812: 'CSM_SERVICE_REQUESTS_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_PROCEDURE);
813: g_debug_level := p_debug_level;
814: x_return_status := FND_API.G_RET_STS_SUCCESS;
815:

Line 830: CSM_UTIL_PKG.DELETE_RECORD

826:
827: /*** was record processed successfully? ***/
828: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN
829: /*** Yes -> delete record from inqueue ***/
830: CSM_UTIL_PKG.DELETE_RECORD
831: (
832: p_user_name,
833: p_tranid,
834: r_incident.seqno$$,

Line 844: CSM_UTIL_PKG.LOG

840: );
841: /*** was delete successful? ***/
842: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
843: /*** no -> rollback ***/
844: CSM_UTIL_PKG.LOG
845: ( 'Deleting from inqueue failed, rolling back to savepoint'
846: || ' for incident_id ' || r_incident.incident_id ,'CSM_SERVICE_REQUESTS_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR); -- put PK column here
847: ROLLBACK TO save_rec;
848: x_return_status := FND_API.G_RET_STS_ERROR;

Line 853: CSM_UTIL_PKG.DELETE_RECORD

849: ELSE
850: /*** Yes -> Delete contact recs */
851: FOR r_contacts IN c_contact( r_incident.incident_id, p_tranid, p_user_name ) LOOP
852: /* Delete matching contact record(s) */
853: CSM_UTIL_PKG.DELETE_RECORD
854: (
855: p_user_name,
856: p_tranid,
857: r_contacts.seqno$$,

Line 867: CSM_UTIL_PKG.LOG

863: );
864: /*** was delete successful? ***/
865: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
866: /*** no -> rollback ***/
867: CSM_UTIL_PKG.LOG
868: ( 'Deleting from inqueue failed, rolling back to savepoint'
869: || ' for incident_id ' || r_incident.incident_id ,'CSM_SERVICE_REQUESTS_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR); -- put PK column here
870: ROLLBACK TO save_rec;
871: x_return_status := FND_API.G_RET_STS_ERROR;

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

873: END LOOP;
874: END IF;
875: ELSIF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN
876: /*** Record was not applied successfully -> defer and reject records ***/
877: csm_util_pkg.log( 'Record not processed successfully, deferring and rejecting record'
878: || ' for PK ' || r_incident.incident_id ,'CSM_SERVICE_REQUESTS_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR); -- put PK column here
879:
880: CSM_UTIL_PKG.DEFER_RECORD
881: (

Line 880: CSM_UTIL_PKG.DEFER_RECORD

876: /*** Record was not applied successfully -> defer and reject records ***/
877: csm_util_pkg.log( 'Record not processed successfully, deferring and rejecting record'
878: || ' for PK ' || r_incident.incident_id ,'CSM_SERVICE_REQUESTS_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR); -- put PK column here
879:
880: CSM_UTIL_PKG.DEFER_RECORD
881: (
882: p_user_name
883: , p_tranid
884: , r_incident.seqno$$

Line 896: CSM_UTIL_PKG.LOG

892:
893: /*** Was defer successful? ***/
894: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
895: /*** no -> rollback ***/
896: CSM_UTIL_PKG.LOG
897: ( 'Defer record failed, rolling back to savepoint'
898: || ' for PK ' || r_incident.incident_id ,'CSM_SERVICE_REQUESTS_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR); -- put PK column here
899: ROLLBACK TO save_rec;
900: x_return_status := FND_API.G_RET_STS_ERROR;

Line 905: CSM_UTIL_PKG.DEFER_RECORD

901: ELSE
902: /** Yes **/
903: FOR r_contacts IN c_contact( r_incident.incident_id, p_tranid, p_user_name ) LOOP
904: /* Defer matching contact record(s) */
905: CSM_UTIL_PKG.DEFER_RECORD
906: (
907: p_user_name,
908: p_tranid,
909: r_contacts.seqno$$,

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

920: END IF;
921:
922: END LOOP;
923:
924: CSM_UTIL_PKG.LOG('Leaving CSM_SERVICE_REQUESTS_PKG.APPLY_CLIENT_CHANGES',
925: 'CSM_SERVICE_REQUESTS_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_PROCEDURE);
926:
927: EXCEPTION WHEN OTHERS THEN
928: /*** catch and log exceptions ***/

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

925: 'CSM_SERVICE_REQUESTS_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_PROCEDURE);
926:
927: EXCEPTION WHEN OTHERS THEN
928: /*** catch and log exceptions ***/
929: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_CLIENT_CHANGES: ' || sqlerrm
930: ,'CSM_SERVICE_REQUESTS_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_EXCEPTION);
931:
932: x_return_status := FND_API.G_RET_STS_ERROR;
933:

Line 955: 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);

951: AND seqno$$ = l_sequence
952: AND a.incident_id = b.incident_id ;
953:
954: BEGIN
955: 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);
956: l_profile_value := fnd_profile.value(csm_profile_pkg.g_JTM_APPL_CONFLICT_RULE);
957: OPEN get_user_id(p_tran_id, p_user_name, p_sequence) ;
958: FETCH get_user_id
959: INTO l_user_id ;