172: -- Declare Process Variable
173: -----------------------------------------------------------------
174: l_api_version CONSTANT NUMBER := 1;
175: l_api_name CONSTANT VARCHAR2(30) := 'populate_code_combinations';
176: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
177: -- Debug related parameters
178: l_module CONSTANT fnd_log_messages.module%TYPE := G_MODULE || l_api_name;
179: l_debug_enabled VARCHAR2(10);
180: is_debug_procedure_on BOOLEAN;
190: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
191: 'begin debug OKLRRPTB.pls call ' || l_api_name);
192: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
193: 'BEGIN API OKL_REPORT_GENERATOR_PVT.' || l_api_name );
194: l_return_status := okl_api.g_ret_sts_success;
195: -- The Report Definition stores the Range of Natural Account Segments.
196: -- Using those prepare a list of Code Combinations and populate it into the
197: -- OKL Account Code Combinations GT Table
198: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
252: IF c_get_segment_num%ISOPEN
253: THEN
254: CLOSE c_get_segment_num;
255: END IF;
256: x_return_status := okl_api.g_ret_sts_unexp_error;
257: okl_api.set_message(p_app_name => g_app_name,
258: p_msg_name => g_unexpected_error,
259: p_token1 => g_sqlcode_token,
260: p_token1_value => SQLCODE,
253: THEN
254: CLOSE c_get_segment_num;
255: END IF;
256: x_return_status := okl_api.g_ret_sts_unexp_error;
257: okl_api.set_message(p_app_name => g_app_name,
258: p_msg_name => g_unexpected_error,
259: p_token1 => g_sqlcode_token,
260: p_token1_value => SQLCODE,
261: p_token2 => g_sqlerrm_token,
338: l_report_pdts_tbl rep_pdts_tbl_type;
339:
340: l_api_version CONSTANT NUMBER := 1;
341: l_api_name CONSTANT VARCHAR2(30) := 'populate_products';
342: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
343: -- Debug related parameters
344: l_module CONSTANT fnd_log_messages.module%TYPE := G_MODULE || l_api_name;
345: l_debug_enabled VARCHAR2(10);
346: is_debug_procedure_on BOOLEAN;
358: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
359: 'begin debug OKLRRPTB.pls call ' || l_api_name);
360: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
361: 'BEGIN API OKL_REPORT_GENERATOR_PVT.' || l_api_name );
362: l_return_status := okl_api.g_ret_sts_success;
363:
364: -- Logic:
365: -- Check whether atleast one product or Book Classification is mentioned on the
366: -- Report Definition or not
419: -- Set the Return Status and return back
420: x_return_status := l_return_status;
421: EXCEPTION
422: WHEN OTHERS THEN
423: x_return_status := okl_api.g_ret_sts_unexp_error;
424: okl_api.set_message(p_app_name => g_app_name,
425: p_msg_name => g_unexpected_error,
426: p_token1 => g_sqlcode_token,
427: p_token1_value => SQLCODE,
420: x_return_status := l_return_status;
421: EXCEPTION
422: WHEN OTHERS THEN
423: x_return_status := okl_api.g_ret_sts_unexp_error;
424: okl_api.set_message(p_app_name => g_app_name,
425: p_msg_name => g_unexpected_error,
426: p_token1 => g_sqlcode_token,
427: p_token1_value => SQLCODE,
428: p_token2 => g_sqlerrm_token,
460: -- Declare Process Variable
461: -----------------------------------------------------------------
462: l_api_version CONSTANT NUMBER := 1;
463: l_api_name CONSTANT VARCHAR2(30) := 'populate_trx_data';
464: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
465: -- Debug related parameters
466: l_module CONSTANT fnd_log_messages.module%TYPE := G_MODULE || l_api_name;
467: l_debug_enabled VARCHAR2(10);
468: is_debug_procedure_on BOOLEAN;
479: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
480: 'begin debug OKLRRPTB.pls call ' || l_api_name);
481: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
482: 'Begin: ' || l_api_name ||'(+)' );
483: l_return_status := okl_api.g_ret_sts_success;
484: -- By now we have the List of Eligible Products and Code Combinations Available
485: -- in the corresponding _GT tables
486: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
487: 'Input Parameters ' ||
3102: -- Set the Return Status and return back
3103: x_return_status := l_return_status;
3104: EXCEPTION
3105: WHEN OTHERS THEN
3106: x_return_status := okl_api.g_ret_sts_unexp_error;
3107: okl_api.set_message(p_app_name => g_app_name,
3108: p_msg_name => g_unexpected_error,
3109: p_token1 => g_sqlcode_token,
3110: p_token1_value => SQLCODE,
3103: x_return_status := l_return_status;
3104: EXCEPTION
3105: WHEN OTHERS THEN
3106: x_return_status := okl_api.g_ret_sts_unexp_error;
3107: okl_api.set_message(p_app_name => g_app_name,
3108: p_msg_name => g_unexpected_error,
3109: p_token1 => g_sqlcode_token,
3110: p_token1_value => SQLCODE,
3111: p_token2 => g_sqlerrm_token,
3240: -- Declare Process Variable
3241: -----------------------------------------------------------------
3242: l_api_version CONSTANT NUMBER := 1;
3243: l_api_name CONSTANT VARCHAR2(30) := 'process_strm_bal_details';
3244: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3245: -- Debug related parameters
3246: l_module CONSTANT fnd_log_messages.module%TYPE := G_MODULE || l_api_name;
3247: l_debug_enabled VARCHAR2(10);
3248: is_debug_procedure_on BOOLEAN;
3261: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
3262: 'begin debug OKLRRPTB.pls call ' || l_api_name);
3263: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
3264: 'Begin: ' || l_api_name ||'(+)' );
3265: l_return_status := okl_api.g_ret_sts_success;
3266: -- By now we have the List of Eligible Products and Code Combinations Available
3267: -- in the corresponding _GT tables
3268: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
3269: 'Input Parameters ' ||
3427: -- If any exception was thrown, then reset the reporting streams - MG uptake
3428: IF g_representation_type = 'SECONDARY' THEN
3429: OKL_STREAMS_SEC_PVT.RESET_REPO_STREAMS;
3430: END IF;
3431: x_return_status := okl_api.g_ret_sts_error;
3432: END process_strm_bal_details;
3433:
3434:
3435: -- Start of comments
3474: -- Declare Process Variable
3475: -----------------------------------------------------------------
3476: l_api_version CONSTANT NUMBER := 1;
3477: l_api_name CONSTANT VARCHAR2(30) := 'populate_acc_data';
3478: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3479: -- Debug related parameters
3480: l_module CONSTANT fnd_log_messages.module%TYPE := G_MODULE || l_api_name;
3481: l_debug_enabled VARCHAR2(10);
3482: is_debug_procedure_on BOOLEAN;
3495: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
3496: 'begin debug OKLRRPTB.pls call ' || l_api_name);
3497: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
3498: 'Begin: ' || l_api_name ||'(+)' );
3499: l_return_status := okl_api.g_ret_sts_success;
3500: -- By now we have the List of Eligible Products and Code Combinations Available
3501: -- in the corresponding _GT tables
3502: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
3503: 'Input Parameters ' ||
5047: x_return_status := l_return_status;
5048: EXCEPTION
5049: WHEN OTHERS
5050: THEN
5051: x_return_status := okl_api.g_ret_sts_unexp_error;
5052: okl_api.set_message(p_app_name => g_app_name,
5053: p_msg_name => g_unexpected_error,
5054: p_token1 => g_sqlcode_token,
5055: p_token1_value => SQLCODE,
5048: EXCEPTION
5049: WHEN OTHERS
5050: THEN
5051: x_return_status := okl_api.g_ret_sts_unexp_error;
5052: okl_api.set_message(p_app_name => g_app_name,
5053: p_msg_name => g_unexpected_error,
5054: p_token1 => g_sqlcode_token,
5055: p_token1_value => SQLCODE,
5056: p_token2 => g_sqlerrm_token,
5083: -- Declare Process Variable
5084: -----------------------------------------------------------------
5085: l_api_version CONSTANT NUMBER := 1;
5086: l_api_name CONSTANT VARCHAR2(30) := 'populate_gl_balances';
5087: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
5088: -- Debug related parameters
5089: l_module CONSTANT fnd_log_messages.module%TYPE := G_MODULE || l_api_name;
5090: l_debug_enabled VARCHAR2(10);
5091: is_debug_procedure_on BOOLEAN;
5101: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
5102: 'begin debug OKLRRPTB.pls call ' || l_api_name);
5103: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
5104: 'Begin: ' || l_api_name ||'(+)' );
5105: l_return_status := okl_api.g_ret_sts_success;
5106: -- By now we have the List of Eligible Products and Code Combinations Available
5107: -- in the corresponding _GT tables
5108: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
5109: 'Input Parameters ' ||
5810: x_return_status := l_return_status;
5811: EXCEPTION
5812: WHEN OTHERS
5813: THEN
5814: x_return_status := okl_api.g_ret_sts_unexp_error;
5815: okl_api.set_message(p_app_name => g_app_name,
5816: p_msg_name => g_unexpected_error,
5817: p_token1 => g_sqlcode_token,
5818: p_token1_value => SQLCODE,
5811: EXCEPTION
5812: WHEN OTHERS
5813: THEN
5814: x_return_status := okl_api.g_ret_sts_unexp_error;
5815: okl_api.set_message(p_app_name => g_app_name,
5816: p_msg_name => g_unexpected_error,
5817: p_token1 => g_sqlcode_token,
5818: p_token1_value => SQLCODE,
5819: p_token2 => g_sqlerrm_token,
5846: -- Declare Process Variable
5847: -----------------------------------------------------------------
5848: l_api_version CONSTANT NUMBER := 1;
5849: l_api_name CONSTANT VARCHAR2(30) := 'validate_orgs_access';
5850: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
5851: -- Debug related parameters
5852: l_module CONSTANT fnd_log_messages.module%TYPE := G_MODULE || l_api_name;
5853: l_debug_enabled VARCHAR2(10);
5854: is_debug_procedure_on BOOLEAN;
5916: RETURN TRUE;
5917: EXCEPTION
5918: WHEN OTHERS
5919: THEN
5920: l_return_status := okl_api.g_ret_sts_unexp_error;
5921: -- Set the oracle error message
5922: okl_api.set_message(p_app_name => okc_api.g_app_name,
5923: p_msg_name => g_unexpected_error,
5924: p_token1 => g_sqlcode_token,
5918: WHEN OTHERS
5919: THEN
5920: l_return_status := okl_api.g_ret_sts_unexp_error;
5921: -- Set the oracle error message
5922: okl_api.set_message(p_app_name => okc_api.g_app_name,
5923: p_msg_name => g_unexpected_error,
5924: p_token1 => g_sqlcode_token,
5925: p_token1_value => SQLCODE,
5926: p_token2 => g_sqlerrm_token,
5965: L_TRX_NON_SPEC_STRMS CONSTANT VARCHAR2(30) := 'TRX_NON_SPEC_STRMS';
5966:
5967: l_api_version CONSTANT NUMBER := 1;
5968: l_api_name CONSTANT VARCHAR2(30) := 'POPULATE_STRM_TO_TRX_DATA';
5969: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
5970:
5971: -- Debug related parameters
5972: l_module CONSTANT fnd_log_messages.module%TYPE := G_MODULE || l_api_name;
5973: l_debug_enabled VARCHAR2(10);
6475: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
6476: 'Starting the processing of streams to transactions and transactions to streams for income: '
6477: || TO_CHAR(l_trace_time, 'DD-MON-YYY HH:MM:SS') );
6478:
6479: l_return_status := okl_api.g_ret_sts_success;
6480:
6481: l_report_count := 1;
6482:
6483: --Check and fetch streams defined on template
7319: IF g_representation_type = 'SECONDARY' THEN
7320: OKL_STREAMS_SEC_PVT.RESET_REPO_STREAMS;
7321: END IF;
7322:
7323: x_return_status := okl_api.g_ret_sts_error;
7324: END POPULATE_STRM_TO_TRX_DATA;
7325:
7326: -- Start of comments
7327: --
7376: -- Declare Process Variable
7377: -----------------------------------------------------------------
7378: l_api_version CONSTANT NUMBER := 1;
7379: l_api_name CONSTANT VARCHAR2(30) := 'generate_gross_inv_recon_rpt';
7380: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
7381: -- Debug related parameters
7382: l_module CONSTANT fnd_log_messages.module%TYPE := G_MODULE || l_api_name;
7383: l_debug_enabled VARCHAR2(10);
7384: is_debug_procedure_on BOOLEAN;
7398: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'P',
7399: 'BEGIN API OKL_REPORT_GENERATOR_PVT.generate_gross_inv_recon_rpt');
7400: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
7401: 'Start of the Main Logic');
7402: l_init_msg_list := OKL_API.G_FALSE;
7403: l_return_status := OKL_API.G_RET_STS_SUCCESS;
7404:
7405: --Get representation type of the ledger
7406: OPEN C_GET_LEGER_REPRENSENTATION(p_ledger_id);
7399: 'BEGIN API OKL_REPORT_GENERATOR_PVT.generate_gross_inv_recon_rpt');
7400: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
7401: 'Start of the Main Logic');
7402: l_init_msg_list := OKL_API.G_FALSE;
7403: l_return_status := OKL_API.G_RET_STS_SUCCESS;
7404:
7405: --Get representation type of the ledger
7406: OPEN C_GET_LEGER_REPRENSENTATION(p_ledger_id);
7407: FETCH C_GET_LEGER_REPRENSENTATION INTO g_representation_type;
7445: ,p_report_id => p_report_id
7446: ,p_ledger_id => p_ledger_id);
7447: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
7448: 'After call to the populate_code_combinations ' || l_return_status );
7449: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
7450: RAISE okl_api.g_exception_unexpected_error;
7451: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
7452: RAISE okl_api.g_exception_error;
7453: END IF;
7446: ,p_ledger_id => p_ledger_id);
7447: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
7448: 'After call to the populate_code_combinations ' || l_return_status );
7449: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
7450: RAISE okl_api.g_exception_unexpected_error;
7451: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
7452: RAISE okl_api.g_exception_error;
7453: END IF;
7454:
7447: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
7448: 'After call to the populate_code_combinations ' || l_return_status );
7449: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
7450: RAISE okl_api.g_exception_unexpected_error;
7451: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
7452: RAISE okl_api.g_exception_error;
7453: END IF;
7454:
7455: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
7448: 'After call to the populate_code_combinations ' || l_return_status );
7449: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
7450: RAISE okl_api.g_exception_unexpected_error;
7451: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
7452: RAISE okl_api.g_exception_error;
7453: END IF;
7454:
7455: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
7456: 'Before calling populate_products: p_report_id=' || p_report_id
7464: ,p_report_id => p_report_id
7465: ,p_org_id => l_org_id );
7466: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
7467: 'After call to the populate_products ' || l_return_status );
7468: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
7469: RAISE okl_api.g_exception_unexpected_error;
7470: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
7471: RAISE okl_api.g_exception_error;
7472: END IF;
7465: ,p_org_id => l_org_id );
7466: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
7467: 'After call to the populate_products ' || l_return_status );
7468: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
7469: RAISE okl_api.g_exception_unexpected_error;
7470: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
7471: RAISE okl_api.g_exception_error;
7472: END IF;
7473:
7466: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
7467: 'After call to the populate_products ' || l_return_status );
7468: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
7469: RAISE okl_api.g_exception_unexpected_error;
7470: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
7471: RAISE okl_api.g_exception_error;
7472: END IF;
7473:
7474: -- Retreive the GL period from and period to dates.
7467: 'After call to the populate_products ' || l_return_status );
7468: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
7469: RAISE okl_api.g_exception_unexpected_error;
7470: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
7471: RAISE okl_api.g_exception_error;
7472: END IF;
7473:
7474: -- Retreive the GL period from and period to dates.
7475: OPEN get_period_from_date;
7476: FETCH get_period_from_date
7477: INTO l_start_date;
7478: IF get_period_from_date%NOTFOUND
7479: THEN
7480: RAISE okl_api.g_exception_error;
7481: END IF;
7482: CLOSE get_period_from_date;
7483:
7484: OPEN get_period_to_date;
7485: FETCH get_period_to_date
7486: INTO l_end_date;
7487: IF get_period_to_date%NOTFOUND
7488: THEN
7489: RAISE okl_api.g_exception_error;
7490: END IF;
7491: CLOSE get_period_to_date;
7492:
7493: ---------------------------------------------------------------------------
7511: ,p_org_id => l_org_id
7512: ,p_le_id => l_le_id);
7513: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
7514: 'After call to the populate_trx_data ' || l_return_status );
7515: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
7516: RAISE okl_api.g_exception_unexpected_error;
7517: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
7518: RAISE okl_api.g_exception_error;
7519: END IF;
7512: ,p_le_id => l_le_id);
7513: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
7514: 'After call to the populate_trx_data ' || l_return_status );
7515: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
7516: RAISE okl_api.g_exception_unexpected_error;
7517: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
7518: RAISE okl_api.g_exception_error;
7519: END IF;
7520:
7513: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
7514: 'After call to the populate_trx_data ' || l_return_status );
7515: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
7516: RAISE okl_api.g_exception_unexpected_error;
7517: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
7518: RAISE okl_api.g_exception_error;
7519: END IF;
7520:
7521: ------------------------------------------------------------
7514: 'After call to the populate_trx_data ' || l_return_status );
7515: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
7516: RAISE okl_api.g_exception_unexpected_error;
7517: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
7518: RAISE okl_api.g_exception_error;
7519: END IF;
7520:
7521: ------------------------------------------------------------
7522: -- Call the API to Calculate the Stream Balances
7538: ,p_org_id => l_org_id
7539: ,p_le_id => l_le_id);
7540: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
7541: 'After call to the process_strm_bal_details ' || l_return_status );
7542: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
7543: RAISE okl_api.g_exception_unexpected_error;
7544: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
7545: RAISE okl_api.g_exception_error;
7546: END IF;
7539: ,p_le_id => l_le_id);
7540: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
7541: 'After call to the process_strm_bal_details ' || l_return_status );
7542: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
7543: RAISE okl_api.g_exception_unexpected_error;
7544: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
7545: RAISE okl_api.g_exception_error;
7546: END IF;
7547: END IF;
7540: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
7541: 'After call to the process_strm_bal_details ' || l_return_status );
7542: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
7543: RAISE okl_api.g_exception_unexpected_error;
7544: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
7545: RAISE okl_api.g_exception_error;
7546: END IF;
7547: END IF;
7548:
7541: 'After call to the process_strm_bal_details ' || l_return_status );
7542: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
7543: RAISE okl_api.g_exception_unexpected_error;
7544: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
7545: RAISE okl_api.g_exception_error;
7546: END IF;
7547: END IF;
7548:
7549: ------------------------------------------------------------
7565: ,p_org_id => l_org_id
7566: ,p_le_id => l_le_id);
7567: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
7568: 'After call to the populate_acc_data ' || l_return_status );
7569: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
7570: RAISE okl_api.g_exception_unexpected_error;
7571: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
7572: RAISE okl_api.g_exception_error;
7573: END IF;
7566: ,p_le_id => l_le_id);
7567: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
7568: 'After call to the populate_acc_data ' || l_return_status );
7569: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
7570: RAISE okl_api.g_exception_unexpected_error;
7571: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
7572: RAISE okl_api.g_exception_error;
7573: END IF;
7574:
7567: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
7568: 'After call to the populate_acc_data ' || l_return_status );
7569: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
7570: RAISE okl_api.g_exception_unexpected_error;
7571: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
7572: RAISE okl_api.g_exception_error;
7573: END IF;
7574:
7575: ---------------------------------------------------------------------------
7568: 'After call to the populate_acc_data ' || l_return_status );
7569: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
7570: RAISE okl_api.g_exception_unexpected_error;
7571: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
7572: RAISE okl_api.g_exception_error;
7573: END IF;
7574:
7575: ---------------------------------------------------------------------------
7576: -- Invoking the API to Populate the GL Opening Balances as on Period From
7589: ,p_period_from => p_gl_period_from
7590: ,p_period_to => p_gl_period_to );
7591: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
7592: 'After call to the populate_gl_balances ' || l_return_status );
7593: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
7594: RAISE okl_api.g_exception_unexpected_error;
7595: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
7596: RAISE okl_api.g_exception_error;
7597: END IF;
7590: ,p_period_to => p_gl_period_to );
7591: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
7592: 'After call to the populate_gl_balances ' || l_return_status );
7593: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
7594: RAISE okl_api.g_exception_unexpected_error;
7595: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
7596: RAISE okl_api.g_exception_error;
7597: END IF;
7598:
7591: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
7592: 'After call to the populate_gl_balances ' || l_return_status );
7593: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
7594: RAISE okl_api.g_exception_unexpected_error;
7595: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
7596: RAISE okl_api.g_exception_error;
7597: END IF;
7598:
7599: ------------------------------------------------------------
7592: 'After call to the populate_gl_balances ' || l_return_status );
7593: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
7594: RAISE okl_api.g_exception_unexpected_error;
7595: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
7596: RAISE okl_api.g_exception_error;
7597: END IF;
7598:
7599: ------------------------------------------------------------
7600: -- If report type is INCOME then call the API to reconcile
7616: ,p_org_id => l_org_id
7617: ,p_le_id => l_le_id);
7618: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
7619: 'After call to the POPULATE_STRM_TO_TRX_DATA ' || l_return_status );
7620: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
7621: RAISE okl_api.g_exception_unexpected_error;
7622: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
7623: RAISE okl_api.g_exception_error;
7624: END IF;
7617: ,p_le_id => l_le_id);
7618: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
7619: 'After call to the POPULATE_STRM_TO_TRX_DATA ' || l_return_status );
7620: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
7621: RAISE okl_api.g_exception_unexpected_error;
7622: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
7623: RAISE okl_api.g_exception_error;
7624: END IF;
7625: END IF;
7618: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
7619: 'After call to the POPULATE_STRM_TO_TRX_DATA ' || l_return_status );
7620: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
7621: RAISE okl_api.g_exception_unexpected_error;
7622: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
7623: RAISE okl_api.g_exception_error;
7624: END IF;
7625: END IF;
7626:
7619: 'After call to the POPULATE_STRM_TO_TRX_DATA ' || l_return_status );
7620: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
7621: RAISE okl_api.g_exception_unexpected_error;
7622: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
7623: RAISE okl_api.g_exception_error;
7624: END IF;
7625: END IF;
7626:
7627:
7630: RETURN TRUE;
7631: EXCEPTION
7632: WHEN OTHERS
7633: THEN
7634: l_return_status := okl_api.g_ret_sts_unexp_error;
7635: -- Set the oracle error message
7636: okl_api.set_message(p_app_name => okc_api.g_app_name,
7637: p_msg_name => g_unexpected_error,
7638: p_token1 => g_sqlcode_token,
7632: WHEN OTHERS
7633: THEN
7634: l_return_status := okl_api.g_ret_sts_unexp_error;
7635: -- Set the oracle error message
7636: okl_api.set_message(p_app_name => okc_api.g_app_name,
7637: p_msg_name => g_unexpected_error,
7638: p_token1 => g_sqlcode_token,
7639: p_token1_value => SQLCODE,
7640: p_token2 => g_sqlerrm_token,