DBA Data[Home] [Help]

APPS.FV_YE_CLOSE dependencies on FV_FACTS1_RUN

Line 488: FROM Fv_Facts1_Run

484: BEGIN
485:
486: SELECT COUNT(*)
487: INTO vg_factsi_bal_cnt
488: FROM Fv_Facts1_Run
489: WHERE period_num = vg_closing_period_num
490: AND set_of_books_id = vg_sob_id
491: AND fiscal_year = vp_closing_fyr
492: and period_num = vp_closing_num;

Line 498: 'are no balances in Fv_Facts1_Run table for '||

494: IF (vg_factsi_bal_cnt = 0) THEN
495: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
496: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,' BALANCES WILL NOT BE CLOSED BY '||
497: 'the FACTS I F/N and trading partner attributes since there '||
498: 'are no balances in Fv_Facts1_Run table for '||
499: 'the period '||vg_closing_period);
500: END IF;
501: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
502: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,' TO CLOSE BY FACTS I F/N AND '||