DBA Data[Home] [Help]

APPS.ARP_BR_REMIT_BATCHES dependencies on FND_API

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

752: | |
753: +===========================================================================*/
754: PROCEDURE update_remit(
755: p_api_version IN NUMBER ,
756: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
757: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
758: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
759: x_return_status OUT NOCOPY VARCHAR2 ,
760: x_msg_count OUT NOCOPY NUMBER ,

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

753: +===========================================================================*/
754: PROCEDURE update_remit(
755: p_api_version IN NUMBER ,
756: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
757: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
758: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
759: x_return_status OUT NOCOPY VARCHAR2 ,
760: x_msg_count OUT NOCOPY NUMBER ,
761: x_msg_data OUT NOCOPY VARCHAR2 ,

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

754: PROCEDURE update_remit(
755: p_api_version IN NUMBER ,
756: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
757: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
758: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
759: x_return_status OUT NOCOPY VARCHAR2 ,
760: x_msg_count OUT NOCOPY NUMBER ,
761: x_msg_data OUT NOCOPY VARCHAR2 ,
762: p_batch_id IN AR_BATCHES.batch_id%TYPE,

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

789:
790: SAVEPOINT update_remit_PVT;
791:
792: -- Standard call to check for call compatability
793: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
794: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
795: END IF;
796:
797: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 794: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

790: SAVEPOINT update_remit_PVT;
791:
792: -- Standard call to check for call compatability
793: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
794: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
795: END IF;
796:
797: x_return_status := FND_API.G_RET_STS_SUCCESS;
798:

Line 797: x_return_status := FND_API.G_RET_STS_SUCCESS;

793: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
794: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
795: END IF;
796:
797: x_return_status := FND_API.G_RET_STS_SUCCESS;
798:
799:
800: IF (p_batch_id IS NULL) THEN
801: l_field := 'P_BATCH_ID';

Line 841: WHEN FND_API.G_EXC_ERROR THEN

837: END IF;
838:
839: EXCEPTION
840:
841: WHEN FND_API.G_EXC_ERROR THEN
842: IF PG_DEBUG in ('Y', 'C') THEN
843: arp_util.debug('EXCEPTION FND_API.G_EXC_ERROR:ARP_BR_REMIT_BATCHES.update_remit');
844: END IF;
845: x_return_status := FND_API.G_RET_STS_ERROR;

Line 843: arp_util.debug('EXCEPTION FND_API.G_EXC_ERROR:ARP_BR_REMIT_BATCHES.update_remit');

839: EXCEPTION
840:
841: WHEN FND_API.G_EXC_ERROR THEN
842: IF PG_DEBUG in ('Y', 'C') THEN
843: arp_util.debug('EXCEPTION FND_API.G_EXC_ERROR:ARP_BR_REMIT_BATCHES.update_remit');
844: END IF;
845: x_return_status := FND_API.G_RET_STS_ERROR;
846: ROLLBACK TO update_remit_PVT;
847:

Line 845: x_return_status := FND_API.G_RET_STS_ERROR;

841: WHEN FND_API.G_EXC_ERROR THEN
842: IF PG_DEBUG in ('Y', 'C') THEN
843: arp_util.debug('EXCEPTION FND_API.G_EXC_ERROR:ARP_BR_REMIT_BATCHES.update_remit');
844: END IF;
845: x_return_status := FND_API.G_RET_STS_ERROR;
846: ROLLBACK TO update_remit_PVT;
847:
848: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
849: IF PG_DEBUG in ('Y', 'C') THEN

Line 848: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

844: END IF;
845: x_return_status := FND_API.G_RET_STS_ERROR;
846: ROLLBACK TO update_remit_PVT;
847:
848: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
849: IF PG_DEBUG in ('Y', 'C') THEN
850: arp_util.debug('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR:ARP_BR_REMIT_BATCHES.update_remit');
851: END IF;
852: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 850: arp_util.debug('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR:ARP_BR_REMIT_BATCHES.update_remit');

846: ROLLBACK TO update_remit_PVT;
847:
848: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
849: IF PG_DEBUG in ('Y', 'C') THEN
850: arp_util.debug('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR:ARP_BR_REMIT_BATCHES.update_remit');
851: END IF;
852: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
853: ROLLBACK TO update_remit_PVT;
854:

Line 852: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

848: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
849: IF PG_DEBUG in ('Y', 'C') THEN
850: arp_util.debug('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR:ARP_BR_REMIT_BATCHES.update_remit');
851: END IF;
852: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
853: ROLLBACK TO update_remit_PVT;
854:
855: WHEN OTHERS THEN
856: IF PG_DEBUG in ('Y', 'C') THEN

Line 862: x_return_status := FND_API.G_RET_STS_ERROR;

858: arp_util.debug('update_remit: ' || SQLERRM);
859: END IF;
860: ROLLBACK TO update_remit_PVT;
861: IF (SQLCODE = -20001) THEN
862: x_return_status := FND_API.G_RET_STS_ERROR;
863: RETURN;
864: END IF;
865:
866: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 866: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

862: x_return_status := FND_API.G_RET_STS_ERROR;
863: RETURN;
864: END IF;
865:
866: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
867:
868:
869: END update_remit;
870:

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

1077: | |
1078: +===========================================================================*/
1079: PROCEDURE lock_remit (
1080: p_api_version IN NUMBER ,
1081: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
1082: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
1083: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1084: x_return_status OUT NOCOPY VARCHAR2 ,
1085: x_msg_count OUT NOCOPY NUMBER ,

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

1078: +===========================================================================*/
1079: PROCEDURE lock_remit (
1080: p_api_version IN NUMBER ,
1081: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
1082: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
1083: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1084: x_return_status OUT NOCOPY VARCHAR2 ,
1085: x_msg_count OUT NOCOPY NUMBER ,
1086: x_msg_data OUT NOCOPY VARCHAR2 ,

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

1079: PROCEDURE lock_remit (
1080: p_api_version IN NUMBER ,
1081: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
1082: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
1083: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1084: x_return_status OUT NOCOPY VARCHAR2 ,
1085: x_msg_count OUT NOCOPY NUMBER ,
1086: x_msg_data OUT NOCOPY VARCHAR2 ,
1087: p_rowid IN varchar2,

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

1129:
1130: SAVEPOINT lock_remit_PVT;
1131:
1132: -- Standard call to check for call compatability
1133: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1134: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1135: END IF;
1136:
1137: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1134: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1130: SAVEPOINT lock_remit_PVT;
1131:
1132: -- Standard call to check for call compatability
1133: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1134: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1135: END IF;
1136:
1137: x_return_status := FND_API.G_RET_STS_SUCCESS;
1138:

Line 1137: x_return_status := FND_API.G_RET_STS_SUCCESS;

1133: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1134: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1135: END IF;
1136:
1137: x_return_status := FND_API.G_RET_STS_SUCCESS;
1138:
1139: arp_cr_batches_pkg.fetch_p(p_batch_id,l_batch_rec);
1140:
1141: l_batch_rec.name :=p_batch_name;

Line 1221: WHEN FND_API.G_EXC_ERROR THEN

1217: END IF;
1218:
1219: EXCEPTION
1220:
1221: WHEN FND_API.G_EXC_ERROR THEN
1222: IF PG_DEBUG in ('Y', 'C') THEN
1223: arp_util.debug('EXCEPTION FND_API.G_EXC_ERROR:ARP_BR_REMIT_BATCHES.lock_remit');
1224: END IF;
1225: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1223: arp_util.debug('EXCEPTION FND_API.G_EXC_ERROR:ARP_BR_REMIT_BATCHES.lock_remit');

1219: EXCEPTION
1220:
1221: WHEN FND_API.G_EXC_ERROR THEN
1222: IF PG_DEBUG in ('Y', 'C') THEN
1223: arp_util.debug('EXCEPTION FND_API.G_EXC_ERROR:ARP_BR_REMIT_BATCHES.lock_remit');
1224: END IF;
1225: x_return_status := FND_API.G_RET_STS_ERROR;
1226: ROLLBACK TO lock_remit_PVT;
1227:

Line 1225: x_return_status := FND_API.G_RET_STS_ERROR;

1221: WHEN FND_API.G_EXC_ERROR THEN
1222: IF PG_DEBUG in ('Y', 'C') THEN
1223: arp_util.debug('EXCEPTION FND_API.G_EXC_ERROR:ARP_BR_REMIT_BATCHES.lock_remit');
1224: END IF;
1225: x_return_status := FND_API.G_RET_STS_ERROR;
1226: ROLLBACK TO lock_remit_PVT;
1227:
1228: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1229: IF PG_DEBUG in ('Y', 'C') THEN

Line 1228: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1224: END IF;
1225: x_return_status := FND_API.G_RET_STS_ERROR;
1226: ROLLBACK TO lock_remit_PVT;
1227:
1228: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1229: IF PG_DEBUG in ('Y', 'C') THEN
1230: arp_util.debug('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR:ARP_BR_REMIT_BATCHES.lock_remit');
1231: END IF;
1232: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1230: arp_util.debug('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR:ARP_BR_REMIT_BATCHES.lock_remit');

1226: ROLLBACK TO lock_remit_PVT;
1227:
1228: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1229: IF PG_DEBUG in ('Y', 'C') THEN
1230: arp_util.debug('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR:ARP_BR_REMIT_BATCHES.lock_remit');
1231: END IF;
1232: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1233: ROLLBACK TO lock_remit_PVT;
1234:

Line 1232: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1228: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1229: IF PG_DEBUG in ('Y', 'C') THEN
1230: arp_util.debug('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR:ARP_BR_REMIT_BATCHES.lock_remit');
1231: END IF;
1232: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1233: ROLLBACK TO lock_remit_PVT;
1234:
1235: WHEN OTHERS THEN
1236: IF PG_DEBUG in ('Y', 'C') THEN

Line 1242: x_return_status := FND_API.G_RET_STS_ERROR;

1238: arp_util.debug('lock_remit: ' || SQLERRM);
1239: END IF;
1240: ROLLBACK TO lock_remit_PVT;
1241: IF (SQLCODE = -20001) THEN
1242: x_return_status := FND_API.G_RET_STS_ERROR;
1243: RETURN;
1244: END IF;
1245:
1246: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1246: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1242: x_return_status := FND_API.G_RET_STS_ERROR;
1243: RETURN;
1244: END IF;
1245:
1246: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1247:
1248:
1249: END lock_remit;
1250: