[Home] [Help]
176: l_ump_rec c_ump%ROWTYPE;
177: l_route_rec c_route%ROWTYPE;
178: l_contacts_rec c_contacts%ROWTYPE;
179: l_billto_shipto_rec c_billto_shipto%ROWTYPE;
180: l_service_request_rec cs_servicerequest_pub.service_request_rec_type;
181: l_notes_table cs_servicerequest_pub.notes_table;
182: l_contacts_table cs_servicerequest_pub.contacts_table;
183: l_link_rec cs_incidentlinks_pub.cs_incident_link_rec_type;
184: l_billto_site_id number;
177: l_route_rec c_route%ROWTYPE;
178: l_contacts_rec c_contacts%ROWTYPE;
179: l_billto_shipto_rec c_billto_shipto%ROWTYPE;
180: l_service_request_rec cs_servicerequest_pub.service_request_rec_type;
181: l_notes_table cs_servicerequest_pub.notes_table;
182: l_contacts_table cs_servicerequest_pub.contacts_table;
183: l_link_rec cs_incidentlinks_pub.cs_incident_link_rec_type;
184: l_billto_site_id number;
185: l_shipto_site_id number;
178: l_contacts_rec c_contacts%ROWTYPE;
179: l_billto_shipto_rec c_billto_shipto%ROWTYPE;
180: l_service_request_rec cs_servicerequest_pub.service_request_rec_type;
181: l_notes_table cs_servicerequest_pub.notes_table;
182: l_contacts_table cs_servicerequest_pub.contacts_table;
183: l_link_rec cs_incidentlinks_pub.cs_incident_link_rec_type;
184: l_billto_site_id number;
185: l_shipto_site_id number;
186: l_msg_index_out number;
211:
212:
213: /* rhungund : note
214: added the following 2 local variables for ER 3956663 */
215: l_no_contacts_table cs_servicerequest_pub.contacts_table;
216: l_no_notes_table cs_servicerequest_pub.notes_table;
217:
218:
219:
212:
213: /* rhungund : note
214: added the following 2 local variables for ER 3956663 */
215: l_no_contacts_table cs_servicerequest_pub.contacts_table;
216: l_no_notes_table cs_servicerequest_pub.notes_table;
217:
218:
219:
220: /* rhungund - note
297: l_product_number := l_ump_rec.instance_number;
298: l_serial_number := l_ump_rec.serial_number;
299:
300:
301: cs_servicerequest_pub.initialize_rec(l_service_request_rec);
302: l_service_request_rec.type_id :=
303: fnd_profile.value('csfpm_incident_type');
304: l_service_request_rec.status_id :=
305: fnd_profile.value('csfpm_incident_status');
428: Update_ServiceRequest() API has no such restriction as it's create counterpart does.
429:
430: The Update_ServiceRequest() API is also newly added to address the same ER.
431: */
432: FND_FILE.put_line(FND_FILE.log,'MESSAGE: before calling cs_servicerequest_pub.Create_ServiceRequest API');
433:
434: IF (nvl(l_primary_contact,'N') = 'N') THEN
435:
436: cs_servicerequest_pub.Create_ServiceRequest
432: FND_FILE.put_line(FND_FILE.log,'MESSAGE: before calling cs_servicerequest_pub.Create_ServiceRequest API');
433:
434: IF (nvl(l_primary_contact,'N') = 'N') THEN
435:
436: cs_servicerequest_pub.Create_ServiceRequest
437: ( p_api_version => 3.0,
438: p_init_msg_list => FND_API.G_FALSE,
439: p_commit => FND_API.G_FALSE,
440: x_return_status => x_return_status,
461:
462:
463: ELSE
464:
465: cs_servicerequest_pub.Create_ServiceRequest
466: ( p_api_version => 3.0,
467: p_init_msg_list => FND_API.G_FALSE,
468: p_commit => FND_API.G_FALSE,
469: x_return_status => x_return_status,
488: x_group_owner => x_group_owner,
489: x_individual_type => x_individual_type );
490:
491: END IF;
492: FND_FILE.put_line(FND_FILE.log,'MESSAGE: after calling cs_servicerequest_pub.Create_ServiceRequest API x_return_status='||x_return_status);
493:
494: If X_Return_status <> FND_API.G_RET_STS_SUCCESS Then
495: fnd_message.set_name('CSF','CSF_PM_SR_CREATION_ERROR');
496: fnd_message.set_token('VALUE1',l_ump_rec.unit_effectivity_id);
515: */
516:
517: l_index := l_contacts_table.FIRST;
518: IF (nvl(l_primary_contact,'N') = 'N' and l_index is not null) THEN
519: CS_ServiceRequest_PUB.Update_ServiceRequest
520: (
521: p_api_version => 3.0,
522: p_init_msg_list => fnd_api.g_false,
523: p_commit => fnd_api.g_false,
1182: COMMIT WORK;
1183: SAVEPOINT update_sr_tasks_pvt;
1184: l_prev_rec := incident_rec;
1185: sr_update_success := FALSE;
1186: cs_servicerequest_pub.Update_Status
1187: (p_api_version => 2.0,
1188: p_init_msg_list => FND_API.G_FALSE,
1189: p_commit => FND_API.G_FALSE,
1190: x_return_status => x_return_status,