DBA Data[Home] [Help]

APPS.OE_BLKT_RELEASE_UTIL dependencies on FND_PROFILE

Line 614: IF NVL(FND_PROFILE.VALUE('ONT_BSA_MIN_MAX_VIOLATION'),'N') = 'Y' THEN

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

Line 644: IF NVL(FND_PROFILE.VALUE('ONT_BSA_MIN_MAX_VIOLATION'),'N') = 'Y' THEN

640: oe_msg_pub.add;
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);

Line 695: IF NVL(FND_PROFILE.VALUE('ONT_BSA_MIN_MAX_VIOLATION'),'N') = 'Y' THEN

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

Line 726: IF NVL(FND_PROFILE.VALUE('ONT_BSA_MIN_MAX_VIOLATION'),'N') = 'Y' THEN

722: oe_msg_pub.add;
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);

Line 768: IF NVL(FND_PROFILE.VALUE('ONT_BSA_MIN_MAX_VIOLATION'),'N') = 'Y' THEN

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
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',

Line 798: IF NVL(FND_PROFILE.VALUE('ONT_BSA_MIN_MAX_VIOLATION'),'N') = 'Y' THEN

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
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',

Line 840: IF NVL(FND_PROFILE.VALUE('ONT_BSA_MIN_MAX_VIOLATION'),'N') = 'Y' THEN

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

Line 1096: IF NVL(FND_PROFILE.VALUE('ONT_BSA_MIN_MAX_VIOLATION'),'N') = 'Y' THEN

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

Line 1158: IF NVL(FND_PROFILE.VALUE('ONT_BSA_MIN_MAX_VIOLATION'),'N') = 'Y' THEN

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