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