[Home] [Help]
2447: x_return_status := FND_API.G_RET_STS_ERROR;
2448:
2449: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
2450: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2451: OE_Order_UTIL.Get_Attribute_Name('line_id'));
2452: OE_MSG_PUB.Add;
2453:
2454: END IF;
2455:
2459: x_return_status := FND_API.G_RET_STS_ERROR;
2460:
2461: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
2462: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2463: OE_Order_UTIL.Get_Attribute_Name('ITEM_IDENTIFIER_TYPE'));
2464: OE_MSG_PUB.Add;
2465:
2466: ELSIF p_line_rec.item_identifier_type <> 'ALL'
2467: AND p_line_rec.inventory_item_id IS NULL
2470: x_return_status := FND_API.G_RET_STS_ERROR;
2471:
2472: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
2473: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2474: OE_Order_UTIL.Get_Attribute_Name('INVENTORY_ITEM_ID'));
2475: OE_MSG_PUB.Add;
2476:
2477: END IF;
2478:
2517: THEN
2518: x_return_status := FND_API.G_RET_STS_ERROR;
2519: FND_MESSAGE.Set_Name('ONT','OE_INVALID_ATTRIBUTE');
2520: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2521: OE_Order_Util.Get_Attribute_Name('ACCOUNTING_RULE_ID'));
2522: OE_MSG_PUB.ADD;
2523: END IF;
2524:
2525:
2535: --some fields not allowed to update if release exists against line
2536: IF (p_line_rec.released_amount > 0) THEN
2537: fnd_message.set_name('ONT', 'OE_BLKT_UPDATE_LINE_ATTRIBUTE');
2538: fnd_message.set_token('ATTRIBUTE',
2539: OE_Order_UTIL.Get_Attribute_Name('LINE_NUMBER'));
2540: OE_MSG_PUB.Add;
2541: ELSE
2542: oe_delayed_requests_pvt.Log_request(p_Entity_Code =>
2543: OE_BLANKET_pub.G_ENTITY_BLANKET_LINE,
2573: (p_line_rec.inventory_item_id,l_old_line_rec.inventory_item_id)) THEN
2574:
2575: fnd_message.set_name('ONT', 'OE_BLKT_UPDATE_LINE_ATTRIBUTE');
2576: fnd_message.set_token('ATTRIBUTE',
2577: OE_Order_UTIL.Get_Attribute_Name('INVENTORY_ITEM_ID'));
2578: OE_MSG_PUB.add;
2579: x_return_status := FND_API.G_RET_STS_ERROR;
2580:
2581: ELSIF (p_line_rec.released_amount > 0) AND
2582: (NOT OE_GLOBALS.Equal
2583: (p_line_rec.item_identifier_type,l_old_line_rec.item_identifier_type)) THEN
2584: fnd_message.set_name('ONT', 'OE_BLKT_UPDATE_LINE_ATTRIBUTE');
2585: fnd_message.set_token('ATTRIBUTE',
2586: OE_Order_UTIL.Get_Attribute_Name('ITEM_IDENTIFIER_TYPE'));
2587: OE_MSG_PUB.add;
2588: x_return_status := FND_API.G_RET_STS_ERROR;
2589:
2590: ELSE
2659: end if;
2660: x_return_status := FND_API.G_RET_STS_ERROR;
2661: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2662: FND_MESSAGE.SET_TOKEN('ATTRIBUTE'
2663: , OE_Order_Util.Get_Attribute_Name('ship_to_org_id'));
2664: OE_MSG_PUB.Add;
2665: END IF;
2666: END IF; -- Ship to
2667:
2679:
2680: x_return_status := FND_API.G_RET_STS_ERROR;
2681: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2682: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2683: OE_Order_Util.Get_Attribute_Name('deliver_to_org_id'));
2684: OE_MSG_PUB.Add;
2685: END IF;
2686:
2687: END IF; -- Deliver to
2696: p_line_rec.sold_to_org_id )) THEN
2697: x_return_status := FND_API.G_RET_STS_ERROR;
2698: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2699: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2700: OE_Order_Util.Get_Attribute_Name('invoice_to_org_id'));
2701: OE_MSG_PUB.Add;
2702: END IF;
2703: END IF; -- Invoice to org
2704:
2759: IF p_line_rec.order_quantity_uom IS NULL THEN
2760: IF (g_new_price_list AND (p_line_rec.pricing_uom IS NULL)) THEN
2761: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
2762: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2763: OE_Order_Util.Get_Attribute_Name('PRICING_QUANTITY_UOM'));
2764: OE_MSG_PUB.Add;
2765: ELSIF p_line_rec.price_list_id IS NOT NULL THEN
2766: IF IS_BLANKET_PRICE_LIST(p_price_list_id => p_line_rec.price_list_id)
2767: AND p_line_rec.pricing_uom IS NULL THEN
2766: IF IS_BLANKET_PRICE_LIST(p_price_list_id => p_line_rec.price_list_id)
2767: AND p_line_rec.pricing_uom IS NULL THEN
2768: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
2769: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2770: OE_Order_Util.Get_Attribute_Name('PRICING_QUANTITY_UOM'));
2771: OE_MSG_PUB.Add;
2772: END IF;
2773: END IF;
2774: END IF;
2777: p_line_rec.price_list_id IS NULL AND
2778: (p_line_rec.enforce_price_list_flag = 'Y') THEN
2779: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
2780: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2781: OE_Order_UTIL.Get_Attribute_Name('PRICE_LIST_ID'));
2782: OE_MSG_PUB.ADD;
2783: x_return_status := FND_API.G_RET_STS_ERROR;
2784: END IF;
2785:
2905: l_old_line_rec.order_quantity_uom) THEN
2906: x_return_status := FND_API.G_RET_STS_ERROR;
2907: fnd_message.set_name('ONT', 'OE_BLKT_UPDATE_LINE_ATTRIBUTE');
2908: fnd_message.set_token('ATTRIBUTE',
2909: OE_Order_UTIL.Get_Attribute_Name('ORDER_QUANTITY_UOM'));
2910: OE_MSG_PUB.Add;
2911: END IF;
2912: END IF;
2913:
2975: l_old_line_rec.pricing_uom) THEN
2976: if (g_new_price_list) THEN
2977: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_UPDATE_LINE_ATTRIBUTE');
2978: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2979: OE_Order_UTIL.Get_Attribute_Name('PRICING_QUANTITY_UOM'));
2980: OE_MSG_PUB.ADD;
2981: x_return_status := FND_API.G_RET_STS_ERROR;
2982: elsif p_line_rec.price_list_id IS NOT NULL THEN
2983: if IS_BLANKET_PRICE_LIST(p_price_list_id => p_line_rec.price_list_id) THEN
2983: if IS_BLANKET_PRICE_LIST(p_price_list_id => p_line_rec.price_list_id) THEN
2984: x_return_status := FND_API.G_RET_STS_ERROR;
2985: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_UPDATE_LINE_ATTRIBUTE');
2986: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2987: OE_Order_UTIL.Get_Attribute_Name('PRICING_QUANTITY_UOM'));
2988: OE_MSG_PUB.ADD;
2989: x_return_status := FND_API.G_RET_STS_ERROR;
2990: end if;
2991: end if;
3212: ELSIF p_line_rec.price_list_id IS NOT NULL THEN
3213: x_return_status := FND_API.G_RET_STS_ERROR;
3214: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
3215: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
3216: OE_Order_UTIL.Get_Attribute_Name('UNIT_LIST_PRICE'));
3217: OE_MSG_PUB.ADD;
3218: END IF;
3219:
3220: END IF; --if g_new_price_list
3439: IF p_header_rec.header_id IS NULL THEN
3440: x_return_status := FND_API.G_RET_STS_ERROR;
3441: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
3442: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
3443: OE_Order_UTIL.Get_Attribute_Name('header_id'));
3444: OE_MSG_PUB.Add;
3445: END IF;
3446:
3447: IF p_header_rec.order_number IS NULL THEN
3447: IF p_header_rec.order_number IS NULL THEN
3448: x_return_status := FND_API.G_RET_STS_ERROR;
3449: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
3450: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
3451: OE_Order_UTIL.Get_Attribute_Name('BLANKET_NUMBER'));
3452: OE_MSG_PUB.Add;
3453: END IF;
3454: --Enabling Pricing Agreements for pack J
3455: IF OE_CODE_CONTROL.Get_Code_Release_Level < '110510' THEN
3456: IF p_header_rec.sold_to_org_id IS NULL THEN
3457: x_return_status := FND_API.G_RET_STS_ERROR;
3458: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
3459: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
3460: OE_Order_UTIL.Get_Attribute_Name('SOLD_TO_ORG_ID'));
3461: OE_MSG_PUB.Add;
3462: END IF;
3463: END IF;
3464:
3465: IF p_header_rec.transactional_curr_code IS NULL THEN
3466: x_return_status := FND_API.G_RET_STS_ERROR;
3467: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
3468: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
3469: OE_Order_UTIL.Get_Attribute_Name('TRANSACTIONAL_CURR_CODE'));
3470: OE_MSG_PUB.Add;
3471: END IF;
3472:
3473: IF p_header_rec.start_date_active IS NULL THEN
3516: end if;
3517: x_return_status := FND_API.G_RET_STS_ERROR;
3518: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
3519: FND_MESSAGE.SET_TOKEN('ATTRIBUTE'
3520: , OE_Order_Util.Get_Attribute_Name('ship_to_org_id'));
3521: OE_MSG_PUB.Add;
3522: END IF;
3523:
3524: END IF; -- Ship to
3557: WHEN NO_DATA_FOUND THEN
3558: l_return_status := FND_API.G_RET_STS_ERROR;
3559: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
3560: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
3561: OE_Order_Util.Get_Attribute_Name('SOLD_TO_SITE_USE_ID'));
3562: OE_MSG_PUB.Add;
3563:
3564: WHEN OTHERS THEN
3565:
3594:
3595: x_return_status := FND_API.G_RET_STS_ERROR;
3596: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
3597: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
3598: OE_Order_Util.Get_Attribute_Name('deliver_to_org_id'));
3599: OE_MSG_PUB.Add;
3600: END IF;
3601:
3602: END if; -- Deliver to
3610: p_header_rec.sold_to_org_id )) THEN
3611: x_return_status := FND_API.G_RET_STS_ERROR;
3612: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
3613: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
3614: OE_Order_Util.Get_Attribute_Name('invoice_to_org_id'));
3615: OE_MSG_PUB.Add;
3616: END IF;
3617:
3618: END IF; -- Invoice to org
3636: WHEN NO_DATA_FOUND THEN
3637: x_return_status := FND_API.G_RET_STS_ERROR;
3638: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
3639: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
3640: OE_Order_Util.Get_Attribute_Name('SOLD_TO_CONTACT_ID'));
3641: OE_MSG_PUB.Add;
3642: WHEN OTHERS THEN
3643: IF OE_MSG_PUB.Check_Msg_Level ( OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3644: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME , 'Record - Sold To Contact');
3835: l_old_header_rec.header_id) THEN
3836: x_return_status := FND_API.G_RET_STS_ERROR;
3837: fnd_message.set_name('ONT', 'OE_BLKT_UPDATE_HDR_ATTRIBUTE');
3838: fnd_message.set_token('ATTRIBUTE',
3839: OE_Order_UTIL.Get_Attribute_Name('HEADER_ID'));
3840: OE_MSG_PUB.Add;
3841: END IF;
3842:
3843: IF NOT OE_GLOBALS.Equal (p_header_rec.order_number,
3844: l_old_header_rec.order_number) THEN
3845: x_return_status := FND_API.G_RET_STS_ERROR;
3846: fnd_message.set_name('ONT', 'OE_BLKT_UPDATE_HDR_ATTRIBUTE');
3847: fnd_message.set_token('ATTRIBUTE',
3848: OE_Order_UTIL.Get_Attribute_Name('BLANKET_NUMBER'));
3849: OE_MSG_PUB.Add;
3850: END IF;
3851:
3852: IF NOT OE_GLOBALS.Equal (p_header_rec.order_category_code,
3853: l_old_header_rec.order_category_code) THEN
3854: x_return_status := FND_API.G_RET_STS_ERROR;
3855: fnd_message.set_name('ONT', 'OE_BLKT_UPDATE_HDR_ATTRIBUTE');
3856: fnd_message.set_token('ATTRIBUTE',
3857: OE_Order_UTIL.Get_Attribute_Name('ORDER_CATEGORY_CODE'));
3858: OE_MSG_PUB.Add;
3859: END IF;
3860:
3861: IF NOT OE_GLOBALS.Equal (p_header_rec.org_id,
3862: l_old_header_rec.org_id) THEN
3863: x_return_status := FND_API.G_RET_STS_ERROR;
3864: fnd_message.set_name('ONT', 'OE_BLKT_UPDATE_HDR_ATTRIBUTE');
3865: fnd_message.set_token('ATTRIBUTE',
3866: OE_Order_UTIL.Get_Attribute_Name('ORG_ID'));
3867: OE_MSG_PUB.Add;
3868: END IF;
3869:
3870: --restricted from changing if releases exist
3873: l_old_header_rec.sold_to_org_id) THEN
3874: x_return_status := FND_API.G_RET_STS_ERROR;
3875: fnd_message.set_name('ONT', 'OE_BLKT_UPDATE_HDR_ATTRIBUTE');
3876: fnd_message.set_token('ATTRIBUTE',
3877: OE_Order_UTIL.Get_Attribute_Name('SOLD_TO_ORG_ID'));
3878: OE_MSG_PUB.Add;
3879: END IF;
3880:
3881: IF NOT OE_GLOBALS.Equal (p_header_rec.transactional_curr_code,
3882: l_old_header_rec.transactional_curr_code) THEN
3883: x_return_status := FND_API.G_RET_STS_ERROR;
3884: fnd_message.set_name('ONT', 'OE_BLKT_UPDATE_HDR_ATTRIBUTE');
3885: fnd_message.set_token('ATTRIBUTE',
3886: OE_Order_UTIL.Get_Attribute_Name('TRANSACTIONAL_CURR_CODE'));
3887: OE_MSG_PUB.Add;
3888: END IF;
3889:
3890: IF NOT OE_GLOBALS.Equal (p_header_rec.start_date_active,
9534: l_dummy := 'INVALID';
9535: x_return_status := FND_API.G_RET_STS_ERROR;
9536: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
9537: FND_MESSAGE.SET_TOKEN('ATTRIBUTE'
9538: , OE_Order_Util.Get_Attribute_Name('ship_to_org_id'));
9539: OE_MSG_PUB.Add;
9540: WHEN OTHERS THEN
9541: if l_debug_level > 0 then
9542: oe_debug_pub.add ('OE_blanket_util.validate_sold_to WOE Blanket In Ship No data found',2);
9567: l_dummy := 'INVALID';
9568: x_return_status := FND_API.G_RET_STS_ERROR;
9569: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
9570: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
9571: OE_Order_Util.Get_Attribute_Name('deliver_to_org_id'));
9572: OE_MSG_PUB.Add;
9573: WHEN OTHERS THEN
9574: if l_debug_level > 0 then
9575: oe_debug_pub.add ('OE_blanket_util.validate_sold_to WOE Blanket In Deliver No data found',2);
9597: l_dummy := 'INVALID';
9598: x_return_status := FND_API.G_RET_STS_ERROR;
9599: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
9600: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
9601: OE_Order_Util.Get_Attribute_Name('invoice_to_org_id'));
9602: OE_MSG_PUB.Add;
9603: WHEN OTHERS THEN
9604: if l_debug_level > 0 then
9605: oe_debug_pub.add ('OE_blanket_util.validate_sold_to WOE Blanket In Invoice No data found',2);