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 FUN_GL_ASF_EVENTS_PKG

Line 1: PACKAGE BODY FUN_GL_ASF_EVENTS_PKG AS

1: PACKAGE BODY FUN_GL_ASF_EVENTS_PKG AS
2: /* $Header: funglasfevntb.pls 120.0 2006/01/13 09:23:10 bsilveir noship $ */
3:
4: g_debug_level NUMBER;
5: g_module CONSTANT VARCHAR2(80) := 'fun.plsql.fun_gl_asf_events_pkg';

Line 5: g_module CONSTANT VARCHAR2(80) := 'fun.plsql.fun_gl_asf_events_pkg';

1: PACKAGE BODY FUN_GL_ASF_EVENTS_PKG AS
2: /* $Header: funglasfevntb.pls 120.0 2006/01/13 09:23:10 bsilveir noship $ */
3:
4: g_debug_level NUMBER;
5: g_module CONSTANT VARCHAR2(80) := 'fun.plsql.fun_gl_asf_events_pkg';
6:
7: -- This procedure is invoked from the GL Accounting Setup Flow page
8: -- when a Balancing Segment Value is removed from the Ledger
9: -- Event Name = oracle.apps.gl.Setup.Ledger.BalancingSegmentValueRemove

Line 34: 'fun.plsql.fun_gl_asf_events_pkg.ledger_bsv_remove',

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:
38: IF l_ledger_id IS NULL OR l_bsv IS NULL

Line 58: 'fun.plsql.fun_gl_asf_events_pkg.ledger_bsv_remove',

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;
62:

Line 69: 'fun.plsql.fun_gl_asf_events_pkg.ledger_bsv_remove',

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:
73: RETURN l_ret_mode;

Line 81: 'fun.plsql.fun_gl_asf_events_pkg.ledger_bsv_remove',

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,
85: l_routine,

Line 120: 'fun.plsql.fun_gl_asf_events_pkg.le_bsv_remove',

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:
124: IF l_le_id IS NULL OR l_bsv IS NULL

Line 144: 'fun.plsql.fun_gl_asf_events_pkg.le_bsv_remove',

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;
148:

Line 161: 'fun.plsql.fun_gl_asf_events_pkg.le_bsv_remove',

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;
165:

Line 172: 'fun.plsql.fun_gl_asf_events_pkg.le_bsv_remove',

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:
176: RETURN l_ret_mode;

Line 184: 'fun.plsql.fun_gl_asf_events_pkg.le_bsv_remove',

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,
188: l_routine,

Line 225: 'fun.plsql.fun_gl_asf_events_pkg.ledger_le_remove',

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:
229: IF l_le_id IS NULL OR l_ledger_id IS NULL

Line 251: 'fun.plsql.fun_gl_asf_events_pkg.ledger_le_remove',

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;
255:

Line 267: 'fun.plsql.fun_gl_asf_events_pkg.ledger_le_remove',

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;
271:

Line 277: 'fun.plsql.fun_gl_asf_events_pkg.ledger_le_remove',

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:
281: RETURN l_ret_mode;

Line 289: 'fun.plsql.fun_gl_asf_events_pkg.ledger_le_remove',

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,
293: l_routine,

Line 327: 'fun.plsql.fun_gl_asf_events_pkg.secondary_ledger_delete',

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:
331: IF l_sec_ledger_id IS NULL

Line 350: 'fun.plsql.fun_gl_asf_events_pkg.secondary_ledger_delete',

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;
354:

Line 361: 'fun.plsql.fun_gl_asf_events_pkg.secondary_ledger_delete',

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;
365:

Line 372: 'fun.plsql.fun_gl_asf_events_pkg.secondary_ledger_delete',

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;
376:

Line 383: 'fun.plsql.fun_gl_asf_events_pkg.secondary_ledger_delete',

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:
387: RETURN l_ret_mode;

Line 395: 'fun.plsql.fun_gl_asf_events_pkg.secondary_ledger_delete',

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,
399: l_routine,

Line 433: 'fun.plsql.fun_gl_asf_events_pkg.reporting_ledger_delete',

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:
437: IF l_rep_ledger_id IS NULL

Line 456: 'fun.plsql.fun_gl_asf_events_pkg.reporting_ledger_delete',

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;
460:

Line 467: 'fun.plsql.fun_gl_asf_events_pkg.reporting_ledger_delete',

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;
471:

Line 478: 'fun.plsql.fun_gl_asf_events_pkg.reporting_ledger_delete',

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;
482:

Line 489: 'fun.plsql.fun_gl_asf_events_pkg.reporting_ledger_delete',

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:
493: RETURN l_ret_mode;

Line 501: 'fun.plsql.fun_gl_asf_events_pkg.reporting_ledger_delete',

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,
505: l_routine,