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.11.12010000.2 2008/08/25 18:57:35 mpsingh 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 170: arp_standard.debug('arp_process_returns.process_invoice_list()+ ');

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

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

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

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

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

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

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

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

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

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

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

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

925: --
926: <>
927: --
928: IF PG_DEBUG in ('Y', 'C') THEN
929: arp_standard.debug('arp_process_RETURNS.process_application_list()- ');
930: END IF;
931: EXCEPTION
932: WHEN OTHERS THEN
933: arp_standard.debug('EXCEPTION : arp_process_returns.process_application_list : ' || SQLERRM(SQLCODE));

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

929: arp_standard.debug('arp_process_RETURNS.process_application_list()- ');
930: END IF;
931: EXCEPTION
932: WHEN OTHERS THEN
933: arp_standard.debug('EXCEPTION : arp_process_returns.process_application_list : ' || SQLERRM(SQLCODE));
934: RAISE;
935: END process_application_list;
936:
937: /*========================================================================

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

1045: l_ra_info app_info_type;
1046: l_rec_in_doubt VARCHAR2(1):='N';
1047: BEGIN
1048: IF PG_DEBUG in ('Y', 'C') THEN
1049: arp_standard.debug('arp_process_RETURNS.unapply_receipts()+ ');
1050: arp_standard.debug('p_inv_customer_trx_id :<' || p_inv_customer_trx_id ||'>');
1051: arp_standard.debug('rec_hand_option :<' || p_receipt_handling_option ||'>');
1052: END IF;
1053: --

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

1202:
1203: END LOOP;
1204:
1205: IF PG_DEBUG in ('Y', 'C') THEN
1206: arp_standard.debug('arp_process_RETURNS.unapply_receipts()- ');
1207: END IF;
1208: EXCEPTION
1209: WHEN OTHERS THEN
1210: arp_standard.debug('arp_process_returns.unapply_receipts : '

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

1206: arp_standard.debug('arp_process_RETURNS.unapply_receipts()- ');
1207: END IF;
1208: EXCEPTION
1209: WHEN OTHERS THEN
1210: arp_standard.debug('arp_process_returns.unapply_receipts : '
1211: || SQLERRM(SQLCODE));
1212: RAISE;
1213:
1214: END unapply_receipts;

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

1219:
1220: PROCEDURE add_invoice (p_customer_trx_id IN NUMBER) IS
1221: BEGIN
1222: IF PG_DEBUG in ('Y', 'C') THEN
1223: arp_standard.debug('arp_process_RETURNS.add_invoice()+ ');
1224: arp_standard.debug('p_customer_trx_id :<' || p_customer_trx_id ||'>');
1225: END IF;
1226:
1227: IF inv_info.EXISTS(p_customer_trx_id) THEN

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

1231: inv_info(p_customer_trx_id).num_of_cms := 1;
1232: END IF;
1233:
1234: IF PG_DEBUG in ('Y', 'C') THEN
1235: arp_standard.debug('arp_process_RETURNS.add_invoice()- ');
1236: END IF;
1237: EXCEPTION
1238: WHEN OTHERS THEN
1239: arp_standard.debug('arp_process_returns.add_invoice : ' ||

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

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

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

1251: l_cnt NUMBER := app_info.COUNT;
1252: BEGIN
1253: --
1254: IF PG_DEBUG in ('Y', 'C') THEN
1255: arp_standard.debug('arp_process_RETURNS.add_ra_to_list()+ ');
1256: arp_standard.debug('count :<' || l_cnt ||'>');
1257: END IF;
1258: --
1259: l_cnt := l_cnt + 1;

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

1260: app_info(l_cnt) := p_ra_info;
1261: app_tab(l_cnt) := p_ra_rec;
1262: --
1263: IF PG_DEBUG in ('Y', 'C') THEN
1264: arp_standard.debug('arp_process_RETURNS.add_ra_to_list()- ');
1265: END IF;
1266: --
1267: EXCEPTION
1268: WHEN OTHERS THEN

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

1265: END IF;
1266: --
1267: EXCEPTION
1268: WHEN OTHERS THEN
1269: arp_standard.debug('arp_process_returns.add_ra_to_list : ' ||
1270: SQLERRM(SQLCODE));
1271: RAISE;
1272: END;
1273: --

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

1280:
1281: BEGIN
1282: --
1283: IF PG_DEBUG in ('Y', 'C') THEN
1284: arp_standard.debug('arp_process_RETURNS.get_total_cm_amount()+ ');
1285: arp_standard.debug('p_inv_customer_trx_id :<'
1286: || p_inv_customer_trx_id ||'>');
1287: END IF;
1288: --

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

1294: --
1295: IF PG_DEBUG in ('Y', 'C') THEN
1296: arp_standard.debug('l_total_cm_amount :<'
1297: || l_total_cm_amount ||'>');
1298: arp_standard.debug('arp_process_RETURNS.get_total_cm_amount()- ');
1299: END IF;
1300: --
1301:
1302: RETURN l_total_cm_amount;

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

1301:
1302: RETURN l_total_cm_amount;
1303: EXCEPTION
1304: WHEN OTHERS THEN
1305: arp_standard.debug('EXCEPTION:arp_process_returns.get_total_cm_amount : '
1306: || SQLERRM(SQLCODE));
1307: RAISE;
1308:
1309: END get_total_cm_amount;

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

1321:
1322: BEGIN
1323: --
1324: IF PG_DEBUG in ('Y', 'C') THEN
1325: arp_standard.debug('arp_process_RETURNS.get_total_payment_types()+ ');
1326: arp_standard.debug('p_inv_customer_trx_id :<'
1327: || p_inv_customer_trx_id ||'>');
1328: END IF;
1329: --

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

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

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

1355: RETURN l_total_payment_types;
1356: --
1357: EXCEPTION
1358: WHEN OTHERS THEN
1359: arp_standard.debug('EXCEPTION:arp_process_returns.get_total_payment_types : '
1360: || SQLERRM(SQLCODE));
1361: RAISE;
1362:
1363: END get_total_payment_types;

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

1373:
1374: BEGIN
1375: --
1376: IF PG_DEBUG in ('Y', 'C') THEN
1377: arp_standard.debug('arp_process_RETURNS.get_receipt_amounts()+ ');
1378: arp_standard.debug('p_cash_receipt_id :<'
1379: || p_cash_receipt_id ||'>');
1380: END IF;
1381: --

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

1410: arp_standard.debug('x_receipt_amount :<'
1411: || x_receipt_amount ||'>');
1412: arp_standard.debug('x_refund_amount :<'
1413: || x_refund_amount ||'>');
1414: arp_standard.debug('arp_process_RETURNS.get_receipt_amounts()- ');
1415: END IF;
1416: --
1417:
1418: EXCEPTION

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

1418: EXCEPTION
1419: WHEN NO_DATA_FOUND THEN
1420: NULL;
1421: WHEN OTHERS THEN
1422: arp_standard.debug('EXCEPTION:arp_process_returns.get_receipt_amounts : '
1423: || SQLERRM(SQLCODE));
1424: RAISE;
1425: END;
1426:

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

1456: x_rec_proc_option IN VARCHAR2) IS
1457: BEGIN
1458: ---
1459: IF PG_DEBUG in ('Y', 'C') THEN
1460: arp_standard.debug('arp_process_RETURNS.check_rec_in_doubt()+ ');
1461: END IF;
1462: ---
1463: x_rec_in_doubt := 'N';
1464: x_rid_reason := null;

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

1484: WHEN NO_DATA_FOUND THEN
1485: NULL;
1486: WHEN OTHERS THEN
1487: arp_standard.debug('Unexpected error '||sqlerrm||
1488: ' occurred in arp_process_returns.check_rec_in_doubt');
1489: RAISE;
1490: END;
1491:
1492: ---

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

1517: WHEN NO_DATA_FOUND THEN
1518: NULL;
1519: WHEN OTHERS THEN
1520: arp_standard.debug('Unexpected error '||sqlerrm||
1521: ' occurred in arp_process_returns.check_rec_in_doubt');
1522: RAISE;
1523: END;
1524:
1525: ---

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

1551: WHEN NO_DATA_FOUND THEN
1552: NULL;
1553: WHEN OTHERS THEN
1554: arp_standard.debug('Unexpected error '||sqlerrm||
1555: ' occurred in arp_process_returns.check_rec_in_doubt');
1556: RAISE;
1557: END;
1558:
1559: ---

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

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

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

1594: ---
1595: <>
1596: ---
1597: IF PG_DEBUG in ('Y', 'C') THEN
1598: arp_standard.debug('arp_process_RETURNS.check_rec_in_doubt()- ');
1599: END IF;
1600: ---
1601: EXCEPTION
1602: WHEN OTHERS THEN

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

1600: ---
1601: EXCEPTION
1602: WHEN OTHERS THEN
1603: arp_standard.debug('Unexpected error '||sqlerrm||
1604: ' occurred in arp_process_returns.check_rec_in_doubt');
1605: RAISE;
1606: END check_rec_in_doubt;
1607:
1608: /*===========================================================================+

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

1631: l_count NUMBER;
1632: BEGIN
1633: ---
1634: IF PG_DEBUG in ('Y', 'C') THEN
1635: arp_standard.debug('arp_process_RETURNS.get_on_acct_cm_apps()+ ');
1636: arp_standard.debug('p_customer_trx_id :<'
1637: || p_customer_trx_id ||'>');
1638: END IF;
1639: ---

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

1648: and app.customer_trx_id = oncm.customer_trx_id
1649: and oncm.previous_customer_trx_id IS NULL;
1650: ---
1651: IF PG_DEBUG in ('Y', 'C') THEN
1652: arp_standard.debug('arp_process_RETURNS.get_on_acct_cm_apps()- ');
1653: END IF;
1654: ---
1655: RETURN l_count;
1656:

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

1656:
1657: EXCEPTION
1658: WHEN OTHERS THEN
1659: arp_standard.debug('Unexpected error '||sqlerrm||
1660: ' occurred in arp_process_returns.get_on_acct_cm_apps');
1661: RAISE;
1662: END get_on_acct_cm_apps;
1663:
1664: /*===========================================================================+

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

1687: l_count NUMBER;
1688: BEGIN
1689: ---
1690: IF PG_DEBUG in ('Y', 'C') THEN
1691: arp_standard.debug('arp_process_RETURNS.get_neg_inv_apps()+ ');
1692: arp_standard.debug('p_customer_trx_id :<'
1693: || p_customer_trx_id ||'>');
1694: END IF;
1695: ---

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

1702: and app.display = 'Y'
1703: and app.amount_applied < 0;
1704: ---
1705: IF PG_DEBUG in ('Y', 'C') THEN
1706: arp_standard.debug('arp_process_RETURNS.get_neg_inv_apps()- ');
1707: END IF;
1708: ---
1709: RETURN l_count;
1710:

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

1710:
1711: EXCEPTION
1712: WHEN OTHERS THEN
1713: arp_standard.debug('Unexpected error '||sqlerrm||
1714: ' occurred in arp_process_returns.get_neg_inv_apps');
1715: RAISE;
1716: END get_neg_inv_apps;
1717:
1718:

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

1741: l_count NUMBER;
1742: BEGIN
1743: ---
1744: IF PG_DEBUG in ('Y', 'C') THEN
1745: arp_standard.debug('arp_process_RETURNS.get_llca_apps()+ ');
1746: arp_standard.debug('p_customer_trx_id :<'
1747: || p_customer_trx_id ||'>');
1748: END IF;
1749: ---

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

1757: and aad.customer_trx_line_id = lines.customer_trx_line_id;
1758:
1759: ---
1760: IF PG_DEBUG in ('Y', 'C') THEN
1761: arp_standard.debug('arp_process_RETURNS.get_llca_apps()- ');
1762: END IF;
1763: ---
1764: RETURN l_count;
1765:

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

1765:
1766: EXCEPTION
1767: WHEN OTHERS THEN
1768: arp_standard.debug('Unexpected error '||sqlerrm||
1769: ' occurred in arp_process_returns.get_llca_apps');
1770: RAISE;
1771: END get_llca_apps;
1772:
1773:

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

1802: AS
1803: BEGIN
1804: ---
1805: IF PG_DEBUG in ('Y', 'C') THEN
1806: arp_standard.debug('arp_process_RETURNS.populate_dff_and_gdf()+ ');
1807: END IF;
1808: ---
1809: x_dff_rec.attribute_category:=p_ra_rec.attribute_category;
1810: x_dff_rec.attribute1 :=p_ra_rec.attribute1;

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

1847: x_gdf_rec.global_attribute20 :=p_ra_rec.global_attribute20;
1848: ---
1849: ---
1850: IF PG_DEBUG in ('Y', 'C') THEN
1851: arp_standard.debug('arp_process_RETURNS.populate_dff_and_gdf()- ');
1852: END IF;
1853: ---
1854: EXCEPTION
1855: WHEN OTHERS THEN

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

1853: ---
1854: EXCEPTION
1855: WHEN OTHERS THEN
1856: arp_standard.debug('Unexpected error '||sqlerrm||
1857: ' occurred in arp_process_returns.populate_dff_and_gdf');
1858: RAISE;
1859: END populate_dff_and_gdf;
1860:
1861:

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

1896:
1897: BEGIN
1898: ---
1899: IF PG_DEBUG in ('Y', 'C') THEN
1900: arp_standard.debug('arp_process_RETURNS.get_amount_applied()+ ');
1901: arp_standard.debug('Customer Trx Id : ' || p_customer_trx_id);
1902: arp_standard.debug('p_line_type : ' || p_line_type);
1903: END IF;
1904: --

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

1969: END IF;
1970: ---
1971: IF PG_DEBUG in ('Y', 'C') THEN
1972: arp_standard.debug('Total Amount : ' || l_total_amount);
1973: arp_standard.debug('arp_process_RETURNS.get_amount_applied()- ');
1974: END IF;
1975: --
1976:
1977: RETURN l_total_amount;

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

1978:
1979: EXCEPTION
1980: WHEN OTHERS THEN
1981: arp_standard.debug('Unexpected error '||sqlerrm||
1982: ' occurred in arp_process_returns.get_amount_applied');
1983: RAISE;
1984: END get_amount_applied;
1985:
1986: BEGIN

Line 1989: END arp_process_RETURNS;

1985:
1986: BEGIN
1987: initialize_globals;
1988:
1989: END arp_process_RETURNS;