DBA Data[Home] [Help]

APPS.ARP_TRX_LINE_UTIL dependencies on ARP_TRX_LINE_UTIL

Line 1: PACKAGE BODY ARP_TRX_LINE_UTIL AS

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 |

Line 149: arp_util.debug('arp_trx_line_util.derive_last_pd_to_cr()+');

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 |

Line 223: arp_util.debug('arp_trx_line_util.derive_last_pd_to_cr()-');

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 */

Line 230: arp_util.debug('arp_trx_line_util.derive_last_pd_to_cr()-');

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 ) */

Line 247: arp_util.debug('EXCEPTION: arp_trx_line_util.derive_last_pd_to_cr()');

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 );

Line 249: 'arp_trx_line_util.derive_last_pd_to_cr() ' || '-----' );

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;

Line 288: arp_util.debug('arp_trx_line_util.get_default_line_num()+');

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

Line 298: arp_util.debug('arp_trx_line_util.get_default_line_num()-');

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

Line 304: arp_util.debug('EXCEPTION: arp_trx_line_util.get_default_line_num()');

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: '---------- ');

Line 307: 'Parameters for arp_trx_line_util.get_default_line_num() ' ||

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:

Line 373: arp_util.debug('arp_trx_line_util.get_item_flex_defaults()+');

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,

Line 436: arp_util.debug('arp_trx_line_util.get_item_flex_defaults()-');

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

Line 442: arp_util.debug('EXCEPTION: arp_trx_line_util.get_item_flex_defaults()');

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: '---------- ');

Line 445: 'Parameters for arp_trx_line_util.get_item_flex_defaults() ' ||

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 );

Line 726: END ARP_TRX_LINE_UTIL;

722: WHEN OTHERS THEN
723: RETURN NULL;
724: END;
725:
726: END ARP_TRX_LINE_UTIL;