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_PROCESS_RETURNS dependencies on ARP_PROCESS_RETURNS

Line 1: PACKAGE BODY ARP_PROCESS_RETURNS AS

1: PACKAGE BODY ARP_PROCESS_RETURNS AS
2: /* $Header: ARPRRTNB.pls 120.17 2010/08/04 09:26:42 npanchak ship $ */
3:
4: /*=======================================================================+
5: | Package Global Constants

Line 7: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ARP_PROCESS_RETURNS';

3:
4: /*=======================================================================+
5: | Package Global Constants
6: +=======================================================================*/
7: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ARP_PROCESS_RETURNS';
8:
9: /*=======================================================================+
10: | Package Global Constants
11: +=======================================================================*/

Line 173: arp_standard.debug('arp_process_returns.process_invoice_list()+ ');

169:
170: BEGIN
171: --
172: IF PG_DEBUG in ('Y', 'C') THEN
173: arp_standard.debug('arp_process_returns.process_invoice_list()+ ');
174: END IF;
175: --
176: -- Check if there are any Invoices to process in the list
177: --

Line 213: arp_standard.debug('arp_process_returns.process_invoice_list : ' ||

209: --
210: -- If adjustment exists then raise exception ***/
211: --
212: IF c01_rec.adj_amount <> 0 THEN
213: arp_standard.debug('arp_process_returns.process_invoice_list : ' ||
214: 'adj_EXCEPTION customer_trx_id <' || c01_rec.inv_customer_trx_id ||
215: '>');
216: RAISE adj_exception;
217: END IF;

Line 234: arp_standard.debug('arp_process_returns.process_invoice_list : ' ||

230: --
231: -- If Total Unapp amount > Applied amount then raise exception
232: --
233: IF l_total_unapp_amount > (c01_rec.inv_app_amount) THEN
234: arp_standard.debug('arp_process_returns.process_invoice_list : ' ||
235: 'overapp_EXCEPTION customer_trx_id <'
236: || c01_rec.inv_customer_trx_id || '>');
237: arp_standard.debug('Inv Balance : <' || c01_rec.inv_balance);
238: arp_standard.debug('Inv App Amount : <' || c01_rec.inv_app_amount);

Line 355: arp_standard.debug('arp_process_RETURNS.process_invoice_list()- ');

351: --
352: <>
353: --
354: IF PG_DEBUG in ('Y', 'C') THEN
355: arp_standard.debug('arp_process_RETURNS.process_invoice_list()- ');
356: END IF;
357: EXCEPTION
358: WHEN OTHERS THEN
359: arp_standard.debug('EXCEPTION : arp_process_returns.process_invoice_list : ' || SQLERRM(SQLCODE));

Line 359: arp_standard.debug('EXCEPTION : arp_process_returns.process_invoice_list : ' || SQLERRM(SQLCODE));

355: arp_standard.debug('arp_process_RETURNS.process_invoice_list()- ');
356: END IF;
357: EXCEPTION
358: WHEN OTHERS THEN
359: arp_standard.debug('EXCEPTION : arp_process_returns.process_invoice_list : ' || SQLERRM(SQLCODE));
360: RAISE;
361: END process_invoice_list;
362:
363: /*========================================================================

Line 441: arp_standard.debug('arp_process_returns.process_application_list()+ ');

437: l_dff_rec ar_receipt_api_pub.attribute_rec_type;
438: l_party_id hz_parties.party_id%type;
439: BEGIN
440: IF PG_DEBUG in ('Y', 'C') THEN
441: arp_standard.debug('arp_process_returns.process_application_list()+ ');
442: END IF;
443: --
444: -- Check if there are any applications to process in the list
445: --

Line 943: arp_standard.debug('arp_process_RETURNS.process_application_list()- ');

939: --
940: <>
941: --
942: IF PG_DEBUG in ('Y', 'C') THEN
943: arp_standard.debug('arp_process_RETURNS.process_application_list()- ');
944: END IF;
945: EXCEPTION
946: WHEN OTHERS THEN
947: arp_standard.debug('EXCEPTION : arp_process_returns.process_application_list : ' || SQLERRM(SQLCODE));

Line 947: arp_standard.debug('EXCEPTION : arp_process_returns.process_application_list : ' || SQLERRM(SQLCODE));

943: arp_standard.debug('arp_process_RETURNS.process_application_list()- ');
944: END IF;
945: EXCEPTION
946: WHEN OTHERS THEN
947: arp_standard.debug('EXCEPTION : arp_process_returns.process_application_list : ' || SQLERRM(SQLCODE));
948: RAISE;
949: END process_application_list;
950:
951: /*========================================================================

Line 1063: arp_standard.debug('arp_process_RETURNS.unapply_receipts()+ ');

1059: l_ra_info app_info_type;
1060: l_rec_in_doubt VARCHAR2(1):='N';
1061: BEGIN
1062: IF PG_DEBUG in ('Y', 'C') THEN
1063: arp_standard.debug('arp_process_RETURNS.unapply_receipts()+ ');
1064: arp_standard.debug('p_inv_customer_trx_id :<' || p_inv_customer_trx_id ||'>');
1065: arp_standard.debug('rec_hand_option :<' || p_receipt_handling_option ||'>');
1066: END IF;
1067: --

Line 1234: arp_standard.debug('arp_process_RETURNS.unapply_receipts()- ');

1230:
1231: END LOOP;
1232:
1233: IF PG_DEBUG in ('Y', 'C') THEN
1234: arp_standard.debug('arp_process_RETURNS.unapply_receipts()- ');
1235: END IF;
1236: EXCEPTION
1237: WHEN OTHERS THEN
1238: arp_standard.debug('arp_process_returns.unapply_receipts : '

Line 1238: arp_standard.debug('arp_process_returns.unapply_receipts : '

1234: arp_standard.debug('arp_process_RETURNS.unapply_receipts()- ');
1235: END IF;
1236: EXCEPTION
1237: WHEN OTHERS THEN
1238: arp_standard.debug('arp_process_returns.unapply_receipts : '
1239: || SQLERRM(SQLCODE));
1240: RAISE;
1241:
1242: END unapply_receipts;

Line 1251: arp_standard.debug('arp_process_RETURNS.add_invoice()+ ');

1247:
1248: PROCEDURE add_invoice (p_customer_trx_id IN NUMBER) IS
1249: BEGIN
1250: IF PG_DEBUG in ('Y', 'C') THEN
1251: arp_standard.debug('arp_process_RETURNS.add_invoice()+ ');
1252: arp_standard.debug('p_customer_trx_id :<' || p_customer_trx_id ||'>');
1253: END IF;
1254:
1255: IF inv_info.EXISTS(p_customer_trx_id) THEN

Line 1263: arp_standard.debug('arp_process_RETURNS.add_invoice()- ');

1259: inv_info(p_customer_trx_id).num_of_cms := 1;
1260: END IF;
1261:
1262: IF PG_DEBUG in ('Y', 'C') THEN
1263: arp_standard.debug('arp_process_RETURNS.add_invoice()- ');
1264: END IF;
1265: EXCEPTION
1266: WHEN OTHERS THEN
1267: arp_standard.debug('arp_process_returns.add_invoice : ' ||

Line 1267: arp_standard.debug('arp_process_returns.add_invoice : ' ||

1263: arp_standard.debug('arp_process_RETURNS.add_invoice()- ');
1264: END IF;
1265: EXCEPTION
1266: WHEN OTHERS THEN
1267: arp_standard.debug('arp_process_returns.add_invoice : ' ||
1268: SQLERRM(SQLCODE));
1269: RAISE;
1270: END;
1271:

Line 1283: arp_standard.debug('arp_process_RETURNS.add_ra_to_list()+ ');

1279: l_cnt NUMBER := app_info.COUNT;
1280: BEGIN
1281: --
1282: IF PG_DEBUG in ('Y', 'C') THEN
1283: arp_standard.debug('arp_process_RETURNS.add_ra_to_list()+ ');
1284: arp_standard.debug('count :<' || l_cnt ||'>');
1285: END IF;
1286: --
1287: l_cnt := l_cnt + 1;

Line 1292: arp_standard.debug('arp_process_RETURNS.add_ra_to_list()- ');

1288: app_info(l_cnt) := p_ra_info;
1289: app_tab(l_cnt) := p_ra_rec;
1290: --
1291: IF PG_DEBUG in ('Y', 'C') THEN
1292: arp_standard.debug('arp_process_RETURNS.add_ra_to_list()- ');
1293: END IF;
1294: --
1295: EXCEPTION
1296: WHEN OTHERS THEN

Line 1297: arp_standard.debug('arp_process_returns.add_ra_to_list : ' ||

1293: END IF;
1294: --
1295: EXCEPTION
1296: WHEN OTHERS THEN
1297: arp_standard.debug('arp_process_returns.add_ra_to_list : ' ||
1298: SQLERRM(SQLCODE));
1299: RAISE;
1300: END;
1301: --

Line 1312: arp_standard.debug('arp_process_RETURNS.get_total_cm_amount()+ ');

1308:
1309: BEGIN
1310: --
1311: IF PG_DEBUG in ('Y', 'C') THEN
1312: arp_standard.debug('arp_process_RETURNS.get_total_cm_amount()+ ');
1313: arp_standard.debug('p_inv_customer_trx_id :<'
1314: || p_inv_customer_trx_id ||'>');
1315: END IF;
1316: --

Line 1326: arp_standard.debug('arp_process_RETURNS.get_total_cm_amount()- ');

1322: --
1323: IF PG_DEBUG in ('Y', 'C') THEN
1324: arp_standard.debug('l_total_cm_amount :<'
1325: || l_total_cm_amount ||'>');
1326: arp_standard.debug('arp_process_RETURNS.get_total_cm_amount()- ');
1327: END IF;
1328: --
1329:
1330: RETURN l_total_cm_amount;

Line 1333: arp_standard.debug('EXCEPTION:arp_process_returns.get_total_cm_amount : '

1329:
1330: RETURN l_total_cm_amount;
1331: EXCEPTION
1332: WHEN OTHERS THEN
1333: arp_standard.debug('EXCEPTION:arp_process_returns.get_total_cm_amount : '
1334: || SQLERRM(SQLCODE));
1335: RAISE;
1336:
1337: END get_total_cm_amount;

Line 1353: arp_standard.debug('arp_process_RETURNS.get_total_payment_types()+ ');

1349:
1350: BEGIN
1351: --
1352: IF PG_DEBUG in ('Y', 'C') THEN
1353: arp_standard.debug('arp_process_RETURNS.get_total_payment_types()+ ');
1354: arp_standard.debug('p_inv_customer_trx_id :<'
1355: || p_inv_customer_trx_id ||'>');
1356: END IF;
1357: --

Line 1380: arp_standard.debug('arp_process_RETURNS.get_total_payment_types()- ');

1376: --
1377: IF PG_DEBUG in ('Y', 'C') THEN
1378: arp_standard.debug('l_total_payment_types :<'
1379: || l_total_payment_types ||'>');
1380: arp_standard.debug('arp_process_RETURNS.get_total_payment_types()- ');
1381: END IF;
1382: --
1383: RETURN l_total_payment_types;
1384: --

Line 1387: arp_standard.debug('EXCEPTION:arp_process_returns.get_total_payment_types : '

1383: RETURN l_total_payment_types;
1384: --
1385: EXCEPTION
1386: WHEN OTHERS THEN
1387: arp_standard.debug('EXCEPTION:arp_process_returns.get_total_payment_types : '
1388: || SQLERRM(SQLCODE));
1389: RAISE;
1390:
1391: END get_total_payment_types;

Line 1405: arp_standard.debug('arp_process_RETURNS.get_receipt_amounts()+ ');

1401:
1402: BEGIN
1403: --
1404: IF PG_DEBUG in ('Y', 'C') THEN
1405: arp_standard.debug('arp_process_RETURNS.get_receipt_amounts()+ ');
1406: arp_standard.debug('p_cash_receipt_id :<'
1407: || p_cash_receipt_id ||'>');
1408: END IF;
1409: --

Line 1442: arp_standard.debug('arp_process_RETURNS.get_receipt_amounts()- ');

1438: arp_standard.debug('x_receipt_amount :<'
1439: || x_receipt_amount ||'>');
1440: arp_standard.debug('x_refund_amount :<'
1441: || x_refund_amount ||'>');
1442: arp_standard.debug('arp_process_RETURNS.get_receipt_amounts()- ');
1443: END IF;
1444: --
1445:
1446: EXCEPTION

Line 1450: arp_standard.debug('EXCEPTION:arp_process_returns.get_receipt_amounts : '

1446: EXCEPTION
1447: WHEN NO_DATA_FOUND THEN
1448: NULL;
1449: WHEN OTHERS THEN
1450: arp_standard.debug('EXCEPTION:arp_process_returns.get_receipt_amounts : '
1451: || SQLERRM(SQLCODE));
1452: RAISE;
1453: END;
1454:

Line 1488: arp_standard.debug('arp_process_RETURNS.check_rec_in_doubt()+ ');

1484: x_rec_proc_option IN VARCHAR2) IS
1485: BEGIN
1486: ---
1487: IF PG_DEBUG in ('Y', 'C') THEN
1488: arp_standard.debug('arp_process_RETURNS.check_rec_in_doubt()+ ');
1489: END IF;
1490: ---
1491: x_rec_in_doubt := 'N';
1492: x_rid_reason := null;

Line 1516: ' occurred in arp_process_returns.check_rec_in_doubt');

1512: WHEN NO_DATA_FOUND THEN
1513: NULL;
1514: WHEN OTHERS THEN
1515: arp_standard.debug('Unexpected error '||sqlerrm||
1516: ' occurred in arp_process_returns.check_rec_in_doubt');
1517: RAISE;
1518: END;
1519:
1520: ---

Line 1549: ' occurred in arp_process_returns.check_rec_in_doubt');

1545: WHEN NO_DATA_FOUND THEN
1546: NULL;
1547: WHEN OTHERS THEN
1548: arp_standard.debug('Unexpected error '||sqlerrm||
1549: ' occurred in arp_process_returns.check_rec_in_doubt');
1550: RAISE;
1551: END;
1552:
1553: ---

Line 1583: ' occurred in arp_process_returns.check_rec_in_doubt');

1579: WHEN NO_DATA_FOUND THEN
1580: NULL;
1581: WHEN OTHERS THEN
1582: arp_standard.debug('Unexpected error '||sqlerrm||
1583: ' occurred in arp_process_returns.check_rec_in_doubt');
1584: RAISE;
1585: END;
1586:
1587: ---

Line 1613: ' occurred in arp_process_returns.check_rec_in_doubt');

1609: WHEN NO_DATA_FOUND THEN
1610: NULL;
1611: WHEN OTHERS THEN
1612: arp_standard.debug('Unexpected error '||sqlerrm||
1613: ' occurred in arp_process_returns.check_rec_in_doubt');
1614: RAISE;
1615: END;
1616:
1617: ---

Line 1626: arp_standard.debug('arp_process_RETURNS.check_rec_in_doubt()- ');

1622: ---
1623: <>
1624: ---
1625: IF PG_DEBUG in ('Y', 'C') THEN
1626: arp_standard.debug('arp_process_RETURNS.check_rec_in_doubt()- ');
1627: END IF;
1628: ---
1629: EXCEPTION
1630: WHEN OTHERS THEN

Line 1632: ' occurred in arp_process_returns.check_rec_in_doubt');

1628: ---
1629: EXCEPTION
1630: WHEN OTHERS THEN
1631: arp_standard.debug('Unexpected error '||sqlerrm||
1632: ' occurred in arp_process_returns.check_rec_in_doubt');
1633: RAISE;
1634: END check_rec_in_doubt;
1635:
1636: /*===========================================================================+

Line 1663: arp_standard.debug('arp_process_RETURNS.get_on_acct_cm_apps()+ ');

1659: l_count NUMBER;
1660: BEGIN
1661: ---
1662: IF PG_DEBUG in ('Y', 'C') THEN
1663: arp_standard.debug('arp_process_RETURNS.get_on_acct_cm_apps()+ ');
1664: arp_standard.debug('p_customer_trx_id :<'
1665: || p_customer_trx_id ||'>');
1666: END IF;
1667: ---

Line 1680: arp_standard.debug('arp_process_RETURNS.get_on_acct_cm_apps()- ');

1676: and app.customer_trx_id = oncm.customer_trx_id
1677: and oncm.previous_customer_trx_id IS NULL;
1678: ---
1679: IF PG_DEBUG in ('Y', 'C') THEN
1680: arp_standard.debug('arp_process_RETURNS.get_on_acct_cm_apps()- ');
1681: END IF;
1682: ---
1683: RETURN l_count;
1684:

Line 1688: ' occurred in arp_process_returns.get_on_acct_cm_apps');

1684:
1685: EXCEPTION
1686: WHEN OTHERS THEN
1687: arp_standard.debug('Unexpected error '||sqlerrm||
1688: ' occurred in arp_process_returns.get_on_acct_cm_apps');
1689: RAISE;
1690: END get_on_acct_cm_apps;
1691:
1692: /*===========================================================================+

Line 1719: arp_standard.debug('arp_process_RETURNS.get_neg_inv_apps()+ ');

1715: l_count NUMBER;
1716: BEGIN
1717: ---
1718: IF PG_DEBUG in ('Y', 'C') THEN
1719: arp_standard.debug('arp_process_RETURNS.get_neg_inv_apps()+ ');
1720: arp_standard.debug('p_customer_trx_id :<'
1721: || p_customer_trx_id ||'>');
1722: END IF;
1723: ---

Line 1734: arp_standard.debug('arp_process_RETURNS.get_neg_inv_apps()- ');

1730: and app.display = 'Y'
1731: and app.amount_applied < 0;
1732: ---
1733: IF PG_DEBUG in ('Y', 'C') THEN
1734: arp_standard.debug('arp_process_RETURNS.get_neg_inv_apps()- ');
1735: END IF;
1736: ---
1737: RETURN l_count;
1738:

Line 1742: ' occurred in arp_process_returns.get_neg_inv_apps');

1738:
1739: EXCEPTION
1740: WHEN OTHERS THEN
1741: arp_standard.debug('Unexpected error '||sqlerrm||
1742: ' occurred in arp_process_returns.get_neg_inv_apps');
1743: RAISE;
1744: END get_neg_inv_apps;
1745:
1746:

Line 1773: arp_standard.debug('arp_process_RETURNS.get_llca_apps()+ ');

1769: l_count NUMBER;
1770: BEGIN
1771: ---
1772: IF PG_DEBUG in ('Y', 'C') THEN
1773: arp_standard.debug('arp_process_RETURNS.get_llca_apps()+ ');
1774: arp_standard.debug('p_customer_trx_id :<'
1775: || p_customer_trx_id ||'>');
1776: END IF;
1777: ---

Line 1789: arp_standard.debug('arp_process_RETURNS.get_llca_apps()- ');

1785: and aad.customer_trx_line_id = lines.customer_trx_line_id;
1786:
1787: ---
1788: IF PG_DEBUG in ('Y', 'C') THEN
1789: arp_standard.debug('arp_process_RETURNS.get_llca_apps()- ');
1790: END IF;
1791: ---
1792: RETURN l_count;
1793:

Line 1797: ' occurred in arp_process_returns.get_llca_apps');

1793:
1794: EXCEPTION
1795: WHEN OTHERS THEN
1796: arp_standard.debug('Unexpected error '||sqlerrm||
1797: ' occurred in arp_process_returns.get_llca_apps');
1798: RAISE;
1799: END get_llca_apps;
1800:
1801:

Line 1834: arp_standard.debug('arp_process_RETURNS.populate_dff_and_gdf()+ ');

1830: AS
1831: BEGIN
1832: ---
1833: IF PG_DEBUG in ('Y', 'C') THEN
1834: arp_standard.debug('arp_process_RETURNS.populate_dff_and_gdf()+ ');
1835: END IF;
1836: ---
1837: x_dff_rec.attribute_category:=p_ra_rec.attribute_category;
1838: x_dff_rec.attribute1 :=p_ra_rec.attribute1;

Line 1879: arp_standard.debug('arp_process_RETURNS.populate_dff_and_gdf()- ');

1875: x_gdf_rec.global_attribute20 :=p_ra_rec.global_attribute20;
1876: ---
1877: ---
1878: IF PG_DEBUG in ('Y', 'C') THEN
1879: arp_standard.debug('arp_process_RETURNS.populate_dff_and_gdf()- ');
1880: END IF;
1881: ---
1882: EXCEPTION
1883: WHEN OTHERS THEN

Line 1885: ' occurred in arp_process_returns.populate_dff_and_gdf');

1881: ---
1882: EXCEPTION
1883: WHEN OTHERS THEN
1884: arp_standard.debug('Unexpected error '||sqlerrm||
1885: ' occurred in arp_process_returns.populate_dff_and_gdf');
1886: RAISE;
1887: END populate_dff_and_gdf;
1888:
1889:

Line 1928: arp_standard.debug('arp_process_RETURNS.get_amount_applied()+ ');

1924:
1925: BEGIN
1926: ---
1927: IF PG_DEBUG in ('Y', 'C') THEN
1928: arp_standard.debug('arp_process_RETURNS.get_amount_applied()+ ');
1929: arp_standard.debug('Customer Trx Id : ' || p_customer_trx_id);
1930: arp_standard.debug('p_line_type : ' || p_line_type);
1931: END IF;
1932: --

Line 2001: arp_standard.debug('arp_process_RETURNS.get_amount_applied()- ');

1997: END IF;
1998: ---
1999: IF PG_DEBUG in ('Y', 'C') THEN
2000: arp_standard.debug('Total Amount : ' || l_total_amount);
2001: arp_standard.debug('arp_process_RETURNS.get_amount_applied()- ');
2002: END IF;
2003: --
2004:
2005: RETURN l_total_amount;

Line 2010: ' occurred in arp_process_returns.get_amount_applied');

2006:
2007: EXCEPTION
2008: WHEN OTHERS THEN
2009: arp_standard.debug('Unexpected error '||sqlerrm||
2010: ' occurred in arp_process_returns.get_amount_applied');
2011: RAISE;
2012: END get_amount_applied;
2013:
2014: PROCEDURE fetch_gl_date( p_ra_rec IN ar_receivable_applications%rowtype,

Line 2025: arp_standard.debug('arp_process_returns.fetch_gl_date()+ ');

2021: l_default_gl_date DATE;
2022: BEGIN
2023:
2024: IF PG_DEBUG in ('Y', 'C') THEN
2025: arp_standard.debug('arp_process_returns.fetch_gl_date()+ ');
2026: END IF;
2027:
2028: l_profile_appln_gl_date_def := NVL(fnd_profile.value('AR_APPLICATION_GL_DATE_DEFAULT')
2029: , 'INV_REC_DT');

Line 2099: arp_standard.debug('arp_process_returns.fetch_gl_date()-');

2095: END IF;
2096:
2097: IF PG_DEBUG in ('Y', 'C') THEN
2098: arp_standard.debug('GL DATE OUT : '||to_char(p_gl_date));
2099: arp_standard.debug('arp_process_returns.fetch_gl_date()-');
2100: END IF;
2101:
2102: EXCEPTION
2103: WHEN OTHERS THEN

Line 2105: arp_standard.debug('Exception -- arp_process_returns');

2101:
2102: EXCEPTION
2103: WHEN OTHERS THEN
2104: IF PG_DEBUG in ('Y', 'C') THEN
2105: arp_standard.debug('Exception -- arp_process_returns');
2106: END IF;
2107: p_gl_date := NULL;
2108:
2109: END fetch_gl_date;

Line 2115: END arp_process_RETURNS;

2111:
2112: BEGIN
2113: initialize_globals;
2114:
2115: END arp_process_RETURNS;