eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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.25.12020000.3 2013/02/13 14:52:06 snama 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 661: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.no_data_found',errbuf);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1190: g_module_name := 'FV_UTILITY.';

1186: END;
1187:
1188:
1189: BEGIN
1190: g_module_name := 'FV_UTILITY.';
1191: g_current_level := fnd_log.g_current_runtime_level;
1192:
1193: END; -- package body