[Home] [Help]
1204: ( 'API_NAME'
1205: , 'CS_SERVICEREQUEST_PUB.create_servicerequest'
1206: );
1207: FND_MSG_PUB.ADD_DETAIL
1208: ( p_associated_column1 => 'CS_INCIDENTS_ALL_B.ITEM_SERIAL_NUMBER'
1209: );
1210: RAISE FND_API.G_EXC_ERROR;
1211: END IF;
1212: -- ------------------------------------------------------------------
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,
1537: p_desc_segment2 => l_service_request_rec.request_attribute_2,
1538: p_desc_segment3 => l_service_request_rec.request_attribute_3,
1539: p_desc_segment4 => l_service_request_rec.request_attribute_4,
1641:
1642: Validate_external_Desc_Flex
1643: ( p_api_name => l_api_name_full,
1644: p_application_short_name => 'CS',
1645: p_ext_desc_flex_name => 'CS_INCIDENTS_ALL_B_EXT',
1646: p_ext_desc_segment1 => l_service_request_rec.external_attribute_1,
1647: p_ext_desc_segment2 => l_service_request_rec.external_attribute_2,
1648: p_ext_desc_segment3 => l_service_request_rec.external_attribute_3,
1649: p_ext_desc_segment4 => l_service_request_rec.external_attribute_4,
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,
1673: p_ext_desc_segment2 => l_service_request_rec.external_attribute_2,
1674: p_ext_desc_segment3 => l_service_request_rec.external_attribute_3,
1675: p_ext_desc_segment4 => l_service_request_rec.external_attribute_4,
2567: ( 'API_NAME'
2568: , 'CS_SERVICEREQUEST_PUB.update_servicerequest'
2569: );
2570: FND_MSG_PUB.ADD_DETAIL
2571: ( p_associated_column1 => 'CS_INCIDENTS_ALL_B.ITEM_SERIAL_NUMBER'
2572: );
2573: RAISE FND_API.G_EXC_ERROR;
2574: END IF;
2575: -- ------------------------------------------------------------
2978:
2979: Validate_Desc_Flex(
2980: p_api_name => l_api_name_full,
2981: p_application_short_name => 'CS',
2982: p_desc_flex_name => 'CS_INCIDENTS_ALL_B',
2983: p_desc_segment1 => l_service_request_rec.request_attribute_1,
2984: p_desc_segment2 => l_service_request_rec.request_attribute_2,
2985: p_desc_segment3 => l_service_request_rec.request_attribute_3,
2986: p_desc_segment4 => l_service_request_rec.request_attribute_4,
6667: ,inc.external_attribute_14 ExtAttribute14
6668: ,inc.external_attribute_15 ExtAttribute15
6669: ,inc.external_context ExtContext
6670: from
6671: cs_incidents_all_b inc
6672: ,cs_incidents_all_tl tl
6673: ,hz_parties party
6674: ,cs_hz_sr_contact_points sr_cont
6675: ,hz_contact_points hzcp
6701: x_msg_data := null;
6702:
6703: IF (p_incident_id IS NULL) AND (p_incident_number IS NOT NULL) THEN
6704: select incident_id into l_incident_id
6705: from cs_incidents_all_b
6706: where incident_number = p_incident_number
6707: and rownum = 1;
6708: ELSE
6709: l_incident_id := p_incident_id;