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_PROCESS_CREDIT_UTIL dependencies on ARP_PROCESS_CREDIT_UTIL

Line 1: PACKAGE BODY ARP_PROCESS_CREDIT_UTIL AS

1: PACKAGE BODY ARP_PROCESS_CREDIT_UTIL AS
2: /* $Header: ARTECMUB.pls 120.12.12010000.1 2008/07/24 16:55:42 appldev ship $ */
3:
4: pg_set_of_books_id ar_system_parameters.set_of_books_id%type;
5:

Line 41: arp_util.debug('arp_process_credit_util.get_commitment_adjustments()+');

37: IS
38: l_amount number;
39: BEGIN
40: IF PG_DEBUG in ('Y', 'C') THEN
41: arp_util.debug('arp_process_credit_util.get_commitment_adjustments()+');
42: END IF;
43:
44: SELECT sum(amount)
45: INTO l_amount

Line 58: arp_util.debug('arp_process_credit_util.get_commitment_adjustments()-');

54:
55: return(l_amount);
56:
57: IF PG_DEBUG in ('Y', 'C') THEN
58: arp_util.debug('arp_process_credit_util.get_commitment_adjustments()-');
59: END IF;
60:
61: EXCEPTION
62:

Line 66: 'arp_process_credit_util.get_commitment_adjustments');

62:
63: WHEN OTHERS THEN
64: IF PG_DEBUG in ('Y', 'C') THEN
65: arp_util.debug('get_commitment_adjustments: ' || 'EXCEPTION : '||
66: 'arp_process_credit_util.get_commitment_adjustments');
67: arp_util.debug('get_commitment_adjustments: ' || 'p_ct_id : '||p_ct_id);
68: arp_util.debug('get_commitment_adjustments: ' || 'p_commit_ct_id : '||p_commit_ct_id);
69: END IF;
70: RAISE;

Line 114: arp_util.debug('arp_process_credit_util.get_commitment_adj_detail()+');

110: p_freight_amount IN OUT NOCOPY number)
111: IS
112: BEGIN
113: IF PG_DEBUG in ('Y', 'C') THEN
114: arp_util.debug('arp_process_credit_util.get_commitment_adj_detail()+');
115: END IF;
116:
117: SELECT sum(amount), sum(NVL(line_adjusted,0)),
118: sum(NVL(tax_adjusted,0)), sum(NVL(freight_adjusted,0))

Line 133: arp_util.debug('arp_process_credit_util.get_commitment_adj_detail()-');

129: AND adj.customer_trx_id = p_ct_id
130: AND adj.adjustment_type = 'C';
131:
132: IF PG_DEBUG in ('Y', 'C') THEN
133: arp_util.debug('arp_process_credit_util.get_commitment_adj_detail()-');
134: END IF;
135:
136: EXCEPTION
137:

Line 141: 'arp_process_credit_util.get_commitment_adj_detail()');

137:
138: WHEN OTHERS THEN
139: IF PG_DEBUG in ('Y', 'C') THEN
140: arp_util.debug('get_commitment_adj_detail: ' || 'EXCEPTION : '||
141: 'arp_process_credit_util.get_commitment_adj_detail()');
142: arp_util.debug('get_commitment_adj_detail: ' || 'p_ct_id : '||p_ct_id);
143: arp_util.debug('get_commitment_adj_detail: ' || 'p_commit_ct_id : '||p_commit_ct_id);
144: END IF;
145: RAISE;

Line 225: arp_util.debug('arp_process_credit_util.get_credited_trx_amounts()+');

221: l_num_installments number;
222: BEGIN
223:
224: IF PG_DEBUG in ('Y', 'C') THEN
225: arp_util.debug('arp_process_credit_util.get_credited_trx_amounts()+');
226: END IF;
227:
228: /*--------------------------------------------------------------------+
229: | get count of installments and lines by type |

Line 309: arp_util.debug('arp_process_credit_util.get_credited_trx_amounts()-');

305: p_num_frt_lines := l_num_frt_lines;
306: p_num_installments := l_num_installments;
307:
308: IF PG_DEBUG in ('Y', 'C') THEN
309: arp_util.debug('arp_process_credit_util.get_credited_trx_amounts()-');
310: END IF;
311:
312: EXCEPTION
313: WHEN OTHERS THEN

Line 316: 'arp_process_credit_util.get_credited_trx_amounts');

312: EXCEPTION
313: WHEN OTHERS THEN
314: IF PG_DEBUG in ('Y', 'C') THEN
315: arp_util.debug('get_credited_trx_amounts: ' || 'EXCEPTION : '||
316: 'arp_process_credit_util.get_credited_trx_amounts');
317: arp_util.debug('get_credited_trx_amounts: ' || 'p_ct_id : '||p_ct_id);
318: arp_util.debug('get_credited_trx_amounts: ' || 'p_commit_ct_id : '||p_commit_ct_id);
319: END IF;
320:

Line 383: arp_util.debug('arp_process_credit_util.get_credited_trx_details()+');

379: IS
380: BEGIN
381:
382: IF PG_DEBUG in ('Y', 'C') THEN
383: arp_util.debug('arp_process_credit_util.get_credited_trx_details()+');
384: END IF;
385:
386: get_credited_trx_amounts(
387: p_ct_id,

Line 414: arp_util.debug('arp_process_credit_util.get_credited_trx_details()-');

410: where customer_trx_id = p_ct_id;
411:
412:
413: IF PG_DEBUG in ('Y', 'C') THEN
414: arp_util.debug('arp_process_credit_util.get_credited_trx_details()-');
415: END IF;
416:
417: EXCEPTION
418: WHEN OTHERS THEN

Line 421: 'arp_process_credit_util.get_credited_trx_details');

417: EXCEPTION
418: WHEN OTHERS THEN
419: IF PG_DEBUG in ('Y', 'C') THEN
420: arp_util.debug('get_credited_trx_details: ' || 'EXCEPTION : '||
421: 'arp_process_credit_util.get_credited_trx_details');
422: arp_util.debug('get_credited_trx_details: ' || 'p_ct_id : '||p_ct_id);
423: arp_util.debug('get_credited_trx_details: ' || 'p_commit_ct_id : '||p_commit_ct_id);
424: END IF;
425:

Line 483: arp_util.debug('arp_process_credit_util.get_credit_memo_amounts()+');

479: l_num_frt_lines number;
480: BEGIN
481:
482: IF PG_DEBUG in ('Y', 'C') THEN
483: arp_util.debug('arp_process_credit_util.get_credit_memo_amounts()+');
484: END IF;
485:
486: SELECT sum(decode(ctl.line_type,
487: 'LINE', ctl.extended_amount,

Line 525: arp_util.debug('arp_process_credit_util.get_credit_memo_amounts()-');

521: p_num_tax_lines := l_num_tax_lines;
522: p_num_frt_lines := l_num_frt_lines;
523:
524: IF PG_DEBUG in ('Y', 'C') THEN
525: arp_util.debug('arp_process_credit_util.get_credit_memo_amounts()-');
526: END IF;
527:
528: EXCEPTION
529: WHEN OTHERS THEN

Line 531: arp_util.debug('EXCEPTION : arp_process_credit_util.get_credit_memo_amounts');

527:
528: EXCEPTION
529: WHEN OTHERS THEN
530: IF PG_DEBUG in ('Y', 'C') THEN
531: arp_util.debug('EXCEPTION : arp_process_credit_util.get_credit_memo_amounts');
532: arp_util.debug('get_credit_memo_amounts: ' || 'p_ct_id : '||p_ct_id);
533: END IF;
534:
535: RAISE;

Line 1212: arp_util.debug('arp_process_credit_util.get_cm_header_defaults()+');

1208: l_nocopy_cust_bank_account_id ce_bank_accounts.bank_account_id%type;
1209:
1210: BEGIN
1211: IF PG_DEBUG in ('Y', 'C') THEN
1212: arp_util.debug('arp_process_credit_util.get_cm_header_defaults()+');
1213: END IF;
1214:
1215: --
1216: -- first try out NOCOPY the credit memo batch source corresponding to

Line 1838: arp_util.debug('arp_process_credit_util.get_cm_header_defaults()-');

1834: p_default_waybill_number := p_crtrx_waybill_number;
1835: p_default_fob_point := p_crtrx_fob_point;
1836:
1837: IF PG_DEBUG in ('Y', 'C') THEN
1838: arp_util.debug('arp_process_credit_util.get_cm_header_defaults()-');
1839: END IF;
1840:
1841: EXCEPTION
1842: WHEN OTHERS THEN

Line 1859: END ARP_PROCESS_CREDIT_UTIL;

1855: END init;
1856:
1857: BEGIN
1858: init;
1859: END ARP_PROCESS_CREDIT_UTIL;
1860: