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

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

291: g_chart_of_accounts_id
292: from gl_ledgers
293: where ledger_id = parm_set_of_books_id;
294:
295: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
296: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'-- APID('||NVL(PARM_APPLICATION_ID,0) ||')'
297: ||' SoB('||NVL(parm_set_of_books_id,0) ||')'
298: ||' Year('||NVL(parm_gl_period_year,0) ||')'
299: ||' Period('||NVL(parm_gl_period_num,0) ||')'

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

292: from gl_ledgers
293: where ledger_id = parm_set_of_books_id;
294:
295: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
296: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'-- APID('||NVL(PARM_APPLICATION_ID,0) ||')'
297: ||' SoB('||NVL(parm_set_of_books_id,0) ||')'
298: ||' Year('||NVL(parm_gl_period_year,0) ||')'
299: ||' Period('||NVL(parm_gl_period_num,0) ||')'
300: ||' Fund Code('||NVL(parm_treasury_value_r1,'Null')

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

326: LOOP
327: parm_treasury_value_r1 := ts_rec.treasury_symbol;
328: parm_tsymbol_id := ts_rec.treasury_symbol_id;
329:
330: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
331: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'PROCESSING TREASURY SYMBOL... '||PARM_TREASURY_VALUE_R1) ;
332: END IF;
333:
334: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

327: parm_treasury_value_r1 := ts_rec.treasury_symbol;
328: parm_tsymbol_id := ts_rec.treasury_symbol_id;
329:
330: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
331: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'PROCESSING TREASURY SYMBOL... '||PARM_TREASURY_VALUE_R1) ;
332: END IF;
333:
334: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
335: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'SUBMITTING FACTS II process FOR TS.....'||PARM_TREASURY_VALUE_R1);

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

330: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
331: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'PROCESSING TREASURY SYMBOL... '||PARM_TREASURY_VALUE_R1) ;
332: END IF;
333:
334: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
335: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'SUBMITTING FACTS II process FOR TS.....'||PARM_TREASURY_VALUE_R1);
336: END IF;
337:
338: select period_num

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

331: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'PROCESSING TREASURY SYMBOL... '||PARM_TREASURY_VALUE_R1) ;
332: END IF;
333:
334: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
335: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'SUBMITTING FACTS II process FOR TS.....'||PARM_TREASURY_VALUE_R1);
336: END IF;
337:
338: select period_num
339: into report_period_num

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

349: contact_extn, contact_email, contact_fax, contact_maiden, supervisor_name,
350: supervisor_phone, supervisor_extn, agency_name_1,
351: agency_name_2, address_1, address_2, city, state, zip, g_currency_code);
352:
353: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
354: 'retcode_facts is '||retcode_facts|| 'FV_FACTS_TRANSACTIONS.v_g_edit_check_code' || FV_FACTS_TRANSACTIONS.v_g_edit_check_code);
355: if (retcode_facts <> 0 )then
356: if (retcode_facts =1 )then
357: if (FV_FACTS_TRANSACTIONS.v_g_edit_check_code = 2)then

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

354: 'retcode_facts is '||retcode_facts|| 'FV_FACTS_TRANSACTIONS.v_g_edit_check_code' || FV_FACTS_TRANSACTIONS.v_g_edit_check_code);
355: if (retcode_facts <> 0 )then
356: if (retcode_facts =1 )then
357: if (FV_FACTS_TRANSACTIONS.v_g_edit_check_code = 2)then
358: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
359: 'Required Edits failed for the Treasury Symbol...'||
360: PARM_TREASURY_VALUE_R1||errbuf_facts);
361: retcode :=1;
362: --return; bug 9191060; if edits fail for one process, the other processes should continue

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

362: --return; bug 9191060; if edits fail for one process, the other processes should continue
363: END IF;
364: end if;
365:
366: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
367: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
368: 'Unable to process FACTS II in SF133 for TS ...'||
369: PARM_TREASURY_VALUE_R1||errbuf_facts);
370: END IF;

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

363: END IF;
364: end if;
365:
366: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
367: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
368: 'Unable to process FACTS II in SF133 for TS ...'||
369: PARM_TREASURY_VALUE_R1||errbuf_facts);
370: END IF;
371: end if; -- end for if retcode_facts <> 0

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

376: IF g_error_code <> 0 THEN
377: errbuf := errbuf || 'Processing for Treasury Symbol '||
378: parm_treasury_value_r1||' FAILED'|| g_error_message;
379: ELSE
380: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
381: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
382: 'SUBMITTING SF133 REPORT FOR TS.....'||PARM_TREASURY_VALUE_R1);
383: END IF;
384:

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

377: errbuf := errbuf || 'Processing for Treasury Symbol '||
378: parm_treasury_value_r1||' FAILED'|| g_error_message;
379: ELSE
380: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
381: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
382: 'SUBMITTING SF133 REPORT FOR TS.....'||PARM_TREASURY_VALUE_R1);
383: END IF;
384:
385: l_req_id :=

Line 392: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,ERRBUF) ;

388:
389: IF l_req_id = 0 THEN
390: errbuf := 'Error submitting SF133 Report for Treasury Symbol ' || parm_treasury_value_r1;
391: retcode := -1 ;
392: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,ERRBUF) ;
393: return;
394: ELSE
395: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
396: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,

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

391: retcode := -1 ;
392: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,ERRBUF) ;
393: return;
394: ELSE
395: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
396: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
397: 'CONCURRENT REQUEST ID FOR SF133 REPORT - ' || l_req_id);
398: END IF;
399: END IF; -- end of IF l_req_id = 0 THEN

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

392: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,ERRBUF) ;
393: return;
394: ELSE
395: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
396: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
397: 'CONCURRENT REQUEST ID FOR SF133 REPORT - ' || l_req_id);
398: END IF;
399: END IF; -- end of IF l_req_id = 0 THEN
400: END IF; -- end of IF g_error_code <> 0

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

410: --
411: IF errbuf IS NULL THEN
412: errbuf := 'Normal End of FVSF133 Package';
413: END IF;
414: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
415: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,ERRBUF);
416: END IF;
417:
418: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

411: IF errbuf IS NULL THEN
412: errbuf := 'Normal End of FVSF133 Package';
413: END IF;
414: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
415: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,ERRBUF);
416: END IF;
417:
418: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
419: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'-- INSERT COUNT('||G_INSERT_COUNT||')');

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

414: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
415: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,ERRBUF);
416: END IF;
417:
418: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
419: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'-- INSERT COUNT('||G_INSERT_COUNT||')');
420: END IF;
421: if retcode <>1 then
422: retcode := g_error_code;

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

415: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,ERRBUF);
416: END IF;
417:
418: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
419: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'-- INSERT COUNT('||G_INSERT_COUNT||')');
420: END IF;
421: if retcode <>1 then
422: retcode := g_error_code;
423: end if; -- if hard edits fail for atleast one process, the SF133 process should end in warning

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

421: if retcode <>1 then
422: retcode := g_error_code;
423: end if; -- if hard edits fail for atleast one process, the SF133 process should end in warning
424: errbuf := 'Normal End of FVSF133 Package';
425: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
426: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,ERRBUF);
427: END IF;
428: sf133_runmode := 'NO';
429: --

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

422: retcode := g_error_code;
423: end if; -- if hard edits fail for atleast one process, the SF133 process should end in warning
424: errbuf := 'Normal End of FVSF133 Package';
425: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
426: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,ERRBUF);
427: END IF;
428: sf133_runmode := 'NO';
429: --
430: -- ------------------------------------

Line 439: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,ERRBUF);

435:
436: WHEN abort_error THEN
437: retcode := g_error_code;
438: errbuf := g_error_message;
439: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,ERRBUF);
440: --
441: WHEN OTHERS THEN
442: retcode := SQLCODE;
443: errbuf := SQLERRM;

Line 444: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name,errbuf);

440: --
441: WHEN OTHERS THEN
442: retcode := SQLCODE;
443: errbuf := SQLERRM;
444: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name,errbuf);
445: RAISE_APPLICATION_ERROR(-20222,
446: 'FVSF133 Exception-'||SQLERRM);
447: --
448:

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

464: BEGIN
465: l_module_name := g_module_name || 'determine_acct_flex_segments';
466: --
467: IF parm_run_mode = 'T' THEN
468: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
469: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'START DETERMINE_ACCT_FLEX_SEGMENTS');
470: END IF;
471: END IF;
472: --

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

465: l_module_name := g_module_name || 'determine_acct_flex_segments';
466: --
467: IF parm_run_mode = 'T' THEN
468: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
469: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'START DETERMINE_ACCT_FLEX_SEGMENTS');
470: END IF;
471: END IF;
472: --
473: -- -------------------------------------

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

572: AND id_flex_code = 'GL#'
573: AND id_flex_num = g_chart_of_accounts_id;
574: EXCEPTION
575: WHEN OTHERS THEN
576: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,'Error in getting the Value set attched '
577: || ' to the segemnt => ' || c_flex_column_name);
578: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,' SQLCODE => ' || SQLCODE ||
579: ' SQLERRM => ' || SQLERRM);
580: RAISE;

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

574: EXCEPTION
575: WHEN OTHERS THEN
576: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,'Error in getting the Value set attched '
577: || ' to the segemnt => ' || c_flex_column_name);
578: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,' SQLCODE => ' || SQLCODE ||
579: ' SQLERRM => ' || SQLERRM);
580: RAISE;
581: END;
582: -- + Rollup for the amount is the segment is a parent segment +

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

618: dbms_sql.bind_variable(v_cursor_id, ':cv_coa_id', g_chart_of_accounts_id);*/
619:
620: --
621:
622: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
623: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,V_SELECT);
624: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, 'testsf133',V_SELECT);
625: END IF;
626: --

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

619:
620: --
621:
622: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
623: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,V_SELECT);
624: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, 'testsf133',V_SELECT);
625: END IF;
626: --
627: -- ------------------------------------

Line 624: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, 'testsf133',V_SELECT);

620: --
621:
622: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
623: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,V_SELECT);
624: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, 'testsf133',V_SELECT);
625: END IF;
626: --
627: -- ------------------------------------
628: -- Exceptions

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

634: close flex_field_column_name_cursor;
635: END IF;
636: g_error_code := SQLCODE;
637: g_error_message := 'determine_acct_flex_segments/'||SQLERRM;
638: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.exception',g_error_message);
639: --
640: END determine_acct_flex_segments;
641: -- --------------------------------------------------------
642: -- --------------------------------------------------------

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

648: BEGIN
649: l_module_name := g_module_name || 'purge_temp_table';
650: --
651: IF parm_run_mode = 'T' THEN
652: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
653: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'START PURGE_TEMP_TABLE');
654: END IF;
655: END IF;
656: --

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

649: l_module_name := g_module_name || 'purge_temp_table';
650: --
651: IF parm_run_mode = 'T' THEN
652: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
653: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'START PURGE_TEMP_TABLE');
654: END IF;
655: END IF;
656: --
657: DELETE

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

674: --
675: WHEN OTHERS THEN
676: g_error_code := SQLCODE;
677: g_error_message := 'purge_temp_table/'||SQLERRM;
678: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.exception',g_error_message);
679: --
680: END purge_temp_table;
681: -- --------------------------------------------------------
682: -- --------------------------------------------------------

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

690: BEGIN
691: l_module_name := g_module_name || 'build_report_lines';
692: --
693: IF parm_run_mode = 'T' THEN
694: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
695: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'START BUILD_REPORT_LINES');
696: END IF;
697: END IF;
698: --

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

691: l_module_name := g_module_name || 'build_report_lines';
692: --
693: IF parm_run_mode = 'T' THEN
694: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
695: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'START BUILD_REPORT_LINES');
696: END IF;
697: END IF;
698: --
699: -- ----------------------------------------

Line 751: 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.');

747: INTO l_line_cnt
748: FROM fv_sf133_rep_line_calc
749: WHERE line_id = c_sf133_line_id;
750: IF l_line_cnt = 0 THEN
751: 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.');
752: RETURN;
753: END IF;
754: process_total_line;
755: END IF; -- end of IF c_sf133_line_type_code = 'D' or c_sf133_line_type_code = 'D2' THEN

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

767: close ts_report_line_cursor;
768: END IF;
769: g_error_code := SQLCODE;
770: g_error_message := SQLERRM;
771: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.exception','BUILD_REPORT_LINES');
772: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.exception',g_error_message);
773: --
774: END build_report_lines;
775: -- --------------------------------------------------------

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

768: END IF;
769: g_error_code := SQLCODE;
770: g_error_message := SQLERRM;
771: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.exception','BUILD_REPORT_LINES');
772: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.exception',g_error_message);
773: --
774: END build_report_lines;
775: -- --------------------------------------------------------
776: -- ----------------------------------------------

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

792: l_module_name := g_module_name || 'build_fiscal_line_columns';
793:
794: --
795: IF parm_run_mode = 'T' THEN
796: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
797: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'START BUILD_FISCAL_LINE_COLUMNS');
798: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, '-- LINE('||C_SF133_LINE_NUMBER||')'
799: || ' Tresury Symbol('||c_sf133_ts_value ||')'
800: || ' '||to_char(SYSDATE,'mm/dd/yyyy hh:mi:ss'));

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

793:
794: --
795: IF parm_run_mode = 'T' THEN
796: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
797: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'START BUILD_FISCAL_LINE_COLUMNS');
798: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, '-- LINE('||C_SF133_LINE_NUMBER||')'
799: || ' Tresury Symbol('||c_sf133_ts_value ||')'
800: || ' '||to_char(SYSDATE,'mm/dd/yyyy hh:mi:ss'));
801: END IF;

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

794: --
795: IF parm_run_mode = 'T' THEN
796: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
797: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'START BUILD_FISCAL_LINE_COLUMNS');
798: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, '-- LINE('||C_SF133_LINE_NUMBER||')'
799: || ' Tresury Symbol('||c_sf133_ts_value ||')'
800: || ' '||to_char(SYSDATE,'mm/dd/yyyy hh:mi:ss'));
801: END IF;
802: END IF;

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

1037:
1038: v_cursor_id := dbms_sql.open_cursor;
1039: query_fetch_bal := query_fetch_bal ||' '|| where_clause;
1040: -- print query
1041: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,query_fetch_bal);
1042:
1043: dbms_sql.parse(v_cursor_id, query_fetch_bal, dbms_sql.v7);
1044: dbms_sql.define_column(v_cursor_id, 1, c_total_balance);
1045: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_acct_id',c_sf133_line_acct_id);

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

1046: dbms_sql.bind_variable(v_cursor_id,':cv_treasury_symbol_id',parm_tsymbol_id);
1047: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_id',c_sf133_line_id);
1048:
1049: --print bind variables
1050: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sf133_balance_type:'||c_sf133_balance_type);
1051: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_treasury_symbol_id:'||parm_tsymbol_id);
1052: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_sf133_line_acct_id:'||c_sf133_line_acct_id);
1053: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sf133_line_id:'||c_sf133_line_id);
1054:

Line 1051: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_treasury_symbol_id:'||parm_tsymbol_id);

1047: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_id',c_sf133_line_id);
1048:
1049: --print bind variables
1050: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sf133_balance_type:'||c_sf133_balance_type);
1051: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_treasury_symbol_id:'||parm_tsymbol_id);
1052: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_sf133_line_acct_id:'||c_sf133_line_acct_id);
1053: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sf133_line_id:'||c_sf133_line_id);
1054:
1055:

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

1048:
1049: --print bind variables
1050: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sf133_balance_type:'||c_sf133_balance_type);
1051: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_treasury_symbol_id:'||parm_tsymbol_id);
1052: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_sf133_line_acct_id:'||c_sf133_line_acct_id);
1053: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sf133_line_id:'||c_sf133_line_id);
1054:
1055:
1056: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);

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

1049: --print bind variables
1050: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sf133_balance_type:'||c_sf133_balance_type);
1051: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_treasury_symbol_id:'||parm_tsymbol_id);
1052: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_sf133_line_acct_id:'||c_sf133_line_acct_id);
1053: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sf133_line_id:'||c_sf133_line_id);
1054:
1055:
1056: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
1057:

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

1054:
1055:
1056: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
1057:
1058: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1059: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'l_ignore := '||l_ignore);
1060: END IF;
1061:
1062: dbms_sql.column_value(v_cursor_id, 1, c_total_balance);

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

1055:
1056: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
1057:
1058: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1059: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'l_ignore := '||l_ignore);
1060: END IF;
1061:
1062: dbms_sql.column_value(v_cursor_id, 1, c_total_balance);
1063: dbms_sql.close_cursor(v_cursor_id);

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

1060: END IF;
1061:
1062: dbms_sql.column_value(v_cursor_id, 1, c_total_balance);
1063: dbms_sql.close_cursor(v_cursor_id);
1064: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance:'||c_total_balance);
1065: end if;
1066:
1067: -- End the code for bal type beginning and ending
1068:

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

1089: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_acct_id',c_sf133_line_acct_id);
1090: dbms_sql.bind_variable(v_cursor_id,':cv_treasury_symbol_id',parm_tsymbol_id);
1091: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_id',c_sf133_line_id);
1092: -- print query
1093: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,query_fetch_bal);
1094:
1095: --print bind variables
1096: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sf133_balance_type:'||c_sf133_balance_type);
1097: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_treasury_symbol_id:'||parm_tsymbol_id);

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

1092: -- print query
1093: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,query_fetch_bal);
1094:
1095: --print bind variables
1096: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sf133_balance_type:'||c_sf133_balance_type);
1097: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_treasury_symbol_id:'||parm_tsymbol_id);
1098: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_sf133_line_acct_id:'||c_sf133_line_acct_id);
1099: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sf133_line_id:'||c_sf133_line_id);
1100:

Line 1097: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_treasury_symbol_id:'||parm_tsymbol_id);

1093: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,query_fetch_bal);
1094:
1095: --print bind variables
1096: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sf133_balance_type:'||c_sf133_balance_type);
1097: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_treasury_symbol_id:'||parm_tsymbol_id);
1098: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_sf133_line_acct_id:'||c_sf133_line_acct_id);
1099: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sf133_line_id:'||c_sf133_line_id);
1100:
1101: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);

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

1094:
1095: --print bind variables
1096: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sf133_balance_type:'||c_sf133_balance_type);
1097: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_treasury_symbol_id:'||parm_tsymbol_id);
1098: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_sf133_line_acct_id:'||c_sf133_line_acct_id);
1099: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sf133_line_id:'||c_sf133_line_id);
1100:
1101: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
1102:

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

1095: --print bind variables
1096: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sf133_balance_type:'||c_sf133_balance_type);
1097: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_treasury_symbol_id:'||parm_tsymbol_id);
1098: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_sf133_line_acct_id:'||c_sf133_line_acct_id);
1099: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sf133_line_id:'||c_sf133_line_id);
1100:
1101: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
1102:
1103: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

1099: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sf133_line_id:'||c_sf133_line_id);
1100:
1101: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
1102:
1103: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1104: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'l_ignore := '||l_ignore);
1105: END IF;
1106:
1107: dbms_sql.column_value(v_cursor_id, 1, c_total_balance);

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

1100:
1101: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
1102:
1103: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1104: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'l_ignore := '||l_ignore);
1105: END IF;
1106:
1107: dbms_sql.column_value(v_cursor_id, 1, c_total_balance);
1108: dbms_sql.close_cursor(v_cursor_id);

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

1105: END IF;
1106:
1107: dbms_sql.column_value(v_cursor_id, 1, c_total_balance);
1108: dbms_sql.close_cursor(v_cursor_id);
1109: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance:'||c_total_balance);
1110:
1111: elsif (( c_sf133_line_type_code = 'D' AND c_sf133_natural_bal_type ='C') or
1112: ( c_sf133_line_type_code = 'D2' AND c_sf133_natural_bal_type ='D'))then
1113:

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

1128: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_acct_id',c_sf133_line_acct_id);
1129: dbms_sql.bind_variable(v_cursor_id,':cv_treasury_symbol_id',parm_tsymbol_id);
1130: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_id',c_sf133_line_id);
1131: -- print query
1132: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,query_fetch_bal);
1133:
1134: --print bind variables
1135: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sf133_balance_type:'||c_sf133_balance_type);
1136: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_treasury_symbol_id:'||parm_tsymbol_id);

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

1131: -- print query
1132: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,query_fetch_bal);
1133:
1134: --print bind variables
1135: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sf133_balance_type:'||c_sf133_balance_type);
1136: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_treasury_symbol_id:'||parm_tsymbol_id);
1137: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_sf133_line_acct_id:'||c_sf133_line_acct_id);
1138: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sf133_line_id:'||c_sf133_line_id);
1139:

Line 1136: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_treasury_symbol_id:'||parm_tsymbol_id);

1132: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,query_fetch_bal);
1133:
1134: --print bind variables
1135: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sf133_balance_type:'||c_sf133_balance_type);
1136: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_treasury_symbol_id:'||parm_tsymbol_id);
1137: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_sf133_line_acct_id:'||c_sf133_line_acct_id);
1138: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sf133_line_id:'||c_sf133_line_id);
1139:
1140: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);

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

1133:
1134: --print bind variables
1135: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sf133_balance_type:'||c_sf133_balance_type);
1136: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_treasury_symbol_id:'||parm_tsymbol_id);
1137: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_sf133_line_acct_id:'||c_sf133_line_acct_id);
1138: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sf133_line_id:'||c_sf133_line_id);
1139:
1140: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
1141:

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

1134: --print bind variables
1135: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sf133_balance_type:'||c_sf133_balance_type);
1136: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_treasury_symbol_id:'||parm_tsymbol_id);
1137: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_sf133_line_acct_id:'||c_sf133_line_acct_id);
1138: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sf133_line_id:'||c_sf133_line_id);
1139:
1140: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
1141:
1142: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

1138: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sf133_line_id:'||c_sf133_line_id);
1139:
1140: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
1141:
1142: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1143: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'l_ignore := '||l_ignore);
1144: END IF;
1145:
1146: dbms_sql.column_value(v_cursor_id, 1, c_total_balance);

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

1139:
1140: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
1141:
1142: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1143: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'l_ignore := '||l_ignore);
1144: END IF;
1145:
1146: dbms_sql.column_value(v_cursor_id, 1, c_total_balance);
1147: dbms_sql.close_cursor(v_cursor_id);

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

1144: END IF;
1145:
1146: dbms_sql.column_value(v_cursor_id, 1, c_total_balance);
1147: dbms_sql.close_cursor(v_cursor_id);
1148: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance:'||c_total_balance);
1149: END IF;
1150:
1151: elsif (( c_sf133_balance_type= 'ED') or( c_sf133_balance_type= 'EC')) then -- bal type is ending debit or ending credit only
1152:

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

1168: dbms_sql.bind_variable(v_cursor_id,':cv_treasury_symbol_id',parm_tsymbol_id);
1169: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_id',c_sf133_line_id);
1170:
1171: -- print query
1172: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,query_fetch_bal);
1173: --print bind variables
1174: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sf133_balance_type:'||c_sf133_balance_type);
1175: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'parm_tsymbol_id:'||parm_tsymbol_id);
1176: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_sf133_line_acct_id:'||c_sf133_line_acct_id);

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

1170:
1171: -- print query
1172: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,query_fetch_bal);
1173: --print bind variables
1174: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sf133_balance_type:'||c_sf133_balance_type);
1175: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'parm_tsymbol_id:'||parm_tsymbol_id);
1176: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_sf133_line_acct_id:'||c_sf133_line_acct_id);
1177: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sf133_line_id:'||c_sf133_line_id);
1178:

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

1171: -- print query
1172: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,query_fetch_bal);
1173: --print bind variables
1174: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sf133_balance_type:'||c_sf133_balance_type);
1175: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'parm_tsymbol_id:'||parm_tsymbol_id);
1176: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_sf133_line_acct_id:'||c_sf133_line_acct_id);
1177: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sf133_line_id:'||c_sf133_line_id);
1178:
1179: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);

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

1172: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,query_fetch_bal);
1173: --print bind variables
1174: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sf133_balance_type:'||c_sf133_balance_type);
1175: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'parm_tsymbol_id:'||parm_tsymbol_id);
1176: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_sf133_line_acct_id:'||c_sf133_line_acct_id);
1177: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sf133_line_id:'||c_sf133_line_id);
1178:
1179: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
1180:

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

1173: --print bind variables
1174: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sf133_balance_type:'||c_sf133_balance_type);
1175: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'parm_tsymbol_id:'||parm_tsymbol_id);
1176: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_sf133_line_acct_id:'||c_sf133_line_acct_id);
1177: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sf133_line_id:'||c_sf133_line_id);
1178:
1179: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
1180:
1181: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

1177: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sf133_line_id:'||c_sf133_line_id);
1178:
1179: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
1180:
1181: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1182: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'l_ignore := '||l_ignore);
1183: END IF;
1184:
1185: dbms_sql.column_value(v_cursor_id, 1, c_total_balance);

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

1178:
1179: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
1180:
1181: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1182: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'l_ignore := '||l_ignore);
1183: END IF;
1184:
1185: dbms_sql.column_value(v_cursor_id, 1, c_total_balance);
1186: dbms_sql.close_cursor(v_cursor_id);

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

1183: END IF;
1184:
1185: dbms_sql.column_value(v_cursor_id, 1, c_total_balance);
1186: dbms_sql.close_cursor(v_cursor_id);
1187: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance:'||c_total_balance);
1188:
1189: if ( c_sf133_balance_type = 'ED')then
1190: if (c_total_balance < 0) then
1191: c_total_balance := 0;

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

1204: ( c_sf133_line_type_code = 'D2' AND c_sf133_natural_bal_type ='D')) then
1205: c_total_balance := c_total_balance*(-1);
1206: end if;
1207:
1208: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance after modification:'||c_total_balance);
1209: end if;
1210:
1211: elsif( (c_sf133_balance_type= 'E-BD') or (c_sf133_balance_type='E-BC')) then -- bal type is end begin debit only
1212:

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

1228: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_acct_id',c_sf133_line_acct_id);
1229: dbms_sql.bind_variable(v_cursor_id,':cv_treasury_symbol_id',parm_tsymbol_id);
1230: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_id',c_sf133_line_id);
1231: -- print query
1232: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,query_fetch_bal);
1233:
1234: --print bind variables
1235: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sf133_balance_type:'||c_sf133_balance_type);
1236: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_treasury_symbol_id:'||parm_tsymbol_id);

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

1231: -- print query
1232: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,query_fetch_bal);
1233:
1234: --print bind variables
1235: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sf133_balance_type:'||c_sf133_balance_type);
1236: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_treasury_symbol_id:'||parm_tsymbol_id);
1237: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_sf133_line_acct_id:'||c_sf133_line_acct_id);
1238: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sf133_line_id:'||c_sf133_line_id);
1239:

Line 1236: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_treasury_symbol_id:'||parm_tsymbol_id);

1232: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,query_fetch_bal);
1233:
1234: --print bind variables
1235: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sf133_balance_type:'||c_sf133_balance_type);
1236: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_treasury_symbol_id:'||parm_tsymbol_id);
1237: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_sf133_line_acct_id:'||c_sf133_line_acct_id);
1238: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sf133_line_id:'||c_sf133_line_id);
1239:
1240: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);

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

1233:
1234: --print bind variables
1235: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sf133_balance_type:'||c_sf133_balance_type);
1236: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_treasury_symbol_id:'||parm_tsymbol_id);
1237: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_sf133_line_acct_id:'||c_sf133_line_acct_id);
1238: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sf133_line_id:'||c_sf133_line_id);
1239:
1240: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
1241:

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

1234: --print bind variables
1235: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sf133_balance_type:'||c_sf133_balance_type);
1236: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_treasury_symbol_id:'||parm_tsymbol_id);
1237: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'cv_sf133_line_acct_id:'||c_sf133_line_acct_id);
1238: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sf133_line_id:'||c_sf133_line_id);
1239:
1240: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
1241:
1242: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

1238: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_sf133_line_id:'||c_sf133_line_id);
1239:
1240: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
1241:
1242: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1243: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'l_ignore := '||l_ignore);
1244: END IF;
1245:
1246: dbms_sql.column_value(v_cursor_id, 1, c_total_balance);

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

1239:
1240: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
1241:
1242: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1243: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'l_ignore := '||l_ignore);
1244: END IF;
1245:
1246: dbms_sql.column_value(v_cursor_id, 1, c_total_balance);
1247: dbms_sql.close_cursor(v_cursor_id);

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

1244: END IF;
1245:
1246: dbms_sql.column_value(v_cursor_id, 1, c_total_balance);
1247: dbms_sql.close_cursor(v_cursor_id);
1248: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance:'||c_total_balance);
1249:
1250: if (c_sf133_balance_type= 'E-BD') then
1251: if (c_total_balance > 0) then
1252: if(( c_sf133_line_type_code = 'D' AND c_sf133_natural_bal_type ='D') or

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

1289: end if;
1290:
1291: c_sf133_amount_not_shown := c_sf133_amount_not_shown + c_total_balance;
1292:
1293: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1294: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'AMT NOT SHOWN = '||C_SF133_AMOUNT_NOT_SHOWN);
1295: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance = '||c_total_balance);
1296: END IF;
1297:

Line 1294: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'AMT NOT SHOWN = '||C_SF133_AMOUNT_NOT_SHOWN);

1290:
1291: c_sf133_amount_not_shown := c_sf133_amount_not_shown + c_total_balance;
1292:
1293: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1294: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'AMT NOT SHOWN = '||C_SF133_AMOUNT_NOT_SHOWN);
1295: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance = '||c_total_balance);
1296: END IF;
1297:
1298:

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

1291: c_sf133_amount_not_shown := c_sf133_amount_not_shown + c_total_balance;
1292:
1293: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1294: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'AMT NOT SHOWN = '||C_SF133_AMOUNT_NOT_SHOWN);
1295: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'c_total_balance = '||c_total_balance);
1296: END IF;
1297:
1298:
1299: END LOOP;

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

1299: END LOOP;
1300: --
1301: -- set up correct display sign
1302: --
1303: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1304: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'NATURAL BAL TYPE = '||C_SF133_NATURAL_BAL_TYPE);
1305: END IF;
1306: /* IF c_sf133_natural_bal_type = 'C' THEN
1307: -- Credit so display opposite

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

1300: --
1301: -- set up correct display sign
1302: --
1303: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1304: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'NATURAL BAL TYPE = '||C_SF133_NATURAL_BAL_TYPE);
1305: END IF;
1306: /* IF c_sf133_natural_bal_type = 'C' THEN
1307: -- Credit so display opposite
1308: c_sf133_column_amount := c_sf133_amount_not_shown * -1;

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

1328: o_sf133_column_amount := c_sf133_amount_not_shown;
1329: o_sf133_amt_not_shown := c_sf133_amount_not_shown;
1330: o_sf133_treasury_symbol_id := c_sf133_treasury_symbol_id; --added for 1575992
1331:
1332: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1333: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'COL AMT ='||O_SF133_COLUMN_AMOUNT);
1334: END IF;
1335: populate_temp_table;
1336: --

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

1329: o_sf133_amt_not_shown := c_sf133_amount_not_shown;
1330: o_sf133_treasury_symbol_id := c_sf133_treasury_symbol_id; --added for 1575992
1331:
1332: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1333: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'COL AMT ='||O_SF133_COLUMN_AMOUNT);
1334: END IF;
1335: populate_temp_table;
1336: --
1337: -- ------------------------------------

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

1350: ELSIF dbms_sql.is_open(v_cursor_id) THEN
1351: dbms_sql.close_cursor(v_cursor_id);
1352: END IF;
1353:
1354: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.exception','BUILD_FISCAL_LINE_COLUMNS:'||G_ERROR_MESSAGE);
1355: --
1356: END build_fiscal_line_columns;
1357: -- ----------------------------------------------
1358: -- ----------------------------------------------

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

1365: BEGIN
1366: l_module_name := g_module_name || 'build_total_line_columns';
1367: --
1368: IF parm_run_mode = 'T' THEN
1369: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1370: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'START BUILD_TOTAL_LINE_COLUMNS');
1371: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'-- LINE='||C_SF133_LINE_NUMBER
1372: ||' Start Total Line('||g_total_start_line_number||')'
1373: || ' Treasury Symbol('||c_sf133_ts_value||')');

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

1366: l_module_name := g_module_name || 'build_total_line_columns';
1367: --
1368: IF parm_run_mode = 'T' THEN
1369: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1370: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'START BUILD_TOTAL_LINE_COLUMNS');
1371: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'-- LINE='||C_SF133_LINE_NUMBER
1372: ||' Start Total Line('||g_total_start_line_number||')'
1373: || ' Treasury Symbol('||c_sf133_ts_value||')');
1374: END IF;

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

1367: --
1368: IF parm_run_mode = 'T' THEN
1369: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1370: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'START BUILD_TOTAL_LINE_COLUMNS');
1371: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'-- LINE='||C_SF133_LINE_NUMBER
1372: ||' Start Total Line('||g_total_start_line_number||')'
1373: || ' Treasury Symbol('||c_sf133_ts_value||')');
1374: END IF;
1375: END IF;

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

1389: WHERE set_of_books_id = parm_set_of_books_id
1390: AND sf133_line_number >
1391: DECODE(c_sf133_line_type_code, 'T', g_total_start_line_number, g_subtotal_start_line_number)
1392: AND sf133_line_number < c_sf133_line_number);
1393: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1394: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'SRART ' || G_TOTAL_START_LINE_NUMBER);
1395: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'END: ' || C_SF133_LINE_NUMBER);
1396: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'AMTNS: ' || C_SF133_AMOUNT_NOT_SHOWN);
1397: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'NATURAL BAL TYPE = '||C_SF133_NATURAL_BAL_TYPE);

Line 1394: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'SRART ' || G_TOTAL_START_LINE_NUMBER);

1390: AND sf133_line_number >
1391: DECODE(c_sf133_line_type_code, 'T', g_total_start_line_number, g_subtotal_start_line_number)
1392: AND sf133_line_number < c_sf133_line_number);
1393: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1394: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'SRART ' || G_TOTAL_START_LINE_NUMBER);
1395: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'END: ' || C_SF133_LINE_NUMBER);
1396: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'AMTNS: ' || C_SF133_AMOUNT_NOT_SHOWN);
1397: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'NATURAL BAL TYPE = '||C_SF133_NATURAL_BAL_TYPE);
1398: END IF;

Line 1395: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'END: ' || C_SF133_LINE_NUMBER);

1391: DECODE(c_sf133_line_type_code, 'T', g_total_start_line_number, g_subtotal_start_line_number)
1392: AND sf133_line_number < c_sf133_line_number);
1393: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1394: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'SRART ' || G_TOTAL_START_LINE_NUMBER);
1395: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'END: ' || C_SF133_LINE_NUMBER);
1396: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'AMTNS: ' || C_SF133_AMOUNT_NOT_SHOWN);
1397: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'NATURAL BAL TYPE = '||C_SF133_NATURAL_BAL_TYPE);
1398: END IF;
1399:

Line 1396: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'AMTNS: ' || C_SF133_AMOUNT_NOT_SHOWN);

1392: AND sf133_line_number < c_sf133_line_number);
1393: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1394: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'SRART ' || G_TOTAL_START_LINE_NUMBER);
1395: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'END: ' || C_SF133_LINE_NUMBER);
1396: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'AMTNS: ' || C_SF133_AMOUNT_NOT_SHOWN);
1397: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'NATURAL BAL TYPE = '||C_SF133_NATURAL_BAL_TYPE);
1398: END IF;
1399:
1400: IF c_sf133_natural_bal_type = 'C' THEN

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

1393: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1394: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'SRART ' || G_TOTAL_START_LINE_NUMBER);
1395: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'END: ' || C_SF133_LINE_NUMBER);
1396: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'AMTNS: ' || C_SF133_AMOUNT_NOT_SHOWN);
1397: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'NATURAL BAL TYPE = '||C_SF133_NATURAL_BAL_TYPE);
1398: END IF;
1399:
1400: IF c_sf133_natural_bal_type = 'C' THEN
1401: -- Credit so display opposite

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

1414: c_sf133_column_amount := '-'||ABS(c_sf133_amount_not_shown);
1415:
1416: END IF;
1417:
1418: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1419: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'BALT: ' || C_SF133_NATURAL_BAL_TYPE);
1420: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'AMT: ' || C_SF133_COLUMN_AMOUNT);
1421: END IF;
1422:

Line 1419: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'BALT: ' || C_SF133_NATURAL_BAL_TYPE);

1415:
1416: END IF;
1417:
1418: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1419: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'BALT: ' || C_SF133_NATURAL_BAL_TYPE);
1420: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'AMT: ' || C_SF133_COLUMN_AMOUNT);
1421: END IF;
1422:
1423: --

Line 1420: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'AMT: ' || C_SF133_COLUMN_AMOUNT);

1416: END IF;
1417:
1418: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1419: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'BALT: ' || C_SF133_NATURAL_BAL_TYPE);
1420: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'AMT: ' || C_SF133_COLUMN_AMOUNT);
1421: END IF;
1422:
1423: --
1424: -- ------------------------------------

Line 1443: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.exception','BUILD_TOTAL_LINE_COLUMNS');

1439: --
1440: WHEN OTHERS THEN
1441: g_error_code := SQLCODE;
1442: g_error_message := SQLERRM;
1443: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.exception','BUILD_TOTAL_LINE_COLUMNS');
1444: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.exception',g_error_message );
1445: --
1446: END build_total_line_columns;
1447: -- ----------------------------------------------

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

1440: WHEN OTHERS THEN
1441: g_error_code := SQLCODE;
1442: g_error_message := SQLERRM;
1443: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.exception','BUILD_TOTAL_LINE_COLUMNS');
1444: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.exception',g_error_message );
1445: --
1446: END build_total_line_columns;
1447: -- ----------------------------------------------
1448: -- --------------------------------------------------------

Line 1458: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, 'testsf133','START POPULATE_TEMP_TABLE');

1454: -- ----------------------------------------------
1455: BEGIN
1456: l_module_name := g_module_name || 'populate_temp_table';
1457: --
1458: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, 'testsf133','START POPULATE_TEMP_TABLE');
1459: IF parm_run_mode = 'T' THEN
1460: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1461: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'START POPULATE_TEMP_TABLE');
1462: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, '-- '||C_SF133_LINE_NUMBER

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

1456: l_module_name := g_module_name || 'populate_temp_table';
1457: --
1458: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, 'testsf133','START POPULATE_TEMP_TABLE');
1459: IF parm_run_mode = 'T' THEN
1460: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1461: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'START POPULATE_TEMP_TABLE');
1462: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, '-- '||C_SF133_LINE_NUMBER
1463: ||' ('||o_sf133_column_number||')'
1464: ||' ('||o_sf133_column_amount||')'

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

1457: --
1458: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, 'testsf133','START POPULATE_TEMP_TABLE');
1459: IF parm_run_mode = 'T' THEN
1460: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1461: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'START POPULATE_TEMP_TABLE');
1462: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, '-- '||C_SF133_LINE_NUMBER
1463: ||' ('||o_sf133_column_number||')'
1464: ||' ('||o_sf133_column_amount||')'
1465: ||' ('||o_sf133_amt_not_shown||')');

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

1458: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, 'testsf133','START POPULATE_TEMP_TABLE');
1459: IF parm_run_mode = 'T' THEN
1460: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1461: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'START POPULATE_TEMP_TABLE');
1462: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, '-- '||C_SF133_LINE_NUMBER
1463: ||' ('||o_sf133_column_number||')'
1464: ||' ('||o_sf133_column_amount||')'
1465: ||' ('||o_sf133_amt_not_shown||')');
1466: END IF;

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

1495: --
1496: WHEN OTHERS THEN
1497: g_error_code := SQLCODE;
1498: g_error_message := SQLERRM;
1499: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.exception',G_ERROR_MESSAGE);
1500: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.exception','-- POPULATE_TEMP_TABLE');
1501: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.exception','---- TREASURY SYMBOL:'||O_SF133_TS_VALUE
1502: ||' Line Id:'||o_sf133_line_id
1503: ||' Col:' ||o_sf133_column_number

Line 1500: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.exception','-- POPULATE_TEMP_TABLE');

1496: WHEN OTHERS THEN
1497: g_error_code := SQLCODE;
1498: g_error_message := SQLERRM;
1499: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.exception',G_ERROR_MESSAGE);
1500: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.exception','-- POPULATE_TEMP_TABLE');
1501: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.exception','---- TREASURY SYMBOL:'||O_SF133_TS_VALUE
1502: ||' Line Id:'||o_sf133_line_id
1503: ||' Col:' ||o_sf133_column_number
1504: ||' Amt:' ||o_sf133_column_amount);

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

1497: g_error_code := SQLCODE;
1498: g_error_message := SQLERRM;
1499: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.exception',G_ERROR_MESSAGE);
1500: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.exception','-- POPULATE_TEMP_TABLE');
1501: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.exception','---- TREASURY SYMBOL:'||O_SF133_TS_VALUE
1502: ||' Line Id:'||o_sf133_line_id
1503: ||' Col:' ||o_sf133_column_number
1504: ||' Amt:' ||o_sf133_column_amount);
1505: --

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

1601:
1602: BEGIN
1603: l_module_name := g_module_name || 'populate_gtt_with_ccid';
1604:
1605: IF ( fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1606: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'Entering Module '||l_module_name);
1607: END IF;
1608:
1609: FOR crec_rec IN crec_cursor (parm_set_of_books_id) LOOP

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

1602: BEGIN
1603: l_module_name := g_module_name || 'populate_gtt_with_ccid';
1604:
1605: IF ( fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1606: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'Entering Module '||l_module_name);
1607: END IF;
1608:
1609: FOR crec_rec IN crec_cursor (parm_set_of_books_id) LOOP
1610:

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

1607: END IF;
1608:
1609: FOR crec_rec IN crec_cursor (parm_set_of_books_id) LOOP
1610:
1611: IF ( fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1612: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'sf133_line_acct_id = '||crec_rec.sf133_line_acct_id);
1613: END IF;
1614:
1615: v_seg(1) := crec_rec.segment1;

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

1608:
1609: FOR crec_rec IN crec_cursor (parm_set_of_books_id) LOOP
1610:
1611: IF ( fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1612: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'sf133_line_acct_id = '||crec_rec.sf133_line_acct_id);
1613: END IF;
1614:
1615: v_seg(1) := crec_rec.segment1;
1616: v_seg(2) := crec_rec.segment2;

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

1646: v_statement := NULL;
1647:
1648: FOR i IN 1 ..30 LOOP
1649: v_seg_str(i) := NULL;
1650: IF ( fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1651: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'v_seg('||i||')='||v_seg(i));
1652: END IF;
1653: END LOOP;
1654:

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

1647:
1648: FOR i IN 1 ..30 LOOP
1649: v_seg_str(i) := NULL;
1650: IF ( fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1651: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'v_seg('||i||')='||v_seg(i));
1652: END IF;
1653: END LOOP;
1654:
1655: l_no_of_seg := 0;

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

1654:
1655: l_no_of_seg := 0;
1656:
1657: FOR flex_rec IN flex_cursor (g_chart_of_accounts_id) LOOP
1658: IF ( fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1659: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'application_column_name = '||flex_rec.application_column_name);
1660: END IF;
1661: l_no_of_child := 0;
1662: l_and := NULL;

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

1655: l_no_of_seg := 0;
1656:
1657: FOR flex_rec IN flex_cursor (g_chart_of_accounts_id) LOOP
1658: IF ( fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1659: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'application_column_name = '||flex_rec.application_column_name);
1660: END IF;
1661: l_no_of_child := 0;
1662: l_and := NULL;
1663:

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

1662: l_and := NULL;
1663:
1664: /* check the segment values is parent */
1665: l_segno := SUBSTR(flex_rec.application_column_name,8,2);
1666: IF ( fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1667: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'l_segno = '||l_segno);
1668: END IF;
1669:
1670: IF (v_seg(l_segno) IS NOT NULL) THEN

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

1663:
1664: /* check the segment values is parent */
1665: l_segno := SUBSTR(flex_rec.application_column_name,8,2);
1666: IF ( fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1667: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'l_segno = '||l_segno);
1668: END IF;
1669:
1670: IF (v_seg(l_segno) IS NOT NULL) THEN
1671: SELECT COUNT(*)

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

1673: FROM fnd_flex_value_hierarchies
1674: WHERE parent_flex_value = v_seg(l_segno)
1675: AND flex_value_set_id = flex_rec.flex_value_set_id;
1676:
1677: IF ( fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1678: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'l_cnt = '||l_cnt);
1679: END IF;
1680:
1681: OPEN child_value_cursor(v_seg(l_segno) , flex_rec.flex_value_set_id);

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

1674: WHERE parent_flex_value = v_seg(l_segno)
1675: AND flex_value_set_id = flex_rec.flex_value_set_id;
1676:
1677: IF ( fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1678: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'l_cnt = '||l_cnt);
1679: END IF;
1680:
1681: OPEN child_value_cursor(v_seg(l_segno) , flex_rec.flex_value_set_id);
1682:

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

1680:
1681: OPEN child_value_cursor(v_seg(l_segno) , flex_rec.flex_value_set_id);
1682:
1683: IF (l_cnt > 0) THEN
1684: IF ( fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1685: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'l_cnt > 0');
1686: END IF;
1687:
1688: l_and := NULL;

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

1681: OPEN child_value_cursor(v_seg(l_segno) , flex_rec.flex_value_set_id);
1682:
1683: IF (l_cnt > 0) THEN
1684: IF ( fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1685: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'l_cnt > 0');
1686: END IF;
1687:
1688: l_and := NULL;
1689:

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

1717: l_and := NULL;
1718: v_statement := v_statement || l_and || l_child || fnd_global.local_chr(10);
1719:
1720: ELSE
1721: IF ( fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1722: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'l_cnt not > 0');
1723: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'l_no_of_seg='||l_no_of_seg);
1724: END IF;
1725: IF (l_no_of_seg > 0) THEN

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

1718: v_statement := v_statement || l_and || l_child || fnd_global.local_chr(10);
1719:
1720: ELSE
1721: IF ( fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1722: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'l_cnt not > 0');
1723: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'l_no_of_seg='||l_no_of_seg);
1724: END IF;
1725: IF (l_no_of_seg > 0) THEN
1726: l_and := ' AND ';

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

1719:
1720: ELSE
1721: IF ( fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1722: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'l_cnt not > 0');
1723: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'l_no_of_seg='||l_no_of_seg);
1724: END IF;
1725: IF (l_no_of_seg > 0) THEN
1726: l_and := ' AND ';
1727: END IF;

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

1736: END IF; --v_seg(l_segno) IS NOT NULL
1737:
1738: END LOOP; --FLEX_CURSOR
1739:
1740: IF ( fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1741: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'v_statement = '||v_statement);
1742: END IF;
1743:
1744: IF (v_statement IS NOT NULL) THEN

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

1737:
1738: END LOOP; --FLEX_CURSOR
1739:
1740: IF ( fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1741: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'v_statement = '||v_statement);
1742: END IF;
1743:
1744: IF (v_statement IS NOT NULL) THEN
1745: v_insert_statement := 'INSERT INTO fv_sf133_ccids_gt

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

1762: FROM fv_sf133_ccids_gt fct
1763: WHERE fct.sf133_line_acct_id =:b_sf133_line_acct_id
1764: AND fct.ccid = gcc.code_combination_id)';
1765:
1766: IF ( fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1767: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'v_insert_statement = '||v_insert_statement);
1768: END IF;
1769:
1770: EXECUTE IMMEDIATE v_insert_statement

Line 1767: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'v_insert_statement = '||v_insert_statement);

1763: WHERE fct.sf133_line_acct_id =:b_sf133_line_acct_id
1764: AND fct.ccid = gcc.code_combination_id)';
1765:
1766: IF ( fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1767: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'v_insert_statement = '||v_insert_statement);
1768: END IF;
1769:
1770: EXECUTE IMMEDIATE v_insert_statement
1771: USING crec_rec.sf133_line_acct_id,

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

1776: crec_rec.sf133_line_acct_id;
1777: END IF;
1778: END LOOP; --crec_cursor
1779:
1780: IF ( fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1781: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'Exiting Module = '||l_module_name);
1782: END IF;
1783:
1784: EXCEPTION

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

1777: END IF;
1778: END LOOP; --crec_cursor
1779:
1780: IF ( fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1781: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'Exiting Module = '||l_module_name);
1782: END IF;
1783:
1784: EXCEPTION
1785: WHEN OTHERS THEN

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

1784: EXCEPTION
1785: WHEN OTHERS THEN
1786: g_error_code := SQLCODE;
1787: g_error_message := SQLERRM;
1788: fv_utility.log_mesg(fnd_log.level_unexpected, l_module_name||'.exception',g_error_message);
1789: fv_utility.log_mesg(fnd_log.level_unexpected, l_module_name||'.exception','-- populate_gtt_with_ccid');
1790: END;
1791:
1792:

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

1785: WHEN OTHERS THEN
1786: g_error_code := SQLCODE;
1787: g_error_message := SQLERRM;
1788: fv_utility.log_mesg(fnd_log.level_unexpected, l_module_name||'.exception',g_error_message);
1789: fv_utility.log_mesg(fnd_log.level_unexpected, l_module_name||'.exception','-- populate_gtt_with_ccid');
1790: END;
1791:
1792:
1793:

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

1814: dbms_sql.define_column(v_cursor_id_ind, 1,DSum_E);
1815: dbms_sql.define_column(v_cursor_id_ind, 2,CSum_E);
1816:
1817: l_ignore1 := dbms_sql.execute_and_fetch(v_cursor_id_ind);
1818: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1819: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, 'testsf133','l_ignore1 := '||l_ignore1);
1820: END IF;
1821: dbms_sql.column_value(v_cursor_id_ind, 1, DSum_E);
1822: dbms_sql.column_value(v_cursor_id_ind, 2, CSum_E);

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

1815: dbms_sql.define_column(v_cursor_id_ind, 2,CSum_E);
1816:
1817: l_ignore1 := dbms_sql.execute_and_fetch(v_cursor_id_ind);
1818: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1819: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, 'testsf133','l_ignore1 := '||l_ignore1);
1820: END IF;
1821: dbms_sql.column_value(v_cursor_id_ind, 1, DSum_E);
1822: dbms_sql.column_value(v_cursor_id_ind, 2, CSum_E);
1823: -- dbms_sql.close_cursor(v_cursor_id_ind);

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

1843: dbms_sql.define_column(v_cursor_id_ind, 1,DSum_B);
1844: dbms_sql.define_column(v_cursor_id_ind, 2,CSum_B);
1845:
1846: l_ignore1 := dbms_sql.execute_and_fetch(v_cursor_id_ind);
1847: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1848: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, 'testsf133','l_ignore1 := '||l_ignore1);
1849: END IF;
1850: dbms_sql.column_value(v_cursor_id_ind, 1, DSum_B);
1851: dbms_sql.column_value(v_cursor_id_ind, 2, CSum_B);

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

1844: dbms_sql.define_column(v_cursor_id_ind, 2,CSum_B);
1845:
1846: l_ignore1 := dbms_sql.execute_and_fetch(v_cursor_id_ind);
1847: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1848: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, 'testsf133','l_ignore1 := '||l_ignore1);
1849: END IF;
1850: dbms_sql.column_value(v_cursor_id_ind, 1, DSum_B);
1851: dbms_sql.column_value(v_cursor_id_ind, 2, CSum_B);
1852: --dbms_sql.close_cursor(v_cursor_id_ind);

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

1860: EXCEPTION
1861: WHEN OTHERS THEN
1862: g_error_code := SQLCODE;
1863: g_error_message := SQLERRM;
1864: fv_utility.log_mesg(fnd_log.level_unexpected, 'testsf133'||'.exception',g_error_message);
1865: fv_utility.log_mesg(fnd_log.level_unexpected, 'testsf133'||'.exception','-- get_bal_type');
1866: END;
1867:
1868:

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

1861: WHEN OTHERS THEN
1862: g_error_code := SQLCODE;
1863: g_error_message := SQLERRM;
1864: fv_utility.log_mesg(fnd_log.level_unexpected, 'testsf133'||'.exception',g_error_message);
1865: fv_utility.log_mesg(fnd_log.level_unexpected, 'testsf133'||'.exception','-- get_bal_type');
1866: END;
1867:
1868:
1869: PROCEDURE process_total_line

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

1912: v_col_1_amt fv_sf133_definitions_cols_temp.sf133_column_amount%TYPE;
1913:
1914:
1915: BEGIN
1916: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,'Inside process_total_line');
1917:
1918: FOR calc_rec IN fv_sf133_calc_cur
1919: LOOP
1920: amt_array(amt_array_cnt).calc_sequence := calc_rec.calc_sequence_number;

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

1950: END IF;
1951:
1952: IF calc_rec.operator = '+' THEN
1953: amt_array(amt_array_cnt).col_1_amt := NVL(temp_amt_low, 0) + NVL(temp_amt_high, 0);
1954: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,calc_rec.operator||amt_array(amt_array_cnt).col_1_amt);
1955:
1956: ELSIF calc_rec.operator = '-' THEN
1957: amt_array(amt_array_cnt).col_1_amt := NVL(temp_amt_low, 0) - NVL(temp_amt_high, 0);
1958: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,calc_rec.operator||amt_array(amt_array_cnt).col_1_amt);

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

1954: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,calc_rec.operator||amt_array(amt_array_cnt).col_1_amt);
1955:
1956: ELSIF calc_rec.operator = '-' THEN
1957: amt_array(amt_array_cnt).col_1_amt := NVL(temp_amt_low, 0) - NVL(temp_amt_high, 0);
1958: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,calc_rec.operator||amt_array(amt_array_cnt).col_1_amt);
1959: ELSE
1960: IF calc_rec.line_low_type = 'L' THEN
1961: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,'inside for loop, range:'||calc_rec.line_low||calc_rec.line_high);
1962: FOR lines_rec IN fv_cfs_lines_cur(calc_rec.line_low, calc_rec.line_high)

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

1957: amt_array(amt_array_cnt).col_1_amt := NVL(temp_amt_low, 0) - NVL(temp_amt_high, 0);
1958: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,calc_rec.operator||amt_array(amt_array_cnt).col_1_amt);
1959: ELSE
1960: IF calc_rec.line_low_type = 'L' THEN
1961: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,'inside for loop, range:'||calc_rec.line_low||calc_rec.line_high);
1962: FOR lines_rec IN fv_cfs_lines_cur(calc_rec.line_low, calc_rec.line_high)
1963: LOOP
1964: FOR fv_sf133_temp_cur_rec IN fv_sf133_temp_cur(lines_rec.sf133_line_id)
1965: LOOP

Line 1967: 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);

1963: LOOP
1964: FOR fv_sf133_temp_cur_rec IN fv_sf133_temp_cur(lines_rec.sf133_line_id)
1965: LOOP
1966: amt_array(amt_array_cnt).col_1_amt := amt_array(amt_array_cnt).col_1_amt + NVL(fv_sf133_temp_cur_rec.sf133_column_amount, 0);
1967: 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);
1968: END LOOP;
1969: END LOOP;
1970: ELSIF calc_rec.line_low_type = 'C' THEN
1971: FOR i IN 1..amt_array_cnt - 1

Line 1976: 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);

1972: LOOP
1973: IF amt_array(i).calc_sequence >= calc_rec.line_low
1974: AND amt_array(i).calc_sequence <= calc_rec.line_high THEN
1975: amt_array(amt_array_cnt).col_1_amt := amt_array(amt_array_cnt).col_1_amt + NVL(amt_array(i).col_1_amt, 0);
1976: 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);
1977: END IF;
1978: END LOOP;
1979: END IF;
1980: END IF;

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

1989: o_sf133_column_number := g_column_number;
1990: o_sf133_column_amount := v_col_1_amt;
1991: o_sf133_amt_not_shown := v_col_1_amt; -- Bug # 2896450
1992: o_sf133_treasury_symbol_id := c_sf133_treasury_symbol_id; --added for 1575992
1993: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'end of process_total_line: '||o_sf133_ts_value||o_sf133_column_amount);
1994:
1995: populate_temp_table;
1996:
1997: EXCEPTION

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

1997: EXCEPTION
1998: WHEN OTHERS THEN
1999: g_error_code := SQLCODE ;
2000: g_error_message := SQLERRM || ' [PROCESS_TOTAL_LINE] ' ;
2001: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',g_error_message);
2002: RETURN;
2003: END process_total_line;
2004:
2005: -- --------------------------------------------------------