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_API

Line 36: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

32: (G_PKG_NAME
33: ,'Get_Line_Number'
34: );
35: END IF;
36: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
37: END Get_Line_Number;
38:
39: ---------------------------------------------------------------------------
40: -- LOCAL FUNCTION Get_Shipment_Number

Line 66: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

62: (G_PKG_NAME
63: ,'Get_Shipment_Number'
64: );
65: END IF;
66: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
67: END Get_Shipment_Number;
68:
69: ---------------------------------------------------------------------------
70: -- PUBLIC FUNCTION Convert_Amount

Line 182: RAISE FND_API.G_EXC_ERROR;

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)
185: THEN
186: OE_MSG_PUB.Add_Exc_Msg

Line 191: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

187: (G_PKG_NAME
188: ,'Convert_Amount'
189: );
190: END IF;
191: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
192: END Convert_Amount;
193:
194: ---------------------------------------------------------------------------
195: -- LOCAL PROCEDURE Cache_Blanket

Line 386: RAISE FND_API.G_EXC_ERROR;

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)
389: THEN
390: OE_MSG_PUB.Add_Exc_Msg

Line 395: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

391: (G_PKG_NAME
392: ,'Cache_Blanket'
393: );
394: END IF;
395: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
396: END Cache_Blanket;
397:
398:
399: ---------------------------------------------------------------------------

Line 437: x_return_status := FND_API.G_RET_STS_SUCCESS;

433: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
434: --
435: BEGIN
436:
437: x_return_status := FND_API.G_RET_STS_SUCCESS;
438:
439: Cache_Blanket(p_blanket_number
440: ,p_blanket_line_number
441: ,'Y' -- p_lock

Line 501: RAISE FND_API.G_EXC_ERROR;

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;
503: END IF;
504:
505: IF l_old_quantity > 0

Line 523: RAISE FND_API.G_EXC_ERROR;

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;
525: END IF;
526:
527: -- INCREMENT Cumulative Released Quantity

Line 550: RAISE FND_API.G_EXC_ERROR;

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:
553: IF l_amount <> 0 THEN
554: l_amount := Convert_Amount

Line 658: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 740: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 783: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 813: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 855: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 873: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

869: END IF;
870:
871: END IF; -- IF blanket header override amount control = 'N'
872:
873: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
874:
875: -- Update quantity fields on cached blanket records
876: IF g_blkt_line_tbl(l_blanket_line_id).uom IS NOT NULL THEN
877: g_blkt_line_tbl(l_blanket_line_id).released_quantity

Line 914: WHEN FND_API.G_EXC_ERROR THEN

910:
911: -- End of min-max checks
912:
913: EXCEPTION
914: WHEN FND_API.G_EXC_ERROR THEN
915: x_return_status := FND_API.G_RET_STS_ERROR;
916: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
917: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
918: WHEN OTHERS THEN

Line 915: x_return_status := FND_API.G_RET_STS_ERROR;

911: -- End of min-max checks
912:
913: EXCEPTION
914: WHEN FND_API.G_EXC_ERROR THEN
915: x_return_status := FND_API.G_RET_STS_ERROR;
916: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
917: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
918: WHEN OTHERS THEN
919: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 916: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

912:
913: EXCEPTION
914: WHEN FND_API.G_EXC_ERROR THEN
915: x_return_status := FND_API.G_RET_STS_ERROR;
916: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
917: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
918: WHEN OTHERS THEN
919: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
920: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 917: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

913: EXCEPTION
914: WHEN FND_API.G_EXC_ERROR THEN
915: x_return_status := FND_API.G_RET_STS_ERROR;
916: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
917: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
918: WHEN OTHERS THEN
919: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
920: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
921: THEN

Line 919: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

915: x_return_status := FND_API.G_RET_STS_ERROR;
916: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
917: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
918: WHEN OTHERS THEN
919: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
920: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
921: THEN
922: OE_MSG_PUB.Add_Exc_Msg
923: (G_PKG_NAME

Line 987: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

983: oe_debug_pub.add('Leaving update blanket');
984:
985: EXCEPTION
986: WHEN OTHERS THEN
987: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
988: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
989: THEN
990: OE_MSG_PUB.Add_Exc_Msg
991: (G_PKG_NAME

Line 1041: x_return_status := FND_API.G_RET_STS_SUCCESS;

1037:
1038:
1039: BEGIN
1040:
1041: x_return_status := FND_API.G_RET_STS_SUCCESS;
1042:
1043: Cache_Blanket(p_blanket_number
1044: ,p_blanket_line_number
1045: ,'Y' -- p_lock

Line 1101: RAISE FND_API.G_EXC_ERROR;

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;
1103:
1104: END IF;
1105:

Line 1122: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1154: RAISE FND_API.G_EXC_ERROR;

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:
1157: l_set_amount := Convert_Amount
1158: (p_from_currency => p_currency_code

Line 1184: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1205: WHEN FND_API.G_EXC_ERROR THEN

1201: END IF;
1202:
1203:
1204: EXCEPTION
1205: WHEN FND_API.G_EXC_ERROR THEN
1206: x_return_status := FND_API.G_RET_STS_ERROR;
1207: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1208: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1209: WHEN OTHERS THEN

Line 1206: x_return_status := FND_API.G_RET_STS_ERROR;

1202:
1203:
1204: EXCEPTION
1205: WHEN FND_API.G_EXC_ERROR THEN
1206: x_return_status := FND_API.G_RET_STS_ERROR;
1207: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1208: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1209: WHEN OTHERS THEN
1210: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1207: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1203:
1204: EXCEPTION
1205: WHEN FND_API.G_EXC_ERROR THEN
1206: x_return_status := FND_API.G_RET_STS_ERROR;
1207: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1208: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1209: WHEN OTHERS THEN
1210: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1211: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 1208: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1204: EXCEPTION
1205: WHEN FND_API.G_EXC_ERROR THEN
1206: x_return_status := FND_API.G_RET_STS_ERROR;
1207: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1208: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1209: WHEN OTHERS THEN
1210: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1211: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1212: THEN

Line 1210: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1206: x_return_status := FND_API.G_RET_STS_ERROR;
1207: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1208: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1209: WHEN OTHERS THEN
1210: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1211: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1212: THEN
1213: OE_MSG_PUB.Add_Exc_Msg
1214: (G_PKG_NAME

Line 1272: x_return_status := FND_API.G_RET_STS_SUCCESS;

1268:
1269: g_blkt_line_tbl.delete;
1270: g_blkt_hdr_tbl.delete;
1271:
1272: x_return_status := FND_API.G_RET_STS_SUCCESS;
1273:
1274: I := p_request_tbl.FIRST;
1275: WHILE I IS NOT NULL LOOP
1276:

Line 1296: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1292: ,p_currency_code => p_request_tbl(I).param1
1293: ,x_return_status => l_return_status
1294: );
1295:
1296: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1297: oe_debug_pub.add('ret sts of error');
1298: x_return_status := FND_API.G_RET_STS_ERROR;
1299: RETURN;
1300: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1298: x_return_status := FND_API.G_RET_STS_ERROR;

1294: );
1295:
1296: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1297: oe_debug_pub.add('ret sts of error');
1298: x_return_status := FND_API.G_RET_STS_ERROR;
1299: RETURN;
1300: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1301: oe_debug_pub.add('ret sts of unexp error');
1302: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1300: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1296: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1297: oe_debug_pub.add('ret sts of error');
1298: x_return_status := FND_API.G_RET_STS_ERROR;
1299: RETURN;
1300: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1301: oe_debug_pub.add('ret sts of unexp error');
1302: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1303: RETURN;
1304: END IF;

Line 1302: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1298: x_return_status := FND_API.G_RET_STS_ERROR;
1299: RETURN;
1300: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1301: oe_debug_pub.add('ret sts of unexp error');
1302: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1303: RETURN;
1304: END IF;
1305:
1306: p_request_tbl(I).processed := 'Y';

Line 1418: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1414: ,p_line_set_id => p_request_tbl_temp(I).param9
1415: ,x_return_status => l_return_status
1416: );
1417:
1418: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1419: oe_debug_pub.add('1. ret sts of error');
1420: x_return_status := FND_API.G_RET_STS_ERROR;
1421: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1422: oe_debug_pub.add('1. ret sts of unexp error');

Line 1420: x_return_status := FND_API.G_RET_STS_ERROR;

1416: );
1417:
1418: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1419: oe_debug_pub.add('1. ret sts of error');
1420: x_return_status := FND_API.G_RET_STS_ERROR;
1421: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1422: oe_debug_pub.add('1. ret sts of unexp error');
1423: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1424: END IF;

Line 1421: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1417:
1418: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1419: oe_debug_pub.add('1. ret sts of error');
1420: x_return_status := FND_API.G_RET_STS_ERROR;
1421: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1422: oe_debug_pub.add('1. ret sts of unexp error');
1423: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1424: END IF;
1425:

Line 1423: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1419: oe_debug_pub.add('1. ret sts of error');
1420: x_return_status := FND_API.G_RET_STS_ERROR;
1421: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1422: oe_debug_pub.add('1. ret sts of unexp error');
1423: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1424: END IF;
1425:
1426: ELSE
1427:

Line 1456: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1452: );
1453:
1454: END IF;
1455:
1456: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1457: oe_debug_pub.add('2. ret sts of error');
1458: x_return_status := FND_API.G_RET_STS_ERROR;
1459: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1460: oe_debug_pub.add('2. ret sts of unexp error');

Line 1458: x_return_status := FND_API.G_RET_STS_ERROR;

1454: END IF;
1455:
1456: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1457: oe_debug_pub.add('2. ret sts of error');
1458: x_return_status := FND_API.G_RET_STS_ERROR;
1459: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1460: oe_debug_pub.add('2. ret sts of unexp error');
1461: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1462: END IF;

Line 1459: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1455:
1456: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1457: oe_debug_pub.add('2. ret sts of error');
1458: x_return_status := FND_API.G_RET_STS_ERROR;
1459: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1460: oe_debug_pub.add('2. ret sts of unexp error');
1461: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1462: END IF;
1463:

Line 1461: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1457: oe_debug_pub.add('2. ret sts of error');
1458: x_return_status := FND_API.G_RET_STS_ERROR;
1459: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1460: oe_debug_pub.add('2. ret sts of unexp error');
1461: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1462: END IF;
1463:
1464: -- Decrement qty/amount for old blanket line
1465: IF p_request_tbl_temp(I).param1 IS NOT NULL THEN

Line 1492: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1488: );
1489:
1490: END IF;
1491:
1492: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1493: oe_debug_pub.add('3. ret sts of error');
1494: x_return_status := FND_API.G_RET_STS_ERROR;
1495: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1496: oe_debug_pub.add('3. ret sts of unexp error');

Line 1494: x_return_status := FND_API.G_RET_STS_ERROR;

1490: END IF;
1491:
1492: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1493: oe_debug_pub.add('3. ret sts of error');
1494: x_return_status := FND_API.G_RET_STS_ERROR;
1495: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1496: oe_debug_pub.add('3. ret sts of unexp error');
1497: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1498: END IF;

Line 1495: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1491:
1492: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1493: oe_debug_pub.add('3. ret sts of error');
1494: x_return_status := FND_API.G_RET_STS_ERROR;
1495: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1496: oe_debug_pub.add('3. ret sts of unexp error');
1497: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1498: END IF;
1499:

Line 1497: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1493: oe_debug_pub.add('3. ret sts of error');
1494: x_return_status := FND_API.G_RET_STS_ERROR;
1495: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1496: oe_debug_pub.add('3. ret sts of unexp error');
1497: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1498: END IF;
1499:
1500: END IF;
1501:

Line 1533: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1529: END LOOP;
1530:
1531:
1532: -- Error during updates, mark the requests as NOT processed
1533: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1534:
1535: if l_debug_level > 0 then
1536: oe_debug_pub.add('Overall Ret Sts :'||x_return_status);
1537: end if;

Line 1573: WHEN FND_API.G_EXC_ERROR THEN

1569: oe_debug_pub.add('EXIT OE_Blanket_Util.Process_Releases');
1570: end if;
1571:
1572: EXCEPTION
1573: WHEN FND_API.G_EXC_ERROR THEN
1574: x_return_status := FND_API.G_RET_STS_ERROR;
1575: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1576: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1577: WHEN OTHERS THEN

Line 1574: x_return_status := FND_API.G_RET_STS_ERROR;

1570: end if;
1571:
1572: EXCEPTION
1573: WHEN FND_API.G_EXC_ERROR THEN
1574: x_return_status := FND_API.G_RET_STS_ERROR;
1575: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1576: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1577: WHEN OTHERS THEN
1578: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1575: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1571:
1572: EXCEPTION
1573: WHEN FND_API.G_EXC_ERROR THEN
1574: x_return_status := FND_API.G_RET_STS_ERROR;
1575: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1576: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1577: WHEN OTHERS THEN
1578: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1579: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 1576: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1572: EXCEPTION
1573: WHEN FND_API.G_EXC_ERROR THEN
1574: x_return_status := FND_API.G_RET_STS_ERROR;
1575: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1576: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1577: WHEN OTHERS THEN
1578: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1579: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1580: THEN

Line 1578: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1574: x_return_status := FND_API.G_RET_STS_ERROR;
1575: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1576: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1577: WHEN OTHERS THEN
1578: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1579: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1580: THEN
1581: OE_MSG_PUB.Add_Exc_Msg
1582: (G_PKG_NAME

Line 1727: WHEN FND_API.G_EXC_ERROR THEN

1723:
1724: END IF; -- if not cached
1725:
1726: EXCEPTION
1727: WHEN FND_API.G_EXC_ERROR THEN
1728: RAISE FND_API.G_EXC_ERROR;
1729: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1730: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1731: WHEN OTHERS THEN

Line 1728: RAISE FND_API.G_EXC_ERROR;

1724: END IF; -- if not cached
1725:
1726: EXCEPTION
1727: WHEN FND_API.G_EXC_ERROR THEN
1728: RAISE FND_API.G_EXC_ERROR;
1729: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1730: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1731: WHEN OTHERS THEN
1732: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 1729: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1725:
1726: EXCEPTION
1727: WHEN FND_API.G_EXC_ERROR THEN
1728: RAISE FND_API.G_EXC_ERROR;
1729: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1730: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1731: WHEN OTHERS THEN
1732: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1733: THEN

Line 1730: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1726: EXCEPTION
1727: WHEN FND_API.G_EXC_ERROR THEN
1728: RAISE FND_API.G_EXC_ERROR;
1729: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1730: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1731: WHEN OTHERS THEN
1732: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1733: THEN
1734: OE_MSG_PUB.Add_Exc_Msg

Line 1739: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1735: (G_PKG_NAME
1736: ,'Populate_Old_Values'
1737: );
1738: END IF;
1739: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1740: END Populate_Old_Values;
1741:
1742: PROCEDURE Cache_Order_Qty_Amt
1743: (p_request_rec IN OUT NOCOPY OE_ORDER_PUB.Request_Rec_Type

Line 1766: x_return_status := fnd_api.g_ret_sts_success;

1762: if l_debug_level > 0 then
1763: oe_debug_pub.add('ENTER OE_Blkt_Release_Util.Cache_Order_Qty_Amt');
1764: end if;
1765:
1766: x_return_status := fnd_api.g_ret_sts_success;
1767:
1768: -- Blanket reference not updated, some other attribute on line updated
1769: IF p_request_rec.param1 = p_request_rec.param11
1770: AND p_request_rec.param2 = p_request_rec.param12

Line 1817: WHEN FND_API.G_EXC_ERROR THEN

1813: oe_debug_pub.add('EXIT OE_Blkt_Release_Util.Cache_Order_Qty_Amt');
1814: end if;
1815:
1816: EXCEPTION
1817: WHEN FND_API.G_EXC_ERROR THEN
1818: x_return_status := FND_API.G_RET_STS_ERROR;
1819: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1820: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1821: WHEN OTHERS THEN

Line 1818: x_return_status := FND_API.G_RET_STS_ERROR;

1814: end if;
1815:
1816: EXCEPTION
1817: WHEN FND_API.G_EXC_ERROR THEN
1818: x_return_status := FND_API.G_RET_STS_ERROR;
1819: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1820: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1821: WHEN OTHERS THEN
1822: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1819: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1815:
1816: EXCEPTION
1817: WHEN FND_API.G_EXC_ERROR THEN
1818: x_return_status := FND_API.G_RET_STS_ERROR;
1819: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1820: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1821: WHEN OTHERS THEN
1822: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1823: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 1820: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1816: EXCEPTION
1817: WHEN FND_API.G_EXC_ERROR THEN
1818: x_return_status := FND_API.G_RET_STS_ERROR;
1819: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1820: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1821: WHEN OTHERS THEN
1822: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1823: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1824: THEN

Line 1822: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1818: x_return_status := FND_API.G_RET_STS_ERROR;
1819: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1820: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1821: WHEN OTHERS THEN
1822: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1823: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1824: THEN
1825: OE_MSG_PUB.Add_Exc_Msg
1826: (G_PKG_NAME