[Home] [Help]
79: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
80: --
81: BEGIN
82:
83: x_return_status := FND_API.G_RET_STS_SUCCESS;
84:
85: -- Check for fields required on a booked order line
86:
87: IF p_line_rec.sold_to_org_id(p_index) IS NULL THEN
84:
85: -- Check for fields required on a booked order line
86:
87: IF p_line_rec.sold_to_org_id(p_index) IS NULL THEN
88: x_return_status := FND_API.G_RET_STS_ERROR;
89: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
90: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
91: OE_Order_UTIL.Get_Attribute_Name('SOLD_TO_ORG_ID'));
92: OE_BULK_MSG_PUB.ADD;
92: OE_BULK_MSG_PUB.ADD;
93: END IF;
94:
95: IF p_line_rec.invoice_to_org_id(p_index) 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('INVOICE_TO_ORG_ID'));
100: OE_BULK_MSG_PUB.ADD;
100: OE_BULK_MSG_PUB.ADD;
101: END IF;
102:
103: IF p_line_rec.tax_exempt_flag(p_index) 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('TAX_EXEMPT_FLAG'));
108: OE_BULK_MSG_PUB.ADD;
110:
111: -- Quantity and UOM Required
112:
113: IF p_line_rec.order_quantity_uom(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('ORDER_QUANTITY_UOM'));
118: OE_BULK_MSG_PUB.ADD;
120:
121: -- Fix bug 1277092: ordered quantity should not be = 0 on a booked line
122: IF p_line_rec.ordered_quantity(p_index) IS NULL
123: OR p_line_rec.ordered_quantity(p_index) = 0 THEN
124: x_return_status := FND_API.G_RET_STS_ERROR;
125: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
126: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
127: OE_Order_UTIL.Get_Attribute_Name('ORDERED_QUANTITY'));
128: OE_BULK_MSG_PUB.ADD;
135: IF p_line_rec.line_category_code(p_index)
136: <> OE_GLOBALS.G_RETURN_CATEGORY_CODE THEN
137:
138: IF p_line_rec.ship_to_org_id(p_index) IS NULL THEN
139: x_return_status := FND_API.G_RET_STS_ERROR;
140: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
141: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
142: OE_Order_UTIL.Get_Attribute_Name('SHIP_TO_ORG_ID'));
143: OE_BULK_MSG_PUB.ADD;
143: OE_BULK_MSG_PUB.ADD;
144: END IF;
145:
146: IF p_line_rec.payment_term_id(p_index) IS NULL THEN
147: x_return_status := FND_API.G_RET_STS_ERROR;
148: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
149: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
150: OE_Order_UTIL.Get_Attribute_Name('PAYMENT_TERM_ID'));
151: OE_BULK_MSG_PUB.ADD;
153: --serla
154: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN
155: IF p_line_rec.item_type_code(p_index) <> 'SERVICE' THEN
156: IF p_line_rec.accounting_rule_id(p_index) IS NOT NULL AND
157: p_line_rec.accounting_rule_id(p_index) <> FND_API.G_MISS_NUM THEN
158: IF l_debug_level > 0 THEN
159: oe_debug_pub.add( 'GETTING ACCOUNTING RULE TYPE' ) ;
160: END IF;
161: SELECT type
166: oe_debug_pub.add( 'RULE_TYPE IS :'||L_RULE_TYPE||': ACCOUNTING RULE DURATION IS: '||P_LINE_REC.ACCOUNTING_RULE_DURATION ( P_INDEX ) ) ;
167: END IF;
168: IF l_rule_type = 'ACC_DUR' THEN
169: IF p_line_rec.accounting_rule_duration(p_index) IS NULL THEN
170: x_return_status := FND_API.G_RET_STS_ERROR;
171: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
172: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
173: OE_Order_UTIL.Get_Attribute_Name('ACCOUNTING_RULE_DURATION'));
174: OE_BULK_MSG_PUB.ADD;
185:
186: -- Commenting out as of 1/23/2003 as tax checks not req'd
187: /*
188: IF p_line_rec.tax_date(p_index) IS NULL THEN
189: x_return_status := FND_API.G_RET_STS_ERROR;
190: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
191: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
192: OE_Order_UTIL.Get_Attribute_Name('TAX_DATE'));
193: OE_BULK_MSG_PUB.ADD;
204:
205: IF p_line_rec.calculate_price_flag(p_index) = 'N' THEN
206:
207: IF p_line_rec.price_list_id(p_index) IS NULL THEN
208: x_return_status := FND_API.G_RET_STS_ERROR;
209: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
210: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
211: OE_Order_UTIL.Get_Attribute_Name('PRICE_LIST_ID'));
212: OE_BULK_MSG_PUB.ADD;
224: EXCEPTION
225: WHEN OTHERS THEN
226: oe_debug_pub.add('Others Error, Line.Check_Book_Reqd_Attributes');
227: oe_debug_pub.add(substr(sqlerrm,1,240));
228: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
229: IF OE_BULK_MSG_PUB.Check_Msg_Level(OE_BULK_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
230: THEN
231: OE_BULK_MSG_PUB.Add_Exc_Msg
232: ( G_PKG_NAME
250: l_org_code VARCHAR2(30);
251:
252: BEGIN
253:
254: x_return_status := FND_API.G_RET_STS_SUCCESS;
255:
256: -- Check for Required Scheduling Attributes
257:
258: IF p_line_rec.ordered_quantity(p_index) IS NULL THEN
257:
258: IF p_line_rec.ordered_quantity(p_index) IS NULL THEN
259: FND_MESSAGE.SET_NAME('ONT','OE_SCH_MISSING_QUANTITY');
260: OE_BULK_MSG_PUB.Add;
261: x_return_status := FND_API.G_RET_STS_ERROR;
262: END IF;
263:
264: -- If the quantity on the line is zero(which is different from
265: -- missing) and if the user is trying to performing scheduling,
267:
268: IF p_line_rec.ordered_quantity(p_index) = 0 THEN
269: FND_MESSAGE.SET_NAME('ONT','OE_SCH_ZERO_QTY');
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 for following statuses: cancelled, shipped, reserved
275: -- qty changes as line is being CREATED.
280:
281: IF p_line_rec.order_quantity_uom(p_index) IS NULL THEN
282: FND_MESSAGE.SET_NAME('ONT','OE_SCH_MISSING_UOM');
283: OE_BULK_MSG_PUB.Add;
284: x_return_status := FND_API.G_RET_STS_ERROR;
285: END IF;
286:
287: -- Item check not required as it is already validated for creation.
288:
292:
293: IF p_line_rec.request_date(p_index) IS NULL THEN
294: FND_MESSAGE.SET_NAME('ONT','OE_SCH_MISSING_REQUEST_DATE');
295: OE_BULK_MSG_PUB.Add;
296: x_return_status := FND_API.G_RET_STS_ERROR;
297: END IF;
298:
299: -- No need to check if line belongs to a set: SETs not supported in BULK mode
300:
323:
324: IF l_debug_level > 0 THEN
325: oe_debug_pub.add( 'OE_SCH_INACTIVE_STD_ONLY' , 1 ) ;
326: END IF;
327: X_return_status := FND_API.G_RET_STS_ERROR;
328: END IF;
329:
330:
331: -- ATO checks for config support
343: OE_BULK_MSG_PUB.Add;
344: IF l_debug_level > 0 THEN
345: oe_debug_pub.add( 'OE_SCH_ATO_WHSE_REQD' , 1 ) ;
346: END IF;
347: x_return_status := FND_API.G_RET_STS_ERROR;
348:
349: END IF;
350: END IF; -- Gop code level
351:
392: oe_debug_pub.add( 'ORGANIZATION CODE:'||L_ORG_CODE , 2 ) ;
393: END IF;
394: FND_MESSAGE.SET_TOKEN('ORG',l_org_code);
395: OE_MSG_PUB.Add;
396: x_return_status := FND_API.G_RET_STS_ERROR;
397:
398: WHEN OTHERS THEN
399: Null;
400: END;
514: WHERE order_source_id = p_line_rec.order_source_id(p_index)
515: AND orig_sys_document_ref = p_line_rec.orig_sys_document_ref(p_index)
516: AND orig_sys_line_ref = p_line_rec.orig_sys_line_ref(p_index)
517: AND org_id = p_line_rec.org_id(p_index)
518: AND (nvl(orig_sys_shipment_ref,fnd_api.g_miss_char)
519: = nvl(p_line_rec.orig_sys_shipment_ref(p_index),fnd_api.g_miss_char)
520: OR -- added to fix bug 5394064
521: p_line_rec.orig_sys_shipment_ref(p_index) = 'OE_ORDER_LINES_ALL'||p_line_rec.line_id(p_index)||'.'||'1')
522: -- Bug 2764130 : there should be only one row for this doc/line ref
515: AND orig_sys_document_ref = p_line_rec.orig_sys_document_ref(p_index)
516: AND orig_sys_line_ref = p_line_rec.orig_sys_line_ref(p_index)
517: AND org_id = p_line_rec.org_id(p_index)
518: AND (nvl(orig_sys_shipment_ref,fnd_api.g_miss_char)
519: = nvl(p_line_rec.orig_sys_shipment_ref(p_index),fnd_api.g_miss_char)
520: OR -- added to fix bug 5394064
521: p_line_rec.orig_sys_shipment_ref(p_index) = 'OE_ORDER_LINES_ALL'||p_line_rec.line_id(p_index)||'.'||'1')
522: -- Bug 2764130 : there should be only one row for this doc/line ref
523: -- combination. If there are multiple rows, it will be errored out in
580: oe_debug_pub.add( 'ERROR IN GETTING CCID' ) ;
581: END IF;
582: failure_message := fnd_flex_ext.get_message;
583: OE_BULK_MSG_PUB.Add_TEXT(failure_message);
584: RAISE FND_API.G_EXC_ERROR;
585: IF l_debug_level > 0 THEN
586: oe_debug_pub.add( 'FAILURE MESSAGE = ' || SUBSTR ( FAILURE_MESSAGE , 1 , 50 ) ) ;
587: END IF;
588: IF l_debug_level > 0 THEN
641: oe_debug_pub.add( 'SOLD TO ORG ID IS MISSING , CAN NOT GET CUST ITEM' ) ;
642: END IF;
643: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_CUSTOMER_ID');
644: OE_BULK_MSG_PUB.Add;
645: RAISE FND_API.G_EXC_ERROR;
646: END IF;
647:
648: INV_CUSTOMER_ITEM_GRP.CI_Attribute_Value(
649: Z_Customer_Item_Id => p_line_rec.ordered_item_id(p_index)
764:
765:
766:
767: EXCEPTION
768: WHEN FND_API.G_EXC_ERROR THEN
769: p_line_rec.lock_control(p_index) := -99;
770: WHEN OTHERS THEN
771: IF l_debug_level > 0 THEN
772: oe_debug_pub.add( 'OTHERS ERROR , LINE.GET_ITEM_INFO' ) ;
780: ( G_PKG_NAME
781: , 'Get_Item_Info'
782: );
783: END IF;
784: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
785: END Get_Item_Info;
786:
787: FUNCTION Validate_Subinventory
788: ( p_subinventory IN VARCHAR2
1021: --
1022: BEGIN
1023: -- validate input quantity
1024: IF (p_input_quantity is not null AND
1025: p_input_quantity <> FND_API.G_MISS_NUM) THEN
1026:
1027: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' THEN
1028: IF nvl(p_input_quantity, 0) < 0 -- Process HVOP added check for negative as was missing -NB take out when support for RMAs needed
1029:
1349: ( G_PKG_NAME
1350: , 'Unbook_Order'
1351: );
1352: END IF;
1353: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1354: END Unbook_Order;
1355:
1356: PROCEDURE Default_Record
1357: (p_line_rec IN OUT NOCOPY OE_WSH_BULK_GRP.LINE_REC_TYPE
1365: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1366: --
1367: BEGIN
1368:
1369: x_return_status := FND_API.G_RET_STS_SUCCESS;
1370:
1371: -- Validation of defaulted attributes - when to do this, within the
1372: -- cache for each source? YES!
1373:
1424: WHEN NO_DATA_FOUND THEN
1425: IF l_debug_level > 0 THEN
1426: oe_debug_pub.add( 'ITEM CACHE RETURNS NO DATA FOUND' ) ;
1427: END IF;
1428: x_return_status := FND_API.G_RET_STS_ERROR;
1429: END;
1430:
1431: END IF;
1432:
1473: WHEN NO_DATA_FOUND THEN
1474: IF l_debug_level > 0 THEN
1475: oe_debug_pub.add( 'SHIP TO CACHE RETURNS NO DATA FOUND' ) ;
1476: END IF;
1477: x_return_status := FND_API.G_RET_STS_ERROR;
1478: END;
1479:
1480: END IF;
1481:
1593: ( G_PKG_NAME
1594: , 'Default_Record'
1595: );
1596: END IF;
1597: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1598: END Default_Record;
1599:
1600: PROCEDURE Populate_Internal_Fields
1601: (p_line_rec IN OUT NOCOPY OE_WSH_BULK_GRP.LINE_REC_TYPE
1654: OE_Bulk_Order_PVT.g_header_rec.invoice_to_org_id(p_header_index)
1655: THEN
1656: FND_MESSAGE.SET_NAME('ONT','OE_BULK_DIFF_INVOICE_TO');
1657: OE_BULK_MSG_PUB.Add('Y', 'ERROR');
1658: x_return_status := FND_API.G_RET_STS_ERROR;
1659: END IF;
1660:
1661:
1662: -------------------------------------------------------------------
1745: p_sold_to_org_id => p_line_rec.sold_to_org_id(p_index),
1746: x_ordered_item => p_line_rec.ordered_item(p_index)
1747: );
1748:
1749: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1750: x_return_status := FND_API.G_RET_STS_ERROR;
1751: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1752: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1753: END IF;
1746: x_ordered_item => p_line_rec.ordered_item(p_index)
1747: );
1748:
1749: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1750: x_return_status := FND_API.G_RET_STS_ERROR;
1751: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1752: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1753: END IF;
1754:
1747: );
1748:
1749: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1750: x_return_status := FND_API.G_RET_STS_ERROR;
1751: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1752: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1753: END IF;
1754:
1755: END IF;
1748:
1749: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1750: x_return_status := FND_API.G_RET_STS_ERROR;
1751: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1752: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1753: END IF;
1754:
1755: END IF;
1756:
1777: THEN -- Service item type
1778: oe_debug_pub.add( 'Populate_Internal_Fields ab' ) ;
1779: FND_MESSAGE.SET_NAME('ONT','OE_BULK_NOT_SUPP_ITEM_TYPE');
1780: OE_BULK_MSG_PUB.Add('Y', 'ERROR');
1781: x_return_status := FND_API.G_RET_STS_ERROR;
1782: x_unsupported_feature := 'Y';
1783: p_line_rec.lock_control(p_index) := -98;
1784: ELSE
1785: oe_debug_pub.add( 'Populate_Internal_Fields bc' ) ;
1912: THEN
1913: oe_debug_pub.add( 'Populate_Internal_Fields 4a' ) ;
1914: FND_MESSAGE.SET_NAME('ONT','OE_BULK_NOT_SUPP_ITEM_TYPE');
1915: OE_BULK_MSG_PUB.Add('Y', 'ERROR');
1916: x_return_status := FND_API.G_RET_STS_ERROR;
1917: x_unsupported_feature := 'Y';
1918: p_line_rec.lock_control(p_index) := -98;
1919:
1920: ELSE
1989: END IF;
1990:
1991: FND_MESSAGE.SET_NAME('ONT','OE_BULK_OPM_DUAL_QTY_ERROR'); -- HVOP define better OM or GMI error code
1992: OE_BULK_MSG_PUB.Add('Y', 'ERROR');
1993: x_return_status := FND_API.G_RET_STS_ERROR;
1994: END IF;
1995: oe_debug_pub.add( 'Populate_Internal_Fields 6' ) ;
1996: IF l_debug_level > 0 THEN
1997: oe_debug_pub.add( 'out of calculate_dual_quantity 2 ' ) ;
2048: <> 'ORDER'
2049: THEN
2050: FND_MESSAGE.SET_NAME('ONT','OE_BULK_NOT_SUPP_RETURN');
2051: OE_BULK_MSG_PUB.Add('Y', 'ERROR');
2052: x_return_status := FND_API.G_RET_STS_ERROR;
2053: ELSE
2054: p_line_rec.line_category_code(p_index) := 'ORDER';
2055: END IF;
2056:
2073: AND NVL(p_process_tax,'N') <> 'Y'
2074: THEN
2075: FND_MESSAGE.SET_NAME('ONT','OE_BULK_NOT_SUPP_TAX_CAL');
2076: OE_BULK_MSG_PUB.Add('Y', 'ERROR');
2077: x_return_status := FND_API.G_RET_STS_ERROR;
2078: END IF;
2079: */
2080:
2081: -- Invalid line type - error message populated during validation
2082: EXCEPTION
2083: WHEN NO_DATA_FOUND THEN
2084: -- Set line category for insert to succeed
2085: p_line_rec.line_category_code(p_index) := 'ORDER';
2086: x_return_status := FND_API.G_RET_STS_ERROR;
2087:
2088: -- fix bug 5109227
2089: p_line_rec.lock_control(p_index) := -99 ;
2090: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2146: END IF;
2147:
2148: oe_debug_pub.add( 'Populate_Internal_Fields 9' ) ;
2149: EXCEPTION
2150: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2151: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2152: WHEN OTHERS THEN
2153: IF l_debug_level > 0 THEN
2154: oe_debug_pub.add( 'OTHERS ERROR , LINE.POPULATE_INTERNAL_FIELDS' ) ;
2147:
2148: oe_debug_pub.add( 'Populate_Internal_Fields 9' ) ;
2149: EXCEPTION
2150: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2151: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2152: WHEN OTHERS THEN
2153: IF l_debug_level > 0 THEN
2154: oe_debug_pub.add( 'OTHERS ERROR , LINE.POPULATE_INTERNAL_FIELDS' ) ;
2155: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 240 ) ) ;
2153: IF l_debug_level > 0 THEN
2154: oe_debug_pub.add( 'OTHERS ERROR , LINE.POPULATE_INTERNAL_FIELDS' ) ;
2155: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 240 ) ) ;
2156: END IF;
2157: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2158: IF OE_BULK_MSG_PUB.Check_Msg_Level(OE_BULK_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2159: THEN
2160: OE_BULK_MSG_PUB.Add_Exc_Msg
2161: ( G_PKG_NAME
2207: where line_id = p_line_rec.line_id(p_line_index);
2208:
2209: IF nvl(p_line_rec.customer_item_net_price(p_line_index)
2210: ,l_unit_selling_price)
2211: <> nvl(l_unit_selling_price,FND_API.G_MISS_NUM)
2212: THEN
2213:
2214: FND_MESSAGE.SET_NAME('ONT','OE_OI_PRICE_WARNING');
2215: FND_MESSAGE.SET_TOKEN('CUST_PRICE'
2220: END IF;
2221:
2222: IF nvl(p_line_rec.customer_payment_term_id(p_line_index)
2223: ,l_payment_term_id)
2224: <> nvl(l_payment_term_id,FND_API.G_MISS_NUM)
2225: THEN
2226:
2227: FND_MESSAGE.SET_NAME('ONT','OE_OI_PAYMENT_TERM_WARNING');
2228: FND_MESSAGE.SET_TOKEN('CUST_TERM'
2234:
2235: END IF;
2236:
2237: EXCEPTION
2238: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2239: IF l_debug_level > 0 THEN
2240: oe_debug_pub.add( 'UNEXP ERROR , LINE.POST_PROCESS' ) ;
2241: END IF;
2242: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2238: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2239: IF l_debug_level > 0 THEN
2240: oe_debug_pub.add( 'UNEXP ERROR , LINE.POST_PROCESS' ) ;
2241: END IF;
2242: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2243: WHEN OTHERS THEN
2244: IF l_debug_level > 0 THEN
2245: oe_debug_pub.add( 'OTHERS ERROR , LINE.POST_PROCESS' ) ;
2246: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 240 ) ) ;
2251: ( G_PKG_NAME
2252: , 'Post_Process'
2253: );
2254: END IF;
2255: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2256: END Post_Process;
2257:
2258: ---------------------------------------------------------------------
2259: -- PROCEDURE Entity
2488: ,p_header_index => header_counter
2489: ,x_return_status => l_return_status
2490: );
2491:
2492: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2493: p_line_rec.lock_control(l_index) := -99;
2494: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2495: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2496: END IF;
2490: );
2491:
2492: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2493: p_line_rec.lock_control(l_index) := -99;
2494: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2495: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2496: END IF;
2497:
2498: END IF;
2491:
2492: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2493: p_line_rec.lock_control(l_index) := -99;
2494: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2495: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2496: END IF;
2497:
2498: END IF;
2499:
2515: ,x_return_status => l_return_status
2516: );
2517:
2518: oe_debug_pub.add('after Populate_Internal_Fields');
2519: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2520: p_line_rec.lock_control(l_index) := -99;
2521: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2522: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2523: END IF;
2517:
2518: oe_debug_pub.add('after Populate_Internal_Fields');
2519: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2520: p_line_rec.lock_control(l_index) := -99;
2521: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2522: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2523: END IF;
2524:
2525: -- Populating calculate price flag
2518: oe_debug_pub.add('after Populate_Internal_Fields');
2519: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2520: p_line_rec.lock_control(l_index) := -99;
2521: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2522: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2523: END IF;
2524:
2525: -- Populating calculate price flag
2526:
2762:
2763: IF (p_line_rec.ship_from_org_id(l_index)IS NULL) THEN
2764:
2765: IF (p_line_rec.ordered_quantity_uom2(l_index)IS NOT NULL
2766: -- AND p_line_rec.context(l_index) = FND_API.G_MISS_CHAR
2767: )
2768: OR
2769: (p_line_rec.ordered_quantity2(l_index) IS NOT NULL)
2770: OR
2858: fnd_message.set_name('ONT','OE_INVALID_ORDER_QUANTITY_UOM');
2859: fnd_message.set_token('ITEM',p_line_rec.ordered_item(l_index) );
2860: fnd_message.set_token('UOM', l_uom);
2861: OE_BULK_MSG_PUB.Add('Y','ERROR');
2862: --RAISE FND_API.G_EXC_ERROR;
2863: END IF;
2864: EXCEPTION
2865: when no_data_found then
2866: IF l_debug_level > 0 THEN
3371: --service items have the partial period accounting rules attached
3372: --to them.
3373: IF p_line_rec.item_type_code(l_index) <> 'SERVICE' THEN
3374: IF p_line_rec.accounting_rule_id(l_index) IS NOT NULL AND
3375: p_line_rec.accounting_rule_id(l_index) <> FND_API.G_MISS_NUM THEN
3376: IF l_debug_level > 0 THEN
3377: oe_debug_pub.add( 'GETTING ACCOUNTING RULE TYPE' ) ;
3378: END IF;
3379: SELECT type
3634:
3635: ELSE -- if the flex validation is successfull
3636: -- For bug 2511313
3637: IF p_line_rec.context(l_index) IS NULL
3638: OR p_line_rec.context(l_index) = FND_API.G_MISS_CHAR THEN
3639: p_line_rec.context(l_index) := oe_validate.g_context;
3640: END IF;
3641:
3642: IF p_line_rec.attribute1(l_index) IS NULL
3639: p_line_rec.context(l_index) := oe_validate.g_context;
3640: END IF;
3641:
3642: IF p_line_rec.attribute1(l_index) IS NULL
3643: OR p_line_rec.attribute1(l_index) = FND_API.G_MISS_CHAR THEN
3644: p_line_rec.attribute1(l_index) := oe_validate.g_attribute1;
3645: END IF;
3646:
3647: IF p_line_rec.attribute2(l_index) IS NULL
3644: p_line_rec.attribute1(l_index) := oe_validate.g_attribute1;
3645: END IF;
3646:
3647: IF p_line_rec.attribute2(l_index) IS NULL
3648: OR p_line_rec.attribute2(l_index) = FND_API.G_MISS_CHAR THEN
3649: p_line_rec.attribute2(l_index) := oe_validate.g_attribute2;
3650: END IF;
3651:
3652: IF p_line_rec.attribute3(l_index) IS NULL
3649: p_line_rec.attribute2(l_index) := oe_validate.g_attribute2;
3650: END IF;
3651:
3652: IF p_line_rec.attribute3(l_index) IS NULL
3653: OR p_line_rec.attribute3(l_index) = FND_API.G_MISS_CHAR THEN
3654: p_line_rec.attribute3(l_index) := oe_validate.g_attribute3;
3655: END IF;
3656:
3657: IF p_line_rec.attribute4(l_index) IS NULL
3654: p_line_rec.attribute3(l_index) := oe_validate.g_attribute3;
3655: END IF;
3656:
3657: IF p_line_rec.attribute4(l_index) IS NULL
3658: OR p_line_rec.attribute4(l_index) = FND_API.G_MISS_CHAR THEN
3659: p_line_rec.attribute4(l_index) := oe_validate.g_attribute4;
3660: END IF;
3661:
3662: IF p_line_rec.attribute5(l_index) IS NULL
3659: p_line_rec.attribute4(l_index) := oe_validate.g_attribute4;
3660: END IF;
3661:
3662: IF p_line_rec.attribute5(l_index) IS NULL
3663: OR p_line_rec.attribute5(l_index) = FND_API.G_MISS_CHAR THEN
3664: p_line_rec.attribute5(l_index) := oe_validate.g_attribute5;
3665: END IF;
3666:
3667: IF p_line_rec.attribute6(l_index) IS NULL
3664: p_line_rec.attribute5(l_index) := oe_validate.g_attribute5;
3665: END IF;
3666:
3667: IF p_line_rec.attribute6(l_index) IS NULL
3668: OR p_line_rec.attribute6(l_index) = FND_API.G_MISS_CHAR THEN
3669: p_line_rec.attribute6(l_index) := oe_validate.g_attribute6;
3670: END IF;
3671:
3672: IF p_line_rec.attribute7(l_index) IS NULL
3669: p_line_rec.attribute6(l_index) := oe_validate.g_attribute6;
3670: END IF;
3671:
3672: IF p_line_rec.attribute7(l_index) IS NULL
3673: OR p_line_rec.attribute7(l_index) = FND_API.G_MISS_CHAR THEN
3674: p_line_rec.attribute7(l_index) := oe_validate.g_attribute7;
3675: END IF;
3676:
3677: IF p_line_rec.attribute8(l_index) IS NULL
3674: p_line_rec.attribute7(l_index) := oe_validate.g_attribute7;
3675: END IF;
3676:
3677: IF p_line_rec.attribute8(l_index) IS NULL
3678: OR p_line_rec.attribute8(l_index) = FND_API.G_MISS_CHAR THEN
3679: p_line_rec.attribute8(l_index) := oe_validate.g_attribute8;
3680: END IF;
3681:
3682: IF p_line_rec.attribute9(l_index) IS NULL
3679: p_line_rec.attribute8(l_index) := oe_validate.g_attribute8;
3680: END IF;
3681:
3682: IF p_line_rec.attribute9(l_index) IS NULL
3683: OR p_line_rec.attribute9(l_index) = FND_API.G_MISS_CHAR THEN
3684: p_line_rec.attribute9(l_index) := oe_validate.g_attribute9;
3685: END IF;
3686:
3687: IF p_line_rec.attribute10(l_index) IS NULL
3684: p_line_rec.attribute9(l_index) := oe_validate.g_attribute9;
3685: END IF;
3686:
3687: IF p_line_rec.attribute10(l_index) IS NULL
3688: OR p_line_rec.attribute10(l_index) = FND_API.G_MISS_CHAR THEN
3689: p_line_rec.attribute10(l_index) := Oe_validate.G_attribute10;
3690: End IF;
3691:
3692: IF p_line_rec.attribute11(l_index) IS NULL
3689: p_line_rec.attribute10(l_index) := Oe_validate.G_attribute10;
3690: End IF;
3691:
3692: IF p_line_rec.attribute11(l_index) IS NULL
3693: OR p_line_rec.attribute11(l_index) = FND_API.G_MISS_CHAR THEN
3694: p_line_rec.attribute11(l_index) := oe_validate.g_attribute11;
3695: END IF;
3696:
3697: IF p_line_rec.attribute12(l_index) IS NULL
3694: p_line_rec.attribute11(l_index) := oe_validate.g_attribute11;
3695: END IF;
3696:
3697: IF p_line_rec.attribute12(l_index) IS NULL
3698: OR p_line_rec.attribute12(l_index) = FND_API.G_MISS_CHAR THEN
3699: p_line_rec.attribute12(l_index) := oe_validate.g_attribute12;
3700: END IF;
3701:
3702: IF p_line_rec.attribute13(l_index) IS NULL
3699: p_line_rec.attribute12(l_index) := oe_validate.g_attribute12;
3700: END IF;
3701:
3702: IF p_line_rec.attribute13(l_index) IS NULL
3703: OR p_line_rec.attribute13(l_index) = FND_API.G_MISS_CHAR THEN
3704: p_line_rec.attribute13(l_index) := oe_validate.g_attribute13;
3705: END IF;
3706:
3707: IF p_line_rec.attribute14(l_index) IS NULL
3704: p_line_rec.attribute13(l_index) := oe_validate.g_attribute13;
3705: END IF;
3706:
3707: IF p_line_rec.attribute14(l_index) IS NULL
3708: OR p_line_rec.attribute14(l_index) = FND_API.G_MISS_CHAR THEN
3709: p_line_rec.attribute14(l_index) := oe_validate.g_attribute14;
3710: END IF;
3711:
3712: IF p_line_rec.attribute15(l_index) IS NULL
3709: p_line_rec.attribute14(l_index) := oe_validate.g_attribute14;
3710: END IF;
3711:
3712: IF p_line_rec.attribute15(l_index) IS NULL
3713: OR p_line_rec.attribute15(l_index) = FND_API.G_MISS_CHAR THEN
3714: p_line_rec.attribute15(l_index) := oe_validate.g_attribute15;
3715: END IF;
3716:
3717: IF p_line_rec.attribute16(l_index) IS NULL
3714: p_line_rec.attribute15(l_index) := oe_validate.g_attribute15;
3715: END IF;
3716:
3717: IF p_line_rec.attribute16(l_index) IS NULL
3718: OR p_line_rec.attribute16(l_index) = FND_API.G_MISS_CHAR THEN
3719: p_line_rec.attribute16(l_index) := oe_validate.g_attribute16;
3720: END IF;
3721:
3722: IF p_line_rec.attribute17(l_index) IS NULL
3719: p_line_rec.attribute16(l_index) := oe_validate.g_attribute16;
3720: END IF;
3721:
3722: IF p_line_rec.attribute17(l_index) IS NULL
3723: OR p_line_rec.attribute17(l_index) = FND_API.G_MISS_CHAR THEN
3724: p_line_rec.attribute17(l_index) := oe_validate.g_attribute17;
3725: END IF;
3726:
3727: IF p_line_rec.attribute18(l_index) IS NULL
3724: p_line_rec.attribute17(l_index) := oe_validate.g_attribute17;
3725: END IF;
3726:
3727: IF p_line_rec.attribute18(l_index) IS NULL
3728: OR p_line_rec.attribute18(l_index) = FND_API.G_MISS_CHAR THEN
3729: p_line_rec.attribute18(l_index) := oe_validate.g_attribute18;
3730: END IF;
3731:
3732: IF p_line_rec.attribute19(l_index) IS NULL
3729: p_line_rec.attribute18(l_index) := oe_validate.g_attribute18;
3730: END IF;
3731:
3732: IF p_line_rec.attribute19(l_index) IS NULL
3733: OR p_line_rec.attribute19(l_index) = FND_API.G_MISS_CHAR THEN
3734: p_line_rec.attribute19(l_index) := oe_validate.g_attribute19;
3735: END IF;
3736:
3737: IF p_line_rec.attribute20(l_index) IS NULL
3734: p_line_rec.attribute19(l_index) := oe_validate.g_attribute19;
3735: END IF;
3736:
3737: IF p_line_rec.attribute20(l_index) IS NULL
3738: OR p_line_rec.attribute20(l_index) = FND_API.G_MISS_CHAR THEN
3739: p_line_rec.attribute20(l_index) := oe_validate.g_attribute20;
3740: END IF;
3741: -- end of assignments, bug 2511313
3742:
3785:
3786: ELSE -- for bug 2511313
3787:
3788: IF p_line_rec.industry_context(l_index) IS NULL
3789: OR p_line_rec.industry_context(l_index) = FND_API.G_MISS_CHAR THEN
3790: p_line_rec.industry_context(l_index) := oe_validate.g_context;
3791: END IF;
3792:
3793: IF p_line_rec.industry_attribute1(l_index) IS NULL
3790: p_line_rec.industry_context(l_index) := oe_validate.g_context;
3791: END IF;
3792:
3793: IF p_line_rec.industry_attribute1(l_index) IS NULL
3794: OR p_line_rec.industry_attribute1(l_index) = FND_API.G_MISS_CHAR THEN
3795: p_line_rec.industry_attribute1(l_index) := oe_validate.g_attribute1;
3796: END IF;
3797:
3798: IF p_line_rec.industry_attribute2(l_index) IS NULL
3795: p_line_rec.industry_attribute1(l_index) := oe_validate.g_attribute1;
3796: END IF;
3797:
3798: IF p_line_rec.industry_attribute2(l_index) IS NULL
3799: OR p_line_rec.industry_attribute2(l_index) = FND_API.G_MISS_CHAR THEN
3800: p_line_rec.industry_attribute2(l_index) := oe_validate.g_attribute2;
3801: END IF;
3802:
3803: IF p_line_rec.industry_attribute3(l_index) IS NULL
3800: p_line_rec.industry_attribute2(l_index) := oe_validate.g_attribute2;
3801: END IF;
3802:
3803: IF p_line_rec.industry_attribute3(l_index) IS NULL
3804: OR p_line_rec.industry_attribute3(l_index) = FND_API.G_MISS_CHAR THEN
3805: p_line_rec.industry_attribute3(l_index) := oe_validate.g_attribute3;
3806: END IF;
3807:
3808: IF p_line_rec.industry_attribute4(l_index) IS NULL
3805: p_line_rec.industry_attribute3(l_index) := oe_validate.g_attribute3;
3806: END IF;
3807:
3808: IF p_line_rec.industry_attribute4(l_index) IS NULL
3809: OR p_line_rec.industry_attribute4(l_index) = FND_API.G_MISS_CHAR THEN
3810: p_line_rec.industry_attribute4(l_index) := oe_validate.g_attribute4;
3811: END IF;
3812:
3813: IF p_line_rec.industry_attribute5(l_index) IS NULL
3810: p_line_rec.industry_attribute4(l_index) := oe_validate.g_attribute4;
3811: END IF;
3812:
3813: IF p_line_rec.industry_attribute5(l_index) IS NULL
3814: OR p_line_rec.industry_attribute5(l_index) = FND_API.G_MISS_CHAR THEN
3815: p_line_rec.industry_attribute5(l_index) := oe_validate.g_attribute5;
3816: END IF;
3817:
3818: IF p_line_rec.industry_attribute6(l_index) IS NULL
3815: p_line_rec.industry_attribute5(l_index) := oe_validate.g_attribute5;
3816: END IF;
3817:
3818: IF p_line_rec.industry_attribute6(l_index) IS NULL
3819: OR p_line_rec.industry_attribute6(l_index) = FND_API.G_MISS_CHAR THEN
3820: p_line_rec.industry_attribute6(l_index) := oe_validate.g_attribute6;
3821: END IF;
3822:
3823: IF p_line_rec.industry_attribute7(l_index) IS NULL
3820: p_line_rec.industry_attribute6(l_index) := oe_validate.g_attribute6;
3821: END IF;
3822:
3823: IF p_line_rec.industry_attribute7(l_index) IS NULL
3824: OR p_line_rec.industry_attribute7(l_index) = FND_API.G_MISS_CHAR THEN
3825: p_line_rec.industry_attribute7(l_index) := oe_validate.g_attribute7;
3826: END IF;
3827:
3828: IF p_line_rec.industry_attribute8(l_index) IS NULL
3825: p_line_rec.industry_attribute7(l_index) := oe_validate.g_attribute7;
3826: END IF;
3827:
3828: IF p_line_rec.industry_attribute8(l_index) IS NULL
3829: OR p_line_rec.industry_attribute8(l_index) = FND_API.G_MISS_CHAR THEN
3830: p_line_rec.industry_attribute8(l_index) := oe_validate.g_attribute8;
3831: END IF;
3832:
3833: IF p_line_rec.industry_attribute9(l_index) IS NULL
3830: p_line_rec.industry_attribute8(l_index) := oe_validate.g_attribute8;
3831: END IF;
3832:
3833: IF p_line_rec.industry_attribute9(l_index) IS NULL
3834: OR p_line_rec.industry_attribute9(l_index) = FND_API.G_MISS_CHAR THEN
3835: p_line_rec.industry_attribute9(l_index) := oe_validate.g_attribute9;
3836: END IF;
3837:
3838: IF p_line_rec.industry_attribute10(l_index) IS NULL
3835: p_line_rec.industry_attribute9(l_index) := oe_validate.g_attribute9;
3836: END IF;
3837:
3838: IF p_line_rec.industry_attribute10(l_index) IS NULL
3839: OR p_line_rec.industry_attribute10(l_index) = FND_API.G_MISS_CHAR THEN
3840: p_line_rec.industry_attribute10(l_index) := oe_validate.g_attribute10;
3841: END IF;
3842:
3843: IF p_line_rec.industry_attribute11(l_index) IS NULL
3840: p_line_rec.industry_attribute10(l_index) := oe_validate.g_attribute10;
3841: END IF;
3842:
3843: IF p_line_rec.industry_attribute11(l_index) IS NULL
3844: OR p_line_rec.industry_attribute11(l_index) = FND_API.G_MISS_CHAR THEN
3845: p_line_rec.industry_attribute11(l_index) := oe_validate.g_attribute11;
3846: END IF;
3847:
3848: IF p_line_rec.industry_attribute12(l_index) IS NULL
3845: p_line_rec.industry_attribute11(l_index) := oe_validate.g_attribute11;
3846: END IF;
3847:
3848: IF p_line_rec.industry_attribute12(l_index) IS NULL
3849: OR p_line_rec.industry_attribute12(l_index) = FND_API.G_MISS_CHAR THEN
3850: p_line_rec.industry_attribute12(l_index) := oe_validate.g_attribute12;
3851: END IF;
3852:
3853: IF p_line_rec.industry_attribute13(l_index) IS NULL
3850: p_line_rec.industry_attribute12(l_index) := oe_validate.g_attribute12;
3851: END IF;
3852:
3853: IF p_line_rec.industry_attribute13(l_index) IS NULL
3854: OR p_line_rec.industry_attribute13(l_index) = FND_API.G_MISS_CHAR THEN
3855: p_line_rec.industry_attribute13(l_index) := oe_validate.g_attribute13;
3856: END IF;
3857:
3858: IF p_line_rec.industry_attribute14(l_index) IS NULL
3855: p_line_rec.industry_attribute13(l_index) := oe_validate.g_attribute13;
3856: END IF;
3857:
3858: IF p_line_rec.industry_attribute14(l_index) IS NULL
3859: OR p_line_rec.industry_attribute14(l_index) = FND_API.G_MISS_CHAR THEN
3860: p_line_rec.industry_attribute14(l_index) := oe_validate.g_attribute14;
3861: END IF;
3862:
3863: IF p_line_rec.industry_attribute15(l_index) IS NULL
3860: p_line_rec.industry_attribute14(l_index) := oe_validate.g_attribute14;
3861: END IF;
3862:
3863: IF p_line_rec.industry_attribute15(l_index) IS NULL
3864: OR p_line_rec.industry_attribute15(l_index) = FND_API.G_MISS_CHAR THEN
3865: p_line_rec.industry_attribute15(l_index) := oe_validate.g_attribute15;
3866: END IF;
3867:
3868: IF p_line_rec.industry_attribute16(l_index) IS NULL
3865: p_line_rec.industry_attribute15(l_index) := oe_validate.g_attribute15;
3866: END IF;
3867:
3868: IF p_line_rec.industry_attribute16(l_index) IS NULL
3869: OR p_line_rec.industry_attribute16(l_index) = FND_API.G_MISS_CHAR THEN
3870: p_line_rec.industry_attribute16(l_index) := oe_validate.g_attribute16;
3871: END IF;
3872:
3873: IF p_line_rec.industry_attribute17(l_index) IS NULL
3870: p_line_rec.industry_attribute16(l_index) := oe_validate.g_attribute16;
3871: END IF;
3872:
3873: IF p_line_rec.industry_attribute17(l_index) IS NULL
3874: OR p_line_rec.industry_attribute17(l_index) = FND_API.G_MISS_CHAR THEN
3875: p_line_rec.industry_attribute17(l_index) := oe_validate.g_attribute17;
3876: END IF;
3877:
3878: IF p_line_rec.industry_attribute18(l_index) IS NULL
3875: p_line_rec.industry_attribute17(l_index) := oe_validate.g_attribute17;
3876: END IF;
3877:
3878: IF p_line_rec.industry_attribute18(l_index) IS NULL
3879: OR p_line_rec.industry_attribute18(l_index) = FND_API.G_MISS_CHAR THEN
3880: p_line_rec.industry_attribute18(l_index) := oe_validate.g_attribute18;
3881: END IF;
3882:
3883: IF p_line_rec.industry_attribute19(l_index) IS NULL
3880: p_line_rec.industry_attribute18(l_index) := oe_validate.g_attribute18;
3881: END IF;
3882:
3883: IF p_line_rec.industry_attribute19(l_index) IS NULL
3884: OR p_line_rec.industry_attribute19(l_index) = FND_API.G_MISS_CHAR THEN
3885: p_line_rec.industry_attribute19(l_index) := oe_validate.g_attribute19;
3886: END IF;
3887:
3888: IF p_line_rec.industry_attribute20(l_index) IS NULL
3885: p_line_rec.industry_attribute19(l_index) := oe_validate.g_attribute19;
3886: END IF;
3887:
3888: IF p_line_rec.industry_attribute20(l_index) IS NULL
3889: OR p_line_rec.industry_attribute20(l_index) = FND_API.G_MISS_CHAR THEN
3890: p_line_rec.industry_attribute20(l_index) := oe_validate.g_attribute20;
3891: END IF;
3892:
3893: IF p_line_rec.industry_attribute21(l_index) IS NULL
3890: p_line_rec.industry_attribute20(l_index) := oe_validate.g_attribute20;
3891: END IF;
3892:
3893: IF p_line_rec.industry_attribute21(l_index) IS NULL
3894: OR p_line_rec.industry_attribute21(l_index) = FND_API.G_MISS_CHAR THEN
3895: p_line_rec.industry_attribute21(l_index) := oe_validate.g_attribute21;
3896: END IF;
3897:
3898: IF p_line_rec.industry_attribute22(l_index) IS NULL
3895: p_line_rec.industry_attribute21(l_index) := oe_validate.g_attribute21;
3896: END IF;
3897:
3898: IF p_line_rec.industry_attribute22(l_index) IS NULL
3899: OR p_line_rec.industry_attribute22(l_index) = FND_API.G_MISS_CHAR THEN
3900: p_line_rec.industry_attribute22(l_index) := oe_validate.g_attribute22;
3901: END IF;
3902:
3903: IF p_line_rec.industry_attribute23(l_index) IS NULL
3900: p_line_rec.industry_attribute22(l_index) := oe_validate.g_attribute22;
3901: END IF;
3902:
3903: IF p_line_rec.industry_attribute23(l_index) IS NULL
3904: OR p_line_rec.industry_attribute23(l_index) = FND_API.G_MISS_CHAR THEN
3905: p_line_rec.industry_attribute23(l_index) := oe_validate.g_attribute23;
3906: END IF;
3907:
3908: IF p_line_rec.industry_attribute24(l_index) IS NULL
3905: p_line_rec.industry_attribute23(l_index) := oe_validate.g_attribute23;
3906: END IF;
3907:
3908: IF p_line_rec.industry_attribute24(l_index) IS NULL
3909: OR p_line_rec.industry_attribute24(l_index) = FND_API.G_MISS_CHAR THEN
3910: p_line_rec.industry_attribute24(l_index) := oe_validate.g_attribute24;
3911: END IF;
3912:
3913: IF p_line_rec.industry_attribute25(l_index) IS NULL
3910: p_line_rec.industry_attribute24(l_index) := oe_validate.g_attribute24;
3911: END IF;
3912:
3913: IF p_line_rec.industry_attribute25(l_index) IS NULL
3914: OR p_line_rec.industry_attribute25(l_index) = FND_API.G_MISS_CHAR THEN
3915: p_line_rec.industry_attribute25(l_index) := oe_validate.g_attribute25;
3916: END IF;
3917:
3918: IF p_line_rec.industry_attribute26(l_index) IS NULL
3915: p_line_rec.industry_attribute25(l_index) := oe_validate.g_attribute25;
3916: END IF;
3917:
3918: IF p_line_rec.industry_attribute26(l_index) IS NULL
3919: OR p_line_rec.industry_attribute26(l_index) = FND_API.G_MISS_CHAR THEN
3920: p_line_rec.industry_attribute26(l_index) := oe_validate.g_attribute26;
3921: END IF;
3922:
3923: IF p_line_rec.industry_attribute27(l_index) IS NULL
3920: p_line_rec.industry_attribute26(l_index) := oe_validate.g_attribute26;
3921: END IF;
3922:
3923: IF p_line_rec.industry_attribute27(l_index) IS NULL
3924: OR p_line_rec.industry_attribute27(l_index) = FND_API.G_MISS_CHAR THEN
3925: p_line_rec.industry_attribute27(l_index) := oe_validate.g_attribute27;
3926: END IF;
3927:
3928: IF p_line_rec.industry_attribute28(l_index) IS NULL
3925: p_line_rec.industry_attribute27(l_index) := oe_validate.g_attribute27;
3926: END IF;
3927:
3928: IF p_line_rec.industry_attribute28(l_index) IS NULL
3929: OR p_line_rec.industry_attribute28(l_index) = FND_API.G_MISS_CHAR THEN
3930: p_line_rec.industry_attribute28(l_index) := oe_validate.g_attribute28;
3931: END IF;
3932:
3933: IF p_line_rec.industry_attribute29(l_index) IS NULL
3930: p_line_rec.industry_attribute28(l_index) := oe_validate.g_attribute28;
3931: END IF;
3932:
3933: IF p_line_rec.industry_attribute29(l_index) IS NULL
3934: OR p_line_rec.industry_attribute29(l_index) = FND_API.G_MISS_CHAR THEN
3935: p_line_rec.industry_attribute29(l_index) := oe_validate.g_attribute29;
3936: END IF;
3937:
3938: IF p_line_rec.industry_attribute30(l_index) IS NULL
3935: p_line_rec.industry_attribute29(l_index) := oe_validate.g_attribute29;
3936: END IF;
3937:
3938: IF p_line_rec.industry_attribute30(l_index) IS NULL
3939: OR p_line_rec.industry_attribute30(l_index) = FND_API.G_MISS_CHAR THEN
3940: p_line_rec.industry_attribute30(l_index) := oe_validate.g_attribute30;
3941: END IF;
3942:
3943: -- end of bug 2511313
3972:
3973: ELSE -- if the flex validation is successfull
3974: -- For bug 2511313
3975: IF p_line_rec.tp_context(l_index) IS NULL
3976: OR p_line_rec.tp_context(l_index) = FND_API.G_MISS_CHAR THEN
3977: p_line_rec.tp_context(l_index) := oe_validate.g_context;
3978: END IF;
3979:
3980: IF p_line_rec.tp_attribute1(l_index) IS NULL
3977: p_line_rec.tp_context(l_index) := oe_validate.g_context;
3978: END IF;
3979:
3980: IF p_line_rec.tp_attribute1(l_index) IS NULL
3981: OR p_line_rec.tp_attribute1(l_index) = FND_API.G_MISS_CHAR THEN
3982: p_line_rec.tp_attribute1(l_index) := oe_validate.g_attribute1;
3983: END IF;
3984:
3985: IF p_line_rec.tp_attribute2(l_index) IS NULL
3982: p_line_rec.tp_attribute1(l_index) := oe_validate.g_attribute1;
3983: END IF;
3984:
3985: IF p_line_rec.tp_attribute2(l_index) IS NULL
3986: OR p_line_rec.tp_attribute2(l_index) = FND_API.G_MISS_CHAR THEN
3987: p_line_rec.tp_attribute2(l_index) := oe_validate.g_attribute2;
3988: END IF;
3989:
3990: IF p_line_rec.tp_attribute3(l_index) IS NULL
3987: p_line_rec.tp_attribute2(l_index) := oe_validate.g_attribute2;
3988: END IF;
3989:
3990: IF p_line_rec.tp_attribute3(l_index) IS NULL
3991: OR p_line_rec.tp_attribute3(l_index) = FND_API.G_MISS_CHAR THEN
3992: p_line_rec.tp_attribute3(l_index) := oe_validate.g_attribute3;
3993: END IF;
3994:
3995: IF p_line_rec.tp_attribute4(l_index) IS NULL
3992: p_line_rec.tp_attribute3(l_index) := oe_validate.g_attribute3;
3993: END IF;
3994:
3995: IF p_line_rec.tp_attribute4(l_index) IS NULL
3996: OR p_line_rec.tp_attribute4(l_index) = FND_API.G_MISS_CHAR THEN
3997: p_line_rec.tp_attribute4(l_index) := oe_validate.g_attribute4;
3998: END IF;
3999:
4000: IF p_line_rec.tp_attribute5(l_index) IS NULL
3997: p_line_rec.tp_attribute4(l_index) := oe_validate.g_attribute4;
3998: END IF;
3999:
4000: IF p_line_rec.tp_attribute5(l_index) IS NULL
4001: OR p_line_rec.tp_attribute5(l_index) = FND_API.G_MISS_CHAR THEN
4002: p_line_rec.tp_attribute5(l_index) := oe_validate.g_attribute5;
4003: END IF;
4004:
4005: IF p_line_rec.tp_attribute6(l_index) IS NULL
4002: p_line_rec.tp_attribute5(l_index) := oe_validate.g_attribute5;
4003: END IF;
4004:
4005: IF p_line_rec.tp_attribute6(l_index) IS NULL
4006: OR p_line_rec.tp_attribute6(l_index) = FND_API.G_MISS_CHAR THEN
4007: p_line_rec.tp_attribute6(l_index) := oe_validate.g_attribute6;
4008: END IF;
4009:
4010: IF p_line_rec.tp_attribute7(l_index) IS NULL
4007: p_line_rec.tp_attribute6(l_index) := oe_validate.g_attribute6;
4008: END IF;
4009:
4010: IF p_line_rec.tp_attribute7(l_index) IS NULL
4011: OR p_line_rec.tp_attribute7(l_index) = FND_API.G_MISS_CHAR THEN
4012: p_line_rec.tp_attribute7(l_index) := oe_validate.g_attribute7;
4013: END IF;
4014:
4015: IF p_line_rec.tp_attribute8(l_index) IS NULL
4012: p_line_rec.tp_attribute7(l_index) := oe_validate.g_attribute7;
4013: END IF;
4014:
4015: IF p_line_rec.tp_attribute8(l_index) IS NULL
4016: OR p_line_rec.tp_attribute8(l_index) = FND_API.G_MISS_CHAR THEN
4017: p_line_rec.tp_attribute8(l_index) := oe_validate.g_attribute8;
4018: END IF;
4019:
4020: IF p_line_rec.tp_attribute9(l_index) IS NULL
4017: p_line_rec.tp_attribute8(l_index) := oe_validate.g_attribute8;
4018: END IF;
4019:
4020: IF p_line_rec.tp_attribute9(l_index) IS NULL
4021: OR p_line_rec.tp_attribute9(l_index) = FND_API.G_MISS_CHAR THEN
4022: p_line_rec.tp_attribute9(l_index) := oe_validate.g_attribute9;
4023: END IF;
4024:
4025: IF p_line_rec.tp_attribute10(l_index) IS NULL
4022: p_line_rec.tp_attribute9(l_index) := oe_validate.g_attribute9;
4023: END IF;
4024:
4025: IF p_line_rec.tp_attribute10(l_index) IS NULL
4026: OR p_line_rec.tp_attribute10(l_index) = FND_API.G_MISS_CHAR THEN
4027: p_line_rec.tp_attribute10(l_index) := Oe_validate.G_attribute10;
4028: End IF;
4029:
4030: IF p_line_rec.tp_attribute11(l_index) IS NULL
4027: p_line_rec.tp_attribute10(l_index) := Oe_validate.G_attribute10;
4028: End IF;
4029:
4030: IF p_line_rec.tp_attribute11(l_index) IS NULL
4031: OR p_line_rec.tp_attribute11(l_index) = FND_API.G_MISS_CHAR THEN
4032: p_line_rec.tp_attribute11(l_index) := oe_validate.g_attribute11;
4033: END IF;
4034:
4035: IF p_line_rec.tp_attribute12(l_index) IS NULL
4032: p_line_rec.tp_attribute11(l_index) := oe_validate.g_attribute11;
4033: END IF;
4034:
4035: IF p_line_rec.tp_attribute12(l_index) IS NULL
4036: OR p_line_rec.tp_attribute12(l_index) = FND_API.G_MISS_CHAR THEN
4037: p_line_rec.tp_attribute12(l_index) := oe_validate.g_attribute12;
4038: END IF;
4039:
4040: IF p_line_rec.tp_attribute13(l_index) IS NULL
4037: p_line_rec.tp_attribute12(l_index) := oe_validate.g_attribute12;
4038: END IF;
4039:
4040: IF p_line_rec.tp_attribute13(l_index) IS NULL
4041: OR p_line_rec.tp_attribute13(l_index) = FND_API.G_MISS_CHAR THEN
4042: p_line_rec.tp_attribute13(l_index) := oe_validate.g_attribute13;
4043: END IF;
4044:
4045: IF p_line_rec.tp_attribute14(l_index) IS NULL
4042: p_line_rec.tp_attribute13(l_index) := oe_validate.g_attribute13;
4043: END IF;
4044:
4045: IF p_line_rec.tp_attribute14(l_index) IS NULL
4046: OR p_line_rec.tp_attribute14(l_index) = FND_API.G_MISS_CHAR THEN
4047: p_line_rec.tp_attribute14(l_index) := oe_validate.g_attribute14;
4048: END IF;
4049:
4050: IF p_line_rec.tp_attribute15(l_index) IS NULL
4047: p_line_rec.tp_attribute14(l_index) := oe_validate.g_attribute14;
4048: END IF;
4049:
4050: IF p_line_rec.tp_attribute15(l_index) IS NULL
4051: OR p_line_rec.tp_attribute15(l_index) = FND_API.G_MISS_CHAR THEN
4052: p_line_rec.tp_attribute15(l_index) := oe_validate.g_attribute15;
4053: END IF;
4054: -- end of assignments, bug 2511313
4055:
4217: Check_Book_Reqd_Attributes(p_line_rec => p_line_rec
4218: ,p_index => l_index
4219: ,x_return_status => l_return_status);
4220:
4221: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4222: l_book_failed := TRUE;
4223: END IF;
4224:
4225: END IF;
4267: Check_Scheduling_Attributes(p_line_rec => p_line_rec
4268: ,p_index =>l_index
4269: ,x_return_status => l_return_status);
4270:
4271: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
4272:
4273: IF OE_BULK_CACHE.G_LINE_TYPE_TBL(l_d_index).scheduling_level_code = 'FOUR'
4274: OR OE_BULK_CACHE.G_LINE_TYPE_TBL(l_d_index).scheduling_level_code = 'FIVE'
4275: THEN
4518: l_book_failed := FALSE;
4519: END IF;
4520:
4521: EXCEPTION
4522: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4523: IF l_debug_level > 0 THEN
4524: oe_debug_pub.add( 'UNEXP ERROR , LINE.ENTITY' ) ;
4525: END IF;
4526: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4522: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4523: IF l_debug_level > 0 THEN
4524: oe_debug_pub.add( 'UNEXP ERROR , LINE.ENTITY' ) ;
4525: END IF;
4526: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4527: WHEN OTHERS THEN
4528: IF l_debug_level > 0 THEN
4529: oe_debug_pub.add( 'OTHERS ERROR , LINE.ENTITY' ) ;
4530: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 240 ) ) ;
4535: ( G_PKG_NAME
4536: , 'Entity'
4537: );
4538: END IF;
4539: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4540: END Entity;
4541:
4542: -- HVOP below routine is for Dual control items support INVCONV
4543:
4573:
4574: /* If neither quantity is present, then error as only called for a process type 1,2,or 3 ite m */
4575:
4576: IF (p_line_rec.ordered_quantity(p_index) IS NULL OR
4577: p_line_rec.ordered_quantity(p_index) = FND_API.G_MISS_NUM ) AND
4578: (p_line_rec.ordered_quantity2(p_index) IS NULL OR
4579: p_line_rec.ordered_quantity2(p_index) = FND_API.G_MISS_NUM ) THEN
4580: p_x_return_status := -1;
4581: IF l_debug_level > 0 THEN
4575:
4576: IF (p_line_rec.ordered_quantity(p_index) IS NULL OR
4577: p_line_rec.ordered_quantity(p_index) = FND_API.G_MISS_NUM ) AND
4578: (p_line_rec.ordered_quantity2(p_index) IS NULL OR
4579: p_line_rec.ordered_quantity2(p_index) = FND_API.G_MISS_NUM ) THEN
4580: p_x_return_status := -1;
4581: IF l_debug_level > 0 THEN
4582: oe_debug_pub.add ('calculate_dual_qty- both quantities empty so error ', 3);
4583: END IF;
4935: oe_debug_pub.add('Exception handling: UOM_CONVERSION_FAILED in calculate_dual_qauntity', 1);
4936: FND_MESSAGE.SET_NAME('INV','INV_NO_CONVERSION_ERR'); -- INVCONV
4937: OE_BULK_MSG_PUB.Add('Y', 'ERROR');
4938:
4939: RAISE FND_API.G_EXC_ERROR;
4940:
4941: WHEN TOLERANCE_ERROR THEN -- INVCONV
4942: oe_debug_pub.add('Exception handling: TOLERANCE_ERROR in calculate_dual_qty', 1);
4943: p_x_return_status := -1;
4940:
4941: WHEN TOLERANCE_ERROR THEN -- INVCONV
4942: oe_debug_pub.add('Exception handling: TOLERANCE_ERROR in calculate_dual_qty', 1);
4943: p_x_return_status := -1;
4944: --RAISE -- FND_API.G_EXC_ERROR; -- INVCONV
4945:
4946:
4947: WHEN OTHERS THEN
4948:
4953: 'Calculate_dual_quantity'
4954: );
4955: END IF;
4956: oe_debug_pub.add('Exception handling: others in calculate_dual_qty', 1);
4957: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4958:
4959:
4960:
4961: END calculate_dual_quantity;
5019: 'Get_Preferred_Grade'
5020: );
5021: END IF;
5022: oe_debug_pub.add('others in get_preferred_grade', 1);
5023: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5024:
5025:
5026: END Get_Preferred_Grade; */
5027:
5082: 'Load_Cust_Trx_Type_Id'
5083: );
5084: END IF;
5085: oe_debug_pub.add('others in Load_Cust_Trx_type_Id', 1);
5086: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5087: END Load_Cust_Trx_Type_Id;
5088:
5089: END OE_BULK_PROCESS_LINE;