[Home] [Help]
116:
117: ELSE
118:
119: --Check if Ct is atleast on Patchset Level H
120: If OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL < '110508' Then
121: Return;
122: End If;
123:
124: IF l_debug_level > 0 THEN
2145:
2146: p_return_status := FND_API.G_RET_STS_SUCCESS; /* Init to Success */
2147:
2148:
2149: If OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL >= '110510' Then
2150: fnd_profile.get('ONT_INCLUDE_CUST_IN_OI_KEY', l_customer_key_profile);
2151: l_customer_key_profile := nvl(l_customer_key_profile, 'N');
2152:
2153: fnd_profile.get('ONT_3A7_RESPONSE_REQUIRED', l_cso_response_profile);
2241: Before Validating change sequence
2242: -----------------------------------------------------------
2243: */
2244:
2245: If OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL >= '110510' Then
2246:
2247: IF l_debug_level > 0 THEN
2248: oe_debug_pub.add( 'BEFORE VALIDATING CHANGE SEQUENCE' ) ;
2249: END IF;
3539: IF l_debug_level > 0 THEN
3540: oe_debug_pub.add( 'BEFORE VALIDATING ORIG_SYS_LINE_REF' ) ;
3541: END IF;
3542:
3543: IF OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL >= '110508' AND
3544: G_IMPORT_SHIPMENTS = 'YES' THEN
3545: IF p_x_line_tbl(I).orig_sys_line_ref = FND_API.G_MISS_CHAR AND
3546: p_x_line_tbl(I).orig_sys_shipment_ref = FND_API.G_MISS_CHAR
3547: THEN
3551: FND_MESSAGE.SET_NAME('ONT','OE_OI_ORIG_SYS_LINE_REF');
3552: OE_MSG_PUB.Add;
3553: p_return_status := FND_API.G_RET_STS_ERROR;
3554: END IF;
3555: ELSIF OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL >= '110508' AND
3556: G_IMPORT_SHIPMENTS = 'NO' THEN
3557: IF p_x_line_tbl(I).orig_sys_line_ref = FND_API.G_MISS_CHAR THEN
3558: IF l_debug_level > 0 THEN
3559: oe_debug_pub.add( 'INVALID ORIG_SYS_LINE_REF... ' ) ;
3561: FND_MESSAGE.SET_NAME('ONT','OE_OI_ORIG_SYS_LINE_REF');
3562: OE_MSG_PUB.Add;
3563: p_return_status := FND_API.G_RET_STS_ERROR;
3564: END IF;
3565: ELSIF OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL < '110508' THEN
3566: IF p_x_line_tbl(I).orig_sys_line_ref = FND_API.G_MISS_CHAR THEN
3567: IF l_debug_level > 0 THEN
3568: oe_debug_pub.add( 'INVALID ORIG_SYS_LINE_REF... ' ) ;
3569: END IF;
3888: AND p_x_header_rec.operation = 'UPDATE'
3889: THEN
3890: p_x_line_tbl(I).header_id := l_header_id;
3891:
3892: IF OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL >= '110508' AND
3893: G_IMPORT_SHIPMENTS = 'YES' THEN
3894:
3895: IF (p_x_line_tbl(I).split_from_line_ref IS NOT NULL) AND
3896: (p_x_line_tbl(I).split_from_line_ref <> FND_API.G_MISS_CHAR) AND
3967: FND_MESSAGE.SET_NAME('ONT','OE_OI_OPERATION_CODE');
3968: OE_MSG_PUB.Add;
3969: p_return_status := FND_API.G_RET_STS_ERROR;
3970: End;
3971: ELSIF OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL >= '110508' AND
3972: G_IMPORT_SHIPMENTS = 'NO' THEN
3973: IF (p_x_line_tbl(I).split_from_line_ref IS NOT NULL) AND
3974: (p_x_line_tbl(I).split_from_line_ref <> FND_API.G_MISS_CHAR)
3975: THEN
4040: FND_MESSAGE.SET_NAME('ONT','OE_OI_OPERATION_CODE');
4041: OE_MSG_PUB.Add;
4042: p_return_status := FND_API.G_RET_STS_ERROR;
4043: End;
4044: ELSIF OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL < '110508' THEN
4045: IF (p_x_line_tbl(I).split_from_line_ref IS NOT NULL) AND
4046: (p_x_line_tbl(I).split_from_line_ref <> FND_API.G_MISS_CHAR)
4047: THEN
4048: IF l_debug_level > 0 THEN
4125:
4126: END IF;
4127:
4128:
4129: IF OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL >= '110508' AND
4130: G_IMPORT_SHIPMENTS = 'YES' THEN
4131:
4132: IF l_debug_level > 0 THEN
4133: oe_debug_pub.add( 'G_IMPORT_SHIPMENTS WAS YES ' ) ;
4206: p_return_status := FND_API.G_RET_STS_ERROR;
4207: End;
4208: END IF;
4209:
4210: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110510' THEN
4211: IF p_x_line_tbl(I).order_source_id = OE_Acknowledgment_Pub.G_XML_ORDER_SOURCE_ID AND
4212: p_x_line_tbl(I).xml_transaction_type_code = OE_Acknowledgment_Pub.G_TRANSACTION_CHO AND
4213: l_cso_response_profile = 'Y' AND
4214: p_x_line_tbl(I).cso_response_flag = 'Y' AND