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 FND_API

Line 41: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,

37: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
38:
39: PROCEDURE create_remit_batch (
40: p_api_version IN NUMBER ,
41: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
42: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
43: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
44: x_return_status OUT NOCOPY VARCHAR2 ,
45: x_msg_count OUT NOCOPY NUMBER ,

Line 42: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

38:
39: PROCEDURE create_remit_batch (
40: p_api_version IN NUMBER ,
41: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
42: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
43: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
44: x_return_status OUT NOCOPY VARCHAR2 ,
45: x_msg_count OUT NOCOPY NUMBER ,
46: x_msg_data OUT NOCOPY VARCHAR2 ,

Line 43: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

39: PROCEDURE create_remit_batch (
40: p_api_version IN NUMBER ,
41: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
42: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
43: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
44: x_return_status OUT NOCOPY VARCHAR2 ,
45: x_msg_count OUT NOCOPY NUMBER ,
46: x_msg_data OUT NOCOPY VARCHAR2 ,
47: p_batch_date IN AR_BATCHES.batch_date%TYPE,

Line 134: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

130:
131: SAVEPOINT create_remit_batch_PVT;
132:
133: -- Standard call to check for call compatability
134: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
135: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
136: END IF;
137:
138: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 135: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

131: SAVEPOINT create_remit_batch_PVT;
132:
133: -- Standard call to check for call compatability
134: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
135: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
136: END IF;
137:
138: x_return_status := FND_API.G_RET_STS_SUCCESS;
139:

Line 138: x_return_status := FND_API.G_RET_STS_SUCCESS;

134: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
135: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
136: END IF;
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,

Line 288: WHEN FND_API.G_EXC_ERROR THEN

284:
285:
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;

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 298: x_return_status := FND_API.G_RET_STS_ERROR;

294: IF CUR_BR%ISOPEN THEN
295: CLOSE CUR_BR;
296: END IF;
297:
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');

Line 300: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

296: END IF;
297:
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;

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 310: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

306: IF CUR_BR%ISOPEN THEN
307: CLOSE CUR_BR;
308: END IF;
309:
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');

Line 324: x_return_status := FND_API.G_RET_STS_ERROR;

320: CLOSE CUR_BR;
321: END IF;
322:
323: IF (SQLCODE = -20001) THEN
324: x_return_status := FND_API.G_RET_STS_ERROR;
325: RETURN;
326: END IF;
327:
328: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 328: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

324: x_return_status := FND_API.G_RET_STS_ERROR;
325: RETURN;
326: END IF;
327:
328: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
329: RAISE;
330:
331:
332: END create_remit_batch;

Line 363: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,

359: | |
360: +===========================================================================*/
361: PROCEDURE select_and_assign_br_to_remit(
362: p_api_version IN NUMBER ,
363: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
364: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
365: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
366: x_return_status OUT NOCOPY VARCHAR2 ,
367: x_msg_count OUT NOCOPY NUMBER ,

Line 364: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

360: +===========================================================================*/
361: PROCEDURE select_and_assign_br_to_remit(
362: p_api_version IN NUMBER ,
363: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
364: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
365: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
366: x_return_status OUT NOCOPY VARCHAR2 ,
367: x_msg_count OUT NOCOPY NUMBER ,
368: x_msg_data OUT NOCOPY VARCHAR2 ,

Line 365: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

361: PROCEDURE select_and_assign_br_to_remit(
362: p_api_version IN NUMBER ,
363: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
364: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
365: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
366: x_return_status OUT NOCOPY VARCHAR2 ,
367: x_msg_count OUT NOCOPY NUMBER ,
368: x_msg_data OUT NOCOPY VARCHAR2 ,
369: p_batch_id IN AR_BATCHES.batch_id%TYPE,

Line 420: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

416:
417: SAVEPOINT select_and_assign_PVT;
418:
419: -- Standard call to check for call compatability
420: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
421: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
422: END IF;
423:
424: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 421: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

417: SAVEPOINT select_and_assign_PVT;
418:
419: -- Standard call to check for call compatability
420: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
421: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
422: END IF;
423:
424: x_return_status := FND_API.G_RET_STS_SUCCESS;
425:

Line 424: x_return_status := FND_API.G_RET_STS_SUCCESS;

420: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
421: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
422: END IF;
423:
424: x_return_status := FND_API.G_RET_STS_SUCCESS;
425:
426: -- lock and fetch of the batch row
427: l_batch_rec.batch_id := p_batch_id;
428: ARP_CR_BATCHES_PKG.lock_fetch_p(l_batch_rec);

Line 1165: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,

1161: | |
1162: +===========================================================================*/
1163: PROCEDURE add_or_rm_br_to_remit (
1164: p_api_version IN NUMBER ,
1165: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
1166: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
1167: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1168: x_return_status OUT NOCOPY VARCHAR2 ,
1169: x_msg_count OUT NOCOPY NUMBER ,

Line 1166: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

1162: +===========================================================================*/
1163: PROCEDURE add_or_rm_br_to_remit (
1164: p_api_version IN NUMBER ,
1165: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
1166: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
1167: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1168: x_return_status OUT NOCOPY VARCHAR2 ,
1169: x_msg_count OUT NOCOPY NUMBER ,
1170: x_msg_data OUT NOCOPY VARCHAR2 ,

Line 1167: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1163: PROCEDURE add_or_rm_br_to_remit (
1164: p_api_version IN NUMBER ,
1165: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
1166: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
1167: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1168: x_return_status OUT NOCOPY VARCHAR2 ,
1169: x_msg_count OUT NOCOPY NUMBER ,
1170: x_msg_data OUT NOCOPY VARCHAR2 ,
1171: p_batch_id IN AR_BATCHES.batch_id%TYPE,

Line 1200: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

1196:
1197: SAVEPOINT add_or_rm_br_to_remit_PVT;
1198:
1199: -- Standard call to check for call compatability
1200: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1201: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1202: END IF;
1203:
1204: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1201: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1197: SAVEPOINT add_or_rm_br_to_remit_PVT;
1198:
1199: -- Standard call to check for call compatability
1200: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1201: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1202: END IF;
1203:
1204: x_return_status := FND_API.G_RET_STS_SUCCESS;
1205:

Line 1204: x_return_status := FND_API.G_RET_STS_SUCCESS;

1200: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1201: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1202: END IF;
1203:
1204: x_return_status := FND_API.G_RET_STS_SUCCESS;
1205:
1206: -- the flag action value is S for 'Select' or D for 'Deselect' or E for 'Erase'
1207: IF (p_action_flag NOT IN ('S','D','E')) THEN
1208: l_field := 'p_action_flag';

Line 1276: IF FND_API.To_Boolean(p_commit) THEN

1272: l_batch_rec.control_count := l_control_count;
1273: l_batch_rec.control_amount := l_control_amount;
1274: arp_cr_batches_pkg.update_p(l_batch_rec,l_batch_rec.batch_id);
1275:
1276: IF FND_API.To_Boolean(p_commit) THEN
1277: IF PG_DEBUG in ('Y', 'C') THEN
1278: arp_util.debug('create_remit_batch: ' || 'commit');
1279: END IF;
1280: COMMIT;

Line 1291: WHEN FND_API.G_EXC_ERROR 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
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;

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 1295: x_return_status := FND_API.G_RET_STS_ERROR;

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:
1298: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1299: IF PG_DEBUG in ('Y', 'C') THEN

Line 1298: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1294: END IF;
1295: x_return_status := FND_API.G_RET_STS_ERROR;
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;

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 1302: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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:
1305: WHEN OTHERS THEN
1306: IF PG_DEBUG in ('Y', 'C') THEN

Line 1312: x_return_status := FND_API.G_RET_STS_ERROR;

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
1312: x_return_status := FND_API.G_RET_STS_ERROR;
1313: RETURN;
1314: END IF;
1315:
1316: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1316: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1312: x_return_status := FND_API.G_RET_STS_ERROR;
1313: RETURN;
1314: END IF;
1315:
1316: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1317:
1318: END add_or_rm_br_to_remit;
1319:
1320:

Line 1345: p_init_msg_list IN varchar2 := FND_API.G_FALSE,

1341: | |
1342: +===========================================================================*/
1343: PROCEDURE create_remit_batch_conc_req (
1344: p_api_version IN number,
1345: p_init_msg_list IN varchar2 := FND_API.G_FALSE,
1346: p_commit IN varchar2 := FND_API.G_FALSE,
1347: p_validation_level IN number := FND_API.G_VALID_LEVEL_FULL,
1348: x_return_status OUT NOCOPY varchar2,
1349: x_msg_count OUT NOCOPY number,

Line 1346: p_commit IN varchar2 := FND_API.G_FALSE,

1342: +===========================================================================*/
1343: PROCEDURE create_remit_batch_conc_req (
1344: p_api_version IN number,
1345: p_init_msg_list IN varchar2 := FND_API.G_FALSE,
1346: p_commit IN varchar2 := FND_API.G_FALSE,
1347: p_validation_level IN number := FND_API.G_VALID_LEVEL_FULL,
1348: x_return_status OUT NOCOPY varchar2,
1349: x_msg_count OUT NOCOPY number,
1350: x_msg_data OUT NOCOPY varchar2,

Line 1347: p_validation_level IN number := FND_API.G_VALID_LEVEL_FULL,

1343: PROCEDURE create_remit_batch_conc_req (
1344: p_api_version IN number,
1345: p_init_msg_list IN varchar2 := FND_API.G_FALSE,
1346: p_commit IN varchar2 := FND_API.G_FALSE,
1347: p_validation_level IN number := FND_API.G_VALID_LEVEL_FULL,
1348: x_return_status OUT NOCOPY varchar2,
1349: x_msg_count OUT NOCOPY number,
1350: x_msg_data OUT NOCOPY varchar2,
1351: p_create_flag IN varchar2,

Line 1409: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

1405:
1406: SAVEPOINT create_conc_req_PVT;
1407:
1408: -- Standard call to check for call compatability
1409: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1410: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1411: END IF;
1412:
1413: IF PG_DEBUG in ('Y', 'C') THEN

Line 1410: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1406: SAVEPOINT create_conc_req_PVT;
1407:
1408: -- Standard call to check for call compatability
1409: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
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 (+)');

Line 1417: x_return_status := FND_API.G_RET_STS_SUCCESS;

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:
1419: --------------------------------------------------
1420: -- validations
1421: --------------------------------------------------

Line 1548: WHEN FND_API.G_EXC_ERROR 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
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;

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 1552: x_return_status := FND_API.G_RET_STS_ERROR;

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:
1555: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1556: IF PG_DEBUG in ('Y', 'C') THEN

Line 1555: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1551: END IF;
1552: x_return_status := FND_API.G_RET_STS_ERROR;
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;

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 1559: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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:
1562: WHEN OTHERS THEN
1563: IF PG_DEBUG in ('Y', 'C') THEN

Line 1569: x_return_status := FND_API.G_RET_STS_ERROR;

1565: arp_util.debug('create_remit_batch: ' || SQLERRM);
1566: END IF;
1567: ROLLBACK TO create_conc_req_PVT;
1568: IF (SQLCODE = -20001) THEN
1569: x_return_status := FND_API.G_RET_STS_ERROR;
1570: RETURN;
1571: END IF;
1572:
1573: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1573: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1569: x_return_status := FND_API.G_RET_STS_ERROR;
1570: RETURN;
1571: END IF;
1572:
1573: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1574:
1575: END create_remit_batch_conc_req;
1576:
1577: /*===========================================================================+

Line 1601: p_init_msg_list IN varchar2 := FND_API.G_FALSE,

1597: | |
1598: +===========================================================================*/
1599: PROCEDURE maintain_remit_batch_conc_req (
1600: p_api_version IN number,
1601: p_init_msg_list IN varchar2 := FND_API.G_FALSE,
1602: p_commit IN varchar2 := FND_API.G_FALSE,
1603: p_validation_level IN number := FND_API.G_VALID_LEVEL_FULL,
1604: x_return_status OUT NOCOPY varchar2,
1605: x_msg_count OUT NOCOPY number,

Line 1602: p_commit IN varchar2 := FND_API.G_FALSE,

1598: +===========================================================================*/
1599: PROCEDURE maintain_remit_batch_conc_req (
1600: p_api_version IN number,
1601: p_init_msg_list IN varchar2 := FND_API.G_FALSE,
1602: p_commit IN varchar2 := FND_API.G_FALSE,
1603: p_validation_level IN number := FND_API.G_VALID_LEVEL_FULL,
1604: x_return_status OUT NOCOPY varchar2,
1605: x_msg_count OUT NOCOPY number,
1606: x_msg_data OUT NOCOPY varchar2,

Line 1603: p_validation_level IN number := FND_API.G_VALID_LEVEL_FULL,

1599: PROCEDURE maintain_remit_batch_conc_req (
1600: p_api_version IN number,
1601: p_init_msg_list IN varchar2 := FND_API.G_FALSE,
1602: p_commit IN varchar2 := FND_API.G_FALSE,
1603: p_validation_level IN number := FND_API.G_VALID_LEVEL_FULL,
1604: x_return_status OUT NOCOPY varchar2,
1605: x_msg_count OUT NOCOPY number,
1606: x_msg_data OUT NOCOPY varchar2,
1607: p_approve_flag IN varchar2,

Line 1643: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

1639:
1640: SAVEPOINT maintain_conc_req_PVT;
1641:
1642: -- Standard call to check for call compatability
1643: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1644: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1645: END IF;
1646:
1647: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1644: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1640: SAVEPOINT maintain_conc_req_PVT;
1641:
1642: -- Standard call to check for call compatability
1643: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1644: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1645: END IF;
1646:
1647: x_return_status := FND_API.G_RET_STS_SUCCESS;
1648:

Line 1647: x_return_status := FND_API.G_RET_STS_SUCCESS;

1643: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1644: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1645: END IF;
1646:
1647: x_return_status := FND_API.G_RET_STS_SUCCESS;
1648:
1649: --------------------------------------------------
1650: -- validations
1651: --------------------------------------------------

Line 1791: WHEN FND_API.G_EXC_ERROR 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
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;

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 1795: x_return_status := FND_API.G_RET_STS_ERROR;

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:
1798: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1799: IF PG_DEBUG in ('Y', 'C') THEN

Line 1798: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1794: END IF;
1795: x_return_status := FND_API.G_RET_STS_ERROR;
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;

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 1802: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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:
1805: WHEN OTHERS THEN
1806: IF PG_DEBUG in ('Y', 'C') THEN

Line 1812: x_return_status := FND_API.G_RET_STS_ERROR;

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
1812: x_return_status := FND_API.G_RET_STS_ERROR;
1813: RETURN;
1814: END IF;
1815:
1816: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1816: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1812: x_return_status := FND_API.G_RET_STS_ERROR;
1813: RETURN;
1814: END IF;
1815:
1816: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1817:
1818: END maintain_remit_batch_conc_req;
1819:
1820: /*===========================================================================+

Line 1845: p_init_msg_list IN varchar2 := FND_API.G_FALSE,

1841: | |
1842: +===========================================================================*/
1843: PROCEDURE update_batch_status (
1844: p_api_version IN number,
1845: p_init_msg_list IN varchar2 := FND_API.G_FALSE,
1846: p_commit IN varchar2 := FND_API.G_FALSE,
1847: p_validation_level IN number := FND_API.G_VALID_LEVEL_FULL,
1848: x_return_status OUT NOCOPY varchar2,
1849: x_msg_count OUT NOCOPY number,

Line 1846: p_commit IN varchar2 := FND_API.G_FALSE,

1842: +===========================================================================*/
1843: PROCEDURE update_batch_status (
1844: p_api_version IN number,
1845: p_init_msg_list IN varchar2 := FND_API.G_FALSE,
1846: p_commit IN varchar2 := FND_API.G_FALSE,
1847: p_validation_level IN number := FND_API.G_VALID_LEVEL_FULL,
1848: x_return_status OUT NOCOPY varchar2,
1849: x_msg_count OUT NOCOPY number,
1850: x_msg_data OUT NOCOPY varchar2,

Line 1847: p_validation_level IN number := FND_API.G_VALID_LEVEL_FULL,

1843: PROCEDURE update_batch_status (
1844: p_api_version IN number,
1845: p_init_msg_list IN varchar2 := FND_API.G_FALSE,
1846: p_commit IN varchar2 := FND_API.G_FALSE,
1847: p_validation_level IN number := FND_API.G_VALID_LEVEL_FULL,
1848: x_return_status OUT NOCOPY varchar2,
1849: x_msg_count OUT NOCOPY number,
1850: x_msg_data OUT NOCOPY varchar2,
1851: p_batch_id IN AR_BATCHES.batch_id%TYPE,

Line 1868: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

1864:
1865: SAVEPOINT update_batch_status_PVT;
1866:
1867: -- Standard call to check for call compatability
1868: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1869: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1870: END IF;
1871:
1872: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1869: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1865: SAVEPOINT update_batch_status_PVT;
1866:
1867: -- Standard call to check for call compatability
1868: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1869: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1870: END IF;
1871:
1872: x_return_status := FND_API.G_RET_STS_SUCCESS;
1873:

Line 1872: x_return_status := FND_API.G_RET_STS_SUCCESS;

1868: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1869: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1870: END IF;
1871:
1872: x_return_status := FND_API.G_RET_STS_SUCCESS;
1873:
1874: -- lock and fetch of the batch row
1875: l_batch_rec.batch_id := p_batch_id;
1876: ARP_CR_BATCHES_PKG.lock_fetch_p(l_batch_rec);

Line 1898: WHEN FND_API.G_EXC_ERROR 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
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;

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 1902: x_return_status := FND_API.G_RET_STS_ERROR;

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:
1905: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1906: IF PG_DEBUG in ('Y', 'C') THEN

Line 1905: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1901: END IF;
1902: x_return_status := FND_API.G_RET_STS_ERROR;
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;

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 1909: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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:
1912: WHEN OTHERS THEN
1913: IF PG_DEBUG in ('Y', 'C') THEN

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 1919: x_return_status := FND_API.G_RET_STS_ERROR;

1915: arp_util.debug('update_batch_status: ' || SQLERRM);
1916: END IF;
1917: ROLLBACK TO update_batch_status_PVT;
1918: IF (SQLCODE = -20001) THEN
1919: x_return_status := FND_API.G_RET_STS_ERROR;
1920: RETURN;
1921: END IF;
1922:
1923: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1923: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1919: x_return_status := FND_API.G_RET_STS_ERROR;
1920: RETURN;
1921: END IF;
1922:
1923: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1924:
1925:
1926: END update_batch_status;
1927: