1: PACKAGE BODY ARP_XLA_UPGRADE AS
2: /* $Header: ARXLAUPB.pls 120.41.12020000.3 2013/03/03 17:20:10 naneja ship $ */
3:
4: PROCEDURE UPGRADE_TRANSACTIONS(
5: l_table_owner IN VARCHAR2,
828: END LOOP ; /* end of WHILE loop */
829:
830: EXCEPTION
831: WHEN NO_DATA_FOUND THEN
832: --arp_standard.debug('NO_DATA_FOUND EXCEPTION: ARP_XLA_UPGRADE.upgrade_transactions');
833: RAISE;
834:
835: WHEN OTHERS THEN
836: --arp_standard.debug('OTHERS EXCEPTION: ARP_XLA_UPGRADE.upgrade_transactions');
832: --arp_standard.debug('NO_DATA_FOUND EXCEPTION: ARP_XLA_UPGRADE.upgrade_transactions');
833: RAISE;
834:
835: WHEN OTHERS THEN
836: --arp_standard.debug('OTHERS EXCEPTION: ARP_XLA_UPGRADE.upgrade_transactions');
837: RAISE;
838:
839: END UPGRADE_TRANSACTIONS;
840:
1490: END LOOP ; /* end of WHILE loop */
1491:
1492: EXCEPTION
1493: WHEN NO_DATA_FOUND THEN
1494: --arp_standard.debug('NO_DATA_FOUND EXCEPTION: ARP_XLA_UPGRADE.upgrade_bills_receivable');
1495: RAISE;
1496:
1497: WHEN OTHERS THEN
1498: --arp_standard.debug('OTHERS EXCEPTION: ARP_XLA_UPGRADE.upgrade_bills_receivable');
1494: --arp_standard.debug('NO_DATA_FOUND EXCEPTION: ARP_XLA_UPGRADE.upgrade_bills_receivable');
1495: RAISE;
1496:
1497: WHEN OTHERS THEN
1498: --arp_standard.debug('OTHERS EXCEPTION: ARP_XLA_UPGRADE.upgrade_bills_receivable');
1499: RAISE;
1500:
1501: END UPGRADE_BILLS_RECEIVABLE;
1502:
2533: END LOOP ; /* end of WHILE loop */
2534:
2535: EXCEPTION
2536: WHEN NO_DATA_FOUND THEN
2537: --arp_standard.debug('NO_DATA_FOUND EXCEPTION: ARP_XLA_UPGRADE.upgrade_receipts');
2538: RAISE;
2539:
2540: WHEN OTHERS THEN
2541: --arp_standard.debug('OTHERS EXCEPTION: ARP_XLA_UPGRADE.upgrade_receipts');
2537: --arp_standard.debug('NO_DATA_FOUND EXCEPTION: ARP_XLA_UPGRADE.upgrade_receipts');
2538: RAISE;
2539:
2540: WHEN OTHERS THEN
2541: --arp_standard.debug('OTHERS EXCEPTION: ARP_XLA_UPGRADE.upgrade_receipts');
2542: RAISE;
2543:
2544: END UPGRADE_RECEIPTS;
2545:
3098: END LOOP ; /* end of WHILE loop */
3099:
3100: EXCEPTION
3101: WHEN NO_DATA_FOUND THEN
3102: --arp_standard.debug('NO_DATA_FOUND EXCEPTION: ARP_XLA_UPGRADE.upgrade_adjustments');
3103: RAISE;
3104:
3105: WHEN OTHERS THEN
3106: --arp_standard.debug('OTHERS EXCEPTION: ARP_XLA_UPGRADE.upgrade_adjustments');
3102: --arp_standard.debug('NO_DATA_FOUND EXCEPTION: ARP_XLA_UPGRADE.upgrade_adjustments');
3103: RAISE;
3104:
3105: WHEN OTHERS THEN
3106: --arp_standard.debug('OTHERS EXCEPTION: ARP_XLA_UPGRADE.upgrade_adjustments');
3107: RAISE;
3108:
3109: END UPGRADE_ADJUSTMENTS;
3110:
3160: where start_date >= (select min(start_date) from XLA_UPGRADE_DATES)
3161: and end_date <= (select max(end_date) from XLA_UPGRADE_DATES);
3162: EXCEPTION
3163: WHEN NO_DATA_FOUND THEN
3164: -- arp_standard.debug('NO_DATA_FOUND EXCEPTION: ARP_XLA_UPGRADE.update_gl_sla_link');
3165: -- arp_standard.debug('NO_DATA_FOUND EXCEPTION: Insert into ar120gir_periods');
3166: RAISE;
3167:
3168: WHEN OTHERS THEN
3165: -- arp_standard.debug('NO_DATA_FOUND EXCEPTION: Insert into ar120gir_periods');
3166: RAISE;
3167:
3168: WHEN OTHERS THEN
3169: -- arp_standard.debug('OTHERS EXCEPTION: ARP_XLA_UPGRADE.update_gl_sla_link');
3170: -- arp_standard.debug('NO_DATA_FOUND EXCEPTION: Insert into ar120gir_periods');
3171: RAISE;
3172: END;
3173:
3447: END LOOP ; /* end of WHILE loop */
3448:
3449: EXCEPTION
3450: WHEN NO_DATA_FOUND THEN
3451: --arp_standard.debug('NO_DATA_FOUND EXCEPTION: ARP_XLA_UPGRADE.update_gl_sla_link');
3452: RAISE;
3453:
3454: WHEN OTHERS THEN
3455: --arp_standard.debug('OTHERS EXCEPTION: ARP_XLA_UPGRADE.update_gl_sla_link');
3451: --arp_standard.debug('NO_DATA_FOUND EXCEPTION: ARP_XLA_UPGRADE.update_gl_sla_link');
3452: RAISE;
3453:
3454: WHEN OTHERS THEN
3455: --arp_standard.debug('OTHERS EXCEPTION: ARP_XLA_UPGRADE.update_gl_sla_link');
3456: RAISE;
3457:
3458: END update_gl_sla_link;
3459: --}
3814: END LOOP ; /* end of WHILE loop */
3815:
3816: EXCEPTION
3817: WHEN NO_DATA_FOUND THEN
3818: --arp_standard.debug('NO_DATA_FOUND EXCEPTION: ARP_XLA_UPGRADE.upgrade_cash_dist');
3819: RAISE;
3820:
3821: WHEN OTHERS THEN
3822: --arp_standard.debug('OTHERS EXCEPTION: ARP_XLA_UPGRADE.upgrade_cash_dist');
3818: --arp_standard.debug('NO_DATA_FOUND EXCEPTION: ARP_XLA_UPGRADE.upgrade_cash_dist');
3819: RAISE;
3820:
3821: WHEN OTHERS THEN
3822: --arp_standard.debug('OTHERS EXCEPTION: ARP_XLA_UPGRADE.upgrade_cash_dist');
3823: RAISE;
3824:
3825: END UPGRADE_CASH_DIST;
3826:
5186: RAISE;
5187: END UPGRADE_CASH_RA_DATA;
5188:
5189:
5190: END ARP_XLA_UPGRADE;