DBA Data[Home] [Help]

APPS.JA_CN_GBI_EXPORT_PKG dependencies on FND_LOG

Line 49: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

45: ,pn_cfs_report_id NUMBER
46: )
47: IS
48: lv_procedure_name VARCHAR2(40) := 'Add_GL_Basic_Info';
49: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
50: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
51: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
52: NO_DATA EXCEPTION;
53: lv_separator VARCHAR2(1);

Line 50: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

46: )
47: IS
48: lv_procedure_name VARCHAR2(40) := 'Add_GL_Basic_Info';
49: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
50: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
51: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
52: NO_DATA EXCEPTION;
53: lv_separator VARCHAR2(1);
54: lv_account_structure VARCHAR2(200);

Line 51: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;

47: IS
48: lv_procedure_name VARCHAR2(40) := 'Add_GL_Basic_Info';
49: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
50: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
51: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
52: NO_DATA EXCEPTION;
53: lv_separator VARCHAR2(1);
54: lv_account_structure VARCHAR2(200);
55: lv_cash_flow_item_rule VARCHAR2(10);

Line 88: FND_LOG.STRING(ln_proc_level,

84: BEGIN
85: --logging for debug
86: IF (ln_proc_level >= ln_dbg_level)
87: THEN
88: FND_LOG.STRING(ln_proc_level,
89: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
90: '.begin',
91: 'Enter procedure');
92: -- logging the parameters

Line 93: FND_LOG.STRING(ln_proc_level,

89: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
90: '.begin',
91: 'Enter procedure');
92: -- logging the parameters
93: FND_LOG.STRING(ln_proc_level,
94: lv_procedure_name ||
95: '.parameters',
96: 'pn_coa_id=' || pn_coa_id || ',' ||
97: 'pn_cfs_report_id=' || pn_cfs_report_id);

Line 118: FND_LOG.STRING(ln_statement_level,

114:
115: --logging the variables
116: IF (ln_statement_level >= ln_dbg_level)
117: THEN
118: FND_LOG.STRING(ln_statement_level,
119: lv_procedure_name,
120: 'lv_separator=' || lv_separator || ',' ||
121: 'lv_account_structure=' || lv_account_structure || ',' ||
122: 'lv_cash_flow_item_rule=' || lv_cash_flow_item_rule);

Line 165: FND_LOG.STRING(ln_proc_level,

161:
162: --logging for debug
163: IF (ln_proc_level >= ln_dbg_level)
164: THEN
165: FND_LOG.STRING(ln_proc_level,
166: GV_MODULE_PREFIX || '.' || lv_procedure_name || '.end',
167: 'Exit procedure');
168: END IF; -- (ln_proc_level>=ln_dbg_level)
169: EXCEPTION

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

167: 'Exit procedure');
168: END IF; -- (ln_proc_level>=ln_dbg_level)
169: EXCEPTION
170: WHEN OTHERS THEN
171: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
172: THEN
173: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
174: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
175: '.Other_Exception ',

Line 173: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

169: EXCEPTION
170: WHEN OTHERS THEN
171: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
172: THEN
173: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
174: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
175: '.Other_Exception ',
176: SQLCODE || SQLERRM);
177: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

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

173: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
174: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
175: '.Other_Exception ',
176: SQLCODE || SQLERRM);
177: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
178: FND_FILE.put_line(FND_FILE.log, lv_procedure_name || SQLCODE || SQLERRM);
179: RAISE;
180: END Add_GL_Basic_Info;
181: