[Home] [Help]
362: FND_MESSAGE.set_token( 'BRNUM' , l_trx_rec.trx_number);
363: app_exception.raise_exception;
364: END IF;
365:
366: ARP_CT_PKG.lock_fetch_p (l_trx_rec, p_customer_trx_id);
367:
368:
369: /*-----------------------------------------------+
370: | Data preparation |
654:
655:
656: -- Do not continue if the action is not allowed for the BR
657:
658: ARP_CT_PKG.lock_fetch_p (l_trx_rec, p_customer_trx_id);
659:
660: IF (C_ACTION_REC.uncomplete_flag <> 'Y')
661: THEN
662: IF PG_DEBUG in ('Y', 'C') THEN
958: p_delete_flag => C_ACTION_REC.delete_flag );
959:
960: -- Do not continue if the action is not allowed for the BR
961:
962: ARP_CT_PKG.lock_fetch_p (l_trx_rec, p_customer_trx_id);
963:
964: IF (C_ACTION_REC.accept_flag <> 'Y')
965: THEN
966: IF PG_DEBUG in ('Y', 'C') THEN
1235:
1236:
1237: -- Do not continue if the action is not allowed for the BR
1238:
1239: ARP_CT_PKG.fetch_p (l_trx_rec, p_customer_trx_id);
1240:
1241: IF (C_ACTION_REC.hold_flag <> 'Y')
1242: THEN
1243: IF PG_DEBUG in ('Y', 'C') THEN
1506:
1507:
1508: -- Do not continue if the action is not allowed for the BR
1509:
1510: ARP_CT_PKG.fetch_p (l_trx_rec, p_customer_trx_id);
1511:
1512: IF (C_ACTION_REC.unhold_flag <> 'Y')
1513: THEN
1514: IF PG_DEBUG in ('Y', 'C') THEN
1747:
1748:
1749: -- Do not continue if the action is not allowed for the BR
1750:
1751: ARP_CT_PKG.fetch_p (l_trx_rec, l_ps_rec.customer_trx_id);
1752:
1753: IF (C_ACTION_REC.select_remit_flag <> 'Y')
1754: THEN
1755: IF PG_DEBUG in ('Y', 'C') THEN
1912:
1913:
1914: -- Do not continue if the action is not allowed for the BR
1915:
1916: ARP_CT_PKG.fetch_p (l_trx_rec, l_ps_rec.customer_trx_id);
1917:
1918: IF (C_ACTION_REC.deselect_remit_flag <> 'Y')
1919: THEN
1920: IF PG_DEBUG in ('Y', 'C') THEN
2072:
2073:
2074: -- Do not continue if the action is not allowed for the BR
2075:
2076: ARP_CT_PKG.fetch_p (l_trx_rec, l_ps_rec.customer_trx_id);
2077:
2078: IF (C_ACTION_REC.deselect_remit_flag <> 'Y')
2079: THEN
2080: IF PG_DEBUG in ('Y', 'C') THEN
2195: arp_cr_batches_pkg.fetch_p (p_batch_id, l_batch_rec);
2196:
2197: arp_ps_pkg.fetch_p (p_ps_id, l_ps_rec);
2198:
2199: ARP_CT_PKG.lock_fetch_p (l_trx_rec, l_ps_rec.customer_trx_id);
2200:
2201:
2202: /*-----------------------------------------------+
2203: | Validate the action |
2244: | Data preparation |
2245: +-----------------------------------------------*/
2246:
2247:
2248: ARP_CT_PKG.fetch_p (l_trx_rec, l_ps_rec.customer_trx_id);
2249:
2250: l_trh_rec.customer_trx_id := l_ps_rec.customer_trx_id;
2251: ARP_TRANSACTION_HISTORY_PKG.lock_fetch_f_trx_id (l_trh_rec);
2252:
2542:
2543:
2544: -- Do not continue if the action is not allowed for the BR
2545:
2546: ARP_CT_PKG.fetch_p (l_trx_rec, p_customer_trx_id);
2547:
2548: IF (C_ACTION_REC.cancel_flag <> 'Y')
2549: THEN
2550: IF PG_DEBUG in ('Y', 'C') THEN
2869:
2870:
2871: -- Do not continue if the action is not allowed for the BR
2872:
2873: ARP_CT_PKG.lock_fetch_p (l_trx_rec, p_customer_trx_id);
2874:
2875: IF (C_ACTION_REC.unpaid_flag <> 'Y')
2876: THEN
2877: IF PG_DEBUG in ('Y', 'C') THEN
3172: p_delete_flag => C_ACTION_REC.delete_flag );
3173:
3174: -- Do not continue if the action is not allowed for the BR
3175:
3176: ARP_CT_PKG.fetch_p (l_trx_rec, p_customer_trx_id);
3177:
3178: IF (C_ACTION_REC.endorse_flag <> 'Y')
3179: THEN
3180: IF PG_DEBUG in ('Y', 'C') THEN
3544:
3545:
3546: -- Do not continue if the action is not allowed for the BR
3547:
3548: ARP_CT_PKG.fetch_p (l_trx_rec, p_customer_trx_id);
3549:
3550: IF (C_ACTION_REC.protest_flag <> 'Y')
3551: THEN
3552: IF PG_DEBUG in ('Y', 'C') THEN
3806: p_delete_flag => C_ACTION_REC.delete_flag );
3807:
3808: -- Do not continue if the action is not allowed for the BR
3809:
3810: ARP_CT_PKG.fetch_p (l_trx_rec, p_customer_trx_id);
3811:
3812: IF (C_ACTION_REC.restate_flag <> 'Y')
3813: THEN
3814: IF PG_DEBUG in ('Y', 'C') THEN
4085: p_delete_flag => C_ACTION_REC.delete_flag );
4086:
4087: -- Do not continue if the action is not allowed for the BR
4088:
4089: ARP_CT_PKG.fetch_p (l_trx_rec, p_customer_trx_id);
4090:
4091: IF (C_ACTION_REC.recall_flag <> 'Y')
4092: THEN
4093: IF PG_DEBUG in ('Y', 'C') THEN
4412: p_delete_flag => C_ACTION_REC.delete_flag );
4413:
4414: -- Do not continue if the action is not allowed for the BR
4415:
4416: ARP_CT_PKG.fetch_p (l_trx_rec, p_customer_trx_id);
4417:
4418: IF (C_ACTION_REC.eliminate_flag <> 'Y')
4419: THEN
4420: IF PG_DEBUG in ('Y', 'C') THEN
4752: p_delete_flag => C_ACTION_REC.delete_flag );
4753:
4754: -- Do not continue if the action is not allowed for the BR
4755:
4756: ARP_CT_PKG.fetch_p (l_trx_rec, p_customer_trx_id);
4757:
4758: IF (C_ACTION_REC.uneliminate_flag <> 'Y')
4759: THEN
4760: IF PG_DEBUG in ('Y', 'C') THEN
5116:
5117:
5118: -- Do not continue if the action is not allowed for the BR
5119:
5120: ARP_CT_PKG.lock_fetch_p (l_trx_rec, p_customer_trx_id);
5121:
5122: IF (C_ACTION_REC.exchange_flag <> 'Y')
5123: THEN
5124: IF PG_DEBUG in ('Y', 'C') THEN