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 3262: arp_util.debug( 'arp_ctl_pkg.delete_f_ct_id()+');

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

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

3265: DELETE FROM ra_customer_trx_lines
3266: WHERE customer_trx_id = p_customer_trx_id;
3267:
3268: IF PG_DEBUG in ('Y', 'C') THEN
3269: arp_util.debug( 'arp_ctl_pkg.delete_f_ct_id()-');
3270: END IF;
3271:
3272: EXCEPTION
3273: WHEN OTHERS THEN

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

3271:
3272: EXCEPTION
3273: WHEN OTHERS THEN
3274: IF PG_DEBUG in ('Y', 'C') THEN
3275: arp_util.debug( 'EXCEPTION: arp_ctl_pkg.delete_f_ct_id()');
3276: arp_util.debug( '');
3277: arp_util.debug( '-------- parameters for delete_f_ct_id() ------');
3278: arp_util.debug( 'p_customer_trx_id = ' ||
3279: p_customer_trx_id);

Line 3276: arp_util.debug( '');

3272: EXCEPTION
3273: WHEN OTHERS THEN
3274: IF PG_DEBUG in ('Y', 'C') THEN
3275: arp_util.debug( 'EXCEPTION: arp_ctl_pkg.delete_f_ct_id()');
3276: arp_util.debug( '');
3277: arp_util.debug( '-------- parameters for delete_f_ct_id() ------');
3278: arp_util.debug( 'p_customer_trx_id = ' ||
3279: p_customer_trx_id);
3280: END IF;

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

3273: WHEN OTHERS THEN
3274: IF PG_DEBUG in ('Y', 'C') THEN
3275: arp_util.debug( 'EXCEPTION: arp_ctl_pkg.delete_f_ct_id()');
3276: arp_util.debug( '');
3277: arp_util.debug( '-------- parameters for delete_f_ct_id() ------');
3278: arp_util.debug( 'p_customer_trx_id = ' ||
3279: p_customer_trx_id);
3280: END IF;
3281:

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

3274: IF PG_DEBUG in ('Y', 'C') THEN
3275: arp_util.debug( 'EXCEPTION: arp_ctl_pkg.delete_f_ct_id()');
3276: arp_util.debug( '');
3277: arp_util.debug( '-------- parameters for delete_f_ct_id() ------');
3278: arp_util.debug( 'p_customer_trx_id = ' ||
3279: p_customer_trx_id);
3280: END IF;
3281:
3282: RAISE;

Line 3298: | arp_util.debug |

3294: | |
3295: | SCOPE - PUBLIC |
3296: | |
3297: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
3298: | arp_util.debug |
3299: | |
3300: | ARGUMENTS : IN: |
3301: | p_link_to_cust_trx_line_id - identifies the rows to delete |
3302: | OUT: |

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

3318: BEGIN
3319:
3320:
3321: IF PG_DEBUG in ('Y', 'C') THEN
3322: arp_util.debug( 'arp_ctl_pkg.delete_f_ltctl_id()+');
3323: END IF;
3324:
3325: DELETE FROM ra_customer_trx_lines
3326: WHERE link_to_cust_trx_line_id = p_link_to_cust_trx_line_id;

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

3325: DELETE FROM ra_customer_trx_lines
3326: WHERE link_to_cust_trx_line_id = p_link_to_cust_trx_line_id;
3327:
3328: IF PG_DEBUG in ('Y', 'C') THEN
3329: arp_util.debug( 'arp_ctl_pkg.delete_f_ltctl_id()-');
3330: END IF;
3331:
3332: EXCEPTION
3333: WHEN OTHERS THEN

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

3331:
3332: EXCEPTION
3333: WHEN OTHERS THEN
3334: IF PG_DEBUG in ('Y', 'C') THEN
3335: arp_util.debug( 'EXCEPTION: arp_ctl_pkg.delete_f_ltctl_id()');
3336: arp_util.debug( '');
3337: arp_util.debug( '-------- parameters for delete_f_ltctl_id() ------');
3338: arp_util.debug( 'p_link_to_cust_trx_line_id = ' ||
3339: p_link_to_cust_trx_line_id);

Line 3336: arp_util.debug( '');

3332: EXCEPTION
3333: WHEN OTHERS THEN
3334: IF PG_DEBUG in ('Y', 'C') THEN
3335: arp_util.debug( 'EXCEPTION: arp_ctl_pkg.delete_f_ltctl_id()');
3336: arp_util.debug( '');
3337: arp_util.debug( '-------- parameters for delete_f_ltctl_id() ------');
3338: arp_util.debug( 'p_link_to_cust_trx_line_id = ' ||
3339: p_link_to_cust_trx_line_id);
3340: END IF;

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

3333: WHEN OTHERS THEN
3334: IF PG_DEBUG in ('Y', 'C') THEN
3335: arp_util.debug( 'EXCEPTION: arp_ctl_pkg.delete_f_ltctl_id()');
3336: arp_util.debug( '');
3337: arp_util.debug( '-------- parameters for delete_f_ltctl_id() ------');
3338: arp_util.debug( 'p_link_to_cust_trx_line_id = ' ||
3339: p_link_to_cust_trx_line_id);
3340: END IF;
3341:

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

3334: IF PG_DEBUG in ('Y', 'C') THEN
3335: arp_util.debug( 'EXCEPTION: arp_ctl_pkg.delete_f_ltctl_id()');
3336: arp_util.debug( '');
3337: arp_util.debug( '-------- parameters for delete_f_ltctl_id() ------');
3338: arp_util.debug( 'p_link_to_cust_trx_line_id = ' ||
3339: p_link_to_cust_trx_line_id);
3340: END IF;
3341:
3342: RAISE;

Line 3357: | arp_util.debug |

3353: | |
3354: | SCOPE - PUBLIC |
3355: | |
3356: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
3357: | arp_util.debug |
3358: | |
3359: | ARGUMENTS : IN: |
3360: | p_customer_trx_id - identifies the transaction |
3361: | p_link_to_cust_trx_line_id - identifies the parent line |

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

3385:
3386: BEGIN
3387:
3388: IF PG_DEBUG in ('Y', 'C') THEN
3389: arp_util.debug( 'arp_ctl_pkg.delete_f_ct_ltctl_id_type()+');
3390: END IF;
3391:
3392: DELETE FROM ra_customer_trx_lines
3393: WHERE customer_trx_id = p_customer_trx_id

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

3396: customer_trx_line_id) = nvl(p_link_to_cust_trx_line_id, -99)
3397: AND line_type = nvl(p_line_type, line_type);
3398:
3399: IF PG_DEBUG in ('Y', 'C') THEN
3400: arp_util.debug( 'arp_ctl_pkg.delete_f_ct_ltctl_id_type()-');
3401: END IF;
3402:
3403: EXCEPTION
3404: WHEN OTHERS THEN

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

3402:
3403: EXCEPTION
3404: WHEN OTHERS THEN
3405: IF PG_DEBUG in ('Y', 'C') THEN
3406: arp_util.debug( 'EXCEPTION: arp_ctl_pkg.delete_f_ct_ltctl_id_type()');
3407: arp_util.debug( '');
3408: arp_util.debug( '---- parameters for delete_f_ct_ltctl_id_type() -----');
3409: arp_util.debug( 'p_customer_trx_id = ' || p_customer_trx_id);
3410: arp_util.debug( 'p_link_to_cust_trx_line_id = ' ||

Line 3407: arp_util.debug( '');

3403: EXCEPTION
3404: WHEN OTHERS THEN
3405: IF PG_DEBUG in ('Y', 'C') THEN
3406: arp_util.debug( 'EXCEPTION: arp_ctl_pkg.delete_f_ct_ltctl_id_type()');
3407: arp_util.debug( '');
3408: arp_util.debug( '---- parameters for delete_f_ct_ltctl_id_type() -----');
3409: arp_util.debug( 'p_customer_trx_id = ' || p_customer_trx_id);
3410: arp_util.debug( 'p_link_to_cust_trx_line_id = ' ||
3411: p_link_to_cust_trx_line_id);

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

3404: WHEN OTHERS THEN
3405: IF PG_DEBUG in ('Y', 'C') THEN
3406: arp_util.debug( 'EXCEPTION: arp_ctl_pkg.delete_f_ct_ltctl_id_type()');
3407: arp_util.debug( '');
3408: arp_util.debug( '---- parameters for delete_f_ct_ltctl_id_type() -----');
3409: arp_util.debug( 'p_customer_trx_id = ' || p_customer_trx_id);
3410: arp_util.debug( 'p_link_to_cust_trx_line_id = ' ||
3411: p_link_to_cust_trx_line_id);
3412: arp_util.debug( 'p_line_type = ' || p_line_type);

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

3405: IF PG_DEBUG in ('Y', 'C') THEN
3406: arp_util.debug( 'EXCEPTION: arp_ctl_pkg.delete_f_ct_ltctl_id_type()');
3407: arp_util.debug( '');
3408: arp_util.debug( '---- parameters for delete_f_ct_ltctl_id_type() -----');
3409: arp_util.debug( 'p_customer_trx_id = ' || p_customer_trx_id);
3410: arp_util.debug( 'p_link_to_cust_trx_line_id = ' ||
3411: p_link_to_cust_trx_line_id);
3412: arp_util.debug( 'p_line_type = ' || p_line_type);
3413: END IF;

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

3406: arp_util.debug( 'EXCEPTION: arp_ctl_pkg.delete_f_ct_ltctl_id_type()');
3407: arp_util.debug( '');
3408: arp_util.debug( '---- parameters for delete_f_ct_ltctl_id_type() -----');
3409: arp_util.debug( 'p_customer_trx_id = ' || p_customer_trx_id);
3410: arp_util.debug( 'p_link_to_cust_trx_line_id = ' ||
3411: p_link_to_cust_trx_line_id);
3412: arp_util.debug( 'p_line_type = ' || p_line_type);
3413: END IF;
3414:

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

3408: arp_util.debug( '---- parameters for delete_f_ct_ltctl_id_type() -----');
3409: arp_util.debug( 'p_customer_trx_id = ' || p_customer_trx_id);
3410: arp_util.debug( 'p_link_to_cust_trx_line_id = ' ||
3411: p_link_to_cust_trx_line_id);
3412: arp_util.debug( 'p_line_type = ' || p_line_type);
3413: END IF;
3414:
3415: RAISE;
3416: END;

Line 3430: | arp_util.debug |

3426: | |
3427: | SCOPE - PUBLIC |
3428: | |
3429: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
3430: | arp_util.debug |
3431: | |
3432: | ARGUMENTS : IN: |
3433: | p_customer_trx_line_id - identifies the row to update |
3434: | p_line_rec - contains the new column values |

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

3457:
3458: BEGIN
3459:
3460: IF PG_DEBUG in ('Y', 'C') THEN
3461: arp_util.debug( 'arp_ctl_pkg.update_p()+ ' ||
3462: to_char(sysdate, 'HH:MI:SS'));
3463: END IF;
3464:
3465: /*---------------------------------------------------------------+

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

3477: ELSE l_currency_code := p_currency_code;
3478: END IF;
3479:
3480: IF PG_DEBUG in ('Y', 'C') THEN
3481: arp_util.debug( 'using currency code: ' || l_currency_code );
3482: END IF;
3483:
3484: arp_ctl_pkg.generic_update( pg_cursor1,
3485: ' WHERE customer_trx_line_id = :where_1 ' ||

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

3489: l_currency_code,
3490: p_line_rec);
3491:
3492: IF PG_DEBUG in ('Y', 'C') THEN
3493: arp_util.debug( 'arp_ctl_pkg.update_p()- ' ||
3494: to_char(sysdate, 'HH:MI:SS'));
3495: END IF;
3496:
3497:

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

3497:
3498: EXCEPTION
3499: WHEN OTHERS THEN
3500: IF PG_DEBUG in ('Y', 'C') THEN
3501: arp_util.debug( 'EXCEPTION: arp_ctl_pkg.update_p()');
3502: arp_util.debug( '');
3503: arp_util.debug( '-------- parameters for update_p() ------');
3504: arp_util.debug( 'p_customer_trx_line_id = ' ||
3505: p_customer_trx_line_id);

Line 3502: arp_util.debug( '');

3498: EXCEPTION
3499: WHEN OTHERS THEN
3500: IF PG_DEBUG in ('Y', 'C') THEN
3501: arp_util.debug( 'EXCEPTION: arp_ctl_pkg.update_p()');
3502: arp_util.debug( '');
3503: arp_util.debug( '-------- parameters for update_p() ------');
3504: arp_util.debug( 'p_customer_trx_line_id = ' ||
3505: p_customer_trx_line_id);
3506: arp_util.debug( 'p_currency_code = ' || p_currency_code);

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

3499: WHEN OTHERS THEN
3500: IF PG_DEBUG in ('Y', 'C') THEN
3501: arp_util.debug( 'EXCEPTION: arp_ctl_pkg.update_p()');
3502: arp_util.debug( '');
3503: arp_util.debug( '-------- parameters for update_p() ------');
3504: arp_util.debug( 'p_customer_trx_line_id = ' ||
3505: p_customer_trx_line_id);
3506: arp_util.debug( 'p_currency_code = ' || p_currency_code);
3507: END IF;

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

3500: IF PG_DEBUG in ('Y', 'C') THEN
3501: arp_util.debug( 'EXCEPTION: arp_ctl_pkg.update_p()');
3502: arp_util.debug( '');
3503: arp_util.debug( '-------- parameters for update_p() ------');
3504: arp_util.debug( 'p_customer_trx_line_id = ' ||
3505: p_customer_trx_line_id);
3506: arp_util.debug( 'p_currency_code = ' || p_currency_code);
3507: END IF;
3508: display_line_rec(p_line_rec);

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

3502: arp_util.debug( '');
3503: arp_util.debug( '-------- parameters for update_p() ------');
3504: arp_util.debug( 'p_customer_trx_line_id = ' ||
3505: p_customer_trx_line_id);
3506: arp_util.debug( 'p_currency_code = ' || p_currency_code);
3507: END IF;
3508: display_line_rec(p_line_rec);
3509:
3510: RAISE;

Line 3524: | arp_util.debug |

3520: | |
3521: | SCOPE - PUBLIC |
3522: | |
3523: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
3524: | arp_util.debug |
3525: | |
3526: | ARGUMENTS : IN: |
3527: | p_customer_trx_id - identifies the rows to update |
3528: | p_line_rec - contains the new column values |

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

3555:
3556: BEGIN
3557:
3558: IF PG_DEBUG in ('Y', 'C') THEN
3559: arp_util.debug( 'arp_ctl_pkg.update_f_ct_id()+ ' ||
3560: to_char(sysdate, 'HH:MI:SS'));
3561: END IF;
3562:
3563:

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

3575: ELSE l_currency_code := p_currency_code;
3576: END IF;
3577:
3578: IF PG_DEBUG in ('Y', 'C') THEN
3579: arp_util.debug( 'using currency code: ' || l_currency_code );
3580: END IF;
3581:
3582:
3583: l_where := ' WHERE customer_trx_id = :where_1 ' ||

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

3590: l_currency_code,
3591: p_line_rec);
3592:
3593: IF PG_DEBUG in ('Y', 'C') THEN
3594: arp_util.debug( 'arp_ctl_pkg.update_f_ct_id()- ' ||
3595: to_char(sysdate, 'HH:MI:SS'));
3596: END IF;
3597:
3598:

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

3598:
3599: EXCEPTION
3600: WHEN OTHERS THEN
3601: IF PG_DEBUG in ('Y', 'C') THEN
3602: arp_util.debug( 'EXCEPTION: arp_ctl_pkg.update_f_ct_id()');
3603: arp_util.debug( '');
3604: arp_util.debug( '-------- parameters for update_f_ct_id() ------');
3605: arp_util.debug( 'p_customer_trx_id = ' ||
3606: p_customer_trx_id);

Line 3603: arp_util.debug( '');

3599: EXCEPTION
3600: WHEN OTHERS THEN
3601: IF PG_DEBUG in ('Y', 'C') THEN
3602: arp_util.debug( 'EXCEPTION: arp_ctl_pkg.update_f_ct_id()');
3603: arp_util.debug( '');
3604: arp_util.debug( '-------- parameters for update_f_ct_id() ------');
3605: arp_util.debug( 'p_customer_trx_id = ' ||
3606: p_customer_trx_id);
3607: arp_util.debug( 'p_line_type = ' || p_line_type);

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

3600: WHEN OTHERS THEN
3601: IF PG_DEBUG in ('Y', 'C') THEN
3602: arp_util.debug( 'EXCEPTION: arp_ctl_pkg.update_f_ct_id()');
3603: arp_util.debug( '');
3604: arp_util.debug( '-------- parameters for update_f_ct_id() ------');
3605: arp_util.debug( 'p_customer_trx_id = ' ||
3606: p_customer_trx_id);
3607: arp_util.debug( 'p_line_type = ' || p_line_type);
3608: arp_util.debug( 'p_currency_code = ' || p_currency_code);

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

3601: IF PG_DEBUG in ('Y', 'C') THEN
3602: arp_util.debug( 'EXCEPTION: arp_ctl_pkg.update_f_ct_id()');
3603: arp_util.debug( '');
3604: arp_util.debug( '-------- parameters for update_f_ct_id() ------');
3605: arp_util.debug( 'p_customer_trx_id = ' ||
3606: p_customer_trx_id);
3607: arp_util.debug( 'p_line_type = ' || p_line_type);
3608: arp_util.debug( 'p_currency_code = ' || p_currency_code);
3609: END IF;

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

3603: arp_util.debug( '');
3604: arp_util.debug( '-------- parameters for update_f_ct_id() ------');
3605: arp_util.debug( 'p_customer_trx_id = ' ||
3606: p_customer_trx_id);
3607: arp_util.debug( 'p_line_type = ' || p_line_type);
3608: arp_util.debug( 'p_currency_code = ' || p_currency_code);
3609: END IF;
3610: display_line_rec(p_line_rec);
3611:

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

3604: arp_util.debug( '-------- parameters for update_f_ct_id() ------');
3605: arp_util.debug( 'p_customer_trx_id = ' ||
3606: p_customer_trx_id);
3607: arp_util.debug( 'p_line_type = ' || p_line_type);
3608: arp_util.debug( 'p_currency_code = ' || p_currency_code);
3609: END IF;
3610: display_line_rec(p_line_rec);
3611:
3612: RAISE;

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

3673: l_old_inclusive_amt ra_customer_trx_lines.extended_amount%type;
3674: l_qty ra_customer_trx_lines.quantity_invoiced%type;
3675: begin
3676: IF PG_DEBUG in ('Y', 'C') THEN
3677: arp_util.debug( 'arp_ctl_pkg.update_amount_f_ctl_id('
3678: || to_char(p_customer_trx_line_id) || ','
3679: || to_char(p_inclusive_amt)
3680: ||')+');
3681: END IF;

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

3741: p_new_extended_amt := l_extended_amount;
3742: p_new_unit_selling_price := l_unit_selling_price;
3743:
3744: IF PG_DEBUG in ('Y', 'C') THEN
3745: arp_util.debug( 'arp_ctl_pkg.update_amount_f_ctl_id('
3746: || to_char(l_extended_amount) || ','
3747: || to_char(l_unit_selling_price)
3748: ||')-');
3749: END IF;

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

3753: close c;
3754: end if;
3755:
3756: IF PG_DEBUG in ('Y', 'C') THEN
3757: arp_util.debug( 'arp_ctl_pkg.update_amount_f_ctl_id(EXCEPTION)-');
3758: END IF;
3759: raise;
3760: end update_amount_f_ctl_id;
3761:

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

3819: l_revenue_amount ra_customer_trx_lines.revenue_amount%type;
3820: l_old_inclusive_amt ra_customer_trx_lines.extended_amount%type;
3821: begin
3822: IF PG_DEBUG in ('Y', 'C') THEN
3823: arp_util.debug( 'arp_ctl_pkg.update_cm_amount_f_ctl_id('
3824: || to_char(p_customer_trx_line_id) || ','
3825: || to_char(p_inclusive_amount)
3826: ||')+');
3827: END IF;

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

3834: if ( p_inclusive_amount is null ) OR
3835: ( p_inclusive_amount = 0 )
3836: then
3837: IF PG_DEBUG in ('Y', 'C') THEN
3838: arp_util.debug( 'arp_ctl_pkg.update_cm_amount_f_ctl_id: '||
3839: 'No Inclusive Tax Amounts');
3840: END IF;
3841:
3842: l_gross_extended_amount := null;

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

3842: l_gross_extended_amount := null;
3843: l_gross_unit_selling_price := null;
3844: else
3845: IF PG_DEBUG in ('Y', 'C') THEN
3846: arp_util.debug( 'arp_ctl_pkg.update_cm_amount_f_ctl_id: '||
3847: 'Inclusive Amount = '||to_char(p_inclusive_amount));
3848: arp_util.debug( 'arp_ctl_pkg.update_cm_amount_f_ctl_id: '||
3849: 'Quantity = '||nvl(to_char(crow.quantity_credited), 'NULL'));
3850: arp_util.debug( 'arp_ctl_pkg.update_cm_amount_f_ctl_id: '||

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

3844: else
3845: IF PG_DEBUG in ('Y', 'C') THEN
3846: arp_util.debug( 'arp_ctl_pkg.update_cm_amount_f_ctl_id: '||
3847: 'Inclusive Amount = '||to_char(p_inclusive_amount));
3848: arp_util.debug( 'arp_ctl_pkg.update_cm_amount_f_ctl_id: '||
3849: 'Quantity = '||nvl(to_char(crow.quantity_credited), 'NULL'));
3850: arp_util.debug( 'arp_ctl_pkg.update_cm_amount_f_ctl_id: '||
3851: 'Precision = '||nvl(to_char(p_precision), 'NULL'));
3852: arp_util.debug( 'arp_ctl_pkg.update_cm_amount_f_ctl_id: '||

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

3846: arp_util.debug( 'arp_ctl_pkg.update_cm_amount_f_ctl_id: '||
3847: 'Inclusive Amount = '||to_char(p_inclusive_amount));
3848: arp_util.debug( 'arp_ctl_pkg.update_cm_amount_f_ctl_id: '||
3849: 'Quantity = '||nvl(to_char(crow.quantity_credited), 'NULL'));
3850: arp_util.debug( 'arp_ctl_pkg.update_cm_amount_f_ctl_id: '||
3851: 'Precision = '||nvl(to_char(p_precision), 'NULL'));
3852: arp_util.debug( 'arp_ctl_pkg.update_cm_amount_f_ctl_id: '||
3853: 'MAU = '||nvl(to_char(p_min_acct_unit), 'NULL'));
3854: END IF;

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

3848: arp_util.debug( 'arp_ctl_pkg.update_cm_amount_f_ctl_id: '||
3849: 'Quantity = '||nvl(to_char(crow.quantity_credited), 'NULL'));
3850: arp_util.debug( 'arp_ctl_pkg.update_cm_amount_f_ctl_id: '||
3851: 'Precision = '||nvl(to_char(p_precision), 'NULL'));
3852: arp_util.debug( 'arp_ctl_pkg.update_cm_amount_f_ctl_id: '||
3853: 'MAU = '||nvl(to_char(p_min_acct_unit), 'NULL'));
3854: END IF;
3855:
3856: l_gross_extended_amount := crow.extended_amount + p_inclusive_amount;

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

3861: close cinv;
3862: exception
3863: when others then
3864: IF PG_DEBUG in ('Y', 'C') THEN
3865: arp_util.debug( 'EXCPETION: Unable to fetch original invoice');
3866: END IF;
3867: raise;
3868: end;
3869: elsif ( crow.unit_selling_price is null ) then

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

3867: raise;
3868: end;
3869: elsif ( crow.unit_selling_price is null ) then
3870: IF PG_DEBUG in ('Y', 'C') THEN
3871: arp_util.debug( 'arp_ctl_pkg.update_cm_amount_f_ctl_id: NO unit selling price');
3872: END IF;
3873: l_gross_unit_selling_price := null;
3874: elsif (p_min_acct_unit is null) then
3875: IF PG_DEBUG in ('Y', 'C') THEN

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

3872: END IF;
3873: l_gross_unit_selling_price := null;
3874: elsif (p_min_acct_unit is null) then
3875: IF PG_DEBUG in ('Y', 'C') THEN
3876: arp_util.debug( 'arp_ctl_pkg.update_cm_amount_f_ctl_id: Rounding to precision');
3877: END IF;
3878: l_gross_unit_selling_price :=
3879: round(l_gross_extended_amount / crow.quantity_credited, p_precision);
3880: else

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

3878: l_gross_unit_selling_price :=
3879: round(l_gross_extended_amount / crow.quantity_credited, p_precision);
3880: else
3881: IF PG_DEBUG in ('Y', 'C') THEN
3882: arp_util.debug( 'arp_ctl_pkg.update_cm_amount_f_ctl_id: Rounding to MAU');
3883: END IF;
3884: l_gross_unit_selling_price :=
3885: round(l_gross_extended_amount / crow.quantity_credited / p_min_acct_unit / 100)
3886: * 100 * p_min_acct_unit;

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

3899: p_new_gross_extended_amount := l_gross_extended_amount;
3900: p_new_gross_unit_selling_price := l_gross_unit_selling_price;
3901:
3902: IF PG_DEBUG in ('Y', 'C') THEN
3903: arp_util.debug( 'arp_ctl_pkg.update_cm_amount_f_ctl_id('
3904: || to_char(l_gross_extended_amount) || ','
3905: || to_char(l_gross_unit_selling_price)
3906: ||')-');
3907: END IF;

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

3912: close c;
3913: end if;
3914:
3915: IF PG_DEBUG in ('Y', 'C') THEN
3916: arp_util.debug( 'arp_ctl_pkg.update_cm_amount_f_ctl_id(EXCEPTION)-');
3917: END IF;
3918: raise;
3919: end update_cm_amount_f_ctl_id;
3920:

Line 3934: | arp_util.debug |

3930: | |
3931: | SCOPE - PUBLIC |
3932: | |
3933: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
3934: | arp_util.debug |
3935: | arp_global.set_of_books_id |
3936: | |
3937: | ARGUMENTS : IN: |
3938: | p_line_rec - contains the new column values |

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

3990:
3991: BEGIN
3992:
3993: IF PG_DEBUG in ('Y', 'C') THEN
3994: arp_util.debug( 'arp_ctl_pkg.insert_p()+');
3995: END IF;
3996:
3997: p_customer_trx_line_id := '';
3998:

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

4293:
4294: p_customer_trx_line_id := l_customer_trx_line_id;
4295:
4296: IF PG_DEBUG in ('Y', 'C') THEN
4297: arp_util.debug( 'after insert: amount_includes_tax_flag = ' ||
4298: p_line_rec.amount_includes_tax_flag);
4299: arp_util.debug( 'after insert: gross_extended_amount = ' ||
4300: p_line_rec.gross_extended_amount);
4301: arp_util.debug( 'after insert: gross_unit_selling_price = ' ||

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

4295:
4296: IF PG_DEBUG in ('Y', 'C') THEN
4297: arp_util.debug( 'after insert: amount_includes_tax_flag = ' ||
4298: p_line_rec.amount_includes_tax_flag);
4299: arp_util.debug( 'after insert: gross_extended_amount = ' ||
4300: p_line_rec.gross_extended_amount);
4301: arp_util.debug( 'after insert: gross_unit_selling_price = ' ||
4302: p_line_rec.gross_unit_selling_price);
4303: arp_util.debug( 'arp_ctl_pkg.insert_p()-');

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

4297: arp_util.debug( 'after insert: amount_includes_tax_flag = ' ||
4298: p_line_rec.amount_includes_tax_flag);
4299: arp_util.debug( 'after insert: gross_extended_amount = ' ||
4300: p_line_rec.gross_extended_amount);
4301: arp_util.debug( 'after insert: gross_unit_selling_price = ' ||
4302: p_line_rec.gross_unit_selling_price);
4303: arp_util.debug( 'arp_ctl_pkg.insert_p()-');
4304: END IF;
4305:

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

4299: arp_util.debug( 'after insert: gross_extended_amount = ' ||
4300: p_line_rec.gross_extended_amount);
4301: arp_util.debug( 'after insert: gross_unit_selling_price = ' ||
4302: p_line_rec.gross_unit_selling_price);
4303: arp_util.debug( 'arp_ctl_pkg.insert_p()-');
4304: END IF;
4305:
4306: EXCEPTION
4307: WHEN OTHERS THEN

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

4305:
4306: EXCEPTION
4307: WHEN OTHERS THEN
4308: IF PG_DEBUG in ('Y', 'C') THEN
4309: arp_util.debug( 'EXCEPTION: arp_ctl_pkg.insert_p()');
4310: arp_util.debug( '');
4311: arp_util.debug( '-------- parameters for insert_p() ------');
4312: END IF;
4313: display_line_rec(p_line_rec);

Line 4310: arp_util.debug( '');

4306: EXCEPTION
4307: WHEN OTHERS THEN
4308: IF PG_DEBUG in ('Y', 'C') THEN
4309: arp_util.debug( 'EXCEPTION: arp_ctl_pkg.insert_p()');
4310: arp_util.debug( '');
4311: arp_util.debug( '-------- parameters for insert_p() ------');
4312: END IF;
4313: display_line_rec(p_line_rec);
4314:

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

4307: WHEN OTHERS THEN
4308: IF PG_DEBUG in ('Y', 'C') THEN
4309: arp_util.debug( 'EXCEPTION: arp_ctl_pkg.insert_p()');
4310: arp_util.debug( '');
4311: arp_util.debug( '-------- parameters for insert_p() ------');
4312: END IF;
4313: display_line_rec(p_line_rec);
4314:
4315: RAISE;

Line 4329: | arp_util.debug |

4325: | |
4326: | SCOPE - PRIVATE |
4327: | |
4328: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
4329: | arp_util.debug |
4330: | |
4331: | ARGUMENTS : IN: |
4332: | p_line_rec |
4333: | OUT: |

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

4344: PROCEDURE display_line_rec(
4345: p_line_rec IN ra_customer_trx_lines%rowtype) IS
4346: BEGIN
4347: IF PG_DEBUG in ('Y', 'C') THEN
4348: arp_util.debug( 'arp_ctl_pkg.display_line_rec()+');
4349: END IF;
4350:
4351: arp_ctl_private_pkg.display_line_rec(p_line_rec);
4352:

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

4350:
4351: arp_ctl_private_pkg.display_line_rec(p_line_rec);
4352:
4353: IF PG_DEBUG in ('Y', 'C') THEN
4354: arp_util.debug( 'arp_ctl_pkg.display_line_rec()-');
4355: END IF;
4356: END;
4357:
4358:

Line 4370: | arp_util.debug |

4366: | |
4367: | SCOPE - PUBLIC |
4368: | |
4369: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
4370: | arp_util.debug |
4371: | |
4372: | ARGUMENTS : IN: |
4373: | p_customer_trx_line_id |
4374: | OUT: |

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

4386: p_customer_trx_line_id IN
4387: ra_customer_trx_lines.customer_trx_line_id%type) IS
4388: BEGIN
4389: IF PG_DEBUG in ('Y', 'C') THEN
4390: arp_util.debug( 'arp_ctl_pkg.display_line_p()+');
4391: END IF;
4392:
4393: arp_ctl_private_pkg.display_line_p(p_customer_trx_line_id);
4394:

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

4392:
4393: arp_ctl_private_pkg.display_line_p(p_customer_trx_line_id);
4394:
4395: IF PG_DEBUG in ('Y', 'C') THEN
4396: arp_util.debug( 'arp_ctl_pkg.display_line_p()-');
4397: END IF;
4398:
4399: END;
4400:

Line 4412: | arp_util.debug |

4408: | |
4409: | SCOPE - PUBLIC |
4410: | |
4411: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
4412: | arp_util.debug |
4413: | |
4414: | ARGUMENTS : IN: |
4415: | p_link_to_cust_trx_line_id |
4416: | OUT: |

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

4433: IS
4434: BEGIN
4435:
4436: IF PG_DEBUG in ('Y', 'C') THEN
4437: arp_util.debug( 'arp_ctl_pkg.display_line_f_lctl_id()+');
4438: END IF;
4439:
4440: arp_ctl_private_pkg.display_line_f_lctl_id( p_link_to_cust_trx_line_id );
4441:

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

4439:
4440: arp_ctl_private_pkg.display_line_f_lctl_id( p_link_to_cust_trx_line_id );
4441:
4442: IF PG_DEBUG in ('Y', 'C') THEN
4443: arp_util.debug( 'arp_ctl_pkg.display_line_f_lctl_id()-');
4444: END IF;
4445:
4446: END;
4447:

Line 4460: | arp_util.debug |

4456: | |
4457: | SCOPE - PUBLIC |
4458: | |
4459: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
4460: | arp_util.debug |
4461: | |
4462: | ARGUMENTS : IN: |
4463: | p_customer_trx_id |
4464: | OUT: |

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

4481: IS
4482: BEGIN
4483:
4484: IF PG_DEBUG in ('Y', 'C') THEN
4485: arp_util.debug( 'arp_ctl_pkg.display_line_f_ct_id()+');
4486: END IF;
4487:
4488: arp_ctl_private_pkg.display_line_f_ct_id( p_customer_trx_id );
4489:

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

4487:
4488: arp_ctl_private_pkg.display_line_f_ct_id( p_customer_trx_id );
4489:
4490: IF PG_DEBUG in ('Y', 'C') THEN
4491: arp_util.debug( 'arp_ctl_pkg.display_line_f_ct_id()-');
4492: END IF;
4493:
4494: END;
4495:

Line 4508: | arp_util.debug |

4504: | |
4505: | SCOPE - PRIVATE |
4506: | |
4507: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
4508: | arp_util.debug |
4509: | |
4510: | ARGUMENTS : IN: |
4511: | p_old_line_rec |
4512: | p_new_line_rec |

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

4563:
4564: BEGIN
4565:
4566: IF PG_DEBUG in ('Y', 'C') THEN
4567: arp_util.debug( 'arp_ctl_pkg.merge_line_recs()+');
4568: END IF;
4569:
4570: IF (p_new_line_rec.customer_trx_line_id = AR_NUMBER_DUMMY)
4571: THEN p_out_line_rec.customer_trx_line_id :=

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

5322: ELSE p_out_line_rec.rule_end_date := p_new_line_rec.rule_end_date;
5323: END IF;
5324:
5325: IF PG_DEBUG in ('Y', 'C') THEN
5326: arp_util.debug( 'arp_ctl_pkg.merge_line_recs()-');
5327: END IF;
5328:
5329: EXCEPTION
5330: WHEN OTHERS THEN

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

5328:
5329: EXCEPTION
5330: WHEN OTHERS THEN
5331: IF PG_DEBUG in ('Y', 'C') THEN
5332: arp_util.debug( 'EXCEPTION: arp_ctl_pkg.merge_line_recs()');
5333: arp_util.debug( '');
5334: arp_util.debug( '-------- parameters for merge_line_recs() ------');
5335: arp_util.debug( ' ---- old line record ----');
5336: END IF;

Line 5333: arp_util.debug( '');

5329: EXCEPTION
5330: WHEN OTHERS THEN
5331: IF PG_DEBUG in ('Y', 'C') THEN
5332: arp_util.debug( 'EXCEPTION: arp_ctl_pkg.merge_line_recs()');
5333: arp_util.debug( '');
5334: arp_util.debug( '-------- parameters for merge_line_recs() ------');
5335: arp_util.debug( ' ---- old line record ----');
5336: END IF;
5337: display_line_rec(p_old_line_rec);

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

5330: WHEN OTHERS THEN
5331: IF PG_DEBUG in ('Y', 'C') THEN
5332: arp_util.debug( 'EXCEPTION: arp_ctl_pkg.merge_line_recs()');
5333: arp_util.debug( '');
5334: arp_util.debug( '-------- parameters for merge_line_recs() ------');
5335: arp_util.debug( ' ---- old line record ----');
5336: END IF;
5337: display_line_rec(p_old_line_rec);
5338: IF PG_DEBUG in ('Y', 'C') THEN

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

5331: IF PG_DEBUG in ('Y', 'C') THEN
5332: arp_util.debug( 'EXCEPTION: arp_ctl_pkg.merge_line_recs()');
5333: arp_util.debug( '');
5334: arp_util.debug( '-------- parameters for merge_line_recs() ------');
5335: arp_util.debug( ' ---- old line record ----');
5336: END IF;
5337: display_line_rec(p_old_line_rec);
5338: IF PG_DEBUG in ('Y', 'C') THEN
5339: arp_util.debug( '');

Line 5339: arp_util.debug( '');

5335: arp_util.debug( ' ---- old line record ----');
5336: END IF;
5337: display_line_rec(p_old_line_rec);
5338: IF PG_DEBUG in ('Y', 'C') THEN
5339: arp_util.debug( '');
5340: arp_util.debug( ' ---- new line record ----');
5341: END IF;
5342: display_line_rec(p_new_line_rec);
5343: IF PG_DEBUG in ('Y', 'C') THEN

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

5336: END IF;
5337: display_line_rec(p_old_line_rec);
5338: IF PG_DEBUG in ('Y', 'C') THEN
5339: arp_util.debug( '');
5340: arp_util.debug( ' ---- new line record ----');
5341: END IF;
5342: display_line_rec(p_new_line_rec);
5343: IF PG_DEBUG in ('Y', 'C') THEN
5344: arp_util.debug( '');

Line 5344: arp_util.debug( '');

5340: arp_util.debug( ' ---- new line record ----');
5341: END IF;
5342: display_line_rec(p_new_line_rec);
5343: IF PG_DEBUG in ('Y', 'C') THEN
5344: arp_util.debug( '');
5345: arp_util.debug( ' ---- merged line record ----');
5346: END IF;
5347: display_line_rec(p_out_line_rec);
5348: IF PG_DEBUG in ('Y', 'C') THEN

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

5341: END IF;
5342: display_line_rec(p_new_line_rec);
5343: IF PG_DEBUG in ('Y', 'C') THEN
5344: arp_util.debug( '');
5345: arp_util.debug( ' ---- merged line record ----');
5346: END IF;
5347: display_line_rec(p_out_line_rec);
5348: IF PG_DEBUG in ('Y', 'C') THEN
5349: arp_util.debug( '');

Line 5349: arp_util.debug( '');

5345: arp_util.debug( ' ---- merged line record ----');
5346: END IF;
5347: display_line_rec(p_out_line_rec);
5348: IF PG_DEBUG in ('Y', 'C') THEN
5349: arp_util.debug( '');
5350: END IF;
5351:
5352: RAISE;
5353:

Line 5366: | arp_util.debug |

5362: | |
5363: | SCOPE - PUBLIC |
5364: | |
5365: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
5366: | arp_util.debug |
5367: | |
5368: | ARGUMENTS : IN: |
5369: | None |
5370: | OUT: |

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

5443: WHERE customer_trx_line_id=c_prev_customer_trx_line_id;
5444: BEGIN
5445:
5446: IF PG_DEBUG in ('Y', 'C') THEN
5447: arp_util.debug( 'arp_ctl_pkg.insert_line_f_cm_ct_ctl_id()+');
5448: -- MVKOLLA - Bug7113653 Added following debug messages
5449: arp_util.debug('-- Added below messages for bug7113653');
5450: arp_util.debug('p_customer_trx_id '||p_customer_trx_id);
5451: arp_util.debug('p_customer_trx_line_id '||p_customer_trx_line_id);

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

5445:
5446: IF PG_DEBUG in ('Y', 'C') THEN
5447: arp_util.debug( 'arp_ctl_pkg.insert_line_f_cm_ct_ctl_id()+');
5448: -- MVKOLLA - Bug7113653 Added following debug messages
5449: arp_util.debug('-- Added below messages for bug7113653');
5450: arp_util.debug('p_customer_trx_id '||p_customer_trx_id);
5451: arp_util.debug('p_customer_trx_line_id '||p_customer_trx_line_id);
5452: arp_util.debug('p_prev_customer_trx_id '||p_prev_customer_trx_id);
5453: arp_util.debug('p_line_type '||p_line_type);

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

5446: IF PG_DEBUG in ('Y', 'C') THEN
5447: arp_util.debug( 'arp_ctl_pkg.insert_line_f_cm_ct_ctl_id()+');
5448: -- MVKOLLA - Bug7113653 Added following debug messages
5449: arp_util.debug('-- Added below messages for bug7113653');
5450: arp_util.debug('p_customer_trx_id '||p_customer_trx_id);
5451: arp_util.debug('p_customer_trx_line_id '||p_customer_trx_line_id);
5452: arp_util.debug('p_prev_customer_trx_id '||p_prev_customer_trx_id);
5453: arp_util.debug('p_line_type '||p_line_type);
5454: arp_util.debug('p_line_percent '||p_line_percent);

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

5447: arp_util.debug( 'arp_ctl_pkg.insert_line_f_cm_ct_ctl_id()+');
5448: -- MVKOLLA - Bug7113653 Added following debug messages
5449: arp_util.debug('-- Added below messages for bug7113653');
5450: arp_util.debug('p_customer_trx_id '||p_customer_trx_id);
5451: arp_util.debug('p_customer_trx_line_id '||p_customer_trx_line_id);
5452: arp_util.debug('p_prev_customer_trx_id '||p_prev_customer_trx_id);
5453: arp_util.debug('p_line_type '||p_line_type);
5454: arp_util.debug('p_line_percent '||p_line_percent);
5455: arp_util.debug('p_uncredited_amount '||p_uncredited_amount);

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

5448: -- MVKOLLA - Bug7113653 Added following debug messages
5449: arp_util.debug('-- Added below messages for bug7113653');
5450: arp_util.debug('p_customer_trx_id '||p_customer_trx_id);
5451: arp_util.debug('p_customer_trx_line_id '||p_customer_trx_line_id);
5452: arp_util.debug('p_prev_customer_trx_id '||p_prev_customer_trx_id);
5453: arp_util.debug('p_line_type '||p_line_type);
5454: arp_util.debug('p_line_percent '||p_line_percent);
5455: arp_util.debug('p_uncredited_amount '||p_uncredited_amount);
5456: arp_util.debug('p_credit_amount '||p_credit_amount);

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

5449: arp_util.debug('-- Added below messages for bug7113653');
5450: arp_util.debug('p_customer_trx_id '||p_customer_trx_id);
5451: arp_util.debug('p_customer_trx_line_id '||p_customer_trx_line_id);
5452: arp_util.debug('p_prev_customer_trx_id '||p_prev_customer_trx_id);
5453: arp_util.debug('p_line_type '||p_line_type);
5454: arp_util.debug('p_line_percent '||p_line_percent);
5455: arp_util.debug('p_uncredited_amount '||p_uncredited_amount);
5456: arp_util.debug('p_credit_amount '||p_credit_amount);
5457: arp_util.debug('p_currency_code '||p_currency_code);

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

5450: arp_util.debug('p_customer_trx_id '||p_customer_trx_id);
5451: arp_util.debug('p_customer_trx_line_id '||p_customer_trx_line_id);
5452: arp_util.debug('p_prev_customer_trx_id '||p_prev_customer_trx_id);
5453: arp_util.debug('p_line_type '||p_line_type);
5454: arp_util.debug('p_line_percent '||p_line_percent);
5455: arp_util.debug('p_uncredited_amount '||p_uncredited_amount);
5456: arp_util.debug('p_credit_amount '||p_credit_amount);
5457: arp_util.debug('p_currency_code '||p_currency_code);
5458: arp_util.debug('p_tax_amount '||p_tax_amount);

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

5451: arp_util.debug('p_customer_trx_line_id '||p_customer_trx_line_id);
5452: arp_util.debug('p_prev_customer_trx_id '||p_prev_customer_trx_id);
5453: arp_util.debug('p_line_type '||p_line_type);
5454: arp_util.debug('p_line_percent '||p_line_percent);
5455: arp_util.debug('p_uncredited_amount '||p_uncredited_amount);
5456: arp_util.debug('p_credit_amount '||p_credit_amount);
5457: arp_util.debug('p_currency_code '||p_currency_code);
5458: arp_util.debug('p_tax_amount '||p_tax_amount);
5459: END IF;

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

5452: arp_util.debug('p_prev_customer_trx_id '||p_prev_customer_trx_id);
5453: arp_util.debug('p_line_type '||p_line_type);
5454: arp_util.debug('p_line_percent '||p_line_percent);
5455: arp_util.debug('p_uncredited_amount '||p_uncredited_amount);
5456: arp_util.debug('p_credit_amount '||p_credit_amount);
5457: arp_util.debug('p_currency_code '||p_currency_code);
5458: arp_util.debug('p_tax_amount '||p_tax_amount);
5459: END IF;
5460:

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

5453: arp_util.debug('p_line_type '||p_line_type);
5454: arp_util.debug('p_line_percent '||p_line_percent);
5455: arp_util.debug('p_uncredited_amount '||p_uncredited_amount);
5456: arp_util.debug('p_credit_amount '||p_credit_amount);
5457: arp_util.debug('p_currency_code '||p_currency_code);
5458: arp_util.debug('p_tax_amount '||p_tax_amount);
5459: END IF;
5460:
5461: --{BUG#3339072

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

5454: arp_util.debug('p_line_percent '||p_line_percent);
5455: arp_util.debug('p_uncredited_amount '||p_uncredited_amount);
5456: arp_util.debug('p_credit_amount '||p_credit_amount);
5457: arp_util.debug('p_currency_code '||p_currency_code);
5458: arp_util.debug('p_tax_amount '||p_tax_amount);
5459: END IF;
5460:
5461: --{BUG#3339072
5462: -- Bug 10169170, Modified the following query to add an Order By clause.

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

5745:
5746: /* Bug-3658284 -Start */
5747: IF (l_trx_line_array.customer_trx_line_id.COUNT = 0) Then
5748: IF PG_DEBUG in ('Y', 'C') THEN
5749: arp_util.debug( 'arp_ctl_pkg.insert_line_f_cm_ct_ctl_id : '||' 0 row Fetch ');
5750: END IF;
5751:
5752: ELSE /*-- Bug 5098922 ---*/
5753:

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

5791: p_tax_amount IS NOT NULL
5792: THEN
5793: IF PG_DEBUG = 'Y'
5794: THEN
5795: arp_util.debug('Inclusive tax, adjusting extended/revenue amounts');
5796: arp_util.debug('customer_trx_line_id = ' ||
5797: l_trx_line_array.customer_trx_line_id(i));
5798: arp_util.debug(' original extended_amount = ' ||
5799: l_trx_line_array.extended_amount(i));

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

5792: THEN
5793: IF PG_DEBUG = 'Y'
5794: THEN
5795: arp_util.debug('Inclusive tax, adjusting extended/revenue amounts');
5796: arp_util.debug('customer_trx_line_id = ' ||
5797: l_trx_line_array.customer_trx_line_id(i));
5798: arp_util.debug(' original extended_amount = ' ||
5799: l_trx_line_array.extended_amount(i));
5800: arp_util.debug(' original revenue_amount = ' ||

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

5794: THEN
5795: arp_util.debug('Inclusive tax, adjusting extended/revenue amounts');
5796: arp_util.debug('customer_trx_line_id = ' ||
5797: l_trx_line_array.customer_trx_line_id(i));
5798: arp_util.debug(' original extended_amount = ' ||
5799: l_trx_line_array.extended_amount(i));
5800: arp_util.debug(' original revenue_amount = ' ||
5801: l_trx_line_array.revenue_amount(i));
5802: END IF;

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

5796: arp_util.debug('customer_trx_line_id = ' ||
5797: l_trx_line_array.customer_trx_line_id(i));
5798: arp_util.debug(' original extended_amount = ' ||
5799: l_trx_line_array.extended_amount(i));
5800: arp_util.debug(' original revenue_amount = ' ||
5801: l_trx_line_array.revenue_amount(i));
5802: END IF;
5803:
5804: l_trx_line_array.extended_amount(i) :=

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

5814: l_trx_line_array.original_revenue_amount(i)), p_currency_code);
5815:
5816: IF PG_DEBUG = 'Y'
5817: THEN
5818: arp_util.debug(' new extended_amount = ' ||
5819: l_trx_line_array.extended_amount(i));
5820: arp_util.debug(' new revenue_amount = ' ||
5821: l_trx_line_array.revenue_amount(i));
5822: END IF;

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

5816: IF PG_DEBUG = 'Y'
5817: THEN
5818: arp_util.debug(' new extended_amount = ' ||
5819: l_trx_line_array.extended_amount(i));
5820: arp_util.debug(' new revenue_amount = ' ||
5821: l_trx_line_array.revenue_amount(i));
5822: END IF;
5823:
5824: END IF;

Line 5853: arp_util.debug('l_trx_line_array.unit_Selling_price(i):' || l_trx_line_array.unit_Selling_price(i));

5849: l_round := 2;
5850: end if;
5851:
5852: IF PG_DEBUG in ('Y', 'C') THEN
5853: arp_util.debug('l_trx_line_array.unit_Selling_price(i):' || l_trx_line_array.unit_Selling_price(i));
5854: arp_util.debug('length(l_quantity_invoiced):'||length(l_quantity_invoiced));
5855: arp_util.debug('length(round(l_quantity_invoiced,0)):'||length(round(l_quantity_invoiced,0)));
5856: arp_util.debug('l_trx_line_array.gross_unit_Selling_price(i):'||l_trx_line_array.gross_unit_Selling_price(i));
5857: arp_util.debug('l_trx_line_array.extended_amount(i):'||l_trx_line_array.extended_amount(i));

Line 5854: arp_util.debug('length(l_quantity_invoiced):'||length(l_quantity_invoiced));

5850: end if;
5851:
5852: IF PG_DEBUG in ('Y', 'C') THEN
5853: arp_util.debug('l_trx_line_array.unit_Selling_price(i):' || l_trx_line_array.unit_Selling_price(i));
5854: arp_util.debug('length(l_quantity_invoiced):'||length(l_quantity_invoiced));
5855: arp_util.debug('length(round(l_quantity_invoiced,0)):'||length(round(l_quantity_invoiced,0)));
5856: arp_util.debug('l_trx_line_array.gross_unit_Selling_price(i):'||l_trx_line_array.gross_unit_Selling_price(i));
5857: arp_util.debug('l_trx_line_array.extended_amount(i):'||l_trx_line_array.extended_amount(i));
5858: arp_util.debug('l_round:'||l_round);

Line 5855: arp_util.debug('length(round(l_quantity_invoiced,0)):'||length(round(l_quantity_invoiced,0)));

5851:
5852: IF PG_DEBUG in ('Y', 'C') THEN
5853: arp_util.debug('l_trx_line_array.unit_Selling_price(i):' || l_trx_line_array.unit_Selling_price(i));
5854: arp_util.debug('length(l_quantity_invoiced):'||length(l_quantity_invoiced));
5855: arp_util.debug('length(round(l_quantity_invoiced,0)):'||length(round(l_quantity_invoiced,0)));
5856: arp_util.debug('l_trx_line_array.gross_unit_Selling_price(i):'||l_trx_line_array.gross_unit_Selling_price(i));
5857: arp_util.debug('l_trx_line_array.extended_amount(i):'||l_trx_line_array.extended_amount(i));
5858: arp_util.debug('l_round:'||l_round);
5859: END IF;

Line 5856: arp_util.debug('l_trx_line_array.gross_unit_Selling_price(i):'||l_trx_line_array.gross_unit_Selling_price(i));

5852: IF PG_DEBUG in ('Y', 'C') THEN
5853: arp_util.debug('l_trx_line_array.unit_Selling_price(i):' || l_trx_line_array.unit_Selling_price(i));
5854: arp_util.debug('length(l_quantity_invoiced):'||length(l_quantity_invoiced));
5855: arp_util.debug('length(round(l_quantity_invoiced,0)):'||length(round(l_quantity_invoiced,0)));
5856: arp_util.debug('l_trx_line_array.gross_unit_Selling_price(i):'||l_trx_line_array.gross_unit_Selling_price(i));
5857: arp_util.debug('l_trx_line_array.extended_amount(i):'||l_trx_line_array.extended_amount(i));
5858: arp_util.debug('l_round:'||l_round);
5859: END IF;
5860:

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

5853: arp_util.debug('l_trx_line_array.unit_Selling_price(i):' || l_trx_line_array.unit_Selling_price(i));
5854: arp_util.debug('length(l_quantity_invoiced):'||length(l_quantity_invoiced));
5855: arp_util.debug('length(round(l_quantity_invoiced,0)):'||length(round(l_quantity_invoiced,0)));
5856: arp_util.debug('l_trx_line_array.gross_unit_Selling_price(i):'||l_trx_line_array.gross_unit_Selling_price(i));
5857: arp_util.debug('l_trx_line_array.extended_amount(i):'||l_trx_line_array.extended_amount(i));
5858: arp_util.debug('l_round:'||l_round);
5859: END IF;
5860:
5861:

Line 5858: arp_util.debug('l_round:'||l_round);

5854: arp_util.debug('length(l_quantity_invoiced):'||length(l_quantity_invoiced));
5855: arp_util.debug('length(round(l_quantity_invoiced,0)):'||length(round(l_quantity_invoiced,0)));
5856: arp_util.debug('l_trx_line_array.gross_unit_Selling_price(i):'||l_trx_line_array.gross_unit_Selling_price(i));
5857: arp_util.debug('l_trx_line_array.extended_amount(i):'||l_trx_line_array.extended_amount(i));
5858: arp_util.debug('l_round:'||l_round);
5859: END IF;
5860:
5861:
5862: If Nvl(l_trx_line_array.gross_unit_Selling_price(i),0) <> 0 then

Line 5871: arp_util.debug('l_qnt_temp:'||l_qnt_temp);

5867:
5868:
5869: --bug 14679910, rounding the quantity to the nearest value
5870: IF PG_DEBUG in ('Y', 'C') THEN
5871: arp_util.debug('l_qnt_temp:'||l_qnt_temp);
5872: arp_util.debug('round(l_qnt_temp,l_round):'||round(l_qnt_temp,l_round));
5873: END IF;
5874: --Bug 16293794
5875: if(l_qnt_temp <> 0 AND round(l_qnt_temp,l_round) = 0 ) then

Line 5872: arp_util.debug('round(l_qnt_temp,l_round):'||round(l_qnt_temp,l_round));

5868:
5869: --bug 14679910, rounding the quantity to the nearest value
5870: IF PG_DEBUG in ('Y', 'C') THEN
5871: arp_util.debug('l_qnt_temp:'||l_qnt_temp);
5872: arp_util.debug('round(l_qnt_temp,l_round):'||round(l_qnt_temp,l_round));
5873: END IF;
5874: --Bug 16293794
5875: if(l_qnt_temp <> 0 AND round(l_qnt_temp,l_round) = 0 ) then
5876: l_trx_line_array.quantity_credited(i):= NVL(round(l_qnt_temp,length(l_qnt_temp)-length(REPLACE(l_qnt_temp, '0', ''))+1),

Line 5880: arp_util.debug('rounding off with precision');

5876: l_trx_line_array.quantity_credited(i):= NVL(round(l_qnt_temp,length(l_qnt_temp)-length(REPLACE(l_qnt_temp, '0', ''))+1),
5877: round(l_qnt_temp,l_round));
5878:
5879: IF PG_DEBUG in ('Y', 'C') THEN
5880: arp_util.debug('rounding off with precision');
5881: END IF;
5882:
5883: else
5884: l_trx_line_array.quantity_credited(i) := round(l_qnt_temp,l_round);

Line 5888: arp_util.debug('l_trx_line_array.quantity_credited(i):'||l_trx_line_array.quantity_credited(i));

5884: l_trx_line_array.quantity_credited(i) := round(l_qnt_temp,l_round);
5885: end if;
5886:
5887: IF PG_DEBUG in ('Y', 'C') THEN
5888: arp_util.debug('l_trx_line_array.quantity_credited(i):'||l_trx_line_array.quantity_credited(i));
5889: END IF;
5890:
5891: l_qnt_temp := 0;
5892:

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

5901: -- MVKOLLA - Added following debug messages as part of bug7113653
5902: IF PG_DEBUG in ('Y', 'C') THEN
5903: i := l_trx_line_array.customer_trx_line_id.FIRST;
5904: WHILE l_trx_line_array.customer_trx_line_id.EXISTS(i) LOOP
5905: arp_util.debug('l_trx_line_array.customer_trx_line_id(i) '||l_trx_line_array.customer_trx_line_id(i));
5906: arp_util.debug('l_trx_line_array.previous_customer_trx_line_id(i) '||l_trx_line_array.previous_customer_trx_line_id(i));
5907: arp_util.debug('l_trx_line_array.extended_amount(i) '||l_trx_line_array.extended_amount(i));
5908: arp_util.debug('l_trx_line_array.revenue_amount(i) '||l_trx_line_array.revenue_amount(i));
5909: i := l_trx_line_array.customer_trx_line_id.NEXT(i);

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

5902: IF PG_DEBUG in ('Y', 'C') THEN
5903: i := l_trx_line_array.customer_trx_line_id.FIRST;
5904: WHILE l_trx_line_array.customer_trx_line_id.EXISTS(i) LOOP
5905: arp_util.debug('l_trx_line_array.customer_trx_line_id(i) '||l_trx_line_array.customer_trx_line_id(i));
5906: arp_util.debug('l_trx_line_array.previous_customer_trx_line_id(i) '||l_trx_line_array.previous_customer_trx_line_id(i));
5907: arp_util.debug('l_trx_line_array.extended_amount(i) '||l_trx_line_array.extended_amount(i));
5908: arp_util.debug('l_trx_line_array.revenue_amount(i) '||l_trx_line_array.revenue_amount(i));
5909: i := l_trx_line_array.customer_trx_line_id.NEXT(i);
5910: END LOOP;

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

5903: i := l_trx_line_array.customer_trx_line_id.FIRST;
5904: WHILE l_trx_line_array.customer_trx_line_id.EXISTS(i) LOOP
5905: arp_util.debug('l_trx_line_array.customer_trx_line_id(i) '||l_trx_line_array.customer_trx_line_id(i));
5906: arp_util.debug('l_trx_line_array.previous_customer_trx_line_id(i) '||l_trx_line_array.previous_customer_trx_line_id(i));
5907: arp_util.debug('l_trx_line_array.extended_amount(i) '||l_trx_line_array.extended_amount(i));
5908: arp_util.debug('l_trx_line_array.revenue_amount(i) '||l_trx_line_array.revenue_amount(i));
5909: i := l_trx_line_array.customer_trx_line_id.NEXT(i);
5910: END LOOP;
5911: END IF;

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

5904: WHILE l_trx_line_array.customer_trx_line_id.EXISTS(i) LOOP
5905: arp_util.debug('l_trx_line_array.customer_trx_line_id(i) '||l_trx_line_array.customer_trx_line_id(i));
5906: arp_util.debug('l_trx_line_array.previous_customer_trx_line_id(i) '||l_trx_line_array.previous_customer_trx_line_id(i));
5907: arp_util.debug('l_trx_line_array.extended_amount(i) '||l_trx_line_array.extended_amount(i));
5908: arp_util.debug('l_trx_line_array.revenue_amount(i) '||l_trx_line_array.revenue_amount(i));
5909: i := l_trx_line_array.customer_trx_line_id.NEXT(i);
5910: END LOOP;
5911: END IF;
5912:

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

6052:
6053: /* Bug Number 6790882 */
6054:
6055: IF PG_DEBUG in ('Y', 'C') THEN
6056: arp_util.debug( 'i = ' || i);
6057: arp_util.debug( 'l_rows_inserted = ' || l_rows_inserted);
6058: arp_util.debug( 'l_mode = ' || l_mode);
6059: END IF;
6060:

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

6053: /* Bug Number 6790882 */
6054:
6055: IF PG_DEBUG in ('Y', 'C') THEN
6056: arp_util.debug( 'i = ' || i);
6057: arp_util.debug( 'l_rows_inserted = ' || l_rows_inserted);
6058: arp_util.debug( 'l_mode = ' || l_mode);
6059: END IF;
6060:
6061: IF l_mode = 'INSERT_NO_LINE' THEN

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

6054:
6055: IF PG_DEBUG in ('Y', 'C') THEN
6056: arp_util.debug( 'i = ' || i);
6057: arp_util.debug( 'l_rows_inserted = ' || l_rows_inserted);
6058: arp_util.debug( 'l_mode = ' || l_mode);
6059: END IF;
6060:
6061: IF l_mode = 'INSERT_NO_LINE' THEN
6062: IF i = l_rows_inserted THEN

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

6075: l_tax_amount := p_tax_amount;
6076: END IF;
6077:
6078: IF PG_DEBUG in ('Y', 'C') THEN
6079: arp_util.debug( 'l_total_tax_prorate = ' || l_total_tax_prorate);
6080: arp_util.debug( 'l_tax_amount = ' || l_tax_amount);
6081: END IF;
6082:
6083: ARP_ETAX_SERVICES_PKG.line_det_factors(

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

6076: END IF;
6077:
6078: IF PG_DEBUG in ('Y', 'C') THEN
6079: arp_util.debug( 'l_total_tax_prorate = ' || l_total_tax_prorate);
6080: arp_util.debug( 'l_tax_amount = ' || l_tax_amount);
6081: END IF;
6082:
6083: ARP_ETAX_SERVICES_PKG.line_det_factors(
6084: p_customer_trx_line_id => l_trx_line_array.customer_trx_line_id(i),

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

6094: --}
6095:
6096:
6097: IF PG_DEBUG in ('Y', 'C') THEN
6098: arp_util.debug( 'arp_ctl_pkg.insert_line_f_cm_ct_ctl_id : '||
6099: to_char(l_rows_inserted)||' rows inserted');
6100: END IF;
6101:
6102: /* Bug 3658284 - Remove the entire rounding update statement */

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

6101:
6102: /* Bug 3658284 - Remove the entire rounding update statement */
6103:
6104: IF PG_DEBUG in ('Y', 'C') THEN
6105: arp_util.debug( 'arp_ctl_pkg.insert_line_f_cm_ct_ctl_id()-');
6106: END IF;
6107:
6108: EXCEPTION
6109: WHEN NO_DATA_FOUND THEN

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

6109: WHEN NO_DATA_FOUND THEN
6110: return;
6111: WHEN OTHERS THEN
6112: IF PG_DEBUG in ('Y', 'C') THEN
6113: arp_util.debug( 'EXCEPTION: arp_ctl_pkg.insert_line_f_cm_ct_ctl_id');
6114: arp_util.debug( '');
6115: arp_util.debug( 'p_customer_trx_id = '||p_customer_trx_id);
6116: arp_util.debug( 'p_customer_trx_line_id = '||p_customer_trx_line_id);
6117: arp_util.debug( 'p_prev_customer_trx_id = '||p_prev_customer_trx_id);

Line 6114: arp_util.debug( '');

6110: return;
6111: WHEN OTHERS THEN
6112: IF PG_DEBUG in ('Y', 'C') THEN
6113: arp_util.debug( 'EXCEPTION: arp_ctl_pkg.insert_line_f_cm_ct_ctl_id');
6114: arp_util.debug( '');
6115: arp_util.debug( 'p_customer_trx_id = '||p_customer_trx_id);
6116: arp_util.debug( 'p_customer_trx_line_id = '||p_customer_trx_line_id);
6117: arp_util.debug( 'p_prev_customer_trx_id = '||p_prev_customer_trx_id);
6118: arp_util.debug( 'p_line_type = '||p_line_type);

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

6111: WHEN OTHERS THEN
6112: IF PG_DEBUG in ('Y', 'C') THEN
6113: arp_util.debug( 'EXCEPTION: arp_ctl_pkg.insert_line_f_cm_ct_ctl_id');
6114: arp_util.debug( '');
6115: arp_util.debug( 'p_customer_trx_id = '||p_customer_trx_id);
6116: arp_util.debug( 'p_customer_trx_line_id = '||p_customer_trx_line_id);
6117: arp_util.debug( 'p_prev_customer_trx_id = '||p_prev_customer_trx_id);
6118: arp_util.debug( 'p_line_type = '||p_line_type);
6119: arp_util.debug( 'p_uncredited_amount = '||p_uncredited_amount);

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

6112: IF PG_DEBUG in ('Y', 'C') THEN
6113: arp_util.debug( 'EXCEPTION: arp_ctl_pkg.insert_line_f_cm_ct_ctl_id');
6114: arp_util.debug( '');
6115: arp_util.debug( 'p_customer_trx_id = '||p_customer_trx_id);
6116: arp_util.debug( 'p_customer_trx_line_id = '||p_customer_trx_line_id);
6117: arp_util.debug( 'p_prev_customer_trx_id = '||p_prev_customer_trx_id);
6118: arp_util.debug( 'p_line_type = '||p_line_type);
6119: arp_util.debug( 'p_uncredited_amount = '||p_uncredited_amount);
6120: arp_util.debug( 'p_credit_amount = '||p_credit_amount);

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

6113: arp_util.debug( 'EXCEPTION: arp_ctl_pkg.insert_line_f_cm_ct_ctl_id');
6114: arp_util.debug( '');
6115: arp_util.debug( 'p_customer_trx_id = '||p_customer_trx_id);
6116: arp_util.debug( 'p_customer_trx_line_id = '||p_customer_trx_line_id);
6117: arp_util.debug( 'p_prev_customer_trx_id = '||p_prev_customer_trx_id);
6118: arp_util.debug( 'p_line_type = '||p_line_type);
6119: arp_util.debug( 'p_uncredited_amount = '||p_uncredited_amount);
6120: arp_util.debug( 'p_credit_amount = '||p_credit_amount);
6121: arp_util.debug( 'p_currency_code = '||p_currency_code);

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

6114: arp_util.debug( '');
6115: arp_util.debug( 'p_customer_trx_id = '||p_customer_trx_id);
6116: arp_util.debug( 'p_customer_trx_line_id = '||p_customer_trx_line_id);
6117: arp_util.debug( 'p_prev_customer_trx_id = '||p_prev_customer_trx_id);
6118: arp_util.debug( 'p_line_type = '||p_line_type);
6119: arp_util.debug( 'p_uncredited_amount = '||p_uncredited_amount);
6120: arp_util.debug( 'p_credit_amount = '||p_credit_amount);
6121: arp_util.debug( 'p_currency_code = '||p_currency_code);
6122: END IF;

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

6115: arp_util.debug( 'p_customer_trx_id = '||p_customer_trx_id);
6116: arp_util.debug( 'p_customer_trx_line_id = '||p_customer_trx_line_id);
6117: arp_util.debug( 'p_prev_customer_trx_id = '||p_prev_customer_trx_id);
6118: arp_util.debug( 'p_line_type = '||p_line_type);
6119: arp_util.debug( 'p_uncredited_amount = '||p_uncredited_amount);
6120: arp_util.debug( 'p_credit_amount = '||p_credit_amount);
6121: arp_util.debug( 'p_currency_code = '||p_currency_code);
6122: END IF;
6123: RAISE;

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

6116: arp_util.debug( 'p_customer_trx_line_id = '||p_customer_trx_line_id);
6117: arp_util.debug( 'p_prev_customer_trx_id = '||p_prev_customer_trx_id);
6118: arp_util.debug( 'p_line_type = '||p_line_type);
6119: arp_util.debug( 'p_uncredited_amount = '||p_uncredited_amount);
6120: arp_util.debug( 'p_credit_amount = '||p_credit_amount);
6121: arp_util.debug( 'p_currency_code = '||p_currency_code);
6122: END IF;
6123: RAISE;
6124:

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

6117: arp_util.debug( 'p_prev_customer_trx_id = '||p_prev_customer_trx_id);
6118: arp_util.debug( 'p_line_type = '||p_line_type);
6119: arp_util.debug( 'p_uncredited_amount = '||p_uncredited_amount);
6120: arp_util.debug( 'p_credit_amount = '||p_credit_amount);
6121: arp_util.debug( 'p_currency_code = '||p_currency_code);
6122: END IF;
6123: RAISE;
6124:
6125: END;

Line 6138: | arp_util.debug |

6134: | |
6135: | SCOPE - PUBLIC |
6136: | |
6137: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
6138: | arp_util.debug |
6139: | |
6140: | ARGUMENTS : IN: |
6141: | None |
6142: | OUT: |

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

6162: l_rows_updated number;
6163: BEGIN
6164:
6165: IF PG_DEBUG in ('Y', 'C') THEN
6166: arp_util.debug( 'arp_ctl_pkg.update_line_f_cm_ctl_id()+');
6167: END IF;
6168:
6169: UPDATE ra_customer_trx_lines ctl
6170: SET extended_amount =

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

6187: AND ctl.link_to_cust_trx_line_id = p_customer_trx_line_id
6188: AND ctl.line_type = p_line_type;
6189:
6190: IF PG_DEBUG in ('Y', 'C') THEN
6191: arp_util.debug( 'arp_ctl_pkg.update_line_f_cm_ctl_id : '||
6192: 'Extended Amount :'|| SQL%ROWCOUNT||' rows updated');
6193: END IF;
6194:
6195: UPDATE ra_customer_trx_lines ctl

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

6199: AND ctl.link_to_cust_trx_line_id = p_customer_trx_line_id
6200: AND ctl.line_type = p_line_type;
6201:
6202: IF PG_DEBUG in ('Y', 'C') THEN
6203: arp_util.debug( 'arp_ctl_pkg.update_line_f_cm_ctl_id : '||
6204: 'Currency Rounding :'|| SQL%ROWCOUNT||' rows updated');
6205: END IF;
6206:
6207: /*----------------------------+

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

6231:
6232: END IF;
6233:
6234: IF PG_DEBUG in ('Y', 'C') THEN
6235: arp_util.debug( 'arp_ctl_pkg.update_line_f_cm_ctl_id()-');
6236: END IF;
6237:
6238: EXCEPTION
6239: WHEN NO_DATA_FOUND THEN

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

6239: WHEN NO_DATA_FOUND THEN
6240: return;
6241: WHEN OTHERS THEN
6242: IF PG_DEBUG in ('Y', 'C') THEN
6243: arp_util.debug( 'EXCEPTION: arp_ctl_pkg.update_line_f_cm_ctl_id');
6244: arp_util.debug( '');
6245: arp_util.debug( 'p_customer_trx_id = '||p_customer_trx_id);
6246: arp_util.debug( 'p_customer_trx_line_id = '||p_customer_trx_line_id);
6247: arp_util.debug( 'p_prev_customer_trx_id = '||p_prev_customer_trx_id);

Line 6244: arp_util.debug( '');

6240: return;
6241: WHEN OTHERS THEN
6242: IF PG_DEBUG in ('Y', 'C') THEN
6243: arp_util.debug( 'EXCEPTION: arp_ctl_pkg.update_line_f_cm_ctl_id');
6244: arp_util.debug( '');
6245: arp_util.debug( 'p_customer_trx_id = '||p_customer_trx_id);
6246: arp_util.debug( 'p_customer_trx_line_id = '||p_customer_trx_line_id);
6247: arp_util.debug( 'p_prev_customer_trx_id = '||p_prev_customer_trx_id);
6248: arp_util.debug( 'p_line_type = '||p_line_type);

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

6241: WHEN OTHERS THEN
6242: IF PG_DEBUG in ('Y', 'C') THEN
6243: arp_util.debug( 'EXCEPTION: arp_ctl_pkg.update_line_f_cm_ctl_id');
6244: arp_util.debug( '');
6245: arp_util.debug( 'p_customer_trx_id = '||p_customer_trx_id);
6246: arp_util.debug( 'p_customer_trx_line_id = '||p_customer_trx_line_id);
6247: arp_util.debug( 'p_prev_customer_trx_id = '||p_prev_customer_trx_id);
6248: arp_util.debug( 'p_line_type = '||p_line_type);
6249: arp_util.debug( 'p_uncredited_amount = '||p_uncredited_amount);

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

6242: IF PG_DEBUG in ('Y', 'C') THEN
6243: arp_util.debug( 'EXCEPTION: arp_ctl_pkg.update_line_f_cm_ctl_id');
6244: arp_util.debug( '');
6245: arp_util.debug( 'p_customer_trx_id = '||p_customer_trx_id);
6246: arp_util.debug( 'p_customer_trx_line_id = '||p_customer_trx_line_id);
6247: arp_util.debug( 'p_prev_customer_trx_id = '||p_prev_customer_trx_id);
6248: arp_util.debug( 'p_line_type = '||p_line_type);
6249: arp_util.debug( 'p_uncredited_amount = '||p_uncredited_amount);
6250: arp_util.debug( 'p_credit_amount = '||p_credit_amount);

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

6243: arp_util.debug( 'EXCEPTION: arp_ctl_pkg.update_line_f_cm_ctl_id');
6244: arp_util.debug( '');
6245: arp_util.debug( 'p_customer_trx_id = '||p_customer_trx_id);
6246: arp_util.debug( 'p_customer_trx_line_id = '||p_customer_trx_line_id);
6247: arp_util.debug( 'p_prev_customer_trx_id = '||p_prev_customer_trx_id);
6248: arp_util.debug( 'p_line_type = '||p_line_type);
6249: arp_util.debug( 'p_uncredited_amount = '||p_uncredited_amount);
6250: arp_util.debug( 'p_credit_amount = '||p_credit_amount);
6251: arp_util.debug( 'p_currency_code = '||p_currency_code);

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

6244: arp_util.debug( '');
6245: arp_util.debug( 'p_customer_trx_id = '||p_customer_trx_id);
6246: arp_util.debug( 'p_customer_trx_line_id = '||p_customer_trx_line_id);
6247: arp_util.debug( 'p_prev_customer_trx_id = '||p_prev_customer_trx_id);
6248: arp_util.debug( 'p_line_type = '||p_line_type);
6249: arp_util.debug( 'p_uncredited_amount = '||p_uncredited_amount);
6250: arp_util.debug( 'p_credit_amount = '||p_credit_amount);
6251: arp_util.debug( 'p_currency_code = '||p_currency_code);
6252: END IF;

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

6245: arp_util.debug( 'p_customer_trx_id = '||p_customer_trx_id);
6246: arp_util.debug( 'p_customer_trx_line_id = '||p_customer_trx_line_id);
6247: arp_util.debug( 'p_prev_customer_trx_id = '||p_prev_customer_trx_id);
6248: arp_util.debug( 'p_line_type = '||p_line_type);
6249: arp_util.debug( 'p_uncredited_amount = '||p_uncredited_amount);
6250: arp_util.debug( 'p_credit_amount = '||p_credit_amount);
6251: arp_util.debug( 'p_currency_code = '||p_currency_code);
6252: END IF;
6253: RAISE;

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

6246: arp_util.debug( 'p_customer_trx_line_id = '||p_customer_trx_line_id);
6247: arp_util.debug( 'p_prev_customer_trx_id = '||p_prev_customer_trx_id);
6248: arp_util.debug( 'p_line_type = '||p_line_type);
6249: arp_util.debug( 'p_uncredited_amount = '||p_uncredited_amount);
6250: arp_util.debug( 'p_credit_amount = '||p_credit_amount);
6251: arp_util.debug( 'p_currency_code = '||p_currency_code);
6252: END IF;
6253: RAISE;
6254:

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

6247: arp_util.debug( 'p_prev_customer_trx_id = '||p_prev_customer_trx_id);
6248: arp_util.debug( 'p_line_type = '||p_line_type);
6249: arp_util.debug( 'p_uncredited_amount = '||p_uncredited_amount);
6250: arp_util.debug( 'p_credit_amount = '||p_credit_amount);
6251: arp_util.debug( 'p_currency_code = '||p_currency_code);
6252: END IF;
6253: RAISE;
6254:
6255: END;

Line 6268: | arp_util.debug |

6264: | |
6265: | SCOPE - PUBLIC |
6266: | |
6267: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
6268: | arp_util.debug |
6269: | |
6270: | ARGUMENTS : IN: |
6271: | None |
6272: | OUT: |

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

6284: FUNCTION get_text_dummy(p_null IN NUMBER DEFAULT null) RETURN varchar2 IS
6285:
6286: BEGIN
6287:
6288: --- arp_util.debug('arp_ctl_pkg.get_text_dummy()+');
6289:
6290: --- arp_util.debug('arp_ctl_pkg.get_text_dummy()-');
6291:
6292: return(AR_TEXT_DUMMY);

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

6286: BEGIN
6287:
6288: --- arp_util.debug('arp_ctl_pkg.get_text_dummy()+');
6289:
6290: --- arp_util.debug('arp_ctl_pkg.get_text_dummy()-');
6291:
6292: return(AR_TEXT_DUMMY);
6293:
6294: EXCEPTION

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

6293:
6294: EXCEPTION
6295: WHEN OTHERS THEN
6296: IF PG_DEBUG in ('Y', 'C') THEN
6297: arp_util.debug( 'EXCEPTION: arp_ctl_pkg.get_text_dummy()');
6298: END IF;
6299: RAISE;
6300:
6301: END;

Line 6313: | arp_util.debug |

6309: | |
6310: | SCOPE - PUBLIC |
6311: | |
6312: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
6313: | arp_util.debug |
6314: | |
6315: | ARGUMENTS : IN: |
6316: | None |
6317: | OUT: |

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

6329: FUNCTION get_number_dummy(p_null IN NUMBER DEFAULT null) RETURN number IS
6330:
6331: BEGIN
6332:
6333: --- arp_util.debug('arp_ctl_pkg.get_number_dummy()+');
6334:
6335: --- arp_util.debug('arp_ctl_pkg.get_number_dummy()-');
6336:
6337: return(AR_NUMBER_DUMMY);

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

6331: BEGIN
6332:
6333: --- arp_util.debug('arp_ctl_pkg.get_number_dummy()+');
6334:
6335: --- arp_util.debug('arp_ctl_pkg.get_number_dummy()-');
6336:
6337: return(AR_NUMBER_DUMMY);
6338:
6339: EXCEPTION

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

6338:
6339: EXCEPTION
6340: WHEN OTHERS THEN
6341: IF PG_DEBUG in ('Y', 'C') THEN
6342: arp_util.debug( 'EXCEPTION: arp_ctl_pkg.get_number_dummy()');
6343: END IF;
6344: RAISE;
6345:
6346: END;