[Home] [Help]
PACKAGE BODY: APPS.AR_BLK_INSRT_TRX_LINE
Source
6 p_customer_trx_line_id IN OUT NOCOPY t_customer_trx_line_id,
1 PACKAGE BODY AR_BLK_INSRT_TRX_LINE as
2 /* $Header: ARTXBLKB.pls 120.2 2005/06/14 18:52:57 vcrisost noship $ */
3
4
5 PROCEDURE bulk_insert_cust_trx_lines (
7 p_customer_trx_id IN OUT NOCOPY t_customer_trx_id,
8 p_line_number IN OUT NOCOPY t_line_number,
9 p_line_type IN OUT NOCOPY t_line_type,
10 p_quantity_credited IN OUT NOCOPY t_quantity_credited,
11 p_quantity_invoiced IN OUT NOCOPY t_quantity_invoiced,
12 p_quantity_ordered IN OUT NOCOPY t_quantity_ordered,
13 p_unit_selling_price IN OUT NOCOPY t_unit_selling_price,
14 p_unit_standard_price IN OUT NOCOPY t_unit_standard_price,
15 p_revenue_amount IN OUT NOCOPY t_revenue_amount,
16 p_extended_amount IN OUT NOCOPY t_extended_amount,
17 p_memo_line_id IN OUT NOCOPY t_memo_line_id,
18 p_inventory_item_id IN OUT NOCOPY t_inventory_item_id,
19 p_item_exception_rate_id IN OUT NOCOPY t_item_exception_rate_id,
20 p_description IN OUT NOCOPY t_description,
21 p_item_context IN OUT NOCOPY t_item_context,
22 p_initial_trx_line_id IN OUT NOCOPY t_initial_trx_line_id,
23 p_link_to_cust_trx_line_id IN OUT NOCOPY t_link_to_cust_trx_line_id,
24 p_prev_customer_trx_id IN OUT NOCOPY t_prev_customer_trx_id,
25 p_prev_customer_trx_line_id IN OUT NOCOPY t_prev_customer_trx_line_id,
26 p_accounting_rule_duration IN OUT NOCOPY t_accounting_rule_duration,
27 p_accounting_rule_id IN OUT NOCOPY t_accounting_rule_id,
28 p_rule_start_date IN OUT NOCOPY t_rule_start_date,
29 p_autorule_complete_flag IN OUT NOCOPY t_autorule_complete_flag,
30 p_autorule_duration_processed IN OUT NOCOPY t_autorule_duration_processed,
31 p_reason_code IN OUT NOCOPY t_reason_code,
32 p_last_period_to_credit IN OUT NOCOPY t_last_period_to_credit,
33 p_sales_order IN OUT NOCOPY t_sales_order,
34 p_sales_order_date IN OUT NOCOPY t_sales_order_date,
35 p_sales_order_line IN OUT NOCOPY t_sales_order_line,
36 p_sales_order_revision IN OUT NOCOPY t_sales_order_revision,
37 p_sales_order_source IN OUT NOCOPY t_sales_order_source,
38 p_vat_tax_id IN OUT NOCOPY t_vat_tax_id,
39 p_tax_exempt_flag IN OUT NOCOPY t_tax_exempt_flag,
40 p_sales_tax_id IN OUT NOCOPY t_sales_tax_id,
41 p_location_segment_id IN OUT NOCOPY t_location_segment_id,
42 p_tax_exempt_number IN OUT NOCOPY t_tax_exempt_number,
43 p_tax_exempt_reason_code IN OUT NOCOPY t_tax_exempt_reason_code,
44 p_tax_vendor_return_code IN OUT NOCOPY t_tax_vendor_return_code,
45 p_taxable_flag IN OUT NOCOPY t_taxable_flag,
46 p_tax_exemption_id IN OUT NOCOPY t_tax_exemption_id,
47 p_tax_precedence IN OUT NOCOPY t_tax_precedence,
48 p_tax_rate IN OUT NOCOPY t_tax_rate,
49 p_uom_code IN OUT NOCOPY t_uom_code,
50 p_autotax IN OUT NOCOPY t_autotax,
51 p_movement_id IN OUT NOCOPY t_movement_id,
52 p_def_ussgl_transaction_code IN OUT NOCOPY t_def_ussgl_transaction_code,
53 p_def_ussgl_trx_code_context IN OUT NOCOPY t_def_ussgl_trx_code_context,
54 p_interface_line_context IN OUT NOCOPY t_interface_line_context,
55 p_interface_line_attribute1 IN OUT NOCOPY t_interface_line_attribute1,
56 p_interface_line_attribute2 IN OUT NOCOPY t_interface_line_attribute2,
57 p_interface_line_attribute3 IN OUT NOCOPY t_interface_line_attribute3,
58 p_interface_line_attribute4 IN OUT NOCOPY t_interface_line_attribute4,
59 p_interface_line_attribute5 IN OUT NOCOPY t_interface_line_attribute5,
60 p_interface_line_attribute6 IN OUT NOCOPY t_interface_line_attribute6,
61 p_interface_line_attribute7 IN OUT NOCOPY t_interface_line_attribute7,
62 p_interface_line_attribute8 IN OUT NOCOPY t_interface_line_attribute8,
63 p_interface_line_attribute9 IN OUT NOCOPY t_interface_line_attribute9,
64 p_interface_line_attribute10 IN OUT NOCOPY t_interface_line_attribute10,
65 p_interface_line_attribute11 IN OUT NOCOPY t_interface_line_attribute11,
66 p_interface_line_attribute12 IN OUT NOCOPY t_interface_line_attribute12,
67 p_interface_line_attribute13 IN OUT NOCOPY t_interface_line_attribute13,
68 p_interface_line_attribute14 IN OUT NOCOPY t_interface_line_attribute14,
69 p_interface_line_attribute15 IN OUT NOCOPY t_interface_line_attribute15,
70 p_attribute_category IN OUT NOCOPY t_attribute_category,
71 p_attribute1 IN OUT NOCOPY t_attribute1,
72 p_attribute2 IN OUT NOCOPY t_attribute2,
73 p_attribute3 IN OUT NOCOPY t_attribute3,
74 p_attribute4 IN OUT NOCOPY t_attribute4,
75 p_attribute5 IN OUT NOCOPY t_attribute5,
76 p_attribute6 IN OUT NOCOPY t_attribute6,
77 p_attribute7 IN OUT NOCOPY t_attribute7,
78 p_attribute8 IN OUT NOCOPY t_attribute8,
79 p_attribute9 IN OUT NOCOPY t_attribute9,
80 p_attribute10 IN OUT NOCOPY t_attribute10,
81 p_attribute11 IN OUT NOCOPY t_attribute11,
82 p_attribute12 IN OUT NOCOPY t_attribute12,
83 p_attribute13 IN OUT NOCOPY t_attribute13,
84 p_attribute14 IN OUT NOCOPY t_attribute14,
85 p_attribute15 IN OUT NOCOPY t_attribute15,
86 p_global_attribute_category IN OUT NOCOPY t_global_attribute_category,
87 p_global_attribute1 IN OUT NOCOPY t_global_attribute1,
88 p_global_attribute2 IN OUT NOCOPY t_global_attribute2,
89 p_global_attribute3 IN OUT NOCOPY t_global_attribute3,
90 p_global_attribute4 IN OUT NOCOPY t_global_attribute4,
91 p_global_attribute5 IN OUT NOCOPY t_global_attribute5,
92 p_global_attribute6 IN OUT NOCOPY t_global_attribute6,
93 p_global_attribute7 IN OUT NOCOPY t_global_attribute7,
94 p_global_attribute8 IN OUT NOCOPY t_global_attribute8,
95 p_global_attribute9 IN OUT NOCOPY t_global_attribute9,
96 p_global_attribute10 IN OUT NOCOPY t_global_attribute10,
97 p_global_attribute11 IN OUT NOCOPY t_global_attribute11,
98 p_global_attribute12 IN OUT NOCOPY t_global_attribute12,
99 p_global_attribute13 IN OUT NOCOPY t_global_attribute13,
100 p_global_attribute14 IN OUT NOCOPY t_global_attribute14,
101 p_global_attribute15 IN OUT NOCOPY t_global_attribute15,
102 p_global_attribute16 IN OUT NOCOPY t_global_attribute16,
103 p_global_attribute17 IN OUT NOCOPY t_global_attribute17,
104 p_global_attribute18 IN OUT NOCOPY t_global_attribute18,
105 p_global_attribute19 IN OUT NOCOPY t_global_attribute19,
106 p_global_attribute20 IN OUT NOCOPY t_global_attribute20,
107 p_created_by IN OUT NOCOPY t_created_by,
108 p_create_date IN OUT NOCOPY t_create_date,
109 p_updated_by IN OUT NOCOPY t_updated_by,
110 p_update_date IN OUT NOCOPY t_update_date,
111 p_prog_appl_id IN OUT NOCOPY t_prog_appl_id,
112 p_last_update_login IN OUT NOCOPY t_last_update_login,
113 p_conc_program_id IN OUT NOCOPY t_conc_program_id,
114 p_program_update_date IN OUT NOCOPY t_program_update_date,
115 p_set_of_books_id IN OUT NOCOPY t_set_of_books_id,
116 p_gross_unit_selling_price IN OUT NOCOPY t_gross_unit_selling_price,
117 p_gross_extended_amount IN OUT NOCOPY t_gross_extended_amount,
118 p_amount_include_tax_flag IN OUT NOCOPY t_amount_includes_tax_flag,
119 p_warehouse_id IN OUT NOCOPY t_warehouse_id,
120 p_translated_description IN OUT NOCOPY t_translated_description,
121 p_taxable_amount IN OUT NOCOPY t_taxable_amount,
122 p_request_id IN OUT NOCOPY t_request_id,
123 p_extended_acctd_amount IN OUT NOCOPY t_extended_acctd_amount,
124 p_br_ref_customer_trx_id IN OUT NOCOPY t_br_ref_customer_trx_id,
125 p_br_ref_payment_schedule_id IN OUT NOCOPY t_br_ref_payment_schedule_id,
126 p_br_adjustment_id IN OUT NOCOPY t_br_adjustment_id,
127 p_wh_update_date IN OUT NOCOPY t_wh_update_date)
128
129 IS
130
131 i number := 0;
132 p_cntr number := 0;
133
134 BEGIN
135
136 arp_standard.debug('AR_BLK_INSRT_TRX_LINE.AR_BLK_INSRT_TRX_LINE(+) ');
137
138 IF p_customer_trx_line_id.count <> 0 then
139 forall i in p_customer_trx_line_id.first..p_customer_trx_line_id.last
140 INSERT INTO ra_customer_trx_lines (customer_trx_line_id,
141 customer_trx_id,
142 line_number,
143 line_type,
144 quantity_credited,
145 quantity_invoiced,
146 quantity_ordered,
147 unit_selling_price,
148 unit_standard_price,
149 revenue_amount,
150 extended_amount,
151 memo_line_id,
152 inventory_item_id,
153 item_exception_rate_id,
154 description,
155 item_context,
156 initial_customer_trx_line_id,
157 link_to_cust_trx_line_id,
158 previous_customer_trx_id,
159 previous_customer_trx_line_id,
160 accounting_rule_duration,
161 accounting_rule_id,
162 rule_start_date,
163 autorule_complete_flag,
164 autorule_duration_processed,
165 reason_code,
166 last_period_to_credit,
167 sales_order,
168 sales_order_date,
169 sales_order_line,
170 sales_order_revision,
171 sales_order_source,
172 vat_tax_id,
173 tax_exempt_flag,
174 sales_tax_id,
175 location_segment_id,
176 tax_exempt_number,
177 tax_exempt_reason_code,
178 tax_vendor_return_code,
179 taxable_flag,
180 tax_exemption_id,
181 tax_precedence,
182 tax_rate,
183 uom_code,
184 autotax,
185 movement_id,
186 default_ussgl_transaction_code,
187 default_ussgl_trx_code_context,
188 interface_line_context,
189 interface_line_attribute1,
190 interface_line_attribute2,
191 interface_line_attribute3,
192 interface_line_attribute4,
193 interface_line_attribute5,
194 interface_line_attribute6,
195 interface_line_attribute7,
196 interface_line_attribute8,
197 interface_line_attribute9,
198 interface_line_attribute10,
199 interface_line_attribute11,
200 interface_line_attribute12,
201 interface_line_attribute13,
202 interface_line_attribute14,
203 interface_line_attribute15,
204 attribute_category,
205 attribute1,
206 attribute2,
207 attribute3,
208 attribute4,
209 attribute5,
210 attribute6,
211 attribute7,
212 attribute8,
213 attribute9,
214 attribute10,
215 attribute11,
216 attribute12,
217 attribute13,
218 attribute14,
219 attribute15,
220 global_attribute_category,
221 global_attribute1,
222 global_attribute2,
223 global_attribute3,
224 global_attribute4,
225 global_attribute5,
226 global_attribute6,
227 global_attribute7,
228 global_attribute8,
229 global_attribute9,
230 global_attribute10,
231 global_attribute11,
232 global_attribute12,
233 global_attribute13,
234 global_attribute14,
235 global_attribute15,
236 global_attribute16,
237 global_attribute17,
238 global_attribute18,
239 global_attribute19,
240 global_attribute20,
241 created_by,
242 creation_date,
243 last_updated_by,
244 last_update_date,
245 program_application_id,
246 last_update_login,
247 program_id,
248 program_update_date,
249 set_of_books_id,
250 gross_unit_selling_price,
251 gross_extended_amount,
252 amount_includes_tax_flag,
253 warehouse_id,
254 translated_description,
255 taxable_amount,
256 request_id,
257 extended_acctd_amount,
258 br_ref_customer_trx_id,
259 br_ref_payment_schedule_id,
260 br_adjustment_id,
261 wh_update_date,
262 org_id)
263 VALUES (p_customer_trx_line_id(i),
264 p_customer_trx_id(i),
265 p_line_number(i),
266 p_line_type(i),
267 p_quantity_credited(i),
268 p_quantity_invoiced(i),
269 p_quantity_ordered(i),
270 p_unit_selling_price(i),
271 p_unit_standard_price(i),
272 p_revenue_amount(i),
273 p_extended_amount(i),
274 p_memo_line_id(i),
275 p_inventory_item_id(i),
276 p_item_exception_rate_id(i),
277 p_description(i),
278 p_item_context(i),
279 p_initial_trx_line_id(i),
280 p_link_to_cust_trx_line_id(i),
281 p_prev_customer_trx_id(i),
282 p_prev_customer_trx_line_id(i),
283 p_accounting_rule_duration(i),
284 p_accounting_rule_id(i),
285 p_rule_start_date(i),
286 p_autorule_complete_flag(i),
287 p_autorule_duration_processed(i),
288 p_reason_code(i),
289 p_last_period_to_credit(i),
290 p_sales_order(i),
291 p_sales_order_date(i),
292 p_sales_order_line(i),
293 p_sales_order_revision(i),
294 p_sales_order_source(i),
295 p_vat_tax_id(i),
296 p_tax_exempt_flag(i),
297 p_sales_tax_id(i),
298 p_location_segment_id(i),
299 p_tax_exempt_number(i),
300 p_tax_exempt_reason_code(i),
301 p_tax_vendor_return_code(i),
302 p_taxable_flag(i),
303 p_tax_exemption_id(i),
304 p_tax_precedence(i),
305 p_tax_rate(i),
306 p_uom_code(i),
307 p_autotax(i),
308 p_movement_id(i),
309 p_def_ussgl_transaction_code(i),
310 p_def_ussgl_trx_code_context(i),
311 p_interface_line_context(i),
312 p_interface_line_attribute1(i),
313 p_interface_line_attribute2(i),
314 p_interface_line_attribute3(i),
315 p_interface_line_attribute4(i),
316 p_interface_line_attribute5(i),
317 p_interface_line_attribute6(i),
318 p_interface_line_attribute7(i),
319 p_interface_line_attribute8(i),
320 p_interface_line_attribute9(i),
321 p_interface_line_attribute10(i),
322 p_interface_line_attribute11(i),
323 p_interface_line_attribute12(i),
324 p_interface_line_attribute13(i),
325 p_interface_line_attribute14(i),
326 p_interface_line_attribute15(i),
327 p_attribute_category(i),
328 p_attribute1(i),
329 p_attribute2(i),
330 p_attribute3(i),
331 p_attribute4(i),
332 p_attribute5(i),
333 p_attribute6(i),
334 p_attribute7(i),
335 p_attribute8(i),
336 p_attribute9(i),
337 p_attribute10(i),
338 p_attribute11(i),
339 p_attribute12(i),
340 p_attribute13(i),
341 p_attribute14(i),
342 p_attribute15(i),
343 p_global_attribute_category(i),
344 p_global_attribute1(i),
345 p_global_attribute2(i),
346 p_global_attribute3(i),
347 p_global_attribute4(i),
348 p_global_attribute5(i),
349 p_global_attribute6(i),
350 p_global_attribute7(i),
351 p_global_attribute8(i),
352 p_global_attribute9(i),
353 p_global_attribute10(i),
354 p_global_attribute11(i),
355 p_global_attribute12(i),
356 p_global_attribute13(i),
357 p_global_attribute14(i),
358 p_global_attribute15(i),
359 p_global_attribute16(i),
360 p_global_attribute17(i),
361 p_global_attribute18(i),
362 p_global_attribute19(i),
363 p_global_attribute20(i),
364 p_created_by(i),
365 p_create_date(i),
366 p_updated_by(i),
367 p_program_update_date(i),
368 p_prog_appl_id(i),
369 p_last_update_login(i),
370 p_conc_program_id(i),
371 p_program_update_date(i),
372 p_set_of_books_id(i),
373 p_gross_unit_selling_price(i),
374 p_gross_extended_amount(i),
375 p_amount_include_tax_flag(i),
376 p_warehouse_id(i),
377 p_translated_description(i),
378 p_taxable_amount(i),
379 p_request_id(i),
380 p_extended_acctd_amount(i),
381 p_br_ref_customer_trx_id(i),
382 p_br_ref_payment_schedule_id(i),
383 p_br_adjustment_id(i),
384 p_wh_update_date(i),
385 arp_standard.sysparm.org_id);
386 p_cntr := p_cntr + 1;
387 end if;
388
389 arp_standard.debug('AR_BLK_INSRT_TRX_LINE.number of records: '||to_char(p_cntr));
390
391 arp_standard.debug('AR_BLK_INSRT_TRX_LINE.bulk_insert_cust_trx_lines(-) ');
392
393 EXCEPTION
394 WHEN OTHERS THEN
395 arp_standard.debug('EXCEPTION: bulk_insert_trx_lines()');
396 arp_standard.debug(SQLCODE||' ; '||SQLERRM);
397
398 arp_standard.debug('p_customer_trx_line_id : '||p_customer_trx_line_id(i));
399 arp_standard.debug('p_customer_trx_id : '||p_customer_trx_id(i));
400 arp_standard.debug('p_line_number : '||p_line_number(i));
401 arp_standard.debug('p_line_type : '||p_line_type(i));
402 arp_standard.debug('p_quantity_credited : '||p_quantity_credited(i));
403 arp_standard.debug('p_quantity_invoiced : '||p_quantity_invoiced(i));
404 arp_standard.debug('p_quantity_ordered : '||p_quantity_ordered(i));
405 arp_standard.debug('p_unit_selling_price : '||p_unit_selling_price(i));
406 arp_standard.debug('p_unit_standard_price : '||p_unit_standard_price(i));
407 arp_standard.debug('p_revenue_amount : '||p_revenue_amount(i));
408 arp_standard.debug('p_extended_amount : '||p_extended_amount(i));
409 arp_standard.debug('p_memo_line_id : '||p_memo_line_id(i));
410 arp_standard.debug('p_inventory_item_id : '||p_inventory_item_id(i));
411 arp_standard.debug('p_item_exception_rate_id : '||p_item_exception_rate_id(i));
412 arp_standard.debug('p_description : '||p_description(i));
413 arp_standard.debug('p_item_context : '||p_item_context(i));
414 arp_standard.debug('p_initial_trx_line_id : '||p_initial_trx_line_id(i));
415 arp_standard.debug('p_link_to_cust_trx_line_id : '||p_link_to_cust_trx_line_id(i));
416 arp_standard.debug('p_prev_customer_trx_id : '||p_prev_customer_trx_id(i));
417 arp_standard.debug('p_prev_customer_trx_line_id : '||p_prev_customer_trx_line_id(i));
418 arp_standard.debug('p_accounting_rule_duration : '||p_accounting_rule_duration(i));
419 arp_standard.debug('p_accounting_rule_id : '||p_accounting_rule_id(i));
420 arp_standard.debug('p_rule_start_date : '||p_rule_start_date(i));
421 arp_standard.debug('p_autorule_complete_flag : '||p_autorule_complete_flag(i));
422 arp_standard.debug('p_autorule_duration_processed : '||p_autorule_duration_processed(i));
423 arp_standard.debug('p_reason_code : '||p_reason_code(i));
424 arp_standard.debug('p_last_period_to_credit : '||p_last_period_to_credit(i));
425 arp_standard.debug('p_sales_order : '||p_sales_order(i));
426 arp_standard.debug('p_sales_order_date : '||p_sales_order_date(i));
427 arp_standard.debug('p_sales_order_line : '||p_sales_order_line(i));
428 arp_standard.debug('p_sales_order_revision : '||p_sales_order_revision(i));
429 arp_standard.debug('p_sales_order_source : '||p_sales_order_source(i));
430 arp_standard.debug('p_vat_tax_id : '||p_vat_tax_id(i));
431 arp_standard.debug('p_tax_exempt_flag : '||p_tax_exempt_flag(i));
432 arp_standard.debug('p_sales_tax_id : '||p_sales_tax_id(i));
433 arp_standard.debug('p_location_segment_id : '||p_location_segment_id(i));
434 arp_standard.debug('p_tax_exempt_number : '||p_tax_exempt_number(i));
435 arp_standard.debug('p_tax_exempt_reason_code : '||p_tax_exempt_reason_code(i));
436 arp_standard.debug('p_tax_vendor_return_code : '||p_tax_vendor_return_code(i));
437 arp_standard.debug('p_taxable_flag : '||p_taxable_flag(i));
438 arp_standard.debug('p_tax_exemption_id : '||p_tax_exemption_id(i));
439 arp_standard.debug('p_tax_precedence : '||p_tax_precedence(i));
440 arp_standard.debug('p_tax_rate : '||p_tax_rate(i));
441 arp_standard.debug('p_uom_code : '||p_uom_code(i));
442 arp_standard.debug('p_autotax : '||p_autotax(i));
443 arp_standard.debug('p_movement_id : '||p_movement_id(i));
444 arp_standard.debug('p_def_ussgl_transaction_code : '||p_def_ussgl_transaction_code(i));
445 arp_standard.debug('p_def_ussgl_trx_code_context : '||p_def_ussgl_trx_code_context(i));
446 arp_standard.debug('p_interface_line_context : '||p_interface_line_context(i));
447 arp_standard.debug('p_interface_line_attribute1 : '||p_interface_line_attribute1(i));
448 arp_standard.debug('p_interface_line_attribute2 : '||p_interface_line_attribute2(i));
449 arp_standard.debug('p_interface_line_attribute3 : '||p_interface_line_attribute3(i));
450 arp_standard.debug('p_interface_line_attribute4 : '||p_interface_line_attribute4(i));
451 arp_standard.debug('p_interface_line_attribute5 : '||p_interface_line_attribute5(i));
452 arp_standard.debug('p_interface_line_attribute6 : '||p_interface_line_attribute6(i));
453 arp_standard.debug('p_interface_line_attribute7 : '||p_interface_line_attribute7(i));
454 arp_standard.debug('p_interface_line_attribute8 : '||p_interface_line_attribute8(i));
455 arp_standard.debug('p_interface_line_attribute9 : '||p_interface_line_attribute9(i));
456 arp_standard.debug('p_interface_line_attribute10 : '||p_interface_line_attribute10(i));
457 arp_standard.debug('p_interface_line_attribute11 : '||p_interface_line_attribute11(i));
458 arp_standard.debug('p_interface_line_attribute12 : '||p_interface_line_attribute12(i));
459 arp_standard.debug('p_interface_line_attribute13 : '||p_interface_line_attribute13(i));
460 arp_standard.debug('p_interface_line_attribute14 : '||p_interface_line_attribute14(i));
461 arp_standard.debug('p_interface_line_attribute15 : '||p_interface_line_attribute15(i));
462 arp_standard.debug('p_attribute_category : '||p_attribute_category(i));
463 arp_standard.debug('p_attribute1 : '||p_attribute1(i));
464 arp_standard.debug('p_attribute2 : '||p_attribute2(i));
465 arp_standard.debug('p_attribute3 : '||p_attribute3(i));
466 arp_standard.debug('p_attribute4 : '||p_attribute4(i));
467 arp_standard.debug('p_attribute5 : '||p_attribute5(i));
468 arp_standard.debug('p_attribute6 : '||p_attribute6(i));
469 arp_standard.debug('p_attribute7 : '||p_attribute7(i));
470 arp_standard.debug('p_attribute8 : '||p_attribute8(i));
471 arp_standard.debug('p_attribute9 : '||p_attribute9(i));
472 arp_standard.debug('p_attribute10 : '||p_attribute10(i));
473 arp_standard.debug('p_attribute11 : '||p_attribute11(i));
474 arp_standard.debug('p_attribute12 : '||p_attribute12(i));
475 arp_standard.debug('p_attribute13 : '||p_attribute13(i));
476 arp_standard.debug('p_attribute14 : '||p_attribute14(i));
477 arp_standard.debug('p_attribute15 : '||p_attribute15(i));
478 arp_standard.debug('p_global_attribute_category : '||p_global_attribute_category(i));
479 arp_standard.debug('p_global_attribute1 : '||p_global_attribute1(i));
480 arp_standard.debug('p_global_attribute2 : '||p_global_attribute2(i));
481 arp_standard.debug('p_global_attribute3 : '||p_global_attribute3(i));
482 arp_standard.debug('p_global_attribute4 : '||p_global_attribute4(i));
483 arp_standard.debug('p_global_attribute5 : '||p_global_attribute5(i));
484 arp_standard.debug('p_global_attribute6 : '||p_global_attribute6(i));
485 arp_standard.debug('p_global_attribute7 : '||p_global_attribute7(i));
486 arp_standard.debug('p_global_attribute8 : '||p_global_attribute8(i));
487 arp_standard.debug('p_global_attribute9 : '||p_global_attribute9(i));
488 arp_standard.debug('p_global_attribute10 : '||p_global_attribute10(i));
489 arp_standard.debug('p_global_attribute11 : '||p_global_attribute11(i));
490 arp_standard.debug('p_global_attribute12 : '||p_global_attribute12(i));
491 arp_standard.debug('p_global_attribute13 : '||p_global_attribute13(i));
492 arp_standard.debug('p_global_attribute14 : '||p_global_attribute14(i));
493 arp_standard.debug('p_global_attribute15 : '||p_global_attribute15(i));
494 arp_standard.debug('p_global_attribute16 : '||p_global_attribute16(i));
495 arp_standard.debug('p_global_attribute17 : '||p_global_attribute17(i));
496 arp_standard.debug('p_global_attribute18 : '||p_global_attribute18(i));
497 arp_standard.debug('p_global_attribute19 : '||p_global_attribute19(i));
498 arp_standard.debug('p_global_attribute20 : '||p_global_attribute20(i));
499 arp_standard.debug('p_created_by : '||p_created_by(i));
500 arp_standard.debug('p_create_date : '||p_create_date(i));
501 arp_standard.debug('p_updated_by : '||p_updated_by(i));
502 arp_standard.debug('p_program_update_date : '||p_program_update_date(i));
503 arp_standard.debug('p_prog_appl_id : '||p_prog_appl_id(i));
504 arp_standard.debug('p_last_update_login : '||p_last_update_login(i));
505 arp_standard.debug('p_conc_program_id : '||p_conc_program_id(i));
506 arp_standard.debug('p_program_update_date : '||p_program_update_date(i));
507 arp_standard.debug('p_set_of_books_id : '||p_set_of_books_id(i));
508 arp_standard.debug('p_gross_unit_selling_price : '||p_gross_unit_selling_price(i));
509 arp_standard.debug('p_gross_extended_amount : '||p_gross_extended_amount(i));
510 arp_standard.debug('p_amount_include_tax_flag : '||p_amount_include_tax_flag(i));
511 arp_standard.debug('p_warehouse_id : '||p_warehouse_id(i));
512 arp_standard.debug('p_translated_description : '||p_translated_description(i));
513 arp_standard.debug('p_taxable_amount : '||p_taxable_amount(i));
514 arp_standard.debug('p_request_id : '||p_request_id(i));
515 arp_standard.debug('p_extended_acctd_amount : '||p_extended_acctd_amount(i));
516 arp_standard.debug('p_br_ref_customer_trx_id : '||p_br_ref_customer_trx_id(i));
517 arp_standard.debug('p_br_ref_payment_schedule_id : '||p_br_ref_payment_schedule_id(i));
518 arp_standard.debug('p_br_adjustment_id : '||p_br_adjustment_id(i));
519 arp_standard.debug('p_wh_update_date : '||p_wh_update_date(i));
520 arp_standard.debug('org_id : '||arp_standard.sysparm.org_id);
521 arp_standard.debug('EXCEPTION: bulk_insert_trx_lines()');
522 RAISE;
523
524 END;
525 END AR_BLK_INSRT_TRX_LINE;
526