[Home] [Help]
708: -- 03/08/05 smisra Raised exception if item_serial_number is passed
709: -- 12/30/05 smisra Bug 4869120
710: -- Removed the code in defaultrequest_attributes
711: -- that derives resource type. This is now part of
712: -- procedure cs_servicerequest_util.validate_owner.
713: --------------------------------------------------------------------------------
714: PROCEDURE Create_ServiceRequest
715: ( p_api_version IN NUMBER,
716: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
980: END IF;
981: IF p_passed_value = FND_API.G_MISS_CHAR THEN
982: p_passed_value := NULL;
983: END IF;
984: CS_ServiceRequest_UTIL.Add_Cp_Flag_Ignored_Msg (p_token_an => l_api_name_full,
985: p_token_ip => p_passed_value,
986: p_token_pv => x_request_rec.verify_cp_flag);
987: END IF; */
988:
996: END IF;
997:
998: if ( p_passed_value <> FND_API.G_MISS_CHAR) then
999: if ( p_passed_value <> x_request_rec.verify_cp_flag) then
1000: CS_ServiceRequest_UTIL.Add_Cp_Flag_Ignored_Msg (p_token_an => l_api_name_full,
1001: p_token_ip => p_passed_value,
1002: p_token_pv => x_request_rec.verify_cp_flag);
1003: end if;
1004: end if;
1028: -- Required parameters are request_date, type_id, status_id,
1029: -- severity_id, owner_id, summary, and the four flags.
1030:
1031: IF (p_request_rec.request_date IS NULL) THEN
1032: CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg(p_api_name, 'SR Request Date');
1033: RAISE FND_API.G_EXC_ERROR;
1034: END IF;
1035:
1036: IF (p_request_rec.type_id = FND_API.G_MISS_NUM) THEN
1033: RAISE FND_API.G_EXC_ERROR;
1034: END IF;
1035:
1036: IF (p_request_rec.type_id = FND_API.G_MISS_NUM) THEN
1037: CS_ServiceRequest_UTIL.Add_Missing_Param_Msg(p_api_name, 'SR Type');
1038: RAISE FND_API.G_EXC_ERROR;
1039: ELSIF (p_request_rec.type_id IS NULL) THEN
1040: CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg(p_api_name, 'SR Type');
1041: RAISE FND_API.G_EXC_ERROR;
1036: IF (p_request_rec.type_id = FND_API.G_MISS_NUM) THEN
1037: CS_ServiceRequest_UTIL.Add_Missing_Param_Msg(p_api_name, 'SR Type');
1038: RAISE FND_API.G_EXC_ERROR;
1039: ELSIF (p_request_rec.type_id IS NULL) THEN
1040: CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg(p_api_name, 'SR Type');
1041: RAISE FND_API.G_EXC_ERROR;
1042: END IF;
1043:
1044: IF (p_request_rec.status_id IS NULL) THEN
1041: RAISE FND_API.G_EXC_ERROR;
1042: END IF;
1043:
1044: IF (p_request_rec.status_id IS NULL) THEN
1045: CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg(p_api_name, 'SR Status');
1046: RAISE FND_API.G_EXC_ERROR;
1047: END IF;
1048:
1049: IF (p_request_rec.severity_id = FND_API.G_MISS_NUM) THEN
1046: RAISE FND_API.G_EXC_ERROR;
1047: END IF;
1048:
1049: IF (p_request_rec.severity_id = FND_API.G_MISS_NUM) THEN
1050: CS_ServiceRequest_UTIL.Add_Missing_Param_Msg(p_api_name, 'SR Severity');
1051: RAISE FND_API.G_EXC_ERROR;
1052: ELSIF (p_request_rec.severity_id IS NULL) THEN
1053: CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg(p_api_name, 'SR Severity');
1054: RAISE FND_API.G_EXC_ERROR;
1049: IF (p_request_rec.severity_id = FND_API.G_MISS_NUM) THEN
1050: CS_ServiceRequest_UTIL.Add_Missing_Param_Msg(p_api_name, 'SR Severity');
1051: RAISE FND_API.G_EXC_ERROR;
1052: ELSIF (p_request_rec.severity_id IS NULL) THEN
1053: CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg(p_api_name, 'SR Severity');
1054: RAISE FND_API.G_EXC_ERROR;
1055: END IF;
1056:
1057: -- Summary could have been passed as NULL or FND_MISS_CHAR
1057: -- Summary could have been passed as NULL or FND_MISS_CHAR
1058: IF (p_request_rec.summary IS NULL) OR
1059: (p_request_rec.summary = FND_API.G_MISS_CHAR) THEN
1060:
1061: CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg(p_api_name, 'SR Summary');
1062: RAISE FND_API.G_EXC_ERROR;
1063:
1064: END IF;
1065:
1066:
1067: -- CAller Type could have been passed as NULL or FND_MISS_CHAR
1068: IF (p_request_rec.caller_type IS NULL) OR
1069: (p_request_rec.caller_type = FND_API.G_MISS_CHAR) THEN
1070: CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg(p_api_name,
1071: 'SR Caller Type');
1072: RAISE FND_API.G_EXC_ERROR;
1073: END IF;
1074:
1072: RAISE FND_API.G_EXC_ERROR;
1073: END IF;
1074:
1075: IF (p_request_rec.verify_cp_flag IS NULL) THEN
1076: CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg(p_api_name, 'p_verify_cp_flag');
1077: RAISE FND_API.G_EXC_ERROR;
1078: END IF;
1079:
1080: -- for cmro_eam
1089: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1090: end;
1091: IF (l_maintenance_flag = 'Y' OR l_maintenance_flag = 'y') THEN
1092: IF (p_request_rec.inventory_org_id = FND_API.G_MISS_NUM) THEN
1093: CS_ServiceRequest_UTIL.Add_Missing_Param_Msg(p_api_name, 'Inventory Org ID');
1094: RAISE FND_API.G_EXC_ERROR;
1095: ELSIF (p_request_rec.inventory_org_id IS NULL) THEN
1096: CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg(p_api_name, 'Inventory Org ID');
1097: RAISE FND_API.G_EXC_ERROR;
1092: IF (p_request_rec.inventory_org_id = FND_API.G_MISS_NUM) THEN
1093: CS_ServiceRequest_UTIL.Add_Missing_Param_Msg(p_api_name, 'Inventory Org ID');
1094: RAISE FND_API.G_EXC_ERROR;
1095: ELSIF (p_request_rec.inventory_org_id IS NULL) THEN
1096: CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg(p_api_name, 'Inventory Org ID');
1097: RAISE FND_API.G_EXC_ERROR;
1098: END IF;
1099: END IF;
1100: -- end for cmro_eam
1528: l_service_request_rec.request_attribute_15 := NULL;
1529: END IF;
1530:
1531:
1532: Cs_ServiceRequest_Util.Validate_Desc_Flex
1533: ( p_api_name => l_api_name_full,
1534: p_application_short_name => 'CS',
1535: p_desc_flex_name => 'CS_INCIDENTS_ALL_B',
1536: p_desc_segment1 => l_service_request_rec.request_attribute_1,
1635: IF (l_service_request_rec.external_attribute_15 = FND_API.G_MISS_CHAR) THEN
1636: l_service_request_rec.external_attribute_15 := NULL;
1637: END IF;
1638:
1639: /************ Changed this call to CS_ServiceRequest_UTIL.Validate_External_Desc_Flex
1640: Bug # 5216510.
1641:
1642: Validate_external_Desc_Flex
1643: ( p_api_name => l_api_name_full,
1664: p_return_status => l_return_status
1665: );
1666: *******************************************************************************/
1667:
1668: Cs_ServiceRequest_Util.Validate_external_Desc_Flex
1669: ( p_api_name => l_api_name_full,
1670: p_application_short_name => 'CS',
1671: p_ext_desc_flex_name => 'CS_INCIDENTS_ALL_B_EXT',
1672: p_ext_desc_segment1 => l_service_request_rec.external_attribute_1,
1996: if (l_request_rec.verify_cp_flag = 'N') then
1997:
1998: if (l_request_rec.cp_component_id <> FND_API.G_MISS_NUM AND
1999: l_request_rec.cp_component_id IS NOT NULL) then
2000: CS_ServiceRequest_UTIL.Add_Param_Ignored_Msg(
2001: p_token_an => l_api_name_full,
2002: p_token_ip => 'p_cp_component_id' );
2003:
2004: l_request_rec.cp_component_id := NULL;
2005: end if;
2006:
2007: if (l_request_rec.cp_component_version_id <> FND_API.G_MISS_NUM AND
2008: l_request_rec.cp_component_version_id IS NOT NULL) then
2009: CS_ServiceRequest_UTIL.Add_Param_Ignored_Msg(
2010: p_token_an => l_api_name_full,
2011: p_token_ip => 'p_cp_component_version_id' );
2012:
2013: l_request_rec.cp_component_version_id := NULL;
2014: end if;
2015:
2016: if (l_request_rec.cp_subcomponent_id <> FND_API.G_MISS_NUM AND
2017: l_request_rec.cp_subcomponent_id IS NOT NULL) then
2018: CS_ServiceRequest_UTIL.Add_Param_Ignored_Msg(
2019: p_token_an => l_api_name_full,
2020: p_token_ip => 'p_cp_subcomponent_id' );
2021:
2022: l_request_rec.cp_subcomponent_id := NULL;
2023: end if;
2024:
2025: if (l_request_rec.cp_subcomponent_version_id <> FND_API.G_MISS_NUM AND
2026: l_request_rec.cp_subcomponent_version_id IS NOT NULL) then
2027: CS_ServiceRequest_UTIL.Add_Param_Ignored_Msg(
2028: p_token_an => l_api_name_full,
2029: p_token_ip => 'p_cp_subcomponent_version_id' );
2030:
2031: l_request_rec.cp_subcomponent_version_id := NULL;
2032: end if;
2033:
2034: if (l_request_rec.cp_revision_id <> FND_API.G_MISS_NUM AND
2035: l_request_rec.cp_revision_id IS NOT NULL) then
2036: CS_ServiceRequest_UTIL.Add_Param_Ignored_Msg(
2037: p_token_an => l_api_name_full,
2038: p_token_ip => 'p_cp_revision_id' );
2039:
2040: l_request_rec.cp_revision_id := NULL;
2041: end if;
2042:
2043: if (l_request_rec.product_revision <> FND_API.G_MISS_CHAR AND
2044: l_request_rec.product_revision IS NOT NULL) then
2045: CS_ServiceRequest_UTIL.Add_Param_Ignored_Msg(
2046: p_token_an => l_api_name_full,
2047: p_token_ip => 'p_product_revision' );
2048:
2049: l_request_rec.product_revision := NULL;
2050: end if;
2051:
2052: if (l_request_rec.component_version <> FND_API.G_MISS_CHAR AND
2053: l_request_rec.component_version IS NOT NULL) then
2054: CS_ServiceRequest_UTIL.Add_Param_Ignored_Msg(
2055: p_token_an => l_api_name_full,
2056: p_token_ip => 'p_component_version' );
2057:
2058: l_request_rec.component_version := NULL;
2059: end if;
2060:
2061: if (l_request_rec.subcomponent_version <> FND_API.G_MISS_CHAR AND
2062: l_request_rec.subcomponent_version IS NOT NULL) then
2063: CS_ServiceRequest_UTIL.Add_Param_Ignored_Msg(
2064: p_token_an => l_api_name_full,
2065: p_token_ip => 'p_subcomponent_version' );
2066:
2067: l_request_rec.subcomponent_version := NULL;
2070:
2071: -- For bug 3541718 - ignore message for contract_number
2072: if ( l_service_request_rec.contract_service_number <> FND_API.G_MISS_CHAR AND
2073: l_service_request_rec.contract_service_number IS NOT NULL) then
2074: CS_ServiceRequest_UTIL.Add_Param_Ignored_Msg(
2075: p_token_an => l_api_name_full,
2076: p_token_ip => 'p_contract_number' );
2077: end if;
2078: -- ----------------------------------------------------------------------
2670: -- Make sure the caller does not set the required fields
2671: -- to NULL
2672: --
2673: IF (l_request_conv_rec.type_id IS NULL) THEN
2674: CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg(
2675: p_token_an => l_api_name_full,
2676: p_token_np => 'p_type_id' );
2677: RAISE FND_API.G_EXC_ERROR;
2678: ELSIF (l_request_conv_rec.status_id IS NULL) THEN
2675: p_token_an => l_api_name_full,
2676: p_token_np => 'p_type_id' );
2677: RAISE FND_API.G_EXC_ERROR;
2678: ELSIF (l_request_conv_rec.status_id IS NULL) THEN
2679: CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg(
2680: p_token_an => l_api_name_full,
2681: p_token_np => 'p_status_id' );
2682: RAISE FND_API.G_EXC_ERROR;
2683: ELSIF (l_request_conv_rec.severity_id IS NULL) THEN
2680: p_token_an => l_api_name_full,
2681: p_token_np => 'p_status_id' );
2682: RAISE FND_API.G_EXC_ERROR;
2683: ELSIF (l_request_conv_rec.severity_id IS NULL) THEN
2684: CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg(
2685: p_token_an => l_api_name_full,
2686: p_token_np => 'p_severity_id' );
2687: RAISE FND_API.G_EXC_ERROR;
2688: ELSIF (l_service_request_rec.summary IS NULL) THEN
2685: p_token_an => l_api_name_full,
2686: p_token_np => 'p_severity_id' );
2687: RAISE FND_API.G_EXC_ERROR;
2688: ELSIF (l_service_request_rec.summary IS NULL) THEN
2689: CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg(
2690: p_token_an => l_api_name_full,
2691: p_token_np => 'p_summary' );
2692: RAISE FND_API.G_EXC_ERROR;
2693: ELSIF (l_request_conv_rec.verify_cp_flag IS NULL) THEN
2690: p_token_an => l_api_name_full,
2691: p_token_np => 'p_summary' );
2692: RAISE FND_API.G_EXC_ERROR;
2693: ELSIF (l_request_conv_rec.verify_cp_flag IS NULL) THEN
2694: CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg(
2695: p_token_an => l_api_name_full,
2696: p_token_np => 'p_verify_cp_flag' );
2697: RAISE FND_API.G_EXC_ERROR;
2698: END IF;
2700: IF l_service_request_rec.owner_id IS NULL THEN
2701: IF (l_service_request_rec.resource_type IS NOT NULL AND
2702: l_service_request_rec.resource_type <> FND_API.G_MISS_CHAR ) THEN
2703:
2704: CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg(
2705: p_token_an => l_api_name_full,
2706: p_token_np => 'p_owner_id' );
2707: RAISE FND_API.G_EXC_ERROR;
2708:
2719:
2720: IF (l_service_request_rec.group_type IS NULL OR
2721: l_service_request_rec.group_type = FND_API.G_MISS_CHAR) THEN
2722:
2723: CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg(
2724: p_token_an => l_api_name_full,
2725: p_token_np => 'p_group_type' );
2726:
2727: RAISE FND_API.G_EXC_ERROR;
2729:
2730: ELSIF l_service_request_rec.owner_group_id IS NULL THEN
2731: IF (l_service_request_rec.group_type IS NOT NULL AND
2732: l_service_request_rec.group_type <> FND_API.G_MISS_CHAR) THEN
2733: CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg(
2734: p_token_an => l_api_name_full,
2735: p_token_np => 'p_group_id' );
2736:
2737: RAISE FND_API.G_EXC_ERROR;
2747: /*
2748: Check to see if a value is passed for Caller_Type as it is not updateable - for BUG 2754987 .
2749: */
2750: IF (l_service_request_rec.caller_type <> FND_API.G_MISS_CHAR) THEN
2751: CS_ServiceRequest_UTIL.Add_Param_Ignored_Msg(
2752: p_token_an => l_api_name_full,
2753: p_token_ip => 'p_caller_type' );
2754:
2755: END IF;
3613: -- -------------------------------------------------------
3614: IF (p_status_id IS NULL) THEN
3615: IF (p_status IS NULL) THEN
3616:
3617: CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg(
3618: p_token_an => l_api_name_full,
3619: p_token_np => 'p_status_id' );
3620: RAISE FND_API.G_EXC_ERROR;
3621:
3620: RAISE FND_API.G_EXC_ERROR;
3621:
3622: ELSE
3623:
3624: CS_ServiceRequest_UTIL.Convert_Status_To_ID(
3625: p_api_name => l_api_name_full,
3626: p_parameter_name => 'p_status',
3627: p_status_name => p_status,
3628: p_subtype => G_SR_Subtype,
3639:
3640: ELSE
3641: l_status_id := p_status_id;
3642: IF (p_status IS NOT NULL) THEN
3643: CS_ServiceRequest_UTIL.Add_Param_Ignored_Msg(
3644: p_token_an => l_api_name_full,
3645: p_token_ip => 'p_status' );
3646: END IF;
3647: END IF;
3651: l_public_comment_flag := 'N';
3652: ELSIF (p_public_comment_flag = FND_API.G_TRUE) THEN
3653: l_public_comment_flag := 'Y';
3654: ELSIF (p_public_comment_flag IS NOT NULL) THEN
3655: CS_ServiceRequest_UTIL.Add_Invalid_Argument_Msg(l_api_name_full,
3656: p_public_comment_flag, 'p_public_comment_flag');
3657: RAISE FND_API.G_EXC_ERROR;
3658: END IF;
3659:
3971: -- -------------------------------------------
3972: -- Make sure the owner ID is not null
3973: -- -------------------------------------------
3974: IF (p_owner_id IS NULL) THEN
3975: CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg(
3976: p_token_an => l_api_name_full,
3977: p_token_np => 'p_owner_id' );
3978: raise FND_API.G_EXC_ERROR;
3979: END IF;
3983: l_public_comment_flag := 'N';
3984: ELSIF (p_public_comment_flag = FND_API.G_TRUE) THEN
3985: l_public_comment_flag := 'Y';
3986: ELSIF (p_public_comment_flag IS NOT NULL) THEN
3987: CS_ServiceRequest_UTIL.Add_Invalid_Argument_Msg(l_api_name_full,
3988: p_public_comment_flag, 'p_public_comment_flag');
3989: RAISE FND_API.G_EXC_ERROR;
3990: END IF;
3991:
4225:
4226: IF ((p_request_conv_rec.type_id <> FND_API.G_MISS_NUM) OR
4227: (p_request_conv_rec.type_id IS NULL)) THEN
4228: IF (p_request_conv_rec.type_name <> FND_API.G_MISS_CHAR) THEN
4229: CS_ServiceRequest_UTIL.Add_Param_Ignored_Msg(p_api_name, 'p_type_name');
4230: END IF;
4231: ELSE
4232: IF (p_request_conv_rec.type_name <> FND_API.G_MISS_CHAR) THEN
4233: CS_ServiceRequest_UTIL.Convert_Type_To_ID
4229: CS_ServiceRequest_UTIL.Add_Param_Ignored_Msg(p_api_name, 'p_type_name');
4230: END IF;
4231: ELSE
4232: IF (p_request_conv_rec.type_name <> FND_API.G_MISS_CHAR) THEN
4233: CS_ServiceRequest_UTIL.Convert_Type_To_ID
4234: ( p_api_name => p_api_name,
4235: p_parameter_name => 'p_type_name',
4236: p_type_name => p_request_conv_rec.type_name,
4237: p_subtype => CS_ServiceRequest_PUB.G_SR_SUBTYPE,
4250:
4251: IF ((p_request_conv_rec.status_id <> FND_API.G_MISS_NUM) OR
4252: (p_request_conv_rec.status_id IS NULL)) THEN
4253: IF (p_request_conv_rec.status_name <> FND_API.G_MISS_CHAR) THEN
4254: CS_ServiceRequest_UTIL.Add_Param_Ignored_Msg(p_api_name, 'p_status_name');
4255: END IF;
4256: ELSE
4257: IF (p_request_conv_rec.status_name <> FND_API.G_MISS_CHAR) THEN
4258: CS_ServiceRequest_UTIL.Convert_Status_To_ID
4254: CS_ServiceRequest_UTIL.Add_Param_Ignored_Msg(p_api_name, 'p_status_name');
4255: END IF;
4256: ELSE
4257: IF (p_request_conv_rec.status_name <> FND_API.G_MISS_CHAR) THEN
4258: CS_ServiceRequest_UTIL.Convert_Status_To_ID
4259: ( p_api_name => p_api_name,
4260: p_parameter_name => 'p_status_name',
4261: p_status_name => p_request_conv_rec.status_name,
4262: p_subtype => CS_ServiceRequest_PUB.G_SR_SUBTYPE,
4275:
4276: IF ((p_request_conv_rec.severity_id <> FND_API.G_MISS_NUM) OR
4277: (p_request_conv_rec.severity_id IS NULL)) THEN
4278: IF (p_request_conv_rec.severity_name <> FND_API.G_MISS_CHAR) THEN
4279: CS_ServiceRequest_UTIL.Add_Param_Ignored_Msg(p_api_name, 'p_severity_name');
4280: END IF;
4281: ELSE
4282: IF (p_request_conv_rec.severity_name <> FND_API.G_MISS_CHAR) THEN
4283: CS_ServiceRequest_UTIL.Convert_Severity_To_ID
4279: CS_ServiceRequest_UTIL.Add_Param_Ignored_Msg(p_api_name, 'p_severity_name');
4280: END IF;
4281: ELSE
4282: IF (p_request_conv_rec.severity_name <> FND_API.G_MISS_CHAR) THEN
4283: CS_ServiceRequest_UTIL.Convert_Severity_To_ID
4284: ( p_api_name => p_api_name,
4285: p_parameter_name => 'p_severity_name',
4286: p_severity_name => p_request_conv_rec.severity_name,
4287: p_subtype => CS_ServiceRequest_PUB.G_SR_SUBTYPE,
4300:
4301: IF ((p_request_conv_rec.urgency_id <> FND_API.G_MISS_NUM) OR
4302: (p_request_conv_rec.urgency_id IS NULL)) THEN --- BUG 2735073
4303: IF (p_request_conv_rec.urgency_name <> FND_API.G_MISS_CHAR) THEN
4304: CS_ServiceRequest_UTIL.Add_Param_Ignored_Msg(p_api_name,
4305: 'p_urgency_name');
4306: END IF;
4307: ELSE
4308: IF (p_request_conv_rec.urgency_name <> FND_API.G_MISS_CHAR) THEN
4305: 'p_urgency_name');
4306: END IF;
4307: ELSE
4308: IF (p_request_conv_rec.urgency_name <> FND_API.G_MISS_CHAR) THEN
4309: CS_ServiceRequest_UTIL.Convert_Urgency_To_ID
4310: ( p_api_name => p_api_name,
4311: p_parameter_name => 'p_urgency_name',
4312: p_urgency_name => p_request_conv_rec.urgency_name,
4313: p_urgency_id => p_request_conv_rec.urgency_id,
4332: p_request_conv_rec.publish_flag := 'Y';
4333: ELSIF (p_request_conv_rec.publish_flag = FND_API.G_FALSE OR p_request_conv_rec.publish_flag = 'N') THEN
4334: p_request_conv_rec.publish_flag := 'N';
4335: ELSIF (p_request_conv_rec.publish_flag IS NOT NULL) THEN
4336: CS_ServiceRequest_UTIL.Add_Invalid_Argument_Msg(p_api_name,
4337: p_request_conv_rec.publish_flag, 'p_publish_flag');
4338: RAISE FND_API.G_EXC_ERROR;
4339: END IF;
4340: END IF;
4341:
4342: IF ((p_request_conv_rec.employee_id <> FND_API.G_MISS_NUM) OR
4343: (p_request_conv_rec.employee_id IS NULL)) THEN
4344: IF (p_request_conv_rec.employee_number <> FND_API.G_MISS_CHAR) THEN
4345: CS_ServiceRequest_UTIL.Add_Param_Ignored_Msg(p_api_name, 'p_employee_number');
4346: END IF;
4347: ELSE
4348: IF (p_request_conv_rec.employee_number <> FND_API.G_MISS_CHAR) THEN
4349: CS_ServiceRequest_UTIL.Convert_Employee_To_ID
4345: CS_ServiceRequest_UTIL.Add_Param_Ignored_Msg(p_api_name, 'p_employee_number');
4346: END IF;
4347: ELSE
4348: IF (p_request_conv_rec.employee_number <> FND_API.G_MISS_CHAR) THEN
4349: CS_ServiceRequest_UTIL.Convert_Employee_To_ID
4350: ( p_api_name => p_api_name,
4351: p_parameter_name_nb => 'p_employee_number',
4352: p_employee_number => p_request_conv_rec.employee_number,
4353: p_employee_id => p_request_conv_rec.employee_id,
4365:
4366: IF ((p_request_conv_rec.customer_product_id <> FND_API.G_MISS_NUM) OR
4367: (p_request_conv_rec.customer_product_id IS NULL)) THEN
4368: IF (p_request_conv_rec.cp_ref_number <> FND_API.G_MISS_NUM) THEN
4369: CS_ServiceRequest_UTIL.Add_Param_Ignored_Msg(p_api_name,
4370: 'p_cp_ref_number');
4371: END IF;
4372: ELSE
4373: IF (p_request_conv_rec.cp_ref_number <> FND_API.G_MISS_NUM) THEN
4370: 'p_cp_ref_number');
4371: END IF;
4372: ELSE
4373: IF (p_request_conv_rec.cp_ref_number <> FND_API.G_MISS_NUM) THEN
4374: CS_ServiceRequest_UTIL.Convert_CP_Ref_Number_To_ID
4375: ( p_api_name => p_api_name,
4376: p_parameter_name => 'p_cp_ref_number',
4377: p_cp_ref_number => p_request_conv_rec.cp_ref_number,
4378: p_org_id => p_org_id,
4444: resp_id => p_resp_id,
4445: user_id => p_user_id
4446: ) THEN
4447: l_error_message := FND_FLEX_KEYVAL.Error_Message;
4448: CS_ServiceRequest_UTIL.Add_Key_Flex_Msg(p_api_name, l_error_message);
4449: p_return_status := FND_API.G_RET_STS_ERROR;
4450: ELSE
4451: p_attribute_id_out := FND_FLEX_KEYVAL.Combination_ID;
4452: END IF;
4477: resp_id => p_resp_id,
4478: user_id => p_user_id
4479: ) THEN
4480: l_error_message := FND_FLEX_KEYVAL.Error_Message;
4481: CS_ServiceRequest_UTIL.Add_Key_Flex_Msg(p_api_name, l_error_message);
4482: p_return_status := FND_API.G_RET_STS_ERROR;
4483: ELSE
4484: p_attribute_id_out := FND_FLEX_KEYVAL.Combination_ID;
4485: END IF;
4556: resp_appl_id => p_resp_appl_id,
4557: resp_id => p_resp_id
4558: ) THEN
4559: l_error_message := FND_FLEX_DESCVAL.Error_Message;
4560: CS_ServiceRequest_UTIL.Add_Desc_Flex_Msg(p_api_name, l_error_message);
4561: p_return_status := FND_API.G_RET_STS_ERROR;
4562: END IF;
4563: END IF;
4564:
4568: -- -------------------------------------------------------------------
4569: -- Validate_External_Desc_Flex
4570: -- For ER# 2501166 added these external attributes date 1st oct 2002
4571: -- -------------------------------------------------------------------
4572: /******* Bug 5216510 Moved this procedure to CS_ServiceRequest_UTIL package.
4573:
4574: PROCEDURE Validate_External_Desc_Flex
4575: ( p_api_name IN VARCHAR2,
4576: p_application_short_name IN VARCHAR2,
4631: resp_appl_id => p_resp_appl_id,
4632: resp_id => p_resp_id
4633: ) THEN
4634: l_error_message := FND_FLEX_DESCVAL.Error_Message;
4635: CS_ServiceRequest_UTIL.Add_Desc_Flex_Msg(p_api_name, l_error_message);
4636: p_return_status := FND_API.G_RET_STS_ERROR;
4637: END IF;
4638: END IF;
4639:
4904: -- Get the request ID
4905: --
4906: IF (p_request_id IS NULL) THEN
4907: IF (p_request_number IS NULL) THEN
4908: CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg(
4909: p_token_an => p_api_name,
4910: p_token_np => 'p_request_id' );
4911: raise FND_API.G_EXC_ERROR;
4912: ELSE
4909: p_token_an => p_api_name,
4910: p_token_np => 'p_request_id' );
4911: raise FND_API.G_EXC_ERROR;
4912: ELSE
4913: CS_ServiceRequest_UTIL.Convert_Request_Number_To_ID(
4914: p_api_name => p_api_name,
4915: p_parameter_name => 'p_request_number',
4916: p_request_number => p_request_number,
4917: p_org_id => p_org_id,
4925: END IF;
4926: ELSE
4927: p_request_id_out := p_request_id;
4928: IF (p_request_number IS NOT NULL) THEN
4929: CS_ServiceRequest_UTIL.Add_Param_Ignored_Msg(
4930: p_token_an => p_api_name,
4931: p_token_ip => 'p_request_number' );
4932: END IF;
4933: END IF;