APPS.FV_SF133_ONEYEAR dependencies on FND_LOG

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

327: -- ------------------------------------
328: -- Store Input Parameters in Global Variables
329: -- ------------------------------------
330: if v_debug then
331: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
332: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'START OF PROGRAM');
333: END IF;
334: end if;
335: parm_application_id := '101';

Line 332: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'START OF PROGRAM');

328: -- Store Input Parameters in Global Variables
329: -- ------------------------------------
330: if v_debug then
331: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
332: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'START OF PROGRAM');
333: END IF;
334: end if;
335: parm_application_id := '101';
336: parm_set_of_books_id := set_of_books_id;

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

351: -- ----------------------------------------
352: -- Display Program Initialization
353: -- ----------------------------------------
354:
355: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
356: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'FVSF133 STARTING, '
357: ||' Run Mode is '||parm_run_mode);
358: END IF;
359:

Line 356: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'FVSF133 STARTING, '

352: -- Display Program Initialization
353: -- ----------------------------------------
354:
355: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
356: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'FVSF133 STARTING, '
357: ||' Run Mode is '||parm_run_mode);
358: END IF;
359:
360:

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

357: ||' Run Mode is '||parm_run_mode);
358: END IF;
359:
360:
361: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
362: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'-- APID('||NVL(PARM_APPLICATION_ID,0) ||')'
363: ||' SoB('||NVL(parm_set_of_books_id,0) ||')'
364: ||' Year('||NVL(parm_gl_period_year,0) ||')'
365: ||' Period('||NVL(parm_gl_period_num,0) ||')'

Line 362: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'-- APID('||NVL(PARM_APPLICATION_ID,0) ||')'

358: END IF;
359:
360:
361: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
362: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'-- APID('||NVL(PARM_APPLICATION_ID,0) ||')'
363: ||' SoB('||NVL(parm_set_of_books_id,0) ||')'
364: ||' Year('||NVL(parm_gl_period_year,0) ||')'
365: ||' Period('||NVL(parm_gl_period_num,0) ||')'
366: ||' Fund Code('||NVL(parm_treasury_value_r1,'Null')

Line 401: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'parm_treasury_value_r1.......'|| parm_treasury_value_r1);

397: -- New code added by Narsimha Balakkari to get the established year and
398: -- cancellation year for specific treasury symbol
399: parm_treasury_value_r1 := ts_rec.treasury_symbol;
400: parm_treasury_symbol_id := ts_rec.treasury_symbol_id;
401: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'parm_treasury_value_r1.......'|| parm_treasury_value_r1);
402:
403: --populate_gtt_with_ccid (parm_treasury_symbol_id);
404:
405: SELECT established_fiscal_yr, substr(cancellation_date,8,4)

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

407: FROM fv_treasury_symbols
408: WHERE treasury_symbol = parm_treasury_value_r1
409: AND set_of_books_id = parm_set_of_books_id ;
410:
411: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
412: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'PROCESSING FOR TREASURY SYMBOL .......'|| PARM_TREASURY_VALUE_R1);
413: END IF;
414:
415: --Fetch the Federal Acct Symbol Id for the TS

Line 412: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'PROCESSING FOR TREASURY SYMBOL .......'|| PARM_TREASURY_VALUE_R1);

408: WHERE treasury_symbol = parm_treasury_value_r1
409: AND set_of_books_id = parm_set_of_books_id ;
410:
411: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
412: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'PROCESSING FOR TREASURY SYMBOL .......'|| PARM_TREASURY_VALUE_R1);
413: END IF;
414:
415: --Fetch the Federal Acct Symbol Id for the TS
416:

Line 422: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'g_federal_acct_symbol_id.......'|| g_federal_acct_symbol_id);

418: INTO g_federal_acct_symbol_id
419: FROM fv_treasury_symbols
420: WHERE set_of_books_id = parm_set_of_books_id
421: AND treasury_symbol_id = parm_treasury_symbol_id;
422: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'g_federal_acct_symbol_id.......'|| g_federal_acct_symbol_id);
423:
424: -- SF133: check if the treasury symbols for the previous 5 years pass factsii edit checks
425:
426: L_LOOP_YEAR := g_established_year ;

Line 453: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,SQLERRM);

449: and time_frame = 'A'; --CGAC
450:
451: exception
452: when no_data_found then
453: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,SQLERRM);
454: exit;
455: end;
456:
457: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

453: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,SQLERRM);
454: exit;
455: end;
456:
457: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
458: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'TREASURY SYMBOL IS '||C_SF133_TS_VALUE );
459: --FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'L_BEG_PERIOD_PREV IS '||L_BEG_PERIOD_PREV );
460: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'L_LOOP_YEAR IS '||l_loop_year );
461: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'PARM_GL_PERIOD_NUM IS '||parm_gl_period_num );

Line 458: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'TREASURY SYMBOL IS '||C_SF133_TS_VALUE );

454: exit;
455: end;
456:
457: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
458: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'TREASURY SYMBOL IS '||C_SF133_TS_VALUE );
459: --FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'L_BEG_PERIOD_PREV IS '||L_BEG_PERIOD_PREV );
460: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'L_LOOP_YEAR IS '||l_loop_year );
461: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'PARM_GL_PERIOD_NUM IS '||parm_gl_period_num );
462: END IF;

Line 459: --FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'L_BEG_PERIOD_PREV IS '||L_BEG_PERIOD_PREV );

455: end;
456:
457: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
458: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'TREASURY SYMBOL IS '||C_SF133_TS_VALUE );
459: --FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'L_BEG_PERIOD_PREV IS '||L_BEG_PERIOD_PREV );
460: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'L_LOOP_YEAR IS '||l_loop_year );
461: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'PARM_GL_PERIOD_NUM IS '||parm_gl_period_num );
462: END IF;
463:

Line 460: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'L_LOOP_YEAR IS '||l_loop_year );

456:
457: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
458: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'TREASURY SYMBOL IS '||C_SF133_TS_VALUE );
459: --FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'L_BEG_PERIOD_PREV IS '||L_BEG_PERIOD_PREV );
460: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'L_LOOP_YEAR IS '||l_loop_year );
461: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'PARM_GL_PERIOD_NUM IS '||parm_gl_period_num );
462: END IF;
463:
464:

Line 461: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'PARM_GL_PERIOD_NUM IS '||parm_gl_period_num );

457: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
458: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'TREASURY SYMBOL IS '||C_SF133_TS_VALUE );
459: --FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'L_BEG_PERIOD_PREV IS '||L_BEG_PERIOD_PREV );
460: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'L_LOOP_YEAR IS '||l_loop_year );
461: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'PARM_GL_PERIOD_NUM IS '||parm_gl_period_num );
462: END IF;
463:
464:
465: FV_FACTS_TRANSACTIONS.main(errbuf_facts, retcode_facts, parm_set_of_books_id, c_sf133_ts_value, L_PROCESS_YEAR, parm_gl_period_num, run_mode_fact, contact_fname,

Line 473: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,

469:
470: IF(retcode_facts <> 0 )then
471: IF(retcode_facts = 1 )then
472: if (FV_FACTS_TRANSACTIONS.v_g_edit_check_code = 2)then
473: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
474: 'Required Edits failed for the Treasury Symbol...'|| PARM_TREASURY_VALUE_R1||errbuf_facts);
475: retcode :=1;
476: END IF;
477: END IF;

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

485: build_report_lines;
486: IF g_error_code <> 0 THEN
487: errbuf := errbuf || 'Processing for Treasury Symbol .......'|| parm_treasury_value_r1 || 'FAILED'|| g_error_message;
488: ELSE
489: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
490: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'SUBMITTING SF133 REPORT FOR TREASURY SYMBOL......' || PARM_TREASURY_VALUE_R1);
491: END IF;
492: l_req_id := FND_REQUEST.SUBMIT_REQUEST('FV','FVXBEGLP','','',FALSE,parm_set_of_books_id,--g_chart_of_accounts_id,
493: parm_gl_period_year,parm_gl_period_name,parm_treasury_value_r1);

Line 490: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'SUBMITTING SF133 REPORT FOR TREASURY SYMBOL......' || PARM_TREASURY_VALUE_R1);

486: IF g_error_code <> 0 THEN
487: errbuf := errbuf || 'Processing for Treasury Symbol .......'|| parm_treasury_value_r1 || 'FAILED'|| g_error_message;
488: ELSE
489: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
490: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'SUBMITTING SF133 REPORT FOR TREASURY SYMBOL......' || PARM_TREASURY_VALUE_R1);
491: END IF;
492: l_req_id := FND_REQUEST.SUBMIT_REQUEST('FV','FVXBEGLP','','',FALSE,parm_set_of_books_id,--g_chart_of_accounts_id,
493: parm_gl_period_year,parm_gl_period_name,parm_treasury_value_r1);
494: IF l_req_id = 0 THEN

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

493: parm_gl_period_year,parm_gl_period_name,parm_treasury_value_r1);
494: IF l_req_id = 0 THEN
495: errbuf := 'Error submitting SF133 Report for Treasury Symbol'|| parm_treasury_value_r1 ;
496: retcode := -1;
497: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.error1', errbuf) ;
498: return;
499: ELSE
500: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
501: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'CONCURRENT REQUEST ID FOR SF133 REPORT - ' || L_REQ_ID);

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

496: retcode := -1;
497: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.error1', errbuf) ;
498: return;
499: ELSE
500: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
501: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'CONCURRENT REQUEST ID FOR SF133 REPORT - ' || L_REQ_ID);
502: END IF;
503: END IF;
504: END IF;

Line 501: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'CONCURRENT REQUEST ID FOR SF133 REPORT - ' || L_REQ_ID);

497: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.error1', errbuf) ;
498: return;
499: ELSE
500: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
501: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'CONCURRENT REQUEST ID FOR SF133 REPORT - ' || L_REQ_ID);
502: END IF;
503: END IF;
504: END IF;
505: -- Committing here to avoid deleting the temporary table

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

517: RAISE abort_error;
518: END IF;
519: --
520:
521: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
522: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'-- INSERT COUNT('||G_INSERT_COUNT||')');
523: END IF;
524: IF errbuf IS NOT null THEN
525: errbuf := 'Normal End of FVSF133 package';

Line 522: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'-- INSERT COUNT('||G_INSERT_COUNT||')');

518: END IF;
519: --
520:
521: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
522: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'-- INSERT COUNT('||G_INSERT_COUNT||')');
523: END IF;
524: IF errbuf IS NOT null THEN
525: errbuf := 'Normal End of FVSF133 package';
526: END IF;

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

523: END IF;
524: IF errbuf IS NOT null THEN
525: errbuf := 'Normal End of FVSF133 package';
526: END IF;
527: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
528: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,ERRBUF);
529: END IF;
530: -- ------------------------------------
531: -- Exceptions

Line 528: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,ERRBUF);

524: IF errbuf IS NOT null THEN
525: errbuf := 'Normal End of FVSF133 package';
526: END IF;
527: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
528: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,ERRBUF);
529: END IF;
530: -- ------------------------------------
531: -- Exceptions
532: -- ------------------------------------

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

536: --
537: WHEN abort_error THEN
538: retcode := g_error_code;
539: errbuf := g_error_message;
540: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.exception1', errbuf) ;
541: WHEN OTHERS THEN
542: g_error_code := SQLCODE;
543: g_error_message := SQLERRM;
544: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception', g_error_message) ;

Line 544: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception', g_error_message) ;

540: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.exception1', errbuf) ;
541: WHEN OTHERS THEN
542: g_error_code := SQLCODE;
543: g_error_message := SQLERRM;
544: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception', g_error_message) ;
545: RAISE_APPLICATION_ERROR(-20222,'FVSF133 Exception-'||SQLERRM);
546: END Main;
547: -- ------------------------------------------------------------------
548: -- --------------------------------------------------------

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

558: BEGIN
559: l_module_name := g_module_name || 'determine_acct_flex_segments';
560: --
561: IF parm_run_mode = 'T' THEN
562: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
563: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'START DETERMINE_ACCT_FLEX_SEGMENTS');
564: END IF;
565: END IF;
566: --

Line 563: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'START DETERMINE_ACCT_FLEX_SEGMENTS');

559: l_module_name := g_module_name || 'determine_acct_flex_segments';
560: --
561: IF parm_run_mode = 'T' THEN
562: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
563: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'START DETERMINE_ACCT_FLEX_SEGMENTS');
564: END IF;
565: END IF;
566: --
567: -- -------------------------------------

Line 660: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,'Error in getting the Value set attched ' ||

656: AND id_flex_code = 'GL#'
657: AND id_flex_num = g_chart_of_accounts_id;
658: EXCEPTION
659: WHEN OTHERS THEN
660: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,'Error in getting the Value set attched ' ||
661: ' to the segemnt => ' || c_flex_column_name);
662: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,' SQLCODE => ' || SQLCODE ||
663: ' SQLERRM => ' || SQLERRM);
664: RAISE;

Line 662: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,' SQLCODE => ' || SQLCODE ||

658: EXCEPTION
659: WHEN OTHERS THEN
660: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,'Error in getting the Value set attched ' ||
661: ' to the segemnt => ' || c_flex_column_name);
662: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,' SQLCODE => ' || SQLCODE ||
663: ' SQLERRM => ' || SQLERRM);
664: RAISE;
665: END;
666: -- + Rollup for the amount is the segment is a parent segment +

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

692: --
693: END LOOP;
694: */
695:
696: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
697: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,V_SELECT);
698: END IF;
699: --
700: v_cursor_id := DBMS_SQL.OPEN_CURSOR();

Line 697: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,V_SELECT);

693: END LOOP;
694: */
695:
696: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
697: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,V_SELECT);
698: END IF;
699: --
700: v_cursor_id := DBMS_SQL.OPEN_CURSOR();
701: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

697: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,V_SELECT);
698: END IF;
699: --
700: v_cursor_id := DBMS_SQL.OPEN_CURSOR();
701: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
702: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'T1');
703: END IF;
704:
705: fnd_file.put_line (fnd_file.log, v_select);

Line 702: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'T1');

698: END IF;
699: --
700: v_cursor_id := DBMS_SQL.OPEN_CURSOR();
701: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
702: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'T1');
703: END IF;
704:
705: fnd_file.put_line (fnd_file.log, v_select);
706:

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

709: dbms_sql.bind_variable(v_cursor_id,':cv_set_of_books_id',parm_set_of_books_id);
710: -- dbms_sql.bind_variable(v_cursor_id,':cv_chart_of_accounts_id',g_chart_of_accounts_id);
711: dbms_sql.bind_variable(v_cursor_id,':cv_currency_code',g_currency_code);
712:
713: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
714: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'T2');
715: END IF;
716: dbms_sql.define_column(v_cursor_id,1,c_total_balance);
717: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 714: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'T2');

710: -- dbms_sql.bind_variable(v_cursor_id,':cv_chart_of_accounts_id',g_chart_of_accounts_id);
711: dbms_sql.bind_variable(v_cursor_id,':cv_currency_code',g_currency_code);
712:
713: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
714: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'T2');
715: END IF;
716: dbms_sql.define_column(v_cursor_id,1,c_total_balance);
717: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
718: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'T3');

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

713: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
714: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'T2');
715: END IF;
716: dbms_sql.define_column(v_cursor_id,1,c_total_balance);
717: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
718: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'T3');
719: END IF;
720:
721:

Line 718: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'T3');

714: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'T2');
715: END IF;
716: dbms_sql.define_column(v_cursor_id,1,c_total_balance);
717: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
718: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'T3');
719: END IF;
720:
721:
722: --

Line 734: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception', g_error_message) ;

730: g_error_message := 'determine_acct_flex_segments/'||SQLERRM;
731: IF flex_field_column_name_cursor%ISOPEN THEN
732: close flex_field_column_name_cursor;
733: END IF;
734: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception', g_error_message) ;
735: --
736: END determine_acct_flex_segments;
737: -- --------------------------------------------------------
738: -- --------------------------------------------------------

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

744: BEGIN
745: l_module_name := g_module_name || 'purge_temp_table';
746: --
747: IF parm_run_mode = 'T' THEN
748: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
749: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'START PURGE_TEMP_TABLE');
750: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,' FUND SEGMENT ('||G_FUND_SEGMENT_NAME ||')');
751: END IF;
752: END IF;

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

745: l_module_name := g_module_name || 'purge_temp_table';
746: --
747: IF parm_run_mode = 'T' THEN
748: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
749: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'START PURGE_TEMP_TABLE');
750: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,' FUND SEGMENT ('||G_FUND_SEGMENT_NAME ||')');
751: END IF;
752: END IF;
753: --

Line 750: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,' FUND SEGMENT ('||G_FUND_SEGMENT_NAME ||')');

746: --
747: IF parm_run_mode = 'T' THEN
748: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
749: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'START PURGE_TEMP_TABLE');
750: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,' FUND SEGMENT ('||G_FUND_SEGMENT_NAME ||')');
751: END IF;
752: END IF;
753: --
754: DELETE

Line 775: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception', g_error_message) ;

771: --
772: WHEN OTHERS THEN
773: g_error_code := SQLCODE;
774: g_error_message := SQLERRM;
775: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception', g_error_message) ;
776: --
777: END purge_temp_table;
778: -- --------------------------------------------------------
779: -- --------------------------------------------------------

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

795: BEGIN
796: l_module_name := g_module_name || 'build_report_lines';
797: --
798: IF parm_run_mode = 'T' THEN
799: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
800: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'START BUILD_REPORT_LINES');
801: END IF;
802: END IF;
803: --

Line 800: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'START BUILD_REPORT_LINES');

796: l_module_name := g_module_name || 'build_report_lines';
797: --
798: IF parm_run_mode = 'T' THEN
799: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
800: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'START BUILD_REPORT_LINES');
801: END IF;
802: END IF;
803: --
804: -- ----------------------------------------------------------

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

836: --
837: FOR ts_report_line_entry IN ts_report_line_cursor LOOP
838: --
839: if v_debug then
840: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
841: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'LG 3 INSIDE LOOP ') ;
842: END IF;
843: end if;
844:

Line 841: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'LG 3 INSIDE LOOP ') ;

837: FOR ts_report_line_entry IN ts_report_line_cursor LOOP
838: --
839: if v_debug then
840: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
841: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'LG 3 INSIDE LOOP ') ;
842: END IF;
843: end if;
844:
845: c_sf133_ts_value := ts_report_line_entry.sf133_ts_value;

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

884: L_LOOP_YEAR := g_established_year - 1;
885:
886: l_sf133_ts_value := c_sf133_ts_value;
887:
888: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
889: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'FEDERAL ACCT SYMBOL ID IS'|| TO_CHAR(L_FEDERAL_ACCT_SYMBOL_ID)) ;
890: END IF;
891:
892: For l_year_counter IN 1..5 Loop

Line 889: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'FEDERAL ACCT SYMBOL ID IS'|| TO_CHAR(L_FEDERAL_ACCT_SYMBOL_ID)) ;

885:
886: l_sf133_ts_value := c_sf133_ts_value;
887:
888: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
889: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'FEDERAL ACCT SYMBOL ID IS'|| TO_CHAR(L_FEDERAL_ACCT_SYMBOL_ID)) ;
890: END IF;
891:
892: For l_year_counter IN 1..5 Loop
893:

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

922: and federal_acct_symbol_id = g_federal_acct_symbol_id
923: and established_fiscal_yr = l_loop_year
924: and time_frame = 'A';--CGAC
925:
926: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
927: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'TREASURY SYMBOL IS '||C_SF133_TS_VALUE );
928: END IF;
929:
930: c_sf133_treasury_symbol_id := g_treasury_symbol_id;

Line 927: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'TREASURY SYMBOL IS '||C_SF133_TS_VALUE );

923: and established_fiscal_yr = l_loop_year
924: and time_frame = 'A';--CGAC
925:
926: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
927: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'TREASURY SYMBOL IS '||C_SF133_TS_VALUE );
928: END IF;
929:
930: c_sf133_treasury_symbol_id := g_treasury_symbol_id;
931: -- dbms_sql.bind_variable(v_cursor_id,':cv_treasury_symbol_id',

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

942: --LGOEL: Restore the treasury symbol variable value
943: c_sf133_ts_value := l_sf133_ts_value;
944:
945:
946: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
947: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'PROCESS YEAR - ' || TO_CHAR(L_PROCESS_YEAR) ||
948: 'Beginning Period - ' || to_char(l_beg_period_prev) ||
949: 'Ending Period - ' || to_char(l_end_period_prev)) ;
950: END IF;

Line 947: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'PROCESS YEAR - ' || TO_CHAR(L_PROCESS_YEAR) ||

943: c_sf133_ts_value := l_sf133_ts_value;
944:
945:
946: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
947: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'PROCESS YEAR - ' || TO_CHAR(L_PROCESS_YEAR) ||
948: 'Beginning Period - ' || to_char(l_beg_period_prev) ||
949: 'Ending Period - ' || to_char(l_end_period_prev)) ;
950: END IF;
951:

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

955: -- assignment after SET phrase, a litle round about way
956: -- is used by using Decode on the right side. Still one
957: -- SQL statement !!
958:
959: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
960: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'LOOP COUNTER ' || TO_CHAR(L_YEAR_COUNTER) || ' AMOUNT VALUE ' || TO_CHAR(O_SF133_COLUMN_AMOUNT)) ;
961: END IF;
962: UPDATE FV_SF133_DEFINITIONS_COLS_TEMP
963: SET

Line 960: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'LOOP COUNTER ' || TO_CHAR(L_YEAR_COUNTER) || ' AMOUNT VALUE ' || TO_CHAR(O_SF133_COLUMN_AMOUNT)) ;

956: -- is used by using Decode on the right side. Still one
957: -- SQL statement !!
958:
959: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
960: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'LOOP COUNTER ' || TO_CHAR(L_YEAR_COUNTER) || ' AMOUNT VALUE ' || TO_CHAR(O_SF133_COLUMN_AMOUNT)) ;
961: END IF;
962: UPDATE FV_SF133_DEFINITIONS_COLS_TEMP
963: SET
964: SF133_COLUMN_2_AMOUNT = DECODE(L_YEAR_COUNTER, 1,

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

1013: INTO l_line_cnt
1014: FROM fv_sf133_rep_line_calc
1015: WHERE line_id = c_sf133_line_id;
1016: IF l_line_cnt = 0 THEN
1017: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.error1','Total line does not contain calculations. SEED Data not properly Loaded. Please Verify and reinvoke the Process.');
1018: RETURN;
1019: END IF;
1020: process_total_line;
1021:

Line 1040: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception', g_error_message) ;

1036:
1037: IF ts_report_line_cursor%ISOPEN THEN
1038: close ts_report_line_cursor;
1039: END IF;
1040: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception', g_error_message) ;
1041: --
1042: END build_report_lines;
1043: -- --------------------------------------------------------
1044: -- ----------------------------------------------

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

1062: l_module_name := g_module_name || 'build_fiscal_line_columns';
1063: --
1064: IF parm_run_mode = 'T' THEN
1065:
1066: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1067: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'START BUILD_FISCAL_LINE_COLUMNS');
1068: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'-- LINE('||C_SF133_LINE_NUMBER||')'
1069: || ' Tresury Symbol('||c_sf133_ts_value ||')'
1070: || ' '||to_char(SYSDATE,'mm/dd/yyyy hh:mi:ss'));

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

1063: --
1064: IF parm_run_mode = 'T' THEN
1065:
1066: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1067: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'START BUILD_FISCAL_LINE_COLUMNS');
1068: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'-- LINE('||C_SF133_LINE_NUMBER||')'
1069: || ' Tresury Symbol('||c_sf133_ts_value ||')'
1070: || ' '||to_char(SYSDATE,'mm/dd/yyyy hh:mi:ss'));
1071: END IF;

Line 1068: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'-- LINE('||C_SF133_LINE_NUMBER||')'

1064: IF parm_run_mode = 'T' THEN
1065:
1066: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1067: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'START BUILD_FISCAL_LINE_COLUMNS');
1068: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'-- LINE('||C_SF133_LINE_NUMBER||')'
1069: || ' Tresury Symbol('||c_sf133_ts_value ||')'
1070: || ' '||to_char(SYSDATE,'mm/dd/yyyy hh:mi:ss'));
1071: END IF;
1072: END IF;

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

1145: END IF;
1146: ELSE
1147: c_rescission_flag := 'TRUE';
1148: END IF;
1149: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1150:
1151: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'LINE NUMBER IS ' || C_SF133_REPORT_LINE_NUMBER);
1152: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'RESOURCE TYPE IS ' || C_RESOURCE_TYPE);
1153: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'RESOURCE FLAG IS ' || C_RESCISSION_FLAG);

Line 1151: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'LINE NUMBER IS ' || C_SF133_REPORT_LINE_NUMBER);

1147: c_rescission_flag := 'TRUE';
1148: END IF;
1149: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1150:
1151: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'LINE NUMBER IS ' || C_SF133_REPORT_LINE_NUMBER);
1152: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'RESOURCE TYPE IS ' || C_RESOURCE_TYPE);
1153: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'RESOURCE FLAG IS ' || C_RESCISSION_FLAG);
1154: END IF;
1155: IF c_rescission_flag = 'TRUE' THEN

Line 1152: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'RESOURCE TYPE IS ' || C_RESOURCE_TYPE);

1148: END IF;
1149: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1150:
1151: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'LINE NUMBER IS ' || C_SF133_REPORT_LINE_NUMBER);
1152: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'RESOURCE TYPE IS ' || C_RESOURCE_TYPE);
1153: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'RESOURCE FLAG IS ' || C_RESCISSION_FLAG);
1154: END IF;
1155: IF c_rescission_flag = 'TRUE' THEN
1156:

Line 1153: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'RESOURCE FLAG IS ' || C_RESCISSION_FLAG);

1149: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1150:
1151: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'LINE NUMBER IS ' || C_SF133_REPORT_LINE_NUMBER);
1152: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'RESOURCE TYPE IS ' || C_RESOURCE_TYPE);
1153: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'RESOURCE FLAG IS ' || C_RESCISSION_FLAG);
1154: END IF;
1155: IF c_rescission_flag = 'TRUE' THEN
1156:
1157: SELECT start_date,

Line 1318: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,query_fetch_bal);

1314:
1315: v_cursor_id := dbms_sql.open_cursor;
1316: query_fetch_bal := query_fetch_bal ||' '|| where_clause;
1317: -- print query
1318: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,query_fetch_bal);
1319:
1320: dbms_sql.parse(v_cursor_id, query_fetch_bal, dbms_sql.v7);
1321: dbms_sql.define_column(v_cursor_id, 1, c_total_balance);
1322: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_acct_id',c_sf133_line_acct_id);

Line 1328: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sf133_balance_type:'||c_sf133_balance_type);

1324: dbms_sql.bind_variable(v_cursor_id,':cv_treasury_symbol_id',c_sf133_treasury_symbol_id);
1325: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_id',c_sf133_line_id);
1326:
1327: --print bind variables
1328: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sf133_balance_type:'||c_sf133_balance_type);
1329: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_treasury_symbol_id:'||c_sf133_treasury_symbol_id);
1330: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_sf133_line_acct_id:'||c_sf133_line_acct_id);
1331: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sf133_line_id:'||c_sf133_line_id);
1332:

Line 1329: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_treasury_symbol_id:'||c_sf133_treasury_symbol_id);

1325: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_id',c_sf133_line_id);
1326:
1327: --print bind variables
1328: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sf133_balance_type:'||c_sf133_balance_type);
1329: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_treasury_symbol_id:'||c_sf133_treasury_symbol_id);
1330: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_sf133_line_acct_id:'||c_sf133_line_acct_id);
1331: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sf133_line_id:'||c_sf133_line_id);
1332:
1333:

Line 1330: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_sf133_line_acct_id:'||c_sf133_line_acct_id);

1326:
1327: --print bind variables
1328: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sf133_balance_type:'||c_sf133_balance_type);
1329: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_treasury_symbol_id:'||c_sf133_treasury_symbol_id);
1330: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_sf133_line_acct_id:'||c_sf133_line_acct_id);
1331: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sf133_line_id:'||c_sf133_line_id);
1332:
1333:
1334: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);

Line 1331: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sf133_line_id:'||c_sf133_line_id);

1327: --print bind variables
1328: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sf133_balance_type:'||c_sf133_balance_type);
1329: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_treasury_symbol_id:'||c_sf133_treasury_symbol_id);
1330: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_sf133_line_acct_id:'||c_sf133_line_acct_id);
1331: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sf133_line_id:'||c_sf133_line_id);
1332:
1333:
1334: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
1335:

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

1332:
1333:
1334: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
1335:
1336: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1337: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'l_ignore := '||l_ignore);
1338: END IF;
1339:
1340: dbms_sql.column_value(v_cursor_id, 1, c_total_balance);

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

1333:
1334: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
1335:
1336: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1337: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'l_ignore := '||l_ignore);
1338: END IF;
1339:
1340: dbms_sql.column_value(v_cursor_id, 1, c_total_balance);
1341: dbms_sql.close_cursor(v_cursor_id);

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

1338: END IF;
1339:
1340: dbms_sql.column_value(v_cursor_id, 1, c_total_balance);
1341: dbms_sql.close_cursor(v_cursor_id);
1342: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance:'||c_total_balance);
1343: end if;
1344:
1345: -- End the code for bal type beginning and ending
1346:

Line 1371: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,query_fetch_bal);

1367: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_acct_id',c_sf133_line_acct_id);
1368: dbms_sql.bind_variable(v_cursor_id,':cv_treasury_symbol_id',c_sf133_treasury_symbol_id);
1369: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_id',c_sf133_line_id);
1370: -- print query
1371: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,query_fetch_bal);
1372:
1373: --print bind variables
1374: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sf133_balance_type:'||c_sf133_balance_type);
1375: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_treasury_symbol_id:'||c_sf133_treasury_symbol_id);

Line 1374: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sf133_balance_type:'||c_sf133_balance_type);

1370: -- print query
1371: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,query_fetch_bal);
1372:
1373: --print bind variables
1374: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sf133_balance_type:'||c_sf133_balance_type);
1375: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_treasury_symbol_id:'||c_sf133_treasury_symbol_id);
1376: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_sf133_line_acct_id:'||c_sf133_line_acct_id);
1377: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sf133_line_id:'||c_sf133_line_id);
1378:

Line 1375: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_treasury_symbol_id:'||c_sf133_treasury_symbol_id);

1371: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,query_fetch_bal);
1372:
1373: --print bind variables
1374: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sf133_balance_type:'||c_sf133_balance_type);
1375: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_treasury_symbol_id:'||c_sf133_treasury_symbol_id);
1376: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_sf133_line_acct_id:'||c_sf133_line_acct_id);
1377: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sf133_line_id:'||c_sf133_line_id);
1378:
1379: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);

Line 1376: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_sf133_line_acct_id:'||c_sf133_line_acct_id);

1372:
1373: --print bind variables
1374: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sf133_balance_type:'||c_sf133_balance_type);
1375: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_treasury_symbol_id:'||c_sf133_treasury_symbol_id);
1376: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_sf133_line_acct_id:'||c_sf133_line_acct_id);
1377: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sf133_line_id:'||c_sf133_line_id);
1378:
1379: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
1380:

Line 1377: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sf133_line_id:'||c_sf133_line_id);

1373: --print bind variables
1374: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sf133_balance_type:'||c_sf133_balance_type);
1375: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_treasury_symbol_id:'||c_sf133_treasury_symbol_id);
1376: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_sf133_line_acct_id:'||c_sf133_line_acct_id);
1377: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sf133_line_id:'||c_sf133_line_id);
1378:
1379: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
1380:
1381: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

1377: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sf133_line_id:'||c_sf133_line_id);
1378:
1379: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
1380:
1381: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1382: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'l_ignore := '||l_ignore);
1383: END IF;
1384:
1385: dbms_sql.column_value(v_cursor_id, 1, c_total_balance);

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

1378:
1379: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
1380:
1381: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1382: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'l_ignore := '||l_ignore);
1383: END IF;
1384:
1385: dbms_sql.column_value(v_cursor_id, 1, c_total_balance);
1386: dbms_sql.close_cursor(v_cursor_id);

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

1383: END IF;
1384:
1385: dbms_sql.column_value(v_cursor_id, 1, c_total_balance);
1386: dbms_sql.close_cursor(v_cursor_id);
1387: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance:'||c_total_balance);
1388:
1389: elsif (( c_sf133_line_type_code = 'D' AND c_sf133_natural_bal_type ='C') or
1390: ( c_sf133_line_type_code = 'D2' AND c_sf133_natural_bal_type ='D'))then
1391:

Line 1410: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,query_fetch_bal);

1406: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_acct_id',c_sf133_line_acct_id);
1407: dbms_sql.bind_variable(v_cursor_id,':cv_treasury_symbol_id',c_sf133_treasury_symbol_id);
1408: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_id',c_sf133_line_id);
1409: -- print query
1410: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,query_fetch_bal);
1411:
1412: --print bind variables
1413: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sf133_balance_type:'||c_sf133_balance_type);
1414: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_treasury_symbol_id:'||c_sf133_treasury_symbol_id);

Line 1413: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sf133_balance_type:'||c_sf133_balance_type);

1409: -- print query
1410: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,query_fetch_bal);
1411:
1412: --print bind variables
1413: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sf133_balance_type:'||c_sf133_balance_type);
1414: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_treasury_symbol_id:'||c_sf133_treasury_symbol_id);
1415: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_sf133_line_acct_id:'||c_sf133_line_acct_id);
1416: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sf133_line_id:'||c_sf133_line_id);
1417:

Line 1414: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_treasury_symbol_id:'||c_sf133_treasury_symbol_id);

1410: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,query_fetch_bal);
1411:
1412: --print bind variables
1413: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sf133_balance_type:'||c_sf133_balance_type);
1414: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_treasury_symbol_id:'||c_sf133_treasury_symbol_id);
1415: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_sf133_line_acct_id:'||c_sf133_line_acct_id);
1416: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sf133_line_id:'||c_sf133_line_id);
1417:
1418: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);

Line 1415: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_sf133_line_acct_id:'||c_sf133_line_acct_id);

1411:
1412: --print bind variables
1413: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sf133_balance_type:'||c_sf133_balance_type);
1414: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_treasury_symbol_id:'||c_sf133_treasury_symbol_id);
1415: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_sf133_line_acct_id:'||c_sf133_line_acct_id);
1416: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sf133_line_id:'||c_sf133_line_id);
1417:
1418: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
1419:

Line 1416: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sf133_line_id:'||c_sf133_line_id);

1412: --print bind variables
1413: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sf133_balance_type:'||c_sf133_balance_type);
1414: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_treasury_symbol_id:'||c_sf133_treasury_symbol_id);
1415: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_sf133_line_acct_id:'||c_sf133_line_acct_id);
1416: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sf133_line_id:'||c_sf133_line_id);
1417:
1418: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
1419:
1420: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

1416: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sf133_line_id:'||c_sf133_line_id);
1417:
1418: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
1419:
1420: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1421: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'l_ignore := '||l_ignore);
1422: END IF;
1423:
1424: dbms_sql.column_value(v_cursor_id, 1, c_total_balance);

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

1417:
1418: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
1419:
1420: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1421: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'l_ignore := '||l_ignore);
1422: END IF;
1423:
1424: dbms_sql.column_value(v_cursor_id, 1, c_total_balance);
1425: dbms_sql.close_cursor(v_cursor_id);

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

1422: END IF;
1423:
1424: dbms_sql.column_value(v_cursor_id, 1, c_total_balance);
1425: dbms_sql.close_cursor(v_cursor_id);
1426: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance:'||c_total_balance);
1427: END IF;
1428:
1429: elsif (( c_sf133_balance_type= 'ED') or( c_sf133_balance_type= 'EC')) then -- bal type is ending debit or ending credit only
1430:

Line 1450: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,query_fetch_bal);

1446: dbms_sql.bind_variable(v_cursor_id,':cv_treasury_symbol_id',c_sf133_treasury_symbol_id);
1447: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_id',c_sf133_line_id);
1448:
1449: -- print query
1450: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,query_fetch_bal);
1451: --print bind variables
1452: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sf133_balance_type:'||c_sf133_balance_type);
1453: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'parm_tsymbol_id:'||c_sf133_treasury_symbol_id);
1454: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_sf133_line_acct_id:'||c_sf133_line_acct_id);

Line 1452: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sf133_balance_type:'||c_sf133_balance_type);

1448:
1449: -- print query
1450: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,query_fetch_bal);
1451: --print bind variables
1452: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sf133_balance_type:'||c_sf133_balance_type);
1453: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'parm_tsymbol_id:'||c_sf133_treasury_symbol_id);
1454: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_sf133_line_acct_id:'||c_sf133_line_acct_id);
1455: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sf133_line_id:'||c_sf133_line_id);
1456:

Line 1453: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'parm_tsymbol_id:'||c_sf133_treasury_symbol_id);

1449: -- print query
1450: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,query_fetch_bal);
1451: --print bind variables
1452: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sf133_balance_type:'||c_sf133_balance_type);
1453: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'parm_tsymbol_id:'||c_sf133_treasury_symbol_id);
1454: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_sf133_line_acct_id:'||c_sf133_line_acct_id);
1455: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sf133_line_id:'||c_sf133_line_id);
1456:
1457: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);

Line 1454: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_sf133_line_acct_id:'||c_sf133_line_acct_id);

1450: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,query_fetch_bal);
1451: --print bind variables
1452: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sf133_balance_type:'||c_sf133_balance_type);
1453: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'parm_tsymbol_id:'||c_sf133_treasury_symbol_id);
1454: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_sf133_line_acct_id:'||c_sf133_line_acct_id);
1455: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sf133_line_id:'||c_sf133_line_id);
1456:
1457: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
1458:

Line 1455: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sf133_line_id:'||c_sf133_line_id);

1451: --print bind variables
1452: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sf133_balance_type:'||c_sf133_balance_type);
1453: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'parm_tsymbol_id:'||c_sf133_treasury_symbol_id);
1454: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_sf133_line_acct_id:'||c_sf133_line_acct_id);
1455: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sf133_line_id:'||c_sf133_line_id);
1456:
1457: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
1458:
1459: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

1455: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sf133_line_id:'||c_sf133_line_id);
1456:
1457: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
1458:
1459: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1460: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'l_ignore := '||l_ignore);
1461: END IF;
1462:
1463: dbms_sql.column_value(v_cursor_id, 1, c_total_balance);

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

1456:
1457: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
1458:
1459: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1460: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'l_ignore := '||l_ignore);
1461: END IF;
1462:
1463: dbms_sql.column_value(v_cursor_id, 1, c_total_balance);
1464: dbms_sql.close_cursor(v_cursor_id);

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

1461: END IF;
1462:
1463: dbms_sql.column_value(v_cursor_id, 1, c_total_balance);
1464: dbms_sql.close_cursor(v_cursor_id);
1465: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance:'||c_total_balance);
1466:
1467: if ( c_sf133_balance_type = 'ED')then
1468: if (c_total_balance < 0) then
1469: c_total_balance := 0;

Line 1486: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance after modification:'||c_total_balance);

1482: ( c_sf133_line_type_code = 'D2' AND c_sf133_natural_bal_type ='D')) then
1483: c_total_balance := c_total_balance*(-1);
1484: end if;
1485:
1486: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance after modification:'||c_total_balance);
1487: end if;
1488:
1489: elsif( (c_sf133_balance_type= 'E-BD') or (c_sf133_balance_type='E-BC')) then -- bal type is end begin debit only
1490:

Line 1510: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,query_fetch_bal);

1506: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_acct_id',c_sf133_line_acct_id);
1507: dbms_sql.bind_variable(v_cursor_id,':cv_treasury_symbol_id',c_sf133_treasury_symbol_id);
1508: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_id',c_sf133_line_id);
1509: -- print query
1510: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,query_fetch_bal);
1511:
1512: --print bind variables
1513: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sf133_balance_type:'||c_sf133_balance_type);
1514: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_treasury_symbol_id:'||c_sf133_treasury_symbol_id);

Line 1513: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sf133_balance_type:'||c_sf133_balance_type);

1509: -- print query
1510: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,query_fetch_bal);
1511:
1512: --print bind variables
1513: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sf133_balance_type:'||c_sf133_balance_type);
1514: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_treasury_symbol_id:'||c_sf133_treasury_symbol_id);
1515: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_sf133_line_acct_id:'||c_sf133_line_acct_id);
1516: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sf133_line_id:'||c_sf133_line_id);
1517:

Line 1514: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_treasury_symbol_id:'||c_sf133_treasury_symbol_id);

1510: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,query_fetch_bal);
1511:
1512: --print bind variables
1513: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sf133_balance_type:'||c_sf133_balance_type);
1514: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_treasury_symbol_id:'||c_sf133_treasury_symbol_id);
1515: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_sf133_line_acct_id:'||c_sf133_line_acct_id);
1516: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sf133_line_id:'||c_sf133_line_id);
1517:
1518: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);

Line 1515: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_sf133_line_acct_id:'||c_sf133_line_acct_id);

1511:
1512: --print bind variables
1513: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sf133_balance_type:'||c_sf133_balance_type);
1514: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_treasury_symbol_id:'||c_sf133_treasury_symbol_id);
1515: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_sf133_line_acct_id:'||c_sf133_line_acct_id);
1516: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sf133_line_id:'||c_sf133_line_id);
1517:
1518: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
1519:

Line 1516: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sf133_line_id:'||c_sf133_line_id);

1512: --print bind variables
1513: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sf133_balance_type:'||c_sf133_balance_type);
1514: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_treasury_symbol_id:'||c_sf133_treasury_symbol_id);
1515: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_sf133_line_acct_id:'||c_sf133_line_acct_id);
1516: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sf133_line_id:'||c_sf133_line_id);
1517:
1518: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
1519:
1520: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

1516: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sf133_line_id:'||c_sf133_line_id);
1517:
1518: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
1519:
1520: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1521: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'l_ignore := '||l_ignore);
1522: END IF;
1523:
1524: dbms_sql.column_value(v_cursor_id, 1, c_total_balance);

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

1517:
1518: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
1519:
1520: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1521: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'l_ignore := '||l_ignore);
1522: END IF;
1523:
1524: dbms_sql.column_value(v_cursor_id, 1, c_total_balance);
1525: dbms_sql.close_cursor(v_cursor_id);

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

1522: END IF;
1523:
1524: dbms_sql.column_value(v_cursor_id, 1, c_total_balance);
1525: dbms_sql.close_cursor(v_cursor_id);
1526: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance:'||c_total_balance);
1527:
1528: if (c_sf133_balance_type= 'E-BD') then
1529: if (c_total_balance > 0) then
1530: if(( c_sf133_line_type_code = 'D' AND c_sf133_natural_bal_type ='D') or

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

1582: o_sf133_column_amount := c_sf133_amount_not_shown;
1583: o_sf133_amt_not_shown := c_sf133_amount_not_shown;
1584: o_sf133_treasury_symbol_id := c_sf133_treasury_symbol_id; --Bug 1575992
1585:
1586: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1587: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'COL AMT ='||O_SF133_COLUMN_AMOUNT);
1588: END IF;
1589: --
1590: -- ------------------------------------

Line 1587: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'COL AMT ='||O_SF133_COLUMN_AMOUNT);

1583: o_sf133_amt_not_shown := c_sf133_amount_not_shown;
1584: o_sf133_treasury_symbol_id := c_sf133_treasury_symbol_id; --Bug 1575992
1585:
1586: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1587: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'COL AMT ='||O_SF133_COLUMN_AMOUNT);
1588: END IF;
1589: --
1590: -- ------------------------------------
1591: -- Exceptions

Line 1607: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception', g_error_message) ;

1603: /* ELSIF balance_cursor%ISOPEN THEN
1604: close balance_cursor;*/
1605: END IF;
1606:
1607: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception', g_error_message) ;
1608: --
1609: END build_fiscal_line_columns;
1610: -- ----------------------------------------------
1611: -- ----------------------------------------------

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

1635: BEGIN
1636: l_module_name := g_module_name || 'build_total_line_columns';
1637: --
1638: IF parm_run_mode = 'T' THEN
1639: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1640: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'START BUILD_TOTAL_LINE_COLUMNS');
1641: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'-- LINE='||C_SF133_LINE_NUMBER
1642: ||' Start Total Line('||g_total_start_line_number||')'
1643: || ' Treasury Symbol('||c_sf133_ts_value||')');

Line 1640: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'START BUILD_TOTAL_LINE_COLUMNS');

1636: l_module_name := g_module_name || 'build_total_line_columns';
1637: --
1638: IF parm_run_mode = 'T' THEN
1639: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1640: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'START BUILD_TOTAL_LINE_COLUMNS');
1641: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'-- LINE='||C_SF133_LINE_NUMBER
1642: ||' Start Total Line('||g_total_start_line_number||')'
1643: || ' Treasury Symbol('||c_sf133_ts_value||')');
1644: END IF;

Line 1641: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'-- LINE='||C_SF133_LINE_NUMBER

1637: --
1638: IF parm_run_mode = 'T' THEN
1639: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1640: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'START BUILD_TOTAL_LINE_COLUMNS');
1641: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'-- LINE='||C_SF133_LINE_NUMBER
1642: ||' Start Total Line('||g_total_start_line_number||')'
1643: || ' Treasury Symbol('||c_sf133_ts_value||')');
1644: END IF;
1645: END IF;

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

1677: DECODE(c_sf133_line_type_code, 'T', g_total_start_line_number, g_subtotal_start_line_number)
1678: AND sf133_line_number < c_sf133_line_number);
1679:
1680:
1681: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1682: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'NATURAL BAL TYPE = '||C_SF133_NATURAL_BAL_TYPE);
1683: END IF;
1684: /* IF c_sf133_natural_bal_type = 'C' THEN
1685:

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

1678: AND sf133_line_number < c_sf133_line_number);
1679:
1680:
1681: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1682: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'NATURAL BAL TYPE = '||C_SF133_NATURAL_BAL_TYPE);
1683: END IF;
1684: /* IF c_sf133_natural_bal_type = 'C' THEN
1685:
1686: -- Credit, so display opposite

Line 1794: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception', g_error_message) ;

1790: --
1791: WHEN OTHERS THEN
1792: g_error_code := SQLCODE;
1793: g_error_message := SQLERRM;
1794: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception', g_error_message) ;
1795: --
1796: END build_total_line_columns;
1797: -- ----------------------------------------------
1798: -- --------------------------------------------------------

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

1805: BEGIN
1806: l_module_name := g_module_name || 'populate_temp_table';
1807: --
1808: IF parm_run_mode = 'T' THEN
1809: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1810: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'START POPULATE_TEMP_TABLE');
1811: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, '-- '||C_SF133_LINE_NUMBER
1812: ||' ('||o_sf133_column_number||')'
1813: ||' ('||o_sf133_column_amount||')'

Line 1810: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'START POPULATE_TEMP_TABLE');

1806: l_module_name := g_module_name || 'populate_temp_table';
1807: --
1808: IF parm_run_mode = 'T' THEN
1809: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1810: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'START POPULATE_TEMP_TABLE');
1811: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, '-- '||C_SF133_LINE_NUMBER
1812: ||' ('||o_sf133_column_number||')'
1813: ||' ('||o_sf133_column_amount||')'
1814: ||' ('||o_sf133_amt_not_shown||')');

Line 1811: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, '-- '||C_SF133_LINE_NUMBER

1807: --
1808: IF parm_run_mode = 'T' THEN
1809: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1810: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'START POPULATE_TEMP_TABLE');
1811: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, '-- '||C_SF133_LINE_NUMBER
1812: ||' ('||o_sf133_column_number||')'
1813: ||' ('||o_sf133_column_amount||')'
1814: ||' ('||o_sf133_amt_not_shown||')');
1815: END IF;

Line 1859: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception', g_error_message) ;

1855: WHEN OTHERS THEN
1856: g_error_code := SQLCODE;
1857: g_error_message := SQLERRM;
1858:
1859: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception', g_error_message) ;
1860: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name,'-- POPULATE_TEMP_TABLE');
1861: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name,'---- TREASURY SYMBOL:'||O_SF133_TS_VALUE
1862: ||' Line Id:'||o_sf133_line_id
1863: ||' Col:' ||o_sf133_column_number

Line 1860: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name,'-- POPULATE_TEMP_TABLE');

1856: g_error_code := SQLCODE;
1857: g_error_message := SQLERRM;
1858:
1859: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception', g_error_message) ;
1860: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name,'-- POPULATE_TEMP_TABLE');
1861: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name,'---- TREASURY SYMBOL:'||O_SF133_TS_VALUE
1862: ||' Line Id:'||o_sf133_line_id
1863: ||' Col:' ||o_sf133_column_number
1864: ||' Amt:' ||o_sf133_column_amount);

Line 1861: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name,'---- TREASURY SYMBOL:'||O_SF133_TS_VALUE

1857: g_error_message := SQLERRM;
1858:
1859: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception', g_error_message) ;
1860: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name,'-- POPULATE_TEMP_TABLE');
1861: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name,'---- TREASURY SYMBOL:'||O_SF133_TS_VALUE
1862: ||' Line Id:'||o_sf133_line_id
1863: ||' Col:' ||o_sf133_column_number
1864: ||' Amt:' ||o_sf133_column_amount);
1865: --

Line 1899: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception', g_error_message) ;

1895: EXCEPTION
1896: WHEN OTHERS THEN
1897: g_error_code := SQLCODE;
1898: g_error_message := SQLERRM;
1899: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception', g_error_message) ;
1900: RAISE ;
1901:
1902: END GET_BEGIN_ENDING_PERIODS ;
1903:

Line 1996: IF ( fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1992:
1993: BEGIN
1994: l_module_name := g_module_name || 'populate_gtt_with_ccid';
1995:
1996: IF ( fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1997: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'Entering Module '||l_module_name);
1998: END IF;
1999:
2000: FOR crec_rec IN crec_cursor (parm_set_of_books_id) LOOP

Line 1997: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'Entering Module '||l_module_name);

1993: BEGIN
1994: l_module_name := g_module_name || 'populate_gtt_with_ccid';
1995:
1996: IF ( fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1997: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'Entering Module '||l_module_name);
1998: END IF;
1999:
2000: FOR crec_rec IN crec_cursor (parm_set_of_books_id) LOOP
2001:

Line 2002: IF ( fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1998: END IF;
1999:
2000: FOR crec_rec IN crec_cursor (parm_set_of_books_id) LOOP
2001:
2002: IF ( fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2003: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'sf133_line_acct_id = '||crec_rec.sf133_line_acct_id);
2004: END IF;
2005:
2006: v_seg(1) := crec_rec.segment1;

Line 2003: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'sf133_line_acct_id = '||crec_rec.sf133_line_acct_id);

1999:
2000: FOR crec_rec IN crec_cursor (parm_set_of_books_id) LOOP
2001:
2002: IF ( fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2003: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'sf133_line_acct_id = '||crec_rec.sf133_line_acct_id);
2004: END IF;
2005:
2006: v_seg(1) := crec_rec.segment1;
2007: v_seg(2) := crec_rec.segment2;

Line 2041: IF ( fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

2037: v_statement := NULL;
2038:
2039: FOR i IN 1 ..30 LOOP
2040: v_seg_str(i) := NULL;
2041: IF ( fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2042: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'v_seg('||i||')='||v_seg(i));
2043: END IF;
2044: END LOOP;
2045:

Line 2042: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'v_seg('||i||')='||v_seg(i));

2038:
2039: FOR i IN 1 ..30 LOOP
2040: v_seg_str(i) := NULL;
2041: IF ( fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2042: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'v_seg('||i||')='||v_seg(i));
2043: END IF;
2044: END LOOP;
2045:
2046: l_no_of_seg := 0;

Line 2049: IF ( fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

2045:
2046: l_no_of_seg := 0;
2047:
2048: FOR flex_rec IN flex_cursor (g_chart_of_accounts_id) LOOP
2049: IF ( fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2050: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'application_column_name = '||flex_rec.application_column_name);
2051: END IF;
2052: l_no_of_child := 0;
2053: l_and := NULL;

Line 2050: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'application_column_name = '||flex_rec.application_column_name);

2046: l_no_of_seg := 0;
2047:
2048: FOR flex_rec IN flex_cursor (g_chart_of_accounts_id) LOOP
2049: IF ( fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2050: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'application_column_name = '||flex_rec.application_column_name);
2051: END IF;
2052: l_no_of_child := 0;
2053: l_and := NULL;
2054:

Line 2057: IF ( fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

2053: l_and := NULL;
2054:
2055: /* check the segment values is parent */
2056: l_segno := SUBSTR(flex_rec.application_column_name,8,2);
2057: IF ( fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2058: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'l_segno = '||l_segno);
2059: END IF;
2060:
2061: IF (v_seg(l_segno) IS NOT NULL) THEN

Line 2058: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'l_segno = '||l_segno);

2054:
2055: /* check the segment values is parent */
2056: l_segno := SUBSTR(flex_rec.application_column_name,8,2);
2057: IF ( fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2058: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'l_segno = '||l_segno);
2059: END IF;
2060:
2061: IF (v_seg(l_segno) IS NOT NULL) THEN
2062: SELECT COUNT(*)

Line 2068: IF ( fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

2064: FROM fnd_flex_value_hierarchies
2065: WHERE parent_flex_value = v_seg(l_segno)
2066: AND flex_value_set_id = flex_rec.flex_value_set_id;
2067:
2068: IF ( fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2069: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'l_cnt = '||l_cnt);
2070: END IF;
2071:
2072: OPEN child_value_cursor(v_seg(l_segno) , flex_rec.flex_value_set_id);

Line 2069: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'l_cnt = '||l_cnt);

2065: WHERE parent_flex_value = v_seg(l_segno)
2066: AND flex_value_set_id = flex_rec.flex_value_set_id;
2067:
2068: IF ( fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2069: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'l_cnt = '||l_cnt);
2070: END IF;
2071:
2072: OPEN child_value_cursor(v_seg(l_segno) , flex_rec.flex_value_set_id);
2073:

Line 2075: IF ( fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

2071:
2072: OPEN child_value_cursor(v_seg(l_segno) , flex_rec.flex_value_set_id);
2073:
2074: IF (l_cnt > 0) THEN
2075: IF ( fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2076: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'l_cnt > 0');
2077: END IF;
2078:
2079: l_and := NULL;

Line 2076: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'l_cnt > 0');

2072: OPEN child_value_cursor(v_seg(l_segno) , flex_rec.flex_value_set_id);
2073:
2074: IF (l_cnt > 0) THEN
2075: IF ( fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2076: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'l_cnt > 0');
2077: END IF;
2078:
2079: l_and := NULL;
2080:

Line 2112: IF ( fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

2108: l_and := NULL;
2109: v_statement := v_statement || l_and || l_child || fnd_global.local_chr(10);
2110:
2111: ELSE
2112: IF ( fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2113: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'l_cnt not > 0');
2114: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'l_no_of_seg='||l_no_of_seg);
2115: END IF;
2116: IF (l_no_of_seg > 0) THEN

Line 2113: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'l_cnt not > 0');

2109: v_statement := v_statement || l_and || l_child || fnd_global.local_chr(10);
2110:
2111: ELSE
2112: IF ( fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2113: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'l_cnt not > 0');
2114: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'l_no_of_seg='||l_no_of_seg);
2115: END IF;
2116: IF (l_no_of_seg > 0) THEN
2117: l_and := ' AND ';

Line 2114: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'l_no_of_seg='||l_no_of_seg);

2110:
2111: ELSE
2112: IF ( fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2113: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'l_cnt not > 0');
2114: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'l_no_of_seg='||l_no_of_seg);
2115: END IF;
2116: IF (l_no_of_seg > 0) THEN
2117: l_and := ' AND ';
2118: END IF;

Line 2131: IF ( fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

2127: END IF; --v_seg(l_segno) IS NOT NULL
2128:
2129: END LOOP; --FLEX_CURSOR
2130:
2131: IF ( fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2132: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'v_statement = '||v_statement);
2133: END IF;
2134:
2135: IF (v_statement IS NOT NULL) THEN

Line 2132: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'v_statement = '||v_statement);

2128:
2129: END LOOP; --FLEX_CURSOR
2130:
2131: IF ( fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2132: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'v_statement = '||v_statement);
2133: END IF;
2134:
2135: IF (v_statement IS NOT NULL) THEN
2136: v_insert_statement := 'INSERT INTO fv_sf133_ccids_gt

Line 2168: IF ( fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

2164: crec_rec.sf133_line_acct_id;
2165: END IF;
2166: END LOOP; --crec_cursor
2167:
2168: IF ( fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2169: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'Exiting Module = '||l_module_name);
2170: END IF;
2171:
2172: EXCEPTION

Line 2169: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'Exiting Module = '||l_module_name);

2165: END IF;
2166: END LOOP; --crec_cursor
2167:
2168: IF ( fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2169: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'Exiting Module = '||l_module_name);
2170: END IF;
2171:
2172: EXCEPTION
2173: WHEN OTHERS THEN

Line 2176: fv_utility.log_mesg(fnd_log.level_unexpected, l_module_name||'.exception',g_error_message);

2172: EXCEPTION
2173: WHEN OTHERS THEN
2174: g_error_code := SQLCODE;
2175: g_error_message := SQLERRM;
2176: fv_utility.log_mesg(fnd_log.level_unexpected, l_module_name||'.exception',g_error_message);
2177: fv_utility.log_mesg(fnd_log.level_unexpected, l_module_name||'.exception','-- populate_gtt_with_ccid');
2178: END;
2179: /*Procedure to fetch balance type for accounts which contain ending and/or begining balances
2180: of type either credit or debit or both*/

Line 2177: fv_utility.log_mesg(fnd_log.level_unexpected, l_module_name||'.exception','-- populate_gtt_with_ccid');

2173: WHEN OTHERS THEN
2174: g_error_code := SQLCODE;
2175: g_error_message := SQLERRM;
2176: fv_utility.log_mesg(fnd_log.level_unexpected, l_module_name||'.exception',g_error_message);
2177: fv_utility.log_mesg(fnd_log.level_unexpected, l_module_name||'.exception','-- populate_gtt_with_ccid');
2178: END;
2179: /*Procedure to fetch balance type for accounts which contain ending and/or begining balances
2180: of type either credit or debit or both*/
2181: PROCEDURE GET_BAL_TYPE

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

2199: dbms_sql.define_column(v_cursor_id_ind, 1,DSum_E);
2200: dbms_sql.define_column(v_cursor_id_ind, 2,CSum_E);
2201:
2202: l_ignore1 := dbms_sql.execute_and_fetch(v_cursor_id_ind);
2203: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2204: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, 'testsf133','l_ignore1 := '||l_ignore1);
2205: END IF;
2206: dbms_sql.column_value(v_cursor_id_ind, 1, DSum_E);
2207: dbms_sql.column_value(v_cursor_id_ind, 2, CSum_E);

Line 2204: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, 'testsf133','l_ignore1 := '||l_ignore1);

2200: dbms_sql.define_column(v_cursor_id_ind, 2,CSum_E);
2201:
2202: l_ignore1 := dbms_sql.execute_and_fetch(v_cursor_id_ind);
2203: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2204: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, 'testsf133','l_ignore1 := '||l_ignore1);
2205: END IF;
2206: dbms_sql.column_value(v_cursor_id_ind, 1, DSum_E);
2207: dbms_sql.column_value(v_cursor_id_ind, 2, CSum_E);
2208: --dbms_sql.close_cursor(v_cursor_id_ind);

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

2228: dbms_sql.define_column(v_cursor_id_ind, 1,DSum_B);
2229: dbms_sql.define_column(v_cursor_id_ind, 2,CSum_B);
2230:
2231: l_ignore1 := dbms_sql.execute_and_fetch(v_cursor_id_ind);
2232: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2233: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, 'testsf133','l_ignore1 := '||l_ignore1);
2234: END IF;
2235: dbms_sql.column_value(v_cursor_id_ind, 1, DSum_B);
2236: dbms_sql.column_value(v_cursor_id_ind, 2, CSum_B);

Line 2233: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, 'testsf133','l_ignore1 := '||l_ignore1);

2229: dbms_sql.define_column(v_cursor_id_ind, 2,CSum_B);
2230:
2231: l_ignore1 := dbms_sql.execute_and_fetch(v_cursor_id_ind);
2232: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2233: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, 'testsf133','l_ignore1 := '||l_ignore1);
2234: END IF;
2235: dbms_sql.column_value(v_cursor_id_ind, 1, DSum_B);
2236: dbms_sql.column_value(v_cursor_id_ind, 2, CSum_B);
2237: --dbms_sql.close_cursor(v_cursor_id_ind);

Line 2249: fv_utility.log_mesg(fnd_log.level_unexpected, 'testsf133'||'.exception',g_error_message);

2245: EXCEPTION
2246: WHEN OTHERS THEN
2247: g_error_code := SQLCODE;
2248: g_error_message := SQLERRM;
2249: fv_utility.log_mesg(fnd_log.level_unexpected, 'testsf133'||'.exception',g_error_message);
2250: fv_utility.log_mesg(fnd_log.level_unexpected, 'testsf133'||'.exception','-- get_bal_type');
2251: END;
2252:
2253:

Line 2250: fv_utility.log_mesg(fnd_log.level_unexpected, 'testsf133'||'.exception','-- get_bal_type');

2246: WHEN OTHERS THEN
2247: g_error_code := SQLCODE;
2248: g_error_message := SQLERRM;
2249: fv_utility.log_mesg(fnd_log.level_unexpected, 'testsf133'||'.exception',g_error_message);
2250: fv_utility.log_mesg(fnd_log.level_unexpected, 'testsf133'||'.exception','-- get_bal_type');
2251: END;
2252:
2253:
2254: PROCEDURE process_total_line

Line 2332: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,'Inside process_total_line');

2328: v_col_6_amt fv_sf133_definitions_cols_temp.sf133_column_6_amount%TYPE;
2329:
2330:
2331: BEGIN
2332: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,'Inside process_total_line');
2333: FOR calc_rec IN fv_sf133_calc_cur
2334: LOOP
2335: amt_array(amt_array_cnt).calc_sequence := calc_rec.calc_sequence_number;
2336:

Line 2385: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,calc_rec.operator||amt_array(amt_array_cnt).col_1_amt);

2381: amt_array(amt_array_cnt).col_3_amt := NVL(temp_amt_low_3, 0) + NVL(temp_amt_high_3, 0);
2382: amt_array(amt_array_cnt).col_4_amt := NVL(temp_amt_low_4, 0) + NVL(temp_amt_high_4, 0);
2383: amt_array(amt_array_cnt).col_5_amt := NVL(temp_amt_low_5, 0) + NVL(temp_amt_high_5, 0);
2384: amt_array(amt_array_cnt).col_6_amt := NVL(temp_amt_low_6, 0) + NVL(temp_amt_high_6, 0);
2385: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,calc_rec.operator||amt_array(amt_array_cnt).col_1_amt);
2386:
2387: ELSIF calc_rec.operator = '-' THEN
2388: amt_array(amt_array_cnt).col_1_amt := NVL(temp_amt_low, 0) - NVL(temp_amt_high, 0);
2389: amt_array(amt_array_cnt).col_2_amt := NVL(temp_amt_low_2, 0) - NVL(temp_amt_high_2, 0);

Line 2394: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,calc_rec.operator||amt_array(amt_array_cnt).col_1_amt);

2390: amt_array(amt_array_cnt).col_3_amt := NVL(temp_amt_low_3, 0) - NVL(temp_amt_high_3, 0);
2391: amt_array(amt_array_cnt).col_4_amt := NVL(temp_amt_low_4, 0) - NVL(temp_amt_high_4, 0);
2392: amt_array(amt_array_cnt).col_5_amt := NVL(temp_amt_low_5, 0) - NVL(temp_amt_high_5, 0);
2393: amt_array(amt_array_cnt).col_6_amt := NVL(temp_amt_low_6, 0) - NVL(temp_amt_high_6, 0);
2394: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,calc_rec.operator||amt_array(amt_array_cnt).col_1_amt);
2395: ELSE
2396: IF calc_rec.line_low_type = 'L' THEN
2397: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,'inside for loop, range:'||calc_rec.line_low||calc_rec.line_high);
2398: FOR lines_rec IN fv_cfs_lines_cur(calc_rec.line_low, calc_rec.line_high)

Line 2397: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,'inside for loop, range:'||calc_rec.line_low||calc_rec.line_high);

2393: amt_array(amt_array_cnt).col_6_amt := NVL(temp_amt_low_6, 0) - NVL(temp_amt_high_6, 0);
2394: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,calc_rec.operator||amt_array(amt_array_cnt).col_1_amt);
2395: ELSE
2396: IF calc_rec.line_low_type = 'L' THEN
2397: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,'inside for loop, range:'||calc_rec.line_low||calc_rec.line_high);
2398: FOR lines_rec IN fv_cfs_lines_cur(calc_rec.line_low, calc_rec.line_high)
2399: LOOP
2400: FOR fv_sf133_temp_cur_rec IN fv_sf133_temp_cur(lines_rec.sf133_line_id)
2401: LOOP

Line 2408: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,'inside for loop, value for line'||amt_array(amt_array_cnt).col_1_amt);

2404: amt_array(amt_array_cnt).col_3_amt := amt_array(amt_array_cnt).col_3_amt + NVL(fv_sf133_temp_cur_rec.sf133_column_3_amount, 0);
2405: amt_array(amt_array_cnt).col_4_amt := amt_array(amt_array_cnt).col_4_amt + NVL(fv_sf133_temp_cur_rec.sf133_column_4_amount, 0);
2406: amt_array(amt_array_cnt).col_5_amt := amt_array(amt_array_cnt).col_5_amt + NVL(fv_sf133_temp_cur_rec.sf133_column_5_amount, 0);
2407: amt_array(amt_array_cnt).col_6_amt := amt_array(amt_array_cnt).col_6_amt + NVL(fv_sf133_temp_cur_rec.sf133_column_6_amount, 0);
2408: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,'inside for loop, value for line'||amt_array(amt_array_cnt).col_1_amt);
2409: END LOOP;
2410: END LOOP;
2411: ELSIF calc_rec.line_low_type = 'C' THEN
2412: FOR i IN 1..amt_array_cnt - 1

Line 2422: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,'inside for loop, value for calc sequence'||amt_array(amt_array_cnt).col_1_amt);

2418: amt_array(amt_array_cnt).col_3_amt := amt_array(amt_array_cnt).col_3_amt + NVL(amt_array(i).col_3_amt, 0);
2419: amt_array(amt_array_cnt).col_4_amt := amt_array(amt_array_cnt).col_4_amt + NVL(amt_array(i).col_4_amt, 0);
2420: amt_array(amt_array_cnt).col_5_amt := amt_array(amt_array_cnt).col_5_amt + NVL(amt_array(i).col_5_amt, 0);
2421: amt_array(amt_array_cnt).col_6_amt := amt_array(amt_array_cnt).col_6_amt + NVL(amt_array(i).col_6_amt, 0);
2422: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,'inside for loop, value for calc sequence'||amt_array(amt_array_cnt).col_1_amt);
2423: END IF;
2424: END LOOP;
2425: END IF;
2426: END IF;

Line 2454: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'end of process_total_line: '||o_sf133_ts_value||o_sf133_column_amount);

2450: c_sf133_amt5_not_shown := v_col_5_amt;
2451: c_sf133_column_amount6 := v_col_6_amt;
2452: c_sf133_amt6_not_shown := v_col_6_amt;
2453: o_sf133_treasury_symbol_id := c_sf133_treasury_symbol_id; --added for 1575992
2454: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'end of process_total_line: '||o_sf133_ts_value||o_sf133_column_amount);
2455:
2456: populate_temp_table;
2457:
2458: -- Bug 9183877

Line 2481: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',g_error_message);

2477: EXCEPTION
2478: WHEN OTHERS THEN
2479: g_error_code := SQLCODE ;
2480: g_error_message := SQLERRM || ' [PROCESS_TOTAL_LINE] ' ;
2481: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',g_error_message);
2482: RETURN;
2483: END process_total_line;
2484: -- + Global Varibale Declaration +
2485: BEGIN