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 116: l_sr_rec CS_ServiceRequest_PUB.service_request_rec_type;

112:
113:
114: --Variable Declarations
115: l_install_location_id csi_item_instances.install_location_id%TYPE;
116: l_sr_rec CS_ServiceRequest_PUB.service_request_rec_type;
117: l_user_id NUMBER;
118: l_msg_count NUMBER;
119: l_msg_data VARCHAR2(240);
120: l_notes_tab CS_ServiceRequest_PUB.notes_table;

Line 120: l_notes_tab CS_ServiceRequest_PUB.notes_table;

116: l_sr_rec CS_ServiceRequest_PUB.service_request_rec_type;
117: l_user_id NUMBER;
118: l_msg_count NUMBER;
119: l_msg_data VARCHAR2(240);
120: l_notes_tab CS_ServiceRequest_PUB.notes_table;
121: l_contacts_tab CS_ServiceRequest_PUB.contacts_table;
122: l_request_id NUMBER;
123: l_request_number VARCHAR2(64);
124: l_interaction_id NUMBER;

Line 121: l_contacts_tab CS_ServiceRequest_PUB.contacts_table;

117: l_user_id NUMBER;
118: l_msg_count NUMBER;
119: l_msg_data VARCHAR2(240);
120: l_notes_tab CS_ServiceRequest_PUB.notes_table;
121: l_contacts_tab CS_ServiceRequest_PUB.contacts_table;
122: l_request_id NUMBER;
123: l_request_number VARCHAR2(64);
124: l_interaction_id NUMBER;
125: l_workflow_process_id NUMBER;

Line 126: l_contact_rec CS_ServiceRequest_PUB.contacts_rec;

122: l_request_id NUMBER;
123: l_request_number VARCHAR2(64);
124: l_interaction_id NUMBER;
125: l_workflow_process_id NUMBER;
126: l_contact_rec CS_ServiceRequest_PUB.contacts_rec;
127: l_contact_index BINARY_INTEGER;
128: l_contact_id CS_HZ_SR_CONTACT_POINTS.PARTY_ID%TYPE;
129: x_individual_owner NUMBER;
130: x_individual_type VARCHAR2(240);

Line 143: l_sr_out_rec CS_ServiceRequest_PUB.sr_create_out_rec_type;

139: l_org_id NUMBER;
140: l_created_by NUMBER;
141: l_party_type VARCHAR2(30);
142: l_responsibility_id NUMBER;
143: l_sr_out_rec CS_ServiceRequest_PUB.sr_create_out_rec_type;
144: l_auto_generate_task VARCHAR2(255);
145:
146: BEGIN
147:

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

178: l_auto_generate_task := 'Y';
179: END IF;
180:
181: -- Initialization
182: CS_ServiceRequest_PUB.INITIALIZE_REC( p_sr_record => l_sr_rec );
183:
184: --get caller type if not send by client
185: IF p_record.CALLER_TYPE IS NULL THEN
186: --get party type

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

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
341: , p_init_msg_list => FND_API.G_TRUE
342: , p_commit => FND_API.G_TRUE
343: , x_return_status => x_return_status

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

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

Line 435: l_sr_rec CS_ServiceRequest_PUB.service_request_rec_type;

431: --
432:
433: r_last_update_date c_last_update_date%ROWTYPE;
434:
435: l_sr_rec CS_ServiceRequest_PUB.service_request_rec_type;
436: l_msg_count NUMBER;
437: l_msg_data VARCHAR2(240);
438: l_notes_tab CS_ServiceRequest_PUB.notes_table;
439: l_contacts_tab CS_ServiceRequest_PUB.contacts_table;

Line 438: l_notes_tab CS_ServiceRequest_PUB.notes_table;

434:
435: l_sr_rec CS_ServiceRequest_PUB.service_request_rec_type;
436: l_msg_count NUMBER;
437: l_msg_data VARCHAR2(240);
438: l_notes_tab CS_ServiceRequest_PUB.notes_table;
439: l_contacts_tab CS_ServiceRequest_PUB.contacts_table;
440: l_interaction_id NUMBER;
441: l_ovn NUMBER;
442: l_user_id NUMBER;

Line 439: l_contacts_tab CS_ServiceRequest_PUB.contacts_table;

435: l_sr_rec CS_ServiceRequest_PUB.service_request_rec_type;
436: l_msg_count NUMBER;
437: l_msg_data VARCHAR2(240);
438: l_notes_tab CS_ServiceRequest_PUB.notes_table;
439: l_contacts_tab CS_ServiceRequest_PUB.contacts_table;
440: l_interaction_id NUMBER;
441: l_ovn NUMBER;
442: l_user_id NUMBER;
443: l_workflow_id NUMBER;

Line 481: CS_ServiceRequest_PUB.INITIALIZE_REC

477: close c_last_update_date;
478: end if;
479:
480: -- Initialization
481: CS_ServiceRequest_PUB.INITIALIZE_REC
482: ( p_sr_record => l_sr_rec
483: );
484:
485: -- Lookup the user_id

Line 519: --l_sr_rec.cc_number := CS_SERVICEREQUEST_PUB.CC_DECODE(p_record.credit_card_number);

515:
516: --ANURAG
517: --credit card number received from client side is in base 64 encoding.
518: --We need to decode this, before passing to SR API
519: --l_sr_rec.cc_number := CS_SERVICEREQUEST_PUB.CC_DECODE(p_record.credit_card_number);
520:
521: -- instantiate the sr record
522: --12.1
523: IF p_record.CALLER_TYPE IS NULL THEN

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

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
669: , p_init_msg_list => FND_API.G_TRUE
670: , p_commit => FND_API.G_TRUE
671: , x_return_status => x_return_status

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

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