2582: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
2583:
2584: BEGIN
2585: IF (l_debug = 'Y') THEN
2586: okc_debug.Set_Indentation('OKS_CVT_PVT');
2587: okc_debug.log('23700: Entered create_version', 2);
2588: END IF;
2589:
2590: INSERT INTO OKS_COVERAGE_TIMES_H(
2583:
2584: BEGIN
2585: IF (l_debug = 'Y') THEN
2586: okc_debug.Set_Indentation('OKS_CVT_PVT');
2587: okc_debug.log('23700: Entered create_version', 2);
2588: END IF;
2589:
2590: INSERT INTO OKS_COVERAGE_TIMES_H(
2591: ID,
2646:
2647: RETURN l_return_status;
2648:
2649: IF (l_debug = 'Y') THEN
2650: okc_debug.log('23800: Exiting create_version', 2);
2651: END IF;
2652:
2653: EXCEPTION
2654:
2655:
2656: WHEN OTHERS THEN
2657:
2658: IF (l_debug = 'Y') THEN
2659: okc_debug.log('23900: Exiting create_version:OTHERS Exception', 2);
2660: okc_debug.Reset_Indentation;
2661: END IF;
2662:
2663: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,
2656: WHEN OTHERS THEN
2657:
2658: IF (l_debug = 'Y') THEN
2659: okc_debug.log('23900: Exiting create_version:OTHERS Exception', 2);
2660: okc_debug.Reset_Indentation;
2661: END IF;
2662:
2663: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,
2664: p_msg_name => okc_version_pvt.G_UNEXPECTED_ERROR,
2681:
2682: BEGIN
2683:
2684: IF (l_debug = 'Y') THEN
2685: okc_debug.Set_Indentation('OKS_CVT_PVT');
2686: okc_debug.log('24000: Exiting restore_version:OTHERS Exception', 2);
2687: END IF;
2688:
2689: DELETE OKS_COVERAGE_TIMES
2682: BEGIN
2683:
2684: IF (l_debug = 'Y') THEN
2685: okc_debug.Set_Indentation('OKS_CVT_PVT');
2686: okc_debug.log('24000: Exiting restore_version:OTHERS Exception', 2);
2687: END IF;
2688:
2689: DELETE OKS_COVERAGE_TIMES
2690: WHERE DNZ_CHR_ID = p_id;
2748:
2749: RETURN l_return_status;
2750:
2751: IF (l_debug = 'Y') THEN
2752: okc_debug.log('24100: Exiting restore_version:OTHERS Exception', 2);
2753: END IF;
2754:
2755: EXCEPTION
2756: WHEN OTHERS THEN
2755: EXCEPTION
2756: WHEN OTHERS THEN
2757:
2758: IF (l_debug = 'Y') THEN
2759: okc_debug.log('24200: Exiting restore_version:OTHERS Exception', 2);
2760: okc_debug.Reset_Indentation;
2761: END IF;
2762:
2763: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,
2756: WHEN OTHERS THEN
2757:
2758: IF (l_debug = 'Y') THEN
2759: okc_debug.log('24200: Exiting restore_version:OTHERS Exception', 2);
2760: okc_debug.Reset_Indentation;
2761: END IF;
2762:
2763: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,
2764: p_msg_name => okc_version_pvt.G_UNEXPECTED_ERROR,