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