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 CS_SERVICEREQUEST_PUB

Line 144: l_sr_rec CS_ServiceRequest_PUB.service_request_rec_type;

140: AND install_location_type_code IN ('HZ_PARTY_SITES','HZ_LOCATIONS');
141:
142: --Variable Declarations
143: l_install_location_id csi_item_instances.install_location_id%TYPE;
144: l_sr_rec CS_ServiceRequest_PUB.service_request_rec_type;
145: l_user_id NUMBER;
146: l_msg_count NUMBER;
147: l_msg_data VARCHAR2(240);
148: l_notes_tab CS_ServiceRequest_PUB.notes_table;

Line 148: l_notes_tab CS_ServiceRequest_PUB.notes_table;

144: l_sr_rec CS_ServiceRequest_PUB.service_request_rec_type;
145: l_user_id NUMBER;
146: l_msg_count NUMBER;
147: l_msg_data VARCHAR2(240);
148: l_notes_tab CS_ServiceRequest_PUB.notes_table;
149: l_contacts_tab CS_ServiceRequest_PUB.contacts_table;
150: l_request_id NUMBER;
151: l_request_number VARCHAR2(64);
152: l_interaction_id NUMBER;

Line 149: l_contacts_tab CS_ServiceRequest_PUB.contacts_table;

145: l_user_id NUMBER;
146: l_msg_count NUMBER;
147: l_msg_data VARCHAR2(240);
148: l_notes_tab CS_ServiceRequest_PUB.notes_table;
149: l_contacts_tab CS_ServiceRequest_PUB.contacts_table;
150: l_request_id NUMBER;
151: l_request_number VARCHAR2(64);
152: l_interaction_id NUMBER;
153: l_workflow_process_id NUMBER;

Line 154: l_contact_rec CS_ServiceRequest_PUB.contacts_rec;

150: l_request_id NUMBER;
151: l_request_number VARCHAR2(64);
152: l_interaction_id NUMBER;
153: l_workflow_process_id NUMBER;
154: l_contact_rec CS_ServiceRequest_PUB.contacts_rec;
155: l_contact_index BINARY_INTEGER;
156: l_contact_id CS_HZ_SR_CONTACT_POINTS.PARTY_ID%TYPE;
157: x_individual_owner NUMBER;
158: x_individual_type VARCHAR2(240);

Line 171: l_sr_out_rec CS_ServiceRequest_PUB.sr_create_out_rec_type;

167: l_org_id NUMBER;
168: l_created_by NUMBER;
169: l_party_type VARCHAR2(30);
170: l_responsibility_id NUMBER;
171: l_sr_out_rec CS_ServiceRequest_PUB.sr_create_out_rec_type;
172: l_auto_generate_task VARCHAR2(255);
173: l_freeform VARCHAR2(255);
174: l_free_form_rec C_FREE_FORM_IB_INFO%ROWTYPE;
175: l_free_form_ser_rec C_FREE_FORM_SER_INFO%ROWTYPE;

Line 231: CS_ServiceRequest_PUB.INITIALIZE_REC( p_sr_record => l_sr_rec );

227: l_auto_generate_task := 'Y';
228: END IF;
229:
230: -- Initialization
231: CS_ServiceRequest_PUB.INITIALIZE_REC( p_sr_record => l_sr_rec );
232:
233:
234: --SR ATTRIBUTES
235: l_sr_rec.SUMMARY := p_record.SUMMARY;

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 447: CS_ServiceRequest_PUB.Create_ServiceRequest

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
449: , p_init_msg_list => FND_API.G_TRUE
450: , p_commit => FND_API.G_TRUE
451: , x_return_status => x_return_status

Line 475: || ' ROOT ERROR: CS_ServiceRequest_PUB.Create_ServiceRequest ' || sqlerrm

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

Line 528: l_sr_rec CS_ServiceRequest_PUB.service_request_rec_type;

524: l_install_location_id csi_item_instances.install_location_id%TYPE;
525: --
526:
527: r_last_update_date c_last_update_date%ROWTYPE;
528: l_sr_rec CS_ServiceRequest_PUB.service_request_rec_type;
529: l_msg_count NUMBER;
530: l_msg_data VARCHAR2(240);
531: l_notes_tab CS_ServiceRequest_PUB.notes_table;
532: l_contacts_tab CS_ServiceRequest_PUB.contacts_table;

Line 531: l_notes_tab CS_ServiceRequest_PUB.notes_table;

527: r_last_update_date c_last_update_date%ROWTYPE;
528: l_sr_rec CS_ServiceRequest_PUB.service_request_rec_type;
529: l_msg_count NUMBER;
530: l_msg_data VARCHAR2(240);
531: l_notes_tab CS_ServiceRequest_PUB.notes_table;
532: l_contacts_tab CS_ServiceRequest_PUB.contacts_table;
533: l_interaction_id NUMBER;
534: l_ovn NUMBER;
535: l_user_id NUMBER;

Line 532: l_contacts_tab CS_ServiceRequest_PUB.contacts_table;

528: l_sr_rec CS_ServiceRequest_PUB.service_request_rec_type;
529: l_msg_count NUMBER;
530: l_msg_data VARCHAR2(240);
531: l_notes_tab CS_ServiceRequest_PUB.notes_table;
532: l_contacts_tab CS_ServiceRequest_PUB.contacts_table;
533: l_interaction_id NUMBER;
534: l_ovn NUMBER;
535: l_user_id NUMBER;
536: l_workflow_id NUMBER;

Line 579: CS_ServiceRequest_PUB.INITIALIZE_REC

575: close c_last_update_date;
576: end if;
577:
578: -- Initialization
579: CS_ServiceRequest_PUB.INITIALIZE_REC
580: ( p_sr_record => l_sr_rec
581: );
582:
583: -- Lookup the user_id

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 806: CS_ServiceRequest_PUB.Update_ServiceRequest

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
808: , p_init_msg_list => FND_API.G_TRUE
809: , p_commit => FND_API.G_TRUE
810: , x_return_status => x_return_status

Line 832: || ' ROOT ERROR: CS_ServiceRequest_PUB.Update_ServiceRequest ' || sqlerrm

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