DBA Data[Home] [Help]

APPS.FV_UTILITY dependencies on FV_UTILITY

Line 1: PACKAGE BODY FV_UTILITY AS

1: PACKAGE BODY FV_UTILITY AS
2: --$Header: FVXUTL1B.pls 120.16.12000000.3 2007/05/15 17:24:46 sasukuma ship $
3: -- l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('FV_DEBUG_FLAG'),'N');
4: g_module_name VARCHAR2(100) ;
5: g_current_level NUMBER ;

Line 662: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.no_data_found',errbuf);

658: EXCEPTION
659: WHEN NO_DATA_FOUND THEN
660: retcode := 2;
661: errbuf := 'Period Set name not found for set of books '||to_char(sob_id);
662: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.no_data_found',errbuf);
663: RETURN ;
664: WHEN OTHERS THEN
665: retcode := SQLCODE ;
666: errbuf := SQLERRM ||

Line 668: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.exception1',errbuf);

664: WHEN OTHERS THEN
665: retcode := SQLCODE ;
666: errbuf := SQLERRM ||
667: ' -- Error in Get_Period_Year procedure,while getting the period set name.' ;
668: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.exception1',errbuf);
669: RETURN ;
670: END;
671: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
672: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,' PERIOD SET NAME IS '||VL_PERIOD_SET_NAME);

Line 672: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,' PERIOD SET NAME IS '||VL_PERIOD_SET_NAME);

668: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.exception1',errbuf);
669: RETURN ;
670: END;
671: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
672: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,' PERIOD SET NAME IS '||VL_PERIOD_SET_NAME);
673: END IF;
674:
675: BEGIN
676: SELECT period_year

Line 686: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.no_data_found1',errbuf);

682: WHEN NO_DATA_FOUND THEN
683: retcode := 2;
684: errbuf := 'Period Year not found for the set of books '||to_char(sob_id) ||
685: ' and the period set name '||vl_period_set_name;
686: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.no_data_found1',errbuf);
687: RETURN ;
688:
689: WHEN OTHERS THEN
690: retcode := SQLCODE ;

Line 693: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.exception2',errbuf);

689: WHEN OTHERS THEN
690: retcode := SQLCODE ;
691: errbuf := SQLERRM ||
692: ' -- Error in Get_Period_Year procedure,while getting the period year.' ;
693: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.exception2',errbuf);
694: RETURN ;
695: END;
696: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
697: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,' PERIOD YEAR IS '||TO_CHAR(PERIOD_YEAR));

Line 697: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,' PERIOD YEAR IS '||TO_CHAR(PERIOD_YEAR));

693: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.exception2',errbuf);
694: RETURN ;
695: END;
696: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
697: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,' PERIOD YEAR IS '||TO_CHAR(PERIOD_YEAR));
698: END IF;
699:
700: BEGIN /* From Period Start Date */
701: SELECT start_date

Line 713: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.no_data_found2',errbuf);

709: EXCEPTION
710: WHEN NO_DATA_FOUND THEN
711: retcode := 2;
712: errbuf := 'Start Date not defined for the period name '||period_from;
713: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.no_data_found2',errbuf);
714: RETURN ;
715:
716: WHEN OTHERS THEN
717: retcode := SQLCODE ;

Line 720: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.exception3',errbuf);

716: WHEN OTHERS THEN
717: retcode := SQLCODE ;
718: errbuf := SQLERRM ||
719: ' -- Error in Get_Period_Year procedure,while getting the start date for the from period '||period_from ;
720: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.exception3',errbuf);
721: RETURN ;
722: END; /* From Period Start Date */
723: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
724: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,' PERIOD START DATE IS '||TO_CHAR(PERIOD_START_DATE));

Line 724: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,' PERIOD START DATE IS '||TO_CHAR(PERIOD_START_DATE));

720: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.exception3',errbuf);
721: RETURN ;
722: END; /* From Period Start Date */
723: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
724: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,' PERIOD START DATE IS '||TO_CHAR(PERIOD_START_DATE));
725: END IF;
726:
727: BEGIN /* To Period End Date */
728: SELECT end_date

Line 740: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.no_data_found3',errbuf);

736: EXCEPTION
737: WHEN NO_DATA_FOUND THEN
738: retcode := 2;
739: errbuf := 'End Date not defined for the period name '||period_to;
740: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.no_data_found3',errbuf);
741: RETURN ;
742:
743: WHEN OTHERS THEN
744: retcode := SQLCODE ;

Line 747: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.exception4',errbuf);

743: WHEN OTHERS THEN
744: retcode := SQLCODE ;
745: errbuf := SQLERRM ||
746: ' -- Error in Get_Period_Year procedure,while getting the end date for the to period '||period_to ;
747: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.exception4',errbuf);
748: RETURN ;
749: END; /* To Period End Date */
750: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
751: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,' PERIOD END DATE IS '||TO_CHAR(PERIOD_END_DATE));

Line 751: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,' PERIOD END DATE IS '||TO_CHAR(PERIOD_END_DATE));

747: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.exception4',errbuf);
748: RETURN ;
749: END; /* To Period End Date */
750: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
751: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,' PERIOD END DATE IS '||TO_CHAR(PERIOD_END_DATE));
752: END IF;
753:
754: -- Setting up the retcode
755: retcode := 0;

Line 760: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',errbuf);

756: EXCEPTION
757: WHEN OTHERS THEN
758: retcode := SQLCODE;
759: errbuf := SQLERRM;
760: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',errbuf);
761: RETURN;
762:
763: END Get_Period_Year;
764:

Line 812: g_module_name := 'FV_UTILITY';

808: ---------------------------------------------------------------
809:
810:
811: BEGIN
812: g_module_name := 'FV_UTILITY';
813: g_current_level := fnd_log.g_current_runtime_level;
814:
815: END; -- package body