40: g_rec_transferred NUMBER := 0;
41: g_cnt_transfer_errors NUMBER := 0;
42: g_cnt_acct_errors NUMBER := 0;
43:
44: C_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
45: C_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
46: C_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
47: C_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
48: C_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
41: g_cnt_transfer_errors NUMBER := 0;
42: g_cnt_acct_errors NUMBER := 0;
43:
44: C_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
45: C_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
46: C_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
47: C_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
48: C_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
49: C_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
42: g_cnt_acct_errors NUMBER := 0;
43:
44: C_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
45: C_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
46: C_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
47: C_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
48: C_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
49: C_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
50:
43:
44: C_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
45: C_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
46: C_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
47: C_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
48: C_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
49: C_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
50:
51: C_LEVEL_LOG_DISABLED CONSTANT NUMBER := 99;
44: C_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
45: C_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
46: C_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
47: C_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
48: C_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
49: C_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
50:
51: C_LEVEL_LOG_DISABLED CONSTANT NUMBER := 99;
52: C_DEFAULT_MODULE CONSTANT VARCHAR2(240) := 'xla.plsql.xla_gl_transfer_pkg';
45: C_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
46: C_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
47: C_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
48: C_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
49: C_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
50:
51: C_LEVEL_LOG_DISABLED CONSTANT NUMBER := 99;
52: C_DEFAULT_MODULE CONSTANT VARCHAR2(240) := 'xla.plsql.xla_gl_transfer_pkg';
53:
62: ,p_module IN VARCHAR2 ) IS
63: l_log_module VARCHAR2(255);
64: BEGIN
65: IF (p_msg IS NULL AND p_level >= g_log_level) THEN
66: fnd_log.message(p_level, NVL(p_module,C_DEFAULT_MODULE));
67: ELSIF p_level >= g_log_level THEN
68: fnd_log.string(p_level, NVL(p_module,C_DEFAULT_MODULE), p_msg);
69: END IF;
70:
64: BEGIN
65: IF (p_msg IS NULL AND p_level >= g_log_level) THEN
66: fnd_log.message(p_level, NVL(p_module,C_DEFAULT_MODULE));
67: ELSIF p_level >= g_log_level THEN
68: fnd_log.string(p_level, NVL(p_module,C_DEFAULT_MODULE), p_msg);
69: END IF;
70:
71: EXCEPTION
72: WHEN OTHERS THEN
69: END IF;
70:
71: EXCEPTION
72: WHEN OTHERS THEN
73: IF g_log_level <= FND_LOG.LEVEL_UNEXPECTED THEN
74: fnd_log.string(LOG_LEVEL => FND_LOG.LEVEL_UNEXPECTED,
75: MODULE => NVL(p_module,C_DEFAULT_MODULE),
76: MESSAGE => 'Unexpected Error While Executing ' || p_module );
77: END IF;
70:
71: EXCEPTION
72: WHEN OTHERS THEN
73: IF g_log_level <= FND_LOG.LEVEL_UNEXPECTED THEN
74: fnd_log.string(LOG_LEVEL => FND_LOG.LEVEL_UNEXPECTED,
75: MODULE => NVL(p_module,C_DEFAULT_MODULE),
76: MESSAGE => 'Unexpected Error While Executing ' || p_module );
77: END IF;
78: END trace;
265:
266: RETURN (l_linkid);
267: EXCEPTION
268: WHEN OTHERS THEN
269: IF g_log_level <= FND_LOG.LEVEL_UNEXPECTED THEN
270: fnd_log.string(FND_LOG.LEVEL_UNEXPECTED,
271: l_log_module,
272: 'Unexpected Error While Executing ' || l_log_module);
273: END IF;
266: RETURN (l_linkid);
267: EXCEPTION
268: WHEN OTHERS THEN
269: IF g_log_level <= FND_LOG.LEVEL_UNEXPECTED THEN
270: fnd_log.string(FND_LOG.LEVEL_UNEXPECTED,
271: l_log_module,
272: 'Unexpected Error While Executing ' || l_log_module);
273: END IF;
274: END get_linkid;
517: END IF;
518:
519: EXCEPTION
520: WHEN OTHERS THEN
521: IF g_log_level <= FND_LOG.LEVEL_UNEXPECTED THEN
522: fnd_log.string(FND_LOG.LEVEL_UNEXPECTED,
523: l_log_module,
524: 'Unexpected Error While Executing ' || l_log_module);
525: END IF;
518:
519: EXCEPTION
520: WHEN OTHERS THEN
521: IF g_log_level <= FND_LOG.LEVEL_UNEXPECTED THEN
522: fnd_log.string(FND_LOG.LEVEL_UNEXPECTED,
523: l_log_module,
524: 'Unexpected Error While Executing ' || l_log_module);
525: END IF;
526: END get_date_range;
2078: END IF;
2079:
2080: EXCEPTION
2081: WHEN OTHERS THEN
2082: IF g_log_level <= FND_LOG.LEVEL_UNEXPECTED THEN
2083: fnd_log.string(FND_LOG.LEVEL_UNEXPECTED,
2084: l_log_module,
2085: 'Unexpected Error While Executing ' || l_log_module);
2086: END IF;
2079:
2080: EXCEPTION
2081: WHEN OTHERS THEN
2082: IF g_log_level <= FND_LOG.LEVEL_UNEXPECTED THEN
2083: fnd_log.string(FND_LOG.LEVEL_UNEXPECTED,
2084: l_log_module,
2085: 'Unexpected Error While Executing ' || l_log_module);
2086: END IF;
2087: END get_funds_check_flag;
2131: END IF;
2132:
2133: EXCEPTION
2134: WHEN OTHERS THEN
2135: IF g_log_level <= FND_LOG.LEVEL_UNEXPECTED THEN
2136: fnd_log.string(FND_LOG.LEVEL_UNEXPECTED,
2137: l_log_module,
2138: 'Unexpected Error While Executing ' || l_log_module);
2139: END IF;
2132:
2133: EXCEPTION
2134: WHEN OTHERS THEN
2135: IF g_log_level <= FND_LOG.LEVEL_UNEXPECTED THEN
2136: fnd_log.string(FND_LOG.LEVEL_UNEXPECTED,
2137: l_log_module,
2138: 'Unexpected Error While Executing ' || l_log_module);
2139: END IF;
2140: END derive_line_types;
3375: RAISE;
3376: END XLA_GL_TRANSFER;
3377:
3378: BEGIN
3379: g_log_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
3380: g_log_enabled := fnd_log.test
3381: (log_level => g_log_level
3382: ,module => C_DEFAULT_MODULE);
3383:
3376: END XLA_GL_TRANSFER;
3377:
3378: BEGIN
3379: g_log_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
3380: g_log_enabled := fnd_log.test
3381: (log_level => g_log_level
3382: ,module => C_DEFAULT_MODULE);
3383:
3384: IF NOT g_log_enabled THEN