[Home] [Help]
39: IF OE_Quote_Util.G_COMPLETE_NEG = 'N' AND
40: NOT OE_GLOBALS.EQUAL(p_line_rec.transaction_phase_code
41: ,p_old_line_rec.transaction_phase_code)
42: THEN
43: FND_MESSAGE.SET_NAME('ONT','OE_PHASE_UPDATE_NOT_ALLOWED');
44: OE_MSG_PUB.ADD;
45: RAISE FND_API.G_EXC_ERROR;
46: END IF;
47:
63: oe_debug_pub.add('arrival set :'||p_line_rec.arrival_set);
64: oe_debug_pub.add('arrival set id :'||p_line_rec.arrival_set_id);
65: oe_debug_pub.add('old arrival set id :'||p_old_line_rec.arrival_set_id);
66: end if;
67: FND_MESSAGE.SET_NAME('ONT','OE_CANT_UPDATE_ORDER_ATTR');
68: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
69: OE_Order_UTIL.Get_Attribute_Name('ARRIVAL_SET_ID'));
70: OE_MSG_PUB.ADD;
71: x_return_status := FND_API.G_RET_STS_ERROR;
64: oe_debug_pub.add('arrival set id :'||p_line_rec.arrival_set_id);
65: oe_debug_pub.add('old arrival set id :'||p_old_line_rec.arrival_set_id);
66: end if;
67: FND_MESSAGE.SET_NAME('ONT','OE_CANT_UPDATE_ORDER_ATTR');
68: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
69: OE_Order_UTIL.Get_Attribute_Name('ARRIVAL_SET_ID'));
70: OE_MSG_PUB.ADD;
71: x_return_status := FND_API.G_RET_STS_ERROR;
72: END IF;
80: oe_debug_pub.add('ship set :'||p_line_rec.ship_set);
81: oe_debug_pub.add('ship set id :'||p_line_rec.ship_set_id);
82: oe_debug_pub.add('old ship set id :'||p_old_line_rec.ship_set_id);
83: end if;
84: FND_MESSAGE.SET_NAME('ONT','OE_CANT_UPDATE_ORDER_ATTR');
85: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
86: OE_Order_UTIL.Get_Attribute_Name('SHIP_SET_ID'));
87: OE_MSG_PUB.ADD;
88: x_return_status := FND_API.G_RET_STS_ERROR;
81: oe_debug_pub.add('ship set id :'||p_line_rec.ship_set_id);
82: oe_debug_pub.add('old ship set id :'||p_old_line_rec.ship_set_id);
83: end if;
84: FND_MESSAGE.SET_NAME('ONT','OE_CANT_UPDATE_ORDER_ATTR');
85: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
86: OE_Order_UTIL.Get_Attribute_Name('SHIP_SET_ID'));
87: OE_MSG_PUB.ADD;
88: x_return_status := FND_API.G_RET_STS_ERROR;
89: END IF;
90: --for bug 3450282. Added NVL condition to consider g_miss_char during comparision
91: IF NOT OE_GLOBALS.EQUAL(NVL(p_line_rec.schedule_ship_date,FND_API.G_MISS_DATE)
92: ,NVL(p_old_line_rec.schedule_ship_date,FND_API.G_MISS_DATE))
93: THEN
94: FND_MESSAGE.SET_NAME('ONT','OE_CANT_UPDATE_ORDER_ATTR');
95: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
96: OE_Order_UTIL.Get_Attribute_Name('SCHEDULE_SHIP_DATE'));
97: OE_MSG_PUB.ADD;
98: x_return_status := FND_API.G_RET_STS_ERROR;
91: IF NOT OE_GLOBALS.EQUAL(NVL(p_line_rec.schedule_ship_date,FND_API.G_MISS_DATE)
92: ,NVL(p_old_line_rec.schedule_ship_date,FND_API.G_MISS_DATE))
93: THEN
94: FND_MESSAGE.SET_NAME('ONT','OE_CANT_UPDATE_ORDER_ATTR');
95: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
96: OE_Order_UTIL.Get_Attribute_Name('SCHEDULE_SHIP_DATE'));
97: OE_MSG_PUB.ADD;
98: x_return_status := FND_API.G_RET_STS_ERROR;
99: END IF;
100: --for bug 3450282. Added NVL condition to consider g_miss_char during comparision
101: IF NOT OE_GLOBALS.EQUAL(NVL(p_line_rec.schedule_arrival_date,FND_API.G_MISS_DATE)
102: ,NVL(p_old_line_rec.schedule_arrival_date,FND_API.G_MISS_DATE))
103: THEN
104: FND_MESSAGE.SET_NAME('ONT','OE_CANT_UPDATE_ORDER_ATTR');
105: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
106: OE_Order_UTIL.Get_Attribute_Name('SCHEDULE_ARRIVAL_DATE'));
107: OE_MSG_PUB.ADD;
108: x_return_status := FND_API.G_RET_STS_ERROR;
101: IF NOT OE_GLOBALS.EQUAL(NVL(p_line_rec.schedule_arrival_date,FND_API.G_MISS_DATE)
102: ,NVL(p_old_line_rec.schedule_arrival_date,FND_API.G_MISS_DATE))
103: THEN
104: FND_MESSAGE.SET_NAME('ONT','OE_CANT_UPDATE_ORDER_ATTR');
105: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
106: OE_Order_UTIL.Get_Attribute_Name('SCHEDULE_ARRIVAL_DATE'));
107: OE_MSG_PUB.ADD;
108: x_return_status := FND_API.G_RET_STS_ERROR;
109: END IF;
111: --for bug 3450282. Added NVL condition to consider g_miss_char during comparision
112: IF NOT OE_GLOBALS.EQUAL(NVL(p_line_rec.override_atp_date_code,FND_API.G_MISS_CHAR)
113: ,NVL(p_old_line_rec.override_atp_date_code,FND_API.G_MISS_CHAR))
114: THEN
115: FND_MESSAGE.SET_NAME('ONT','OE_CANT_UPDATE_ORDER_ATTR');
116: --The following line was modified for bug 3153680
117: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Override ATP');
118: OE_MSG_PUB.ADD;
119: x_return_status := FND_API.G_RET_STS_ERROR;
113: ,NVL(p_old_line_rec.override_atp_date_code,FND_API.G_MISS_CHAR))
114: THEN
115: FND_MESSAGE.SET_NAME('ONT','OE_CANT_UPDATE_ORDER_ATTR');
116: --The following line was modified for bug 3153680
117: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Override ATP');
118: OE_MSG_PUB.ADD;
119: x_return_status := FND_API.G_RET_STS_ERROR;
120: END IF;
121:
127: p_line_rec.reserved_quantity IS NULL)
128: OR (p_line_rec.reserved_quantity=FND_API.G_MISS_NUM AND
129: p_old_line_rec.reserved_quantity IS NULL))
130: THEN
131: FND_MESSAGE.SET_NAME('ONT','OE_CANT_UPDATE_ORDER_ATTR');
132: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
133: OE_Order_UTIL.Get_Attribute_Name('RESERVED_QUANTITY'));
134: OE_MSG_PUB.ADD;
135: x_return_status := FND_API.G_RET_STS_ERROR;
128: OR (p_line_rec.reserved_quantity=FND_API.G_MISS_NUM AND
129: p_old_line_rec.reserved_quantity IS NULL))
130: THEN
131: FND_MESSAGE.SET_NAME('ONT','OE_CANT_UPDATE_ORDER_ATTR');
132: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
133: OE_Order_UTIL.Get_Attribute_Name('RESERVED_QUANTITY'));
134: OE_MSG_PUB.ADD;
135: x_return_status := FND_API.G_RET_STS_ERROR;
136: END IF;
145: p_line_rec.reserved_quantity2 IS NULL)
146: OR (p_line_rec.reserved_quantity2=FND_API.G_MISS_NUM AND
147: p_old_line_rec.reserved_quantity2 IS NULL))
148: THEN
149: FND_MESSAGE.SET_NAME('ONT','OE_CANT_UPDATE_ORDER_ATTR');
150: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
151: OE_Order_UTIL.Get_Attribute_Name('RESERVED_QUANTITY2'));
152: OE_MSG_PUB.ADD;
153: x_return_status := FND_API.G_RET_STS_ERROR;
146: OR (p_line_rec.reserved_quantity2=FND_API.G_MISS_NUM AND
147: p_old_line_rec.reserved_quantity2 IS NULL))
148: THEN
149: FND_MESSAGE.SET_NAME('ONT','OE_CANT_UPDATE_ORDER_ATTR');
150: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
151: OE_Order_UTIL.Get_Attribute_Name('RESERVED_QUANTITY2'));
152: OE_MSG_PUB.ADD;
153: x_return_status := FND_API.G_RET_STS_ERROR;
154: END IF;
159: --for bug 3450282. Added NVL condition to consider g_miss_char during comparision
160: IF NOT OE_GLOBALS.EQUAL(NVL(p_line_rec.firm_demand_flag,FND_API.G_MISS_CHAR)
161: ,NVL(p_old_line_rec.firm_demand_flag,FND_API.G_MISS_CHAR))
162: THEN
163: FND_MESSAGE.SET_NAME('ONT','OE_CANT_UPDATE_ORDER_ATTR');
164: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Firm Demand');
165: OE_MSG_PUB.ADD;
166: x_return_status := FND_API.G_RET_STS_ERROR;
167: END IF;
160: IF NOT OE_GLOBALS.EQUAL(NVL(p_line_rec.firm_demand_flag,FND_API.G_MISS_CHAR)
161: ,NVL(p_old_line_rec.firm_demand_flag,FND_API.G_MISS_CHAR))
162: THEN
163: FND_MESSAGE.SET_NAME('ONT','OE_CANT_UPDATE_ORDER_ATTR');
164: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Firm Demand');
165: OE_MSG_PUB.ADD;
166: x_return_status := FND_API.G_RET_STS_ERROR;
167: END IF;
168: --for bug 3450282. Added NVL condition to consider g_miss_num during comparision
168: --for bug 3450282. Added NVL condition to consider g_miss_num during comparision
169: IF NOT OE_GLOBALS.EQUAL(NVL(p_line_rec.late_demand_penalty_factor,FND_API.G_MISS_NUM)
170: ,NVL(p_old_line_rec.late_demand_penalty_factor,FND_API.G_MISS_NUM))
171: THEN
172: FND_MESSAGE.SET_NAME('ONT','OE_CANT_UPDATE_ORDER_ATTR');
173: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Late Demand Penalty');
174: OE_MSG_PUB.ADD;
175: x_return_status := FND_API.G_RET_STS_ERROR;
176: END IF;
169: IF NOT OE_GLOBALS.EQUAL(NVL(p_line_rec.late_demand_penalty_factor,FND_API.G_MISS_NUM)
170: ,NVL(p_old_line_rec.late_demand_penalty_factor,FND_API.G_MISS_NUM))
171: THEN
172: FND_MESSAGE.SET_NAME('ONT','OE_CANT_UPDATE_ORDER_ATTR');
173: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Late Demand Penalty');
174: OE_MSG_PUB.ADD;
175: x_return_status := FND_API.G_RET_STS_ERROR;
176: END IF;
177:
177:
178: -- schedule action is not a DB field so check for not null only
179: IF p_line_rec.schedule_action_code IS NOT NULL
180: THEN
181: FND_MESSAGE.SET_NAME('ONT','OE_CANT_UPDATE_ORDER_ATTR');
182: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
183: OE_Order_UTIL.Get_Attribute_Name('SCHEDULE_ACTION_CODE'));
184: OE_MSG_PUB.ADD;
185: x_return_status := FND_API.G_RET_STS_ERROR;
178: -- schedule action is not a DB field so check for not null only
179: IF p_line_rec.schedule_action_code IS NOT NULL
180: THEN
181: FND_MESSAGE.SET_NAME('ONT','OE_CANT_UPDATE_ORDER_ATTR');
182: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
183: OE_Order_UTIL.Get_Attribute_Name('SCHEDULE_ACTION_CODE'));
184: OE_MSG_PUB.ADD;
185: x_return_status := FND_API.G_RET_STS_ERROR;
186: END IF;
186: END IF;
187:
188: -- Return orders not supported
189: IF p_line_rec.line_category_code = 'RETURN' THEN
190: FND_MESSAGE.SET_NAME('ONT','OE_QUOTE_RETURN_NOT_SUPP');
191: OE_MSG_PUB.ADD;
192: x_return_status := FND_API.G_RET_STS_ERROR;
193: END IF;
194:
193: END IF;
194:
195: -- Internal sales orders not allowed
196: IF p_line_rec.order_source_id = 10 THEN
197: FND_MESSAGE.SET_NAME('ONT','OE_QUOTE_INT_ORD_NOT_SUPP');
198: OE_MSG_PUB.ADD;
199: x_return_status := FND_API.G_RET_STS_ERROR;
200: END IF;
201:
200: END IF;
201:
202: -- Cancellation operation not supported for quotes
203: IF p_line_rec.cancelled_flag = 'Y' THEN
204: FND_MESSAGE.SET_NAME('ONT','OE_QUOTE_CANCEL_NOT_SUPP');
205: OE_MSG_PUB.ADD;
206: x_return_status := FND_API.G_RET_STS_ERROR;
207: END IF;
208:
273: -- Check for fields required on a booked order line
274:
275: IF p_line_rec.sold_to_org_id IS NULL THEN
276: x_return_status := FND_API.G_RET_STS_ERROR;
277: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
278: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
279: OE_Order_UTIL.Get_Attribute_Name('SOLD_TO_ORG_ID'));
280: OE_MSG_PUB.ADD;
281: END IF;
274:
275: IF p_line_rec.sold_to_org_id IS NULL THEN
276: x_return_status := FND_API.G_RET_STS_ERROR;
277: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
278: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
279: OE_Order_UTIL.Get_Attribute_Name('SOLD_TO_ORG_ID'));
280: OE_MSG_PUB.ADD;
281: END IF;
282:
281: END IF;
282:
283: IF p_line_rec.invoice_to_org_id IS NULL THEN
284: x_return_status := FND_API.G_RET_STS_ERROR;
285: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
286: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
287: OE_Order_UTIL.Get_Attribute_Name('INVOICE_TO_ORG_ID'));
288: OE_MSG_PUB.ADD;
289: END IF;
282:
283: IF p_line_rec.invoice_to_org_id IS NULL THEN
284: x_return_status := FND_API.G_RET_STS_ERROR;
285: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
286: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
287: OE_Order_UTIL.Get_Attribute_Name('INVOICE_TO_ORG_ID'));
288: OE_MSG_PUB.ADD;
289: END IF;
290:
289: END IF;
290:
291: IF p_line_rec.tax_exempt_flag IS NULL THEN
292: x_return_status := FND_API.G_RET_STS_ERROR;
293: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
294: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
295: OE_Order_UTIL.Get_Attribute_Name('TAX_EXEMPT_FLAG'));
296: OE_MSG_PUB.ADD;
297: END IF;
290:
291: IF p_line_rec.tax_exempt_flag IS NULL THEN
292: x_return_status := FND_API.G_RET_STS_ERROR;
293: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
294: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
295: OE_Order_UTIL.Get_Attribute_Name('TAX_EXEMPT_FLAG'));
296: OE_MSG_PUB.ADD;
297: END IF;
298:
299:
300: -- Item, Quantity and UOM Required
301: IF p_line_rec.inventory_item_id IS NULL THEN
302: x_return_status := FND_API.G_RET_STS_ERROR;
303: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
304: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
305: OE_Order_UTIL.Get_Attribute_Name('INVENTORY_ITEM_ID'));
306: OE_MSG_PUB.ADD;
307: END IF;
300: -- Item, Quantity and UOM Required
301: IF p_line_rec.inventory_item_id IS NULL THEN
302: x_return_status := FND_API.G_RET_STS_ERROR;
303: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
304: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
305: OE_Order_UTIL.Get_Attribute_Name('INVENTORY_ITEM_ID'));
306: OE_MSG_PUB.ADD;
307: END IF;
308:
307: END IF;
308:
309: IF p_line_rec.order_quantity_uom IS NULL THEN
310: x_return_status := FND_API.G_RET_STS_ERROR;
311: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
312: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
313: OE_Order_UTIL.Get_Attribute_Name('ORDER_QUANTITY_UOM'));
314: OE_MSG_PUB.ADD;
315: END IF;
308:
309: IF p_line_rec.order_quantity_uom IS NULL THEN
310: x_return_status := FND_API.G_RET_STS_ERROR;
311: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
312: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
313: OE_Order_UTIL.Get_Attribute_Name('ORDER_QUANTITY_UOM'));
314: OE_MSG_PUB.ADD;
315: END IF;
316:
317: -- Fix bug 1277092: ordered quantity should not be = 0 on a booked line
318: IF p_line_rec.ordered_quantity IS NULL
319: OR p_line_rec.ordered_quantity = 0 THEN
320: x_return_status := FND_API.G_RET_STS_ERROR;
321: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
322: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
323: OE_Order_UTIL.Get_Attribute_Name('ORDERED_QUANTITY'));
324: OE_MSG_PUB.ADD;
325: END IF;
318: IF p_line_rec.ordered_quantity IS NULL
319: OR p_line_rec.ordered_quantity = 0 THEN
320: x_return_status := FND_API.G_RET_STS_ERROR;
321: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
322: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
323: OE_Order_UTIL.Get_Attribute_Name('ORDERED_QUANTITY'));
324: OE_MSG_PUB.ADD;
325: END IF;
326:
355: ,p_old_line_rec.unit_selling_price) THEN
356:
357: IF p_line_rec.unit_selling_price IS NULL THEN
358: x_return_status := FND_API.G_RET_STS_ERROR;
359: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
360: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
361: OE_Order_UTIL.Get_Attribute_Name('UNIT_SELLING_PRICE'));
362: OE_MSG_PUB.ADD;
363: END IF;
356:
357: IF p_line_rec.unit_selling_price IS NULL THEN
358: x_return_status := FND_API.G_RET_STS_ERROR;
359: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
360: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
361: OE_Order_UTIL.Get_Attribute_Name('UNIT_SELLING_PRICE'));
362: OE_MSG_PUB.ADD;
363: END IF;
364:
372: ,p_old_line_rec.booked_flag) THEN
373:
374: IF p_line_rec.price_list_id IS NULL THEN
375: x_return_status := FND_API.G_RET_STS_ERROR;
376: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
377: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
378: OE_Order_UTIL.Get_Attribute_Name('PRICE_LIST_ID'));
379: OE_MSG_PUB.ADD;
380: END IF;
373:
374: IF p_line_rec.price_list_id IS NULL THEN
375: x_return_status := FND_API.G_RET_STS_ERROR;
376: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
377: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
378: OE_Order_UTIL.Get_Attribute_Name('PRICE_LIST_ID'));
379: OE_MSG_PUB.ADD;
380: END IF;
381:
381:
382:
383: IF p_line_rec.unit_list_price IS NULL THEN
384: x_return_status := FND_API.G_RET_STS_ERROR;
385: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
386: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
387: OE_Order_UTIL.Get_Attribute_Name('UNIT_LIST_PRICE'));
388: OE_MSG_PUB.ADD;
389: END IF;
382:
383: IF p_line_rec.unit_list_price IS NULL THEN
384: x_return_status := FND_API.G_RET_STS_ERROR;
385: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
386: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
387: OE_Order_UTIL.Get_Attribute_Name('UNIT_LIST_PRICE'));
388: OE_MSG_PUB.ADD;
389: END IF;
390:
389: END IF;
390:
391: IF p_line_rec.unit_selling_price IS NULL THEN
392: x_return_status := FND_API.G_RET_STS_ERROR;
393: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
394: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
395: OE_Order_UTIL.Get_Attribute_Name('UNIT_SELLING_PRICE'));
396: OE_MSG_PUB.ADD;
397: END IF;
390:
391: IF p_line_rec.unit_selling_price IS NULL THEN
392: x_return_status := FND_API.G_RET_STS_ERROR;
393: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
394: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
395: OE_Order_UTIL.Get_Attribute_Name('UNIT_SELLING_PRICE'));
396: OE_MSG_PUB.ADD;
397: END IF;
398:
408: IF p_line_rec.line_category_code <> OE_GLOBALS.G_RETURN_CATEGORY_CODE THEN
409:
410: IF p_line_rec.ship_to_org_id IS NULL THEN
411: x_return_status := FND_API.G_RET_STS_ERROR;
412: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
413: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
414: OE_Order_UTIL.Get_Attribute_Name('SHIP_TO_ORG_ID'));
415: OE_MSG_PUB.ADD;
416: END IF;
409:
410: IF p_line_rec.ship_to_org_id IS NULL THEN
411: x_return_status := FND_API.G_RET_STS_ERROR;
412: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
413: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
414: OE_Order_UTIL.Get_Attribute_Name('SHIP_TO_ORG_ID'));
415: OE_MSG_PUB.ADD;
416: END IF;
417:
416: END IF;
417:
418: IF p_line_rec.payment_term_id IS NULL THEN
419: x_return_status := FND_API.G_RET_STS_ERROR;
420: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
421: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
422: OE_Order_UTIL.Get_Attribute_Name('PAYMENT_TERM_ID'));
423: OE_MSG_PUB.ADD;
424: END IF;
417:
418: IF p_line_rec.payment_term_id IS NULL THEN
419: x_return_status := FND_API.G_RET_STS_ERROR;
420: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
421: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
422: OE_Order_UTIL.Get_Attribute_Name('PAYMENT_TERM_ID'));
423: OE_MSG_PUB.ADD;
424: END IF;
425:
439: END IF;
440: IF l_rule_type = 'ACC_DUR' THEN
441: IF p_line_rec.accounting_rule_duration IS NULL THEN
442: x_return_status := FND_API.G_RET_STS_ERROR;
443: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
444: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
445: OE_Order_UTIL.Get_Attribute_Name('ACCOUNTING_RULE_DURATION'));
446: OE_MSG_PUB.ADD;
447: END IF; -- end of accounting_rule_duration null
440: IF l_rule_type = 'ACC_DUR' THEN
441: IF p_line_rec.accounting_rule_duration IS NULL THEN
442: x_return_status := FND_API.G_RET_STS_ERROR;
443: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
444: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
445: OE_Order_UTIL.Get_Attribute_Name('ACCOUNTING_RULE_DURATION'));
446: OE_MSG_PUB.ADD;
447: END IF; -- end of accounting_rule_duration null
448: END IF; -- end of variable accounting rule type
455:
456: IF p_line_rec.service_start_date IS NULL THEN
457: oe_debug_pub.add(' inside new rule validation conditions service start date');
458: x_return_status := FND_API.G_RET_STS_ERROR;
459: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
460: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Accounting Rule Start Date' );
461: OE_MSG_PUB.ADD;
462: END IF;
463: IF p_line_rec.service_end_date IS NULL THEN
456: IF p_line_rec.service_start_date IS NULL THEN
457: oe_debug_pub.add(' inside new rule validation conditions service start date');
458: x_return_status := FND_API.G_RET_STS_ERROR;
459: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
460: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Accounting Rule Start Date' );
461: OE_MSG_PUB.ADD;
462: END IF;
463: IF p_line_rec.service_end_date IS NULL THEN
464: x_return_status := FND_API.G_RET_STS_ERROR;
461: OE_MSG_PUB.ADD;
462: END IF;
463: IF p_line_rec.service_end_date IS NULL THEN
464: x_return_status := FND_API.G_RET_STS_ERROR;
465: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
466: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Accounting Rule End Date' );
467: OE_MSG_PUB.ADD;
468: END IF;
469:
462: END IF;
463: IF p_line_rec.service_end_date IS NULL THEN
464: x_return_status := FND_API.G_RET_STS_ERROR;
465: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
466: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Accounting Rule End Date' );
467: OE_MSG_PUB.ADD;
468: END IF;
469:
470: END IF;
483: IF p_line_rec.line_category_code = OE_GLOBALS.G_RETURN_CATEGORY_CODE THEN
484:
485: IF p_line_rec.ship_from_org_id IS NULL THEN
486: x_return_status := FND_API.G_RET_STS_ERROR;
487: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_RETURN_ATTRIBUTE');
488: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
489: OE_Order_UTIL.Get_Attribute_Name('SHIP_FROM_ORG_ID'));
490: OE_MSG_PUB.ADD;
491: END IF;
484:
485: IF p_line_rec.ship_from_org_id IS NULL THEN
486: x_return_status := FND_API.G_RET_STS_ERROR;
487: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_RETURN_ATTRIBUTE');
488: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
489: OE_Order_UTIL.Get_Attribute_Name('SHIP_FROM_ORG_ID'));
490: OE_MSG_PUB.ADD;
491: END IF;
492:
491: END IF;
492:
493: IF p_line_rec.request_date IS NULL THEN
494: x_return_status := FND_API.G_RET_STS_ERROR;
495: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_RETURN_ATTRIBUTE');
496: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
497: OE_Order_UTIL.Get_Attribute_Name('REQUEST_DATE'));
498: OE_MSG_PUB.ADD;
499: END IF;
492:
493: IF p_line_rec.request_date IS NULL THEN
494: x_return_status := FND_API.G_RET_STS_ERROR;
495: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_RETURN_ATTRIBUTE');
496: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
497: OE_Order_UTIL.Get_Attribute_Name('REQUEST_DATE'));
498: OE_MSG_PUB.ADD;
499: END IF;
500:
504:
505: IF p_line_rec.tax_date IS NULL
506: THEN
507: x_return_status := FND_API.G_RET_STS_ERROR;
508: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_RETURN_ATTRIBUTE');
509: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
510: OE_Order_UTIL.Get_Attribute_Name('TAX_DATE'));
511: OE_MSG_PUB.ADD;
512: END IF;
505: IF p_line_rec.tax_date IS NULL
506: THEN
507: x_return_status := FND_API.G_RET_STS_ERROR;
508: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_RETURN_ATTRIBUTE');
509: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
510: OE_Order_UTIL.Get_Attribute_Name('TAX_DATE'));
511: OE_MSG_PUB.ADD;
512: END IF;
513:
591:
592: IF nvl(l_tax_calculation_event_code, 'ENTERING') IN ('ENTERING', 'BOOKING') THEN
593:
594: x_return_status := FND_API.G_RET_STS_ERROR;
595: FND_MESSAGE.SET_NAME('ONT','OE_VAL_TAX_CODE_REQD');
596: OE_MSG_PUB.ADD;
597: END IF;
598: END IF;
599:
603: -- Service Duration is required on SERVICE lines
604: IF l_item_type_code = 'SERVICE' THEN
605: IF p_line_rec.service_duration IS NULL THEN
606: x_return_status := FND_API.G_RET_STS_ERROR;
607: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_SERVICE_DURATION');
608: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
609: OE_Order_UTIL.Get_Attribute_Name('SERVICE_DURATION'));
610: OE_MSG_PUB.ADD;
611: END IF;
604: IF l_item_type_code = 'SERVICE' THEN
605: IF p_line_rec.service_duration IS NULL THEN
606: x_return_status := FND_API.G_RET_STS_ERROR;
607: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_SERVICE_DURATION');
608: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
609: OE_Order_UTIL.Get_Attribute_Name('SERVICE_DURATION'));
610: OE_MSG_PUB.ADD;
611: END IF;
612: END IF;
617: IF p_line_rec.service_coterminate_flag = 'Y' OR
618: p_line_rec.service_reference_type_code = 'CUSTOMER_PRODUCT' THEN
619: IF p_line_rec.service_start_date IS NULL THEN
620: x_return_status := FND_API.G_RET_STS_ERROR;
621: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
622: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', OE_Order_UTIL.Get_Attribute_Name('SERVICE_START_DATE'));
623: OE_MSG_PUB.ADD;
624: END IF;
625: IF p_line_rec.service_end_date IS NULL THEN
618: p_line_rec.service_reference_type_code = 'CUSTOMER_PRODUCT' THEN
619: IF p_line_rec.service_start_date IS NULL THEN
620: x_return_status := FND_API.G_RET_STS_ERROR;
621: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
622: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', OE_Order_UTIL.Get_Attribute_Name('SERVICE_START_DATE'));
623: OE_MSG_PUB.ADD;
624: END IF;
625: IF p_line_rec.service_end_date IS NULL THEN
626: x_return_status := FND_API.G_RET_STS_ERROR;
623: OE_MSG_PUB.ADD;
624: END IF;
625: IF p_line_rec.service_end_date IS NULL THEN
626: x_return_status := FND_API.G_RET_STS_ERROR;
627: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
628: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', OE_Order_UTIL.Get_Attribute_Name('SERVICE_END_DATE'));
629: OE_MSG_PUB.ADD;
630: END IF;
631: END IF;
624: END IF;
625: IF p_line_rec.service_end_date IS NULL THEN
626: x_return_status := FND_API.G_RET_STS_ERROR;
627: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
628: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', OE_Order_UTIL.Get_Attribute_Name('SERVICE_END_DATE'));
629: OE_MSG_PUB.ADD;
630: END IF;
631: END IF;
632:
631: END IF;
632:
633: IF p_line_rec.service_duration IS NULL THEN
634: x_return_status := FND_API.G_RET_STS_ERROR;
635: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
636: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
637: OE_Order_UTIL.Get_Attribute_Name('SERVICE_DURATION'));
638: OE_MSG_PUB.ADD;
639: END IF;
632:
633: IF p_line_rec.service_duration IS NULL THEN
634: x_return_status := FND_API.G_RET_STS_ERROR;
635: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
636: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
637: OE_Order_UTIL.Get_Attribute_Name('SERVICE_DURATION'));
638: OE_MSG_PUB.ADD;
639: END IF;
640: IF p_line_rec.service_period IS NULL THEN
638: OE_MSG_PUB.ADD;
639: END IF;
640: IF p_line_rec.service_period IS NULL THEN
641: x_return_status := FND_API.G_RET_STS_ERROR;
642: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
643: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
644: OE_Order_UTIL.Get_Attribute_Name('SERVICE_PERIOD'));
645: OE_MSG_PUB.ADD;
646: END IF;
639: END IF;
640: IF p_line_rec.service_period IS NULL THEN
641: x_return_status := FND_API.G_RET_STS_ERROR;
642: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
643: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
644: OE_Order_UTIL.Get_Attribute_Name('SERVICE_PERIOD'));
645: OE_MSG_PUB.ADD;
646: END IF;
647: END IF;
656: p_line_rec.cancelled_flag <> 'Y'
657: THEN
658: IF (OE_LINE_UTIL.Is_Over_Return(p_line_rec)) THEN
659: x_return_status := FND_API.G_RET_STS_ERROR;
660: FND_MESSAGE.Set_Name('ONT', 'OE_RETURN_INVALID_QUANTITY');
661: OE_MSG_PUB.ADD;
662: END IF;
663:
664: END IF;
671:
672: IF (OE_CODE_CONTROL.Code_Release_Level >= '110509' and p_line_rec.order_firmed_date > l_hdr_booked_date
673: and p_line_rec.creation_date <= l_hdr_booked_date) THEN
674: x_return_status := FND_API.G_RET_STS_ERROR;
675: FND_MESSAGE.Set_Name('ONT','ONT_ORDER_FIRMED_DATE_INVALID');
676: OE_MSG_PUB.Add;
677: END IF;
678: --end
679:
697: l_revision_controlled := 'N';
698: End;
699: IF l_revision_controlled = 'Y' THEN
700: x_return_status := FND_API.G_RET_STS_ERROR;
701: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_RETURN_ATTRIBUTE');
702: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', OE_Order_UTIL.Get_Attribute_Name('ITEM_REVISION'));
703: OE_MSG_PUB.ADD;
704: END IF;
705: END IF;
698: End;
699: IF l_revision_controlled = 'Y' THEN
700: x_return_status := FND_API.G_RET_STS_ERROR;
701: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_RETURN_ATTRIBUTE');
702: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', OE_Order_UTIL.Get_Attribute_Name('ITEM_REVISION'));
703: OE_MSG_PUB.ADD;
704: END IF;
705: END IF;
706: END IF;
794: AND wnd.status_code in ('CO', 'IT', 'CL', 'SA')))
795: AND rownum = 1;
796:
797: IF l_ship_set > 0 AND l_shipset_enforce = 'Y' THEN
798: FND_MESSAGE.Set_Name ('ONT','ONT_SET_PICK_RELEASED');
799: BEGIN
800: SELECT SET_NAME
801: INTO l_set_name
802: FROM OE_SETS
804: EXCEPTION
805: WHEN NO_DATA_FOUND THEN
806: l_set_name := null;
807: END;
808: FND_MESSAGE.Set_Token('SHIP_SET',l_set_name);
809: OE_MSG_PUB.Add;
810: x_return_status := FND_API.G_RET_STS_ERROR;
811: END IF;
812:
831: AND Released_Status In ('S','Y','C')
832: AND ROWNUM = 1;
833:
834: IF l_smc_model > 0 AND l_shipset_enforce = 'Y' THEN
835: FND_MESSAGE.Set_Name ('ONT','ONT_SMC_PICK_RELEASED');
836: BEGIN
837: SELECT ORDERED_ITEM,inventory_item_id
838: INTO l_model_name,l_model_item_id
839: FROM OE_ORDER_LINES
841: EXCEPTION
842: WHEN NO_DATA_FOUND THEN
843: l_model_name := null;
844: END;
845: FND_MESSAGE.Set_Token('MODEL',nvl(l_model_name,l_model_item_id));
846: OE_MSG_PUB.Add;
847: x_return_status := FND_API.G_RET_STS_ERROR;
848: END IF;
849: END IF;
944: p_ato_line_id = p_line_id)) THEN
945: IF l_debug_level > 0 then
946: OE_DEBUG_PUB.Add('item is config related with decimal qty',2);
947: END IF;
948: FND_MESSAGE.SET_NAME('ONT', 'OE_CONFIG_NO_DECIMALS');
949: FND_MESSAGE.SET_TOKEN('ITEM', nvl(OE_Id_To_Value.Inventory_Item(p_item_id),p_item_id));
950: FND_Message.Set_Token('LINE_NUM', p_line_num);
951: OE_MSG_PUB.Add;
952: x_return_status := FND_API.G_RET_STS_ERROR;
945: IF l_debug_level > 0 then
946: OE_DEBUG_PUB.Add('item is config related with decimal qty',2);
947: END IF;
948: FND_MESSAGE.SET_NAME('ONT', 'OE_CONFIG_NO_DECIMALS');
949: FND_MESSAGE.SET_TOKEN('ITEM', nvl(OE_Id_To_Value.Inventory_Item(p_item_id),p_item_id));
950: FND_Message.Set_Token('LINE_NUM', p_line_num);
951: OE_MSG_PUB.Add;
952: x_return_status := FND_API.G_RET_STS_ERROR;
953: END IF;
946: OE_DEBUG_PUB.Add('item is config related with decimal qty',2);
947: END IF;
948: FND_MESSAGE.SET_NAME('ONT', 'OE_CONFIG_NO_DECIMALS');
949: FND_MESSAGE.SET_TOKEN('ITEM', nvl(OE_Id_To_Value.Inventory_Item(p_item_id),p_item_id));
950: FND_Message.Set_Token('LINE_NUM', p_line_num);
951: OE_MSG_PUB.Add;
952: x_return_status := FND_API.G_RET_STS_ERROR;
953: END IF;
954:
957: IF p_item_type_code IN ('MODEL', 'KIT','CLASS','INCLUDED','OPTION', 'CONFIG') THEN
958: IF l_debug_level > 0 then
959: OE_DEBUG_PUB.Add('item is config related with decimal qty',2);
960: END IF;
961: FND_MESSAGE.SET_NAME('ONT', 'OE_CONFIG_NO_DECIMALS');
962: FND_MESSAGE.SET_TOKEN('ITEM', nvl(OE_Id_To_Value.Inventory_Item(p_item_id),p_item_id));
963: FND_Message.Set_Token('LINE_NUM', p_line_num);
964: OE_MSG_PUB.Add;
965: x_return_status := FND_API.G_RET_STS_ERROR;
958: IF l_debug_level > 0 then
959: OE_DEBUG_PUB.Add('item is config related with decimal qty',2);
960: END IF;
961: FND_MESSAGE.SET_NAME('ONT', 'OE_CONFIG_NO_DECIMALS');
962: FND_MESSAGE.SET_TOKEN('ITEM', nvl(OE_Id_To_Value.Inventory_Item(p_item_id),p_item_id));
963: FND_Message.Set_Token('LINE_NUM', p_line_num);
964: OE_MSG_PUB.Add;
965: x_return_status := FND_API.G_RET_STS_ERROR;
966: END IF;
959: OE_DEBUG_PUB.Add('item is config related with decimal qty',2);
960: END IF;
961: FND_MESSAGE.SET_NAME('ONT', 'OE_CONFIG_NO_DECIMALS');
962: FND_MESSAGE.SET_TOKEN('ITEM', nvl(OE_Id_To_Value.Inventory_Item(p_item_id),p_item_id));
963: FND_Message.Set_Token('LINE_NUM', p_line_num);
964: OE_MSG_PUB.Add;
965: x_return_status := FND_API.G_RET_STS_ERROR;
966: END IF;
967:
1003: OE_DEBUG_PUB.Add('do not error out,cascading',1);
1004: END IF;
1005: x_return_status := FND_API.G_RET_STS_SUCCESS;
1006: ELSE
1007: fnd_message.set_name('ONT', 'OE_DECIMAL_MAX_PRECISION');
1008: -- move INV error message to OE message stack
1009: oe_msg_pub.add;
1010: x_return_status := FND_API.G_RET_STS_ERROR;
1011: END IF;
1096: END IF;
1097: END IF;
1098: END IF;
1099:
1100: FND_MESSAGE.Set_Name('ONT', 'OE_CONFIG_DECIMAL_RATIO');
1101:
1102: FND_MESSAGE.Set_TOKEN('ITEM', nvl(p_line_rec.ordered_item,
1103: p_line_rec.inventory_item_id));
1104: FND_MESSAGE.Set_TOKEN('TYPECODE', p_line_rec.item_type_code);
1098: END IF;
1099:
1100: FND_MESSAGE.Set_Name('ONT', 'OE_CONFIG_DECIMAL_RATIO');
1101:
1102: FND_MESSAGE.Set_TOKEN('ITEM', nvl(p_line_rec.ordered_item,
1103: p_line_rec.inventory_item_id));
1104: FND_MESSAGE.Set_TOKEN('TYPECODE', p_line_rec.item_type_code);
1105: FND_MESSAGE.Set_TOKEN('VALUE',
1106: to_char(l_ordered_quantity/p_line_rec.ordered_quantity));
1100: FND_MESSAGE.Set_Name('ONT', 'OE_CONFIG_DECIMAL_RATIO');
1101:
1102: FND_MESSAGE.Set_TOKEN('ITEM', nvl(p_line_rec.ordered_item,
1103: p_line_rec.inventory_item_id));
1104: FND_MESSAGE.Set_TOKEN('TYPECODE', p_line_rec.item_type_code);
1105: FND_MESSAGE.Set_TOKEN('VALUE',
1106: to_char(l_ordered_quantity/p_line_rec.ordered_quantity));
1107:
1108: FND_MESSAGE.Set_TOKEN('MODEL', nvl(l_ordered_item,l_inv_item_id));
1101:
1102: FND_MESSAGE.Set_TOKEN('ITEM', nvl(p_line_rec.ordered_item,
1103: p_line_rec.inventory_item_id));
1104: FND_MESSAGE.Set_TOKEN('TYPECODE', p_line_rec.item_type_code);
1105: FND_MESSAGE.Set_TOKEN('VALUE',
1106: to_char(l_ordered_quantity/p_line_rec.ordered_quantity));
1107:
1108: FND_MESSAGE.Set_TOKEN('MODEL', nvl(l_ordered_item,l_inv_item_id));
1109: FND_MESSAGE.Set_TOKEN('PTYPECODE', l_item_type_code);
1104: FND_MESSAGE.Set_TOKEN('TYPECODE', p_line_rec.item_type_code);
1105: FND_MESSAGE.Set_TOKEN('VALUE',
1106: to_char(l_ordered_quantity/p_line_rec.ordered_quantity));
1107:
1108: FND_MESSAGE.Set_TOKEN('MODEL', nvl(l_ordered_item,l_inv_item_id));
1109: FND_MESSAGE.Set_TOKEN('PTYPECODE', l_item_type_code);
1110:
1111: OE_MSG_PUB.Add;
1112:
1105: FND_MESSAGE.Set_TOKEN('VALUE',
1106: to_char(l_ordered_quantity/p_line_rec.ordered_quantity));
1107:
1108: FND_MESSAGE.Set_TOKEN('MODEL', nvl(l_ordered_item,l_inv_item_id));
1109: FND_MESSAGE.Set_TOKEN('PTYPECODE', l_item_type_code);
1110:
1111: OE_MSG_PUB.Add;
1112:
1113: x_return_status := FND_API.G_RET_STS_ERROR;
1192: IF l_debug_level > 0 then
1193: oe_debug_pub.add(' Validate Line Type Line Cat Code from the OE_TRXT_ALL table: '||lline_category_code);
1194: oe_debug_pub.add(' Validate Line Type Line Cat Code from the UI: '||p_line_rec.line_category_code);
1195: END IF;
1196: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1197: fnd_message.set_token('ATTRIBUTE', OE_Order_Util.Get_Attribute_Name('Line_type_id'));
1198: OE_MSG_PUB.Add;
1199: RAISE FND_API.G_EXC_ERROR;
1200: end if;
1193: oe_debug_pub.add(' Validate Line Type Line Cat Code from the OE_TRXT_ALL table: '||lline_category_code);
1194: oe_debug_pub.add(' Validate Line Type Line Cat Code from the UI: '||p_line_rec.line_category_code);
1195: END IF;
1196: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1197: fnd_message.set_token('ATTRIBUTE', OE_Order_Util.Get_Attribute_Name('Line_type_id'));
1198: OE_MSG_PUB.Add;
1199: RAISE FND_API.G_EXC_ERROR;
1200: end if;
1201: END IF;
1209: IF NOT OE_Globals.Equal(l_new_wf_item_type, l_old_wf_item_type)
1210: THEN
1211: oe_debug_pub.add('workflow item type changed', 1);
1212:
1213: -- FND_Message.Set_Name('ONT', 'OE_WF_ITEM_TYPE_CHANGED');
1214: FND_Message.Set_Name('ONT', 'OE_ITEM_TYPE_CONST');
1215: oe_msg_pub.add;
1216: RAISE FND_API.G_EXC_ERROR;
1217: END IF;
1210: THEN
1211: oe_debug_pub.add('workflow item type changed', 1);
1212:
1213: -- FND_Message.Set_Name('ONT', 'OE_WF_ITEM_TYPE_CHANGED');
1214: FND_Message.Set_Name('ONT', 'OE_ITEM_TYPE_CONST');
1215: oe_msg_pub.add;
1216: RAISE FND_API.G_EXC_ERROR;
1217: END IF;
1218:
1267: IF lexists IS NULL THEN
1268: IF l_debug_level > 0 then
1269: oe_debug_pub.add('No explicit assignment exists',2);
1270: END IF;
1271: FND_MESSAGE.SET_NAME('ONT','OE_EXP_ASSIGN_REQ');
1272: OE_MSG_PUB.ADD;
1273: RAISE FND_API.G_EXC_ERROR;
1274: END IF;
1275:
1280: OE_DEBUG_PUB.Add('Exiting OE_VALIDATE_LINE.Validate_Line_Type',1);
1281: END IF;
1282: EXCEPTION
1283: WHEN NO_DATA_FOUND THEN
1284: FND_MESSAGE.SET_NAME('ONT','OE_FLOW_CNT_CHANGE');
1285: OE_MSG_PUB.ADD;
1286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1287: WHEN FND_API.G_EXC_ERROR THEN
1288: RAISE FND_API.G_EXC_ERROR;
1350:
1351: RETURN TRUE;
1352: EXCEPTION
1353: WHEN NO_DATA_FOUND THEN
1354: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ITEM_WHSE');
1355: OE_MSG_PUB.add;
1356: RETURN FALSE;
1357: WHEN OTHERS THEN
1358: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ITEM_WHSE');
1354: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ITEM_WHSE');
1355: OE_MSG_PUB.add;
1356: RETURN FALSE;
1357: WHEN OTHERS THEN
1358: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ITEM_WHSE');
1359: OE_MSG_PUB.add;
1360: RETURN FALSE;
1361: END Validate_Receiving_Org;
1362:
1382:
1383: oe_debug_pub.add('Old Shipable flag, New shipable flag : '||l_shipable_flag_old||l_shipable_flag_new);
1384: IF (l_shipable_flag_old <> l_shipable_flag_new AND l_shipable_flag_new = 'N') THEN
1385: l_result := FALSE;
1386: FND_MESSAGE.SET_NAME('ONT','OE_INVLD_CHG_SHP_FROM_ORG');
1387: oe_msg_pub.add;
1388: ELSE
1389: l_result := TRUE;
1390: END IF;
1527: IF l_debug_level > 0 then
1528: oe_debug_pub.add('RR: No data found',1);
1529: END IF;
1530:
1531: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ITEM_WHSE');
1532: OE_MSG_PUB.add;
1533: RETURN FALSE;
1534:
1535: WHEN OTHERS THEN
1535: WHEN OTHERS THEN
1536: IF l_debug_level > 0 then
1537: oe_debug_pub.add('RR: OTHERS',1);
1538: END IF;
1539: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ITEM_WHSE');
1540: OE_MSG_PUB.add;
1541: RETURN FALSE;
1542:
1543: END Validate_Item_Warehouse;
1929: RETURN TRUE;
1930: ELSIF (l_profile = 'R') THEN
1931: RETURN FALSE;
1932: ELSE -- warning
1933: FND_MESSAGE.SET_NAME('ONT','OE_RETURN_ITEM_MISMATCH_WARNIN');
1934: OE_MSG_PUB.ADD;
1935: END IF;
1936:
1937: END IF;
2007: RETURN TRUE;
2008: ELSIF (l_profile = 'R') THEN
2009: RETURN FALSE;
2010: ELSE -- warning
2011: FND_MESSAGE.SET_NAME('ONT','OE_UNFULFILLED_LINE_WARNING');
2012: OE_MSG_PUB.ADD;
2013: END IF;
2014:
2015: END IF;
2065:
2066: IF l_returnable_flag = 'Y' THEN
2067: x_return_status := FND_API.G_RET_STS_SUCCESS;
2068: ELSE
2069: fnd_message.set_name('ONT', 'OE_ITEM_NOT_RETURNABLE');
2070: OE_MSG_PUB.add;
2071: x_return_status := FND_API.G_RET_STS_ERROR;
2072: END IF;
2073:
2076: IF l_debug_level > 0 then
2077: oe_debug_pub.add('Validate_Return_Item: No data found',1);
2078: END IF;
2079: x_return_status := FND_API.G_RET_STS_ERROR;
2080: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ITEM_WHSE');
2081: OE_MSG_PUB.add;
2082: WHEN OTHERS THEN
2083: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2084: IF l_debug_level > 0 then
2108: WHERE line_id = p_reference_line_id
2109: and line_category_code = 'ORDER';
2110:
2111: IF NOT OE_GLOBALS.EQUAL(l_tax_code,p_tax_code) THEN
2112: fnd_message.set_name('ONT','OE_RETURN_ATTR_CANNOT_CHANGE');
2113: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Tax Code');
2114: OE_MSG_PUB.Add;
2115: RETURN FALSE;
2116: END IF;
2109: and line_category_code = 'ORDER';
2110:
2111: IF NOT OE_GLOBALS.EQUAL(l_tax_code,p_tax_code) THEN
2112: fnd_message.set_name('ONT','OE_RETURN_ATTR_CANNOT_CHANGE');
2113: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Tax Code');
2114: OE_MSG_PUB.Add;
2115: RETURN FALSE;
2116: END IF;
2117:
2124: WHEN NO_DATA_FOUND THEN
2125: if l_debug_level > 0 then
2126: oe_debug_pub.add('Validate_Return_Reference: No data found',1);
2127: end if;
2128: fnd_message.set_name('ONT', 'OE_RETURN_INVALID_SO_LINE');
2129: OE_MSG_PUB.Add;
2130: RETURN FALSE;
2131: WHEN OTHERS THEN
2132: if l_debug_level > 0 then
2131: WHEN OTHERS THEN
2132: if l_debug_level > 0 then
2133: oe_debug_pub.add('Validate_Return_Reference: When Others',1);
2134: end if;
2135: fnd_message.set_name('ONT', 'OE_RETURN_INVALID_SO_LINE');
2136: OE_MSG_PUB.Add;
2137: RETURN FALSE;
2138: END Validate_Return_Reference_Tax;
2139:
2162: WHERE line_id = p_reference_line_id
2163: and line_category_code = 'ORDER';
2164:
2165: IF l_source_document_type_id = 10 THEN
2166: fnd_message.set_name('ONT','OE_NO_RMA_FOR_INTERNAL_ORDER');
2167: OE_MSG_PUB.Add;
2168: RETURN FALSE;
2169: END IF;
2170:
2168: RETURN FALSE;
2169: END IF;
2170:
2171: IF NOT OE_GLOBALS.EQUAL(l_uom_code,p_uom_code) THEN
2172: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2173: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Unit Of Measure');
2174: OE_MSG_PUB.Add;
2175: RETURN FALSE;
2176: END IF;
2169: END IF;
2170:
2171: IF NOT OE_GLOBALS.EQUAL(l_uom_code,p_uom_code) THEN
2172: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2173: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Unit Of Measure');
2174: OE_MSG_PUB.Add;
2175: RETURN FALSE;
2176: END IF;
2177:
2177:
2178: IF l_booked_flag = 'Y' THEN
2179: RETURN TRUE;
2180: ELSE
2181: fnd_message.set_name('ONT', 'OE_RETURN_UNBOOKED_ORDER');
2182: OE_MSG_PUB.Add;
2183: END IF;
2184: IF l_debug_level > 0 then
2185: oe_debug_pub.add('Exit Validate_Return_Reference',1);
2190: WHEN NO_DATA_FOUND THEN
2191: IF l_debug_level > 0 then
2192: oe_debug_pub.add('Validate_Return_Reference: No data found',1);
2193: END IF;
2194: fnd_message.set_name('ONT', 'OE_RETURN_INVALID_SO_LINE');
2195: OE_MSG_PUB.Add;
2196: RETURN FALSE;
2197: WHEN OTHERS THEN
2198: IF l_debug_level > 0 then
2197: WHEN OTHERS THEN
2198: IF l_debug_level > 0 then
2199: oe_debug_pub.add('Validate_Return_Reference: When Others',1);
2200: END IF;
2201: fnd_message.set_name('ONT', 'OE_RETURN_INVALID_SO_LINE');
2202: OE_MSG_PUB.Add;
2203: RETURN FALSE;
2204: END Validate_Return_Reference;
2205:
2233: END IF;
2234:
2235: IF l_ord_qty > 0 THEN
2236: IF p_ord_qty <= 0 THEN
2237: fnd_message.set_name('ONT','OE_LINE_HAS_RMA_CANNOT_CANCEL');
2238: OE_MSG_PUB.Add;
2239: RETURN FALSE;
2240: ELSE
2241: IF p_ord_qty < l_ord_qty THEN
2238: OE_MSG_PUB.Add;
2239: RETURN FALSE;
2240: ELSE
2241: IF p_ord_qty < l_ord_qty THEN
2242: fnd_message.set_name('ONT','OE_LINE_HAS_RMA_HIGHER_QTY');
2243: OE_MSG_PUB.Add;
2244: RETURN FALSE;
2245: END IF;
2246: END IF;
2549: oe_debug_pub.add('Error: Commitment NOT related to Sold To/Invoice To at the line level');
2550: end if;
2551:
2552: x_return_status := FND_API.G_RET_STS_ERROR;
2553: FND_MESSAGE.SET_NAME('ONT','ONT_COM_CUSTOMER_MISMATCH');
2554: FND_MESSAGE.SET_TOKEN('CUSTOMER','');
2555: OE_MSG_PUB.ADD;
2556: end if;
2557:
2550: end if;
2551:
2552: x_return_status := FND_API.G_RET_STS_ERROR;
2553: FND_MESSAGE.SET_NAME('ONT','ONT_COM_CUSTOMER_MISMATCH');
2554: FND_MESSAGE.SET_TOKEN('CUSTOMER','');
2555: OE_MSG_PUB.ADD;
2556: end if;
2557:
2558: /* Fix Bug # 3015881 End */
2579:
2580: IF NOT OE_GLOBALS.EQUAL(nvl(l_agreement_id, p_line_rec.agreement_id), p_line_rec.agreement_id)
2581: AND p_line_rec.agreement_id IS NOT NULL THEN
2582: x_return_status := FND_API.G_RET_STS_ERROR;
2583: fnd_message.set_name('ONT','ONT_COM_AGREEMENT_MISMATCH');
2584: FND_MESSAGE.SET_TOKEN('AGREEMENT',OE_Id_To_Value.Agreement(p_line_rec.agreement_id));
2585: OE_MSG_PUB.Add;
2586: END IF;
2587:
2580: IF NOT OE_GLOBALS.EQUAL(nvl(l_agreement_id, p_line_rec.agreement_id), p_line_rec.agreement_id)
2581: AND p_line_rec.agreement_id IS NOT NULL THEN
2582: x_return_status := FND_API.G_RET_STS_ERROR;
2583: fnd_message.set_name('ONT','ONT_COM_AGREEMENT_MISMATCH');
2584: FND_MESSAGE.SET_TOKEN('AGREEMENT',OE_Id_To_Value.Agreement(p_line_rec.agreement_id));
2585: OE_MSG_PUB.Add;
2586: END IF;
2587:
2588: IF NOT OE_GLOBALS.EQUAL(nvl(l_inventory_item_id, p_line_rec.inventory_item_id), p_line_rec.inventory_item_id) THEN
2586: END IF;
2587:
2588: IF NOT OE_GLOBALS.EQUAL(nvl(l_inventory_item_id, p_line_rec.inventory_item_id), p_line_rec.inventory_item_id) THEN
2589: x_return_status := FND_API.G_RET_STS_ERROR;
2590: fnd_message.set_name('ONT','ONT_COM_ITEM_MISMATCH');
2591: FND_MESSAGE.SET_TOKEN('ITEM', OE_Id_To_Value.Inventory_Item(p_line_rec.inventory_item_id));
2592: OE_MSG_PUB.Add;
2593: END IF;
2594: IF l_debug_level > 0 then
2587:
2588: IF NOT OE_GLOBALS.EQUAL(nvl(l_inventory_item_id, p_line_rec.inventory_item_id), p_line_rec.inventory_item_id) THEN
2589: x_return_status := FND_API.G_RET_STS_ERROR;
2590: fnd_message.set_name('ONT','ONT_COM_ITEM_MISMATCH');
2591: FND_MESSAGE.SET_TOKEN('ITEM', OE_Id_To_Value.Inventory_Item(p_line_rec.inventory_item_id));
2592: OE_MSG_PUB.Add;
2593: END IF;
2594: IF l_debug_level > 0 then
2595: oe_debug_pub.add('OEXLLINB: commitment end date is: '||l_comm_end_date, 3);
2609: l_comm_end_date is NOT NULL THEN
2610: IF trunc(l_comm_end_date)< trunc(l_event_end_date)
2611: THEN
2612: x_return_status := FND_API.G_RET_STS_ERROR;
2613: fnd_message.set_name('ONT','ONT_COM_END_DATE');
2614: FND_MESSAGE.SET_TOKEN('COMMITMENT',l_commitment_number);
2615: OE_MSG_PUB.Add;
2616: END IF;
2617: END IF;
2610: IF trunc(l_comm_end_date)< trunc(l_event_end_date)
2611: THEN
2612: x_return_status := FND_API.G_RET_STS_ERROR;
2613: fnd_message.set_name('ONT','ONT_COM_END_DATE');
2614: FND_MESSAGE.SET_TOKEN('COMMITMENT',l_commitment_number);
2615: OE_MSG_PUB.Add;
2616: END IF;
2617: END IF;
2618: END IF;
2640: END IF;
2641:
2642: IF l_commitment_bal <= 0 THEN
2643: x_return_status := FND_API.G_RET_STS_ERROR;
2644: FND_MESSAGE.SET_NAME('ONT','OE_COM_ZERO_BALANCE');
2645: FND_MESSAGE.SET_TOKEN('COMMITMENT',l_commitment_number);
2646: OE_MSG_PUB.Add;
2647: END IF;
2648:
2641:
2642: IF l_commitment_bal <= 0 THEN
2643: x_return_status := FND_API.G_RET_STS_ERROR;
2644: FND_MESSAGE.SET_NAME('ONT','OE_COM_ZERO_BALANCE');
2645: FND_MESSAGE.SET_TOKEN('COMMITMENT',l_commitment_number);
2646: OE_MSG_PUB.Add;
2647: END IF;
2648:
2649: END IF;
2658: x_return_status := FND_API.G_RET_STS_ERROR;
2659: IF l_debug_level > 0 then
2660: OE_DEBUG_PUB.Add('Validate_Commitment: When no data found');
2661: END IF;
2662: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2663: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Commitment Number');
2664: OE_MSG_PUB.Add;
2665:
2666: WHEN OTHERS THEN
2659: IF l_debug_level > 0 then
2660: OE_DEBUG_PUB.Add('Validate_Commitment: When no data found');
2661: END IF;
2662: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2663: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Commitment Number');
2664: OE_MSG_PUB.Add;
2665:
2666: WHEN OTHERS THEN
2667:
2713: THEN
2714: IF l_debug_level > 0 then
2715: oe_debug_pub.add('service / part of smc model', 4);
2716: END IF;
2717: FND_MESSAGE.SET_NAME('ONT', 'OE_DS_NOT_VALID_ITEM');
2718: FND_MESSAGE.SET_TOKEN('ITEM', nvl(p_line_rec.ordered_item,p_line_rec.inventory_item_id));
2719: OE_MSG_PUB.Add;
2720: x_return_status := FND_API.G_RET_STS_ERROR;
2721: RETURN;
2714: IF l_debug_level > 0 then
2715: oe_debug_pub.add('service / part of smc model', 4);
2716: END IF;
2717: FND_MESSAGE.SET_NAME('ONT', 'OE_DS_NOT_VALID_ITEM');
2718: FND_MESSAGE.SET_TOKEN('ITEM', nvl(p_line_rec.ordered_item,p_line_rec.inventory_item_id));
2719: OE_MSG_PUB.Add;
2720: x_return_status := FND_API.G_RET_STS_ERROR;
2721: RETURN;
2722: ELSE
2728: IF (p_line_rec.item_type_code <> OE_GLOBALS.G_ITEM_STANDARD) THEN
2729: IF l_debug_level > 0 then
2730: oe_debug_pub.add('Cannot dropship non-standard item',2);
2731: END IF;
2732: FND_MESSAGE.SET_NAME('ONT', 'OE_DS_NOT_ALLOWED');
2733: OE_MSG_PUB.Add;
2734: x_return_status := FND_API.G_RET_STS_ERROR;
2735: RETURN;
2736: END IF;
2772: END IF;
2773: END IF;
2774:
2775: IF l_purchasing_enabled_flag = 'N' THEN
2776: FND_MESSAGE.SET_NAME('ONT', 'OE_DS_NOT_ENABLED');
2777: FND_MESSAGE.SET_TOKEN('ITEM', nvl(p_line_rec.ordered_item,p_line_rec.inventory_item_id));
2778: FND_MESSAGE.SET_TOKEN('ORG', nvl(p_line_rec.ship_from_org_id,
2779: OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID')));
2780: OE_MSG_PUB.Add;
2773: END IF;
2774:
2775: IF l_purchasing_enabled_flag = 'N' THEN
2776: FND_MESSAGE.SET_NAME('ONT', 'OE_DS_NOT_ENABLED');
2777: FND_MESSAGE.SET_TOKEN('ITEM', nvl(p_line_rec.ordered_item,p_line_rec.inventory_item_id));
2778: FND_MESSAGE.SET_TOKEN('ORG', nvl(p_line_rec.ship_from_org_id,
2779: OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID')));
2780: OE_MSG_PUB.Add;
2781: x_return_status := FND_API.G_RET_STS_ERROR;
2774:
2775: IF l_purchasing_enabled_flag = 'N' THEN
2776: FND_MESSAGE.SET_NAME('ONT', 'OE_DS_NOT_ENABLED');
2777: FND_MESSAGE.SET_TOKEN('ITEM', nvl(p_line_rec.ordered_item,p_line_rec.inventory_item_id));
2778: FND_MESSAGE.SET_TOKEN('ORG', nvl(p_line_rec.ship_from_org_id,
2779: OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID')));
2780: OE_MSG_PUB.Add;
2781: x_return_status := FND_API.G_RET_STS_ERROR;
2782: END IF;
2792: THEN
2793: IF l_debug_level > 0 then
2794: oe_debug_pub.add('item under ato model', 4);
2795: END IF;
2796: FND_MESSAGE.SET_NAME('ONT', 'OE_DS_CHANGE_NOT_ALLOWED');
2797: OE_MSG_PUB.Add;
2798: x_return_status := FND_API.G_RET_STS_ERROR;
2799: END IF;
2800: IF l_debug_level > 0 then
2861: NOT OE_GLOBALS.Equal(p_line_rec.arrival_set_id,
2862: l_arrival_set_id)) AND
2863: OE_ORDER_SCH_UTIL.OESCH_PERFORM_SCHEDULING = 'Y' THEN
2864:
2865: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_SET_OPR');
2866: FND_MESSAGE.SET_TOKEN('ITEMTYPE', p_line_rec.item_type_code);
2867: OE_MSG_PUB.ADD;
2868: IF l_debug_level > 0 then
2869: oe_debug_pub.add('Set- not allowed for this itemtype');
2862: l_arrival_set_id)) AND
2863: OE_ORDER_SCH_UTIL.OESCH_PERFORM_SCHEDULING = 'Y' THEN
2864:
2865: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_SET_OPR');
2866: FND_MESSAGE.SET_TOKEN('ITEMTYPE', p_line_rec.item_type_code);
2867: OE_MSG_PUB.ADD;
2868: IF l_debug_level > 0 then
2869: oe_debug_pub.add('Set- not allowed for this itemtype');
2870: END IF;
2888: oe_debug_pub.add('arrival_set_id : '|| p_line_rec.arrival_set_id,2);
2889: oe_debug_pub.add('arrival_set : '|| p_line_rec.arrival_set,2);
2890: oe_debug_pub.add('Set name - not allowed for this itemtype');
2891: END IF;
2892: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_SET_OPR');
2893: FND_MESSAGE.SET_TOKEN('ITEMTYPE', p_line_rec.item_type_code);
2894: OE_MSG_PUB.ADD;
2895: RETURN FALSE;
2896: END IF; -- set name
2889: oe_debug_pub.add('arrival_set : '|| p_line_rec.arrival_set,2);
2890: oe_debug_pub.add('Set name - not allowed for this itemtype');
2891: END IF;
2892: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_SET_OPR');
2893: FND_MESSAGE.SET_TOKEN('ITEMTYPE', p_line_rec.item_type_code);
2894: OE_MSG_PUB.ADD;
2895: RETURN FALSE;
2896: END IF; -- set name
2897: END IF; -- main
2918: END IF;
2919: x_return_status := FND_API.G_RET_STS_SUCCESS;
2920:
2921: IF LENGTHB(p_line_rec.user_item_description) > 240 THEN
2922: fnd_message.set_name('ONT','ONT_USER_ITEM_DESC_TOO_LONG');
2923: OE_MSG_PUB.Add;
2924: IF l_debug_level > 0 then
2925: Oe_debug_pub.add('The length of user_item_description should not exceed 240 characters for drop ship lines.',3);
2926: END IF;
3018: if l_debug_level > 0 then
3019: oe_debug_pub.add('Blanket Line Number is not supplied: Blanket #:'||
3020: p_line_rec.blanket_number || ', Inventory Item #:'||p_line_rec.inventory_item_id, 2);
3021: end if;
3022: FND_MESSAGE.SET_NAME('ONT', 'OE_BLKT_NO_BLANKET_LINE_NUM');
3023: OE_MSG_PUB.Add;
3024: x_return_status := FND_API.G_RET_STS_ERROR;
3025: END IF;
3026:
3041: if l_debug_level > 0 then
3042: oe_debug_pub.add('Blankets only support standard items', 1);
3043: end if;
3044:
3045: FND_MESSAGE.SET_NAME('ONT', 'OE_BLKT_NON_STANDARD_ITEM');
3046: OE_MSG_PUB.Add;
3047: x_return_status := FND_API.G_RET_STS_ERROR;
3048:
3049: END IF;
3053: if l_debug_level > 0 then
3054: oe_debug_pub.add('Blankets does not support Included items', 1);
3055: end if;
3056:
3057: FND_MESSAGE.SET_NAME('ONT', 'OE_BLKT_INCLUDED_ITEM');
3058: OE_MSG_PUB.Add;
3059: x_return_status := FND_API.G_RET_STS_ERROR;
3060: END IF;
3061:
3062: END IF; -- End of Pack -J changes.
3063: -- Blanket AND Agreement cannot co-exist on release line
3064:
3065: IF p_line_rec.agreement_id IS NOT NULL THEN
3066: FND_MESSAGE.SET_NAME('ONT', 'OE_BLKT_AGREEMENT_EXISTS');
3067: OE_MSG_PUB.Add;
3068: x_return_status := FND_API.G_RET_STS_ERROR;
3069: END IF;
3070:
3166: IF (l_item_id <> p_line_rec.inventory_item_id) THEN
3167: if l_debug_level > 0 then
3168: oe_debug_pub.add('Release does not match blanket line inventory item', 1);
3169: end if;
3170: FND_MESSAGE.SET_NAME('ONT', 'OE_BLKT_INVALID_ATTRIBUTE');
3171: fnd_message.set_token('ATTRIBUTE', OE_Order_Util.Get_Attribute_Name('INVENTORY_ITEM_ID'));
3172: --for bug 3257240
3173: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE', OE_Id_To_Value.Inventory_Item(l_item_id));
3174: OE_MSG_PUB.Add;
3167: if l_debug_level > 0 then
3168: oe_debug_pub.add('Release does not match blanket line inventory item', 1);
3169: end if;
3170: FND_MESSAGE.SET_NAME('ONT', 'OE_BLKT_INVALID_ATTRIBUTE');
3171: fnd_message.set_token('ATTRIBUTE', OE_Order_Util.Get_Attribute_Name('INVENTORY_ITEM_ID'));
3172: --for bug 3257240
3173: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE', OE_Id_To_Value.Inventory_Item(l_item_id));
3174: OE_MSG_PUB.Add;
3175: x_return_status := FND_API.G_RET_STS_ERROR;
3169: end if;
3170: FND_MESSAGE.SET_NAME('ONT', 'OE_BLKT_INVALID_ATTRIBUTE');
3171: fnd_message.set_token('ATTRIBUTE', OE_Order_Util.Get_Attribute_Name('INVENTORY_ITEM_ID'));
3172: --for bug 3257240
3173: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE', OE_Id_To_Value.Inventory_Item(l_item_id));
3174: OE_MSG_PUB.Add;
3175: x_return_status := FND_API.G_RET_STS_ERROR;
3176: END IF;
3177: ELSIF l_item_context = 'CUST' THEN
3180: OR l_item_id <> p_line_rec.inventory_item_id ) THEN
3181: if l_debug_level > 0 then
3182: oe_debug_pub.add('Release does not match blanket line customer item', 1);
3183: end if;
3184: FND_MESSAGE.SET_NAME('ONT', 'OE_BLKT_INVALID_ATTRIBUTE');
3185: fnd_message.set_token('ATTRIBUTE', OE_Order_Util.Get_Attribute_Name('CUSTOMER_ITEM_ID'));
3186: --for bug 3257240
3187: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE', OE_Id_To_Value.Inventory_Item(l_item_id));
3188: OE_MSG_PUB.Add;
3181: if l_debug_level > 0 then
3182: oe_debug_pub.add('Release does not match blanket line customer item', 1);
3183: end if;
3184: FND_MESSAGE.SET_NAME('ONT', 'OE_BLKT_INVALID_ATTRIBUTE');
3185: fnd_message.set_token('ATTRIBUTE', OE_Order_Util.Get_Attribute_Name('CUSTOMER_ITEM_ID'));
3186: --for bug 3257240
3187: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE', OE_Id_To_Value.Inventory_Item(l_item_id));
3188: OE_MSG_PUB.Add;
3189: x_return_status := FND_API.G_RET_STS_ERROR;
3183: end if;
3184: FND_MESSAGE.SET_NAME('ONT', 'OE_BLKT_INVALID_ATTRIBUTE');
3185: fnd_message.set_token('ATTRIBUTE', OE_Order_Util.Get_Attribute_Name('CUSTOMER_ITEM_ID'));
3186: --for bug 3257240
3187: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE', OE_Id_To_Value.Inventory_Item(l_item_id));
3188: OE_MSG_PUB.Add;
3189: x_return_status := FND_API.G_RET_STS_ERROR;
3190: END IF;
3191:
3216: WHERE CATEGORY_ID = l_item_id;
3217: if l_debug_level > 0 then
3218: oe_debug_pub.add('Release does not match blanket line item category', 1);
3219: end if;
3220: FND_MESSAGE.SET_NAME('ONT', 'OE_BLKT_INVALID_ATTRIBUTE');
3221: fnd_message.set_token('ATTRIBUTE', OE_Order_Util.Get_Attribute_Name('INVENTORY_ITEM_ID'));
3222: --for bug 3257240
3223: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE', OE_Id_To_Value.Inventory_Item(l_item_id));
3224: OE_MSG_PUB.Add;
3217: if l_debug_level > 0 then
3218: oe_debug_pub.add('Release does not match blanket line item category', 1);
3219: end if;
3220: FND_MESSAGE.SET_NAME('ONT', 'OE_BLKT_INVALID_ATTRIBUTE');
3221: fnd_message.set_token('ATTRIBUTE', OE_Order_Util.Get_Attribute_Name('INVENTORY_ITEM_ID'));
3222: --for bug 3257240
3223: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE', OE_Id_To_Value.Inventory_Item(l_item_id));
3224: OE_MSG_PUB.Add;
3225: x_return_status := FND_API.G_RET_STS_ERROR;
3219: end if;
3220: FND_MESSAGE.SET_NAME('ONT', 'OE_BLKT_INVALID_ATTRIBUTE');
3221: fnd_message.set_token('ATTRIBUTE', OE_Order_Util.Get_Attribute_Name('INVENTORY_ITEM_ID'));
3222: --for bug 3257240
3223: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE', OE_Id_To_Value.Inventory_Item(l_item_id));
3224: OE_MSG_PUB.Add;
3225: x_return_status := FND_API.G_RET_STS_ERROR;
3226: END;
3227:
3231:
3232: if l_debug_level > 0 then
3233: oe_debug_pub.add('Release does not match blanket line xref item item', 1);
3234: end if;
3235: FND_MESSAGE.SET_NAME('ONT', 'OE_BLKT_INVALID_ATTRIBUTE');
3236: fnd_message.set_token('ATTRIBUTE', OE_Order_Util.Get_Attribute_Name('ORDERED_ITEM'));
3237: --for bug 3257240
3238: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE', OE_Id_To_Value.Inventory_Item(l_item_id));
3239: OE_MSG_PUB.Add;
3232: if l_debug_level > 0 then
3233: oe_debug_pub.add('Release does not match blanket line xref item item', 1);
3234: end if;
3235: FND_MESSAGE.SET_NAME('ONT', 'OE_BLKT_INVALID_ATTRIBUTE');
3236: fnd_message.set_token('ATTRIBUTE', OE_Order_Util.Get_Attribute_Name('ORDERED_ITEM'));
3237: --for bug 3257240
3238: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE', OE_Id_To_Value.Inventory_Item(l_item_id));
3239: OE_MSG_PUB.Add;
3240: x_return_status := FND_API.G_RET_STS_ERROR;
3234: end if;
3235: FND_MESSAGE.SET_NAME('ONT', 'OE_BLKT_INVALID_ATTRIBUTE');
3236: fnd_message.set_token('ATTRIBUTE', OE_Order_Util.Get_Attribute_Name('ORDERED_ITEM'));
3237: --for bug 3257240
3238: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE', OE_Id_To_Value.Inventory_Item(l_item_id));
3239: OE_MSG_PUB.Add;
3240: x_return_status := FND_API.G_RET_STS_ERROR;
3241: END IF;
3242: END IF;
3269: AND STATUS = 'A'
3270: AND ROWNUM = 1;
3271: exception
3272: when no_data_found then
3273: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_ATTRIBUTE');
3274: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name
3275: ('SOLD_TO_ORG_ID'));
3276: --for bug 3257240
3277: OE_Id_To_Value.Sold_To_Org
3270: AND ROWNUM = 1;
3271: exception
3272: when no_data_found then
3273: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_ATTRIBUTE');
3274: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name
3275: ('SOLD_TO_ORG_ID'));
3276: --for bug 3257240
3277: OE_Id_To_Value.Sold_To_Org
3278: ( p_sold_to_org_id => l_sold_to_org_id
3278: ( p_sold_to_org_id => l_sold_to_org_id
3279: , x_org => l_customer_name
3280: , x_customer_number => l_customer_number
3281: );
3282: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE',l_customer_name);
3283: OE_MSG_PUB.Add;
3284: x_return_status := FND_API.G_RET_STS_ERROR;
3285: end;
3286: else
3283: OE_MSG_PUB.Add;
3284: x_return_status := FND_API.G_RET_STS_ERROR;
3285: end;
3286: else
3287: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_ATTRIBUTE');
3288: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name
3289: ('SOLD_TO_ORG_ID'));
3290: --for bug 3257240
3291: OE_Id_To_Value.Sold_To_Org
3284: x_return_status := FND_API.G_RET_STS_ERROR;
3285: end;
3286: else
3287: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_ATTRIBUTE');
3288: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name
3289: ('SOLD_TO_ORG_ID'));
3290: --for bug 3257240
3291: OE_Id_To_Value.Sold_To_Org
3292: ( p_sold_to_org_id => l_sold_to_org_id
3292: ( p_sold_to_org_id => l_sold_to_org_id
3293: , x_org => l_customer_name
3294: , x_customer_number => l_customer_number
3295: );
3296: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE',l_customer_name);
3297: OE_MSG_PUB.Add;
3298: x_return_status := FND_API.G_RET_STS_ERROR;
3299: end if;
3300: END IF;
3312: THEN
3313: if l_debug_level > 0 then
3314: oe_debug_pub.add('Blanket order is currently on hold', 1);
3315: end if;
3316: FND_MESSAGE.SET_NAME('ONT', 'OE_BLKT_ON_HOLD');
3317: OE_MSG_PUB.Add;
3318: x_return_status := FND_API.G_RET_STS_ERROR;
3319: END IF;
3320:
3327: THEN
3328: if l_debug_level > 0 then
3329: oe_debug_pub.add('Blanket is not in Active Status', 1);
3330: end if;
3331: FND_MESSAGE.SET_NAME('ONT', 'OE_BLKT_INVALID_BLANKET');
3332: OE_MSG_PUB.Add;
3333: x_return_status := FND_API.G_RET_STS_ERROR;
3334: END IF;
3335:
3354: THEN
3355: if l_debug_level > 0 then
3356: oe_debug_pub.add('Request date is not within active blanket line dates', 1);
3357: end if;
3358: FND_MESSAGE.SET_NAME('ONT', 'OE_BLKT_INVALID_LINE_REQ_DATE');
3359: OE_MSG_PUB.Add;
3360: x_return_status := FND_API.G_RET_STS_ERROR;
3361: END IF;
3362:
3376: OR NOT OE_GLOBALS.EQUAL(p_line_rec.price_list_id
3377: ,p_old_line_rec.price_list_id) )
3378: THEN
3379: IF l_price_list_id <> p_line_rec.price_list_id THEN
3380: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_ATTRIBUTE');
3381: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name
3382: ('PRICE_LIST_ID'));
3383: --for bug 3257240
3384: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE',OE_Id_To_Value.Price_List(l_price_list_id));
3377: ,p_old_line_rec.price_list_id) )
3378: THEN
3379: IF l_price_list_id <> p_line_rec.price_list_id THEN
3380: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_ATTRIBUTE');
3381: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name
3382: ('PRICE_LIST_ID'));
3383: --for bug 3257240
3384: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE',OE_Id_To_Value.Price_List(l_price_list_id));
3385: OE_MSG_PUB.ADD;
3380: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_ATTRIBUTE');
3381: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name
3382: ('PRICE_LIST_ID'));
3383: --for bug 3257240
3384: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE',OE_Id_To_Value.Price_List(l_price_list_id));
3385: OE_MSG_PUB.ADD;
3386: x_return_status := FND_API.G_RET_STS_ERROR;
3387: END IF;
3388: END IF;
3395: OR NOT OE_GLOBALS.EQUAL(p_line_rec.ship_to_org_id
3396: ,p_old_line_rec.ship_to_org_id) )
3397: THEN
3398: IF l_ship_to_org_id <> p_line_rec.ship_to_org_id THEN
3399: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_ATTRIBUTE');
3400: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name
3401: ('SHIP_TO_ORG_ID'));
3402: --for bug 3257240
3403: OE_ID_TO_VALUE.ship_to_Org
3396: ,p_old_line_rec.ship_to_org_id) )
3397: THEN
3398: IF l_ship_to_org_id <> p_line_rec.ship_to_org_id THEN
3399: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_ATTRIBUTE');
3400: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name
3401: ('SHIP_TO_ORG_ID'));
3402: --for bug 3257240
3403: OE_ID_TO_VALUE.ship_to_Org
3404: ( p_ship_to_org_id => p_line_rec.ship_to_org_id
3412: , x_ship_to_state => l_state
3413: , x_ship_to_postal_code => l_postal_code
3414: , x_ship_to_country => l_country
3415: );
3416: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE',l_org);
3417: OE_MSG_PUB.ADD;
3418: x_return_status := FND_API.G_RET_STS_ERROR;
3419: END IF;
3420: END IF;
3427: OR NOT OE_GLOBALS.EQUAL(p_line_rec.invoice_to_org_id
3428: ,p_old_line_rec.invoice_to_org_id) )
3429: THEN
3430: IF l_invoice_to_org_id <> p_line_rec.invoice_to_org_id THEN
3431: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_ATTRIBUTE');
3432: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name
3433: ('INVOICE_TO_ORG_ID'));
3434: --for bug 3257240
3435: OE_ID_TO_VALUE.Invoice_To_Org
3428: ,p_old_line_rec.invoice_to_org_id) )
3429: THEN
3430: IF l_invoice_to_org_id <> p_line_rec.invoice_to_org_id THEN
3431: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_ATTRIBUTE');
3432: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name
3433: ('INVOICE_TO_ORG_ID'));
3434: --for bug 3257240
3435: OE_ID_TO_VALUE.Invoice_To_Org
3436: ( p_invoice_to_org_id => p_line_rec.invoice_to_org_id
3444: , x_invoice_to_state => l_state
3445: , x_invoice_to_postal_code => l_postal_code
3446: , x_invoice_to_country => l_country
3447: );
3448: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE',l_org);
3449: OE_MSG_PUB.ADD;
3450: x_return_status := FND_API.G_RET_STS_ERROR;
3451: END IF;
3452: END IF;
3459: OR NOT OE_GLOBALS.EQUAL(p_line_rec.freight_terms_code
3460: ,p_old_line_rec.freight_terms_code) )
3461: THEN
3462: IF l_freight_terms_code <> p_line_rec.freight_terms_code THEN
3463: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_ATTRIBUTE');
3464: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name
3465: ('FREIGHT_TERMS_CODE'));
3466: --for bug 3257240
3467: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE',OE_Id_To_Value.Freight_Terms(l_freight_terms_code));
3460: ,p_old_line_rec.freight_terms_code) )
3461: THEN
3462: IF l_freight_terms_code <> p_line_rec.freight_terms_code THEN
3463: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_ATTRIBUTE');
3464: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name
3465: ('FREIGHT_TERMS_CODE'));
3466: --for bug 3257240
3467: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE',OE_Id_To_Value.Freight_Terms(l_freight_terms_code));
3468: OE_MSG_PUB.ADD;
3463: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_ATTRIBUTE');
3464: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name
3465: ('FREIGHT_TERMS_CODE'));
3466: --for bug 3257240
3467: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE',OE_Id_To_Value.Freight_Terms(l_freight_terms_code));
3468: OE_MSG_PUB.ADD;
3469: x_return_status := FND_API.G_RET_STS_ERROR;
3470: END IF;
3471: END IF;
3478: OR NOT OE_GLOBALS.EQUAL(p_line_rec.shipping_method_code
3479: ,p_old_line_rec.shipping_method_code) )
3480: THEN
3481: IF l_shipping_method_code <> p_line_rec.shipping_method_code THEN
3482: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_ATTRIBUTE');
3483: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name
3484: ('SHIPPING_METHOD_CODE'));
3485: --for bug 3257240
3486: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE',OE_Id_To_Value.Ship_Method(l_shipping_method_code));
3479: ,p_old_line_rec.shipping_method_code) )
3480: THEN
3481: IF l_shipping_method_code <> p_line_rec.shipping_method_code THEN
3482: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_ATTRIBUTE');
3483: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name
3484: ('SHIPPING_METHOD_CODE'));
3485: --for bug 3257240
3486: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE',OE_Id_To_Value.Ship_Method(l_shipping_method_code));
3487: OE_MSG_PUB.ADD;
3482: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_ATTRIBUTE');
3483: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name
3484: ('SHIPPING_METHOD_CODE'));
3485: --for bug 3257240
3486: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE',OE_Id_To_Value.Ship_Method(l_shipping_method_code));
3487: OE_MSG_PUB.ADD;
3488: x_return_status := FND_API.G_RET_STS_ERROR;
3489: END IF;
3490: END IF;
3497: OR NOT OE_GLOBALS.EQUAL(p_line_rec.payment_term_id
3498: ,p_old_line_rec.payment_term_id) )
3499: THEN
3500: IF l_payment_term_id <> p_line_rec.payment_term_id THEN
3501: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_ATTRIBUTE');
3502: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name
3503: ('PAYMENT_TERM_ID'));
3504: --for bug 3257240
3505: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE',OE_Id_To_Value.Payment_Term(l_payment_term_id));
3498: ,p_old_line_rec.payment_term_id) )
3499: THEN
3500: IF l_payment_term_id <> p_line_rec.payment_term_id THEN
3501: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_ATTRIBUTE');
3502: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name
3503: ('PAYMENT_TERM_ID'));
3504: --for bug 3257240
3505: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE',OE_Id_To_Value.Payment_Term(l_payment_term_id));
3506: OE_MSG_PUB.ADD;
3501: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_ATTRIBUTE');
3502: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name
3503: ('PAYMENT_TERM_ID'));
3504: --for bug 3257240
3505: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE',OE_Id_To_Value.Payment_Term(l_payment_term_id));
3506: OE_MSG_PUB.ADD;
3507: x_return_status := FND_API.G_RET_STS_ERROR;
3508: END IF;
3509: END IF;
3516: OR NOT OE_GLOBALS.EQUAL(p_line_rec.accounting_rule_id
3517: ,p_old_line_rec.accounting_rule_id) )
3518: THEN
3519: IF l_accounting_rule_id <> p_line_rec.accounting_rule_id THEN
3520: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_ATTRIBUTE');
3521: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name
3522: ('ACCOUNTING_RULE_ID'));
3523: --for bug 3257240
3524: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE',OE_Id_To_Value.Accounting_Rule(l_accounting_rule_id));
3517: ,p_old_line_rec.accounting_rule_id) )
3518: THEN
3519: IF l_accounting_rule_id <> p_line_rec.accounting_rule_id THEN
3520: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_ATTRIBUTE');
3521: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name
3522: ('ACCOUNTING_RULE_ID'));
3523: --for bug 3257240
3524: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE',OE_Id_To_Value.Accounting_Rule(l_accounting_rule_id));
3525: OE_MSG_PUB.ADD;
3520: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_ATTRIBUTE');
3521: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name
3522: ('ACCOUNTING_RULE_ID'));
3523: --for bug 3257240
3524: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE',OE_Id_To_Value.Accounting_Rule(l_accounting_rule_id));
3525: OE_MSG_PUB.ADD;
3526: x_return_status := FND_API.G_RET_STS_ERROR;
3527: END IF;
3528: END IF;
3535: OR NOT OE_GLOBALS.EQUAL(p_line_rec.invoicing_rule_id
3536: ,p_old_line_rec.invoicing_rule_id) )
3537: THEN
3538: IF l_invoicing_rule_id <> p_line_rec.invoicing_rule_id THEN
3539: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_ATTRIBUTE');
3540: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name
3541: ('INVOICING_RULE_ID'));
3542: --for bug 3257240
3543: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE',OE_Id_To_Value.Invoicing_Rule(l_invoicing_rule_id));
3536: ,p_old_line_rec.invoicing_rule_id) )
3537: THEN
3538: IF l_invoicing_rule_id <> p_line_rec.invoicing_rule_id THEN
3539: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_ATTRIBUTE');
3540: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name
3541: ('INVOICING_RULE_ID'));
3542: --for bug 3257240
3543: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE',OE_Id_To_Value.Invoicing_Rule(l_invoicing_rule_id));
3544: OE_MSG_PUB.ADD;
3539: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_ATTRIBUTE');
3540: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name
3541: ('INVOICING_RULE_ID'));
3542: --for bug 3257240
3543: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE',OE_Id_To_Value.Invoicing_Rule(l_invoicing_rule_id));
3544: OE_MSG_PUB.ADD;
3545: x_return_status := FND_API.G_RET_STS_ERROR;
3546: END IF;
3547: END IF;
3551: if l_debug_level > 0 then
3552: oe_debug_pub.add('Blanket Values combination is not valid: Blanket #:'||
3553: p_line_rec.blanket_number || ', Blanket Line #:'||p_line_rec.blanket_line_number, 2);
3554: end if;
3555: FND_MESSAGE.SET_NAME('ONT', 'OE_BLKT_INVALID_BLANKET');
3556: OE_MSG_PUB.Add;
3557: x_return_status := FND_API.G_RET_STS_ERROR;
3558:
3559: WHEN FND_API.G_EXC_ERROR THEN
3830: THEN
3831:
3832: l_return_status := FND_API.G_RET_STS_ERROR;
3833:
3834: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
3835: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
3836: OE_Order_UTIL.Get_Attribute_Name('LINE_ID'));
3837: OE_MSG_PUB.Add;
3838:
3831:
3832: l_return_status := FND_API.G_RET_STS_ERROR;
3833:
3834: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
3835: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
3836: OE_Order_UTIL.Get_Attribute_Name('LINE_ID'));
3837: OE_MSG_PUB.Add;
3838:
3839: END IF;
3844: THEN
3845:
3846: l_return_status := FND_API.G_RET_STS_ERROR;
3847:
3848: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
3849: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
3850: OE_Order_UTIL.Get_Attribute_Name('INVENTORY_ITEM_ID'));
3851: OE_MSG_PUB.Add;
3852:
3845:
3846: l_return_status := FND_API.G_RET_STS_ERROR;
3847:
3848: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
3849: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
3850: OE_Order_UTIL.Get_Attribute_Name('INVENTORY_ITEM_ID'));
3851: OE_MSG_PUB.Add;
3852:
3853: END IF;
3858: THEN
3859:
3860: l_return_status := FND_API.G_RET_STS_ERROR;
3861:
3862: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
3863: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
3864: OE_Order_UTIL.Get_Attribute_Name('LINE_TYPE_ID'));
3865: OE_MSG_PUB.Add;
3866:
3859:
3860: l_return_status := FND_API.G_RET_STS_ERROR;
3861:
3862: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
3863: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
3864: OE_Order_UTIL.Get_Attribute_Name('LINE_TYPE_ID'));
3865: OE_MSG_PUB.Add;
3866:
3867: ELSIF p_line_rec.line_type_id IS NOT NULL AND -- Bug 5873408
3896: ELSE
3897:
3898: -- Feature not supported prior to 11i10, raise error
3899: IF p_line_rec.transaction_phase_code = 'N' THEN
3900: FND_MESSAGE.SET_NAME('ONT','OE_QUOTE_INVALID_RELEASE');
3901: OE_MSG_PUB.ADD;
3902: RAISE FND_API.G_EXC_ERROR;
3903: END IF;
3904:
3916: IF p_line_rec.return_reason_code is NULL
3917: THEN
3918: l_return_status := FND_API.G_RET_STS_ERROR;
3919:
3920: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
3921: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
3922: OE_Order_UTIL.Get_Attribute_Name('RETURN_REASON_CODE'));
3923: OE_MSG_PUB.Add;
3924: END IF;
3917: THEN
3918: l_return_status := FND_API.G_RET_STS_ERROR;
3919:
3920: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
3921: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
3922: OE_Order_UTIL.Get_Attribute_Name('RETURN_REASON_CODE'));
3923: OE_MSG_PUB.Add;
3924: END IF;
3925:
3976: -- Any item other than Standard can not have level - four or five
3977: IF (l_scheduling_level_code = OE_SCHEDULE_UTIL.SCH_LEVEL_FOUR
3978: OR l_scheduling_level_code = OE_SCHEDULE_UTIL.SCH_LEVEL_FIVE) THEN
3979:
3980: FND_MESSAGE.SET_NAME('ONT', 'OE_SCH_INACTIVE_STD_ONLY');
3981: FND_MESSAGE.SET_TOKEN('LTYPE',nvl(Oe_Schedule_Util.sch_cached_line_type ,'0'));
3982: OE_MSG_PUB.Add;
3983: l_return_status := FND_API.G_RET_STS_ERROR;
3984: END IF;
3977: IF (l_scheduling_level_code = OE_SCHEDULE_UTIL.SCH_LEVEL_FOUR
3978: OR l_scheduling_level_code = OE_SCHEDULE_UTIL.SCH_LEVEL_FIVE) THEN
3979:
3980: FND_MESSAGE.SET_NAME('ONT', 'OE_SCH_INACTIVE_STD_ONLY');
3981: FND_MESSAGE.SET_TOKEN('LTYPE',nvl(Oe_Schedule_Util.sch_cached_line_type ,'0'));
3982: OE_MSG_PUB.Add;
3983: l_return_status := FND_API.G_RET_STS_ERROR;
3984: END IF;
3985:
3993: IF l_debug_level > 0 then
3994: oe_debug_pub.add( 'A SERVICE LINE ', 1 ) ;
3995: END IF;
3996:
3997: FND_MESSAGE.SET_NAME('ONT','OE_SCH_NO_ACTION_DONE_NO_EXP');
3998: OE_MSG_PUB.Add;
3999: l_return_status := FND_API.G_RET_STS_ERROR;
4000: END IF;
4001: ---- End 2720165 --
4020: WHERE organization_id = p_line_rec.ship_from_org_id
4021: AND secondary_inventory_name = p_line_rec.subinventory;
4022: EXCEPTION
4023: WHEN OTHERS THEN
4024: fnd_message.set_name('ONT','OE_SUBINV_INVALID');
4025: OE_MSG_PUB.Add;
4026: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4027: END;
4028: END IF;
4032: IF nvl(p_line_rec.shipment_number,FND_API.G_MISS_NUM) <> nvl(p_old_line_rec.shipment_number,FND_API.G_MISS_NUM)
4033: AND p_line_rec.operation =OE_GLOBALS.G_OPR_UPDATE
4034: AND nvl(p_line_rec.split_action_code,'X')<>'SPLIT'
4035: THEN
4036: fnd_message.set_name('ONT','OE_CANT_UPDATE_SHIPMENT_NO');
4037: OE_MSG_PUB.Add;
4038: l_return_status:=FND_API.G_RET_STS_ERROR;
4039: END IF;
4040:
4045: oe_debug_pub.add('Entity Validateion: subinventory', 1);
4046: END IF;
4047: IF p_line_rec.ship_from_org_id is null THEN
4048: l_return_status := FND_API.G_RET_STS_ERROR;
4049: fnd_message.set_name('ONT', 'OE_ATTRIBUTE_REQUIRED');
4050: fnd_message.set_token('ATTRIBUTE',OE_Order_UTIL.Get_Attribute_Name('SHIP_FROM_ORG_ID'));
4051: OE_MSG_PUB.Add;
4052: ELSE
4053: -- validate the subinv is allowed (expense/asset)
4046: END IF;
4047: IF p_line_rec.ship_from_org_id is null THEN
4048: l_return_status := FND_API.G_RET_STS_ERROR;
4049: fnd_message.set_name('ONT', 'OE_ATTRIBUTE_REQUIRED');
4050: fnd_message.set_token('ATTRIBUTE',OE_Order_UTIL.Get_Attribute_Name('SHIP_FROM_ORG_ID'));
4051: OE_MSG_PUB.Add;
4052: ELSE
4053: -- validate the subinv is allowed (expense/asset)
4054: -- because defaulting can be defaulting an expense sub
4098: and secondary_inventory = p_line_rec.subinventory;
4099: EXCEPTION
4100: WHEN OTHERS THEN
4101: l_return_status := FND_API.G_RET_STS_ERROR;
4102: fnd_message.set_name('ONT', 'OE_SUBINV_INVALID');
4103: oe_msg_pub.add;
4104: END;
4105: ELSE -- not a restricted subinv case
4106: BEGIN
4134: );
4135: EXCEPTION
4136: WHEN OTHERS THEN
4137: l_return_status := FND_API.G_RET_STS_ERROR;
4138: fnd_message.set_name('ONT', 'OE_SUBINV_NON_ASSET');
4139: oe_msg_pub.add;
4140: END;
4141: END IF; -- restrict subinv or not
4142: END IF;
4141: END IF; -- restrict subinv or not
4142: END IF;
4143: ELSE -- external
4144: l_return_status := FND_API.G_RET_STS_ERROR;
4145: fnd_message.set_name('ONT', 'OE_SUBINV_EXTERNAL');
4146: OE_MSG_PUB.Add;
4147: END IF;
4148: END IF;
4149:
4210: AND effectivity_date<=sysdate
4211: AND revision= p_line_rec.item_revision;
4212: EXCEPTION
4213: WHEN NO_DATA_FOUND THEN
4214: fnd_message.set_name('ONT','ONT_REV_WH_NOT_EXIST');
4215: OE_MSG_PUB.Add;
4216: l_return_status := FND_API.G_RET_STS_ERROR;
4217: END;
4218: IF p_line_rec.reference_line_id is NOT NULL AND
4244:
4245: IF l_notnull_revision_flag = 'Y' AND
4246: l_tot_transaction_quantity = 0
4247: THEN
4248: fnd_message.set_name('ONT','ONT_ITEM_REV_MISMATCH');
4249: OE_MSG_PUB.Add;
4250: END IF;
4251:
4252: IF l_tot_transaction_quantity > 0
4276: END IF;
4277: IF (l_tot_transaction_quantity - NVL(l_quantity_entered,0))
4278: < p_line_rec.ordered_quantity
4279: THEN
4280: fnd_message.set_name('ONT','ONT_RMA_EXCEED_SHIP_QTY');
4281: OE_MSG_PUB.Add;
4282: l_return_status := FND_API.G_RET_STS_ERROR;
4283: END IF;
4284: END IF; -- IF l_tot_transaction_quantity > 0
4311: IF l_debug_level > 0 THEN
4312: oe_debug_pub.add('dual X-VAL qty 1 not empty', 2);
4313: END IF;
4314: l_return_status := FND_API.G_RET_STS_ERROR;
4315: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
4316: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Ordered_Quantity2');
4317: OE_MSG_PUB.Add;
4318:
4319: ELSIF (p_line_rec.ordered_quantity2 <> FND_API.G_MISS_NUM OR
4312: oe_debug_pub.add('dual X-VAL qty 1 not empty', 2);
4313: END IF;
4314: l_return_status := FND_API.G_RET_STS_ERROR;
4315: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
4316: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Ordered_Quantity2');
4317: OE_MSG_PUB.Add;
4318:
4319: ELSIF (p_line_rec.ordered_quantity2 <> FND_API.G_MISS_NUM OR
4320: p_line_rec.ordered_quantity2 IS NOT NULL) AND
4321: (p_old_line_rec.ordered_quantity = FND_API.G_MISS_NUM OR
4322: p_line_rec.ordered_quantity IS NULL) THEN
4323:
4324: l_return_status := FND_API.G_RET_STS_ERROR;
4325: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
4326: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Ordered_Quantity');
4327: OE_MSG_PUB.Add;
4328: END IF;
4329: -- END IF; INVCONV
4322: p_line_rec.ordered_quantity IS NULL) THEN
4323:
4324: l_return_status := FND_API.G_RET_STS_ERROR;
4325: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
4326: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Ordered_Quantity');
4327: OE_MSG_PUB.Add;
4328: END IF;
4329: -- END IF; INVCONV
4330:
4421: l_delta_qty2 := p_line_rec.ordered_quantity2 - nvl(l_req_qty2,0);
4422:
4423: IF ( l_delta_qty1 > 0 AND l_delta_qty2 <= 0) OR (l_delta_qty2 > 0 AND l_delta_qty1 <= 0) THEN
4424: l_return_status := FND_API.G_RET_STS_ERROR;
4425: FND_MESSAGE.set_name('GMI', 'GMI_SHIPPING_SPLIT_DEV_ERR'); -- INVCONV change this message to INV
4426: OE_MSG_PUB.Add;
4427: END IF;
4428:
4429: IF (l_delta_qty1 > 0) AND (l_delta_qty2 > 0) THEN
4524: l_valid_line_number := 'N';
4525: END;
4526:
4527: IF l_valid_line_number = 'N' THEN
4528: FND_MESSAGE.SET_NAME('ONT','OE_LINE_NUMBER_EXISTS');
4529: OE_MSG_PUB.ADD;
4530: /* x_return_status := FND_API.G_RET_STS_ERROR; This line replaced with next for 2068070 */
4531: l_return_status := FND_API.G_RET_STS_ERROR;
4532: END IF;
4869: -- Schedule_Ship_Date and schedule_Arrival_date. We should not
4870: -- error out for this item.
4871:
4872: IF p_line_rec.item_type_code <> OE_GLOBALS.G_ITEM_CONFIG THEN
4873: FND_MESSAGE.SET_NAME('ONT','OE_SCH_INVALID_CHANGE');
4874: OE_MSG_PUB.Add;
4875: l_return_status := FND_API.G_RET_STS_ERROR;
4876: END IF;
4877:
4906: IF (p_line_rec.project_id IS NOT NULL
4907: AND p_line_rec.ship_from_org_id IS NULL) THEN
4908:
4909: l_return_status := FND_API.G_RET_STS_ERROR;
4910: FND_MESSAGE.SET_NAME('ONT', 'OE_SHIP_FROM_REQD');
4911: OE_MSG_PUB.add;
4912: ELSIF (p_line_rec.task_id IS NOT NULL AND
4913: p_line_rec.project_id IS NULL) THEN
4914:
4912: ELSIF (p_line_rec.task_id IS NOT NULL AND
4913: p_line_rec.project_id IS NULL) THEN
4914:
4915: l_return_status := FND_API.G_RET_STS_ERROR;
4916: FND_MESSAGE.SET_NAME('ONT', 'OE_VAL_PROJECT_REQD');
4917: OE_MSG_PUB.add;
4918: END IF;
4919:
4920: -- Added Code for Enhanced Project Validation and Controls.
4988: (p_line_rec.project_id,
4989: p_line_rec.ship_from_org_id) IS NULL THEN
4990:
4991: l_return_status := FND_API.G_RET_STS_ERROR;
4992: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_SHIP_FROM_PROJ');
4993: OE_MSG_PUB.add;
4994: END IF;
4995:
4996: END IF;
4998: IF (p_line_rec.task_id IS NOT NULL
4999: AND p_line_rec.project_id IS NULL) THEN
5000:
5001: l_return_status := FND_API.G_RET_STS_ERROR;
5002: FND_MESSAGE.SET_NAME('ONT', 'OE_VAL_PROJECT_REQD');
5003: OE_MSG_PUB.add;
5004:
5005: ELSIF (p_line_rec.task_id is NOT NULL
5006: AND p_line_rec.project_id IS NOT NULL) THEN
5010: p_line_rec.task_id) THEN
5011:
5012: l_return_status := FND_API.G_RET_STS_ERROR;
5013: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'TASK_ID');
5014: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
5015: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
5016: OE_Order_Util.Get_Attribute_Name('task_id'));
5017: OE_MSG_PUB.Add;
5018: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
5011:
5012: l_return_status := FND_API.G_RET_STS_ERROR;
5013: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'TASK_ID');
5014: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
5015: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
5016: OE_Order_Util.Get_Attribute_Name('task_id'));
5017: OE_MSG_PUB.Add;
5018: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
5019:
5026: p_line_rec.project_id,
5027: p_line_rec.ship_from_org_id) THEN
5028:
5029: l_return_status := FND_API.G_RET_STS_ERROR;
5030: FND_MESSAGE.SET_NAME('ONT', 'OE_VAL_TASK_REQD');
5031: OE_MSG_PUB.ADD;
5032:
5033: END IF;
5034:
5047: (p_line_rec.inventory_item_id,p_line_rec.ship_from_org_id) = 'Y'
5048: THEN
5049:
5050: l_return_status := FND_API.G_RET_STS_ERROR;
5051: fnd_message.set_name('ONT', 'OE_UEFF_NUMBER_REQD');
5052: OE_MSG_PUB.add;
5053: END IF;
5054:
5055: END IF;
5064: p_old_line_rec.end_item_unit_number))
5065: THEN
5066:
5067: l_return_status := FND_API.G_RET_STS_ERROR;
5068: fnd_message.set_name('ONT', 'OE_PJM_NOT_INSTALLED');
5069: OE_MSG_PUB.add;
5070:
5071: END IF;
5072:
5088:
5089: IF (NOT OE_GLOBALS.EQUAL(p_line_rec.project_id,
5090: p_old_line_rec.project_id)) THEN
5091: l_return_status := FND_API.G_RET_STS_ERROR;
5092: FND_MESSAGE.SET_NAME('ONT', 'OE_VAL_PROJ_UPD');
5093: OE_MSG_PUB.add;
5094: ELSIF (NOT OE_GLOBALS.EQUAL(p_line_rec.task_id,
5095: p_old_line_rec.task_id)) THEN
5096: l_return_status := FND_API.G_RET_STS_ERROR;
5093: OE_MSG_PUB.add;
5094: ELSIF (NOT OE_GLOBALS.EQUAL(p_line_rec.task_id,
5095: p_old_line_rec.task_id)) THEN
5096: l_return_status := FND_API.G_RET_STS_ERROR;
5097: FND_MESSAGE.SET_NAME('ONT', 'OE_VAL_TASK_UPD');
5098: OE_MSG_PUB.add;
5099: END IF;
5100:
5101: END IF;
5129: , p_line_rec.operation /*Bug 1805985 add*/
5130: )
5131: THEN
5132: l_return_status := FND_API.G_RET_STS_ERROR;
5133: fnd_message.set_name('ONT', 'OE_ITEM_VALIDATION_FAILED');
5134: OE_MSG_PUB.add;
5135: END IF;
5136:
5137: END IF;
5147: OR p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_MODEL )) then
5148:
5149: IF NOT OE_ITORD_UTIL.Validate_Item_Orderability(p_line_rec) then
5150: l_return_status := FND_API.G_RET_STS_ERROR;
5151: fnd_message.set_name('ONT', 'OE_ITORD_VALIDATION_FAILED');
5152: fnd_message.set_token('ITEM',OE_ITORD_UTIL.get_item_name(p_line_rec.inventory_item_id));
5153: fnd_message.set_token('CATEGORY',OE_ITORD_UTIL.get_item_category_name(p_line_rec.inventory_item_id));
5154: OE_MSG_PUB.add;
5155: END IF;
5148:
5149: IF NOT OE_ITORD_UTIL.Validate_Item_Orderability(p_line_rec) then
5150: l_return_status := FND_API.G_RET_STS_ERROR;
5151: fnd_message.set_name('ONT', 'OE_ITORD_VALIDATION_FAILED');
5152: fnd_message.set_token('ITEM',OE_ITORD_UTIL.get_item_name(p_line_rec.inventory_item_id));
5153: fnd_message.set_token('CATEGORY',OE_ITORD_UTIL.get_item_category_name(p_line_rec.inventory_item_id));
5154: OE_MSG_PUB.add;
5155: END IF;
5156: END IF;
5149: IF NOT OE_ITORD_UTIL.Validate_Item_Orderability(p_line_rec) then
5150: l_return_status := FND_API.G_RET_STS_ERROR;
5151: fnd_message.set_name('ONT', 'OE_ITORD_VALIDATION_FAILED');
5152: fnd_message.set_token('ITEM',OE_ITORD_UTIL.get_item_name(p_line_rec.inventory_item_id));
5153: fnd_message.set_token('CATEGORY',OE_ITORD_UTIL.get_item_category_name(p_line_rec.inventory_item_id));
5154: OE_MSG_PUB.add;
5155: END IF;
5156: END IF;
5157:
5172: , p_line_rec.inventory_item_id
5173: )
5174: THEN
5175: l_return_status := FND_API.G_RET_STS_ERROR;
5176: fnd_message.set_name('ONT', 'OE_RETURN_ITEM_MISMATCH_REJECT');
5177: OE_MSG_PUB.add;
5178: END IF;
5179: END IF;
5180: IF l_debug_level > 0 then
5191: ( p_line_rec.reference_line_id
5192: )
5193: THEN
5194: l_return_status := FND_API.G_RET_STS_ERROR;
5195: fnd_message.set_name('ONT', 'OE_UNFULFILLED_LINE_REJECT');
5196: OE_MSG_PUB.add;
5197: END IF;
5198:
5199: END IF;
5274: p_line_rec.cancelled_flag <> 'Y' and
5275: NVL(p_line_rec.ordered_quantity,1) <> 1)
5276: THEN
5277: l_return_status := FND_API.G_RET_STS_ERROR;
5278: fnd_message.set_name('ONT','OE_SERIAL_REFERENCED_RMA');
5279: OE_MSG_PUB.Add;
5280: END IF;
5281:
5282: IF l_debug_level > 0 then
5305: end if;
5306: ELSE
5307:
5308: l_return_status := FND_API.G_RET_STS_ERROR;
5309: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
5310: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
5311: OE_Order_Util.Get_Attribute_Name('ship_to_org_id'));
5312: OE_MSG_PUB.Add;
5313: END IF;
5306: ELSE
5307:
5308: l_return_status := FND_API.G_RET_STS_ERROR;
5309: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
5310: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
5311: OE_Order_Util.Get_Attribute_Name('ship_to_org_id'));
5312: OE_MSG_PUB.Add;
5313: END IF;
5314: END IF;
5357: OE_DEBUG_PUB.Add('Setting ship_to_contact_id to NULL',1);
5358: end if;
5359: ELSE
5360: l_return_status := FND_API.G_RET_STS_ERROR;
5361: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
5362: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
5363: OE_Order_Util.Get_Attribute_Name('ship_to_contact_id'));
5364: OE_MSG_PUB.Add;
5365: END IF;
5358: end if;
5359: ELSE
5360: l_return_status := FND_API.G_RET_STS_ERROR;
5361: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
5362: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
5363: OE_Order_Util.Get_Attribute_Name('ship_to_contact_id'));
5364: OE_MSG_PUB.Add;
5365: END IF;
5366: WHEN OTHERS THEN
5397: OE_DEBUG_PUB.Add('Setting deliver_to_org_id to NULL',1);
5398: end if;
5399: ELSE
5400: l_return_status := FND_API.G_RET_STS_ERROR;
5401: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
5402: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
5403: OE_Order_Util.Get_Attribute_Name('deliver_to_org_id'));
5404: OE_MSG_PUB.Add;
5405: END IF;
5398: end if;
5399: ELSE
5400: l_return_status := FND_API.G_RET_STS_ERROR;
5401: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
5402: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
5403: OE_Order_Util.Get_Attribute_Name('deliver_to_org_id'));
5404: OE_MSG_PUB.Add;
5405: END IF;
5406: END IF;
5451: OE_DEBUG_PUB.Add('Setting deliver_to_contact_id to NULL',1);
5452: end if;
5453: ELSE
5454: l_return_status := FND_API.G_RET_STS_ERROR;
5455: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
5456: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
5457: OE_Order_Util.Get_Attribute_Name('deliver_to_contact_id'));
5458: OE_MSG_PUB.Add;
5459: END IF;
5452: end if;
5453: ELSE
5454: l_return_status := FND_API.G_RET_STS_ERROR;
5455: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
5456: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
5457: OE_Order_Util.Get_Attribute_Name('deliver_to_contact_id'));
5458: OE_MSG_PUB.Add;
5459: END IF;
5460: WHEN OTHERS THEN
5543: OE_DEBUG_PUB.Add('Setting invoice_to_org_id to MISSING',1);
5544: end if;
5545: ELSE
5546: l_return_status := FND_API.G_RET_STS_ERROR;
5547: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
5548: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
5549: OE_Order_Util.Get_Attribute_Name('invoice_to_org_id'));
5550: OE_MSG_PUB.Add;
5551: END IF;
5544: end if;
5545: ELSE
5546: l_return_status := FND_API.G_RET_STS_ERROR;
5547: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
5548: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
5549: OE_Order_Util.Get_Attribute_Name('invoice_to_org_id'));
5550: OE_MSG_PUB.Add;
5551: END IF;
5552: WHEN OTHERS THEN
5604: OE_DEBUG_PUB.Add('Setting invoice_to_contact_id to NULL',1);
5605: end if;
5606: ELSE
5607: l_return_status := FND_API.G_RET_STS_ERROR;
5608: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
5609: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
5610: OE_Order_Util.Get_Attribute_Name('invoice_to_contact_id'));
5611: OE_MSG_PUB.Add;
5612: END IF;
5605: end if;
5606: ELSE
5607: l_return_status := FND_API.G_RET_STS_ERROR;
5608: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
5609: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
5610: OE_Order_Util.Get_Attribute_Name('invoice_to_contact_id'));
5611: OE_MSG_PUB.Add;
5612: END IF;
5613: WHEN OTHERS THEN
5680: EXCEPTION
5681:
5682: WHEN NO_DATA_FOUND THEN
5683: l_return_status := FND_API.G_RET_STS_ERROR;
5684: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
5685: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
5686: OE_Order_Util.Get_Attribute_Name('TAX_CODE'));
5687: OE_MSG_PUB.Add;
5688:
5681:
5682: WHEN NO_DATA_FOUND THEN
5683: l_return_status := FND_API.G_RET_STS_ERROR;
5684: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
5685: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
5686: OE_Order_Util.Get_Attribute_Name('TAX_CODE'));
5687: OE_MSG_PUB.Add;
5688:
5689: WHEN OTHERS THEN
5709: THEN
5710: l_return_status := FND_API.G_RET_STS_ERROR;
5711: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_ERROR)
5712: THEN
5713: fnd_message.set_name('ONT','OE_NO_TAX_EXEMPTION');
5714: OE_MSG_PUB.Add;
5715: END IF;
5716:
5717: END IF; -- If Tax handling is Standard
5727: THEN
5728: l_return_status := FND_API.G_RET_STS_ERROR;
5729: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_ERROR)
5730: THEN
5731: fnd_message.set_name('ONT','OE_TAX_EXEMPTION_REQUIRED');
5732: OE_MSG_PUB.Add;
5733: END IF;
5734: END IF;*/
5735:
5738: THEN
5739: l_return_status := FND_API.G_RET_STS_ERROR;
5740: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_ERROR)
5741: THEN
5742: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
5743: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
5744: OE_Order_Util.Get_Attribute_Name('TAX_EXEMPT_REASON_CODE'));
5745: OE_MSG_PUB.Add;
5746: END IF;
5739: l_return_status := FND_API.G_RET_STS_ERROR;
5740: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_ERROR)
5741: THEN
5742: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
5743: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
5744: OE_Order_Util.Get_Attribute_Name('TAX_EXEMPT_REASON_CODE'));
5745: OE_MSG_PUB.Add;
5746: END IF;
5747: END IF;
5755: THEN
5756: l_return_status := FND_API.G_RET_STS_ERROR;
5757: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_ERROR)
5758: THEN
5759: fnd_message.set_name('ONT','OE_TAX_EXEMPTION_NOT_ALLOWED');
5760: OE_MSG_PUB.Add;
5761: END IF;
5762:
5763: END IF; -- If Tax handling is Required
5886: l_return_status := FND_API.G_RET_STS_ERROR;
5887:
5888: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
5889: THEN
5890: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
5891: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
5892: OE_Order_Util.Get_Attribute_Name('TAX_EXEMPT_NUMBER'));
5893: OE_MSG_PUB.Add;
5894: END IF;
5887:
5888: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
5889: THEN
5890: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
5891: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
5892: OE_Order_Util.Get_Attribute_Name('TAX_EXEMPT_NUMBER'));
5893: OE_MSG_PUB.Add;
5894: END IF;
5895: END IF;
5957: IF l_debug_level > 0 then
5958: oe_debug_pub.add('uom other than primary uom is entered', 1);
5959: END IF;
5960:
5961: fnd_message.set_name('ONT','OE_INVALID_ORDER_QUANTITY_UOM');
5962: fnd_message.set_token('ITEM',nvl(p_line_rec.ordered_item,p_line_rec.inventory_item_id));
5963: fnd_message.set_token('UOM', l_uom);
5964: OE_MSG_PUB.Add;
5965: RAISE FND_API.G_EXC_ERROR;
5958: oe_debug_pub.add('uom other than primary uom is entered', 1);
5959: END IF;
5960:
5961: fnd_message.set_name('ONT','OE_INVALID_ORDER_QUANTITY_UOM');
5962: fnd_message.set_token('ITEM',nvl(p_line_rec.ordered_item,p_line_rec.inventory_item_id));
5963: fnd_message.set_token('UOM', l_uom);
5964: OE_MSG_PUB.Add;
5965: RAISE FND_API.G_EXC_ERROR;
5966: END IF;
5959: END IF;
5960:
5961: fnd_message.set_name('ONT','OE_INVALID_ORDER_QUANTITY_UOM');
5962: fnd_message.set_token('ITEM',nvl(p_line_rec.ordered_item,p_line_rec.inventory_item_id));
5963: fnd_message.set_token('UOM', l_uom);
5964: OE_MSG_PUB.Add;
5965: RAISE FND_API.G_EXC_ERROR;
5966: END IF;
5967: EXCEPTION
5986: IF l_uom_count = 0 THEN
5987: IF l_debug_level > 0 then
5988: oe_debug_pub.add('uom/item combination invalid',2);
5989: END IF;
5990: fnd_message.set_name('ONT', 'OE_INVALID_ITEM_UOM');
5991: OE_MSG_PUB.Add;
5992: RAISE FND_API.G_EXC_ERROR;
5993: END IF;
5994:
5997: IF NOT l_ret_status THEN
5998: IF l_debug_level > 0 then
5999: oe_debug_pub.add('uom/item combination invalid',2);
6000: END IF;
6001: fnd_message.set_name('ONT', 'OE_INVALID_ITEM_UOM');
6002: OE_MSG_PUB.Add;
6003: RAISE FND_API.G_EXC_ERROR;
6004: END IF;
6005: /*1544265*/
6044: IF NOT OE_GLOBALS.EQUAL(l_list_type_code,'PRL') THEN
6045: -- any price list with 'PRL' type should be allowed to
6046: -- be associated with any agreement according to bug 1386406.
6047: IF NOT OE_GLOBALS.EQUAL(l_price_list_id, p_line_rec.price_list_id) THEN
6048: fnd_message.set_name('ONT', 'OE_INVALID_AGREEMENT_PLIST');
6049: fnd_message.set_Token('AGREEMENT_NAME', l_agreement_name);
6050: BEGIN
6051: SELECT name
6052: INTO l_price_list_name
6045: -- any price list with 'PRL' type should be allowed to
6046: -- be associated with any agreement according to bug 1386406.
6047: IF NOT OE_GLOBALS.EQUAL(l_price_list_id, p_line_rec.price_list_id) THEN
6048: fnd_message.set_name('ONT', 'OE_INVALID_AGREEMENT_PLIST');
6049: fnd_message.set_Token('AGREEMENT_NAME', l_agreement_name);
6050: BEGIN
6051: SELECT name
6052: INTO l_price_list_name
6053: FROM qp_List_headers_vl
6058:
6059: Exception when no_data_found then
6060: l_price_list_name := p_line_rec.price_list_id;
6061: END;
6062: fnd_message.set_Token('PRICE_LIST1', l_price_list_name);
6063: BEGIN
6064:
6065: SELECT name
6066: INTO l_price_list_name
6072: EXCEPTION
6073: WHEN NO_DATA_FOUND THEN
6074: l_price_list_name := l_price_list_id;
6075: END;
6076: fnd_message.set_Token('PRICE_LIST2', l_price_list_name);
6077: OE_MSG_PUB.Add;
6078: IF l_debug_level > 0 then
6079: oe_debug_pub.add('Invalid Agreement +price_list_id combination',2);
6080: END IF;
6086: -- modified by lkxu, to check for customer relationships.
6087: IF l_sold_to_org IS NOT NULL AND l_sold_to_org <> -1
6088: AND NOT OE_GLOBALS.EQUAL(l_sold_to_org,p_line_rec.sold_to_org_id) THEN
6089: IF nvl(lcustomer_relations,'N') = 'N' THEN
6090: fnd_message.set_name('ONT', 'OE_INVALID_AGREEMENT');
6091: fnd_message.set_Token('AGREEMENT_ID', p_line_rec.agreement_id);
6092: fnd_message.set_Token('AGREEMENT_NAME', l_agreement_name);
6093: fnd_message.set_Token('CUSTOMER_ID', p_line_rec.sold_to_org_id);
6094: OE_MSG_PUB.Add;
6087: IF l_sold_to_org IS NOT NULL AND l_sold_to_org <> -1
6088: AND NOT OE_GLOBALS.EQUAL(l_sold_to_org,p_line_rec.sold_to_org_id) THEN
6089: IF nvl(lcustomer_relations,'N') = 'N' THEN
6090: fnd_message.set_name('ONT', 'OE_INVALID_AGREEMENT');
6091: fnd_message.set_Token('AGREEMENT_ID', p_line_rec.agreement_id);
6092: fnd_message.set_Token('AGREEMENT_NAME', l_agreement_name);
6093: fnd_message.set_Token('CUSTOMER_ID', p_line_rec.sold_to_org_id);
6094: OE_MSG_PUB.Add;
6095: IF l_debug_level > 0 then
6088: AND NOT OE_GLOBALS.EQUAL(l_sold_to_org,p_line_rec.sold_to_org_id) THEN
6089: IF nvl(lcustomer_relations,'N') = 'N' THEN
6090: fnd_message.set_name('ONT', 'OE_INVALID_AGREEMENT');
6091: fnd_message.set_Token('AGREEMENT_ID', p_line_rec.agreement_id);
6092: fnd_message.set_Token('AGREEMENT_NAME', l_agreement_name);
6093: fnd_message.set_Token('CUSTOMER_ID', p_line_rec.sold_to_org_id);
6094: OE_MSG_PUB.Add;
6095: IF l_debug_level > 0 then
6096: oe_debug_pub.add('Invalid Agreement +sold_org_id combination',2);
6089: IF nvl(lcustomer_relations,'N') = 'N' THEN
6090: fnd_message.set_name('ONT', 'OE_INVALID_AGREEMENT');
6091: fnd_message.set_Token('AGREEMENT_ID', p_line_rec.agreement_id);
6092: fnd_message.set_Token('AGREEMENT_NAME', l_agreement_name);
6093: fnd_message.set_Token('CUSTOMER_ID', p_line_rec.sold_to_org_id);
6094: OE_MSG_PUB.Add;
6095: IF l_debug_level > 0 then
6096: oe_debug_pub.add('Invalid Agreement +sold_org_id combination',2);
6097: END IF;
6111: );
6112:
6113: EXCEPTION
6114: WHEN NO_DATA_FOUND THEN
6115: fnd_message.set_name('ONT', 'OE_INVALID_AGREEMENT');
6116: fnd_message.set_Token('AGREEMENT_ID', p_line_rec.agreement_id);
6117: fnd_message.set_Token('AGREEMENT_NAME', l_agreement_name);
6118: fnd_message.set_Token('CUSTOMER_ID', p_line_rec.sold_to_org_id);
6119: OE_MSG_PUB.Add;
6112:
6113: EXCEPTION
6114: WHEN NO_DATA_FOUND THEN
6115: fnd_message.set_name('ONT', 'OE_INVALID_AGREEMENT');
6116: fnd_message.set_Token('AGREEMENT_ID', p_line_rec.agreement_id);
6117: fnd_message.set_Token('AGREEMENT_NAME', l_agreement_name);
6118: fnd_message.set_Token('CUSTOMER_ID', p_line_rec.sold_to_org_id);
6119: OE_MSG_PUB.Add;
6120: IF l_debug_level > 0 then
6113: EXCEPTION
6114: WHEN NO_DATA_FOUND THEN
6115: fnd_message.set_name('ONT', 'OE_INVALID_AGREEMENT');
6116: fnd_message.set_Token('AGREEMENT_ID', p_line_rec.agreement_id);
6117: fnd_message.set_Token('AGREEMENT_NAME', l_agreement_name);
6118: fnd_message.set_Token('CUSTOMER_ID', p_line_rec.sold_to_org_id);
6119: OE_MSG_PUB.Add;
6120: IF l_debug_level > 0 then
6121: oe_debug_pub.add('Invalid Agreement +sold_org_id combination',2);
6114: WHEN NO_DATA_FOUND THEN
6115: fnd_message.set_name('ONT', 'OE_INVALID_AGREEMENT');
6116: fnd_message.set_Token('AGREEMENT_ID', p_line_rec.agreement_id);
6117: fnd_message.set_Token('AGREEMENT_NAME', l_agreement_name);
6118: fnd_message.set_Token('CUSTOMER_ID', p_line_rec.sold_to_org_id);
6119: OE_MSG_PUB.Add;
6120: IF l_debug_level > 0 then
6121: oe_debug_pub.add('Invalid Agreement +sold_org_id combination',2);
6122: END IF;
6127:
6128:
6129: EXCEPTION
6130: WHEN NO_DATA_FOUND THEN
6131: fnd_message.set_name('ONT', 'OE_INVALID_AGREEMENT');
6132: fnd_message.set_Token('AGREEMENT_ID', p_line_rec.agreement_id);
6133: fnd_message.set_Token('AGREEMENT_NAME', l_agreement_name);
6134: fnd_message.set_Token('CUSTOMER_ID', l_sold_to_org);
6135: OE_MSG_PUB.Add;
6128:
6129: EXCEPTION
6130: WHEN NO_DATA_FOUND THEN
6131: fnd_message.set_name('ONT', 'OE_INVALID_AGREEMENT');
6132: fnd_message.set_Token('AGREEMENT_ID', p_line_rec.agreement_id);
6133: fnd_message.set_Token('AGREEMENT_NAME', l_agreement_name);
6134: fnd_message.set_Token('CUSTOMER_ID', l_sold_to_org);
6135: OE_MSG_PUB.Add;
6136: IF l_debug_level > 0 then
6129: EXCEPTION
6130: WHEN NO_DATA_FOUND THEN
6131: fnd_message.set_name('ONT', 'OE_INVALID_AGREEMENT');
6132: fnd_message.set_Token('AGREEMENT_ID', p_line_rec.agreement_id);
6133: fnd_message.set_Token('AGREEMENT_NAME', l_agreement_name);
6134: fnd_message.set_Token('CUSTOMER_ID', l_sold_to_org);
6135: OE_MSG_PUB.Add;
6136: IF l_debug_level > 0 then
6137: oe_debug_pub.add('Invalid Agreement +sold_org_id combination',2);
6130: WHEN NO_DATA_FOUND THEN
6131: fnd_message.set_name('ONT', 'OE_INVALID_AGREEMENT');
6132: fnd_message.set_Token('AGREEMENT_ID', p_line_rec.agreement_id);
6133: fnd_message.set_Token('AGREEMENT_NAME', l_agreement_name);
6134: fnd_message.set_Token('CUSTOMER_ID', l_sold_to_org);
6135: OE_MSG_PUB.Add;
6136: IF l_debug_level > 0 then
6137: oe_debug_pub.add('Invalid Agreement +sold_org_id combination',2);
6138: END IF;
6172: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN
6173: --
6174: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'PRICE_LIST_ID');
6175:
6176: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
6177: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
6178: OE_Order_Util.Get_Attribute_Name('price_list_id'));
6179: OE_MSG_PUB.Add;
6180: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
6173: --
6174: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'PRICE_LIST_ID');
6175:
6176: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
6177: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
6178: OE_Order_Util.Get_Attribute_Name('price_list_id'));
6179: OE_MSG_PUB.Add;
6180: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
6181: --
6205: G_REDEFAULT_MISSING := 'Y';
6206: ELSE
6207:
6208: --
6209: FND_MESSAGE.SET_NAME('ONT','OE_CURRENCY_MISMATCH');
6210: FND_MESSAGE.SET_TOKEN('LINE_CURR_CODE', l_currency_code);
6211: FND_MESSAGE.SET_TOKEN('PRICE_LIST_NAME', l_price_list_name);
6212: FND_MESSAGE.SET_TOKEN('HEADER_CURR_CODE', l_hdr_currency_code);
6213: OE_MSG_PUB.ADD;
6206: ELSE
6207:
6208: --
6209: FND_MESSAGE.SET_NAME('ONT','OE_CURRENCY_MISMATCH');
6210: FND_MESSAGE.SET_TOKEN('LINE_CURR_CODE', l_currency_code);
6211: FND_MESSAGE.SET_TOKEN('PRICE_LIST_NAME', l_price_list_name);
6212: FND_MESSAGE.SET_TOKEN('HEADER_CURR_CODE', l_hdr_currency_code);
6213: OE_MSG_PUB.ADD;
6214: --
6207:
6208: --
6209: FND_MESSAGE.SET_NAME('ONT','OE_CURRENCY_MISMATCH');
6210: FND_MESSAGE.SET_TOKEN('LINE_CURR_CODE', l_currency_code);
6211: FND_MESSAGE.SET_TOKEN('PRICE_LIST_NAME', l_price_list_name);
6212: FND_MESSAGE.SET_TOKEN('HEADER_CURR_CODE', l_hdr_currency_code);
6213: OE_MSG_PUB.ADD;
6214: --
6215: RAISE FND_API.G_EXC_ERROR;
6208: --
6209: FND_MESSAGE.SET_NAME('ONT','OE_CURRENCY_MISMATCH');
6210: FND_MESSAGE.SET_TOKEN('LINE_CURR_CODE', l_currency_code);
6211: FND_MESSAGE.SET_TOKEN('PRICE_LIST_NAME', l_price_list_name);
6212: FND_MESSAGE.SET_TOKEN('HEADER_CURR_CODE', l_hdr_currency_code);
6213: OE_MSG_PUB.ADD;
6214: --
6215: RAISE FND_API.G_EXC_ERROR;
6216: --
6311: END IF;
6312:
6313: EXCEPTION
6314: WHEN NO_DATA_FOUND THEN
6315: fnd_message.set_name('ONT', 'OE_INVALID_NONAGR_PLIST');
6316: fnd_message.set_Token('PRICE_LIST1', p_line_rec.price_list_id);
6317: fnd_message.set_Token('PRICING_DATE', p_line_rec.pricing_date);
6318: OE_MSG_PUB.Add;
6319: IF l_debug_level > 0 then
6312:
6313: EXCEPTION
6314: WHEN NO_DATA_FOUND THEN
6315: fnd_message.set_name('ONT', 'OE_INVALID_NONAGR_PLIST');
6316: fnd_message.set_Token('PRICE_LIST1', p_line_rec.price_list_id);
6317: fnd_message.set_Token('PRICING_DATE', p_line_rec.pricing_date);
6318: OE_MSG_PUB.Add;
6319: IF l_debug_level > 0 then
6320: oe_debug_pub.add('Invalid non agreement price list ',2);
6313: EXCEPTION
6314: WHEN NO_DATA_FOUND THEN
6315: fnd_message.set_name('ONT', 'OE_INVALID_NONAGR_PLIST');
6316: fnd_message.set_Token('PRICE_LIST1', p_line_rec.price_list_id);
6317: fnd_message.set_Token('PRICING_DATE', p_line_rec.pricing_date);
6318: OE_MSG_PUB.Add;
6319: IF l_debug_level > 0 then
6320: oe_debug_pub.add('Invalid non agreement price list ',2);
6321: END IF;
6351: IF (NOT OE_GLOBALS.EQUAL(p_line_rec.line_number,
6352: p_old_line_rec.line_number)) THEN
6353:
6354: l_return_status := FND_API.G_RET_STS_ERROR;
6355: fnd_message.set_name('ONT', 'OE_LINE_NUMBER_UPD');
6356: OE_MSG_PUB.add;
6357:
6358: END IF;
6359: END IF;
6394: IF l_debug_level > 0 then
6395: oe_debug_pub.add('class/option qty changed to 0', 1);
6396: END IF;
6397: l_return_status := FND_API.G_RET_STS_ERROR;
6398: FND_MESSAGE.SET_NAME('ONT', 'OE_CONFIG_NO_ZERO_QTY');
6399: oe_msg_pub.add;
6400: END IF;
6401:
6402: l_option_count := 0;
6419: IF l_debug_level > 0 then
6420: oe_debug_pub.add('models qty changed to 0, no cancellation', 1);
6421: END IF;
6422: l_return_status := FND_API.G_RET_STS_ERROR;
6423: FND_Message.Set_Name('ONT', 'OE_CONFIG_NO_ZERO_QTY');
6424: oe_msg_pub.add;
6425: END IF;
6426: END IF;
6427: */
6442: IF l_debug_level > 0 then
6443: oe_debug_pub.add('Ordered Qty cannot be greater than 1 for OTA lines', 1);
6444: END IF;
6445: l_return_status := FND_API.G_RET_STS_ERROR;
6446: FND_Message.Set_Name('ONT', 'OE_OTA_INVALID_QTY');
6447: oe_msg_pub.add;
6448: END IF;
6449:
6450: /* End of validation for OTA */
6470: (p_line_rec.cust_po_number
6471: ,p_line_rec.sold_to_org_id
6472: ,p_line_rec.header_id )
6473: THEN
6474: FND_MESSAGE.SET_NAME('ONT','OE_VAL_DUP_PO_NUMBER');
6475: OE_MSG_PUB.ADD;
6476: END IF;
6477:
6478: END IF;
6504: AND trunc(nvl(END_DATE_ACTIVE,add_months(sysdate,+10000)));
6505:
6506: EXCEPTION
6507: WHEN NO_DATA_FOUND THEN
6508: fnd_message.set_name('ONT', 'ONT_INVALID_AGR');
6509: fnd_message.set_Token('PRICING_DATE', p_line_rec.pricing_date);
6510: OE_MSG_PUB.Add;
6511: IF l_debug_level > 0 then
6512: oe_debug_pub.add('Invalid Agreement',2);
6505:
6506: EXCEPTION
6507: WHEN NO_DATA_FOUND THEN
6508: fnd_message.set_name('ONT', 'ONT_INVALID_AGR');
6509: fnd_message.set_Token('PRICING_DATE', p_line_rec.pricing_date);
6510: OE_MSG_PUB.Add;
6511: IF l_debug_level > 0 then
6512: oe_debug_pub.add('Invalid Agreement',2);
6513: END IF;
6527:
6528: IF (p_line_rec.service_end_date < p_line_rec.service_start_date) -- 2992944
6529: THEN
6530: l_return_status := FND_API.G_RET_STS_ERROR;
6531: fnd_message.set_name('ONT','OE_SERV_END_DATE');
6532: OE_MSG_PUB.Add;
6533: END IF;
6534:
6535: END IF;
6578: IF l_debug_level > 0 then
6579: oe_debug_pub.add('Ship tolerances can not be specified on PTOs',3);
6580: END IF;
6581: l_return_status := FND_API.G_RET_STS_ERROR;
6582: fnd_message.set_name('ONT','OE_NO_TOL_FOR_PTO');
6583: OE_MSG_PUB.Add;
6584:
6585: END IF;
6586: IF l_debug_level > 0 then
6596: IF l_debug_level > 0 then
6597: oe_debug_pub.add('child line of model with null qty', 3);
6598: END IF;
6599: l_return_status := FND_API.G_RET_STS_ERROR;
6600: fnd_message.set_name('ONT','OE_CONFIG_NULL_QUANTITY');
6601: fnd_message.set_Token('ITEM', nvl(p_line_rec.ordered_item,p_line_rec.inventory_item_id));
6602: OE_MSG_PUB.Add;
6603:
6604: END IF;
6597: oe_debug_pub.add('child line of model with null qty', 3);
6598: END IF;
6599: l_return_status := FND_API.G_RET_STS_ERROR;
6600: fnd_message.set_name('ONT','OE_CONFIG_NULL_QUANTITY');
6601: fnd_message.set_Token('ITEM', nvl(p_line_rec.ordered_item,p_line_rec.inventory_item_id));
6602: OE_MSG_PUB.Add;
6603:
6604: END IF;
6605:
6628: p_line_rec.schedule_action_code IS NULL THEN
6629:
6630: -- Must have some scheduling action when you set the Override
6631: -- ATP Flag
6632: FND_MESSAGE.SET_NAME('ONT','OE_SCH_OVER_ATP_NO_SCH_ACT');
6633: OE_MSG_PUB.Add;
6634: IF l_debug_level > 0 then
6635: Oe_debug_pub.add('Missing Schedule Action',1);
6636: END IF;
6642: p_line_rec.source_type_code = OE_GLOBALS.G_SOURCE_EXTERNAL) THEN
6643:
6644: -- Override ATP flag cannot be set for Service, Return,
6645: -- and Drop Ship Lines.
6646: FND_MESSAGE.SET_NAME('ONT', 'OE_SCH_OVER_ATP_INVLD_LINE');
6647: OE_MSG_PUB.Add;
6648: IF l_debug_level > 0 then
6649: Oe_debug_pub.add('Override ATP cannot be set for Service, Return and
6650: Drop Ship lines',1);
6657: ELSE
6658:
6659: IF p_line_rec.override_atp_date_code IS NOT NULL THEN
6660:
6661: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
6662: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Override Atp');
6663: OE_MSG_PUB.Add;
6664: l_return_status := FND_API.G_RET_STS_ERROR;
6665: IF l_debug_level > 0 then
6658:
6659: IF p_line_rec.override_atp_date_code IS NOT NULL THEN
6660:
6661: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
6662: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Override Atp');
6663: OE_MSG_PUB.Add;
6664: l_return_status := FND_API.G_RET_STS_ERROR;
6665: IF l_debug_level > 0 then
6666: Oe_debug_pub.add('Override ATP cannot be set prior to pack-I' ||
6685: OR p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_SERVICE
6686: OR p_line_rec.line_category_code = 'RETURN'
6687: OR p_line_rec.open_flag = 'N' THEN
6688:
6689: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_FIRM_OPR');
6690: OE_MSG_PUB.Add;
6691: l_return_status := FND_API.G_RET_STS_ERROR;
6692:
6693: END IF;
6725: if l_debug_level > 0 then
6726: OE_DEBUG_PUB.Add('Blankets are only available in Pack I or greater',1);
6727: end if;
6728: l_return_status := FND_API.G_RET_STS_ERROR;
6729: FND_MESSAGE.Set_Name('ONT','OE_BLANKET_INVALID_VERSION');
6730: OE_MSG_PUB.Add;
6731: END IF;
6732:
6733: ELSE
6846: PO_CODE_RELEASE_GRP.PRC_11i_Family_Pack_J AND
6847: OE_CODE_CONTROL.Code_Release_Level < '110510') THEN
6848:
6849:
6850: Fnd_Message.Set_Name('ONT','ONT_DS_PO_CHANGE_REQD');
6851:
6852: l_ds_req := RTRIM(p_line_rec.line_number || '.' ||
6853: p_line_rec.shipment_number || '.' ||
6854: p_line_rec.option_number || '.' ||
6855: p_line_rec.component_number || '.' ||
6856: p_line_rec.service_number, '.');
6857:
6858:
6859: FND_Message.Set_Token('LINE_NUM', l_ds_req);
6860:
6861: IF l_debug_level > 0 THEN
6862: oe_debug_pub.add('dropship line - message reqd', 1);
6863: END IF;
6867: INTO l_sold_to_org
6868: FROM po_requisition_headers_all
6869: WHERE requisition_header_id = l_req_header_id;
6870:
6871: FND_Message.Set_Token('REQ_NUM', l_sold_to_org);
6872: FND_Message.Set_Token('REQ_STS', nvl(l_req_status, '-'));
6873:
6874: EXCEPTION
6875: WHEN OTHERS THEN
6868: FROM po_requisition_headers_all
6869: WHERE requisition_header_id = l_req_header_id;
6870:
6871: FND_Message.Set_Token('REQ_NUM', l_sold_to_org);
6872: FND_Message.Set_Token('REQ_STS', nvl(l_req_status, '-'));
6873:
6874: EXCEPTION
6875: WHEN OTHERS THEN
6876: null;
6882: INTO l_sold_to_org
6883: FROM po_headers_all
6884: WHERE po_header_id = l_po_header_id;
6885:
6886: FND_Message.Set_Token('PO_NUM', l_sold_to_org);
6887: -- bug 4411054
6888: --FND_Message.Set_Token('PO_STS', nvl(l_po_status, '-'));
6889: FND_Message.Set_Token('PO_STS', nvl(l_closed_code, '-'));
6890:
6884: WHERE po_header_id = l_po_header_id;
6885:
6886: FND_Message.Set_Token('PO_NUM', l_sold_to_org);
6887: -- bug 4411054
6888: --FND_Message.Set_Token('PO_STS', nvl(l_po_status, '-'));
6889: FND_Message.Set_Token('PO_STS', nvl(l_closed_code, '-'));
6890:
6891: ELSE
6892:
6885:
6886: FND_Message.Set_Token('PO_NUM', l_sold_to_org);
6887: -- bug 4411054
6888: --FND_Message.Set_Token('PO_STS', nvl(l_po_status, '-'));
6889: FND_Message.Set_Token('PO_STS', nvl(l_closed_code, '-'));
6890:
6891: ELSE
6892:
6893: FND_Message.Set_Token('PO_NUM', '-');
6889: FND_Message.Set_Token('PO_STS', nvl(l_closed_code, '-'));
6890:
6891: ELSE
6892:
6893: FND_Message.Set_Token('PO_NUM', '-');
6894: FND_Message.Set_Token('PO_STS', 'NOT CREATED');
6895: IF l_debug_level > 0 THEN
6896: oe_debug_pub.add('no po', 4);
6897: END IF;
6890:
6891: ELSE
6892:
6893: FND_Message.Set_Token('PO_NUM', '-');
6894: FND_Message.Set_Token('PO_STS', 'NOT CREATED');
6895: IF l_debug_level > 0 THEN
6896: oe_debug_pub.add('no po', 4);
6897: END IF;
6898: END IF;
6957: OE_DEBUG_PUB.ADD('VALIDATION FOR IB_OWNER FAILED IN OEXLLINB.pls');
6958: OE_DEBUG_PUB.ADD('OLD LINE HAS INSTALL_BASE CAN NOT CHANGE IT');
6959: END IF;
6960: l_return_status := FND_API.G_RET_STS_ERROR;
6961: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
6962: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_OWNER'));
6963: OE_MSG_PUB.Add;
6964: END IF;
6965:
6958: OE_DEBUG_PUB.ADD('OLD LINE HAS INSTALL_BASE CAN NOT CHANGE IT');
6959: END IF;
6960: l_return_status := FND_API.G_RET_STS_ERROR;
6961: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
6962: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_OWNER'));
6963: OE_MSG_PUB.Add;
6964: END IF;
6965:
6966:
6971: OE_DEBUG_PUB.ADD('VALIDATION FOR IB_INSTALLED_AT_LOCATION FAILED IN OEXLLINB.pls');
6972: OE_DEBUG_PUB.ADD('OLD LINE HAS INSTALL_BASE CAN NOT CHANGE IT');
6973: END IF;
6974: l_return_status := FND_API.G_RET_STS_ERROR;
6975: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
6976: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_INSTALLED_AT_LOCATION'));
6977: OE_MSG_PUB.Add;
6978: END IF;
6979:
6972: OE_DEBUG_PUB.ADD('OLD LINE HAS INSTALL_BASE CAN NOT CHANGE IT');
6973: END IF;
6974: l_return_status := FND_API.G_RET_STS_ERROR;
6975: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
6976: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_INSTALLED_AT_LOCATION'));
6977: OE_MSG_PUB.Add;
6978: END IF;
6979:
6980:
6985: OE_DEBUG_PUB.ADD('VALIDATION FOR IB_CURRENT_LOCATION FAILED IN OEXLLINB.pls');
6986: OE_DEBUG_PUB.ADD('OLD LINE HAS INSTALL_BASE CAN NOT CHANGE IT');
6987: END IF;
6988: l_return_status := FND_API.G_RET_STS_ERROR;
6989: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
6990: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_CURRENT_LOCATION'));
6991: OE_MSG_PUB.Add;
6992: END IF;
6993:
6986: OE_DEBUG_PUB.ADD('OLD LINE HAS INSTALL_BASE CAN NOT CHANGE IT');
6987: END IF;
6988: l_return_status := FND_API.G_RET_STS_ERROR;
6989: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
6990: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_CURRENT_LOCATION'));
6991: OE_MSG_PUB.Add;
6992: END IF;
6993:
6994: -- END OF check.
7004: OE_DEBUG_PUB.ADD('VALIDATION FOR IB_OWNER FAILED IN OEXLLINB.pls');
7005: OE_DEBUG_PUB.ADD('TRYING TO UPDATE WITH INSTALL_BASE OLD LINE HAS SOME VALUE');
7006: END IF;
7007: l_return_status := FND_API.G_RET_STS_ERROR;
7008: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7009: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_OWNER'));
7010: OE_MSG_PUB.Add;
7011: END IF;
7012:
7005: OE_DEBUG_PUB.ADD('TRYING TO UPDATE WITH INSTALL_BASE OLD LINE HAS SOME VALUE');
7006: END IF;
7007: l_return_status := FND_API.G_RET_STS_ERROR;
7008: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7009: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_OWNER'));
7010: OE_MSG_PUB.Add;
7011: END IF;
7012:
7013: IF p_line_rec.ib_installed_at_location='INSTALL_BASE' and p_old_line_rec.ib_installed_at_location in ('BILL_TO','DELIVER_TO','END_CUSTOMER','SHIP_TO','SOLD_TO') THEN
7015: OE_DEBUG_PUB.ADD('VALIDATION FOR IB_INSTALLED_AT_LOCATION FAILED IN OEXLLINB.pls');
7016: OE_DEBUG_PUB.ADD('TRYING TO UPDATE WITH INSTALL_BASE OLD LINE HAS SOME VALUE');
7017: END IF;
7018: l_return_status := FND_API.G_RET_STS_ERROR;
7019: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7020: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_INSTALLED_AT_LOCATION'));
7021: OE_MSG_PUB.Add;
7022: END IF;
7023:
7016: OE_DEBUG_PUB.ADD('TRYING TO UPDATE WITH INSTALL_BASE OLD LINE HAS SOME VALUE');
7017: END IF;
7018: l_return_status := FND_API.G_RET_STS_ERROR;
7019: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7020: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_INSTALLED_AT_LOCATION'));
7021: OE_MSG_PUB.Add;
7022: END IF;
7023:
7024: IF p_line_rec.ib_current_location='INSTALL_BASE' and p_old_line_rec.ib_current_location in ('BILL_TO','DELIVER_TO','END_CUSTOMER','SHIP_TO','SOLD_TO') THEN
7026: OE_DEBUG_PUB.ADD('VALIDATION FOR IB_CURRENT_LOCATION FAILED IN OEXLLINB.pls');
7027: OE_DEBUG_PUB.ADD('TRYING TO UPDATE WITH INSTALL_BASE OLD LINE HAS SOME VALUE');
7028: END IF;
7029: l_return_status := FND_API.G_RET_STS_ERROR;
7030: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7031: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_CURRENT_LOCATION'));
7032: OE_MSG_PUB.Add;
7033: END IF;
7034:
7027: OE_DEBUG_PUB.ADD('TRYING TO UPDATE WITH INSTALL_BASE OLD LINE HAS SOME VALUE');
7028: END IF;
7029: l_return_status := FND_API.G_RET_STS_ERROR;
7030: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7031: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_CURRENT_LOCATION'));
7032: OE_MSG_PUB.Add;
7033: END IF;
7034:
7035: IF OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL >= '110510' THEN
7042: OE_DEBUG_PUB.ADD('Validation for IB_OWNER failed from OEXLLINB.pls');
7043: OE_DEBUG_PUB.ADD('THIS IS NOT A MODEL , CAN NOT HAVE INSTALL_BASE ');
7044: END IF;
7045: l_return_status := FND_API.G_RET_STS_ERROR;
7046: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7047: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_OWNER'));
7048: OE_MSG_PUB.Add;
7049:
7050: END IF;
7043: OE_DEBUG_PUB.ADD('THIS IS NOT A MODEL , CAN NOT HAVE INSTALL_BASE ');
7044: END IF;
7045: l_return_status := FND_API.G_RET_STS_ERROR;
7046: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7047: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_OWNER'));
7048: OE_MSG_PUB.Add;
7049:
7050: END IF;
7051:
7059: OE_DEBUG_PUB.ADD('Validation for IB_INSTALLED_AT_LOCATION failed from OEXLLINB.pls');
7060: OE_DEBUG_PUB.ADD('This is not a model , can not have INSTALL_BASE ');
7061: END IF;
7062: l_return_status := FND_API.G_RET_STS_ERROR;
7063: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7064: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_INSTALLED_AT_LOCATION'));
7065: OE_MSG_PUB.Add;
7066:
7067: END IF;
7060: OE_DEBUG_PUB.ADD('This is not a model , can not have INSTALL_BASE ');
7061: END IF;
7062: l_return_status := FND_API.G_RET_STS_ERROR;
7063: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7064: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_INSTALLED_AT_LOCATION'));
7065: OE_MSG_PUB.Add;
7066:
7067: END IF;
7068:
7077: OE_DEBUG_PUB.ADD('Validation for IB_CURRENT_LOCATION failed from OEXLLINB.pls');
7078: OE_DEBUG_PUB.ADD('THIS IS NOT A MODEL , CAN NOT HAVE INSTALL_BASE ');
7079: END IF;
7080: l_return_status := FND_API.G_RET_STS_ERROR;
7081: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7082: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_CURRENT_LOCATION'));
7083: OE_MSG_PUB.Add;
7084:
7085: END IF;
7078: OE_DEBUG_PUB.ADD('THIS IS NOT A MODEL , CAN NOT HAVE INSTALL_BASE ');
7079: END IF;
7080: l_return_status := FND_API.G_RET_STS_ERROR;
7081: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7082: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_CURRENT_LOCATION'));
7083: OE_MSG_PUB.Add;
7084:
7085: END IF;
7086:
7105: IF l_debug_level >0 THEN
7106: OE_DEBUG_PUB.ADD('end customer id is null but value is end_customer!');
7107: END IF;
7108: l_return_status := FND_API.G_RET_STS_ERROR;
7109: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7110: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_OWNER'));
7111: OE_MSG_PUB.Add;
7112:
7113: ELSIF p_line_rec.ib_owner = 'SOLD_TO' AND
7106: OE_DEBUG_PUB.ADD('end customer id is null but value is end_customer!');
7107: END IF;
7108: l_return_status := FND_API.G_RET_STS_ERROR;
7109: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7110: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_OWNER'));
7111: OE_MSG_PUB.Add;
7112:
7113: ELSIF p_line_rec.ib_owner = 'SOLD_TO' AND
7114: p_line_rec.sold_to_org_id is null
7116: IF l_debug_level >0 THEN
7117: OE_DEBUG_PUB.ADD(' sold_to_org_id is null but value is sold_to!');
7118: END IF;
7119: l_return_status := FND_API.G_RET_STS_ERROR;
7120: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7121: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_OWNER'));
7122: OE_MSG_PUB.Add;
7123: END IF;
7124: END IF;
7117: OE_DEBUG_PUB.ADD(' sold_to_org_id is null but value is sold_to!');
7118: END IF;
7119: l_return_status := FND_API.G_RET_STS_ERROR;
7120: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7121: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_OWNER'));
7122: OE_MSG_PUB.Add;
7123: END IF;
7124: END IF;
7125: IF l_debug_level > 0 then
7140: IF l_debug_level >0 THEN
7141: OE_DEBUG_PUB.ADD(' bill_to_org_id is null but value is bill_to!');
7142: END IF;
7143: l_return_status := FND_API.G_RET_STS_ERROR;
7144: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7145: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_INSTALLED_AT_LOCATION'));
7146: OE_MSG_PUB.Add;
7147:
7148: ELSIF p_line_rec.ib_installed_at_location = 'SHIP_TO' AND
7141: OE_DEBUG_PUB.ADD(' bill_to_org_id is null but value is bill_to!');
7142: END IF;
7143: l_return_status := FND_API.G_RET_STS_ERROR;
7144: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7145: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_INSTALLED_AT_LOCATION'));
7146: OE_MSG_PUB.Add;
7147:
7148: ELSIF p_line_rec.ib_installed_at_location = 'SHIP_TO' AND
7149: p_line_rec.ship_to_org_id is null
7151: IF l_debug_level >0 THEN
7152: OE_DEBUG_PUB.ADD(' ship_to_org_id is null but value is ship_to!');
7153: END IF;
7154: l_return_status := FND_API.G_RET_STS_ERROR;
7155: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7156: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_INSTALLED_AT_LOCATION'));
7157: OE_MSG_PUB.Add;
7158:
7159: ELSIF p_line_rec.ib_installed_at_location = 'DELIVER_TO' AND
7152: OE_DEBUG_PUB.ADD(' ship_to_org_id is null but value is ship_to!');
7153: END IF;
7154: l_return_status := FND_API.G_RET_STS_ERROR;
7155: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7156: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_INSTALLED_AT_LOCATION'));
7157: OE_MSG_PUB.Add;
7158:
7159: ELSIF p_line_rec.ib_installed_at_location = 'DELIVER_TO' AND
7160: p_line_rec.deliver_to_org_id is null
7162: IF l_debug_level >0 THEN
7163: OE_DEBUG_PUB.ADD(' deliver_to_org_id is null but value is deliver_to!');
7164: END IF;
7165: l_return_status := FND_API.G_RET_STS_ERROR;
7166: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7167: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_INSTALLED_AT_LOCATION'));
7168: OE_MSG_PUB.Add;
7169: ELSIF p_line_rec.ib_installed_at_location = 'END_CUSTOMER' AND
7170: p_line_rec.end_customer_site_use_id is null
7163: OE_DEBUG_PUB.ADD(' deliver_to_org_id is null but value is deliver_to!');
7164: END IF;
7165: l_return_status := FND_API.G_RET_STS_ERROR;
7166: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7167: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_INSTALLED_AT_LOCATION'));
7168: OE_MSG_PUB.Add;
7169: ELSIF p_line_rec.ib_installed_at_location = 'END_CUSTOMER' AND
7170: p_line_rec.end_customer_site_use_id is null
7171: THEN
7172: IF l_debug_level >0 THEN
7173: OE_DEBUG_PUB.ADD('end customer id is null but value is end_customer!');
7174: END IF;
7175: l_return_status := FND_API.G_RET_STS_ERROR;
7176: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7177: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_INSTALLED_AT_LOCATION'));
7178: OE_MSG_PUB.Add;
7179:
7180: -- no validation for SOLD_TO
7173: OE_DEBUG_PUB.ADD('end customer id is null but value is end_customer!');
7174: END IF;
7175: l_return_status := FND_API.G_RET_STS_ERROR;
7176: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7177: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_INSTALLED_AT_LOCATION'));
7178: OE_MSG_PUB.Add;
7179:
7180: -- no validation for SOLD_TO
7181: -- since no line level sold_to_site_use_id
7183: ELSIF p_line_rec.ib_installed_at_location = 'SOLD_TO'
7184: AND OE_Order_Cache.g_header_rec.sold_to_site_use_id is null
7185: THEN
7186: l_return_status := FND_API.G_RET_STS_ERROR;
7187: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7188: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_INSTALLED_AT_LOCATION'));
7189: OE_MSG_PUB.Add;
7190:
7191: END IF;
7184: AND OE_Order_Cache.g_header_rec.sold_to_site_use_id is null
7185: THEN
7186: l_return_status := FND_API.G_RET_STS_ERROR;
7187: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7188: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_INSTALLED_AT_LOCATION'));
7189: OE_MSG_PUB.Add;
7190:
7191: END IF;
7192: END IF;
7208: IF l_debug_level >0 THEN
7209: OE_DEBUG_PUB.ADD(' bill_to_org_id is null but value is bill_to!');
7210: END IF;
7211: l_return_status := FND_API.G_RET_STS_ERROR;
7212: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7213: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_CURRENT_LOCATION'));
7214: OE_MSG_PUB.Add;
7215:
7216: ELSIF p_line_rec.ib_current_location = 'SHIP_TO' AND
7209: OE_DEBUG_PUB.ADD(' bill_to_org_id is null but value is bill_to!');
7210: END IF;
7211: l_return_status := FND_API.G_RET_STS_ERROR;
7212: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7213: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_CURRENT_LOCATION'));
7214: OE_MSG_PUB.Add;
7215:
7216: ELSIF p_line_rec.ib_current_location = 'SHIP_TO' AND
7217: p_line_rec.ship_to_org_id is null
7219: IF l_debug_level >0 THEN
7220: OE_DEBUG_PUB.ADD(' ship_to_org_id is null but value is ship_to!');
7221: END IF;
7222: l_return_status := FND_API.G_RET_STS_ERROR;
7223: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7224: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_CURRENT_LOCATION'));
7225: OE_MSG_PUB.Add;
7226:
7227: ELSIF p_line_rec.ib_current_location = 'DELIVER_TO' AND
7220: OE_DEBUG_PUB.ADD(' ship_to_org_id is null but value is ship_to!');
7221: END IF;
7222: l_return_status := FND_API.G_RET_STS_ERROR;
7223: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7224: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_CURRENT_LOCATION'));
7225: OE_MSG_PUB.Add;
7226:
7227: ELSIF p_line_rec.ib_current_location = 'DELIVER_TO' AND
7228: p_line_rec.deliver_to_org_id is null
7227: ELSIF p_line_rec.ib_current_location = 'DELIVER_TO' AND
7228: p_line_rec.deliver_to_org_id is null
7229: THEN
7230: l_return_status := FND_API.G_RET_STS_ERROR;
7231: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7232: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_CURRENT_LOCATION'));
7233: OE_MSG_PUB.Add;
7234:
7235: ELSIF p_line_rec.ib_current_location = 'END_CUSTOMER' AND
7228: p_line_rec.deliver_to_org_id is null
7229: THEN
7230: l_return_status := FND_API.G_RET_STS_ERROR;
7231: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7232: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_CURRENT_LOCATION'));
7233: OE_MSG_PUB.Add;
7234:
7235: ELSIF p_line_rec.ib_current_location = 'END_CUSTOMER' AND
7236: p_line_rec.end_customer_site_use_id is null
7235: ELSIF p_line_rec.ib_current_location = 'END_CUSTOMER' AND
7236: p_line_rec.end_customer_site_use_id is null
7237: THEN
7238: l_return_status := FND_API.G_RET_STS_ERROR;
7239: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7240: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_CURRENT_LOCATION'));
7241: OE_MSG_PUB.Add;
7242:
7243: -- no validation for SOLD_TO
7236: p_line_rec.end_customer_site_use_id is null
7237: THEN
7238: l_return_status := FND_API.G_RET_STS_ERROR;
7239: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7240: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_CURRENT_LOCATION'));
7241: OE_MSG_PUB.Add;
7242:
7243: -- no validation for SOLD_TO
7244: -- since no line level sold_to_site_use_id
7246: ELSIF p_line_rec.ib_current_location = 'SOLD_TO'
7247: AND OE_Order_Cache.g_header_rec.sold_to_site_use_id is null
7248: THEN
7249: l_return_status := FND_API.G_RET_STS_ERROR;
7250: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7251: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_CURRENT_LOCATION'));
7252: OE_MSG_PUB.Add;
7253:
7254:
7247: AND OE_Order_Cache.g_header_rec.sold_to_site_use_id is null
7248: THEN
7249: l_return_status := FND_API.G_RET_STS_ERROR;
7250: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7251: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_CURRENT_LOCATION'));
7252: OE_MSG_PUB.Add;
7253:
7254:
7255: END IF;
7281: EXCEPTION
7282:
7283: WHEN NO_DATA_FOUND THEN
7284: l_return_status := FND_API.G_RET_STS_ERROR;
7285: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7286: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
7287: OE_Order_Util.Get_Attribute_Name('END_CUSTOMER_CONTACT_ID'));
7288: OE_MSG_PUB.Add;
7289:
7282:
7283: WHEN NO_DATA_FOUND THEN
7284: l_return_status := FND_API.G_RET_STS_ERROR;
7285: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7286: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
7287: OE_Order_Util.Get_Attribute_Name('END_CUSTOMER_CONTACT_ID'));
7288: OE_MSG_PUB.Add;
7289:
7290: WHEN OTHERS THEN
7328: EXCEPTION
7329:
7330: WHEN NO_DATA_FOUND THEN
7331: l_return_status := FND_API.G_RET_STS_ERROR;
7332: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7333: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
7334: OE_Order_Util.Get_Attribute_Name('END_CUSTOMER_SITE_USE_ID'));
7335: OE_MSG_PUB.Add;
7336:
7329:
7330: WHEN NO_DATA_FOUND THEN
7331: l_return_status := FND_API.G_RET_STS_ERROR;
7332: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7333: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
7334: OE_Order_Util.Get_Attribute_Name('END_CUSTOMER_SITE_USE_ID'));
7335: OE_MSG_PUB.Add;
7336:
7337: WHEN OTHERS THEN
7436: --WHERE mtl_msi.inventory_item_id = p_line_rec.inventory_item_id
7437: --AND mtl_msi.organization_id =
7438: -- OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID');
7439:
7440: FND_MESSAGE.SET_NAME('ONT','ONT_NO_RC_ALLOWED');
7441: --FND_MESSAGE.SET_TOKEN('ITEM',l_item_description);
7442: OE_MSG_PUB.Add;
7443: RAISE FND_API.G_EXC_ERROR;
7444: END IF;
7437: --AND mtl_msi.organization_id =
7438: -- OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID');
7439:
7440: FND_MESSAGE.SET_NAME('ONT','ONT_NO_RC_ALLOWED');
7441: --FND_MESSAGE.SET_TOKEN('ITEM',l_item_description);
7442: OE_MSG_PUB.Add;
7443: RAISE FND_API.G_EXC_ERROR;
7444: END IF;
7445: END IF; --operation CREATE
7453: OE_DEBUG_PUB.Add('Line Num:'||p_line_rec.line_number,2);
7454: OE_DEBUG_PUB.Add('ERR: Update of charge periodicity',3);
7455: END IF;
7456:
7457: FND_MESSAGE.SET_NAME('ONT','ONT_NO_UPDATE_ON_PERIODICITY');
7458: FND_MESSAGE.SET_TOKEN('LINE_NUM',p_line_rec.line_number);
7459: OE_MSG_PUB.Add;
7460: RAISE FND_API.G_EXC_ERROR;
7461:
7454: OE_DEBUG_PUB.Add('ERR: Update of charge periodicity',3);
7455: END IF;
7456:
7457: FND_MESSAGE.SET_NAME('ONT','ONT_NO_UPDATE_ON_PERIODICITY');
7458: FND_MESSAGE.SET_TOKEN('LINE_NUM',p_line_rec.line_number);
7459: OE_MSG_PUB.Add;
7460: RAISE FND_API.G_EXC_ERROR;
7461:
7462: END IF;
7463: ELSE --recurring charges system paramter is N
7464: IF l_debug_level > 0 THEN
7465: OE_DEBUG_PUB.Add('ERR: Recurring Charges SYS Param is disabled');
7466: END IF;
7467: FND_MESSAGE.SET_NAME('ONT','ONT_RECUR_CHARGES_NOT_ENABLED');
7468: OE_MSG_PUB.Add;
7469: RAISE FND_API.G_EXC_ERROR;
7470:
7471: END IF;
7483: then
7484:
7485: if p_line_rec.service_duration is not null and p_line_rec.service_duration <>FND_API.G_MISS_NUM then
7486: l_return_status := FND_API.G_RET_STS_ERROR;
7487: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7488: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
7489: OE_Order_UTIL.Get_Attribute_Name('SERVICE_DURATION'));
7490: OE_MSG_PUB.ADD;
7491: end if;
7484:
7485: if p_line_rec.service_duration is not null and p_line_rec.service_duration <>FND_API.G_MISS_NUM then
7486: l_return_status := FND_API.G_RET_STS_ERROR;
7487: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7488: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
7489: OE_Order_UTIL.Get_Attribute_Name('SERVICE_DURATION'));
7490: OE_MSG_PUB.ADD;
7491: end if;
7492:
7491: end if;
7492:
7493: if p_line_rec.service_period is not null and p_line_rec.service_period <>FND_API.G_MISS_CHAR then
7494: l_return_status := FND_API.G_RET_STS_ERROR;
7495: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7496: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
7497: OE_Order_UTIL.Get_Attribute_Name('SERVICE_PERIOD'));
7498: OE_MSG_PUB.ADD;
7499: end if;
7492:
7493: if p_line_rec.service_period is not null and p_line_rec.service_period <>FND_API.G_MISS_CHAR then
7494: l_return_status := FND_API.G_RET_STS_ERROR;
7495: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7496: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
7497: OE_Order_UTIL.Get_Attribute_Name('SERVICE_PERIOD'));
7498: OE_MSG_PUB.ADD;
7499: end if;
7500:
7499: end if;
7500:
7501: if p_line_rec.service_start_date is not null and p_line_rec.service_start_date <>FND_API.G_MISS_DATE then
7502: l_return_status := FND_API.G_RET_STS_ERROR;
7503: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7504: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
7505: OE_Order_UTIL.Get_Attribute_Name('SERVICE_START_DATE'));
7506: OE_MSG_PUB.ADD;
7507: end if;
7500:
7501: if p_line_rec.service_start_date is not null and p_line_rec.service_start_date <>FND_API.G_MISS_DATE then
7502: l_return_status := FND_API.G_RET_STS_ERROR;
7503: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7504: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
7505: OE_Order_UTIL.Get_Attribute_Name('SERVICE_START_DATE'));
7506: OE_MSG_PUB.ADD;
7507: end if;
7508:
7507: end if;
7508:
7509: if p_line_rec.service_end_date is not null and p_line_rec.service_end_date <>FND_API.G_MISS_DATE then
7510: l_return_status := FND_API.G_RET_STS_ERROR;
7511: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7512: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
7513: OE_Order_UTIL.Get_Attribute_Name('SERVICE_END_DATE'));
7514: OE_MSG_PUB.ADD;
7515: end if;
7508:
7509: if p_line_rec.service_end_date is not null and p_line_rec.service_end_date <>FND_API.G_MISS_DATE then
7510: l_return_status := FND_API.G_RET_STS_ERROR;
7511: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7512: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
7513: OE_Order_UTIL.Get_Attribute_Name('SERVICE_END_DATE'));
7514: OE_MSG_PUB.ADD;
7515: end if;
7516:
7522: -- webroot bug 6826344 added end
7523:
7524: if p_line_rec.service_txn_comments is not null and p_line_rec.service_txn_comments <>FND_API.G_MISS_CHAR then
7525: l_return_status := FND_API.G_RET_STS_ERROR;
7526: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7527: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
7528: OE_Order_UTIL.Get_Attribute_Name('SERVICE_TXN_COMMENTS'));
7529: OE_MSG_PUB.ADD;
7530: end if;
7523:
7524: if p_line_rec.service_txn_comments is not null and p_line_rec.service_txn_comments <>FND_API.G_MISS_CHAR then
7525: l_return_status := FND_API.G_RET_STS_ERROR;
7526: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7527: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
7528: OE_Order_UTIL.Get_Attribute_Name('SERVICE_TXN_COMMENTS'));
7529: OE_MSG_PUB.ADD;
7530: end if;
7531:
7530: end if;
7531:
7532: if p_line_rec.service_txn_reason_code is not null and p_line_rec.service_txn_reason_code <>FND_API.G_MISS_CHAR then
7533: l_return_status := FND_API.G_RET_STS_ERROR;
7534: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7535: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
7536: OE_Order_UTIL.Get_Attribute_Name('SERVICE_TXN_REASON_CODE'));
7537: OE_MSG_PUB.ADD;
7538: end if;
7531:
7532: if p_line_rec.service_txn_reason_code is not null and p_line_rec.service_txn_reason_code <>FND_API.G_MISS_CHAR then
7533: l_return_status := FND_API.G_RET_STS_ERROR;
7534: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7535: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
7536: OE_Order_UTIL.Get_Attribute_Name('SERVICE_TXN_REASON_CODE'));
7537: OE_MSG_PUB.ADD;
7538: end if;
7539:
7538: end if;
7539:
7540: if p_line_rec.service_coterminate_flag is not null and p_line_rec.service_coterminate_flag <>FND_API.G_MISS_CHAR then
7541: l_return_status := FND_API.G_RET_STS_ERROR;
7542: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7543: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
7544: OE_Order_UTIL.Get_Attribute_Name('SERVICE_COTERMINATE_FLAG'));
7545: OE_MSG_PUB.ADD;
7546: end if;
7539:
7540: if p_line_rec.service_coterminate_flag is not null and p_line_rec.service_coterminate_flag <>FND_API.G_MISS_CHAR then
7541: l_return_status := FND_API.G_RET_STS_ERROR;
7542: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7543: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
7544: OE_Order_UTIL.Get_Attribute_Name('SERVICE_COTERMINATE_FLAG'));
7545: OE_MSG_PUB.ADD;
7546: end if;
7547: end if;
7563: oe_debug_pub.add('Rule Type is :'||l_rule_type);
7564: END IF;
7565: IF l_rule_type = 'PP_DR_ALL' or l_rule_type = 'PP_DR_PP' THEN
7566: l_return_status := FND_API.G_RET_STS_ERROR;
7567: FND_MESSAGE.Set_Name('ONT','OE_INVALID_ATTRIBUTE');
7568: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
7569: OE_Order_Util.Get_Attribute_Name('ACCOUNTING_RULE_ID'));
7570: OE_MSG_PUB.ADD;
7571: END IF; --End of rule type
7564: END IF;
7565: IF l_rule_type = 'PP_DR_ALL' or l_rule_type = 'PP_DR_PP' THEN
7566: l_return_status := FND_API.G_RET_STS_ERROR;
7567: FND_MESSAGE.Set_Name('ONT','OE_INVALID_ATTRIBUTE');
7568: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
7569: OE_Order_Util.Get_Attribute_Name('ACCOUNTING_RULE_ID'));
7570: OE_MSG_PUB.ADD;
7571: END IF; --End of rule type
7572: END IF;--End of accounting type id is not null
7620: AND organization_id = p_line_rec.ship_from_org_id
7621: and rownum=1;
7622: END IF;
7623:
7624: fnd_message.set_name('ONT','OE_INVALID_ORDER_QUANTITY_UOM');
7625: fnd_message.set_token('ITEM',nvl(p_line_rec.ordered_item,p_line_rec.inventory_item_id));
7626: fnd_message.set_token('UOM', l_uom);
7627: l_return_status := FND_API.G_RET_STS_ERROR;
7628: OE_MSG_PUB.ADD;
7621: and rownum=1;
7622: END IF;
7623:
7624: fnd_message.set_name('ONT','OE_INVALID_ORDER_QUANTITY_UOM');
7625: fnd_message.set_token('ITEM',nvl(p_line_rec.ordered_item,p_line_rec.inventory_item_id));
7626: fnd_message.set_token('UOM', l_uom);
7627: l_return_status := FND_API.G_RET_STS_ERROR;
7628: OE_MSG_PUB.ADD;
7629: exception
7622: END IF;
7623:
7624: fnd_message.set_name('ONT','OE_INVALID_ORDER_QUANTITY_UOM');
7625: fnd_message.set_token('ITEM',nvl(p_line_rec.ordered_item,p_line_rec.inventory_item_id));
7626: fnd_message.set_token('UOM', l_uom);
7627: l_return_status := FND_API.G_RET_STS_ERROR;
7628: OE_MSG_PUB.ADD;
7629: exception
7630: when no_data_found then
8253: -- to change the schedule ship date.
8254:
8255: IF l_type_code = 'ARRIVAL' THEN
8256:
8257: FND_MESSAGE.SET_NAME('ONT','OE_SCH_INV_SHP_DATE');
8258: OE_MSG_PUB.Add;
8259:
8260: l_return_status := FND_API.G_RET_STS_ERROR;
8261:
8275: -- to change the schedule arrival date.
8276:
8277: IF nvl(l_type_code,'SHIP') = 'SHIP' THEN
8278:
8279: FND_MESSAGE.SET_NAME('ONT','OE_SCH_INV_ARR_DATE');
8280: OE_MSG_PUB.Add;
8281:
8282: l_return_status := FND_API.G_RET_STS_ERROR;
8283:
8938: p_old_line_rec.accepted_quantity <> FND_API.G_MISS_NUM AND
8939: p_old_line_rec.accepted_quantity <> p_x_line_rec.accepted_quantity
8940: THEN
8941: p_x_line_rec.accepted_quantity := p_old_line_rec.accepted_quantity;
8942: FND_MESSAGE.SET_NAME('ONT','ONT_CANNOT_UPDATE_ACCEPTANCE');
8943: OE_MSG_PUB.Add;
8944: END IF;
8945:
8946: IF p_old_line_rec.REVREC_SIGNATURE_DATE IS NOT NULL AND
8947: p_old_line_rec.REVREC_SIGNATURE_DATE <> FND_API.G_MISS_DATE AND
8948: p_old_line_rec.REVREC_SIGNATURE_DATE <> p_x_line_rec.REVREC_SIGNATURE_DATE
8949: THEN
8950: p_x_line_rec.REVREC_SIGNATURE_DATE := p_old_line_rec.REVREC_SIGNATURE_DATE;
8951: FND_MESSAGE.SET_NAME('ONT','ONT_CANNOT_UPDATE_ACCEPTANCE');
8952: OE_MSG_PUB.Add;
8953: END IF;
8954:
8955: IF p_old_line_rec.accepted_by IS NOT NULL AND
8956: p_old_line_rec.accepted_by <> FND_API.G_MISS_NUM AND
8957: p_old_line_rec.accepted_by <> p_x_line_rec.accepted_by
8958: THEN
8959: p_x_line_rec.accepted_by := p_old_line_rec.accepted_by;
8960: FND_MESSAGE.SET_NAME('ONT','ONT_CANNOT_UPDATE_ACCEPTANCE');
8961: OE_MSG_PUB.Add;
8962: END IF;
8963: --
8964:
9483: -- from the Process Order Call and if the Context field is required
9484: -- and context is not defaulted by the flex api.
9485:
9486: IF OE_OE_PRICING_AVAILABILITY.IS_PRICING_AVAILIBILITY = 'N' THEN
9487: FND_MESSAGE.SET_NAME('FND', 'ONT_CONTEXT_NOT_FOUND');
9488: OE_MSG_PUB.ADD;
9489: IF l_debug_level > 0 THEN
9490: oe_debug_pub.add('desc_flex Context Not set for OE_LINE_ATTRIBUTES DFF ') ;
9491: END IF;