[Home] [Help]
30: x_return_status := FND_API.G_RET_STS_ERROR;
31: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
32: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
33: OE_Order_UTIL.Get_Attribute_Name('SOLD_TO_ORG_ID'));
34: OE_MSG_PUB.ADD;
35: END IF;
36:
37: IF p_line_rec.invoice_to_org_id IS NULL THEN
38: x_return_status := FND_API.G_RET_STS_ERROR;
38: x_return_status := FND_API.G_RET_STS_ERROR;
39: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
40: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
41: OE_Order_UTIL.Get_Attribute_Name('INVOICE_TO_ORG_ID'));
42: OE_MSG_PUB.ADD;
43: END IF;
44:
45: IF p_line_rec.tax_exempt_flag IS NULL THEN
46: x_return_status := FND_API.G_RET_STS_ERROR;
46: x_return_status := FND_API.G_RET_STS_ERROR;
47: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
48: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
49: OE_Order_UTIL.Get_Attribute_Name('TAX_EXEMPT_FLAG'));
50: OE_MSG_PUB.ADD;
51: END IF;
52:
53:
54: -- Item, Quantity and UOM Required
56: x_return_status := FND_API.G_RET_STS_ERROR;
57: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
58: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
59: OE_Order_UTIL.Get_Attribute_Name('INVENTORY_ITEM_ID'));
60: OE_MSG_PUB.ADD;
61: END IF;
62:
63: IF p_line_rec.order_quantity_uom IS NULL THEN
64: x_return_status := FND_API.G_RET_STS_ERROR;
64: x_return_status := FND_API.G_RET_STS_ERROR;
65: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
66: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
67: OE_Order_UTIL.Get_Attribute_Name('ORDER_QUANTITY_UOM'));
68: OE_MSG_PUB.ADD;
69: END IF;
70:
71: -- Fix bug 1277092: ordered quantity should not be = 0 on a booked line
72: IF p_line_rec.ordered_quantity IS NULL
74: x_return_status := FND_API.G_RET_STS_ERROR;
75: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
76: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
77: OE_Order_UTIL.Get_Attribute_Name('ORDERED_QUANTITY'));
78: OE_MSG_PUB.ADD;
79: END IF;
80:
81: -- For all items that are NOT included items OR config items,
82: -- price list, unit selling price and unit list price are required.
96: x_return_status := FND_API.G_RET_STS_ERROR;
97: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
98: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
99: OE_Order_UTIL.Get_Attribute_Name('PRICE_LIST_ID'));
100: OE_MSG_PUB.ADD;
101: END IF;
102:
103: IF p_line_rec.unit_list_price IS NULL THEN
104: x_return_status := FND_API.G_RET_STS_ERROR;
104: x_return_status := FND_API.G_RET_STS_ERROR;
105: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
106: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
107: OE_Order_UTIL.Get_Attribute_Name('UNIT_LIST_PRICE'));
108: OE_MSG_PUB.ADD;
109: END IF;
110:
111: IF p_line_rec.unit_selling_price IS NULL THEN
112: x_return_status := FND_API.G_RET_STS_ERROR;
112: x_return_status := FND_API.G_RET_STS_ERROR;
113: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
114: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
115: OE_Order_UTIL.Get_Attribute_Name('UNIT_SELLING_PRICE'));
116: OE_MSG_PUB.ADD;
117: END IF;
118:
119: END IF; -- End of check for pricing attributes.
120:
129: x_return_status := FND_API.G_RET_STS_ERROR;
130: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
131: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
132: OE_Order_UTIL.Get_Attribute_Name('SHIP_TO_ORG_ID'));
133: OE_MSG_PUB.ADD;
134: END IF;
135:
136: IF p_line_rec.payment_term_id IS NULL THEN
137: x_return_status := FND_API.G_RET_STS_ERROR;
137: x_return_status := FND_API.G_RET_STS_ERROR;
138: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
139: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
140: OE_Order_UTIL.Get_Attribute_Name('PAYMENT_TERM_ID'));
141: OE_MSG_PUB.ADD;
142: END IF;
143:
144: END IF;
145:
152: x_return_status := FND_API.G_RET_STS_ERROR;
153: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_RETURN_ATTRIBUTE');
154: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
155: OE_Order_UTIL.Get_Attribute_Name('SHIP_FROM_ORG_ID'));
156: OE_MSG_PUB.ADD;
157: END IF;
158:
159: IF p_line_rec.request_date IS NULL THEN
160: x_return_status := FND_API.G_RET_STS_ERROR;
160: x_return_status := FND_API.G_RET_STS_ERROR;
161: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_RETURN_ATTRIBUTE');
162: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
163: OE_Order_UTIL.Get_Attribute_Name('REQUEST_DATE'));
164: OE_MSG_PUB.ADD;
165: END IF;
166:
167: END IF;
168:
173: x_return_status := FND_API.G_RET_STS_ERROR;
174: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_RETURN_ATTRIBUTE');
175: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
176: OE_Order_UTIL.Get_Attribute_Name('TAX_DATE'));
177: OE_MSG_PUB.ADD;
178: END IF;
179:
180: -- Tax code is required under following conditions.
181: -- 1. The tax hadnling is required at line level.
212: AND p_line_rec.tax_code IS NULL
213: THEN
214: x_return_status := FND_API.G_RET_STS_ERROR;
215: FND_MESSAGE.SET_NAME('ONT','OE_VAL_TAX_CODE_REQD');
216: OE_MSG_PUB.ADD;
217: END IF;*/
218:
219: /* Added by Manish */
220:
225: x_return_status := FND_API.G_RET_STS_ERROR;
226: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_SERVICE_DURATION');
227: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
228: OE_Order_UTIL.Get_Attribute_Name('SERVICE_DURATION'));
229: OE_MSG_PUB.ADD;
230: END IF;
231: END IF;
232: ------------------------------------------------------------------------
233: --Check over return
239: THEN
240: IF (OE_LINE_UTIL.Is_Over_Return(p_line_rec)) THEN
241: x_return_status := FND_API.G_RET_STS_ERROR;
242: FND_MESSAGE.Set_Name('ONT', 'OE_RETURN_INVALID_QUANTITY');
243: OE_MSG_PUB.ADD;
244: END IF;
245: END IF;
246:
247: OE_DEBUG_PUB.Add('Entering OE_CNCL_VALIDATE_LINE.Check_Book_Reqd_Attributes',1);
248:
249: EXCEPTION
250: WHEN OTHERS THEN
251: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
252: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
253: THEN
254: OE_MSG_PUB.Add_Exc_Msg
255: ( G_PKG_NAME
256: , 'Check_Book_Reqd_Attributes'
250: WHEN OTHERS THEN
251: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
252: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
253: THEN
254: OE_MSG_PUB.Add_Exc_Msg
255: ( G_PKG_NAME
256: , 'Check_Book_Reqd_Attributes'
257: );
258: END IF;
304: IF p_item_type_code IN ('MODEL', 'OPTION', 'KIT',
305: 'CLASS','INCLUDED', 'CONFIG') THEN
306: oe_debug_pub.add('item is config related with decimal qty',2);
307: FND_MESSAGE.SET_NAME('ONT', 'OE_CONFIG_NO_DECIMALS');
308: OE_MSG_PUB.Add;
309: x_return_status := FND_API.G_RET_STS_ERROR;
310:
311: ELSE
312:
331: fnd_message.set_name('ONT', 'OE_DECIMAL_MAX_PRECISION');
332: END IF;
333:
334: -- move INV error message to OE message stack
335: oe_msg_pub.add;
336: x_return_status := FND_API.G_RET_STS_ERROR;
337: END IF;
338:
339: END IF; -- config related item type
400:
401: IF lexists IS NULL THEN
402: oe_debug_pub.add('No explicit assignment exists',2);
403: FND_MESSAGE.SET_NAME('ONT','OE_EXP_ASSIGN_REQ');
404: OE_MSG_PUB.ADD;
405: RAISE FND_API.G_EXC_ERROR;
406: END IF;
407:
408: END IF;
410: OE_DEBUG_PUB.Add('Exiting OE_CNCL_VALIDATE_LINE.Validate_Line_Type',1);
411: EXCEPTION
412: WHEN NO_DATA_FOUND THEN
413: FND_MESSAGE.SET_NAME('ONT','OE_FLOW_CNT_CHANGE');
414: OE_MSG_PUB.ADD;
415: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
416: WHEN FND_API.G_EXC_ERROR THEN
417: RAISE FND_API.G_EXC_ERROR;
418:
416: WHEN FND_API.G_EXC_ERROR THEN
417: RAISE FND_API.G_EXC_ERROR;
418:
419: WHEN OTHERS THEN
420: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
421: THEN
422: OE_MSG_PUB.Add_Exc_Msg
423: ( G_PKG_NAME ,
424: 'Validate_Line_Type'
418:
419: WHEN OTHERS THEN
420: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
421: THEN
422: OE_MSG_PUB.Add_Exc_Msg
423: ( G_PKG_NAME ,
424: 'Validate_Line_Type'
425: );
426: END IF;
454: RETURN TRUE;
455: EXCEPTION
456: WHEN NO_DATA_FOUND THEN
457: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ITEM_WHSE');
458: OE_MSG_PUB.add;
459: RETURN FALSE;
460: WHEN OTHERS THEN
461: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ITEM_WHSE');
462: OE_MSG_PUB.add;
458: OE_MSG_PUB.add;
459: RETURN FALSE;
460: WHEN OTHERS THEN
461: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ITEM_WHSE');
462: OE_MSG_PUB.add;
463: RETURN FALSE;
464: END Validate_Receiving_Org;
465:
466: FUNCTION Validate_Item_Warehouse
510: WHEN NO_DATA_FOUND THEN
511: oe_debug_pub.add('RR: No data found',1);
512:
513: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ITEM_WHSE');
514: OE_MSG_PUB.add;
515: RETURN FALSE;
516:
517: WHEN OTHERS THEN
518: oe_debug_pub.add('RR: OTHERS',1);
516:
517: WHEN OTHERS THEN
518: oe_debug_pub.add('RR: OTHERS',1);
519: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ITEM_WHSE');
520: OE_MSG_PUB.add;
521: RETURN FALSE;
522:
523: END Validate_Item_Warehouse;
524:
686: ELSIF (l_profile = 'R') THEN
687: RETURN FALSE;
688: ELSE -- warning
689: FND_MESSAGE.SET_NAME('ONT','OE_RETURN_ITEM_MISMATCH_WARNIN');
690: OE_MSG_PUB.ADD;
691: END IF;
692:
693: END IF;
694:
756: ELSIF (l_profile = 'R') THEN
757: RETURN FALSE;
758: ELSE -- warning
759: FND_MESSAGE.SET_NAME('ONT','OE_UNFULFILLED_LINE_WARNING');
760: OE_MSG_PUB.ADD;
761: END IF;
762:
763: END IF;
764:
822: IF l_booked_flag = 'Y' THEN
823: RETURN TRUE;
824: ELSE
825: fnd_message.set_name('ONT', 'OE_RETURN_UNBOOKED_ORDER');
826: OE_MSG_PUB.Add;
827: END IF;
828:
829: oe_debug_pub.add('Exit Validate_Return_Reference',1);
830: RETURN FALSE;
832: EXCEPTION
833: WHEN NO_DATA_FOUND THEN
834: oe_debug_pub.add('Validate_Return_Reference: No data found',1);
835: fnd_message.set_name('ONT', 'OE_RETURN_INVALID_SO_LINE');
836: OE_MSG_PUB.Add;
837: RETURN FALSE;
838: WHEN OTHERS THEN
839: oe_debug_pub.add('Validate_Return_Reference: When Others',1);
840: fnd_message.set_name('ONT', 'OE_RETURN_INVALID_SO_LINE');
837: RETURN FALSE;
838: WHEN OTHERS THEN
839: oe_debug_pub.add('Validate_Return_Reference: When Others',1);
840: fnd_message.set_name('ONT', 'OE_RETURN_INVALID_SO_LINE');
841: OE_MSG_PUB.Add;
842: RETURN FALSE;
843: END Validate_Return_Reference;
844:
845:
1042: THEN
1043: oe_debug_pub.add('servie / part of smc model', 4);
1044: FND_MESSAGE.SET_NAME('ONT', 'OE_DS_NOT_VALID_ITEM');
1045: FND_MESSAGE.SET_TOKEN('ITEM', p_line_rec.ordered_item);
1046: OE_MSG_PUB.Add;
1047: x_return_status := FND_API.G_RET_STS_ERROR;
1048: RETURN;
1049: ELSE
1050: oe_debug_pub.add('validate line: pack H new logic DS', 1);
1052: ELSE
1053: IF (p_line_rec.item_type_code <> OE_GLOBALS.G_ITEM_STANDARD) THEN
1054: oe_debug_pub.add('Cannot dropship non-standard item',2);
1055: FND_MESSAGE.SET_NAME('ONT', 'OE_DS_NOT_ALLOWED');
1056: OE_MSG_PUB.Add;
1057: x_return_status := FND_API.G_RET_STS_ERROR;
1058: RETURN;
1059: END IF;
1060: END IF;
1064: p_line_rec.arrival_set_id is not null THEN
1065:
1066: oe_debug_pub.add('Cannot insert external line to set',2);
1067: FND_MESSAGE.SET_NAME('ONT', 'OE_DS_SET_INS_FAILED');
1068: OE_MSG_PUB.Add;
1069: x_return_status := FND_API.G_RET_STS_ERROR;
1070: RETURN;
1071: END IF;
1072:
1091: FND_MESSAGE.SET_NAME('ONT', 'OE_DS_NOT_ENABLED');
1092: FND_MESSAGE.SET_TOKEN('ITEM', nvl(p_line_rec.ship_from_org_id,
1093: OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID')));
1094: FND_MESSAGE.SET_TOKEN('ORG', p_line_rec.ordered_item);
1095: OE_MSG_PUB.Add;
1096: x_return_status := FND_API.G_RET_STS_ERROR;
1097: END IF;
1098:
1099: END IF;
1239:
1240: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
1241: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1242: OE_Order_UTIL.Get_Attribute_Name('INVENTORY_ITEM_ID'));
1243: OE_MSG_PUB.Add;
1244:
1245: END IF;
1246:
1247: oe_debug_pub.add('3 '||l_return_status, 1);
1252:
1253: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
1254: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1255: OE_Order_UTIL.Get_Attribute_Name('LINE_TYPE_ID'));
1256: OE_MSG_PUB.Add;
1257:
1258: ELSIF p_line_rec.line_type_id IS NOT NULL THEN
1259: Validate_line_type(p_line_rec => p_line_rec);
1260:
1282:
1283: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
1284: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1285: OE_Order_UTIL.Get_Attribute_Name('RETURN_REASON_CODE'));
1286: OE_MSG_PUB.Add;
1287:
1288: END IF;
1289:
1290:
1300: IF p_line_rec.ship_from_org_id is null THEN
1301: l_return_status := FND_API.G_RET_STS_ERROR;
1302: fnd_message.set_name('ONT', 'OE_ATTRIBUTE_REQUIRED');
1303: fnd_message.set_token('ATTRIBUTE',OE_Order_UTIL.Get_Attribute_Name('SHIP_FROM_ORG_ID'));
1304: OE_MSG_PUB.Add;
1305: END IF;
1306: ELSE -- external
1307: l_return_status := FND_API.G_RET_STS_ERROR;
1308: fnd_message.set_name('ONT', 'OE_SUBINV_EXTERNAL');
1305: END IF;
1306: ELSE -- external
1307: l_return_status := FND_API.G_RET_STS_ERROR;
1308: fnd_message.set_name('ONT', 'OE_SUBINV_EXTERNAL');
1309: OE_MSG_PUB.Add;
1310: END IF;
1311: END IF;
1312:
1313: -- end subinventory
1381:
1382: l_return_status := FND_API.G_RET_STS_ERROR;
1383: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
1384: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Ordered_Quantity2');
1385: OE_MSG_PUB.Add;
1386:
1387: ELSIF (p_line_rec.ordered_quantity2 <> FND_API.G_MISS_NUM OR
1388: p_line_rec.ordered_quantity2 IS NOT NULL) AND
1389: (p_line_rec.ordered_quantity IS NULL) THEN
1390:
1391: l_return_status := FND_API.G_RET_STS_ERROR;
1392: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
1393: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Ordered_Quantity');
1394: OE_MSG_PUB.Add;
1395: END IF; -- IF (p_line_rec.ordered_quantity <> FND_API.G_MISS_NUM OR
1396: END IF; -- IF l_item_rec.tracking_quantity_ind = 'PS' IF l_item_rec.dualum_ind in (1,2,3) THEN
1397:
1398: /* If qty1/qty2 both populated, check tolerances
1425: END IF;
1426:
1427: l_buffer := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST, -- INVCONV
1428: p_encoded => 'F');
1429: oe_msg_pub.add_text(p_message_text => l_buffer);
1430: IF l_debug_level > 0 THEN
1431: oe_debug_pub.add(l_buffer,1);
1432: END IF;
1433: l_return_status := FND_API.G_RET_STS_ERROR;
1459: -- OPM END 06/22
1460: IF(l_return = -68) THEN
1461: l_return_status := FND_API.G_RET_STS_ERROR;
1462: FND_MESSAGE.set_name('GMI', 'IC_DEVIATION_HI_ERR');
1463: OE_MSG_PUB.Add;
1464: ELSIF (l_return = -69) THEN
1465: l_return_status := FND_API.G_RET_STS_ERROR;
1466: FND_MESSAGE.set_name('GMI', 'IC_DEVIATION_LO_ERR');
1467: OE_MSG_PUB.Add;
1463: OE_MSG_PUB.Add;
1464: ELSIF (l_return = -69) THEN
1465: l_return_status := FND_API.G_RET_STS_ERROR;
1466: FND_MESSAGE.set_name('GMI', 'IC_DEVIATION_LO_ERR');
1467: OE_MSG_PUB.Add;
1468: END IF; */
1469:
1470:
1471: END IF; -- IF (p_line_rec.ordered_quantity <> FND_API.G_MISS_NUM AND
1648: THEN
1649:
1650: IF (p_line_rec.reserved_quantity > p_line_rec.ordered_quantity) THEN
1651: fnd_message.set_name('ONT','OE_SCH_RES_MORE_ORD_QTY');
1652: OE_MSG_PUB.Add;
1653: l_return_status := FND_API.G_RET_STS_ERROR;
1654: END IF;
1655:
1656: END IF;*/
1673: -- error out for this item.
1674:
1675: IF p_line_rec.item_type_code <> OE_GLOBALS.G_ITEM_CONFIG THEN
1676: FND_MESSAGE.SET_NAME('ONT','OE_SCH_INVALID_CHANGE');
1677: OE_MSG_PUB.Add;
1678: l_return_status := FND_API.G_RET_STS_ERROR;
1679: END IF;
1680:
1681: END IF;
1693: AND p_line_rec.ship_from_org_id IS NULL) THEN
1694:
1695: l_return_status := FND_API.G_RET_STS_ERROR;
1696: FND_MESSAGE.SET_NAME('ONT', 'OE_SHIP_FROM_REQD');
1697: OE_MSG_PUB.add;
1698: ELSIF (p_line_rec.task_id IS NOT NULL
1699: AND p_line_rec.project_id IS NULL) THEN
1700:
1701: l_return_status := FND_API.G_RET_STS_ERROR;
1699: AND p_line_rec.project_id IS NULL) THEN
1700:
1701: l_return_status := FND_API.G_RET_STS_ERROR;
1702: FND_MESSAGE.SET_NAME('ONT', 'OE_VAL_PROJECT_REQD');
1703: OE_MSG_PUB.add;
1704:
1705: END IF;
1706:
1707: -- Added Code for Enhanced Project Validation and Controls.
1735: OE_DEBUG_PUB.Add('Validate Proj References Result:'||
1736: result,1);
1737:
1738: IF result <> PJM_PROJECT.G_VALIDATE_SUCCESS THEN
1739: OE_MSG_PUB.Transfer_Msg_Stack;
1740: l_msg_count:=OE_MSG_PUB.COUNT_MSG;
1741: FOR I in 1..l_msg_count loop
1742: l_msg_data := OE_MSG_PUB.Get(I,'F');
1743: OE_DEBUG_PUB.add(l_msg_data,1);
1736: result,1);
1737:
1738: IF result <> PJM_PROJECT.G_VALIDATE_SUCCESS THEN
1739: OE_MSG_PUB.Transfer_Msg_Stack;
1740: l_msg_count:=OE_MSG_PUB.COUNT_MSG;
1741: FOR I in 1..l_msg_count loop
1742: l_msg_data := OE_MSG_PUB.Get(I,'F');
1743: OE_DEBUG_PUB.add(l_msg_data,1);
1744: END LOOP;
1738: IF result <> PJM_PROJECT.G_VALIDATE_SUCCESS THEN
1739: OE_MSG_PUB.Transfer_Msg_Stack;
1740: l_msg_count:=OE_MSG_PUB.COUNT_MSG;
1741: FOR I in 1..l_msg_count loop
1742: l_msg_data := OE_MSG_PUB.Get(I,'F');
1743: OE_DEBUG_PUB.add(l_msg_data,1);
1744: END LOOP;
1745: END IF;
1746:
1764: p_line_rec.ship_from_org_id) IS NULL THEN
1765:
1766: l_return_status := FND_API.G_RET_STS_ERROR;
1767: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_SHIP_FROM_PROJ');
1768: OE_MSG_PUB.add;
1769: END IF;
1770:
1771: END IF;
1772:
1774: AND p_line_rec.project_id IS NULL) THEN
1775:
1776: l_return_status := FND_API.G_RET_STS_ERROR;
1777: FND_MESSAGE.SET_NAME('ONT', 'OE_VAL_PROJECT_REQD');
1778: OE_MSG_PUB.add;
1779:
1780: ELSIF (p_line_rec.task_id is NOT NULL
1781: AND p_line_rec.project_id IS NOT NULL) THEN
1782:
1784: p_line_rec.project_id,
1785: p_line_rec.task_id) THEN
1786:
1787: l_return_status := FND_API.G_RET_STS_ERROR;
1788: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'TASK_ID');
1789: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1790: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1791: OE_Order_Util.Get_Attribute_Name('task_id'));
1792: OE_MSG_PUB.Add;
1788: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'TASK_ID');
1789: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1790: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1791: OE_Order_Util.Get_Attribute_Name('task_id'));
1792: OE_MSG_PUB.Add;
1793: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
1794:
1795: END IF;
1796:
1789: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1790: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1791: OE_Order_Util.Get_Attribute_Name('task_id'));
1792: OE_MSG_PUB.Add;
1793: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
1794:
1795: END IF;
1796:
1797: ELSIF (p_line_rec.task_id is NULL
1802: p_line_rec.ship_from_org_id) THEN
1803:
1804: l_return_status := FND_API.G_RET_STS_ERROR;
1805: FND_MESSAGE.SET_NAME('ONT', 'OE_VAL_TASK_REQD');
1806: OE_MSG_PUB.ADD;
1807:
1808: END IF;
1809:
1810: END IF;
1822: THEN
1823:
1824: l_return_status := FND_API.G_RET_STS_ERROR;
1825: fnd_message.set_name('ONT', 'OE_UEFF_NUMBER_REQD');
1826: OE_MSG_PUB.add;
1827: END IF;
1828:
1829: END IF;
1830: ELSE -- When project manufacturing is not enabled at the site.
1833: p_line_rec.task_id IS NOT NULL OR
1834: p_line_rec.end_item_unit_number IS NOT NULL) THEN
1835: l_return_status := FND_API.G_RET_STS_ERROR;
1836: fnd_message.set_name('ONT', 'OE_PJM_NOT_INSTALLED');
1837: OE_MSG_PUB.add;
1838:
1839: END IF;
1840:
1841:
1853: --AND p_line_rec.line_id <> p_line_rec.ato_line_id
1854: THEN
1855:
1856: FND_MESSAGE.SET_NAME('ONT', 'OE_VAL_PROJ_UPD');
1857: OE_MSG_PUB.add;
1858:
1859:
1860: END IF;
1861:
1875: , p_line_rec.sold_to_org_id)
1876: THEN
1877: l_return_status := FND_API.G_RET_STS_ERROR;
1878: fnd_message.set_name('ONT', 'OE_ITEM_VALIDATION_FAILED');
1879: OE_MSG_PUB.add;
1880: END IF;
1881:
1882: END IF;
1883:
1893: )
1894: THEN
1895: l_return_status := FND_API.G_RET_STS_ERROR;
1896: fnd_message.set_name('ONT', 'OE_RETURN_ITEM_MISMATCH_REJECT');
1897: OE_MSG_PUB.add;
1898: END IF;
1899: END IF;
1900:
1901: oe_debug_pub.add('13 '||l_return_status, 1);
1909: )
1910: THEN
1911: l_return_status := FND_API.G_RET_STS_ERROR;
1912: fnd_message.set_name('ONT', 'OE_UNFULFILLED_LINE_REJECT');
1913: OE_MSG_PUB.add;
1914: END IF;
1915:
1916: END IF;
1917:
1925: p_line_rec.ship_from_org_id)
1926: THEN
1927: l_return_status := FND_API.G_RET_STS_ERROR;
1928: fnd_message.set_name('ONT', 'OE_ITEM_NOT_RETURNABLE');
1929: OE_MSG_PUB.add;
1930: END IF;
1931: END IF;
1932:
1933:
1953: NVL(p_line_rec.ordered_quantity,1) <> 1)
1954: THEN
1955: l_return_status := FND_API.G_RET_STS_ERROR;
1956: fnd_message.set_name('ONT','OE_SERIAL_REFERENCED_RMA');
1957: OE_MSG_PUB.Add;
1958: END IF;
1959:
1960:
1961: oe_debug_pub.add('14_3 '||l_return_status, 1);
1971: l_return_status := FND_API.G_RET_STS_ERROR;
1972: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1973: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1974: OE_Order_Util.Get_Attribute_Name('ship_to_org_id'));
1975: OE_MSG_PUB.Add;
1976: END IF;
1977:
1978: END IF;
1979:
2007: l_return_status := FND_API.G_RET_STS_ERROR;
2008: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
2009: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2010: OE_Order_Util.Get_Attribute_Name('ship_to_contact_id'));
2011: OE_MSG_PUB.Add;
2012: WHEN OTHERS THEN
2013: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2014: OE_MSG_PUB.Add_Exc_Msg
2015: ( G_PKG_NAME ,
2009: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2010: OE_Order_Util.Get_Attribute_Name('ship_to_contact_id'));
2011: OE_MSG_PUB.Add;
2012: WHEN OTHERS THEN
2013: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2014: OE_MSG_PUB.Add_Exc_Msg
2015: ( G_PKG_NAME ,
2016: 'Record - Ship To Contact validation '
2017: );
2010: OE_Order_Util.Get_Attribute_Name('ship_to_contact_id'));
2011: OE_MSG_PUB.Add;
2012: WHEN OTHERS THEN
2013: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2014: OE_MSG_PUB.Add_Exc_Msg
2015: ( G_PKG_NAME ,
2016: 'Record - Ship To Contact validation '
2017: );
2018: END IF;
2033: l_return_status := FND_API.G_RET_STS_ERROR;
2034: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2035: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2036: OE_Order_Util.Get_Attribute_Name('deliver_to_org_id'));
2037: OE_MSG_PUB.Add;
2038: END IF;
2039:
2040: END IF;
2041:
2068: l_return_status := FND_API.G_RET_STS_ERROR;
2069: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
2070: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2071: OE_Order_Util.Get_Attribute_Name('deliver_to_contact_id'));
2072: OE_MSG_PUB.Add;
2073: WHEN OTHERS THEN
2074: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2075: OE_MSG_PUB.Add_Exc_Msg
2076: ( G_PKG_NAME ,
2070: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2071: OE_Order_Util.Get_Attribute_Name('deliver_to_contact_id'));
2072: OE_MSG_PUB.Add;
2073: WHEN OTHERS THEN
2074: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2075: OE_MSG_PUB.Add_Exc_Msg
2076: ( G_PKG_NAME ,
2077: 'Record - Deliver To Contact validation '
2078: );
2071: OE_Order_Util.Get_Attribute_Name('deliver_to_contact_id'));
2072: OE_MSG_PUB.Add;
2073: WHEN OTHERS THEN
2074: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2075: OE_MSG_PUB.Add_Exc_Msg
2076: ( G_PKG_NAME ,
2077: 'Record - Deliver To Contact validation '
2078: );
2079: END IF;
2144: l_return_status := FND_API.G_RET_STS_ERROR;
2145: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
2146: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2147: OE_Order_Util.Get_Attribute_Name('invoice_to_org_id'));
2148: OE_MSG_PUB.Add;
2149: WHEN OTHERS THEN
2150: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2151: OE_MSG_PUB.Add_Exc_Msg
2152: ( G_PKG_NAME ,
2146: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2147: OE_Order_Util.Get_Attribute_Name('invoice_to_org_id'));
2148: OE_MSG_PUB.Add;
2149: WHEN OTHERS THEN
2150: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2151: OE_MSG_PUB.Add_Exc_Msg
2152: ( G_PKG_NAME ,
2153: 'Record - Invoice To Org validation '
2154: );
2147: OE_Order_Util.Get_Attribute_Name('invoice_to_org_id'));
2148: OE_MSG_PUB.Add;
2149: WHEN OTHERS THEN
2150: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2151: OE_MSG_PUB.Add_Exc_Msg
2152: ( G_PKG_NAME ,
2153: 'Record - Invoice To Org validation '
2154: );
2155: END IF;
2186: l_return_status := FND_API.G_RET_STS_ERROR;
2187: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
2188: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2189: OE_Order_Util.Get_Attribute_Name('invoice_to_contact_id'));
2190: OE_MSG_PUB.Add;
2191: WHEN OTHERS THEN
2192: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2193: OE_MSG_PUB.Add_Exc_Msg
2194: ( G_PKG_NAME ,
2188: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2189: OE_Order_Util.Get_Attribute_Name('invoice_to_contact_id'));
2190: OE_MSG_PUB.Add;
2191: WHEN OTHERS THEN
2192: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2193: OE_MSG_PUB.Add_Exc_Msg
2194: ( G_PKG_NAME ,
2195: 'Record - Invoice To Contact validation '
2196: );
2189: OE_Order_Util.Get_Attribute_Name('invoice_to_contact_id'));
2190: OE_MSG_PUB.Add;
2191: WHEN OTHERS THEN
2192: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2193: OE_MSG_PUB.Add_Exc_Msg
2194: ( G_PKG_NAME ,
2195: 'Record - Invoice To Contact validation '
2196: );
2197: END IF;
2251: l_return_status := FND_API.G_RET_STS_ERROR;
2252: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
2253: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2254: OE_Order_Util.Get_Attribute_Name('TAX_CODE'));
2255: OE_MSG_PUB.Add;
2256:
2257: WHEN OTHERS THEN
2258: IF OE_MSG_PUB.Check_Msg_Level (
2259: OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2254: OE_Order_Util.Get_Attribute_Name('TAX_CODE'));
2255: OE_MSG_PUB.Add;
2256:
2257: WHEN OTHERS THEN
2258: IF OE_MSG_PUB.Check_Msg_Level (
2259: OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2260: THEN
2261: OE_MSG_PUB.Add_Exc_Msg
2262: ( G_PKG_NAME ,
2255: OE_MSG_PUB.Add;
2256:
2257: WHEN OTHERS THEN
2258: IF OE_MSG_PUB.Check_Msg_Level (
2259: OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2260: THEN
2261: OE_MSG_PUB.Add_Exc_Msg
2262: ( G_PKG_NAME ,
2263: 'Record - Tax Code validation '
2257: WHEN OTHERS THEN
2258: IF OE_MSG_PUB.Check_Msg_Level (
2259: OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2260: THEN
2261: OE_MSG_PUB.Add_Exc_Msg
2262: ( G_PKG_NAME ,
2263: 'Record - Tax Code validation '
2264: );
2265: END IF;
2275: -- Check for Tax exempt reason
2276: IF p_line_rec.tax_exempt_reason_code IS NULL
2277: THEN
2278: l_return_status := FND_API.G_RET_STS_ERROR;
2279: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_ERROR)
2280: THEN
2281: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
2282: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2283: OE_Order_Util.Get_Attribute_Name('TAX_EXEMPT_REASON_CODE'));
2280: THEN
2281: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
2282: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2283: OE_Order_Util.Get_Attribute_Name('TAX_EXEMPT_REASON_CODE'));
2284: OE_MSG_PUB.Add;
2285: END IF;
2286: END IF;
2287: END IF; -- If Tax handling is exempt
2288:
2297: (p_line_rec.tax_exempt_number IS NOT NULL OR
2298: p_line_rec.tax_exempt_reason_code IS NOT NULL)
2299: THEN
2300: l_return_status := FND_API.G_RET_STS_ERROR;
2301: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_ERROR)
2302: THEN
2303: fnd_message.set_name('ONT','OE_TAX_EXEMPTION_NOT_ALLOWED');
2304: OE_MSG_PUB.Add;
2305: END IF;
2300: l_return_status := FND_API.G_RET_STS_ERROR;
2301: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_ERROR)
2302: THEN
2303: fnd_message.set_name('ONT','OE_TAX_EXEMPTION_NOT_ALLOWED');
2304: OE_MSG_PUB.Add;
2305: END IF;
2306:
2307: END IF; -- If Tax handling is Required
2308:
2387: WHEN NO_DATA_FOUND THEN
2388:
2389: l_return_status := FND_API.G_RET_STS_ERROR;
2390:
2391: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2392: THEN
2393: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2394: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2395: OE_Order_Util.Get_Attribute_Name('TAX_EXEMPT_NUMBER'));
2392: THEN
2393: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2394: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2395: OE_Order_Util.Get_Attribute_Name('TAX_EXEMPT_NUMBER'));
2396: OE_MSG_PUB.Add;
2397: END IF;
2398:
2399: WHEN OTHERS THEN
2400: IF OE_MSG_PUB.Check_Msg_Level (
2396: OE_MSG_PUB.Add;
2397: END IF;
2398:
2399: WHEN OTHERS THEN
2400: IF OE_MSG_PUB.Check_Msg_Level (
2401: OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2402: THEN
2403: OE_MSG_PUB.Add_Exc_Msg
2404: ( G_PKG_NAME ,
2397: END IF;
2398:
2399: WHEN OTHERS THEN
2400: IF OE_MSG_PUB.Check_Msg_Level (
2401: OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2402: THEN
2403: OE_MSG_PUB.Add_Exc_Msg
2404: ( G_PKG_NAME ,
2405: 'Record - Tax Exemptions '
2399: WHEN OTHERS THEN
2400: IF OE_MSG_PUB.Check_Msg_Level (
2401: OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2402: THEN
2403: OE_MSG_PUB.Add_Exc_Msg
2404: ( G_PKG_NAME ,
2405: 'Record - Tax Exemptions '
2406: );
2407: END IF;
2438:
2439: fnd_message.set_name('ONT','OE_INVALID_ORDER_QUANTITY_UOM');
2440: fnd_message.set_token('ITEM',p_line_rec.ordered_item );
2441: fnd_message.set_token('UOM', l_uom);
2442: OE_MSG_PUB.Add;
2443: RAISE FND_API.G_EXC_ERROR;
2444: END IF;
2445: EXCEPTION
2446: when no_data_found then
2461:
2462: IF l_uom_count = 0 THEN
2463: oe_debug_pub.add('uom/item combination invalid',2);
2464: fnd_message.set_name('ONT', 'OE_INVALID_ITEM_UOM');
2465: OE_MSG_PUB.Add;
2466: RAISE FND_API.G_EXC_ERROR;
2467: END IF;
2468: */
2469:
2477: oe_debug_pub.add('uom/item combination invalid',2);
2478: end if;
2479:
2480: fnd_message.set_name('ONT', 'OE_INVALID_ITEM_UOM');
2481: OE_MSG_PUB.Add;
2482: RAISE FND_API.G_EXC_ERROR;
2483: END IF;
2484:
2485:
2541: WHEN NO_DATA_FOUND THEN
2542: l_price_list_name := l_price_list_id;
2543: END;
2544: fnd_message.set_Token('PRICE_LIST2', l_price_list_name);
2545: OE_MSG_PUB.Add;
2546: oe_debug_pub.add('Invalid Agreement +price_list_id combination',2);
2547: raise FND_API.G_EXC_ERROR;
2548: END IF;
2549: END IF; -- end of if l_list_type_code <> 'PRL'
2556: fnd_message.set_name('ONT', 'OE_INVALID_AGREEMENT');
2557: fnd_message.set_Token('AGREEMENT_ID', p_line_rec.agreement_id);
2558: fnd_message.set_Token('AGREEMENT_NAME', l_agreement_name);
2559: fnd_message.set_Token('CUSTOMER_ID', p_line_rec.sold_to_org_id);
2560: OE_MSG_PUB.Add;
2561: oe_debug_pub.add('Invalid Agreement +sold_org_id combination',2);
2562: RAISE FND_API.G_EXC_ERROR;
2563: ELSIF lcustomer_relations = 'Y' THEN
2564:
2582: fnd_message.set_name('ONT', 'OE_INVALID_AGREEMENT');
2583: fnd_message.set_Token('AGREEMENT_ID', p_line_rec.agreement_id);
2584: fnd_message.set_Token('AGREEMENT_NAME', l_agreement_name);
2585: fnd_message.set_Token('CUSTOMER_ID', p_line_rec.sold_to_org_id);
2586: OE_MSG_PUB.Add;
2587: oe_debug_pub.add('Invalid Agreement +sold_org_id combination',2);
2588: RAISE FND_API.G_EXC_ERROR;
2589: END;
2590: END IF;
2596: fnd_message.set_name('ONT', 'OE_INVALID_AGREEMENT');
2597: fnd_message.set_Token('AGREEMENT_ID', p_line_rec.agreement_id);
2598: fnd_message.set_Token('AGREEMENT_NAME', l_agreement_name);
2599: fnd_message.set_Token('CUSTOMER_ID', l_sold_to_org);
2600: OE_MSG_PUB.Add;
2601: oe_debug_pub.add('Invalid Agreement +sold_org_id combination',2);
2602: RAISE FND_API.G_EXC_ERROR;
2603: END;
2604: END IF; -- Agreement has changed
2625: WHEN NO_DATA_FOUND THEN
2626: fnd_message.set_name('ONT', 'OE_INVALID_NONAGR_PLIST');
2627: fnd_message.set_Token('PRICE_LIST1', p_line_rec.price_list_id);
2628: fnd_message.set_Token('PRICING_DATE', p_line_rec.pricing_date);
2629: OE_MSG_PUB.Add;
2630: oe_debug_pub.add('Invalid non agreement price list ',2);
2631: RAISE FND_API.G_EXC_ERROR;
2632: END;
2633:
2654: IF (NOT OE_GLOBALS.EQUAL(p_line_rec.line_number,null)) THEN
2655:
2656: l_return_status := FND_API.G_RET_STS_ERROR;
2657: fnd_message.set_name('ONT', 'OE_LINE_NUMBER_UPD');
2658: OE_MSG_PUB.add;
2659:
2660: END IF;
2661: END IF;
2662:
2690: oe_debug_pub.add('Ordered Qty cannot be greater than 1 for OTA lines',
2691: 1);
2692: l_return_status := FND_API.G_RET_STS_ERROR;
2693: FND_Message.Set_Name('ONT', 'OE_OTA_INVALID_QTY');
2694: oe_msg_pub.add;
2695: END IF;
2696:
2697: /* End of validation for OTA */
2698:
2708: ,p_line_rec.sold_to_org_id
2709: ,p_line_rec.header_id )
2710: THEN
2711: FND_MESSAGE.SET_NAME('ONT','OE_VAL_DUP_PO_NUMBER');
2712: OE_MSG_PUB.ADD;
2713: END IF;
2714:
2715: END IF;
2716: -- End of check for duplicate PO number
2727: IF (p_line_rec.service_end_date <= p_line_rec.service_start_date)
2728: THEN
2729: l_return_status := FND_API.G_RET_STS_ERROR;
2730: fnd_message.set_name('ONT','OE_SERV_END_DATE');
2731: OE_MSG_PUB.Add;
2732: END IF;
2733:
2734: END IF;
2735:
2751: WHEN OTHERS THEN
2752:
2753: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2754:
2755: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2756: THEN
2757: OE_MSG_PUB.Add_Exc_Msg
2758: ( G_PKG_NAME
2759: , 'Entity'
2753: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2754:
2755: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2756: THEN
2757: OE_MSG_PUB.Add_Exc_Msg
2758: ( G_PKG_NAME
2759: , 'Entity'
2760: );
2761: END IF;
2784: and p_x_line_rec.blanket_line_number is NOT NULL
2785: THEN
2786: x_return_status := FND_API.G_RET_STS_ERROR;
2787: fnd_message.set_name('ONT', 'OE_BLKT_DISALLOW_CLOSE_REL');
2788: OE_MSG_PUB.add;
2789: END IF;
2790:
2791: -- Validate line attributes
2792:
3861: WHEN OTHERS THEN
3862:
3863: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3864:
3865: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3866: THEN
3867: OE_MSG_PUB.Add_Exc_Msg
3868: ( G_PKG_NAME
3869: , 'Attributes'
3863: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3864:
3865: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3866: THEN
3867: OE_MSG_PUB.Add_Exc_Msg
3868: ( G_PKG_NAME
3869: , 'Attributes'
3870: );
3871: END IF;
3987: RETURN l_item_type_code;
3988:
3989: WHEN OTHERS THEN
3990:
3991: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3992: THEN
3993: OE_MSG_PUB.Add_Exc_Msg
3994: ( G_PKG_NAME ,
3995: 'Get_Item_Type'
3989: WHEN OTHERS THEN
3990:
3991: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3992: THEN
3993: OE_MSG_PUB.Add_Exc_Msg
3994: ( G_PKG_NAME ,
3995: 'Get_Item_Type'
3996: );
3997: END IF;