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 1214: ARP_CR_BATCHES_PKG.fetch_p(p_batch_id,l_batch_rec);

1210: APP_EXCEPTION.raise_exception;
1211: END IF;
1212:
1213: -- fetch the remittance batch row
1214: ARP_CR_BATCHES_PKG.fetch_p(p_batch_id,l_batch_rec);
1215: l_control_count := l_batch_rec.control_count;
1216: l_control_amount := l_batch_rec.control_amount;
1217:
1218: -- The remittance has been approved; no changes are allowed

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

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

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

1460: select org_id into l_org_id
1461: from ar_system_parameters;
1462:
1463: -- Fetch of the remittance batch
1464: ARP_CR_BATCHES_PKG.fetch_p(p_batch_id,l_batch_rec);
1465:
1466: --MOAC changes
1467: FND_REQUEST.SET_ORG_ID(l_org_id);
1468: -- Submit the BR Remittance auto Create concurrent program as a concurrent request

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

1524: p_batch_applied_status := l_batch_rec.batch_applied_status;
1525:
1526: -- Update the batch row with the request id
1527: l_batch_rec.operation_request_id := l_request_id;
1528: arp_cr_batches_pkg.update_p(l_batch_rec,l_batch_rec.batch_id);
1529:
1530: COMMIT;
1531:
1532: IF PG_DEBUG in ('Y', 'C') THEN

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

1682: select org_id into l_org_id
1683: from ar_system_parameters;
1684:
1685: -- Fetch of the remittance batch
1686: ARP_CR_BATCHES_PKG.fetch_p(p_batch_id,l_batch_rec);
1687:
1688: -- Validation
1689: IF (p_cancel_flag = 'Y') AND (l_batch_rec.batch_applied_status NOT IN ('STARTED_CREATION','COMPLETED_CREATION','STARTED_APPROVAL','STARTED_CANCELLATION')) THEN
1690: FND_MESSAGE.set_name('AR','AR_BR_CANNOT_CANCEL_REMIT');

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

1762: ELSIF (p_format_flag = 'Y') AND (l_batch_rec.auto_trans_program_id IS NOT NULL) THEN
1763: l_batch_rec.batch_applied_status := 'STARTED_FORMAT';
1764: END IF;
1765:
1766: arp_cr_batches_pkg.update_p(l_batch_rec,l_batch_rec.batch_id);
1767:
1768: p_control_count := l_batch_rec.control_count;
1769: p_control_amount := l_batch_rec.control_amount;
1770: p_request_id := l_request_id;

Line 1865: ARP_CR_BATCHES_PKG.lock_fetch_p(l_batch_rec);

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);
1866:
1867: p_batch_applied_status := l_batch_rec.batch_applied_status;
1868:
1869: -- The batch status is updated only if the batch status is STARTED_CREATION

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

1872: END IF;
1873:
1874: -- update the batch status to 'COMPLETED_CREATION'
1875: l_batch_rec.batch_applied_status := 'COMPLETED_CREATION';
1876: arp_cr_batches_pkg.update_p(l_batch_rec,l_batch_rec.batch_id);
1877:
1878: p_batch_applied_status := l_batch_rec.batch_applied_status;
1879:
1880: commit;