[Home] [Help]
918: l_return_status VARCHAR2(1);
919: l_api_version NUMBER;
920: l_init_msg_list VARCHAR2(1);
921: l_total_length CONSTANT NUMBER DEFAULT 152;
922: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_BILLING_UTIL_PVT.CHECK_PREUPGRADE_DATA';
923: l_debug_enabled VARCHAR2(10);
924: is_debug_procedure_on BOOLEAN;
925: is_debug_statement_on BOOLEAN;
926: l_contract VARCHAR2(120);
1026:
1027: x_any_data_exists := false; -- VPANWAR changed for pre upgrade test
1028:
1029: /* l_debug_enabled := okl_debug_pub.check_log_enabled;
1030: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
1031: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
1032: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRBULB.pls call CHECK_PREUPGRADE_DATA');
1033: END IF;*/
1034:
1028:
1029: /* l_debug_enabled := okl_debug_pub.check_log_enabled;
1030: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
1031: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
1032: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRBULB.pls call CHECK_PREUPGRADE_DATA');
1033: END IF;*/
1034:
1035: x_retcode := 0;
1036: x_errbuf := null;
1197: CLOSE cnsld_pstv_check_csr;
1198:
1199: okl_api.END_ACTIVITY(l_msg_count, l_msg_data);
1200: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
1201: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRUPGB.pls call IN_PROCESS_BILLING_TXN');
1202: END IF;
1203:
1204: EXCEPTION
1205: WHEN OTHERS THEN