[Home] [Help]
73: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
74: FND_MESSAGE.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
75: FND_MESSAGE.set_token
76: ('P_TEXT'
77: , 'CS_SERVICEREQUEST_UTIL.get_incident_type_details'||'-'||SQLERRM
78: );
79: FND_MSG_PUB.ADD;
80: END get_incident_type_details;
81: -- -----------------------------------------------------------------------------
435: IF p_sr_rec.incident_location_id <> NVL(p_old_incident_location_id,-9) OR
436: NVL(p_sr_rec.incident_location_type,'X') <> NVL(p_old_incident_location_type,'Y') OR
437: p_old_incident_country IS NULL
438: THEN
439: CS_ServiceRequest_UTIL.Validate_Inc_Location_Id
440: ( p_api_name => l_api_name
441: , p_parameter_name => 'p_incident_location_id'
442: , p_incident_location_type => p_sr_rec.incident_location_type
443: , p_incident_location_id => p_sr_rec.incident_location_id
470: p_sr_rec.type_id <> NVL(p_old_incident_type_id , -9) OR
471: NVL(p_sr_rec.owner_group_id,-1) <> NVL(p_old_owner_group_id , -1) OR
472: NVL(p_sr_rec.resource_type ,'Y')<> NVL(p_old_resource_type ,'x')
473: THEN
474: CS_SERVICEREQUEST_UTIL.validate_owner
475: ( p_api_name => NULL
476: , p_parameter_name => 'owner id'
477: , p_owner_id => p_sr_rec.owner_id
478: , p_group_type => p_sr_rec.group_type
510: NVL(p_sr_rec.install_site_id ,-9) <> NVL(p_old_install_site_id ,-9) OR
511: NVL(p_sr_rec.inventory_item_id ,-9) <> NVL(p_old_inventory_item_id ,-9) OR
512: NVL(p_sr_rec.customer_product_id,-9) <> NVL(p_old_customer_product_id,-9)
513: THEN
514: CS_SERVICEREQUEST_UTIL.Validate_Contract_Service_Id
515: ( p_api_name => l_api_name
516: , p_parameter_name => 'p_contract_service_id'
517: , p_contract_service_id => p_sr_rec.contract_service_id
518: , x_contract_id => p_sr_rec.contract_id
522: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
523: THEN
524: l_contract_service_id_valid := 'N';
525: ELSE
526: CS_SERVICEREQUEST_UTIL.contracts_cross_val
527: ( p_parameter_name => 'contract_service_id'
528: , p_contract_service_id => p_sr_rec.contract_service_id
529: , p_busiproc_id => p_sr_related_data.business_process_id
530: , p_request_date => p_sr_rec.request_date
657: IF l_contract_service_id_valid <> 'Y' AND
658: l_contract_defaulted <> 'Y'
659: THEN
660: FND_MESSAGE.set_name ('CS', 'CS_SR_CONTRACT_INVALID');
661: FND_MESSAGE.set_token('API_NAME', 'CS_SERVICEREQUEST_UTIL.contracts_cross_val' );
662: FND_MSG_PUB.add;
663: RAISE FND_API.G_EXC_ERROR;
664: END IF;
665: -- End of Default contract SLA processing
785: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
786: FND_MESSAGE.set_name ('CS', 'CS_API_SR_UNKNOWN_ERROR');
787: FND_MESSAGE.set_token
788: ('P_TEXT'
789: , 'CS_SERVICEREQUEST_UTIL.vldt_sr_rec'||'-'||SQLERRM
790: );
791: FND_MSG_PUB.ADD;
792: END vldt_sr_rec;
793: --============================================================================
1590: end if;
1591:
1592: -- For bug 3370562 - pass resp_id an appl_id
1593: -- validate security in create
1594: cs_servicerequest_util.validate_type (
1595: p_parameter_name => NULL,
1596: p_type_id => p_service_request_rec.type_id,
1597: p_subtype => G_SR_SUBTYPE,
1598: p_status_id => p_service_request_rec.status_id,
1630: p_service_request_rec.customer_product_id <> FND_API.G_MISS_NUM)
1631: THEN
1632: IF p_service_request_rec.maint_organization_id = FND_API.G_MISS_NUM
1633: THEN
1634: CS_ServiceRequest_UTIL.Add_Missing_Param_Msg(l_api_name_full, 'Maint_organization_id');
1635: RAISE FND_API.G_EXC_ERROR;
1636: ELSIF (p_service_request_rec.maint_organization_id IS NULL) THEN
1637: CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg(l_api_name_full, 'Maint_organization_id');
1638: RAISE FND_API.G_EXC_ERROR;
1633: THEN
1634: CS_ServiceRequest_UTIL.Add_Missing_Param_Msg(l_api_name_full, 'Maint_organization_id');
1635: RAISE FND_API.G_EXC_ERROR;
1636: ELSIF (p_service_request_rec.maint_organization_id IS NULL) THEN
1637: CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg(l_api_name_full, 'Maint_organization_id');
1638: RAISE FND_API.G_EXC_ERROR;
1639: END IF;
1640: END IF;
1641: END IF;
1667: , x_return_status => l_return_status
1668: );
1669: IF l_return_status = FND_API.G_RET_STS_ERROR
1670: THEN
1671: CS_ServiceRequest_UTIL.Add_Invalid_Argument_Msg
1672: ( p_token_an => l_api_name_full
1673: , p_token_v => TO_CHAR(p_service_request_rec.type_id)
1674: , p_token_p => 'p_type_id'
1675: , p_table_name => G_TABLE_NAME
1921: IF ( p_validation_level = FND_API.G_VALID_LEVEL_NONE ) THEN
1922: IF ( p_service_request_rec.bill_to_site_id <> FND_API.G_MISS_NUM AND
1923: p_service_request_rec.bill_to_site_id IS NOT NULL ) THEN
1924:
1925: CS_ServiceRequest_UTIL.Validate_Bill_To_Ship_To_Site
1926: ( p_api_name => 'Get bill to site use id',
1927: p_parameter_name => 'Bill_To Site ',
1928: p_bill_to_site_id => p_service_request_rec.bill_to_site_id,
1929: p_bill_to_party_id => p_service_request_rec.bill_to_party_id,
1938:
1939: IF ( p_service_request_rec.ship_to_site_id <> FND_API.G_MISS_NUM AND
1940: p_service_request_rec.ship_to_site_id IS NOT NULL ) THEN
1941:
1942: CS_ServiceRequest_UTIL.Validate_Bill_To_Ship_To_Site
1943: ( p_api_name => 'Get ship to site use id',
1944: p_parameter_name => 'Ship_To Site ',
1945: p_bill_to_site_id => p_service_request_rec.ship_to_site_id,
1946: p_bill_to_party_id => p_service_request_rec.ship_to_party_id,
2289: (l_service_request_rec.project_task_id IS NOT NULL AND l_service_request_rec.project_task_id <> FND_API.G_MISS_NUM) OR
2290: (l_service_request_rec.expenditure_org_id IS NOT NULL AND l_service_request_rec.expenditure_org_id <> FND_API.G_MISS_NUM)
2291: ) THEN
2292:
2293: CS_ServiceRequest_UTIL.VALIDATE_PROJECT_INFO
2294: (p_api_name => 'Validate_project_Task_id',
2295: p_project_id => l_service_request_rec.project_id,
2296: p_project_task_id => l_service_request_rec.project_task_id,
2297: p_exp_org_id => l_service_request_rec.expenditure_org_id,
3131: l_note_index := p_notes.NEXT(l_note_index);
3132: END LOOP;
3133:
3134:
3135: --CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg(l_api_name_full, 'step #8');
3136: -- Launching the workflow (HOOK)
3137: IF (JTF_USR_HKS.Ok_To_Execute('CS_ServiceRequest_PVT', 'Create_ServiceRequest',
3138: 'W', 'W')) THEN
3139:
3716: -- Non EAM service requests
3717: -- Raised error msg when maint_organization_id is NOT passed
3718: -- for EAM SRs with customer product
3719: -- 07/11/05 smisra Release 12 ERES changes
3720: -- called CS_SERVICEREQUEST_UTIL.get_status_details to
3721: -- details of old status and new status.
3722: -- if request updated is not allowed and new status has
3723: -- intermediate status id then do the following
3724: -- 1. Warn user that only status will be updated
3916: L_OLD_SERVICEREQUEST_REC SR_OLDVALUES_REC_TYPE;
3917:
3918: -- out rec for servicerequest_cross_val
3919:
3920: l_sr_cross_val_out_rec CS_ServiceRequest_UTIL.sr_cross_val_out_rec_type;
3921:
3922: -- Validation record
3923: l_sr_validation_rec request_validation_rec_type;
3924:
4223:
4224: EXCEPTION
4225: WHEN NO_DATA_FOUND THEN
4226: l_return_status := FND_API.G_RET_STS_ERROR;
4227: CS_ServiceRequest_UTIL.Add_Invalid_Argument_Msg
4228: (p_token_an => l_api_name_full,
4229: p_token_v => TO_CHAR(p_request_id),
4230: p_token_p => 'Request ID' ,
4231: p_table_name => G_TABLE_NAME,
4253: END IF;
4254:
4255: -- Check if mandatory parameter is passed
4256: IF (p_request_id IS NULL ) THEN
4257: CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg
4258: (p_token_an => l_api_name_full,
4259: p_token_np => 'SR Incident Id',
4260: p_table_name => G_TABLE_NAME,
4261: p_column_name => 'INCIDENT_ID' );
4263: RAISE FND_API.G_EXC_ERROR;
4264: END IF;
4265:
4266: IF (p_object_version_number IS NULL ) THEN
4267: CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg
4268: (p_token_an => l_api_name_full,
4269: p_token_np => 'SR Object Version Number',
4270: p_table_name => G_TABLE_NAME,
4271: p_column_name => 'OBJECT_VERSION_NUMBER');
4275:
4276: -- Check if user has passed null to mandatory parameters.
4277:
4278: IF (l_service_request_rec.type_id IS NULL) THEN
4279: CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg
4280: (p_token_an => l_api_name_full,
4281: p_token_np => 'SR Type',
4282: p_table_name => G_TABLE_NAME,
4283: p_column_name => 'INCIDENT_TYPE_ID');
4284: RAISE FND_API.G_EXC_ERROR;
4285: END IF;
4286:
4287: IF (l_service_request_rec.status_id IS NULL) THEN
4288: CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg
4289: (p_token_an => l_api_name_full,
4290: p_token_np => 'SR Status',
4291: p_table_name => G_TABLE_NAME,
4292: p_column_name => 'INCIDENT_STATUS_ID');
4293: RAISE FND_API.G_EXC_ERROR;
4294: END IF;
4295:
4296: IF (l_service_request_rec.severity_id IS NULL) THEN
4297: CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg
4298: (p_token_an => l_api_name_full,
4299: p_token_np => 'SR Severity',
4300: p_table_name => G_TABLE_NAME,
4301: p_column_name => 'SEVERITY_ID');
4304: END IF;
4305:
4306: -- Request Date is a reqd field, so check if passed, else return error
4307: IF (l_service_request_rec.request_date IS NULL) THEN
4308: CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg
4309: (p_token_an => l_api_name_full,
4310: p_token_np => 'SR Request Date',
4311: p_table_name => G_TABLE_NAME,
4312: p_column_name => 'REQUEST_DATE');
4314: END IF;
4315:
4316:
4317: IF (l_service_request_rec.summary IS NULL) THEN
4318: CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg (
4319: p_token_an => l_api_name_full,
4320: p_token_np => 'SR Summary',
4321: p_table_name => G_TABLE_NAME,
4322: p_column_name => 'SUMMARY');
4329: FETCH l_ServiceRequest_csr INTO l_old_ServiceRequest_rec;
4330:
4331: IF ( l_ServiceRequest_csr%NOTFOUND ) THEN
4332:
4333: CS_ServiceRequest_UTIL.Add_Invalid_Argument_Msg
4334: ( p_token_an => l_api_name_full,
4335: p_token_v => TO_CHAR(p_request_id),
4336: p_token_p => 'p_request_id',
4337: p_table_name => G_TABLE_NAME,
4371: , x_return_status => l_return_status
4372: );
4373: IF l_return_status = FND_API.G_RET_STS_ERROR
4374: THEN
4375: CS_ServiceRequest_UTIL.Add_Invalid_Argument_Msg
4376: ( p_token_an => l_api_name_full
4377: , p_token_v => TO_CHAR(l_service_request_rec.type_id)
4378: , p_token_p => 'p_type_id'
4379: , p_table_name => G_TABLE_NAME
4429: -- For bug 3370562 - pass resp_id an appl_id
4430: -- validate security in update; first against old sr type
4431:
4432: -- For bug 3474365 - pass different operation code for old sr type
4433: cs_servicerequest_util.validate_type (
4434: p_parameter_name => NULL,
4435: p_type_id => l_old_servicerequest_rec.incident_type_id,
4436: p_subtype => G_SR_SUBTYPE,
4437: p_status_id => p_service_request_rec.status_id, -- not used
4454: -- if type has changed and is not the same as the existing type, then validate
4455: -- if the responsibility has access to the new SR Type
4456: IF ( p_service_request_rec.type_id <> FND_API.G_MISS_NUM AND
4457: p_service_request_rec.type_id <> l_old_ServiceRequest_rec.incident_type_id ) then
4458: cs_servicerequest_util.validate_type (
4459: p_parameter_name => NULL,
4460: p_type_id => p_service_request_rec.type_id,
4461: p_subtype => G_SR_SUBTYPE,
4462: p_status_id => p_service_request_rec.status_id, -- not used
4475: RAISE FND_API.G_EXC_ERROR;
4476: end if;
4477:
4478: -- if the type has changed, check if the change is EAM <-> non-EAM.
4479: cs_servicerequest_util.validate_type_change (
4480: p_old_eam_type_flag => l_old_maintenance_flag,
4481: p_new_eam_type_flag => l_new_maintenance_flag,
4482: x_return_status => lx_return_status );
4483:
4510: THEN
4511: IF (p_service_request_rec.maint_organization_id = FND_API.G_MISS_NUM AND
4512: l_old_servicerequest_rec.maint_organization_id IS NULL)
4513: THEN
4514: CS_ServiceRequest_UTIL.Add_Missing_Param_Msg(l_api_name_full, 'Maint_organization_id');
4515: RAISE FND_API.G_EXC_ERROR;
4516: ELSIF (p_service_request_rec.maint_organization_id IS NULL) THEN
4517: CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg(l_api_name_full, 'Maint_organization_id');
4518: RAISE FND_API.G_EXC_ERROR;
4513: THEN
4514: CS_ServiceRequest_UTIL.Add_Missing_Param_Msg(l_api_name_full, 'Maint_organization_id');
4515: RAISE FND_API.G_EXC_ERROR;
4516: ELSIF (p_service_request_rec.maint_organization_id IS NULL) THEN
4517: CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg(l_api_name_full, 'Maint_organization_id');
4518: RAISE FND_API.G_EXC_ERROR;
4519: END IF;
4520: END IF;
4521: END IF;
4543: END IF;
4544:
4545: IF (l_new_maintenance_flag = 'y' OR l_new_maintenance_flag = 'Y') THEN
4546: IF (l_service_request_rec.inventory_org_id IS NULL) THEN
4547: CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg(
4548: l_api_name_full, 'Inventory Org ID');
4549: RAISE FND_API.G_EXC_ERROR;
4550: END IF;
4551: END IF;
4558:
4559: END IF; -- IF ( p_validation_level > fnd_api.g_valid_level_none )
4560:
4561: l_sr_related_data.target_status_id := l_service_request_rec.status_id;
4562: CS_SERVICEREQUEST_UTIL.get_status_details
4563: ( p_status_id => l_old_servicerequest_rec.incident_status_id
4564: , x_close_flag => l_sr_related_data.old_close_flag
4565: , x_disallow_request_update => l_sr_related_data.old_disallow_request_update
4566: , x_disallow_agent_dispatch => l_sr_related_data.old_disallow_owner_update
4574: l_start_eres_flag := 'N';
4575: IF (l_service_request_rec.status_id <> FND_API.G_MISS_NUM AND
4576: l_service_request_rec.status_id <> l_old_servicerequest_rec.incident_status_id)
4577: THEN
4578: CS_SERVICEREQUEST_UTIL.get_status_details
4579: ( p_status_id => l_sr_related_data.target_status_id
4580: , x_close_flag => l_sr_related_data.close_flag
4581: , x_disallow_request_update => l_sr_related_data.disallow_request_update
4582: , x_disallow_agent_dispatch => l_sr_related_data.disallow_owner_update
4674: , p_same_associated_columns => 'CS_INCIDENTS_ALL_B.INCIDENT_STATUS_ID'
4675: );
4676: IF l_old_servicerequest_rec.incident_status_id = l_service_request_rec.status_id
4677: THEN
4678: CS_ServiceRequest_UTIL.Add_Same_Val_Update_Msg
4679: ( p_token_an => 'CS_SERVICEREQUEST_PUB.update_servicerequest'
4680: , p_token_p => 'p_status_id'
4681: , p_table_name => G_TABLE_NAME
4682: , p_column_name => 'INCIDENT_STATUS_ID'
5021: -- Release 11.5.10 as part of the API Cleanup projecT
5022: --
5023: l_contract_service_id_valid := 'Y';
5024: IF ( p_validation_level > FND_API.G_VALID_LEVEL_NONE ) THEN
5025: CS_ServiceRequest_UTIL.SERVICEREQUEST_CROSS_VAL (
5026: p_new_sr_rec => l_service_request_rec,
5027: p_old_sr_rec => l_old_ServiceRequest_rec,
5028: x_cross_val_out_rec => l_sr_cross_val_out_rec,
5029: x_return_status => l_return_status );
5137: p_service_request_rec.contract_service_id <> FND_API.G_MISS_NUM)
5138: )
5139: THEN
5140: FND_MESSAGE.set_name ('CS', 'CS_SR_CONTRACT_INVALID');
5141: FND_MESSAGE.set_token('API_NAME', 'CS_SERVICEREQUEST_UTIL.contracts_cross_val' );
5142: FND_MSG_PUB.add;
5143: RAISE FND_API.G_EXC_ERROR;
5144: END IF;
5145: END IF;
5151: IF ( p_validation_level = FND_API.G_VALID_LEVEL_NONE ) THEN
5152: IF ( nvl(p_service_request_rec.bill_to_site_id,-99) <> nvl(l_old_ServiceRequest_rec.bill_to_site_id,-99))
5153: AND p_service_request_rec.bill_to_site_id <> FND_API.G_MISS_NUM THEN
5154:
5155: CS_ServiceRequest_UTIL.Validate_Bill_To_Ship_To_Site
5156: ( p_api_name => 'Get bill to site use id',
5157: p_parameter_name => 'Bill_To Site ',
5158: p_bill_to_site_id => p_service_request_rec.bill_to_site_id,
5159: p_bill_to_party_id => p_service_request_rec.bill_to_party_id,
5183:
5184: IF ( nvl(p_service_request_rec.ship_to_site_id,-99) <> nvl(l_old_ServiceRequest_rec.ship_to_site_id,-99))
5185: AND p_service_request_rec.ship_to_site_id <> FND_API.G_MISS_NUM THEN
5186:
5187: CS_ServiceRequest_UTIL.Validate_Bill_To_Ship_To_Site
5188: ( p_api_name => 'Get ship to site use id',
5189: p_parameter_name => 'Ship_To Site ',
5190: p_bill_to_site_id => p_service_request_rec.ship_to_site_id,
5191: p_bill_to_party_id => p_service_request_rec.ship_to_party_id,
5389: -- This is to be executed only for ERES update. For non eres updates
5390: -- this procedure is called from servicerequest_cross_val procedure.
5391: IF l_start_eres_flag = 'Y'
5392: THEN
5393: CS_SERVICEREQUEST_UTIL.task_restrict_close_cross_val
5394: ( p_incident_id => p_request_id
5395: , p_status_id => l_sr_related_data.target_status_id
5396: , x_return_status => l_return_status
5397: );
5407: -- cannot have resolved, responded flags as 'Y'. so no need to attempt to default
5408: -- resolved and responded by dates.
5409: IF l_start_eres_flag = 'N'
5410: THEN
5411: CS_SERVICEREQUEST_UTIL.get_reacted_resolved_dates
5412: ( p_incident_status_id => l_service_request_rec.status_id
5413: , p_old_incident_status_id => l_old_servicerequest_rec.incident_status_id
5414: , p_old_incident_resolved_date => l_old_servicerequest_rec.incident_resolved_date
5415: , p_old_inc_responded_by_date => l_old_servicerequest_rec.inc_responded_by_date
5495: ELSIF l_service_request_rec.contract_service_id is null THEN
5496: l_contra_id := null;
5497: l_contract_number := NULL;
5498: /* ELSE
5499: CS_ServiceRequest_UTIL.Validate_Contract_Service_Id(
5500: p_api_name => l_api_name,
5501: p_parameter_name => 'contract_service_id',
5502: p_contract_service_id => p_service_request_rec.contract_service_id,
5503: x_contract_id =>l_contra_id,
5746: l_service_request_rec.expenditure_org_id <> FND_API.G_MISS_NUM) THEN
5747: l_service_request_rec.project_id := l_old_serviceRequest_rec.project_id;
5748: l_service_request_rec.project_task_id := l_old_serviceRequest_rec.project_task_id;
5749: IF ( p_validation_level > FND_API.G_VALID_LEVEL_NONE ) THEN
5750: CS_ServiceRequest_UTIL.VALIDATE_PROJECT_INFO
5751: (p_api_name => 'Validate_project_Task_id',
5752: p_project_id => l_service_request_rec.project_id,
5753: p_project_task_id => l_service_request_rec.project_task_id,
5754: p_exp_org_id => l_service_request_rec.expenditure_org_id ,
5763:
5764: --validate all newly passed values
5765: ELSIF (l_service_request_Rec.project_id <> FND_API.G_MISS_NUM AND l_service_request_rec.project_task_id <> FND_API.G_MISS_NUM AND l_service_request_rec.expenditure_org_id <> FND_API.G_MISS_NUM) THEN
5766: IF ( p_validation_level > FND_API.G_VALID_LEVEL_NONE ) THEN
5767: CS_ServiceRequest_UTIL.VALIDATE_PROJECT_INFO
5768: (p_api_name => 'Validate_project_Task_id',
5769: p_project_id => l_service_request_rec.project_id,
5770: p_project_task_id => l_service_request_rec.project_task_id,
5771: p_exp_org_id => l_service_request_rec.expenditure_org_id ,
6595: END IF;
6596: IF l_approval_status = 'NO_ACTION'
6597: THEN
6598: -- validated orginal target status
6599: CS_ServiceRequest_UTIL.Validate_Updated_Status
6600: ( p_api_name => 'CS_SERVICEREQUEST_PVT.update_servicerequest'
6601: , p_parameter_name => 'p_status_id'
6602: , p_resp_id => p_resp_id
6603: , p_new_status_id => l_sr_related_data.target_status_id
6617: END IF;
6618: -- target status is valid at this point.
6619: --
6620: -- Now get responded and resolved dates
6621: CS_SERVICEREQUEST_UTIL.get_reacted_resolved_dates
6622: ( p_incident_status_id => l_sr_related_data.target_status_id
6623: , p_old_incident_status_id => l_old_servicerequest_rec.incident_status_id
6624: , p_old_incident_resolved_date => l_old_servicerequest_rec.incident_resolved_date
6625: , p_old_inc_responded_by_date => l_old_servicerequest_rec.inc_responded_by_date
6878: IF NVL(l_sr_related_data.close_flag,'N') = 'Y'
6879: THEN
6880: -- Close workflow processing
6881: -- check if old status was closed on Not
6882: CS_SERVICEREQUEST_UTIL.get_status_details
6883: ( p_status_id => l_old_servicerequest_rec.incident_status_id
6884: , x_close_flag => l_sr_related_data.old_close_flag
6885: , x_disallow_request_update => l_sr_related_data.old_disallow_request_update
6886: , x_disallow_agent_dispatch => l_sr_related_data.old_disallow_owner_update
6955: NVL(l_service_request_rec.incident_location_type,'-') <>
6956: NVL(l_old_servicerequest_rec.incident_location_type,'-')
6957: THEN
6958:
6959: CS_ServiceRequest_UTIL.Verify_LocUpdate_For_FSTasks
6960: (p_incident_id => p_request_id,
6961: x_return_status => x_return_status );
6962:
6963:
6966: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
6967: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6968: END IF ;
6969:
6970: CS_servicerequest_util.update_task_address
6971: ( p_incident_id => p_request_id
6972: , p_location_type => l_service_request_rec.incident_location_type
6973: , p_location_id => l_service_request_rec.incident_location_id
6974: , p_old_location_id => l_old_servicerequest_rec.incident_location_id -- bug 8947959
7499: OPEN l_ServiceRequest_csr;
7500: FETCH l_ServiceRequest_csr INTO l_ServiceRequest_rec;
7501: IF (l_ServiceRequest_csr%NOTFOUND) THEN
7502:
7503: CS_ServiceRequest_UTIL.Add_Invalid_Argument_Msg
7504: ( p_token_an => l_api_name_full,
7505: p_token_v => TO_CHAR(p_request_id),
7506: p_token_p => 'p_request_id',
7507: p_table_name => G_TABLE_NAME,
7522: -- Display the Warning that SR Status has not changed, only if SR Status's Disallow Update is unchecked
7523:
7524: IF (l_sr_related_data.disallow_request_update <> 'Y') THEN
7525:
7526: CS_ServiceRequest_UTIL.Add_Same_Val_Update_Msg
7527: ( p_token_an => l_api_name_full,
7528: p_token_p => 'p_status_id' ,
7529: p_table_name => G_TABLE_NAME,
7530: p_column_name => 'INCIDENT_STATUS_ID');
7538: -- Perform validation when necessary
7539: -- -------------------------------------
7540: IF (p_validation_level > FND_API.G_VALID_LEVEL_NONE) THEN
7541:
7542: CS_ServiceRequest_UTIL.Validate_Who_Info(
7543: p_api_name => l_api_name_full,
7544: p_parameter_name_usr => 'p_last_updated_by',
7545: p_parameter_name_login => 'p_last_update_login',
7546: p_user_id => p_last_updated_by,
7570: end if;
7571:
7572: -- For bug 3370562 - pass resp_id an appl_id
7573: -- validate security in update; first against old sr type
7574: cs_servicerequest_util.validate_type (
7575: p_parameter_name => NULL,
7576: p_type_id => l_servicerequest_rec.incident_type_id,
7577: p_subtype => G_SR_SUBTYPE,
7578: p_status_id => l_servicerequest_rec.incident_status_id, -- not used
7593: END IF; -- IF (p_validation_level > FND_API.G_VALID_LEVEL_NONE) THEN
7594:
7595: -- Get the details of the existing status of SR
7596:
7597: CS_SERVICEREQUEST_UTIL.get_status_details
7598: ( p_status_id => l_servicerequest_rec.incident_status_id
7599: , x_close_flag => l_sr_related_data.old_close_flag
7600: , x_disallow_request_update => l_sr_related_data.old_disallow_request_update
7601: , x_disallow_agent_dispatch => l_sr_related_data.old_disallow_owner_update
7620: END IF; -- l_pending approval flag is Y
7621: END IF; -- if after get_status_details call
7622:
7623: -- Get the details of the new status
7624: CS_SERVICEREQUEST_UTIL.get_status_details
7625: ( p_status_id => p_status_id
7626: , x_close_flag => l_sr_related_data.close_flag
7627: , x_disallow_request_update => l_sr_related_data.disallow_request_update
7628: , x_disallow_agent_dispatch => l_sr_related_data.disallow_owner_update
7684: -- We ALWAYS have to validate the status because we don't know if the
7685: -- status is a "closed" status, and we need this information in order
7686: -- to set the closed_date variable accordingly
7687: -- ------------------------------------------------------------------
7688: CS_ServiceRequest_UTIL.Validate_Updated_Status(
7689: p_api_name => l_api_name_full,
7690: p_parameter_name => 'p_status_id',
7691: p_resp_id => p_resp_id ,
7692: p_new_status_id => p_status_id,
7851: EXCEPTION
7852:
7853: WHEN NO_DATA_FOUND THEN
7854: l_return_status := FND_API.G_RET_STS_ERROR;
7855: CS_ServiceRequest_UTIL.Add_Invalid_Argument_Msg
7856: ( p_token_an => l_api_name_full,
7857: p_token_v => TO_CHAR(l_ServiceRequest_rec.incident_type_id),
7858: p_token_p => 'p_type_id' ,
7859: p_table_name => G_TABLE_NAME,
7905: ELSE
7906: l_closed_date := p_closed_date;
7907: IF (p_closed_date IS NOT NULL) THEN
7908:
7909: CS_ServiceRequest_UTIL.Validate_Closed_Date(
7910: p_api_name => G_PKG_NAME||'.'||l_api_name,
7911: p_parameter_name => 'p_closed_date',
7912: p_closed_date => l_closed_date,
7913: p_request_date => l_ServiceRequest_rec.incident_date,
7924: IF (p_closed_date = FND_API.G_MISS_DATE) OR
7925: (p_closed_date IS NULL) THEN
7926: NULL;
7927: ELSE
7928: CS_ServiceRequest_UTIL.Add_Param_Ignored_MSg
7929: ( p_token_an => l_api_name_full,
7930: p_token_ip => 'p_closed_date',
7931: p_table_name => G_TABLE_NAME,
7932: p_column_name => 'CLOSED_DATE');
7938: --- SR has any open tasks with restrict flag set to 'Y', If yes, return
7939: --- error ( bug # 3512003).
7940:
7941: IF (l_closed_flag = 'Y') THEN
7942: CS_ServiceRequest_UTIL.TASK_RESTRICT_CLOSE_CROSS_VAL (
7943: p_incident_id => p_request_id,
7944: p_status_id => p_status_id,
7945: x_return_status => l_return_status );
7946:
7993: END IF;
7994: END IF;
7995: END IF;
7996:
7997: CS_SERVICEREQUEST_UTIL.get_reacted_resolved_dates
7998: ( p_incident_status_id => p_status_id
7999: , p_old_incident_status_id => l_servicerequest_rec.incident_status_id
8000: , p_old_incident_resolved_date => l_servicerequest_rec.incident_resolved_date
8001: , p_old_inc_responded_by_date => l_servicerequest_rec.inc_responded_by_date
8487: OPEN l_ServiceRequest_csr;
8488: FETCH l_ServiceRequest_csr INTO l_ServiceRequest_rec;
8489: IF (l_ServiceRequest_csr%NOTFOUND) THEN
8490:
8491: CS_ServiceRequest_UTIL.Add_Invalid_Argument_Msg(
8492: p_token_an => l_api_name_full,
8493: p_token_v => TO_CHAR(p_request_id),
8494: p_token_p => 'p_request_id',
8495: p_table_name => G_TABLE_NAME,
8511: -- --------------------------------------------------------
8512: IF ((p_owner_id = l_ServiceRequest_rec.incident_owner_id) AND
8513: (l_owner_group_id = l_ServiceRequest_rec.owner_group_id) ) THEN
8514:
8515: CS_ServiceRequest_UTIL.Add_Same_Val_Update_Msg(
8516: p_token_an => l_api_name_full,
8517: p_token_p => 'p_owner_id/p_owner_group_id',
8518: p_table_name => G_TABLE_NAME,
8519: p_column_name => 'OWNER_GROUP_ID');
8525: -- -------------------------------------
8526: -- Perform validation when necessary
8527: -- -------------------------------------
8528: IF (p_validation_level > FND_API.G_VALID_LEVEL_NONE) THEN
8529: CS_ServiceRequest_UTIL.Validate_Who_Info(
8530: p_api_name => l_api_name_full,
8531: p_parameter_name_usr => 'p_last_updated_by',
8532: p_parameter_name_login => 'p_last_update_login',
8533: p_user_id => p_last_updated_by,
8558: end if;
8559:
8560: -- For bug 3370562 - pass resp_id an appl_id
8561: -- validate security in update; first against old sr type
8562: cs_servicerequest_util.validate_type (
8563: p_parameter_name => NULL,
8564: p_type_id => l_servicerequest_rec.incident_type_id,
8565: p_subtype => G_SR_SUBTYPE,
8566: p_status_id => l_servicerequest_rec.incident_status_id, -- not used
8577: -- security violation; responsibility does not have access to SR Type
8578: -- being created. Stop and raise error.
8579: RAISE FND_API.G_EXC_ERROR;
8580: end if;
8581: CS_SERVICEREQUEST_UTIL.get_status_details
8582: ( p_status_id => l_servicerequest_rec.incident_status_id
8583: , x_close_flag => l_sr_related_data.close_flag
8584: , x_disallow_request_update => l_sr_related_data.disallow_request_update
8585: , x_disallow_agent_dispatch => l_sr_related_data.disallow_owner_update
8706: */
8707:
8708: -- Added for bug 2725543
8709: IF (p_owner_group_id <> FND_API.G_MISS_NUM) THEN
8710: CS_ServiceRequest_UTIL.Validate_Group_Id
8711: ( p_api_name => l_api_name_full,
8712: p_parameter_name => 'p_owner_group_id',
8713: p_group_type => 'RS_GROUP',
8714: p_owner_group_id => p_owner_group_id,
8720: RAISE FND_API.G_EXC_ERROR;
8721: END IF;
8722: END IF;
8723:
8724: CS_ServiceRequest_UTIL.Validate_Owner
8725: ( p_api_name => l_api_name_full
8726: , p_parameter_name => 'p_owner_id'
8727: , p_owner_id => p_owner_id
8728: , p_group_type => 'RS_GROUP'
8743:
8744: END IF;
8745:
8746: -- Get unassigned_indicator
8747: l_unasgn_ind := CS_SERVICEREQUEST_UTIL.get_unassigned_indicator(p_owner_id, l_owner_group_id);
8748: -- ----------------------------------------------
8749: -- Update the owner and insert the audit record
8750: -- ----------------------------------------------
8751: -- Update CS_INCIDENTS table
10132: ELSIF (p_service_request_rec.caller_type = 'PERSON' ) THEN
10133: l_customer_id := p_service_request_rec.customer_id ;--Added for Bug 2167129
10134: END IF;
10135:
10136: --CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg(p_api_name, 'step val sr rec #1');
10137: -- Validate all non-missing attributes
10138:
10139: /***** dj api cleanup
10140: -- commenting out call to validate type as this is done as the first step in
10141: -- both the create and update procedures
10142: IF FND_API.To_Boolean(p_service_request_rec.validate_type) THEN
10143: IF FND_API.To_Boolean(p_service_request_rec.status_id_change) THEN
10144: -- dj api cleanup
10145: CS_ServiceRequest_UTIL.Validate_Type (
10146: p_parameter_name => 'p_type_id',
10147: p_type_id => p_service_request_rec.type_id,
10148: p_subtype => G_SR_SUBTYPE,
10149: P_status_id => p_service_request_rec.updated_status_id,
10156: x_cmro_flag => lx_cmro_flag, -- new for 11.5.10
10157: x_maintenance_flag => lx_maintenance_flag ); -- new for 11.5.10
10158:
10159: ELSE
10160: CS_ServiceRequest_UTIL.Validate_Type (
10161: p_parameter_name => 'p_type_id',
10162: p_type_id => p_service_request_rec.type_id,
10163: p_subtype => G_SR_SUBTYPE,
10164: P_status_id => p_service_request_rec.status_id,
10181:
10182: end comment of type ********/
10183:
10184: IF FND_API.To_Boolean(p_service_request_rec.validate_status) THEN
10185: CS_ServiceRequest_UTIL.Validate_Status
10186: ( p_api_name => p_api_name,
10187: p_parameter_name => 'p_status_id',
10188: p_status_id => p_service_request_rec.status_id,
10189: p_subtype => G_SR_SUBTYPE,
10207: ELSE
10208: l_old_type_id := p_service_request_rec.type_id;
10209: END IF ;
10210:
10211: CS_ServiceRequest_UTIL.Validate_Updated_Status
10212: ( p_api_name => p_api_name,
10213: p_parameter_name => 'p_status_id',
10214: p_resp_id => p_resp_id ,
10215: p_new_status_id => p_service_request_rec.updated_status_id,
10228: RETURN;
10229: END IF;
10230: END IF;
10231:
10232: -- CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg(p_api_name, 'step val sr rec #3');
10233:
10234: IF (p_service_request_rec.severity_id <> FND_API.G_MISS_NUM) THEN
10235:
10236: CS_ServiceRequest_UTIL.Validate_Severity
10232: -- CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg(p_api_name, 'step val sr rec #3');
10233:
10234: IF (p_service_request_rec.severity_id <> FND_API.G_MISS_NUM) THEN
10235:
10236: CS_ServiceRequest_UTIL.Validate_Severity
10237: ( p_api_name => p_api_name,
10238: p_parameter_name => 'p_severity_id',
10239: p_severity_id => p_service_request_rec.severity_id,
10240: p_subtype => G_SR_SUBTYPE,
10245: RETURN;
10246: END IF;
10247: END IF;
10248:
10249: --CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg(p_api_name, 'step val sr rec #4');
10250:
10251: IF (p_service_request_rec.urgency_id <> FND_API.G_MISS_NUM) THEN
10252:
10253: CS_ServiceRequest_UTIL.Validate_Urgency
10249: --CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg(p_api_name, 'step val sr rec #4');
10250:
10251: IF (p_service_request_rec.urgency_id <> FND_API.G_MISS_NUM) THEN
10252:
10253: CS_ServiceRequest_UTIL.Validate_Urgency
10254: ( p_api_name => p_api_name,
10255: p_parameter_name => 'p_urgency_id',
10256: p_urgency_id => p_service_request_rec.urgency_id,
10257: x_return_status => l_return_status
10266: -- Validate SR_CREATION_CHANNEL
10267:
10268: IF (p_service_request_rec.sr_creation_channel <> FND_API.G_MISS_CHAR ) THEN
10269:
10270: CS_ServiceRequest_UTIL.Validate_SR_Channel(
10271: p_api_name => p_api_name,
10272: p_parameter_name => 'p_sr_creation_channel',
10273: p_sr_creation_channel => p_service_request_rec.sr_creation_channel,
10274: x_return_status => l_return_status);
10278: RETURN;
10279: END IF;
10280: END IF;
10281:
10282: --CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg(p_api_name, 'step val sr rec #6');
10283:
10284: IF (p_service_request_rec.publish_flag <> FND_API.G_MISS_CHAR) AND
10285: p_sr_mode <> 'CREATE' THEN
10286:
10298: END IF;
10299:
10300: IF FND_API.To_Boolean(p_service_request_rec.validate_customer) THEN
10301:
10302: CS_ServiceRequest_UTIL.Validate_Customer
10303: ( p_api_name => p_api_name,
10304: p_parameter_name => 'p_customer_id',
10305: p_caller_type => p_service_request_rec.caller_type, --Bug 3666089
10306: p_customer_id => p_service_request_rec.customer_id,
10313: END IF;
10314: END IF;
10315:
10316: IF (p_service_request_rec.contact_id <> FND_API.G_MISS_NUM) THEN
10317: CS_ServiceRequest_UTIL.Validate_Customer_Contact
10318: ( p_api_name => p_api_name,
10319: p_parameter_name => 'p_contact_id',
10320: p_customer_contact_id => p_service_request_rec.contact_id,
10321: p_customer_id => p_service_request_rec.customer_id,
10329: END IF;
10330: END IF;
10331:
10332: IF FND_API.To_Boolean(p_service_request_rec.validate_employee) THEN
10333: CS_ServiceRequest_UTIL.Validate_Employee
10334: ( p_api_name => p_api_name,
10335: p_parameter_name => 'p_employee_id',
10336: p_employee_id => p_service_request_rec.employee_id,
10337: p_org_id => p_org_id,
10354: -- For bug 2743507 , moving the call to validate inv org id before
10355: -- the validation of inv item id.
10356:
10357: IF (p_service_request_rec.inventory_org_id <> FND_API.G_MISS_NUM) THEN
10358: CS_ServiceRequest_UTIL.Validate_Inventory_Org
10359: ( p_api_name => p_api_name,
10360: p_parameter_name => 'Inventory Organization',
10361: p_inv_org_id => p_service_request_rec.inventory_org_id,
10362: x_inv_org_master_org_flag => l_inv_org_master_org_flag,
10371: -- validate maintenance organization id
10372: IF (p_service_request_rec.maint_organization_id <> FND_API.G_MISS_NUM AND
10373: p_service_request_rec.maint_organization_id IS NOT NULL )
10374: THEN
10375: CS_SERVICEREQUEST_UTIL.validate_maint_organization_id
10376: ( p_maint_organization_id => p_service_request_rec.maint_organization_id
10377: , p_inventory_org_id => p_service_request_rec.inventory_org_id
10378: , p_inv_org_master_org_flag => l_inv_org_master_org_flag
10379: , x_return_status => l_return_status
10389: AND (p_sr_mode = 'CREATE') THEN
10390: IF ((p_service_request_rec.inventory_org_id = FND_API.G_MISS_NUM) OR
10391: (p_service_request_rec.inventory_org_id IS NULL)) THEN
10392:
10393: CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg
10394: ( p_token_an => p_api_name,
10395: p_token_np => 'p_inventory_org_id',
10396: p_table_name => G_TABLE_NAME,
10397: p_column_name => 'INV_ORGANIZATION_ID');
10398:
10399: x_return_status := FND_API.G_RET_STS_ERROR;
10400: RETURN;
10401: END IF;
10402: CS_ServiceRequest_UTIL.Validate_Product
10403: ( p_api_name => p_api_name,
10404: p_parameter_name => 'p_inventory_item_id',
10405: p_inventory_item_id => p_service_request_rec.inventory_item_id,
10406: p_inventory_org_id => p_service_request_rec.inventory_org_id,
10427: AND (p_sr_mode = 'CREATE') THEN
10428: IF ((p_service_request_rec.inventory_org_id = FND_API.G_MISS_NUM) OR
10429: (p_service_request_rec.inventory_org_id IS NULL)) THEN
10430:
10431: CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg
10432: ( p_token_an => p_api_name,
10433: p_token_np => 'p_inventory_org_id',
10434: p_table_name => G_TABLE_NAME,
10435: p_column_name => 'INV_ORGANIZATION_ID');
10442: l_maint_organization_id := NULL;
10443: ELSE
10444: l_maint_organization_id := p_service_request_rec.maint_organization_id;
10445: ENd IF;
10446: CS_ServiceRequest_UTIL.Validate_Customer_Product_id
10447: (p_customer_product_id => p_service_request_rec.customer_product_id,
10448: p_customer_id => p_service_request_rec.customer_id,
10449: p_inventory_item_id => p_inventory_item_id,
10450: p_inventory_org_id => p_service_request_rec.inventory_org_id,
10461: -- For bug 3340433
10462: IF (nvl(p_service_request_rec.inventory_item_id,-99) <> FND_API.G_MISS_NUM) then
10463: If (p_service_request_rec.inventory_item_id <> p_inventory_item_id) then
10464: --Raise an ignore message;
10465: CS_ServiceRequest_UTIL.Add_Param_Ignored_Msg(
10466: p_token_an => p_api_name,
10467: p_token_ip => 'p_inventory_item_id' );
10468: End if;
10469: END IF;
10478: IF (p_service_request_rec.current_serial_number <> FND_API.G_MISS_CHAR) AND
10479: (p_service_request_rec.customer_product_id <> FND_API.G_MISS_NUM)
10480: AND (p_sr_mode = 'CREATE') THEN
10481:
10482: CS_ServiceRequest_UTIL.Validate_Current_Serial
10483: ( p_api_name => p_api_name,
10484: p_parameter_name => 'p_current_serial_number',
10485: p_inventory_item_id => p_inventory_item_id,
10486: p_inventory_org_id => p_service_request_rec.inventory_org_id,
10500:
10501: IF p_service_request_rec.owning_dept_id <> FND_API.G_MISS_NUM AND
10502: p_sr_mode = 'CREATE'
10503: THEN
10504: CS_ServiceRequest_UTIL.Validate_Owning_department
10505: ( p_api_name => p_api_name
10506: , p_parameter_name => 'Owning Department'
10507: , p_inv_org_id => p_service_request_rec.maint_organization_id
10508: , p_owning_dept_id => p_service_request_rec.owning_dept_id
10520:
10521: IF (p_service_request_rec.problem_code <> FND_API.G_MISS_CHAR)
10522: AND (p_sr_mode = 'CREATE') THEN
10523:
10524: CS_ServiceRequest_UTIL.Validate_Problem_Code
10525: ( p_api_name => p_api_name,
10526: p_parameter_name => 'p_problem_code',
10527: p_problem_code => p_service_request_rec.problem_code,
10528: p_incident_type_id => p_service_request_rec.type_id,
10541: -----------Validation is required for Cust_Pref_Lang_Id,Comm_Pref_Code and
10542: -----------Category_Id.
10543:
10544: IF (p_service_request_rec.cust_pref_lang_code <> FND_API.G_MISS_CHAR) THEN
10545: CS_ServiceRequest_UTIL.Validate_Cust_Pref_Lang_Code
10546: ( p_api_name => p_api_name,
10547: p_parameter_name => 'p_cust_pref_lang_code',
10548: p_cust_pref_lang_code => p_service_request_rec.cust_pref_lang_code,
10549: x_return_status => l_return_status
10555: END IF;
10556:
10557: IF (p_service_request_rec.category_set_id <> FND_API.G_MISS_NUM)
10558: AND (p_sr_mode = 'CREATE') THEN
10559: CS_ServiceRequest_UTIL.Validate_Category_Set_Id
10560: ( p_api_name => p_api_name,
10561: p_parameter_name => 'p_category_set_id',
10562: p_category_id => p_service_request_rec.category_id,
10563: p_category_set_id => p_service_request_rec.category_set_id,
10574:
10575: IF (p_service_request_rec.external_reference <> FND_API.G_MISS_CHAR)
10576: AND (p_sr_mode = 'CREATE') THEN
10577: -- For bug 3746983
10578: CS_ServiceRequest_UTIL.Validate_External_Reference
10579: ( p_api_name => p_api_name,
10580: p_parameter_name => 'p_external_reference',
10581: p_external_reference => p_service_request_rec.external_reference,
10582: p_customer_product_id => p_service_request_rec.customer_product_id,
10591: END IF;
10592: END IF;
10593:
10594: IF (p_service_request_rec.system_id <> FND_API.G_MISS_NUM) THEN
10595: CS_ServiceRequest_UTIL.Validate_System_Id
10596: ( p_api_name => p_api_name,
10597: p_parameter_name => 'p_system_id',
10598: p_system_id => p_service_request_rec.system_id,
10599: x_return_status => l_return_status
10604: END IF;
10605: END IF;
10606:
10607: IF (p_service_request_rec.comm_pref_code <> FND_API.G_MISS_CHAR) THEN
10608: CS_ServiceRequest_UTIL.Validate_Comm_Pref_Code
10609: ( p_api_name => p_api_name,
10610: p_parameter_name => 'p_comm_pref_code',
10611: p_comm_pref_code => p_service_request_rec.comm_pref_code,
10612: x_return_status => l_return_status
10620: IF (p_service_request_rec.category_id <> FND_API.G_MISS_NUM AND
10621: (p_service_request_rec.category_set_id = FND_API.G_MISS_NUM OR
10622: p_service_request_rec.category_set_id IS NULL) )
10623: AND (p_sr_mode = 'CREATE') THEN
10624: CS_ServiceRequest_UTIL.Validate_Category_Id
10625: ( p_api_name => p_api_name,
10626: p_parameter_name => 'p_category_id',
10627: p_category_id => p_service_request_rec.category_id,
10628: p_category_set_id=> p_service_request_rec.category_set_id,
10634: END IF;
10635: END IF;
10636:
10637: IF (p_service_request_rec.group_type <> FND_API.G_MISS_CHAR) THEN
10638: CS_ServiceRequest_UTIL.Validate_Group_Type
10639: ( p_api_name => p_api_name,
10640: p_parameter_name => 'p_group_type',
10641: p_group_type => p_service_request_rec.group_type,
10642: --p_resource_type => p_service_request_rec.resource_type,
10649: END IF;
10650: END IF;
10651:
10652: IF (p_service_request_rec.owner_group_id <> FND_API.G_MISS_NUM) THEN
10653: CS_ServiceRequest_UTIL.Validate_Group_Id
10654: ( p_api_name => p_api_name,
10655: p_parameter_name => 'p_owner_group_id',
10656: p_group_type => p_service_request_rec.group_type,
10657: p_owner_group_id => p_service_request_rec.owner_group_id,
10665: END IF;
10666: END IF;
10667:
10668: IF (p_service_request_rec.exp_resolution_date <> FND_API.G_MISS_DATE) THEN
10669: CS_ServiceRequest_UTIL.Validate_Exp_Resolution_Date
10670: ( p_api_name => p_api_name,
10671: p_parameter_name => 'p_exp_resolution_date',
10672: p_exp_resolution_date => p_service_request_rec.exp_resolution_date,
10673: p_request_date => p_request_date,
10687:
10688: l_customer_type:= p_service_request_rec.caller_type;
10689:
10690: IF (p_service_request_rec.bill_to_party_id <> FND_API.G_MISS_NUM) THEN
10691: CS_ServiceRequest_UTIL.Validate_Bill_To_Ship_To_Party
10692: ( p_api_name => p_api_name,
10693: p_parameter_name => 'Bill_To Party',
10694: p_bill_to_party_id => p_service_request_rec.bill_to_party_id,
10695: p_customer_id => p_service_request_rec.customer_id,
10706: Commented now but should be uncommented for 11.5.10
10707: IF (FND_API.To_Boolean(p_service_request_rec.validate_bill_to_site) OR
10708: (p_service_request_rec.bill_to_site_id <> FND_API.G_MISS_NUM)) THEN
10709:
10710: CS_ServiceRequest_UTIL.Validate_Bill_To_Ship_To_Site
10711: ( p_api_name => p_api_name,
10712: p_parameter_name => 'Bill_To Site ',
10713: p_bill_to_site_id => p_service_request_rec.bill_to_site_id,
10714: p_bill_to_party_id => p_service_request_rec.bill_to_party_id,
10725: *****************************************************************/
10726:
10727: IF (p_service_request_rec.bill_to_Contact_id <> FND_API.G_MISS_NUM)
10728: AND (p_sr_mode = 'CREATE') THEN
10729: CS_ServiceRequest_UTIL.Validate_Bill_To_Ship_To_Ct
10730: ( p_api_name => p_api_name,
10731: p_parameter_name => 'Bill_To Contact',
10732: p_bill_to_contact_id => p_service_request_rec.bill_to_contact_id,
10733: p_bill_to_party_id => p_service_request_rec.bill_to_party_id ,
10749:
10750: l_customer_type:= p_service_request_rec.caller_type;
10751:
10752: IF (p_service_request_rec.ship_to_party_id <> FND_API.G_MISS_NUM) THEN
10753: CS_ServiceRequest_UTIL.Validate_Bill_To_Ship_To_Party
10754: ( p_api_name => p_api_name,
10755: p_parameter_name => 'Ship_To Party',
10756: p_bill_to_party_id => p_service_request_rec.ship_to_party_id,
10757: p_customer_id => p_service_request_rec.customer_id,
10770:
10771: IF (FND_API.To_Boolean(p_service_request_rec.validate_ship_to_site) OR
10772: (p_service_request_rec.ship_to_site_id <> FND_API.G_MISS_NUM)) THEN
10773:
10774: CS_ServiceRequest_UTIL.Validate_Bill_To_Ship_To_Site
10775: ( p_api_name => p_api_name,
10776: p_parameter_name => 'Ship_To Site ',
10777: p_bill_to_site_id => p_service_request_rec.ship_to_site_id,
10778: p_bill_to_party_id => p_service_request_rec.ship_to_party_id,
10791: -- Validate the Ship_To_Contact - Use the validate_bill_to_Contact procedure itself
10792:
10793: IF (p_service_request_rec.ship_to_Contact_id <> FND_API.G_MISS_NUM)
10794: AND (p_sr_mode = 'CREATE') THEN
10795: CS_ServiceRequest_UTIL.Validate_Bill_To_Ship_To_Ct
10796: ( p_api_name => p_api_name,
10797: p_parameter_name => 'Ship_To Contact',
10798: p_bill_to_contact_id => p_service_request_rec.ship_to_contact_id,
10799: p_bill_to_party_id => p_service_request_rec.ship_to_party_id ,
10809: --Code added to validate install site
10810: --IF FND_API.To_Boolean(p_service_request_rec.validate_install_site) THEN
10811: IF ( p_service_request_rec.install_site_id <> FND_API.G_MISS_NUM AND
10812: p_service_request_rec.install_site_id IS NOT NULL) THEN
10813: CS_ServiceRequest_UTIL.Validate_Install_Site (
10814: p_parameter_name => 'Install Site',
10815: p_install_site_id => p_service_request_rec.install_site_id,
10816: p_customer_id => l_customer_id,
10817: x_return_status => l_return_status
10823: END IF;
10824:
10825: IF ( p_service_request_rec.install_site_use_id <> FND_API.G_MISS_NUM AND
10826: p_service_request_rec.install_site_use_id IS NOT NULL) THEN
10827: CS_ServiceRequest_UTIL.Validate_Install_Site (
10828: p_parameter_name => 'Install Site Use',
10829: p_install_site_id => p_service_request_rec.install_site_use_id,
10830: p_customer_id => l_customer_id,
10831: x_return_status => l_return_status
10841: ( p_service_request_rec.ship_to_site_use_id <> FND_API.G_MISS_NUM AND
10842: p_service_request_rec.ship_to_site_use_id IS NOT NULL ) AND
10843: ( p_sr_mode = 'CREATE') ) THEN
10844:
10845: CS_ServiceRequest_UTIL.Validate_Site_Site_Use
10846: ( p_api_name => p_api_name,
10847: p_parameter_name => 'Ship_To Site and/or Site Use ',
10848: p_site_id => p_service_request_rec.ship_to_site_id,
10849: p_site_use_id => p_service_request_rec.ship_to_site_use_id,
10860: ( p_service_request_rec.ship_to_site_id IS NULL OR
10861: p_service_request_rec.ship_to_site_id = FND_API.G_MISS_NUM ) AND
10862: ( p_sr_mode = 'CREATE') ) THEN
10863:
10864: CS_ServiceRequest_UTIL.Validate_Bill_Ship_Site_Use
10865: ( p_api_name => p_api_name,
10866: p_parameter_name => 'Ship_To Site Use ',
10867: p_site_use_id => p_service_request_rec.ship_to_site_use_id,
10868: p_party_id => p_service_request_rec.ship_to_party_id,
10879: ( p_service_request_rec.ship_to_site_use_id IS NULL OR
10880: p_service_request_rec.ship_to_site_use_id = FND_API.G_MISS_NUM ) AND
10881: ( p_sr_mode = 'CREATE') ) THEN
10882:
10883: CS_ServiceRequest_UTIL.Validate_Bill_To_Ship_To_Site
10884: ( p_api_name => p_api_name,
10885: p_parameter_name => 'Ship_To Site ',
10886: p_bill_to_site_id => p_service_request_rec.ship_to_site_id,
10887: p_bill_to_party_id => p_service_request_rec.ship_to_party_id,
10901: ( p_service_request_rec.bill_to_site_use_id <> FND_API.G_MISS_NUM AND
10902: p_service_request_rec.bill_to_site_use_id IS NOT NULL ) AND
10903: ( p_sr_mode = 'CREATE') ) THEN
10904:
10905: CS_ServiceRequest_UTIL.Validate_Site_Site_Use
10906: ( p_api_name => p_api_name,
10907: p_parameter_name => 'Bill_to Site and/or Site Use ',
10908: p_site_id => p_service_request_rec.bill_to_site_id,
10909: p_site_use_id => p_service_request_rec.bill_to_site_use_id,
10920: ( p_service_request_rec.bill_to_site_id IS NULL OR
10921: p_service_request_rec.bill_to_site_id = FND_API.G_MISS_NUM ) AND
10922: ( p_sr_mode = 'CREATE') ) THEN
10923:
10924: CS_ServiceRequest_UTIL.Validate_Bill_Ship_Site_Use
10925: ( p_api_name => p_api_name,
10926: p_parameter_name => 'Bill_to Site Use ',
10927: p_site_use_id => p_service_request_rec.bill_to_site_use_id,
10928: p_party_id => p_service_request_rec.bill_to_party_id,
10939: p_service_request_rec.bill_to_site_id IS NOT NULL ) AND
10940: ( p_service_request_rec.bill_to_site_use_id IS NULL OR
10941: p_service_request_rec.bill_to_site_use_id = FND_API.G_MISS_NUM ) AND
10942: ( p_sr_mode = 'CREATE') ) THEN
10943: CS_ServiceRequest_UTIL.Validate_Bill_To_Ship_To_Site
10944: ( p_api_name => p_api_name,
10945: p_parameter_name => 'Bill_to Site ',
10946: p_bill_to_site_id => p_service_request_rec.bill_to_site_id,
10947: p_bill_to_party_id => p_service_request_rec.bill_to_party_id,
10957:
10958: IF (p_service_request_rec.resolution_code <> FND_API.G_MISS_CHAR)
10959: AND (p_sr_mode = 'CREATE') THEN
10960:
10961: cs_servicerequest_util.resolution_code_cross_val (
10962: p_parameter_name => 'p_resolution_code',
10963: p_resolution_code => p_service_request_rec.resolution_code,
10964: p_problem_code => p_service_request_rec.problem_code,
10965: p_incident_type_id => p_service_request_rec.type_id,
10974: END IF;
10975: END IF;
10976:
10977: IF (p_service_request_rec.act_resolution_date <> FND_API.G_MISS_DATE) THEN
10978: CS_ServiceRequest_UTIL.Validate_Act_Resolution_Date
10979: ( p_api_name => p_api_name,
10980: p_parameter_name => 'p_act_resolution_date',
10981: p_act_resolution_date => p_service_request_rec.act_resolution_date,
10982: p_request_date => p_request_date,
10991: IF (p_service_request_rec.current_contact_time_diff <> FND_API.G_MISS_NUM) THEN
10992: IF ((p_service_request_rec.current_contact_time_diff < -24) OR
10993: (p_service_request_rec.current_contact_time_diff > 24)) THEN
10994:
10995: CS_ServiceRequest_UTIL.Add_Invalid_Argument_Msg
10996: ( p_token_an => 'p_api_name',
10997: p_token_v => TO_CHAR(p_service_request_rec.current_contact_time_diff),
10998: p_token_p => 'p_contact_time_diff',
10999: p_table_name => G_TABLE_NAME ,
11007: IF (p_service_request_rec.rep_by_time_difference <> FND_API.G_MISS_NUM) THEN
11008: IF ((p_service_request_rec.rep_by_time_difference < -24) OR
11009: (p_service_request_rec.rep_by_time_difference > 24)) THEN
11010:
11011: CS_ServiceRequest_UTIL.Add_Invalid_Argument_Msg
11012: ( p_token_an => 'p_api_name',
11013: p_token_v => TO_CHAR(p_service_request_rec.rep_by_time_difference),
11014: p_token_p => 'p_represented_by_time_diff',
11015: p_table_name => G_TABLE_NAME ,
11027: (p_service_request_rec.contract_id IS NOT NULL) AND
11028: (p_service_request_rec.contract_service_id IS NULL OR
11029: p_service_request_rec.contract_service_id = FND_API.G_MISS_NUM) THEN
11030:
11031: CS_ServiceRequest_UTIL.Validate_Contract_Id(
11032: p_api_name => p_api_name,
11033: p_parameter_name => 'p_contract_id',
11034: p_contract_id => p_service_request_rec.contract_id,
11035: x_contract_number => p_contract_number,
11057: IF (p_service_request_rec.caller_type = 'ORGANIZATION') THEN
11058:
11059: --p_org_id => p_org_id,
11060:
11061: CS_ServiceRequest_UTIL.Validate_Account_Id(
11062: p_api_name => p_api_name,
11063: p_parameter_name => 'p_account_id',
11064: p_account_id => p_service_request_rec.account_id,
11065: p_customer_id => p_service_request_rec.customer_id,
11070: RETURN;
11071: END IF;
11072: ELSIF (p_service_request_rec.caller_type = 'PERSON') THEN
11073:
11074: CS_ServiceRequest_UTIL.Validate_Account_Id(
11075: p_api_name => p_api_name,
11076: p_parameter_name => 'p_account_id',
11077: p_account_id => p_service_request_rec.account_id,
11078: p_customer_id => p_service_request_rec.customer_id,
11093:
11094: IF (p_service_request_rec.platform_id <> FND_API.G_MISS_NUM AND
11095: p_service_request_rec.platform_id IS NOT NULL) THEN
11096:
11097: CS_ServiceRequest_UTIL.Validate_Platform_Id(
11098: p_api_name => p_api_name,
11099: p_parameter_name => 'p_platform_id',
11100: p_platform_id => p_service_request_rec.platform_id,
11101: p_organization_id => p_service_request_rec.inv_platform_org_id,
11117: p_service_request_rec.platform_version_id is NOT NULL AND
11118: p_service_request_rec.platform_version <> FND_API.G_MISS_CHAR AND
11119: p_service_request_rec.platform_version is NOT NULL
11120: )THEN
11121: CS_ServiceRequest_UTIL.Add_Invalid_Argument_Msg
11122: ( p_token_an => p_api_name,
11123: p_token_v => p_service_request_rec.platform_version,
11124: p_token_p => 'p_platform_version',
11125: p_table_name => G_TABLE_NAME ,
11136: p_service_request_rec.platform_id IS NOT NULL) AND
11137: (p_service_request_rec.platform_version_id <> FND_API.G_MISS_NUM AND
11138: p_service_request_rec.platform_version_id IS NOT NULL) THEN
11139:
11140: CS_ServiceRequest_UTIL.Validate_Platform_Version_Id(
11141: p_api_name => p_api_name,
11142: p_parameter_name => 'p_platform_Version_id',
11143: p_platform_id => p_service_request_rec.platform_id,
11144: p_organization_id => p_service_request_rec.inv_platform_org_id,
11157: --
11158: IF (p_service_request_rec.territory_id <> FND_API.G_MISS_NUM AND
11159: p_service_request_rec.territory_id IS NOT NULL) THEN
11160:
11161: CS_ServiceRequest_UTIL.Validate_Territory_Id(
11162: p_api_name => p_api_name,
11163: p_parameter_name => 'p_territory_id',
11164: p_territory_id => p_service_request_rec.territory_id,
11165: p_owner_id => p_service_request_rec.owner_id,
11180: IF (p_service_request_rec.cp_component_id <> FND_API.G_MISS_NUM AND
11181: p_service_request_rec.cp_component_id IS NOT NULL)
11182: AND (p_sr_mode = 'CREATE') THEN
11183:
11184: CS_ServiceRequest_UTIL.Validate_CP_Comp_Id(
11185: p_api_name => p_api_name,
11186: p_parameter_name => 'p_cp_component_id',
11187: p_cp_component_id => p_service_request_rec.cp_component_id,
11188: p_customer_product_id => p_service_request_rec.customer_product_id,
11196:
11197: IF (p_service_request_rec.inv_component_id <> FND_API.G_MISS_NUM AND
11198: p_service_request_rec.inv_component_id IS NOT NULL) THEN
11199:
11200: CS_ServiceRequest_UTIL.INV_COMPONENT_CROSS_VAL (
11201: p_parameter_name => 'Inventory component',
11202: p_cp_component_id => p_service_request_rec.cp_component_id,
11203: p_inv_component_id => p_service_request_rec.inv_component_id,
11204: x_return_status => l_return_status );
11222: IF (p_service_request_rec.customer_product_id <> FND_API.G_MISS_NUM AND
11223: p_service_request_rec.customer_product_id IS NOT NULL)
11224: AND (p_sr_mode = 'CREATE') THEN
11225:
11226: CS_ServiceRequest_UTIL.Validate_Product_Version(
11227: p_parameter_name => 'p_product_revision',
11228: p_product_version => x_product_revision,
11229: p_instance_id => p_service_request_rec.customer_product_id,
11230: p_inventory_org_id => p_service_request_rec.inventory_org_id,
11229: p_instance_id => p_service_request_rec.customer_product_id,
11230: p_inventory_org_id => p_service_request_rec.inventory_org_id,
11231: x_return_status => l_return_status);
11232: /***
11233: CS_ServiceRequest_UTIL.Validate_Product_Revision(
11234: p_api_name => p_api_name,
11235: p_parameter_name => 'p_product_revision',
11236: p_product_revision => p_service_request_rec.product_revision,
11237: p_customer_product_id => p_service_request_rec.customer_product_id,
11254: -- p_service_request_rec.component_version IS NOT NULL)
11255: -- AND (p_sr_mode = 'CREATE') THEN
11256:
11257: -- -- For 3337848
11258: -- CS_ServiceRequest_UTIL.Validate_Component_Version(
11259: -- p_api_name => p_api_name,
11260: -- p_parameter_name => 'p_component_version',
11261: -- p_component_version => p_service_request_rec.component_version,
11262: -- p_cp_component_id => p_service_request_rec.cp_component_id,
11274: p_service_request_rec.cp_component_id IS NOT NULL)
11275: AND (p_sr_mode = 'CREATE') THEN
11276:
11277: -- For 3337848
11278: CS_ServiceRequest_UTIL.Validate_Product_Version(
11279: p_parameter_name => 'p_component_version',
11280: p_product_version => x_component_version,
11281: p_instance_id => p_service_request_rec.cp_component_id,
11282: p_inventory_org_id => p_service_request_rec.inventory_org_id,
11293: IF (p_service_request_rec.cp_subcomponent_id <> FND_API.G_MISS_NUM AND
11294: p_service_request_rec.cp_subcomponent_id IS NOT NULL)
11295: AND (p_sr_mode = 'CREATE') THEN
11296:
11297: CS_ServiceRequest_UTIL.Validate_CP_SubComp_Id(
11298: p_api_name => p_api_name,
11299: p_parameter_name => 'p_cp_subcomponent_id',
11300: p_cp_subcomponent_id => p_service_request_rec.cp_subcomponent_id,
11301: p_cp_component_id => p_service_request_rec.cp_component_id,
11311: -- For bug 3324210
11312: IF (p_service_request_rec.inv_subcomponent_id <> FND_API.G_MISS_NUM AND
11313: p_service_request_rec.inv_subcomponent_id IS NOT NULL) THEN
11314:
11315: CS_ServiceRequest_UTIL.INV_SUBCOMPONENT_CROSS_VAL (
11316: p_parameter_name => 'inv subcomponent',
11317: p_inv_subcomponent_id => p_service_request_rec.inv_subcomponent_id,
11318: p_cp_subcomponent_id => p_service_request_rec.cp_subcomponent_id,
11319: x_return_status => l_return_status );
11335: -- p_service_request_rec.subcomponent_version IS NOT NULL)
11336: -- AND (p_sr_mode = 'CREATE') THEN
11337:
11338: -- For bug 3337848
11339: -- CS_ServiceRequest_UTIL.Validate_Subcomponent_Version(
11340: -- p_api_name => p_api_name,
11341: -- p_parameter_name => 'p_subcomponent_version',
11342: -- p_subcomponent_version => p_service_request_rec.subcomponent_version,
11343: -- p_cp_component_id => p_service_request_rec.cp_component_id,
11358: p_service_request_rec.cp_subcomponent_id IS NOT NULL)
11359: AND (p_sr_mode = 'CREATE') THEN
11360:
11361: -- For bug 3337848
11362: CS_ServiceRequest_UTIL.Validate_Product_Version(
11363: p_parameter_name => 'p_subcomponent_version',
11364: p_product_version => x_subcomponent_version,
11365: p_instance_id => p_service_request_rec.cp_subcomponent_id,
11366: p_inventory_org_id => p_service_request_rec.inventory_org_id,
11381: --
11382: IF (p_service_request_rec.inv_item_revision <> FND_API.G_MISS_CHAR )
11383: AND (p_sr_mode = 'CREATE') THEN
11384:
11385: CS_ServiceRequest_UTIL.Validate_Inv_Item_Rev(
11386: p_api_name => p_api_name,
11387: p_parameter_name => 'p_inv_item_revision',
11388: p_inv_item_revision => p_service_request_rec.inv_item_revision,
11389: p_inventory_item_id => p_inventory_item_id,
11402: IF (p_service_request_rec.inv_component_id <> FND_API.G_MISS_NUM AND
11403: p_service_request_rec.inv_component_id IS NOT NULL)
11404: AND (p_sr_mode = 'CREATE') THEN
11405:
11406: CS_ServiceRequest_UTIL.Validate_Inv_Comp_Id(
11407: p_api_name => p_api_name,
11408: p_parameter_name => 'p_inv_component_id',
11409: p_inventory_org_id => p_service_request_rec.inventory_org_id,
11410: p_inv_component_id => p_service_request_rec.inv_component_id,
11422: IF (p_service_request_rec.inv_component_version <> FND_API.G_MISS_CHAR AND
11423: p_service_request_rec.inv_component_version IS NOT NULL)
11424: AND (p_sr_mode = 'CREATE') THEN
11425:
11426: CS_ServiceRequest_UTIL.Validate_Inv_Comp_Ver(
11427: p_api_name => p_api_name,
11428: p_parameter_name => 'p_inv_component_version',
11429: p_inventory_org_id => p_service_request_rec.inventory_org_id,
11430: p_inv_component_id => p_service_request_rec.inv_component_id,
11443: IF (p_sr_mode = 'CREATE' AND
11444: p_service_request_rec.inv_subcomponent_id <> FND_API.G_MISS_NUM AND
11445: p_service_request_rec.inv_subcomponent_id IS NOT NULL) THEN
11446:
11447: CS_ServiceRequest_UTIL.Validate_Inv_SubComp_Id(
11448: p_api_name => p_api_name,
11449: p_parameter_name => 'p_inv_subcomponent_id',
11450: p_inventory_org_id => p_service_request_rec.inventory_org_id,
11451: p_inv_subcomponent_id => p_service_request_rec.inv_subcomponent_id,
11464: IF (p_service_request_rec.inv_subcomponent_version <> FND_API.G_MISS_CHAR AND
11465: p_service_request_rec.inv_subcomponent_version IS NOT NULL)
11466: AND (p_sr_mode = 'CREATE') THEN
11467:
11468: CS_ServiceRequest_UTIL.Validate_Inv_SubComp_Ver(
11469: p_api_name => p_api_name,
11470: p_parameter_name => 'p_inv_subcomponent_version',
11471: p_inventory_org_id => p_service_request_rec.inventory_org_id,
11472: p_inv_subcomponent_id =>p_service_request_rec.inv_subcomponent_id,
11488: p_request_date IS NOT NULL) AND
11489: (p_service_request_rec.incident_occurred_date <> FND_API.G_MISS_DATE AND
11490: p_service_request_rec.incident_occurred_date IS NOT NULL) THEN
11491:
11492: CS_ServiceRequest_UTIL.Validate_Inc_Reported_Date(
11493: p_api_name => p_api_name,
11494: p_parameter_name => 'p_incident_date',
11495: p_request_date => p_request_date,
11496: p_inc_occurred_date => p_service_request_rec.incident_occurred_date,
11508: p_service_request_rec.incident_occurred_date IS NOT NULL) AND
11509: (p_request_date <> FND_API.G_MISS_DATE AND
11510: p_request_date IS NOT NULL) THEN
11511:
11512: CS_ServiceRequest_UTIL.Validate_Inc_Occurred_Date(
11513: p_api_name => p_api_name,
11514: p_parameter_name => 'p_incident_occurred_date',
11515: p_inc_occurred_date => p_service_request_rec.incident_occurred_date,
11516: p_request_date => p_request_date,
11526: --
11527: IF (p_service_request_rec.incident_resolved_date <> FND_API.G_MISS_DATE AND
11528: p_service_request_rec.incident_resolved_date IS NOT NULL) THEN
11529:
11530: CS_ServiceRequest_UTIL.Validate_Inc_Resolved_Date(
11531: p_api_name => p_api_name,
11532: p_parameter_name => 'p_incident_resolved_date',
11533: p_inc_resolved_date => p_service_request_rec.incident_resolved_date,
11534: p_request_date => p_request_date,
11544: --
11545: IF (p_service_request_rec.inc_responded_by_date <> FND_API.G_MISS_DATE AND
11546: p_service_request_rec.inc_responded_by_date IS NOT NULL) THEN
11547:
11548: CS_ServiceRequest_UTIL.Validate_Inc_Responded_Date(
11549: p_api_name => p_api_name,
11550: p_parameter_name => 'p_inc_responded_by_date',
11551: p_inc_responded_by_date => p_service_request_rec.inc_responded_by_date,
11552: p_request_date => p_request_date,
11567: this code is moved to vldt_sr_rec procedure
11568: IF (p_service_request_rec.incident_location_id <> FND_API.G_MISS_NUM AND
11569: p_service_request_rec.incident_location_id IS NOT NULL)
11570: THEN
11571: CS_ServiceRequest_UTIL.Validate_Inc_Location_Id(
11572: p_api_name => p_api_name,
11573: p_parameter_name => 'p_incident_location_id',
11574: p_incident_location_type => p_service_request_rec.incident_location_type,
11575: p_incident_location_id => p_service_request_rec.incident_location_id,
11586: --
11587: IF (p_service_request_rec.incident_country <> FND_API.G_MISS_CHAR AND
11588: p_service_request_rec.incident_country IS NOT NULL) THEN
11589:
11590: CS_ServiceRequest_UTIL.Validate_Incident_Country(
11591: p_api_name => p_api_name,
11592: p_parameter_name => 'p_incident_country',
11593: p_incident_country => p_service_request_rec.incident_country,
11594: x_return_status => l_return_status );
11605: IF (p_service_request_rec.bill_to_account_id <> FND_API.G_MISS_NUM AND
11606: p_service_request_rec.bill_to_account_id IS NOT NULL)
11607: AND (p_sr_mode = 'CREATE') THEN
11608:
11609: CS_ServiceRequest_UTIL.Validate_Bill_To_Ship_To_Acct
11610: ( p_api_name => p_api_name,
11611: p_parameter_name => 'Bill_To Account',
11612: p_account_id => p_service_request_rec.bill_to_account_id,
11613: p_party_id => p_service_request_rec.bill_to_party_id,
11626: IF (p_service_request_rec.ship_to_account_id <> FND_API.G_MISS_NUM AND
11627: p_service_request_rec.ship_to_account_id IS NOT NULL)
11628: AND (p_sr_mode = 'CREATE') THEN
11629:
11630: CS_ServiceRequest_UTIL.Validate_bill_To_Ship_To_Acct
11631: ( p_api_name => p_api_name,
11632: p_parameter_name => 'Ship_To Account',
11633: p_account_id => p_service_request_rec.ship_to_account_id,
11634: p_party_id => p_service_request_rec.ship_to_party_id,
11645:
11646: IF (p_service_request_rec.customer_phone_id <> FND_API.G_MISS_NUM AND
11647: p_service_request_rec.customer_phone_id IS NOT NULL ) THEN
11648:
11649: CS_ServiceRequest_UTIL.Validate_Per_Contact_Point_Id
11650: ( p_api_name => p_api_name,
11651: p_parameter_name => 'p_contact_point_id',
11652: p_contact_point_type => 'PHONE',
11653: p_contact_point_id => p_service_request_rec.customer_phone_id,
11666:
11667: IF (p_service_request_rec.customer_email_id <> FND_API.G_MISS_NUM AND
11668: p_service_request_rec.customer_email_id IS NOT NULL ) THEN
11669:
11670: CS_ServiceRequest_UTIL.Validate_Per_Contact_Point_Id
11671: ( p_api_name => p_api_name,
11672: p_parameter_name => 'p_contact_point_id',
11673: p_contact_point_type => 'EMAIL',
11674: p_contact_point_id => p_service_request_rec.customer_email_id,
11685: -- 15995804 Validate Price List Header Id
11686: IF (p_service_request_rec.price_list_header_id <> FND_API.G_MISS_NUM AND
11687: p_service_request_rec.price_list_header_id IS NOT NULL ) THEN
11688:
11689: CS_ServiceRequest_UTIL.VALIDATE_PRICE_LIST_HEADER
11690: ( p_api_name => p_api_name,
11691: p_parameter_name => 'p_price_list_header_id',
11692: p_price_list_header_id => p_service_request_rec.price_list_header_id,
11693: p_org_id => p_org_id,
11907: Initialize_audit_rec(
11908: p_sr_audit_record => x_audit_vals_rec) ;
11909:
11910: --
11911: --CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg(l_api_name_full, 'step #1');
11912:
11913: -- Check if the mandatory parameters are specified. If not, return error.
11914:
11915: IF (l_service_request_rec.type_id = FND_API.G_MISS_NUM OR
11914:
11915: IF (l_service_request_rec.type_id = FND_API.G_MISS_NUM OR
11916: l_service_request_rec.type_id IS NULL) THEN
11917:
11918: CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg
11919: (p_token_an => l_api_name_full,
11920: p_token_np => 'SR Type',
11921: p_table_name => G_TABLE_NAME,
11922: p_column_name => 'INCIDENT_TYPE_ID');
11927:
11928: IF (l_service_request_rec.status_id = FND_API.G_MISS_NUM OR
11929: l_service_request_rec.status_id IS NULL) THEN
11930:
11931: CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg
11932: (p_token_an => l_api_name_full,
11933: p_token_np => 'SR Status',
11934: p_table_name => G_TABLE_NAME,
11935: p_column_name => 'INCIDENT_STATUS_ID');
11940:
11941: IF (l_service_request_rec.severity_id = FND_API.G_MISS_NUM OR
11942: l_service_request_rec.severity_id IS NULL) THEN
11943:
11944: CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg
11945: (p_token_an => l_api_name_full,
11946: p_token_np => 'SR Severity',
11947: p_table_name => G_TABLE_NAME,
11948: p_column_name => 'SEVERITY_ID');
11953: -- Request Date is a reqd field, so check if passed, else return error
11954: IF (l_service_request_rec.request_date = FND_API.G_MISS_DATE OR
11955: l_service_request_rec.request_date IS NULL) THEN
11956:
11957: CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg
11958: (p_token_an => l_api_name_full,
11959: p_token_np => 'SR Request Date',
11960: p_table_name => G_TABLE_NAME,
11961: p_column_name => 'REQUEST_DATE');
11966: -- Summary is a reqd field, so check if passed, else return error
11967: IF (l_service_request_rec.summary = FND_API.G_MISS_CHAR OR
11968: l_service_request_rec.summary IS NULL) THEN
11969:
11970: CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg
11971: (p_token_an => l_api_name_full,
11972: p_token_np => 'SR Summary',
11973: p_table_name => G_TABLE_NAME,
11974: p_column_name => 'SUMMARY');
11979: -- for cmro_eam
11980:
11981: IF (p_maintenance_flag = 'Y' OR p_maintenance_flag = 'y') THEN
11982: IF (l_service_request_rec.inventory_org_id = FND_API.G_MISS_NUM) THEN
11983: CS_ServiceRequest_UTIL.Add_Missing_Param_Msg(l_api_name_full, 'Inventory Org ID');
11984: RAISE FND_API.G_EXC_ERROR;
11985: ELSIF (l_service_request_rec.inventory_org_id IS NULL) THEN
11986: CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg(l_api_name_full, 'Inventory Org ID');
11987: RAISE FND_API.G_EXC_ERROR;
11982: IF (l_service_request_rec.inventory_org_id = FND_API.G_MISS_NUM) THEN
11983: CS_ServiceRequest_UTIL.Add_Missing_Param_Msg(l_api_name_full, 'Inventory Org ID');
11984: RAISE FND_API.G_EXC_ERROR;
11985: ELSIF (l_service_request_rec.inventory_org_id IS NULL) THEN
11986: CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg(l_api_name_full, 'Inventory Org ID');
11987: RAISE FND_API.G_EXC_ERROR;
11988: END IF;
11989: END IF;
11990: -- end of cmro_eam
12135:
12136: /*Commented this code for backward compatibility, that if someone
12137: passes a creation program code as NULL or G_MISS_CHAR, we are supporting
12138: it now and defaulting it to UNKNOWN
12139: CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg
12140: (p_token_an => l_api_name_full,
12141: p_token_np => 'SR Creation Program Code',
12142: p_table_name => G_TABLE_NAME,
12143: p_column_name => 'CREATION_PROGRAM_CODE');
12209:
12210: --AND(l_service_request_rec.customer_company_name = FND_API.G_MISS_CHAR OR
12211: -- l_service_request_rec.customer_company_name IS NULL)
12212:
12213: CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg
12214: (p_token_an => l_api_name_full,
12215: p_token_np => 'SR Customer',
12216: p_table_name => null,
12217: p_column_name => 'CUSTOMER_COMPANY_NAME');
12228:
12229: ELSE
12230: --Customer Id is not passed, but customer number may be passed
12231: --Retrieve the customer_id from the customer_number
12232: CS_ServiceRequest_UTIL.Convert_Customer_To_ID(
12233: p_api_name=>l_api_name,
12234: p_parameter_name_nb=>'l_service_request_rec.customer_number',
12235: p_parameter_name_n=> 'Customer_Name',
12236: p_customer_number=>l_service_request_rec.customer_number,
12267: -- raise error if customer_id is not passed . bug #3299567
12268: IF ((l_service_request_rec.customer_id = FND_API.G_MISS_NUM OR
12269: l_service_request_rec.customer_id IS NULL )) THEN
12270:
12271: CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg(l_api_name_full, 'SR Customer');
12272: RAISE FND_API.G_EXC_ERROR;
12273:
12274: END IF;
12275:
12278:
12279: ELSE
12280: -- caller type passed is not valid
12281:
12282: CS_ServiceRequest_UTIL.Add_Invalid_Argument_Msg
12283: ( p_token_an => l_api_name_full,
12284: p_token_v => l_service_request_rec.caller_type,
12285: p_token_p => 'p_caller_type',
12286: p_table_name => G_TABLE_NAME ,
12288:
12289: RAISE FND_API.G_EXC_ERROR;
12290: END IF;
12291:
12292: --CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg(l_api_name_full, 'step #2');
12293: --
12294: /*11.5.10 Misc ER added logic to handle usability related changes*/
12295:
12296: -- For bug 3512501 - added begin..exception
12300: FROM cs_incident_statuses_vl
12301: WHERE incident_status_id=l_service_request_rec.status_id ;
12302: exception
12303: when no_data_found then
12304: CS_ServiceRequest_UTIL.Add_Invalid_Argument_Msg( p_token_an => l_api_name_full,
12305: p_token_v => TO_CHAR(l_service_request_rec.status_id),
12306: p_token_p => 'p_status_id',
12307: p_table_name => G_TABLE_NAME,
12308: p_column_name => 'INCIDENT_STATUS_ID' );
12339: INTO l_test
12340: FROM cs_incidents_all_b
12341: WHERE incident_id = p_request_id;
12342:
12343: CS_ServiceRequest_UTIL.Add_Invalid_Argument_Msg
12344: ( p_token_an => l_api_name_full,
12345: p_token_v => p_request_id,
12346: p_token_p => 'p_request_id' ,
12347: p_table_name => G_TABLE_NAME ,
12368: INTO l_test
12369: FROM cs_incidents_all_b
12370: WHERE incident_number = p_request_number;
12371:
12372: CS_ServiceRequest_UTIL.Add_Invalid_Argument_Msg
12373: ( p_token_an => l_api_name_full,
12374: p_token_v => p_request_number,
12375: p_token_p => 'p_request_number',
12376: p_table_name => G_TABLE_NAME,
12390: -- replaced validation of org_id with the procedure call below and set local variable
12391: -- to p_org_id
12392: IF p_org_id IS NOT NULL
12393: THEN
12394: CS_SERVICEREQUEST_UTIL.validate_org_id
12395: ( p_org_id => p_org_id
12396: , x_return_status => l_return_status
12397: );
12398: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
12405:
12406: --
12407: -- Validate the user and login id's
12408: --
12409: CS_ServiceRequest_UTIL.Validate_Who_Info
12410: ( p_api_name => l_api_name_full,
12411: p_parameter_name_usr => 'p_user_id',
12412: p_parameter_name_login => 'p_login_id',
12413: p_user_id => p_user_id,
12421: --
12422: IF l_service_request_rec.created_by IS NOT NULL AND
12423: l_service_request_rec.created_by <> FND_API.G_Miss_NUM THEN
12424:
12425: CS_ServiceRequest_UTIL.Validate_Who_Info
12426: ( p_api_name => l_api_name_full,
12427: p_parameter_name_usr => 'p_created_by',
12428: p_parameter_name_login => NULL,
12429: p_user_id => l_service_request_rec.created_by,
12440: --
12441: IF l_service_request_rec.last_updated_by IS NOT NULL AND
12442: l_service_request_rec.last_updated_by <> FND_API.G_Miss_NUM THEN
12443:
12444: CS_ServiceRequest_UTIL.Validate_Who_Info
12445: ( p_api_name => l_api_name_full,
12446: p_parameter_name_usr => 'p_last_updated_by',
12447: p_parameter_name_login => NULL,
12448: p_user_id => l_service_request_rec.last_updated_by,
12454: END IF;
12455:
12456: END IF ;
12457:
12458: --CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg(l_api_name_full, 'step #2.1');
12459:
12460:
12461: --CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg(l_api_name_full, 'step #2.2');
12462:
12457:
12458: --CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg(l_api_name_full, 'step #2.1');
12459:
12460:
12461: --CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg(l_api_name_full, 'step #2.2');
12462:
12463: --
12464: -- Type, status, severity, resource_type, owner and publish flag are always validated
12465: -- Urgency, problem code, expected resolution date, resolution code, and
12572: AND l_service_request_rec.incident_country <> FND_API.G_MISS_CHAR) THEN
12573: l_service_request_val_rec.incident_country := l_service_request_rec.incident_country;
12574: END IF;
12575:
12576: --CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg(l_api_name_full, 'step #2.3');
12577:
12578: IF (nvl(l_service_request_rec.bill_to_site_id,-99) <> FND_API.G_MISS_NUM) THEN
12579: l_service_request_val_rec.validate_bill_to_site := FND_API.G_TRUE;
12580: l_service_request_val_rec.bill_to_site_id := l_service_request_rec.bill_to_site_id;
12591: IF (nvl(l_service_request_rec.bill_to_party_id, -99) <> FND_API.G_MISS_NUM) THEN
12592: l_service_request_val_rec.bill_to_party_id := l_service_request_rec.bill_to_party_id;
12593: END IF;
12594:
12595: --CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg(l_api_name_full, 'step #2.4');
12596:
12597: IF (nvl(l_service_request_rec.ship_to_site_id, -99) <> FND_API.G_MISS_NUM) THEN
12598: l_service_request_val_rec.validate_ship_to_site := FND_API.G_TRUE;
12599: l_service_request_val_rec.ship_to_site_id := l_service_request_rec.ship_to_site_id;
12611: IF (nvl(l_service_request_rec.ship_to_party_id,-99) <> FND_API.G_MISS_NUM) THEN
12612: l_service_request_val_rec.ship_to_party_id := l_service_request_rec.ship_to_party_id;
12613: END IF;
12614:
12615: --CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg(l_api_name_full, 'step #2.5');
12616:
12617: IF ( l_service_request_rec.install_site_id <> FND_API.G_MISS_NUM ) THEN
12618: l_service_request_val_rec.validate_install_site := FND_API.G_TRUE;
12619: l_service_request_val_rec.install_site_id := l_service_request_rec.install_site_id;
12956: IF l_bill_to_site_use_id <> FND_API.G_MISS_NUM THEN
12957: l_service_request_rec.bill_to_site_use_id := l_bill_to_site_use_id;
12958: END IF;
12959:
12960: --cs_sERviceRequest_UTIL.Add_Null_Parameter_Msg(l_api_name_full, 'step #2.7');
12961:
12962: --
12963: -- If customer product ID is passed in and validated, use the inventory
12964: -- item ID retrieved from the CS_CUSTOMER_PRODUCTS_ALL table.
12983: (l_service_request_rec.closed_date IS NULL)) THEN
12984: l_service_request_rec.closed_date := SYSDATE;
12985: ELSIF (l_service_request_rec.closed_date IS NOT NULL) THEN
12986:
12987: CS_ServiceRequest_UTIL.Validate_Closed_Date
12988: ( p_api_name => l_api_name_full,
12989: p_parameter_name => 'p_closed_date',
12990: p_closed_date => l_service_request_rec.closed_date,
12991: p_request_date => l_service_request_rec.request_date,
12998: ELSE
12999: IF ((l_service_request_rec.closed_date <> FND_API.G_MISS_DATE) AND
13000: (l_service_request_rec.closed_date IS NOT NULL)) THEN
13001:
13002: CS_ServiceRequest_UTIL.Add_Param_Ignored_Msg
13003: (p_token_an => l_api_name_full,
13004: p_token_ip => 'p_closed_date',
13005: p_table_name => G_TABLE_NAME,
13006: p_column_name => 'CLOSED_DATE');
13012: -- For bug 3635269
13013: /* IF (l_service_request_rec.sr_creation_channel <> FND_API.G_MISS_CHAR AND
13014: l_service_request_rec.sr_creation_channel IS NOT NULL) THEN
13015:
13016: CS_ServiceRequest_UTIL.Validate_SR_Channel(
13017: p_api_name => l_api_name_full,
13018: p_parameter_name => 'p_sr_creation_channel',
13019: p_sr_creation_channel => l_service_request_rec.sr_creation_channel,
13020: x_return_status => l_return_status);
13027:
13028:
13029: END IF; /* IF p_validation_level >= FND_API.G_VALID_LEVEL_NONE THEN */
13030:
13031: --CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg(l_api_name_full, 'step #3');
13032:
13033: --
13034: -- The request_id needs to be generated here because it is needed when
13035: -- inserting records into CS_HZ_SR_CONTACT_POINTS
13037: -- request id is unique is done only if validation level is set.
13038: --Commenting this because , selecting from dual is not supported anymore
13039: --because of performance reasons.
13040:
13041: --CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg(l_api_name_full, 'step #4');
13042:
13043: -- -------------------------------------------------------------
13044: -- Check if the passsed type_id has AutoLaunch Workflow flag set to 'Y'.
13045: -- If so, we need to call the workflow lauch API. We need to do this irrespective
13063:
13064: WHEN NO_DATA_FOUND THEN
13065: l_return_status := FND_API.G_RET_STS_ERROR;
13066:
13067: CS_ServiceRequest_UTIL.Add_Invalid_Argument_Msg
13068: ( p_token_an => l_api_name_full,
13069: p_token_v => TO_CHAR(l_service_request_rec.type_id),
13070: p_token_p => 'p_type_id',
13071: p_table_name => G_TABLE_NAME ,
14971: --
14972: IF (l_service_request_rec.contract_service_id <> FND_API.G_MISS_NUM AND
14973: l_service_request_rec.contract_service_id IS NOT NULL) THEN
14974:
14975: CS_ServiceRequest_UTIL.Validate_Contract_Service_Id(
14976: p_api_name => l_api_name,
14977: p_parameter_name => 'p_contract_service_id',
14978: p_contract_service_id => l_service_request_rec.contract_service_id,
14979: x_contract_id =>x_contra_id,
14993: (l_service_request_rec.contract_id IS NOT NULL) AND
14994: (l_service_request_rec.contract_service_id IS NULL OR
14995: l_service_request_rec.contract_service_id <> FND_API.G_MISS_NUM) THEN
14996:
14997: CS_ServiceRequest_UTIL.Validate_Contract_Id(
14998: p_api_name => l_api_name,
14999: p_parameter_name => 'p_contract_id',
15000: p_contract_id => l_service_request_rec.contract_id,
15001: x_contract_number => x_contract_number,
15020:
15021: IF (l_service_request_rec.creation_program_code <> FND_API.G_MISS_CHAR) AND
15022: (l_service_request_rec.creation_program_code IS NOT NULL) THEN
15023:
15024: CS_ServiceRequest_UTIL.Validate_source_program_code(
15025: p_api_name => l_api_name,
15026: p_parameter_name => 'p_creation_program_code',
15027: p_source_program_code => l_service_request_rec.creation_program_code,
15028: x_return_status => l_return_status);
15036: -- Added for address by shijain 05 dec 2002
15037: IF (l_service_request_rec.INCIDENT_DIRECTION_QUALIFIER <> FND_API.G_MISS_CHAR) AND
15038: (l_service_request_rec.INCIDENT_DIRECTION_QUALIFIER IS NOT NULL) THEN
15039:
15040: CS_ServiceRequest_UTIL.Validate_INC_DIRECTION_QUAL(
15041: p_api_name => l_api_name,
15042: p_parameter_name => 'p_INC_DIRECTION_QUAL',
15043: p_INC_DIRECTION_QUAL => l_service_request_rec.INCIDENT_DIRECTION_QUALIFIER,
15044: x_return_status => l_return_status);
15053: IF (l_service_request_rec.INCIDENT_DISTANCE_QUAL_UOM <> FND_API.G_MISS_CHAR) AND
15054: (l_service_request_rec.INCIDENT_DISTANCE_QUAL_UOM IS NOT NULL) THEN
15055:
15056:
15057: CS_ServiceRequest_UTIL.Validate_INC_DIST_QUAL_UOM(
15058: p_api_name => l_api_name,
15059: p_parameter_name => 'p_INC_DIST_QUAL_UOM',
15060: p_INC_DIST_QUAL_UOM => l_service_request_rec.INCIDENT_DISTANCE_QUAL_UOM,
15061: x_return_status => l_return_status);
15073: l_service_request_rec.instrument_payment_use_id := NULL;
15074: END IF;
15075:
15076: IF l_service_request_rec.instrument_payment_use_id IS NOT NULL THEN
15077: CS_ServiceRequest_UTIL.validate_credit_card(
15078: p_api_name => l_api_name,
15079: p_parameter_name => 'P_INSTRUMENT_PAYMENT_USE_ID',
15080: p_instrument_payment_use_id =>
15081: l_service_request_rec.instrument_payment_use_id,
15194: -- structure l_sr_related_data members
15195: --
15196: -- Removed queries on cs_incident_statuses_b table that were
15197: -- present inside comments. These queries are replaced with
15198: -- cs_servicerequest_util.get_status_details call
15199: --
15200: -- Modified condition for calling auto assignment and added
15201: -- one more condition of disallow_request_update flag of
15202: -- old status id. if this flag is Y then auto assignment
15606: OPEN l_ServiceRequest_csr;
15607: FETCH l_ServiceRequest_csr INTO l_old_ServiceRequest_rec;
15608: IF (l_ServiceRequest_csr%NOTFOUND) THEN
15609:
15610: CS_ServiceRequest_UTIL.Add_Invalid_Argument_Msg
15611: ( p_token_an => l_api_name_full,
15612: p_token_v => TO_CHAR(p_request_id),
15613: p_token_p => 'p_request_id',
15614: p_table_name => G_TABLE_NAME,
15726: end if;
15727:
15728: IF ( l_update_desc_flex_int = FND_API.G_TRUE and
15729: p_validation_level > FND_API.G_VALID_LEVEL_NONE) THEN
15730: Cs_Servicerequest_Util.Validate_Desc_Flex(
15731: p_api_name => l_api_name_full,
15732: p_application_short_name => 'CS',
15733: p_desc_flex_name => 'CS_INCIDENTS_ALL_B',
15734: p_desc_segment1 => l_service_request_rec.request_attribute_1,
15878: end if;
15879:
15880: IF ( l_update_desc_flex_ext = FND_API.G_TRUE and
15881: p_validation_level > FND_API.G_VALID_LEVEL_NONE) THEN
15882: Cs_ServiceRequest_Util.Validate_external_Desc_Flex
15883: ( p_api_name => l_api_name_full,
15884: p_application_short_name => 'CS',
15885: p_ext_desc_flex_name => 'CS_INCIDENTS_ALL_B_EXT',
15886: p_ext_desc_segment1 => l_service_request_rec.external_attribute_1,
15992: IF (p_validation_level > FND_API.G_VALID_LEVEL_NONE) THEN
15993: --
15994: -- Validate WHO information
15995: --
15996: CS_ServiceRequest_UTIL.Validate_Who_Info
15997: ( p_api_name => l_api_name_full,
15998: p_parameter_name_usr => 'p_last_updated_by',
15999: p_parameter_name_login => 'p_last_update_login',
16000: p_user_id => l_service_request_rec.last_updated_by,
16009: IF p_last_updated_by IS NOT NULL AND
16010: p_last_updated_by <> FND_API.G_MISS_NUM THEN
16011:
16012:
16013: CS_ServiceRequest_UTIL.Validate_Who_Info
16014: ( p_api_name => l_api_name_full,
16015: p_parameter_name_usr => 'p_last_updated_by',
16016: p_parameter_name_login => null,
16017: p_user_id => p_last_updated_by,
16065: RAISE FND_API.G_EXC_ERROR;
16066: END IF;
16067: END IF; -- Workflow condition
16068:
16069: CS_SERVICEREQUEST_UTIL.get_status_details
16070: ( p_status_id => l_old_servicerequest_rec.incident_status_id
16071: , x_close_flag => l_sr_related_data.old_close_flag
16072: , x_disallow_request_update => l_sr_related_data.old_disallow_request_update
16073: , x_disallow_agent_dispatch => l_sr_related_data.old_disallow_owner_update
16112: l_service_request_rec.last_updated_by IS NULL ) THEN
16113: l_service_request_rec.last_updated_by := p_last_updated_by;
16114: END IF;
16115:
16116: CS_SERVICEREQUEST_UTIL.get_status_details
16117: ( p_status_id => l_service_request_rec.status_id
16118: , x_close_flag => l_sr_related_data.close_flag
16119: , x_disallow_request_update => l_sr_related_data.disallow_request_update
16120: , x_disallow_agent_dispatch => l_sr_related_data.disallow_owner_update
16127: );
16128: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
16129: THEN
16130: l_return_status := FND_API.G_RET_STS_ERROR;
16131: CS_ServiceRequest_UTIL.Add_Invalid_Argument_Msg
16132: ( p_token_an => l_api_name_full
16133: , p_token_v => TO_CHAR(l_service_request_rec.status_id)
16134: , p_token_p => 'p_status_id'
16135: , p_table_name => G_TABLE_NAME
16164: EXCEPTION
16165: WHEN NO_DATA_FOUND THEN
16166: l_return_status := FND_API.G_RET_STS_ERROR;
16167:
16168: CS_ServiceRequest_UTIL.Add_Invalid_Argument_Msg
16169: ( p_token_an => l_api_name_full,
16170: p_token_v => TO_CHAR(l_type_id_temp),
16171: p_token_p => 'p_type_id',
16172: p_table_name => G_TABLE_NAME ,
16506: AND LANGUAGE = USERENV('LANG');
16507: EXCEPTION
16508: WHEN NO_DATA_FOUND THEN
16509: l_return_status := FND_API.G_RET_STS_ERROR;
16510: CS_ServiceRequest_UTIL.Add_Invalid_Argument_Msg
16511: ( p_token_an => l_api_name_full,
16512: p_token_v => TO_CHAR(l_service_request_rec.owner_id),
16513: p_token_p => 'p_owner_id',
16514: p_table_name => G_TABLE_NAME ,
17186: IF (l_service_request_rec.cp_component_id is NULL AND
17187: l_service_request_rec.component_version is NOT NULL AND
17188: l_service_request_rec.component_version <> FND_API.G_MISS_CHAR) THEN
17189: l_service_request_rec.component_version := null;
17190: CS_ServiceRequest_UTIL.Add_Param_Ignored_Msg(
17191: p_token_an => l_api_name_full,
17192: p_token_ip => 'p_component_version' );
17193: END IF;
17194:
17229: IF (l_service_request_rec.cp_subcomponent_id is NULL AND
17230: l_service_request_rec.subcomponent_version is NOT NULL AND
17231: l_service_request_rec.subcomponent_version <> FND_API.G_MISS_CHAR ) THEN
17232: l_service_request_rec.subcomponent_version := null;
17233: CS_ServiceRequest_UTIL.Add_Param_Ignored_Msg(
17234: p_token_an => l_api_name_full,
17235: p_token_ip => 'p_subcomponent_version' );
17236: END IF;
17237:
17612: l_service_request_rec.verify_cp_flag := 'Y';
17613: END IF;
17614: -- 2757488
17615: ELSIF (l_service_request_rec.verify_cp_flag NOT IN ('Y','N')) THEN
17616: CS_ServiceRequest_UTIL.Add_Invalid_Argument_Msg
17617: ( p_token_an => l_api_name_full,
17618: p_token_v => l_service_request_rec.verify_cp_flag,
17619: p_token_p => 'verify_cp_flag',
17620: p_table_name => G_TABLE_NAME ,
17628: IF (l_service_request_rec.verify_cp_flag <> FND_API.G_MISS_CHAR
17629: AND l_service_request_rec.verify_cp_flag IS NOT NULL) THEN
17630:
17631: IF (l_service_request_rec.verify_cp_flag NOT IN ('Y','N')) THEN
17632: CS_ServiceRequest_UTIL.Add_Invalid_Argument_Msg
17633: ( p_token_an => l_api_name_full,
17634: p_token_v => l_service_request_rec.verify_cp_flag,
17635: p_token_p => 'verify_cp_flag',
17636: p_table_name => G_TABLE_NAME ,
17653: END IF;
17654:
17655: if ( p_passed_value <> FND_API.G_MISS_CHAR) then
17656: if ( p_passed_value <> l_service_request_rec.verify_cp_flag) then
17657: CS_ServiceRequest_UTIL.Add_Cp_Flag_Ignored_Msg (p_token_an => l_api_name_full,
17658: p_token_ip => p_passed_value,
17659: p_token_pv => l_service_request_rec.verify_cp_flag);
17660: end if;
17661: end if;
17676: WHERE party_number = l_service_request_rec.customer_number;
17677: EXCEPTION
17678: WHEN OTHERS THEN
17679:
17680: CS_ServiceRequest_UTIL.Add_Invalid_Argument_Msg
17681: ( p_token_an => l_api_name_full,
17682: p_token_v => l_service_request_rec.customer_number,
17683: p_token_p => 'p_customer_number',
17684: p_table_name => G_TABLE_NAME ,
17839:
17840: -- for bug 3333340
17841: if (l_service_request_rec.cp_component_id <> FND_API.G_MISS_NUM AND
17842: l_service_request_rec.cp_component_id IS NOT NULL) then
17843: CS_ServiceRequest_UTIL.Add_Param_Ignored_Msg(
17844: p_token_an => l_api_name_full,
17845: p_token_ip => 'p_cp_component_id' );
17846:
17847: l_service_request_rec.cp_component_id := NULL;
17848: end if;
17849:
17850: if (l_service_request_rec.cp_component_version_id <> FND_API.G_MISS_NUM AND
17851: l_service_request_rec.cp_component_version_id IS NOT NULL) then
17852: CS_ServiceRequest_UTIL.Add_Param_Ignored_Msg(
17853: p_token_an => l_api_name_full,
17854: p_token_ip => 'p_cp_component_version_id' );
17855:
17856: l_service_request_rec.cp_component_version_id := NULL;
17857: end if;
17858:
17859: if (l_service_request_rec.cp_subcomponent_id <> FND_API.G_MISS_NUM AND
17860: l_service_request_rec.cp_subcomponent_id IS NOT NULL) then
17861: CS_ServiceRequest_UTIL.Add_Param_Ignored_Msg(
17862: p_token_an => l_api_name_full,
17863: p_token_ip => 'p_cp_subcomponent_id' );
17864:
17865: l_service_request_rec.cp_subcomponent_id := NULL;
17866: end if;
17867:
17868: if (l_service_request_rec.cp_subcomponent_version_id <> FND_API.G_MISS_NUM AND
17869: l_service_request_rec.cp_subcomponent_version_id IS NOT NULL) then
17870: CS_ServiceRequest_UTIL.Add_Param_Ignored_Msg(
17871: p_token_an => l_api_name_full,
17872: p_token_ip => 'p_cp_subcomponent_version_id' );
17873:
17874: l_service_request_rec.cp_subcomponent_version_id := NULL;
17875: end if;
17876:
17877: if (l_service_request_rec.cp_revision_id <> FND_API.G_MISS_NUM AND
17878: l_service_request_rec.cp_revision_id IS NOT NULL) then
17879: CS_ServiceRequest_UTIL.Add_Param_Ignored_Msg(
17880: p_token_an => l_api_name_full,
17881: p_token_ip => 'p_cp_revision_id' );
17882:
17883: l_service_request_rec.cp_revision_id := NULL;
17885: -- Fix for bug 9398013 Sharanya. Checking for validation level also
17886: if (l_service_request_rec.product_revision <> FND_API.G_MISS_CHAR AND
17887: l_service_request_rec.product_revision IS NOT NULL AND
17888: (p_validation_level > FND_API.G_VALID_LEVEL_NONE)) then
17889: CS_ServiceRequest_UTIL.Add_Param_Ignored_Msg(
17890: p_token_an => l_api_name_full,
17891: p_token_ip => 'p_product_revision' );
17892:
17893: l_service_request_rec.product_revision := NULL;
17894: end if;
17895:
17896: if (l_service_request_rec.component_version <> FND_API.G_MISS_CHAR AND
17897: l_service_request_rec.component_version IS NOT NULL) then
17898: CS_ServiceRequest_UTIL.Add_Param_Ignored_Msg(
17899: p_token_an => l_api_name_full,
17900: p_token_ip => 'p_component_version' );
17901:
17902: l_service_request_rec.component_version := NULL;
17903: end if;
17904:
17905: if (l_service_request_rec.subcomponent_version <> FND_API.G_MISS_CHAR AND
17906: l_service_request_rec.subcomponent_version IS NOT NULL) then
17907: CS_ServiceRequest_UTIL.Add_Param_Ignored_Msg(
17908: p_token_an => l_api_name_full,
17909: p_token_ip => 'p_subcomponent_version' );
17910:
17911: l_service_request_rec.subcomponent_version := NULL;
18227: l_service_request_rec.closed_date := l_old_ServiceRequest_rec.close_date;
18228: END IF;
18229: ELSIF (l_service_request_rec.closed_date IS NOT NULL) THEN
18230:
18231: CS_ServiceRequest_UTIL.Validate_Closed_Date
18232: ( p_api_name => l_api_name_full,
18233: p_parameter_name => 'p_closed_date',
18234: p_closed_date => l_service_request_rec.closed_date,
18235: p_request_date => l_old_ServiceRequest_rec.incident_date,
18245: -- l_service_request_rec.status_flag:= 'O';
18246:
18247: IF (l_service_request_rec.closed_date <> FND_API.G_MISS_DATE) THEN
18248:
18249: CS_ServiceRequest_UTIL.Add_Param_Ignored_Msg
18250: ( p_token_an => l_api_name_full,
18251: p_token_ip => 'p_closed_date',
18252: p_table_name => G_TABLE_NAME,
18253: p_column_name => 'CLOSED_DATE' );
18503: --
18504: IF (l_service_request_rec.contract_service_id <> FND_API.G_MISS_NUM AND
18505: l_service_request_rec.contract_service_id IS NOT NULL) THEN
18506:
18507: CS_ServiceRequest_UTIL.Validate_Contract_Service_Id(
18508: p_api_name => l_api_name,
18509: p_parameter_name => 'p_contract_service_id',
18510: p_contract_service_id => l_service_request_rec.contract_service_id,
18511: x_contract_id =>x_contra_id,
18524: (p_service_request_rec.contract_id IS NOT NULL) AND
18525: (p_service_request_rec.contract_service_id IS NULL OR
18526: p_service_request_rec.contract_service_id = FND_API.G_MISS_NUM) THEN
18527:
18528: CS_ServiceRequest_UTIL.Validate_Contract_Id(
18529: p_api_name => l_api_name,
18530: p_parameter_name => 'p_contract_id',
18531: p_contract_id => l_service_request_rec.contract_id,
18532: x_contract_number => x_contract_number,
18559:
18560: /*Commented this code for backward compatibility, that if someone
18561: passes a last update program code as NULL or G_MISS_CHAR, we are supporting
18562: it now and defaulting it to UNKNOWN
18563: CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg
18564: ( p_token_an => l_api_name_full,
18565: p_token_np => 'SR Last Update Program Code',
18566: p_table_name => G_TABLE_NAME ,
18567: p_column_name => 'LAST_UPDATE_PROGRAM_CODE');
18577:
18578: IF (l_service_request_rec.last_update_program_code <> FND_API.G_MISS_CHAR) AND
18579: (l_service_request_rec.last_update_program_code IS NOT NULL) THEN
18580:
18581: CS_ServiceRequest_UTIL.Validate_source_program_code(
18582: p_api_name => l_api_name,
18583: p_parameter_name => 'p_last_update_program_code',
18584: p_source_program_code => l_service_request_rec.last_update_program_code,
18585: x_return_status => l_return_status);
18593: -- Added for address by shijain 05 dec 2002
18594: IF (l_service_request_rec.INCIDENT_DIRECTION_QUALIFIER <> FND_API.G_MISS_CHAR) AND
18595: (l_service_request_rec.INCIDENT_DIRECTION_QUALIFIER IS NOT NULL) THEN
18596:
18597: CS_ServiceRequest_UTIL.Validate_INC_DIRECTION_QUAL(
18598: p_api_name => l_api_name,
18599: p_parameter_name => 'p_INC_DIRECTION_QUAL',
18600: p_INC_DIRECTION_QUAL => l_service_request_rec.INCIDENT_DIRECTION_QUALIFIER,
18601: x_return_status => l_return_status);
18610: IF (l_service_request_rec.INCIDENT_DISTANCE_QUAL_UOM <> FND_API.G_MISS_CHAR) AND
18611: (l_service_request_rec.INCIDENT_DISTANCE_QUAL_UOM IS NOT NULL) THEN
18612:
18613:
18614: CS_ServiceRequest_UTIL.Validate_INC_DIST_QUAL_UOM(
18615: p_api_name => l_api_name,
18616: p_parameter_name => 'p_INC_DIST_QUAL_UOM',
18617: p_INC_DIST_QUAL_UOM => l_service_request_rec.INCIDENT_DISTANCE_QUAL_UOM,
18618: x_return_status => l_return_status);
19802: l_old_ServiceRequest_rec.instrument_payment_use_id;
19803: END IF;
19804:
19805: IF l_service_request_rec.instrument_payment_use_id IS not NULL THEN
19806: CS_ServiceRequest_UTIL.validate_credit_card(
19807: p_api_name => l_api_name,
19808: p_parameter_name => 'P_INSTRUMENT_PAYMENT_USE_ID',
19809: p_instrument_payment_use_id =>
19810: l_service_request_rec.instrument_payment_use_id,