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_API

Line 341: , p_init_msg_list => FND_API.G_TRUE

337:
338: /* Calling CS API for actual insert */
339: CS_ServiceRequest_PUB.Create_ServiceRequest
340: ( p_api_version => 4.0
341: , p_init_msg_list => FND_API.G_TRUE
342: , p_commit => FND_API.G_TRUE
343: , x_return_status => x_return_status
344: , x_msg_count => l_msg_count
345: , x_msg_data => l_msg_data

Line 342: , p_commit => FND_API.G_TRUE

338: /* Calling CS API for actual insert */
339: CS_ServiceRequest_PUB.Create_ServiceRequest
340: ( p_api_version => 4.0
341: , p_init_msg_list => FND_API.G_TRUE
342: , p_commit => FND_API.G_TRUE
343: , x_return_status => x_return_status
344: , x_msg_count => l_msg_count
345: , x_msg_data => l_msg_data
346: , p_user_id => l_created_by

Line 360: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

356: , p_auto_assign => 'Y'
357: , x_sr_create_out_rec => l_sr_out_rec
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

Line 369: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 388: x_return_status := FND_API.G_RET_STS_ERROR;

384: IF c_customer_account%ISOPEN THEN
385: CLOSE c_customer_account;
386: END IF;
387:
388: x_return_status := FND_API.G_RET_STS_ERROR;
389: END APPLY_INSERT;
390:
391: /***
392: This procedure is called by APPLY_CLIENT_CHANGES when an updated record is to be processed.

Line 460: ASG_DEFER.IS_DEFERRED(p_record.clid$$cs, p_record.tranid$$,g_pub_name, p_record.seqno$$) <> FND_API.G_TRUE then

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
461: open c_last_update_date(b_incident_id => p_record.incident_id);
462: fetch c_last_update_date into r_last_update_date;
463: if c_last_update_date%found then
464: if r_last_update_date.last_update_date <> p_record.server_last_update_date and r_last_update_date.last_updated_by <> asg_base.get_user_id(p_record.clid$$cs) then

Line 466: x_return_status := FND_API.G_RET_STS_ERROR;

462: fetch c_last_update_date into r_last_update_date;
463: if c_last_update_date%found then
464: if r_last_update_date.last_update_date <> p_record.server_last_update_date and r_last_update_date.last_updated_by <> asg_base.get_user_id(p_record.clid$$cs) then
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);

Line 512: l_ovn := FND_API.G_MISS_NUM;

508: then
509: l_ovn := r_ovn.object_version_number;
510: else
511: -- Let the API complain.
512: l_ovn := FND_API.G_MISS_NUM;
513: end if;
514: close c_ovn;
515:
516: --ANURAG

Line 669: , p_init_msg_list => FND_API.G_TRUE

665:
666: -- Finally the update itself.
667: CS_ServiceRequest_PUB.Update_ServiceRequest
668: ( p_api_version => 3.0
669: , p_init_msg_list => FND_API.G_TRUE
670: , p_commit => FND_API.G_TRUE
671: , x_return_status => x_return_status
672: , x_msg_count => l_msg_count
673: , x_msg_data => l_msg_data

Line 670: , p_commit => FND_API.G_TRUE

666: -- Finally the update itself.
667: CS_ServiceRequest_PUB.Update_ServiceRequest
668: ( p_api_version => 3.0
669: , p_init_msg_list => FND_API.G_TRUE
670: , p_commit => FND_API.G_TRUE
671: , x_return_status => x_return_status
672: , x_msg_count => l_msg_count
673: , x_msg_data => l_msg_data
674: , p_request_id => p_record.incident_id

Line 687: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

683: , x_workflow_process_id => l_workflow_id
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: );

Line 695: x_return_status := FND_API.G_RET_STS_ERROR;

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:
699: CSM_UTIL_PKG.LOG('Leaving CSM_SERVICE_REQUESTS_PKG.APPLY_UPDATE for incident_id ' || p_record.incident_id ,

Line 711: x_return_status := FND_API.G_RET_STS_ERROR;

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:
714: /***
715: This procedure is called by APPLY_CLIENT_CHANGES for every record in in-queue that needs to be processed.

Line 727: x_return_status := FND_API.G_RET_STS_SUCCESS;

723: l_rc BOOLEAN;
724: l_access_id NUMBER;
725: BEGIN
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);

Line 761: x_return_status := FND_API.G_RET_STS_ERROR;

757: , p_token_name1 => 'DML'
758: , p_token_value1 => p_record.dmltype$$
759: );
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'

Line 775: x_return_status := FND_API.G_RET_STS_ERROR;

771: , p_token_name1 => 'DML'
772: , p_token_value1 => p_record.dmltype$$
773: );
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);

Line 789: x_return_status := FND_API.G_RET_STS_ERROR;

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;
792:
793: /***

Line 814: x_return_status := FND_API.G_RET_STS_SUCCESS;

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 ***/
817: FOR r_incident IN c_incident( p_user_name, p_tranid) LOOP
818: SAVEPOINT save_rec ;

Line 828: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN

824: , l_process_status
825: );
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,

Line 842: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN

838: l_error_msg,
839: l_process_status
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

Line 848: x_return_status := FND_API.G_RET_STS_ERROR;

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 */
851: FOR r_contacts IN c_contact( r_incident.incident_id, p_tranid, p_user_name ) LOOP
852: /* Delete matching contact record(s) */

Line 865: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN

861: l_error_msg,
862: l_process_status
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

Line 871: x_return_status := FND_API.G_RET_STS_ERROR;

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;
874: END IF;
875: ELSIF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN

Line 875: ELSIF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN

871: x_return_status := FND_API.G_RET_STS_ERROR;
872: END IF;
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:

Line 894: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN

890: , r_incident.dmltype$$
891: );
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

Line 900: x_return_status := FND_API.G_RET_STS_ERROR;

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 **/
903: FOR r_contacts IN c_contact( r_incident.incident_id, p_tranid, p_user_name ) LOOP
904: /* Defer matching contact record(s) */

Line 932: x_return_status := FND_API.G_RET_STS_ERROR;

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;
935:
936: FUNCTION CONFLICT_RESOLUTION_METHOD (p_user_name IN VARCHAR2,