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_CFS_PKG dependencies on FND_LOG

Line 137: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Sob ID: '||p_set_of_books_id);

133: l_facts_edit_cnt NUMBER;
134:
135: BEGIN
136:
137: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Sob ID: '||p_set_of_books_id);
138: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Period: '||p_period_name);
139: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Units: '||p_units);
140: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Report type: '||p_report_type);
141: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Table Ind: '||p_table_indicator);

Line 138: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Period: '||p_period_name);

134:
135: BEGIN
136:
137: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Sob ID: '||p_set_of_books_id);
138: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Period: '||p_period_name);
139: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Units: '||p_units);
140: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Report type: '||p_report_type);
141: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Table Ind: '||p_table_indicator);
142:

Line 139: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Units: '||p_units);

135: BEGIN
136:
137: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Sob ID: '||p_set_of_books_id);
138: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Period: '||p_period_name);
139: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Units: '||p_units);
140: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Report type: '||p_report_type);
141: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Table Ind: '||p_table_indicator);
142:
143: v_sob := p_set_of_books_id;

Line 140: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Report type: '||p_report_type);

136:
137: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Sob ID: '||p_set_of_books_id);
138: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Period: '||p_period_name);
139: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Units: '||p_units);
140: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Report type: '||p_report_type);
141: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Table Ind: '||p_table_indicator);
142:
143: v_sob := p_set_of_books_id;
144: v_period_name := p_period_name;

Line 141: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Table Ind: '||p_table_indicator);

137: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Sob ID: '||p_set_of_books_id);
138: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Period: '||p_period_name);
139: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Units: '||p_units);
140: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Report type: '||p_report_type);
141: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Table Ind: '||p_table_indicator);
142:
143: v_sob := p_set_of_books_id;
144: v_period_name := p_period_name;
145: v_report_type := p_report_type;

Line 196: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.error1',errbuf);

192:
193: IF l_request_id = 0 THEN
194: errbuf := 'Error submitting Consolidated Financial Statements Report';
195: retcode := -1;
196: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.error1',errbuf);
197: return;
198: ELSE
199: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
200: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,

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

195: retcode := -1;
196: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.error1',errbuf);
197: return;
198: ELSE
199: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
200: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
201: 'CONCURRENT REQUEST ID FOR CONSOLIDATED FINANCIAL STATEMENTS REPORT - '
202: || l_request_id);
203: END IF;

Line 200: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,

196: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.error1',errbuf);
197: return;
198: ELSE
199: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
200: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
201: 'CONCURRENT REQUEST ID FOR CONSOLIDATED FINANCIAL STATEMENTS REPORT - '
202: || l_request_id);
203: END IF;
204: END IF;

Line 220: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',v_errbuf);

216: EXCEPTION
217: WHEN OTHERS THEN
218: retcode := SQLCODE ;
219: errbuf := SQLERRM || ' [MAIN] ' ;
220: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',v_errbuf);
221: ROLLBACK;
222: COMMIT ;
223: END main;
224: -- =============================================================

Line 308: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.invalid_segment',v_errbuf);

304: EXCEPTION
305: WHEN invalid_segment THEN
306: v_retcode := -1;
307: v_errbuf := 'Error getting Balancing and Accounting segments.';
308: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.invalid_segment',v_errbuf);
309: ROLLBACK;
310: RETURN;
311: WHEN OTHERS THEN
312: v_retcode := sqlcode;

Line 314: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',v_errbuf);

310: RETURN;
311: WHEN OTHERS THEN
312: v_retcode := sqlcode;
313: v_errbuf := sqlerrm ;
314: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',v_errbuf);
315: RETURN;
316: END get_qualifier_segments ;
317: -- =============================================================
318: PROCEDURE populate_ccid IS

Line 375: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Ccid process starts');

371: l_cnt number;
372:
373: BEGIN
374:
375: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Ccid process starts');
376:
377: For crec_rec in crec
378:
379: loop

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

495: end if;
496:
497:
498: End loop; /* flex_crec */
499: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
500: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'Popualte CCID Completed');
501: END IF;
502: exception
503: when others then

Line 500: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'Popualte CCID Completed');

496:
497:
498: End loop; /* flex_crec */
499: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
500: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'Popualte CCID Completed');
501: END IF;
502: exception
503: when others then
504: v_retcode := -1;

Line 506: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',v_errbuf);

502: exception
503: when others then
504: v_retcode := -1;
505: v_errbuf := '[POPULATE-CCID]' || sqlerrm;
506: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',v_errbuf);
507: return;
508: End populate_ccid;
509: -- =============================================================
510: PROCEDURE build_dynamic_query IS

Line 680: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',v_errbuf);

676: EXCEPTION
677: WHEN OTHERS THEN
678: v_retcode := SQLCODE ;
679: v_errbuf := SQLERRM || ' [BUILD_DYNAMIC_QUERY] ' ;
680: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',v_errbuf);
681: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception','Stage it errors ' || l_stage);
682: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',l_out);
683: RETURN;
684: END build_dynamic_query;

Line 681: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception','Stage it errors ' || l_stage);

677: WHEN OTHERS THEN
678: v_retcode := SQLCODE ;
679: v_errbuf := SQLERRM || ' [BUILD_DYNAMIC_QUERY] ' ;
680: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',v_errbuf);
681: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception','Stage it errors ' || l_stage);
682: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',l_out);
683: RETURN;
684: END build_dynamic_query;
685: -- =============================================================

Line 682: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',l_out);

678: v_retcode := SQLCODE ;
679: v_errbuf := SQLERRM || ' [BUILD_DYNAMIC_QUERY] ' ;
680: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',v_errbuf);
681: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception','Stage it errors ' || l_stage);
682: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',l_out);
683: RETURN;
684: END build_dynamic_query;
685: -- =============================================================
686: PROCEDURE process_report_line

Line 741: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.error1',v_errbuf);

737: WHERE line_id = v_line_id;
738: IF l_line_cnt = 0 THEN
739: v_retcode := -1;
740: v_errbuf := 'SEED Data not properly Loaded. Please Verify and reinvoke the Process.';
741: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.error1',v_errbuf);
742: RETURN;
743: END IF;
744: -- $$$dbms_sql.bind_variable(v_cursor_id1,':cv_line_id',v_line_id);
745: process_total_line;

Line 761: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',v_errbuf);

757: EXCEPTION
758: WHEN OTHERS THEN
759: v_retcode := SQLCODE ;
760: v_errbuf := SQLERRM || ' [PROCESS_REPORT_LINE] ' ;
761: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',v_errbuf);
762: RETURN;
763: END process_report_line;
764: -- =============================================================
765: PROCEDURE get_one_time_values

Line 838: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Chart of accounts id: '||v_chart_of_accounts_id);

834: AND period_year = v_period_fiscal_year-1
835: AND application_id = '101'
836: AND period_num = v_period_num;
837:
838: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Chart of accounts id: '||v_chart_of_accounts_id);
839: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Fiscal year: '||v_period_fiscal_year);
840: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_period_num: '||v_period_num);
841: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_end_date: '||v_end_date);
842: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_begin_period: '||v_begin_period);

Line 839: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Fiscal year: '||v_period_fiscal_year);

835: AND application_id = '101'
836: AND period_num = v_period_num;
837:
838: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Chart of accounts id: '||v_chart_of_accounts_id);
839: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Fiscal year: '||v_period_fiscal_year);
840: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_period_num: '||v_period_num);
841: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_end_date: '||v_end_date);
842: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_begin_period: '||v_begin_period);
843: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_begin_period_end_date: '||v_begin_period_end_date);

Line 840: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_period_num: '||v_period_num);

836: AND period_num = v_period_num;
837:
838: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Chart of accounts id: '||v_chart_of_accounts_id);
839: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Fiscal year: '||v_period_fiscal_year);
840: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_period_num: '||v_period_num);
841: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_end_date: '||v_end_date);
842: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_begin_period: '||v_begin_period);
843: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_begin_period_end_date: '||v_begin_period_end_date);
844: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_begin_period_1: '||v_begin_period_1);

Line 841: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_end_date: '||v_end_date);

837:
838: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Chart of accounts id: '||v_chart_of_accounts_id);
839: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Fiscal year: '||v_period_fiscal_year);
840: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_period_num: '||v_period_num);
841: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_end_date: '||v_end_date);
842: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_begin_period: '||v_begin_period);
843: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_begin_period_end_date: '||v_begin_period_end_date);
844: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_begin_period_1: '||v_begin_period_1);
845: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_begin_period_1_end_date: '||v_begin_period_1_end_date);

Line 842: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_begin_period: '||v_begin_period);

838: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Chart of accounts id: '||v_chart_of_accounts_id);
839: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Fiscal year: '||v_period_fiscal_year);
840: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_period_num: '||v_period_num);
841: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_end_date: '||v_end_date);
842: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_begin_period: '||v_begin_period);
843: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_begin_period_end_date: '||v_begin_period_end_date);
844: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_begin_period_1: '||v_begin_period_1);
845: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_begin_period_1_end_date: '||v_begin_period_1_end_date);
846: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_end_period_1_end_date: '||v_end_period_1_end_date);

Line 843: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_begin_period_end_date: '||v_begin_period_end_date);

839: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Fiscal year: '||v_period_fiscal_year);
840: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_period_num: '||v_period_num);
841: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_end_date: '||v_end_date);
842: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_begin_period: '||v_begin_period);
843: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_begin_period_end_date: '||v_begin_period_end_date);
844: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_begin_period_1: '||v_begin_period_1);
845: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_begin_period_1_end_date: '||v_begin_period_1_end_date);
846: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_end_period_1_end_date: '||v_end_period_1_end_date);
847:

Line 844: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_begin_period_1: '||v_begin_period_1);

840: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_period_num: '||v_period_num);
841: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_end_date: '||v_end_date);
842: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_begin_period: '||v_begin_period);
843: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_begin_period_end_date: '||v_begin_period_end_date);
844: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_begin_period_1: '||v_begin_period_1);
845: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_begin_period_1_end_date: '||v_begin_period_1_end_date);
846: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_end_period_1_end_date: '||v_end_period_1_end_date);
847:
848: EXCEPTION

Line 845: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_begin_period_1_end_date: '||v_begin_period_1_end_date);

841: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_end_date: '||v_end_date);
842: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_begin_period: '||v_begin_period);
843: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_begin_period_end_date: '||v_begin_period_end_date);
844: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_begin_period_1: '||v_begin_period_1);
845: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_begin_period_1_end_date: '||v_begin_period_1_end_date);
846: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_end_period_1_end_date: '||v_end_period_1_end_date);
847:
848: EXCEPTION
849: WHEN NO_DATA_FOUND THEN

Line 846: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_end_period_1_end_date: '||v_end_period_1_end_date);

842: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_begin_period: '||v_begin_period);
843: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_begin_period_end_date: '||v_begin_period_end_date);
844: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_begin_period_1: '||v_begin_period_1);
845: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_begin_period_1_end_date: '||v_begin_period_1_end_date);
846: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_end_period_1_end_date: '||v_end_period_1_end_date);
847:
848: EXCEPTION
849: WHEN NO_DATA_FOUND THEN
850: IF l_stage = 4 OR l_stage = 5 THEN

Line 964: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,l_log_mesg);

960: AND id_flex_code = 'GL#'
961: AND id_flex_num = v_chart_of_accounts_id;
962:
963: l_log_mesg := '***** Line Number' || v_line_number || ': ' || '*****';
964: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,l_log_mesg);
965:
966: FOR detail_rec IN fv_cfs_detail_cur
967: LOOP ---- L1
968: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, '########');

Line 968: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, '########');

964: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,l_log_mesg);
965:
966: FOR detail_rec IN fv_cfs_detail_cur
967: LOOP ---- L1
968: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, '########');
969: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Account Num: '||detail_rec.account_number);
970: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'line id: '||v_line_id);
971: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'line detail id: '||detail_rec.line_detail_id);
972: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'balance type: '||detail_rec.balance_type);

Line 969: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Account Num: '||detail_rec.account_number);

965:
966: FOR detail_rec IN fv_cfs_detail_cur
967: LOOP ---- L1
968: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, '########');
969: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Account Num: '||detail_rec.account_number);
970: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'line id: '||v_line_id);
971: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'line detail id: '||detail_rec.line_detail_id);
972: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'balance type: '||detail_rec.balance_type);
973: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Fed Non Fed: '||detail_rec.fed_non_fed);

Line 970: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'line id: '||v_line_id);

966: FOR detail_rec IN fv_cfs_detail_cur
967: LOOP ---- L1
968: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, '########');
969: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Account Num: '||detail_rec.account_number);
970: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'line id: '||v_line_id);
971: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'line detail id: '||detail_rec.line_detail_id);
972: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'balance type: '||detail_rec.balance_type);
973: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Fed Non Fed: '||detail_rec.fed_non_fed);
974: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'By Recipient: '||v_by_recipient);

Line 971: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'line detail id: '||detail_rec.line_detail_id);

967: LOOP ---- L1
968: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, '########');
969: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Account Num: '||detail_rec.account_number);
970: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'line id: '||v_line_id);
971: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'line detail id: '||detail_rec.line_detail_id);
972: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'balance type: '||detail_rec.balance_type);
973: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Fed Non Fed: '||detail_rec.fed_non_fed);
974: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'By Recipient: '||v_by_recipient);
975:

Line 972: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'balance type: '||detail_rec.balance_type);

968: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, '########');
969: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Account Num: '||detail_rec.account_number);
970: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'line id: '||v_line_id);
971: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'line detail id: '||detail_rec.line_detail_id);
972: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'balance type: '||detail_rec.balance_type);
973: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Fed Non Fed: '||detail_rec.fed_non_fed);
974: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'By Recipient: '||v_by_recipient);
975:
976: v_balance_type := detail_rec.balance_type;

Line 973: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Fed Non Fed: '||detail_rec.fed_non_fed);

969: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Account Num: '||detail_rec.account_number);
970: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'line id: '||v_line_id);
971: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'line detail id: '||detail_rec.line_detail_id);
972: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'balance type: '||detail_rec.balance_type);
973: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Fed Non Fed: '||detail_rec.fed_non_fed);
974: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'By Recipient: '||v_by_recipient);
975:
976: v_balance_type := detail_rec.balance_type;
977:

Line 974: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'By Recipient: '||v_by_recipient);

970: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'line id: '||v_line_id);
971: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'line detail id: '||detail_rec.line_detail_id);
972: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'balance type: '||detail_rec.balance_type);
973: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Fed Non Fed: '||detail_rec.fed_non_fed);
974: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'By Recipient: '||v_by_recipient);
975:
976: v_balance_type := detail_rec.balance_type;
977:
978: l_balance_determined := 0;

Line 1015: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Recipient name: '||v_recipient_name);

1011: dbms_sql.column_value(v_fct1_rcpt_sel_curid, 1, v_amount);
1012: dbms_sql.column_value(v_fct1_rcpt_sel_curid, 2, v_recipient_name);
1013: v_col_1_amt := nvl(v_amount, 0);
1014:
1015: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Recipient name: '||v_recipient_name);
1016: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Recipient amount: '||v_amount);
1017:
1018: dbms_sql.bind_variable(v_fct1_rcpt_sel2_curid,':cv_recipient_name',v_recipient_name);
1019: l_ignore := dbms_sql.execute_and_fetch(v_fct1_rcpt_sel2_curid);

Line 1016: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Recipient amount: '||v_amount);

1012: dbms_sql.column_value(v_fct1_rcpt_sel_curid, 2, v_recipient_name);
1013: v_col_1_amt := nvl(v_amount, 0);
1014:
1015: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Recipient name: '||v_recipient_name);
1016: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Recipient amount: '||v_amount);
1017:
1018: dbms_sql.bind_variable(v_fct1_rcpt_sel2_curid,':cv_recipient_name',v_recipient_name);
1019: l_ignore := dbms_sql.execute_and_fetch(v_fct1_rcpt_sel2_curid);
1020: dbms_sql.column_value(v_fct1_rcpt_sel2_curid, 1, v_amount);

Line 1022: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Recipient group by amount: '||v_amount);

1018: dbms_sql.bind_variable(v_fct1_rcpt_sel2_curid,':cv_recipient_name',v_recipient_name);
1019: l_ignore := dbms_sql.execute_and_fetch(v_fct1_rcpt_sel2_curid);
1020: dbms_sql.column_value(v_fct1_rcpt_sel2_curid, 1, v_amount);
1021: v_col_2_amt := nvl(v_amount, 0);
1022: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Recipient group by amount: '||v_amount);
1023:
1024: l_found := FALSE;
1025: FOR i IN 1..l_recipient_cnt - 1
1026: LOOP

Line 1070: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Account Type: '||l_account_type);

1066: NULL;
1067: END;
1068: END;
1069: END IF;
1070: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Account Type: '||l_account_type);
1071: -- ===================================================================
1072: v_py_gl_beg_bal := 0;
1073: v_py_gl_end_bal := 0;
1074: v_cy_gl_beg_bal := 0;

Line 1089: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Prior year begin gl bal: '||v_py_gl_beg_bal);

1085:
1086: dbms_sql.bind_variable(v_glbal_curid,':cv_end_date', v_begin_period_1_end_date);
1087: l_ignore := dbms_sql.execute_and_fetch(v_glbal_curid);
1088: dbms_sql.column_value(v_glbal_curid, 1, v_py_gl_beg_bal);
1089: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Prior year begin gl bal: '||v_py_gl_beg_bal);
1090:
1091: -- Get current year beginning balance
1092: dbms_sql.bind_variable(v_glbal_curid,':cv_period_fiscal_year',v_period_fiscal_year);
1093:

Line 1098: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Current year begin gl bal: '||v_cy_gl_beg_bal);

1094: dbms_sql.bind_variable(v_glbal_curid,':cv_end_date', v_begin_period_end_date);
1095: dbms_sql.bind_variable(v_glbal_curid,':cv_balance_type','B');
1096: l_ignore := dbms_sql.execute_and_fetch(v_glbal_curid);
1097: dbms_sql.column_value(v_glbal_curid, 1, v_cy_gl_beg_bal);
1098: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Current year begin gl bal: '||v_cy_gl_beg_bal);
1099:
1100: -- ===================================================================
1101:
1102: IF v_report_type <> 'SBR'

Line 1122: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, l_log_mesg);

1118: has a blank Natural Balance in the Report Definitions form.
1119: Please select Natural Balance for any line with a Balance Type
1120: of Net Increase or Net Decrease.';
1121: fnd_file.put_line(fnd_file.log, l_log_mesg);
1122: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, l_log_mesg);
1123: v_retcode := -1 ;
1124: v_errbuf := l_log_mesg;
1125: ROLLBACK;
1126: RETURN;

Line 1133: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Prior year begin bal: '||v_py_gl_beg_bal);

1129: --======= PRIOR YEAR CALCULATION ===========
1130: -- Get facts1 beginning balance for prior year
1131: IF detail_rec.balance_type IN ('B','G','I','J') THEN
1132:
1133: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Prior year begin bal: '||v_py_gl_beg_bal);
1134:
1135: IF detail_rec.balance_type = 'B' THEN
1136: v_amount:= v_py_gl_beg_bal;
1137: END IF;

Line 1149: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Prior year end facts1 bal: '||v_py_fct1_endbal);

1145: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_balance_type','');
1146: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_period_num',v_end_period);
1147: l_ignore := dbms_sql.execute_and_fetch(v_fct1_sel_curid);
1148: dbms_sql.column_value(v_fct1_sel_curid, 1, v_py_fct1_endbal);
1149: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Prior year end facts1 bal: '||v_py_fct1_endbal);
1150:
1151: v_amount := get_bal_type_amt(detail_rec.balance_type,
1152: v_natural_balance_type,
1153: NVL(v_py_gl_beg_bal,0),

Line 1170: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Current year begin bal: '||v_cy_gl_beg_bal);

1166: --======= CURRENT YEAR CALCULATION ===========
1167: -- Get facts1 beginning balance for current year
1168: v_amount := 0;
1169: IF detail_rec.balance_type IN ('B','G','I','J') THEN
1170: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Current year begin bal: '||v_cy_gl_beg_bal);
1171: IF detail_rec.balance_type = 'B' THEN
1172: v_amount := v_cy_gl_beg_bal;
1173: END IF;
1174: END IF;

Line 1185: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Current year end facsts1 bal: '||v_cy_fct1_endbal);

1181: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_balance_type','');
1182: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_period_num',v_end_period);
1183: l_ignore := dbms_sql.execute_and_fetch(v_fct1_sel_curid);
1184: dbms_sql.column_value(v_fct1_sel_curid, 1, v_cy_fct1_endbal);
1185: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Current year end facsts1 bal: '||v_cy_fct1_endbal);
1186:
1187: v_amount := get_bal_type_amt(detail_rec.balance_type,
1188: v_natural_balance_type,
1189: NVL(v_cy_gl_beg_bal,0),

Line 1231: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Current year begin bal: '||v_cy_sbr_beg_bal);

1227: dbms_sql.bind_variable(v_sbr_curid,':cv_period_fiscal_year',v_period_fiscal_year);
1228: l_ignore := dbms_sql.execute_and_fetch(v_sbr_curid);
1229: dbms_sql.column_value(v_sbr_curid, 1, v_cy_sbr_beg_bal);
1230: v_amount := v_cy_sbr_beg_bal;
1231: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Current year begin bal: '||v_cy_sbr_beg_bal);
1232: ELSIF detail_rec.balance_type IN ('C','D','E','G','I','J') THEN
1233: -- IF balance type is ending, ending cr only or ending dr only
1234: -- Get the begin balance
1235: dbms_sql.bind_variable(v_sbr_curid,':cv_balance_type','B');

Line 1248: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Current year end bal: '||v_cy_sbr_end_bal);

1244: dbms_sql.bind_variable(v_sbr_curid,':cv_end_date', v_end_period_end_date);
1245: dbms_sql.bind_variable(v_sbr_curid,':cv_period_fiscal_year',v_period_fiscal_year);
1246: l_ignore := dbms_sql.execute_and_fetch(v_sbr_curid);
1247: dbms_sql.column_value(v_sbr_curid, 1, v_cy_sbr_end_bal);
1248: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Current year end bal: '||v_cy_sbr_end_bal);
1249:
1250: v_amount := get_bal_type_amt(detail_rec.balance_type,
1251: v_natural_balance_type,
1252: NVL(v_cy_sbr_beg_bal,0),

Line 1276: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Prior year begin bal: '||v_py_sbr_beg_bal);

1272: dbms_sql.bind_variable(v_sbr_curid,':cv_period_fiscal_year',v_period_fiscal_year-1);
1273: l_ignore := dbms_sql.execute_and_fetch(v_sbr_curid);
1274: dbms_sql.column_value(v_sbr_curid, 1, v_py_sbr_beg_bal);
1275: v_amount := v_py_sbr_beg_bal;
1276: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Prior year begin bal: '||v_py_sbr_beg_bal);
1277: -- IF balance type is ending, ending cr only or ending dr only
1278: ELSIF detail_rec.balance_type IN ('C', 'D','E','G','I','J') THEN
1279: -- Get the begin balance
1280: dbms_sql.bind_variable(v_sbr_curid,':cv_balance_type','B');

Line 1293: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Prior year end bal: '||v_py_sbr_end_bal);

1289: dbms_sql.bind_variable(v_sbr_curid,':cv_end_date', v_end_period_1_end_date);
1290: dbms_sql.bind_variable(v_sbr_curid,':cv_period_fiscal_year',v_period_fiscal_year-1);
1291: l_ignore := dbms_sql.execute_and_fetch(v_sbr_curid);
1292: dbms_sql.column_value(v_sbr_curid, 1, v_py_sbr_end_bal);
1293: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Prior year end bal: '||v_py_sbr_end_bal);
1294: v_amount := get_bal_type_amt(detail_rec.balance_type,
1295: v_natural_balance_type,
1296: NVL(v_py_sbr_beg_bal,0),
1297: NVL(v_py_sbr_end_bal,0));

Line 1333: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

1329: ELSE
1330: SELECT REPLACE(l_log_mesg, '*****', v_col_1_amt || ', ' || v_col_2_amt || ', '
1331: || v_col_3_amt || ', ' || v_col_4_amt)
1332: INTO l_log_mesg FROM dual;
1333: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1334: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,L_LOG_MESG);
1335: END IF;
1336: populate_temp_table;
1337: END IF;

Line 1334: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,L_LOG_MESG);

1330: SELECT REPLACE(l_log_mesg, '*****', v_col_1_amt || ', ' || v_col_2_amt || ', '
1331: || v_col_3_amt || ', ' || v_col_4_amt)
1332: INTO l_log_mesg FROM dual;
1333: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1334: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,L_LOG_MESG);
1335: END IF;
1336: populate_temp_table;
1337: END IF;
1338:

Line 1343: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',v_errbuf);

1339: EXCEPTION
1340: WHEN OTHERS THEN
1341: v_retcode := SQLCODE ;
1342: v_errbuf := SQLERRM || ' [PROCESS_DETAIL_LINE] ' ;
1343: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',v_errbuf);
1344: RETURN;
1345:
1346: END process_detail_line;
1347: -- =============================================================

Line 1518: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',v_errbuf);

1514: EXCEPTION
1515: WHEN OTHERS THEN
1516: v_retcode := SQLCODE ;
1517: v_errbuf := SQLERRM || ' [PROCESS_TOTAL_LINE] ' ;
1518: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',v_errbuf);
1519: RETURN;
1520: END process_total_line;
1521: -- =============================================================
1522: PROCEDURE populate_temp_table

Line 1577: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',v_errbuf);

1573: EXCEPTION
1574: WHEN OTHERS THEN
1575: v_retcode := -1;
1576: v_errbuf := SQLERRM;
1577: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',v_errbuf);
1578: RAISE;
1579:
1580: END populate_temp_table;
1581: -- =============================================================

Line 1590: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'IN get_bal_type_amt function');

1586: IS
1587: l_module_name VARCHAR2(200) := g_module_name || 'populate_temp_table';
1588: l_end_minus_beg_amt NUMBER;
1589: BEGIN
1590: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'IN get_bal_type_amt function');
1591: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Natural balance: '||p_natural_bal_type);
1592: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_beg_bal: '||p_beg_bal);
1593: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_end_bal: '||p_end_bal);
1594:

Line 1591: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Natural balance: '||p_natural_bal_type);

1587: l_module_name VARCHAR2(200) := g_module_name || 'populate_temp_table';
1588: l_end_minus_beg_amt NUMBER;
1589: BEGIN
1590: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'IN get_bal_type_amt function');
1591: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Natural balance: '||p_natural_bal_type);
1592: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_beg_bal: '||p_beg_bal);
1593: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_end_bal: '||p_end_bal);
1594:
1595:

Line 1592: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_beg_bal: '||p_beg_bal);

1588: l_end_minus_beg_amt NUMBER;
1589: BEGIN
1590: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'IN get_bal_type_amt function');
1591: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Natural balance: '||p_natural_bal_type);
1592: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_beg_bal: '||p_beg_bal);
1593: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_end_bal: '||p_end_bal);
1594:
1595:
1596: IF p_balance_type = 'E' THEN

Line 1593: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_end_bal: '||p_end_bal);

1589: BEGIN
1590: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'IN get_bal_type_amt function');
1591: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Natural balance: '||p_natural_bal_type);
1592: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_beg_bal: '||p_beg_bal);
1593: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_end_bal: '||p_end_bal);
1594:
1595:
1596: IF p_balance_type = 'E' THEN
1597: RETURN p_end_bal;

Line 1619: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'end minus begin: '||l_end_minus_beg_amt);

1615: -- If balance type is End minus Begin, Net Increase or
1616: -- Net Decrease then report amount depending on the
1617: -- natural balance type
1618: l_end_minus_beg_amt := p_end_bal - p_beg_bal;
1619: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'end minus begin: '||l_end_minus_beg_amt);
1620: IF p_balance_type = 'G' THEN
1621: RETURN l_end_minus_beg_amt;
1622: END IF;
1623: IF p_balance_type = 'I' THEN

Line 1659: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',v_errbuf);

1655: EXCEPTION
1656: WHEN OTHERS THEN
1657: v_retcode := -1;
1658: v_errbuf := SQLERRM;
1659: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',v_errbuf);
1660: END get_bal_type_amt;
1661: -- =============================================================
1662: BEGIN
1663: