[Home] [Help]
4808:
4809: l_exists VARCHAR2(1);
4810: l_fetch_size NUMBER := 5000;
4811:
4812: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_REPORT_PVT.PRE_BILLING';
4813: l_debug_enabled VARCHAR2(10);
4814: is_debug_procedure_on BOOLEAN;
4815: is_debug_statement_on BOOLEAN;
4816: x_errbuf VARCHAR2(1000);
4824:
4825: BEGIN
4826:
4827: l_debug_enabled := okl_debug_pub.check_log_enabled;
4828: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
4829:
4830: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
4831: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin procedure pre_billing_proc');
4832: END IF;
4827: l_debug_enabled := okl_debug_pub.check_log_enabled;
4828: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
4829:
4830: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
4831: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin procedure pre_billing_proc');
4832: END IF;
4833:
4834: -- check for logging on STATEMENT level
4835: is_debug_statement_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);
4831: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin procedure pre_billing_proc');
4832: END IF;
4833:
4834: -- check for logging on STATEMENT level
4835: is_debug_statement_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);
4836:
4837: OPEN c_streams;
4838: LOOP
4839: -- Clear table contents
5118: END LOOP; -- Loop a/c c_streams
5119: CLOSE c_streams;
5120:
5121: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
5122: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end procedure pre_billing_proc');
5123: END IF;
5124: RETURN TRUE;
5125: EXCEPTION
5126: WHEN OTHERS THEN