DBA Data[Home] [Help]

APPS.ARP_PROCESS_BR_HEADER dependencies on ARP_UTIL

Line 21: | arp_util.debug |

17: | |
18: | SCOPE - PUBLIC |
19: | |
20: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
21: | arp_util.debug |
22: | |
23: | ARGUMENTS : IN: p_trx_rec |
24: | OUT: p_trx_number |
25: | p_customer_trx_id |

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 122: | arp_util.debug |

118: | |
119: | SCOPE - PUBLIC |
120: | |
121: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
122: | arp_util.debug |
123: | |
124: | ARGUMENTS : IN: |
125: | OUT: |
126: | IN/ OUT: p_trx_rec |

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 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 193: | arp_util.debug |

189: | |
190: | SCOPE - PUBLIC |
191: | |
192: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
193: | arp_util.debug |
194: | |
195: | ARGUMENTS : IN: p_customer_trx_id |
196: | OUT: |
197: | IN/ OUT: |

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 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 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 266: | arp_util.debug |

262: | |
263: | SCOPE - PRIVATE |
264: | |
265: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
266: | arp_util.debug |
267: | |
268: | ARGUMENTS : IN: p_customer_trx_id |
269: | OUT: None |
270: | |

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 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 322: | arp_util.debug |

318: | SCOPE - PRIVATE |
319: | |
320: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
321: | dbms_sql.bind_variable |
322: | arp_util.debug |
323: | |
324: | ARGUMENTS : IN: p_customer_trx_id |
325: | OUT: None |
326: | |

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 374: | arp_util.debug |

370: | |
371: | SCOPE - PUBLIC |
372: | |
373: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
374: | arp_util.debug |
375: | |
376: | ARGUMENTS : IN: p_customer_trx_id |
377: | OUT: |
378: | IN/ OUT: |

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 444: | arp_util.debug |

440: | moved for a Bills Receivable transaction. |
441: | SCOPE - PUBLIC |
442: | |
443: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
444: | arp_util.debug |
445: | |
446: | ARGUMENTS : IN: p_customer_trx_id - ID of the BR to be checked |
447: | OUT: p_required - returns whether to move tax or not |
448: | IN/ OUT: |

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;