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.JL_ZZ_FA_FUNCTIONS_PKG dependencies on FND_LOG

Line 5: | FND Logging infrastructure |

1: PACKAGE BODY jl_zz_fa_functions_pkg AS
2: /* $Header: jlzzfafb.pls 120.11 2006/09/20 17:13:59 abuissa ship $ */
3:
4: /* ======================================================================*
5: | FND Logging infrastructure |
6: * ======================================================================*/
7: G_PKG_NAME CONSTANT VARCHAR2(30) := 'JL_ZZ_FA_FUNCTIONS_PKG';
8: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
9: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;

Line 8: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

4: /* ======================================================================*
5: | FND Logging infrastructure |
6: * ======================================================================*/
7: G_PKG_NAME CONSTANT VARCHAR2(30) := 'JL_ZZ_FA_FUNCTIONS_PKG';
8: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
9: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
10: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
11: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
12: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;

Line 9: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;

5: | FND Logging infrastructure |
6: * ======================================================================*/
7: G_PKG_NAME CONSTANT VARCHAR2(30) := 'JL_ZZ_FA_FUNCTIONS_PKG';
8: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
9: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
10: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
11: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
12: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
13: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

Line 10: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;

6: * ======================================================================*/
7: G_PKG_NAME CONSTANT VARCHAR2(30) := 'JL_ZZ_FA_FUNCTIONS_PKG';
8: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
9: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
10: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
11: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
12: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
13: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
14: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

Line 11: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;

7: G_PKG_NAME CONSTANT VARCHAR2(30) := 'JL_ZZ_FA_FUNCTIONS_PKG';
8: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
9: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
10: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
11: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
12: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
13: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
14: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
15: G_MODULE_NAME CONSTANT VARCHAR2(80) := 'JL.PLSQL.JL_ZZ_FA_FUNCTIONS_PKG.';

Line 12: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;

8: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
9: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
10: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
11: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
12: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
13: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
14: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
15: G_MODULE_NAME CONSTANT VARCHAR2(80) := 'JL.PLSQL.JL_ZZ_FA_FUNCTIONS_PKG.';
16:

Line 13: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

9: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
10: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
11: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
12: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
13: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
14: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
15: G_MODULE_NAME CONSTANT VARCHAR2(80) := 'JL.PLSQL.JL_ZZ_FA_FUNCTIONS_PKG.';
16:
17:

Line 14: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

10: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
11: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
12: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
13: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
14: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
15: G_MODULE_NAME CONSTANT VARCHAR2(80) := 'JL.PLSQL.JL_ZZ_FA_FUNCTIONS_PKG.';
16:
17:
18: TYPE temp_plsql_table is table of JL_AR_FA_EXHIBIT_REPORT%ROWTYPE index by binary_integer;

Line 695: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');

691: END;
692: p_depr_rpt_period := p_depr_rpt_period + l_depr_rpt_period;
693:
694: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
695: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
696: END IF;
697:
698: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
699: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_depr_rpt_period := '||to_char(p_depr_rpt_period));

Line 700: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'p_depr_rpt_period := '||to_char(p_depr_rpt_period));

696: END IF;
697:
698: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
699: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_depr_rpt_period := '||to_char(p_depr_rpt_period));
700: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'p_depr_rpt_period := '||to_char(p_depr_rpt_period));
701: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_depr_rpt_period := '||to_char(p_depr_rpt_period));
702: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'p_depr_rpt_period := '||to_char(p_depr_rpt_period));
703: END IF;
704:

Line 702: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'p_depr_rpt_period := '||to_char(p_depr_rpt_period));

698: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
699: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_depr_rpt_period := '||to_char(p_depr_rpt_period));
700: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'p_depr_rpt_period := '||to_char(p_depr_rpt_period));
701: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_depr_rpt_period := '||to_char(p_depr_rpt_period));
702: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'p_depr_rpt_period := '||to_char(p_depr_rpt_period));
703: END IF;
704:
705: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
706: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',G_PKG_NAME||': '||l_api_name||'(-)');

Line 706: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',G_PKG_NAME||': '||l_api_name||'(-)');

702: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'p_depr_rpt_period := '||to_char(p_depr_rpt_period));
703: END IF;
704:
705: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
706: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',G_PKG_NAME||': '||l_api_name||'(-)');
707: END IF;
708:
709: END get_asset_info_end_period_mrc;
710:

Line 731: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');

727:
728: BEGIN
729:
730: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
731: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
732: END IF;
733:
734: BEGIN
735: SELECT nvl(bk.cost,0)

Line 764: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'NEW 1: p_accum_depr_beg_period := '||to_char(p_accum_depr_begin_period));

760: END;
761:
762: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
763: FND_FILE.PUT_LINE(FND_FILE.LOG,'NEW 1: p_accum_depr_beg_period := '||to_char(p_accum_depr_begin_period));
764: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'NEW 1: p_accum_depr_beg_period := '||to_char(p_accum_depr_begin_period));
765: END IF;
766:
767: -- Bug 3128957:
768: --

Line 789: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'NEW 2: p_accum_depr_beg_period := '||to_char(p_accum_depr_begin_period));

785: END IF;
786:
787: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
788: FND_FILE.PUT_LINE(FND_FILE.LOG,'NEW 1: p_accum_depr_beg_period := '||to_char(p_accum_depr_begin_period));
789: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'NEW 2: p_accum_depr_beg_period := '||to_char(p_accum_depr_begin_period));
790: END IF;
791:
792: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
793: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',G_PKG_NAME||': '||l_api_name||'(-)');

Line 793: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',G_PKG_NAME||': '||l_api_name||'(-)');

789: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'NEW 2: p_accum_depr_beg_period := '||to_char(p_accum_depr_begin_period));
790: END IF;
791:
792: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
793: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',G_PKG_NAME||': '||l_api_name||'(-)');
794: END IF;
795:
796: END get_asset_info_beg_period;
797:

Line 823: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');

819:
820:
821: BEGIN
822: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
823: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
824: END IF;
825:
826: BEGIN
827: SELECT nvl(bk.cost,0)

Line 928: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'p_depr_rpt_period := '||to_char(p_depr_rpt_period));

924: END;
925: p_depr_rpt_period := p_depr_rpt_period + l_depr_rpt_period;
926: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
927: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_depr_rpt_period := '||to_char(p_depr_rpt_period));
928: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'p_depr_rpt_period := '||to_char(p_depr_rpt_period));
929: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_depr_rpt_period := '||to_char(p_depr_rpt_period));
930: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'p_depr_rpt_period := '||to_char(p_depr_rpt_period));
931: END IF;
932:

Line 930: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'p_depr_rpt_period := '||to_char(p_depr_rpt_period));

926: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
927: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_depr_rpt_period := '||to_char(p_depr_rpt_period));
928: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'p_depr_rpt_period := '||to_char(p_depr_rpt_period));
929: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_depr_rpt_period := '||to_char(p_depr_rpt_period));
930: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'p_depr_rpt_period := '||to_char(p_depr_rpt_period));
931: END IF;
932:
933: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
934: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',G_PKG_NAME||': '||l_api_name||'(-)');

Line 934: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',G_PKG_NAME||': '||l_api_name||'(-)');

930: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'p_depr_rpt_period := '||to_char(p_depr_rpt_period));
931: END IF;
932:
933: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
934: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',G_PKG_NAME||': '||l_api_name||'(-)');
935: END IF;
936:
937: END get_asset_info_end_period;
938:

Line 1075: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');

1071:
1072:
1073: BEGIN
1074: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1075: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
1076: END IF;
1077:
1078: IF p_mrcsobtype = 'R' THEN
1079: get_asset_info_beg_period_mrc ( p_hist_book_type_code

Line 1087: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'p_historical_cost_beg_period := '||to_char(p_historical_cost_begin_period));

1083: , p_historical_cost_begin_period
1084: , p_accum_depr_begin_period);
1085: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1086: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_historical_cost_beg_period := '||to_char(p_historical_cost_begin_period));
1087: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'p_historical_cost_beg_period := '||to_char(p_historical_cost_begin_period));
1088: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_accum_depr_beg_period := '||to_char(p_accum_depr_begin_period));
1089: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'p_accum_depr_beg_period := '||to_char(p_accum_depr_begin_period));
1090: END IF;
1091:

Line 1089: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'p_accum_depr_beg_period := '||to_char(p_accum_depr_begin_period));

1085: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1086: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_historical_cost_beg_period := '||to_char(p_historical_cost_begin_period));
1087: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'p_historical_cost_beg_period := '||to_char(p_historical_cost_begin_period));
1088: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_accum_depr_beg_period := '||to_char(p_accum_depr_begin_period));
1089: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'p_accum_depr_beg_period := '||to_char(p_accum_depr_begin_period));
1090: END IF;
1091:
1092: get_asset_info_end_period_mrc ( p_hist_book_type_code
1093: , p_adj_book_type_code

Line 1111: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'p_historical_cost_beg_period := '||to_char(p_historical_cost_begin_period));

1107: , p_historical_cost_begin_period
1108: , p_accum_depr_begin_period);
1109: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1110: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_historical_cost_beg_period := '||to_char(p_historical_cost_begin_period));
1111: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'p_historical_cost_beg_period := '||to_char(p_historical_cost_begin_period));
1112: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_accum_depr_beg_period := '||to_char(p_accum_depr_begin_period));
1113: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'p_accum_depr_beg_period := '||to_char(p_accum_depr_begin_period));
1114: END IF;
1115:

Line 1113: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'p_accum_depr_beg_period := '||to_char(p_accum_depr_begin_period));

1109: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1110: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_historical_cost_beg_period := '||to_char(p_historical_cost_begin_period));
1111: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'p_historical_cost_beg_period := '||to_char(p_historical_cost_begin_period));
1112: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_accum_depr_beg_period := '||to_char(p_accum_depr_begin_period));
1113: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'p_accum_depr_beg_period := '||to_char(p_accum_depr_begin_period));
1114: END IF;
1115:
1116: get_asset_info_end_period ( p_hist_book_type_code
1117: , p_adj_book_type_code

Line 1131: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'p_historical_cost_end_period := '||to_char(p_historical_cost_end_period));

1127: END IF;
1128:
1129: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1130: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_historical_cost_end_period := '||to_char(p_historical_cost_end_period));
1131: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'p_historical_cost_end_period := '||to_char(p_historical_cost_end_period));
1132: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_adjusted_cost_end_period := '||to_char(p_adjusted_cost_end_period));
1133: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'p_adjusted_cost_end_period := '||to_char(p_adjusted_cost_end_period));
1134: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_hist_accum_depr_end_period := '||to_char(p_hist_accum_depr_end_period));
1135: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'p_hist_accum_depr_end_period := '||to_char(p_hist_accum_depr_end_period));

Line 1133: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'p_adjusted_cost_end_period := '||to_char(p_adjusted_cost_end_period));

1129: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1130: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_historical_cost_end_period := '||to_char(p_historical_cost_end_period));
1131: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'p_historical_cost_end_period := '||to_char(p_historical_cost_end_period));
1132: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_adjusted_cost_end_period := '||to_char(p_adjusted_cost_end_period));
1133: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'p_adjusted_cost_end_period := '||to_char(p_adjusted_cost_end_period));
1134: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_hist_accum_depr_end_period := '||to_char(p_hist_accum_depr_end_period));
1135: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'p_hist_accum_depr_end_period := '||to_char(p_hist_accum_depr_end_period));
1136: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_adj_accum_depr_end_period := '||to_char(p_adj_accum_depr_end_period));
1137: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'p_adj_accum_depr_end_period := '||to_char(p_adj_accum_depr_end_period));

Line 1135: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'p_hist_accum_depr_end_period := '||to_char(p_hist_accum_depr_end_period));

1131: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'p_historical_cost_end_period := '||to_char(p_historical_cost_end_period));
1132: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_adjusted_cost_end_period := '||to_char(p_adjusted_cost_end_period));
1133: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'p_adjusted_cost_end_period := '||to_char(p_adjusted_cost_end_period));
1134: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_hist_accum_depr_end_period := '||to_char(p_hist_accum_depr_end_period));
1135: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'p_hist_accum_depr_end_period := '||to_char(p_hist_accum_depr_end_period));
1136: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_adj_accum_depr_end_period := '||to_char(p_adj_accum_depr_end_period));
1137: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'p_adj_accum_depr_end_period := '||to_char(p_adj_accum_depr_end_period));
1138: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_depr_rpt_period := '||to_char(p_depr_rpt_period));
1139: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'p_depr_rpt_period := '||to_char(p_depr_rpt_period));

Line 1137: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'p_adj_accum_depr_end_period := '||to_char(p_adj_accum_depr_end_period));

1133: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'p_adjusted_cost_end_period := '||to_char(p_adjusted_cost_end_period));
1134: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_hist_accum_depr_end_period := '||to_char(p_hist_accum_depr_end_period));
1135: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'p_hist_accum_depr_end_period := '||to_char(p_hist_accum_depr_end_period));
1136: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_adj_accum_depr_end_period := '||to_char(p_adj_accum_depr_end_period));
1137: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'p_adj_accum_depr_end_period := '||to_char(p_adj_accum_depr_end_period));
1138: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_depr_rpt_period := '||to_char(p_depr_rpt_period));
1139: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'p_depr_rpt_period := '||to_char(p_depr_rpt_period));
1140: END IF;
1141:

Line 1139: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'p_depr_rpt_period := '||to_char(p_depr_rpt_period));

1135: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'p_hist_accum_depr_end_period := '||to_char(p_hist_accum_depr_end_period));
1136: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_adj_accum_depr_end_period := '||to_char(p_adj_accum_depr_end_period));
1137: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'p_adj_accum_depr_end_period := '||to_char(p_adj_accum_depr_end_period));
1138: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_depr_rpt_period := '||to_char(p_depr_rpt_period));
1139: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'p_depr_rpt_period := '||to_char(p_depr_rpt_period));
1140: END IF;
1141:
1142: IF p_historical_cost_end_period <> 0 THEN
1143: p_cost_coefficient := p_adjusted_cost_end_period / p_historical_cost_end_period;

Line 1244: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'l_period_counter_fully_retired := '||to_char(l_period_counter_fully_retired));

1240:
1241: IF l_hist_cost_retirement <> 0 THEN
1242: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1243: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_period_counter_fully_retired := '||to_char(l_period_counter_fully_retired));
1244: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'l_period_counter_fully_retired := '||to_char(l_period_counter_fully_retired));
1245: END IF;
1246: get_remain_reval_coefficient ( p_adj_book_type_code
1247: , p_asset_id
1248: , l_date_placed_in_service

Line 1256: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'l_remain_reval_coefficient := '||to_char(l_remain_reval_coefficient));

1252: );
1253:
1254: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1255: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_remain_reval_coefficient := '||to_char(l_remain_reval_coefficient));
1256: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'l_remain_reval_coefficient := '||to_char(l_remain_reval_coefficient));
1257: END IF;
1258:
1259: p_cost_coefficient := l_remain_reval_coefficient * l_adj_cost_retirement / l_hist_cost_retirement;
1260:

Line 1263: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'p_cost_coefficient := '||to_char(p_cost_coefficient));

1259: p_cost_coefficient := l_remain_reval_coefficient * l_adj_cost_retirement / l_hist_cost_retirement;
1260:
1261: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1262: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_cost_coefficient := '||to_char(p_cost_coefficient));
1263: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'p_cost_coefficient := '||to_char(p_cost_coefficient));
1264: END IF;
1265:
1266: ELSE
1267: p_cost_coefficient := 0;

Line 1279: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'p_cost_coefficient := '||to_char(p_cost_coefficient));

1275: END IF;
1276:
1277: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1278: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_cost_coefficient := '||to_char(p_cost_coefficient));
1279: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'p_cost_coefficient := '||to_char(p_cost_coefficient));
1280: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_depr_coefficient := '||to_char(p_depr_coefficient));
1281: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'p_depr_coefficient := '||to_char(p_depr_coefficient));
1282: END IF;
1283:

Line 1281: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'p_depr_coefficient := '||to_char(p_depr_coefficient));

1277: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1278: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_cost_coefficient := '||to_char(p_cost_coefficient));
1279: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'p_cost_coefficient := '||to_char(p_cost_coefficient));
1280: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_depr_coefficient := '||to_char(p_depr_coefficient));
1281: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'p_depr_coefficient := '||to_char(p_depr_coefficient));
1282: END IF;
1283:
1284: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1285: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',G_PKG_NAME||': '||l_api_name||'(-)');

Line 1285: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',G_PKG_NAME||': '||l_api_name||'(-)');

1281: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'p_depr_coefficient := '||to_char(p_depr_coefficient));
1282: END IF;
1283:
1284: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1285: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',G_PKG_NAME||': '||l_api_name||'(-)');
1286: END IF;
1287:
1288: END get_cost_coefficient;
1289:

Line 1309: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');

1305:
1306: BEGIN
1307:
1308: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1309: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
1310: END IF;
1311:
1312: l_category_id := p_category_id;
1313:

Line 1316: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'p_asset_id = '||to_char(p_asset_id));

1312: l_category_id := p_category_id;
1313:
1314: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1315: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_asset_id = '||to_char(p_asset_id));
1316: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'p_asset_id = '||to_char(p_asset_id));
1317: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_category_id = '||to_char(p_category_id));
1318: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'p_category_id = '||to_char(p_category_id));
1319: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_asset_type = '||p_asset_type);
1320: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'p_asset_type = '||p_asset_type);

Line 1318: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'p_category_id = '||to_char(p_category_id));

1314: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1315: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_asset_id = '||to_char(p_asset_id));
1316: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'p_asset_id = '||to_char(p_asset_id));
1317: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_category_id = '||to_char(p_category_id));
1318: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'p_category_id = '||to_char(p_category_id));
1319: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_asset_type = '||p_asset_type);
1320: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'p_asset_type = '||p_asset_type);
1321: END IF;
1322:

Line 1320: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'p_asset_type = '||p_asset_type);

1316: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'p_asset_id = '||to_char(p_asset_id));
1317: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_category_id = '||to_char(p_category_id));
1318: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'p_category_id = '||to_char(p_category_id));
1319: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_asset_type = '||p_asset_type);
1320: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'p_asset_type = '||p_asset_type);
1321: END IF;
1322:
1323: IF p_asset_type = 'CIP' THEN
1324: BEGIN

Line 1347: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'p_exhibit_group_id = '||to_char(p_exhibit_group_id));

1343: END IF;
1344:
1345: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1346: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_exhibit_group_id = '||to_char(p_exhibit_group_id));
1347: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'p_exhibit_group_id = '||to_char(p_exhibit_group_id));
1348: END IF;
1349:
1350: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1351: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',G_PKG_NAME||': '||l_api_name||'(-)');

Line 1351: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',G_PKG_NAME||': '||l_api_name||'(-)');

1347: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'p_exhibit_group_id = '||to_char(p_exhibit_group_id));
1348: END IF;
1349:
1350: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1351: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',G_PKG_NAME||': '||l_api_name||'(-)');
1352: END IF;
1353:
1354: END get_exhibit_group;
1355:

Line 1379: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');

1375:
1376: BEGIN
1377:
1378: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1379: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
1380: END IF;
1381:
1382: p_old_category_id := 0;
1383: p_position := 0;

Line 1412: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'l_cip_exhibit_group_id := '||to_char(l_cip_exhibit_group_id));

1408: END;
1409:
1410: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1411: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_cip_exhibit_group_id := '||to_char(l_cip_exhibit_group_id));
1412: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'l_cip_exhibit_group_id := '||to_char(l_cip_exhibit_group_id));
1413: END IF;
1414:
1415: IF ((l_asset_type = 'CIP') OR (p_old_category_id <> 0)) THEN
1416:

Line 1446: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'p_position = '||to_char(p_position));

1442: END IF;
1443:
1444: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1445: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_position = '||to_char(p_position));
1446: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'p_position = '||to_char(p_position));
1447: END IF;
1448:
1449: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1450: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',G_PKG_NAME||': '||l_api_name||'(-)');

Line 1450: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',G_PKG_NAME||': '||l_api_name||'(-)');

1446: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'p_position = '||to_char(p_position));
1447: END IF;
1448:
1449: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1450: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',G_PKG_NAME||': '||l_api_name||'(-)');
1451: END IF;
1452:
1453: END get_old_category;
1454:

Line 1462: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');

1458:
1459: BEGIN
1460:
1461: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1462: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
1463: END IF;
1464:
1465: row_count := 1;
1466: FOR row_count IN report_table.first .. report_table.last LOOP

Line 1471: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'exhibit_group_id('||to_char(row_count)||'):= '||to_char(report_table(row_count).exhibit_group_id));

1467: IF report_table.exists(row_count) THEN
1468:
1469: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1470: FND_FILE.PUT_LINE(FND_FILE.LOG,'exhibit_group_id('||to_char(row_count)||'):= '||to_char(report_table(row_count).exhibit_group_id));
1471: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'exhibit_group_id('||to_char(row_count)||'):= '||to_char(report_table(row_count).exhibit_group_id));
1472: FND_FILE.PUT_LINE(FND_FILE.LOG,'category_id('||to_char(row_count)||'):= '||to_char(report_table(row_count).category_id));
1473: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'category_id('||to_char(row_count)||'):= '||to_char(report_table(row_count).category_id));
1474: FND_FILE.PUT_LINE(FND_FILE.LOG,'asset_id('||to_char(row_count)||'):= '||to_char(report_table(row_count).asset_id));
1475: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'asset_id('||to_char(row_count)||'):= '||to_char(report_table(row_count).asset_id));

Line 1473: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'category_id('||to_char(row_count)||'):= '||to_char(report_table(row_count).category_id));

1469: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1470: FND_FILE.PUT_LINE(FND_FILE.LOG,'exhibit_group_id('||to_char(row_count)||'):= '||to_char(report_table(row_count).exhibit_group_id));
1471: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'exhibit_group_id('||to_char(row_count)||'):= '||to_char(report_table(row_count).exhibit_group_id));
1472: FND_FILE.PUT_LINE(FND_FILE.LOG,'category_id('||to_char(row_count)||'):= '||to_char(report_table(row_count).category_id));
1473: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'category_id('||to_char(row_count)||'):= '||to_char(report_table(row_count).category_id));
1474: FND_FILE.PUT_LINE(FND_FILE.LOG,'asset_id('||to_char(row_count)||'):= '||to_char(report_table(row_count).asset_id));
1475: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'asset_id('||to_char(row_count)||'):= '||to_char(report_table(row_count).asset_id));
1476: FND_FILE.PUT_LINE(FND_FILE.LOG,'report_table(1).begin_cost := '||to_char(report_table(row_count).begin_cost));
1477: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'report_table(1).begin_cost := '||to_char(report_table(row_count).begin_cost));

Line 1475: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'asset_id('||to_char(row_count)||'):= '||to_char(report_table(row_count).asset_id));

1471: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'exhibit_group_id('||to_char(row_count)||'):= '||to_char(report_table(row_count).exhibit_group_id));
1472: FND_FILE.PUT_LINE(FND_FILE.LOG,'category_id('||to_char(row_count)||'):= '||to_char(report_table(row_count).category_id));
1473: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'category_id('||to_char(row_count)||'):= '||to_char(report_table(row_count).category_id));
1474: FND_FILE.PUT_LINE(FND_FILE.LOG,'asset_id('||to_char(row_count)||'):= '||to_char(report_table(row_count).asset_id));
1475: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'asset_id('||to_char(row_count)||'):= '||to_char(report_table(row_count).asset_id));
1476: FND_FILE.PUT_LINE(FND_FILE.LOG,'report_table(1).begin_cost := '||to_char(report_table(row_count).begin_cost));
1477: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'report_table(1).begin_cost := '||to_char(report_table(row_count).begin_cost));
1478: FND_FILE.PUT_LINE(FND_FILE.LOG,'additions('||to_char(row_count)||'):= '||to_char(report_table(row_count).additions));
1479: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'additions('||to_char(row_count)||'):= '||to_char(report_table(row_count).additions));

Line 1477: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'report_table(1).begin_cost := '||to_char(report_table(row_count).begin_cost));

1473: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'category_id('||to_char(row_count)||'):= '||to_char(report_table(row_count).category_id));
1474: FND_FILE.PUT_LINE(FND_FILE.LOG,'asset_id('||to_char(row_count)||'):= '||to_char(report_table(row_count).asset_id));
1475: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'asset_id('||to_char(row_count)||'):= '||to_char(report_table(row_count).asset_id));
1476: FND_FILE.PUT_LINE(FND_FILE.LOG,'report_table(1).begin_cost := '||to_char(report_table(row_count).begin_cost));
1477: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'report_table(1).begin_cost := '||to_char(report_table(row_count).begin_cost));
1478: FND_FILE.PUT_LINE(FND_FILE.LOG,'additions('||to_char(row_count)||'):= '||to_char(report_table(row_count).additions));
1479: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'additions('||to_char(row_count)||'):= '||to_char(report_table(row_count).additions));
1480: FND_FILE.PUT_LINE(FND_FILE.LOG,'retirements('||to_char(row_count)||'):= '||to_char(report_table(row_count).retirements));
1481: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'retirements('||to_char(row_count)||'):= '||to_char(report_table(row_count).retirements));

Line 1479: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'additions('||to_char(row_count)||'):= '||to_char(report_table(row_count).additions));

1475: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'asset_id('||to_char(row_count)||'):= '||to_char(report_table(row_count).asset_id));
1476: FND_FILE.PUT_LINE(FND_FILE.LOG,'report_table(1).begin_cost := '||to_char(report_table(row_count).begin_cost));
1477: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'report_table(1).begin_cost := '||to_char(report_table(row_count).begin_cost));
1478: FND_FILE.PUT_LINE(FND_FILE.LOG,'additions('||to_char(row_count)||'):= '||to_char(report_table(row_count).additions));
1479: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'additions('||to_char(row_count)||'):= '||to_char(report_table(row_count).additions));
1480: FND_FILE.PUT_LINE(FND_FILE.LOG,'retirements('||to_char(row_count)||'):= '||to_char(report_table(row_count).retirements));
1481: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'retirements('||to_char(row_count)||'):= '||to_char(report_table(row_count).retirements));
1482: FND_FILE.PUT_LINE(FND_FILE.LOG,'transfers('||to_char(row_count)||'):= '||to_char(report_table(row_count).transfers));
1483: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'transfers('||to_char(row_count)||'):= '||to_char(report_table(row_count).transfers));

Line 1481: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'retirements('||to_char(row_count)||'):= '||to_char(report_table(row_count).retirements));

1477: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'report_table(1).begin_cost := '||to_char(report_table(row_count).begin_cost));
1478: FND_FILE.PUT_LINE(FND_FILE.LOG,'additions('||to_char(row_count)||'):= '||to_char(report_table(row_count).additions));
1479: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'additions('||to_char(row_count)||'):= '||to_char(report_table(row_count).additions));
1480: FND_FILE.PUT_LINE(FND_FILE.LOG,'retirements('||to_char(row_count)||'):= '||to_char(report_table(row_count).retirements));
1481: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'retirements('||to_char(row_count)||'):= '||to_char(report_table(row_count).retirements));
1482: FND_FILE.PUT_LINE(FND_FILE.LOG,'transfers('||to_char(row_count)||'):= '||to_char(report_table(row_count).transfers));
1483: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'transfers('||to_char(row_count)||'):= '||to_char(report_table(row_count).transfers));
1484: FND_FILE.PUT_LINE(FND_FILE.LOG,'end_cost('||to_char(row_count)||'):= '||to_char(report_table(row_count).end_cost));
1485: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'end_cost('||to_char(row_count)||'):= '||to_char(report_table(row_count).end_cost));

Line 1483: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'transfers('||to_char(row_count)||'):= '||to_char(report_table(row_count).transfers));

1479: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'additions('||to_char(row_count)||'):= '||to_char(report_table(row_count).additions));
1480: FND_FILE.PUT_LINE(FND_FILE.LOG,'retirements('||to_char(row_count)||'):= '||to_char(report_table(row_count).retirements));
1481: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'retirements('||to_char(row_count)||'):= '||to_char(report_table(row_count).retirements));
1482: FND_FILE.PUT_LINE(FND_FILE.LOG,'transfers('||to_char(row_count)||'):= '||to_char(report_table(row_count).transfers));
1483: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'transfers('||to_char(row_count)||'):= '||to_char(report_table(row_count).transfers));
1484: FND_FILE.PUT_LINE(FND_FILE.LOG,'end_cost('||to_char(row_count)||'):= '||to_char(report_table(row_count).end_cost));
1485: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'end_cost('||to_char(row_count)||'):= '||to_char(report_table(row_count).end_cost));
1486: FND_FILE.PUT_LINE(FND_FILE.LOG,'report_table(1).begin_accum_depr := '||to_char(report_table(row_count).begin_accum_depr));
1487: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'report_table(1).begin_accum_depr := '||to_char(report_table(row_count).begin_accum_depr));

Line 1485: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'end_cost('||to_char(row_count)||'):= '||to_char(report_table(row_count).end_cost));

1481: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'retirements('||to_char(row_count)||'):= '||to_char(report_table(row_count).retirements));
1482: FND_FILE.PUT_LINE(FND_FILE.LOG,'transfers('||to_char(row_count)||'):= '||to_char(report_table(row_count).transfers));
1483: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'transfers('||to_char(row_count)||'):= '||to_char(report_table(row_count).transfers));
1484: FND_FILE.PUT_LINE(FND_FILE.LOG,'end_cost('||to_char(row_count)||'):= '||to_char(report_table(row_count).end_cost));
1485: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'end_cost('||to_char(row_count)||'):= '||to_char(report_table(row_count).end_cost));
1486: FND_FILE.PUT_LINE(FND_FILE.LOG,'report_table(1).begin_accum_depr := '||to_char(report_table(row_count).begin_accum_depr));
1487: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'report_table(1).begin_accum_depr := '||to_char(report_table(row_count).begin_accum_depr));
1488: END IF;
1489:

Line 1487: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'report_table(1).begin_accum_depr := '||to_char(report_table(row_count).begin_accum_depr));

1483: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'transfers('||to_char(row_count)||'):= '||to_char(report_table(row_count).transfers));
1484: FND_FILE.PUT_LINE(FND_FILE.LOG,'end_cost('||to_char(row_count)||'):= '||to_char(report_table(row_count).end_cost));
1485: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'end_cost('||to_char(row_count)||'):= '||to_char(report_table(row_count).end_cost));
1486: FND_FILE.PUT_LINE(FND_FILE.LOG,'report_table(1).begin_accum_depr := '||to_char(report_table(row_count).begin_accum_depr));
1487: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'report_table(1).begin_accum_depr := '||to_char(report_table(row_count).begin_accum_depr));
1488: END IF;
1489:
1490: insert into JL_AR_FA_EXHIBIT_REPORT ( conc_request_id
1491: , exhibit_group_id

Line 1534: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',G_PKG_NAME||': '||l_api_name||'(-)');

1530: END IF;
1531: END LOOP;
1532:
1533: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1534: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',G_PKG_NAME||': '||l_api_name||'(-)');
1535: END IF;
1536:
1537: END insert_db_records;
1538:

Line 1621: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');

1617:
1618: BEGIN
1619:
1620: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1621: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
1622: END IF;
1623:
1624: l_exhibit_group_id := 0;
1625: l_category_id := 0;

Line 1641: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Start');

1637: delete from JL_AR_FA_EXHIBIT_REPORT;
1638:
1639: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1640: FND_FILE.PUT_LINE(FND_FILE.LOG,'Start');
1641: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Start');
1642: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_tax_book = '||p_tax_book);
1643: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'p_tax_book = '||p_tax_book);
1644: END IF;
1645:

Line 1643: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'p_tax_book = '||p_tax_book);

1639: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1640: FND_FILE.PUT_LINE(FND_FILE.LOG,'Start');
1641: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Start');
1642: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_tax_book = '||p_tax_book);
1643: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'p_tax_book = '||p_tax_book);
1644: END IF;
1645:
1646: IF p_mrcsobtype = 'R' THEN
1647: OPEN fetch_txns_for_rpt_period FOR

Line 1767: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Next Record**');

1763: OR fetch_txns_for_rpt_period%NOTFOUND IS NULL;
1764:
1765: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1766: FND_FILE.PUT_LINE(FND_FILE.LOG,'**Next Record****');
1767: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, '**Next Record****');
1768: FND_FILE.PUT_LINE(FND_FILE.LOG,'asset_txns_rec.category_id := '||to_char(asset_txns_rec.category_id));
1769: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'asset_txns_rec.category_id := '||to_char(asset_txns_rec.category_id));
1770: FND_FILE.PUT_LINE(FND_FILE.LOG,'asset_txns_rec.asset_id := '||to_char(asset_txns_rec.asset_id));
1771: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'asset_txns_rec.asset_id := '||to_char(asset_txns_rec.asset_id));

Line 1769: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'asset_txns_rec.category_id := '||to_char(asset_txns_rec.category_id));

1765: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1766: FND_FILE.PUT_LINE(FND_FILE.LOG,'**Next Record****');
1767: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, '**Next Record****');
1768: FND_FILE.PUT_LINE(FND_FILE.LOG,'asset_txns_rec.category_id := '||to_char(asset_txns_rec.category_id));
1769: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'asset_txns_rec.category_id := '||to_char(asset_txns_rec.category_id));
1770: FND_FILE.PUT_LINE(FND_FILE.LOG,'asset_txns_rec.asset_id := '||to_char(asset_txns_rec.asset_id));
1771: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'asset_txns_rec.asset_id := '||to_char(asset_txns_rec.asset_id));
1772: FND_FILE.PUT_LINE(FND_FILE.LOG,'asset_txns_rec.transaction_type_code := '||asset_txns_rec.transaction_type_code);
1773: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'asset_txns_rec.transaction_type_code := '||asset_txns_rec.transaction_type_code);

Line 1771: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'asset_txns_rec.asset_id := '||to_char(asset_txns_rec.asset_id));

1767: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, '**Next Record****');
1768: FND_FILE.PUT_LINE(FND_FILE.LOG,'asset_txns_rec.category_id := '||to_char(asset_txns_rec.category_id));
1769: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'asset_txns_rec.category_id := '||to_char(asset_txns_rec.category_id));
1770: FND_FILE.PUT_LINE(FND_FILE.LOG,'asset_txns_rec.asset_id := '||to_char(asset_txns_rec.asset_id));
1771: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'asset_txns_rec.asset_id := '||to_char(asset_txns_rec.asset_id));
1772: FND_FILE.PUT_LINE(FND_FILE.LOG,'asset_txns_rec.transaction_type_code := '||asset_txns_rec.transaction_type_code);
1773: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'asset_txns_rec.transaction_type_code := '||asset_txns_rec.transaction_type_code);
1774: FND_FILE.PUT_LINE(FND_FILE.LOG,'asset_txns_rec.period_counter := '||to_char(asset_txns_rec.period_counter));
1775: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'asset_txns_rec.period_counter := '||to_char(asset_txns_rec.period_counter));

Line 1773: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'asset_txns_rec.transaction_type_code := '||asset_txns_rec.transaction_type_code);

1769: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'asset_txns_rec.category_id := '||to_char(asset_txns_rec.category_id));
1770: FND_FILE.PUT_LINE(FND_FILE.LOG,'asset_txns_rec.asset_id := '||to_char(asset_txns_rec.asset_id));
1771: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'asset_txns_rec.asset_id := '||to_char(asset_txns_rec.asset_id));
1772: FND_FILE.PUT_LINE(FND_FILE.LOG,'asset_txns_rec.transaction_type_code := '||asset_txns_rec.transaction_type_code);
1773: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'asset_txns_rec.transaction_type_code := '||asset_txns_rec.transaction_type_code);
1774: FND_FILE.PUT_LINE(FND_FILE.LOG,'asset_txns_rec.period_counter := '||to_char(asset_txns_rec.period_counter));
1775: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'asset_txns_rec.period_counter := '||to_char(asset_txns_rec.period_counter));
1776: END IF;
1777:

Line 1775: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'asset_txns_rec.period_counter := '||to_char(asset_txns_rec.period_counter));

1771: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'asset_txns_rec.asset_id := '||to_char(asset_txns_rec.asset_id));
1772: FND_FILE.PUT_LINE(FND_FILE.LOG,'asset_txns_rec.transaction_type_code := '||asset_txns_rec.transaction_type_code);
1773: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'asset_txns_rec.transaction_type_code := '||asset_txns_rec.transaction_type_code);
1774: FND_FILE.PUT_LINE(FND_FILE.LOG,'asset_txns_rec.period_counter := '||to_char(asset_txns_rec.period_counter));
1775: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'asset_txns_rec.period_counter := '||to_char(asset_txns_rec.period_counter));
1776: END IF;
1777:
1778: IF ((asset_txns_rec.asset_id <> l_asset_id) OR (l_category_id <> asset_txns_rec.category_id)) THEN
1779: IF (asset_txns_rec.asset_id <> l_asset_id) THEN

Line 1803: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'l_historical_cost_beg_period := '||to_char(l_historical_cost_begin_period));

1799: );
1800:
1801: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1802: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_historical_cost_beg_period := '||to_char(l_historical_cost_begin_period));
1803: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'l_historical_cost_beg_period := '||to_char(l_historical_cost_begin_period));
1804: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_accum_depr_beg_period := '||to_char(l_accum_depr_begin_period));
1805: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'l_accum_depr_beg_period := '||to_char(l_accum_depr_begin_period));
1806: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_historical_cost_end_period := '||to_char(l_historical_cost_end_period));
1807: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'l_historical_cost_end_period := '||to_char(l_historical_cost_end_period));

Line 1805: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'l_accum_depr_beg_period := '||to_char(l_accum_depr_begin_period));

1801: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1802: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_historical_cost_beg_period := '||to_char(l_historical_cost_begin_period));
1803: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'l_historical_cost_beg_period := '||to_char(l_historical_cost_begin_period));
1804: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_accum_depr_beg_period := '||to_char(l_accum_depr_begin_period));
1805: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'l_accum_depr_beg_period := '||to_char(l_accum_depr_begin_period));
1806: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_historical_cost_end_period := '||to_char(l_historical_cost_end_period));
1807: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'l_historical_cost_end_period := '||to_char(l_historical_cost_end_period));
1808: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_adjusted_cost_end_period := '||to_char(l_adjusted_cost_end_period));
1809: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'l_adjusted_cost_end_period := '||to_char(l_adjusted_cost_end_period));

Line 1807: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'l_historical_cost_end_period := '||to_char(l_historical_cost_end_period));

1803: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'l_historical_cost_beg_period := '||to_char(l_historical_cost_begin_period));
1804: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_accum_depr_beg_period := '||to_char(l_accum_depr_begin_period));
1805: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'l_accum_depr_beg_period := '||to_char(l_accum_depr_begin_period));
1806: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_historical_cost_end_period := '||to_char(l_historical_cost_end_period));
1807: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'l_historical_cost_end_period := '||to_char(l_historical_cost_end_period));
1808: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_adjusted_cost_end_period := '||to_char(l_adjusted_cost_end_period));
1809: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'l_adjusted_cost_end_period := '||to_char(l_adjusted_cost_end_period));
1810: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_hist_accum_depr_end_period := '||to_char(l_hist_accum_depr_end_period));
1811: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'l_hist_accum_depr_end_period := '||to_char(l_hist_accum_depr_end_period));

Line 1809: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'l_adjusted_cost_end_period := '||to_char(l_adjusted_cost_end_period));

1805: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'l_accum_depr_beg_period := '||to_char(l_accum_depr_begin_period));
1806: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_historical_cost_end_period := '||to_char(l_historical_cost_end_period));
1807: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'l_historical_cost_end_period := '||to_char(l_historical_cost_end_period));
1808: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_adjusted_cost_end_period := '||to_char(l_adjusted_cost_end_period));
1809: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'l_adjusted_cost_end_period := '||to_char(l_adjusted_cost_end_period));
1810: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_hist_accum_depr_end_period := '||to_char(l_hist_accum_depr_end_period));
1811: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'l_hist_accum_depr_end_period := '||to_char(l_hist_accum_depr_end_period));
1812: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_adj_accum_depr_end_period := '||to_char(l_adj_accum_depr_end_period));
1813: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'l_adj_accum_depr_end_period := '||to_char(l_adj_accum_depr_end_period));

Line 1811: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'l_hist_accum_depr_end_period := '||to_char(l_hist_accum_depr_end_period));

1807: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'l_historical_cost_end_period := '||to_char(l_historical_cost_end_period));
1808: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_adjusted_cost_end_period := '||to_char(l_adjusted_cost_end_period));
1809: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'l_adjusted_cost_end_period := '||to_char(l_adjusted_cost_end_period));
1810: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_hist_accum_depr_end_period := '||to_char(l_hist_accum_depr_end_period));
1811: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'l_hist_accum_depr_end_period := '||to_char(l_hist_accum_depr_end_period));
1812: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_adj_accum_depr_end_period := '||to_char(l_adj_accum_depr_end_period));
1813: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'l_adj_accum_depr_end_period := '||to_char(l_adj_accum_depr_end_period));
1814: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_depr_rpt_period := '||to_char(l_depr_rpt_period));
1815: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'l_depr_rpt_period := '||to_char(l_depr_rpt_period));

Line 1813: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'l_adj_accum_depr_end_period := '||to_char(l_adj_accum_depr_end_period));

1809: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'l_adjusted_cost_end_period := '||to_char(l_adjusted_cost_end_period));
1810: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_hist_accum_depr_end_period := '||to_char(l_hist_accum_depr_end_period));
1811: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'l_hist_accum_depr_end_period := '||to_char(l_hist_accum_depr_end_period));
1812: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_adj_accum_depr_end_period := '||to_char(l_adj_accum_depr_end_period));
1813: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'l_adj_accum_depr_end_period := '||to_char(l_adj_accum_depr_end_period));
1814: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_depr_rpt_period := '||to_char(l_depr_rpt_period));
1815: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'l_depr_rpt_period := '||to_char(l_depr_rpt_period));
1816: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_cost_coefficient := '||to_char(l_cost_coefficient));
1817: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'l_cost_coefficient := '||to_char(l_cost_coefficient));

Line 1815: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'l_depr_rpt_period := '||to_char(l_depr_rpt_period));

1811: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'l_hist_accum_depr_end_period := '||to_char(l_hist_accum_depr_end_period));
1812: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_adj_accum_depr_end_period := '||to_char(l_adj_accum_depr_end_period));
1813: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'l_adj_accum_depr_end_period := '||to_char(l_adj_accum_depr_end_period));
1814: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_depr_rpt_period := '||to_char(l_depr_rpt_period));
1815: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'l_depr_rpt_period := '||to_char(l_depr_rpt_period));
1816: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_cost_coefficient := '||to_char(l_cost_coefficient));
1817: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'l_cost_coefficient := '||to_char(l_cost_coefficient));
1818: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_depr_coefficient := '||to_char(l_depr_coefficient));
1819: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'l_depr_coefficient := '||to_char(l_depr_coefficient));

Line 1817: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'l_cost_coefficient := '||to_char(l_cost_coefficient));

1813: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'l_adj_accum_depr_end_period := '||to_char(l_adj_accum_depr_end_period));
1814: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_depr_rpt_period := '||to_char(l_depr_rpt_period));
1815: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'l_depr_rpt_period := '||to_char(l_depr_rpt_period));
1816: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_cost_coefficient := '||to_char(l_cost_coefficient));
1817: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'l_cost_coefficient := '||to_char(l_cost_coefficient));
1818: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_depr_coefficient := '||to_char(l_depr_coefficient));
1819: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'l_depr_coefficient := '||to_char(l_depr_coefficient));
1820: END IF;
1821:

Line 1819: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'l_depr_coefficient := '||to_char(l_depr_coefficient));

1815: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'l_depr_rpt_period := '||to_char(l_depr_rpt_period));
1816: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_cost_coefficient := '||to_char(l_cost_coefficient));
1817: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'l_cost_coefficient := '||to_char(l_cost_coefficient));
1818: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_depr_coefficient := '||to_char(l_depr_coefficient));
1819: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'l_depr_coefficient := '||to_char(l_depr_coefficient));
1820: END IF;
1821:
1822: l_asset_id := asset_txns_rec.asset_id;
1823: i := 1;

Line 1829: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'asset_txns_rec.transaction_type_code := ' || asset_txns_rec.transaction_type_code );

1825: /* If the first transaction hit in this loop is RECLASS or CAPITALIZATION(ADDITION) then we need to create additional record for old category */
1826:
1827: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1828: FND_FILE.PUT_LINE(FND_FILE.LOG,'asset_txns_rec.transaction_type_code := ' || asset_txns_rec.transaction_type_code );
1829: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'asset_txns_rec.transaction_type_code := ' || asset_txns_rec.transaction_type_code );
1830: END IF;
1831:
1832: IF asset_txns_rec.transaction_type_code in ('RECLASS','CIP RECLASS','ADDITION') THEN
1833: get_old_category ( asset_txns_rec.asset_id

Line 1840: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'p_tax_book = '||p_tax_book);

1836: , l_old_category_id
1837: , j);
1838: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1839: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_tax_book = '||p_tax_book);
1840: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'p_tax_book = '||p_tax_book);
1841: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_old_category_id = '||to_char(l_old_category_id));
1842: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'l_old_category_id = '||to_char(l_old_category_id));
1843: END IF;
1844:

Line 1842: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'l_old_category_id = '||to_char(l_old_category_id));

1838: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1839: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_tax_book = '||p_tax_book);
1840: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'p_tax_book = '||p_tax_book);
1841: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_old_category_id = '||to_char(l_old_category_id));
1842: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'l_old_category_id = '||to_char(l_old_category_id));
1843: END IF;
1844:
1845: /* If old category returned is -1, then Transaction in consideration is Capitalization. */
1846: IF l_old_category_id = -1 THEN

Line 1904: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'report_table(1).begin_cost := '||to_char(report_table(i).begin_cost));

1900: report_table(i).begin_accum_depr := l_depr_coefficient * l_accum_depr_begin_period;
1901:
1902: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1903: FND_FILE.PUT_LINE(FND_FILE.LOG,'report_table(1).begin_cost := '||to_char(report_table(i).begin_cost));
1904: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'report_table(1).begin_cost := '||to_char(report_table(i).begin_cost));
1905: FND_FILE.PUT_LINE(FND_FILE.LOG,'report_table(1).begin_accum_depr := '||to_char(report_table(i).begin_accum_depr));
1906: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'report_table(1).begin_accum_depr := '||to_char(report_table(i).begin_accum_depr));
1907: END IF;
1908:

Line 1906: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'report_table(1).begin_accum_depr := '||to_char(report_table(i).begin_accum_depr));

1902: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1903: FND_FILE.PUT_LINE(FND_FILE.LOG,'report_table(1).begin_cost := '||to_char(report_table(i).begin_cost));
1904: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'report_table(1).begin_cost := '||to_char(report_table(i).begin_cost));
1905: FND_FILE.PUT_LINE(FND_FILE.LOG,'report_table(1).begin_accum_depr := '||to_char(report_table(i).begin_accum_depr));
1906: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'report_table(1).begin_accum_depr := '||to_char(report_table(i).begin_accum_depr));
1907: END IF;
1908:
1909: END IF;
1910: IF (asset_txns_rec.category_id <> l_category_id) THEN

Line 1968: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'l_old_category_id := ' || to_char(l_old_category_id));

1964: , j);
1965:
1966: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1967: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_old_category_id := ' || to_char(l_old_category_id));
1968: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'l_old_category_id := ' || to_char(l_old_category_id));
1969: END IF;
1970:
1971: IF l_old_category_id <> -1 THEN
1972:

Line 1975: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Regular Addition');

1971: IF l_old_category_id <> -1 THEN
1972:
1973: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1974: FND_FILE.PUT_LINE(FND_FILE.LOG,'Regular Addition');
1975: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Regular Addition');
1976: END IF;
1977:
1978: get_adjust_amount (asset_txns_rec.book_type_code
1979: , asset_txns_rec.asset_id

Line 1989: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'l_adjustment := ' || to_char(l_adjustment));

1985: );
1986:
1987: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1988: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_adjustment := ' || to_char(l_adjustment));
1989: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'l_adjustment := ' || to_char(l_adjustment));
1990: END IF;
1991:
1992: report_table(i).additions := report_table(i).additions + l_cost_coefficient * l_adjustment;
1993:

Line 1996: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'additions := ' || to_char(report_table(i).additions));

1992: report_table(i).additions := report_table(i).additions + l_cost_coefficient * l_adjustment;
1993:
1994: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1995: FND_FILE.PUT_LINE(FND_FILE.LOG,'additions := ' || to_char(report_table(i).additions));
1996: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'additions := ' || to_char(report_table(i).additions));
1997: END IF;
1998:
1999: END IF;
2000: ELSIF asset_txns_rec.transaction_type_code in ('CIP ADDITION') THEN

Line 2012: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'l_adjustment := ' || to_char(l_adjustment));

2008: );
2009:
2010: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2011: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_adjustment := ' || to_char(l_adjustment));
2012: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'l_adjustment := ' || to_char(l_adjustment));
2013: END IF;
2014:
2015: report_table(i).additions := report_table(i).additions + l_cost_coefficient * l_adjustment;
2016:

Line 2019: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'additions := ' || to_char(report_table(i).additions));

2015: report_table(i).additions := report_table(i).additions + l_cost_coefficient * l_adjustment;
2016:
2017: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2018: FND_FILE.PUT_LINE(FND_FILE.LOG,'additions := ' || to_char(report_table(i).additions));
2019: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'additions := ' || to_char(report_table(i).additions));
2020: END IF;
2021: END IF;
2022: END IF;
2023:

Line 2028: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'In FULL/PARTIAL RETIREMENT');

2024: IF asset_txns_rec.transaction_type_code in ('FULL RETIREMENT','PARTIAL RETIREMENT') THEN
2025:
2026: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2027: FND_FILE.PUT_LINE(FND_FILE.LOG,'In FULL/PARTIAL RETIREMENT');
2028: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'In FULL/PARTIAL RETIREMENT');
2029: END IF;
2030:
2031: /* Ignore the re-instated retirements */
2032: l_ignore_retirement := 'N';

Line 2068: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'l_adjustment := ' || to_char(l_adjustment));

2064: );
2065:
2066: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2067: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_adjustment := ' || to_char(l_adjustment));
2068: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'l_adjustment := ' || to_char(l_adjustment));
2069: END IF;
2070:
2071: report_table(i).retirements := report_table(i).retirements + l_cost_coefficient * l_adjustment;
2072:

Line 2075: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'retirements := ' || to_char(report_table(i).retirements));

2071: report_table(i).retirements := report_table(i).retirements + l_cost_coefficient * l_adjustment;
2072:
2073: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2074: FND_FILE.PUT_LINE(FND_FILE.LOG,'retirements := ' || to_char(report_table(i).retirements));
2075: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'retirements := ' || to_char(report_table(i).retirements));
2076: END IF;
2077:
2078: get_adjust_amount (asset_txns_rec.book_type_code
2079: , asset_txns_rec.asset_id

Line 2089: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'l_adjustment := ' || to_char(l_adjustment));

2085: );
2086:
2087: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2088: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_adjustment := ' || to_char(l_adjustment));
2089: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'l_adjustment := ' || to_char(l_adjustment));
2090: END IF;
2091:
2092: report_table(i).accum_depr_retirements := report_table(i).accum_depr_retirements - l_depr_coefficient * l_adjustment;
2093:

Line 2096: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'accum_depr_retirements := ' || to_char(report_table(i).accum_depr_retirements));

2092: report_table(i).accum_depr_retirements := report_table(i).accum_depr_retirements - l_depr_coefficient * l_adjustment;
2093:
2094: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2095: FND_FILE.PUT_LINE(FND_FILE.LOG,'accum_depr_retirements := ' || to_char(report_table(i).accum_depr_retirements));
2096: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'accum_depr_retirements := ' || to_char(report_table(i).accum_depr_retirements));
2097: END IF;
2098:
2099: END IF;
2100: END IF;

Line 2140: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'l_adjustment := ' || to_char(l_adjustment));

2136: );
2137:
2138: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2139: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_adjustment := ' || to_char(l_adjustment));
2140: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'l_adjustment := ' || to_char(l_adjustment));
2141: END IF;
2142:
2143: report_table(i).retirements := report_table(i).retirements - l_cost_coefficient * l_adjustment;
2144:

Line 2147: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'retirements := ' || to_char(report_table(i).retirements));

2143: report_table(i).retirements := report_table(i).retirements - l_cost_coefficient * l_adjustment;
2144:
2145: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2146: FND_FILE.PUT_LINE(FND_FILE.LOG,'retirements := ' || to_char(report_table(i).retirements));
2147: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'retirements := ' || to_char(report_table(i).retirements));
2148: END IF;
2149:
2150: get_adjust_amount (asset_txns_rec.book_type_code
2151: , asset_txns_rec.asset_id

Line 2161: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'l_adjustment := ' || to_char(l_adjustment));

2157: );
2158:
2159: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2160: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_adjustment := ' || to_char(l_adjustment));
2161: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'l_adjustment := ' || to_char(l_adjustment));
2162: END IF;
2163:
2164: report_table(i).accum_depr_retirements := report_table(i).accum_depr_retirements + l_depr_coefficient * l_adjustment;
2165:

Line 2168: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'accum_depr_retirements := ' || to_char(report_table(i).accum_depr_retirements));

2164: report_table(i).accum_depr_retirements := report_table(i).accum_depr_retirements + l_depr_coefficient * l_adjustment;
2165:
2166: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2167: FND_FILE.PUT_LINE(FND_FILE.LOG,'accum_depr_retirements := ' || to_char(report_table(i).accum_depr_retirements));
2168: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'accum_depr_retirements := ' || to_char(report_table(i).accum_depr_retirements));
2169: END IF;
2170:
2171: END IF;
2172: END IF;

Line 2181: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Capitalization of the asset');

2177: IF (asset_txns_rec.transaction_type_code = 'ADDITION' AND l_old_category_id = -1) THEN
2178:
2179: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2180: FND_FILE.PUT_LINE(FND_FILE.LOG,'Capitalization of the asset');
2181: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Capitalization of the asset');
2182: END IF;
2183:
2184: i := i + 1;
2185:

Line 2230: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'l_adjustment := ' || to_char(l_adjustment));

2226: );
2227:
2228: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2229: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_adjustment := ' || to_char(l_adjustment));
2230: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'l_adjustment := ' || to_char(l_adjustment));
2231: FND_FILE.PUT_LINE(FND_FILE.LOG,'j := ' || to_char(j));
2232: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'j := ' || to_char(j));
2233: FND_FILE.PUT_LINE(FND_FILE.LOG,'i := ' || to_char(i));
2234: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'i := ' || to_char(i));

Line 2232: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'j := ' || to_char(j));

2228: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2229: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_adjustment := ' || to_char(l_adjustment));
2230: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'l_adjustment := ' || to_char(l_adjustment));
2231: FND_FILE.PUT_LINE(FND_FILE.LOG,'j := ' || to_char(j));
2232: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'j := ' || to_char(j));
2233: FND_FILE.PUT_LINE(FND_FILE.LOG,'i := ' || to_char(i));
2234: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'i := ' || to_char(i));
2235: END IF;
2236:

Line 2234: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'i := ' || to_char(i));

2230: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'l_adjustment := ' || to_char(l_adjustment));
2231: FND_FILE.PUT_LINE(FND_FILE.LOG,'j := ' || to_char(j));
2232: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'j := ' || to_char(j));
2233: FND_FILE.PUT_LINE(FND_FILE.LOG,'i := ' || to_char(i));
2234: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'i := ' || to_char(i));
2235: END IF;
2236:
2237: report_table(i).transfers := report_table(i).transfers + l_cost_coefficient * l_adjustment;
2238:

Line 2241: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'transfers To := ' || to_char(report_table(i).transfers));

2237: report_table(i).transfers := report_table(i).transfers + l_cost_coefficient * l_adjustment;
2238:
2239: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2240: FND_FILE.PUT_LINE(FND_FILE.LOG,'transfers To := ' || to_char(report_table(i).transfers));
2241: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'transfers To := ' || to_char(report_table(i).transfers));
2242: END IF;
2243:
2244: report_table(j).transfers := report_table(j).transfers - l_cost_coefficient * l_adjustment;
2245:

Line 2248: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'transfers From := ' || to_char(report_table(j).transfers));

2244: report_table(j).transfers := report_table(j).transfers - l_cost_coefficient * l_adjustment;
2245:
2246: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2247: FND_FILE.PUT_LINE(FND_FILE.LOG,'transfers From := ' || to_char(report_table(j).transfers));
2248: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'transfers From := ' || to_char(report_table(j).transfers));
2249: END IF;
2250:
2251: IF report_table(i).begin_accum_depr > 0 THEN
2252: get_adjust_amount (asset_txns_rec.book_type_code

Line 2265: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'accum_depr_transfers := ' || to_char(report_table(i).accum_depr_transfers));

2261: report_table(i).accum_depr_transfers := report_table(i).accum_depr_transfers + (l_depr_coefficient * l_adjustment);
2262:
2263: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2264: FND_FILE.PUT_LINE(FND_FILE.LOG,'accum_depr_transfers := ' || to_char(report_table(i).accum_depr_transfers));
2265: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'accum_depr_transfers := ' || to_char(report_table(i).accum_depr_transfers));
2266: END IF;
2267:
2268: report_table(j).accum_depr_transfers := report_table(j).accum_depr_transfers - (l_depr_coefficient * l_adjustment);
2269: END IF;

Line 2274: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Capitalization of the asset ends');

2270: IF (asset_txns_rec.transaction_type_code = 'ADDITION' AND l_old_category_id = -1) THEN
2271:
2272: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2273: FND_FILE.PUT_LINE(FND_FILE.LOG,'Capitalization of the asset ends');
2274: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Capitalization of the asset ends');
2275: END IF;
2276:
2277: END IF;
2278: END IF;

Line 2304: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Bug 4956193: Adjustment calculated flag:'||l_adj_already_calculated_flag);

2300: END IF;
2301:
2302: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2303: FND_FILE.PUT_LINE(FND_FILE.LOG,'Bug 4956193: Adjustment calculated flag:'||l_adj_already_calculated_flag);
2304: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Bug 4956193: Adjustment calculated flag:'||l_adj_already_calculated_flag);
2305: END IF;
2306:
2307: -----------------------------------------------------------------------------
2308: -- Bug 4856193. Only if Adjustment has not been calculated yet, calculate it.

Line 2333: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'l_adjustment := ' || to_char(l_adjustment));

2329: END IF;
2330:
2331: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2332: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_adjustment := ' || to_char(l_adjustment));
2333: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'l_adjustment := ' || to_char(l_adjustment));
2334: END IF;
2335:
2336: IF l_adjustment > 0 THEN
2337: report_table(i).additions := report_table(i).additions + l_cost_coefficient * l_adjustment;

Line 2341: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Addition adjustments := ' || to_char(report_table(i).additions));

2337: report_table(i).additions := report_table(i).additions + l_cost_coefficient * l_adjustment;
2338:
2339: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2340: FND_FILE.PUT_LINE(FND_FILE.LOG,'Addition adjustments := ' || to_char(report_table(i).additions));
2341: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Addition adjustments := ' || to_char(report_table(i).additions));
2342: END IF;
2343:
2344: ELSE
2345: report_table(i).retirements := report_table(i).retirements - l_cost_coefficient * l_adjustment;

Line 2349: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Retirement adjustments := ' || to_char(report_table(i).retirements));

2345: report_table(i).retirements := report_table(i).retirements - l_cost_coefficient * l_adjustment;
2346:
2347: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2348: FND_FILE.PUT_LINE(FND_FILE.LOG,'Retirement adjustments := ' || to_char(report_table(i).retirements));
2349: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Retirement adjustments := ' || to_char(report_table(i).retirements));
2350: END IF;
2351:
2352: END IF;
2353:

Line 2365: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'l_adjustment := ' || to_char(l_adjustment));

2361: );
2362:
2363: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2364: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_adjustment := ' || to_char(l_adjustment));
2365: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'l_adjustment := ' || to_char(l_adjustment));
2366: END IF;
2367:
2368: IF l_adjustment < 0 THEN
2369: report_table(i).accum_depr_retirements := report_table(i).accum_depr_retirements + (l_depr_coefficient * l_adjustment);

Line 2373: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'accum_depr_retirements := ' || to_char(report_table(i).accum_depr_retirements));

2369: report_table(i).accum_depr_retirements := report_table(i).accum_depr_retirements + (l_depr_coefficient * l_adjustment);
2370:
2371: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2372: FND_FILE.PUT_LINE(FND_FILE.LOG,'accum_depr_retirements := ' || to_char(report_table(i).accum_depr_retirements));
2373: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'accum_depr_retirements := ' || to_char(report_table(i).accum_depr_retirements));
2374: END IF;
2375:
2376: END IF;
2377: END IF;

Line 2384: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',G_PKG_NAME||': '||l_api_name||'(-)');

2380: END LOOP;
2381: insert_db_records;
2382:
2383: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2384: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',G_PKG_NAME||': '||l_api_name||'(-)');
2385: END IF;
2386:
2387: END Populate_FA_Exhibit_Data;
2388: