[Home] [Help]
373: FND_MESSAGE.set_token( 'BRNUM' , l_trx_rec.trx_number);
374: app_exception.raise_exception;
375: END IF;
376:
377: ARP_CT_PKG.lock_fetch_p (l_trx_rec, p_customer_trx_id);
378:
379:
380: /*-----------------------------------------------+
381: | Data preparation |
665:
666:
667: -- Do not continue if the action is not allowed for the BR
668:
669: ARP_CT_PKG.lock_fetch_p (l_trx_rec, p_customer_trx_id);
670:
671: IF (C_ACTION_REC.uncomplete_flag <> 'Y')
672: THEN
673: IF PG_DEBUG in ('Y', 'C') THEN
969: p_delete_flag => C_ACTION_REC.delete_flag );
970:
971: -- Do not continue if the action is not allowed for the BR
972:
973: ARP_CT_PKG.lock_fetch_p (l_trx_rec, p_customer_trx_id);
974:
975: IF (C_ACTION_REC.accept_flag <> 'Y')
976: THEN
977: IF PG_DEBUG in ('Y', 'C') THEN
1246:
1247:
1248: -- Do not continue if the action is not allowed for the BR
1249:
1250: ARP_CT_PKG.fetch_p (l_trx_rec, p_customer_trx_id);
1251:
1252: IF (C_ACTION_REC.hold_flag <> 'Y')
1253: THEN
1254: IF PG_DEBUG in ('Y', 'C') THEN
1517:
1518:
1519: -- Do not continue if the action is not allowed for the BR
1520:
1521: ARP_CT_PKG.fetch_p (l_trx_rec, p_customer_trx_id);
1522:
1523: IF (C_ACTION_REC.unhold_flag <> 'Y')
1524: THEN
1525: IF PG_DEBUG in ('Y', 'C') THEN
1758:
1759:
1760: -- Do not continue if the action is not allowed for the BR
1761:
1762: ARP_CT_PKG.fetch_p (l_trx_rec, l_ps_rec.customer_trx_id);
1763:
1764: IF (C_ACTION_REC.select_remit_flag <> 'Y')
1765: THEN
1766: IF PG_DEBUG in ('Y', 'C') THEN
1923:
1924:
1925: -- Do not continue if the action is not allowed for the BR
1926:
1927: ARP_CT_PKG.fetch_p (l_trx_rec, l_ps_rec.customer_trx_id);
1928:
1929: IF (C_ACTION_REC.deselect_remit_flag <> 'Y')
1930: THEN
1931: IF PG_DEBUG in ('Y', 'C') THEN
2083:
2084:
2085: -- Do not continue if the action is not allowed for the BR
2086:
2087: ARP_CT_PKG.fetch_p (l_trx_rec, l_ps_rec.customer_trx_id);
2088:
2089: IF (C_ACTION_REC.deselect_remit_flag <> 'Y')
2090: THEN
2091: IF PG_DEBUG in ('Y', 'C') THEN
2206: arp_cr_batches_pkg.fetch_p (p_batch_id, l_batch_rec);
2207:
2208: arp_ps_pkg.fetch_p (p_ps_id, l_ps_rec);
2209:
2210: ARP_CT_PKG.lock_fetch_p (l_trx_rec, l_ps_rec.customer_trx_id);
2211:
2212:
2213: /*-----------------------------------------------+
2214: | Validate the action |
2255: | Data preparation |
2256: +-----------------------------------------------*/
2257:
2258:
2259: ARP_CT_PKG.fetch_p (l_trx_rec, l_ps_rec.customer_trx_id);
2260:
2261: l_trh_rec.customer_trx_id := l_ps_rec.customer_trx_id;
2262: ARP_TRANSACTION_HISTORY_PKG.lock_fetch_f_trx_id (l_trh_rec);
2263:
2553:
2554:
2555: -- Do not continue if the action is not allowed for the BR
2556:
2557: ARP_CT_PKG.fetch_p (l_trx_rec, p_customer_trx_id);
2558:
2559: IF (C_ACTION_REC.cancel_flag <> 'Y')
2560: THEN
2561: IF PG_DEBUG in ('Y', 'C') THEN
2880:
2881:
2882: -- Do not continue if the action is not allowed for the BR
2883:
2884: ARP_CT_PKG.lock_fetch_p (l_trx_rec, p_customer_trx_id);
2885:
2886: IF (C_ACTION_REC.unpaid_flag <> 'Y')
2887: THEN
2888: IF PG_DEBUG in ('Y', 'C') THEN
3183: p_delete_flag => C_ACTION_REC.delete_flag );
3184:
3185: -- Do not continue if the action is not allowed for the BR
3186:
3187: ARP_CT_PKG.fetch_p (l_trx_rec, p_customer_trx_id);
3188:
3189: IF (C_ACTION_REC.endorse_flag <> 'Y')
3190: THEN
3191: IF PG_DEBUG in ('Y', 'C') THEN
3555:
3556:
3557: -- Do not continue if the action is not allowed for the BR
3558:
3559: ARP_CT_PKG.fetch_p (l_trx_rec, p_customer_trx_id);
3560:
3561: IF (C_ACTION_REC.protest_flag <> 'Y')
3562: THEN
3563: IF PG_DEBUG in ('Y', 'C') THEN
3817: p_delete_flag => C_ACTION_REC.delete_flag );
3818:
3819: -- Do not continue if the action is not allowed for the BR
3820:
3821: ARP_CT_PKG.fetch_p (l_trx_rec, p_customer_trx_id);
3822:
3823: IF (C_ACTION_REC.restate_flag <> 'Y')
3824: THEN
3825: IF PG_DEBUG in ('Y', 'C') THEN
4096: p_delete_flag => C_ACTION_REC.delete_flag );
4097:
4098: -- Do not continue if the action is not allowed for the BR
4099:
4100: ARP_CT_PKG.fetch_p (l_trx_rec, p_customer_trx_id);
4101:
4102: IF (C_ACTION_REC.recall_flag <> 'Y')
4103: THEN
4104: IF PG_DEBUG in ('Y', 'C') THEN
4423: p_delete_flag => C_ACTION_REC.delete_flag );
4424:
4425: -- Do not continue if the action is not allowed for the BR
4426:
4427: ARP_CT_PKG.fetch_p (l_trx_rec, p_customer_trx_id);
4428:
4429: IF (C_ACTION_REC.eliminate_flag <> 'Y')
4430: THEN
4431: IF PG_DEBUG in ('Y', 'C') THEN
4763: p_delete_flag => C_ACTION_REC.delete_flag );
4764:
4765: -- Do not continue if the action is not allowed for the BR
4766:
4767: ARP_CT_PKG.fetch_p (l_trx_rec, p_customer_trx_id);
4768:
4769: IF (C_ACTION_REC.uneliminate_flag <> 'Y')
4770: THEN
4771: IF PG_DEBUG in ('Y', 'C') THEN
5127:
5128:
5129: -- Do not continue if the action is not allowed for the BR
5130:
5131: ARP_CT_PKG.lock_fetch_p (l_trx_rec, p_customer_trx_id);
5132:
5133: IF (C_ACTION_REC.exchange_flag <> 'Y')
5134: THEN
5135: IF PG_DEBUG in ('Y', 'C') THEN