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_DEPRN_ADJ_PKG dependencies on FND_LOG

Line 5: | FND Logging infrastructure |

1: PACKAGE BODY jl_zz_fa_deprn_adj_pkg AS
2: /* $Header: jlzzfdab.pls 120.8 2006/09/20 17:05:04 abuissa ship $ */
3:
4: /* ======================================================================*
5: | FND Logging infrastructure |
6: * ======================================================================*/
7: G_PKG_NAME CONSTANT VARCHAR2(30) := 'JL_ZZ_FA_DEPRN_ADJ_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_DEPRN_ADJ_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_DEPRN_ADJ_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_DEPRN_ADJ_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_DEPRN_ADJ_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_DEPRN_ADJ_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_DEPRN_ADJ_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_DEPRN_ADJ_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_DEPRN_ADJ_PKG.';
16:
17: /*+=========================================================================+
18: | PUBLIC PROCEDURE |

Line 111: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);

107:
108: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
109: x_char := 'Start Debugging';
110: fnd_file.put_line (FND_FILE.LOG, x_char);
111: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);
112: x_char := ' ';
113: fnd_file.put_line (FND_FILE.LOG, x_char);
114: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);
115: x_char := 'Country :'||x_country_code;

Line 114: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);

110: fnd_file.put_line (FND_FILE.LOG, x_char);
111: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);
112: x_char := ' ';
113: fnd_file.put_line (FND_FILE.LOG, x_char);
114: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);
115: x_char := 'Country :'||x_country_code;
116: fnd_file.put_line (FND_FILE.LOG, x_char);
117: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);
118: x_char := 'Precision :'||g_precision;

Line 117: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);

113: fnd_file.put_line (FND_FILE.LOG, x_char);
114: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);
115: x_char := 'Country :'||x_country_code;
116: fnd_file.put_line (FND_FILE.LOG, x_char);
117: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);
118: x_char := 'Precision :'||g_precision;
119: fnd_file.put_line (FND_FILE.LOG, x_char);
120: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);
121: END IF;

Line 120: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);

116: fnd_file.put_line (FND_FILE.LOG, x_char);
117: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);
118: x_char := 'Precision :'||g_precision;
119: fnd_file.put_line (FND_FILE.LOG, x_char);
120: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);
121: END IF;
122:
123: IF g_precision IS NULL OR g_precision = 0 THEN
124: g_precision := 38;

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

124: g_precision := 38;
125: END IF;
126:
127: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
128: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',G_PKG_NAME||': '||l_api_name||'(-)');
129: END IF;
130:
131: END get_who_columns;
132:

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

144:
145: BEGIN
146:
147: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
148: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
149: END IF;
150:
151:
152: g_step := 'BOOK INFO';

Line 157: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);

153:
154: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
155: x_char := ' ';
156: fnd_file.put_line (FND_FILE.LOG, x_char);
157: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);
158: x_char := 'Procedure get_details';
159: fnd_file.put_line (FND_FILE.LOG, x_char);
160: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);
161: END IF;

Line 160: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);

156: fnd_file.put_line (FND_FILE.LOG, x_char);
157: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);
158: x_char := 'Procedure get_details';
159: fnd_file.put_line (FND_FILE.LOG, x_char);
160: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);
161: END IF;
162:
163: ------------------------------------------------------------
164: -- Details for book given --

Line 347: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);

343: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
344:
345: x_char := 'Period counter :'||TO_CHAR(g_period_counter1);
346: fnd_file.put_line (FND_FILE.LOG, x_char);
347: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);
348: x_char := 'Period Name :'||g_period_name;
349: fnd_file.put_line (FND_FILE.LOG, x_char);
350: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);
351:

Line 350: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);

346: fnd_file.put_line (FND_FILE.LOG, x_char);
347: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);
348: x_char := 'Period Name :'||g_period_name;
349: fnd_file.put_line (FND_FILE.LOG, x_char);
350: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);
351:
352: IF x_country_code = 'CL' THEN
353: x_char := 'Period counter to get indexes :'||TO_CHAR(g_period_counter2);
354: fnd_file.put_line (FND_FILE.LOG, x_char);

Line 355: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);

351:
352: IF x_country_code = 'CL' THEN
353: x_char := 'Period counter to get indexes :'||TO_CHAR(g_period_counter2);
354: fnd_file.put_line (FND_FILE.LOG, x_char);
355: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);
356: END IF;
357:
358: x_char := ' ';
359: fnd_file.put_line (FND_FILE.LOG, x_char);

Line 360: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);

356: END IF;
357:
358: x_char := ' ';
359: fnd_file.put_line (FND_FILE.LOG, x_char);
360: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);
361: x_char := 'End of procedure get_details';
362: fnd_file.put_line (FND_FILE.LOG, x_char);
363: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);
364: END IF;

Line 363: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);

359: fnd_file.put_line (FND_FILE.LOG, x_char);
360: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);
361: x_char := 'End of procedure get_details';
362: fnd_file.put_line (FND_FILE.LOG, x_char);
363: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);
364: END IF;
365:
366: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
367: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',G_PKG_NAME||': '||l_api_name||'(-)');

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

363: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);
364: END IF;
365:
366: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
367: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',G_PKG_NAME||': '||l_api_name||'(-)');
368: END IF;
369:
370: END get_details;
371:

Line 473: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);

469: ------------------------------------------------------------
470: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
471: x_char := ' ';
472: fnd_file.put_line (FND_FILE.LOG, x_char);
473: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);
474: x_char := 'Procedure get_index_rate';
475: fnd_file.put_line (FND_FILE.LOG, x_char);
476: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);
477: x_char := ' ';

Line 476: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);

472: fnd_file.put_line (FND_FILE.LOG, x_char);
473: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);
474: x_char := 'Procedure get_index_rate';
475: fnd_file.put_line (FND_FILE.LOG, x_char);
476: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);
477: x_char := ' ';
478: fnd_file.put_line (FND_FILE.LOG, x_char);
479: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);
480: x_char := 'Getting index for Category :'||p_current_category;

Line 479: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);

475: fnd_file.put_line (FND_FILE.LOG, x_char);
476: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);
477: x_char := ' ';
478: fnd_file.put_line (FND_FILE.LOG, x_char);
479: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);
480: x_char := 'Getting index for Category :'||p_current_category;
481: fnd_file.put_line (FND_FILE.LOG, x_char);
482: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);
483: END IF;

Line 482: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);

478: fnd_file.put_line (FND_FILE.LOG, x_char);
479: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);
480: x_char := 'Getting index for Category :'||p_current_category;
481: fnd_file.put_line (FND_FILE.LOG, x_char);
482: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);
483: END IF;
484:
485:
486: SELECT b.price_index_id

Line 510: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);

506: g_step := '';
507: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
508: x_char := ' ';
509: fnd_file.put_line (FND_FILE.LOG, x_char);
510: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);
511: x_char := 'End of procedure get_index_rate';
512: fnd_file.put_line (FND_FILE.LOG, x_char);
513: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);
514: END IF;

Line 513: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);

509: fnd_file.put_line (FND_FILE.LOG, x_char);
510: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);
511: x_char := 'End of procedure get_index_rate';
512: fnd_file.put_line (FND_FILE.LOG, x_char);
513: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);
514: END IF;
515:
516: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
517: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',G_PKG_NAME||': '||l_api_name||'(-)');

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

513: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);
514: END IF;
515:
516: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
517: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',G_PKG_NAME||': '||l_api_name||'(-)');
518: END IF;
519:
520: END get_index_rate;
521:

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

564:
565: BEGIN
566:
567: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
568: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
569: END IF;
570:
571: g_step := '';
572:

Line 576: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);

572:
573: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
574: x_char := ' ';
575: fnd_file.put_line (FND_FILE.LOG, x_char);
576: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);
577: x_char := 'Procedure Current_period_retirements';
578: fnd_file.put_line (FND_FILE.LOG, x_char);
579: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);
580: END IF;

Line 579: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);

575: fnd_file.put_line (FND_FILE.LOG, x_char);
576: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);
577: x_char := 'Procedure Current_period_retirements';
578: fnd_file.put_line (FND_FILE.LOG, x_char);
579: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);
580: END IF;
581:
582:
583: FOR fa_ret_rec IN fa_ret

Line 616: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);

612:
613: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
614: x_char := 'Processing asset retired :'||TO_CHAR(fa_ret_rec.asset_id);
615: fnd_file.put_line (FND_FILE.LOG, x_char);
616: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);
617: END IF;
618:
619:
620: FOR fa_cat_rec IN fa_cat(fa_ret_rec.asset_id)

Line 645: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);

641:
642: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
643: x_char := 'YTD Depreciation and Current Period Depreciation are:'||TO_CHAR(l_accum_deprn)||','||TO_CHAR(l_deprn_amount);
644: fnd_file.put_line (FND_FILE.LOG, x_char);
645: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);
646: END IF;
647:
648:
649: INSERT INTO jl_zz_fa_retiremnt_adjs

Line 709: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);

705:
706: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
707: x_char := ' ';
708: fnd_file.put_line (FND_FILE.LOG, x_char);
709: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);
710: x_char := 'End of Procedure current_period_retirements';
711: fnd_file.put_line (FND_FILE.LOG, x_char);
712: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);
713: END IF;

Line 712: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);

708: fnd_file.put_line (FND_FILE.LOG, x_char);
709: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);
710: x_char := 'End of Procedure current_period_retirements';
711: fnd_file.put_line (FND_FILE.LOG, x_char);
712: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);
713: END IF;
714:
715: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
716: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',G_PKG_NAME||': '||l_api_name||'(-)');

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

712: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);
713: END IF;
714:
715: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
716: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',G_PKG_NAME||': '||l_api_name||'(-)');
717: END IF;
718:
719: END current_period_retirements;
720:

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

770: --
771: BEGIN
772:
773: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
774: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
775: END IF;
776:
777: g_step := '';
778:

Line 782: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);

778:
779: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
780: x_char := ' ';
781: fnd_file.put_line (FND_FILE.LOG, x_char);
782: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);
783: x_char := 'Procedure Current_period_reinstatements';
784: fnd_file.put_line (FND_FILE.LOG, x_char);
785: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);
786: END IF;

Line 785: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);

781: fnd_file.put_line (FND_FILE.LOG, x_char);
782: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);
783: x_char := 'Procedure Current_period_reinstatements';
784: fnd_file.put_line (FND_FILE.LOG, x_char);
785: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);
786: END IF;
787:
788: FOR fa_ret_rec IN fa_ret
789: LOOP

Line 819: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);

815:
816: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
817: x_char := 'Processing asset reinstated :'||TO_CHAR(fa_ret_rec.asset_id);
818: fnd_file.put_line (FND_FILE.LOG, x_char);
819: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);
820: END IF;
821:
822:
823: FOR fa_cat_rec IN fa_cat(fa_ret_rec.asset_id)

Line 838: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);

834:
835: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
836: x_char := 'Amount accumulated for this asset :'||TO_CHAR(l_deprn_amount);
837: fnd_file.put_line (FND_FILE.LOG, x_char);
838: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);
839: END IF;
840:
841:
842: INSERT INTO jl_zz_fa_retiremnt_adjs

Line 892: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);

888:
889: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
890: x_char := ' ';
891: fnd_file.put_line (FND_FILE.LOG, x_char);
892: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);
893: x_char := 'End of Procedure current_period_reistatements';
894: fnd_file.put_line (FND_FILE.LOG, x_char);
895: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);
896: END IF;

Line 895: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);

891: fnd_file.put_line (FND_FILE.LOG, x_char);
892: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);
893: x_char := 'End of Procedure current_period_reistatements';
894: fnd_file.put_line (FND_FILE.LOG, x_char);
895: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);
896: END IF;
897:
898: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
899: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',G_PKG_NAME||': '||l_api_name||'(-)');

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

895: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);
896: END IF;
897:
898: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
899: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',G_PKG_NAME||': '||l_api_name||'(-)');
900: END IF;
901:
902: END current_period_reinstatements;
903:

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

952:
953: BEGIN
954:
955: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
956: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
957: END IF;
958:
959: g_step := 'CURR DPRN INFO';
960:

Line 964: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);

960:
961: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
962: x_char := ' ';
963: fnd_file.put_line (FND_FILE.LOG, x_char);
964: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);
965: x_char := 'Procedure Adjust_previous_retirements';
966: fnd_file.put_line (FND_FILE.LOG, x_char);
967: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);
968: END IF;

Line 967: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);

963: fnd_file.put_line (FND_FILE.LOG, x_char);
964: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);
965: x_char := 'Procedure Adjust_previous_retirements';
966: fnd_file.put_line (FND_FILE.LOG, x_char);
967: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);
968: END IF;
969:
970:
971: FOR fa_adjst_rec IN fa_adjst

Line 1001: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);

997: ------------------------------------------------------------
998: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
999: x_char := ' ';
1000: fnd_file.put_line (FND_FILE.LOG, x_char);
1001: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);
1002: x_char := 'Before finding the DPIS : asset_id = '||TO_CHAR(fa_adjst_rec.asset_id);
1003: fnd_file.put_line (FND_FILE.LOG, x_char);
1004: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);
1005: x_char := 'retirement_id = '||TO_CHAR(fa_adjst_rec.retirement_id);

Line 1004: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);

1000: fnd_file.put_line (FND_FILE.LOG, x_char);
1001: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);
1002: x_char := 'Before finding the DPIS : asset_id = '||TO_CHAR(fa_adjst_rec.asset_id);
1003: fnd_file.put_line (FND_FILE.LOG, x_char);
1004: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);
1005: x_char := 'retirement_id = '||TO_CHAR(fa_adjst_rec.retirement_id);
1006: fnd_file.put_line (FND_FILE.LOG, x_char);
1007: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);
1008: x_char := 'book_type_code = '||p_book_type_code;

Line 1007: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);

1003: fnd_file.put_line (FND_FILE.LOG, x_char);
1004: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);
1005: x_char := 'retirement_id = '||TO_CHAR(fa_adjst_rec.retirement_id);
1006: fnd_file.put_line (FND_FILE.LOG, x_char);
1007: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);
1008: x_char := 'book_type_code = '||p_book_type_code;
1009: fnd_file.put_line (FND_FILE.LOG, x_char);
1010: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);
1011: END IF;

Line 1010: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);

1006: fnd_file.put_line (FND_FILE.LOG, x_char);
1007: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);
1008: x_char := 'book_type_code = '||p_book_type_code;
1009: fnd_file.put_line (FND_FILE.LOG, x_char);
1010: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);
1011: END IF;
1012:
1013: SELECT b.date_placed_in_service
1014: INTO cur_date_placed_in_service

Line 1046: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);

1042:
1043: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1044: x_char := 'Processing asset :'||TO_CHAR(fa_adjst_rec.asset_id);
1045: fnd_file.put_line (FND_FILE.LOG, x_char);
1046: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);
1047: x_char := 'Accumulated depreciation for this asset :'||TO_CHAR(l_adj_accum_deprn);
1048: fnd_file.put_line (FND_FILE.LOG, x_char);
1049: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);
1050: END IF;

Line 1049: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);

1045: fnd_file.put_line (FND_FILE.LOG, x_char);
1046: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);
1047: x_char := 'Accumulated depreciation for this asset :'||TO_CHAR(l_adj_accum_deprn);
1048: fnd_file.put_line (FND_FILE.LOG, x_char);
1049: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);
1050: END IF;
1051:
1052:
1053: INSERT INTO jl_zz_fa_retiremnt_adjs

Line 1119: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);

1115:
1116: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1117: x_char := ' ';
1118: fnd_file.put_line (FND_FILE.LOG, x_char);
1119: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);
1120: x_char := 'End of Procedure adjust_previous_retirements';
1121: fnd_file.put_line (FND_FILE.LOG, x_char);
1122: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);
1123: END IF;

Line 1122: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);

1118: fnd_file.put_line (FND_FILE.LOG, x_char);
1119: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);
1120: x_char := 'End of Procedure adjust_previous_retirements';
1121: fnd_file.put_line (FND_FILE.LOG, x_char);
1122: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);
1123: END IF;
1124:
1125: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1126: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',G_PKG_NAME||': '||l_api_name||'(-)');

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

1122: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);
1123: END IF;
1124:
1125: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1126: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',G_PKG_NAME||': '||l_api_name||'(-)');
1127: END IF;
1128:
1129: END adjust_previous_retirements;
1130:

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

1166:
1167: BEGIN
1168:
1169: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1170: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
1171: END IF;
1172:
1173: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1174: x_char := ' ';

Line 1176: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);

1172:
1173: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1174: x_char := ' ';
1175: fnd_file.put_line (FND_FILE.LOG, x_char);
1176: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);
1177: x_char := 'Procedure Insert_retiremnt_jes';
1178: fnd_file.put_line (FND_FILE.LOG, x_char);
1179: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);
1180: END IF;

Line 1179: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);

1175: fnd_file.put_line (FND_FILE.LOG, x_char);
1176: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);
1177: x_char := 'Procedure Insert_retiremnt_jes';
1178: fnd_file.put_line (FND_FILE.LOG, x_char);
1179: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);
1180: END IF;
1181:
1182: FOR fa_adjst_rec IN fa_adjst
1183: LOOP

Line 1229: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);

1225:
1226: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1227: x_char := ' ';
1228: fnd_file.put_line (FND_FILE.LOG, x_char);
1229: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);
1230: x_char := 'End of Procedure insert_retiremnt_jes';
1231: fnd_file.put_line (FND_FILE.LOG, x_char);
1232: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);
1233: END IF;

Line 1232: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);

1228: fnd_file.put_line (FND_FILE.LOG, x_char);
1229: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);
1230: x_char := 'End of Procedure insert_retiremnt_jes';
1231: fnd_file.put_line (FND_FILE.LOG, x_char);
1232: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);
1233: END IF;
1234:
1235: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1236: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',G_PKG_NAME||': '||l_api_name||'(-)');

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

1232: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);
1233: END IF;
1234:
1235: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1236: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',G_PKG_NAME||': '||l_api_name||'(-)');
1237: END IF;
1238:
1239: END insert_retiremnt_jes;
1240:

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

1257:
1258: BEGIN
1259:
1260: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1261: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'(+)');
1262: END IF;
1263:
1264: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1265: x_char := ' ';

Line 1267: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);

1263:
1264: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1265: x_char := ' ';
1266: fnd_file.put_line (FND_FILE.LOG, x_char);
1267: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);
1268: x_char := 'Procedure insert_gl_interface';
1269: fnd_file.put_line (FND_FILE.LOG, x_char);
1270: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);
1271: END IF;

Line 1270: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);

1266: fnd_file.put_line (FND_FILE.LOG, x_char);
1267: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);
1268: x_char := 'Procedure insert_gl_interface';
1269: fnd_file.put_line (FND_FILE.LOG, x_char);
1270: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);
1271: END IF;
1272:
1273:
1274: SELECT gl_interface_control_s.nextval

Line 1326: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);

1322:
1323: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1324: x_char := ' ';
1325: fnd_file.put_line (FND_FILE.LOG, x_char);
1326: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);
1327: x_char := 'End of procedure insert_gl_interface';
1328: fnd_file.put_line (FND_FILE.LOG, x_char);
1329: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);
1330: END IF;

Line 1329: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);

1325: fnd_file.put_line (FND_FILE.LOG, x_char);
1326: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);
1327: x_char := 'End of procedure insert_gl_interface';
1328: fnd_file.put_line (FND_FILE.LOG, x_char);
1329: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);
1330: END IF;
1331:
1332: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1333: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',G_PKG_NAME||': '||l_api_name||'(-)');

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

1329: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);
1330: END IF;
1331:
1332: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1333: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',G_PKG_NAME||': '||l_api_name||'(-)');
1334: END IF;
1335:
1336: END insert_gl_interface;
1337: