DBA Data[Home] [Help]

APPS.FV_UTILITY dependencies on FND_LOG

Line 23: l_level := fnd_log.LEVEL_ERROR ;

19: l_level NUMBER ;
20: l_module VARCHAR2(2000) ;
21: BEGIN
22: IF p_level IS NULL THEN
23: l_level := fnd_log.LEVEL_ERROR ;
24: ELSE
25: l_level := p_level;
26: END IF;
27:

Line 35: fnd_log.message (l_level, l_module, p_pop);

31: l_module := p_module;
32: END IF;
33:
34: IF (l_level >= g_current_level) THEN
35: fnd_log.message (l_level, l_module, p_pop);
36: END IF;
37: END;
38:
39: PROCEDURE message

Line 50: l_level := fnd_log.LEVEL_ERROR ;

46: l_module VARCHAR2(2000) ;
47: BEGIN
48:
49: IF p_level IS NULL THEN
50: l_level := fnd_log.LEVEL_ERROR ;
51: ELSE
52: l_level := p_level;
53: END IF;
54:

Line 62: fnd_log.message (l_level, l_module, p_pop);

58: l_module := p_module;
59: END IF;
60:
61: IF (l_level >= g_current_level) THEN
62: fnd_log.message (l_level, l_module, p_pop);
63: END IF;
64: END;
65:
66: PROCEDURE log_mesg

Line 74: fnd_log.string (p_level, p_module, p_message);

70: p_message IN VARCHAR2
71: ) IS
72: BEGIN
73: IF (p_level >= g_current_level) THEN
74: fnd_log.string (p_level, p_module, p_message);
75: END IF;
76: FND_FILE.PUT_LINE(FND_FILE.LOG, p_message);
77: END;
78:

Line 91: l_level := fnd_log.LEVEL_STATEMENT;

87: l_module VARCHAR2(2000) ;
88: BEGIN
89:
90: IF p_level IS NULL THEN
91: l_level := fnd_log.LEVEL_STATEMENT;
92: ELSE
93: l_level := p_level;
94: END IF;
95:

Line 112: IF p_level >= fnd_log.LEVEL_STATEMENT THEN

108: p_module IN VARCHAR2,
109: p_message IN VARCHAR2
110: ) IS
111: BEGIN
112: IF p_level >= fnd_log.LEVEL_STATEMENT THEN
113: fnd_log.string (p_level, p_module, p_message);
114: END IF;
115: END;
116:

Line 113: fnd_log.string (p_level, p_module, p_message);

109: p_message IN VARCHAR2
110: ) IS
111: BEGIN
112: IF p_level >= fnd_log.LEVEL_STATEMENT THEN
113: fnd_log.string (p_level, p_module, p_message);
114: END IF;
115: END;
116:
117:

Line 130: l_level := fnd_log.LEVEL_STATEMENT;

126:
127:
128: BEGIN
129: IF p_level IS NULL THEN
130: l_level := fnd_log.LEVEL_STATEMENT;
131: ELSE
132: l_level := p_level;
133: END IF;
134:

Line 163: LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',l_errbuf);

159: RETURN (l_time);
160: EXCEPTION
161: WHEN OTHERS THEN
162: l_errbuf := SQLERRM;
163: LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',l_errbuf);
164: RAISE;
165:
166: END;
167:

Line 250: LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.final_exception',error_message);

246: EXCEPTION
247: WHEN no_data_exception THEN
248: error_code := TRUE;
249: error_message := ('No data found for this FV Context Variable '||variable_type);
250: LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.final_exception',error_message);
251:
252: WHEN others THEN
253: error_code := TRUE;
254: error_message := 'Error in retrieving FV Context Variables for '||variable_type||' - '||sqlerrm;

Line 255: LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',error_message);

251:
252: WHEN others THEN
253: error_code := TRUE;
254: error_message := 'Error in retrieving FV Context Variables for '||variable_type||' - '||sqlerrm;
255: LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',error_message);
256:
257: END get_context;
258:
259: ---added GET REPORT INFO PROCEDURE

Line 383: LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',l_errbuf);

379: WHEN OTHERS THEN
380: l_errbuf := SQLERRM;
381: Fnd_Message.Set_Name('FV','FV_DC_GENERAL');
382: FND_MESSAGE.SET_TOKEN('MSG','UNHANDLED EXCEPTION IN GETTING REPORT INFORMATION');
383: LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',l_errbuf);
384: MESSAGE(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception');
385:
386: App_Exception.Raise_Exception;
387:

Line 384: MESSAGE(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception');

380: l_errbuf := SQLERRM;
381: Fnd_Message.Set_Name('FV','FV_DC_GENERAL');
382: FND_MESSAGE.SET_TOKEN('MSG','UNHANDLED EXCEPTION IN GETTING REPORT INFORMATION');
383: LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',l_errbuf);
384: MESSAGE(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception');
385:
386: App_Exception.Raise_Exception;
387:
388: END GET_REPORT_INFO;

Line 422: LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',error_message);

418: EXCEPTION
419: when others then
420: error_code := TRUE;
421: error_message := 'Error in FV_UTILTIY.GET_ORG_INFO -'||sqlerrm;
422: LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',error_message);
423:
424: END get_org_info;
425:
426: Procedure gl_get_first_period(tset_of_books_id IN NUMBER,

Line 464: LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.final_exception',errbuf);

460:
461: errbuf := gl_message.get_message('GL_PLL_INVALID_FIRST_PERIOD', 'Y',
462: 'PERIOD', tperiod_name,
463: 'SOBID', tset_of_books_id);
464: LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.final_exception',errbuf);
465:
466: WHEN OTHERS THEN
467:
468: errbuf := SQLERRM;

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

465:
466: WHEN OTHERS THEN
467:
468: errbuf := SQLERRM;
469: LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',errbuf);
470:
471: END;
472:
473: -------------------------------------------------------------------------------

Line 523: LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.final_exception1',l_errbuf);

519: WHEN invalid_acct_segment_error THEN
520: l_errbuf := SQLERRM;
521: error_code := TRUE;
522: error_message := 'Error in FV_UTILTIY.GET_SEGMENT_COL_NAMES - '||l_errbuf;
523: LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.final_exception1',l_errbuf);
524: LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.final_exception1','Error in FV_CONTEXT_PKG.GET_SEGMENT_COL_NAMES: Cannot read Account Segment Information');
525: RAISE_APPLICATION_ERROR(-20002,'Error in FV_CONTEXT_PKG.GET_SEGMENT_COL_NAMES: Cannot read Account Segment Information');
526:
527: WHEN invalid_bal_segment_error THEN

Line 524: LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.final_exception1','Error in FV_CONTEXT_PKG.GET_SEGMENT_COL_NAMES: Cannot read Account Segment Information');

520: l_errbuf := SQLERRM;
521: error_code := TRUE;
522: error_message := 'Error in FV_UTILTIY.GET_SEGMENT_COL_NAMES - '||l_errbuf;
523: LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.final_exception1',l_errbuf);
524: LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.final_exception1','Error in FV_CONTEXT_PKG.GET_SEGMENT_COL_NAMES: Cannot read Account Segment Information');
525: RAISE_APPLICATION_ERROR(-20002,'Error in FV_CONTEXT_PKG.GET_SEGMENT_COL_NAMES: Cannot read Account Segment Information');
526:
527: WHEN invalid_bal_segment_error THEN
528: l_errbuf := SQLERRM;

Line 531: LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.final_exception1',l_errbuf);

527: WHEN invalid_bal_segment_error THEN
528: l_errbuf := SQLERRM;
529: error_code := TRUE;
530: error_message := 'Error in FV_UTILTIY.GET_SEGMENT_COL_NAMES - '||l_errbuf;
531: LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.final_exception1',l_errbuf);
532: LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.final_exception1','Error in FV_CONTEXT_PKG.GET_SEGMENT_COL_NAMES: Cannot read Balancing Segment Information');
533: RAISE_APPLICATION_ERROR(-20002,'Error in FV_CONTEXT_PKG.GET_SEGMENT_COL_NAMES: Cannot read Account Segment Information');
534:
535: WHEN others THEN

Line 532: LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.final_exception1','Error in FV_CONTEXT_PKG.GET_SEGMENT_COL_NAMES: Cannot read Balancing Segment Information');

528: l_errbuf := SQLERRM;
529: error_code := TRUE;
530: error_message := 'Error in FV_UTILTIY.GET_SEGMENT_COL_NAMES - '||l_errbuf;
531: LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.final_exception1',l_errbuf);
532: LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.final_exception1','Error in FV_CONTEXT_PKG.GET_SEGMENT_COL_NAMES: Cannot read Balancing Segment Information');
533: RAISE_APPLICATION_ERROR(-20002,'Error in FV_CONTEXT_PKG.GET_SEGMENT_COL_NAMES: Cannot read Account Segment Information');
534:
535: WHEN others THEN
536: l_errbuf := SQLERRM;

Line 539: LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception2',l_errbuf);

535: WHEN others THEN
536: l_errbuf := SQLERRM;
537: error_code := TRUE;
538: error_message := 'Error in FV_UTILTIY.GET_SEGMENT_COL_NAMES - '||l_errbuf;
539: LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception2',l_errbuf);
540: RAISE_APPLICATION_ERROR(-20003,'Error in FV_CONTEXT_PKG.GET_SEGMENT_COL_NAMES: '||l_errbuf);
541:
542: END get_segment_col_names;
543:

Line 585: LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.exception',l_errbuf);

581: END LOOP;
582: EXCEPTION
583: WHEN OTHERS THEN
584: l_errbuf := SQLERRM;
585: LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.exception',l_errbuf);
586: END calc_child_flex_value;
587:
588: FUNCTION calc_concat_accts(p_flex_value IN VARCHAR2,
589: p_coa_id IN NUMBER)

Line 637: LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.exception',l_errbuf);

633:
634: EXCEPTION
635: WHEN OTHERS THEN
636: l_errbuf := SQLERRM;
637: LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.exception',l_errbuf);
638: RETURN NULL;
639: END calc_concat_accts;
640: ----------------------------------------------------------------------------
641:

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 671: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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);
673: END IF;
674:
675: BEGIN

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 696: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

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));
698: END IF;
699:
700: BEGIN /* From Period Start Date */

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 723: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

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));
725: END IF;
726:
727: BEGIN /* To Period End 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 750: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

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));
752: END IF;
753:
754: -- Setting up the retcode

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 804: log_mesg(fnd_log.level_unexpected, l_module_name||'.final_exception',l_errbuf);

800: RETURN l_tin;
801: EXCEPTION
802: WHEN OTHERS THEN
803: l_errbuf := SQLERRM;
804: log_mesg(fnd_log.level_unexpected, l_module_name||'.final_exception',l_errbuf);
805: RAISE;
806: END;
807:
808: ---------------------------------------------------------------

Line 813: g_current_level := fnd_log.g_current_runtime_level;

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