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

Line 29: g_dbg_level NUMBER := FND_LOG.G_Current_Runtime_Level;

25: --+======================================================================*/
26:
27: --==== Golbal Variables ============
28: g_module_name VARCHAR2(30) := 'JA_CN_EAB_EXPORT_PKG';
29: g_dbg_level NUMBER := FND_LOG.G_Current_Runtime_Level;
30: g_proc_level NUMBER := FND_LOG.Level_Procedure;
31: g_stmt_level NUMBER := FND_LOG.Level_Statement;
32: g_ledger_id GL_LEDGERS.Ledger_Id%TYPE;
33: g_book_num JA_CN_SYSTEM_PARAMETERS_ALL.BOOK_NUM%TYPE;

Line 30: g_proc_level NUMBER := FND_LOG.Level_Procedure;

26:
27: --==== Golbal Variables ============
28: g_module_name VARCHAR2(30) := 'JA_CN_EAB_EXPORT_PKG';
29: g_dbg_level NUMBER := FND_LOG.G_Current_Runtime_Level;
30: g_proc_level NUMBER := FND_LOG.Level_Procedure;
31: g_stmt_level NUMBER := FND_LOG.Level_Statement;
32: g_ledger_id GL_LEDGERS.Ledger_Id%TYPE;
33: g_book_num JA_CN_SYSTEM_PARAMETERS_ALL.BOOK_NUM%TYPE;
34: g_book_name JA_CN_SYSTEM_PARAMETERS_ALL.BOOK_NAME%TYPE;

Line 31: g_stmt_level NUMBER := FND_LOG.Level_Statement;

27: --==== Golbal Variables ============
28: g_module_name VARCHAR2(30) := 'JA_CN_EAB_EXPORT_PKG';
29: g_dbg_level NUMBER := FND_LOG.G_Current_Runtime_Level;
30: g_proc_level NUMBER := FND_LOG.Level_Procedure;
31: g_stmt_level NUMBER := FND_LOG.Level_Statement;
32: g_ledger_id GL_LEDGERS.Ledger_Id%TYPE;
33: g_book_num JA_CN_SYSTEM_PARAMETERS_ALL.BOOK_NUM%TYPE;
34: g_book_name JA_CN_SYSTEM_PARAMETERS_ALL.BOOK_NAME%TYPE;
35: g_company_name JA_CN_SYSTEM_PARAMETERS_ALL.COMPANY_NAME%TYPE;

Line 73: FND_LOG.STRING(g_proc_level,

69:
70: BEGIN
71: --log for debug
72: IF (g_proc_level >= g_dbg_level) THEN
73: FND_LOG.STRING(g_proc_level,
74: g_module_name || '.' || l_procedure_name || '.begin',
75: 'begin procedure');
76: END IF; --( g_proc_level >= g_dbg_level)
77:

Line 106: FND_LOG.STRING(g_proc_level,

102:
103:
104: --log for debug
105: IF (g_proc_level >= g_dbg_level) THEN
106: FND_LOG.STRING(g_proc_level,
107: g_module_name || '.' || l_procedure_name || '.end',
108: 'end procedure');
109: END IF; --( g_proc_level >= g_dbg_level)
110:

Line 149: FND_LOG.STRING(g_proc_level,

145: BEGIN
146: --log for debug
147: IF (g_proc_level >= g_dbg_level)
148: THEN
149: FND_LOG.STRING(g_proc_level,
150: g_module_name || '.' || l_procedure_name || '.begin',
151: 'begin procedure');
152: END IF; --( g_proc_level >= g_dbg_level)
153:

Line 192: FND_LOG.STRING(g_proc_level,

188:
189: --log for debug
190: IF (g_proc_level >= g_dbg_level)
191: THEN
192: FND_LOG.STRING(g_proc_level,
193: g_module_name || '.' || l_procedure_name || '.end',
194: 'end procedure');
195: END IF; --( g_proc_level >= g_dbg_level)
196:

Line 202: IF (FND_LOG.LEVEL_UNEXPECTED >= g_dbg_level)

198: /* WHEN NO_DATA_FOUND THEN
199: RAISE;
200:
201: WHEN OTHERS THEN
202: IF (FND_LOG.LEVEL_UNEXPECTED >= g_dbg_level)
203: THEN
204: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
205: g_module_name || l_procedure_name ||
206: '.OTHER_EXCEPTION',

Line 204: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

200:
201: WHEN OTHERS THEN
202: IF (FND_LOG.LEVEL_UNEXPECTED >= g_dbg_level)
203: THEN
204: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
205: g_module_name || l_procedure_name ||
206: '.OTHER_EXCEPTION',
207: SQLCODE || ':' || SQLERRM);
208: END IF;

Line 220: FND_LOG.String( g_proc_level,

216: FND_FILE.put_line(FND_FILE.output, l_msg_miss_book_info);
217:
218: IF (g_proc_level >= g_dbg_level)
219: THEN
220: FND_LOG.String( g_proc_level,
221: g_module_name || '.' || l_procedure_name||'.JA_CN_MISSING_BOOK_INFO '
222: ,l_msg_miss_book_info);
223: END IF;
224: RAISE;

Line 235: FND_LOG.String( g_proc_level,

231: FND_FILE.put_line(FND_FILE.output, l_msg_miss_book_info);
232:
233: IF (g_proc_level >= g_dbg_level)
234: THEN
235: FND_LOG.String( g_proc_level,
236: g_module_name || '.' || l_procedure_name||'.JA_CN_MISSING_BOOK_INFO '
237: ,l_msg_miss_book_info);
238: END IF;
239: RAISE;

Line 245: FND_LOG.String( g_proc_level,

241: --errbuf := l_msg_miss_book_info;
242: WHEN OTHERS THEN
243: IF (g_proc_level >= g_dbg_level)
244: THEN
245: FND_LOG.String( g_proc_level,
246: g_module_name || '.' || l_procedure_name||'.Other_Exception '
247: ,SQLCODE||':'||SQLERRM
248: );
249: END IF; --(l_proc_level >= l_dbg_level)

Line 279: FND_LOG.STRING(g_proc_level,

275: BEGIN
276: --log for debug
277: l_ledger_id := P_LEDGER_ID;
278: IF (g_proc_level >= g_dbg_level) THEN
279: FND_LOG.STRING(g_proc_level,
280: g_module_name || '.' || l_procedure_name || '.begin',
281: 'begin procedure');
282: END IF; --( g_proc_level >= g_dbg_level)
283:

Line 294: FND_LOG.STRING(g_proc_level,

290: AND ledger.ledger_id = P_LEDGER_ID;
291:
292: --log for debug
293: IF (g_proc_level >= g_dbg_level) THEN
294: FND_LOG.STRING(g_proc_level,
295: g_module_name || '.' || l_procedure_name || '.end',
296: 'end procedure');
297: END IF; --( g_proc_level >= g_dbg_level)
298:

Line 301: IF (FND_LOG.LEVEL_UNEXPECTED >= g_dbg_level)

297: END IF; --( g_proc_level >= g_dbg_level)
298:
299: EXCEPTION
300: WHEN NO_DATA_FOUND THEN
301: IF (FND_LOG.LEVEL_UNEXPECTED >= g_dbg_level)
302: THEN
303: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
304: g_module_name || l_procedure_name ||
305: '.NO_DATA_FOUND',

Line 303: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

299: EXCEPTION
300: WHEN NO_DATA_FOUND THEN
301: IF (FND_LOG.LEVEL_UNEXPECTED >= g_dbg_level)
302: THEN
303: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
304: g_module_name || l_procedure_name ||
305: '.NO_DATA_FOUND',
306: SQLCODE || ':' || SQLERRM);
307: END IF;

Line 310: IF (FND_LOG.LEVEL_UNEXPECTED >= g_dbg_level)

306: SQLCODE || ':' || SQLERRM);
307: END IF;
308: RAISE;
309: WHEN OTHERS THEN
310: IF (FND_LOG.LEVEL_UNEXPECTED >= g_dbg_level)
311: THEN
312: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
313: g_module_name || l_procedure_name ||
314: '.OTHER_EXCEPTION',

Line 312: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

308: RAISE;
309: WHEN OTHERS THEN
310: IF (FND_LOG.LEVEL_UNEXPECTED >= g_dbg_level)
311: THEN
312: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
313: g_module_name || l_procedure_name ||
314: '.OTHER_EXCEPTION',
315: SQLCODE || ':' || SQLERRM);
316: END IF;

Line 343: FND_LOG.STRING(g_proc_level,

339: l_procedure_name VARCHAR2(30) := 'Query_Software_Infor';
340: BEGIN
341: --log for debug
342: IF (g_proc_level >= g_dbg_level) THEN
343: FND_LOG.STRING(g_proc_level,
344: g_module_name || '.' || l_procedure_name || '.begin',
345: 'begin procedure');
346: END IF; --( g_proc_level >= g_dbg_level)
347:

Line 373: FND_LOG.STRING(g_proc_level,

369: AND major_version IN (SELECT MAX(major_version) FROM ad_releases);
370:
371: --log for debug
372: IF (g_proc_level >= g_dbg_level) THEN
373: FND_LOG.STRING(g_proc_level,
374: g_module_name || '.' || l_procedure_name || '.end',
375: 'end procedure');
376: END IF; --( g_proc_level >= g_dbg_level)
377:

Line 423: FND_LOG.STRING(g_proc_level,

419: -- check parameter
420:
421: --log for debug
422: IF (g_proc_level >= g_dbg_level) THEN
423: FND_LOG.STRING(g_proc_level,
424: g_module_name || '.' || l_procedure_name || '.begin',
425: 'begin procedure');
426: FND_LOG.STRING(g_proc_level,
427: g_module_name || '.' || l_procedure_name ||

Line 426: FND_LOG.STRING(g_proc_level,

422: IF (g_proc_level >= g_dbg_level) THEN
423: FND_LOG.STRING(g_proc_level,
424: g_module_name || '.' || l_procedure_name || '.begin',
425: 'begin procedure');
426: FND_LOG.STRING(g_proc_level,
427: g_module_name || '.' || l_procedure_name ||
428: '.p_le_id is',
429: to_char(p_le_id));
430: FND_LOG.STRING(g_proc_level,

Line 430: FND_LOG.STRING(g_proc_level,

426: FND_LOG.STRING(g_proc_level,
427: g_module_name || '.' || l_procedure_name ||
428: '.p_le_id is',
429: to_char(p_le_id));
430: FND_LOG.STRING(g_proc_level,
431: g_module_name || '.' || l_procedure_name ||
432: '.p_fiscal_year is',
433: p_fiscal_year);
434: END IF; --( g_proc_level >= g_dbg_level)

Line 471: FND_LOG.STRING(g_proc_level,

467: --Dbms_Output.put_line('SYC TEST & TEST AND TEST1');
468:
469: --log for debug
470: IF (g_proc_level >= g_dbg_level) THEN
471: FND_LOG.STRING(g_proc_level,
472: g_module_name || '.' || l_procedure_name || '.end',
473: 'end procedure');
474: END IF; --( g_proc_level >= g_dbg_level)
475: