[Home] [Help]
1669:
1670: -- Show Error message if appropriate context value is not passed
1671: -- from the Process Order Call and if the Context field is required.
1672:
1673: FND_MESSAGE.SET_NAME('FND', 'ONT_BLKT_CONTEXT_NOT_FOUND');
1674:
1675: OE_MSG_PUB.ADD;
1676: IF l_debug_level > 0 THEN
1677: oe_debug_pub.add( 'Context not set for OE_BLKT_LINE_ATTRIBUTES DFF ' ) ;
2291: THEN
2292:
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:
2292:
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;
2303: THEN
2304:
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:
2304:
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'
2314: THEN
2315:
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:
2315:
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;
2326: THEN
2327:
2328: x_return_status := FND_API.G_RET_STS_ERROR;
2329:
2330: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
2331: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Activation Date');
2332: OE_MSG_PUB.Add;
2333:
2334: END IF;
2327:
2328: x_return_status := FND_API.G_RET_STS_ERROR;
2329:
2330: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
2331: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Activation Date');
2332: OE_MSG_PUB.Add;
2333:
2334: END IF;
2335:
2361: (p_line_rec.inventory_item_id,
2362: p_line_rec.accounting_rule_id)
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;
2362: p_line_rec.accounting_rule_id)
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:
2379: (p_line_rec.line_number,l_old_line_rec.line_number)
2380: THEN
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
2380: THEN
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 =>
2417: IF (p_line_rec.released_amount > 0) AND
2418: (NOT OE_GLOBALS.Equal
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;
2418: (NOT OE_GLOBALS.Equal
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:
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;
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:
2439: IF p_line_rec.item_identifier_type = 'ALL' THEN
2440:
2441: IF p_line_rec.inventory_item_id IS NOT NULL THEN
2442: x_return_status := FND_API.G_RET_STS_ERROR;
2443: fnd_message.set_name('ONT', 'OE_ITEM_VALIDATION_FAILED');
2444: OE_MSG_PUB.add;
2445: END IF;
2446:
2447: -- For all other context values, validate item id
2454: p_line_rec.ordered_item_id,
2455: p_line_rec.ordered_item
2456: ) THEN
2457: x_return_status := FND_API.G_RET_STS_ERROR;
2458: fnd_message.set_name('ONT', 'OE_ITEM_VALIDATION_FAILED');
2459: OE_MSG_PUB.add;
2460: END IF;
2461:
2462: END IF;
2501: if l_debug_level > 0 then
2502: oe_debug_pub.add ('Blanket In: No data found',2);
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;
2502: oe_debug_pub.add ('Blanket In: No data found',2);
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
2521: IF NOT (Validate_Deliver_To_Org(p_line_rec.deliver_to_org_id,
2522: p_line_rec.sold_to_org_id )) THEN
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;
2522: p_line_rec.sold_to_org_id )) THEN
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:
2538: -- ER 5743580
2539: IF NOT ( Validate_Invoice_To_Org ( p_line_rec.invoice_to_org_id,
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;
2539: IF NOT ( Validate_Invoice_To_Org ( p_line_rec.invoice_to_org_id,
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
2557: > (p_line_rec.end_date_active)) THEN
2558: if ( nvl(p_line_rec.source_document_type_id,0) = 2 --bug#5528507
2559: AND p_line_rec.operation = OE_GLOBALS.G_OPR_CREATE)
2560: then
2561: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_DATE_RANGE');
2562: OE_MSG_PUB.ADD;
2563: oe_debug_pub.add('1: Not Setting Error',1);
2564:
2565: else
2562: OE_MSG_PUB.ADD;
2563: oe_debug_pub.add('1: Not Setting Error',1);
2564:
2565: else
2566: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_DATE_RANGE');
2567: OE_MSG_PUB.ADD;
2568: oe_debug_pub.add('1: Setting Error',1);
2569: x_return_status := FND_API.G_RET_STS_ERROR;
2570: end if;
2573:
2574: --line start date must be after header date range
2575: if (p_line_rec.start_date_active < g_header_rec.start_date_active)
2576: then
2577: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_END_DATE_CONFLICT');
2578: OE_MSG_PUB.ADD;
2579: x_return_status := FND_API.G_RET_STS_ERROR;
2580: end if;
2581:
2585: if p_line_rec.end_date_active is NULL
2586: or (p_line_rec.end_date_active
2587: > g_header_rec.end_date_active)
2588: then
2589: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_END_DATE_CONFLICT');
2590: OE_MSG_PUB.ADD;
2591: x_return_status := FND_API.G_RET_STS_ERROR;
2592: end if;
2593: end if;
2600: -- pricing uom is required if it is a blanket price list
2601: -- and ordered UOM is null
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
2601: -- and ordered UOM is null
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)
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
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;
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
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;
2618:
2619: IF NOT g_new_price_list AND
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;
2619: IF NOT g_new_price_list AND
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;
2631: (p_line_rec.Blanket_Min_Quantity IS NOT NULL
2632: OR p_line_rec.Blanket_Max_Quantity IS NOT NULL
2633: OR p_line_rec.Min_Release_Quantity IS NOT NULL
2634: OR p_line_rec.Max_Release_Quantity IS NOT NULL) THEN
2635: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_QUANTITY_UOM');
2636: OE_MSG_PUB.ADD;
2637: x_return_status := FND_API.G_RET_STS_ERROR;
2638:
2639: END IF;
2652: p_line_rec.blanket_max_amount,
2653: 'BLANKET_LINE_AMOUNT', x_return_status);
2654: /*
2655: IF p_line_rec.blanket_max_amount > g_header_rec.blanket_max_amount THEN
2656: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_LINE_MIN_MAX_VALUES');
2657: OE_MSG_PUB.ADD;
2658: x_return_status := FND_API.G_RET_STS_ERROR;
2659: END IF;
2660: */
2659: END IF;
2660: */
2661: IF p_line_rec.min_release_amount > p_line_rec.blanket_max_amount OR
2662: p_line_rec.max_release_amount > p_line_rec.blanket_max_amount THEN
2663: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_LINE_MAX_AMOUNT');
2664: OE_MSG_PUB.ADD;
2665: x_return_status := FND_API.G_RET_STS_ERROR;
2666:
2667: END IF;
2667: END IF;
2668:
2669: IF p_line_rec.min_release_quantity > p_line_rec.blanket_max_quantity OR
2670: p_line_rec.max_release_quantity > p_line_rec.blanket_max_quantity THEN
2671: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_LINE_MAX_QUANTITY');
2672: OE_MSG_PUB.ADD;
2673: x_return_status := FND_API.G_RET_STS_ERROR;
2674:
2675: END IF;
2683: --not allowed to change any attributes on a previously closed blanket
2684: IF p_line_rec.end_date_active < trunc(sysdate) and
2685: l_old_line_rec.end_date_active < trunc(sysdate) THEN
2686: x_return_status := FND_API.G_RET_STS_ERROR;
2687: fnd_message.set_name('ONT', 'OE_BLKT_UPDATE_ATTR_CLOSED');
2688: OE_MSG_PUB.Add;
2689: END IF;
2690: --Srini
2691: --oe_blanket_util.Get_Inventory_Item(p_x_line_rec => p_line_rec,
2695: IF NOT OE_GLOBALS.Equal(p_line_rec.end_date_active, l_old_line_rec.end_date_active) AND
2696: p_line_rec.end_date_active <= trunc(sysdate) AND
2697: p_line_rec.override_blanket_controls_flag = 'N' THEN
2698: IF nvl(p_line_rec.released_amount,0) < p_line_rec.blanket_min_amount THEN
2699: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_CLOSE_MIN_VALUES');
2700: OE_MSG_PUB.ADD;
2701: if l_debug_level > 0 then
2702: oe_debug_pub.add('Blanket line close min amount ');
2703: end if;
2702: oe_debug_pub.add('Blanket line close min amount ');
2703: end if;
2704:
2705: ELSIF nvl(p_line_rec.released_quantity,0) < p_line_rec.blanket_min_quantity THEN
2706: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_CLOSE_MIN_VALUES');
2707: OE_MSG_PUB.ADD;
2708: if l_debug_level > 0 then
2709: oe_debug_pub.add('Blanket line close min quantity ');
2710: end if;
2715: IF (p_line_rec.released_amount > 0) THEN
2716: IF NOT OE_GLOBALS.Equal (p_line_rec.order_quantity_uom,
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;
2716: IF NOT OE_GLOBALS.Equal (p_line_rec.order_quantity_uom,
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;
2758: AND ROWNUM = 1;
2759:
2760: IF l_dummy = 'ERROR' THEN
2761: x_return_status := FND_API.G_RET_STS_ERROR;
2762: fnd_message.set_name('ONT', 'OE_BLKT_LINE_RELEASE_END_DATE');
2763: OE_MSG_PUB.Add;
2764: END IF;
2765:
2766: EXCEPTION
2782: --pricing uom not allowed to change if blanket price list
2783: if NOT OE_GLOBALS.EQUAL(p_line_rec.pricing_uom,
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;
2783: if NOT OE_GLOBALS.EQUAL(p_line_rec.pricing_uom,
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
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
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;
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
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;
2805: oe_debug_pub.add('Blanket In validate entity update 1');
2806: end if;
2807: if NOT OE_GLOBALS.EQUAL(p_line_rec.released_amount,
2808: l_old_line_rec.released_amount) THEN
2809: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_UPDATE_LINE_ATTRIBUTE');
2810: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Released Amount');
2811: OE_MSG_PUB.ADD;
2812: x_return_status := FND_API.G_RET_STS_ERROR;
2813: end if;
2806: end if;
2807: if NOT OE_GLOBALS.EQUAL(p_line_rec.released_amount,
2808: l_old_line_rec.released_amount) THEN
2809: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_UPDATE_LINE_ATTRIBUTE');
2810: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Released Amount');
2811: OE_MSG_PUB.ADD;
2812: x_return_status := FND_API.G_RET_STS_ERROR;
2813: end if;
2814:
2813: end if;
2814:
2815: if NOT OE_GLOBALS.EQUAL(p_line_rec.returned_amount,
2816: l_old_line_rec.returned_amount) THEN
2817: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_UPDATE_LINE_ATTRIBUTE');
2818: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Returned Amount');
2819: OE_MSG_PUB.ADD;
2820: x_return_status := FND_API.G_RET_STS_ERROR;
2821: end if;
2814:
2815: if NOT OE_GLOBALS.EQUAL(p_line_rec.returned_amount,
2816: l_old_line_rec.returned_amount) THEN
2817: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_UPDATE_LINE_ATTRIBUTE');
2818: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Returned Amount');
2819: OE_MSG_PUB.ADD;
2820: x_return_status := FND_API.G_RET_STS_ERROR;
2821: end if;
2822:
2821: end if;
2822:
2823: if NOT OE_GLOBALS.EQUAL(p_line_rec.released_quantity,
2824: l_old_line_rec.released_quantity) THEN
2825: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_UPDATE_LINE_ATTRIBUTE');
2826: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Released Quantity');
2827: OE_MSG_PUB.ADD;
2828: x_return_status := FND_API.G_RET_STS_ERROR;
2829: end if;
2822:
2823: if NOT OE_GLOBALS.EQUAL(p_line_rec.released_quantity,
2824: l_old_line_rec.released_quantity) THEN
2825: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_UPDATE_LINE_ATTRIBUTE');
2826: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Released Quantity');
2827: OE_MSG_PUB.ADD;
2828: x_return_status := FND_API.G_RET_STS_ERROR;
2829: end if;
2830:
2829: end if;
2830:
2831: if NOT OE_GLOBALS.EQUAL(p_line_rec.fulfilled_quantity,
2832: l_old_line_rec.fulfilled_quantity) THEN
2833: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_UPDATE_LINE_ATTRIBUTE');
2834: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Fulfilled Quantity');
2835: OE_MSG_PUB.ADD;
2836: x_return_status := FND_API.G_RET_STS_ERROR;
2837: end if;
2830:
2831: if NOT OE_GLOBALS.EQUAL(p_line_rec.fulfilled_quantity,
2832: l_old_line_rec.fulfilled_quantity) THEN
2833: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_UPDATE_LINE_ATTRIBUTE');
2834: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Fulfilled Quantity');
2835: OE_MSG_PUB.ADD;
2836: x_return_status := FND_API.G_RET_STS_ERROR;
2837: end if;
2838:
2837: end if;
2838:
2839: if NOT OE_GLOBALS.EQUAL(p_line_rec.fulfilled_amount,
2840: l_old_line_rec.fulfilled_amount) THEN
2841: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_UPDATE_LINE_ATTRIBUTE');
2842: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Fulfilled Amount');
2843: OE_MSG_PUB.ADD;
2844: x_return_status := FND_API.G_RET_STS_ERROR;
2845: end if;
2838:
2839: if NOT OE_GLOBALS.EQUAL(p_line_rec.fulfilled_amount,
2840: l_old_line_rec.fulfilled_amount) THEN
2841: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_UPDATE_LINE_ATTRIBUTE');
2842: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Fulfilled Amount');
2843: OE_MSG_PUB.ADD;
2844: x_return_status := FND_API.G_RET_STS_ERROR;
2845: end if;
2846:
2845: end if;
2846:
2847: if NOT OE_GLOBALS.EQUAL(p_line_rec.returned_quantity,
2848: l_old_line_rec.returned_quantity) THEN
2849: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_UPDATE_LINE_ATTRIBUTE');
2850: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Returned Quantity');
2851: OE_MSG_PUB.ADD;
2852: x_return_status := FND_API.G_RET_STS_ERROR;
2853: end if;
2846:
2847: if NOT OE_GLOBALS.EQUAL(p_line_rec.returned_quantity,
2848: l_old_line_rec.returned_quantity) THEN
2849: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_UPDATE_LINE_ATTRIBUTE');
2850: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Returned Quantity');
2851: OE_MSG_PUB.ADD;
2852: x_return_status := FND_API.G_RET_STS_ERROR;
2853: end if;
2854: if l_debug_level > 0 then
2872:
2873: if ( nvl(p_line_rec.source_document_type_id,0) = 2 --bug#5528507
2874: AND p_line_rec.operation = OE_GLOBALS.G_OPR_CREATE)
2875: then
2876: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_DATE_RANGE');
2877: OE_MSG_PUB.ADD;
2878: oe_debug_pub.add('2: Not Setting Error',1);
2879:
2880: else
2877: OE_MSG_PUB.ADD;
2878: oe_debug_pub.add('2: Not Setting Error',1);
2879:
2880: else
2881: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_DATE_RANGE');
2882: OE_MSG_PUB.ADD;
2883: x_return_status := FND_API.G_RET_STS_ERROR;
2884: oe_debug_pub.add('2: Setting Error',1);
2885: end if;
3019: END IF; -- if list price changes
3020:
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;
3020:
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:
3068:
3069: IF p_line_rec.modifier_list_line_id IS NOT NULL
3070: THEN
3071: oe_debug_pub.add('modifier list line id is not null');
3072: fnd_message.set_name('ONT','OE_BLKT_CANNOT_UPDATE_DIS');
3073: oe_msg_pub.add;
3074: x_return_status := FND_API.G_RET_STS_ERROR;
3075: ELSIF g_header_rec.new_modifier_list_name IS NULL
3076: AND g_header_rec.new_modifier_list_id IS NULL
3074: x_return_status := FND_API.G_RET_STS_ERROR;
3075: ELSIF g_header_rec.new_modifier_list_name IS NULL
3076: AND g_header_rec.new_modifier_list_id IS NULL
3077: THEN
3078: fnd_message.set_name('ONT','OE_BLKT_CANNOT_ENTER_DIS');
3079: oe_msg_pub.add;
3080: x_return_status := FND_API.G_RET_STS_ERROR;
3081: ELSIF p_line_rec.discount_percent IS NOT NULL
3082: AND p_line_rec.discount_amount IS NOT NULL
3080: x_return_status := FND_API.G_RET_STS_ERROR;
3081: ELSIF p_line_rec.discount_percent IS NOT NULL
3082: AND p_line_rec.discount_amount IS NOT NULL
3083: THEN
3084: fnd_message.set_name('ONT','OE_BLKT_DISCOUNT_CONFLICT');
3085: oe_msg_pub.add;
3086: x_return_status := FND_API.G_RET_STS_ERROR;
3087: ELSE
3088: -- Log delayed request to create new modifier list line
3246:
3247: -- Check Required attributes
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;
3247: -- Check Required attributes
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:
3254: END IF;
3255:
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;
3255:
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
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;
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;
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;
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:
3280: END IF;
3281:
3282: IF p_header_rec.start_date_active IS NULL THEN
3283: x_return_status := FND_API.G_RET_STS_ERROR;
3284: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
3285: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Activation Date');
3286: OE_MSG_PUB.Add;
3287: END IF;
3288:
3281:
3282: IF p_header_rec.start_date_active IS NULL THEN
3283: x_return_status := FND_API.G_RET_STS_ERROR;
3284: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
3285: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Activation Date');
3286: OE_MSG_PUB.Add;
3287: END IF;
3288:
3289: ---------------------------------------------------------------------
3298:
3299: if ( nvl(p_header_rec.source_document_type_id,0) = 2) --bug#5528507
3300: AND p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3301: then
3302: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_DATE_RANGE');
3303: OE_MSG_PUB.ADD;
3304: oe_debug_pub.add('3: Not Setting Error',1);
3305:
3306: else
3303: OE_MSG_PUB.ADD;
3304: oe_debug_pub.add('3: Not Setting Error',1);
3305:
3306: else
3307: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_DATE_RANGE');
3308: OE_MSG_PUB.ADD;
3309: x_return_status := FND_API.G_RET_STS_ERROR;
3310: oe_debug_pub.add('3: Setting Error',1);
3311: end if;
3323: if l_debug_level > 0 then
3324: oe_debug_pub.add ('Blanket In: No data found',2);
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;
3324: oe_debug_pub.add ('Blanket In: No data found',2);
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:
3364: EXCEPTION
3365:
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:
3365:
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
3401: IF NOT (Validate_Deliver_To_Org(p_header_rec.deliver_to_org_id,
3402: p_header_rec.sold_to_org_id )) THEN
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;
3402: p_header_rec.sold_to_org_id )) THEN
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:
3417: -- ER 5743580
3418: IF NOT ( Validate_Invoice_To_Org ( p_header_rec.invoice_to_org_id,
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;
3418: IF NOT ( Validate_Invoice_To_Org ( p_header_rec.invoice_to_org_id,
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:
3443: -- Valid Sold To Contact
3444: EXCEPTION
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
3444: EXCEPTION
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
3458:
3459: if p_header_rec.start_date_active is not NULL and
3460: p_header_rec.end_date_active is not NULL and
3461: p_header_rec.start_date_active > p_header_rec.end_date_active then
3462: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_DATE_RANGE');
3463: OE_MSG_PUB.ADD;
3464: x_return_status := FND_API.G_RET_STS_ERROR;
3465: end if;
3466:
3515: p_old_header_rec.new_price_list_id)
3516: THEN
3517:
3518: -- Cannot enter ID for a new price list, only name
3519: fnd_message.set_name('ONT','OE_BLKT_CANT_ENTER_NEW_PL_ID');
3520: oe_msg_pub.add;
3521: x_return_status := FND_API.G_RET_STS_ERROR;
3522:
3523: ELSIF p_header_rec.new_price_list_name IS NOT NULL
3537: FROM qp_list_headers_vl
3538: WHERE name = p_header_rec.new_price_list_name
3539: AND rownum = 1;
3540:
3541: fnd_message.set_name('ONT','OE_BLKT_PRICE_LIST_EXISTS');
3542: oe_msg_pub.add;
3543: x_return_status := FND_API.G_RET_STS_ERROR;
3544:
3545: EXCEPTION
3553: p_old_header_rec.new_modifier_list_id)
3554: THEN
3555:
3556: -- Cannot enter ID for a new modifier list, only name
3557: fnd_message.set_name('ONT','OE_BLKT_CANT_ENTER_MOD_LIST_ID');
3558: oe_msg_pub.add;
3559: x_return_status := FND_API.G_RET_STS_ERROR;
3560:
3561: ELSIF p_header_rec.new_modifier_list_name IS NOT NULL
3577: FROM qp_list_headers_vl
3578: WHERE name = p_header_rec.new_modifier_list_name
3579: AND rownum = 1;
3580:
3581: fnd_message.set_name('ONT','OE_BLKT_MOD_LIST_EXISTS');
3582: oe_msg_pub.add;
3583: x_return_status := FND_API.G_RET_STS_ERROR;
3584:
3585: EXCEPTION
3622: --not allowed to change any attributes on a previously closed blanket
3623: IF p_header_rec.end_date_active < trunc(sysdate) and
3624: l_old_header_rec.end_date_active < trunc(sysdate) THEN
3625: x_return_status := FND_API.G_RET_STS_ERROR;
3626: fnd_message.set_name('ONT', 'OE_BLKT_UPDATE_ATTR_CLOSED');
3627: OE_MSG_PUB.Add;
3628: END IF;
3629:
3630:
3634: nvl(p_header_rec.released_amount,0) < p_header_rec.blanket_min_amount THEN
3635: if l_debug_level > 0 then
3636: oe_debug_pub.add('Blanket header close min amount ');
3637: end if;
3638: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_CLOSE_MIN_VALUES');
3639: OE_MSG_PUB.ADD;
3640: END IF;
3641:
3642:
3642:
3643: IF NOT OE_GLOBALS.Equal (p_header_rec.header_id,
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;
3643: IF NOT OE_GLOBALS.Equal (p_header_rec.header_id,
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:
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;
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:
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;
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:
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;
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:
3680: IF p_header_rec.released_amount > 0 THEN
3681: IF NOT OE_GLOBALS.Equal (p_header_rec.sold_to_org_id,
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;
3681: IF NOT OE_GLOBALS.Equal (p_header_rec.sold_to_org_id,
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:
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;
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:
3698:
3699: IF NOT OE_GLOBALS.Equal (p_header_rec.start_date_active,
3700: l_old_header_rec.start_date_active) THEN
3701: x_return_status := FND_API.G_RET_STS_ERROR;
3702: fnd_message.set_name('ONT', 'OE_BLKT_UPDATE_HDR_ATTRIBUTE');
3703: fnd_message.set_token('ATTRIBUTE','Activation Date');
3704: OE_MSG_PUB.Add;
3705: END IF;
3706: END IF; --if releases exist
3699: IF NOT OE_GLOBALS.Equal (p_header_rec.start_date_active,
3700: l_old_header_rec.start_date_active) THEN
3701: x_return_status := FND_API.G_RET_STS_ERROR;
3702: fnd_message.set_name('ONT', 'OE_BLKT_UPDATE_HDR_ATTRIBUTE');
3703: fnd_message.set_token('ATTRIBUTE','Activation Date');
3704: OE_MSG_PUB.Add;
3705: END IF;
3706: END IF; --if releases exist
3707:
3707:
3708: IF NOT OE_GLOBALS.Equal (p_header_rec.released_amount,
3709: l_old_header_rec.released_amount) THEN
3710: x_return_status := FND_API.G_RET_STS_ERROR;
3711: fnd_message.set_name('ONT', 'OE_BLKT_UPDATE_HDR_ATTRIBUTE');
3712: fnd_message.set_token('ATTRIBUTE','Released Amount');
3713: OE_MSG_PUB.Add;
3714: END IF;
3715:
3708: IF NOT OE_GLOBALS.Equal (p_header_rec.released_amount,
3709: l_old_header_rec.released_amount) THEN
3710: x_return_status := FND_API.G_RET_STS_ERROR;
3711: fnd_message.set_name('ONT', 'OE_BLKT_UPDATE_HDR_ATTRIBUTE');
3712: fnd_message.set_token('ATTRIBUTE','Released Amount');
3713: OE_MSG_PUB.Add;
3714: END IF;
3715:
3716: IF NOT OE_GLOBALS.Equal (p_header_rec.returned_amount,
3715:
3716: IF NOT OE_GLOBALS.Equal (p_header_rec.returned_amount,
3717: l_old_header_rec.returned_amount) THEN
3718: x_return_status := FND_API.G_RET_STS_ERROR;
3719: fnd_message.set_name('ONT', 'OE_BLKT_UPDATE_HDR_ATTRIBUTE');
3720: fnd_message.set_token('ATTRIBUTE', 'Returned Amount');
3721: fnd_message.set_token('new amount', p_header_rec.returned_amount);
3722: fnd_message.set_token('old amount', l_old_header_rec.returned_amount);
3723: OE_MSG_PUB.Add;
3716: IF NOT OE_GLOBALS.Equal (p_header_rec.returned_amount,
3717: l_old_header_rec.returned_amount) THEN
3718: x_return_status := FND_API.G_RET_STS_ERROR;
3719: fnd_message.set_name('ONT', 'OE_BLKT_UPDATE_HDR_ATTRIBUTE');
3720: fnd_message.set_token('ATTRIBUTE', 'Returned Amount');
3721: fnd_message.set_token('new amount', p_header_rec.returned_amount);
3722: fnd_message.set_token('old amount', l_old_header_rec.returned_amount);
3723: OE_MSG_PUB.Add;
3724: END IF;
3717: l_old_header_rec.returned_amount) THEN
3718: x_return_status := FND_API.G_RET_STS_ERROR;
3719: fnd_message.set_name('ONT', 'OE_BLKT_UPDATE_HDR_ATTRIBUTE');
3720: fnd_message.set_token('ATTRIBUTE', 'Returned Amount');
3721: fnd_message.set_token('new amount', p_header_rec.returned_amount);
3722: fnd_message.set_token('old amount', l_old_header_rec.returned_amount);
3723: OE_MSG_PUB.Add;
3724: END IF;
3725:
3718: x_return_status := FND_API.G_RET_STS_ERROR;
3719: fnd_message.set_name('ONT', 'OE_BLKT_UPDATE_HDR_ATTRIBUTE');
3720: fnd_message.set_token('ATTRIBUTE', 'Returned Amount');
3721: fnd_message.set_token('new amount', p_header_rec.returned_amount);
3722: fnd_message.set_token('old amount', l_old_header_rec.returned_amount);
3723: OE_MSG_PUB.Add;
3724: END IF;
3725:
3726: IF NOT OE_GLOBALS.Equal (p_header_rec.fulfilled_amount,
3725:
3726: IF NOT OE_GLOBALS.Equal (p_header_rec.fulfilled_amount,
3727: l_old_header_rec.fulfilled_amount) THEN
3728: x_return_status := FND_API.G_RET_STS_ERROR;
3729: fnd_message.set_name('ONT', 'OE_BLKT_UPDATE_HDR_ATTRIBUTE');
3730: fnd_message.set_token('ATTRIBUTE','Fulfilled Amount');
3731: fnd_message.set_token('new amount', p_header_rec.fulfilled_amount);
3732: fnd_message.set_token('old amount', l_old_header_rec.fulfilled_amount);
3733: OE_MSG_PUB.Add;
3726: IF NOT OE_GLOBALS.Equal (p_header_rec.fulfilled_amount,
3727: l_old_header_rec.fulfilled_amount) THEN
3728: x_return_status := FND_API.G_RET_STS_ERROR;
3729: fnd_message.set_name('ONT', 'OE_BLKT_UPDATE_HDR_ATTRIBUTE');
3730: fnd_message.set_token('ATTRIBUTE','Fulfilled Amount');
3731: fnd_message.set_token('new amount', p_header_rec.fulfilled_amount);
3732: fnd_message.set_token('old amount', l_old_header_rec.fulfilled_amount);
3733: OE_MSG_PUB.Add;
3734: END IF;
3727: l_old_header_rec.fulfilled_amount) THEN
3728: x_return_status := FND_API.G_RET_STS_ERROR;
3729: fnd_message.set_name('ONT', 'OE_BLKT_UPDATE_HDR_ATTRIBUTE');
3730: fnd_message.set_token('ATTRIBUTE','Fulfilled Amount');
3731: fnd_message.set_token('new amount', p_header_rec.fulfilled_amount);
3732: fnd_message.set_token('old amount', l_old_header_rec.fulfilled_amount);
3733: OE_MSG_PUB.Add;
3734: END IF;
3735:
3728: x_return_status := FND_API.G_RET_STS_ERROR;
3729: fnd_message.set_name('ONT', 'OE_BLKT_UPDATE_HDR_ATTRIBUTE');
3730: fnd_message.set_token('ATTRIBUTE','Fulfilled Amount');
3731: fnd_message.set_token('new amount', p_header_rec.fulfilled_amount);
3732: fnd_message.set_token('old amount', l_old_header_rec.fulfilled_amount);
3733: OE_MSG_PUB.Add;
3734: END IF;
3735:
3736:
3758: AND ROWNUM = 1;
3759:
3760: IF l_dummy = 'ERROR' THEN
3761: x_return_status := FND_API.G_RET_STS_ERROR;
3762: fnd_message.set_name('ONT', 'OE_BLKT_END_DATE_CONFLICT');
3763: OE_MSG_PUB.Add;
3764: END IF;
3765:
3766: EXCEPTION
3779: AND BLANKET_NUMBER = p_header_rec.order_number
3780: AND ROWNUM = 1;
3781: IF l_dummy = 'ERROR' THEN
3782: x_return_status := FND_API.G_RET_STS_ERROR;
3783: fnd_message.set_name('ONT', 'OE_BLKT_RELEASE_END_DATE');
3784: OE_MSG_PUB.Add;
3785: END IF;
3786:
3787: EXCEPTION
3819: OR BLANKET_MIN_QUANTITY < RELEASED_QUANTITY)
3820: AND ROWNUM = 1;
3821:
3822: IF l_dummy = 'WARNING' THEN
3823: fnd_message.set_name('ONT', 'OE_BLKT_CLOSE_MIN_VALUES');
3824: OE_MSG_PUB.Add;
3825: END IF;
3826: END IF;
3827: END IF;
3840: l_old_header_rec.blanket_max_amount)
3841: AND p_header_rec.blanket_max_amount < p_header_rec.released_amount
3842: AND nvl(p_header_rec.override_amount_flag, 'N') = 'N' THEN
3843: x_return_status := FND_API.G_RET_STS_ERROR;
3844: fnd_message.set_name('ONT', 'OE_BLKT_UPDATE_MAX_LIMIT');
3845: OE_MSG_PUB.Add;
3846: END IF;
3847:
3848: -- Version Change
3868: <= l_old_header_rec.version_number
3869: THEN
3870:
3871: x_return_status := FND_API.G_RET_STS_ERROR;
3872: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_REVISION_NUM');
3873: OE_MSG_PUB.ADD;
3874:
3875: ELSIF p_header_rec.revision_change_reason_code IS NULL THEN
3876:
3874:
3875: ELSIF p_header_rec.revision_change_reason_code IS NULL THEN
3876:
3877: x_return_status := FND_API.G_RET_STS_ERROR;
3878: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
3879: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Revision Reason');
3880: OE_MSG_PUB.ADD;
3881:
3882: ELSE
3875: ELSIF p_header_rec.revision_change_reason_code IS NULL THEN
3876:
3877: x_return_status := FND_API.G_RET_STS_ERROR;
3878: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
3879: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Revision Reason');
3880: OE_MSG_PUB.ADD;
3881:
3882: ELSE
3883:
3891: AND LOOKUP_CODE = p_header_rec.revision_change_reason_code;
3892:
3893: EXCEPTION
3894: WHEN NO_DATA_FOUND THEN
3895: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_REASON_CODE');
3896: FND_MESSAGE.SET_TOKEN('REASON_CODE', p_header_rec.revision_change_reason_code);
3897: OE_MSG_PUB.ADD;
3898: x_return_status := FND_API.G_RET_STS_ERROR;
3899: END;
3892:
3893: EXCEPTION
3894: WHEN NO_DATA_FOUND THEN
3895: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_REASON_CODE');
3896: FND_MESSAGE.SET_TOKEN('REASON_CODE', p_header_rec.revision_change_reason_code);
3897: OE_MSG_PUB.ADD;
3898: x_return_status := FND_API.G_RET_STS_ERROR;
3899: END;
3900:
6462: x_return_status := FND_API.G_RET_STS_ERROR;
6463:
6464: -- Release the lock
6465:
6466: fnd_message.set_name('ONT','OE_LOCK_ROW_CHANGED');
6467: OE_MSG_PUB.Add;
6468:
6469: END IF;
6470:
6484: if l_debug_level > 0 then
6485: oe_debug_pub.add('no data found in blanket lock_blanket', 1);
6486: end if;
6487:
6488: fnd_message.set_name('ONT','OE_LOCK_ROW_DELETED');
6489: OE_MSG_PUB.Add;
6490:
6491: OE_GLOBALS.G_LOCK_TEST := 'N';
6492:
6497: if l_debug_level > 0 then
6498: oe_debug_pub.add('record_lock in blanket lock_blanket', 1);
6499: end if;
6500:
6501: fnd_message.set_name('ONT','OE_LOCK_ROW_ALREADY_LOCKED');
6502: OE_MSG_PUB.Add;
6503:
6504: OE_GLOBALS.G_LOCK_TEST := 'N';
6505:
7018: end if;
7019:
7020: IF x_result <> FND_SEQNUM.SEQSUCC THEN
7021: IF x_result = FND_SEQNUM.NOTUSED THEN
7022: fnd_message.set_name('ONT','OE_MISS_DOC_SEQ');
7023: OE_MSG_PUB.Add;
7024: RAISE FND_API.G_EXC_ERROR;
7025: END IF;
7026:
7055: INTO l_column_name
7056: FROM fnd_lookups
7057: WHERE lookup_type = 'SEQUENCE_METHOD'
7058: AND lookup_code = t;
7059: fnd_message.set_name('ONT','OE_BLKT_INVALID_DOC_SEQ');
7060: fnd_message.set_token('Document Sequence', l_column_name);
7061: OE_MSG_PUB.Add;
7062:
7063: RAISE FND_API.G_EXC_ERROR;
7056: FROM fnd_lookups
7057: WHERE lookup_type = 'SEQUENCE_METHOD'
7058: AND lookup_code = t;
7059: fnd_message.set_name('ONT','OE_BLKT_INVALID_DOC_SEQ');
7060: fnd_message.set_token('Document Sequence', l_column_name);
7061: OE_MSG_PUB.Add;
7062:
7063: RAISE FND_API.G_EXC_ERROR;
7064: -- x_doc_sequence_value := p_x_header_rec.order_number;
7070: OE_BLANKET_HEADERS_ALL
7071: WHERE order_number = X_doc_sequence_value;
7072:
7073: IF lcount > 0 THEN
7074: fnd_message.set_name('ONT','OE_BLKT_NUM_EXISTS');
7075: OE_MSG_PUB.Add;
7076: RAISE FND_API.G_EXC_ERROR;
7077: END IF;
7078: END IF; -- Blanket category code not null
7321: END;
7322:
7323: END IF;
7324: IF l_valid = 'N' THEN
7325: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_LINE_NUMBER_EXISTS');
7326: OE_MSG_PUB.ADD;
7327: RAISE FND_API.G_EXC_ERROR;
7328: END IF;
7329:
7457: );
7458:
7459: if (lcount > 0) then
7460: -- ERROR: date overlap problem. Show error and
7461: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_UNIQUE_ITEM_VIOLATION');
7462: OE_MSG_PUB.ADD;
7463: RAISE FND_API.G_EXC_ERROR;
7464: end if;
7465:
7771: , x_line_tbl => x_line_tbl
7772: );
7773:
7774: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
7775: fnd_message.set_name('ONT','OE_CPY_COPY_FAILED');
7776: OE_MSG_PUB.Add;
7777: ROLLBACK TO SAVEPOINT Copy_Blanket;
7778: RAISE FND_API.G_EXC_ERROR;
7779: END IF;
7795: x_return_status := nvl(l_return_status, x_return_status);
7796: END IF;
7797:
7798: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
7799: fnd_message.set_name('ONT','OE_CPY_COPY_FAILED');
7800: OE_MSG_PUB.Add;
7801: ROLLBACK TO SAVEPOINT Copy_Blanket;
7802: RAISE FND_API.G_EXC_ERROR;
7803: ELSE
7800: OE_MSG_PUB.Add;
7801: ROLLBACK TO SAVEPOINT Copy_Blanket;
7802: RAISE FND_API.G_EXC_ERROR;
7803: ELSE
7804: fnd_message.set_name('ONT','OE_BL_COPY_SUCCESS');
7805: -- Bug 3337297
7806: -- Set blanket number token
7807: fnd_message.set_token('BLANKET_NUMBER',x_header_rec.order_number);
7808: OE_MSG_PUB.Add;
7803: ELSE
7804: fnd_message.set_name('ONT','OE_BL_COPY_SUCCESS');
7805: -- Bug 3337297
7806: -- Set blanket number token
7807: fnd_message.set_token('BLANKET_NUMBER',x_header_rec.order_number);
7808: OE_MSG_PUB.Add;
7809: x_header_id := x_header_rec.header_id;
7810: END IF;
7811:
7867: AND (p_min_value > p_max_value) THEN
7868: if l_debug_level > 0 then
7869: oe_debug_pub.add('Invalid min/max for attribute :'||p_attribute);
7870: end if;
7871: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_MIN_MAX_RANGE');
7872: FND_MESSAGE.SET_TOKEN('MIN', p_min_value);
7873: FND_MESSAGE.SET_TOKEN('MAX', p_max_value);
7874: OE_MSG_PUB.ADD;
7875: x_return_status := FND_API.G_RET_STS_ERROR;
7868: if l_debug_level > 0 then
7869: oe_debug_pub.add('Invalid min/max for attribute :'||p_attribute);
7870: end if;
7871: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_MIN_MAX_RANGE');
7872: FND_MESSAGE.SET_TOKEN('MIN', p_min_value);
7873: FND_MESSAGE.SET_TOKEN('MAX', p_max_value);
7874: OE_MSG_PUB.ADD;
7875: x_return_status := FND_API.G_RET_STS_ERROR;
7876: END IF;
7869: oe_debug_pub.add('Invalid min/max for attribute :'||p_attribute);
7870: end if;
7871: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_MIN_MAX_RANGE');
7872: FND_MESSAGE.SET_TOKEN('MIN', p_min_value);
7873: FND_MESSAGE.SET_TOKEN('MAX', p_max_value);
7874: OE_MSG_PUB.ADD;
7875: x_return_status := FND_API.G_RET_STS_ERROR;
7876: END IF;
7877:
9271: ELSIF to_number(l_attribute_value) = p_x_line_rec.inventory_item_id THEN
9272: NULL;
9273: ELSE
9274: oe_debug_pub.add('Issue error message', 1);
9275: fnd_message.set_name('ONT','OE_INVALIDATES_CUSTOMER_ITEM');
9276: OE_MSG_PUB.Add;
9277: x_return_status := FND_API.G_RET_STS_ERROR;
9278: END IF;
9279: END Get_Inventory_Item;
9335: oe_debug_pub.add ('OE_blanket_util.validate_sold_to Blanket In ship to No data found',2);
9336: end if;
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
9336: end if;
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
9368: oe_debug_pub.add ('OE_blanket_util.validate_sold_to Blanket In deliver No data found',2);
9369: end if;
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
9369: end if;
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
9398: oe_debug_pub.add ('OE_blanket_util.validate_sold_to Blanket In invoice No data found',2);
9399: end if;
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
9399: end if;
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
9475: ,p_source_document_type_id => null);
9476:
9477: if (trunc(l_header_rec.end_date_active) < trunc(sysdate))
9478: then
9479: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_DATE_RANGE');
9480: OE_MSG_PUB.ADD;
9481: x_return_status := FND_API.G_RET_STS_ERROR;
9482: end if;
9483:
9506:
9507: if (l_line_tbl(K).end_date_active is not NULL and
9508: (l_line_tbl(K).start_date_active)
9509: > (l_line_tbl(K).end_date_active)) THEN
9510: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_DATE_RANGE');
9511: OE_MSG_PUB.ADD;
9512: x_return_status := FND_API.G_RET_STS_ERROR;
9513: end if;
9514:
9513: end if;
9514:
9515: if( trunc(l_line_tbl(K).end_date_active) < trunc(sysdate))
9516: then
9517: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_DATE_RANGE');
9518: OE_MSG_PUB.ADD;
9519: x_return_status := FND_API.G_RET_STS_ERROR;
9520: end if;
9521: