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.16 2011/07/19 00:34:16 dgaurab 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 224: arp_util.debug('arp_trx_line_util.derive_last_pd_to_cr()-');

220: ( gl_dates_rec.gl_date - l_prior_date );
221: END IF;
222:
223: IF PG_DEBUG in ('Y', 'C') THEN
224: arp_util.debug('arp_trx_line_util.derive_last_pd_to_cr()-');
225: END IF;
226: RETURN( l_period_count + l_period_fraction );
227:
228: ELSE /* p_last_date_to_credit = gl_dates_rec.gl_date */

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

227:
228: ELSE /* p_last_date_to_credit = gl_dates_rec.gl_date */
229:
230: IF PG_DEBUG in ('Y', 'C') THEN
231: arp_util.debug('arp_trx_line_util.derive_last_pd_to_cr()-');
232: END IF;
233: RETURN( l_period_count );
234:
235: END IF; /* IF ( p_last_date_to_credit < gl_dates_rec.gl_date ) */

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

244:
245: EXCEPTION
246: WHEN OTHERS THEN
247: IF PG_DEBUG in ('Y', 'C') THEN
248: arp_util.debug('EXCEPTION: arp_trx_line_util.derive_last_pd_to_cr()');
249: arp_util.debug('derive_last_pd_to_cr: ' || '----- Parameters for ' ||
250: 'arp_trx_line_util.derive_last_pd_to_cr() ' || '-----' );
251: arp_util.debug('derive_last_pd_to_cr: ' || 'p_customer_trx_line_id = ' || p_customer_trx_line_id );
252: arp_util.debug('derive_last_pd_to_cr: ' || 'p_last_date_to_credit = ' || p_last_date_to_credit );

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

246: WHEN OTHERS THEN
247: IF PG_DEBUG in ('Y', 'C') THEN
248: arp_util.debug('EXCEPTION: arp_trx_line_util.derive_last_pd_to_cr()');
249: arp_util.debug('derive_last_pd_to_cr: ' || '----- Parameters for ' ||
250: 'arp_trx_line_util.derive_last_pd_to_cr() ' || '-----' );
251: arp_util.debug('derive_last_pd_to_cr: ' || 'p_customer_trx_line_id = ' || p_customer_trx_line_id );
252: arp_util.debug('derive_last_pd_to_cr: ' || 'p_last_date_to_credit = ' || p_last_date_to_credit );
253: END IF;
254: RAISE;

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

285:
286: BEGIN
287:
288: IF PG_DEBUG in ('Y', 'C') THEN
289: arp_util.debug('arp_trx_line_util.get_default_line_num()+');
290: END IF;
291:
292: SELECT nvl( max(line_number), 0 ) + 1
293: INTO p_line_number

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

295: WHERE customer_trx_id = p_customer_trx_id
296: AND line_type in ('LINE', 'CB', 'CHARGES');
297:
298: IF PG_DEBUG in ('Y', 'C') THEN
299: arp_util.debug('arp_trx_line_util.get_default_line_num()-');
300: END IF;
301:
302: EXCEPTION
303: WHEN OTHERS THEN

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

301:
302: EXCEPTION
303: WHEN OTHERS THEN
304: IF PG_DEBUG in ('Y', 'C') THEN
305: arp_util.debug('EXCEPTION: arp_trx_line_util.get_default_line_num()');
306: arp_util.debug('get_default_line_num: ' ||
307: '---------- ' ||
308: 'Parameters for arp_trx_line_util.get_default_line_num() ' ||
309: '---------- ');

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

304: IF PG_DEBUG in ('Y', 'C') THEN
305: arp_util.debug('EXCEPTION: arp_trx_line_util.get_default_line_num()');
306: arp_util.debug('get_default_line_num: ' ||
307: '---------- ' ||
308: 'Parameters for arp_trx_line_util.get_default_line_num() ' ||
309: '---------- ');
310: arp_util.debug('get_default_line_num: ' || 'p_customer_trx_id = ' || p_customer_trx_id);
311: END IF;
312:

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

370:
371: BEGIN
372:
373: IF PG_DEBUG in ('Y', 'C') THEN
374: arp_util.debug('arp_trx_line_util.get_item_flex_defaults()+');
375: END IF;
376:
377: SELECT msi.description,
378: muom.uom_code,

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

433: rr.occurrences,
434: rr.frequency;
435:
436: IF PG_DEBUG in ('Y', 'C') THEN
437: arp_util.debug('arp_trx_line_util.get_item_flex_defaults()-');
438: END IF;
439:
440: EXCEPTION
441: WHEN OTHERS THEN

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

439:
440: EXCEPTION
441: WHEN OTHERS THEN
442: IF PG_DEBUG in ('Y', 'C') THEN
443: arp_util.debug('EXCEPTION: arp_trx_line_util.get_item_flex_defaults()');
444: arp_util.debug('get_item_flex_defaults: ' ||
445: '---------- ' ||
446: 'Parameters for arp_trx_line_util.get_item_flex_defaults() ' ||
447: '---------- ');

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

442: IF PG_DEBUG in ('Y', 'C') THEN
443: arp_util.debug('EXCEPTION: arp_trx_line_util.get_item_flex_defaults()');
444: arp_util.debug('get_item_flex_defaults: ' ||
445: '---------- ' ||
446: 'Parameters for arp_trx_line_util.get_item_flex_defaults() ' ||
447: '---------- ');
448: arp_util.debug('get_item_flex_defaults: ' || 'p_inventory_item_id = ' || p_inventory_item_id);
449: arp_util.debug('get_item_flex_defaults: ' || 'p_organization_id = ' || p_organization_id );
450: arp_util.debug('get_item_flex_defaults: ' || 'p_trx_date = ' || p_trx_date );

Line 729: END ARP_TRX_LINE_UTIL;

725: WHEN OTHERS THEN
726: RETURN NULL;
727: END;
728:
729: END ARP_TRX_LINE_UTIL;