1: PACKAGE BODY ARP_TRX_LINE_UTIL AS
2: /* $Header: ARTCTLTB.pls 120.12.12010000.3 2008/11/21 09:37:10 npanchak ship $ */
3:
4: /*===========================================================================+
5: | FUNCTION |
145:
146: BEGIN
147:
148: IF PG_DEBUG in ('Y', 'C') THEN
149: arp_util.debug('arp_trx_line_util.derive_last_pd_to_cr()+');
150: END IF;
151:
152: /*-------------------------------------------------+
153: | Validate that the Last GL Date is between the |
219: ( gl_dates_rec.gl_date - l_prior_date );
220: END IF;
221:
222: IF PG_DEBUG in ('Y', 'C') THEN
223: arp_util.debug('arp_trx_line_util.derive_last_pd_to_cr()-');
224: END IF;
225: RETURN( l_period_count + l_period_fraction );
226:
227: ELSE /* p_last_date_to_credit = gl_dates_rec.gl_date */
226:
227: ELSE /* p_last_date_to_credit = gl_dates_rec.gl_date */
228:
229: IF PG_DEBUG in ('Y', 'C') THEN
230: arp_util.debug('arp_trx_line_util.derive_last_pd_to_cr()-');
231: END IF;
232: RETURN( l_period_count );
233:
234: END IF; /* IF ( p_last_date_to_credit < gl_dates_rec.gl_date ) */
243:
244: EXCEPTION
245: WHEN OTHERS THEN
246: IF PG_DEBUG in ('Y', 'C') THEN
247: arp_util.debug('EXCEPTION: arp_trx_line_util.derive_last_pd_to_cr()');
248: arp_util.debug('derive_last_pd_to_cr: ' || '----- Parameters for ' ||
249: 'arp_trx_line_util.derive_last_pd_to_cr() ' || '-----' );
250: arp_util.debug('derive_last_pd_to_cr: ' || 'p_customer_trx_line_id = ' || p_customer_trx_line_id );
251: arp_util.debug('derive_last_pd_to_cr: ' || 'p_last_date_to_credit = ' || p_last_date_to_credit );
245: WHEN OTHERS THEN
246: IF PG_DEBUG in ('Y', 'C') THEN
247: arp_util.debug('EXCEPTION: arp_trx_line_util.derive_last_pd_to_cr()');
248: arp_util.debug('derive_last_pd_to_cr: ' || '----- Parameters for ' ||
249: 'arp_trx_line_util.derive_last_pd_to_cr() ' || '-----' );
250: arp_util.debug('derive_last_pd_to_cr: ' || 'p_customer_trx_line_id = ' || p_customer_trx_line_id );
251: arp_util.debug('derive_last_pd_to_cr: ' || 'p_last_date_to_credit = ' || p_last_date_to_credit );
252: END IF;
253: RAISE;
284:
285: BEGIN
286:
287: IF PG_DEBUG in ('Y', 'C') THEN
288: arp_util.debug('arp_trx_line_util.get_default_line_num()+');
289: END IF;
290:
291: SELECT nvl( max(line_number), 0 ) + 1
292: INTO p_line_number
294: WHERE customer_trx_id = p_customer_trx_id
295: AND line_type in ('LINE', 'CB', 'CHARGES');
296:
297: IF PG_DEBUG in ('Y', 'C') THEN
298: arp_util.debug('arp_trx_line_util.get_default_line_num()-');
299: END IF;
300:
301: EXCEPTION
302: WHEN OTHERS THEN
300:
301: EXCEPTION
302: WHEN OTHERS THEN
303: IF PG_DEBUG in ('Y', 'C') THEN
304: arp_util.debug('EXCEPTION: arp_trx_line_util.get_default_line_num()');
305: arp_util.debug('get_default_line_num: ' ||
306: '---------- ' ||
307: 'Parameters for arp_trx_line_util.get_default_line_num() ' ||
308: '---------- ');
303: IF PG_DEBUG in ('Y', 'C') THEN
304: arp_util.debug('EXCEPTION: arp_trx_line_util.get_default_line_num()');
305: arp_util.debug('get_default_line_num: ' ||
306: '---------- ' ||
307: 'Parameters for arp_trx_line_util.get_default_line_num() ' ||
308: '---------- ');
309: arp_util.debug('get_default_line_num: ' || 'p_customer_trx_id = ' || p_customer_trx_id);
310: END IF;
311:
369:
370: BEGIN
371:
372: IF PG_DEBUG in ('Y', 'C') THEN
373: arp_util.debug('arp_trx_line_util.get_item_flex_defaults()+');
374: END IF;
375:
376: SELECT msi.description,
377: muom.uom_code,
432: rr.occurrences,
433: rr.frequency;
434:
435: IF PG_DEBUG in ('Y', 'C') THEN
436: arp_util.debug('arp_trx_line_util.get_item_flex_defaults()-');
437: END IF;
438:
439: EXCEPTION
440: WHEN OTHERS THEN
438:
439: EXCEPTION
440: WHEN OTHERS THEN
441: IF PG_DEBUG in ('Y', 'C') THEN
442: arp_util.debug('EXCEPTION: arp_trx_line_util.get_item_flex_defaults()');
443: arp_util.debug('get_item_flex_defaults: ' ||
444: '---------- ' ||
445: 'Parameters for arp_trx_line_util.get_item_flex_defaults() ' ||
446: '---------- ');
441: IF PG_DEBUG in ('Y', 'C') THEN
442: arp_util.debug('EXCEPTION: arp_trx_line_util.get_item_flex_defaults()');
443: arp_util.debug('get_item_flex_defaults: ' ||
444: '---------- ' ||
445: 'Parameters for arp_trx_line_util.get_item_flex_defaults() ' ||
446: '---------- ');
447: arp_util.debug('get_item_flex_defaults: ' || 'p_inventory_item_id = ' || p_inventory_item_id);
448: arp_util.debug('get_item_flex_defaults: ' || 'p_organization_id = ' || p_organization_id );
449: arp_util.debug('get_item_flex_defaults: ' || 'p_trx_date = ' || p_trx_date );
722: WHEN OTHERS THEN
723: RETURN NULL;
724: END;
725:
726: END ARP_TRX_LINE_UTIL;