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_CTLGD_PKG dependencies on ARP_CTLGD_PKG

Line 1: PACKAGE BODY ARP_CTLGD_PKG AS

1: PACKAGE BODY ARP_CTLGD_PKG AS
2: /* $Header: ARTILGDB.pls 120.21 2010/09/20 06:33:40 nemani ship $ */
3: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
4:
5: /*--------------------------------------------------------+

Line 72: arp_util.debug('arp_ctlgd_pkg.display_dist_rec()+');

68:
69:
70: BEGIN
71:
72: arp_util.debug('arp_ctlgd_pkg.display_dist_rec()+');
73:
74: arp_util.debug('************** Dump of ra_cust_trx_line_gl_dist record '||
75: '**************');
76:

Line 132: arp_util.debug('arp_ctlgd_pkg.display_dist_rec()-');

128: arp_util.debug('rounding_correction_flag:'|| p_dist_rec.rounding_correction_flag);
129: arp_util.debug('************** End ra_cust_trx_line_gl_dist record ' ||
130: '**************');
131:
132: arp_util.debug('arp_ctlgd_pkg.display_dist_rec()-');
133:
134: EXCEPTION
135: WHEN OTHERS THEN
136: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.display_dist_rec()');

Line 136: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.display_dist_rec()');

132: arp_util.debug('arp_ctlgd_pkg.display_dist_rec()-');
133:
134: EXCEPTION
135: WHEN OTHERS THEN
136: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.display_dist_rec()');
137: RAISE;
138:
139: END;
140:

Line 178: arp_util.debug('arp_ctlgd_pkg.display_dist_p()+');

174: l_dist_rec ra_cust_trx_line_gl_dist%rowtype;
175:
176: BEGIN
177:
178: arp_util.debug('arp_ctlgd_pkg.display_dist_p()+');
179:
180: arp_ctlgd_pkg.fetch_p(l_dist_rec, p_cust_trx_line_gl_dist_id);
181:
182: arp_ctlgd_pkg.display_dist_rec(l_dist_rec);

Line 180: arp_ctlgd_pkg.fetch_p(l_dist_rec, p_cust_trx_line_gl_dist_id);

176: BEGIN
177:
178: arp_util.debug('arp_ctlgd_pkg.display_dist_p()+');
179:
180: arp_ctlgd_pkg.fetch_p(l_dist_rec, p_cust_trx_line_gl_dist_id);
181:
182: arp_ctlgd_pkg.display_dist_rec(l_dist_rec);
183:
184: arp_util.debug('arp_ctlgd_pkg.display_dist_p()-');

Line 182: arp_ctlgd_pkg.display_dist_rec(l_dist_rec);

178: arp_util.debug('arp_ctlgd_pkg.display_dist_p()+');
179:
180: arp_ctlgd_pkg.fetch_p(l_dist_rec, p_cust_trx_line_gl_dist_id);
181:
182: arp_ctlgd_pkg.display_dist_rec(l_dist_rec);
183:
184: arp_util.debug('arp_ctlgd_pkg.display_dist_p()-');
185:
186: EXCEPTION

Line 184: arp_util.debug('arp_ctlgd_pkg.display_dist_p()-');

180: arp_ctlgd_pkg.fetch_p(l_dist_rec, p_cust_trx_line_gl_dist_id);
181:
182: arp_ctlgd_pkg.display_dist_rec(l_dist_rec);
183:
184: arp_util.debug('arp_ctlgd_pkg.display_dist_p()-');
185:
186: EXCEPTION
187: WHEN OTHERS THEN
188: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.display_dist_p()');

Line 188: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.display_dist_p()');

184: arp_util.debug('arp_ctlgd_pkg.display_dist_p()-');
185:
186: EXCEPTION
187: WHEN OTHERS THEN
188: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.display_dist_p()');
189: RAISE;
190:
191: END;
192:

Line 240: arp_util.debug('arp_ctlgd_pkg.display_dist_f_ctls_id()+');

236:
237:
238: BEGIN
239:
240: arp_util.debug('arp_ctlgd_pkg.display_dist_f_ctls_id()+');
241:
242: arp_util.debug('=====================================================' ||
243: '==========================');
244: arp_util.debug('========== ' ||

Line 250: arp_ctlgd_pkg.display_dist_p(l_dist_rec.cust_trx_line_gl_dist_id);

246: to_char( p_cust_trx_line_salesrep_id ) || ' ' ||
247: '==========');
248:
249: FOR l_dist_rec IN srep_cursor LOOP
250: arp_ctlgd_pkg.display_dist_p(l_dist_rec.cust_trx_line_gl_dist_id);
251: END LOOP;
252:
253: arp_util.debug('====== End ' ||
254: 'Dump of ra_cust_trx_line_gl_dist records for ctls: '||

Line 260: arp_util.debug('arp_ctlgd_pkg.display_dist_f_ctls_id()-');

256: '=======');
257: arp_util.debug('=====================================================' ||
258: '==========================');
259:
260: arp_util.debug('arp_ctlgd_pkg.display_dist_f_ctls_id()-');
261:
262: EXCEPTION
263: WHEN OTHERS THEN
264: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.display_dist_f_ctls_id()');

Line 264: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.display_dist_f_ctls_id()');

260: arp_util.debug('arp_ctlgd_pkg.display_dist_f_ctls_id()-');
261:
262: EXCEPTION
263: WHEN OTHERS THEN
264: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.display_dist_f_ctls_id()');
265: RAISE;
266:
267: END;
268:

Line 315: arp_util.debug('arp_ctlgd_pkg.display_dist_f_ct_id()+');

311:
312:
313: BEGIN
314:
315: arp_util.debug('arp_ctlgd_pkg.display_dist_f_ct_id()+');
316:
317: arp_util.debug('=====================================================' ||
318: '==========================');
319: arp_util.debug('========== ' ||

Line 325: arp_ctlgd_pkg.display_dist_p(l_dist_rec.cust_trx_line_gl_dist_id);

321: to_char( p_customer_trx_id ) || ' ' ||
322: '==========');
323:
324: FOR l_dist_rec IN srep_cursor LOOP
325: arp_ctlgd_pkg.display_dist_p(l_dist_rec.cust_trx_line_gl_dist_id);
326: END LOOP;
327:
328: arp_util.debug('====== End ' ||
329: 'Dump of ra_cust_trx_line_gl_dist records for ctid: '||

Line 335: arp_util.debug('arp_ctlgd_pkg.display_dist_f_ct_id()-');

331: '=======');
332: arp_util.debug('=====================================================' ||
333: '==========================');
334:
335: arp_util.debug('arp_ctlgd_pkg.display_dist_f_ct_id()-');
336:
337: EXCEPTION
338: WHEN OTHERS THEN
339: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.display_dist_f_ct_id()');

Line 339: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.display_dist_f_ct_id()');

335: arp_util.debug('arp_ctlgd_pkg.display_dist_f_ct_id()-');
336:
337: EXCEPTION
338: WHEN OTHERS THEN
339: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.display_dist_f_ct_id()');
340: RAISE;
341:
342: END;
343:

Line 391: arp_util.debug('arp_ctlgd_pkg.display_dist_f_ctl_id()+');

387:
388:
389: BEGIN
390:
391: arp_util.debug('arp_ctlgd_pkg.display_dist_f_ctl_id()+');
392:
393: arp_util.debug('=====================================================' ||
394: '==========================');
395: arp_util.debug('========== ' ||

Line 401: arp_ctlgd_pkg.display_dist_p(l_dist_rec.cust_trx_line_gl_dist_id);

397: to_char( p_customer_trx_line_id ) || ' ' ||
398: '==========');
399:
400: FOR l_dist_rec IN dist_cursor LOOP
401: arp_ctlgd_pkg.display_dist_p(l_dist_rec.cust_trx_line_gl_dist_id);
402: END LOOP;
403:
404: arp_util.debug('====== End ' ||
405: 'Dump of ra_cust_trx_line_gl_dist records for ctlid: '||

Line 411: arp_util.debug('arp_ctlgd_pkg.display_dist_f_ctl_id()-');

407: '=======');
408: arp_util.debug('=====================================================' ||
409: '==========================');
410:
411: arp_util.debug('arp_ctlgd_pkg.display_dist_f_ctl_id()-');
412:
413: EXCEPTION
414: WHEN OTHERS THEN
415: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.display_dist_f_ctl_id()');

Line 415: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.display_dist_f_ctl_id()');

411: arp_util.debug('arp_ctlgd_pkg.display_dist_f_ctl_id()-');
412:
413: EXCEPTION
414: WHEN OTHERS THEN
415: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.display_dist_f_ctl_id()');
416: RAISE;
417:
418: END;
419:

Line 834: arp_util.debug('arp_ctlgd_pkg.bind_dist_variables()+');

830: IS
831:
832: BEGIN
833:
834: arp_util.debug('arp_ctlgd_pkg.bind_dist_variables()+');
835:
836: /*------------------+
837: | Dummy constants |
838: +------------------*/

Line 1035: arp_util.debug('arp_ctlgd_pkg.bind_dist_variables()-');

1031: p_dist_rec.program_update_date);
1032: dbms_sql.bind_variable(p_update_cursor, ':ccid_change_flag',
1033: p_dist_rec.ccid_change_flag); /* Bug 8788491 */
1034:
1035: arp_util.debug('arp_ctlgd_pkg.bind_dist_variables()-');
1036:
1037: EXCEPTION
1038: WHEN OTHERS THEN
1039: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.bind_dist_variables()');

Line 1039: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.bind_dist_variables()');

1035: arp_util.debug('arp_ctlgd_pkg.bind_dist_variables()-');
1036:
1037: EXCEPTION
1038: WHEN OTHERS THEN
1039: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.bind_dist_variables()');
1040: RAISE;
1041:
1042: END;
1043:

Line 1079: arp_util.debug('arp_ctlgd_pkg.construct_dist_update_stmt()+');

1075:
1076: PROCEDURE construct_dist_update_stmt( update_text OUT NOCOPY varchar2) IS
1077:
1078: BEGIN
1079: arp_util.debug('arp_ctlgd_pkg.construct_dist_update_stmt()+');
1080:
1081: update_text :=
1082: 'UPDATE ra_cust_trx_line_gl_dist
1083: SET cust_trx_line_gl_dist_id =

Line 1330: arp_util.debug('arp_ctlgd_pkg.construct_dist_update_stmt()-');

1326: :ar_flag_dummy, ccid_change_flag,
1327: :ccid_change_flag)'; /* Bug 8788491 */
1328:
1329:
1330: arp_util.debug('arp_ctlgd_pkg.construct_dist_update_stmt()-');
1331:
1332: EXCEPTION
1333: WHEN OTHERS THEN
1334: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.construct_dist_update_stmt()');

Line 1334: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.construct_dist_update_stmt()');

1330: arp_util.debug('arp_ctlgd_pkg.construct_dist_update_stmt()-');
1331:
1332: EXCEPTION
1333: WHEN OTHERS THEN
1334: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.construct_dist_update_stmt()');
1335: RAISE;
1336:
1337: END;
1338:

Line 1401: arp_util.debug('arp_ctlgd_pkg.generic_update()+');

1397: l_update_statement varchar2(25000);
1398: gl_dist_array dbms_sql.number_table; /* mrc */
1399:
1400: BEGIN
1401: arp_util.debug('arp_ctlgd_pkg.generic_update()+');
1402:
1403: /*--------------------------------------------------------------+
1404: | If this update statement has not already been parsed, |
1405: | construct the statement and parse it. |

Line 1418: arp_ctlgd_pkg.construct_dist_update_stmt(l_update_statement);

1414: /*---------------------------------+
1415: | Construct the update statement |
1416: +---------------------------------*/
1417:
1418: arp_ctlgd_pkg.construct_dist_update_stmt(l_update_statement);
1419:
1420: l_update_statement := l_update_statement || p_where_clause;
1421:
1422: /*--------------------------------------------------------+

Line 1439: arp_ctlgd_pkg.bind_dist_variables(p_update_cursor,

1435: dbms_sql.v7);
1436:
1437: END IF;
1438:
1439: arp_ctlgd_pkg.bind_dist_variables(p_update_cursor,
1440: p_dist_rec,
1441: p_exchange_rate,
1442: p_currency_code,
1443: p_precision,

Line 1501: arp_util.debug('arp_ctlgd_pkg.generic_update()-');

1497: END LOOP;
1498:
1499:
1500:
1501: arp_util.debug('arp_ctlgd_pkg.generic_update()-');
1502:
1503: EXCEPTION
1504: WHEN OTHERS THEN
1505: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.generic_update()');

Line 1505: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.generic_update()');

1501: arp_util.debug('arp_ctlgd_pkg.generic_update()-');
1502:
1503: EXCEPTION
1504: WHEN OTHERS THEN
1505: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.generic_update()');
1506: arp_util.debug(l_update_statement);
1507: arp_util.debug('Error at character: ' ||
1508: to_char(dbms_sql.last_error_position));
1509: RAISE;

Line 1646: arp_util.debug('arp_ctlgd_pkg.lock_p()+');

1642: l_cust_trx_line_gl_dist_id
1643: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type;
1644:
1645: BEGIN
1646: arp_util.debug('arp_ctlgd_pkg.lock_p()+');
1647:
1648:
1649: SELECT cust_trx_line_gl_dist_id
1650: INTO l_cust_trx_line_gl_dist_id

Line 1655: arp_util.debug('arp_ctlgd_pkg.lock_p()-');

1651: FROM ra_cust_trx_line_gl_dist
1652: WHERE cust_trx_line_gl_dist_id = p_cust_trx_line_gl_dist_id
1653: FOR UPDATE OF cust_trx_line_gl_dist_id NOWAIT;
1654:
1655: arp_util.debug('arp_ctlgd_pkg.lock_p()-');
1656:
1657: EXCEPTION
1658: WHEN OTHERS THEN
1659: arp_util.debug( 'EXCEPTION: arp_ctlgd_pkg.lock_p' );

Line 1659: arp_util.debug( 'EXCEPTION: arp_ctlgd_pkg.lock_p' );

1655: arp_util.debug('arp_ctlgd_pkg.lock_p()-');
1656:
1657: EXCEPTION
1658: WHEN OTHERS THEN
1659: arp_util.debug( 'EXCEPTION: arp_ctlgd_pkg.lock_p' );
1660: RAISE;
1661: END;
1662:
1663: /*===========================================================================+

Line 1711: arp_util.debug('arp_ctlgd_pkg.lock_f_ct_id()+');

1707: FOR UPDATE OF cust_trx_line_gl_dist_id NOWAIT;
1708:
1709:
1710: BEGIN
1711: arp_util.debug('arp_ctlgd_pkg.lock_f_ct_id()+');
1712:
1713: OPEN lock_c;
1714: CLOSE lock_c;
1715:

Line 1716: arp_util.debug('arp_ctlgd_pkg.lock_f_ct_id()-');

1712:
1713: OPEN lock_c;
1714: CLOSE lock_c;
1715:
1716: arp_util.debug('arp_ctlgd_pkg.lock_f_ct_id()-');
1717:
1718: EXCEPTION
1719: WHEN OTHERS THEN
1720: arp_util.debug( 'EXCEPTION: arp_ctlgd_pkg.lock_f_ct_id' );

Line 1720: arp_util.debug( 'EXCEPTION: arp_ctlgd_pkg.lock_f_ct_id' );

1716: arp_util.debug('arp_ctlgd_pkg.lock_f_ct_id()-');
1717:
1718: EXCEPTION
1719: WHEN OTHERS THEN
1720: arp_util.debug( 'EXCEPTION: arp_ctlgd_pkg.lock_f_ct_id' );
1721: RAISE;
1722: END;
1723:
1724: /*===========================================================================+

Line 1770: arp_util.debug('arp_ctlgd_pkg.lock_f_ctl_id()+');

1766: AND account_class = nvl(p_account_class, account_class)
1767: FOR UPDATE OF cust_trx_line_gl_dist_id NOWAIT;
1768:
1769: BEGIN
1770: arp_util.debug('arp_ctlgd_pkg.lock_f_ctl_id()+');
1771:
1772: OPEN lock_c;
1773: CLOSE lock_c;
1774:

Line 1775: arp_util.debug('arp_ctlgd_pkg.lock_f_ctl_id()-');

1771:
1772: OPEN lock_c;
1773: CLOSE lock_c;
1774:
1775: arp_util.debug('arp_ctlgd_pkg.lock_f_ctl_id()-');
1776:
1777: EXCEPTION
1778: WHEN OTHERS THEN
1779: arp_util.debug( 'EXCEPTION: arp_ctlgd_pkg.lock_f_ctl_id' );

Line 1779: arp_util.debug( 'EXCEPTION: arp_ctlgd_pkg.lock_f_ctl_id' );

1775: arp_util.debug('arp_ctlgd_pkg.lock_f_ctl_id()-');
1776:
1777: EXCEPTION
1778: WHEN OTHERS THEN
1779: arp_util.debug( 'EXCEPTION: arp_ctlgd_pkg.lock_f_ctl_id' );
1780: RAISE;
1781: END;
1782:
1783:

Line 1830: arp_util.debug('arp_ctlgd_pkg.lock_f_ctls_id()+');

1826: AND account_class = nvl(p_account_class, account_class)
1827: FOR UPDATE OF cust_trx_line_gl_dist_id NOWAIT;
1828:
1829: BEGIN
1830: arp_util.debug('arp_ctlgd_pkg.lock_f_ctls_id()+');
1831:
1832: OPEN lock_c;
1833: CLOSE lock_c;
1834:

Line 1835: arp_util.debug('arp_ctlgd_pkg.lock_f_ctls_id()-');

1831:
1832: OPEN lock_c;
1833: CLOSE lock_c;
1834:
1835: arp_util.debug('arp_ctlgd_pkg.lock_f_ctls_id()-');
1836:
1837: EXCEPTION
1838: WHEN OTHERS THEN
1839: arp_util.debug( 'EXCEPTION: arp_ctlgd_pkg.lock_f_ctls_id' );

Line 1839: arp_util.debug( 'EXCEPTION: arp_ctlgd_pkg.lock_f_ctls_id' );

1835: arp_util.debug('arp_ctlgd_pkg.lock_f_ctls_id()-');
1836:
1837: EXCEPTION
1838: WHEN OTHERS THEN
1839: arp_util.debug( 'EXCEPTION: arp_ctlgd_pkg.lock_f_ctls_id' );
1840: RAISE;
1841: END;
1842:
1843: /*===========================================================================+

Line 1877: arp_util.debug('arp_ctlgd_pkg.lock_fetch_p()+');

1873: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type
1874: ) IS
1875:
1876: BEGIN
1877: arp_util.debug('arp_ctlgd_pkg.lock_fetch_p()+');
1878:
1879: SELECT *
1880: INTO p_dist_rec
1881: FROM ra_cust_trx_line_gl_dist

Line 1885: arp_util.debug('arp_ctlgd_pkg.lock_fetch_p()-');

1881: FROM ra_cust_trx_line_gl_dist
1882: WHERE cust_trx_line_gl_dist_id = p_cust_trx_line_gl_dist_id
1883: FOR UPDATE OF cust_trx_line_gl_dist_id NOWAIT;
1884:
1885: arp_util.debug('arp_ctlgd_pkg.lock_fetch_p()-');
1886:
1887: EXCEPTION
1888: WHEN OTHERS THEN
1889: arp_util.debug( 'EXCEPTION: arp_ctlgd_pkg.lock_fetch_p' );

Line 1889: arp_util.debug( 'EXCEPTION: arp_ctlgd_pkg.lock_fetch_p' );

1885: arp_util.debug('arp_ctlgd_pkg.lock_fetch_p()-');
1886:
1887: EXCEPTION
1888: WHEN OTHERS THEN
1889: arp_util.debug( 'EXCEPTION: arp_ctlgd_pkg.lock_fetch_p' );
1890: RAISE;
1891: END;
1892:
1893: /*===========================================================================+

Line 1935: arp_util.debug('arp_ctlgd_pkg.lock_compare_p()+');

1931: l_temp_dist_rec ra_cust_trx_line_gl_dist%rowtype;
1932: l_ignore_who_flag varchar2(2);
1933:
1934: BEGIN
1935: arp_util.debug('arp_ctlgd_pkg.lock_compare_p()+');
1936:
1937: IF (p_ignore_who_flag = TRUE)
1938: THEN l_ignore_who_flag := 'Y';
1939: ELSE l_ignore_who_flag := 'N';

Line 2365: arp_util.debug('arp_ctlgd_pkg.lock_compare_p()-');

2361: ) /* Bug 8788491 */
2362: )
2363: FOR UPDATE OF cust_trx_line_gl_dist_id NOWAIT;
2364:
2365: arp_util.debug('arp_ctlgd_pkg.lock_compare_p()-');
2366:
2367: EXCEPTION
2368: WHEN NO_DATA_FOUND THEN
2369:

Line 2390: arp_util.debug( 'EXCEPTION: arp_ctlgd_pkg.lock_compare_p' );

2386: APP_EXCEPTION.Raise_Exception;
2387:
2388:
2389: WHEN OTHERS THEN
2390: arp_util.debug( 'EXCEPTION: arp_ctlgd_pkg.lock_compare_p' );
2391:
2392: arp_util.debug( SQLERRM );
2393:
2394: arp_util.debug('----- parameters for lock_compare_p -----');

Line 2565: arp_util.debug('arp_ctlgd_pkg.lock_compare_cover()+',

2561:
2562: BEGIN
2563:
2564: IF PG_DEBUG in ('Y', 'C') THEN
2565: arp_util.debug('arp_ctlgd_pkg.lock_compare_cover()+',
2566: pg_msg_level_debug);
2567: END IF;
2568:
2569: /*------------------------------------------------+

Line 2625: arp_util.debug('arp_ctlgd_pkg.lock_compare_cover()-',

2621: TRUE -- ignore who columns
2622: );
2623:
2624: IF PG_DEBUG in ('Y', 'C') THEN
2625: arp_util.debug('arp_ctlgd_pkg.lock_compare_cover()-',
2626: pg_msg_level_debug);
2627: END IF;
2628:
2629: EXCEPTION

Line 2633: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.lock_compare_cover()',

2629: EXCEPTION
2630: WHEN OTHERS THEN
2631:
2632: IF PG_DEBUG in ('Y', 'C') THEN
2633: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.lock_compare_cover()',
2634: pg_msg_level_debug);
2635: arp_util.debug('lock_compare_cover: ' || '------- parameters for lock_compare_cove() ' ||
2636: '---------',
2637: pg_msg_level_debug);

Line 2754: arp_util.debug('arp_ctlgd_pkg.fetch_p()+');

2750: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type)
2751: IS
2752:
2753: BEGIN
2754: arp_util.debug('arp_ctlgd_pkg.fetch_p()+');
2755:
2756: SELECT *
2757: INTO p_dist_rec
2758: FROM ra_cust_trx_line_gl_dist

Line 2761: arp_util.debug('arp_ctlgd_pkg.fetch_p()-');

2757: INTO p_dist_rec
2758: FROM ra_cust_trx_line_gl_dist
2759: WHERE cust_trx_line_gl_dist_id = p_cust_trx_line_gl_dist_id;
2760:
2761: arp_util.debug('arp_ctlgd_pkg.fetch_p()-');
2762:
2763: EXCEPTION
2764: WHEN OTHERS THEN
2765: arp_util.debug( 'EXCEPTION: arp_ctlgd_pkg.fetch_p' );

Line 2765: arp_util.debug( 'EXCEPTION: arp_ctlgd_pkg.fetch_p' );

2761: arp_util.debug('arp_ctlgd_pkg.fetch_p()-');
2762:
2763: EXCEPTION
2764: WHEN OTHERS THEN
2765: arp_util.debug( 'EXCEPTION: arp_ctlgd_pkg.fetch_p' );
2766: RAISE;
2767: END;
2768:
2769:

Line 2808: arp_util.debug('arp_ctlgd_pkg.delete_p()+');

2804:
2805: BEGIN
2806:
2807:
2808: arp_util.debug('arp_ctlgd_pkg.delete_p()+');
2809:
2810: DELETE FROM ra_cust_trx_line_gl_dist
2811: WHERE cust_trx_line_gl_dist_id = p_cust_trx_line_gl_dist_id;
2812:

Line 2814: THEN arp_util.debug('EXCEPTION: arp_ctlgd_pkg.delete_p()');

2810: DELETE FROM ra_cust_trx_line_gl_dist
2811: WHERE cust_trx_line_gl_dist_id = p_cust_trx_line_gl_dist_id;
2812:
2813: IF ( SQL%ROWCOUNT = 0 )
2814: THEN arp_util.debug('EXCEPTION: arp_ctlgd_pkg.delete_p()');
2815: RAISE NO_DATA_FOUND;
2816: END IF;
2817:
2818: /* call mrc api to delete */

Line 2827: arp_util.debug('arp_ctlgd_pkg.delete_p()-');

2823: p_mode => 'SINGLE',
2824: p_key_value => p_cust_trx_line_gl_dist_id);
2825:
2826:
2827: arp_util.debug('arp_ctlgd_pkg.delete_p()-');
2828:
2829: EXCEPTION
2830: WHEN OTHERS THEN
2831: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.delete_p()');

Line 2831: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.delete_p()');

2827: arp_util.debug('arp_ctlgd_pkg.delete_p()-');
2828:
2829: EXCEPTION
2830: WHEN OTHERS THEN
2831: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.delete_p()');
2832:
2833: RAISE;
2834:
2835: END;

Line 2881: arp_util.debug('arp_ctlgd_pkg.delete_f_ct_id()+');

2877: l_gl_dist_key_value_list gl_ca_utility_pkg.r_key_value_arr;
2878:
2879: BEGIN
2880:
2881: arp_util.debug('arp_ctlgd_pkg.delete_f_ct_id()+');
2882:
2883: DELETE FROM ra_cust_trx_line_gl_dist
2884: WHERE customer_trx_id = p_customer_trx_id
2885: AND account_set_flag = nvl(p_account_set_flag, account_set_flag)

Line 2896: arp_util.debug('arp_ctlgd_pkg.delete_f_ct_id()-');

2892: p_mode => 'BATCH',
2893: p_key_value_list => l_gl_dist_key_value_list);
2894:
2895:
2896: arp_util.debug('arp_ctlgd_pkg.delete_f_ct_id()-');
2897:
2898: EXCEPTION
2899: WHEN OTHERS THEN
2900: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.delete_f_ct_id()');

Line 2900: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.delete_f_ct_id()');

2896: arp_util.debug('arp_ctlgd_pkg.delete_f_ct_id()-');
2897:
2898: EXCEPTION
2899: WHEN OTHERS THEN
2900: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.delete_f_ct_id()');
2901:
2902: RAISE;
2903:
2904: END;

Line 2953: arp_util.debug('arp_ctlgd_pkg.delete_f_ctl_id()+');

2949:
2950: BEGIN
2951:
2952:
2953: arp_util.debug('arp_ctlgd_pkg.delete_f_ctl_id()+');
2954:
2955: DELETE FROM ra_cust_trx_line_gl_dist
2956: WHERE customer_trx_line_id = p_customer_trx_line_id
2957: AND account_set_flag = nvl(p_account_set_flag, account_set_flag)

Line 2996: arp_util.debug('arp_ctlgd_pkg.delete_f_ctl_id()-');

2992: p_table_name => 'RA_CUST_TRX_LINE_GL_DIST',
2993: p_mode => 'BATCH',
2994: p_key_value_list => l_gl_dist_key_value_list);
2995:
2996: arp_util.debug('arp_ctlgd_pkg.delete_f_ctl_id()-');
2997:
2998: EXCEPTION
2999: WHEN OTHERS THEN
3000: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.delete_f_ctl_id()');

Line 3000: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.delete_f_ctl_id()');

2996: arp_util.debug('arp_ctlgd_pkg.delete_f_ctl_id()-');
2997:
2998: EXCEPTION
2999: WHEN OTHERS THEN
3000: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.delete_f_ctl_id()');
3001:
3002: RAISE;
3003:
3004: END;

Line 3050: arp_util.debug('arp_ctlgd_pkg.delete_f_ctls_id()+');

3046: l_gl_dist_key_value_list gl_ca_utility_pkg.r_key_value_arr;
3047:
3048: BEGIN
3049:
3050: arp_util.debug('arp_ctlgd_pkg.delete_f_ctls_id()+');
3051:
3052: DELETE FROM ra_cust_trx_line_gl_dist
3053: WHERE cust_trx_line_salesrep_id = p_cust_trx_line_salesrep_id
3054: AND account_set_flag = nvl(p_account_set_flag, account_set_flag)

Line 3067: arp_util.debug('arp_ctlgd_pkg.delete_f_ctls_id()-');

3063: p_mode => 'BATCH',
3064: p_key_value_list => l_gl_dist_key_value_list);
3065:
3066:
3067: arp_util.debug('arp_ctlgd_pkg.delete_f_ctls_id()-');
3068:
3069: EXCEPTION
3070: WHEN OTHERS THEN
3071: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.delete_f_ctls_id()');

Line 3071: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.delete_f_ctls_id()');

3067: arp_util.debug('arp_ctlgd_pkg.delete_f_ctls_id()-');
3068:
3069: EXCEPTION
3070: WHEN OTHERS THEN
3071: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.delete_f_ctls_id()');
3072:
3073: RAISE;
3074:
3075: END;

Line 3129: arp_util.debug('arp_ctlgd_pkg.delete_f_ct_ltctl_id_type()+');

3125: l_acctd_amt NUMBER := 0;
3126:
3127: BEGIN
3128:
3129: arp_util.debug('arp_ctlgd_pkg.delete_f_ct_ltctl_id_type()+');
3130:
3131: DELETE FROM ra_cust_trx_line_gl_dist
3132: WHERE customer_trx_id = p_customer_trx_id
3133: AND customer_trx_line_id in

Line 3169: arp_util.debug('arp_ctlgd_pkg.delete_f_ct_ltctl_id_type()-');

3165: WHERE customer_trx_id = p_customer_trx_id
3166: and account_class = 'REC'
3167: and account_set_flag = 'N';
3168:
3169: arp_util.debug('arp_ctlgd_pkg.delete_f_ct_ltctl_id_type()-');
3170:
3171: EXCEPTION
3172: WHEN OTHERS THEN
3173: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.delete_f_ct_ltctl_id_type()');

Line 3173: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.delete_f_ct_ltctl_id_type()');

3169: arp_util.debug('arp_ctlgd_pkg.delete_f_ct_ltctl_id_type()-');
3170:
3171: EXCEPTION
3172: WHEN OTHERS THEN
3173: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.delete_f_ct_ltctl_id_type()');
3174:
3175: RAISE;
3176:
3177: END;

Line 3232: arp_util.debug('arp_ctlgd_pkg.update_p()+ ' ||

3228: l_where varchar2(500);
3229:
3230: BEGIN
3231:
3232: arp_util.debug('arp_ctlgd_pkg.update_p()+ ' ||
3233: to_char(sysdate, 'HH:MI:SS'));
3234:
3235: l_where := ' WHERE cust_trx_line_gl_dist_id = :where_1 ' ||
3236: 'AND account_set_flag = nvl(:where_account_set_flag, '||

Line 3241: arp_ctlgd_pkg.generic_update( pg_cursor1,

3237: 'account_set_flag) ' ||
3238: 'AND account_class = nvl(:where_account_class, account_class)';
3239:
3240:
3241: arp_ctlgd_pkg.generic_update( pg_cursor1,
3242: l_where,
3243: p_cust_trx_line_gl_dist_id,
3244: null,
3245: null,

Line 3252: arp_util.debug('arp_ctlgd_pkg.update_p()- ' ||

3248: p_precision,
3249: p_mau,
3250: p_dist_rec);
3251:
3252: arp_util.debug('arp_ctlgd_pkg.update_p()- ' ||
3253: to_char(sysdate, 'HH:MI:SS'));
3254:
3255:
3256: EXCEPTION

Line 3258: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.update_p()');

3254:
3255:
3256: EXCEPTION
3257: WHEN OTHERS THEN
3258: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.update_p()');
3259: RAISE;
3260: END;
3261:
3262:

Line 3320: arp_util.debug('arp_ctlgd_pkg.update_f_ct_id()+ ' ||

3316: l_where varchar2(500);
3317:
3318: BEGIN
3319:
3320: arp_util.debug('arp_ctlgd_pkg.update_f_ct_id()+ ' ||
3321: to_char(sysdate, 'HH:MI:SS'));
3322:
3323: l_where := ' WHERE customer_trx_id = :where_1 ' ||
3324: 'AND account_set_flag = nvl(:where_account_set_flag, '||

Line 3328: arp_ctlgd_pkg.generic_update( pg_cursor2,

3324: 'AND account_set_flag = nvl(:where_account_set_flag, '||
3325: 'account_set_flag) ' ||
3326: 'AND account_class = nvl(:where_account_class, account_class)';
3327:
3328: arp_ctlgd_pkg.generic_update( pg_cursor2,
3329: l_where,
3330: p_customer_trx_id,
3331: p_account_set_flag,
3332: p_account_class,

Line 3339: arp_util.debug('arp_ctlgd_pkg.update_f_ct_id()- ' ||

3335: p_precision,
3336: p_mau,
3337: p_dist_rec);
3338:
3339: arp_util.debug('arp_ctlgd_pkg.update_f_ct_id()- ' ||
3340: to_char(sysdate, 'HH:MI:SS'));
3341:
3342:
3343: EXCEPTION

Line 3345: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.update_f_ct_id()');

3341:
3342:
3343: EXCEPTION
3344: WHEN OTHERS THEN
3345: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.update_f_ct_id()');
3346: RAISE;
3347: END;
3348:
3349:

Line 3408: arp_util.debug('arp_ctlgd_pkg.update_f_ctl_id()+ ' ||

3404: l_where varchar2(500);
3405:
3406: BEGIN
3407:
3408: arp_util.debug('arp_ctlgd_pkg.update_f_ctl_id()+ ' ||
3409: to_char(sysdate, 'HH:MI:SS'));
3410:
3411: l_where := ' WHERE customer_trx_line_id = :where_1 ' ||
3412: 'AND account_set_flag = nvl(:where_account_set_flag, '||

Line 3417: arp_ctlgd_pkg.generic_update( pg_cursor3,

3413: 'account_set_flag) ' ||
3414: 'AND account_class = nvl(:where_account_class, account_class)';
3415:
3416:
3417: arp_ctlgd_pkg.generic_update( pg_cursor3,
3418: l_where,
3419: p_customer_trx_line_id,
3420: p_account_set_flag,
3421: p_account_class,

Line 3428: arp_util.debug('arp_ctlgd_pkg.update_f_ctl_id()- ' ||

3424: p_precision,
3425: p_mau,
3426: p_dist_rec);
3427:
3428: arp_util.debug('arp_ctlgd_pkg.update_f_ctl_id()- ' ||
3429: to_char(sysdate, 'HH:MI:SS'));
3430:
3431:
3432: EXCEPTION

Line 3434: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.update_f_ctl_id()');

3430:
3431:
3432: EXCEPTION
3433: WHEN OTHERS THEN
3434: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.update_f_ctl_id()');
3435: RAISE;
3436: END;
3437:
3438: /*===========================================================================+

Line 3496: arp_util.debug('arp_ctlgd_pkg.update_f_ctls_id()+ ' ||

3492: l_where varchar2(500);
3493:
3494: BEGIN
3495:
3496: arp_util.debug('arp_ctlgd_pkg.update_f_ctls_id()+ ' ||
3497: to_char(sysdate, 'HH:MI:SS'));
3498:
3499: l_where := ' WHERE cust_trx_line_salesrep_id = :where_1 ' ||
3500: 'AND account_set_flag = nvl(:where_account_set_flag, '||

Line 3504: arp_ctlgd_pkg.generic_update( pg_cursor4,

3500: 'AND account_set_flag = nvl(:where_account_set_flag, '||
3501: 'account_set_flag) ' ||
3502: 'AND account_class = nvl(:where_account_class, account_class)';
3503:
3504: arp_ctlgd_pkg.generic_update( pg_cursor4,
3505: l_where,
3506: p_cust_trx_line_salesrep_id,
3507: p_account_set_flag,
3508: p_account_class,

Line 3515: arp_util.debug('arp_ctlgd_pkg.update_f_ctls_id()- ' ||

3511: p_precision,
3512: p_mau,
3513: p_dist_rec);
3514:
3515: arp_util.debug('arp_ctlgd_pkg.update_f_ctls_id()- ' ||
3516: to_char(sysdate, 'HH:MI:SS'));
3517:
3518:
3519: EXCEPTION

Line 3521: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.update_f_ctls_id()');

3517:
3518:
3519: EXCEPTION
3520: WHEN OTHERS THEN
3521: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.update_f_ctls_id()');
3522: RAISE;
3523: END;
3524:
3525:

Line 3578: arp_util.debug('arp_ctlgd_pkg.update_acctd_amount()+');

3574: l_gl_dist_key_value_list gl_ca_utility_pkg.r_key_value_arr;
3575:
3576: BEGIN
3577:
3578: arp_util.debug('arp_ctlgd_pkg.update_acctd_amount()+');
3579:
3580: update ra_cust_trx_line_gl_dist
3581: set last_updated_by = pg_user_id,
3582: last_update_date = sysdate,

Line 3606: arp_util.debug('arp_ctlgd_pkg.update_acctd_amount()-');

3602: p_mode => 'BATCH',
3603: p_key_value_list => l_gl_dist_key_value_list);
3604: END IF;
3605:
3606: arp_util.debug('arp_ctlgd_pkg.update_acctd_amount()-');
3607:
3608: EXCEPTION
3609: WHEN NO_DATA_FOUND THEN
3610: arp_util.debug('arp_ctlgd_pkg.update_acctd_amount()-');

Line 3610: arp_util.debug('arp_ctlgd_pkg.update_acctd_amount()-');

3606: arp_util.debug('arp_ctlgd_pkg.update_acctd_amount()-');
3607:
3608: EXCEPTION
3609: WHEN NO_DATA_FOUND THEN
3610: arp_util.debug('arp_ctlgd_pkg.update_acctd_amount()-');
3611: WHEN OTHERS THEN
3612: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.update_acctd_amount()');
3613: RAISE;
3614: END;

Line 3612: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.update_acctd_amount()');

3608: EXCEPTION
3609: WHEN NO_DATA_FOUND THEN
3610: arp_util.debug('arp_ctlgd_pkg.update_acctd_amount()-');
3611: WHEN OTHERS THEN
3612: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.update_acctd_amount()');
3613: RAISE;
3614: END;
3615:
3616: /*===========================================================================+

Line 3674: arp_util.debug('arp_ctlgd_pkg.update_amount_f_ctl_id()+');

3670: l_gl_dist_key_value_list gl_ca_utility_pkg.r_key_value_arr;
3671:
3672: BEGIN
3673:
3674: arp_util.debug('arp_ctlgd_pkg.update_amount_f_ctl_id()+');
3675:
3676: UPDATE ra_cust_trx_line_gl_dist
3677: SET last_updated_by = pg_user_id,
3678: last_update_date = sysdate,

Line 3710: arp_util.debug('arp_ctlgd_pkg.update_amount_f_ctl_id()-');

3706: p_mode => 'BATCH',
3707: p_key_value_list => l_gl_dist_key_value_list);
3708: END IF;
3709: END IF;
3710: arp_util.debug('arp_ctlgd_pkg.update_amount_f_ctl_id()-');
3711:
3712: EXCEPTION
3713: WHEN NO_DATA_FOUND THEN
3714: arp_util.debug('arp_ctlgd_pkg.update_amount_f_ctl_id()-');

Line 3714: arp_util.debug('arp_ctlgd_pkg.update_amount_f_ctl_id()-');

3710: arp_util.debug('arp_ctlgd_pkg.update_amount_f_ctl_id()-');
3711:
3712: EXCEPTION
3713: WHEN NO_DATA_FOUND THEN
3714: arp_util.debug('arp_ctlgd_pkg.update_amount_f_ctl_id()-');
3715: WHEN OTHERS THEN
3716: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.update_amount_f_ctl_id()');
3717: RAISE;
3718: END;

Line 3716: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.update_amount_f_ctl_id()');

3712: EXCEPTION
3713: WHEN NO_DATA_FOUND THEN
3714: arp_util.debug('arp_ctlgd_pkg.update_amount_f_ctl_id()-');
3715: WHEN OTHERS THEN
3716: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.update_amount_f_ctl_id()');
3717: RAISE;
3718: END;
3719:
3720:

Line 3783: arp_util.debug('arp_ctlgd_pkg.insert_p()+');

3779:
3780:
3781: BEGIN
3782:
3783: arp_util.debug('arp_ctlgd_pkg.insert_p()+');
3784:
3785: p_cust_trx_line_gl_dist_id := '';
3786:
3787: /*---------------------------*

Line 3931: arp_util.debug('arp_ctlgd_pkg.insert_p()-');

3927: p_table_name => 'RA_CUST_TRX_LINE_GL_DIST',
3928: p_mode => 'SINGLE',
3929: p_key_value => p_cust_trx_line_gl_dist_id);
3930:
3931: arp_util.debug('arp_ctlgd_pkg.insert_p()-');
3932:
3933: EXCEPTION
3934: WHEN OTHERS THEN
3935: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.insert_p()');

Line 3935: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.insert_p()');

3931: arp_util.debug('arp_ctlgd_pkg.insert_p()-');
3932:
3933: EXCEPTION
3934: WHEN OTHERS THEN
3935: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.insert_p()');
3936: RAISE;
3937: END;
3938:
3939: /*===========================================================================+

Line 4009: arp_util.debug('arp_ctlgd_pkg.select_summary()+');

4005:
4006: BEGIN
4007:
4008: IF PG_DEBUG in ('Y', 'C') THEN
4009: arp_util.debug('arp_ctlgd_pkg.select_summary()+');
4010: END IF;
4011:
4012: SELECT NVL( SUM( NVL(amount, 0) ), 0),
4013: NVL( SUM( NVL(amount, 0) ), 0),

Line 4061: arp_util.debug('arp_ctlgd_pkg.select_summary()-');

4057: NVL( cust_trx_line_salesrep_id, -10) )
4058: AND account_set_flag = p_account_set_flag;
4059:
4060: IF PG_DEBUG in ('Y', 'C') THEN
4061: arp_util.debug('arp_ctlgd_pkg.select_summary()-');
4062: END IF;
4063:
4064: EXCEPTION
4065: WHEN OTHERS THEN

Line 4067: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.select_summary()');

4063:
4064: EXCEPTION
4065: WHEN OTHERS THEN
4066: IF PG_DEBUG in ('Y', 'C') THEN
4067: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.select_summary()');
4068: END IF;
4069: RAISE;
4070:
4071: END select_summary;

Line 4088: END ARP_CTLGD_PKG;

4084: pg_conc_program_id := fnd_global.conc_program_id;
4085:
4086: pg_msg_level_debug := arp_global.MSG_LEVEL_DEBUG;
4087:
4088: END ARP_CTLGD_PKG;