DBA Data[Home] [Help]

APPS.ARP_ROUNDING dependencies on ARP_UTIL

Line 66: | arp_util.debug |

62: | called from correct_rule_records_by_line and
63: | from within ARP_CREDIT_MEMO_MODULE |
64: | |
65: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
66: | arp_util.debug |
67: | |
68: | ARGUMENTS : IN: |
69: | p_customer_trx_id |
70: | p_request_id |

Line 126: arp_util.debug('arp_rounding.set_rec_offset_flag()+');

122: l_no_rof NUMBER;
123: l_count NUMBER;
124: BEGIN
125: IF PG_DEBUG in ('Y', 'C') THEN
126: arp_util.debug('arp_rounding.set_rec_offset_flag()+');
127: END IF;
128:
129: p_result := 0; -- no action needed
130:

Line 160: arp_util.debug(' l_no_rof = ' || l_no_rof);

156: AND g2.account_class in ('UNEARN','UNBILL')
157: AND g2.rec_offset_flag = 'Y');
158:
159: IF PG_DEBUG in ('Y', 'C') THEN
160: arp_util.debug(' l_no_rof = ' || l_no_rof);
161: END IF;
162:
163: IF l_no_rof > 0
164: THEN

Line 231: arp_util.debug(' updated ' || l_count ||

227:
228: l_count := SQL%ROWCOUNT;
229:
230: IF PG_DEBUG in ('Y', 'C') THEN
231: arp_util.debug(' updated ' || l_count ||
232: ' rec_offset rows.');
233: END IF;
234:
235: /* indicate if rows were set or not */

Line 296: arp_util.debug(' updated ' || l_count || ' rec_offset rows.');

292:
293: l_count := SQL%ROWCOUNT;
294:
295: IF PG_DEBUG in ('Y', 'C') THEN
296: arp_util.debug(' updated ' || l_count || ' rec_offset rows.');
297: END IF;
298: IF l_count > 0
299: THEN
300: /* we updated some. Technically, this does not mean

Line 314: arp_util.debug('arp_rounding.set_rec_offset_flag()-');

310: END IF;
311: END IF;
312:
313: IF PG_DEBUG in ('Y', 'C') THEN
314: arp_util.debug('arp_rounding.set_rec_offset_flag()-');
315: END IF;
316: EXCEPTION
317: WHEN OTHERS THEN
318: arp_util.debug('EXCEPTION: arp_process_dist.set_rec_offset_flag()');

Line 318: arp_util.debug('EXCEPTION: arp_process_dist.set_rec_offset_flag()');

314: arp_util.debug('arp_rounding.set_rec_offset_flag()-');
315: END IF;
316: EXCEPTION
317: WHEN OTHERS THEN
318: arp_util.debug('EXCEPTION: arp_process_dist.set_rec_offset_flag()');
319: RAISE;
320: END;
321:
322: /*===========================================================================+

Line 346: | arp_util.debug |

342: | SCOPE - PRIVATE |
343: | called from correct_rule_records_by_line
344: | |
345: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
346: | arp_util.debug |
347: | |
348: | ARGUMENTS : IN: |
349: | p_customer_trx_id |
350: | OUT: |

Line 424: arp_util.debug('arp_rounding.true_lines_by_gl_date()+');

420:
421: l_rows_needing_truing NUMBER;
422:
423: BEGIN
424: arp_util.debug('arp_rounding.true_lines_by_gl_date()+');
425:
426: IF (p_customer_trx_id IS NOT NULL)
427: THEN
428: /* True the rows (if required) */

Line 519: arp_util.debug('arp_rounding.true_lines_by_gl_date()-');

515: END IF;
516:
517: END IF;
518:
519: arp_util.debug('arp_rounding.true_lines_by_gl_date()-');
520: EXCEPTION
521: WHEN OTHERS THEN
522: arp_util.debug('EXCEPTION: arp_rounding.true_lines_by_gl_date()');
523: RAISE;

Line 522: arp_util.debug('EXCEPTION: arp_rounding.true_lines_by_gl_date()');

518:
519: arp_util.debug('arp_rounding.true_lines_by_gl_date()-');
520: EXCEPTION
521: WHEN OTHERS THEN
522: arp_util.debug('EXCEPTION: arp_rounding.true_lines_by_gl_date()');
523: RAISE;
524: END;
525:
526: /*===========================================================================+

Line 543: | arp_util.debug |

539: | SCOPE - PRIVATE |
540: | called from do_line_level_rounding
541: | |
542: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
543: | arp_util.debug |
544: | |
545: | ARGUMENTS : IN: |
546: | p_customer_trx_id |
547: | p_request_id |

Line 567: arp_util.debug('arp_rounding.correct_suspense()+');

563:
564: l_acctd_correction ra_cust_trx_line_gl_dist.acctd_amount%type;
565: l_rows NUMBER;
566: BEGIN
567: arp_util.debug('arp_rounding.correct_suspense()+');
568:
569: IF (p_customer_trx_id is not NULL)
570: THEN
571:

Line 595: arp_util.debug(' updated ' || l_rows

591: AND g2.account_set_flag = 'N'
592: AND g2.posting_control_id = -3));
593:
594: l_rows := SQL%ROWCOUNT;
595: arp_util.debug(' updated ' || l_rows
596: || ' suspense rows.');
597:
598: ELSE
599: arp_util.debug(' no suspense correction required');

Line 599: arp_util.debug(' no suspense correction required');

595: arp_util.debug(' updated ' || l_rows
596: || ' suspense rows.');
597:
598: ELSE
599: arp_util.debug(' no suspense correction required');
600: END IF;
601:
602: END IF;
603: /***********************************************

Line 622: arp_util.debug('arp_rounding.correct_suspense-');

618: NULL, /*p_check_rules_flag*/
619: NULL /*p_period_set_name */
620: );
621: IF PG_DEBUG in ('Y', 'C') THEN
622: arp_util.debug('arp_rounding.correct_suspense-');
623: END IF;
624: EXCEPTION
625: WHEN OTHERS THEN
626: arp_util.debug('EXCEPTION: arp_process_dist.correct_suspense()');

Line 626: arp_util.debug('EXCEPTION: arp_process_dist.correct_suspense()');

622: arp_util.debug('arp_rounding.correct_suspense-');
623: END IF;
624: EXCEPTION
625: WHEN OTHERS THEN
626: arp_util.debug('EXCEPTION: arp_process_dist.correct_suspense()');
627: END;
628:
629: /*-------------------------------------------------------------------------+
630: | PRIVATE FUNCTION |

Line 5469: arp_util.print_fcn_label( 'arp_rounding.correct_scredit_rounding_errs()+ ');

5465: +-------------------------------------------------------*/
5466:
5467: SAVEPOINT ARPLBCRE_2;
5468:
5469: arp_util.print_fcn_label( 'arp_rounding.correct_scredit_rounding_errs()+ ');
5470:
5471: /*-------------------------------------------------------------------------+
5472: | Correct errors in the revenue_amount_split and revenue_percent_split |
5473: | columns: |

Line 5543: arp_util.debug('Salescredit Revenue Errors Corrected : ' || l_count);

5539:
5540: l_count := sql%rowcount;
5541:
5542: IF PG_DEBUG in ('Y', 'C') THEN
5543: arp_util.debug('Salescredit Revenue Errors Corrected : ' || l_count);
5544: END IF;
5545:
5546: p_rows_processed := l_count;
5547:

Line 5548: arp_util.print_fcn_label( 'arp_rounding.correct_scredit_rounding_errs()- ');

5544: END IF;
5545:
5546: p_rows_processed := l_count;
5547:
5548: arp_util.print_fcn_label( 'arp_rounding.correct_scredit_rounding_errs()- ');
5549:
5550: EXCEPTION
5551: WHEN OTHERS THEN
5552:

Line 5556: arp_util.debug('EXCEPTION: arp_rounding.correct_scredit_rounding_errs()');

5552:
5553: ROLLBACK TO SAVEPOINT ARPLBCRE_2;
5554:
5555: IF PG_DEBUG in ('Y', 'C') THEN
5556: arp_util.debug('EXCEPTION: arp_rounding.correct_scredit_rounding_errs()');
5557: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id);
5558: END IF;
5559:
5560:

Line 5557: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id);

5553: ROLLBACK TO SAVEPOINT ARPLBCRE_2;
5554:
5555: IF PG_DEBUG in ('Y', 'C') THEN
5556: arp_util.debug('EXCEPTION: arp_rounding.correct_scredit_rounding_errs()');
5557: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id);
5558: END IF;
5559:
5560:
5561: RAISE;