DBA Data[Home] [Help]

APPS.OE_ORDER_IMPORT_PVT dependencies on OE_GLOBALS

Line 40: l_control_rec OE_Globals.Control_Rec_Type;

36: ,p_return_status OUT NOCOPY VARCHAR2
37: ,p_validate_desc_flex in varchar2 default 'Y' -- bug4343612
38: ) IS
39:
40: l_control_rec OE_Globals.Control_Rec_Type;
41:
42: l_header_adj_rec OE_Order_Pub.Header_Adj_Rec_Type;
43: l_header_scredit_rec OE_Order_Pub.Header_Scredit_Rec_Type;
44: l_header_payment_rec OE_Order_Pub.Header_payment_Rec_Type;

Line 175: l_api_service_level VARCHAR2(30) := OE_GLOBALS.G_ALL_SERVICE;

171: l_init_msg_list VARCHAR2(1) := p_init_msg_list;
172: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
173: l_return_values VARCHAR2(1) := FND_API.G_FALSE;
174: l_commit VARCHAR2(1) := FND_API.G_FALSE;
175: l_api_service_level VARCHAR2(30) := OE_GLOBALS.G_ALL_SERVICE;
176:
177: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
178: l_return_status_oi_pre VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
179: l_return_status_oi_pst VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 447: , nvl(operation_code, OE_GLOBALS.G_OPR_CREATE)

443: , nvl(global_attribute19, FND_API.G_MISS_CHAR)
444: , nvl(global_attribute20, FND_API.G_MISS_CHAR)
445: , request_id
446: , NVL(request_date, FND_API.G_MISS_DATE)
447: , nvl(operation_code, OE_GLOBALS.G_OPR_CREATE)
448: , nvl(ready_flag, 'Y')
449: , nvl(status_flag, '0')
450: , nvl(force_apply_flag, 'N')
451: , nvl(change_reason, FND_API.G_MISS_CHAR)

Line 611: , nvl(operation_code, OE_GLOBALS.G_OPR_CREATE)

607: , nvl(attribute13, FND_API.G_MISS_CHAR)
608: , nvl(attribute14, FND_API.G_MISS_CHAR)
609: , nvl(attribute15, FND_API.G_MISS_CHAR)
610: , request_id
611: , nvl(operation_code, OE_GLOBALS.G_OPR_CREATE)
612: , nvl(status_flag, FND_API.G_MISS_CHAR)
613: -- Price Adjustment related changes bug# 1220921 (Start)
614: , nvl( AC_CONTEXT, FND_API.G_MISS_CHAR)
615: , nvl( AC_ATTRIBUTE1, FND_API.G_MISS_CHAR)

Line 810: , nvl(operation_code , OE_GLOBALS.G_OPR_CREATE)

806: , nvl(attribute12 , FND_API.G_MISS_CHAR)
807: , nvl(attribute13 , FND_API.G_MISS_CHAR)
808: , nvl(attribute14 , FND_API.G_MISS_CHAR)
809: , nvl(attribute15 , FND_API.G_MISS_CHAR)
810: , nvl(operation_code , OE_GLOBALS.G_OPR_CREATE)
811: FROM oe_price_atts_iface_all
812: WHERE order_source_id = l_order_source_id
813: AND orig_sys_document_ref = l_orig_sys_document_ref
814: AND nvl(sold_to_org_id, FND_API.G_MISS_NUM)

Line 859: , nvl(operation_code, OE_GLOBALS.G_OPR_CREATE)

855: , nvl(attribute12, FND_API.G_MISS_CHAR)
856: , nvl(attribute13, FND_API.G_MISS_CHAR)
857: , nvl(attribute14, FND_API.G_MISS_CHAR)
858: , nvl(attribute15, FND_API.G_MISS_CHAR)
859: , nvl(operation_code, OE_GLOBALS.G_OPR_CREATE)
860: , nvl(status_flag, FND_API.G_MISS_CHAR)
861: , nvl(change_reason, FND_API.G_MISS_CHAR)
862: , nvl(change_comments, FND_API.G_MISS_CHAR)
863: FROM oe_credits_iface_all

Line 932: , nvl(operation_code, OE_GLOBALS.G_OPR_CREATE)

928: , nvl(attribute12, FND_API.G_MISS_CHAR)
929: , nvl(attribute13, FND_API.G_MISS_CHAR)
930: , nvl(attribute14, FND_API.G_MISS_CHAR)
931: , nvl(attribute15, FND_API.G_MISS_CHAR)
932: , nvl(operation_code, OE_GLOBALS.G_OPR_CREATE)
933: , nvl(status_flag, FND_API.G_MISS_CHAR)
934: , nvl(payment_number, FND_API.G_MISS_NUM)
935: , nvl(header_id, FND_API.G_MISS_NUM)
936: , nvl(line_id, FND_API.G_MISS_NUM)

Line 1246: , nvl(operation_code, OE_GLOBALS.G_OPR_CREATE)

1242: , nvl(return_attribute13, FND_API.G_MISS_CHAR)
1243: , nvl(return_attribute14, FND_API.G_MISS_CHAR)
1244: , nvl(return_attribute15, FND_API.G_MISS_CHAR)
1245: , request_id
1246: , nvl(operation_code, OE_GLOBALS.G_OPR_CREATE)
1247: , nvl(status_flag, FND_API.G_MISS_CHAR)
1248: , nvl(change_reason, FND_API.G_MISS_CHAR)
1249: , nvl(change_comments, FND_API.G_MISS_CHAR)
1250: , nvl(service_txn_reason_code, FND_API.G_MISS_CHAR)

Line 1427: , nvl(operation_code, OE_GLOBALS.G_OPR_CREATE)

1423: , nvl(attribute13, FND_API.G_MISS_CHAR)
1424: , nvl(attribute14, FND_API.G_MISS_CHAR)
1425: , nvl(attribute15, FND_API.G_MISS_CHAR)
1426: , request_id
1427: , nvl(operation_code, OE_GLOBALS.G_OPR_CREATE)
1428: , nvl(status_flag, FND_API.G_MISS_CHAR)
1429: -- Price Adjustment related changes bug# 1220921 (Start)
1430: , nvl( AC_CONTEXT, FND_API.G_MISS_CHAR)
1431: , nvl( AC_ATTRIBUTE1, FND_API.G_MISS_CHAR)

Line 1624: , nvl(operation_code , OE_GLOBALS.G_OPR_CREATE)

1620: , nvl(attribute12 , FND_API.G_MISS_CHAR)
1621: , nvl(attribute13 , FND_API.G_MISS_CHAR)
1622: , nvl(attribute14 , FND_API.G_MISS_CHAR)
1623: , nvl(attribute15 , FND_API.G_MISS_CHAR)
1624: , nvl(operation_code , OE_GLOBALS.G_OPR_CREATE)
1625: FROM oe_price_atts_iface_all
1626: WHERE order_source_id = l_order_source_id
1627: AND orig_sys_document_ref = l_orig_sys_document_ref
1628: AND nvl(sold_to_org_id, FND_API.G_MISS_NUM)

Line 1672: , nvl(operation_code, OE_GLOBALS.G_OPR_CREATE)

1668: , nvl(attribute12, FND_API.G_MISS_CHAR)
1669: , nvl(attribute13, FND_API.G_MISS_CHAR)
1670: , nvl(attribute14, FND_API.G_MISS_CHAR)
1671: , nvl(attribute15, FND_API.G_MISS_CHAR)
1672: , nvl(operation_code, OE_GLOBALS.G_OPR_CREATE)
1673: , nvl(status_flag, FND_API.G_MISS_CHAR)
1674: , nvl(change_reason, FND_API.G_MISS_CHAR)
1675: , nvl(change_comments, FND_API.G_MISS_CHAR)
1676: FROM oe_credits_iface_all

Line 1744: , nvl(operation_code, OE_GLOBALS.G_OPR_CREATE)

1740: , nvl(attribute12, FND_API.G_MISS_CHAR)
1741: , nvl(attribute13, FND_API.G_MISS_CHAR)
1742: , nvl(attribute14, FND_API.G_MISS_CHAR)
1743: , nvl(attribute15, FND_API.G_MISS_CHAR)
1744: , nvl(operation_code, OE_GLOBALS.G_OPR_CREATE)
1745: , nvl(status_flag, FND_API.G_MISS_CHAR)
1746: , nvl(payment_number, FND_API.G_MISS_NUM)
1747: , nvl(header_id, FND_API.G_MISS_NUM)
1748: , nvl(line_id, FND_API.G_MISS_NUM)

Line 1796: , nvl(operation_code, OE_GLOBALS.G_OPR_CREATE)

1792: , nvl(attribute12, FND_API.G_MISS_CHAR)
1793: , nvl(attribute13, FND_API.G_MISS_CHAR)
1794: , nvl(attribute14, FND_API.G_MISS_CHAR)
1795: , nvl(attribute15, FND_API.G_MISS_CHAR)
1796: , nvl(operation_code, OE_GLOBALS.G_OPR_CREATE)
1797: , nvl(status_flag, FND_API.G_MISS_CHAR)
1798: FROM oe_lotserials_iface_all
1799: WHERE order_source_id = l_order_source_id
1800: AND orig_sys_document_ref = l_orig_sys_document_ref

Line 1849: , nvl(operation_code, OE_GLOBALS.G_OPR_CREATE)

1845: , attribute12
1846: , attribute13
1847: , attribute14
1848: , attribute15
1849: , nvl(operation_code, OE_GLOBALS.G_OPR_CREATE)
1850: FROM oe_reservtns_iface_all
1851: WHERE order_source_id = l_order_source_id
1852: AND orig_sys_document_ref = l_orig_sys_document_ref
1853: AND nvl(sold_to_org_id, FND_API.G_MISS_NUM)

Line 2503: OE_GLOBALS.G_XML_TXN_CODE := NULL;

2499: l_sold_to_org.
2500:
2501: */
2502: -- bug 3392678
2503: OE_GLOBALS.G_XML_TXN_CODE := NULL;
2504: IF l_header_rec.order_source_id = OE_Acknowledgment_Pub.G_XML_ORDER_SOURCE_ID
2505: AND nvl(l_header_rec.xml_transaction_type_code, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
2506: OE_GLOBALS.G_XML_TXN_CODE := l_header_rec.xml_transaction_type_code;
2507: IF l_debug_level > 0 THEN

Line 2506: OE_GLOBALS.G_XML_TXN_CODE := l_header_rec.xml_transaction_type_code;

2502: -- bug 3392678
2503: OE_GLOBALS.G_XML_TXN_CODE := NULL;
2504: IF l_header_rec.order_source_id = OE_Acknowledgment_Pub.G_XML_ORDER_SOURCE_ID
2505: AND nvl(l_header_rec.xml_transaction_type_code, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
2506: OE_GLOBALS.G_XML_TXN_CODE := l_header_rec.xml_transaction_type_code;
2507: IF l_debug_level > 0 THEN
2508: oe_debug_pub.add( 'SET GLOBAL TXN CODE TO '||OE_GLOBALS.G_XML_TXN_CODE ) ;
2509: END IF;
2510: END IF;

Line 2508: oe_debug_pub.add( 'SET GLOBAL TXN CODE TO '||OE_GLOBALS.G_XML_TXN_CODE ) ;

2504: IF l_header_rec.order_source_id = OE_Acknowledgment_Pub.G_XML_ORDER_SOURCE_ID
2505: AND nvl(l_header_rec.xml_transaction_type_code, FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
2506: OE_GLOBALS.G_XML_TXN_CODE := l_header_rec.xml_transaction_type_code;
2507: IF l_debug_level > 0 THEN
2508: oe_debug_pub.add( 'SET GLOBAL TXN CODE TO '||OE_GLOBALS.G_XML_TXN_CODE ) ;
2509: END IF;
2510: END IF;
2511:
2512: IF l_header_rec.order_source_id NOT IN (OE_Acknowledgment_Pub.G_XML_ORDER_SOURCE_ID,

Line 2513: OE_Globals.G_ORDER_SOURCE_EDI)

2509: END IF;
2510: END IF;
2511:
2512: IF l_header_rec.order_source_id NOT IN (OE_Acknowledgment_Pub.G_XML_ORDER_SOURCE_ID,
2513: OE_Globals.G_ORDER_SOURCE_EDI)
2514: AND l_header_rec.xml_message_id IS NULL THEN
2515: SELECT oe_xml_message_seq_s.nextval
2516: INTO l_header_rec.xml_message_id
2517: FROM DUAL;

Line 3071: l_action_request_rec.entity_code := OE_Globals.G_ENTITY_HEADER;

3067: ;
3068: EXIT WHEN l_action_request_header_cursor%NOTFOUND;
3069: l_action_request_rec.request_type := l_action_rec.operation_code;
3070:
3071: l_action_request_rec.entity_code := OE_Globals.G_ENTITY_HEADER;
3072: --l_action_request_rec.entity_id := l_header_rec_new.header_id;
3073:
3074: IF l_debug_level > 0 THEN
3075: oe_debug_pub.add( 'ACTION CODE: '|| L_ACTION_REQUEST_REC.REQUEST_TYPE , 1 ) ;

Line 3082: IF l_action_rec.operation_code = OE_Globals.G_APPLY_HOLD THEN

3078:
3079: oe_debug_pub.add( 'ENTITY ID : '|| L_ACTION_REQUEST_REC.ENTITY_ID , 1 ) ;
3080: END IF;
3081:
3082: IF l_action_rec.operation_code = OE_Globals.G_APPLY_HOLD THEN
3083: l_action_request_rec.param1 := l_action_rec.hold_id;
3084: l_action_request_rec.param2 := nvl(l_action_rec.hold_type_code,'O');
3085: l_action_request_rec.param3 := nvl(l_action_rec.hold_type_id,
3086: l_action_request_rec.entity_id);

Line 3116: ELSIF l_action_rec.operation_code = OE_Globals.G_RELEASE_HOLD THEN

3112:
3113: oe_debug_pub.add( 'PARAM4/HOLD_CMNTS: ' || L_ACTION_REQUEST_REC.PARAM4 , 1 ) ;
3114: END IF;
3115:
3116: ELSIF l_action_rec.operation_code = OE_Globals.G_RELEASE_HOLD THEN
3117: l_action_request_rec.param1 := l_action_rec.hold_id;
3118: l_action_request_rec.param2 := nvl(l_action_rec.hold_type_code,'O');
3119: l_action_request_rec.param3 := nvl(l_action_rec.hold_type_id,
3120: l_action_request_rec.entity_id);

Line 3137: ELSIF l_action_rec.operation_code = OE_Globals.G_ACCEPT_FULFILLMENT OR l_action_rec.operation_code = OE_Globals.G_REJECT_FULFILLMENT THEN

3133: oe_debug_pub.add( 'PARAM5/REL_COMMNTS: '|| L_ACTION_REQUEST_REC.PARAM5 , 1 ) ;
3134: END IF;
3135:
3136: --myerrams, introduced the following check for Customer Acceptance.
3137: ELSIF l_action_rec.operation_code = OE_Globals.G_ACCEPT_FULFILLMENT OR l_action_rec.operation_code = OE_Globals.G_REJECT_FULFILLMENT THEN
3138: IF (OE_SYS_PARAMETERS.VALUE('ENABLE_FULFILLMENT_ACCEPTANCE',p_org_id) = 'Y')
3139: THEN
3140: -- Customer Comments
3141: l_action_request_rec.param1 := l_action_rec.char_param1;

Line 4594: (l_action_rec.operation_code = OE_GLOBALS.G_ADD_FULFILLMENT_SET OR

4590:
4591: l_action_request_rec.request_type := l_action_rec.operation_code;
4592:
4593: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' AND
4594: (l_action_rec.operation_code = OE_GLOBALS.G_ADD_FULFILLMENT_SET OR
4595: l_action_rec.operation_code = OE_GLOBALS.G_REMOVE_FULFILLMENT_SET) THEN
4596:
4597: l_action_request_rec.param5 := l_action_rec.fulfillment_set_name;
4598: END IF;

Line 4595: l_action_rec.operation_code = OE_GLOBALS.G_REMOVE_FULFILLMENT_SET) THEN

4591: l_action_request_rec.request_type := l_action_rec.operation_code;
4592:
4593: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' AND
4594: (l_action_rec.operation_code = OE_GLOBALS.G_ADD_FULFILLMENT_SET OR
4595: l_action_rec.operation_code = OE_GLOBALS.G_REMOVE_FULFILLMENT_SET) THEN
4596:
4597: l_action_request_rec.param5 := l_action_rec.fulfillment_set_name;
4598: END IF;
4599:

Line 4600: l_action_request_rec.entity_code := OE_Globals.G_ENTITY_LINE;

4596:
4597: l_action_request_rec.param5 := l_action_rec.fulfillment_set_name;
4598: END IF;
4599:
4600: l_action_request_rec.entity_code := OE_Globals.G_ENTITY_LINE;
4601: l_action_request_rec.entity_index := l_line_count;
4602:
4603: IF l_debug_level > 0 THEN
4604: oe_debug_pub.add( 'ACTION CODE: '|| L_ACTION_REQUEST_REC.REQUEST_TYPE , 1 ) ;

Line 4611: IF l_action_rec.operation_code = OE_Globals.G_APPLY_HOLD THEN

4607:
4608: oe_debug_pub.add( 'ENTITY ID : '|| L_ACTION_REQUEST_REC.ENTITY_ID , 1 ) ;
4609: END IF;
4610:
4611: IF l_action_rec.operation_code = OE_Globals.G_APPLY_HOLD THEN
4612: l_action_request_rec.param1 := l_action_rec.hold_id;
4613: l_action_request_rec.param2 := nvl(l_action_rec.hold_type_code,'O');
4614: l_action_request_rec.param3 := nvl(l_action_rec.hold_type_id,
4615: l_action_request_rec.entity_id);

Line 4645: ELSIF l_action_rec.operation_code = OE_Globals.G_RELEASE_HOLD THEN

4641:
4642: oe_debug_pub.add( 'PARAM4/HOLD_CMNTS: ' || L_ACTION_REQUEST_REC.PARAM4 , 1 ) ;
4643: END IF;
4644:
4645: ELSIF l_action_rec.operation_code = OE_Globals.G_RELEASE_HOLD THEN
4646: l_action_request_rec.param1 := l_action_rec.hold_id;
4647: l_action_request_rec.param2 := nvl(l_action_rec.hold_type_code,'O');
4648: l_action_request_rec.param3 := nvl(l_action_rec.hold_type_id,
4649: l_action_request_rec.entity_id);

Line 4666: ELSIF l_action_rec.operation_code = OE_Globals.G_ACCEPT_FULFILLMENT OR l_action_rec.operation_code = OE_Globals.G_REJECT_FULFILLMENT THEN

4662: oe_debug_pub.add( 'PARAM5/REL_COMMNTS: '|| L_ACTION_REQUEST_REC.PARAM5 , 1 ) ;
4663: END IF;
4664:
4665: --myerrams, introduced the following check for Customer Acceptance.
4666: ELSIF l_action_rec.operation_code = OE_Globals.G_ACCEPT_FULFILLMENT OR l_action_rec.operation_code = OE_Globals.G_REJECT_FULFILLMENT THEN
4667: IF (OE_SYS_PARAMETERS.VALUE('ENABLE_FULFILLMENT_ACCEPTANCE',p_org_id) = 'Y')
4668: THEN
4669: -- Customer Comments
4670: l_action_request_rec.param1 := l_action_rec.char_param1;

Line 4824: l_api_service_level := OE_GLOBALS.G_VALIDATION_ONLY;

4820: -- aksingh
4821: IF l_debug_level > 0 THEN
4822: oe_debug_pub.add( 'SETTTING L_API_SERVICE_LEVEL TO VALIDATE_ONLY' ) ;
4823: END IF;
4824: l_api_service_level := OE_GLOBALS.G_VALIDATION_ONLY;
4825: -- Following is added to fix the bug# 1267887
4826: -- It will allow the processing of all the line if API is called in
4827: -- validate only mode
4828: -- l_control_rec.process_partial := TRUE;

Line 4865: OE_GLOBALS.G_FAIL_ORDER_IMPORT := FALSE; /* Bug # 4036765 */

4861: oe_debug_pub.add('action table old count = '|| l_action_request_tbl_old.count);
4862:
4863: End If;
4864:
4865: OE_GLOBALS.G_FAIL_ORDER_IMPORT := FALSE; /* Bug # 4036765 */
4866:
4867: OE_GLOBALS.G_ORDER_IMPORT_CALL := TRUE; -- Bug 7367433
4868:
4869: OE_Order_Grp.Process_Order(

Line 4867: OE_GLOBALS.G_ORDER_IMPORT_CALL := TRUE; -- Bug 7367433

4863: End If;
4864:
4865: OE_GLOBALS.G_FAIL_ORDER_IMPORT := FALSE; /* Bug # 4036765 */
4866:
4867: OE_GLOBALS.G_ORDER_IMPORT_CALL := TRUE; -- Bug 7367433
4868:
4869: OE_Order_Grp.Process_Order(
4870: p_api_version_number => 1
4871: ,p_init_msg_list => l_init_msg_list

Line 4958: OE_GLOBALS.G_ORDER_IMPORT_CALL := FALSE; -- Bug 7367433

4954: ,x_msg_data => p_msg_data
4955: ,p_validate_desc_flex => p_validate_desc_flex --bug 4343612
4956: );
4957:
4958: OE_GLOBALS.G_ORDER_IMPORT_CALL := FALSE; -- Bug 7367433
4959:
4960: -- For Actions call is directly made to delayed request
4961: -- Process_Order_Action, which is changed from the calling
4962: -- process_order group appi twice

Line 4972: IF OE_GLOBALS.G_FAIL_ORDER_IMPORT THEN

4968: oe_debug_pub.add( 'PROCESS_ORDER RETURN STATUS BEFORE ACTION : '||L_RETURN_STATUS_PO , 1 ) ;
4969: END IF;
4970:
4971: /* Bug # 4036765 */
4972: IF OE_GLOBALS.G_FAIL_ORDER_IMPORT THEN
4973: IF l_debug_level > 0 THEN
4974: oe_debug_pub.add( 'G_FAIL_ORDER_IMPORT WAS SET TO TRUE. SETTING PROCESS_ORDER RETURN STATUS TO FAILURE' , 1 ) ;
4975: END IF;
4976: l_return_status_po := FND_API.G_RET_STS_ERROR;

Line 5236: IF nvl(OE_GLOBALS.G_PAYMENT_PROCESSED, 'N') = 'O' THEN

5232: -- For Bug 7367433
5233: -- From Order Import we will make a call to Verfify Payment, only after committing the data.
5234: -- The call to Verify Payment from Booking code is suppressed for Order Import flow.
5235: -- This change is only for Verify Payment call that is triggered as part of Booking.
5236: IF nvl(OE_GLOBALS.G_PAYMENT_PROCESSED, 'N') = 'O' THEN
5237: BEGIN
5238: SAVEPOINT VERIFY_PAYMENT;
5239:
5240: if l_debug_level > 5 then

Line 5793: OE_GLOBALS.G_XML_TXN_CODE := NULL;

5789: -- This should only be raised when the profile is set to ASYNCHRONOUS
5790:
5791: -- {Start If for raising event for XML Trans
5792: If l_header_rec.order_source_id = Oe_Acknowledgment_Pub.G_XML_ORDER_SOURCE_ID Then
5793: OE_GLOBALS.G_XML_TXN_CODE := NULL;
5794: IF l_debug_level > 0 THEN
5795: oe_debug_pub.add( 'SET GLOBAL TXN CODE TO NULL' ) ;
5796: END IF;
5797:

Line 5882: OE_GLOBALS.G_ORDER_IMPORT_CALL := FALSE; -- Bug 7367433

5878: END IF;
5879: p_msg_count := p_msg_count + 1;
5880: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5881:
5882: OE_GLOBALS.G_ORDER_IMPORT_CALL := FALSE; -- Bug 7367433
5883:
5884: END IMPORT_ORDER;
5885:
5886: END OE_ORDER_IMPORT_PVT;