[Home] [Help]
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:
48: END IF; -- End of check for UPDATE operation
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;
73:
74: IF NVL(p_line_rec.ship_set,fnd_api.g_miss_char)
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)
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)
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;
110:
111: --for bug 3450282. Added NVL condition to consider g_miss_char during comparision
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:
122: IF NOT OE_GLOBALS.EQUAL(p_line_rec.reserved_quantity
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;
137: END IF;
138:
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;
155: END IF;
156:
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
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:
178: -- schedule action is not a DB field so check for not null only
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;
187:
188: -- Return orders not supported
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:
195: -- Internal sales orders not allowed
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:
202: -- Cancellation operation not supported for quotes
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:
209: END IF; -- End of check if phase = F/N
217: x_return_status := FND_API.G_RET_STS_ERROR;
218: WHEN OTHERS THEN
219: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
220:
221: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
222: THEN
223: OE_MSG_PUB.Add_Exc_Msg
224: ( G_PKG_NAME ,
225: 'Check_Negotiation_Attributes'
219: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
220:
221: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
222: THEN
223: OE_MSG_PUB.Add_Exc_Msg
224: ( G_PKG_NAME ,
225: 'Check_Negotiation_Attributes'
226: );
227: END IF;
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:
283: IF p_line_rec.invoice_to_org_id IS NULL THEN
284: x_return_status := FND_API.G_RET_STS_ERROR;
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:
291: IF p_line_rec.tax_exempt_flag IS NULL THEN
292: x_return_status := FND_API.G_RET_STS_ERROR;
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
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:
309: IF p_line_rec.order_quantity_uom IS NULL THEN
310: x_return_status := FND_API.G_RET_STS_ERROR;
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
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:
327: -- For all items that are NOT included items OR config items,
328: -- price list, unit selling price and unit list price are required.
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:
365: END IF;
366:
375: x_return_status := FND_API.G_RET_STS_ERROR;
376: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
377: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
378: OE_Order_UTIL.Get_Attribute_Name('PRICE_LIST_ID'));
379: OE_MSG_PUB.ADD;
380: END IF;
381:
382:
383: IF p_line_rec.unit_list_price IS NULL THEN
384: x_return_status := FND_API.G_RET_STS_ERROR;
385: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
386: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
387: OE_Order_UTIL.Get_Attribute_Name('UNIT_LIST_PRICE'));
388: OE_MSG_PUB.ADD;
389: END IF;
390:
391: IF p_line_rec.unit_selling_price IS NULL THEN
392: x_return_status := FND_API.G_RET_STS_ERROR;
392: x_return_status := FND_API.G_RET_STS_ERROR;
393: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
394: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
395: OE_Order_UTIL.Get_Attribute_Name('UNIT_SELLING_PRICE'));
396: OE_MSG_PUB.ADD;
397: END IF;
398:
399:
400: END IF;
411: x_return_status := FND_API.G_RET_STS_ERROR;
412: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
413: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
414: OE_Order_UTIL.Get_Attribute_Name('SHIP_TO_ORG_ID'));
415: OE_MSG_PUB.ADD;
416: END IF;
417:
418: IF p_line_rec.payment_term_id IS NULL THEN
419: x_return_status := FND_API.G_RET_STS_ERROR;
419: x_return_status := FND_API.G_RET_STS_ERROR;
420: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
421: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
422: OE_Order_UTIL.Get_Attribute_Name('PAYMENT_TERM_ID'));
423: OE_MSG_PUB.ADD;
424: END IF;
425:
426: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN
427: IF p_line_rec.item_type_code <> 'SERVICE' THEN
442: x_return_status := FND_API.G_RET_STS_ERROR;
443: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
444: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
445: OE_Order_UTIL.Get_Attribute_Name('ACCOUNTING_RULE_DURATION'));
446: OE_MSG_PUB.ADD;
447: END IF; -- end of accounting_rule_duration null
448: END IF; -- end of variable accounting rule type
449:
450: -- WEBROOT ER bug 6826344 start
457: oe_debug_pub.add(' inside new rule validation conditions service start date');
458: x_return_status := FND_API.G_RET_STS_ERROR;
459: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
460: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Accounting Rule Start Date' );
461: OE_MSG_PUB.ADD;
462: END IF;
463: IF p_line_rec.service_end_date IS NULL THEN
464: x_return_status := FND_API.G_RET_STS_ERROR;
465: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
463: IF p_line_rec.service_end_date IS NULL THEN
464: x_return_status := FND_API.G_RET_STS_ERROR;
465: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
466: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Accounting Rule End Date' );
467: OE_MSG_PUB.ADD;
468: END IF;
469:
470: END IF;
471:
486: x_return_status := FND_API.G_RET_STS_ERROR;
487: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_RETURN_ATTRIBUTE');
488: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
489: OE_Order_UTIL.Get_Attribute_Name('SHIP_FROM_ORG_ID'));
490: OE_MSG_PUB.ADD;
491: END IF;
492:
493: IF p_line_rec.request_date IS NULL THEN
494: x_return_status := FND_API.G_RET_STS_ERROR;
494: x_return_status := FND_API.G_RET_STS_ERROR;
495: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_RETURN_ATTRIBUTE');
496: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
497: OE_Order_UTIL.Get_Attribute_Name('REQUEST_DATE'));
498: OE_MSG_PUB.ADD;
499: END IF;
500:
501: END IF;
502:
507: x_return_status := FND_API.G_RET_STS_ERROR;
508: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_RETURN_ATTRIBUTE');
509: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
510: OE_Order_UTIL.Get_Attribute_Name('TAX_DATE'));
511: OE_MSG_PUB.ADD;
512: END IF;
513:
514: -- Tax code is required under following conditions.
515: -- 1. The tax hadnling is required at line level.
592: IF nvl(l_tax_calculation_event_code, 'ENTERING') IN ('ENTERING', 'BOOKING') THEN
593:
594: x_return_status := FND_API.G_RET_STS_ERROR;
595: FND_MESSAGE.SET_NAME('ONT','OE_VAL_TAX_CODE_REQD');
596: OE_MSG_PUB.ADD;
597: END IF;
598: END IF;
599:
600: END IF;
606: x_return_status := FND_API.G_RET_STS_ERROR;
607: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_SERVICE_DURATION');
608: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
609: OE_Order_UTIL.Get_Attribute_Name('SERVICE_DURATION'));
610: OE_MSG_PUB.ADD;
611: END IF;
612: END IF;
613: */
614:
619: IF p_line_rec.service_start_date IS NULL THEN
620: x_return_status := FND_API.G_RET_STS_ERROR;
621: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
622: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', OE_Order_UTIL.Get_Attribute_Name('SERVICE_START_DATE'));
623: OE_MSG_PUB.ADD;
624: END IF;
625: IF p_line_rec.service_end_date IS NULL THEN
626: x_return_status := FND_API.G_RET_STS_ERROR;
627: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
625: IF p_line_rec.service_end_date IS NULL THEN
626: x_return_status := FND_API.G_RET_STS_ERROR;
627: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
628: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', OE_Order_UTIL.Get_Attribute_Name('SERVICE_END_DATE'));
629: OE_MSG_PUB.ADD;
630: END IF;
631: END IF;
632:
633: IF p_line_rec.service_duration IS NULL THEN
634: x_return_status := FND_API.G_RET_STS_ERROR;
635: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
636: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
637: OE_Order_UTIL.Get_Attribute_Name('SERVICE_DURATION'));
638: OE_MSG_PUB.ADD;
639: END IF;
640: IF p_line_rec.service_period IS NULL THEN
641: x_return_status := FND_API.G_RET_STS_ERROR;
642: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
641: x_return_status := FND_API.G_RET_STS_ERROR;
642: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
643: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
644: OE_Order_UTIL.Get_Attribute_Name('SERVICE_PERIOD'));
645: OE_MSG_PUB.ADD;
646: END IF;
647: END IF;
648: /* End of 1888018 change */
649:
657: THEN
658: IF (OE_LINE_UTIL.Is_Over_Return(p_line_rec)) THEN
659: x_return_status := FND_API.G_RET_STS_ERROR;
660: FND_MESSAGE.Set_Name('ONT', 'OE_RETURN_INVALID_QUANTITY');
661: OE_MSG_PUB.ADD;
662: END IF;
663:
664: END IF;
665:
672: IF (OE_CODE_CONTROL.Code_Release_Level >= '110509' and p_line_rec.order_firmed_date > l_hdr_booked_date
673: and p_line_rec.creation_date <= l_hdr_booked_date) THEN
674: x_return_status := FND_API.G_RET_STS_ERROR;
675: FND_MESSAGE.Set_Name('ONT','ONT_ORDER_FIRMED_DATE_INVALID');
676: OE_MSG_PUB.Add;
677: END IF;
678: --end
679:
680: /* Fix Bug 2429989: Returning Revision Controlled Items */
699: IF l_revision_controlled = 'Y' THEN
700: x_return_status := FND_API.G_RET_STS_ERROR;
701: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_RETURN_ATTRIBUTE');
702: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', OE_Order_UTIL.Get_Attribute_Name('ITEM_REVISION'));
703: OE_MSG_PUB.ADD;
704: END IF;
705: END IF;
706: END IF;
707: */
711:
712: EXCEPTION
713: WHEN OTHERS THEN
714: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
715: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
716: THEN
717: OE_MSG_PUB.Add_Exc_Msg
718: ( G_PKG_NAME
719: , 'Check_Book_Reqd_Attributes'
713: WHEN OTHERS THEN
714: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
715: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
716: THEN
717: OE_MSG_PUB.Add_Exc_Msg
718: ( G_PKG_NAME
719: , 'Check_Book_Reqd_Attributes'
720: );
721: END IF;
805: WHEN NO_DATA_FOUND THEN
806: l_set_name := null;
807: END;
808: FND_MESSAGE.Set_Token('SHIP_SET',l_set_name);
809: OE_MSG_PUB.Add;
810: x_return_status := FND_API.G_RET_STS_ERROR;
811: END IF;
812:
813: END IF;
842: WHEN NO_DATA_FOUND THEN
843: l_model_name := null;
844: END;
845: FND_MESSAGE.Set_Token('MODEL',nvl(l_model_name,l_model_item_id));
846: OE_MSG_PUB.Add;
847: x_return_status := FND_API.G_RET_STS_ERROR;
848: END IF;
849: END IF;
850:
870: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
871:
872: WHEN OTHERS THEN
873: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
874: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
875: THEN
876: OE_MSG_PUB.Add_Exc_Msg
877: ( 'OE_VALIDATE_LINE',
878: 'Validate_Shipset_SMC');
872: WHEN OTHERS THEN
873: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
874: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
875: THEN
876: OE_MSG_PUB.Add_Exc_Msg
877: ( 'OE_VALIDATE_LINE',
878: 'Validate_Shipset_SMC');
879: END IF;
880: END Validate_Shipset_SMC;
947: END IF;
948: FND_MESSAGE.SET_NAME('ONT', 'OE_CONFIG_NO_DECIMALS');
949: FND_MESSAGE.SET_TOKEN('ITEM', nvl(OE_Id_To_Value.Inventory_Item(p_item_id),p_item_id));
950: FND_Message.Set_Token('LINE_NUM', p_line_num);
951: OE_MSG_PUB.Add;
952: x_return_status := FND_API.G_RET_STS_ERROR;
953: END IF;
954:
955: ELSE
960: END IF;
961: FND_MESSAGE.SET_NAME('ONT', 'OE_CONFIG_NO_DECIMALS');
962: FND_MESSAGE.SET_TOKEN('ITEM', nvl(OE_Id_To_Value.Inventory_Item(p_item_id),p_item_id));
963: FND_Message.Set_Token('LINE_NUM', p_line_num);
964: OE_MSG_PUB.Add;
965: x_return_status := FND_API.G_RET_STS_ERROR;
966: END IF;
967:
968: END IF;
1005: x_return_status := FND_API.G_RET_STS_SUCCESS;
1006: ELSE
1007: fnd_message.set_name('ONT', 'OE_DECIMAL_MAX_PRECISION');
1008: -- move INV error message to OE message stack
1009: oe_msg_pub.add;
1010: x_return_status := FND_API.G_RET_STS_ERROR;
1011: END IF;
1012: ELSIF l_qty_return_status = 'E' THEN
1013: oe_msg_pub.add;
1009: oe_msg_pub.add;
1010: x_return_status := FND_API.G_RET_STS_ERROR;
1011: END IF;
1012: ELSIF l_qty_return_status = 'E' THEN
1013: oe_msg_pub.add;
1014: x_return_status := FND_API.G_RET_STS_ERROR;
1015: END IF;
1016:
1017: ELSIF l_qty_return_status = 'S' THEN
1107:
1108: FND_MESSAGE.Set_TOKEN('MODEL', nvl(l_ordered_item,l_inv_item_id));
1109: FND_MESSAGE.Set_TOKEN('PTYPECODE', l_item_type_code);
1110:
1111: OE_MSG_PUB.Add;
1112:
1113: x_return_status := FND_API.G_RET_STS_ERROR;
1114:
1115: END IF;
1194: oe_debug_pub.add(' Validate Line Type Line Cat Code from the UI: '||p_line_rec.line_category_code);
1195: END IF;
1196: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1197: fnd_message.set_token('ATTRIBUTE', OE_Order_Util.Get_Attribute_Name('Line_type_id'));
1198: OE_MSG_PUB.Add;
1199: RAISE FND_API.G_EXC_ERROR;
1200: end if;
1201: END IF;
1202:
1211: oe_debug_pub.add('workflow item type changed', 1);
1212:
1213: -- FND_Message.Set_Name('ONT', 'OE_WF_ITEM_TYPE_CHANGED');
1214: FND_Message.Set_Name('ONT', 'OE_ITEM_TYPE_CONST');
1215: oe_msg_pub.add;
1216: RAISE FND_API.G_EXC_ERROR;
1217: END IF;
1218:
1219: IF (NOT OE_GLOBALS.EQUAL(p_line_rec.line_type_id,p_old_line_rec.line_type_id))
1268: IF l_debug_level > 0 then
1269: oe_debug_pub.add('No explicit assignment exists',2);
1270: END IF;
1271: FND_MESSAGE.SET_NAME('ONT','OE_EXP_ASSIGN_REQ');
1272: OE_MSG_PUB.ADD;
1273: RAISE FND_API.G_EXC_ERROR;
1274: END IF;
1275:
1276: END IF;
1281: END IF;
1282: EXCEPTION
1283: WHEN NO_DATA_FOUND THEN
1284: FND_MESSAGE.SET_NAME('ONT','OE_FLOW_CNT_CHANGE');
1285: OE_MSG_PUB.ADD;
1286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1287: WHEN FND_API.G_EXC_ERROR THEN
1288: RAISE FND_API.G_EXC_ERROR;
1289:
1287: WHEN FND_API.G_EXC_ERROR THEN
1288: RAISE FND_API.G_EXC_ERROR;
1289:
1290: WHEN OTHERS THEN
1291: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1292: THEN
1293: OE_MSG_PUB.Add_Exc_Msg
1294: ( G_PKG_NAME ,
1295: 'Validate_Line_Type'
1289:
1290: WHEN OTHERS THEN
1291: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1292: THEN
1293: OE_MSG_PUB.Add_Exc_Msg
1294: ( G_PKG_NAME ,
1295: 'Validate_Line_Type'
1296: );
1297: END IF;
1351: RETURN TRUE;
1352: EXCEPTION
1353: WHEN NO_DATA_FOUND THEN
1354: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ITEM_WHSE');
1355: OE_MSG_PUB.add;
1356: RETURN FALSE;
1357: WHEN OTHERS THEN
1358: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ITEM_WHSE');
1359: OE_MSG_PUB.add;
1355: OE_MSG_PUB.add;
1356: RETURN FALSE;
1357: WHEN OTHERS THEN
1358: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ITEM_WHSE');
1359: OE_MSG_PUB.add;
1360: RETURN FALSE;
1361: END Validate_Receiving_Org;
1362:
1363: -- bug 6647169 begin
1383: oe_debug_pub.add('Old Shipable flag, New shipable flag : '||l_shipable_flag_old||l_shipable_flag_new);
1384: IF (l_shipable_flag_old <> l_shipable_flag_new AND l_shipable_flag_new = 'N') THEN
1385: l_result := FALSE;
1386: FND_MESSAGE.SET_NAME('ONT','OE_INVLD_CHG_SHP_FROM_ORG');
1387: oe_msg_pub.add;
1388: ELSE
1389: l_result := TRUE;
1390: END IF;
1391: EXCEPTION when others then
1528: oe_debug_pub.add('RR: No data found',1);
1529: END IF;
1530:
1531: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ITEM_WHSE');
1532: OE_MSG_PUB.add;
1533: RETURN FALSE;
1534:
1535: WHEN OTHERS THEN
1536: IF l_debug_level > 0 then
1536: IF l_debug_level > 0 then
1537: oe_debug_pub.add('RR: OTHERS',1);
1538: END IF;
1539: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ITEM_WHSE');
1540: OE_MSG_PUB.add;
1541: RETURN FALSE;
1542:
1543: END Validate_Item_Warehouse;
1544:
1930: ELSIF (l_profile = 'R') THEN
1931: RETURN FALSE;
1932: ELSE -- warning
1933: FND_MESSAGE.SET_NAME('ONT','OE_RETURN_ITEM_MISMATCH_WARNIN');
1934: OE_MSG_PUB.ADD;
1935: END IF;
1936:
1937: END IF;
1938: IF l_debug_level > 0 then
2008: ELSIF (l_profile = 'R') THEN
2009: RETURN FALSE;
2010: ELSE -- warning
2011: FND_MESSAGE.SET_NAME('ONT','OE_UNFULFILLED_LINE_WARNING');
2012: OE_MSG_PUB.ADD;
2013: END IF;
2014:
2015: END IF;
2016: IF l_debug_level > 0 then
2066: IF l_returnable_flag = 'Y' THEN
2067: x_return_status := FND_API.G_RET_STS_SUCCESS;
2068: ELSE
2069: fnd_message.set_name('ONT', 'OE_ITEM_NOT_RETURNABLE');
2070: OE_MSG_PUB.add;
2071: x_return_status := FND_API.G_RET_STS_ERROR;
2072: END IF;
2073:
2074: EXCEPTION
2077: oe_debug_pub.add('Validate_Return_Item: No data found',1);
2078: END IF;
2079: x_return_status := FND_API.G_RET_STS_ERROR;
2080: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ITEM_WHSE');
2081: OE_MSG_PUB.add;
2082: WHEN OTHERS THEN
2083: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2084: IF l_debug_level > 0 then
2085: oe_debug_pub.add('Validate_Return_Item: When Others',1);
2110:
2111: IF NOT OE_GLOBALS.EQUAL(l_tax_code,p_tax_code) THEN
2112: fnd_message.set_name('ONT','OE_RETURN_ATTR_CANNOT_CHANGE');
2113: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Tax Code');
2114: OE_MSG_PUB.Add;
2115: RETURN FALSE;
2116: END IF;
2117:
2118: if l_debug_level > 0 then
2125: if l_debug_level > 0 then
2126: oe_debug_pub.add('Validate_Return_Reference: No data found',1);
2127: end if;
2128: fnd_message.set_name('ONT', 'OE_RETURN_INVALID_SO_LINE');
2129: OE_MSG_PUB.Add;
2130: RETURN FALSE;
2131: WHEN OTHERS THEN
2132: if l_debug_level > 0 then
2133: oe_debug_pub.add('Validate_Return_Reference: When Others',1);
2132: if l_debug_level > 0 then
2133: oe_debug_pub.add('Validate_Return_Reference: When Others',1);
2134: end if;
2135: fnd_message.set_name('ONT', 'OE_RETURN_INVALID_SO_LINE');
2136: OE_MSG_PUB.Add;
2137: RETURN FALSE;
2138: END Validate_Return_Reference_Tax;
2139:
2140: FUNCTION Validate_Return_Reference
2163: and line_category_code = 'ORDER';
2164:
2165: IF l_source_document_type_id = 10 THEN
2166: fnd_message.set_name('ONT','OE_NO_RMA_FOR_INTERNAL_ORDER');
2167: OE_MSG_PUB.Add;
2168: RETURN FALSE;
2169: END IF;
2170:
2171: IF NOT OE_GLOBALS.EQUAL(l_uom_code,p_uom_code) THEN
2170:
2171: IF NOT OE_GLOBALS.EQUAL(l_uom_code,p_uom_code) THEN
2172: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2173: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Unit Of Measure');
2174: OE_MSG_PUB.Add;
2175: RETURN FALSE;
2176: END IF;
2177:
2178: IF l_booked_flag = 'Y' THEN
2178: IF l_booked_flag = 'Y' THEN
2179: RETURN TRUE;
2180: ELSE
2181: fnd_message.set_name('ONT', 'OE_RETURN_UNBOOKED_ORDER');
2182: OE_MSG_PUB.Add;
2183: END IF;
2184: IF l_debug_level > 0 then
2185: oe_debug_pub.add('Exit Validate_Return_Reference',1);
2186: END IF;
2191: IF l_debug_level > 0 then
2192: oe_debug_pub.add('Validate_Return_Reference: No data found',1);
2193: END IF;
2194: fnd_message.set_name('ONT', 'OE_RETURN_INVALID_SO_LINE');
2195: OE_MSG_PUB.Add;
2196: RETURN FALSE;
2197: WHEN OTHERS THEN
2198: IF l_debug_level > 0 then
2199: oe_debug_pub.add('Validate_Return_Reference: When Others',1);
2198: IF l_debug_level > 0 then
2199: oe_debug_pub.add('Validate_Return_Reference: When Others',1);
2200: END IF;
2201: fnd_message.set_name('ONT', 'OE_RETURN_INVALID_SO_LINE');
2202: OE_MSG_PUB.Add;
2203: RETURN FALSE;
2204: END Validate_Return_Reference;
2205:
2206: /*
2234:
2235: IF l_ord_qty > 0 THEN
2236: IF p_ord_qty <= 0 THEN
2237: fnd_message.set_name('ONT','OE_LINE_HAS_RMA_CANNOT_CANCEL');
2238: OE_MSG_PUB.Add;
2239: RETURN FALSE;
2240: ELSE
2241: IF p_ord_qty < l_ord_qty THEN
2242: fnd_message.set_name('ONT','OE_LINE_HAS_RMA_HIGHER_QTY');
2239: RETURN FALSE;
2240: ELSE
2241: IF p_ord_qty < l_ord_qty THEN
2242: fnd_message.set_name('ONT','OE_LINE_HAS_RMA_HIGHER_QTY');
2243: OE_MSG_PUB.Add;
2244: RETURN FALSE;
2245: END IF;
2246: END IF;
2247: END IF;
2551:
2552: x_return_status := FND_API.G_RET_STS_ERROR;
2553: FND_MESSAGE.SET_NAME('ONT','ONT_COM_CUSTOMER_MISMATCH');
2554: FND_MESSAGE.SET_TOKEN('CUSTOMER','');
2555: OE_MSG_PUB.ADD;
2556: end if;
2557:
2558: /* Fix Bug # 3015881 End */
2559:
2581: AND p_line_rec.agreement_id IS NOT NULL THEN
2582: x_return_status := FND_API.G_RET_STS_ERROR;
2583: fnd_message.set_name('ONT','ONT_COM_AGREEMENT_MISMATCH');
2584: FND_MESSAGE.SET_TOKEN('AGREEMENT',OE_Id_To_Value.Agreement(p_line_rec.agreement_id));
2585: OE_MSG_PUB.Add;
2586: END IF;
2587:
2588: IF NOT OE_GLOBALS.EQUAL(nvl(l_inventory_item_id, p_line_rec.inventory_item_id), p_line_rec.inventory_item_id) THEN
2589: x_return_status := FND_API.G_RET_STS_ERROR;
2588: IF NOT OE_GLOBALS.EQUAL(nvl(l_inventory_item_id, p_line_rec.inventory_item_id), p_line_rec.inventory_item_id) THEN
2589: x_return_status := FND_API.G_RET_STS_ERROR;
2590: fnd_message.set_name('ONT','ONT_COM_ITEM_MISMATCH');
2591: FND_MESSAGE.SET_TOKEN('ITEM', OE_Id_To_Value.Inventory_Item(p_line_rec.inventory_item_id));
2592: OE_MSG_PUB.Add;
2593: END IF;
2594: IF l_debug_level > 0 then
2595: oe_debug_pub.add('OEXLLINB: commitment end date is: '||l_comm_end_date, 3);
2596: END IF;
2611: THEN
2612: x_return_status := FND_API.G_RET_STS_ERROR;
2613: fnd_message.set_name('ONT','ONT_COM_END_DATE');
2614: FND_MESSAGE.SET_TOKEN('COMMITMENT',l_commitment_number);
2615: OE_MSG_PUB.Add;
2616: END IF;
2617: END IF;
2618: END IF;
2619:
2642: IF l_commitment_bal <= 0 THEN
2643: x_return_status := FND_API.G_RET_STS_ERROR;
2644: FND_MESSAGE.SET_NAME('ONT','OE_COM_ZERO_BALANCE');
2645: FND_MESSAGE.SET_TOKEN('COMMITMENT',l_commitment_number);
2646: OE_MSG_PUB.Add;
2647: END IF;
2648:
2649: END IF;
2650:
2660: OE_DEBUG_PUB.Add('Validate_Commitment: When no data found');
2661: END IF;
2662: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2663: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Commitment Number');
2664: OE_MSG_PUB.Add;
2665:
2666: WHEN OTHERS THEN
2667:
2668: x_return_status := FND_API.G_RET_STS_ERROR;
2715: oe_debug_pub.add('service / part of smc model', 4);
2716: END IF;
2717: FND_MESSAGE.SET_NAME('ONT', 'OE_DS_NOT_VALID_ITEM');
2718: FND_MESSAGE.SET_TOKEN('ITEM', nvl(p_line_rec.ordered_item,p_line_rec.inventory_item_id));
2719: OE_MSG_PUB.Add;
2720: x_return_status := FND_API.G_RET_STS_ERROR;
2721: RETURN;
2722: ELSE
2723: IF l_debug_level > 0 then
2729: IF l_debug_level > 0 then
2730: oe_debug_pub.add('Cannot dropship non-standard item',2);
2731: END IF;
2732: FND_MESSAGE.SET_NAME('ONT', 'OE_DS_NOT_ALLOWED');
2733: OE_MSG_PUB.Add;
2734: x_return_status := FND_API.G_RET_STS_ERROR;
2735: RETURN;
2736: END IF;
2737: END IF;
2776: FND_MESSAGE.SET_NAME('ONT', 'OE_DS_NOT_ENABLED');
2777: FND_MESSAGE.SET_TOKEN('ITEM', nvl(p_line_rec.ordered_item,p_line_rec.inventory_item_id));
2778: FND_MESSAGE.SET_TOKEN('ORG', nvl(p_line_rec.ship_from_org_id,
2779: OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID')));
2780: OE_MSG_PUB.Add;
2781: x_return_status := FND_API.G_RET_STS_ERROR;
2782: END IF;
2783:
2784: END IF; -- if external
2793: IF l_debug_level > 0 then
2794: oe_debug_pub.add('item under ato model', 4);
2795: END IF;
2796: FND_MESSAGE.SET_NAME('ONT', 'OE_DS_CHANGE_NOT_ALLOWED');
2797: OE_MSG_PUB.Add;
2798: x_return_status := FND_API.G_RET_STS_ERROR;
2799: END IF;
2800: IF l_debug_level > 0 then
2801: oe_debug_pub.add('leaving validate_source_type', 3);
2863: OE_ORDER_SCH_UTIL.OESCH_PERFORM_SCHEDULING = 'Y' THEN
2864:
2865: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_SET_OPR');
2866: FND_MESSAGE.SET_TOKEN('ITEMTYPE', p_line_rec.item_type_code);
2867: OE_MSG_PUB.ADD;
2868: IF l_debug_level > 0 then
2869: oe_debug_pub.add('Set- not allowed for this itemtype');
2870: END IF;
2871: RETURN FALSE;
2890: oe_debug_pub.add('Set name - not allowed for this itemtype');
2891: END IF;
2892: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_SET_OPR');
2893: FND_MESSAGE.SET_TOKEN('ITEMTYPE', p_line_rec.item_type_code);
2894: OE_MSG_PUB.ADD;
2895: RETURN FALSE;
2896: END IF; -- set name
2897: END IF; -- main
2898:
2919: x_return_status := FND_API.G_RET_STS_SUCCESS;
2920:
2921: IF LENGTHB(p_line_rec.user_item_description) > 240 THEN
2922: fnd_message.set_name('ONT','ONT_USER_ITEM_DESC_TOO_LONG');
2923: OE_MSG_PUB.Add;
2924: IF l_debug_level > 0 then
2925: Oe_debug_pub.add('The length of user_item_description should not exceed 240 characters for drop ship lines.',3);
2926: END IF;
2927: x_return_status := FND_API.G_RET_STS_ERROR;
3019: oe_debug_pub.add('Blanket Line Number is not supplied: Blanket #:'||
3020: p_line_rec.blanket_number || ', Inventory Item #:'||p_line_rec.inventory_item_id, 2);
3021: end if;
3022: FND_MESSAGE.SET_NAME('ONT', 'OE_BLKT_NO_BLANKET_LINE_NUM');
3023: OE_MSG_PUB.Add;
3024: x_return_status := FND_API.G_RET_STS_ERROR;
3025: END IF;
3026:
3027:
3042: oe_debug_pub.add('Blankets only support standard items', 1);
3043: end if;
3044:
3045: FND_MESSAGE.SET_NAME('ONT', 'OE_BLKT_NON_STANDARD_ITEM');
3046: OE_MSG_PUB.Add;
3047: x_return_status := FND_API.G_RET_STS_ERROR;
3048:
3049: END IF;
3050: ELSE --for bug 3372805
3054: oe_debug_pub.add('Blankets does not support Included items', 1);
3055: end if;
3056:
3057: FND_MESSAGE.SET_NAME('ONT', 'OE_BLKT_INCLUDED_ITEM');
3058: OE_MSG_PUB.Add;
3059: x_return_status := FND_API.G_RET_STS_ERROR;
3060: END IF;
3061:
3062: END IF; -- End of Pack -J changes.
3063: -- Blanket AND Agreement cannot co-exist on release line
3064:
3065: IF p_line_rec.agreement_id IS NOT NULL THEN
3066: FND_MESSAGE.SET_NAME('ONT', 'OE_BLKT_AGREEMENT_EXISTS');
3067: OE_MSG_PUB.Add;
3068: x_return_status := FND_API.G_RET_STS_ERROR;
3069: END IF;
3070:
3071: -- If any of the above checks failed, no need to proceed with
3170: FND_MESSAGE.SET_NAME('ONT', 'OE_BLKT_INVALID_ATTRIBUTE');
3171: fnd_message.set_token('ATTRIBUTE', OE_Order_Util.Get_Attribute_Name('INVENTORY_ITEM_ID'));
3172: --for bug 3257240
3173: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE', OE_Id_To_Value.Inventory_Item(l_item_id));
3174: OE_MSG_PUB.Add;
3175: x_return_status := FND_API.G_RET_STS_ERROR;
3176: END IF;
3177: ELSIF l_item_context = 'CUST' THEN
3178:
3184: FND_MESSAGE.SET_NAME('ONT', 'OE_BLKT_INVALID_ATTRIBUTE');
3185: fnd_message.set_token('ATTRIBUTE', OE_Order_Util.Get_Attribute_Name('CUSTOMER_ITEM_ID'));
3186: --for bug 3257240
3187: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE', OE_Id_To_Value.Inventory_Item(l_item_id));
3188: OE_MSG_PUB.Add;
3189: x_return_status := FND_API.G_RET_STS_ERROR;
3190: END IF;
3191:
3192: ELSIF l_item_context = 'ALL' THEN
3220: FND_MESSAGE.SET_NAME('ONT', 'OE_BLKT_INVALID_ATTRIBUTE');
3221: fnd_message.set_token('ATTRIBUTE', OE_Order_Util.Get_Attribute_Name('INVENTORY_ITEM_ID'));
3222: --for bug 3257240
3223: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE', OE_Id_To_Value.Inventory_Item(l_item_id));
3224: OE_MSG_PUB.Add;
3225: x_return_status := FND_API.G_RET_STS_ERROR;
3226: END;
3227:
3228: ELSE
3235: FND_MESSAGE.SET_NAME('ONT', 'OE_BLKT_INVALID_ATTRIBUTE');
3236: fnd_message.set_token('ATTRIBUTE', OE_Order_Util.Get_Attribute_Name('ORDERED_ITEM'));
3237: --for bug 3257240
3238: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE', OE_Id_To_Value.Inventory_Item(l_item_id));
3239: OE_MSG_PUB.Add;
3240: x_return_status := FND_API.G_RET_STS_ERROR;
3241: END IF;
3242: END IF;
3243: END IF;
3279: , x_org => l_customer_name
3280: , x_customer_number => l_customer_number
3281: );
3282: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE',l_customer_name);
3283: OE_MSG_PUB.Add;
3284: x_return_status := FND_API.G_RET_STS_ERROR;
3285: end;
3286: else
3287: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_ATTRIBUTE');
3293: , x_org => l_customer_name
3294: , x_customer_number => l_customer_number
3295: );
3296: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE',l_customer_name);
3297: OE_MSG_PUB.Add;
3298: x_return_status := FND_API.G_RET_STS_ERROR;
3299: end if;
3300: END IF;
3301:
3313: if l_debug_level > 0 then
3314: oe_debug_pub.add('Blanket order is currently on hold', 1);
3315: end if;
3316: FND_MESSAGE.SET_NAME('ONT', 'OE_BLKT_ON_HOLD');
3317: OE_MSG_PUB.Add;
3318: x_return_status := FND_API.G_RET_STS_ERROR;
3319: END IF;
3320:
3321: --Active Blanket Validation for release lines.For Bug 3192386
3328: if l_debug_level > 0 then
3329: oe_debug_pub.add('Blanket is not in Active Status', 1);
3330: end if;
3331: FND_MESSAGE.SET_NAME('ONT', 'OE_BLKT_INVALID_BLANKET');
3332: OE_MSG_PUB.Add;
3333: x_return_status := FND_API.G_RET_STS_ERROR;
3334: END IF;
3335:
3336:
3355: if l_debug_level > 0 then
3356: oe_debug_pub.add('Request date is not within active blanket line dates', 1);
3357: end if;
3358: FND_MESSAGE.SET_NAME('ONT', 'OE_BLKT_INVALID_LINE_REQ_DATE');
3359: OE_MSG_PUB.Add;
3360: x_return_status := FND_API.G_RET_STS_ERROR;
3361: END IF;
3362:
3363:
3381: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name
3382: ('PRICE_LIST_ID'));
3383: --for bug 3257240
3384: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE',OE_Id_To_Value.Price_List(l_price_list_id));
3385: OE_MSG_PUB.ADD;
3386: x_return_status := FND_API.G_RET_STS_ERROR;
3387: END IF;
3388: END IF;
3389:
3413: , x_ship_to_postal_code => l_postal_code
3414: , x_ship_to_country => l_country
3415: );
3416: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE',l_org);
3417: OE_MSG_PUB.ADD;
3418: x_return_status := FND_API.G_RET_STS_ERROR;
3419: END IF;
3420: END IF;
3421:
3445: , x_invoice_to_postal_code => l_postal_code
3446: , x_invoice_to_country => l_country
3447: );
3448: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE',l_org);
3449: OE_MSG_PUB.ADD;
3450: x_return_status := FND_API.G_RET_STS_ERROR;
3451: END IF;
3452: END IF;
3453:
3464: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name
3465: ('FREIGHT_TERMS_CODE'));
3466: --for bug 3257240
3467: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE',OE_Id_To_Value.Freight_Terms(l_freight_terms_code));
3468: OE_MSG_PUB.ADD;
3469: x_return_status := FND_API.G_RET_STS_ERROR;
3470: END IF;
3471: END IF;
3472:
3483: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name
3484: ('SHIPPING_METHOD_CODE'));
3485: --for bug 3257240
3486: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE',OE_Id_To_Value.Ship_Method(l_shipping_method_code));
3487: OE_MSG_PUB.ADD;
3488: x_return_status := FND_API.G_RET_STS_ERROR;
3489: END IF;
3490: END IF;
3491:
3502: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name
3503: ('PAYMENT_TERM_ID'));
3504: --for bug 3257240
3505: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE',OE_Id_To_Value.Payment_Term(l_payment_term_id));
3506: OE_MSG_PUB.ADD;
3507: x_return_status := FND_API.G_RET_STS_ERROR;
3508: END IF;
3509: END IF;
3510:
3521: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name
3522: ('ACCOUNTING_RULE_ID'));
3523: --for bug 3257240
3524: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE',OE_Id_To_Value.Accounting_Rule(l_accounting_rule_id));
3525: OE_MSG_PUB.ADD;
3526: x_return_status := FND_API.G_RET_STS_ERROR;
3527: END IF;
3528: END IF;
3529:
3540: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name
3541: ('INVOICING_RULE_ID'));
3542: --for bug 3257240
3543: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE',OE_Id_To_Value.Invoicing_Rule(l_invoicing_rule_id));
3544: OE_MSG_PUB.ADD;
3545: x_return_status := FND_API.G_RET_STS_ERROR;
3546: END IF;
3547: END IF;
3548:
3552: oe_debug_pub.add('Blanket Values combination is not valid: Blanket #:'||
3553: p_line_rec.blanket_number || ', Blanket Line #:'||p_line_rec.blanket_line_number, 2);
3554: end if;
3555: FND_MESSAGE.SET_NAME('ONT', 'OE_BLKT_INVALID_BLANKET');
3556: OE_MSG_PUB.Add;
3557: x_return_status := FND_API.G_RET_STS_ERROR;
3558:
3559: WHEN FND_API.G_EXC_ERROR THEN
3560: if l_debug_level > 0 then
3573: WHEN OTHERS THEN
3574:
3575: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3576:
3577: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3578: THEN
3579: OE_MSG_PUB.Add_Exc_Msg
3580: ( 'OE_VALIDATE_LINE',
3581: 'Validate_Blanket_Values');
3575: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3576:
3577: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3578: THEN
3579: OE_MSG_PUB.Add_Exc_Msg
3580: ( 'OE_VALIDATE_LINE',
3581: 'Validate_Blanket_Values');
3582: END IF;
3583:
3833:
3834: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
3835: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
3836: OE_Order_UTIL.Get_Attribute_Name('LINE_ID'));
3837: OE_MSG_PUB.Add;
3838:
3839: END IF;
3840: IF l_debug_level > 0 then
3841: oe_debug_pub.add('2 '||l_return_status, 1);
3847:
3848: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
3849: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
3850: OE_Order_UTIL.Get_Attribute_Name('INVENTORY_ITEM_ID'));
3851: OE_MSG_PUB.Add;
3852:
3853: END IF;
3854: IF l_debug_level > 0 then
3855: oe_debug_pub.add('3 '||l_return_status, 1);
3861:
3862: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
3863: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
3864: OE_Order_UTIL.Get_Attribute_Name('LINE_TYPE_ID'));
3865: OE_MSG_PUB.Add;
3866:
3867: ELSIF p_line_rec.line_type_id IS NOT NULL AND -- Bug 5873408
3868: ( nvl(p_line_rec.transaction_phase_code, 'F') <> 'N' )
3869: THEN
3897:
3898: -- Feature not supported prior to 11i10, raise error
3899: IF p_line_rec.transaction_phase_code = 'N' THEN
3900: FND_MESSAGE.SET_NAME('ONT','OE_QUOTE_INVALID_RELEASE');
3901: OE_MSG_PUB.ADD;
3902: RAISE FND_API.G_EXC_ERROR;
3903: END IF;
3904:
3905: END IF;
3919:
3920: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
3921: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
3922: OE_Order_UTIL.Get_Attribute_Name('RETURN_REASON_CODE'));
3923: OE_MSG_PUB.Add;
3924: END IF;
3925:
3926: -- Set the G_REF_RMA if the RMA is getting created or the reference is
3927: -- changing.
3978: OR l_scheduling_level_code = OE_SCHEDULE_UTIL.SCH_LEVEL_FIVE) THEN
3979:
3980: FND_MESSAGE.SET_NAME('ONT', 'OE_SCH_INACTIVE_STD_ONLY');
3981: FND_MESSAGE.SET_TOKEN('LTYPE',nvl(Oe_Schedule_Util.sch_cached_line_type ,'0'));
3982: OE_MSG_PUB.Add;
3983: l_return_status := FND_API.G_RET_STS_ERROR;
3984: END IF;
3985:
3986: END IF;
3994: oe_debug_pub.add( 'A SERVICE LINE ', 1 ) ;
3995: END IF;
3996:
3997: FND_MESSAGE.SET_NAME('ONT','OE_SCH_NO_ACTION_DONE_NO_EXP');
3998: OE_MSG_PUB.Add;
3999: l_return_status := FND_API.G_RET_STS_ERROR;
4000: END IF;
4001: ---- End 2720165 --
4002:
4021: AND secondary_inventory_name = p_line_rec.subinventory;
4022: EXCEPTION
4023: WHEN OTHERS THEN
4024: fnd_message.set_name('ONT','OE_SUBINV_INVALID');
4025: OE_MSG_PUB.Add;
4026: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4027: END;
4028: END IF;
4029: END IF;
4033: AND p_line_rec.operation =OE_GLOBALS.G_OPR_UPDATE
4034: AND nvl(p_line_rec.split_action_code,'X')<>'SPLIT'
4035: THEN
4036: fnd_message.set_name('ONT','OE_CANT_UPDATE_SHIPMENT_NO');
4037: OE_MSG_PUB.Add;
4038: l_return_status:=FND_API.G_RET_STS_ERROR;
4039: END IF;
4040:
4041: IF p_line_rec.subinventory is not null THEN
4047: IF p_line_rec.ship_from_org_id is null THEN
4048: l_return_status := FND_API.G_RET_STS_ERROR;
4049: fnd_message.set_name('ONT', 'OE_ATTRIBUTE_REQUIRED');
4050: fnd_message.set_token('ATTRIBUTE',OE_Order_UTIL.Get_Attribute_Name('SHIP_FROM_ORG_ID'));
4051: OE_MSG_PUB.Add;
4052: ELSE
4053: -- validate the subinv is allowed (expense/asset)
4054: -- because defaulting can be defaulting an expense sub
4055: -- and the INV profile is set to No.
4099: EXCEPTION
4100: WHEN OTHERS THEN
4101: l_return_status := FND_API.G_RET_STS_ERROR;
4102: fnd_message.set_name('ONT', 'OE_SUBINV_INVALID');
4103: oe_msg_pub.add;
4104: END;
4105: ELSE -- not a restricted subinv case
4106: BEGIN
4107: select 'Y'
4135: EXCEPTION
4136: WHEN OTHERS THEN
4137: l_return_status := FND_API.G_RET_STS_ERROR;
4138: fnd_message.set_name('ONT', 'OE_SUBINV_NON_ASSET');
4139: oe_msg_pub.add;
4140: END;
4141: END IF; -- restrict subinv or not
4142: END IF;
4143: ELSE -- external
4142: END IF;
4143: ELSE -- external
4144: l_return_status := FND_API.G_RET_STS_ERROR;
4145: fnd_message.set_name('ONT', 'OE_SUBINV_EXTERNAL');
4146: OE_MSG_PUB.Add;
4147: END IF;
4148: END IF;
4149:
4150: -- end subinventory
4211: AND revision= p_line_rec.item_revision;
4212: EXCEPTION
4213: WHEN NO_DATA_FOUND THEN
4214: fnd_message.set_name('ONT','ONT_REV_WH_NOT_EXIST');
4215: OE_MSG_PUB.Add;
4216: l_return_status := FND_API.G_RET_STS_ERROR;
4217: END;
4218: IF p_line_rec.reference_line_id is NOT NULL AND
4219: p_line_rec.reference_line_id <> FND_API.G_MISS_NUM
4245: IF l_notnull_revision_flag = 'Y' AND
4246: l_tot_transaction_quantity = 0
4247: THEN
4248: fnd_message.set_name('ONT','ONT_ITEM_REV_MISMATCH');
4249: OE_MSG_PUB.Add;
4250: END IF;
4251:
4252: IF l_tot_transaction_quantity > 0
4253: THEN
4277: IF (l_tot_transaction_quantity - NVL(l_quantity_entered,0))
4278: < p_line_rec.ordered_quantity
4279: THEN
4280: fnd_message.set_name('ONT','ONT_RMA_EXCEED_SHIP_QTY');
4281: OE_MSG_PUB.Add;
4282: l_return_status := FND_API.G_RET_STS_ERROR;
4283: END IF;
4284: END IF; -- IF l_tot_transaction_quantity > 0
4285: END IF; -- IF p_line_rec.reference_line_id is NOT NULL
4313: END IF;
4314: l_return_status := FND_API.G_RET_STS_ERROR;
4315: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
4316: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Ordered_Quantity2');
4317: OE_MSG_PUB.Add;
4318:
4319: ELSIF (p_line_rec.ordered_quantity2 <> FND_API.G_MISS_NUM OR
4320: p_line_rec.ordered_quantity2 IS NOT NULL) AND
4321: (p_old_line_rec.ordered_quantity = FND_API.G_MISS_NUM OR
4323:
4324: l_return_status := FND_API.G_RET_STS_ERROR;
4325: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
4326: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Ordered_Quantity');
4327: OE_MSG_PUB.Add;
4328: END IF;
4329: -- END IF; INVCONV
4330:
4331: /* If qty1/qty2 both populated, check tolerances
4383: END IF;
4384:
4385: l_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST, -- INVCONV
4386: p_encoded => 'F');
4387: oe_msg_pub.add_text(p_message_text => l_msg_data);
4388: IF l_debug_level > 0 THEN
4389: oe_debug_pub.add(l_msg_data,1);
4390: END IF;
4391: RAISE fnd_api.g_exc_error;
4422:
4423: IF ( l_delta_qty1 > 0 AND l_delta_qty2 <= 0) OR (l_delta_qty2 > 0 AND l_delta_qty1 <= 0) THEN
4424: l_return_status := FND_API.G_RET_STS_ERROR;
4425: FND_MESSAGE.set_name('GMI', 'GMI_SHIPPING_SPLIT_DEV_ERR'); -- INVCONV change this message to INV
4426: OE_MSG_PUB.Add;
4427: END IF;
4428:
4429: IF (l_delta_qty1 > 0) AND (l_delta_qty2 > 0) THEN
4430:
4446: END IF;
4447:
4448: l_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST, -- INVCONV
4449: p_encoded => 'F');
4450: oe_msg_pub.add_text(p_message_text => l_msg_data);
4451: IF l_debug_level > 0 THEN
4452: oe_debug_pub.add(l_msg_data,1);
4453: END IF;
4454: l_return_status := FND_API.G_RET_STS_ERROR;
4525: END;
4526:
4527: IF l_valid_line_number = 'N' THEN
4528: FND_MESSAGE.SET_NAME('ONT','OE_LINE_NUMBER_EXISTS');
4529: OE_MSG_PUB.ADD;
4530: /* x_return_status := FND_API.G_RET_STS_ERROR; This line replaced with next for 2068070 */
4531: l_return_status := FND_API.G_RET_STS_ERROR;
4532: END IF;
4533:
4870: -- error out for this item.
4871:
4872: IF p_line_rec.item_type_code <> OE_GLOBALS.G_ITEM_CONFIG THEN
4873: FND_MESSAGE.SET_NAME('ONT','OE_SCH_INVALID_CHANGE');
4874: OE_MSG_PUB.Add;
4875: l_return_status := FND_API.G_RET_STS_ERROR;
4876: END IF;
4877:
4878: END IF;
4907: AND p_line_rec.ship_from_org_id IS NULL) THEN
4908:
4909: l_return_status := FND_API.G_RET_STS_ERROR;
4910: FND_MESSAGE.SET_NAME('ONT', 'OE_SHIP_FROM_REQD');
4911: OE_MSG_PUB.add;
4912: ELSIF (p_line_rec.task_id IS NOT NULL AND
4913: p_line_rec.project_id IS NULL) THEN
4914:
4915: l_return_status := FND_API.G_RET_STS_ERROR;
4913: p_line_rec.project_id IS NULL) THEN
4914:
4915: l_return_status := FND_API.G_RET_STS_ERROR;
4916: FND_MESSAGE.SET_NAME('ONT', 'OE_VAL_PROJECT_REQD');
4917: OE_MSG_PUB.add;
4918: END IF;
4919:
4920: -- Added Code for Enhanced Project Validation and Controls.
4921:
4950: OE_DEBUG_PUB.Add('Validate Proj References Result:'||
4951: result,1);
4952: END IF;
4953: IF result <> PJM_PROJECT.G_VALIDATE_SUCCESS THEN
4954: OE_MSG_PUB.Transfer_Msg_Stack;
4955: l_msg_count:=OE_MSG_PUB.COUNT_MSG;
4956: FOR I in 1..l_msg_count loop
4957: l_msg_data := OE_MSG_PUB.Get(I,'F');
4958: IF l_debug_level > 0 then
4951: result,1);
4952: END IF;
4953: IF result <> PJM_PROJECT.G_VALIDATE_SUCCESS THEN
4954: OE_MSG_PUB.Transfer_Msg_Stack;
4955: l_msg_count:=OE_MSG_PUB.COUNT_MSG;
4956: FOR I in 1..l_msg_count loop
4957: l_msg_data := OE_MSG_PUB.Get(I,'F');
4958: IF l_debug_level > 0 then
4959: OE_DEBUG_PUB.add(l_msg_data,1);
4953: IF result <> PJM_PROJECT.G_VALIDATE_SUCCESS THEN
4954: OE_MSG_PUB.Transfer_Msg_Stack;
4955: l_msg_count:=OE_MSG_PUB.COUNT_MSG;
4956: FOR I in 1..l_msg_count loop
4957: l_msg_data := OE_MSG_PUB.Get(I,'F');
4958: IF l_debug_level > 0 then
4959: OE_DEBUG_PUB.add(l_msg_data,1);
4960: END IF;
4961: END LOOP;
4989: p_line_rec.ship_from_org_id) IS NULL THEN
4990:
4991: l_return_status := FND_API.G_RET_STS_ERROR;
4992: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_SHIP_FROM_PROJ');
4993: OE_MSG_PUB.add;
4994: END IF;
4995:
4996: END IF;
4997:
4999: AND p_line_rec.project_id IS NULL) THEN
5000:
5001: l_return_status := FND_API.G_RET_STS_ERROR;
5002: FND_MESSAGE.SET_NAME('ONT', 'OE_VAL_PROJECT_REQD');
5003: OE_MSG_PUB.add;
5004:
5005: ELSIF (p_line_rec.task_id is NOT NULL
5006: AND p_line_rec.project_id IS NOT NULL) THEN
5007:
5009: p_line_rec.project_id,
5010: p_line_rec.task_id) THEN
5011:
5012: l_return_status := FND_API.G_RET_STS_ERROR;
5013: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'TASK_ID');
5014: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
5015: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
5016: OE_Order_Util.Get_Attribute_Name('task_id'));
5017: OE_MSG_PUB.Add;
5013: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'TASK_ID');
5014: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
5015: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
5016: OE_Order_Util.Get_Attribute_Name('task_id'));
5017: OE_MSG_PUB.Add;
5018: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
5019:
5020: END IF;
5021:
5014: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
5015: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
5016: OE_Order_Util.Get_Attribute_Name('task_id'));
5017: OE_MSG_PUB.Add;
5018: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
5019:
5020: END IF;
5021:
5022: ELSIF (p_line_rec.task_id is NULL
5027: p_line_rec.ship_from_org_id) THEN
5028:
5029: l_return_status := FND_API.G_RET_STS_ERROR;
5030: FND_MESSAGE.SET_NAME('ONT', 'OE_VAL_TASK_REQD');
5031: OE_MSG_PUB.ADD;
5032:
5033: END IF;
5034:
5035: END IF;
5048: THEN
5049:
5050: l_return_status := FND_API.G_RET_STS_ERROR;
5051: fnd_message.set_name('ONT', 'OE_UEFF_NUMBER_REQD');
5052: OE_MSG_PUB.add;
5053: END IF;
5054:
5055: END IF;
5056: END IF; -- Added for bug 6243026
5065: THEN
5066:
5067: l_return_status := FND_API.G_RET_STS_ERROR;
5068: fnd_message.set_name('ONT', 'OE_PJM_NOT_INSTALLED');
5069: OE_MSG_PUB.add;
5070:
5071: END IF;
5072:
5073:
5089: IF (NOT OE_GLOBALS.EQUAL(p_line_rec.project_id,
5090: p_old_line_rec.project_id)) THEN
5091: l_return_status := FND_API.G_RET_STS_ERROR;
5092: FND_MESSAGE.SET_NAME('ONT', 'OE_VAL_PROJ_UPD');
5093: OE_MSG_PUB.add;
5094: ELSIF (NOT OE_GLOBALS.EQUAL(p_line_rec.task_id,
5095: p_old_line_rec.task_id)) THEN
5096: l_return_status := FND_API.G_RET_STS_ERROR;
5097: FND_MESSAGE.SET_NAME('ONT', 'OE_VAL_TASK_UPD');
5094: ELSIF (NOT OE_GLOBALS.EQUAL(p_line_rec.task_id,
5095: p_old_line_rec.task_id)) THEN
5096: l_return_status := FND_API.G_RET_STS_ERROR;
5097: FND_MESSAGE.SET_NAME('ONT', 'OE_VAL_TASK_UPD');
5098: OE_MSG_PUB.add;
5099: END IF;
5100:
5101: END IF;
5102:
5130: )
5131: THEN
5132: l_return_status := FND_API.G_RET_STS_ERROR;
5133: fnd_message.set_name('ONT', 'OE_ITEM_VALIDATION_FAILED');
5134: OE_MSG_PUB.add;
5135: END IF;
5136:
5137: END IF;
5138: IF l_debug_level > 0 then
5150: l_return_status := FND_API.G_RET_STS_ERROR;
5151: fnd_message.set_name('ONT', 'OE_ITORD_VALIDATION_FAILED');
5152: fnd_message.set_token('ITEM',OE_ITORD_UTIL.get_item_name(p_line_rec.inventory_item_id));
5153: fnd_message.set_token('CATEGORY',OE_ITORD_UTIL.get_item_category_name(p_line_rec.inventory_item_id));
5154: OE_MSG_PUB.add;
5155: END IF;
5156: END IF;
5157:
5158: IF l_debug_level > 0 then
5173: )
5174: THEN
5175: l_return_status := FND_API.G_RET_STS_ERROR;
5176: fnd_message.set_name('ONT', 'OE_RETURN_ITEM_MISMATCH_REJECT');
5177: OE_MSG_PUB.add;
5178: END IF;
5179: END IF;
5180: IF l_debug_level > 0 then
5181: oe_debug_pub.add('13 '||l_return_status, 1);
5192: )
5193: THEN
5194: l_return_status := FND_API.G_RET_STS_ERROR;
5195: fnd_message.set_name('ONT', 'OE_UNFULFILLED_LINE_REJECT');
5196: OE_MSG_PUB.add;
5197: END IF;
5198:
5199: END IF;
5200: IF l_debug_level > 0 then
5275: NVL(p_line_rec.ordered_quantity,1) <> 1)
5276: THEN
5277: l_return_status := FND_API.G_RET_STS_ERROR;
5278: fnd_message.set_name('ONT','OE_SERIAL_REFERENCED_RMA');
5279: OE_MSG_PUB.Add;
5280: END IF;
5281:
5282: IF l_debug_level > 0 then
5283: oe_debug_pub.add('14_3 '||l_return_status, 1);
5308: l_return_status := FND_API.G_RET_STS_ERROR;
5309: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
5310: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
5311: OE_Order_Util.Get_Attribute_Name('ship_to_org_id'));
5312: OE_MSG_PUB.Add;
5313: END IF;
5314: END IF;
5315:
5316: END IF;
5360: l_return_status := FND_API.G_RET_STS_ERROR;
5361: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
5362: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
5363: OE_Order_Util.Get_Attribute_Name('ship_to_contact_id'));
5364: OE_MSG_PUB.Add;
5365: END IF;
5366: WHEN OTHERS THEN
5367: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5368: OE_MSG_PUB.Add_Exc_Msg
5363: OE_Order_Util.Get_Attribute_Name('ship_to_contact_id'));
5364: OE_MSG_PUB.Add;
5365: END IF;
5366: WHEN OTHERS THEN
5367: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5368: OE_MSG_PUB.Add_Exc_Msg
5369: ( G_PKG_NAME ,
5370: 'Record - Ship To Contact validation '
5371: );
5364: OE_MSG_PUB.Add;
5365: END IF;
5366: WHEN OTHERS THEN
5367: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5368: OE_MSG_PUB.Add_Exc_Msg
5369: ( G_PKG_NAME ,
5370: 'Record - Ship To Contact validation '
5371: );
5372: END IF;
5400: l_return_status := FND_API.G_RET_STS_ERROR;
5401: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
5402: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
5403: OE_Order_Util.Get_Attribute_Name('deliver_to_org_id'));
5404: OE_MSG_PUB.Add;
5405: END IF;
5406: END IF;
5407:
5408: END IF;
5454: l_return_status := FND_API.G_RET_STS_ERROR;
5455: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
5456: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
5457: OE_Order_Util.Get_Attribute_Name('deliver_to_contact_id'));
5458: OE_MSG_PUB.Add;
5459: END IF;
5460: WHEN OTHERS THEN
5461: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5462: OE_MSG_PUB.Add_Exc_Msg
5457: OE_Order_Util.Get_Attribute_Name('deliver_to_contact_id'));
5458: OE_MSG_PUB.Add;
5459: END IF;
5460: WHEN OTHERS THEN
5461: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5462: OE_MSG_PUB.Add_Exc_Msg
5463: ( G_PKG_NAME ,
5464: 'Record - Deliver To Contact validation '
5465: );
5458: OE_MSG_PUB.Add;
5459: END IF;
5460: WHEN OTHERS THEN
5461: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5462: OE_MSG_PUB.Add_Exc_Msg
5463: ( G_PKG_NAME ,
5464: 'Record - Deliver To Contact validation '
5465: );
5466: END IF;
5546: l_return_status := FND_API.G_RET_STS_ERROR;
5547: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
5548: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
5549: OE_Order_Util.Get_Attribute_Name('invoice_to_org_id'));
5550: OE_MSG_PUB.Add;
5551: END IF;
5552: WHEN OTHERS THEN
5553: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5554: OE_MSG_PUB.Add_Exc_Msg
5549: OE_Order_Util.Get_Attribute_Name('invoice_to_org_id'));
5550: OE_MSG_PUB.Add;
5551: END IF;
5552: WHEN OTHERS THEN
5553: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5554: OE_MSG_PUB.Add_Exc_Msg
5555: ( G_PKG_NAME ,
5556: 'Record - Invoice To Org validation '
5557: );
5550: OE_MSG_PUB.Add;
5551: END IF;
5552: WHEN OTHERS THEN
5553: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5554: OE_MSG_PUB.Add_Exc_Msg
5555: ( G_PKG_NAME ,
5556: 'Record - Invoice To Org validation '
5557: );
5558: END IF;
5607: l_return_status := FND_API.G_RET_STS_ERROR;
5608: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
5609: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
5610: OE_Order_Util.Get_Attribute_Name('invoice_to_contact_id'));
5611: OE_MSG_PUB.Add;
5612: END IF;
5613: WHEN OTHERS THEN
5614: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5615: OE_MSG_PUB.Add_Exc_Msg
5610: OE_Order_Util.Get_Attribute_Name('invoice_to_contact_id'));
5611: OE_MSG_PUB.Add;
5612: END IF;
5613: WHEN OTHERS THEN
5614: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5615: OE_MSG_PUB.Add_Exc_Msg
5616: ( G_PKG_NAME ,
5617: 'Record - Invoice To Contact validation '
5618: );
5611: OE_MSG_PUB.Add;
5612: END IF;
5613: WHEN OTHERS THEN
5614: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5615: OE_MSG_PUB.Add_Exc_Msg
5616: ( G_PKG_NAME ,
5617: 'Record - Invoice To Contact validation '
5618: );
5619: END IF;
5683: l_return_status := FND_API.G_RET_STS_ERROR;
5684: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
5685: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
5686: OE_Order_Util.Get_Attribute_Name('TAX_CODE'));
5687: OE_MSG_PUB.Add;
5688:
5689: WHEN OTHERS THEN
5690: IF OE_MSG_PUB.Check_Msg_Level (
5691: OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5686: OE_Order_Util.Get_Attribute_Name('TAX_CODE'));
5687: OE_MSG_PUB.Add;
5688:
5689: WHEN OTHERS THEN
5690: IF OE_MSG_PUB.Check_Msg_Level (
5691: OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5692: THEN
5693: OE_MSG_PUB.Add_Exc_Msg
5694: ( G_PKG_NAME ,
5687: OE_MSG_PUB.Add;
5688:
5689: WHEN OTHERS THEN
5690: IF OE_MSG_PUB.Check_Msg_Level (
5691: OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5692: THEN
5693: OE_MSG_PUB.Add_Exc_Msg
5694: ( G_PKG_NAME ,
5695: 'Record - Tax Code validation '
5689: WHEN OTHERS THEN
5690: IF OE_MSG_PUB.Check_Msg_Level (
5691: OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5692: THEN
5693: OE_MSG_PUB.Add_Exc_Msg
5694: ( G_PKG_NAME ,
5695: 'Record - Tax Code validation '
5696: );
5697: END IF;
5707: (p_line_rec.tax_exempt_number IS NOT NULL OR
5708: p_line_rec.tax_exempt_reason_code IS NOT NULL)
5709: THEN
5710: l_return_status := FND_API.G_RET_STS_ERROR;
5711: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_ERROR)
5712: THEN
5713: fnd_message.set_name('ONT','OE_NO_TAX_EXEMPTION');
5714: OE_MSG_PUB.Add;
5715: END IF;
5710: l_return_status := FND_API.G_RET_STS_ERROR;
5711: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_ERROR)
5712: THEN
5713: fnd_message.set_name('ONT','OE_NO_TAX_EXEMPTION');
5714: OE_MSG_PUB.Add;
5715: END IF;
5716:
5717: END IF; -- If Tax handling is Standard
5718:
5725: --bug6732513
5726: /* IF p_line_rec.tax_exempt_number IS NULL
5727: THEN
5728: l_return_status := FND_API.G_RET_STS_ERROR;
5729: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_ERROR)
5730: THEN
5731: fnd_message.set_name('ONT','OE_TAX_EXEMPTION_REQUIRED');
5732: OE_MSG_PUB.Add;
5733: END IF;
5728: l_return_status := FND_API.G_RET_STS_ERROR;
5729: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_ERROR)
5730: THEN
5731: fnd_message.set_name('ONT','OE_TAX_EXEMPTION_REQUIRED');
5732: OE_MSG_PUB.Add;
5733: END IF;
5734: END IF;*/
5735:
5736:
5736:
5737: IF p_line_rec.tax_exempt_reason_code IS NULL
5738: THEN
5739: l_return_status := FND_API.G_RET_STS_ERROR;
5740: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_ERROR)
5741: THEN
5742: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
5743: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
5744: OE_Order_Util.Get_Attribute_Name('TAX_EXEMPT_REASON_CODE'));
5741: THEN
5742: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
5743: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
5744: OE_Order_Util.Get_Attribute_Name('TAX_EXEMPT_REASON_CODE'));
5745: OE_MSG_PUB.Add;
5746: END IF;
5747: END IF;
5748: END IF; -- If Tax handling is exempt
5749:
5753: (p_line_rec.tax_exempt_number IS NOT NULL OR
5754: p_line_rec.tax_exempt_reason_code IS NOT NULL)
5755: THEN
5756: l_return_status := FND_API.G_RET_STS_ERROR;
5757: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_ERROR)
5758: THEN
5759: fnd_message.set_name('ONT','OE_TAX_EXEMPTION_NOT_ALLOWED');
5760: OE_MSG_PUB.Add;
5761: END IF;
5756: l_return_status := FND_API.G_RET_STS_ERROR;
5757: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_ERROR)
5758: THEN
5759: fnd_message.set_name('ONT','OE_TAX_EXEMPTION_NOT_ALLOWED');
5760: OE_MSG_PUB.Add;
5761: END IF;
5762:
5763: END IF; -- If Tax handling is Required
5764:
5884: ELSE
5885:
5886: l_return_status := FND_API.G_RET_STS_ERROR;
5887:
5888: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
5889: THEN
5890: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
5891: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
5892: OE_Order_Util.Get_Attribute_Name('TAX_EXEMPT_NUMBER'));
5889: THEN
5890: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
5891: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
5892: OE_Order_Util.Get_Attribute_Name('TAX_EXEMPT_NUMBER'));
5893: OE_MSG_PUB.Add;
5894: END IF;
5895: END IF;
5896:
5897: WHEN OTHERS THEN
5894: END IF;
5895: END IF;
5896:
5897: WHEN OTHERS THEN
5898: IF OE_MSG_PUB.Check_Msg_Level (
5899: OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5900: THEN
5901: OE_MSG_PUB.Add_Exc_Msg
5902: ( G_PKG_NAME ,
5895: END IF;
5896:
5897: WHEN OTHERS THEN
5898: IF OE_MSG_PUB.Check_Msg_Level (
5899: OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5900: THEN
5901: OE_MSG_PUB.Add_Exc_Msg
5902: ( G_PKG_NAME ,
5903: 'Record - Tax Exemptions '
5897: WHEN OTHERS THEN
5898: IF OE_MSG_PUB.Check_Msg_Level (
5899: OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5900: THEN
5901: OE_MSG_PUB.Add_Exc_Msg
5902: ( G_PKG_NAME ,
5903: 'Record - Tax Exemptions '
5904: );
5905: END IF;
5960:
5961: fnd_message.set_name('ONT','OE_INVALID_ORDER_QUANTITY_UOM');
5962: fnd_message.set_token('ITEM',nvl(p_line_rec.ordered_item,p_line_rec.inventory_item_id));
5963: fnd_message.set_token('UOM', l_uom);
5964: OE_MSG_PUB.Add;
5965: RAISE FND_API.G_EXC_ERROR;
5966: END IF;
5967: EXCEPTION
5968: when no_data_found then
5987: IF l_debug_level > 0 then
5988: oe_debug_pub.add('uom/item combination invalid',2);
5989: END IF;
5990: fnd_message.set_name('ONT', 'OE_INVALID_ITEM_UOM');
5991: OE_MSG_PUB.Add;
5992: RAISE FND_API.G_EXC_ERROR;
5993: END IF;
5994:
5995: */
5998: IF l_debug_level > 0 then
5999: oe_debug_pub.add('uom/item combination invalid',2);
6000: END IF;
6001: fnd_message.set_name('ONT', 'OE_INVALID_ITEM_UOM');
6002: OE_MSG_PUB.Add;
6003: RAISE FND_API.G_EXC_ERROR;
6004: END IF;
6005: /*1544265*/
6006: END IF;
6073: WHEN NO_DATA_FOUND THEN
6074: l_price_list_name := l_price_list_id;
6075: END;
6076: fnd_message.set_Token('PRICE_LIST2', l_price_list_name);
6077: OE_MSG_PUB.Add;
6078: IF l_debug_level > 0 then
6079: oe_debug_pub.add('Invalid Agreement +price_list_id combination',2);
6080: END IF;
6081: raise FND_API.G_EXC_ERROR;
6090: fnd_message.set_name('ONT', 'OE_INVALID_AGREEMENT');
6091: fnd_message.set_Token('AGREEMENT_ID', p_line_rec.agreement_id);
6092: fnd_message.set_Token('AGREEMENT_NAME', l_agreement_name);
6093: fnd_message.set_Token('CUSTOMER_ID', p_line_rec.sold_to_org_id);
6094: OE_MSG_PUB.Add;
6095: IF l_debug_level > 0 then
6096: oe_debug_pub.add('Invalid Agreement +sold_org_id combination',2);
6097: END IF;
6098: RAISE FND_API.G_EXC_ERROR;
6115: fnd_message.set_name('ONT', 'OE_INVALID_AGREEMENT');
6116: fnd_message.set_Token('AGREEMENT_ID', p_line_rec.agreement_id);
6117: fnd_message.set_Token('AGREEMENT_NAME', l_agreement_name);
6118: fnd_message.set_Token('CUSTOMER_ID', p_line_rec.sold_to_org_id);
6119: OE_MSG_PUB.Add;
6120: IF l_debug_level > 0 then
6121: oe_debug_pub.add('Invalid Agreement +sold_org_id combination',2);
6122: END IF;
6123: RAISE FND_API.G_EXC_ERROR;
6131: fnd_message.set_name('ONT', 'OE_INVALID_AGREEMENT');
6132: fnd_message.set_Token('AGREEMENT_ID', p_line_rec.agreement_id);
6133: fnd_message.set_Token('AGREEMENT_NAME', l_agreement_name);
6134: fnd_message.set_Token('CUSTOMER_ID', l_sold_to_org);
6135: OE_MSG_PUB.Add;
6136: IF l_debug_level > 0 then
6137: oe_debug_pub.add('Invalid Agreement +sold_org_id combination',2);
6138: END IF;
6139: RAISE FND_API.G_EXC_ERROR;
6168: EXCEPTION
6169: --
6170: WHEN NO_DATA_FOUND THEN
6171: --
6172: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN
6173: --
6174: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'PRICE_LIST_ID');
6175:
6176: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
6170: WHEN NO_DATA_FOUND THEN
6171: --
6172: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN
6173: --
6174: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'PRICE_LIST_ID');
6175:
6176: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
6177: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
6178: OE_Order_Util.Get_Attribute_Name('price_list_id'));
6175:
6176: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
6177: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
6178: OE_Order_Util.Get_Attribute_Name('price_list_id'));
6179: OE_MSG_PUB.Add;
6180: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
6181: --
6182: END IF;
6183: --
6176: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
6177: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
6178: OE_Order_Util.Get_Attribute_Name('price_list_id'));
6179: OE_MSG_PUB.Add;
6180: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
6181: --
6182: END IF;
6183: --
6184: RAISE FND_API.G_EXC_ERROR;
6209: FND_MESSAGE.SET_NAME('ONT','OE_CURRENCY_MISMATCH');
6210: FND_MESSAGE.SET_TOKEN('LINE_CURR_CODE', l_currency_code);
6211: FND_MESSAGE.SET_TOKEN('PRICE_LIST_NAME', l_price_list_name);
6212: FND_MESSAGE.SET_TOKEN('HEADER_CURR_CODE', l_hdr_currency_code);
6213: OE_MSG_PUB.ADD;
6214: --
6215: RAISE FND_API.G_EXC_ERROR;
6216: --
6217: END IF;
6314: WHEN NO_DATA_FOUND THEN
6315: fnd_message.set_name('ONT', 'OE_INVALID_NONAGR_PLIST');
6316: fnd_message.set_Token('PRICE_LIST1', p_line_rec.price_list_id);
6317: fnd_message.set_Token('PRICING_DATE', p_line_rec.pricing_date);
6318: OE_MSG_PUB.Add;
6319: IF l_debug_level > 0 then
6320: oe_debug_pub.add('Invalid non agreement price list ',2);
6321: END IF;
6322: RAISE FND_API.G_EXC_ERROR;
6352: p_old_line_rec.line_number)) THEN
6353:
6354: l_return_status := FND_API.G_RET_STS_ERROR;
6355: fnd_message.set_name('ONT', 'OE_LINE_NUMBER_UPD');
6356: OE_MSG_PUB.add;
6357:
6358: END IF;
6359: END IF;
6360:
6395: oe_debug_pub.add('class/option qty changed to 0', 1);
6396: END IF;
6397: l_return_status := FND_API.G_RET_STS_ERROR;
6398: FND_MESSAGE.SET_NAME('ONT', 'OE_CONFIG_NO_ZERO_QTY');
6399: oe_msg_pub.add;
6400: END IF;
6401:
6402: l_option_count := 0;
6403:
6420: oe_debug_pub.add('models qty changed to 0, no cancellation', 1);
6421: END IF;
6422: l_return_status := FND_API.G_RET_STS_ERROR;
6423: FND_Message.Set_Name('ONT', 'OE_CONFIG_NO_ZERO_QTY');
6424: oe_msg_pub.add;
6425: END IF;
6426: END IF;
6427: */
6428: IF l_debug_level > 0 then
6443: oe_debug_pub.add('Ordered Qty cannot be greater than 1 for OTA lines', 1);
6444: END IF;
6445: l_return_status := FND_API.G_RET_STS_ERROR;
6446: FND_Message.Set_Name('ONT', 'OE_OTA_INVALID_QTY');
6447: oe_msg_pub.add;
6448: END IF;
6449:
6450: /* End of validation for OTA */
6451:
6471: ,p_line_rec.sold_to_org_id
6472: ,p_line_rec.header_id )
6473: THEN
6474: FND_MESSAGE.SET_NAME('ONT','OE_VAL_DUP_PO_NUMBER');
6475: OE_MSG_PUB.ADD;
6476: END IF;
6477:
6478: END IF;
6479: -- End of check for duplicate PO number
6506: EXCEPTION
6507: WHEN NO_DATA_FOUND THEN
6508: fnd_message.set_name('ONT', 'ONT_INVALID_AGR');
6509: fnd_message.set_Token('PRICING_DATE', p_line_rec.pricing_date);
6510: OE_MSG_PUB.Add;
6511: IF l_debug_level > 0 then
6512: oe_debug_pub.add('Invalid Agreement',2);
6513: END IF;
6514: RAISE FND_API.G_EXC_ERROR;
6528: IF (p_line_rec.service_end_date < p_line_rec.service_start_date) -- 2992944
6529: THEN
6530: l_return_status := FND_API.G_RET_STS_ERROR;
6531: fnd_message.set_name('ONT','OE_SERV_END_DATE');
6532: OE_MSG_PUB.Add;
6533: END IF;
6534:
6535: END IF;
6536:
6579: oe_debug_pub.add('Ship tolerances can not be specified on PTOs',3);
6580: END IF;
6581: l_return_status := FND_API.G_RET_STS_ERROR;
6582: fnd_message.set_name('ONT','OE_NO_TOL_FOR_PTO');
6583: OE_MSG_PUB.Add;
6584:
6585: END IF;
6586: IF l_debug_level > 0 then
6587: oe_debug_pub.add('19 '||l_return_status ,1);
6598: END IF;
6599: l_return_status := FND_API.G_RET_STS_ERROR;
6600: fnd_message.set_name('ONT','OE_CONFIG_NULL_QUANTITY');
6601: fnd_message.set_Token('ITEM', nvl(p_line_rec.ordered_item,p_line_rec.inventory_item_id));
6602: OE_MSG_PUB.Add;
6603:
6604: END IF;
6605:
6606: IF l_debug_level > 0 then
6629:
6630: -- Must have some scheduling action when you set the Override
6631: -- ATP Flag
6632: FND_MESSAGE.SET_NAME('ONT','OE_SCH_OVER_ATP_NO_SCH_ACT');
6633: OE_MSG_PUB.Add;
6634: IF l_debug_level > 0 then
6635: Oe_debug_pub.add('Missing Schedule Action',1);
6636: END IF;
6637: l_return_status := FND_API.G_RET_STS_ERROR;
6643:
6644: -- Override ATP flag cannot be set for Service, Return,
6645: -- and Drop Ship Lines.
6646: FND_MESSAGE.SET_NAME('ONT', 'OE_SCH_OVER_ATP_INVLD_LINE');
6647: OE_MSG_PUB.Add;
6648: IF l_debug_level > 0 then
6649: Oe_debug_pub.add('Override ATP cannot be set for Service, Return and
6650: Drop Ship lines',1);
6651: END IF;
6659: IF p_line_rec.override_atp_date_code IS NOT NULL THEN
6660:
6661: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
6662: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Override Atp');
6663: OE_MSG_PUB.Add;
6664: l_return_status := FND_API.G_RET_STS_ERROR;
6665: IF l_debug_level > 0 then
6666: Oe_debug_pub.add('Override ATP cannot be set prior to pack-I' ||
6667: p_line_rec.override_atp_date_code,2);
6686: OR p_line_rec.line_category_code = 'RETURN'
6687: OR p_line_rec.open_flag = 'N' THEN
6688:
6689: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_FIRM_OPR');
6690: OE_MSG_PUB.Add;
6691: l_return_status := FND_API.G_RET_STS_ERROR;
6692:
6693: END IF;
6694:
6726: OE_DEBUG_PUB.Add('Blankets are only available in Pack I or greater',1);
6727: end if;
6728: l_return_status := FND_API.G_RET_STS_ERROR;
6729: FND_MESSAGE.Set_Name('ONT','OE_BLANKET_INVALID_VERSION');
6730: OE_MSG_PUB.Add;
6731: END IF;
6732:
6733: ELSE
6734:
6896: oe_debug_pub.add('no po', 4);
6897: END IF;
6898: END IF;
6899:
6900: OE_MSG_PUB.Add;
6901: END IF;
6902:
6903: EXCEPTION
6904: WHEN NO_DATA_FOUND THEN
6959: END IF;
6960: l_return_status := FND_API.G_RET_STS_ERROR;
6961: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
6962: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_OWNER'));
6963: OE_MSG_PUB.Add;
6964: END IF;
6965:
6966:
6967: IF p_old_line_rec.ib_installed_at_location='INSTALL_BASE' AND
6973: END IF;
6974: l_return_status := FND_API.G_RET_STS_ERROR;
6975: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
6976: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_INSTALLED_AT_LOCATION'));
6977: OE_MSG_PUB.Add;
6978: END IF;
6979:
6980:
6981: IF p_old_line_rec.ib_current_location='INSTALL_BASE' AND
6987: END IF;
6988: l_return_status := FND_API.G_RET_STS_ERROR;
6989: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
6990: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_CURRENT_LOCATION'));
6991: OE_MSG_PUB.Add;
6992: END IF;
6993:
6994: -- END OF check.
6995:
7006: END IF;
7007: l_return_status := FND_API.G_RET_STS_ERROR;
7008: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7009: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_OWNER'));
7010: OE_MSG_PUB.Add;
7011: END IF;
7012:
7013: IF p_line_rec.ib_installed_at_location='INSTALL_BASE' and p_old_line_rec.ib_installed_at_location in ('BILL_TO','DELIVER_TO','END_CUSTOMER','SHIP_TO','SOLD_TO') THEN
7014: IF l_debug_level > 0 THEN
7017: END IF;
7018: l_return_status := FND_API.G_RET_STS_ERROR;
7019: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7020: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_INSTALLED_AT_LOCATION'));
7021: OE_MSG_PUB.Add;
7022: END IF;
7023:
7024: IF p_line_rec.ib_current_location='INSTALL_BASE' and p_old_line_rec.ib_current_location in ('BILL_TO','DELIVER_TO','END_CUSTOMER','SHIP_TO','SOLD_TO') THEN
7025: IF l_debug_level > 0 THEN
7028: END IF;
7029: l_return_status := FND_API.G_RET_STS_ERROR;
7030: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7031: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_CURRENT_LOCATION'));
7032: OE_MSG_PUB.Add;
7033: END IF;
7034:
7035: IF OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL >= '110510' THEN
7036:
7044: END IF;
7045: l_return_status := FND_API.G_RET_STS_ERROR;
7046: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7047: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_OWNER'));
7048: OE_MSG_PUB.Add;
7049:
7050: END IF;
7051:
7052: END IF;
7061: END IF;
7062: l_return_status := FND_API.G_RET_STS_ERROR;
7063: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7064: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_INSTALLED_AT_LOCATION'));
7065: OE_MSG_PUB.Add;
7066:
7067: END IF;
7068:
7069: END IF;
7079: END IF;
7080: l_return_status := FND_API.G_RET_STS_ERROR;
7081: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7082: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_CURRENT_LOCATION'));
7083: OE_MSG_PUB.Add;
7084:
7085: END IF;
7086:
7087: END IF;
7107: END IF;
7108: l_return_status := FND_API.G_RET_STS_ERROR;
7109: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7110: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_OWNER'));
7111: OE_MSG_PUB.Add;
7112:
7113: ELSIF p_line_rec.ib_owner = 'SOLD_TO' AND
7114: p_line_rec.sold_to_org_id is null
7115: THEN
7118: END IF;
7119: l_return_status := FND_API.G_RET_STS_ERROR;
7120: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7121: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_OWNER'));
7122: OE_MSG_PUB.Add;
7123: END IF;
7124: END IF;
7125: IF l_debug_level > 0 then
7126: oe_debug_pub.ADD('ib_installed_at_location: '||p_line_rec.ib_installed_at_location);
7142: END IF;
7143: l_return_status := FND_API.G_RET_STS_ERROR;
7144: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7145: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_INSTALLED_AT_LOCATION'));
7146: OE_MSG_PUB.Add;
7147:
7148: ELSIF p_line_rec.ib_installed_at_location = 'SHIP_TO' AND
7149: p_line_rec.ship_to_org_id is null
7150: THEN
7153: END IF;
7154: l_return_status := FND_API.G_RET_STS_ERROR;
7155: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7156: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_INSTALLED_AT_LOCATION'));
7157: OE_MSG_PUB.Add;
7158:
7159: ELSIF p_line_rec.ib_installed_at_location = 'DELIVER_TO' AND
7160: p_line_rec.deliver_to_org_id is null
7161: THEN
7164: END IF;
7165: l_return_status := FND_API.G_RET_STS_ERROR;
7166: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7167: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_INSTALLED_AT_LOCATION'));
7168: OE_MSG_PUB.Add;
7169: ELSIF p_line_rec.ib_installed_at_location = 'END_CUSTOMER' AND
7170: p_line_rec.end_customer_site_use_id is null
7171: THEN
7172: IF l_debug_level >0 THEN
7174: END IF;
7175: l_return_status := FND_API.G_RET_STS_ERROR;
7176: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7177: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_INSTALLED_AT_LOCATION'));
7178: OE_MSG_PUB.Add;
7179:
7180: -- no validation for SOLD_TO
7181: -- since no line level sold_to_site_use_id
7182: -- REMOVE after LOV is fixed
7185: THEN
7186: l_return_status := FND_API.G_RET_STS_ERROR;
7187: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7188: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_INSTALLED_AT_LOCATION'));
7189: OE_MSG_PUB.Add;
7190:
7191: END IF;
7192: END IF;
7193: IF l_debug_level > 0 then
7210: END IF;
7211: l_return_status := FND_API.G_RET_STS_ERROR;
7212: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7213: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_CURRENT_LOCATION'));
7214: OE_MSG_PUB.Add;
7215:
7216: ELSIF p_line_rec.ib_current_location = 'SHIP_TO' AND
7217: p_line_rec.ship_to_org_id is null
7218: THEN
7221: END IF;
7222: l_return_status := FND_API.G_RET_STS_ERROR;
7223: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7224: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_CURRENT_LOCATION'));
7225: OE_MSG_PUB.Add;
7226:
7227: ELSIF p_line_rec.ib_current_location = 'DELIVER_TO' AND
7228: p_line_rec.deliver_to_org_id is null
7229: THEN
7229: THEN
7230: l_return_status := FND_API.G_RET_STS_ERROR;
7231: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7232: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_CURRENT_LOCATION'));
7233: OE_MSG_PUB.Add;
7234:
7235: ELSIF p_line_rec.ib_current_location = 'END_CUSTOMER' AND
7236: p_line_rec.end_customer_site_use_id is null
7237: THEN
7237: THEN
7238: l_return_status := FND_API.G_RET_STS_ERROR;
7239: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7240: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_CURRENT_LOCATION'));
7241: OE_MSG_PUB.Add;
7242:
7243: -- no validation for SOLD_TO
7244: -- since no line level sold_to_site_use_id
7245: -- REMOVE after LOV is fixed
7248: THEN
7249: l_return_status := FND_API.G_RET_STS_ERROR;
7250: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7251: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_CURRENT_LOCATION'));
7252: OE_MSG_PUB.Add;
7253:
7254:
7255: END IF;
7256: END IF;
7284: l_return_status := FND_API.G_RET_STS_ERROR;
7285: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7286: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
7287: OE_Order_Util.Get_Attribute_Name('END_CUSTOMER_CONTACT_ID'));
7288: OE_MSG_PUB.Add;
7289:
7290: WHEN OTHERS THEN
7291: IF OE_MSG_PUB.Check_Msg_Level
7292: ( OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7287: OE_Order_Util.Get_Attribute_Name('END_CUSTOMER_CONTACT_ID'));
7288: OE_MSG_PUB.Add;
7289:
7290: WHEN OTHERS THEN
7291: IF OE_MSG_PUB.Check_Msg_Level
7292: ( OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7293: THEN
7294: OE_MSG_PUB.Add_Exc_Msg
7295: ( G_PKG_NAME ,
7288: OE_MSG_PUB.Add;
7289:
7290: WHEN OTHERS THEN
7291: IF OE_MSG_PUB.Check_Msg_Level
7292: ( OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7293: THEN
7294: OE_MSG_PUB.Add_Exc_Msg
7295: ( G_PKG_NAME ,
7296: 'Record - End Customer Contact'
7290: WHEN OTHERS THEN
7291: IF OE_MSG_PUB.Check_Msg_Level
7292: ( OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7293: THEN
7294: OE_MSG_PUB.Add_Exc_Msg
7295: ( G_PKG_NAME ,
7296: 'Record - End Customer Contact'
7297: );
7298: END IF;
7331: l_return_status := FND_API.G_RET_STS_ERROR;
7332: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7333: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
7334: OE_Order_Util.Get_Attribute_Name('END_CUSTOMER_SITE_USE_ID'));
7335: OE_MSG_PUB.Add;
7336:
7337: WHEN OTHERS THEN
7338: IF OE_MSG_PUB.Check_Msg_Level
7339: ( OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7334: OE_Order_Util.Get_Attribute_Name('END_CUSTOMER_SITE_USE_ID'));
7335: OE_MSG_PUB.Add;
7336:
7337: WHEN OTHERS THEN
7338: IF OE_MSG_PUB.Check_Msg_Level
7339: ( OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7340: THEN
7341: OE_MSG_PUB.Add_Exc_Msg
7342: ( G_PKG_NAME ,
7335: OE_MSG_PUB.Add;
7336:
7337: WHEN OTHERS THEN
7338: IF OE_MSG_PUB.Check_Msg_Level
7339: ( OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7340: THEN
7341: OE_MSG_PUB.Add_Exc_Msg
7342: ( G_PKG_NAME ,
7343: 'Record - End Customer Site'
7337: WHEN OTHERS THEN
7338: IF OE_MSG_PUB.Check_Msg_Level
7339: ( OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7340: THEN
7341: OE_MSG_PUB.Add_Exc_Msg
7342: ( G_PKG_NAME ,
7343: 'Record - End Customer Site'
7344: );
7345: END IF;
7438: -- OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID');
7439:
7440: FND_MESSAGE.SET_NAME('ONT','ONT_NO_RC_ALLOWED');
7441: --FND_MESSAGE.SET_TOKEN('ITEM',l_item_description);
7442: OE_MSG_PUB.Add;
7443: RAISE FND_API.G_EXC_ERROR;
7444: END IF;
7445: END IF; --operation CREATE
7446:
7455: END IF;
7456:
7457: FND_MESSAGE.SET_NAME('ONT','ONT_NO_UPDATE_ON_PERIODICITY');
7458: FND_MESSAGE.SET_TOKEN('LINE_NUM',p_line_rec.line_number);
7459: OE_MSG_PUB.Add;
7460: RAISE FND_API.G_EXC_ERROR;
7461:
7462: END IF;
7463: ELSE --recurring charges system paramter is N
7464: IF l_debug_level > 0 THEN
7465: OE_DEBUG_PUB.Add('ERR: Recurring Charges SYS Param is disabled');
7466: END IF;
7467: FND_MESSAGE.SET_NAME('ONT','ONT_RECUR_CHARGES_NOT_ENABLED');
7468: OE_MSG_PUB.Add;
7469: RAISE FND_API.G_EXC_ERROR;
7470:
7471: END IF;
7472: ELSE -- Invalid charge_periodicity
7486: l_return_status := FND_API.G_RET_STS_ERROR;
7487: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7488: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
7489: OE_Order_UTIL.Get_Attribute_Name('SERVICE_DURATION'));
7490: OE_MSG_PUB.ADD;
7491: end if;
7492:
7493: if p_line_rec.service_period is not null and p_line_rec.service_period <>FND_API.G_MISS_CHAR then
7494: l_return_status := FND_API.G_RET_STS_ERROR;
7494: l_return_status := FND_API.G_RET_STS_ERROR;
7495: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7496: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
7497: OE_Order_UTIL.Get_Attribute_Name('SERVICE_PERIOD'));
7498: OE_MSG_PUB.ADD;
7499: end if;
7500:
7501: if p_line_rec.service_start_date is not null and p_line_rec.service_start_date <>FND_API.G_MISS_DATE then
7502: l_return_status := FND_API.G_RET_STS_ERROR;
7502: l_return_status := FND_API.G_RET_STS_ERROR;
7503: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7504: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
7505: OE_Order_UTIL.Get_Attribute_Name('SERVICE_START_DATE'));
7506: OE_MSG_PUB.ADD;
7507: end if;
7508:
7509: if p_line_rec.service_end_date is not null and p_line_rec.service_end_date <>FND_API.G_MISS_DATE then
7510: l_return_status := FND_API.G_RET_STS_ERROR;
7510: l_return_status := FND_API.G_RET_STS_ERROR;
7511: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7512: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
7513: OE_Order_UTIL.Get_Attribute_Name('SERVICE_END_DATE'));
7514: OE_MSG_PUB.ADD;
7515: end if;
7516:
7517: -- webroot bug 6826344 added start
7518: END IF;
7525: l_return_status := FND_API.G_RET_STS_ERROR;
7526: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7527: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
7528: OE_Order_UTIL.Get_Attribute_Name('SERVICE_TXN_COMMENTS'));
7529: OE_MSG_PUB.ADD;
7530: end if;
7531:
7532: if p_line_rec.service_txn_reason_code is not null and p_line_rec.service_txn_reason_code <>FND_API.G_MISS_CHAR then
7533: l_return_status := FND_API.G_RET_STS_ERROR;
7533: l_return_status := FND_API.G_RET_STS_ERROR;
7534: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7535: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
7536: OE_Order_UTIL.Get_Attribute_Name('SERVICE_TXN_REASON_CODE'));
7537: OE_MSG_PUB.ADD;
7538: end if;
7539:
7540: if p_line_rec.service_coterminate_flag is not null and p_line_rec.service_coterminate_flag <>FND_API.G_MISS_CHAR then
7541: l_return_status := FND_API.G_RET_STS_ERROR;
7541: l_return_status := FND_API.G_RET_STS_ERROR;
7542: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7543: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
7544: OE_Order_UTIL.Get_Attribute_Name('SERVICE_COTERMINATE_FLAG'));
7545: OE_MSG_PUB.ADD;
7546: end if;
7547: end if;
7548:
7549: --PP Revenue Recognition
7566: l_return_status := FND_API.G_RET_STS_ERROR;
7567: FND_MESSAGE.Set_Name('ONT','OE_INVALID_ATTRIBUTE');
7568: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
7569: OE_Order_Util.Get_Attribute_Name('ACCOUNTING_RULE_ID'));
7570: OE_MSG_PUB.ADD;
7571: END IF; --End of rule type
7572: END IF;--End of accounting type id is not null
7573: END IF; --End of item type not Service
7574: --PP Revenue Recognition
7624: fnd_message.set_name('ONT','OE_INVALID_ORDER_QUANTITY_UOM');
7625: fnd_message.set_token('ITEM',nvl(p_line_rec.ordered_item,p_line_rec.inventory_item_id));
7626: fnd_message.set_token('UOM', l_uom);
7627: l_return_status := FND_API.G_RET_STS_ERROR;
7628: OE_MSG_PUB.ADD;
7629: exception
7630: when no_data_found then
7631: IF l_debug_level > 0 then
7632: oe_debug_pub.add('OEXLLINB, no_data_found in service period validation', 1);
7698: WHEN OTHERS THEN
7699:
7700: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7701:
7702: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7703: THEN
7704: OE_MSG_PUB.Add_Exc_Msg
7705: ( G_PKG_NAME
7706: , 'Entity'
7700: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7701:
7702: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7703: THEN
7704: OE_MSG_PUB.Add_Exc_Msg
7705: ( G_PKG_NAME
7706: , 'Entity'
7707: );
7708: END IF;
8254:
8255: IF l_type_code = 'ARRIVAL' THEN
8256:
8257: FND_MESSAGE.SET_NAME('ONT','OE_SCH_INV_SHP_DATE');
8258: OE_MSG_PUB.Add;
8259:
8260: l_return_status := FND_API.G_RET_STS_ERROR;
8261:
8262: END IF;
8276:
8277: IF nvl(l_type_code,'SHIP') = 'SHIP' THEN
8278:
8279: FND_MESSAGE.SET_NAME('ONT','OE_SCH_INV_ARR_DATE');
8280: OE_MSG_PUB.Add;
8281:
8282: l_return_status := FND_API.G_RET_STS_ERROR;
8283:
8284: END IF;
8939: p_old_line_rec.accepted_quantity <> p_x_line_rec.accepted_quantity
8940: THEN
8941: p_x_line_rec.accepted_quantity := p_old_line_rec.accepted_quantity;
8942: FND_MESSAGE.SET_NAME('ONT','ONT_CANNOT_UPDATE_ACCEPTANCE');
8943: OE_MSG_PUB.Add;
8944: END IF;
8945:
8946: IF p_old_line_rec.REVREC_SIGNATURE_DATE IS NOT NULL AND
8947: p_old_line_rec.REVREC_SIGNATURE_DATE <> FND_API.G_MISS_DATE AND
8948: p_old_line_rec.REVREC_SIGNATURE_DATE <> p_x_line_rec.REVREC_SIGNATURE_DATE
8949: THEN
8950: p_x_line_rec.REVREC_SIGNATURE_DATE := p_old_line_rec.REVREC_SIGNATURE_DATE;
8951: FND_MESSAGE.SET_NAME('ONT','ONT_CANNOT_UPDATE_ACCEPTANCE');
8952: OE_MSG_PUB.Add;
8953: END IF;
8954:
8955: IF p_old_line_rec.accepted_by IS NOT NULL AND
8956: p_old_line_rec.accepted_by <> FND_API.G_MISS_NUM AND
8957: p_old_line_rec.accepted_by <> p_x_line_rec.accepted_by
8958: THEN
8959: p_x_line_rec.accepted_by := p_old_line_rec.accepted_by;
8960: FND_MESSAGE.SET_NAME('ONT','ONT_CANNOT_UPDATE_ACCEPTANCE');
8961: OE_MSG_PUB.Add;
8962: END IF;
8963: --
8964:
8965: IF l_debug_level > 0 then
8979: WHEN OTHERS THEN
8980:
8981: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8982:
8983: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8984: THEN
8985: OE_MSG_PUB.Add_Exc_Msg
8986: ( G_PKG_NAME
8987: , 'Attributes'
8981: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8982:
8983: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8984: THEN
8985: OE_MSG_PUB.Add_Exc_Msg
8986: ( G_PKG_NAME
8987: , 'Attributes'
8988: );
8989: END IF;
9484: -- and context is not defaulted by the flex api.
9485:
9486: IF OE_OE_PRICING_AVAILABILITY.IS_PRICING_AVAILIBILITY = 'N' THEN
9487: FND_MESSAGE.SET_NAME('FND', 'ONT_CONTEXT_NOT_FOUND');
9488: OE_MSG_PUB.ADD;
9489: IF l_debug_level > 0 THEN
9490: oe_debug_pub.add('desc_flex Context Not set for OE_LINE_ATTRIBUTES DFF ') ;
9491: END IF;
9492: RAISE FND_API.G_EXC_ERROR;
10629: WHEN OTHERS THEN
10630:
10631: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10632:
10633: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
10634: THEN
10635: OE_MSG_PUB.Add_Exc_Msg
10636: ( G_PKG_NAME
10637: , 'Entity_Delete'
10631: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10632:
10633: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
10634: THEN
10635: OE_MSG_PUB.Add_Exc_Msg
10636: ( G_PKG_NAME
10637: , 'Entity_Delete'
10638: );
10639: END IF;