APPS.ARP_PROGRAM_BR_REMIT dependencies on ARP_CR_BATCHES_PKG

Line 352: ARP_CR_BATCHES_PKG.lock_fetch_p(l_batch_rec);

348: SAVEPOINT create_remit_PVT;
349:
350: -- lock and fetch of the batch row
351: l_batch_rec.batch_id := p_batch_id;
352: ARP_CR_BATCHES_PKG.lock_fetch_p(l_batch_rec);
353:
354: -- The action Create is enabled only if the batch status is STARTED_CREATION
355: IF l_batch_rec.batch_applied_status NOT IN ('STARTED_CREATION') THEN
356: FND_MESSAGE.set_name('AR','AR_BR_CANNOT_RECREATE_REMIT');

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

435: -- update the batch row with the control count and the control amount
436: l_batch_rec.control_count := l_control_count;
437: l_batch_rec.control_amount := l_control_amount;
438: l_batch_rec.batch_applied_status := 'COMPLETED_CREATION';
439: arp_cr_batches_pkg.update_p(l_batch_rec,l_batch_rec.batch_id);
440:
441: FND_FILE.PUT_LINE(FND_FILE.LOG,'-------------- ACTION CREATE --------------');
442: FND_FILE.PUT_LINE(FND_FILE.LOG,'BR Remittance number :'||l_batch_rec.name);
443: FND_FILE.PUT_LINE(FND_FILE.LOG,'Count :'||l_control_count);

Line 507: ARP_CR_BATCHES_PKG.lock_fetch_p(l_batch_rec);

503: SAVEPOINT cancel_remit_PVT;
504:
505: -- lock and fetch of the batch row
506: l_batch_rec.batch_id := p_batch_id;
507: ARP_CR_BATCHES_PKG.lock_fetch_p(l_batch_rec);
508:
509: -- The action Cancel is enabled only if the batch status is STARTED_CANCELLATION
510: IF l_batch_rec.batch_applied_status NOT IN ('STARTED_CANCELLATION') THEN
511: FND_MESSAGE.set_name('AR','AR_BR_CANNOT_CANCEL_REMIT');

Line 591: ARP_CR_BATCHES_PKG.lock_fetch_p(l_batch_rec);

587: SAVEPOINT approve_remit_PVT;
588:
589: -- lock and fetch of the batch row
590: l_batch_rec.batch_id := p_batch_id;
591: ARP_CR_BATCHES_PKG.lock_fetch_p(l_batch_rec);
592:
593: -- The action Approve is enabled only if the batch status is COMPLETED_CREATION and STARTED_APPROVAL
594: IF l_batch_rec.batch_applied_status NOT IN ('COMPLETED_CREATION','STARTED_APPROVAL') THEN
595: FND_MESSAGE.set_name('AR','AR_BR_CANNOT_APPROVE_REMIT');

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

609:
610: -- update the batch row with the batch applied status
611: l_batch_rec.status := 'CL';
612: l_batch_rec.batch_applied_status := 'COMPLETED_APPROVAL';
613: arp_cr_batches_pkg.update_p(l_batch_rec,l_batch_rec.batch_id);
614:
615: commit;
616:
617: FND_FILE.PUT_LINE(FND_FILE.LOG,'-------------- ACTION APPROVE --------------');

Line 692: ARP_CR_BATCHES_PKG.lock_fetch_p(l_batch_rec);

688: SAVEPOINT format_remit_PVT;
689:
690: -- lock and fetch of the batch row
691: l_batch_rec.batch_id := p_batch_id;
692: ARP_CR_BATCHES_PKG.lock_fetch_p(l_batch_rec);
693:
694: -- The action Format is enabled only if the transmission program field is filled
695: /*
696: IF l_batch_rec.auto_trans_program_id IS NULL THEN

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

755: END IF;
756:
757: -- update the batch row with the control count and the control amount
758: l_batch_rec.batch_applied_status := 'COMPLETED_FORMAT';
759: arp_cr_batches_pkg.update_p(l_batch_rec,l_batch_rec.batch_id);
760:
761: commit;
762:
763: FND_FILE.PUT_LINE(FND_FILE.LOG,'--------------------------------------------');

Line 835: ARP_CR_BATCHES_PKG.lock_fetch_p(l_batch_rec);

831: SAVEPOINT print_remit_PVT;
832:
833: -- lock and fetch of the batch row
834: l_batch_rec.batch_id := p_batch_id;
835: ARP_CR_BATCHES_PKG.lock_fetch_p(l_batch_rec);
836:
837: -- parameter sort_by value must be BATCH NAME
838: select lookup_code
839: into l_sort_by

Line 995: ARP_CR_BATCHES_PKG.lock_fetch_p(l_batch_rec);

991: SAVEPOINT print_bills_remit_PVT;
992:
993: -- lock and fetch of the batch row
994: l_batch_rec.batch_id := p_batch_id;
995: ARP_CR_BATCHES_PKG.lock_fetch_p(l_batch_rec);
996:
997: FND_FILE.PUT_LINE(FND_FILE.LOG,'----------- ACTION Print Bills -------------');
998: FND_FILE.PUT_LINE(FND_FILE.LOG,'BR Remittance number : ' || l_batch_rec.name);
999: FND_FILE.PUT_LINE(FND_FILE.LOG,'Program ARBRFMTW parameters');