1: PACKAGE BODY OE_XML_PROCESS_UTIL AS
2: /* $Header: OEXUPOXB.pls 120.3 2006/02/15 22:42:36 ppnair noship $ */
3:
4: Procedure Concat_Strings(
5: String1 IN VARCHAR2,
28: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
29: --
30: Begin
31: IF l_debug_level > 0 THEN
32: oe_debug_pub.add( 'ENTERING OE_XML_PROCESS_UTIL.GET_SHIP_TO_ORG_ID' ) ;
33: END IF;
34: SELECT site_use_id
35: INTO l_site_use_id
36: FROM hz_cust_site_uses_all a, hz_cust_acct_sites_all b
62: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
63: --
64: Begin
65: IF l_debug_level > 0 THEN
66: oe_debug_pub.add( 'ENTERING OE_XML_PROCESS_UTIL.GET_BILL_TO_ORG_ID' ) ;
67: END IF;
68:
69: SELECT site_use_id
70: INTO l_site_use_id
96: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
97: --
98: Begin
99: IF l_debug_level > 0 THEN
100: oe_debug_pub.add( 'ENTERING OE_XML_PROCESS_UTIL.GET_SOLD_TO_ORG_ID' ) ;
101: END IF;
102:
103: SELECT cust_account_id
104: INTO l_sold_to_org_id
128: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
129: --
130: Begin
131: IF l_debug_level > 0 THEN
132: oe_debug_pub.add( 'ENTERING OE_XML_PROCESS_UTIL.GET_SOLD_TO_EDI_LOC' ) ;
133: END IF;
134:
135: Select /* MOAC_SQL_CHANGE */ a.ece_tp_location_code, c.party_name
136: Into x_edi_location_code, x_sold_to_name
145: And a.cust_account_id = d.cust_account_id
146: And d.party_id = c.party_id;
147:
148: IF l_debug_level > 0 THEN
149: oe_debug_pub.add( 'EXITING OE_XML_PROCESS_UTIL.GET_SOLD_TO_EDI_LOC' ) ;
150: END IF;
151: Exception
152: When Others Then
153: x_edi_location_code := Null;
322: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
323: --
324: Begin
325: IF l_debug_level > 0 THEN
326: oe_debug_pub.add( 'ENTERING OE_XML_PROCESS_UTIL.GET_SHIP_FROM_EDI_LOC' ) ;
327: END IF;
328:
329: Select hl.ece_tp_location_code
330: Into x_edi_location_code
528: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
529: --
530: Begin
531: IF l_debug_level > 0 THEN
532: oe_debug_pub.add( 'ENTERING OE_XML_PROCESS_UTIL.GET_SALES_PERSON' ) ;
533: END IF;
534: x_salesrep := Oe_Id_To_Value.Salesrep(p_salesrep_id => p_salesrep_id);
535:
536: Exception
560: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
561: --
562: Begin
563: IF l_debug_level > 0 THEN
564: oe_debug_pub.add( 'ENTERING OE_XML_PROCESS_UTIL.GET_LINE_ORDERED_QUANTITY' ) ;
565: END IF;
566:
567: If OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL >= '110510' Then
568: fnd_profile.get('ONT_INCLUDE_CUST_IN_OI_KEY', l_customer_key_profile);
614: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
615: --
616: Begin
617: IF l_debug_level > 0 THEN
618: oe_debug_pub.add( 'ENTERING OE_XML_PROCESS_UTIL.GET_LINE_ORDERED_QUANTITY_UOM' ) ;
619: END IF;
620:
621:
622: If OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL >= '110510' Then
669: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
670: --
671: begin
672: IF l_debug_level > 0 THEN
673: oe_debug_pub.add( 'ENTERING OE_XML_PROCESS_UTIL.SET_CANCELLED_FLAG' ) ;
674: END IF;
675:
676:
677:
1004: END IF;
1005:
1006: END Process_Response_Reject;
1007:
1008: END OE_XML_PROCESS_UTIL;