[Home] [Help]
68: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
69: FND_MESSAGE.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
70: FND_MESSAGE.set_token
71: ('P_TEXT'
72: , 'CS_SERVICEREQUEST_UTIL.get_incident_type_details'||'-'||SQLERRM
73: );
74: FND_MSG_PUB.ADD;
75: END get_incident_type_details;
76: -- -----------------------------------------------------------------------------
397: IF p_sr_rec.incident_location_id <> NVL(p_old_incident_location_id,-9) OR
398: NVL(p_sr_rec.incident_location_type,'X') <> NVL(p_old_incident_location_type,'Y') OR
399: p_old_incident_country IS NULL
400: THEN
401: CS_ServiceRequest_UTIL.Validate_Inc_Location_Id
402: ( p_api_name => l_api_name
403: , p_parameter_name => 'p_incident_location_id'
404: , p_incident_location_type => p_sr_rec.incident_location_type
405: , p_incident_location_id => p_sr_rec.incident_location_id
432: p_sr_rec.type_id <> NVL(p_old_incident_type_id , -9) OR
433: NVL(p_sr_rec.owner_group_id,-1) <> NVL(p_old_owner_group_id , -1) OR
434: NVL(p_sr_rec.resource_type ,'Y')<> NVL(p_old_resource_type ,'x')
435: THEN
436: CS_SERVICEREQUEST_UTIL.validate_owner
437: ( p_api_name => NULL
438: , p_parameter_name => 'owner id'
439: , p_owner_id => p_sr_rec.owner_id
440: , p_group_type => p_sr_rec.group_type
472: NVL(p_sr_rec.install_site_id ,-9) <> NVL(p_old_install_site_id ,-9) OR
473: NVL(p_sr_rec.inventory_item_id ,-9) <> NVL(p_old_inventory_item_id ,-9) OR
474: NVL(p_sr_rec.customer_product_id,-9) <> NVL(p_old_customer_product_id,-9)
475: THEN
476: CS_SERVICEREQUEST_UTIL.Validate_Contract_Service_Id
477: ( p_api_name => l_api_name
478: , p_parameter_name => 'p_contract_service_id'
479: , p_contract_service_id => p_sr_rec.contract_service_id
480: , x_contract_id => p_sr_rec.contract_id
484: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
485: THEN
486: l_contract_service_id_valid := 'N';
487: ELSE
488: CS_SERVICEREQUEST_UTIL.contracts_cross_val
489: ( p_parameter_name => 'contract_service_id'
490: , p_contract_service_id => p_sr_rec.contract_service_id
491: , p_busiproc_id => p_sr_related_data.business_process_id
492: , p_request_date => p_sr_rec.request_date
607: IF l_contract_service_id_valid <> 'Y' AND
608: l_contract_defaulted <> 'Y'
609: THEN
610: FND_MESSAGE.set_name ('CS', 'CS_SR_CONTRACT_INVALID');
611: FND_MESSAGE.set_token('API_NAME', 'CS_SERVICEREQUEST_UTIL.contracts_cross_val' );
612: FND_MSG_PUB.add;
613: RAISE FND_API.G_EXC_ERROR;
614: END IF;
615: -- End of Default contract SLA processing
735: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
736: FND_MESSAGE.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
737: FND_MESSAGE.set_token
738: ('P_TEXT'
739: , 'CS_SERVICEREQUEST_UTIL.vldt_sr_rec'||'-'||SQLERRM
740: );
741: FND_MSG_PUB.ADD;
742: END vldt_sr_rec;
743: --============================================================================
1528: end if;
1529:
1530: -- For bug 3370562 - pass resp_id an appl_id
1531: -- validate security in create
1532: cs_servicerequest_util.validate_type (
1533: p_parameter_name => NULL,
1534: p_type_id => p_service_request_rec.type_id,
1535: p_subtype => G_SR_SUBTYPE,
1536: p_status_id => p_service_request_rec.status_id,
1568: p_service_request_rec.customer_product_id <> FND_API.G_MISS_NUM)
1569: THEN
1570: IF p_service_request_rec.maint_organization_id = FND_API.G_MISS_NUM
1571: THEN
1572: CS_ServiceRequest_UTIL.Add_Missing_Param_Msg(l_api_name_full, 'Maint_organization_id');
1573: RAISE FND_API.G_EXC_ERROR;
1574: ELSIF (p_service_request_rec.maint_organization_id IS NULL) THEN
1575: CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg(l_api_name_full, 'Maint_organization_id');
1576: RAISE FND_API.G_EXC_ERROR;
1571: THEN
1572: CS_ServiceRequest_UTIL.Add_Missing_Param_Msg(l_api_name_full, 'Maint_organization_id');
1573: RAISE FND_API.G_EXC_ERROR;
1574: ELSIF (p_service_request_rec.maint_organization_id IS NULL) THEN
1575: CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg(l_api_name_full, 'Maint_organization_id');
1576: RAISE FND_API.G_EXC_ERROR;
1577: END IF;
1578: END IF;
1579: END IF;
1605: , x_return_status => l_return_status
1606: );
1607: IF l_return_status = FND_API.G_RET_STS_ERROR
1608: THEN
1609: CS_ServiceRequest_UTIL.Add_Invalid_Argument_Msg
1610: ( p_token_an => l_api_name_full
1611: , p_token_v => TO_CHAR(p_service_request_rec.type_id)
1612: , p_token_p => 'p_type_id'
1613: , p_table_name => G_TABLE_NAME
1790: IF ( p_validation_level = FND_API.G_VALID_LEVEL_NONE ) THEN
1791: IF ( p_service_request_rec.bill_to_site_id <> FND_API.G_MISS_NUM AND
1792: p_service_request_rec.bill_to_site_id IS NOT NULL ) THEN
1793:
1794: CS_ServiceRequest_UTIL.Validate_Bill_To_Ship_To_Site
1795: ( p_api_name => 'Get bill to site use id',
1796: p_parameter_name => 'Bill_To Site ',
1797: p_bill_to_site_id => p_service_request_rec.bill_to_site_id,
1798: p_bill_to_party_id => p_service_request_rec.bill_to_party_id,
1807:
1808: IF ( p_service_request_rec.ship_to_site_id <> FND_API.G_MISS_NUM AND
1809: p_service_request_rec.ship_to_site_id IS NOT NULL ) THEN
1810:
1811: CS_ServiceRequest_UTIL.Validate_Bill_To_Ship_To_Site
1812: ( p_api_name => 'Get ship to site use id',
1813: p_parameter_name => 'Ship_To Site ',
1814: p_bill_to_site_id => p_service_request_rec.ship_to_site_id,
1815: p_bill_to_party_id => p_service_request_rec.ship_to_party_id,
2791: l_note_index := p_notes.NEXT(l_note_index);
2792: END LOOP;
2793:
2794:
2795: --CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg(l_api_name_full, 'step #8');
2796: -- Launching the workflow (HOOK)
2797: IF (JTF_USR_HKS.Ok_To_Execute('CS_ServiceRequest_PVT', 'Create_ServiceRequest',
2798: 'W', 'W')) THEN
2799:
3376: -- Non EAM service requests
3377: -- Raised error msg when maint_organization_id is NOT passed
3378: -- for EAM SRs with customer product
3379: -- 07/11/05 smisra Release 12 ERES changes
3380: -- called CS_SERVICEREQUEST_UTIL.get_status_details to
3381: -- details of old status and new status.
3382: -- if request updated is not allowed and new status has
3383: -- intermediate status id then do the following
3384: -- 1. Warn user that only status will be updated
3565: L_OLD_SERVICEREQUEST_REC SR_OLDVALUES_REC_TYPE;
3566:
3567: -- out rec for servicerequest_cross_val
3568:
3569: l_sr_cross_val_out_rec CS_ServiceRequest_UTIL.sr_cross_val_out_rec_type;
3570:
3571: -- Validation record
3572: l_sr_validation_rec request_validation_rec_type;
3573:
3853:
3854: EXCEPTION
3855: WHEN NO_DATA_FOUND THEN
3856: l_return_status := FND_API.G_RET_STS_ERROR;
3857: CS_ServiceRequest_UTIL.Add_Invalid_Argument_Msg
3858: (p_token_an => l_api_name_full,
3859: p_token_v => TO_CHAR(p_request_id),
3860: p_token_p => 'Request ID' ,
3861: p_table_name => G_TABLE_NAME,
3883: END IF;
3884:
3885: -- Check if mandatory parameter is passed
3886: IF (p_request_id IS NULL ) THEN
3887: CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg
3888: (p_token_an => l_api_name_full,
3889: p_token_np => 'SR Incident Id',
3890: p_table_name => G_TABLE_NAME,
3891: p_column_name => 'INCIDENT_ID' );
3893: RAISE FND_API.G_EXC_ERROR;
3894: END IF;
3895:
3896: IF (p_object_version_number IS NULL ) THEN
3897: CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg
3898: (p_token_an => l_api_name_full,
3899: p_token_np => 'SR Object Version Number',
3900: p_table_name => G_TABLE_NAME,
3901: p_column_name => 'OBJECT_VERSION_NUMBER');
3905:
3906: -- Check if user has passed null to mandatory parameters.
3907:
3908: IF (l_service_request_rec.type_id IS NULL) THEN
3909: CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg
3910: (p_token_an => l_api_name_full,
3911: p_token_np => 'SR Type',
3912: p_table_name => G_TABLE_NAME,
3913: p_column_name => 'INCIDENT_TYPE_ID');
3914: RAISE FND_API.G_EXC_ERROR;
3915: END IF;
3916:
3917: IF (l_service_request_rec.status_id IS NULL) THEN
3918: CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg
3919: (p_token_an => l_api_name_full,
3920: p_token_np => 'SR Status',
3921: p_table_name => G_TABLE_NAME,
3922: p_column_name => 'INCIDENT_STATUS_ID');
3923: RAISE FND_API.G_EXC_ERROR;
3924: END IF;
3925:
3926: IF (l_service_request_rec.severity_id IS NULL) THEN
3927: CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg
3928: (p_token_an => l_api_name_full,
3929: p_token_np => 'SR Severity',
3930: p_table_name => G_TABLE_NAME,
3931: p_column_name => 'SEVERITY_ID');
3934: END IF;
3935:
3936: -- Request Date is a reqd field, so check if passed, else return error
3937: IF (l_service_request_rec.request_date IS NULL) THEN
3938: CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg
3939: (p_token_an => l_api_name_full,
3940: p_token_np => 'SR Request Date',
3941: p_table_name => G_TABLE_NAME,
3942: p_column_name => 'REQUEST_DATE');
3944: END IF;
3945:
3946:
3947: IF (l_service_request_rec.summary IS NULL) THEN
3948: CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg (
3949: p_token_an => l_api_name_full,
3950: p_token_np => 'SR Summary',
3951: p_table_name => G_TABLE_NAME,
3952: p_column_name => 'SUMMARY');
3959: FETCH l_ServiceRequest_csr INTO l_old_ServiceRequest_rec;
3960:
3961: IF ( l_ServiceRequest_csr%NOTFOUND ) THEN
3962:
3963: CS_ServiceRequest_UTIL.Add_Invalid_Argument_Msg
3964: ( p_token_an => l_api_name_full,
3965: p_token_v => TO_CHAR(p_request_id),
3966: p_token_p => 'p_request_id',
3967: p_table_name => G_TABLE_NAME,
4001: , x_return_status => l_return_status
4002: );
4003: IF l_return_status = FND_API.G_RET_STS_ERROR
4004: THEN
4005: CS_ServiceRequest_UTIL.Add_Invalid_Argument_Msg
4006: ( p_token_an => l_api_name_full
4007: , p_token_v => TO_CHAR(l_service_request_rec.type_id)
4008: , p_token_p => 'p_type_id'
4009: , p_table_name => G_TABLE_NAME
4059: -- For bug 3370562 - pass resp_id an appl_id
4060: -- validate security in update; first against old sr type
4061:
4062: -- For bug 3474365 - pass different operation code for old sr type
4063: cs_servicerequest_util.validate_type (
4064: p_parameter_name => NULL,
4065: p_type_id => l_old_servicerequest_rec.incident_type_id,
4066: p_subtype => G_SR_SUBTYPE,
4067: p_status_id => p_service_request_rec.status_id, -- not used
4084: -- if type has changed and is not the same as the existing type, then validate
4085: -- if the responsibility has access to the new SR Type
4086: IF ( p_service_request_rec.type_id <> FND_API.G_MISS_NUM AND
4087: p_service_request_rec.type_id <> l_old_ServiceRequest_rec.incident_type_id ) then
4088: cs_servicerequest_util.validate_type (
4089: p_parameter_name => NULL,
4090: p_type_id => p_service_request_rec.type_id,
4091: p_subtype => G_SR_SUBTYPE,
4092: p_status_id => p_service_request_rec.status_id, -- not used
4105: RAISE FND_API.G_EXC_ERROR;
4106: end if;
4107:
4108: -- if the type has changed, check if the change is EAM <-> non-EAM.
4109: cs_servicerequest_util.validate_type_change (
4110: p_old_eam_type_flag => l_old_maintenance_flag,
4111: p_new_eam_type_flag => l_new_maintenance_flag,
4112: x_return_status => lx_return_status );
4113:
4140: THEN
4141: IF (p_service_request_rec.maint_organization_id = FND_API.G_MISS_NUM AND
4142: l_old_servicerequest_rec.maint_organization_id IS NULL)
4143: THEN
4144: CS_ServiceRequest_UTIL.Add_Missing_Param_Msg(l_api_name_full, 'Maint_organization_id');
4145: RAISE FND_API.G_EXC_ERROR;
4146: ELSIF (p_service_request_rec.maint_organization_id IS NULL) THEN
4147: CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg(l_api_name_full, 'Maint_organization_id');
4148: RAISE FND_API.G_EXC_ERROR;
4143: THEN
4144: CS_ServiceRequest_UTIL.Add_Missing_Param_Msg(l_api_name_full, 'Maint_organization_id');
4145: RAISE FND_API.G_EXC_ERROR;
4146: ELSIF (p_service_request_rec.maint_organization_id IS NULL) THEN
4147: CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg(l_api_name_full, 'Maint_organization_id');
4148: RAISE FND_API.G_EXC_ERROR;
4149: END IF;
4150: END IF;
4151: END IF;
4173: END IF;
4174:
4175: IF (l_new_maintenance_flag = 'y' OR l_new_maintenance_flag = 'Y') THEN
4176: IF (l_service_request_rec.inventory_org_id IS NULL) THEN
4177: CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg(
4178: l_api_name_full, 'Inventory Org ID');
4179: RAISE FND_API.G_EXC_ERROR;
4180: END IF;
4181: END IF;
4188:
4189: END IF; -- IF ( p_validation_level > fnd_api.g_valid_level_none )
4190:
4191: l_sr_related_data.target_status_id := l_service_request_rec.status_id;
4192: CS_SERVICEREQUEST_UTIL.get_status_details
4193: ( p_status_id => l_old_servicerequest_rec.incident_status_id
4194: , x_close_flag => l_sr_related_data.old_close_flag
4195: , x_disallow_request_update => l_sr_related_data.old_disallow_request_update
4196: , x_disallow_agent_dispatch => l_sr_related_data.old_disallow_owner_update
4204: l_start_eres_flag := 'N';
4205: IF (l_service_request_rec.status_id <> FND_API.G_MISS_NUM AND
4206: l_service_request_rec.status_id <> l_old_servicerequest_rec.incident_status_id)
4207: THEN
4208: CS_SERVICEREQUEST_UTIL.get_status_details
4209: ( p_status_id => l_sr_related_data.target_status_id
4210: , x_close_flag => l_sr_related_data.close_flag
4211: , x_disallow_request_update => l_sr_related_data.disallow_request_update
4212: , x_disallow_agent_dispatch => l_sr_related_data.disallow_owner_update
4304: , p_same_associated_columns => 'CS_INCIDENTS_ALL_B.INCIDENT_STATUS_ID'
4305: );
4306: IF l_old_servicerequest_rec.incident_status_id = l_service_request_rec.status_id
4307: THEN
4308: CS_ServiceRequest_UTIL.Add_Same_Val_Update_Msg
4309: ( p_token_an => 'CS_SERVICEREQUEST_PUB.update_servicerequest'
4310: , p_token_p => 'p_status_id'
4311: , p_table_name => G_TABLE_NAME
4312: , p_column_name => 'INCIDENT_STATUS_ID'
4600: -- Release 11.5.10 as part of the API Cleanup projecT
4601: --
4602: l_contract_service_id_valid := 'Y';
4603: IF ( p_validation_level > FND_API.G_VALID_LEVEL_NONE ) THEN
4604: CS_ServiceRequest_UTIL.SERVICEREQUEST_CROSS_VAL (
4605: p_new_sr_rec => l_service_request_rec,
4606: p_old_sr_rec => l_old_ServiceRequest_rec,
4607: x_cross_val_out_rec => l_sr_cross_val_out_rec,
4608: x_return_status => l_return_status );
4716: p_service_request_rec.contract_service_id <> FND_API.G_MISS_NUM)
4717: )
4718: THEN
4719: FND_MESSAGE.set_name ('CS', 'CS_SR_CONTRACT_INVALID');
4720: FND_MESSAGE.set_token('API_NAME', 'CS_SERVICEREQUEST_UTIL.contracts_cross_val' );
4721: FND_MSG_PUB.add;
4722: RAISE FND_API.G_EXC_ERROR;
4723: END IF;
4724: END IF;
4730: IF ( p_validation_level = FND_API.G_VALID_LEVEL_NONE ) THEN
4731: IF ( nvl(p_service_request_rec.bill_to_site_id,-99) <> nvl(l_old_ServiceRequest_rec.bill_to_site_id,-99))
4732: AND p_service_request_rec.bill_to_site_id <> FND_API.G_MISS_NUM THEN
4733:
4734: CS_ServiceRequest_UTIL.Validate_Bill_To_Ship_To_Site
4735: ( p_api_name => 'Get bill to site use id',
4736: p_parameter_name => 'Bill_To Site ',
4737: p_bill_to_site_id => p_service_request_rec.bill_to_site_id,
4738: p_bill_to_party_id => p_service_request_rec.bill_to_party_id,
4762:
4763: IF ( nvl(p_service_request_rec.ship_to_site_id,-99) <> nvl(l_old_ServiceRequest_rec.ship_to_site_id,-99))
4764: AND p_service_request_rec.ship_to_site_id <> FND_API.G_MISS_NUM THEN
4765:
4766: CS_ServiceRequest_UTIL.Validate_Bill_To_Ship_To_Site
4767: ( p_api_name => 'Get ship to site use id',
4768: p_parameter_name => 'Ship_To Site ',
4769: p_bill_to_site_id => p_service_request_rec.ship_to_site_id,
4770: p_bill_to_party_id => p_service_request_rec.ship_to_party_id,
4968: -- This is to be executed only for ERES update. For non eres updates
4969: -- this procedure is called from servicerequest_cross_val procedure.
4970: IF l_start_eres_flag = 'Y'
4971: THEN
4972: CS_SERVICEREQUEST_UTIL.task_restrict_close_cross_val
4973: ( p_incident_id => p_request_id
4974: , p_status_id => l_sr_related_data.target_status_id
4975: , x_return_status => l_return_status
4976: );
4986: -- cannot have resolved, responded flags as 'Y'. so no need to attempt to default
4987: -- resolved and responded by dates.
4988: IF l_start_eres_flag = 'N'
4989: THEN
4990: CS_SERVICEREQUEST_UTIL.get_reacted_resolved_dates
4991: ( p_incident_status_id => l_service_request_rec.status_id
4992: , p_old_incident_status_id => l_old_servicerequest_rec.incident_status_id
4993: , p_old_incident_resolved_date => l_old_servicerequest_rec.incident_resolved_date
4994: , p_old_inc_responded_by_date => l_old_servicerequest_rec.inc_responded_by_date
5074: ELSIF l_service_request_rec.contract_service_id is null THEN
5075: l_contra_id := null;
5076: l_contract_number := NULL;
5077: /* ELSE
5078: CS_ServiceRequest_UTIL.Validate_Contract_Service_Id(
5079: p_api_name => l_api_name,
5080: p_parameter_name => 'contract_service_id',
5081: p_contract_service_id => p_service_request_rec.contract_service_id,
5082: x_contract_id =>l_contra_id,
5829: END IF;
5830: IF l_approval_status = 'NO_ACTION'
5831: THEN
5832: -- validated orginal target status
5833: CS_ServiceRequest_UTIL.Validate_Updated_Status
5834: ( p_api_name => 'CS_SERVICEREQUEST_PVT.update_servicerequest'
5835: , p_parameter_name => 'p_status_id'
5836: , p_resp_id => p_resp_id
5837: , p_new_status_id => l_sr_related_data.target_status_id
5851: END IF;
5852: -- target status is valid at this point.
5853: --
5854: -- Now get responded and resolved dates
5855: CS_SERVICEREQUEST_UTIL.get_reacted_resolved_dates
5856: ( p_incident_status_id => l_sr_related_data.target_status_id
5857: , p_old_incident_status_id => l_old_servicerequest_rec.incident_status_id
5858: , p_old_incident_resolved_date => l_old_servicerequest_rec.incident_resolved_date
5859: , p_old_inc_responded_by_date => l_old_servicerequest_rec.inc_responded_by_date
6091: IF NVL(l_sr_related_data.close_flag,'N') = 'Y'
6092: THEN
6093: -- Close workflow processing
6094: -- check if old status was closed on Not
6095: CS_SERVICEREQUEST_UTIL.get_status_details
6096: ( p_status_id => l_old_servicerequest_rec.incident_status_id
6097: , x_close_flag => l_sr_related_data.old_close_flag
6098: , x_disallow_request_update => l_sr_related_data.old_disallow_request_update
6099: , x_disallow_agent_dispatch => l_sr_related_data.old_disallow_owner_update
6168: NVL(l_service_request_rec.incident_location_type,'-') <>
6169: NVL(l_old_servicerequest_rec.incident_location_type,'-')
6170: THEN
6171:
6172: CS_ServiceRequest_UTIL.Verify_LocUpdate_For_FSTasks
6173: (p_incident_id => p_request_id,
6174: x_return_status => x_return_status );
6175:
6176:
6179: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
6180: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6181: END IF ;
6182:
6183: CS_servicerequest_util.update_task_address
6184: ( p_incident_id => p_request_id
6185: , p_location_type => l_service_request_rec.incident_location_type
6186: , p_location_id => l_service_request_rec.incident_location_id
6187: , x_return_status => x_return_status
6685: OPEN l_ServiceRequest_csr;
6686: FETCH l_ServiceRequest_csr INTO l_ServiceRequest_rec;
6687: IF (l_ServiceRequest_csr%NOTFOUND) THEN
6688:
6689: CS_ServiceRequest_UTIL.Add_Invalid_Argument_Msg
6690: ( p_token_an => l_api_name_full,
6691: p_token_v => TO_CHAR(p_request_id),
6692: p_token_p => 'p_request_id',
6693: p_table_name => G_TABLE_NAME,
6708: -- Display the Warning that SR Status has not changed, only if SR Status's Disallow Update is unchecked
6709:
6710: IF (l_sr_related_data.disallow_request_update <> 'Y') THEN
6711:
6712: CS_ServiceRequest_UTIL.Add_Same_Val_Update_Msg
6713: ( p_token_an => l_api_name_full,
6714: p_token_p => 'p_status_id' ,
6715: p_table_name => G_TABLE_NAME,
6716: p_column_name => 'INCIDENT_STATUS_ID');
6724: -- Perform validation when necessary
6725: -- -------------------------------------
6726: IF (p_validation_level > FND_API.G_VALID_LEVEL_NONE) THEN
6727:
6728: CS_ServiceRequest_UTIL.Validate_Who_Info(
6729: p_api_name => l_api_name_full,
6730: p_parameter_name_usr => 'p_last_updated_by',
6731: p_parameter_name_login => 'p_last_update_login',
6732: p_user_id => p_last_updated_by,
6756: end if;
6757:
6758: -- For bug 3370562 - pass resp_id an appl_id
6759: -- validate security in update; first against old sr type
6760: cs_servicerequest_util.validate_type (
6761: p_parameter_name => NULL,
6762: p_type_id => l_servicerequest_rec.incident_type_id,
6763: p_subtype => G_SR_SUBTYPE,
6764: p_status_id => l_servicerequest_rec.incident_status_id, -- not used
6779: END IF; -- IF (p_validation_level > FND_API.G_VALID_LEVEL_NONE) THEN
6780:
6781: -- Get the details of the existing status of SR
6782:
6783: CS_SERVICEREQUEST_UTIL.get_status_details
6784: ( p_status_id => l_servicerequest_rec.incident_status_id
6785: , x_close_flag => l_sr_related_data.old_close_flag
6786: , x_disallow_request_update => l_sr_related_data.old_disallow_request_update
6787: , x_disallow_agent_dispatch => l_sr_related_data.old_disallow_owner_update
6806: END IF; -- l_pending approval flag is Y
6807: END IF; -- if after get_status_details call
6808:
6809: -- Get the details of the new status
6810: CS_SERVICEREQUEST_UTIL.get_status_details
6811: ( p_status_id => p_status_id
6812: , x_close_flag => l_sr_related_data.close_flag
6813: , x_disallow_request_update => l_sr_related_data.disallow_request_update
6814: , x_disallow_agent_dispatch => l_sr_related_data.disallow_owner_update
6870: -- We ALWAYS have to validate the status because we don't know if the
6871: -- status is a "closed" status, and we need this information in order
6872: -- to set the closed_date variable accordingly
6873: -- ------------------------------------------------------------------
6874: CS_ServiceRequest_UTIL.Validate_Updated_Status(
6875: p_api_name => l_api_name_full,
6876: p_parameter_name => 'p_status_id',
6877: p_resp_id => p_resp_id ,
6878: p_new_status_id => p_status_id,
6919: EXCEPTION
6920:
6921: WHEN NO_DATA_FOUND THEN
6922: l_return_status := FND_API.G_RET_STS_ERROR;
6923: CS_ServiceRequest_UTIL.Add_Invalid_Argument_Msg
6924: ( p_token_an => l_api_name_full,
6925: p_token_v => TO_CHAR(l_ServiceRequest_rec.incident_type_id),
6926: p_token_p => 'p_type_id' ,
6927: p_table_name => G_TABLE_NAME,
6973: ELSE
6974: l_closed_date := p_closed_date;
6975: IF (p_closed_date IS NOT NULL) THEN
6976:
6977: CS_ServiceRequest_UTIL.Validate_Closed_Date(
6978: p_api_name => G_PKG_NAME||'.'||l_api_name,
6979: p_parameter_name => 'p_closed_date',
6980: p_closed_date => l_closed_date,
6981: p_request_date => l_ServiceRequest_rec.incident_date,
6992: IF (p_closed_date = FND_API.G_MISS_DATE) OR
6993: (p_closed_date IS NULL) THEN
6994: NULL;
6995: ELSE
6996: CS_ServiceRequest_UTIL.Add_Param_Ignored_MSg
6997: ( p_token_an => l_api_name_full,
6998: p_token_ip => 'p_closed_date',
6999: p_table_name => G_TABLE_NAME,
7000: p_column_name => 'CLOSED_DATE');
7006: --- SR has any open tasks with restrict flag set to 'Y', If yes, return
7007: --- error ( bug # 3512003).
7008:
7009: IF (l_closed_flag = 'Y') THEN
7010: CS_ServiceRequest_UTIL.TASK_RESTRICT_CLOSE_CROSS_VAL (
7011: p_incident_id => p_request_id,
7012: p_status_id => p_status_id,
7013: x_return_status => l_return_status );
7014:
7061: END IF;
7062: END IF;
7063: END IF;
7064:
7065: CS_SERVICEREQUEST_UTIL.get_reacted_resolved_dates
7066: ( p_incident_status_id => p_status_id
7067: , p_old_incident_status_id => l_servicerequest_rec.incident_status_id
7068: , p_old_incident_resolved_date => l_servicerequest_rec.incident_resolved_date
7069: , p_old_inc_responded_by_date => l_servicerequest_rec.inc_responded_by_date
7545: OPEN l_ServiceRequest_csr;
7546: FETCH l_ServiceRequest_csr INTO l_ServiceRequest_rec;
7547: IF (l_ServiceRequest_csr%NOTFOUND) THEN
7548:
7549: CS_ServiceRequest_UTIL.Add_Invalid_Argument_Msg(
7550: p_token_an => l_api_name_full,
7551: p_token_v => TO_CHAR(p_request_id),
7552: p_token_p => 'p_request_id',
7553: p_table_name => G_TABLE_NAME,
7569: -- --------------------------------------------------------
7570: IF ((p_owner_id = l_ServiceRequest_rec.incident_owner_id) AND
7571: (l_owner_group_id = l_ServiceRequest_rec.owner_group_id) ) THEN
7572:
7573: CS_ServiceRequest_UTIL.Add_Same_Val_Update_Msg(
7574: p_token_an => l_api_name_full,
7575: p_token_p => 'p_owner_id/p_owner_group_id',
7576: p_table_name => G_TABLE_NAME,
7577: p_column_name => 'OWNER_GROUP_ID');
7583: -- -------------------------------------
7584: -- Perform validation when necessary
7585: -- -------------------------------------
7586: IF (p_validation_level > FND_API.G_VALID_LEVEL_NONE) THEN
7587: CS_ServiceRequest_UTIL.Validate_Who_Info(
7588: p_api_name => l_api_name_full,
7589: p_parameter_name_usr => 'p_last_updated_by',
7590: p_parameter_name_login => 'p_last_update_login',
7591: p_user_id => p_last_updated_by,
7616: end if;
7617:
7618: -- For bug 3370562 - pass resp_id an appl_id
7619: -- validate security in update; first against old sr type
7620: cs_servicerequest_util.validate_type (
7621: p_parameter_name => NULL,
7622: p_type_id => l_servicerequest_rec.incident_type_id,
7623: p_subtype => G_SR_SUBTYPE,
7624: p_status_id => l_servicerequest_rec.incident_status_id, -- not used
7635: -- security violation; responsibility does not have access to SR Type
7636: -- being created. Stop and raise error.
7637: RAISE FND_API.G_EXC_ERROR;
7638: end if;
7639: CS_SERVICEREQUEST_UTIL.get_status_details
7640: ( p_status_id => l_servicerequest_rec.incident_status_id
7641: , x_close_flag => l_sr_related_data.close_flag
7642: , x_disallow_request_update => l_sr_related_data.disallow_request_update
7643: , x_disallow_agent_dispatch => l_sr_related_data.disallow_owner_update
7764: */
7765:
7766: -- Added for bug 2725543
7767: IF (p_owner_group_id <> FND_API.G_MISS_NUM) THEN
7768: CS_ServiceRequest_UTIL.Validate_Group_Id
7769: ( p_api_name => l_api_name_full,
7770: p_parameter_name => 'p_owner_group_id',
7771: p_group_type => 'RS_GROUP',
7772: p_owner_group_id => p_owner_group_id,
7778: RAISE FND_API.G_EXC_ERROR;
7779: END IF;
7780: END IF;
7781:
7782: CS_ServiceRequest_UTIL.Validate_Owner
7783: ( p_api_name => l_api_name_full
7784: , p_parameter_name => 'p_owner_id'
7785: , p_owner_id => p_owner_id
7786: , p_group_type => 'RS_GROUP'
7801:
7802: END IF;
7803:
7804: -- Get unassigned_indicator
7805: l_unasgn_ind := CS_SERVICEREQUEST_UTIL.get_unassigned_indicator(p_owner_id, l_owner_group_id);
7806: -- ----------------------------------------------
7807: -- Update the owner and insert the audit record
7808: -- ----------------------------------------------
7809: -- Update CS_INCIDENTS table
9120: ELSIF (p_service_request_rec.caller_type = 'PERSON' ) THEN
9121: l_customer_id := p_service_request_rec.customer_id ;--Added for Bug 2167129
9122: END IF;
9123:
9124: --CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg(p_api_name, 'step val sr rec #1');
9125: -- Validate all non-missing attributes
9126:
9127: /***** dj api cleanup
9128: -- commenting out call to validate type as this is done as the first step in
9129: -- both the create and update procedures
9130: IF FND_API.To_Boolean(p_service_request_rec.validate_type) THEN
9131: IF FND_API.To_Boolean(p_service_request_rec.status_id_change) THEN
9132: -- dj api cleanup
9133: CS_ServiceRequest_UTIL.Validate_Type (
9134: p_parameter_name => 'p_type_id',
9135: p_type_id => p_service_request_rec.type_id,
9136: p_subtype => G_SR_SUBTYPE,
9137: P_status_id => p_service_request_rec.updated_status_id,
9144: x_cmro_flag => lx_cmro_flag, -- new for 11.5.10
9145: x_maintenance_flag => lx_maintenance_flag ); -- new for 11.5.10
9146:
9147: ELSE
9148: CS_ServiceRequest_UTIL.Validate_Type (
9149: p_parameter_name => 'p_type_id',
9150: p_type_id => p_service_request_rec.type_id,
9151: p_subtype => G_SR_SUBTYPE,
9152: P_status_id => p_service_request_rec.status_id,
9169:
9170: end comment of type ********/
9171:
9172: IF FND_API.To_Boolean(p_service_request_rec.validate_status) THEN
9173: CS_ServiceRequest_UTIL.Validate_Status
9174: ( p_api_name => p_api_name,
9175: p_parameter_name => 'p_status_id',
9176: p_status_id => p_service_request_rec.status_id,
9177: p_subtype => G_SR_SUBTYPE,
9195: ELSE
9196: l_old_type_id := p_service_request_rec.type_id;
9197: END IF ;
9198:
9199: CS_ServiceRequest_UTIL.Validate_Updated_Status
9200: ( p_api_name => p_api_name,
9201: p_parameter_name => 'p_status_id',
9202: p_resp_id => p_resp_id ,
9203: p_new_status_id => p_service_request_rec.updated_status_id,
9216: RETURN;
9217: END IF;
9218: END IF;
9219:
9220: -- CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg(p_api_name, 'step val sr rec #3');
9221:
9222: IF (p_service_request_rec.severity_id <> FND_API.G_MISS_NUM) THEN
9223:
9224: CS_ServiceRequest_UTIL.Validate_Severity
9220: -- CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg(p_api_name, 'step val sr rec #3');
9221:
9222: IF (p_service_request_rec.severity_id <> FND_API.G_MISS_NUM) THEN
9223:
9224: CS_ServiceRequest_UTIL.Validate_Severity
9225: ( p_api_name => p_api_name,
9226: p_parameter_name => 'p_severity_id',
9227: p_severity_id => p_service_request_rec.severity_id,
9228: p_subtype => G_SR_SUBTYPE,
9233: RETURN;
9234: END IF;
9235: END IF;
9236:
9237: --CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg(p_api_name, 'step val sr rec #4');
9238:
9239: IF (p_service_request_rec.urgency_id <> FND_API.G_MISS_NUM) THEN
9240:
9241: CS_ServiceRequest_UTIL.Validate_Urgency
9237: --CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg(p_api_name, 'step val sr rec #4');
9238:
9239: IF (p_service_request_rec.urgency_id <> FND_API.G_MISS_NUM) THEN
9240:
9241: CS_ServiceRequest_UTIL.Validate_Urgency
9242: ( p_api_name => p_api_name,
9243: p_parameter_name => 'p_urgency_id',
9244: p_urgency_id => p_service_request_rec.urgency_id,
9245: x_return_status => l_return_status
9254: -- Validate SR_CREATION_CHANNEL
9255:
9256: IF (p_service_request_rec.sr_creation_channel <> FND_API.G_MISS_CHAR ) THEN
9257:
9258: CS_ServiceRequest_UTIL.Validate_SR_Channel(
9259: p_api_name => p_api_name,
9260: p_parameter_name => 'p_sr_creation_channel',
9261: p_sr_creation_channel => p_service_request_rec.sr_creation_channel,
9262: x_return_status => l_return_status);
9266: RETURN;
9267: END IF;
9268: END IF;
9269:
9270: --CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg(p_api_name, 'step val sr rec #6');
9271:
9272: IF (p_service_request_rec.publish_flag <> FND_API.G_MISS_CHAR) AND
9273: p_sr_mode <> 'CREATE' THEN
9274:
9286: END IF;
9287:
9288: IF FND_API.To_Boolean(p_service_request_rec.validate_customer) THEN
9289:
9290: CS_ServiceRequest_UTIL.Validate_Customer
9291: ( p_api_name => p_api_name,
9292: p_parameter_name => 'p_customer_id',
9293: p_caller_type => p_service_request_rec.caller_type, --Bug 3666089
9294: p_customer_id => p_service_request_rec.customer_id,
9301: END IF;
9302: END IF;
9303:
9304: IF (p_service_request_rec.contact_id <> FND_API.G_MISS_NUM) THEN
9305: CS_ServiceRequest_UTIL.Validate_Customer_Contact
9306: ( p_api_name => p_api_name,
9307: p_parameter_name => 'p_contact_id',
9308: p_customer_contact_id => p_service_request_rec.contact_id,
9309: p_customer_id => p_service_request_rec.customer_id,
9317: END IF;
9318: END IF;
9319:
9320: IF FND_API.To_Boolean(p_service_request_rec.validate_employee) THEN
9321: CS_ServiceRequest_UTIL.Validate_Employee
9322: ( p_api_name => p_api_name,
9323: p_parameter_name => 'p_employee_id',
9324: p_employee_id => p_service_request_rec.employee_id,
9325: p_org_id => p_org_id,
9342: -- For bug 2743507 , moving the call to validate inv org id before
9343: -- the validation of inv item id.
9344:
9345: IF (p_service_request_rec.inventory_org_id <> FND_API.G_MISS_NUM) THEN
9346: CS_ServiceRequest_UTIL.Validate_Inventory_Org
9347: ( p_api_name => p_api_name,
9348: p_parameter_name => 'Inventory Organization',
9349: p_inv_org_id => p_service_request_rec.inventory_org_id,
9350: x_inv_org_master_org_flag => l_inv_org_master_org_flag,
9359: -- validate maintenance organization id
9360: IF (p_service_request_rec.maint_organization_id <> FND_API.G_MISS_NUM AND
9361: p_service_request_rec.maint_organization_id IS NOT NULL )
9362: THEN
9363: CS_SERVICEREQUEST_UTIL.validate_maint_organization_id
9364: ( p_maint_organization_id => p_service_request_rec.maint_organization_id
9365: , p_inventory_org_id => p_service_request_rec.inventory_org_id
9366: , p_inv_org_master_org_flag => l_inv_org_master_org_flag
9367: , x_return_status => l_return_status
9377: AND (p_sr_mode = 'CREATE') THEN
9378: IF ((p_service_request_rec.inventory_org_id = FND_API.G_MISS_NUM) OR
9379: (p_service_request_rec.inventory_org_id IS NULL)) THEN
9380:
9381: CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg
9382: ( p_token_an => p_api_name,
9383: p_token_np => 'p_inventory_org_id',
9384: p_table_name => G_TABLE_NAME,
9385: p_column_name => 'INV_ORGANIZATION_ID');
9386:
9387: x_return_status := FND_API.G_RET_STS_ERROR;
9388: RETURN;
9389: END IF;
9390: CS_ServiceRequest_UTIL.Validate_Product
9391: ( p_api_name => p_api_name,
9392: p_parameter_name => 'p_inventory_item_id',
9393: p_inventory_item_id => p_service_request_rec.inventory_item_id,
9394: p_inventory_org_id => p_service_request_rec.inventory_org_id,
9415: AND (p_sr_mode = 'CREATE') THEN
9416: IF ((p_service_request_rec.inventory_org_id = FND_API.G_MISS_NUM) OR
9417: (p_service_request_rec.inventory_org_id IS NULL)) THEN
9418:
9419: CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg
9420: ( p_token_an => p_api_name,
9421: p_token_np => 'p_inventory_org_id',
9422: p_table_name => G_TABLE_NAME,
9423: p_column_name => 'INV_ORGANIZATION_ID');
9430: l_maint_organization_id := NULL;
9431: ELSE
9432: l_maint_organization_id := p_service_request_rec.maint_organization_id;
9433: ENd IF;
9434: CS_ServiceRequest_UTIL.Validate_Customer_Product_id
9435: (p_customer_product_id => p_service_request_rec.customer_product_id,
9436: p_customer_id => p_service_request_rec.customer_id,
9437: p_inventory_item_id => p_inventory_item_id,
9438: p_inventory_org_id => p_service_request_rec.inventory_org_id,
9449: -- For bug 3340433
9450: IF (nvl(p_service_request_rec.inventory_item_id,-99) <> FND_API.G_MISS_NUM) then
9451: If (p_service_request_rec.inventory_item_id <> p_inventory_item_id) then
9452: --Raise an ignore message;
9453: CS_ServiceRequest_UTIL.Add_Param_Ignored_Msg(
9454: p_token_an => p_api_name,
9455: p_token_ip => 'p_inventory_item_id' );
9456: End if;
9457: END IF;
9466: IF (p_service_request_rec.current_serial_number <> FND_API.G_MISS_CHAR) AND
9467: (p_service_request_rec.customer_product_id <> FND_API.G_MISS_NUM)
9468: AND (p_sr_mode = 'CREATE') THEN
9469:
9470: CS_ServiceRequest_UTIL.Validate_Current_Serial
9471: ( p_api_name => p_api_name,
9472: p_parameter_name => 'p_current_serial_number',
9473: p_inventory_item_id => p_inventory_item_id,
9474: p_inventory_org_id => p_service_request_rec.inventory_org_id,
9488:
9489: IF p_service_request_rec.owning_dept_id <> FND_API.G_MISS_NUM AND
9490: p_sr_mode = 'CREATE'
9491: THEN
9492: CS_ServiceRequest_UTIL.Validate_Owning_department
9493: ( p_api_name => p_api_name
9494: , p_parameter_name => 'Owning Department'
9495: , p_inv_org_id => p_service_request_rec.maint_organization_id
9496: , p_owning_dept_id => p_service_request_rec.owning_dept_id
9508:
9509: IF (p_service_request_rec.problem_code <> FND_API.G_MISS_CHAR)
9510: AND (p_sr_mode = 'CREATE') THEN
9511:
9512: CS_ServiceRequest_UTIL.Validate_Problem_Code
9513: ( p_api_name => p_api_name,
9514: p_parameter_name => 'p_problem_code',
9515: p_problem_code => p_service_request_rec.problem_code,
9516: p_incident_type_id => p_service_request_rec.type_id,
9529: -----------Validation is required for Cust_Pref_Lang_Id,Comm_Pref_Code and
9530: -----------Category_Id.
9531:
9532: IF (p_service_request_rec.cust_pref_lang_code <> FND_API.G_MISS_CHAR) THEN
9533: CS_ServiceRequest_UTIL.Validate_Cust_Pref_Lang_Code
9534: ( p_api_name => p_api_name,
9535: p_parameter_name => 'p_cust_pref_lang_code',
9536: p_cust_pref_lang_code => p_service_request_rec.cust_pref_lang_code,
9537: x_return_status => l_return_status
9543: END IF;
9544:
9545: IF (p_service_request_rec.category_set_id <> FND_API.G_MISS_NUM)
9546: AND (p_sr_mode = 'CREATE') THEN
9547: CS_ServiceRequest_UTIL.Validate_Category_Set_Id
9548: ( p_api_name => p_api_name,
9549: p_parameter_name => 'p_category_set_id',
9550: p_category_id => p_service_request_rec.category_id,
9551: p_category_set_id => p_service_request_rec.category_set_id,
9562:
9563: IF (p_service_request_rec.external_reference <> FND_API.G_MISS_CHAR)
9564: AND (p_sr_mode = 'CREATE') THEN
9565: -- For bug 3746983
9566: CS_ServiceRequest_UTIL.Validate_External_Reference
9567: ( p_api_name => p_api_name,
9568: p_parameter_name => 'p_external_reference',
9569: p_external_reference => p_service_request_rec.external_reference,
9570: p_customer_product_id => p_service_request_rec.customer_product_id,
9579: END IF;
9580: END IF;
9581:
9582: IF (p_service_request_rec.system_id <> FND_API.G_MISS_NUM) THEN
9583: CS_ServiceRequest_UTIL.Validate_System_Id
9584: ( p_api_name => p_api_name,
9585: p_parameter_name => 'p_system_id',
9586: p_system_id => p_service_request_rec.system_id,
9587: x_return_status => l_return_status
9592: END IF;
9593: END IF;
9594:
9595: IF (p_service_request_rec.comm_pref_code <> FND_API.G_MISS_CHAR) THEN
9596: CS_ServiceRequest_UTIL.Validate_Comm_Pref_Code
9597: ( p_api_name => p_api_name,
9598: p_parameter_name => 'p_comm_pref_code',
9599: p_comm_pref_code => p_service_request_rec.comm_pref_code,
9600: x_return_status => l_return_status
9608: IF (p_service_request_rec.category_id <> FND_API.G_MISS_NUM AND
9609: (p_service_request_rec.category_set_id = FND_API.G_MISS_NUM OR
9610: p_service_request_rec.category_set_id IS NULL) )
9611: AND (p_sr_mode = 'CREATE') THEN
9612: CS_ServiceRequest_UTIL.Validate_Category_Id
9613: ( p_api_name => p_api_name,
9614: p_parameter_name => 'p_category_id',
9615: p_category_id => p_service_request_rec.category_id,
9616: p_category_set_id=> p_service_request_rec.category_set_id,
9622: END IF;
9623: END IF;
9624:
9625: IF (p_service_request_rec.group_type <> FND_API.G_MISS_CHAR) THEN
9626: CS_ServiceRequest_UTIL.Validate_Group_Type
9627: ( p_api_name => p_api_name,
9628: p_parameter_name => 'p_group_type',
9629: p_group_type => p_service_request_rec.group_type,
9630: --p_resource_type => p_service_request_rec.resource_type,
9637: END IF;
9638: END IF;
9639:
9640: IF (p_service_request_rec.owner_group_id <> FND_API.G_MISS_NUM) THEN
9641: CS_ServiceRequest_UTIL.Validate_Group_Id
9642: ( p_api_name => p_api_name,
9643: p_parameter_name => 'p_owner_group_id',
9644: p_group_type => p_service_request_rec.group_type,
9645: p_owner_group_id => p_service_request_rec.owner_group_id,
9653: END IF;
9654: END IF;
9655:
9656: IF (p_service_request_rec.exp_resolution_date <> FND_API.G_MISS_DATE) THEN
9657: CS_ServiceRequest_UTIL.Validate_Exp_Resolution_Date
9658: ( p_api_name => p_api_name,
9659: p_parameter_name => 'p_exp_resolution_date',
9660: p_exp_resolution_date => p_service_request_rec.exp_resolution_date,
9661: p_request_date => p_request_date,
9675:
9676: l_customer_type:= p_service_request_rec.caller_type;
9677:
9678: IF (p_service_request_rec.bill_to_party_id <> FND_API.G_MISS_NUM) THEN
9679: CS_ServiceRequest_UTIL.Validate_Bill_To_Ship_To_Party
9680: ( p_api_name => p_api_name,
9681: p_parameter_name => 'Bill_To Party',
9682: p_bill_to_party_id => p_service_request_rec.bill_to_party_id,
9683: p_customer_id => p_service_request_rec.customer_id,
9694: Commented now but should be uncommented for 11.5.10
9695: IF (FND_API.To_Boolean(p_service_request_rec.validate_bill_to_site) OR
9696: (p_service_request_rec.bill_to_site_id <> FND_API.G_MISS_NUM)) THEN
9697:
9698: CS_ServiceRequest_UTIL.Validate_Bill_To_Ship_To_Site
9699: ( p_api_name => p_api_name,
9700: p_parameter_name => 'Bill_To Site ',
9701: p_bill_to_site_id => p_service_request_rec.bill_to_site_id,
9702: p_bill_to_party_id => p_service_request_rec.bill_to_party_id,
9713: *****************************************************************/
9714:
9715: IF (p_service_request_rec.bill_to_Contact_id <> FND_API.G_MISS_NUM)
9716: AND (p_sr_mode = 'CREATE') THEN
9717: CS_ServiceRequest_UTIL.Validate_Bill_To_Ship_To_Ct
9718: ( p_api_name => p_api_name,
9719: p_parameter_name => 'Bill_To Contact',
9720: p_bill_to_contact_id => p_service_request_rec.bill_to_contact_id,
9721: p_bill_to_party_id => p_service_request_rec.bill_to_party_id ,
9737:
9738: l_customer_type:= p_service_request_rec.caller_type;
9739:
9740: IF (p_service_request_rec.ship_to_party_id <> FND_API.G_MISS_NUM) THEN
9741: CS_ServiceRequest_UTIL.Validate_Bill_To_Ship_To_Party
9742: ( p_api_name => p_api_name,
9743: p_parameter_name => 'Ship_To Party',
9744: p_bill_to_party_id => p_service_request_rec.ship_to_party_id,
9745: p_customer_id => p_service_request_rec.customer_id,
9758:
9759: IF (FND_API.To_Boolean(p_service_request_rec.validate_ship_to_site) OR
9760: (p_service_request_rec.ship_to_site_id <> FND_API.G_MISS_NUM)) THEN
9761:
9762: CS_ServiceRequest_UTIL.Validate_Bill_To_Ship_To_Site
9763: ( p_api_name => p_api_name,
9764: p_parameter_name => 'Ship_To Site ',
9765: p_bill_to_site_id => p_service_request_rec.ship_to_site_id,
9766: p_bill_to_party_id => p_service_request_rec.ship_to_party_id,
9779: -- Validate the Ship_To_Contact - Use the validate_bill_to_Contact procedure itself
9780:
9781: IF (p_service_request_rec.ship_to_Contact_id <> FND_API.G_MISS_NUM)
9782: AND (p_sr_mode = 'CREATE') THEN
9783: CS_ServiceRequest_UTIL.Validate_Bill_To_Ship_To_Ct
9784: ( p_api_name => p_api_name,
9785: p_parameter_name => 'Ship_To Contact',
9786: p_bill_to_contact_id => p_service_request_rec.ship_to_contact_id,
9787: p_bill_to_party_id => p_service_request_rec.ship_to_party_id ,
9797: --Code added to validate install site
9798: --IF FND_API.To_Boolean(p_service_request_rec.validate_install_site) THEN
9799: IF ( p_service_request_rec.install_site_id <> FND_API.G_MISS_NUM AND
9800: p_service_request_rec.install_site_id IS NOT NULL) THEN
9801: CS_ServiceRequest_UTIL.Validate_Install_Site (
9802: p_parameter_name => 'Install Site',
9803: p_install_site_id => p_service_request_rec.install_site_id,
9804: p_customer_id => l_customer_id,
9805: x_return_status => l_return_status
9811: END IF;
9812:
9813: IF ( p_service_request_rec.install_site_use_id <> FND_API.G_MISS_NUM AND
9814: p_service_request_rec.install_site_use_id IS NOT NULL) THEN
9815: CS_ServiceRequest_UTIL.Validate_Install_Site (
9816: p_parameter_name => 'Install Site Use',
9817: p_install_site_id => p_service_request_rec.install_site_use_id,
9818: p_customer_id => l_customer_id,
9819: x_return_status => l_return_status
9829: ( p_service_request_rec.ship_to_site_use_id <> FND_API.G_MISS_NUM AND
9830: p_service_request_rec.ship_to_site_use_id IS NOT NULL ) AND
9831: ( p_sr_mode = 'CREATE') ) THEN
9832:
9833: CS_ServiceRequest_UTIL.Validate_Site_Site_Use
9834: ( p_api_name => p_api_name,
9835: p_parameter_name => 'Ship_To Site and/or Site Use ',
9836: p_site_id => p_service_request_rec.ship_to_site_id,
9837: p_site_use_id => p_service_request_rec.ship_to_site_use_id,
9848: ( p_service_request_rec.ship_to_site_id IS NULL OR
9849: p_service_request_rec.ship_to_site_id = FND_API.G_MISS_NUM ) AND
9850: ( p_sr_mode = 'CREATE') ) THEN
9851:
9852: CS_ServiceRequest_UTIL.Validate_Bill_Ship_Site_Use
9853: ( p_api_name => p_api_name,
9854: p_parameter_name => 'Ship_To Site Use ',
9855: p_site_use_id => p_service_request_rec.ship_to_site_use_id,
9856: p_party_id => p_service_request_rec.ship_to_party_id,
9867: ( p_service_request_rec.ship_to_site_use_id IS NULL OR
9868: p_service_request_rec.ship_to_site_use_id = FND_API.G_MISS_NUM ) AND
9869: ( p_sr_mode = 'CREATE') ) THEN
9870:
9871: CS_ServiceRequest_UTIL.Validate_Bill_To_Ship_To_Site
9872: ( p_api_name => p_api_name,
9873: p_parameter_name => 'Ship_To Site ',
9874: p_bill_to_site_id => p_service_request_rec.ship_to_site_id,
9875: p_bill_to_party_id => p_service_request_rec.ship_to_party_id,
9889: ( p_service_request_rec.bill_to_site_use_id <> FND_API.G_MISS_NUM AND
9890: p_service_request_rec.bill_to_site_use_id IS NOT NULL ) AND
9891: ( p_sr_mode = 'CREATE') ) THEN
9892:
9893: CS_ServiceRequest_UTIL.Validate_Site_Site_Use
9894: ( p_api_name => p_api_name,
9895: p_parameter_name => 'Bill_to Site and/or Site Use ',
9896: p_site_id => p_service_request_rec.bill_to_site_id,
9897: p_site_use_id => p_service_request_rec.bill_to_site_use_id,
9908: ( p_service_request_rec.bill_to_site_id IS NULL OR
9909: p_service_request_rec.bill_to_site_id = FND_API.G_MISS_NUM ) AND
9910: ( p_sr_mode = 'CREATE') ) THEN
9911:
9912: CS_ServiceRequest_UTIL.Validate_Bill_Ship_Site_Use
9913: ( p_api_name => p_api_name,
9914: p_parameter_name => 'Bill_to Site Use ',
9915: p_site_use_id => p_service_request_rec.bill_to_site_use_id,
9916: p_party_id => p_service_request_rec.bill_to_party_id,
9927: p_service_request_rec.bill_to_site_id IS NOT NULL ) AND
9928: ( p_service_request_rec.bill_to_site_use_id IS NULL OR
9929: p_service_request_rec.bill_to_site_use_id = FND_API.G_MISS_NUM ) AND
9930: ( p_sr_mode = 'CREATE') ) THEN
9931: CS_ServiceRequest_UTIL.Validate_Bill_To_Ship_To_Site
9932: ( p_api_name => p_api_name,
9933: p_parameter_name => 'Bill_to Site ',
9934: p_bill_to_site_id => p_service_request_rec.bill_to_site_id,
9935: p_bill_to_party_id => p_service_request_rec.bill_to_party_id,
9945:
9946: IF (p_service_request_rec.resolution_code <> FND_API.G_MISS_CHAR)
9947: AND (p_sr_mode = 'CREATE') THEN
9948:
9949: cs_servicerequest_util.resolution_code_cross_val (
9950: p_parameter_name => 'p_resolution_code',
9951: p_resolution_code => p_service_request_rec.resolution_code,
9952: p_problem_code => p_service_request_rec.problem_code,
9953: p_incident_type_id => p_service_request_rec.type_id,
9962: END IF;
9963: END IF;
9964:
9965: IF (p_service_request_rec.act_resolution_date <> FND_API.G_MISS_DATE) THEN
9966: CS_ServiceRequest_UTIL.Validate_Act_Resolution_Date
9967: ( p_api_name => p_api_name,
9968: p_parameter_name => 'p_act_resolution_date',
9969: p_act_resolution_date => p_service_request_rec.act_resolution_date,
9970: p_request_date => p_request_date,
9979: IF (p_service_request_rec.current_contact_time_diff <> FND_API.G_MISS_NUM) THEN
9980: IF ((p_service_request_rec.current_contact_time_diff < -24) OR
9981: (p_service_request_rec.current_contact_time_diff > 24)) THEN
9982:
9983: CS_ServiceRequest_UTIL.Add_Invalid_Argument_Msg
9984: ( p_token_an => 'p_api_name',
9985: p_token_v => TO_CHAR(p_service_request_rec.current_contact_time_diff),
9986: p_token_p => 'p_contact_time_diff',
9987: p_table_name => G_TABLE_NAME ,
9995: IF (p_service_request_rec.rep_by_time_difference <> FND_API.G_MISS_NUM) THEN
9996: IF ((p_service_request_rec.rep_by_time_difference < -24) OR
9997: (p_service_request_rec.rep_by_time_difference > 24)) THEN
9998:
9999: CS_ServiceRequest_UTIL.Add_Invalid_Argument_Msg
10000: ( p_token_an => 'p_api_name',
10001: p_token_v => TO_CHAR(p_service_request_rec.rep_by_time_difference),
10002: p_token_p => 'p_represented_by_time_diff',
10003: p_table_name => G_TABLE_NAME ,
10015: (p_service_request_rec.contract_id IS NOT NULL) AND
10016: (p_service_request_rec.contract_service_id IS NULL OR
10017: p_service_request_rec.contract_service_id = FND_API.G_MISS_NUM) THEN
10018:
10019: CS_ServiceRequest_UTIL.Validate_Contract_Id(
10020: p_api_name => p_api_name,
10021: p_parameter_name => 'p_contract_id',
10022: p_contract_id => p_service_request_rec.contract_id,
10023: x_contract_number => p_contract_number,
10045: IF (p_service_request_rec.caller_type = 'ORGANIZATION') THEN
10046:
10047: --p_org_id => p_org_id,
10048:
10049: CS_ServiceRequest_UTIL.Validate_Account_Id(
10050: p_api_name => p_api_name,
10051: p_parameter_name => 'p_account_id',
10052: p_account_id => p_service_request_rec.account_id,
10053: p_customer_id => p_service_request_rec.customer_id,
10058: RETURN;
10059: END IF;
10060: ELSIF (p_service_request_rec.caller_type = 'PERSON') THEN
10061:
10062: CS_ServiceRequest_UTIL.Validate_Account_Id(
10063: p_api_name => p_api_name,
10064: p_parameter_name => 'p_account_id',
10065: p_account_id => p_service_request_rec.account_id,
10066: p_customer_id => p_service_request_rec.customer_id,
10081:
10082: IF (p_service_request_rec.platform_id <> FND_API.G_MISS_NUM AND
10083: p_service_request_rec.platform_id IS NOT NULL) THEN
10084:
10085: CS_ServiceRequest_UTIL.Validate_Platform_Id(
10086: p_api_name => p_api_name,
10087: p_parameter_name => 'p_platform_id',
10088: p_platform_id => p_service_request_rec.platform_id,
10089: p_organization_id => p_service_request_rec.inv_platform_org_id,
10105: p_service_request_rec.platform_version_id is NOT NULL AND
10106: p_service_request_rec.platform_version <> FND_API.G_MISS_CHAR AND
10107: p_service_request_rec.platform_version is NOT NULL
10108: )THEN
10109: CS_ServiceRequest_UTIL.Add_Invalid_Argument_Msg
10110: ( p_token_an => p_api_name,
10111: p_token_v => p_service_request_rec.platform_version,
10112: p_token_p => 'p_platform_version',
10113: p_table_name => G_TABLE_NAME ,
10124: p_service_request_rec.platform_id IS NOT NULL) AND
10125: (p_service_request_rec.platform_version_id <> FND_API.G_MISS_NUM AND
10126: p_service_request_rec.platform_version_id IS NOT NULL) THEN
10127:
10128: CS_ServiceRequest_UTIL.Validate_Platform_Version_Id(
10129: p_api_name => p_api_name,
10130: p_parameter_name => 'p_platform_Version_id',
10131: p_platform_id => p_service_request_rec.platform_id,
10132: p_organization_id => p_service_request_rec.inv_platform_org_id,
10145: --
10146: IF (p_service_request_rec.territory_id <> FND_API.G_MISS_NUM AND
10147: p_service_request_rec.territory_id IS NOT NULL) THEN
10148:
10149: CS_ServiceRequest_UTIL.Validate_Territory_Id(
10150: p_api_name => p_api_name,
10151: p_parameter_name => 'p_territory_id',
10152: p_territory_id => p_service_request_rec.territory_id,
10153: p_owner_id => p_service_request_rec.owner_id,
10168: IF (p_service_request_rec.cp_component_id <> FND_API.G_MISS_NUM AND
10169: p_service_request_rec.cp_component_id IS NOT NULL)
10170: AND (p_sr_mode = 'CREATE') THEN
10171:
10172: CS_ServiceRequest_UTIL.Validate_CP_Comp_Id(
10173: p_api_name => p_api_name,
10174: p_parameter_name => 'p_cp_component_id',
10175: p_cp_component_id => p_service_request_rec.cp_component_id,
10176: p_customer_product_id => p_service_request_rec.customer_product_id,
10184:
10185: IF (p_service_request_rec.inv_component_id <> FND_API.G_MISS_NUM AND
10186: p_service_request_rec.inv_component_id IS NOT NULL) THEN
10187:
10188: CS_ServiceRequest_UTIL.INV_COMPONENT_CROSS_VAL (
10189: p_parameter_name => 'Inventory component',
10190: p_cp_component_id => p_service_request_rec.cp_component_id,
10191: p_inv_component_id => p_service_request_rec.inv_component_id,
10192: x_return_status => l_return_status );
10210: IF (p_service_request_rec.customer_product_id <> FND_API.G_MISS_NUM AND
10211: p_service_request_rec.customer_product_id IS NOT NULL)
10212: AND (p_sr_mode = 'CREATE') THEN
10213:
10214: CS_ServiceRequest_UTIL.Validate_Product_Version(
10215: p_parameter_name => 'p_product_revision',
10216: p_product_version => x_product_revision,
10217: p_instance_id => p_service_request_rec.customer_product_id,
10218: p_inventory_org_id => p_service_request_rec.inventory_org_id,
10217: p_instance_id => p_service_request_rec.customer_product_id,
10218: p_inventory_org_id => p_service_request_rec.inventory_org_id,
10219: x_return_status => l_return_status);
10220: /***
10221: CS_ServiceRequest_UTIL.Validate_Product_Revision(
10222: p_api_name => p_api_name,
10223: p_parameter_name => 'p_product_revision',
10224: p_product_revision => p_service_request_rec.product_revision,
10225: p_customer_product_id => p_service_request_rec.customer_product_id,
10242: -- p_service_request_rec.component_version IS NOT NULL)
10243: -- AND (p_sr_mode = 'CREATE') THEN
10244:
10245: -- -- For 3337848
10246: -- CS_ServiceRequest_UTIL.Validate_Component_Version(
10247: -- p_api_name => p_api_name,
10248: -- p_parameter_name => 'p_component_version',
10249: -- p_component_version => p_service_request_rec.component_version,
10250: -- p_cp_component_id => p_service_request_rec.cp_component_id,
10262: p_service_request_rec.cp_component_id IS NOT NULL)
10263: AND (p_sr_mode = 'CREATE') THEN
10264:
10265: -- For 3337848
10266: CS_ServiceRequest_UTIL.Validate_Product_Version(
10267: p_parameter_name => 'p_component_version',
10268: p_product_version => x_component_version,
10269: p_instance_id => p_service_request_rec.cp_component_id,
10270: p_inventory_org_id => p_service_request_rec.inventory_org_id,
10281: IF (p_service_request_rec.cp_subcomponent_id <> FND_API.G_MISS_NUM AND
10282: p_service_request_rec.cp_subcomponent_id IS NOT NULL)
10283: AND (p_sr_mode = 'CREATE') THEN
10284:
10285: CS_ServiceRequest_UTIL.Validate_CP_SubComp_Id(
10286: p_api_name => p_api_name,
10287: p_parameter_name => 'p_cp_subcomponent_id',
10288: p_cp_subcomponent_id => p_service_request_rec.cp_subcomponent_id,
10289: p_cp_component_id => p_service_request_rec.cp_component_id,
10299: -- For bug 3324210
10300: IF (p_service_request_rec.inv_subcomponent_id <> FND_API.G_MISS_NUM AND
10301: p_service_request_rec.inv_subcomponent_id IS NOT NULL) THEN
10302:
10303: CS_ServiceRequest_UTIL.INV_SUBCOMPONENT_CROSS_VAL (
10304: p_parameter_name => 'inv subcomponent',
10305: p_inv_subcomponent_id => p_service_request_rec.inv_subcomponent_id,
10306: p_cp_subcomponent_id => p_service_request_rec.cp_subcomponent_id,
10307: x_return_status => l_return_status );
10323: -- p_service_request_rec.subcomponent_version IS NOT NULL)
10324: -- AND (p_sr_mode = 'CREATE') THEN
10325:
10326: -- For bug 3337848
10327: -- CS_ServiceRequest_UTIL.Validate_Subcomponent_Version(
10328: -- p_api_name => p_api_name,
10329: -- p_parameter_name => 'p_subcomponent_version',
10330: -- p_subcomponent_version => p_service_request_rec.subcomponent_version,
10331: -- p_cp_component_id => p_service_request_rec.cp_component_id,
10346: p_service_request_rec.cp_subcomponent_id IS NOT NULL)
10347: AND (p_sr_mode = 'CREATE') THEN
10348:
10349: -- For bug 3337848
10350: CS_ServiceRequest_UTIL.Validate_Product_Version(
10351: p_parameter_name => 'p_subcomponent_version',
10352: p_product_version => x_subcomponent_version,
10353: p_instance_id => p_service_request_rec.cp_subcomponent_id,
10354: p_inventory_org_id => p_service_request_rec.inventory_org_id,
10369: --
10370: IF (p_service_request_rec.inv_item_revision <> FND_API.G_MISS_CHAR )
10371: AND (p_sr_mode = 'CREATE') THEN
10372:
10373: CS_ServiceRequest_UTIL.Validate_Inv_Item_Rev(
10374: p_api_name => p_api_name,
10375: p_parameter_name => 'p_inv_item_revision',
10376: p_inv_item_revision => p_service_request_rec.inv_item_revision,
10377: p_inventory_item_id => p_inventory_item_id,
10390: IF (p_service_request_rec.inv_component_id <> FND_API.G_MISS_NUM AND
10391: p_service_request_rec.inv_component_id IS NOT NULL)
10392: AND (p_sr_mode = 'CREATE') THEN
10393:
10394: CS_ServiceRequest_UTIL.Validate_Inv_Comp_Id(
10395: p_api_name => p_api_name,
10396: p_parameter_name => 'p_inv_component_id',
10397: p_inventory_org_id => p_service_request_rec.inventory_org_id,
10398: p_inv_component_id => p_service_request_rec.inv_component_id,
10410: IF (p_service_request_rec.inv_component_version <> FND_API.G_MISS_CHAR AND
10411: p_service_request_rec.inv_component_version IS NOT NULL)
10412: AND (p_sr_mode = 'CREATE') THEN
10413:
10414: CS_ServiceRequest_UTIL.Validate_Inv_Comp_Ver(
10415: p_api_name => p_api_name,
10416: p_parameter_name => 'p_inv_component_version',
10417: p_inventory_org_id => p_service_request_rec.inventory_org_id,
10418: p_inv_component_id => p_service_request_rec.inv_component_id,
10431: IF (p_sr_mode = 'CREATE' AND
10432: p_service_request_rec.inv_subcomponent_id <> FND_API.G_MISS_NUM AND
10433: p_service_request_rec.inv_subcomponent_id IS NOT NULL) THEN
10434:
10435: CS_ServiceRequest_UTIL.Validate_Inv_SubComp_Id(
10436: p_api_name => p_api_name,
10437: p_parameter_name => 'p_inv_subcomponent_id',
10438: p_inventory_org_id => p_service_request_rec.inventory_org_id,
10439: p_inv_subcomponent_id => p_service_request_rec.inv_subcomponent_id,
10452: IF (p_service_request_rec.inv_subcomponent_version <> FND_API.G_MISS_CHAR AND
10453: p_service_request_rec.inv_subcomponent_version IS NOT NULL)
10454: AND (p_sr_mode = 'CREATE') THEN
10455:
10456: CS_ServiceRequest_UTIL.Validate_Inv_SubComp_Ver(
10457: p_api_name => p_api_name,
10458: p_parameter_name => 'p_inv_subcomponent_version',
10459: p_inventory_org_id => p_service_request_rec.inventory_org_id,
10460: p_inv_subcomponent_id =>p_service_request_rec.inv_subcomponent_id,
10476: p_request_date IS NOT NULL) AND
10477: (p_service_request_rec.incident_occurred_date <> FND_API.G_MISS_DATE AND
10478: p_service_request_rec.incident_occurred_date IS NOT NULL) THEN
10479:
10480: CS_ServiceRequest_UTIL.Validate_Inc_Reported_Date(
10481: p_api_name => p_api_name,
10482: p_parameter_name => 'p_incident_date',
10483: p_request_date => p_request_date,
10484: p_inc_occurred_date => p_service_request_rec.incident_occurred_date,
10496: p_service_request_rec.incident_occurred_date IS NOT NULL) AND
10497: (p_request_date <> FND_API.G_MISS_DATE AND
10498: p_request_date IS NOT NULL) THEN
10499:
10500: CS_ServiceRequest_UTIL.Validate_Inc_Occurred_Date(
10501: p_api_name => p_api_name,
10502: p_parameter_name => 'p_incident_occurred_date',
10503: p_inc_occurred_date => p_service_request_rec.incident_occurred_date,
10504: p_request_date => p_request_date,
10514: --
10515: IF (p_service_request_rec.incident_resolved_date <> FND_API.G_MISS_DATE AND
10516: p_service_request_rec.incident_resolved_date IS NOT NULL) THEN
10517:
10518: CS_ServiceRequest_UTIL.Validate_Inc_Resolved_Date(
10519: p_api_name => p_api_name,
10520: p_parameter_name => 'p_incident_resolved_date',
10521: p_inc_resolved_date => p_service_request_rec.incident_resolved_date,
10522: p_request_date => p_request_date,
10532: --
10533: IF (p_service_request_rec.inc_responded_by_date <> FND_API.G_MISS_DATE AND
10534: p_service_request_rec.inc_responded_by_date IS NOT NULL) THEN
10535:
10536: CS_ServiceRequest_UTIL.Validate_Inc_Responded_Date(
10537: p_api_name => p_api_name,
10538: p_parameter_name => 'p_inc_responded_by_date',
10539: p_inc_responded_by_date => p_service_request_rec.inc_responded_by_date,
10540: p_request_date => p_request_date,
10555: this code is moved to vldt_sr_rec procedure
10556: IF (p_service_request_rec.incident_location_id <> FND_API.G_MISS_NUM AND
10557: p_service_request_rec.incident_location_id IS NOT NULL)
10558: THEN
10559: CS_ServiceRequest_UTIL.Validate_Inc_Location_Id(
10560: p_api_name => p_api_name,
10561: p_parameter_name => 'p_incident_location_id',
10562: p_incident_location_type => p_service_request_rec.incident_location_type,
10563: p_incident_location_id => p_service_request_rec.incident_location_id,
10574: --
10575: IF (p_service_request_rec.incident_country <> FND_API.G_MISS_CHAR AND
10576: p_service_request_rec.incident_country IS NOT NULL) THEN
10577:
10578: CS_ServiceRequest_UTIL.Validate_Incident_Country(
10579: p_api_name => p_api_name,
10580: p_parameter_name => 'p_incident_country',
10581: p_incident_country => p_service_request_rec.incident_country,
10582: x_return_status => l_return_status );
10593: IF (p_service_request_rec.bill_to_account_id <> FND_API.G_MISS_NUM AND
10594: p_service_request_rec.bill_to_account_id IS NOT NULL)
10595: AND (p_sr_mode = 'CREATE') THEN
10596:
10597: CS_ServiceRequest_UTIL.Validate_Bill_To_Ship_To_Acct
10598: ( p_api_name => p_api_name,
10599: p_parameter_name => 'Bill_To Account',
10600: p_account_id => p_service_request_rec.bill_to_account_id,
10601: p_party_id => p_service_request_rec.bill_to_party_id,
10614: IF (p_service_request_rec.ship_to_account_id <> FND_API.G_MISS_NUM AND
10615: p_service_request_rec.ship_to_account_id IS NOT NULL)
10616: AND (p_sr_mode = 'CREATE') THEN
10617:
10618: CS_ServiceRequest_UTIL.Validate_bill_To_Ship_To_Acct
10619: ( p_api_name => p_api_name,
10620: p_parameter_name => 'Ship_To Account',
10621: p_account_id => p_service_request_rec.ship_to_account_id,
10622: p_party_id => p_service_request_rec.ship_to_party_id,
10633:
10634: IF (p_service_request_rec.customer_phone_id <> FND_API.G_MISS_NUM AND
10635: p_service_request_rec.customer_phone_id IS NOT NULL ) THEN
10636:
10637: CS_ServiceRequest_UTIL.Validate_Per_Contact_Point_Id
10638: ( p_api_name => p_api_name,
10639: p_parameter_name => 'p_contact_point_id',
10640: p_contact_point_type => 'PHONE',
10641: p_contact_point_id => p_service_request_rec.customer_phone_id,
10654:
10655: IF (p_service_request_rec.customer_email_id <> FND_API.G_MISS_NUM AND
10656: p_service_request_rec.customer_email_id IS NOT NULL ) THEN
10657:
10658: CS_ServiceRequest_UTIL.Validate_Per_Contact_Point_Id
10659: ( p_api_name => p_api_name,
10660: p_parameter_name => 'p_contact_point_id',
10661: p_contact_point_type => 'EMAIL',
10662: p_contact_point_id => p_service_request_rec.customer_email_id,
10876: Initialize_audit_rec(
10877: p_sr_audit_record => x_audit_vals_rec) ;
10878:
10879: --
10880: --CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg(l_api_name_full, 'step #1');
10881:
10882: -- Check if the mandatory parameters are specified. If not, return error.
10883:
10884: IF (l_service_request_rec.type_id = FND_API.G_MISS_NUM OR
10883:
10884: IF (l_service_request_rec.type_id = FND_API.G_MISS_NUM OR
10885: l_service_request_rec.type_id IS NULL) THEN
10886:
10887: CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg
10888: (p_token_an => l_api_name_full,
10889: p_token_np => 'SR Type',
10890: p_table_name => G_TABLE_NAME,
10891: p_column_name => 'INCIDENT_TYPE_ID');
10896:
10897: IF (l_service_request_rec.status_id = FND_API.G_MISS_NUM OR
10898: l_service_request_rec.status_id IS NULL) THEN
10899:
10900: CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg
10901: (p_token_an => l_api_name_full,
10902: p_token_np => 'SR Status',
10903: p_table_name => G_TABLE_NAME,
10904: p_column_name => 'INCIDENT_STATUS_ID');
10909:
10910: IF (l_service_request_rec.severity_id = FND_API.G_MISS_NUM OR
10911: l_service_request_rec.severity_id IS NULL) THEN
10912:
10913: CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg
10914: (p_token_an => l_api_name_full,
10915: p_token_np => 'SR Severity',
10916: p_table_name => G_TABLE_NAME,
10917: p_column_name => 'SEVERITY_ID');
10922: -- Request Date is a reqd field, so check if passed, else return error
10923: IF (l_service_request_rec.request_date = FND_API.G_MISS_DATE OR
10924: l_service_request_rec.request_date IS NULL) THEN
10925:
10926: CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg
10927: (p_token_an => l_api_name_full,
10928: p_token_np => 'SR Request Date',
10929: p_table_name => G_TABLE_NAME,
10930: p_column_name => 'REQUEST_DATE');
10935: -- Summary is a reqd field, so check if passed, else return error
10936: IF (l_service_request_rec.summary = FND_API.G_MISS_CHAR OR
10937: l_service_request_rec.summary IS NULL) THEN
10938:
10939: CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg
10940: (p_token_an => l_api_name_full,
10941: p_token_np => 'SR Summary',
10942: p_table_name => G_TABLE_NAME,
10943: p_column_name => 'SUMMARY');
10948: -- for cmro_eam
10949:
10950: IF (p_maintenance_flag = 'Y' OR p_maintenance_flag = 'y') THEN
10951: IF (l_service_request_rec.inventory_org_id = FND_API.G_MISS_NUM) THEN
10952: CS_ServiceRequest_UTIL.Add_Missing_Param_Msg(l_api_name_full, 'Inventory Org ID');
10953: RAISE FND_API.G_EXC_ERROR;
10954: ELSIF (l_service_request_rec.inventory_org_id IS NULL) THEN
10955: CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg(l_api_name_full, 'Inventory Org ID');
10956: RAISE FND_API.G_EXC_ERROR;
10951: IF (l_service_request_rec.inventory_org_id = FND_API.G_MISS_NUM) THEN
10952: CS_ServiceRequest_UTIL.Add_Missing_Param_Msg(l_api_name_full, 'Inventory Org ID');
10953: RAISE FND_API.G_EXC_ERROR;
10954: ELSIF (l_service_request_rec.inventory_org_id IS NULL) THEN
10955: CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg(l_api_name_full, 'Inventory Org ID');
10956: RAISE FND_API.G_EXC_ERROR;
10957: END IF;
10958: END IF;
10959: -- end of cmro_eam
11104:
11105: /*Commented this code for backward compatibility, that if someone
11106: passes a creation program code as NULL or G_MISS_CHAR, we are supporting
11107: it now and defaulting it to UNKNOWN
11108: CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg
11109: (p_token_an => l_api_name_full,
11110: p_token_np => 'SR Creation Program Code',
11111: p_table_name => G_TABLE_NAME,
11112: p_column_name => 'CREATION_PROGRAM_CODE');
11178:
11179: --AND(l_service_request_rec.customer_company_name = FND_API.G_MISS_CHAR OR
11180: -- l_service_request_rec.customer_company_name IS NULL)
11181:
11182: CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg
11183: (p_token_an => l_api_name_full,
11184: p_token_np => 'SR Customer',
11185: p_table_name => null,
11186: p_column_name => 'CUSTOMER_COMPANY_NAME');
11197:
11198: ELSE
11199: --Customer Id is not passed, but customer number may be passed
11200: --Retrieve the customer_id from the customer_number
11201: CS_ServiceRequest_UTIL.Convert_Customer_To_ID(
11202: p_api_name=>l_api_name,
11203: p_parameter_name_nb=>'l_service_request_rec.customer_number',
11204: p_parameter_name_n=> 'Customer_Name',
11205: p_customer_number=>l_service_request_rec.customer_number,
11236: -- raise error if customer_id is not passed . bug #3299567
11237: IF ((l_service_request_rec.customer_id = FND_API.G_MISS_NUM OR
11238: l_service_request_rec.customer_id IS NULL )) THEN
11239:
11240: CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg(l_api_name_full, 'SR Customer');
11241: RAISE FND_API.G_EXC_ERROR;
11242:
11243: END IF;
11244:
11247:
11248: ELSE
11249: -- caller type passed is not valid
11250:
11251: CS_ServiceRequest_UTIL.Add_Invalid_Argument_Msg
11252: ( p_token_an => l_api_name_full,
11253: p_token_v => l_service_request_rec.caller_type,
11254: p_token_p => 'p_caller_type',
11255: p_table_name => G_TABLE_NAME ,
11257:
11258: RAISE FND_API.G_EXC_ERROR;
11259: END IF;
11260:
11261: --CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg(l_api_name_full, 'step #2');
11262: --
11263: /*11.5.10 Misc ER added logic to handle usability related changes*/
11264:
11265: -- For bug 3512501 - added begin..exception
11269: FROM cs_incident_statuses_vl
11270: WHERE incident_status_id=l_service_request_rec.status_id ;
11271: exception
11272: when no_data_found then
11273: CS_ServiceRequest_UTIL.Add_Invalid_Argument_Msg( p_token_an => l_api_name_full,
11274: p_token_v => TO_CHAR(l_service_request_rec.status_id),
11275: p_token_p => 'p_status_id',
11276: p_table_name => G_TABLE_NAME,
11277: p_column_name => 'INCIDENT_STATUS_ID' );
11308: INTO l_test
11309: FROM cs_incidents_all_b
11310: WHERE incident_id = p_request_id;
11311:
11312: CS_ServiceRequest_UTIL.Add_Invalid_Argument_Msg
11313: ( p_token_an => l_api_name_full,
11314: p_token_v => p_request_id,
11315: p_token_p => 'p_request_id' ,
11316: p_table_name => G_TABLE_NAME ,
11337: INTO l_test
11338: FROM cs_incidents_all_b
11339: WHERE incident_number = p_request_number;
11340:
11341: CS_ServiceRequest_UTIL.Add_Invalid_Argument_Msg
11342: ( p_token_an => l_api_name_full,
11343: p_token_v => p_request_number,
11344: p_token_p => 'p_request_number',
11345: p_table_name => G_TABLE_NAME,
11359: -- replaced validation of org_id with the procedure call below and set local variable
11360: -- to p_org_id
11361: IF p_org_id IS NOT NULL
11362: THEN
11363: CS_SERVICEREQUEST_UTIL.validate_org_id
11364: ( p_org_id => p_org_id
11365: , x_return_status => l_return_status
11366: );
11367: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
11374:
11375: --
11376: -- Validate the user and login id's
11377: --
11378: CS_ServiceRequest_UTIL.Validate_Who_Info
11379: ( p_api_name => l_api_name_full,
11380: p_parameter_name_usr => 'p_user_id',
11381: p_parameter_name_login => 'p_login_id',
11382: p_user_id => p_user_id,
11390: --
11391: IF l_service_request_rec.created_by IS NOT NULL AND
11392: l_service_request_rec.created_by <> FND_API.G_Miss_NUM THEN
11393:
11394: CS_ServiceRequest_UTIL.Validate_Who_Info
11395: ( p_api_name => l_api_name_full,
11396: p_parameter_name_usr => 'p_created_by',
11397: p_parameter_name_login => NULL,
11398: p_user_id => l_service_request_rec.created_by,
11409: --
11410: IF l_service_request_rec.last_updated_by IS NOT NULL AND
11411: l_service_request_rec.last_updated_by <> FND_API.G_Miss_NUM THEN
11412:
11413: CS_ServiceRequest_UTIL.Validate_Who_Info
11414: ( p_api_name => l_api_name_full,
11415: p_parameter_name_usr => 'p_last_updated_by',
11416: p_parameter_name_login => NULL,
11417: p_user_id => l_service_request_rec.last_updated_by,
11423: END IF;
11424:
11425: END IF ;
11426:
11427: --CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg(l_api_name_full, 'step #2.1');
11428:
11429:
11430: --CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg(l_api_name_full, 'step #2.2');
11431:
11426:
11427: --CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg(l_api_name_full, 'step #2.1');
11428:
11429:
11430: --CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg(l_api_name_full, 'step #2.2');
11431:
11432: --
11433: -- Type, status, severity, resource_type, owner and publish flag are always validated
11434: -- Urgency, problem code, expected resolution date, resolution code, and
11541: AND l_service_request_rec.incident_country <> FND_API.G_MISS_CHAR) THEN
11542: l_service_request_val_rec.incident_country := l_service_request_rec.incident_country;
11543: END IF;
11544:
11545: --CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg(l_api_name_full, 'step #2.3');
11546:
11547: IF (nvl(l_service_request_rec.bill_to_site_id,-99) <> FND_API.G_MISS_NUM) THEN
11548: l_service_request_val_rec.validate_bill_to_site := FND_API.G_TRUE;
11549: l_service_request_val_rec.bill_to_site_id := l_service_request_rec.bill_to_site_id;
11560: IF (nvl(l_service_request_rec.bill_to_party_id, -99) <> FND_API.G_MISS_NUM) THEN
11561: l_service_request_val_rec.bill_to_party_id := l_service_request_rec.bill_to_party_id;
11562: END IF;
11563:
11564: --CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg(l_api_name_full, 'step #2.4');
11565:
11566: IF (nvl(l_service_request_rec.ship_to_site_id, -99) <> FND_API.G_MISS_NUM) THEN
11567: l_service_request_val_rec.validate_ship_to_site := FND_API.G_TRUE;
11568: l_service_request_val_rec.ship_to_site_id := l_service_request_rec.ship_to_site_id;
11580: IF (nvl(l_service_request_rec.ship_to_party_id,-99) <> FND_API.G_MISS_NUM) THEN
11581: l_service_request_val_rec.ship_to_party_id := l_service_request_rec.ship_to_party_id;
11582: END IF;
11583:
11584: --CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg(l_api_name_full, 'step #2.5');
11585:
11586: IF ( l_service_request_rec.install_site_id <> FND_API.G_MISS_NUM ) THEN
11587: l_service_request_val_rec.validate_install_site := FND_API.G_TRUE;
11588: l_service_request_val_rec.install_site_id := l_service_request_rec.install_site_id;
11914: IF l_bill_to_site_use_id <> FND_API.G_MISS_NUM THEN
11915: l_service_request_rec.bill_to_site_use_id := l_bill_to_site_use_id;
11916: END IF;
11917:
11918: --cs_sERviceRequest_UTIL.Add_Null_Parameter_Msg(l_api_name_full, 'step #2.7');
11919:
11920: --
11921: -- If customer product ID is passed in and validated, use the inventory
11922: -- item ID retrieved from the CS_CUSTOMER_PRODUCTS_ALL table.
11941: (l_service_request_rec.closed_date IS NULL)) THEN
11942: l_service_request_rec.closed_date := SYSDATE;
11943: ELSIF (l_service_request_rec.closed_date IS NOT NULL) THEN
11944:
11945: CS_ServiceRequest_UTIL.Validate_Closed_Date
11946: ( p_api_name => l_api_name_full,
11947: p_parameter_name => 'p_closed_date',
11948: p_closed_date => l_service_request_rec.closed_date,
11949: p_request_date => l_service_request_rec.request_date,
11956: ELSE
11957: IF ((l_service_request_rec.closed_date <> FND_API.G_MISS_DATE) AND
11958: (l_service_request_rec.closed_date IS NOT NULL)) THEN
11959:
11960: CS_ServiceRequest_UTIL.Add_Param_Ignored_Msg
11961: (p_token_an => l_api_name_full,
11962: p_token_ip => 'p_closed_date',
11963: p_table_name => G_TABLE_NAME,
11964: p_column_name => 'CLOSED_DATE');
11970: -- For bug 3635269
11971: /* IF (l_service_request_rec.sr_creation_channel <> FND_API.G_MISS_CHAR AND
11972: l_service_request_rec.sr_creation_channel IS NOT NULL) THEN
11973:
11974: CS_ServiceRequest_UTIL.Validate_SR_Channel(
11975: p_api_name => l_api_name_full,
11976: p_parameter_name => 'p_sr_creation_channel',
11977: p_sr_creation_channel => l_service_request_rec.sr_creation_channel,
11978: x_return_status => l_return_status);
11985:
11986:
11987: END IF; /* IF p_validation_level >= FND_API.G_VALID_LEVEL_NONE THEN */
11988:
11989: --CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg(l_api_name_full, 'step #3');
11990:
11991: --
11992: -- The request_id needs to be generated here because it is needed when
11993: -- inserting records into CS_HZ_SR_CONTACT_POINTS
11995: -- request id is unique is done only if validation level is set.
11996: --Commenting this because , selecting from dual is not supported anymore
11997: --because of performance reasons.
11998:
11999: --CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg(l_api_name_full, 'step #4');
12000:
12001: -- -------------------------------------------------------------
12002: -- Check if the passsed type_id has AutoLaunch Workflow flag set to 'Y'.
12003: -- If so, we need to call the workflow lauch API. We need to do this irrespective
12021:
12022: WHEN NO_DATA_FOUND THEN
12023: l_return_status := FND_API.G_RET_STS_ERROR;
12024:
12025: CS_ServiceRequest_UTIL.Add_Invalid_Argument_Msg
12026: ( p_token_an => l_api_name_full,
12027: p_token_v => TO_CHAR(l_service_request_rec.type_id),
12028: p_token_p => 'p_type_id',
12029: p_table_name => G_TABLE_NAME ,
13835: --
13836: IF (l_service_request_rec.contract_service_id <> FND_API.G_MISS_NUM AND
13837: l_service_request_rec.contract_service_id IS NOT NULL) THEN
13838:
13839: CS_ServiceRequest_UTIL.Validate_Contract_Service_Id(
13840: p_api_name => l_api_name,
13841: p_parameter_name => 'p_contract_service_id',
13842: p_contract_service_id => l_service_request_rec.contract_service_id,
13843: x_contract_id =>x_contra_id,
13857: (l_service_request_rec.contract_id IS NOT NULL) AND
13858: (l_service_request_rec.contract_service_id IS NULL OR
13859: l_service_request_rec.contract_service_id <> FND_API.G_MISS_NUM) THEN
13860:
13861: CS_ServiceRequest_UTIL.Validate_Contract_Id(
13862: p_api_name => l_api_name,
13863: p_parameter_name => 'p_contract_id',
13864: p_contract_id => l_service_request_rec.contract_id,
13865: x_contract_number => x_contract_number,
13884:
13885: IF (l_service_request_rec.creation_program_code <> FND_API.G_MISS_CHAR) AND
13886: (l_service_request_rec.creation_program_code IS NOT NULL) THEN
13887:
13888: CS_ServiceRequest_UTIL.Validate_source_program_code(
13889: p_api_name => l_api_name,
13890: p_parameter_name => 'p_creation_program_code',
13891: p_source_program_code => l_service_request_rec.creation_program_code,
13892: x_return_status => l_return_status);
13900: -- Added for address by shijain 05 dec 2002
13901: IF (l_service_request_rec.INCIDENT_DIRECTION_QUALIFIER <> FND_API.G_MISS_CHAR) AND
13902: (l_service_request_rec.INCIDENT_DIRECTION_QUALIFIER IS NOT NULL) THEN
13903:
13904: CS_ServiceRequest_UTIL.Validate_INC_DIRECTION_QUAL(
13905: p_api_name => l_api_name,
13906: p_parameter_name => 'p_INC_DIRECTION_QUAL',
13907: p_INC_DIRECTION_QUAL => l_service_request_rec.INCIDENT_DIRECTION_QUALIFIER,
13908: x_return_status => l_return_status);
13917: IF (l_service_request_rec.INCIDENT_DISTANCE_QUAL_UOM <> FND_API.G_MISS_CHAR) AND
13918: (l_service_request_rec.INCIDENT_DISTANCE_QUAL_UOM IS NOT NULL) THEN
13919:
13920:
13921: CS_ServiceRequest_UTIL.Validate_INC_DIST_QUAL_UOM(
13922: p_api_name => l_api_name,
13923: p_parameter_name => 'p_INC_DIST_QUAL_UOM',
13924: p_INC_DIST_QUAL_UOM => l_service_request_rec.INCIDENT_DISTANCE_QUAL_UOM,
13925: x_return_status => l_return_status);
13999: -- structure l_sr_related_data members
14000: --
14001: -- Removed queries on cs_incident_statuses_b table that were
14002: -- present inside comments. These queries are replaced with
14003: -- cs_servicerequest_util.get_status_details call
14004: --
14005: -- Modified condition for calling auto assignment and added
14006: -- one more condition of disallow_request_update flag of
14007: -- old status id. if this flag is Y then auto assignment
14396: OPEN l_ServiceRequest_csr;
14397: FETCH l_ServiceRequest_csr INTO l_old_ServiceRequest_rec;
14398: IF (l_ServiceRequest_csr%NOTFOUND) THEN
14399:
14400: CS_ServiceRequest_UTIL.Add_Invalid_Argument_Msg
14401: ( p_token_an => l_api_name_full,
14402: p_token_v => TO_CHAR(p_request_id),
14403: p_token_p => 'p_request_id',
14404: p_table_name => G_TABLE_NAME,
14516: end if;
14517:
14518: IF ( l_update_desc_flex_int = FND_API.G_TRUE and
14519: p_validation_level > FND_API.G_VALID_LEVEL_NONE) THEN
14520: Cs_Servicerequest_Util.Validate_Desc_Flex(
14521: p_api_name => l_api_name_full,
14522: p_application_short_name => 'CS',
14523: p_desc_flex_name => 'CS_INCIDENTS_ALL_B',
14524: p_desc_segment1 => l_service_request_rec.request_attribute_1,
14668: end if;
14669:
14670: IF ( l_update_desc_flex_ext = FND_API.G_TRUE and
14671: p_validation_level > FND_API.G_VALID_LEVEL_NONE) THEN
14672: Cs_ServiceRequest_Util.Validate_external_Desc_Flex
14673: ( p_api_name => l_api_name_full,
14674: p_application_short_name => 'CS',
14675: p_ext_desc_flex_name => 'CS_INCIDENTS_ALL_B_EXT',
14676: p_ext_desc_segment1 => l_service_request_rec.external_attribute_1,
14782: IF (p_validation_level > FND_API.G_VALID_LEVEL_NONE) THEN
14783: --
14784: -- Validate WHO information
14785: --
14786: CS_ServiceRequest_UTIL.Validate_Who_Info
14787: ( p_api_name => l_api_name_full,
14788: p_parameter_name_usr => 'p_last_updated_by',
14789: p_parameter_name_login => 'p_last_update_login',
14790: p_user_id => l_service_request_rec.last_updated_by,
14799: IF p_last_updated_by IS NOT NULL AND
14800: p_last_updated_by <> FND_API.G_MISS_NUM THEN
14801:
14802:
14803: CS_ServiceRequest_UTIL.Validate_Who_Info
14804: ( p_api_name => l_api_name_full,
14805: p_parameter_name_usr => 'p_last_updated_by',
14806: p_parameter_name_login => null,
14807: p_user_id => p_last_updated_by,
14855: RAISE FND_API.G_EXC_ERROR;
14856: END IF;
14857: END IF; -- Workflow condition
14858:
14859: CS_SERVICEREQUEST_UTIL.get_status_details
14860: ( p_status_id => l_old_servicerequest_rec.incident_status_id
14861: , x_close_flag => l_sr_related_data.old_close_flag
14862: , x_disallow_request_update => l_sr_related_data.old_disallow_request_update
14863: , x_disallow_agent_dispatch => l_sr_related_data.old_disallow_owner_update
14902: l_service_request_rec.last_updated_by IS NULL ) THEN
14903: l_service_request_rec.last_updated_by := p_last_updated_by;
14904: END IF;
14905:
14906: CS_SERVICEREQUEST_UTIL.get_status_details
14907: ( p_status_id => l_service_request_rec.status_id
14908: , x_close_flag => l_sr_related_data.close_flag
14909: , x_disallow_request_update => l_sr_related_data.disallow_request_update
14910: , x_disallow_agent_dispatch => l_sr_related_data.disallow_owner_update
14917: );
14918: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
14919: THEN
14920: l_return_status := FND_API.G_RET_STS_ERROR;
14921: CS_ServiceRequest_UTIL.Add_Invalid_Argument_Msg
14922: ( p_token_an => l_api_name_full
14923: , p_token_v => TO_CHAR(l_service_request_rec.status_id)
14924: , p_token_p => 'p_status_id'
14925: , p_table_name => G_TABLE_NAME
14954: EXCEPTION
14955: WHEN NO_DATA_FOUND THEN
14956: l_return_status := FND_API.G_RET_STS_ERROR;
14957:
14958: CS_ServiceRequest_UTIL.Add_Invalid_Argument_Msg
14959: ( p_token_an => l_api_name_full,
14960: p_token_v => TO_CHAR(l_type_id_temp),
14961: p_token_p => 'p_type_id',
14962: p_table_name => G_TABLE_NAME ,
15241: AND LANGUAGE = USERENV('LANG');
15242: EXCEPTION
15243: WHEN NO_DATA_FOUND THEN
15244: l_return_status := FND_API.G_RET_STS_ERROR;
15245: CS_ServiceRequest_UTIL.Add_Invalid_Argument_Msg
15246: ( p_token_an => l_api_name_full,
15247: p_token_v => TO_CHAR(l_service_request_rec.owner_id),
15248: p_token_p => 'p_owner_id',
15249: p_table_name => G_TABLE_NAME ,
15905: IF (l_service_request_rec.cp_component_id is NULL AND
15906: l_service_request_rec.component_version is NOT NULL AND
15907: l_service_request_rec.component_version <> FND_API.G_MISS_CHAR) THEN
15908: l_service_request_rec.component_version := null;
15909: CS_ServiceRequest_UTIL.Add_Param_Ignored_Msg(
15910: p_token_an => l_api_name_full,
15911: p_token_ip => 'p_component_version' );
15912: END IF;
15913:
15948: IF (l_service_request_rec.cp_subcomponent_id is NULL AND
15949: l_service_request_rec.subcomponent_version is NOT NULL AND
15950: l_service_request_rec.subcomponent_version <> FND_API.G_MISS_CHAR ) THEN
15951: l_service_request_rec.subcomponent_version := null;
15952: CS_ServiceRequest_UTIL.Add_Param_Ignored_Msg(
15953: p_token_an => l_api_name_full,
15954: p_token_ip => 'p_subcomponent_version' );
15955: END IF;
15956:
16331: l_service_request_rec.verify_cp_flag := 'Y';
16332: END IF;
16333: -- 2757488
16334: ELSIF (l_service_request_rec.verify_cp_flag NOT IN ('Y','N')) THEN
16335: CS_ServiceRequest_UTIL.Add_Invalid_Argument_Msg
16336: ( p_token_an => l_api_name_full,
16337: p_token_v => l_service_request_rec.verify_cp_flag,
16338: p_token_p => 'verify_cp_flag',
16339: p_table_name => G_TABLE_NAME ,
16347: IF (l_service_request_rec.verify_cp_flag <> FND_API.G_MISS_CHAR
16348: AND l_service_request_rec.verify_cp_flag IS NOT NULL) THEN
16349:
16350: IF (l_service_request_rec.verify_cp_flag NOT IN ('Y','N')) THEN
16351: CS_ServiceRequest_UTIL.Add_Invalid_Argument_Msg
16352: ( p_token_an => l_api_name_full,
16353: p_token_v => l_service_request_rec.verify_cp_flag,
16354: p_token_p => 'verify_cp_flag',
16355: p_table_name => G_TABLE_NAME ,
16372: END IF;
16373:
16374: if ( p_passed_value <> FND_API.G_MISS_CHAR) then
16375: if ( p_passed_value <> l_service_request_rec.verify_cp_flag) then
16376: CS_ServiceRequest_UTIL.Add_Cp_Flag_Ignored_Msg (p_token_an => l_api_name_full,
16377: p_token_ip => p_passed_value,
16378: p_token_pv => l_service_request_rec.verify_cp_flag);
16379: end if;
16380: end if;
16395: WHERE party_number = l_service_request_rec.customer_number;
16396: EXCEPTION
16397: WHEN OTHERS THEN
16398:
16399: CS_ServiceRequest_UTIL.Add_Invalid_Argument_Msg
16400: ( p_token_an => l_api_name_full,
16401: p_token_v => l_service_request_rec.customer_number,
16402: p_token_p => 'p_customer_number',
16403: p_table_name => G_TABLE_NAME ,
16554:
16555: -- for bug 3333340
16556: if (l_service_request_rec.cp_component_id <> FND_API.G_MISS_NUM AND
16557: l_service_request_rec.cp_component_id IS NOT NULL) then
16558: CS_ServiceRequest_UTIL.Add_Param_Ignored_Msg(
16559: p_token_an => l_api_name_full,
16560: p_token_ip => 'p_cp_component_id' );
16561:
16562: l_service_request_rec.cp_component_id := NULL;
16563: end if;
16564:
16565: if (l_service_request_rec.cp_component_version_id <> FND_API.G_MISS_NUM AND
16566: l_service_request_rec.cp_component_version_id IS NOT NULL) then
16567: CS_ServiceRequest_UTIL.Add_Param_Ignored_Msg(
16568: p_token_an => l_api_name_full,
16569: p_token_ip => 'p_cp_component_version_id' );
16570:
16571: l_service_request_rec.cp_component_version_id := NULL;
16572: end if;
16573:
16574: if (l_service_request_rec.cp_subcomponent_id <> FND_API.G_MISS_NUM AND
16575: l_service_request_rec.cp_subcomponent_id IS NOT NULL) then
16576: CS_ServiceRequest_UTIL.Add_Param_Ignored_Msg(
16577: p_token_an => l_api_name_full,
16578: p_token_ip => 'p_cp_subcomponent_id' );
16579:
16580: l_service_request_rec.cp_subcomponent_id := NULL;
16581: end if;
16582:
16583: if (l_service_request_rec.cp_subcomponent_version_id <> FND_API.G_MISS_NUM AND
16584: l_service_request_rec.cp_subcomponent_version_id IS NOT NULL) then
16585: CS_ServiceRequest_UTIL.Add_Param_Ignored_Msg(
16586: p_token_an => l_api_name_full,
16587: p_token_ip => 'p_cp_subcomponent_version_id' );
16588:
16589: l_service_request_rec.cp_subcomponent_version_id := NULL;
16590: end if;
16591:
16592: if (l_service_request_rec.cp_revision_id <> FND_API.G_MISS_NUM AND
16593: l_service_request_rec.cp_revision_id IS NOT NULL) then
16594: CS_ServiceRequest_UTIL.Add_Param_Ignored_Msg(
16595: p_token_an => l_api_name_full,
16596: p_token_ip => 'p_cp_revision_id' );
16597:
16598: l_service_request_rec.cp_revision_id := NULL;
16599: end if;
16600:
16601: if (l_service_request_rec.product_revision <> FND_API.G_MISS_CHAR AND
16602: l_service_request_rec.product_revision IS NOT NULL) then
16603: CS_ServiceRequest_UTIL.Add_Param_Ignored_Msg(
16604: p_token_an => l_api_name_full,
16605: p_token_ip => 'p_product_revision' );
16606:
16607: l_service_request_rec.product_revision := NULL;
16608: end if;
16609:
16610: if (l_service_request_rec.component_version <> FND_API.G_MISS_CHAR AND
16611: l_service_request_rec.component_version IS NOT NULL) then
16612: CS_ServiceRequest_UTIL.Add_Param_Ignored_Msg(
16613: p_token_an => l_api_name_full,
16614: p_token_ip => 'p_component_version' );
16615:
16616: l_service_request_rec.component_version := NULL;
16617: end if;
16618:
16619: if (l_service_request_rec.subcomponent_version <> FND_API.G_MISS_CHAR AND
16620: l_service_request_rec.subcomponent_version IS NOT NULL) then
16621: CS_ServiceRequest_UTIL.Add_Param_Ignored_Msg(
16622: p_token_an => l_api_name_full,
16623: p_token_ip => 'p_subcomponent_version' );
16624:
16625: l_service_request_rec.subcomponent_version := NULL;
16932: l_service_request_rec.closed_date := l_old_ServiceRequest_rec.close_date;
16933: END IF;
16934: ELSIF (l_service_request_rec.closed_date IS NOT NULL) THEN
16935:
16936: CS_ServiceRequest_UTIL.Validate_Closed_Date
16937: ( p_api_name => l_api_name_full,
16938: p_parameter_name => 'p_closed_date',
16939: p_closed_date => l_service_request_rec.closed_date,
16940: p_request_date => l_old_ServiceRequest_rec.incident_date,
16950: -- l_service_request_rec.status_flag:= 'O';
16951:
16952: IF (l_service_request_rec.closed_date <> FND_API.G_MISS_DATE) THEN
16953:
16954: CS_ServiceRequest_UTIL.Add_Param_Ignored_Msg
16955: ( p_token_an => l_api_name_full,
16956: p_token_ip => 'p_closed_date',
16957: p_table_name => G_TABLE_NAME,
16958: p_column_name => 'CLOSED_DATE' );
17174: --
17175: IF (l_service_request_rec.contract_service_id <> FND_API.G_MISS_NUM AND
17176: l_service_request_rec.contract_service_id IS NOT NULL) THEN
17177:
17178: CS_ServiceRequest_UTIL.Validate_Contract_Service_Id(
17179: p_api_name => l_api_name,
17180: p_parameter_name => 'p_contract_service_id',
17181: p_contract_service_id => l_service_request_rec.contract_service_id,
17182: x_contract_id =>x_contra_id,
17195: (p_service_request_rec.contract_id IS NOT NULL) AND
17196: (p_service_request_rec.contract_service_id IS NULL OR
17197: p_service_request_rec.contract_service_id = FND_API.G_MISS_NUM) THEN
17198:
17199: CS_ServiceRequest_UTIL.Validate_Contract_Id(
17200: p_api_name => l_api_name,
17201: p_parameter_name => 'p_contract_id',
17202: p_contract_id => l_service_request_rec.contract_id,
17203: x_contract_number => x_contract_number,
17230:
17231: /*Commented this code for backward compatibility, that if someone
17232: passes a last update program code as NULL or G_MISS_CHAR, we are supporting
17233: it now and defaulting it to UNKNOWN
17234: CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg
17235: ( p_token_an => l_api_name_full,
17236: p_token_np => 'SR Last Update Program Code',
17237: p_table_name => G_TABLE_NAME ,
17238: p_column_name => 'LAST_UPDATE_PROGRAM_CODE');
17248:
17249: IF (l_service_request_rec.last_update_program_code <> FND_API.G_MISS_CHAR) AND
17250: (l_service_request_rec.last_update_program_code IS NOT NULL) THEN
17251:
17252: CS_ServiceRequest_UTIL.Validate_source_program_code(
17253: p_api_name => l_api_name,
17254: p_parameter_name => 'p_last_update_program_code',
17255: p_source_program_code => l_service_request_rec.last_update_program_code,
17256: x_return_status => l_return_status);
17264: -- Added for address by shijain 05 dec 2002
17265: IF (l_service_request_rec.INCIDENT_DIRECTION_QUALIFIER <> FND_API.G_MISS_CHAR) AND
17266: (l_service_request_rec.INCIDENT_DIRECTION_QUALIFIER IS NOT NULL) THEN
17267:
17268: CS_ServiceRequest_UTIL.Validate_INC_DIRECTION_QUAL(
17269: p_api_name => l_api_name,
17270: p_parameter_name => 'p_INC_DIRECTION_QUAL',
17271: p_INC_DIRECTION_QUAL => l_service_request_rec.INCIDENT_DIRECTION_QUALIFIER,
17272: x_return_status => l_return_status);
17281: IF (l_service_request_rec.INCIDENT_DISTANCE_QUAL_UOM <> FND_API.G_MISS_CHAR) AND
17282: (l_service_request_rec.INCIDENT_DISTANCE_QUAL_UOM IS NOT NULL) THEN
17283:
17284:
17285: CS_ServiceRequest_UTIL.Validate_INC_DIST_QUAL_UOM(
17286: p_api_name => l_api_name,
17287: p_parameter_name => 'p_INC_DIST_QUAL_UOM',
17288: p_INC_DIST_QUAL_UOM => l_service_request_rec.INCIDENT_DISTANCE_QUAL_UOM,
17289: x_return_status => l_return_status);