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_REPORT_GENERATOR_PVT dependencies on OKL_API

Line 176: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

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;

Line 194: l_return_status := okl_api.g_ret_sts_success;

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',

Line 256: x_return_status := okl_api.g_ret_sts_unexp_error;

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,

Line 257: okl_api.set_message(p_app_name => g_app_name,

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,

Line 342: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

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;

Line 362: l_return_status := okl_api.g_ret_sts_success;

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

Line 423: x_return_status := okl_api.g_ret_sts_unexp_error;

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,

Line 424: okl_api.set_message(p_app_name => g_app_name,

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,

Line 464: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

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;

Line 483: l_return_status := okl_api.g_ret_sts_success;

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 ' ||

Line 3106: x_return_status := okl_api.g_ret_sts_unexp_error;

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,

Line 3107: okl_api.set_message(p_app_name => g_app_name,

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,

Line 3244: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

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;

Line 3265: l_return_status := okl_api.g_ret_sts_success;

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 ' ||

Line 3431: x_return_status := okl_api.g_ret_sts_error;

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

Line 3478: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

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;

Line 3499: l_return_status := okl_api.g_ret_sts_success;

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 ' ||

Line 5051: x_return_status := okl_api.g_ret_sts_unexp_error;

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,

Line 5052: okl_api.set_message(p_app_name => g_app_name,

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,

Line 5087: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

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;

Line 5105: l_return_status := okl_api.g_ret_sts_success;

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 ' ||

Line 5814: x_return_status := okl_api.g_ret_sts_unexp_error;

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,

Line 5815: okl_api.set_message(p_app_name => g_app_name,

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,

Line 5850: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

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;

Line 5920: l_return_status := okl_api.g_ret_sts_unexp_error;

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,

Line 5922: okl_api.set_message(p_app_name => okc_api.g_app_name,

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,

Line 5969: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

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);

Line 6479: l_return_status := okl_api.g_ret_sts_success;

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

Line 7323: x_return_status := okl_api.g_ret_sts_error;

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: --

Line 7380: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

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;

Line 7402: l_init_msg_list := OKL_API.G_FALSE;

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);

Line 7403: l_return_status := OKL_API.G_RET_STS_SUCCESS;

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;

Line 7449: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

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;

Line 7450: RAISE okl_api.g_exception_unexpected_error;

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:

Line 7451: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

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',

Line 7452: RAISE okl_api.g_exception_error;

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

Line 7468: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

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;

Line 7469: RAISE okl_api.g_exception_unexpected_error;

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:

Line 7470: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

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.

Line 7471: RAISE okl_api.g_exception_error;

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;

Line 7480: RAISE okl_api.g_exception_error;

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;

Line 7489: RAISE okl_api.g_exception_error;

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: ---------------------------------------------------------------------------

Line 7515: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

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;

Line 7516: RAISE okl_api.g_exception_unexpected_error;

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:

Line 7517: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

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: ------------------------------------------------------------

Line 7518: RAISE okl_api.g_exception_error;

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

Line 7542: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

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;

Line 7543: RAISE okl_api.g_exception_unexpected_error;

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;

Line 7544: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

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:

Line 7545: RAISE okl_api.g_exception_error;

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: ------------------------------------------------------------

Line 7569: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

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;

Line 7570: RAISE okl_api.g_exception_unexpected_error;

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:

Line 7571: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

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: ---------------------------------------------------------------------------

Line 7572: RAISE okl_api.g_exception_error;

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

Line 7593: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

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;

Line 7594: RAISE okl_api.g_exception_unexpected_error;

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:

Line 7595: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

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: ------------------------------------------------------------

Line 7596: RAISE okl_api.g_exception_error;

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

Line 7620: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

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;

Line 7621: RAISE okl_api.g_exception_unexpected_error;

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;

Line 7622: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

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:

Line 7623: RAISE okl_api.g_exception_error;

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:

Line 7634: l_return_status := okl_api.g_ret_sts_unexp_error;

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,

Line 7636: okl_api.set_message(p_app_name => okc_api.g_app_name,

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,