[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:
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:
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:
397: IF p_line_rec.unit_selling_price IS NULL THEN
398: x_return_status := FND_API.G_RET_STS_ERROR;
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;
405:
406:
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:
425: IF p_line_rec.payment_term_id IS NULL THEN
426: x_return_status := FND_API.G_RET_STS_ERROR;
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:
433: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN
434: IF p_line_rec.item_type_code <> 'SERVICE' 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
456:
457: -- WEBROOT ER bug 6826344 start
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;
472: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
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;
478:
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:
500: IF p_line_rec.request_date IS NULL THEN
501: x_return_status := FND_API.G_RET_STS_ERROR;
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:
508: END IF;
509:
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:
521: -- Tax code is required under following conditions.
522: -- 1. The tax hadnling is required at line level.
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:
607: END IF;
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;
620: */
621:
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;
633: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
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:
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
647: x_return_status := FND_API.G_RET_STS_ERROR;
648: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
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
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;
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
671: END IF;
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;
689:
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:
704: /* Fix Bug 2429989: Returning Revision Controlled Items */
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;
731: */
735:
736: EXCEPTION
737: WHEN OTHERS THEN
738: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
739: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
740: THEN
741: OE_MSG_PUB.Add_Exc_Msg
742: ( G_PKG_NAME
743: , 'Check_Book_Reqd_Attributes'
737: WHEN OTHERS THEN
738: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
739: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
740: THEN
741: OE_MSG_PUB.Add_Exc_Msg
742: ( G_PKG_NAME
743: , 'Check_Book_Reqd_Attributes'
744: );
745: END IF;
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:
837: END IF;
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;
874:
894: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
895:
896: WHEN OTHERS THEN
897: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
898: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
899: THEN
900: OE_MSG_PUB.Add_Exc_Msg
901: ( 'OE_VALIDATE_LINE',
902: 'Validate_Shipset_SMC');
896: WHEN OTHERS THEN
897: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
898: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
899: THEN
900: OE_MSG_PUB.Add_Exc_Msg
901: ( 'OE_VALIDATE_LINE',
902: 'Validate_Shipset_SMC');
903: END IF;
904: END Validate_Shipset_SMC;
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:
979: ELSE
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:
992: 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;
1036: ELSIF l_qty_return_status = 'E' THEN
1037: oe_msg_pub.add;
1033: oe_msg_pub.add;
1034: x_return_status := FND_API.G_RET_STS_ERROR;
1035: END IF;
1036: ELSIF l_qty_return_status = 'E' THEN
1037: oe_msg_pub.add;
1038: x_return_status := FND_API.G_RET_STS_ERROR;
1039: END IF;
1040:
1041: ELSIF l_qty_return_status = 'S' THEN
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;
1138:
1139: END IF;
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;
1226:
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:
1243: IF (NOT OE_GLOBALS.EQUAL(p_line_rec.line_type_id,p_old_line_rec.line_type_id))
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:
1300: END IF;
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;
1313:
1311: WHEN FND_API.G_EXC_ERROR THEN
1312: RAISE FND_API.G_EXC_ERROR;
1313:
1314: WHEN OTHERS THEN
1315: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1316: THEN
1317: OE_MSG_PUB.Add_Exc_Msg
1318: ( G_PKG_NAME ,
1319: 'Validate_Line_Type'
1313:
1314: WHEN OTHERS THEN
1315: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1316: THEN
1317: OE_MSG_PUB.Add_Exc_Msg
1318: ( G_PKG_NAME ,
1319: 'Validate_Line_Type'
1320: );
1321: END IF;
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');
1383: OE_MSG_PUB.add;
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:
1387: -- bug 6647169 begin
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;
1415: EXCEPTION when others 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
1560: IF l_debug_level > 0 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;
1568:
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;
1962: IF l_debug_level > 0 then
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;
2040: IF l_debug_level > 0 then
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:
2099: EXCEPTION
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
2110: oe_debug_pub.add('Validate_Return_Item: When Others',1);
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:
2143: if l_debug_level > 0 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
2158: oe_debug_pub.add('Validate_Return_Reference: When Others',1);
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:
2165: FUNCTION Validate_Return_Reference
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
2215:
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:
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:
2296: IF l_booked_flag = 'Y' THEN
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);
2304: END IF;
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
2317: oe_debug_pub.add('Validate_Return_Reference: When Others',1);
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:
2324: /*
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');
2363: OE_MSG_PUB.Add;
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)
2367: fnd_message.set_name('ONT','OE_LINE_HAS_RMA_CANNOT_DELINK');
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
2372: 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 */
2684:
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
2714: x_return_status := FND_API.G_RET_STS_ERROR;
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);
2721: END IF;
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;
2744:
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;
2775:
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:
2793: x_return_status := FND_API.G_RET_STS_ERROR;
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
2848: IF l_debug_level > 0 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;
2862: END IF;
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;
2908:
2909: END IF; -- if external
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
2926: oe_debug_pub.add('leaving validate_source_type', 3);
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;
2996: RETURN FALSE;
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
3023:
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;
3052: x_return_status := FND_API.G_RET_STS_ERROR;
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:
3152:
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;
3175: ELSE --for bug 3372805
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:
3196: -- If any of the above checks failed, no need to proceed with
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
3303:
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:
3317: ELSIF l_item_context = 'ALL' THEN
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:
3353: ELSE
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;
3368: END IF;
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
3412: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_ATTRIBUTE');
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;
3426:
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:
3446: --Active Blanket Validation for release lines.For Bug 3192386
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:
3461:
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:
3488:
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;
3514:
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;
3546:
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;
3578:
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;
3597:
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;
3616:
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;
3635:
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;
3654:
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;
3673:
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
3685: if l_debug_level > 0 then
3698: WHEN OTHERS THEN
3699:
3700: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3701:
3702: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3703: THEN
3704: OE_MSG_PUB.Add_Exc_Msg
3705: ( 'OE_VALIDATE_LINE',
3706: 'Validate_Blanket_Values');
3700: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3701:
3702: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3703: THEN
3704: OE_MSG_PUB.Add_Exc_Msg
3705: ( 'OE_VALIDATE_LINE',
3706: 'Validate_Blanket_Values');
3707: END IF;
3708:
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;
3972: IF l_debug_level > 0 then
3973: oe_debug_pub.add('2 '||l_return_status, 1);
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;
3986: IF l_debug_level > 0 then
3987: oe_debug_pub.add('3 '||l_return_status, 1);
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
4000: ( nvl(p_line_rec.transaction_phase_code, 'F') <> 'N' )
4001: 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:
4024: /* IF p_line_rec.shipping_method_code IS NULL THEN
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:
4031: END IF ;
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:
4047: /* IF p_line_rec.shipping_method_code IS NULL THEN
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 ;
4054: END IF ;
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
4089: l_return_status := FND_API.G_RET_STS_ERROR;
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;
4095: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
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
4101:
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;
4124: --bug 16208602 end
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
4142: RAISE FND_API.G_EXC_ERROR;
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:
4168: END IF;
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:
4189: -- Set the G_REF_RMA if the RMA is getting created or the reference is
4190: -- changing.
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;
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
4271: OR P_line_rec.arrival_set_id is not null)
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:
4286: END IF;
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 --
4302:
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;
4329: END IF;
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:
4341: IF p_line_rec.subinventory is not null THEN
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
4355: -- and the INV profile is set to No.
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
4407: select 'Y'
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;
4443: ELSE -- external
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:
4450: -- end subinventory
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
4519: p_line_rec.reference_line_id <> FND_API.G_MISS_NUM
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
4553: THEN
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
4585: END IF; -- IF p_line_rec.reference_line_id is NOT NULL
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
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:
4631: /* If qty1/qty2 both populated, check tolerances
4683: END IF;
4684:
4685: l_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST, -- INVCONV
4686: p_encoded => 'F');
4687: oe_msg_pub.add_text(p_message_text => l_msg_data);
4688: IF l_debug_level > 0 THEN
4689: oe_debug_pub.add(l_msg_data,1);
4690: END IF;
4691: RAISE fnd_api.g_exc_error;
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
4740:
4756: END IF;
4757:
4758: l_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST, -- INVCONV
4759: p_encoded => 'F');
4760: oe_msg_pub.add_text(p_message_text => l_msg_data);
4761: IF l_debug_level > 0 THEN
4762: oe_debug_pub.add(l_msg_data,1);
4763: END IF;
4764: l_return_status := FND_API.G_RET_STS_ERROR;
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;
4849:
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:
5194: END IF;
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:
5231: l_return_status := FND_API.G_RET_STS_ERROR;
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.
5237:
5266: OE_DEBUG_PUB.Add('Validate Proj References Result:'||
5267: result,1);
5268: END IF;
5269: IF result <> PJM_PROJECT.G_VALIDATE_SUCCESS THEN
5270: OE_MSG_PUB.Transfer_Msg_Stack;
5271: l_msg_count:=OE_MSG_PUB.COUNT_MSG;
5272: FOR I in 1..l_msg_count loop
5273: l_msg_data := OE_MSG_PUB.Get(I,'F');
5274: IF l_debug_level > 0 then
5267: result,1);
5268: END IF;
5269: IF result <> PJM_PROJECT.G_VALIDATE_SUCCESS THEN
5270: OE_MSG_PUB.Transfer_Msg_Stack;
5271: l_msg_count:=OE_MSG_PUB.COUNT_MSG;
5272: FOR I in 1..l_msg_count loop
5273: l_msg_data := OE_MSG_PUB.Get(I,'F');
5274: IF l_debug_level > 0 then
5275: OE_DEBUG_PUB.add(l_msg_data,1);
5269: IF result <> PJM_PROJECT.G_VALIDATE_SUCCESS THEN
5270: OE_MSG_PUB.Transfer_Msg_Stack;
5271: l_msg_count:=OE_MSG_PUB.COUNT_MSG;
5272: FOR I in 1..l_msg_count loop
5273: l_msg_data := OE_MSG_PUB.Get(I,'F');
5274: IF l_debug_level > 0 then
5275: OE_DEBUG_PUB.add(l_msg_data,1);
5276: END IF;
5277: END LOOP;
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;
5313:
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
5323:
5325: p_line_rec.project_id,
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;
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:
5336: END IF;
5337:
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:
5336: END IF;
5337:
5338: ELSIF (p_line_rec.task_id is NULL
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:
5351: END IF;
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;
5372: END IF; -- Added for bug 6243026
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:
5389:
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;
5413: FND_MESSAGE.SET_NAME('ONT', 'OE_VAL_TASK_UPD');
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;
5418:
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;
5454: IF l_debug_level > 0 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:
5474: IF l_debug_level > 0 then
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
5497: oe_debug_pub.add('13 '||l_return_status, 1);
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;
5516: IF l_debug_level > 0 then
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:
5569: -- Validate if Reference SO Line is Valid
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
5624: oe_debug_pub.add('14_3 '||l_return_status, 1);
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;
5656:
5657: END IF;
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
5708: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5709: OE_MSG_PUB.Add_Exc_Msg
5704: OE_Order_Util.Get_Attribute_Name('ship_to_contact_id'));
5705: OE_MSG_PUB.Add;
5706: END IF;
5707: WHEN OTHERS THEN
5708: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5709: OE_MSG_PUB.Add_Exc_Msg
5710: ( G_PKG_NAME ,
5711: 'Record - Ship To Contact validation '
5712: );
5705: OE_MSG_PUB.Add;
5706: END IF;
5707: WHEN OTHERS THEN
5708: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5709: OE_MSG_PUB.Add_Exc_Msg
5710: ( G_PKG_NAME ,
5711: 'Record - Ship To Contact validation '
5712: );
5713: END IF;
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;
5748:
5749: END IF;
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
5802: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5803: OE_MSG_PUB.Add_Exc_Msg
5798: OE_Order_Util.Get_Attribute_Name('deliver_to_contact_id'));
5799: OE_MSG_PUB.Add;
5800: END IF;
5801: WHEN OTHERS THEN
5802: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5803: OE_MSG_PUB.Add_Exc_Msg
5804: ( G_PKG_NAME ,
5805: 'Record - Deliver To Contact validation '
5806: );
5799: OE_MSG_PUB.Add;
5800: END IF;
5801: WHEN OTHERS THEN
5802: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5803: OE_MSG_PUB.Add_Exc_Msg
5804: ( G_PKG_NAME ,
5805: 'Record - Deliver To Contact validation '
5806: );
5807: END IF;
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
5894: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5895: OE_MSG_PUB.Add_Exc_Msg
5890: OE_Order_Util.Get_Attribute_Name('invoice_to_org_id'));
5891: OE_MSG_PUB.Add;
5892: END IF;
5893: WHEN OTHERS THEN
5894: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5895: OE_MSG_PUB.Add_Exc_Msg
5896: ( G_PKG_NAME ,
5897: 'Record - Invoice To Org validation '
5898: );
5891: OE_MSG_PUB.Add;
5892: END IF;
5893: WHEN OTHERS THEN
5894: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5895: OE_MSG_PUB.Add_Exc_Msg
5896: ( G_PKG_NAME ,
5897: 'Record - Invoice To Org validation '
5898: );
5899: END IF;
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
5955: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5956: OE_MSG_PUB.Add_Exc_Msg
5951: OE_Order_Util.Get_Attribute_Name('invoice_to_contact_id'));
5952: OE_MSG_PUB.Add;
5953: END IF;
5954: WHEN OTHERS THEN
5955: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5956: OE_MSG_PUB.Add_Exc_Msg
5957: ( G_PKG_NAME ,
5958: 'Record - Invoice To Contact validation '
5959: );
5952: OE_MSG_PUB.Add;
5953: END IF;
5954: WHEN OTHERS THEN
5955: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5956: OE_MSG_PUB.Add_Exc_Msg
5957: ( G_PKG_NAME ,
5958: 'Record - Invoice To Contact validation '
5959: );
5960: END IF;
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
6031: IF OE_MSG_PUB.Check_Msg_Level (
6032: OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6027: OE_Order_Util.Get_Attribute_Name('TAX_CODE'));
6028: OE_MSG_PUB.Add;
6029:
6030: WHEN OTHERS THEN
6031: IF OE_MSG_PUB.Check_Msg_Level (
6032: OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6033: THEN
6034: OE_MSG_PUB.Add_Exc_Msg
6035: ( G_PKG_NAME ,
6028: OE_MSG_PUB.Add;
6029:
6030: WHEN OTHERS THEN
6031: IF OE_MSG_PUB.Check_Msg_Level (
6032: OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6033: THEN
6034: OE_MSG_PUB.Add_Exc_Msg
6035: ( G_PKG_NAME ,
6036: 'Record - Tax Code validation '
6030: WHEN OTHERS THEN
6031: IF OE_MSG_PUB.Check_Msg_Level (
6032: OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6033: THEN
6034: OE_MSG_PUB.Add_Exc_Msg
6035: ( G_PKG_NAME ,
6036: 'Record - Tax Code validation '
6037: );
6038: END IF;
6048: (p_line_rec.tax_exempt_number IS NOT NULL OR
6049: p_line_rec.tax_exempt_reason_code IS NOT NULL)
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;
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
6059:
6066: --bug6732513
6067: /* IF p_line_rec.tax_exempt_number IS NULL
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;
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:
6077:
6077:
6078: IF p_line_rec.tax_exempt_reason_code IS NULL
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'));
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;
6089: END IF; -- If Tax handling is exempt
6090:
6094: (p_line_rec.tax_exempt_number IS NOT NULL OR
6095: p_line_rec.tax_exempt_reason_code IS NOT NULL)
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;
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
6105:
6225: ELSE
6226:
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'));
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;
6237:
6238: WHEN OTHERS THEN
6235: END IF;
6236: END IF;
6237:
6238: WHEN OTHERS THEN
6239: IF OE_MSG_PUB.Check_Msg_Level (
6240: OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6241: THEN
6242: OE_MSG_PUB.Add_Exc_Msg
6243: ( G_PKG_NAME ,
6236: END IF;
6237:
6238: WHEN OTHERS THEN
6239: IF OE_MSG_PUB.Check_Msg_Level (
6240: OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6241: THEN
6242: OE_MSG_PUB.Add_Exc_Msg
6243: ( G_PKG_NAME ,
6244: 'Record - Tax Exemptions '
6238: WHEN OTHERS THEN
6239: IF OE_MSG_PUB.Check_Msg_Level (
6240: OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6241: THEN
6242: OE_MSG_PUB.Add_Exc_Msg
6243: ( G_PKG_NAME ,
6244: 'Record - Tax Exemptions '
6245: );
6246: 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
6340: when no_data_found 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:
6367: */
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*/
6378: END IF;
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;
6453: raise FND_API.G_EXC_ERROR;
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;
6470: RAISE FND_API.G_EXC_ERROR;
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;
6495: RAISE FND_API.G_EXC_ERROR;
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;
6511: RAISE FND_API.G_EXC_ERROR;
6540: EXCEPTION
6541: --
6542: WHEN NO_DATA_FOUND THEN
6543: --
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');
6542: WHEN NO_DATA_FOUND THEN
6543: --
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'));
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: --
6554: END IF;
6555: --
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: --
6554: END IF;
6555: --
6556: RAISE FND_API.G_EXC_ERROR;
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: --
6589: END IF;
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;
6694: RAISE FND_API.G_EXC_ERROR;
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;
6732:
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;
6775:
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: */
6800: 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 */
6823:
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;
6851: -- End of check for duplicate PO number
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;
6886: RAISE FND_API.G_EXC_ERROR;
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;
6908:
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 */
6959: If (NVL(p_line_rec.subscription_enable_flag,'N') <> 'Y'
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
6971:
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
6985: oe_debug_pub.add('19 '||l_return_status ,1);
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:
7004: IF l_debug_level > 0 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;
7035: l_return_status := FND_API.G_RET_STS_ERROR;
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);
7049: END IF;
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' ||
7065: p_line_rec.override_atp_date_code,2);
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;
7092:
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
7132:
7294: oe_debug_pub.add('no po', 4);
7295: END IF;
7296: END IF;
7297:
7298: OE_MSG_PUB.Add;
7299: END IF;
7300:
7301: EXCEPTION
7302: WHEN NO_DATA_FOUND THEN
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:
7365: IF p_old_line_rec.ib_installed_at_location='INSTALL_BASE' AND
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:
7379: IF p_old_line_rec.ib_current_location='INSTALL_BASE' AND
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.
7393:
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
7412: IF l_debug_level > 0 THEN
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
7423: IF l_debug_level > 0 THEN
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
7434:
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:
7450: END IF;
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:
7467: END IF;
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:
7485: END IF;
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
7513: THEN
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
7524: oe_debug_pub.ADD('ib_installed_at_location: '||p_line_rec.ib_installed_at_location);
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
7548: THEN
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
7559: THEN
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
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
7580: -- REMOVE after LOV is fixed
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;
7591: IF l_debug_level > 0 then
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
7616: THEN
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
7627: THEN
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
7635: THEN
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
7643: -- REMOVE after LOV is fixed
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;
7654: END IF;
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
7689: IF OE_MSG_PUB.Check_Msg_Level
7690: ( OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7685: OE_Order_Util.Get_Attribute_Name('END_CUSTOMER_CONTACT_ID'));
7686: OE_MSG_PUB.Add;
7687:
7688: WHEN OTHERS THEN
7689: IF OE_MSG_PUB.Check_Msg_Level
7690: ( OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7691: THEN
7692: OE_MSG_PUB.Add_Exc_Msg
7693: ( G_PKG_NAME ,
7686: OE_MSG_PUB.Add;
7687:
7688: WHEN OTHERS THEN
7689: IF OE_MSG_PUB.Check_Msg_Level
7690: ( OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7691: THEN
7692: OE_MSG_PUB.Add_Exc_Msg
7693: ( G_PKG_NAME ,
7694: 'Record - End Customer Contact'
7688: WHEN OTHERS THEN
7689: IF OE_MSG_PUB.Check_Msg_Level
7690: ( OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7691: THEN
7692: OE_MSG_PUB.Add_Exc_Msg
7693: ( G_PKG_NAME ,
7694: 'Record - End Customer Contact'
7695: );
7696: END IF;
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
7736: IF OE_MSG_PUB.Check_Msg_Level
7737: ( OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7732: OE_Order_Util.Get_Attribute_Name('END_CUSTOMER_SITE_USE_ID'));
7733: OE_MSG_PUB.Add;
7734:
7735: WHEN OTHERS THEN
7736: IF OE_MSG_PUB.Check_Msg_Level
7737: ( OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7738: THEN
7739: OE_MSG_PUB.Add_Exc_Msg
7740: ( G_PKG_NAME ,
7733: OE_MSG_PUB.Add;
7734:
7735: WHEN OTHERS THEN
7736: IF OE_MSG_PUB.Check_Msg_Level
7737: ( OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7738: THEN
7739: OE_MSG_PUB.Add_Exc_Msg
7740: ( G_PKG_NAME ,
7741: 'Record - End Customer Site'
7735: WHEN OTHERS THEN
7736: IF OE_MSG_PUB.Check_Msg_Level
7737: ( OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7738: THEN
7739: OE_MSG_PUB.Add_Exc_Msg
7740: ( G_PKG_NAME ,
7741: 'Record - End Customer Site'
7742: );
7743: END IF;
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
7844:
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;
7870: ELSE -- Invalid charge_periodicity
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:
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;
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:
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;
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:
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;
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:
7926: -- webroot bug 6826344 added start
7927: END IF;
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:
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;
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:
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;
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;
7957:
7958: --PP Revenue Recognition
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
7982: END IF; --End of item type not Service
7983: --PP Revenue Recognition
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
8042: IF l_debug_level > 0 then
8043: oe_debug_pub.add('OEXLLINB, no_data_found in service period validation', 1);
8109: WHEN OTHERS THEN
8110:
8111: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8112:
8113: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8114: THEN
8115: OE_MSG_PUB.Add_Exc_Msg
8116: ( G_PKG_NAME
8117: , 'Entity'
8111: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8112:
8113: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8114: THEN
8115: OE_MSG_PUB.Add_Exc_Msg
8116: ( G_PKG_NAME
8117: , 'Entity'
8118: );
8119: END IF;
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:
8674: END IF;
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:
8696: END IF;
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
9383: IF p_x_line_rec.service_bill_profile_id IS NOT NULL AND
9467: WHEN OTHERS THEN
9468:
9469: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9470:
9471: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
9472: THEN
9473: OE_MSG_PUB.Add_Exc_Msg
9474: ( G_PKG_NAME
9475: , 'Attributes'
9469: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9470:
9471: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
9472: THEN
9473: OE_MSG_PUB.Add_Exc_Msg
9474: ( G_PKG_NAME
9475: , 'Attributes'
9476: );
9477: END IF;
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;
9989: RAISE FND_API.G_EXC_ERROR;
11151: WHEN OTHERS THEN
11152:
11153: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11154:
11155: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
11156: THEN
11157: OE_MSG_PUB.Add_Exc_Msg
11158: ( G_PKG_NAME
11159: , 'Entity_Delete'
11153: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11154:
11155: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
11156: THEN
11157: OE_MSG_PUB.Add_Exc_Msg
11158: ( G_PKG_NAME
11159: , 'Entity_Delete'
11160: );
11161: END IF;