APPS.JA_CN_SR_EXPORT_PKG dependencies on FND_LOG

Line 57: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

53: ,pv_accounting_year IN VARCHAR2
54: )
55: IS
56: lv_procedure_name VARCHAR2(40) := 'Add_Supplier';
57: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
58: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
59: --ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
60: NO_DATA EXCEPTION;
61: ln_row_count NUMBER := 0;

Line 58: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

54: )
55: IS
56: lv_procedure_name VARCHAR2(40) := 'Add_Supplier';
57: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
58: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
59: --ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
60: NO_DATA EXCEPTION;
61: ln_row_count NUMBER := 0;
62:

Line 59: --ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;

55: IS
56: lv_procedure_name VARCHAR2(40) := 'Add_Supplier';
57: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
58: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
59: --ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
60: NO_DATA EXCEPTION;
61: ln_row_count NUMBER := 0;
62:
63: CURSOR supplier_cur

Line 83: FND_LOG.STRING(ln_proc_level,

79: BEGIN
80: --logging for debug
81: IF (ln_proc_level >= ln_dbg_level)
82: THEN
83: FND_LOG.STRING(ln_proc_level,
84: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
85: '.begin',
86: 'Enter procedure');
87: -- logging the parameters

Line 88: FND_LOG.STRING(ln_proc_level,

84: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
85: '.begin',
86: 'Enter procedure');
87: -- logging the parameters
88: FND_LOG.STRING(ln_proc_level,
89: lv_procedure_name ||
90: '.parameters',
91: 'pn_legal_entity_id=' || pn_legal_entity_id || ',' ||
92: 'pv_accounting_year=' || pv_accounting_year);

Line 136: FND_LOG.STRING(ln_proc_level,

132:
133: --logging for debug
134: IF (ln_proc_level >= ln_dbg_level)
135: THEN
136: FND_LOG.STRING(ln_proc_level,
137: GV_MODULE_PREFIX || '.' || lv_procedure_name || '.end',
138: 'Exit procedure');
139: END IF; -- (ln_proc_level>=ln_dbg_level)
140:

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

140:
141: --To handle the No Data Found Exception
142: EXCEPTION
143: WHEN OTHERS THEN
144: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
145: THEN
146: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
147: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
148: '.Other_Exception ',

Line 146: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

142: EXCEPTION
143: WHEN OTHERS THEN
144: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
145: THEN
146: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
147: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
148: '.Other_Exception ',
149: SQLCODE || SQLERRM);
150: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

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

146: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
147: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
148: '.Other_Exception ',
149: SQLCODE || SQLERRM);
150: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
151: FND_FILE.put_line(FND_FILE.log, lv_procedure_name || SQLCODE || SQLERRM);
152: RAISE;
153:
154: END Add_Supplier;