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 149: 'CSM_SERVICE_REQUESTS_PKG.APPLY_INSERT',FND_LOG.LEVEL_PROCEDURE);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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
755: (
756: p_message => 'CSM_DML_OPERATION'

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

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

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

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

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

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

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

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

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

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

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;
872: END IF;
873: END LOOP;

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

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

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

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;
901: ELSE
902: /** Yes **/

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

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

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

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

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 ;