1: PACKAGE BODY ARP_PROCESS_BR_LINE AS
2: /* $Header: ARTEBRLB.pls 120.9 2005/08/10 23:15:35 hyu ship $ */
3:
4: /*===========================================================================+
5: | PROCEDURE |
33:
34: BEGIN
35:
36: IF PG_DEBUG in ('Y', 'C') THEN
37: arp_util.debug('arp_process_br_line.insert_line()+');
38: END IF;
39:
40: /*------------------------------------------------+
41: | All the validation and defaulting is done in |
62: /*------------------------------------------+
63: | Call MRC logic to create MRC rows |
64: +------------------------------------------*/
65: -- No longer required as arp_ctl_pkg.insert_p does insert the mrc customer_trx_lines
66: -- ARP_PROCESS_BR_LINE.insert_mrc_transaction_line(p_line_rec,
67: -- p_customer_trx_line_id);
68:
69: /*---------------------------------------------------------------------------+
70: | All accounting is done in the accounting engine called by transaction |
71: | history entity handler |
72: +---------------------------------------------------------------------------*/
73:
74: IF PG_DEBUG in ('Y', 'C') THEN
75: arp_util.debug('arp_process_br_line.insert_line()-');
76: END IF;
77:
78: EXCEPTION
79: WHEN OTHERS THEN
77:
78: EXCEPTION
79: WHEN OTHERS THEN
80: IF PG_DEBUG in ('Y', 'C') THEN
81: arp_util.debug('EXCEPTION: arp_process_br_line.insert_line()');
82: END IF;
83: arp_ctl_pkg.display_line_rec(p_line_rec);
84: RAISE;
85:
118:
119: BEGIN
120:
121: IF PG_DEBUG in ('Y', 'C') THEN
122: arp_util.debug('arp_process_br_line.update_line()+');
123: END IF;
124:
125: /*------------------------------------------------+
126: | All the validation and defaulting is done in |
150: | Call MRC logic to create MRC rows |
151: +------------------------------------------*/
152: -- No longer required as the procedure arp_ctl_pkg.update_p does the updation of mrc trx lines
153:
154: -- ARP_PROCESS_BR_LINE.update_mrc_transaction_line(p_line_rec,
155: -- p_customer_trx_line_id);
156:
157: /*---------------------------------------------------------------------------+
158: | All accounting is done in the accounting engine called by transaction |
159: | history entity handler |
160: +---------------------------------------------------------------------------*/
161:
162: IF PG_DEBUG in ('Y', 'C') THEN
163: arp_util.debug('arp_process_br_line.update_line()-');
164: END IF;
165:
166: EXCEPTION
167: WHEN OTHERS THEN
165:
166: EXCEPTION
167: WHEN OTHERS THEN
168: IF PG_DEBUG in ('Y', 'C') THEN
169: arp_util.debug('EXCEPTION: arp_process_br_line.update_line()');
170: END IF;
171: arp_ctl_pkg.display_line_rec(p_line_rec);
172: RAISE;
173:
202: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type) IS
203:
204: BEGIN
205: IF PG_DEBUG in ('Y', 'C') THEN
206: arp_util.debug('arp_process_br_line.delete_line()+');
207: END IF;
208:
209: /*------------------------------------------------+
210: | All the validation and defaulting is done in |
230: /*------------------------------------------+
231: | Call MRC logic to create MRC rows |
232: +------------------------------------------*/
233: -- Should be removed as the arp_ctl_pkg.delete_p does the deletion of mrc lines
234: -- ARP_PROCESS_BR_LINE.delete_mrc_transaction_line(p_customer_trx_line_id);
235:
236: /*---------------------------------------------------------------------------+
237: | All accounting is done in the accounting engine called by transaction |
238: | history entity handler |
238: | history entity handler |
239: +---------------------------------------------------------------------------*/
240:
241: IF PG_DEBUG in ('Y', 'C') THEN
242: arp_util.debug('arp_process_br_line.delete_line()-');
243: END IF;
244:
245: EXCEPTION
246: WHEN OTHERS THEN
244:
245: EXCEPTION
246: WHEN OTHERS THEN
247: IF PG_DEBUG in ('Y', 'C') THEN
248: arp_util.debug('EXCEPTION: arp_process_br_line.delete_line()');
249: arp_util.debug('delete_line: ' || 'p_customer_trx_line_id = ' || p_customer_trx_line_id);
250: END IF;
251: RAISE;
252:
252:
253: END delete_line;
254:
255:
256: END ARP_PROCESS_BR_LINE;