[Home] [Help]
1: PACKAGE BODY OE_CNCL_Util AS
2: /* $Header: OEXVCGIB.pls 120.3 2008/01/10 12:41:56 sgoli ship $ */
3:
4: -- Global constant holding the package name
5:
2: /* $Header: OEXVCGIB.pls 120.3 2008/01/10 12:41:56 sgoli ship $ */
3:
4: -- Global constant holding the package name
5:
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_CNCL_Util';
7:
8:
9: PROCEDURE Get_Header_Ids
10: ( p_x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type
20: --
21: BEGIN
22: -- aksingh start on 08/07/2000
23: IF l_debug_level > 0 THEN
24: oe_debug_pub.add( 'ENTERING OE_CNCL_UTIL.GET_HEADER_IDS' , 1 ) ;
25: END IF;
26:
27:
28: IF p_header_val_rec.accounting_rule <> FND_API.G_MISS_CHAR
1258: -- End of get IDs for customer related fields
1259: ----------------------------------------------------------------------
1260:
1261: IF l_debug_level > 0 THEN
1262: oe_debug_pub.add( 'EXITING OE_CNCL_UTIL.GET_HEADER_IDS' , 1 ) ;
1263: END IF;
1264:
1265: END Get_Header_Ids;
1266:
2880: IS
2881: --p_x_header_rec OE_Order_PUB.Header_Rec_Type := p_header_rec;
2882: BEGIN
2883:
2884: oe_debug_pub.add('Entering OE_CNCL_UTIL.CONVERT_MISS_TO_NULL: HEADER', 1);
2885:
2886: IF p_x_header_rec.accounting_rule_id = FND_API.G_MISS_NUM THEN
2887: p_x_header_rec.accounting_rule_id := NULL;
2888: END IF;
3584: IF p_x_header_rec.order_firmed_date = FND_API.G_MISS_DATE THEN
3585: p_x_header_rec.order_firmed_date := NULL;
3586: END IF;
3587:
3588: oe_debug_pub.add('Exiting OE_CNCL_UTIL.CONVERT_MISS_TO_NULL: HEADER', 1);
3589:
3590:
3591: END Convert_Miss_To_Null;
3592:
3602: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3603: BEGIN
3604:
3605: if l_debug_level > 0 then
3606: oe_debug_pub.add('Entering OE_CNCL_UTIL.CONVERT_MISS_TO_NULL: LINE', 1);
3607:
3608: oe_debug_pub.add('outside margin convert miss to null',1);
3609: end if;
3610: --MRG BGN
4956: p_x_line_rec.USER_ITEM_DESCRIPTION := NULL;
4957: END IF;
4958:
4959: if l_debug_level > 0 then
4960: oe_debug_pub.add('Exiting OE_CNCL_UTIL.CONVERT_MISS_TO_NULL: LINE', 1);
4961: end if;
4962: END Convert_Miss_To_Null;
4963:
4964:
4976: --
4977: BEGIN
4978:
4979: IF l_debug_level > 0 THEN
4980: oe_debug_pub.add( 'ENTERING OE_CNCL_UTIL.CONVERT_MISS_TO_NULL: HEADER ADJUSTMENT' , 1 ) ;
4981: END IF;
4982:
4983: IF l_Header_Adj_rec.price_adjustment_id = FND_API.G_MISS_NUM THEN
4984: l_Header_Adj_rec.price_adjustment_id := NULL;
5377: END IF;
5378:
5379:
5380: IF l_debug_level > 0 THEN
5381: oe_debug_pub.add( 'EXITING OE_CNCL_UTIL.CONVERT_MISS_TO_NULL: HEADER ADJUSTMENT' , 1 ) ;
5382: END IF;
5383:
5384: -- RETURN l_Header_Adj_rec;
5385: p_x_Header_Adj_rec := l_Header_Adj_rec;
5397: --
5398: BEGIN
5399:
5400: IF l_debug_level > 0 THEN
5401: oe_debug_pub.add( 'EXITING OE_CNCL_UTIL.CONVERT_MISS_TO_NULL: HEADER SCREDIT' , 1 ) ;
5402: END IF;
5403: IF p_x_Header_Scredit_rec.ATTRIBUTE1 = FND_API.G_MISS_CHAR THEN
5404: p_x_Header_Scredit_rec.ATTRIBUTE1 := NULL;
5405: END IF;
5534: p_x_Header_Scredit_rec.WH_UPDATE_DATE := NULL;
5535: END IF;
5536:
5537: IF l_debug_level > 0 THEN
5538: oe_debug_pub.add( 'EXITING OE_CNCL_UTIL.CONVERT_MISS_TO_NULL: HEADER SCREDIT' , 1 ) ;
5539: END IF;
5540:
5541: END Convert_Miss_To_Null;
5542:
5558: BEGIN
5559:
5560:
5561: IF l_debug_level > 0 THEN
5562: oe_debug_pub.add( 'ENTERING OE_CNCL_UTIL.CONVERT_MISS_TO_NULL: LINE ADJUSTMENT' , 1 ) ;
5563: END IF;
5564:
5565: IF l_Line_Adj_rec.adjusted_amount = FND_API.G_MISS_NUM THEN
5566: l_Line_Adj_rec.adjusted_amount := NULL;
5965: l_line_Adj_rec.tax_rate_id := NULL;
5966: END IF;
5967:
5968: IF l_debug_level > 0 THEN
5969: oe_debug_pub.add( 'EXITING OE_CNCL_UTIL.CONVERT_MISS_TO_NULL: LINE ADJUSTMENT' , 1 ) ;
5970: END IF;
5971:
5972: -- RETURN l_Line_Adj_rec;
5973: p_x_Line_Adj_rec := l_Line_Adj_rec;
5984: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5985: --
5986: BEGIN
5987: IF l_debug_level > 0 THEN
5988: oe_debug_pub.add( 'EXITING OE_CNCL_UTIL.CONVERT_MISS_TO_NULL: LINE SCREDIT' , 1 ) ;
5989: END IF;
5990: IF p_x_Line_Scredit_rec.ATTRIBUTE1 = FND_API.G_MISS_CHAR THEN
5991: p_x_Line_Scredit_rec.ATTRIBUTE1 := NULL;
5992: END IF;
6124:
6125: END IF;
6126:
6127: IF l_debug_level > 0 THEN
6128: oe_debug_pub.add( 'EXITING OE_CNCL_UTIL.CONVERT_MISS_TO_NULL: LINE SCREDIT' , 1 ) ;
6129: END IF;
6130: END;
6131:
6132:
6129: END IF;
6130: END;
6131:
6132:
6133: END OE_CNCL_UTIL;