[Home] [Help]
96: oe_debug_pub.add( 'ENTERING OEXPACKB GET_HEADER_ID' ) ;
97: END IF;
98:
99: If OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL >= '110510' Then
100: fnd_profile.get('ONT_INCLUDE_CUST_IN_OI_KEY', l_customer_key_profile);
101: l_customer_key_profile := nvl(l_customer_key_profile, 'N');
102: IF l_debug_level > 0 THEN
103: oe_debug_pub.add( 'CUSTOMER KEY PROFILE SETTING = '||l_customer_key_profile ) ;
104: END IF;
950:
951:
952:
953: If OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL >= '110510' Then
954: fnd_profile.get('ONT_INCLUDE_CUST_IN_OI_KEY', l_customer_key_profile);
955: l_customer_key_profile := nvl(l_customer_key_profile, 'N');
956: IF l_debug_level > 0 THEN
957: oe_debug_pub.add( 'CUSTOMER KEY PROFILE SETTING = '||l_customer_key_profile ) ;
958: END IF;
1166: END IF;
1167: l_acknowledgment_type := p_transaction_type;
1168:
1169: If OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL >= '110510' Then
1170: fnd_profile.get('ONT_INCLUDE_CUST_IN_OI_KEY', l_customer_key_profile);
1171: l_customer_key_profile := nvl(l_customer_key_profile, 'N');
1172: IF l_debug_level > 0 THEN
1173: oe_debug_pub.add( 'CUSTOMER KEY PROFILE SETTING = '||l_customer_key_profile ) ;
1174: END IF;
1840: );
1841: IF l_is_delivery_required_cso = 'Y' THEN
1842: -- populate profile only if 3a7 is set up, this will need to change if we start
1843: -- supporting holds via 3a6 also
1844: l_cso_response_profile := nvl(FND_PROFILE.VALUE ('ONT_3A7_RESPONSE_REQUIRED'), 'N');
1845: END IF;
1846: IF l_debug_level > 0 THEN
1847: oe_debug_pub.add( 'OEXPACKB: is delivery required for 3a7 = ' || l_is_delivery_required_cso ) ;
1848: oe_debug_pub.add( 'OEXPACKB: fetched CSO Response Required profile ' || l_cso_response_profile) ;
1933: -- (barring any notification issues). Thus, if the XML orders accept state profile
1934: -- is set to 'BOOKED' then we have a change from 'Pending' to 'Accept' and thus
1935: -- need to send a 3A7, otherwise we turn off 3a7
1936: IF l_is_delivery_required_cso = 'Y' THEN
1937: IF nvl(FND_PROFILE.VALUE('ONT_XML_ACCEPT_STATE'), 'ENTERED') = 'ENTERED' THEN
1938: l_header_req_cso := 'N'; -- i.e. 3a7 not sent on Booking if accept state is Entered,
1939: -- unless of course there are line_changes (handled later)
1940: ELSIF nvl(OE_GLOBALS.G_XML_TXN_CODE, G_TRANSACTION_CSO) = G_TRANSACTION_POI THEN
1941: l_header_req_cso := 'N'; -- i.e. don't send 3a7 if order is booked by buyer
2766: l_msg_count NUMBER := 0 ;
2767: l_msg_data VARCHAR2(2000):= NULL ;
2768: l_message_text VARCHAR2(2000);
2769:
2770: --l_debug_level NUMBER := to_number(nvl(fnd_profile.value('ONT_DEBUG_LEVEL'),'0'));
2771: l_filename VARCHAR2(200);
2772: l_request_id NUMBER;
2773: l_org_id NUMBER;
2774: l_order_rec Order_Rec_Type;
2856:
2857: IF l_debug_level > 0 THEN
2858: oe_debug_pub.add( 'BEFORE GETTING REQUEST ID' ) ;
2859: END IF;
2860: fnd_profile.get('CONC_REQUEST_ID', l_request_id);
2861: IF l_debug_level > 0 THEN
2862: oe_debug_pub.add( 'REQUEST ID: '|| TO_CHAR ( L_REQUEST_ID ) ) ;
2863: END IF;
2864: fnd_file.put_line(FND_FILE.OUTPUT, 'Request Id: '|| to_char(l_request_id));
3011: i NUMBER;
3012: l_org_id NUMBER := p_org_id;
3013: l_conc_request_id NUMBER := p_conc_request_id;
3014: l_response_flag VARCHAR2(1) := p_response_flag;
3015: l_integ_profile VARCHAR2(10) := nvl (FND_PROFILE.VALUE ('ONT_EM_INTEG_SOURCES'), 'XML');
3016: l_customer_key_profile VARCHAR2(1) := 'N';
3017: l_failure_ack_flag VARCHAR2(1) := nvl(p_failure_ack_flag, 'N');
3018: l_order_processed_flag VARCHAR2(1) := 'Y';
3019:
3127: -----------------------------------------------------------
3128: IF OE_Code_Control.Code_Release_Level >= '110510' THEN
3129: IF l_processing_stage = 'IMPORT_FAILURE' THEN
3130: IF p_order_source_id = 20 AND l_transaction_subtype IN (G_TRANSACTION_CHO, G_TRANSACTION_CPO) THEN
3131: fnd_profile.get('ONT_INCLUDE_CUST_IN_OI_KEY', l_customer_key_profile);
3132: l_customer_key_profile := nvl(l_customer_key_profile, 'N');
3133:
3134: Begin
3135: Select order_number, order_type_id, header_id