[Home] [Help]
689: -- 03/08/05 smisra Raised exception if item_serial_number is passed
690: -- 12/30/05 smisra Bug 4869120
691: -- Removed the code in defaultrequest_attributes
692: -- that derives resource type. This is now part of
693: -- procedure cs_servicerequest_util.validate_owner.
694: --------------------------------------------------------------------------------
695: PROCEDURE Create_ServiceRequest
696: ( p_api_version IN NUMBER,
697: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
956: END IF;
957: IF p_passed_value = FND_API.G_MISS_CHAR THEN
958: p_passed_value := NULL;
959: END IF;
960: CS_ServiceRequest_UTIL.Add_Cp_Flag_Ignored_Msg (p_token_an => l_api_name_full,
961: p_token_ip => p_passed_value,
962: p_token_pv => x_request_rec.verify_cp_flag);
963: END IF; */
964:
972: END IF;
973:
974: if ( p_passed_value <> FND_API.G_MISS_CHAR) then
975: if ( p_passed_value <> x_request_rec.verify_cp_flag) then
976: CS_ServiceRequest_UTIL.Add_Cp_Flag_Ignored_Msg (p_token_an => l_api_name_full,
977: p_token_ip => p_passed_value,
978: p_token_pv => x_request_rec.verify_cp_flag);
979: end if;
980: end if;
1004: -- Required parameters are request_date, type_id, status_id,
1005: -- severity_id, owner_id, summary, and the four flags.
1006:
1007: IF (p_request_rec.request_date IS NULL) THEN
1008: CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg(p_api_name, 'SR Request Date');
1009: RAISE FND_API.G_EXC_ERROR;
1010: END IF;
1011:
1012: IF (p_request_rec.type_id = FND_API.G_MISS_NUM) THEN
1009: RAISE FND_API.G_EXC_ERROR;
1010: END IF;
1011:
1012: IF (p_request_rec.type_id = FND_API.G_MISS_NUM) THEN
1013: CS_ServiceRequest_UTIL.Add_Missing_Param_Msg(p_api_name, 'SR Type');
1014: RAISE FND_API.G_EXC_ERROR;
1015: ELSIF (p_request_rec.type_id IS NULL) THEN
1016: CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg(p_api_name, 'SR Type');
1017: RAISE FND_API.G_EXC_ERROR;
1012: IF (p_request_rec.type_id = FND_API.G_MISS_NUM) THEN
1013: CS_ServiceRequest_UTIL.Add_Missing_Param_Msg(p_api_name, 'SR Type');
1014: RAISE FND_API.G_EXC_ERROR;
1015: ELSIF (p_request_rec.type_id IS NULL) THEN
1016: CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg(p_api_name, 'SR Type');
1017: RAISE FND_API.G_EXC_ERROR;
1018: END IF;
1019:
1020: IF (p_request_rec.status_id IS NULL) THEN
1017: RAISE FND_API.G_EXC_ERROR;
1018: END IF;
1019:
1020: IF (p_request_rec.status_id IS NULL) THEN
1021: CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg(p_api_name, 'SR Status');
1022: RAISE FND_API.G_EXC_ERROR;
1023: END IF;
1024:
1025: IF (p_request_rec.severity_id = FND_API.G_MISS_NUM) THEN
1022: RAISE FND_API.G_EXC_ERROR;
1023: END IF;
1024:
1025: IF (p_request_rec.severity_id = FND_API.G_MISS_NUM) THEN
1026: CS_ServiceRequest_UTIL.Add_Missing_Param_Msg(p_api_name, 'SR Severity');
1027: RAISE FND_API.G_EXC_ERROR;
1028: ELSIF (p_request_rec.severity_id IS NULL) THEN
1029: CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg(p_api_name, 'SR Severity');
1030: RAISE FND_API.G_EXC_ERROR;
1025: IF (p_request_rec.severity_id = FND_API.G_MISS_NUM) THEN
1026: CS_ServiceRequest_UTIL.Add_Missing_Param_Msg(p_api_name, 'SR Severity');
1027: RAISE FND_API.G_EXC_ERROR;
1028: ELSIF (p_request_rec.severity_id IS NULL) THEN
1029: CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg(p_api_name, 'SR Severity');
1030: RAISE FND_API.G_EXC_ERROR;
1031: END IF;
1032:
1033: -- Summary could have been passed as NULL or FND_MISS_CHAR
1033: -- Summary could have been passed as NULL or FND_MISS_CHAR
1034: IF (p_request_rec.summary IS NULL) OR
1035: (p_request_rec.summary = FND_API.G_MISS_CHAR) THEN
1036:
1037: CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg(p_api_name, 'SR Summary');
1038: RAISE FND_API.G_EXC_ERROR;
1039:
1040: END IF;
1041:
1042:
1043: -- CAller Type could have been passed as NULL or FND_MISS_CHAR
1044: IF (p_request_rec.caller_type IS NULL) OR
1045: (p_request_rec.caller_type = FND_API.G_MISS_CHAR) THEN
1046: CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg(p_api_name,
1047: 'SR Caller Type');
1048: RAISE FND_API.G_EXC_ERROR;
1049: END IF;
1050:
1048: RAISE FND_API.G_EXC_ERROR;
1049: END IF;
1050:
1051: IF (p_request_rec.verify_cp_flag IS NULL) THEN
1052: CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg(p_api_name, 'p_verify_cp_flag');
1053: RAISE FND_API.G_EXC_ERROR;
1054: END IF;
1055:
1056: -- for cmro_eam
1065: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1066: end;
1067: IF (l_maintenance_flag = 'Y' OR l_maintenance_flag = 'y') THEN
1068: IF (p_request_rec.inventory_org_id = FND_API.G_MISS_NUM) THEN
1069: CS_ServiceRequest_UTIL.Add_Missing_Param_Msg(p_api_name, 'Inventory Org ID');
1070: RAISE FND_API.G_EXC_ERROR;
1071: ELSIF (p_request_rec.inventory_org_id IS NULL) THEN
1072: CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg(p_api_name, 'Inventory Org ID');
1073: RAISE FND_API.G_EXC_ERROR;
1068: IF (p_request_rec.inventory_org_id = FND_API.G_MISS_NUM) THEN
1069: CS_ServiceRequest_UTIL.Add_Missing_Param_Msg(p_api_name, 'Inventory Org ID');
1070: RAISE FND_API.G_EXC_ERROR;
1071: ELSIF (p_request_rec.inventory_org_id IS NULL) THEN
1072: CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg(p_api_name, 'Inventory Org ID');
1073: RAISE FND_API.G_EXC_ERROR;
1074: END IF;
1075: END IF;
1076: -- end for cmro_eam
1504: l_service_request_rec.request_attribute_15 := NULL;
1505: END IF;
1506:
1507:
1508: Cs_ServiceRequest_Util.Validate_Desc_Flex
1509: ( p_api_name => l_api_name_full,
1510: p_application_short_name => 'CS',
1511: p_desc_flex_name => 'CS_INCIDENTS_ALL_B',
1512: p_desc_segment1 => l_service_request_rec.request_attribute_1,
1611: IF (l_service_request_rec.external_attribute_15 = FND_API.G_MISS_CHAR) THEN
1612: l_service_request_rec.external_attribute_15 := NULL;
1613: END IF;
1614:
1615: /************ Changed this call to CS_ServiceRequest_UTIL.Validate_External_Desc_Flex
1616: Bug # 5216510.
1617:
1618: Validate_external_Desc_Flex
1619: ( p_api_name => l_api_name_full,
1640: p_return_status => l_return_status
1641: );
1642: *******************************************************************************/
1643:
1644: Cs_ServiceRequest_Util.Validate_external_Desc_Flex
1645: ( p_api_name => l_api_name_full,
1646: p_application_short_name => 'CS',
1647: p_ext_desc_flex_name => 'CS_INCIDENTS_ALL_B_EXT',
1648: p_ext_desc_segment1 => l_service_request_rec.external_attribute_1,
1947: if (l_request_rec.verify_cp_flag = 'N') then
1948:
1949: if (l_request_rec.cp_component_id <> FND_API.G_MISS_NUM AND
1950: l_request_rec.cp_component_id IS NOT NULL) then
1951: CS_ServiceRequest_UTIL.Add_Param_Ignored_Msg(
1952: p_token_an => l_api_name_full,
1953: p_token_ip => 'p_cp_component_id' );
1954:
1955: l_request_rec.cp_component_id := NULL;
1956: end if;
1957:
1958: if (l_request_rec.cp_component_version_id <> FND_API.G_MISS_NUM AND
1959: l_request_rec.cp_component_version_id IS NOT NULL) then
1960: CS_ServiceRequest_UTIL.Add_Param_Ignored_Msg(
1961: p_token_an => l_api_name_full,
1962: p_token_ip => 'p_cp_component_version_id' );
1963:
1964: l_request_rec.cp_component_version_id := NULL;
1965: end if;
1966:
1967: if (l_request_rec.cp_subcomponent_id <> FND_API.G_MISS_NUM AND
1968: l_request_rec.cp_subcomponent_id IS NOT NULL) then
1969: CS_ServiceRequest_UTIL.Add_Param_Ignored_Msg(
1970: p_token_an => l_api_name_full,
1971: p_token_ip => 'p_cp_subcomponent_id' );
1972:
1973: l_request_rec.cp_subcomponent_id := NULL;
1974: end if;
1975:
1976: if (l_request_rec.cp_subcomponent_version_id <> FND_API.G_MISS_NUM AND
1977: l_request_rec.cp_subcomponent_version_id IS NOT NULL) then
1978: CS_ServiceRequest_UTIL.Add_Param_Ignored_Msg(
1979: p_token_an => l_api_name_full,
1980: p_token_ip => 'p_cp_subcomponent_version_id' );
1981:
1982: l_request_rec.cp_subcomponent_version_id := NULL;
1983: end if;
1984:
1985: if (l_request_rec.cp_revision_id <> FND_API.G_MISS_NUM AND
1986: l_request_rec.cp_revision_id IS NOT NULL) then
1987: CS_ServiceRequest_UTIL.Add_Param_Ignored_Msg(
1988: p_token_an => l_api_name_full,
1989: p_token_ip => 'p_cp_revision_id' );
1990:
1991: l_request_rec.cp_revision_id := NULL;
1992: end if;
1993:
1994: if (l_request_rec.product_revision <> FND_API.G_MISS_CHAR AND
1995: l_request_rec.product_revision IS NOT NULL) then
1996: CS_ServiceRequest_UTIL.Add_Param_Ignored_Msg(
1997: p_token_an => l_api_name_full,
1998: p_token_ip => 'p_product_revision' );
1999:
2000: l_request_rec.product_revision := NULL;
2001: end if;
2002:
2003: if (l_request_rec.component_version <> FND_API.G_MISS_CHAR AND
2004: l_request_rec.component_version IS NOT NULL) then
2005: CS_ServiceRequest_UTIL.Add_Param_Ignored_Msg(
2006: p_token_an => l_api_name_full,
2007: p_token_ip => 'p_component_version' );
2008:
2009: l_request_rec.component_version := NULL;
2010: end if;
2011:
2012: if (l_request_rec.subcomponent_version <> FND_API.G_MISS_CHAR AND
2013: l_request_rec.subcomponent_version IS NOT NULL) then
2014: CS_ServiceRequest_UTIL.Add_Param_Ignored_Msg(
2015: p_token_an => l_api_name_full,
2016: p_token_ip => 'p_subcomponent_version' );
2017:
2018: l_request_rec.subcomponent_version := NULL;
2021:
2022: -- For bug 3541718 - ignore message for contract_number
2023: if ( l_service_request_rec.contract_service_number <> FND_API.G_MISS_CHAR AND
2024: l_service_request_rec.contract_service_number IS NOT NULL) then
2025: CS_ServiceRequest_UTIL.Add_Param_Ignored_Msg(
2026: p_token_an => l_api_name_full,
2027: p_token_ip => 'p_contract_number' );
2028: end if;
2029: -- ----------------------------------------------------------------------
2601: -- Make sure the caller does not set the required fields
2602: -- to NULL
2603: --
2604: IF (l_request_conv_rec.type_id IS NULL) THEN
2605: CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg(
2606: p_token_an => l_api_name_full,
2607: p_token_np => 'p_type_id' );
2608: RAISE FND_API.G_EXC_ERROR;
2609: ELSIF (l_request_conv_rec.status_id IS NULL) THEN
2606: p_token_an => l_api_name_full,
2607: p_token_np => 'p_type_id' );
2608: RAISE FND_API.G_EXC_ERROR;
2609: ELSIF (l_request_conv_rec.status_id IS NULL) THEN
2610: CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg(
2611: p_token_an => l_api_name_full,
2612: p_token_np => 'p_status_id' );
2613: RAISE FND_API.G_EXC_ERROR;
2614: ELSIF (l_request_conv_rec.severity_id IS NULL) THEN
2611: p_token_an => l_api_name_full,
2612: p_token_np => 'p_status_id' );
2613: RAISE FND_API.G_EXC_ERROR;
2614: ELSIF (l_request_conv_rec.severity_id IS NULL) THEN
2615: CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg(
2616: p_token_an => l_api_name_full,
2617: p_token_np => 'p_severity_id' );
2618: RAISE FND_API.G_EXC_ERROR;
2619: ELSIF (l_service_request_rec.summary IS NULL) THEN
2616: p_token_an => l_api_name_full,
2617: p_token_np => 'p_severity_id' );
2618: RAISE FND_API.G_EXC_ERROR;
2619: ELSIF (l_service_request_rec.summary IS NULL) THEN
2620: CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg(
2621: p_token_an => l_api_name_full,
2622: p_token_np => 'p_summary' );
2623: RAISE FND_API.G_EXC_ERROR;
2624: ELSIF (l_request_conv_rec.verify_cp_flag IS NULL) THEN
2621: p_token_an => l_api_name_full,
2622: p_token_np => 'p_summary' );
2623: RAISE FND_API.G_EXC_ERROR;
2624: ELSIF (l_request_conv_rec.verify_cp_flag IS NULL) THEN
2625: CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg(
2626: p_token_an => l_api_name_full,
2627: p_token_np => 'p_verify_cp_flag' );
2628: RAISE FND_API.G_EXC_ERROR;
2629: END IF;
2631: IF l_service_request_rec.owner_id IS NULL THEN
2632: IF (l_service_request_rec.resource_type IS NOT NULL AND
2633: l_service_request_rec.resource_type <> FND_API.G_MISS_CHAR ) THEN
2634:
2635: CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg(
2636: p_token_an => l_api_name_full,
2637: p_token_np => 'p_owner_id' );
2638: RAISE FND_API.G_EXC_ERROR;
2639:
2650:
2651: IF (l_service_request_rec.group_type IS NULL OR
2652: l_service_request_rec.group_type = FND_API.G_MISS_CHAR) THEN
2653:
2654: CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg(
2655: p_token_an => l_api_name_full,
2656: p_token_np => 'p_group_type' );
2657:
2658: RAISE FND_API.G_EXC_ERROR;
2660:
2661: ELSIF l_service_request_rec.owner_group_id IS NULL THEN
2662: IF (l_service_request_rec.group_type IS NOT NULL AND
2663: l_service_request_rec.group_type <> FND_API.G_MISS_CHAR) THEN
2664: CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg(
2665: p_token_an => l_api_name_full,
2666: p_token_np => 'p_group_id' );
2667:
2668: RAISE FND_API.G_EXC_ERROR;
2678: /*
2679: Check to see if a value is passed for Caller_Type as it is not updateable - for BUG 2754987 .
2680: */
2681: IF (l_service_request_rec.caller_type <> FND_API.G_MISS_CHAR) THEN
2682: CS_ServiceRequest_UTIL.Add_Param_Ignored_Msg(
2683: p_token_an => l_api_name_full,
2684: p_token_ip => 'p_caller_type' );
2685:
2686: END IF;
3500: -- -------------------------------------------------------
3501: IF (p_status_id IS NULL) THEN
3502: IF (p_status IS NULL) THEN
3503:
3504: CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg(
3505: p_token_an => l_api_name_full,
3506: p_token_np => 'p_status_id' );
3507: RAISE FND_API.G_EXC_ERROR;
3508:
3507: RAISE FND_API.G_EXC_ERROR;
3508:
3509: ELSE
3510:
3511: CS_ServiceRequest_UTIL.Convert_Status_To_ID(
3512: p_api_name => l_api_name_full,
3513: p_parameter_name => 'p_status',
3514: p_status_name => p_status,
3515: p_subtype => G_SR_Subtype,
3526:
3527: ELSE
3528: l_status_id := p_status_id;
3529: IF (p_status IS NOT NULL) THEN
3530: CS_ServiceRequest_UTIL.Add_Param_Ignored_Msg(
3531: p_token_an => l_api_name_full,
3532: p_token_ip => 'p_status' );
3533: END IF;
3534: END IF;
3538: l_public_comment_flag := 'N';
3539: ELSIF (p_public_comment_flag = FND_API.G_TRUE) THEN
3540: l_public_comment_flag := 'Y';
3541: ELSIF (p_public_comment_flag IS NOT NULL) THEN
3542: CS_ServiceRequest_UTIL.Add_Invalid_Argument_Msg(l_api_name_full,
3543: p_public_comment_flag, 'p_public_comment_flag');
3544: RAISE FND_API.G_EXC_ERROR;
3545: END IF;
3546:
3856: -- -------------------------------------------
3857: -- Make sure the owner ID is not null
3858: -- -------------------------------------------
3859: IF (p_owner_id IS NULL) THEN
3860: CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg(
3861: p_token_an => l_api_name_full,
3862: p_token_np => 'p_owner_id' );
3863: raise FND_API.G_EXC_ERROR;
3864: END IF;
3868: l_public_comment_flag := 'N';
3869: ELSIF (p_public_comment_flag = FND_API.G_TRUE) THEN
3870: l_public_comment_flag := 'Y';
3871: ELSIF (p_public_comment_flag IS NOT NULL) THEN
3872: CS_ServiceRequest_UTIL.Add_Invalid_Argument_Msg(l_api_name_full,
3873: p_public_comment_flag, 'p_public_comment_flag');
3874: RAISE FND_API.G_EXC_ERROR;
3875: END IF;
3876:
4110:
4111: IF ((p_request_conv_rec.type_id <> FND_API.G_MISS_NUM) OR
4112: (p_request_conv_rec.type_id IS NULL)) THEN
4113: IF (p_request_conv_rec.type_name <> FND_API.G_MISS_CHAR) THEN
4114: CS_ServiceRequest_UTIL.Add_Param_Ignored_Msg(p_api_name, 'p_type_name');
4115: END IF;
4116: ELSE
4117: IF (p_request_conv_rec.type_name <> FND_API.G_MISS_CHAR) THEN
4118: CS_ServiceRequest_UTIL.Convert_Type_To_ID
4114: CS_ServiceRequest_UTIL.Add_Param_Ignored_Msg(p_api_name, 'p_type_name');
4115: END IF;
4116: ELSE
4117: IF (p_request_conv_rec.type_name <> FND_API.G_MISS_CHAR) THEN
4118: CS_ServiceRequest_UTIL.Convert_Type_To_ID
4119: ( p_api_name => p_api_name,
4120: p_parameter_name => 'p_type_name',
4121: p_type_name => p_request_conv_rec.type_name,
4122: p_subtype => CS_ServiceRequest_PUB.G_SR_SUBTYPE,
4135:
4136: IF ((p_request_conv_rec.status_id <> FND_API.G_MISS_NUM) OR
4137: (p_request_conv_rec.status_id IS NULL)) THEN
4138: IF (p_request_conv_rec.status_name <> FND_API.G_MISS_CHAR) THEN
4139: CS_ServiceRequest_UTIL.Add_Param_Ignored_Msg(p_api_name, 'p_status_name');
4140: END IF;
4141: ELSE
4142: IF (p_request_conv_rec.status_name <> FND_API.G_MISS_CHAR) THEN
4143: CS_ServiceRequest_UTIL.Convert_Status_To_ID
4139: CS_ServiceRequest_UTIL.Add_Param_Ignored_Msg(p_api_name, 'p_status_name');
4140: END IF;
4141: ELSE
4142: IF (p_request_conv_rec.status_name <> FND_API.G_MISS_CHAR) THEN
4143: CS_ServiceRequest_UTIL.Convert_Status_To_ID
4144: ( p_api_name => p_api_name,
4145: p_parameter_name => 'p_status_name',
4146: p_status_name => p_request_conv_rec.status_name,
4147: p_subtype => CS_ServiceRequest_PUB.G_SR_SUBTYPE,
4160:
4161: IF ((p_request_conv_rec.severity_id <> FND_API.G_MISS_NUM) OR
4162: (p_request_conv_rec.severity_id IS NULL)) THEN
4163: IF (p_request_conv_rec.severity_name <> FND_API.G_MISS_CHAR) THEN
4164: CS_ServiceRequest_UTIL.Add_Param_Ignored_Msg(p_api_name, 'p_severity_name');
4165: END IF;
4166: ELSE
4167: IF (p_request_conv_rec.severity_name <> FND_API.G_MISS_CHAR) THEN
4168: CS_ServiceRequest_UTIL.Convert_Severity_To_ID
4164: CS_ServiceRequest_UTIL.Add_Param_Ignored_Msg(p_api_name, 'p_severity_name');
4165: END IF;
4166: ELSE
4167: IF (p_request_conv_rec.severity_name <> FND_API.G_MISS_CHAR) THEN
4168: CS_ServiceRequest_UTIL.Convert_Severity_To_ID
4169: ( p_api_name => p_api_name,
4170: p_parameter_name => 'p_severity_name',
4171: p_severity_name => p_request_conv_rec.severity_name,
4172: p_subtype => CS_ServiceRequest_PUB.G_SR_SUBTYPE,
4185:
4186: IF ((p_request_conv_rec.urgency_id <> FND_API.G_MISS_NUM) OR
4187: (p_request_conv_rec.urgency_id IS NULL)) THEN --- BUG 2735073
4188: IF (p_request_conv_rec.urgency_name <> FND_API.G_MISS_CHAR) THEN
4189: CS_ServiceRequest_UTIL.Add_Param_Ignored_Msg(p_api_name,
4190: 'p_urgency_name');
4191: END IF;
4192: ELSE
4193: IF (p_request_conv_rec.urgency_name <> FND_API.G_MISS_CHAR) THEN
4190: 'p_urgency_name');
4191: END IF;
4192: ELSE
4193: IF (p_request_conv_rec.urgency_name <> FND_API.G_MISS_CHAR) THEN
4194: CS_ServiceRequest_UTIL.Convert_Urgency_To_ID
4195: ( p_api_name => p_api_name,
4196: p_parameter_name => 'p_urgency_name',
4197: p_urgency_name => p_request_conv_rec.urgency_name,
4198: p_urgency_id => p_request_conv_rec.urgency_id,
4213: p_request_conv_rec.publish_flag := 'Y';
4214: ELSIF (p_request_conv_rec.publish_flag = FND_API.G_FALSE) THEN
4215: p_request_conv_rec.publish_flag := 'N';
4216: ELSIF (p_request_conv_rec.publish_flag IS NOT NULL) THEN
4217: CS_ServiceRequest_UTIL.Add_Invalid_Argument_Msg(p_api_name,
4218: p_request_conv_rec.publish_flag, 'p_publish_flag');
4219: RAISE FND_API.G_EXC_ERROR;
4220: END IF;
4221: END IF;
4222:
4223: IF ((p_request_conv_rec.employee_id <> FND_API.G_MISS_NUM) OR
4224: (p_request_conv_rec.employee_id IS NULL)) THEN
4225: IF (p_request_conv_rec.employee_number <> FND_API.G_MISS_CHAR) THEN
4226: CS_ServiceRequest_UTIL.Add_Param_Ignored_Msg(p_api_name, 'p_employee_number');
4227: END IF;
4228: ELSE
4229: IF (p_request_conv_rec.employee_number <> FND_API.G_MISS_CHAR) THEN
4230: CS_ServiceRequest_UTIL.Convert_Employee_To_ID
4226: CS_ServiceRequest_UTIL.Add_Param_Ignored_Msg(p_api_name, 'p_employee_number');
4227: END IF;
4228: ELSE
4229: IF (p_request_conv_rec.employee_number <> FND_API.G_MISS_CHAR) THEN
4230: CS_ServiceRequest_UTIL.Convert_Employee_To_ID
4231: ( p_api_name => p_api_name,
4232: p_parameter_name_nb => 'p_employee_number',
4233: p_employee_number => p_request_conv_rec.employee_number,
4234: p_employee_id => p_request_conv_rec.employee_id,
4246:
4247: IF ((p_request_conv_rec.customer_product_id <> FND_API.G_MISS_NUM) OR
4248: (p_request_conv_rec.customer_product_id IS NULL)) THEN
4249: IF (p_request_conv_rec.cp_ref_number <> FND_API.G_MISS_NUM) THEN
4250: CS_ServiceRequest_UTIL.Add_Param_Ignored_Msg(p_api_name,
4251: 'p_cp_ref_number');
4252: END IF;
4253: ELSE
4254: IF (p_request_conv_rec.cp_ref_number <> FND_API.G_MISS_NUM) THEN
4251: 'p_cp_ref_number');
4252: END IF;
4253: ELSE
4254: IF (p_request_conv_rec.cp_ref_number <> FND_API.G_MISS_NUM) THEN
4255: CS_ServiceRequest_UTIL.Convert_CP_Ref_Number_To_ID
4256: ( p_api_name => p_api_name,
4257: p_parameter_name => 'p_cp_ref_number',
4258: p_cp_ref_number => p_request_conv_rec.cp_ref_number,
4259: p_org_id => p_org_id,
4325: resp_id => p_resp_id,
4326: user_id => p_user_id
4327: ) THEN
4328: l_error_message := FND_FLEX_KEYVAL.Error_Message;
4329: CS_ServiceRequest_UTIL.Add_Key_Flex_Msg(p_api_name, l_error_message);
4330: p_return_status := FND_API.G_RET_STS_ERROR;
4331: ELSE
4332: p_attribute_id_out := FND_FLEX_KEYVAL.Combination_ID;
4333: END IF;
4358: resp_id => p_resp_id,
4359: user_id => p_user_id
4360: ) THEN
4361: l_error_message := FND_FLEX_KEYVAL.Error_Message;
4362: CS_ServiceRequest_UTIL.Add_Key_Flex_Msg(p_api_name, l_error_message);
4363: p_return_status := FND_API.G_RET_STS_ERROR;
4364: ELSE
4365: p_attribute_id_out := FND_FLEX_KEYVAL.Combination_ID;
4366: END IF;
4437: resp_appl_id => p_resp_appl_id,
4438: resp_id => p_resp_id
4439: ) THEN
4440: l_error_message := FND_FLEX_DESCVAL.Error_Message;
4441: CS_ServiceRequest_UTIL.Add_Desc_Flex_Msg(p_api_name, l_error_message);
4442: p_return_status := FND_API.G_RET_STS_ERROR;
4443: END IF;
4444: END IF;
4445:
4449: -- -------------------------------------------------------------------
4450: -- Validate_External_Desc_Flex
4451: -- For ER# 2501166 added these external attributes date 1st oct 2002
4452: -- -------------------------------------------------------------------
4453: /******* Bug 5216510 Moved this procedure to CS_ServiceRequest_UTIL package.
4454:
4455: PROCEDURE Validate_External_Desc_Flex
4456: ( p_api_name IN VARCHAR2,
4457: p_application_short_name IN VARCHAR2,
4512: resp_appl_id => p_resp_appl_id,
4513: resp_id => p_resp_id
4514: ) THEN
4515: l_error_message := FND_FLEX_DESCVAL.Error_Message;
4516: CS_ServiceRequest_UTIL.Add_Desc_Flex_Msg(p_api_name, l_error_message);
4517: p_return_status := FND_API.G_RET_STS_ERROR;
4518: END IF;
4519: END IF;
4520:
4785: -- Get the request ID
4786: --
4787: IF (p_request_id IS NULL) THEN
4788: IF (p_request_number IS NULL) THEN
4789: CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg(
4790: p_token_an => p_api_name,
4791: p_token_np => 'p_request_id' );
4792: raise FND_API.G_EXC_ERROR;
4793: ELSE
4790: p_token_an => p_api_name,
4791: p_token_np => 'p_request_id' );
4792: raise FND_API.G_EXC_ERROR;
4793: ELSE
4794: CS_ServiceRequest_UTIL.Convert_Request_Number_To_ID(
4795: p_api_name => p_api_name,
4796: p_parameter_name => 'p_request_number',
4797: p_request_number => p_request_number,
4798: p_org_id => p_org_id,
4806: END IF;
4807: ELSE
4808: p_request_id_out := p_request_id;
4809: IF (p_request_number IS NOT NULL) THEN
4810: CS_ServiceRequest_UTIL.Add_Param_Ignored_Msg(
4811: p_token_an => p_api_name,
4812: p_token_ip => 'p_request_number' );
4813: END IF;
4814: END IF;