DBA Data[Home] [Help]

APPS.JA_CN_PS_FA_AC_EXP_PKG dependencies on FND_LOG

Line 54: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

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

Line 55: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

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

Line 81: FND_LOG.STRING( ln_proc_level

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

Line 87: FND_LOG.STRING( ln_proc_level

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

Line 161: FND_LOG.STRING( ln_proc_level

157:
158: --logging for debug
159: IF (ln_proc_level>=ln_dbg_level)
160: THEN
161: FND_LOG.STRING( ln_proc_level
162: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.end'
163: , 'Exit procedure');
164: END IF; -- (ln_proc_level>=ln_dbg_level)
165:

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

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

Line 170: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED

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

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

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

Line 212: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

208: , pv_period_to IN VARCHAR2
209: , pn_coa_id IN NUMBER
210: )
211: IS
212: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
213: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
214: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
215: ln_full_retirement_count NUMBER := 0;
216: ln_reinstate_count NUMBER := 0;

Line 213: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

209: , pn_coa_id IN NUMBER
210: )
211: IS
212: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
213: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
214: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
215: ln_full_retirement_count NUMBER := 0;
216: ln_reinstate_count NUMBER := 0;
217: ln_depreciation_counter NUMBER := 0;

Line 214: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;

210: )
211: IS
212: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
213: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
214: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
215: ln_full_retirement_count NUMBER := 0;
216: ln_reinstate_count NUMBER := 0;
217: ln_depreciation_counter NUMBER := 0;
218: ln_real_deprn_counter NUMBER := 0;

Line 395: FND_LOG.STRING( ln_proc_level

391: BEGIN
392: --logging for debug
393: IF (ln_proc_level>=ln_dbg_level)
394: THEN
395: FND_LOG.STRING( ln_proc_level
396: , GV_MODULE_PREFIX ||'.' || lv_procedure_name
397: || '.begin'
398: , 'Enter procedure'
399: );

Line 401: FND_LOG.STRING( ln_proc_level

397: || '.begin'
398: , 'Enter procedure'
399: );
400: -- logging the parameters
401: FND_LOG.STRING( ln_proc_level
402: , lv_procedure_name || '.parameters'
403: , 'pn_legal_entity_id=' || pn_legal_entity_id|| ','
404: || 'pn_ledger_id=' || pn_ledger_id || ','
405: || 'pv_accounting_year=' || pv_accounting_year || ','

Line 459: FND_LOG.STRING( ln_statement_level

455:
456: --log start data and end date
457: IF (ln_statement_level >= ln_dbg_level)
458: THEN
459: FND_LOG.STRING( ln_statement_level
460: , lv_procedure_name
461: , 'Fetched:'
462: || ' start date=' || nvl(TO_CHAR(ld_start_date), 'null')
463: || ' end date=' || nvl(to_char(ld_end_date), 'null'));

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

1122: );
1123: END IF;-- (lb_retirement_flag = FALSE)
1124: EXCEPTION
1125: WHEN OTHERS THEN
1126: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1127: THEN
1128: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
1129: , GV_MODULE_PREFIX || '.' || lv_procedure_name
1130: ||'.Other_Exception '

Line 1128: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED

1124: EXCEPTION
1125: WHEN OTHERS THEN
1126: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1127: THEN
1128: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
1129: , GV_MODULE_PREFIX || '.' || lv_procedure_name
1130: ||'.Other_Exception '
1131: , SQLCODE || SQLERRM);
1132: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

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

1128: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
1129: , GV_MODULE_PREFIX || '.' || lv_procedure_name
1130: ||'.Other_Exception '
1131: , SQLCODE || SQLERRM);
1132: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1133: FND_FILE.put_line( FND_FILE.log
1134: , lv_procedure_name || SQLCODE || SQLERRM);
1135: END;
1136: END LOOP;

Line 1254: FND_LOG.STRING( ln_proc_level

1250: END IF; --(ln_row_count = 0)
1251: --logging for debug
1252: IF (ln_proc_level>=ln_dbg_level)
1253: THEN
1254: FND_LOG.STRING( ln_proc_level
1255: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.end'
1256: , 'Exit procedure'
1257: );
1258: END IF; -- (ln_proc_level>=ln_dbg_level)

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

1257: );
1258: END IF; -- (ln_proc_level>=ln_dbg_level)
1259: EXCEPTION
1260: WHEN OTHERS THEN
1261: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1262: THEN
1263: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
1264: , GV_MODULE_PREFIX || '.' || lv_procedure_name
1265: || '.Other_Exception '

Line 1263: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED

1259: EXCEPTION
1260: WHEN OTHERS THEN
1261: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1262: THEN
1263: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
1264: , GV_MODULE_PREFIX || '.' || lv_procedure_name
1265: || '.Other_Exception '
1266: , SQLCODE || SQLERRM);
1267: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

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

1263: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
1264: , GV_MODULE_PREFIX || '.' || lv_procedure_name
1265: || '.Other_Exception '
1266: , SQLCODE || SQLERRM);
1267: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1268: FND_FILE.put_line(FND_FILE.log, lv_procedure_name || SQLCODE || SQLERRM);
1269: RAISE;
1270: END Add_FA_Asset_Card_Monthly;
1271: END JA_CN_PS_FA_AC_EXP_PKG;