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_PS_PKG dependencies on ARP_PS_PKG

Line 1: PACKAGE BODY ARP_PS_PKG AS

1: PACKAGE BODY ARP_PS_PKG AS
2: /* $Header: ARCIPSB.pls 120.12 2006/06/30 06:03:00 arnkumar ship $*/
3:
4: /*--------------------------------------------------------+
5: | Dummy constants for use in update and lock operations |

Line 65: arp_standard.debug('dump_debug: ' || 'arp_ps_pkg.set_to_dummy' );

61: +===========================================================================*/
62: PROCEDURE set_to_dummy( p_ps_rec IN OUT NOCOPY ar_payment_schedules%ROWTYPE ) IS
63: BEGIN
64: IF PG_DEBUG in ('Y', 'C') THEN
65: arp_standard.debug('dump_debug: ' || 'arp_ps_pkg.set_to_dummy' );
66: END IF;
67: --
68: p_ps_rec.acctd_amount_due_remaining := AR_NUMBER_DUMMY;
69: p_ps_rec.amount_due_original := AR_NUMBER_DUMMY;

Line 184: arp_standard.debug('dump_debug: ' || 'arp_ps_pkg.set_to_dummy()-' );

180: p_ps_rec.global_attribute19 := AR_TEXT_DUMMY;
181: p_ps_rec.global_attribute20 := AR_TEXT_DUMMY;
182:
183: IF PG_DEBUG in ('Y', 'C') THEN
184: arp_standard.debug('dump_debug: ' || 'arp_ps_pkg.set_to_dummy()-' );
185: END IF;
186: EXCEPTION
187: WHEN OTHERS THEN
188: IF PG_DEBUG in ('Y', 'C') THEN

Line 189: arp_standard.debug('dump_debug: ' || 'EXCEPTION: arp_ps_pkg.set_to_dummy' );

185: END IF;
186: EXCEPTION
187: WHEN OTHERS THEN
188: IF PG_DEBUG in ('Y', 'C') THEN
189: arp_standard.debug('dump_debug: ' || 'EXCEPTION: arp_ps_pkg.set_to_dummy' );
190: END IF;
191: RAISE;
192: END set_to_dummy;
193: --

Line 238: arp_standard.debug('dump_debug: ' || 'arp_ps_pkg.insert_p()+');

234: p_ps_id OUT NOCOPY ar_payment_schedules.payment_schedule_id%TYPE ) IS
235: l_ps_id ar_payment_schedules.payment_schedule_id%TYPE;
236: BEGIN
237: IF PG_DEBUG in ('Y', 'C') THEN
238: arp_standard.debug('dump_debug: ' || 'arp_ps_pkg.insert_p()+');
239: END IF;
240:
241: SELECT ar_payment_schedules_s.nextval
242: INTO l_ps_id

Line 521: arp_standard.debug('dump_debug: ' || 'arp_ps_pkg.insert_p()-');

517: p_mode => 'SINGLE',
518: p_key_value => p_ps_id);
519:
520: IF PG_DEBUG in ('Y', 'C') THEN
521: arp_standard.debug('dump_debug: ' || 'arp_ps_pkg.insert_p()-');
522: END IF;
523: EXCEPTION
524: WHEN OTHERS THEN
525: dump_debug(p_ps_rec);

Line 527: arp_standard.debug('dump_debug: ' || 'EXCEPTION: arp_ps_pkg.insert_p' );

523: EXCEPTION
524: WHEN OTHERS THEN
525: dump_debug(p_ps_rec);
526: IF PG_DEBUG in ('Y', 'C') THEN
527: arp_standard.debug('dump_debug: ' || 'EXCEPTION: arp_ps_pkg.insert_p' );
528: END IF;
529: RAISE;
530: END;
531: --

Line 588: arp_standard.debug('dump_debug: ' || 'arp_ps_pkg.update_p(1)+' );

584: l_last_update_login NUMBER := arp_standard.profile.last_update_login;
585: l_user_id NUMBER := arp_standard.profile.user_id;
586: BEGIN
587: IF PG_DEBUG in ('Y', 'C') THEN
588: arp_standard.debug('dump_debug: ' || 'arp_ps_pkg.update_p(1)+' );
589: END IF;
590: /*Bug 5129946: Calling arp_dispute_history.DisputeHistory*/
591: l_ps_id := p_ps_id;
592: OPEN get_existing_ps(l_ps_id);

Line 1025: arp_standard.debug('dump_debug: ' || 'arp_ps_pkg.update_p(1)-' );

1021: p_mode => 'SINGLE',
1022: p_key_value => p_ps_rec.payment_schedule_id);
1023:
1024: IF PG_DEBUG in ('Y', 'C') THEN
1025: arp_standard.debug('dump_debug: ' || 'arp_ps_pkg.update_p(1)-' );
1026: END IF;
1027:
1028: EXCEPTION
1029: WHEN OTHERS THEN

Line 1032: arp_standard.debug('dump_debug: ' || 'EXCEPTION: arp_ps_pkg.update_p(1)' );

1028: EXCEPTION
1029: WHEN OTHERS THEN
1030: dump_debug(p_ps_rec);
1031: IF PG_DEBUG in ('Y', 'C') THEN
1032: arp_standard.debug('dump_debug: ' || 'EXCEPTION: arp_ps_pkg.update_p(1)' );
1033: END IF;
1034: RAISE;
1035: END;
1036: /*===========================================================================+

Line 1091: arp_standard.debug('dump_debug: ' || 'arp_ps_pkg.update_p(2)+');

1087: l_last_update_login NUMBER := arp_standard.profile.last_update_login;
1088: l_user_id NUMBER := arp_standard.profile.user_id;
1089: BEGIN
1090: IF PG_DEBUG in ('Y', 'C') THEN
1091: arp_standard.debug('dump_debug: ' || 'arp_ps_pkg.update_p(2)+');
1092: END IF;
1093: --
1094: /*Bug 5129946: Calling arp_dispute_history.DisputeHistory*/
1095: l_ps_id := p_ps_rec.payment_schedule_id;

Line 1278: arp_standard.debug('dump_debug: ' || 'arp_ps_pkg.update_p(2)-' );

1274: p_mode => 'SINGLE',
1275: p_key_value => p_ps_rec.payment_schedule_id);
1276:
1277: IF PG_DEBUG in ('Y', 'C') THEN
1278: arp_standard.debug('dump_debug: ' || 'arp_ps_pkg.update_p(2)-' );
1279: END IF;
1280:
1281: EXCEPTION
1282: WHEN OTHERS THEN

Line 1285: arp_standard.debug('dump_debug: ' || 'EXCEPTION: arp_ps_pkg.update_p(2)' );

1281: EXCEPTION
1282: WHEN OTHERS THEN
1283: dump_debug(p_ps_rec);
1284: IF PG_DEBUG in ('Y', 'C') THEN
1285: arp_standard.debug('dump_debug: ' || 'EXCEPTION: arp_ps_pkg.update_p(2)' );
1286: END IF;
1287: RAISE;
1288: END;
1289: --

Line 1318: arp_standard.debug('dump_debug: ' || '>>>>>>> arp_ps_pkg.delete_p' );

1314: PROCEDURE delete_p(
1315: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE ) IS
1316: BEGIN
1317: IF PG_DEBUG in ('Y', 'C') THEN
1318: arp_standard.debug('dump_debug: ' || '>>>>>>> arp_ps_pkg.delete_p' );
1319: END IF;
1320: DELETE FROM ar_payment_schedules
1321: WHERE payment_schedule_id = p_ps_id;
1322:

Line 1339: arp_standard.debug('dump_debug: ' || '<<<<<<< arp_ps_pkg.delete_p' );

1335: p_key_value => p_ps_id);
1336:
1337: --
1338: IF PG_DEBUG in ('Y', 'C') THEN
1339: arp_standard.debug('dump_debug: ' || '<<<<<<< arp_ps_pkg.delete_p' );
1340: END IF;
1341: EXCEPTION
1342: WHEN OTHERS THEN
1343: IF PG_DEBUG in ('Y', 'C') THEN

Line 1345: 'EXCEPTION: arp_ps_pkg.delete_p' );

1341: EXCEPTION
1342: WHEN OTHERS THEN
1343: IF PG_DEBUG in ('Y', 'C') THEN
1344: arp_standard.debug('dump_debug: ' ||
1345: 'EXCEPTION: arp_ps_pkg.delete_p' );
1346: END IF;
1347: RAISE;
1348: END;
1349: --

Line 1376: arp_standard.debug('dump_debug: ' || '>>>>>>> arp_ps_pkg.delete_f_ct_id' );

1372: p_ct_id IN ra_customer_trx.customer_trx_id%TYPE ) IS
1373: l_ps_key_value_list gl_ca_utility_pkg.r_key_value_arr;
1374: BEGIN
1375: IF PG_DEBUG in ('Y', 'C') THEN
1376: arp_standard.debug('dump_debug: ' || '>>>>>>> arp_ps_pkg.delete_f_ct_id' );
1377: END IF;
1378: DELETE FROM ar_payment_schedules
1379: WHERE customer_trx_id = p_ct_id
1380: RETURNING payment_schedule_id

Line 1398: arp_standard.debug('dump_debug: ' || '<<<<<<< arp_ps_pkg.delete_f_ct_id' );

1394: p_mode => 'BATCH',
1395: p_key_value_list => l_ps_key_value_list);
1396: --
1397: IF PG_DEBUG in ('Y', 'C') THEN
1398: arp_standard.debug('dump_debug: ' || '<<<<<<< arp_ps_pkg.delete_f_ct_id' );
1399: END IF;
1400: EXCEPTION
1401: WHEN OTHERS THEN
1402: IF PG_DEBUG in ('Y', 'C') THEN

Line 1404: 'EXCEPTION: arp_ps_pkg.delete_f_ct_id' );

1400: EXCEPTION
1401: WHEN OTHERS THEN
1402: IF PG_DEBUG in ('Y', 'C') THEN
1403: arp_standard.debug('dump_debug: ' ||
1404: 'EXCEPTION: arp_ps_pkg.delete_f_ct_id' );
1405: END IF;
1406: RAISE;
1407: END;
1408: --

Line 1436: arp_standard.debug('dump_debug: ' || '>>>>>>> arp_ps_pkg.fetch_p' );

1432: PROCEDURE fetch_p( p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
1433: p_ps_rec OUT NOCOPY ar_payment_schedules%ROWTYPE ) IS
1434: BEGIN
1435: IF PG_DEBUG in ('Y', 'C') THEN
1436: arp_standard.debug('dump_debug: ' || '>>>>>>> arp_ps_pkg.fetch_p' );
1437: END IF;
1438: --
1439: SELECT *
1440: INTO p_ps_rec

Line 1445: arp_standard.debug('dump_debug: ' || '<<<<<<< arp_ps_pkg.fetch_p' );

1441: FROM ar_payment_schedules
1442: WHERE payment_schedule_id = p_ps_id;
1443: --
1444: IF PG_DEBUG in ('Y', 'C') THEN
1445: arp_standard.debug('dump_debug: ' || '<<<<<<< arp_ps_pkg.fetch_p' );
1446: END IF;
1447: EXCEPTION
1448: WHEN OTHERS THEN
1449: IF PG_DEBUG in ('Y', 'C') THEN

Line 1451: 'EXCEPTION: arp_ps_pkg.fetch_p' );

1447: EXCEPTION
1448: WHEN OTHERS THEN
1449: IF PG_DEBUG in ('Y', 'C') THEN
1450: arp_standard.debug('dump_debug: ' ||
1451: 'EXCEPTION: arp_ps_pkg.fetch_p' );
1452: END IF;
1453: RAISE;
1454: END;
1455: --

Line 1484: arp_standard.debug('dump_debug: ' || '>>>>>>> arp_ps_pkg.fetch_p' );

1480: PROCEDURE fetch_fk_cr_id( p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE,
1481: p_ps_rec OUT NOCOPY ar_payment_schedules%ROWTYPE ) IS
1482: BEGIN
1483: IF PG_DEBUG in ('Y', 'C') THEN
1484: arp_standard.debug('dump_debug: ' || '>>>>>>> arp_ps_pkg.fetch_p' );
1485: END IF;
1486: --
1487: SELECT *
1488: INTO p_ps_rec

Line 1493: arp_standard.debug('dump_debug: ' || '<<<<<<< arp_ps_pkg.fetch_p' );

1489: FROM ar_payment_schedules
1490: WHERE cash_receipt_id = p_cr_id;
1491: --
1492: IF PG_DEBUG in ('Y', 'C') THEN
1493: arp_standard.debug('dump_debug: ' || '<<<<<<< arp_ps_pkg.fetch_p' );
1494: END IF;
1495: EXCEPTION
1496: WHEN OTHERS THEN
1497: IF PG_DEBUG in ('Y', 'C') THEN

Line 1499: 'EXCEPTION: arp_ps_pkg.fetch_p' );

1495: EXCEPTION
1496: WHEN OTHERS THEN
1497: IF PG_DEBUG in ('Y', 'C') THEN
1498: arp_standard.debug('dump_debug: ' ||
1499: 'EXCEPTION: arp_ps_pkg.fetch_p' );
1500: END IF;
1501: RAISE;
1502: END;
1503:

Line 1537: arp_standard.debug('dump_debug: ' || 'arp_ps_pkg.lock_p()+' );

1533: PROCEDURE lock_p( p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE ) IS
1534: l_ps_id ar_payment_schedules.payment_schedule_id%TYPE;
1535: BEGIN
1536: IF PG_DEBUG in ('Y', 'C') THEN
1537: arp_standard.debug('dump_debug: ' || 'arp_ps_pkg.lock_p()+' );
1538: END IF;
1539:
1540: SELECT ps.payment_schedule_id
1541: INTO l_ps_id

Line 1547: arp_standard.debug('dump_debug: ' || 'arp_ps_pkg.lock_p()-' );

1543: WHERE ps.payment_schedule_id = p_ps_id
1544: FOR UPDATE OF PS.STATUS NOWAIT;
1545:
1546: IF PG_DEBUG in ('Y', 'C') THEN
1547: arp_standard.debug('dump_debug: ' || 'arp_ps_pkg.lock_p()-' );
1548: END IF;
1549: EXCEPTION
1550:
1551: WHEN OTHERS THEN

Line 1553: arp_standard.debug('dump_debug: ' || 'EXCEPTION: arp_ps_pkg.lock_p' );

1549: EXCEPTION
1550:
1551: WHEN OTHERS THEN
1552: IF PG_DEBUG in ('Y', 'C') THEN
1553: arp_standard.debug('dump_debug: ' || 'EXCEPTION: arp_ps_pkg.lock_p' );
1554: END IF;
1555: raise;
1556: END;
1557:

Line 1600: arp_util.debug('dump_debug: ' || 'arp_ps_pkg.lock_f_ct_id()+');

1596:
1597:
1598: BEGIN
1599: IF PG_DEBUG in ('Y', 'C') THEN
1600: arp_util.debug('dump_debug: ' || 'arp_ps_pkg.lock_f_ct_id()+');
1601: END IF;
1602:
1603: OPEN lock_c;
1604: CLOSE lock_c;

Line 1607: arp_util.debug('dump_debug: ' || 'arp_ps_pkg.lock_f_ct_id()-');

1603: OPEN lock_c;
1604: CLOSE lock_c;
1605:
1606: IF PG_DEBUG in ('Y', 'C') THEN
1607: arp_util.debug('dump_debug: ' || 'arp_ps_pkg.lock_f_ct_id()-');
1608: END IF;
1609:
1610: EXCEPTION
1611: WHEN OTHERS THEN

Line 1613: arp_util.debug('dump_debug: ' || 'EXCEPTION: arp_ps_pkg.lock_f_ct_id' );

1609:
1610: EXCEPTION
1611: WHEN OTHERS THEN
1612: IF PG_DEBUG in ('Y', 'C') THEN
1613: arp_util.debug('dump_debug: ' || 'EXCEPTION: arp_ps_pkg.lock_f_ct_id' );
1614: END IF;
1615: RAISE; /* Bug-3874863 */
1616: END;
1617:

Line 1646: arp_standard.debug('dump_debug: ' || 'arp_ps_pkg.nowaitlock_p()+' );

1642: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE ) IS
1643: l_ps_id ar_payment_schedules.payment_schedule_id%TYPE;
1644: BEGIN
1645: IF PG_DEBUG in ('Y', 'C') THEN
1646: arp_standard.debug('dump_debug: ' || 'arp_ps_pkg.nowaitlock_p()+' );
1647: arp_standard.debug('dump_debug: ' || '-- Locking using payment_schedule_id = '||
1648: TO_CHAR(p_ps_id));
1649: END IF;
1650:

Line 1673: arp_standard.debug('dump_debug: ' || 'arp_ps_pkg.nowaitlock_p()-' );

1669: END IF;
1670:
1671:
1672: IF PG_DEBUG in ('Y', 'C') THEN
1673: arp_standard.debug('dump_debug: ' || 'arp_ps_pkg.nowaitlock_p()-' );
1674: END IF;
1675: EXCEPTION
1676: WHEN OTHERS THEN
1677: IF PG_DEBUG in ('Y', 'C') THEN

Line 1679: 'EXCEPTION: arp_ps_pkg.nowaitlock_p' );

1675: EXCEPTION
1676: WHEN OTHERS THEN
1677: IF PG_DEBUG in ('Y', 'C') THEN
1678: arp_standard.debug('dump_debug: ' ||
1679: 'EXCEPTION: arp_ps_pkg.nowaitlock_p' );
1680: END IF;
1681: RAISE;
1682: END nowaitlock_p;
1683:

Line 1718: arp_standard.debug('dump_debug: ' || 'arp_ps_pkg.nowaitlock_compare_p()+' );

1714: , p_amount_due_remaining IN NUMBER) IS
1715: l_ps_id NUMBER;
1716: BEGIN
1717: IF PG_DEBUG in ('Y', 'C') THEN
1718: arp_standard.debug('dump_debug: ' || 'arp_ps_pkg.nowaitlock_compare_p()+' );
1719: arp_standard.debug('p_ps_id:'||to_char(p_ps_id) );
1720: arp_standard.debug('p_amount_due_remaining:'||to_char(p_amount_due_remaining) );
1721:
1722: END IF;

Line 1732: arp_standard.debug('dump_debug: ' || 'arp_ps_pkg.nowaitlock_compare_p()-' );

1728: AND ps.amount_due_remaining = decode(ps.class,'PMT',ps.amount_due_remaining,p_amount_due_remaining)
1729: FOR UPDATE OF PS.amount_due_remaining NOWAIT;
1730:
1731: IF PG_DEBUG in ('Y', 'C') THEN
1732: arp_standard.debug('dump_debug: ' || 'arp_ps_pkg.nowaitlock_compare_p()-' );
1733: END IF;
1734:
1735: EXCEPTION
1736: WHEN NO_DATA_FOUND THEN

Line 1744: 'EXCEPTION: arp_ps_pkg.nowaitlock_cmopare_p' );

1740:
1741: WHEN OTHERS THEN
1742: IF PG_DEBUG in ('Y', 'C') THEN
1743: arp_standard.debug('dump_debug: ' ||
1744: 'EXCEPTION: arp_ps_pkg.nowaitlock_cmopare_p' );
1745: arp_standard.debug('dump_debug: ' || '-- payment_schedule_id = '||
1746: TO_CHAR(p_ps_id));
1747: arp_standard.debug('dump_debug: ' || '-- amount_due_remaining = '||
1748: TO_CHAR(p_amount_due_remaining));

Line 2001: END ARP_PS_PKG;

1997: pg_last_updated_by := arp_global.last_updated_by;
1998: pg_last_update_date := arp_global.last_update_date;
1999: pg_last_update_login := arp_global.last_update_login;
2000: pg_set_of_books_id := arp_global.set_of_books_id;
2001: END ARP_PS_PKG;