eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_BOOK_CONTROLLER_PVT dependencies on OKL_BOOK_CONTROLLER_PVT

Line 1: PACKAGE BODY OKL_BOOK_CONTROLLER_PVT AS

1: PACKAGE BODY OKL_BOOK_CONTROLLER_PVT AS
2: /* $Header: OKLRBCTB.pls 120.8.12010000.4 2009/11/27 06:06:17 rpillay ship $ */
3: --------------------------------------------------------------------------------
4: --LOCAL DATASTRUCTURES
5: --------------------------------------------------------------------------------

Line 249: OKL_BOOK_CONTROLLER_PVT.init_book_controller_trx(

245: END IF;
246:
247: -- Initialize records in okl_book_controller_trx table
248:
249: OKL_BOOK_CONTROLLER_PVT.init_book_controller_trx(
250: p_api_version => p_api_version,
251: p_init_msg_list => p_init_msg_list,
252: x_return_status => x_return_status,
253: x_msg_count => x_msg_count,

Line 889: p_progress_status => OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_ERROR);

885: x_msg_data => l_msg_data,
886: p_khr_id => p_khr_id,
887: p_prog_short_name => l_program_name,
888: p_conc_req_id => NULL,
889: p_progress_status => OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_ERROR);
890:
891: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
892: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
893: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

Line 927: p_progress_status => OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_RUNNING);

923: x_msg_data => l_msg_data,
924: p_khr_id => p_khr_id,
925: p_prog_short_name => l_program_name,
926: p_conc_req_id => l_request_id,
927: p_progress_status => OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_RUNNING);
928:
929: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
930: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
931: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

Line 972: p_progress_status => OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_ERROR);

968: x_msg_count => l_msg_count,
969: x_msg_data => l_msg_data,
970: p_khr_id => p_khr_id,
971: p_prog_short_name => l_program_name,
972: p_progress_status => OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_ERROR);
973:
974: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
975: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
976: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

Line 1008: p_progress_status => OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_COMPLETE);

1004: x_msg_count => l_msg_count,
1005: x_msg_data => l_msg_data,
1006: p_khr_id => p_khr_id,
1007: p_prog_short_name => l_program_name,
1008: p_progress_status => OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_COMPLETE);
1009:
1010: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1011: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1012: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

Line 3010: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_BOOK_CONTROLLER_PVT.init_book_controller_trx.', 'Begin(+)');

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;

Line 3050: l_qa_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_COMPLETE;

3046: FETCH get_curr_sts_code INTO l_curr_sts_code;
3047: CLOSE get_curr_sts_code;
3048:
3049: IF (l_curr_sts_code = 'PASSED') THEN
3050: l_qa_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_COMPLETE;
3051: l_ut_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_COMPLETE;
3052: l_st_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_PENDING;
3053: l_bk_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_PENDING;
3054: ELSIF (l_curr_sts_code IN ('COMPLETE','APPROVED')) THEN

Line 3051: l_ut_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_COMPLETE;

3047: CLOSE get_curr_sts_code;
3048:
3049: IF (l_curr_sts_code = 'PASSED') THEN
3050: l_qa_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_COMPLETE;
3051: l_ut_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_COMPLETE;
3052: l_st_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_PENDING;
3053: l_bk_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_PENDING;
3054: ELSIF (l_curr_sts_code IN ('COMPLETE','APPROVED')) THEN
3055: l_qa_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_COMPLETE;

Line 3052: l_st_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_PENDING;

3048:
3049: IF (l_curr_sts_code = 'PASSED') THEN
3050: l_qa_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_COMPLETE;
3051: l_ut_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_COMPLETE;
3052: l_st_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_PENDING;
3053: l_bk_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_PENDING;
3054: ELSIF (l_curr_sts_code IN ('COMPLETE','APPROVED')) THEN
3055: l_qa_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_COMPLETE;
3056: l_ut_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_COMPLETE;

Line 3053: l_bk_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_PENDING;

3049: IF (l_curr_sts_code = 'PASSED') THEN
3050: l_qa_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_COMPLETE;
3051: l_ut_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_COMPLETE;
3052: l_st_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_PENDING;
3053: l_bk_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_PENDING;
3054: ELSIF (l_curr_sts_code IN ('COMPLETE','APPROVED')) THEN
3055: l_qa_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_COMPLETE;
3056: l_ut_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_COMPLETE;
3057: l_st_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_COMPLETE;

Line 3055: l_qa_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_COMPLETE;

3051: l_ut_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_COMPLETE;
3052: l_st_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_PENDING;
3053: l_bk_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_PENDING;
3054: ELSIF (l_curr_sts_code IN ('COMPLETE','APPROVED')) THEN
3055: l_qa_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_COMPLETE;
3056: l_ut_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_COMPLETE;
3057: l_st_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_COMPLETE;
3058: l_bk_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_PENDING;
3059: ELSIF (l_curr_sts_code = 'PENDING_APPROVAL') THEN

Line 3056: l_ut_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_COMPLETE;

3052: l_st_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_PENDING;
3053: l_bk_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_PENDING;
3054: ELSIF (l_curr_sts_code IN ('COMPLETE','APPROVED')) THEN
3055: l_qa_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_COMPLETE;
3056: l_ut_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_COMPLETE;
3057: l_st_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_COMPLETE;
3058: l_bk_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_PENDING;
3059: ELSIF (l_curr_sts_code = 'PENDING_APPROVAL') THEN
3060: l_qa_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_COMPLETE;

Line 3057: l_st_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_COMPLETE;

3053: l_bk_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_PENDING;
3054: ELSIF (l_curr_sts_code IN ('COMPLETE','APPROVED')) THEN
3055: l_qa_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_COMPLETE;
3056: l_ut_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_COMPLETE;
3057: l_st_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_COMPLETE;
3058: l_bk_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_PENDING;
3059: ELSIF (l_curr_sts_code = 'PENDING_APPROVAL') THEN
3060: l_qa_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_COMPLETE;
3061: l_ut_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_COMPLETE;

Line 3058: l_bk_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_PENDING;

3054: ELSIF (l_curr_sts_code IN ('COMPLETE','APPROVED')) THEN
3055: l_qa_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_COMPLETE;
3056: l_ut_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_COMPLETE;
3057: l_st_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_COMPLETE;
3058: l_bk_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_PENDING;
3059: ELSIF (l_curr_sts_code = 'PENDING_APPROVAL') THEN
3060: l_qa_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_COMPLETE;
3061: l_ut_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_COMPLETE;
3062: l_st_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_COMPLETE;

Line 3060: l_qa_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_COMPLETE;

3056: l_ut_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_COMPLETE;
3057: l_st_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_COMPLETE;
3058: l_bk_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_PENDING;
3059: ELSIF (l_curr_sts_code = 'PENDING_APPROVAL') THEN
3060: l_qa_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_COMPLETE;
3061: l_ut_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_COMPLETE;
3062: l_st_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_COMPLETE;
3063: l_bk_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_RUNNING;
3064: --Bug# 9119881

Line 3061: l_ut_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_COMPLETE;

3057: l_st_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_COMPLETE;
3058: l_bk_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_PENDING;
3059: ELSIF (l_curr_sts_code = 'PENDING_APPROVAL') THEN
3060: l_qa_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_COMPLETE;
3061: l_ut_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_COMPLETE;
3062: l_st_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_COMPLETE;
3063: l_bk_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_RUNNING;
3064: --Bug# 9119881
3065: ELSIF (l_curr_sts_code IN ('NEW','INCOMPLETE')) THEN

Line 3062: l_st_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_COMPLETE;

3058: l_bk_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_PENDING;
3059: ELSIF (l_curr_sts_code = 'PENDING_APPROVAL') THEN
3060: l_qa_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_COMPLETE;
3061: l_ut_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_COMPLETE;
3062: l_st_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_COMPLETE;
3063: l_bk_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_RUNNING;
3064: --Bug# 9119881
3065: ELSIF (l_curr_sts_code IN ('NEW','INCOMPLETE')) THEN
3066: l_qa_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_PENDING;

Line 3063: l_bk_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_RUNNING;

3059: ELSIF (l_curr_sts_code = 'PENDING_APPROVAL') THEN
3060: l_qa_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_COMPLETE;
3061: l_ut_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_COMPLETE;
3062: l_st_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_COMPLETE;
3063: l_bk_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_RUNNING;
3064: --Bug# 9119881
3065: ELSIF (l_curr_sts_code IN ('NEW','INCOMPLETE')) THEN
3066: l_qa_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_PENDING;
3067: l_ut_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_PENDING;

Line 3066: l_qa_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_PENDING;

3062: l_st_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_COMPLETE;
3063: l_bk_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_RUNNING;
3064: --Bug# 9119881
3065: ELSIF (l_curr_sts_code IN ('NEW','INCOMPLETE')) THEN
3066: l_qa_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_PENDING;
3067: l_ut_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_PENDING;
3068: l_st_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_PENDING;
3069: l_bk_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_PENDING;
3070: ELSE

Line 3067: l_ut_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_PENDING;

3063: l_bk_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_RUNNING;
3064: --Bug# 9119881
3065: ELSIF (l_curr_sts_code IN ('NEW','INCOMPLETE')) THEN
3066: l_qa_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_PENDING;
3067: l_ut_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_PENDING;
3068: l_st_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_PENDING;
3069: l_bk_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_PENDING;
3070: ELSE
3071: l_qa_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_COMPLETE;

Line 3068: l_st_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_PENDING;

3064: --Bug# 9119881
3065: ELSIF (l_curr_sts_code IN ('NEW','INCOMPLETE')) THEN
3066: l_qa_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_PENDING;
3067: l_ut_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_PENDING;
3068: l_st_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_PENDING;
3069: l_bk_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_PENDING;
3070: ELSE
3071: l_qa_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_COMPLETE;
3072: l_ut_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_COMPLETE;

Line 3069: l_bk_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_PENDING;

3065: ELSIF (l_curr_sts_code IN ('NEW','INCOMPLETE')) THEN
3066: l_qa_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_PENDING;
3067: l_ut_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_PENDING;
3068: l_st_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_PENDING;
3069: l_bk_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_PENDING;
3070: ELSE
3071: l_qa_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_COMPLETE;
3072: l_ut_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_COMPLETE;
3073: l_st_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_COMPLETE;

Line 3071: l_qa_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_COMPLETE;

3067: l_ut_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_PENDING;
3068: l_st_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_PENDING;
3069: l_bk_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_PENDING;
3070: ELSE
3071: l_qa_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_COMPLETE;
3072: l_ut_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_COMPLETE;
3073: l_st_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_COMPLETE;
3074: l_bk_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_COMPLETE;
3075: END IF;

Line 3072: l_ut_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_COMPLETE;

3068: l_st_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_PENDING;
3069: l_bk_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_PENDING;
3070: ELSE
3071: l_qa_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_COMPLETE;
3072: l_ut_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_COMPLETE;
3073: l_st_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_COMPLETE;
3074: l_bk_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_COMPLETE;
3075: END IF;
3076: --Bug# 9119881

Line 3073: l_st_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_COMPLETE;

3069: l_bk_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_PENDING;
3070: ELSE
3071: l_qa_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_COMPLETE;
3072: l_ut_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_COMPLETE;
3073: l_st_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_COMPLETE;
3074: l_bk_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_COMPLETE;
3075: END IF;
3076: --Bug# 9119881
3077:

Line 3074: l_bk_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_COMPLETE;

3070: ELSE
3071: l_qa_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_COMPLETE;
3072: l_ut_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_COMPLETE;
3073: l_st_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_COMPLETE;
3074: l_bk_progress_status := OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_COMPLETE;
3075: END IF;
3076: --Bug# 9119881
3077:
3078: i := 0;

Line 3151: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_BOOK_CONTROLLER_PVT.init_book_controller_trx.', 'End(-)');

3147: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
3148: x_msg_data => x_msg_data);
3149:
3150: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3151: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_BOOK_CONTROLLER_PVT.init_book_controller_trx.', 'End(-)');
3152: END IF;
3153:
3154: EXCEPTION
3155: WHEN OKL_API.G_EXCEPTION_ERROR THEN

Line 3165: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'OKL_BOOK_CONTROLLER_PVT.init_book_controller_trx.', 'EXP - ERROR');

3161: x_msg_data => x_msg_data,
3162: p_api_type => g_api_type);
3163:
3164: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3165: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'OKL_BOOK_CONTROLLER_PVT.init_book_controller_trx.', 'EXP - ERROR');
3166: END IF;
3167:
3168: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3169: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 3178: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'OKL_BOOK_CONTROLLER_PVT.init_book_controller_trx.', 'EXP - UNEXCP ERROR');

3174: x_msg_data => x_msg_data,
3175: p_api_type => g_api_type);
3176:
3177: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3178: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'OKL_BOOK_CONTROLLER_PVT.init_book_controller_trx.', 'EXP - UNEXCP ERROR');
3179: END IF;
3180:
3181: WHEN OTHERS THEN
3182: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 3191: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'OKL_BOOK_CONTROLLER_PVT.init_book_controller_trx.', 'EXP - OTHERS');

3187: x_msg_data => x_msg_data,
3188: p_api_type => g_api_type);
3189:
3190: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3191: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'OKL_BOOK_CONTROLLER_PVT.init_book_controller_trx.', 'EXP - OTHERS');
3192: END IF;
3193:
3194: END init_book_controller_trx;
3195:

Line 3237: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_BOOK_CONTROLLER_PVT.update_book_controller_trx.', 'Begin(+)');

3233: l_book_ctrl_trx c_book_ctrl_trx%ROWTYPE;
3234:
3235: BEGIN
3236: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3237: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_BOOK_CONTROLLER_PVT.update_book_controller_trx.', 'Begin(+)');
3238: END IF;
3239: x_return_status := OKL_API.G_RET_STS_SUCCESS;
3240:
3241: x_return_status := OKL_API.START_ACTIVITY(

Line 3304: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_BOOK_CONTROLLER_PVT.update_book_controller_trx.', 'End(-)');

3300: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
3301: x_msg_data => x_msg_data);
3302:
3303: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3304: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_BOOK_CONTROLLER_PVT.update_book_controller_trx.', 'End(-)');
3305: END IF;
3306:
3307: EXCEPTION
3308: WHEN OKL_API.G_EXCEPTION_ERROR THEN

Line 3321: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'OKL_BOOK_CONTROLLER_PVT.update_book_controller_trx.', 'EXP - ERROR');

3317: x_msg_data => x_msg_data,
3318: p_api_type => g_api_type);
3319:
3320: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3321: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'OKL_BOOK_CONTROLLER_PVT.update_book_controller_trx.', 'EXP - ERROR');
3322: END IF;
3323:
3324: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3325: IF (c_book_ctrl_trx%ISOPEN) THEN

Line 3337: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'OKL_BOOK_CONTROLLER_PVT.update_book_controller_trx.', 'EXP - UNEXCP ERROR');

3333: x_msg_data => x_msg_data,
3334: p_api_type => g_api_type);
3335:
3336: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3337: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'OKL_BOOK_CONTROLLER_PVT.update_book_controller_trx.', 'EXP - UNEXCP ERROR');
3338: END IF;
3339:
3340: WHEN OTHERS THEN
3341: IF (c_book_ctrl_trx%ISOPEN) THEN

Line 3353: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'OKL_BOOK_CONTROLLER_PVT.update_book_controller_trx.', 'EXP - OTHERS');

3349: x_msg_data => x_msg_data,
3350: p_api_type => g_api_type);
3351:
3352: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3353: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'OKL_BOOK_CONTROLLER_PVT.update_book_controller_trx.', 'EXP - OTHERS');
3354: END IF;
3355: END update_book_controller_trx;
3356:
3357: -----------------------------------------------------------------------------

Line 3383: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_BOOK_CONTROLLER_PVT.cancel_contract_activation.', 'Begin(+)');

3379: l_api_version CONSTANT NUMBER := 1.0;
3380: l_prog_short_name OKL_BOOK_CONTROLLER_TRX.prog_short_name%TYPE;
3381: BEGIN
3382: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3383: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_BOOK_CONTROLLER_PVT.cancel_contract_activation.', 'Begin(+)');
3384: END IF;
3385:
3386: x_return_status := OKL_API.G_RET_STS_SUCCESS;
3387:

Line 3435: l_prog_short_name := OKL_BOOK_CONTROLLER_PVT.G_VALIDATE_CONTRACT;

3431:
3432: FOR i in 1..4
3433: LOOP
3434: IF (i = 1) THEN
3435: l_prog_short_name := OKL_BOOK_CONTROLLER_PVT.G_VALIDATE_CONTRACT;
3436: ELSIF (i = 2) THEN
3437: l_prog_short_name := OKL_BOOK_CONTROLLER_PVT.G_CALC_UPFRONT_TAX;
3438: ELSIF (i = 3) THEN
3439: l_prog_short_name := OKL_BOOK_CONTROLLER_PVT.G_PRICE_CONTRACT;

Line 3437: l_prog_short_name := OKL_BOOK_CONTROLLER_PVT.G_CALC_UPFRONT_TAX;

3433: LOOP
3434: IF (i = 1) THEN
3435: l_prog_short_name := OKL_BOOK_CONTROLLER_PVT.G_VALIDATE_CONTRACT;
3436: ELSIF (i = 2) THEN
3437: l_prog_short_name := OKL_BOOK_CONTROLLER_PVT.G_CALC_UPFRONT_TAX;
3438: ELSIF (i = 3) THEN
3439: l_prog_short_name := OKL_BOOK_CONTROLLER_PVT.G_PRICE_CONTRACT;
3440: ELSIF (i = 4) THEN
3441: l_prog_short_name := OKL_BOOK_CONTROLLER_PVT.G_SUBMIT_CONTRACT;

Line 3439: l_prog_short_name := OKL_BOOK_CONTROLLER_PVT.G_PRICE_CONTRACT;

3435: l_prog_short_name := OKL_BOOK_CONTROLLER_PVT.G_VALIDATE_CONTRACT;
3436: ELSIF (i = 2) THEN
3437: l_prog_short_name := OKL_BOOK_CONTROLLER_PVT.G_CALC_UPFRONT_TAX;
3438: ELSIF (i = 3) THEN
3439: l_prog_short_name := OKL_BOOK_CONTROLLER_PVT.G_PRICE_CONTRACT;
3440: ELSIF (i = 4) THEN
3441: l_prog_short_name := OKL_BOOK_CONTROLLER_PVT.G_SUBMIT_CONTRACT;
3442: END IF;
3443:

Line 3441: l_prog_short_name := OKL_BOOK_CONTROLLER_PVT.G_SUBMIT_CONTRACT;

3437: l_prog_short_name := OKL_BOOK_CONTROLLER_PVT.G_CALC_UPFRONT_TAX;
3438: ELSIF (i = 3) THEN
3439: l_prog_short_name := OKL_BOOK_CONTROLLER_PVT.G_PRICE_CONTRACT;
3440: ELSIF (i = 4) THEN
3441: l_prog_short_name := OKL_BOOK_CONTROLLER_PVT.G_SUBMIT_CONTRACT;
3442: END IF;
3443:
3444: okl_book_controller_pvt.update_book_controller_trx(
3445: p_api_version => p_api_version,

Line 3444: okl_book_controller_pvt.update_book_controller_trx(

3440: ELSIF (i = 4) THEN
3441: l_prog_short_name := OKL_BOOK_CONTROLLER_PVT.G_SUBMIT_CONTRACT;
3442: END IF;
3443:
3444: okl_book_controller_pvt.update_book_controller_trx(
3445: p_api_version => p_api_version,
3446: p_init_msg_list => p_init_msg_list,
3447: x_return_status => x_return_status,
3448: x_msg_count => x_msg_count,

Line 3453: p_progress_status => OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_PENDING);

3449: x_msg_data => x_msg_data,
3450: p_khr_id => p_khr_id,
3451: p_prog_short_name => l_prog_short_name,
3452: p_conc_req_id => NULL,
3453: p_progress_status => OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_PENDING);
3454:
3455: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3456: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3457: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

Line 3468: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_BOOK_CONTROLLER_PVT.cancel_contract_activation.', 'End(-)');

3464: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
3465: x_msg_data => x_msg_data);
3466:
3467: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3468: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_BOOK_CONTROLLER_PVT.cancel_contract_activation.', 'End(-)');
3469: END IF;
3470:
3471: EXCEPTION
3472: WHEN OKL_API.G_EXCEPTION_ERROR THEN

Line 3482: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'OKL_BOOK_CONTROLLER_PVT.cancel_contract_activation.', 'EXP - ERROR');

3478: x_msg_data => x_msg_data,
3479: p_api_type => g_api_type);
3480:
3481: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3482: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'OKL_BOOK_CONTROLLER_PVT.cancel_contract_activation.', 'EXP - ERROR');
3483: END IF;
3484:
3485: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3486: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 3495: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'OKL_BOOK_CONTROLLER_PVT.cancel_contract_activation.', 'EXP - UNEXCP ERROR');

3491: x_msg_data => x_msg_data,
3492: p_api_type => g_api_type);
3493:
3494: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3495: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'OKL_BOOK_CONTROLLER_PVT.cancel_contract_activation.', 'EXP - UNEXCP ERROR');
3496: END IF;
3497:
3498: WHEN OTHERS THEN
3499: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 3508: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'OKL_BOOK_CONTROLLER_PVT.cancel_contract_activation.', 'EXP - OTHERS');

3504: x_msg_data => x_msg_data,
3505: p_api_type => g_api_type);
3506:
3507: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3508: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'OKL_BOOK_CONTROLLER_PVT.cancel_contract_activation.', 'EXP - OTHERS');
3509: END IF;
3510: END cancel_contract_activation;
3511:
3512: -----------------------------------------------------------------------------

Line 3547: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_BOOK_CONTROLLER_PVT.validate_contract_nxtbtn.', 'Begin(+)');

3543: l_progress_status okl_book_controller_trx.progress_status%TYPE;
3544: x_process_status VARCHAR2(30);
3545: BEGIN
3546: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3547: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_BOOK_CONTROLLER_PVT.validate_contract_nxtbtn.', 'Begin(+)');
3548: END IF;
3549:
3550: x_return_status := OKL_API.G_RET_STS_SUCCESS;
3551:

Line 3568: OPEN c_book_ctrl_trx(p_khr_id,okl_book_controller_pvt.g_validate_contract);

3564: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3565: RAISE OKL_API.G_EXCEPTION_ERROR;
3566: END IF;
3567:
3568: OPEN c_book_ctrl_trx(p_khr_id,okl_book_controller_pvt.g_validate_contract);
3569: FETCH c_book_ctrl_trx INTO l_progress_status;
3570: CLOSE c_book_ctrl_trx;
3571:
3572: IF (l_progress_status = okl_book_controller_pvt.g_prog_sts_complete) THEN

Line 3572: IF (l_progress_status = okl_book_controller_pvt.g_prog_sts_complete) THEN

3568: OPEN c_book_ctrl_trx(p_khr_id,okl_book_controller_pvt.g_validate_contract);
3569: FETCH c_book_ctrl_trx INTO l_progress_status;
3570: CLOSE c_book_ctrl_trx;
3571:
3572: IF (l_progress_status = okl_book_controller_pvt.g_prog_sts_complete) THEN
3573: OPEN c_book_ctrl_trx(p_khr_id,okl_book_controller_pvt.g_calc_upfront_tax);
3574: FETCH c_book_ctrl_trx INTO l_progress_status;
3575: CLOSE c_book_ctrl_trx;
3576: IF (l_progress_status = okl_book_controller_pvt.g_prog_sts_pending) THEN

Line 3573: OPEN c_book_ctrl_trx(p_khr_id,okl_book_controller_pvt.g_calc_upfront_tax);

3569: FETCH c_book_ctrl_trx INTO l_progress_status;
3570: CLOSE c_book_ctrl_trx;
3571:
3572: IF (l_progress_status = okl_book_controller_pvt.g_prog_sts_complete) THEN
3573: OPEN c_book_ctrl_trx(p_khr_id,okl_book_controller_pvt.g_calc_upfront_tax);
3574: FETCH c_book_ctrl_trx INTO l_progress_status;
3575: CLOSE c_book_ctrl_trx;
3576: IF (l_progress_status = okl_book_controller_pvt.g_prog_sts_pending) THEN
3577: OKL_CONTRACT_BOOK_PVT.calculate_upfront_tax(

Line 3576: IF (l_progress_status = okl_book_controller_pvt.g_prog_sts_pending) THEN

3572: IF (l_progress_status = okl_book_controller_pvt.g_prog_sts_complete) THEN
3573: OPEN c_book_ctrl_trx(p_khr_id,okl_book_controller_pvt.g_calc_upfront_tax);
3574: FETCH c_book_ctrl_trx INTO l_progress_status;
3575: CLOSE c_book_ctrl_trx;
3576: IF (l_progress_status = okl_book_controller_pvt.g_prog_sts_pending) THEN
3577: OKL_CONTRACT_BOOK_PVT.calculate_upfront_tax(
3578: p_api_version => p_api_version,
3579: p_init_msg_list => p_init_msg_list,
3580: x_return_status => x_return_status,

Line 3603: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_BOOK_CONTROLLER_PVT.validate_contract_nxtbtn.', 'End(-)');

3599: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
3600: x_msg_data => x_msg_data);
3601:
3602: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3603: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_BOOK_CONTROLLER_PVT.validate_contract_nxtbtn.', 'End(-)');
3604: END IF;
3605:
3606: EXCEPTION
3607: WHEN OKL_API.G_EXCEPTION_ERROR THEN

Line 3617: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'OKL_BOOK_CONTROLLER_PVT.validate_contract_nxtbtn.', 'EXP - ERROR');

3613: x_msg_data => x_msg_data,
3614: p_api_type => g_api_type);
3615:
3616: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3617: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'OKL_BOOK_CONTROLLER_PVT.validate_contract_nxtbtn.', 'EXP - ERROR');
3618: END IF;
3619:
3620: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3621: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 3630: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'OKL_BOOK_CONTROLLER_PVT.validate_contract_nxtbtn.', 'EXP - UNEXCP ERROR');

3626: x_msg_data => x_msg_data,
3627: p_api_type => g_api_type);
3628:
3629: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3630: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'OKL_BOOK_CONTROLLER_PVT.validate_contract_nxtbtn.', 'EXP - UNEXCP ERROR');
3631: END IF;
3632:
3633: WHEN OTHERS THEN
3634: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 3643: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'OKL_BOOK_CONTROLLER_PVT.validate_contract_nxtbtn.', 'EXP - OTHERS');

3639: x_msg_data => x_msg_data,
3640: p_api_type => g_api_type);
3641:
3642: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3643: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'OKL_BOOK_CONTROLLER_PVT.validate_contract_nxtbtn.', 'EXP - OTHERS');
3644: END IF;
3645: END validate_contract_nxtbtn;
3646:
3647: -----------------------------------------------------------------------------

Line 3682: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_BOOK_CONTROLLER_PVT.calc_upfronttax_nxtbtn.', 'Begin(+)');

3678: l_progress_status okl_book_controller_trx.progress_status%TYPE;
3679: x_process_status VARCHAR2(30);
3680: BEGIN
3681: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3682: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_BOOK_CONTROLLER_PVT.calc_upfronttax_nxtbtn.', 'Begin(+)');
3683: END IF;
3684:
3685: x_return_status := OKL_API.G_RET_STS_SUCCESS;
3686:

Line 3703: OPEN c_book_ctrl_trx(p_khr_id,okl_book_controller_pvt.g_calc_upfront_tax);

3699: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3700: RAISE OKL_API.G_EXCEPTION_ERROR;
3701: END IF;
3702:
3703: OPEN c_book_ctrl_trx(p_khr_id,okl_book_controller_pvt.g_calc_upfront_tax);
3704: FETCH c_book_ctrl_trx INTO l_progress_status;
3705: CLOSE c_book_ctrl_trx;
3706:
3707: IF (l_progress_status <> okl_book_controller_pvt.g_prog_sts_complete) THEN

Line 3707: IF (l_progress_status <> okl_book_controller_pvt.g_prog_sts_complete) THEN

3703: OPEN c_book_ctrl_trx(p_khr_id,okl_book_controller_pvt.g_calc_upfront_tax);
3704: FETCH c_book_ctrl_trx INTO l_progress_status;
3705: CLOSE c_book_ctrl_trx;
3706:
3707: IF (l_progress_status <> okl_book_controller_pvt.g_prog_sts_complete) THEN
3708: OKL_LA_SALES_TAX_PVT.validate_upfront_tax_fee(
3709: p_api_version => p_api_version,
3710: p_init_msg_list => p_init_msg_list,
3711: x_return_status => x_return_status,

Line 3726: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_BOOK_CONTROLLER_PVT.calc_upfronttax_nxtbtn.', 'End(-)');

3722: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
3723: x_msg_data => x_msg_data);
3724:
3725: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3726: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_BOOK_CONTROLLER_PVT.calc_upfronttax_nxtbtn.', 'End(-)');
3727: END IF;
3728:
3729: EXCEPTION
3730: WHEN OKL_API.G_EXCEPTION_ERROR THEN

Line 3740: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'OKL_BOOK_CONTROLLER_PVT.validate_contract_nxtbtn.', 'EXP - ERROR');

3736: x_msg_data => x_msg_data,
3737: p_api_type => g_api_type);
3738:
3739: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3740: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'OKL_BOOK_CONTROLLER_PVT.validate_contract_nxtbtn.', 'EXP - ERROR');
3741: END IF;
3742:
3743: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3744: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 3753: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'OKL_BOOK_CONTROLLER_PVT.validate_contract_nxtbtn.', 'EXP - UNEXCP ERROR');

3749: x_msg_data => x_msg_data,
3750: p_api_type => g_api_type);
3751:
3752: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3753: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'OKL_BOOK_CONTROLLER_PVT.validate_contract_nxtbtn.', 'EXP - UNEXCP ERROR');
3754: END IF;
3755:
3756: WHEN OTHERS THEN
3757: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 3766: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'OKL_BOOK_CONTROLLER_PVT.validate_contract_nxtbtn.', 'EXP - OTHERS');

3762: x_msg_data => x_msg_data,
3763: p_api_type => g_api_type);
3764:
3765: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3766: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'OKL_BOOK_CONTROLLER_PVT.validate_contract_nxtbtn.', 'EXP - OTHERS');
3767: END IF;
3768: END calc_upfronttax_nxtbtn;
3769:
3770: -----------------------------------------------------------------------------

Line 4256: END OKL_BOOK_CONTROLLER_PVT;

4252: END submit_prb_upgrade;
4253:
4254: --Bug# 8798934
4255:
4256: END OKL_BOOK_CONTROLLER_PVT;