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 1154: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,

1150: | |
1151: +===========================================================================*/
1152: PROCEDURE add_or_rm_br_to_remit (
1153: p_api_version IN NUMBER ,
1154: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
1155: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
1156: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1157: x_return_status OUT NOCOPY VARCHAR2 ,
1158: x_msg_count OUT NOCOPY NUMBER ,

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

1151: +===========================================================================*/
1152: PROCEDURE add_or_rm_br_to_remit (
1153: p_api_version IN NUMBER ,
1154: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
1155: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
1156: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1157: x_return_status OUT NOCOPY VARCHAR2 ,
1158: x_msg_count OUT NOCOPY NUMBER ,
1159: x_msg_data OUT NOCOPY VARCHAR2 ,

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

1152: PROCEDURE add_or_rm_br_to_remit (
1153: p_api_version IN NUMBER ,
1154: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
1155: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
1156: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1157: x_return_status OUT NOCOPY VARCHAR2 ,
1158: x_msg_count OUT NOCOPY NUMBER ,
1159: x_msg_data OUT NOCOPY VARCHAR2 ,
1160: p_batch_id IN AR_BATCHES.batch_id%TYPE,

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

1185:
1186: SAVEPOINT add_or_rm_br_to_remit_PVT;
1187:
1188: -- Standard call to check for call compatability
1189: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1190: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1191: END IF;
1192:
1193: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1190: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1186: SAVEPOINT add_or_rm_br_to_remit_PVT;
1187:
1188: -- Standard call to check for call compatability
1189: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1190: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1191: END IF;
1192:
1193: x_return_status := FND_API.G_RET_STS_SUCCESS;
1194:

Line 1193: x_return_status := FND_API.G_RET_STS_SUCCESS;

1189: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1190: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1191: END IF;
1192:
1193: x_return_status := FND_API.G_RET_STS_SUCCESS;
1194:
1195: -- the flag action value is S for 'Select' or D for 'Deselect' or E for 'Erase'
1196: IF (p_action_flag NOT IN ('S','D','E')) THEN
1197: l_field := 'p_action_flag';

Line 1265: IF FND_API.To_Boolean(p_commit) THEN

1261: l_batch_rec.control_count := l_control_count;
1262: l_batch_rec.control_amount := l_control_amount;
1263: arp_cr_batches_pkg.update_p(l_batch_rec,l_batch_rec.batch_id);
1264:
1265: IF FND_API.To_Boolean(p_commit) THEN
1266: IF PG_DEBUG in ('Y', 'C') THEN
1267: arp_util.debug('create_remit_batch: ' || 'commit');
1268: END IF;
1269: COMMIT;

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

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

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

Line 1287: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

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

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

Line 1301: x_return_status := FND_API.G_RET_STS_ERROR;

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
1301: x_return_status := FND_API.G_RET_STS_ERROR;
1302: RETURN;
1303: END IF;
1304:
1305: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1305: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1301: x_return_status := FND_API.G_RET_STS_ERROR;
1302: RETURN;
1303: END IF;
1304:
1305: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1306:
1307: END add_or_rm_br_to_remit;
1308:
1309:

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

1330: | |
1331: +===========================================================================*/
1332: PROCEDURE create_remit_batch_conc_req (
1333: p_api_version IN number,
1334: p_init_msg_list IN varchar2 := FND_API.G_FALSE,
1335: p_commit IN varchar2 := FND_API.G_FALSE,
1336: p_validation_level IN number := FND_API.G_VALID_LEVEL_FULL,
1337: x_return_status OUT NOCOPY varchar2,
1338: x_msg_count OUT NOCOPY number,

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

1331: +===========================================================================*/
1332: PROCEDURE create_remit_batch_conc_req (
1333: p_api_version IN number,
1334: p_init_msg_list IN varchar2 := FND_API.G_FALSE,
1335: p_commit IN varchar2 := FND_API.G_FALSE,
1336: p_validation_level IN number := FND_API.G_VALID_LEVEL_FULL,
1337: x_return_status OUT NOCOPY varchar2,
1338: x_msg_count OUT NOCOPY number,
1339: x_msg_data OUT NOCOPY varchar2,

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

1332: PROCEDURE create_remit_batch_conc_req (
1333: p_api_version IN number,
1334: p_init_msg_list IN varchar2 := FND_API.G_FALSE,
1335: p_commit IN varchar2 := FND_API.G_FALSE,
1336: p_validation_level IN number := FND_API.G_VALID_LEVEL_FULL,
1337: x_return_status OUT NOCOPY varchar2,
1338: x_msg_count OUT NOCOPY number,
1339: x_msg_data OUT NOCOPY varchar2,
1340: p_create_flag IN varchar2,

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

1394:
1395: SAVEPOINT create_conc_req_PVT;
1396:
1397: -- Standard call to check for call compatability
1398: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1399: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1400: END IF;
1401:
1402: IF PG_DEBUG in ('Y', 'C') THEN

Line 1399: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1406: x_return_status := FND_API.G_RET_STS_SUCCESS;

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:
1408: --------------------------------------------------
1409: -- validations
1410: --------------------------------------------------

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

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

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

Line 1544: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

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

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

Line 1558: x_return_status := FND_API.G_RET_STS_ERROR;

1554: arp_util.debug('create_remit_batch: ' || SQLERRM);
1555: END IF;
1556: ROLLBACK TO create_conc_req_PVT;
1557: IF (SQLCODE = -20001) THEN
1558: x_return_status := FND_API.G_RET_STS_ERROR;
1559: RETURN;
1560: END IF;
1561:
1562: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1562: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1558: x_return_status := FND_API.G_RET_STS_ERROR;
1559: RETURN;
1560: END IF;
1561:
1562: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1563:
1564: END create_remit_batch_conc_req;
1565:
1566: /*===========================================================================+

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

1586: | |
1587: +===========================================================================*/
1588: PROCEDURE maintain_remit_batch_conc_req (
1589: p_api_version IN number,
1590: p_init_msg_list IN varchar2 := FND_API.G_FALSE,
1591: p_commit IN varchar2 := FND_API.G_FALSE,
1592: p_validation_level IN number := FND_API.G_VALID_LEVEL_FULL,
1593: x_return_status OUT NOCOPY varchar2,
1594: x_msg_count OUT NOCOPY number,

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

1587: +===========================================================================*/
1588: PROCEDURE maintain_remit_batch_conc_req (
1589: p_api_version IN number,
1590: p_init_msg_list IN varchar2 := FND_API.G_FALSE,
1591: p_commit IN varchar2 := FND_API.G_FALSE,
1592: p_validation_level IN number := FND_API.G_VALID_LEVEL_FULL,
1593: x_return_status OUT NOCOPY varchar2,
1594: x_msg_count OUT NOCOPY number,
1595: x_msg_data OUT NOCOPY varchar2,

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

1588: PROCEDURE maintain_remit_batch_conc_req (
1589: p_api_version IN number,
1590: p_init_msg_list IN varchar2 := FND_API.G_FALSE,
1591: p_commit IN varchar2 := FND_API.G_FALSE,
1592: p_validation_level IN number := FND_API.G_VALID_LEVEL_FULL,
1593: x_return_status OUT NOCOPY varchar2,
1594: x_msg_count OUT NOCOPY number,
1595: x_msg_data OUT NOCOPY varchar2,
1596: p_approve_flag IN varchar2,

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

1628:
1629: SAVEPOINT maintain_conc_req_PVT;
1630:
1631: -- Standard call to check for call compatability
1632: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1633: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1634: END IF;
1635:
1636: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1633: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1629: SAVEPOINT maintain_conc_req_PVT;
1630:
1631: -- Standard call to check for call compatability
1632: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1633: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1634: END IF;
1635:
1636: x_return_status := FND_API.G_RET_STS_SUCCESS;
1637:

Line 1636: x_return_status := FND_API.G_RET_STS_SUCCESS;

1632: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1633: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1634: END IF;
1635:
1636: x_return_status := FND_API.G_RET_STS_SUCCESS;
1637:
1638: --------------------------------------------------
1639: -- validations
1640: --------------------------------------------------

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

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

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

Line 1787: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

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

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

Line 1801: x_return_status := FND_API.G_RET_STS_ERROR;

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
1801: x_return_status := FND_API.G_RET_STS_ERROR;
1802: RETURN;
1803: END IF;
1804:
1805: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1805: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1801: x_return_status := FND_API.G_RET_STS_ERROR;
1802: RETURN;
1803: END IF;
1804:
1805: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1806:
1807: END maintain_remit_batch_conc_req;
1808:
1809: /*===========================================================================+

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

1830: | |
1831: +===========================================================================*/
1832: PROCEDURE update_batch_status (
1833: p_api_version IN number,
1834: p_init_msg_list IN varchar2 := FND_API.G_FALSE,
1835: p_commit IN varchar2 := FND_API.G_FALSE,
1836: p_validation_level IN number := FND_API.G_VALID_LEVEL_FULL,
1837: x_return_status OUT NOCOPY varchar2,
1838: x_msg_count OUT NOCOPY number,

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

1831: +===========================================================================*/
1832: PROCEDURE update_batch_status (
1833: p_api_version IN number,
1834: p_init_msg_list IN varchar2 := FND_API.G_FALSE,
1835: p_commit IN varchar2 := FND_API.G_FALSE,
1836: p_validation_level IN number := FND_API.G_VALID_LEVEL_FULL,
1837: x_return_status OUT NOCOPY varchar2,
1838: x_msg_count OUT NOCOPY number,
1839: x_msg_data OUT NOCOPY varchar2,

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

1832: PROCEDURE update_batch_status (
1833: p_api_version IN number,
1834: p_init_msg_list IN varchar2 := FND_API.G_FALSE,
1835: p_commit IN varchar2 := FND_API.G_FALSE,
1836: p_validation_level IN number := FND_API.G_VALID_LEVEL_FULL,
1837: x_return_status OUT NOCOPY varchar2,
1838: x_msg_count OUT NOCOPY number,
1839: x_msg_data OUT NOCOPY varchar2,
1840: p_batch_id IN AR_BATCHES.batch_id%TYPE,

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

1853:
1854: SAVEPOINT update_batch_status_PVT;
1855:
1856: -- Standard call to check for call compatability
1857: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1858: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1859: END IF;
1860:
1861: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1858: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1854: SAVEPOINT update_batch_status_PVT;
1855:
1856: -- Standard call to check for call compatability
1857: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1858: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1859: END IF;
1860:
1861: x_return_status := FND_API.G_RET_STS_SUCCESS;
1862:

Line 1861: x_return_status := FND_API.G_RET_STS_SUCCESS;

1857: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1858: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1859: END IF;
1860:
1861: x_return_status := FND_API.G_RET_STS_SUCCESS;
1862:
1863: -- lock and fetch of the batch row
1864: l_batch_rec.batch_id := p_batch_id;
1865: ARP_CR_BATCHES_PKG.lock_fetch_p(l_batch_rec);

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

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

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

Line 1894: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

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

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

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

1904: arp_util.debug('update_batch_status: ' || SQLERRM);
1905: END IF;
1906: ROLLBACK TO update_batch_status_PVT;
1907: IF (SQLCODE = -20001) THEN
1908: x_return_status := FND_API.G_RET_STS_ERROR;
1909: RETURN;
1910: END IF;
1911:
1912: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1912: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1908: x_return_status := FND_API.G_RET_STS_ERROR;
1909: RETURN;
1910: END IF;
1911:
1912: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1913:
1914:
1915: END update_batch_status;
1916: