[Home] [Help]
765: l_return_status VARCHAR2(1);
766: l_api_version NUMBER;
767: l_init_msg_list VARCHAR2(1);
768: l_total_length CONSTANT NUMBER DEFAULT 152;
769: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_BILLING_UTIL_PVT.CHECK_PREUPGRADE_DATA';
770: l_debug_enabled VARCHAR2(10);
771: is_debug_procedure_on BOOLEAN;
772: is_debug_statement_on BOOLEAN;
773: l_contract VARCHAR2(120);
873:
874: x_any_data_exists := false; -- VPANWAR changed for pre upgrade test
875:
876: /* l_debug_enabled := okl_debug_pub.check_log_enabled;
877: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
878: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
879: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRBULB.pls call CHECK_PREUPGRADE_DATA');
880: END IF;*/
881:
875:
876: /* l_debug_enabled := okl_debug_pub.check_log_enabled;
877: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
878: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
879: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRBULB.pls call CHECK_PREUPGRADE_DATA');
880: END IF;*/
881:
882: x_retcode := 0;
883: x_errbuf := null;
1044: CLOSE cnsld_pstv_check_csr;
1045:
1046: okl_api.END_ACTIVITY(l_msg_count, l_msg_data);
1047: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
1048: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRUPGB.pls call IN_PROCESS_BILLING_TXN');
1049: END IF;
1050:
1051: EXCEPTION
1052: WHEN OTHERS THEN