[Home] [Help]
143: oe_debug_pub.add( 'ENTERING OE_BULK_TAX_UTIL.GET_DEFAULT_TAX_CODE' ) ;
144: END IF;
145: --Loop over the loaded lines to default the tax code
146: l_index := 1;
147: WHILE l_index <= OE_Bulk_Order_PVT.G_LINE_REC.LINE_ID.COUNT LOOP
148: l_index_inc := 1;
149:
150: --IF (OE_Bulk_Order_PVT.G_LINE_REC.tax_exempt_flag(l_index) = 'R'
151: -- OR
146: l_index := 1;
147: WHILE l_index <= OE_Bulk_Order_PVT.G_LINE_REC.LINE_ID.COUNT LOOP
148: l_index_inc := 1;
149:
150: --IF (OE_Bulk_Order_PVT.G_LINE_REC.tax_exempt_flag(l_index) = 'R'
151: -- OR
152: -- OE_Bulk_Order_PVT.G_LINE_REC.tax_calculation_flag(l_index) = 'Y')
153: --THEN
154: --bug7685103
148: l_index_inc := 1;
149:
150: --IF (OE_Bulk_Order_PVT.G_LINE_REC.tax_exempt_flag(l_index) = 'R'
151: -- OR
152: -- OE_Bulk_Order_PVT.G_LINE_REC.tax_calculation_flag(l_index) = 'Y')
153: --THEN
154: --bug7685103
155:
156: l_header_index := OE_Bulk_Order_PVT.G_LINE_REC.header_index(l_index);
152: -- OE_Bulk_Order_PVT.G_LINE_REC.tax_calculation_flag(l_index) = 'Y')
153: --THEN
154: --bug7685103
155:
156: l_header_index := OE_Bulk_Order_PVT.G_LINE_REC.header_index(l_index);
157:
158:
159: IF l_debug_level > 0 THEN
160: oe_debug_pub.add( 'line index: ' || l_index || ' line id: '|| OE_Bulk_Order_PVT.G_LINE_REC.line_id(l_index) || ' header index: ' || l_header_index || ' header id: ' || OE_Bulk_Order_PVT.G_HEADER_REC.header_id(l_header_index));
156: l_header_index := OE_Bulk_Order_PVT.G_LINE_REC.header_index(l_index);
157:
158:
159: IF l_debug_level > 0 THEN
160: oe_debug_pub.add( 'line index: ' || l_index || ' line id: '|| OE_Bulk_Order_PVT.G_LINE_REC.line_id(l_index) || ' header index: ' || l_header_index || ' header id: ' || OE_Bulk_Order_PVT.G_HEADER_REC.header_id(l_header_index));
161: END IF;
162:
163: IF nvl(OE_Bulk_Order_PVT.G_HEADER_REC.lock_control(l_header_index),0) = -99
164: THEN
159: IF l_debug_level > 0 THEN
160: oe_debug_pub.add( 'line index: ' || l_index || ' line id: '|| OE_Bulk_Order_PVT.G_LINE_REC.line_id(l_index) || ' header index: ' || l_header_index || ' header id: ' || OE_Bulk_Order_PVT.G_HEADER_REC.header_id(l_header_index));
161: END IF;
162:
163: IF nvl(OE_Bulk_Order_PVT.G_HEADER_REC.lock_control(l_header_index),0) = -99
164: THEN
165: IF l_debug_level > 0 THEN
166: oe_debug_pub.add( 'lock control set. skipping header with header id: '|| OE_Bulk_Order_PVT.G_HEADER_REC.header_id(l_header_index));
167: END IF;
162:
163: IF nvl(OE_Bulk_Order_PVT.G_HEADER_REC.lock_control(l_header_index),0) = -99
164: THEN
165: IF l_debug_level > 0 THEN
166: oe_debug_pub.add( 'lock control set. skipping header with header id: '|| OE_Bulk_Order_PVT.G_HEADER_REC.header_id(l_header_index));
167: END IF;
168: --Skip the remaining lines in this header as it is marked for error
169: l_remaining_lines := OE_Bulk_Order_PVT.G_HEADER_REC.end_line_index(l_header_index) - l_index;
170: l_index_inc := l_remaining_lines + 1;
165: IF l_debug_level > 0 THEN
166: oe_debug_pub.add( 'lock control set. skipping header with header id: '|| OE_Bulk_Order_PVT.G_HEADER_REC.header_id(l_header_index));
167: END IF;
168: --Skip the remaining lines in this header as it is marked for error
169: l_remaining_lines := OE_Bulk_Order_PVT.G_HEADER_REC.end_line_index(l_header_index) - l_index;
170: l_index_inc := l_remaining_lines + 1;
171: ELSE
172:
173: --default the tax_date with the following precedence: 1. schedule_ship_date, 2. request_date, 3. promise_date, 4. sysdate
170: l_index_inc := l_remaining_lines + 1;
171: ELSE
172:
173: --default the tax_date with the following precedence: 1. schedule_ship_date, 2. request_date, 3. promise_date, 4. sysdate
174: IF OE_Bulk_Order_PVT.G_LINE_REC.schedule_ship_date(l_index) IS NOT NULL
175: THEN
176: IF l_debug_level > 0 THEN
177: oe_debug_pub.add( 'defaulting tax date from schedule ship date');
178: END IF;
175: THEN
176: IF l_debug_level > 0 THEN
177: oe_debug_pub.add( 'defaulting tax date from schedule ship date');
178: END IF;
179: OE_Bulk_Order_PVT.G_LINE_REC.tax_date(l_index) := OE_Bulk_Order_PVT.G_LINE_REC.schedule_ship_date(l_index);
180: ELSIF OE_Bulk_Order_PVT.G_LINE_REC.request_date(l_index) IS NOT NULL
181: THEN
182: IF l_debug_level > 0 THEN
183: oe_debug_pub.add( 'defaulting tax date from request date');
176: IF l_debug_level > 0 THEN
177: oe_debug_pub.add( 'defaulting tax date from schedule ship date');
178: END IF;
179: OE_Bulk_Order_PVT.G_LINE_REC.tax_date(l_index) := OE_Bulk_Order_PVT.G_LINE_REC.schedule_ship_date(l_index);
180: ELSIF OE_Bulk_Order_PVT.G_LINE_REC.request_date(l_index) IS NOT NULL
181: THEN
182: IF l_debug_level > 0 THEN
183: oe_debug_pub.add( 'defaulting tax date from request date');
184: END IF;
181: THEN
182: IF l_debug_level > 0 THEN
183: oe_debug_pub.add( 'defaulting tax date from request date');
184: END IF;
185: OE_Bulk_Order_PVT.G_LINE_REC.tax_date(l_index) := OE_Bulk_Order_PVT.G_LINE_REC.request_date(l_index);
186: ELSIF OE_Bulk_Order_PVT.G_LINE_REC.promise_date(l_index) IS NOT NULL
187: THEN
188: IF l_debug_level > 0 THEN
189: oe_debug_pub.add( 'defaulting tax date from promise date');
182: IF l_debug_level > 0 THEN
183: oe_debug_pub.add( 'defaulting tax date from request date');
184: END IF;
185: OE_Bulk_Order_PVT.G_LINE_REC.tax_date(l_index) := OE_Bulk_Order_PVT.G_LINE_REC.request_date(l_index);
186: ELSIF OE_Bulk_Order_PVT.G_LINE_REC.promise_date(l_index) IS NOT NULL
187: THEN
188: IF l_debug_level > 0 THEN
189: oe_debug_pub.add( 'defaulting tax date from promise date');
190: END IF;
187: THEN
188: IF l_debug_level > 0 THEN
189: oe_debug_pub.add( 'defaulting tax date from promise date');
190: END IF;
191: OE_Bulk_Order_PVT.G_LINE_REC.tax_date(l_index) := OE_Bulk_Order_PVT.G_LINE_REC.promise_date(l_index);
192: ELSE
193: IF l_debug_level > 0 THEN
194: oe_debug_pub.add( 'defaulting tax date from sysdate');
195: END IF;
192: ELSE
193: IF l_debug_level > 0 THEN
194: oe_debug_pub.add( 'defaulting tax date from sysdate');
195: END IF;
196: OE_Bulk_Order_PVT.G_LINE_REC.tax_date(l_index) := sysdate;
197: END IF; --end of schedule_ship_date is not null
198:
199: --get the tax code
200: IF OE_Bulk_Order_PVT.G_LINE_REC.tax_code(l_index) IS NULL
196: OE_Bulk_Order_PVT.G_LINE_REC.tax_date(l_index) := sysdate;
197: END IF; --end of schedule_ship_date is not null
198:
199: --get the tax code
200: IF OE_Bulk_Order_PVT.G_LINE_REC.tax_code(l_index) IS NULL
201: THEN
202:
203: BEGIN
204:
203: BEGIN
204:
205: IF l_debug_level > 0 THEN
206: oe_debug_pub.add( 'before calling ZX_AR_TAX_CLASSIFICATN_DEF_PKG.GET_DEFAULT_TAX_CLASSIFICATION');
207: oe_debug_pub.add( 'OE_Bulk_Order_PVT.G_LINE_REC.org_id('||l_index||') :'||OE_Bulk_Order_PVT.G_LINE_REC.org_id(l_index) );
208: END IF;
209:
210: SELECT hsecs INTO l_start_time from v$timer;
211:
209:
210: SELECT hsecs INTO l_start_time from v$timer;
211:
212: ZX_AR_TAX_CLASSIFICATN_DEF_PKG.GET_DEFAULT_TAX_CLASSIFICATION
213: ( p_ship_to_site_use_id => OE_Bulk_Order_PVT.G_LINE_REC.ship_to_org_id(l_index) ,
214: p_bill_to_site_use_id => OE_Bulk_Order_PVT.G_LINE_REC.invoice_to_org_id(l_index),
215: p_inventory_item_id =>OE_Bulk_Order_PVT.G_LINE_REC.inventory_item_id(l_index) ,
216: p_organization_id => OE_Bulk_Order_PVT.G_ITEM_ORG,
217: p_set_of_books_id => OE_Bulk_Order_PVT.G_SOB_ID,
210: SELECT hsecs INTO l_start_time from v$timer;
211:
212: ZX_AR_TAX_CLASSIFICATN_DEF_PKG.GET_DEFAULT_TAX_CLASSIFICATION
213: ( p_ship_to_site_use_id => OE_Bulk_Order_PVT.G_LINE_REC.ship_to_org_id(l_index) ,
214: p_bill_to_site_use_id => OE_Bulk_Order_PVT.G_LINE_REC.invoice_to_org_id(l_index),
215: p_inventory_item_id =>OE_Bulk_Order_PVT.G_LINE_REC.inventory_item_id(l_index) ,
216: p_organization_id => OE_Bulk_Order_PVT.G_ITEM_ORG,
217: p_set_of_books_id => OE_Bulk_Order_PVT.G_SOB_ID,
218: p_trx_date => OE_Bulk_Order_PVT.G_LINE_REC.tax_date(l_index),
211:
212: ZX_AR_TAX_CLASSIFICATN_DEF_PKG.GET_DEFAULT_TAX_CLASSIFICATION
213: ( p_ship_to_site_use_id => OE_Bulk_Order_PVT.G_LINE_REC.ship_to_org_id(l_index) ,
214: p_bill_to_site_use_id => OE_Bulk_Order_PVT.G_LINE_REC.invoice_to_org_id(l_index),
215: p_inventory_item_id =>OE_Bulk_Order_PVT.G_LINE_REC.inventory_item_id(l_index) ,
216: p_organization_id => OE_Bulk_Order_PVT.G_ITEM_ORG,
217: p_set_of_books_id => OE_Bulk_Order_PVT.G_SOB_ID,
218: p_trx_date => OE_Bulk_Order_PVT.G_LINE_REC.tax_date(l_index),
219: p_trx_type_id => OE_Bulk_Order_PVT.G_LINE_REC.cust_trx_type_id(l_index),
212: ZX_AR_TAX_CLASSIFICATN_DEF_PKG.GET_DEFAULT_TAX_CLASSIFICATION
213: ( p_ship_to_site_use_id => OE_Bulk_Order_PVT.G_LINE_REC.ship_to_org_id(l_index) ,
214: p_bill_to_site_use_id => OE_Bulk_Order_PVT.G_LINE_REC.invoice_to_org_id(l_index),
215: p_inventory_item_id =>OE_Bulk_Order_PVT.G_LINE_REC.inventory_item_id(l_index) ,
216: p_organization_id => OE_Bulk_Order_PVT.G_ITEM_ORG,
217: p_set_of_books_id => OE_Bulk_Order_PVT.G_SOB_ID,
218: p_trx_date => OE_Bulk_Order_PVT.G_LINE_REC.tax_date(l_index),
219: p_trx_type_id => OE_Bulk_Order_PVT.G_LINE_REC.cust_trx_type_id(l_index),
220: p_tax_classification_code => x_tax_code,
213: ( p_ship_to_site_use_id => OE_Bulk_Order_PVT.G_LINE_REC.ship_to_org_id(l_index) ,
214: p_bill_to_site_use_id => OE_Bulk_Order_PVT.G_LINE_REC.invoice_to_org_id(l_index),
215: p_inventory_item_id =>OE_Bulk_Order_PVT.G_LINE_REC.inventory_item_id(l_index) ,
216: p_organization_id => OE_Bulk_Order_PVT.G_ITEM_ORG,
217: p_set_of_books_id => OE_Bulk_Order_PVT.G_SOB_ID,
218: p_trx_date => OE_Bulk_Order_PVT.G_LINE_REC.tax_date(l_index),
219: p_trx_type_id => OE_Bulk_Order_PVT.G_LINE_REC.cust_trx_type_id(l_index),
220: p_tax_classification_code => x_tax_code,
221: -- p_cust_trx_id => l_ra_cust_trx_type_id,
214: p_bill_to_site_use_id => OE_Bulk_Order_PVT.G_LINE_REC.invoice_to_org_id(l_index),
215: p_inventory_item_id =>OE_Bulk_Order_PVT.G_LINE_REC.inventory_item_id(l_index) ,
216: p_organization_id => OE_Bulk_Order_PVT.G_ITEM_ORG,
217: p_set_of_books_id => OE_Bulk_Order_PVT.G_SOB_ID,
218: p_trx_date => OE_Bulk_Order_PVT.G_LINE_REC.tax_date(l_index),
219: p_trx_type_id => OE_Bulk_Order_PVT.G_LINE_REC.cust_trx_type_id(l_index),
220: p_tax_classification_code => x_tax_code,
221: -- p_cust_trx_id => l_ra_cust_trx_type_id,
222: -- p_customer_id => nvl(l_shipment_rec.ship_to_cust_party_id,l_shipment_header_rec.ship_to_cust_party_id),
215: p_inventory_item_id =>OE_Bulk_Order_PVT.G_LINE_REC.inventory_item_id(l_index) ,
216: p_organization_id => OE_Bulk_Order_PVT.G_ITEM_ORG,
217: p_set_of_books_id => OE_Bulk_Order_PVT.G_SOB_ID,
218: p_trx_date => OE_Bulk_Order_PVT.G_LINE_REC.tax_date(l_index),
219: p_trx_type_id => OE_Bulk_Order_PVT.G_LINE_REC.cust_trx_type_id(l_index),
220: p_tax_classification_code => x_tax_code,
221: -- p_cust_trx_id => l_ra_cust_trx_type_id,
222: -- p_customer_id => nvl(l_shipment_rec.ship_to_cust_party_id,l_shipment_header_rec.ship_to_cust_party_id),
223: appl_short_name => 'ONT',
223: appl_short_name => 'ONT',
224: p_entity_code => 'OE_ORDER_HEADERS',
225: p_event_class_code => 'SALES_TRANSACTION_TAX_QUOTE',
226: p_application_id => 660,
227: p_internal_organization_id => OE_Bulk_Order_PVT.G_LINE_REC.org_id(l_index) --bug7759207
228: );
229:
230:
231:
257: */
258: NULL;
259:
260: ELSE
261: OE_Bulk_Order_PVT.G_LINE_REC.tax_code(l_index) := x_tax_code;
262: oe_debug_pub.add( ' Tax Code :'|| OE_Bulk_Order_PVT.G_LINE_REC.tax_code(l_index),1);
263: END IF; -- tax_code IS NULL
264:
265:
258: NULL;
259:
260: ELSE
261: OE_Bulk_Order_PVT.G_LINE_REC.tax_code(l_index) := x_tax_code;
262: oe_debug_pub.add( ' Tax Code :'|| OE_Bulk_Order_PVT.G_LINE_REC.tax_code(l_index),1);
263: END IF; -- tax_code IS NULL
264:
265:
266: EXCEPTION
269: IF l_debug_level > 0 THEN
270: oe_debug_pub.add( 'in others exception in get default tax: ' || SQLERRM);
271: END IF;
272:
273: OE_Bulk_Order_PVT.G_LINE_REC.tax_code(l_index) := x_tax_code;
274:
275: /*Handle_Tax_Code_Error(p_index => l_index,
276: p_header_index => l_header_index,
277: x_index_inc => l_error_inc);
289:
290: --bug7685103
291: --This validation will be done in OEBLLINB.pls
292: /* -- Validating Tax Information
293: IF OE_Bulk_Order_PVT.G_LINE_REC.tax_code(l_index) IS NOT NULL AND
294: OE_Bulk_Order_PVT.G_LINE_REC.tax_date(l_index) IS NOT NULL
295: THEN
296: BEGIN
297: IF oe_code_control.code_release_level >= '110510' THEN
290: --bug7685103
291: --This validation will be done in OEBLLINB.pls
292: /* -- Validating Tax Information
293: IF OE_Bulk_Order_PVT.G_LINE_REC.tax_code(l_index) IS NOT NULL AND
294: OE_Bulk_Order_PVT.G_LINE_REC.tax_date(l_index) IS NOT NULL
295: THEN
296: BEGIN
297: IF oe_code_control.code_release_level >= '110510' THEN
298:
301:
302: SELECT 'VALID'
303: INTO l_dummy
304: FROM AR_VAT_TAX V
305: WHERE V.TAX_CODE = OE_Bulk_Order_PVT.G_LINE_REC.tax_code(l_index)
306: AND V.SET_OF_BOOKS_ID = l_sob_id
307: AND NVL(V.ENABLED_FLAG,'Y')='Y'
308: AND NVL(V.TAX_CLASS,'O')='O'
309: AND NVL(V.DISPLAYED_FLAG,'Y')='Y'
306: AND V.SET_OF_BOOKS_ID = l_sob_id
307: AND NVL(V.ENABLED_FLAG,'Y')='Y'
308: AND NVL(V.TAX_CLASS,'O')='O'
309: AND NVL(V.DISPLAYED_FLAG,'Y')='Y'
310: AND TRUNC(OE_Bulk_Order_PVT.G_LINE_REC.tax_date(l_index))
311: BETWEEN TRUNC(V.START_DATE) AND
312: TRUNC(NVL(V.END_DATE, OE_Bulk_Order_PVT.G_LINE_REC.tax_date(l_index)))
313: AND ROWNUM = 1;
314:
308: AND NVL(V.TAX_CLASS,'O')='O'
309: AND NVL(V.DISPLAYED_FLAG,'Y')='Y'
310: AND TRUNC(OE_Bulk_Order_PVT.G_LINE_REC.tax_date(l_index))
311: BETWEEN TRUNC(V.START_DATE) AND
312: TRUNC(NVL(V.END_DATE, OE_Bulk_Order_PVT.G_LINE_REC.tax_date(l_index)))
313: AND ROWNUM = 1;
314:
315: ELSE
316:
317: SELECT 'VALID'
318: INTO l_dummy
319: FROM AR_VAT_TAX V,
320: AR_SYSTEM_PARAMETERS P
321: WHERE V.TAX_CODE = OE_Bulk_Order_PVT.G_LINE_REC.tax_code(l_index)
322: AND V.SET_OF_BOOKS_ID = P.SET_OF_BOOKS_ID
323: AND NVL(V.ENABLED_FLAG,'Y')='Y'
324: AND NVL(V.TAX_CLASS,'O')='O'
325: AND NVL(V.DISPLAYED_FLAG,'Y')='Y'
322: AND V.SET_OF_BOOKS_ID = P.SET_OF_BOOKS_ID
323: AND NVL(V.ENABLED_FLAG,'Y')='Y'
324: AND NVL(V.TAX_CLASS,'O')='O'
325: AND NVL(V.DISPLAYED_FLAG,'Y')='Y'
326: AND TRUNC(OE_Bulk_Order_PVT.G_LINE_REC.tax_date(l_index))
327: BETWEEN TRUNC(V.START_DATE) AND
328: TRUNC(NVL(V.END_DATE, OE_Bulk_Order_PVT.G_LINE_REC.tax_date(l_index)))
329: AND ROWNUM = 1;
330:
324: AND NVL(V.TAX_CLASS,'O')='O'
325: AND NVL(V.DISPLAYED_FLAG,'Y')='Y'
326: AND TRUNC(OE_Bulk_Order_PVT.G_LINE_REC.tax_date(l_index))
327: BETWEEN TRUNC(V.START_DATE) AND
328: TRUNC(NVL(V.END_DATE, OE_Bulk_Order_PVT.G_LINE_REC.tax_date(l_index)))
329: AND ROWNUM = 1;
330:
331: END IF;
332:
562: l_index := 1;
563: l_tax_index := 1;
564: l_adj_index := 1;
565:
566: WHILE l_index <= OE_Bulk_Order_PVT.G_LINE_REC.LINE_ID.COUNT LOOP
567: l_tax_value := 0;
568: l_index_inc := 1;
569: l_header_index := OE_Bulk_Order_PVT.G_LINE_REC.header_index(l_index);
570: l_header_id := OE_Bulk_Order_PVT.G_LINE_REC.header_id(l_index);
565:
566: WHILE l_index <= OE_Bulk_Order_PVT.G_LINE_REC.LINE_ID.COUNT LOOP
567: l_tax_value := 0;
568: l_index_inc := 1;
569: l_header_index := OE_Bulk_Order_PVT.G_LINE_REC.header_index(l_index);
570: l_header_id := OE_Bulk_Order_PVT.G_LINE_REC.header_id(l_index);
571: l_line_id := OE_Bulk_Order_PVT.G_LINE_REC.line_id(l_index);
572: zx_global_structures_pkg.init_trx_line_dist_tbl(l_index);
573: IF l_debug_level > 0 THEN
566: WHILE l_index <= OE_Bulk_Order_PVT.G_LINE_REC.LINE_ID.COUNT LOOP
567: l_tax_value := 0;
568: l_index_inc := 1;
569: l_header_index := OE_Bulk_Order_PVT.G_LINE_REC.header_index(l_index);
570: l_header_id := OE_Bulk_Order_PVT.G_LINE_REC.header_id(l_index);
571: l_line_id := OE_Bulk_Order_PVT.G_LINE_REC.line_id(l_index);
572: zx_global_structures_pkg.init_trx_line_dist_tbl(l_index);
573: IF l_debug_level > 0 THEN
574: oe_debug_pub.add( 'line index: ' || l_index || ' line id: '|| l_line_id || ' header index: ' || l_header_index || ' header id: ' || l_header_id);
567: l_tax_value := 0;
568: l_index_inc := 1;
569: l_header_index := OE_Bulk_Order_PVT.G_LINE_REC.header_index(l_index);
570: l_header_id := OE_Bulk_Order_PVT.G_LINE_REC.header_id(l_index);
571: l_line_id := OE_Bulk_Order_PVT.G_LINE_REC.line_id(l_index);
572: zx_global_structures_pkg.init_trx_line_dist_tbl(l_index);
573: IF l_debug_level > 0 THEN
574: oe_debug_pub.add( 'line index: ' || l_index || ' line id: '|| l_line_id || ' header index: ' || l_header_index || ' header id: ' || l_header_id);
575: END IF;
574: oe_debug_pub.add( 'line index: ' || l_index || ' line id: '|| l_line_id || ' header index: ' || l_header_index || ' header id: ' || l_header_id);
575: END IF;
576:
577:
578: IF nvl(OE_Bulk_Order_PVT.G_HEADER_REC.lock_control(l_header_index),0) = -99
579: THEN
580:
581: IF l_debug_level > 0 THEN
582: oe_debug_pub.add( 'lock control set. skipping header with header id: '|| l_header_id);
582: oe_debug_pub.add( 'lock control set. skipping header with header id: '|| l_header_id);
583: END IF;
584:
585: l_legal_entity_id := get_le_id(p_order_type_id =>
586: OE_Bulk_Order_PVT.G_HEADER_REC.order_type_id(l_header_index)
587: , p_sold_to_customer_id =>
588: OE_Bulk_Order_PVT.G_HEADER_REC.sold_to_org_id(l_header_index)
589: , p_bill_to_customer_id => l_bill_to_customer_id
590: , p_org_id => OE_Bulk_Order_PVT.G_HEADER_REC.org_id(l_header_index)
584:
585: l_legal_entity_id := get_le_id(p_order_type_id =>
586: OE_Bulk_Order_PVT.G_HEADER_REC.order_type_id(l_header_index)
587: , p_sold_to_customer_id =>
588: OE_Bulk_Order_PVT.G_HEADER_REC.sold_to_org_id(l_header_index)
589: , p_bill_to_customer_id => l_bill_to_customer_id
590: , p_org_id => OE_Bulk_Order_PVT.G_HEADER_REC.org_id(l_header_index)
591: );
592:
586: OE_Bulk_Order_PVT.G_HEADER_REC.order_type_id(l_header_index)
587: , p_sold_to_customer_id =>
588: OE_Bulk_Order_PVT.G_HEADER_REC.sold_to_org_id(l_header_index)
589: , p_bill_to_customer_id => l_bill_to_customer_id
590: , p_org_id => OE_Bulk_Order_PVT.G_HEADER_REC.org_id(l_header_index)
591: );
592:
593:
594: --Skip the remaining lines in this header as it is marked for error
591: );
592:
593:
594: --Skip the remaining lines in this header as it is marked for error
595: l_remaining_lines := OE_Bulk_Order_PVT.G_HEADER_REC.end_line_index(l_header_index) - l_index;
596: l_index_inc := l_remaining_lines + 1;
597: ELSE
598: IF l_debug_level > 0 THEN
599: oe_debug_pub.add('inventory_item_id: ' || OE_Bulk_Order_PVT.G_LINE_REC.inventory_item_id(l_index));
595: l_remaining_lines := OE_Bulk_Order_PVT.G_HEADER_REC.end_line_index(l_header_index) - l_index;
596: l_index_inc := l_remaining_lines + 1;
597: ELSE
598: IF l_debug_level > 0 THEN
599: oe_debug_pub.add('inventory_item_id: ' || OE_Bulk_Order_PVT.G_LINE_REC.inventory_item_id(l_index));
600: oe_debug_pub.add('unit_selling_price: ' || OE_Bulk_Order_PVT.G_LINE_REC.unit_selling_price(l_index));
601: oe_debug_pub.add('tax_exempt_flag: ' || OE_Bulk_Order_PVT.G_LINE_REC.tax_exempt_flag(l_index));
602: oe_debug_pub.add('tax_calculation_flag: ' || OE_Bulk_Order_PVT.G_LINE_REC.tax_calculation_flag(l_index));
603: END IF;
596: l_index_inc := l_remaining_lines + 1;
597: ELSE
598: IF l_debug_level > 0 THEN
599: oe_debug_pub.add('inventory_item_id: ' || OE_Bulk_Order_PVT.G_LINE_REC.inventory_item_id(l_index));
600: oe_debug_pub.add('unit_selling_price: ' || OE_Bulk_Order_PVT.G_LINE_REC.unit_selling_price(l_index));
601: oe_debug_pub.add('tax_exempt_flag: ' || OE_Bulk_Order_PVT.G_LINE_REC.tax_exempt_flag(l_index));
602: oe_debug_pub.add('tax_calculation_flag: ' || OE_Bulk_Order_PVT.G_LINE_REC.tax_calculation_flag(l_index));
603: END IF;
604:
597: ELSE
598: IF l_debug_level > 0 THEN
599: oe_debug_pub.add('inventory_item_id: ' || OE_Bulk_Order_PVT.G_LINE_REC.inventory_item_id(l_index));
600: oe_debug_pub.add('unit_selling_price: ' || OE_Bulk_Order_PVT.G_LINE_REC.unit_selling_price(l_index));
601: oe_debug_pub.add('tax_exempt_flag: ' || OE_Bulk_Order_PVT.G_LINE_REC.tax_exempt_flag(l_index));
602: oe_debug_pub.add('tax_calculation_flag: ' || OE_Bulk_Order_PVT.G_LINE_REC.tax_calculation_flag(l_index));
603: END IF;
604:
605: begin
598: IF l_debug_level > 0 THEN
599: oe_debug_pub.add('inventory_item_id: ' || OE_Bulk_Order_PVT.G_LINE_REC.inventory_item_id(l_index));
600: oe_debug_pub.add('unit_selling_price: ' || OE_Bulk_Order_PVT.G_LINE_REC.unit_selling_price(l_index));
601: oe_debug_pub.add('tax_exempt_flag: ' || OE_Bulk_Order_PVT.G_LINE_REC.tax_exempt_flag(l_index));
602: oe_debug_pub.add('tax_calculation_flag: ' || OE_Bulk_Order_PVT.G_LINE_REC.tax_calculation_flag(l_index));
603: END IF;
604:
605: begin
606: select location_id
605: begin
606: select location_id
607: into l_bill_from_location_id
608: from HR_ALL_ORGANIZATION_UNITS
609: where organization_id = OE_Bulk_Order_PVT.G_HEADER_REC.org_id(l_header_index);
610: Exception
611: when others then
612: l_bill_from_location_id := NULL;
613: End;
611: when others then
612: l_bill_from_location_id := NULL;
613: End;
614:
615: open get_internal_loc(OE_Bulk_Order_PVT.G_HEADER_REC.org_id(l_header_index));
616: fetch get_internal_loc into l_internal_org_location_id;
617: close get_internal_loc;
618:
619: IF l_debug_level > 0 then
617: close get_internal_loc;
618:
619: IF l_debug_level > 0 then
620: oe_debug_pub.add('om_tax_line 13' , 4);
621: oe_debug_pub.add('OE_Bulk_Order_PVT.G_LINE_REC.inventory_item_id(l_index):'||OE_Bulk_Order_PVT.G_LINE_REC.inventory_item_id(l_index));
622: oe_debug_pub.add('OE_Bulk_Order_PVT.G_LINE_REC.unit_selling_price(l_index):'||OE_Bulk_Order_PVT.G_LINE_REC.unit_selling_price(l_index));
623: oe_debug_pub.add('OE_Bulk_Order_PVT.G_LINE_REC.item_type_code(l_index):'||OE_Bulk_Order_PVT.G_LINE_REC.item_type_code(l_index));
624: END IF;
625:
618:
619: IF l_debug_level > 0 then
620: oe_debug_pub.add('om_tax_line 13' , 4);
621: oe_debug_pub.add('OE_Bulk_Order_PVT.G_LINE_REC.inventory_item_id(l_index):'||OE_Bulk_Order_PVT.G_LINE_REC.inventory_item_id(l_index));
622: oe_debug_pub.add('OE_Bulk_Order_PVT.G_LINE_REC.unit_selling_price(l_index):'||OE_Bulk_Order_PVT.G_LINE_REC.unit_selling_price(l_index));
623: oe_debug_pub.add('OE_Bulk_Order_PVT.G_LINE_REC.item_type_code(l_index):'||OE_Bulk_Order_PVT.G_LINE_REC.item_type_code(l_index));
624: END IF;
625:
626:
619: IF l_debug_level > 0 then
620: oe_debug_pub.add('om_tax_line 13' , 4);
621: oe_debug_pub.add('OE_Bulk_Order_PVT.G_LINE_REC.inventory_item_id(l_index):'||OE_Bulk_Order_PVT.G_LINE_REC.inventory_item_id(l_index));
622: oe_debug_pub.add('OE_Bulk_Order_PVT.G_LINE_REC.unit_selling_price(l_index):'||OE_Bulk_Order_PVT.G_LINE_REC.unit_selling_price(l_index));
623: oe_debug_pub.add('OE_Bulk_Order_PVT.G_LINE_REC.item_type_code(l_index):'||OE_Bulk_Order_PVT.G_LINE_REC.item_type_code(l_index));
624: END IF;
625:
626:
627: IF ((OE_Bulk_Order_PVT.G_LINE_REC.inventory_item_id(l_index) IS NOT NULL
623: oe_debug_pub.add('OE_Bulk_Order_PVT.G_LINE_REC.item_type_code(l_index):'||OE_Bulk_Order_PVT.G_LINE_REC.item_type_code(l_index));
624: END IF;
625:
626:
627: IF ((OE_Bulk_Order_PVT.G_LINE_REC.inventory_item_id(l_index) IS NOT NULL
628: AND OE_Bulk_Order_PVT.G_LINE_REC.unit_selling_price(l_index) IS NOT NULL
629: AND OE_Bulk_Order_PVT.G_LINE_REC.item_type_code(l_index) <> OE_GLOBALS.G_ITEM_INCLUDED)
630: )
631: --AND
624: END IF;
625:
626:
627: IF ((OE_Bulk_Order_PVT.G_LINE_REC.inventory_item_id(l_index) IS NOT NULL
628: AND OE_Bulk_Order_PVT.G_LINE_REC.unit_selling_price(l_index) IS NOT NULL
629: AND OE_Bulk_Order_PVT.G_LINE_REC.item_type_code(l_index) <> OE_GLOBALS.G_ITEM_INCLUDED)
630: )
631: --AND
632: --(OE_Bulk_Order_PVT.G_LINE_REC.tax_exempt_flag(l_index) = 'R' OR
625:
626:
627: IF ((OE_Bulk_Order_PVT.G_LINE_REC.inventory_item_id(l_index) IS NOT NULL
628: AND OE_Bulk_Order_PVT.G_LINE_REC.unit_selling_price(l_index) IS NOT NULL
629: AND OE_Bulk_Order_PVT.G_LINE_REC.item_type_code(l_index) <> OE_GLOBALS.G_ITEM_INCLUDED)
630: )
631: --AND
632: --(OE_Bulk_Order_PVT.G_LINE_REC.tax_exempt_flag(l_index) = 'R' OR
633: --OE_Bulk_Order_PVT.G_LINE_REC.tax_calculation_flag(l_index) = 'Y'))
628: AND OE_Bulk_Order_PVT.G_LINE_REC.unit_selling_price(l_index) IS NOT NULL
629: AND OE_Bulk_Order_PVT.G_LINE_REC.item_type_code(l_index) <> OE_GLOBALS.G_ITEM_INCLUDED)
630: )
631: --AND
632: --(OE_Bulk_Order_PVT.G_LINE_REC.tax_exempt_flag(l_index) = 'R' OR
633: --OE_Bulk_Order_PVT.G_LINE_REC.tax_calculation_flag(l_index) = 'Y'))
634: --bug7685103
635: THEN
636:
629: AND OE_Bulk_Order_PVT.G_LINE_REC.item_type_code(l_index) <> OE_GLOBALS.G_ITEM_INCLUDED)
630: )
631: --AND
632: --(OE_Bulk_Order_PVT.G_LINE_REC.tax_exempt_flag(l_index) = 'R' OR
633: --OE_Bulk_Order_PVT.G_LINE_REC.tax_calculation_flag(l_index) = 'Y'))
634: --bug7685103
635: THEN
636:
637: l_order_type_cache_key := OE_BULK_CACHE.Load_Order_Type(OE_Bulk_Order_PVT.G_HEADER_REC.order_type_id(l_header_index));
633: --OE_Bulk_Order_PVT.G_LINE_REC.tax_calculation_flag(l_index) = 'Y'))
634: --bug7685103
635: THEN
636:
637: l_order_type_cache_key := OE_BULK_CACHE.Load_Order_Type(OE_Bulk_Order_PVT.G_HEADER_REC.order_type_id(l_header_index));
638:
639: IF l_debug_level > 0 THEN
640: oe_debug_pub.add( 'tax calculation event: ' || OE_Bulk_Cache.G_ORDER_TYPE_TBL(l_order_type_cache_key).tax_calculation_event);
641: oe_debug_pub.add( 'booked_flag: ' || nvl(OE_Bulk_Order_PVT.G_HEADER_REC.booked_flag(l_header_index), 'N'));
637: l_order_type_cache_key := OE_BULK_CACHE.Load_Order_Type(OE_Bulk_Order_PVT.G_HEADER_REC.order_type_id(l_header_index));
638:
639: IF l_debug_level > 0 THEN
640: oe_debug_pub.add( 'tax calculation event: ' || OE_Bulk_Cache.G_ORDER_TYPE_TBL(l_order_type_cache_key).tax_calculation_event);
641: oe_debug_pub.add( 'booked_flag: ' || nvl(OE_Bulk_Order_PVT.G_HEADER_REC.booked_flag(l_header_index), 'N'));
642: END IF;
643:
644: IF ((nvl(OE_Bulk_Order_PVT.G_HEADER_REC.booked_flag(l_header_index), 'N') = 'N' AND
645: OE_Bulk_Cache.G_ORDER_TYPE_TBL(l_order_type_cache_key).tax_calculation_event = 'BOOKING')
640: oe_debug_pub.add( 'tax calculation event: ' || OE_Bulk_Cache.G_ORDER_TYPE_TBL(l_order_type_cache_key).tax_calculation_event);
641: oe_debug_pub.add( 'booked_flag: ' || nvl(OE_Bulk_Order_PVT.G_HEADER_REC.booked_flag(l_header_index), 'N'));
642: END IF;
643:
644: IF ((nvl(OE_Bulk_Order_PVT.G_HEADER_REC.booked_flag(l_header_index), 'N') = 'N' AND
645: OE_Bulk_Cache.G_ORDER_TYPE_TBL(l_order_type_cache_key).tax_calculation_event = 'BOOKING')
646: OR
647: (OE_Bulk_Cache.G_ORDER_TYPE_TBL(l_order_type_cache_key).tax_calculation_event NOT IN ('ENTERING', 'BOOKING')))
648: THEN
650: oe_debug_pub.add( 'tax calculation event not set to ENTERING or BOOKING...OR....event is set to BOOKING but order is not booked. skipping header with header id: '|| l_header_id);
651: END IF;
652:
653: --Skip the remaining lines in this header
654: l_remaining_lines := OE_Bulk_Order_PVT.G_HEADER_REC.end_line_index(l_header_index) - l_index;
655: l_index_inc := l_remaining_lines + 1;
656: ELSE
657:
658: oe_debug_pub.add( 'Set message Context ');
661: ( p_entity_code => 'LINE'
662: ,p_entity_id => l_line_id
663: ,p_header_id => l_header_id
664: ,p_line_id => l_line_id
665: ,p_orig_sys_document_ref => OE_Bulk_Order_PVT.G_LINE_REC.orig_sys_document_ref(l_index)
666: ,p_orig_sys_document_line_ref => OE_Bulk_Order_PVT.G_LINE_REC.orig_sys_line_ref(l_index)
667: ,p_source_document_id => NULL
668: ,p_source_document_line_id => NULL
669: ,p_order_source_id => OE_Bulk_Order_PVT.G_LINE_REC.order_source_id(l_index)
662: ,p_entity_id => l_line_id
663: ,p_header_id => l_header_id
664: ,p_line_id => l_line_id
665: ,p_orig_sys_document_ref => OE_Bulk_Order_PVT.G_LINE_REC.orig_sys_document_ref(l_index)
666: ,p_orig_sys_document_line_ref => OE_Bulk_Order_PVT.G_LINE_REC.orig_sys_line_ref(l_index)
667: ,p_source_document_id => NULL
668: ,p_source_document_line_id => NULL
669: ,p_order_source_id => OE_Bulk_Order_PVT.G_LINE_REC.order_source_id(l_index)
670: ,p_source_document_type_id => NULL
665: ,p_orig_sys_document_ref => OE_Bulk_Order_PVT.G_LINE_REC.orig_sys_document_ref(l_index)
666: ,p_orig_sys_document_line_ref => OE_Bulk_Order_PVT.G_LINE_REC.orig_sys_line_ref(l_index)
667: ,p_source_document_id => NULL
668: ,p_source_document_line_id => NULL
669: ,p_order_source_id => OE_Bulk_Order_PVT.G_LINE_REC.order_source_id(l_index)
670: ,p_source_document_type_id => NULL
671: );
672:
673:
676: END IF;
677:
678:
679:
680: l_currency_code := OE_Bulk_Order_PVT.G_HEADER_REC.transactional_curr_code(l_header_index);
681: l_header_org_id := OE_Bulk_Order_PVT.G_HEADER_REC.org_id(l_header_index);
682: l_conversion_rate := OE_Bulk_Order_PVT.G_HEADER_REC.conversion_rate(l_header_index);
683: l_inventory_org_id := oe_sys_parameters.value('MASTER_ORGANIZATION_ID',OE_Bulk_Order_PVT.G_HEADER_REC.org_id(l_header_index));
684:
677:
678:
679:
680: l_currency_code := OE_Bulk_Order_PVT.G_HEADER_REC.transactional_curr_code(l_header_index);
681: l_header_org_id := OE_Bulk_Order_PVT.G_HEADER_REC.org_id(l_header_index);
682: l_conversion_rate := OE_Bulk_Order_PVT.G_HEADER_REC.conversion_rate(l_header_index);
683: l_inventory_org_id := oe_sys_parameters.value('MASTER_ORGANIZATION_ID',OE_Bulk_Order_PVT.G_HEADER_REC.org_id(l_header_index));
684:
685:
678:
679:
680: l_currency_code := OE_Bulk_Order_PVT.G_HEADER_REC.transactional_curr_code(l_header_index);
681: l_header_org_id := OE_Bulk_Order_PVT.G_HEADER_REC.org_id(l_header_index);
682: l_conversion_rate := OE_Bulk_Order_PVT.G_HEADER_REC.conversion_rate(l_header_index);
683: l_inventory_org_id := oe_sys_parameters.value('MASTER_ORGANIZATION_ID',OE_Bulk_Order_PVT.G_HEADER_REC.org_id(l_header_index));
684:
685:
686: select c.minimum_accountable_unit,
679:
680: l_currency_code := OE_Bulk_Order_PVT.G_HEADER_REC.transactional_curr_code(l_header_index);
681: l_header_org_id := OE_Bulk_Order_PVT.G_HEADER_REC.org_id(l_header_index);
682: l_conversion_rate := OE_Bulk_Order_PVT.G_HEADER_REC.conversion_rate(l_header_index);
683: l_inventory_org_id := oe_sys_parameters.value('MASTER_ORGANIZATION_ID',OE_Bulk_Order_PVT.G_HEADER_REC.org_id(l_header_index));
684:
685:
686: select c.minimum_accountable_unit,
687: c.precision
692:
693: l_AR_Sys_Param_Rec := OE_Sys_Parameters_Pvt.Get_AR_Sys_Params;
694:
695: --code changes made for bug 1883552 begin
696: l_commitment_id := nvl(OE_Bulk_Order_PVT.G_LINE_REC.commitment_id(l_index),0);
697: if l_commitment_id <> 0 then
698:
699:
700: IF l_debug_level > 0 THEN
729: IF l_debug_level > 0 THEN
730: oe_debug_pub.add('In else part of commitment id',4);
731: END IF;
732: /*l_cust_trx_type_id :=
733: OE_INVOICE_PUB.Get_Customer_Transaction_Type(OE_Bulk_Order_PVT.G_LINE_REC(l_index)); */
734:
735: end if;
736: --code changes made for bug 1883552 end
737:
739: oe_debug_pub.add('Customer trx type id is:'||l_cust_trx_type_id,4);
740: END IF;
741:
742: -- bug7685103 to avoid NO_DATA_FOUND exception
743: IF OE_Bulk_Order_PVT.G_LINE_REC.tax_code(l_index) IS NOT NULL THEN
744: l_tax_code_cache_key := OE_Bulk_Cache.load_tax_attributes(OE_Bulk_Order_PVT.G_LINE_REC.tax_code(l_index), OE_Bulk_Order_PVT.G_LINE_REC.tax_date(l_index));
745:
746: IF l_debug_level > 0 THEN
747: oe_debug_pub.add('tax inclusive flag from cache:' || OE_BULK_CACHE.G_TAX_ATTRIBUTES_TBL(l_tax_code_cache_key).amount_includes_tax_flag);
740: END IF;
741:
742: -- bug7685103 to avoid NO_DATA_FOUND exception
743: IF OE_Bulk_Order_PVT.G_LINE_REC.tax_code(l_index) IS NOT NULL THEN
744: l_tax_code_cache_key := OE_Bulk_Cache.load_tax_attributes(OE_Bulk_Order_PVT.G_LINE_REC.tax_code(l_index), OE_Bulk_Order_PVT.G_LINE_REC.tax_date(l_index));
745:
746: IF l_debug_level > 0 THEN
747: oe_debug_pub.add('tax inclusive flag from cache:' || OE_BULK_CACHE.G_TAX_ATTRIBUTES_TBL(l_tax_code_cache_key).amount_includes_tax_flag);
748: END IF;
752:
753:
754: BEGIN
755:
756: l_salesrep_cache_key := OE_BULK_CACHE.Load_Salesrep(OE_Bulk_Order_PVT.G_LINE_REC.salesrep_id(l_index));
757: l_person_id := OE_BULK_CACHE.G_SALESREP_TBL(l_salesrep_cache_key).person_id;
758:
759: IF l_debug_level > 0 THEN
760: oe_debug_pub.add( 'Before Calling load_person: ' || l_person_id);
758:
759: IF l_debug_level > 0 THEN
760: oe_debug_pub.add( 'Before Calling load_person: ' || l_person_id);
761: oe_debug_pub.add( ' l_index :'|| l_index);
762: oe_debug_pub.add( ' Tax Date :'|| OE_Bulk_Order_PVT.G_LINE_REC.tax_date(l_index));
763: END IF;
764:
765: l_asgn_org_id := OE_BULK_CACHE.Load_Person(l_person_id, OE_Bulk_Order_PVT.G_LINE_REC.tax_date(l_index));
766:
761: oe_debug_pub.add( ' l_index :'|| l_index);
762: oe_debug_pub.add( ' Tax Date :'|| OE_Bulk_Order_PVT.G_LINE_REC.tax_date(l_index));
763: END IF;
764:
765: l_asgn_org_id := OE_BULK_CACHE.Load_Person(l_person_id, OE_Bulk_Order_PVT.G_LINE_REC.tax_date(l_index));
766:
767: EXCEPTION
768: When others then
769: l_load_person_failed := true;
780: l_poo_location_id := OE_BULK_CACHE.G_PERSON_TBL(l_person_id).LOCATION_ID;
781: END IF;
782:
783: -- Legal Entity
784: oe_debug_pub.add( ' Ship from org id :'|| OE_Bulk_Order_PVT.G_LINE_REC.ship_from_org_id(l_index));
785:
786: IF OE_Bulk_Order_PVT.G_LINE_REC.ship_from_org_id(l_index) IS NOT NULL THEN
787: BEGIN
788: SELECT location_id
782:
783: -- Legal Entity
784: oe_debug_pub.add( ' Ship from org id :'|| OE_Bulk_Order_PVT.G_LINE_REC.ship_from_org_id(l_index));
785:
786: IF OE_Bulk_Order_PVT.G_LINE_REC.ship_from_org_id(l_index) IS NOT NULL THEN
787: BEGIN
788: SELECT location_id
789: INTO l_ship_from_location_id
790: FROM hr_all_organization_units hu
787: BEGIN
788: SELECT location_id
789: INTO l_ship_from_location_id
790: FROM hr_all_organization_units hu
791: WHERE hu.organization_id = OE_Bulk_Order_PVT.G_LINE_REC.ship_from_org_id(l_index);
792: EXCEPTION
793: WHEN OTHERS THEN
794: NULL;
795: END;
798:
799: -- zx_global_structures_pkg.init_trx_line_dist_tbl(i);
800:
801: -- populate ship_to info if ship_to_org_id is not null
802: IF OE_Bulk_Order_PVT.G_LINE_REC.ship_to_org_id(l_index) IS NOT NULL
803: THEN
804: IF l_debug_level > 0 THEN
805: oe_debug_pub.add( 'retrieving ship_to info');
806: END IF;
803: THEN
804: IF l_debug_level > 0 THEN
805: oe_debug_pub.add( 'retrieving ship_to info');
806: END IF;
807: l_ship_to_cache_key := OE_Bulk_Cache.load_loc_info(OE_Bulk_Order_PVT.G_LINE_REC.ship_to_org_id(l_index));
808: l_ship_to_cust_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).CUST_ACCOUNT_ID;
809: l_ship_to_postal_code := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).POSTAL_CODE;
810: l_ship_location_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).LOC_ID;
811: l_ship_to_state := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).STATE;
827: zx_global_structures_pkg.trx_line_dist_tbl.SHIP_TO_PARTY_ID(l_index) := l_ship_party_id; --1001;
828: zx_global_structures_pkg.trx_line_dist_tbl.SHIP_TO_PARTY_SITE_ID(l_index) := l_ship_party_site_id;--1024;
829: zx_global_structures_pkg.trx_line_dist_tbl.SHIP_TO_LOCATION_ID(l_index) := l_ship_location_id;--1067;
830: zx_global_structures_pkg.trx_line_dist_tbl.SHIP_THIRD_PTY_ACCT_SITE_ID(l_index) := l_ship_to_cust_acct_site_id;--1024;
831: zx_global_structures_pkg.trx_line_dist_tbl.SHIP_TO_CUST_ACCT_SITE_USE_ID(l_index) := OE_Bulk_Order_PVT.G_LINE_REC.ship_to_org_id(l_index);--1007;
832: zx_global_structures_pkg.trx_line_dist_tbl.SHIP_THIRD_PTY_ACCT_ID(l_index) := l_ship_to_cust_account_id;--1001;
833:
834:
835: -- populate invoice_to info if invoice_to_org_id is not null
832: zx_global_structures_pkg.trx_line_dist_tbl.SHIP_THIRD_PTY_ACCT_ID(l_index) := l_ship_to_cust_account_id;--1001;
833:
834:
835: -- populate invoice_to info if invoice_to_org_id is not null
836: IF OE_Bulk_Order_PVT.G_LINE_REC.invoice_to_org_id(l_index) IS NOT NULL
837: THEN
838: IF l_debug_level > 0 THEN
839: oe_debug_pub.add( 'retrieving bill_to info');
840: END IF;
837: THEN
838: IF l_debug_level > 0 THEN
839: oe_debug_pub.add( 'retrieving bill_to info');
840: END IF;
841: l_invoice_to_cache_key := OE_Bulk_Cache.load_loc_info(OE_Bulk_Order_PVT.G_LINE_REC.invoice_to_org_id(l_index));
842: l_bill_to_cust_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).CUST_ACCOUNT_ID;
843: l_bill_to_postal_code := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).POSTAL_CODE;
844: l_bill_location_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).LOC_ID;
845: l_bill_to_state := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).STATE;
855: l_bill_to_acct_tax_rnd_rule := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).ACCT_TAX_ROUNDING_RULE;
856: END IF; --end of if invoice_to_org_id IS NOT NULL
857:
858:
859: l_legal_entity_id := get_le_id(p_order_type_id => OE_Bulk_Order_PVT.G_HEADER_REC.order_type_id(l_header_index)
860: , p_sold_to_customer_id => OE_Bulk_Order_PVT.G_HEADER_REC.sold_to_org_id(l_header_index)
861: , p_bill_to_customer_id => l_bill_to_cust_id
862: , p_org_id => OE_Bulk_Order_PVT.G_HEADER_REC.org_id(l_header_index)
863: );
856: END IF; --end of if invoice_to_org_id IS NOT NULL
857:
858:
859: l_legal_entity_id := get_le_id(p_order_type_id => OE_Bulk_Order_PVT.G_HEADER_REC.order_type_id(l_header_index)
860: , p_sold_to_customer_id => OE_Bulk_Order_PVT.G_HEADER_REC.sold_to_org_id(l_header_index)
861: , p_bill_to_customer_id => l_bill_to_cust_id
862: , p_org_id => OE_Bulk_Order_PVT.G_HEADER_REC.org_id(l_header_index)
863: );
864:
858:
859: l_legal_entity_id := get_le_id(p_order_type_id => OE_Bulk_Order_PVT.G_HEADER_REC.order_type_id(l_header_index)
860: , p_sold_to_customer_id => OE_Bulk_Order_PVT.G_HEADER_REC.sold_to_org_id(l_header_index)
861: , p_bill_to_customer_id => l_bill_to_cust_id
862: , p_org_id => OE_Bulk_Order_PVT.G_HEADER_REC.org_id(l_header_index)
863: );
864:
865:
866: oe_debug_pub.add( ' Assign Bill To info ');
872: zx_global_structures_pkg.trx_line_dist_tbl.BILL_TO_PARTY_ID(l_index) := l_bill_party_id;
873: zx_global_structures_pkg.trx_line_dist_tbl.BILL_TO_PARTY_SITE_ID(l_index) := l_bill_party_site_id; --1024;
874: zx_global_structures_pkg.trx_line_dist_tbl.BILL_TO_LOCATION_ID(l_index) := l_bill_location_id;--1067;
875: zx_global_structures_pkg.trx_line_dist_tbl.BILL_THIRD_PTY_ACCT_SITE_ID(l_index) := l_bill_to_cust_acct_site_id;--1024;
876: zx_global_structures_pkg.trx_line_dist_tbl.BILL_TO_CUST_ACCT_SITE_USE_ID(l_index) := OE_Bulk_Order_PVT.G_LINE_REC.invoice_to_org_id(l_index);--1006;
877: zx_global_structures_pkg.trx_line_dist_tbl.BILL_THIRD_PTY_ACCT_ID(l_index) := l_bill_to_cust_account_id;
878:
879:
880: oe_debug_pub.add( ' Assign other values ',1);
882:
883: zx_global_structures_pkg.trx_line_dist_tbl.APPLICATION_ID(l_index) := 660;
884: zx_global_structures_pkg.trx_line_dist_tbl.ENTITY_CODE(l_index) := 'OE_ORDER_HEADERS';
885: zx_global_structures_pkg.trx_line_dist_tbl.EVENT_CLASS_CODE(l_index) := 'SALES_TRANSACTION_TAX_QUOTE';
886: zx_global_structures_pkg.trx_line_dist_tbl.TRX_ID(l_index) := OE_Bulk_Order_PVT.G_Line_Rec.header_id(l_index);
887: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LEVEL_TYPE(l_index) := 'LINE';
888:
889: zx_global_structures_pkg.trx_line_dist_tbl.INTERNAL_ORGANIZATION_ID(l_index) := OE_Bulk_Order_PVT.G_Header_Rec.org_id(l_header_index);
890: zx_global_structures_pkg.trx_line_dist_tbl.EVENT_TYPE_CODE(l_index) := 'CREATE';
885: zx_global_structures_pkg.trx_line_dist_tbl.EVENT_CLASS_CODE(l_index) := 'SALES_TRANSACTION_TAX_QUOTE';
886: zx_global_structures_pkg.trx_line_dist_tbl.TRX_ID(l_index) := OE_Bulk_Order_PVT.G_Line_Rec.header_id(l_index);
887: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LEVEL_TYPE(l_index) := 'LINE';
888:
889: zx_global_structures_pkg.trx_line_dist_tbl.INTERNAL_ORGANIZATION_ID(l_index) := OE_Bulk_Order_PVT.G_Header_Rec.org_id(l_header_index);
890: zx_global_structures_pkg.trx_line_dist_tbl.EVENT_TYPE_CODE(l_index) := 'CREATE';
891:
892: zx_global_structures_pkg.trx_line_dist_tbl.TRX_DATE(l_index) := OE_Bulk_Order_PVT.G_Line_Rec.TAX_DATE(l_index);
893:
888:
889: zx_global_structures_pkg.trx_line_dist_tbl.INTERNAL_ORGANIZATION_ID(l_index) := OE_Bulk_Order_PVT.G_Header_Rec.org_id(l_header_index);
890: zx_global_structures_pkg.trx_line_dist_tbl.EVENT_TYPE_CODE(l_index) := 'CREATE';
891:
892: zx_global_structures_pkg.trx_line_dist_tbl.TRX_DATE(l_index) := OE_Bulk_Order_PVT.G_Line_Rec.TAX_DATE(l_index);
893:
894: zx_global_structures_pkg.trx_line_dist_tbl.TRX_DOC_REVISION(l_index) := NULL; -- VARCHAR2_150_tbl_type ,
895: zx_global_structures_pkg.trx_line_dist_tbl.LEDGER_ID(l_index) := l_AR_Sys_Param_Rec.set_of_books_id;
896: zx_global_structures_pkg.trx_line_dist_tbl.TRX_CURRENCY_CODE(l_index) := OE_Bulk_Order_PVT.G_Header_Rec.transactional_curr_code(l_header_index);
892: zx_global_structures_pkg.trx_line_dist_tbl.TRX_DATE(l_index) := OE_Bulk_Order_PVT.G_Line_Rec.TAX_DATE(l_index);
893:
894: zx_global_structures_pkg.trx_line_dist_tbl.TRX_DOC_REVISION(l_index) := NULL; -- VARCHAR2_150_tbl_type ,
895: zx_global_structures_pkg.trx_line_dist_tbl.LEDGER_ID(l_index) := l_AR_Sys_Param_Rec.set_of_books_id;
896: zx_global_structures_pkg.trx_line_dist_tbl.TRX_CURRENCY_CODE(l_index) := OE_Bulk_Order_PVT.G_Header_Rec.transactional_curr_code(l_header_index);
897: oe_debug_pub.add( '1:');
898:
899: zx_global_structures_pkg.trx_line_dist_tbl.CURRENCY_CONVERSION_DATE(l_index) := OE_Bulk_Order_PVT.G_Header_Rec.conversion_rate_Date(l_header_index);
900: zx_global_structures_pkg.trx_line_dist_tbl.CURRENCY_CONVERSION_RATE(l_index) := OE_Bulk_Order_PVT.G_Header_Rec.conversion_rate(l_header_index);
895: zx_global_structures_pkg.trx_line_dist_tbl.LEDGER_ID(l_index) := l_AR_Sys_Param_Rec.set_of_books_id;
896: zx_global_structures_pkg.trx_line_dist_tbl.TRX_CURRENCY_CODE(l_index) := OE_Bulk_Order_PVT.G_Header_Rec.transactional_curr_code(l_header_index);
897: oe_debug_pub.add( '1:');
898:
899: zx_global_structures_pkg.trx_line_dist_tbl.CURRENCY_CONVERSION_DATE(l_index) := OE_Bulk_Order_PVT.G_Header_Rec.conversion_rate_Date(l_header_index);
900: zx_global_structures_pkg.trx_line_dist_tbl.CURRENCY_CONVERSION_RATE(l_index) := OE_Bulk_Order_PVT.G_Header_Rec.conversion_rate(l_header_index);
901: zx_global_structures_pkg.trx_line_dist_tbl.CURRENCY_CONVERSION_TYPE(l_index) := OE_Bulk_Order_PVT.G_Header_Rec.CONVERSION_TYPE_CODE(l_header_index);
902: zx_global_structures_pkg.trx_line_dist_tbl.MINIMUM_ACCOUNTABLE_UNIT(l_index) := G_MINIMUM_ACCOUNTABLE_UNIT;
903: zx_global_structures_pkg.trx_line_dist_tbl.PRECISION(l_index) := l_precision;
896: zx_global_structures_pkg.trx_line_dist_tbl.TRX_CURRENCY_CODE(l_index) := OE_Bulk_Order_PVT.G_Header_Rec.transactional_curr_code(l_header_index);
897: oe_debug_pub.add( '1:');
898:
899: zx_global_structures_pkg.trx_line_dist_tbl.CURRENCY_CONVERSION_DATE(l_index) := OE_Bulk_Order_PVT.G_Header_Rec.conversion_rate_Date(l_header_index);
900: zx_global_structures_pkg.trx_line_dist_tbl.CURRENCY_CONVERSION_RATE(l_index) := OE_Bulk_Order_PVT.G_Header_Rec.conversion_rate(l_header_index);
901: zx_global_structures_pkg.trx_line_dist_tbl.CURRENCY_CONVERSION_TYPE(l_index) := OE_Bulk_Order_PVT.G_Header_Rec.CONVERSION_TYPE_CODE(l_header_index);
902: zx_global_structures_pkg.trx_line_dist_tbl.MINIMUM_ACCOUNTABLE_UNIT(l_index) := G_MINIMUM_ACCOUNTABLE_UNIT;
903: zx_global_structures_pkg.trx_line_dist_tbl.PRECISION(l_index) := l_precision;
904: -- revisit the logic to derive legal_entity_id later when legal_entity_id approach is clarified.
897: oe_debug_pub.add( '1:');
898:
899: zx_global_structures_pkg.trx_line_dist_tbl.CURRENCY_CONVERSION_DATE(l_index) := OE_Bulk_Order_PVT.G_Header_Rec.conversion_rate_Date(l_header_index);
900: zx_global_structures_pkg.trx_line_dist_tbl.CURRENCY_CONVERSION_RATE(l_index) := OE_Bulk_Order_PVT.G_Header_Rec.conversion_rate(l_header_index);
901: zx_global_structures_pkg.trx_line_dist_tbl.CURRENCY_CONVERSION_TYPE(l_index) := OE_Bulk_Order_PVT.G_Header_Rec.CONVERSION_TYPE_CODE(l_header_index);
902: zx_global_structures_pkg.trx_line_dist_tbl.MINIMUM_ACCOUNTABLE_UNIT(l_index) := G_MINIMUM_ACCOUNTABLE_UNIT;
903: zx_global_structures_pkg.trx_line_dist_tbl.PRECISION(l_index) := l_precision;
904: -- revisit the logic to derive legal_entity_id later when legal_entity_id approach is clarified.
905: zx_global_structures_pkg.trx_line_dist_tbl.LEGAL_ENTITY_ID(l_index) := l_legal_entity_id; -- NUMBER_tbl_type ,
904: -- revisit the logic to derive legal_entity_id later when legal_entity_id approach is clarified.
905: zx_global_structures_pkg.trx_line_dist_tbl.LEGAL_ENTITY_ID(l_index) := l_legal_entity_id; -- NUMBER_tbl_type ,
906: zx_global_structures_pkg.trx_line_dist_tbl.ESTABLISHMENT_ID(l_index) := NULL; -- NUMBER_tbl_type ,
907: zx_global_structures_pkg.trx_line_dist_tbl.APPLIED_FROM_TRX_NUMBER(l_index) := NULL; -- VARCHAR2_150_tbl_type ,
908: zx_global_structures_pkg.trx_line_dist_tbl.TRX_NUMBER(l_index) := OE_Bulk_Order_PVT.G_Header_Rec.order_number(l_header_index);
909: oe_debug_pub.add( '2:');
910: zx_global_structures_pkg.trx_line_dist_tbl.TRX_DESCRIPTION(l_index) := NULL; -- VARCHAR2_240_tbl_type ,
911: zx_global_structures_pkg.trx_line_dist_tbl.TRX_COMMUNICATED_DATE(l_index) := NULL; -- DATE_tbl_type ,
912: zx_global_structures_pkg.trx_line_dist_tbl.BATCH_SOURCE_ID(l_index) := NULL; -- NUMBER_tbl_type ,
956: --zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_MAU(l_index) := NULL; -- NUMBER_tbl_type ,
957: --zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_PRECISION(l_index) := NULL; -- NUMBER_tbl_type ,
958: zx_global_structures_pkg.trx_line_dist_tbl.LINE_INTENDED_USE(l_index) := NULL; -- VARCHAR2_240_tbl_type ,
959: zx_global_structures_pkg.trx_line_dist_tbl.INPUT_TAX_CLASSIFICATION_CODE(l_index) := NULL; -- VARCHAR2_30_tbl_type ,
960: zx_global_structures_pkg.trx_line_dist_tbl.EXEMPTION_CONTROL_FLAG(l_index) := OE_Bulk_Order_PVT.G_Line_Rec.TAX_EXEMPT_FLAG(l_index);
961: oe_debug_pub.add( '4:');
962: zx_global_structures_pkg.trx_line_dist_tbl.EXEMPT_REASON_CODE(l_index) := OE_Bulk_Order_PVT.G_Line_Rec.TAX_EXEMPT_REASON_CODE(l_index);
963: oe_debug_pub.add( '44:');
964: zx_global_structures_pkg.trx_line_dist_tbl.INTERFACE_ENTITY_CODE(l_index) := NULL; -- VARCHAR2_30_tbl_type,
958: zx_global_structures_pkg.trx_line_dist_tbl.LINE_INTENDED_USE(l_index) := NULL; -- VARCHAR2_240_tbl_type ,
959: zx_global_structures_pkg.trx_line_dist_tbl.INPUT_TAX_CLASSIFICATION_CODE(l_index) := NULL; -- VARCHAR2_30_tbl_type ,
960: zx_global_structures_pkg.trx_line_dist_tbl.EXEMPTION_CONTROL_FLAG(l_index) := OE_Bulk_Order_PVT.G_Line_Rec.TAX_EXEMPT_FLAG(l_index);
961: oe_debug_pub.add( '4:');
962: zx_global_structures_pkg.trx_line_dist_tbl.EXEMPT_REASON_CODE(l_index) := OE_Bulk_Order_PVT.G_Line_Rec.TAX_EXEMPT_REASON_CODE(l_index);
963: oe_debug_pub.add( '44:');
964: zx_global_structures_pkg.trx_line_dist_tbl.INTERFACE_ENTITY_CODE(l_index) := NULL; -- VARCHAR2_30_tbl_type,
965: zx_global_structures_pkg.trx_line_dist_tbl.INTERFACE_LINE_ID(l_index) := NULL; -- NUMBER_tbl_type,
966: zx_global_structures_pkg.trx_line_dist_tbl.HISTORICAL_TAX_CODE_ID(l_index) := NULL; -- NUMBER_tbl_type,
964: zx_global_structures_pkg.trx_line_dist_tbl.INTERFACE_ENTITY_CODE(l_index) := NULL; -- VARCHAR2_30_tbl_type,
965: zx_global_structures_pkg.trx_line_dist_tbl.INTERFACE_LINE_ID(l_index) := NULL; -- NUMBER_tbl_type,
966: zx_global_structures_pkg.trx_line_dist_tbl.HISTORICAL_TAX_CODE_ID(l_index) := NULL; -- NUMBER_tbl_type,
967:
968: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_ID(l_index) := OE_Bulk_Order_PVT.G_Line_Rec.Line_Id(l_index);
969: oe_debug_pub.add( '444:');
970: zx_global_structures_pkg.trx_line_dist_tbl.LINE_CLASS(l_index) := 'INVOICE';
971: zx_global_structures_pkg.trx_line_dist_tbl.LINE_LEVEL_ACTION(l_index) := 'CREATE';
972: oe_debug_pub.add( '441:');
969: oe_debug_pub.add( '444:');
970: zx_global_structures_pkg.trx_line_dist_tbl.LINE_CLASS(l_index) := 'INVOICE';
971: zx_global_structures_pkg.trx_line_dist_tbl.LINE_LEVEL_ACTION(l_index) := 'CREATE';
972: oe_debug_pub.add( '441:');
973: -- zx_global_structures_pkg.trx_line_dist_tbl.TRX_SHIPPING_DATE(l_index) := Nvl(OE_Bulk_Order_PVT.G_Line_Rec.actual_shipment_date(l_index), OE_Bulk_Order_PVT.G_Line_Rec.schedule_ship_date(l_index)); -- l_trx_shipping_date;
974: oe_debug_pub.add( '412');
975: zx_global_structures_pkg.trx_line_dist_tbl.TRX_RECEIPT_DATE(l_index) := NULL ;
976: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_TYPE(l_index) := 'LINE';
977: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_DATE(l_index) := OE_Bulk_Order_PVT.G_Line_Rec.tax_date(l_index);
973: -- zx_global_structures_pkg.trx_line_dist_tbl.TRX_SHIPPING_DATE(l_index) := Nvl(OE_Bulk_Order_PVT.G_Line_Rec.actual_shipment_date(l_index), OE_Bulk_Order_PVT.G_Line_Rec.schedule_ship_date(l_index)); -- l_trx_shipping_date;
974: oe_debug_pub.add( '412');
975: zx_global_structures_pkg.trx_line_dist_tbl.TRX_RECEIPT_DATE(l_index) := NULL ;
976: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_TYPE(l_index) := 'LINE';
977: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_DATE(l_index) := OE_Bulk_Order_PVT.G_Line_Rec.tax_date(l_index);
978: oe_debug_pub.add( '5:');
979: IF OE_Bulk_Order_PVT.G_Line_Rec.global_attribute_category(l_index) IN
980: ('JL.AR.OEXOEORD.LINES',
981: 'JL.BR.OEXOEORD.LINES',
975: zx_global_structures_pkg.trx_line_dist_tbl.TRX_RECEIPT_DATE(l_index) := NULL ;
976: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_TYPE(l_index) := 'LINE';
977: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_DATE(l_index) := OE_Bulk_Order_PVT.G_Line_Rec.tax_date(l_index);
978: oe_debug_pub.add( '5:');
979: IF OE_Bulk_Order_PVT.G_Line_Rec.global_attribute_category(l_index) IN
980: ('JL.AR.OEXOEORD.LINES',
981: 'JL.BR.OEXOEORD.LINES',
982: 'JL.CO.OEXOEORD.LINES') THEN
983: zx_global_structures_pkg.trx_line_dist_tbl.TRX_BUSINESS_CATEGORY(l_index) := OE_Bulk_Order_PVT.G_Line_Rec.global_attribute6(l_index); --l_trx_business_category;
979: IF OE_Bulk_Order_PVT.G_Line_Rec.global_attribute_category(l_index) IN
980: ('JL.AR.OEXOEORD.LINES',
981: 'JL.BR.OEXOEORD.LINES',
982: 'JL.CO.OEXOEORD.LINES') THEN
983: zx_global_structures_pkg.trx_line_dist_tbl.TRX_BUSINESS_CATEGORY(l_index) := OE_Bulk_Order_PVT.G_Line_Rec.global_attribute6(l_index); --l_trx_business_category;
984: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_FISC_CLASSIFICATION(l_index):= OE_Bulk_Order_PVT.G_Line_Rec.global_attribute5(l_index);
985: ELSE
986: zx_global_structures_pkg.trx_line_dist_tbl.TRX_BUSINESS_CATEGORY(l_index) := NULL;
987: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_FISC_CLASSIFICATION(l_index):= NULL;
980: ('JL.AR.OEXOEORD.LINES',
981: 'JL.BR.OEXOEORD.LINES',
982: 'JL.CO.OEXOEORD.LINES') THEN
983: zx_global_structures_pkg.trx_line_dist_tbl.TRX_BUSINESS_CATEGORY(l_index) := OE_Bulk_Order_PVT.G_Line_Rec.global_attribute6(l_index); --l_trx_business_category;
984: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_FISC_CLASSIFICATION(l_index):= OE_Bulk_Order_PVT.G_Line_Rec.global_attribute5(l_index);
985: ELSE
986: zx_global_structures_pkg.trx_line_dist_tbl.TRX_BUSINESS_CATEGORY(l_index) := NULL;
987: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_FISC_CLASSIFICATION(l_index):= NULL;
988: END IF;
989: oe_debug_pub.add( '6:');
990: zx_global_structures_pkg.trx_line_dist_tbl.LINE_INTENDED_USE(l_index) := NULL;
991: zx_global_structures_pkg.trx_line_dist_tbl.USER_DEFINED_FISC_CLASS(l_index) := NULL;
992: zx_global_structures_pkg.trx_line_dist_tbl.LINE_AMT_INCLUDES_TAX_FLAG(l_index) := 'S';
993: zx_global_structures_pkg.trx_line_dist_tbl.LINE_AMT(l_index) := OE_Bulk_Order_PVT.G_Line_Rec. ordered_quantity (l_index) * OE_Bulk_Order_PVT.G_Line_Rec.unit_selling_price(l_index);
994: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_QUANTITY(l_index) := OE_Bulk_Order_PVT.G_Line_Rec. ordered_quantity (l_index);
995: zx_global_structures_pkg.trx_line_dist_tbl.UNIT_PRICE(l_index) := OE_Bulk_Order_PVT.G_Line_Rec.unit_selling_price(l_index);
996: zx_global_structures_pkg.trx_line_dist_tbl.EXEMPT_CERTIFICATE_NUMBER(l_index) := OE_Bulk_Order_PVT.G_Line_Rec.tax_exempt_number(l_index);
997: zx_global_structures_pkg.trx_line_dist_tbl.EXEMPT_REASON(l_index) := OE_Bulk_Order_PVT.G_Line_Rec.TAX_EXEMPT_REASON_CODE(l_index);
990: zx_global_structures_pkg.trx_line_dist_tbl.LINE_INTENDED_USE(l_index) := NULL;
991: zx_global_structures_pkg.trx_line_dist_tbl.USER_DEFINED_FISC_CLASS(l_index) := NULL;
992: zx_global_structures_pkg.trx_line_dist_tbl.LINE_AMT_INCLUDES_TAX_FLAG(l_index) := 'S';
993: zx_global_structures_pkg.trx_line_dist_tbl.LINE_AMT(l_index) := OE_Bulk_Order_PVT.G_Line_Rec. ordered_quantity (l_index) * OE_Bulk_Order_PVT.G_Line_Rec.unit_selling_price(l_index);
994: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_QUANTITY(l_index) := OE_Bulk_Order_PVT.G_Line_Rec. ordered_quantity (l_index);
995: zx_global_structures_pkg.trx_line_dist_tbl.UNIT_PRICE(l_index) := OE_Bulk_Order_PVT.G_Line_Rec.unit_selling_price(l_index);
996: zx_global_structures_pkg.trx_line_dist_tbl.EXEMPT_CERTIFICATE_NUMBER(l_index) := OE_Bulk_Order_PVT.G_Line_Rec.tax_exempt_number(l_index);
997: zx_global_structures_pkg.trx_line_dist_tbl.EXEMPT_REASON(l_index) := OE_Bulk_Order_PVT.G_Line_Rec.TAX_EXEMPT_REASON_CODE(l_index);
998: oe_debug_pub.add( '7:');
991: zx_global_structures_pkg.trx_line_dist_tbl.USER_DEFINED_FISC_CLASS(l_index) := NULL;
992: zx_global_structures_pkg.trx_line_dist_tbl.LINE_AMT_INCLUDES_TAX_FLAG(l_index) := 'S';
993: zx_global_structures_pkg.trx_line_dist_tbl.LINE_AMT(l_index) := OE_Bulk_Order_PVT.G_Line_Rec. ordered_quantity (l_index) * OE_Bulk_Order_PVT.G_Line_Rec.unit_selling_price(l_index);
994: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_QUANTITY(l_index) := OE_Bulk_Order_PVT.G_Line_Rec. ordered_quantity (l_index);
995: zx_global_structures_pkg.trx_line_dist_tbl.UNIT_PRICE(l_index) := OE_Bulk_Order_PVT.G_Line_Rec.unit_selling_price(l_index);
996: zx_global_structures_pkg.trx_line_dist_tbl.EXEMPT_CERTIFICATE_NUMBER(l_index) := OE_Bulk_Order_PVT.G_Line_Rec.tax_exempt_number(l_index);
997: zx_global_structures_pkg.trx_line_dist_tbl.EXEMPT_REASON(l_index) := OE_Bulk_Order_PVT.G_Line_Rec.TAX_EXEMPT_REASON_CODE(l_index);
998: oe_debug_pub.add( '7:');
999: zx_global_structures_pkg.trx_line_dist_tbl.CASH_DISCOUNT(l_index) := NULL;
992: zx_global_structures_pkg.trx_line_dist_tbl.LINE_AMT_INCLUDES_TAX_FLAG(l_index) := 'S';
993: zx_global_structures_pkg.trx_line_dist_tbl.LINE_AMT(l_index) := OE_Bulk_Order_PVT.G_Line_Rec. ordered_quantity (l_index) * OE_Bulk_Order_PVT.G_Line_Rec.unit_selling_price(l_index);
994: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_QUANTITY(l_index) := OE_Bulk_Order_PVT.G_Line_Rec. ordered_quantity (l_index);
995: zx_global_structures_pkg.trx_line_dist_tbl.UNIT_PRICE(l_index) := OE_Bulk_Order_PVT.G_Line_Rec.unit_selling_price(l_index);
996: zx_global_structures_pkg.trx_line_dist_tbl.EXEMPT_CERTIFICATE_NUMBER(l_index) := OE_Bulk_Order_PVT.G_Line_Rec.tax_exempt_number(l_index);
997: zx_global_structures_pkg.trx_line_dist_tbl.EXEMPT_REASON(l_index) := OE_Bulk_Order_PVT.G_Line_Rec.TAX_EXEMPT_REASON_CODE(l_index);
998: oe_debug_pub.add( '7:');
999: zx_global_structures_pkg.trx_line_dist_tbl.CASH_DISCOUNT(l_index) := NULL;
1000: zx_global_structures_pkg.trx_line_dist_tbl.VOLUME_DISCOUNT(l_index) := NULL;
993: zx_global_structures_pkg.trx_line_dist_tbl.LINE_AMT(l_index) := OE_Bulk_Order_PVT.G_Line_Rec. ordered_quantity (l_index) * OE_Bulk_Order_PVT.G_Line_Rec.unit_selling_price(l_index);
994: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_QUANTITY(l_index) := OE_Bulk_Order_PVT.G_Line_Rec. ordered_quantity (l_index);
995: zx_global_structures_pkg.trx_line_dist_tbl.UNIT_PRICE(l_index) := OE_Bulk_Order_PVT.G_Line_Rec.unit_selling_price(l_index);
996: zx_global_structures_pkg.trx_line_dist_tbl.EXEMPT_CERTIFICATE_NUMBER(l_index) := OE_Bulk_Order_PVT.G_Line_Rec.tax_exempt_number(l_index);
997: zx_global_structures_pkg.trx_line_dist_tbl.EXEMPT_REASON(l_index) := OE_Bulk_Order_PVT.G_Line_Rec.TAX_EXEMPT_REASON_CODE(l_index);
998: oe_debug_pub.add( '7:');
999: zx_global_structures_pkg.trx_line_dist_tbl.CASH_DISCOUNT(l_index) := NULL;
1000: zx_global_structures_pkg.trx_line_dist_tbl.VOLUME_DISCOUNT(l_index) := NULL;
1001: zx_global_structures_pkg.trx_line_dist_tbl.TRADING_DISCOUNT(l_index) := NULL;
1002: zx_global_structures_pkg.trx_line_dist_tbl.TRANSFER_CHARGE(l_index) := NULL ;
1003: zx_global_structures_pkg.trx_line_dist_tbl.TRANSPORTATION_CHARGE(l_index) := NULL;
1004: zx_global_structures_pkg.trx_line_dist_tbl.INSURANCE_CHARGE(l_index) := NULL;
1005: zx_global_structures_pkg.trx_line_dist_tbl.OTHER_CHARGE(l_index) := NULL;
1006: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_ID(l_index) := OE_Bulk_Order_PVT.G_Line_Rec.inventory_item_id(l_index);
1007: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_ORG_ID(l_index) := NVL(OE_Bulk_Order_PVT.G_Line_Rec.ship_from_org_id(l_index),l_inventory_org_id);
1008: oe_debug_pub.add( '8:');
1009: zx_global_structures_pkg.trx_line_dist_tbl.UOM_CODE(l_index) :=NVL( OE_Bulk_Order_PVT.G_Line_Rec.order_quantity_uom (l_index), OE_Bulk_Order_PVT.G_Line_Rec.pricing_quantity_uom(l_index));
1010: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_TYPE(l_index) := NULL;
1003: zx_global_structures_pkg.trx_line_dist_tbl.TRANSPORTATION_CHARGE(l_index) := NULL;
1004: zx_global_structures_pkg.trx_line_dist_tbl.INSURANCE_CHARGE(l_index) := NULL;
1005: zx_global_structures_pkg.trx_line_dist_tbl.OTHER_CHARGE(l_index) := NULL;
1006: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_ID(l_index) := OE_Bulk_Order_PVT.G_Line_Rec.inventory_item_id(l_index);
1007: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_ORG_ID(l_index) := NVL(OE_Bulk_Order_PVT.G_Line_Rec.ship_from_org_id(l_index),l_inventory_org_id);
1008: oe_debug_pub.add( '8:');
1009: zx_global_structures_pkg.trx_line_dist_tbl.UOM_CODE(l_index) :=NVL( OE_Bulk_Order_PVT.G_Line_Rec.order_quantity_uom (l_index), OE_Bulk_Order_PVT.G_Line_Rec.pricing_quantity_uom(l_index));
1010: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_TYPE(l_index) := NULL;
1011: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_CODE(l_index) := NULL;
1005: zx_global_structures_pkg.trx_line_dist_tbl.OTHER_CHARGE(l_index) := NULL;
1006: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_ID(l_index) := OE_Bulk_Order_PVT.G_Line_Rec.inventory_item_id(l_index);
1007: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_ORG_ID(l_index) := NVL(OE_Bulk_Order_PVT.G_Line_Rec.ship_from_org_id(l_index),l_inventory_org_id);
1008: oe_debug_pub.add( '8:');
1009: zx_global_structures_pkg.trx_line_dist_tbl.UOM_CODE(l_index) :=NVL( OE_Bulk_Order_PVT.G_Line_Rec.order_quantity_uom (l_index), OE_Bulk_Order_PVT.G_Line_Rec.pricing_quantity_uom(l_index));
1010: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_TYPE(l_index) := NULL;
1011: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_CODE(l_index) := NULL;
1012: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_CATEGORY(l_index) := NULL;
1013: zx_global_structures_pkg.trx_line_dist_tbl.TRX_SIC_CODE(l_index) := NULL ;
1010: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_TYPE(l_index) := NULL;
1011: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_CODE(l_index) := NULL;
1012: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_CATEGORY(l_index) := NULL;
1013: zx_global_structures_pkg.trx_line_dist_tbl.TRX_SIC_CODE(l_index) := NULL ;
1014: zx_global_structures_pkg.trx_line_dist_tbl.FOB_POINT(l_index) := OE_Bulk_Order_PVT.G_Line_Rec.fob_point_code(l_index);
1015: zx_global_structures_pkg.trx_line_dist_tbl.SHIP_FROM_PARTY_ID(l_index):= OE_Bulk_Order_PVT.G_Line_Rec.ship_from_org_id(l_index);
1016: zx_global_structures_pkg.trx_line_dist_tbl.POA_PARTY_ID(l_index) := l_header_org_id;
1017: oe_debug_pub.add( '9:');
1018: zx_global_structures_pkg.trx_line_dist_tbl.POO_PARTY_ID(l_index) := l_asgn_org_id; -- Load it from person_id cache ->asgn_org_id;
1011: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_CODE(l_index) := NULL;
1012: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_CATEGORY(l_index) := NULL;
1013: zx_global_structures_pkg.trx_line_dist_tbl.TRX_SIC_CODE(l_index) := NULL ;
1014: zx_global_structures_pkg.trx_line_dist_tbl.FOB_POINT(l_index) := OE_Bulk_Order_PVT.G_Line_Rec.fob_point_code(l_index);
1015: zx_global_structures_pkg.trx_line_dist_tbl.SHIP_FROM_PARTY_ID(l_index):= OE_Bulk_Order_PVT.G_Line_Rec.ship_from_org_id(l_index);
1016: zx_global_structures_pkg.trx_line_dist_tbl.POA_PARTY_ID(l_index) := l_header_org_id;
1017: oe_debug_pub.add( '9:');
1018: zx_global_structures_pkg.trx_line_dist_tbl.POO_PARTY_ID(l_index) := l_asgn_org_id; -- Load it from person_id cache ->asgn_org_id;
1019: zx_global_structures_pkg.trx_line_dist_tbl.BILL_FROM_PARTY_ID(l_index):= NULL;
1050: zx_global_structures_pkg.trx_line_dist_tbl.REF_DOC_DIST_ID(l_index) := NULL; -- NUMBER_tbl_type ,
1051: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_DIST_TAX_AMT(l_index) := NULL; -- NUMBER_tbl_type ,
1052: oe_debug_pub.add( '10:');
1053: zx_global_structures_pkg.trx_line_dist_tbl.ASSESSABLE_VALUE(l_index) := NULL ;
1054: zx_global_structures_pkg.trx_line_dist_tbl.OUTPUT_TAX_CLASSIFICATION_CODE(l_index) := OE_Bulk_Order_PVT.G_Line_Rec.tax_code(l_index);
1055: zx_global_structures_pkg.trx_line_dist_tbl.TRX_ID_LEVEL2(l_index) := NULL;
1056: zx_global_structures_pkg.trx_line_dist_tbl.TRX_ID_LEVEL3(l_index) := NULL;
1057: zx_global_structures_pkg.trx_line_dist_tbl.TRX_ID_LEVEL4(l_index) := NULL;
1058: zx_global_structures_pkg.trx_line_dist_tbl.TRX_ID_LEVEL5(l_index) := NULL;
1068: zx_global_structures_pkg.trx_line_dist_tbl.LINE_TRX_USER_KEY3(l_index):= NULL;
1069: zx_global_structures_pkg.trx_line_dist_tbl.LINE_TRX_USER_KEY4(l_index):= NULL;
1070: zx_global_structures_pkg.trx_line_dist_tbl.LINE_TRX_USER_KEY5(l_index):= NULL;
1071: zx_global_structures_pkg.trx_line_dist_tbl.LINE_TRX_USER_KEY6(l_index):= NULL;
1072: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_NUMBER(l_index) := OE_Bulk_Order_PVT.G_Line_Rec.line_number(l_index);
1073: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_DIST_ID(l_index) := NULL;
1074: zx_global_structures_pkg.trx_line_dist_tbl.DIST_TRX_USER_KEY1(l_index) := NULL;
1075: zx_global_structures_pkg.trx_line_dist_tbl.DIST_TRX_USER_KEY2(l_index) := NULL;
1076: zx_global_structures_pkg.trx_line_dist_tbl.DIST_TRX_USER_KEY3(l_index) := NULL;
1080: zx_global_structures_pkg.trx_line_dist_tbl.HISTORICAL_FLAG(l_index) :='N';
1081: zx_global_structures_pkg.trx_line_dist_tbl.CTRL_HDR_TX_APPL_FLAG(l_index) :='N';
1082: zx_global_structures_pkg.trx_line_dist_tbl.CTRL_TOTAL_LINE_TX_AMT(l_index) :=NULL;
1083: oe_debug_pub.add( '11:');
1084: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_DESCRIPTION(l_index) := OE_Bulk_Order_PVT.G_Line_Rec. user_item_description (l_index);
1085: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_DESCRIPTION(l_index) := OE_Bulk_Order_PVT.G_Line_Rec. user_item_description (l_index);
1086: zx_global_structures_pkg.trx_line_dist_tbl.TRX_WAYBILL_NUMBER(l_index) := NULL;
1087: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_GL_DATE(l_index) := NULL;
1088: zx_global_structures_pkg.trx_line_dist_tbl.MERCHANT_PARTY_NAME(l_index) := NULL;
1081: zx_global_structures_pkg.trx_line_dist_tbl.CTRL_HDR_TX_APPL_FLAG(l_index) :='N';
1082: zx_global_structures_pkg.trx_line_dist_tbl.CTRL_TOTAL_LINE_TX_AMT(l_index) :=NULL;
1083: oe_debug_pub.add( '11:');
1084: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_DESCRIPTION(l_index) := OE_Bulk_Order_PVT.G_Line_Rec. user_item_description (l_index);
1085: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_DESCRIPTION(l_index) := OE_Bulk_Order_PVT.G_Line_Rec. user_item_description (l_index);
1086: zx_global_structures_pkg.trx_line_dist_tbl.TRX_WAYBILL_NUMBER(l_index) := NULL;
1087: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_GL_DATE(l_index) := NULL;
1088: zx_global_structures_pkg.trx_line_dist_tbl.MERCHANT_PARTY_NAME(l_index) := NULL;
1089: zx_global_structures_pkg.trx_line_dist_tbl.MERCHANT_PARTY_DOCUMENT_NUMBER(l_index) := NULL;
1332:
1333:
1334: oe_debug_pub.add( ' Assigned the Tax values ');
1335: /*
1336: IF ( NOT ( OE_Bulk_Order_PVT.G_Line_Rec.header_id(l_index) is null OR
1337: OE_Bulk_Order_PVT.G_Line_Rec.inventory_item_id(l_index) is null OR
1338: OE_Bulk_Order_PVT.G_Line_Rec.unit_selling_price(l_index) is null)
1339: )
1340: THEN
1333:
1334: oe_debug_pub.add( ' Assigned the Tax values ');
1335: /*
1336: IF ( NOT ( OE_Bulk_Order_PVT.G_Line_Rec.header_id(l_index) is null OR
1337: OE_Bulk_Order_PVT.G_Line_Rec.inventory_item_id(l_index) is null OR
1338: OE_Bulk_Order_PVT.G_Line_Rec.unit_selling_price(l_index) is null)
1339: )
1340: THEN
1341:
1334: oe_debug_pub.add( ' Assigned the Tax values ');
1335: /*
1336: IF ( NOT ( OE_Bulk_Order_PVT.G_Line_Rec.header_id(l_index) is null OR
1337: OE_Bulk_Order_PVT.G_Line_Rec.inventory_item_id(l_index) is null OR
1338: OE_Bulk_Order_PVT.G_Line_Rec.unit_selling_price(l_index) is null)
1339: )
1340: THEN
1341:
1342:
1351: l_transaction_rec.application_id := 660;
1352: l_transaction_rec.entity_code := 'OE_ORDER_HEADERS';
1353: l_transaction_rec.event_class_code := 'SALES_TRANSACTION_TAX_QUOTE';
1354: l_transaction_rec.event_type_code := 'CREATE';
1355: l_transaction_rec.trx_id := OE_Bulk_Order_PVT.G_Header_Rec.header_id(l_header_index);
1356: l_transaction_rec.internal_organization_id := OE_Bulk_Order_PVT.G_Header_Rec.org_id(l_header_index);
1357:
1358:
1359: SELECT hsecs INTO l_start_time from v$timer;
1352: l_transaction_rec.entity_code := 'OE_ORDER_HEADERS';
1353: l_transaction_rec.event_class_code := 'SALES_TRANSACTION_TAX_QUOTE';
1354: l_transaction_rec.event_type_code := 'CREATE';
1355: l_transaction_rec.trx_id := OE_Bulk_Order_PVT.G_Header_Rec.header_id(l_header_index);
1356: l_transaction_rec.internal_organization_id := OE_Bulk_Order_PVT.G_Header_Rec.org_id(l_header_index);
1357:
1358:
1359: SELECT hsecs INTO l_start_time from v$timer;
1360:
1397: END IF;
1398: Handle_Error( l_header_index);
1399:
1400: IF l_debug_level > 0 THEN
1401: oe_debug_pub.add( 'return status was ERROR. skipping header with header id: '|| OE_Bulk_Order_PVT.G_Header_Rec.header_id(l_header_index));
1402: oe_debug_pub.add( ' Error :'|| l_x_msg_data, 1);
1403: END IF;
1404:
1405: --Skip the remaining lines in this header as it is marked for error
1402: oe_debug_pub.add( ' Error :'|| l_x_msg_data, 1);
1403: END IF;
1404:
1405: --Skip the remaining lines in this header as it is marked for error
1406: -- l_remaining_lines := OE_Bulk_Order_PVT.G_HEADER_REC.end_line_index(l_header_index) - l_index;
1407: -- l_index_inc := l_remaining_lines + 1;
1408: ELSE
1409:
1410: IF l_debug_level > 0 THEN
1416: fetch detail_tax_lines_gt into detail_tax_lines_gt_rec;
1417: loop
1418: exit when detail_tax_lines_gt%NOTFOUND;*/
1419: i := 1;
1420: for detail_tax_lines_gt_rec in detail_tax_lines_gt(OE_Bulk_Order_PVT.G_Header_Rec.header_id(l_header_index)) loop
1421: oe_debug_pub.add( ' Header il_header_index Lalit' || detail_tax_lines_gt_rec.trx_level_type, 1);
1422: oe_debug_pub.add( ' Header id :' || OE_Bulk_Order_PVT.G_Header_Rec.header_id(l_header_index), 1);
1423: oe_debug_pub.add( ' Tax Code :'|| detail_tax_lines_gt_rec.Tax_Code,1);
1424: oe_debug_pub.add( ' Tax_rate_id :'|| detail_tax_lines_gt_rec.tax_rate_id ,1);
1418: exit when detail_tax_lines_gt%NOTFOUND;*/
1419: i := 1;
1420: for detail_tax_lines_gt_rec in detail_tax_lines_gt(OE_Bulk_Order_PVT.G_Header_Rec.header_id(l_header_index)) loop
1421: oe_debug_pub.add( ' Header il_header_index Lalit' || detail_tax_lines_gt_rec.trx_level_type, 1);
1422: oe_debug_pub.add( ' Header id :' || OE_Bulk_Order_PVT.G_Header_Rec.header_id(l_header_index), 1);
1423: oe_debug_pub.add( ' Tax Code :'|| detail_tax_lines_gt_rec.Tax_Code,1);
1424: oe_debug_pub.add( ' Tax_rate_id :'|| detail_tax_lines_gt_rec.tax_rate_id ,1);
1425:
1426: --Build the Adjustments records to INSERT Tax Info
1425:
1426: --Build the Adjustments records to INSERT Tax Info
1427: Extend_Adj_Rec(1, G_LINE_ADJ_REC);
1428: oe_debug_pub.add( ' Aftr Extend ');
1429: G_LINE_ADJ_REC.header_id(i) := detail_tax_lines_gt_rec.trx_id; --OE_Bulk_Order_PVT.G_Line_Rec.header_id(i);
1430: G_LINE_ADJ_REC.line_id(i) := detail_tax_lines_gt_rec.trx_line_id; --OE_Bulk_Order_PVT.G_Line_Rec.line_id(i);
1431:
1432: -- l_tax_code := OE_Bulk_Order_PVT.G_LINE_REC.Tax_Code(i);
1433:
1426: --Build the Adjustments records to INSERT Tax Info
1427: Extend_Adj_Rec(1, G_LINE_ADJ_REC);
1428: oe_debug_pub.add( ' Aftr Extend ');
1429: G_LINE_ADJ_REC.header_id(i) := detail_tax_lines_gt_rec.trx_id; --OE_Bulk_Order_PVT.G_Line_Rec.header_id(i);
1430: G_LINE_ADJ_REC.line_id(i) := detail_tax_lines_gt_rec.trx_line_id; --OE_Bulk_Order_PVT.G_Line_Rec.line_id(i);
1431:
1432: -- l_tax_code := OE_Bulk_Order_PVT.G_LINE_REC.Tax_Code(i);
1433:
1434: G_LINE_ADJ_REC.tax_code(i) := detail_tax_lines_gt_rec.Tax_Code;
1428: oe_debug_pub.add( ' Aftr Extend ');
1429: G_LINE_ADJ_REC.header_id(i) := detail_tax_lines_gt_rec.trx_id; --OE_Bulk_Order_PVT.G_Line_Rec.header_id(i);
1430: G_LINE_ADJ_REC.line_id(i) := detail_tax_lines_gt_rec.trx_line_id; --OE_Bulk_Order_PVT.G_Line_Rec.line_id(i);
1431:
1432: -- l_tax_code := OE_Bulk_Order_PVT.G_LINE_REC.Tax_Code(i);
1433:
1434: G_LINE_ADJ_REC.tax_code(i) := detail_tax_lines_gt_rec.Tax_Code;
1435: G_LINE_ADJ_REC.operand(i) := detail_tax_lines_gt_rec.tax_rate;
1436: G_LINE_ADJ_REC.adjusted_amount(i) := detail_tax_lines_gt_rec.tax_amt;
1438: G_LINE_ADJ_REC.list_line_type_code(i) := 'TAX';
1439: G_LINE_ADJ_REC.arithmetic_operator(i) := 'AMT';
1440: G_LINE_ADJ_REC.tax_rate_id(i) := detail_tax_lines_gt_rec.tax_rate_id ; --bug7685103
1441:
1442: -- OE_Bulk_Order_PVT.G_LINE_REC.tax_value(i) := detail_tax_lines_gt_rec.tax_amt;
1443:
1444: IF l_debug_level > 0 THEN
1445: oe_debug_pub.add( 'total tax value: i: ' ||
1446: detail_tax_lines_gt_rec.tax_amt, 1);
1464: END IF;
1465: -- END IF;
1466:
1467: --Tax value not updated on order line in case of post_insert = FALSE
1468: FOR i IN 1..OE_Bulk_Order_PVT.G_LINE_REC.line_id.COUNT LOOP --bug7685103
1469: FOR j in 1..G_Tax_Line_Id.COUNT LOOP
1470: IF OE_Bulk_Order_PVT.G_LINE_REC.line_id(i) = G_Tax_Line_Id(j) THEN
1471: OE_Bulk_Order_PVT.G_LINE_REC.tax_value(i) := NVL(OE_Bulk_Order_PVT.G_LINE_REC.tax_value(i),0)+ G_Tax_Line_Value(j);
1472: END IF;
1466:
1467: --Tax value not updated on order line in case of post_insert = FALSE
1468: FOR i IN 1..OE_Bulk_Order_PVT.G_LINE_REC.line_id.COUNT LOOP --bug7685103
1469: FOR j in 1..G_Tax_Line_Id.COUNT LOOP
1470: IF OE_Bulk_Order_PVT.G_LINE_REC.line_id(i) = G_Tax_Line_Id(j) THEN
1471: OE_Bulk_Order_PVT.G_LINE_REC.tax_value(i) := NVL(OE_Bulk_Order_PVT.G_LINE_REC.tax_value(i),0)+ G_Tax_Line_Value(j);
1472: END IF;
1473: END LOOP;
1474: END LOOP;
1467: --Tax value not updated on order line in case of post_insert = FALSE
1468: FOR i IN 1..OE_Bulk_Order_PVT.G_LINE_REC.line_id.COUNT LOOP --bug7685103
1469: FOR j in 1..G_Tax_Line_Id.COUNT LOOP
1470: IF OE_Bulk_Order_PVT.G_LINE_REC.line_id(i) = G_Tax_Line_Id(j) THEN
1471: OE_Bulk_Order_PVT.G_LINE_REC.tax_value(i) := NVL(OE_Bulk_Order_PVT.G_LINE_REC.tax_value(i),0)+ G_Tax_Line_Value(j);
1472: END IF;
1473: END LOOP;
1474: END LOOP;
1475: --bug7685103
1705: IF l_debug_level > 0 THEN
1706: oe_debug_pub.add( 'ENTERING OE_BULK_TAX_UTIL.HANDLE_ERROR' ) ;
1707: END IF;
1708:
1709: --OE_Bulk_Order_PVT.G_LINE_REC.lock_control(p_line_index) := -99;
1710: OE_Bulk_Order_PVT.G_HEADER_REC.lock_control(p_header_index) := -99;
1711: OE_BULK_ORDER_PVT.mark_header_error(p_header_index, OE_Bulk_Order_PVT.G_HEADER_REC);
1712:
1713:
1706: oe_debug_pub.add( 'ENTERING OE_BULK_TAX_UTIL.HANDLE_ERROR' ) ;
1707: END IF;
1708:
1709: --OE_Bulk_Order_PVT.G_LINE_REC.lock_control(p_line_index) := -99;
1710: OE_Bulk_Order_PVT.G_HEADER_REC.lock_control(p_header_index) := -99;
1711: OE_BULK_ORDER_PVT.mark_header_error(p_header_index, OE_Bulk_Order_PVT.G_HEADER_REC);
1712:
1713:
1714: IF l_debug_level > 0 THEN
1707: END IF;
1708:
1709: --OE_Bulk_Order_PVT.G_LINE_REC.lock_control(p_line_index) := -99;
1710: OE_Bulk_Order_PVT.G_HEADER_REC.lock_control(p_header_index) := -99;
1711: OE_BULK_ORDER_PVT.mark_header_error(p_header_index, OE_Bulk_Order_PVT.G_HEADER_REC);
1712:
1713:
1714: IF l_debug_level > 0 THEN
1715: oe_debug_pub.add( 'EXITING OE_BULK_TAX_UTIL.HANDLE_ERROR' ) ;
1747: IF l_debug_level > 0 THEN
1748: oe_debug_pub.add( 'ENTERING OE_BULK_TAX_UTIL.HANDLE_TAX_CODE_ERROR' ) ;
1749: END IF;
1750:
1751: OE_Bulk_Order_PVT.G_LINE_REC.tax_code(p_index) := null;
1752:
1753: IF nvl(OE_Bulk_Order_PVT.G_HEADER_REC.booked_flag(p_header_index), 'N') = 'Y'
1754: THEN
1755:
1749: END IF;
1750:
1751: OE_Bulk_Order_PVT.G_LINE_REC.tax_code(p_index) := null;
1752:
1753: IF nvl(OE_Bulk_Order_PVT.G_HEADER_REC.booked_flag(p_header_index), 'N') = 'Y'
1754: THEN
1755:
1756:
1757: IF l_debug_level > 0 THEN
1757: IF l_debug_level > 0 THEN
1758: oe_debug_pub.add( 'order was booked');
1759: END IF;
1760:
1761: l_order_type_cache_key := OE_BULK_CACHE.Load_Order_Type(OE_Bulk_Order_PVT.G_HEADER_REC.order_type_id(p_header_index));
1762: IF OE_Bulk_Cache.G_ORDER_TYPE_TBL(l_order_type_cache_key).tax_calculation_event IN ('ENTERING', 'BOOKING') THEN
1763:
1764: OE_BULK_MSG_PUB.Set_Msg_Context
1765: ( p_entity_code => 'HEADER'
1762: IF OE_Bulk_Cache.G_ORDER_TYPE_TBL(l_order_type_cache_key).tax_calculation_event IN ('ENTERING', 'BOOKING') THEN
1763:
1764: OE_BULK_MSG_PUB.Set_Msg_Context
1765: ( p_entity_code => 'HEADER'
1766: ,p_entity_id => OE_Bulk_Order_PVT.G_HEADER_REC.header_id(p_header_index)
1767: ,p_header_id => OE_Bulk_Order_PVT.G_HEADER_REC.header_id(p_header_index)
1768: ,p_orig_sys_document_ref => OE_Bulk_Order_PVT.G_HEADER_REC.orig_sys_document_ref(p_header_index)
1769: ,p_order_source_id => OE_Bulk_Order_PVT.G_HEADER_REC.order_source_id(p_header_index)
1770: );
1763:
1764: OE_BULK_MSG_PUB.Set_Msg_Context
1765: ( p_entity_code => 'HEADER'
1766: ,p_entity_id => OE_Bulk_Order_PVT.G_HEADER_REC.header_id(p_header_index)
1767: ,p_header_id => OE_Bulk_Order_PVT.G_HEADER_REC.header_id(p_header_index)
1768: ,p_orig_sys_document_ref => OE_Bulk_Order_PVT.G_HEADER_REC.orig_sys_document_ref(p_header_index)
1769: ,p_order_source_id => OE_Bulk_Order_PVT.G_HEADER_REC.order_source_id(p_header_index)
1770: );
1771:
1764: OE_BULK_MSG_PUB.Set_Msg_Context
1765: ( p_entity_code => 'HEADER'
1766: ,p_entity_id => OE_Bulk_Order_PVT.G_HEADER_REC.header_id(p_header_index)
1767: ,p_header_id => OE_Bulk_Order_PVT.G_HEADER_REC.header_id(p_header_index)
1768: ,p_orig_sys_document_ref => OE_Bulk_Order_PVT.G_HEADER_REC.orig_sys_document_ref(p_header_index)
1769: ,p_order_source_id => OE_Bulk_Order_PVT.G_HEADER_REC.order_source_id(p_header_index)
1770: );
1771:
1772: FND_MESSAGE.SET_NAME('ONT','OE_VAL_TAX_CODE_REQD');
1765: ( p_entity_code => 'HEADER'
1766: ,p_entity_id => OE_Bulk_Order_PVT.G_HEADER_REC.header_id(p_header_index)
1767: ,p_header_id => OE_Bulk_Order_PVT.G_HEADER_REC.header_id(p_header_index)
1768: ,p_orig_sys_document_ref => OE_Bulk_Order_PVT.G_HEADER_REC.orig_sys_document_ref(p_header_index)
1769: ,p_order_source_id => OE_Bulk_Order_PVT.G_HEADER_REC.order_source_id(p_header_index)
1770: );
1771:
1772: FND_MESSAGE.SET_NAME('ONT','OE_VAL_TAX_CODE_REQD');
1773: OE_BULK_MSG_PUB.Add;
1773: OE_BULK_MSG_PUB.Add;
1774: Handle_Error( p_header_index);
1775:
1776: IF l_debug_level > 0 THEN
1777: oe_debug_pub.add( 'tax code not found. skipping header with header id: '|| OE_Bulk_Order_PVT.G_HEADER_REC.header_id(p_header_index));
1778: END IF;
1779:
1780: --Skip the remaining lines in this header
1781: l_remaining_lines := OE_Bulk_Order_PVT.G_HEADER_REC.end_line_index(p_header_index) - p_index;
1777: oe_debug_pub.add( 'tax code not found. skipping header with header id: '|| OE_Bulk_Order_PVT.G_HEADER_REC.header_id(p_header_index));
1778: END IF;
1779:
1780: --Skip the remaining lines in this header
1781: l_remaining_lines := OE_Bulk_Order_PVT.G_HEADER_REC.end_line_index(p_header_index) - p_index;
1782: l_index_inc := l_remaining_lines + 1;
1783: END IF; -- end of tax event in ENTERING or BOOKING
1784:
1785: END IF; --end of IF booked_flag = 'Y'