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;
2075: END IF;
2076:
2077: EXCEPTION
2078: WHEN OTHERS THEN
2079: IF g_log_level <= FND_LOG.LEVEL_UNEXPECTED THEN
2080: fnd_log.string(FND_LOG.LEVEL_UNEXPECTED,
2081: l_log_module,
2082: 'Unexpected Error While Executing ' || l_log_module);
2083: END IF;
2076:
2077: EXCEPTION
2078: WHEN OTHERS THEN
2079: IF g_log_level <= FND_LOG.LEVEL_UNEXPECTED THEN
2080: fnd_log.string(FND_LOG.LEVEL_UNEXPECTED,
2081: l_log_module,
2082: 'Unexpected Error While Executing ' || l_log_module);
2083: END IF;
2084: END get_funds_check_flag;
2128: END IF;
2129:
2130: EXCEPTION
2131: WHEN OTHERS THEN
2132: IF g_log_level <= FND_LOG.LEVEL_UNEXPECTED THEN
2133: fnd_log.string(FND_LOG.LEVEL_UNEXPECTED,
2134: l_log_module,
2135: 'Unexpected Error While Executing ' || l_log_module);
2136: END IF;
2129:
2130: EXCEPTION
2131: WHEN OTHERS THEN
2132: IF g_log_level <= FND_LOG.LEVEL_UNEXPECTED THEN
2133: fnd_log.string(FND_LOG.LEVEL_UNEXPECTED,
2134: l_log_module,
2135: 'Unexpected Error While Executing ' || l_log_module);
2136: END IF;
2137: END derive_line_types;
3363: RAISE;
3364: END XLA_GL_TRANSFER;
3365:
3366: BEGIN
3367: g_log_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
3368: g_log_enabled := fnd_log.test
3369: (log_level => g_log_level
3370: ,module => C_DEFAULT_MODULE);
3371:
3364: END XLA_GL_TRANSFER;
3365:
3366: BEGIN
3367: g_log_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
3368: g_log_enabled := fnd_log.test
3369: (log_level => g_log_level
3370: ,module => C_DEFAULT_MODULE);
3371:
3372: IF NOT g_log_enabled THEN