DBA Data[Home] [Help]

APPS.ARP_PROCESS_BR_HEADER dependencies on ARP_PROCESS_BR_HEADER

Line 1: PACKAGE BODY ARP_PROCESS_BR_HEADER AS

1: PACKAGE BODY ARP_PROCESS_BR_HEADER AS
2: /* $Header: ARTEBRHB.pls 120.4.12010000.3 2008/10/31 05:36:19 spdixit ship $ */
3:
4: SUBTYPE ae_doc_rec_type IS arp_acct_main.ae_doc_rec_type;
5:

Line 45: arp_util.debug('delete_transaction: ' || 'arp_process_br_header.insert_header()+');

41: l_transaction_history_id ar_transaction_history.transaction_history_id%TYPE;
42: BEGIN
43:
44: IF PG_DEBUG in ('Y', 'C') THEN
45: arp_util.debug('delete_transaction: ' || 'arp_process_br_header.insert_header()+');
46: END IF;
47:
48: /*------------------------------------------------+
49: | All the validation and defaulting is done in |

Line 100: arp_util.debug('delete_transaction: ' || 'arp_process_br_header.insert_header()-');

96: | history entity handler |
97: +---------------------------------------------------------------------------*/
98:
99: IF PG_DEBUG in ('Y', 'C') THEN
100: arp_util.debug('delete_transaction: ' || 'arp_process_br_header.insert_header()-');
101: END IF;
102:
103: EXCEPTION
104: WHEN OTHERS THEN

Line 106: arp_util.debug('delete_transaction: ' || 'EXCEPTION: arp_process_br_header.insert_header()');

102:
103: EXCEPTION
104: WHEN OTHERS THEN
105: IF PG_DEBUG in ('Y', 'C') THEN
106: arp_util.debug('delete_transaction: ' || 'EXCEPTION: arp_process_br_header.insert_header()');
107: END IF;
108: RAISE;
109:
110: END insert_header;

Line 140: arp_util.debug('delete_transaction: ' || 'arp_process_br_header.update_header()+');

136: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE) IS
137: BEGIN
138:
139: IF PG_DEBUG in ('Y', 'C') THEN
140: arp_util.debug('delete_transaction: ' || 'arp_process_br_header.update_header()+');
141: END IF;
142:
143: /*------------------------------------------------+
144: | All the validation and defaulting is done in |

Line 152: arp_process_br_header.lock_transaction(p_trx_rec.customer_trx_id);

148:
149: /*----------------------------------------------------------------+
150: | Lock rows in other tables that reference this customer_trx_id |
151: +----------------------------------------------------------------*/
152: arp_process_br_header.lock_transaction(p_trx_rec.customer_trx_id);
153:
154: /*----------------------------------------------------------------------+
155: | BR does not have Tax tax itself, deferred tax exists but it is taken |
156: | care of with the transaction history. |

Line 170: arp_util.debug('delete_transaction: ' || 'arp_process_br_header.update_header()-');

166: | Disputing is handled by updating the PS using PS entity handlers |
167: +----------------------------------------------------------------------*/
168:
169: IF PG_DEBUG in ('Y', 'C') THEN
170: arp_util.debug('delete_transaction: ' || 'arp_process_br_header.update_header()-');
171: END IF;
172:
173: EXCEPTION
174: WHEN OTHERS THEN

Line 176: arp_util.debug('delete_transaction: ' || 'EXCEPTION: arp_process_br_header.update_header()');

172:
173: EXCEPTION
174: WHEN OTHERS THEN
175: IF PG_DEBUG in ('Y', 'C') THEN
176: arp_util.debug('delete_transaction: ' || 'EXCEPTION: arp_process_br_header.update_header()');
177: END IF;
178: RAISE;
179:
180: END update_header;

Line 210: arp_util.debug('delete_transaction: ' || 'arp_process_br_header.delete_header()+');

206: l_transaction_history_id NUMBER;
207: BEGIN
208:
209: IF PG_DEBUG in ('Y', 'C') THEN
210: arp_util.debug('delete_transaction: ' || 'arp_process_br_header.delete_header()+');
211: END IF;
212:
213: /*----------------------------------------------------------------+
214: | Lock rows in other tables that reference this customer_trx_id |

Line 216: arp_process_br_header.lock_transaction(p_customer_trx_id);

212:
213: /*----------------------------------------------------------------+
214: | Lock rows in other tables that reference this customer_trx_id |
215: +----------------------------------------------------------------*/
216: arp_process_br_header.lock_transaction(p_customer_trx_id);
217:
218: /*-------------------------+
219: | delete the transaction |
220: +-------------------------*/

Line 232: arp_util.debug('EXCEPTION: getting trh_id in arp_process_br_header.delete_header() '|| sqlerrm);

228:
229: EXCEPTION
230: WHEN OTHERS THEN
231: IF PG_DEBUG in ('Y', 'C') THEN
232: arp_util.debug('EXCEPTION: getting trh_id in arp_process_br_header.delete_header() '|| sqlerrm);
233: END IF;
234: RAISE;
235: END;
236:

Line 240: arp_process_br_header.delete_transaction(p_customer_trx_id);

236:
237: ARP_XLA_EVENTS.delete_event( p_document_id => l_transaction_history_id,
238: p_doc_table => 'TRH');
239:
240: arp_process_br_header.delete_transaction(p_customer_trx_id);
241:
242: IF PG_DEBUG in ('Y', 'C') THEN
243: arp_util.debug('delete_transaction: ' || 'arp_process_br_header.delete_header()-');
244: END IF;

Line 243: arp_util.debug('delete_transaction: ' || 'arp_process_br_header.delete_header()-');

239:
240: arp_process_br_header.delete_transaction(p_customer_trx_id);
241:
242: IF PG_DEBUG in ('Y', 'C') THEN
243: arp_util.debug('delete_transaction: ' || 'arp_process_br_header.delete_header()-');
244: END IF;
245:
246: EXCEPTION
247: WHEN OTHERS THEN

Line 249: arp_util.debug('delete_transaction: ' || 'EXCEPTION: arp_process_br_header.delete_header()');

245:
246: EXCEPTION
247: WHEN OTHERS THEN
248: IF PG_DEBUG in ('Y', 'C') THEN
249: arp_util.debug('delete_transaction: ' || 'EXCEPTION: arp_process_br_header.delete_header()');
250: END IF;
251: RAISE;
252:
253: END delete_header;

Line 282: arp_util.debug('arp_process_br_header.delete_transaction()+');

278:
279: BEGIN
280:
281: IF PG_DEBUG in ('Y', 'C') THEN
282: arp_util.debug('arp_process_br_header.delete_transaction()+');
283: END IF;
284:
285: savepoint ar_br_delete_transaction_1;
286:

Line 293: arp_process_br_header.delete_transaction_dist(p_customer_trx_id);

289: +------------------------------------------------------------------*/
290: arp_ct_pkg.delete_p(p_customer_trx_id);
291: arp_ctl_pkg.delete_f_ct_id(p_customer_trx_id);
292: arp_ps_pkg.delete_f_ct_id(p_customer_trx_id);
293: arp_process_br_header.delete_transaction_dist(p_customer_trx_id);
294: arp_transaction_history_pkg.delete_p(p_trx_id => p_customer_trx_id);
295:
296: IF PG_DEBUG in ('Y', 'C') THEN
297: arp_util.debug('arp_process_br_header.delete_transaction()-');

Line 297: arp_util.debug('arp_process_br_header.delete_transaction()-');

293: arp_process_br_header.delete_transaction_dist(p_customer_trx_id);
294: arp_transaction_history_pkg.delete_p(p_trx_id => p_customer_trx_id);
295:
296: IF PG_DEBUG in ('Y', 'C') THEN
297: arp_util.debug('arp_process_br_header.delete_transaction()-');
298: END IF;
299:
300: EXCEPTION
301: WHEN OTHERS THEN

Line 303: arp_util.debug('EXCEPTION: arp_process_br_header.delete_transaction()');

299:
300: EXCEPTION
301: WHEN OTHERS THEN
302: IF PG_DEBUG in ('Y', 'C') THEN
303: arp_util.debug('EXCEPTION: arp_process_br_header.delete_transaction()');
304: END IF;
305: rollback to savepoint ar_br_delete_transaction_1;
306: RAISE;
307:

Line 336: arp_util.debug('delete_transaction: ' || 'arp_process_br_header.lock_transaction()+');

332: +===========================================================================*/
333: PROCEDURE lock_transaction(p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE) IS
334: BEGIN
335: IF PG_DEBUG in ('Y', 'C') THEN
336: arp_util.debug('delete_transaction: ' || 'arp_process_br_header.lock_transaction()+');
337: END IF;
338:
339: savepoint ar_br_lock_transaction_1;
340:

Line 351: arp_util.debug('delete_transaction: ' || 'arp_process_br_header.lock_transaction()-');

347: arp_adjustments_pkg.lock_f_ct_id(p_customer_trx_id);
348: arp_transaction_history_pkg.lock_f_trx_id(p_customer_trx_id);
349:
350: IF PG_DEBUG in ('Y', 'C') THEN
351: arp_util.debug('delete_transaction: ' || 'arp_process_br_header.lock_transaction()-');
352: END IF;
353:
354: EXCEPTION
355: WHEN OTHERS THEN

Line 357: arp_util.debug('delete_transaction: ' || 'EXCEPTION: arp_process_br_header.lock_transaction');

353:
354: EXCEPTION
355: WHEN OTHERS THEN
356: IF PG_DEBUG in ('Y', 'C') THEN
357: arp_util.debug('delete_transaction: ' || 'EXCEPTION: arp_process_br_header.lock_transaction');
358: END IF;
359: rollback to savepoint ar_br_lock_transaction_1;
360: RAISE;
361:

Line 404: arp_util.debug('arp_process_br_header.delete_transaction_dist()+');

400:
401: BEGIN
402:
403: IF PG_DEBUG in ('Y', 'C') THEN
404: arp_util.debug('arp_process_br_header.delete_transaction_dist()+');
405: END IF;
406:
407: /*------------------------------------------------------------------+
408: | loop through all transaction history rows that have accounting |

Line 422: arp_util.debug('arp_process_br_header.delete_transaction_dist()-');

418:
419: END LOOP;
420:
421: IF PG_DEBUG in ('Y', 'C') THEN
422: arp_util.debug('arp_process_br_header.delete_transaction_dist()-');
423: END IF;
424:
425: EXCEPTION
426: WHEN OTHERS THEN

Line 428: arp_util.debug('EXCEPTION: arp_process_br_header.delete_transaction_dist()');

424:
425: EXCEPTION
426: WHEN OTHERS THEN
427: IF PG_DEBUG in ('Y', 'C') THEN
428: arp_util.debug('EXCEPTION: arp_process_br_header.delete_transaction_dist()');
429: END IF;
430: RAISE;
431:
432: END delete_transaction_dist;

Line 484: arp_util.debug('arp_process_br_header.move_deferred_tax()+');

480: move_deferred_tax_rec move_deferred_tax_cur%ROWTYPE;
481:
482: BEGIN
483: IF PG_DEBUG in ('Y', 'C') THEN
484: arp_util.debug('arp_process_br_header.move_deferred_tax()+');
485: END IF;
486:
487: OPEN move_deferred_tax_cur;
488: FETCH move_deferred_tax_cur INTO move_deferred_tax_rec;

Line 502: arp_util.debug('arp_process_br_header.move_deferred_tax()-');

498:
499: END IF;
500:
501: IF PG_DEBUG in ('Y', 'C') THEN
502: arp_util.debug('arp_process_br_header.move_deferred_tax()-');
503: END IF;
504:
505: EXCEPTION
506: WHEN NO_DATA_FOUND THEN

Line 508: arp_util.debug('EXCEPTION: arp_process_br_header.move_deferred_tax()');

504:
505: EXCEPTION
506: WHEN NO_DATA_FOUND THEN
507: IF PG_DEBUG in ('Y', 'C') THEN
508: arp_util.debug('EXCEPTION: arp_process_br_header.move_deferred_tax()');
509: END IF;
510: p_required := FALSE; --Tax is not deferred processing not required
511:
512: WHEN OTHERS THEN

Line 514: arp_util.debug('EXCEPTION: arp_process_br_header.move_deferred_tax()');

510: p_required := FALSE; --Tax is not deferred processing not required
511:
512: WHEN OTHERS THEN
513: IF PG_DEBUG in ('Y', 'C') THEN
514: arp_util.debug('EXCEPTION: arp_process_br_header.move_deferred_tax()');
515: END IF;
516: p_required := FALSE; --Tax is not deferred processing not required
517:
518: END move_deferred_tax;

Line 521: END ARP_PROCESS_BR_HEADER;

517:
518: END move_deferred_tax;
519:
520:
521: END ARP_PROCESS_BR_HEADER;