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_CTL_PKG dependencies on ARP_UTIL

Line 105: | arp_util.debug |

101: | |
102: | SCOPE - PUBLIC |
103: | |
104: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
105: | arp_util.debug |
106: | |
107: | ARGUMENTS : IN: |
108: | p_mode |
109: | p_tax_amount |

Line 135: arp_util.debug( 'arp_ctl_pkg.calculate_prorated_tax_amount()+');

131: l_tax_amount ra_customer_trx_lines.extended_amount%type;
132:
133: BEGIN
134: IF PG_DEBUG in ('Y', 'C') THEN
135: arp_util.debug( 'arp_ctl_pkg.calculate_prorated_tax_amount()+');
136: END IF;
137:
138: IF p_mode = 'INSERT_NO_LINE' then
139:

Line 211: arp_util.debug( 'l_tax_recoverable = ' || l_tax_recoverable);

207: l_tax_amount := p_tax_amount;
208: END IF;
209:
210: IF PG_DEBUG in ('Y', 'C') THEN
211: arp_util.debug( 'l_tax_recoverable = ' || l_tax_recoverable);
212: arp_util.debug( 'l_total_tax_recoverable = ' || l_total_tax_recoverable);
213: arp_util.debug( 'l_tax_amount = ' || l_tax_amount);
214: END IF;
215:

Line 212: arp_util.debug( 'l_total_tax_recoverable = ' || l_total_tax_recoverable);

208: END IF;
209:
210: IF PG_DEBUG in ('Y', 'C') THEN
211: arp_util.debug( 'l_tax_recoverable = ' || l_tax_recoverable);
212: arp_util.debug( 'l_total_tax_recoverable = ' || l_total_tax_recoverable);
213: arp_util.debug( 'l_tax_amount = ' || l_tax_amount);
214: END IF;
215:
216: IF PG_DEBUG in ('Y', 'C') THEN

Line 213: arp_util.debug( 'l_tax_amount = ' || l_tax_amount);

209:
210: IF PG_DEBUG in ('Y', 'C') THEN
211: arp_util.debug( 'l_tax_recoverable = ' || l_tax_recoverable);
212: arp_util.debug( 'l_total_tax_recoverable = ' || l_total_tax_recoverable);
213: arp_util.debug( 'l_tax_amount = ' || l_tax_amount);
214: END IF;
215:
216: IF PG_DEBUG in ('Y', 'C') THEN
217: arp_util.debug( 'arp_ctl_pkg.calculate_prorated_tax_amount()-');

Line 217: arp_util.debug( 'arp_ctl_pkg.calculate_prorated_tax_amount()-');

213: arp_util.debug( 'l_tax_amount = ' || l_tax_amount);
214: END IF;
215:
216: IF PG_DEBUG in ('Y', 'C') THEN
217: arp_util.debug( 'arp_ctl_pkg.calculate_prorated_tax_amount()-');
218: END IF;
219:
220: RETURN l_tax_amount;
221: EXCEPTION

Line 226: arp_util.debug( 'EXCEPTION: arp_ctl_pkg.calculate_prorated_tax_amount');

222: WHEN NO_DATA_FOUND THEN
223: return null;
224: WHEN OTHERS THEN
225: IF PG_DEBUG in ('Y', 'C') THEN
226: arp_util.debug( 'EXCEPTION: arp_ctl_pkg.calculate_prorated_tax_amount');
227: arp_util.debug( '');
228: arp_util.debug( 'p_customer_trx_id = '||p_customer_trx_id);
229: arp_util.debug( 'p_customer_trx_line_id = '||p_customer_trx_line_id);
230: arp_util.debug( 'p_tax_amount = '||p_tax_amount);

Line 227: arp_util.debug( '');

223: return null;
224: WHEN OTHERS THEN
225: IF PG_DEBUG in ('Y', 'C') THEN
226: arp_util.debug( 'EXCEPTION: arp_ctl_pkg.calculate_prorated_tax_amount');
227: arp_util.debug( '');
228: arp_util.debug( 'p_customer_trx_id = '||p_customer_trx_id);
229: arp_util.debug( 'p_customer_trx_line_id = '||p_customer_trx_line_id);
230: arp_util.debug( 'p_tax_amount = '||p_tax_amount);
231: arp_util.debug( 'p_mode = '||p_mode);

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

224: WHEN OTHERS THEN
225: IF PG_DEBUG in ('Y', 'C') THEN
226: arp_util.debug( 'EXCEPTION: arp_ctl_pkg.calculate_prorated_tax_amount');
227: arp_util.debug( '');
228: arp_util.debug( 'p_customer_trx_id = '||p_customer_trx_id);
229: arp_util.debug( 'p_customer_trx_line_id = '||p_customer_trx_line_id);
230: arp_util.debug( 'p_tax_amount = '||p_tax_amount);
231: arp_util.debug( 'p_mode = '||p_mode);
232: END IF;

Line 229: arp_util.debug( 'p_customer_trx_line_id = '||p_customer_trx_line_id);

225: IF PG_DEBUG in ('Y', 'C') THEN
226: arp_util.debug( 'EXCEPTION: arp_ctl_pkg.calculate_prorated_tax_amount');
227: arp_util.debug( '');
228: arp_util.debug( 'p_customer_trx_id = '||p_customer_trx_id);
229: arp_util.debug( 'p_customer_trx_line_id = '||p_customer_trx_line_id);
230: arp_util.debug( 'p_tax_amount = '||p_tax_amount);
231: arp_util.debug( 'p_mode = '||p_mode);
232: END IF;
233: RAISE;

Line 230: arp_util.debug( 'p_tax_amount = '||p_tax_amount);

226: arp_util.debug( 'EXCEPTION: arp_ctl_pkg.calculate_prorated_tax_amount');
227: arp_util.debug( '');
228: arp_util.debug( 'p_customer_trx_id = '||p_customer_trx_id);
229: arp_util.debug( 'p_customer_trx_line_id = '||p_customer_trx_line_id);
230: arp_util.debug( 'p_tax_amount = '||p_tax_amount);
231: arp_util.debug( 'p_mode = '||p_mode);
232: END IF;
233: RAISE;
234:

Line 231: arp_util.debug( 'p_mode = '||p_mode);

227: arp_util.debug( '');
228: arp_util.debug( 'p_customer_trx_id = '||p_customer_trx_id);
229: arp_util.debug( 'p_customer_trx_line_id = '||p_customer_trx_line_id);
230: arp_util.debug( 'p_tax_amount = '||p_tax_amount);
231: arp_util.debug( 'p_mode = '||p_mode);
232: END IF;
233: RAISE;
234:
235: END calculate_prorated_tax_amount;

Line 249: | arp_util.debug |

245: | SCOPE - PRIVATE |
246: | |
247: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
248: | dbms_sql.bind_variable |
249: | arp_util.debug |
250: | |
251: | ARGUMENTS : IN: |
252: | p_update_cursor - ID of the update cursor |
253: | p_line_rec - ra_customer_trx_lines record |

Line 298: arp_util.debug('arp_ctl_pkg.bind_line_variables()+');

294: p_line_rec IN ra_customer_trx_lines%rowtype) IS
295:
296: BEGIN
297:
298: arp_util.debug('arp_ctl_pkg.bind_line_variables()+');
299:
300:
301: /*------------------+
302: | Dummy constants |

Line 725: arp_util.debug('arp_ctl_pkg.bind_line_variables()-');

721: /* 4713671 end */
722: dbms_sql.bind_variable(p_update_cursor, ':rule_end_date',
723: p_line_rec.rule_end_date);
724:
725: arp_util.debug('arp_ctl_pkg.bind_line_variables()-');
726:
727: EXCEPTION
728: WHEN OTHERS THEN
729: arp_util.debug('EXCEPTION: arp_ctl_pkg.bind_line_variables()');

Line 729: arp_util.debug('EXCEPTION: arp_ctl_pkg.bind_line_variables()');

725: arp_util.debug('arp_ctl_pkg.bind_line_variables()-');
726:
727: EXCEPTION
728: WHEN OTHERS THEN
729: arp_util.debug('EXCEPTION: arp_ctl_pkg.bind_line_variables()');
730:
731: arp_util.debug('');
732: arp_util.debug('-------- parameters for bind_line_variables() ------');
733:

Line 731: arp_util.debug('');

727: EXCEPTION
728: WHEN OTHERS THEN
729: arp_util.debug('EXCEPTION: arp_ctl_pkg.bind_line_variables()');
730:
731: arp_util.debug('');
732: arp_util.debug('-------- parameters for bind_line_variables() ------');
733:
734: arp_util.debug('p_update_cursor = ' || p_update_cursor);
735: arp_util.debug('');

Line 732: arp_util.debug('-------- parameters for bind_line_variables() ------');

728: WHEN OTHERS THEN
729: arp_util.debug('EXCEPTION: arp_ctl_pkg.bind_line_variables()');
730:
731: arp_util.debug('');
732: arp_util.debug('-------- parameters for bind_line_variables() ------');
733:
734: arp_util.debug('p_update_cursor = ' || p_update_cursor);
735: arp_util.debug('');
736: display_line_rec(p_line_rec);

Line 734: arp_util.debug('p_update_cursor = ' || p_update_cursor);

730:
731: arp_util.debug('');
732: arp_util.debug('-------- parameters for bind_line_variables() ------');
733:
734: arp_util.debug('p_update_cursor = ' || p_update_cursor);
735: arp_util.debug('');
736: display_line_rec(p_line_rec);
737:
738: RAISE;

Line 735: arp_util.debug('');

731: arp_util.debug('');
732: arp_util.debug('-------- parameters for bind_line_variables() ------');
733:
734: arp_util.debug('p_update_cursor = ' || p_update_cursor);
735: arp_util.debug('');
736: display_line_rec(p_line_rec);
737:
738: RAISE;
739:

Line 755: | arp_util.debug |

751: | |
752: | SCOPE - PRIVATE |
753: | |
754: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
755: | arp_util.debug |
756: | |
757: | ARGUMENTS : IN: |
758: | None. |
759: | OUT: |

Line 800: arp_util.debug('arp_ctl_pkg.construct_line_update_stmt()+');

796:
797: PROCEDURE construct_line_update_stmt( update_text OUT NOCOPY varchar2) IS
798:
799: BEGIN
800: arp_util.debug('arp_ctl_pkg.construct_line_update_stmt()+');
801:
802: update_text :=
803: 'UPDATE ra_customer_trx_lines
804: SET customer_trx_line_id =

Line 1352: arp_util.debug('arp_ctl_pkg.construct_line_update_stmt()-');

1348: :ar_date_dummy, rule_end_date,
1349: :rule_end_date) ';
1350:
1351:
1352: arp_util.debug('arp_ctl_pkg.construct_line_update_stmt()-');
1353:
1354: EXCEPTION
1355: WHEN OTHERS THEN
1356: arp_util.debug('EXCEPTION: arp_ctl_pkg.construct_line_update_stmt()');

Line 1356: arp_util.debug('EXCEPTION: arp_ctl_pkg.construct_line_update_stmt()');

1352: arp_util.debug('arp_ctl_pkg.construct_line_update_stmt()-');
1353:
1354: EXCEPTION
1355: WHEN OTHERS THEN
1356: arp_util.debug('EXCEPTION: arp_ctl_pkg.construct_line_update_stmt()');
1357: RAISE;
1358:
1359: END;
1360:

Line 1374: | arp_util.debug |

1370: | |
1371: | SCOPE - PRIVATE |
1372: | |
1373: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1374: | arp_util.debug |
1375: | dbms_sql.open_cursor |
1376: | dbms_sql.parse |
1377: | dbms_sql.execute |
1378: | dbms_sql.close_cursor |

Line 1416: arp_util.debug('arp_ctl_pkg.generic_update()+');

1412: ctl_array dbms_sql.number_table;
1413: --}
1414:
1415: BEGIN
1416: arp_util.debug('arp_ctl_pkg.generic_update()+');
1417:
1418: /*--------------------------------------------------------------+
1419: | If this update statement has not already been parsed, |
1420: | construct the statement and parse it. |

Line 1441: arp_util.debug('Update statement:');

1437: --{BUG#3339072 MRC trx line
1438: ' RETURNING :customer_trx_line_id INTO :ctl_value ';
1439: --}
1440:
1441: arp_util.debug('Update statement:');
1442: arp_util.debug('');
1443: arp_util.debug(l_update_statement);
1444: arp_util.debug('');
1445:

Line 1442: arp_util.debug('');

1438: ' RETURNING :customer_trx_line_id INTO :ctl_value ';
1439: --}
1440:
1441: arp_util.debug('Update statement:');
1442: arp_util.debug('');
1443: arp_util.debug(l_update_statement);
1444: arp_util.debug('');
1445:
1446: /*-----------------------------------------------+

Line 1443: arp_util.debug(l_update_statement);

1439: --}
1440:
1441: arp_util.debug('Update statement:');
1442: arp_util.debug('');
1443: arp_util.debug(l_update_statement);
1444: arp_util.debug('');
1445:
1446: /*-----------------------------------------------+
1447: | Parse, bind, execute and close the statement |

Line 1444: arp_util.debug('');

1440:
1441: arp_util.debug('Update statement:');
1442: arp_util.debug('');
1443: arp_util.debug(l_update_statement);
1444: arp_util.debug('');
1445:
1446: /*-----------------------------------------------+
1447: | Parse, bind, execute and close the statement |
1448: +-----------------------------------------------*/

Line 1478: arp_util.debug( to_char(l_count) || ' rows updated');

1474: --}
1475:
1476: l_count := dbms_sql.execute(p_update_cursor);
1477:
1478: arp_util.debug( to_char(l_count) || ' rows updated');
1479:
1480: --{BUG#3339072
1481: dbms_sql.variable_value(p_update_cursor, ':ctl_value',
1482: ctl_array);

Line 1493: arp_util.debug('arp_ctl_pkg.generic_update()-');

1489: IF (l_count = 0)
1490: THEN RAISE NO_DATA_FOUND;
1491: END IF;
1492:
1493: arp_util.debug('arp_ctl_pkg.generic_update()-');
1494:
1495: EXCEPTION
1496: WHEN OTHERS THEN
1497: arp_util.debug('EXCEPTION: arp_ctl_pkg.generic_update()');

Line 1497: arp_util.debug('EXCEPTION: arp_ctl_pkg.generic_update()');

1493: arp_util.debug('arp_ctl_pkg.generic_update()-');
1494:
1495: EXCEPTION
1496: WHEN OTHERS THEN
1497: arp_util.debug('EXCEPTION: arp_ctl_pkg.generic_update()');
1498: arp_util.debug(l_update_statement);
1499: arp_util.debug('Error at character: ' ||
1500: to_char(dbms_sql.last_error_position));
1501:

Line 1498: arp_util.debug(l_update_statement);

1494:
1495: EXCEPTION
1496: WHEN OTHERS THEN
1497: arp_util.debug('EXCEPTION: arp_ctl_pkg.generic_update()');
1498: arp_util.debug(l_update_statement);
1499: arp_util.debug('Error at character: ' ||
1500: to_char(dbms_sql.last_error_position));
1501:
1502: arp_util.debug('');

Line 1499: arp_util.debug('Error at character: ' ||

1495: EXCEPTION
1496: WHEN OTHERS THEN
1497: arp_util.debug('EXCEPTION: arp_ctl_pkg.generic_update()');
1498: arp_util.debug(l_update_statement);
1499: arp_util.debug('Error at character: ' ||
1500: to_char(dbms_sql.last_error_position));
1501:
1502: arp_util.debug('');
1503: arp_util.debug('-------- parameters for generic_update() ------');

Line 1502: arp_util.debug('');

1498: arp_util.debug(l_update_statement);
1499: arp_util.debug('Error at character: ' ||
1500: to_char(dbms_sql.last_error_position));
1501:
1502: arp_util.debug('');
1503: arp_util.debug('-------- parameters for generic_update() ------');
1504: arp_util.debug('p_update_cursor = ' || p_update_cursor);
1505: arp_util.debug('p_where_clause = ' || p_where_clause);
1506: arp_util.debug('p_where1 = ' || p_where1);

Line 1503: arp_util.debug('-------- parameters for generic_update() ------');

1499: arp_util.debug('Error at character: ' ||
1500: to_char(dbms_sql.last_error_position));
1501:
1502: arp_util.debug('');
1503: arp_util.debug('-------- parameters for generic_update() ------');
1504: arp_util.debug('p_update_cursor = ' || p_update_cursor);
1505: arp_util.debug('p_where_clause = ' || p_where_clause);
1506: arp_util.debug('p_where1 = ' || p_where1);
1507: arp_util.debug('p_line_type = ' || p_line_type);

Line 1504: arp_util.debug('p_update_cursor = ' || p_update_cursor);

1500: to_char(dbms_sql.last_error_position));
1501:
1502: arp_util.debug('');
1503: arp_util.debug('-------- parameters for generic_update() ------');
1504: arp_util.debug('p_update_cursor = ' || p_update_cursor);
1505: arp_util.debug('p_where_clause = ' || p_where_clause);
1506: arp_util.debug('p_where1 = ' || p_where1);
1507: arp_util.debug('p_line_type = ' || p_line_type);
1508: arp_util.debug('p_currency_code = ' || p_currency_code);

Line 1505: arp_util.debug('p_where_clause = ' || p_where_clause);

1501:
1502: arp_util.debug('');
1503: arp_util.debug('-------- parameters for generic_update() ------');
1504: arp_util.debug('p_update_cursor = ' || p_update_cursor);
1505: arp_util.debug('p_where_clause = ' || p_where_clause);
1506: arp_util.debug('p_where1 = ' || p_where1);
1507: arp_util.debug('p_line_type = ' || p_line_type);
1508: arp_util.debug('p_currency_code = ' || p_currency_code);
1509: display_line_rec(p_line_rec);

Line 1506: arp_util.debug('p_where1 = ' || p_where1);

1502: arp_util.debug('');
1503: arp_util.debug('-------- parameters for generic_update() ------');
1504: arp_util.debug('p_update_cursor = ' || p_update_cursor);
1505: arp_util.debug('p_where_clause = ' || p_where_clause);
1506: arp_util.debug('p_where1 = ' || p_where1);
1507: arp_util.debug('p_line_type = ' || p_line_type);
1508: arp_util.debug('p_currency_code = ' || p_currency_code);
1509: display_line_rec(p_line_rec);
1510:

Line 1507: arp_util.debug('p_line_type = ' || p_line_type);

1503: arp_util.debug('-------- parameters for generic_update() ------');
1504: arp_util.debug('p_update_cursor = ' || p_update_cursor);
1505: arp_util.debug('p_where_clause = ' || p_where_clause);
1506: arp_util.debug('p_where1 = ' || p_where1);
1507: arp_util.debug('p_line_type = ' || p_line_type);
1508: arp_util.debug('p_currency_code = ' || p_currency_code);
1509: display_line_rec(p_line_rec);
1510:
1511: RAISE;

Line 1508: arp_util.debug('p_currency_code = ' || p_currency_code);

1504: arp_util.debug('p_update_cursor = ' || p_update_cursor);
1505: arp_util.debug('p_where_clause = ' || p_where_clause);
1506: arp_util.debug('p_where1 = ' || p_where1);
1507: arp_util.debug('p_line_type = ' || p_line_type);
1508: arp_util.debug('p_currency_code = ' || p_currency_code);
1509: display_line_rec(p_line_rec);
1510:
1511: RAISE;
1512: END;

Line 1532: | arp_util.debug |

1528: | |
1529: | SCOPE - PUBLIC |
1530: | |
1531: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1532: | arp_util.debug |
1533: | |
1534: | ARGUMENTS : IN: |
1535: | None |
1536: | OUT: |

Line 1578: arp_util.debug('arp_ctl_pkg.set_to_dummy()+');

1574:
1575: BEGIN
1576:
1577: IF PG_DEBUG in ('Y', 'C') THEN
1578: arp_util.debug('arp_ctl_pkg.set_to_dummy()+');
1579: END IF;
1580:
1581: p_line_rec.customer_trx_line_id := AR_NUMBER_DUMMY;
1582: p_line_rec.customer_trx_id := AR_NUMBER_DUMMY;

Line 1720: arp_util.debug('arp_ctl_pkg.set_to_dummy()-');

1716: p_line_rec.tax_classification_code := AR_TEXT_DUMMY;
1717:
1718: p_line_rec.rule_end_date := AR_DATE_DUMMY;
1719: IF PG_DEBUG in ('Y', 'C') THEN
1720: arp_util.debug('arp_ctl_pkg.set_to_dummy()-');
1721: END IF;
1722:
1723: EXCEPTION
1724: WHEN OTHERS THEN

Line 1726: arp_util.debug('EXCEPTION: arp_ctl_pkg.set_to_dummy()');

1722:
1723: EXCEPTION
1724: WHEN OTHERS THEN
1725: IF PG_DEBUG in ('Y', 'C') THEN
1726: arp_util.debug('EXCEPTION: arp_ctl_pkg.set_to_dummy()');
1727: END IF;
1728: RAISE;
1729:
1730: END;

Line 1744: | arp_util.debug |

1740: | |
1741: | SCOPE - PUBLIC |
1742: | |
1743: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1744: | arp_util.debug |
1745: | |
1746: | ARGUMENTS : IN: |
1747: | p_customer_trx_line_id - identifies the record to fetch|
1748: | OUT: |

Line 1767: arp_util.debug( 'arp_ctl_pkg.fetch_p()+');

1763: IS
1764:
1765: BEGIN
1766: IF PG_DEBUG in ('Y', 'C') THEN
1767: arp_util.debug( 'arp_ctl_pkg.fetch_p()+');
1768: END IF;
1769:
1770: SELECT *
1771: INTO p_line_rec

Line 1776: arp_util.debug( 'arp_ctl_pkg.fetch_p()-');

1772: FROM ra_customer_trx_lines
1773: WHERE customer_trx_line_id = p_customer_trx_line_id;
1774:
1775: IF PG_DEBUG in ('Y', 'C') THEN
1776: arp_util.debug( 'arp_ctl_pkg.fetch_p()-');
1777: END IF;
1778:
1779: EXCEPTION
1780: WHEN OTHERS THEN

Line 1782: arp_util.debug( 'EXCEPTION: arp_ctl_pkg.fetch_p' );

1778:
1779: EXCEPTION
1780: WHEN OTHERS THEN
1781: IF PG_DEBUG in ('Y', 'C') THEN
1782: arp_util.debug( 'EXCEPTION: arp_ctl_pkg.fetch_p' );
1783: arp_util.debug( '');
1784: arp_util.debug( '-------- parameters for fetch_p() ------');
1785: arp_util.debug( 'p_customer_trx_line_id = ' || p_customer_trx_line_id);
1786: END IF;

Line 1783: arp_util.debug( '');

1779: EXCEPTION
1780: WHEN OTHERS THEN
1781: IF PG_DEBUG in ('Y', 'C') THEN
1782: arp_util.debug( 'EXCEPTION: arp_ctl_pkg.fetch_p' );
1783: arp_util.debug( '');
1784: arp_util.debug( '-------- parameters for fetch_p() ------');
1785: arp_util.debug( 'p_customer_trx_line_id = ' || p_customer_trx_line_id);
1786: END IF;
1787:

Line 1784: arp_util.debug( '-------- parameters for fetch_p() ------');

1780: WHEN OTHERS THEN
1781: IF PG_DEBUG in ('Y', 'C') THEN
1782: arp_util.debug( 'EXCEPTION: arp_ctl_pkg.fetch_p' );
1783: arp_util.debug( '');
1784: arp_util.debug( '-------- parameters for fetch_p() ------');
1785: arp_util.debug( 'p_customer_trx_line_id = ' || p_customer_trx_line_id);
1786: END IF;
1787:
1788: RAISE;

Line 1785: arp_util.debug( 'p_customer_trx_line_id = ' || p_customer_trx_line_id);

1781: IF PG_DEBUG in ('Y', 'C') THEN
1782: arp_util.debug( 'EXCEPTION: arp_ctl_pkg.fetch_p' );
1783: arp_util.debug( '');
1784: arp_util.debug( '-------- parameters for fetch_p() ------');
1785: arp_util.debug( 'p_customer_trx_line_id = ' || p_customer_trx_line_id);
1786: END IF;
1787:
1788: RAISE;
1789: END;

Line 1802: | arp_util.debug |

1798: | |
1799: | SCOPE - PUBLIC |
1800: | |
1801: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1802: | arp_util.debug |
1803: | |
1804: | ARGUMENTS : IN: |
1805: | p_customer_trx_line_id - identifies the row to lock |
1806: | OUT: |

Line 1826: arp_util.debug( 'arp_ctl_pkg.lock_p()+');

1822: l_customer_trx_line_id ra_customer_trx_lines.customer_trx_line_id%type;
1823:
1824: BEGIN
1825: IF PG_DEBUG in ('Y', 'C') THEN
1826: arp_util.debug( 'arp_ctl_pkg.lock_p()+');
1827: END IF;
1828:
1829:
1830: SELECT customer_trx_line_id

Line 1837: arp_util.debug( 'arp_ctl_pkg.lock_p()-');

1833: WHERE customer_trx_line_id = p_customer_trx_line_id
1834: FOR UPDATE OF customer_trx_line_id NOWAIT;
1835:
1836: IF PG_DEBUG in ('Y', 'C') THEN
1837: arp_util.debug( 'arp_ctl_pkg.lock_p()-');
1838: END IF;
1839:
1840: EXCEPTION
1841: WHEN OTHERS THEN

Line 1843: arp_util.debug( 'EXCEPTION: arp_ctl_pkg.lock_p' );

1839:
1840: EXCEPTION
1841: WHEN OTHERS THEN
1842: IF PG_DEBUG in ('Y', 'C') THEN
1843: arp_util.debug( 'EXCEPTION: arp_ctl_pkg.lock_p' );
1844: arp_util.debug( '');
1845: arp_util.debug( '-------- parameters for lock_p() ------');
1846: arp_util.debug( 'p_customer_trx_line_id = ' ||
1847: p_customer_trx_line_id);

Line 1844: arp_util.debug( '');

1840: EXCEPTION
1841: WHEN OTHERS THEN
1842: IF PG_DEBUG in ('Y', 'C') THEN
1843: arp_util.debug( 'EXCEPTION: arp_ctl_pkg.lock_p' );
1844: arp_util.debug( '');
1845: arp_util.debug( '-------- parameters for lock_p() ------');
1846: arp_util.debug( 'p_customer_trx_line_id = ' ||
1847: p_customer_trx_line_id);
1848: END IF;

Line 1845: arp_util.debug( '-------- parameters for lock_p() ------');

1841: WHEN OTHERS THEN
1842: IF PG_DEBUG in ('Y', 'C') THEN
1843: arp_util.debug( 'EXCEPTION: arp_ctl_pkg.lock_p' );
1844: arp_util.debug( '');
1845: arp_util.debug( '-------- parameters for lock_p() ------');
1846: arp_util.debug( 'p_customer_trx_line_id = ' ||
1847: p_customer_trx_line_id);
1848: END IF;
1849:

Line 1846: arp_util.debug( 'p_customer_trx_line_id = ' ||

1842: IF PG_DEBUG in ('Y', 'C') THEN
1843: arp_util.debug( 'EXCEPTION: arp_ctl_pkg.lock_p' );
1844: arp_util.debug( '');
1845: arp_util.debug( '-------- parameters for lock_p() ------');
1846: arp_util.debug( 'p_customer_trx_line_id = ' ||
1847: p_customer_trx_line_id);
1848: END IF;
1849:
1850: RAISE;

Line 1864: | arp_util.debug |

1860: | |
1861: | SCOPE - PUBLIC |
1862: | |
1863: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1864: | arp_util.debug |
1865: | |
1866: | ARGUMENTS : IN: |
1867: | p_customer_trx_id - identifies the rows to lock |
1868: | OUT: |

Line 1892: arp_util.debug( 'arp_ctl_pkg.lock_f_ct_id()+');

1888: FOR UPDATE OF customer_trx_line_id NOWAIT;
1889:
1890: BEGIN
1891: IF PG_DEBUG in ('Y', 'C') THEN
1892: arp_util.debug( 'arp_ctl_pkg.lock_f_ct_id()+');
1893: END IF;
1894:
1895: OPEN lock_c;
1896: CLOSE lock_c;

Line 1899: arp_util.debug( 'arp_ctl_pkg.lock_f_ct_id()-');

1895: OPEN lock_c;
1896: CLOSE lock_c;
1897:
1898: IF PG_DEBUG in ('Y', 'C') THEN
1899: arp_util.debug( 'arp_ctl_pkg.lock_f_ct_id()-');
1900: END IF;
1901:
1902: EXCEPTION
1903: WHEN OTHERS THEN

Line 1905: arp_util.debug( 'EXCEPTION: arp_ctl_pkg.lock_f_ct_id' );

1901:
1902: EXCEPTION
1903: WHEN OTHERS THEN
1904: IF PG_DEBUG in ('Y', 'C') THEN
1905: arp_util.debug( 'EXCEPTION: arp_ctl_pkg.lock_f_ct_id' );
1906: arp_util.debug( '');
1907: arp_util.debug( '-------- parameters for lock_f_ct_id() ------');
1908: arp_util.debug( 'p_customer_trx_id = ' ||
1909: p_customer_trx_id);

Line 1906: arp_util.debug( '');

1902: EXCEPTION
1903: WHEN OTHERS THEN
1904: IF PG_DEBUG in ('Y', 'C') THEN
1905: arp_util.debug( 'EXCEPTION: arp_ctl_pkg.lock_f_ct_id' );
1906: arp_util.debug( '');
1907: arp_util.debug( '-------- parameters for lock_f_ct_id() ------');
1908: arp_util.debug( 'p_customer_trx_id = ' ||
1909: p_customer_trx_id);
1910: END IF;

Line 1907: arp_util.debug( '-------- parameters for lock_f_ct_id() ------');

1903: WHEN OTHERS THEN
1904: IF PG_DEBUG in ('Y', 'C') THEN
1905: arp_util.debug( 'EXCEPTION: arp_ctl_pkg.lock_f_ct_id' );
1906: arp_util.debug( '');
1907: arp_util.debug( '-------- parameters for lock_f_ct_id() ------');
1908: arp_util.debug( 'p_customer_trx_id = ' ||
1909: p_customer_trx_id);
1910: END IF;
1911:

Line 1908: arp_util.debug( 'p_customer_trx_id = ' ||

1904: IF PG_DEBUG in ('Y', 'C') THEN
1905: arp_util.debug( 'EXCEPTION: arp_ctl_pkg.lock_f_ct_id' );
1906: arp_util.debug( '');
1907: arp_util.debug( '-------- parameters for lock_f_ct_id() ------');
1908: arp_util.debug( 'p_customer_trx_id = ' ||
1909: p_customer_trx_id);
1910: END IF;
1911:
1912: RAISE;

Line 1928: | arp_util.debug |

1924: | |
1925: | SCOPE - PUBLIC |
1926: | |
1927: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1928: | arp_util.debug |
1929: | |
1930: | ARGUMENTS : IN: |
1931: | p_customer_trx_line_id - identifies the row to lock |
1932: | OUT: |

Line 1950: arp_util.debug( 'arp_ctl_pkg.lock_fetch_p()+');

1946: ra_customer_trx_lines.customer_trx_line_id%type ) IS
1947:
1948: BEGIN
1949: IF PG_DEBUG in ('Y', 'C') THEN
1950: arp_util.debug( 'arp_ctl_pkg.lock_fetch_p()+');
1951: END IF;
1952:
1953: SELECT *
1954: INTO p_line_rec

Line 1960: arp_util.debug( 'arp_ctl_pkg.lock_fetch_p()-');

1956: WHERE customer_trx_line_id = p_customer_trx_line_id
1957: FOR UPDATE OF customer_trx_line_id NOWAIT;
1958:
1959: IF PG_DEBUG in ('Y', 'C') THEN
1960: arp_util.debug( 'arp_ctl_pkg.lock_fetch_p()-');
1961: END IF;
1962:
1963: EXCEPTION
1964: WHEN OTHERS THEN

Line 1966: arp_util.debug( 'EXCEPTION: arp_ctl_pkg.lock_fetch_p' );

1962:
1963: EXCEPTION
1964: WHEN OTHERS THEN
1965: IF PG_DEBUG in ('Y', 'C') THEN
1966: arp_util.debug( 'EXCEPTION: arp_ctl_pkg.lock_fetch_p' );
1967: arp_util.debug( '');
1968: arp_util.debug( '-------- parameters for lock_fetch_p() ------');
1969: arp_util.debug( 'p_customer_trx_line_id = ' ||
1970: p_customer_trx_line_id);

Line 1967: arp_util.debug( '');

1963: EXCEPTION
1964: WHEN OTHERS THEN
1965: IF PG_DEBUG in ('Y', 'C') THEN
1966: arp_util.debug( 'EXCEPTION: arp_ctl_pkg.lock_fetch_p' );
1967: arp_util.debug( '');
1968: arp_util.debug( '-------- parameters for lock_fetch_p() ------');
1969: arp_util.debug( 'p_customer_trx_line_id = ' ||
1970: p_customer_trx_line_id);
1971: END IF;

Line 1968: arp_util.debug( '-------- parameters for lock_fetch_p() ------');

1964: WHEN OTHERS THEN
1965: IF PG_DEBUG in ('Y', 'C') THEN
1966: arp_util.debug( 'EXCEPTION: arp_ctl_pkg.lock_fetch_p' );
1967: arp_util.debug( '');
1968: arp_util.debug( '-------- parameters for lock_fetch_p() ------');
1969: arp_util.debug( 'p_customer_trx_line_id = ' ||
1970: p_customer_trx_line_id);
1971: END IF;
1972: display_line_rec(p_line_rec);

Line 1969: arp_util.debug( 'p_customer_trx_line_id = ' ||

1965: IF PG_DEBUG in ('Y', 'C') THEN
1966: arp_util.debug( 'EXCEPTION: arp_ctl_pkg.lock_fetch_p' );
1967: arp_util.debug( '');
1968: arp_util.debug( '-------- parameters for lock_fetch_p() ------');
1969: arp_util.debug( 'p_customer_trx_line_id = ' ||
1970: p_customer_trx_line_id);
1971: END IF;
1972: display_line_rec(p_line_rec);
1973:

Line 1989: | arp_util.debug |

1985: | |
1986: | SCOPE - PUBLIC |
1987: | |
1988: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1989: | arp_util.debug |
1990: | |
1991: | ARGUMENTS : IN: |
1992: | p_customer_trx_line_id - identifies the row to lock |
1993: | p_line_rec - line record for comparison |

Line 2043: arp_util.debug( 'arp_ctl_pkg.lock_compare_p()+');

2039: l_ignore_who_flag varchar2(2);
2040:
2041: BEGIN
2042: IF PG_DEBUG in ('Y', 'C') THEN
2043: arp_util.debug( 'arp_ctl_pkg.lock_compare_p()+');
2044: END IF;
2045:
2046: IF (p_ignore_who_flag = TRUE)
2047: THEN l_ignore_who_flag := 'Y';

Line 3120: arp_util.debug( 'arp_ctl_pkg.lock_compare_p()-');

3116: FOR UPDATE OF customer_trx_line_id NOWAIT;
3117:
3118:
3119: IF PG_DEBUG in ('Y', 'C') THEN
3120: arp_util.debug( 'arp_ctl_pkg.lock_compare_p()-');
3121: END IF;
3122:
3123: EXCEPTION
3124: WHEN NO_DATA_FOUND THEN

Line 3126: arp_util.debug( '');

3122:
3123: EXCEPTION
3124: WHEN NO_DATA_FOUND THEN
3125: IF PG_DEBUG in ('Y', 'C') THEN
3126: arp_util.debug( '');
3127: arp_util.debug( 'p_customer_trx_line_id = ' ||
3128: p_customer_trx_line_id );
3129: arp_util.debug( '-------- new line record --------');
3130: END IF;

Line 3127: arp_util.debug( 'p_customer_trx_line_id = ' ||

3123: EXCEPTION
3124: WHEN NO_DATA_FOUND THEN
3125: IF PG_DEBUG in ('Y', 'C') THEN
3126: arp_util.debug( '');
3127: arp_util.debug( 'p_customer_trx_line_id = ' ||
3128: p_customer_trx_line_id );
3129: arp_util.debug( '-------- new line record --------');
3130: END IF;
3131: display_line_rec( p_line_rec );

Line 3129: arp_util.debug( '-------- new line record --------');

3125: IF PG_DEBUG in ('Y', 'C') THEN
3126: arp_util.debug( '');
3127: arp_util.debug( 'p_customer_trx_line_id = ' ||
3128: p_customer_trx_line_id );
3129: arp_util.debug( '-------- new line record --------');
3130: END IF;
3131: display_line_rec( p_line_rec );
3132:
3133: IF PG_DEBUG in ('Y', 'C') THEN

Line 3134: arp_util.debug( '');

3130: END IF;
3131: display_line_rec( p_line_rec );
3132:
3133: IF PG_DEBUG in ('Y', 'C') THEN
3134: arp_util.debug( '');
3135: arp_util.debug( '-------- old line record --------');
3136: END IF;
3137:
3138: fetch_p( l_temp_line_rec,

Line 3135: arp_util.debug( '-------- old line record --------');

3131: display_line_rec( p_line_rec );
3132:
3133: IF PG_DEBUG in ('Y', 'C') THEN
3134: arp_util.debug( '');
3135: arp_util.debug( '-------- old line record --------');
3136: END IF;
3137:
3138: fetch_p( l_temp_line_rec,
3139: p_customer_trx_line_id );

Line 3148: arp_util.debug( 'EXCEPTION: arp_ctl_pkg.lock_compare_p' );

3144: APP_EXCEPTION.Raise_Exception;
3145:
3146: WHEN OTHERS THEN
3147: IF PG_DEBUG in ('Y', 'C') THEN
3148: arp_util.debug( 'EXCEPTION: arp_ctl_pkg.lock_compare_p' );
3149: arp_util.debug( '');
3150: arp_util.debug( '-------- parameters for lock_compare_p() ------');
3151: arp_util.debug( 'p_customer_trx_line_id = ' ||
3152: p_customer_trx_line_id);

Line 3149: arp_util.debug( '');

3145:
3146: WHEN OTHERS THEN
3147: IF PG_DEBUG in ('Y', 'C') THEN
3148: arp_util.debug( 'EXCEPTION: arp_ctl_pkg.lock_compare_p' );
3149: arp_util.debug( '');
3150: arp_util.debug( '-------- parameters for lock_compare_p() ------');
3151: arp_util.debug( 'p_customer_trx_line_id = ' ||
3152: p_customer_trx_line_id);
3153: arp_util.debug( 'p_ignore_who_flag = ' ||

Line 3150: arp_util.debug( '-------- parameters for lock_compare_p() ------');

3146: WHEN OTHERS THEN
3147: IF PG_DEBUG in ('Y', 'C') THEN
3148: arp_util.debug( 'EXCEPTION: arp_ctl_pkg.lock_compare_p' );
3149: arp_util.debug( '');
3150: arp_util.debug( '-------- parameters for lock_compare_p() ------');
3151: arp_util.debug( 'p_customer_trx_line_id = ' ||
3152: p_customer_trx_line_id);
3153: arp_util.debug( 'p_ignore_who_flag = ' ||
3154: arp_trx_util.boolean_to_varchar2(p_ignore_who_flag));

Line 3151: arp_util.debug( 'p_customer_trx_line_id = ' ||

3147: IF PG_DEBUG in ('Y', 'C') THEN
3148: arp_util.debug( 'EXCEPTION: arp_ctl_pkg.lock_compare_p' );
3149: arp_util.debug( '');
3150: arp_util.debug( '-------- parameters for lock_compare_p() ------');
3151: arp_util.debug( 'p_customer_trx_line_id = ' ||
3152: p_customer_trx_line_id);
3153: arp_util.debug( 'p_ignore_who_flag = ' ||
3154: arp_trx_util.boolean_to_varchar2(p_ignore_who_flag));
3155: END IF;

Line 3153: arp_util.debug( 'p_ignore_who_flag = ' ||

3149: arp_util.debug( '');
3150: arp_util.debug( '-------- parameters for lock_compare_p() ------');
3151: arp_util.debug( 'p_customer_trx_line_id = ' ||
3152: p_customer_trx_line_id);
3153: arp_util.debug( 'p_ignore_who_flag = ' ||
3154: arp_trx_util.boolean_to_varchar2(p_ignore_who_flag));
3155: END IF;
3156: display_line_rec(p_line_rec);
3157:

Line 3173: | arp_util.debug |

3169: | |
3170: | SCOPE - PUBLIC |
3171: | |
3172: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
3173: | arp_util.debug |
3174: | |
3175: | ARGUMENTS : IN: |
3176: | p_customer_trx_line_id - identifies the row to delete |
3177: | OUT: |

Line 3197: arp_util.debug( 'arp_ctl_pkg.delete_p()+');

3193:
3194: BEGIN
3195:
3196: IF PG_DEBUG in ('Y', 'C') THEN
3197: arp_util.debug( 'arp_ctl_pkg.delete_p()+');
3198: arp_util.debug( 'deleting ctlid: ' || p_customer_trx_line_id);
3199: END IF;
3200:
3201: DELETE FROM ra_customer_trx_lines

Line 3198: arp_util.debug( 'deleting ctlid: ' || p_customer_trx_line_id);

3194: BEGIN
3195:
3196: IF PG_DEBUG in ('Y', 'C') THEN
3197: arp_util.debug( 'arp_ctl_pkg.delete_p()+');
3198: arp_util.debug( 'deleting ctlid: ' || p_customer_trx_line_id);
3199: END IF;
3200:
3201: DELETE FROM ra_customer_trx_lines
3202: WHERE customer_trx_line_id = p_customer_trx_line_id;

Line 3205: THEN arp_util.debug('EXCEPTION: arp_ctl_pkg.delete_p()');

3201: DELETE FROM ra_customer_trx_lines
3202: WHERE customer_trx_line_id = p_customer_trx_line_id;
3203:
3204: IF ( SQL%ROWCOUNT = 0 )
3205: THEN arp_util.debug('EXCEPTION: arp_ctl_pkg.delete_p()');
3206: RAISE NO_DATA_FOUND;
3207: END IF;
3208:
3209: IF PG_DEBUG in ('Y', 'C') THEN

Line 3210: arp_util.debug( 'arp_ctl_pkg.delete_p()-');

3206: RAISE NO_DATA_FOUND;
3207: END IF;
3208:
3209: IF PG_DEBUG in ('Y', 'C') THEN
3210: arp_util.debug( 'arp_ctl_pkg.delete_p()-');
3211: END IF;
3212:
3213: EXCEPTION
3214: WHEN OTHERS THEN

Line 3216: arp_util.debug( 'EXCEPTION: arp_ctl_pkg.delete_p()');

3212:
3213: EXCEPTION
3214: WHEN OTHERS THEN
3215: IF PG_DEBUG in ('Y', 'C') THEN
3216: arp_util.debug( 'EXCEPTION: arp_ctl_pkg.delete_p()');
3217: arp_util.debug( '');
3218: arp_util.debug( '-------- parameters for delete_p() ------');
3219: arp_util.debug( 'p_customer_trx_line_id = ' ||
3220: p_customer_trx_line_id);

Line 3217: arp_util.debug( '');

3213: EXCEPTION
3214: WHEN OTHERS THEN
3215: IF PG_DEBUG in ('Y', 'C') THEN
3216: arp_util.debug( 'EXCEPTION: arp_ctl_pkg.delete_p()');
3217: arp_util.debug( '');
3218: arp_util.debug( '-------- parameters for delete_p() ------');
3219: arp_util.debug( 'p_customer_trx_line_id = ' ||
3220: p_customer_trx_line_id);
3221: END IF;

Line 3218: arp_util.debug( '-------- parameters for delete_p() ------');

3214: WHEN OTHERS THEN
3215: IF PG_DEBUG in ('Y', 'C') THEN
3216: arp_util.debug( 'EXCEPTION: arp_ctl_pkg.delete_p()');
3217: arp_util.debug( '');
3218: arp_util.debug( '-------- parameters for delete_p() ------');
3219: arp_util.debug( 'p_customer_trx_line_id = ' ||
3220: p_customer_trx_line_id);
3221: END IF;
3222:

Line 3219: arp_util.debug( 'p_customer_trx_line_id = ' ||

3215: IF PG_DEBUG in ('Y', 'C') THEN
3216: arp_util.debug( 'EXCEPTION: arp_ctl_pkg.delete_p()');
3217: arp_util.debug( '');
3218: arp_util.debug( '-------- parameters for delete_p() ------');
3219: arp_util.debug( 'p_customer_trx_line_id = ' ||
3220: p_customer_trx_line_id);
3221: END IF;
3222:
3223: RAISE;

Line 3238: | arp_util.debug |

3234: | |
3235: | SCOPE - PUBLIC |
3236: | |
3237: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
3238: | arp_util.debug |
3239: | |
3240: | ARGUMENTS : IN: |
3241: | p_customer_trx_id - identifies the rows to delete |
3242: | OUT: |

Line 3266: arp_util.debug( 'arp_ctl_pkg.delete_f_ct_id()+');

3262: BEGIN
3263:
3264:
3265: IF PG_DEBUG in ('Y', 'C') THEN
3266: arp_util.debug( 'arp_ctl_pkg.delete_f_ct_id()+');
3267: END IF;
3268:
3269: DELETE FROM ra_customer_trx_lines
3270: WHERE customer_trx_id = p_customer_trx_id

Line 3277: arp_util.debug( 'arp_ctl_pkg.delete_f_ct_id()-');

3273: BULK COLLECT INTO l_ctl_key_list;
3274: --}
3275:
3276: IF PG_DEBUG in ('Y', 'C') THEN
3277: arp_util.debug( 'arp_ctl_pkg.delete_f_ct_id()-');
3278: END IF;
3279:
3280: EXCEPTION
3281: WHEN OTHERS THEN

Line 3283: arp_util.debug( 'EXCEPTION: arp_ctl_pkg.delete_f_ct_id()');

3279:
3280: EXCEPTION
3281: WHEN OTHERS THEN
3282: IF PG_DEBUG in ('Y', 'C') THEN
3283: arp_util.debug( 'EXCEPTION: arp_ctl_pkg.delete_f_ct_id()');
3284: arp_util.debug( '');
3285: arp_util.debug( '-------- parameters for delete_f_ct_id() ------');
3286: arp_util.debug( 'p_customer_trx_id = ' ||
3287: p_customer_trx_id);

Line 3284: arp_util.debug( '');

3280: EXCEPTION
3281: WHEN OTHERS THEN
3282: IF PG_DEBUG in ('Y', 'C') THEN
3283: arp_util.debug( 'EXCEPTION: arp_ctl_pkg.delete_f_ct_id()');
3284: arp_util.debug( '');
3285: arp_util.debug( '-------- parameters for delete_f_ct_id() ------');
3286: arp_util.debug( 'p_customer_trx_id = ' ||
3287: p_customer_trx_id);
3288: END IF;

Line 3285: arp_util.debug( '-------- parameters for delete_f_ct_id() ------');

3281: WHEN OTHERS THEN
3282: IF PG_DEBUG in ('Y', 'C') THEN
3283: arp_util.debug( 'EXCEPTION: arp_ctl_pkg.delete_f_ct_id()');
3284: arp_util.debug( '');
3285: arp_util.debug( '-------- parameters for delete_f_ct_id() ------');
3286: arp_util.debug( 'p_customer_trx_id = ' ||
3287: p_customer_trx_id);
3288: END IF;
3289:

Line 3286: arp_util.debug( 'p_customer_trx_id = ' ||

3282: IF PG_DEBUG in ('Y', 'C') THEN
3283: arp_util.debug( 'EXCEPTION: arp_ctl_pkg.delete_f_ct_id()');
3284: arp_util.debug( '');
3285: arp_util.debug( '-------- parameters for delete_f_ct_id() ------');
3286: arp_util.debug( 'p_customer_trx_id = ' ||
3287: p_customer_trx_id);
3288: END IF;
3289:
3290: RAISE;

Line 3306: | arp_util.debug |

3302: | |
3303: | SCOPE - PUBLIC |
3304: | |
3305: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
3306: | arp_util.debug |
3307: | |
3308: | ARGUMENTS : IN: |
3309: | p_link_to_cust_trx_line_id - identifies the rows to delete |
3310: | OUT: |

Line 3333: arp_util.debug( 'arp_ctl_pkg.delete_f_ltctl_id()+');

3329: BEGIN
3330:
3331:
3332: IF PG_DEBUG in ('Y', 'C') THEN
3333: arp_util.debug( 'arp_ctl_pkg.delete_f_ltctl_id()+');
3334: END IF;
3335:
3336: DELETE FROM ra_customer_trx_lines
3337: WHERE link_to_cust_trx_line_id = p_link_to_cust_trx_line_id

Line 3344: arp_util.debug( 'arp_ctl_pkg.delete_f_ltctl_id()-');

3340: BULK COLLECT INTO l_ctl_key_list;
3341: --}
3342:
3343: IF PG_DEBUG in ('Y', 'C') THEN
3344: arp_util.debug( 'arp_ctl_pkg.delete_f_ltctl_id()-');
3345: END IF;
3346:
3347: EXCEPTION
3348: WHEN OTHERS THEN

Line 3350: arp_util.debug( 'EXCEPTION: arp_ctl_pkg.delete_f_ltctl_id()');

3346:
3347: EXCEPTION
3348: WHEN OTHERS THEN
3349: IF PG_DEBUG in ('Y', 'C') THEN
3350: arp_util.debug( 'EXCEPTION: arp_ctl_pkg.delete_f_ltctl_id()');
3351: arp_util.debug( '');
3352: arp_util.debug( '-------- parameters for delete_f_ltctl_id() ------');
3353: arp_util.debug( 'p_link_to_cust_trx_line_id = ' ||
3354: p_link_to_cust_trx_line_id);

Line 3351: arp_util.debug( '');

3347: EXCEPTION
3348: WHEN OTHERS THEN
3349: IF PG_DEBUG in ('Y', 'C') THEN
3350: arp_util.debug( 'EXCEPTION: arp_ctl_pkg.delete_f_ltctl_id()');
3351: arp_util.debug( '');
3352: arp_util.debug( '-------- parameters for delete_f_ltctl_id() ------');
3353: arp_util.debug( 'p_link_to_cust_trx_line_id = ' ||
3354: p_link_to_cust_trx_line_id);
3355: END IF;

Line 3352: arp_util.debug( '-------- parameters for delete_f_ltctl_id() ------');

3348: WHEN OTHERS THEN
3349: IF PG_DEBUG in ('Y', 'C') THEN
3350: arp_util.debug( 'EXCEPTION: arp_ctl_pkg.delete_f_ltctl_id()');
3351: arp_util.debug( '');
3352: arp_util.debug( '-------- parameters for delete_f_ltctl_id() ------');
3353: arp_util.debug( 'p_link_to_cust_trx_line_id = ' ||
3354: p_link_to_cust_trx_line_id);
3355: END IF;
3356:

Line 3353: arp_util.debug( 'p_link_to_cust_trx_line_id = ' ||

3349: IF PG_DEBUG in ('Y', 'C') THEN
3350: arp_util.debug( 'EXCEPTION: arp_ctl_pkg.delete_f_ltctl_id()');
3351: arp_util.debug( '');
3352: arp_util.debug( '-------- parameters for delete_f_ltctl_id() ------');
3353: arp_util.debug( 'p_link_to_cust_trx_line_id = ' ||
3354: p_link_to_cust_trx_line_id);
3355: END IF;
3356:
3357: RAISE;

Line 3372: | arp_util.debug |

3368: | |
3369: | SCOPE - PUBLIC |
3370: | |
3371: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
3372: | arp_util.debug |
3373: | |
3374: | ARGUMENTS : IN: |
3375: | p_customer_trx_id - identifies the transaction |
3376: | p_link_to_cust_trx_line_id - identifies the parent line |

Line 3407: arp_util.debug( 'arp_ctl_pkg.delete_f_ct_ltctl_id_type()+');

3403:
3404: BEGIN
3405:
3406: IF PG_DEBUG in ('Y', 'C') THEN
3407: arp_util.debug( 'arp_ctl_pkg.delete_f_ct_ltctl_id_type()+');
3408: END IF;
3409:
3410: DELETE FROM ra_customer_trx_lines
3411: WHERE customer_trx_id = p_customer_trx_id

Line 3422: arp_util.debug( 'arp_ctl_pkg.delete_f_ct_ltctl_id_type()-');

3418: BULK COLLECT INTO l_ctl_key_list;
3419: --}
3420:
3421: IF PG_DEBUG in ('Y', 'C') THEN
3422: arp_util.debug( 'arp_ctl_pkg.delete_f_ct_ltctl_id_type()-');
3423: END IF;
3424:
3425: EXCEPTION
3426: WHEN OTHERS THEN

Line 3428: arp_util.debug( 'EXCEPTION: arp_ctl_pkg.delete_f_ct_ltctl_id_type()');

3424:
3425: EXCEPTION
3426: WHEN OTHERS THEN
3427: IF PG_DEBUG in ('Y', 'C') THEN
3428: arp_util.debug( 'EXCEPTION: arp_ctl_pkg.delete_f_ct_ltctl_id_type()');
3429: arp_util.debug( '');
3430: arp_util.debug( '---- parameters for delete_f_ct_ltctl_id_type() -----');
3431: arp_util.debug( 'p_customer_trx_id = ' || p_customer_trx_id);
3432: arp_util.debug( 'p_link_to_cust_trx_line_id = ' ||

Line 3429: arp_util.debug( '');

3425: EXCEPTION
3426: WHEN OTHERS THEN
3427: IF PG_DEBUG in ('Y', 'C') THEN
3428: arp_util.debug( 'EXCEPTION: arp_ctl_pkg.delete_f_ct_ltctl_id_type()');
3429: arp_util.debug( '');
3430: arp_util.debug( '---- parameters for delete_f_ct_ltctl_id_type() -----');
3431: arp_util.debug( 'p_customer_trx_id = ' || p_customer_trx_id);
3432: arp_util.debug( 'p_link_to_cust_trx_line_id = ' ||
3433: p_link_to_cust_trx_line_id);

Line 3430: arp_util.debug( '---- parameters for delete_f_ct_ltctl_id_type() -----');

3426: WHEN OTHERS THEN
3427: IF PG_DEBUG in ('Y', 'C') THEN
3428: arp_util.debug( 'EXCEPTION: arp_ctl_pkg.delete_f_ct_ltctl_id_type()');
3429: arp_util.debug( '');
3430: arp_util.debug( '---- parameters for delete_f_ct_ltctl_id_type() -----');
3431: arp_util.debug( 'p_customer_trx_id = ' || p_customer_trx_id);
3432: arp_util.debug( 'p_link_to_cust_trx_line_id = ' ||
3433: p_link_to_cust_trx_line_id);
3434: arp_util.debug( 'p_line_type = ' || p_line_type);

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

3427: IF PG_DEBUG in ('Y', 'C') THEN
3428: arp_util.debug( 'EXCEPTION: arp_ctl_pkg.delete_f_ct_ltctl_id_type()');
3429: arp_util.debug( '');
3430: arp_util.debug( '---- parameters for delete_f_ct_ltctl_id_type() -----');
3431: arp_util.debug( 'p_customer_trx_id = ' || p_customer_trx_id);
3432: arp_util.debug( 'p_link_to_cust_trx_line_id = ' ||
3433: p_link_to_cust_trx_line_id);
3434: arp_util.debug( 'p_line_type = ' || p_line_type);
3435: END IF;

Line 3432: arp_util.debug( 'p_link_to_cust_trx_line_id = ' ||

3428: arp_util.debug( 'EXCEPTION: arp_ctl_pkg.delete_f_ct_ltctl_id_type()');
3429: arp_util.debug( '');
3430: arp_util.debug( '---- parameters for delete_f_ct_ltctl_id_type() -----');
3431: arp_util.debug( 'p_customer_trx_id = ' || p_customer_trx_id);
3432: arp_util.debug( 'p_link_to_cust_trx_line_id = ' ||
3433: p_link_to_cust_trx_line_id);
3434: arp_util.debug( 'p_line_type = ' || p_line_type);
3435: END IF;
3436:

Line 3434: arp_util.debug( 'p_line_type = ' || p_line_type);

3430: arp_util.debug( '---- parameters for delete_f_ct_ltctl_id_type() -----');
3431: arp_util.debug( 'p_customer_trx_id = ' || p_customer_trx_id);
3432: arp_util.debug( 'p_link_to_cust_trx_line_id = ' ||
3433: p_link_to_cust_trx_line_id);
3434: arp_util.debug( 'p_line_type = ' || p_line_type);
3435: END IF;
3436:
3437: RAISE;
3438: END;

Line 3452: | arp_util.debug |

3448: | |
3449: | SCOPE - PUBLIC |
3450: | |
3451: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
3452: | arp_util.debug |
3453: | |
3454: | ARGUMENTS : IN: |
3455: | p_customer_trx_line_id - identifies the row to update |
3456: | p_line_rec - contains the new column values |

Line 3483: arp_util.debug( 'arp_ctl_pkg.update_p()+ ' ||

3479:
3480: BEGIN
3481:
3482: IF PG_DEBUG in ('Y', 'C') THEN
3483: arp_util.debug( 'arp_ctl_pkg.update_p()+ ' ||
3484: to_char(sysdate, 'HH:MI:SS'));
3485: END IF;
3486:
3487: /*---------------------------------------------------------------+

Line 3503: arp_util.debug( 'using currency code: ' || l_currency_code );

3499: ELSE l_currency_code := p_currency_code;
3500: END IF;
3501:
3502: IF PG_DEBUG in ('Y', 'C') THEN
3503: arp_util.debug( 'using currency code: ' || l_currency_code );
3504: END IF;
3505:
3506: arp_ctl_pkg.generic_update( pg_cursor1,
3507: ' WHERE customer_trx_line_id = :where_1 ' ||

Line 3515: arp_util.debug( 'arp_ctl_pkg.update_p()- ' ||

3511: l_currency_code,
3512: p_line_rec);
3513:
3514: IF PG_DEBUG in ('Y', 'C') THEN
3515: arp_util.debug( 'arp_ctl_pkg.update_p()- ' ||
3516: to_char(sysdate, 'HH:MI:SS'));
3517: END IF;
3518:
3519:

Line 3523: arp_util.debug( 'EXCEPTION: arp_ctl_pkg.update_p()');

3519:
3520: EXCEPTION
3521: WHEN OTHERS THEN
3522: IF PG_DEBUG in ('Y', 'C') THEN
3523: arp_util.debug( 'EXCEPTION: arp_ctl_pkg.update_p()');
3524: arp_util.debug( '');
3525: arp_util.debug( '-------- parameters for update_p() ------');
3526: arp_util.debug( 'p_customer_trx_line_id = ' ||
3527: p_customer_trx_line_id);

Line 3524: arp_util.debug( '');

3520: EXCEPTION
3521: WHEN OTHERS THEN
3522: IF PG_DEBUG in ('Y', 'C') THEN
3523: arp_util.debug( 'EXCEPTION: arp_ctl_pkg.update_p()');
3524: arp_util.debug( '');
3525: arp_util.debug( '-------- parameters for update_p() ------');
3526: arp_util.debug( 'p_customer_trx_line_id = ' ||
3527: p_customer_trx_line_id);
3528: arp_util.debug( 'p_currency_code = ' || p_currency_code);

Line 3525: arp_util.debug( '-------- parameters for update_p() ------');

3521: WHEN OTHERS THEN
3522: IF PG_DEBUG in ('Y', 'C') THEN
3523: arp_util.debug( 'EXCEPTION: arp_ctl_pkg.update_p()');
3524: arp_util.debug( '');
3525: arp_util.debug( '-------- parameters for update_p() ------');
3526: arp_util.debug( 'p_customer_trx_line_id = ' ||
3527: p_customer_trx_line_id);
3528: arp_util.debug( 'p_currency_code = ' || p_currency_code);
3529: END IF;

Line 3526: arp_util.debug( 'p_customer_trx_line_id = ' ||

3522: IF PG_DEBUG in ('Y', 'C') THEN
3523: arp_util.debug( 'EXCEPTION: arp_ctl_pkg.update_p()');
3524: arp_util.debug( '');
3525: arp_util.debug( '-------- parameters for update_p() ------');
3526: arp_util.debug( 'p_customer_trx_line_id = ' ||
3527: p_customer_trx_line_id);
3528: arp_util.debug( 'p_currency_code = ' || p_currency_code);
3529: END IF;
3530: display_line_rec(p_line_rec);

Line 3528: arp_util.debug( 'p_currency_code = ' || p_currency_code);

3524: arp_util.debug( '');
3525: arp_util.debug( '-------- parameters for update_p() ------');
3526: arp_util.debug( 'p_customer_trx_line_id = ' ||
3527: p_customer_trx_line_id);
3528: arp_util.debug( 'p_currency_code = ' || p_currency_code);
3529: END IF;
3530: display_line_rec(p_line_rec);
3531:
3532: RAISE;

Line 3546: | arp_util.debug |

3542: | |
3543: | SCOPE - PUBLIC |
3544: | |
3545: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
3546: | arp_util.debug |
3547: | |
3548: | ARGUMENTS : IN: |
3549: | p_customer_trx_id - identifies the rows to update |
3550: | p_line_rec - contains the new column values |

Line 3581: arp_util.debug( 'arp_ctl_pkg.update_f_ct_id()+ ' ||

3577:
3578: BEGIN
3579:
3580: IF PG_DEBUG in ('Y', 'C') THEN
3581: arp_util.debug( 'arp_ctl_pkg.update_f_ct_id()+ ' ||
3582: to_char(sysdate, 'HH:MI:SS'));
3583: END IF;
3584:
3585:

Line 3601: arp_util.debug( 'using currency code: ' || l_currency_code );

3597: ELSE l_currency_code := p_currency_code;
3598: END IF;
3599:
3600: IF PG_DEBUG in ('Y', 'C') THEN
3601: arp_util.debug( 'using currency code: ' || l_currency_code );
3602: END IF;
3603:
3604:
3605: l_where := ' WHERE customer_trx_id = :where_1 ' ||

Line 3616: arp_util.debug( 'arp_ctl_pkg.update_f_ct_id()- ' ||

3612: l_currency_code,
3613: p_line_rec);
3614:
3615: IF PG_DEBUG in ('Y', 'C') THEN
3616: arp_util.debug( 'arp_ctl_pkg.update_f_ct_id()- ' ||
3617: to_char(sysdate, 'HH:MI:SS'));
3618: END IF;
3619:
3620:

Line 3624: arp_util.debug( 'EXCEPTION: arp_ctl_pkg.update_f_ct_id()');

3620:
3621: EXCEPTION
3622: WHEN OTHERS THEN
3623: IF PG_DEBUG in ('Y', 'C') THEN
3624: arp_util.debug( 'EXCEPTION: arp_ctl_pkg.update_f_ct_id()');
3625: arp_util.debug( '');
3626: arp_util.debug( '-------- parameters for update_f_ct_id() ------');
3627: arp_util.debug( 'p_customer_trx_id = ' ||
3628: p_customer_trx_id);

Line 3625: arp_util.debug( '');

3621: EXCEPTION
3622: WHEN OTHERS THEN
3623: IF PG_DEBUG in ('Y', 'C') THEN
3624: arp_util.debug( 'EXCEPTION: arp_ctl_pkg.update_f_ct_id()');
3625: arp_util.debug( '');
3626: arp_util.debug( '-------- parameters for update_f_ct_id() ------');
3627: arp_util.debug( 'p_customer_trx_id = ' ||
3628: p_customer_trx_id);
3629: arp_util.debug( 'p_line_type = ' || p_line_type);

Line 3626: arp_util.debug( '-------- parameters for update_f_ct_id() ------');

3622: WHEN OTHERS THEN
3623: IF PG_DEBUG in ('Y', 'C') THEN
3624: arp_util.debug( 'EXCEPTION: arp_ctl_pkg.update_f_ct_id()');
3625: arp_util.debug( '');
3626: arp_util.debug( '-------- parameters for update_f_ct_id() ------');
3627: arp_util.debug( 'p_customer_trx_id = ' ||
3628: p_customer_trx_id);
3629: arp_util.debug( 'p_line_type = ' || p_line_type);
3630: arp_util.debug( 'p_currency_code = ' || p_currency_code);

Line 3627: arp_util.debug( 'p_customer_trx_id = ' ||

3623: IF PG_DEBUG in ('Y', 'C') THEN
3624: arp_util.debug( 'EXCEPTION: arp_ctl_pkg.update_f_ct_id()');
3625: arp_util.debug( '');
3626: arp_util.debug( '-------- parameters for update_f_ct_id() ------');
3627: arp_util.debug( 'p_customer_trx_id = ' ||
3628: p_customer_trx_id);
3629: arp_util.debug( 'p_line_type = ' || p_line_type);
3630: arp_util.debug( 'p_currency_code = ' || p_currency_code);
3631: END IF;

Line 3629: arp_util.debug( 'p_line_type = ' || p_line_type);

3625: arp_util.debug( '');
3626: arp_util.debug( '-------- parameters for update_f_ct_id() ------');
3627: arp_util.debug( 'p_customer_trx_id = ' ||
3628: p_customer_trx_id);
3629: arp_util.debug( 'p_line_type = ' || p_line_type);
3630: arp_util.debug( 'p_currency_code = ' || p_currency_code);
3631: END IF;
3632: display_line_rec(p_line_rec);
3633:

Line 3630: arp_util.debug( 'p_currency_code = ' || p_currency_code);

3626: arp_util.debug( '-------- parameters for update_f_ct_id() ------');
3627: arp_util.debug( 'p_customer_trx_id = ' ||
3628: p_customer_trx_id);
3629: arp_util.debug( 'p_line_type = ' || p_line_type);
3630: arp_util.debug( 'p_currency_code = ' || p_currency_code);
3631: END IF;
3632: display_line_rec(p_line_rec);
3633:
3634: RAISE;

Line 3699: arp_util.debug( 'arp_ctl_pkg.update_amount_f_ctl_id('

3695: l_old_inclusive_amt ra_customer_trx_lines.extended_amount%type;
3696: l_qty ra_customer_trx_lines.quantity_invoiced%type;
3697: begin
3698: IF PG_DEBUG in ('Y', 'C') THEN
3699: arp_util.debug( 'arp_ctl_pkg.update_amount_f_ctl_id('
3700: || to_char(p_customer_trx_line_id) || ','
3701: || to_char(p_inclusive_amt)
3702: ||')+');
3703: END IF;

Line 3767: arp_util.debug( 'arp_ctl_pkg.update_amount_f_ctl_id('

3763: p_new_extended_amt := l_extended_amount;
3764: p_new_unit_selling_price := l_unit_selling_price;
3765:
3766: IF PG_DEBUG in ('Y', 'C') THEN
3767: arp_util.debug( 'arp_ctl_pkg.update_amount_f_ctl_id('
3768: || to_char(l_extended_amount) || ','
3769: || to_char(l_unit_selling_price)
3770: ||')-');
3771: END IF;

Line 3779: arp_util.debug( 'arp_ctl_pkg.update_amount_f_ctl_id(EXCEPTION)-');

3775: close c;
3776: end if;
3777:
3778: IF PG_DEBUG in ('Y', 'C') THEN
3779: arp_util.debug( 'arp_ctl_pkg.update_amount_f_ctl_id(EXCEPTION)-');
3780: END IF;
3781: raise;
3782: end update_amount_f_ctl_id;
3783:

Line 3845: arp_util.debug( 'arp_ctl_pkg.update_cm_amount_f_ctl_id('

3841: l_revenue_amount ra_customer_trx_lines.revenue_amount%type;
3842: l_old_inclusive_amt ra_customer_trx_lines.extended_amount%type;
3843: begin
3844: IF PG_DEBUG in ('Y', 'C') THEN
3845: arp_util.debug( 'arp_ctl_pkg.update_cm_amount_f_ctl_id('
3846: || to_char(p_customer_trx_line_id) || ','
3847: || to_char(p_inclusive_amount)
3848: ||')+');
3849: END IF;

Line 3860: arp_util.debug( 'arp_ctl_pkg.update_cm_amount_f_ctl_id: '||

3856: if ( p_inclusive_amount is null ) OR
3857: ( p_inclusive_amount = 0 )
3858: then
3859: IF PG_DEBUG in ('Y', 'C') THEN
3860: arp_util.debug( 'arp_ctl_pkg.update_cm_amount_f_ctl_id: '||
3861: 'No Inclusive Tax Amounts');
3862: END IF;
3863:
3864: l_gross_extended_amount := null;

Line 3868: arp_util.debug( 'arp_ctl_pkg.update_cm_amount_f_ctl_id: '||

3864: l_gross_extended_amount := null;
3865: l_gross_unit_selling_price := null;
3866: else
3867: IF PG_DEBUG in ('Y', 'C') THEN
3868: arp_util.debug( 'arp_ctl_pkg.update_cm_amount_f_ctl_id: '||
3869: 'Inclusive Amount = '||to_char(p_inclusive_amount));
3870: arp_util.debug( 'arp_ctl_pkg.update_cm_amount_f_ctl_id: '||
3871: 'Quantity = '||nvl(to_char(crow.quantity_credited), 'NULL'));
3872: arp_util.debug( 'arp_ctl_pkg.update_cm_amount_f_ctl_id: '||

Line 3870: arp_util.debug( 'arp_ctl_pkg.update_cm_amount_f_ctl_id: '||

3866: else
3867: IF PG_DEBUG in ('Y', 'C') THEN
3868: arp_util.debug( 'arp_ctl_pkg.update_cm_amount_f_ctl_id: '||
3869: 'Inclusive Amount = '||to_char(p_inclusive_amount));
3870: arp_util.debug( 'arp_ctl_pkg.update_cm_amount_f_ctl_id: '||
3871: 'Quantity = '||nvl(to_char(crow.quantity_credited), 'NULL'));
3872: arp_util.debug( 'arp_ctl_pkg.update_cm_amount_f_ctl_id: '||
3873: 'Precision = '||nvl(to_char(p_precision), 'NULL'));
3874: arp_util.debug( 'arp_ctl_pkg.update_cm_amount_f_ctl_id: '||

Line 3872: arp_util.debug( 'arp_ctl_pkg.update_cm_amount_f_ctl_id: '||

3868: arp_util.debug( 'arp_ctl_pkg.update_cm_amount_f_ctl_id: '||
3869: 'Inclusive Amount = '||to_char(p_inclusive_amount));
3870: arp_util.debug( 'arp_ctl_pkg.update_cm_amount_f_ctl_id: '||
3871: 'Quantity = '||nvl(to_char(crow.quantity_credited), 'NULL'));
3872: arp_util.debug( 'arp_ctl_pkg.update_cm_amount_f_ctl_id: '||
3873: 'Precision = '||nvl(to_char(p_precision), 'NULL'));
3874: arp_util.debug( 'arp_ctl_pkg.update_cm_amount_f_ctl_id: '||
3875: 'MAU = '||nvl(to_char(p_min_acct_unit), 'NULL'));
3876: END IF;

Line 3874: arp_util.debug( 'arp_ctl_pkg.update_cm_amount_f_ctl_id: '||

3870: arp_util.debug( 'arp_ctl_pkg.update_cm_amount_f_ctl_id: '||
3871: 'Quantity = '||nvl(to_char(crow.quantity_credited), 'NULL'));
3872: arp_util.debug( 'arp_ctl_pkg.update_cm_amount_f_ctl_id: '||
3873: 'Precision = '||nvl(to_char(p_precision), 'NULL'));
3874: arp_util.debug( 'arp_ctl_pkg.update_cm_amount_f_ctl_id: '||
3875: 'MAU = '||nvl(to_char(p_min_acct_unit), 'NULL'));
3876: END IF;
3877:
3878: l_gross_extended_amount := crow.extended_amount + p_inclusive_amount;

Line 3887: arp_util.debug( 'EXCPETION: Unable to fetch original invoice');

3883: close cinv;
3884: exception
3885: when others then
3886: IF PG_DEBUG in ('Y', 'C') THEN
3887: arp_util.debug( 'EXCPETION: Unable to fetch original invoice');
3888: END IF;
3889: raise;
3890: end;
3891: elsif ( crow.unit_selling_price is null ) then

Line 3893: arp_util.debug( 'arp_ctl_pkg.update_cm_amount_f_ctl_id: NO unit selling price');

3889: raise;
3890: end;
3891: elsif ( crow.unit_selling_price is null ) then
3892: IF PG_DEBUG in ('Y', 'C') THEN
3893: arp_util.debug( 'arp_ctl_pkg.update_cm_amount_f_ctl_id: NO unit selling price');
3894: END IF;
3895: l_gross_unit_selling_price := null;
3896: elsif (p_min_acct_unit is null) then
3897: IF PG_DEBUG in ('Y', 'C') THEN

Line 3898: arp_util.debug( 'arp_ctl_pkg.update_cm_amount_f_ctl_id: Rounding to precision');

3894: END IF;
3895: l_gross_unit_selling_price := null;
3896: elsif (p_min_acct_unit is null) then
3897: IF PG_DEBUG in ('Y', 'C') THEN
3898: arp_util.debug( 'arp_ctl_pkg.update_cm_amount_f_ctl_id: Rounding to precision');
3899: END IF;
3900: l_gross_unit_selling_price :=
3901: round(l_gross_extended_amount / crow.quantity_credited, p_precision+2);
3902: else

Line 3904: arp_util.debug( 'arp_ctl_pkg.update_cm_amount_f_ctl_id: Rounding to MAU');

3900: l_gross_unit_selling_price :=
3901: round(l_gross_extended_amount / crow.quantity_credited, p_precision+2);
3902: else
3903: IF PG_DEBUG in ('Y', 'C') THEN
3904: arp_util.debug( 'arp_ctl_pkg.update_cm_amount_f_ctl_id: Rounding to MAU');
3905: END IF;
3906: l_gross_unit_selling_price :=
3907: round(l_gross_extended_amount / crow.quantity_credited / p_min_acct_unit / 100)
3908: * 100 * p_min_acct_unit;

Line 3925: arp_util.debug( 'arp_ctl_pkg.update_cm_amount_f_ctl_id('

3921: p_new_gross_extended_amount := l_gross_extended_amount;
3922: p_new_gross_unit_selling_price := l_gross_unit_selling_price;
3923:
3924: IF PG_DEBUG in ('Y', 'C') THEN
3925: arp_util.debug( 'arp_ctl_pkg.update_cm_amount_f_ctl_id('
3926: || to_char(l_gross_extended_amount) || ','
3927: || to_char(l_gross_unit_selling_price)
3928: ||')-');
3929: END IF;

Line 3938: arp_util.debug( 'arp_ctl_pkg.update_cm_amount_f_ctl_id(EXCEPTION)-');

3934: close c;
3935: end if;
3936:
3937: IF PG_DEBUG in ('Y', 'C') THEN
3938: arp_util.debug( 'arp_ctl_pkg.update_cm_amount_f_ctl_id(EXCEPTION)-');
3939: END IF;
3940: raise;
3941: end update_cm_amount_f_ctl_id;
3942:

Line 3956: | arp_util.debug |

3952: | |
3953: | SCOPE - PUBLIC |
3954: | |
3955: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
3956: | arp_util.debug |
3957: | arp_global.set_of_books_id |
3958: | |
3959: | ARGUMENTS : IN: |
3960: | p_line_rec - contains the new column values |

Line 4016: arp_util.debug( 'arp_ctl_pkg.insert_p()+');

4012:
4013: BEGIN
4014:
4015: IF PG_DEBUG in ('Y', 'C') THEN
4016: arp_util.debug( 'arp_ctl_pkg.insert_p()+');
4017: END IF;
4018:
4019: p_customer_trx_line_id := '';
4020:

Line 4319: arp_util.debug( 'after insert: amount_includes_tax_flag = ' ||

4315:
4316: p_customer_trx_line_id := l_customer_trx_line_id;
4317:
4318: IF PG_DEBUG in ('Y', 'C') THEN
4319: arp_util.debug( 'after insert: amount_includes_tax_flag = ' ||
4320: p_line_rec.amount_includes_tax_flag);
4321: arp_util.debug( 'after insert: gross_extended_amount = ' ||
4322: p_line_rec.gross_extended_amount);
4323: arp_util.debug( 'after insert: gross_unit_selling_price = ' ||

Line 4321: arp_util.debug( 'after insert: gross_extended_amount = ' ||

4317:
4318: IF PG_DEBUG in ('Y', 'C') THEN
4319: arp_util.debug( 'after insert: amount_includes_tax_flag = ' ||
4320: p_line_rec.amount_includes_tax_flag);
4321: arp_util.debug( 'after insert: gross_extended_amount = ' ||
4322: p_line_rec.gross_extended_amount);
4323: arp_util.debug( 'after insert: gross_unit_selling_price = ' ||
4324: p_line_rec.gross_unit_selling_price);
4325: arp_util.debug( 'arp_ctl_pkg.insert_p()-');

Line 4323: arp_util.debug( 'after insert: gross_unit_selling_price = ' ||

4319: arp_util.debug( 'after insert: amount_includes_tax_flag = ' ||
4320: p_line_rec.amount_includes_tax_flag);
4321: arp_util.debug( 'after insert: gross_extended_amount = ' ||
4322: p_line_rec.gross_extended_amount);
4323: arp_util.debug( 'after insert: gross_unit_selling_price = ' ||
4324: p_line_rec.gross_unit_selling_price);
4325: arp_util.debug( 'arp_ctl_pkg.insert_p()-');
4326: END IF;
4327:

Line 4325: arp_util.debug( 'arp_ctl_pkg.insert_p()-');

4321: arp_util.debug( 'after insert: gross_extended_amount = ' ||
4322: p_line_rec.gross_extended_amount);
4323: arp_util.debug( 'after insert: gross_unit_selling_price = ' ||
4324: p_line_rec.gross_unit_selling_price);
4325: arp_util.debug( 'arp_ctl_pkg.insert_p()-');
4326: END IF;
4327:
4328: EXCEPTION
4329: WHEN OTHERS THEN

Line 4331: arp_util.debug( 'EXCEPTION: arp_ctl_pkg.insert_p()');

4327:
4328: EXCEPTION
4329: WHEN OTHERS THEN
4330: IF PG_DEBUG in ('Y', 'C') THEN
4331: arp_util.debug( 'EXCEPTION: arp_ctl_pkg.insert_p()');
4332: arp_util.debug( '');
4333: arp_util.debug( '-------- parameters for insert_p() ------');
4334: END IF;
4335: display_line_rec(p_line_rec);

Line 4332: arp_util.debug( '');

4328: EXCEPTION
4329: WHEN OTHERS THEN
4330: IF PG_DEBUG in ('Y', 'C') THEN
4331: arp_util.debug( 'EXCEPTION: arp_ctl_pkg.insert_p()');
4332: arp_util.debug( '');
4333: arp_util.debug( '-------- parameters for insert_p() ------');
4334: END IF;
4335: display_line_rec(p_line_rec);
4336:

Line 4333: arp_util.debug( '-------- parameters for insert_p() ------');

4329: WHEN OTHERS THEN
4330: IF PG_DEBUG in ('Y', 'C') THEN
4331: arp_util.debug( 'EXCEPTION: arp_ctl_pkg.insert_p()');
4332: arp_util.debug( '');
4333: arp_util.debug( '-------- parameters for insert_p() ------');
4334: END IF;
4335: display_line_rec(p_line_rec);
4336:
4337: RAISE;

Line 4351: | arp_util.debug |

4347: | |
4348: | SCOPE - PRIVATE |
4349: | |
4350: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
4351: | arp_util.debug |
4352: | |
4353: | ARGUMENTS : IN: |
4354: | p_line_rec |
4355: | OUT: |

Line 4370: arp_util.debug( 'arp_ctl_pkg.display_line_rec()+');

4366: PROCEDURE display_line_rec(
4367: p_line_rec IN ra_customer_trx_lines%rowtype) IS
4368: BEGIN
4369: IF PG_DEBUG in ('Y', 'C') THEN
4370: arp_util.debug( 'arp_ctl_pkg.display_line_rec()+');
4371: END IF;
4372:
4373: arp_ctl_private_pkg.display_line_rec(p_line_rec);
4374:

Line 4376: arp_util.debug( 'arp_ctl_pkg.display_line_rec()-');

4372:
4373: arp_ctl_private_pkg.display_line_rec(p_line_rec);
4374:
4375: IF PG_DEBUG in ('Y', 'C') THEN
4376: arp_util.debug( 'arp_ctl_pkg.display_line_rec()-');
4377: END IF;
4378: END;
4379:
4380:

Line 4392: | arp_util.debug |

4388: | |
4389: | SCOPE - PUBLIC |
4390: | |
4391: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
4392: | arp_util.debug |
4393: | |
4394: | ARGUMENTS : IN: |
4395: | p_customer_trx_line_id |
4396: | OUT: |

Line 4412: arp_util.debug( 'arp_ctl_pkg.display_line_p()+');

4408: p_customer_trx_line_id IN
4409: ra_customer_trx_lines.customer_trx_line_id%type) IS
4410: BEGIN
4411: IF PG_DEBUG in ('Y', 'C') THEN
4412: arp_util.debug( 'arp_ctl_pkg.display_line_p()+');
4413: END IF;
4414:
4415: arp_ctl_private_pkg.display_line_p(p_customer_trx_line_id);
4416:

Line 4418: arp_util.debug( 'arp_ctl_pkg.display_line_p()-');

4414:
4415: arp_ctl_private_pkg.display_line_p(p_customer_trx_line_id);
4416:
4417: IF PG_DEBUG in ('Y', 'C') THEN
4418: arp_util.debug( 'arp_ctl_pkg.display_line_p()-');
4419: END IF;
4420:
4421: END;
4422:

Line 4434: | arp_util.debug |

4430: | |
4431: | SCOPE - PUBLIC |
4432: | |
4433: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
4434: | arp_util.debug |
4435: | |
4436: | ARGUMENTS : IN: |
4437: | p_link_to_cust_trx_line_id |
4438: | OUT: |

Line 4459: arp_util.debug( 'arp_ctl_pkg.display_line_f_lctl_id()+');

4455: IS
4456: BEGIN
4457:
4458: IF PG_DEBUG in ('Y', 'C') THEN
4459: arp_util.debug( 'arp_ctl_pkg.display_line_f_lctl_id()+');
4460: END IF;
4461:
4462: arp_ctl_private_pkg.display_line_f_lctl_id( p_link_to_cust_trx_line_id );
4463:

Line 4465: arp_util.debug( 'arp_ctl_pkg.display_line_f_lctl_id()-');

4461:
4462: arp_ctl_private_pkg.display_line_f_lctl_id( p_link_to_cust_trx_line_id );
4463:
4464: IF PG_DEBUG in ('Y', 'C') THEN
4465: arp_util.debug( 'arp_ctl_pkg.display_line_f_lctl_id()-');
4466: END IF;
4467:
4468: END;
4469:

Line 4482: | arp_util.debug |

4478: | |
4479: | SCOPE - PUBLIC |
4480: | |
4481: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
4482: | arp_util.debug |
4483: | |
4484: | ARGUMENTS : IN: |
4485: | p_customer_trx_id |
4486: | OUT: |

Line 4507: arp_util.debug( 'arp_ctl_pkg.display_line_f_ct_id()+');

4503: IS
4504: BEGIN
4505:
4506: IF PG_DEBUG in ('Y', 'C') THEN
4507: arp_util.debug( 'arp_ctl_pkg.display_line_f_ct_id()+');
4508: END IF;
4509:
4510: arp_ctl_private_pkg.display_line_f_ct_id( p_customer_trx_id );
4511:

Line 4513: arp_util.debug( 'arp_ctl_pkg.display_line_f_ct_id()-');

4509:
4510: arp_ctl_private_pkg.display_line_f_ct_id( p_customer_trx_id );
4511:
4512: IF PG_DEBUG in ('Y', 'C') THEN
4513: arp_util.debug( 'arp_ctl_pkg.display_line_f_ct_id()-');
4514: END IF;
4515:
4516: END;
4517:

Line 4530: | arp_util.debug |

4526: | |
4527: | SCOPE - PRIVATE |
4528: | |
4529: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
4530: | arp_util.debug |
4531: | |
4532: | ARGUMENTS : IN: |
4533: | p_old_line_rec |
4534: | p_new_line_rec |

Line 4589: arp_util.debug( 'arp_ctl_pkg.merge_line_recs()+');

4585:
4586: BEGIN
4587:
4588: IF PG_DEBUG in ('Y', 'C') THEN
4589: arp_util.debug( 'arp_ctl_pkg.merge_line_recs()+');
4590: END IF;
4591:
4592: IF (p_new_line_rec.customer_trx_line_id = AR_NUMBER_DUMMY)
4593: THEN p_out_line_rec.customer_trx_line_id :=

Line 5348: arp_util.debug( 'arp_ctl_pkg.merge_line_recs()-');

5344: ELSE p_out_line_rec.rule_end_date := p_new_line_rec.rule_end_date;
5345: END IF;
5346:
5347: IF PG_DEBUG in ('Y', 'C') THEN
5348: arp_util.debug( 'arp_ctl_pkg.merge_line_recs()-');
5349: END IF;
5350:
5351: EXCEPTION
5352: WHEN OTHERS THEN

Line 5354: arp_util.debug( 'EXCEPTION: arp_ctl_pkg.merge_line_recs()');

5350:
5351: EXCEPTION
5352: WHEN OTHERS THEN
5353: IF PG_DEBUG in ('Y', 'C') THEN
5354: arp_util.debug( 'EXCEPTION: arp_ctl_pkg.merge_line_recs()');
5355: arp_util.debug( '');
5356: arp_util.debug( '-------- parameters for merge_line_recs() ------');
5357: arp_util.debug( ' ---- old line record ----');
5358: END IF;

Line 5355: arp_util.debug( '');

5351: EXCEPTION
5352: WHEN OTHERS THEN
5353: IF PG_DEBUG in ('Y', 'C') THEN
5354: arp_util.debug( 'EXCEPTION: arp_ctl_pkg.merge_line_recs()');
5355: arp_util.debug( '');
5356: arp_util.debug( '-------- parameters for merge_line_recs() ------');
5357: arp_util.debug( ' ---- old line record ----');
5358: END IF;
5359: display_line_rec(p_old_line_rec);

Line 5356: arp_util.debug( '-------- parameters for merge_line_recs() ------');

5352: WHEN OTHERS THEN
5353: IF PG_DEBUG in ('Y', 'C') THEN
5354: arp_util.debug( 'EXCEPTION: arp_ctl_pkg.merge_line_recs()');
5355: arp_util.debug( '');
5356: arp_util.debug( '-------- parameters for merge_line_recs() ------');
5357: arp_util.debug( ' ---- old line record ----');
5358: END IF;
5359: display_line_rec(p_old_line_rec);
5360: IF PG_DEBUG in ('Y', 'C') THEN

Line 5357: arp_util.debug( ' ---- old line record ----');

5353: IF PG_DEBUG in ('Y', 'C') THEN
5354: arp_util.debug( 'EXCEPTION: arp_ctl_pkg.merge_line_recs()');
5355: arp_util.debug( '');
5356: arp_util.debug( '-------- parameters for merge_line_recs() ------');
5357: arp_util.debug( ' ---- old line record ----');
5358: END IF;
5359: display_line_rec(p_old_line_rec);
5360: IF PG_DEBUG in ('Y', 'C') THEN
5361: arp_util.debug( '');

Line 5361: arp_util.debug( '');

5357: arp_util.debug( ' ---- old line record ----');
5358: END IF;
5359: display_line_rec(p_old_line_rec);
5360: IF PG_DEBUG in ('Y', 'C') THEN
5361: arp_util.debug( '');
5362: arp_util.debug( ' ---- new line record ----');
5363: END IF;
5364: display_line_rec(p_new_line_rec);
5365: IF PG_DEBUG in ('Y', 'C') THEN

Line 5362: arp_util.debug( ' ---- new line record ----');

5358: END IF;
5359: display_line_rec(p_old_line_rec);
5360: IF PG_DEBUG in ('Y', 'C') THEN
5361: arp_util.debug( '');
5362: arp_util.debug( ' ---- new line record ----');
5363: END IF;
5364: display_line_rec(p_new_line_rec);
5365: IF PG_DEBUG in ('Y', 'C') THEN
5366: arp_util.debug( '');

Line 5366: arp_util.debug( '');

5362: arp_util.debug( ' ---- new line record ----');
5363: END IF;
5364: display_line_rec(p_new_line_rec);
5365: IF PG_DEBUG in ('Y', 'C') THEN
5366: arp_util.debug( '');
5367: arp_util.debug( ' ---- merged line record ----');
5368: END IF;
5369: display_line_rec(p_out_line_rec);
5370: IF PG_DEBUG in ('Y', 'C') THEN

Line 5367: arp_util.debug( ' ---- merged line record ----');

5363: END IF;
5364: display_line_rec(p_new_line_rec);
5365: IF PG_DEBUG in ('Y', 'C') THEN
5366: arp_util.debug( '');
5367: arp_util.debug( ' ---- merged line record ----');
5368: END IF;
5369: display_line_rec(p_out_line_rec);
5370: IF PG_DEBUG in ('Y', 'C') THEN
5371: arp_util.debug( '');

Line 5371: arp_util.debug( '');

5367: arp_util.debug( ' ---- merged line record ----');
5368: END IF;
5369: display_line_rec(p_out_line_rec);
5370: IF PG_DEBUG in ('Y', 'C') THEN
5371: arp_util.debug( '');
5372: END IF;
5373:
5374: RAISE;
5375:

Line 5388: | arp_util.debug |

5384: | |
5385: | SCOPE - PUBLIC |
5386: | |
5387: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
5388: | arp_util.debug |
5389: | |
5390: | ARGUMENTS : IN: |
5391: | None |
5392: | OUT: |

Line 5463: arp_util.debug( 'arp_ctl_pkg.insert_line_f_cm_ct_ctl_id()+');

5459:
5460: BEGIN
5461:
5462: IF PG_DEBUG in ('Y', 'C') THEN
5463: arp_util.debug( 'arp_ctl_pkg.insert_line_f_cm_ct_ctl_id()+');
5464: -- MVKOLLA - Bug7113653 Added following debug messages
5465: arp_util.debug('-- Added below messages for bug7113653');
5466: arp_util.debug('p_customer_trx_id '||p_customer_trx_id);
5467: arp_util.debug('p_customer_trx_line_id '||p_customer_trx_line_id);

Line 5465: arp_util.debug('-- Added below messages for bug7113653');

5461:
5462: IF PG_DEBUG in ('Y', 'C') THEN
5463: arp_util.debug( 'arp_ctl_pkg.insert_line_f_cm_ct_ctl_id()+');
5464: -- MVKOLLA - Bug7113653 Added following debug messages
5465: arp_util.debug('-- Added below messages for bug7113653');
5466: arp_util.debug('p_customer_trx_id '||p_customer_trx_id);
5467: arp_util.debug('p_customer_trx_line_id '||p_customer_trx_line_id);
5468: arp_util.debug('p_prev_customer_trx_id '||p_prev_customer_trx_id);
5469: arp_util.debug('p_line_type '||p_line_type);

Line 5466: arp_util.debug('p_customer_trx_id '||p_customer_trx_id);

5462: IF PG_DEBUG in ('Y', 'C') THEN
5463: arp_util.debug( 'arp_ctl_pkg.insert_line_f_cm_ct_ctl_id()+');
5464: -- MVKOLLA - Bug7113653 Added following debug messages
5465: arp_util.debug('-- Added below messages for bug7113653');
5466: arp_util.debug('p_customer_trx_id '||p_customer_trx_id);
5467: arp_util.debug('p_customer_trx_line_id '||p_customer_trx_line_id);
5468: arp_util.debug('p_prev_customer_trx_id '||p_prev_customer_trx_id);
5469: arp_util.debug('p_line_type '||p_line_type);
5470: arp_util.debug('p_line_percent '||p_line_percent);

Line 5467: arp_util.debug('p_customer_trx_line_id '||p_customer_trx_line_id);

5463: arp_util.debug( 'arp_ctl_pkg.insert_line_f_cm_ct_ctl_id()+');
5464: -- MVKOLLA - Bug7113653 Added following debug messages
5465: arp_util.debug('-- Added below messages for bug7113653');
5466: arp_util.debug('p_customer_trx_id '||p_customer_trx_id);
5467: arp_util.debug('p_customer_trx_line_id '||p_customer_trx_line_id);
5468: arp_util.debug('p_prev_customer_trx_id '||p_prev_customer_trx_id);
5469: arp_util.debug('p_line_type '||p_line_type);
5470: arp_util.debug('p_line_percent '||p_line_percent);
5471: arp_util.debug('p_uncredited_amount '||p_uncredited_amount);

Line 5468: arp_util.debug('p_prev_customer_trx_id '||p_prev_customer_trx_id);

5464: -- MVKOLLA - Bug7113653 Added following debug messages
5465: arp_util.debug('-- Added below messages for bug7113653');
5466: arp_util.debug('p_customer_trx_id '||p_customer_trx_id);
5467: arp_util.debug('p_customer_trx_line_id '||p_customer_trx_line_id);
5468: arp_util.debug('p_prev_customer_trx_id '||p_prev_customer_trx_id);
5469: arp_util.debug('p_line_type '||p_line_type);
5470: arp_util.debug('p_line_percent '||p_line_percent);
5471: arp_util.debug('p_uncredited_amount '||p_uncredited_amount);
5472: arp_util.debug('p_credit_amount '||p_credit_amount);

Line 5469: arp_util.debug('p_line_type '||p_line_type);

5465: arp_util.debug('-- Added below messages for bug7113653');
5466: arp_util.debug('p_customer_trx_id '||p_customer_trx_id);
5467: arp_util.debug('p_customer_trx_line_id '||p_customer_trx_line_id);
5468: arp_util.debug('p_prev_customer_trx_id '||p_prev_customer_trx_id);
5469: arp_util.debug('p_line_type '||p_line_type);
5470: arp_util.debug('p_line_percent '||p_line_percent);
5471: arp_util.debug('p_uncredited_amount '||p_uncredited_amount);
5472: arp_util.debug('p_credit_amount '||p_credit_amount);
5473: arp_util.debug('p_currency_code '||p_currency_code);

Line 5470: arp_util.debug('p_line_percent '||p_line_percent);

5466: arp_util.debug('p_customer_trx_id '||p_customer_trx_id);
5467: arp_util.debug('p_customer_trx_line_id '||p_customer_trx_line_id);
5468: arp_util.debug('p_prev_customer_trx_id '||p_prev_customer_trx_id);
5469: arp_util.debug('p_line_type '||p_line_type);
5470: arp_util.debug('p_line_percent '||p_line_percent);
5471: arp_util.debug('p_uncredited_amount '||p_uncredited_amount);
5472: arp_util.debug('p_credit_amount '||p_credit_amount);
5473: arp_util.debug('p_currency_code '||p_currency_code);
5474: arp_util.debug('p_tax_amount '||p_tax_amount);

Line 5471: arp_util.debug('p_uncredited_amount '||p_uncredited_amount);

5467: arp_util.debug('p_customer_trx_line_id '||p_customer_trx_line_id);
5468: arp_util.debug('p_prev_customer_trx_id '||p_prev_customer_trx_id);
5469: arp_util.debug('p_line_type '||p_line_type);
5470: arp_util.debug('p_line_percent '||p_line_percent);
5471: arp_util.debug('p_uncredited_amount '||p_uncredited_amount);
5472: arp_util.debug('p_credit_amount '||p_credit_amount);
5473: arp_util.debug('p_currency_code '||p_currency_code);
5474: arp_util.debug('p_tax_amount '||p_tax_amount);
5475: END IF;

Line 5472: arp_util.debug('p_credit_amount '||p_credit_amount);

5468: arp_util.debug('p_prev_customer_trx_id '||p_prev_customer_trx_id);
5469: arp_util.debug('p_line_type '||p_line_type);
5470: arp_util.debug('p_line_percent '||p_line_percent);
5471: arp_util.debug('p_uncredited_amount '||p_uncredited_amount);
5472: arp_util.debug('p_credit_amount '||p_credit_amount);
5473: arp_util.debug('p_currency_code '||p_currency_code);
5474: arp_util.debug('p_tax_amount '||p_tax_amount);
5475: END IF;
5476:

Line 5473: arp_util.debug('p_currency_code '||p_currency_code);

5469: arp_util.debug('p_line_type '||p_line_type);
5470: arp_util.debug('p_line_percent '||p_line_percent);
5471: arp_util.debug('p_uncredited_amount '||p_uncredited_amount);
5472: arp_util.debug('p_credit_amount '||p_credit_amount);
5473: arp_util.debug('p_currency_code '||p_currency_code);
5474: arp_util.debug('p_tax_amount '||p_tax_amount);
5475: END IF;
5476:
5477: --{BUG#3339072

Line 5474: arp_util.debug('p_tax_amount '||p_tax_amount);

5470: arp_util.debug('p_line_percent '||p_line_percent);
5471: arp_util.debug('p_uncredited_amount '||p_uncredited_amount);
5472: arp_util.debug('p_credit_amount '||p_credit_amount);
5473: arp_util.debug('p_currency_code '||p_currency_code);
5474: arp_util.debug('p_tax_amount '||p_tax_amount);
5475: END IF;
5476:
5477: --{BUG#3339072
5478: SELECT ra_customer_trx_lines_s.nextval,

Line 5710: arp_util.debug( 'arp_ctl_pkg.insert_line_f_cm_ct_ctl_id : '||' 0 row Fetch ');

5706:
5707: /* Bug-3658284 -Start */
5708: IF (l_trx_line_array.customer_trx_line_id.COUNT = 0) Then
5709: IF PG_DEBUG in ('Y', 'C') THEN
5710: arp_util.debug( 'arp_ctl_pkg.insert_line_f_cm_ct_ctl_id : '||' 0 row Fetch ');
5711: END IF;
5712:
5713: ELSE /*-- Bug 5098922 ---*/
5714:

Line 5756: arp_util.debug('Inclusive tax, adjusting extended/revenue amounts');

5752: p_tax_amount IS NOT NULL
5753: THEN
5754: IF PG_DEBUG = 'Y'
5755: THEN
5756: arp_util.debug('Inclusive tax, adjusting extended/revenue amounts');
5757: arp_util.debug('customer_trx_line_id = ' ||
5758: l_trx_line_array.customer_trx_line_id(i));
5759: arp_util.debug(' original extended_amount = ' ||
5760: l_trx_line_array.extended_amount(i));

Line 5757: arp_util.debug('customer_trx_line_id = ' ||

5753: THEN
5754: IF PG_DEBUG = 'Y'
5755: THEN
5756: arp_util.debug('Inclusive tax, adjusting extended/revenue amounts');
5757: arp_util.debug('customer_trx_line_id = ' ||
5758: l_trx_line_array.customer_trx_line_id(i));
5759: arp_util.debug(' original extended_amount = ' ||
5760: l_trx_line_array.extended_amount(i));
5761: arp_util.debug(' original revenue_amount = ' ||

Line 5759: arp_util.debug(' original extended_amount = ' ||

5755: THEN
5756: arp_util.debug('Inclusive tax, adjusting extended/revenue amounts');
5757: arp_util.debug('customer_trx_line_id = ' ||
5758: l_trx_line_array.customer_trx_line_id(i));
5759: arp_util.debug(' original extended_amount = ' ||
5760: l_trx_line_array.extended_amount(i));
5761: arp_util.debug(' original revenue_amount = ' ||
5762: l_trx_line_array.revenue_amount(i));
5763: END IF;

Line 5761: arp_util.debug(' original revenue_amount = ' ||

5757: arp_util.debug('customer_trx_line_id = ' ||
5758: l_trx_line_array.customer_trx_line_id(i));
5759: arp_util.debug(' original extended_amount = ' ||
5760: l_trx_line_array.extended_amount(i));
5761: arp_util.debug(' original revenue_amount = ' ||
5762: l_trx_line_array.revenue_amount(i));
5763: END IF;
5764:
5765: l_trx_line_array.extended_amount(i) :=

Line 5779: arp_util.debug(' new extended_amount = ' ||

5775: l_trx_line_array.original_revenue_amount(i)), p_currency_code);
5776:
5777: IF PG_DEBUG = 'Y'
5778: THEN
5779: arp_util.debug(' new extended_amount = ' ||
5780: l_trx_line_array.extended_amount(i));
5781: arp_util.debug(' new revenue_amount = ' ||
5782: l_trx_line_array.revenue_amount(i));
5783: END IF;

Line 5781: arp_util.debug(' new revenue_amount = ' ||

5777: IF PG_DEBUG = 'Y'
5778: THEN
5779: arp_util.debug(' new extended_amount = ' ||
5780: l_trx_line_array.extended_amount(i));
5781: arp_util.debug(' new revenue_amount = ' ||
5782: l_trx_line_array.revenue_amount(i));
5783: END IF;
5784:
5785: END IF;

Line 5817: arp_util.debug('l_trx_line_array.customer_trx_line_id(i) '||l_trx_line_array.customer_trx_line_id(i));

5813: -- MVKOLLA - Added following debug messages as part of bug7113653
5814: IF PG_DEBUG in ('Y', 'C') THEN
5815: i := l_trx_line_array.customer_trx_line_id.FIRST;
5816: WHILE l_trx_line_array.customer_trx_line_id.EXISTS(i) LOOP
5817: arp_util.debug('l_trx_line_array.customer_trx_line_id(i) '||l_trx_line_array.customer_trx_line_id(i));
5818: arp_util.debug('l_trx_line_array.previous_customer_trx_line_id(i) '||l_trx_line_array.previous_customer_trx_line_id(i));
5819: arp_util.debug('l_trx_line_array.extended_amount(i) '||l_trx_line_array.extended_amount(i));
5820: arp_util.debug('l_trx_line_array.revenue_amount(i) '||l_trx_line_array.revenue_amount(i));
5821: i := l_trx_line_array.customer_trx_line_id.NEXT(i);

Line 5818: arp_util.debug('l_trx_line_array.previous_customer_trx_line_id(i) '||l_trx_line_array.previous_customer_trx_line_id(i));

5814: IF PG_DEBUG in ('Y', 'C') THEN
5815: i := l_trx_line_array.customer_trx_line_id.FIRST;
5816: WHILE l_trx_line_array.customer_trx_line_id.EXISTS(i) LOOP
5817: arp_util.debug('l_trx_line_array.customer_trx_line_id(i) '||l_trx_line_array.customer_trx_line_id(i));
5818: arp_util.debug('l_trx_line_array.previous_customer_trx_line_id(i) '||l_trx_line_array.previous_customer_trx_line_id(i));
5819: arp_util.debug('l_trx_line_array.extended_amount(i) '||l_trx_line_array.extended_amount(i));
5820: arp_util.debug('l_trx_line_array.revenue_amount(i) '||l_trx_line_array.revenue_amount(i));
5821: i := l_trx_line_array.customer_trx_line_id.NEXT(i);
5822: END LOOP;

Line 5819: arp_util.debug('l_trx_line_array.extended_amount(i) '||l_trx_line_array.extended_amount(i));

5815: i := l_trx_line_array.customer_trx_line_id.FIRST;
5816: WHILE l_trx_line_array.customer_trx_line_id.EXISTS(i) LOOP
5817: arp_util.debug('l_trx_line_array.customer_trx_line_id(i) '||l_trx_line_array.customer_trx_line_id(i));
5818: arp_util.debug('l_trx_line_array.previous_customer_trx_line_id(i) '||l_trx_line_array.previous_customer_trx_line_id(i));
5819: arp_util.debug('l_trx_line_array.extended_amount(i) '||l_trx_line_array.extended_amount(i));
5820: arp_util.debug('l_trx_line_array.revenue_amount(i) '||l_trx_line_array.revenue_amount(i));
5821: i := l_trx_line_array.customer_trx_line_id.NEXT(i);
5822: END LOOP;
5823: END IF;

Line 5820: arp_util.debug('l_trx_line_array.revenue_amount(i) '||l_trx_line_array.revenue_amount(i));

5816: WHILE l_trx_line_array.customer_trx_line_id.EXISTS(i) LOOP
5817: arp_util.debug('l_trx_line_array.customer_trx_line_id(i) '||l_trx_line_array.customer_trx_line_id(i));
5818: arp_util.debug('l_trx_line_array.previous_customer_trx_line_id(i) '||l_trx_line_array.previous_customer_trx_line_id(i));
5819: arp_util.debug('l_trx_line_array.extended_amount(i) '||l_trx_line_array.extended_amount(i));
5820: arp_util.debug('l_trx_line_array.revenue_amount(i) '||l_trx_line_array.revenue_amount(i));
5821: i := l_trx_line_array.customer_trx_line_id.NEXT(i);
5822: END LOOP;
5823: END IF;
5824:

Line 5972: arp_util.debug( 'i = ' || i);

5968:
5969: /* Bug Number 6790882 */
5970:
5971: IF PG_DEBUG in ('Y', 'C') THEN
5972: arp_util.debug( 'i = ' || i);
5973: arp_util.debug( 'l_rows_inserted = ' || l_rows_inserted);
5974: arp_util.debug( 'l_mode = ' || l_mode);
5975: END IF;
5976:

Line 5973: arp_util.debug( 'l_rows_inserted = ' || l_rows_inserted);

5969: /* Bug Number 6790882 */
5970:
5971: IF PG_DEBUG in ('Y', 'C') THEN
5972: arp_util.debug( 'i = ' || i);
5973: arp_util.debug( 'l_rows_inserted = ' || l_rows_inserted);
5974: arp_util.debug( 'l_mode = ' || l_mode);
5975: END IF;
5976:
5977: IF l_mode = 'INSERT_NO_LINE' THEN

Line 5974: arp_util.debug( 'l_mode = ' || l_mode);

5970:
5971: IF PG_DEBUG in ('Y', 'C') THEN
5972: arp_util.debug( 'i = ' || i);
5973: arp_util.debug( 'l_rows_inserted = ' || l_rows_inserted);
5974: arp_util.debug( 'l_mode = ' || l_mode);
5975: END IF;
5976:
5977: IF l_mode = 'INSERT_NO_LINE' THEN
5978: IF i = l_rows_inserted THEN

Line 5995: arp_util.debug( 'l_total_tax_prorate = ' || l_total_tax_prorate);

5991: l_tax_amount := p_tax_amount;
5992: END IF;
5993:
5994: IF PG_DEBUG in ('Y', 'C') THEN
5995: arp_util.debug( 'l_total_tax_prorate = ' || l_total_tax_prorate);
5996: arp_util.debug( 'l_tax_amount = ' || l_tax_amount);
5997: END IF;
5998:
5999: ARP_ETAX_SERVICES_PKG.line_det_factors(

Line 5996: arp_util.debug( 'l_tax_amount = ' || l_tax_amount);

5992: END IF;
5993:
5994: IF PG_DEBUG in ('Y', 'C') THEN
5995: arp_util.debug( 'l_total_tax_prorate = ' || l_total_tax_prorate);
5996: arp_util.debug( 'l_tax_amount = ' || l_tax_amount);
5997: END IF;
5998:
5999: ARP_ETAX_SERVICES_PKG.line_det_factors(
6000: p_customer_trx_line_id => l_trx_line_array.customer_trx_line_id(i),

Line 6014: arp_util.debug( 'arp_ctl_pkg.insert_line_f_cm_ct_ctl_id : '||

6010: --}
6011:
6012:
6013: IF PG_DEBUG in ('Y', 'C') THEN
6014: arp_util.debug( 'arp_ctl_pkg.insert_line_f_cm_ct_ctl_id : '||
6015: to_char(l_rows_inserted)||' rows inserted');
6016: END IF;
6017:
6018: /* Bug 3658284 - Remove the entire rounding update statement */

Line 6021: arp_util.debug( 'arp_ctl_pkg.insert_line_f_cm_ct_ctl_id()-');

6017:
6018: /* Bug 3658284 - Remove the entire rounding update statement */
6019:
6020: IF PG_DEBUG in ('Y', 'C') THEN
6021: arp_util.debug( 'arp_ctl_pkg.insert_line_f_cm_ct_ctl_id()-');
6022: END IF;
6023:
6024: EXCEPTION
6025: WHEN NO_DATA_FOUND THEN

Line 6029: arp_util.debug( 'EXCEPTION: arp_ctl_pkg.insert_line_f_cm_ct_ctl_id');

6025: WHEN NO_DATA_FOUND THEN
6026: return;
6027: WHEN OTHERS THEN
6028: IF PG_DEBUG in ('Y', 'C') THEN
6029: arp_util.debug( 'EXCEPTION: arp_ctl_pkg.insert_line_f_cm_ct_ctl_id');
6030: arp_util.debug( '');
6031: arp_util.debug( 'p_customer_trx_id = '||p_customer_trx_id);
6032: arp_util.debug( 'p_customer_trx_line_id = '||p_customer_trx_line_id);
6033: arp_util.debug( 'p_prev_customer_trx_id = '||p_prev_customer_trx_id);

Line 6030: arp_util.debug( '');

6026: return;
6027: WHEN OTHERS THEN
6028: IF PG_DEBUG in ('Y', 'C') THEN
6029: arp_util.debug( 'EXCEPTION: arp_ctl_pkg.insert_line_f_cm_ct_ctl_id');
6030: arp_util.debug( '');
6031: arp_util.debug( 'p_customer_trx_id = '||p_customer_trx_id);
6032: arp_util.debug( 'p_customer_trx_line_id = '||p_customer_trx_line_id);
6033: arp_util.debug( 'p_prev_customer_trx_id = '||p_prev_customer_trx_id);
6034: arp_util.debug( 'p_line_type = '||p_line_type);

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

6027: WHEN OTHERS THEN
6028: IF PG_DEBUG in ('Y', 'C') THEN
6029: arp_util.debug( 'EXCEPTION: arp_ctl_pkg.insert_line_f_cm_ct_ctl_id');
6030: arp_util.debug( '');
6031: arp_util.debug( 'p_customer_trx_id = '||p_customer_trx_id);
6032: arp_util.debug( 'p_customer_trx_line_id = '||p_customer_trx_line_id);
6033: arp_util.debug( 'p_prev_customer_trx_id = '||p_prev_customer_trx_id);
6034: arp_util.debug( 'p_line_type = '||p_line_type);
6035: arp_util.debug( 'p_uncredited_amount = '||p_uncredited_amount);

Line 6032: arp_util.debug( 'p_customer_trx_line_id = '||p_customer_trx_line_id);

6028: IF PG_DEBUG in ('Y', 'C') THEN
6029: arp_util.debug( 'EXCEPTION: arp_ctl_pkg.insert_line_f_cm_ct_ctl_id');
6030: arp_util.debug( '');
6031: arp_util.debug( 'p_customer_trx_id = '||p_customer_trx_id);
6032: arp_util.debug( 'p_customer_trx_line_id = '||p_customer_trx_line_id);
6033: arp_util.debug( 'p_prev_customer_trx_id = '||p_prev_customer_trx_id);
6034: arp_util.debug( 'p_line_type = '||p_line_type);
6035: arp_util.debug( 'p_uncredited_amount = '||p_uncredited_amount);
6036: arp_util.debug( 'p_credit_amount = '||p_credit_amount);

Line 6033: arp_util.debug( 'p_prev_customer_trx_id = '||p_prev_customer_trx_id);

6029: arp_util.debug( 'EXCEPTION: arp_ctl_pkg.insert_line_f_cm_ct_ctl_id');
6030: arp_util.debug( '');
6031: arp_util.debug( 'p_customer_trx_id = '||p_customer_trx_id);
6032: arp_util.debug( 'p_customer_trx_line_id = '||p_customer_trx_line_id);
6033: arp_util.debug( 'p_prev_customer_trx_id = '||p_prev_customer_trx_id);
6034: arp_util.debug( 'p_line_type = '||p_line_type);
6035: arp_util.debug( 'p_uncredited_amount = '||p_uncredited_amount);
6036: arp_util.debug( 'p_credit_amount = '||p_credit_amount);
6037: arp_util.debug( 'p_currency_code = '||p_currency_code);

Line 6034: arp_util.debug( 'p_line_type = '||p_line_type);

6030: arp_util.debug( '');
6031: arp_util.debug( 'p_customer_trx_id = '||p_customer_trx_id);
6032: arp_util.debug( 'p_customer_trx_line_id = '||p_customer_trx_line_id);
6033: arp_util.debug( 'p_prev_customer_trx_id = '||p_prev_customer_trx_id);
6034: arp_util.debug( 'p_line_type = '||p_line_type);
6035: arp_util.debug( 'p_uncredited_amount = '||p_uncredited_amount);
6036: arp_util.debug( 'p_credit_amount = '||p_credit_amount);
6037: arp_util.debug( 'p_currency_code = '||p_currency_code);
6038: END IF;

Line 6035: arp_util.debug( 'p_uncredited_amount = '||p_uncredited_amount);

6031: arp_util.debug( 'p_customer_trx_id = '||p_customer_trx_id);
6032: arp_util.debug( 'p_customer_trx_line_id = '||p_customer_trx_line_id);
6033: arp_util.debug( 'p_prev_customer_trx_id = '||p_prev_customer_trx_id);
6034: arp_util.debug( 'p_line_type = '||p_line_type);
6035: arp_util.debug( 'p_uncredited_amount = '||p_uncredited_amount);
6036: arp_util.debug( 'p_credit_amount = '||p_credit_amount);
6037: arp_util.debug( 'p_currency_code = '||p_currency_code);
6038: END IF;
6039: RAISE;

Line 6036: arp_util.debug( 'p_credit_amount = '||p_credit_amount);

6032: arp_util.debug( 'p_customer_trx_line_id = '||p_customer_trx_line_id);
6033: arp_util.debug( 'p_prev_customer_trx_id = '||p_prev_customer_trx_id);
6034: arp_util.debug( 'p_line_type = '||p_line_type);
6035: arp_util.debug( 'p_uncredited_amount = '||p_uncredited_amount);
6036: arp_util.debug( 'p_credit_amount = '||p_credit_amount);
6037: arp_util.debug( 'p_currency_code = '||p_currency_code);
6038: END IF;
6039: RAISE;
6040:

Line 6037: arp_util.debug( 'p_currency_code = '||p_currency_code);

6033: arp_util.debug( 'p_prev_customer_trx_id = '||p_prev_customer_trx_id);
6034: arp_util.debug( 'p_line_type = '||p_line_type);
6035: arp_util.debug( 'p_uncredited_amount = '||p_uncredited_amount);
6036: arp_util.debug( 'p_credit_amount = '||p_credit_amount);
6037: arp_util.debug( 'p_currency_code = '||p_currency_code);
6038: END IF;
6039: RAISE;
6040:
6041: END;

Line 6054: | arp_util.debug |

6050: | |
6051: | SCOPE - PUBLIC |
6052: | |
6053: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
6054: | arp_util.debug |
6055: | |
6056: | ARGUMENTS : IN: |
6057: | None |
6058: | OUT: |

Line 6085: arp_util.debug( 'arp_ctl_pkg.update_line_f_cm_ctl_id()+');

6081: --}
6082: BEGIN
6083:
6084: IF PG_DEBUG in ('Y', 'C') THEN
6085: arp_util.debug( 'arp_ctl_pkg.update_line_f_cm_ctl_id()+');
6086: END IF;
6087:
6088: UPDATE ra_customer_trx_lines ctl
6089: SET extended_amount =

Line 6114: arp_util.debug( 'arp_ctl_pkg.update_line_f_cm_ctl_id : '||

6110: BULK COLLECT INTO l_ctl_key_list;
6111: --}
6112:
6113: IF PG_DEBUG in ('Y', 'C') THEN
6114: arp_util.debug( 'arp_ctl_pkg.update_line_f_cm_ctl_id : '||
6115: 'Extended Amount :'|| SQL%ROWCOUNT||' rows updated');
6116: END IF;
6117:
6118: UPDATE ra_customer_trx_lines ctl

Line 6130: arp_util.debug( 'arp_ctl_pkg.update_line_f_cm_ctl_id : '||

6126: BULK COLLECT INTO l_ctl_key_list;
6127: --}
6128:
6129: IF PG_DEBUG in ('Y', 'C') THEN
6130: arp_util.debug( 'arp_ctl_pkg.update_line_f_cm_ctl_id : '||
6131: 'Currency Rounding :'|| SQL%ROWCOUNT||' rows updated');
6132: END IF;
6133:
6134: /*----------------------------+

Line 6167: arp_util.debug( 'arp_ctl_pkg.update_line_f_cm_ctl_id()-');

6163:
6164: END IF;
6165:
6166: IF PG_DEBUG in ('Y', 'C') THEN
6167: arp_util.debug( 'arp_ctl_pkg.update_line_f_cm_ctl_id()-');
6168: END IF;
6169:
6170: EXCEPTION
6171: WHEN NO_DATA_FOUND THEN

Line 6175: arp_util.debug( 'EXCEPTION: arp_ctl_pkg.update_line_f_cm_ctl_id');

6171: WHEN NO_DATA_FOUND THEN
6172: return;
6173: WHEN OTHERS THEN
6174: IF PG_DEBUG in ('Y', 'C') THEN
6175: arp_util.debug( 'EXCEPTION: arp_ctl_pkg.update_line_f_cm_ctl_id');
6176: arp_util.debug( '');
6177: arp_util.debug( 'p_customer_trx_id = '||p_customer_trx_id);
6178: arp_util.debug( 'p_customer_trx_line_id = '||p_customer_trx_line_id);
6179: arp_util.debug( 'p_prev_customer_trx_id = '||p_prev_customer_trx_id);

Line 6176: arp_util.debug( '');

6172: return;
6173: WHEN OTHERS THEN
6174: IF PG_DEBUG in ('Y', 'C') THEN
6175: arp_util.debug( 'EXCEPTION: arp_ctl_pkg.update_line_f_cm_ctl_id');
6176: arp_util.debug( '');
6177: arp_util.debug( 'p_customer_trx_id = '||p_customer_trx_id);
6178: arp_util.debug( 'p_customer_trx_line_id = '||p_customer_trx_line_id);
6179: arp_util.debug( 'p_prev_customer_trx_id = '||p_prev_customer_trx_id);
6180: arp_util.debug( 'p_line_type = '||p_line_type);

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

6173: WHEN OTHERS THEN
6174: IF PG_DEBUG in ('Y', 'C') THEN
6175: arp_util.debug( 'EXCEPTION: arp_ctl_pkg.update_line_f_cm_ctl_id');
6176: arp_util.debug( '');
6177: arp_util.debug( 'p_customer_trx_id = '||p_customer_trx_id);
6178: arp_util.debug( 'p_customer_trx_line_id = '||p_customer_trx_line_id);
6179: arp_util.debug( 'p_prev_customer_trx_id = '||p_prev_customer_trx_id);
6180: arp_util.debug( 'p_line_type = '||p_line_type);
6181: arp_util.debug( 'p_uncredited_amount = '||p_uncredited_amount);

Line 6178: arp_util.debug( 'p_customer_trx_line_id = '||p_customer_trx_line_id);

6174: IF PG_DEBUG in ('Y', 'C') THEN
6175: arp_util.debug( 'EXCEPTION: arp_ctl_pkg.update_line_f_cm_ctl_id');
6176: arp_util.debug( '');
6177: arp_util.debug( 'p_customer_trx_id = '||p_customer_trx_id);
6178: arp_util.debug( 'p_customer_trx_line_id = '||p_customer_trx_line_id);
6179: arp_util.debug( 'p_prev_customer_trx_id = '||p_prev_customer_trx_id);
6180: arp_util.debug( 'p_line_type = '||p_line_type);
6181: arp_util.debug( 'p_uncredited_amount = '||p_uncredited_amount);
6182: arp_util.debug( 'p_credit_amount = '||p_credit_amount);

Line 6179: arp_util.debug( 'p_prev_customer_trx_id = '||p_prev_customer_trx_id);

6175: arp_util.debug( 'EXCEPTION: arp_ctl_pkg.update_line_f_cm_ctl_id');
6176: arp_util.debug( '');
6177: arp_util.debug( 'p_customer_trx_id = '||p_customer_trx_id);
6178: arp_util.debug( 'p_customer_trx_line_id = '||p_customer_trx_line_id);
6179: arp_util.debug( 'p_prev_customer_trx_id = '||p_prev_customer_trx_id);
6180: arp_util.debug( 'p_line_type = '||p_line_type);
6181: arp_util.debug( 'p_uncredited_amount = '||p_uncredited_amount);
6182: arp_util.debug( 'p_credit_amount = '||p_credit_amount);
6183: arp_util.debug( 'p_currency_code = '||p_currency_code);

Line 6180: arp_util.debug( 'p_line_type = '||p_line_type);

6176: arp_util.debug( '');
6177: arp_util.debug( 'p_customer_trx_id = '||p_customer_trx_id);
6178: arp_util.debug( 'p_customer_trx_line_id = '||p_customer_trx_line_id);
6179: arp_util.debug( 'p_prev_customer_trx_id = '||p_prev_customer_trx_id);
6180: arp_util.debug( 'p_line_type = '||p_line_type);
6181: arp_util.debug( 'p_uncredited_amount = '||p_uncredited_amount);
6182: arp_util.debug( 'p_credit_amount = '||p_credit_amount);
6183: arp_util.debug( 'p_currency_code = '||p_currency_code);
6184: END IF;

Line 6181: arp_util.debug( 'p_uncredited_amount = '||p_uncredited_amount);

6177: arp_util.debug( 'p_customer_trx_id = '||p_customer_trx_id);
6178: arp_util.debug( 'p_customer_trx_line_id = '||p_customer_trx_line_id);
6179: arp_util.debug( 'p_prev_customer_trx_id = '||p_prev_customer_trx_id);
6180: arp_util.debug( 'p_line_type = '||p_line_type);
6181: arp_util.debug( 'p_uncredited_amount = '||p_uncredited_amount);
6182: arp_util.debug( 'p_credit_amount = '||p_credit_amount);
6183: arp_util.debug( 'p_currency_code = '||p_currency_code);
6184: END IF;
6185: RAISE;

Line 6182: arp_util.debug( 'p_credit_amount = '||p_credit_amount);

6178: arp_util.debug( 'p_customer_trx_line_id = '||p_customer_trx_line_id);
6179: arp_util.debug( 'p_prev_customer_trx_id = '||p_prev_customer_trx_id);
6180: arp_util.debug( 'p_line_type = '||p_line_type);
6181: arp_util.debug( 'p_uncredited_amount = '||p_uncredited_amount);
6182: arp_util.debug( 'p_credit_amount = '||p_credit_amount);
6183: arp_util.debug( 'p_currency_code = '||p_currency_code);
6184: END IF;
6185: RAISE;
6186:

Line 6183: arp_util.debug( 'p_currency_code = '||p_currency_code);

6179: arp_util.debug( 'p_prev_customer_trx_id = '||p_prev_customer_trx_id);
6180: arp_util.debug( 'p_line_type = '||p_line_type);
6181: arp_util.debug( 'p_uncredited_amount = '||p_uncredited_amount);
6182: arp_util.debug( 'p_credit_amount = '||p_credit_amount);
6183: arp_util.debug( 'p_currency_code = '||p_currency_code);
6184: END IF;
6185: RAISE;
6186:
6187: END;

Line 6200: | arp_util.debug |

6196: | |
6197: | SCOPE - PUBLIC |
6198: | |
6199: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
6200: | arp_util.debug |
6201: | |
6202: | ARGUMENTS : IN: |
6203: | None |
6204: | OUT: |

Line 6220: --- arp_util.debug('arp_ctl_pkg.get_text_dummy()+');

6216: FUNCTION get_text_dummy(p_null IN NUMBER DEFAULT null) RETURN varchar2 IS
6217:
6218: BEGIN
6219:
6220: --- arp_util.debug('arp_ctl_pkg.get_text_dummy()+');
6221:
6222: --- arp_util.debug('arp_ctl_pkg.get_text_dummy()-');
6223:
6224: return(AR_TEXT_DUMMY);

Line 6222: --- arp_util.debug('arp_ctl_pkg.get_text_dummy()-');

6218: BEGIN
6219:
6220: --- arp_util.debug('arp_ctl_pkg.get_text_dummy()+');
6221:
6222: --- arp_util.debug('arp_ctl_pkg.get_text_dummy()-');
6223:
6224: return(AR_TEXT_DUMMY);
6225:
6226: EXCEPTION

Line 6229: arp_util.debug( 'EXCEPTION: arp_ctl_pkg.get_text_dummy()');

6225:
6226: EXCEPTION
6227: WHEN OTHERS THEN
6228: IF PG_DEBUG in ('Y', 'C') THEN
6229: arp_util.debug( 'EXCEPTION: arp_ctl_pkg.get_text_dummy()');
6230: END IF;
6231: RAISE;
6232:
6233: END;

Line 6245: | arp_util.debug |

6241: | |
6242: | SCOPE - PUBLIC |
6243: | |
6244: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
6245: | arp_util.debug |
6246: | |
6247: | ARGUMENTS : IN: |
6248: | None |
6249: | OUT: |

Line 6265: --- arp_util.debug('arp_ctl_pkg.get_number_dummy()+');

6261: FUNCTION get_number_dummy(p_null IN NUMBER DEFAULT null) RETURN number IS
6262:
6263: BEGIN
6264:
6265: --- arp_util.debug('arp_ctl_pkg.get_number_dummy()+');
6266:
6267: --- arp_util.debug('arp_ctl_pkg.get_number_dummy()-');
6268:
6269: return(AR_NUMBER_DUMMY);

Line 6267: --- arp_util.debug('arp_ctl_pkg.get_number_dummy()-');

6263: BEGIN
6264:
6265: --- arp_util.debug('arp_ctl_pkg.get_number_dummy()+');
6266:
6267: --- arp_util.debug('arp_ctl_pkg.get_number_dummy()-');
6268:
6269: return(AR_NUMBER_DUMMY);
6270:
6271: EXCEPTION

Line 6274: arp_util.debug( 'EXCEPTION: arp_ctl_pkg.get_number_dummy()');

6270:
6271: EXCEPTION
6272: WHEN OTHERS THEN
6273: IF PG_DEBUG in ('Y', 'C') THEN
6274: arp_util.debug( 'EXCEPTION: arp_ctl_pkg.get_number_dummy()');
6275: END IF;
6276: RAISE;
6277:
6278: END;