DBA Data[Home] [Help]

APPS.ARP_PROCESS_BR_REMIT dependencies on ARP_CR_BATCHES_PKG

Line 428: ARP_CR_BATCHES_PKG.lock_fetch_p(l_batch_rec);

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);
429:
430: -- The action Create is enabled only if the batch status is STARTED_CREATION
431: IF l_batch_rec.batch_applied_status NOT IN ('STARTED_CREATION') THEN
432: FND_MESSAGE.set_name('AR','AR_BR_CANNOT_RECREATE_REMIT');

Line 515: arp_cr_batches_pkg.update_p(l_batch_rec,l_batch_rec.batch_id);

511: -- update the batch row with the control count and the control amount
512: l_batch_rec.control_count := l_control_count;
513: l_batch_rec.control_amount := l_control_amount;
514: l_batch_rec.batch_applied_status := 'COMPLETED_CREATION';
515: arp_cr_batches_pkg.update_p(l_batch_rec,l_batch_rec.batch_id);
516:
517: p_batch_applied_status := l_batch_rec.batch_applied_status;
518: p_control_count := l_batch_rec.control_count;
519: p_control_amount := l_batch_rec.control_amount;

Line 1225: ARP_CR_BATCHES_PKG.fetch_p(p_batch_id,l_batch_rec);

1221: APP_EXCEPTION.raise_exception;
1222: END IF;
1223:
1224: -- fetch the remittance batch row
1225: ARP_CR_BATCHES_PKG.fetch_p(p_batch_id,l_batch_rec);
1226: l_control_count := l_batch_rec.control_count;
1227: l_control_amount := l_batch_rec.control_amount;
1228:
1229: -- The remittance has been approved; no changes are allowed

Line 1274: arp_cr_batches_pkg.update_p(l_batch_rec,l_batch_rec.batch_id);

1270:
1271: -- update the batch row with the control count and the control amount
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');

Line 1475: ARP_CR_BATCHES_PKG.fetch_p(p_batch_id,l_batch_rec);

1471: select org_id into l_org_id
1472: from ar_system_parameters;
1473:
1474: -- Fetch of the remittance batch
1475: ARP_CR_BATCHES_PKG.fetch_p(p_batch_id,l_batch_rec);
1476:
1477: --MOAC changes
1478: FND_REQUEST.SET_ORG_ID(l_org_id);
1479: -- Submit the BR Remittance auto Create concurrent program as a concurrent request

Line 1539: arp_cr_batches_pkg.update_p(l_batch_rec,l_batch_rec.batch_id);

1535: p_batch_applied_status := l_batch_rec.batch_applied_status;
1536:
1537: -- Update the batch row with the request id
1538: l_batch_rec.operation_request_id := l_request_id;
1539: arp_cr_batches_pkg.update_p(l_batch_rec,l_batch_rec.batch_id);
1540:
1541: COMMIT;
1542:
1543: IF PG_DEBUG in ('Y', 'C') THEN

Line 1697: ARP_CR_BATCHES_PKG.fetch_p(p_batch_id,l_batch_rec);

1693: select org_id into l_org_id
1694: from ar_system_parameters;
1695:
1696: -- Fetch of the remittance batch
1697: ARP_CR_BATCHES_PKG.fetch_p(p_batch_id,l_batch_rec);
1698:
1699: -- Validation
1700: IF (p_cancel_flag = 'Y') AND (l_batch_rec.batch_applied_status NOT IN ('STARTED_CREATION','COMPLETED_CREATION','STARTED_APPROVAL','STARTED_CANCELLATION')) THEN
1701: FND_MESSAGE.set_name('AR','AR_BR_CANNOT_CANCEL_REMIT');

Line 1777: arp_cr_batches_pkg.update_p(l_batch_rec,l_batch_rec.batch_id);

1773: ELSIF (p_format_flag = 'Y') AND (l_batch_rec.auto_trans_program_id IS NOT NULL) THEN
1774: l_batch_rec.batch_applied_status := 'STARTED_FORMAT';
1775: END IF;
1776:
1777: arp_cr_batches_pkg.update_p(l_batch_rec,l_batch_rec.batch_id);
1778:
1779: p_control_count := l_batch_rec.control_count;
1780: p_control_amount := l_batch_rec.control_amount;
1781: p_request_id := l_request_id;

Line 1876: ARP_CR_BATCHES_PKG.lock_fetch_p(l_batch_rec);

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);
1877:
1878: p_batch_applied_status := l_batch_rec.batch_applied_status;
1879:
1880: -- The batch status is updated only if the batch status is STARTED_CREATION

Line 1887: arp_cr_batches_pkg.update_p(l_batch_rec,l_batch_rec.batch_id);

1883: END IF;
1884:
1885: -- update the batch status to 'COMPLETED_CREATION'
1886: l_batch_rec.batch_applied_status := 'COMPLETED_CREATION';
1887: arp_cr_batches_pkg.update_p(l_batch_rec,l_batch_rec.batch_id);
1888:
1889: p_batch_applied_status := l_batch_rec.batch_applied_status;
1890:
1891: commit;