482: AND ffvh.child_flex_value_high
483: AND ffv.flex_value_set_id = :g_value_set_id AND ffv.flex_value_set_id = ffvh.flex_value_set_id'||
484: ' AND parent_flex_value = :l_cash_ussgl_acct)) AND GLB.period_year = :l_period_year AND GLB.period_num = :l_period_num AND GLB.LEDGER_ID = :g_set_of_books_id AND glb.currency_code = :l_currency_code';
485:
486: IBY_PAYMENT_FORMAT_VAL_PVT.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, 'Dynamic SQL Statement');
487: IBY_PAYMENT_FORMAT_VAL_PVT.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, l_bal_select);
488: IBY_PAYMENT_FORMAT_VAL_PVT.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, ':l_cash_ussgl_acct = ' || l_cash_ussgl_acct);
489: IBY_PAYMENT_FORMAT_VAL_PVT.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, ':l_period_year = ' || l_period_year);
490: IBY_PAYMENT_FORMAT_VAL_PVT.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, ':l_period_num = ' || l_period_num);
483: AND ffv.flex_value_set_id = :g_value_set_id AND ffv.flex_value_set_id = ffvh.flex_value_set_id'||
484: ' AND parent_flex_value = :l_cash_ussgl_acct)) AND GLB.period_year = :l_period_year AND GLB.period_num = :l_period_num AND GLB.LEDGER_ID = :g_set_of_books_id AND glb.currency_code = :l_currency_code';
485:
486: IBY_PAYMENT_FORMAT_VAL_PVT.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, 'Dynamic SQL Statement');
487: IBY_PAYMENT_FORMAT_VAL_PVT.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, l_bal_select);
488: IBY_PAYMENT_FORMAT_VAL_PVT.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, ':l_cash_ussgl_acct = ' || l_cash_ussgl_acct);
489: IBY_PAYMENT_FORMAT_VAL_PVT.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, ':l_period_year = ' || l_period_year);
490: IBY_PAYMENT_FORMAT_VAL_PVT.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, ':l_period_num = ' || l_period_num);
491: IBY_PAYMENT_FORMAT_VAL_PVT.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, ':g_set_of_books_id = ' || g_set_of_books_id);
484: ' AND parent_flex_value = :l_cash_ussgl_acct)) AND GLB.period_year = :l_period_year AND GLB.period_num = :l_period_num AND GLB.LEDGER_ID = :g_set_of_books_id AND glb.currency_code = :l_currency_code';
485:
486: IBY_PAYMENT_FORMAT_VAL_PVT.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, 'Dynamic SQL Statement');
487: IBY_PAYMENT_FORMAT_VAL_PVT.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, l_bal_select);
488: IBY_PAYMENT_FORMAT_VAL_PVT.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, ':l_cash_ussgl_acct = ' || l_cash_ussgl_acct);
489: IBY_PAYMENT_FORMAT_VAL_PVT.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, ':l_period_year = ' || l_period_year);
490: IBY_PAYMENT_FORMAT_VAL_PVT.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, ':l_period_num = ' || l_period_num);
491: IBY_PAYMENT_FORMAT_VAL_PVT.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, ':g_set_of_books_id = ' || g_set_of_books_id);
492: IBY_PAYMENT_FORMAT_VAL_PVT.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, ':l_currency_code = ' || l_currency_code);
485:
486: IBY_PAYMENT_FORMAT_VAL_PVT.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, 'Dynamic SQL Statement');
487: IBY_PAYMENT_FORMAT_VAL_PVT.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, l_bal_select);
488: IBY_PAYMENT_FORMAT_VAL_PVT.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, ':l_cash_ussgl_acct = ' || l_cash_ussgl_acct);
489: IBY_PAYMENT_FORMAT_VAL_PVT.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, ':l_period_year = ' || l_period_year);
490: IBY_PAYMENT_FORMAT_VAL_PVT.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, ':l_period_num = ' || l_period_num);
491: IBY_PAYMENT_FORMAT_VAL_PVT.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, ':g_set_of_books_id = ' || g_set_of_books_id);
492: IBY_PAYMENT_FORMAT_VAL_PVT.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, ':l_currency_code = ' || l_currency_code);
493: IBY_PAYMENT_FORMAT_VAL_PVT.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, ':g_value_set_id = ' || g_value_set_id);
486: IBY_PAYMENT_FORMAT_VAL_PVT.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, 'Dynamic SQL Statement');
487: IBY_PAYMENT_FORMAT_VAL_PVT.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, l_bal_select);
488: IBY_PAYMENT_FORMAT_VAL_PVT.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, ':l_cash_ussgl_acct = ' || l_cash_ussgl_acct);
489: IBY_PAYMENT_FORMAT_VAL_PVT.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, ':l_period_year = ' || l_period_year);
490: IBY_PAYMENT_FORMAT_VAL_PVT.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, ':l_period_num = ' || l_period_num);
491: IBY_PAYMENT_FORMAT_VAL_PVT.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, ':g_set_of_books_id = ' || g_set_of_books_id);
492: IBY_PAYMENT_FORMAT_VAL_PVT.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, ':l_currency_code = ' || l_currency_code);
493: IBY_PAYMENT_FORMAT_VAL_PVT.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, ':g_value_set_id = ' || g_value_set_id);
494:
487: IBY_PAYMENT_FORMAT_VAL_PVT.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, l_bal_select);
488: IBY_PAYMENT_FORMAT_VAL_PVT.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, ':l_cash_ussgl_acct = ' || l_cash_ussgl_acct);
489: IBY_PAYMENT_FORMAT_VAL_PVT.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, ':l_period_year = ' || l_period_year);
490: IBY_PAYMENT_FORMAT_VAL_PVT.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, ':l_period_num = ' || l_period_num);
491: IBY_PAYMENT_FORMAT_VAL_PVT.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, ':g_set_of_books_id = ' || g_set_of_books_id);
492: IBY_PAYMENT_FORMAT_VAL_PVT.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, ':l_currency_code = ' || l_currency_code);
493: IBY_PAYMENT_FORMAT_VAL_PVT.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, ':g_value_set_id = ' || g_value_set_id);
494:
495:
488: IBY_PAYMENT_FORMAT_VAL_PVT.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, ':l_cash_ussgl_acct = ' || l_cash_ussgl_acct);
489: IBY_PAYMENT_FORMAT_VAL_PVT.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, ':l_period_year = ' || l_period_year);
490: IBY_PAYMENT_FORMAT_VAL_PVT.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, ':l_period_num = ' || l_period_num);
491: IBY_PAYMENT_FORMAT_VAL_PVT.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, ':g_set_of_books_id = ' || g_set_of_books_id);
492: IBY_PAYMENT_FORMAT_VAL_PVT.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, ':l_currency_code = ' || l_currency_code);
493: IBY_PAYMENT_FORMAT_VAL_PVT.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, ':g_value_set_id = ' || g_value_set_id);
494:
495:
496:
489: IBY_PAYMENT_FORMAT_VAL_PVT.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, ':l_period_year = ' || l_period_year);
490: IBY_PAYMENT_FORMAT_VAL_PVT.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, ':l_period_num = ' || l_period_num);
491: IBY_PAYMENT_FORMAT_VAL_PVT.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, ':g_set_of_books_id = ' || g_set_of_books_id);
492: IBY_PAYMENT_FORMAT_VAL_PVT.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, ':l_currency_code = ' || l_currency_code);
493: IBY_PAYMENT_FORMAT_VAL_PVT.log_error_messages(FND_LOG.LEVEL_STATEMENT, l_module_name, ':g_value_set_id = ' || g_value_set_id);
494:
495:
496:
497: