[Home] [Help]
65: oe_debug_pub.add('old arrival set id :'||p_old_line_rec.arrival_set_id);
66: end if;
67: FND_MESSAGE.SET_NAME('ONT','OE_CANT_UPDATE_ORDER_ATTR');
68: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
69: OE_Order_UTIL.Get_Attribute_Name('ARRIVAL_SET_ID'));
70: OE_MSG_PUB.ADD;
71: x_return_status := FND_API.G_RET_STS_ERROR;
72: END IF;
73:
82: oe_debug_pub.add('old ship set id :'||p_old_line_rec.ship_set_id);
83: end if;
84: FND_MESSAGE.SET_NAME('ONT','OE_CANT_UPDATE_ORDER_ATTR');
85: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
86: OE_Order_UTIL.Get_Attribute_Name('SHIP_SET_ID'));
87: OE_MSG_PUB.ADD;
88: x_return_status := FND_API.G_RET_STS_ERROR;
89: END IF;
90: --for bug 3450282. Added NVL condition to consider g_miss_char during comparision
92: ,NVL(p_old_line_rec.schedule_ship_date,FND_API.G_MISS_DATE))
93: THEN
94: FND_MESSAGE.SET_NAME('ONT','OE_CANT_UPDATE_ORDER_ATTR');
95: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
96: OE_Order_UTIL.Get_Attribute_Name('SCHEDULE_SHIP_DATE'));
97: OE_MSG_PUB.ADD;
98: x_return_status := FND_API.G_RET_STS_ERROR;
99: END IF;
100: --for bug 3450282. Added NVL condition to consider g_miss_char during comparision
102: ,NVL(p_old_line_rec.schedule_arrival_date,FND_API.G_MISS_DATE))
103: THEN
104: FND_MESSAGE.SET_NAME('ONT','OE_CANT_UPDATE_ORDER_ATTR');
105: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
106: OE_Order_UTIL.Get_Attribute_Name('SCHEDULE_ARRIVAL_DATE'));
107: OE_MSG_PUB.ADD;
108: x_return_status := FND_API.G_RET_STS_ERROR;
109: END IF;
110:
129: p_old_line_rec.reserved_quantity IS NULL))
130: THEN
131: FND_MESSAGE.SET_NAME('ONT','OE_CANT_UPDATE_ORDER_ATTR');
132: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
133: OE_Order_UTIL.Get_Attribute_Name('RESERVED_QUANTITY'));
134: OE_MSG_PUB.ADD;
135: x_return_status := FND_API.G_RET_STS_ERROR;
136: END IF;
137: END IF;
147: p_old_line_rec.reserved_quantity2 IS NULL))
148: THEN
149: FND_MESSAGE.SET_NAME('ONT','OE_CANT_UPDATE_ORDER_ATTR');
150: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
151: OE_Order_UTIL.Get_Attribute_Name('RESERVED_QUANTITY2'));
152: OE_MSG_PUB.ADD;
153: x_return_status := FND_API.G_RET_STS_ERROR;
154: END IF;
155: END IF;
179: IF p_line_rec.schedule_action_code IS NOT NULL
180: THEN
181: FND_MESSAGE.SET_NAME('ONT','OE_CANT_UPDATE_ORDER_ATTR');
182: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
183: OE_Order_UTIL.Get_Attribute_Name('SCHEDULE_ACTION_CODE'));
184: OE_MSG_PUB.ADD;
185: x_return_status := FND_API.G_RET_STS_ERROR;
186: END IF;
187:
275: IF p_line_rec.sold_to_org_id IS NULL THEN
276: x_return_status := FND_API.G_RET_STS_ERROR;
277: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
278: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
279: OE_Order_UTIL.Get_Attribute_Name('SOLD_TO_ORG_ID'));
280: OE_MSG_PUB.ADD;
281: END IF;
282:
283: IF p_line_rec.invoice_to_org_id IS NULL THEN
283: IF p_line_rec.invoice_to_org_id IS NULL THEN
284: x_return_status := FND_API.G_RET_STS_ERROR;
285: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
286: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
287: OE_Order_UTIL.Get_Attribute_Name('INVOICE_TO_ORG_ID'));
288: OE_MSG_PUB.ADD;
289: END IF;
290:
291: IF p_line_rec.tax_exempt_flag IS NULL THEN
291: IF p_line_rec.tax_exempt_flag IS NULL THEN
292: x_return_status := FND_API.G_RET_STS_ERROR;
293: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
294: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
295: OE_Order_UTIL.Get_Attribute_Name('TAX_EXEMPT_FLAG'));
296: OE_MSG_PUB.ADD;
297: END IF;
298:
299:
301: IF p_line_rec.inventory_item_id IS NULL THEN
302: x_return_status := FND_API.G_RET_STS_ERROR;
303: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
304: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
305: OE_Order_UTIL.Get_Attribute_Name('INVENTORY_ITEM_ID'));
306: OE_MSG_PUB.ADD;
307: END IF;
308:
309: IF p_line_rec.order_quantity_uom IS NULL THEN
309: IF p_line_rec.order_quantity_uom IS NULL THEN
310: x_return_status := FND_API.G_RET_STS_ERROR;
311: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
312: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
313: OE_Order_UTIL.Get_Attribute_Name('ORDER_QUANTITY_UOM'));
314: OE_MSG_PUB.ADD;
315: END IF;
316:
317: -- Fix bug 1277092: ordered quantity should not be = 0 on a booked line
319: OR p_line_rec.ordered_quantity = 0 THEN
320: x_return_status := FND_API.G_RET_STS_ERROR;
321: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
322: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
323: OE_Order_UTIL.Get_Attribute_Name('ORDERED_QUANTITY'));
324: OE_MSG_PUB.ADD;
325: END IF;
326:
327: -- For all items that are NOT included items OR config items,
357: IF p_line_rec.unit_selling_price IS NULL THEN
358: x_return_status := FND_API.G_RET_STS_ERROR;
359: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
360: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
361: OE_Order_UTIL.Get_Attribute_Name('UNIT_SELLING_PRICE'));
362: OE_MSG_PUB.ADD;
363: END IF;
364:
365: END IF;
380: IF p_line_rec.price_list_id IS NULL THEN
381: x_return_status := FND_API.G_RET_STS_ERROR;
382: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
383: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
384: OE_Order_UTIL.Get_Attribute_Name('PRICE_LIST_ID'));
385: OE_MSG_PUB.ADD;
386: END IF;
387:
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
397: IF p_line_rec.unit_selling_price IS NULL THEN
398: x_return_status := FND_API.G_RET_STS_ERROR;
399: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
400: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
401: OE_Order_UTIL.Get_Attribute_Name('UNIT_SELLING_PRICE'));
402: OE_MSG_PUB.ADD;
403: END IF;
404: END IF;
405:
417: IF p_line_rec.ship_to_org_id IS NULL THEN
418: x_return_status := FND_API.G_RET_STS_ERROR;
419: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
420: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
421: OE_Order_UTIL.Get_Attribute_Name('SHIP_TO_ORG_ID'));
422: OE_MSG_PUB.ADD;
423: END IF;
424:
425: IF p_line_rec.payment_term_id IS NULL THEN
425: IF p_line_rec.payment_term_id IS NULL THEN
426: x_return_status := FND_API.G_RET_STS_ERROR;
427: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
428: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
429: OE_Order_UTIL.Get_Attribute_Name('PAYMENT_TERM_ID'));
430: OE_MSG_PUB.ADD;
431: END IF;
432:
433: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN
448: IF p_line_rec.accounting_rule_duration IS NULL THEN
449: x_return_status := FND_API.G_RET_STS_ERROR;
450: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
451: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
452: OE_Order_UTIL.Get_Attribute_Name('ACCOUNTING_RULE_DURATION'));
453: OE_MSG_PUB.ADD;
454: END IF; -- end of accounting_rule_duration null
455: END IF; -- end of variable accounting rule type
456:
492: IF p_line_rec.ship_from_org_id IS NULL THEN
493: x_return_status := FND_API.G_RET_STS_ERROR;
494: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_RETURN_ATTRIBUTE');
495: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
496: OE_Order_UTIL.Get_Attribute_Name('SHIP_FROM_ORG_ID'));
497: OE_MSG_PUB.ADD;
498: END IF;
499:
500: IF p_line_rec.request_date IS NULL THEN
500: IF p_line_rec.request_date IS NULL THEN
501: x_return_status := FND_API.G_RET_STS_ERROR;
502: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_RETURN_ATTRIBUTE');
503: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
504: OE_Order_UTIL.Get_Attribute_Name('REQUEST_DATE'));
505: OE_MSG_PUB.ADD;
506: END IF;
507:
508: END IF;
513: THEN
514: x_return_status := FND_API.G_RET_STS_ERROR;
515: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_RETURN_ATTRIBUTE');
516: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
517: OE_Order_UTIL.Get_Attribute_Name('TAX_DATE'));
518: OE_MSG_PUB.ADD;
519: END IF;
520:
521: -- Tax code is required under following conditions.
612: IF p_line_rec.service_duration IS NULL THEN
613: x_return_status := FND_API.G_RET_STS_ERROR;
614: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_SERVICE_DURATION');
615: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
616: OE_Order_UTIL.Get_Attribute_Name('SERVICE_DURATION'));
617: OE_MSG_PUB.ADD;
618: END IF;
619: END IF;
620: */
624: p_line_rec.service_reference_type_code = 'CUSTOMER_PRODUCT' THEN
625: IF p_line_rec.service_start_date IS NULL THEN
626: x_return_status := FND_API.G_RET_STS_ERROR;
627: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
628: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', OE_Order_UTIL.Get_Attribute_Name('SERVICE_START_DATE'));
629: OE_MSG_PUB.ADD;
630: END IF;
631: IF p_line_rec.service_end_date IS NULL THEN
632: x_return_status := FND_API.G_RET_STS_ERROR;
630: END IF;
631: IF p_line_rec.service_end_date IS NULL THEN
632: x_return_status := FND_API.G_RET_STS_ERROR;
633: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
634: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', OE_Order_UTIL.Get_Attribute_Name('SERVICE_END_DATE'));
635: OE_MSG_PUB.ADD;
636: END IF;
637: END IF;
638:
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;
646: IF p_line_rec.service_period IS NULL THEN
647: x_return_status := FND_API.G_RET_STS_ERROR;
648: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
649: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
650: OE_Order_UTIL.Get_Attribute_Name('SERVICE_PERIOD'));
651: OE_MSG_PUB.ADD;
652: END IF;
653: -- sol_ord_er #16014165
654: IF p_line_rec.subscription_enable_flag = 'Y' THEN
655: -- If Service Start Date is NULL
656: IF p_line_rec.service_start_date IS NULL THEN
657: x_return_status := FND_API.G_RET_STS_ERROR;
658: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
659: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', OE_Order_UTIL.Get_Attribute_Name('SERVICE_START_DATE'));
660: OE_MSG_PUB.ADD;
661: End IF;
662: -- If Subscription Template is NULL
663: IF NVL(P_LINE_REC.service_subs_template_id,FND_API.G_MISS_NUM)= FND_API.G_MISS_NUM THEN
662: -- If Subscription Template is NULL
663: IF NVL(P_LINE_REC.service_subs_template_id,FND_API.G_MISS_NUM)= FND_API.G_MISS_NUM THEN
664: x_return_status := FND_API.G_RET_STS_ERROR;
665: fnd_message.set_name('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
666: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', oe_order_util.get_attribute_name('SERVICE_SUBS_TEMPLATE_ID'));
667: OE_MSG_PUB.Add;
668: End IF;
669: END IF;
670: -- sol_ord_er #16014165
722: End;
723: IF l_revision_controlled = 'Y' THEN
724: x_return_status := FND_API.G_RET_STS_ERROR;
725: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_RETURN_ATTRIBUTE');
726: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', OE_Order_UTIL.Get_Attribute_Name('ITEM_REVISION'));
727: OE_MSG_PUB.ADD;
728: END IF;
729: END IF;
730: END IF;
1217: oe_debug_pub.add(' Validate Line Type Line Cat Code from the OE_TRXT_ALL table: '||lline_category_code);
1218: oe_debug_pub.add(' Validate Line Type Line Cat Code from the UI: '||p_line_rec.line_category_code);
1219: END IF;
1220: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1221: fnd_message.set_token('ATTRIBUTE', OE_Order_Util.Get_Attribute_Name('Line_type_id'));
1222: OE_MSG_PUB.Add;
1223: RAISE FND_API.G_EXC_ERROR;
1224: end if;
1225: END IF;
3292: if l_debug_level > 0 then
3293: oe_debug_pub.add('Release does not match blanket line inventory item', 1);
3294: end if;
3295: FND_MESSAGE.SET_NAME('ONT', 'OE_BLKT_INVALID_ATTRIBUTE');
3296: fnd_message.set_token('ATTRIBUTE', OE_Order_Util.Get_Attribute_Name('INVENTORY_ITEM_ID'));
3297: --for bug 3257240
3298: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE', OE_Id_To_Value.Inventory_Item(l_item_id));
3299: OE_MSG_PUB.Add;
3300: x_return_status := FND_API.G_RET_STS_ERROR;
3306: if l_debug_level > 0 then
3307: oe_debug_pub.add('Release does not match blanket line customer item', 1);
3308: end if;
3309: FND_MESSAGE.SET_NAME('ONT', 'OE_BLKT_INVALID_ATTRIBUTE');
3310: fnd_message.set_token('ATTRIBUTE', OE_Order_Util.Get_Attribute_Name('CUSTOMER_ITEM_ID'));
3311: --for bug 3257240
3312: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE', OE_Id_To_Value.Inventory_Item(l_item_id));
3313: OE_MSG_PUB.Add;
3314: x_return_status := FND_API.G_RET_STS_ERROR;
3342: if l_debug_level > 0 then
3343: oe_debug_pub.add('Release does not match blanket line item category', 1);
3344: end if;
3345: FND_MESSAGE.SET_NAME('ONT', 'OE_BLKT_INVALID_ATTRIBUTE');
3346: fnd_message.set_token('ATTRIBUTE', OE_Order_Util.Get_Attribute_Name('INVENTORY_ITEM_ID'));
3347: --for bug 3257240
3348: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE', OE_Id_To_Value.Inventory_Item(l_item_id));
3349: OE_MSG_PUB.Add;
3350: x_return_status := FND_API.G_RET_STS_ERROR;
3357: if l_debug_level > 0 then
3358: oe_debug_pub.add('Release does not match blanket line xref item item', 1);
3359: end if;
3360: FND_MESSAGE.SET_NAME('ONT', 'OE_BLKT_INVALID_ATTRIBUTE');
3361: fnd_message.set_token('ATTRIBUTE', OE_Order_Util.Get_Attribute_Name('ORDERED_ITEM'));
3362: --for bug 3257240
3363: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE', OE_Id_To_Value.Inventory_Item(l_item_id));
3364: OE_MSG_PUB.Add;
3365: x_return_status := FND_API.G_RET_STS_ERROR;
3395: AND ROWNUM = 1;
3396: exception
3397: when no_data_found then
3398: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_ATTRIBUTE');
3399: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name
3400: ('SOLD_TO_ORG_ID'));
3401: --for bug 3257240
3402: OE_Id_To_Value.Sold_To_Org
3403: ( p_sold_to_org_id => l_sold_to_org_id
3409: x_return_status := FND_API.G_RET_STS_ERROR;
3410: end;
3411: else
3412: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_ATTRIBUTE');
3413: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name
3414: ('SOLD_TO_ORG_ID'));
3415: --for bug 3257240
3416: OE_Id_To_Value.Sold_To_Org
3417: ( p_sold_to_org_id => l_sold_to_org_id
3502: ,p_old_line_rec.price_list_id) )
3503: THEN
3504: IF l_price_list_id <> p_line_rec.price_list_id THEN
3505: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_ATTRIBUTE');
3506: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name
3507: ('PRICE_LIST_ID'));
3508: --for bug 3257240
3509: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE',OE_Id_To_Value.Price_List(l_price_list_id));
3510: OE_MSG_PUB.ADD;
3521: ,p_old_line_rec.ship_to_org_id) )
3522: THEN
3523: IF l_ship_to_org_id <> p_line_rec.ship_to_org_id THEN
3524: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_ATTRIBUTE');
3525: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name
3526: ('SHIP_TO_ORG_ID'));
3527: --for bug 3257240
3528: OE_ID_TO_VALUE.ship_to_Org
3529: ( p_ship_to_org_id => p_line_rec.ship_to_org_id
3553: ,p_old_line_rec.invoice_to_org_id) )
3554: THEN
3555: IF l_invoice_to_org_id <> p_line_rec.invoice_to_org_id THEN
3556: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_ATTRIBUTE');
3557: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name
3558: ('INVOICE_TO_ORG_ID'));
3559: --for bug 3257240
3560: OE_ID_TO_VALUE.Invoice_To_Org
3561: ( p_invoice_to_org_id => p_line_rec.invoice_to_org_id
3585: ,p_old_line_rec.freight_terms_code) )
3586: THEN
3587: IF l_freight_terms_code <> p_line_rec.freight_terms_code THEN
3588: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_ATTRIBUTE');
3589: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name
3590: ('FREIGHT_TERMS_CODE'));
3591: --for bug 3257240
3592: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE',OE_Id_To_Value.Freight_Terms(l_freight_terms_code));
3593: OE_MSG_PUB.ADD;
3604: ,p_old_line_rec.shipping_method_code) )
3605: THEN
3606: IF l_shipping_method_code <> p_line_rec.shipping_method_code THEN
3607: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_ATTRIBUTE');
3608: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name
3609: ('SHIPPING_METHOD_CODE'));
3610: --for bug 3257240
3611: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE',OE_Id_To_Value.Ship_Method(l_shipping_method_code));
3612: OE_MSG_PUB.ADD;
3623: ,p_old_line_rec.payment_term_id) )
3624: THEN
3625: IF l_payment_term_id <> p_line_rec.payment_term_id THEN
3626: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_ATTRIBUTE');
3627: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name
3628: ('PAYMENT_TERM_ID'));
3629: --for bug 3257240
3630: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE',OE_Id_To_Value.Payment_Term(l_payment_term_id));
3631: OE_MSG_PUB.ADD;
3642: ,p_old_line_rec.accounting_rule_id) )
3643: THEN
3644: IF l_accounting_rule_id <> p_line_rec.accounting_rule_id THEN
3645: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_ATTRIBUTE');
3646: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name
3647: ('ACCOUNTING_RULE_ID'));
3648: --for bug 3257240
3649: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE',OE_Id_To_Value.Accounting_Rule(l_accounting_rule_id));
3650: OE_MSG_PUB.ADD;
3661: ,p_old_line_rec.invoicing_rule_id) )
3662: THEN
3663: IF l_invoicing_rule_id <> p_line_rec.invoicing_rule_id THEN
3664: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_ATTRIBUTE');
3665: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name
3666: ('INVOICING_RULE_ID'));
3667: --for bug 3257240
3668: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE',OE_Id_To_Value.Invoicing_Rule(l_invoicing_rule_id));
3669: OE_MSG_PUB.ADD;
3964: l_return_status := FND_API.G_RET_STS_ERROR;
3965:
3966: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
3967: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
3968: OE_Order_UTIL.Get_Attribute_Name('LINE_ID'));
3969: OE_MSG_PUB.Add;
3970:
3971: END IF;
3972: IF l_debug_level > 0 then
3978: l_return_status := FND_API.G_RET_STS_ERROR;
3979:
3980: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
3981: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
3982: OE_Order_UTIL.Get_Attribute_Name('INVENTORY_ITEM_ID'));
3983: OE_MSG_PUB.Add;
3984:
3985: END IF;
3986: IF l_debug_level > 0 then
3992: l_return_status := FND_API.G_RET_STS_ERROR;
3993:
3994: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
3995: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
3996: OE_Order_UTIL.Get_Attribute_Name('LINE_TYPE_ID'));
3997: OE_MSG_PUB.Add;
3998:
3999: ELSIF p_line_rec.line_type_id IS NOT NULL AND -- Bug 5873408
4000: ( nvl(p_line_rec.transaction_phase_code, 'F') <> 'N' )
4015: THEN
4016:
4017: IF p_line_rec.ship_from_org_id IS NULL THEN
4018: FND_MESSAGE.SET_NAME('ONT','ONT_ATTR_REQ_SET');
4019: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',oe_order_util.GET_ATTRIBUTE_name('SHIP_FROM_ORG_ID'));
4020: OE_MSG_PUB.ADD;
4021: RAISE FND_API.G_EXC_ERROR;
4022: END IF ;
4023:
4038: THEN
4039:
4040: IF p_line_rec.ship_from_org_id IS NULL THEN
4041: FND_MESSAGE.SET_NAME('ONT','ONT_ATTR_REQ_SET');
4042: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',oe_order_util.GET_ATTRIBUTE_name('SHIP_FROM_ORG_ID'));
4043: OE_MSG_PUB.ADD;
4044: RAISE FND_API.G_EXC_ERROR;
4045: END IF ;
4046:
4080: If(NVL(P_LINE_REC.subscription_enable_flag,'N') <> 'Y') then -- sol_ord_er #16014165
4081: IF NVL(P_LINE_REC.SERVICE_REFERENCE_TYPE_CODE, FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN
4082: l_return_status := FND_API.G_RET_STS_ERROR;
4083: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
4084: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', oe_order_util.get_attribute_name('SERVICE_REFERENCE_TYPE_CODE'));
4085: OE_MSG_PUB.Add;
4086: ELSIF NVL(P_LINE_REC.SERVICE_REFERENCE_LINE_ID, FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN
4087: -- Bug 16561155
4088: IF NVL(P_LINE_REC.SERVICE_REFERENCE_TYPE_CODE, FND_API.G_MISS_CHAR) = 'CUSTOMER_PRODUCT' THEN
4092: ELSE
4093: -- Bug 16561155
4094: l_return_status := FND_API.G_RET_STS_ERROR;
4095: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
4096: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', oe_order_util.get_attribute_name('SERVICE_REFERENCE_LINE_ID'));
4097: OE_MSG_PUB.Add;
4098: END IF;
4099: END IF;
4100: end if; -- sol_ord_er #16014165
4133: IF (NVL(P_LINE_REC.service_bill_option_code,'FBOM') <> 'FBOM'
4134: and NVL(P_LINE_REC.service_bill_profile_id,FND_API.G_MISS_NUM)= FND_API.G_MISS_NUM) THEN
4135: l_return_status := FND_API.G_RET_STS_ERROR;
4136: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
4137: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', oe_order_util.get_attribute_name('SERVICE_BILL_PROFILE_ID'));
4138: OE_MSG_PUB.Add;
4139: End IF;
4140: End If;
4141: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4181: l_return_status := FND_API.G_RET_STS_ERROR;
4182:
4183: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
4184: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
4185: OE_Order_UTIL.Get_Attribute_Name('RETURN_REASON_CODE'));
4186: OE_MSG_PUB.Add;
4187: END IF;
4188:
4189: -- Set the G_REF_RMA if the RMA is getting created or the reference is
4346: END IF;
4347: IF p_line_rec.ship_from_org_id is null THEN
4348: l_return_status := FND_API.G_RET_STS_ERROR;
4349: fnd_message.set_name('ONT', 'OE_ATTRIBUTE_REQUIRED');
4350: fnd_message.set_token('ATTRIBUTE',OE_Order_UTIL.Get_Attribute_Name('SHIP_FROM_ORG_ID'));
4351: OE_MSG_PUB.Add;
4352: ELSE
4353: -- validate the subinv is allowed (expense/asset)
4354: -- because defaulting can be defaulting an expense sub
5328: l_return_status := FND_API.G_RET_STS_ERROR;
5329: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'TASK_ID');
5330: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
5331: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
5332: OE_Order_Util.Get_Attribute_Name('task_id'));
5333: OE_MSG_PUB.Add;
5334: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
5335:
5336: END IF;
5648:
5649: l_return_status := FND_API.G_RET_STS_ERROR;
5650: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
5651: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
5652: OE_Order_Util.Get_Attribute_Name('ship_to_org_id'));
5653: OE_MSG_PUB.Add;
5654: END IF;
5655: END IF;
5656:
5700: ELSE
5701: l_return_status := FND_API.G_RET_STS_ERROR;
5702: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
5703: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
5704: OE_Order_Util.Get_Attribute_Name('ship_to_contact_id'));
5705: OE_MSG_PUB.Add;
5706: END IF;
5707: WHEN OTHERS THEN
5708: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5740: ELSE
5741: l_return_status := FND_API.G_RET_STS_ERROR;
5742: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
5743: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
5744: OE_Order_Util.Get_Attribute_Name('deliver_to_org_id'));
5745: OE_MSG_PUB.Add;
5746: END IF;
5747: END IF;
5748:
5794: ELSE
5795: l_return_status := FND_API.G_RET_STS_ERROR;
5796: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
5797: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
5798: OE_Order_Util.Get_Attribute_Name('deliver_to_contact_id'));
5799: OE_MSG_PUB.Add;
5800: END IF;
5801: WHEN OTHERS THEN
5802: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5886: ELSE
5887: l_return_status := FND_API.G_RET_STS_ERROR;
5888: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
5889: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
5890: OE_Order_Util.Get_Attribute_Name('invoice_to_org_id'));
5891: OE_MSG_PUB.Add;
5892: END IF;
5893: WHEN OTHERS THEN
5894: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5947: ELSE
5948: l_return_status := FND_API.G_RET_STS_ERROR;
5949: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
5950: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
5951: OE_Order_Util.Get_Attribute_Name('invoice_to_contact_id'));
5952: OE_MSG_PUB.Add;
5953: END IF;
5954: WHEN OTHERS THEN
5955: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6023: WHEN NO_DATA_FOUND THEN
6024: l_return_status := FND_API.G_RET_STS_ERROR;
6025: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
6026: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
6027: OE_Order_Util.Get_Attribute_Name('TAX_CODE'));
6028: OE_MSG_PUB.Add;
6029:
6030: WHEN OTHERS THEN
6031: IF OE_MSG_PUB.Check_Msg_Level (
6081: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_ERROR)
6082: THEN
6083: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
6084: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
6085: OE_Order_Util.Get_Attribute_Name('TAX_EXEMPT_REASON_CODE'));
6086: OE_MSG_PUB.Add;
6087: END IF;
6088: END IF;
6089: END IF; -- If Tax handling is exempt
6229: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
6230: THEN
6231: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
6232: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
6233: OE_Order_Util.Get_Attribute_Name('TAX_EXEMPT_NUMBER'));
6234: OE_MSG_PUB.Add;
6235: END IF;
6236: END IF;
6237:
6546: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'PRICE_LIST_ID');
6547:
6548: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
6549: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
6550: OE_Order_Util.Get_Attribute_Name('price_list_id'));
6551: OE_MSG_PUB.Add;
6552: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
6553: --
6554: END IF;
6950: IF l_debug_level > 0 then
6951: OE_DEBUG_PUB.Add('Coverage Template Cannot be provided to Subscription Service Line');
6952: END IF;
6953: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
6954: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',oe_order_util.get_attribute_name('SERVICE_COV_TEMPLATE_ID'));
6955: OE_MSG_PUB.Add;
6956: RAISE FND_API.G_EXC_ERROR;
6957: End If;
6958: /* Subscription Template cannot be provided to any other line other than Subscription Service */
6962: IF l_debug_level > 0 then
6963: OE_DEBUG_PUB.Add('Subscription Template Cannot be provided to a non Subscription Service Line');
6964: END IF;
6965: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
6966: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',oe_order_util.get_attribute_name('SERVICE_SUBS_TEMPLATE_ID'));
6967: OE_MSG_PUB.Add;
6968: RAISE FND_API.G_EXC_ERROR;
6969: End If;
6970: -- sol_ord_er #16014165 end
7356: OE_DEBUG_PUB.ADD('OLD LINE HAS INSTALL_BASE CAN NOT CHANGE IT');
7357: END IF;
7358: l_return_status := FND_API.G_RET_STS_ERROR;
7359: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7360: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_OWNER'));
7361: OE_MSG_PUB.Add;
7362: END IF;
7363:
7364:
7370: OE_DEBUG_PUB.ADD('OLD LINE HAS INSTALL_BASE CAN NOT CHANGE IT');
7371: END IF;
7372: l_return_status := FND_API.G_RET_STS_ERROR;
7373: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7374: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_INSTALLED_AT_LOCATION'));
7375: OE_MSG_PUB.Add;
7376: END IF;
7377:
7378:
7384: OE_DEBUG_PUB.ADD('OLD LINE HAS INSTALL_BASE CAN NOT CHANGE IT');
7385: END IF;
7386: l_return_status := FND_API.G_RET_STS_ERROR;
7387: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7388: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_CURRENT_LOCATION'));
7389: OE_MSG_PUB.Add;
7390: END IF;
7391:
7392: -- END OF check.
7403: OE_DEBUG_PUB.ADD('TRYING TO UPDATE WITH INSTALL_BASE OLD LINE HAS SOME VALUE');
7404: END IF;
7405: l_return_status := FND_API.G_RET_STS_ERROR;
7406: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7407: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_OWNER'));
7408: OE_MSG_PUB.Add;
7409: END IF;
7410:
7411: IF p_line_rec.ib_installed_at_location='INSTALL_BASE' and p_old_line_rec.ib_installed_at_location in ('BILL_TO','DELIVER_TO','END_CUSTOMER','SHIP_TO','SOLD_TO') THEN
7414: OE_DEBUG_PUB.ADD('TRYING TO UPDATE WITH INSTALL_BASE OLD LINE HAS SOME VALUE');
7415: END IF;
7416: l_return_status := FND_API.G_RET_STS_ERROR;
7417: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7418: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_INSTALLED_AT_LOCATION'));
7419: OE_MSG_PUB.Add;
7420: END IF;
7421:
7422: IF p_line_rec.ib_current_location='INSTALL_BASE' and p_old_line_rec.ib_current_location in ('BILL_TO','DELIVER_TO','END_CUSTOMER','SHIP_TO','SOLD_TO') THEN
7425: OE_DEBUG_PUB.ADD('TRYING TO UPDATE WITH INSTALL_BASE OLD LINE HAS SOME VALUE');
7426: END IF;
7427: l_return_status := FND_API.G_RET_STS_ERROR;
7428: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7429: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_CURRENT_LOCATION'));
7430: OE_MSG_PUB.Add;
7431: END IF;
7432:
7433: IF OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL >= '110510' THEN
7441: OE_DEBUG_PUB.ADD('THIS IS NOT A MODEL , CAN NOT HAVE INSTALL_BASE ');
7442: END IF;
7443: l_return_status := FND_API.G_RET_STS_ERROR;
7444: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7445: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_OWNER'));
7446: OE_MSG_PUB.Add;
7447:
7448: END IF;
7449:
7458: OE_DEBUG_PUB.ADD('This is not a model , can not have INSTALL_BASE ');
7459: END IF;
7460: l_return_status := FND_API.G_RET_STS_ERROR;
7461: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7462: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_INSTALLED_AT_LOCATION'));
7463: OE_MSG_PUB.Add;
7464:
7465: END IF;
7466:
7476: OE_DEBUG_PUB.ADD('THIS IS NOT A MODEL , CAN NOT HAVE INSTALL_BASE ');
7477: END IF;
7478: l_return_status := FND_API.G_RET_STS_ERROR;
7479: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7480: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_CURRENT_LOCATION'));
7481: OE_MSG_PUB.Add;
7482:
7483: END IF;
7484:
7504: OE_DEBUG_PUB.ADD('end customer id is null but value is end_customer!');
7505: END IF;
7506: l_return_status := FND_API.G_RET_STS_ERROR;
7507: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7508: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_OWNER'));
7509: OE_MSG_PUB.Add;
7510:
7511: ELSIF p_line_rec.ib_owner = 'SOLD_TO' AND
7512: p_line_rec.sold_to_org_id is null
7515: OE_DEBUG_PUB.ADD(' sold_to_org_id is null but value is sold_to!');
7516: END IF;
7517: l_return_status := FND_API.G_RET_STS_ERROR;
7518: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7519: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_OWNER'));
7520: OE_MSG_PUB.Add;
7521: END IF;
7522: END IF;
7523: IF l_debug_level > 0 then
7539: OE_DEBUG_PUB.ADD(' bill_to_org_id is null but value is bill_to!');
7540: END IF;
7541: l_return_status := FND_API.G_RET_STS_ERROR;
7542: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7543: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_INSTALLED_AT_LOCATION'));
7544: OE_MSG_PUB.Add;
7545:
7546: ELSIF p_line_rec.ib_installed_at_location = 'SHIP_TO' AND
7547: p_line_rec.ship_to_org_id is null
7550: OE_DEBUG_PUB.ADD(' ship_to_org_id is null but value is ship_to!');
7551: END IF;
7552: l_return_status := FND_API.G_RET_STS_ERROR;
7553: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7554: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_INSTALLED_AT_LOCATION'));
7555: OE_MSG_PUB.Add;
7556:
7557: ELSIF p_line_rec.ib_installed_at_location = 'DELIVER_TO' AND
7558: p_line_rec.deliver_to_org_id is null
7561: OE_DEBUG_PUB.ADD(' deliver_to_org_id is null but value is deliver_to!');
7562: END IF;
7563: l_return_status := FND_API.G_RET_STS_ERROR;
7564: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7565: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_INSTALLED_AT_LOCATION'));
7566: OE_MSG_PUB.Add;
7567: ELSIF p_line_rec.ib_installed_at_location = 'END_CUSTOMER' AND
7568: p_line_rec.end_customer_site_use_id is null
7569: THEN
7571: OE_DEBUG_PUB.ADD('end customer id is null but value is end_customer!');
7572: END IF;
7573: l_return_status := FND_API.G_RET_STS_ERROR;
7574: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7575: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_INSTALLED_AT_LOCATION'));
7576: OE_MSG_PUB.Add;
7577:
7578: -- no validation for SOLD_TO
7579: -- since no line level sold_to_site_use_id
7582: AND OE_Order_Cache.g_header_rec.sold_to_site_use_id is null
7583: THEN
7584: l_return_status := FND_API.G_RET_STS_ERROR;
7585: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7586: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_INSTALLED_AT_LOCATION'));
7587: OE_MSG_PUB.Add;
7588:
7589: END IF;
7590: END IF;
7607: OE_DEBUG_PUB.ADD(' bill_to_org_id is null but value is bill_to!');
7608: END IF;
7609: l_return_status := FND_API.G_RET_STS_ERROR;
7610: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7611: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_CURRENT_LOCATION'));
7612: OE_MSG_PUB.Add;
7613:
7614: ELSIF p_line_rec.ib_current_location = 'SHIP_TO' AND
7615: p_line_rec.ship_to_org_id is null
7618: OE_DEBUG_PUB.ADD(' ship_to_org_id is null but value is ship_to!');
7619: END IF;
7620: l_return_status := FND_API.G_RET_STS_ERROR;
7621: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7622: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_CURRENT_LOCATION'));
7623: OE_MSG_PUB.Add;
7624:
7625: ELSIF p_line_rec.ib_current_location = 'DELIVER_TO' AND
7626: p_line_rec.deliver_to_org_id is null
7626: p_line_rec.deliver_to_org_id is null
7627: THEN
7628: l_return_status := FND_API.G_RET_STS_ERROR;
7629: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7630: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_CURRENT_LOCATION'));
7631: OE_MSG_PUB.Add;
7632:
7633: ELSIF p_line_rec.ib_current_location = 'END_CUSTOMER' AND
7634: p_line_rec.end_customer_site_use_id is null
7634: p_line_rec.end_customer_site_use_id is null
7635: THEN
7636: l_return_status := FND_API.G_RET_STS_ERROR;
7637: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7638: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_CURRENT_LOCATION'));
7639: OE_MSG_PUB.Add;
7640:
7641: -- no validation for SOLD_TO
7642: -- since no line level sold_to_site_use_id
7645: AND OE_Order_Cache.g_header_rec.sold_to_site_use_id is null
7646: THEN
7647: l_return_status := FND_API.G_RET_STS_ERROR;
7648: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7649: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_CURRENT_LOCATION'));
7650: OE_MSG_PUB.Add;
7651:
7652:
7653: END IF;
7681: WHEN NO_DATA_FOUND THEN
7682: l_return_status := FND_API.G_RET_STS_ERROR;
7683: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7684: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
7685: OE_Order_Util.Get_Attribute_Name('END_CUSTOMER_CONTACT_ID'));
7686: OE_MSG_PUB.Add;
7687:
7688: WHEN OTHERS THEN
7689: IF OE_MSG_PUB.Check_Msg_Level
7728: WHEN NO_DATA_FOUND THEN
7729: l_return_status := FND_API.G_RET_STS_ERROR;
7730: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7731: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
7732: OE_Order_Util.Get_Attribute_Name('END_CUSTOMER_SITE_USE_ID'));
7733: OE_MSG_PUB.Add;
7734:
7735: WHEN OTHERS THEN
7736: IF OE_MSG_PUB.Check_Msg_Level
7894: if p_line_rec.service_duration is not null and p_line_rec.service_duration <>FND_API.G_MISS_NUM then
7895: l_return_status := FND_API.G_RET_STS_ERROR;
7896: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7897: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
7898: OE_Order_UTIL.Get_Attribute_Name('SERVICE_DURATION'));
7899: OE_MSG_PUB.ADD;
7900: end if;
7901:
7902: if p_line_rec.service_period is not null and p_line_rec.service_period <>FND_API.G_MISS_CHAR then
7902: if p_line_rec.service_period is not null and p_line_rec.service_period <>FND_API.G_MISS_CHAR then
7903: l_return_status := FND_API.G_RET_STS_ERROR;
7904: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7905: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
7906: OE_Order_UTIL.Get_Attribute_Name('SERVICE_PERIOD'));
7907: OE_MSG_PUB.ADD;
7908: end if;
7909:
7910: if p_line_rec.service_start_date is not null and p_line_rec.service_start_date <>FND_API.G_MISS_DATE then
7910: if p_line_rec.service_start_date is not null and p_line_rec.service_start_date <>FND_API.G_MISS_DATE then
7911: l_return_status := FND_API.G_RET_STS_ERROR;
7912: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7913: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
7914: OE_Order_UTIL.Get_Attribute_Name('SERVICE_START_DATE'));
7915: OE_MSG_PUB.ADD;
7916: end if;
7917:
7918: if p_line_rec.service_end_date is not null and p_line_rec.service_end_date <>FND_API.G_MISS_DATE then
7918: if p_line_rec.service_end_date is not null and p_line_rec.service_end_date <>FND_API.G_MISS_DATE then
7919: l_return_status := FND_API.G_RET_STS_ERROR;
7920: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7921: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
7922: OE_Order_UTIL.Get_Attribute_Name('SERVICE_END_DATE'));
7923: OE_MSG_PUB.ADD;
7924: end if;
7925:
7926: -- webroot bug 6826344 added start
7933: if p_line_rec.service_txn_comments is not null and p_line_rec.service_txn_comments <>FND_API.G_MISS_CHAR then
7934: l_return_status := FND_API.G_RET_STS_ERROR;
7935: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7936: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
7937: OE_Order_UTIL.Get_Attribute_Name('SERVICE_TXN_COMMENTS'));
7938: OE_MSG_PUB.ADD;
7939: end if;
7940:
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
7941: if p_line_rec.service_txn_reason_code is not null and p_line_rec.service_txn_reason_code <>FND_API.G_MISS_CHAR then
7942: l_return_status := FND_API.G_RET_STS_ERROR;
7943: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7944: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
7945: OE_Order_UTIL.Get_Attribute_Name('SERVICE_TXN_REASON_CODE'));
7946: OE_MSG_PUB.ADD;
7947: end if;
7948:
7949: if p_line_rec.service_coterminate_flag is not null and p_line_rec.service_coterminate_flag <>FND_API.G_MISS_CHAR then
7949: if p_line_rec.service_coterminate_flag is not null and p_line_rec.service_coterminate_flag <>FND_API.G_MISS_CHAR then
7950: l_return_status := FND_API.G_RET_STS_ERROR;
7951: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7952: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
7953: OE_Order_UTIL.Get_Attribute_Name('SERVICE_COTERMINATE_FLAG'));
7954: OE_MSG_PUB.ADD;
7955: end if;
7956: end if;
7957:
7974: IF l_rule_type = 'PP_DR_ALL' or l_rule_type = 'PP_DR_PP' THEN
7975: l_return_status := FND_API.G_RET_STS_ERROR;
7976: FND_MESSAGE.Set_Name('ONT','OE_INVALID_ATTRIBUTE');
7977: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
7978: OE_Order_Util.Get_Attribute_Name('ACCOUNTING_RULE_ID'));
7979: OE_MSG_PUB.ADD;
7980: END IF; --End of rule type
7981: END IF;--End of accounting type id is not null
7982: END IF; --End of item type not Service