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

Line 60: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

56: , pn_accounting_year IN NUMBER
57: )
58: IS
59: lv_procedure_name VARCHAR2(30) := 'Export_Shared_Information';
60: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
61: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
62: lv_si_element VARCHAR2(2000);
63:
64: BEGIN

Line 61: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

57: )
58: IS
59: lv_procedure_name VARCHAR2(30) := 'Export_Shared_Information';
60: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
61: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
62: lv_si_element VARCHAR2(2000);
63:
64: BEGIN
65: --logging for debug

Line 68: FND_LOG.STRING( ln_proc_level

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

Line 73: FND_LOG.STRING( ln_proc_level

69: , GV_MODULE_PREFIX ||'.' || lv_procedure_name
70: || '.begin'
71: , 'Enter procedure');
72: -- logging the parameters
73: FND_LOG.STRING( ln_proc_level
74: , lv_procedure_name || '.parameters'
75: , 'pn_legal_entity_id=' || pn_legal_entity_id|| ','
76: || 'pn_ledger_id=' || pn_ledger_id || ','
77: || 'pn_accounting_year=' || pn_accounting_year || ','

Line 225: FND_LOG.STRING( ln_proc_level

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

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

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

Line 233: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED

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

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

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

Line 284: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

280: IS
281: NO_DATA EXCEPTION;
282:
283: lv_procedure_name VARCHAR2(40) := 'Export_SI';
284: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
285: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
286: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
287: lv_error_status BOOLEAN;
288:

Line 285: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

281: NO_DATA EXCEPTION;
282:
283: lv_procedure_name VARCHAR2(40) := 'Export_SI';
284: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
285: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
286: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
287: lv_error_status BOOLEAN;
288:
289: ln_reqid_gle NUMBER;

Line 286: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;

282:
283: lv_procedure_name VARCHAR2(40) := 'Export_SI';
284: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
285: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
286: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
287: lv_error_status BOOLEAN;
288:
289: ln_reqid_gle NUMBER;
290: lv_gle_req_phase fnd_lookup_values.meaning%TYPE;

Line 313: FND_LOG.STRING( ln_proc_level

309: BEGIN
310: --logging for debug
311: IF (ln_proc_level>=ln_dbg_level)
312: THEN
313: FND_LOG.STRING( ln_proc_level
314: , GV_MODULE_PREFIX ||'.' || lv_procedure_name
315: || '.begin'
316: , 'Enter procedure');
317:

Line 319: FND_LOG.STRING( ln_proc_level

315: || '.begin'
316: , 'Enter procedure');
317:
318: -- logging the parameters
319: FND_LOG.STRING( ln_proc_level
320: , lv_procedure_name || '.parameters'
321: , 'pn_legal_entity_id=' || pn_legal_entity_id|| ','
322: || 'pn_ledger_id=' || pn_ledger_id || ','
323: || 'pn_accounting_year=' || pn_accounting_year || ','

Line 414: FND_LOG.STRING( ln_statement_level

410: );
411: --logging the variables
412: IF (ln_statement_level >= ln_dbg_level)
413: THEN
414: FND_LOG.STRING( ln_statement_level
415: , lv_procedure_name
416: , 'lv_output_file_name:' || lv_output_file_name);
417: END IF; --(ln_statement_level >= ln_dbg_level)
418: FND_FILE.put_line( FND_FILE.log

Line 479: FND_LOG.STRING( ln_proc_level

475: END IF; --lv_error_flag='W'
476: --logging for debug
477: IF (ln_proc_level >= ln_dbg_level)
478: THEN
479: FND_LOG.STRING( ln_proc_level
480: , GV_MODULE_PREFIX || '.' || lv_procedure_name || '.end'
481: , 'Exit procedure');
482: END IF; -- (ln_proc_level>=ln_dbg_level)
483: --logging for debug

Line 486: FND_LOG.STRING( ln_proc_level

482: END IF; -- (ln_proc_level>=ln_dbg_level)
483: --logging for debug
484: IF (ln_proc_level>=ln_dbg_level)
485: THEN
486: FND_LOG.STRING( ln_proc_level
487: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.end'
488: , 'Exit procedure'
489: );
490: END IF; -- (ln_proc_level>=ln_dbg_level)

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

490: END IF; -- (ln_proc_level>=ln_dbg_level)
491:
492: EXCEPTION
493: WHEN OTHERS THEN
494: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
495: THEN
496: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
497: , GV_MODULE_PREFIX || '.' || lv_procedure_name
498: || '.Other_Exception '

Line 496: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED

492: EXCEPTION
493: WHEN OTHERS THEN
494: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
495: THEN
496: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
497: , GV_MODULE_PREFIX || '.' || lv_procedure_name
498: || '.Other_Exception '
499: , SQLCODE || SQLERRM);
500: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

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

496: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
497: , GV_MODULE_PREFIX || '.' || lv_procedure_name
498: || '.Other_Exception '
499: , SQLCODE || SQLERRM);
500: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
501: FND_FILE.put_line( FND_FILE.log
502: , lv_procedure_name || SQLCODE || SQLERRM);
503: RAISE;
504: END Submit_Request;