788: RAISE FND_API.G_EXC_ERROR;
789: END IF;
790:
791: --SG{
792: IF OE_ORDER_CACHE.G_HEADER_REC.header_id IS NULL THEN
793: --header not available in cache, load info to cache
794: IF p_x_line_Scredit_rec.line_Id IS NOT NULL THEN
795: OE_ORDER_CACHE.Load_Order_Header(p_x_line_Scredit_rec.Header_Id);
796: ELSE
791: --SG{
792: IF OE_ORDER_CACHE.G_HEADER_REC.header_id IS NULL THEN
793: --header not available in cache, load info to cache
794: IF p_x_line_Scredit_rec.line_Id IS NOT NULL THEN
795: OE_ORDER_CACHE.Load_Order_Header(p_x_line_Scredit_rec.Header_Id);
796: ELSE
797: oe_debug_pub.add(' Warning:Null header_id for header sales credits');
798: END IF;
799: END IF;
797: oe_debug_pub.add(' Warning:Null header_id for header sales credits');
798: END IF;
799: END IF;
800:
801: IF OE_ORDER_CACHE.G_HEADER_REC.booked_flag = 'Y' THEN
802: l_sg_date := OE_ORDER_CACHE.G_HEADER_REC.booked_date;
803: ELSE
804: l_sg_date := OE_ORDER_CACHE.G_HEADER_REC.ordered_date;
805: END IF;
798: END IF;
799: END IF;
800:
801: IF OE_ORDER_CACHE.G_HEADER_REC.booked_flag = 'Y' THEN
802: l_sg_date := OE_ORDER_CACHE.G_HEADER_REC.booked_date;
803: ELSE
804: l_sg_date := OE_ORDER_CACHE.G_HEADER_REC.ordered_date;
805: END IF;
806:
800:
801: IF OE_ORDER_CACHE.G_HEADER_REC.booked_flag = 'Y' THEN
802: l_sg_date := OE_ORDER_CACHE.G_HEADER_REC.booked_date;
803: ELSE
804: l_sg_date := OE_ORDER_CACHE.G_HEADER_REC.ordered_date;
805: END IF;
806:
807: --5692017
808: IF p_x_line_Scredit_rec.operation = oe_globals.g_opr_create AND
825: IF nvl(p_x_line_Scredit_rec.sales_group_updated_flag,'N') <> 'Y'
826: AND nvl(p_x_line_Scredit_rec.salesrep_id,FND_API.G_MISS_NUM)<>FND_API.G_MISS_NUM
827: THEN
828:
829: IF OE_ORDER_CACHE.G_HEADER_REC.header_id IS NULL THEN
830: --header not available in cache, load info to cache
831: IF p_x_line_Scredit_rec.Header_Id IS NOT NULL THEN
832: OE_ORDER_CACHE.Load_Order_Header(p_x_line_Scredit_rec.Header_Id);
833: ELSE
828:
829: IF OE_ORDER_CACHE.G_HEADER_REC.header_id IS NULL THEN
830: --header not available in cache, load info to cache
831: IF p_x_line_Scredit_rec.Header_Id IS NOT NULL THEN
832: OE_ORDER_CACHE.Load_Order_Header(p_x_line_Scredit_rec.Header_Id);
833: ELSE
834: oe_debug_pub.add(' Warning:Null header_id for header sales credits');
835: END IF;
836: END IF;
834: oe_debug_pub.add(' Warning:Null header_id for header sales credits');
835: END IF;
836: END IF;
837:
838: IF OE_ORDER_CACHE.G_HEADER_REC.booked_flag = 'Y' THEN
839: l_sg_date := OE_ORDER_CACHE.G_HEADER_REC.booked_date;
840: ELSE
841: l_sg_date := OE_ORDER_CACHE.G_HEADER_REC.ordered_date;
842: END IF;
835: END IF;
836: END IF;
837:
838: IF OE_ORDER_CACHE.G_HEADER_REC.booked_flag = 'Y' THEN
839: l_sg_date := OE_ORDER_CACHE.G_HEADER_REC.booked_date;
840: ELSE
841: l_sg_date := OE_ORDER_CACHE.G_HEADER_REC.ordered_date;
842: END IF;
843:
837:
838: IF OE_ORDER_CACHE.G_HEADER_REC.booked_flag = 'Y' THEN
839: l_sg_date := OE_ORDER_CACHE.G_HEADER_REC.booked_date;
840: ELSE
841: l_sg_date := OE_ORDER_CACHE.G_HEADER_REC.ordered_date;
842: END IF;
843:
844: oe_debug_pub.add('Before getting sales group--line');
845: OE_Header_Scredit_Util.Get_Sales_Group(p_date => l_sg_date,
2402: END IF;
2403: IF NOT OE_GLOBALS.EQUAL(G_HEADER_ID,p_line_rec.header_id) or
2404: G_SALESREP_ID IS NULL Then
2405: --added for bug 4200055
2406: if ((Oe_Order_Cache.g_header_rec.header_id = p_line_rec.header_id)
2407: AND (Oe_Order_Cache.g_header_rec.header_id <> NULL)
2408: AND (Oe_Order_Cache.g_header_rec.header_id <> FND_API.G_MISS_NUM)) Then
2409: G_SALESREP_ID := Oe_Order_Cache.g_header_rec.salesrep_id ;
2410: else
2403: IF NOT OE_GLOBALS.EQUAL(G_HEADER_ID,p_line_rec.header_id) or
2404: G_SALESREP_ID IS NULL Then
2405: --added for bug 4200055
2406: if ((Oe_Order_Cache.g_header_rec.header_id = p_line_rec.header_id)
2407: AND (Oe_Order_Cache.g_header_rec.header_id <> NULL)
2408: AND (Oe_Order_Cache.g_header_rec.header_id <> FND_API.G_MISS_NUM)) Then
2409: G_SALESREP_ID := Oe_Order_Cache.g_header_rec.salesrep_id ;
2410: else
2411: Oe_Order_Cache.Load_Order_Header(p_line_rec.header_id) ;
2404: G_SALESREP_ID IS NULL Then
2405: --added for bug 4200055
2406: if ((Oe_Order_Cache.g_header_rec.header_id = p_line_rec.header_id)
2407: AND (Oe_Order_Cache.g_header_rec.header_id <> NULL)
2408: AND (Oe_Order_Cache.g_header_rec.header_id <> FND_API.G_MISS_NUM)) Then
2409: G_SALESREP_ID := Oe_Order_Cache.g_header_rec.salesrep_id ;
2410: else
2411: Oe_Order_Cache.Load_Order_Header(p_line_rec.header_id) ;
2412: G_SALESREP_ID := Oe_Order_Cache.g_header_rec.salesrep_id ;
2405: --added for bug 4200055
2406: if ((Oe_Order_Cache.g_header_rec.header_id = p_line_rec.header_id)
2407: AND (Oe_Order_Cache.g_header_rec.header_id <> NULL)
2408: AND (Oe_Order_Cache.g_header_rec.header_id <> FND_API.G_MISS_NUM)) Then
2409: G_SALESREP_ID := Oe_Order_Cache.g_header_rec.salesrep_id ;
2410: else
2411: Oe_Order_Cache.Load_Order_Header(p_line_rec.header_id) ;
2412: G_SALESREP_ID := Oe_Order_Cache.g_header_rec.salesrep_id ;
2413: end if ;
2407: AND (Oe_Order_Cache.g_header_rec.header_id <> NULL)
2408: AND (Oe_Order_Cache.g_header_rec.header_id <> FND_API.G_MISS_NUM)) Then
2409: G_SALESREP_ID := Oe_Order_Cache.g_header_rec.salesrep_id ;
2410: else
2411: Oe_Order_Cache.Load_Order_Header(p_line_rec.header_id) ;
2412: G_SALESREP_ID := Oe_Order_Cache.g_header_rec.salesrep_id ;
2413: end if ;
2414: /*select salesrep_id
2415: into G_SALESREP_ID
2408: AND (Oe_Order_Cache.g_header_rec.header_id <> FND_API.G_MISS_NUM)) Then
2409: G_SALESREP_ID := Oe_Order_Cache.g_header_rec.salesrep_id ;
2410: else
2411: Oe_Order_Cache.Load_Order_Header(p_line_rec.header_id) ;
2412: G_SALESREP_ID := Oe_Order_Cache.g_header_rec.salesrep_id ;
2413: end if ;
2414: /*select salesrep_id
2415: into G_SALESREP_ID
2416: from oe_order_headers