DBA Data[Home] [Help]

APPS.JA_CN_UDRV_EXPORT dependencies on FND_LOG

Line 60: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

56: , pn_ledger_id IN NUMBER
57: , pv_accounting_year IN VARCHAR2
58: )
59: IS
60: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
61: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
62: lv_procedure_name VARCHAR2(40) := 'Add_User_Defined_Record_Values';
63: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
64: ln_journal_number NUMBER;

Line 61: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

57: , pv_accounting_year IN VARCHAR2
58: )
59: IS
60: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
61: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
62: lv_procedure_name VARCHAR2(40) := 'Add_User_Defined_Record_Values';
63: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
64: ln_journal_number NUMBER;
65: lv_sub_segment_code VARCHAR2(20);

Line 63: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;

59: IS
60: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
61: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
62: lv_procedure_name VARCHAR2(40) := 'Add_User_Defined_Record_Values';
63: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
64: ln_journal_number NUMBER;
65: lv_sub_segment_code VARCHAR2(20);
66: lv_source_code VARCHAR2(30);
67: lv_context_code VARCHAR2(30);

Line 220: FND_LOG.STRING( ln_proc_level

216: BEGIN
217: --logging for debug
218: IF (ln_proc_level>=ln_dbg_level)
219: THEN
220: FND_LOG.STRING( ln_proc_level
221: , GV_MODULE_PREFIX ||'.' || lv_procedure_name ||
222: '.begin'
223: , 'Enter procedure'
224: );

Line 227: FND_LOG.STRING(ln_proc_level,

223: , 'Enter procedure'
224: );
225:
226: -- logging the parameters
227: FND_LOG.STRING(ln_proc_level,
228: lv_procedure_name ||
229: '.parameters',
230: 'pn_legal_entity_id=' || pn_le_id|| ',' ||
231: 'pn_ledger_id=' || pn_ledger_id || ',' ||

Line 274: FND_LOG.STRING(ln_statement_level,

270:
271: --logging the variables
272: IF (ln_statement_level >= ln_dbg_level)
273: THEN
274: FND_LOG.STRING(ln_statement_level,
275: lv_procedure_name,
276: 'Journal number is:' || ln_journal_number);
277: END IF; --(ln_statement_level >= ln_dbg_level)
278: FND_FILE.put_line(FND_FILE.log, lv_procedure_name ||

Line 400: FND_LOG.STRING( ln_proc_level

396:
397: --logging for debug
398: IF (ln_proc_level>=ln_dbg_level)
399: THEN
400: FND_LOG.STRING( ln_proc_level
401: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.end'
402: , 'Exit procedure'
403: );
404: END IF; -- (ln_proc_level>=ln_dbg_level)

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

404: END IF; -- (ln_proc_level>=ln_dbg_level)
405:
406: EXCEPTION
407: WHEN OTHERS THEN
408: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
409: THEN
410: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
411: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
412: '.Other_Exception ',

Line 410: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

406: EXCEPTION
407: WHEN OTHERS THEN
408: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
409: THEN
410: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
411: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
412: '.Other_Exception ',
413: SQLCODE || SQLERRM);
414: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

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

410: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
411: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
412: '.Other_Exception ',
413: SQLCODE || SQLERRM);
414: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
415: FND_FILE.put_line(FND_FILE.log, lv_procedure_name || SQLCODE || SQLERRM);
416: END Add_User_Defined_Record_Value;
417:
418: END JA_CN_UDRV_EXPORT;