[Home] [Help]
2293: x_return_status := FND_API.G_RET_STS_ERROR;
2294:
2295: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
2296: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2297: OE_Order_UTIL.Get_Attribute_Name('line_id'));
2298: OE_MSG_PUB.Add;
2299:
2300: END IF;
2301:
2305: x_return_status := FND_API.G_RET_STS_ERROR;
2306:
2307: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
2308: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2309: OE_Order_UTIL.Get_Attribute_Name('ITEM_IDENTIFIER_TYPE'));
2310: OE_MSG_PUB.Add;
2311:
2312: ELSIF p_line_rec.item_identifier_type <> 'ALL'
2313: AND p_line_rec.inventory_item_id IS NULL
2316: x_return_status := FND_API.G_RET_STS_ERROR;
2317:
2318: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
2319: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2320: OE_Order_UTIL.Get_Attribute_Name('INVENTORY_ITEM_ID'));
2321: OE_MSG_PUB.Add;
2322:
2323: END IF;
2324:
2363: THEN
2364: x_return_status := FND_API.G_RET_STS_ERROR;
2365: FND_MESSAGE.Set_Name('ONT','OE_INVALID_ATTRIBUTE');
2366: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2367: OE_Order_Util.Get_Attribute_Name('ACCOUNTING_RULE_ID'));
2368: OE_MSG_PUB.ADD;
2369: END IF;
2370:
2371:
2381: --some fields not allowed to update if release exists against line
2382: IF (p_line_rec.released_amount > 0) THEN
2383: fnd_message.set_name('ONT', 'OE_BLKT_UPDATE_LINE_ATTRIBUTE');
2384: fnd_message.set_token('ATTRIBUTE',
2385: OE_Order_UTIL.Get_Attribute_Name('LINE_NUMBER'));
2386: OE_MSG_PUB.Add;
2387: ELSE
2388: oe_delayed_requests_pvt.Log_request(p_Entity_Code =>
2389: OE_BLANKET_pub.G_ENTITY_BLANKET_LINE,
2419: (p_line_rec.inventory_item_id,l_old_line_rec.inventory_item_id)) THEN
2420:
2421: fnd_message.set_name('ONT', 'OE_BLKT_UPDATE_LINE_ATTRIBUTE');
2422: fnd_message.set_token('ATTRIBUTE',
2423: OE_Order_UTIL.Get_Attribute_Name('INVENTORY_ITEM_ID'));
2424: OE_MSG_PUB.add;
2425: x_return_status := FND_API.G_RET_STS_ERROR;
2426:
2427: ELSIF (p_line_rec.released_amount > 0) AND
2428: (NOT OE_GLOBALS.Equal
2429: (p_line_rec.item_identifier_type,l_old_line_rec.item_identifier_type)) THEN
2430: fnd_message.set_name('ONT', 'OE_BLKT_UPDATE_LINE_ATTRIBUTE');
2431: fnd_message.set_token('ATTRIBUTE',
2432: OE_Order_UTIL.Get_Attribute_Name('ITEM_IDENTIFIER_TYPE'));
2433: OE_MSG_PUB.add;
2434: x_return_status := FND_API.G_RET_STS_ERROR;
2435:
2436: ELSE
2503: end if;
2504: x_return_status := FND_API.G_RET_STS_ERROR;
2505: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2506: FND_MESSAGE.SET_TOKEN('ATTRIBUTE'
2507: , OE_Order_Util.Get_Attribute_Name('ship_to_org_id'));
2508: OE_MSG_PUB.Add;
2509: END IF;
2510: END IF; -- Ship to
2511:
2523:
2524: x_return_status := FND_API.G_RET_STS_ERROR;
2525: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2526: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2527: OE_Order_Util.Get_Attribute_Name('deliver_to_org_id'));
2528: OE_MSG_PUB.Add;
2529: END IF;
2530:
2531: END IF; -- Deliver to
2540: p_line_rec.sold_to_org_id )) THEN
2541: x_return_status := FND_API.G_RET_STS_ERROR;
2542: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2543: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2544: OE_Order_Util.Get_Attribute_Name('invoice_to_org_id'));
2545: OE_MSG_PUB.Add;
2546: END IF;
2547: END IF; -- Invoice to org
2548:
2602: IF p_line_rec.order_quantity_uom IS NULL THEN
2603: IF (g_new_price_list AND (p_line_rec.pricing_uom IS NULL)) THEN
2604: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
2605: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2606: OE_Order_Util.Get_Attribute_Name('PRICING_QUANTITY_UOM'));
2607: OE_MSG_PUB.Add;
2608: ELSIF p_line_rec.price_list_id IS NOT NULL THEN
2609: IF IS_BLANKET_PRICE_LIST(p_price_list_id => p_line_rec.price_list_id)
2610: AND p_line_rec.pricing_uom IS NULL THEN
2609: IF IS_BLANKET_PRICE_LIST(p_price_list_id => p_line_rec.price_list_id)
2610: AND p_line_rec.pricing_uom IS NULL THEN
2611: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
2612: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2613: OE_Order_Util.Get_Attribute_Name('PRICING_QUANTITY_UOM'));
2614: OE_MSG_PUB.Add;
2615: END IF;
2616: END IF;
2617: END IF;
2620: p_line_rec.price_list_id IS NULL AND
2621: (p_line_rec.enforce_price_list_flag = 'Y') THEN
2622: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
2623: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2624: OE_Order_UTIL.Get_Attribute_Name('PRICE_LIST_ID'));
2625: OE_MSG_PUB.ADD;
2626: x_return_status := FND_API.G_RET_STS_ERROR;
2627: END IF;
2628:
2717: l_old_line_rec.order_quantity_uom) THEN
2718: x_return_status := FND_API.G_RET_STS_ERROR;
2719: fnd_message.set_name('ONT', 'OE_BLKT_UPDATE_LINE_ATTRIBUTE');
2720: fnd_message.set_token('ATTRIBUTE',
2721: OE_Order_UTIL.Get_Attribute_Name('ORDER_QUANTITY_UOM'));
2722: OE_MSG_PUB.Add;
2723: END IF;
2724: END IF;
2725:
2784: l_old_line_rec.pricing_uom) THEN
2785: if (g_new_price_list) THEN
2786: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_UPDATE_LINE_ATTRIBUTE');
2787: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2788: OE_Order_UTIL.Get_Attribute_Name('PRICING_QUANTITY_UOM'));
2789: OE_MSG_PUB.ADD;
2790: x_return_status := FND_API.G_RET_STS_ERROR;
2791: elsif p_line_rec.price_list_id IS NOT NULL THEN
2792: if IS_BLANKET_PRICE_LIST(p_price_list_id => p_line_rec.price_list_id) THEN
2792: if IS_BLANKET_PRICE_LIST(p_price_list_id => p_line_rec.price_list_id) THEN
2793: x_return_status := FND_API.G_RET_STS_ERROR;
2794: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_UPDATE_LINE_ATTRIBUTE');
2795: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2796: OE_Order_UTIL.Get_Attribute_Name('PRICING_QUANTITY_UOM'));
2797: OE_MSG_PUB.ADD;
2798: x_return_status := FND_API.G_RET_STS_ERROR;
2799: end if;
2800: end if;
3021: ELSIF p_line_rec.price_list_id IS NOT NULL THEN
3022: x_return_status := FND_API.G_RET_STS_ERROR;
3023: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
3024: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
3025: OE_Order_UTIL.Get_Attribute_Name('UNIT_LIST_PRICE'));
3026: OE_MSG_PUB.ADD;
3027: END IF;
3028:
3029: END IF; --if g_new_price_list
3248: IF p_header_rec.header_id IS NULL THEN
3249: x_return_status := FND_API.G_RET_STS_ERROR;
3250: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
3251: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
3252: OE_Order_UTIL.Get_Attribute_Name('header_id'));
3253: OE_MSG_PUB.Add;
3254: END IF;
3255:
3256: IF p_header_rec.order_number IS NULL THEN
3256: IF p_header_rec.order_number IS NULL THEN
3257: x_return_status := FND_API.G_RET_STS_ERROR;
3258: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
3259: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
3260: OE_Order_UTIL.Get_Attribute_Name('BLANKET_NUMBER'));
3261: OE_MSG_PUB.Add;
3262: END IF;
3263: --Enabling Pricing Agreements for pack J
3264: IF OE_CODE_CONTROL.Get_Code_Release_Level < '110510' THEN
3265: IF p_header_rec.sold_to_org_id IS NULL THEN
3266: x_return_status := FND_API.G_RET_STS_ERROR;
3267: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
3268: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
3269: OE_Order_UTIL.Get_Attribute_Name('SOLD_TO_ORG_ID'));
3270: OE_MSG_PUB.Add;
3271: END IF;
3272: END IF;
3273:
3274: IF p_header_rec.transactional_curr_code IS NULL THEN
3275: x_return_status := FND_API.G_RET_STS_ERROR;
3276: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
3277: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
3278: OE_Order_UTIL.Get_Attribute_Name('TRANSACTIONAL_CURR_CODE'));
3279: OE_MSG_PUB.Add;
3280: END IF;
3281:
3282: IF p_header_rec.start_date_active IS NULL THEN
3325: end if;
3326: x_return_status := FND_API.G_RET_STS_ERROR;
3327: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
3328: FND_MESSAGE.SET_TOKEN('ATTRIBUTE'
3329: , OE_Order_Util.Get_Attribute_Name('ship_to_org_id'));
3330: OE_MSG_PUB.Add;
3331: END IF;
3332:
3333: END IF; -- Ship to
3366: WHEN NO_DATA_FOUND THEN
3367: l_return_status := FND_API.G_RET_STS_ERROR;
3368: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
3369: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
3370: OE_Order_Util.Get_Attribute_Name('SOLD_TO_SITE_USE_ID'));
3371: OE_MSG_PUB.Add;
3372:
3373: WHEN OTHERS THEN
3374:
3403:
3404: x_return_status := FND_API.G_RET_STS_ERROR;
3405: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
3406: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
3407: OE_Order_Util.Get_Attribute_Name('deliver_to_org_id'));
3408: OE_MSG_PUB.Add;
3409: END IF;
3410:
3411: END if; -- Deliver to
3419: p_header_rec.sold_to_org_id )) THEN
3420: x_return_status := FND_API.G_RET_STS_ERROR;
3421: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
3422: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
3423: OE_Order_Util.Get_Attribute_Name('invoice_to_org_id'));
3424: OE_MSG_PUB.Add;
3425: END IF;
3426:
3427: END IF; -- Invoice to org
3445: WHEN NO_DATA_FOUND THEN
3446: x_return_status := FND_API.G_RET_STS_ERROR;
3447: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
3448: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
3449: OE_Order_Util.Get_Attribute_Name('SOLD_TO_CONTACT_ID'));
3450: OE_MSG_PUB.Add;
3451: WHEN OTHERS THEN
3452: IF OE_MSG_PUB.Check_Msg_Level ( OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3453: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME , 'Record - Sold To Contact');
3644: l_old_header_rec.header_id) THEN
3645: x_return_status := FND_API.G_RET_STS_ERROR;
3646: fnd_message.set_name('ONT', 'OE_BLKT_UPDATE_HDR_ATTRIBUTE');
3647: fnd_message.set_token('ATTRIBUTE',
3648: OE_Order_UTIL.Get_Attribute_Name('HEADER_ID'));
3649: OE_MSG_PUB.Add;
3650: END IF;
3651:
3652: IF NOT OE_GLOBALS.Equal (p_header_rec.order_number,
3653: l_old_header_rec.order_number) THEN
3654: x_return_status := FND_API.G_RET_STS_ERROR;
3655: fnd_message.set_name('ONT', 'OE_BLKT_UPDATE_HDR_ATTRIBUTE');
3656: fnd_message.set_token('ATTRIBUTE',
3657: OE_Order_UTIL.Get_Attribute_Name('BLANKET_NUMBER'));
3658: OE_MSG_PUB.Add;
3659: END IF;
3660:
3661: IF NOT OE_GLOBALS.Equal (p_header_rec.order_category_code,
3662: l_old_header_rec.order_category_code) THEN
3663: x_return_status := FND_API.G_RET_STS_ERROR;
3664: fnd_message.set_name('ONT', 'OE_BLKT_UPDATE_HDR_ATTRIBUTE');
3665: fnd_message.set_token('ATTRIBUTE',
3666: OE_Order_UTIL.Get_Attribute_Name('ORDER_CATEGORY_CODE'));
3667: OE_MSG_PUB.Add;
3668: END IF;
3669:
3670: IF NOT OE_GLOBALS.Equal (p_header_rec.org_id,
3671: l_old_header_rec.org_id) THEN
3672: x_return_status := FND_API.G_RET_STS_ERROR;
3673: fnd_message.set_name('ONT', 'OE_BLKT_UPDATE_HDR_ATTRIBUTE');
3674: fnd_message.set_token('ATTRIBUTE',
3675: OE_Order_UTIL.Get_Attribute_Name('ORG_ID'));
3676: OE_MSG_PUB.Add;
3677: END IF;
3678:
3679: --restricted from changing if releases exist
3682: l_old_header_rec.sold_to_org_id) THEN
3683: x_return_status := FND_API.G_RET_STS_ERROR;
3684: fnd_message.set_name('ONT', 'OE_BLKT_UPDATE_HDR_ATTRIBUTE');
3685: fnd_message.set_token('ATTRIBUTE',
3686: OE_Order_UTIL.Get_Attribute_Name('SOLD_TO_ORG_ID'));
3687: OE_MSG_PUB.Add;
3688: END IF;
3689:
3690: IF NOT OE_GLOBALS.Equal (p_header_rec.transactional_curr_code,
3691: l_old_header_rec.transactional_curr_code) THEN
3692: x_return_status := FND_API.G_RET_STS_ERROR;
3693: fnd_message.set_name('ONT', 'OE_BLKT_UPDATE_HDR_ATTRIBUTE');
3694: fnd_message.set_token('ATTRIBUTE',
3695: OE_Order_UTIL.Get_Attribute_Name('TRANSACTIONAL_CURR_CODE'));
3696: OE_MSG_PUB.Add;
3697: END IF;
3698:
3699: IF NOT OE_GLOBALS.Equal (p_header_rec.start_date_active,
9337: l_dummy := 'INVALID';
9338: x_return_status := FND_API.G_RET_STS_ERROR;
9339: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
9340: FND_MESSAGE.SET_TOKEN('ATTRIBUTE'
9341: , OE_Order_Util.Get_Attribute_Name('ship_to_org_id'));
9342: OE_MSG_PUB.Add;
9343: WHEN OTHERS THEN
9344: if l_debug_level > 0 then
9345: oe_debug_pub.add ('OE_blanket_util.validate_sold_to WOE Blanket In Ship No data found',2);
9370: l_dummy := 'INVALID';
9371: x_return_status := FND_API.G_RET_STS_ERROR;
9372: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
9373: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
9374: OE_Order_Util.Get_Attribute_Name('deliver_to_org_id'));
9375: OE_MSG_PUB.Add;
9376: WHEN OTHERS THEN
9377: if l_debug_level > 0 then
9378: oe_debug_pub.add ('OE_blanket_util.validate_sold_to WOE Blanket In Deliver No data found',2);
9400: l_dummy := 'INVALID';
9401: x_return_status := FND_API.G_RET_STS_ERROR;
9402: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
9403: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
9404: OE_Order_Util.Get_Attribute_Name('invoice_to_org_id'));
9405: OE_MSG_PUB.Add;
9406: WHEN OTHERS THEN
9407: if l_debug_level > 0 then
9408: oe_debug_pub.add ('OE_blanket_util.validate_sold_to WOE Blanket In Invoice No data found',2);