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

Line 65: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

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

Line 66: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

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

Line 67: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;

63: IS
64: lv_procedure_name VARCHAR2(40) := 'Export_Fixed_Assets';
65: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
66: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
67: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
68: lv_fa_element VARCHAR2(1000);
69: lv_bsv_flag VARCHAR2(10);
70: BEGIN
71: --logging for debug

Line 74: FND_LOG.STRING( ln_proc_level

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

Line 81: FND_LOG.STRING(ln_proc_level,

77: , 'Enter procedure'
78: );
79:
80: -- logging the parameters
81: FND_LOG.STRING(ln_proc_level,
82: lv_procedure_name ||
83: '.parameters',
84: 'pn_legal_entity_id=' || pn_legal_entity_id|| ',' ||
85: 'pn_ledger_id=' || pn_ledger_id || ',' ||

Line 224: FND_LOG.STRING( ln_proc_level

220:
221: --logging for debug
222: IF (ln_proc_level >= ln_dbg_level)
223: THEN
224: FND_LOG.STRING( ln_proc_level
225: , GV_MODULE_PREFIX || '.' || lv_procedure_name || '.end',
226: 'Exit procedure');
227: END IF; -- (ln_proc_level>=ln_dbg_level)
228: EXCEPTION

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

226: 'Exit procedure');
227: END IF; -- (ln_proc_level>=ln_dbg_level)
228: EXCEPTION
229: WHEN OTHERS THEN
230: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
231: THEN
232: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
233: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
234: '.Other_Exception ',

Line 232: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

228: EXCEPTION
229: WHEN OTHERS THEN
230: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
231: THEN
232: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
233: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
234: '.Other_Exception ',
235: SQLCODE || SQLERRM);
236: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

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

232: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
233: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
234: '.Other_Exception ',
235: SQLCODE || SQLERRM);
236: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
237: FND_FILE.put_line(FND_FILE.log, lv_procedure_name || SQLCODE || SQLERRM);
238: pv_retcode := 2;
239: END Export_Fixed_Assets;
240:

Line 286: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

282: IS
283: NO_DATA EXCEPTION;
284:
285: lv_procedure_name VARCHAR2(40) := 'Submit_Request';
286: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
287: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
288: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
289: lv_error_status BOOLEAN;
290: lv_period_from VARCHAR2(100);

Line 287: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

283: NO_DATA EXCEPTION;
284:
285: lv_procedure_name VARCHAR2(40) := 'Submit_Request';
286: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
287: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
288: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
289: lv_error_status BOOLEAN;
290: lv_period_from VARCHAR2(100);
291: lv_period_to VARCHAR2(100);

Line 288: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;

284:
285: lv_procedure_name VARCHAR2(40) := 'Submit_Request';
286: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
287: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
288: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
289: lv_error_status BOOLEAN;
290: lv_period_from VARCHAR2(100);
291: lv_period_to VARCHAR2(100);
292:

Line 317: FND_LOG.STRING( ln_proc_level

313: BEGIN
314: --logging for debug
315: IF (ln_proc_level>=ln_dbg_level)
316: THEN
317: FND_LOG.STRING( ln_proc_level
318: , GV_MODULE_PREFIX ||'.' || lv_procedure_name ||
319: '.begin'
320: , 'Enter procedure'
321: );

Line 324: FND_LOG.STRING(ln_proc_level,

320: , 'Enter procedure'
321: );
322:
323: -- logging the parameters
324: FND_LOG.STRING(ln_proc_level,
325: lv_procedure_name ||
326: '.parameters',
327: 'pn_legal_entity_id=' || pn_legal_entity_id|| ',' ||
328: 'pn_ledger_id=' || pn_ledger_id || ',' ||

Line 486: FND_LOG.STRING(ln_statement_level,

482: );
483: --logging the variables
484: IF (ln_statement_level >= ln_dbg_level)
485: THEN
486: FND_LOG.STRING(ln_statement_level,
487: lv_procedure_name,
488: 'lv_output_file_name:' || lv_output_file_name);
489: END IF; --(ln_statement_level >= ln_dbg_level)
490: FND_FILE.put_line(FND_FILE.log, lv_procedure_name ||

Line 552: FND_LOG.STRING( ln_proc_level

548:
549: --logging for debug
550: IF (ln_proc_level >= ln_dbg_level)
551: THEN
552: FND_LOG.STRING( ln_proc_level
553: ,GV_MODULE_PREFIX || '.' || lv_procedure_name || '.end',
554: 'Exit procedure');
555: END IF; -- (ln_proc_level>=ln_dbg_level)
556:

Line 560: FND_LOG.STRING( ln_proc_level

556:
557: --logging for debug
558: IF (ln_proc_level>=ln_dbg_level)
559: THEN
560: FND_LOG.STRING( ln_proc_level
561: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.end'
562: , 'Exit procedure'
563: );
564: END IF; -- (ln_proc_level>=ln_dbg_level)

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

564: END IF; -- (ln_proc_level>=ln_dbg_level)
565:
566: EXCEPTION
567: WHEN OTHERS THEN
568: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
569: THEN
570: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
571: , GV_MODULE_PREFIX || '.' || lv_procedure_name ||
572: '.Other_Exception ',

Line 570: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED

566: EXCEPTION
567: WHEN OTHERS THEN
568: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
569: THEN
570: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
571: , GV_MODULE_PREFIX || '.' || lv_procedure_name ||
572: '.Other_Exception ',
573: SQLCODE || SQLERRM);
574: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

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

570: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
571: , GV_MODULE_PREFIX || '.' || lv_procedure_name ||
572: '.Other_Exception ',
573: SQLCODE || SQLERRM);
574: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
575: FND_FILE.put_line(FND_FILE.log, lv_procedure_name || SQLCODE || SQLERRM);
576:
577: END Submit_Request;
578:

Line 602: ln_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;

598: RETURN BOOLEAN
599: IS
600: lv_False_Flag VARCHAR2(1) := 'N';
601: lv_Error_Msg VARCHAR2(2000);
602: ln_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
603: ln_Proc_Level NUMBER := Fnd_Log.Level_Procedure;
604: lv_Proc_Name VARCHAR2(100) := 'Check_kff';
605: ln_row_count NUMBER := 0;
606:

Line 603: ln_Proc_Level NUMBER := Fnd_Log.Level_Procedure;

599: IS
600: lv_False_Flag VARCHAR2(1) := 'N';
601: lv_Error_Msg VARCHAR2(2000);
602: ln_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
603: ln_Proc_Level NUMBER := Fnd_Log.Level_Procedure;
604: lv_Proc_Name VARCHAR2(100) := 'Check_kff';
605: ln_row_count NUMBER := 0;
606:
607: CURSOR kff_cur(ln_coa_id NUMBER) IS

Line 617: Fnd_Log.STRING(ln_Proc_Level,

613:
614: --log for debug
615: IF (ln_Proc_Level >= ln_Dbg_Level)
616: THEN
617: Fnd_Log.STRING(ln_Proc_Level,
618: GV_MODULE_PREFIX || '.' || lv_Proc_Name || '.begin',
619: 'Enter function');
620: END IF; --(l_proc_level >= l_dbg_level)
621:

Line 654: Fnd_Log.STRING(ln_Proc_Level,

650: IF lv_False_Flag = 'N'
651: THEN
652: --log for debug
653: IF (ln_Proc_Level >= ln_Dbg_Level) THEN
654: Fnd_Log.STRING(ln_Proc_Level,
655: GV_MODULE_PREFIX || '.' || lv_Proc_Name || '.end',
656: 'Exit function');
657: END IF; --( ln_proc_level >= ln_dbg_level )
658: RETURN TRUE;

Line 663: Fnd_Log.STRING(ln_Proc_Level,

659: ELSE
660: --log for debug
661: IF (ln_Proc_Level >= ln_Dbg_Level)
662: THEN
663: Fnd_Log.STRING(ln_Proc_Level,
664: GV_MODULE_PREFIX || '.' || lv_Proc_Name || '.end',
665: 'Exit function');
666: END IF; --( ln_proc_level >= ln_dbg_level )
667: RETURN FALSE;

Line 676: Fnd_Log.STRING(ln_Proc_Level,

672: WHEN OTHERS
673: THEN
674: IF (ln_Proc_Level >= ln_Dbg_Level)
675: THEN
676: Fnd_Log.STRING(ln_Proc_Level,
677: GV_MODULE_PREFIX || '.' || lv_Proc_Name ||
678: '. Other_Exception ',
679: SQLCODE || ':' || SQLERRM);
680: END IF; --(ln_proc_level >= ln_dbg_level)

Line 708: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

704: RETURN BOOLEAN
705: IS
706: ln_row_count NUMBER := 0;
707: lv_Error_Msg VARCHAR2(2000);
708: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
709: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
710: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
711: lv_procedure_name VARCHAR2(40) := 'Check_Depreciation_Assignment';
712:

Line 709: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

705: IS
706: ln_row_count NUMBER := 0;
707: lv_Error_Msg VARCHAR2(2000);
708: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
709: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
710: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
711: lv_procedure_name VARCHAR2(40) := 'Check_Depreciation_Assignment';
712:
713: BEGIN

Line 710: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;

706: ln_row_count NUMBER := 0;
707: lv_Error_Msg VARCHAR2(2000);
708: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
709: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
710: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
711: lv_procedure_name VARCHAR2(40) := 'Check_Depreciation_Assignment';
712:
713: BEGIN
714:

Line 717: FND_LOG.STRING( ln_proc_level

713: BEGIN
714:
715: IF (ln_proc_level>=ln_dbg_level)
716: THEN
717: FND_LOG.STRING( ln_proc_level
718: , GV_MODULE_PREFIX ||'.' || lv_procedure_name ||
719: '.begin'
720: , 'Enter procedure'
721: );

Line 724: FND_LOG.STRING(ln_proc_level,

720: , 'Enter procedure'
721: );
722:
723: -- logging the parameters
724: FND_LOG.STRING(ln_proc_level,
725: lv_procedure_name ||
726: '.parameters',
727: 'pn_legal_entity_id=' || pn_legal_entity_id);
728: END IF; --l_proc_level>=l_dbg_level

Line 745: FND_LOG.STRING( ln_proc_level

741: Fnd_File.Put_Line(Fnd_File.Output, lv_Error_Msg);
742: --logging for debug
743: IF (ln_proc_level>=ln_dbg_level)
744: THEN
745: FND_LOG.STRING( ln_proc_level
746: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.end'
747: , 'Exit procedure'
748: );
749: END IF; -- (ln_proc_level>=ln_dbg_level)

Line 755: FND_LOG.STRING( ln_proc_level

751: ELSE
752: --logging for debug
753: IF (ln_proc_level>=ln_dbg_level)
754: THEN
755: FND_LOG.STRING( ln_proc_level
756: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.end'
757: , 'Exit procedure'
758: );
759: END IF; -- (ln_proc_level>=ln_dbg_level)

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

762:
763: EXCEPTION
764:
765: WHEN OTHERS THEN
766: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
767: THEN
768: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
769: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
770: '.Other_Exception ',

Line 768: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

764:
765: WHEN OTHERS THEN
766: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
767: THEN
768: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
769: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
770: '.Other_Exception ',
771: SQLCODE || SQLERRM);
772: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

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

768: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
769: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
770: '.Other_Exception ',
771: SQLCODE || SQLERRM);
772: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
773: FND_FILE.put_line(FND_FILE.log, lv_procedure_name || SQLCODE || SQLERRM);
774:
775: END Check_Depreciation_Assignment;
776: