APPS.JA_CN_SIOA_EXPORT_PKG dependencies on FND_LOG

Line 58: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

54: ,pv_period_to VARCHAR2*/
55: )
56: IS
57: lv_procedure_name VARCHAR2(40) := 'Add_Sub_Item_Of_Account';
58: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
59: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
60: NO_DATA EXCEPTION;
61:
62: --Get account number from itemized balance table

Line 59: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

55: )
56: IS
57: lv_procedure_name VARCHAR2(40) := 'Add_Sub_Item_Of_Account';
58: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
59: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
60: NO_DATA EXCEPTION;
61:
62: --Get account number from itemized balance table
63: --The data is fetched by ledger id and legal entity id

Line 286: FND_LOG.STRING(ln_proc_level,

282: BEGIN
283: --logging for debug
284: IF (ln_proc_level >= ln_dbg_level)
285: THEN
286: FND_LOG.STRING(ln_proc_level,
287: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
288: '.begin',
289: 'Enter procedure');
290: -- logging the parameters

Line 291: FND_LOG.STRING(ln_proc_level,

287: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
288: '.begin',
289: 'Enter procedure');
290: -- logging the parameters
291: FND_LOG.STRING(ln_proc_level,
292: lv_procedure_name ||
293: '.parameters',
294: 'pn_legal_entity_id=' || pn_legal_entity_id || ',' ||
295: 'pn_ledger_id=' || pn_ledger_id || ',' ||

Line 383: FND_LOG.STRING(ln_proc_level,

379:
380: --logging for debug
381: IF (ln_proc_level >= ln_dbg_level)
382: THEN
383: FND_LOG.STRING(ln_proc_level,
384: GV_MODULE_PREFIX || '.' || lv_procedure_name || '.end',
385: 'Exit procedure');
386: END IF; -- (ln_proc_level>=ln_dbg_level)
387:

Line 393: FND_LOG.STRING(ln_proc_level,

389: WHEN NO_DATA THEN
390: --logging for debug
391: IF (ln_proc_level >= ln_dbg_level)
392: THEN
393: FND_LOG.STRING(ln_proc_level,
394: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
395: 'exception',
396: 'No data for Subsidiary Item of Account');
397: END IF; --l_proc_level>=l_dbg_level

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

395: 'exception',
396: 'No data for Subsidiary Item of Account');
397: END IF; --l_proc_level>=l_dbg_level
398: WHEN OTHERS THEN
399: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
400: THEN
401: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
402: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
403: '.Other_Exception ',

Line 401: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

397: END IF; --l_proc_level>=l_dbg_level
398: WHEN OTHERS THEN
399: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
400: THEN
401: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
402: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
403: '.Other_Exception ',
404: SQLCODE || SQLERRM);
405: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

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

401: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
402: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
403: '.Other_Exception ',
404: SQLCODE || SQLERRM);
405: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
406: FND_FILE.put_line(FND_FILE.log, lv_procedure_name || SQLCODE || SQLERRM);
407:
408: END Add_Sub_Item_Of_Account;
409: