APPS.OE_BLANKET_UTIL dependencies on FND_MESSAGE

Line 42: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_CLOSE_MIN_VALUES');

38: NOT OE_GLOBALS.Equal(p_line_rec.end_date_active, p_old_line_rec.end_date_active) THEN
39:
40: IF p_line_rec.override_blanket_controls_flag = 'N' THEN
41: IF nvl(p_line_rec.released_amount,0) < p_line_rec.blanket_min_amount THEN
42: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_CLOSE_MIN_VALUES');
43: OE_MSG_PUB.ADD;
44: if l_debug_level > 0 then
45: oe_debug_pub.add('Blanket line close min amount ');
46: end if;

Line 50: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_CLOSE_MIN_VALUES');

46: end if;
47: -- return false; This is a warning..hence not returning ..
48:
49: ELSIF nvl(p_line_rec.released_quantity,0) < p_line_rec.blanket_min_quantity THEN
50: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_CLOSE_MIN_VALUES');
51: OE_MSG_PUB.ADD;
52: if l_debug_level > 0 then
53: oe_debug_pub.add('Blanket line close min quantity ');
54: end if;

Line 73: fnd_message.set_name('ONT', 'OE_BLKT_LINE_RELEASE_END_DATE');

69: AND BLANKET_LINE_NUMBER = p_line_rec.line_number
70: AND ROWNUM = 1;
71:
72: IF l_dummy = 'ERROR' THEN
73: fnd_message.set_name('ONT', 'OE_BLKT_LINE_RELEASE_END_DATE');
74: OE_MSG_PUB.Add;
75: return false;
76: END IF;
77:

Line 1815: FND_MESSAGE.SET_NAME('FND', 'ONT_BLKT_CONTEXT_NOT_FOUND');

1811:
1812: -- Show Error message if appropriate context value is not passed
1813: -- from the Process Order Call and if the Context field is required.
1814:
1815: FND_MESSAGE.SET_NAME('FND', 'ONT_BLKT_CONTEXT_NOT_FOUND');
1816:
1817: OE_MSG_PUB.ADD;
1818: IF l_debug_level > 0 THEN
1819: oe_debug_pub.add( 'Context not set for OE_BLKT_LINE_ATTRIBUTES DFF ' ) ;

Line 2449: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');

2445: THEN
2446:
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:

Line 2450: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

2446:
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;

Line 2461: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');

2457: THEN
2458:
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:

Line 2462: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

2458:
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'

Line 2472: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');

2468: THEN
2469:
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:

Line 2473: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

2469:
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;

Line 2484: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');

2480: THEN
2481:
2482: x_return_status := FND_API.G_RET_STS_ERROR;
2483:
2484: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
2485: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Activation Date');
2486: OE_MSG_PUB.Add;
2487:
2488: END IF;

Line 2485: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Activation Date');

2481:
2482: x_return_status := FND_API.G_RET_STS_ERROR;
2483:
2484: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
2485: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Activation Date');
2486: OE_MSG_PUB.Add;
2487:
2488: END IF;
2489:

Line 2519: FND_MESSAGE.Set_Name('ONT','OE_INVALID_ATTRIBUTE');

2515: (p_line_rec.inventory_item_id,
2516: p_line_rec.accounting_rule_id)
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;

Line 2520: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

2516: p_line_rec.accounting_rule_id)
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:

Line 2537: fnd_message.set_name('ONT', 'OE_BLKT_UPDATE_LINE_ATTRIBUTE');

2533: (p_line_rec.line_number,l_old_line_rec.line_number)
2534: THEN
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

Line 2538: fnd_message.set_token('ATTRIBUTE',

2534: THEN
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 =>

Line 2575: fnd_message.set_name('ONT', 'OE_BLKT_UPDATE_LINE_ATTRIBUTE');

2571: IF (p_line_rec.released_amount > 0) AND
2572: (NOT OE_GLOBALS.Equal
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;

Line 2576: fnd_message.set_token('ATTRIBUTE',

2572: (NOT OE_GLOBALS.Equal
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:

Line 2584: fnd_message.set_name('ONT', 'OE_BLKT_UPDATE_LINE_ATTRIBUTE');

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;

Line 2585: fnd_message.set_token('ATTRIBUTE',

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:

Line 2597: fnd_message.set_name('ONT', 'OE_ITEM_VALIDATION_FAILED');

2593: IF p_line_rec.item_identifier_type = 'ALL' THEN
2594:
2595: IF p_line_rec.inventory_item_id IS NOT NULL THEN
2596: x_return_status := FND_API.G_RET_STS_ERROR;
2597: fnd_message.set_name('ONT', 'OE_ITEM_VALIDATION_FAILED');
2598: OE_MSG_PUB.add;
2599: END IF;
2600:
2601: -- For all other context values, validate item id

Line 2612: fnd_message.set_name('ONT', 'OE_ITEM_VALIDATION_FAILED');

2608: p_line_rec.ordered_item_id,
2609: p_line_rec.ordered_item
2610: ) THEN
2611: x_return_status := FND_API.G_RET_STS_ERROR;
2612: fnd_message.set_name('ONT', 'OE_ITEM_VALIDATION_FAILED');
2613: OE_MSG_PUB.add;
2614: END IF;
2615:
2616: END IF;

Line 2661: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');

2657: if l_debug_level > 0 then
2658: oe_debug_pub.add ('Blanket In: No data found',2);
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;

Line 2662: FND_MESSAGE.SET_TOKEN('ATTRIBUTE'

2658: oe_debug_pub.add ('Blanket In: No data found',2);
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

Line 2681: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');

2677: IF NOT (Validate_Deliver_To_Org(p_line_rec.deliver_to_org_id,
2678: p_line_rec.sold_to_org_id )) THEN
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;

Line 2682: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

2678: p_line_rec.sold_to_org_id )) THEN
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:

Line 2698: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');

2694: -- ER 5743580
2695: IF NOT ( Validate_Invoice_To_Org ( p_line_rec.invoice_to_org_id,
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;

Line 2699: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

2695: IF NOT ( Validate_Invoice_To_Org ( p_line_rec.invoice_to_org_id,
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

Line 2718: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_DATE_RANGE');

2714: > (p_line_rec.end_date_active)) THEN
2715: if ( nvl(p_line_rec.source_document_type_id,0) = 2 --bug#5528507
2716: AND p_line_rec.operation = OE_GLOBALS.G_OPR_CREATE)
2717: then
2718: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_DATE_RANGE');
2719: OE_MSG_PUB.ADD;
2720: oe_debug_pub.add('1: Not Setting Error',1);
2721:
2722: else

Line 2723: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_DATE_RANGE');

2719: OE_MSG_PUB.ADD;
2720: oe_debug_pub.add('1: Not Setting Error',1);
2721:
2722: else
2723: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_DATE_RANGE');
2724: OE_MSG_PUB.ADD;
2725: oe_debug_pub.add('1: Setting Error',1);
2726: x_return_status := FND_API.G_RET_STS_ERROR;
2727: end if;

Line 2734: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_END_DATE_CONFLICT');

2730:
2731: --line start date must be after header date range
2732: if (p_line_rec.start_date_active < g_header_rec.start_date_active)
2733: then
2734: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_END_DATE_CONFLICT');
2735: OE_MSG_PUB.ADD;
2736: x_return_status := FND_API.G_RET_STS_ERROR;
2737: end if;
2738:

Line 2746: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_END_DATE_CONFLICT');

2742: if p_line_rec.end_date_active is NULL
2743: or (p_line_rec.end_date_active
2744: > g_header_rec.end_date_active)
2745: then
2746: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_END_DATE_CONFLICT');
2747: OE_MSG_PUB.ADD;
2748: x_return_status := FND_API.G_RET_STS_ERROR;
2749: end if;
2750: end if;

Line 2761: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');

2757: -- pricing uom is required if it is a blanket price list
2758: -- and ordered UOM is null
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

Line 2762: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

2758: -- and ordered UOM is null
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)

Line 2768: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');

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
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;

Line 2769: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

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
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;

Line 2779: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');

2775:
2776: IF NOT g_new_price_list AND
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;

Line 2780: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

2776: IF NOT g_new_price_list AND
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;

Line 2792: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_QUANTITY_UOM');

2788: (p_line_rec.Blanket_Min_Quantity IS NOT NULL
2789: OR p_line_rec.Blanket_Max_Quantity IS NOT NULL
2790: OR p_line_rec.Min_Release_Quantity IS NOT NULL
2791: OR p_line_rec.Max_Release_Quantity IS NOT NULL) THEN
2792: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_QUANTITY_UOM');
2793: OE_MSG_PUB.ADD;
2794: x_return_status := FND_API.G_RET_STS_ERROR;
2795:
2796: END IF;

Line 2805: fnd_message.set_name('ONT','OE_BSA_REL_QUANTITY');

2801: and ((l_old_line_rec.blanket_max_quantity >= l_old_line_rec.released_quantity)
2802: or (Nvl(l_old_line_rec.blanket_max_quantity,0) = 0))
2803: and (p_line_rec.override_blanket_controls_flag = 'N') then
2804:
2805: fnd_message.set_name('ONT','OE_BSA_REL_QUANTITY');
2806: FND_MESSAGE.SET_TOKEN('VALUE',l_old_line_rec.released_quantity);
2807: OE_MSG_PUB.ADD;
2808: x_return_status := FND_API.G_RET_STS_ERROR;
2809:

Line 2806: FND_MESSAGE.SET_TOKEN('VALUE',l_old_line_rec.released_quantity);

2802: or (Nvl(l_old_line_rec.blanket_max_quantity,0) = 0))
2803: and (p_line_rec.override_blanket_controls_flag = 'N') then
2804:
2805: fnd_message.set_name('ONT','OE_BSA_REL_QUANTITY');
2806: FND_MESSAGE.SET_TOKEN('VALUE',l_old_line_rec.released_quantity);
2807: OE_MSG_PUB.ADD;
2808: x_return_status := FND_API.G_RET_STS_ERROR;
2809:
2810: elsif (p_line_rec.blanket_max_amount < p_line_rec.released_amount)

Line 2815: fnd_message.set_name('ONT','OE_BSA_REL_AMOUNT');

2811: and ((l_old_line_rec.blanket_max_amount >= l_old_line_rec.released_amount)
2812: or (nvl(l_old_line_rec.blanket_max_amount,0) = 0))
2813: and (p_line_rec.override_blanket_controls_flag = 'N') then
2814:
2815: fnd_message.set_name('ONT','OE_BSA_REL_AMOUNT');
2816: FND_MESSAGE.SET_TOKEN('VALUE',l_old_line_rec.released_amount);
2817: OE_MSG_PUB.ADD;
2818: x_return_status := FND_API.G_RET_STS_ERROR;
2819:

Line 2816: FND_MESSAGE.SET_TOKEN('VALUE',l_old_line_rec.released_amount);

2812: or (nvl(l_old_line_rec.blanket_max_amount,0) = 0))
2813: and (p_line_rec.override_blanket_controls_flag = 'N') then
2814:
2815: fnd_message.set_name('ONT','OE_BSA_REL_AMOUNT');
2816: FND_MESSAGE.SET_TOKEN('VALUE',l_old_line_rec.released_amount);
2817: OE_MSG_PUB.ADD;
2818: x_return_status := FND_API.G_RET_STS_ERROR;
2819:
2820:

Line 2842: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_LINE_MIN_MAX_VALUES');

2838: p_line_rec.blanket_max_amount,
2839: 'BLANKET_LINE_AMOUNT', x_return_status);
2840: /*
2841: IF p_line_rec.blanket_max_amount > g_header_rec.blanket_max_amount THEN
2842: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_LINE_MIN_MAX_VALUES');
2843: OE_MSG_PUB.ADD;
2844: x_return_status := FND_API.G_RET_STS_ERROR;
2845: END IF;
2846: */

Line 2849: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_LINE_MAX_AMOUNT');

2845: END IF;
2846: */
2847: IF p_line_rec.min_release_amount > p_line_rec.blanket_max_amount OR
2848: p_line_rec.max_release_amount > p_line_rec.blanket_max_amount THEN
2849: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_LINE_MAX_AMOUNT');
2850: OE_MSG_PUB.ADD;
2851: x_return_status := FND_API.G_RET_STS_ERROR;
2852:
2853: END IF;

Line 2857: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_LINE_MAX_QUANTITY');

2853: END IF;
2854:
2855: IF p_line_rec.min_release_quantity > p_line_rec.blanket_max_quantity OR
2856: p_line_rec.max_release_quantity > p_line_rec.blanket_max_quantity THEN
2857: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_LINE_MAX_QUANTITY');
2858: OE_MSG_PUB.ADD;
2859: x_return_status := FND_API.G_RET_STS_ERROR;
2860:
2861: END IF;

Line 2873: fnd_message.set_name('ONT', 'OE_BLKT_UPDATE_ATTR_CLOSED');

2869: --not allowed to change any attributes on a previously closed blanket
2870: IF p_line_rec.end_date_active < trunc(sysdate) and
2871: l_old_line_rec.end_date_active < trunc(sysdate) THEN
2872: x_return_status := FND_API.G_RET_STS_ERROR;
2873: fnd_message.set_name('ONT', 'OE_BLKT_UPDATE_ATTR_CLOSED');
2874: OE_MSG_PUB.Add;
2875: END IF;
2876: --Srini
2877: --oe_blanket_util.Get_Inventory_Item(p_x_line_rec => p_line_rec,

Line 2887: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_CLOSE_MIN_VALUES');

2883: IF NOT OE_GLOBALS.Equal(p_line_rec.end_date_active, l_old_line_rec.end_date_active) AND
2884: p_line_rec.end_date_active <= trunc(sysdate) AND
2885: p_line_rec.override_blanket_controls_flag = 'N' THEN
2886: IF nvl(p_line_rec.released_amount,0) < p_line_rec.blanket_min_amount THEN
2887: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_CLOSE_MIN_VALUES');
2888: OE_MSG_PUB.ADD;
2889: if l_debug_level > 0 then
2890: oe_debug_pub.add('Blanket line close min amount ');
2891: end if;

Line 2894: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_CLOSE_MIN_VALUES');

2890: oe_debug_pub.add('Blanket line close min amount ');
2891: end if;
2892:
2893: ELSIF nvl(p_line_rec.released_quantity,0) < p_line_rec.blanket_min_quantity THEN
2894: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_CLOSE_MIN_VALUES');
2895: OE_MSG_PUB.ADD;
2896: if l_debug_level > 0 then
2897: oe_debug_pub.add('Blanket line close min quantity ');
2898: end if;

Line 2907: fnd_message.set_name('ONT', 'OE_BLKT_UPDATE_LINE_ATTRIBUTE');

2903: IF (p_line_rec.released_amount > 0) THEN
2904: IF NOT OE_GLOBALS.Equal (p_line_rec.order_quantity_uom,
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;

Line 2908: fnd_message.set_token('ATTRIBUTE',

2904: IF NOT OE_GLOBALS.Equal (p_line_rec.order_quantity_uom,
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;

Line 2953: fnd_message.set_name('ONT', 'OE_BLKT_LINE_RELEASE_END_DATE');

2949: AND ROWNUM = 1;
2950:
2951: IF l_dummy = 'ERROR' THEN
2952: x_return_status := FND_API.G_RET_STS_ERROR;
2953: fnd_message.set_name('ONT', 'OE_BLKT_LINE_RELEASE_END_DATE');
2954: OE_MSG_PUB.Add;
2955: END IF;
2956:
2957: EXCEPTION

Line 2977: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_UPDATE_LINE_ATTRIBUTE');

2973: --pricing uom not allowed to change if blanket price list
2974: if NOT OE_GLOBALS.EQUAL(p_line_rec.pricing_uom,
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;

Line 2978: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

2974: if NOT OE_GLOBALS.EQUAL(p_line_rec.pricing_uom,
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

Line 2985: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_UPDATE_LINE_ATTRIBUTE');

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
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;

Line 2986: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

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
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;

Line 3000: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_UPDATE_LINE_ATTRIBUTE');

2996: oe_debug_pub.add('Blanket In validate entity update 1');
2997: end if;
2998: if NOT OE_GLOBALS.EQUAL(p_line_rec.released_amount,
2999: l_old_line_rec.released_amount) THEN
3000: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_UPDATE_LINE_ATTRIBUTE');
3001: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Released Amount');
3002: OE_MSG_PUB.ADD;
3003: x_return_status := FND_API.G_RET_STS_ERROR;
3004: end if;

Line 3001: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Released Amount');

2997: end if;
2998: if NOT OE_GLOBALS.EQUAL(p_line_rec.released_amount,
2999: l_old_line_rec.released_amount) THEN
3000: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_UPDATE_LINE_ATTRIBUTE');
3001: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Released Amount');
3002: OE_MSG_PUB.ADD;
3003: x_return_status := FND_API.G_RET_STS_ERROR;
3004: end if;
3005:

Line 3008: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_UPDATE_LINE_ATTRIBUTE');

3004: end if;
3005:
3006: if NOT OE_GLOBALS.EQUAL(p_line_rec.returned_amount,
3007: l_old_line_rec.returned_amount) THEN
3008: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_UPDATE_LINE_ATTRIBUTE');
3009: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Returned Amount');
3010: OE_MSG_PUB.ADD;
3011: x_return_status := FND_API.G_RET_STS_ERROR;
3012: end if;

Line 3009: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Returned Amount');

3005:
3006: if NOT OE_GLOBALS.EQUAL(p_line_rec.returned_amount,
3007: l_old_line_rec.returned_amount) THEN
3008: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_UPDATE_LINE_ATTRIBUTE');
3009: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Returned Amount');
3010: OE_MSG_PUB.ADD;
3011: x_return_status := FND_API.G_RET_STS_ERROR;
3012: end if;
3013:

Line 3016: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_UPDATE_LINE_ATTRIBUTE');

3012: end if;
3013:
3014: if NOT OE_GLOBALS.EQUAL(p_line_rec.released_quantity,
3015: Round(l_old_line_rec.released_quantity, 6)) THEN --round() added for bug 9587613
3016: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_UPDATE_LINE_ATTRIBUTE');
3017: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Released Quantity');
3018: OE_MSG_PUB.ADD;
3019: x_return_status := FND_API.G_RET_STS_ERROR;
3020: end if;

Line 3017: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Released Quantity');

3013:
3014: if NOT OE_GLOBALS.EQUAL(p_line_rec.released_quantity,
3015: Round(l_old_line_rec.released_quantity, 6)) THEN --round() added for bug 9587613
3016: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_UPDATE_LINE_ATTRIBUTE');
3017: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Released Quantity');
3018: OE_MSG_PUB.ADD;
3019: x_return_status := FND_API.G_RET_STS_ERROR;
3020: end if;
3021:

Line 3024: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_UPDATE_LINE_ATTRIBUTE');

3020: end if;
3021:
3022: if NOT OE_GLOBALS.EQUAL(p_line_rec.fulfilled_quantity,
3023: Round(l_old_line_rec.fulfilled_quantity, 6)) THEN --round() added for bug 9587613
3024: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_UPDATE_LINE_ATTRIBUTE');
3025: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Fulfilled Quantity');
3026: OE_MSG_PUB.ADD;
3027: x_return_status := FND_API.G_RET_STS_ERROR;
3028: end if;

Line 3025: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Fulfilled Quantity');

3021:
3022: if NOT OE_GLOBALS.EQUAL(p_line_rec.fulfilled_quantity,
3023: Round(l_old_line_rec.fulfilled_quantity, 6)) THEN --round() added for bug 9587613
3024: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_UPDATE_LINE_ATTRIBUTE');
3025: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Fulfilled Quantity');
3026: OE_MSG_PUB.ADD;
3027: x_return_status := FND_API.G_RET_STS_ERROR;
3028: end if;
3029:

Line 3032: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_UPDATE_LINE_ATTRIBUTE');

3028: end if;
3029:
3030: if NOT OE_GLOBALS.EQUAL(p_line_rec.fulfilled_amount,
3031: l_old_line_rec.fulfilled_amount) THEN
3032: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_UPDATE_LINE_ATTRIBUTE');
3033: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Fulfilled Amount');
3034: OE_MSG_PUB.ADD;
3035: x_return_status := FND_API.G_RET_STS_ERROR;
3036: end if;

Line 3033: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Fulfilled Amount');

3029:
3030: if NOT OE_GLOBALS.EQUAL(p_line_rec.fulfilled_amount,
3031: l_old_line_rec.fulfilled_amount) THEN
3032: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_UPDATE_LINE_ATTRIBUTE');
3033: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Fulfilled Amount');
3034: OE_MSG_PUB.ADD;
3035: x_return_status := FND_API.G_RET_STS_ERROR;
3036: end if;
3037:

Line 3040: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_UPDATE_LINE_ATTRIBUTE');

3036: end if;
3037:
3038: if NOT OE_GLOBALS.EQUAL(p_line_rec.returned_quantity,
3039: Round(l_old_line_rec.returned_quantity, 6)) THEN --round() added for bug 9587613
3040: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_UPDATE_LINE_ATTRIBUTE');
3041: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Returned Quantity');
3042: OE_MSG_PUB.ADD;
3043: x_return_status := FND_API.G_RET_STS_ERROR;
3044: end if;

Line 3041: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Returned Quantity');

3037:
3038: if NOT OE_GLOBALS.EQUAL(p_line_rec.returned_quantity,
3039: Round(l_old_line_rec.returned_quantity, 6)) THEN --round() added for bug 9587613
3040: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_UPDATE_LINE_ATTRIBUTE');
3041: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Returned Quantity');
3042: OE_MSG_PUB.ADD;
3043: x_return_status := FND_API.G_RET_STS_ERROR;
3044: end if;
3045: if l_debug_level > 0 then

Line 3067: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_DATE_RANGE');

3063:
3064: if ( nvl(p_line_rec.source_document_type_id,0) = 2 --bug#5528507
3065: AND p_line_rec.operation = OE_GLOBALS.G_OPR_CREATE)
3066: then
3067: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_DATE_RANGE');
3068: OE_MSG_PUB.ADD;
3069: oe_debug_pub.add('2: Not Setting Error',1);
3070:
3071: else

Line 3072: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_DATE_RANGE');

3068: OE_MSG_PUB.ADD;
3069: oe_debug_pub.add('2: Not Setting Error',1);
3070:
3071: else
3072: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_DATE_RANGE');
3073: OE_MSG_PUB.ADD;
3074: x_return_status := FND_API.G_RET_STS_ERROR;
3075: oe_debug_pub.add('2: Setting Error',1);
3076: end if;

Line 3214: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');

3210: END IF; -- if list price changes
3211:
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;

Line 3215: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

3211:
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:

Line 3263: fnd_message.set_name('ONT','OE_BLKT_CANNOT_UPDATE_DIS');

3259:
3260: IF p_line_rec.modifier_list_line_id IS NOT NULL
3261: THEN
3262: oe_debug_pub.add('modifier list line id is not null');
3263: fnd_message.set_name('ONT','OE_BLKT_CANNOT_UPDATE_DIS');
3264: oe_msg_pub.add;
3265: x_return_status := FND_API.G_RET_STS_ERROR;
3266: ELSIF g_header_rec.new_modifier_list_name IS NULL
3267: AND g_header_rec.new_modifier_list_id IS NULL

Line 3269: fnd_message.set_name('ONT','OE_BLKT_CANNOT_ENTER_DIS');

3265: x_return_status := FND_API.G_RET_STS_ERROR;
3266: ELSIF g_header_rec.new_modifier_list_name IS NULL
3267: AND g_header_rec.new_modifier_list_id IS NULL
3268: THEN
3269: fnd_message.set_name('ONT','OE_BLKT_CANNOT_ENTER_DIS');
3270: oe_msg_pub.add;
3271: x_return_status := FND_API.G_RET_STS_ERROR;
3272: ELSIF p_line_rec.discount_percent IS NOT NULL
3273: AND p_line_rec.discount_amount IS NOT NULL

Line 3275: fnd_message.set_name('ONT','OE_BLKT_DISCOUNT_CONFLICT');

3271: x_return_status := FND_API.G_RET_STS_ERROR;
3272: ELSIF p_line_rec.discount_percent IS NOT NULL
3273: AND p_line_rec.discount_amount IS NOT NULL
3274: THEN
3275: fnd_message.set_name('ONT','OE_BLKT_DISCOUNT_CONFLICT');
3276: oe_msg_pub.add;
3277: x_return_status := FND_API.G_RET_STS_ERROR;
3278: ELSE
3279: -- Log delayed request to create new modifier list line

Line 3441: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');

3437:
3438: -- Check Required attributes
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;

Line 3442: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

3438: -- Check Required attributes
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:

Line 3449: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');

3445: END IF;
3446:
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;

Line 3450: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

3446:
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

Line 3458: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');

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;

Line 3459: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

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;

Line 3467: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');

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;

Line 3468: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

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:

Line 3475: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');

3471: END IF;
3472:
3473: IF p_header_rec.start_date_active IS NULL THEN
3474: x_return_status := FND_API.G_RET_STS_ERROR;
3475: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
3476: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Activation Date');
3477: OE_MSG_PUB.Add;
3478: END IF;
3479:

Line 3476: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Activation Date');

3472:
3473: IF p_header_rec.start_date_active IS NULL THEN
3474: x_return_status := FND_API.G_RET_STS_ERROR;
3475: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
3476: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Activation Date');
3477: OE_MSG_PUB.Add;
3478: END IF;
3479:
3480: ---------------------------------------------------------------------

Line 3493: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_DATE_RANGE');

3489:
3490: if ( nvl(p_header_rec.source_document_type_id,0) = 2) --bug#5528507
3491: AND p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3492: then
3493: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_DATE_RANGE');
3494: OE_MSG_PUB.ADD;
3495: oe_debug_pub.add('3: Not Setting Error',1);
3496:
3497: else

Line 3498: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_DATE_RANGE');

3494: OE_MSG_PUB.ADD;
3495: oe_debug_pub.add('3: Not Setting Error',1);
3496:
3497: else
3498: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_DATE_RANGE');
3499: OE_MSG_PUB.ADD;
3500: x_return_status := FND_API.G_RET_STS_ERROR;
3501: oe_debug_pub.add('3: Setting Error',1);
3502: end if;

Line 3518: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');

3514: if l_debug_level > 0 then
3515: oe_debug_pub.add ('Blanket In: No data found',2);
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;

Line 3519: FND_MESSAGE.SET_TOKEN('ATTRIBUTE'

3515: oe_debug_pub.add ('Blanket In: No data found',2);
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:

Line 3559: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');

3555: EXCEPTION
3556:
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:

Line 3560: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

3556:
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

Line 3596: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');

3592: IF NOT (Validate_Deliver_To_Org(p_header_rec.deliver_to_org_id,
3593: p_header_rec.sold_to_org_id )) THEN
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;

Line 3597: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

3593: p_header_rec.sold_to_org_id )) THEN
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:

Line 3612: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');

3608: -- ER 5743580
3609: IF NOT ( Validate_Invoice_To_Org ( p_header_rec.invoice_to_org_id,
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;

Line 3613: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

3609: IF NOT ( Validate_Invoice_To_Org ( p_header_rec.invoice_to_org_id,
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:

Line 3638: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');

3634: -- Valid Sold To Contact
3635: EXCEPTION
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

Line 3639: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

3635: EXCEPTION
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

Line 3653: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_DATE_RANGE');

3649:
3650: if p_header_rec.start_date_active is not NULL and
3651: p_header_rec.end_date_active is not NULL and
3652: p_header_rec.start_date_active > p_header_rec.end_date_active then
3653: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_DATE_RANGE');
3654: OE_MSG_PUB.ADD;
3655: x_return_status := FND_API.G_RET_STS_ERROR;
3656: end if;
3657:

Line 3710: fnd_message.set_name('ONT','OE_BLKT_CANT_ENTER_NEW_PL_ID');

3706: p_old_header_rec.new_price_list_id)
3707: THEN
3708:
3709: -- Cannot enter ID for a new price list, only name
3710: fnd_message.set_name('ONT','OE_BLKT_CANT_ENTER_NEW_PL_ID');
3711: oe_msg_pub.add;
3712: x_return_status := FND_API.G_RET_STS_ERROR;
3713:
3714: ELSIF p_header_rec.new_price_list_name IS NOT NULL

Line 3732: fnd_message.set_name('ONT','OE_BLKT_PRICE_LIST_EXISTS');

3728: FROM qp_list_headers_vl
3729: WHERE name = p_header_rec.new_price_list_name
3730: AND rownum = 1;
3731:
3732: fnd_message.set_name('ONT','OE_BLKT_PRICE_LIST_EXISTS');
3733: oe_msg_pub.add;
3734: x_return_status := FND_API.G_RET_STS_ERROR;
3735:
3736: EXCEPTION

Line 3748: fnd_message.set_name('ONT','OE_BLKT_CANT_ENTER_MOD_LIST_ID');

3744: p_old_header_rec.new_modifier_list_id)
3745: THEN
3746:
3747: -- Cannot enter ID for a new modifier list, only name
3748: fnd_message.set_name('ONT','OE_BLKT_CANT_ENTER_MOD_LIST_ID');
3749: oe_msg_pub.add;
3750: x_return_status := FND_API.G_RET_STS_ERROR;
3751:
3752: ELSIF p_header_rec.new_modifier_list_name IS NOT NULL

Line 3772: fnd_message.set_name('ONT','OE_BLKT_MOD_LIST_EXISTS');

3768: FROM qp_list_headers_vl
3769: WHERE name = p_header_rec.new_modifier_list_name
3770: AND rownum = 1;
3771:
3772: fnd_message.set_name('ONT','OE_BLKT_MOD_LIST_EXISTS');
3773: oe_msg_pub.add;
3774: x_return_status := FND_API.G_RET_STS_ERROR;
3775:
3776: EXCEPTION

Line 3817: fnd_message.set_name('ONT', 'OE_BLKT_UPDATE_ATTR_CLOSED');

3813: --not allowed to change any attributes on a previously closed blanket
3814: IF p_header_rec.end_date_active < trunc(sysdate) and
3815: l_old_header_rec.end_date_active < trunc(sysdate) THEN
3816: x_return_status := FND_API.G_RET_STS_ERROR;
3817: fnd_message.set_name('ONT', 'OE_BLKT_UPDATE_ATTR_CLOSED');
3818: OE_MSG_PUB.Add;
3819: END IF;
3820:
3821:

Line 3829: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_CLOSE_MIN_VALUES');

3825: nvl(p_header_rec.released_amount,0) < p_header_rec.blanket_min_amount THEN
3826: if l_debug_level > 0 then
3827: oe_debug_pub.add('Blanket header close min amount ');
3828: end if;
3829: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_CLOSE_MIN_VALUES');
3830: OE_MSG_PUB.ADD;
3831: END IF;
3832:
3833:

Line 3837: fnd_message.set_name('ONT', 'OE_BLKT_UPDATE_HDR_ATTRIBUTE');

3833:
3834: IF NOT OE_GLOBALS.Equal (p_header_rec.header_id,
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;

Line 3838: fnd_message.set_token('ATTRIBUTE',

3834: IF NOT OE_GLOBALS.Equal (p_header_rec.header_id,
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:

Line 3846: fnd_message.set_name('ONT', 'OE_BLKT_UPDATE_HDR_ATTRIBUTE');

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;

Line 3847: fnd_message.set_token('ATTRIBUTE',

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:

Line 3855: fnd_message.set_name('ONT', 'OE_BLKT_UPDATE_HDR_ATTRIBUTE');

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;

Line 3856: fnd_message.set_token('ATTRIBUTE',

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:

Line 3864: fnd_message.set_name('ONT', 'OE_BLKT_UPDATE_HDR_ATTRIBUTE');

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;

Line 3865: fnd_message.set_token('ATTRIBUTE',

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:

Line 3875: fnd_message.set_name('ONT', 'OE_BLKT_UPDATE_HDR_ATTRIBUTE');

3871: IF p_header_rec.released_amount > 0 THEN
3872: IF NOT OE_GLOBALS.Equal (p_header_rec.sold_to_org_id,
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;

Line 3876: fnd_message.set_token('ATTRIBUTE',

3872: IF NOT OE_GLOBALS.Equal (p_header_rec.sold_to_org_id,
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:

Line 3884: fnd_message.set_name('ONT', 'OE_BLKT_UPDATE_HDR_ATTRIBUTE');

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;

Line 3885: fnd_message.set_token('ATTRIBUTE',

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:

Line 3893: fnd_message.set_name('ONT', 'OE_BLKT_UPDATE_HDR_ATTRIBUTE');

3889:
3890: IF NOT OE_GLOBALS.Equal (p_header_rec.start_date_active,
3891: l_old_header_rec.start_date_active) THEN
3892: x_return_status := FND_API.G_RET_STS_ERROR;
3893: fnd_message.set_name('ONT', 'OE_BLKT_UPDATE_HDR_ATTRIBUTE');
3894: fnd_message.set_token('ATTRIBUTE','Activation Date');
3895: OE_MSG_PUB.Add;
3896: END IF;
3897: END IF; --if releases exist

Line 3894: fnd_message.set_token('ATTRIBUTE','Activation Date');

3890: IF NOT OE_GLOBALS.Equal (p_header_rec.start_date_active,
3891: l_old_header_rec.start_date_active) THEN
3892: x_return_status := FND_API.G_RET_STS_ERROR;
3893: fnd_message.set_name('ONT', 'OE_BLKT_UPDATE_HDR_ATTRIBUTE');
3894: fnd_message.set_token('ATTRIBUTE','Activation Date');
3895: OE_MSG_PUB.Add;
3896: END IF;
3897: END IF; --if releases exist
3898:

Line 3902: fnd_message.set_name('ONT', 'OE_BLKT_UPDATE_HDR_ATTRIBUTE');

3898:
3899: IF NOT OE_GLOBALS.Equal (p_header_rec.released_amount,
3900: l_old_header_rec.released_amount) THEN
3901: x_return_status := FND_API.G_RET_STS_ERROR;
3902: fnd_message.set_name('ONT', 'OE_BLKT_UPDATE_HDR_ATTRIBUTE');
3903: fnd_message.set_token('ATTRIBUTE','Released Amount');
3904: OE_MSG_PUB.Add;
3905: END IF;
3906:

Line 3903: fnd_message.set_token('ATTRIBUTE','Released Amount');

3899: IF NOT OE_GLOBALS.Equal (p_header_rec.released_amount,
3900: l_old_header_rec.released_amount) THEN
3901: x_return_status := FND_API.G_RET_STS_ERROR;
3902: fnd_message.set_name('ONT', 'OE_BLKT_UPDATE_HDR_ATTRIBUTE');
3903: fnd_message.set_token('ATTRIBUTE','Released Amount');
3904: OE_MSG_PUB.Add;
3905: END IF;
3906:
3907: IF NOT OE_GLOBALS.Equal (p_header_rec.returned_amount,

Line 3910: fnd_message.set_name('ONT', 'OE_BLKT_UPDATE_HDR_ATTRIBUTE');

3906:
3907: IF NOT OE_GLOBALS.Equal (p_header_rec.returned_amount,
3908: l_old_header_rec.returned_amount) THEN
3909: x_return_status := FND_API.G_RET_STS_ERROR;
3910: fnd_message.set_name('ONT', 'OE_BLKT_UPDATE_HDR_ATTRIBUTE');
3911: fnd_message.set_token('ATTRIBUTE', 'Returned Amount');
3912: fnd_message.set_token('new amount', p_header_rec.returned_amount);
3913: fnd_message.set_token('old amount', l_old_header_rec.returned_amount);
3914: OE_MSG_PUB.Add;

Line 3911: fnd_message.set_token('ATTRIBUTE', 'Returned Amount');

3907: IF NOT OE_GLOBALS.Equal (p_header_rec.returned_amount,
3908: l_old_header_rec.returned_amount) THEN
3909: x_return_status := FND_API.G_RET_STS_ERROR;
3910: fnd_message.set_name('ONT', 'OE_BLKT_UPDATE_HDR_ATTRIBUTE');
3911: fnd_message.set_token('ATTRIBUTE', 'Returned Amount');
3912: fnd_message.set_token('new amount', p_header_rec.returned_amount);
3913: fnd_message.set_token('old amount', l_old_header_rec.returned_amount);
3914: OE_MSG_PUB.Add;
3915: END IF;

Line 3912: fnd_message.set_token('new amount', p_header_rec.returned_amount);

3908: l_old_header_rec.returned_amount) THEN
3909: x_return_status := FND_API.G_RET_STS_ERROR;
3910: fnd_message.set_name('ONT', 'OE_BLKT_UPDATE_HDR_ATTRIBUTE');
3911: fnd_message.set_token('ATTRIBUTE', 'Returned Amount');
3912: fnd_message.set_token('new amount', p_header_rec.returned_amount);
3913: fnd_message.set_token('old amount', l_old_header_rec.returned_amount);
3914: OE_MSG_PUB.Add;
3915: END IF;
3916:

Line 3913: fnd_message.set_token('old amount', l_old_header_rec.returned_amount);

3909: x_return_status := FND_API.G_RET_STS_ERROR;
3910: fnd_message.set_name('ONT', 'OE_BLKT_UPDATE_HDR_ATTRIBUTE');
3911: fnd_message.set_token('ATTRIBUTE', 'Returned Amount');
3912: fnd_message.set_token('new amount', p_header_rec.returned_amount);
3913: fnd_message.set_token('old amount', l_old_header_rec.returned_amount);
3914: OE_MSG_PUB.Add;
3915: END IF;
3916:
3917: IF NOT OE_GLOBALS.Equal (p_header_rec.fulfilled_amount,

Line 3920: fnd_message.set_name('ONT', 'OE_BLKT_UPDATE_HDR_ATTRIBUTE');

3916:
3917: IF NOT OE_GLOBALS.Equal (p_header_rec.fulfilled_amount,
3918: l_old_header_rec.fulfilled_amount) THEN
3919: x_return_status := FND_API.G_RET_STS_ERROR;
3920: fnd_message.set_name('ONT', 'OE_BLKT_UPDATE_HDR_ATTRIBUTE');
3921: fnd_message.set_token('ATTRIBUTE','Fulfilled Amount');
3922: fnd_message.set_token('new amount', p_header_rec.fulfilled_amount);
3923: fnd_message.set_token('old amount', l_old_header_rec.fulfilled_amount);
3924: OE_MSG_PUB.Add;

Line 3921: fnd_message.set_token('ATTRIBUTE','Fulfilled Amount');

3917: IF NOT OE_GLOBALS.Equal (p_header_rec.fulfilled_amount,
3918: l_old_header_rec.fulfilled_amount) THEN
3919: x_return_status := FND_API.G_RET_STS_ERROR;
3920: fnd_message.set_name('ONT', 'OE_BLKT_UPDATE_HDR_ATTRIBUTE');
3921: fnd_message.set_token('ATTRIBUTE','Fulfilled Amount');
3922: fnd_message.set_token('new amount', p_header_rec.fulfilled_amount);
3923: fnd_message.set_token('old amount', l_old_header_rec.fulfilled_amount);
3924: OE_MSG_PUB.Add;
3925: END IF;

Line 3922: fnd_message.set_token('new amount', p_header_rec.fulfilled_amount);

3918: l_old_header_rec.fulfilled_amount) THEN
3919: x_return_status := FND_API.G_RET_STS_ERROR;
3920: fnd_message.set_name('ONT', 'OE_BLKT_UPDATE_HDR_ATTRIBUTE');
3921: fnd_message.set_token('ATTRIBUTE','Fulfilled Amount');
3922: fnd_message.set_token('new amount', p_header_rec.fulfilled_amount);
3923: fnd_message.set_token('old amount', l_old_header_rec.fulfilled_amount);
3924: OE_MSG_PUB.Add;
3925: END IF;
3926:

Line 3923: fnd_message.set_token('old amount', l_old_header_rec.fulfilled_amount);

3919: x_return_status := FND_API.G_RET_STS_ERROR;
3920: fnd_message.set_name('ONT', 'OE_BLKT_UPDATE_HDR_ATTRIBUTE');
3921: fnd_message.set_token('ATTRIBUTE','Fulfilled Amount');
3922: fnd_message.set_token('new amount', p_header_rec.fulfilled_amount);
3923: fnd_message.set_token('old amount', l_old_header_rec.fulfilled_amount);
3924: OE_MSG_PUB.Add;
3925: END IF;
3926:
3927:

Line 3953: fnd_message.set_name('ONT', 'OE_BLKT_END_DATE_CONFLICT');

3949: AND ROWNUM = 1;
3950:
3951: IF l_dummy = 'ERROR' THEN
3952: x_return_status := FND_API.G_RET_STS_ERROR;
3953: fnd_message.set_name('ONT', 'OE_BLKT_END_DATE_CONFLICT');
3954: OE_MSG_PUB.Add;
3955: END IF;
3956:
3957: EXCEPTION

Line 3977: fnd_message.set_name('ONT', 'OE_BLKT_RELEASE_END_DATE');

3973: AND BLANKET_NUMBER = p_header_rec.order_number
3974: AND ROWNUM = 1;
3975: IF l_dummy = 'ERROR' THEN
3976: x_return_status := FND_API.G_RET_STS_ERROR;
3977: fnd_message.set_name('ONT', 'OE_BLKT_RELEASE_END_DATE');
3978: OE_MSG_PUB.Add;
3979: END IF;
3980:
3981: EXCEPTION

Line 4017: fnd_message.set_name('ONT', 'OE_BLKT_CLOSE_MIN_VALUES');

4013: OR BLANKET_MIN_QUANTITY < RELEASED_QUANTITY)
4014: AND ROWNUM = 1;
4015:
4016: IF l_dummy = 'WARNING' THEN
4017: fnd_message.set_name('ONT', 'OE_BLKT_CLOSE_MIN_VALUES');
4018: OE_MSG_PUB.Add;
4019: END IF;
4020: END IF;
4021: END IF;

Line 4038: fnd_message.set_name('ONT', 'OE_BLKT_UPDATE_MAX_LIMIT');

4034: l_old_header_rec.blanket_max_amount)
4035: AND p_header_rec.blanket_max_amount < p_header_rec.released_amount
4036: AND nvl(p_header_rec.override_amount_flag, 'N') = 'N' THEN
4037: x_return_status := FND_API.G_RET_STS_ERROR;
4038: fnd_message.set_name('ONT', 'OE_BLKT_UPDATE_MAX_LIMIT');
4039: OE_MSG_PUB.Add;
4040: END IF;
4041:
4042: -- Version Change

Line 4066: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_REVISION_NUM');

4062: <= l_old_header_rec.version_number
4063: THEN
4064:
4065: x_return_status := FND_API.G_RET_STS_ERROR;
4066: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_REVISION_NUM');
4067: OE_MSG_PUB.ADD;
4068:
4069: ELSIF p_header_rec.revision_change_reason_code IS NULL THEN
4070:

Line 4072: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');

4068:
4069: ELSIF p_header_rec.revision_change_reason_code IS NULL THEN
4070:
4071: x_return_status := FND_API.G_RET_STS_ERROR;
4072: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
4073: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Revision Reason');
4074: OE_MSG_PUB.ADD;
4075:
4076: ELSE

Line 4073: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Revision Reason');

4069: ELSIF p_header_rec.revision_change_reason_code IS NULL THEN
4070:
4071: x_return_status := FND_API.G_RET_STS_ERROR;
4072: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
4073: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Revision Reason');
4074: OE_MSG_PUB.ADD;
4075:
4076: ELSE
4077:

Line 4089: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_REASON_CODE');

4085: AND LOOKUP_CODE = p_header_rec.revision_change_reason_code;
4086:
4087: EXCEPTION
4088: WHEN NO_DATA_FOUND THEN
4089: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_REASON_CODE');
4090: FND_MESSAGE.SET_TOKEN('REASON_CODE', p_header_rec.revision_change_reason_code);
4091: OE_MSG_PUB.ADD;
4092: x_return_status := FND_API.G_RET_STS_ERROR;
4093: END;

Line 4090: FND_MESSAGE.SET_TOKEN('REASON_CODE', p_header_rec.revision_change_reason_code);

4086:
4087: EXCEPTION
4088: WHEN NO_DATA_FOUND THEN
4089: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_REASON_CODE');
4090: FND_MESSAGE.SET_TOKEN('REASON_CODE', p_header_rec.revision_change_reason_code);
4091: OE_MSG_PUB.ADD;
4092: x_return_status := FND_API.G_RET_STS_ERROR;
4093: END;
4094:

Line 6660: fnd_message.set_name('ONT','OE_LOCK_ROW_CHANGED');

6656: x_return_status := FND_API.G_RET_STS_ERROR;
6657:
6658: -- Release the lock
6659:
6660: fnd_message.set_name('ONT','OE_LOCK_ROW_CHANGED');
6661: OE_MSG_PUB.Add;
6662:
6663: END IF;
6664:

Line 6682: fnd_message.set_name('ONT','OE_LOCK_ROW_DELETED');

6678: if l_debug_level > 0 then
6679: oe_debug_pub.add('no data found in blanket lock_blanket', 1);
6680: end if;
6681:
6682: fnd_message.set_name('ONT','OE_LOCK_ROW_DELETED');
6683: OE_MSG_PUB.Add;
6684:
6685: OE_GLOBALS.G_LOCK_TEST := 'N';
6686:

Line 6695: fnd_message.set_name('ONT','OE_LOCK_ROW_ALREADY_LOCKED');

6691: if l_debug_level > 0 then
6692: oe_debug_pub.add('record_lock in blanket lock_blanket', 1);
6693: end if;
6694:
6695: fnd_message.set_name('ONT','OE_LOCK_ROW_ALREADY_LOCKED');
6696: OE_MSG_PUB.Add;
6697:
6698: OE_GLOBALS.G_LOCK_TEST := 'N';
6699:

Line 7216: fnd_message.set_name('ONT','OE_MISS_DOC_SEQ');

7212: end if;
7213:
7214: IF x_result <> FND_SEQNUM.SEQSUCC THEN
7215: IF x_result = FND_SEQNUM.NOTUSED THEN
7216: fnd_message.set_name('ONT','OE_MISS_DOC_SEQ');
7217: OE_MSG_PUB.Add;
7218: RAISE FND_API.G_EXC_ERROR;
7219: END IF;
7220:

Line 7253: fnd_message.set_name('ONT','OE_BLKT_INVALID_DOC_SEQ');

7249: INTO l_column_name
7250: FROM fnd_lookups
7251: WHERE lookup_type = 'SEQUENCE_METHOD'
7252: AND lookup_code = t;
7253: fnd_message.set_name('ONT','OE_BLKT_INVALID_DOC_SEQ');
7254: fnd_message.set_token('Document Sequence', l_column_name);
7255: OE_MSG_PUB.Add;
7256:
7257: RAISE FND_API.G_EXC_ERROR;

Line 7254: fnd_message.set_token('Document Sequence', l_column_name);

7250: FROM fnd_lookups
7251: WHERE lookup_type = 'SEQUENCE_METHOD'
7252: AND lookup_code = t;
7253: fnd_message.set_name('ONT','OE_BLKT_INVALID_DOC_SEQ');
7254: fnd_message.set_token('Document Sequence', l_column_name);
7255: OE_MSG_PUB.Add;
7256:
7257: RAISE FND_API.G_EXC_ERROR;
7258: -- x_doc_sequence_value := p_x_header_rec.order_number;

Line 7268: fnd_message.set_name('ONT','OE_BLKT_NUM_EXISTS');

7264: OE_BLANKET_HEADERS_ALL
7265: WHERE order_number = X_doc_sequence_value;
7266:
7267: IF lcount > 0 THEN
7268: fnd_message.set_name('ONT','OE_BLKT_NUM_EXISTS');
7269: OE_MSG_PUB.Add;
7270: RAISE FND_API.G_EXC_ERROR;
7271: END IF;
7272: END IF; -- Blanket category code not null

Line 7522: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_LINE_NUMBER_EXISTS');

7518: END;
7519:
7520: END IF;
7521: IF l_valid = 'N' THEN
7522: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_LINE_NUMBER_EXISTS');
7523: OE_MSG_PUB.ADD;
7524: RAISE FND_API.G_EXC_ERROR;
7525: END IF;
7526:

Line 7658: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_UNIQUE_ITEM_VIOLATION');

7654: );
7655:
7656: if (lcount > 0) then
7657: -- ERROR: date overlap problem. Show error and
7658: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_UNIQUE_ITEM_VIOLATION');
7659: OE_MSG_PUB.ADD;
7660: RAISE FND_API.G_EXC_ERROR;
7661: end if;
7662:

Line 7972: fnd_message.set_name('ONT','OE_CPY_COPY_FAILED');

7968: , x_line_tbl => x_line_tbl
7969: );
7970:
7971: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
7972: fnd_message.set_name('ONT','OE_CPY_COPY_FAILED');
7973: OE_MSG_PUB.Add;
7974: ROLLBACK TO SAVEPOINT Copy_Blanket;
7975: RAISE FND_API.G_EXC_ERROR;
7976: END IF;

Line 7996: fnd_message.set_name('ONT','OE_CPY_COPY_FAILED');

7992: x_return_status := nvl(l_return_status, x_return_status);
7993: END IF;
7994:
7995: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
7996: fnd_message.set_name('ONT','OE_CPY_COPY_FAILED');
7997: OE_MSG_PUB.Add;
7998: ROLLBACK TO SAVEPOINT Copy_Blanket;
7999: RAISE FND_API.G_EXC_ERROR;
8000: ELSE

Line 8001: fnd_message.set_name('ONT','OE_BL_COPY_SUCCESS');

7997: OE_MSG_PUB.Add;
7998: ROLLBACK TO SAVEPOINT Copy_Blanket;
7999: RAISE FND_API.G_EXC_ERROR;
8000: ELSE
8001: fnd_message.set_name('ONT','OE_BL_COPY_SUCCESS');
8002: -- Bug 3337297
8003: -- Set blanket number token
8004: fnd_message.set_token('BLANKET_NUMBER',x_header_rec.order_number);
8005: OE_MSG_PUB.Add;

Line 8004: fnd_message.set_token('BLANKET_NUMBER',x_header_rec.order_number);

8000: ELSE
8001: fnd_message.set_name('ONT','OE_BL_COPY_SUCCESS');
8002: -- Bug 3337297
8003: -- Set blanket number token
8004: fnd_message.set_token('BLANKET_NUMBER',x_header_rec.order_number);
8005: OE_MSG_PUB.Add;
8006: x_header_id := x_header_rec.header_id;
8007: END IF;
8008:

Line 8068: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_MIN_MAX_RANGE');

8064: AND (p_min_value > p_max_value) THEN
8065: if l_debug_level > 0 then
8066: oe_debug_pub.add('Invalid min/max for attribute :'||p_attribute);
8067: end if;
8068: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_MIN_MAX_RANGE');
8069: FND_MESSAGE.SET_TOKEN('MIN', p_min_value);
8070: FND_MESSAGE.SET_TOKEN('MAX', p_max_value);
8071: OE_MSG_PUB.ADD;
8072: x_return_status := FND_API.G_RET_STS_ERROR;

Line 8069: FND_MESSAGE.SET_TOKEN('MIN', p_min_value);

8065: if l_debug_level > 0 then
8066: oe_debug_pub.add('Invalid min/max for attribute :'||p_attribute);
8067: end if;
8068: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_MIN_MAX_RANGE');
8069: FND_MESSAGE.SET_TOKEN('MIN', p_min_value);
8070: FND_MESSAGE.SET_TOKEN('MAX', p_max_value);
8071: OE_MSG_PUB.ADD;
8072: x_return_status := FND_API.G_RET_STS_ERROR;
8073: END IF;

Line 8070: FND_MESSAGE.SET_TOKEN('MAX', p_max_value);

8066: oe_debug_pub.add('Invalid min/max for attribute :'||p_attribute);
8067: end if;
8068: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_MIN_MAX_RANGE');
8069: FND_MESSAGE.SET_TOKEN('MIN', p_min_value);
8070: FND_MESSAGE.SET_TOKEN('MAX', p_max_value);
8071: OE_MSG_PUB.ADD;
8072: x_return_status := FND_API.G_RET_STS_ERROR;
8073: END IF;
8074:

Line 9472: fnd_message.set_name('ONT','OE_INVALIDATES_CUSTOMER_ITEM');

9468: ELSIF to_number(l_attribute_value) = p_x_line_rec.inventory_item_id THEN
9469: NULL;
9470: ELSE
9471: oe_debug_pub.add('Issue error message', 1);
9472: fnd_message.set_name('ONT','OE_INVALIDATES_CUSTOMER_ITEM');
9473: OE_MSG_PUB.Add;
9474: x_return_status := FND_API.G_RET_STS_ERROR;
9475: END IF;
9476: END Get_Inventory_Item;

Line 9536: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');

9532: oe_debug_pub.add ('OE_blanket_util.validate_sold_to Blanket In ship to No data found',2);
9533: end if;
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

Line 9537: FND_MESSAGE.SET_TOKEN('ATTRIBUTE'

9533: end if;
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

Line 9569: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');

9565: oe_debug_pub.add ('OE_blanket_util.validate_sold_to Blanket In deliver No data found',2);
9566: end if;
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

Line 9570: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

9566: end if;
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

Line 9599: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');

9595: oe_debug_pub.add ('OE_blanket_util.validate_sold_to Blanket In invoice No data found',2);
9596: end if;
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

Line 9600: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

9596: end if;
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

Line 9676: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_DATE_RANGE');

9672: ,p_source_document_type_id => null);
9673:
9674: if (trunc(l_header_rec.end_date_active) < trunc(sysdate))
9675: then
9676: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_DATE_RANGE');
9677: OE_MSG_PUB.ADD;
9678: x_return_status := FND_API.G_RET_STS_ERROR;
9679: end if;
9680:

Line 9707: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_DATE_RANGE');

9703:
9704: if (l_line_tbl(K).end_date_active is not NULL and
9705: (l_line_tbl(K).start_date_active)
9706: > (l_line_tbl(K).end_date_active)) THEN
9707: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_DATE_RANGE');
9708: OE_MSG_PUB.ADD;
9709: x_return_status := FND_API.G_RET_STS_ERROR;
9710: end if;
9711:

Line 9714: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_DATE_RANGE');

9710: end if;
9711:
9712: if( trunc(l_line_tbl(K).end_date_active) < trunc(sysdate))
9713: then
9714: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_DATE_RANGE');
9715: OE_MSG_PUB.ADD;
9716: x_return_status := FND_API.G_RET_STS_ERROR;
9717: end if;
9718: