APPS.FV_TBAL_BY_TS dependencies on FND_LOG

Line 97: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

93: IF retcode <> 0
94: THEN RETURN;
95: END IF;
96:
97: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
98: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'v_group_by: '||v_group_by);
99: END IF;
100:
101: IF p_amount_type = 'PTD'

Line 98: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'v_group_by: '||v_group_by);

94: THEN RETURN;
95: END IF;
96:
97: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
98: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'v_group_by: '||v_group_by);
99: END IF;
100:
101: IF p_amount_type = 'PTD'
102: THEN

Line 182: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

178: OR glb.translated_flag IS NULL)
179: GROUP BY fts.treasury_symbol_id, glcc.'||v_acc_seg_name ||
180: v_group_by ;
181:
182: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
183: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'Select: '|| v_statement);
184: END IF;
185:
186: EXECUTE IMMEDIATE v_statement;

Line 183: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'Select: '|| v_statement);

179: GROUP BY fts.treasury_symbol_id, glcc.'||v_acc_seg_name ||
180: v_group_by ;
181:
182: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
183: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'Select: '|| v_statement);
184: END IF;
185:
186: EXECUTE IMMEDIATE v_statement;
187:

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

200:
201: IF v_req_id = 0 THEN
202: retcode := -2;
203: errbuf := 'Error submitting Trial Balance report' ;
204: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.exception1',errbuf);
205: END IF;
206:
207: EXCEPTION WHEN OTHERS THEN
208: retcode := sqlcode;

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

206:
207: EXCEPTION WHEN OTHERS THEN
208: retcode := sqlcode;
209: errbuf := SUBSTR(sqlerrm,1,250);
210: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',errbuf);
211: END main;
212: --------------------------------------------------------------------------------------
213: PROCEDURE purge_summary_txns IS
214: l_module_name VARCHAR2(200) := g_module_name || 'purge_summary_txns';

Line 217: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

213: PROCEDURE purge_summary_txns IS
214: l_module_name VARCHAR2(200) := g_module_name || 'purge_summary_txns';
215: BEGIN
216:
217: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
218: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'Purging facts temp table');
219: END IF;
220:
221: DELETE

Line 218: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'Purging facts temp table');

214: l_module_name VARCHAR2(200) := g_module_name || 'purge_summary_txns';
215: BEGIN
216:
217: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
218: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'Purging facts temp table');
219: END IF;
220:
221: DELETE
222: FROM fv_facts_temp

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

224: EXCEPTION
225: WHEN OTHERS THEN
226: retcode := -1;
227: errbuf := 'Error while grouping by: '||SUBSTR(sqlerrm,1,200);
228: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',errbuf);
229: RAISE;
230: END purge_summary_txns;
231: --------------------------------------------------------------------------------
232: -- This procedure selects the break columns, which the user has setup for the

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

267: END IF;
268: EXCEPTION WHEN OTHERS THEN
269: retcode := -1;
270: errbuf := 'Error while grouping by: '||SUBSTR(sqlerrm,1,200);
271: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',errbuf);
272:
273: END group_by_columns;
274: --------------------------------------------------------------------------------------
275: END fv_tbal_by_ts;