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_BR_REMIT dependencies on ARP_PROCESS_BR_REMIT

Line 1: PACKAGE BODY ARP_PROCESS_BR_REMIT AS

1: PACKAGE BODY ARP_PROCESS_BR_REMIT AS
2: /* $Header: ARBRRMAB.pls 120.7 2005/06/24 22:09:58 apandit ship $*/
3:
4: G_PKG_NAME CONSTANT varchar2(30) := 'ARP_PROCESS_BR_REMIT';
5:

Line 4: G_PKG_NAME CONSTANT varchar2(30) := 'ARP_PROCESS_BR_REMIT';

1: PACKAGE BODY ARP_PROCESS_BR_REMIT AS
2: /* $Header: ARBRRMAB.pls 120.7 2005/06/24 22:09:58 apandit ship $*/
3:
4: G_PKG_NAME CONSTANT varchar2(30) := 'ARP_PROCESS_BR_REMIT';
5:
6: TYPE CUR_TYP IS REF CURSOR;
7:
8: /*-------------- Private procedures used by the package --------------------*/

Line 128: arp_util.debug('ARP_PROCESS_BR_REMIT.create_remit_batch (+)');

124:
125: BEGIN
126:
127: IF PG_DEBUG in ('Y', 'C') THEN
128: arp_util.debug('ARP_PROCESS_BR_REMIT.create_remit_batch (+)');
129: END IF;
130:
131: SAVEPOINT create_remit_batch_PVT;
132:

Line 141: ARP_PROCESS_BR_REMIT.validate_br_search_criteria(

137:
138: x_return_status := FND_API.G_RET_STS_SUCCESS;
139:
140: -- BR search criteria validation
141: ARP_PROCESS_BR_REMIT.validate_br_search_criteria(
142: p_remit_total_low,
143: p_remit_total_high,
144: p_maturity_date_low,
145: p_maturity_date_high,

Line 171: ARP_PROCESS_BR_REMIT.construct_select_br_for_remit (

167: p_drawee_sort_criteria,
168: p_drawee_order);
169:
170: -- The necessary BR select statements are built
171: ARP_PROCESS_BR_REMIT.construct_select_br_for_remit (
172: p_transaction_type1_id,
173: p_transaction_type2_id,
174: p_drawee_class1_code,
175: p_drawee_class2_code,

Line 282: arp_util.debug('ARP_PROCESS_BR_REMIT.create_remit_batch (-)');

278:
279: COMMIT;
280:
281: IF PG_DEBUG in ('Y', 'C') THEN
282: arp_util.debug('ARP_PROCESS_BR_REMIT.create_remit_batch (-)');
283: END IF;
284:
285:
286: EXCEPTION

Line 290: arp_util.debug('EXCEPTION FND_API.G_EXC_ERROR: ARP_PROCESS_BR_REMIT.create_remit_batch');

286: EXCEPTION
287:
288: WHEN FND_API.G_EXC_ERROR THEN
289: IF PG_DEBUG in ('Y', 'C') THEN
290: arp_util.debug('EXCEPTION FND_API.G_EXC_ERROR: ARP_PROCESS_BR_REMIT.create_remit_batch');
291: END IF;
292: ROLLBACK TO create_remit_batch_PVT;
293:
294: IF CUR_BR%ISOPEN THEN

Line 302: arp_util.debug('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR: ARP_PROCESS_BR_REMIT.create_remit_batch');

298: x_return_status := FND_API.G_RET_STS_ERROR;
299:
300: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
301: IF PG_DEBUG in ('Y', 'C') THEN
302: arp_util.debug('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR: ARP_PROCESS_BR_REMIT.create_remit_batch');
303: END IF;
304: ROLLBACK TO create_remit_batch_PVT;
305:
306: IF CUR_BR%ISOPEN THEN

Line 314: arp_util.debug('EXCEPTION OTHERS: ARP_PROCESS_BR_REMIT.create_remit_batch');

310: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
311:
312: WHEN OTHERS THEN
313: IF PG_DEBUG in ('Y', 'C') THEN
314: arp_util.debug('EXCEPTION OTHERS: ARP_PROCESS_BR_REMIT.create_remit_batch');
315: arp_util.debug('create_remit_batch: ' || SQLERRM);
316: END IF;
317: ROLLBACK TO create_remit_batch_PVT;
318:

Line 414: arp_util.debug('create_remit_batch: ' || 'ARP_PROCESS_BR_REMIT.select_and_assign_br_to_remit (+)');

410:
411: BEGIN
412:
413: IF PG_DEBUG in ('Y', 'C') THEN
414: arp_util.debug('create_remit_batch: ' || 'ARP_PROCESS_BR_REMIT.select_and_assign_br_to_remit (+)');
415: END IF;
416:
417: SAVEPOINT select_and_assign_PVT;
418:

Line 437: ARP_PROCESS_BR_REMIT.validate_br_search_criteria(

433: APP_EXCEPTION.raise_exception;
434: END IF;
435:
436: -- BR search criteria validation
437: ARP_PROCESS_BR_REMIT.validate_br_search_criteria(
438: p_remit_total_low,
439: p_remit_total_high,
440: p_maturity_date_low,
441: p_maturity_date_high,

Line 467: ARP_PROCESS_BR_REMIT.construct_select_br_for_remit (

463: p_drawee_sort_criteria,
464: p_drawee_order);
465:
466: -- The necessary BR select statements are built
467: ARP_PROCESS_BR_REMIT.construct_select_br_for_remit (
468: p_transaction_type1_id,
469: p_transaction_type2_id,
470: p_drawee_class1_code,
471: p_drawee_class2_code,

Line 487: ARP_PROCESS_BR_REMIT.assign_br_to_remit(

483: l_select_detail);
484:
485: -- The selected BR are assigned to the remittance by updating the reserved columns in the table AR_PAYMENT_SCHEDULES
486: -- until the parameter remittance maximum amount is reached (If it is filled of course).
487: ARP_PROCESS_BR_REMIT.assign_br_to_remit(
488: l_select_detail,
489: l_batch_rec.batch_id,
490: p_remit_total_high,
491: p_include_unpaid_flag,

Line 525: arp_util.debug('create_remit_batch: ' || 'ARP_PROCESS_BR_REMIT.select_and_assign_br_to_remit (+)');

521: IF PG_DEBUG in ('Y', 'C') THEN
522: arp_util.debug('create_remit_batch: ' || 'BR Remittance number :'||l_batch_rec.name);
523: arp_util.debug('create_remit_batch: ' || 'Count :'||l_control_count);
524: arp_util.debug('create_remit_batch: ' || 'Amount :'||l_control_amount);
525: arp_util.debug('create_remit_batch: ' || 'ARP_PROCESS_BR_REMIT.select_and_assign_br_to_remit (+)');
526: END IF;
527:
528: EXCEPTION
529: WHEN OTHERS THEN

Line 598: arp_util.debug('create_remit_batch: ' || '-----------ARP_PROCESS_BR_REMIT.construct_select_br_for_remit (+)-------------');

594:
595: BEGIN
596:
597: IF PG_DEBUG in ('Y', 'C') THEN
598: arp_util.debug('create_remit_batch: ' || '-----------ARP_PROCESS_BR_REMIT.construct_select_br_for_remit (+)-------------');
599: END IF;
600:
601: /*-------------------------------------------------------------------------------------*/
602: /* clause Where set up */

Line 747: arp_util.debug('create_remit_batch: ' || '-----------ARP_PROCESS_BR_REMIT.construct_select_br_for_remit (-)-------------');

743: l_where_clause ||
744: l_order_clause;
745:
746: IF PG_DEBUG in ('Y', 'C') THEN
747: arp_util.debug('create_remit_batch: ' || '-----------ARP_PROCESS_BR_REMIT.construct_select_br_for_remit (-)-------------');
748: END IF;
749:
750:
751: EXCEPTION

Line 754: arp_util.debug('create_remit_batch: ' || 'EXCEPTION OTHERS: ARP_PROCESS_BR_REMIT.construct_select_br_for_remit ');

750:
751: EXCEPTION
752: WHEN OTHERS THEN
753: IF PG_DEBUG in ('Y', 'C') THEN
754: arp_util.debug('create_remit_batch: ' || 'EXCEPTION OTHERS: ARP_PROCESS_BR_REMIT.construct_select_br_for_remit ');
755: END IF;
756: RAISE;
757:
758: END construct_select_br_for_remit;

Line 822: arp_util.debug('create_remit_batch: ' || 'ARP_PROCESS_BR_REMIT.validate_br_search_criteria (+)');

818:
819: BEGIN
820:
821: IF PG_DEBUG in ('Y', 'C') THEN
822: arp_util.debug('create_remit_batch: ' || 'ARP_PROCESS_BR_REMIT.validate_br_search_criteria (+)');
823: END IF;
824:
825: -- remittance total amount
826: IF (p_remit_total_low IS NULL) AND (p_remit_total_high IS NULL) THEN

Line 976: arp_util.debug('create_remit_batch: ' || 'ARP_PROCESS_BR_REMIT.validate_br_search_criteria (-)');

972: APP_EXCEPTION.raise_exception;
973: END IF;
974:
975: IF PG_DEBUG in ('Y', 'C') THEN
976: arp_util.debug('create_remit_batch: ' || 'ARP_PROCESS_BR_REMIT.validate_br_search_criteria (-)');
977: END IF;
978:
979: EXCEPTION
980: WHEN OTHERS THEN

Line 982: arp_util.debug('create_remit_batch: ' || 'EXCEPTION OTHERS: ARP_PROCESS_BR_REMIT.validate_br_search_criteria ');

978:
979: EXCEPTION
980: WHEN OTHERS THEN
981: IF PG_DEBUG in ('Y', 'C') THEN
982: arp_util.debug('create_remit_batch: ' || 'EXCEPTION OTHERS: ARP_PROCESS_BR_REMIT.validate_br_search_criteria ');
983: END IF;
984: RAISE;
985:
986:

Line 1045: arp_util.debug('create_remit_batch: ' || 'ARP_PROCESS_BR_REMIT.assign_br_to_remit(+)');

1041:
1042: BEGIN
1043:
1044: IF PG_DEBUG in ('Y', 'C') THEN
1045: arp_util.debug('create_remit_batch: ' || 'ARP_PROCESS_BR_REMIT.assign_br_to_remit(+)');
1046: END IF;
1047:
1048: SAVEPOINT assign_br_to_remit_PVT;
1049:

Line 1112: arp_util.debug('create_remit_batch: ' || 'ARP_PROCESS_BR_REMIT.assign_br_to_remit(-)');

1108: p_control_count := TOTAL_COUNT;
1109: p_control_amount := TOTAL_AMOUNT;
1110:
1111: IF PG_DEBUG in ('Y', 'C') THEN
1112: arp_util.debug('create_remit_batch: ' || 'ARP_PROCESS_BR_REMIT.assign_br_to_remit(-)');
1113: END IF;
1114:
1115: EXCEPTION
1116: WHEN OTHERS THEN

Line 1118: arp_util.debug('create_remit_batch: ' || 'EXCEPTION OTHERS: ARP_PROCESS_BR_REMIT.assign_br_to_remit');

1114:
1115: EXCEPTION
1116: WHEN OTHERS THEN
1117: IF PG_DEBUG in ('Y', 'C') THEN
1118: arp_util.debug('create_remit_batch: ' || 'EXCEPTION OTHERS: ARP_PROCESS_BR_REMIT.assign_br_to_remit');
1119: END IF;
1120: ROLLBACK TO assign_br_to_remit_PVT;
1121:
1122: IF CUR_BR%ISOPEN THEN

Line 1183: arp_util.debug('create_remit_batch: ' || 'ARP_PROCESS_BR_REMIT.add_or_rm_br_to_remit(+)');

1179:
1180: BEGIN
1181:
1182: IF PG_DEBUG in ('Y', 'C') THEN
1183: arp_util.debug('create_remit_batch: ' || 'ARP_PROCESS_BR_REMIT.add_or_rm_br_to_remit(+)');
1184: END IF;
1185:
1186: SAVEPOINT add_or_rm_br_to_remit_PVT;
1187:

Line 1276: arp_util.debug('create_remit_batch: ' || 'ARP_PROCESS_BR_REMIT.add_or_rm_br_to_remit(-)');

1272: p_control_count := l_control_count;
1273: p_control_amount := l_control_amount;
1274:
1275: IF PG_DEBUG in ('Y', 'C') THEN
1276: arp_util.debug('create_remit_batch: ' || 'ARP_PROCESS_BR_REMIT.add_or_rm_br_to_remit(-)');
1277: END IF;
1278:
1279: EXCEPTION
1280: WHEN FND_API.G_EXC_ERROR THEN

Line 1282: arp_util.debug('create_remit_batch: ' || 'EXCEPTION FND_API.G_EXC_ERROR: ARP_PROCESS_BR_REMIT.add_or_rm_br_to_remit');

1278:
1279: EXCEPTION
1280: WHEN FND_API.G_EXC_ERROR THEN
1281: IF PG_DEBUG in ('Y', 'C') THEN
1282: arp_util.debug('create_remit_batch: ' || 'EXCEPTION FND_API.G_EXC_ERROR: ARP_PROCESS_BR_REMIT.add_or_rm_br_to_remit');
1283: END IF;
1284: x_return_status := FND_API.G_RET_STS_ERROR;
1285: ROLLBACK TO add_or_rm_br_to_remit_PVT;
1286:

Line 1289: arp_util.debug('create_remit_batch: ' || 'EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR: ARP_PROCESS_BR_REMIT.add_or_rm_br_to_remit');

1285: ROLLBACK TO add_or_rm_br_to_remit_PVT;
1286:
1287: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1288: IF PG_DEBUG in ('Y', 'C') THEN
1289: arp_util.debug('create_remit_batch: ' || 'EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR: ARP_PROCESS_BR_REMIT.add_or_rm_br_to_remit');
1290: END IF;
1291: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1292: ROLLBACK TO add_or_rm_br_to_remit_PVT;
1293:

Line 1296: arp_util.debug('create_remit_batch: ' || 'EXCEPTION OTHERS: ARP_PROCESS_BR_REMIT.add_or_rm_br_to_remit');

1292: ROLLBACK TO add_or_rm_br_to_remit_PVT;
1293:
1294: WHEN OTHERS THEN
1295: IF PG_DEBUG in ('Y', 'C') THEN
1296: arp_util.debug('create_remit_batch: ' || 'EXCEPTION OTHERS: ARP_PROCESS_BR_REMIT.add_or_rm_br_to_remit');
1297: arp_util.debug('create_remit_batch: ' || SQLERRM);
1298: END IF;
1299: ROLLBACK TO add_or_rm_br_to_remit_PVT;
1300: IF (SQLCODE = -20001) THEN

Line 1403: arp_util.debug('ARP_PROCESS_BR_REMIT.create_remit_batch_conc_req (+)');

1399: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1400: END IF;
1401:
1402: IF PG_DEBUG in ('Y', 'C') THEN
1403: arp_util.debug('ARP_PROCESS_BR_REMIT.create_remit_batch_conc_req (+)');
1404: END IF;
1405:
1406: x_return_status := FND_API.G_RET_STS_SUCCESS;
1407:

Line 1513: FND_MESSAGE.set_token('PROCEDURE','ARP_PROCESS_BR_REMIT.create_remit_batch_conc_req');

1509: argument35 =>p_physical_bill);
1510:
1511: IF (l_request_id = 0) THEN
1512: FND_MESSAGE.set_name('AR','AR_BR_BATCH_SUBMIT_FAILED');
1513: FND_MESSAGE.set_token('PROCEDURE','ARP_PROCESS_BR_REMIT.create_remit_batch_conc_req');
1514: APP_EXCEPTION.raise_exception;
1515: ELSE
1516: IF PG_DEBUG in ('Y', 'C') THEN
1517: arp_util.debug('create_remit_batch: ' || 'Submitted Request - '||l_program||'. Request ID ='||to_char(l_request_id));

Line 1533: arp_util.debug('ARP_PROCESS_BR_REMIT.create_remit_batch_conc_req (-)');

1529:
1530: COMMIT;
1531:
1532: IF PG_DEBUG in ('Y', 'C') THEN
1533: arp_util.debug('ARP_PROCESS_BR_REMIT.create_remit_batch_conc_req (-)');
1534: END IF;
1535:
1536: EXCEPTION
1537: WHEN FND_API.G_EXC_ERROR THEN

Line 1539: arp_util.debug('EXCEPTION FND_API.G_EXC_ERROR: ARP_PROCESS_BR_REMIT.create_remit_batch_conc_req');

1535:
1536: EXCEPTION
1537: WHEN FND_API.G_EXC_ERROR THEN
1538: IF PG_DEBUG in ('Y', 'C') THEN
1539: arp_util.debug('EXCEPTION FND_API.G_EXC_ERROR: ARP_PROCESS_BR_REMIT.create_remit_batch_conc_req');
1540: END IF;
1541: x_return_status := FND_API.G_RET_STS_ERROR;
1542: ROLLBACK TO create_conc_req_PVT;
1543:

Line 1546: arp_util.debug('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR: ARP_PROCESS_BR_REMIT.create_remit_batch_conc_req');

1542: ROLLBACK TO create_conc_req_PVT;
1543:
1544: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1545: IF PG_DEBUG in ('Y', 'C') THEN
1546: arp_util.debug('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR: ARP_PROCESS_BR_REMIT.create_remit_batch_conc_req');
1547: END IF;
1548: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1549: ROLLBACK TO create_conc_req_PVT;
1550:

Line 1553: arp_util.debug('EXCEPTION OTHERS: ARP_PROCESS_BR_REMIT.create_remit_batch_conc_req');

1549: ROLLBACK TO create_conc_req_PVT;
1550:
1551: WHEN OTHERS THEN
1552: IF PG_DEBUG in ('Y', 'C') THEN
1553: arp_util.debug('EXCEPTION OTHERS: ARP_PROCESS_BR_REMIT.create_remit_batch_conc_req');
1554: arp_util.debug('create_remit_batch: ' || SQLERRM);
1555: END IF;
1556: ROLLBACK TO create_conc_req_PVT;
1557: IF (SQLCODE = -20001) THEN

Line 1626: arp_util.debug('ARP_PROCESS_BR_REMIT.maintain_remit_batch_conc_req (+)');

1622: l_org_id number;
1623: BEGIN
1624:
1625: IF PG_DEBUG in ('Y', 'C') THEN
1626: arp_util.debug('ARP_PROCESS_BR_REMIT.maintain_remit_batch_conc_req (+)');
1627: END IF;
1628:
1629: SAVEPOINT maintain_conc_req_PVT;
1630:

Line 1747: FND_MESSAGE.set_token('PROCEDURE','ARP_PROCESS_BR_REMIT.maintain_remit_batch_conc_req');

1743: argument35 =>p_physical_bill);
1744:
1745: IF (l_request_id = 0) THEN
1746: FND_MESSAGE.set_name('AR','AR_BR_BATCH_SUBMIT_FAILED');
1747: FND_MESSAGE.set_token('PROCEDURE','ARP_PROCESS_BR_REMIT.maintain_remit_batch_conc_req');
1748: APP_EXCEPTION.raise_exception;
1749: ELSE
1750: IF PG_DEBUG in ('Y', 'C') THEN
1751: arp_util.debug('maintain_remit_batch_conc_req: ' || 'Submitted Request - '||l_program||'. Request ID ='||to_char(l_request_id));

Line 1776: arp_util.debug('ARP_PROCESS_BR_REMIT.maintain_remit_batch_conc_req (-)');

1772:
1773: COMMIT;
1774:
1775: IF PG_DEBUG in ('Y', 'C') THEN
1776: arp_util.debug('ARP_PROCESS_BR_REMIT.maintain_remit_batch_conc_req (-)');
1777: END IF;
1778:
1779: EXCEPTION
1780: WHEN FND_API.G_EXC_ERROR THEN

Line 1782: arp_util.debug('EXCEPTION FND_API.G_EXC_ERROR: ARP_PROCESS_BR_REMIT.maintain_remit_batch_conc_req');

1778:
1779: EXCEPTION
1780: WHEN FND_API.G_EXC_ERROR THEN
1781: IF PG_DEBUG in ('Y', 'C') THEN
1782: arp_util.debug('EXCEPTION FND_API.G_EXC_ERROR: ARP_PROCESS_BR_REMIT.maintain_remit_batch_conc_req');
1783: END IF;
1784: x_return_status := FND_API.G_RET_STS_ERROR;
1785: ROLLBACK TO maintain_conc_req_PVT;
1786:

Line 1789: arp_util.debug('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR: ARP_PROCESS_BR_REMIT.maintain_remit_batch_conc_req');

1785: ROLLBACK TO maintain_conc_req_PVT;
1786:
1787: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1788: IF PG_DEBUG in ('Y', 'C') THEN
1789: arp_util.debug('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR: ARP_PROCESS_BR_REMIT.maintain_remit_batch_conc_req');
1790: END IF;
1791: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1792: ROLLBACK TO maintain_conc_req_PVT;
1793:

Line 1796: arp_util.debug('EXCEPTION OTHERS: ARP_PROCESS_BR_REMIT.maintain_remit_batch_conc_req');

1792: ROLLBACK TO maintain_conc_req_PVT;
1793:
1794: WHEN OTHERS THEN
1795: IF PG_DEBUG in ('Y', 'C') THEN
1796: arp_util.debug('EXCEPTION OTHERS: ARP_PROCESS_BR_REMIT.maintain_remit_batch_conc_req');
1797: arp_util.debug('maintain_remit_batch_conc_req: ' || SQLERRM);
1798: END IF;
1799: ROLLBACK TO maintain_conc_req_PVT;
1800: IF (SQLCODE = -20001) THEN

Line 1851: arp_util.debug('ARP_PROCESS_BR_REMIT.update_batch_status (+)');

1847:
1848: BEGIN
1849:
1850: IF PG_DEBUG in ('Y', 'C') THEN
1851: arp_util.debug('ARP_PROCESS_BR_REMIT.update_batch_status (+)');
1852: END IF;
1853:
1854: SAVEPOINT update_batch_status_PVT;
1855:

Line 1883: arp_util.debug('ARP_PROCESS_BR_REMIT.update_batch_status (-)');

1879:
1880: commit;
1881:
1882: IF PG_DEBUG in ('Y', 'C') THEN
1883: arp_util.debug('ARP_PROCESS_BR_REMIT.update_batch_status (-)');
1884: END IF;
1885:
1886: EXCEPTION
1887: WHEN FND_API.G_EXC_ERROR THEN

Line 1889: arp_util.debug('EXCEPTION FND_API.G_EXC_ERROR:ARP_PROCESS_BR_REMIT.update_batch_status');

1885:
1886: EXCEPTION
1887: WHEN FND_API.G_EXC_ERROR THEN
1888: IF PG_DEBUG in ('Y', 'C') THEN
1889: arp_util.debug('EXCEPTION FND_API.G_EXC_ERROR:ARP_PROCESS_BR_REMIT.update_batch_status');
1890: END IF;
1891: x_return_status := FND_API.G_RET_STS_ERROR;
1892: ROLLBACK TO update_batch_status_PVT;
1893:

Line 1896: arp_util.debug('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR:ARP_PROCESS_BR_REMIT.update_batch_status');

1892: ROLLBACK TO update_batch_status_PVT;
1893:
1894: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1895: IF PG_DEBUG in ('Y', 'C') THEN
1896: arp_util.debug('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR:ARP_PROCESS_BR_REMIT.update_batch_status');
1897: END IF;
1898: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1899: ROLLBACK TO update_batch_status_PVT;
1900:

Line 1903: arp_util.debug('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR:ARP_PROCESS_BR_REMIT.update_batch_status');

1899: ROLLBACK TO update_batch_status_PVT;
1900:
1901: WHEN OTHERS THEN
1902: IF PG_DEBUG in ('Y', 'C') THEN
1903: arp_util.debug('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR:ARP_PROCESS_BR_REMIT.update_batch_status');
1904: arp_util.debug('update_batch_status: ' || SQLERRM);
1905: END IF;
1906: ROLLBACK TO update_batch_status_PVT;
1907: IF (SQLCODE = -20001) THEN

Line 1971: END ARP_PROCESS_BR_REMIT;

1967:
1968:
1969:
1970:
1971: END ARP_PROCESS_BR_REMIT;
1972: