DBA Data[Home] [Help]

APPS.JA_CN_FA_AC_EXPORT_PKG dependencies on FND_LOG

Line 55: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

51: pv_accounting_year IN VARCHAR2,
52: pv_period_from IN VARCHAR2,
53: pv_period_to IN VARCHAR2,
54: pn_coa_id NUMBER) IS
55: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
56: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
57: lv_procedure_name VARCHAR2(40) := 'Add_FA_Asset_Card';
58: ld_start_date DATE;
59: ld_end_date DATE;

Line 56: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

52: pv_period_from IN VARCHAR2,
53: pv_period_to IN VARCHAR2,
54: pn_coa_id NUMBER) IS
55: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
56: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
57: lv_procedure_name VARCHAR2(40) := 'Add_FA_Asset_Card';
58: ld_start_date DATE;
59: ld_end_date DATE;
60: ld_start_date_monthly DATE;

Line 77: FND_LOG.STRING(ln_proc_level,

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

Line 83: FND_LOG.STRING(ln_proc_level,

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

Line 295: FND_LOG.STRING(ln_proc_level,

291: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
292: END IF;
293: --logging for debug
294: IF (ln_proc_level >= ln_dbg_level) THEN
295: FND_LOG.STRING(ln_proc_level,
296: GV_MODULE_PREFIX || '.' || lv_procedure_name || '.end',
297: 'Exit procedure');
298: END IF; -- (ln_proc_level>=ln_dbg_level)
299:

Line 302: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

298: END IF; -- (ln_proc_level>=ln_dbg_level)
299:
300: EXCEPTION
301: WHEN OTHERS THEN
302: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
303: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
304: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
305: '.Other_Exception ',
306: SQLCODE || SQLERRM);

Line 303: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

299:
300: EXCEPTION
301: WHEN OTHERS THEN
302: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
303: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
304: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
305: '.Other_Exception ',
306: SQLCODE || SQLERRM);
307: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

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

303: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
304: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
305: '.Other_Exception ',
306: SQLCODE || SQLERRM);
307: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
308: FND_FILE.put_line(FND_FILE.log,
309: lv_procedure_name || SQLCODE || SQLERRM);
310: END Add_FA_Asset_Card;
311: --==========================================================================

Line 341: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

337: pv_accounting_year IN VARCHAR2,
338: pv_period_from IN VARCHAR2,
339: pv_period_to IN VARCHAR2,
340: pn_coa_id NUMBER) RETURN NUMBER IS
341: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
342: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
343: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
344: ln_full_retirement_count NUMBER := 0;
345: ln_reinstate_count NUMBER := 0;

Line 342: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

338: pv_period_from IN VARCHAR2,
339: pv_period_to IN VARCHAR2,
340: pn_coa_id NUMBER) RETURN NUMBER IS
341: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
342: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
343: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
344: ln_full_retirement_count NUMBER := 0;
345: ln_reinstate_count NUMBER := 0;
346: ln_depreciation_counter NUMBER := 0;

Line 343: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;

339: pv_period_to IN VARCHAR2,
340: pn_coa_id NUMBER) RETURN NUMBER IS
341: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
342: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
343: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
344: ln_full_retirement_count NUMBER := 0;
345: ln_reinstate_count NUMBER := 0;
346: ln_depreciation_counter NUMBER := 0;
347: ln_real_deprn_counter NUMBER := 0;

Line 510: FND_LOG.STRING(ln_proc_level,

506: BEGIN
507:
508: --logging for debug
509: IF (ln_proc_level >= ln_dbg_level) THEN
510: FND_LOG.STRING(ln_proc_level,
511: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
512: '.begin',
513: 'Enter procedure');
514: -- logging the parameters

Line 515: FND_LOG.STRING(ln_proc_level,

511: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
512: '.begin',
513: 'Enter procedure');
514: -- logging the parameters
515: FND_LOG.STRING(ln_proc_level,
516: lv_procedure_name || '.parameters',
517: 'pn_legal_entity_id=' || pn_legal_entity_id || ',' ||
518: 'pn_ledger_id=' || pn_ledger_id || ',' ||
519: 'pv_accounting_year=' || pv_accounting_year || ',' ||

Line 561: FND_LOG.STRING(ln_statement_level,

557: END IF; -- pv_period_to IS NOT NULL
558:
559: --log start data and end date
560: IF (ln_statement_level >= ln_dbg_level) THEN
561: FND_LOG.STRING(ln_statement_level,
562: lv_procedure_name,
563: 'Fetched: start date=' ||
564: nvl(to_char(ld_start_date), 'null') || ' end date=' ||
565: nvl(to_char(ld_end_date), 'null'));

Line 1257: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1253:
1254: END IF; -- (lb_retirement_flag = FALSE)
1255: EXCEPTION
1256: WHEN OTHERS THEN
1257: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1258: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
1259: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
1260: '.Other_Exception ',
1261: SQLCODE || SQLERRM);

Line 1258: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

1254: END IF; -- (lb_retirement_flag = FALSE)
1255: EXCEPTION
1256: WHEN OTHERS THEN
1257: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1258: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
1259: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
1260: '.Other_Exception ',
1261: SQLCODE || SQLERRM);
1262: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

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

1258: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
1259: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
1260: '.Other_Exception ',
1261: SQLCODE || SQLERRM);
1262: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1263: FND_FILE.put_line(FND_FILE.log,
1264: lv_procedure_name || SQLCODE || SQLERRM);
1265: END;
1266: END LOOP;

Line 1454: FND_LOG.STRING(ln_proc_level,

1450:
1451: END IF; --(ln_row_count = 0)*/
1452: --logging for debug
1453: IF (ln_proc_level >= ln_dbg_level) THEN
1454: FND_LOG.STRING(ln_proc_level,
1455: GV_MODULE_PREFIX || '.' || lv_procedure_name || '.end',
1456: 'Exit procedure');
1457: END IF; -- (ln_proc_level>=ln_dbg_level)
1458:

Line 1467: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1463: END IF; --(ln_row_count = 0)
1464:
1465: EXCEPTION
1466: WHEN OTHERS THEN
1467: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1468: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
1469: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
1470: '.Other_Exception ',
1471: SQLCODE || SQLERRM);

Line 1468: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

1464:
1465: EXCEPTION
1466: WHEN OTHERS THEN
1467: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1468: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
1469: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
1470: '.Other_Exception ',
1471: SQLCODE || SQLERRM);
1472: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

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

1468: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
1469: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
1470: '.Other_Exception ',
1471: SQLCODE || SQLERRM);
1472: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1473: FND_FILE.put_line(FND_FILE.log,
1474: lv_procedure_name || SQLCODE || SQLERRM);
1475:
1476: END Add_FA_Asset_Card_Monthly;