1: PACKAGE BODY ARP_MRC_XLA_UPGRADE AS
2: /* $Header: ARMXLAUB.pls 120.14 2006/12/16 00:27:15 jvarkey noship $ */
3:
4: PROCEDURE UPGRADE_MC_GAIN_LOSS(
5: l_start_rowid IN ROWID,
893: END LOOP ; /* end of WHILE loop */
894:
895: EXCEPTION
896: WHEN NO_DATA_FOUND THEN
897: --arp_standard.debug('NO_DATA_FOUND EXCEPTION: ARP_MRC_XLA_UPGRADE.upgrade_mc_transactions');
898: RAISE;
899:
900: WHEN OTHERS THEN
901: --arp_standard.debug('OTHERS EXCEPTION: ARP_MRC_XLA_UPGRADE.upgrade_mc_transactions');
897: --arp_standard.debug('NO_DATA_FOUND EXCEPTION: ARP_MRC_XLA_UPGRADE.upgrade_mc_transactions');
898: RAISE;
899:
900: WHEN OTHERS THEN
901: --arp_standard.debug('OTHERS EXCEPTION: ARP_MRC_XLA_UPGRADE.upgrade_mc_transactions');
902: RAISE;
903:
904: END UPGRADE_MC_TRANSACTIONS;
905:
1761: END LOOP ; /* end of WHILE loop */
1762:
1763: EXCEPTION
1764: WHEN NO_DATA_FOUND THEN
1765: --arp_standard.debug('NO_DATA_FOUND EXCEPTION: ARP_MRC_XLA_UPGRADE.upgrade_mc_receipts');
1766: RAISE;
1767:
1768: WHEN OTHERS THEN
1769: --arp_standard.debug('OTHERS EXCEPTION: ARP_MRC_XLA_UPGRADE.upgrade_mc_receipts');
1765: --arp_standard.debug('NO_DATA_FOUND EXCEPTION: ARP_MRC_XLA_UPGRADE.upgrade_mc_receipts');
1766: RAISE;
1767:
1768: WHEN OTHERS THEN
1769: --arp_standard.debug('OTHERS EXCEPTION: ARP_MRC_XLA_UPGRADE.upgrade_mc_receipts');
1770: RAISE;
1771:
1772: END UPGRADE_MC_RECEIPTS;
1773:
2297: END LOOP ; /* end of WHILE loop */
2298:
2299: EXCEPTION
2300: WHEN NO_DATA_FOUND THEN
2301: --arp_standard.debug('NO_DATA_FOUND EXCEPTION: ARP_MRC_XLA_UPGRADE.upgrade_mc_adjustments');
2302: RAISE;
2303:
2304: WHEN OTHERS THEN
2305: --arp_standard.debug('OTHERS EXCEPTION: ARP_MRC_XLA_UPGRADE.upgrade_mc_adjustments');
2301: --arp_standard.debug('NO_DATA_FOUND EXCEPTION: ARP_MRC_XLA_UPGRADE.upgrade_mc_adjustments');
2302: RAISE;
2303:
2304: WHEN OTHERS THEN
2305: --arp_standard.debug('OTHERS EXCEPTION: ARP_MRC_XLA_UPGRADE.upgrade_mc_adjustments');
2306: RAISE;
2307:
2308: END UPGRADE_MC_ADJUSTMENTS;
2309:
2917: END IF; /* If l_table */
2918:
2919: EXCEPTION
2920: WHEN NO_DATA_FOUND THEN
2921: --arp_standard.debug('NO_DATA_FOUND EXCEPTION: ARP_MRC_XLA_UPGRADE.upgrade_mc_gain_loss');
2922: RAISE;
2923:
2924: WHEN OTHERS THEN
2925: --arp_standard.debug('OTHERS EXCEPTION: ARP_MRC_XLA_UPGRADE.upgrade_mc_gain_loss');
2921: --arp_standard.debug('NO_DATA_FOUND EXCEPTION: ARP_MRC_XLA_UPGRADE.upgrade_mc_gain_loss');
2922: RAISE;
2923:
2924: WHEN OTHERS THEN
2925: --arp_standard.debug('OTHERS EXCEPTION: ARP_MRC_XLA_UPGRADE.upgrade_mc_gain_loss');
2926: RAISE;
2927:
2928: END UPGRADE_MC_GAIN_LOSS;
2929:
2926: RAISE;
2927:
2928: END UPGRADE_MC_GAIN_LOSS;
2929:
2930: END ARP_MRC_XLA_UPGRADE;