1: PACKAGE BODY ARP_MRC_XLA_UPGRADE AS
2: /* $Header: ARMXLAUB.pls 120.14.12020000.3 2013/02/20 11:02:04 kyennawa ship $ */
3:
4: PROCEDURE UPGRADE_MC_GAIN_LOSS(
5: l_start_rowid IN ROWID,
915: END LOOP ; /* end of WHILE loop */
916:
917: EXCEPTION
918: WHEN NO_DATA_FOUND THEN
919: --arp_standard.debug('NO_DATA_FOUND EXCEPTION: ARP_MRC_XLA_UPGRADE.upgrade_mc_transactions');
920: RAISE;
921:
922: WHEN OTHERS THEN
923: --arp_standard.debug('OTHERS EXCEPTION: ARP_MRC_XLA_UPGRADE.upgrade_mc_transactions');
919: --arp_standard.debug('NO_DATA_FOUND EXCEPTION: ARP_MRC_XLA_UPGRADE.upgrade_mc_transactions');
920: RAISE;
921:
922: WHEN OTHERS THEN
923: --arp_standard.debug('OTHERS EXCEPTION: ARP_MRC_XLA_UPGRADE.upgrade_mc_transactions');
924: RAISE;
925:
926: END UPGRADE_MC_TRANSACTIONS;
927:
1813: END LOOP ; /* end of WHILE loop */
1814:
1815: EXCEPTION
1816: WHEN NO_DATA_FOUND THEN
1817: --arp_standard.debug('NO_DATA_FOUND EXCEPTION: ARP_MRC_XLA_UPGRADE.upgrade_mc_receipts');
1818: RAISE;
1819:
1820: WHEN OTHERS THEN
1821: --arp_standard.debug('OTHERS EXCEPTION: ARP_MRC_XLA_UPGRADE.upgrade_mc_receipts');
1817: --arp_standard.debug('NO_DATA_FOUND EXCEPTION: ARP_MRC_XLA_UPGRADE.upgrade_mc_receipts');
1818: RAISE;
1819:
1820: WHEN OTHERS THEN
1821: --arp_standard.debug('OTHERS EXCEPTION: ARP_MRC_XLA_UPGRADE.upgrade_mc_receipts');
1822: RAISE;
1823:
1824: END UPGRADE_MC_RECEIPTS;
1825:
2350: END LOOP ; /* end of WHILE loop */
2351:
2352: EXCEPTION
2353: WHEN NO_DATA_FOUND THEN
2354: --arp_standard.debug('NO_DATA_FOUND EXCEPTION: ARP_MRC_XLA_UPGRADE.upgrade_mc_adjustments');
2355: RAISE;
2356:
2357: WHEN OTHERS THEN
2358: --arp_standard.debug('OTHERS EXCEPTION: ARP_MRC_XLA_UPGRADE.upgrade_mc_adjustments');
2354: --arp_standard.debug('NO_DATA_FOUND EXCEPTION: ARP_MRC_XLA_UPGRADE.upgrade_mc_adjustments');
2355: RAISE;
2356:
2357: WHEN OTHERS THEN
2358: --arp_standard.debug('OTHERS EXCEPTION: ARP_MRC_XLA_UPGRADE.upgrade_mc_adjustments');
2359: RAISE;
2360:
2361: END UPGRADE_MC_ADJUSTMENTS;
2362:
3000: END IF; /* If l_table */
3001:
3002: EXCEPTION
3003: WHEN NO_DATA_FOUND THEN
3004: --arp_standard.debug('NO_DATA_FOUND EXCEPTION: ARP_MRC_XLA_UPGRADE.upgrade_mc_gain_loss');
3005: RAISE;
3006:
3007: WHEN OTHERS THEN
3008: --arp_standard.debug('OTHERS EXCEPTION: ARP_MRC_XLA_UPGRADE.upgrade_mc_gain_loss');
3004: --arp_standard.debug('NO_DATA_FOUND EXCEPTION: ARP_MRC_XLA_UPGRADE.upgrade_mc_gain_loss');
3005: RAISE;
3006:
3007: WHEN OTHERS THEN
3008: --arp_standard.debug('OTHERS EXCEPTION: ARP_MRC_XLA_UPGRADE.upgrade_mc_gain_loss');
3009: RAISE;
3010:
3011: END UPGRADE_MC_GAIN_LOSS;
3012:
3009: RAISE;
3010:
3011: END UPGRADE_MC_GAIN_LOSS;
3012:
3013: END ARP_MRC_XLA_UPGRADE;