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 FND_LOG

Line 180: 'CSM_SERVICE_REQUESTS_PKG.APPLY_INSERT',FND_LOG.LEVEL_PROCEDURE);

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;
184: l_resp_id := TO_NUMBER(fnd_profile.value('CSM_SR_CREATE_RESP'));

Line 444: 'CSM_SERVICE_REQUESTS_PKG.APPLY_INSERT',FND_LOG.LEVEL_EVENT);

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
448: ( p_api_version => 4.0

Line 476: || ' for incident_id ' || p_record.incident_id,'CSM_SERVICE_REQUESTS_PKG.APPLY_INSERT',FND_LOG.LEVEL_ERROR);

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;
479: END IF;
480: CSM_UTIL_PKG.LOG('Leaving CSM_SERVICE_REQUESTS_PKG.APPLY_INSERT for incident_id ' || p_record.incident_id ,

Line 481: 'CSM_SERVICE_REQUESTS_PKG.APPLY_INSERT',FND_LOG.LEVEL_PROCEDURE);

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);
485: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

Line 490: || ' for incident_id ' || p_record.incident_id ,'CSM_SERVICE_REQUESTS_PKG.APPLY_INSERT',FND_LOG.LEVEL_EXCEPTION);

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;
494: END IF;

Line 554: 'CSM_SERVICE_REQUESTS_PKG.APPLY_UPDATE',FND_LOG.LEVEL_PROCEDURE);

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
558: ASG_DEFER.IS_DEFERRED(p_record.clid$$cs, p_record.tranid$$,g_pub_name, p_record.seqno$$) <> FND_API.G_TRUE then

Line 568: || p_record.incident_id,'CSM_SERVICE_REQUESTS_PKG.APPLY_UPDATE',FND_LOG.LEVEL_ERROR);

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
572: CSM_UTIL_PKG.LOG('No record found in Apps Database for incident_id ' || p_record.incident_id ,

Line 573: 'CSM_SERVICE_REQUESTS_PKG.APPLY_UPDATE',FND_LOG.LEVEL_PROCEDURE);

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;
577:

Line 803: 'CSM_SERVICE_REQUESTS_PKG.APPLY_UPDATE',FND_LOG.LEVEL_EVENT);

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
807: ( p_api_version => 3.0

Line 833: || ' for incident_id ' || p_record.incident_id ,'CSM_SERVICE_REQUESTS_PKG.APPLY_UPDATE',FND_LOG.LEVEL_ERROR);

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;
836: END IF;
837:

Line 839: 'CSM_SERVICE_REQUESTS_PKG.APPLY_UPDATE',FND_LOG.LEVEL_PROCEDURE);

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);
843: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

Line 848: || ' for incident_id ' || p_record.incident_id ,'CSM_SERVICE_REQUESTS_PKG.APPLY_UPDATE',FND_LOG.LEVEL_EXCEPTION);

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;
852:

Line 870: 'CSM_SERVICE_REQUESTS_PKG.APPLY_RECORD',FND_LOG.LEVEL_PROCEDURE);

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
874: APPLY_INSERT

Line 891: || ' for Incident_id ' || p_record.incident_id ,'CSM_SERVICE_REQUESTS_PKG.APPLY_RECORD',FND_LOG.LEVEL_ERROR);

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
894: (
895: p_message => 'CSM_DML_OPERATION'

Line 905: || ' for Incident_id ' || p_record.incident_id ,'CSM_SERVICE_REQUESTS_PKG.APPLY_RECORD',FND_LOG.LEVEL_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
908: (
909: p_message => 'CSM_DML_OPERATION'

Line 918: 'CSM_SERVICE_REQUESTS_PKG.APPLY_RECORD',FND_LOG.LEVEL_PROCEDURE);

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
922: (

Line 926: || ' for incident_id ' || p_record.incident_id ,'CSM_SERVICE_REQUESTS_PKG.APPLY_RECORD',FND_LOG.LEVEL_EXCEPTION);

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:
930: END APPLY_RECORD;

Line 951: 'CSM_SERVICE_REQUESTS_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_PROCEDURE);

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:
955: /*** loop through CSM_INCIDENTS_ALL_INQ records in inqueue ***/

Line 985: || ' for incident_id ' || r_incident.incident_id ,'CSM_SERVICE_REQUESTS_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR); -- put PK column here

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;
988: ELSE
989: /*** Yes -> Delete contact recs */

Line 1008: || ' for incident_id ' || r_incident.incident_id ,'CSM_SERVICE_REQUESTS_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR); -- put PK column here

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;
1011: END IF;
1012: END LOOP;

Line 1017: || ' for PK ' || r_incident.incident_id ,'CSM_SERVICE_REQUESTS_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR); -- put PK column here

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: (
1021: p_user_name

Line 1037: || ' for PK ' || r_incident.incident_id ,'CSM_SERVICE_REQUESTS_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR); -- put PK column here

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;
1040: ELSE
1041: /** Yes **/

Line 1064: 'CSM_SERVICE_REQUESTS_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_PROCEDURE);

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 ***/
1068: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_CLIENT_CHANGES: ' || sqlerrm

Line 1069: ,'CSM_SERVICE_REQUESTS_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_EXCEPTION);

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:
1073: END APPLY_CLIENT_CHANGES;

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 ;