20: | |
21: | SCOPE - PUBLIC |
22: | |
23: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
24: | arp_standard.debug |
25: | |
26: | ARGUMENTS : IN: |
27: | p_form_name |
28: | p_form_version |
171:
172: BEGIN
173:
174: IF PG_DEBUG in ('Y', 'C') THEN
175: arp_standard.debug('arp_process_dist.insert_dist_cover()+');
176: END IF;
177:
178: /*-----------------------------------------+
179: | Populate the dist record group with |
219: l_dist_rec.attribute14 := p_attribute14;
220: l_dist_rec.attribute15 := p_attribute15;
221:
222: /*----------------------------------------+
223: | Call the standard dist entity handler |
224: +----------------------------------------*/
225:
226: arp_process_dist.insert_dist(
227: p_form_name,
233: p_base_mau,
234: p_cust_trx_line_gl_dist_id );
235:
236: IF PG_DEBUG in ('Y', 'C') THEN
237: arp_standard.debug('arp_process_dist.insert_dist_cover()-');
238: END IF;
239:
240: EXCEPTION
241: WHEN OTHERS THEN
240: EXCEPTION
241: WHEN OTHERS THEN
242:
243: IF PG_DEBUG in ('Y', 'C') THEN
244: arp_standard.debug('EXCEPTION: arp_process_dist.insert_dist_cover()',
245: 'plsql');
246: arp_standard.debug('------- parameters for insert_dist_cover() ' ||
247: '---------',
248: 'plsql');
242:
243: IF PG_DEBUG in ('Y', 'C') THEN
244: arp_standard.debug('EXCEPTION: arp_process_dist.insert_dist_cover()',
245: 'plsql');
246: arp_standard.debug('------- parameters for insert_dist_cover() ' ||
247: '---------',
248: 'plsql');
249: arp_standard.debug( 'p_form_name = ' || p_form_name,
250: 'plsql');
245: 'plsql');
246: arp_standard.debug('------- parameters for insert_dist_cover() ' ||
247: '---------',
248: 'plsql');
249: arp_standard.debug( 'p_form_name = ' || p_form_name,
250: 'plsql');
251: arp_standard.debug( 'p_form_version = ' || p_form_version,
252: 'plsql');
253: arp_standard.debug( 'p_exchange_rate = ' || p_exchange_rate,
247: '---------',
248: 'plsql');
249: arp_standard.debug( 'p_form_name = ' || p_form_name,
250: 'plsql');
251: arp_standard.debug( 'p_form_version = ' || p_form_version,
252: 'plsql');
253: arp_standard.debug( 'p_exchange_rate = ' || p_exchange_rate,
254: 'plsql');
255: arp_standard.debug( 'p_base_currency_code = ' || p_base_currency_code,
249: arp_standard.debug( 'p_form_name = ' || p_form_name,
250: 'plsql');
251: arp_standard.debug( 'p_form_version = ' || p_form_version,
252: 'plsql');
253: arp_standard.debug( 'p_exchange_rate = ' || p_exchange_rate,
254: 'plsql');
255: arp_standard.debug( 'p_base_currency_code = ' || p_base_currency_code,
256: 'plsql');
257: arp_standard.debug( 'p_base_precision = ' || p_base_precision,
251: arp_standard.debug( 'p_form_version = ' || p_form_version,
252: 'plsql');
253: arp_standard.debug( 'p_exchange_rate = ' || p_exchange_rate,
254: 'plsql');
255: arp_standard.debug( 'p_base_currency_code = ' || p_base_currency_code,
256: 'plsql');
257: arp_standard.debug( 'p_base_precision = ' || p_base_precision,
258: 'plsql');
259: arp_standard.debug( 'p_base_mau = ' || p_base_mau,
253: arp_standard.debug( 'p_exchange_rate = ' || p_exchange_rate,
254: 'plsql');
255: arp_standard.debug( 'p_base_currency_code = ' || p_base_currency_code,
256: 'plsql');
257: arp_standard.debug( 'p_base_precision = ' || p_base_precision,
258: 'plsql');
259: arp_standard.debug( 'p_base_mau = ' || p_base_mau,
260: 'plsql');
261: arp_standard.debug( 'p_customer_trx_id = ' || p_customer_trx_id,
255: arp_standard.debug( 'p_base_currency_code = ' || p_base_currency_code,
256: 'plsql');
257: arp_standard.debug( 'p_base_precision = ' || p_base_precision,
258: 'plsql');
259: arp_standard.debug( 'p_base_mau = ' || p_base_mau,
260: 'plsql');
261: arp_standard.debug( 'p_customer_trx_id = ' || p_customer_trx_id,
262: 'plsql');
263: arp_standard.debug( 'p_customer_trx_line_id = ' || p_customer_trx_line_id,
257: arp_standard.debug( 'p_base_precision = ' || p_base_precision,
258: 'plsql');
259: arp_standard.debug( 'p_base_mau = ' || p_base_mau,
260: 'plsql');
261: arp_standard.debug( 'p_customer_trx_id = ' || p_customer_trx_id,
262: 'plsql');
263: arp_standard.debug( 'p_customer_trx_line_id = ' || p_customer_trx_line_id,
264: 'plsql');
265: arp_standard.debug( 'p_cust_trx_line_salesrep_id = ' ||
259: arp_standard.debug( 'p_base_mau = ' || p_base_mau,
260: 'plsql');
261: arp_standard.debug( 'p_customer_trx_id = ' || p_customer_trx_id,
262: 'plsql');
263: arp_standard.debug( 'p_customer_trx_line_id = ' || p_customer_trx_line_id,
264: 'plsql');
265: arp_standard.debug( 'p_cust_trx_line_salesrep_id = ' ||
266: p_cust_trx_line_salesrep_id,
267: 'plsql');
261: arp_standard.debug( 'p_customer_trx_id = ' || p_customer_trx_id,
262: 'plsql');
263: arp_standard.debug( 'p_customer_trx_line_id = ' || p_customer_trx_line_id,
264: 'plsql');
265: arp_standard.debug( 'p_cust_trx_line_salesrep_id = ' ||
266: p_cust_trx_line_salesrep_id,
267: 'plsql');
268: arp_standard.debug( 'p_account_class = ' || p_account_class,
269: 'plsql');
264: 'plsql');
265: arp_standard.debug( 'p_cust_trx_line_salesrep_id = ' ||
266: p_cust_trx_line_salesrep_id,
267: 'plsql');
268: arp_standard.debug( 'p_account_class = ' || p_account_class,
269: 'plsql');
270: arp_standard.debug( 'p_percent = ' || p_percent,
271: 'plsql');
272: arp_standard.debug( 'p_amount = ' || p_amount,
266: p_cust_trx_line_salesrep_id,
267: 'plsql');
268: arp_standard.debug( 'p_account_class = ' || p_account_class,
269: 'plsql');
270: arp_standard.debug( 'p_percent = ' || p_percent,
271: 'plsql');
272: arp_standard.debug( 'p_amount = ' || p_amount,
273: 'plsql');
274: arp_standard.debug( 'p_acctd_amount = ' || p_acctd_amount,
268: arp_standard.debug( 'p_account_class = ' || p_account_class,
269: 'plsql');
270: arp_standard.debug( 'p_percent = ' || p_percent,
271: 'plsql');
272: arp_standard.debug( 'p_amount = ' || p_amount,
273: 'plsql');
274: arp_standard.debug( 'p_acctd_amount = ' || p_acctd_amount,
275: 'plsql');
276: arp_standard.debug( 'p_gl_date = ' || p_gl_date,
270: arp_standard.debug( 'p_percent = ' || p_percent,
271: 'plsql');
272: arp_standard.debug( 'p_amount = ' || p_amount,
273: 'plsql');
274: arp_standard.debug( 'p_acctd_amount = ' || p_acctd_amount,
275: 'plsql');
276: arp_standard.debug( 'p_gl_date = ' || p_gl_date,
277: 'plsql');
278: arp_standard.debug( 'p_original_gl_date = ' || p_original_gl_date,
272: arp_standard.debug( 'p_amount = ' || p_amount,
273: 'plsql');
274: arp_standard.debug( 'p_acctd_amount = ' || p_acctd_amount,
275: 'plsql');
276: arp_standard.debug( 'p_gl_date = ' || p_gl_date,
277: 'plsql');
278: arp_standard.debug( 'p_original_gl_date = ' || p_original_gl_date,
279: 'plsql');
280: arp_standard.debug( 'p_code_combination_id = ' || p_code_combination_id,
274: arp_standard.debug( 'p_acctd_amount = ' || p_acctd_amount,
275: 'plsql');
276: arp_standard.debug( 'p_gl_date = ' || p_gl_date,
277: 'plsql');
278: arp_standard.debug( 'p_original_gl_date = ' || p_original_gl_date,
279: 'plsql');
280: arp_standard.debug( 'p_code_combination_id = ' || p_code_combination_id,
281: 'plsql');
282: arp_standard.debug( 'p_concatenated_segments = ' || p_concatenated_segments,
276: arp_standard.debug( 'p_gl_date = ' || p_gl_date,
277: 'plsql');
278: arp_standard.debug( 'p_original_gl_date = ' || p_original_gl_date,
279: 'plsql');
280: arp_standard.debug( 'p_code_combination_id = ' || p_code_combination_id,
281: 'plsql');
282: arp_standard.debug( 'p_concatenated_segments = ' || p_concatenated_segments,
283: 'plsql');
284: arp_standard.debug( 'p_collected_tax_ccid = ' || p_collected_tax_ccid,
278: arp_standard.debug( 'p_original_gl_date = ' || p_original_gl_date,
279: 'plsql');
280: arp_standard.debug( 'p_code_combination_id = ' || p_code_combination_id,
281: 'plsql');
282: arp_standard.debug( 'p_concatenated_segments = ' || p_concatenated_segments,
283: 'plsql');
284: arp_standard.debug( 'p_collected_tax_ccid = ' || p_collected_tax_ccid,
285: 'plsql');
286: arp_standard.debug( 'p_collected_tax_concat_seg = ' || p_collected_tax_concat_seg,
280: arp_standard.debug( 'p_code_combination_id = ' || p_code_combination_id,
281: 'plsql');
282: arp_standard.debug( 'p_concatenated_segments = ' || p_concatenated_segments,
283: 'plsql');
284: arp_standard.debug( 'p_collected_tax_ccid = ' || p_collected_tax_ccid,
285: 'plsql');
286: arp_standard.debug( 'p_collected_tax_concat_seg = ' || p_collected_tax_concat_seg,
287: 'plsql');
288: arp_standard.debug( 'p_comments = ' || p_comments,
282: arp_standard.debug( 'p_concatenated_segments = ' || p_concatenated_segments,
283: 'plsql');
284: arp_standard.debug( 'p_collected_tax_ccid = ' || p_collected_tax_ccid,
285: 'plsql');
286: arp_standard.debug( 'p_collected_tax_concat_seg = ' || p_collected_tax_concat_seg,
287: 'plsql');
288: arp_standard.debug( 'p_comments = ' || p_comments,
289: 'plsql');
290: arp_standard.debug( 'p_account_set_flag = ' || p_account_set_flag,
284: arp_standard.debug( 'p_collected_tax_ccid = ' || p_collected_tax_ccid,
285: 'plsql');
286: arp_standard.debug( 'p_collected_tax_concat_seg = ' || p_collected_tax_concat_seg,
287: 'plsql');
288: arp_standard.debug( 'p_comments = ' || p_comments,
289: 'plsql');
290: arp_standard.debug( 'p_account_set_flag = ' || p_account_set_flag,
291: 'plsql');
292: arp_standard.debug( 'p_ussgl_transaction_code = ' ||
286: arp_standard.debug( 'p_collected_tax_concat_seg = ' || p_collected_tax_concat_seg,
287: 'plsql');
288: arp_standard.debug( 'p_comments = ' || p_comments,
289: 'plsql');
290: arp_standard.debug( 'p_account_set_flag = ' || p_account_set_flag,
291: 'plsql');
292: arp_standard.debug( 'p_ussgl_transaction_code = ' ||
293: p_ussgl_transaction_code,
294: 'plsql');
288: arp_standard.debug( 'p_comments = ' || p_comments,
289: 'plsql');
290: arp_standard.debug( 'p_account_set_flag = ' || p_account_set_flag,
291: 'plsql');
292: arp_standard.debug( 'p_ussgl_transaction_code = ' ||
293: p_ussgl_transaction_code,
294: 'plsql');
295: arp_standard.debug( 'p_ussgl_trx_code_context = ' ||
296: p_ussgl_trx_code_context,
291: 'plsql');
292: arp_standard.debug( 'p_ussgl_transaction_code = ' ||
293: p_ussgl_transaction_code,
294: 'plsql');
295: arp_standard.debug( 'p_ussgl_trx_code_context = ' ||
296: p_ussgl_trx_code_context,
297: 'plsql');
298: arp_standard.debug( 'p_attribute_category = ' || p_attribute_category,
299: 'plsql');
294: 'plsql');
295: arp_standard.debug( 'p_ussgl_trx_code_context = ' ||
296: p_ussgl_trx_code_context,
297: 'plsql');
298: arp_standard.debug( 'p_attribute_category = ' || p_attribute_category,
299: 'plsql');
300: arp_standard.debug( 'p_attribute1 = ' || p_attribute1,
301: 'plsql');
302: arp_standard.debug( 'p_attribute2 = ' || p_attribute2,
296: p_ussgl_trx_code_context,
297: 'plsql');
298: arp_standard.debug( 'p_attribute_category = ' || p_attribute_category,
299: 'plsql');
300: arp_standard.debug( 'p_attribute1 = ' || p_attribute1,
301: 'plsql');
302: arp_standard.debug( 'p_attribute2 = ' || p_attribute2,
303: 'plsql');
304: arp_standard.debug( 'p_attribute3 = ' || p_attribute3,
298: arp_standard.debug( 'p_attribute_category = ' || p_attribute_category,
299: 'plsql');
300: arp_standard.debug( 'p_attribute1 = ' || p_attribute1,
301: 'plsql');
302: arp_standard.debug( 'p_attribute2 = ' || p_attribute2,
303: 'plsql');
304: arp_standard.debug( 'p_attribute3 = ' || p_attribute3,
305: 'plsql');
306: arp_standard.debug( 'p_attribute4 = ' || p_attribute4,
300: arp_standard.debug( 'p_attribute1 = ' || p_attribute1,
301: 'plsql');
302: arp_standard.debug( 'p_attribute2 = ' || p_attribute2,
303: 'plsql');
304: arp_standard.debug( 'p_attribute3 = ' || p_attribute3,
305: 'plsql');
306: arp_standard.debug( 'p_attribute4 = ' || p_attribute4,
307: 'plsql');
308: arp_standard.debug( 'p_attribute5 = ' || p_attribute5,
302: arp_standard.debug( 'p_attribute2 = ' || p_attribute2,
303: 'plsql');
304: arp_standard.debug( 'p_attribute3 = ' || p_attribute3,
305: 'plsql');
306: arp_standard.debug( 'p_attribute4 = ' || p_attribute4,
307: 'plsql');
308: arp_standard.debug( 'p_attribute5 = ' || p_attribute5,
309: 'plsql');
310: arp_standard.debug( 'p_attribute6 = ' || p_attribute6,
304: arp_standard.debug( 'p_attribute3 = ' || p_attribute3,
305: 'plsql');
306: arp_standard.debug( 'p_attribute4 = ' || p_attribute4,
307: 'plsql');
308: arp_standard.debug( 'p_attribute5 = ' || p_attribute5,
309: 'plsql');
310: arp_standard.debug( 'p_attribute6 = ' || p_attribute6,
311: 'plsql');
312: arp_standard.debug( 'p_attribute7 = ' || p_attribute7,
306: arp_standard.debug( 'p_attribute4 = ' || p_attribute4,
307: 'plsql');
308: arp_standard.debug( 'p_attribute5 = ' || p_attribute5,
309: 'plsql');
310: arp_standard.debug( 'p_attribute6 = ' || p_attribute6,
311: 'plsql');
312: arp_standard.debug( 'p_attribute7 = ' || p_attribute7,
313: 'plsql');
314: arp_standard.debug( 'p_attribute8 = ' || p_attribute8,
308: arp_standard.debug( 'p_attribute5 = ' || p_attribute5,
309: 'plsql');
310: arp_standard.debug( 'p_attribute6 = ' || p_attribute6,
311: 'plsql');
312: arp_standard.debug( 'p_attribute7 = ' || p_attribute7,
313: 'plsql');
314: arp_standard.debug( 'p_attribute8 = ' || p_attribute8,
315: 'plsql');
316: arp_standard.debug( 'p_attribute9 = ' || p_attribute9,
310: arp_standard.debug( 'p_attribute6 = ' || p_attribute6,
311: 'plsql');
312: arp_standard.debug( 'p_attribute7 = ' || p_attribute7,
313: 'plsql');
314: arp_standard.debug( 'p_attribute8 = ' || p_attribute8,
315: 'plsql');
316: arp_standard.debug( 'p_attribute9 = ' || p_attribute9,
317: 'plsql');
318: arp_standard.debug( 'p_attribute10 = ' || p_attribute10,
312: arp_standard.debug( 'p_attribute7 = ' || p_attribute7,
313: 'plsql');
314: arp_standard.debug( 'p_attribute8 = ' || p_attribute8,
315: 'plsql');
316: arp_standard.debug( 'p_attribute9 = ' || p_attribute9,
317: 'plsql');
318: arp_standard.debug( 'p_attribute10 = ' || p_attribute10,
319: 'plsql');
320: arp_standard.debug( 'p_attribute11 = ' || p_attribute11,
314: arp_standard.debug( 'p_attribute8 = ' || p_attribute8,
315: 'plsql');
316: arp_standard.debug( 'p_attribute9 = ' || p_attribute9,
317: 'plsql');
318: arp_standard.debug( 'p_attribute10 = ' || p_attribute10,
319: 'plsql');
320: arp_standard.debug( 'p_attribute11 = ' || p_attribute11,
321: 'plsql');
322: arp_standard.debug( 'p_attribute12 = ' || p_attribute12,
316: arp_standard.debug( 'p_attribute9 = ' || p_attribute9,
317: 'plsql');
318: arp_standard.debug( 'p_attribute10 = ' || p_attribute10,
319: 'plsql');
320: arp_standard.debug( 'p_attribute11 = ' || p_attribute11,
321: 'plsql');
322: arp_standard.debug( 'p_attribute12 = ' || p_attribute12,
323: 'plsql');
324: arp_standard.debug( 'p_attribute13 = ' || p_attribute13,
318: arp_standard.debug( 'p_attribute10 = ' || p_attribute10,
319: 'plsql');
320: arp_standard.debug( 'p_attribute11 = ' || p_attribute11,
321: 'plsql');
322: arp_standard.debug( 'p_attribute12 = ' || p_attribute12,
323: 'plsql');
324: arp_standard.debug( 'p_attribute13 = ' || p_attribute13,
325: 'plsql');
326: arp_standard.debug( 'p_attribute14 = ' || p_attribute14,
320: arp_standard.debug( 'p_attribute11 = ' || p_attribute11,
321: 'plsql');
322: arp_standard.debug( 'p_attribute12 = ' || p_attribute12,
323: 'plsql');
324: arp_standard.debug( 'p_attribute13 = ' || p_attribute13,
325: 'plsql');
326: arp_standard.debug( 'p_attribute14 = ' || p_attribute14,
327: 'plsql');
328: arp_standard.debug( 'p_attribute15 = ' || p_attribute15,
322: arp_standard.debug( 'p_attribute12 = ' || p_attribute12,
323: 'plsql');
324: arp_standard.debug( 'p_attribute13 = ' || p_attribute13,
325: 'plsql');
326: arp_standard.debug( 'p_attribute14 = ' || p_attribute14,
327: 'plsql');
328: arp_standard.debug( 'p_attribute15 = ' || p_attribute15,
329: 'plsql');
330: END IF;
324: arp_standard.debug( 'p_attribute13 = ' || p_attribute13,
325: 'plsql');
326: arp_standard.debug( 'p_attribute14 = ' || p_attribute14,
327: 'plsql');
328: arp_standard.debug( 'p_attribute15 = ' || p_attribute15,
329: 'plsql');
330: END IF;
331:
332: RAISE;
346: | |
347: | SCOPE - PRIVATE |
348: | |
349: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
350: | arp_standard.debug |
351: | |
352: | ARGUMENTS : IN: |
353: | p_customer_trx_id |
354: | p_customer_trx_line_id |
399: l_valid_orig_gl_date DATE;
400:
401: BEGIN
402: IF PG_DEBUG in ('Y', 'C') THEN
403: arp_standard.debug('arp_insert_dist_cover.set_original_gl_date()+');
404: END IF;
405:
406: IF p_account_class <> 'REV'
407: THEN
422: END IF;
423: RETURN l_valid_orig_gl_date;
424:
425: IF PG_DEBUG in ('Y', 'C') THEN
426: arp_standard.debug('arp_insert_dist_cover.set_original_gl_date()-',
427: 'plsql');
428: END IF;
429: EXCEPTION
430: WHEN OTHERS THEN
429: EXCEPTION
430: WHEN OTHERS THEN
431:
432: IF PG_DEBUG in ('Y', 'C') THEN
433: arp_standard.debug('EXCEPTION: arp_process_dist.insert_dist_cover()'||
434: sqlerrm, 'plsql');
435: END IF;
436: RETURN p_original_gl_date;
437: END set_original_gl_date;