3005: l_st_progress_status okl_book_controller_trx.progress_status%TYPE;
3006: l_bk_progress_status okl_book_controller_trx.progress_status%TYPE;
3007:
3008: BEGIN
3009: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3010: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_BOOK_CONTROLLER_PVT.init_book_controller_trx.', 'Begin(+)');
3011: END IF;
3012:
3013: x_batch_number := null;
3006: l_bk_progress_status okl_book_controller_trx.progress_status%TYPE;
3007:
3008: BEGIN
3009: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3010: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_BOOK_CONTROLLER_PVT.init_book_controller_trx.', 'Begin(+)');
3011: END IF;
3012:
3013: x_batch_number := null;
3014: x_return_status := OKL_API.G_RET_STS_SUCCESS;
3139:
3140: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
3141: x_msg_data => x_msg_data);
3142:
3143: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3144: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_BOOK_CONTROLLER_PVT.init_book_controller_trx.', 'End(-)');
3145: END IF;
3146:
3147: EXCEPTION
3140: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
3141: x_msg_data => x_msg_data);
3142:
3143: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3144: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_BOOK_CONTROLLER_PVT.init_book_controller_trx.', 'End(-)');
3145: END IF;
3146:
3147: EXCEPTION
3148: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3153: x_msg_count => x_msg_count,
3154: x_msg_data => x_msg_data,
3155: p_api_type => g_api_type);
3156:
3157: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3158: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'OKL_BOOK_CONTROLLER_PVT.init_book_controller_trx.', 'EXP - ERROR');
3159: END IF;
3160:
3161: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3154: x_msg_data => x_msg_data,
3155: p_api_type => g_api_type);
3156:
3157: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3158: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'OKL_BOOK_CONTROLLER_PVT.init_book_controller_trx.', 'EXP - ERROR');
3159: END IF;
3160:
3161: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3162: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
3166: x_msg_count => x_msg_count,
3167: x_msg_data => x_msg_data,
3168: p_api_type => g_api_type);
3169:
3170: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3171: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'OKL_BOOK_CONTROLLER_PVT.init_book_controller_trx.', 'EXP - UNEXCP ERROR');
3172: END IF;
3173:
3174: WHEN OTHERS THEN
3167: x_msg_data => x_msg_data,
3168: p_api_type => g_api_type);
3169:
3170: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3171: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'OKL_BOOK_CONTROLLER_PVT.init_book_controller_trx.', 'EXP - UNEXCP ERROR');
3172: END IF;
3173:
3174: WHEN OTHERS THEN
3175: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
3179: x_msg_count => x_msg_count,
3180: x_msg_data => x_msg_data,
3181: p_api_type => g_api_type);
3182:
3183: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3184: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'OKL_BOOK_CONTROLLER_PVT.init_book_controller_trx.', 'EXP - OTHERS');
3185: END IF;
3186:
3187: END init_book_controller_trx;
3180: x_msg_data => x_msg_data,
3181: p_api_type => g_api_type);
3182:
3183: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3184: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'OKL_BOOK_CONTROLLER_PVT.init_book_controller_trx.', 'EXP - OTHERS');
3185: END IF;
3186:
3187: END init_book_controller_trx;
3188:
3225:
3226: l_book_ctrl_trx c_book_ctrl_trx%ROWTYPE;
3227:
3228: BEGIN
3229: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3230: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_BOOK_CONTROLLER_PVT.update_book_controller_trx.', 'Begin(+)');
3231: END IF;
3232: x_return_status := OKL_API.G_RET_STS_SUCCESS;
3233:
3226: l_book_ctrl_trx c_book_ctrl_trx%ROWTYPE;
3227:
3228: BEGIN
3229: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3230: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_BOOK_CONTROLLER_PVT.update_book_controller_trx.', 'Begin(+)');
3231: END IF;
3232: x_return_status := OKL_API.G_RET_STS_SUCCESS;
3233:
3234: x_return_status := OKL_API.START_ACTIVITY(
3292:
3293: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
3294: x_msg_data => x_msg_data);
3295:
3296: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3297: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_BOOK_CONTROLLER_PVT.update_book_controller_trx.', 'End(-)');
3298: END IF;
3299:
3300: EXCEPTION
3293: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
3294: x_msg_data => x_msg_data);
3295:
3296: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3297: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_BOOK_CONTROLLER_PVT.update_book_controller_trx.', 'End(-)');
3298: END IF;
3299:
3300: EXCEPTION
3301: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3309: x_msg_count => x_msg_count,
3310: x_msg_data => x_msg_data,
3311: p_api_type => g_api_type);
3312:
3313: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3314: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'OKL_BOOK_CONTROLLER_PVT.update_book_controller_trx.', 'EXP - ERROR');
3315: END IF;
3316:
3317: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3310: x_msg_data => x_msg_data,
3311: p_api_type => g_api_type);
3312:
3313: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3314: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'OKL_BOOK_CONTROLLER_PVT.update_book_controller_trx.', 'EXP - ERROR');
3315: END IF;
3316:
3317: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3318: IF (c_book_ctrl_trx%ISOPEN) THEN
3325: x_msg_count => x_msg_count,
3326: x_msg_data => x_msg_data,
3327: p_api_type => g_api_type);
3328:
3329: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3330: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'OKL_BOOK_CONTROLLER_PVT.update_book_controller_trx.', 'EXP - UNEXCP ERROR');
3331: END IF;
3332:
3333: WHEN OTHERS THEN
3326: x_msg_data => x_msg_data,
3327: p_api_type => g_api_type);
3328:
3329: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3330: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'OKL_BOOK_CONTROLLER_PVT.update_book_controller_trx.', 'EXP - UNEXCP ERROR');
3331: END IF;
3332:
3333: WHEN OTHERS THEN
3334: IF (c_book_ctrl_trx%ISOPEN) THEN
3341: x_msg_count => x_msg_count,
3342: x_msg_data => x_msg_data,
3343: p_api_type => g_api_type);
3344:
3345: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3346: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'OKL_BOOK_CONTROLLER_PVT.update_book_controller_trx.', 'EXP - OTHERS');
3347: END IF;
3348: END update_book_controller_trx;
3349:
3342: x_msg_data => x_msg_data,
3343: p_api_type => g_api_type);
3344:
3345: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3346: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'OKL_BOOK_CONTROLLER_PVT.update_book_controller_trx.', 'EXP - OTHERS');
3347: END IF;
3348: END update_book_controller_trx;
3349:
3350: -----------------------------------------------------------------------------
3371: l_api_name CONSTANT VARCHAR2(30) := 'cancel_contract_activation';
3372: l_api_version CONSTANT NUMBER := 1.0;
3373: l_prog_short_name OKL_BOOK_CONTROLLER_TRX.prog_short_name%TYPE;
3374: BEGIN
3375: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3376: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_BOOK_CONTROLLER_PVT.cancel_contract_activation.', 'Begin(+)');
3377: END IF;
3378:
3379: x_return_status := OKL_API.G_RET_STS_SUCCESS;
3372: l_api_version CONSTANT NUMBER := 1.0;
3373: l_prog_short_name OKL_BOOK_CONTROLLER_TRX.prog_short_name%TYPE;
3374: BEGIN
3375: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3376: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_BOOK_CONTROLLER_PVT.cancel_contract_activation.', 'Begin(+)');
3377: END IF;
3378:
3379: x_return_status := OKL_API.G_RET_STS_SUCCESS;
3380:
3456:
3457: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
3458: x_msg_data => x_msg_data);
3459:
3460: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3461: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_BOOK_CONTROLLER_PVT.cancel_contract_activation.', 'End(-)');
3462: END IF;
3463:
3464: EXCEPTION
3457: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
3458: x_msg_data => x_msg_data);
3459:
3460: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3461: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_BOOK_CONTROLLER_PVT.cancel_contract_activation.', 'End(-)');
3462: END IF;
3463:
3464: EXCEPTION
3465: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3470: x_msg_count => x_msg_count,
3471: x_msg_data => x_msg_data,
3472: p_api_type => g_api_type);
3473:
3474: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3475: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'OKL_BOOK_CONTROLLER_PVT.cancel_contract_activation.', 'EXP - ERROR');
3476: END IF;
3477:
3478: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3471: x_msg_data => x_msg_data,
3472: p_api_type => g_api_type);
3473:
3474: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3475: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'OKL_BOOK_CONTROLLER_PVT.cancel_contract_activation.', 'EXP - ERROR');
3476: END IF;
3477:
3478: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3479: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
3483: x_msg_count => x_msg_count,
3484: x_msg_data => x_msg_data,
3485: p_api_type => g_api_type);
3486:
3487: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3488: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'OKL_BOOK_CONTROLLER_PVT.cancel_contract_activation.', 'EXP - UNEXCP ERROR');
3489: END IF;
3490:
3491: WHEN OTHERS THEN
3484: x_msg_data => x_msg_data,
3485: p_api_type => g_api_type);
3486:
3487: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3488: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'OKL_BOOK_CONTROLLER_PVT.cancel_contract_activation.', 'EXP - UNEXCP ERROR');
3489: END IF;
3490:
3491: WHEN OTHERS THEN
3492: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
3496: x_msg_count => x_msg_count,
3497: x_msg_data => x_msg_data,
3498: p_api_type => g_api_type);
3499:
3500: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3501: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'OKL_BOOK_CONTROLLER_PVT.cancel_contract_activation.', 'EXP - OTHERS');
3502: END IF;
3503: END cancel_contract_activation;
3504:
3497: x_msg_data => x_msg_data,
3498: p_api_type => g_api_type);
3499:
3500: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3501: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'OKL_BOOK_CONTROLLER_PVT.cancel_contract_activation.', 'EXP - OTHERS');
3502: END IF;
3503: END cancel_contract_activation;
3504:
3505: -----------------------------------------------------------------------------
3535:
3536: l_progress_status okl_book_controller_trx.progress_status%TYPE;
3537: x_process_status VARCHAR2(30);
3538: BEGIN
3539: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3540: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_BOOK_CONTROLLER_PVT.validate_contract_nxtbtn.', 'Begin(+)');
3541: END IF;
3542:
3543: x_return_status := OKL_API.G_RET_STS_SUCCESS;
3536: l_progress_status okl_book_controller_trx.progress_status%TYPE;
3537: x_process_status VARCHAR2(30);
3538: BEGIN
3539: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3540: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_BOOK_CONTROLLER_PVT.validate_contract_nxtbtn.', 'Begin(+)');
3541: END IF;
3542:
3543: x_return_status := OKL_API.G_RET_STS_SUCCESS;
3544:
3591:
3592: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
3593: x_msg_data => x_msg_data);
3594:
3595: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3596: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_BOOK_CONTROLLER_PVT.validate_contract_nxtbtn.', 'End(-)');
3597: END IF;
3598:
3599: EXCEPTION
3592: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
3593: x_msg_data => x_msg_data);
3594:
3595: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3596: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_BOOK_CONTROLLER_PVT.validate_contract_nxtbtn.', 'End(-)');
3597: END IF;
3598:
3599: EXCEPTION
3600: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3605: x_msg_count => x_msg_count,
3606: x_msg_data => x_msg_data,
3607: p_api_type => g_api_type);
3608:
3609: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3610: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'OKL_BOOK_CONTROLLER_PVT.validate_contract_nxtbtn.', 'EXP - ERROR');
3611: END IF;
3612:
3613: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3606: x_msg_data => x_msg_data,
3607: p_api_type => g_api_type);
3608:
3609: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3610: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'OKL_BOOK_CONTROLLER_PVT.validate_contract_nxtbtn.', 'EXP - ERROR');
3611: END IF;
3612:
3613: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3614: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
3618: x_msg_count => x_msg_count,
3619: x_msg_data => x_msg_data,
3620: p_api_type => g_api_type);
3621:
3622: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3623: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'OKL_BOOK_CONTROLLER_PVT.validate_contract_nxtbtn.', 'EXP - UNEXCP ERROR');
3624: END IF;
3625:
3626: WHEN OTHERS THEN
3619: x_msg_data => x_msg_data,
3620: p_api_type => g_api_type);
3621:
3622: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3623: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'OKL_BOOK_CONTROLLER_PVT.validate_contract_nxtbtn.', 'EXP - UNEXCP ERROR');
3624: END IF;
3625:
3626: WHEN OTHERS THEN
3627: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
3631: x_msg_count => x_msg_count,
3632: x_msg_data => x_msg_data,
3633: p_api_type => g_api_type);
3634:
3635: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3636: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'OKL_BOOK_CONTROLLER_PVT.validate_contract_nxtbtn.', 'EXP - OTHERS');
3637: END IF;
3638: END validate_contract_nxtbtn;
3639:
3632: x_msg_data => x_msg_data,
3633: p_api_type => g_api_type);
3634:
3635: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3636: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'OKL_BOOK_CONTROLLER_PVT.validate_contract_nxtbtn.', 'EXP - OTHERS');
3637: END IF;
3638: END validate_contract_nxtbtn;
3639:
3640: -----------------------------------------------------------------------------
3670:
3671: l_progress_status okl_book_controller_trx.progress_status%TYPE;
3672: x_process_status VARCHAR2(30);
3673: BEGIN
3674: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3675: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_BOOK_CONTROLLER_PVT.calc_upfronttax_nxtbtn.', 'Begin(+)');
3676: END IF;
3677:
3678: x_return_status := OKL_API.G_RET_STS_SUCCESS;
3671: l_progress_status okl_book_controller_trx.progress_status%TYPE;
3672: x_process_status VARCHAR2(30);
3673: BEGIN
3674: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3675: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_BOOK_CONTROLLER_PVT.calc_upfronttax_nxtbtn.', 'Begin(+)');
3676: END IF;
3677:
3678: x_return_status := OKL_API.G_RET_STS_SUCCESS;
3679:
3714:
3715: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
3716: x_msg_data => x_msg_data);
3717:
3718: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3719: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_BOOK_CONTROLLER_PVT.calc_upfronttax_nxtbtn.', 'End(-)');
3720: END IF;
3721:
3722: EXCEPTION
3715: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
3716: x_msg_data => x_msg_data);
3717:
3718: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3719: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_BOOK_CONTROLLER_PVT.calc_upfronttax_nxtbtn.', 'End(-)');
3720: END IF;
3721:
3722: EXCEPTION
3723: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3728: x_msg_count => x_msg_count,
3729: x_msg_data => x_msg_data,
3730: p_api_type => g_api_type);
3731:
3732: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3733: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'OKL_BOOK_CONTROLLER_PVT.validate_contract_nxtbtn.', 'EXP - ERROR');
3734: END IF;
3735:
3736: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3729: x_msg_data => x_msg_data,
3730: p_api_type => g_api_type);
3731:
3732: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3733: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'OKL_BOOK_CONTROLLER_PVT.validate_contract_nxtbtn.', 'EXP - ERROR');
3734: END IF;
3735:
3736: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3737: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
3741: x_msg_count => x_msg_count,
3742: x_msg_data => x_msg_data,
3743: p_api_type => g_api_type);
3744:
3745: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3746: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'OKL_BOOK_CONTROLLER_PVT.validate_contract_nxtbtn.', 'EXP - UNEXCP ERROR');
3747: END IF;
3748:
3749: WHEN OTHERS THEN
3742: x_msg_data => x_msg_data,
3743: p_api_type => g_api_type);
3744:
3745: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3746: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'OKL_BOOK_CONTROLLER_PVT.validate_contract_nxtbtn.', 'EXP - UNEXCP ERROR');
3747: END IF;
3748:
3749: WHEN OTHERS THEN
3750: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
3754: x_msg_count => x_msg_count,
3755: x_msg_data => x_msg_data,
3756: p_api_type => g_api_type);
3757:
3758: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3759: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'OKL_BOOK_CONTROLLER_PVT.validate_contract_nxtbtn.', 'EXP - OTHERS');
3760: END IF;
3761: END calc_upfronttax_nxtbtn;
3762:
3755: x_msg_data => x_msg_data,
3756: p_api_type => g_api_type);
3757:
3758: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3759: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'OKL_BOOK_CONTROLLER_PVT.validate_contract_nxtbtn.', 'EXP - OTHERS');
3760: END IF;
3761: END calc_upfronttax_nxtbtn;
3762:
3763: -----------------------------------------------------------------------------