APPS.FV_REIMB_ACTIVITY_PROCESS dependencies on FND_LOG

Line 9: C_STATE_LEVEL CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

5: g_period_num NUMBER;
6: g_period_year NUMBER;
7: g_ledger_id NUMBER;
8: g_coa_id NUMBER;
9: C_STATE_LEVEL CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
10: g_log_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
11: g_module_name VARCHAR2(50) := 'fv.plsql.fv_reimb_activity_process.';
12: g_errbuf VARCHAR2(500);
13: g_retcode NUMBER := 0;

Line 10: g_log_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

6: g_period_year NUMBER;
7: g_ledger_id NUMBER;
8: g_coa_id NUMBER;
9: C_STATE_LEVEL CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
10: g_log_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
11: g_module_name VARCHAR2(50) := 'fv.plsql.fv_reimb_activity_process.';
12: g_errbuf VARCHAR2(500);
13: g_retcode NUMBER := 0;
14: g_currency VARCHAR2(3);

Line 147: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module,g_errbuf) ;

143:
144: IF l_seed_count=0 THEN
145: g_retcode := -1 ;
146: g_errbuf := ' Please run the Populate Reimbursable Activity Report Definitions Process .' ;
147: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module,g_errbuf) ;
148: RETURN ;
149: END IF;
150: -- Check whether Accounts are Defined in the form ,
151: -- Reimbursable Activity Report Definitions .

Line 163: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module,g_errbuf) ;

159: IF l_Acct_count=0 THEN
160: g_retcode := -1 ;
161: g_errbuf := ' Accounts not defined . Please define Accounts in the Reimbursable Activity Report
162: Definitions Form. ' ;
163: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module,g_errbuf) ;
164: RETURN ;
165: END IF;
166:
167: ----End of set up check

Line 443: FND_LOG.STRING(p_level,

439: IS
440:
441: BEGIN
442: IF (p_level >= g_log_level ) THEN
443: FND_LOG.STRING(p_level,
444: p_procedure_name,
445: p_debug_info);
446: END IF;
447: END log;

Line 532: fv_utility.log_mesg(fnd_log.level_error, l_module,g_errbuf) ;

528:
529: IF (g_delimiter IS NULL) THEN
530: g_retcode := 2 ;
531: g_errbuf := 'The Flexfield Structure is not found' ;
532: fv_utility.log_mesg(fnd_log.level_error, l_module,g_errbuf) ;
533: END IF;
534:
535: IF (g_retcode = 0) THEN
536: log(C_STATE_LEVEL, l_module, ' delimiter is ' ||g_delimiter);

Line 543: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module||'.final_exception',g_errbuf) ;

539: EXCEPTION
540: WHEN OTHERS THEN
541: g_retcode := SQLCODE;
542: g_errbuf := SQLERRM;
543: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module||'.final_exception',g_errbuf) ;
544: RAISE;
545: END get_segment_details;
546: -----------------------------------------------------------------
547:

Line 582: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module||'.final_exception',g_errbuf) ;

578: EXCEPTION
579: WHEN OTHERS THEN
580: g_retcode := SQLCODE;
581: g_errbuf := SQLERRM;
582: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module||'.final_exception',g_errbuf) ;
583: END Get_Application_Col_Names;
584: ---------------------------------------------------------------------
585: -- ------------------------------------------------------------------
586: -- Procedure Get_Segment_Values

Line 725: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module||'.final_exception',g_ERRBUF) ;

721: EXCEPTION
722: WHEN OTHERS THEN
723: g_retcode := SQLCODE;
724: g_ERRBUF := SQLERRM;
725: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module||'.final_exception',g_ERRBUF) ;
726: RAISE;
727: END Get_Segment_Values ;
728: ------------------------------------
729: -- Procedure to poulate the gt table for all the columns

Line 811: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module||'Incomplete Report Definition Setup',g_ERRBUF) ;

807: EXCEPTION
808: WHEN NO_DATA_FOUND then
809: g_retcode := SQLCODE;
810: g_ERRBUF := SQLERRM;
811: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module||'Incomplete Report Definition Setup',g_ERRBUF) ;
812: RAISE;
813: END;
814: -- Remove 'glcc.' from g_select
815: SELECT REPLACE(g_select, 'glcc.', '') INTO l_select_mod FROM dual;

Line 854: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module||'.dbms_sql_l_main_cursor',g_ERRBUF) ;

850: EXCEPTION
851: WHEN OTHERS THEN
852: g_retcode := SQLCODE;
853: g_ERRBUF := SQLERRM;
854: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module||'.dbms_sql_l_main_cursor',g_ERRBUF) ;
855: RAISE;
856: END ;
857:
858: BEGIN

Line 864: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module||'.dbms_sql_parse_l_main_cursor',g_ERRBUF) ;

860: EXCEPTION
861: WHEN OTHERS THEN
862: g_retcode := SQLCODE;
863: g_ERRBUF := SQLERRM;
864: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module||'.dbms_sql_parse_l_main_cursor',g_ERRBUF) ;
865: RAISE;
866: END ;
867:
868: --log(C_STATE_LEVEL, l_module, 'g_period_name: '|| g_period_name );

Line 1032: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module||'.dbms_sql_execute_l_main_cursor',g_ERRBUF) ;

1028: EXCEPTION
1029: WHEN OTHERS THEN
1030: g_retcode := SQLCODE;
1031: g_ERRBUF := SQLERRM;
1032: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module||'.dbms_sql_execute_l_main_cursor',g_ERRBUF) ;
1033: RAISE;
1034: END ;
1035:
1036: log(C_STATE_LEVEL, l_module, 'completed dbms_sql.execute' );