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.9 2010/07/15 13:08:12 dgaurab 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.9 2010/07/15 13:08:12 dgaurab 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 758: arp_util.debug('create_remit_batch: ' || '-----------ARP_PROCESS_BR_REMIT.construct_select_br_for_remit (-)-------------');

754: l_where_clause ||
755: l_order_clause;
756:
757: IF PG_DEBUG in ('Y', 'C') THEN
758: arp_util.debug('create_remit_batch: ' || '-----------ARP_PROCESS_BR_REMIT.construct_select_br_for_remit (-)-------------');
759: END IF;
760:
761:
762: EXCEPTION

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

761:
762: EXCEPTION
763: WHEN OTHERS THEN
764: IF PG_DEBUG in ('Y', 'C') THEN
765: arp_util.debug('create_remit_batch: ' || 'EXCEPTION OTHERS: ARP_PROCESS_BR_REMIT.construct_select_br_for_remit ');
766: END IF;
767: RAISE;
768:
769: END construct_select_br_for_remit;

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

829:
830: BEGIN
831:
832: IF PG_DEBUG in ('Y', 'C') THEN
833: arp_util.debug('create_remit_batch: ' || 'ARP_PROCESS_BR_REMIT.validate_br_search_criteria (+)');
834: END IF;
835:
836: -- remittance total amount
837: IF (p_remit_total_low IS NULL) AND (p_remit_total_high IS NULL) THEN

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

983: APP_EXCEPTION.raise_exception;
984: END IF;
985:
986: IF PG_DEBUG in ('Y', 'C') THEN
987: arp_util.debug('create_remit_batch: ' || 'ARP_PROCESS_BR_REMIT.validate_br_search_criteria (-)');
988: END IF;
989:
990: EXCEPTION
991: WHEN OTHERS THEN

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

989:
990: EXCEPTION
991: WHEN OTHERS THEN
992: IF PG_DEBUG in ('Y', 'C') THEN
993: arp_util.debug('create_remit_batch: ' || 'EXCEPTION OTHERS: ARP_PROCESS_BR_REMIT.validate_br_search_criteria ');
994: END IF;
995: RAISE;
996:
997:

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

1052:
1053: BEGIN
1054:
1055: IF PG_DEBUG in ('Y', 'C') THEN
1056: arp_util.debug('create_remit_batch: ' || 'ARP_PROCESS_BR_REMIT.assign_br_to_remit(+)');
1057: END IF;
1058:
1059: SAVEPOINT assign_br_to_remit_PVT;
1060:

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

1119: p_control_count := TOTAL_COUNT;
1120: p_control_amount := TOTAL_AMOUNT;
1121:
1122: IF PG_DEBUG in ('Y', 'C') THEN
1123: arp_util.debug('create_remit_batch: ' || 'ARP_PROCESS_BR_REMIT.assign_br_to_remit(-)');
1124: END IF;
1125:
1126: EXCEPTION
1127: WHEN OTHERS THEN

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

1125:
1126: EXCEPTION
1127: WHEN OTHERS THEN
1128: IF PG_DEBUG in ('Y', 'C') THEN
1129: arp_util.debug('create_remit_batch: ' || 'EXCEPTION OTHERS: ARP_PROCESS_BR_REMIT.assign_br_to_remit');
1130: END IF;
1131: ROLLBACK TO assign_br_to_remit_PVT;
1132:
1133: IF CUR_BR%ISOPEN THEN

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

1190:
1191: BEGIN
1192:
1193: IF PG_DEBUG in ('Y', 'C') THEN
1194: arp_util.debug('create_remit_batch: ' || 'ARP_PROCESS_BR_REMIT.add_or_rm_br_to_remit(+)');
1195: END IF;
1196:
1197: SAVEPOINT add_or_rm_br_to_remit_PVT;
1198:

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

1283: p_control_count := l_control_count;
1284: p_control_amount := l_control_amount;
1285:
1286: IF PG_DEBUG in ('Y', 'C') THEN
1287: arp_util.debug('create_remit_batch: ' || 'ARP_PROCESS_BR_REMIT.add_or_rm_br_to_remit(-)');
1288: END IF;
1289:
1290: EXCEPTION
1291: WHEN FND_API.G_EXC_ERROR THEN

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

1289:
1290: EXCEPTION
1291: WHEN FND_API.G_EXC_ERROR THEN
1292: IF PG_DEBUG in ('Y', 'C') THEN
1293: arp_util.debug('create_remit_batch: ' || 'EXCEPTION FND_API.G_EXC_ERROR: ARP_PROCESS_BR_REMIT.add_or_rm_br_to_remit');
1294: END IF;
1295: x_return_status := FND_API.G_RET_STS_ERROR;
1296: ROLLBACK TO add_or_rm_br_to_remit_PVT;
1297:

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

1296: ROLLBACK TO add_or_rm_br_to_remit_PVT;
1297:
1298: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1299: IF PG_DEBUG in ('Y', 'C') THEN
1300: arp_util.debug('create_remit_batch: ' || 'EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR: ARP_PROCESS_BR_REMIT.add_or_rm_br_to_remit');
1301: END IF;
1302: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1303: ROLLBACK TO add_or_rm_br_to_remit_PVT;
1304:

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

1303: ROLLBACK TO add_or_rm_br_to_remit_PVT;
1304:
1305: WHEN OTHERS THEN
1306: IF PG_DEBUG in ('Y', 'C') THEN
1307: arp_util.debug('create_remit_batch: ' || 'EXCEPTION OTHERS: ARP_PROCESS_BR_REMIT.add_or_rm_br_to_remit');
1308: arp_util.debug('create_remit_batch: ' || SQLERRM);
1309: END IF;
1310: ROLLBACK TO add_or_rm_br_to_remit_PVT;
1311: IF (SQLCODE = -20001) THEN

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

1410: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1411: END IF;
1412:
1413: IF PG_DEBUG in ('Y', 'C') THEN
1414: arp_util.debug('ARP_PROCESS_BR_REMIT.create_remit_batch_conc_req (+)');
1415: END IF;
1416:
1417: x_return_status := FND_API.G_RET_STS_SUCCESS;
1418:

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

1520: argument35 =>p_physical_bill);
1521:
1522: IF (l_request_id = 0) THEN
1523: FND_MESSAGE.set_name('AR','AR_BR_BATCH_SUBMIT_FAILED');
1524: FND_MESSAGE.set_token('PROCEDURE','ARP_PROCESS_BR_REMIT.create_remit_batch_conc_req');
1525: APP_EXCEPTION.raise_exception;
1526: ELSE
1527: IF PG_DEBUG in ('Y', 'C') THEN
1528: arp_util.debug('create_remit_batch: ' || 'Submitted Request - '||l_program||'. Request ID ='||to_char(l_request_id));

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

1540:
1541: COMMIT;
1542:
1543: IF PG_DEBUG in ('Y', 'C') THEN
1544: arp_util.debug('ARP_PROCESS_BR_REMIT.create_remit_batch_conc_req (-)');
1545: END IF;
1546:
1547: EXCEPTION
1548: WHEN FND_API.G_EXC_ERROR THEN

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

1546:
1547: EXCEPTION
1548: WHEN FND_API.G_EXC_ERROR THEN
1549: IF PG_DEBUG in ('Y', 'C') THEN
1550: arp_util.debug('EXCEPTION FND_API.G_EXC_ERROR: ARP_PROCESS_BR_REMIT.create_remit_batch_conc_req');
1551: END IF;
1552: x_return_status := FND_API.G_RET_STS_ERROR;
1553: ROLLBACK TO create_conc_req_PVT;
1554:

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

1553: ROLLBACK TO create_conc_req_PVT;
1554:
1555: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1556: IF PG_DEBUG in ('Y', 'C') THEN
1557: arp_util.debug('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR: ARP_PROCESS_BR_REMIT.create_remit_batch_conc_req');
1558: END IF;
1559: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1560: ROLLBACK TO create_conc_req_PVT;
1561:

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

1560: ROLLBACK TO create_conc_req_PVT;
1561:
1562: WHEN OTHERS THEN
1563: IF PG_DEBUG in ('Y', 'C') THEN
1564: arp_util.debug('EXCEPTION OTHERS: ARP_PROCESS_BR_REMIT.create_remit_batch_conc_req');
1565: arp_util.debug('create_remit_batch: ' || SQLERRM);
1566: END IF;
1567: ROLLBACK TO create_conc_req_PVT;
1568: IF (SQLCODE = -20001) THEN

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

1633: l_org_id number;
1634: BEGIN
1635:
1636: IF PG_DEBUG in ('Y', 'C') THEN
1637: arp_util.debug('ARP_PROCESS_BR_REMIT.maintain_remit_batch_conc_req (+)');
1638: END IF;
1639:
1640: SAVEPOINT maintain_conc_req_PVT;
1641:

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

1754: argument35 =>p_physical_bill);
1755:
1756: IF (l_request_id = 0) THEN
1757: FND_MESSAGE.set_name('AR','AR_BR_BATCH_SUBMIT_FAILED');
1758: FND_MESSAGE.set_token('PROCEDURE','ARP_PROCESS_BR_REMIT.maintain_remit_batch_conc_req');
1759: APP_EXCEPTION.raise_exception;
1760: ELSE
1761: IF PG_DEBUG in ('Y', 'C') THEN
1762: arp_util.debug('maintain_remit_batch_conc_req: ' || 'Submitted Request - '||l_program||'. Request ID ='||to_char(l_request_id));

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

1783:
1784: COMMIT;
1785:
1786: IF PG_DEBUG in ('Y', 'C') THEN
1787: arp_util.debug('ARP_PROCESS_BR_REMIT.maintain_remit_batch_conc_req (-)');
1788: END IF;
1789:
1790: EXCEPTION
1791: WHEN FND_API.G_EXC_ERROR THEN

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

1789:
1790: EXCEPTION
1791: WHEN FND_API.G_EXC_ERROR THEN
1792: IF PG_DEBUG in ('Y', 'C') THEN
1793: arp_util.debug('EXCEPTION FND_API.G_EXC_ERROR: ARP_PROCESS_BR_REMIT.maintain_remit_batch_conc_req');
1794: END IF;
1795: x_return_status := FND_API.G_RET_STS_ERROR;
1796: ROLLBACK TO maintain_conc_req_PVT;
1797:

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

1796: ROLLBACK TO maintain_conc_req_PVT;
1797:
1798: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1799: IF PG_DEBUG in ('Y', 'C') THEN
1800: arp_util.debug('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR: ARP_PROCESS_BR_REMIT.maintain_remit_batch_conc_req');
1801: END IF;
1802: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1803: ROLLBACK TO maintain_conc_req_PVT;
1804:

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

1803: ROLLBACK TO maintain_conc_req_PVT;
1804:
1805: WHEN OTHERS THEN
1806: IF PG_DEBUG in ('Y', 'C') THEN
1807: arp_util.debug('EXCEPTION OTHERS: ARP_PROCESS_BR_REMIT.maintain_remit_batch_conc_req');
1808: arp_util.debug('maintain_remit_batch_conc_req: ' || SQLERRM);
1809: END IF;
1810: ROLLBACK TO maintain_conc_req_PVT;
1811: IF (SQLCODE = -20001) THEN

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

1858:
1859: BEGIN
1860:
1861: IF PG_DEBUG in ('Y', 'C') THEN
1862: arp_util.debug('ARP_PROCESS_BR_REMIT.update_batch_status (+)');
1863: END IF;
1864:
1865: SAVEPOINT update_batch_status_PVT;
1866:

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

1890:
1891: commit;
1892:
1893: IF PG_DEBUG in ('Y', 'C') THEN
1894: arp_util.debug('ARP_PROCESS_BR_REMIT.update_batch_status (-)');
1895: END IF;
1896:
1897: EXCEPTION
1898: WHEN FND_API.G_EXC_ERROR THEN

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

1896:
1897: EXCEPTION
1898: WHEN FND_API.G_EXC_ERROR THEN
1899: IF PG_DEBUG in ('Y', 'C') THEN
1900: arp_util.debug('EXCEPTION FND_API.G_EXC_ERROR:ARP_PROCESS_BR_REMIT.update_batch_status');
1901: END IF;
1902: x_return_status := FND_API.G_RET_STS_ERROR;
1903: ROLLBACK TO update_batch_status_PVT;
1904:

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

1903: ROLLBACK TO update_batch_status_PVT;
1904:
1905: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1906: IF PG_DEBUG in ('Y', 'C') THEN
1907: arp_util.debug('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR:ARP_PROCESS_BR_REMIT.update_batch_status');
1908: END IF;
1909: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1910: ROLLBACK TO update_batch_status_PVT;
1911:

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

1910: ROLLBACK TO update_batch_status_PVT;
1911:
1912: WHEN OTHERS THEN
1913: IF PG_DEBUG in ('Y', 'C') THEN
1914: arp_util.debug('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR:ARP_PROCESS_BR_REMIT.update_batch_status');
1915: arp_util.debug('update_batch_status: ' || SQLERRM);
1916: END IF;
1917: ROLLBACK TO update_batch_status_PVT;
1918: IF (SQLCODE = -20001) THEN

Line 1982: END ARP_PROCESS_BR_REMIT;

1978:
1979:
1980:
1981:
1982: END ARP_PROCESS_BR_REMIT;
1983: