635: -----------------------------------------------------------------------------------
636: PROCEDURE UPGRADE_BUDGET_CODES IS
637:
638: BEGIN
639: DELETE FROM fv_facts_bud_fed_accts;
640: DELETE FROM fv_facts_budget_accounts;
641:
642: fnd_file.put_line(fnd_file.log, 'Deleted all records FROM fv_facts_bud_fed_accts AND fv_facts_budget_accounts');
643: EXCEPTION
638: BEGIN
639: DELETE FROM fv_facts_bud_fed_accts;
640: DELETE FROM fv_facts_budget_accounts;
641:
642: fnd_file.put_line(fnd_file.log, 'Deleted all records FROM fv_facts_bud_fed_accts AND fv_facts_budget_accounts');
643: EXCEPTION
644: WHEN OTHERS THEN
645: g_err_buff := 'When Others Error: '||SQLERRM;
646: g_err_code := sqlcode;
1049: END;
1050:
1051: --7)Update Budget Codes Table
1052: BEGIN
1053: DELETE FROM fv_facts_bud_fed_accts;
1054: DELETE FROM fv_facts_budget_accounts;
1055: EXCEPTION
1056: WHEN OTHERS THEN
1057: FND_FILE.PUT_LINE(FND_FILE.LOG,