[Home] [Help]
100: IF l_debug_level > 0 THEN
101: oe_debug_pub.add( 'ENTERING OEXPACKB GET_HEADER_ID' ) ;
102: END IF;
103:
104: If OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL >= '110510' Then
105: fnd_profile.get('ONT_INCLUDE_CUST_IN_OI_KEY', l_customer_key_profile);
106: l_customer_key_profile := nvl(l_customer_key_profile, 'N');
107: IF l_debug_level > 0 THEN
108: oe_debug_pub.add( 'CUSTOMER KEY PROFILE SETTING = '||l_customer_key_profile ) ;
202: IF l_debug_level > 0 THEN
203: oe_debug_pub.add( 'L_START_FROM_FLOW = '||L_START_FROM_FLOW ) ;
204: END IF;
205:
206: IF OE_Code_Control.Code_Release_Level >= '110510' THEN
207: IF p_check_for_delivery = 'Y' THEN
208: OE_Acknowledgment_Pub.Is_Delivery_Required
209: (
210: p_customer_id => p_sold_to_org_id,
229: oe_debug_pub.add( 'L_ITEMKEY = '||L_ITEMKEY || ' ORG ID passed in is ' || p_org_id ) ;
230: END IF;
231:
232:
233: If OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL >= '110510' Then
234: l_user_key := p_orig_sys_document_ref || ',' || to_char(p_sold_to_org_id) || ',' || p_change_sequence || ',' || p_transaction_type;
235: Else
236: l_user_key := p_orig_sys_document_ref || ',' || to_char(p_sold_to_org_id) || ',' || p_transaction_type;
237: End If;
466: IF l_debug_level > 0 THEN
467: oe_debug_pub.add( 'start_from_flow:' || l_itemtype) ;
468: END IF;
469:
470: IF OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL >= '110510' THEN
471: IF l_itemtype = OE_ORDER_IMPORT_WF.G_WFI_CONC_PGM THEN
472: wf_event.AddParameterToList(p_name=> 'REQ_ID',
473: p_value=> p_request_id,
474: p_parameterlist=> l_parameter_list);
954: END IF;
955:
956:
957:
958: If OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL >= '110510' Then
959: fnd_profile.get('ONT_INCLUDE_CUST_IN_OI_KEY', l_customer_key_profile);
960: l_customer_key_profile := nvl(l_customer_key_profile, 'N');
961: IF l_debug_level > 0 THEN
962: oe_debug_pub.add( 'CUSTOMER KEY PROFILE SETTING = '||l_customer_key_profile ) ;
1170: oe_debug_pub.add( 'OEXPACKB: ENTERING PROCESS_XML_ACKNOWLEDGMENT' ) ;
1171: END IF;
1172: l_acknowledgment_type := p_transaction_type;
1173:
1174: If OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL >= '110510' Then
1175: fnd_profile.get('ONT_INCLUDE_CUST_IN_OI_KEY', l_customer_key_profile);
1176: l_customer_key_profile := nvl(l_customer_key_profile, 'N');
1177: IF l_debug_level > 0 THEN
1178: oe_debug_pub.add( 'CUSTOMER KEY PROFILE SETTING = '||l_customer_key_profile ) ;
1838: x_is_delivery_required => l_is_delivery_required,
1839: x_return_status => l_return_status
1840: );
1841:
1842: If (OE_Code_Control.code_release_level >= '110510') Then
1843:
1844: Is_Delivery_Required( p_customer_id => l_header_rec.sold_to_org_id,
1845: p_transaction_type => 'ONT',
1846: p_transaction_subtype => G_TRANSACTION_CSO,
2497:
2498: -- start of checking to see if 3A7 hold needs to be applied
2499: -- Note that we only apply a hold if line was not sent in by the buyer
2500: IF l_apply_3a7_hold THEN
2501: IF OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL >= '110510' THEN
2502: IF l_is_delivery_required_cso = 'Y'
2503: AND l_cso_response_profile = 'Y'
2504: AND NOT l_3a7_buyer_line
2505: AND nvl(OE_GLOBALS.G_XML_TXN_CODE, G_TRANSACTION_CSO) <> G_TRANSACTION_POI
2646: oe_debug_pub.add( ' L_LINE_REQ_CSO : ' || L_LINE_REQ_CSO ) ;
2647: oe_debug_pub.add( ' L_LINE_STATUS : ' || L_LINE_STATUS_CSO ) ;
2648: END IF;
2649: If l_is_delivery_required_cso = 'Y' Then
2650: IF OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL >= '110510'
2651: AND l_cso_response_profile = 'Y' THEN
2652: -- Check if Hold already exists on this order line
2653: IF l_debug_level > 0 THEN
2654: oe_debug_pub.add( 'Process SSO: Check If Hold Already Applied' ) ;
3167: FROM dual;
3168:
3169:
3170: -- { begin code release level
3171: IF OE_Code_Control.Code_Release_Level >= '110510' THEN
3172:
3173: If l_subscriber_list <> 'DEFAULT' THEN
3174:
3175: /* error checking primarily to guard against some OI cases where we
3240: END IF; -- } end code release level
3241: -----------------------------------------------------------
3242: -- Non-CLN params
3243: -----------------------------------------------------------
3244: IF OE_Code_Control.Code_Release_Level >= '110510' THEN
3245: IF l_processing_stage = 'IMPORT_FAILURE' THEN
3246: IF p_order_source_id = 20 AND l_transaction_subtype IN (G_TRANSACTION_CHO, G_TRANSACTION_CPO) THEN
3247: fnd_profile.get('ONT_INCLUDE_CUST_IN_OI_KEY', l_customer_key_profile);
3248: l_customer_key_profile := nvl(l_customer_key_profile, 'N');
3360: -- then we need to populate the alternate CLN key
3361: -- of these we populate the XMLG_INTERNAL_TXN_TYPE/SUBTYPE always (as it
3362: -- is part of the key for the history table),
3363: -- the other parameters are added in this code block
3364: IF OE_Code_Control.Code_Release_Level >= '110510' THEN
3365: wf_event.AddParameterToList(p_name=> 'DOCUMENT_DIRECTION',
3366: p_value=> p_document_direction,
3367: p_parameterlist=> l_parameter_list);
3368:
3412: wf_event.AddParameterToList(p_name=> 'MESSAGE_TEXT',
3413: p_value=> l_message_text,
3414: p_parameterlist=> l_parameter_list);
3415:
3416: IF OE_Code_Control.Code_Release_Level >= '110510' THEN
3417: --transaction type
3418: IF l_transaction_subtype = G_TRANSACTION_CBODO THEN
3419: l_transaction_type := 'ECX';
3420: -- begin bug 4179657
3496: oe_debug_pub.add( 'CONVERTED LIST ' || l_converted ) ;
3497: oe_debug_pub.add( 'BEFORE RAISE EVENT oracle.apps.ont.oi.xml_int.status' ) ;
3498: END IF;
3499:
3500: IF OE_Code_Control.Code_Release_Level < '110510' THEN
3501: IF p_order_source_id <> G_XML_ORDER_SOURCE_ID OR
3502: l_processing_stage NOT IN ('IMPORT_SUCCESS', 'OUTBOUND_SENT') OR
3503: l_transaction_subtype = G_TRANSACTION_CBODO THEN
3504: l_parameter_list.DELETE;