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.12.12000000.4 2007/10/23 20:08:30 mraymond 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 1034: arp_util.debug('arp_ctlgd_pkg.bind_dist_variables()-');

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

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

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

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

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

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

1321: :ar_date_dummy, program_update_date,
1322: :program_update_date)';
1323:
1324:
1325: arp_util.debug('arp_ctlgd_pkg.construct_dist_update_stmt()-');
1326:
1327: EXCEPTION
1328: WHEN OTHERS THEN
1329: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.construct_dist_update_stmt()');

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

1325: arp_util.debug('arp_ctlgd_pkg.construct_dist_update_stmt()-');
1326:
1327: EXCEPTION
1328: WHEN OTHERS THEN
1329: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.construct_dist_update_stmt()');
1330: RAISE;
1331:
1332: END;
1333:

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

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

Line 1413: arp_ctlgd_pkg.construct_dist_update_stmt(l_update_statement);

1409: /*---------------------------------+
1410: | Construct the update statement |
1411: +---------------------------------*/
1412:
1413: arp_ctlgd_pkg.construct_dist_update_stmt(l_update_statement);
1414:
1415: l_update_statement := l_update_statement || p_where_clause;
1416:
1417: /*--------------------------------------------------------+

Line 1434: arp_ctlgd_pkg.bind_dist_variables(p_update_cursor,

1430: dbms_sql.v7);
1431:
1432: END IF;
1433:
1434: arp_ctlgd_pkg.bind_dist_variables(p_update_cursor,
1435: p_dist_rec,
1436: p_exchange_rate,
1437: p_currency_code,
1438: p_precision,

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

1492: END LOOP;
1493:
1494:
1495:
1496: arp_util.debug('arp_ctlgd_pkg.generic_update()-');
1497:
1498: EXCEPTION
1499: WHEN OTHERS THEN
1500: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.generic_update()');

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

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

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

1637: l_cust_trx_line_gl_dist_id
1638: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type;
1639:
1640: BEGIN
1641: arp_util.debug('arp_ctlgd_pkg.lock_p()+');
1642:
1643:
1644: SELECT cust_trx_line_gl_dist_id
1645: INTO l_cust_trx_line_gl_dist_id

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

1646: FROM ra_cust_trx_line_gl_dist
1647: WHERE cust_trx_line_gl_dist_id = p_cust_trx_line_gl_dist_id
1648: FOR UPDATE OF cust_trx_line_gl_dist_id NOWAIT;
1649:
1650: arp_util.debug('arp_ctlgd_pkg.lock_p()-');
1651:
1652: EXCEPTION
1653: WHEN OTHERS THEN
1654: arp_util.debug( 'EXCEPTION: arp_ctlgd_pkg.lock_p' );

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

1650: arp_util.debug('arp_ctlgd_pkg.lock_p()-');
1651:
1652: EXCEPTION
1653: WHEN OTHERS THEN
1654: arp_util.debug( 'EXCEPTION: arp_ctlgd_pkg.lock_p' );
1655: RAISE;
1656: END;
1657:
1658: /*===========================================================================+

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

1702: FOR UPDATE OF cust_trx_line_gl_dist_id NOWAIT;
1703:
1704:
1705: BEGIN
1706: arp_util.debug('arp_ctlgd_pkg.lock_f_ct_id()+');
1707:
1708: OPEN lock_c;
1709: CLOSE lock_c;
1710:

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

1707:
1708: OPEN lock_c;
1709: CLOSE lock_c;
1710:
1711: arp_util.debug('arp_ctlgd_pkg.lock_f_ct_id()-');
1712:
1713: EXCEPTION
1714: WHEN OTHERS THEN
1715: arp_util.debug( 'EXCEPTION: arp_ctlgd_pkg.lock_f_ct_id' );

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

1711: arp_util.debug('arp_ctlgd_pkg.lock_f_ct_id()-');
1712:
1713: EXCEPTION
1714: WHEN OTHERS THEN
1715: arp_util.debug( 'EXCEPTION: arp_ctlgd_pkg.lock_f_ct_id' );
1716: RAISE;
1717: END;
1718:
1719: /*===========================================================================+

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

1761: AND account_class = nvl(p_account_class, account_class)
1762: FOR UPDATE OF cust_trx_line_gl_dist_id NOWAIT;
1763:
1764: BEGIN
1765: arp_util.debug('arp_ctlgd_pkg.lock_f_ctl_id()+');
1766:
1767: OPEN lock_c;
1768: CLOSE lock_c;
1769:

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

1766:
1767: OPEN lock_c;
1768: CLOSE lock_c;
1769:
1770: arp_util.debug('arp_ctlgd_pkg.lock_f_ctl_id()-');
1771:
1772: EXCEPTION
1773: WHEN OTHERS THEN
1774: arp_util.debug( 'EXCEPTION: arp_ctlgd_pkg.lock_f_ctl_id' );

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

1770: arp_util.debug('arp_ctlgd_pkg.lock_f_ctl_id()-');
1771:
1772: EXCEPTION
1773: WHEN OTHERS THEN
1774: arp_util.debug( 'EXCEPTION: arp_ctlgd_pkg.lock_f_ctl_id' );
1775: RAISE;
1776: END;
1777:
1778:

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

1821: AND account_class = nvl(p_account_class, account_class)
1822: FOR UPDATE OF cust_trx_line_gl_dist_id NOWAIT;
1823:
1824: BEGIN
1825: arp_util.debug('arp_ctlgd_pkg.lock_f_ctls_id()+');
1826:
1827: OPEN lock_c;
1828: CLOSE lock_c;
1829:

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

1826:
1827: OPEN lock_c;
1828: CLOSE lock_c;
1829:
1830: arp_util.debug('arp_ctlgd_pkg.lock_f_ctls_id()-');
1831:
1832: EXCEPTION
1833: WHEN OTHERS THEN
1834: arp_util.debug( 'EXCEPTION: arp_ctlgd_pkg.lock_f_ctls_id' );

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

1830: arp_util.debug('arp_ctlgd_pkg.lock_f_ctls_id()-');
1831:
1832: EXCEPTION
1833: WHEN OTHERS THEN
1834: arp_util.debug( 'EXCEPTION: arp_ctlgd_pkg.lock_f_ctls_id' );
1835: RAISE;
1836: END;
1837:
1838: /*===========================================================================+

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

1868: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type
1869: ) IS
1870:
1871: BEGIN
1872: arp_util.debug('arp_ctlgd_pkg.lock_fetch_p()+');
1873:
1874: SELECT *
1875: INTO p_dist_rec
1876: FROM ra_cust_trx_line_gl_dist

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

1876: FROM ra_cust_trx_line_gl_dist
1877: WHERE cust_trx_line_gl_dist_id = p_cust_trx_line_gl_dist_id
1878: FOR UPDATE OF cust_trx_line_gl_dist_id NOWAIT;
1879:
1880: arp_util.debug('arp_ctlgd_pkg.lock_fetch_p()-');
1881:
1882: EXCEPTION
1883: WHEN OTHERS THEN
1884: arp_util.debug( 'EXCEPTION: arp_ctlgd_pkg.lock_fetch_p' );

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

1880: arp_util.debug('arp_ctlgd_pkg.lock_fetch_p()-');
1881:
1882: EXCEPTION
1883: WHEN OTHERS THEN
1884: arp_util.debug( 'EXCEPTION: arp_ctlgd_pkg.lock_fetch_p' );
1885: RAISE;
1886: END;
1887:
1888: /*===========================================================================+

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

1926: l_temp_dist_rec ra_cust_trx_line_gl_dist%rowtype;
1927: l_ignore_who_flag varchar2(2);
1928:
1929: BEGIN
1930: arp_util.debug('arp_ctlgd_pkg.lock_compare_p()+');
1931:
1932: IF (p_ignore_who_flag = TRUE)
1933: THEN l_ignore_who_flag := 'Y';
1934: ELSE l_ignore_who_flag := 'N';

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

2348: )
2349: )
2350: FOR UPDATE OF cust_trx_line_gl_dist_id NOWAIT;
2351:
2352: arp_util.debug('arp_ctlgd_pkg.lock_compare_p()-');
2353:
2354: EXCEPTION
2355: WHEN NO_DATA_FOUND THEN
2356:

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

2373: APP_EXCEPTION.Raise_Exception;
2374:
2375:
2376: WHEN OTHERS THEN
2377: arp_util.debug( 'EXCEPTION: arp_ctlgd_pkg.lock_compare_p' );
2378:
2379: arp_util.debug( SQLERRM );
2380:
2381: arp_util.debug('----- parameters for lock_compare_p -----');

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

2546:
2547: BEGIN
2548:
2549: IF PG_DEBUG in ('Y', 'C') THEN
2550: arp_util.debug('arp_ctlgd_pkg.lock_compare_cover()+',
2551: pg_msg_level_debug);
2552: END IF;
2553:
2554: /*------------------------------------------------+

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

2605: TRUE -- ignore who columns
2606: );
2607:
2608: IF PG_DEBUG in ('Y', 'C') THEN
2609: arp_util.debug('arp_ctlgd_pkg.lock_compare_cover()-',
2610: pg_msg_level_debug);
2611: END IF;
2612:
2613: EXCEPTION

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

2613: EXCEPTION
2614: WHEN OTHERS THEN
2615:
2616: IF PG_DEBUG in ('Y', 'C') THEN
2617: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.lock_compare_cover()',
2618: pg_msg_level_debug);
2619: arp_util.debug('lock_compare_cover: ' || '------- parameters for lock_compare_cove() ' ||
2620: '---------',
2621: pg_msg_level_debug);

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

2734: ra_cust_trx_line_gl_dist.cust_trx_line_gl_dist_id%type)
2735: IS
2736:
2737: BEGIN
2738: arp_util.debug('arp_ctlgd_pkg.fetch_p()+');
2739:
2740: SELECT *
2741: INTO p_dist_rec
2742: FROM ra_cust_trx_line_gl_dist

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

2741: INTO p_dist_rec
2742: FROM ra_cust_trx_line_gl_dist
2743: WHERE cust_trx_line_gl_dist_id = p_cust_trx_line_gl_dist_id;
2744:
2745: arp_util.debug('arp_ctlgd_pkg.fetch_p()-');
2746:
2747: EXCEPTION
2748: WHEN OTHERS THEN
2749: arp_util.debug( 'EXCEPTION: arp_ctlgd_pkg.fetch_p' );

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

2745: arp_util.debug('arp_ctlgd_pkg.fetch_p()-');
2746:
2747: EXCEPTION
2748: WHEN OTHERS THEN
2749: arp_util.debug( 'EXCEPTION: arp_ctlgd_pkg.fetch_p' );
2750: RAISE;
2751: END;
2752:
2753:

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

2788:
2789: BEGIN
2790:
2791:
2792: arp_util.debug('arp_ctlgd_pkg.delete_p()+');
2793:
2794: DELETE FROM ra_cust_trx_line_gl_dist
2795: WHERE cust_trx_line_gl_dist_id = p_cust_trx_line_gl_dist_id;
2796:

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

2794: DELETE FROM ra_cust_trx_line_gl_dist
2795: WHERE cust_trx_line_gl_dist_id = p_cust_trx_line_gl_dist_id;
2796:
2797: IF ( SQL%ROWCOUNT = 0 )
2798: THEN arp_util.debug('EXCEPTION: arp_ctlgd_pkg.delete_p()');
2799: RAISE NO_DATA_FOUND;
2800: END IF;
2801:
2802: /* call mrc api to delete */

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

2807: p_mode => 'SINGLE',
2808: p_key_value => p_cust_trx_line_gl_dist_id);
2809:
2810:
2811: arp_util.debug('arp_ctlgd_pkg.delete_p()-');
2812:
2813: EXCEPTION
2814: WHEN OTHERS THEN
2815: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.delete_p()');

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

2811: arp_util.debug('arp_ctlgd_pkg.delete_p()-');
2812:
2813: EXCEPTION
2814: WHEN OTHERS THEN
2815: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.delete_p()');
2816:
2817: RAISE;
2818:
2819: END;

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

2861: l_gl_dist_key_value_list gl_ca_utility_pkg.r_key_value_arr;
2862:
2863: BEGIN
2864:
2865: arp_util.debug('arp_ctlgd_pkg.delete_f_ct_id()+');
2866:
2867: DELETE FROM ra_cust_trx_line_gl_dist
2868: WHERE customer_trx_id = p_customer_trx_id
2869: AND account_set_flag = nvl(p_account_set_flag, account_set_flag)

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

2878: p_mode => 'BATCH',
2879: p_key_value_list => l_gl_dist_key_value_list);
2880:
2881:
2882: arp_util.debug('arp_ctlgd_pkg.delete_f_ct_id()-');
2883:
2884: EXCEPTION
2885: WHEN OTHERS THEN
2886: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.delete_f_ct_id()');

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

2882: arp_util.debug('arp_ctlgd_pkg.delete_f_ct_id()-');
2883:
2884: EXCEPTION
2885: WHEN OTHERS THEN
2886: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.delete_f_ct_id()');
2887:
2888: RAISE;
2889:
2890: END;

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

2933:
2934: BEGIN
2935:
2936:
2937: arp_util.debug('arp_ctlgd_pkg.delete_f_ctl_id()+');
2938:
2939: DELETE FROM ra_cust_trx_line_gl_dist
2940: WHERE customer_trx_line_id = p_customer_trx_line_id
2941: AND account_set_flag = nvl(p_account_set_flag, account_set_flag)

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

2949: p_table_name => 'RA_CUST_TRX_LINE_GL_DIST',
2950: p_mode => 'BATCH',
2951: p_key_value_list => l_gl_dist_key_value_list);
2952:
2953: arp_util.debug('arp_ctlgd_pkg.delete_f_ctl_id()-');
2954:
2955: EXCEPTION
2956: WHEN OTHERS THEN
2957: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.delete_f_ctl_id()');

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

2953: arp_util.debug('arp_ctlgd_pkg.delete_f_ctl_id()-');
2954:
2955: EXCEPTION
2956: WHEN OTHERS THEN
2957: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.delete_f_ctl_id()');
2958:
2959: RAISE;
2960:
2961: END;

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

3003: l_gl_dist_key_value_list gl_ca_utility_pkg.r_key_value_arr;
3004:
3005: BEGIN
3006:
3007: arp_util.debug('arp_ctlgd_pkg.delete_f_ctls_id()+');
3008:
3009: DELETE FROM ra_cust_trx_line_gl_dist
3010: WHERE cust_trx_line_salesrep_id = p_cust_trx_line_salesrep_id
3011: AND account_set_flag = nvl(p_account_set_flag, account_set_flag)

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

3020: p_mode => 'BATCH',
3021: p_key_value_list => l_gl_dist_key_value_list);
3022:
3023:
3024: arp_util.debug('arp_ctlgd_pkg.delete_f_ctls_id()-');
3025:
3026: EXCEPTION
3027: WHEN OTHERS THEN
3028: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.delete_f_ctls_id()');

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

3024: arp_util.debug('arp_ctlgd_pkg.delete_f_ctls_id()-');
3025:
3026: EXCEPTION
3027: WHEN OTHERS THEN
3028: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.delete_f_ctls_id()');
3029:
3030: RAISE;
3031:
3032: END;

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

3082: l_gl_dist_key_value_list gl_ca_utility_pkg.r_key_value_arr;
3083:
3084: BEGIN
3085:
3086: arp_util.debug('arp_ctlgd_pkg.delete_f_ct_ltctl_id_type()+');
3087:
3088: DELETE FROM ra_cust_trx_line_gl_dist
3089: WHERE customer_trx_id = p_customer_trx_id
3090: AND customer_trx_line_id in

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

3109: p_mode => 'BATCH',
3110: p_key_value_list => l_gl_dist_key_value_list);
3111:
3112:
3113: arp_util.debug('arp_ctlgd_pkg.delete_f_ct_ltctl_id_type()-');
3114:
3115: EXCEPTION
3116: WHEN OTHERS THEN
3117: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.delete_f_ct_ltctl_id_type()');

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

3113: arp_util.debug('arp_ctlgd_pkg.delete_f_ct_ltctl_id_type()-');
3114:
3115: EXCEPTION
3116: WHEN OTHERS THEN
3117: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.delete_f_ct_ltctl_id_type()');
3118:
3119: RAISE;
3120:
3121: END;

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

3172: l_where varchar2(500);
3173:
3174: BEGIN
3175:
3176: arp_util.debug('arp_ctlgd_pkg.update_p()+ ' ||
3177: to_char(sysdate, 'HH:MI:SS'));
3178:
3179: l_where := ' WHERE cust_trx_line_gl_dist_id = :where_1 ' ||
3180: 'AND account_set_flag = nvl(:where_account_set_flag, '||

Line 3185: arp_ctlgd_pkg.generic_update( pg_cursor1,

3181: 'account_set_flag) ' ||
3182: 'AND account_class = nvl(:where_account_class, account_class)';
3183:
3184:
3185: arp_ctlgd_pkg.generic_update( pg_cursor1,
3186: l_where,
3187: p_cust_trx_line_gl_dist_id,
3188: null,
3189: null,

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

3192: p_precision,
3193: p_mau,
3194: p_dist_rec);
3195:
3196: arp_util.debug('arp_ctlgd_pkg.update_p()- ' ||
3197: to_char(sysdate, 'HH:MI:SS'));
3198:
3199:
3200: EXCEPTION

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

3198:
3199:
3200: EXCEPTION
3201: WHEN OTHERS THEN
3202: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.update_p()');
3203: RAISE;
3204: END;
3205:
3206:

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

3260: l_where varchar2(500);
3261:
3262: BEGIN
3263:
3264: arp_util.debug('arp_ctlgd_pkg.update_f_ct_id()+ ' ||
3265: to_char(sysdate, 'HH:MI:SS'));
3266:
3267: l_where := ' WHERE customer_trx_id = :where_1 ' ||
3268: 'AND account_set_flag = nvl(:where_account_set_flag, '||

Line 3272: arp_ctlgd_pkg.generic_update( pg_cursor2,

3268: 'AND account_set_flag = nvl(:where_account_set_flag, '||
3269: 'account_set_flag) ' ||
3270: 'AND account_class = nvl(:where_account_class, account_class)';
3271:
3272: arp_ctlgd_pkg.generic_update( pg_cursor2,
3273: l_where,
3274: p_customer_trx_id,
3275: p_account_set_flag,
3276: p_account_class,

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

3279: p_precision,
3280: p_mau,
3281: p_dist_rec);
3282:
3283: arp_util.debug('arp_ctlgd_pkg.update_f_ct_id()- ' ||
3284: to_char(sysdate, 'HH:MI:SS'));
3285:
3286:
3287: EXCEPTION

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

3285:
3286:
3287: EXCEPTION
3288: WHEN OTHERS THEN
3289: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.update_f_ct_id()');
3290: RAISE;
3291: END;
3292:
3293:

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

3348: l_where varchar2(500);
3349:
3350: BEGIN
3351:
3352: arp_util.debug('arp_ctlgd_pkg.update_f_ctl_id()+ ' ||
3353: to_char(sysdate, 'HH:MI:SS'));
3354:
3355: l_where := ' WHERE customer_trx_line_id = :where_1 ' ||
3356: 'AND account_set_flag = nvl(:where_account_set_flag, '||

Line 3361: arp_ctlgd_pkg.generic_update( pg_cursor3,

3357: 'account_set_flag) ' ||
3358: 'AND account_class = nvl(:where_account_class, account_class)';
3359:
3360:
3361: arp_ctlgd_pkg.generic_update( pg_cursor3,
3362: l_where,
3363: p_customer_trx_line_id,
3364: p_account_set_flag,
3365: p_account_class,

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

3368: p_precision,
3369: p_mau,
3370: p_dist_rec);
3371:
3372: arp_util.debug('arp_ctlgd_pkg.update_f_ctl_id()- ' ||
3373: to_char(sysdate, 'HH:MI:SS'));
3374:
3375:
3376: EXCEPTION

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

3374:
3375:
3376: EXCEPTION
3377: WHEN OTHERS THEN
3378: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.update_f_ctl_id()');
3379: RAISE;
3380: END;
3381:
3382: /*===========================================================================+

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

3436: l_where varchar2(500);
3437:
3438: BEGIN
3439:
3440: arp_util.debug('arp_ctlgd_pkg.update_f_ctls_id()+ ' ||
3441: to_char(sysdate, 'HH:MI:SS'));
3442:
3443: l_where := ' WHERE cust_trx_line_salesrep_id = :where_1 ' ||
3444: 'AND account_set_flag = nvl(:where_account_set_flag, '||

Line 3448: arp_ctlgd_pkg.generic_update( pg_cursor4,

3444: 'AND account_set_flag = nvl(:where_account_set_flag, '||
3445: 'account_set_flag) ' ||
3446: 'AND account_class = nvl(:where_account_class, account_class)';
3447:
3448: arp_ctlgd_pkg.generic_update( pg_cursor4,
3449: l_where,
3450: p_cust_trx_line_salesrep_id,
3451: p_account_set_flag,
3452: p_account_class,

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

3455: p_precision,
3456: p_mau,
3457: p_dist_rec);
3458:
3459: arp_util.debug('arp_ctlgd_pkg.update_f_ctls_id()- ' ||
3460: to_char(sysdate, 'HH:MI:SS'));
3461:
3462:
3463: EXCEPTION

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

3461:
3462:
3463: EXCEPTION
3464: WHEN OTHERS THEN
3465: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.update_f_ctls_id()');
3466: RAISE;
3467: END;
3468:
3469:

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

3518: l_gl_dist_key_value_list gl_ca_utility_pkg.r_key_value_arr;
3519:
3520: BEGIN
3521:
3522: arp_util.debug('arp_ctlgd_pkg.update_acctd_amount()+');
3523:
3524: update ra_cust_trx_line_gl_dist
3525: set last_updated_by = pg_user_id,
3526: last_update_date = sysdate,

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

3548: p_mode => 'BATCH',
3549: p_key_value_list => l_gl_dist_key_value_list);
3550: END IF;
3551:
3552: arp_util.debug('arp_ctlgd_pkg.update_acctd_amount()-');
3553:
3554: EXCEPTION
3555: WHEN NO_DATA_FOUND THEN
3556: arp_util.debug('arp_ctlgd_pkg.update_acctd_amount()-');

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

3552: arp_util.debug('arp_ctlgd_pkg.update_acctd_amount()-');
3553:
3554: EXCEPTION
3555: WHEN NO_DATA_FOUND THEN
3556: arp_util.debug('arp_ctlgd_pkg.update_acctd_amount()-');
3557: WHEN OTHERS THEN
3558: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.update_acctd_amount()');
3559: RAISE;
3560: END;

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

3554: EXCEPTION
3555: WHEN NO_DATA_FOUND THEN
3556: arp_util.debug('arp_ctlgd_pkg.update_acctd_amount()-');
3557: WHEN OTHERS THEN
3558: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.update_acctd_amount()');
3559: RAISE;
3560: END;
3561:
3562: /*===========================================================================+

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

3616: l_gl_dist_key_value_list gl_ca_utility_pkg.r_key_value_arr;
3617:
3618: BEGIN
3619:
3620: arp_util.debug('arp_ctlgd_pkg.update_amount_f_ctl_id()+');
3621:
3622: UPDATE ra_cust_trx_line_gl_dist
3623: SET last_updated_by = pg_user_id,
3624: last_update_date = sysdate,

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

3652: p_mode => 'BATCH',
3653: p_key_value_list => l_gl_dist_key_value_list);
3654: END IF;
3655: END IF;
3656: arp_util.debug('arp_ctlgd_pkg.update_amount_f_ctl_id()-');
3657:
3658: EXCEPTION
3659: WHEN NO_DATA_FOUND THEN
3660: arp_util.debug('arp_ctlgd_pkg.update_amount_f_ctl_id()-');

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

3656: arp_util.debug('arp_ctlgd_pkg.update_amount_f_ctl_id()-');
3657:
3658: EXCEPTION
3659: WHEN NO_DATA_FOUND THEN
3660: arp_util.debug('arp_ctlgd_pkg.update_amount_f_ctl_id()-');
3661: WHEN OTHERS THEN
3662: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.update_amount_f_ctl_id()');
3663: RAISE;
3664: END;

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

3658: EXCEPTION
3659: WHEN NO_DATA_FOUND THEN
3660: arp_util.debug('arp_ctlgd_pkg.update_amount_f_ctl_id()-');
3661: WHEN OTHERS THEN
3662: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.update_amount_f_ctl_id()');
3663: RAISE;
3664: END;
3665:
3666:

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

3725:
3726:
3727: BEGIN
3728:
3729: arp_util.debug('arp_ctlgd_pkg.insert_p()+');
3730:
3731: p_cust_trx_line_gl_dist_id := '';
3732:
3733: /*---------------------------*

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

3871: p_table_name => 'RA_CUST_TRX_LINE_GL_DIST',
3872: p_mode => 'SINGLE',
3873: p_key_value => p_cust_trx_line_gl_dist_id);
3874:
3875: arp_util.debug('arp_ctlgd_pkg.insert_p()-');
3876:
3877: EXCEPTION
3878: WHEN OTHERS THEN
3879: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.insert_p()');

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

3875: arp_util.debug('arp_ctlgd_pkg.insert_p()-');
3876:
3877: EXCEPTION
3878: WHEN OTHERS THEN
3879: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.insert_p()');
3880: RAISE;
3881: END;
3882:
3883: /*===========================================================================+

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

3949:
3950: BEGIN
3951:
3952: IF PG_DEBUG in ('Y', 'C') THEN
3953: arp_util.debug('arp_ctlgd_pkg.select_summary()+');
3954: END IF;
3955:
3956: SELECT NVL( SUM( NVL(amount, 0) ), 0),
3957: NVL( SUM( NVL(amount, 0) ), 0),

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

4001: NVL( cust_trx_line_salesrep_id, -10) )
4002: AND account_set_flag = p_account_set_flag;
4003:
4004: IF PG_DEBUG in ('Y', 'C') THEN
4005: arp_util.debug('arp_ctlgd_pkg.select_summary()-');
4006: END IF;
4007:
4008: EXCEPTION
4009: WHEN OTHERS THEN

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

4007:
4008: EXCEPTION
4009: WHEN OTHERS THEN
4010: IF PG_DEBUG in ('Y', 'C') THEN
4011: arp_util.debug('EXCEPTION: arp_ctlgd_pkg.select_summary()');
4012: END IF;
4013: RAISE;
4014:
4015: END select_summary;

Line 4032: END ARP_CTLGD_PKG;

4028: pg_conc_program_id := fnd_global.conc_program_id;
4029:
4030: pg_msg_level_debug := arp_global.MSG_LEVEL_DEBUG;
4031:
4032: END ARP_CTLGD_PKG;