63: -- It will also include profile options that do not change
64: -- for a given request_id
65: ------------------------------------------------------------
66:
67: -- Set the globals in OE_BULK_ORDER_PVT using system parameters
68:
69: -- Initialize Request ID Global
70:
71: OE_BULK_ORDER_PVT.G_REQUEST_ID := p_request_id;
67: -- Set the globals in OE_BULK_ORDER_PVT using system parameters
68:
69: -- Initialize Request ID Global
70:
71: OE_BULK_ORDER_PVT.G_REQUEST_ID := p_request_id;
72:
73: -- This ensures that the WF selector functions do not test context.
74:
75: OE_STANDARD_WF.RESET_APPS_CONTEXT_OFF;
77: -- Initialize Global Flex Status
78:
79: IF p_validate_desc_flex = 'Y' THEN
80:
81: OE_BULK_ORDER_PVT.G_OE_HEADER_ATTRIBUTES :=
82: OE_BULK_ORDER_PVT.GET_FLEX_ENABLED_FLAG('OE_HEADER_ATTRIBUTES');
83: OE_BULK_ORDER_PVT.G_OE_HEADER_GLOBAL_ATTRIBUTE :=
84: OE_BULK_ORDER_PVT.GET_FLEX_ENABLED_FLAG('OE_HEADER_GLOBAL_ATTRIBUTE');
85: OE_BULK_ORDER_PVT.G_OE_HEADER_TP_ATTRIBUTES :=
78:
79: IF p_validate_desc_flex = 'Y' THEN
80:
81: OE_BULK_ORDER_PVT.G_OE_HEADER_ATTRIBUTES :=
82: OE_BULK_ORDER_PVT.GET_FLEX_ENABLED_FLAG('OE_HEADER_ATTRIBUTES');
83: OE_BULK_ORDER_PVT.G_OE_HEADER_GLOBAL_ATTRIBUTE :=
84: OE_BULK_ORDER_PVT.GET_FLEX_ENABLED_FLAG('OE_HEADER_GLOBAL_ATTRIBUTE');
85: OE_BULK_ORDER_PVT.G_OE_HEADER_TP_ATTRIBUTES :=
86: OE_BULK_ORDER_PVT.GET_FLEX_ENABLED_FLAG('OE_HEADER_TP_ATTRIBUTES');
79: IF p_validate_desc_flex = 'Y' THEN
80:
81: OE_BULK_ORDER_PVT.G_OE_HEADER_ATTRIBUTES :=
82: OE_BULK_ORDER_PVT.GET_FLEX_ENABLED_FLAG('OE_HEADER_ATTRIBUTES');
83: OE_BULK_ORDER_PVT.G_OE_HEADER_GLOBAL_ATTRIBUTE :=
84: OE_BULK_ORDER_PVT.GET_FLEX_ENABLED_FLAG('OE_HEADER_GLOBAL_ATTRIBUTE');
85: OE_BULK_ORDER_PVT.G_OE_HEADER_TP_ATTRIBUTES :=
86: OE_BULK_ORDER_PVT.GET_FLEX_ENABLED_FLAG('OE_HEADER_TP_ATTRIBUTES');
87:
80:
81: OE_BULK_ORDER_PVT.G_OE_HEADER_ATTRIBUTES :=
82: OE_BULK_ORDER_PVT.GET_FLEX_ENABLED_FLAG('OE_HEADER_ATTRIBUTES');
83: OE_BULK_ORDER_PVT.G_OE_HEADER_GLOBAL_ATTRIBUTE :=
84: OE_BULK_ORDER_PVT.GET_FLEX_ENABLED_FLAG('OE_HEADER_GLOBAL_ATTRIBUTE');
85: OE_BULK_ORDER_PVT.G_OE_HEADER_TP_ATTRIBUTES :=
86: OE_BULK_ORDER_PVT.GET_FLEX_ENABLED_FLAG('OE_HEADER_TP_ATTRIBUTES');
87:
88: OE_BULK_ORDER_PVT.G_OE_LINE_ATTRIBUTES :=
81: OE_BULK_ORDER_PVT.G_OE_HEADER_ATTRIBUTES :=
82: OE_BULK_ORDER_PVT.GET_FLEX_ENABLED_FLAG('OE_HEADER_ATTRIBUTES');
83: OE_BULK_ORDER_PVT.G_OE_HEADER_GLOBAL_ATTRIBUTE :=
84: OE_BULK_ORDER_PVT.GET_FLEX_ENABLED_FLAG('OE_HEADER_GLOBAL_ATTRIBUTE');
85: OE_BULK_ORDER_PVT.G_OE_HEADER_TP_ATTRIBUTES :=
86: OE_BULK_ORDER_PVT.GET_FLEX_ENABLED_FLAG('OE_HEADER_TP_ATTRIBUTES');
87:
88: OE_BULK_ORDER_PVT.G_OE_LINE_ATTRIBUTES :=
89: OE_BULK_ORDER_PVT.GET_FLEX_ENABLED_FLAG('OE_LINE_ATTRIBUTES');
82: OE_BULK_ORDER_PVT.GET_FLEX_ENABLED_FLAG('OE_HEADER_ATTRIBUTES');
83: OE_BULK_ORDER_PVT.G_OE_HEADER_GLOBAL_ATTRIBUTE :=
84: OE_BULK_ORDER_PVT.GET_FLEX_ENABLED_FLAG('OE_HEADER_GLOBAL_ATTRIBUTE');
85: OE_BULK_ORDER_PVT.G_OE_HEADER_TP_ATTRIBUTES :=
86: OE_BULK_ORDER_PVT.GET_FLEX_ENABLED_FLAG('OE_HEADER_TP_ATTRIBUTES');
87:
88: OE_BULK_ORDER_PVT.G_OE_LINE_ATTRIBUTES :=
89: OE_BULK_ORDER_PVT.GET_FLEX_ENABLED_FLAG('OE_LINE_ATTRIBUTES');
90: OE_BULK_ORDER_PVT.G_OE_LINE_INDUSTRY_ATTRIBUTE :=
84: OE_BULK_ORDER_PVT.GET_FLEX_ENABLED_FLAG('OE_HEADER_GLOBAL_ATTRIBUTE');
85: OE_BULK_ORDER_PVT.G_OE_HEADER_TP_ATTRIBUTES :=
86: OE_BULK_ORDER_PVT.GET_FLEX_ENABLED_FLAG('OE_HEADER_TP_ATTRIBUTES');
87:
88: OE_BULK_ORDER_PVT.G_OE_LINE_ATTRIBUTES :=
89: OE_BULK_ORDER_PVT.GET_FLEX_ENABLED_FLAG('OE_LINE_ATTRIBUTES');
90: OE_BULK_ORDER_PVT.G_OE_LINE_INDUSTRY_ATTRIBUTE :=
91: OE_BULK_ORDER_PVT.GET_FLEX_ENABLED_FLAG('OE_LINE_INDUSTRY_ATTRIBUTE');
92: OE_BULK_ORDER_PVT.G_OE_LINE_TP_ATTRIBUTES :=
85: OE_BULK_ORDER_PVT.G_OE_HEADER_TP_ATTRIBUTES :=
86: OE_BULK_ORDER_PVT.GET_FLEX_ENABLED_FLAG('OE_HEADER_TP_ATTRIBUTES');
87:
88: OE_BULK_ORDER_PVT.G_OE_LINE_ATTRIBUTES :=
89: OE_BULK_ORDER_PVT.GET_FLEX_ENABLED_FLAG('OE_LINE_ATTRIBUTES');
90: OE_BULK_ORDER_PVT.G_OE_LINE_INDUSTRY_ATTRIBUTE :=
91: OE_BULK_ORDER_PVT.GET_FLEX_ENABLED_FLAG('OE_LINE_INDUSTRY_ATTRIBUTE');
92: OE_BULK_ORDER_PVT.G_OE_LINE_TP_ATTRIBUTES :=
93: OE_BULK_ORDER_PVT.GET_FLEX_ENABLED_FLAG('OE_LINE_TP_ATTRIBUTES');
86: OE_BULK_ORDER_PVT.GET_FLEX_ENABLED_FLAG('OE_HEADER_TP_ATTRIBUTES');
87:
88: OE_BULK_ORDER_PVT.G_OE_LINE_ATTRIBUTES :=
89: OE_BULK_ORDER_PVT.GET_FLEX_ENABLED_FLAG('OE_LINE_ATTRIBUTES');
90: OE_BULK_ORDER_PVT.G_OE_LINE_INDUSTRY_ATTRIBUTE :=
91: OE_BULK_ORDER_PVT.GET_FLEX_ENABLED_FLAG('OE_LINE_INDUSTRY_ATTRIBUTE');
92: OE_BULK_ORDER_PVT.G_OE_LINE_TP_ATTRIBUTES :=
93: OE_BULK_ORDER_PVT.GET_FLEX_ENABLED_FLAG('OE_LINE_TP_ATTRIBUTES');
94:
87:
88: OE_BULK_ORDER_PVT.G_OE_LINE_ATTRIBUTES :=
89: OE_BULK_ORDER_PVT.GET_FLEX_ENABLED_FLAG('OE_LINE_ATTRIBUTES');
90: OE_BULK_ORDER_PVT.G_OE_LINE_INDUSTRY_ATTRIBUTE :=
91: OE_BULK_ORDER_PVT.GET_FLEX_ENABLED_FLAG('OE_LINE_INDUSTRY_ATTRIBUTE');
92: OE_BULK_ORDER_PVT.G_OE_LINE_TP_ATTRIBUTES :=
93: OE_BULK_ORDER_PVT.GET_FLEX_ENABLED_FLAG('OE_LINE_TP_ATTRIBUTES');
94:
95: END IF;
88: OE_BULK_ORDER_PVT.G_OE_LINE_ATTRIBUTES :=
89: OE_BULK_ORDER_PVT.GET_FLEX_ENABLED_FLAG('OE_LINE_ATTRIBUTES');
90: OE_BULK_ORDER_PVT.G_OE_LINE_INDUSTRY_ATTRIBUTE :=
91: OE_BULK_ORDER_PVT.GET_FLEX_ENABLED_FLAG('OE_LINE_INDUSTRY_ATTRIBUTE');
92: OE_BULK_ORDER_PVT.G_OE_LINE_TP_ATTRIBUTES :=
93: OE_BULK_ORDER_PVT.GET_FLEX_ENABLED_FLAG('OE_LINE_TP_ATTRIBUTES');
94:
95: END IF;
96:
89: OE_BULK_ORDER_PVT.GET_FLEX_ENABLED_FLAG('OE_LINE_ATTRIBUTES');
90: OE_BULK_ORDER_PVT.G_OE_LINE_INDUSTRY_ATTRIBUTE :=
91: OE_BULK_ORDER_PVT.GET_FLEX_ENABLED_FLAG('OE_LINE_INDUSTRY_ATTRIBUTE');
92: OE_BULK_ORDER_PVT.G_OE_LINE_TP_ATTRIBUTES :=
93: OE_BULK_ORDER_PVT.GET_FLEX_ENABLED_FLAG('OE_LINE_TP_ATTRIBUTES');
94:
95: END IF;
96:
97: -- Initialize OE_GLOBALS.g_org_id
135: -- It will also include system parameters that only change
136: -- during the OU change.
137: ------------------------------------------------------------
138:
139: OE_BULK_ORDER_PVT.G_SCHEDULE_LINE_ON_HOLD := OE_Sys_Parameters.value('ONT_SCHEDULE_LINE_ON_HOLD');
140:
141: OE_BULK_ORDER_PVT.G_RESERVATION_TIME_FENCE := OE_Sys_Parameters.value('ONT_RESERVATION_TIME_FENCE');
142:
143: OE_BULK_ORDER_PVT.G_ITEM_ORG := OE_Sys_Parameters.value('MASTER_ORGANIZATION_ID');
137: ------------------------------------------------------------
138:
139: OE_BULK_ORDER_PVT.G_SCHEDULE_LINE_ON_HOLD := OE_Sys_Parameters.value('ONT_SCHEDULE_LINE_ON_HOLD');
140:
141: OE_BULK_ORDER_PVT.G_RESERVATION_TIME_FENCE := OE_Sys_Parameters.value('ONT_RESERVATION_TIME_FENCE');
142:
143: OE_BULK_ORDER_PVT.G_ITEM_ORG := OE_Sys_Parameters.value('MASTER_ORGANIZATION_ID');
144:
145: OE_BULK_ORDER_PVT.G_SOB_ID := OE_Sys_Parameters.value('SET_OF_BOOKS_ID');
139: OE_BULK_ORDER_PVT.G_SCHEDULE_LINE_ON_HOLD := OE_Sys_Parameters.value('ONT_SCHEDULE_LINE_ON_HOLD');
140:
141: OE_BULK_ORDER_PVT.G_RESERVATION_TIME_FENCE := OE_Sys_Parameters.value('ONT_RESERVATION_TIME_FENCE');
142:
143: OE_BULK_ORDER_PVT.G_ITEM_ORG := OE_Sys_Parameters.value('MASTER_ORGANIZATION_ID');
144:
145: OE_BULK_ORDER_PVT.G_SOB_ID := OE_Sys_Parameters.value('SET_OF_BOOKS_ID');
146:
147: OE_BULK_ORDER_PVT.G_CUST_RELATIONS := OE_Sys_Parameters.value('CUSTOMER_RELATIONSHIPS_FLAG');
141: OE_BULK_ORDER_PVT.G_RESERVATION_TIME_FENCE := OE_Sys_Parameters.value('ONT_RESERVATION_TIME_FENCE');
142:
143: OE_BULK_ORDER_PVT.G_ITEM_ORG := OE_Sys_Parameters.value('MASTER_ORGANIZATION_ID');
144:
145: OE_BULK_ORDER_PVT.G_SOB_ID := OE_Sys_Parameters.value('SET_OF_BOOKS_ID');
146:
147: OE_BULK_ORDER_PVT.G_CUST_RELATIONS := OE_Sys_Parameters.value('CUSTOMER_RELATIONSHIPS_FLAG');
148:
149: OE_BULK_ORDER_PVT.G_CUST_RELATIONS := OE_Sys_Parameters.value('CUSTOMER_RELATIONSHIPS_FLAG');
143: OE_BULK_ORDER_PVT.G_ITEM_ORG := OE_Sys_Parameters.value('MASTER_ORGANIZATION_ID');
144:
145: OE_BULK_ORDER_PVT.G_SOB_ID := OE_Sys_Parameters.value('SET_OF_BOOKS_ID');
146:
147: OE_BULK_ORDER_PVT.G_CUST_RELATIONS := OE_Sys_Parameters.value('CUSTOMER_RELATIONSHIPS_FLAG');
148:
149: OE_BULK_ORDER_PVT.G_CUST_RELATIONS := OE_Sys_Parameters.value('CUSTOMER_RELATIONSHIPS_FLAG');
150:
151:
145: OE_BULK_ORDER_PVT.G_SOB_ID := OE_Sys_Parameters.value('SET_OF_BOOKS_ID');
146:
147: OE_BULK_ORDER_PVT.G_CUST_RELATIONS := OE_Sys_Parameters.value('CUSTOMER_RELATIONSHIPS_FLAG');
148:
149: OE_BULK_ORDER_PVT.G_CUST_RELATIONS := OE_Sys_Parameters.value('CUSTOMER_RELATIONSHIPS_FLAG');
150:
151:
152: ----------------------------------------------------------
153: -- Load Hold Sources into globals
662: END LOOP;
663:
664: if p_debug_level >0 then
665: oe_debug_pub.add('process recs with no org '||p_process_recs_with_no_org);
666: oe_debug_pub.add('G_CONFIG_EFFECT_DATE'||OE_BULK_ORDER_PVT.G_CONFIG_EFFECT_DATE);
667: end if;
668: --End bug 4685432
669:
670: -----------------------------------------------------------
1272: If p_debug_level > 0 Then
1273: oe_debug_pub.add(' Calling Process Batch with process Tax :'|| p_process_tax, 1);
1274: end if;
1275:
1276: OE_BULK_ORDER_PVT.PROCESS_BATCH (
1277: p_batch_id => l_batch_id,
1278: p_validate_only => p_validate_only,
1279: p_validate_desc_flex => p_validate_desc_flex,
1280: p_defaulting_mode => p_defaulting_mode,
1289: );
1290:
1291: -- Save messages logged during the processing of this batch
1292:
1293: OE_BULK_MSG_PUB.Save_Messages(OE_Bulk_Order_PVT.G_REQUEST_ID);
1294:
1295: -- Save messages from non-bulk enabled API calls
1296: OE_MSG_PUB.Save_Messages(OE_Bulk_Order_PVT.G_REQUEST_ID);
1297:
1292:
1293: OE_BULK_MSG_PUB.Save_Messages(OE_Bulk_Order_PVT.G_REQUEST_ID);
1294:
1295: -- Save messages from non-bulk enabled API calls
1296: OE_MSG_PUB.Save_Messages(OE_Bulk_Order_PVT.G_REQUEST_ID);
1297:
1298:
1299: -- Process_Batch will only return unexp error or success result
1300: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN