eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_BLKT_RELEASE_UTIL dependencies on FND_MESSAGE

Line 178: FND_MESSAGE.SET_NAME('ONT','OE_BL_MISSING_CONV_RATE');

174: WHEN No_Conversion_Rate THEN
175: if l_debug_level > 0 then
176: oe_debug_pub.add('no rate found in either blanket or sob currency');
177: end if;
178: FND_MESSAGE.SET_NAME('ONT','OE_BL_MISSING_CONV_RATE');
179: FND_MESSAGE.SET_TOKEN('BLANKET_CURRENCY',p_to_currency);
180: OE_MSG_PUB.ADD;
181: RAISE FND_API.G_EXC_ERROR;
182: WHEN OTHERS THEN

Line 179: FND_MESSAGE.SET_TOKEN('BLANKET_CURRENCY',p_to_currency);

175: if l_debug_level > 0 then
176: oe_debug_pub.add('no rate found in either blanket or sob currency');
177: end if;
178: FND_MESSAGE.SET_NAME('ONT','OE_BL_MISSING_CONV_RATE');
179: FND_MESSAGE.SET_TOKEN('BLANKET_CURRENCY',p_to_currency);
180: OE_MSG_PUB.ADD;
181: RAISE FND_API.G_EXC_ERROR;
182: WHEN OTHERS THEN
183: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 369: FND_MESSAGE.Set_Name('ONT','OE_BL_LOCKED');

365: end if;
366:
367: EXCEPTION
368: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
369: FND_MESSAGE.Set_Name('ONT','OE_BL_LOCKED');
370: FND_MESSAGE.Set_Token('BLANKET_NUMBER',p_blanket_number);
371: OE_MSG_PUB.Add;
372: RAISE FND_API.G_EXC_ERROR;
373: WHEN OTHERS THEN

Line 370: FND_MESSAGE.Set_Token('BLANKET_NUMBER',p_blanket_number);

366:
367: EXCEPTION
368: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
369: FND_MESSAGE.Set_Name('ONT','OE_BL_LOCKED');
370: FND_MESSAGE.Set_Token('BLANKET_NUMBER',p_blanket_number);
371: OE_MSG_PUB.Add;
372: RAISE FND_API.G_EXC_ERROR;
373: WHEN OTHERS THEN
374: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 479: FND_MESSAGE.SET_NAME('ONT','OE_BL_UOM_CONV_FAILED');

475: if l_debug_level > 0 then
476: oe_debug_pub.add('conv new qty :'||l_quantity);
477: end if;
478: IF l_quantity < 0 THEN
479: FND_MESSAGE.SET_NAME('ONT','OE_BL_UOM_CONV_FAILED');
480: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Line_Number(p_line_id));
481: FND_MESSAGE.SET_TOKEN('BLANKET_UOM',
482: g_blkt_line_tbl(l_blanket_line_id).uom);
483: OE_MSG_PUB.ADD;

Line 480: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Line_Number(p_line_id));

476: oe_debug_pub.add('conv new qty :'||l_quantity);
477: end if;
478: IF l_quantity < 0 THEN
479: FND_MESSAGE.SET_NAME('ONT','OE_BL_UOM_CONV_FAILED');
480: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Line_Number(p_line_id));
481: FND_MESSAGE.SET_TOKEN('BLANKET_UOM',
482: g_blkt_line_tbl(l_blanket_line_id).uom);
483: OE_MSG_PUB.ADD;
484: RAISE FND_API.G_EXC_ERROR;

Line 481: FND_MESSAGE.SET_TOKEN('BLANKET_UOM',

477: end if;
478: IF l_quantity < 0 THEN
479: FND_MESSAGE.SET_NAME('ONT','OE_BL_UOM_CONV_FAILED');
480: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Line_Number(p_line_id));
481: FND_MESSAGE.SET_TOKEN('BLANKET_UOM',
482: g_blkt_line_tbl(l_blanket_line_id).uom);
483: OE_MSG_PUB.ADD;
484: RAISE FND_API.G_EXC_ERROR;
485: END IF;

Line 501: FND_MESSAGE.SET_NAME('ONT','OE_BL_UOM_CONV_FAILED');

497: if l_debug_level > 0 then
498: oe_debug_pub.add('conv old qty :'||l_quantity);
499: end if;
500: IF l_old_quantity < 0 THEN
501: FND_MESSAGE.SET_NAME('ONT','OE_BL_UOM_CONV_FAILED');
502: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Line_Number(p_line_id));
503: FND_MESSAGE.SET_TOKEN('BLANKET_UOM',
504: g_blkt_line_tbl(l_blanket_line_id).uom);
505: OE_MSG_PUB.ADD;

Line 502: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Line_Number(p_line_id));

498: oe_debug_pub.add('conv old qty :'||l_quantity);
499: end if;
500: IF l_old_quantity < 0 THEN
501: FND_MESSAGE.SET_NAME('ONT','OE_BL_UOM_CONV_FAILED');
502: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Line_Number(p_line_id));
503: FND_MESSAGE.SET_TOKEN('BLANKET_UOM',
504: g_blkt_line_tbl(l_blanket_line_id).uom);
505: OE_MSG_PUB.ADD;
506: RAISE FND_API.G_EXC_ERROR;

Line 503: FND_MESSAGE.SET_TOKEN('BLANKET_UOM',

499: end if;
500: IF l_old_quantity < 0 THEN
501: FND_MESSAGE.SET_NAME('ONT','OE_BL_UOM_CONV_FAILED');
502: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Line_Number(p_line_id));
503: FND_MESSAGE.SET_TOKEN('BLANKET_UOM',
504: g_blkt_line_tbl(l_blanket_line_id).uom);
505: OE_MSG_PUB.ADD;
506: RAISE FND_API.G_EXC_ERROR;
507: END IF;

Line 530: FND_MESSAGE.SET_NAME('ONT','OE_BL_MISS_CONVERSION_TYPE');

526: <> g_blkt_hdr_tbl(l_blanket_header_id).currency_code
527: THEN
528:
529: IF g_blkt_hdr_tbl(l_blanket_header_id).conversion_type_code IS NULL THEN
530: FND_MESSAGE.SET_NAME('ONT','OE_BL_MISS_CONVERSION_TYPE');
531: FND_MESSAGE.SET_TOKEN('BLANKET_NUMBER',p_blanket_number);
532: oe_msg_pub.add;
533: RAISE FND_API.G_EXC_ERROR;
534: END IF;

Line 531: FND_MESSAGE.SET_TOKEN('BLANKET_NUMBER',p_blanket_number);

527: THEN
528:
529: IF g_blkt_hdr_tbl(l_blanket_header_id).conversion_type_code IS NULL THEN
530: FND_MESSAGE.SET_NAME('ONT','OE_BL_MISS_CONVERSION_TYPE');
531: FND_MESSAGE.SET_TOKEN('BLANKET_NUMBER',p_blanket_number);
532: oe_msg_pub.add;
533: RAISE FND_API.G_EXC_ERROR;
534: END IF;
535:

Line 602: FND_MESSAGE.SET_NAME('ONT','OE_BL_MIN_MAX_SHIPMENT_QTY');

598: THEN
599: -- If shipment line, only a warning is issued. Error status is not set.
600: IF p_line_set_id IS NOT NULL THEN
601: IF g_blkt_line_tbl(l_blanket_line_id).OVERRIDE_RELEASE_CONTROLS_FLAG = 'N' THEN
602: FND_MESSAGE.SET_NAME('ONT','OE_BL_MIN_MAX_SHIPMENT_QTY');
603: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Line_Number(p_line_id));
604: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUMBER'
605: ,Get_Shipment_Number(p_line_id));
606: FND_MESSAGE.SET_TOKEN('BLANKET_UOM',

Line 603: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Line_Number(p_line_id));

599: -- If shipment line, only a warning is issued. Error status is not set.
600: IF p_line_set_id IS NOT NULL THEN
601: IF g_blkt_line_tbl(l_blanket_line_id).OVERRIDE_RELEASE_CONTROLS_FLAG = 'N' THEN
602: FND_MESSAGE.SET_NAME('ONT','OE_BL_MIN_MAX_SHIPMENT_QTY');
603: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Line_Number(p_line_id));
604: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUMBER'
605: ,Get_Shipment_Number(p_line_id));
606: FND_MESSAGE.SET_TOKEN('BLANKET_UOM',
607: g_blkt_line_tbl(l_blanket_line_id).uom);

Line 604: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUMBER'

600: IF p_line_set_id IS NOT NULL THEN
601: IF g_blkt_line_tbl(l_blanket_line_id).OVERRIDE_RELEASE_CONTROLS_FLAG = 'N' THEN
602: FND_MESSAGE.SET_NAME('ONT','OE_BL_MIN_MAX_SHIPMENT_QTY');
603: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Line_Number(p_line_id));
604: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUMBER'
605: ,Get_Shipment_Number(p_line_id));
606: FND_MESSAGE.SET_TOKEN('BLANKET_UOM',
607: g_blkt_line_tbl(l_blanket_line_id).uom);
608: FND_MESSAGE.SET_TOKEN('MINIMUM',

Line 606: FND_MESSAGE.SET_TOKEN('BLANKET_UOM',

602: FND_MESSAGE.SET_NAME('ONT','OE_BL_MIN_MAX_SHIPMENT_QTY');
603: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Line_Number(p_line_id));
604: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUMBER'
605: ,Get_Shipment_Number(p_line_id));
606: FND_MESSAGE.SET_TOKEN('BLANKET_UOM',
607: g_blkt_line_tbl(l_blanket_line_id).uom);
608: FND_MESSAGE.SET_TOKEN('MINIMUM',
609: g_blkt_line_tbl(l_blanket_line_id).min_release_quantity);
610: FND_MESSAGE.SET_TOKEN('MAXIMUM',

Line 608: FND_MESSAGE.SET_TOKEN('MINIMUM',

604: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUMBER'
605: ,Get_Shipment_Number(p_line_id));
606: FND_MESSAGE.SET_TOKEN('BLANKET_UOM',
607: g_blkt_line_tbl(l_blanket_line_id).uom);
608: FND_MESSAGE.SET_TOKEN('MINIMUM',
609: g_blkt_line_tbl(l_blanket_line_id).min_release_quantity);
610: FND_MESSAGE.SET_TOKEN('MAXIMUM',
611: g_blkt_line_tbl(l_blanket_line_id).max_release_quantity);
612: oe_msg_pub.add;

Line 610: FND_MESSAGE.SET_TOKEN('MAXIMUM',

606: FND_MESSAGE.SET_TOKEN('BLANKET_UOM',
607: g_blkt_line_tbl(l_blanket_line_id).uom);
608: FND_MESSAGE.SET_TOKEN('MINIMUM',
609: g_blkt_line_tbl(l_blanket_line_id).min_release_quantity);
610: FND_MESSAGE.SET_TOKEN('MAXIMUM',
611: g_blkt_line_tbl(l_blanket_line_id).max_release_quantity);
612: oe_msg_pub.add;
613: ELSE
614: IF NVL(FND_PROFILE.VALUE('ONT_BSA_MIN_MAX_VIOLATION'),'N') = 'Y' THEN

Line 615: FND_MESSAGE.SET_NAME('ONT','OE_BL_MIN_MAX_SHIPMENT_QTY');

611: g_blkt_line_tbl(l_blanket_line_id).max_release_quantity);
612: oe_msg_pub.add;
613: ELSE
614: IF NVL(FND_PROFILE.VALUE('ONT_BSA_MIN_MAX_VIOLATION'),'N') = 'Y' THEN
615: FND_MESSAGE.SET_NAME('ONT','OE_BL_MIN_MAX_SHIPMENT_QTY');
616: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Line_Number(p_line_id));
617: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUMBER'
618: ,Get_Shipment_Number(p_line_id));
619: FND_MESSAGE.SET_TOKEN('BLANKET_UOM',

Line 616: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Line_Number(p_line_id));

612: oe_msg_pub.add;
613: ELSE
614: IF NVL(FND_PROFILE.VALUE('ONT_BSA_MIN_MAX_VIOLATION'),'N') = 'Y' THEN
615: FND_MESSAGE.SET_NAME('ONT','OE_BL_MIN_MAX_SHIPMENT_QTY');
616: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Line_Number(p_line_id));
617: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUMBER'
618: ,Get_Shipment_Number(p_line_id));
619: FND_MESSAGE.SET_TOKEN('BLANKET_UOM',
620: g_blkt_line_tbl(l_blanket_line_id).uom);

Line 617: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUMBER'

613: ELSE
614: IF NVL(FND_PROFILE.VALUE('ONT_BSA_MIN_MAX_VIOLATION'),'N') = 'Y' THEN
615: FND_MESSAGE.SET_NAME('ONT','OE_BL_MIN_MAX_SHIPMENT_QTY');
616: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Line_Number(p_line_id));
617: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUMBER'
618: ,Get_Shipment_Number(p_line_id));
619: FND_MESSAGE.SET_TOKEN('BLANKET_UOM',
620: g_blkt_line_tbl(l_blanket_line_id).uom);
621: FND_MESSAGE.SET_TOKEN('MINIMUM',

Line 619: FND_MESSAGE.SET_TOKEN('BLANKET_UOM',

615: FND_MESSAGE.SET_NAME('ONT','OE_BL_MIN_MAX_SHIPMENT_QTY');
616: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Line_Number(p_line_id));
617: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUMBER'
618: ,Get_Shipment_Number(p_line_id));
619: FND_MESSAGE.SET_TOKEN('BLANKET_UOM',
620: g_blkt_line_tbl(l_blanket_line_id).uom);
621: FND_MESSAGE.SET_TOKEN('MINIMUM',
622: g_blkt_line_tbl(l_blanket_line_id).min_release_quantity);
623: FND_MESSAGE.SET_TOKEN('MAXIMUM',

Line 621: FND_MESSAGE.SET_TOKEN('MINIMUM',

617: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUMBER'
618: ,Get_Shipment_Number(p_line_id));
619: FND_MESSAGE.SET_TOKEN('BLANKET_UOM',
620: g_blkt_line_tbl(l_blanket_line_id).uom);
621: FND_MESSAGE.SET_TOKEN('MINIMUM',
622: g_blkt_line_tbl(l_blanket_line_id).min_release_quantity);
623: FND_MESSAGE.SET_TOKEN('MAXIMUM',
624: g_blkt_line_tbl(l_blanket_line_id).max_release_quantity);
625: oe_msg_pub.add;

Line 623: FND_MESSAGE.SET_TOKEN('MAXIMUM',

619: FND_MESSAGE.SET_TOKEN('BLANKET_UOM',
620: g_blkt_line_tbl(l_blanket_line_id).uom);
621: FND_MESSAGE.SET_TOKEN('MINIMUM',
622: g_blkt_line_tbl(l_blanket_line_id).min_release_quantity);
623: FND_MESSAGE.SET_TOKEN('MAXIMUM',
624: g_blkt_line_tbl(l_blanket_line_id).max_release_quantity);
625: oe_msg_pub.add;
626: END IF;
627: END IF;

Line 632: FND_MESSAGE.SET_NAME('ONT','OE_BL_MIN_MAX_REL_QTY');

628:
629: -- For regular lines, raise error.
630: ELSE
631: IF g_blkt_line_tbl(l_blanket_line_id).OVERRIDE_RELEASE_CONTROLS_FLAG = 'N' THEN
632: FND_MESSAGE.SET_NAME('ONT','OE_BL_MIN_MAX_REL_QTY');
633: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Line_Number(p_line_id));
634: FND_MESSAGE.SET_TOKEN('BLANKET_UOM',
635: g_blkt_line_tbl(l_blanket_line_id).uom);
636: FND_MESSAGE.SET_TOKEN('MINIMUM',

Line 633: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Line_Number(p_line_id));

629: -- For regular lines, raise error.
630: ELSE
631: IF g_blkt_line_tbl(l_blanket_line_id).OVERRIDE_RELEASE_CONTROLS_FLAG = 'N' THEN
632: FND_MESSAGE.SET_NAME('ONT','OE_BL_MIN_MAX_REL_QTY');
633: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Line_Number(p_line_id));
634: FND_MESSAGE.SET_TOKEN('BLANKET_UOM',
635: g_blkt_line_tbl(l_blanket_line_id).uom);
636: FND_MESSAGE.SET_TOKEN('MINIMUM',
637: g_blkt_line_tbl(l_blanket_line_id).min_release_quantity);

Line 634: FND_MESSAGE.SET_TOKEN('BLANKET_UOM',

630: ELSE
631: IF g_blkt_line_tbl(l_blanket_line_id).OVERRIDE_RELEASE_CONTROLS_FLAG = 'N' THEN
632: FND_MESSAGE.SET_NAME('ONT','OE_BL_MIN_MAX_REL_QTY');
633: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Line_Number(p_line_id));
634: FND_MESSAGE.SET_TOKEN('BLANKET_UOM',
635: g_blkt_line_tbl(l_blanket_line_id).uom);
636: FND_MESSAGE.SET_TOKEN('MINIMUM',
637: g_blkt_line_tbl(l_blanket_line_id).min_release_quantity);
638: FND_MESSAGE.SET_TOKEN('MAXIMUM',

Line 636: FND_MESSAGE.SET_TOKEN('MINIMUM',

632: FND_MESSAGE.SET_NAME('ONT','OE_BL_MIN_MAX_REL_QTY');
633: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Line_Number(p_line_id));
634: FND_MESSAGE.SET_TOKEN('BLANKET_UOM',
635: g_blkt_line_tbl(l_blanket_line_id).uom);
636: FND_MESSAGE.SET_TOKEN('MINIMUM',
637: g_blkt_line_tbl(l_blanket_line_id).min_release_quantity);
638: FND_MESSAGE.SET_TOKEN('MAXIMUM',
639: g_blkt_line_tbl(l_blanket_line_id).max_release_quantity);
640: oe_msg_pub.add;

Line 638: FND_MESSAGE.SET_TOKEN('MAXIMUM',

634: FND_MESSAGE.SET_TOKEN('BLANKET_UOM',
635: g_blkt_line_tbl(l_blanket_line_id).uom);
636: FND_MESSAGE.SET_TOKEN('MINIMUM',
637: g_blkt_line_tbl(l_blanket_line_id).min_release_quantity);
638: FND_MESSAGE.SET_TOKEN('MAXIMUM',
639: g_blkt_line_tbl(l_blanket_line_id).max_release_quantity);
640: oe_msg_pub.add;
641: x_return_status := FND_API.G_RET_STS_ERROR;
642:

Line 645: FND_MESSAGE.SET_NAME('ONT','OE_BL_MIN_MAX_REL_QTY');

641: x_return_status := FND_API.G_RET_STS_ERROR;
642:
643: ELSE
644: IF NVL(FND_PROFILE.VALUE('ONT_BSA_MIN_MAX_VIOLATION'),'N') = 'Y' THEN
645: FND_MESSAGE.SET_NAME('ONT','OE_BL_MIN_MAX_REL_QTY');
646: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Line_Number(p_line_id));
647: FND_MESSAGE.SET_TOKEN('BLANKET_UOM',
648: g_blkt_line_tbl(l_blanket_line_id).uom);
649: FND_MESSAGE.SET_TOKEN('MINIMUM',

Line 646: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Line_Number(p_line_id));

642:
643: ELSE
644: IF NVL(FND_PROFILE.VALUE('ONT_BSA_MIN_MAX_VIOLATION'),'N') = 'Y' THEN
645: FND_MESSAGE.SET_NAME('ONT','OE_BL_MIN_MAX_REL_QTY');
646: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Line_Number(p_line_id));
647: FND_MESSAGE.SET_TOKEN('BLANKET_UOM',
648: g_blkt_line_tbl(l_blanket_line_id).uom);
649: FND_MESSAGE.SET_TOKEN('MINIMUM',
650: g_blkt_line_tbl(l_blanket_line_id).min_release_quantity);

Line 647: FND_MESSAGE.SET_TOKEN('BLANKET_UOM',

643: ELSE
644: IF NVL(FND_PROFILE.VALUE('ONT_BSA_MIN_MAX_VIOLATION'),'N') = 'Y' THEN
645: FND_MESSAGE.SET_NAME('ONT','OE_BL_MIN_MAX_REL_QTY');
646: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Line_Number(p_line_id));
647: FND_MESSAGE.SET_TOKEN('BLANKET_UOM',
648: g_blkt_line_tbl(l_blanket_line_id).uom);
649: FND_MESSAGE.SET_TOKEN('MINIMUM',
650: g_blkt_line_tbl(l_blanket_line_id).min_release_quantity);
651: FND_MESSAGE.SET_TOKEN('MAXIMUM',

Line 649: FND_MESSAGE.SET_TOKEN('MINIMUM',

645: FND_MESSAGE.SET_NAME('ONT','OE_BL_MIN_MAX_REL_QTY');
646: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Line_Number(p_line_id));
647: FND_MESSAGE.SET_TOKEN('BLANKET_UOM',
648: g_blkt_line_tbl(l_blanket_line_id).uom);
649: FND_MESSAGE.SET_TOKEN('MINIMUM',
650: g_blkt_line_tbl(l_blanket_line_id).min_release_quantity);
651: FND_MESSAGE.SET_TOKEN('MAXIMUM',
652: g_blkt_line_tbl(l_blanket_line_id).max_release_quantity);
653: oe_msg_pub.add;

Line 651: FND_MESSAGE.SET_TOKEN('MAXIMUM',

647: FND_MESSAGE.SET_TOKEN('BLANKET_UOM',
648: g_blkt_line_tbl(l_blanket_line_id).uom);
649: FND_MESSAGE.SET_TOKEN('MINIMUM',
650: g_blkt_line_tbl(l_blanket_line_id).min_release_quantity);
651: FND_MESSAGE.SET_TOKEN('MAXIMUM',
652: g_blkt_line_tbl(l_blanket_line_id).max_release_quantity);
653: oe_msg_pub.add;
654: END IF;
655:

Line 683: FND_MESSAGE.SET_NAME('ONT','OE_BL_MIN_MAX_SHIPMENT_AMT');

679: THEN
680: -- If shipment line, only a warning is issued. Error status is not set.
681: IF p_line_set_id IS NOT NULL THEN
682: IF g_blkt_line_tbl(l_blanket_line_id).OVERRIDE_RELEASE_CONTROLS_FLAG = 'N' THEN
683: FND_MESSAGE.SET_NAME('ONT','OE_BL_MIN_MAX_SHIPMENT_AMT');
684: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Line_Number(p_line_id));
685: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUMBER'
686: ,Get_Shipment_Number(p_line_id));
687: FND_MESSAGE.SET_TOKEN('BLANKET_CURRENCY',

Line 684: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Line_Number(p_line_id));

680: -- If shipment line, only a warning is issued. Error status is not set.
681: IF p_line_set_id IS NOT NULL THEN
682: IF g_blkt_line_tbl(l_blanket_line_id).OVERRIDE_RELEASE_CONTROLS_FLAG = 'N' THEN
683: FND_MESSAGE.SET_NAME('ONT','OE_BL_MIN_MAX_SHIPMENT_AMT');
684: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Line_Number(p_line_id));
685: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUMBER'
686: ,Get_Shipment_Number(p_line_id));
687: FND_MESSAGE.SET_TOKEN('BLANKET_CURRENCY',
688: g_blkt_hdr_tbl(l_blanket_header_id).currency_code);

Line 685: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUMBER'

681: IF p_line_set_id IS NOT NULL THEN
682: IF g_blkt_line_tbl(l_blanket_line_id).OVERRIDE_RELEASE_CONTROLS_FLAG = 'N' THEN
683: FND_MESSAGE.SET_NAME('ONT','OE_BL_MIN_MAX_SHIPMENT_AMT');
684: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Line_Number(p_line_id));
685: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUMBER'
686: ,Get_Shipment_Number(p_line_id));
687: FND_MESSAGE.SET_TOKEN('BLANKET_CURRENCY',
688: g_blkt_hdr_tbl(l_blanket_header_id).currency_code);
689: FND_MESSAGE.SET_TOKEN('MINIMUM',

Line 687: FND_MESSAGE.SET_TOKEN('BLANKET_CURRENCY',

683: FND_MESSAGE.SET_NAME('ONT','OE_BL_MIN_MAX_SHIPMENT_AMT');
684: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Line_Number(p_line_id));
685: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUMBER'
686: ,Get_Shipment_Number(p_line_id));
687: FND_MESSAGE.SET_TOKEN('BLANKET_CURRENCY',
688: g_blkt_hdr_tbl(l_blanket_header_id).currency_code);
689: FND_MESSAGE.SET_TOKEN('MINIMUM',
690: g_blkt_line_tbl(l_blanket_line_id).min_release_amount);
691: FND_MESSAGE.SET_TOKEN('MAXIMUM',

Line 689: FND_MESSAGE.SET_TOKEN('MINIMUM',

685: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUMBER'
686: ,Get_Shipment_Number(p_line_id));
687: FND_MESSAGE.SET_TOKEN('BLANKET_CURRENCY',
688: g_blkt_hdr_tbl(l_blanket_header_id).currency_code);
689: FND_MESSAGE.SET_TOKEN('MINIMUM',
690: g_blkt_line_tbl(l_blanket_line_id).min_release_amount);
691: FND_MESSAGE.SET_TOKEN('MAXIMUM',
692: g_blkt_line_tbl(l_blanket_line_id).max_release_amount);
693: oe_msg_pub.add;

Line 691: FND_MESSAGE.SET_TOKEN('MAXIMUM',

687: FND_MESSAGE.SET_TOKEN('BLANKET_CURRENCY',
688: g_blkt_hdr_tbl(l_blanket_header_id).currency_code);
689: FND_MESSAGE.SET_TOKEN('MINIMUM',
690: g_blkt_line_tbl(l_blanket_line_id).min_release_amount);
691: FND_MESSAGE.SET_TOKEN('MAXIMUM',
692: g_blkt_line_tbl(l_blanket_line_id).max_release_amount);
693: oe_msg_pub.add;
694: ELSE
695: IF NVL(FND_PROFILE.VALUE('ONT_BSA_MIN_MAX_VIOLATION'),'N') = 'Y' THEN

Line 696: FND_MESSAGE.SET_NAME('ONT','OE_BL_MIN_MAX_SHIPMENT_AMT');

692: g_blkt_line_tbl(l_blanket_line_id).max_release_amount);
693: oe_msg_pub.add;
694: ELSE
695: IF NVL(FND_PROFILE.VALUE('ONT_BSA_MIN_MAX_VIOLATION'),'N') = 'Y' THEN
696: FND_MESSAGE.SET_NAME('ONT','OE_BL_MIN_MAX_SHIPMENT_AMT');
697: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Line_Number(p_line_id));
698: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUMBER'
699: ,Get_Shipment_Number(p_line_id));
700: FND_MESSAGE.SET_TOKEN('BLANKET_CURRENCY',

Line 697: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Line_Number(p_line_id));

693: oe_msg_pub.add;
694: ELSE
695: IF NVL(FND_PROFILE.VALUE('ONT_BSA_MIN_MAX_VIOLATION'),'N') = 'Y' THEN
696: FND_MESSAGE.SET_NAME('ONT','OE_BL_MIN_MAX_SHIPMENT_AMT');
697: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Line_Number(p_line_id));
698: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUMBER'
699: ,Get_Shipment_Number(p_line_id));
700: FND_MESSAGE.SET_TOKEN('BLANKET_CURRENCY',
701: g_blkt_hdr_tbl(l_blanket_header_id).currency_code);

Line 698: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUMBER'

694: ELSE
695: IF NVL(FND_PROFILE.VALUE('ONT_BSA_MIN_MAX_VIOLATION'),'N') = 'Y' THEN
696: FND_MESSAGE.SET_NAME('ONT','OE_BL_MIN_MAX_SHIPMENT_AMT');
697: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Line_Number(p_line_id));
698: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUMBER'
699: ,Get_Shipment_Number(p_line_id));
700: FND_MESSAGE.SET_TOKEN('BLANKET_CURRENCY',
701: g_blkt_hdr_tbl(l_blanket_header_id).currency_code);
702: FND_MESSAGE.SET_TOKEN('MINIMUM',

Line 700: FND_MESSAGE.SET_TOKEN('BLANKET_CURRENCY',

696: FND_MESSAGE.SET_NAME('ONT','OE_BL_MIN_MAX_SHIPMENT_AMT');
697: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Line_Number(p_line_id));
698: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUMBER'
699: ,Get_Shipment_Number(p_line_id));
700: FND_MESSAGE.SET_TOKEN('BLANKET_CURRENCY',
701: g_blkt_hdr_tbl(l_blanket_header_id).currency_code);
702: FND_MESSAGE.SET_TOKEN('MINIMUM',
703: g_blkt_line_tbl(l_blanket_line_id).min_release_amount);
704: FND_MESSAGE.SET_TOKEN('MAXIMUM',

Line 702: FND_MESSAGE.SET_TOKEN('MINIMUM',

698: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUMBER'
699: ,Get_Shipment_Number(p_line_id));
700: FND_MESSAGE.SET_TOKEN('BLANKET_CURRENCY',
701: g_blkt_hdr_tbl(l_blanket_header_id).currency_code);
702: FND_MESSAGE.SET_TOKEN('MINIMUM',
703: g_blkt_line_tbl(l_blanket_line_id).min_release_amount);
704: FND_MESSAGE.SET_TOKEN('MAXIMUM',
705: g_blkt_line_tbl(l_blanket_line_id).max_release_amount);
706: oe_msg_pub.add;

Line 704: FND_MESSAGE.SET_TOKEN('MAXIMUM',

700: FND_MESSAGE.SET_TOKEN('BLANKET_CURRENCY',
701: g_blkt_hdr_tbl(l_blanket_header_id).currency_code);
702: FND_MESSAGE.SET_TOKEN('MINIMUM',
703: g_blkt_line_tbl(l_blanket_line_id).min_release_amount);
704: FND_MESSAGE.SET_TOKEN('MAXIMUM',
705: g_blkt_line_tbl(l_blanket_line_id).max_release_amount);
706: oe_msg_pub.add;
707: END IF;
708:

Line 714: FND_MESSAGE.SET_NAME('ONT','OE_BL_MIN_MAX_REL_AMT');

710:
711: -- For regular lines, raise error.
712: ELSE
713: IF g_blkt_line_tbl(l_blanket_line_id).OVERRIDE_RELEASE_CONTROLS_FLAG = 'N' THEN
714: FND_MESSAGE.SET_NAME('ONT','OE_BL_MIN_MAX_REL_AMT');
715: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Line_Number(p_line_id));
716: FND_MESSAGE.SET_TOKEN('BLANKET_CURRENCY',
717: g_blkt_hdr_tbl(l_blanket_header_id).currency_code);
718: FND_MESSAGE.SET_TOKEN('MINIMUM',

Line 715: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Line_Number(p_line_id));

711: -- For regular lines, raise error.
712: ELSE
713: IF g_blkt_line_tbl(l_blanket_line_id).OVERRIDE_RELEASE_CONTROLS_FLAG = 'N' THEN
714: FND_MESSAGE.SET_NAME('ONT','OE_BL_MIN_MAX_REL_AMT');
715: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Line_Number(p_line_id));
716: FND_MESSAGE.SET_TOKEN('BLANKET_CURRENCY',
717: g_blkt_hdr_tbl(l_blanket_header_id).currency_code);
718: FND_MESSAGE.SET_TOKEN('MINIMUM',
719: g_blkt_line_tbl(l_blanket_line_id).min_release_amount);

Line 716: FND_MESSAGE.SET_TOKEN('BLANKET_CURRENCY',

712: ELSE
713: IF g_blkt_line_tbl(l_blanket_line_id).OVERRIDE_RELEASE_CONTROLS_FLAG = 'N' THEN
714: FND_MESSAGE.SET_NAME('ONT','OE_BL_MIN_MAX_REL_AMT');
715: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Line_Number(p_line_id));
716: FND_MESSAGE.SET_TOKEN('BLANKET_CURRENCY',
717: g_blkt_hdr_tbl(l_blanket_header_id).currency_code);
718: FND_MESSAGE.SET_TOKEN('MINIMUM',
719: g_blkt_line_tbl(l_blanket_line_id).min_release_amount);
720: FND_MESSAGE.SET_TOKEN('MAXIMUM',

Line 718: FND_MESSAGE.SET_TOKEN('MINIMUM',

714: FND_MESSAGE.SET_NAME('ONT','OE_BL_MIN_MAX_REL_AMT');
715: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Line_Number(p_line_id));
716: FND_MESSAGE.SET_TOKEN('BLANKET_CURRENCY',
717: g_blkt_hdr_tbl(l_blanket_header_id).currency_code);
718: FND_MESSAGE.SET_TOKEN('MINIMUM',
719: g_blkt_line_tbl(l_blanket_line_id).min_release_amount);
720: FND_MESSAGE.SET_TOKEN('MAXIMUM',
721: g_blkt_line_tbl(l_blanket_line_id).max_release_amount);
722: oe_msg_pub.add;

Line 720: FND_MESSAGE.SET_TOKEN('MAXIMUM',

716: FND_MESSAGE.SET_TOKEN('BLANKET_CURRENCY',
717: g_blkt_hdr_tbl(l_blanket_header_id).currency_code);
718: FND_MESSAGE.SET_TOKEN('MINIMUM',
719: g_blkt_line_tbl(l_blanket_line_id).min_release_amount);
720: FND_MESSAGE.SET_TOKEN('MAXIMUM',
721: g_blkt_line_tbl(l_blanket_line_id).max_release_amount);
722: oe_msg_pub.add;
723: x_return_status := FND_API.G_RET_STS_ERROR;
724:

Line 727: FND_MESSAGE.SET_NAME('ONT','OE_BL_MIN_MAX_REL_AMT');

723: x_return_status := FND_API.G_RET_STS_ERROR;
724:
725: ELSE
726: IF NVL(FND_PROFILE.VALUE('ONT_BSA_MIN_MAX_VIOLATION'),'N') = 'Y' THEN
727: FND_MESSAGE.SET_NAME('ONT','OE_BL_MIN_MAX_REL_AMT');
728: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Line_Number(p_line_id));
729: FND_MESSAGE.SET_TOKEN('BLANKET_CURRENCY',
730: g_blkt_hdr_tbl(l_blanket_header_id).currency_code);
731: FND_MESSAGE.SET_TOKEN('MINIMUM',

Line 728: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Line_Number(p_line_id));

724:
725: ELSE
726: IF NVL(FND_PROFILE.VALUE('ONT_BSA_MIN_MAX_VIOLATION'),'N') = 'Y' THEN
727: FND_MESSAGE.SET_NAME('ONT','OE_BL_MIN_MAX_REL_AMT');
728: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Line_Number(p_line_id));
729: FND_MESSAGE.SET_TOKEN('BLANKET_CURRENCY',
730: g_blkt_hdr_tbl(l_blanket_header_id).currency_code);
731: FND_MESSAGE.SET_TOKEN('MINIMUM',
732: g_blkt_line_tbl(l_blanket_line_id).min_release_amount);

Line 729: FND_MESSAGE.SET_TOKEN('BLANKET_CURRENCY',

725: ELSE
726: IF NVL(FND_PROFILE.VALUE('ONT_BSA_MIN_MAX_VIOLATION'),'N') = 'Y' THEN
727: FND_MESSAGE.SET_NAME('ONT','OE_BL_MIN_MAX_REL_AMT');
728: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Line_Number(p_line_id));
729: FND_MESSAGE.SET_TOKEN('BLANKET_CURRENCY',
730: g_blkt_hdr_tbl(l_blanket_header_id).currency_code);
731: FND_MESSAGE.SET_TOKEN('MINIMUM',
732: g_blkt_line_tbl(l_blanket_line_id).min_release_amount);
733: FND_MESSAGE.SET_TOKEN('MAXIMUM',

Line 731: FND_MESSAGE.SET_TOKEN('MINIMUM',

727: FND_MESSAGE.SET_NAME('ONT','OE_BL_MIN_MAX_REL_AMT');
728: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Line_Number(p_line_id));
729: FND_MESSAGE.SET_TOKEN('BLANKET_CURRENCY',
730: g_blkt_hdr_tbl(l_blanket_header_id).currency_code);
731: FND_MESSAGE.SET_TOKEN('MINIMUM',
732: g_blkt_line_tbl(l_blanket_line_id).min_release_amount);
733: FND_MESSAGE.SET_TOKEN('MAXIMUM',
734: g_blkt_line_tbl(l_blanket_line_id).max_release_amount);
735: oe_msg_pub.add;

Line 733: FND_MESSAGE.SET_TOKEN('MAXIMUM',

729: FND_MESSAGE.SET_TOKEN('BLANKET_CURRENCY',
730: g_blkt_hdr_tbl(l_blanket_header_id).currency_code);
731: FND_MESSAGE.SET_TOKEN('MINIMUM',
732: g_blkt_line_tbl(l_blanket_line_id).min_release_amount);
733: FND_MESSAGE.SET_TOKEN('MAXIMUM',
734: g_blkt_line_tbl(l_blanket_line_id).max_release_amount);
735: oe_msg_pub.add;
736: END IF;
737:

Line 758: FND_MESSAGE.SET_NAME('ONT','OE_BL_LIN_MAX_QTY_EXCEEDED');

754: (g_blkt_line_tbl(l_blanket_line_id).blanket_max_quantity
755: + g_blkt_line_tbl(l_blanket_line_id).returned_quantity)
756: THEN
757: IF g_blkt_line_tbl(l_blanket_line_id).OVERRIDE_BLANKET_CONTROLS_FLAG = 'N' THEN
758: FND_MESSAGE.SET_NAME('ONT','OE_BL_LIN_MAX_QTY_EXCEEDED');
759: FND_MESSAGE.SET_TOKEN('BLANKET_NUMBER',p_blanket_number);
760: FND_MESSAGE.SET_TOKEN('BLANKET_LINE_NUMBER',p_blanket_line_number);
761: FND_MESSAGE.SET_TOKEN('BLANKET_UOM',
762: g_blkt_line_tbl(l_blanket_line_id).uom);

Line 759: FND_MESSAGE.SET_TOKEN('BLANKET_NUMBER',p_blanket_number);

755: + g_blkt_line_tbl(l_blanket_line_id).returned_quantity)
756: THEN
757: IF g_blkt_line_tbl(l_blanket_line_id).OVERRIDE_BLANKET_CONTROLS_FLAG = 'N' THEN
758: FND_MESSAGE.SET_NAME('ONT','OE_BL_LIN_MAX_QTY_EXCEEDED');
759: FND_MESSAGE.SET_TOKEN('BLANKET_NUMBER',p_blanket_number);
760: FND_MESSAGE.SET_TOKEN('BLANKET_LINE_NUMBER',p_blanket_line_number);
761: FND_MESSAGE.SET_TOKEN('BLANKET_UOM',
762: g_blkt_line_tbl(l_blanket_line_id).uom);
763: FND_MESSAGE.SET_TOKEN('MAXIMUM',

Line 760: FND_MESSAGE.SET_TOKEN('BLANKET_LINE_NUMBER',p_blanket_line_number);

756: THEN
757: IF g_blkt_line_tbl(l_blanket_line_id).OVERRIDE_BLANKET_CONTROLS_FLAG = 'N' THEN
758: FND_MESSAGE.SET_NAME('ONT','OE_BL_LIN_MAX_QTY_EXCEEDED');
759: FND_MESSAGE.SET_TOKEN('BLANKET_NUMBER',p_blanket_number);
760: FND_MESSAGE.SET_TOKEN('BLANKET_LINE_NUMBER',p_blanket_line_number);
761: FND_MESSAGE.SET_TOKEN('BLANKET_UOM',
762: g_blkt_line_tbl(l_blanket_line_id).uom);
763: FND_MESSAGE.SET_TOKEN('MAXIMUM',
764: g_blkt_line_tbl(l_blanket_line_id).blanket_max_quantity);

Line 761: FND_MESSAGE.SET_TOKEN('BLANKET_UOM',

757: IF g_blkt_line_tbl(l_blanket_line_id).OVERRIDE_BLANKET_CONTROLS_FLAG = 'N' THEN
758: FND_MESSAGE.SET_NAME('ONT','OE_BL_LIN_MAX_QTY_EXCEEDED');
759: FND_MESSAGE.SET_TOKEN('BLANKET_NUMBER',p_blanket_number);
760: FND_MESSAGE.SET_TOKEN('BLANKET_LINE_NUMBER',p_blanket_line_number);
761: FND_MESSAGE.SET_TOKEN('BLANKET_UOM',
762: g_blkt_line_tbl(l_blanket_line_id).uom);
763: FND_MESSAGE.SET_TOKEN('MAXIMUM',
764: g_blkt_line_tbl(l_blanket_line_id).blanket_max_quantity);
765: oe_msg_pub.add;

Line 763: FND_MESSAGE.SET_TOKEN('MAXIMUM',

759: FND_MESSAGE.SET_TOKEN('BLANKET_NUMBER',p_blanket_number);
760: FND_MESSAGE.SET_TOKEN('BLANKET_LINE_NUMBER',p_blanket_line_number);
761: FND_MESSAGE.SET_TOKEN('BLANKET_UOM',
762: g_blkt_line_tbl(l_blanket_line_id).uom);
763: FND_MESSAGE.SET_TOKEN('MAXIMUM',
764: g_blkt_line_tbl(l_blanket_line_id).blanket_max_quantity);
765: oe_msg_pub.add;
766: x_return_status := FND_API.G_RET_STS_ERROR;
767: ELSE

Line 769: FND_MESSAGE.SET_NAME('ONT','OE_BL_LIN_MAX_QTY_EXCEEDED');

765: oe_msg_pub.add;
766: x_return_status := FND_API.G_RET_STS_ERROR;
767: ELSE
768: IF NVL(FND_PROFILE.VALUE('ONT_BSA_MIN_MAX_VIOLATION'),'N') = 'Y' THEN
769: FND_MESSAGE.SET_NAME('ONT','OE_BL_LIN_MAX_QTY_EXCEEDED');
770: FND_MESSAGE.SET_TOKEN('BLANKET_NUMBER',p_blanket_number);
771: FND_MESSAGE.SET_TOKEN('BLANKET_LINE_NUMBER',p_blanket_line_number);
772: FND_MESSAGE.SET_TOKEN('BLANKET_UOM',
773: g_blkt_line_tbl(l_blanket_line_id).uom);

Line 770: FND_MESSAGE.SET_TOKEN('BLANKET_NUMBER',p_blanket_number);

766: x_return_status := FND_API.G_RET_STS_ERROR;
767: ELSE
768: IF NVL(FND_PROFILE.VALUE('ONT_BSA_MIN_MAX_VIOLATION'),'N') = 'Y' THEN
769: FND_MESSAGE.SET_NAME('ONT','OE_BL_LIN_MAX_QTY_EXCEEDED');
770: FND_MESSAGE.SET_TOKEN('BLANKET_NUMBER',p_blanket_number);
771: FND_MESSAGE.SET_TOKEN('BLANKET_LINE_NUMBER',p_blanket_line_number);
772: FND_MESSAGE.SET_TOKEN('BLANKET_UOM',
773: g_blkt_line_tbl(l_blanket_line_id).uom);
774: FND_MESSAGE.SET_TOKEN('MAXIMUM',

Line 771: FND_MESSAGE.SET_TOKEN('BLANKET_LINE_NUMBER',p_blanket_line_number);

767: ELSE
768: IF NVL(FND_PROFILE.VALUE('ONT_BSA_MIN_MAX_VIOLATION'),'N') = 'Y' THEN
769: FND_MESSAGE.SET_NAME('ONT','OE_BL_LIN_MAX_QTY_EXCEEDED');
770: FND_MESSAGE.SET_TOKEN('BLANKET_NUMBER',p_blanket_number);
771: FND_MESSAGE.SET_TOKEN('BLANKET_LINE_NUMBER',p_blanket_line_number);
772: FND_MESSAGE.SET_TOKEN('BLANKET_UOM',
773: g_blkt_line_tbl(l_blanket_line_id).uom);
774: FND_MESSAGE.SET_TOKEN('MAXIMUM',
775: g_blkt_line_tbl(l_blanket_line_id).blanket_max_quantity);

Line 772: FND_MESSAGE.SET_TOKEN('BLANKET_UOM',

768: IF NVL(FND_PROFILE.VALUE('ONT_BSA_MIN_MAX_VIOLATION'),'N') = 'Y' THEN
769: FND_MESSAGE.SET_NAME('ONT','OE_BL_LIN_MAX_QTY_EXCEEDED');
770: FND_MESSAGE.SET_TOKEN('BLANKET_NUMBER',p_blanket_number);
771: FND_MESSAGE.SET_TOKEN('BLANKET_LINE_NUMBER',p_blanket_line_number);
772: FND_MESSAGE.SET_TOKEN('BLANKET_UOM',
773: g_blkt_line_tbl(l_blanket_line_id).uom);
774: FND_MESSAGE.SET_TOKEN('MAXIMUM',
775: g_blkt_line_tbl(l_blanket_line_id).blanket_max_quantity);
776: oe_msg_pub.add;

Line 774: FND_MESSAGE.SET_TOKEN('MAXIMUM',

770: FND_MESSAGE.SET_TOKEN('BLANKET_NUMBER',p_blanket_number);
771: FND_MESSAGE.SET_TOKEN('BLANKET_LINE_NUMBER',p_blanket_line_number);
772: FND_MESSAGE.SET_TOKEN('BLANKET_UOM',
773: g_blkt_line_tbl(l_blanket_line_id).uom);
774: FND_MESSAGE.SET_TOKEN('MAXIMUM',
775: g_blkt_line_tbl(l_blanket_line_id).blanket_max_quantity);
776: oe_msg_pub.add;
777: END IF;
778:

Line 788: FND_MESSAGE.SET_NAME('ONT','OE_BL_LIN_MAX_AMT_EXCEEDED');

784: (g_blkt_line_tbl(l_blanket_line_id).blanket_line_max_amount
785: + g_blkt_line_tbl(l_blanket_line_id).returned_amount)
786: THEN
787: IF g_blkt_line_tbl(l_blanket_line_id).OVERRIDE_BLANKET_CONTROLS_FLAG = 'N' THEN
788: FND_MESSAGE.SET_NAME('ONT','OE_BL_LIN_MAX_AMT_EXCEEDED');
789: FND_MESSAGE.SET_TOKEN('BLANKET_NUMBER',p_blanket_number);
790: FND_MESSAGE.SET_TOKEN('BLANKET_LINE_NUMBER',p_blanket_line_number);
791: FND_MESSAGE.SET_TOKEN('BLANKET_CURRENCY',
792: g_blkt_hdr_tbl(l_blanket_header_id).currency_code);

Line 789: FND_MESSAGE.SET_TOKEN('BLANKET_NUMBER',p_blanket_number);

785: + g_blkt_line_tbl(l_blanket_line_id).returned_amount)
786: THEN
787: IF g_blkt_line_tbl(l_blanket_line_id).OVERRIDE_BLANKET_CONTROLS_FLAG = 'N' THEN
788: FND_MESSAGE.SET_NAME('ONT','OE_BL_LIN_MAX_AMT_EXCEEDED');
789: FND_MESSAGE.SET_TOKEN('BLANKET_NUMBER',p_blanket_number);
790: FND_MESSAGE.SET_TOKEN('BLANKET_LINE_NUMBER',p_blanket_line_number);
791: FND_MESSAGE.SET_TOKEN('BLANKET_CURRENCY',
792: g_blkt_hdr_tbl(l_blanket_header_id).currency_code);
793: FND_MESSAGE.SET_TOKEN('MAXIMUM',

Line 790: FND_MESSAGE.SET_TOKEN('BLANKET_LINE_NUMBER',p_blanket_line_number);

786: THEN
787: IF g_blkt_line_tbl(l_blanket_line_id).OVERRIDE_BLANKET_CONTROLS_FLAG = 'N' THEN
788: FND_MESSAGE.SET_NAME('ONT','OE_BL_LIN_MAX_AMT_EXCEEDED');
789: FND_MESSAGE.SET_TOKEN('BLANKET_NUMBER',p_blanket_number);
790: FND_MESSAGE.SET_TOKEN('BLANKET_LINE_NUMBER',p_blanket_line_number);
791: FND_MESSAGE.SET_TOKEN('BLANKET_CURRENCY',
792: g_blkt_hdr_tbl(l_blanket_header_id).currency_code);
793: FND_MESSAGE.SET_TOKEN('MAXIMUM',
794: g_blkt_line_tbl(l_blanket_line_id).blanket_line_max_amount);

Line 791: FND_MESSAGE.SET_TOKEN('BLANKET_CURRENCY',

787: IF g_blkt_line_tbl(l_blanket_line_id).OVERRIDE_BLANKET_CONTROLS_FLAG = 'N' THEN
788: FND_MESSAGE.SET_NAME('ONT','OE_BL_LIN_MAX_AMT_EXCEEDED');
789: FND_MESSAGE.SET_TOKEN('BLANKET_NUMBER',p_blanket_number);
790: FND_MESSAGE.SET_TOKEN('BLANKET_LINE_NUMBER',p_blanket_line_number);
791: FND_MESSAGE.SET_TOKEN('BLANKET_CURRENCY',
792: g_blkt_hdr_tbl(l_blanket_header_id).currency_code);
793: FND_MESSAGE.SET_TOKEN('MAXIMUM',
794: g_blkt_line_tbl(l_blanket_line_id).blanket_line_max_amount);
795: oe_msg_pub.add;

Line 793: FND_MESSAGE.SET_TOKEN('MAXIMUM',

789: FND_MESSAGE.SET_TOKEN('BLANKET_NUMBER',p_blanket_number);
790: FND_MESSAGE.SET_TOKEN('BLANKET_LINE_NUMBER',p_blanket_line_number);
791: FND_MESSAGE.SET_TOKEN('BLANKET_CURRENCY',
792: g_blkt_hdr_tbl(l_blanket_header_id).currency_code);
793: FND_MESSAGE.SET_TOKEN('MAXIMUM',
794: g_blkt_line_tbl(l_blanket_line_id).blanket_line_max_amount);
795: oe_msg_pub.add;
796: x_return_status := FND_API.G_RET_STS_ERROR;
797: ELSE

Line 799: FND_MESSAGE.SET_NAME('ONT','OE_BL_LIN_MAX_AMT_EXCEEDED');

795: oe_msg_pub.add;
796: x_return_status := FND_API.G_RET_STS_ERROR;
797: ELSE
798: IF NVL(FND_PROFILE.VALUE('ONT_BSA_MIN_MAX_VIOLATION'),'N') = 'Y' THEN
799: FND_MESSAGE.SET_NAME('ONT','OE_BL_LIN_MAX_AMT_EXCEEDED');
800: FND_MESSAGE.SET_TOKEN('BLANKET_NUMBER',p_blanket_number);
801: FND_MESSAGE.SET_TOKEN('BLANKET_LINE_NUMBER',p_blanket_line_number);
802: FND_MESSAGE.SET_TOKEN('BLANKET_CURRENCY',
803: g_blkt_hdr_tbl(l_blanket_header_id).currency_code);

Line 800: FND_MESSAGE.SET_TOKEN('BLANKET_NUMBER',p_blanket_number);

796: x_return_status := FND_API.G_RET_STS_ERROR;
797: ELSE
798: IF NVL(FND_PROFILE.VALUE('ONT_BSA_MIN_MAX_VIOLATION'),'N') = 'Y' THEN
799: FND_MESSAGE.SET_NAME('ONT','OE_BL_LIN_MAX_AMT_EXCEEDED');
800: FND_MESSAGE.SET_TOKEN('BLANKET_NUMBER',p_blanket_number);
801: FND_MESSAGE.SET_TOKEN('BLANKET_LINE_NUMBER',p_blanket_line_number);
802: FND_MESSAGE.SET_TOKEN('BLANKET_CURRENCY',
803: g_blkt_hdr_tbl(l_blanket_header_id).currency_code);
804: FND_MESSAGE.SET_TOKEN('MAXIMUM',

Line 801: FND_MESSAGE.SET_TOKEN('BLANKET_LINE_NUMBER',p_blanket_line_number);

797: ELSE
798: IF NVL(FND_PROFILE.VALUE('ONT_BSA_MIN_MAX_VIOLATION'),'N') = 'Y' THEN
799: FND_MESSAGE.SET_NAME('ONT','OE_BL_LIN_MAX_AMT_EXCEEDED');
800: FND_MESSAGE.SET_TOKEN('BLANKET_NUMBER',p_blanket_number);
801: FND_MESSAGE.SET_TOKEN('BLANKET_LINE_NUMBER',p_blanket_line_number);
802: FND_MESSAGE.SET_TOKEN('BLANKET_CURRENCY',
803: g_blkt_hdr_tbl(l_blanket_header_id).currency_code);
804: FND_MESSAGE.SET_TOKEN('MAXIMUM',
805: g_blkt_line_tbl(l_blanket_line_id).blanket_line_max_amount);

Line 802: FND_MESSAGE.SET_TOKEN('BLANKET_CURRENCY',

798: IF NVL(FND_PROFILE.VALUE('ONT_BSA_MIN_MAX_VIOLATION'),'N') = 'Y' THEN
799: FND_MESSAGE.SET_NAME('ONT','OE_BL_LIN_MAX_AMT_EXCEEDED');
800: FND_MESSAGE.SET_TOKEN('BLANKET_NUMBER',p_blanket_number);
801: FND_MESSAGE.SET_TOKEN('BLANKET_LINE_NUMBER',p_blanket_line_number);
802: FND_MESSAGE.SET_TOKEN('BLANKET_CURRENCY',
803: g_blkt_hdr_tbl(l_blanket_header_id).currency_code);
804: FND_MESSAGE.SET_TOKEN('MAXIMUM',
805: g_blkt_line_tbl(l_blanket_line_id).blanket_line_max_amount);
806: oe_msg_pub.add;

Line 804: FND_MESSAGE.SET_TOKEN('MAXIMUM',

800: FND_MESSAGE.SET_TOKEN('BLANKET_NUMBER',p_blanket_number);
801: FND_MESSAGE.SET_TOKEN('BLANKET_LINE_NUMBER',p_blanket_line_number);
802: FND_MESSAGE.SET_TOKEN('BLANKET_CURRENCY',
803: g_blkt_hdr_tbl(l_blanket_header_id).currency_code);
804: FND_MESSAGE.SET_TOKEN('MAXIMUM',
805: g_blkt_line_tbl(l_blanket_line_id).blanket_line_max_amount);
806: oe_msg_pub.add;
807: END IF;
808:

Line 831: FND_MESSAGE.SET_NAME('ONT','OE_BL_HDR_MAX_AMT_EXCEEDED');

827: (g_blkt_hdr_tbl(l_blanket_header_id).blanket_max_amount
828: + g_blkt_hdr_tbl(l_blanket_header_id).returned_amount)
829: THEN
830: IF g_blkt_hdr_tbl(l_blanket_header_id).override_amount_flag = 'N' THEN
831: FND_MESSAGE.SET_NAME('ONT','OE_BL_HDR_MAX_AMT_EXCEEDED');
832: FND_MESSAGE.SET_TOKEN('BLANKET_NUMBER',p_blanket_number);
833: FND_MESSAGE.SET_TOKEN('BLANKET_CURRENCY',
834: g_blkt_hdr_tbl(l_blanket_header_id).currency_code);
835: FND_MESSAGE.SET_TOKEN('MAXIMUM',

Line 832: FND_MESSAGE.SET_TOKEN('BLANKET_NUMBER',p_blanket_number);

828: + g_blkt_hdr_tbl(l_blanket_header_id).returned_amount)
829: THEN
830: IF g_blkt_hdr_tbl(l_blanket_header_id).override_amount_flag = 'N' THEN
831: FND_MESSAGE.SET_NAME('ONT','OE_BL_HDR_MAX_AMT_EXCEEDED');
832: FND_MESSAGE.SET_TOKEN('BLANKET_NUMBER',p_blanket_number);
833: FND_MESSAGE.SET_TOKEN('BLANKET_CURRENCY',
834: g_blkt_hdr_tbl(l_blanket_header_id).currency_code);
835: FND_MESSAGE.SET_TOKEN('MAXIMUM',
836: g_blkt_hdr_tbl(l_blanket_header_id).blanket_max_amount);

Line 833: FND_MESSAGE.SET_TOKEN('BLANKET_CURRENCY',

829: THEN
830: IF g_blkt_hdr_tbl(l_blanket_header_id).override_amount_flag = 'N' THEN
831: FND_MESSAGE.SET_NAME('ONT','OE_BL_HDR_MAX_AMT_EXCEEDED');
832: FND_MESSAGE.SET_TOKEN('BLANKET_NUMBER',p_blanket_number);
833: FND_MESSAGE.SET_TOKEN('BLANKET_CURRENCY',
834: g_blkt_hdr_tbl(l_blanket_header_id).currency_code);
835: FND_MESSAGE.SET_TOKEN('MAXIMUM',
836: g_blkt_hdr_tbl(l_blanket_header_id).blanket_max_amount);
837: oe_msg_pub.add;

Line 835: FND_MESSAGE.SET_TOKEN('MAXIMUM',

831: FND_MESSAGE.SET_NAME('ONT','OE_BL_HDR_MAX_AMT_EXCEEDED');
832: FND_MESSAGE.SET_TOKEN('BLANKET_NUMBER',p_blanket_number);
833: FND_MESSAGE.SET_TOKEN('BLANKET_CURRENCY',
834: g_blkt_hdr_tbl(l_blanket_header_id).currency_code);
835: FND_MESSAGE.SET_TOKEN('MAXIMUM',
836: g_blkt_hdr_tbl(l_blanket_header_id).blanket_max_amount);
837: oe_msg_pub.add;
838: x_return_status := FND_API.G_RET_STS_ERROR;
839: ELSE

Line 841: FND_MESSAGE.SET_NAME('ONT','OE_BL_HDR_MAX_AMT_EXCEEDED');

837: oe_msg_pub.add;
838: x_return_status := FND_API.G_RET_STS_ERROR;
839: ELSE
840: IF NVL(FND_PROFILE.VALUE('ONT_BSA_MIN_MAX_VIOLATION'),'N') = 'Y' THEN
841: FND_MESSAGE.SET_NAME('ONT','OE_BL_HDR_MAX_AMT_EXCEEDED');
842: FND_MESSAGE.SET_TOKEN('BLANKET_NUMBER',p_blanket_number);
843: FND_MESSAGE.SET_TOKEN('BLANKET_CURRENCY',
844: g_blkt_hdr_tbl(l_blanket_header_id).currency_code);
845: FND_MESSAGE.SET_TOKEN('MAXIMUM',

Line 842: FND_MESSAGE.SET_TOKEN('BLANKET_NUMBER',p_blanket_number);

838: x_return_status := FND_API.G_RET_STS_ERROR;
839: ELSE
840: IF NVL(FND_PROFILE.VALUE('ONT_BSA_MIN_MAX_VIOLATION'),'N') = 'Y' THEN
841: FND_MESSAGE.SET_NAME('ONT','OE_BL_HDR_MAX_AMT_EXCEEDED');
842: FND_MESSAGE.SET_TOKEN('BLANKET_NUMBER',p_blanket_number);
843: FND_MESSAGE.SET_TOKEN('BLANKET_CURRENCY',
844: g_blkt_hdr_tbl(l_blanket_header_id).currency_code);
845: FND_MESSAGE.SET_TOKEN('MAXIMUM',
846: g_blkt_hdr_tbl(l_blanket_header_id).blanket_max_amount);

Line 843: FND_MESSAGE.SET_TOKEN('BLANKET_CURRENCY',

839: ELSE
840: IF NVL(FND_PROFILE.VALUE('ONT_BSA_MIN_MAX_VIOLATION'),'N') = 'Y' THEN
841: FND_MESSAGE.SET_NAME('ONT','OE_BL_HDR_MAX_AMT_EXCEEDED');
842: FND_MESSAGE.SET_TOKEN('BLANKET_NUMBER',p_blanket_number);
843: FND_MESSAGE.SET_TOKEN('BLANKET_CURRENCY',
844: g_blkt_hdr_tbl(l_blanket_header_id).currency_code);
845: FND_MESSAGE.SET_TOKEN('MAXIMUM',
846: g_blkt_hdr_tbl(l_blanket_header_id).blanket_max_amount);
847: oe_msg_pub.add;

Line 845: FND_MESSAGE.SET_TOKEN('MAXIMUM',

841: FND_MESSAGE.SET_NAME('ONT','OE_BL_HDR_MAX_AMT_EXCEEDED');
842: FND_MESSAGE.SET_TOKEN('BLANKET_NUMBER',p_blanket_number);
843: FND_MESSAGE.SET_TOKEN('BLANKET_CURRENCY',
844: g_blkt_hdr_tbl(l_blanket_header_id).currency_code);
845: FND_MESSAGE.SET_TOKEN('MAXIMUM',
846: g_blkt_hdr_tbl(l_blanket_header_id).blanket_max_amount);
847: oe_msg_pub.add;
848: END IF;
849:

Line 1068: FND_MESSAGE.SET_NAME('ONT','OE_BL_UOM_CONV_FAILED');

1064: ,p_to_uom_code => g_blkt_line_tbl(l_blanket_line_id).uom
1065: ,p_from_qty => l_set_quantity
1066: );
1067: IF l_set_quantity < 0 THEN
1068: FND_MESSAGE.SET_NAME('ONT','OE_BL_UOM_CONV_FAILED');
1069: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Set_Line_Number);
1070: FND_MESSAGE.SET_TOKEN('BLANKET_UOM',
1071: g_blkt_line_tbl(l_blanket_line_id).uom);
1072: OE_MSG_PUB.ADD;

Line 1069: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Set_Line_Number);

1065: ,p_from_qty => l_set_quantity
1066: );
1067: IF l_set_quantity < 0 THEN
1068: FND_MESSAGE.SET_NAME('ONT','OE_BL_UOM_CONV_FAILED');
1069: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Set_Line_Number);
1070: FND_MESSAGE.SET_TOKEN('BLANKET_UOM',
1071: g_blkt_line_tbl(l_blanket_line_id).uom);
1072: OE_MSG_PUB.ADD;
1073: RAISE FND_API.G_EXC_ERROR;

Line 1070: FND_MESSAGE.SET_TOKEN('BLANKET_UOM',

1066: );
1067: IF l_set_quantity < 0 THEN
1068: FND_MESSAGE.SET_NAME('ONT','OE_BL_UOM_CONV_FAILED');
1069: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Set_Line_Number);
1070: FND_MESSAGE.SET_TOKEN('BLANKET_UOM',
1071: g_blkt_line_tbl(l_blanket_line_id).uom);
1072: OE_MSG_PUB.ADD;
1073: RAISE FND_API.G_EXC_ERROR;
1074: END IF;

Line 1085: FND_MESSAGE.SET_NAME('ONT','OE_BL_SUM_SPLIT_MIN_MAX_QTY');

1081: nvl(g_blkt_line_tbl(l_blanket_line_id).max_release_quantity
1082: ,l_set_quantity)
1083: THEN
1084: IF g_blkt_line_tbl(l_blanket_line_id).OVERRIDE_RELEASE_CONTROLS_FLAG = 'N' THEN
1085: FND_MESSAGE.SET_NAME('ONT','OE_BL_SUM_SPLIT_MIN_MAX_QTY');
1086: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Set_Line_Number);
1087: FND_MESSAGE.SET_TOKEN('BLANKET_UOM',
1088: g_blkt_line_tbl(l_blanket_line_id).uom);
1089: FND_MESSAGE.SET_TOKEN('MINIMUM',

Line 1086: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Set_Line_Number);

1082: ,l_set_quantity)
1083: THEN
1084: IF g_blkt_line_tbl(l_blanket_line_id).OVERRIDE_RELEASE_CONTROLS_FLAG = 'N' THEN
1085: FND_MESSAGE.SET_NAME('ONT','OE_BL_SUM_SPLIT_MIN_MAX_QTY');
1086: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Set_Line_Number);
1087: FND_MESSAGE.SET_TOKEN('BLANKET_UOM',
1088: g_blkt_line_tbl(l_blanket_line_id).uom);
1089: FND_MESSAGE.SET_TOKEN('MINIMUM',
1090: g_blkt_line_tbl(l_blanket_line_id).min_release_quantity);

Line 1087: FND_MESSAGE.SET_TOKEN('BLANKET_UOM',

1083: THEN
1084: IF g_blkt_line_tbl(l_blanket_line_id).OVERRIDE_RELEASE_CONTROLS_FLAG = 'N' THEN
1085: FND_MESSAGE.SET_NAME('ONT','OE_BL_SUM_SPLIT_MIN_MAX_QTY');
1086: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Set_Line_Number);
1087: FND_MESSAGE.SET_TOKEN('BLANKET_UOM',
1088: g_blkt_line_tbl(l_blanket_line_id).uom);
1089: FND_MESSAGE.SET_TOKEN('MINIMUM',
1090: g_blkt_line_tbl(l_blanket_line_id).min_release_quantity);
1091: FND_MESSAGE.SET_TOKEN('MAXIMUM',

Line 1089: FND_MESSAGE.SET_TOKEN('MINIMUM',

1085: FND_MESSAGE.SET_NAME('ONT','OE_BL_SUM_SPLIT_MIN_MAX_QTY');
1086: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Set_Line_Number);
1087: FND_MESSAGE.SET_TOKEN('BLANKET_UOM',
1088: g_blkt_line_tbl(l_blanket_line_id).uom);
1089: FND_MESSAGE.SET_TOKEN('MINIMUM',
1090: g_blkt_line_tbl(l_blanket_line_id).min_release_quantity);
1091: FND_MESSAGE.SET_TOKEN('MAXIMUM',
1092: g_blkt_line_tbl(l_blanket_line_id).max_release_quantity);
1093: oe_msg_pub.add;

Line 1091: FND_MESSAGE.SET_TOKEN('MAXIMUM',

1087: FND_MESSAGE.SET_TOKEN('BLANKET_UOM',
1088: g_blkt_line_tbl(l_blanket_line_id).uom);
1089: FND_MESSAGE.SET_TOKEN('MINIMUM',
1090: g_blkt_line_tbl(l_blanket_line_id).min_release_quantity);
1091: FND_MESSAGE.SET_TOKEN('MAXIMUM',
1092: g_blkt_line_tbl(l_blanket_line_id).max_release_quantity);
1093: oe_msg_pub.add;
1094: x_return_status := FND_API.G_RET_STS_ERROR;
1095: ELSE

Line 1097: FND_MESSAGE.SET_NAME('ONT','OE_BL_SUM_SPLIT_MIN_MAX_QTY');

1093: oe_msg_pub.add;
1094: x_return_status := FND_API.G_RET_STS_ERROR;
1095: ELSE
1096: IF NVL(FND_PROFILE.VALUE('ONT_BSA_MIN_MAX_VIOLATION'),'N') = 'Y' THEN
1097: FND_MESSAGE.SET_NAME('ONT','OE_BL_SUM_SPLIT_MIN_MAX_QTY');
1098: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Set_Line_Number);
1099: FND_MESSAGE.SET_TOKEN('BLANKET_UOM',
1100: g_blkt_line_tbl(l_blanket_line_id).uom);
1101: FND_MESSAGE.SET_TOKEN('MINIMUM',

Line 1098: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Set_Line_Number);

1094: x_return_status := FND_API.G_RET_STS_ERROR;
1095: ELSE
1096: IF NVL(FND_PROFILE.VALUE('ONT_BSA_MIN_MAX_VIOLATION'),'N') = 'Y' THEN
1097: FND_MESSAGE.SET_NAME('ONT','OE_BL_SUM_SPLIT_MIN_MAX_QTY');
1098: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Set_Line_Number);
1099: FND_MESSAGE.SET_TOKEN('BLANKET_UOM',
1100: g_blkt_line_tbl(l_blanket_line_id).uom);
1101: FND_MESSAGE.SET_TOKEN('MINIMUM',
1102: g_blkt_line_tbl(l_blanket_line_id).min_release_quantity);

Line 1099: FND_MESSAGE.SET_TOKEN('BLANKET_UOM',

1095: ELSE
1096: IF NVL(FND_PROFILE.VALUE('ONT_BSA_MIN_MAX_VIOLATION'),'N') = 'Y' THEN
1097: FND_MESSAGE.SET_NAME('ONT','OE_BL_SUM_SPLIT_MIN_MAX_QTY');
1098: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Set_Line_Number);
1099: FND_MESSAGE.SET_TOKEN('BLANKET_UOM',
1100: g_blkt_line_tbl(l_blanket_line_id).uom);
1101: FND_MESSAGE.SET_TOKEN('MINIMUM',
1102: g_blkt_line_tbl(l_blanket_line_id).min_release_quantity);
1103: FND_MESSAGE.SET_TOKEN('MAXIMUM',

Line 1101: FND_MESSAGE.SET_TOKEN('MINIMUM',

1097: FND_MESSAGE.SET_NAME('ONT','OE_BL_SUM_SPLIT_MIN_MAX_QTY');
1098: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Set_Line_Number);
1099: FND_MESSAGE.SET_TOKEN('BLANKET_UOM',
1100: g_blkt_line_tbl(l_blanket_line_id).uom);
1101: FND_MESSAGE.SET_TOKEN('MINIMUM',
1102: g_blkt_line_tbl(l_blanket_line_id).min_release_quantity);
1103: FND_MESSAGE.SET_TOKEN('MAXIMUM',
1104: g_blkt_line_tbl(l_blanket_line_id).max_release_quantity);
1105: oe_msg_pub.add;

Line 1103: FND_MESSAGE.SET_TOKEN('MAXIMUM',

1099: FND_MESSAGE.SET_TOKEN('BLANKET_UOM',
1100: g_blkt_line_tbl(l_blanket_line_id).uom);
1101: FND_MESSAGE.SET_TOKEN('MINIMUM',
1102: g_blkt_line_tbl(l_blanket_line_id).min_release_quantity);
1103: FND_MESSAGE.SET_TOKEN('MAXIMUM',
1104: g_blkt_line_tbl(l_blanket_line_id).max_release_quantity);
1105: oe_msg_pub.add;
1106: END IF;
1107:

Line 1123: FND_MESSAGE.SET_NAME('ONT','OE_BL_MISS_CONVERSION_TYPE');

1119: <> g_blkt_hdr_tbl(l_blanket_header_id).currency_code
1120: THEN
1121:
1122: IF g_blkt_hdr_tbl(l_blanket_header_id).conversion_type_code IS NULL THEN
1123: FND_MESSAGE.SET_NAME('ONT','OE_BL_MISS_CONVERSION_TYPE');
1124: FND_MESSAGE.SET_TOKEN('BLANKET_NUMBER',p_blanket_number);
1125: oe_msg_pub.add;
1126: RAISE FND_API.G_EXC_ERROR;
1127: END IF;

Line 1124: FND_MESSAGE.SET_TOKEN('BLANKET_NUMBER',p_blanket_number);

1120: THEN
1121:
1122: IF g_blkt_hdr_tbl(l_blanket_header_id).conversion_type_code IS NULL THEN
1123: FND_MESSAGE.SET_NAME('ONT','OE_BL_MISS_CONVERSION_TYPE');
1124: FND_MESSAGE.SET_TOKEN('BLANKET_NUMBER',p_blanket_number);
1125: oe_msg_pub.add;
1126: RAISE FND_API.G_EXC_ERROR;
1127: END IF;
1128:

Line 1147: FND_MESSAGE.SET_NAME('ONT','OE_BL_SUM_SPLIT_MIN_MAX_AMT');

1143: ,l_set_amount)
1144: )
1145: THEN
1146: IF g_blkt_line_tbl(l_blanket_line_id).OVERRIDE_RELEASE_CONTROLS_FLAG = 'N' THEN
1147: FND_MESSAGE.SET_NAME('ONT','OE_BL_SUM_SPLIT_MIN_MAX_AMT');
1148: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Set_Line_Number);
1149: FND_MESSAGE.SET_TOKEN('BLANKET_CURRENCY',
1150: g_blkt_hdr_tbl(l_blanket_header_id).currency_code);
1151: FND_MESSAGE.SET_TOKEN('MINIMUM',

Line 1148: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Set_Line_Number);

1144: )
1145: THEN
1146: IF g_blkt_line_tbl(l_blanket_line_id).OVERRIDE_RELEASE_CONTROLS_FLAG = 'N' THEN
1147: FND_MESSAGE.SET_NAME('ONT','OE_BL_SUM_SPLIT_MIN_MAX_AMT');
1148: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Set_Line_Number);
1149: FND_MESSAGE.SET_TOKEN('BLANKET_CURRENCY',
1150: g_blkt_hdr_tbl(l_blanket_header_id).currency_code);
1151: FND_MESSAGE.SET_TOKEN('MINIMUM',
1152: g_blkt_line_tbl(l_blanket_line_id).min_release_amount);

Line 1149: FND_MESSAGE.SET_TOKEN('BLANKET_CURRENCY',

1145: THEN
1146: IF g_blkt_line_tbl(l_blanket_line_id).OVERRIDE_RELEASE_CONTROLS_FLAG = 'N' THEN
1147: FND_MESSAGE.SET_NAME('ONT','OE_BL_SUM_SPLIT_MIN_MAX_AMT');
1148: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Set_Line_Number);
1149: FND_MESSAGE.SET_TOKEN('BLANKET_CURRENCY',
1150: g_blkt_hdr_tbl(l_blanket_header_id).currency_code);
1151: FND_MESSAGE.SET_TOKEN('MINIMUM',
1152: g_blkt_line_tbl(l_blanket_line_id).min_release_amount);
1153: FND_MESSAGE.SET_TOKEN('MAXIMUM',

Line 1151: FND_MESSAGE.SET_TOKEN('MINIMUM',

1147: FND_MESSAGE.SET_NAME('ONT','OE_BL_SUM_SPLIT_MIN_MAX_AMT');
1148: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Set_Line_Number);
1149: FND_MESSAGE.SET_TOKEN('BLANKET_CURRENCY',
1150: g_blkt_hdr_tbl(l_blanket_header_id).currency_code);
1151: FND_MESSAGE.SET_TOKEN('MINIMUM',
1152: g_blkt_line_tbl(l_blanket_line_id).min_release_amount);
1153: FND_MESSAGE.SET_TOKEN('MAXIMUM',
1154: g_blkt_line_tbl(l_blanket_line_id).max_release_amount);
1155: oe_msg_pub.add;

Line 1153: FND_MESSAGE.SET_TOKEN('MAXIMUM',

1149: FND_MESSAGE.SET_TOKEN('BLANKET_CURRENCY',
1150: g_blkt_hdr_tbl(l_blanket_header_id).currency_code);
1151: FND_MESSAGE.SET_TOKEN('MINIMUM',
1152: g_blkt_line_tbl(l_blanket_line_id).min_release_amount);
1153: FND_MESSAGE.SET_TOKEN('MAXIMUM',
1154: g_blkt_line_tbl(l_blanket_line_id).max_release_amount);
1155: oe_msg_pub.add;
1156: x_return_status := FND_API.G_RET_STS_ERROR;
1157: ELSE

Line 1159: FND_MESSAGE.SET_NAME('ONT','OE_BL_SUM_SPLIT_MIN_MAX_AMT');

1155: oe_msg_pub.add;
1156: x_return_status := FND_API.G_RET_STS_ERROR;
1157: ELSE
1158: IF NVL(FND_PROFILE.VALUE('ONT_BSA_MIN_MAX_VIOLATION'),'N') = 'Y' THEN
1159: FND_MESSAGE.SET_NAME('ONT','OE_BL_SUM_SPLIT_MIN_MAX_AMT');
1160: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Set_Line_Number);
1161: FND_MESSAGE.SET_TOKEN('BLANKET_CURRENCY',
1162: g_blkt_hdr_tbl(l_blanket_header_id).currency_code);
1163: FND_MESSAGE.SET_TOKEN('MINIMUM',

Line 1160: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Set_Line_Number);

1156: x_return_status := FND_API.G_RET_STS_ERROR;
1157: ELSE
1158: IF NVL(FND_PROFILE.VALUE('ONT_BSA_MIN_MAX_VIOLATION'),'N') = 'Y' THEN
1159: FND_MESSAGE.SET_NAME('ONT','OE_BL_SUM_SPLIT_MIN_MAX_AMT');
1160: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Set_Line_Number);
1161: FND_MESSAGE.SET_TOKEN('BLANKET_CURRENCY',
1162: g_blkt_hdr_tbl(l_blanket_header_id).currency_code);
1163: FND_MESSAGE.SET_TOKEN('MINIMUM',
1164: g_blkt_line_tbl(l_blanket_line_id).min_release_amount);

Line 1161: FND_MESSAGE.SET_TOKEN('BLANKET_CURRENCY',

1157: ELSE
1158: IF NVL(FND_PROFILE.VALUE('ONT_BSA_MIN_MAX_VIOLATION'),'N') = 'Y' THEN
1159: FND_MESSAGE.SET_NAME('ONT','OE_BL_SUM_SPLIT_MIN_MAX_AMT');
1160: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Set_Line_Number);
1161: FND_MESSAGE.SET_TOKEN('BLANKET_CURRENCY',
1162: g_blkt_hdr_tbl(l_blanket_header_id).currency_code);
1163: FND_MESSAGE.SET_TOKEN('MINIMUM',
1164: g_blkt_line_tbl(l_blanket_line_id).min_release_amount);
1165: FND_MESSAGE.SET_TOKEN('MAXIMUM',

Line 1163: FND_MESSAGE.SET_TOKEN('MINIMUM',

1159: FND_MESSAGE.SET_NAME('ONT','OE_BL_SUM_SPLIT_MIN_MAX_AMT');
1160: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Set_Line_Number);
1161: FND_MESSAGE.SET_TOKEN('BLANKET_CURRENCY',
1162: g_blkt_hdr_tbl(l_blanket_header_id).currency_code);
1163: FND_MESSAGE.SET_TOKEN('MINIMUM',
1164: g_blkt_line_tbl(l_blanket_line_id).min_release_amount);
1165: FND_MESSAGE.SET_TOKEN('MAXIMUM',
1166: g_blkt_line_tbl(l_blanket_line_id).max_release_amount);
1167: oe_msg_pub.add;

Line 1165: FND_MESSAGE.SET_TOKEN('MAXIMUM',

1161: FND_MESSAGE.SET_TOKEN('BLANKET_CURRENCY',
1162: g_blkt_hdr_tbl(l_blanket_header_id).currency_code);
1163: FND_MESSAGE.SET_TOKEN('MINIMUM',
1164: g_blkt_line_tbl(l_blanket_line_id).min_release_amount);
1165: FND_MESSAGE.SET_TOKEN('MAXIMUM',
1166: g_blkt_line_tbl(l_blanket_line_id).max_release_amount);
1167: oe_msg_pub.add;
1168: END IF;
1169: END IF;