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 348: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Sob ID: '||p_set_of_books_id);

344: l_count_acct NUMBER;
345: l_sub_sbr NUMBER:=2;
346: l_one_edit_pass NUMBER:=0;
347: BEGIN
348: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Sob ID: '||p_set_of_books_id);
349: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Period: '||p_period_name);
350: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Units: '||p_units);
351: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Report type: '||p_report_type);
352: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Table Ind: '||p_table_indicator);

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

345: l_sub_sbr NUMBER:=2;
346: l_one_edit_pass NUMBER:=0;
347: BEGIN
348: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Sob ID: '||p_set_of_books_id);
349: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Period: '||p_period_name);
350: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Units: '||p_units);
351: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Report type: '||p_report_type);
352: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Table Ind: '||p_table_indicator);
353: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_facts_rep_show : '||p_facts_rep_show);

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

346: l_one_edit_pass NUMBER:=0;
347: BEGIN
348: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Sob ID: '||p_set_of_books_id);
349: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Period: '||p_period_name);
350: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Units: '||p_units);
351: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Report type: '||p_report_type);
352: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Table Ind: '||p_table_indicator);
353: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_facts_rep_show : '||p_facts_rep_show);
354:

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

347: BEGIN
348: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Sob ID: '||p_set_of_books_id);
349: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Period: '||p_period_name);
350: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Units: '||p_units);
351: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Report type: '||p_report_type);
352: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Table Ind: '||p_table_indicator);
353: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_facts_rep_show : '||p_facts_rep_show);
354:
355: v_sob := p_set_of_books_id;

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

348: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Sob ID: '||p_set_of_books_id);
349: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Period: '||p_period_name);
350: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Units: '||p_units);
351: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Report type: '||p_report_type);
352: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Table Ind: '||p_table_indicator);
353: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_facts_rep_show : '||p_facts_rep_show);
354:
355: v_sob := p_set_of_books_id;
356: v_period_name := p_period_name;

Line 353: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_facts_rep_show : '||p_facts_rep_show);

349: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Period: '||p_period_name);
350: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Units: '||p_units);
351: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Report type: '||p_report_type);
352: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Table Ind: '||p_table_indicator);
353: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'p_facts_rep_show : '||p_facts_rep_show);
354:
355: v_sob := p_set_of_books_id;
356: v_period_name := p_period_name;
357: v_report_type := p_report_type;

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

413:
414: if l_count=0 or l_count_acct=0 then
415: errbuf := 'No Setup data for Statement of Budgetary Resources';
416: retcode := 1;
417: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.error1',errbuf);
418: RETURN;
419: end if;
420:
421: -- Processing SBR report line definitions

Line 422: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'BEFORE ts_rec CURSOR->'||p_set_of_books_id);

418: RETURN;
419: end if;
420:
421: -- Processing SBR report line definitions
422: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'BEFORE ts_rec CURSOR->'||p_set_of_books_id);
423: purge_csf_temp_table;
424:
425: build_sbr_dynamic_query;
426:

Line 429: --fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'in cursor loop');

425: build_sbr_dynamic_query;
426:
427: FOR ts_rec IN ts_cursor(p_set_of_books_id)
428: LOOP
429: --fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'in cursor loop');
430: parm_treasury_value := ts_rec.treasury_symbol;
431: parm_tsymbol_id := ts_rec.treasury_symbol_id;
432: v_purge_ts_id := ts_rec.treasury_symbol_id;
433:

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

430: parm_treasury_value := ts_rec.treasury_symbol;
431: parm_tsymbol_id := ts_rec.treasury_symbol_id;
432: v_purge_ts_id := ts_rec.treasury_symbol_id;
433:
434: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
435: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'SUBMITTING FACTS II process FOR TS.....'||parm_treasury_value);
436: END IF;
437: SELECT period_num
438: INTO report_period_num

Line 435: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'SUBMITTING FACTS II process FOR TS.....'||parm_treasury_value);

431: parm_tsymbol_id := ts_rec.treasury_symbol_id;
432: v_purge_ts_id := ts_rec.treasury_symbol_id;
433:
434: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
435: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'SUBMITTING FACTS II process FOR TS.....'||parm_treasury_value);
436: END IF;
437: SELECT period_num
438: INTO report_period_num
439: FROM gl_period_statuses

Line 448: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'Purging old data before triggers facts process for Treasury Symbol-> '||parm_treasury_value);

444:
445: retcode_facts:=0;
446:
447: /*Purging old data from fv_facts_temp tables*/
448: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'Purging old data before triggers facts process for Treasury Symbol-> '||parm_treasury_value);
449: purge_facts_transactions;
450:
451:
452: FV_FACTS_TRANSACTIONS.main(errbuf_facts, retcode_facts, v_sob, parm_treasury_value,

Line 458: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'retcode_facts is '||retcode_facts|| ' FV_FACTS_TRANSACTIONS.v_g_edit_check_code' || FV_FACTS_TRANSACTIONS.v_g_edit_check_code);

454: contact_phone, contact_extn, contact_email, contact_fax, contact_maiden, supervisor_name,
455: supervisor_phone, supervisor_extn, agency_name_1, agency_name_2, address_1, address_2,
456: city, state, zip, v_currency_code,v_facts_rep_show);
457:
458: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'retcode_facts is '||retcode_facts|| ' FV_FACTS_TRANSACTIONS.v_g_edit_check_code' || FV_FACTS_TRANSACTIONS.v_g_edit_check_code);
459:
460: -- Commenting out the code which checks if required edit checks passed
461: /*Checking whether atleast one treasury symbol passed required edit checks successfully*/
462: /* l_sub_sbr:=FV_FACTS_TRANSACTIONS.v_g_edit_check_code;

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

466:
467: IF (retcode_facts <> 0 )THEN
468: IF (retcode_facts =1 )THEN
469:
470: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
471: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'Unable to process FACTS II in sbr for retcode_facts= 1 and TS ...'|| parm_treasury_value||errbuf_facts);
472: END IF;
473: -- Commenting out the code which checks if required edit checks passed
474: /* IF (FV_FACTS_TRANSACTIONS.v_g_edit_check_code = 2)THEN

Line 471: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'Unable to process FACTS II in sbr for retcode_facts= 1 and TS ...'|| parm_treasury_value||errbuf_facts);

467: IF (retcode_facts <> 0 )THEN
468: IF (retcode_facts =1 )THEN
469:
470: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
471: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'Unable to process FACTS II in sbr for retcode_facts= 1 and TS ...'|| parm_treasury_value||errbuf_facts);
472: END IF;
473: -- Commenting out the code which checks if required edit checks passed
474: /* IF (FV_FACTS_TRANSACTIONS.v_g_edit_check_code = 2)THEN
475: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'Purging old data as Required Edits failed for the Treasury Symbol...'|| parm_treasury_value||errbuf_facts);

Line 475: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'Purging old data as Required Edits failed for the Treasury Symbol...'|| parm_treasury_value||errbuf_facts);

471: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'Unable to process FACTS II in sbr for retcode_facts= 1 and TS ...'|| parm_treasury_value||errbuf_facts);
472: END IF;
473: -- Commenting out the code which checks if required edit checks passed
474: /* IF (FV_FACTS_TRANSACTIONS.v_g_edit_check_code = 2)THEN
475: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'Purging old data as Required Edits failed for the Treasury Symbol...'|| parm_treasury_value||errbuf_facts);
476: retcode :=1;
477: --Purging old data from fv_facts_temp table
478: purge_facts_transactions;
479: --return; bug 9191060; if edits fail for one process, the other processes should continue

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

479: --return; bug 9191060; if edits fail for one process, the other processes should continue
480: END IF;*/
481:
482: END IF;
483: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
484: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'Unable to process FACTS II in sbr for TS ...'|| parm_treasury_value||errbuf_facts);
485: END IF;
486:
487: END IF;

Line 484: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'Unable to process FACTS II in sbr for TS ...'|| parm_treasury_value||errbuf_facts);

480: END IF;*/
481:
482: END IF;
483: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
484: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'Unable to process FACTS II in sbr for TS ...'|| parm_treasury_value||errbuf_facts);
485: END IF;
486:
487: END IF;
488: END LOOP;

Line 490: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'FV_FACTS_TRANSACTIONS.v_g_edit_check_code ->'||FV_FACTS_TRANSACTIONS.v_g_edit_check_code);

486:
487: END IF;
488: END LOOP;
489: -- end for if retcode_facts <> 0
490: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'FV_FACTS_TRANSACTIONS.v_g_edit_check_code ->'||FV_FACTS_TRANSACTIONS.v_g_edit_check_code);
491:
492: -- Commentd out code which checks if required edit checks passedd
493:
494: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

490: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'FV_FACTS_TRANSACTIONS.v_g_edit_check_code ->'||FV_FACTS_TRANSACTIONS.v_g_edit_check_code);
491:
492: -- Commentd out code which checks if required edit checks passedd
493:
494: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
495: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'CALLING BUILD REPORT LINES.....');
496: END IF;
497: build_report_lines;
498:

Line 495: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'CALLING BUILD REPORT LINES.....');

491:
492: -- Commentd out code which checks if required edit checks passedd
493:
494: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
495: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'CALLING BUILD REPORT LINES.....');
496: END IF;
497: build_report_lines;
498:
499: IF g_error_code <> 0 THEN

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

498:
499: IF g_error_code <> 0 THEN
500: errbuf := errbuf || 'Processing for Treasury Symbol '|| parm_treasury_value||' FAILED '|| g_error_message;
501: ELSE
502: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
503: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'SUBMITTING sbr REPORT FOR TS.....'||parm_treasury_value);
504: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'BEFORE CALLING REPORT -> v_retcode :'||v_retcode);
505: END IF;
506:

Line 503: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'SUBMITTING sbr REPORT FOR TS.....'||parm_treasury_value);

499: IF g_error_code <> 0 THEN
500: errbuf := errbuf || 'Processing for Treasury Symbol '|| parm_treasury_value||' FAILED '|| g_error_message;
501: ELSE
502: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
503: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'SUBMITTING sbr REPORT FOR TS.....'||parm_treasury_value);
504: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'BEFORE CALLING REPORT -> v_retcode :'||v_retcode);
505: END IF;
506:
507: IF v_retcode IN (0, 1) THEN

Line 504: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'BEFORE CALLING REPORT -> v_retcode :'||v_retcode);

500: errbuf := errbuf || 'Processing for Treasury Symbol '|| parm_treasury_value||' FAILED '|| g_error_message;
501: ELSE
502: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
503: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'SUBMITTING sbr REPORT FOR TS.....'||parm_treasury_value);
504: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'BEFORE CALLING REPORT -> v_retcode :'||v_retcode);
505: END IF;
506:
507: IF v_retcode IN (0, 1) THEN
508: l_request_id := FND_REQUEST.SUBMIT_REQUEST ('FV', 'FVSBRCMR', '', '', FALSE, v_sequence_id, v_sob, v_period_name, p_units, v_report_type, v_end_date,v_period_fiscal_year);

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

508: l_request_id := FND_REQUEST.SUBMIT_REQUEST ('FV', 'FVSBRCMR', '', '', FALSE, v_sequence_id, v_sob, v_period_name, p_units, v_report_type, v_end_date,v_period_fiscal_year);
509: IF l_request_id = 0 THEN
510: errbuf := 'Error submitting Consolidated Financial Statements Report';
511: retcode := -1;
512: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.error1',errbuf);
513: RETURN;
514: ELSE
515: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
516: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'CONCURRENT REQUEST ID FOR CONSOLIDATED FINANCIAL STATEMENTS REPORT - ' || l_request_id);

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

511: retcode := -1;
512: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.error1',errbuf);
513: RETURN;
514: ELSE
515: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
516: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'CONCURRENT REQUEST ID FOR CONSOLIDATED FINANCIAL STATEMENTS REPORT - ' || l_request_id);
517: END IF;
518: END IF;
519: END IF;

Line 516: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'CONCURRENT REQUEST ID FOR CONSOLIDATED FINANCIAL STATEMENTS REPORT - ' || l_request_id);

512: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.error1',errbuf);
513: RETURN;
514: ELSE
515: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
516: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'CONCURRENT REQUEST ID FOR CONSOLIDATED FINANCIAL STATEMENTS REPORT - ' || l_request_id);
517: END IF;
518: END IF;
519: END IF;
520: END IF;

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

534: build_dynamic_query;
535: IF v_retcode IN (0, 1) THEN
536: process_report_line;
537: END IF;
538: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
539: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'BEFORE CALLING REPORT -> v_retcode :'||v_retcode);
540: END IF;
541: IF v_retcode IN (0, 1) THEN
542: l_request_id := FND_REQUEST.SUBMIT_REQUEST ('FV', 'FVCFSCMR', '', '', FALSE, v_sequence_id, v_sob, v_period_name, p_units, v_report_type, v_end_date );

Line 539: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'BEFORE CALLING REPORT -> v_retcode :'||v_retcode);

535: IF v_retcode IN (0, 1) THEN
536: process_report_line;
537: END IF;
538: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
539: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'BEFORE CALLING REPORT -> v_retcode :'||v_retcode);
540: END IF;
541: IF v_retcode IN (0, 1) THEN
542: l_request_id := FND_REQUEST.SUBMIT_REQUEST ('FV', 'FVCFSCMR', '', '', FALSE, v_sequence_id, v_sob, v_period_name, p_units, v_report_type, v_end_date );
543: IF l_request_id = 0 THEN

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

542: l_request_id := FND_REQUEST.SUBMIT_REQUEST ('FV', 'FVCFSCMR', '', '', FALSE, v_sequence_id, v_sob, v_period_name, p_units, v_report_type, v_end_date );
543: IF l_request_id = 0 THEN
544: errbuf := 'Error submitting Consolidated Financial Statements Report';
545: retcode := -1;
546: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.error1',errbuf);
547: RETURN;
548: ELSE
549:
550: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

546: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.error1',errbuf);
547: RETURN;
548: ELSE
549:
550: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
551: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'CONCURRENT REQUEST ID FOR CONSOLIDATED FINANCIAL STATEMENTS REPORT - ' || l_request_id);
552: END IF;
553: COMMIT;
554: END IF;

Line 551: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'CONCURRENT REQUEST ID FOR CONSOLIDATED FINANCIAL STATEMENTS REPORT - ' || l_request_id);

547: RETURN;
548: ELSE
549:
550: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
551: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'CONCURRENT REQUEST ID FOR CONSOLIDATED FINANCIAL STATEMENTS REPORT - ' || l_request_id);
552: END IF;
553: COMMIT;
554: END IF;
555: END IF;

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

560: EXCEPTION
561: WHEN OTHERS THEN
562: retcode := SQLCODE ;
563: errbuf := SQLERRM || ' [MAIN] ' ;
564: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',v_errbuf);
565: ROLLBACK;
566: COMMIT ;
567: END main;
568: -- =============================================================

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

613: EXCEPTION
614: WHEN invalid_segment THEN
615: v_retcode := -1;
616: v_errbuf := 'Error getting Balancing and Accounting segments.';
617: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.invalid_segment',v_errbuf);
618: ROLLBACK;
619: RETURN;
620: WHEN OTHERS THEN
621: v_retcode := SQLCODE;

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

619: RETURN;
620: WHEN OTHERS THEN
621: v_retcode := SQLCODE;
622: v_errbuf := sqlerrm ;
623: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',v_errbuf);
624: RETURN;
625: END get_qualifier_segments ;
626: -- =============================================================
627: PROCEDURE populate_ccid

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

742: l_cnt NUMBER;
743: BEGIN
744:
745:
746: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Ccid process starts');
747: IF upper(v_report_type)=upper('SBR') THEN
748: FOR sbr_crec_rec IN SBR_CREC
749: LOOP
750: v_seg(1) := sbr_crec_rec.segment1;

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

846: END LOOP;
847: --SBR POPULATE CCID
848: ELSE
849: /*NON SBR data*/
850: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Ccid process starts');
851: FOR crec_rec IN crec
852: LOOP
853: v_seg(1) := crec_rec.segment1;
854: v_seg(2) := crec_rec.segment2;

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

949: END IF;
950: END LOOP;
951: END IF;
952: /* flex_crec */
953: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
954: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'Popualte CCID Completed');
955: END IF;
956: EXCEPTION
957: WHEN OTHERS THEN

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

950: END LOOP;
951: END IF;
952: /* flex_crec */
953: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
954: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'Popualte CCID Completed');
955: END IF;
956: EXCEPTION
957: WHEN OTHERS THEN
958: v_retcode := -1;

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

956: EXCEPTION
957: WHEN OTHERS THEN
958: v_retcode := -1;
959: v_errbuf := '[POPULATE-CCID]' || sqlerrm;
960: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',v_errbuf);
961: RETURN;
962: END populate_ccid;
963: -- =============================================================
964: PROCEDURE build_dynamic_query

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

1110: EXCEPTION
1111: WHEN OTHERS THEN
1112: v_retcode := SQLCODE ;
1113: v_errbuf := SQLERRM || ' [BUILD_DYNAMIC_QUERY] ' ;
1114: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',v_errbuf);
1115: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception','Stage it errors ' || l_stage);
1116: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',l_out);
1117: RETURN;
1118: END build_dynamic_query;

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

1111: WHEN OTHERS THEN
1112: v_retcode := SQLCODE ;
1113: v_errbuf := SQLERRM || ' [BUILD_DYNAMIC_QUERY] ' ;
1114: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',v_errbuf);
1115: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception','Stage it errors ' || l_stage);
1116: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',l_out);
1117: RETURN;
1118: END build_dynamic_query;
1119: -- =============================================================

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

1112: v_retcode := SQLCODE ;
1113: v_errbuf := SQLERRM || ' [BUILD_DYNAMIC_QUERY] ' ;
1114: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',v_errbuf);
1115: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception','Stage it errors ' || l_stage);
1116: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',l_out);
1117: RETURN;
1118: END build_dynamic_query;
1119: -- =============================================================
1120: PROCEDURE process_report_line

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

1181: WHERE line_id = v_line_id;
1182: IF l_line_cnt = 0 THEN
1183: v_retcode := -1;
1184: v_errbuf := 'SEED Data not properly Loaded. Please Verify and reinvoke the Process.';
1185: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.error1',v_errbuf);
1186: RETURN;
1187: END IF;
1188: -- $$$dbms_sql.bind_variable(v_cursor_id1,':cv_line_id',v_line_id);
1189: process_total_line;

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

1207: EXCEPTION
1208: WHEN OTHERS THEN
1209: v_retcode := SQLCODE ;
1210: v_errbuf := SQLERRM || ' [PROCESS_REPORT_LINE] ' ;
1211: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',v_errbuf);
1212: RETURN;
1213: END process_report_line;
1214: -- =============================================================
1215: PROCEDURE get_one_time_values

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

1296: AND period_year = v_period_fiscal_year-1
1297: AND application_id = '101'
1298: AND period_num = v_period_num;
1299:
1300: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Chart of accounts id: '||v_chart_of_accounts_id);
1301: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Fiscal year: '||v_period_fiscal_year);
1302: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_period_name: '||v_period_name);
1303: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_period_num: '||v_period_num);
1304: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_end_date: '||v_end_date);

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

1297: AND application_id = '101'
1298: AND period_num = v_period_num;
1299:
1300: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Chart of accounts id: '||v_chart_of_accounts_id);
1301: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Fiscal year: '||v_period_fiscal_year);
1302: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_period_name: '||v_period_name);
1303: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_period_num: '||v_period_num);
1304: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_end_date: '||v_end_date);
1305: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_begin_period: '||v_begin_period);

Line 1302: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_period_name: '||v_period_name);

1298: AND period_num = v_period_num;
1299:
1300: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Chart of accounts id: '||v_chart_of_accounts_id);
1301: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Fiscal year: '||v_period_fiscal_year);
1302: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_period_name: '||v_period_name);
1303: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_period_num: '||v_period_num);
1304: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_end_date: '||v_end_date);
1305: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_begin_period: '||v_begin_period);
1306: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_begin_period_end_date: '||v_begin_period_end_date);

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

1299:
1300: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Chart of accounts id: '||v_chart_of_accounts_id);
1301: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Fiscal year: '||v_period_fiscal_year);
1302: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_period_name: '||v_period_name);
1303: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_period_num: '||v_period_num);
1304: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_end_date: '||v_end_date);
1305: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_begin_period: '||v_begin_period);
1306: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_begin_period_end_date: '||v_begin_period_end_date);
1307: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_begin_period_1: '||v_begin_period_1);

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

1300: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Chart of accounts id: '||v_chart_of_accounts_id);
1301: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Fiscal year: '||v_period_fiscal_year);
1302: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_period_name: '||v_period_name);
1303: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_period_num: '||v_period_num);
1304: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_end_date: '||v_end_date);
1305: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_begin_period: '||v_begin_period);
1306: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_begin_period_end_date: '||v_begin_period_end_date);
1307: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_begin_period_1: '||v_begin_period_1);
1308: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_begin_period_1_end_date: '||v_begin_period_1_end_date);

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

1301: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Fiscal year: '||v_period_fiscal_year);
1302: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_period_name: '||v_period_name);
1303: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_period_num: '||v_period_num);
1304: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_end_date: '||v_end_date);
1305: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_begin_period: '||v_begin_period);
1306: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_begin_period_end_date: '||v_begin_period_end_date);
1307: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_begin_period_1: '||v_begin_period_1);
1308: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_begin_period_1_end_date: '||v_begin_period_1_end_date);
1309: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_end_period_1_end_date: '||v_end_period_1_end_date);

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

1302: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_period_name: '||v_period_name);
1303: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_period_num: '||v_period_num);
1304: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_end_date: '||v_end_date);
1305: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_begin_period: '||v_begin_period);
1306: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_begin_period_end_date: '||v_begin_period_end_date);
1307: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_begin_period_1: '||v_begin_period_1);
1308: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_begin_period_1_end_date: '||v_begin_period_1_end_date);
1309: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_end_period_1_end_date: '||v_end_period_1_end_date);
1310: EXCEPTION

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

1303: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_period_num: '||v_period_num);
1304: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_end_date: '||v_end_date);
1305: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_begin_period: '||v_begin_period);
1306: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_begin_period_end_date: '||v_begin_period_end_date);
1307: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_begin_period_1: '||v_begin_period_1);
1308: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_begin_period_1_end_date: '||v_begin_period_1_end_date);
1309: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_end_period_1_end_date: '||v_end_period_1_end_date);
1310: EXCEPTION
1311: WHEN NO_DATA_FOUND THEN

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

1304: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_end_date: '||v_end_date);
1305: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_begin_period: '||v_begin_period);
1306: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_begin_period_end_date: '||v_begin_period_end_date);
1307: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_begin_period_1: '||v_begin_period_1);
1308: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_begin_period_1_end_date: '||v_begin_period_1_end_date);
1309: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_end_period_1_end_date: '||v_end_period_1_end_date);
1310: EXCEPTION
1311: WHEN NO_DATA_FOUND THEN
1312: IF l_stage = 4 OR l_stage = 5 THEN

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

1305: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_begin_period: '||v_begin_period);
1306: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_begin_period_end_date: '||v_begin_period_end_date);
1307: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_begin_period_1: '||v_begin_period_1);
1308: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_begin_period_1_end_date: '||v_begin_period_1_end_date);
1309: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_end_period_1_end_date: '||v_end_period_1_end_date);
1310: EXCEPTION
1311: WHEN NO_DATA_FOUND THEN
1312: IF l_stage = 4 OR l_stage = 5 THEN
1313: fv_utility.log_mesg('No calendar has been setup for the year: '||TO_CHAR(v_period_fiscal_year-1));

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

1480: AND id_flex_code = 'GL#'
1481: AND id_flex_num = v_chart_of_accounts_id;
1482:
1483: l_log_mesg := '***** Line Number' || v_line_number || ': ' || '*****';
1484: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,l_log_mesg);
1485: FOR detail_rec IN fv_cfs_detail_cur
1486: LOOP ---- L1
1487: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, '########');
1488: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Account Num: '||detail_rec.account_number);

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

1483: l_log_mesg := '***** Line Number' || v_line_number || ': ' || '*****';
1484: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,l_log_mesg);
1485: FOR detail_rec IN fv_cfs_detail_cur
1486: LOOP ---- L1
1487: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, '########');
1488: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Account Num: '||detail_rec.account_number);
1489: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'line id: '||v_line_id);
1490: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'line detail id: '||detail_rec.line_detail_id);
1491: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'balance type: '||detail_rec.balance_type);

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

1484: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,l_log_mesg);
1485: FOR detail_rec IN fv_cfs_detail_cur
1486: LOOP ---- L1
1487: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, '########');
1488: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Account Num: '||detail_rec.account_number);
1489: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'line id: '||v_line_id);
1490: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'line detail id: '||detail_rec.line_detail_id);
1491: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'balance type: '||detail_rec.balance_type);
1492: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Fed Non Fed: '||detail_rec.fed_non_fed);

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

1485: FOR detail_rec IN fv_cfs_detail_cur
1486: LOOP ---- L1
1487: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, '########');
1488: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Account Num: '||detail_rec.account_number);
1489: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'line id: '||v_line_id);
1490: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'line detail id: '||detail_rec.line_detail_id);
1491: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'balance type: '||detail_rec.balance_type);
1492: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Fed Non Fed: '||detail_rec.fed_non_fed);
1493: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'By Recipient: '||v_by_recipient);

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

1486: LOOP ---- L1
1487: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, '########');
1488: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Account Num: '||detail_rec.account_number);
1489: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'line id: '||v_line_id);
1490: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'line detail id: '||detail_rec.line_detail_id);
1491: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'balance type: '||detail_rec.balance_type);
1492: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Fed Non Fed: '||detail_rec.fed_non_fed);
1493: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'By Recipient: '||v_by_recipient);
1494: v_balance_type := detail_rec.balance_type;

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

1487: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, '########');
1488: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Account Num: '||detail_rec.account_number);
1489: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'line id: '||v_line_id);
1490: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'line detail id: '||detail_rec.line_detail_id);
1491: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'balance type: '||detail_rec.balance_type);
1492: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Fed Non Fed: '||detail_rec.fed_non_fed);
1493: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'By Recipient: '||v_by_recipient);
1494: v_balance_type := detail_rec.balance_type;
1495: l_balance_determined := 0;

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

1488: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Account Num: '||detail_rec.account_number);
1489: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'line id: '||v_line_id);
1490: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'line detail id: '||detail_rec.line_detail_id);
1491: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'balance type: '||detail_rec.balance_type);
1492: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Fed Non Fed: '||detail_rec.fed_non_fed);
1493: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'By Recipient: '||v_by_recipient);
1494: v_balance_type := detail_rec.balance_type;
1495: l_balance_determined := 0;
1496: l_prev_year_gl_balance := 0;

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

1489: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'line id: '||v_line_id);
1490: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'line detail id: '||detail_rec.line_detail_id);
1491: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'balance type: '||detail_rec.balance_type);
1492: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Fed Non Fed: '||detail_rec.fed_non_fed);
1493: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'By Recipient: '||v_by_recipient);
1494: v_balance_type := detail_rec.balance_type;
1495: l_balance_determined := 0;
1496: l_prev_year_gl_balance := 0;
1497: l_curr_year_gl_balance := 0;

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

1522: WHEN l_ignore= 0;
1523: dbms_sql.column_value(v_fct1_rcpt_sel_curid, 1, v_amount);
1524: dbms_sql.column_value(v_fct1_rcpt_sel_curid, 2, v_recipient_name);
1525: v_col_1_amt := NVL(v_amount, 0);
1526: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Recipient name: '||v_recipient_name);
1527: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Recipient amount: '||v_amount);
1528: dbms_sql.bind_variable(v_fct1_rcpt_sel2_curid,':cv_recipient_name',v_recipient_name);
1529: l_ignore := dbms_sql.execute_and_fetch(v_fct1_rcpt_sel2_curid);
1530: dbms_sql.column_value(v_fct1_rcpt_sel2_curid, 1, v_amount);

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

1523: dbms_sql.column_value(v_fct1_rcpt_sel_curid, 1, v_amount);
1524: dbms_sql.column_value(v_fct1_rcpt_sel_curid, 2, v_recipient_name);
1525: v_col_1_amt := NVL(v_amount, 0);
1526: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Recipient name: '||v_recipient_name);
1527: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Recipient amount: '||v_amount);
1528: dbms_sql.bind_variable(v_fct1_rcpt_sel2_curid,':cv_recipient_name',v_recipient_name);
1529: l_ignore := dbms_sql.execute_and_fetch(v_fct1_rcpt_sel2_curid);
1530: dbms_sql.column_value(v_fct1_rcpt_sel2_curid, 1, v_amount);
1531: v_col_2_amt := NVL(v_amount, 0);

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

1528: dbms_sql.bind_variable(v_fct1_rcpt_sel2_curid,':cv_recipient_name',v_recipient_name);
1529: l_ignore := dbms_sql.execute_and_fetch(v_fct1_rcpt_sel2_curid);
1530: dbms_sql.column_value(v_fct1_rcpt_sel2_curid, 1, v_amount);
1531: v_col_2_amt := NVL(v_amount, 0);
1532: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Recipient group by amount: '||v_amount);
1533: l_found := FALSE;
1534: FOR i IN 1..l_recipient_cnt - 1
1535: LOOP
1536: IF l_recipient_rec(i).recipient_name = v_recipient_name THEN

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

1573: NULL;
1574: END;
1575: END;
1576: END IF;
1577: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Account Type: '||l_account_type);
1578: -- ===================================================================
1579: v_py_gl_beg_bal := 0;
1580: v_py_gl_end_bal := 0;
1581: v_cy_gl_beg_bal := 0;

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

1589: dbms_sql.bind_variable(v_glbal_curid,':cv_balance_type','B');
1590: dbms_sql.bind_variable(v_glbal_curid,':cv_end_date', v_begin_period_1_end_date);
1591: l_ignore := dbms_sql.execute_and_fetch(v_glbal_curid);
1592: dbms_sql.column_value(v_glbal_curid, 1, v_py_gl_beg_bal);
1593: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Prior year begin gl bal: '||v_py_gl_beg_bal);
1594: -- Get current year beginning balance
1595: dbms_sql.bind_variable(v_glbal_curid,':cv_period_fiscal_year',v_period_fiscal_year);
1596: dbms_sql.bind_variable(v_glbal_curid,':cv_end_date', v_begin_period_end_date);
1597: dbms_sql.bind_variable(v_glbal_curid,':cv_balance_type','B');

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

1596: dbms_sql.bind_variable(v_glbal_curid,':cv_end_date', v_begin_period_end_date);
1597: dbms_sql.bind_variable(v_glbal_curid,':cv_balance_type','B');
1598: l_ignore := dbms_sql.execute_and_fetch(v_glbal_curid);
1599: dbms_sql.column_value(v_glbal_curid, 1, v_cy_gl_beg_bal);
1600: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Current year begin gl bal: '||v_cy_gl_beg_bal);
1601: -- ===================================================================
1602: IF v_report_type <> 'sbr' AND l_account_type NOT IN ('D','C') THEN --- 3
1603: v_py_fct1_begbal := 0;
1604: v_py_fct1_endbal := 0;

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

1613: has a blank Natural Balance in the Report Definitions form.
1614: Please select Natural Balance for any line with a Balance Type
1615: of Net Increase or Net Decrease.';
1616: fnd_file.put_line(fnd_file.log, l_log_mesg);
1617: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, l_log_mesg);
1618: v_retcode := -1 ;
1619: v_errbuf := l_log_mesg;
1620: ROLLBACK;
1621: RETURN;

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

1622: END IF;
1623: --======= PRIOR YEAR CALCULATION ===========
1624: -- Get facts1 beginning balance for prior year
1625: IF detail_rec.balance_type IN ('B','G','I','J') THEN
1626: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Prior year begin bal: '||v_py_gl_beg_bal);
1627: IF detail_rec.balance_type = 'B' THEN
1628: v_amount := v_py_gl_beg_bal;
1629: END IF;
1630: END IF;

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

1636: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_balance_type','');
1637: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_period_num',v_end_period);
1638: l_ignore := dbms_sql.execute_and_fetch(v_fct1_sel_curid);
1639: dbms_sql.column_value(v_fct1_sel_curid, 1, v_py_fct1_endbal);
1640: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Prior year end facts1 bal: '||v_py_fct1_endbal);
1641: v_amount := get_bal_type_amt(detail_rec.balance_type, v_natural_balance_type, NVL(v_py_gl_beg_bal,0), NVL(v_py_fct1_endbal,0));
1642: END IF;
1643: -- Set prior year amounts for reporting
1644: -- Bug 9479298

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

1668: --======= CURRENT YEAR CALCULATION ===========
1669: -- Get facts1 beginning balance for current year
1670: v_amount := 0;
1671: IF detail_rec.balance_type IN ('B','G','I','J') THEN
1672: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Current year begin bal: '||v_cy_gl_beg_bal);
1673: IF detail_rec.balance_type = 'B' THEN
1674: v_amount := v_cy_gl_beg_bal;
1675: END IF;
1676: END IF;

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

1682: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_balance_type','');
1683: dbms_sql.bind_variable(v_fct1_sel_curid,':cv_period_num',v_end_period);
1684: l_ignore := dbms_sql.execute_and_fetch(v_fct1_sel_curid);
1685: dbms_sql.column_value(v_fct1_sel_curid, 1, v_cy_fct1_endbal);
1686: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Current year end facsts1 bal: '||v_cy_fct1_endbal);
1687: v_amount := get_bal_type_amt(detail_rec.balance_type, v_natural_balance_type, NVL(v_cy_gl_beg_bal,0), NVL(v_cy_fct1_endbal,0));
1688: END IF;
1689: -- Set current year amounts for reporting
1690: IF detail_rec.cum_res = 'Y' OR detail_rec.budget_col = 'Y' OR (detail_rec.cum_res IS NULL AND detail_rec.budget_col IS NULL) THEN

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

1720: dbms_sql.bind_variable(v_sbr_curid,':cv_period_fiscal_year',v_period_fiscal_year);
1721: l_ignore := dbms_sql.execute_and_fetch(v_sbr_curid);
1722: dbms_sql.column_value(v_sbr_curid, 1, v_cy_sbr_beg_bal);
1723: v_amount := v_cy_sbr_beg_bal;
1724: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Current year begin bal: '||v_cy_sbr_beg_bal);
1725: ELSIF detail_rec.balance_type IN ('C','D','E','G','I','J') THEN
1726: -- IF balance type is ending, ending cr only or ending dr only
1727: -- Get the begin balance
1728: dbms_sql.bind_variable(v_sbr_curid,':cv_balance_type','B');

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

1737: dbms_sql.bind_variable(v_sbr_curid,':cv_end_date', v_end_period_end_date);
1738: dbms_sql.bind_variable(v_sbr_curid,':cv_period_fiscal_year',v_period_fiscal_year);
1739: l_ignore := dbms_sql.execute_and_fetch(v_sbr_curid);
1740: dbms_sql.column_value(v_sbr_curid, 1, v_cy_sbr_end_bal);
1741: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Current year end bal: '||v_cy_sbr_end_bal);
1742: v_amount := get_bal_type_amt(detail_rec.balance_type, v_natural_balance_type, NVL(v_cy_sbr_beg_bal,0), NVL(v_cy_sbr_end_bal,0));
1743: END IF;
1744: -- Set current year amounts for reporting
1745: IF detail_rec.cum_res = 'Y' OR detail_rec.budget_col = 'Y' OR (detail_rec.cum_res IS NULL AND detail_rec.budget_col IS NULL) THEN

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

1765: dbms_sql.bind_variable(v_sbr_curid,':cv_period_fiscal_year',v_period_fiscal_year-1);
1766: l_ignore := dbms_sql.execute_and_fetch(v_sbr_curid);
1767: dbms_sql.column_value(v_sbr_curid, 1, v_py_sbr_beg_bal);
1768: v_amount := v_py_sbr_beg_bal;
1769: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Prior year begin bal: '||v_py_sbr_beg_bal);
1770: -- IF balance type is ending, ending cr only or ending dr only
1771: ELSIF detail_rec.balance_type IN ('C', 'D','E','G','I','J') THEN
1772: -- Get the begin balance
1773: dbms_sql.bind_variable(v_sbr_curid,':cv_balance_type','B');

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

1782: dbms_sql.bind_variable(v_sbr_curid,':cv_end_date', v_end_period_1_end_date);
1783: dbms_sql.bind_variable(v_sbr_curid,':cv_period_fiscal_year',v_period_fiscal_year-1);
1784: l_ignore := dbms_sql.execute_and_fetch(v_sbr_curid);
1785: dbms_sql.column_value(v_sbr_curid, 1, v_py_sbr_end_bal);
1786: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Prior year end bal: '||v_py_sbr_end_bal);
1787: v_amount := get_bal_type_amt(detail_rec.balance_type, v_natural_balance_type, NVL(v_py_sbr_beg_bal,0), NVL(v_py_sbr_end_bal,0));
1788: END IF;
1789: l_log_mesg := ', ' || NVL(v_amount, 0);
1790:

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

1842: || ', '
1843: || v_col_6_amt)
1844: INTO l_log_mesg
1845: FROM dual;
1846: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1847: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,L_LOG_MESG);
1848: END IF;
1849: populate_temp_table;
1850: END IF;

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

1843: || v_col_6_amt)
1844: INTO l_log_mesg
1845: FROM dual;
1846: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1847: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,L_LOG_MESG);
1848: END IF;
1849: populate_temp_table;
1850: END IF;
1851: EXCEPTION

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

1851: EXCEPTION
1852: WHEN OTHERS THEN
1853: v_retcode := SQLCODE ;
1854: v_errbuf := SQLERRM || ' [PROCESS_DETAIL_LINE] ' ;
1855: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',v_errbuf);
1856: RETURN;
1857: END process_detail_line;
1858:
1859: -- =============================================================

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

2137: EXCEPTION
2138: WHEN OTHERS THEN
2139: v_retcode := SQLCODE ;
2140: v_errbuf := SQLERRM || ' [PROCESS_TOTAL_LINE] ' ;
2141: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',v_errbuf);
2142: RETURN;
2143: END process_total_line;
2144: /* SBR developement*/
2145: /*Processing the SBR line totals*/

Line 2214: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,'Inside process_sbr_total_line');

2210: amt_array amt_table;
2211: amt_array_cnt BINARY_INTEGER DEFAULT 1;
2212: --v_col_1_amt fv_sbr_definitions_cols_temp.sf133_column_amount%TYPE;
2213: BEGIN
2214: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,'Inside process_sbr_total_line');
2215: FOR calc_rec IN fv_sbr_calc_cur
2216: LOOP
2217: amt_array(amt_array_cnt).calc_sequence := calc_rec.calc_sequence_number;
2218: IF calc_rec.line_low_type = 'L' AND calc_rec.operator IN ('+','-') THEN

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

2314: EXCEPTION
2315: WHEN OTHERS THEN
2316: v_retcode := SQLCODE ;
2317: v_errbuf := SQLERRM || ' [PROCESS_TOTAL_LINE] ' ;
2318: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',v_errbuf);
2319: RETURN;
2320: END process_sbr_total_line;
2321: /*SBR */
2322: -- =============================================================

Line 2577: FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',v_errbuf

2573: v_retcode := -1;
2574: v_errbuf := SQLERRM;
2575: FV_UTILITY.LOG_MESG
2576: (
2577: FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',v_errbuf
2578: )
2579: ;
2580: RAISE;
2581: END populate_temp_table;

Line 2601: fnd_log.level_statement, l_module_name, 'IN get_bal_type_amt function'

2597: l_end_minus_beg_amt NUMBER;
2598: BEGIN
2599: fv_utility.debug_mesg
2600: (
2601: fnd_log.level_statement, l_module_name, 'IN get_bal_type_amt function'
2602: )
2603: ;
2604: fv_utility.debug_mesg
2605: (

Line 2606: fnd_log.level_statement, l_module_name, 'Natural balance: '||p_natural_bal_type

2602: )
2603: ;
2604: fv_utility.debug_mesg
2605: (
2606: fnd_log.level_statement, l_module_name, 'Natural balance: '||p_natural_bal_type
2607: )
2608: ;
2609: fv_utility.debug_mesg
2610: (

Line 2611: fnd_log.level_statement, l_module_name, 'p_beg_bal: '||p_beg_bal

2607: )
2608: ;
2609: fv_utility.debug_mesg
2610: (
2611: fnd_log.level_statement, l_module_name, 'p_beg_bal: '||p_beg_bal
2612: )
2613: ;
2614: fv_utility.debug_mesg
2615: (

Line 2616: fnd_log.level_statement, l_module_name, 'p_end_bal: '||p_end_bal

2612: )
2613: ;
2614: fv_utility.debug_mesg
2615: (
2616: fnd_log.level_statement, l_module_name, 'p_end_bal: '||p_end_bal
2617: )
2618: ;
2619: IF p_balance_type = 'E' THEN
2620: RETURN p_end_bal;

Line 2643: fnd_log.level_statement, l_module_name, 'end minus begin: '||l_end_minus_beg_amt

2639: -- natural balance type
2640: l_end_minus_beg_amt := p_end_bal - p_beg_bal;
2641: fv_utility.debug_mesg
2642: (
2643: fnd_log.level_statement, l_module_name, 'end minus begin: '||l_end_minus_beg_amt
2644: )
2645: ;
2646: IF p_balance_type = 'G' THEN
2647: RETURN l_end_minus_beg_amt;

Line 2684: FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',v_errbuf

2680: v_retcode := -1;
2681: v_errbuf := SQLERRM;
2682: FV_UTILITY.LOG_MESG
2683: (
2684: FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',v_errbuf
2685: )
2686: ;
2687: END get_bal_type_amt;
2688:

Line 2706: FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

2702: l_module_name := g_module_name || 'build_report_lines';
2703: --
2704: IF
2705: (
2706: FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
2707: )
2708: THEN
2709: FV_UTILITY.DEBUG_MESG
2710: (

Line 2711: FND_LOG.LEVEL_STATEMENT, l_module_name,'START BUILD_REPORT_LINES'

2707: )
2708: THEN
2709: FV_UTILITY.DEBUG_MESG
2710: (
2711: FND_LOG.LEVEL_STATEMENT, l_module_name,'START BUILD_REPORT_LINES'
2712: )
2713: ;
2714: END IF;
2715: --

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

2734: AND PERIOD_YEAR = v_period_fiscal_year
2735: AND APPLICATION_ID = '101'
2736: AND CLOSING_STATUS IN ('O','C')
2737: AND PERIOD_NAME = v_period_name;
2738: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2739: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'Min Period num->'||g_period_num);
2740: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'Period Number for quarter->'||parm_gl_period_num);
2741: END IF;
2742: -- ----------------------------------------------------

Line 2739: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'Min Period num->'||g_period_num);

2735: AND APPLICATION_ID = '101'
2736: AND CLOSING_STATUS IN ('O','C')
2737: AND PERIOD_NAME = v_period_name;
2738: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2739: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'Min Period num->'||g_period_num);
2740: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'Period Number for quarter->'||parm_gl_period_num);
2741: END IF;
2742: -- ----------------------------------------------------
2743: -- Get Next sbr Treasury Symbol Line from Cursor

Line 2740: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'Period Number for quarter->'||parm_gl_period_num);

2736: AND CLOSING_STATUS IN ('O','C')
2737: AND PERIOD_NAME = v_period_name;
2738: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2739: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'Min Period num->'||g_period_num);
2740: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'Period Number for quarter->'||parm_gl_period_num);
2741: END IF;
2742: -- ----------------------------------------------------
2743: -- Get Next sbr Treasury Symbol Line from Cursor
2744: -- ----------------------------------------------------

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

2744: -- ----------------------------------------------------
2745: --
2746: g_ts_value_in_process := NULL;
2747: --
2748: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2749: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'Before cursor.....sbr_report_line_cursor');
2750: END IF;
2751: /*INSERTING ALL LABELS TO Report table*/
2752: INSERT

Line 2749: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'Before cursor.....sbr_report_line_cursor');

2745: --
2746: g_ts_value_in_process := NULL;
2747: --
2748: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2749: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'Before cursor.....sbr_report_line_cursor');
2750: END IF;
2751: /*INSERTING ALL LABELS TO Report table*/
2752: INSERT
2753: INTO fv_cfs_rep_temp

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

2774:
2775: FOR sbr_report_line_entry IN sbr_report_line_cursor
2776: LOOP
2777: --
2778: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2779: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'In cursor.....sbr_report_line_cursor');
2780: END IF;
2781: c_sbr_line_id := sbr_report_line_entry.sbr_line_id;
2782: c_sbr_line_number := sbr_report_line_entry.sbr_line_number;

Line 2779: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'In cursor.....sbr_report_line_cursor');

2775: FOR sbr_report_line_entry IN sbr_report_line_cursor
2776: LOOP
2777: --
2778: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2779: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'In cursor.....sbr_report_line_cursor');
2780: END IF;
2781: c_sbr_line_id := sbr_report_line_entry.sbr_line_id;
2782: c_sbr_line_number := sbr_report_line_entry.sbr_line_number;
2783: c_sbr_line_type_code := sbr_report_line_entry.sbr_line_type_code;

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

2785: c_sbr_report_line_number := sbr_report_line_entry.sbr_report_line_number;
2786: c_sbr_gl_balance := sbr_report_line_entry.sbr_gl_balance;
2787: v_line_id := c_sbr_line_id;
2788: v_line_label := sbr_report_line_entry.sbr_line_label;
2789: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2790: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sbr_line_id:'||c_sbr_line_id);
2791: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sbr_line_number:'||c_sbr_line_number);
2792: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sbr_line_type_code:'||c_sbr_line_type_code);
2793: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sbr_natural_bal_type:'||c_sbr_natural_bal_type);

Line 2790: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sbr_line_id:'||c_sbr_line_id);

2786: c_sbr_gl_balance := sbr_report_line_entry.sbr_gl_balance;
2787: v_line_id := c_sbr_line_id;
2788: v_line_label := sbr_report_line_entry.sbr_line_label;
2789: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2790: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sbr_line_id:'||c_sbr_line_id);
2791: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sbr_line_number:'||c_sbr_line_number);
2792: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sbr_line_type_code:'||c_sbr_line_type_code);
2793: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sbr_natural_bal_type:'||c_sbr_natural_bal_type);
2794: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sbr_report_line_number:'||c_sbr_report_line_number);

Line 2791: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sbr_line_number:'||c_sbr_line_number);

2787: v_line_id := c_sbr_line_id;
2788: v_line_label := sbr_report_line_entry.sbr_line_label;
2789: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2790: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sbr_line_id:'||c_sbr_line_id);
2791: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sbr_line_number:'||c_sbr_line_number);
2792: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sbr_line_type_code:'||c_sbr_line_type_code);
2793: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sbr_natural_bal_type:'||c_sbr_natural_bal_type);
2794: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sbr_report_line_number:'||c_sbr_report_line_number);
2795: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'v_line_label:'||v_line_label);

Line 2792: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sbr_line_type_code:'||c_sbr_line_type_code);

2788: v_line_label := sbr_report_line_entry.sbr_line_label;
2789: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2790: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sbr_line_id:'||c_sbr_line_id);
2791: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sbr_line_number:'||c_sbr_line_number);
2792: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sbr_line_type_code:'||c_sbr_line_type_code);
2793: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sbr_natural_bal_type:'||c_sbr_natural_bal_type);
2794: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sbr_report_line_number:'||c_sbr_report_line_number);
2795: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'v_line_label:'||v_line_label);
2796: END IF;

Line 2793: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sbr_natural_bal_type:'||c_sbr_natural_bal_type);

2789: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2790: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sbr_line_id:'||c_sbr_line_id);
2791: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sbr_line_number:'||c_sbr_line_number);
2792: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sbr_line_type_code:'||c_sbr_line_type_code);
2793: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sbr_natural_bal_type:'||c_sbr_natural_bal_type);
2794: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sbr_report_line_number:'||c_sbr_report_line_number);
2795: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'v_line_label:'||v_line_label);
2796: END IF;
2797: IF g_error_code = 0 THEN

Line 2794: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sbr_report_line_number:'||c_sbr_report_line_number);

2790: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sbr_line_id:'||c_sbr_line_id);
2791: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sbr_line_number:'||c_sbr_line_number);
2792: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sbr_line_type_code:'||c_sbr_line_type_code);
2793: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sbr_natural_bal_type:'||c_sbr_natural_bal_type);
2794: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sbr_report_line_number:'||c_sbr_report_line_number);
2795: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'v_line_label:'||v_line_label);
2796: END IF;
2797: IF g_error_code = 0 THEN
2798: IF c_sbr_line_type_code = 'D' OR c_sbr_line_type_code = 'D2' THEN

Line 2795: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'v_line_label:'||v_line_label);

2791: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sbr_line_number:'||c_sbr_line_number);
2792: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sbr_line_type_code:'||c_sbr_line_type_code);
2793: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sbr_natural_bal_type:'||c_sbr_natural_bal_type);
2794: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sbr_report_line_number:'||c_sbr_report_line_number);
2795: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'v_line_label:'||v_line_label);
2796: END IF;
2797: IF g_error_code = 0 THEN
2798: IF c_sbr_line_type_code = 'D' OR c_sbr_line_type_code = 'D2' THEN
2799: g_column_number := 1;

Line 2801: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'Calling build_fiscal_line_columns :'||v_period_fiscal_year);

2797: IF g_error_code = 0 THEN
2798: IF c_sbr_line_type_code = 'D' OR c_sbr_line_type_code = 'D2' THEN
2799: g_column_number := 1;
2800: IF ( UPPER(NVL(c_sbr_gl_balance,'N')) = 'N' ) THEN
2801: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'Calling build_fiscal_line_columns :'||v_period_fiscal_year);
2802: build_fiscal_line_columns(v_period_fiscal_year);
2803: END IF;
2804: /*Pulling data for current year from GL BALANCES tables directly with out FV_FACT_TEMP*/
2805: IF ( UPPER(NVL(c_sbr_gl_balance,'N')) = 'Y' ) THEN

Line 2808: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'Calling get_sbr_py_bal_details :'||v_period_fiscal_year);

2804: /*Pulling data for current year from GL BALANCES tables directly with out FV_FACT_TEMP*/
2805: IF ( UPPER(NVL(c_sbr_gl_balance,'N')) = 'Y' ) THEN
2806: -- As get_sbr_py_bal_details pulls data for previous year
2807: -- increasing fiscal year by one
2808: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'Calling get_sbr_py_bal_details :'||v_period_fiscal_year);
2809: v_year_flag:='C';
2810: get_sbr_py_bal_details(v_period_fiscal_year+1);
2811:
2812: /*Populating previous fiscal year amount */

Line 2826: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.exception','BUILD_REPORT_LINES:Either fv_cfs_rep_temp table does not have data or some unknown error');

2822: AND period_num=v_period_num
2823: AND period_year=v_period_fiscal_year-1;
2824: EXCEPTION
2825: WHEN OTHERS THEN
2826: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.exception','BUILD_REPORT_LINES:Either fv_cfs_rep_temp table does not have data or some unknown error');
2827: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.exception',SQLERRM);
2828: END;
2829:
2830: populate_temp_table;

Line 2827: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.exception',SQLERRM);

2823: AND period_year=v_period_fiscal_year-1;
2824: EXCEPTION
2825: WHEN OTHERS THEN
2826: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.exception','BUILD_REPORT_LINES:Either fv_cfs_rep_temp table does not have data or some unknown error');
2827: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.exception',SQLERRM);
2828: END;
2829:
2830: populate_temp_table;
2831: END IF;

Line 2839: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.error','Total line does not contain calculations. SEED Data not properly Loaded. Please Verify and reinvoke the Process.');

2835: INTO l_line_cnt
2836: FROM fv_sbr_rep_line_calc
2837: WHERE line_id = c_sbr_line_id;
2838: IF l_line_cnt = 0 THEN
2839: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.error','Total line does not contain calculations. SEED Data not properly Loaded. Please Verify and reinvoke the Process.');
2840: RETURN;
2841: END IF;
2842: process_sbr_total_line;
2843: END IF; -- end of IF c_sbr_line_type_code = 'D' or c_sbr_line_type_code = 'D2' THEN

Line 2859: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.exception','BUILD_REPORT_LINES');

2855: CLOSE sbr_report_line_cursor;
2856: END IF;
2857: g_error_code := SQLCODE;
2858: g_error_message := SQLERRM;
2859: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.exception','BUILD_REPORT_LINES');
2860: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.exception',g_error_message);
2861: --
2862: END build_report_lines;
2863: -- --------------------------------------------------------

Line 2860: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.exception',g_error_message);

2856: END IF;
2857: g_error_code := SQLCODE;
2858: g_error_message := SQLERRM;
2859: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.exception','BUILD_REPORT_LINES');
2860: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.exception',g_error_message);
2861: --
2862: END build_report_lines;
2863: -- --------------------------------------------------------
2864: -- ----------------------------------------------

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

2882:
2883: BEGIN
2884: l_module_name := g_module_name || 'build_fiscal_line_columns';
2885: --
2886: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2887: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'START BUILD_FISCAL_LINE_COLUMNS');
2888: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, '-- LINE('||C_sbr_LINE_NUMBER||')' || ' Tresury Symbol('||c_sbr_ts_value ||')' || ' '||TO_CHAR(SYSDATE,'mm/dd/yyyy hh:mi:ss'));
2889: END IF;
2890: --

Line 2887: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'START BUILD_FISCAL_LINE_COLUMNS');

2883: BEGIN
2884: l_module_name := g_module_name || 'build_fiscal_line_columns';
2885: --
2886: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2887: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'START BUILD_FISCAL_LINE_COLUMNS');
2888: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, '-- LINE('||C_sbr_LINE_NUMBER||')' || ' Tresury Symbol('||c_sbr_ts_value ||')' || ' '||TO_CHAR(SYSDATE,'mm/dd/yyyy hh:mi:ss'));
2889: END IF;
2890: --
2891: -- ----------------------------------------

Line 2888: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, '-- LINE('||C_sbr_LINE_NUMBER||')' || ' Tresury Symbol('||c_sbr_ts_value ||')' || ' '||TO_CHAR(SYSDATE,'mm/dd/yyyy hh:mi:ss'));

2884: l_module_name := g_module_name || 'build_fiscal_line_columns';
2885: --
2886: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2887: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'START BUILD_FISCAL_LINE_COLUMNS');
2888: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, '-- LINE('||C_sbr_LINE_NUMBER||')' || ' Tresury Symbol('||c_sbr_ts_value ||')' || ' '||TO_CHAR(SYSDATE,'mm/dd/yyyy hh:mi:ss'));
2889: END IF;
2890: --
2891: -- ----------------------------------------
2892: -- Get Fund Accummulation

Line 2909: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'Before balance_type_cursor :');

2905: CSum_B :=0;
2906: /* Mofified SBR ER Bug 9445574*/
2907: v_col_1_amt:=0;
2908: v_col_2_amt:=0;
2909: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'Before balance_type_cursor :');
2910: -- for the line find all accounts and sum
2911: FOR balance_type_rec IN balance_type_cursor
2912: LOOP
2913: c_sbr_line_acct_id := balance_type_rec.sbr_line_acct_id;

Line 2938: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'in balance_type_cursor :c_acct_number->'||c_acct_number);

2934: /* Initializing for each account amount Bug 9453402*/
2935: c_total_balance := 0;
2936: c_total_balance_bud :=0;
2937: c_total_balance_nbfa :=0;
2938: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'in balance_type_cursor :c_acct_number->'||c_acct_number);
2939:
2940: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'Before gl_period_statuses ');
2941:
2942: SELECT start_date,

Line 2940: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'Before gl_period_statuses ');

2936: c_total_balance_bud :=0;
2937: c_total_balance_nbfa :=0;
2938: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'in balance_type_cursor :c_acct_number->'||c_acct_number);
2939:
2940: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'Before gl_period_statuses ');
2941:
2942: SELECT start_date,
2943: end_date
2944: INTO beg_date,

Line 2960: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'in get_ts_id_rec :get_ts_id_rec.treasury_symbol_id ->'||get_ts_id_rec.treasury_symbol_id);

2956: c_total_balance :=0;
2957: c_total_balance_bud :=0;
2958: c_total_balance_nbfa :=0;
2959:
2960: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'in get_ts_id_rec :get_ts_id_rec.treasury_symbol_id ->'||get_ts_id_rec.treasury_symbol_id);
2961: /*
2962: * If Treasury symbol is defined on SBR Definitions form for an account then amount for that
2963: * Treasury symbol is only considered on report
2964: */

Line 2996: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'Before c_rescission_flag = TRUE ');

2992: ELSE
2993: c_rescission_flag := 'TRUE';
2994: END IF;
2995:
2996: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'Before c_rescission_flag = TRUE ');
2997:
2998: IF c_rescission_flag = 'TRUE' THEN
2999:
3000: /*Avialability type and Treasury symbol */

Line 3003: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'before fv_treasury_symbols');

2999:
3000: /*Avialability type and Treasury symbol */
3001: BEGIN
3002:
3003: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'before fv_treasury_symbols');
3004:
3005: -- Bug 13355766. Modified query to use the new values for Authority Type Code
3006: -- (TIME_FRAME)
3007: --SELECT DECODE(time_frame,'NO_YEAR','X',NULL) ,

Line 3021: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'After fv_treasury_symbols/fv_fund_groups');

3017: AND fts.set_of_books_id = v_sob
3018: AND fts.set_of_books_id = ffg.set_of_books_id
3019: AND ffg.fund_group_code = fts.fund_group_code;
3020:
3021: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'After fv_treasury_symbols/fv_fund_groups');
3022: -- Extract expiration date of treasury symbol and determine if the TS expired
3023: -- or will it expire in the year for which the process is run
3024: IF(exp_date < close_date ) THEN
3025: whether_Exp := 'E';

Line 3042: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'After expiring_year');

3038: FROM fv_treasury_symbols
3039: WHERE treasury_symbol_id=get_ts_id_rec.treasury_symbol_id
3040: AND set_of_books_id=v_sob;
3041:
3042: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'After expiring_year');
3043:
3044: IF (expiring_year IS NOT NULL AND expiring_year = v_period_fiscal_year) THEN
3045: whether_Exp_SameYear := 'Y';
3046: elsif ( expiring_year > v_period_fiscal_year) THEN

Line 3063: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, '.exception','For Treasury symbol '||get_ts_id_rec.treasury_symbol_id||' '||G_ERROR_MESSAGE);

3059: EXCEPTION
3060: WHEN OTHERS THEN
3061: g_error_code := SQLCODE;
3062: g_error_message := SQLERRM;
3063: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, '.exception','For Treasury symbol '||get_ts_id_rec.treasury_symbol_id||' '||G_ERROR_MESSAGE);
3064:
3065: END;
3066: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'After FV_FACTS_FEDERAL_ACCOUNTS');
3067: query_fetch_bal_bud :=NULL;

Line 3066: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'After FV_FACTS_FEDERAL_ACCOUNTS');

3062: g_error_message := SQLERRM;
3063: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, '.exception','For Treasury symbol '||get_ts_id_rec.treasury_symbol_id||' '||G_ERROR_MESSAGE);
3064:
3065: END;
3066: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'After FV_FACTS_FEDERAL_ACCOUNTS');
3067: query_fetch_bal_bud :=NULL;
3068: query_fetch_bal_nbfa :=NULL;
3069: where_clause := ' ';
3070:

Line 3129: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'After FV_FACTS_FEDERAL_ACCOUNTS');

3125: IF (c_financing_account_code IS NOT NULL ) THEN
3126: where_clause := where_clause||' '||'and trim(financing_account_code) = '''||financing_account_treas||''' ';
3127: END IF;
3128:
3129: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'After FV_FACTS_FEDERAL_ACCOUNTS');
3130:
3131:
3132: IF( c_sbr_balance_type = 'B' OR c_sbr_balance_type = 'E') THEN
3133: IF(( c_sbr_line_type_code = 'D' AND c_sbr_natural_bal_type ='D') OR ( c_sbr_line_type_code = 'D2' AND c_sbr_natural_bal_type ='C'))THEN

Line 3163: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,query_fetch_bal_bud);

3159: IF (query_fetch_bal_bud IS NOT NULL) THEN
3160: v_cursor_id := dbms_sql.open_cursor;
3161: query_fetch_bal_bud := query_fetch_bal_bud ||' '|| where_clause||' '||group_by_clause;
3162: -- print query
3163: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,query_fetch_bal_bud);
3164: dbms_sql.parse(v_cursor_id, query_fetch_bal_bud, dbms_sql.v7);
3165: dbms_sql.define_column(v_cursor_id, 1, c_total_balance);
3166: dbms_sql.define_column(v_cursor_id, 2, v_bud_col,1);
3167: dbms_sql.define_column(v_cursor_id, 3, v_nbfa_col,1);

Line 3172: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sbr_balance_type:'||c_sbr_balance_type);

3168: dbms_sql.bind_variable(v_cursor_id,':cv_sbr_line_acct_id',c_sbr_line_acct_id);
3169: dbms_sql.bind_variable(v_cursor_id,':cv_treasury_symbol_id',c_sbr_treasury_symbol_id);
3170: dbms_sql.bind_variable(v_cursor_id,':cv_sbr_line_id',c_sbr_line_id);
3171: --print bind variables
3172: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sbr_balance_type:'||c_sbr_balance_type);
3173: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_treasury_symbol_id:'||c_sbr_treasury_symbol_id);
3174: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_sbr_line_acct_id:'||c_sbr_line_acct_id);
3175: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sbr_line_id:'||c_sbr_line_id);
3176: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);

Line 3173: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_treasury_symbol_id:'||c_sbr_treasury_symbol_id);

3169: dbms_sql.bind_variable(v_cursor_id,':cv_treasury_symbol_id',c_sbr_treasury_symbol_id);
3170: dbms_sql.bind_variable(v_cursor_id,':cv_sbr_line_id',c_sbr_line_id);
3171: --print bind variables
3172: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sbr_balance_type:'||c_sbr_balance_type);
3173: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_treasury_symbol_id:'||c_sbr_treasury_symbol_id);
3174: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_sbr_line_acct_id:'||c_sbr_line_acct_id);
3175: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sbr_line_id:'||c_sbr_line_id);
3176: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
3177: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 3174: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_sbr_line_acct_id:'||c_sbr_line_acct_id);

3170: dbms_sql.bind_variable(v_cursor_id,':cv_sbr_line_id',c_sbr_line_id);
3171: --print bind variables
3172: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sbr_balance_type:'||c_sbr_balance_type);
3173: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_treasury_symbol_id:'||c_sbr_treasury_symbol_id);
3174: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_sbr_line_acct_id:'||c_sbr_line_acct_id);
3175: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sbr_line_id:'||c_sbr_line_id);
3176: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
3177: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3178: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'l_ignore := '||l_ignore);

Line 3175: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sbr_line_id:'||c_sbr_line_id);

3171: --print bind variables
3172: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sbr_balance_type:'||c_sbr_balance_type);
3173: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_treasury_symbol_id:'||c_sbr_treasury_symbol_id);
3174: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_sbr_line_acct_id:'||c_sbr_line_acct_id);
3175: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sbr_line_id:'||c_sbr_line_id);
3176: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
3177: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3178: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'l_ignore := '||l_ignore);
3179: END IF;

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

3173: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_treasury_symbol_id:'||c_sbr_treasury_symbol_id);
3174: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_sbr_line_acct_id:'||c_sbr_line_acct_id);
3175: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sbr_line_id:'||c_sbr_line_id);
3176: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
3177: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3178: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'l_ignore := '||l_ignore);
3179: END IF;
3180: dbms_sql.column_value(v_cursor_id, 1, c_total_balance);
3181: dbms_sql.column_value(v_cursor_id, 2, v_bud_col);

Line 3178: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'l_ignore := '||l_ignore);

3174: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_sbr_line_acct_id:'||c_sbr_line_acct_id);
3175: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sbr_line_id:'||c_sbr_line_id);
3176: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
3177: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3178: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'l_ignore := '||l_ignore);
3179: END IF;
3180: dbms_sql.column_value(v_cursor_id, 1, c_total_balance);
3181: dbms_sql.column_value(v_cursor_id, 2, v_bud_col);
3182: dbms_sql.column_value(v_cursor_id, 3, v_nbfa_col);

Line 3192: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance:'||c_total_balance);

3188: c_total_balance_nbfa:=c_total_balance_nbfa+c_total_balance;
3189: ELSIF UPPER(v_bud_col) ='Y' THEN
3190: c_total_balance_bud :=c_total_balance_bud+c_total_balance;
3191: END IF;
3192: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance:'||c_total_balance);
3193: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance_nbfa:'||c_total_balance_bud);
3194: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance_bud:'||c_total_balance_bud);
3195: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'v_bud_col:'||v_bud_col);
3196: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'v_nbfa_col:'||v_nbfa_col);

Line 3193: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance_nbfa:'||c_total_balance_bud);

3189: ELSIF UPPER(v_bud_col) ='Y' THEN
3190: c_total_balance_bud :=c_total_balance_bud+c_total_balance;
3191: END IF;
3192: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance:'||c_total_balance);
3193: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance_nbfa:'||c_total_balance_bud);
3194: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance_bud:'||c_total_balance_bud);
3195: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'v_bud_col:'||v_bud_col);
3196: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'v_nbfa_col:'||v_nbfa_col);
3197: END IF;

Line 3194: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance_bud:'||c_total_balance_bud);

3190: c_total_balance_bud :=c_total_balance_bud+c_total_balance;
3191: END IF;
3192: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance:'||c_total_balance);
3193: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance_nbfa:'||c_total_balance_bud);
3194: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance_bud:'||c_total_balance_bud);
3195: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'v_bud_col:'||v_bud_col);
3196: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'v_nbfa_col:'||v_nbfa_col);
3197: END IF;
3198:

Line 3195: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'v_bud_col:'||v_bud_col);

3191: END IF;
3192: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance:'||c_total_balance);
3193: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance_nbfa:'||c_total_balance_bud);
3194: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance_bud:'||c_total_balance_bud);
3195: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'v_bud_col:'||v_bud_col);
3196: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'v_nbfa_col:'||v_nbfa_col);
3197: END IF;
3198:
3199: elsif c_sbr_balance_type = 'E-B' THEN -- balance type is end-begin

Line 3196: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'v_nbfa_col:'||v_nbfa_col);

3192: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance:'||c_total_balance);
3193: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance_nbfa:'||c_total_balance_bud);
3194: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance_bud:'||c_total_balance_bud);
3195: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'v_bud_col:'||v_bud_col);
3196: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'v_nbfa_col:'||v_nbfa_col);
3197: END IF;
3198:
3199: elsif c_sbr_balance_type = 'E-B' THEN -- balance type is end-begin
3200: IF(( c_sbr_line_type_code = 'D' AND c_sbr_natural_bal_type ='D') OR ( c_sbr_line_type_code = 'D2' AND c_sbr_natural_bal_type ='C') ) THEN

Line 3224: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,query_fetch_bal_bud);

3220: dbms_sql.bind_variable(v_cursor_id,':cv_sbr_line_acct_id',c_sbr_line_acct_id);
3221: dbms_sql.bind_variable(v_cursor_id,':cv_treasury_symbol_id',c_sbr_treasury_symbol_id);
3222: dbms_sql.bind_variable(v_cursor_id,':cv_sbr_line_id',c_sbr_line_id);
3223: -- print query
3224: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,query_fetch_bal_bud);
3225: --print bind variables
3226: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sbr_balance_type:'||c_sbr_balance_type);
3227: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_treasury_symbol_id:'||c_sbr_treasury_symbol_id);
3228: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_sbr_line_acct_id:'||c_sbr_line_acct_id);

Line 3226: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sbr_balance_type:'||c_sbr_balance_type);

3222: dbms_sql.bind_variable(v_cursor_id,':cv_sbr_line_id',c_sbr_line_id);
3223: -- print query
3224: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,query_fetch_bal_bud);
3225: --print bind variables
3226: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sbr_balance_type:'||c_sbr_balance_type);
3227: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_treasury_symbol_id:'||c_sbr_treasury_symbol_id);
3228: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_sbr_line_acct_id:'||c_sbr_line_acct_id);
3229: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sbr_line_id:'||c_sbr_line_id);
3230: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);

Line 3227: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_treasury_symbol_id:'||c_sbr_treasury_symbol_id);

3223: -- print query
3224: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,query_fetch_bal_bud);
3225: --print bind variables
3226: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sbr_balance_type:'||c_sbr_balance_type);
3227: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_treasury_symbol_id:'||c_sbr_treasury_symbol_id);
3228: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_sbr_line_acct_id:'||c_sbr_line_acct_id);
3229: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sbr_line_id:'||c_sbr_line_id);
3230: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
3231: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 3228: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_sbr_line_acct_id:'||c_sbr_line_acct_id);

3224: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,query_fetch_bal_bud);
3225: --print bind variables
3226: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sbr_balance_type:'||c_sbr_balance_type);
3227: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_treasury_symbol_id:'||c_sbr_treasury_symbol_id);
3228: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_sbr_line_acct_id:'||c_sbr_line_acct_id);
3229: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sbr_line_id:'||c_sbr_line_id);
3230: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
3231: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3232: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'l_ignore := '||l_ignore);

Line 3229: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sbr_line_id:'||c_sbr_line_id);

3225: --print bind variables
3226: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sbr_balance_type:'||c_sbr_balance_type);
3227: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_treasury_symbol_id:'||c_sbr_treasury_symbol_id);
3228: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_sbr_line_acct_id:'||c_sbr_line_acct_id);
3229: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sbr_line_id:'||c_sbr_line_id);
3230: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
3231: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3232: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'l_ignore := '||l_ignore);
3233: END IF;

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

3227: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_treasury_symbol_id:'||c_sbr_treasury_symbol_id);
3228: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_sbr_line_acct_id:'||c_sbr_line_acct_id);
3229: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sbr_line_id:'||c_sbr_line_id);
3230: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
3231: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3232: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'l_ignore := '||l_ignore);
3233: END IF;
3234: dbms_sql.column_value(v_cursor_id, 1, c_total_balance);
3235: dbms_sql.column_value(v_cursor_id, 2, v_bud_col);

Line 3232: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'l_ignore := '||l_ignore);

3228: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_sbr_line_acct_id:'||c_sbr_line_acct_id);
3229: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sbr_line_id:'||c_sbr_line_id);
3230: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
3231: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3232: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'l_ignore := '||l_ignore);
3233: END IF;
3234: dbms_sql.column_value(v_cursor_id, 1, c_total_balance);
3235: dbms_sql.column_value(v_cursor_id, 2, v_bud_col);
3236: dbms_sql.column_value(v_cursor_id, 3, v_nbfa_col);

Line 3245: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance:'||c_total_balance);

3241: c_total_balance_nbfa:=c_total_balance_nbfa+c_total_balance;
3242: ELSIF UPPER(v_bud_col) ='Y' THEN
3243: c_total_balance_bud :=c_total_balance_bud+c_total_balance;
3244: END IF;
3245: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance:'||c_total_balance);
3246: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance_bud:'||c_total_balance_bud);
3247: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance_nbfa:'||c_total_balance_nbfa);
3248: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'v_bud_col:'||v_bud_col);
3249: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'v_nbfa_col:'||v_nbfa_col);

Line 3246: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance_bud:'||c_total_balance_bud);

3242: ELSIF UPPER(v_bud_col) ='Y' THEN
3243: c_total_balance_bud :=c_total_balance_bud+c_total_balance;
3244: END IF;
3245: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance:'||c_total_balance);
3246: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance_bud:'||c_total_balance_bud);
3247: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance_nbfa:'||c_total_balance_nbfa);
3248: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'v_bud_col:'||v_bud_col);
3249: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'v_nbfa_col:'||v_nbfa_col);
3250:

Line 3247: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance_nbfa:'||c_total_balance_nbfa);

3243: c_total_balance_bud :=c_total_balance_bud+c_total_balance;
3244: END IF;
3245: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance:'||c_total_balance);
3246: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance_bud:'||c_total_balance_bud);
3247: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance_nbfa:'||c_total_balance_nbfa);
3248: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'v_bud_col:'||v_bud_col);
3249: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'v_nbfa_col:'||v_nbfa_col);
3250:
3251: elsif (( c_sbr_line_type_code = 'D' AND c_sbr_natural_bal_type ='C') OR ( c_sbr_line_type_code = 'D2' AND c_sbr_natural_bal_type ='D'))THEN

Line 3248: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'v_bud_col:'||v_bud_col);

3244: END IF;
3245: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance:'||c_total_balance);
3246: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance_bud:'||c_total_balance_bud);
3247: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance_nbfa:'||c_total_balance_nbfa);
3248: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'v_bud_col:'||v_bud_col);
3249: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'v_nbfa_col:'||v_nbfa_col);
3250:
3251: elsif (( c_sbr_line_type_code = 'D' AND c_sbr_natural_bal_type ='C') OR ( c_sbr_line_type_code = 'D2' AND c_sbr_natural_bal_type ='D'))THEN
3252: /*FOR BUD_COL*/

Line 3249: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'v_nbfa_col:'||v_nbfa_col);

3245: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance:'||c_total_balance);
3246: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance_bud:'||c_total_balance_bud);
3247: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance_nbfa:'||c_total_balance_nbfa);
3248: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'v_bud_col:'||v_bud_col);
3249: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'v_nbfa_col:'||v_nbfa_col);
3250:
3251: elsif (( c_sbr_line_type_code = 'D' AND c_sbr_natural_bal_type ='C') OR ( c_sbr_line_type_code = 'D2' AND c_sbr_natural_bal_type ='D'))THEN
3252: /*FOR BUD_COL*/
3253: query_fetch_bal_bud := ' select

Line 3274: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,query_fetch_bal_bud);

3270: dbms_sql.bind_variable(v_cursor_id,':cv_sbr_line_acct_id',c_sbr_line_acct_id);
3271: dbms_sql.bind_variable(v_cursor_id,':cv_treasury_symbol_id',c_sbr_treasury_symbol_id);
3272: dbms_sql.bind_variable(v_cursor_id,':cv_sbr_line_id',c_sbr_line_id);
3273: -- print query
3274: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,query_fetch_bal_bud);
3275: --print bind variables
3276: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sbr_balance_type:'||c_sbr_balance_type);
3277: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_treasury_symbol_id:'||c_sbr_treasury_symbol_id);
3278: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_sbr_line_acct_id:'||c_sbr_line_acct_id);

Line 3276: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sbr_balance_type:'||c_sbr_balance_type);

3272: dbms_sql.bind_variable(v_cursor_id,':cv_sbr_line_id',c_sbr_line_id);
3273: -- print query
3274: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,query_fetch_bal_bud);
3275: --print bind variables
3276: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sbr_balance_type:'||c_sbr_balance_type);
3277: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_treasury_symbol_id:'||c_sbr_treasury_symbol_id);
3278: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_sbr_line_acct_id:'||c_sbr_line_acct_id);
3279: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sbr_line_id:'||c_sbr_line_id);
3280: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);

Line 3277: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_treasury_symbol_id:'||c_sbr_treasury_symbol_id);

3273: -- print query
3274: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,query_fetch_bal_bud);
3275: --print bind variables
3276: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sbr_balance_type:'||c_sbr_balance_type);
3277: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_treasury_symbol_id:'||c_sbr_treasury_symbol_id);
3278: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_sbr_line_acct_id:'||c_sbr_line_acct_id);
3279: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sbr_line_id:'||c_sbr_line_id);
3280: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
3281: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 3278: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_sbr_line_acct_id:'||c_sbr_line_acct_id);

3274: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,query_fetch_bal_bud);
3275: --print bind variables
3276: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sbr_balance_type:'||c_sbr_balance_type);
3277: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_treasury_symbol_id:'||c_sbr_treasury_symbol_id);
3278: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_sbr_line_acct_id:'||c_sbr_line_acct_id);
3279: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sbr_line_id:'||c_sbr_line_id);
3280: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
3281: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3282: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'l_ignore := '||l_ignore);

Line 3279: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sbr_line_id:'||c_sbr_line_id);

3275: --print bind variables
3276: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sbr_balance_type:'||c_sbr_balance_type);
3277: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_treasury_symbol_id:'||c_sbr_treasury_symbol_id);
3278: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_sbr_line_acct_id:'||c_sbr_line_acct_id);
3279: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sbr_line_id:'||c_sbr_line_id);
3280: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
3281: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3282: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'l_ignore := '||l_ignore);
3283: END IF;

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

3277: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_treasury_symbol_id:'||c_sbr_treasury_symbol_id);
3278: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_sbr_line_acct_id:'||c_sbr_line_acct_id);
3279: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sbr_line_id:'||c_sbr_line_id);
3280: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
3281: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3282: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'l_ignore := '||l_ignore);
3283: END IF;
3284: dbms_sql.column_value(v_cursor_id, 1, c_total_balance);
3285: dbms_sql.column_value(v_cursor_id, 2, v_bud_col);

Line 3282: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'l_ignore := '||l_ignore);

3278: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_sbr_line_acct_id:'||c_sbr_line_acct_id);
3279: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sbr_line_id:'||c_sbr_line_id);
3280: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
3281: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3282: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'l_ignore := '||l_ignore);
3283: END IF;
3284: dbms_sql.column_value(v_cursor_id, 1, c_total_balance);
3285: dbms_sql.column_value(v_cursor_id, 2, v_bud_col);
3286: dbms_sql.column_value(v_cursor_id, 3, v_nbfa_col);

Line 3295: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance:'||c_total_balance);

3291: c_total_balance_nbfa:=c_total_balance_nbfa+c_total_balance;
3292: ELSIF UPPER(v_bud_col) ='Y' THEN
3293: c_total_balance_bud :=c_total_balance_bud+c_total_balance;
3294: END IF;
3295: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance:'||c_total_balance);
3296: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance_nbfa:'||c_total_balance_nbfa);
3297: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance_bud:'||c_total_balance_bud);
3298: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'v_bud_col:'||v_bud_col);
3299: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'v_nbfa_col:'||v_nbfa_col);

Line 3296: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance_nbfa:'||c_total_balance_nbfa);

3292: ELSIF UPPER(v_bud_col) ='Y' THEN
3293: c_total_balance_bud :=c_total_balance_bud+c_total_balance;
3294: END IF;
3295: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance:'||c_total_balance);
3296: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance_nbfa:'||c_total_balance_nbfa);
3297: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance_bud:'||c_total_balance_bud);
3298: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'v_bud_col:'||v_bud_col);
3299: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'v_nbfa_col:'||v_nbfa_col);
3300:

Line 3297: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance_bud:'||c_total_balance_bud);

3293: c_total_balance_bud :=c_total_balance_bud+c_total_balance;
3294: END IF;
3295: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance:'||c_total_balance);
3296: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance_nbfa:'||c_total_balance_nbfa);
3297: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance_bud:'||c_total_balance_bud);
3298: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'v_bud_col:'||v_bud_col);
3299: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'v_nbfa_col:'||v_nbfa_col);
3300:
3301: elsif (( c_sbr_balance_type= 'ED') OR( c_sbr_balance_type= 'EC')) THEN -- bal type is ending debit or ending credit only

Line 3298: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'v_bud_col:'||v_bud_col);

3294: END IF;
3295: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance:'||c_total_balance);
3296: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance_nbfa:'||c_total_balance_nbfa);
3297: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance_bud:'||c_total_balance_bud);
3298: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'v_bud_col:'||v_bud_col);
3299: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'v_nbfa_col:'||v_nbfa_col);
3300:
3301: elsif (( c_sbr_balance_type= 'ED') OR( c_sbr_balance_type= 'EC')) THEN -- bal type is ending debit or ending credit only
3302: /*FOR BUD COL */

Line 3299: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'v_nbfa_col:'||v_nbfa_col);

3295: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance:'||c_total_balance);
3296: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance_nbfa:'||c_total_balance_nbfa);
3297: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance_bud:'||c_total_balance_bud);
3298: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'v_bud_col:'||v_bud_col);
3299: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'v_nbfa_col:'||v_nbfa_col);
3300:
3301: elsif (( c_sbr_balance_type= 'ED') OR( c_sbr_balance_type= 'EC')) THEN -- bal type is ending debit or ending credit only
3302: /*FOR BUD COL */
3303: query_fetch_bal_bud := 'select sum(nvl(amount,0)),acct.bud_col,acct.nbfa_col

Line 3325: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,query_fetch_bal_bud);

3321: dbms_sql.bind_variable(v_cursor_id,':cv_sbr_line_acct_id',c_sbr_line_acct_id);
3322: dbms_sql.bind_variable(v_cursor_id,':cv_treasury_symbol_id',c_sbr_treasury_symbol_id);
3323: dbms_sql.bind_variable(v_cursor_id,':cv_sbr_line_id',c_sbr_line_id);
3324: -- print query
3325: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,query_fetch_bal_bud);
3326: --print bind variables
3327: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sbr_balance_type:'||c_sbr_balance_type);
3328: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'parm_tsymbol_id:'||c_sbr_treasury_symbol_id);
3329: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_sbr_line_acct_id:'||c_sbr_line_acct_id);

Line 3327: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sbr_balance_type:'||c_sbr_balance_type);

3323: dbms_sql.bind_variable(v_cursor_id,':cv_sbr_line_id',c_sbr_line_id);
3324: -- print query
3325: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,query_fetch_bal_bud);
3326: --print bind variables
3327: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sbr_balance_type:'||c_sbr_balance_type);
3328: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'parm_tsymbol_id:'||c_sbr_treasury_symbol_id);
3329: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_sbr_line_acct_id:'||c_sbr_line_acct_id);
3330: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sbr_line_id:'||c_sbr_line_id);
3331: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);

Line 3328: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'parm_tsymbol_id:'||c_sbr_treasury_symbol_id);

3324: -- print query
3325: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,query_fetch_bal_bud);
3326: --print bind variables
3327: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sbr_balance_type:'||c_sbr_balance_type);
3328: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'parm_tsymbol_id:'||c_sbr_treasury_symbol_id);
3329: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_sbr_line_acct_id:'||c_sbr_line_acct_id);
3330: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sbr_line_id:'||c_sbr_line_id);
3331: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
3332: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 3329: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_sbr_line_acct_id:'||c_sbr_line_acct_id);

3325: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,query_fetch_bal_bud);
3326: --print bind variables
3327: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sbr_balance_type:'||c_sbr_balance_type);
3328: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'parm_tsymbol_id:'||c_sbr_treasury_symbol_id);
3329: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_sbr_line_acct_id:'||c_sbr_line_acct_id);
3330: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sbr_line_id:'||c_sbr_line_id);
3331: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
3332: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3333: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'l_ignore := '||l_ignore);

Line 3330: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sbr_line_id:'||c_sbr_line_id);

3326: --print bind variables
3327: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sbr_balance_type:'||c_sbr_balance_type);
3328: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'parm_tsymbol_id:'||c_sbr_treasury_symbol_id);
3329: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_sbr_line_acct_id:'||c_sbr_line_acct_id);
3330: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sbr_line_id:'||c_sbr_line_id);
3331: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
3332: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3333: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'l_ignore := '||l_ignore);
3334: END IF;

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

3328: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'parm_tsymbol_id:'||c_sbr_treasury_symbol_id);
3329: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_sbr_line_acct_id:'||c_sbr_line_acct_id);
3330: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sbr_line_id:'||c_sbr_line_id);
3331: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
3332: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3333: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'l_ignore := '||l_ignore);
3334: END IF;
3335: dbms_sql.column_value(v_cursor_id, 1, c_total_balance);
3336: dbms_sql.column_value(v_cursor_id, 2, v_bud_col);

Line 3333: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'l_ignore := '||l_ignore);

3329: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_sbr_line_acct_id:'||c_sbr_line_acct_id);
3330: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sbr_line_id:'||c_sbr_line_id);
3331: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
3332: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3333: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'l_ignore := '||l_ignore);
3334: END IF;
3335: dbms_sql.column_value(v_cursor_id, 1, c_total_balance);
3336: dbms_sql.column_value(v_cursor_id, 2, v_bud_col);
3337: dbms_sql.column_value(v_cursor_id, 3, v_nbfa_col);

Line 3361: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance:'||c_total_balance);

3357: c_total_balance_nbfa:=c_total_balance_nbfa+c_total_balance;
3358: ELSIF UPPER(v_bud_col) ='Y' THEN
3359: c_total_balance_bud :=c_total_balance_nbfa+c_total_balance;
3360: END IF;
3361: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance:'||c_total_balance);
3362: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance_bud:'||c_total_balance_bud);
3363: fV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance_nbfa:'||c_total_balance_nbfa);
3364: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'v_bud_col:'||v_bud_col);
3365: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'v_nbfa_col:'||v_nbfa_col);

Line 3362: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance_bud:'||c_total_balance_bud);

3358: ELSIF UPPER(v_bud_col) ='Y' THEN
3359: c_total_balance_bud :=c_total_balance_nbfa+c_total_balance;
3360: END IF;
3361: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance:'||c_total_balance);
3362: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance_bud:'||c_total_balance_bud);
3363: fV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance_nbfa:'||c_total_balance_nbfa);
3364: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'v_bud_col:'||v_bud_col);
3365: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'v_nbfa_col:'||v_nbfa_col);
3366: END IF;

Line 3363: fV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance_nbfa:'||c_total_balance_nbfa);

3359: c_total_balance_bud :=c_total_balance_nbfa+c_total_balance;
3360: END IF;
3361: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance:'||c_total_balance);
3362: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance_bud:'||c_total_balance_bud);
3363: fV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance_nbfa:'||c_total_balance_nbfa);
3364: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'v_bud_col:'||v_bud_col);
3365: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'v_nbfa_col:'||v_nbfa_col);
3366: END IF;
3367:

Line 3364: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'v_bud_col:'||v_bud_col);

3360: END IF;
3361: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance:'||c_total_balance);
3362: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance_bud:'||c_total_balance_bud);
3363: fV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance_nbfa:'||c_total_balance_nbfa);
3364: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'v_bud_col:'||v_bud_col);
3365: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'v_nbfa_col:'||v_nbfa_col);
3366: END IF;
3367:
3368: elsif( (c_sbr_balance_type= 'E-BD') OR (c_sbr_balance_type='E-BC')) THEN -- bal type is end begin debit only

Line 3365: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'v_nbfa_col:'||v_nbfa_col);

3361: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance:'||c_total_balance);
3362: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance_bud:'||c_total_balance_bud);
3363: fV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance_nbfa:'||c_total_balance_nbfa);
3364: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'v_bud_col:'||v_bud_col);
3365: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'v_nbfa_col:'||v_nbfa_col);
3366: END IF;
3367:
3368: elsif( (c_sbr_balance_type= 'E-BD') OR (c_sbr_balance_type='E-BC')) THEN -- bal type is end begin debit only
3369: /*FOR BUD_COL*/

Line 3391: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,query_fetch_bal_bud);

3387: dbms_sql.bind_variable(v_cursor_id,':cv_sbr_line_acct_id',c_sbr_line_acct_id);
3388: dbms_sql.bind_variable(v_cursor_id,':cv_treasury_symbol_id',c_sbr_treasury_symbol_id);
3389: dbms_sql.bind_variable(v_cursor_id,':cv_sbr_line_id',c_sbr_line_id);
3390: -- print query
3391: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,query_fetch_bal_bud);
3392: --print bind variables
3393: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sbr_balance_type:'||c_sbr_balance_type);
3394: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_treasury_symbol_id:'||c_sbr_treasury_symbol_id);
3395: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_sbr_line_acct_id:'||c_sbr_line_acct_id);

Line 3393: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sbr_balance_type:'||c_sbr_balance_type);

3389: dbms_sql.bind_variable(v_cursor_id,':cv_sbr_line_id',c_sbr_line_id);
3390: -- print query
3391: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,query_fetch_bal_bud);
3392: --print bind variables
3393: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sbr_balance_type:'||c_sbr_balance_type);
3394: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_treasury_symbol_id:'||c_sbr_treasury_symbol_id);
3395: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_sbr_line_acct_id:'||c_sbr_line_acct_id);
3396: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sbr_line_id:'||c_sbr_line_id);
3397: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);

Line 3394: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_treasury_symbol_id:'||c_sbr_treasury_symbol_id);

3390: -- print query
3391: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,query_fetch_bal_bud);
3392: --print bind variables
3393: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sbr_balance_type:'||c_sbr_balance_type);
3394: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_treasury_symbol_id:'||c_sbr_treasury_symbol_id);
3395: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_sbr_line_acct_id:'||c_sbr_line_acct_id);
3396: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sbr_line_id:'||c_sbr_line_id);
3397: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
3398:

Line 3395: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_sbr_line_acct_id:'||c_sbr_line_acct_id);

3391: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,query_fetch_bal_bud);
3392: --print bind variables
3393: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sbr_balance_type:'||c_sbr_balance_type);
3394: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_treasury_symbol_id:'||c_sbr_treasury_symbol_id);
3395: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_sbr_line_acct_id:'||c_sbr_line_acct_id);
3396: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sbr_line_id:'||c_sbr_line_id);
3397: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
3398:
3399:

Line 3396: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sbr_line_id:'||c_sbr_line_id);

3392: --print bind variables
3393: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sbr_balance_type:'||c_sbr_balance_type);
3394: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_treasury_symbol_id:'||c_sbr_treasury_symbol_id);
3395: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_sbr_line_acct_id:'||c_sbr_line_acct_id);
3396: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sbr_line_id:'||c_sbr_line_id);
3397: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
3398:
3399:
3400: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

3396: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sbr_line_id:'||c_sbr_line_id);
3397: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
3398:
3399:
3400: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3401: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'l_ignore := '||l_ignore);
3402: END IF;
3403: dbms_sql.column_value(v_cursor_id, 1, c_total_balance);
3404: dbms_sql.column_value(v_cursor_id, 2, v_bud_col);

Line 3401: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'l_ignore := '||l_ignore);

3397: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
3398:
3399:
3400: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3401: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'l_ignore := '||l_ignore);
3402: END IF;
3403: dbms_sql.column_value(v_cursor_id, 1, c_total_balance);
3404: dbms_sql.column_value(v_cursor_id, 2, v_bud_col);
3405: dbms_sql.column_value(v_cursor_id, 3, v_nbfa_col);

Line 3440: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance:'||c_total_balance);

3436: c_total_balance_nbfa:=c_total_balance_nbfa + c_total_balance;
3437: ELSIF UPPER(v_bud_col) ='Y' THEN
3438: c_total_balance_bud :=c_total_balance_bud + c_total_balance;
3439: END IF;
3440: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance:'||c_total_balance);
3441: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance_nbfa:'||c_total_balance_nbfa);
3442: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance_bud:'||c_total_balance_bud);
3443: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'v_bud_col:'||v_bud_col);
3444: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'v_nbfa_col:'||v_nbfa_col);

Line 3441: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance_nbfa:'||c_total_balance_nbfa);

3437: ELSIF UPPER(v_bud_col) ='Y' THEN
3438: c_total_balance_bud :=c_total_balance_bud + c_total_balance;
3439: END IF;
3440: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance:'||c_total_balance);
3441: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance_nbfa:'||c_total_balance_nbfa);
3442: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance_bud:'||c_total_balance_bud);
3443: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'v_bud_col:'||v_bud_col);
3444: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'v_nbfa_col:'||v_nbfa_col);
3445: END IF;

Line 3442: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance_bud:'||c_total_balance_bud);

3438: c_total_balance_bud :=c_total_balance_bud + c_total_balance;
3439: END IF;
3440: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance:'||c_total_balance);
3441: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance_nbfa:'||c_total_balance_nbfa);
3442: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance_bud:'||c_total_balance_bud);
3443: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'v_bud_col:'||v_bud_col);
3444: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'v_nbfa_col:'||v_nbfa_col);
3445: END IF;
3446:

Line 3443: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'v_bud_col:'||v_bud_col);

3439: END IF;
3440: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance:'||c_total_balance);
3441: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance_nbfa:'||c_total_balance_nbfa);
3442: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance_bud:'||c_total_balance_bud);
3443: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'v_bud_col:'||v_bud_col);
3444: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'v_nbfa_col:'||v_nbfa_col);
3445: END IF;
3446:
3447: END IF;

Line 3444: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'v_nbfa_col:'||v_nbfa_col);

3440: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance:'||c_total_balance);
3441: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance_nbfa:'||c_total_balance_nbfa);
3442: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance_bud:'||c_total_balance_bud);
3443: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'v_bud_col:'||v_bud_col);
3444: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'v_nbfa_col:'||v_nbfa_col);
3445: END IF;
3446:
3447: END IF;
3448: END IF; -- end checking for balance types

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

3453: END IF;
3454: IF (c_total_balance_nbfa IS NULL) THEN
3455: c_total_balance_nbfa :=0;
3456: END IF;
3457: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3458: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance_bud = '||c_total_balance_bud);
3459: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance_nbfa = '||c_total_balance_nbfa);
3460: END IF;
3461:

Line 3458: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance_bud = '||c_total_balance_bud);

3454: IF (c_total_balance_nbfa IS NULL) THEN
3455: c_total_balance_nbfa :=0;
3456: END IF;
3457: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3458: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance_bud = '||c_total_balance_bud);
3459: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance_nbfa = '||c_total_balance_nbfa);
3460: END IF;
3461:
3462: end if;

Line 3459: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance_nbfa = '||c_total_balance_nbfa);

3455: c_total_balance_nbfa :=0;
3456: END IF;
3457: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3458: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance_bud = '||c_total_balance_bud);
3459: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance_nbfa = '||c_total_balance_nbfa);
3460: END IF;
3461:
3462: end if;
3463: -- Added for SBR ER bug 9439646

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

3462: end if;
3463: -- Added for SBR ER bug 9439646
3464: v_col_1_amt := v_col_1_amt + c_total_balance_bud;
3465: v_col_2_amt := v_col_2_amt + c_total_balance_nbfa;
3466: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3467: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'v_col_1_amt ='||v_col_1_amt);
3468: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'v_col_2_amt ='||v_col_2_amt);
3469: END IF;
3470:

Line 3467: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'v_col_1_amt ='||v_col_1_amt);

3463: -- Added for SBR ER bug 9439646
3464: v_col_1_amt := v_col_1_amt + c_total_balance_bud;
3465: v_col_2_amt := v_col_2_amt + c_total_balance_nbfa;
3466: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3467: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'v_col_1_amt ='||v_col_1_amt);
3468: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'v_col_2_amt ='||v_col_2_amt);
3469: END IF;
3470:
3471:

Line 3468: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'v_col_2_amt ='||v_col_2_amt);

3464: v_col_1_amt := v_col_1_amt + c_total_balance_bud;
3465: v_col_2_amt := v_col_2_amt + c_total_balance_nbfa;
3466: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3467: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'v_col_1_amt ='||v_col_1_amt);
3468: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'v_col_2_amt ='||v_col_2_amt);
3469: END IF;
3470:
3471:
3472: END LOOP;

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

3474: END LOOP;
3475: --
3476: -- set up correct display sign
3477: --
3478: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3479: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'NATURAL BAL TYPE = '||C_sbr_NATURAL_BAL_TYPE);
3480: END IF;
3481:
3482: /*

Line 3479: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'NATURAL BAL TYPE = '||C_sbr_NATURAL_BAL_TYPE);

3475: --
3476: -- set up correct display sign
3477: --
3478: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3479: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'NATURAL BAL TYPE = '||C_sbr_NATURAL_BAL_TYPE);
3480: END IF;
3481:
3482: /*
3483: Commented for SBR ER bug 9439646

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

3482: /*
3483: Commented for SBR ER bug 9439646
3484: v_col_1_amt := c_total_balance_bud;
3485: v_col_2_amt := c_total_balance_nbfa;
3486: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3487: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'v_col_1_amt ='||v_col_1_amt);
3488: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'v_col_2_amt ='||v_col_2_amt);
3489: END IF;*/
3490:

Line 3487: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'v_col_1_amt ='||v_col_1_amt);

3483: Commented for SBR ER bug 9439646
3484: v_col_1_amt := c_total_balance_bud;
3485: v_col_2_amt := c_total_balance_nbfa;
3486: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3487: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'v_col_1_amt ='||v_col_1_amt);
3488: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'v_col_2_amt ='||v_col_2_amt);
3489: END IF;*/
3490:
3491: v_col_3_amt:=0;

Line 3488: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'v_col_2_amt ='||v_col_2_amt);

3484: v_col_1_amt := c_total_balance_bud;
3485: v_col_2_amt := c_total_balance_nbfa;
3486: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3487: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'v_col_1_amt ='||v_col_1_amt);
3488: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'v_col_2_amt ='||v_col_2_amt);
3489: END IF;*/
3490:
3491: v_col_3_amt:=0;
3492: v_col_4_amt:=0;

Line 3508: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.exception','BUILD_FISCAL_LINE_COLUMNS:Either fv_cfs_rep_temp table does not have data or some unknown error');

3504: EXCEPTION
3505: WHEN OTHERS THEN
3506: --g_error_code := SQLCODE;
3507: g_error_message := SQLERRM;
3508: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.exception','BUILD_FISCAL_LINE_COLUMNS:Either fv_cfs_rep_temp table does not have data or some unknown error');
3509: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.exception',G_ERROR_MESSAGE);
3510: END;
3511:
3512: populate_temp_table;

Line 3509: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.exception',G_ERROR_MESSAGE);

3505: WHEN OTHERS THEN
3506: --g_error_code := SQLCODE;
3507: g_error_message := SQLERRM;
3508: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.exception','BUILD_FISCAL_LINE_COLUMNS:Either fv_cfs_rep_temp table does not have data or some unknown error');
3509: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.exception',G_ERROR_MESSAGE);
3510: END;
3511:
3512: populate_temp_table;
3513:

Line 3531: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.exception','BUILD_FISCAL_LINE_COLUMNS:'||G_ERROR_MESSAGE);

3527: CLOSE balance_type_cursor;
3528: ELSIF dbms_sql.is_open(v_cursor_id) THEN
3529: dbms_sql.close_cursor(v_cursor_id);
3530: END IF;
3531: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.exception','BUILD_FISCAL_LINE_COLUMNS:'||G_ERROR_MESSAGE);
3532: --
3533: END build_fiscal_line_columns;
3534:
3535: PROCEDURE purge_csf_temp_table

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

3539: --
3540: BEGIN
3541: l_module_name := g_module_name || 'purge_csf_temp_table';
3542: --
3543: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3544: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'START PURGE_TEMP_TABLE');
3545: END IF;
3546: --
3547:

Line 3544: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'START PURGE_TEMP_TABLE');

3540: BEGIN
3541: l_module_name := g_module_name || 'purge_csf_temp_table';
3542: --
3543: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3544: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'START PURGE_TEMP_TABLE');
3545: END IF;
3546: --
3547:
3548: DELETE

Line 3570: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.exception',g_error_message);

3566: --
3567: WHEN OTHERS THEN
3568: g_error_code := SQLCODE;
3569: g_error_message := 'purge_temp_table/'||SQLERRM;
3570: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.exception',g_error_message);
3571: --
3572: END purge_csf_temp_table;
3573:
3574:

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

3727: EXCEPTION
3728: WHEN OTHERS THEN
3729: v_retcode := SQLCODE ;
3730: v_errbuf := SQLERRM || ' [build_sbr_dynamic_query] ' ;
3731: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',v_errbuf);
3732: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception','Stage it errors ' || l_stage);
3733: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',l_out);
3734: RETURN;
3735: END build_sbr_dynamic_query;

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

3728: WHEN OTHERS THEN
3729: v_retcode := SQLCODE ;
3730: v_errbuf := SQLERRM || ' [build_sbr_dynamic_query] ' ;
3731: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',v_errbuf);
3732: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception','Stage it errors ' || l_stage);
3733: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',l_out);
3734: RETURN;
3735: END build_sbr_dynamic_query;
3736:

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

3729: v_retcode := SQLCODE ;
3730: v_errbuf := SQLERRM || ' [build_sbr_dynamic_query] ' ;
3731: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',v_errbuf);
3732: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception','Stage it errors ' || l_stage);
3733: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',l_out);
3734: RETURN;
3735: END build_sbr_dynamic_query;
3736:
3737: PROCEDURE get_sbr_py_bal_details(p_fiscal_year NUMBER)

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

3807: v_col_2_amt:=0;
3808: END IF;
3809:
3810: l_log_mesg := '***** Line Number' || v_line_number || ': ' || '*****';
3811: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,l_log_mesg);
3812: FOR detail_rec IN fv_sbr_detail_cur
3813: LOOP ---- L1
3814: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, '########');
3815: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Account Num: '||detail_rec.acct_number);

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

3810: l_log_mesg := '***** Line Number' || v_line_number || ': ' || '*****';
3811: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,l_log_mesg);
3812: FOR detail_rec IN fv_sbr_detail_cur
3813: LOOP ---- L1
3814: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, '########');
3815: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Account Num: '||detail_rec.acct_number);
3816: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'line id: '||v_line_id);
3817: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'line detail id: '||detail_rec.sbr_line_acct_id);
3818: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'balance type: '||detail_rec.sbr_balance_type);

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

3811: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,l_log_mesg);
3812: FOR detail_rec IN fv_sbr_detail_cur
3813: LOOP ---- L1
3814: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, '########');
3815: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Account Num: '||detail_rec.acct_number);
3816: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'line id: '||v_line_id);
3817: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'line detail id: '||detail_rec.sbr_line_acct_id);
3818: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'balance type: '||detail_rec.sbr_balance_type);
3819:

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

3812: FOR detail_rec IN fv_sbr_detail_cur
3813: LOOP ---- L1
3814: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, '########');
3815: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Account Num: '||detail_rec.acct_number);
3816: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'line id: '||v_line_id);
3817: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'line detail id: '||detail_rec.sbr_line_acct_id);
3818: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'balance type: '||detail_rec.sbr_balance_type);
3819:
3820: v_balance_type := detail_rec.sbr_balance_type;

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

3813: LOOP ---- L1
3814: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, '########');
3815: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Account Num: '||detail_rec.acct_number);
3816: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'line id: '||v_line_id);
3817: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'line detail id: '||detail_rec.sbr_line_acct_id);
3818: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'balance type: '||detail_rec.sbr_balance_type);
3819:
3820: v_balance_type := detail_rec.sbr_balance_type;
3821: l_balance_determined := 0;

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

3814: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, '########');
3815: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Account Num: '||detail_rec.acct_number);
3816: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'line id: '||v_line_id);
3817: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'line detail id: '||detail_rec.sbr_line_acct_id);
3818: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'balance type: '||detail_rec.sbr_balance_type);
3819:
3820: v_balance_type := detail_rec.sbr_balance_type;
3821: l_balance_determined := 0;
3822: l_prev_year_gl_balance := 0;

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

3849: NULL;
3850: END;
3851: END;
3852: END IF;
3853: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Account Type: '||l_account_type);
3854: -- ===================================================================
3855: v_py_gl_beg_bal := 0;
3856: v_py_gl_end_bal := 0;
3857: v_cy_gl_beg_bal := 0;

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

3865: dbms_sql.bind_variable(v_glbal_curid,':cv_balance_type','B');
3866: --dbms_sql.bind_variable(v_glbal_curid,':cv_end_date', v_begin_period_1_end_date);
3867: l_ignore := dbms_sql.execute_and_fetch(v_glbal_curid);
3868: dbms_sql.column_value(v_glbal_curid, 1, v_py_gl_beg_bal);
3869: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Prior year begin gl bal: '||v_py_gl_beg_bal);
3870: */
3871: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_report_type: '||v_report_type);
3872: IF UPPER(v_report_type) = 'SBR' THEN
3873: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'IN SIDE IF : ');

Line 3871: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_report_type: '||v_report_type);

3867: l_ignore := dbms_sql.execute_and_fetch(v_glbal_curid);
3868: dbms_sql.column_value(v_glbal_curid, 1, v_py_gl_beg_bal);
3869: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Prior year begin gl bal: '||v_py_gl_beg_bal);
3870: */
3871: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_report_type: '||v_report_type);
3872: IF UPPER(v_report_type) = 'SBR' THEN
3873: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'IN SIDE IF : ');
3874: v_cy_sbr_beg_bal := 0;
3875: v_cy_sbr_end_bal := 0;

Line 3873: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'IN SIDE IF : ');

3869: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Prior year begin gl bal: '||v_py_gl_beg_bal);
3870: */
3871: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_report_type: '||v_report_type);
3872: IF UPPER(v_report_type) = 'SBR' THEN
3873: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'IN SIDE IF : ');
3874: v_cy_sbr_beg_bal := 0;
3875: v_cy_sbr_end_bal := 0;
3876: v_py_sbr_beg_bal := 0;
3877: v_py_sbr_end_bal := 0;

Line 3878: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'bEFORE IF detail_rec.sbr_balance_type:detail_rec.acct_number-> '||detail_rec.sbr_balance_type||'::'||detail_rec.acct_number);

3874: v_cy_sbr_beg_bal := 0;
3875: v_cy_sbr_end_bal := 0;
3876: v_py_sbr_beg_bal := 0;
3877: v_py_sbr_end_bal := 0;
3878: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'bEFORE IF detail_rec.sbr_balance_type:detail_rec.acct_number-> '||detail_rec.sbr_balance_type||'::'||detail_rec.acct_number);
3879: dbms_sql.bind_variable(v_sbr_curid,':cv_line_id',v_line_id);
3880: dbms_sql.bind_variable(v_sbr_curid,':cv_line_detail_id',detail_rec.sbr_line_acct_id);
3881: --dbms_sql.bind_variable(v_sbr_curid,':cv_account_number',detail_rec.acct_number);
3882: dbms_sql.bind_variable(v_sbr_curid,':cv_acc_num',detail_rec.acct_number||'%');

Line 3890: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'inside IF detail_rec.sbr_balance_type: '||detail_rec.sbr_balance_type);

3886: ---------------------------------
3887:
3888: IF detail_rec.sbr_balance_type = 'B' THEN
3889: -- If balance type is begin
3890: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'inside IF detail_rec.sbr_balance_type: '||detail_rec.sbr_balance_type);
3891: dbms_sql.define_column(v_sbr_curid, 1, v_py_sbr_beg_bal);
3892: dbms_sql.bind_variable(v_sbr_curid,':cv_balance_type','B');
3893: dbms_sql.bind_variable(v_sbr_curid,':cv_period_num',v_begin_period_1);
3894:

Line 3898: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_sbr_curid : ');

3894:
3895:
3896: ---dbms_sql.bind_variable(v_sbr_curid,':cv_end_date', v_begin_period_1_end_date);
3897: dbms_sql.bind_variable(v_sbr_curid,':cv_period_fiscal_year',p_fiscal_year-1);
3898: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_sbr_curid : ');
3899: l_ignore := dbms_sql.execute_and_fetch(v_sbr_curid);
3900:
3901: dbms_sql.column_value(v_sbr_curid, 1, v_py_sbr_beg_bal);
3902: v_amount := v_py_sbr_beg_bal;

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

3899: l_ignore := dbms_sql.execute_and_fetch(v_sbr_curid);
3900:
3901: dbms_sql.column_value(v_sbr_curid, 1, v_py_sbr_beg_bal);
3902: v_amount := v_py_sbr_beg_bal;
3903: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Prior year begin bal: '||v_amount);
3904: -- IF balance type is ending, ending cr only or ending dr only
3905: ELSIF detail_rec.sbr_balance_type IN ('C', 'D','E','G','I','J') THEN
3906: -- Get the begin balance
3907: dbms_sql.define_column(v_sbr_curid, 1, v_py_sbr_beg_bal);

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

3920: dbms_sql.bind_variable(v_sbr_curid,':cv_period_fiscal_year',p_fiscal_year-1);
3921: l_ignore := dbms_sql.execute_and_fetch(v_sbr_curid);
3922: dbms_sql.column_value(v_sbr_curid, 1, v_py_sbr_end_bal);
3923:
3924: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Prior year end bal: '||v_py_sbr_end_bal);
3925: v_amount := get_bal_type_amt(detail_rec.sbr_balance_type, v_natural_balance_type, NVL(v_py_sbr_beg_bal,0), NVL(v_py_sbr_end_bal,0));
3926: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_amount: '||v_amount);
3927: END IF;
3928: l_log_mesg := ', ' || NVL(v_amount, 0);

Line 3926: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_amount: '||v_amount);

3922: dbms_sql.column_value(v_sbr_curid, 1, v_py_sbr_end_bal);
3923:
3924: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'Prior year end bal: '||v_py_sbr_end_bal);
3925: v_amount := get_bal_type_amt(detail_rec.sbr_balance_type, v_natural_balance_type, NVL(v_py_sbr_beg_bal,0), NVL(v_py_sbr_end_bal,0));
3926: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_amount: '||v_amount);
3927: END IF;
3928: l_log_mesg := ', ' || NVL(v_amount, 0);
3929: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'detail_rec.bud_col: '||detail_rec.bud_col);
3930: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'detail_rec.nbfa_col: '||detail_rec.nbfa_col);

Line 3929: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'detail_rec.bud_col: '||detail_rec.bud_col);

3925: v_amount := get_bal_type_amt(detail_rec.sbr_balance_type, v_natural_balance_type, NVL(v_py_sbr_beg_bal,0), NVL(v_py_sbr_end_bal,0));
3926: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_amount: '||v_amount);
3927: END IF;
3928: l_log_mesg := ', ' || NVL(v_amount, 0);
3929: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'detail_rec.bud_col: '||detail_rec.bud_col);
3930: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'detail_rec.nbfa_col: '||detail_rec.nbfa_col);
3931:
3932: -- Added upper function for bug 9453175
3933: /*Summing previous years amount*/

Line 3930: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'detail_rec.nbfa_col: '||detail_rec.nbfa_col);

3926: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_amount: '||v_amount);
3927: END IF;
3928: l_log_mesg := ', ' || NVL(v_amount, 0);
3929: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'detail_rec.bud_col: '||detail_rec.bud_col);
3930: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'detail_rec.nbfa_col: '||detail_rec.nbfa_col);
3931:
3932: -- Added upper function for bug 9453175
3933: /*Summing previous years amount*/
3934: IF ( UPPER(v_year_flag) = 'P') THEN

Line 3940: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_col_3_amt: '||v_col_3_amt);

3936: v_col_3_amt := v_col_3_amt + NVL(v_amount, 0);
3937: ELSIF UPPER(nvl(detail_rec.nbfa_col,'N')) = 'Y' THEN
3938: v_col_4_amt := v_col_4_amt + NVL(v_amount, 0);
3939: END IF;
3940: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_col_3_amt: '||v_col_3_amt);
3941: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_col_4_amt: '||v_col_4_amt);
3942: END IF;
3943: /*Summing current years amount*/
3944: IF ( UPPER(v_year_flag) = 'C') THEN

Line 3941: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_col_4_amt: '||v_col_4_amt);

3937: ELSIF UPPER(nvl(detail_rec.nbfa_col,'N')) = 'Y' THEN
3938: v_col_4_amt := v_col_4_amt + NVL(v_amount, 0);
3939: END IF;
3940: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_col_3_amt: '||v_col_3_amt);
3941: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_col_4_amt: '||v_col_4_amt);
3942: END IF;
3943: /*Summing current years amount*/
3944: IF ( UPPER(v_year_flag) = 'C') THEN
3945: IF UPPER(nvl(detail_rec.bud_col,'Y')) = 'Y' THEN

Line 3950: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_col_1_amt: '||v_col_1_amt);

3946: v_col_1_amt := v_col_1_amt + NVL(v_amount, 0);
3947: ELSIF UPPER(nvl(detail_rec.nbfa_col,'N')) = 'Y' THEN
3948: v_col_2_amt := v_col_2_amt + NVL(v_amount, 0);
3949: END IF;
3950: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_col_1_amt: '||v_col_1_amt);
3951: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_col_2_amt: '||v_col_2_amt);
3952: END IF;
3953:
3954: END IF; --- 10

Line 3951: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_col_2_amt: '||v_col_2_amt);

3947: ELSIF UPPER(nvl(detail_rec.nbfa_col,'N')) = 'Y' THEN
3948: v_col_2_amt := v_col_2_amt + NVL(v_amount, 0);
3949: END IF;
3950: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_col_1_amt: '||v_col_1_amt);
3951: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name, 'v_col_2_amt: '||v_col_2_amt);
3952: END IF;
3953:
3954: END IF; --- 10
3955:

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

3957: EXCEPTION
3958: WHEN OTHERS THEN
3959: v_retcode := SQLCODE ;
3960: v_errbuf := SQLERRM || ' [get_sbr_py_bal_details] ' ;
3961: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',v_errbuf);
3962: RETURN;
3963: END get_sbr_py_bal_details;
3964:
3965: PROCEDURE purge_facts_transactions

Line 3989: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name||'NO DATA FOUND IN FV_FACTS_TEMP / FV_FACTS_EDIT_CHECK_STATUS tables ');

3985:
3986: EXCEPTION
3987: -- Exception Processing
3988: When NO_DATA_FOUND Then
3989: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name||'NO DATA FOUND IN FV_FACTS_TEMP / FV_FACTS_EDIT_CHECK_STATUS tables ');
3990: When Others Then
3991: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name||'.final_exception',SQLERRM);
3992: END purge_facts_transactions ;
3993:

Line 3991: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name||'.final_exception',SQLERRM);

3987: -- Exception Processing
3988: When NO_DATA_FOUND Then
3989: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name||'NO DATA FOUND IN FV_FACTS_TEMP / FV_FACTS_EDIT_CHECK_STATUS tables ');
3990: When Others Then
3991: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name||'.final_exception',SQLERRM);
3992: END purge_facts_transactions ;
3993:
3994:
3995: