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 222: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

218: g_chart_of_accounts_id
219: from gl_ledgers
220: where ledger_id = parm_set_of_books_id;
221:
222: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
223: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'-- APID('||NVL(PARM_APPLICATION_ID,0) ||')'
224: ||' SoB('||NVL(parm_set_of_books_id,0) ||')'
225: ||' Year('||NVL(parm_gl_period_year,0) ||')'
226: ||' Period('||NVL(parm_gl_period_num,0) ||')'

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

219: from gl_ledgers
220: where ledger_id = parm_set_of_books_id;
221:
222: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
223: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'-- APID('||NVL(PARM_APPLICATION_ID,0) ||')'
224: ||' SoB('||NVL(parm_set_of_books_id,0) ||')'
225: ||' Year('||NVL(parm_gl_period_year,0) ||')'
226: ||' Period('||NVL(parm_gl_period_num,0) ||')'
227: ||' Fund Code('||NVL(parm_treasury_value_r1,'Null')

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

263: populate_gtt_with_ccid(parm_tsymbol_id);
264: --determine_acct_flex_segments;
265:
266: dbms_sql.bind_variable(v_cursor_id,':cv_treasury_symbol_id',parm_tsymbol_id);
267: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
268: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'PROCESSING TREASURY SYMBOL... '||PARM_TREASURY_VALUE_R1) ;
269: END IF;
270: build_report_lines;
271: IF g_error_code <> 0 THEN

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

264: --determine_acct_flex_segments;
265:
266: dbms_sql.bind_variable(v_cursor_id,':cv_treasury_symbol_id',parm_tsymbol_id);
267: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
268: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'PROCESSING TREASURY SYMBOL... '||PARM_TREASURY_VALUE_R1) ;
269: END IF;
270: build_report_lines;
271: IF g_error_code <> 0 THEN
272: errbuf := errbuf || '

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

273: Processing for Treasury Symbol '||parm_treasury_value_r1||' FAILED'||
274: g_error_message;
275: ELSE
276:
277: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
278: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'SUBMITTING SF133 REPORT FOR TS.....'||PARM_TREASURY_VALUE_R1);
279: END IF;
280:
281: l_req_id :=

Line 278: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'SUBMITTING SF133 REPORT FOR TS.....'||PARM_TREASURY_VALUE_R1);

274: g_error_message;
275: ELSE
276:
277: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
278: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'SUBMITTING SF133 REPORT FOR TS.....'||PARM_TREASURY_VALUE_R1);
279: END IF;
280:
281: l_req_id :=
282: FND_REQUEST.SUBMIT_REQUEST ('FV','FVXBGLPN','','',FALSE,parm_set_of_books_id,g_chart_of_accounts_id,

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

284:
285: IF l_req_id = 0 THEN
286: errbuf := 'Error submitting SF133 Report for Treasury Symbol ' || parm_treasury_value_r1;
287: retcode := -1 ;
288: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,ERRBUF) ;
289: return;
290: ELSE
291: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
292: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'CONCURRENT REQUEST ID FOR SF133 REPORT - ' ||

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

287: retcode := -1 ;
288: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,ERRBUF) ;
289: return;
290: ELSE
291: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
292: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'CONCURRENT REQUEST ID FOR SF133 REPORT - ' ||
293: l_req_id);
294: END IF;
295: END IF;

Line 292: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'CONCURRENT REQUEST ID FOR SF133 REPORT - ' ||

288: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,ERRBUF) ;
289: return;
290: ELSE
291: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
292: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'CONCURRENT REQUEST ID FOR SF133 REPORT - ' ||
293: l_req_id);
294: END IF;
295: END IF;
296:

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

308: --
309: IF errbuf IS NULL THEN
310: errbuf := 'Normal End of FVSF133 Package';
311: END IF;
312: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
313: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,ERRBUF);
314: END IF;
315:
316: dbms_sql.close_cursor(v_cursor_id);

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

309: IF errbuf IS NULL THEN
310: errbuf := 'Normal End of FVSF133 Package';
311: END IF;
312: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
313: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,ERRBUF);
314: END IF;
315:
316: dbms_sql.close_cursor(v_cursor_id);
317: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

313: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,ERRBUF);
314: END IF;
315:
316: dbms_sql.close_cursor(v_cursor_id);
317: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
318: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'-- INSERT COUNT('||G_INSERT_COUNT||')');
319: END IF;
320: retcode := g_error_code;
321: errbuf := 'Normal End of FVSF133 Package';

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

314: END IF;
315:
316: dbms_sql.close_cursor(v_cursor_id);
317: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
318: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'-- INSERT COUNT('||G_INSERT_COUNT||')');
319: END IF;
320: retcode := g_error_code;
321: errbuf := 'Normal End of FVSF133 Package';
322: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

318: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'-- INSERT COUNT('||G_INSERT_COUNT||')');
319: END IF;
320: retcode := g_error_code;
321: errbuf := 'Normal End of FVSF133 Package';
322: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
323: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,ERRBUF);
324: END IF;
325: --
326: -- ------------------------------------

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

319: END IF;
320: retcode := g_error_code;
321: errbuf := 'Normal End of FVSF133 Package';
322: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
323: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,ERRBUF);
324: END IF;
325: --
326: -- ------------------------------------
327: -- Exceptions

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

330: --
331: WHEN abort_error THEN
332: retcode := g_error_code;
333: errbuf := g_error_message;
334: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,ERRBUF);
335: --
336: WHEN OTHERS THEN
337: retcode := SQLCODE;
338: errbuf := SQLERRM;

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

335: --
336: WHEN OTHERS THEN
337: retcode := SQLCODE;
338: errbuf := SQLERRM;
339: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name,errbuf);
340: RAISE_APPLICATION_ERROR(-20222,
341: 'FVSF133 Exception-'||SQLERRM);
342: --
343: END main;

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

358: BEGIN
359: l_module_name := g_module_name || 'determine_acct_flex_segments';
360: --
361: IF parm_run_mode = 'T' THEN
362: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
363: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'START DETERMINE_ACCT_FLEX_SEGMENTS');
364: END IF;
365: END IF;
366: --

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

359: l_module_name := g_module_name || 'determine_acct_flex_segments';
360: --
361: IF parm_run_mode = 'T' THEN
362: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
363: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'START DETERMINE_ACCT_FLEX_SEGMENTS');
364: END IF;
365: END IF;
366: --
367: -- -------------------------------------

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

457: AND id_flex_code = 'GL#'
458: AND id_flex_num = g_chart_of_accounts_id;
459: EXCEPTION
460: WHEN OTHERS THEN
461: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,'Error in getting the Value set attched '
462: || ' to the segemnt => ' || c_flex_column_name);
463: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,' SQLCODE => ' || SQLCODE ||
464: ' SQLERRM => ' || SQLERRM);
465: RAISE;

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

459: EXCEPTION
460: WHEN OTHERS THEN
461: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,'Error in getting the Value set attched '
462: || ' to the segemnt => ' || c_flex_column_name);
463: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,' SQLCODE => ' || SQLCODE ||
464: ' SQLERRM => ' || SQLERRM);
465: RAISE;
466: END;
467: -- + Rollup for the amount is the segment is a parent segment +

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

503: dbms_sql.bind_variable(v_cursor_id, ':cv_coa_id', g_chart_of_accounts_id);
504:
505: --
506:
507: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
508: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,V_SELECT);
509: END IF;
510: --
511: -- ------------------------------------

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

504:
505: --
506:
507: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
508: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,V_SELECT);
509: END IF;
510: --
511: -- ------------------------------------
512: -- Exceptions

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

518: close flex_field_column_name_cursor;
519: END IF;
520: g_error_code := SQLCODE;
521: g_error_message := 'determine_acct_flex_segments/'||SQLERRM;
522: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.exception',g_error_message);
523: --
524: END determine_acct_flex_segments;
525: -- --------------------------------------------------------
526: -- --------------------------------------------------------

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

532: BEGIN
533: l_module_name := g_module_name || 'purge_temp_table';
534: --
535: IF parm_run_mode = 'T' THEN
536: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
537: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'START PURGE_TEMP_TABLE');
538: END IF;
539: END IF;
540: --

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

533: l_module_name := g_module_name || 'purge_temp_table';
534: --
535: IF parm_run_mode = 'T' THEN
536: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
537: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'START PURGE_TEMP_TABLE');
538: END IF;
539: END IF;
540: --
541: DELETE

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

558: --
559: WHEN OTHERS THEN
560: g_error_code := SQLCODE;
561: g_error_message := 'purge_temp_table/'||SQLERRM;
562: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.exception',g_error_message);
563: --
564: END purge_temp_table;
565: -- --------------------------------------------------------
566: -- --------------------------------------------------------

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

573: BEGIN
574: l_module_name := g_module_name || 'build_report_lines';
575: --
576: IF parm_run_mode = 'T' THEN
577: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
578: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'START BUILD_REPORT_LINES');
579: END IF;
580: END IF;
581: --

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

574: l_module_name := g_module_name || 'build_report_lines';
575: --
576: IF parm_run_mode = 'T' THEN
577: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
578: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'START BUILD_REPORT_LINES');
579: END IF;
580: END IF;
581: --
582: -- ----------------------------------------

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

623:
624: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_id',c_sf133_line_id);
625: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_category',c_sf133_line_category);
626: --
627: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
628: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_SF133_LINE_CATEGORY = '||C_SF133_LINE_CATEGORY);
629: END IF;
630: IF g_error_code = 0 THEN
631: IF c_sf133_line_type_code = 'D' THEN

Line 628: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_SF133_LINE_CATEGORY = '||C_SF133_LINE_CATEGORY);

624: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_id',c_sf133_line_id);
625: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_category',c_sf133_line_category);
626: --
627: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
628: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_SF133_LINE_CATEGORY = '||C_SF133_LINE_CATEGORY);
629: END IF;
630: IF g_error_code = 0 THEN
631: IF c_sf133_line_type_code = 'D' THEN
632: g_column_number := 1;

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

668: close ts_report_line_cursor;
669: END IF;
670: g_error_code := SQLCODE;
671: g_error_message := SQLERRM;
672: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.exception','BUILD_REPORT_LINES');
673: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.exception',g_error_message);
674: --
675: END build_report_lines;
676: -- --------------------------------------------------------

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

669: END IF;
670: g_error_code := SQLCODE;
671: g_error_message := SQLERRM;
672: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.exception','BUILD_REPORT_LINES');
673: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.exception',g_error_message);
674: --
675: END build_report_lines;
676: -- --------------------------------------------------------
677: -- ----------------------------------------------

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

686: BEGIN
687: l_module_name := g_module_name || 'build_fiscal_line_columns';
688: --
689: IF parm_run_mode = 'T' THEN
690: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
691: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'START BUILD_FISCAL_LINE_COLUMNS');
692: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, '-- LINE('||C_SF133_LINE_NUMBER||')'
693: || ' Tresury Symbol('||c_sf133_ts_value ||')'
694: || ' '||to_char(SYSDATE,'mm/dd/yyyy hh:mi:ss'));

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

687: l_module_name := g_module_name || 'build_fiscal_line_columns';
688: --
689: IF parm_run_mode = 'T' THEN
690: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
691: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'START BUILD_FISCAL_LINE_COLUMNS');
692: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, '-- LINE('||C_SF133_LINE_NUMBER||')'
693: || ' Tresury Symbol('||c_sf133_ts_value ||')'
694: || ' '||to_char(SYSDATE,'mm/dd/yyyy hh:mi:ss'));
695: END IF;

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

688: --
689: IF parm_run_mode = 'T' THEN
690: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
691: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'START BUILD_FISCAL_LINE_COLUMNS');
692: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, '-- LINE('||C_SF133_LINE_NUMBER||')'
693: || ' Tresury Symbol('||c_sf133_ts_value ||')'
694: || ' '||to_char(SYSDATE,'mm/dd/yyyy hh:mi:ss'));
695: END IF;
696: END IF;

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

715: c_sf133_additional_info := balance_type_rec.sf133_additional_info;
716:
717: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_acct_id',c_sf133_line_acct_id);
718:
719: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
720: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'BALANCE_TYPE = '||C_SF133_BALANCE_TYPE);
721: END IF;
722:
723: -- New code by Narsimha for rescission.

Line 720: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'BALANCE_TYPE = '||C_SF133_BALANCE_TYPE);

716:
717: dbms_sql.bind_variable(v_cursor_id,':cv_sf133_line_acct_id',c_sf133_line_acct_id);
718:
719: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
720: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'BALANCE_TYPE = '||C_SF133_BALANCE_TYPE);
721: END IF;
722:
723: -- New code by Narsimha for rescission.
724:

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

755: -- ending balance type
756: dbms_sql.bind_variable(v_cursor_id, ':cv_balance_type','E');
757: dbms_sql.bind_variable(v_cursor_id,':cv_period',c_end_period);
758: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
759: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
760: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'l_ignore := '||l_ignore);
761: END IF;
762: dbms_sql.column_value(v_cursor_id, 1, c_total_balance);
763: ELSIF c_sf133_balance_type = 'B' THEN

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

756: dbms_sql.bind_variable(v_cursor_id, ':cv_balance_type','E');
757: dbms_sql.bind_variable(v_cursor_id,':cv_period',c_end_period);
758: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
759: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
760: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'l_ignore := '||l_ignore);
761: END IF;
762: dbms_sql.column_value(v_cursor_id, 1, c_total_balance);
763: ELSIF c_sf133_balance_type = 'B' THEN
764: -- beginning balance type

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

764: -- beginning balance type
765: dbms_sql.bind_variable(v_cursor_id, ':cv_balance_type','B');
766: dbms_sql.bind_variable(v_cursor_id,':cv_period',c_begin_period);
767: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
768: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
769: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'l_ignore := '||l_ignore);
770: END IF;
771: dbms_sql.column_value(v_cursor_id, 1, c_total_balance);
772: ELSIF c_sf133_balance_type = 'P' THEN

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

765: dbms_sql.bind_variable(v_cursor_id, ':cv_balance_type','B');
766: dbms_sql.bind_variable(v_cursor_id,':cv_period',c_begin_period);
767: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
768: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
769: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'l_ignore := '||l_ignore);
770: END IF;
771: dbms_sql.column_value(v_cursor_id, 1, c_total_balance);
772: ELSIF c_sf133_balance_type = 'P' THEN
773: dbms_sql.bind_variable(v_cursor_id, ':cv_balance_type','P');

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

772: ELSIF c_sf133_balance_type = 'P' THEN
773: dbms_sql.bind_variable(v_cursor_id, ':cv_balance_type','P');
774: dbms_sql.bind_variable(v_cursor_id,':cv_period',c_end_period);
775: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
776: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
777: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'l_ignore := '||l_ignore);
778: END IF;
779: dbms_sql.column_value(v_cursor_id, 1, c_total_balance);
780: ELSIF c_sf133_balance_type = 'N' THEN

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

773: dbms_sql.bind_variable(v_cursor_id, ':cv_balance_type','P');
774: dbms_sql.bind_variable(v_cursor_id,':cv_period',c_end_period);
775: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
776: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
777: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'l_ignore := '||l_ignore);
778: END IF;
779: dbms_sql.column_value(v_cursor_id, 1, c_total_balance);
780: ELSIF c_sf133_balance_type = 'N' THEN
781: dbms_sql.bind_variable(v_cursor_id, ':cv_balance_type','N');

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

780: ELSIF c_sf133_balance_type = 'N' THEN
781: dbms_sql.bind_variable(v_cursor_id, ':cv_balance_type','N');
782: dbms_sql.bind_variable(v_cursor_id,':cv_period',c_end_period);
783: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
784: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
785: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'l_ignore := '||l_ignore);
786: END IF;
787: dbms_sql.column_value(v_cursor_id, 1, c_total_balance);
788: ELSIF c_sf133_balance_type in ('D','S') THEN

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

781: dbms_sql.bind_variable(v_cursor_id, ':cv_balance_type','N');
782: dbms_sql.bind_variable(v_cursor_id,':cv_period',c_end_period);
783: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
784: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
785: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'l_ignore := '||l_ignore);
786: END IF;
787: dbms_sql.column_value(v_cursor_id, 1, c_total_balance);
788: ELSIF c_sf133_balance_type in ('D','S') THEN
789: dbms_sql.bind_variable(v_cursor_id, ':cv_balance_type','E');

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

788: ELSIF c_sf133_balance_type in ('D','S') THEN
789: dbms_sql.bind_variable(v_cursor_id, ':cv_balance_type','E');
790: dbms_sql.bind_variable(v_cursor_id,':cv_period',c_end_period);
791: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
792: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
793: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'l_ignore := '||l_ignore);
794: END IF;
795: dbms_sql.column_value(v_cursor_id, 1, c_ending_balance);
796: dbms_sql.bind_variable(v_cursor_id, ':cv_balance_type','B');

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

789: dbms_sql.bind_variable(v_cursor_id, ':cv_balance_type','E');
790: dbms_sql.bind_variable(v_cursor_id,':cv_period',c_end_period);
791: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
792: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
793: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'l_ignore := '||l_ignore);
794: END IF;
795: dbms_sql.column_value(v_cursor_id, 1, c_ending_balance);
796: dbms_sql.bind_variable(v_cursor_id, ':cv_balance_type','B');
797: dbms_sql.bind_variable(v_cursor_id,':cv_period',c_begin_period);

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

795: dbms_sql.column_value(v_cursor_id, 1, c_ending_balance);
796: dbms_sql.bind_variable(v_cursor_id, ':cv_balance_type','B');
797: dbms_sql.bind_variable(v_cursor_id,':cv_period',c_begin_period);
798: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
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,'l_ignore := '||l_ignore);
801: END IF;
802: dbms_sql.column_value(v_cursor_id, 1, c_begin_balance);
803:

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

796: dbms_sql.bind_variable(v_cursor_id, ':cv_balance_type','B');
797: dbms_sql.bind_variable(v_cursor_id,':cv_period',c_begin_period);
798: l_ignore := dbms_sql.execute_and_fetch(v_cursor_id);
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,'l_ignore := '||l_ignore);
801: END IF;
802: dbms_sql.column_value(v_cursor_id, 1, c_begin_balance);
803:
804: IF c_sf133_balance_type = 'D' THEN

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

806: ELSIF c_sf133_balance_type = 'S' THEN
807: c_total_balance := c_begin_balance - c_ending_balance;
808: END IF;
809: END IF;
810: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
811: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_TOTAL_BALANCE = '||C_TOTAL_BALANCE);
812: END IF;
813:
814: END IF;

Line 811: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_TOTAL_BALANCE = '||C_TOTAL_BALANCE);

807: c_total_balance := c_begin_balance - c_ending_balance;
808: END IF;
809: END IF;
810: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
811: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'C_TOTAL_BALANCE = '||C_TOTAL_BALANCE);
812: END IF;
813:
814: END IF;
815: -- sum the line amount

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

813:
814: END IF;
815: -- sum the line amount
816: c_sf133_amount_not_shown := c_sf133_amount_not_shown + c_total_balance;
817: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
818: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'AMT NOT SHOWN = '||C_SF133_AMOUNT_NOT_SHOWN);
819: END IF;
820:
821: END LOOP;

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

814: END IF;
815: -- sum the line amount
816: c_sf133_amount_not_shown := c_sf133_amount_not_shown + c_total_balance;
817: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
818: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'AMT NOT SHOWN = '||C_SF133_AMOUNT_NOT_SHOWN);
819: END IF;
820:
821: END LOOP;
822: --dbms_sql.close_cursor(v_cursor_id);

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

822: --dbms_sql.close_cursor(v_cursor_id);
823: --
824: -- set up correct display sign
825: --
826: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
827: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'NATURAL BAL TYPE = '||C_SF133_NATURAL_BAL_TYPE);
828: END IF;
829: IF c_sf133_natural_bal_type = 'C' THEN
830: -- Credit so display opposite

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

823: --
824: -- set up correct display sign
825: --
826: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
827: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'NATURAL BAL TYPE = '||C_SF133_NATURAL_BAL_TYPE);
828: END IF;
829: IF c_sf133_natural_bal_type = 'C' THEN
830: -- Credit so display opposite
831: c_sf133_column_amount := c_sf133_amount_not_shown * -1;

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

851: o_sf133_column_amount := c_sf133_column_amount;
852: o_sf133_amt_not_shown := c_sf133_amount_not_shown;
853: o_sf133_treasury_symbol_id := c_sf133_treasury_symbol_id; --added for 1575992
854:
855: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
856: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'COL AMT ='||O_SF133_COLUMN_AMOUNT);
857: END IF;
858:
859:

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

852: o_sf133_amt_not_shown := c_sf133_amount_not_shown;
853: o_sf133_treasury_symbol_id := c_sf133_treasury_symbol_id; --added for 1575992
854:
855: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
856: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'COL AMT ='||O_SF133_COLUMN_AMOUNT);
857: END IF;
858:
859:
860: populate_temp_table;

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

875: ELSIF dbms_sql.is_open(v_cursor_id) THEN
876: dbms_sql.close_cursor(v_cursor_id);
877: END IF;
878:
879: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.exception','BUILD_FISCAL_LINE_COLUMNS:'||G_ERROR_MESSAGE);
880: --
881: END build_fiscal_line_columns;
882: -- ----------------------------------------------
883: -- ----------------------------------------------

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

890: BEGIN
891: l_module_name := g_module_name || 'build_total_line_columns';
892: --
893: IF parm_run_mode = 'T' THEN
894: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
895: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'START BUILD_TOTAL_LINE_COLUMNS');
896: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'-- LINE='||C_SF133_LINE_NUMBER
897: ||' Start Total Line('||g_total_start_line_number||')'
898: || ' Treasury Symbol('||c_sf133_ts_value||')');

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

891: l_module_name := g_module_name || 'build_total_line_columns';
892: --
893: IF parm_run_mode = 'T' THEN
894: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
895: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'START BUILD_TOTAL_LINE_COLUMNS');
896: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'-- LINE='||C_SF133_LINE_NUMBER
897: ||' Start Total Line('||g_total_start_line_number||')'
898: || ' Treasury Symbol('||c_sf133_ts_value||')');
899: END IF;

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

892: --
893: IF parm_run_mode = 'T' THEN
894: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
895: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'START BUILD_TOTAL_LINE_COLUMNS');
896: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'-- LINE='||C_SF133_LINE_NUMBER
897: ||' Start Total Line('||g_total_start_line_number||')'
898: || ' Treasury Symbol('||c_sf133_ts_value||')');
899: END IF;
900: END IF;

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

914: WHERE set_of_books_id = parm_set_of_books_id
915: AND sf133_line_number >
916: DECODE(c_sf133_line_type_code, 'T', g_total_start_line_number, g_subtotal_start_line_number)
917: AND sf133_line_number < c_sf133_line_number);
918: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
919: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'SRART ' || G_TOTAL_START_LINE_NUMBER);
920: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'END: ' || C_SF133_LINE_NUMBER);
921: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'AMTNS: ' || C_SF133_AMOUNT_NOT_SHOWN);
922: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'NATURAL BAL TYPE = '||C_SF133_NATURAL_BAL_TYPE);

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

915: AND sf133_line_number >
916: DECODE(c_sf133_line_type_code, 'T', g_total_start_line_number, g_subtotal_start_line_number)
917: AND sf133_line_number < c_sf133_line_number);
918: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
919: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'SRART ' || G_TOTAL_START_LINE_NUMBER);
920: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'END: ' || C_SF133_LINE_NUMBER);
921: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'AMTNS: ' || C_SF133_AMOUNT_NOT_SHOWN);
922: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'NATURAL BAL TYPE = '||C_SF133_NATURAL_BAL_TYPE);
923: END IF;

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

916: DECODE(c_sf133_line_type_code, 'T', g_total_start_line_number, g_subtotal_start_line_number)
917: AND sf133_line_number < c_sf133_line_number);
918: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
919: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'SRART ' || G_TOTAL_START_LINE_NUMBER);
920: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'END: ' || C_SF133_LINE_NUMBER);
921: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'AMTNS: ' || C_SF133_AMOUNT_NOT_SHOWN);
922: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'NATURAL BAL TYPE = '||C_SF133_NATURAL_BAL_TYPE);
923: END IF;
924:

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

917: AND sf133_line_number < c_sf133_line_number);
918: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
919: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'SRART ' || G_TOTAL_START_LINE_NUMBER);
920: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'END: ' || C_SF133_LINE_NUMBER);
921: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'AMTNS: ' || C_SF133_AMOUNT_NOT_SHOWN);
922: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'NATURAL BAL TYPE = '||C_SF133_NATURAL_BAL_TYPE);
923: END IF;
924:
925: IF c_sf133_natural_bal_type = 'C' THEN

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

918: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
919: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'SRART ' || G_TOTAL_START_LINE_NUMBER);
920: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'END: ' || C_SF133_LINE_NUMBER);
921: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'AMTNS: ' || C_SF133_AMOUNT_NOT_SHOWN);
922: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'NATURAL BAL TYPE = '||C_SF133_NATURAL_BAL_TYPE);
923: END IF;
924:
925: IF c_sf133_natural_bal_type = 'C' THEN
926: -- Credit so display opposite

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

939: c_sf133_column_amount := '-'||ABS(c_sf133_amount_not_shown);
940:
941: END IF;
942:
943: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
944: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'BALT: ' || C_SF133_NATURAL_BAL_TYPE);
945: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'AMT: ' || C_SF133_COLUMN_AMOUNT);
946: END IF;
947:

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

940:
941: END IF;
942:
943: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
944: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'BALT: ' || C_SF133_NATURAL_BAL_TYPE);
945: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'AMT: ' || C_SF133_COLUMN_AMOUNT);
946: END IF;
947:
948: --

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

941: END IF;
942:
943: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
944: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'BALT: ' || C_SF133_NATURAL_BAL_TYPE);
945: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'AMT: ' || C_SF133_COLUMN_AMOUNT);
946: END IF;
947:
948: --
949: -- ------------------------------------

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

964: --
965: WHEN OTHERS THEN
966: g_error_code := SQLCODE;
967: g_error_message := SQLERRM;
968: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.exception','BUILD_TOTAL_LINE_COLUMNS');
969: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.exception',g_error_message );
970: --
971: END build_total_line_columns;
972: -- ----------------------------------------------

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

965: WHEN OTHERS THEN
966: g_error_code := SQLCODE;
967: g_error_message := SQLERRM;
968: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.exception','BUILD_TOTAL_LINE_COLUMNS');
969: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.exception',g_error_message );
970: --
971: END build_total_line_columns;
972: -- ----------------------------------------------
973: -- --------------------------------------------------------

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

980: BEGIN
981: l_module_name := g_module_name || 'populate_temp_table';
982: --
983: IF parm_run_mode = 'T' THEN
984: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
985: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'START POPULATE_TEMP_TABLE');
986: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, '-- '||C_SF133_LINE_NUMBER
987: ||' ('||o_sf133_column_number||')'
988: ||' ('||o_sf133_column_amount||')'

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

981: l_module_name := g_module_name || 'populate_temp_table';
982: --
983: IF parm_run_mode = 'T' THEN
984: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
985: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'START POPULATE_TEMP_TABLE');
986: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, '-- '||C_SF133_LINE_NUMBER
987: ||' ('||o_sf133_column_number||')'
988: ||' ('||o_sf133_column_amount||')'
989: ||' ('||o_sf133_amt_not_shown||')');

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

982: --
983: IF parm_run_mode = 'T' THEN
984: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
985: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'START POPULATE_TEMP_TABLE');
986: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, '-- '||C_SF133_LINE_NUMBER
987: ||' ('||o_sf133_column_number||')'
988: ||' ('||o_sf133_column_amount||')'
989: ||' ('||o_sf133_amt_not_shown||')');
990: END IF;

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

1019: --
1020: WHEN OTHERS THEN
1021: g_error_code := SQLCODE;
1022: g_error_message := SQLERRM;
1023: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.exception',G_ERROR_MESSAGE);
1024: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.exception','-- POPULATE_TEMP_TABLE');
1025: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.exception','---- TREASURY SYMBOL:'||O_SF133_TS_VALUE
1026: ||' Line Id:'||o_sf133_line_id
1027: ||' Col:' ||o_sf133_column_number

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

1020: WHEN OTHERS THEN
1021: g_error_code := SQLCODE;
1022: g_error_message := SQLERRM;
1023: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.exception',G_ERROR_MESSAGE);
1024: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.exception','-- POPULATE_TEMP_TABLE');
1025: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.exception','---- TREASURY SYMBOL:'||O_SF133_TS_VALUE
1026: ||' Line Id:'||o_sf133_line_id
1027: ||' Col:' ||o_sf133_column_number
1028: ||' Amt:' ||o_sf133_column_amount);

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

1021: g_error_code := SQLCODE;
1022: g_error_message := SQLERRM;
1023: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.exception',G_ERROR_MESSAGE);
1024: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.exception','-- POPULATE_TEMP_TABLE');
1025: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.exception','---- TREASURY SYMBOL:'||O_SF133_TS_VALUE
1026: ||' Line Id:'||o_sf133_line_id
1027: ||' Col:' ||o_sf133_column_number
1028: ||' Amt:' ||o_sf133_column_amount);
1029: --

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

1124:
1125: BEGIN
1126: l_module_name := g_module_name || 'populate_gtt_with_ccid';
1127:
1128: IF ( fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1129: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'Entering Module '||l_module_name);
1130: END IF;
1131:
1132: FOR crec_rec IN crec_cursor (parm_set_of_books_id) LOOP

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

1125: BEGIN
1126: l_module_name := g_module_name || 'populate_gtt_with_ccid';
1127:
1128: IF ( fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1129: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'Entering Module '||l_module_name);
1130: END IF;
1131:
1132: FOR crec_rec IN crec_cursor (parm_set_of_books_id) LOOP
1133:

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

1130: END IF;
1131:
1132: FOR crec_rec IN crec_cursor (parm_set_of_books_id) LOOP
1133:
1134: IF ( fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1135: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'sf133_line_acct_id = '||crec_rec.sf133_line_acct_id);
1136: END IF;
1137:
1138: v_seg(1) := crec_rec.segment1;

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

1131:
1132: FOR crec_rec IN crec_cursor (parm_set_of_books_id) LOOP
1133:
1134: IF ( fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1135: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'sf133_line_acct_id = '||crec_rec.sf133_line_acct_id);
1136: END IF;
1137:
1138: v_seg(1) := crec_rec.segment1;
1139: v_seg(2) := crec_rec.segment2;

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

1169: v_statement := NULL;
1170:
1171: FOR i IN 1 ..30 LOOP
1172: v_seg_str(i) := NULL;
1173: IF ( fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1174: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'v_seg('||i||')='||v_seg(i));
1175: END IF;
1176: END LOOP;
1177:

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

1170:
1171: FOR i IN 1 ..30 LOOP
1172: v_seg_str(i) := NULL;
1173: IF ( fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1174: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'v_seg('||i||')='||v_seg(i));
1175: END IF;
1176: END LOOP;
1177:
1178: l_no_of_seg := 0;

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

1177:
1178: l_no_of_seg := 0;
1179:
1180: FOR flex_rec IN flex_cursor (g_chart_of_accounts_id) LOOP
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,'application_column_name = '||flex_rec.application_column_name);
1183: END IF;
1184: l_no_of_child := 0;
1185: l_and := NULL;

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

1178: l_no_of_seg := 0;
1179:
1180: FOR flex_rec IN flex_cursor (g_chart_of_accounts_id) LOOP
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,'application_column_name = '||flex_rec.application_column_name);
1183: END IF;
1184: l_no_of_child := 0;
1185: l_and := NULL;
1186:

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

1185: l_and := NULL;
1186:
1187: /* check the segment values is parent */
1188: l_segno := SUBSTR(flex_rec.application_column_name,8,2);
1189: IF ( fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1190: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'l_segno = '||l_segno);
1191: END IF;
1192:
1193: IF (v_seg(l_segno) IS NOT NULL) THEN

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

1186:
1187: /* check the segment values is parent */
1188: l_segno := SUBSTR(flex_rec.application_column_name,8,2);
1189: IF ( fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1190: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'l_segno = '||l_segno);
1191: END IF;
1192:
1193: IF (v_seg(l_segno) IS NOT NULL) THEN
1194: SELECT COUNT(*)

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

1196: FROM fnd_flex_value_hierarchies
1197: WHERE parent_flex_value = v_seg(l_segno)
1198: AND flex_value_set_id = flex_rec.flex_value_set_id;
1199:
1200: IF ( fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1201: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'l_cnt = '||l_cnt);
1202: END IF;
1203:
1204: OPEN child_value_cursor(v_seg(l_segno) , flex_rec.flex_value_set_id);

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

1197: WHERE parent_flex_value = v_seg(l_segno)
1198: AND flex_value_set_id = flex_rec.flex_value_set_id;
1199:
1200: IF ( fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1201: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'l_cnt = '||l_cnt);
1202: END IF;
1203:
1204: OPEN child_value_cursor(v_seg(l_segno) , flex_rec.flex_value_set_id);
1205:

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

1203:
1204: OPEN child_value_cursor(v_seg(l_segno) , flex_rec.flex_value_set_id);
1205:
1206: IF (l_cnt > 0) THEN
1207: IF ( fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1208: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'l_cnt > 0');
1209: END IF;
1210:
1211: l_and := NULL;

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

1204: OPEN child_value_cursor(v_seg(l_segno) , flex_rec.flex_value_set_id);
1205:
1206: IF (l_cnt > 0) THEN
1207: IF ( fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1208: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'l_cnt > 0');
1209: END IF;
1210:
1211: l_and := NULL;
1212:

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

1240: l_and := NULL;
1241: v_statement := v_statement || l_and || l_child || fnd_global.local_chr(10);
1242:
1243: ELSE
1244: IF ( fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1245: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'l_cnt not > 0');
1246: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'l_no_of_seg='||l_no_of_seg);
1247: END IF;
1248: IF (l_no_of_seg > 0) THEN

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

1241: v_statement := v_statement || l_and || l_child || fnd_global.local_chr(10);
1242:
1243: ELSE
1244: IF ( fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1245: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'l_cnt not > 0');
1246: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'l_no_of_seg='||l_no_of_seg);
1247: END IF;
1248: IF (l_no_of_seg > 0) THEN
1249: l_and := ' AND ';

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

1242:
1243: ELSE
1244: IF ( fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1245: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'l_cnt not > 0');
1246: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'l_no_of_seg='||l_no_of_seg);
1247: END IF;
1248: IF (l_no_of_seg > 0) THEN
1249: l_and := ' AND ';
1250: END IF;

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

1259: END IF; --v_seg(l_segno) IS NOT NULL
1260:
1261: END LOOP; --FLEX_CURSOR
1262:
1263: IF ( fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1264: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'v_statement = '||v_statement);
1265: END IF;
1266:
1267: IF (v_statement IS NOT NULL) THEN

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

1260:
1261: END LOOP; --FLEX_CURSOR
1262:
1263: IF ( fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1264: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'v_statement = '||v_statement);
1265: END IF;
1266:
1267: IF (v_statement IS NOT NULL) THEN
1268: v_insert_statement := 'INSERT INTO fv_sf133_ccids_gt

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

1285: FROM fv_sf133_ccids_gt fct
1286: WHERE fct.sf133_line_acct_id =:b_sf133_line_acct_id
1287: AND fct.ccid = gcc.code_combination_id)';
1288:
1289: IF ( fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1290: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'v_insert_statement = '||v_insert_statement);
1291: END IF;
1292:
1293: EXECUTE IMMEDIATE v_insert_statement

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

1286: WHERE fct.sf133_line_acct_id =:b_sf133_line_acct_id
1287: AND fct.ccid = gcc.code_combination_id)';
1288:
1289: IF ( fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1290: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'v_insert_statement = '||v_insert_statement);
1291: END IF;
1292:
1293: EXECUTE IMMEDIATE v_insert_statement
1294: USING crec_rec.sf133_line_acct_id,

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

1299: crec_rec.sf133_line_acct_id;
1300: END IF;
1301: END LOOP; --crec_cursor
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,'Exiting Module = '||l_module_name);
1305: END IF;
1306:
1307: EXCEPTION

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

1300: END IF;
1301: END LOOP; --crec_cursor
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,'Exiting Module = '||l_module_name);
1305: END IF;
1306:
1307: EXCEPTION
1308: WHEN OTHERS THEN

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

1307: EXCEPTION
1308: WHEN OTHERS THEN
1309: g_error_code := SQLCODE;
1310: g_error_message := SQLERRM;
1311: fv_utility.log_mesg(fnd_log.level_unexpected, l_module_name||'.exception',g_error_message);
1312: fv_utility.log_mesg(fnd_log.level_unexpected, l_module_name||'.exception','-- populate_gtt_with_ccid');
1313: END;
1314: -- --------------------------------------------------------
1315: -- --------------------------------------------------------

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

1308: WHEN OTHERS THEN
1309: g_error_code := SQLCODE;
1310: g_error_message := SQLERRM;
1311: fv_utility.log_mesg(fnd_log.level_unexpected, l_module_name||'.exception',g_error_message);
1312: fv_utility.log_mesg(fnd_log.level_unexpected, l_module_name||'.exception','-- populate_gtt_with_ccid');
1313: END;
1314: -- --------------------------------------------------------
1315: -- --------------------------------------------------------
1316: BEGIN