[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:
378:
379: IF (WSH_INTEGRATION.Validate_Oe_Attributes(p_line_rec.order_source_id) = 'Y') THEN
380: IF p_line_rec.price_list_id IS NULL THEN
381: x_return_status := FND_API.G_RET_STS_ERROR;
382: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
383: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
384: OE_Order_UTIL.Get_Attribute_Name('PRICE_LIST_ID'));
385: OE_MSG_PUB.ADD;
386: END IF;
379: IF (WSH_INTEGRATION.Validate_Oe_Attributes(p_line_rec.order_source_id) = 'Y') THEN
380: IF p_line_rec.price_list_id IS NULL THEN
381: x_return_status := FND_API.G_RET_STS_ERROR;
382: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
383: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
384: OE_Order_UTIL.Get_Attribute_Name('PRICE_LIST_ID'));
385: OE_MSG_PUB.ADD;
386: END IF;
387:
387:
388:
389: IF p_line_rec.unit_list_price IS NULL THEN
390: x_return_status := FND_API.G_RET_STS_ERROR;
391: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
392: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
393: OE_Order_UTIL.Get_Attribute_Name('UNIT_LIST_PRICE'));
394: OE_MSG_PUB.ADD;
395: END IF;
388:
389: IF p_line_rec.unit_list_price IS NULL THEN
390: x_return_status := FND_API.G_RET_STS_ERROR;
391: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
392: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
393: OE_Order_UTIL.Get_Attribute_Name('UNIT_LIST_PRICE'));
394: OE_MSG_PUB.ADD;
395: END IF;
396:
395: END IF;
396:
397: IF p_line_rec.unit_selling_price IS NULL THEN
398: x_return_status := FND_API.G_RET_STS_ERROR;
399: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
400: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
401: OE_Order_UTIL.Get_Attribute_Name('UNIT_SELLING_PRICE'));
402: OE_MSG_PUB.ADD;
403: END IF;
396:
397: IF p_line_rec.unit_selling_price IS NULL THEN
398: x_return_status := FND_API.G_RET_STS_ERROR;
399: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
400: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
401: OE_Order_UTIL.Get_Attribute_Name('UNIT_SELLING_PRICE'));
402: OE_MSG_PUB.ADD;
403: END IF;
404: END IF;
415: IF p_line_rec.line_category_code <> OE_GLOBALS.G_RETURN_CATEGORY_CODE THEN
416:
417: IF p_line_rec.ship_to_org_id IS NULL THEN
418: x_return_status := FND_API.G_RET_STS_ERROR;
419: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
420: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
421: OE_Order_UTIL.Get_Attribute_Name('SHIP_TO_ORG_ID'));
422: OE_MSG_PUB.ADD;
423: END IF;
416:
417: IF p_line_rec.ship_to_org_id IS NULL THEN
418: x_return_status := FND_API.G_RET_STS_ERROR;
419: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
420: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
421: OE_Order_UTIL.Get_Attribute_Name('SHIP_TO_ORG_ID'));
422: OE_MSG_PUB.ADD;
423: END IF;
424:
423: END IF;
424:
425: IF p_line_rec.payment_term_id IS NULL THEN
426: x_return_status := FND_API.G_RET_STS_ERROR;
427: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
428: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
429: OE_Order_UTIL.Get_Attribute_Name('PAYMENT_TERM_ID'));
430: OE_MSG_PUB.ADD;
431: END IF;
424:
425: IF p_line_rec.payment_term_id IS NULL THEN
426: x_return_status := FND_API.G_RET_STS_ERROR;
427: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
428: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
429: OE_Order_UTIL.Get_Attribute_Name('PAYMENT_TERM_ID'));
430: OE_MSG_PUB.ADD;
431: END IF;
432:
446: END IF;
447: IF l_rule_type = 'ACC_DUR' THEN
448: IF p_line_rec.accounting_rule_duration IS NULL THEN
449: x_return_status := FND_API.G_RET_STS_ERROR;
450: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
451: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
452: OE_Order_UTIL.Get_Attribute_Name('ACCOUNTING_RULE_DURATION'));
453: OE_MSG_PUB.ADD;
454: END IF; -- end of accounting_rule_duration null
447: IF l_rule_type = 'ACC_DUR' THEN
448: IF p_line_rec.accounting_rule_duration IS NULL THEN
449: x_return_status := FND_API.G_RET_STS_ERROR;
450: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
451: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
452: OE_Order_UTIL.Get_Attribute_Name('ACCOUNTING_RULE_DURATION'));
453: OE_MSG_PUB.ADD;
454: END IF; -- end of accounting_rule_duration null
455: END IF; -- end of variable accounting rule type
462:
463: IF p_line_rec.service_start_date IS NULL THEN
464: oe_debug_pub.add(' inside new rule validation conditions service start date');
465: x_return_status := FND_API.G_RET_STS_ERROR;
466: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
467: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Accounting Rule Start Date' );
468: OE_MSG_PUB.ADD;
469: END IF;
470: IF p_line_rec.service_end_date IS NULL THEN
463: IF p_line_rec.service_start_date IS NULL THEN
464: oe_debug_pub.add(' inside new rule validation conditions service start date');
465: x_return_status := FND_API.G_RET_STS_ERROR;
466: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
467: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Accounting Rule Start Date' );
468: OE_MSG_PUB.ADD;
469: END IF;
470: IF p_line_rec.service_end_date IS NULL THEN
471: x_return_status := FND_API.G_RET_STS_ERROR;
468: OE_MSG_PUB.ADD;
469: END IF;
470: IF p_line_rec.service_end_date IS NULL THEN
471: x_return_status := FND_API.G_RET_STS_ERROR;
472: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
473: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Accounting Rule End Date' );
474: OE_MSG_PUB.ADD;
475: END IF;
476:
469: END IF;
470: IF p_line_rec.service_end_date IS NULL THEN
471: x_return_status := FND_API.G_RET_STS_ERROR;
472: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
473: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Accounting Rule End Date' );
474: OE_MSG_PUB.ADD;
475: END IF;
476:
477: END IF;
490: IF p_line_rec.line_category_code = OE_GLOBALS.G_RETURN_CATEGORY_CODE THEN
491:
492: IF p_line_rec.ship_from_org_id IS NULL THEN
493: x_return_status := FND_API.G_RET_STS_ERROR;
494: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_RETURN_ATTRIBUTE');
495: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
496: OE_Order_UTIL.Get_Attribute_Name('SHIP_FROM_ORG_ID'));
497: OE_MSG_PUB.ADD;
498: END IF;
491:
492: IF p_line_rec.ship_from_org_id IS NULL THEN
493: x_return_status := FND_API.G_RET_STS_ERROR;
494: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_RETURN_ATTRIBUTE');
495: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
496: OE_Order_UTIL.Get_Attribute_Name('SHIP_FROM_ORG_ID'));
497: OE_MSG_PUB.ADD;
498: END IF;
499:
498: END IF;
499:
500: IF p_line_rec.request_date IS NULL THEN
501: x_return_status := FND_API.G_RET_STS_ERROR;
502: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_RETURN_ATTRIBUTE');
503: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
504: OE_Order_UTIL.Get_Attribute_Name('REQUEST_DATE'));
505: OE_MSG_PUB.ADD;
506: END IF;
499:
500: IF p_line_rec.request_date IS NULL THEN
501: x_return_status := FND_API.G_RET_STS_ERROR;
502: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_RETURN_ATTRIBUTE');
503: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
504: OE_Order_UTIL.Get_Attribute_Name('REQUEST_DATE'));
505: OE_MSG_PUB.ADD;
506: END IF;
507:
511:
512: IF p_line_rec.tax_date IS NULL
513: THEN
514: x_return_status := FND_API.G_RET_STS_ERROR;
515: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_RETURN_ATTRIBUTE');
516: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
517: OE_Order_UTIL.Get_Attribute_Name('TAX_DATE'));
518: OE_MSG_PUB.ADD;
519: END IF;
512: IF p_line_rec.tax_date IS NULL
513: THEN
514: x_return_status := FND_API.G_RET_STS_ERROR;
515: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_RETURN_ATTRIBUTE');
516: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
517: OE_Order_UTIL.Get_Attribute_Name('TAX_DATE'));
518: OE_MSG_PUB.ADD;
519: END IF;
520:
598:
599: IF nvl(l_tax_calculation_event_code, 'ENTERING') IN ('ENTERING', 'BOOKING') THEN
600:
601: x_return_status := FND_API.G_RET_STS_ERROR;
602: FND_MESSAGE.SET_NAME('ONT','OE_VAL_TAX_CODE_REQD');
603: OE_MSG_PUB.ADD;
604: END IF;
605: END IF;
606:
610: -- Service Duration is required on SERVICE lines
611: IF l_item_type_code = 'SERVICE' THEN
612: IF p_line_rec.service_duration IS NULL THEN
613: x_return_status := FND_API.G_RET_STS_ERROR;
614: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_SERVICE_DURATION');
615: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
616: OE_Order_UTIL.Get_Attribute_Name('SERVICE_DURATION'));
617: OE_MSG_PUB.ADD;
618: END IF;
611: IF l_item_type_code = 'SERVICE' THEN
612: IF p_line_rec.service_duration IS NULL THEN
613: x_return_status := FND_API.G_RET_STS_ERROR;
614: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_SERVICE_DURATION');
615: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
616: OE_Order_UTIL.Get_Attribute_Name('SERVICE_DURATION'));
617: OE_MSG_PUB.ADD;
618: END IF;
619: END IF;
623: IF p_line_rec.service_coterminate_flag = 'Y' OR
624: p_line_rec.service_reference_type_code = 'CUSTOMER_PRODUCT' THEN
625: IF p_line_rec.service_start_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_START_DATE'));
629: OE_MSG_PUB.ADD;
630: END IF;
631: IF p_line_rec.service_end_date IS NULL THEN
624: p_line_rec.service_reference_type_code = 'CUSTOMER_PRODUCT' THEN
625: IF p_line_rec.service_start_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_START_DATE'));
629: OE_MSG_PUB.ADD;
630: END IF;
631: IF p_line_rec.service_end_date IS NULL THEN
632: x_return_status := FND_API.G_RET_STS_ERROR;
629: OE_MSG_PUB.ADD;
630: END IF;
631: IF p_line_rec.service_end_date IS NULL THEN
632: x_return_status := FND_API.G_RET_STS_ERROR;
633: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
634: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', OE_Order_UTIL.Get_Attribute_Name('SERVICE_END_DATE'));
635: OE_MSG_PUB.ADD;
636: END IF;
637: END IF;
630: END IF;
631: IF p_line_rec.service_end_date IS NULL THEN
632: x_return_status := FND_API.G_RET_STS_ERROR;
633: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
634: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', OE_Order_UTIL.Get_Attribute_Name('SERVICE_END_DATE'));
635: OE_MSG_PUB.ADD;
636: END IF;
637: END IF;
638:
637: END IF;
638:
639: IF p_line_rec.service_duration IS NULL THEN
640: x_return_status := FND_API.G_RET_STS_ERROR;
641: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
642: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
643: OE_Order_UTIL.Get_Attribute_Name('SERVICE_DURATION'));
644: OE_MSG_PUB.ADD;
645: END IF;
638:
639: IF p_line_rec.service_duration IS NULL THEN
640: x_return_status := FND_API.G_RET_STS_ERROR;
641: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
642: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
643: OE_Order_UTIL.Get_Attribute_Name('SERVICE_DURATION'));
644: OE_MSG_PUB.ADD;
645: END IF;
646: IF p_line_rec.service_period IS NULL THEN
644: OE_MSG_PUB.ADD;
645: END IF;
646: IF p_line_rec.service_period IS NULL THEN
647: x_return_status := FND_API.G_RET_STS_ERROR;
648: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
649: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
650: OE_Order_UTIL.Get_Attribute_Name('SERVICE_PERIOD'));
651: OE_MSG_PUB.ADD;
652: END IF;
645: END IF;
646: IF p_line_rec.service_period IS NULL THEN
647: x_return_status := FND_API.G_RET_STS_ERROR;
648: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
649: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
650: OE_Order_UTIL.Get_Attribute_Name('SERVICE_PERIOD'));
651: OE_MSG_PUB.ADD;
652: END IF;
653: -- sol_ord_er #16014165
654: IF p_line_rec.subscription_enable_flag = 'Y' THEN
655: -- If Service Start Date is NULL
656: IF p_line_rec.service_start_date IS NULL THEN
657: x_return_status := FND_API.G_RET_STS_ERROR;
658: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
659: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', OE_Order_UTIL.Get_Attribute_Name('SERVICE_START_DATE'));
660: OE_MSG_PUB.ADD;
661: End IF;
662: -- If Subscription Template is NULL
655: -- If Service Start Date is NULL
656: IF p_line_rec.service_start_date IS NULL THEN
657: x_return_status := FND_API.G_RET_STS_ERROR;
658: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
659: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', OE_Order_UTIL.Get_Attribute_Name('SERVICE_START_DATE'));
660: OE_MSG_PUB.ADD;
661: End IF;
662: -- If Subscription Template is NULL
663: IF NVL(P_LINE_REC.service_subs_template_id,FND_API.G_MISS_NUM)= FND_API.G_MISS_NUM THEN
661: End IF;
662: -- If Subscription Template is NULL
663: IF NVL(P_LINE_REC.service_subs_template_id,FND_API.G_MISS_NUM)= FND_API.G_MISS_NUM THEN
664: x_return_status := FND_API.G_RET_STS_ERROR;
665: fnd_message.set_name('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
666: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', oe_order_util.get_attribute_name('SERVICE_SUBS_TEMPLATE_ID'));
667: OE_MSG_PUB.Add;
668: End IF;
669: END IF;
662: -- If Subscription Template is NULL
663: IF NVL(P_LINE_REC.service_subs_template_id,FND_API.G_MISS_NUM)= FND_API.G_MISS_NUM THEN
664: x_return_status := FND_API.G_RET_STS_ERROR;
665: fnd_message.set_name('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
666: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', oe_order_util.get_attribute_name('SERVICE_SUBS_TEMPLATE_ID'));
667: OE_MSG_PUB.Add;
668: End IF;
669: END IF;
670: -- sol_ord_er #16014165
680: p_line_rec.cancelled_flag <> 'Y'
681: THEN
682: IF (OE_LINE_UTIL.Is_Over_Return(p_line_rec)) THEN
683: x_return_status := FND_API.G_RET_STS_ERROR;
684: FND_MESSAGE.Set_Name('ONT', 'OE_RETURN_INVALID_QUANTITY');
685: OE_MSG_PUB.ADD;
686: END IF;
687:
688: END IF;
695:
696: IF (OE_CODE_CONTROL.Code_Release_Level >= '110509' and p_line_rec.order_firmed_date > l_hdr_booked_date
697: and p_line_rec.creation_date <= l_hdr_booked_date) THEN
698: x_return_status := FND_API.G_RET_STS_ERROR;
699: FND_MESSAGE.Set_Name('ONT','ONT_ORDER_FIRMED_DATE_INVALID');
700: OE_MSG_PUB.Add;
701: END IF;
702: --end
703:
721: l_revision_controlled := 'N';
722: End;
723: IF l_revision_controlled = 'Y' THEN
724: x_return_status := FND_API.G_RET_STS_ERROR;
725: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_RETURN_ATTRIBUTE');
726: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', OE_Order_UTIL.Get_Attribute_Name('ITEM_REVISION'));
727: OE_MSG_PUB.ADD;
728: END IF;
729: END IF;
722: End;
723: IF l_revision_controlled = 'Y' THEN
724: x_return_status := FND_API.G_RET_STS_ERROR;
725: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_RETURN_ATTRIBUTE');
726: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', OE_Order_UTIL.Get_Attribute_Name('ITEM_REVISION'));
727: OE_MSG_PUB.ADD;
728: END IF;
729: END IF;
730: END IF;
818: AND wnd.status_code in ('CO', 'IT', 'CL', 'SA')))
819: AND rownum = 1;
820:
821: IF l_ship_set > 0 AND l_shipset_enforce = 'Y' THEN
822: FND_MESSAGE.Set_Name ('ONT','ONT_SET_PICK_RELEASED');
823: BEGIN
824: SELECT SET_NAME
825: INTO l_set_name
826: FROM OE_SETS
828: EXCEPTION
829: WHEN NO_DATA_FOUND THEN
830: l_set_name := null;
831: END;
832: FND_MESSAGE.Set_Token('SHIP_SET',l_set_name);
833: OE_MSG_PUB.Add;
834: x_return_status := FND_API.G_RET_STS_ERROR;
835: END IF;
836:
855: AND Released_Status In ('S','Y','C')
856: AND ROWNUM = 1;
857:
858: IF l_smc_model > 0 AND l_shipset_enforce = 'Y' THEN
859: FND_MESSAGE.Set_Name ('ONT','ONT_SMC_PICK_RELEASED');
860: BEGIN
861: SELECT ORDERED_ITEM,inventory_item_id
862: INTO l_model_name,l_model_item_id
863: FROM OE_ORDER_LINES
865: EXCEPTION
866: WHEN NO_DATA_FOUND THEN
867: l_model_name := null;
868: END;
869: FND_MESSAGE.Set_Token('MODEL',nvl(l_model_name,l_model_item_id));
870: OE_MSG_PUB.Add;
871: x_return_status := FND_API.G_RET_STS_ERROR;
872: END IF;
873: END IF;
968: p_ato_line_id = p_line_id)) THEN
969: IF l_debug_level > 0 then
970: OE_DEBUG_PUB.Add('item is config related with decimal qty',2);
971: END IF;
972: FND_MESSAGE.SET_NAME('ONT', 'OE_CONFIG_NO_DECIMALS');
973: FND_MESSAGE.SET_TOKEN('ITEM', nvl(OE_Id_To_Value.Inventory_Item(p_item_id),p_item_id));
974: FND_Message.Set_Token('LINE_NUM', p_line_num);
975: OE_MSG_PUB.Add;
976: x_return_status := FND_API.G_RET_STS_ERROR;
969: IF l_debug_level > 0 then
970: OE_DEBUG_PUB.Add('item is config related with decimal qty',2);
971: END IF;
972: FND_MESSAGE.SET_NAME('ONT', 'OE_CONFIG_NO_DECIMALS');
973: FND_MESSAGE.SET_TOKEN('ITEM', nvl(OE_Id_To_Value.Inventory_Item(p_item_id),p_item_id));
974: FND_Message.Set_Token('LINE_NUM', p_line_num);
975: OE_MSG_PUB.Add;
976: x_return_status := FND_API.G_RET_STS_ERROR;
977: END IF;
970: OE_DEBUG_PUB.Add('item is config related with decimal qty',2);
971: END IF;
972: FND_MESSAGE.SET_NAME('ONT', 'OE_CONFIG_NO_DECIMALS');
973: FND_MESSAGE.SET_TOKEN('ITEM', nvl(OE_Id_To_Value.Inventory_Item(p_item_id),p_item_id));
974: FND_Message.Set_Token('LINE_NUM', p_line_num);
975: OE_MSG_PUB.Add;
976: x_return_status := FND_API.G_RET_STS_ERROR;
977: END IF;
978:
981: IF p_item_type_code IN ('MODEL', 'KIT','CLASS','INCLUDED','OPTION', 'CONFIG') THEN
982: IF l_debug_level > 0 then
983: OE_DEBUG_PUB.Add('item is config related with decimal qty',2);
984: END IF;
985: FND_MESSAGE.SET_NAME('ONT', 'OE_CONFIG_NO_DECIMALS');
986: FND_MESSAGE.SET_TOKEN('ITEM', nvl(OE_Id_To_Value.Inventory_Item(p_item_id),p_item_id));
987: FND_Message.Set_Token('LINE_NUM', p_line_num);
988: OE_MSG_PUB.Add;
989: x_return_status := FND_API.G_RET_STS_ERROR;
982: IF l_debug_level > 0 then
983: OE_DEBUG_PUB.Add('item is config related with decimal qty',2);
984: END IF;
985: FND_MESSAGE.SET_NAME('ONT', 'OE_CONFIG_NO_DECIMALS');
986: FND_MESSAGE.SET_TOKEN('ITEM', nvl(OE_Id_To_Value.Inventory_Item(p_item_id),p_item_id));
987: FND_Message.Set_Token('LINE_NUM', p_line_num);
988: OE_MSG_PUB.Add;
989: x_return_status := FND_API.G_RET_STS_ERROR;
990: END IF;
983: OE_DEBUG_PUB.Add('item is config related with decimal qty',2);
984: END IF;
985: FND_MESSAGE.SET_NAME('ONT', 'OE_CONFIG_NO_DECIMALS');
986: FND_MESSAGE.SET_TOKEN('ITEM', nvl(OE_Id_To_Value.Inventory_Item(p_item_id),p_item_id));
987: FND_Message.Set_Token('LINE_NUM', p_line_num);
988: OE_MSG_PUB.Add;
989: x_return_status := FND_API.G_RET_STS_ERROR;
990: END IF;
991:
1027: OE_DEBUG_PUB.Add('do not error out,cascading',1);
1028: END IF;
1029: x_return_status := FND_API.G_RET_STS_SUCCESS;
1030: ELSE
1031: fnd_message.set_name('ONT', 'OE_DECIMAL_MAX_PRECISION');
1032: -- move INV error message to OE message stack
1033: oe_msg_pub.add;
1034: x_return_status := FND_API.G_RET_STS_ERROR;
1035: END IF;
1120: END IF;
1121: END IF;
1122: END IF;
1123:
1124: FND_MESSAGE.Set_Name('ONT', 'OE_CONFIG_DECIMAL_RATIO');
1125:
1126: FND_MESSAGE.Set_TOKEN('ITEM', nvl(p_line_rec.ordered_item,
1127: p_line_rec.inventory_item_id));
1128: FND_MESSAGE.Set_TOKEN('TYPECODE', p_line_rec.item_type_code);
1122: END IF;
1123:
1124: FND_MESSAGE.Set_Name('ONT', 'OE_CONFIG_DECIMAL_RATIO');
1125:
1126: FND_MESSAGE.Set_TOKEN('ITEM', nvl(p_line_rec.ordered_item,
1127: p_line_rec.inventory_item_id));
1128: FND_MESSAGE.Set_TOKEN('TYPECODE', p_line_rec.item_type_code);
1129: FND_MESSAGE.Set_TOKEN('VALUE',
1130: to_char(l_ordered_quantity/p_line_rec.ordered_quantity));
1124: FND_MESSAGE.Set_Name('ONT', 'OE_CONFIG_DECIMAL_RATIO');
1125:
1126: FND_MESSAGE.Set_TOKEN('ITEM', nvl(p_line_rec.ordered_item,
1127: p_line_rec.inventory_item_id));
1128: FND_MESSAGE.Set_TOKEN('TYPECODE', p_line_rec.item_type_code);
1129: FND_MESSAGE.Set_TOKEN('VALUE',
1130: to_char(l_ordered_quantity/p_line_rec.ordered_quantity));
1131:
1132: FND_MESSAGE.Set_TOKEN('MODEL', nvl(l_ordered_item,l_inv_item_id));
1125:
1126: FND_MESSAGE.Set_TOKEN('ITEM', nvl(p_line_rec.ordered_item,
1127: p_line_rec.inventory_item_id));
1128: FND_MESSAGE.Set_TOKEN('TYPECODE', p_line_rec.item_type_code);
1129: FND_MESSAGE.Set_TOKEN('VALUE',
1130: to_char(l_ordered_quantity/p_line_rec.ordered_quantity));
1131:
1132: FND_MESSAGE.Set_TOKEN('MODEL', nvl(l_ordered_item,l_inv_item_id));
1133: FND_MESSAGE.Set_TOKEN('PTYPECODE', l_item_type_code);
1128: FND_MESSAGE.Set_TOKEN('TYPECODE', p_line_rec.item_type_code);
1129: FND_MESSAGE.Set_TOKEN('VALUE',
1130: to_char(l_ordered_quantity/p_line_rec.ordered_quantity));
1131:
1132: FND_MESSAGE.Set_TOKEN('MODEL', nvl(l_ordered_item,l_inv_item_id));
1133: FND_MESSAGE.Set_TOKEN('PTYPECODE', l_item_type_code);
1134:
1135: OE_MSG_PUB.Add;
1136:
1129: FND_MESSAGE.Set_TOKEN('VALUE',
1130: to_char(l_ordered_quantity/p_line_rec.ordered_quantity));
1131:
1132: FND_MESSAGE.Set_TOKEN('MODEL', nvl(l_ordered_item,l_inv_item_id));
1133: FND_MESSAGE.Set_TOKEN('PTYPECODE', l_item_type_code);
1134:
1135: OE_MSG_PUB.Add;
1136:
1137: x_return_status := FND_API.G_RET_STS_ERROR;
1216: IF l_debug_level > 0 then
1217: oe_debug_pub.add(' Validate Line Type Line Cat Code from the OE_TRXT_ALL table: '||lline_category_code);
1218: oe_debug_pub.add(' Validate Line Type Line Cat Code from the UI: '||p_line_rec.line_category_code);
1219: END IF;
1220: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1221: fnd_message.set_token('ATTRIBUTE', OE_Order_Util.Get_Attribute_Name('Line_type_id'));
1222: OE_MSG_PUB.Add;
1223: RAISE FND_API.G_EXC_ERROR;
1224: end if;
1217: oe_debug_pub.add(' Validate Line Type Line Cat Code from the OE_TRXT_ALL table: '||lline_category_code);
1218: oe_debug_pub.add(' Validate Line Type Line Cat Code from the UI: '||p_line_rec.line_category_code);
1219: END IF;
1220: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1221: fnd_message.set_token('ATTRIBUTE', OE_Order_Util.Get_Attribute_Name('Line_type_id'));
1222: OE_MSG_PUB.Add;
1223: RAISE FND_API.G_EXC_ERROR;
1224: end if;
1225: END IF;
1233: IF NOT OE_Globals.Equal(l_new_wf_item_type, l_old_wf_item_type)
1234: THEN
1235: oe_debug_pub.add('workflow item type changed', 1);
1236:
1237: -- FND_Message.Set_Name('ONT', 'OE_WF_ITEM_TYPE_CHANGED');
1238: FND_Message.Set_Name('ONT', 'OE_ITEM_TYPE_CONST');
1239: oe_msg_pub.add;
1240: RAISE FND_API.G_EXC_ERROR;
1241: END IF;
1234: THEN
1235: oe_debug_pub.add('workflow item type changed', 1);
1236:
1237: -- FND_Message.Set_Name('ONT', 'OE_WF_ITEM_TYPE_CHANGED');
1238: FND_Message.Set_Name('ONT', 'OE_ITEM_TYPE_CONST');
1239: oe_msg_pub.add;
1240: RAISE FND_API.G_EXC_ERROR;
1241: END IF;
1242:
1291: IF lexists IS NULL THEN
1292: IF l_debug_level > 0 then
1293: oe_debug_pub.add('No explicit assignment exists',2);
1294: END IF;
1295: FND_MESSAGE.SET_NAME('ONT','OE_EXP_ASSIGN_REQ');
1296: OE_MSG_PUB.ADD;
1297: RAISE FND_API.G_EXC_ERROR;
1298: END IF;
1299:
1304: OE_DEBUG_PUB.Add('Exiting OE_VALIDATE_LINE.Validate_Line_Type',1);
1305: END IF;
1306: EXCEPTION
1307: WHEN NO_DATA_FOUND THEN
1308: FND_MESSAGE.SET_NAME('ONT','OE_FLOW_CNT_CHANGE');
1309: OE_MSG_PUB.ADD;
1310: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1311: WHEN FND_API.G_EXC_ERROR THEN
1312: RAISE FND_API.G_EXC_ERROR;
1374:
1375: RETURN TRUE;
1376: EXCEPTION
1377: WHEN NO_DATA_FOUND THEN
1378: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ITEM_WHSE');
1379: OE_MSG_PUB.add;
1380: RETURN FALSE;
1381: WHEN OTHERS THEN
1382: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ITEM_WHSE');
1378: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ITEM_WHSE');
1379: OE_MSG_PUB.add;
1380: RETURN FALSE;
1381: WHEN OTHERS THEN
1382: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ITEM_WHSE');
1383: OE_MSG_PUB.add;
1384: RETURN FALSE;
1385: END Validate_Receiving_Org;
1386:
1406:
1407: oe_debug_pub.add('Old Shipable flag, New shipable flag : '||l_shipable_flag_old||l_shipable_flag_new);
1408: IF (l_shipable_flag_old <> l_shipable_flag_new AND l_shipable_flag_new = 'N') THEN
1409: l_result := FALSE;
1410: FND_MESSAGE.SET_NAME('ONT','OE_INVLD_CHG_SHP_FROM_ORG');
1411: oe_msg_pub.add;
1412: ELSE
1413: l_result := TRUE;
1414: END IF;
1551: IF l_debug_level > 0 then
1552: oe_debug_pub.add('RR: No data found',1);
1553: END IF;
1554:
1555: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ITEM_WHSE');
1556: OE_MSG_PUB.add;
1557: RETURN FALSE;
1558:
1559: WHEN OTHERS THEN
1559: WHEN OTHERS THEN
1560: IF l_debug_level > 0 then
1561: oe_debug_pub.add('RR: OTHERS',1);
1562: END IF;
1563: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ITEM_WHSE');
1564: OE_MSG_PUB.add;
1565: RETURN FALSE;
1566:
1567: END Validate_Item_Warehouse;
1953: RETURN TRUE;
1954: ELSIF (l_profile = 'R') THEN
1955: RETURN FALSE;
1956: ELSE -- warning
1957: FND_MESSAGE.SET_NAME('ONT','OE_RETURN_ITEM_MISMATCH_WARNIN');
1958: OE_MSG_PUB.ADD;
1959: END IF;
1960:
1961: END IF;
2031: RETURN TRUE;
2032: ELSIF (l_profile = 'R') THEN
2033: RETURN FALSE;
2034: ELSE -- warning
2035: FND_MESSAGE.SET_NAME('ONT','OE_UNFULFILLED_LINE_WARNING');
2036: OE_MSG_PUB.ADD;
2037: END IF;
2038:
2039: END IF;
2090:
2091: IF l_returnable_flag = 'Y' THEN
2092: x_return_status := FND_API.G_RET_STS_SUCCESS;
2093: ELSE
2094: fnd_message.set_name('ONT', 'OE_ITEM_NOT_RETURNABLE');
2095: OE_MSG_PUB.add;
2096: x_return_status := FND_API.G_RET_STS_ERROR;
2097: END IF;
2098:
2101: IF l_debug_level > 0 then
2102: oe_debug_pub.add('Validate_Return_Item: No data found',1);
2103: END IF;
2104: x_return_status := FND_API.G_RET_STS_ERROR;
2105: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ITEM_WHSE');
2106: OE_MSG_PUB.add;
2107: WHEN OTHERS THEN
2108: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2109: IF l_debug_level > 0 then
2133: WHERE line_id = p_reference_line_id
2134: and line_category_code = 'ORDER';
2135:
2136: IF NOT OE_GLOBALS.EQUAL(l_tax_code,p_tax_code) THEN
2137: fnd_message.set_name('ONT','OE_RETURN_ATTR_CANNOT_CHANGE');
2138: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Tax Code');
2139: OE_MSG_PUB.Add;
2140: RETURN FALSE;
2141: END IF;
2134: and line_category_code = 'ORDER';
2135:
2136: IF NOT OE_GLOBALS.EQUAL(l_tax_code,p_tax_code) THEN
2137: fnd_message.set_name('ONT','OE_RETURN_ATTR_CANNOT_CHANGE');
2138: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Tax Code');
2139: OE_MSG_PUB.Add;
2140: RETURN FALSE;
2141: END IF;
2142:
2149: WHEN NO_DATA_FOUND THEN
2150: if l_debug_level > 0 then
2151: oe_debug_pub.add('Validate_Return_Reference: No data found',1);
2152: end if;
2153: fnd_message.set_name('ONT', 'OE_RETURN_INVALID_SO_LINE');
2154: OE_MSG_PUB.Add;
2155: RETURN FALSE;
2156: WHEN OTHERS THEN
2157: if l_debug_level > 0 then
2156: WHEN OTHERS THEN
2157: if l_debug_level > 0 then
2158: oe_debug_pub.add('Validate_Return_Reference: When Others',1);
2159: end if;
2160: fnd_message.set_name('ONT', 'OE_RETURN_INVALID_SO_LINE');
2161: OE_MSG_PUB.Add;
2162: RETURN FALSE;
2163: END Validate_Return_Reference_Tax;
2164:
2206: IF l_debug_level > 0 then
2207: oe_debug_pub.add('p_reference_line_id= '||p_reference_line_id
2208: ||' l_subscription_enable_flag = '||l_subscription_enable_flag,5);
2209: END IF;
2210: fnd_message.set_name('ONT', 'OE_RETURN_INVALID_SO_LINE');
2211: OE_MSG_PUB.Add;
2212: RETURN FALSE;
2213: End If;
2214: -- sol_ord_er #16014165 end
2278:
2279: IF ((l_actid IS NOT NULL) OR (nvl(fnd_profile.value('ONT_BYPASS_ISO_RMA_VAL'), 'N') = 'N')) THEN
2280: -- end changes for bug10631972
2281:
2282: fnd_message.set_name('ONT','OE_NO_RMA_FOR_INTERNAL_ORDER');
2283: OE_MSG_PUB.Add;
2284: RETURN FALSE;
2285: END IF; -- bug10631972
2286:
2286:
2287: END IF; --l_source_document_type_id = 10
2288:
2289: IF NOT OE_GLOBALS.EQUAL(l_uom_code,p_uom_code) THEN
2290: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2291: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Unit Of Measure');
2292: OE_MSG_PUB.Add;
2293: RETURN FALSE;
2294: END IF;
2287: END IF; --l_source_document_type_id = 10
2288:
2289: IF NOT OE_GLOBALS.EQUAL(l_uom_code,p_uom_code) THEN
2290: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2291: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Unit Of Measure');
2292: OE_MSG_PUB.Add;
2293: RETURN FALSE;
2294: END IF;
2295:
2295:
2296: IF l_booked_flag = 'Y' THEN
2297: RETURN TRUE;
2298: ELSE
2299: fnd_message.set_name('ONT', 'OE_RETURN_UNBOOKED_ORDER');
2300: OE_MSG_PUB.Add;
2301: END IF;
2302: IF l_debug_level > 0 then
2303: oe_debug_pub.add('Exit Validate_Return_Reference',1);
2308: WHEN NO_DATA_FOUND THEN
2309: IF l_debug_level > 0 then
2310: oe_debug_pub.add('Validate_Return_Reference: No data found',1);
2311: END IF;
2312: fnd_message.set_name('ONT', 'OE_RETURN_INVALID_SO_LINE');
2313: OE_MSG_PUB.Add;
2314: RETURN FALSE;
2315: WHEN OTHERS THEN
2316: IF l_debug_level > 0 then
2315: WHEN OTHERS THEN
2316: IF l_debug_level > 0 then
2317: oe_debug_pub.add('Validate_Return_Reference: When Others',1);
2318: END IF;
2319: fnd_message.set_name('ONT', 'OE_RETURN_INVALID_SO_LINE');
2320: OE_MSG_PUB.Add;
2321: RETURN FALSE;
2322: END Validate_Return_Reference;
2323:
2354: IF l_ord_qty > 0 THEN
2355: -- Begin : Changes for bug 7707133
2356: -- Introduced additional ELSE clause
2357: IF p_ord_qty <= 0 THEN -- line cancellation
2358: fnd_message.set_name('ONT','OE_LINE_HAS_RMA_CANNOT_CANCEL');
2359: OE_MSG_PUB.Add;
2360: RETURN FALSE;
2361: ELSIF p_ord_qty < l_ord_qty THEN -- Higher Return quantity
2362: fnd_message.set_name('ONT','OE_LINE_HAS_RMA_HIGHER_QTY');
2358: fnd_message.set_name('ONT','OE_LINE_HAS_RMA_CANNOT_CANCEL');
2359: OE_MSG_PUB.Add;
2360: RETURN FALSE;
2361: ELSIF p_ord_qty < l_ord_qty THEN -- Higher Return quantity
2362: fnd_message.set_name('ONT','OE_LINE_HAS_RMA_HIGHER_QTY');
2363: OE_MSG_PUB.Add;
2364: RETURN FALSE;
2365: ELSIF p_action_code = OE_GLOBALS.G_OPR_DELETE THEN
2366: -- Line deletion during config item delinking (p_ord_qty>0)
2363: OE_MSG_PUB.Add;
2364: RETURN FALSE;
2365: ELSIF p_action_code = OE_GLOBALS.G_OPR_DELETE THEN
2366: -- Line deletion during config item delinking (p_ord_qty>0)
2367: fnd_message.set_name('ONT','OE_LINE_HAS_RMA_CANNOT_DELINK');
2368: OE_MSG_PUB.Add;
2369: RETURN FALSE;
2370: END IF;
2371: -- End : Changes for bug 7707133
2674: oe_debug_pub.add('Error: Commitment NOT related to Sold To/Invoice To at the line level');
2675: end if;
2676:
2677: x_return_status := FND_API.G_RET_STS_ERROR;
2678: FND_MESSAGE.SET_NAME('ONT','ONT_COM_CUSTOMER_MISMATCH');
2679: FND_MESSAGE.SET_TOKEN('CUSTOMER','');
2680: OE_MSG_PUB.ADD;
2681: end if;
2682:
2675: end if;
2676:
2677: x_return_status := FND_API.G_RET_STS_ERROR;
2678: FND_MESSAGE.SET_NAME('ONT','ONT_COM_CUSTOMER_MISMATCH');
2679: FND_MESSAGE.SET_TOKEN('CUSTOMER','');
2680: OE_MSG_PUB.ADD;
2681: end if;
2682:
2683: /* Fix Bug # 3015881 End */
2704:
2705: IF NOT OE_GLOBALS.EQUAL(nvl(l_agreement_id, p_line_rec.agreement_id), p_line_rec.agreement_id)
2706: AND p_line_rec.agreement_id IS NOT NULL THEN
2707: x_return_status := FND_API.G_RET_STS_ERROR;
2708: fnd_message.set_name('ONT','ONT_COM_AGREEMENT_MISMATCH');
2709: FND_MESSAGE.SET_TOKEN('AGREEMENT',OE_Id_To_Value.Agreement(p_line_rec.agreement_id));
2710: OE_MSG_PUB.Add;
2711: END IF;
2712:
2705: IF NOT OE_GLOBALS.EQUAL(nvl(l_agreement_id, p_line_rec.agreement_id), p_line_rec.agreement_id)
2706: AND p_line_rec.agreement_id IS NOT NULL THEN
2707: x_return_status := FND_API.G_RET_STS_ERROR;
2708: fnd_message.set_name('ONT','ONT_COM_AGREEMENT_MISMATCH');
2709: FND_MESSAGE.SET_TOKEN('AGREEMENT',OE_Id_To_Value.Agreement(p_line_rec.agreement_id));
2710: OE_MSG_PUB.Add;
2711: END IF;
2712:
2713: IF NOT OE_GLOBALS.EQUAL(nvl(l_inventory_item_id, p_line_rec.inventory_item_id), p_line_rec.inventory_item_id) THEN
2711: END IF;
2712:
2713: IF NOT OE_GLOBALS.EQUAL(nvl(l_inventory_item_id, p_line_rec.inventory_item_id), p_line_rec.inventory_item_id) THEN
2714: x_return_status := FND_API.G_RET_STS_ERROR;
2715: fnd_message.set_name('ONT','ONT_COM_ITEM_MISMATCH');
2716: FND_MESSAGE.SET_TOKEN('ITEM', OE_Id_To_Value.Inventory_Item(p_line_rec.inventory_item_id));
2717: OE_MSG_PUB.Add;
2718: END IF;
2719: IF l_debug_level > 0 then
2712:
2713: IF NOT OE_GLOBALS.EQUAL(nvl(l_inventory_item_id, p_line_rec.inventory_item_id), p_line_rec.inventory_item_id) THEN
2714: x_return_status := FND_API.G_RET_STS_ERROR;
2715: fnd_message.set_name('ONT','ONT_COM_ITEM_MISMATCH');
2716: FND_MESSAGE.SET_TOKEN('ITEM', OE_Id_To_Value.Inventory_Item(p_line_rec.inventory_item_id));
2717: OE_MSG_PUB.Add;
2718: END IF;
2719: IF l_debug_level > 0 then
2720: oe_debug_pub.add('OEXLLINB: commitment end date is: '||l_comm_end_date, 3);
2734: l_comm_end_date is NOT NULL THEN
2735: IF trunc(l_comm_end_date)< trunc(l_event_end_date)
2736: THEN
2737: x_return_status := FND_API.G_RET_STS_ERROR;
2738: fnd_message.set_name('ONT','ONT_COM_END_DATE');
2739: FND_MESSAGE.SET_TOKEN('COMMITMENT',l_commitment_number);
2740: OE_MSG_PUB.Add;
2741: END IF;
2742: END IF;
2735: IF trunc(l_comm_end_date)< trunc(l_event_end_date)
2736: THEN
2737: x_return_status := FND_API.G_RET_STS_ERROR;
2738: fnd_message.set_name('ONT','ONT_COM_END_DATE');
2739: FND_MESSAGE.SET_TOKEN('COMMITMENT',l_commitment_number);
2740: OE_MSG_PUB.Add;
2741: END IF;
2742: END IF;
2743: END IF;
2765: END IF;
2766:
2767: IF l_commitment_bal <= 0 THEN
2768: x_return_status := FND_API.G_RET_STS_ERROR;
2769: FND_MESSAGE.SET_NAME('ONT','OE_COM_ZERO_BALANCE');
2770: FND_MESSAGE.SET_TOKEN('COMMITMENT',l_commitment_number);
2771: OE_MSG_PUB.Add;
2772: END IF;
2773:
2766:
2767: IF l_commitment_bal <= 0 THEN
2768: x_return_status := FND_API.G_RET_STS_ERROR;
2769: FND_MESSAGE.SET_NAME('ONT','OE_COM_ZERO_BALANCE');
2770: FND_MESSAGE.SET_TOKEN('COMMITMENT',l_commitment_number);
2771: OE_MSG_PUB.Add;
2772: END IF;
2773:
2774: END IF;
2783: x_return_status := FND_API.G_RET_STS_ERROR;
2784: IF l_debug_level > 0 then
2785: OE_DEBUG_PUB.Add('Validate_Commitment: When no data found');
2786: END IF;
2787: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2788: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Commitment Number');
2789: OE_MSG_PUB.Add;
2790:
2791: WHEN OTHERS THEN
2784: IF l_debug_level > 0 then
2785: OE_DEBUG_PUB.Add('Validate_Commitment: When no data found');
2786: END IF;
2787: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2788: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Commitment Number');
2789: OE_MSG_PUB.Add;
2790:
2791: WHEN OTHERS THEN
2792:
2838: THEN
2839: IF l_debug_level > 0 then
2840: oe_debug_pub.add('service / part of smc model', 4);
2841: END IF;
2842: FND_MESSAGE.SET_NAME('ONT', 'OE_DS_NOT_VALID_ITEM');
2843: FND_MESSAGE.SET_TOKEN('ITEM', nvl(p_line_rec.ordered_item,p_line_rec.inventory_item_id));
2844: OE_MSG_PUB.Add;
2845: x_return_status := FND_API.G_RET_STS_ERROR;
2846: RETURN;
2839: IF l_debug_level > 0 then
2840: oe_debug_pub.add('service / part of smc model', 4);
2841: END IF;
2842: FND_MESSAGE.SET_NAME('ONT', 'OE_DS_NOT_VALID_ITEM');
2843: FND_MESSAGE.SET_TOKEN('ITEM', nvl(p_line_rec.ordered_item,p_line_rec.inventory_item_id));
2844: OE_MSG_PUB.Add;
2845: x_return_status := FND_API.G_RET_STS_ERROR;
2846: RETURN;
2847: ELSE
2853: IF (p_line_rec.item_type_code <> OE_GLOBALS.G_ITEM_STANDARD) THEN
2854: IF l_debug_level > 0 then
2855: oe_debug_pub.add('Cannot dropship non-standard item',2);
2856: END IF;
2857: FND_MESSAGE.SET_NAME('ONT', 'OE_DS_NOT_ALLOWED');
2858: OE_MSG_PUB.Add;
2859: x_return_status := FND_API.G_RET_STS_ERROR;
2860: RETURN;
2861: END IF;
2897: END IF;
2898: END IF;
2899:
2900: IF l_purchasing_enabled_flag = 'N' THEN
2901: FND_MESSAGE.SET_NAME('ONT', 'OE_DS_NOT_ENABLED');
2902: FND_MESSAGE.SET_TOKEN('ITEM', nvl(p_line_rec.ordered_item,p_line_rec.inventory_item_id));
2903: FND_MESSAGE.SET_TOKEN('ORG', nvl(p_line_rec.ship_from_org_id,
2904: OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID')));
2905: OE_MSG_PUB.Add;
2898: END IF;
2899:
2900: IF l_purchasing_enabled_flag = 'N' THEN
2901: FND_MESSAGE.SET_NAME('ONT', 'OE_DS_NOT_ENABLED');
2902: FND_MESSAGE.SET_TOKEN('ITEM', nvl(p_line_rec.ordered_item,p_line_rec.inventory_item_id));
2903: FND_MESSAGE.SET_TOKEN('ORG', nvl(p_line_rec.ship_from_org_id,
2904: OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID')));
2905: OE_MSG_PUB.Add;
2906: x_return_status := FND_API.G_RET_STS_ERROR;
2899:
2900: IF l_purchasing_enabled_flag = 'N' THEN
2901: FND_MESSAGE.SET_NAME('ONT', 'OE_DS_NOT_ENABLED');
2902: FND_MESSAGE.SET_TOKEN('ITEM', nvl(p_line_rec.ordered_item,p_line_rec.inventory_item_id));
2903: FND_MESSAGE.SET_TOKEN('ORG', nvl(p_line_rec.ship_from_org_id,
2904: OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID')));
2905: OE_MSG_PUB.Add;
2906: x_return_status := FND_API.G_RET_STS_ERROR;
2907: END IF;
2917: THEN
2918: IF l_debug_level > 0 then
2919: oe_debug_pub.add('item under ato model', 4);
2920: END IF;
2921: FND_MESSAGE.SET_NAME('ONT', 'OE_DS_CHANGE_NOT_ALLOWED');
2922: OE_MSG_PUB.Add;
2923: x_return_status := FND_API.G_RET_STS_ERROR;
2924: END IF;
2925: IF l_debug_level > 0 then
2986: NOT OE_GLOBALS.Equal(p_line_rec.arrival_set_id,
2987: l_arrival_set_id)) AND
2988: OE_ORDER_SCH_UTIL.OESCH_PERFORM_SCHEDULING = 'Y' THEN
2989:
2990: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_SET_OPR');
2991: FND_MESSAGE.SET_TOKEN('ITEMTYPE', p_line_rec.item_type_code);
2992: OE_MSG_PUB.ADD;
2993: IF l_debug_level > 0 then
2994: oe_debug_pub.add('Set- not allowed for this itemtype');
2987: l_arrival_set_id)) AND
2988: OE_ORDER_SCH_UTIL.OESCH_PERFORM_SCHEDULING = 'Y' THEN
2989:
2990: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_SET_OPR');
2991: FND_MESSAGE.SET_TOKEN('ITEMTYPE', p_line_rec.item_type_code);
2992: OE_MSG_PUB.ADD;
2993: IF l_debug_level > 0 then
2994: oe_debug_pub.add('Set- not allowed for this itemtype');
2995: END IF;
3013: oe_debug_pub.add('arrival_set_id : '|| p_line_rec.arrival_set_id,2);
3014: oe_debug_pub.add('arrival_set : '|| p_line_rec.arrival_set,2);
3015: oe_debug_pub.add('Set name - not allowed for this itemtype');
3016: END IF;
3017: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_SET_OPR');
3018: FND_MESSAGE.SET_TOKEN('ITEMTYPE', p_line_rec.item_type_code);
3019: OE_MSG_PUB.ADD;
3020: RETURN FALSE;
3021: END IF; -- set name
3014: oe_debug_pub.add('arrival_set : '|| p_line_rec.arrival_set,2);
3015: oe_debug_pub.add('Set name - not allowed for this itemtype');
3016: END IF;
3017: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_SET_OPR');
3018: FND_MESSAGE.SET_TOKEN('ITEMTYPE', p_line_rec.item_type_code);
3019: OE_MSG_PUB.ADD;
3020: RETURN FALSE;
3021: END IF; -- set name
3022: END IF; -- main
3043: END IF;
3044: x_return_status := FND_API.G_RET_STS_SUCCESS;
3045:
3046: IF LENGTHB(p_line_rec.user_item_description) > 240 THEN
3047: fnd_message.set_name('ONT','ONT_USER_ITEM_DESC_TOO_LONG');
3048: OE_MSG_PUB.Add;
3049: IF l_debug_level > 0 then
3050: Oe_debug_pub.add('The length of user_item_description should not exceed 240 characters for drop ship lines.',3);
3051: END IF;
3143: if l_debug_level > 0 then
3144: oe_debug_pub.add('Blanket Line Number is not supplied: Blanket #:'||
3145: p_line_rec.blanket_number || ', Inventory Item #:'||p_line_rec.inventory_item_id, 2);
3146: end if;
3147: FND_MESSAGE.SET_NAME('ONT', 'OE_BLKT_NO_BLANKET_LINE_NUM');
3148: OE_MSG_PUB.Add;
3149: x_return_status := FND_API.G_RET_STS_ERROR;
3150: END IF;
3151:
3166: if l_debug_level > 0 then
3167: oe_debug_pub.add('Blankets only support standard items', 1);
3168: end if;
3169:
3170: FND_MESSAGE.SET_NAME('ONT', 'OE_BLKT_NON_STANDARD_ITEM');
3171: OE_MSG_PUB.Add;
3172: x_return_status := FND_API.G_RET_STS_ERROR;
3173:
3174: END IF;
3178: if l_debug_level > 0 then
3179: oe_debug_pub.add('Blankets does not support Included items', 1);
3180: end if;
3181:
3182: FND_MESSAGE.SET_NAME('ONT', 'OE_BLKT_INCLUDED_ITEM');
3183: OE_MSG_PUB.Add;
3184: x_return_status := FND_API.G_RET_STS_ERROR;
3185: END IF;
3186:
3187: END IF; -- End of Pack -J changes.
3188: -- Blanket AND Agreement cannot co-exist on release line
3189:
3190: IF p_line_rec.agreement_id IS NOT NULL THEN
3191: FND_MESSAGE.SET_NAME('ONT', 'OE_BLKT_AGREEMENT_EXISTS');
3192: OE_MSG_PUB.Add;
3193: x_return_status := FND_API.G_RET_STS_ERROR;
3194: END IF;
3195:
3291: IF (l_item_id <> p_line_rec.inventory_item_id) THEN
3292: if l_debug_level > 0 then
3293: oe_debug_pub.add('Release does not match blanket line inventory item', 1);
3294: end if;
3295: FND_MESSAGE.SET_NAME('ONT', 'OE_BLKT_INVALID_ATTRIBUTE');
3296: fnd_message.set_token('ATTRIBUTE', OE_Order_Util.Get_Attribute_Name('INVENTORY_ITEM_ID'));
3297: --for bug 3257240
3298: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE', OE_Id_To_Value.Inventory_Item(l_item_id));
3299: OE_MSG_PUB.Add;
3292: if l_debug_level > 0 then
3293: oe_debug_pub.add('Release does not match blanket line inventory item', 1);
3294: end if;
3295: FND_MESSAGE.SET_NAME('ONT', 'OE_BLKT_INVALID_ATTRIBUTE');
3296: fnd_message.set_token('ATTRIBUTE', OE_Order_Util.Get_Attribute_Name('INVENTORY_ITEM_ID'));
3297: --for bug 3257240
3298: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE', OE_Id_To_Value.Inventory_Item(l_item_id));
3299: OE_MSG_PUB.Add;
3300: x_return_status := FND_API.G_RET_STS_ERROR;
3294: end if;
3295: FND_MESSAGE.SET_NAME('ONT', 'OE_BLKT_INVALID_ATTRIBUTE');
3296: fnd_message.set_token('ATTRIBUTE', OE_Order_Util.Get_Attribute_Name('INVENTORY_ITEM_ID'));
3297: --for bug 3257240
3298: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE', OE_Id_To_Value.Inventory_Item(l_item_id));
3299: OE_MSG_PUB.Add;
3300: x_return_status := FND_API.G_RET_STS_ERROR;
3301: END IF;
3302: ELSIF l_item_context = 'CUST' THEN
3305: OR l_item_id <> p_line_rec.inventory_item_id ) THEN
3306: if l_debug_level > 0 then
3307: oe_debug_pub.add('Release does not match blanket line customer item', 1);
3308: end if;
3309: FND_MESSAGE.SET_NAME('ONT', 'OE_BLKT_INVALID_ATTRIBUTE');
3310: fnd_message.set_token('ATTRIBUTE', OE_Order_Util.Get_Attribute_Name('CUSTOMER_ITEM_ID'));
3311: --for bug 3257240
3312: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE', OE_Id_To_Value.Inventory_Item(l_item_id));
3313: OE_MSG_PUB.Add;
3306: if l_debug_level > 0 then
3307: oe_debug_pub.add('Release does not match blanket line customer item', 1);
3308: end if;
3309: FND_MESSAGE.SET_NAME('ONT', 'OE_BLKT_INVALID_ATTRIBUTE');
3310: fnd_message.set_token('ATTRIBUTE', OE_Order_Util.Get_Attribute_Name('CUSTOMER_ITEM_ID'));
3311: --for bug 3257240
3312: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE', OE_Id_To_Value.Inventory_Item(l_item_id));
3313: OE_MSG_PUB.Add;
3314: x_return_status := FND_API.G_RET_STS_ERROR;
3308: end if;
3309: FND_MESSAGE.SET_NAME('ONT', 'OE_BLKT_INVALID_ATTRIBUTE');
3310: fnd_message.set_token('ATTRIBUTE', OE_Order_Util.Get_Attribute_Name('CUSTOMER_ITEM_ID'));
3311: --for bug 3257240
3312: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE', OE_Id_To_Value.Inventory_Item(l_item_id));
3313: OE_MSG_PUB.Add;
3314: x_return_status := FND_API.G_RET_STS_ERROR;
3315: END IF;
3316:
3341: WHERE CATEGORY_ID = l_item_id;
3342: if l_debug_level > 0 then
3343: oe_debug_pub.add('Release does not match blanket line item category', 1);
3344: end if;
3345: FND_MESSAGE.SET_NAME('ONT', 'OE_BLKT_INVALID_ATTRIBUTE');
3346: fnd_message.set_token('ATTRIBUTE', OE_Order_Util.Get_Attribute_Name('INVENTORY_ITEM_ID'));
3347: --for bug 3257240
3348: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE', OE_Id_To_Value.Inventory_Item(l_item_id));
3349: OE_MSG_PUB.Add;
3342: if l_debug_level > 0 then
3343: oe_debug_pub.add('Release does not match blanket line item category', 1);
3344: end if;
3345: FND_MESSAGE.SET_NAME('ONT', 'OE_BLKT_INVALID_ATTRIBUTE');
3346: fnd_message.set_token('ATTRIBUTE', OE_Order_Util.Get_Attribute_Name('INVENTORY_ITEM_ID'));
3347: --for bug 3257240
3348: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE', OE_Id_To_Value.Inventory_Item(l_item_id));
3349: OE_MSG_PUB.Add;
3350: x_return_status := FND_API.G_RET_STS_ERROR;
3344: end if;
3345: FND_MESSAGE.SET_NAME('ONT', 'OE_BLKT_INVALID_ATTRIBUTE');
3346: fnd_message.set_token('ATTRIBUTE', OE_Order_Util.Get_Attribute_Name('INVENTORY_ITEM_ID'));
3347: --for bug 3257240
3348: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE', OE_Id_To_Value.Inventory_Item(l_item_id));
3349: OE_MSG_PUB.Add;
3350: x_return_status := FND_API.G_RET_STS_ERROR;
3351: END;
3352:
3356:
3357: if l_debug_level > 0 then
3358: oe_debug_pub.add('Release does not match blanket line xref item item', 1);
3359: end if;
3360: FND_MESSAGE.SET_NAME('ONT', 'OE_BLKT_INVALID_ATTRIBUTE');
3361: fnd_message.set_token('ATTRIBUTE', OE_Order_Util.Get_Attribute_Name('ORDERED_ITEM'));
3362: --for bug 3257240
3363: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE', OE_Id_To_Value.Inventory_Item(l_item_id));
3364: OE_MSG_PUB.Add;
3357: if l_debug_level > 0 then
3358: oe_debug_pub.add('Release does not match blanket line xref item item', 1);
3359: end if;
3360: FND_MESSAGE.SET_NAME('ONT', 'OE_BLKT_INVALID_ATTRIBUTE');
3361: fnd_message.set_token('ATTRIBUTE', OE_Order_Util.Get_Attribute_Name('ORDERED_ITEM'));
3362: --for bug 3257240
3363: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE', OE_Id_To_Value.Inventory_Item(l_item_id));
3364: OE_MSG_PUB.Add;
3365: x_return_status := FND_API.G_RET_STS_ERROR;
3359: end if;
3360: FND_MESSAGE.SET_NAME('ONT', 'OE_BLKT_INVALID_ATTRIBUTE');
3361: fnd_message.set_token('ATTRIBUTE', OE_Order_Util.Get_Attribute_Name('ORDERED_ITEM'));
3362: --for bug 3257240
3363: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE', OE_Id_To_Value.Inventory_Item(l_item_id));
3364: OE_MSG_PUB.Add;
3365: x_return_status := FND_API.G_RET_STS_ERROR;
3366: END IF;
3367: END IF;
3394: AND STATUS = 'A'
3395: AND ROWNUM = 1;
3396: exception
3397: when no_data_found then
3398: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_ATTRIBUTE');
3399: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name
3400: ('SOLD_TO_ORG_ID'));
3401: --for bug 3257240
3402: OE_Id_To_Value.Sold_To_Org
3395: AND ROWNUM = 1;
3396: exception
3397: when no_data_found then
3398: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_ATTRIBUTE');
3399: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name
3400: ('SOLD_TO_ORG_ID'));
3401: --for bug 3257240
3402: OE_Id_To_Value.Sold_To_Org
3403: ( p_sold_to_org_id => l_sold_to_org_id
3403: ( p_sold_to_org_id => l_sold_to_org_id
3404: , x_org => l_customer_name
3405: , x_customer_number => l_customer_number
3406: );
3407: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE',l_customer_name);
3408: OE_MSG_PUB.Add;
3409: x_return_status := FND_API.G_RET_STS_ERROR;
3410: end;
3411: else
3408: OE_MSG_PUB.Add;
3409: x_return_status := FND_API.G_RET_STS_ERROR;
3410: end;
3411: else
3412: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_ATTRIBUTE');
3413: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name
3414: ('SOLD_TO_ORG_ID'));
3415: --for bug 3257240
3416: OE_Id_To_Value.Sold_To_Org
3409: x_return_status := FND_API.G_RET_STS_ERROR;
3410: end;
3411: else
3412: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_ATTRIBUTE');
3413: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name
3414: ('SOLD_TO_ORG_ID'));
3415: --for bug 3257240
3416: OE_Id_To_Value.Sold_To_Org
3417: ( p_sold_to_org_id => l_sold_to_org_id
3417: ( p_sold_to_org_id => l_sold_to_org_id
3418: , x_org => l_customer_name
3419: , x_customer_number => l_customer_number
3420: );
3421: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE',l_customer_name);
3422: OE_MSG_PUB.Add;
3423: x_return_status := FND_API.G_RET_STS_ERROR;
3424: end if;
3425: END IF;
3437: THEN
3438: if l_debug_level > 0 then
3439: oe_debug_pub.add('Blanket order is currently on hold', 1);
3440: end if;
3441: FND_MESSAGE.SET_NAME('ONT', 'OE_BLKT_ON_HOLD');
3442: OE_MSG_PUB.Add;
3443: x_return_status := FND_API.G_RET_STS_ERROR;
3444: END IF;
3445:
3452: THEN
3453: if l_debug_level > 0 then
3454: oe_debug_pub.add('Blanket is not in Active Status', 1);
3455: end if;
3456: FND_MESSAGE.SET_NAME('ONT', 'OE_BLKT_INVALID_BLANKET');
3457: OE_MSG_PUB.Add;
3458: x_return_status := FND_API.G_RET_STS_ERROR;
3459: END IF;
3460:
3479: THEN
3480: if l_debug_level > 0 then
3481: oe_debug_pub.add('Request date is not within active blanket line dates', 1);
3482: end if;
3483: FND_MESSAGE.SET_NAME('ONT', 'OE_BLKT_INVALID_LINE_REQ_DATE');
3484: OE_MSG_PUB.Add;
3485: x_return_status := FND_API.G_RET_STS_ERROR;
3486: END IF;
3487:
3501: OR NOT OE_GLOBALS.EQUAL(p_line_rec.price_list_id
3502: ,p_old_line_rec.price_list_id) )
3503: THEN
3504: IF l_price_list_id <> p_line_rec.price_list_id THEN
3505: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_ATTRIBUTE');
3506: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name
3507: ('PRICE_LIST_ID'));
3508: --for bug 3257240
3509: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE',OE_Id_To_Value.Price_List(l_price_list_id));
3502: ,p_old_line_rec.price_list_id) )
3503: THEN
3504: IF l_price_list_id <> p_line_rec.price_list_id THEN
3505: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_ATTRIBUTE');
3506: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name
3507: ('PRICE_LIST_ID'));
3508: --for bug 3257240
3509: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE',OE_Id_To_Value.Price_List(l_price_list_id));
3510: OE_MSG_PUB.ADD;
3505: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_ATTRIBUTE');
3506: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name
3507: ('PRICE_LIST_ID'));
3508: --for bug 3257240
3509: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE',OE_Id_To_Value.Price_List(l_price_list_id));
3510: OE_MSG_PUB.ADD;
3511: x_return_status := FND_API.G_RET_STS_ERROR;
3512: END IF;
3513: END IF;
3520: OR NOT OE_GLOBALS.EQUAL(p_line_rec.ship_to_org_id
3521: ,p_old_line_rec.ship_to_org_id) )
3522: THEN
3523: IF l_ship_to_org_id <> p_line_rec.ship_to_org_id THEN
3524: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_ATTRIBUTE');
3525: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name
3526: ('SHIP_TO_ORG_ID'));
3527: --for bug 3257240
3528: OE_ID_TO_VALUE.ship_to_Org
3521: ,p_old_line_rec.ship_to_org_id) )
3522: THEN
3523: IF l_ship_to_org_id <> p_line_rec.ship_to_org_id THEN
3524: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_ATTRIBUTE');
3525: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name
3526: ('SHIP_TO_ORG_ID'));
3527: --for bug 3257240
3528: OE_ID_TO_VALUE.ship_to_Org
3529: ( p_ship_to_org_id => p_line_rec.ship_to_org_id
3537: , x_ship_to_state => l_state
3538: , x_ship_to_postal_code => l_postal_code
3539: , x_ship_to_country => l_country
3540: );
3541: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE',l_org);
3542: OE_MSG_PUB.ADD;
3543: x_return_status := FND_API.G_RET_STS_ERROR;
3544: END IF;
3545: END IF;
3552: OR NOT OE_GLOBALS.EQUAL(p_line_rec.invoice_to_org_id
3553: ,p_old_line_rec.invoice_to_org_id) )
3554: THEN
3555: IF l_invoice_to_org_id <> p_line_rec.invoice_to_org_id THEN
3556: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_ATTRIBUTE');
3557: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name
3558: ('INVOICE_TO_ORG_ID'));
3559: --for bug 3257240
3560: OE_ID_TO_VALUE.Invoice_To_Org
3553: ,p_old_line_rec.invoice_to_org_id) )
3554: THEN
3555: IF l_invoice_to_org_id <> p_line_rec.invoice_to_org_id THEN
3556: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_ATTRIBUTE');
3557: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name
3558: ('INVOICE_TO_ORG_ID'));
3559: --for bug 3257240
3560: OE_ID_TO_VALUE.Invoice_To_Org
3561: ( p_invoice_to_org_id => p_line_rec.invoice_to_org_id
3569: , x_invoice_to_state => l_state
3570: , x_invoice_to_postal_code => l_postal_code
3571: , x_invoice_to_country => l_country
3572: );
3573: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE',l_org);
3574: OE_MSG_PUB.ADD;
3575: x_return_status := FND_API.G_RET_STS_ERROR;
3576: END IF;
3577: END IF;
3584: OR NOT OE_GLOBALS.EQUAL(p_line_rec.freight_terms_code
3585: ,p_old_line_rec.freight_terms_code) )
3586: THEN
3587: IF l_freight_terms_code <> p_line_rec.freight_terms_code THEN
3588: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_ATTRIBUTE');
3589: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name
3590: ('FREIGHT_TERMS_CODE'));
3591: --for bug 3257240
3592: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE',OE_Id_To_Value.Freight_Terms(l_freight_terms_code));
3585: ,p_old_line_rec.freight_terms_code) )
3586: THEN
3587: IF l_freight_terms_code <> p_line_rec.freight_terms_code THEN
3588: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_ATTRIBUTE');
3589: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name
3590: ('FREIGHT_TERMS_CODE'));
3591: --for bug 3257240
3592: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE',OE_Id_To_Value.Freight_Terms(l_freight_terms_code));
3593: OE_MSG_PUB.ADD;
3588: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_ATTRIBUTE');
3589: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name
3590: ('FREIGHT_TERMS_CODE'));
3591: --for bug 3257240
3592: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE',OE_Id_To_Value.Freight_Terms(l_freight_terms_code));
3593: OE_MSG_PUB.ADD;
3594: x_return_status := FND_API.G_RET_STS_ERROR;
3595: END IF;
3596: END IF;
3603: OR NOT OE_GLOBALS.EQUAL(p_line_rec.shipping_method_code
3604: ,p_old_line_rec.shipping_method_code) )
3605: THEN
3606: IF l_shipping_method_code <> p_line_rec.shipping_method_code THEN
3607: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_ATTRIBUTE');
3608: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name
3609: ('SHIPPING_METHOD_CODE'));
3610: --for bug 3257240
3611: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE',OE_Id_To_Value.Ship_Method(l_shipping_method_code));
3604: ,p_old_line_rec.shipping_method_code) )
3605: THEN
3606: IF l_shipping_method_code <> p_line_rec.shipping_method_code THEN
3607: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_ATTRIBUTE');
3608: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name
3609: ('SHIPPING_METHOD_CODE'));
3610: --for bug 3257240
3611: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE',OE_Id_To_Value.Ship_Method(l_shipping_method_code));
3612: OE_MSG_PUB.ADD;
3607: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_ATTRIBUTE');
3608: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name
3609: ('SHIPPING_METHOD_CODE'));
3610: --for bug 3257240
3611: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE',OE_Id_To_Value.Ship_Method(l_shipping_method_code));
3612: OE_MSG_PUB.ADD;
3613: x_return_status := FND_API.G_RET_STS_ERROR;
3614: END IF;
3615: END IF;
3622: OR NOT OE_GLOBALS.EQUAL(p_line_rec.payment_term_id
3623: ,p_old_line_rec.payment_term_id) )
3624: THEN
3625: IF l_payment_term_id <> p_line_rec.payment_term_id THEN
3626: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_ATTRIBUTE');
3627: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name
3628: ('PAYMENT_TERM_ID'));
3629: --for bug 3257240
3630: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE',OE_Id_To_Value.Payment_Term(l_payment_term_id));
3623: ,p_old_line_rec.payment_term_id) )
3624: THEN
3625: IF l_payment_term_id <> p_line_rec.payment_term_id THEN
3626: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_ATTRIBUTE');
3627: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name
3628: ('PAYMENT_TERM_ID'));
3629: --for bug 3257240
3630: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE',OE_Id_To_Value.Payment_Term(l_payment_term_id));
3631: OE_MSG_PUB.ADD;
3626: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_ATTRIBUTE');
3627: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name
3628: ('PAYMENT_TERM_ID'));
3629: --for bug 3257240
3630: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE',OE_Id_To_Value.Payment_Term(l_payment_term_id));
3631: OE_MSG_PUB.ADD;
3632: x_return_status := FND_API.G_RET_STS_ERROR;
3633: END IF;
3634: END IF;
3641: OR NOT OE_GLOBALS.EQUAL(p_line_rec.accounting_rule_id
3642: ,p_old_line_rec.accounting_rule_id) )
3643: THEN
3644: IF l_accounting_rule_id <> p_line_rec.accounting_rule_id THEN
3645: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_ATTRIBUTE');
3646: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name
3647: ('ACCOUNTING_RULE_ID'));
3648: --for bug 3257240
3649: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE',OE_Id_To_Value.Accounting_Rule(l_accounting_rule_id));
3642: ,p_old_line_rec.accounting_rule_id) )
3643: THEN
3644: IF l_accounting_rule_id <> p_line_rec.accounting_rule_id THEN
3645: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_ATTRIBUTE');
3646: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name
3647: ('ACCOUNTING_RULE_ID'));
3648: --for bug 3257240
3649: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE',OE_Id_To_Value.Accounting_Rule(l_accounting_rule_id));
3650: OE_MSG_PUB.ADD;
3645: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_ATTRIBUTE');
3646: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name
3647: ('ACCOUNTING_RULE_ID'));
3648: --for bug 3257240
3649: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE',OE_Id_To_Value.Accounting_Rule(l_accounting_rule_id));
3650: OE_MSG_PUB.ADD;
3651: x_return_status := FND_API.G_RET_STS_ERROR;
3652: END IF;
3653: END IF;
3660: OR NOT OE_GLOBALS.EQUAL(p_line_rec.invoicing_rule_id
3661: ,p_old_line_rec.invoicing_rule_id) )
3662: THEN
3663: IF l_invoicing_rule_id <> p_line_rec.invoicing_rule_id THEN
3664: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_ATTRIBUTE');
3665: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name
3666: ('INVOICING_RULE_ID'));
3667: --for bug 3257240
3668: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE',OE_Id_To_Value.Invoicing_Rule(l_invoicing_rule_id));
3661: ,p_old_line_rec.invoicing_rule_id) )
3662: THEN
3663: IF l_invoicing_rule_id <> p_line_rec.invoicing_rule_id THEN
3664: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_ATTRIBUTE');
3665: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name
3666: ('INVOICING_RULE_ID'));
3667: --for bug 3257240
3668: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE',OE_Id_To_Value.Invoicing_Rule(l_invoicing_rule_id));
3669: OE_MSG_PUB.ADD;
3664: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_ATTRIBUTE');
3665: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name
3666: ('INVOICING_RULE_ID'));
3667: --for bug 3257240
3668: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE',OE_Id_To_Value.Invoicing_Rule(l_invoicing_rule_id));
3669: OE_MSG_PUB.ADD;
3670: x_return_status := FND_API.G_RET_STS_ERROR;
3671: END IF;
3672: END IF;
3676: if l_debug_level > 0 then
3677: oe_debug_pub.add('Blanket Values combination is not valid: Blanket #:'||
3678: p_line_rec.blanket_number || ', Blanket Line #:'||p_line_rec.blanket_line_number, 2);
3679: end if;
3680: FND_MESSAGE.SET_NAME('ONT', 'OE_BLKT_INVALID_BLANKET');
3681: OE_MSG_PUB.Add;
3682: x_return_status := FND_API.G_RET_STS_ERROR;
3683:
3684: WHEN FND_API.G_EXC_ERROR THEN
3962: THEN
3963:
3964: l_return_status := FND_API.G_RET_STS_ERROR;
3965:
3966: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
3967: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
3968: OE_Order_UTIL.Get_Attribute_Name('LINE_ID'));
3969: OE_MSG_PUB.Add;
3970:
3963:
3964: l_return_status := FND_API.G_RET_STS_ERROR;
3965:
3966: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
3967: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
3968: OE_Order_UTIL.Get_Attribute_Name('LINE_ID'));
3969: OE_MSG_PUB.Add;
3970:
3971: END IF;
3976: THEN
3977:
3978: l_return_status := FND_API.G_RET_STS_ERROR;
3979:
3980: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
3981: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
3982: OE_Order_UTIL.Get_Attribute_Name('INVENTORY_ITEM_ID'));
3983: OE_MSG_PUB.Add;
3984:
3977:
3978: l_return_status := FND_API.G_RET_STS_ERROR;
3979:
3980: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
3981: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
3982: OE_Order_UTIL.Get_Attribute_Name('INVENTORY_ITEM_ID'));
3983: OE_MSG_PUB.Add;
3984:
3985: END IF;
3990: THEN
3991:
3992: l_return_status := FND_API.G_RET_STS_ERROR;
3993:
3994: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
3995: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
3996: OE_Order_UTIL.Get_Attribute_Name('LINE_TYPE_ID'));
3997: OE_MSG_PUB.Add;
3998:
3991:
3992: l_return_status := FND_API.G_RET_STS_ERROR;
3993:
3994: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
3995: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
3996: OE_Order_UTIL.Get_Attribute_Name('LINE_TYPE_ID'));
3997: OE_MSG_PUB.Add;
3998:
3999: ELSIF p_line_rec.line_type_id IS NOT NULL AND -- Bug 5873408
4014: AND p_line_rec.arrival_set <> FND_API.G_MISS_char ))
4015: THEN
4016:
4017: IF p_line_rec.ship_from_org_id IS NULL THEN
4018: FND_MESSAGE.SET_NAME('ONT','ONT_ATTR_REQ_SET');
4019: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',oe_order_util.GET_ATTRIBUTE_name('SHIP_FROM_ORG_ID'));
4020: OE_MSG_PUB.ADD;
4021: RAISE FND_API.G_EXC_ERROR;
4022: END IF ;
4015: THEN
4016:
4017: IF p_line_rec.ship_from_org_id IS NULL THEN
4018: FND_MESSAGE.SET_NAME('ONT','ONT_ATTR_REQ_SET');
4019: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',oe_order_util.GET_ATTRIBUTE_name('SHIP_FROM_ORG_ID'));
4020: OE_MSG_PUB.ADD;
4021: RAISE FND_API.G_EXC_ERROR;
4022: END IF ;
4023:
4021: RAISE FND_API.G_EXC_ERROR;
4022: END IF ;
4023:
4024: /* IF p_line_rec.shipping_method_code IS NULL THEN
4025: FND_MESSAGE.SET_NAME('ONT','ONT_ATTR_REQ_SET'); --rakesh
4026: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Ship Method');
4027: OE_MSG_PUB.ADD;
4028: RAISE FND_API.G_EXC_ERROR;
4029: END IF ; */
4022: END IF ;
4023:
4024: /* IF p_line_rec.shipping_method_code IS NULL THEN
4025: FND_MESSAGE.SET_NAME('ONT','ONT_ATTR_REQ_SET'); --rakesh
4026: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Ship Method');
4027: OE_MSG_PUB.ADD;
4028: RAISE FND_API.G_EXC_ERROR;
4029: END IF ; */
4030:
4037: AND p_line_rec.ship_set <> FND_API.G_MISS_char ))
4038: THEN
4039:
4040: IF p_line_rec.ship_from_org_id IS NULL THEN
4041: FND_MESSAGE.SET_NAME('ONT','ONT_ATTR_REQ_SET');
4042: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',oe_order_util.GET_ATTRIBUTE_name('SHIP_FROM_ORG_ID'));
4043: OE_MSG_PUB.ADD;
4044: RAISE FND_API.G_EXC_ERROR;
4045: END IF ;
4038: THEN
4039:
4040: IF p_line_rec.ship_from_org_id IS NULL THEN
4041: FND_MESSAGE.SET_NAME('ONT','ONT_ATTR_REQ_SET');
4042: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',oe_order_util.GET_ATTRIBUTE_name('SHIP_FROM_ORG_ID'));
4043: OE_MSG_PUB.ADD;
4044: RAISE FND_API.G_EXC_ERROR;
4045: END IF ;
4046:
4044: RAISE FND_API.G_EXC_ERROR;
4045: END IF ;
4046:
4047: /* IF p_line_rec.shipping_method_code IS NULL THEN
4048: FND_MESSAGE.SET_NAME('ONT','ONT_ATTR_REQ_SET'); --rakesh
4049: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Ship Method');
4050: OE_MSG_PUB.ADD;
4051: RAISE FND_API.G_EXC_ERROR;
4052: END IF ; */
4045: END IF ;
4046:
4047: /* IF p_line_rec.shipping_method_code IS NULL THEN
4048: FND_MESSAGE.SET_NAME('ONT','ONT_ATTR_REQ_SET'); --rakesh
4049: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Ship Method');
4050: OE_MSG_PUB.ADD;
4051: RAISE FND_API.G_EXC_ERROR;
4052: END IF ; */
4053: END IF ;
4079:
4080: If(NVL(P_LINE_REC.subscription_enable_flag,'N') <> 'Y') then -- sol_ord_er #16014165
4081: IF NVL(P_LINE_REC.SERVICE_REFERENCE_TYPE_CODE, FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN
4082: l_return_status := FND_API.G_RET_STS_ERROR;
4083: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
4084: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', oe_order_util.get_attribute_name('SERVICE_REFERENCE_TYPE_CODE'));
4085: OE_MSG_PUB.Add;
4086: ELSIF NVL(P_LINE_REC.SERVICE_REFERENCE_LINE_ID, FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN
4087: -- Bug 16561155
4080: If(NVL(P_LINE_REC.subscription_enable_flag,'N') <> 'Y') then -- sol_ord_er #16014165
4081: IF NVL(P_LINE_REC.SERVICE_REFERENCE_TYPE_CODE, FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN
4082: l_return_status := FND_API.G_RET_STS_ERROR;
4083: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
4084: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', oe_order_util.get_attribute_name('SERVICE_REFERENCE_TYPE_CODE'));
4085: OE_MSG_PUB.Add;
4086: ELSIF NVL(P_LINE_REC.SERVICE_REFERENCE_LINE_ID, FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN
4087: -- Bug 16561155
4088: IF NVL(P_LINE_REC.SERVICE_REFERENCE_TYPE_CODE, FND_API.G_MISS_CHAR) = 'CUSTOMER_PRODUCT' THEN
4086: ELSIF NVL(P_LINE_REC.SERVICE_REFERENCE_LINE_ID, FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN
4087: -- Bug 16561155
4088: IF NVL(P_LINE_REC.SERVICE_REFERENCE_TYPE_CODE, FND_API.G_MISS_CHAR) = 'CUSTOMER_PRODUCT' THEN
4089: l_return_status := FND_API.G_RET_STS_ERROR;
4090: fnd_message.set_name('ONT','ONT_SERV_REF_CUST_PROD_REQD');
4091: OE_MSG_PUB.Add;
4092: ELSE
4093: -- Bug 16561155
4094: l_return_status := FND_API.G_RET_STS_ERROR;
4091: OE_MSG_PUB.Add;
4092: ELSE
4093: -- Bug 16561155
4094: l_return_status := FND_API.G_RET_STS_ERROR;
4095: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
4096: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', oe_order_util.get_attribute_name('SERVICE_REFERENCE_LINE_ID'));
4097: OE_MSG_PUB.Add;
4098: END IF;
4099: END IF;
4092: ELSE
4093: -- Bug 16561155
4094: l_return_status := FND_API.G_RET_STS_ERROR;
4095: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
4096: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', oe_order_util.get_attribute_name('SERVICE_REFERENCE_LINE_ID'));
4097: OE_MSG_PUB.Add;
4098: END IF;
4099: END IF;
4100: end if; -- sol_ord_er #16014165
4115: oe_debug_pub.ADD('Product item serviceable flag is '||l_serviceable_product_flag,1);
4116:
4117: IF Nvl(l_serviceable_product_flag,'N') <> 'Y' OR l_flow_status_code = 'CANCELLED' THEN
4118: l_return_status := FND_API.G_RET_STS_ERROR;
4119: fnd_message.set_name('ONT','ONT_PRD_LINE_NOT_SRV');
4120: OE_MSG_PUB.Add;
4121: END IF;
4122:
4123: END IF;
4132: -- If Billing Option involves Contract, Billing Profile is required
4133: IF (NVL(P_LINE_REC.service_bill_option_code,'FBOM') <> 'FBOM'
4134: and NVL(P_LINE_REC.service_bill_profile_id,FND_API.G_MISS_NUM)= FND_API.G_MISS_NUM) THEN
4135: l_return_status := FND_API.G_RET_STS_ERROR;
4136: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
4137: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', oe_order_util.get_attribute_name('SERVICE_BILL_PROFILE_ID'));
4138: OE_MSG_PUB.Add;
4139: End IF;
4140: End If;
4133: IF (NVL(P_LINE_REC.service_bill_option_code,'FBOM') <> 'FBOM'
4134: and NVL(P_LINE_REC.service_bill_profile_id,FND_API.G_MISS_NUM)= FND_API.G_MISS_NUM) THEN
4135: l_return_status := FND_API.G_RET_STS_ERROR;
4136: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
4137: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', oe_order_util.get_attribute_name('SERVICE_BILL_PROFILE_ID'));
4138: OE_MSG_PUB.Add;
4139: End IF;
4140: End If;
4141: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4159: ELSE
4160:
4161: -- Feature not supported prior to 11i10, raise error
4162: IF p_line_rec.transaction_phase_code = 'N' THEN
4163: FND_MESSAGE.SET_NAME('ONT','OE_QUOTE_INVALID_RELEASE');
4164: OE_MSG_PUB.ADD;
4165: RAISE FND_API.G_EXC_ERROR;
4166: END IF;
4167:
4179: IF p_line_rec.return_reason_code is NULL
4180: THEN
4181: l_return_status := FND_API.G_RET_STS_ERROR;
4182:
4183: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
4184: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
4185: OE_Order_UTIL.Get_Attribute_Name('RETURN_REASON_CODE'));
4186: OE_MSG_PUB.Add;
4187: END IF;
4180: THEN
4181: l_return_status := FND_API.G_RET_STS_ERROR;
4182:
4183: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
4184: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
4185: OE_Order_UTIL.Get_Attribute_Name('RETURN_REASON_CODE'));
4186: OE_MSG_PUB.Add;
4187: END IF;
4188:
4253: p_line_id => p_line_rec.line_id,
4254: p_sch_level => l_scheduling_level_code) THEN
4255: NULL;
4256: ELSE
4257: FND_MESSAGE.SET_NAME('ONT', 'OE_SCH_NONSTANDALONE');
4258: OE_MSG_PUB.Add;
4259: IF l_debug_level > 0 then
4260: oe_debug_pub.add( 'This is a Active Demand set. Inactive Demand lines not allowed', 1 ) ;
4261: END IF;
4261: END IF;
4262: l_return_status := FND_API.G_RET_STS_ERROR;
4263: END IF;
4264: ELSE
4265: FND_MESSAGE.SET_NAME('ONT', 'OE_SCH_INACTIVE_STD_ONLY');
4266: FND_MESSAGE.SET_TOKEN('LTYPE',l_line_type);
4267: OE_MSG_PUB.Add;
4268: l_return_status := FND_API.G_RET_STS_ERROR;
4269: END IF;
4262: l_return_status := FND_API.G_RET_STS_ERROR;
4263: END IF;
4264: ELSE
4265: FND_MESSAGE.SET_NAME('ONT', 'OE_SCH_INACTIVE_STD_ONLY');
4266: FND_MESSAGE.SET_TOKEN('LTYPE',l_line_type);
4267: OE_MSG_PUB.Add;
4268: l_return_status := FND_API.G_RET_STS_ERROR;
4269: END IF;
4270: ELSIF (p_line_rec.ship_set_id is not null
4277: IF l_debug_level > 0 then
4278: oe_debug_pub.add( 'This is a Inactive Demand set. Active Demand lines not allowed', 1 ) ;
4279: END IF;
4280:
4281: FND_MESSAGE.SET_NAME('ONT', 'OE_SCH_STANDALONE');
4282: OE_MSG_PUB.Add;
4283: l_return_status := FND_API.G_RET_STS_ERROR;
4284: END IF;
4285:
4293: IF l_debug_level > 0 then
4294: oe_debug_pub.add( 'A SERVICE LINE ', 1 ) ;
4295: END IF;
4296:
4297: FND_MESSAGE.SET_NAME('ONT','OE_SCH_NO_ACTION_DONE_NO_EXP');
4298: OE_MSG_PUB.Add;
4299: l_return_status := FND_API.G_RET_STS_ERROR;
4300: END IF;
4301: ---- End 2720165 --
4320: WHERE organization_id = p_line_rec.ship_from_org_id
4321: AND secondary_inventory_name = p_line_rec.subinventory;
4322: EXCEPTION
4323: WHEN OTHERS THEN
4324: fnd_message.set_name('ONT','OE_SUBINV_INVALID');
4325: OE_MSG_PUB.Add;
4326: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4327: END;
4328: END IF;
4332: IF nvl(p_line_rec.shipment_number,FND_API.G_MISS_NUM) <> nvl(p_old_line_rec.shipment_number,FND_API.G_MISS_NUM)
4333: AND p_line_rec.operation =OE_GLOBALS.G_OPR_UPDATE
4334: AND nvl(p_line_rec.split_action_code,'X')<>'SPLIT'
4335: THEN
4336: fnd_message.set_name('ONT','OE_CANT_UPDATE_SHIPMENT_NO');
4337: OE_MSG_PUB.Add;
4338: l_return_status:=FND_API.G_RET_STS_ERROR;
4339: END IF;
4340:
4345: oe_debug_pub.add('Entity Validateion: subinventory', 1);
4346: END IF;
4347: IF p_line_rec.ship_from_org_id is null THEN
4348: l_return_status := FND_API.G_RET_STS_ERROR;
4349: fnd_message.set_name('ONT', 'OE_ATTRIBUTE_REQUIRED');
4350: fnd_message.set_token('ATTRIBUTE',OE_Order_UTIL.Get_Attribute_Name('SHIP_FROM_ORG_ID'));
4351: OE_MSG_PUB.Add;
4352: ELSE
4353: -- validate the subinv is allowed (expense/asset)
4346: END IF;
4347: IF p_line_rec.ship_from_org_id is null THEN
4348: l_return_status := FND_API.G_RET_STS_ERROR;
4349: fnd_message.set_name('ONT', 'OE_ATTRIBUTE_REQUIRED');
4350: fnd_message.set_token('ATTRIBUTE',OE_Order_UTIL.Get_Attribute_Name('SHIP_FROM_ORG_ID'));
4351: OE_MSG_PUB.Add;
4352: ELSE
4353: -- validate the subinv is allowed (expense/asset)
4354: -- because defaulting can be defaulting an expense sub
4398: and secondary_inventory = p_line_rec.subinventory;
4399: EXCEPTION
4400: WHEN OTHERS THEN
4401: l_return_status := FND_API.G_RET_STS_ERROR;
4402: fnd_message.set_name('ONT', 'OE_SUBINV_INVALID');
4403: oe_msg_pub.add;
4404: END;
4405: ELSE -- not a restricted subinv case
4406: BEGIN
4434: );
4435: EXCEPTION
4436: WHEN OTHERS THEN
4437: l_return_status := FND_API.G_RET_STS_ERROR;
4438: fnd_message.set_name('ONT', 'OE_SUBINV_NON_ASSET');
4439: oe_msg_pub.add;
4440: END;
4441: END IF; -- restrict subinv or not
4442: END IF;
4441: END IF; -- restrict subinv or not
4442: END IF;
4443: ELSE -- external
4444: l_return_status := FND_API.G_RET_STS_ERROR;
4445: fnd_message.set_name('ONT', 'OE_SUBINV_EXTERNAL');
4446: OE_MSG_PUB.Add;
4447: END IF;
4448: END IF;
4449:
4510: AND effectivity_date<=sysdate
4511: AND revision= p_line_rec.item_revision;
4512: EXCEPTION
4513: WHEN NO_DATA_FOUND THEN
4514: fnd_message.set_name('ONT','ONT_REV_WH_NOT_EXIST');
4515: OE_MSG_PUB.Add;
4516: l_return_status := FND_API.G_RET_STS_ERROR;
4517: END;
4518: IF p_line_rec.reference_line_id is NOT NULL AND
4544:
4545: IF l_notnull_revision_flag = 'Y' AND
4546: l_tot_transaction_quantity = 0
4547: THEN
4548: fnd_message.set_name('ONT','ONT_ITEM_REV_MISMATCH');
4549: OE_MSG_PUB.Add;
4550: END IF;
4551:
4552: IF l_tot_transaction_quantity > 0
4576: END IF;
4577: IF (l_tot_transaction_quantity - NVL(l_quantity_entered,0))
4578: < p_line_rec.ordered_quantity
4579: THEN
4580: fnd_message.set_name('ONT','ONT_RMA_EXCEED_SHIP_QTY');
4581: OE_MSG_PUB.Add;
4582: l_return_status := FND_API.G_RET_STS_ERROR;
4583: END IF;
4584: END IF; -- IF l_tot_transaction_quantity > 0
4611: IF l_debug_level > 0 THEN
4612: oe_debug_pub.add('dual X-VAL qty 1 not empty', 2);
4613: END IF;
4614: l_return_status := FND_API.G_RET_STS_ERROR;
4615: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
4616: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Ordered_Quantity2');
4617: OE_MSG_PUB.Add;
4618:
4619: ELSIF (p_line_rec.ordered_quantity2 <> FND_API.G_MISS_NUM OR
4612: oe_debug_pub.add('dual X-VAL qty 1 not empty', 2);
4613: END IF;
4614: l_return_status := FND_API.G_RET_STS_ERROR;
4615: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
4616: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Ordered_Quantity2');
4617: OE_MSG_PUB.Add;
4618:
4619: ELSIF (p_line_rec.ordered_quantity2 <> FND_API.G_MISS_NUM OR
4620: p_line_rec.ordered_quantity2 IS NOT NULL) AND
4621: (p_old_line_rec.ordered_quantity = FND_API.G_MISS_NUM OR
4622: p_line_rec.ordered_quantity IS NULL) THEN
4623:
4624: l_return_status := FND_API.G_RET_STS_ERROR;
4625: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
4626: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Ordered_Quantity');
4627: OE_MSG_PUB.Add;
4628: END IF;
4629: -- END IF; INVCONV
4622: p_line_rec.ordered_quantity IS NULL) THEN
4623:
4624: l_return_status := FND_API.G_RET_STS_ERROR;
4625: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
4626: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Ordered_Quantity');
4627: OE_MSG_PUB.Add;
4628: END IF;
4629: -- END IF; INVCONV
4630:
4731: l_delta_qty2 := p_line_rec.ordered_quantity2 - nvl(l_req_qty2,0);
4732:
4733: IF ( l_delta_qty1 > 0 AND l_delta_qty2 <= 0) OR (l_delta_qty2 > 0 AND l_delta_qty1 <= 0) THEN
4734: l_return_status := FND_API.G_RET_STS_ERROR;
4735: FND_MESSAGE.set_name('GMI', 'GMI_SHIPPING_SPLIT_DEV_ERR'); -- INVCONV change this message to INV
4736: OE_MSG_PUB.Add;
4737: END IF;
4738:
4739: IF (l_delta_qty1 > 0) AND (l_delta_qty2 > 0) THEN
4840: l_valid_line_number := 'N';
4841: END;
4842:
4843: IF l_valid_line_number = 'N' THEN
4844: FND_MESSAGE.SET_NAME('ONT','OE_LINE_NUMBER_EXISTS');
4845: OE_MSG_PUB.ADD;
4846: /* x_return_status := FND_API.G_RET_STS_ERROR; This line replaced with next for 2068070 */
4847: l_return_status := FND_API.G_RET_STS_ERROR;
4848: END IF;
5185: -- Schedule_Ship_Date and schedule_Arrival_date. We should not
5186: -- error out for this item.
5187:
5188: IF p_line_rec.item_type_code <> OE_GLOBALS.G_ITEM_CONFIG THEN
5189: FND_MESSAGE.SET_NAME('ONT','OE_SCH_INVALID_CHANGE');
5190: OE_MSG_PUB.Add;
5191: l_return_status := FND_API.G_RET_STS_ERROR;
5192: END IF;
5193:
5222: IF (p_line_rec.project_id IS NOT NULL
5223: AND p_line_rec.ship_from_org_id IS NULL) THEN
5224:
5225: l_return_status := FND_API.G_RET_STS_ERROR;
5226: FND_MESSAGE.SET_NAME('ONT', 'OE_SHIP_FROM_REQD');
5227: OE_MSG_PUB.add;
5228: ELSIF (p_line_rec.task_id IS NOT NULL AND
5229: p_line_rec.project_id IS NULL) THEN
5230:
5228: ELSIF (p_line_rec.task_id IS NOT NULL AND
5229: p_line_rec.project_id IS NULL) THEN
5230:
5231: l_return_status := FND_API.G_RET_STS_ERROR;
5232: FND_MESSAGE.SET_NAME('ONT', 'OE_VAL_PROJECT_REQD');
5233: OE_MSG_PUB.add;
5234: END IF;
5235:
5236: -- Added Code for Enhanced Project Validation and Controls.
5304: (p_line_rec.project_id,
5305: p_line_rec.ship_from_org_id) IS NULL THEN
5306:
5307: l_return_status := FND_API.G_RET_STS_ERROR;
5308: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_SHIP_FROM_PROJ');
5309: OE_MSG_PUB.add;
5310: END IF;
5311:
5312: END IF;
5314: IF (p_line_rec.task_id IS NOT NULL
5315: AND p_line_rec.project_id IS NULL) THEN
5316:
5317: l_return_status := FND_API.G_RET_STS_ERROR;
5318: FND_MESSAGE.SET_NAME('ONT', 'OE_VAL_PROJECT_REQD');
5319: OE_MSG_PUB.add;
5320:
5321: ELSIF (p_line_rec.task_id is NOT NULL
5322: AND p_line_rec.project_id IS NOT NULL) THEN
5326: p_line_rec.task_id) THEN
5327:
5328: l_return_status := FND_API.G_RET_STS_ERROR;
5329: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'TASK_ID');
5330: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
5331: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
5332: OE_Order_Util.Get_Attribute_Name('task_id'));
5333: OE_MSG_PUB.Add;
5334: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
5327:
5328: l_return_status := FND_API.G_RET_STS_ERROR;
5329: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'TASK_ID');
5330: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
5331: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
5332: OE_Order_Util.Get_Attribute_Name('task_id'));
5333: OE_MSG_PUB.Add;
5334: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
5335:
5342: p_line_rec.project_id,
5343: p_line_rec.ship_from_org_id) THEN
5344:
5345: l_return_status := FND_API.G_RET_STS_ERROR;
5346: FND_MESSAGE.SET_NAME('ONT', 'OE_VAL_TASK_REQD');
5347: OE_MSG_PUB.ADD;
5348:
5349: END IF;
5350:
5363: (p_line_rec.inventory_item_id,p_line_rec.ship_from_org_id) = 'Y'
5364: THEN
5365:
5366: l_return_status := FND_API.G_RET_STS_ERROR;
5367: fnd_message.set_name('ONT', 'OE_UEFF_NUMBER_REQD');
5368: OE_MSG_PUB.add;
5369: END IF;
5370:
5371: END IF;
5380: p_old_line_rec.end_item_unit_number))
5381: THEN
5382:
5383: l_return_status := FND_API.G_RET_STS_ERROR;
5384: fnd_message.set_name('ONT', 'OE_PJM_NOT_INSTALLED');
5385: OE_MSG_PUB.add;
5386:
5387: END IF;
5388:
5404:
5405: IF (NOT OE_GLOBALS.EQUAL(p_line_rec.project_id,
5406: p_old_line_rec.project_id)) THEN
5407: l_return_status := FND_API.G_RET_STS_ERROR;
5408: FND_MESSAGE.SET_NAME('ONT', 'OE_VAL_PROJ_UPD');
5409: OE_MSG_PUB.add;
5410: ELSIF (NOT OE_GLOBALS.EQUAL(p_line_rec.task_id,
5411: p_old_line_rec.task_id)) THEN
5412: l_return_status := FND_API.G_RET_STS_ERROR;
5409: OE_MSG_PUB.add;
5410: ELSIF (NOT OE_GLOBALS.EQUAL(p_line_rec.task_id,
5411: p_old_line_rec.task_id)) THEN
5412: l_return_status := FND_API.G_RET_STS_ERROR;
5413: FND_MESSAGE.SET_NAME('ONT', 'OE_VAL_TASK_UPD');
5414: OE_MSG_PUB.add;
5415: END IF;
5416:
5417: END IF;
5445: , p_line_rec.operation /*Bug 1805985 add*/
5446: )
5447: THEN
5448: l_return_status := FND_API.G_RET_STS_ERROR;
5449: fnd_message.set_name('ONT', 'OE_ITEM_VALIDATION_FAILED');
5450: OE_MSG_PUB.add;
5451: END IF;
5452:
5453: END IF;
5463: OR p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_MODEL )) then
5464:
5465: IF NOT OE_ITORD_UTIL.Validate_Item_Orderability(p_line_rec) then
5466: l_return_status := FND_API.G_RET_STS_ERROR;
5467: fnd_message.set_name('ONT', 'OE_ITORD_VALIDATION_FAILED');
5468: fnd_message.set_token('ITEM',OE_ITORD_UTIL.get_item_name(p_line_rec.inventory_item_id));
5469: fnd_message.set_token('CATEGORY',OE_ITORD_UTIL.get_item_category_name(p_line_rec.inventory_item_id));
5470: OE_MSG_PUB.add;
5471: END IF;
5464:
5465: IF NOT OE_ITORD_UTIL.Validate_Item_Orderability(p_line_rec) then
5466: l_return_status := FND_API.G_RET_STS_ERROR;
5467: fnd_message.set_name('ONT', 'OE_ITORD_VALIDATION_FAILED');
5468: fnd_message.set_token('ITEM',OE_ITORD_UTIL.get_item_name(p_line_rec.inventory_item_id));
5469: fnd_message.set_token('CATEGORY',OE_ITORD_UTIL.get_item_category_name(p_line_rec.inventory_item_id));
5470: OE_MSG_PUB.add;
5471: END IF;
5472: END IF;
5465: IF NOT OE_ITORD_UTIL.Validate_Item_Orderability(p_line_rec) then
5466: l_return_status := FND_API.G_RET_STS_ERROR;
5467: fnd_message.set_name('ONT', 'OE_ITORD_VALIDATION_FAILED');
5468: fnd_message.set_token('ITEM',OE_ITORD_UTIL.get_item_name(p_line_rec.inventory_item_id));
5469: fnd_message.set_token('CATEGORY',OE_ITORD_UTIL.get_item_category_name(p_line_rec.inventory_item_id));
5470: OE_MSG_PUB.add;
5471: END IF;
5472: END IF;
5473:
5488: , p_line_rec.inventory_item_id
5489: )
5490: THEN
5491: l_return_status := FND_API.G_RET_STS_ERROR;
5492: fnd_message.set_name('ONT', 'OE_RETURN_ITEM_MISMATCH_REJECT');
5493: OE_MSG_PUB.add;
5494: END IF;
5495: END IF;
5496: IF l_debug_level > 0 then
5507: ( p_line_rec.reference_line_id
5508: )
5509: THEN
5510: l_return_status := FND_API.G_RET_STS_ERROR;
5511: fnd_message.set_name('ONT', 'OE_UNFULFILLED_LINE_REJECT');
5512: OE_MSG_PUB.add;
5513: END IF;
5514:
5515: END IF;
5560: oe_debug_pub.add('RMA line is already received', 1);
5561: END IF;
5562:
5563: l_return_status := FND_API.G_RET_STS_ERROR;
5564: fnd_message.set_name('ONT','OE_RMA_RECEIVED');
5565: OE_MSG_PUB.Add;
5566: END IF;
5567: --End Bug 16574899
5568:
5615: p_line_rec.cancelled_flag <> 'Y' and
5616: NVL(p_line_rec.ordered_quantity,1) <> 1)
5617: THEN
5618: l_return_status := FND_API.G_RET_STS_ERROR;
5619: fnd_message.set_name('ONT','OE_SERIAL_REFERENCED_RMA');
5620: OE_MSG_PUB.Add;
5621: END IF;
5622:
5623: IF l_debug_level > 0 then
5646: end if;
5647: ELSE
5648:
5649: l_return_status := FND_API.G_RET_STS_ERROR;
5650: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
5651: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
5652: OE_Order_Util.Get_Attribute_Name('ship_to_org_id'));
5653: OE_MSG_PUB.Add;
5654: END IF;
5647: ELSE
5648:
5649: l_return_status := FND_API.G_RET_STS_ERROR;
5650: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
5651: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
5652: OE_Order_Util.Get_Attribute_Name('ship_to_org_id'));
5653: OE_MSG_PUB.Add;
5654: END IF;
5655: END IF;
5698: OE_DEBUG_PUB.Add('Setting ship_to_contact_id to NULL',1);
5699: end if;
5700: ELSE
5701: l_return_status := FND_API.G_RET_STS_ERROR;
5702: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
5703: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
5704: OE_Order_Util.Get_Attribute_Name('ship_to_contact_id'));
5705: OE_MSG_PUB.Add;
5706: END IF;
5699: end if;
5700: ELSE
5701: l_return_status := FND_API.G_RET_STS_ERROR;
5702: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
5703: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
5704: OE_Order_Util.Get_Attribute_Name('ship_to_contact_id'));
5705: OE_MSG_PUB.Add;
5706: END IF;
5707: WHEN OTHERS THEN
5738: OE_DEBUG_PUB.Add('Setting deliver_to_org_id to NULL',1);
5739: end if;
5740: ELSE
5741: l_return_status := FND_API.G_RET_STS_ERROR;
5742: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
5743: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
5744: OE_Order_Util.Get_Attribute_Name('deliver_to_org_id'));
5745: OE_MSG_PUB.Add;
5746: END IF;
5739: end if;
5740: ELSE
5741: l_return_status := FND_API.G_RET_STS_ERROR;
5742: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
5743: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
5744: OE_Order_Util.Get_Attribute_Name('deliver_to_org_id'));
5745: OE_MSG_PUB.Add;
5746: END IF;
5747: END IF;
5792: OE_DEBUG_PUB.Add('Setting deliver_to_contact_id to NULL',1);
5793: end if;
5794: ELSE
5795: l_return_status := FND_API.G_RET_STS_ERROR;
5796: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
5797: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
5798: OE_Order_Util.Get_Attribute_Name('deliver_to_contact_id'));
5799: OE_MSG_PUB.Add;
5800: END IF;
5793: end if;
5794: ELSE
5795: l_return_status := FND_API.G_RET_STS_ERROR;
5796: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
5797: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
5798: OE_Order_Util.Get_Attribute_Name('deliver_to_contact_id'));
5799: OE_MSG_PUB.Add;
5800: END IF;
5801: WHEN OTHERS THEN
5884: OE_DEBUG_PUB.Add('Setting invoice_to_org_id to MISSING',1);
5885: end if;
5886: ELSE
5887: l_return_status := FND_API.G_RET_STS_ERROR;
5888: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
5889: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
5890: OE_Order_Util.Get_Attribute_Name('invoice_to_org_id'));
5891: OE_MSG_PUB.Add;
5892: END IF;
5885: end if;
5886: ELSE
5887: l_return_status := FND_API.G_RET_STS_ERROR;
5888: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
5889: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
5890: OE_Order_Util.Get_Attribute_Name('invoice_to_org_id'));
5891: OE_MSG_PUB.Add;
5892: END IF;
5893: WHEN OTHERS THEN
5945: OE_DEBUG_PUB.Add('Setting invoice_to_contact_id to NULL',1);
5946: end if;
5947: ELSE
5948: l_return_status := FND_API.G_RET_STS_ERROR;
5949: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
5950: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
5951: OE_Order_Util.Get_Attribute_Name('invoice_to_contact_id'));
5952: OE_MSG_PUB.Add;
5953: END IF;
5946: end if;
5947: ELSE
5948: l_return_status := FND_API.G_RET_STS_ERROR;
5949: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
5950: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
5951: OE_Order_Util.Get_Attribute_Name('invoice_to_contact_id'));
5952: OE_MSG_PUB.Add;
5953: END IF;
5954: WHEN OTHERS THEN
6021: EXCEPTION
6022:
6023: WHEN NO_DATA_FOUND THEN
6024: l_return_status := FND_API.G_RET_STS_ERROR;
6025: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
6026: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
6027: OE_Order_Util.Get_Attribute_Name('TAX_CODE'));
6028: OE_MSG_PUB.Add;
6029:
6022:
6023: WHEN NO_DATA_FOUND THEN
6024: l_return_status := FND_API.G_RET_STS_ERROR;
6025: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
6026: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
6027: OE_Order_Util.Get_Attribute_Name('TAX_CODE'));
6028: OE_MSG_PUB.Add;
6029:
6030: WHEN OTHERS THEN
6050: THEN
6051: l_return_status := FND_API.G_RET_STS_ERROR;
6052: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_ERROR)
6053: THEN
6054: fnd_message.set_name('ONT','OE_NO_TAX_EXEMPTION');
6055: OE_MSG_PUB.Add;
6056: END IF;
6057:
6058: END IF; -- If Tax handling is Standard
6068: THEN
6069: l_return_status := FND_API.G_RET_STS_ERROR;
6070: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_ERROR)
6071: THEN
6072: fnd_message.set_name('ONT','OE_TAX_EXEMPTION_REQUIRED');
6073: OE_MSG_PUB.Add;
6074: END IF;
6075: END IF;*/
6076:
6079: THEN
6080: l_return_status := FND_API.G_RET_STS_ERROR;
6081: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_ERROR)
6082: THEN
6083: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
6084: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
6085: OE_Order_Util.Get_Attribute_Name('TAX_EXEMPT_REASON_CODE'));
6086: OE_MSG_PUB.Add;
6087: END IF;
6080: l_return_status := FND_API.G_RET_STS_ERROR;
6081: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_ERROR)
6082: THEN
6083: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
6084: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
6085: OE_Order_Util.Get_Attribute_Name('TAX_EXEMPT_REASON_CODE'));
6086: OE_MSG_PUB.Add;
6087: END IF;
6088: END IF;
6096: THEN
6097: l_return_status := FND_API.G_RET_STS_ERROR;
6098: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_ERROR)
6099: THEN
6100: fnd_message.set_name('ONT','OE_TAX_EXEMPTION_NOT_ALLOWED');
6101: OE_MSG_PUB.Add;
6102: END IF;
6103:
6104: END IF; -- If Tax handling is Required
6227: l_return_status := FND_API.G_RET_STS_ERROR;
6228:
6229: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
6230: THEN
6231: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
6232: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
6233: OE_Order_Util.Get_Attribute_Name('TAX_EXEMPT_NUMBER'));
6234: OE_MSG_PUB.Add;
6235: END IF;
6228:
6229: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
6230: THEN
6231: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
6232: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
6233: OE_Order_Util.Get_Attribute_Name('TAX_EXEMPT_NUMBER'));
6234: OE_MSG_PUB.Add;
6235: END IF;
6236: END IF;
6329: IF l_debug_level > 0 then
6330: oe_debug_pub.add('uom other than primary uom is entered', 1);
6331: END IF;
6332:
6333: fnd_message.set_name('ONT','OE_INVALID_ORDER_QUANTITY_UOM');
6334: fnd_message.set_token('ITEM',nvl(p_line_rec.ordered_item,p_line_rec.inventory_item_id));
6335: fnd_message.set_token('UOM', l_uom);
6336: OE_MSG_PUB.Add;
6337: RAISE FND_API.G_EXC_ERROR;
6330: oe_debug_pub.add('uom other than primary uom is entered', 1);
6331: END IF;
6332:
6333: fnd_message.set_name('ONT','OE_INVALID_ORDER_QUANTITY_UOM');
6334: fnd_message.set_token('ITEM',nvl(p_line_rec.ordered_item,p_line_rec.inventory_item_id));
6335: fnd_message.set_token('UOM', l_uom);
6336: OE_MSG_PUB.Add;
6337: RAISE FND_API.G_EXC_ERROR;
6338: END IF;
6331: END IF;
6332:
6333: fnd_message.set_name('ONT','OE_INVALID_ORDER_QUANTITY_UOM');
6334: fnd_message.set_token('ITEM',nvl(p_line_rec.ordered_item,p_line_rec.inventory_item_id));
6335: fnd_message.set_token('UOM', l_uom);
6336: OE_MSG_PUB.Add;
6337: RAISE FND_API.G_EXC_ERROR;
6338: END IF;
6339: EXCEPTION
6358: IF l_uom_count = 0 THEN
6359: IF l_debug_level > 0 then
6360: oe_debug_pub.add('uom/item combination invalid',2);
6361: END IF;
6362: fnd_message.set_name('ONT', 'OE_INVALID_ITEM_UOM');
6363: OE_MSG_PUB.Add;
6364: RAISE FND_API.G_EXC_ERROR;
6365: END IF;
6366:
6369: IF NOT l_ret_status THEN
6370: IF l_debug_level > 0 then
6371: oe_debug_pub.add('uom/item combination invalid',2);
6372: END IF;
6373: fnd_message.set_name('ONT', 'OE_INVALID_ITEM_UOM');
6374: OE_MSG_PUB.Add;
6375: RAISE FND_API.G_EXC_ERROR;
6376: END IF;
6377: /*1544265*/
6416: IF NOT OE_GLOBALS.EQUAL(l_list_type_code,'PRL') THEN
6417: -- any price list with 'PRL' type should be allowed to
6418: -- be associated with any agreement according to bug 1386406.
6419: IF NOT OE_GLOBALS.EQUAL(l_price_list_id, p_line_rec.price_list_id) THEN
6420: fnd_message.set_name('ONT', 'OE_INVALID_AGREEMENT_PLIST');
6421: fnd_message.set_Token('AGREEMENT_NAME', l_agreement_name);
6422: BEGIN
6423: SELECT name
6424: INTO l_price_list_name
6417: -- any price list with 'PRL' type should be allowed to
6418: -- be associated with any agreement according to bug 1386406.
6419: IF NOT OE_GLOBALS.EQUAL(l_price_list_id, p_line_rec.price_list_id) THEN
6420: fnd_message.set_name('ONT', 'OE_INVALID_AGREEMENT_PLIST');
6421: fnd_message.set_Token('AGREEMENT_NAME', l_agreement_name);
6422: BEGIN
6423: SELECT name
6424: INTO l_price_list_name
6425: FROM qp_List_headers_vl
6430:
6431: Exception when no_data_found then
6432: l_price_list_name := p_line_rec.price_list_id;
6433: END;
6434: fnd_message.set_Token('PRICE_LIST1', l_price_list_name);
6435: BEGIN
6436:
6437: SELECT name
6438: INTO l_price_list_name
6444: EXCEPTION
6445: WHEN NO_DATA_FOUND THEN
6446: l_price_list_name := l_price_list_id;
6447: END;
6448: fnd_message.set_Token('PRICE_LIST2', l_price_list_name);
6449: OE_MSG_PUB.Add;
6450: IF l_debug_level > 0 then
6451: oe_debug_pub.add('Invalid Agreement +price_list_id combination',2);
6452: END IF;
6458: -- modified by lkxu, to check for customer relationships.
6459: IF l_sold_to_org IS NOT NULL AND l_sold_to_org <> -1
6460: AND NOT OE_GLOBALS.EQUAL(l_sold_to_org,p_line_rec.sold_to_org_id) THEN
6461: IF nvl(lcustomer_relations,'N') = 'N' THEN
6462: fnd_message.set_name('ONT', 'OE_INVALID_AGREEMENT');
6463: fnd_message.set_Token('AGREEMENT_ID', p_line_rec.agreement_id);
6464: fnd_message.set_Token('AGREEMENT_NAME', l_agreement_name);
6465: fnd_message.set_Token('CUSTOMER_ID', p_line_rec.sold_to_org_id);
6466: OE_MSG_PUB.Add;
6459: IF l_sold_to_org IS NOT NULL AND l_sold_to_org <> -1
6460: AND NOT OE_GLOBALS.EQUAL(l_sold_to_org,p_line_rec.sold_to_org_id) THEN
6461: IF nvl(lcustomer_relations,'N') = 'N' THEN
6462: fnd_message.set_name('ONT', 'OE_INVALID_AGREEMENT');
6463: fnd_message.set_Token('AGREEMENT_ID', p_line_rec.agreement_id);
6464: fnd_message.set_Token('AGREEMENT_NAME', l_agreement_name);
6465: fnd_message.set_Token('CUSTOMER_ID', p_line_rec.sold_to_org_id);
6466: OE_MSG_PUB.Add;
6467: IF l_debug_level > 0 then
6460: AND NOT OE_GLOBALS.EQUAL(l_sold_to_org,p_line_rec.sold_to_org_id) THEN
6461: IF nvl(lcustomer_relations,'N') = 'N' THEN
6462: fnd_message.set_name('ONT', 'OE_INVALID_AGREEMENT');
6463: fnd_message.set_Token('AGREEMENT_ID', p_line_rec.agreement_id);
6464: fnd_message.set_Token('AGREEMENT_NAME', l_agreement_name);
6465: fnd_message.set_Token('CUSTOMER_ID', p_line_rec.sold_to_org_id);
6466: OE_MSG_PUB.Add;
6467: IF l_debug_level > 0 then
6468: oe_debug_pub.add('Invalid Agreement +sold_org_id combination',2);
6461: IF nvl(lcustomer_relations,'N') = 'N' THEN
6462: fnd_message.set_name('ONT', 'OE_INVALID_AGREEMENT');
6463: fnd_message.set_Token('AGREEMENT_ID', p_line_rec.agreement_id);
6464: fnd_message.set_Token('AGREEMENT_NAME', l_agreement_name);
6465: fnd_message.set_Token('CUSTOMER_ID', p_line_rec.sold_to_org_id);
6466: OE_MSG_PUB.Add;
6467: IF l_debug_level > 0 then
6468: oe_debug_pub.add('Invalid Agreement +sold_org_id combination',2);
6469: END IF;
6483: );
6484:
6485: EXCEPTION
6486: WHEN NO_DATA_FOUND THEN
6487: fnd_message.set_name('ONT', 'OE_INVALID_AGREEMENT');
6488: fnd_message.set_Token('AGREEMENT_ID', p_line_rec.agreement_id);
6489: fnd_message.set_Token('AGREEMENT_NAME', l_agreement_name);
6490: fnd_message.set_Token('CUSTOMER_ID', p_line_rec.sold_to_org_id);
6491: OE_MSG_PUB.Add;
6484:
6485: EXCEPTION
6486: WHEN NO_DATA_FOUND THEN
6487: fnd_message.set_name('ONT', 'OE_INVALID_AGREEMENT');
6488: fnd_message.set_Token('AGREEMENT_ID', p_line_rec.agreement_id);
6489: fnd_message.set_Token('AGREEMENT_NAME', l_agreement_name);
6490: fnd_message.set_Token('CUSTOMER_ID', p_line_rec.sold_to_org_id);
6491: OE_MSG_PUB.Add;
6492: IF l_debug_level > 0 then
6485: EXCEPTION
6486: WHEN NO_DATA_FOUND THEN
6487: fnd_message.set_name('ONT', 'OE_INVALID_AGREEMENT');
6488: fnd_message.set_Token('AGREEMENT_ID', p_line_rec.agreement_id);
6489: fnd_message.set_Token('AGREEMENT_NAME', l_agreement_name);
6490: fnd_message.set_Token('CUSTOMER_ID', p_line_rec.sold_to_org_id);
6491: OE_MSG_PUB.Add;
6492: IF l_debug_level > 0 then
6493: oe_debug_pub.add('Invalid Agreement +sold_org_id combination',2);
6486: WHEN NO_DATA_FOUND THEN
6487: fnd_message.set_name('ONT', 'OE_INVALID_AGREEMENT');
6488: fnd_message.set_Token('AGREEMENT_ID', p_line_rec.agreement_id);
6489: fnd_message.set_Token('AGREEMENT_NAME', l_agreement_name);
6490: fnd_message.set_Token('CUSTOMER_ID', p_line_rec.sold_to_org_id);
6491: OE_MSG_PUB.Add;
6492: IF l_debug_level > 0 then
6493: oe_debug_pub.add('Invalid Agreement +sold_org_id combination',2);
6494: END IF;
6499:
6500:
6501: EXCEPTION
6502: WHEN NO_DATA_FOUND THEN
6503: fnd_message.set_name('ONT', 'OE_INVALID_AGREEMENT');
6504: fnd_message.set_Token('AGREEMENT_ID', p_line_rec.agreement_id);
6505: fnd_message.set_Token('AGREEMENT_NAME', l_agreement_name);
6506: fnd_message.set_Token('CUSTOMER_ID', l_sold_to_org);
6507: OE_MSG_PUB.Add;
6500:
6501: EXCEPTION
6502: WHEN NO_DATA_FOUND THEN
6503: fnd_message.set_name('ONT', 'OE_INVALID_AGREEMENT');
6504: fnd_message.set_Token('AGREEMENT_ID', p_line_rec.agreement_id);
6505: fnd_message.set_Token('AGREEMENT_NAME', l_agreement_name);
6506: fnd_message.set_Token('CUSTOMER_ID', l_sold_to_org);
6507: OE_MSG_PUB.Add;
6508: IF l_debug_level > 0 then
6501: EXCEPTION
6502: WHEN NO_DATA_FOUND THEN
6503: fnd_message.set_name('ONT', 'OE_INVALID_AGREEMENT');
6504: fnd_message.set_Token('AGREEMENT_ID', p_line_rec.agreement_id);
6505: fnd_message.set_Token('AGREEMENT_NAME', l_agreement_name);
6506: fnd_message.set_Token('CUSTOMER_ID', l_sold_to_org);
6507: OE_MSG_PUB.Add;
6508: IF l_debug_level > 0 then
6509: oe_debug_pub.add('Invalid Agreement +sold_org_id combination',2);
6502: WHEN NO_DATA_FOUND THEN
6503: fnd_message.set_name('ONT', 'OE_INVALID_AGREEMENT');
6504: fnd_message.set_Token('AGREEMENT_ID', p_line_rec.agreement_id);
6505: fnd_message.set_Token('AGREEMENT_NAME', l_agreement_name);
6506: fnd_message.set_Token('CUSTOMER_ID', l_sold_to_org);
6507: OE_MSG_PUB.Add;
6508: IF l_debug_level > 0 then
6509: oe_debug_pub.add('Invalid Agreement +sold_org_id combination',2);
6510: END IF;
6544: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN
6545: --
6546: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'PRICE_LIST_ID');
6547:
6548: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
6549: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
6550: OE_Order_Util.Get_Attribute_Name('price_list_id'));
6551: OE_MSG_PUB.Add;
6552: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
6545: --
6546: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'PRICE_LIST_ID');
6547:
6548: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
6549: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
6550: OE_Order_Util.Get_Attribute_Name('price_list_id'));
6551: OE_MSG_PUB.Add;
6552: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
6553: --
6577: G_REDEFAULT_MISSING := 'Y';
6578: ELSE
6579:
6580: --
6581: FND_MESSAGE.SET_NAME('ONT','OE_CURRENCY_MISMATCH');
6582: FND_MESSAGE.SET_TOKEN('LINE_CURR_CODE', l_currency_code);
6583: FND_MESSAGE.SET_TOKEN('PRICE_LIST_NAME', l_price_list_name);
6584: FND_MESSAGE.SET_TOKEN('HEADER_CURR_CODE', l_hdr_currency_code);
6585: OE_MSG_PUB.ADD;
6578: ELSE
6579:
6580: --
6581: FND_MESSAGE.SET_NAME('ONT','OE_CURRENCY_MISMATCH');
6582: FND_MESSAGE.SET_TOKEN('LINE_CURR_CODE', l_currency_code);
6583: FND_MESSAGE.SET_TOKEN('PRICE_LIST_NAME', l_price_list_name);
6584: FND_MESSAGE.SET_TOKEN('HEADER_CURR_CODE', l_hdr_currency_code);
6585: OE_MSG_PUB.ADD;
6586: --
6579:
6580: --
6581: FND_MESSAGE.SET_NAME('ONT','OE_CURRENCY_MISMATCH');
6582: FND_MESSAGE.SET_TOKEN('LINE_CURR_CODE', l_currency_code);
6583: FND_MESSAGE.SET_TOKEN('PRICE_LIST_NAME', l_price_list_name);
6584: FND_MESSAGE.SET_TOKEN('HEADER_CURR_CODE', l_hdr_currency_code);
6585: OE_MSG_PUB.ADD;
6586: --
6587: RAISE FND_API.G_EXC_ERROR;
6580: --
6581: FND_MESSAGE.SET_NAME('ONT','OE_CURRENCY_MISMATCH');
6582: FND_MESSAGE.SET_TOKEN('LINE_CURR_CODE', l_currency_code);
6583: FND_MESSAGE.SET_TOKEN('PRICE_LIST_NAME', l_price_list_name);
6584: FND_MESSAGE.SET_TOKEN('HEADER_CURR_CODE', l_hdr_currency_code);
6585: OE_MSG_PUB.ADD;
6586: --
6587: RAISE FND_API.G_EXC_ERROR;
6588: --
6683: END IF;
6684:
6685: EXCEPTION
6686: WHEN NO_DATA_FOUND THEN
6687: fnd_message.set_name('ONT', 'OE_INVALID_NONAGR_PLIST');
6688: fnd_message.set_Token('PRICE_LIST1', p_line_rec.price_list_id);
6689: fnd_message.set_Token('PRICING_DATE', p_line_rec.pricing_date);
6690: OE_MSG_PUB.Add;
6691: IF l_debug_level > 0 then
6684:
6685: EXCEPTION
6686: WHEN NO_DATA_FOUND THEN
6687: fnd_message.set_name('ONT', 'OE_INVALID_NONAGR_PLIST');
6688: fnd_message.set_Token('PRICE_LIST1', p_line_rec.price_list_id);
6689: fnd_message.set_Token('PRICING_DATE', p_line_rec.pricing_date);
6690: OE_MSG_PUB.Add;
6691: IF l_debug_level > 0 then
6692: oe_debug_pub.add('Invalid non agreement price list ',2);
6685: EXCEPTION
6686: WHEN NO_DATA_FOUND THEN
6687: fnd_message.set_name('ONT', 'OE_INVALID_NONAGR_PLIST');
6688: fnd_message.set_Token('PRICE_LIST1', p_line_rec.price_list_id);
6689: fnd_message.set_Token('PRICING_DATE', p_line_rec.pricing_date);
6690: OE_MSG_PUB.Add;
6691: IF l_debug_level > 0 then
6692: oe_debug_pub.add('Invalid non agreement price list ',2);
6693: END IF;
6723: IF (NOT OE_GLOBALS.EQUAL(p_line_rec.line_number,
6724: p_old_line_rec.line_number)) THEN
6725:
6726: l_return_status := FND_API.G_RET_STS_ERROR;
6727: fnd_message.set_name('ONT', 'OE_LINE_NUMBER_UPD');
6728: OE_MSG_PUB.add;
6729:
6730: END IF;
6731: END IF;
6766: IF l_debug_level > 0 then
6767: oe_debug_pub.add('class/option qty changed to 0', 1);
6768: END IF;
6769: l_return_status := FND_API.G_RET_STS_ERROR;
6770: FND_MESSAGE.SET_NAME('ONT', 'OE_CONFIG_NO_ZERO_QTY');
6771: oe_msg_pub.add;
6772: END IF;
6773:
6774: l_option_count := 0;
6791: IF l_debug_level > 0 then
6792: oe_debug_pub.add('models qty changed to 0, no cancellation', 1);
6793: END IF;
6794: l_return_status := FND_API.G_RET_STS_ERROR;
6795: FND_Message.Set_Name('ONT', 'OE_CONFIG_NO_ZERO_QTY');
6796: oe_msg_pub.add;
6797: END IF;
6798: END IF;
6799: */
6814: IF l_debug_level > 0 then
6815: oe_debug_pub.add('Ordered Qty cannot be greater than 1 for OTA lines', 1);
6816: END IF;
6817: l_return_status := FND_API.G_RET_STS_ERROR;
6818: FND_Message.Set_Name('ONT', 'OE_OTA_INVALID_QTY');
6819: oe_msg_pub.add;
6820: END IF;
6821:
6822: /* End of validation for OTA */
6842: (p_line_rec.cust_po_number
6843: ,p_line_rec.sold_to_org_id
6844: ,p_line_rec.header_id )
6845: THEN
6846: FND_MESSAGE.SET_NAME('ONT','OE_VAL_DUP_PO_NUMBER');
6847: OE_MSG_PUB.ADD;
6848: END IF;
6849:
6850: END IF;
6876: AND trunc(nvl(END_DATE_ACTIVE,add_months(sysdate,+10000)));
6877:
6878: EXCEPTION
6879: WHEN NO_DATA_FOUND THEN
6880: fnd_message.set_name('ONT', 'ONT_INVALID_AGR');
6881: fnd_message.set_Token('PRICING_DATE', p_line_rec.pricing_date);
6882: OE_MSG_PUB.Add;
6883: IF l_debug_level > 0 then
6884: oe_debug_pub.add('Invalid Agreement',2);
6877:
6878: EXCEPTION
6879: WHEN NO_DATA_FOUND THEN
6880: fnd_message.set_name('ONT', 'ONT_INVALID_AGR');
6881: fnd_message.set_Token('PRICING_DATE', p_line_rec.pricing_date);
6882: OE_MSG_PUB.Add;
6883: IF l_debug_level > 0 then
6884: oe_debug_pub.add('Invalid Agreement',2);
6885: END IF;
6899:
6900: IF (p_line_rec.service_end_date < p_line_rec.service_start_date) -- 2992944
6901: THEN
6902: l_return_status := FND_API.G_RET_STS_ERROR;
6903: fnd_message.set_name('ONT','OE_SERV_END_DATE');
6904: OE_MSG_PUB.Add;
6905: END IF;
6906:
6907: END IF;
6949: l_return_status := FND_API.G_RET_STS_ERROR;
6950: IF l_debug_level > 0 then
6951: OE_DEBUG_PUB.Add('Coverage Template Cannot be provided to Subscription Service Line');
6952: END IF;
6953: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
6954: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',oe_order_util.get_attribute_name('SERVICE_COV_TEMPLATE_ID'));
6955: OE_MSG_PUB.Add;
6956: RAISE FND_API.G_EXC_ERROR;
6957: End If;
6950: IF l_debug_level > 0 then
6951: OE_DEBUG_PUB.Add('Coverage Template Cannot be provided to Subscription Service Line');
6952: END IF;
6953: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
6954: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',oe_order_util.get_attribute_name('SERVICE_COV_TEMPLATE_ID'));
6955: OE_MSG_PUB.Add;
6956: RAISE FND_API.G_EXC_ERROR;
6957: End If;
6958: /* Subscription Template cannot be provided to any other line other than Subscription Service */
6961: l_return_status := FND_API.G_RET_STS_ERROR;
6962: IF l_debug_level > 0 then
6963: OE_DEBUG_PUB.Add('Subscription Template Cannot be provided to a non Subscription Service Line');
6964: END IF;
6965: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
6966: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',oe_order_util.get_attribute_name('SERVICE_SUBS_TEMPLATE_ID'));
6967: OE_MSG_PUB.Add;
6968: RAISE FND_API.G_EXC_ERROR;
6969: End If;
6962: IF l_debug_level > 0 then
6963: OE_DEBUG_PUB.Add('Subscription Template Cannot be provided to a non Subscription Service Line');
6964: END IF;
6965: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
6966: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',oe_order_util.get_attribute_name('SERVICE_SUBS_TEMPLATE_ID'));
6967: OE_MSG_PUB.Add;
6968: RAISE FND_API.G_EXC_ERROR;
6969: End If;
6970: -- sol_ord_er #16014165 end
6976: IF l_debug_level > 0 then
6977: oe_debug_pub.add('Ship tolerances can not be specified on PTOs',3);
6978: END IF;
6979: l_return_status := FND_API.G_RET_STS_ERROR;
6980: fnd_message.set_name('ONT','OE_NO_TOL_FOR_PTO');
6981: OE_MSG_PUB.Add;
6982:
6983: END IF;
6984: IF l_debug_level > 0 then
6994: IF l_debug_level > 0 then
6995: oe_debug_pub.add('child line of model with null qty', 3);
6996: END IF;
6997: l_return_status := FND_API.G_RET_STS_ERROR;
6998: fnd_message.set_name('ONT','OE_CONFIG_NULL_QUANTITY');
6999: fnd_message.set_Token('ITEM', nvl(p_line_rec.ordered_item,p_line_rec.inventory_item_id));
7000: OE_MSG_PUB.Add;
7001:
7002: END IF;
6995: oe_debug_pub.add('child line of model with null qty', 3);
6996: END IF;
6997: l_return_status := FND_API.G_RET_STS_ERROR;
6998: fnd_message.set_name('ONT','OE_CONFIG_NULL_QUANTITY');
6999: fnd_message.set_Token('ITEM', nvl(p_line_rec.ordered_item,p_line_rec.inventory_item_id));
7000: OE_MSG_PUB.Add;
7001:
7002: END IF;
7003:
7026: p_line_rec.schedule_action_code IS NULL THEN
7027:
7028: -- Must have some scheduling action when you set the Override
7029: -- ATP Flag
7030: FND_MESSAGE.SET_NAME('ONT','OE_SCH_OVER_ATP_NO_SCH_ACT');
7031: OE_MSG_PUB.Add;
7032: IF l_debug_level > 0 then
7033: Oe_debug_pub.add('Missing Schedule Action',1);
7034: END IF;
7040: p_line_rec.source_type_code = OE_GLOBALS.G_SOURCE_EXTERNAL) THEN
7041:
7042: -- Override ATP flag cannot be set for Service, Return,
7043: -- and Drop Ship Lines.
7044: FND_MESSAGE.SET_NAME('ONT', 'OE_SCH_OVER_ATP_INVLD_LINE');
7045: OE_MSG_PUB.Add;
7046: IF l_debug_level > 0 then
7047: Oe_debug_pub.add('Override ATP cannot be set for Service, Return and
7048: Drop Ship lines',1);
7055: ELSE
7056:
7057: IF p_line_rec.override_atp_date_code IS NOT NULL THEN
7058:
7059: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7060: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Override Atp');
7061: OE_MSG_PUB.Add;
7062: l_return_status := FND_API.G_RET_STS_ERROR;
7063: IF l_debug_level > 0 then
7056:
7057: IF p_line_rec.override_atp_date_code IS NOT NULL THEN
7058:
7059: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7060: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Override Atp');
7061: OE_MSG_PUB.Add;
7062: l_return_status := FND_API.G_RET_STS_ERROR;
7063: IF l_debug_level > 0 then
7064: Oe_debug_pub.add('Override ATP cannot be set prior to pack-I' ||
7083: OR p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_SERVICE
7084: OR p_line_rec.line_category_code = 'RETURN'
7085: OR p_line_rec.open_flag = 'N' THEN
7086:
7087: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_FIRM_OPR');
7088: OE_MSG_PUB.Add;
7089: l_return_status := FND_API.G_RET_STS_ERROR;
7090:
7091: END IF;
7123: if l_debug_level > 0 then
7124: OE_DEBUG_PUB.Add('Blankets are only available in Pack I or greater',1);
7125: end if;
7126: l_return_status := FND_API.G_RET_STS_ERROR;
7127: FND_MESSAGE.Set_Name('ONT','OE_BLANKET_INVALID_VERSION');
7128: OE_MSG_PUB.Add;
7129: END IF;
7130:
7131: ELSE
7244: PO_CODE_RELEASE_GRP.PRC_11i_Family_Pack_J AND
7245: OE_CODE_CONTROL.Code_Release_Level < '110510') THEN
7246:
7247:
7248: Fnd_Message.Set_Name('ONT','ONT_DS_PO_CHANGE_REQD');
7249:
7250: l_ds_req := RTRIM(p_line_rec.line_number || '.' ||
7251: p_line_rec.shipment_number || '.' ||
7252: p_line_rec.option_number || '.' ||
7253: p_line_rec.component_number || '.' ||
7254: p_line_rec.service_number, '.');
7255:
7256:
7257: FND_Message.Set_Token('LINE_NUM', l_ds_req);
7258:
7259: IF l_debug_level > 0 THEN
7260: oe_debug_pub.add('dropship line - message reqd', 1);
7261: END IF;
7265: INTO l_sold_to_org
7266: FROM po_requisition_headers_all
7267: WHERE requisition_header_id = l_req_header_id;
7268:
7269: FND_Message.Set_Token('REQ_NUM', l_sold_to_org);
7270: FND_Message.Set_Token('REQ_STS', nvl(l_req_status, '-'));
7271:
7272: EXCEPTION
7273: WHEN OTHERS THEN
7266: FROM po_requisition_headers_all
7267: WHERE requisition_header_id = l_req_header_id;
7268:
7269: FND_Message.Set_Token('REQ_NUM', l_sold_to_org);
7270: FND_Message.Set_Token('REQ_STS', nvl(l_req_status, '-'));
7271:
7272: EXCEPTION
7273: WHEN OTHERS THEN
7274: null;
7280: INTO l_sold_to_org
7281: FROM po_headers_all
7282: WHERE po_header_id = l_po_header_id;
7283:
7284: FND_Message.Set_Token('PO_NUM', l_sold_to_org);
7285: -- bug 4411054
7286: --FND_Message.Set_Token('PO_STS', nvl(l_po_status, '-'));
7287: FND_Message.Set_Token('PO_STS', nvl(l_closed_code, '-'));
7288:
7282: WHERE po_header_id = l_po_header_id;
7283:
7284: FND_Message.Set_Token('PO_NUM', l_sold_to_org);
7285: -- bug 4411054
7286: --FND_Message.Set_Token('PO_STS', nvl(l_po_status, '-'));
7287: FND_Message.Set_Token('PO_STS', nvl(l_closed_code, '-'));
7288:
7289: ELSE
7290:
7283:
7284: FND_Message.Set_Token('PO_NUM', l_sold_to_org);
7285: -- bug 4411054
7286: --FND_Message.Set_Token('PO_STS', nvl(l_po_status, '-'));
7287: FND_Message.Set_Token('PO_STS', nvl(l_closed_code, '-'));
7288:
7289: ELSE
7290:
7291: FND_Message.Set_Token('PO_NUM', '-');
7287: FND_Message.Set_Token('PO_STS', nvl(l_closed_code, '-'));
7288:
7289: ELSE
7290:
7291: FND_Message.Set_Token('PO_NUM', '-');
7292: FND_Message.Set_Token('PO_STS', 'NOT CREATED');
7293: IF l_debug_level > 0 THEN
7294: oe_debug_pub.add('no po', 4);
7295: END IF;
7288:
7289: ELSE
7290:
7291: FND_Message.Set_Token('PO_NUM', '-');
7292: FND_Message.Set_Token('PO_STS', 'NOT CREATED');
7293: IF l_debug_level > 0 THEN
7294: oe_debug_pub.add('no po', 4);
7295: END IF;
7296: END IF;
7355: OE_DEBUG_PUB.ADD('VALIDATION FOR IB_OWNER FAILED IN OEXLLINB.pls');
7356: OE_DEBUG_PUB.ADD('OLD LINE HAS INSTALL_BASE CAN NOT CHANGE IT');
7357: END IF;
7358: l_return_status := FND_API.G_RET_STS_ERROR;
7359: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7360: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_OWNER'));
7361: OE_MSG_PUB.Add;
7362: END IF;
7363:
7356: OE_DEBUG_PUB.ADD('OLD LINE HAS INSTALL_BASE CAN NOT CHANGE IT');
7357: END IF;
7358: l_return_status := FND_API.G_RET_STS_ERROR;
7359: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7360: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_OWNER'));
7361: OE_MSG_PUB.Add;
7362: END IF;
7363:
7364:
7369: OE_DEBUG_PUB.ADD('VALIDATION FOR IB_INSTALLED_AT_LOCATION FAILED IN OEXLLINB.pls');
7370: OE_DEBUG_PUB.ADD('OLD LINE HAS INSTALL_BASE CAN NOT CHANGE IT');
7371: END IF;
7372: l_return_status := FND_API.G_RET_STS_ERROR;
7373: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7374: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_INSTALLED_AT_LOCATION'));
7375: OE_MSG_PUB.Add;
7376: END IF;
7377:
7370: OE_DEBUG_PUB.ADD('OLD LINE HAS INSTALL_BASE CAN NOT CHANGE IT');
7371: END IF;
7372: l_return_status := FND_API.G_RET_STS_ERROR;
7373: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7374: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_INSTALLED_AT_LOCATION'));
7375: OE_MSG_PUB.Add;
7376: END IF;
7377:
7378:
7383: OE_DEBUG_PUB.ADD('VALIDATION FOR IB_CURRENT_LOCATION FAILED IN OEXLLINB.pls');
7384: OE_DEBUG_PUB.ADD('OLD LINE HAS INSTALL_BASE CAN NOT CHANGE IT');
7385: END IF;
7386: l_return_status := FND_API.G_RET_STS_ERROR;
7387: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7388: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_CURRENT_LOCATION'));
7389: OE_MSG_PUB.Add;
7390: END IF;
7391:
7384: OE_DEBUG_PUB.ADD('OLD LINE HAS INSTALL_BASE CAN NOT CHANGE IT');
7385: END IF;
7386: l_return_status := FND_API.G_RET_STS_ERROR;
7387: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7388: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_CURRENT_LOCATION'));
7389: OE_MSG_PUB.Add;
7390: END IF;
7391:
7392: -- END OF check.
7402: OE_DEBUG_PUB.ADD('VALIDATION FOR IB_OWNER FAILED IN OEXLLINB.pls');
7403: OE_DEBUG_PUB.ADD('TRYING TO UPDATE WITH INSTALL_BASE OLD LINE HAS SOME VALUE');
7404: END IF;
7405: l_return_status := FND_API.G_RET_STS_ERROR;
7406: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7407: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_OWNER'));
7408: OE_MSG_PUB.Add;
7409: END IF;
7410:
7403: OE_DEBUG_PUB.ADD('TRYING TO UPDATE WITH INSTALL_BASE OLD LINE HAS SOME VALUE');
7404: END IF;
7405: l_return_status := FND_API.G_RET_STS_ERROR;
7406: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7407: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_OWNER'));
7408: OE_MSG_PUB.Add;
7409: END IF;
7410:
7411: 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
7413: OE_DEBUG_PUB.ADD('VALIDATION FOR IB_INSTALLED_AT_LOCATION FAILED IN OEXLLINB.pls');
7414: OE_DEBUG_PUB.ADD('TRYING TO UPDATE WITH INSTALL_BASE OLD LINE HAS SOME VALUE');
7415: END IF;
7416: l_return_status := FND_API.G_RET_STS_ERROR;
7417: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7418: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_INSTALLED_AT_LOCATION'));
7419: OE_MSG_PUB.Add;
7420: END IF;
7421:
7414: OE_DEBUG_PUB.ADD('TRYING TO UPDATE WITH INSTALL_BASE OLD LINE HAS SOME VALUE');
7415: END IF;
7416: l_return_status := FND_API.G_RET_STS_ERROR;
7417: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7418: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_INSTALLED_AT_LOCATION'));
7419: OE_MSG_PUB.Add;
7420: END IF;
7421:
7422: 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
7424: OE_DEBUG_PUB.ADD('VALIDATION FOR IB_CURRENT_LOCATION FAILED IN OEXLLINB.pls');
7425: OE_DEBUG_PUB.ADD('TRYING TO UPDATE WITH INSTALL_BASE OLD LINE HAS SOME VALUE');
7426: END IF;
7427: l_return_status := FND_API.G_RET_STS_ERROR;
7428: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7429: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_CURRENT_LOCATION'));
7430: OE_MSG_PUB.Add;
7431: END IF;
7432:
7425: OE_DEBUG_PUB.ADD('TRYING TO UPDATE WITH INSTALL_BASE OLD LINE HAS SOME VALUE');
7426: END IF;
7427: l_return_status := FND_API.G_RET_STS_ERROR;
7428: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7429: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_CURRENT_LOCATION'));
7430: OE_MSG_PUB.Add;
7431: END IF;
7432:
7433: IF OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL >= '110510' THEN
7440: OE_DEBUG_PUB.ADD('Validation for IB_OWNER failed from OEXLLINB.pls');
7441: OE_DEBUG_PUB.ADD('THIS IS NOT A MODEL , CAN NOT HAVE INSTALL_BASE ');
7442: END IF;
7443: l_return_status := FND_API.G_RET_STS_ERROR;
7444: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7445: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_OWNER'));
7446: OE_MSG_PUB.Add;
7447:
7448: END IF;
7441: OE_DEBUG_PUB.ADD('THIS IS NOT A MODEL , CAN NOT HAVE INSTALL_BASE ');
7442: END IF;
7443: l_return_status := FND_API.G_RET_STS_ERROR;
7444: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7445: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_OWNER'));
7446: OE_MSG_PUB.Add;
7447:
7448: END IF;
7449:
7457: OE_DEBUG_PUB.ADD('Validation for IB_INSTALLED_AT_LOCATION failed from OEXLLINB.pls');
7458: OE_DEBUG_PUB.ADD('This is not a model , can not have INSTALL_BASE ');
7459: END IF;
7460: l_return_status := FND_API.G_RET_STS_ERROR;
7461: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7462: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_INSTALLED_AT_LOCATION'));
7463: OE_MSG_PUB.Add;
7464:
7465: END IF;
7458: OE_DEBUG_PUB.ADD('This is not a model , can not have INSTALL_BASE ');
7459: END IF;
7460: l_return_status := FND_API.G_RET_STS_ERROR;
7461: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7462: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_INSTALLED_AT_LOCATION'));
7463: OE_MSG_PUB.Add;
7464:
7465: END IF;
7466:
7475: OE_DEBUG_PUB.ADD('Validation for IB_CURRENT_LOCATION failed from OEXLLINB.pls');
7476: OE_DEBUG_PUB.ADD('THIS IS NOT A MODEL , CAN NOT HAVE INSTALL_BASE ');
7477: END IF;
7478: l_return_status := FND_API.G_RET_STS_ERROR;
7479: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7480: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_CURRENT_LOCATION'));
7481: OE_MSG_PUB.Add;
7482:
7483: END IF;
7476: OE_DEBUG_PUB.ADD('THIS IS NOT A MODEL , CAN NOT HAVE INSTALL_BASE ');
7477: END IF;
7478: l_return_status := FND_API.G_RET_STS_ERROR;
7479: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7480: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_CURRENT_LOCATION'));
7481: OE_MSG_PUB.Add;
7482:
7483: END IF;
7484:
7503: IF l_debug_level >0 THEN
7504: OE_DEBUG_PUB.ADD('end customer id is null but value is end_customer!');
7505: END IF;
7506: l_return_status := FND_API.G_RET_STS_ERROR;
7507: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7508: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_OWNER'));
7509: OE_MSG_PUB.Add;
7510:
7511: ELSIF p_line_rec.ib_owner = 'SOLD_TO' AND
7504: OE_DEBUG_PUB.ADD('end customer id is null but value is end_customer!');
7505: END IF;
7506: l_return_status := FND_API.G_RET_STS_ERROR;
7507: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7508: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_OWNER'));
7509: OE_MSG_PUB.Add;
7510:
7511: ELSIF p_line_rec.ib_owner = 'SOLD_TO' AND
7512: p_line_rec.sold_to_org_id is null
7514: IF l_debug_level >0 THEN
7515: OE_DEBUG_PUB.ADD(' sold_to_org_id is null but value is sold_to!');
7516: END IF;
7517: l_return_status := FND_API.G_RET_STS_ERROR;
7518: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7519: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_OWNER'));
7520: OE_MSG_PUB.Add;
7521: END IF;
7522: END IF;
7515: OE_DEBUG_PUB.ADD(' sold_to_org_id is null but value is sold_to!');
7516: END IF;
7517: l_return_status := FND_API.G_RET_STS_ERROR;
7518: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7519: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_OWNER'));
7520: OE_MSG_PUB.Add;
7521: END IF;
7522: END IF;
7523: IF l_debug_level > 0 then
7538: IF l_debug_level >0 THEN
7539: OE_DEBUG_PUB.ADD(' bill_to_org_id is null but value is bill_to!');
7540: END IF;
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',OE_Order_UTIL.Get_attribute_name('IB_INSTALLED_AT_LOCATION'));
7544: OE_MSG_PUB.Add;
7545:
7546: ELSIF p_line_rec.ib_installed_at_location = 'SHIP_TO' AND
7539: OE_DEBUG_PUB.ADD(' bill_to_org_id is null but value is bill_to!');
7540: END IF;
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',OE_Order_UTIL.Get_attribute_name('IB_INSTALLED_AT_LOCATION'));
7544: OE_MSG_PUB.Add;
7545:
7546: ELSIF p_line_rec.ib_installed_at_location = 'SHIP_TO' AND
7547: p_line_rec.ship_to_org_id is null
7549: IF l_debug_level >0 THEN
7550: OE_DEBUG_PUB.ADD(' ship_to_org_id is null but value is ship_to!');
7551: END IF;
7552: l_return_status := FND_API.G_RET_STS_ERROR;
7553: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7554: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_INSTALLED_AT_LOCATION'));
7555: OE_MSG_PUB.Add;
7556:
7557: ELSIF p_line_rec.ib_installed_at_location = 'DELIVER_TO' AND
7550: OE_DEBUG_PUB.ADD(' ship_to_org_id is null but value is ship_to!');
7551: END IF;
7552: l_return_status := FND_API.G_RET_STS_ERROR;
7553: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7554: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_INSTALLED_AT_LOCATION'));
7555: OE_MSG_PUB.Add;
7556:
7557: ELSIF p_line_rec.ib_installed_at_location = 'DELIVER_TO' AND
7558: p_line_rec.deliver_to_org_id is null
7560: IF l_debug_level >0 THEN
7561: OE_DEBUG_PUB.ADD(' deliver_to_org_id is null but value is deliver_to!');
7562: END IF;
7563: l_return_status := FND_API.G_RET_STS_ERROR;
7564: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7565: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_INSTALLED_AT_LOCATION'));
7566: OE_MSG_PUB.Add;
7567: ELSIF p_line_rec.ib_installed_at_location = 'END_CUSTOMER' AND
7568: p_line_rec.end_customer_site_use_id is null
7561: OE_DEBUG_PUB.ADD(' deliver_to_org_id is null but value is deliver_to!');
7562: END IF;
7563: l_return_status := FND_API.G_RET_STS_ERROR;
7564: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7565: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_INSTALLED_AT_LOCATION'));
7566: OE_MSG_PUB.Add;
7567: ELSIF p_line_rec.ib_installed_at_location = 'END_CUSTOMER' AND
7568: p_line_rec.end_customer_site_use_id is null
7569: THEN
7570: IF l_debug_level >0 THEN
7571: OE_DEBUG_PUB.ADD('end customer id is null but value is end_customer!');
7572: END IF;
7573: l_return_status := FND_API.G_RET_STS_ERROR;
7574: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7575: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_INSTALLED_AT_LOCATION'));
7576: OE_MSG_PUB.Add;
7577:
7578: -- no validation for SOLD_TO
7571: OE_DEBUG_PUB.ADD('end customer id is null but value is end_customer!');
7572: END IF;
7573: l_return_status := FND_API.G_RET_STS_ERROR;
7574: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7575: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_INSTALLED_AT_LOCATION'));
7576: OE_MSG_PUB.Add;
7577:
7578: -- no validation for SOLD_TO
7579: -- since no line level sold_to_site_use_id
7581: ELSIF p_line_rec.ib_installed_at_location = 'SOLD_TO'
7582: AND OE_Order_Cache.g_header_rec.sold_to_site_use_id is null
7583: THEN
7584: l_return_status := FND_API.G_RET_STS_ERROR;
7585: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7586: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_INSTALLED_AT_LOCATION'));
7587: OE_MSG_PUB.Add;
7588:
7589: END IF;
7582: AND OE_Order_Cache.g_header_rec.sold_to_site_use_id is null
7583: THEN
7584: l_return_status := FND_API.G_RET_STS_ERROR;
7585: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7586: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_INSTALLED_AT_LOCATION'));
7587: OE_MSG_PUB.Add;
7588:
7589: END IF;
7590: END IF;
7606: IF l_debug_level >0 THEN
7607: OE_DEBUG_PUB.ADD(' bill_to_org_id is null but value is bill_to!');
7608: END IF;
7609: l_return_status := FND_API.G_RET_STS_ERROR;
7610: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7611: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_CURRENT_LOCATION'));
7612: OE_MSG_PUB.Add;
7613:
7614: ELSIF p_line_rec.ib_current_location = 'SHIP_TO' AND
7607: OE_DEBUG_PUB.ADD(' bill_to_org_id is null but value is bill_to!');
7608: END IF;
7609: l_return_status := FND_API.G_RET_STS_ERROR;
7610: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7611: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_CURRENT_LOCATION'));
7612: OE_MSG_PUB.Add;
7613:
7614: ELSIF p_line_rec.ib_current_location = 'SHIP_TO' AND
7615: p_line_rec.ship_to_org_id is null
7617: IF l_debug_level >0 THEN
7618: OE_DEBUG_PUB.ADD(' ship_to_org_id is null but value is ship_to!');
7619: END IF;
7620: l_return_status := FND_API.G_RET_STS_ERROR;
7621: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7622: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_CURRENT_LOCATION'));
7623: OE_MSG_PUB.Add;
7624:
7625: ELSIF p_line_rec.ib_current_location = 'DELIVER_TO' AND
7618: OE_DEBUG_PUB.ADD(' ship_to_org_id is null but value is ship_to!');
7619: END IF;
7620: l_return_status := FND_API.G_RET_STS_ERROR;
7621: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7622: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_CURRENT_LOCATION'));
7623: OE_MSG_PUB.Add;
7624:
7625: ELSIF p_line_rec.ib_current_location = 'DELIVER_TO' AND
7626: p_line_rec.deliver_to_org_id is null
7625: ELSIF p_line_rec.ib_current_location = 'DELIVER_TO' AND
7626: p_line_rec.deliver_to_org_id is null
7627: THEN
7628: l_return_status := FND_API.G_RET_STS_ERROR;
7629: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7630: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_CURRENT_LOCATION'));
7631: OE_MSG_PUB.Add;
7632:
7633: ELSIF p_line_rec.ib_current_location = 'END_CUSTOMER' AND
7626: p_line_rec.deliver_to_org_id is null
7627: THEN
7628: l_return_status := FND_API.G_RET_STS_ERROR;
7629: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7630: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_CURRENT_LOCATION'));
7631: OE_MSG_PUB.Add;
7632:
7633: ELSIF p_line_rec.ib_current_location = 'END_CUSTOMER' AND
7634: p_line_rec.end_customer_site_use_id is null
7633: ELSIF p_line_rec.ib_current_location = 'END_CUSTOMER' AND
7634: p_line_rec.end_customer_site_use_id is null
7635: THEN
7636: l_return_status := FND_API.G_RET_STS_ERROR;
7637: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7638: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_CURRENT_LOCATION'));
7639: OE_MSG_PUB.Add;
7640:
7641: -- no validation for SOLD_TO
7634: p_line_rec.end_customer_site_use_id is null
7635: THEN
7636: l_return_status := FND_API.G_RET_STS_ERROR;
7637: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7638: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_CURRENT_LOCATION'));
7639: OE_MSG_PUB.Add;
7640:
7641: -- no validation for SOLD_TO
7642: -- since no line level sold_to_site_use_id
7644: ELSIF p_line_rec.ib_current_location = 'SOLD_TO'
7645: AND OE_Order_Cache.g_header_rec.sold_to_site_use_id is null
7646: THEN
7647: l_return_status := FND_API.G_RET_STS_ERROR;
7648: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7649: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_CURRENT_LOCATION'));
7650: OE_MSG_PUB.Add;
7651:
7652:
7645: AND OE_Order_Cache.g_header_rec.sold_to_site_use_id is null
7646: THEN
7647: l_return_status := FND_API.G_RET_STS_ERROR;
7648: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7649: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_CURRENT_LOCATION'));
7650: OE_MSG_PUB.Add;
7651:
7652:
7653: END IF;
7679: EXCEPTION
7680:
7681: WHEN NO_DATA_FOUND THEN
7682: l_return_status := FND_API.G_RET_STS_ERROR;
7683: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7684: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
7685: OE_Order_Util.Get_Attribute_Name('END_CUSTOMER_CONTACT_ID'));
7686: OE_MSG_PUB.Add;
7687:
7680:
7681: WHEN NO_DATA_FOUND THEN
7682: l_return_status := FND_API.G_RET_STS_ERROR;
7683: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7684: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
7685: OE_Order_Util.Get_Attribute_Name('END_CUSTOMER_CONTACT_ID'));
7686: OE_MSG_PUB.Add;
7687:
7688: WHEN OTHERS THEN
7726: EXCEPTION
7727:
7728: WHEN NO_DATA_FOUND THEN
7729: l_return_status := FND_API.G_RET_STS_ERROR;
7730: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7731: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
7732: OE_Order_Util.Get_Attribute_Name('END_CUSTOMER_SITE_USE_ID'));
7733: OE_MSG_PUB.Add;
7734:
7727:
7728: WHEN NO_DATA_FOUND THEN
7729: l_return_status := FND_API.G_RET_STS_ERROR;
7730: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7731: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
7732: OE_Order_Util.Get_Attribute_Name('END_CUSTOMER_SITE_USE_ID'));
7733: OE_MSG_PUB.Add;
7734:
7735: WHEN OTHERS THEN
7834: --WHERE mtl_msi.inventory_item_id = p_line_rec.inventory_item_id
7835: --AND mtl_msi.organization_id =
7836: -- OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID');
7837:
7838: FND_MESSAGE.SET_NAME('ONT','ONT_NO_RC_ALLOWED');
7839: --FND_MESSAGE.SET_TOKEN('ITEM',l_item_description);
7840: OE_MSG_PUB.Add;
7841: RAISE FND_API.G_EXC_ERROR;
7842: END IF;
7835: --AND mtl_msi.organization_id =
7836: -- OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID');
7837:
7838: FND_MESSAGE.SET_NAME('ONT','ONT_NO_RC_ALLOWED');
7839: --FND_MESSAGE.SET_TOKEN('ITEM',l_item_description);
7840: OE_MSG_PUB.Add;
7841: RAISE FND_API.G_EXC_ERROR;
7842: END IF;
7843: END IF; --operation CREATE
7851: OE_DEBUG_PUB.Add('Line Num:'||p_line_rec.line_number,2);
7852: OE_DEBUG_PUB.Add('ERR: Update of charge periodicity',3);
7853: END IF;
7854:
7855: FND_MESSAGE.SET_NAME('ONT','ONT_NO_UPDATE_ON_PERIODICITY');
7856: FND_MESSAGE.SET_TOKEN('LINE_NUM',p_line_rec.line_number);
7857: OE_MSG_PUB.Add;
7858: RAISE FND_API.G_EXC_ERROR;
7859:
7852: OE_DEBUG_PUB.Add('ERR: Update of charge periodicity',3);
7853: END IF;
7854:
7855: FND_MESSAGE.SET_NAME('ONT','ONT_NO_UPDATE_ON_PERIODICITY');
7856: FND_MESSAGE.SET_TOKEN('LINE_NUM',p_line_rec.line_number);
7857: OE_MSG_PUB.Add;
7858: RAISE FND_API.G_EXC_ERROR;
7859:
7860: END IF;
7861: ELSE --recurring charges system paramter is N
7862: IF l_debug_level > 0 THEN
7863: OE_DEBUG_PUB.Add('ERR: Recurring Charges SYS Param is disabled');
7864: END IF;
7865: FND_MESSAGE.SET_NAME('ONT','ONT_RECUR_CHARGES_NOT_ENABLED');
7866: OE_MSG_PUB.Add;
7867: RAISE FND_API.G_EXC_ERROR;
7868:
7869: END IF;
7892: then
7893:
7894: if p_line_rec.service_duration is not null and p_line_rec.service_duration <>FND_API.G_MISS_NUM then
7895: l_return_status := FND_API.G_RET_STS_ERROR;
7896: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7897: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
7898: OE_Order_UTIL.Get_Attribute_Name('SERVICE_DURATION'));
7899: OE_MSG_PUB.ADD;
7900: end if;
7893:
7894: if p_line_rec.service_duration is not null and p_line_rec.service_duration <>FND_API.G_MISS_NUM then
7895: l_return_status := FND_API.G_RET_STS_ERROR;
7896: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7897: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
7898: OE_Order_UTIL.Get_Attribute_Name('SERVICE_DURATION'));
7899: OE_MSG_PUB.ADD;
7900: end if;
7901:
7900: end if;
7901:
7902: if p_line_rec.service_period is not null and p_line_rec.service_period <>FND_API.G_MISS_CHAR then
7903: l_return_status := FND_API.G_RET_STS_ERROR;
7904: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7905: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
7906: OE_Order_UTIL.Get_Attribute_Name('SERVICE_PERIOD'));
7907: OE_MSG_PUB.ADD;
7908: end if;
7901:
7902: if p_line_rec.service_period is not null and p_line_rec.service_period <>FND_API.G_MISS_CHAR then
7903: l_return_status := FND_API.G_RET_STS_ERROR;
7904: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7905: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
7906: OE_Order_UTIL.Get_Attribute_Name('SERVICE_PERIOD'));
7907: OE_MSG_PUB.ADD;
7908: end if;
7909:
7908: end if;
7909:
7910: if p_line_rec.service_start_date is not null and p_line_rec.service_start_date <>FND_API.G_MISS_DATE then
7911: l_return_status := FND_API.G_RET_STS_ERROR;
7912: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7913: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
7914: OE_Order_UTIL.Get_Attribute_Name('SERVICE_START_DATE'));
7915: OE_MSG_PUB.ADD;
7916: end if;
7909:
7910: if p_line_rec.service_start_date is not null and p_line_rec.service_start_date <>FND_API.G_MISS_DATE then
7911: l_return_status := FND_API.G_RET_STS_ERROR;
7912: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7913: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
7914: OE_Order_UTIL.Get_Attribute_Name('SERVICE_START_DATE'));
7915: OE_MSG_PUB.ADD;
7916: end if;
7917:
7916: end if;
7917:
7918: if p_line_rec.service_end_date is not null and p_line_rec.service_end_date <>FND_API.G_MISS_DATE then
7919: l_return_status := FND_API.G_RET_STS_ERROR;
7920: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7921: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
7922: OE_Order_UTIL.Get_Attribute_Name('SERVICE_END_DATE'));
7923: OE_MSG_PUB.ADD;
7924: end if;
7917:
7918: if p_line_rec.service_end_date is not null and p_line_rec.service_end_date <>FND_API.G_MISS_DATE then
7919: l_return_status := FND_API.G_RET_STS_ERROR;
7920: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7921: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
7922: OE_Order_UTIL.Get_Attribute_Name('SERVICE_END_DATE'));
7923: OE_MSG_PUB.ADD;
7924: end if;
7925:
7931: -- webroot bug 6826344 added end
7932:
7933: if p_line_rec.service_txn_comments is not null and p_line_rec.service_txn_comments <>FND_API.G_MISS_CHAR then
7934: l_return_status := FND_API.G_RET_STS_ERROR;
7935: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7936: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
7937: OE_Order_UTIL.Get_Attribute_Name('SERVICE_TXN_COMMENTS'));
7938: OE_MSG_PUB.ADD;
7939: end if;
7932:
7933: if p_line_rec.service_txn_comments is not null and p_line_rec.service_txn_comments <>FND_API.G_MISS_CHAR then
7934: l_return_status := FND_API.G_RET_STS_ERROR;
7935: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7936: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
7937: OE_Order_UTIL.Get_Attribute_Name('SERVICE_TXN_COMMENTS'));
7938: OE_MSG_PUB.ADD;
7939: end if;
7940:
7939: end if;
7940:
7941: 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
7942: l_return_status := FND_API.G_RET_STS_ERROR;
7943: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7944: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
7945: OE_Order_UTIL.Get_Attribute_Name('SERVICE_TXN_REASON_CODE'));
7946: OE_MSG_PUB.ADD;
7947: end if;
7940:
7941: 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
7942: l_return_status := FND_API.G_RET_STS_ERROR;
7943: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7944: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
7945: OE_Order_UTIL.Get_Attribute_Name('SERVICE_TXN_REASON_CODE'));
7946: OE_MSG_PUB.ADD;
7947: end if;
7948:
7947: end if;
7948:
7949: if p_line_rec.service_coterminate_flag is not null and p_line_rec.service_coterminate_flag <>FND_API.G_MISS_CHAR then
7950: l_return_status := FND_API.G_RET_STS_ERROR;
7951: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7952: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
7953: OE_Order_UTIL.Get_Attribute_Name('SERVICE_COTERMINATE_FLAG'));
7954: OE_MSG_PUB.ADD;
7955: end if;
7948:
7949: if p_line_rec.service_coterminate_flag is not null and p_line_rec.service_coterminate_flag <>FND_API.G_MISS_CHAR then
7950: l_return_status := FND_API.G_RET_STS_ERROR;
7951: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7952: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
7953: OE_Order_UTIL.Get_Attribute_Name('SERVICE_COTERMINATE_FLAG'));
7954: OE_MSG_PUB.ADD;
7955: end if;
7956: end if;
7972: oe_debug_pub.add('Rule Type is :'||l_rule_type);
7973: END IF;
7974: IF l_rule_type = 'PP_DR_ALL' or l_rule_type = 'PP_DR_PP' THEN
7975: l_return_status := FND_API.G_RET_STS_ERROR;
7976: FND_MESSAGE.Set_Name('ONT','OE_INVALID_ATTRIBUTE');
7977: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
7978: OE_Order_Util.Get_Attribute_Name('ACCOUNTING_RULE_ID'));
7979: OE_MSG_PUB.ADD;
7980: END IF; --End of rule type
7973: END IF;
7974: IF l_rule_type = 'PP_DR_ALL' or l_rule_type = 'PP_DR_PP' THEN
7975: l_return_status := FND_API.G_RET_STS_ERROR;
7976: FND_MESSAGE.Set_Name('ONT','OE_INVALID_ATTRIBUTE');
7977: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
7978: OE_Order_Util.Get_Attribute_Name('ACCOUNTING_RULE_ID'));
7979: OE_MSG_PUB.ADD;
7980: END IF; --End of rule type
7981: END IF;--End of accounting type id is not null
8031: AND organization_id = p_line_rec.ship_from_org_id
8032: and rownum=1;
8033: END IF;
8034:
8035: fnd_message.set_name('ONT','OE_INVALID_ORDER_QUANTITY_UOM');
8036: fnd_message.set_token('ITEM',nvl(p_line_rec.ordered_item,p_line_rec.inventory_item_id));
8037: fnd_message.set_token('UOM', l_uom);
8038: l_return_status := FND_API.G_RET_STS_ERROR;
8039: OE_MSG_PUB.ADD;
8032: and rownum=1;
8033: END IF;
8034:
8035: fnd_message.set_name('ONT','OE_INVALID_ORDER_QUANTITY_UOM');
8036: fnd_message.set_token('ITEM',nvl(p_line_rec.ordered_item,p_line_rec.inventory_item_id));
8037: fnd_message.set_token('UOM', l_uom);
8038: l_return_status := FND_API.G_RET_STS_ERROR;
8039: OE_MSG_PUB.ADD;
8040: exception
8033: END IF;
8034:
8035: fnd_message.set_name('ONT','OE_INVALID_ORDER_QUANTITY_UOM');
8036: fnd_message.set_token('ITEM',nvl(p_line_rec.ordered_item,p_line_rec.inventory_item_id));
8037: fnd_message.set_token('UOM', l_uom);
8038: l_return_status := FND_API.G_RET_STS_ERROR;
8039: OE_MSG_PUB.ADD;
8040: exception
8041: when no_data_found then
8665: -- to change the schedule ship date.
8666:
8667: IF l_type_code = 'ARRIVAL' THEN
8668:
8669: FND_MESSAGE.SET_NAME('ONT','OE_SCH_INV_SHP_DATE');
8670: OE_MSG_PUB.Add;
8671:
8672: l_return_status := FND_API.G_RET_STS_ERROR;
8673:
8687: -- to change the schedule arrival date.
8688:
8689: IF nvl(l_type_code,'SHIP') = 'SHIP' THEN
8690:
8691: FND_MESSAGE.SET_NAME('ONT','OE_SCH_INV_ARR_DATE');
8692: OE_MSG_PUB.Add;
8693:
8694: l_return_status := FND_API.G_RET_STS_ERROR;
8695:
9356: p_old_line_rec.accepted_quantity <> FND_API.G_MISS_NUM AND
9357: p_old_line_rec.accepted_quantity <> p_x_line_rec.accepted_quantity
9358: THEN
9359: p_x_line_rec.accepted_quantity := p_old_line_rec.accepted_quantity;
9360: FND_MESSAGE.SET_NAME('ONT','ONT_CANNOT_UPDATE_ACCEPTANCE');
9361: OE_MSG_PUB.Add;
9362: END IF;
9363:
9364: IF p_old_line_rec.REVREC_SIGNATURE_DATE IS NOT NULL AND
9365: p_old_line_rec.REVREC_SIGNATURE_DATE <> FND_API.G_MISS_DATE AND
9366: p_old_line_rec.REVREC_SIGNATURE_DATE <> p_x_line_rec.REVREC_SIGNATURE_DATE
9367: THEN
9368: p_x_line_rec.REVREC_SIGNATURE_DATE := p_old_line_rec.REVREC_SIGNATURE_DATE;
9369: FND_MESSAGE.SET_NAME('ONT','ONT_CANNOT_UPDATE_ACCEPTANCE');
9370: OE_MSG_PUB.Add;
9371: END IF;
9372:
9373: IF p_old_line_rec.accepted_by IS NOT NULL AND
9374: p_old_line_rec.accepted_by <> FND_API.G_MISS_NUM AND
9375: p_old_line_rec.accepted_by <> p_x_line_rec.accepted_by
9376: THEN
9377: p_x_line_rec.accepted_by := p_old_line_rec.accepted_by;
9378: FND_MESSAGE.SET_NAME('ONT','ONT_CANNOT_UPDATE_ACCEPTANCE');
9379: OE_MSG_PUB.Add;
9380: END IF;
9381: --
9382: --sol_ord_er #16014165
9980: -- from the Process Order Call and if the Context field is required
9981: -- and context is not defaulted by the flex api.
9982:
9983: IF OE_OE_PRICING_AVAILABILITY.IS_PRICING_AVAILIBILITY = 'N' THEN
9984: FND_MESSAGE.SET_NAME('FND', 'ONT_CONTEXT_NOT_FOUND');
9985: OE_MSG_PUB.ADD;
9986: IF l_debug_level > 0 THEN
9987: oe_debug_pub.add('desc_flex Context Not set for OE_LINE_ATTRIBUTES DFF ') ;
9988: END IF;