[Home] [Help]
54: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
55: --
56: BEGIN
57:
58: x_return_status := FND_API.G_RET_STS_SUCCESS;
59:
60: -- Check for fields required on a booked order line
61:
62: IF p_line_rec.sold_to_org_id(p_index) IS NULL THEN
59:
60: -- Check for fields required on a booked order line
61:
62: IF p_line_rec.sold_to_org_id(p_index) IS NULL THEN
63: x_return_status := FND_API.G_RET_STS_ERROR;
64: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
65: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
66: OE_Order_UTIL.Get_Attribute_Name('SOLD_TO_ORG_ID'));
67: OE_BULK_MSG_PUB.ADD;
67: OE_BULK_MSG_PUB.ADD;
68: END IF;
69:
70: IF p_line_rec.invoice_to_org_id(p_index) IS NULL THEN
71: x_return_status := FND_API.G_RET_STS_ERROR;
72: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
73: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
74: OE_Order_UTIL.Get_Attribute_Name('INVOICE_TO_ORG_ID'));
75: OE_BULK_MSG_PUB.ADD;
75: OE_BULK_MSG_PUB.ADD;
76: END IF;
77:
78: IF p_line_rec.tax_exempt_flag(p_index) IS NULL THEN
79: x_return_status := FND_API.G_RET_STS_ERROR;
80: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
81: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
82: OE_Order_UTIL.Get_Attribute_Name('TAX_EXEMPT_FLAG'));
83: OE_BULK_MSG_PUB.ADD;
85:
86: -- Quantity and UOM Required
87:
88: IF p_line_rec.order_quantity_uom(p_index) IS NULL THEN
89: x_return_status := FND_API.G_RET_STS_ERROR;
90: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
91: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
92: OE_Order_UTIL.Get_Attribute_Name('ORDER_QUANTITY_UOM'));
93: OE_BULK_MSG_PUB.ADD;
95:
96: -- Fix bug 1277092: ordered quantity should not be = 0 on a booked line
97: IF p_line_rec.ordered_quantity(p_index) IS NULL
98: OR p_line_rec.ordered_quantity(p_index) = 0 THEN
99: x_return_status := FND_API.G_RET_STS_ERROR;
100: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
101: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
102: OE_Order_UTIL.Get_Attribute_Name('ORDERED_QUANTITY'));
103: OE_BULK_MSG_PUB.ADD;
110: IF p_line_rec.line_category_code(p_index)
111: <> OE_GLOBALS.G_RETURN_CATEGORY_CODE THEN
112:
113: IF p_line_rec.ship_to_org_id(p_index) IS NULL THEN
114: x_return_status := FND_API.G_RET_STS_ERROR;
115: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
116: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
117: OE_Order_UTIL.Get_Attribute_Name('SHIP_TO_ORG_ID'));
118: OE_BULK_MSG_PUB.ADD;
118: OE_BULK_MSG_PUB.ADD;
119: END IF;
120:
121: IF p_line_rec.payment_term_id(p_index) IS NULL THEN
122: x_return_status := FND_API.G_RET_STS_ERROR;
123: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
124: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
125: OE_Order_UTIL.Get_Attribute_Name('PAYMENT_TERM_ID'));
126: OE_BULK_MSG_PUB.ADD;
128: --serla
129: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN
130: IF p_line_rec.item_type_code(p_index) <> 'SERVICE' THEN
131: IF p_line_rec.accounting_rule_id(p_index) IS NOT NULL AND
132: p_line_rec.accounting_rule_id(p_index) <> FND_API.G_MISS_NUM THEN
133: IF l_debug_level > 0 THEN
134: oe_debug_pub.add( 'GETTING ACCOUNTING RULE TYPE' ) ;
135: END IF;
136: SELECT type
141: oe_debug_pub.add( 'RULE_TYPE IS :'||L_RULE_TYPE||': ACCOUNTING RULE DURATION IS: '||P_LINE_REC.ACCOUNTING_RULE_DURATION ( P_INDEX ) ) ;
142: END IF;
143: IF l_rule_type = 'ACC_DUR' THEN
144: IF p_line_rec.accounting_rule_duration(p_index) IS NULL THEN
145: x_return_status := FND_API.G_RET_STS_ERROR;
146: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
147: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
148: OE_Order_UTIL.Get_Attribute_Name('ACCOUNTING_RULE_DURATION'));
149: OE_BULK_MSG_PUB.ADD;
160:
161: -- Commenting out as of 1/23/2003 as tax checks not req'd
162: /*
163: IF p_line_rec.tax_date(p_index) IS NULL THEN
164: x_return_status := FND_API.G_RET_STS_ERROR;
165: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
166: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
167: OE_Order_UTIL.Get_Attribute_Name('TAX_DATE'));
168: OE_BULK_MSG_PUB.ADD;
179:
180: IF p_line_rec.calculate_price_flag(p_index) = 'N' THEN
181:
182: IF p_line_rec.price_list_id(p_index) IS NULL THEN
183: x_return_status := FND_API.G_RET_STS_ERROR;
184: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
185: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
186: OE_Order_UTIL.Get_Attribute_Name('PRICE_LIST_ID'));
187: OE_BULK_MSG_PUB.ADD;
199: EXCEPTION
200: WHEN OTHERS THEN
201: oe_debug_pub.add('Others Error, Line.Check_Book_Reqd_Attributes');
202: oe_debug_pub.add(substr(sqlerrm,1,240));
203: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
204: IF OE_BULK_MSG_PUB.Check_Msg_Level(OE_BULK_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
205: THEN
206: OE_BULK_MSG_PUB.Add_Exc_Msg
207: ( G_PKG_NAME
225: l_org_code VARCHAR2(30);
226:
227: BEGIN
228:
229: x_return_status := FND_API.G_RET_STS_SUCCESS;
230:
231: -- Check for Required Scheduling Attributes
232:
233: IF p_line_rec.ordered_quantity(p_index) IS NULL THEN
232:
233: IF p_line_rec.ordered_quantity(p_index) IS NULL THEN
234: FND_MESSAGE.SET_NAME('ONT','OE_SCH_MISSING_QUANTITY');
235: OE_BULK_MSG_PUB.Add;
236: x_return_status := FND_API.G_RET_STS_ERROR;
237: END IF;
238:
239: -- If the quantity on the line is zero(which is different from
240: -- missing) and if the user is trying to performing scheduling,
242:
243: IF p_line_rec.ordered_quantity(p_index) = 0 THEN
244: FND_MESSAGE.SET_NAME('ONT','OE_SCH_ZERO_QTY');
245: OE_BULK_MSG_PUB.Add;
246: x_return_status := FND_API.G_RET_STS_ERROR;
247: END IF;
248:
249: -- No need to check for following statuses: cancelled, shipped, reserved
250: -- qty changes as line is being CREATED.
255:
256: IF p_line_rec.order_quantity_uom(p_index) IS NULL THEN
257: FND_MESSAGE.SET_NAME('ONT','OE_SCH_MISSING_UOM');
258: OE_BULK_MSG_PUB.Add;
259: x_return_status := FND_API.G_RET_STS_ERROR;
260: END IF;
261:
262: -- Item check not required as it is already validated for creation.
263:
267:
268: IF p_line_rec.request_date(p_index) IS NULL THEN
269: FND_MESSAGE.SET_NAME('ONT','OE_SCH_MISSING_REQUEST_DATE');
270: OE_BULK_MSG_PUB.Add;
271: x_return_status := FND_API.G_RET_STS_ERROR;
272: END IF;
273:
274: -- No need to check if line belongs to a set: SETs not supported in BULK mode
275:
298:
299: IF l_debug_level > 0 THEN
300: oe_debug_pub.add( 'OE_SCH_INACTIVE_STD_ONLY' , 1 ) ;
301: END IF;
302: X_return_status := FND_API.G_RET_STS_ERROR;
303: END IF;
304:
305:
306: -- ATO checks for config support
317: OE_BULK_MSG_PUB.Add;
318: IF l_debug_level > 0 THEN
319: oe_debug_pub.add( 'OE_SCH_ATO_WHSE_REQD' , 1 ) ;
320: END IF;
321: x_return_status := FND_API.G_RET_STS_ERROR;
322:
323: END IF;
324: END IF; -- Gop code level
325:
366: oe_debug_pub.add( 'ORGANIZATION CODE:'||L_ORG_CODE , 2 ) ;
367: END IF;
368: FND_MESSAGE.SET_TOKEN('ORG',l_org_code);
369: OE_MSG_PUB.Add;
370: x_return_status := FND_API.G_RET_STS_ERROR;
371:
372: WHEN OTHERS THEN
373: Null;
374: END;
488: WHERE order_source_id = p_line_rec.order_source_id(p_index)
489: AND orig_sys_document_ref = p_line_rec.orig_sys_document_ref(p_index)
490: AND orig_sys_line_ref = p_line_rec.orig_sys_line_ref(p_index)
491: AND org_id = p_line_rec.org_id(p_index)
492: AND (nvl(orig_sys_shipment_ref,fnd_api.g_miss_char)
493: = nvl(p_line_rec.orig_sys_shipment_ref(p_index),fnd_api.g_miss_char)
494: OR -- added to fix bug 5394064
495: p_line_rec.orig_sys_shipment_ref(p_index) = 'OE_ORDER_LINES_ALL'||p_line_rec.line_id(p_index)||'.'||'1')
496: -- Bug 2764130 : there should be only one row for this doc/line ref
489: AND orig_sys_document_ref = p_line_rec.orig_sys_document_ref(p_index)
490: AND orig_sys_line_ref = p_line_rec.orig_sys_line_ref(p_index)
491: AND org_id = p_line_rec.org_id(p_index)
492: AND (nvl(orig_sys_shipment_ref,fnd_api.g_miss_char)
493: = nvl(p_line_rec.orig_sys_shipment_ref(p_index),fnd_api.g_miss_char)
494: OR -- added to fix bug 5394064
495: p_line_rec.orig_sys_shipment_ref(p_index) = 'OE_ORDER_LINES_ALL'||p_line_rec.line_id(p_index)||'.'||'1')
496: -- Bug 2764130 : there should be only one row for this doc/line ref
497: -- combination. If there are multiple rows, it will be errored out in
554: oe_debug_pub.add( 'ERROR IN GETTING CCID' ) ;
555: END IF;
556: failure_message := fnd_flex_ext.get_message;
557: OE_BULK_MSG_PUB.Add_TEXT(failure_message);
558: RAISE FND_API.G_EXC_ERROR;
559: IF l_debug_level > 0 THEN
560: oe_debug_pub.add( 'FAILURE MESSAGE = ' || SUBSTR ( FAILURE_MESSAGE , 1 , 50 ) ) ;
561: END IF;
562: IF l_debug_level > 0 THEN
615: oe_debug_pub.add( 'SOLD TO ORG ID IS MISSING , CAN NOT GET CUST ITEM' ) ;
616: END IF;
617: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_CUSTOMER_ID');
618: OE_BULK_MSG_PUB.Add;
619: RAISE FND_API.G_EXC_ERROR;
620: END IF;
621:
622: INV_CUSTOMER_ITEM_GRP.CI_Attribute_Value(
623: Z_Customer_Item_Id => p_line_rec.ordered_item_id(p_index)
738:
739:
740:
741: EXCEPTION
742: WHEN FND_API.G_EXC_ERROR THEN
743: p_line_rec.lock_control(p_index) := -99;
744: WHEN OTHERS THEN
745: IF l_debug_level > 0 THEN
746: oe_debug_pub.add( 'OTHERS ERROR , LINE.GET_ITEM_INFO' ) ;
754: ( G_PKG_NAME
755: , 'Get_Item_Info'
756: );
757: END IF;
758: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
759: END Get_Item_Info;
760:
761: FUNCTION Validate_Subinventory
762: ( p_subinventory IN VARCHAR2
995: --
996: BEGIN
997: -- validate input quantity
998: IF (p_input_quantity is not null AND
999: p_input_quantity <> FND_API.G_MISS_NUM) THEN
1000:
1001: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' THEN
1002: IF nvl(p_input_quantity, 0) < 0 -- Process HVOP added check for negative as was missing -NB take out when support for RMAs needed
1003:
1323: ( G_PKG_NAME
1324: , 'Unbook_Order'
1325: );
1326: END IF;
1327: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1328: END Unbook_Order;
1329:
1330: PROCEDURE Default_Record
1331: (p_line_rec IN OUT NOCOPY OE_WSH_BULK_GRP.LINE_REC_TYPE
1339: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1340: --
1341: BEGIN
1342:
1343: x_return_status := FND_API.G_RET_STS_SUCCESS;
1344:
1345: -- Validation of defaulted attributes - when to do this, within the
1346: -- cache for each source? YES!
1347:
1398: WHEN NO_DATA_FOUND THEN
1399: IF l_debug_level > 0 THEN
1400: oe_debug_pub.add( 'ITEM CACHE RETURNS NO DATA FOUND' ) ;
1401: END IF;
1402: x_return_status := FND_API.G_RET_STS_ERROR;
1403: END;
1404:
1405: END IF;
1406:
1447: WHEN NO_DATA_FOUND THEN
1448: IF l_debug_level > 0 THEN
1449: oe_debug_pub.add( 'SHIP TO CACHE RETURNS NO DATA FOUND' ) ;
1450: END IF;
1451: x_return_status := FND_API.G_RET_STS_ERROR;
1452: END;
1453:
1454: END IF;
1455:
1567: ( G_PKG_NAME
1568: , 'Default_Record'
1569: );
1570: END IF;
1571: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1572: END Default_Record;
1573:
1574: PROCEDURE Populate_Internal_Fields
1575: (p_line_rec IN OUT NOCOPY OE_WSH_BULK_GRP.LINE_REC_TYPE
1626: OE_Bulk_Order_PVT.g_header_rec.invoice_to_org_id(p_header_index)
1627: THEN
1628: FND_MESSAGE.SET_NAME('ONT','OE_BULK_DIFF_INVOICE_TO');
1629: OE_BULK_MSG_PUB.Add('Y', 'ERROR');
1630: x_return_status := FND_API.G_RET_STS_ERROR;
1631: END IF;
1632:
1633:
1634: -------------------------------------------------------------------
1717: p_sold_to_org_id => p_line_rec.sold_to_org_id(p_index),
1718: x_ordered_item => p_line_rec.ordered_item(p_index)
1719: );
1720:
1721: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1722: x_return_status := FND_API.G_RET_STS_ERROR;
1723: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1724: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1725: END IF;
1718: x_ordered_item => p_line_rec.ordered_item(p_index)
1719: );
1720:
1721: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1722: x_return_status := FND_API.G_RET_STS_ERROR;
1723: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1724: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1725: END IF;
1726:
1719: );
1720:
1721: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1722: x_return_status := FND_API.G_RET_STS_ERROR;
1723: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1724: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1725: END IF;
1726:
1727: END IF;
1720:
1721: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1722: x_return_status := FND_API.G_RET_STS_ERROR;
1723: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1724: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1725: END IF;
1726:
1727: END IF;
1728:
1749: THEN -- Service item type
1750: oe_debug_pub.add( 'Populate_Internal_Fields ab' ) ;
1751: FND_MESSAGE.SET_NAME('ONT','OE_BULK_NOT_SUPP_ITEM_TYPE');
1752: OE_BULK_MSG_PUB.Add('Y', 'ERROR');
1753: x_return_status := FND_API.G_RET_STS_ERROR;
1754: x_unsupported_feature := 'Y';
1755: p_line_rec.lock_control(p_index) := -98;
1756: ELSE
1757: oe_debug_pub.add( 'Populate_Internal_Fields bc' ) ;
1884: THEN
1885: oe_debug_pub.add( 'Populate_Internal_Fields 4a' ) ;
1886: FND_MESSAGE.SET_NAME('ONT','OE_BULK_NOT_SUPP_ITEM_TYPE');
1887: OE_BULK_MSG_PUB.Add('Y', 'ERROR');
1888: x_return_status := FND_API.G_RET_STS_ERROR;
1889: x_unsupported_feature := 'Y';
1890: p_line_rec.lock_control(p_index) := -98;
1891:
1892: ELSE
1961: END IF;
1962:
1963: FND_MESSAGE.SET_NAME('ONT','OE_BULK_OPM_DUAL_QTY_ERROR'); -- HVOP define better OM or GMI error code
1964: OE_BULK_MSG_PUB.Add('Y', 'ERROR');
1965: x_return_status := FND_API.G_RET_STS_ERROR;
1966: END IF;
1967: oe_debug_pub.add( 'Populate_Internal_Fields 6' ) ;
1968: IF l_debug_level > 0 THEN
1969: oe_debug_pub.add( 'out of calculate_dual_quantity 2 ' ) ;
1993: <> 'ORDER'
1994: THEN
1995: FND_MESSAGE.SET_NAME('ONT','OE_BULK_NOT_SUPP_RETURN');
1996: OE_BULK_MSG_PUB.Add('Y', 'ERROR');
1997: x_return_status := FND_API.G_RET_STS_ERROR;
1998: ELSE
1999: p_line_rec.line_category_code(p_index) := 'ORDER';
2000: END IF;
2001:
2018: AND NVL(p_process_tax,'N') <> 'Y'
2019: THEN
2020: FND_MESSAGE.SET_NAME('ONT','OE_BULK_NOT_SUPP_TAX_CAL');
2021: OE_BULK_MSG_PUB.Add('Y', 'ERROR');
2022: x_return_status := FND_API.G_RET_STS_ERROR;
2023: END IF;
2024: */
2025:
2026: -- Invalid line type - error message populated during validation
2027: EXCEPTION
2028: WHEN NO_DATA_FOUND THEN
2029: -- Set line category for insert to succeed
2030: p_line_rec.line_category_code(p_index) := 'ORDER';
2031: x_return_status := FND_API.G_RET_STS_ERROR;
2032:
2033: -- fix bug 5109227
2034: p_line_rec.lock_control(p_index) := -99 ;
2035: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2091: END IF;
2092:
2093: oe_debug_pub.add( 'Populate_Internal_Fields 9' ) ;
2094: EXCEPTION
2095: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2096: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2097: WHEN OTHERS THEN
2098: IF l_debug_level > 0 THEN
2099: oe_debug_pub.add( 'OTHERS ERROR , LINE.POPULATE_INTERNAL_FIELDS' ) ;
2092:
2093: oe_debug_pub.add( 'Populate_Internal_Fields 9' ) ;
2094: EXCEPTION
2095: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2096: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2097: WHEN OTHERS THEN
2098: IF l_debug_level > 0 THEN
2099: oe_debug_pub.add( 'OTHERS ERROR , LINE.POPULATE_INTERNAL_FIELDS' ) ;
2100: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 240 ) ) ;
2098: IF l_debug_level > 0 THEN
2099: oe_debug_pub.add( 'OTHERS ERROR , LINE.POPULATE_INTERNAL_FIELDS' ) ;
2100: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 240 ) ) ;
2101: END IF;
2102: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2103: IF OE_BULK_MSG_PUB.Check_Msg_Level(OE_BULK_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2104: THEN
2105: OE_BULK_MSG_PUB.Add_Exc_Msg
2106: ( G_PKG_NAME
2152: where line_id = p_line_rec.line_id(p_line_index);
2153:
2154: IF nvl(p_line_rec.customer_item_net_price(p_line_index)
2155: ,l_unit_selling_price)
2156: <> nvl(l_unit_selling_price,FND_API.G_MISS_NUM)
2157: THEN
2158:
2159: FND_MESSAGE.SET_NAME('ONT','OE_OI_PRICE_WARNING');
2160: FND_MESSAGE.SET_TOKEN('CUST_PRICE'
2165: END IF;
2166:
2167: IF nvl(p_line_rec.customer_payment_term_id(p_line_index)
2168: ,l_payment_term_id)
2169: <> nvl(l_payment_term_id,FND_API.G_MISS_NUM)
2170: THEN
2171:
2172: FND_MESSAGE.SET_NAME('ONT','OE_OI_PAYMENT_TERM_WARNING');
2173: FND_MESSAGE.SET_TOKEN('CUST_TERM'
2179:
2180: END IF;
2181:
2182: EXCEPTION
2183: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2184: IF l_debug_level > 0 THEN
2185: oe_debug_pub.add( 'UNEXP ERROR , LINE.POST_PROCESS' ) ;
2186: END IF;
2187: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2183: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2184: IF l_debug_level > 0 THEN
2185: oe_debug_pub.add( 'UNEXP ERROR , LINE.POST_PROCESS' ) ;
2186: END IF;
2187: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2188: WHEN OTHERS THEN
2189: IF l_debug_level > 0 THEN
2190: oe_debug_pub.add( 'OTHERS ERROR , LINE.POST_PROCESS' ) ;
2191: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 240 ) ) ;
2196: ( G_PKG_NAME
2197: , 'Post_Process'
2198: );
2199: END IF;
2200: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2201: END Post_Process;
2202:
2203: ---------------------------------------------------------------------
2204: -- PROCEDURE Entity
2433: ,p_header_index => header_counter
2434: ,x_return_status => l_return_status
2435: );
2436:
2437: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2438: p_line_rec.lock_control(l_index) := -99;
2439: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2440: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2441: END IF;
2435: );
2436:
2437: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2438: p_line_rec.lock_control(l_index) := -99;
2439: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2440: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2441: END IF;
2442:
2443: END IF;
2436:
2437: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2438: p_line_rec.lock_control(l_index) := -99;
2439: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2440: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2441: END IF;
2442:
2443: END IF;
2444:
2460: ,x_return_status => l_return_status
2461: );
2462:
2463: oe_debug_pub.add('after Populate_Internal_Fields');
2464: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2465: p_line_rec.lock_control(l_index) := -99;
2466: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2467: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2468: END IF;
2462:
2463: oe_debug_pub.add('after Populate_Internal_Fields');
2464: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2465: p_line_rec.lock_control(l_index) := -99;
2466: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2467: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2468: END IF;
2469:
2470: -- Populating calculate price flag
2463: oe_debug_pub.add('after Populate_Internal_Fields');
2464: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2465: p_line_rec.lock_control(l_index) := -99;
2466: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2467: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2468: END IF;
2469:
2470: -- Populating calculate price flag
2471:
2707:
2708: IF (p_line_rec.ship_from_org_id(l_index)IS NULL) THEN
2709:
2710: IF (p_line_rec.ordered_quantity_uom2(l_index)IS NOT NULL
2711: -- AND p_line_rec.context(l_index) = FND_API.G_MISS_CHAR
2712: )
2713: OR
2714: (p_line_rec.ordered_quantity2(l_index) IS NOT NULL)
2715: OR
2803: fnd_message.set_name('ONT','OE_INVALID_ORDER_QUANTITY_UOM');
2804: fnd_message.set_token('ITEM',p_line_rec.ordered_item(l_index) );
2805: fnd_message.set_token('UOM', l_uom);
2806: OE_BULK_MSG_PUB.Add('Y','ERROR');
2807: --RAISE FND_API.G_EXC_ERROR;
2808: END IF;
2809: EXCEPTION
2810: when no_data_found then
2811: IF l_debug_level > 0 THEN
3316: --service items have the partial period accounting rules attached
3317: --to them.
3318: IF p_line_rec.item_type_code(l_index) <> 'SERVICE' THEN
3319: IF p_line_rec.accounting_rule_id(l_index) IS NOT NULL AND
3320: p_line_rec.accounting_rule_id(l_index) <> FND_API.G_MISS_NUM THEN
3321: IF l_debug_level > 0 THEN
3322: oe_debug_pub.add( 'GETTING ACCOUNTING RULE TYPE' ) ;
3323: END IF;
3324: SELECT type
3579:
3580: ELSE -- if the flex validation is successfull
3581: -- For bug 2511313
3582: IF p_line_rec.context(l_index) IS NULL
3583: OR p_line_rec.context(l_index) = FND_API.G_MISS_CHAR THEN
3584: p_line_rec.context(l_index) := oe_validate.g_context;
3585: END IF;
3586:
3587: IF p_line_rec.attribute1(l_index) IS NULL
3584: p_line_rec.context(l_index) := oe_validate.g_context;
3585: END IF;
3586:
3587: IF p_line_rec.attribute1(l_index) IS NULL
3588: OR p_line_rec.attribute1(l_index) = FND_API.G_MISS_CHAR THEN
3589: p_line_rec.attribute1(l_index) := oe_validate.g_attribute1;
3590: END IF;
3591:
3592: IF p_line_rec.attribute2(l_index) IS NULL
3589: p_line_rec.attribute1(l_index) := oe_validate.g_attribute1;
3590: END IF;
3591:
3592: IF p_line_rec.attribute2(l_index) IS NULL
3593: OR p_line_rec.attribute2(l_index) = FND_API.G_MISS_CHAR THEN
3594: p_line_rec.attribute2(l_index) := oe_validate.g_attribute2;
3595: END IF;
3596:
3597: IF p_line_rec.attribute3(l_index) IS NULL
3594: p_line_rec.attribute2(l_index) := oe_validate.g_attribute2;
3595: END IF;
3596:
3597: IF p_line_rec.attribute3(l_index) IS NULL
3598: OR p_line_rec.attribute3(l_index) = FND_API.G_MISS_CHAR THEN
3599: p_line_rec.attribute3(l_index) := oe_validate.g_attribute3;
3600: END IF;
3601:
3602: IF p_line_rec.attribute4(l_index) IS NULL
3599: p_line_rec.attribute3(l_index) := oe_validate.g_attribute3;
3600: END IF;
3601:
3602: IF p_line_rec.attribute4(l_index) IS NULL
3603: OR p_line_rec.attribute4(l_index) = FND_API.G_MISS_CHAR THEN
3604: p_line_rec.attribute4(l_index) := oe_validate.g_attribute4;
3605: END IF;
3606:
3607: IF p_line_rec.attribute5(l_index) IS NULL
3604: p_line_rec.attribute4(l_index) := oe_validate.g_attribute4;
3605: END IF;
3606:
3607: IF p_line_rec.attribute5(l_index) IS NULL
3608: OR p_line_rec.attribute5(l_index) = FND_API.G_MISS_CHAR THEN
3609: p_line_rec.attribute5(l_index) := oe_validate.g_attribute5;
3610: END IF;
3611:
3612: IF p_line_rec.attribute6(l_index) IS NULL
3609: p_line_rec.attribute5(l_index) := oe_validate.g_attribute5;
3610: END IF;
3611:
3612: IF p_line_rec.attribute6(l_index) IS NULL
3613: OR p_line_rec.attribute6(l_index) = FND_API.G_MISS_CHAR THEN
3614: p_line_rec.attribute6(l_index) := oe_validate.g_attribute6;
3615: END IF;
3616:
3617: IF p_line_rec.attribute7(l_index) IS NULL
3614: p_line_rec.attribute6(l_index) := oe_validate.g_attribute6;
3615: END IF;
3616:
3617: IF p_line_rec.attribute7(l_index) IS NULL
3618: OR p_line_rec.attribute7(l_index) = FND_API.G_MISS_CHAR THEN
3619: p_line_rec.attribute7(l_index) := oe_validate.g_attribute7;
3620: END IF;
3621:
3622: IF p_line_rec.attribute8(l_index) IS NULL
3619: p_line_rec.attribute7(l_index) := oe_validate.g_attribute7;
3620: END IF;
3621:
3622: IF p_line_rec.attribute8(l_index) IS NULL
3623: OR p_line_rec.attribute8(l_index) = FND_API.G_MISS_CHAR THEN
3624: p_line_rec.attribute8(l_index) := oe_validate.g_attribute8;
3625: END IF;
3626:
3627: IF p_line_rec.attribute9(l_index) IS NULL
3624: p_line_rec.attribute8(l_index) := oe_validate.g_attribute8;
3625: END IF;
3626:
3627: IF p_line_rec.attribute9(l_index) IS NULL
3628: OR p_line_rec.attribute9(l_index) = FND_API.G_MISS_CHAR THEN
3629: p_line_rec.attribute9(l_index) := oe_validate.g_attribute9;
3630: END IF;
3631:
3632: IF p_line_rec.attribute10(l_index) IS NULL
3629: p_line_rec.attribute9(l_index) := oe_validate.g_attribute9;
3630: END IF;
3631:
3632: IF p_line_rec.attribute10(l_index) IS NULL
3633: OR p_line_rec.attribute10(l_index) = FND_API.G_MISS_CHAR THEN
3634: p_line_rec.attribute10(l_index) := Oe_validate.G_attribute10;
3635: End IF;
3636:
3637: IF p_line_rec.attribute11(l_index) IS NULL
3634: p_line_rec.attribute10(l_index) := Oe_validate.G_attribute10;
3635: End IF;
3636:
3637: IF p_line_rec.attribute11(l_index) IS NULL
3638: OR p_line_rec.attribute11(l_index) = FND_API.G_MISS_CHAR THEN
3639: p_line_rec.attribute11(l_index) := oe_validate.g_attribute11;
3640: END IF;
3641:
3642: IF p_line_rec.attribute12(l_index) IS NULL
3639: p_line_rec.attribute11(l_index) := oe_validate.g_attribute11;
3640: END IF;
3641:
3642: IF p_line_rec.attribute12(l_index) IS NULL
3643: OR p_line_rec.attribute12(l_index) = FND_API.G_MISS_CHAR THEN
3644: p_line_rec.attribute12(l_index) := oe_validate.g_attribute12;
3645: END IF;
3646:
3647: IF p_line_rec.attribute13(l_index) IS NULL
3644: p_line_rec.attribute12(l_index) := oe_validate.g_attribute12;
3645: END IF;
3646:
3647: IF p_line_rec.attribute13(l_index) IS NULL
3648: OR p_line_rec.attribute13(l_index) = FND_API.G_MISS_CHAR THEN
3649: p_line_rec.attribute13(l_index) := oe_validate.g_attribute13;
3650: END IF;
3651:
3652: IF p_line_rec.attribute14(l_index) IS NULL
3649: p_line_rec.attribute13(l_index) := oe_validate.g_attribute13;
3650: END IF;
3651:
3652: IF p_line_rec.attribute14(l_index) IS NULL
3653: OR p_line_rec.attribute14(l_index) = FND_API.G_MISS_CHAR THEN
3654: p_line_rec.attribute14(l_index) := oe_validate.g_attribute14;
3655: END IF;
3656:
3657: IF p_line_rec.attribute15(l_index) IS NULL
3654: p_line_rec.attribute14(l_index) := oe_validate.g_attribute14;
3655: END IF;
3656:
3657: IF p_line_rec.attribute15(l_index) IS NULL
3658: OR p_line_rec.attribute15(l_index) = FND_API.G_MISS_CHAR THEN
3659: p_line_rec.attribute15(l_index) := oe_validate.g_attribute15;
3660: END IF;
3661:
3662: IF p_line_rec.attribute16(l_index) IS NULL
3659: p_line_rec.attribute15(l_index) := oe_validate.g_attribute15;
3660: END IF;
3661:
3662: IF p_line_rec.attribute16(l_index) IS NULL
3663: OR p_line_rec.attribute16(l_index) = FND_API.G_MISS_CHAR THEN
3664: p_line_rec.attribute16(l_index) := oe_validate.g_attribute16;
3665: END IF;
3666:
3667: IF p_line_rec.attribute17(l_index) IS NULL
3664: p_line_rec.attribute16(l_index) := oe_validate.g_attribute16;
3665: END IF;
3666:
3667: IF p_line_rec.attribute17(l_index) IS NULL
3668: OR p_line_rec.attribute17(l_index) = FND_API.G_MISS_CHAR THEN
3669: p_line_rec.attribute17(l_index) := oe_validate.g_attribute17;
3670: END IF;
3671:
3672: IF p_line_rec.attribute18(l_index) IS NULL
3669: p_line_rec.attribute17(l_index) := oe_validate.g_attribute17;
3670: END IF;
3671:
3672: IF p_line_rec.attribute18(l_index) IS NULL
3673: OR p_line_rec.attribute18(l_index) = FND_API.G_MISS_CHAR THEN
3674: p_line_rec.attribute18(l_index) := oe_validate.g_attribute18;
3675: END IF;
3676:
3677: IF p_line_rec.attribute19(l_index) IS NULL
3674: p_line_rec.attribute18(l_index) := oe_validate.g_attribute18;
3675: END IF;
3676:
3677: IF p_line_rec.attribute19(l_index) IS NULL
3678: OR p_line_rec.attribute19(l_index) = FND_API.G_MISS_CHAR THEN
3679: p_line_rec.attribute19(l_index) := oe_validate.g_attribute19;
3680: END IF;
3681:
3682: IF p_line_rec.attribute20(l_index) IS NULL
3679: p_line_rec.attribute19(l_index) := oe_validate.g_attribute19;
3680: END IF;
3681:
3682: IF p_line_rec.attribute20(l_index) IS NULL
3683: OR p_line_rec.attribute20(l_index) = FND_API.G_MISS_CHAR THEN
3684: p_line_rec.attribute20(l_index) := oe_validate.g_attribute20;
3685: END IF;
3686: -- end of assignments, bug 2511313
3687:
3730:
3731: ELSE -- for bug 2511313
3732:
3733: IF p_line_rec.industry_context(l_index) IS NULL
3734: OR p_line_rec.industry_context(l_index) = FND_API.G_MISS_CHAR THEN
3735: p_line_rec.industry_context(l_index) := oe_validate.g_context;
3736: END IF;
3737:
3738: IF p_line_rec.industry_attribute1(l_index) IS NULL
3735: p_line_rec.industry_context(l_index) := oe_validate.g_context;
3736: END IF;
3737:
3738: IF p_line_rec.industry_attribute1(l_index) IS NULL
3739: OR p_line_rec.industry_attribute1(l_index) = FND_API.G_MISS_CHAR THEN
3740: p_line_rec.industry_attribute1(l_index) := oe_validate.g_attribute1;
3741: END IF;
3742:
3743: IF p_line_rec.industry_attribute2(l_index) IS NULL
3740: p_line_rec.industry_attribute1(l_index) := oe_validate.g_attribute1;
3741: END IF;
3742:
3743: IF p_line_rec.industry_attribute2(l_index) IS NULL
3744: OR p_line_rec.industry_attribute2(l_index) = FND_API.G_MISS_CHAR THEN
3745: p_line_rec.industry_attribute2(l_index) := oe_validate.g_attribute2;
3746: END IF;
3747:
3748: IF p_line_rec.industry_attribute3(l_index) IS NULL
3745: p_line_rec.industry_attribute2(l_index) := oe_validate.g_attribute2;
3746: END IF;
3747:
3748: IF p_line_rec.industry_attribute3(l_index) IS NULL
3749: OR p_line_rec.industry_attribute3(l_index) = FND_API.G_MISS_CHAR THEN
3750: p_line_rec.industry_attribute3(l_index) := oe_validate.g_attribute3;
3751: END IF;
3752:
3753: IF p_line_rec.industry_attribute4(l_index) IS NULL
3750: p_line_rec.industry_attribute3(l_index) := oe_validate.g_attribute3;
3751: END IF;
3752:
3753: IF p_line_rec.industry_attribute4(l_index) IS NULL
3754: OR p_line_rec.industry_attribute4(l_index) = FND_API.G_MISS_CHAR THEN
3755: p_line_rec.industry_attribute4(l_index) := oe_validate.g_attribute4;
3756: END IF;
3757:
3758: IF p_line_rec.industry_attribute5(l_index) IS NULL
3755: p_line_rec.industry_attribute4(l_index) := oe_validate.g_attribute4;
3756: END IF;
3757:
3758: IF p_line_rec.industry_attribute5(l_index) IS NULL
3759: OR p_line_rec.industry_attribute5(l_index) = FND_API.G_MISS_CHAR THEN
3760: p_line_rec.industry_attribute5(l_index) := oe_validate.g_attribute5;
3761: END IF;
3762:
3763: IF p_line_rec.industry_attribute6(l_index) IS NULL
3760: p_line_rec.industry_attribute5(l_index) := oe_validate.g_attribute5;
3761: END IF;
3762:
3763: IF p_line_rec.industry_attribute6(l_index) IS NULL
3764: OR p_line_rec.industry_attribute6(l_index) = FND_API.G_MISS_CHAR THEN
3765: p_line_rec.industry_attribute6(l_index) := oe_validate.g_attribute6;
3766: END IF;
3767:
3768: IF p_line_rec.industry_attribute7(l_index) IS NULL
3765: p_line_rec.industry_attribute6(l_index) := oe_validate.g_attribute6;
3766: END IF;
3767:
3768: IF p_line_rec.industry_attribute7(l_index) IS NULL
3769: OR p_line_rec.industry_attribute7(l_index) = FND_API.G_MISS_CHAR THEN
3770: p_line_rec.industry_attribute7(l_index) := oe_validate.g_attribute7;
3771: END IF;
3772:
3773: IF p_line_rec.industry_attribute8(l_index) IS NULL
3770: p_line_rec.industry_attribute7(l_index) := oe_validate.g_attribute7;
3771: END IF;
3772:
3773: IF p_line_rec.industry_attribute8(l_index) IS NULL
3774: OR p_line_rec.industry_attribute8(l_index) = FND_API.G_MISS_CHAR THEN
3775: p_line_rec.industry_attribute8(l_index) := oe_validate.g_attribute8;
3776: END IF;
3777:
3778: IF p_line_rec.industry_attribute9(l_index) IS NULL
3775: p_line_rec.industry_attribute8(l_index) := oe_validate.g_attribute8;
3776: END IF;
3777:
3778: IF p_line_rec.industry_attribute9(l_index) IS NULL
3779: OR p_line_rec.industry_attribute9(l_index) = FND_API.G_MISS_CHAR THEN
3780: p_line_rec.industry_attribute9(l_index) := oe_validate.g_attribute9;
3781: END IF;
3782:
3783: IF p_line_rec.industry_attribute10(l_index) IS NULL
3780: p_line_rec.industry_attribute9(l_index) := oe_validate.g_attribute9;
3781: END IF;
3782:
3783: IF p_line_rec.industry_attribute10(l_index) IS NULL
3784: OR p_line_rec.industry_attribute10(l_index) = FND_API.G_MISS_CHAR THEN
3785: p_line_rec.industry_attribute10(l_index) := oe_validate.g_attribute10;
3786: END IF;
3787:
3788: IF p_line_rec.industry_attribute11(l_index) IS NULL
3785: p_line_rec.industry_attribute10(l_index) := oe_validate.g_attribute10;
3786: END IF;
3787:
3788: IF p_line_rec.industry_attribute11(l_index) IS NULL
3789: OR p_line_rec.industry_attribute11(l_index) = FND_API.G_MISS_CHAR THEN
3790: p_line_rec.industry_attribute11(l_index) := oe_validate.g_attribute11;
3791: END IF;
3792:
3793: IF p_line_rec.industry_attribute12(l_index) IS NULL
3790: p_line_rec.industry_attribute11(l_index) := oe_validate.g_attribute11;
3791: END IF;
3792:
3793: IF p_line_rec.industry_attribute12(l_index) IS NULL
3794: OR p_line_rec.industry_attribute12(l_index) = FND_API.G_MISS_CHAR THEN
3795: p_line_rec.industry_attribute12(l_index) := oe_validate.g_attribute12;
3796: END IF;
3797:
3798: IF p_line_rec.industry_attribute13(l_index) IS NULL
3795: p_line_rec.industry_attribute12(l_index) := oe_validate.g_attribute12;
3796: END IF;
3797:
3798: IF p_line_rec.industry_attribute13(l_index) IS NULL
3799: OR p_line_rec.industry_attribute13(l_index) = FND_API.G_MISS_CHAR THEN
3800: p_line_rec.industry_attribute13(l_index) := oe_validate.g_attribute13;
3801: END IF;
3802:
3803: IF p_line_rec.industry_attribute14(l_index) IS NULL
3800: p_line_rec.industry_attribute13(l_index) := oe_validate.g_attribute13;
3801: END IF;
3802:
3803: IF p_line_rec.industry_attribute14(l_index) IS NULL
3804: OR p_line_rec.industry_attribute14(l_index) = FND_API.G_MISS_CHAR THEN
3805: p_line_rec.industry_attribute14(l_index) := oe_validate.g_attribute14;
3806: END IF;
3807:
3808: IF p_line_rec.industry_attribute15(l_index) IS NULL
3805: p_line_rec.industry_attribute14(l_index) := oe_validate.g_attribute14;
3806: END IF;
3807:
3808: IF p_line_rec.industry_attribute15(l_index) IS NULL
3809: OR p_line_rec.industry_attribute15(l_index) = FND_API.G_MISS_CHAR THEN
3810: p_line_rec.industry_attribute15(l_index) := oe_validate.g_attribute15;
3811: END IF;
3812:
3813: IF p_line_rec.industry_attribute16(l_index) IS NULL
3810: p_line_rec.industry_attribute15(l_index) := oe_validate.g_attribute15;
3811: END IF;
3812:
3813: IF p_line_rec.industry_attribute16(l_index) IS NULL
3814: OR p_line_rec.industry_attribute16(l_index) = FND_API.G_MISS_CHAR THEN
3815: p_line_rec.industry_attribute16(l_index) := oe_validate.g_attribute16;
3816: END IF;
3817:
3818: IF p_line_rec.industry_attribute17(l_index) IS NULL
3815: p_line_rec.industry_attribute16(l_index) := oe_validate.g_attribute16;
3816: END IF;
3817:
3818: IF p_line_rec.industry_attribute17(l_index) IS NULL
3819: OR p_line_rec.industry_attribute17(l_index) = FND_API.G_MISS_CHAR THEN
3820: p_line_rec.industry_attribute17(l_index) := oe_validate.g_attribute17;
3821: END IF;
3822:
3823: IF p_line_rec.industry_attribute18(l_index) IS NULL
3820: p_line_rec.industry_attribute17(l_index) := oe_validate.g_attribute17;
3821: END IF;
3822:
3823: IF p_line_rec.industry_attribute18(l_index) IS NULL
3824: OR p_line_rec.industry_attribute18(l_index) = FND_API.G_MISS_CHAR THEN
3825: p_line_rec.industry_attribute18(l_index) := oe_validate.g_attribute18;
3826: END IF;
3827:
3828: IF p_line_rec.industry_attribute19(l_index) IS NULL
3825: p_line_rec.industry_attribute18(l_index) := oe_validate.g_attribute18;
3826: END IF;
3827:
3828: IF p_line_rec.industry_attribute19(l_index) IS NULL
3829: OR p_line_rec.industry_attribute19(l_index) = FND_API.G_MISS_CHAR THEN
3830: p_line_rec.industry_attribute19(l_index) := oe_validate.g_attribute19;
3831: END IF;
3832:
3833: IF p_line_rec.industry_attribute20(l_index) IS NULL
3830: p_line_rec.industry_attribute19(l_index) := oe_validate.g_attribute19;
3831: END IF;
3832:
3833: IF p_line_rec.industry_attribute20(l_index) IS NULL
3834: OR p_line_rec.industry_attribute20(l_index) = FND_API.G_MISS_CHAR THEN
3835: p_line_rec.industry_attribute20(l_index) := oe_validate.g_attribute20;
3836: END IF;
3837:
3838: IF p_line_rec.industry_attribute21(l_index) IS NULL
3835: p_line_rec.industry_attribute20(l_index) := oe_validate.g_attribute20;
3836: END IF;
3837:
3838: IF p_line_rec.industry_attribute21(l_index) IS NULL
3839: OR p_line_rec.industry_attribute21(l_index) = FND_API.G_MISS_CHAR THEN
3840: p_line_rec.industry_attribute21(l_index) := oe_validate.g_attribute21;
3841: END IF;
3842:
3843: IF p_line_rec.industry_attribute22(l_index) IS NULL
3840: p_line_rec.industry_attribute21(l_index) := oe_validate.g_attribute21;
3841: END IF;
3842:
3843: IF p_line_rec.industry_attribute22(l_index) IS NULL
3844: OR p_line_rec.industry_attribute22(l_index) = FND_API.G_MISS_CHAR THEN
3845: p_line_rec.industry_attribute22(l_index) := oe_validate.g_attribute22;
3846: END IF;
3847:
3848: IF p_line_rec.industry_attribute23(l_index) IS NULL
3845: p_line_rec.industry_attribute22(l_index) := oe_validate.g_attribute22;
3846: END IF;
3847:
3848: IF p_line_rec.industry_attribute23(l_index) IS NULL
3849: OR p_line_rec.industry_attribute23(l_index) = FND_API.G_MISS_CHAR THEN
3850: p_line_rec.industry_attribute23(l_index) := oe_validate.g_attribute23;
3851: END IF;
3852:
3853: IF p_line_rec.industry_attribute24(l_index) IS NULL
3850: p_line_rec.industry_attribute23(l_index) := oe_validate.g_attribute23;
3851: END IF;
3852:
3853: IF p_line_rec.industry_attribute24(l_index) IS NULL
3854: OR p_line_rec.industry_attribute24(l_index) = FND_API.G_MISS_CHAR THEN
3855: p_line_rec.industry_attribute24(l_index) := oe_validate.g_attribute24;
3856: END IF;
3857:
3858: IF p_line_rec.industry_attribute25(l_index) IS NULL
3855: p_line_rec.industry_attribute24(l_index) := oe_validate.g_attribute24;
3856: END IF;
3857:
3858: IF p_line_rec.industry_attribute25(l_index) IS NULL
3859: OR p_line_rec.industry_attribute25(l_index) = FND_API.G_MISS_CHAR THEN
3860: p_line_rec.industry_attribute25(l_index) := oe_validate.g_attribute25;
3861: END IF;
3862:
3863: IF p_line_rec.industry_attribute26(l_index) IS NULL
3860: p_line_rec.industry_attribute25(l_index) := oe_validate.g_attribute25;
3861: END IF;
3862:
3863: IF p_line_rec.industry_attribute26(l_index) IS NULL
3864: OR p_line_rec.industry_attribute26(l_index) = FND_API.G_MISS_CHAR THEN
3865: p_line_rec.industry_attribute26(l_index) := oe_validate.g_attribute26;
3866: END IF;
3867:
3868: IF p_line_rec.industry_attribute27(l_index) IS NULL
3865: p_line_rec.industry_attribute26(l_index) := oe_validate.g_attribute26;
3866: END IF;
3867:
3868: IF p_line_rec.industry_attribute27(l_index) IS NULL
3869: OR p_line_rec.industry_attribute27(l_index) = FND_API.G_MISS_CHAR THEN
3870: p_line_rec.industry_attribute27(l_index) := oe_validate.g_attribute27;
3871: END IF;
3872:
3873: IF p_line_rec.industry_attribute28(l_index) IS NULL
3870: p_line_rec.industry_attribute27(l_index) := oe_validate.g_attribute27;
3871: END IF;
3872:
3873: IF p_line_rec.industry_attribute28(l_index) IS NULL
3874: OR p_line_rec.industry_attribute28(l_index) = FND_API.G_MISS_CHAR THEN
3875: p_line_rec.industry_attribute28(l_index) := oe_validate.g_attribute28;
3876: END IF;
3877:
3878: IF p_line_rec.industry_attribute29(l_index) IS NULL
3875: p_line_rec.industry_attribute28(l_index) := oe_validate.g_attribute28;
3876: END IF;
3877:
3878: IF p_line_rec.industry_attribute29(l_index) IS NULL
3879: OR p_line_rec.industry_attribute29(l_index) = FND_API.G_MISS_CHAR THEN
3880: p_line_rec.industry_attribute29(l_index) := oe_validate.g_attribute29;
3881: END IF;
3882:
3883: IF p_line_rec.industry_attribute30(l_index) IS NULL
3880: p_line_rec.industry_attribute29(l_index) := oe_validate.g_attribute29;
3881: END IF;
3882:
3883: IF p_line_rec.industry_attribute30(l_index) IS NULL
3884: OR p_line_rec.industry_attribute30(l_index) = FND_API.G_MISS_CHAR THEN
3885: p_line_rec.industry_attribute30(l_index) := oe_validate.g_attribute30;
3886: END IF;
3887:
3888: -- end of bug 2511313
3917:
3918: ELSE -- if the flex validation is successfull
3919: -- For bug 2511313
3920: IF p_line_rec.tp_context(l_index) IS NULL
3921: OR p_line_rec.tp_context(l_index) = FND_API.G_MISS_CHAR THEN
3922: p_line_rec.tp_context(l_index) := oe_validate.g_context;
3923: END IF;
3924:
3925: IF p_line_rec.tp_attribute1(l_index) IS NULL
3922: p_line_rec.tp_context(l_index) := oe_validate.g_context;
3923: END IF;
3924:
3925: IF p_line_rec.tp_attribute1(l_index) IS NULL
3926: OR p_line_rec.tp_attribute1(l_index) = FND_API.G_MISS_CHAR THEN
3927: p_line_rec.tp_attribute1(l_index) := oe_validate.g_attribute1;
3928: END IF;
3929:
3930: IF p_line_rec.tp_attribute2(l_index) IS NULL
3927: p_line_rec.tp_attribute1(l_index) := oe_validate.g_attribute1;
3928: END IF;
3929:
3930: IF p_line_rec.tp_attribute2(l_index) IS NULL
3931: OR p_line_rec.tp_attribute2(l_index) = FND_API.G_MISS_CHAR THEN
3932: p_line_rec.tp_attribute2(l_index) := oe_validate.g_attribute2;
3933: END IF;
3934:
3935: IF p_line_rec.tp_attribute3(l_index) IS NULL
3932: p_line_rec.tp_attribute2(l_index) := oe_validate.g_attribute2;
3933: END IF;
3934:
3935: IF p_line_rec.tp_attribute3(l_index) IS NULL
3936: OR p_line_rec.tp_attribute3(l_index) = FND_API.G_MISS_CHAR THEN
3937: p_line_rec.tp_attribute3(l_index) := oe_validate.g_attribute3;
3938: END IF;
3939:
3940: IF p_line_rec.tp_attribute4(l_index) IS NULL
3937: p_line_rec.tp_attribute3(l_index) := oe_validate.g_attribute3;
3938: END IF;
3939:
3940: IF p_line_rec.tp_attribute4(l_index) IS NULL
3941: OR p_line_rec.tp_attribute4(l_index) = FND_API.G_MISS_CHAR THEN
3942: p_line_rec.tp_attribute4(l_index) := oe_validate.g_attribute4;
3943: END IF;
3944:
3945: IF p_line_rec.tp_attribute5(l_index) IS NULL
3942: p_line_rec.tp_attribute4(l_index) := oe_validate.g_attribute4;
3943: END IF;
3944:
3945: IF p_line_rec.tp_attribute5(l_index) IS NULL
3946: OR p_line_rec.tp_attribute5(l_index) = FND_API.G_MISS_CHAR THEN
3947: p_line_rec.tp_attribute5(l_index) := oe_validate.g_attribute5;
3948: END IF;
3949:
3950: IF p_line_rec.tp_attribute6(l_index) IS NULL
3947: p_line_rec.tp_attribute5(l_index) := oe_validate.g_attribute5;
3948: END IF;
3949:
3950: IF p_line_rec.tp_attribute6(l_index) IS NULL
3951: OR p_line_rec.tp_attribute6(l_index) = FND_API.G_MISS_CHAR THEN
3952: p_line_rec.tp_attribute6(l_index) := oe_validate.g_attribute6;
3953: END IF;
3954:
3955: IF p_line_rec.tp_attribute7(l_index) IS NULL
3952: p_line_rec.tp_attribute6(l_index) := oe_validate.g_attribute6;
3953: END IF;
3954:
3955: IF p_line_rec.tp_attribute7(l_index) IS NULL
3956: OR p_line_rec.tp_attribute7(l_index) = FND_API.G_MISS_CHAR THEN
3957: p_line_rec.tp_attribute7(l_index) := oe_validate.g_attribute7;
3958: END IF;
3959:
3960: IF p_line_rec.tp_attribute8(l_index) IS NULL
3957: p_line_rec.tp_attribute7(l_index) := oe_validate.g_attribute7;
3958: END IF;
3959:
3960: IF p_line_rec.tp_attribute8(l_index) IS NULL
3961: OR p_line_rec.tp_attribute8(l_index) = FND_API.G_MISS_CHAR THEN
3962: p_line_rec.tp_attribute8(l_index) := oe_validate.g_attribute8;
3963: END IF;
3964:
3965: IF p_line_rec.tp_attribute9(l_index) IS NULL
3962: p_line_rec.tp_attribute8(l_index) := oe_validate.g_attribute8;
3963: END IF;
3964:
3965: IF p_line_rec.tp_attribute9(l_index) IS NULL
3966: OR p_line_rec.tp_attribute9(l_index) = FND_API.G_MISS_CHAR THEN
3967: p_line_rec.tp_attribute9(l_index) := oe_validate.g_attribute9;
3968: END IF;
3969:
3970: IF p_line_rec.tp_attribute10(l_index) IS NULL
3967: p_line_rec.tp_attribute9(l_index) := oe_validate.g_attribute9;
3968: END IF;
3969:
3970: IF p_line_rec.tp_attribute10(l_index) IS NULL
3971: OR p_line_rec.tp_attribute10(l_index) = FND_API.G_MISS_CHAR THEN
3972: p_line_rec.tp_attribute10(l_index) := Oe_validate.G_attribute10;
3973: End IF;
3974:
3975: IF p_line_rec.tp_attribute11(l_index) IS NULL
3972: p_line_rec.tp_attribute10(l_index) := Oe_validate.G_attribute10;
3973: End IF;
3974:
3975: IF p_line_rec.tp_attribute11(l_index) IS NULL
3976: OR p_line_rec.tp_attribute11(l_index) = FND_API.G_MISS_CHAR THEN
3977: p_line_rec.tp_attribute11(l_index) := oe_validate.g_attribute11;
3978: END IF;
3979:
3980: IF p_line_rec.tp_attribute12(l_index) IS NULL
3977: p_line_rec.tp_attribute11(l_index) := oe_validate.g_attribute11;
3978: END IF;
3979:
3980: IF p_line_rec.tp_attribute12(l_index) IS NULL
3981: OR p_line_rec.tp_attribute12(l_index) = FND_API.G_MISS_CHAR THEN
3982: p_line_rec.tp_attribute12(l_index) := oe_validate.g_attribute12;
3983: END IF;
3984:
3985: IF p_line_rec.tp_attribute13(l_index) IS NULL
3982: p_line_rec.tp_attribute12(l_index) := oe_validate.g_attribute12;
3983: END IF;
3984:
3985: IF p_line_rec.tp_attribute13(l_index) IS NULL
3986: OR p_line_rec.tp_attribute13(l_index) = FND_API.G_MISS_CHAR THEN
3987: p_line_rec.tp_attribute13(l_index) := oe_validate.g_attribute13;
3988: END IF;
3989:
3990: IF p_line_rec.tp_attribute14(l_index) IS NULL
3987: p_line_rec.tp_attribute13(l_index) := oe_validate.g_attribute13;
3988: END IF;
3989:
3990: IF p_line_rec.tp_attribute14(l_index) IS NULL
3991: OR p_line_rec.tp_attribute14(l_index) = FND_API.G_MISS_CHAR THEN
3992: p_line_rec.tp_attribute14(l_index) := oe_validate.g_attribute14;
3993: END IF;
3994:
3995: IF p_line_rec.tp_attribute15(l_index) IS NULL
3992: p_line_rec.tp_attribute14(l_index) := oe_validate.g_attribute14;
3993: END IF;
3994:
3995: IF p_line_rec.tp_attribute15(l_index) IS NULL
3996: OR p_line_rec.tp_attribute15(l_index) = FND_API.G_MISS_CHAR THEN
3997: p_line_rec.tp_attribute15(l_index) := oe_validate.g_attribute15;
3998: END IF;
3999: -- end of assignments, bug 2511313
4000:
4154: Check_Book_Reqd_Attributes(p_line_rec => p_line_rec
4155: ,p_index => l_index
4156: ,x_return_status => l_return_status);
4157:
4158: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4159: l_book_failed := TRUE;
4160: END IF;
4161:
4162: END IF;
4204: Check_Scheduling_Attributes(p_line_rec => p_line_rec
4205: ,p_index =>l_index
4206: ,x_return_status => l_return_status);
4207:
4208: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
4209:
4210: IF OE_BULK_CACHE.G_LINE_TYPE_TBL(l_d_index).scheduling_level_code = 'FOUR'
4211: OR OE_BULK_CACHE.G_LINE_TYPE_TBL(l_d_index).scheduling_level_code = 'FIVE'
4212: THEN
4413: l_book_failed := FALSE;
4414: END IF;
4415:
4416: EXCEPTION
4417: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4418: IF l_debug_level > 0 THEN
4419: oe_debug_pub.add( 'UNEXP ERROR , LINE.ENTITY' ) ;
4420: END IF;
4421: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4417: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4418: IF l_debug_level > 0 THEN
4419: oe_debug_pub.add( 'UNEXP ERROR , LINE.ENTITY' ) ;
4420: END IF;
4421: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4422: WHEN OTHERS THEN
4423: IF l_debug_level > 0 THEN
4424: oe_debug_pub.add( 'OTHERS ERROR , LINE.ENTITY' ) ;
4425: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 240 ) ) ;
4430: ( G_PKG_NAME
4431: , 'Entity'
4432: );
4433: END IF;
4434: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4435: END Entity;
4436:
4437: -- HVOP below routine is for Dual control items support INVCONV
4438:
4468:
4469: /* If neither quantity is present, then error as only called for a process type 1,2,or 3 ite m */
4470:
4471: IF (p_line_rec.ordered_quantity(p_index) IS NULL OR
4472: p_line_rec.ordered_quantity(p_index) = FND_API.G_MISS_NUM ) AND
4473: (p_line_rec.ordered_quantity2(p_index) IS NULL OR
4474: p_line_rec.ordered_quantity2(p_index) = FND_API.G_MISS_NUM ) THEN
4475: p_x_return_status := -1;
4476: IF l_debug_level > 0 THEN
4470:
4471: IF (p_line_rec.ordered_quantity(p_index) IS NULL OR
4472: p_line_rec.ordered_quantity(p_index) = FND_API.G_MISS_NUM ) AND
4473: (p_line_rec.ordered_quantity2(p_index) IS NULL OR
4474: p_line_rec.ordered_quantity2(p_index) = FND_API.G_MISS_NUM ) THEN
4475: p_x_return_status := -1;
4476: IF l_debug_level > 0 THEN
4477: oe_debug_pub.add ('calculate_dual_qty- both quantities empty so error ', 3);
4478: END IF;
4830: oe_debug_pub.add('Exception handling: UOM_CONVERSION_FAILED in calculate_dual_qauntity', 1);
4831: FND_MESSAGE.SET_NAME('INV','INV_NO_CONVERSION_ERR'); -- INVCONV
4832: OE_BULK_MSG_PUB.Add('Y', 'ERROR');
4833:
4834: RAISE FND_API.G_EXC_ERROR;
4835:
4836: WHEN TOLERANCE_ERROR THEN -- INVCONV
4837: oe_debug_pub.add('Exception handling: TOLERANCE_ERROR in calculate_dual_qty', 1);
4838: p_x_return_status := -1;
4835:
4836: WHEN TOLERANCE_ERROR THEN -- INVCONV
4837: oe_debug_pub.add('Exception handling: TOLERANCE_ERROR in calculate_dual_qty', 1);
4838: p_x_return_status := -1;
4839: --RAISE -- FND_API.G_EXC_ERROR; -- INVCONV
4840:
4841:
4842: WHEN OTHERS THEN
4843:
4848: 'Calculate_dual_quantity'
4849: );
4850: END IF;
4851: oe_debug_pub.add('Exception handling: others in calculate_dual_qty', 1);
4852: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4853:
4854:
4855:
4856: END calculate_dual_quantity;
4914: 'Get_Preferred_Grade'
4915: );
4916: END IF;
4917: oe_debug_pub.add('others in get_preferred_grade', 1);
4918: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4919:
4920:
4921: END Get_Preferred_Grade; */
4922:
4977: 'Load_Cust_Trx_Type_Id'
4978: );
4979: END IF;
4980: oe_debug_pub.add('others in Load_Cust_Trx_type_Id', 1);
4981: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4982: END Load_Cust_Trx_Type_Id;
4983:
4984: END OE_BULK_PROCESS_LINE;