[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;
3536: IF l_debug_level > 0 THEN
3537: oe_debug_pub.add( 'BEFORE VALIDATING ORIG_SYS_LINE_REF' ) ;
3538: END IF;
3539:
3540: IF OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL >= '110508' AND
3541: G_IMPORT_SHIPMENTS = 'YES' THEN
3542: IF p_x_line_tbl(I).orig_sys_line_ref = FND_API.G_MISS_CHAR AND
3543: p_x_line_tbl(I).orig_sys_shipment_ref = FND_API.G_MISS_CHAR
3544: THEN
3548: FND_MESSAGE.SET_NAME('ONT','OE_OI_ORIG_SYS_LINE_REF');
3549: OE_MSG_PUB.Add;
3550: p_return_status := FND_API.G_RET_STS_ERROR;
3551: END IF;
3552: ELSIF OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL >= '110508' AND
3553: G_IMPORT_SHIPMENTS = 'NO' THEN
3554: IF p_x_line_tbl(I).orig_sys_line_ref = FND_API.G_MISS_CHAR THEN
3555: IF l_debug_level > 0 THEN
3556: oe_debug_pub.add( 'INVALID ORIG_SYS_LINE_REF... ' ) ;
3558: FND_MESSAGE.SET_NAME('ONT','OE_OI_ORIG_SYS_LINE_REF');
3559: OE_MSG_PUB.Add;
3560: p_return_status := FND_API.G_RET_STS_ERROR;
3561: END IF;
3562: ELSIF OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL < '110508' THEN
3563: IF p_x_line_tbl(I).orig_sys_line_ref = FND_API.G_MISS_CHAR THEN
3564: IF l_debug_level > 0 THEN
3565: oe_debug_pub.add( 'INVALID ORIG_SYS_LINE_REF... ' ) ;
3566: END IF;
3885: AND p_x_header_rec.operation = 'UPDATE'
3886: THEN
3887: p_x_line_tbl(I).header_id := l_header_id;
3888:
3889: IF OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL >= '110508' AND
3890: G_IMPORT_SHIPMENTS = 'YES' THEN
3891:
3892: IF (p_x_line_tbl(I).split_from_line_ref IS NOT NULL) AND
3893: (p_x_line_tbl(I).split_from_line_ref <> FND_API.G_MISS_CHAR) AND
3964: FND_MESSAGE.SET_NAME('ONT','OE_OI_OPERATION_CODE');
3965: OE_MSG_PUB.Add;
3966: p_return_status := FND_API.G_RET_STS_ERROR;
3967: End;
3968: ELSIF OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL >= '110508' AND
3969: G_IMPORT_SHIPMENTS = 'NO' THEN
3970: IF (p_x_line_tbl(I).split_from_line_ref IS NOT NULL) AND
3971: (p_x_line_tbl(I).split_from_line_ref <> FND_API.G_MISS_CHAR)
3972: THEN
4037: FND_MESSAGE.SET_NAME('ONT','OE_OI_OPERATION_CODE');
4038: OE_MSG_PUB.Add;
4039: p_return_status := FND_API.G_RET_STS_ERROR;
4040: End;
4041: ELSIF OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL < '110508' THEN
4042: IF (p_x_line_tbl(I).split_from_line_ref IS NOT NULL) AND
4043: (p_x_line_tbl(I).split_from_line_ref <> FND_API.G_MISS_CHAR)
4044: THEN
4045: IF l_debug_level > 0 THEN
4122:
4123: END IF;
4124:
4125:
4126: IF OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL >= '110508' AND
4127: G_IMPORT_SHIPMENTS = 'YES' THEN
4128:
4129: IF l_debug_level > 0 THEN
4130: oe_debug_pub.add( 'G_IMPORT_SHIPMENTS WAS YES ' ) ;
4203: p_return_status := FND_API.G_RET_STS_ERROR;
4204: End;
4205: END IF;
4206:
4207: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110510' THEN
4208: IF p_x_line_tbl(I).order_source_id = OE_Acknowledgment_Pub.G_XML_ORDER_SOURCE_ID AND
4209: p_x_line_tbl(I).xml_transaction_type_code = OE_Acknowledgment_Pub.G_TRANSACTION_CHO AND
4210: l_cso_response_profile = 'Y' AND
4211: p_x_line_tbl(I).cso_response_flag = 'Y' AND