APPS.JA_CN_UPDATE_JL_SEQ_PKG dependencies on FND_LOG

Line 28: g_dbg_level NUMBER := FND_LOG.G_Current_Runtime_Level;

24: --+======================================================================*/
25:
26: --==== Golbal Variables ============
27: g_module_name VARCHAR2(30) := 'JA_CN_UPDATE_JL_SEQ_PKG';
28: g_dbg_level NUMBER := FND_LOG.G_Current_Runtime_Level;
29: g_proc_level NUMBER := FND_LOG.Level_Procedure;
30: g_stmt_level NUMBER := FND_LOG.Level_Statement;
31:
32: --==========================================================================

Line 29: g_proc_level NUMBER := FND_LOG.Level_Procedure;

25:
26: --==== Golbal Variables ============
27: g_module_name VARCHAR2(30) := 'JA_CN_UPDATE_JL_SEQ_PKG';
28: g_dbg_level NUMBER := FND_LOG.G_Current_Runtime_Level;
29: g_proc_level NUMBER := FND_LOG.Level_Procedure;
30: g_stmt_level NUMBER := FND_LOG.Level_Statement;
31:
32: --==========================================================================
33: -- PROCEDURE NAME:

Line 30: g_stmt_level NUMBER := FND_LOG.Level_Statement;

26: --==== Golbal Variables ============
27: g_module_name VARCHAR2(30) := 'JA_CN_UPDATE_JL_SEQ_PKG';
28: g_dbg_level NUMBER := FND_LOG.G_Current_Runtime_Level;
29: g_proc_level NUMBER := FND_LOG.Level_Procedure;
30: g_stmt_level NUMBER := FND_LOG.Level_Statement;
31:
32: --==========================================================================
33: -- PROCEDURE NAME:
34: -- Create_JL_Seq Private

Line 61: FND_LOG.STRING(g_proc_level,

57:
58: BEGIN
59: --log for debug
60: IF (g_proc_level >= g_dbg_level) THEN
61: FND_LOG.STRING(g_proc_level,
62: g_module_name || '.' || l_procedure_name || '.begin',
63: 'begin procedure');
64: END IF; --( g_proc_level >= g_dbg_level)
65:

Line 90: FND_LOG.STRING(g_proc_level,

86: fnd_global.LOGIN_ID);
87:
88: --log for debug
89: IF (g_proc_level >= g_dbg_level) THEN
90: FND_LOG.STRING(g_proc_level,
91: g_module_name || '.' || l_procedure_name || '.end',
92: 'end procedure');
93: END IF; --( g_proc_level >= g_dbg_level)
94:

Line 97: IF (FND_LOG.LEVEL_UNEXPECTED >= g_dbg_level) THEN

93: END IF; --( g_proc_level >= g_dbg_level)
94:
95: EXCEPTION
96: WHEN OTHERS THEN
97: IF (FND_LOG.LEVEL_UNEXPECTED >= g_dbg_level) THEN
98: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
99: g_module_name || ',' || l_procedure_name ||
100: '.OTHER_EXCEPTION',
101: SQLCODE || ':' || SQLERRM);

Line 98: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

94:
95: EXCEPTION
96: WHEN OTHERS THEN
97: IF (FND_LOG.LEVEL_UNEXPECTED >= g_dbg_level) THEN
98: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
99: g_module_name || ',' || l_procedure_name ||
100: '.OTHER_EXCEPTION',
101: SQLCODE || ':' || SQLERRM);
102: END IF;

Line 139: FND_LOG.STRING(g_proc_level,

135:
136: BEGIN
137: --log for debug
138: IF (g_proc_level >= g_dbg_level) THEN
139: FND_LOG.STRING(g_proc_level,
140: g_module_name || '.' || l_procedure_name || '.begin',
141: 'begin procedure');
142: END IF; --( g_proc_level >= g_dbg_level)
143:

Line 156: FND_LOG.STRING(g_proc_level,

152: AND jcjn.period_name = p_period_name;
153:
154: --log for debug
155: IF (g_proc_level >= g_dbg_level) THEN
156: FND_LOG.STRING(g_proc_level,
157: g_module_name || '.' || l_procedure_name || '.end',
158: 'end procedure');
159: END IF; --( g_proc_level >= g_dbg_level)
160:

Line 163: IF (FND_LOG.LEVEL_UNEXPECTED >= g_dbg_level) THEN

159: END IF; --( g_proc_level >= g_dbg_level)
160:
161: EXCEPTION
162: WHEN OTHERS THEN
163: IF (FND_LOG.LEVEL_UNEXPECTED >= g_dbg_level) THEN
164: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
165: g_module_name || ',' || l_procedure_name ||
166: '.OTHER_EXCEPTION',
167: SQLCODE || ':' || SQLERRM);

Line 164: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

160:
161: EXCEPTION
162: WHEN OTHERS THEN
163: IF (FND_LOG.LEVEL_UNEXPECTED >= g_dbg_level) THEN
164: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
165: g_module_name || ',' || l_procedure_name ||
166: '.OTHER_EXCEPTION',
167: SQLCODE || ':' || SQLERRM);
168: END IF;

Line 214: FND_LOG.STRING(g_proc_level,

210: BEGIN
211:
212: --log for debug
213: IF (g_proc_level >= g_dbg_level) THEN
214: FND_LOG.STRING(g_proc_level,
215: g_module_name || '.' || l_procedure_name || '.begin',
216: 'begin procedure');
217: END IF; --( g_proc_level >= g_dbg_level)
218:

Line 243: FND_LOG.STRING(g_proc_level,

239: END IF; --c_sequence%NOTFOUND
240:
241: --log for debug
242: IF (g_proc_level >= g_dbg_level) THEN
243: FND_LOG.STRING(g_proc_level,
244: g_module_name || '.' || l_procedure_name || '.end',
245: 'end procedure');
246: END IF; --( g_proc_level >= g_dbg_level)
247:

Line 251: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level) THEN

247:
248: EXCEPTION
249: WHEN l_exc_invalid_argument THEN
250: /*
251: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level) THEN
252: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
253: g_module_prefix ||','|| l_procedure_name ||
254: '.INVALID_ARGUMENT',
255: 'invalid_argument';

Line 252: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

248: EXCEPTION
249: WHEN l_exc_invalid_argument THEN
250: /*
251: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level) THEN
252: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
253: g_module_prefix ||','|| l_procedure_name ||
254: '.INVALID_ARGUMENT',
255: 'invalid_argument';
256: END IF;