26: OE_DEBUG_PUB.Add('Entering OE_CNCL_VALIDATE_LINE.Check_Book_Reqd_Attributes',1);
27: -- Check for fields required on a booked order line
28:
29: IF p_line_rec.sold_to_org_id IS NULL THEN
30: x_return_status := FND_API.G_RET_STS_ERROR;
31: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
32: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
33: OE_Order_UTIL.Get_Attribute_Name('SOLD_TO_ORG_ID'));
34: OE_MSG_PUB.ADD;
34: OE_MSG_PUB.ADD;
35: END IF;
36:
37: IF p_line_rec.invoice_to_org_id IS NULL THEN
38: x_return_status := FND_API.G_RET_STS_ERROR;
39: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
40: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
41: OE_Order_UTIL.Get_Attribute_Name('INVOICE_TO_ORG_ID'));
42: OE_MSG_PUB.ADD;
42: OE_MSG_PUB.ADD;
43: END IF;
44:
45: IF p_line_rec.tax_exempt_flag IS NULL THEN
46: x_return_status := FND_API.G_RET_STS_ERROR;
47: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
48: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
49: OE_Order_UTIL.Get_Attribute_Name('TAX_EXEMPT_FLAG'));
50: OE_MSG_PUB.ADD;
52:
53:
54: -- Item, Quantity and UOM Required
55: IF p_line_rec.inventory_item_id IS NULL THEN
56: x_return_status := FND_API.G_RET_STS_ERROR;
57: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
58: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
59: OE_Order_UTIL.Get_Attribute_Name('INVENTORY_ITEM_ID'));
60: OE_MSG_PUB.ADD;
60: OE_MSG_PUB.ADD;
61: END IF;
62:
63: IF p_line_rec.order_quantity_uom IS NULL THEN
64: x_return_status := FND_API.G_RET_STS_ERROR;
65: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
66: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
67: OE_Order_UTIL.Get_Attribute_Name('ORDER_QUANTITY_UOM'));
68: OE_MSG_PUB.ADD;
70:
71: -- Fix bug 1277092: ordered quantity should not be = 0 on a booked line
72: IF p_line_rec.ordered_quantity IS NULL
73: OR p_line_rec.ordered_quantity = 0 THEN
74: x_return_status := FND_API.G_RET_STS_ERROR;
75: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
76: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
77: OE_Order_UTIL.Get_Attribute_Name('ORDERED_QUANTITY'));
78: OE_MSG_PUB.ADD;
92: AND l_item_type_code <> 'CONFIG')
93: THEN
94:
95: IF p_line_rec.price_list_id IS NULL THEN
96: x_return_status := FND_API.G_RET_STS_ERROR;
97: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
98: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
99: OE_Order_UTIL.Get_Attribute_Name('PRICE_LIST_ID'));
100: OE_MSG_PUB.ADD;
100: OE_MSG_PUB.ADD;
101: END IF;
102:
103: IF p_line_rec.unit_list_price IS NULL THEN
104: x_return_status := FND_API.G_RET_STS_ERROR;
105: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
106: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
107: OE_Order_UTIL.Get_Attribute_Name('UNIT_LIST_PRICE'));
108: OE_MSG_PUB.ADD;
108: OE_MSG_PUB.ADD;
109: END IF;
110:
111: IF p_line_rec.unit_selling_price IS NULL THEN
112: x_return_status := FND_API.G_RET_STS_ERROR;
113: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
114: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
115: OE_Order_UTIL.Get_Attribute_Name('UNIT_SELLING_PRICE'));
116: OE_MSG_PUB.ADD;
125:
126: IF p_line_rec.line_category_code <> OE_GLOBALS.G_RETURN_CATEGORY_CODE THEN
127:
128: IF p_line_rec.ship_to_org_id IS NULL THEN
129: x_return_status := FND_API.G_RET_STS_ERROR;
130: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
131: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
132: OE_Order_UTIL.Get_Attribute_Name('SHIP_TO_ORG_ID'));
133: OE_MSG_PUB.ADD;
133: OE_MSG_PUB.ADD;
134: END IF;
135:
136: IF p_line_rec.payment_term_id IS NULL THEN
137: x_return_status := FND_API.G_RET_STS_ERROR;
138: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
139: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
140: OE_Order_UTIL.Get_Attribute_Name('PAYMENT_TERM_ID'));
141: OE_MSG_PUB.ADD;
148:
149: IF p_line_rec.line_category_code = OE_GLOBALS.G_RETURN_CATEGORY_CODE THEN
150:
151: IF p_line_rec.ship_from_org_id IS NULL THEN
152: x_return_status := FND_API.G_RET_STS_ERROR;
153: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_RETURN_ATTRIBUTE');
154: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
155: OE_Order_UTIL.Get_Attribute_Name('SHIP_FROM_ORG_ID'));
156: OE_MSG_PUB.ADD;
156: OE_MSG_PUB.ADD;
157: END IF;
158:
159: IF p_line_rec.request_date IS NULL THEN
160: x_return_status := FND_API.G_RET_STS_ERROR;
161: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_RETURN_ATTRIBUTE');
162: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
163: OE_Order_UTIL.Get_Attribute_Name('REQUEST_DATE'));
164: OE_MSG_PUB.ADD;
169: /* Added by Manish */
170:
171: IF p_line_rec.tax_date IS NULL
172: THEN
173: x_return_status := FND_API.G_RET_STS_ERROR;
174: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_RETURN_ATTRIBUTE');
175: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
176: OE_Order_UTIL.Get_Attribute_Name('TAX_DATE'));
177: OE_MSG_PUB.ADD;
210: /* this validation no longer required
211: IF (l_line_type_rec.calculate_tax_flag = 'Y' OR p_line_rec.tax_exempt_flag = 'R')
212: AND p_line_rec.tax_code IS NULL
213: THEN
214: x_return_status := FND_API.G_RET_STS_ERROR;
215: FND_MESSAGE.SET_NAME('ONT','OE_VAL_TAX_CODE_REQD');
216: OE_MSG_PUB.ADD;
217: END IF;*/
218:
221:
222: -- Service Duration is required on SERVICE lines
223: IF l_item_type_code = 'SERVICE' THEN
224: IF p_line_rec.service_duration IS NULL THEN
225: x_return_status := FND_API.G_RET_STS_ERROR;
226: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_SERVICE_DURATION');
227: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
228: OE_Order_UTIL.Get_Attribute_Name('SERVICE_DURATION'));
229: OE_MSG_PUB.ADD;
237: p_line_rec.reference_line_id is not NULL AND
238: p_line_rec.cancelled_flag <> 'Y'
239: THEN
240: IF (OE_LINE_UTIL.Is_Over_Return(p_line_rec)) THEN
241: x_return_status := FND_API.G_RET_STS_ERROR;
242: FND_MESSAGE.Set_Name('ONT', 'OE_RETURN_INVALID_QUANTITY');
243: OE_MSG_PUB.ADD;
244: END IF;
245: END IF;
247: OE_DEBUG_PUB.Add('Entering OE_CNCL_VALIDATE_LINE.Check_Book_Reqd_Attributes',1);
248:
249: EXCEPTION
250: WHEN OTHERS THEN
251: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
252: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
253: THEN
254: OE_MSG_PUB.Add_Exc_Msg
255: ( G_PKG_NAME
293: BEGIN
294: OE_DEBUG_PUB.Add('Entering OE_CNCL_VALIDATE_LINE.Validate_Decimal_Quantity',1);
295: -- validate input quantity
296: IF (p_input_quantity is not null AND
297: p_input_quantity <> FND_API.G_MISS_NUM) THEN
298:
299: IF trunc(p_input_quantity) <> p_input_quantity THEN
300: oe_debug_pub.add('input quantity is decimal',2);
301:
305: 'CLASS','INCLUDED', 'CONFIG') THEN
306: oe_debug_pub.add('item is config related with decimal qty',2);
307: FND_MESSAGE.SET_NAME('ONT', 'OE_CONFIG_NO_DECIMALS');
308: OE_MSG_PUB.Add;
309: x_return_status := FND_API.G_RET_STS_ERROR;
310:
311: ELSE
312:
313: oe_debug_pub.add('before calling inv decimals api',2);
332: END IF;
333:
334: -- move INV error message to OE message stack
335: oe_msg_pub.add;
336: x_return_status := FND_API.G_RET_STS_ERROR;
337: END IF;
338:
339: END IF; -- config related item type
340: END IF; -- item_type_code is null
401: IF lexists IS NULL THEN
402: oe_debug_pub.add('No explicit assignment exists',2);
403: FND_MESSAGE.SET_NAME('ONT','OE_EXP_ASSIGN_REQ');
404: OE_MSG_PUB.ADD;
405: RAISE FND_API.G_EXC_ERROR;
406: END IF;
407:
408: END IF;
409:
411: EXCEPTION
412: WHEN NO_DATA_FOUND THEN
413: FND_MESSAGE.SET_NAME('ONT','OE_FLOW_CNT_CHANGE');
414: OE_MSG_PUB.ADD;
415: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
416: WHEN FND_API.G_EXC_ERROR THEN
417: RAISE FND_API.G_EXC_ERROR;
418:
419: WHEN OTHERS THEN
412: WHEN NO_DATA_FOUND THEN
413: FND_MESSAGE.SET_NAME('ONT','OE_FLOW_CNT_CHANGE');
414: OE_MSG_PUB.ADD;
415: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
416: WHEN FND_API.G_EXC_ERROR THEN
417: RAISE FND_API.G_EXC_ERROR;
418:
419: WHEN OTHERS THEN
420: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
413: FND_MESSAGE.SET_NAME('ONT','OE_FLOW_CNT_CHANGE');
414: OE_MSG_PUB.ADD;
415: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
416: WHEN FND_API.G_EXC_ERROR THEN
417: RAISE FND_API.G_EXC_ERROR;
418:
419: WHEN OTHERS THEN
420: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
421: THEN
423: ( G_PKG_NAME ,
424: 'Validate_Line_Type'
425: );
426: END IF;
427: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
428:
429:
430: END Validate_line_type;
431:
1043: oe_debug_pub.add('servie / part of smc model', 4);
1044: FND_MESSAGE.SET_NAME('ONT', 'OE_DS_NOT_VALID_ITEM');
1045: FND_MESSAGE.SET_TOKEN('ITEM', p_line_rec.ordered_item);
1046: OE_MSG_PUB.Add;
1047: x_return_status := FND_API.G_RET_STS_ERROR;
1048: RETURN;
1049: ELSE
1050: oe_debug_pub.add('validate line: pack H new logic DS', 1);
1051: END IF;
1053: IF (p_line_rec.item_type_code <> OE_GLOBALS.G_ITEM_STANDARD) THEN
1054: oe_debug_pub.add('Cannot dropship non-standard item',2);
1055: FND_MESSAGE.SET_NAME('ONT', 'OE_DS_NOT_ALLOWED');
1056: OE_MSG_PUB.Add;
1057: x_return_status := FND_API.G_RET_STS_ERROR;
1058: RETURN;
1059: END IF;
1060: END IF;
1061:
1065:
1066: oe_debug_pub.add('Cannot insert external line to set',2);
1067: FND_MESSAGE.SET_NAME('ONT', 'OE_DS_SET_INS_FAILED');
1068: OE_MSG_PUB.Add;
1069: x_return_status := FND_API.G_RET_STS_ERROR;
1070: RETURN;
1071: END IF;
1072:
1073:
1092: FND_MESSAGE.SET_TOKEN('ITEM', nvl(p_line_rec.ship_from_org_id,
1093: OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID')));
1094: FND_MESSAGE.SET_TOKEN('ORG', p_line_rec.ordered_item);
1095: OE_MSG_PUB.Add;
1096: x_return_status := FND_API.G_RET_STS_ERROR;
1097: END IF;
1098:
1099: END IF;
1100:
1117: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1118: , p_line_rec IN OE_Order_PUB.Line_Rec_Type
1119: )
1120: IS
1121: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1122: l_valid_line_number VARCHAR2(1) := 'Y';
1123: l_dummy VARCHAR2(10);
1124: l_uom VARCHAR2(3);
1125: l_uom_count NUMBER;
1234: oe_debug_pub.add('2 '||l_return_status, 1);
1235: IF p_line_rec.inventory_item_id IS NULL
1236: THEN
1237:
1238: l_return_status := FND_API.G_RET_STS_ERROR;
1239:
1240: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
1241: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1242: OE_Order_UTIL.Get_Attribute_Name('INVENTORY_ITEM_ID'));
1247: oe_debug_pub.add('3 '||l_return_status, 1);
1248: IF p_line_rec.line_type_id IS NULL
1249: THEN
1250:
1251: l_return_status := FND_API.G_RET_STS_ERROR;
1252:
1253: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
1254: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1255: OE_Order_UTIL.Get_Attribute_Name('LINE_TYPE_ID'));
1261: END IF;
1262:
1263: -- Return Error if a required attribute is missing.
1264:
1265: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1266:
1267: RAISE FND_API.G_EXC_ERROR;
1268:
1269: END IF;
1263: -- Return Error if a required attribute is missing.
1264:
1265: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1266:
1267: RAISE FND_API.G_EXC_ERROR;
1268:
1269: END IF;
1270:
1271:
1277: oe_debug_pub.add('5 '||l_return_status, 1);
1278: IF p_line_rec.line_category_code = OE_GLOBALS.G_RETURN_CATEGORY_CODE
1279: and p_line_rec.return_reason_code is NULL
1280: THEN
1281: l_return_status := FND_API.G_RET_STS_ERROR;
1282:
1283: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
1284: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1285: OE_Order_UTIL.Get_Attribute_Name('RETURN_REASON_CODE'));
1297: IF p_line_rec.source_type_code = 'INTERNAL' OR
1298: p_line_rec.source_type_code is null THEN
1299: oe_debug_pub.add('Entity Validateion: subinventory', 1);
1300: IF p_line_rec.ship_from_org_id is null THEN
1301: l_return_status := FND_API.G_RET_STS_ERROR;
1302: fnd_message.set_name('ONT', 'OE_ATTRIBUTE_REQUIRED');
1303: fnd_message.set_token('ATTRIBUTE',OE_Order_UTIL.Get_Attribute_Name('SHIP_FROM_ORG_ID'));
1304: OE_MSG_PUB.Add;
1305: END IF;
1303: fnd_message.set_token('ATTRIBUTE',OE_Order_UTIL.Get_Attribute_Name('SHIP_FROM_ORG_ID'));
1304: OE_MSG_PUB.Add;
1305: END IF;
1306: ELSE -- external
1307: l_return_status := FND_API.G_RET_STS_ERROR;
1308: fnd_message.set_name('ONT', 'OE_SUBINV_EXTERNAL');
1309: OE_MSG_PUB.Add;
1310: END IF;
1311: END IF;
1324: END IF;
1325:
1326: -- Return Error if a conditionally required attribute is missing.
1327:
1328: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1329:
1330: RAISE FND_API.G_EXC_ERROR;
1331:
1332: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1326: -- Return Error if a conditionally required attribute is missing.
1327:
1328: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1329:
1330: RAISE FND_API.G_EXC_ERROR;
1331:
1332: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1333:
1334: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1328: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1329:
1330: RAISE FND_API.G_EXC_ERROR;
1331:
1332: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1333:
1334: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1335:
1336: END IF;
1330: RAISE FND_API.G_EXC_ERROR;
1331:
1332: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1333:
1334: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1335:
1336: END IF;
1337:
1338:
1371: IF l_tracking_quantity_ind = 'PS' then
1372: -- IF l_item_rec.dualum_ind in (1,2,3) THEN INVCONV
1373: oe_debug_pub.add('Primary and Secondary X-VAL - tracking_quantity_ind PS', 2);
1374:
1375: IF (p_line_rec.ordered_quantity <> FND_API.G_MISS_NUM OR
1376: p_line_rec.ordered_quantity IS NOT NULL) AND
1377: (p_line_rec.ordered_quantity2 = FND_API.G_MISS_NUM OR
1378: p_line_rec.ordered_quantity2 IS NULL) THEN
1379:
1373: oe_debug_pub.add('Primary and Secondary X-VAL - tracking_quantity_ind PS', 2);
1374:
1375: IF (p_line_rec.ordered_quantity <> FND_API.G_MISS_NUM OR
1376: p_line_rec.ordered_quantity IS NOT NULL) AND
1377: (p_line_rec.ordered_quantity2 = FND_API.G_MISS_NUM OR
1378: p_line_rec.ordered_quantity2 IS NULL) THEN
1379:
1380: oe_debug_pub.add('Primary and Secondary X-VAL qty 1 not empty', 2);
1381:
1378: p_line_rec.ordered_quantity2 IS NULL) THEN
1379:
1380: oe_debug_pub.add('Primary and Secondary X-VAL qty 1 not empty', 2);
1381:
1382: l_return_status := FND_API.G_RET_STS_ERROR;
1383: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
1384: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Ordered_Quantity2');
1385: OE_MSG_PUB.Add;
1386:
1383: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
1384: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Ordered_Quantity2');
1385: OE_MSG_PUB.Add;
1386:
1387: ELSIF (p_line_rec.ordered_quantity2 <> FND_API.G_MISS_NUM OR
1388: p_line_rec.ordered_quantity2 IS NOT NULL) AND
1389: (p_line_rec.ordered_quantity IS NULL) THEN
1390:
1391: l_return_status := FND_API.G_RET_STS_ERROR;
1387: ELSIF (p_line_rec.ordered_quantity2 <> FND_API.G_MISS_NUM OR
1388: p_line_rec.ordered_quantity2 IS NOT NULL) AND
1389: (p_line_rec.ordered_quantity IS NULL) THEN
1390:
1391: l_return_status := FND_API.G_RET_STS_ERROR;
1392: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
1393: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Ordered_Quantity');
1394: OE_MSG_PUB.Add;
1395: END IF; -- IF (p_line_rec.ordered_quantity <> FND_API.G_MISS_NUM OR
1391: l_return_status := FND_API.G_RET_STS_ERROR;
1392: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
1393: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Ordered_Quantity');
1394: OE_MSG_PUB.Add;
1395: END IF; -- IF (p_line_rec.ordered_quantity <> FND_API.G_MISS_NUM OR
1396: END IF; -- IF l_item_rec.tracking_quantity_ind = 'PS' IF l_item_rec.dualum_ind in (1,2,3) THEN
1397:
1398: /* If qty1/qty2 both populated, check tolerances
1399: ================================================*/
1400: oe_debug_pub.add('Primary and Secondary X-VAL - tolerance check', 2);
1401:
1402: IF l_secondary_default_ind in ('N','D') then -- INVCONV
1403: -- IF l_item_rec.dualum_ind in (2,3) THEN
1404: IF (p_line_rec.ordered_quantity <> FND_API.G_MISS_NUM AND
1405: p_line_rec.ordered_quantity IS NOT NULL) AND
1406: (p_line_rec.ordered_quantity2 <> FND_API.G_MISS_NUM AND
1407: p_line_rec.ordered_quantity2 IS NOT NULL) THEN
1408:
1402: IF l_secondary_default_ind in ('N','D') then -- INVCONV
1403: -- IF l_item_rec.dualum_ind in (2,3) THEN
1404: IF (p_line_rec.ordered_quantity <> FND_API.G_MISS_NUM AND
1405: p_line_rec.ordered_quantity IS NOT NULL) AND
1406: (p_line_rec.ordered_quantity2 <> FND_API.G_MISS_NUM AND
1407: p_line_rec.ordered_quantity2 IS NOT NULL) THEN
1408:
1409: -- check the deviation and error out
1410: l_return := INV_CONVERT.Within_Deviation -- INVCONV
1429: oe_msg_pub.add_text(p_message_text => l_buffer);
1430: IF l_debug_level > 0 THEN
1431: oe_debug_pub.add(l_buffer,1);
1432: END IF;
1433: l_return_status := FND_API.G_RET_STS_ERROR;
1434:
1435: else
1436: IF l_debug_level > 0 THEN
1437: oe_debug_pub.add('Primary and Secondary X-VAL - No tolerance error ',1);
1457: ,l_item_rec.opm_item_um2
1458: ,0);
1459: -- OPM END 06/22
1460: IF(l_return = -68) THEN
1461: l_return_status := FND_API.G_RET_STS_ERROR;
1462: FND_MESSAGE.set_name('GMI', 'IC_DEVIATION_HI_ERR');
1463: OE_MSG_PUB.Add;
1464: ELSIF (l_return = -69) THEN
1465: l_return_status := FND_API.G_RET_STS_ERROR;
1461: l_return_status := FND_API.G_RET_STS_ERROR;
1462: FND_MESSAGE.set_name('GMI', 'IC_DEVIATION_HI_ERR');
1463: OE_MSG_PUB.Add;
1464: ELSIF (l_return = -69) THEN
1465: l_return_status := FND_API.G_RET_STS_ERROR;
1466: FND_MESSAGE.set_name('GMI', 'IC_DEVIATION_LO_ERR');
1467: OE_MSG_PUB.Add;
1468: END IF; */
1469:
1467: OE_MSG_PUB.Add;
1468: END IF; */
1469:
1470:
1471: END IF; -- IF (p_line_rec.ordered_quantity <> FND_API.G_MISS_NUM AND
1472:
1473:
1474: END IF; -- IF l_item_rec.tracking_quantity_ind = 'PS' IF l_item_rec.dualum_ind in (2,3) THEN INVCONV
1475:
1476: -- END IF; -- IF OE_Line_Util.Process_Characteristics INVCONV
1477:
1478: -- Return Error if a required quantity validation fails
1479: -- ====================================================
1480: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1481: RAISE FND_API.G_EXC_ERROR;
1482: END IF;
1483: -- OPM 02/JUN/00 END
1484: -- ===================
1477:
1478: -- Return Error if a required quantity validation fails
1479: -- ====================================================
1480: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1481: RAISE FND_API.G_EXC_ERROR;
1482: END IF;
1483: -- OPM 02/JUN/00 END
1484: -- ===================
1485:
1490:
1491: -- Validate if the warehouse, item combination is valid
1492: IF p_line_rec.inventory_item_id is not null AND
1493: p_line_rec.ship_from_org_id is not null AND
1494: p_line_rec.inventory_item_id <> FND_API.G_MISS_NUM AND
1495: p_line_rec.ship_from_org_id <> FND_API.G_MISS_NUM THEN
1496:
1497: /* IF p_line_rec.inventory_item_id <>
1498: nvl(p_old_line_rec.inventory_item_id,0) OR
1491: -- Validate if the warehouse, item combination is valid
1492: IF p_line_rec.inventory_item_id is not null AND
1493: p_line_rec.ship_from_org_id is not null AND
1494: p_line_rec.inventory_item_id <> FND_API.G_MISS_NUM AND
1495: p_line_rec.ship_from_org_id <> FND_API.G_MISS_NUM THEN
1496:
1497: /* IF p_line_rec.inventory_item_id <>
1498: nvl(p_old_line_rec.inventory_item_id,0) OR
1499: p_line_rec.ship_from_org_id <> nvl(p_old_line_rec.ship_from_org_id,0)
1520: l_item_type_code,
1521: p_line_rec.line_id,
1522: p_line_rec.top_model_line_id)
1523: THEN
1524: l_return_status := FND_API.G_RET_STS_ERROR;
1525: END IF;
1526: ELSE
1527: oe_debug_pub.add('Source Type is External',1);
1528: IF NOT Validate_Receiving_Org
1528: IF NOT Validate_Receiving_Org
1529: (p_line_rec.inventory_item_id,
1530: p_line_rec.ship_from_org_id)
1531: THEN
1532: l_return_status := FND_API.G_RET_STS_ERROR;
1533: END IF;
1534: END IF;
1535: --END IF;
1536: END IF;
1538: -- subinventory
1539:
1540: IF p_line_rec.ship_from_org_id is not null AND
1541: p_line_rec.subinventory is not null AND
1542: p_line_rec.ship_From_org_id <> FND_API.G_MISS_NUM AND
1543: p_line_rec.subinventory <> FND_API.G_MISS_CHAR THEN
1544:
1545: /* IF p_line_rec.ship_from_org_id <> nvl(p_old_line_rec.ship_from_org_id, 0) OR
1546: p_line_rec.subinventory <> nvl(p_old_line_rec.subinventory, '0') THEN
1539:
1540: IF p_line_rec.ship_from_org_id is not null AND
1541: p_line_rec.subinventory is not null AND
1542: p_line_rec.ship_From_org_id <> FND_API.G_MISS_NUM AND
1543: p_line_rec.subinventory <> FND_API.G_MISS_CHAR THEN
1544:
1545: /* IF p_line_rec.ship_from_org_id <> nvl(p_old_line_rec.ship_from_org_id, 0) OR
1546: p_line_rec.subinventory <> nvl(p_old_line_rec.subinventory, '0') THEN
1547: */
1553: AND secondary_inventory_name = p_line_rec.subinventory;
1554: EXCEPTION
1555: WHEN OTHERS THEN
1556: -- not a valid subinventory, show show a msg
1557: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1558: END;
1559: --END IF;
1560: END IF;
1561:
1649:
1650: IF (p_line_rec.reserved_quantity > p_line_rec.ordered_quantity) THEN
1651: fnd_message.set_name('ONT','OE_SCH_RES_MORE_ORD_QTY');
1652: OE_MSG_PUB.Add;
1653: l_return_status := FND_API.G_RET_STS_ERROR;
1654: END IF;
1655:
1656: END IF;*/
1657:
1674:
1675: IF p_line_rec.item_type_code <> OE_GLOBALS.G_ITEM_CONFIG THEN
1676: FND_MESSAGE.SET_NAME('ONT','OE_SCH_INVALID_CHANGE');
1677: OE_MSG_PUB.Add;
1678: l_return_status := FND_API.G_RET_STS_ERROR;
1679: END IF;
1680:
1681: END IF;
1682: */
1691:
1692: IF (p_line_rec.project_id IS NOT NULL
1693: AND p_line_rec.ship_from_org_id IS NULL) THEN
1694:
1695: l_return_status := FND_API.G_RET_STS_ERROR;
1696: FND_MESSAGE.SET_NAME('ONT', 'OE_SHIP_FROM_REQD');
1697: OE_MSG_PUB.add;
1698: ELSIF (p_line_rec.task_id IS NOT NULL
1699: AND p_line_rec.project_id IS NULL) THEN
1697: OE_MSG_PUB.add;
1698: ELSIF (p_line_rec.task_id IS NOT NULL
1699: AND p_line_rec.project_id IS NULL) THEN
1700:
1701: l_return_status := FND_API.G_RET_STS_ERROR;
1702: FND_MESSAGE.SET_NAME('ONT', 'OE_VAL_PROJECT_REQD');
1703: OE_MSG_PUB.add;
1704:
1705: END IF;
1744: END LOOP;
1745: END IF;
1746:
1747: IF result = PJM_PROJECT.G_VALIDATE_FAILURE THEN
1748: l_return_status := FND_API.G_RET_STS_ERROR;
1749: OE_DEBUG_PUB.Add('PJM Validation API returned with Errors',1);
1750: ELSIF result = PJM_PROJECT.G_VALIDATE_WARNING THEN
1751: OE_DEBUG_PUB.Add('PJM Validation API returned with Warnings',1);
1752: END IF;
1762: IF pjm_project.val_proj_idtonum
1763: (p_line_rec.project_id,
1764: p_line_rec.ship_from_org_id) IS NULL THEN
1765:
1766: l_return_status := FND_API.G_RET_STS_ERROR;
1767: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_SHIP_FROM_PROJ');
1768: OE_MSG_PUB.add;
1769: END IF;
1770:
1772:
1773: IF (p_line_rec.task_id IS NOT NULL
1774: AND p_line_rec.project_id IS NULL) THEN
1775:
1776: l_return_status := FND_API.G_RET_STS_ERROR;
1777: FND_MESSAGE.SET_NAME('ONT', 'OE_VAL_PROJECT_REQD');
1778: OE_MSG_PUB.add;
1779:
1780: ELSIF (p_line_rec.task_id is NOT NULL
1783: IF NOT Validate_task(
1784: p_line_rec.project_id,
1785: p_line_rec.task_id) THEN
1786:
1787: l_return_status := FND_API.G_RET_STS_ERROR;
1788: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'TASK_ID');
1789: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1790: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1791: OE_Order_Util.Get_Attribute_Name('task_id'));
1800: IF Validate_task_reqd(
1801: p_line_rec.project_id,
1802: p_line_rec.ship_from_org_id) THEN
1803:
1804: l_return_status := FND_API.G_RET_STS_ERROR;
1805: FND_MESSAGE.SET_NAME('ONT', 'OE_VAL_TASK_REQD');
1806: OE_MSG_PUB.ADD;
1807:
1808: END IF;
1820: IF PJM_UNIT_EFF.UNIT_EFFECTIVE_ITEM
1821: (p_line_rec.inventory_item_id,p_line_rec.ship_from_org_id) = 'Y'
1822: THEN
1823:
1824: l_return_status := FND_API.G_RET_STS_ERROR;
1825: fnd_message.set_name('ONT', 'OE_UEFF_NUMBER_REQD');
1826: OE_MSG_PUB.add;
1827: END IF;
1828:
1831:
1832: IF (p_line_rec.project_id IS NOT NULL OR
1833: p_line_rec.task_id IS NOT NULL OR
1834: p_line_rec.end_item_unit_number IS NOT NULL) THEN
1835: l_return_status := FND_API.G_RET_STS_ERROR;
1836: fnd_message.set_name('ONT', 'OE_PJM_NOT_INSTALLED');
1837: OE_MSG_PUB.add;
1838:
1839: END IF;
1873: , p_line_rec.item_identifier_type
1874: , p_line_rec.ordered_item
1875: , p_line_rec.sold_to_org_id)
1876: THEN
1877: l_return_status := FND_API.G_RET_STS_ERROR;
1878: fnd_message.set_name('ONT', 'OE_ITEM_VALIDATION_FAILED');
1879: OE_MSG_PUB.add;
1880: END IF;
1881:
1891: ( p_line_rec.reference_line_id
1892: , p_line_rec.inventory_item_id
1893: )
1894: THEN
1895: l_return_status := FND_API.G_RET_STS_ERROR;
1896: fnd_message.set_name('ONT', 'OE_RETURN_ITEM_MISMATCH_REJECT');
1897: OE_MSG_PUB.add;
1898: END IF;
1899: END IF;
1907: IF NOT Validate_Return_Fulfilled_Line
1908: ( p_line_rec.reference_line_id
1909: )
1910: THEN
1911: l_return_status := FND_API.G_RET_STS_ERROR;
1912: fnd_message.set_name('ONT', 'OE_UNFULFILLED_LINE_REJECT');
1913: OE_MSG_PUB.add;
1914: END IF;
1915:
1923: THEN
1924: IF NOT Validate_Return_Item(p_line_rec.inventory_item_id,
1925: p_line_rec.ship_from_org_id)
1926: THEN
1927: l_return_status := FND_API.G_RET_STS_ERROR;
1928: fnd_message.set_name('ONT', 'OE_ITEM_NOT_RETURNABLE');
1929: OE_MSG_PUB.add;
1930: END IF;
1931: END IF;
1939: THEN
1940: IF NOT Validate_Return_Reference(p_line_rec.reference_line_id)
1941: THEN
1942: -- Message is populated in the function
1943: l_return_status := FND_API.G_RET_STS_ERROR;
1944: END IF;
1945: END IF;
1946:
1947: oe_debug_pub.add('14_2 '||l_return_status, 1);
1951: p_line_rec.reference_line_id is not null and
1952: p_line_rec.return_context = 'SERIAL' and
1953: NVL(p_line_rec.ordered_quantity,1) <> 1)
1954: THEN
1955: l_return_status := FND_API.G_RET_STS_ERROR;
1956: fnd_message.set_name('ONT','OE_SERIAL_REFERENCED_RMA');
1957: OE_MSG_PUB.Add;
1958: END IF;
1959:
1967:
1968: IF NOT Validate_Ship_To_Org(p_line_rec.ship_to_org_id,
1969: p_line_rec.sold_to_org_id
1970: ) THEN
1971: l_return_status := FND_API.G_RET_STS_ERROR;
1972: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1973: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1974: OE_Order_Util.Get_Attribute_Name('ship_to_org_id'));
1975: OE_MSG_PUB.Add;
2003:
2004:
2005: EXCEPTION
2006: WHEN NO_DATA_FOUND THEN
2007: l_return_status := FND_API.G_RET_STS_ERROR;
2008: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
2009: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2010: OE_Order_Util.Get_Attribute_Name('ship_to_contact_id'));
2011: OE_MSG_PUB.Add;
2015: ( G_PKG_NAME ,
2016: 'Record - Ship To Contact validation '
2017: );
2018: END IF;
2019: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2020: END;
2021:
2022: END IF;
2023:
2029:
2030: IF NOT Validate_Deliver_To_Org(p_line_rec.deliver_to_org_id,
2031: p_line_rec.sold_to_org_id
2032: ) THEN
2033: l_return_status := FND_API.G_RET_STS_ERROR;
2034: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2035: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2036: OE_Order_Util.Get_Attribute_Name('deliver_to_org_id'));
2037: OE_MSG_PUB.Add;
2064:
2065:
2066: EXCEPTION
2067: WHEN NO_DATA_FOUND THEN
2068: l_return_status := FND_API.G_RET_STS_ERROR;
2069: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
2070: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2071: OE_Order_Util.Get_Attribute_Name('deliver_to_contact_id'));
2072: OE_MSG_PUB.Add;
2076: ( G_PKG_NAME ,
2077: 'Record - Deliver To Contact validation '
2078: );
2079: END IF;
2080: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2081: END;
2082:
2083: END IF;
2084:
2140: END IF;
2141:
2142: EXCEPTION
2143: WHEN NO_DATA_FOUND THEN
2144: l_return_status := FND_API.G_RET_STS_ERROR;
2145: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
2146: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2147: OE_Order_Util.Get_Attribute_Name('invoice_to_org_id'));
2148: OE_MSG_PUB.Add;
2152: ( G_PKG_NAME ,
2153: 'Record - Invoice To Org validation '
2154: );
2155: END IF;
2156: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2157: END;
2158:
2159: END IF;
2160:
2182:
2183:
2184: EXCEPTION
2185: WHEN NO_DATA_FOUND THEN
2186: l_return_status := FND_API.G_RET_STS_ERROR;
2187: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
2188: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2189: OE_Order_Util.Get_Attribute_Name('invoice_to_contact_id'));
2190: OE_MSG_PUB.Add;
2194: ( G_PKG_NAME ,
2195: 'Record - Invoice To Contact validation '
2196: );
2197: END IF;
2198: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2199: END;
2200:
2201: END IF;
2202:
2247:
2248: EXCEPTION
2249:
2250: WHEN NO_DATA_FOUND THEN
2251: l_return_status := FND_API.G_RET_STS_ERROR;
2252: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
2253: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2254: OE_Order_Util.Get_Attribute_Name('TAX_CODE'));
2255: OE_MSG_PUB.Add;
2262: ( G_PKG_NAME ,
2263: 'Record - Tax Code validation '
2264: );
2265: END IF;
2266: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2267:
2268: END; -- BEGIN
2269: END IF;
2270:
2274: THEN
2275: -- Check for Tax exempt reason
2276: IF p_line_rec.tax_exempt_reason_code IS NULL
2277: THEN
2278: l_return_status := FND_API.G_RET_STS_ERROR;
2279: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_ERROR)
2280: THEN
2281: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
2282: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2296: IF p_line_rec.tax_exempt_flag = 'R' AND
2297: (p_line_rec.tax_exempt_number IS NOT NULL OR
2298: p_line_rec.tax_exempt_reason_code IS NOT NULL)
2299: THEN
2300: l_return_status := FND_API.G_RET_STS_ERROR;
2301: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_ERROR)
2302: THEN
2303: fnd_message.set_name('ONT','OE_TAX_EXEMPTION_NOT_ALLOWED');
2304: OE_MSG_PUB.Add;
2385: EXCEPTION
2386:
2387: WHEN NO_DATA_FOUND THEN
2388:
2389: l_return_status := FND_API.G_RET_STS_ERROR;
2390:
2391: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2392: THEN
2393: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2404: ( G_PKG_NAME ,
2405: 'Record - Tax Exemptions '
2406: );
2407: END IF;
2408: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2409:
2410: END; -- BEGIN
2411:
2412: END IF; -- Tax exempton info validation.
2439: fnd_message.set_name('ONT','OE_INVALID_ORDER_QUANTITY_UOM');
2440: fnd_message.set_token('ITEM',p_line_rec.ordered_item );
2441: fnd_message.set_token('UOM', l_uom);
2442: OE_MSG_PUB.Add;
2443: RAISE FND_API.G_EXC_ERROR;
2444: END IF;
2445: EXCEPTION
2446: when no_data_found then
2447: oe_debug_pub.add('OEXLLINB, no_data_found in uom validation', 1);
2444: END IF;
2445: EXCEPTION
2446: when no_data_found then
2447: oe_debug_pub.add('OEXLLINB, no_data_found in uom validation', 1);
2448: RAISE FND_API.G_EXC_ERROR;
2449: END;
2450:
2451: ELSE -- not ato related, validate item, uom combination
2452: /* commenting for 8993157
2462: IF l_uom_count = 0 THEN
2463: oe_debug_pub.add('uom/item combination invalid',2);
2464: fnd_message.set_name('ONT', 'OE_INVALID_ITEM_UOM');
2465: OE_MSG_PUB.Add;
2466: RAISE FND_API.G_EXC_ERROR;
2467: END IF;
2468: */
2469:
2470: l_ret_status :=
2478: end if;
2479:
2480: fnd_message.set_name('ONT', 'OE_INVALID_ITEM_UOM');
2481: OE_MSG_PUB.Add;
2482: RAISE FND_API.G_EXC_ERROR;
2483: END IF;
2484:
2485:
2486: END IF;
2486: END IF;
2487: END IF;
2488:
2489: If p_line_rec.agreement_id is not null and
2490: NOT OE_GLOBALS.EQUAL(p_line_rec.agreement_id, fnd_api.g_miss_num) then
2491: If not oe_globals.equal(p_line_rec.agreement_id,null) then
2492:
2493: -- Check for Agreement +sold_org_id
2494:
2543: END;
2544: fnd_message.set_Token('PRICE_LIST2', l_price_list_name);
2545: OE_MSG_PUB.Add;
2546: oe_debug_pub.add('Invalid Agreement +price_list_id combination',2);
2547: raise FND_API.G_EXC_ERROR;
2548: END IF;
2549: END IF; -- end of if l_list_type_code <> 'PRL'
2550:
2551:
2558: fnd_message.set_Token('AGREEMENT_NAME', l_agreement_name);
2559: fnd_message.set_Token('CUSTOMER_ID', p_line_rec.sold_to_org_id);
2560: OE_MSG_PUB.Add;
2561: oe_debug_pub.add('Invalid Agreement +sold_org_id combination',2);
2562: RAISE FND_API.G_EXC_ERROR;
2563: ELSIF lcustomer_relations = 'Y' THEN
2564:
2565: BEGIN
2566: SELECT 'VALID'
2584: fnd_message.set_Token('AGREEMENT_NAME', l_agreement_name);
2585: fnd_message.set_Token('CUSTOMER_ID', p_line_rec.sold_to_org_id);
2586: OE_MSG_PUB.Add;
2587: oe_debug_pub.add('Invalid Agreement +sold_org_id combination',2);
2588: RAISE FND_API.G_EXC_ERROR;
2589: END;
2590: END IF;
2591: END IF;
2592:
2598: fnd_message.set_Token('AGREEMENT_NAME', l_agreement_name);
2599: fnd_message.set_Token('CUSTOMER_ID', l_sold_to_org);
2600: OE_MSG_PUB.Add;
2601: oe_debug_pub.add('Invalid Agreement +sold_org_id combination',2);
2602: RAISE FND_API.G_EXC_ERROR;
2603: END;
2604: END IF; -- Agreement has changed
2605:
2606: ELSE
2627: fnd_message.set_Token('PRICE_LIST1', p_line_rec.price_list_id);
2628: fnd_message.set_Token('PRICING_DATE', p_line_rec.pricing_date);
2629: OE_MSG_PUB.Add;
2630: oe_debug_pub.add('Invalid non agreement price list ',2);
2631: RAISE FND_API.G_EXC_ERROR;
2632: END;
2633:
2634: --END IF; -- Price list or pricing date has changed
2635: END IF;
2646: (p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CLASS) OR
2647: (p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_KIT) OR
2648: (p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_SERVICE AND
2649: p_line_rec.service_reference_line_id IS NOT NULL AND
2650: p_line_rec.service_reference_line_id <> FND_API.G_MISS_NUM)
2651:
2652: THEN
2653:
2654: IF (NOT OE_GLOBALS.EQUAL(p_line_rec.line_number,null)) THEN
2652: THEN
2653:
2654: IF (NOT OE_GLOBALS.EQUAL(p_line_rec.line_number,null)) THEN
2655:
2656: l_return_status := FND_API.G_RET_STS_ERROR;
2657: fnd_message.set_name('ONT', 'OE_LINE_NUMBER_UPD');
2658: OE_MSG_PUB.add;
2659:
2660: END IF;
2688: p_line_rec.ordered_quantity > 1 then
2689:
2690: oe_debug_pub.add('Ordered Qty cannot be greater than 1 for OTA lines',
2691: 1);
2692: l_return_status := FND_API.G_RET_STS_ERROR;
2693: FND_Message.Set_Name('ONT', 'OE_OTA_INVALID_QTY');
2694: oe_msg_pub.add;
2695: END IF;
2696:
2718:
2719: -- Fix for bug#1411346:
2720: -- SERVICE end date must be after service start date.
2721:
2722: IF (p_line_rec.service_end_date <> FND_API.G_MISS_DATE OR
2723: p_line_rec.service_end_date IS NOT NULL) AND
2724: (p_line_rec.service_start_date <> FND_API.G_MISS_DATE OR
2725: p_line_rec.service_start_date IS NOT NULL) THEN
2726:
2720: -- SERVICE end date must be after service start date.
2721:
2722: IF (p_line_rec.service_end_date <> FND_API.G_MISS_DATE OR
2723: p_line_rec.service_end_date IS NOT NULL) AND
2724: (p_line_rec.service_start_date <> FND_API.G_MISS_DATE OR
2725: p_line_rec.service_start_date IS NOT NULL) THEN
2726:
2727: IF (p_line_rec.service_end_date <= p_line_rec.service_start_date)
2728: THEN
2725: p_line_rec.service_start_date IS NOT NULL) THEN
2726:
2727: IF (p_line_rec.service_end_date <= p_line_rec.service_start_date)
2728: THEN
2729: l_return_status := FND_API.G_RET_STS_ERROR;
2730: fnd_message.set_name('ONT','OE_SERV_END_DATE');
2731: OE_MSG_PUB.Add;
2732: END IF;
2733:
2739: -- Done validating entity
2740: oe_debug_pub.add('Exit OE_CNCL_VALIDATE_LINE.ENTITY',1);
2741: EXCEPTION
2742:
2743: WHEN FND_API.G_EXC_ERROR THEN
2744:
2745: x_return_status := FND_API.G_RET_STS_ERROR;
2746:
2747: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2741: EXCEPTION
2742:
2743: WHEN FND_API.G_EXC_ERROR THEN
2744:
2745: x_return_status := FND_API.G_RET_STS_ERROR;
2746:
2747: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2748:
2749: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2743: WHEN FND_API.G_EXC_ERROR THEN
2744:
2745: x_return_status := FND_API.G_RET_STS_ERROR;
2746:
2747: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2748:
2749: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2750:
2751: WHEN OTHERS THEN
2745: x_return_status := FND_API.G_RET_STS_ERROR;
2746:
2747: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2748:
2749: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2750:
2751: WHEN OTHERS THEN
2752:
2753: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2749: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2750:
2751: WHEN OTHERS THEN
2752:
2753: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2754:
2755: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2756: THEN
2757: OE_MSG_PUB.Add_Exc_Msg
2766:
2767: PROCEDURE Attributes
2768: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2769: , p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
2770: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
2771: )
2772: IS
2773: l_return_status VARCHAR2(1);
2774: l_line_rec OE_Order_PUB.Line_Rec_Type := OE_Order_PUB.G_MISS_LINE_REC;
2775: l_type_code VARCHAR2(30);
2776: BEGIN
2777: oe_debug_pub.add('Enter procedure OE_CNCL_VALIDATE_line.Attributes',1);
2778:
2779: x_return_status := FND_API.G_RET_STS_SUCCESS;
2780: l_return_status := FND_API.G_RET_STS_SUCCESS;
2781:
2782: -- validate Sales Agreements Attributes
2783: IF p_x_line_rec.blanket_number IS NOT NULL
2776: BEGIN
2777: oe_debug_pub.add('Enter procedure OE_CNCL_VALIDATE_line.Attributes',1);
2778:
2779: x_return_status := FND_API.G_RET_STS_SUCCESS;
2780: l_return_status := FND_API.G_RET_STS_SUCCESS;
2781:
2782: -- validate Sales Agreements Attributes
2783: IF p_x_line_rec.blanket_number IS NOT NULL
2784: and p_x_line_rec.blanket_line_number is NOT NULL
2782: -- validate Sales Agreements Attributes
2783: IF p_x_line_rec.blanket_number IS NOT NULL
2784: and p_x_line_rec.blanket_line_number is NOT NULL
2785: THEN
2786: x_return_status := FND_API.G_RET_STS_ERROR;
2787: fnd_message.set_name('ONT', 'OE_BLKT_DISALLOW_CLOSE_REL');
2788: OE_MSG_PUB.add;
2789: END IF;
2790:
2795: IF NOT OE_CNCL_Validate.Accounting_Rule(p_x_line_rec.accounting_rule_id) THEN
2796: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
2797: p_x_line_rec.accounting_rule_id := NULL;
2798: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
2799: p_x_line_rec.accounting_rule_id := FND_API.G_MISS_NUM;
2800: ELSE
2801: x_return_status := FND_API.G_RET_STS_ERROR;
2802: END IF;
2803: END IF;
2797: p_x_line_rec.accounting_rule_id := NULL;
2798: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
2799: p_x_line_rec.accounting_rule_id := FND_API.G_MISS_NUM;
2800: ELSE
2801: x_return_status := FND_API.G_RET_STS_ERROR;
2802: END IF;
2803: END IF;
2804: END IF;
2805:
2808: IF NOT OE_CNCL_Validate.Agreement(p_x_line_rec.agreement_id) THEN
2809: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
2810: p_x_line_rec.agreement_id := NULL;
2811: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
2812: p_x_line_rec.agreement_id := FND_API.G_MISS_NUM;
2813: ELSE
2814: x_return_status := FND_API.G_RET_STS_ERROR;
2815: END IF;
2816: END IF;
2810: p_x_line_rec.agreement_id := NULL;
2811: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
2812: p_x_line_rec.agreement_id := FND_API.G_MISS_NUM;
2813: ELSE
2814: x_return_status := FND_API.G_RET_STS_ERROR;
2815: END IF;
2816: END IF;
2817: END IF;
2818:
2822: IF NOT OE_CNCL_Validate.Deliver_To_Contact(p_x_line_rec.deliver_to_contact_id) THEN
2823: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
2824: p_x_line_rec.deliver_to_contact_id := NULL;
2825: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
2826: p_x_line_rec.deliver_to_contact_id := FND_API.G_MISS_NUM;
2827: ELSE
2828: x_return_status := FND_API.G_RET_STS_ERROR;
2829: END IF;
2830: END IF;
2824: p_x_line_rec.deliver_to_contact_id := NULL;
2825: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
2826: p_x_line_rec.deliver_to_contact_id := FND_API.G_MISS_NUM;
2827: ELSE
2828: x_return_status := FND_API.G_RET_STS_ERROR;
2829: END IF;
2830: END IF;
2831: END IF;
2832:
2835: IF NOT OE_CNCL_Validate.Deliver_To_Org(p_x_line_rec.deliver_to_org_id) THEN
2836: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
2837: p_x_line_rec.deliver_to_org_id := NULL;
2838: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
2839: p_x_line_rec.deliver_to_org_id := FND_API.G_MISS_NUM;
2840: ELSE
2841: x_return_status := FND_API.G_RET_STS_ERROR;
2842: END IF;
2843: END IF;
2837: p_x_line_rec.deliver_to_org_id := NULL;
2838: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
2839: p_x_line_rec.deliver_to_org_id := FND_API.G_MISS_NUM;
2840: ELSE
2841: x_return_status := FND_API.G_RET_STS_ERROR;
2842: END IF;
2843: END IF;
2844: END IF;
2845:
2848: IF NOT OE_CNCL_Validate.Demand_Class(p_x_line_rec.demand_class_code) THEN
2849: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
2850: p_x_line_rec.demand_class_code := NULL;
2851: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
2852: p_x_line_rec.demand_class_code := FND_API.G_MISS_CHAR;
2853: ELSE
2854: x_return_status := FND_API.G_RET_STS_ERROR;
2855: END IF;
2856: END IF;
2850: p_x_line_rec.demand_class_code := NULL;
2851: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
2852: p_x_line_rec.demand_class_code := FND_API.G_MISS_CHAR;
2853: ELSE
2854: x_return_status := FND_API.G_RET_STS_ERROR;
2855: END IF;
2856: END IF;
2857: END IF;
2858:
2861: IF NOT OE_CNCL_Validate.Dep_Plan_Required(p_x_line_rec.dep_plan_required_flag) THEN
2862: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
2863: p_x_line_rec.dep_plan_required_flag := NULL;
2864: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
2865: p_x_line_rec.dep_plan_required_flag := FND_API.G_MISS_CHAR;
2866: ELSE
2867: x_return_status := FND_API.G_RET_STS_ERROR;
2868: END IF;
2869: END IF;
2863: p_x_line_rec.dep_plan_required_flag := NULL;
2864: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
2865: p_x_line_rec.dep_plan_required_flag := FND_API.G_MISS_CHAR;
2866: ELSE
2867: x_return_status := FND_API.G_RET_STS_ERROR;
2868: END IF;
2869: END IF;
2870: END IF;
2871:
2874: IF NOT OE_CNCL_Validate.End_Item_Unit_Number(p_x_line_rec.end_item_unit_number) THEN
2875: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
2876: p_x_line_rec.end_item_unit_number := NULL;
2877: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
2878: p_x_line_rec.end_item_unit_number := FND_API.G_MISS_CHAR;
2879: ELSE
2880: x_return_status := FND_API.G_RET_STS_ERROR;
2881: END IF;
2882: END IF;
2876: p_x_line_rec.end_item_unit_number := NULL;
2877: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
2878: p_x_line_rec.end_item_unit_number := FND_API.G_MISS_CHAR;
2879: ELSE
2880: x_return_status := FND_API.G_RET_STS_ERROR;
2881: END IF;
2882: END IF;
2883: END IF;
2884:
2887: IF NOT OE_CNCL_Validate.Fob_Point(p_x_line_rec.fob_point_code) THEN
2888: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
2889: p_x_line_rec.fob_point_code := NULL;
2890: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
2891: p_x_line_rec.fob_point_code := FND_API.G_MISS_CHAR;
2892: ELSE
2893: x_return_status := FND_API.G_RET_STS_ERROR;
2894: END IF;
2895: END IF;
2889: p_x_line_rec.fob_point_code := NULL;
2890: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
2891: p_x_line_rec.fob_point_code := FND_API.G_MISS_CHAR;
2892: ELSE
2893: x_return_status := FND_API.G_RET_STS_ERROR;
2894: END IF;
2895: END IF;
2896: END IF;
2897:
2900: IF NOT OE_CNCL_Validate.Freight_Terms(p_x_line_rec.freight_terms_code) THEN
2901: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
2902: p_x_line_rec.freight_terms_code := NULL;
2903: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
2904: p_x_line_rec.freight_terms_code := FND_API.G_MISS_CHAR;
2905: ELSE
2906: x_return_status := FND_API.G_RET_STS_ERROR;
2907: END IF;
2908: END IF;
2902: p_x_line_rec.freight_terms_code := NULL;
2903: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
2904: p_x_line_rec.freight_terms_code := FND_API.G_MISS_CHAR;
2905: ELSE
2906: x_return_status := FND_API.G_RET_STS_ERROR;
2907: END IF;
2908: END IF;
2909: END IF;
2910:
2913: IF NOT OE_CNCL_Validate.Invoice_To_Contact(p_x_line_rec.invoice_to_contact_id) THEN
2914: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
2915: p_x_line_rec.invoice_to_contact_id := NULL;
2916: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
2917: p_x_line_rec.invoice_to_contact_id := FND_API.G_MISS_NUM;
2918: ELSE
2919: x_return_status := FND_API.G_RET_STS_ERROR;
2920: END IF;
2921: END IF;
2915: p_x_line_rec.invoice_to_contact_id := NULL;
2916: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
2917: p_x_line_rec.invoice_to_contact_id := FND_API.G_MISS_NUM;
2918: ELSE
2919: x_return_status := FND_API.G_RET_STS_ERROR;
2920: END IF;
2921: END IF;
2922: END IF;
2923:
2926: IF NOT OE_CNCL_Validate.Invoice_To_Org(p_x_line_rec.invoice_to_org_id) THEN
2927: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
2928: p_x_line_rec.invoice_to_org_id := NULL;
2929: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
2930: p_x_line_rec.invoice_to_org_id := FND_API.G_MISS_NUM;
2931: ELSE
2932: x_return_status := FND_API.G_RET_STS_ERROR;
2933: END IF;
2934: END IF;
2928: p_x_line_rec.invoice_to_org_id := NULL;
2929: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
2930: p_x_line_rec.invoice_to_org_id := FND_API.G_MISS_NUM;
2931: ELSE
2932: x_return_status := FND_API.G_RET_STS_ERROR;
2933: END IF;
2934: END IF;
2935: END IF;
2936:
2939: IF NOT OE_CNCL_Validate.Invoicing_Rule(p_x_line_rec.invoicing_rule_id) THEN
2940: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
2941: p_x_line_rec.invoicing_rule_id := NULL;
2942: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
2943: p_x_line_rec.invoicing_rule_id := FND_API.G_MISS_NUM;
2944: ELSE
2945: x_return_status := FND_API.G_RET_STS_ERROR;
2946: END IF;
2947: END IF;
2941: p_x_line_rec.invoicing_rule_id := NULL;
2942: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
2943: p_x_line_rec.invoicing_rule_id := FND_API.G_MISS_NUM;
2944: ELSE
2945: x_return_status := FND_API.G_RET_STS_ERROR;
2946: END IF;
2947: END IF;
2948: END IF;
2949:
2955: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
2956: p_x_line_rec.Ib_owner := NULL;
2957: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF
2958: THEN
2959: p_x_line_rec.Ib_Owner := FND_API.G_MISS_CHAR;
2960: ELSE
2961: x_return_status := FND_API.G_RET_STS_ERROR;
2962: END IF;
2963: END IF;
2957: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF
2958: THEN
2959: p_x_line_rec.Ib_Owner := FND_API.G_MISS_CHAR;
2960: ELSE
2961: x_return_status := FND_API.G_RET_STS_ERROR;
2962: END IF;
2963: END IF;
2964: END IF;
2965:
2970: THEN
2971: p_x_line_rec.Ib_installed_at_location := NULL;
2972: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF
2973: THEN
2974: p_x_line_rec.Ib_installed_at_location := FND_API.G_MISS_CHAR;
2975: ELSE
2976: x_return_status := FND_API.G_RET_STS_ERROR;
2977: END IF;
2978: END IF;
2972: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF
2973: THEN
2974: p_x_line_rec.Ib_installed_at_location := FND_API.G_MISS_CHAR;
2975: ELSE
2976: x_return_status := FND_API.G_RET_STS_ERROR;
2977: END IF;
2978: END IF;
2979:
2980: END IF;
2987: THEN
2988: p_x_line_rec.Ib_current_location := NULL;
2989: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF
2990: THEN
2991: p_x_line_rec.Ib_current_location := FND_API.G_MISS_CHAR;
2992: ELSE
2993: x_return_status := FND_API.G_RET_STS_ERROR;
2994: END IF;
2995: END IF;
2989: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF
2990: THEN
2991: p_x_line_rec.Ib_current_location := FND_API.G_MISS_CHAR;
2992: ELSE
2993: x_return_status := FND_API.G_RET_STS_ERROR;
2994: END IF;
2995: END IF;
2996: END IF;
2997:
3003: THEN
3004: p_x_line_rec.End_customer_id := NULL;
3005: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF
3006: THEN
3007: p_x_line_rec.End_customer_id := FND_API.G_MISS_NUM;
3008: ELSE
3009: x_return_status := FND_API.G_RET_STS_ERROR;
3010: END IF;
3011: END IF;
3005: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF
3006: THEN
3007: p_x_line_rec.End_customer_id := FND_API.G_MISS_NUM;
3008: ELSE
3009: x_return_status := FND_API.G_RET_STS_ERROR;
3010: END IF;
3011: END IF;
3012:
3013: END IF;
3021: THEN
3022: p_x_line_rec.End_customer_contact_id := NULL;
3023: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF
3024: THEN
3025: p_x_line_rec.End_customer_contact_id := FND_API.G_MISS_NUM;
3026: ELSE
3027: x_return_status := FND_API.G_RET_STS_ERROR;
3028: END IF;
3029: END IF;
3023: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF
3024: THEN
3025: p_x_line_rec.End_customer_contact_id := FND_API.G_MISS_NUM;
3026: ELSE
3027: x_return_status := FND_API.G_RET_STS_ERROR;
3028: END IF;
3029: END IF;
3030: END IF;
3031:
3036: THEN
3037: p_x_line_rec.End_customer_site_use_id := NULL;
3038: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF
3039: THEN
3040: p_x_line_rec.End_customer_site_use_id := FND_API.G_MISS_NUM;
3041: ELSE
3042: x_return_status := FND_API.G_RET_STS_ERROR;
3043: END IF;
3044: END IF;
3038: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF
3039: THEN
3040: p_x_line_rec.End_customer_site_use_id := FND_API.G_MISS_NUM;
3041: ELSE
3042: x_return_status := FND_API.G_RET_STS_ERROR;
3043: END IF;
3044: END IF;
3045: END IF;
3046: -- bug 4240715}
3050: IF NOT OE_CNCL_Validate.Item_Type(p_x_line_rec.item_type_code) THEN
3051: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3052: p_x_line_rec.item_type_code := NULL;
3053: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3054: p_x_line_rec.item_type_code := FND_API.G_MISS_CHAR;
3055: ELSE
3056: x_return_status := FND_API.G_RET_STS_ERROR;
3057: END IF;
3058: END IF;
3052: p_x_line_rec.item_type_code := NULL;
3053: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3054: p_x_line_rec.item_type_code := FND_API.G_MISS_CHAR;
3055: ELSE
3056: x_return_status := FND_API.G_RET_STS_ERROR;
3057: END IF;
3058: END IF;
3059: END IF;
3060:
3063: IF NOT OE_CNCL_Validate.Payment_Term(p_x_line_rec.payment_term_id) THEN
3064: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3065: p_x_line_rec.payment_term_id := NULL;
3066: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3067: p_x_line_rec.payment_term_id := FND_API.G_MISS_NUM;
3068: ELSE
3069: x_return_status := FND_API.G_RET_STS_ERROR;
3070: END IF;
3071: END IF;
3065: p_x_line_rec.payment_term_id := NULL;
3066: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3067: p_x_line_rec.payment_term_id := FND_API.G_MISS_NUM;
3068: ELSE
3069: x_return_status := FND_API.G_RET_STS_ERROR;
3070: END IF;
3071: END IF;
3072: END IF;
3073:
3076: IF NOT OE_CNCL_Validate.Price_List(p_x_line_rec.price_list_id) THEN
3077: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3078: p_x_line_rec.price_list_id := NULL;
3079: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3080: p_x_line_rec.price_list_id := FND_API.G_MISS_NUM;
3081: ELSE
3082: x_return_status := FND_API.G_RET_STS_ERROR;
3083: END IF;
3084: END IF;
3078: p_x_line_rec.price_list_id := NULL;
3079: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3080: p_x_line_rec.price_list_id := FND_API.G_MISS_NUM;
3081: ELSE
3082: x_return_status := FND_API.G_RET_STS_ERROR;
3083: END IF;
3084: END IF;
3085: END IF;
3086:
3089: IF NOT OE_CNCL_Validate.Project(p_x_line_rec.project_id) THEN
3090: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3091: p_x_line_rec.project_id := NULL;
3092: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3093: p_x_line_rec.project_id := FND_API.G_MISS_NUM;
3094: ELSE
3095: x_return_status := FND_API.G_RET_STS_ERROR;
3096: END IF;
3097: END IF;
3091: p_x_line_rec.project_id := NULL;
3092: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3093: p_x_line_rec.project_id := FND_API.G_MISS_NUM;
3094: ELSE
3095: x_return_status := FND_API.G_RET_STS_ERROR;
3096: END IF;
3097: END IF;
3098: END IF;
3099:
3102: IF NOT OE_CNCL_Validate.Shipment_Priority(p_x_line_rec.shipment_priority_code) THEN
3103: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3104: p_x_line_rec.shipment_priority_code := NULL;
3105: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3106: p_x_line_rec.shipment_priority_code := FND_API.G_MISS_CHAR;
3107: ELSE
3108: x_return_status := FND_API.G_RET_STS_ERROR;
3109: END IF;
3110: END IF;
3104: p_x_line_rec.shipment_priority_code := NULL;
3105: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3106: p_x_line_rec.shipment_priority_code := FND_API.G_MISS_CHAR;
3107: ELSE
3108: x_return_status := FND_API.G_RET_STS_ERROR;
3109: END IF;
3110: END IF;
3111: END IF;
3112:
3115: IF NOT OE_CNCL_Validate.Shipping_Method(p_x_line_rec.shipping_method_code) THEN
3116: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3117: p_x_line_rec.shipping_method_code := NULL;
3118: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3119: p_x_line_rec.shipping_method_code := FND_API.G_MISS_CHAR;
3120: ELSE
3121: x_return_status := FND_API.G_RET_STS_ERROR;
3122: END IF;
3123: END IF;
3117: p_x_line_rec.shipping_method_code := NULL;
3118: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3119: p_x_line_rec.shipping_method_code := FND_API.G_MISS_CHAR;
3120: ELSE
3121: x_return_status := FND_API.G_RET_STS_ERROR;
3122: END IF;
3123: END IF;
3124: END IF;
3125:
3128: IF NOT OE_CNCL_Validate.Ship_From_Org(p_x_line_rec.ship_from_org_id) THEN
3129: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3130: p_x_line_rec.ship_from_org_id := NULL;
3131: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3132: p_x_line_rec.ship_from_org_id := FND_API.G_MISS_NUM;
3133: ELSE
3134: x_return_status := FND_API.G_RET_STS_ERROR;
3135: END IF;
3136: END IF;
3130: p_x_line_rec.ship_from_org_id := NULL;
3131: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3132: p_x_line_rec.ship_from_org_id := FND_API.G_MISS_NUM;
3133: ELSE
3134: x_return_status := FND_API.G_RET_STS_ERROR;
3135: END IF;
3136: END IF;
3137: END IF;
3138:
3141: IF NOT OE_CNCL_Validate.Shipping_Interfaced(p_x_line_rec.shipping_interfaced_flag) THEN
3142: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3143: p_x_line_rec.shipping_interfaced_flag := NULL;
3144: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3145: p_x_line_rec.shipping_interfaced_flag := FND_API.G_MISS_CHAR;
3146: ELSE
3147: x_return_status := FND_API.G_RET_STS_ERROR;
3148: END IF;
3149: END IF;
3143: p_x_line_rec.shipping_interfaced_flag := NULL;
3144: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3145: p_x_line_rec.shipping_interfaced_flag := FND_API.G_MISS_CHAR;
3146: ELSE
3147: x_return_status := FND_API.G_RET_STS_ERROR;
3148: END IF;
3149: END IF;
3150: END IF;
3151:
3154: IF NOT OE_CNCL_Validate.shippable(p_x_line_rec.shippable_flag) THEN
3155: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3156: p_x_line_rec.shippable_flag := NULL;
3157: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3158: p_x_line_rec.shippable_flag := FND_API.G_MISS_CHAR;
3159: ELSE
3160: x_return_status := FND_API.G_RET_STS_ERROR;
3161: END IF;
3162: END IF;
3156: p_x_line_rec.shippable_flag := NULL;
3157: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3158: p_x_line_rec.shippable_flag := FND_API.G_MISS_CHAR;
3159: ELSE
3160: x_return_status := FND_API.G_RET_STS_ERROR;
3161: END IF;
3162: END IF;
3163: END IF;
3164:
3167: IF NOT OE_CNCL_Validate.Ship_To_Contact(p_x_line_rec.ship_to_contact_id) THEN
3168: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3169: p_x_line_rec.ship_to_contact_id := NULL;
3170: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3171: p_x_line_rec.ship_to_contact_id := FND_API.G_MISS_NUM;
3172: ELSE
3173: x_return_status := FND_API.G_RET_STS_ERROR;
3174: END IF;
3175: END IF;
3169: p_x_line_rec.ship_to_contact_id := NULL;
3170: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3171: p_x_line_rec.ship_to_contact_id := FND_API.G_MISS_NUM;
3172: ELSE
3173: x_return_status := FND_API.G_RET_STS_ERROR;
3174: END IF;
3175: END IF;
3176: END IF;
3177:
3180: IF NOT OE_CNCL_Validate.Ship_To_Org(p_x_line_rec.ship_to_org_id) THEN
3181: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3182: p_x_line_rec.ship_to_org_id := NULL;
3183: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3184: p_x_line_rec.ship_to_org_id := FND_API.G_MISS_NUM;
3185: ELSE
3186: x_return_status := FND_API.G_RET_STS_ERROR;
3187: END IF;
3188: END IF;
3182: p_x_line_rec.ship_to_org_id := NULL;
3183: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3184: p_x_line_rec.ship_to_org_id := FND_API.G_MISS_NUM;
3185: ELSE
3186: x_return_status := FND_API.G_RET_STS_ERROR;
3187: END IF;
3188: END IF;
3189: END IF;
3190:
3193: IF NOT OE_CNCL_Validate.Sold_To_Org(p_x_line_rec.sold_to_org_id) THEN
3194: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3195: p_x_line_rec.sold_to_org_id := NULL;
3196: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3197: p_x_line_rec.sold_to_org_id := FND_API.G_MISS_NUM;
3198: ELSE
3199: x_return_status := FND_API.G_RET_STS_ERROR;
3200: END IF;
3201: END IF;
3195: p_x_line_rec.sold_to_org_id := NULL;
3196: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3197: p_x_line_rec.sold_to_org_id := FND_API.G_MISS_NUM;
3198: ELSE
3199: x_return_status := FND_API.G_RET_STS_ERROR;
3200: END IF;
3201: END IF;
3202: END IF;
3203:
3206: IF NOT OE_CNCL_Validate.Source_Type(p_x_line_rec.source_type_code) THEN
3207: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3208: p_x_line_rec.source_type_code := NULL;
3209: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3210: p_x_line_rec.source_type_code := FND_API.G_MISS_CHAR;
3211: ELSE
3212: x_return_status := FND_API.G_RET_STS_ERROR;
3213: END IF;
3214: END IF;
3208: p_x_line_rec.source_type_code := NULL;
3209: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3210: p_x_line_rec.source_type_code := FND_API.G_MISS_CHAR;
3211: ELSE
3212: x_return_status := FND_API.G_RET_STS_ERROR;
3213: END IF;
3214: END IF;
3215: END IF;
3216:
3219: IF NOT OE_CNCL_Validate.Tax_Exempt(p_x_line_rec.tax_exempt_flag) THEN
3220: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3221: p_x_line_rec.tax_exempt_flag := NULL;
3222: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3223: p_x_line_rec.tax_exempt_flag := FND_API.G_MISS_CHAR;
3224: ELSE
3225: x_return_status := FND_API.G_RET_STS_ERROR;
3226: END IF;
3227: END IF;
3221: p_x_line_rec.tax_exempt_flag := NULL;
3222: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3223: p_x_line_rec.tax_exempt_flag := FND_API.G_MISS_CHAR;
3224: ELSE
3225: x_return_status := FND_API.G_RET_STS_ERROR;
3226: END IF;
3227: END IF;
3228: END IF;
3229:
3232: IF NOT OE_CNCL_Validate.Tax_Exempt_Reason(p_x_line_rec.tax_exempt_reason_code) THEN
3233: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3234: p_x_line_rec.tax_exempt_reason_code := NULL;
3235: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3236: p_x_line_rec.tax_exempt_reason_code := FND_API.G_MISS_CHAR;
3237: ELSE
3238: x_return_status := FND_API.G_RET_STS_ERROR;
3239: END IF;
3240: END IF;
3234: p_x_line_rec.tax_exempt_reason_code := NULL;
3235: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3236: p_x_line_rec.tax_exempt_reason_code := FND_API.G_MISS_CHAR;
3237: ELSE
3238: x_return_status := FND_API.G_RET_STS_ERROR;
3239: END IF;
3240: END IF;
3241: END IF;
3242:
3245: IF NOT OE_CNCL_Validate.Tax_Point(p_x_line_rec.tax_point_code) THEN
3246: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3247: p_x_line_rec.tax_point_code := NULL;
3248: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3249: p_x_line_rec.tax_point_code := FND_API.G_MISS_CHAR;
3250: ELSE
3251: x_return_status := FND_API.G_RET_STS_ERROR;
3252: END IF;
3253: END IF;
3247: p_x_line_rec.tax_point_code := NULL;
3248: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3249: p_x_line_rec.tax_point_code := FND_API.G_MISS_CHAR;
3250: ELSE
3251: x_return_status := FND_API.G_RET_STS_ERROR;
3252: END IF;
3253: END IF;
3254: END IF;
3255:
3258: IF NOT OE_CNCL_Validate.fulfilled(p_x_line_rec.fulfilled_flag) THEN
3259: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3260: p_x_line_rec.fulfilled_flag := NULL;
3261: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3262: p_x_line_rec.fulfilled_flag := FND_API.G_MISS_CHAR;
3263: ELSE
3264: x_return_status := FND_API.G_RET_STS_ERROR;
3265: END IF;
3266: END IF;
3260: p_x_line_rec.fulfilled_flag := NULL;
3261: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3262: p_x_line_rec.fulfilled_flag := FND_API.G_MISS_CHAR;
3263: ELSE
3264: x_return_status := FND_API.G_RET_STS_ERROR;
3265: END IF;
3266: END IF;
3267: END IF;
3268:
3271: IF NOT OE_CNCL_Validate.Line_Flow_Status(p_x_line_rec.flow_status_code) THEN
3272: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3273: p_x_line_rec.flow_status_code := NULL;
3274: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3275: p_x_line_rec.flow_status_code := FND_API.G_MISS_CHAR;
3276: ELSE
3277: x_return_status := FND_API.G_RET_STS_ERROR;
3278: END IF;
3279: END IF;
3273: p_x_line_rec.flow_status_code := NULL;
3274: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3275: p_x_line_rec.flow_status_code := FND_API.G_MISS_CHAR;
3276: ELSE
3277: x_return_status := FND_API.G_RET_STS_ERROR;
3278: END IF;
3279: END IF;
3280: END IF;
3281:
3352: p_x_line_rec.attribute19 := null;
3353: p_x_line_rec.attribute20 := null;
3354:
3355: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3356: p_x_line_rec.context := FND_API.G_MISS_CHAR;
3357: p_x_line_rec.attribute1 := FND_API.G_MISS_CHAR;
3358: p_x_line_rec.attribute2 := FND_API.G_MISS_CHAR;
3359: p_x_line_rec.attribute3 := FND_API.G_MISS_CHAR;
3360: p_x_line_rec.attribute4 := FND_API.G_MISS_CHAR;
3353: p_x_line_rec.attribute20 := null;
3354:
3355: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3356: p_x_line_rec.context := FND_API.G_MISS_CHAR;
3357: p_x_line_rec.attribute1 := FND_API.G_MISS_CHAR;
3358: p_x_line_rec.attribute2 := FND_API.G_MISS_CHAR;
3359: p_x_line_rec.attribute3 := FND_API.G_MISS_CHAR;
3360: p_x_line_rec.attribute4 := FND_API.G_MISS_CHAR;
3361: p_x_line_rec.attribute5 := FND_API.G_MISS_CHAR;
3354:
3355: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3356: p_x_line_rec.context := FND_API.G_MISS_CHAR;
3357: p_x_line_rec.attribute1 := FND_API.G_MISS_CHAR;
3358: p_x_line_rec.attribute2 := FND_API.G_MISS_CHAR;
3359: p_x_line_rec.attribute3 := FND_API.G_MISS_CHAR;
3360: p_x_line_rec.attribute4 := FND_API.G_MISS_CHAR;
3361: p_x_line_rec.attribute5 := FND_API.G_MISS_CHAR;
3362: p_x_line_rec.attribute6 := FND_API.G_MISS_CHAR;
3355: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3356: p_x_line_rec.context := FND_API.G_MISS_CHAR;
3357: p_x_line_rec.attribute1 := FND_API.G_MISS_CHAR;
3358: p_x_line_rec.attribute2 := FND_API.G_MISS_CHAR;
3359: p_x_line_rec.attribute3 := FND_API.G_MISS_CHAR;
3360: p_x_line_rec.attribute4 := FND_API.G_MISS_CHAR;
3361: p_x_line_rec.attribute5 := FND_API.G_MISS_CHAR;
3362: p_x_line_rec.attribute6 := FND_API.G_MISS_CHAR;
3363: p_x_line_rec.attribute7 := FND_API.G_MISS_CHAR;
3356: p_x_line_rec.context := FND_API.G_MISS_CHAR;
3357: p_x_line_rec.attribute1 := FND_API.G_MISS_CHAR;
3358: p_x_line_rec.attribute2 := FND_API.G_MISS_CHAR;
3359: p_x_line_rec.attribute3 := FND_API.G_MISS_CHAR;
3360: p_x_line_rec.attribute4 := FND_API.G_MISS_CHAR;
3361: p_x_line_rec.attribute5 := FND_API.G_MISS_CHAR;
3362: p_x_line_rec.attribute6 := FND_API.G_MISS_CHAR;
3363: p_x_line_rec.attribute7 := FND_API.G_MISS_CHAR;
3364: p_x_line_rec.attribute8 := FND_API.G_MISS_CHAR;
3357: p_x_line_rec.attribute1 := FND_API.G_MISS_CHAR;
3358: p_x_line_rec.attribute2 := FND_API.G_MISS_CHAR;
3359: p_x_line_rec.attribute3 := FND_API.G_MISS_CHAR;
3360: p_x_line_rec.attribute4 := FND_API.G_MISS_CHAR;
3361: p_x_line_rec.attribute5 := FND_API.G_MISS_CHAR;
3362: p_x_line_rec.attribute6 := FND_API.G_MISS_CHAR;
3363: p_x_line_rec.attribute7 := FND_API.G_MISS_CHAR;
3364: p_x_line_rec.attribute8 := FND_API.G_MISS_CHAR;
3365: p_x_line_rec.attribute9 := FND_API.G_MISS_CHAR;
3358: p_x_line_rec.attribute2 := FND_API.G_MISS_CHAR;
3359: p_x_line_rec.attribute3 := FND_API.G_MISS_CHAR;
3360: p_x_line_rec.attribute4 := FND_API.G_MISS_CHAR;
3361: p_x_line_rec.attribute5 := FND_API.G_MISS_CHAR;
3362: p_x_line_rec.attribute6 := FND_API.G_MISS_CHAR;
3363: p_x_line_rec.attribute7 := FND_API.G_MISS_CHAR;
3364: p_x_line_rec.attribute8 := FND_API.G_MISS_CHAR;
3365: p_x_line_rec.attribute9 := FND_API.G_MISS_CHAR;
3366: p_x_line_rec.attribute10 := FND_API.G_MISS_CHAR;
3359: p_x_line_rec.attribute3 := FND_API.G_MISS_CHAR;
3360: p_x_line_rec.attribute4 := FND_API.G_MISS_CHAR;
3361: p_x_line_rec.attribute5 := FND_API.G_MISS_CHAR;
3362: p_x_line_rec.attribute6 := FND_API.G_MISS_CHAR;
3363: p_x_line_rec.attribute7 := FND_API.G_MISS_CHAR;
3364: p_x_line_rec.attribute8 := FND_API.G_MISS_CHAR;
3365: p_x_line_rec.attribute9 := FND_API.G_MISS_CHAR;
3366: p_x_line_rec.attribute10 := FND_API.G_MISS_CHAR;
3367: p_x_line_rec.attribute11 := FND_API.G_MISS_CHAR;
3360: p_x_line_rec.attribute4 := FND_API.G_MISS_CHAR;
3361: p_x_line_rec.attribute5 := FND_API.G_MISS_CHAR;
3362: p_x_line_rec.attribute6 := FND_API.G_MISS_CHAR;
3363: p_x_line_rec.attribute7 := FND_API.G_MISS_CHAR;
3364: p_x_line_rec.attribute8 := FND_API.G_MISS_CHAR;
3365: p_x_line_rec.attribute9 := FND_API.G_MISS_CHAR;
3366: p_x_line_rec.attribute10 := FND_API.G_MISS_CHAR;
3367: p_x_line_rec.attribute11 := FND_API.G_MISS_CHAR;
3368: p_x_line_rec.attribute12 := FND_API.G_MISS_CHAR;
3361: p_x_line_rec.attribute5 := FND_API.G_MISS_CHAR;
3362: p_x_line_rec.attribute6 := FND_API.G_MISS_CHAR;
3363: p_x_line_rec.attribute7 := FND_API.G_MISS_CHAR;
3364: p_x_line_rec.attribute8 := FND_API.G_MISS_CHAR;
3365: p_x_line_rec.attribute9 := FND_API.G_MISS_CHAR;
3366: p_x_line_rec.attribute10 := FND_API.G_MISS_CHAR;
3367: p_x_line_rec.attribute11 := FND_API.G_MISS_CHAR;
3368: p_x_line_rec.attribute12 := FND_API.G_MISS_CHAR;
3369: p_x_line_rec.attribute13 := FND_API.G_MISS_CHAR;
3362: p_x_line_rec.attribute6 := FND_API.G_MISS_CHAR;
3363: p_x_line_rec.attribute7 := FND_API.G_MISS_CHAR;
3364: p_x_line_rec.attribute8 := FND_API.G_MISS_CHAR;
3365: p_x_line_rec.attribute9 := FND_API.G_MISS_CHAR;
3366: p_x_line_rec.attribute10 := FND_API.G_MISS_CHAR;
3367: p_x_line_rec.attribute11 := FND_API.G_MISS_CHAR;
3368: p_x_line_rec.attribute12 := FND_API.G_MISS_CHAR;
3369: p_x_line_rec.attribute13 := FND_API.G_MISS_CHAR;
3370: p_x_line_rec.attribute14 := FND_API.G_MISS_CHAR;
3363: p_x_line_rec.attribute7 := FND_API.G_MISS_CHAR;
3364: p_x_line_rec.attribute8 := FND_API.G_MISS_CHAR;
3365: p_x_line_rec.attribute9 := FND_API.G_MISS_CHAR;
3366: p_x_line_rec.attribute10 := FND_API.G_MISS_CHAR;
3367: p_x_line_rec.attribute11 := FND_API.G_MISS_CHAR;
3368: p_x_line_rec.attribute12 := FND_API.G_MISS_CHAR;
3369: p_x_line_rec.attribute13 := FND_API.G_MISS_CHAR;
3370: p_x_line_rec.attribute14 := FND_API.G_MISS_CHAR;
3371: p_x_line_rec.attribute15 := FND_API.G_MISS_CHAR;
3364: p_x_line_rec.attribute8 := FND_API.G_MISS_CHAR;
3365: p_x_line_rec.attribute9 := FND_API.G_MISS_CHAR;
3366: p_x_line_rec.attribute10 := FND_API.G_MISS_CHAR;
3367: p_x_line_rec.attribute11 := FND_API.G_MISS_CHAR;
3368: p_x_line_rec.attribute12 := FND_API.G_MISS_CHAR;
3369: p_x_line_rec.attribute13 := FND_API.G_MISS_CHAR;
3370: p_x_line_rec.attribute14 := FND_API.G_MISS_CHAR;
3371: p_x_line_rec.attribute15 := FND_API.G_MISS_CHAR;
3372: p_x_line_rec.attribute16 := FND_API.G_MISS_CHAR; -- for bug 2184255
3365: p_x_line_rec.attribute9 := FND_API.G_MISS_CHAR;
3366: p_x_line_rec.attribute10 := FND_API.G_MISS_CHAR;
3367: p_x_line_rec.attribute11 := FND_API.G_MISS_CHAR;
3368: p_x_line_rec.attribute12 := FND_API.G_MISS_CHAR;
3369: p_x_line_rec.attribute13 := FND_API.G_MISS_CHAR;
3370: p_x_line_rec.attribute14 := FND_API.G_MISS_CHAR;
3371: p_x_line_rec.attribute15 := FND_API.G_MISS_CHAR;
3372: p_x_line_rec.attribute16 := FND_API.G_MISS_CHAR; -- for bug 2184255
3373: p_x_line_rec.attribute17 := FND_API.G_MISS_CHAR;
3366: p_x_line_rec.attribute10 := FND_API.G_MISS_CHAR;
3367: p_x_line_rec.attribute11 := FND_API.G_MISS_CHAR;
3368: p_x_line_rec.attribute12 := FND_API.G_MISS_CHAR;
3369: p_x_line_rec.attribute13 := FND_API.G_MISS_CHAR;
3370: p_x_line_rec.attribute14 := FND_API.G_MISS_CHAR;
3371: p_x_line_rec.attribute15 := FND_API.G_MISS_CHAR;
3372: p_x_line_rec.attribute16 := FND_API.G_MISS_CHAR; -- for bug 2184255
3373: p_x_line_rec.attribute17 := FND_API.G_MISS_CHAR;
3374: p_x_line_rec.attribute18 := FND_API.G_MISS_CHAR;
3367: p_x_line_rec.attribute11 := FND_API.G_MISS_CHAR;
3368: p_x_line_rec.attribute12 := FND_API.G_MISS_CHAR;
3369: p_x_line_rec.attribute13 := FND_API.G_MISS_CHAR;
3370: p_x_line_rec.attribute14 := FND_API.G_MISS_CHAR;
3371: p_x_line_rec.attribute15 := FND_API.G_MISS_CHAR;
3372: p_x_line_rec.attribute16 := FND_API.G_MISS_CHAR; -- for bug 2184255
3373: p_x_line_rec.attribute17 := FND_API.G_MISS_CHAR;
3374: p_x_line_rec.attribute18 := FND_API.G_MISS_CHAR;
3375: p_x_line_rec.attribute19 := FND_API.G_MISS_CHAR;
3368: p_x_line_rec.attribute12 := FND_API.G_MISS_CHAR;
3369: p_x_line_rec.attribute13 := FND_API.G_MISS_CHAR;
3370: p_x_line_rec.attribute14 := FND_API.G_MISS_CHAR;
3371: p_x_line_rec.attribute15 := FND_API.G_MISS_CHAR;
3372: p_x_line_rec.attribute16 := FND_API.G_MISS_CHAR; -- for bug 2184255
3373: p_x_line_rec.attribute17 := FND_API.G_MISS_CHAR;
3374: p_x_line_rec.attribute18 := FND_API.G_MISS_CHAR;
3375: p_x_line_rec.attribute19 := FND_API.G_MISS_CHAR;
3376: p_x_line_rec.attribute20 := FND_API.G_MISS_CHAR;
3369: p_x_line_rec.attribute13 := FND_API.G_MISS_CHAR;
3370: p_x_line_rec.attribute14 := FND_API.G_MISS_CHAR;
3371: p_x_line_rec.attribute15 := FND_API.G_MISS_CHAR;
3372: p_x_line_rec.attribute16 := FND_API.G_MISS_CHAR; -- for bug 2184255
3373: p_x_line_rec.attribute17 := FND_API.G_MISS_CHAR;
3374: p_x_line_rec.attribute18 := FND_API.G_MISS_CHAR;
3375: p_x_line_rec.attribute19 := FND_API.G_MISS_CHAR;
3376: p_x_line_rec.attribute20 := FND_API.G_MISS_CHAR;
3377: ELSE
3370: p_x_line_rec.attribute14 := FND_API.G_MISS_CHAR;
3371: p_x_line_rec.attribute15 := FND_API.G_MISS_CHAR;
3372: p_x_line_rec.attribute16 := FND_API.G_MISS_CHAR; -- for bug 2184255
3373: p_x_line_rec.attribute17 := FND_API.G_MISS_CHAR;
3374: p_x_line_rec.attribute18 := FND_API.G_MISS_CHAR;
3375: p_x_line_rec.attribute19 := FND_API.G_MISS_CHAR;
3376: p_x_line_rec.attribute20 := FND_API.G_MISS_CHAR;
3377: ELSE
3378:
3371: p_x_line_rec.attribute15 := FND_API.G_MISS_CHAR;
3372: p_x_line_rec.attribute16 := FND_API.G_MISS_CHAR; -- for bug 2184255
3373: p_x_line_rec.attribute17 := FND_API.G_MISS_CHAR;
3374: p_x_line_rec.attribute18 := FND_API.G_MISS_CHAR;
3375: p_x_line_rec.attribute19 := FND_API.G_MISS_CHAR;
3376: p_x_line_rec.attribute20 := FND_API.G_MISS_CHAR;
3377: ELSE
3378:
3379: x_return_status := FND_API.G_RET_STS_ERROR;
3372: p_x_line_rec.attribute16 := FND_API.G_MISS_CHAR; -- for bug 2184255
3373: p_x_line_rec.attribute17 := FND_API.G_MISS_CHAR;
3374: p_x_line_rec.attribute18 := FND_API.G_MISS_CHAR;
3375: p_x_line_rec.attribute19 := FND_API.G_MISS_CHAR;
3376: p_x_line_rec.attribute20 := FND_API.G_MISS_CHAR;
3377: ELSE
3378:
3379: x_return_status := FND_API.G_RET_STS_ERROR;
3380: END IF;
3375: p_x_line_rec.attribute19 := FND_API.G_MISS_CHAR;
3376: p_x_line_rec.attribute20 := FND_API.G_MISS_CHAR;
3377: ELSE
3378:
3379: x_return_status := FND_API.G_RET_STS_ERROR;
3380: END IF;
3381: END IF;
3382:
3383: oe_debug_pub.add('After line_desc_flex ' || x_return_status,2);
3459: p_x_line_rec.global_attribute19 := null;
3460: p_x_line_rec.global_attribute20 := null;
3461:
3462: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3463: p_x_line_rec.global_attribute_category := FND_API.G_MISS_CHAR;
3464: p_x_line_rec.global_attribute1 := FND_API.G_MISS_CHAR;
3465: p_x_line_rec.global_attribute2 := FND_API.G_MISS_CHAR;
3466: p_x_line_rec.global_attribute3 := FND_API.G_MISS_CHAR;
3467: p_x_line_rec.global_attribute4 := FND_API.G_MISS_CHAR;
3460: p_x_line_rec.global_attribute20 := null;
3461:
3462: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3463: p_x_line_rec.global_attribute_category := FND_API.G_MISS_CHAR;
3464: p_x_line_rec.global_attribute1 := FND_API.G_MISS_CHAR;
3465: p_x_line_rec.global_attribute2 := FND_API.G_MISS_CHAR;
3466: p_x_line_rec.global_attribute3 := FND_API.G_MISS_CHAR;
3467: p_x_line_rec.global_attribute4 := FND_API.G_MISS_CHAR;
3468: p_x_line_rec.global_attribute5 := FND_API.G_MISS_CHAR;
3461:
3462: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3463: p_x_line_rec.global_attribute_category := FND_API.G_MISS_CHAR;
3464: p_x_line_rec.global_attribute1 := FND_API.G_MISS_CHAR;
3465: p_x_line_rec.global_attribute2 := FND_API.G_MISS_CHAR;
3466: p_x_line_rec.global_attribute3 := FND_API.G_MISS_CHAR;
3467: p_x_line_rec.global_attribute4 := FND_API.G_MISS_CHAR;
3468: p_x_line_rec.global_attribute5 := FND_API.G_MISS_CHAR;
3469: p_x_line_rec.global_attribute6 := FND_API.G_MISS_CHAR;
3462: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3463: p_x_line_rec.global_attribute_category := FND_API.G_MISS_CHAR;
3464: p_x_line_rec.global_attribute1 := FND_API.G_MISS_CHAR;
3465: p_x_line_rec.global_attribute2 := FND_API.G_MISS_CHAR;
3466: p_x_line_rec.global_attribute3 := FND_API.G_MISS_CHAR;
3467: p_x_line_rec.global_attribute4 := FND_API.G_MISS_CHAR;
3468: p_x_line_rec.global_attribute5 := FND_API.G_MISS_CHAR;
3469: p_x_line_rec.global_attribute6 := FND_API.G_MISS_CHAR;
3470: p_x_line_rec.global_attribute7 := FND_API.G_MISS_CHAR;
3463: p_x_line_rec.global_attribute_category := FND_API.G_MISS_CHAR;
3464: p_x_line_rec.global_attribute1 := FND_API.G_MISS_CHAR;
3465: p_x_line_rec.global_attribute2 := FND_API.G_MISS_CHAR;
3466: p_x_line_rec.global_attribute3 := FND_API.G_MISS_CHAR;
3467: p_x_line_rec.global_attribute4 := FND_API.G_MISS_CHAR;
3468: p_x_line_rec.global_attribute5 := FND_API.G_MISS_CHAR;
3469: p_x_line_rec.global_attribute6 := FND_API.G_MISS_CHAR;
3470: p_x_line_rec.global_attribute7 := FND_API.G_MISS_CHAR;
3471: p_x_line_rec.global_attribute8 := FND_API.G_MISS_CHAR;
3464: p_x_line_rec.global_attribute1 := FND_API.G_MISS_CHAR;
3465: p_x_line_rec.global_attribute2 := FND_API.G_MISS_CHAR;
3466: p_x_line_rec.global_attribute3 := FND_API.G_MISS_CHAR;
3467: p_x_line_rec.global_attribute4 := FND_API.G_MISS_CHAR;
3468: p_x_line_rec.global_attribute5 := FND_API.G_MISS_CHAR;
3469: p_x_line_rec.global_attribute6 := FND_API.G_MISS_CHAR;
3470: p_x_line_rec.global_attribute7 := FND_API.G_MISS_CHAR;
3471: p_x_line_rec.global_attribute8 := FND_API.G_MISS_CHAR;
3472: p_x_line_rec.global_attribute9 := FND_API.G_MISS_CHAR;
3465: p_x_line_rec.global_attribute2 := FND_API.G_MISS_CHAR;
3466: p_x_line_rec.global_attribute3 := FND_API.G_MISS_CHAR;
3467: p_x_line_rec.global_attribute4 := FND_API.G_MISS_CHAR;
3468: p_x_line_rec.global_attribute5 := FND_API.G_MISS_CHAR;
3469: p_x_line_rec.global_attribute6 := FND_API.G_MISS_CHAR;
3470: p_x_line_rec.global_attribute7 := FND_API.G_MISS_CHAR;
3471: p_x_line_rec.global_attribute8 := FND_API.G_MISS_CHAR;
3472: p_x_line_rec.global_attribute9 := FND_API.G_MISS_CHAR;
3473: p_x_line_rec.global_attribute11 := FND_API.G_MISS_CHAR;
3466: p_x_line_rec.global_attribute3 := FND_API.G_MISS_CHAR;
3467: p_x_line_rec.global_attribute4 := FND_API.G_MISS_CHAR;
3468: p_x_line_rec.global_attribute5 := FND_API.G_MISS_CHAR;
3469: p_x_line_rec.global_attribute6 := FND_API.G_MISS_CHAR;
3470: p_x_line_rec.global_attribute7 := FND_API.G_MISS_CHAR;
3471: p_x_line_rec.global_attribute8 := FND_API.G_MISS_CHAR;
3472: p_x_line_rec.global_attribute9 := FND_API.G_MISS_CHAR;
3473: p_x_line_rec.global_attribute11 := FND_API.G_MISS_CHAR;
3474: p_x_line_rec.global_attribute12 := FND_API.G_MISS_CHAR;
3467: p_x_line_rec.global_attribute4 := FND_API.G_MISS_CHAR;
3468: p_x_line_rec.global_attribute5 := FND_API.G_MISS_CHAR;
3469: p_x_line_rec.global_attribute6 := FND_API.G_MISS_CHAR;
3470: p_x_line_rec.global_attribute7 := FND_API.G_MISS_CHAR;
3471: p_x_line_rec.global_attribute8 := FND_API.G_MISS_CHAR;
3472: p_x_line_rec.global_attribute9 := FND_API.G_MISS_CHAR;
3473: p_x_line_rec.global_attribute11 := FND_API.G_MISS_CHAR;
3474: p_x_line_rec.global_attribute12 := FND_API.G_MISS_CHAR;
3475: p_x_line_rec.global_attribute13 := FND_API.G_MISS_CHAR;
3468: p_x_line_rec.global_attribute5 := FND_API.G_MISS_CHAR;
3469: p_x_line_rec.global_attribute6 := FND_API.G_MISS_CHAR;
3470: p_x_line_rec.global_attribute7 := FND_API.G_MISS_CHAR;
3471: p_x_line_rec.global_attribute8 := FND_API.G_MISS_CHAR;
3472: p_x_line_rec.global_attribute9 := FND_API.G_MISS_CHAR;
3473: p_x_line_rec.global_attribute11 := FND_API.G_MISS_CHAR;
3474: p_x_line_rec.global_attribute12 := FND_API.G_MISS_CHAR;
3475: p_x_line_rec.global_attribute13 := FND_API.G_MISS_CHAR;
3476: p_x_line_rec.global_attribute14 := FND_API.G_MISS_CHAR;
3469: p_x_line_rec.global_attribute6 := FND_API.G_MISS_CHAR;
3470: p_x_line_rec.global_attribute7 := FND_API.G_MISS_CHAR;
3471: p_x_line_rec.global_attribute8 := FND_API.G_MISS_CHAR;
3472: p_x_line_rec.global_attribute9 := FND_API.G_MISS_CHAR;
3473: p_x_line_rec.global_attribute11 := FND_API.G_MISS_CHAR;
3474: p_x_line_rec.global_attribute12 := FND_API.G_MISS_CHAR;
3475: p_x_line_rec.global_attribute13 := FND_API.G_MISS_CHAR;
3476: p_x_line_rec.global_attribute14 := FND_API.G_MISS_CHAR;
3477: p_x_line_rec.global_attribute15 := FND_API.G_MISS_CHAR;
3470: p_x_line_rec.global_attribute7 := FND_API.G_MISS_CHAR;
3471: p_x_line_rec.global_attribute8 := FND_API.G_MISS_CHAR;
3472: p_x_line_rec.global_attribute9 := FND_API.G_MISS_CHAR;
3473: p_x_line_rec.global_attribute11 := FND_API.G_MISS_CHAR;
3474: p_x_line_rec.global_attribute12 := FND_API.G_MISS_CHAR;
3475: p_x_line_rec.global_attribute13 := FND_API.G_MISS_CHAR;
3476: p_x_line_rec.global_attribute14 := FND_API.G_MISS_CHAR;
3477: p_x_line_rec.global_attribute15 := FND_API.G_MISS_CHAR;
3478: p_x_line_rec.global_attribute16 := FND_API.G_MISS_CHAR;
3471: p_x_line_rec.global_attribute8 := FND_API.G_MISS_CHAR;
3472: p_x_line_rec.global_attribute9 := FND_API.G_MISS_CHAR;
3473: p_x_line_rec.global_attribute11 := FND_API.G_MISS_CHAR;
3474: p_x_line_rec.global_attribute12 := FND_API.G_MISS_CHAR;
3475: p_x_line_rec.global_attribute13 := FND_API.G_MISS_CHAR;
3476: p_x_line_rec.global_attribute14 := FND_API.G_MISS_CHAR;
3477: p_x_line_rec.global_attribute15 := FND_API.G_MISS_CHAR;
3478: p_x_line_rec.global_attribute16 := FND_API.G_MISS_CHAR;
3479: p_x_line_rec.global_attribute17 := FND_API.G_MISS_CHAR;
3472: p_x_line_rec.global_attribute9 := FND_API.G_MISS_CHAR;
3473: p_x_line_rec.global_attribute11 := FND_API.G_MISS_CHAR;
3474: p_x_line_rec.global_attribute12 := FND_API.G_MISS_CHAR;
3475: p_x_line_rec.global_attribute13 := FND_API.G_MISS_CHAR;
3476: p_x_line_rec.global_attribute14 := FND_API.G_MISS_CHAR;
3477: p_x_line_rec.global_attribute15 := FND_API.G_MISS_CHAR;
3478: p_x_line_rec.global_attribute16 := FND_API.G_MISS_CHAR;
3479: p_x_line_rec.global_attribute17 := FND_API.G_MISS_CHAR;
3480: p_x_line_rec.global_attribute18 := FND_API.G_MISS_CHAR;
3473: p_x_line_rec.global_attribute11 := FND_API.G_MISS_CHAR;
3474: p_x_line_rec.global_attribute12 := FND_API.G_MISS_CHAR;
3475: p_x_line_rec.global_attribute13 := FND_API.G_MISS_CHAR;
3476: p_x_line_rec.global_attribute14 := FND_API.G_MISS_CHAR;
3477: p_x_line_rec.global_attribute15 := FND_API.G_MISS_CHAR;
3478: p_x_line_rec.global_attribute16 := FND_API.G_MISS_CHAR;
3479: p_x_line_rec.global_attribute17 := FND_API.G_MISS_CHAR;
3480: p_x_line_rec.global_attribute18 := FND_API.G_MISS_CHAR;
3481: p_x_line_rec.global_attribute19 := FND_API.G_MISS_CHAR;
3474: p_x_line_rec.global_attribute12 := FND_API.G_MISS_CHAR;
3475: p_x_line_rec.global_attribute13 := FND_API.G_MISS_CHAR;
3476: p_x_line_rec.global_attribute14 := FND_API.G_MISS_CHAR;
3477: p_x_line_rec.global_attribute15 := FND_API.G_MISS_CHAR;
3478: p_x_line_rec.global_attribute16 := FND_API.G_MISS_CHAR;
3479: p_x_line_rec.global_attribute17 := FND_API.G_MISS_CHAR;
3480: p_x_line_rec.global_attribute18 := FND_API.G_MISS_CHAR;
3481: p_x_line_rec.global_attribute19 := FND_API.G_MISS_CHAR;
3482: p_x_line_rec.global_attribute20 := FND_API.G_MISS_CHAR;
3475: p_x_line_rec.global_attribute13 := FND_API.G_MISS_CHAR;
3476: p_x_line_rec.global_attribute14 := FND_API.G_MISS_CHAR;
3477: p_x_line_rec.global_attribute15 := FND_API.G_MISS_CHAR;
3478: p_x_line_rec.global_attribute16 := FND_API.G_MISS_CHAR;
3479: p_x_line_rec.global_attribute17 := FND_API.G_MISS_CHAR;
3480: p_x_line_rec.global_attribute18 := FND_API.G_MISS_CHAR;
3481: p_x_line_rec.global_attribute19 := FND_API.G_MISS_CHAR;
3482: p_x_line_rec.global_attribute20 := FND_API.G_MISS_CHAR;
3483:
3476: p_x_line_rec.global_attribute14 := FND_API.G_MISS_CHAR;
3477: p_x_line_rec.global_attribute15 := FND_API.G_MISS_CHAR;
3478: p_x_line_rec.global_attribute16 := FND_API.G_MISS_CHAR;
3479: p_x_line_rec.global_attribute17 := FND_API.G_MISS_CHAR;
3480: p_x_line_rec.global_attribute18 := FND_API.G_MISS_CHAR;
3481: p_x_line_rec.global_attribute19 := FND_API.G_MISS_CHAR;
3482: p_x_line_rec.global_attribute20 := FND_API.G_MISS_CHAR;
3483:
3484: ELSE
3477: p_x_line_rec.global_attribute15 := FND_API.G_MISS_CHAR;
3478: p_x_line_rec.global_attribute16 := FND_API.G_MISS_CHAR;
3479: p_x_line_rec.global_attribute17 := FND_API.G_MISS_CHAR;
3480: p_x_line_rec.global_attribute18 := FND_API.G_MISS_CHAR;
3481: p_x_line_rec.global_attribute19 := FND_API.G_MISS_CHAR;
3482: p_x_line_rec.global_attribute20 := FND_API.G_MISS_CHAR;
3483:
3484: ELSE
3485:
3478: p_x_line_rec.global_attribute16 := FND_API.G_MISS_CHAR;
3479: p_x_line_rec.global_attribute17 := FND_API.G_MISS_CHAR;
3480: p_x_line_rec.global_attribute18 := FND_API.G_MISS_CHAR;
3481: p_x_line_rec.global_attribute19 := FND_API.G_MISS_CHAR;
3482: p_x_line_rec.global_attribute20 := FND_API.G_MISS_CHAR;
3483:
3484: ELSE
3485:
3486: x_return_status := FND_API.G_RET_STS_ERROR;
3482: p_x_line_rec.global_attribute20 := FND_API.G_MISS_CHAR;
3483:
3484: ELSE
3485:
3486: x_return_status := FND_API.G_RET_STS_ERROR;
3487: END IF;
3488: END IF;
3489:
3490: OE_DEBUG_PUB.ADD('After G_Line_desc_flex ' || x_return_status,2);
3594: p_x_line_rec.Industry_attribute30 := null;
3595:
3596: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3597:
3598: p_x_line_rec.Industry_context := FND_API.G_MISS_CHAR;
3599: p_x_line_rec.Industry_attribute1 := FND_API.G_MISS_CHAR;
3600: p_x_line_rec.Industry_attribute2 := FND_API.G_MISS_CHAR;
3601: p_x_line_rec.Industry_attribute3 := FND_API.G_MISS_CHAR;
3602: p_x_line_rec.Industry_attribute4 := FND_API.G_MISS_CHAR;
3595:
3596: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3597:
3598: p_x_line_rec.Industry_context := FND_API.G_MISS_CHAR;
3599: p_x_line_rec.Industry_attribute1 := FND_API.G_MISS_CHAR;
3600: p_x_line_rec.Industry_attribute2 := FND_API.G_MISS_CHAR;
3601: p_x_line_rec.Industry_attribute3 := FND_API.G_MISS_CHAR;
3602: p_x_line_rec.Industry_attribute4 := FND_API.G_MISS_CHAR;
3603: p_x_line_rec.Industry_attribute5 := FND_API.G_MISS_CHAR;
3596: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3597:
3598: p_x_line_rec.Industry_context := FND_API.G_MISS_CHAR;
3599: p_x_line_rec.Industry_attribute1 := FND_API.G_MISS_CHAR;
3600: p_x_line_rec.Industry_attribute2 := FND_API.G_MISS_CHAR;
3601: p_x_line_rec.Industry_attribute3 := FND_API.G_MISS_CHAR;
3602: p_x_line_rec.Industry_attribute4 := FND_API.G_MISS_CHAR;
3603: p_x_line_rec.Industry_attribute5 := FND_API.G_MISS_CHAR;
3604: p_x_line_rec.Industry_attribute6 := FND_API.G_MISS_CHAR;
3597:
3598: p_x_line_rec.Industry_context := FND_API.G_MISS_CHAR;
3599: p_x_line_rec.Industry_attribute1 := FND_API.G_MISS_CHAR;
3600: p_x_line_rec.Industry_attribute2 := FND_API.G_MISS_CHAR;
3601: p_x_line_rec.Industry_attribute3 := FND_API.G_MISS_CHAR;
3602: p_x_line_rec.Industry_attribute4 := FND_API.G_MISS_CHAR;
3603: p_x_line_rec.Industry_attribute5 := FND_API.G_MISS_CHAR;
3604: p_x_line_rec.Industry_attribute6 := FND_API.G_MISS_CHAR;
3605: p_x_line_rec.Industry_attribute7 := FND_API.G_MISS_CHAR;
3598: p_x_line_rec.Industry_context := FND_API.G_MISS_CHAR;
3599: p_x_line_rec.Industry_attribute1 := FND_API.G_MISS_CHAR;
3600: p_x_line_rec.Industry_attribute2 := FND_API.G_MISS_CHAR;
3601: p_x_line_rec.Industry_attribute3 := FND_API.G_MISS_CHAR;
3602: p_x_line_rec.Industry_attribute4 := FND_API.G_MISS_CHAR;
3603: p_x_line_rec.Industry_attribute5 := FND_API.G_MISS_CHAR;
3604: p_x_line_rec.Industry_attribute6 := FND_API.G_MISS_CHAR;
3605: p_x_line_rec.Industry_attribute7 := FND_API.G_MISS_CHAR;
3606: p_x_line_rec.Industry_attribute8 := FND_API.G_MISS_CHAR;
3599: p_x_line_rec.Industry_attribute1 := FND_API.G_MISS_CHAR;
3600: p_x_line_rec.Industry_attribute2 := FND_API.G_MISS_CHAR;
3601: p_x_line_rec.Industry_attribute3 := FND_API.G_MISS_CHAR;
3602: p_x_line_rec.Industry_attribute4 := FND_API.G_MISS_CHAR;
3603: p_x_line_rec.Industry_attribute5 := FND_API.G_MISS_CHAR;
3604: p_x_line_rec.Industry_attribute6 := FND_API.G_MISS_CHAR;
3605: p_x_line_rec.Industry_attribute7 := FND_API.G_MISS_CHAR;
3606: p_x_line_rec.Industry_attribute8 := FND_API.G_MISS_CHAR;
3607: p_x_line_rec.Industry_attribute9 := FND_API.G_MISS_CHAR;
3600: p_x_line_rec.Industry_attribute2 := FND_API.G_MISS_CHAR;
3601: p_x_line_rec.Industry_attribute3 := FND_API.G_MISS_CHAR;
3602: p_x_line_rec.Industry_attribute4 := FND_API.G_MISS_CHAR;
3603: p_x_line_rec.Industry_attribute5 := FND_API.G_MISS_CHAR;
3604: p_x_line_rec.Industry_attribute6 := FND_API.G_MISS_CHAR;
3605: p_x_line_rec.Industry_attribute7 := FND_API.G_MISS_CHAR;
3606: p_x_line_rec.Industry_attribute8 := FND_API.G_MISS_CHAR;
3607: p_x_line_rec.Industry_attribute9 := FND_API.G_MISS_CHAR;
3608: p_x_line_rec.Industry_attribute10 := FND_API.G_MISS_CHAR;
3601: p_x_line_rec.Industry_attribute3 := FND_API.G_MISS_CHAR;
3602: p_x_line_rec.Industry_attribute4 := FND_API.G_MISS_CHAR;
3603: p_x_line_rec.Industry_attribute5 := FND_API.G_MISS_CHAR;
3604: p_x_line_rec.Industry_attribute6 := FND_API.G_MISS_CHAR;
3605: p_x_line_rec.Industry_attribute7 := FND_API.G_MISS_CHAR;
3606: p_x_line_rec.Industry_attribute8 := FND_API.G_MISS_CHAR;
3607: p_x_line_rec.Industry_attribute9 := FND_API.G_MISS_CHAR;
3608: p_x_line_rec.Industry_attribute10 := FND_API.G_MISS_CHAR;
3609: p_x_line_rec.Industry_attribute11 := FND_API.G_MISS_CHAR;
3602: p_x_line_rec.Industry_attribute4 := FND_API.G_MISS_CHAR;
3603: p_x_line_rec.Industry_attribute5 := FND_API.G_MISS_CHAR;
3604: p_x_line_rec.Industry_attribute6 := FND_API.G_MISS_CHAR;
3605: p_x_line_rec.Industry_attribute7 := FND_API.G_MISS_CHAR;
3606: p_x_line_rec.Industry_attribute8 := FND_API.G_MISS_CHAR;
3607: p_x_line_rec.Industry_attribute9 := FND_API.G_MISS_CHAR;
3608: p_x_line_rec.Industry_attribute10 := FND_API.G_MISS_CHAR;
3609: p_x_line_rec.Industry_attribute11 := FND_API.G_MISS_CHAR;
3610: p_x_line_rec.Industry_attribute12 := FND_API.G_MISS_CHAR;
3603: p_x_line_rec.Industry_attribute5 := FND_API.G_MISS_CHAR;
3604: p_x_line_rec.Industry_attribute6 := FND_API.G_MISS_CHAR;
3605: p_x_line_rec.Industry_attribute7 := FND_API.G_MISS_CHAR;
3606: p_x_line_rec.Industry_attribute8 := FND_API.G_MISS_CHAR;
3607: p_x_line_rec.Industry_attribute9 := FND_API.G_MISS_CHAR;
3608: p_x_line_rec.Industry_attribute10 := FND_API.G_MISS_CHAR;
3609: p_x_line_rec.Industry_attribute11 := FND_API.G_MISS_CHAR;
3610: p_x_line_rec.Industry_attribute12 := FND_API.G_MISS_CHAR;
3611: p_x_line_rec.Industry_attribute13 := FND_API.G_MISS_CHAR;
3604: p_x_line_rec.Industry_attribute6 := FND_API.G_MISS_CHAR;
3605: p_x_line_rec.Industry_attribute7 := FND_API.G_MISS_CHAR;
3606: p_x_line_rec.Industry_attribute8 := FND_API.G_MISS_CHAR;
3607: p_x_line_rec.Industry_attribute9 := FND_API.G_MISS_CHAR;
3608: p_x_line_rec.Industry_attribute10 := FND_API.G_MISS_CHAR;
3609: p_x_line_rec.Industry_attribute11 := FND_API.G_MISS_CHAR;
3610: p_x_line_rec.Industry_attribute12 := FND_API.G_MISS_CHAR;
3611: p_x_line_rec.Industry_attribute13 := FND_API.G_MISS_CHAR;
3612: p_x_line_rec.Industry_attribute14 := FND_API.G_MISS_CHAR;
3605: p_x_line_rec.Industry_attribute7 := FND_API.G_MISS_CHAR;
3606: p_x_line_rec.Industry_attribute8 := FND_API.G_MISS_CHAR;
3607: p_x_line_rec.Industry_attribute9 := FND_API.G_MISS_CHAR;
3608: p_x_line_rec.Industry_attribute10 := FND_API.G_MISS_CHAR;
3609: p_x_line_rec.Industry_attribute11 := FND_API.G_MISS_CHAR;
3610: p_x_line_rec.Industry_attribute12 := FND_API.G_MISS_CHAR;
3611: p_x_line_rec.Industry_attribute13 := FND_API.G_MISS_CHAR;
3612: p_x_line_rec.Industry_attribute14 := FND_API.G_MISS_CHAR;
3613: p_x_line_rec.Industry_attribute15 := FND_API.G_MISS_CHAR;
3606: p_x_line_rec.Industry_attribute8 := FND_API.G_MISS_CHAR;
3607: p_x_line_rec.Industry_attribute9 := FND_API.G_MISS_CHAR;
3608: p_x_line_rec.Industry_attribute10 := FND_API.G_MISS_CHAR;
3609: p_x_line_rec.Industry_attribute11 := FND_API.G_MISS_CHAR;
3610: p_x_line_rec.Industry_attribute12 := FND_API.G_MISS_CHAR;
3611: p_x_line_rec.Industry_attribute13 := FND_API.G_MISS_CHAR;
3612: p_x_line_rec.Industry_attribute14 := FND_API.G_MISS_CHAR;
3613: p_x_line_rec.Industry_attribute15 := FND_API.G_MISS_CHAR;
3614: p_x_line_rec.Industry_attribute16 := FND_API.G_MISS_CHAR;
3607: p_x_line_rec.Industry_attribute9 := FND_API.G_MISS_CHAR;
3608: p_x_line_rec.Industry_attribute10 := FND_API.G_MISS_CHAR;
3609: p_x_line_rec.Industry_attribute11 := FND_API.G_MISS_CHAR;
3610: p_x_line_rec.Industry_attribute12 := FND_API.G_MISS_CHAR;
3611: p_x_line_rec.Industry_attribute13 := FND_API.G_MISS_CHAR;
3612: p_x_line_rec.Industry_attribute14 := FND_API.G_MISS_CHAR;
3613: p_x_line_rec.Industry_attribute15 := FND_API.G_MISS_CHAR;
3614: p_x_line_rec.Industry_attribute16 := FND_API.G_MISS_CHAR;
3615: p_x_line_rec.Industry_attribute17 := FND_API.G_MISS_CHAR;
3608: p_x_line_rec.Industry_attribute10 := FND_API.G_MISS_CHAR;
3609: p_x_line_rec.Industry_attribute11 := FND_API.G_MISS_CHAR;
3610: p_x_line_rec.Industry_attribute12 := FND_API.G_MISS_CHAR;
3611: p_x_line_rec.Industry_attribute13 := FND_API.G_MISS_CHAR;
3612: p_x_line_rec.Industry_attribute14 := FND_API.G_MISS_CHAR;
3613: p_x_line_rec.Industry_attribute15 := FND_API.G_MISS_CHAR;
3614: p_x_line_rec.Industry_attribute16 := FND_API.G_MISS_CHAR;
3615: p_x_line_rec.Industry_attribute17 := FND_API.G_MISS_CHAR;
3616: p_x_line_rec.Industry_attribute18 := FND_API.G_MISS_CHAR;
3609: p_x_line_rec.Industry_attribute11 := FND_API.G_MISS_CHAR;
3610: p_x_line_rec.Industry_attribute12 := FND_API.G_MISS_CHAR;
3611: p_x_line_rec.Industry_attribute13 := FND_API.G_MISS_CHAR;
3612: p_x_line_rec.Industry_attribute14 := FND_API.G_MISS_CHAR;
3613: p_x_line_rec.Industry_attribute15 := FND_API.G_MISS_CHAR;
3614: p_x_line_rec.Industry_attribute16 := FND_API.G_MISS_CHAR;
3615: p_x_line_rec.Industry_attribute17 := FND_API.G_MISS_CHAR;
3616: p_x_line_rec.Industry_attribute18 := FND_API.G_MISS_CHAR;
3617: p_x_line_rec.Industry_attribute19 := FND_API.G_MISS_CHAR;
3610: p_x_line_rec.Industry_attribute12 := FND_API.G_MISS_CHAR;
3611: p_x_line_rec.Industry_attribute13 := FND_API.G_MISS_CHAR;
3612: p_x_line_rec.Industry_attribute14 := FND_API.G_MISS_CHAR;
3613: p_x_line_rec.Industry_attribute15 := FND_API.G_MISS_CHAR;
3614: p_x_line_rec.Industry_attribute16 := FND_API.G_MISS_CHAR;
3615: p_x_line_rec.Industry_attribute17 := FND_API.G_MISS_CHAR;
3616: p_x_line_rec.Industry_attribute18 := FND_API.G_MISS_CHAR;
3617: p_x_line_rec.Industry_attribute19 := FND_API.G_MISS_CHAR;
3618: p_x_line_rec.Industry_attribute20 := FND_API.G_MISS_CHAR;
3611: p_x_line_rec.Industry_attribute13 := FND_API.G_MISS_CHAR;
3612: p_x_line_rec.Industry_attribute14 := FND_API.G_MISS_CHAR;
3613: p_x_line_rec.Industry_attribute15 := FND_API.G_MISS_CHAR;
3614: p_x_line_rec.Industry_attribute16 := FND_API.G_MISS_CHAR;
3615: p_x_line_rec.Industry_attribute17 := FND_API.G_MISS_CHAR;
3616: p_x_line_rec.Industry_attribute18 := FND_API.G_MISS_CHAR;
3617: p_x_line_rec.Industry_attribute19 := FND_API.G_MISS_CHAR;
3618: p_x_line_rec.Industry_attribute20 := FND_API.G_MISS_CHAR;
3619: p_x_line_rec.Industry_attribute21 := FND_API.G_MISS_CHAR;
3612: p_x_line_rec.Industry_attribute14 := FND_API.G_MISS_CHAR;
3613: p_x_line_rec.Industry_attribute15 := FND_API.G_MISS_CHAR;
3614: p_x_line_rec.Industry_attribute16 := FND_API.G_MISS_CHAR;
3615: p_x_line_rec.Industry_attribute17 := FND_API.G_MISS_CHAR;
3616: p_x_line_rec.Industry_attribute18 := FND_API.G_MISS_CHAR;
3617: p_x_line_rec.Industry_attribute19 := FND_API.G_MISS_CHAR;
3618: p_x_line_rec.Industry_attribute20 := FND_API.G_MISS_CHAR;
3619: p_x_line_rec.Industry_attribute21 := FND_API.G_MISS_CHAR;
3620: p_x_line_rec.Industry_attribute22 := FND_API.G_MISS_CHAR;
3613: p_x_line_rec.Industry_attribute15 := FND_API.G_MISS_CHAR;
3614: p_x_line_rec.Industry_attribute16 := FND_API.G_MISS_CHAR;
3615: p_x_line_rec.Industry_attribute17 := FND_API.G_MISS_CHAR;
3616: p_x_line_rec.Industry_attribute18 := FND_API.G_MISS_CHAR;
3617: p_x_line_rec.Industry_attribute19 := FND_API.G_MISS_CHAR;
3618: p_x_line_rec.Industry_attribute20 := FND_API.G_MISS_CHAR;
3619: p_x_line_rec.Industry_attribute21 := FND_API.G_MISS_CHAR;
3620: p_x_line_rec.Industry_attribute22 := FND_API.G_MISS_CHAR;
3621: p_x_line_rec.Industry_attribute23 := FND_API.G_MISS_CHAR;
3614: p_x_line_rec.Industry_attribute16 := FND_API.G_MISS_CHAR;
3615: p_x_line_rec.Industry_attribute17 := FND_API.G_MISS_CHAR;
3616: p_x_line_rec.Industry_attribute18 := FND_API.G_MISS_CHAR;
3617: p_x_line_rec.Industry_attribute19 := FND_API.G_MISS_CHAR;
3618: p_x_line_rec.Industry_attribute20 := FND_API.G_MISS_CHAR;
3619: p_x_line_rec.Industry_attribute21 := FND_API.G_MISS_CHAR;
3620: p_x_line_rec.Industry_attribute22 := FND_API.G_MISS_CHAR;
3621: p_x_line_rec.Industry_attribute23 := FND_API.G_MISS_CHAR;
3622: p_x_line_rec.Industry_attribute24 := FND_API.G_MISS_CHAR;
3615: p_x_line_rec.Industry_attribute17 := FND_API.G_MISS_CHAR;
3616: p_x_line_rec.Industry_attribute18 := FND_API.G_MISS_CHAR;
3617: p_x_line_rec.Industry_attribute19 := FND_API.G_MISS_CHAR;
3618: p_x_line_rec.Industry_attribute20 := FND_API.G_MISS_CHAR;
3619: p_x_line_rec.Industry_attribute21 := FND_API.G_MISS_CHAR;
3620: p_x_line_rec.Industry_attribute22 := FND_API.G_MISS_CHAR;
3621: p_x_line_rec.Industry_attribute23 := FND_API.G_MISS_CHAR;
3622: p_x_line_rec.Industry_attribute24 := FND_API.G_MISS_CHAR;
3623: p_x_line_rec.Industry_attribute25 := FND_API.G_MISS_CHAR;
3616: p_x_line_rec.Industry_attribute18 := FND_API.G_MISS_CHAR;
3617: p_x_line_rec.Industry_attribute19 := FND_API.G_MISS_CHAR;
3618: p_x_line_rec.Industry_attribute20 := FND_API.G_MISS_CHAR;
3619: p_x_line_rec.Industry_attribute21 := FND_API.G_MISS_CHAR;
3620: p_x_line_rec.Industry_attribute22 := FND_API.G_MISS_CHAR;
3621: p_x_line_rec.Industry_attribute23 := FND_API.G_MISS_CHAR;
3622: p_x_line_rec.Industry_attribute24 := FND_API.G_MISS_CHAR;
3623: p_x_line_rec.Industry_attribute25 := FND_API.G_MISS_CHAR;
3624: p_x_line_rec.Industry_attribute26 := FND_API.G_MISS_CHAR;
3617: p_x_line_rec.Industry_attribute19 := FND_API.G_MISS_CHAR;
3618: p_x_line_rec.Industry_attribute20 := FND_API.G_MISS_CHAR;
3619: p_x_line_rec.Industry_attribute21 := FND_API.G_MISS_CHAR;
3620: p_x_line_rec.Industry_attribute22 := FND_API.G_MISS_CHAR;
3621: p_x_line_rec.Industry_attribute23 := FND_API.G_MISS_CHAR;
3622: p_x_line_rec.Industry_attribute24 := FND_API.G_MISS_CHAR;
3623: p_x_line_rec.Industry_attribute25 := FND_API.G_MISS_CHAR;
3624: p_x_line_rec.Industry_attribute26 := FND_API.G_MISS_CHAR;
3625: p_x_line_rec.Industry_attribute27 := FND_API.G_MISS_CHAR;
3618: p_x_line_rec.Industry_attribute20 := FND_API.G_MISS_CHAR;
3619: p_x_line_rec.Industry_attribute21 := FND_API.G_MISS_CHAR;
3620: p_x_line_rec.Industry_attribute22 := FND_API.G_MISS_CHAR;
3621: p_x_line_rec.Industry_attribute23 := FND_API.G_MISS_CHAR;
3622: p_x_line_rec.Industry_attribute24 := FND_API.G_MISS_CHAR;
3623: p_x_line_rec.Industry_attribute25 := FND_API.G_MISS_CHAR;
3624: p_x_line_rec.Industry_attribute26 := FND_API.G_MISS_CHAR;
3625: p_x_line_rec.Industry_attribute27 := FND_API.G_MISS_CHAR;
3626: p_x_line_rec.Industry_attribute28 := FND_API.G_MISS_CHAR;
3619: p_x_line_rec.Industry_attribute21 := FND_API.G_MISS_CHAR;
3620: p_x_line_rec.Industry_attribute22 := FND_API.G_MISS_CHAR;
3621: p_x_line_rec.Industry_attribute23 := FND_API.G_MISS_CHAR;
3622: p_x_line_rec.Industry_attribute24 := FND_API.G_MISS_CHAR;
3623: p_x_line_rec.Industry_attribute25 := FND_API.G_MISS_CHAR;
3624: p_x_line_rec.Industry_attribute26 := FND_API.G_MISS_CHAR;
3625: p_x_line_rec.Industry_attribute27 := FND_API.G_MISS_CHAR;
3626: p_x_line_rec.Industry_attribute28 := FND_API.G_MISS_CHAR;
3627: p_x_line_rec.Industry_attribute29 := FND_API.G_MISS_CHAR;
3620: p_x_line_rec.Industry_attribute22 := FND_API.G_MISS_CHAR;
3621: p_x_line_rec.Industry_attribute23 := FND_API.G_MISS_CHAR;
3622: p_x_line_rec.Industry_attribute24 := FND_API.G_MISS_CHAR;
3623: p_x_line_rec.Industry_attribute25 := FND_API.G_MISS_CHAR;
3624: p_x_line_rec.Industry_attribute26 := FND_API.G_MISS_CHAR;
3625: p_x_line_rec.Industry_attribute27 := FND_API.G_MISS_CHAR;
3626: p_x_line_rec.Industry_attribute28 := FND_API.G_MISS_CHAR;
3627: p_x_line_rec.Industry_attribute29 := FND_API.G_MISS_CHAR;
3628: p_x_line_rec.Industry_attribute30 := FND_API.G_MISS_CHAR;
3621: p_x_line_rec.Industry_attribute23 := FND_API.G_MISS_CHAR;
3622: p_x_line_rec.Industry_attribute24 := FND_API.G_MISS_CHAR;
3623: p_x_line_rec.Industry_attribute25 := FND_API.G_MISS_CHAR;
3624: p_x_line_rec.Industry_attribute26 := FND_API.G_MISS_CHAR;
3625: p_x_line_rec.Industry_attribute27 := FND_API.G_MISS_CHAR;
3626: p_x_line_rec.Industry_attribute28 := FND_API.G_MISS_CHAR;
3627: p_x_line_rec.Industry_attribute29 := FND_API.G_MISS_CHAR;
3628: p_x_line_rec.Industry_attribute30 := FND_API.G_MISS_CHAR;
3629: ELSE
3622: p_x_line_rec.Industry_attribute24 := FND_API.G_MISS_CHAR;
3623: p_x_line_rec.Industry_attribute25 := FND_API.G_MISS_CHAR;
3624: p_x_line_rec.Industry_attribute26 := FND_API.G_MISS_CHAR;
3625: p_x_line_rec.Industry_attribute27 := FND_API.G_MISS_CHAR;
3626: p_x_line_rec.Industry_attribute28 := FND_API.G_MISS_CHAR;
3627: p_x_line_rec.Industry_attribute29 := FND_API.G_MISS_CHAR;
3628: p_x_line_rec.Industry_attribute30 := FND_API.G_MISS_CHAR;
3629: ELSE
3630:
3623: p_x_line_rec.Industry_attribute25 := FND_API.G_MISS_CHAR;
3624: p_x_line_rec.Industry_attribute26 := FND_API.G_MISS_CHAR;
3625: p_x_line_rec.Industry_attribute27 := FND_API.G_MISS_CHAR;
3626: p_x_line_rec.Industry_attribute28 := FND_API.G_MISS_CHAR;
3627: p_x_line_rec.Industry_attribute29 := FND_API.G_MISS_CHAR;
3628: p_x_line_rec.Industry_attribute30 := FND_API.G_MISS_CHAR;
3629: ELSE
3630:
3631: x_return_status := FND_API.G_RET_STS_ERROR;
3624: p_x_line_rec.Industry_attribute26 := FND_API.G_MISS_CHAR;
3625: p_x_line_rec.Industry_attribute27 := FND_API.G_MISS_CHAR;
3626: p_x_line_rec.Industry_attribute28 := FND_API.G_MISS_CHAR;
3627: p_x_line_rec.Industry_attribute29 := FND_API.G_MISS_CHAR;
3628: p_x_line_rec.Industry_attribute30 := FND_API.G_MISS_CHAR;
3629: ELSE
3630:
3631: x_return_status := FND_API.G_RET_STS_ERROR;
3632: END IF;
3627: p_x_line_rec.Industry_attribute29 := FND_API.G_MISS_CHAR;
3628: p_x_line_rec.Industry_attribute30 := FND_API.G_MISS_CHAR;
3629: ELSE
3630:
3631: x_return_status := FND_API.G_RET_STS_ERROR;
3632: END IF;
3633: END IF;
3634:
3635: oe_debug_pub.add('After I_line_desc_flex ' || x_return_status,2);
3695: p_x_line_rec.tp_attribute15 := null;
3696:
3697: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3698:
3699: p_x_line_rec.tp_context := FND_API.G_MISS_CHAR;
3700: p_x_line_rec.tp_attribute1 := FND_API.G_MISS_CHAR;
3701: p_x_line_rec.tp_attribute2 := FND_API.G_MISS_CHAR;
3702: p_x_line_rec.tp_attribute3 := FND_API.G_MISS_CHAR;
3703: p_x_line_rec.tp_attribute4 := FND_API.G_MISS_CHAR;
3696:
3697: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3698:
3699: p_x_line_rec.tp_context := FND_API.G_MISS_CHAR;
3700: p_x_line_rec.tp_attribute1 := FND_API.G_MISS_CHAR;
3701: p_x_line_rec.tp_attribute2 := FND_API.G_MISS_CHAR;
3702: p_x_line_rec.tp_attribute3 := FND_API.G_MISS_CHAR;
3703: p_x_line_rec.tp_attribute4 := FND_API.G_MISS_CHAR;
3704: p_x_line_rec.tp_attribute5 := FND_API.G_MISS_CHAR;
3697: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3698:
3699: p_x_line_rec.tp_context := FND_API.G_MISS_CHAR;
3700: p_x_line_rec.tp_attribute1 := FND_API.G_MISS_CHAR;
3701: p_x_line_rec.tp_attribute2 := FND_API.G_MISS_CHAR;
3702: p_x_line_rec.tp_attribute3 := FND_API.G_MISS_CHAR;
3703: p_x_line_rec.tp_attribute4 := FND_API.G_MISS_CHAR;
3704: p_x_line_rec.tp_attribute5 := FND_API.G_MISS_CHAR;
3705: p_x_line_rec.tp_attribute6 := FND_API.G_MISS_CHAR;
3698:
3699: p_x_line_rec.tp_context := FND_API.G_MISS_CHAR;
3700: p_x_line_rec.tp_attribute1 := FND_API.G_MISS_CHAR;
3701: p_x_line_rec.tp_attribute2 := FND_API.G_MISS_CHAR;
3702: p_x_line_rec.tp_attribute3 := FND_API.G_MISS_CHAR;
3703: p_x_line_rec.tp_attribute4 := FND_API.G_MISS_CHAR;
3704: p_x_line_rec.tp_attribute5 := FND_API.G_MISS_CHAR;
3705: p_x_line_rec.tp_attribute6 := FND_API.G_MISS_CHAR;
3706: p_x_line_rec.tp_attribute7 := FND_API.G_MISS_CHAR;
3699: p_x_line_rec.tp_context := FND_API.G_MISS_CHAR;
3700: p_x_line_rec.tp_attribute1 := FND_API.G_MISS_CHAR;
3701: p_x_line_rec.tp_attribute2 := FND_API.G_MISS_CHAR;
3702: p_x_line_rec.tp_attribute3 := FND_API.G_MISS_CHAR;
3703: p_x_line_rec.tp_attribute4 := FND_API.G_MISS_CHAR;
3704: p_x_line_rec.tp_attribute5 := FND_API.G_MISS_CHAR;
3705: p_x_line_rec.tp_attribute6 := FND_API.G_MISS_CHAR;
3706: p_x_line_rec.tp_attribute7 := FND_API.G_MISS_CHAR;
3707: p_x_line_rec.tp_attribute8 := FND_API.G_MISS_CHAR;
3700: p_x_line_rec.tp_attribute1 := FND_API.G_MISS_CHAR;
3701: p_x_line_rec.tp_attribute2 := FND_API.G_MISS_CHAR;
3702: p_x_line_rec.tp_attribute3 := FND_API.G_MISS_CHAR;
3703: p_x_line_rec.tp_attribute4 := FND_API.G_MISS_CHAR;
3704: p_x_line_rec.tp_attribute5 := FND_API.G_MISS_CHAR;
3705: p_x_line_rec.tp_attribute6 := FND_API.G_MISS_CHAR;
3706: p_x_line_rec.tp_attribute7 := FND_API.G_MISS_CHAR;
3707: p_x_line_rec.tp_attribute8 := FND_API.G_MISS_CHAR;
3708: p_x_line_rec.tp_attribute9 := FND_API.G_MISS_CHAR;
3701: p_x_line_rec.tp_attribute2 := FND_API.G_MISS_CHAR;
3702: p_x_line_rec.tp_attribute3 := FND_API.G_MISS_CHAR;
3703: p_x_line_rec.tp_attribute4 := FND_API.G_MISS_CHAR;
3704: p_x_line_rec.tp_attribute5 := FND_API.G_MISS_CHAR;
3705: p_x_line_rec.tp_attribute6 := FND_API.G_MISS_CHAR;
3706: p_x_line_rec.tp_attribute7 := FND_API.G_MISS_CHAR;
3707: p_x_line_rec.tp_attribute8 := FND_API.G_MISS_CHAR;
3708: p_x_line_rec.tp_attribute9 := FND_API.G_MISS_CHAR;
3709: p_x_line_rec.tp_attribute10 := FND_API.G_MISS_CHAR;
3702: p_x_line_rec.tp_attribute3 := FND_API.G_MISS_CHAR;
3703: p_x_line_rec.tp_attribute4 := FND_API.G_MISS_CHAR;
3704: p_x_line_rec.tp_attribute5 := FND_API.G_MISS_CHAR;
3705: p_x_line_rec.tp_attribute6 := FND_API.G_MISS_CHAR;
3706: p_x_line_rec.tp_attribute7 := FND_API.G_MISS_CHAR;
3707: p_x_line_rec.tp_attribute8 := FND_API.G_MISS_CHAR;
3708: p_x_line_rec.tp_attribute9 := FND_API.G_MISS_CHAR;
3709: p_x_line_rec.tp_attribute10 := FND_API.G_MISS_CHAR;
3710: p_x_line_rec.tp_attribute11 := FND_API.G_MISS_CHAR;
3703: p_x_line_rec.tp_attribute4 := FND_API.G_MISS_CHAR;
3704: p_x_line_rec.tp_attribute5 := FND_API.G_MISS_CHAR;
3705: p_x_line_rec.tp_attribute6 := FND_API.G_MISS_CHAR;
3706: p_x_line_rec.tp_attribute7 := FND_API.G_MISS_CHAR;
3707: p_x_line_rec.tp_attribute8 := FND_API.G_MISS_CHAR;
3708: p_x_line_rec.tp_attribute9 := FND_API.G_MISS_CHAR;
3709: p_x_line_rec.tp_attribute10 := FND_API.G_MISS_CHAR;
3710: p_x_line_rec.tp_attribute11 := FND_API.G_MISS_CHAR;
3711: p_x_line_rec.tp_attribute12 := FND_API.G_MISS_CHAR;
3704: p_x_line_rec.tp_attribute5 := FND_API.G_MISS_CHAR;
3705: p_x_line_rec.tp_attribute6 := FND_API.G_MISS_CHAR;
3706: p_x_line_rec.tp_attribute7 := FND_API.G_MISS_CHAR;
3707: p_x_line_rec.tp_attribute8 := FND_API.G_MISS_CHAR;
3708: p_x_line_rec.tp_attribute9 := FND_API.G_MISS_CHAR;
3709: p_x_line_rec.tp_attribute10 := FND_API.G_MISS_CHAR;
3710: p_x_line_rec.tp_attribute11 := FND_API.G_MISS_CHAR;
3711: p_x_line_rec.tp_attribute12 := FND_API.G_MISS_CHAR;
3712: p_x_line_rec.tp_attribute13 := FND_API.G_MISS_CHAR;
3705: p_x_line_rec.tp_attribute6 := FND_API.G_MISS_CHAR;
3706: p_x_line_rec.tp_attribute7 := FND_API.G_MISS_CHAR;
3707: p_x_line_rec.tp_attribute8 := FND_API.G_MISS_CHAR;
3708: p_x_line_rec.tp_attribute9 := FND_API.G_MISS_CHAR;
3709: p_x_line_rec.tp_attribute10 := FND_API.G_MISS_CHAR;
3710: p_x_line_rec.tp_attribute11 := FND_API.G_MISS_CHAR;
3711: p_x_line_rec.tp_attribute12 := FND_API.G_MISS_CHAR;
3712: p_x_line_rec.tp_attribute13 := FND_API.G_MISS_CHAR;
3713: p_x_line_rec.tp_attribute14 := FND_API.G_MISS_CHAR;
3706: p_x_line_rec.tp_attribute7 := FND_API.G_MISS_CHAR;
3707: p_x_line_rec.tp_attribute8 := FND_API.G_MISS_CHAR;
3708: p_x_line_rec.tp_attribute9 := FND_API.G_MISS_CHAR;
3709: p_x_line_rec.tp_attribute10 := FND_API.G_MISS_CHAR;
3710: p_x_line_rec.tp_attribute11 := FND_API.G_MISS_CHAR;
3711: p_x_line_rec.tp_attribute12 := FND_API.G_MISS_CHAR;
3712: p_x_line_rec.tp_attribute13 := FND_API.G_MISS_CHAR;
3713: p_x_line_rec.tp_attribute14 := FND_API.G_MISS_CHAR;
3714: p_x_line_rec.tp_attribute15 := FND_API.G_MISS_CHAR;
3707: p_x_line_rec.tp_attribute8 := FND_API.G_MISS_CHAR;
3708: p_x_line_rec.tp_attribute9 := FND_API.G_MISS_CHAR;
3709: p_x_line_rec.tp_attribute10 := FND_API.G_MISS_CHAR;
3710: p_x_line_rec.tp_attribute11 := FND_API.G_MISS_CHAR;
3711: p_x_line_rec.tp_attribute12 := FND_API.G_MISS_CHAR;
3712: p_x_line_rec.tp_attribute13 := FND_API.G_MISS_CHAR;
3713: p_x_line_rec.tp_attribute14 := FND_API.G_MISS_CHAR;
3714: p_x_line_rec.tp_attribute15 := FND_API.G_MISS_CHAR;
3715: ELSE
3708: p_x_line_rec.tp_attribute9 := FND_API.G_MISS_CHAR;
3709: p_x_line_rec.tp_attribute10 := FND_API.G_MISS_CHAR;
3710: p_x_line_rec.tp_attribute11 := FND_API.G_MISS_CHAR;
3711: p_x_line_rec.tp_attribute12 := FND_API.G_MISS_CHAR;
3712: p_x_line_rec.tp_attribute13 := FND_API.G_MISS_CHAR;
3713: p_x_line_rec.tp_attribute14 := FND_API.G_MISS_CHAR;
3714: p_x_line_rec.tp_attribute15 := FND_API.G_MISS_CHAR;
3715: ELSE
3716:
3709: p_x_line_rec.tp_attribute10 := FND_API.G_MISS_CHAR;
3710: p_x_line_rec.tp_attribute11 := FND_API.G_MISS_CHAR;
3711: p_x_line_rec.tp_attribute12 := FND_API.G_MISS_CHAR;
3712: p_x_line_rec.tp_attribute13 := FND_API.G_MISS_CHAR;
3713: p_x_line_rec.tp_attribute14 := FND_API.G_MISS_CHAR;
3714: p_x_line_rec.tp_attribute15 := FND_API.G_MISS_CHAR;
3715: ELSE
3716:
3717: x_return_status := FND_API.G_RET_STS_ERROR;
3710: p_x_line_rec.tp_attribute11 := FND_API.G_MISS_CHAR;
3711: p_x_line_rec.tp_attribute12 := FND_API.G_MISS_CHAR;
3712: p_x_line_rec.tp_attribute13 := FND_API.G_MISS_CHAR;
3713: p_x_line_rec.tp_attribute14 := FND_API.G_MISS_CHAR;
3714: p_x_line_rec.tp_attribute15 := FND_API.G_MISS_CHAR;
3715: ELSE
3716:
3717: x_return_status := FND_API.G_RET_STS_ERROR;
3718: END IF;
3713: p_x_line_rec.tp_attribute14 := FND_API.G_MISS_CHAR;
3714: p_x_line_rec.tp_attribute15 := FND_API.G_MISS_CHAR;
3715: ELSE
3716:
3717: x_return_status := FND_API.G_RET_STS_ERROR;
3718: END IF;
3719: END IF;
3720:
3721: --oe_debug_pub.add('After TP_line_desc_flex ' || x_return_status);
3782: p_x_line_rec.Return_attribute15 := null;
3783: p_x_line_rec.Return_attribute10 := null;
3784:
3785: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3786: p_x_line_rec.Return_context := FND_API.G_MISS_CHAR;
3787: p_x_line_rec.Return_attribute1 := FND_API.G_MISS_CHAR;
3788: p_x_line_rec.Return_attribute2 := FND_API.G_MISS_CHAR;
3789: p_x_line_rec.Return_attribute3 := FND_API.G_MISS_CHAR;
3790: p_x_line_rec.Return_attribute4 := FND_API.G_MISS_CHAR;
3783: p_x_line_rec.Return_attribute10 := null;
3784:
3785: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3786: p_x_line_rec.Return_context := FND_API.G_MISS_CHAR;
3787: p_x_line_rec.Return_attribute1 := FND_API.G_MISS_CHAR;
3788: p_x_line_rec.Return_attribute2 := FND_API.G_MISS_CHAR;
3789: p_x_line_rec.Return_attribute3 := FND_API.G_MISS_CHAR;
3790: p_x_line_rec.Return_attribute4 := FND_API.G_MISS_CHAR;
3791: p_x_line_rec.Return_attribute5 := FND_API.G_MISS_CHAR;
3784:
3785: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3786: p_x_line_rec.Return_context := FND_API.G_MISS_CHAR;
3787: p_x_line_rec.Return_attribute1 := FND_API.G_MISS_CHAR;
3788: p_x_line_rec.Return_attribute2 := FND_API.G_MISS_CHAR;
3789: p_x_line_rec.Return_attribute3 := FND_API.G_MISS_CHAR;
3790: p_x_line_rec.Return_attribute4 := FND_API.G_MISS_CHAR;
3791: p_x_line_rec.Return_attribute5 := FND_API.G_MISS_CHAR;
3792: p_x_line_rec.Return_attribute6 := FND_API.G_MISS_CHAR;
3785: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3786: p_x_line_rec.Return_context := FND_API.G_MISS_CHAR;
3787: p_x_line_rec.Return_attribute1 := FND_API.G_MISS_CHAR;
3788: p_x_line_rec.Return_attribute2 := FND_API.G_MISS_CHAR;
3789: p_x_line_rec.Return_attribute3 := FND_API.G_MISS_CHAR;
3790: p_x_line_rec.Return_attribute4 := FND_API.G_MISS_CHAR;
3791: p_x_line_rec.Return_attribute5 := FND_API.G_MISS_CHAR;
3792: p_x_line_rec.Return_attribute6 := FND_API.G_MISS_CHAR;
3793: p_x_line_rec.Return_attribute7 := FND_API.G_MISS_CHAR;
3786: p_x_line_rec.Return_context := FND_API.G_MISS_CHAR;
3787: p_x_line_rec.Return_attribute1 := FND_API.G_MISS_CHAR;
3788: p_x_line_rec.Return_attribute2 := FND_API.G_MISS_CHAR;
3789: p_x_line_rec.Return_attribute3 := FND_API.G_MISS_CHAR;
3790: p_x_line_rec.Return_attribute4 := FND_API.G_MISS_CHAR;
3791: p_x_line_rec.Return_attribute5 := FND_API.G_MISS_CHAR;
3792: p_x_line_rec.Return_attribute6 := FND_API.G_MISS_CHAR;
3793: p_x_line_rec.Return_attribute7 := FND_API.G_MISS_CHAR;
3794: p_x_line_rec.Return_attribute8 := FND_API.G_MISS_CHAR;
3787: p_x_line_rec.Return_attribute1 := FND_API.G_MISS_CHAR;
3788: p_x_line_rec.Return_attribute2 := FND_API.G_MISS_CHAR;
3789: p_x_line_rec.Return_attribute3 := FND_API.G_MISS_CHAR;
3790: p_x_line_rec.Return_attribute4 := FND_API.G_MISS_CHAR;
3791: p_x_line_rec.Return_attribute5 := FND_API.G_MISS_CHAR;
3792: p_x_line_rec.Return_attribute6 := FND_API.G_MISS_CHAR;
3793: p_x_line_rec.Return_attribute7 := FND_API.G_MISS_CHAR;
3794: p_x_line_rec.Return_attribute8 := FND_API.G_MISS_CHAR;
3795: p_x_line_rec.Return_attribute9 := FND_API.G_MISS_CHAR;
3788: p_x_line_rec.Return_attribute2 := FND_API.G_MISS_CHAR;
3789: p_x_line_rec.Return_attribute3 := FND_API.G_MISS_CHAR;
3790: p_x_line_rec.Return_attribute4 := FND_API.G_MISS_CHAR;
3791: p_x_line_rec.Return_attribute5 := FND_API.G_MISS_CHAR;
3792: p_x_line_rec.Return_attribute6 := FND_API.G_MISS_CHAR;
3793: p_x_line_rec.Return_attribute7 := FND_API.G_MISS_CHAR;
3794: p_x_line_rec.Return_attribute8 := FND_API.G_MISS_CHAR;
3795: p_x_line_rec.Return_attribute9 := FND_API.G_MISS_CHAR;
3796: p_x_line_rec.Return_attribute11 := FND_API.G_MISS_CHAR;
3789: p_x_line_rec.Return_attribute3 := FND_API.G_MISS_CHAR;
3790: p_x_line_rec.Return_attribute4 := FND_API.G_MISS_CHAR;
3791: p_x_line_rec.Return_attribute5 := FND_API.G_MISS_CHAR;
3792: p_x_line_rec.Return_attribute6 := FND_API.G_MISS_CHAR;
3793: p_x_line_rec.Return_attribute7 := FND_API.G_MISS_CHAR;
3794: p_x_line_rec.Return_attribute8 := FND_API.G_MISS_CHAR;
3795: p_x_line_rec.Return_attribute9 := FND_API.G_MISS_CHAR;
3796: p_x_line_rec.Return_attribute11 := FND_API.G_MISS_CHAR;
3797: p_x_line_rec.Return_attribute12 := FND_API.G_MISS_CHAR;
3790: p_x_line_rec.Return_attribute4 := FND_API.G_MISS_CHAR;
3791: p_x_line_rec.Return_attribute5 := FND_API.G_MISS_CHAR;
3792: p_x_line_rec.Return_attribute6 := FND_API.G_MISS_CHAR;
3793: p_x_line_rec.Return_attribute7 := FND_API.G_MISS_CHAR;
3794: p_x_line_rec.Return_attribute8 := FND_API.G_MISS_CHAR;
3795: p_x_line_rec.Return_attribute9 := FND_API.G_MISS_CHAR;
3796: p_x_line_rec.Return_attribute11 := FND_API.G_MISS_CHAR;
3797: p_x_line_rec.Return_attribute12 := FND_API.G_MISS_CHAR;
3798: p_x_line_rec.Return_attribute13 := FND_API.G_MISS_CHAR;
3791: p_x_line_rec.Return_attribute5 := FND_API.G_MISS_CHAR;
3792: p_x_line_rec.Return_attribute6 := FND_API.G_MISS_CHAR;
3793: p_x_line_rec.Return_attribute7 := FND_API.G_MISS_CHAR;
3794: p_x_line_rec.Return_attribute8 := FND_API.G_MISS_CHAR;
3795: p_x_line_rec.Return_attribute9 := FND_API.G_MISS_CHAR;
3796: p_x_line_rec.Return_attribute11 := FND_API.G_MISS_CHAR;
3797: p_x_line_rec.Return_attribute12 := FND_API.G_MISS_CHAR;
3798: p_x_line_rec.Return_attribute13 := FND_API.G_MISS_CHAR;
3799: p_x_line_rec.Return_attribute14 := FND_API.G_MISS_CHAR;
3792: p_x_line_rec.Return_attribute6 := FND_API.G_MISS_CHAR;
3793: p_x_line_rec.Return_attribute7 := FND_API.G_MISS_CHAR;
3794: p_x_line_rec.Return_attribute8 := FND_API.G_MISS_CHAR;
3795: p_x_line_rec.Return_attribute9 := FND_API.G_MISS_CHAR;
3796: p_x_line_rec.Return_attribute11 := FND_API.G_MISS_CHAR;
3797: p_x_line_rec.Return_attribute12 := FND_API.G_MISS_CHAR;
3798: p_x_line_rec.Return_attribute13 := FND_API.G_MISS_CHAR;
3799: p_x_line_rec.Return_attribute14 := FND_API.G_MISS_CHAR;
3800: p_x_line_rec.Return_attribute15 := FND_API.G_MISS_CHAR;
3793: p_x_line_rec.Return_attribute7 := FND_API.G_MISS_CHAR;
3794: p_x_line_rec.Return_attribute8 := FND_API.G_MISS_CHAR;
3795: p_x_line_rec.Return_attribute9 := FND_API.G_MISS_CHAR;
3796: p_x_line_rec.Return_attribute11 := FND_API.G_MISS_CHAR;
3797: p_x_line_rec.Return_attribute12 := FND_API.G_MISS_CHAR;
3798: p_x_line_rec.Return_attribute13 := FND_API.G_MISS_CHAR;
3799: p_x_line_rec.Return_attribute14 := FND_API.G_MISS_CHAR;
3800: p_x_line_rec.Return_attribute15 := FND_API.G_MISS_CHAR;
3801: p_x_line_rec.Return_attribute10 := FND_API.G_MISS_CHAR;
3794: p_x_line_rec.Return_attribute8 := FND_API.G_MISS_CHAR;
3795: p_x_line_rec.Return_attribute9 := FND_API.G_MISS_CHAR;
3796: p_x_line_rec.Return_attribute11 := FND_API.G_MISS_CHAR;
3797: p_x_line_rec.Return_attribute12 := FND_API.G_MISS_CHAR;
3798: p_x_line_rec.Return_attribute13 := FND_API.G_MISS_CHAR;
3799: p_x_line_rec.Return_attribute14 := FND_API.G_MISS_CHAR;
3800: p_x_line_rec.Return_attribute15 := FND_API.G_MISS_CHAR;
3801: p_x_line_rec.Return_attribute10 := FND_API.G_MISS_CHAR;
3802: ELSE
3795: p_x_line_rec.Return_attribute9 := FND_API.G_MISS_CHAR;
3796: p_x_line_rec.Return_attribute11 := FND_API.G_MISS_CHAR;
3797: p_x_line_rec.Return_attribute12 := FND_API.G_MISS_CHAR;
3798: p_x_line_rec.Return_attribute13 := FND_API.G_MISS_CHAR;
3799: p_x_line_rec.Return_attribute14 := FND_API.G_MISS_CHAR;
3800: p_x_line_rec.Return_attribute15 := FND_API.G_MISS_CHAR;
3801: p_x_line_rec.Return_attribute10 := FND_API.G_MISS_CHAR;
3802: ELSE
3803:
3796: p_x_line_rec.Return_attribute11 := FND_API.G_MISS_CHAR;
3797: p_x_line_rec.Return_attribute12 := FND_API.G_MISS_CHAR;
3798: p_x_line_rec.Return_attribute13 := FND_API.G_MISS_CHAR;
3799: p_x_line_rec.Return_attribute14 := FND_API.G_MISS_CHAR;
3800: p_x_line_rec.Return_attribute15 := FND_API.G_MISS_CHAR;
3801: p_x_line_rec.Return_attribute10 := FND_API.G_MISS_CHAR;
3802: ELSE
3803:
3804: x_return_status := FND_API.G_RET_STS_ERROR;
3797: p_x_line_rec.Return_attribute12 := FND_API.G_MISS_CHAR;
3798: p_x_line_rec.Return_attribute13 := FND_API.G_MISS_CHAR;
3799: p_x_line_rec.Return_attribute14 := FND_API.G_MISS_CHAR;
3800: p_x_line_rec.Return_attribute15 := FND_API.G_MISS_CHAR;
3801: p_x_line_rec.Return_attribute10 := FND_API.G_MISS_CHAR;
3802: ELSE
3803:
3804: x_return_status := FND_API.G_RET_STS_ERROR;
3805: END IF;
3800: p_x_line_rec.Return_attribute15 := FND_API.G_MISS_CHAR;
3801: p_x_line_rec.Return_attribute10 := FND_API.G_MISS_CHAR;
3802: ELSE
3803:
3804: x_return_status := FND_API.G_RET_STS_ERROR;
3805: END IF;
3806: END IF;
3807:
3808: oe_debug_pub.add('After Return line_desc_flex ' || x_return_status,2);
3818: IF NOT OE_CNCL_Validate.salesrep(p_x_line_rec.salesrep_id) THEN
3819: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3820: p_x_line_rec.salesrep_id := NULL;
3821: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3822: p_x_line_rec.salesrep_id := FND_API.G_MISS_NUM;
3823: ELSE
3824: x_return_status := FND_API.G_RET_STS_ERROR;
3825: END IF;
3826: END IF;
3820: p_x_line_rec.salesrep_id := NULL;
3821: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3822: p_x_line_rec.salesrep_id := FND_API.G_MISS_NUM;
3823: ELSE
3824: x_return_status := FND_API.G_RET_STS_ERROR;
3825: END IF;
3826: END IF;
3827: END IF;
3828:
3831: IF NOT OE_CNCL_Validate.return_reason(p_x_line_rec.return_reason_code) THEN
3832: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3833: p_x_line_rec.return_reason_code := NULL;
3834: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3835: p_x_line_rec.return_reason_code := FND_API.G_MISS_CHAR;
3836: ELSE
3837: x_return_status := FND_API.G_RET_STS_ERROR;
3838: END IF;
3839: END IF;
3833: p_x_line_rec.return_reason_code := NULL;
3834: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3835: p_x_line_rec.return_reason_code := FND_API.G_MISS_CHAR;
3836: ELSE
3837: x_return_status := FND_API.G_RET_STS_ERROR;
3838: END IF;
3839: END IF;
3840: END IF;
3841:
3842: -- Validate Commitment
3843: IF (p_x_line_rec.commitment_id IS NOT NULL)
3844: THEN
3845: IF NOT OE_CNCL_Validate.commitment(p_x_line_rec.commitment_id) THEN
3846: x_return_status := FND_API.G_RET_STS_ERROR;
3847: END IF;
3848: END IF;
3849: oe_debug_pub.add('Exiting procedure OE_CNCL_VALIDATE_line.Attributes',1);
3850:
3849: oe_debug_pub.add('Exiting procedure OE_CNCL_VALIDATE_line.Attributes',1);
3850:
3851: EXCEPTION
3852:
3853: WHEN FND_API.G_EXC_ERROR THEN
3854:
3855: x_return_status := FND_API.G_RET_STS_ERROR;
3856:
3857: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3851: EXCEPTION
3852:
3853: WHEN FND_API.G_EXC_ERROR THEN
3854:
3855: x_return_status := FND_API.G_RET_STS_ERROR;
3856:
3857: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3858:
3859: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3853: WHEN FND_API.G_EXC_ERROR THEN
3854:
3855: x_return_status := FND_API.G_RET_STS_ERROR;
3856:
3857: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3858:
3859: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3860:
3861: WHEN OTHERS THEN
3855: x_return_status := FND_API.G_RET_STS_ERROR;
3856:
3857: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3858:
3859: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3860:
3861: WHEN OTHERS THEN
3862:
3863: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3859: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3860:
3861: WHEN OTHERS THEN
3862:
3863: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3864:
3865: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3866: THEN
3867: OE_MSG_PUB.Add_Exc_Msg
3952: EXCEPTION
3953: WHEN NO_DATA_FOUND THEN
3954: oe_debug_pub.add('get_item_type no data found, bom_item_type : 4', 1);
3955: IF (p_line_rec.top_model_line_ref is not null AND
3956: p_line_rec.top_model_line_ref <> FND_API.G_MISS_CHAR)
3957: OR
3958: (p_line_rec.top_model_line_index is not null AND
3959: p_line_rec.top_model_line_index <> FND_API.G_MISS_NUM)
3960:
3955: IF (p_line_rec.top_model_line_ref is not null AND
3956: p_line_rec.top_model_line_ref <> FND_API.G_MISS_CHAR)
3957: OR
3958: (p_line_rec.top_model_line_index is not null AND
3959: p_line_rec.top_model_line_index <> FND_API.G_MISS_NUM)
3960:
3961: THEN
3962: oe_debug_pub.add(' Before calling check 2');
3963: RETURN OE_GLOBALS.G_ITEM_OPTION;
3995: 'Get_Item_Type'
3996: );
3997: END IF;
3998:
3999: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4000:
4001:
4002: END Get_Item_Type;
4003: