[Home] [Help]
29: IF p_line_rec.sold_to_org_id IS NULL THEN
30: x_return_status := FND_API.G_RET_STS_ERROR;
31: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
32: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
33: OE_Order_UTIL.Get_Attribute_Name('SOLD_TO_ORG_ID'));
34: OE_MSG_PUB.ADD;
35: END IF;
36:
37: IF p_line_rec.invoice_to_org_id IS NULL THEN
37: IF p_line_rec.invoice_to_org_id IS NULL THEN
38: x_return_status := FND_API.G_RET_STS_ERROR;
39: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
40: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
41: OE_Order_UTIL.Get_Attribute_Name('INVOICE_TO_ORG_ID'));
42: OE_MSG_PUB.ADD;
43: END IF;
44:
45: IF p_line_rec.tax_exempt_flag IS NULL THEN
45: IF p_line_rec.tax_exempt_flag IS NULL THEN
46: x_return_status := FND_API.G_RET_STS_ERROR;
47: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
48: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
49: OE_Order_UTIL.Get_Attribute_Name('TAX_EXEMPT_FLAG'));
50: OE_MSG_PUB.ADD;
51: END IF;
52:
53:
55: IF p_line_rec.inventory_item_id IS NULL THEN
56: x_return_status := FND_API.G_RET_STS_ERROR;
57: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
58: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
59: OE_Order_UTIL.Get_Attribute_Name('INVENTORY_ITEM_ID'));
60: OE_MSG_PUB.ADD;
61: END IF;
62:
63: IF p_line_rec.order_quantity_uom IS NULL THEN
63: IF p_line_rec.order_quantity_uom IS NULL THEN
64: x_return_status := FND_API.G_RET_STS_ERROR;
65: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
66: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
67: OE_Order_UTIL.Get_Attribute_Name('ORDER_QUANTITY_UOM'));
68: OE_MSG_PUB.ADD;
69: END IF;
70:
71: -- Fix bug 1277092: ordered quantity should not be = 0 on a booked line
73: OR p_line_rec.ordered_quantity = 0 THEN
74: x_return_status := FND_API.G_RET_STS_ERROR;
75: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
76: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
77: OE_Order_UTIL.Get_Attribute_Name('ORDERED_QUANTITY'));
78: OE_MSG_PUB.ADD;
79: END IF;
80:
81: -- For all items that are NOT included items OR config items,
95: IF p_line_rec.price_list_id IS NULL THEN
96: x_return_status := FND_API.G_RET_STS_ERROR;
97: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
98: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
99: OE_Order_UTIL.Get_Attribute_Name('PRICE_LIST_ID'));
100: OE_MSG_PUB.ADD;
101: END IF;
102:
103: IF p_line_rec.unit_list_price IS NULL THEN
103: IF p_line_rec.unit_list_price IS NULL THEN
104: x_return_status := FND_API.G_RET_STS_ERROR;
105: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
106: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
107: OE_Order_UTIL.Get_Attribute_Name('UNIT_LIST_PRICE'));
108: OE_MSG_PUB.ADD;
109: END IF;
110:
111: IF p_line_rec.unit_selling_price IS NULL THEN
111: IF p_line_rec.unit_selling_price IS NULL THEN
112: x_return_status := FND_API.G_RET_STS_ERROR;
113: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
114: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
115: OE_Order_UTIL.Get_Attribute_Name('UNIT_SELLING_PRICE'));
116: OE_MSG_PUB.ADD;
117: END IF;
118:
119: END IF; -- End of check for pricing attributes.
128: IF p_line_rec.ship_to_org_id IS NULL THEN
129: x_return_status := FND_API.G_RET_STS_ERROR;
130: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
131: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
132: OE_Order_UTIL.Get_Attribute_Name('SHIP_TO_ORG_ID'));
133: OE_MSG_PUB.ADD;
134: END IF;
135:
136: IF p_line_rec.payment_term_id IS NULL THEN
136: IF p_line_rec.payment_term_id IS NULL THEN
137: x_return_status := FND_API.G_RET_STS_ERROR;
138: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
139: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
140: OE_Order_UTIL.Get_Attribute_Name('PAYMENT_TERM_ID'));
141: OE_MSG_PUB.ADD;
142: END IF;
143:
144: END IF;
151: IF p_line_rec.ship_from_org_id IS NULL THEN
152: x_return_status := FND_API.G_RET_STS_ERROR;
153: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_RETURN_ATTRIBUTE');
154: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
155: OE_Order_UTIL.Get_Attribute_Name('SHIP_FROM_ORG_ID'));
156: OE_MSG_PUB.ADD;
157: END IF;
158:
159: IF p_line_rec.request_date IS NULL THEN
159: IF p_line_rec.request_date IS NULL THEN
160: x_return_status := FND_API.G_RET_STS_ERROR;
161: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_RETURN_ATTRIBUTE');
162: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
163: OE_Order_UTIL.Get_Attribute_Name('REQUEST_DATE'));
164: OE_MSG_PUB.ADD;
165: END IF;
166:
167: END IF;
172: THEN
173: x_return_status := FND_API.G_RET_STS_ERROR;
174: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_RETURN_ATTRIBUTE');
175: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
176: OE_Order_UTIL.Get_Attribute_Name('TAX_DATE'));
177: OE_MSG_PUB.ADD;
178: END IF;
179:
180: -- Tax code is required under following conditions.
224: IF p_line_rec.service_duration IS NULL THEN
225: x_return_status := FND_API.G_RET_STS_ERROR;
226: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_SERVICE_DURATION');
227: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
228: OE_Order_UTIL.Get_Attribute_Name('SERVICE_DURATION'));
229: OE_MSG_PUB.ADD;
230: END IF;
231: END IF;
232: ------------------------------------------------------------------------
1237: l_return_status := FND_API.G_RET_STS_ERROR;
1238:
1239: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
1240: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1241: OE_Order_UTIL.Get_Attribute_Name('INVENTORY_ITEM_ID'));
1242: OE_MSG_PUB.Add;
1243:
1244: END IF;
1245:
1250: l_return_status := FND_API.G_RET_STS_ERROR;
1251:
1252: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
1253: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1254: OE_Order_UTIL.Get_Attribute_Name('LINE_TYPE_ID'));
1255: OE_MSG_PUB.Add;
1256:
1257: ELSIF p_line_rec.line_type_id IS NOT NULL THEN
1258: Validate_line_type(p_line_rec => p_line_rec);
1280: l_return_status := FND_API.G_RET_STS_ERROR;
1281:
1282: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
1283: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1284: OE_Order_UTIL.Get_Attribute_Name('RETURN_REASON_CODE'));
1285: OE_MSG_PUB.Add;
1286:
1287: END IF;
1288:
1298: oe_debug_pub.add('Entity Validateion: subinventory', 1);
1299: IF p_line_rec.ship_from_org_id is null THEN
1300: l_return_status := FND_API.G_RET_STS_ERROR;
1301: fnd_message.set_name('ONT', 'OE_ATTRIBUTE_REQUIRED');
1302: fnd_message.set_token('ATTRIBUTE',OE_Order_UTIL.Get_Attribute_Name('SHIP_FROM_ORG_ID'));
1303: OE_MSG_PUB.Add;
1304: END IF;
1305: ELSE -- external
1306: l_return_status := FND_API.G_RET_STS_ERROR;
1786: l_return_status := FND_API.G_RET_STS_ERROR;
1787: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'TASK_ID');
1788: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1789: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1790: OE_Order_Util.Get_Attribute_Name('task_id'));
1791: OE_MSG_PUB.Add;
1792: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
1793:
1794: END IF;
1969: ) THEN
1970: l_return_status := FND_API.G_RET_STS_ERROR;
1971: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1972: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1973: OE_Order_Util.Get_Attribute_Name('ship_to_org_id'));
1974: OE_MSG_PUB.Add;
1975: END IF;
1976:
1977: END IF;
2005: WHEN NO_DATA_FOUND THEN
2006: l_return_status := FND_API.G_RET_STS_ERROR;
2007: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
2008: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2009: OE_Order_Util.Get_Attribute_Name('ship_to_contact_id'));
2010: OE_MSG_PUB.Add;
2011: WHEN OTHERS THEN
2012: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2013: OE_MSG_PUB.Add_Exc_Msg
2031: ) THEN
2032: l_return_status := FND_API.G_RET_STS_ERROR;
2033: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2034: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2035: OE_Order_Util.Get_Attribute_Name('deliver_to_org_id'));
2036: OE_MSG_PUB.Add;
2037: END IF;
2038:
2039: END IF;
2066: WHEN NO_DATA_FOUND THEN
2067: l_return_status := FND_API.G_RET_STS_ERROR;
2068: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
2069: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2070: OE_Order_Util.Get_Attribute_Name('deliver_to_contact_id'));
2071: OE_MSG_PUB.Add;
2072: WHEN OTHERS THEN
2073: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2074: OE_MSG_PUB.Add_Exc_Msg
2142: WHEN NO_DATA_FOUND THEN
2143: l_return_status := FND_API.G_RET_STS_ERROR;
2144: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
2145: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2146: OE_Order_Util.Get_Attribute_Name('invoice_to_org_id'));
2147: OE_MSG_PUB.Add;
2148: WHEN OTHERS THEN
2149: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2150: OE_MSG_PUB.Add_Exc_Msg
2184: WHEN NO_DATA_FOUND THEN
2185: l_return_status := FND_API.G_RET_STS_ERROR;
2186: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
2187: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2188: OE_Order_Util.Get_Attribute_Name('invoice_to_contact_id'));
2189: OE_MSG_PUB.Add;
2190: WHEN OTHERS THEN
2191: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2192: OE_MSG_PUB.Add_Exc_Msg
2249: WHEN NO_DATA_FOUND THEN
2250: l_return_status := FND_API.G_RET_STS_ERROR;
2251: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
2252: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2253: OE_Order_Util.Get_Attribute_Name('TAX_CODE'));
2254: OE_MSG_PUB.Add;
2255:
2256: WHEN OTHERS THEN
2257: IF OE_MSG_PUB.Check_Msg_Level (
2278: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_ERROR)
2279: THEN
2280: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
2281: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2282: OE_Order_Util.Get_Attribute_Name('TAX_EXEMPT_REASON_CODE'));
2283: OE_MSG_PUB.Add;
2284: END IF;
2285: END IF;
2286: END IF; -- If Tax handling is exempt
2390: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2391: THEN
2392: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2393: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2394: OE_Order_Util.Get_Attribute_Name('TAX_EXEMPT_NUMBER'));
2395: OE_MSG_PUB.Add;
2396: END IF;
2397:
2398: WHEN OTHERS THEN