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.

[Home] [Help]

APPS.JA_CN_PS_FA_EXP_PKG dependencies on FND_LOG

Line 62: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

58: , pn_coa_id IN NUMBER
59: )
60: AS
61: lv_procedure_name VARCHAR2(40) := 'Export_Fixed_Assets';
62: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
63: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
64: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
65: lv_fa_element VARCHAR2(1000);
66: lv_bsv_flag VARCHAR2(10);

Line 63: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

59: )
60: AS
61: lv_procedure_name VARCHAR2(40) := 'Export_Fixed_Assets';
62: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
63: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
64: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
65: lv_fa_element VARCHAR2(1000);
66: lv_bsv_flag VARCHAR2(10);
67:

Line 64: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;

60: AS
61: lv_procedure_name VARCHAR2(40) := 'Export_Fixed_Assets';
62: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
63: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
64: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
65: lv_fa_element VARCHAR2(1000);
66: lv_bsv_flag VARCHAR2(10);
67:
68: BEGIN

Line 72: FND_LOG.STRING( ln_proc_level

68: BEGIN
69: --logging for debug
70: IF (ln_proc_level >= ln_dbg_level)
71: THEN
72: FND_LOG.STRING( ln_proc_level
73: , GV_MODULE_PREFIX || '.' || lv_procedure_name || '.begin'
74: , 'Enter procedure');
75:
76: -- logging the parameters

Line 77: FND_LOG.STRING( ln_proc_level

73: , GV_MODULE_PREFIX || '.' || lv_procedure_name || '.begin'
74: , 'Enter procedure');
75:
76: -- logging the parameters
77: FND_LOG.STRING( ln_proc_level
78: , lv_procedure_name || '.parameters'
79: , 'pn_legal_entity_id=' || pn_legal_entity_id || ','
80: || 'pn_ledger_id=' || pn_ledger_id || ','
81: || 'pv_accounting_year=' || pv_accounting_year || ','

Line 259: FND_LOG.STRING( ln_proc_level

255: );
256: --logging for debug
257: IF (ln_proc_level >= ln_dbg_level)
258: THEN
259: FND_LOG.STRING( ln_proc_level
260: , GV_MODULE_PREFIX || '.' || lv_procedure_name || '.end'
261: , 'Exit procedure');
262: END IF; -- (ln_proc_level>=ln_dbg_level)
263:

Line 266: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

262: END IF; -- (ln_proc_level>=ln_dbg_level)
263:
264: EXCEPTION
265: WHEN OTHERS THEN
266: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
267: THEN
268: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
269: , GV_MODULE_PREFIX || '.' || lv_procedure_name
270: || '.Other_Exception '

Line 268: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED

264: EXCEPTION
265: WHEN OTHERS THEN
266: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
267: THEN
268: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
269: , GV_MODULE_PREFIX || '.' || lv_procedure_name
270: || '.Other_Exception '
271: , SQLCODE || SQLERRM);
272: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

Line 272: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

268: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
269: , GV_MODULE_PREFIX || '.' || lv_procedure_name
270: || '.Other_Exception '
271: , SQLCODE || SQLERRM);
272: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
273: FND_FILE.put_line( FND_FILE.log
274: , lv_procedure_name || SQLCODE || SQLERRM);
275: pv_retcode := 2;
276: END Export_Fixed_Asset;

Line 320: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

316: )
317: AS
318: NO_DATA EXCEPTION;
319: lv_procedure_name VARCHAR2(40) := 'Submit_Request';
320: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
321: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
322: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
323: lv_error_status BOOLEAN;
324: lv_period_from VARCHAR2(100);

Line 321: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

317: AS
318: NO_DATA EXCEPTION;
319: lv_procedure_name VARCHAR2(40) := 'Submit_Request';
320: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
321: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
322: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
323: lv_error_status BOOLEAN;
324: lv_period_from VARCHAR2(100);
325: lv_period_to VARCHAR2(100);

Line 322: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;

318: NO_DATA EXCEPTION;
319: lv_procedure_name VARCHAR2(40) := 'Submit_Request';
320: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
321: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
322: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
323: lv_error_status BOOLEAN;
324: lv_period_from VARCHAR2(100);
325: lv_period_to VARCHAR2(100);
326:

Line 348: FND_LOG.STRING( ln_proc_level

344: BEGIN
345: --logging for debug
346: IF (ln_proc_level >= ln_dbg_level)
347: THEN
348: FND_LOG.STRING( ln_proc_level
349: , GV_MODULE_PREFIX || '.' || lv_procedure_name || '.begin'
350: , 'Enter procedure');
351:
352: -- logging the parameters

Line 353: FND_LOG.STRING( ln_proc_level

349: , GV_MODULE_PREFIX || '.' || lv_procedure_name || '.begin'
350: , 'Enter procedure');
351:
352: -- logging the parameters
353: FND_LOG.STRING( ln_proc_level
354: , lv_procedure_name || '.parameters'
355: , 'pn_legal_entity_id=' || pn_legal_entity_id || ','
356: || 'pn_ledger_id=' || pn_ledger_id || ','
357: || 'pv_accounting_year=' || pv_accounting_year || ','

Line 520: FND_LOG.STRING( ln_statement_level

516: );
517: --logging the variables
518: IF (ln_statement_level >= ln_dbg_level)
519: THEN
520: FND_LOG.STRING( ln_statement_level
521: , lv_procedure_name
522: , 'lv_output_file_name:' || lv_output_file_name);
523: END IF; --(ln_statement_level >= ln_dbg_level)
524: FND_FILE.put_line( FND_FILE.log

Line 587: FND_LOG.STRING( ln_proc_level

583: END IF; --lv_error_flag='W'
584:
585: --logging for debug
586: IF (ln_proc_level >= ln_dbg_level) THEN
587: FND_LOG.STRING( ln_proc_level
588: , GV_MODULE_PREFIX || '.' || lv_procedure_name || '.end'
589: , 'Exit procedure');
590: END IF; -- (ln_proc_level>=ln_dbg_level)
591:

Line 595: FND_LOG.STRING( ln_proc_level

591:
592: --logging for debug
593: IF (ln_proc_level >= ln_dbg_level)
594: THEN
595: FND_LOG.STRING( ln_proc_level
596: , GV_MODULE_PREFIX || '.' || lv_procedure_name || '.end'
597: , 'Exit procedure');
598: END IF; -- (ln_proc_level>=ln_dbg_level)
599:

Line 602: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

598: END IF; -- (ln_proc_level>=ln_dbg_level)
599:
600: EXCEPTION
601: WHEN OTHERS THEN
602: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
603: THEN
604: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
605: , GV_MODULE_PREFIX || '.' || lv_procedure_name
606: || '.Other_Exception '

Line 604: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED

600: EXCEPTION
601: WHEN OTHERS THEN
602: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
603: THEN
604: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
605: , GV_MODULE_PREFIX || '.' || lv_procedure_name
606: || '.Other_Exception '
607: , SQLCODE || SQLERRM);
608: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

Line 608: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

604: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
605: , GV_MODULE_PREFIX || '.' || lv_procedure_name
606: || '.Other_Exception '
607: , SQLCODE || SQLERRM);
608: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
609: FND_FILE.put_line( FND_FILE.log
610: , lv_procedure_name || SQLCODE || SQLERRM);
611: END Submit_Request;
612: --==========================================================================

Line 637: ln_dbg_level NUMBER := FND_LOG.g_current_runtime_level;

633: RETURN BOOLEAN
634: IS
635: lv_false_flag VARCHAR2(1) := 'N';
636: lv_error_msg VARCHAR2(2000);
637: ln_dbg_level NUMBER := FND_LOG.g_current_runtime_level;
638: ln_proc_level NUMBER := FND_LOG.Level_Procedure;
639: lv_proc_name VARCHAR2(100) := 'Check_kff';
640: ln_row_count NUMBER := 0;
641:

Line 638: ln_proc_level NUMBER := FND_LOG.Level_Procedure;

634: IS
635: lv_false_flag VARCHAR2(1) := 'N';
636: lv_error_msg VARCHAR2(2000);
637: ln_dbg_level NUMBER := FND_LOG.g_current_runtime_level;
638: ln_proc_level NUMBER := FND_LOG.Level_Procedure;
639: lv_proc_name VARCHAR2(100) := 'Check_kff';
640: ln_row_count NUMBER := 0;
641:
642: CURSOR kff_cur

Line 656: Fnd_Log.STRING(ln_proc_level,

652:
653: BEGIN
654: --log for debug
655: IF (ln_proc_level >= ln_dbg_level) THEN
656: Fnd_Log.STRING(ln_proc_level,
657: GV_MODULE_PREFIX || '.' || lv_proc_name || '.begin',
658: 'Enter function');
659: END IF; --(l_proc_level >= l_dbg_level)
660:

Line 687: Fnd_Log.STRING(ln_proc_level,

683:
684: IF lv_false_flag = 'N' THEN
685: --log for debug
686: IF (ln_proc_level >= ln_dbg_level) THEN
687: Fnd_Log.STRING(ln_proc_level,
688: GV_MODULE_PREFIX || '.' || lv_proc_name || '.end',
689: 'Exit function');
690: END IF; --( ln_proc_level >= ln_dbg_level )
691: RETURN TRUE;

Line 695: Fnd_Log.STRING(ln_proc_level,

691: RETURN TRUE;
692: ELSE
693: --log for debug
694: IF (ln_proc_level >= ln_dbg_level) THEN
695: Fnd_Log.STRING(ln_proc_level,
696: GV_MODULE_PREFIX || '.' || lv_proc_name || '.end',
697: 'Exit function');
698: END IF; --( ln_proc_level >= ln_dbg_level )
699: RETURN FALSE;

Line 706: Fnd_Log.STRING(ln_proc_level,

702: EXCEPTION
703:
704: WHEN OTHERS THEN
705: IF (ln_proc_level >= ln_dbg_level) THEN
706: Fnd_Log.STRING(ln_proc_level,
707: GV_MODULE_PREFIX || '.' || lv_proc_name ||
708: '. Other_Exception ',
709: SQLCODE || ':' || SQLERRM);
710: END IF; --(ln_proc_level >= ln_dbg_level)

Line 736: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

732: FUNCTION Check_Depreciation_Assignment(pn_legal_entity_id NUMBER)
733: RETURN BOOLEAN IS
734: ln_row_count NUMBER := 0;
735: lv_Error_Msg VARCHAR2(2000);
736: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
737: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
738: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
739: lv_procedure_name VARCHAR2(40) := 'Check_Depreciation_Assignment';
740:

Line 737: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

733: RETURN BOOLEAN IS
734: ln_row_count NUMBER := 0;
735: lv_Error_Msg VARCHAR2(2000);
736: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
737: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
738: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
739: lv_procedure_name VARCHAR2(40) := 'Check_Depreciation_Assignment';
740:
741: BEGIN

Line 738: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;

734: ln_row_count NUMBER := 0;
735: lv_Error_Msg VARCHAR2(2000);
736: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
737: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
738: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
739: lv_procedure_name VARCHAR2(40) := 'Check_Depreciation_Assignment';
740:
741: BEGIN
742:

Line 744: FND_LOG.STRING( ln_proc_level

740:
741: BEGIN
742:
743: IF (ln_proc_level >= ln_dbg_level) THEN
744: FND_LOG.STRING( ln_proc_level
745: , GV_MODULE_PREFIX || '.' || lv_procedure_name
746: || '.begin'
747: , 'Enter procedure');
748: -- logging the parameters

Line 749: FND_LOG.STRING( ln_proc_level

745: , GV_MODULE_PREFIX || '.' || lv_procedure_name
746: || '.begin'
747: , 'Enter procedure');
748: -- logging the parameters
749: FND_LOG.STRING( ln_proc_level
750: , lv_procedure_name || '.parameters'
751: , 'pn_legal_entity_id=' || pn_legal_entity_id);
752: END IF; --l_proc_level>=l_dbg_level
753:

Line 771: FND_LOG.STRING( ln_proc_level

767: Fnd_File.Put_Line( Fnd_File.Output
768: , lv_Error_Msg);
769: --logging for debug
770: IF (ln_proc_level >= ln_dbg_level) THEN
771: FND_LOG.STRING( ln_proc_level
772: ,GV_MODULE_PREFIX || '.' || lv_procedure_name
773: || '.end'
774: , 'Exit procedure');
775: END IF; -- (ln_proc_level>=ln_dbg_level)

Line 780: FND_LOG.STRING( ln_proc_level

776: RETURN FALSE;
777: ELSE
778: --logging for debug
779: IF (ln_proc_level >= ln_dbg_level) THEN
780: FND_LOG.STRING( ln_proc_level
781: , GV_MODULE_PREFIX || '.' || lv_procedure_name
782: || '.end'
783: , 'Exit procedure');
784: END IF; -- (ln_proc_level>=ln_dbg_level)

Line 790: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

786: END IF; --(IF(ln_row_count = 0))
787:
788: EXCEPTION
789: WHEN OTHERS THEN
790: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
791: THEN
792: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
793: , GV_MODULE_PREFIX || '.' || lv_procedure_name
794: || '.Other_Exception '

Line 792: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED

788: EXCEPTION
789: WHEN OTHERS THEN
790: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
791: THEN
792: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
793: , GV_MODULE_PREFIX || '.' || lv_procedure_name
794: || '.Other_Exception '
795: , SQLCODE || SQLERRM);
796: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

Line 796: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

792: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
793: , GV_MODULE_PREFIX || '.' || lv_procedure_name
794: || '.Other_Exception '
795: , SQLCODE || SQLERRM);
796: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
797: FND_FILE.put_line( FND_FILE.log
798: , lv_procedure_name || SQLCODE || SQLERRM);
799:
800: END Check_Depreciation_Assignment;