eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FUN_GL_ASF_EVENTS_PKG dependencies on FND_LOG

Line 26: g_debug_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

22:
23: SAVEPOINT fun_ledger_bsv_remove;
24:
25: -- variable p_validation_level is not used .
26: g_debug_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
27:
28: l_ledger_id := wf_event.getvalueforparameter ('LEDGER_ID',p_event.parameter_list);
29: l_bsv := wf_event.getvalueforparameter ('BAL_SEGMENT_VALUE',p_event.parameter_list);
30:

Line 31: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level)

27:
28: l_ledger_id := wf_event.getvalueforparameter ('LEDGER_ID',p_event.parameter_list);
29: l_bsv := wf_event.getvalueforparameter ('BAL_SEGMENT_VALUE',p_event.parameter_list);
30:
31: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level)
32: THEN
33: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
34: 'fun.plsql.fun_gl_asf_events_pkg.ledger_bsv_remove',
35: 'Begin Ledger Id ' || l_ledger_id || ', BSV ' || l_bsv);

Line 33: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

29: l_bsv := wf_event.getvalueforparameter ('BAL_SEGMENT_VALUE',p_event.parameter_list);
30:
31: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level)
32: THEN
33: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
34: 'fun.plsql.fun_gl_asf_events_pkg.ledger_bsv_remove',
35: 'Begin Ledger Id ' || l_ledger_id || ', BSV ' || l_bsv);
36: END IF;
37:

Line 55: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level)

51: AND template_id IN (SELECT template_id
52: FROM fun_balance_options
53: WHERE ledger_id = l_ledger_id);
54:
55: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level)
56: THEN
57: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
58: 'fun.plsql.fun_gl_asf_events_pkg.ledger_bsv_remove',
59: ' No. of rows deleted from fun_balance_accounts is ' ||

Line 57: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

53: WHERE ledger_id = l_ledger_id);
54:
55: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level)
56: THEN
57: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
58: 'fun.plsql.fun_gl_asf_events_pkg.ledger_bsv_remove',
59: ' No. of rows deleted from fun_balance_accounts is ' ||
60: SQL%ROWCOUNT);
61: END IF;

Line 66: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level)

62:
63:
64: END IF; -- Ledger and BSV passed
65:
66: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level)
67: THEN
68: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
69: 'fun.plsql.fun_gl_asf_events_pkg.ledger_bsv_remove',
70: 'completed');

Line 68: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

64: END IF; -- Ledger and BSV passed
65:
66: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level)
67: THEN
68: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
69: 'fun.plsql.fun_gl_asf_events_pkg.ledger_bsv_remove',
70: 'completed');
71: END IF;
72:

Line 78: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level)

74:
75: EXCEPTION
76: WHEN OTHERS THEN
77: ROLLBACK TO fun_ledger_bsv_remove;
78: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level)
79: THEN
80: fnd_log.string(FND_LOG.LEVEL_UNEXPECTED,
81: 'fun.plsql.fun_gl_asf_events_pkg.ledger_bsv_remove',
82: 'Error encountered ' || SQLERRM);

Line 80: fnd_log.string(FND_LOG.LEVEL_UNEXPECTED,

76: WHEN OTHERS THEN
77: ROLLBACK TO fun_ledger_bsv_remove;
78: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level)
79: THEN
80: fnd_log.string(FND_LOG.LEVEL_UNEXPECTED,
81: 'fun.plsql.fun_gl_asf_events_pkg.ledger_bsv_remove',
82: 'Error encountered ' || SQLERRM);
83: END IF;
84: wf_core.context (g_module,

Line 112: g_debug_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

108: BEGIN
109: SAVEPOINT fun_le_bsv_remove;
110:
111: -- variable p_validation_level is not used .
112: g_debug_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
113:
114: l_le_id := wf_event.getvalueforparameter ('LEGAL_ENTITY_ID',p_event.parameter_list);
115: l_bsv := wf_event.getvalueforparameter ('BAL_SEGMENT_VALUE',p_event.parameter_list);
116:

Line 117: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level)

113:
114: l_le_id := wf_event.getvalueforparameter ('LEGAL_ENTITY_ID',p_event.parameter_list);
115: l_bsv := wf_event.getvalueforparameter ('BAL_SEGMENT_VALUE',p_event.parameter_list);
116:
117: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level)
118: THEN
119: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
120: 'fun.plsql.fun_gl_asf_events_pkg.le_bsv_remove',
121: 'Begin LE Id ' || l_le_id || ', BSV ' || l_bsv);

Line 119: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

115: l_bsv := wf_event.getvalueforparameter ('BAL_SEGMENT_VALUE',p_event.parameter_list);
116:
117: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level)
118: THEN
119: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
120: 'fun.plsql.fun_gl_asf_events_pkg.le_bsv_remove',
121: 'Begin LE Id ' || l_le_id || ', BSV ' || l_bsv);
122: END IF;
123:

Line 141: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level)

137: AND template_id IN (SELECT template_id
138: FROM fun_balance_options
139: WHERE le_id = l_le_id);
140:
141: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level)
142: THEN
143: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
144: 'fun.plsql.fun_gl_asf_events_pkg.le_bsv_remove',
145: ' No. of rows deleted from fun_balance_accounts is ' ||

Line 143: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

139: WHERE le_id = l_le_id);
140:
141: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level)
142: THEN
143: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
144: 'fun.plsql.fun_gl_asf_events_pkg.le_bsv_remove',
145: ' No. of rows deleted from fun_balance_accounts is ' ||
146: SQL%ROWCOUNT);
147: END IF;

Line 158: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level)

154: last_updated_by = FND_GLOBAL.USER_ID
155: WHERE (trans_bsv = l_bsv AND from_le_id = l_le_id)
156: OR (tp_bsv = l_bsv AND to_le_id = l_le_id);
157:
158: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level)
159: THEN
160: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
161: 'fun.plsql.fun_gl_asf_events_pkg.le_bsv_remove',
162: ' No. of rows terminated in fun_inter_accounts is ' ||

Line 160: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

156: OR (tp_bsv = l_bsv AND to_le_id = l_le_id);
157:
158: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level)
159: THEN
160: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
161: 'fun.plsql.fun_gl_asf_events_pkg.le_bsv_remove',
162: ' No. of rows terminated in fun_inter_accounts is ' ||
163: SQL%ROWCOUNT);
164: END IF;

Line 169: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level)

165:
166:
167: END IF; -- Ledger and BSV passed
168:
169: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level)
170: THEN
171: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
172: 'fun.plsql.fun_gl_asf_events_pkg.le_bsv_remove',
173: 'completed');

Line 171: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

167: END IF; -- Ledger and BSV passed
168:
169: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level)
170: THEN
171: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
172: 'fun.plsql.fun_gl_asf_events_pkg.le_bsv_remove',
173: 'completed');
174: END IF;
175:

Line 181: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level)

177:
178: EXCEPTION
179: WHEN OTHERS THEN
180: ROLLBACK TO fun_le_bsv_remove;
181: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level)
182: THEN
183: fnd_log.string(FND_LOG.LEVEL_UNEXPECTED,
184: 'fun.plsql.fun_gl_asf_events_pkg.le_bsv_remove',
185: 'Error encountered ' || SQLERRM);

Line 183: fnd_log.string(FND_LOG.LEVEL_UNEXPECTED,

179: WHEN OTHERS THEN
180: ROLLBACK TO fun_le_bsv_remove;
181: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level)
182: THEN
183: fnd_log.string(FND_LOG.LEVEL_UNEXPECTED,
184: 'fun.plsql.fun_gl_asf_events_pkg.le_bsv_remove',
185: 'Error encountered ' || SQLERRM);
186: END IF;
187: wf_core.context (g_module,

Line 217: g_debug_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

213: BEGIN
214: SAVEPOINT fun_ledger_le_remove;
215:
216: -- variable p_validation_level is not used .
217: g_debug_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
218:
219: l_le_id := wf_event.getvalueforparameter ('LEGAL_ENTITY_ID',p_event.parameter_list);
220: l_ledger_id := wf_event.getvalueforparameter ('PRIMARY_LEDGER_ID',p_event.parameter_list);
221:

Line 222: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level)

218:
219: l_le_id := wf_event.getvalueforparameter ('LEGAL_ENTITY_ID',p_event.parameter_list);
220: l_ledger_id := wf_event.getvalueforparameter ('PRIMARY_LEDGER_ID',p_event.parameter_list);
221:
222: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level)
223: THEN
224: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
225: 'fun.plsql.fun_gl_asf_events_pkg.ledger_le_remove',
226: 'Begin LE Id ' || l_le_id || ', Ledger Id ' || l_ledger_id);

Line 224: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

220: l_ledger_id := wf_event.getvalueforparameter ('PRIMARY_LEDGER_ID',p_event.parameter_list);
221:
222: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level)
223: THEN
224: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
225: 'fun.plsql.fun_gl_asf_events_pkg.ledger_le_remove',
226: 'Begin LE Id ' || l_le_id || ', Ledger Id ' || l_ledger_id);
227: END IF;
228:

Line 248: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level)

244: last_updated_by = FND_GLOBAL.USER_ID
245: WHERE le_id = l_le_id
246: AND ledger_id = l_ledger_id;
247:
248: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level)
249: THEN
250: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
251: 'fun.plsql.fun_gl_asf_events_pkg.ledger_le_remove',
252: ' No. of rows disabled in fun_balance_options is ' ||

Line 250: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

246: AND ledger_id = l_ledger_id;
247:
248: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level)
249: THEN
250: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
251: 'fun.plsql.fun_gl_asf_events_pkg.ledger_le_remove',
252: ' No. of rows disabled in fun_balance_options is ' ||
253: SQL%ROWCOUNT);
254: END IF;

Line 264: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level)

260: last_updated_by = FND_GLOBAL.USER_ID
261: WHERE from_le_id = l_le_id
262: AND ledger_id = l_ledger_id;
263:
264: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level)
265: THEN
266: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
267: 'fun.plsql.fun_gl_asf_events_pkg.ledger_le_remove',
268: ' No. of rows terminated in fun_inter_accounts is ' ||

Line 266: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

262: AND ledger_id = l_ledger_id;
263:
264: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level)
265: THEN
266: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
267: 'fun.plsql.fun_gl_asf_events_pkg.ledger_le_remove',
268: ' No. of rows terminated in fun_inter_accounts is ' ||
269: SQL%ROWCOUNT);
270: END IF;

Line 274: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level)

270: END IF;
271:
272: END IF; -- Ledger and LE passed
273:
274: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level)
275: THEN
276: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
277: 'fun.plsql.fun_gl_asf_events_pkg.ledger_le_remove',
278: 'completed');

Line 276: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

272: END IF; -- Ledger and LE passed
273:
274: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level)
275: THEN
276: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
277: 'fun.plsql.fun_gl_asf_events_pkg.ledger_le_remove',
278: 'completed');
279: END IF;
280:

Line 286: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level)

282:
283: EXCEPTION
284: WHEN OTHERS THEN
285: ROLLBACK TO fun_ledger_le_remove;
286: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level)
287: THEN
288: fnd_log.string(FND_LOG.LEVEL_UNEXPECTED,
289: 'fun.plsql.fun_gl_asf_events_pkg.ledger_le_remove',
290: 'Error encountered ' || SQLERRM);

Line 288: fnd_log.string(FND_LOG.LEVEL_UNEXPECTED,

284: WHEN OTHERS THEN
285: ROLLBACK TO fun_ledger_le_remove;
286: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level)
287: THEN
288: fnd_log.string(FND_LOG.LEVEL_UNEXPECTED,
289: 'fun.plsql.fun_gl_asf_events_pkg.ledger_le_remove',
290: 'Error encountered ' || SQLERRM);
291: END IF;
292: wf_core.context (g_module,

Line 320: g_debug_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

316: BEGIN
317: SAVEPOINT fun_secondary_ledger_delete;
318:
319: -- variable p_validation_level is not used .
320: g_debug_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
321:
322: l_sec_ledger_id := wf_event.getvalueforparameter ('SECONDARY_LEDGER_ID',p_event.parameter_list);
323:
324: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level)

Line 324: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level)

320: g_debug_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
321:
322: l_sec_ledger_id := wf_event.getvalueforparameter ('SECONDARY_LEDGER_ID',p_event.parameter_list);
323:
324: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level)
325: THEN
326: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
327: 'fun.plsql.fun_gl_asf_events_pkg.secondary_ledger_delete',
328: 'Begin Secondary Ledger Id ' || l_sec_ledger_id );

Line 326: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

322: l_sec_ledger_id := wf_event.getvalueforparameter ('SECONDARY_LEDGER_ID',p_event.parameter_list);
323:
324: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level)
325: THEN
326: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
327: 'fun.plsql.fun_gl_asf_events_pkg.secondary_ledger_delete',
328: 'Begin Secondary Ledger Id ' || l_sec_ledger_id );
329: END IF;
330:

Line 347: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level)

343: WHERE template_id in (SELECT template_id
344: FROM fun_balance_options
345: WHERE ledger_id = l_sec_ledger_id);
346:
347: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level)
348: THEN
349: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
350: 'fun.plsql.fun_gl_asf_events_pkg.secondary_ledger_delete',
351: ' No. of rows deleted in fun_balance_accounts is ' ||

Line 349: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

345: WHERE ledger_id = l_sec_ledger_id);
346:
347: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level)
348: THEN
349: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
350: 'fun.plsql.fun_gl_asf_events_pkg.secondary_ledger_delete',
351: ' No. of rows deleted in fun_balance_accounts is ' ||
352: SQL%ROWCOUNT);
353: END IF;

Line 358: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level)

354:
355: DELETE FROM fun_balance_options
356: WHERE ledger_id = l_sec_ledger_id;
357:
358: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level)
359: THEN
360: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
361: 'fun.plsql.fun_gl_asf_events_pkg.secondary_ledger_delete',
362: ' No. of rows deleted in fun_balance_options is ' ||

Line 360: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

356: WHERE ledger_id = l_sec_ledger_id;
357:
358: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level)
359: THEN
360: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
361: 'fun.plsql.fun_gl_asf_events_pkg.secondary_ledger_delete',
362: ' No. of rows deleted in fun_balance_options is ' ||
363: SQL%ROWCOUNT);
364: END IF;

Line 369: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level)

365:
366: DELETE FROM fun_inter_accounts
367: WHERE ledger_id = l_sec_ledger_id;
368:
369: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level)
370: THEN
371: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
372: 'fun.plsql.fun_gl_asf_events_pkg.secondary_ledger_delete',
373: ' No. of rows deleted in fun_inter_accounts is ' ||

Line 371: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

367: WHERE ledger_id = l_sec_ledger_id;
368:
369: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level)
370: THEN
371: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
372: 'fun.plsql.fun_gl_asf_events_pkg.secondary_ledger_delete',
373: ' No. of rows deleted in fun_inter_accounts is ' ||
374: SQL%ROWCOUNT);
375: END IF;

Line 380: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level)

376:
377:
378: END IF; -- Ledger passed
379:
380: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level)
381: THEN
382: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
383: 'fun.plsql.fun_gl_asf_events_pkg.secondary_ledger_delete',
384: 'completed');

Line 382: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

378: END IF; -- Ledger passed
379:
380: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level)
381: THEN
382: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
383: 'fun.plsql.fun_gl_asf_events_pkg.secondary_ledger_delete',
384: 'completed');
385: END IF;
386:

Line 392: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level)

388:
389: EXCEPTION
390: WHEN OTHERS THEN
391: ROLLBACK TO fun_secondary_ledger_delete;
392: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level)
393: THEN
394: fnd_log.string(FND_LOG.LEVEL_UNEXPECTED,
395: 'fun.plsql.fun_gl_asf_events_pkg.secondary_ledger_delete',
396: 'Error encountered ' || SQLERRM);

Line 394: fnd_log.string(FND_LOG.LEVEL_UNEXPECTED,

390: WHEN OTHERS THEN
391: ROLLBACK TO fun_secondary_ledger_delete;
392: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level)
393: THEN
394: fnd_log.string(FND_LOG.LEVEL_UNEXPECTED,
395: 'fun.plsql.fun_gl_asf_events_pkg.secondary_ledger_delete',
396: 'Error encountered ' || SQLERRM);
397: END IF;
398: wf_core.context (g_module,

Line 426: g_debug_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

422: BEGIN
423: SAVEPOINT fun_reporting_ledger_delete;
424:
425: -- variable p_validation_level is not used .
426: g_debug_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
427:
428: l_rep_ledger_id := wf_event.getvalueforparameter ('TARGET_LEDGER_ID',p_event.parameter_list);
429:
430: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level)

Line 430: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level)

426: g_debug_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
427:
428: l_rep_ledger_id := wf_event.getvalueforparameter ('TARGET_LEDGER_ID',p_event.parameter_list);
429:
430: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level)
431: THEN
432: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
433: 'fun.plsql.fun_gl_asf_events_pkg.reporting_ledger_delete',
434: 'Begin Reporting Ledger Id ' || l_rep_ledger_id );

Line 432: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

428: l_rep_ledger_id := wf_event.getvalueforparameter ('TARGET_LEDGER_ID',p_event.parameter_list);
429:
430: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level)
431: THEN
432: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
433: 'fun.plsql.fun_gl_asf_events_pkg.reporting_ledger_delete',
434: 'Begin Reporting Ledger Id ' || l_rep_ledger_id );
435: END IF;
436:

Line 453: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level)

449: WHERE template_id in (SELECT template_id
450: FROM fun_balance_options
451: WHERE ledger_id = l_rep_ledger_id);
452:
453: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level)
454: THEN
455: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
456: 'fun.plsql.fun_gl_asf_events_pkg.reporting_ledger_delete',
457: ' No. of rows deleted in fun_balance_accounts is ' ||

Line 455: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

451: WHERE ledger_id = l_rep_ledger_id);
452:
453: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level)
454: THEN
455: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
456: 'fun.plsql.fun_gl_asf_events_pkg.reporting_ledger_delete',
457: ' No. of rows deleted in fun_balance_accounts is ' ||
458: SQL%ROWCOUNT);
459: END IF;

Line 464: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level)

460:
461: DELETE FROM fun_balance_options
462: WHERE ledger_id = l_rep_ledger_id;
463:
464: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level)
465: THEN
466: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
467: 'fun.plsql.fun_gl_asf_events_pkg.reporting_ledger_delete',
468: ' No. of rows deleted in fun_balance_options is ' ||

Line 466: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

462: WHERE ledger_id = l_rep_ledger_id;
463:
464: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level)
465: THEN
466: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
467: 'fun.plsql.fun_gl_asf_events_pkg.reporting_ledger_delete',
468: ' No. of rows deleted in fun_balance_options is ' ||
469: SQL%ROWCOUNT);
470: END IF;

Line 475: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level)

471:
472: DELETE FROM fun_inter_accounts
473: WHERE ledger_id = l_rep_ledger_id;
474:
475: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level)
476: THEN
477: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
478: 'fun.plsql.fun_gl_asf_events_pkg.reporting_ledger_delete',
479: ' No. of rows deleted in fun_inter_accounts is ' ||

Line 477: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

473: WHERE ledger_id = l_rep_ledger_id;
474:
475: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level)
476: THEN
477: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
478: 'fun.plsql.fun_gl_asf_events_pkg.reporting_ledger_delete',
479: ' No. of rows deleted in fun_inter_accounts is ' ||
480: SQL%ROWCOUNT);
481: END IF;

Line 486: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level)

482:
483:
484: END IF; -- Ledger passed
485:
486: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level)
487: THEN
488: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
489: 'fun.plsql.fun_gl_asf_events_pkg.reporting_ledger_delete',
490: 'completed');

Line 488: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,

484: END IF; -- Ledger passed
485:
486: IF (FND_LOG.LEVEL_PROCEDURE >= g_debug_level)
487: THEN
488: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
489: 'fun.plsql.fun_gl_asf_events_pkg.reporting_ledger_delete',
490: 'completed');
491: END IF;
492:

Line 498: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level)

494:
495: EXCEPTION
496: WHEN OTHERS THEN
497: ROLLBACK TO fun_reporting_ledger_delete;
498: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level)
499: THEN
500: fnd_log.string(FND_LOG.LEVEL_UNEXPECTED,
501: 'fun.plsql.fun_gl_asf_events_pkg.reporting_ledger_delete',
502: 'Error encountered ' || SQLERRM);

Line 500: fnd_log.string(FND_LOG.LEVEL_UNEXPECTED,

496: WHEN OTHERS THEN
497: ROLLBACK TO fun_reporting_ledger_delete;
498: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level)
499: THEN
500: fnd_log.string(FND_LOG.LEVEL_UNEXPECTED,
501: 'fun.plsql.fun_gl_asf_events_pkg.reporting_ledger_delete',
502: 'Error encountered ' || SQLERRM);
503: END IF;
504: wf_core.context (g_module,