DBA Data[Home] [Help]

APPS.OE_CNCL_UTIL dependencies on OE_DEBUG_PUB

Line 19: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

15: l_ship_to_org_id NUMBER;
16: l_invoice_to_org_id NUMBER;
17: l_deliver_to_org_id NUMBER;
18: --
19: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
20: --
21: BEGIN
22: -- aksingh start on 08/07/2000
23: IF l_debug_level > 0 THEN

Line 24: oe_debug_pub.add( 'ENTERING OE_CNCL_UTIL.GET_HEADER_IDS' , 1 ) ;

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

Line 200: oe_debug_pub.add( 'SHIP METHOD CONVERSION ERROR' ) ;

196: );
197:
198: IF p_x_header_rec.shipping_method_code = FND_API.G_MISS_CHAR THEN
199: IF l_debug_level > 0 THEN
200: oe_debug_pub.add( 'SHIP METHOD CONVERSION ERROR' ) ;
201: END IF;
202: p_x_header_rec.return_status := FND_API.G_RET_STS_ERROR;
203: END IF;
204:

Line 953: oe_debug_pub.add( ' customer location error ') ;

949: );
950:
951: IF p_x_header_rec.sold_to_site_use_id = FND_API.G_MISS_NUM THEN
952: IF l_debug_level > 0 THEN
953: oe_debug_pub.add( ' customer location error ') ;
954: END IF;
955: p_x_header_rec.return_status := FND_API.G_RET_STS_ERROR;
956: END IF;
957:

Line 1077: oe_Debug_pub.add('attribute procedure');

1073:
1074: END IF;
1075:
1076: ELSE
1077: oe_Debug_pub.add('attribute procedure');
1078: p_x_header_rec.end_customer_id:=OE_Value_To_Id.end_customer
1079: ( p_end_customer => p_header_val_rec.end_customer_name
1080: ,p_end_customer_number=> p_header_val_rec.end_customer_number
1081: );

Line 1108: oe_debug_pub.add('before calling aend customer contact value to id');

1104:
1105: END IF;
1106:
1107: ELSE
1108: oe_debug_pub.add('before calling aend customer contact value to id');
1109: p_x_header_rec.end_customer_contact_id := OE_Value_To_Id.end_customer_contact
1110: ( p_end_customer_contact => p_header_val_rec.end_customer_contact
1111: ,p_end_customer_id =>p_x_header_rec.end_customer_id
1112: );

Line 1113: oe_debug_pub.add('End customer contact id is '||p_x_header_rec.end_customer_contact_id);

1109: p_x_header_rec.end_customer_contact_id := OE_Value_To_Id.end_customer_contact
1110: ( p_end_customer_contact => p_header_val_rec.end_customer_contact
1111: ,p_end_customer_id =>p_x_header_rec.end_customer_id
1112: );
1113: oe_debug_pub.add('End customer contact id is '||p_x_header_rec.end_customer_contact_id);
1114:
1115: IF p_x_header_rec.end_customer_contact_id = FND_API.G_MISS_NUM THEN
1116: p_x_header_rec.return_status := FND_API.G_RET_STS_ERROR;
1117: END IF;

Line 1147: oe_debug_pub.add('Before calling End custoemr site use value to id');

1143:
1144: END IF;
1145:
1146: ELSE
1147: oe_debug_pub.add('Before calling End custoemr site use value to id');
1148: p_x_header_rec.end_customer_site_use_id := OE_Value_To_Id.end_customer_site
1149: ( p_end_customer_site_address1 => p_header_val_rec.end_customer_site_address1
1150: , p_end_customer_site_address2 => p_header_val_rec.end_customer_site_address2
1151: , p_end_customer_site_address3 => p_header_val_rec.end_customer_site_address3

Line 1164: oe_debug_pub.add('after hdr sold_to_site_use_id='||p_x_header_rec.end_customer_site_use_id);

1160: , p_end_customer_site_use_code => NULL
1161: );
1162:
1163:
1164: oe_debug_pub.add('after hdr sold_to_site_use_id='||p_x_header_rec.end_customer_site_use_id);
1165:
1166: IF p_x_header_rec.end_customer_site_use_id = FND_API.G_MISS_NUM THEN
1167: p_x_header_rec.return_status := FND_API.G_RET_STS_ERROR;
1168: END IF;

Line 1262: oe_debug_pub.add( 'EXITING OE_CNCL_UTIL.GET_HEADER_IDS' , 1 ) ;

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:

Line 1278: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

1274: l_deliver_to_org_id NUMBER;
1275: l_invoice_to_org_id NUMBER;
1276: l_ship_to_org_id NUMBER;
1277: --
1278: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1279: --
1280: BEGIN
1281: p_x_line_rec.return_status := FND_API.G_RET_STS_SUCCESS;
1282:

Line 1449: oe_debug_pub.add( 'SHIP METHOD CONVERSION ERROR' ) ;

1445: );
1446:
1447: IF p_x_line_rec.shipping_method_code = FND_API.G_MISS_CHAR THEN
1448: IF l_debug_level > 0 THEN
1449: oe_debug_pub.add( 'SHIP METHOD CONVERSION ERROR' ) ;
1450: END IF;
1451: p_x_line_rec.return_status := FND_API.G_RET_STS_ERROR;
1452: END IF;
1453:

Line 2389: oe_Debug_pub.add('In get line ids procedure');

2385: END IF;
2386:
2387: --{added for bug 4240715
2388:
2389: oe_Debug_pub.add('In get line ids procedure');
2390:
2391: IF p_line_val_rec.end_customer_name <> FND_API.G_MISS_CHAR
2392: OR p_line_val_rec.end_customer_number <> FND_API.G_MISS_CHAR
2393: THEN

Line 2414: oe_debug_pub.add('after gettting end customer id'||p_x_line_rec.end_customer_id);

2410: ( p_end_customer => p_line_val_rec.end_customer_name
2411: ,p_end_customer_number=> p_line_val_rec.end_customer_number
2412: );
2413:
2414: oe_debug_pub.add('after gettting end customer id'||p_x_line_rec.end_customer_id);
2415: IF p_x_line_rec.end_customer_id = FND_API.G_MISS_NUM THEN
2416: p_x_line_rec.return_status := FND_API.G_RET_STS_ERROR;
2417: END IF;
2418:

Line 2440: oe_debug_pub.add('before calling aend customer contact value to id');

2436:
2437: END IF;
2438:
2439: ELSE
2440: oe_debug_pub.add('before calling aend customer contact value to id');
2441: p_x_line_rec.end_customer_contact_id := OE_Value_To_Id.end_customer_contact
2442: ( p_end_customer_contact => p_line_val_rec.end_customer_contact
2443: ,p_end_customer_id =>p_x_line_rec.end_customer_id
2444: );

Line 2445: oe_debug_pub.add('End customer contact id is '||p_x_line_rec.end_customer_contact_id);

2441: p_x_line_rec.end_customer_contact_id := OE_Value_To_Id.end_customer_contact
2442: ( p_end_customer_contact => p_line_val_rec.end_customer_contact
2443: ,p_end_customer_id =>p_x_line_rec.end_customer_id
2444: );
2445: oe_debug_pub.add('End customer contact id is '||p_x_line_rec.end_customer_contact_id);
2446:
2447: IF p_x_line_rec.end_customer_contact_id = FND_API.G_MISS_NUM THEN
2448: p_x_line_rec.return_status := FND_API.G_RET_STS_ERROR;
2449: END IF;

Line 2479: oe_debug_pub.add('Before calling End custoemr site use value to id');

2475:
2476: END IF;
2477:
2478: ELSE
2479: oe_debug_pub.add('Before calling End custoemr site use value to id');
2480: p_x_line_rec.end_customer_site_use_id := OE_Value_To_Id.end_customer_site
2481: ( p_end_customer_site_address1 => p_line_val_rec.end_customer_site_address1
2482: , p_end_customer_site_address2 => p_line_val_rec.end_customer_site_address2
2483: , p_end_customer_site_address3 => p_line_val_rec.end_customer_site_address3

Line 2496: oe_debug_pub.add('after hdr sold_to_site_use_id='||p_x_line_rec.end_customer_site_use_id);

2492: , p_end_customer_site_use_code => NULL
2493: );
2494:
2495:
2496: oe_debug_pub.add('after hdr sold_to_site_use_id='||p_x_line_rec.end_customer_site_use_id);
2497:
2498: IF p_x_line_rec.end_customer_site_use_id = FND_API.G_MISS_NUM THEN
2499: p_x_line_rec.return_status := FND_API.G_RET_STS_ERROR;
2500: END IF;

Line 2607: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

2603: )
2604: IS
2605:
2606: --
2607: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2608: --
2609: BEGIN
2610: -- aksingh working
2611: -- initialize return_status.

Line 2691: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

2687: , p_Line_Scredit_val_rec IN OE_Order_PUB.Line_Scredit_Val_Rec_Type
2688: )
2689: IS
2690: --
2691: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2692: --
2693: BEGIN
2694:
2695: -- initialize return_status.

Line 2770: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

2766: )
2767: IS
2768: l_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2769: --
2770: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2771: --
2772: BEGIN
2773: -- aksingh completed modification
2774: -- initialize return_status.

Line 2825: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

2821: )
2822: IS
2823: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2824: --
2825: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2826: --
2827: BEGIN
2828:
2829: -- initialize return_status.

Line 2884: oe_debug_pub.add('Entering OE_CNCL_UTIL.CONVERT_MISS_TO_NULL: HEADER', 1);

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;

Line 3588: oe_debug_pub.add('Exiting OE_CNCL_UTIL.CONVERT_MISS_TO_NULL: HEADER', 1);

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:

Line 3602: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

3598: PROCEDURE Convert_Miss_To_Null
3599: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
3600: )
3601: IS
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);

Line 3606: oe_debug_pub.add('Entering OE_CNCL_UTIL.CONVERT_MISS_TO_NULL: LINE', 1);

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

Line 3608: oe_debug_pub.add('outside margin convert miss to null',1);

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
3611: IF OE_FEATURES_PVT.Is_Margin_Avail Then
3612: if l_debug_level > 0 then

Line 3613: oe_debug_pub.add('inside margin convert miss to null',1);

3609: end if;
3610: --MRG BGN
3611: IF OE_FEATURES_PVT.Is_Margin_Avail Then
3612: if l_debug_level > 0 then
3613: oe_debug_pub.add('inside margin convert miss to null',1);
3614: end if;
3615: IF p_x_line_rec.unit_cost = FND_API.G_MISS_NUM THEN
3616: p_x_line_rec.unit_cost := NULL;
3617: END IF;

Line 4806: oe_debug_pub.add('OEXVCIGB convert_miss_to_null - order_source_id');

4802: /* End of Marketing source code related */
4803:
4804: IF p_x_line_rec.order_source_id = FND_API.G_MISS_NUM THEN
4805: if l_debug_level > 0 then
4806: oe_debug_pub.add('OEXVCIGB convert_miss_to_null - order_source_id');
4807: end if;
4808: p_x_line_rec.order_source_id := NULL;
4809: END IF;
4810:

Line 4960: oe_debug_pub.add('Exiting OE_CNCL_UTIL.CONVERT_MISS_TO_NULL: LINE', 1);

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:

Line 4975: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

4971: )
4972: IS
4973: l_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type := p_x_Header_Adj_rec;
4974: --
4975: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4976: --
4977: BEGIN
4978:
4979: IF l_debug_level > 0 THEN

Line 4980: oe_debug_pub.add( 'ENTERING OE_CNCL_UTIL.CONVERT_MISS_TO_NULL: HEADER ADJUSTMENT' , 1 ) ;

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;

Line 5381: oe_debug_pub.add( 'EXITING OE_CNCL_UTIL.CONVERT_MISS_TO_NULL: HEADER ADJUSTMENT' , 1 ) ;

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;

Line 5396: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

5392: ( p_x_Header_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Header_Scredit_Rec_Type
5393: )
5394: IS
5395: --
5396: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5397: --
5398: BEGIN
5399:
5400: IF l_debug_level > 0 THEN

Line 5401: oe_debug_pub.add( 'EXITING OE_CNCL_UTIL.CONVERT_MISS_TO_NULL: HEADER SCREDIT' , 1 ) ;

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;

Line 5538: oe_debug_pub.add( 'EXITING OE_CNCL_UTIL.CONVERT_MISS_TO_NULL: HEADER SCREDIT' , 1 ) ;

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:

Line 5556: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

5552: )
5553: IS
5554: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type := p_x_Line_Adj_rec;
5555: --
5556: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5557: --
5558: BEGIN
5559:
5560:

Line 5562: oe_debug_pub.add( 'ENTERING OE_CNCL_UTIL.CONVERT_MISS_TO_NULL: LINE ADJUSTMENT' , 1 ) ;

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;

Line 5969: oe_debug_pub.add( 'EXITING OE_CNCL_UTIL.CONVERT_MISS_TO_NULL: LINE ADJUSTMENT' , 1 ) ;

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;

Line 5984: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

5980: ( p_x_Line_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Rec_Type
5981: )
5982: IS
5983: --
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 ) ;

Line 5988: oe_debug_pub.add( 'EXITING OE_CNCL_UTIL.CONVERT_MISS_TO_NULL: LINE SCREDIT' , 1 ) ;

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;

Line 6128: oe_debug_pub.add( 'EXITING OE_CNCL_UTIL.CONVERT_MISS_TO_NULL: LINE SCREDIT' , 1 ) ;

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: