[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;
374: IF p_line_rec.price_list_id IS NULL THEN
375: x_return_status := FND_API.G_RET_STS_ERROR;
376: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
377: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
378: OE_Order_UTIL.Get_Attribute_Name('PRICE_LIST_ID'));
379: OE_MSG_PUB.ADD;
380: END IF;
381:
382:
383: IF p_line_rec.unit_list_price IS NULL THEN
384: x_return_status := FND_API.G_RET_STS_ERROR;
385: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
386: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
387: OE_Order_UTIL.Get_Attribute_Name('UNIT_LIST_PRICE'));
388: OE_MSG_PUB.ADD;
389: END IF;
390:
391: IF p_line_rec.unit_selling_price IS NULL THEN
391: IF p_line_rec.unit_selling_price IS NULL THEN
392: x_return_status := FND_API.G_RET_STS_ERROR;
393: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
394: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
395: OE_Order_UTIL.Get_Attribute_Name('UNIT_SELLING_PRICE'));
396: OE_MSG_PUB.ADD;
397: END IF;
398:
399:
410: IF p_line_rec.ship_to_org_id IS NULL THEN
411: x_return_status := FND_API.G_RET_STS_ERROR;
412: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
413: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
414: OE_Order_UTIL.Get_Attribute_Name('SHIP_TO_ORG_ID'));
415: OE_MSG_PUB.ADD;
416: END IF;
417:
418: IF p_line_rec.payment_term_id IS NULL THEN
418: IF p_line_rec.payment_term_id IS NULL THEN
419: x_return_status := FND_API.G_RET_STS_ERROR;
420: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
421: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
422: OE_Order_UTIL.Get_Attribute_Name('PAYMENT_TERM_ID'));
423: OE_MSG_PUB.ADD;
424: END IF;
425:
426: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN
441: IF p_line_rec.accounting_rule_duration IS NULL THEN
442: x_return_status := FND_API.G_RET_STS_ERROR;
443: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
444: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
445: OE_Order_UTIL.Get_Attribute_Name('ACCOUNTING_RULE_DURATION'));
446: OE_MSG_PUB.ADD;
447: END IF; -- end of accounting_rule_duration null
448: END IF; -- end of variable accounting rule type
449:
485: IF p_line_rec.ship_from_org_id IS NULL THEN
486: x_return_status := FND_API.G_RET_STS_ERROR;
487: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_RETURN_ATTRIBUTE');
488: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
489: OE_Order_UTIL.Get_Attribute_Name('SHIP_FROM_ORG_ID'));
490: OE_MSG_PUB.ADD;
491: END IF;
492:
493: IF p_line_rec.request_date IS NULL THEN
493: IF p_line_rec.request_date IS NULL THEN
494: x_return_status := FND_API.G_RET_STS_ERROR;
495: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_RETURN_ATTRIBUTE');
496: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
497: OE_Order_UTIL.Get_Attribute_Name('REQUEST_DATE'));
498: OE_MSG_PUB.ADD;
499: END IF;
500:
501: END IF;
506: THEN
507: x_return_status := FND_API.G_RET_STS_ERROR;
508: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_RETURN_ATTRIBUTE');
509: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
510: OE_Order_UTIL.Get_Attribute_Name('TAX_DATE'));
511: OE_MSG_PUB.ADD;
512: END IF;
513:
514: -- Tax code is required under following conditions.
605: IF p_line_rec.service_duration IS NULL THEN
606: x_return_status := FND_API.G_RET_STS_ERROR;
607: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_SERVICE_DURATION');
608: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
609: OE_Order_UTIL.Get_Attribute_Name('SERVICE_DURATION'));
610: OE_MSG_PUB.ADD;
611: END IF;
612: END IF;
613: */
618: p_line_rec.service_reference_type_code = 'CUSTOMER_PRODUCT' THEN
619: IF p_line_rec.service_start_date IS NULL THEN
620: x_return_status := FND_API.G_RET_STS_ERROR;
621: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
622: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', OE_Order_UTIL.Get_Attribute_Name('SERVICE_START_DATE'));
623: OE_MSG_PUB.ADD;
624: END IF;
625: IF p_line_rec.service_end_date IS NULL THEN
626: x_return_status := FND_API.G_RET_STS_ERROR;
624: END IF;
625: IF p_line_rec.service_end_date IS NULL THEN
626: x_return_status := FND_API.G_RET_STS_ERROR;
627: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
628: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', OE_Order_UTIL.Get_Attribute_Name('SERVICE_END_DATE'));
629: OE_MSG_PUB.ADD;
630: END IF;
631: END IF;
632:
633: IF p_line_rec.service_duration IS NULL THEN
634: x_return_status := FND_API.G_RET_STS_ERROR;
635: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
636: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
637: OE_Order_UTIL.Get_Attribute_Name('SERVICE_DURATION'));
638: OE_MSG_PUB.ADD;
639: END IF;
640: IF p_line_rec.service_period IS NULL THEN
641: x_return_status := FND_API.G_RET_STS_ERROR;
640: IF p_line_rec.service_period IS NULL THEN
641: x_return_status := FND_API.G_RET_STS_ERROR;
642: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
643: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
644: OE_Order_UTIL.Get_Attribute_Name('SERVICE_PERIOD'));
645: OE_MSG_PUB.ADD;
646: END IF;
647: END IF;
648: /* End of 1888018 change */
698: End;
699: IF l_revision_controlled = 'Y' THEN
700: x_return_status := FND_API.G_RET_STS_ERROR;
701: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_RETURN_ATTRIBUTE');
702: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', OE_Order_UTIL.Get_Attribute_Name('ITEM_REVISION'));
703: OE_MSG_PUB.ADD;
704: END IF;
705: END IF;
706: END IF;
1193: oe_debug_pub.add(' Validate Line Type Line Cat Code from the OE_TRXT_ALL table: '||lline_category_code);
1194: oe_debug_pub.add(' Validate Line Type Line Cat Code from the UI: '||p_line_rec.line_category_code);
1195: END IF;
1196: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1197: fnd_message.set_token('ATTRIBUTE', OE_Order_Util.Get_Attribute_Name('Line_type_id'));
1198: OE_MSG_PUB.Add;
1199: RAISE FND_API.G_EXC_ERROR;
1200: end if;
1201: END IF;
3167: if l_debug_level > 0 then
3168: oe_debug_pub.add('Release does not match blanket line inventory item', 1);
3169: end if;
3170: FND_MESSAGE.SET_NAME('ONT', 'OE_BLKT_INVALID_ATTRIBUTE');
3171: fnd_message.set_token('ATTRIBUTE', OE_Order_Util.Get_Attribute_Name('INVENTORY_ITEM_ID'));
3172: --for bug 3257240
3173: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE', OE_Id_To_Value.Inventory_Item(l_item_id));
3174: OE_MSG_PUB.Add;
3175: x_return_status := FND_API.G_RET_STS_ERROR;
3181: if l_debug_level > 0 then
3182: oe_debug_pub.add('Release does not match blanket line customer item', 1);
3183: end if;
3184: FND_MESSAGE.SET_NAME('ONT', 'OE_BLKT_INVALID_ATTRIBUTE');
3185: fnd_message.set_token('ATTRIBUTE', OE_Order_Util.Get_Attribute_Name('CUSTOMER_ITEM_ID'));
3186: --for bug 3257240
3187: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE', OE_Id_To_Value.Inventory_Item(l_item_id));
3188: OE_MSG_PUB.Add;
3189: x_return_status := FND_API.G_RET_STS_ERROR;
3217: if l_debug_level > 0 then
3218: oe_debug_pub.add('Release does not match blanket line item category', 1);
3219: end if;
3220: FND_MESSAGE.SET_NAME('ONT', 'OE_BLKT_INVALID_ATTRIBUTE');
3221: fnd_message.set_token('ATTRIBUTE', OE_Order_Util.Get_Attribute_Name('INVENTORY_ITEM_ID'));
3222: --for bug 3257240
3223: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE', OE_Id_To_Value.Inventory_Item(l_item_id));
3224: OE_MSG_PUB.Add;
3225: x_return_status := FND_API.G_RET_STS_ERROR;
3232: if l_debug_level > 0 then
3233: oe_debug_pub.add('Release does not match blanket line xref item item', 1);
3234: end if;
3235: FND_MESSAGE.SET_NAME('ONT', 'OE_BLKT_INVALID_ATTRIBUTE');
3236: fnd_message.set_token('ATTRIBUTE', OE_Order_Util.Get_Attribute_Name('ORDERED_ITEM'));
3237: --for bug 3257240
3238: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE', OE_Id_To_Value.Inventory_Item(l_item_id));
3239: OE_MSG_PUB.Add;
3240: x_return_status := FND_API.G_RET_STS_ERROR;
3270: AND ROWNUM = 1;
3271: exception
3272: when no_data_found then
3273: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_ATTRIBUTE');
3274: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name
3275: ('SOLD_TO_ORG_ID'));
3276: --for bug 3257240
3277: OE_Id_To_Value.Sold_To_Org
3278: ( p_sold_to_org_id => l_sold_to_org_id
3284: x_return_status := FND_API.G_RET_STS_ERROR;
3285: end;
3286: else
3287: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_ATTRIBUTE');
3288: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name
3289: ('SOLD_TO_ORG_ID'));
3290: --for bug 3257240
3291: OE_Id_To_Value.Sold_To_Org
3292: ( p_sold_to_org_id => l_sold_to_org_id
3377: ,p_old_line_rec.price_list_id) )
3378: THEN
3379: IF l_price_list_id <> p_line_rec.price_list_id THEN
3380: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_ATTRIBUTE');
3381: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name
3382: ('PRICE_LIST_ID'));
3383: --for bug 3257240
3384: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE',OE_Id_To_Value.Price_List(l_price_list_id));
3385: OE_MSG_PUB.ADD;
3396: ,p_old_line_rec.ship_to_org_id) )
3397: THEN
3398: IF l_ship_to_org_id <> p_line_rec.ship_to_org_id THEN
3399: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_ATTRIBUTE');
3400: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name
3401: ('SHIP_TO_ORG_ID'));
3402: --for bug 3257240
3403: OE_ID_TO_VALUE.ship_to_Org
3404: ( p_ship_to_org_id => p_line_rec.ship_to_org_id
3428: ,p_old_line_rec.invoice_to_org_id) )
3429: THEN
3430: IF l_invoice_to_org_id <> p_line_rec.invoice_to_org_id THEN
3431: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_ATTRIBUTE');
3432: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name
3433: ('INVOICE_TO_ORG_ID'));
3434: --for bug 3257240
3435: OE_ID_TO_VALUE.Invoice_To_Org
3436: ( p_invoice_to_org_id => p_line_rec.invoice_to_org_id
3460: ,p_old_line_rec.freight_terms_code) )
3461: THEN
3462: IF l_freight_terms_code <> p_line_rec.freight_terms_code THEN
3463: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_ATTRIBUTE');
3464: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name
3465: ('FREIGHT_TERMS_CODE'));
3466: --for bug 3257240
3467: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE',OE_Id_To_Value.Freight_Terms(l_freight_terms_code));
3468: OE_MSG_PUB.ADD;
3479: ,p_old_line_rec.shipping_method_code) )
3480: THEN
3481: IF l_shipping_method_code <> p_line_rec.shipping_method_code THEN
3482: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_ATTRIBUTE');
3483: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name
3484: ('SHIPPING_METHOD_CODE'));
3485: --for bug 3257240
3486: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE',OE_Id_To_Value.Ship_Method(l_shipping_method_code));
3487: OE_MSG_PUB.ADD;
3498: ,p_old_line_rec.payment_term_id) )
3499: THEN
3500: IF l_payment_term_id <> p_line_rec.payment_term_id THEN
3501: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_ATTRIBUTE');
3502: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name
3503: ('PAYMENT_TERM_ID'));
3504: --for bug 3257240
3505: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE',OE_Id_To_Value.Payment_Term(l_payment_term_id));
3506: OE_MSG_PUB.ADD;
3517: ,p_old_line_rec.accounting_rule_id) )
3518: THEN
3519: IF l_accounting_rule_id <> p_line_rec.accounting_rule_id THEN
3520: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_ATTRIBUTE');
3521: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name
3522: ('ACCOUNTING_RULE_ID'));
3523: --for bug 3257240
3524: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE',OE_Id_To_Value.Accounting_Rule(l_accounting_rule_id));
3525: OE_MSG_PUB.ADD;
3536: ,p_old_line_rec.invoicing_rule_id) )
3537: THEN
3538: IF l_invoicing_rule_id <> p_line_rec.invoicing_rule_id THEN
3539: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_ATTRIBUTE');
3540: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name
3541: ('INVOICING_RULE_ID'));
3542: --for bug 3257240
3543: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE',OE_Id_To_Value.Invoicing_Rule(l_invoicing_rule_id));
3544: OE_MSG_PUB.ADD;
3832: l_return_status := FND_API.G_RET_STS_ERROR;
3833:
3834: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
3835: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
3836: OE_Order_UTIL.Get_Attribute_Name('LINE_ID'));
3837: OE_MSG_PUB.Add;
3838:
3839: END IF;
3840: IF l_debug_level > 0 then
3846: l_return_status := FND_API.G_RET_STS_ERROR;
3847:
3848: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
3849: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
3850: OE_Order_UTIL.Get_Attribute_Name('INVENTORY_ITEM_ID'));
3851: OE_MSG_PUB.Add;
3852:
3853: END IF;
3854: IF l_debug_level > 0 then
3860: l_return_status := FND_API.G_RET_STS_ERROR;
3861:
3862: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
3863: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
3864: OE_Order_UTIL.Get_Attribute_Name('LINE_TYPE_ID'));
3865: OE_MSG_PUB.Add;
3866:
3867: ELSIF p_line_rec.line_type_id IS NOT NULL AND -- Bug 5873408
3868: ( nvl(p_line_rec.transaction_phase_code, 'F') <> 'N' )
3918: l_return_status := FND_API.G_RET_STS_ERROR;
3919:
3920: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
3921: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
3922: OE_Order_UTIL.Get_Attribute_Name('RETURN_REASON_CODE'));
3923: OE_MSG_PUB.Add;
3924: END IF;
3925:
3926: -- Set the G_REF_RMA if the RMA is getting created or the reference is
4046: END IF;
4047: IF p_line_rec.ship_from_org_id is null THEN
4048: l_return_status := FND_API.G_RET_STS_ERROR;
4049: fnd_message.set_name('ONT', 'OE_ATTRIBUTE_REQUIRED');
4050: fnd_message.set_token('ATTRIBUTE',OE_Order_UTIL.Get_Attribute_Name('SHIP_FROM_ORG_ID'));
4051: OE_MSG_PUB.Add;
4052: ELSE
4053: -- validate the subinv is allowed (expense/asset)
4054: -- because defaulting can be defaulting an expense sub
5012: l_return_status := FND_API.G_RET_STS_ERROR;
5013: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'TASK_ID');
5014: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
5015: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
5016: OE_Order_Util.Get_Attribute_Name('task_id'));
5017: OE_MSG_PUB.Add;
5018: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
5019:
5020: END IF;
5307:
5308: l_return_status := FND_API.G_RET_STS_ERROR;
5309: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
5310: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
5311: OE_Order_Util.Get_Attribute_Name('ship_to_org_id'));
5312: OE_MSG_PUB.Add;
5313: END IF;
5314: END IF;
5315:
5359: ELSE
5360: l_return_status := FND_API.G_RET_STS_ERROR;
5361: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
5362: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
5363: OE_Order_Util.Get_Attribute_Name('ship_to_contact_id'));
5364: OE_MSG_PUB.Add;
5365: END IF;
5366: WHEN OTHERS THEN
5367: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5399: ELSE
5400: l_return_status := FND_API.G_RET_STS_ERROR;
5401: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
5402: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
5403: OE_Order_Util.Get_Attribute_Name('deliver_to_org_id'));
5404: OE_MSG_PUB.Add;
5405: END IF;
5406: END IF;
5407:
5453: ELSE
5454: l_return_status := FND_API.G_RET_STS_ERROR;
5455: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
5456: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
5457: OE_Order_Util.Get_Attribute_Name('deliver_to_contact_id'));
5458: OE_MSG_PUB.Add;
5459: END IF;
5460: WHEN OTHERS THEN
5461: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5545: ELSE
5546: l_return_status := FND_API.G_RET_STS_ERROR;
5547: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
5548: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
5549: OE_Order_Util.Get_Attribute_Name('invoice_to_org_id'));
5550: OE_MSG_PUB.Add;
5551: END IF;
5552: WHEN OTHERS THEN
5553: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5606: ELSE
5607: l_return_status := FND_API.G_RET_STS_ERROR;
5608: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
5609: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
5610: OE_Order_Util.Get_Attribute_Name('invoice_to_contact_id'));
5611: OE_MSG_PUB.Add;
5612: END IF;
5613: WHEN OTHERS THEN
5614: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5682: WHEN NO_DATA_FOUND THEN
5683: l_return_status := FND_API.G_RET_STS_ERROR;
5684: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
5685: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
5686: OE_Order_Util.Get_Attribute_Name('TAX_CODE'));
5687: OE_MSG_PUB.Add;
5688:
5689: WHEN OTHERS THEN
5690: IF OE_MSG_PUB.Check_Msg_Level (
5740: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_ERROR)
5741: THEN
5742: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
5743: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
5744: OE_Order_Util.Get_Attribute_Name('TAX_EXEMPT_REASON_CODE'));
5745: OE_MSG_PUB.Add;
5746: END IF;
5747: END IF;
5748: END IF; -- If Tax handling is exempt
5888: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
5889: THEN
5890: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
5891: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
5892: OE_Order_Util.Get_Attribute_Name('TAX_EXEMPT_NUMBER'));
5893: OE_MSG_PUB.Add;
5894: END IF;
5895: END IF;
5896:
6174: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'PRICE_LIST_ID');
6175:
6176: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
6177: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
6178: OE_Order_Util.Get_Attribute_Name('price_list_id'));
6179: OE_MSG_PUB.Add;
6180: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
6181: --
6182: END IF;
6958: OE_DEBUG_PUB.ADD('OLD LINE HAS INSTALL_BASE CAN NOT CHANGE IT');
6959: END IF;
6960: l_return_status := FND_API.G_RET_STS_ERROR;
6961: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
6962: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_OWNER'));
6963: OE_MSG_PUB.Add;
6964: END IF;
6965:
6966:
6972: OE_DEBUG_PUB.ADD('OLD LINE HAS INSTALL_BASE CAN NOT CHANGE IT');
6973: END IF;
6974: l_return_status := FND_API.G_RET_STS_ERROR;
6975: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
6976: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_INSTALLED_AT_LOCATION'));
6977: OE_MSG_PUB.Add;
6978: END IF;
6979:
6980:
6986: OE_DEBUG_PUB.ADD('OLD LINE HAS INSTALL_BASE CAN NOT CHANGE IT');
6987: END IF;
6988: l_return_status := FND_API.G_RET_STS_ERROR;
6989: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
6990: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_CURRENT_LOCATION'));
6991: OE_MSG_PUB.Add;
6992: END IF;
6993:
6994: -- END OF check.
7005: OE_DEBUG_PUB.ADD('TRYING TO UPDATE WITH INSTALL_BASE OLD LINE HAS SOME VALUE');
7006: END IF;
7007: l_return_status := FND_API.G_RET_STS_ERROR;
7008: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7009: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_OWNER'));
7010: OE_MSG_PUB.Add;
7011: END IF;
7012:
7013: IF p_line_rec.ib_installed_at_location='INSTALL_BASE' and p_old_line_rec.ib_installed_at_location in ('BILL_TO','DELIVER_TO','END_CUSTOMER','SHIP_TO','SOLD_TO') THEN
7016: OE_DEBUG_PUB.ADD('TRYING TO UPDATE WITH INSTALL_BASE OLD LINE HAS SOME VALUE');
7017: END IF;
7018: l_return_status := FND_API.G_RET_STS_ERROR;
7019: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7020: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_INSTALLED_AT_LOCATION'));
7021: OE_MSG_PUB.Add;
7022: END IF;
7023:
7024: IF p_line_rec.ib_current_location='INSTALL_BASE' and p_old_line_rec.ib_current_location in ('BILL_TO','DELIVER_TO','END_CUSTOMER','SHIP_TO','SOLD_TO') THEN
7027: OE_DEBUG_PUB.ADD('TRYING TO UPDATE WITH INSTALL_BASE OLD LINE HAS SOME VALUE');
7028: END IF;
7029: l_return_status := FND_API.G_RET_STS_ERROR;
7030: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7031: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_CURRENT_LOCATION'));
7032: OE_MSG_PUB.Add;
7033: END IF;
7034:
7035: IF OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL >= '110510' THEN
7043: OE_DEBUG_PUB.ADD('THIS IS NOT A MODEL , CAN NOT HAVE INSTALL_BASE ');
7044: END IF;
7045: l_return_status := FND_API.G_RET_STS_ERROR;
7046: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7047: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_OWNER'));
7048: OE_MSG_PUB.Add;
7049:
7050: END IF;
7051:
7060: OE_DEBUG_PUB.ADD('This is not a model , can not have INSTALL_BASE ');
7061: END IF;
7062: l_return_status := FND_API.G_RET_STS_ERROR;
7063: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7064: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_INSTALLED_AT_LOCATION'));
7065: OE_MSG_PUB.Add;
7066:
7067: END IF;
7068:
7078: OE_DEBUG_PUB.ADD('THIS IS NOT A MODEL , CAN NOT HAVE INSTALL_BASE ');
7079: END IF;
7080: l_return_status := FND_API.G_RET_STS_ERROR;
7081: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7082: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_CURRENT_LOCATION'));
7083: OE_MSG_PUB.Add;
7084:
7085: END IF;
7086:
7106: OE_DEBUG_PUB.ADD('end customer id is null but value is end_customer!');
7107: END IF;
7108: l_return_status := FND_API.G_RET_STS_ERROR;
7109: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7110: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_OWNER'));
7111: OE_MSG_PUB.Add;
7112:
7113: ELSIF p_line_rec.ib_owner = 'SOLD_TO' AND
7114: p_line_rec.sold_to_org_id is null
7117: OE_DEBUG_PUB.ADD(' sold_to_org_id is null but value is sold_to!');
7118: END IF;
7119: l_return_status := FND_API.G_RET_STS_ERROR;
7120: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7121: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_OWNER'));
7122: OE_MSG_PUB.Add;
7123: END IF;
7124: END IF;
7125: IF l_debug_level > 0 then
7141: OE_DEBUG_PUB.ADD(' bill_to_org_id is null but value is bill_to!');
7142: END IF;
7143: l_return_status := FND_API.G_RET_STS_ERROR;
7144: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7145: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_INSTALLED_AT_LOCATION'));
7146: OE_MSG_PUB.Add;
7147:
7148: ELSIF p_line_rec.ib_installed_at_location = 'SHIP_TO' AND
7149: p_line_rec.ship_to_org_id is null
7152: OE_DEBUG_PUB.ADD(' ship_to_org_id is null but value is ship_to!');
7153: END IF;
7154: l_return_status := FND_API.G_RET_STS_ERROR;
7155: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7156: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_INSTALLED_AT_LOCATION'));
7157: OE_MSG_PUB.Add;
7158:
7159: ELSIF p_line_rec.ib_installed_at_location = 'DELIVER_TO' AND
7160: p_line_rec.deliver_to_org_id is null
7163: OE_DEBUG_PUB.ADD(' deliver_to_org_id is null but value is deliver_to!');
7164: END IF;
7165: l_return_status := FND_API.G_RET_STS_ERROR;
7166: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7167: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_INSTALLED_AT_LOCATION'));
7168: OE_MSG_PUB.Add;
7169: ELSIF p_line_rec.ib_installed_at_location = 'END_CUSTOMER' AND
7170: p_line_rec.end_customer_site_use_id is null
7171: THEN
7173: OE_DEBUG_PUB.ADD('end customer id is null but value is end_customer!');
7174: END IF;
7175: l_return_status := FND_API.G_RET_STS_ERROR;
7176: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7177: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_INSTALLED_AT_LOCATION'));
7178: OE_MSG_PUB.Add;
7179:
7180: -- no validation for SOLD_TO
7181: -- since no line level sold_to_site_use_id
7184: AND OE_Order_Cache.g_header_rec.sold_to_site_use_id is null
7185: THEN
7186: l_return_status := FND_API.G_RET_STS_ERROR;
7187: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7188: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_INSTALLED_AT_LOCATION'));
7189: OE_MSG_PUB.Add;
7190:
7191: END IF;
7192: END IF;
7209: OE_DEBUG_PUB.ADD(' bill_to_org_id is null but value is bill_to!');
7210: END IF;
7211: l_return_status := FND_API.G_RET_STS_ERROR;
7212: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7213: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_CURRENT_LOCATION'));
7214: OE_MSG_PUB.Add;
7215:
7216: ELSIF p_line_rec.ib_current_location = 'SHIP_TO' AND
7217: p_line_rec.ship_to_org_id is null
7220: OE_DEBUG_PUB.ADD(' ship_to_org_id is null but value is ship_to!');
7221: END IF;
7222: l_return_status := FND_API.G_RET_STS_ERROR;
7223: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7224: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_CURRENT_LOCATION'));
7225: OE_MSG_PUB.Add;
7226:
7227: ELSIF p_line_rec.ib_current_location = 'DELIVER_TO' AND
7228: p_line_rec.deliver_to_org_id is null
7228: p_line_rec.deliver_to_org_id is null
7229: THEN
7230: l_return_status := FND_API.G_RET_STS_ERROR;
7231: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7232: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_CURRENT_LOCATION'));
7233: OE_MSG_PUB.Add;
7234:
7235: ELSIF p_line_rec.ib_current_location = 'END_CUSTOMER' AND
7236: p_line_rec.end_customer_site_use_id is null
7236: p_line_rec.end_customer_site_use_id is null
7237: THEN
7238: l_return_status := FND_API.G_RET_STS_ERROR;
7239: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7240: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_CURRENT_LOCATION'));
7241: OE_MSG_PUB.Add;
7242:
7243: -- no validation for SOLD_TO
7244: -- since no line level sold_to_site_use_id
7247: AND OE_Order_Cache.g_header_rec.sold_to_site_use_id is null
7248: THEN
7249: l_return_status := FND_API.G_RET_STS_ERROR;
7250: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7251: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_CURRENT_LOCATION'));
7252: OE_MSG_PUB.Add;
7253:
7254:
7255: END IF;
7283: WHEN NO_DATA_FOUND THEN
7284: l_return_status := FND_API.G_RET_STS_ERROR;
7285: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7286: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
7287: OE_Order_Util.Get_Attribute_Name('END_CUSTOMER_CONTACT_ID'));
7288: OE_MSG_PUB.Add;
7289:
7290: WHEN OTHERS THEN
7291: IF OE_MSG_PUB.Check_Msg_Level
7330: WHEN NO_DATA_FOUND THEN
7331: l_return_status := FND_API.G_RET_STS_ERROR;
7332: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7333: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
7334: OE_Order_Util.Get_Attribute_Name('END_CUSTOMER_SITE_USE_ID'));
7335: OE_MSG_PUB.Add;
7336:
7337: WHEN OTHERS THEN
7338: IF OE_MSG_PUB.Check_Msg_Level
7485: if p_line_rec.service_duration is not null and p_line_rec.service_duration <>FND_API.G_MISS_NUM then
7486: l_return_status := FND_API.G_RET_STS_ERROR;
7487: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7488: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
7489: OE_Order_UTIL.Get_Attribute_Name('SERVICE_DURATION'));
7490: OE_MSG_PUB.ADD;
7491: end if;
7492:
7493: if p_line_rec.service_period is not null and p_line_rec.service_period <>FND_API.G_MISS_CHAR then
7493: if p_line_rec.service_period is not null and p_line_rec.service_period <>FND_API.G_MISS_CHAR then
7494: l_return_status := FND_API.G_RET_STS_ERROR;
7495: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7496: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
7497: OE_Order_UTIL.Get_Attribute_Name('SERVICE_PERIOD'));
7498: OE_MSG_PUB.ADD;
7499: end if;
7500:
7501: if p_line_rec.service_start_date is not null and p_line_rec.service_start_date <>FND_API.G_MISS_DATE then
7501: if p_line_rec.service_start_date is not null and p_line_rec.service_start_date <>FND_API.G_MISS_DATE then
7502: l_return_status := FND_API.G_RET_STS_ERROR;
7503: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7504: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
7505: OE_Order_UTIL.Get_Attribute_Name('SERVICE_START_DATE'));
7506: OE_MSG_PUB.ADD;
7507: end if;
7508:
7509: if p_line_rec.service_end_date is not null and p_line_rec.service_end_date <>FND_API.G_MISS_DATE then
7509: if p_line_rec.service_end_date is not null and p_line_rec.service_end_date <>FND_API.G_MISS_DATE then
7510: l_return_status := FND_API.G_RET_STS_ERROR;
7511: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7512: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
7513: OE_Order_UTIL.Get_Attribute_Name('SERVICE_END_DATE'));
7514: OE_MSG_PUB.ADD;
7515: end if;
7516:
7517: -- webroot bug 6826344 added start
7524: if p_line_rec.service_txn_comments is not null and p_line_rec.service_txn_comments <>FND_API.G_MISS_CHAR then
7525: l_return_status := FND_API.G_RET_STS_ERROR;
7526: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7527: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
7528: OE_Order_UTIL.Get_Attribute_Name('SERVICE_TXN_COMMENTS'));
7529: OE_MSG_PUB.ADD;
7530: end if;
7531:
7532: if p_line_rec.service_txn_reason_code is not null and p_line_rec.service_txn_reason_code <>FND_API.G_MISS_CHAR then
7532: if p_line_rec.service_txn_reason_code is not null and p_line_rec.service_txn_reason_code <>FND_API.G_MISS_CHAR then
7533: l_return_status := FND_API.G_RET_STS_ERROR;
7534: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7535: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
7536: OE_Order_UTIL.Get_Attribute_Name('SERVICE_TXN_REASON_CODE'));
7537: OE_MSG_PUB.ADD;
7538: end if;
7539:
7540: if p_line_rec.service_coterminate_flag is not null and p_line_rec.service_coterminate_flag <>FND_API.G_MISS_CHAR then
7540: if p_line_rec.service_coterminate_flag is not null and p_line_rec.service_coterminate_flag <>FND_API.G_MISS_CHAR then
7541: l_return_status := FND_API.G_RET_STS_ERROR;
7542: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7543: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
7544: OE_Order_UTIL.Get_Attribute_Name('SERVICE_COTERMINATE_FLAG'));
7545: OE_MSG_PUB.ADD;
7546: end if;
7547: end if;
7548:
7565: IF l_rule_type = 'PP_DR_ALL' or l_rule_type = 'PP_DR_PP' THEN
7566: l_return_status := FND_API.G_RET_STS_ERROR;
7567: FND_MESSAGE.Set_Name('ONT','OE_INVALID_ATTRIBUTE');
7568: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
7569: OE_Order_Util.Get_Attribute_Name('ACCOUNTING_RULE_ID'));
7570: OE_MSG_PUB.ADD;
7571: END IF; --End of rule type
7572: END IF;--End of accounting type id is not null
7573: END IF; --End of item type not Service