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 179: FND_MESSAGE.SET_NAME('ONT','OE_BL_MISSING_CONV_RATE');

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

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

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

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

379: end if;
380:
381: EXCEPTION
382: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
383: FND_MESSAGE.Set_Name('ONT','OE_BL_LOCKED');
384: FND_MESSAGE.Set_Token('BLANKET_NUMBER',p_blanket_number);
385: OE_MSG_PUB.Add;
386: RAISE FND_API.G_EXC_ERROR;
387: WHEN OTHERS THEN

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

380:
381: EXCEPTION
382: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
383: FND_MESSAGE.Set_Name('ONT','OE_BL_LOCKED');
384: FND_MESSAGE.Set_Token('BLANKET_NUMBER',p_blanket_number);
385: OE_MSG_PUB.Add;
386: RAISE FND_API.G_EXC_ERROR;
387: WHEN OTHERS THEN
388: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

492: if l_debug_level > 0 then
493: oe_debug_pub.add('conv new qty :'||l_quantity);
494: end if;
495: IF l_quantity < 0 THEN
496: FND_MESSAGE.SET_NAME('ONT','OE_BL_UOM_CONV_FAILED');
497: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Line_Number(p_line_id));
498: FND_MESSAGE.SET_TOKEN('BLANKET_UOM',
499: g_blkt_line_tbl(l_blanket_line_id).uom);
500: OE_MSG_PUB.ADD;

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

493: oe_debug_pub.add('conv new qty :'||l_quantity);
494: end if;
495: IF l_quantity < 0 THEN
496: FND_MESSAGE.SET_NAME('ONT','OE_BL_UOM_CONV_FAILED');
497: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Line_Number(p_line_id));
498: FND_MESSAGE.SET_TOKEN('BLANKET_UOM',
499: g_blkt_line_tbl(l_blanket_line_id).uom);
500: OE_MSG_PUB.ADD;
501: RAISE FND_API.G_EXC_ERROR;

Line 498: FND_MESSAGE.SET_TOKEN('BLANKET_UOM',

494: end if;
495: IF l_quantity < 0 THEN
496: FND_MESSAGE.SET_NAME('ONT','OE_BL_UOM_CONV_FAILED');
497: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Line_Number(p_line_id));
498: FND_MESSAGE.SET_TOKEN('BLANKET_UOM',
499: g_blkt_line_tbl(l_blanket_line_id).uom);
500: OE_MSG_PUB.ADD;
501: RAISE FND_API.G_EXC_ERROR;
502: END IF;

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

514: if l_debug_level > 0 then
515: oe_debug_pub.add('conv old qty :'||l_quantity);
516: end if;
517: IF l_old_quantity < 0 THEN
518: FND_MESSAGE.SET_NAME('ONT','OE_BL_UOM_CONV_FAILED');
519: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Line_Number(p_line_id));
520: FND_MESSAGE.SET_TOKEN('BLANKET_UOM',
521: g_blkt_line_tbl(l_blanket_line_id).uom);
522: OE_MSG_PUB.ADD;

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

515: oe_debug_pub.add('conv old qty :'||l_quantity);
516: end if;
517: IF l_old_quantity < 0 THEN
518: FND_MESSAGE.SET_NAME('ONT','OE_BL_UOM_CONV_FAILED');
519: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Line_Number(p_line_id));
520: FND_MESSAGE.SET_TOKEN('BLANKET_UOM',
521: g_blkt_line_tbl(l_blanket_line_id).uom);
522: OE_MSG_PUB.ADD;
523: RAISE FND_API.G_EXC_ERROR;

Line 520: FND_MESSAGE.SET_TOKEN('BLANKET_UOM',

516: end if;
517: IF l_old_quantity < 0 THEN
518: FND_MESSAGE.SET_NAME('ONT','OE_BL_UOM_CONV_FAILED');
519: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Line_Number(p_line_id));
520: FND_MESSAGE.SET_TOKEN('BLANKET_UOM',
521: g_blkt_line_tbl(l_blanket_line_id).uom);
522: OE_MSG_PUB.ADD;
523: RAISE FND_API.G_EXC_ERROR;
524: END IF;

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

543: <> g_blkt_hdr_tbl(l_blanket_header_id).currency_code
544: THEN
545:
546: IF g_blkt_hdr_tbl(l_blanket_header_id).conversion_type_code IS NULL THEN
547: FND_MESSAGE.SET_NAME('ONT','OE_BL_MISS_CONVERSION_TYPE');
548: FND_MESSAGE.SET_TOKEN('BLANKET_NUMBER',p_blanket_number);
549: oe_msg_pub.add;
550: RAISE FND_API.G_EXC_ERROR;
551: END IF;

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

544: THEN
545:
546: IF g_blkt_hdr_tbl(l_blanket_header_id).conversion_type_code IS NULL THEN
547: FND_MESSAGE.SET_NAME('ONT','OE_BL_MISS_CONVERSION_TYPE');
548: FND_MESSAGE.SET_TOKEN('BLANKET_NUMBER',p_blanket_number);
549: oe_msg_pub.add;
550: RAISE FND_API.G_EXC_ERROR;
551: END IF;
552:

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

615: THEN
616: -- If shipment line, only a warning is issued. Error status is not set.
617: IF p_line_set_id IS NOT NULL THEN
618: IF g_blkt_line_tbl(l_blanket_line_id).OVERRIDE_RELEASE_CONTROLS_FLAG = 'N' THEN
619: FND_MESSAGE.SET_NAME('ONT','OE_BL_MIN_MAX_SHIPMENT_QTY');
620: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Line_Number(p_line_id));
621: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUMBER'
622: ,Get_Shipment_Number(p_line_id));
623: FND_MESSAGE.SET_TOKEN('BLANKET_UOM',

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

616: -- If shipment line, only a warning is issued. Error status is not set.
617: IF p_line_set_id IS NOT NULL THEN
618: IF g_blkt_line_tbl(l_blanket_line_id).OVERRIDE_RELEASE_CONTROLS_FLAG = 'N' THEN
619: FND_MESSAGE.SET_NAME('ONT','OE_BL_MIN_MAX_SHIPMENT_QTY');
620: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Line_Number(p_line_id));
621: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUMBER'
622: ,Get_Shipment_Number(p_line_id));
623: FND_MESSAGE.SET_TOKEN('BLANKET_UOM',
624: g_blkt_line_tbl(l_blanket_line_id).uom);

Line 621: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUMBER'

617: IF p_line_set_id IS NOT NULL THEN
618: IF g_blkt_line_tbl(l_blanket_line_id).OVERRIDE_RELEASE_CONTROLS_FLAG = 'N' THEN
619: FND_MESSAGE.SET_NAME('ONT','OE_BL_MIN_MAX_SHIPMENT_QTY');
620: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Line_Number(p_line_id));
621: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUMBER'
622: ,Get_Shipment_Number(p_line_id));
623: FND_MESSAGE.SET_TOKEN('BLANKET_UOM',
624: g_blkt_line_tbl(l_blanket_line_id).uom);
625: FND_MESSAGE.SET_TOKEN('MINIMUM',

Line 623: FND_MESSAGE.SET_TOKEN('BLANKET_UOM',

619: FND_MESSAGE.SET_NAME('ONT','OE_BL_MIN_MAX_SHIPMENT_QTY');
620: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Line_Number(p_line_id));
621: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUMBER'
622: ,Get_Shipment_Number(p_line_id));
623: FND_MESSAGE.SET_TOKEN('BLANKET_UOM',
624: g_blkt_line_tbl(l_blanket_line_id).uom);
625: FND_MESSAGE.SET_TOKEN('MINIMUM',
626: g_blkt_line_tbl(l_blanket_line_id).min_release_quantity);
627: FND_MESSAGE.SET_TOKEN('MAXIMUM',

Line 625: FND_MESSAGE.SET_TOKEN('MINIMUM',

621: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUMBER'
622: ,Get_Shipment_Number(p_line_id));
623: FND_MESSAGE.SET_TOKEN('BLANKET_UOM',
624: g_blkt_line_tbl(l_blanket_line_id).uom);
625: FND_MESSAGE.SET_TOKEN('MINIMUM',
626: g_blkt_line_tbl(l_blanket_line_id).min_release_quantity);
627: FND_MESSAGE.SET_TOKEN('MAXIMUM',
628: g_blkt_line_tbl(l_blanket_line_id).max_release_quantity);
629: oe_msg_pub.add;

Line 627: FND_MESSAGE.SET_TOKEN('MAXIMUM',

623: FND_MESSAGE.SET_TOKEN('BLANKET_UOM',
624: g_blkt_line_tbl(l_blanket_line_id).uom);
625: FND_MESSAGE.SET_TOKEN('MINIMUM',
626: g_blkt_line_tbl(l_blanket_line_id).min_release_quantity);
627: FND_MESSAGE.SET_TOKEN('MAXIMUM',
628: g_blkt_line_tbl(l_blanket_line_id).max_release_quantity);
629: oe_msg_pub.add;
630: ELSE
631: IF NVL(FND_PROFILE.VALUE('ONT_BSA_MIN_MAX_VIOLATION'),'N') = 'Y' THEN

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

628: g_blkt_line_tbl(l_blanket_line_id).max_release_quantity);
629: oe_msg_pub.add;
630: ELSE
631: IF NVL(FND_PROFILE.VALUE('ONT_BSA_MIN_MAX_VIOLATION'),'N') = 'Y' THEN
632: FND_MESSAGE.SET_NAME('ONT','OE_BL_MIN_MAX_SHIPMENT_QTY');
633: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Line_Number(p_line_id));
634: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUMBER'
635: ,Get_Shipment_Number(p_line_id));
636: FND_MESSAGE.SET_TOKEN('BLANKET_UOM',

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

629: oe_msg_pub.add;
630: ELSE
631: IF NVL(FND_PROFILE.VALUE('ONT_BSA_MIN_MAX_VIOLATION'),'N') = 'Y' THEN
632: FND_MESSAGE.SET_NAME('ONT','OE_BL_MIN_MAX_SHIPMENT_QTY');
633: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Line_Number(p_line_id));
634: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUMBER'
635: ,Get_Shipment_Number(p_line_id));
636: FND_MESSAGE.SET_TOKEN('BLANKET_UOM',
637: g_blkt_line_tbl(l_blanket_line_id).uom);

Line 634: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUMBER'

630: ELSE
631: IF NVL(FND_PROFILE.VALUE('ONT_BSA_MIN_MAX_VIOLATION'),'N') = 'Y' THEN
632: FND_MESSAGE.SET_NAME('ONT','OE_BL_MIN_MAX_SHIPMENT_QTY');
633: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Line_Number(p_line_id));
634: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUMBER'
635: ,Get_Shipment_Number(p_line_id));
636: FND_MESSAGE.SET_TOKEN('BLANKET_UOM',
637: g_blkt_line_tbl(l_blanket_line_id).uom);
638: FND_MESSAGE.SET_TOKEN('MINIMUM',

Line 636: FND_MESSAGE.SET_TOKEN('BLANKET_UOM',

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

Line 638: FND_MESSAGE.SET_TOKEN('MINIMUM',

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

Line 640: FND_MESSAGE.SET_TOKEN('MAXIMUM',

636: FND_MESSAGE.SET_TOKEN('BLANKET_UOM',
637: g_blkt_line_tbl(l_blanket_line_id).uom);
638: FND_MESSAGE.SET_TOKEN('MINIMUM',
639: g_blkt_line_tbl(l_blanket_line_id).min_release_quantity);
640: FND_MESSAGE.SET_TOKEN('MAXIMUM',
641: g_blkt_line_tbl(l_blanket_line_id).max_release_quantity);
642: oe_msg_pub.add;
643: END IF;
644: END IF;

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

645:
646: -- For regular lines, raise error.
647: ELSE
648: IF g_blkt_line_tbl(l_blanket_line_id).OVERRIDE_RELEASE_CONTROLS_FLAG = 'N' THEN
649: FND_MESSAGE.SET_NAME('ONT','OE_BL_MIN_MAX_REL_QTY');
650: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Line_Number(p_line_id));
651: FND_MESSAGE.SET_TOKEN('BLANKET_UOM',
652: g_blkt_line_tbl(l_blanket_line_id).uom);
653: FND_MESSAGE.SET_TOKEN('MINIMUM',

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

646: -- For regular lines, raise error.
647: ELSE
648: IF g_blkt_line_tbl(l_blanket_line_id).OVERRIDE_RELEASE_CONTROLS_FLAG = 'N' THEN
649: FND_MESSAGE.SET_NAME('ONT','OE_BL_MIN_MAX_REL_QTY');
650: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Line_Number(p_line_id));
651: FND_MESSAGE.SET_TOKEN('BLANKET_UOM',
652: g_blkt_line_tbl(l_blanket_line_id).uom);
653: FND_MESSAGE.SET_TOKEN('MINIMUM',
654: g_blkt_line_tbl(l_blanket_line_id).min_release_quantity);

Line 651: FND_MESSAGE.SET_TOKEN('BLANKET_UOM',

647: ELSE
648: IF g_blkt_line_tbl(l_blanket_line_id).OVERRIDE_RELEASE_CONTROLS_FLAG = 'N' THEN
649: FND_MESSAGE.SET_NAME('ONT','OE_BL_MIN_MAX_REL_QTY');
650: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Line_Number(p_line_id));
651: FND_MESSAGE.SET_TOKEN('BLANKET_UOM',
652: g_blkt_line_tbl(l_blanket_line_id).uom);
653: FND_MESSAGE.SET_TOKEN('MINIMUM',
654: g_blkt_line_tbl(l_blanket_line_id).min_release_quantity);
655: FND_MESSAGE.SET_TOKEN('MAXIMUM',

Line 653: FND_MESSAGE.SET_TOKEN('MINIMUM',

649: FND_MESSAGE.SET_NAME('ONT','OE_BL_MIN_MAX_REL_QTY');
650: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Line_Number(p_line_id));
651: FND_MESSAGE.SET_TOKEN('BLANKET_UOM',
652: g_blkt_line_tbl(l_blanket_line_id).uom);
653: FND_MESSAGE.SET_TOKEN('MINIMUM',
654: g_blkt_line_tbl(l_blanket_line_id).min_release_quantity);
655: FND_MESSAGE.SET_TOKEN('MAXIMUM',
656: g_blkt_line_tbl(l_blanket_line_id).max_release_quantity);
657: oe_msg_pub.add;

Line 655: FND_MESSAGE.SET_TOKEN('MAXIMUM',

651: FND_MESSAGE.SET_TOKEN('BLANKET_UOM',
652: g_blkt_line_tbl(l_blanket_line_id).uom);
653: FND_MESSAGE.SET_TOKEN('MINIMUM',
654: g_blkt_line_tbl(l_blanket_line_id).min_release_quantity);
655: FND_MESSAGE.SET_TOKEN('MAXIMUM',
656: g_blkt_line_tbl(l_blanket_line_id).max_release_quantity);
657: oe_msg_pub.add;
658: x_return_status := FND_API.G_RET_STS_ERROR;
659:

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

658: x_return_status := FND_API.G_RET_STS_ERROR;
659:
660: ELSE
661: IF NVL(FND_PROFILE.VALUE('ONT_BSA_MIN_MAX_VIOLATION'),'N') = 'Y' THEN
662: FND_MESSAGE.SET_NAME('ONT','OE_BL_MIN_MAX_REL_QTY');
663: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Line_Number(p_line_id));
664: FND_MESSAGE.SET_TOKEN('BLANKET_UOM',
665: g_blkt_line_tbl(l_blanket_line_id).uom);
666: FND_MESSAGE.SET_TOKEN('MINIMUM',

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

659:
660: ELSE
661: IF NVL(FND_PROFILE.VALUE('ONT_BSA_MIN_MAX_VIOLATION'),'N') = 'Y' THEN
662: FND_MESSAGE.SET_NAME('ONT','OE_BL_MIN_MAX_REL_QTY');
663: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Line_Number(p_line_id));
664: FND_MESSAGE.SET_TOKEN('BLANKET_UOM',
665: g_blkt_line_tbl(l_blanket_line_id).uom);
666: FND_MESSAGE.SET_TOKEN('MINIMUM',
667: g_blkt_line_tbl(l_blanket_line_id).min_release_quantity);

Line 664: FND_MESSAGE.SET_TOKEN('BLANKET_UOM',

660: ELSE
661: IF NVL(FND_PROFILE.VALUE('ONT_BSA_MIN_MAX_VIOLATION'),'N') = 'Y' THEN
662: FND_MESSAGE.SET_NAME('ONT','OE_BL_MIN_MAX_REL_QTY');
663: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Line_Number(p_line_id));
664: FND_MESSAGE.SET_TOKEN('BLANKET_UOM',
665: g_blkt_line_tbl(l_blanket_line_id).uom);
666: FND_MESSAGE.SET_TOKEN('MINIMUM',
667: g_blkt_line_tbl(l_blanket_line_id).min_release_quantity);
668: FND_MESSAGE.SET_TOKEN('MAXIMUM',

Line 666: FND_MESSAGE.SET_TOKEN('MINIMUM',

662: FND_MESSAGE.SET_NAME('ONT','OE_BL_MIN_MAX_REL_QTY');
663: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Line_Number(p_line_id));
664: FND_MESSAGE.SET_TOKEN('BLANKET_UOM',
665: g_blkt_line_tbl(l_blanket_line_id).uom);
666: FND_MESSAGE.SET_TOKEN('MINIMUM',
667: g_blkt_line_tbl(l_blanket_line_id).min_release_quantity);
668: FND_MESSAGE.SET_TOKEN('MAXIMUM',
669: g_blkt_line_tbl(l_blanket_line_id).max_release_quantity);
670: oe_msg_pub.add;

Line 668: FND_MESSAGE.SET_TOKEN('MAXIMUM',

664: FND_MESSAGE.SET_TOKEN('BLANKET_UOM',
665: g_blkt_line_tbl(l_blanket_line_id).uom);
666: FND_MESSAGE.SET_TOKEN('MINIMUM',
667: g_blkt_line_tbl(l_blanket_line_id).min_release_quantity);
668: FND_MESSAGE.SET_TOKEN('MAXIMUM',
669: g_blkt_line_tbl(l_blanket_line_id).max_release_quantity);
670: oe_msg_pub.add;
671: END IF;
672:

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

696: THEN
697: -- If shipment line, only a warning is issued. Error status is not set.
698: IF p_line_set_id IS NOT NULL THEN
699: IF g_blkt_line_tbl(l_blanket_line_id).OVERRIDE_RELEASE_CONTROLS_FLAG = 'N' THEN
700: FND_MESSAGE.SET_NAME('ONT','OE_BL_MIN_MAX_SHIPMENT_AMT');
701: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Line_Number(p_line_id));
702: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUMBER'
703: ,Get_Shipment_Number(p_line_id));
704: FND_MESSAGE.SET_TOKEN('BLANKET_CURRENCY',

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

697: -- If shipment line, only a warning is issued. Error status is not set.
698: IF p_line_set_id IS NOT NULL THEN
699: IF g_blkt_line_tbl(l_blanket_line_id).OVERRIDE_RELEASE_CONTROLS_FLAG = 'N' THEN
700: FND_MESSAGE.SET_NAME('ONT','OE_BL_MIN_MAX_SHIPMENT_AMT');
701: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Line_Number(p_line_id));
702: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUMBER'
703: ,Get_Shipment_Number(p_line_id));
704: FND_MESSAGE.SET_TOKEN('BLANKET_CURRENCY',
705: g_blkt_hdr_tbl(l_blanket_header_id).currency_code);

Line 702: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUMBER'

698: IF p_line_set_id IS NOT NULL THEN
699: IF g_blkt_line_tbl(l_blanket_line_id).OVERRIDE_RELEASE_CONTROLS_FLAG = 'N' THEN
700: FND_MESSAGE.SET_NAME('ONT','OE_BL_MIN_MAX_SHIPMENT_AMT');
701: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Line_Number(p_line_id));
702: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUMBER'
703: ,Get_Shipment_Number(p_line_id));
704: FND_MESSAGE.SET_TOKEN('BLANKET_CURRENCY',
705: g_blkt_hdr_tbl(l_blanket_header_id).currency_code);
706: FND_MESSAGE.SET_TOKEN('MINIMUM',

Line 704: FND_MESSAGE.SET_TOKEN('BLANKET_CURRENCY',

700: FND_MESSAGE.SET_NAME('ONT','OE_BL_MIN_MAX_SHIPMENT_AMT');
701: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Line_Number(p_line_id));
702: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUMBER'
703: ,Get_Shipment_Number(p_line_id));
704: FND_MESSAGE.SET_TOKEN('BLANKET_CURRENCY',
705: g_blkt_hdr_tbl(l_blanket_header_id).currency_code);
706: FND_MESSAGE.SET_TOKEN('MINIMUM',
707: g_blkt_line_tbl(l_blanket_line_id).min_release_amount);
708: FND_MESSAGE.SET_TOKEN('MAXIMUM',

Line 706: FND_MESSAGE.SET_TOKEN('MINIMUM',

702: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUMBER'
703: ,Get_Shipment_Number(p_line_id));
704: FND_MESSAGE.SET_TOKEN('BLANKET_CURRENCY',
705: g_blkt_hdr_tbl(l_blanket_header_id).currency_code);
706: FND_MESSAGE.SET_TOKEN('MINIMUM',
707: g_blkt_line_tbl(l_blanket_line_id).min_release_amount);
708: FND_MESSAGE.SET_TOKEN('MAXIMUM',
709: g_blkt_line_tbl(l_blanket_line_id).max_release_amount);
710: oe_msg_pub.add;

Line 708: FND_MESSAGE.SET_TOKEN('MAXIMUM',

704: FND_MESSAGE.SET_TOKEN('BLANKET_CURRENCY',
705: g_blkt_hdr_tbl(l_blanket_header_id).currency_code);
706: FND_MESSAGE.SET_TOKEN('MINIMUM',
707: g_blkt_line_tbl(l_blanket_line_id).min_release_amount);
708: FND_MESSAGE.SET_TOKEN('MAXIMUM',
709: g_blkt_line_tbl(l_blanket_line_id).max_release_amount);
710: oe_msg_pub.add;
711: ELSE
712: IF NVL(FND_PROFILE.VALUE('ONT_BSA_MIN_MAX_VIOLATION'),'N') = 'Y' THEN

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

709: g_blkt_line_tbl(l_blanket_line_id).max_release_amount);
710: oe_msg_pub.add;
711: ELSE
712: IF NVL(FND_PROFILE.VALUE('ONT_BSA_MIN_MAX_VIOLATION'),'N') = 'Y' THEN
713: FND_MESSAGE.SET_NAME('ONT','OE_BL_MIN_MAX_SHIPMENT_AMT');
714: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Line_Number(p_line_id));
715: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUMBER'
716: ,Get_Shipment_Number(p_line_id));
717: FND_MESSAGE.SET_TOKEN('BLANKET_CURRENCY',

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

710: oe_msg_pub.add;
711: ELSE
712: IF NVL(FND_PROFILE.VALUE('ONT_BSA_MIN_MAX_VIOLATION'),'N') = 'Y' THEN
713: FND_MESSAGE.SET_NAME('ONT','OE_BL_MIN_MAX_SHIPMENT_AMT');
714: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Line_Number(p_line_id));
715: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUMBER'
716: ,Get_Shipment_Number(p_line_id));
717: FND_MESSAGE.SET_TOKEN('BLANKET_CURRENCY',
718: g_blkt_hdr_tbl(l_blanket_header_id).currency_code);

Line 715: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUMBER'

711: ELSE
712: IF NVL(FND_PROFILE.VALUE('ONT_BSA_MIN_MAX_VIOLATION'),'N') = 'Y' THEN
713: FND_MESSAGE.SET_NAME('ONT','OE_BL_MIN_MAX_SHIPMENT_AMT');
714: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Line_Number(p_line_id));
715: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUMBER'
716: ,Get_Shipment_Number(p_line_id));
717: FND_MESSAGE.SET_TOKEN('BLANKET_CURRENCY',
718: g_blkt_hdr_tbl(l_blanket_header_id).currency_code);
719: FND_MESSAGE.SET_TOKEN('MINIMUM',

Line 717: FND_MESSAGE.SET_TOKEN('BLANKET_CURRENCY',

713: FND_MESSAGE.SET_NAME('ONT','OE_BL_MIN_MAX_SHIPMENT_AMT');
714: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Line_Number(p_line_id));
715: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUMBER'
716: ,Get_Shipment_Number(p_line_id));
717: FND_MESSAGE.SET_TOKEN('BLANKET_CURRENCY',
718: g_blkt_hdr_tbl(l_blanket_header_id).currency_code);
719: FND_MESSAGE.SET_TOKEN('MINIMUM',
720: g_blkt_line_tbl(l_blanket_line_id).min_release_amount);
721: FND_MESSAGE.SET_TOKEN('MAXIMUM',

Line 719: FND_MESSAGE.SET_TOKEN('MINIMUM',

715: FND_MESSAGE.SET_TOKEN('SHIPMENT_NUMBER'
716: ,Get_Shipment_Number(p_line_id));
717: FND_MESSAGE.SET_TOKEN('BLANKET_CURRENCY',
718: g_blkt_hdr_tbl(l_blanket_header_id).currency_code);
719: FND_MESSAGE.SET_TOKEN('MINIMUM',
720: g_blkt_line_tbl(l_blanket_line_id).min_release_amount);
721: FND_MESSAGE.SET_TOKEN('MAXIMUM',
722: g_blkt_line_tbl(l_blanket_line_id).max_release_amount);
723: oe_msg_pub.add;

Line 721: FND_MESSAGE.SET_TOKEN('MAXIMUM',

717: FND_MESSAGE.SET_TOKEN('BLANKET_CURRENCY',
718: g_blkt_hdr_tbl(l_blanket_header_id).currency_code);
719: FND_MESSAGE.SET_TOKEN('MINIMUM',
720: g_blkt_line_tbl(l_blanket_line_id).min_release_amount);
721: FND_MESSAGE.SET_TOKEN('MAXIMUM',
722: g_blkt_line_tbl(l_blanket_line_id).max_release_amount);
723: oe_msg_pub.add;
724: END IF;
725:

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

727:
728: -- For regular lines, raise error.
729: ELSE
730: IF g_blkt_line_tbl(l_blanket_line_id).OVERRIDE_RELEASE_CONTROLS_FLAG = 'N' THEN
731: FND_MESSAGE.SET_NAME('ONT','OE_BL_MIN_MAX_REL_AMT');
732: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Line_Number(p_line_id));
733: FND_MESSAGE.SET_TOKEN('BLANKET_CURRENCY',
734: g_blkt_hdr_tbl(l_blanket_header_id).currency_code);
735: FND_MESSAGE.SET_TOKEN('MINIMUM',

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

728: -- For regular lines, raise error.
729: ELSE
730: IF g_blkt_line_tbl(l_blanket_line_id).OVERRIDE_RELEASE_CONTROLS_FLAG = 'N' THEN
731: FND_MESSAGE.SET_NAME('ONT','OE_BL_MIN_MAX_REL_AMT');
732: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Line_Number(p_line_id));
733: FND_MESSAGE.SET_TOKEN('BLANKET_CURRENCY',
734: g_blkt_hdr_tbl(l_blanket_header_id).currency_code);
735: FND_MESSAGE.SET_TOKEN('MINIMUM',
736: g_blkt_line_tbl(l_blanket_line_id).min_release_amount);

Line 733: FND_MESSAGE.SET_TOKEN('BLANKET_CURRENCY',

729: ELSE
730: IF g_blkt_line_tbl(l_blanket_line_id).OVERRIDE_RELEASE_CONTROLS_FLAG = 'N' THEN
731: FND_MESSAGE.SET_NAME('ONT','OE_BL_MIN_MAX_REL_AMT');
732: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Line_Number(p_line_id));
733: FND_MESSAGE.SET_TOKEN('BLANKET_CURRENCY',
734: g_blkt_hdr_tbl(l_blanket_header_id).currency_code);
735: FND_MESSAGE.SET_TOKEN('MINIMUM',
736: g_blkt_line_tbl(l_blanket_line_id).min_release_amount);
737: FND_MESSAGE.SET_TOKEN('MAXIMUM',

Line 735: FND_MESSAGE.SET_TOKEN('MINIMUM',

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

Line 737: FND_MESSAGE.SET_TOKEN('MAXIMUM',

733: FND_MESSAGE.SET_TOKEN('BLANKET_CURRENCY',
734: g_blkt_hdr_tbl(l_blanket_header_id).currency_code);
735: FND_MESSAGE.SET_TOKEN('MINIMUM',
736: g_blkt_line_tbl(l_blanket_line_id).min_release_amount);
737: FND_MESSAGE.SET_TOKEN('MAXIMUM',
738: g_blkt_line_tbl(l_blanket_line_id).max_release_amount);
739: oe_msg_pub.add;
740: x_return_status := FND_API.G_RET_STS_ERROR;
741:

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

740: x_return_status := FND_API.G_RET_STS_ERROR;
741:
742: ELSE
743: IF NVL(FND_PROFILE.VALUE('ONT_BSA_MIN_MAX_VIOLATION'),'N') = 'Y' THEN
744: FND_MESSAGE.SET_NAME('ONT','OE_BL_MIN_MAX_REL_AMT');
745: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Line_Number(p_line_id));
746: FND_MESSAGE.SET_TOKEN('BLANKET_CURRENCY',
747: g_blkt_hdr_tbl(l_blanket_header_id).currency_code);
748: FND_MESSAGE.SET_TOKEN('MINIMUM',

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

741:
742: ELSE
743: IF NVL(FND_PROFILE.VALUE('ONT_BSA_MIN_MAX_VIOLATION'),'N') = 'Y' THEN
744: FND_MESSAGE.SET_NAME('ONT','OE_BL_MIN_MAX_REL_AMT');
745: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Line_Number(p_line_id));
746: FND_MESSAGE.SET_TOKEN('BLANKET_CURRENCY',
747: g_blkt_hdr_tbl(l_blanket_header_id).currency_code);
748: FND_MESSAGE.SET_TOKEN('MINIMUM',
749: g_blkt_line_tbl(l_blanket_line_id).min_release_amount);

Line 746: FND_MESSAGE.SET_TOKEN('BLANKET_CURRENCY',

742: ELSE
743: IF NVL(FND_PROFILE.VALUE('ONT_BSA_MIN_MAX_VIOLATION'),'N') = 'Y' THEN
744: FND_MESSAGE.SET_NAME('ONT','OE_BL_MIN_MAX_REL_AMT');
745: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Line_Number(p_line_id));
746: FND_MESSAGE.SET_TOKEN('BLANKET_CURRENCY',
747: g_blkt_hdr_tbl(l_blanket_header_id).currency_code);
748: FND_MESSAGE.SET_TOKEN('MINIMUM',
749: g_blkt_line_tbl(l_blanket_line_id).min_release_amount);
750: FND_MESSAGE.SET_TOKEN('MAXIMUM',

Line 748: FND_MESSAGE.SET_TOKEN('MINIMUM',

744: FND_MESSAGE.SET_NAME('ONT','OE_BL_MIN_MAX_REL_AMT');
745: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Line_Number(p_line_id));
746: FND_MESSAGE.SET_TOKEN('BLANKET_CURRENCY',
747: g_blkt_hdr_tbl(l_blanket_header_id).currency_code);
748: FND_MESSAGE.SET_TOKEN('MINIMUM',
749: g_blkt_line_tbl(l_blanket_line_id).min_release_amount);
750: FND_MESSAGE.SET_TOKEN('MAXIMUM',
751: g_blkt_line_tbl(l_blanket_line_id).max_release_amount);
752: oe_msg_pub.add;

Line 750: FND_MESSAGE.SET_TOKEN('MAXIMUM',

746: FND_MESSAGE.SET_TOKEN('BLANKET_CURRENCY',
747: g_blkt_hdr_tbl(l_blanket_header_id).currency_code);
748: FND_MESSAGE.SET_TOKEN('MINIMUM',
749: g_blkt_line_tbl(l_blanket_line_id).min_release_amount);
750: FND_MESSAGE.SET_TOKEN('MAXIMUM',
751: g_blkt_line_tbl(l_blanket_line_id).max_release_amount);
752: oe_msg_pub.add;
753: END IF;
754:

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

771: (g_blkt_line_tbl(l_blanket_line_id).blanket_max_quantity
772: + g_blkt_line_tbl(l_blanket_line_id).returned_quantity)
773: THEN
774: IF g_blkt_line_tbl(l_blanket_line_id).OVERRIDE_BLANKET_CONTROLS_FLAG = 'N' THEN
775: FND_MESSAGE.SET_NAME('ONT','OE_BL_LIN_MAX_QTY_EXCEEDED');
776: FND_MESSAGE.SET_TOKEN('BLANKET_NUMBER',p_blanket_number);
777: FND_MESSAGE.SET_TOKEN('BLANKET_LINE_NUMBER',p_blanket_line_number);
778: FND_MESSAGE.SET_TOKEN('BLANKET_UOM',
779: g_blkt_line_tbl(l_blanket_line_id).uom);

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

772: + g_blkt_line_tbl(l_blanket_line_id).returned_quantity)
773: THEN
774: IF g_blkt_line_tbl(l_blanket_line_id).OVERRIDE_BLANKET_CONTROLS_FLAG = 'N' THEN
775: FND_MESSAGE.SET_NAME('ONT','OE_BL_LIN_MAX_QTY_EXCEEDED');
776: FND_MESSAGE.SET_TOKEN('BLANKET_NUMBER',p_blanket_number);
777: FND_MESSAGE.SET_TOKEN('BLANKET_LINE_NUMBER',p_blanket_line_number);
778: FND_MESSAGE.SET_TOKEN('BLANKET_UOM',
779: g_blkt_line_tbl(l_blanket_line_id).uom);
780: FND_MESSAGE.SET_TOKEN('MAXIMUM',

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

773: THEN
774: IF g_blkt_line_tbl(l_blanket_line_id).OVERRIDE_BLANKET_CONTROLS_FLAG = 'N' THEN
775: FND_MESSAGE.SET_NAME('ONT','OE_BL_LIN_MAX_QTY_EXCEEDED');
776: FND_MESSAGE.SET_TOKEN('BLANKET_NUMBER',p_blanket_number);
777: FND_MESSAGE.SET_TOKEN('BLANKET_LINE_NUMBER',p_blanket_line_number);
778: FND_MESSAGE.SET_TOKEN('BLANKET_UOM',
779: g_blkt_line_tbl(l_blanket_line_id).uom);
780: FND_MESSAGE.SET_TOKEN('MAXIMUM',
781: g_blkt_line_tbl(l_blanket_line_id).blanket_max_quantity);

Line 778: FND_MESSAGE.SET_TOKEN('BLANKET_UOM',

774: IF g_blkt_line_tbl(l_blanket_line_id).OVERRIDE_BLANKET_CONTROLS_FLAG = 'N' THEN
775: FND_MESSAGE.SET_NAME('ONT','OE_BL_LIN_MAX_QTY_EXCEEDED');
776: FND_MESSAGE.SET_TOKEN('BLANKET_NUMBER',p_blanket_number);
777: FND_MESSAGE.SET_TOKEN('BLANKET_LINE_NUMBER',p_blanket_line_number);
778: FND_MESSAGE.SET_TOKEN('BLANKET_UOM',
779: g_blkt_line_tbl(l_blanket_line_id).uom);
780: FND_MESSAGE.SET_TOKEN('MAXIMUM',
781: g_blkt_line_tbl(l_blanket_line_id).blanket_max_quantity);
782: oe_msg_pub.add;

Line 780: FND_MESSAGE.SET_TOKEN('MAXIMUM',

776: FND_MESSAGE.SET_TOKEN('BLANKET_NUMBER',p_blanket_number);
777: FND_MESSAGE.SET_TOKEN('BLANKET_LINE_NUMBER',p_blanket_line_number);
778: FND_MESSAGE.SET_TOKEN('BLANKET_UOM',
779: g_blkt_line_tbl(l_blanket_line_id).uom);
780: FND_MESSAGE.SET_TOKEN('MAXIMUM',
781: g_blkt_line_tbl(l_blanket_line_id).blanket_max_quantity);
782: oe_msg_pub.add;
783: x_return_status := FND_API.G_RET_STS_ERROR;
784: ELSE

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

782: oe_msg_pub.add;
783: x_return_status := FND_API.G_RET_STS_ERROR;
784: ELSE
785: IF NVL(FND_PROFILE.VALUE('ONT_BSA_MIN_MAX_VIOLATION'),'N') = 'Y' THEN
786: FND_MESSAGE.SET_NAME('ONT','OE_BL_LIN_MAX_QTY_EXCEEDED');
787: FND_MESSAGE.SET_TOKEN('BLANKET_NUMBER',p_blanket_number);
788: FND_MESSAGE.SET_TOKEN('BLANKET_LINE_NUMBER',p_blanket_line_number);
789: FND_MESSAGE.SET_TOKEN('BLANKET_UOM',
790: g_blkt_line_tbl(l_blanket_line_id).uom);

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

783: x_return_status := FND_API.G_RET_STS_ERROR;
784: ELSE
785: IF NVL(FND_PROFILE.VALUE('ONT_BSA_MIN_MAX_VIOLATION'),'N') = 'Y' THEN
786: FND_MESSAGE.SET_NAME('ONT','OE_BL_LIN_MAX_QTY_EXCEEDED');
787: FND_MESSAGE.SET_TOKEN('BLANKET_NUMBER',p_blanket_number);
788: FND_MESSAGE.SET_TOKEN('BLANKET_LINE_NUMBER',p_blanket_line_number);
789: FND_MESSAGE.SET_TOKEN('BLANKET_UOM',
790: g_blkt_line_tbl(l_blanket_line_id).uom);
791: FND_MESSAGE.SET_TOKEN('MAXIMUM',

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

784: ELSE
785: IF NVL(FND_PROFILE.VALUE('ONT_BSA_MIN_MAX_VIOLATION'),'N') = 'Y' THEN
786: FND_MESSAGE.SET_NAME('ONT','OE_BL_LIN_MAX_QTY_EXCEEDED');
787: FND_MESSAGE.SET_TOKEN('BLANKET_NUMBER',p_blanket_number);
788: FND_MESSAGE.SET_TOKEN('BLANKET_LINE_NUMBER',p_blanket_line_number);
789: FND_MESSAGE.SET_TOKEN('BLANKET_UOM',
790: g_blkt_line_tbl(l_blanket_line_id).uom);
791: FND_MESSAGE.SET_TOKEN('MAXIMUM',
792: g_blkt_line_tbl(l_blanket_line_id).blanket_max_quantity);

Line 789: FND_MESSAGE.SET_TOKEN('BLANKET_UOM',

785: IF NVL(FND_PROFILE.VALUE('ONT_BSA_MIN_MAX_VIOLATION'),'N') = 'Y' THEN
786: FND_MESSAGE.SET_NAME('ONT','OE_BL_LIN_MAX_QTY_EXCEEDED');
787: FND_MESSAGE.SET_TOKEN('BLANKET_NUMBER',p_blanket_number);
788: FND_MESSAGE.SET_TOKEN('BLANKET_LINE_NUMBER',p_blanket_line_number);
789: FND_MESSAGE.SET_TOKEN('BLANKET_UOM',
790: g_blkt_line_tbl(l_blanket_line_id).uom);
791: FND_MESSAGE.SET_TOKEN('MAXIMUM',
792: g_blkt_line_tbl(l_blanket_line_id).blanket_max_quantity);
793: oe_msg_pub.add;

Line 791: FND_MESSAGE.SET_TOKEN('MAXIMUM',

787: FND_MESSAGE.SET_TOKEN('BLANKET_NUMBER',p_blanket_number);
788: FND_MESSAGE.SET_TOKEN('BLANKET_LINE_NUMBER',p_blanket_line_number);
789: FND_MESSAGE.SET_TOKEN('BLANKET_UOM',
790: g_blkt_line_tbl(l_blanket_line_id).uom);
791: FND_MESSAGE.SET_TOKEN('MAXIMUM',
792: g_blkt_line_tbl(l_blanket_line_id).blanket_max_quantity);
793: oe_msg_pub.add;
794: END IF;
795:

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

801: (g_blkt_line_tbl(l_blanket_line_id).blanket_line_max_amount
802: + g_blkt_line_tbl(l_blanket_line_id).returned_amount)
803: THEN
804: IF g_blkt_line_tbl(l_blanket_line_id).OVERRIDE_BLANKET_CONTROLS_FLAG = 'N' THEN
805: FND_MESSAGE.SET_NAME('ONT','OE_BL_LIN_MAX_AMT_EXCEEDED');
806: FND_MESSAGE.SET_TOKEN('BLANKET_NUMBER',p_blanket_number);
807: FND_MESSAGE.SET_TOKEN('BLANKET_LINE_NUMBER',p_blanket_line_number);
808: FND_MESSAGE.SET_TOKEN('BLANKET_CURRENCY',
809: g_blkt_hdr_tbl(l_blanket_header_id).currency_code);

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

802: + g_blkt_line_tbl(l_blanket_line_id).returned_amount)
803: THEN
804: IF g_blkt_line_tbl(l_blanket_line_id).OVERRIDE_BLANKET_CONTROLS_FLAG = 'N' THEN
805: FND_MESSAGE.SET_NAME('ONT','OE_BL_LIN_MAX_AMT_EXCEEDED');
806: FND_MESSAGE.SET_TOKEN('BLANKET_NUMBER',p_blanket_number);
807: FND_MESSAGE.SET_TOKEN('BLANKET_LINE_NUMBER',p_blanket_line_number);
808: FND_MESSAGE.SET_TOKEN('BLANKET_CURRENCY',
809: g_blkt_hdr_tbl(l_blanket_header_id).currency_code);
810: FND_MESSAGE.SET_TOKEN('MAXIMUM',

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

803: THEN
804: IF g_blkt_line_tbl(l_blanket_line_id).OVERRIDE_BLANKET_CONTROLS_FLAG = 'N' THEN
805: FND_MESSAGE.SET_NAME('ONT','OE_BL_LIN_MAX_AMT_EXCEEDED');
806: FND_MESSAGE.SET_TOKEN('BLANKET_NUMBER',p_blanket_number);
807: FND_MESSAGE.SET_TOKEN('BLANKET_LINE_NUMBER',p_blanket_line_number);
808: FND_MESSAGE.SET_TOKEN('BLANKET_CURRENCY',
809: g_blkt_hdr_tbl(l_blanket_header_id).currency_code);
810: FND_MESSAGE.SET_TOKEN('MAXIMUM',
811: g_blkt_line_tbl(l_blanket_line_id).blanket_line_max_amount);

Line 808: FND_MESSAGE.SET_TOKEN('BLANKET_CURRENCY',

804: IF g_blkt_line_tbl(l_blanket_line_id).OVERRIDE_BLANKET_CONTROLS_FLAG = 'N' THEN
805: FND_MESSAGE.SET_NAME('ONT','OE_BL_LIN_MAX_AMT_EXCEEDED');
806: FND_MESSAGE.SET_TOKEN('BLANKET_NUMBER',p_blanket_number);
807: FND_MESSAGE.SET_TOKEN('BLANKET_LINE_NUMBER',p_blanket_line_number);
808: FND_MESSAGE.SET_TOKEN('BLANKET_CURRENCY',
809: g_blkt_hdr_tbl(l_blanket_header_id).currency_code);
810: FND_MESSAGE.SET_TOKEN('MAXIMUM',
811: g_blkt_line_tbl(l_blanket_line_id).blanket_line_max_amount);
812: oe_msg_pub.add;

Line 810: FND_MESSAGE.SET_TOKEN('MAXIMUM',

806: FND_MESSAGE.SET_TOKEN('BLANKET_NUMBER',p_blanket_number);
807: FND_MESSAGE.SET_TOKEN('BLANKET_LINE_NUMBER',p_blanket_line_number);
808: FND_MESSAGE.SET_TOKEN('BLANKET_CURRENCY',
809: g_blkt_hdr_tbl(l_blanket_header_id).currency_code);
810: FND_MESSAGE.SET_TOKEN('MAXIMUM',
811: g_blkt_line_tbl(l_blanket_line_id).blanket_line_max_amount);
812: oe_msg_pub.add;
813: x_return_status := FND_API.G_RET_STS_ERROR;
814: ELSE

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

812: oe_msg_pub.add;
813: x_return_status := FND_API.G_RET_STS_ERROR;
814: ELSE
815: IF NVL(FND_PROFILE.VALUE('ONT_BSA_MIN_MAX_VIOLATION'),'N') = 'Y' THEN
816: FND_MESSAGE.SET_NAME('ONT','OE_BL_LIN_MAX_AMT_EXCEEDED');
817: FND_MESSAGE.SET_TOKEN('BLANKET_NUMBER',p_blanket_number);
818: FND_MESSAGE.SET_TOKEN('BLANKET_LINE_NUMBER',p_blanket_line_number);
819: FND_MESSAGE.SET_TOKEN('BLANKET_CURRENCY',
820: g_blkt_hdr_tbl(l_blanket_header_id).currency_code);

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

813: x_return_status := FND_API.G_RET_STS_ERROR;
814: ELSE
815: IF NVL(FND_PROFILE.VALUE('ONT_BSA_MIN_MAX_VIOLATION'),'N') = 'Y' THEN
816: FND_MESSAGE.SET_NAME('ONT','OE_BL_LIN_MAX_AMT_EXCEEDED');
817: FND_MESSAGE.SET_TOKEN('BLANKET_NUMBER',p_blanket_number);
818: FND_MESSAGE.SET_TOKEN('BLANKET_LINE_NUMBER',p_blanket_line_number);
819: FND_MESSAGE.SET_TOKEN('BLANKET_CURRENCY',
820: g_blkt_hdr_tbl(l_blanket_header_id).currency_code);
821: FND_MESSAGE.SET_TOKEN('MAXIMUM',

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

814: ELSE
815: IF NVL(FND_PROFILE.VALUE('ONT_BSA_MIN_MAX_VIOLATION'),'N') = 'Y' THEN
816: FND_MESSAGE.SET_NAME('ONT','OE_BL_LIN_MAX_AMT_EXCEEDED');
817: FND_MESSAGE.SET_TOKEN('BLANKET_NUMBER',p_blanket_number);
818: FND_MESSAGE.SET_TOKEN('BLANKET_LINE_NUMBER',p_blanket_line_number);
819: FND_MESSAGE.SET_TOKEN('BLANKET_CURRENCY',
820: g_blkt_hdr_tbl(l_blanket_header_id).currency_code);
821: FND_MESSAGE.SET_TOKEN('MAXIMUM',
822: g_blkt_line_tbl(l_blanket_line_id).blanket_line_max_amount);

Line 819: FND_MESSAGE.SET_TOKEN('BLANKET_CURRENCY',

815: IF NVL(FND_PROFILE.VALUE('ONT_BSA_MIN_MAX_VIOLATION'),'N') = 'Y' THEN
816: FND_MESSAGE.SET_NAME('ONT','OE_BL_LIN_MAX_AMT_EXCEEDED');
817: FND_MESSAGE.SET_TOKEN('BLANKET_NUMBER',p_blanket_number);
818: FND_MESSAGE.SET_TOKEN('BLANKET_LINE_NUMBER',p_blanket_line_number);
819: FND_MESSAGE.SET_TOKEN('BLANKET_CURRENCY',
820: g_blkt_hdr_tbl(l_blanket_header_id).currency_code);
821: FND_MESSAGE.SET_TOKEN('MAXIMUM',
822: g_blkt_line_tbl(l_blanket_line_id).blanket_line_max_amount);
823: oe_msg_pub.add;

Line 821: FND_MESSAGE.SET_TOKEN('MAXIMUM',

817: FND_MESSAGE.SET_TOKEN('BLANKET_NUMBER',p_blanket_number);
818: FND_MESSAGE.SET_TOKEN('BLANKET_LINE_NUMBER',p_blanket_line_number);
819: FND_MESSAGE.SET_TOKEN('BLANKET_CURRENCY',
820: g_blkt_hdr_tbl(l_blanket_header_id).currency_code);
821: FND_MESSAGE.SET_TOKEN('MAXIMUM',
822: g_blkt_line_tbl(l_blanket_line_id).blanket_line_max_amount);
823: oe_msg_pub.add;
824: END IF;
825:

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

844: (g_blkt_hdr_tbl(l_blanket_header_id).blanket_max_amount
845: + g_blkt_hdr_tbl(l_blanket_header_id).returned_amount)
846: THEN
847: IF g_blkt_hdr_tbl(l_blanket_header_id).override_amount_flag = 'N' THEN
848: FND_MESSAGE.SET_NAME('ONT','OE_BL_HDR_MAX_AMT_EXCEEDED');
849: FND_MESSAGE.SET_TOKEN('BLANKET_NUMBER',p_blanket_number);
850: FND_MESSAGE.SET_TOKEN('BLANKET_CURRENCY',
851: g_blkt_hdr_tbl(l_blanket_header_id).currency_code);
852: FND_MESSAGE.SET_TOKEN('MAXIMUM',

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

845: + g_blkt_hdr_tbl(l_blanket_header_id).returned_amount)
846: THEN
847: IF g_blkt_hdr_tbl(l_blanket_header_id).override_amount_flag = 'N' THEN
848: FND_MESSAGE.SET_NAME('ONT','OE_BL_HDR_MAX_AMT_EXCEEDED');
849: FND_MESSAGE.SET_TOKEN('BLANKET_NUMBER',p_blanket_number);
850: FND_MESSAGE.SET_TOKEN('BLANKET_CURRENCY',
851: g_blkt_hdr_tbl(l_blanket_header_id).currency_code);
852: FND_MESSAGE.SET_TOKEN('MAXIMUM',
853: g_blkt_hdr_tbl(l_blanket_header_id).blanket_max_amount);

Line 850: FND_MESSAGE.SET_TOKEN('BLANKET_CURRENCY',

846: THEN
847: IF g_blkt_hdr_tbl(l_blanket_header_id).override_amount_flag = 'N' THEN
848: FND_MESSAGE.SET_NAME('ONT','OE_BL_HDR_MAX_AMT_EXCEEDED');
849: FND_MESSAGE.SET_TOKEN('BLANKET_NUMBER',p_blanket_number);
850: FND_MESSAGE.SET_TOKEN('BLANKET_CURRENCY',
851: g_blkt_hdr_tbl(l_blanket_header_id).currency_code);
852: FND_MESSAGE.SET_TOKEN('MAXIMUM',
853: g_blkt_hdr_tbl(l_blanket_header_id).blanket_max_amount);
854: oe_msg_pub.add;

Line 852: FND_MESSAGE.SET_TOKEN('MAXIMUM',

848: FND_MESSAGE.SET_NAME('ONT','OE_BL_HDR_MAX_AMT_EXCEEDED');
849: FND_MESSAGE.SET_TOKEN('BLANKET_NUMBER',p_blanket_number);
850: FND_MESSAGE.SET_TOKEN('BLANKET_CURRENCY',
851: g_blkt_hdr_tbl(l_blanket_header_id).currency_code);
852: FND_MESSAGE.SET_TOKEN('MAXIMUM',
853: g_blkt_hdr_tbl(l_blanket_header_id).blanket_max_amount);
854: oe_msg_pub.add;
855: x_return_status := FND_API.G_RET_STS_ERROR;
856: ELSE

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

854: oe_msg_pub.add;
855: x_return_status := FND_API.G_RET_STS_ERROR;
856: ELSE
857: IF NVL(FND_PROFILE.VALUE('ONT_BSA_MIN_MAX_VIOLATION'),'N') = 'Y' THEN
858: FND_MESSAGE.SET_NAME('ONT','OE_BL_HDR_MAX_AMT_EXCEEDED');
859: FND_MESSAGE.SET_TOKEN('BLANKET_NUMBER',p_blanket_number);
860: FND_MESSAGE.SET_TOKEN('BLANKET_CURRENCY',
861: g_blkt_hdr_tbl(l_blanket_header_id).currency_code);
862: FND_MESSAGE.SET_TOKEN('MAXIMUM',

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

855: x_return_status := FND_API.G_RET_STS_ERROR;
856: ELSE
857: IF NVL(FND_PROFILE.VALUE('ONT_BSA_MIN_MAX_VIOLATION'),'N') = 'Y' THEN
858: FND_MESSAGE.SET_NAME('ONT','OE_BL_HDR_MAX_AMT_EXCEEDED');
859: FND_MESSAGE.SET_TOKEN('BLANKET_NUMBER',p_blanket_number);
860: FND_MESSAGE.SET_TOKEN('BLANKET_CURRENCY',
861: g_blkt_hdr_tbl(l_blanket_header_id).currency_code);
862: FND_MESSAGE.SET_TOKEN('MAXIMUM',
863: g_blkt_hdr_tbl(l_blanket_header_id).blanket_max_amount);

Line 860: FND_MESSAGE.SET_TOKEN('BLANKET_CURRENCY',

856: ELSE
857: IF NVL(FND_PROFILE.VALUE('ONT_BSA_MIN_MAX_VIOLATION'),'N') = 'Y' THEN
858: FND_MESSAGE.SET_NAME('ONT','OE_BL_HDR_MAX_AMT_EXCEEDED');
859: FND_MESSAGE.SET_TOKEN('BLANKET_NUMBER',p_blanket_number);
860: FND_MESSAGE.SET_TOKEN('BLANKET_CURRENCY',
861: g_blkt_hdr_tbl(l_blanket_header_id).currency_code);
862: FND_MESSAGE.SET_TOKEN('MAXIMUM',
863: g_blkt_hdr_tbl(l_blanket_header_id).blanket_max_amount);
864: oe_msg_pub.add;

Line 862: FND_MESSAGE.SET_TOKEN('MAXIMUM',

858: FND_MESSAGE.SET_NAME('ONT','OE_BL_HDR_MAX_AMT_EXCEEDED');
859: FND_MESSAGE.SET_TOKEN('BLANKET_NUMBER',p_blanket_number);
860: FND_MESSAGE.SET_TOKEN('BLANKET_CURRENCY',
861: g_blkt_hdr_tbl(l_blanket_header_id).currency_code);
862: FND_MESSAGE.SET_TOKEN('MAXIMUM',
863: g_blkt_hdr_tbl(l_blanket_header_id).blanket_max_amount);
864: oe_msg_pub.add;
865: END IF;
866:

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

1092: ,p_to_uom_code => g_blkt_line_tbl(l_blanket_line_id).uom
1093: ,p_from_qty => l_set_quantity
1094: );
1095: IF l_set_quantity < 0 THEN
1096: FND_MESSAGE.SET_NAME('ONT','OE_BL_UOM_CONV_FAILED');
1097: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Set_Line_Number);
1098: FND_MESSAGE.SET_TOKEN('BLANKET_UOM',
1099: g_blkt_line_tbl(l_blanket_line_id).uom);
1100: OE_MSG_PUB.ADD;

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

1093: ,p_from_qty => l_set_quantity
1094: );
1095: IF l_set_quantity < 0 THEN
1096: FND_MESSAGE.SET_NAME('ONT','OE_BL_UOM_CONV_FAILED');
1097: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Set_Line_Number);
1098: FND_MESSAGE.SET_TOKEN('BLANKET_UOM',
1099: g_blkt_line_tbl(l_blanket_line_id).uom);
1100: OE_MSG_PUB.ADD;
1101: RAISE FND_API.G_EXC_ERROR;

Line 1098: FND_MESSAGE.SET_TOKEN('BLANKET_UOM',

1094: );
1095: IF l_set_quantity < 0 THEN
1096: FND_MESSAGE.SET_NAME('ONT','OE_BL_UOM_CONV_FAILED');
1097: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Set_Line_Number);
1098: FND_MESSAGE.SET_TOKEN('BLANKET_UOM',
1099: g_blkt_line_tbl(l_blanket_line_id).uom);
1100: OE_MSG_PUB.ADD;
1101: RAISE FND_API.G_EXC_ERROR;
1102: END IF;

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

1109: nvl(g_blkt_line_tbl(l_blanket_line_id).max_release_quantity
1110: ,l_set_quantity)
1111: THEN
1112: IF g_blkt_line_tbl(l_blanket_line_id).OVERRIDE_RELEASE_CONTROLS_FLAG = 'N' THEN
1113: FND_MESSAGE.SET_NAME('ONT','OE_BL_SUM_SPLIT_MIN_MAX_QTY');
1114: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Set_Line_Number);
1115: FND_MESSAGE.SET_TOKEN('BLANKET_UOM',
1116: g_blkt_line_tbl(l_blanket_line_id).uom);
1117: FND_MESSAGE.SET_TOKEN('MINIMUM',

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

1110: ,l_set_quantity)
1111: THEN
1112: IF g_blkt_line_tbl(l_blanket_line_id).OVERRIDE_RELEASE_CONTROLS_FLAG = 'N' THEN
1113: FND_MESSAGE.SET_NAME('ONT','OE_BL_SUM_SPLIT_MIN_MAX_QTY');
1114: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Set_Line_Number);
1115: FND_MESSAGE.SET_TOKEN('BLANKET_UOM',
1116: g_blkt_line_tbl(l_blanket_line_id).uom);
1117: FND_MESSAGE.SET_TOKEN('MINIMUM',
1118: g_blkt_line_tbl(l_blanket_line_id).min_release_quantity);

Line 1115: FND_MESSAGE.SET_TOKEN('BLANKET_UOM',

1111: THEN
1112: IF g_blkt_line_tbl(l_blanket_line_id).OVERRIDE_RELEASE_CONTROLS_FLAG = 'N' THEN
1113: FND_MESSAGE.SET_NAME('ONT','OE_BL_SUM_SPLIT_MIN_MAX_QTY');
1114: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Set_Line_Number);
1115: FND_MESSAGE.SET_TOKEN('BLANKET_UOM',
1116: g_blkt_line_tbl(l_blanket_line_id).uom);
1117: FND_MESSAGE.SET_TOKEN('MINIMUM',
1118: g_blkt_line_tbl(l_blanket_line_id).min_release_quantity);
1119: FND_MESSAGE.SET_TOKEN('MAXIMUM',

Line 1117: FND_MESSAGE.SET_TOKEN('MINIMUM',

1113: FND_MESSAGE.SET_NAME('ONT','OE_BL_SUM_SPLIT_MIN_MAX_QTY');
1114: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Set_Line_Number);
1115: FND_MESSAGE.SET_TOKEN('BLANKET_UOM',
1116: g_blkt_line_tbl(l_blanket_line_id).uom);
1117: FND_MESSAGE.SET_TOKEN('MINIMUM',
1118: g_blkt_line_tbl(l_blanket_line_id).min_release_quantity);
1119: FND_MESSAGE.SET_TOKEN('MAXIMUM',
1120: g_blkt_line_tbl(l_blanket_line_id).max_release_quantity);
1121: oe_msg_pub.add;

Line 1119: FND_MESSAGE.SET_TOKEN('MAXIMUM',

1115: FND_MESSAGE.SET_TOKEN('BLANKET_UOM',
1116: g_blkt_line_tbl(l_blanket_line_id).uom);
1117: FND_MESSAGE.SET_TOKEN('MINIMUM',
1118: g_blkt_line_tbl(l_blanket_line_id).min_release_quantity);
1119: FND_MESSAGE.SET_TOKEN('MAXIMUM',
1120: g_blkt_line_tbl(l_blanket_line_id).max_release_quantity);
1121: oe_msg_pub.add;
1122: x_return_status := FND_API.G_RET_STS_ERROR;
1123: ELSE

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

1121: oe_msg_pub.add;
1122: x_return_status := FND_API.G_RET_STS_ERROR;
1123: ELSE
1124: IF NVL(FND_PROFILE.VALUE('ONT_BSA_MIN_MAX_VIOLATION'),'N') = 'Y' THEN
1125: FND_MESSAGE.SET_NAME('ONT','OE_BL_SUM_SPLIT_MIN_MAX_QTY');
1126: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Set_Line_Number);
1127: FND_MESSAGE.SET_TOKEN('BLANKET_UOM',
1128: g_blkt_line_tbl(l_blanket_line_id).uom);
1129: FND_MESSAGE.SET_TOKEN('MINIMUM',

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

1122: x_return_status := FND_API.G_RET_STS_ERROR;
1123: ELSE
1124: IF NVL(FND_PROFILE.VALUE('ONT_BSA_MIN_MAX_VIOLATION'),'N') = 'Y' THEN
1125: FND_MESSAGE.SET_NAME('ONT','OE_BL_SUM_SPLIT_MIN_MAX_QTY');
1126: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Set_Line_Number);
1127: FND_MESSAGE.SET_TOKEN('BLANKET_UOM',
1128: g_blkt_line_tbl(l_blanket_line_id).uom);
1129: FND_MESSAGE.SET_TOKEN('MINIMUM',
1130: g_blkt_line_tbl(l_blanket_line_id).min_release_quantity);

Line 1127: FND_MESSAGE.SET_TOKEN('BLANKET_UOM',

1123: ELSE
1124: IF NVL(FND_PROFILE.VALUE('ONT_BSA_MIN_MAX_VIOLATION'),'N') = 'Y' THEN
1125: FND_MESSAGE.SET_NAME('ONT','OE_BL_SUM_SPLIT_MIN_MAX_QTY');
1126: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Set_Line_Number);
1127: FND_MESSAGE.SET_TOKEN('BLANKET_UOM',
1128: g_blkt_line_tbl(l_blanket_line_id).uom);
1129: FND_MESSAGE.SET_TOKEN('MINIMUM',
1130: g_blkt_line_tbl(l_blanket_line_id).min_release_quantity);
1131: FND_MESSAGE.SET_TOKEN('MAXIMUM',

Line 1129: FND_MESSAGE.SET_TOKEN('MINIMUM',

1125: FND_MESSAGE.SET_NAME('ONT','OE_BL_SUM_SPLIT_MIN_MAX_QTY');
1126: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Set_Line_Number);
1127: FND_MESSAGE.SET_TOKEN('BLANKET_UOM',
1128: g_blkt_line_tbl(l_blanket_line_id).uom);
1129: FND_MESSAGE.SET_TOKEN('MINIMUM',
1130: g_blkt_line_tbl(l_blanket_line_id).min_release_quantity);
1131: FND_MESSAGE.SET_TOKEN('MAXIMUM',
1132: g_blkt_line_tbl(l_blanket_line_id).max_release_quantity);
1133: oe_msg_pub.add;

Line 1131: FND_MESSAGE.SET_TOKEN('MAXIMUM',

1127: FND_MESSAGE.SET_TOKEN('BLANKET_UOM',
1128: g_blkt_line_tbl(l_blanket_line_id).uom);
1129: FND_MESSAGE.SET_TOKEN('MINIMUM',
1130: g_blkt_line_tbl(l_blanket_line_id).min_release_quantity);
1131: FND_MESSAGE.SET_TOKEN('MAXIMUM',
1132: g_blkt_line_tbl(l_blanket_line_id).max_release_quantity);
1133: oe_msg_pub.add;
1134: END IF;
1135:

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

1147: <> g_blkt_hdr_tbl(l_blanket_header_id).currency_code
1148: THEN
1149:
1150: IF g_blkt_hdr_tbl(l_blanket_header_id).conversion_type_code IS NULL THEN
1151: FND_MESSAGE.SET_NAME('ONT','OE_BL_MISS_CONVERSION_TYPE');
1152: FND_MESSAGE.SET_TOKEN('BLANKET_NUMBER',p_blanket_number);
1153: oe_msg_pub.add;
1154: RAISE FND_API.G_EXC_ERROR;
1155: END IF;

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

1148: THEN
1149:
1150: IF g_blkt_hdr_tbl(l_blanket_header_id).conversion_type_code IS NULL THEN
1151: FND_MESSAGE.SET_NAME('ONT','OE_BL_MISS_CONVERSION_TYPE');
1152: FND_MESSAGE.SET_TOKEN('BLANKET_NUMBER',p_blanket_number);
1153: oe_msg_pub.add;
1154: RAISE FND_API.G_EXC_ERROR;
1155: END IF;
1156:

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

1171: ,l_set_amount)
1172: )
1173: THEN
1174: IF g_blkt_line_tbl(l_blanket_line_id).OVERRIDE_RELEASE_CONTROLS_FLAG = 'N' THEN
1175: FND_MESSAGE.SET_NAME('ONT','OE_BL_SUM_SPLIT_MIN_MAX_AMT');
1176: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Set_Line_Number);
1177: FND_MESSAGE.SET_TOKEN('BLANKET_CURRENCY',
1178: g_blkt_hdr_tbl(l_blanket_header_id).currency_code);
1179: FND_MESSAGE.SET_TOKEN('MINIMUM',

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

1172: )
1173: THEN
1174: IF g_blkt_line_tbl(l_blanket_line_id).OVERRIDE_RELEASE_CONTROLS_FLAG = 'N' THEN
1175: FND_MESSAGE.SET_NAME('ONT','OE_BL_SUM_SPLIT_MIN_MAX_AMT');
1176: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Set_Line_Number);
1177: FND_MESSAGE.SET_TOKEN('BLANKET_CURRENCY',
1178: g_blkt_hdr_tbl(l_blanket_header_id).currency_code);
1179: FND_MESSAGE.SET_TOKEN('MINIMUM',
1180: g_blkt_line_tbl(l_blanket_line_id).min_release_amount);

Line 1177: FND_MESSAGE.SET_TOKEN('BLANKET_CURRENCY',

1173: THEN
1174: IF g_blkt_line_tbl(l_blanket_line_id).OVERRIDE_RELEASE_CONTROLS_FLAG = 'N' THEN
1175: FND_MESSAGE.SET_NAME('ONT','OE_BL_SUM_SPLIT_MIN_MAX_AMT');
1176: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Set_Line_Number);
1177: FND_MESSAGE.SET_TOKEN('BLANKET_CURRENCY',
1178: g_blkt_hdr_tbl(l_blanket_header_id).currency_code);
1179: FND_MESSAGE.SET_TOKEN('MINIMUM',
1180: g_blkt_line_tbl(l_blanket_line_id).min_release_amount);
1181: FND_MESSAGE.SET_TOKEN('MAXIMUM',

Line 1179: FND_MESSAGE.SET_TOKEN('MINIMUM',

1175: FND_MESSAGE.SET_NAME('ONT','OE_BL_SUM_SPLIT_MIN_MAX_AMT');
1176: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Set_Line_Number);
1177: FND_MESSAGE.SET_TOKEN('BLANKET_CURRENCY',
1178: g_blkt_hdr_tbl(l_blanket_header_id).currency_code);
1179: FND_MESSAGE.SET_TOKEN('MINIMUM',
1180: g_blkt_line_tbl(l_blanket_line_id).min_release_amount);
1181: FND_MESSAGE.SET_TOKEN('MAXIMUM',
1182: g_blkt_line_tbl(l_blanket_line_id).max_release_amount);
1183: oe_msg_pub.add;

Line 1181: FND_MESSAGE.SET_TOKEN('MAXIMUM',

1177: FND_MESSAGE.SET_TOKEN('BLANKET_CURRENCY',
1178: g_blkt_hdr_tbl(l_blanket_header_id).currency_code);
1179: FND_MESSAGE.SET_TOKEN('MINIMUM',
1180: g_blkt_line_tbl(l_blanket_line_id).min_release_amount);
1181: FND_MESSAGE.SET_TOKEN('MAXIMUM',
1182: g_blkt_line_tbl(l_blanket_line_id).max_release_amount);
1183: oe_msg_pub.add;
1184: x_return_status := FND_API.G_RET_STS_ERROR;
1185: ELSE

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

1183: oe_msg_pub.add;
1184: x_return_status := FND_API.G_RET_STS_ERROR;
1185: ELSE
1186: IF NVL(FND_PROFILE.VALUE('ONT_BSA_MIN_MAX_VIOLATION'),'N') = 'Y' THEN
1187: FND_MESSAGE.SET_NAME('ONT','OE_BL_SUM_SPLIT_MIN_MAX_AMT');
1188: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Set_Line_Number);
1189: FND_MESSAGE.SET_TOKEN('BLANKET_CURRENCY',
1190: g_blkt_hdr_tbl(l_blanket_header_id).currency_code);
1191: FND_MESSAGE.SET_TOKEN('MINIMUM',

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

1184: x_return_status := FND_API.G_RET_STS_ERROR;
1185: ELSE
1186: IF NVL(FND_PROFILE.VALUE('ONT_BSA_MIN_MAX_VIOLATION'),'N') = 'Y' THEN
1187: FND_MESSAGE.SET_NAME('ONT','OE_BL_SUM_SPLIT_MIN_MAX_AMT');
1188: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Set_Line_Number);
1189: FND_MESSAGE.SET_TOKEN('BLANKET_CURRENCY',
1190: g_blkt_hdr_tbl(l_blanket_header_id).currency_code);
1191: FND_MESSAGE.SET_TOKEN('MINIMUM',
1192: g_blkt_line_tbl(l_blanket_line_id).min_release_amount);

Line 1189: FND_MESSAGE.SET_TOKEN('BLANKET_CURRENCY',

1185: ELSE
1186: IF NVL(FND_PROFILE.VALUE('ONT_BSA_MIN_MAX_VIOLATION'),'N') = 'Y' THEN
1187: FND_MESSAGE.SET_NAME('ONT','OE_BL_SUM_SPLIT_MIN_MAX_AMT');
1188: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Set_Line_Number);
1189: FND_MESSAGE.SET_TOKEN('BLANKET_CURRENCY',
1190: g_blkt_hdr_tbl(l_blanket_header_id).currency_code);
1191: FND_MESSAGE.SET_TOKEN('MINIMUM',
1192: g_blkt_line_tbl(l_blanket_line_id).min_release_amount);
1193: FND_MESSAGE.SET_TOKEN('MAXIMUM',

Line 1191: FND_MESSAGE.SET_TOKEN('MINIMUM',

1187: FND_MESSAGE.SET_NAME('ONT','OE_BL_SUM_SPLIT_MIN_MAX_AMT');
1188: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',Get_Set_Line_Number);
1189: FND_MESSAGE.SET_TOKEN('BLANKET_CURRENCY',
1190: g_blkt_hdr_tbl(l_blanket_header_id).currency_code);
1191: FND_MESSAGE.SET_TOKEN('MINIMUM',
1192: g_blkt_line_tbl(l_blanket_line_id).min_release_amount);
1193: FND_MESSAGE.SET_TOKEN('MAXIMUM',
1194: g_blkt_line_tbl(l_blanket_line_id).max_release_amount);
1195: oe_msg_pub.add;

Line 1193: FND_MESSAGE.SET_TOKEN('MAXIMUM',

1189: FND_MESSAGE.SET_TOKEN('BLANKET_CURRENCY',
1190: g_blkt_hdr_tbl(l_blanket_header_id).currency_code);
1191: FND_MESSAGE.SET_TOKEN('MINIMUM',
1192: g_blkt_line_tbl(l_blanket_line_id).min_release_amount);
1193: FND_MESSAGE.SET_TOKEN('MAXIMUM',
1194: g_blkt_line_tbl(l_blanket_line_id).max_release_amount);
1195: oe_msg_pub.add;
1196: END IF;
1197: END IF;