1728: -- Clear the controller cache
1729: Clear_Header;
1730: --added for bug3716206
1731: OE_GLOBALS.G_HEADER_CREATED := FALSE;
1732: OE_ORDER_UTIL.Clear_Global_Picture(l_return_status);
1733: EXCEPTION
1734: WHEN OTHERS THEN
1735: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1736: THEN
3560: -- bug 3588660
3561: IF OE_CODE_CONTROL.Code_Release_Level >= '110508' THEN
3562:
3563:
3564: IF (( OE_ORDER_UTIL.g_header_rec.header_id is not null
3565: AND OE_ORDER_UTIL.g_header_rec.header_id <> FND_API.G_MISS_NUM)
3566: OR OE_ORDER_UTIL.g_header_adj_tbl.count >0
3567: OR OE_ORDER_UTIL.g_Header_Scredit_tbl.count >0
3568: OR OE_ORDER_UTIL.g_line_tbl.count >0
3561: IF OE_CODE_CONTROL.Code_Release_Level >= '110508' THEN
3562:
3563:
3564: IF (( OE_ORDER_UTIL.g_header_rec.header_id is not null
3565: AND OE_ORDER_UTIL.g_header_rec.header_id <> FND_API.G_MISS_NUM)
3566: OR OE_ORDER_UTIL.g_header_adj_tbl.count >0
3567: OR OE_ORDER_UTIL.g_Header_Scredit_tbl.count >0
3568: OR OE_ORDER_UTIL.g_line_tbl.count >0
3569: OR OE_ORDER_UTIL.g_Line_Adj_tbl.count >0
3562:
3563:
3564: IF (( OE_ORDER_UTIL.g_header_rec.header_id is not null
3565: AND OE_ORDER_UTIL.g_header_rec.header_id <> FND_API.G_MISS_NUM)
3566: OR OE_ORDER_UTIL.g_header_adj_tbl.count >0
3567: OR OE_ORDER_UTIL.g_Header_Scredit_tbl.count >0
3568: OR OE_ORDER_UTIL.g_line_tbl.count >0
3569: OR OE_ORDER_UTIL.g_Line_Adj_tbl.count >0
3570: OR OE_ORDER_UTIL.g_Line_Scredit_tbl.count >0
3563:
3564: IF (( OE_ORDER_UTIL.g_header_rec.header_id is not null
3565: AND OE_ORDER_UTIL.g_header_rec.header_id <> FND_API.G_MISS_NUM)
3566: OR OE_ORDER_UTIL.g_header_adj_tbl.count >0
3567: OR OE_ORDER_UTIL.g_Header_Scredit_tbl.count >0
3568: OR OE_ORDER_UTIL.g_line_tbl.count >0
3569: OR OE_ORDER_UTIL.g_Line_Adj_tbl.count >0
3570: OR OE_ORDER_UTIL.g_Line_Scredit_tbl.count >0
3571: OR OE_ORDER_UTIL.g_Lot_Serial_tbl.count >0 ) THEN
3564: IF (( OE_ORDER_UTIL.g_header_rec.header_id is not null
3565: AND OE_ORDER_UTIL.g_header_rec.header_id <> FND_API.G_MISS_NUM)
3566: OR OE_ORDER_UTIL.g_header_adj_tbl.count >0
3567: OR OE_ORDER_UTIL.g_Header_Scredit_tbl.count >0
3568: OR OE_ORDER_UTIL.g_line_tbl.count >0
3569: OR OE_ORDER_UTIL.g_Line_Adj_tbl.count >0
3570: OR OE_ORDER_UTIL.g_Line_Scredit_tbl.count >0
3571: OR OE_ORDER_UTIL.g_Lot_Serial_tbl.count >0 ) THEN
3572:
3565: AND OE_ORDER_UTIL.g_header_rec.header_id <> FND_API.G_MISS_NUM)
3566: OR OE_ORDER_UTIL.g_header_adj_tbl.count >0
3567: OR OE_ORDER_UTIL.g_Header_Scredit_tbl.count >0
3568: OR OE_ORDER_UTIL.g_line_tbl.count >0
3569: OR OE_ORDER_UTIL.g_Line_Adj_tbl.count >0
3570: OR OE_ORDER_UTIL.g_Line_Scredit_tbl.count >0
3571: OR OE_ORDER_UTIL.g_Lot_Serial_tbl.count >0 ) THEN
3572:
3573: oe_debug_pub.add('hash calling prn');
3566: OR OE_ORDER_UTIL.g_header_adj_tbl.count >0
3567: OR OE_ORDER_UTIL.g_Header_Scredit_tbl.count >0
3568: OR OE_ORDER_UTIL.g_line_tbl.count >0
3569: OR OE_ORDER_UTIL.g_Line_Adj_tbl.count >0
3570: OR OE_ORDER_UTIL.g_Line_Scredit_tbl.count >0
3571: OR OE_ORDER_UTIL.g_Lot_Serial_tbl.count >0 ) THEN
3572:
3573: oe_debug_pub.add('hash calling prn');
3574:
3567: OR OE_ORDER_UTIL.g_Header_Scredit_tbl.count >0
3568: OR OE_ORDER_UTIL.g_line_tbl.count >0
3569: OR OE_ORDER_UTIL.g_Line_Adj_tbl.count >0
3570: OR OE_ORDER_UTIL.g_Line_Scredit_tbl.count >0
3571: OR OE_ORDER_UTIL.g_Lot_Serial_tbl.count >0 ) THEN
3572:
3573: oe_debug_pub.add('hash calling prn');
3574:
3575: OE_Order_PVT.Process_Requests_And_Notify
3584: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3585: END IF;
3586:
3587: --zbutt change bug#4772531 begin
3588: oe_order_util.clear_global_picture(l_return_status) ;
3589: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3590: RAISE FND_API.G_EXC_ERROR;
3591: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3592: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;