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.GL_ADD_RECON_UPGRADE_PKG dependencies on FND_LOG

Line 57: GL_MESSAGE.FUNC_ENT(fn_name, FND_LOG.LEVEL_PROCEDURE,

53: l_rows NUMBER := 0;
54: fn_name CONSTANT VARCHAR2(30) := 'PREPARE_RECON_UPDATE';
55: --
56: BEGIN
57: GL_MESSAGE.FUNC_ENT(fn_name, FND_LOG.LEVEL_PROCEDURE,
58: g_api || '.' || fn_name);
59: -- parameters
60: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL >= FND_LOG.LEVEL_PROCEDURE) THEN
61: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,

Line 60: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL >= FND_LOG.LEVEL_PROCEDURE) THEN

56: BEGIN
57: GL_MESSAGE.FUNC_ENT(fn_name, FND_LOG.LEVEL_PROCEDURE,
58: g_api || '.' || fn_name);
59: -- parameters
60: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL >= FND_LOG.LEVEL_PROCEDURE) THEN
61: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,
62: g_api || '.' || fn_name,
63: 'x_src_table = ' || 'gl_je_lines');
64: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,

Line 61: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,

57: GL_MESSAGE.FUNC_ENT(fn_name, FND_LOG.LEVEL_PROCEDURE,
58: g_api || '.' || fn_name);
59: -- parameters
60: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL >= FND_LOG.LEVEL_PROCEDURE) THEN
61: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,
62: g_api || '.' || fn_name,
63: 'x_src_table = ' || 'gl_je_lines');
64: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,
65: g_api || '.' || fn_name,

Line 64: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,

60: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL >= FND_LOG.LEVEL_PROCEDURE) THEN
61: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,
62: g_api || '.' || fn_name,
63: 'x_src_table = ' || 'gl_je_lines');
64: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,
65: g_api || '.' || fn_name,
66: 'x_start_id = ' || x_start_id);
67: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,
68: g_api || '.' || fn_name,

Line 67: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,

63: 'x_src_table = ' || 'gl_je_lines');
64: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,
65: g_api || '.' || fn_name,
66: 'x_start_id = ' || x_start_id);
67: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,
68: g_api || '.' || fn_name,
69: 'x_end_id = ' || x_end_id);
70: END IF;
71: --

Line 75: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL >= FND_LOG.LEVEL_PROCEDURE) THEN

71: --
72: EXECUTE IMMEDIATE g_std_ins USING x_start_id, x_end_id;
73: l_rows := SQL%ROWCOUNT;
74: --
75: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL >= FND_LOG.LEVEL_PROCEDURE) THEN
76: GL_MESSAGE.FUNC_SUCC(fn_name, FND_LOG.LEVEL_PROCEDURE,
77: g_api || '.' || fn_name);
78: END IF;
79: RETURN l_rows;

Line 76: GL_MESSAGE.FUNC_SUCC(fn_name, FND_LOG.LEVEL_PROCEDURE,

72: EXECUTE IMMEDIATE g_std_ins USING x_start_id, x_end_id;
73: l_rows := SQL%ROWCOUNT;
74: --
75: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL >= FND_LOG.LEVEL_PROCEDURE) THEN
76: GL_MESSAGE.FUNC_SUCC(fn_name, FND_LOG.LEVEL_PROCEDURE,
77: g_api || '.' || fn_name);
78: END IF;
79: RETURN l_rows;
80: EXCEPTION

Line 82: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL >= FND_LOG.LEVEL_PROCEDURE) THEN

78: END IF;
79: RETURN l_rows;
80: EXCEPTION
81: WHEN OTHERS THEN
82: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL >= FND_LOG.LEVEL_PROCEDURE) THEN
83: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_UNEXPECTED,
84: g_api || '.' || fn_name,
85: SUBSTR(SQLERRM, 1, 4000));
86: GL_MESSAGE.FUNC_FAIL(fn_name, FND_LOG.LEVEL_UNEXPECTED,

Line 83: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_UNEXPECTED,

79: RETURN l_rows;
80: EXCEPTION
81: WHEN OTHERS THEN
82: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL >= FND_LOG.LEVEL_PROCEDURE) THEN
83: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_UNEXPECTED,
84: g_api || '.' || fn_name,
85: SUBSTR(SQLERRM, 1, 4000));
86: GL_MESSAGE.FUNC_FAIL(fn_name, FND_LOG.LEVEL_UNEXPECTED,
87: g_api || '.' || fn_name);

Line 86: GL_MESSAGE.FUNC_FAIL(fn_name, FND_LOG.LEVEL_UNEXPECTED,

82: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL >= FND_LOG.LEVEL_PROCEDURE) THEN
83: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_UNEXPECTED,
84: g_api || '.' || fn_name,
85: SUBSTR(SQLERRM, 1, 4000));
86: GL_MESSAGE.FUNC_FAIL(fn_name, FND_LOG.LEVEL_UNEXPECTED,
87: g_api || '.' || fn_name);
88: END IF;
89: RAISE;
90: RETURN l_rows;

Line 114: GL_MESSAGE.FUNC_ENT(fn_name, FND_LOG.LEVEL_PROCEDURE,

110: l_table_owner VARCHAR2(30);
111: l_gl_schema VARCHAR2(30);
112: l_applsys_schema VARCHAR2(30);
113: BEGIN
114: GL_MESSAGE.FUNC_ENT(fn_name, FND_LOG.LEVEL_PROCEDURE,
115: g_api || '.' || fn_name);
116: -- parameters
117: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL >= FND_LOG.LEVEL_PROCEDURE) THEN
118: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,

Line 117: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL >= FND_LOG.LEVEL_PROCEDURE) THEN

113: BEGIN
114: GL_MESSAGE.FUNC_ENT(fn_name, FND_LOG.LEVEL_PROCEDURE,
115: g_api || '.' || fn_name);
116: -- parameters
117: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL >= FND_LOG.LEVEL_PROCEDURE) THEN
118: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,
119: g_api || '.' || fn_name,
120: 'x_batch_size = ' || x_batch_size);
121: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,

Line 118: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,

114: GL_MESSAGE.FUNC_ENT(fn_name, FND_LOG.LEVEL_PROCEDURE,
115: g_api || '.' || fn_name);
116: -- parameters
117: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL >= FND_LOG.LEVEL_PROCEDURE) THEN
118: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,
119: g_api || '.' || fn_name,
120: 'x_batch_size = ' || x_batch_size);
121: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,
122: g_api || '.' || fn_name,

Line 121: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,

117: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL >= FND_LOG.LEVEL_PROCEDURE) THEN
118: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,
119: g_api || '.' || fn_name,
120: 'x_batch_size = ' || x_batch_size);
121: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,
122: g_api || '.' || fn_name,
123: 'x_num_workers = ' || x_num_workers);
124: END IF;
125: -- AD_CONC_UTILS_PKG.submit_subrequests sets request data

Line 198: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL >= FND_LOG.LEVEL_PROCEDURE) THEN

194: END IF;
195: --
196: END IF;
197: --
198: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL >= FND_LOG.LEVEL_PROCEDURE) THEN
199: GL_MESSAGE.FUNC_SUCC(fn_name, FND_LOG.LEVEL_PROCEDURE,
200: g_api || '.' || fn_name);
201: END IF;
202: --

Line 199: GL_MESSAGE.FUNC_SUCC(fn_name, FND_LOG.LEVEL_PROCEDURE,

195: --
196: END IF;
197: --
198: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL >= FND_LOG.LEVEL_PROCEDURE) THEN
199: GL_MESSAGE.FUNC_SUCC(fn_name, FND_LOG.LEVEL_PROCEDURE,
200: g_api || '.' || fn_name);
201: END IF;
202: --
203: EXCEPTION

Line 206: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL >= FND_LOG.LEVEL_PROCEDURE) THEN

202: --
203: EXCEPTION
204: WHEN SUBMIT_REQ_ERROR THEN
205: x_retcode := AD_CONC_UTILS_PKG.CONC_FAIL;
206: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL >= FND_LOG.LEVEL_PROCEDURE) THEN
207: GL_MESSAGE.WRITE_LOG(msg_name => 'SHRD0055',
208: token_num => 1,
209: t1 => 'ROUTINE',
210: v1 => fn_name,

Line 211: log_level => FND_LOG.LEVEL_PROCEDURE,

207: GL_MESSAGE.WRITE_LOG(msg_name => 'SHRD0055',
208: token_num => 1,
209: t1 => 'ROUTINE',
210: v1 => fn_name,
211: log_level => FND_LOG.LEVEL_PROCEDURE,
212: module => g_api || '.' || fn_name);
213: GL_MESSAGE.FUNC_FAIL(fn_name, FND_LOG.LEVEL_UNEXPECTED,
214: g_api || '.' || fn_name);
215: END IF;

Line 213: GL_MESSAGE.FUNC_FAIL(fn_name, FND_LOG.LEVEL_UNEXPECTED,

209: t1 => 'ROUTINE',
210: v1 => fn_name,
211: log_level => FND_LOG.LEVEL_PROCEDURE,
212: module => g_api || '.' || fn_name);
213: GL_MESSAGE.FUNC_FAIL(fn_name, FND_LOG.LEVEL_UNEXPECTED,
214: g_api || '.' || fn_name);
215: END IF;
216: RAISE;
217: WHEN OTHERS THEN

Line 219: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL >= FND_LOG.LEVEL_PROCEDURE) THEN

215: END IF;
216: RAISE;
217: WHEN OTHERS THEN
218: x_retcode := AD_CONC_UTILS_PKG.CONC_FAIL;
219: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL >= FND_LOG.LEVEL_PROCEDURE) THEN
220: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_UNEXPECTED,
221: g_api || '.' || fn_name,
222: SUBSTR(SQLERRM, 1, 4000));
223: GL_MESSAGE.FUNC_FAIL(fn_name, FND_LOG.LEVEL_UNEXPECTED,

Line 220: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_UNEXPECTED,

216: RAISE;
217: WHEN OTHERS THEN
218: x_retcode := AD_CONC_UTILS_PKG.CONC_FAIL;
219: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL >= FND_LOG.LEVEL_PROCEDURE) THEN
220: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_UNEXPECTED,
221: g_api || '.' || fn_name,
222: SUBSTR(SQLERRM, 1, 4000));
223: GL_MESSAGE.FUNC_FAIL(fn_name, FND_LOG.LEVEL_UNEXPECTED,
224: g_api || '.' || fn_name);

Line 223: GL_MESSAGE.FUNC_FAIL(fn_name, FND_LOG.LEVEL_UNEXPECTED,

219: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL >= FND_LOG.LEVEL_PROCEDURE) THEN
220: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_UNEXPECTED,
221: g_api || '.' || fn_name,
222: SUBSTR(SQLERRM, 1, 4000));
223: GL_MESSAGE.FUNC_FAIL(fn_name, FND_LOG.LEVEL_UNEXPECTED,
224: g_api || '.' || fn_name);
225: END IF;
226: RAISE;
227: END upgrade_recon;

Line 249: GL_MESSAGE.FUNC_ENT(fn_name, FND_LOG.LEVEL_PROCEDURE,

245: FND_FILE.PUT_LINE(FND_FILE.LOG, 'X_Num_Workers : ' || X_Num_Workers);
246: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Session Id : ' ||
247: FND_GLOBAL.session_id);
248: --
249: GL_MESSAGE.FUNC_ENT(fn_name, FND_LOG.LEVEL_PROCEDURE,
250: g_api || '.' || fn_name);
251: -- parameters
252: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL >= FND_LOG.LEVEL_PROCEDURE) THEN
253: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,

Line 252: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL >= FND_LOG.LEVEL_PROCEDURE) THEN

248: --
249: GL_MESSAGE.FUNC_ENT(fn_name, FND_LOG.LEVEL_PROCEDURE,
250: g_api || '.' || fn_name);
251: -- parameters
252: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL >= FND_LOG.LEVEL_PROCEDURE) THEN
253: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,
254: g_api || '.' || fn_name,
255: 'x_batch_size = ' || x_batch_size);
256: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,

Line 253: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,

249: GL_MESSAGE.FUNC_ENT(fn_name, FND_LOG.LEVEL_PROCEDURE,
250: g_api || '.' || fn_name);
251: -- parameters
252: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL >= FND_LOG.LEVEL_PROCEDURE) THEN
253: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,
254: g_api || '.' || fn_name,
255: 'x_batch_size = ' || x_batch_size);
256: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,
257: g_api || '.' || fn_name,

Line 256: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,

252: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL >= FND_LOG.LEVEL_PROCEDURE) THEN
253: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,
254: g_api || '.' || fn_name,
255: 'x_batch_size = ' || x_batch_size);
256: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_PROCEDURE,
257: g_api || '.' || fn_name,
258: 'x_argument4 = ' || x_argument4);
259: END IF;
260: --

Line 303: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL >= FND_LOG.LEVEL_PROCEDURE) THEN

299: --
300: end loop;
301: --
302: x_retcode := AD_CONC_UTILS_PKG.CONC_SUCCESS;
303: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL >= FND_LOG.LEVEL_PROCEDURE) THEN
304: GL_MESSAGE.FUNC_SUCC(fn_name, FND_LOG.LEVEL_PROCEDURE,
305: g_api || '.' || fn_name);
306: END IF;
307: EXCEPTION

Line 304: GL_MESSAGE.FUNC_SUCC(fn_name, FND_LOG.LEVEL_PROCEDURE,

300: end loop;
301: --
302: x_retcode := AD_CONC_UTILS_PKG.CONC_SUCCESS;
303: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL >= FND_LOG.LEVEL_PROCEDURE) THEN
304: GL_MESSAGE.FUNC_SUCC(fn_name, FND_LOG.LEVEL_PROCEDURE,
305: g_api || '.' || fn_name);
306: END IF;
307: EXCEPTION
308: WHEN OTHERS THEN

Line 311: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL >= FND_LOG.LEVEL_PROCEDURE) THEN

307: EXCEPTION
308: WHEN OTHERS THEN
309: x_errbuf := SUBSTR(SQLERRM, 1, 240);
310: x_retcode := AD_CONC_UTILS_PKG.CONC_FAIL;
311: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL >= FND_LOG.LEVEL_PROCEDURE) THEN
312: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_UNEXPECTED,
313: g_api || '.' || fn_name,
314: SUBSTR(SQLERRM, 1, 4000));
315: GL_MESSAGE.FUNC_FAIL(fn_name, FND_LOG.LEVEL_UNEXPECTED,

Line 312: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_UNEXPECTED,

308: WHEN OTHERS THEN
309: x_errbuf := SUBSTR(SQLERRM, 1, 240);
310: x_retcode := AD_CONC_UTILS_PKG.CONC_FAIL;
311: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL >= FND_LOG.LEVEL_PROCEDURE) THEN
312: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_UNEXPECTED,
313: g_api || '.' || fn_name,
314: SUBSTR(SQLERRM, 1, 4000));
315: GL_MESSAGE.FUNC_FAIL(fn_name, FND_LOG.LEVEL_UNEXPECTED,
316: g_api || '.' || fn_name);

Line 315: GL_MESSAGE.FUNC_FAIL(fn_name, FND_LOG.LEVEL_UNEXPECTED,

311: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL >= FND_LOG.LEVEL_PROCEDURE) THEN
312: GL_MESSAGE.WRITE_FNDLOG_STRING(FND_LOG.LEVEL_UNEXPECTED,
313: g_api || '.' || fn_name,
314: SUBSTR(SQLERRM, 1, 4000));
315: GL_MESSAGE.FUNC_FAIL(fn_name, FND_LOG.LEVEL_UNEXPECTED,
316: g_api || '.' || fn_name);
317: END IF;
318: RAISE;
319: END update_gl_je_lines_recon_table;