eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ARP_TRX_TAX_UTIL dependencies on ARP_TRX_TAX_UTIL

Line 1: PACKAGE BODY ARP_TRX_TAX_UTIL AS

1: PACKAGE BODY ARP_TRX_TAX_UTIL AS
2: /* $Header: ARTCTTXB.pls 115.4 2003/10/10 14:27:45 mraymond ship $ */
3:
4: /*===========================================================================+
5: | PROCEDURE |

Line 41: arp_util.debug('arp_trx_tax_util.get_default_line_num()+');

37:
38: BEGIN
39:
40: IF PG_DEBUG in ('Y', 'C') THEN
41: arp_util.debug('arp_trx_tax_util.get_default_line_num()+');
42: END IF;
43:
44: SELECT nvl( max(line_number), 0 ) + 1
45: INTO p_line_number

Line 52: arp_util.debug('arp_trx_tax_util.get_default_line_num()-');

48: AND link_to_cust_trx_line_id = p_customer_trx_line_id
49: AND line_type = 'TAX';
50:
51: IF PG_DEBUG in ('Y', 'C') THEN
52: arp_util.debug('arp_trx_tax_util.get_default_line_num()-');
53: END IF;
54:
55: EXCEPTION
56: WHEN OTHERS THEN

Line 58: arp_util.debug('EXCEPTION: arp_trx_tax_util.get_default_line_num()');

54:
55: EXCEPTION
56: WHEN OTHERS THEN
57: IF PG_DEBUG in ('Y', 'C') THEN
58: arp_util.debug('EXCEPTION: arp_trx_tax_util.get_default_line_num()');
59: arp_util.debug('get_default_line_num: ' ||
60: '---------- ' ||
61: 'Parameters for arp_trx_tax_util.get_default_line_num() ' ||
62: '---------- ');

Line 61: 'Parameters for arp_trx_tax_util.get_default_line_num() ' ||

57: IF PG_DEBUG in ('Y', 'C') THEN
58: arp_util.debug('EXCEPTION: arp_trx_tax_util.get_default_line_num()');
59: arp_util.debug('get_default_line_num: ' ||
60: '---------- ' ||
61: 'Parameters for arp_trx_tax_util.get_default_line_num() ' ||
62: '---------- ');
63: arp_util.debug('get_default_line_num: ' || 'p_customer_trx_id = ' || p_customer_trx_id);
64: END IF;
65:

Line 133: arp_util.debug('arp_trx_tax_util.get_item_flex_defaults()+');

129:
130: BEGIN
131:
132: IF PG_DEBUG in ('Y', 'C') THEN
133: arp_util.debug('arp_trx_tax_util.get_item_flex_defaults()+');
134: END IF;
135:
136: SELECT msi.description,
137: DECODE( SIGN( p_trx_date - TRUNC( NVL(muom.disable_date,

Line 201: arp_util.debug('arp_trx_tax_util.get_item_flex_defaults()-');

197: rr.occurrences,
198: rr.frequency;
199:
200: IF PG_DEBUG in ('Y', 'C') THEN
201: arp_util.debug('arp_trx_tax_util.get_item_flex_defaults()-');
202: END IF;
203:
204: EXCEPTION
205: WHEN OTHERS THEN

Line 207: arp_util.debug('EXCEPTION: arp_trx_tax_util.get_item_flex_defaults()');

203:
204: EXCEPTION
205: WHEN OTHERS THEN
206: IF PG_DEBUG in ('Y', 'C') THEN
207: arp_util.debug('EXCEPTION: arp_trx_tax_util.get_item_flex_defaults()');
208: arp_util.debug('get_item_flex_defaults: ' ||
209: '---------- ' ||
210: 'Parameters for arp_trx_tax_util.get_item_flex_defaults() ' ||
211: '---------- ');

Line 210: 'Parameters for arp_trx_tax_util.get_item_flex_defaults() ' ||

206: IF PG_DEBUG in ('Y', 'C') THEN
207: arp_util.debug('EXCEPTION: arp_trx_tax_util.get_item_flex_defaults()');
208: arp_util.debug('get_item_flex_defaults: ' ||
209: '---------- ' ||
210: 'Parameters for arp_trx_tax_util.get_item_flex_defaults() ' ||
211: '---------- ');
212: arp_util.debug('get_item_flex_defaults: ' || 'p_inventory_item_id = ' || p_inventory_item_id);
213: arp_util.debug('get_item_flex_defaults: ' || 'p_organization_id = ' || p_organization_id );
214: arp_util.debug('get_item_flex_defaults: ' || 'p_trx_date = ' || p_trx_date );

Line 260: arp_util.debug('arp_trx_tax_util.select_summary()+');

256:
257: BEGIN
258:
259: IF PG_DEBUG in ('Y', 'C') THEN
260: arp_util.debug('arp_trx_tax_util.select_summary()+');
261: END IF;
262:
263: SELECT nvl(sum(extended_amount),0), nvl(sum(extended_amount),0)
264: INTO p_total, p_total_rtot_db

Line 275: arp_util.debug('arp_trx_tax_util.select_summary()-');

271: -10 )
272: AND line_type = 'TAX';
273:
274: IF PG_DEBUG in ('Y', 'C') THEN
275: arp_util.debug('arp_trx_tax_util.select_summary()-');
276: END IF;
277:
278: EXCEPTION
279: WHEN OTHERS THEN

Line 281: arp_util.debug('EXCEPTION: arp_trx_tax_util.select_summary()');

277:
278: EXCEPTION
279: WHEN OTHERS THEN
280: IF PG_DEBUG in ('Y', 'C') THEN
281: arp_util.debug('EXCEPTION: arp_trx_tax_util.select_summary()');
282: arp_util.debug('select_summary: ' || 'p_customer_trx_id = ' || p_customer_trx_id);
283: END IF;
284: RAISE;
285: END select_summary;

Line 318: arp_util.debug('arp_trx_tax_util.check_last_line_on_delete()+');

314: IS
315: l_only_tax_line_flag varchar2(2);
316: BEGIN
317:
318: arp_util.debug('arp_trx_tax_util.check_last_line_on_delete()+');
319: SELECT decode(max(dummy),
320: '', 'N',
321: 'Y')
322: INTO l_only_tax_line_flag

Line 337: arp_util.debug('arp_trx_tax_util.check_last_line_on_delete()-');

333: THEN p_only_tax_line_flag := TRUE;
334: ELSE p_only_tax_line_flag := FALSE;
335: END IF;
336:
337: arp_util.debug('arp_trx_tax_util.check_last_line_on_delete()-');
338:
339: EXCEPTION
340: WHEN OTHERS THEN
341: arp_util.debug('EXCEPTION: arp_trx_tax_util.check_last_line_on_delete()');

Line 341: arp_util.debug('EXCEPTION: arp_trx_tax_util.check_last_line_on_delete()');

337: arp_util.debug('arp_trx_tax_util.check_last_line_on_delete()-');
338:
339: EXCEPTION
340: WHEN OTHERS THEN
341: arp_util.debug('EXCEPTION: arp_trx_tax_util.check_last_line_on_delete()');
342: arp_util.debug('p_customer_trx_line_id = ' || p_customer_trx_line_id);
343: RAISE;
344:
345: END;

Line 381: arp_util.debug('arp_trx_tax_util.check_unique_line()+');

377: IS
378: l_unique_line_flag varchar2(2);
379: BEGIN
380:
381: arp_util.debug('arp_trx_tax_util.check_unique_line()+');
382: SELECT decode(max(dummy),
383: '', 'N',
384: 'Y')
385: INTO l_unique_line_flag

Line 402: arp_util.debug('arp_trx_tax_util.check_unique_line()-');

398: ELSE
399: p_unique_line_flag := TRUE;
400: END IF;
401:
402: arp_util.debug('arp_trx_tax_util.check_unique_line()-');
403:
404: EXCEPTION
405: WHEN OTHERS THEN
406: arp_util.debug('EXCEPTION: arp_trx_tax_util.check_unique_line()');

Line 406: arp_util.debug('EXCEPTION: arp_trx_tax_util.check_unique_line()');

402: arp_util.debug('arp_trx_tax_util.check_unique_line()-');
403:
404: EXCEPTION
405: WHEN OTHERS THEN
406: arp_util.debug('EXCEPTION: arp_trx_tax_util.check_unique_line()');
407: arp_util.debug(
408: '---------- ' ||
409: 'Parameters for arp_trx_tax_util.check_unique_line() ' ||
410: '---------- ');

Line 409: 'Parameters for arp_trx_tax_util.check_unique_line() ' ||

405: WHEN OTHERS THEN
406: arp_util.debug('EXCEPTION: arp_trx_tax_util.check_unique_line()');
407: arp_util.debug(
408: '---------- ' ||
409: 'Parameters for arp_trx_tax_util.check_unique_line() ' ||
410: '---------- ');
411: arp_util.debug('p_customer_trx_line_id = ' || p_customer_trx_line_id);
412: arp_util.debug('p_customer_trx_line_number = ' || p_customer_trx_line_num);
413:

Line 446: arp_util.debug('arp_trx_tax_util.tax_balance()+');

442:
443: RETURN NUMBER IS
444: l_balance_due number;
445: Begin
446: arp_util.debug('arp_trx_tax_util.tax_balance()+');
447:
448: /* Calculate Balance Due By Checking Any other Credit Memos
449: Which Are Complete */
450:

Line 462: arp_util.debug('arp_trx_tax_util.tax_balance()-');

458: AND ct.complete_flag = 'Y';
459:
460: return(l_balance_due);
461:
462: arp_util.debug('arp_trx_tax_util.tax_balance()-');
463:
464: EXCEPTION
465: WHEN OTHERS THEN
466: arp_util.debug('EXCEPTION: arp_trx_tax_util.tax_balance');

Line 466: arp_util.debug('EXCEPTION: arp_trx_tax_util.tax_balance');

462: arp_util.debug('arp_trx_tax_util.tax_balance()-');
463:
464: EXCEPTION
465: WHEN OTHERS THEN
466: arp_util.debug('EXCEPTION: arp_trx_tax_util.tax_balance');
467: RAISE;
468: End;
469:
470: /*===========================================================================+

Line 502: arp_util.debug('arp_trx_tax_util.check_tax_code()+');

498: IS
499: l_adhoc_tax_flag varchar2(2);
500: BEGIN
501:
502: arp_util.debug('arp_trx_tax_util.check_tax_code()+');
503: SELECT validate_flag
504: INTO l_adhoc_tax_flag
505: FROM ar_vat_tax
506: WHERE tax_code = p_tax_code;

Line 515: arp_util.debug('arp_trx_tax_util.check_tax_code()-');

511: ELSE
512: p_adhoc_tax_flag := FALSE;
513: END IF;
514:
515: arp_util.debug('arp_trx_tax_util.check_tax_code()-');
516:
517: EXCEPTION
518: WHEN OTHERS THEN
519: arp_util.debug('EXCEPTION: arp_trx_tax_util.check_tax_code()');

Line 519: arp_util.debug('EXCEPTION: arp_trx_tax_util.check_tax_code()');

515: arp_util.debug('arp_trx_tax_util.check_tax_code()-');
516:
517: EXCEPTION
518: WHEN OTHERS THEN
519: arp_util.debug('EXCEPTION: arp_trx_tax_util.check_tax_code()');
520: arp_util.debug(
521: '---------- ' ||
522: 'Parameters for arp_trx_tax_util.check_tax_code() ' ||
523: '---------- ');

Line 522: 'Parameters for arp_trx_tax_util.check_tax_code() ' ||

518: WHEN OTHERS THEN
519: arp_util.debug('EXCEPTION: arp_trx_tax_util.check_tax_code()');
520: arp_util.debug(
521: '---------- ' ||
522: 'Parameters for arp_trx_tax_util.check_tax_code() ' ||
523: '---------- ');
524: arp_util.debug('p_tax_code = ' || p_tax_code);
525:
526: RAISE;

Line 528: END ARP_TRX_TAX_UTIL;

524: arp_util.debug('p_tax_code = ' || p_tax_code);
525:
526: RAISE;
527: END;
528: END ARP_TRX_TAX_UTIL;