DBA Data[Home] [Help]

APPS.OE_DEFAULT_HEADER dependencies on OE_DEBUG_PUB

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

11: RETURN VARCHAR2
12: IS
13: l_freight_code VARCHAR2(80);
14: --
15: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
16: --
17: begin
18: IF l_debug_level > 0 THEN
19: oe_debug_pub.add('Enter get_freight_carrier()',1);

Line 19: oe_debug_pub.add('Enter get_freight_carrier()',1);

15: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
16: --
17: begin
18: IF l_debug_level > 0 THEN
19: oe_debug_pub.add('Enter get_freight_carrier()',1);
20: oe_debug_pub.add('Performance Issue 2830725 fixed',5);
21: END IF;
22: IF (p_header_rec.shipping_method_code IS NOT NULL AND
23: p_header_rec.shipping_method_code <> FND_API.G_MISS_CHAR) AND

Line 20: oe_debug_pub.add('Performance Issue 2830725 fixed',5);

16: --
17: begin
18: IF l_debug_level > 0 THEN
19: oe_debug_pub.add('Enter get_freight_carrier()',1);
20: oe_debug_pub.add('Performance Issue 2830725 fixed',5);
21: END IF;
22: IF (p_header_rec.shipping_method_code IS NOT NULL AND
23: p_header_rec.shipping_method_code <> FND_API.G_MISS_CHAR) AND
24: (p_header_rec.ship_from_org_id IS NOT NULL AND

Line 53: oe_debug_pub.add('Freight carrier returned is '||l_freight_code,5);

49: WHERE ship_method_code = p_header_rec.shipping_method_code
50: AND ORGANIZATION_ID = p_header_rec.ship_from_org_id;
51: END IF;
52: IF l_debug_level > 0 THEN
53: oe_debug_pub.add('Freight carrier returned is '||l_freight_code,5);
54: END IF;
55: RETURN l_freight_code;
56: ELSE
57: IF l_debug_level > 0 THEN

Line 58: oe_debug_pub.add('into header null condition'||p_header_rec.ship_from_org_id,5);

54: END IF;
55: RETURN l_freight_code;
56: ELSE
57: IF l_debug_level > 0 THEN
58: oe_debug_pub.add('into header null condition'||p_header_rec.ship_from_org_id,5);
59: END IF;
60: RETURN p_header_rec.freight_carrier_code;
61: END IF;
62: ELSE

Line 64: oe_debug_pub.add('SHIP FROM OR SHIP METHOD IS NULL/MISSING',5);

60: RETURN p_header_rec.freight_carrier_code;
61: END IF;
62: ELSE
63: IF l_debug_level > 0 THEN
64: oe_debug_pub.add('SHIP FROM OR SHIP METHOD IS NULL/MISSING',5);
65: END IF;
66: RETURN NULL;
67: END IF;
68:

Line 79: oe_debug_pub.add('SQL Error : '||sqlerrm,1);

75: EXCEPTION
76:
77: WHEN NO_DATA_FOUND THEN
78: IF l_debug_level > 0 THEN
79: oe_debug_pub.add('SQL Error : '||sqlerrm,1);
80: END IF;
81: RETURN NULL;
82: WHEN OTHERS THEN
83: IF l_debug_level > 0 THEN

Line 84: oe_debug_pub.add('SQL Other Error : '||sqlerrm,1);

80: END IF;
81: RETURN NULL;
82: WHEN OTHERS THEN
83: IF l_debug_level > 0 THEN
84: oe_debug_pub.add('SQL Other Error : '||sqlerrm,1);
85: END IF;
86: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
87: THEN
88: OE_MSG_PUB.Add_Exc_Msg

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

99: RETURN VARCHAR2
100: IS
101: l_category_code varchar2(30);
102: --
103: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
104: --
105: BEGIN
106: /*
107: * Always default 1 as the order category

Line 111: oe_debug_pub.add( 'ENTER ORDER CATEGORY' ) ;

107: * Always default 1 as the order category
108: *
109: */
110: IF l_debug_level > 0 THEN
111: oe_debug_pub.add( 'ENTER ORDER CATEGORY' ) ;
112: END IF;
113: IF l_debug_level > 0 THEN
114: oe_debug_pub.add( 'ENTER ORDER CATEGORY'|| P_HEADER_REC.ORDER_TYPE_ID ) ;
115: END IF;

Line 114: oe_debug_pub.add( 'ENTER ORDER CATEGORY'|| P_HEADER_REC.ORDER_TYPE_ID ) ;

110: IF l_debug_level > 0 THEN
111: oe_debug_pub.add( 'ENTER ORDER CATEGORY' ) ;
112: END IF;
113: IF l_debug_level > 0 THEN
114: oe_debug_pub.add( 'ENTER ORDER CATEGORY'|| P_HEADER_REC.ORDER_TYPE_ID ) ;
115: END IF;
116: Select order_category_code
117: into l_category_code
118: from

Line 131: oe_debug_pub.add( 'ORDER CATEGORY CONSTRAINED' ) ;

127: l_category_code) THEN
128: FND_MESSAGE.SET_NAME('ONT','OE_ORD_CAT_CONST');
129: OE_MSG_PUB.ADD;
130: IF l_debug_level > 0 THEN
131: oe_debug_pub.add( 'ORDER CATEGORY CONSTRAINED' ) ;
132: END IF;
133: RAISE FND_API.G_EXC_ERROR;
134: END IF;
135: END IF;

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

181: from hz_cust_site_uses
182: where
183: site_use_id = lsiteuseid;
184: --
185: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
186: --
187: Begin
188:
189: --IF p_header_rec.operation = oe_globals.g_opr_create THEN

Line 201: oe_debug_pub.add( 'ENTER - CUST PREF SET IN SHIP TO' , 1 ) ;

197: lshipset,
198: larrivalset;
199: CLOSE C2;
200: IF l_debug_level > 0 THEN
201: oe_debug_pub.add( 'ENTER - CUST PREF SET IN SHIP TO' , 1 ) ;
202: END IF;
203: IF nvl(lshipset,'N') = 'Y' THEN
204: RETURN 'SHIP';
205: ELSIF nvl(larrivalset,'N') = 'Y' THEN

Line 209: oe_debug_pub.add( 'EXIT - CUST PREF SET IN SHIP TO' , 1 ) ;

205: ELSIF nvl(larrivalset,'N') = 'Y' THEN
206: RETURN 'ARRIVAL';
207: END IF;
208: IF l_debug_level > 0 THEN
209: oe_debug_pub.add( 'EXIT - CUST PREF SET IN SHIP TO' , 1 ) ;
210: END IF;
211:
212: END IF;
213:

Line 224: oe_debug_pub.add( 'ENTER - CUST PREF SET IN BILL TO' , 1 ) ;

220: lshipset,
221: larrivalset;
222: CLOSE C2;
223: IF l_debug_level > 0 THEN
224: oe_debug_pub.add( 'ENTER - CUST PREF SET IN BILL TO' , 1 ) ;
225: END IF;
226: IF nvl(lshipset,'N') = 'Y' THEN
227: RETURN 'SHIP';
228: ELSIF nvl(larrivalset,'N') = 'Y' THEN

Line 232: oe_debug_pub.add( 'EXIT - CUST PREF SET IN BILL TO' , 1 ) ;

228: ELSIF nvl(larrivalset,'N') = 'Y' THEN
229: RETURN 'ARRIVAL';
230: END IF;
231: IF l_debug_level > 0 THEN
232: oe_debug_pub.add( 'EXIT - CUST PREF SET IN BILL TO' , 1 ) ;
233: END IF;
234:
235: END IF;
236:

Line 258: oe_debug_pub.add( 'ENTER - CUST PREF SET IN SOLD TO' , 1 ) ;

254: lshipset,
255: larrivalset;
256: CLOSE C1;
257: IF l_debug_level > 0 THEN
258: oe_debug_pub.add( 'ENTER - CUST PREF SET IN SOLD TO' , 1 ) ;
259: END IF;
260:
261: IF nvl(lshipset,'N') = 'Y' THEN
262: RETURN 'SHIP';

Line 268: oe_debug_pub.add( 'SET CODE'|| P_HEADER_REC.CUSTOMER_PREFERENCE_SET_CODE , 1 ) ;

264: RETURN 'ARRIVAL';
265: END IF;
266:
267: IF l_debug_level > 0 THEN
268: oe_debug_pub.add( 'SET CODE'|| P_HEADER_REC.CUSTOMER_PREFERENCE_SET_CODE , 1 ) ;
269: END IF;
270: RETURN p_header_rec.customer_preference_set_code;
271: IF l_debug_level > 0 THEN
272: oe_debug_pub.add( 'EXIT - CUST PREF SET IN SOLD TO' , 1 ) ;

Line 272: oe_debug_pub.add( 'EXIT - CUST PREF SET IN SOLD TO' , 1 ) ;

268: oe_debug_pub.add( 'SET CODE'|| P_HEADER_REC.CUSTOMER_PREFERENCE_SET_CODE , 1 ) ;
269: END IF;
270: RETURN p_header_rec.customer_preference_set_code;
271: IF l_debug_level > 0 THEN
272: oe_debug_pub.add( 'EXIT - CUST PREF SET IN SOLD TO' , 1 ) ;
273: END IF;
274: END IF;
275:
276:

Line 280: oe_debug_pub.add( 'SET CODE'|| P_HEADER_REC.CUSTOMER_PREFERENCE_SET_CODE , 1 ) ;

276:
277:
278: --END IF;
279: IF l_debug_level > 0 THEN
280: oe_debug_pub.add( 'SET CODE'|| P_HEADER_REC.CUSTOMER_PREFERENCE_SET_CODE , 1 ) ;
281: END IF;
282: IF l_debug_level > 0 THEN
283: oe_debug_pub.add( 'EXIT - ' , 1 ) ;
284: END IF;

Line 283: oe_debug_pub.add( 'EXIT - ' , 1 ) ;

279: IF l_debug_level > 0 THEN
280: oe_debug_pub.add( 'SET CODE'|| P_HEADER_REC.CUSTOMER_PREFERENCE_SET_CODE , 1 ) ;
281: END IF;
282: IF l_debug_level > 0 THEN
283: oe_debug_pub.add( 'EXIT - ' , 1 ) ;
284: END IF;
285:
286: RETURN p_header_rec.customer_preference_set_code;
287: EXCEPTION

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

305: FUNCTION Get_Booked
306: RETURN VARCHAR2
307: IS
308: --
309: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
310: --
311: BEGIN
312:
313: RETURN 'N';

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

317: FUNCTION Get_Cancelled
318: RETURN VARCHAR2
319: IS
320: --
321: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
322: --
323: BEGIN
324:
325: RETURN 'N';

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

330: RETURN NUMBER
331: IS
332: l_hdr_id NUMBER := NULL;
333: --
334: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
335: --
336: BEGIN
337: /*
338: * Select from the sequence

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

363: FUNCTION Get_Open
364: RETURN VARCHAR2
365: IS
366: --
367: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
368: --
369: BEGIN
370:
371: RETURN 'Y';

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

376: RETURN NUMBER
377: IS
378: l_org_id NUMBER := NULL;
379: --
380: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
381: --
382: BEGIN
383:
384: OE_GLOBALS.Set_Context;

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

391: FUNCTION Get_Ordered_Date
392: RETURN DATE
393: IS
394: --
395: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
396: --
397: BEGIN
398:
399: /*

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

422: FUNCTION Get_Version_Number
423: RETURN NUMBER
424: IS
425: --
426: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
427: --
428: BEGIN
429: /*
430: * Always default 1 as the version number prior to 11i10.

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

458: RETURN NUMBER
459: IS
460: --l_order_source_id NUMBER;
461: --
462: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
463: --
464: BEGIN
465: /*
466: SELECT ORDER_SOURCE_ID

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

490: RETURN NUMBER
491: IS
492: l_em_message_id NUMBER;
493: --
494: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
495: --
496: BEGIN
497: SELECT OE_XML_MESSAGE_SEQ_S.NEXTVAL
498: INTO l_em_message_id

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

512: l_contract_template_id NUMBER := NULL;
513: l_return_status VARCHAR2(1);
514: l_msg_count NUMBER;
515: l_msg_data VARCHAR2(2000);
516: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
517: l_result VARCHAR2(1) := 'Y';
518: BEGIN
519:
520: IF l_debug_level > 0 THEN

Line 521: oe_debug_pub.add( 'ENTER GET CONTRACT TEMPLATE' ) ;

517: l_result VARCHAR2(1) := 'Y';
518: BEGIN
519:
520: IF l_debug_level > 0 THEN
521: oe_debug_pub.add( 'ENTER GET CONTRACT TEMPLATE' ) ;
522: END IF;
523:
524: BEGIN
525: select contract_template_id

Line 535: oe_debug_pub.add( 'l_contract_template_id'|| l_contract_template_id ) ;

531: l_contract_template_id := NULL;
532: END;
533:
534: IF l_debug_level > 0 THEN
535: oe_debug_pub.add( 'l_contract_template_id'|| l_contract_template_id ) ;
536: oe_debug_pub.add( 'p_header_rec.order_type_id'|| p_header_rec.order_type_id ) ;
537: END IF;
538:
539: -- call is_terms_template_valid

Line 536: oe_debug_pub.add( 'p_header_rec.order_type_id'|| p_header_rec.order_type_id ) ;

532: END;
533:
534: IF l_debug_level > 0 THEN
535: oe_debug_pub.add( 'l_contract_template_id'|| l_contract_template_id ) ;
536: oe_debug_pub.add( 'p_header_rec.order_type_id'|| p_header_rec.order_type_id ) ;
537: END IF;
538:
539: -- call is_terms_template_valid
540: -- check for result and put msg on stack based if N

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

598: )
599: IS
600: l_header_rec OE_AK_ORDER_HEADERS_V%ROWTYPE;
601: --
602: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
603: --
604: BEGIN
605: IF l_debug_level > 0 THEN
606: oe_debug_pub.add('ENTER Clear_And_Re_Default') ;

Line 606: oe_debug_pub.add('ENTER Clear_And_Re_Default') ;

602: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
603: --
604: BEGIN
605: IF l_debug_level > 0 THEN
606: oe_debug_pub.add('ENTER Clear_And_Re_Default') ;
607: END IF;
608:
609: -- Identify source attributes
610: -- And copy source attribute values from IN parameters

Line 630: oe_debug_pub.add('RE-CALLING ONT_HEADER_DEF_HDLR.DEFAULT_RECORD') ;

626: END IF;
627:
628: IF p_default_record = 'Y' THEN
629: IF l_debug_level > 0 THEN
630: oe_debug_pub.add('RE-CALLING ONT_HEADER_DEF_HDLR.DEFAULT_RECORD') ;
631: END IF;
632: ONT_HEADER_Def_Hdlr.Default_Record
633: (p_x_rec => p_x_header_rec
634: ,p_initial_rec => l_header_rec

Line 640: oe_debug_pub.add('EXIT Clear_And_Re_Default') ;

636: );
637: END IF;
638:
639: IF l_debug_level > 0 THEN
640: oe_debug_pub.add('EXIT Clear_And_Re_Default') ;
641: END IF;
642:
643: END Clear_And_Re_Default;
644:

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

651: IS
652: l_blanket_number NUMBER := NULL;
653: l_request_date DATE;
654: --
655: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
656: --
657: BEGIN
658:
659: if l_debug_level > 0 then

Line 660: oe_debug_pub.add('Enter Default_Blanket_Number');

656: --
657: BEGIN
658:
659: if l_debug_level > 0 then
660: oe_debug_pub.add('Enter Default_Blanket_Number');
661: oe_debug_pub.add('Request Date :'||p_request_date);
662: end if;
663:
664: if p_request_date = fnd_api.g_miss_date then

Line 661: oe_debug_pub.add('Request Date :'||p_request_date);

657: BEGIN
658:
659: if l_debug_level > 0 then
660: oe_debug_pub.add('Enter Default_Blanket_Number');
661: oe_debug_pub.add('Request Date :'||p_request_date);
662: end if;
663:
664: if p_request_date = fnd_api.g_miss_date then
665: l_request_date := null;

Line 683: oe_debug_pub.add('Exit Default_Blanket_Number, default :'||l_blanket_number);

679: AND BH.ORDER_NUMBER = BHE.ORDER_NUMBER
680: AND BH.SALES_DOCUMENT_TYPE_CODE = 'B';
681:
682: if l_debug_level > 0 then
683: oe_debug_pub.add('Exit Default_Blanket_Number, default :'||l_blanket_number);
684: end if;
685:
686: RETURN l_blanket_number;
687:

Line 693: oe_debug_pub.add('No Blanket Number exists for this customer and po number :'||p_sold_to_org_id || ', ' || p_cust_po_number,2);

689: WHEN TOO_MANY_ROWS THEN
690: RETURN NULL;
691: WHEN NO_DATA_FOUND THEN
692: IF l_debug_level > 0 THEN
693: oe_debug_pub.add('No Blanket Number exists for this customer and po number :'||p_sold_to_org_id || ', ' || p_cust_po_number,2);
694: END IF;
695: RETURN NULL;
696: END Default_Blanket_Number;
697:

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

717: l_exists VARCHAR2(1);
718: l_party_type VARCHAR2(30);
719:
720: --
721: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
722: --
723: BEGIN
724:
725: IF l_debug_level > 0 THEN

Line 726: oe_debug_pub.add( 'ENTER OE_DEFAULT_HEADER.ATTRIBUTES' ) ;

722: --
723: BEGIN
724:
725: IF l_debug_level > 0 THEN
726: oe_debug_pub.add( 'ENTER OE_DEFAULT_HEADER.ATTRIBUTES' ) ;
727: END IF;
728:
729: -- Due to incompatibilities in the record type structure
730: -- copy the data to a rowtype record format

Line 801: oe_debug_pub.add('Blanket Number :'||g_header_rec.blanket_number);

797: --defaults blanket_number based on sold_to_org and customer_po:
798: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN
799:
800: IF l_debug_level > 0 THEN
801: oe_debug_pub.add('Blanket Number :'||g_header_rec.blanket_number);
802: oe_debug_pub.add('Sold To :'||g_header_rec.sold_to_org_id);
803: oe_debug_pub.add('Cust PO :'||g_header_rec.cust_po_number);
804: oe_debug_pub.add('Old Cust PO :'||l_old_header_rec.cust_po_number);
805: END IF;

Line 802: oe_debug_pub.add('Sold To :'||g_header_rec.sold_to_org_id);

798: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN
799:
800: IF l_debug_level > 0 THEN
801: oe_debug_pub.add('Blanket Number :'||g_header_rec.blanket_number);
802: oe_debug_pub.add('Sold To :'||g_header_rec.sold_to_org_id);
803: oe_debug_pub.add('Cust PO :'||g_header_rec.cust_po_number);
804: oe_debug_pub.add('Old Cust PO :'||l_old_header_rec.cust_po_number);
805: END IF;
806:

Line 803: oe_debug_pub.add('Cust PO :'||g_header_rec.cust_po_number);

799:
800: IF l_debug_level > 0 THEN
801: oe_debug_pub.add('Blanket Number :'||g_header_rec.blanket_number);
802: oe_debug_pub.add('Sold To :'||g_header_rec.sold_to_org_id);
803: oe_debug_pub.add('Cust PO :'||g_header_rec.cust_po_number);
804: oe_debug_pub.add('Old Cust PO :'||l_old_header_rec.cust_po_number);
805: END IF;
806:
807: IF (g_header_rec.blanket_number IS NULL OR

Line 804: oe_debug_pub.add('Old Cust PO :'||l_old_header_rec.cust_po_number);

800: IF l_debug_level > 0 THEN
801: oe_debug_pub.add('Blanket Number :'||g_header_rec.blanket_number);
802: oe_debug_pub.add('Sold To :'||g_header_rec.sold_to_org_id);
803: oe_debug_pub.add('Cust PO :'||g_header_rec.cust_po_number);
804: oe_debug_pub.add('Old Cust PO :'||l_old_header_rec.cust_po_number);
805: END IF;
806:
807: IF (g_header_rec.blanket_number IS NULL OR
808: g_header_rec.blanket_number = FND_API.G_MISS_NUM) AND

Line 848: oe_debug_pub.add( 'CALLING ONT_HEADER_DEF_HDLR.DEFAULT_RECORD ' ) ;

844: --END Blankets Code Merge
845:
846: -- call the default handler framework to default the missing attributes
847: IF l_debug_level > 0 THEN
848: oe_debug_pub.add( 'CALLING ONT_HEADER_DEF_HDLR.DEFAULT_RECORD ' ) ;
849: END IF;
850: l_record := g_header_rec;
851:
852: -- add the code below to populate party_type if pay now is enabled and

Line 888: oe_debug_pub.add('party type in defaulting is: '||l_party_type, 3);

884: g_header_rec.party_type := l_party_type;
885: l_old_header_rec.party_type := l_party_type;
886:
887: IF l_debug_level > 0 then
888: oe_debug_pub.add('party type in defaulting is: '||l_party_type, 3);
889: END IF;
890: END IF;
891: END IF;
892:

Line 900: oe_debug_pub.add( 'RETURNING FROM ONT_HEADER_DEF_HDLR.DEFAULT_RECORD ' ) ;

896: , p_in_old_rec => l_old_header_rec
897: , p_iteration => p_iteration
898: );
899: IF l_debug_level > 0 THEN
900: oe_debug_pub.add( 'RETURNING FROM ONT_HEADER_DEF_HDLR.DEFAULT_RECORD ' ) ;
901: END IF;
902:
903: --BEGIN Blankets Code Merge
904: --Blanket Header Hardcoded Defaulting

Line 921: oe_debug_pub.add('cust po changed and blkt num is null');

917: ,g_header_rec.cust_po_number)
918: THEN
919:
920: if l_debug_level > 0 then
921: oe_debug_pub.add('cust po changed and blkt num is null');
922: end if;
923:
924: l_blanket_number := Default_Blanket_Number(
925: l_record.sold_to_org_id,

Line 954: oe_debug_pub.add( 'ENTER DEFAULT CATEGORY'|| P_X_HEADER_REC.ORDER_TYPE_ID ) ;

950: END IF;
951: --End Blankets Code Merge
952:
953: IF l_debug_level > 0 THEN
954: oe_debug_pub.add( 'ENTER DEFAULT CATEGORY'|| P_X_HEADER_REC.ORDER_TYPE_ID ) ;
955: END IF;
956: IF l_debug_level > 0 THEN
957: oe_debug_pub.add( 'ENTER DEFAULT CATEGORY'|| P_X_HEADER_REC.ORDER_CATEGORY_CODE ) ;
958: END IF;

Line 957: oe_debug_pub.add( 'ENTER DEFAULT CATEGORY'|| P_X_HEADER_REC.ORDER_CATEGORY_CODE ) ;

953: IF l_debug_level > 0 THEN
954: oe_debug_pub.add( 'ENTER DEFAULT CATEGORY'|| P_X_HEADER_REC.ORDER_TYPE_ID ) ;
955: END IF;
956: IF l_debug_level > 0 THEN
957: oe_debug_pub.add( 'ENTER DEFAULT CATEGORY'|| P_X_HEADER_REC.ORDER_CATEGORY_CODE ) ;
958: END IF;
959: IF (p_x_header_rec.order_category_code = FND_API.G_MISS_CHAR OR
960: p_x_header_rec.order_category_code IS NULL) THEN
961:

Line 989: oe_debug_pub.add( 'SET CODE'|| P_X_HEADER_REC.CUSTOMER_PREFERENCE_SET_CODE , 1 ) ;

985: l_cust_pref_set_code IS NOT NULL) THEN
986: p_x_header_rec.customer_preference_set_code := l_cust_pref_set_code;
987: END IF;
988: IF l_debug_level > 0 THEN
989: oe_debug_pub.add( 'SET CODE'|| P_X_HEADER_REC.CUSTOMER_PREFERENCE_SET_CODE , 1 ) ;
990: END IF;
991:
992: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL <= '110509' THEN
993: p_x_header_rec.customer_preference_set_code

Line 999: oe_debug_pub.add( 'AFTER SET CODE'|| P_X_HEADER_REC.CUSTOMER_PREFERENCE_SET_CODE , 1 ) ;

995: p_old_header_rec => p_old_header_rec);
996: END IF;
997:
998: IF l_debug_level > 0 THEN
999: oe_debug_pub.add( 'AFTER SET CODE'|| P_X_HEADER_REC.CUSTOMER_PREFERENCE_SET_CODE , 1 ) ;
1000: END IF;
1001:
1002: -- Assign the marketing_source_code_id value back to the out record. This
1003: -- done because the column in not enabled in the AK tables for defaulting.

Line 1017: oe_debug_pub.add( 'JPN: MARKETING SOURCE CODE IS:' || P_X_HEADER_REC.MARKETING_SOURCE_CODE_ID ) ;

1013: p_old_header_rec => p_old_header_rec);
1014:
1015:
1016: IF l_debug_level > 0 THEN
1017: oe_debug_pub.add( 'JPN: MARKETING SOURCE CODE IS:' || P_X_HEADER_REC.MARKETING_SOURCE_CODE_ID ) ;
1018: END IF;
1019:
1020: --If order currency is different than SOB currency and
1021: --fixed_rate is detected as Yes, then both of them are

Line 1031: oe_debug_pub.add( 'WHEN CURR CODE IS NOT SAME' ) ;

1027: IF p_x_header_rec.transactional_curr_code <> l_set_of_books_rec.currency_code
1028: THEN
1029:
1030: IF l_debug_level > 0 THEN
1031: oe_debug_pub.add( 'WHEN CURR CODE IS NOT SAME' ) ;
1032: END IF;
1033: l_Is_Fixed_Rate :=
1034: GL_CURRENCY_API.IS_FIXED_RATE(
1035: p_x_header_rec.transactional_curr_code,

Line 1190: oe_debug_pub.add('Transaction phase after defaulting fwk :'

1186:
1187: -- QUOTING changes
1188:
1189: IF l_debug_level > 0 THEN
1190: oe_debug_pub.add('Transaction phase after defaulting fwk :'
1191: ||p_x_header_rec.transaction_phase_code);
1192: END IF;
1193:
1194: IF oe_code_control.code_release_level >= '110510' THEN

Line 1234: oe_debug_pub.add('Transaction phase at end :'

1230:
1231: END IF;
1232:
1233: IF l_debug_level > 0 THEN
1234: oe_debug_pub.add('Transaction phase at end :'
1235: ||p_x_header_rec.transaction_phase_code);
1236: END IF;
1237:
1238: -- QUOTING changes END

Line 1248: oe_debug_pub.add( 'EXIT OE_DEFAULT_HEADER.ATTRIBUTES' ) ;

1244: END IF;
1245: END IF;
1246:
1247: IF l_debug_level > 0 THEN
1248: oe_debug_pub.add( 'EXIT OE_DEFAULT_HEADER.ATTRIBUTES' ) ;
1249: END IF;
1250:
1251: EXCEPTION
1252: