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_ETC_CONC_PROG dependencies on FND_LOG

Line 93: l_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;

89: l_Flag NUMBER;
90: l_Error_Flag VARCHAR2(1) := 'N';
91: l_Error_Status BOOLEAN;
92:
93: l_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
94: l_Proc_Level NUMBER := Fnd_Log.Level_Procedure;
95: l_Proc_Name VARCHAR2(100) := 'transfer_gl_sla_to_cnao';
96:
97: BEGIN

Line 94: l_Proc_Level NUMBER := Fnd_Log.Level_Procedure;

90: l_Error_Flag VARCHAR2(1) := 'N';
91: l_Error_Status BOOLEAN;
92:
93: l_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
94: l_Proc_Level NUMBER := Fnd_Log.Level_Procedure;
95: l_Proc_Name VARCHAR2(100) := 'transfer_gl_sla_to_cnao';
96:
97: BEGIN
98: --log for debug

Line 100: Fnd_Log.STRING(l_Proc_Level,

96:
97: BEGIN
98: --log for debug
99: IF (l_Proc_Level >= l_Dbg_Level) THEN
100: Fnd_Log.STRING(l_Proc_Level,
101: l_Module_Prefix || '.' || l_Proc_Name || '.begin',
102: 'Enter procedure');
103: Fnd_Log.STRING(l_Proc_Level,
104: l_Module_Prefix || '.' || l_Proc_Name || '.parameters',

Line 103: Fnd_Log.STRING(l_Proc_Level,

99: IF (l_Proc_Level >= l_Dbg_Level) THEN
100: Fnd_Log.STRING(l_Proc_Level,
101: l_Module_Prefix || '.' || l_Proc_Name || '.begin',
102: 'Enter procedure');
103: Fnd_Log.STRING(l_Proc_Level,
104: l_Module_Prefix || '.' || l_Proc_Name || '.parameters',
105: 'p_period_name:' || p_Period_Name);
106: Fnd_Log.STRING(l_Proc_Level,
107: l_Module_Prefix || '.' || l_Proc_Name || '.parameters',

Line 106: Fnd_Log.STRING(l_Proc_Level,

102: 'Enter procedure');
103: Fnd_Log.STRING(l_Proc_Level,
104: l_Module_Prefix || '.' || l_Proc_Name || '.parameters',
105: 'p_period_name:' || p_Period_Name);
106: Fnd_Log.STRING(l_Proc_Level,
107: l_Module_Prefix || '.' || l_Proc_Name || '.parameters',
108: 'p_legal_entity_id:' || p_Legal_Entity_Id);
109: END IF; --(l_proc_level >= l_dbg_level)
110:

Line 132: Fnd_Log.STRING(l_Proc_Level,

128: END IF; --l_error_flag = 'Y'
129:
130: --log for debug
131: IF (l_Proc_Level >= l_Dbg_Level) THEN
132: Fnd_Log.STRING(l_Proc_Level,
133: l_Module_Prefix || '.' || l_Proc_Name || '.end',
134: 'Exit procedure');
135: END IF; --( l_proc_level >= l_dbg_level )
136:

Line 140: Fnd_Log.STRING(l_Proc_Level,

136:
137: EXCEPTION
138: WHEN OTHERS THEN
139: IF (l_Proc_Level >= l_Dbg_Level) THEN
140: Fnd_Log.STRING(l_Proc_Level,
141: l_Module_Prefix || '.' || l_Proc_Name ||
142: '. Other_Exception ',
143: SQLCODE || ':' || SQLERRM);
144: END IF; --(l_proc_level >= l_dbg_level)

Line 182: l_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;

178: l_Flag NUMBER;
179: l_Error_Flag VARCHAR2(1) := 'N';
180: l_Error_Status BOOLEAN;
181:
182: l_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
183: l_Proc_Level NUMBER := Fnd_Log.Level_Procedure;
184: l_Proc_Name VARCHAR2(100) := 'post_journal_itemized';
185:
186: BEGIN

Line 183: l_Proc_Level NUMBER := Fnd_Log.Level_Procedure;

179: l_Error_Flag VARCHAR2(1) := 'N';
180: l_Error_Status BOOLEAN;
181:
182: l_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
183: l_Proc_Level NUMBER := Fnd_Log.Level_Procedure;
184: l_Proc_Name VARCHAR2(100) := 'post_journal_itemized';
185:
186: BEGIN
187: --log for debug

Line 189: Fnd_Log.STRING(l_Proc_Level,

185:
186: BEGIN
187: --log for debug
188: IF (l_Proc_Level >= l_Dbg_Level) THEN
189: Fnd_Log.STRING(l_Proc_Level,
190: l_Module_Prefix || '.' || l_Proc_Name || '.begin',
191: 'Enter procedure');
192: Fnd_Log.STRING(l_Proc_Level,
193: l_Module_Prefix || '.' || l_Proc_Name || '.parameters',

Line 192: Fnd_Log.STRING(l_Proc_Level,

188: IF (l_Proc_Level >= l_Dbg_Level) THEN
189: Fnd_Log.STRING(l_Proc_Level,
190: l_Module_Prefix || '.' || l_Proc_Name || '.begin',
191: 'Enter procedure');
192: Fnd_Log.STRING(l_Proc_Level,
193: l_Module_Prefix || '.' || l_Proc_Name || '.parameters',
194: 'p_period_name:' || p_Period_Name);
195: Fnd_Log.STRING(l_Proc_Level,
196: l_Module_Prefix || '.' || l_Proc_Name || '.parameters',

Line 195: Fnd_Log.STRING(l_Proc_Level,

191: 'Enter procedure');
192: Fnd_Log.STRING(l_Proc_Level,
193: l_Module_Prefix || '.' || l_Proc_Name || '.parameters',
194: 'p_period_name:' || p_Period_Name);
195: Fnd_Log.STRING(l_Proc_Level,
196: l_Module_Prefix || '.' || l_Proc_Name || '.parameters',
197: 'p_Ledger_id :' || P_ledger_Id);
198: Fnd_Log.STRING(l_Proc_Level,
199: l_Module_Prefix || '.' || l_Proc_Name || '.parameters',

Line 198: Fnd_Log.STRING(l_Proc_Level,

194: 'p_period_name:' || p_Period_Name);
195: Fnd_Log.STRING(l_Proc_Level,
196: l_Module_Prefix || '.' || l_Proc_Name || '.parameters',
197: 'p_Ledger_id :' || P_ledger_Id);
198: Fnd_Log.STRING(l_Proc_Level,
199: l_Module_Prefix || '.' || l_Proc_Name || '.parameters',
200: 'p_legal_entity_ID:' || p_Legal_Entity_Id);
201: END IF; --(l_proc_level >= l_dbg_level)
202:

Line 220: Fnd_Log.STRING(l_Proc_Level,

216: END IF; --l_error_flag = 'Y'
217:
218: --log for debug
219: IF (l_Proc_Level >= l_Dbg_Level) THEN
220: Fnd_Log.STRING(l_Proc_Level,
221: l_Module_Prefix || '.' || l_Proc_Name || '.end',
222: 'Exit procedure');
223: END IF; --( l_proc_level >= l_dbg_level )
224:

Line 228: Fnd_Log.STRING(l_Proc_Level,

224:
225: EXCEPTION
226: WHEN OTHERS THEN
227: IF (l_Proc_Level >= l_Dbg_Level) THEN
228: Fnd_Log.STRING(l_Proc_Level,
229: l_Module_Prefix || '.' || l_Proc_Name ||
230: '. Other_Exception ',
231: SQLCODE || ':' || SQLERRM);
232: END IF; --(l_proc_level >= l_dbg_level)

Line 278: l_dbg_level NUMBER := FND_LOG.G_Current_Runtime_Level;

274: l_flag NUMBER:=0;
275: l_error_flag VARCHAR2(1) := 'N';
276: l_error_status BOOLEAN;
277:
278: l_dbg_level NUMBER := FND_LOG.G_Current_Runtime_Level;
279: l_proc_level NUMBER := FND_LOG.Level_Procedure;
280: l_proc_name VARCHAR2(100) := 'EAB_Export';
281:
282: BEGIN

Line 279: l_proc_level NUMBER := FND_LOG.Level_Procedure;

275: l_error_flag VARCHAR2(1) := 'N';
276: l_error_status BOOLEAN;
277:
278: l_dbg_level NUMBER := FND_LOG.G_Current_Runtime_Level;
279: l_proc_level NUMBER := FND_LOG.Level_Procedure;
280: l_proc_name VARCHAR2(100) := 'EAB_Export';
281:
282: BEGIN
283: --log for debug

Line 286: FND_LOG.STRING(l_proc_level,

282: BEGIN
283: --log for debug
284: IF (l_proc_level >= l_dbg_level)
285: THEN
286: FND_LOG.STRING(l_proc_level,
287: l_module_prefix || '.' || l_proc_name || '.begin',
288: 'Enter procedure');
289: FND_LOG.STRING(l_proc_level,
290: l_module_prefix || '.' || l_proc_name || '.parameters',

Line 289: FND_LOG.STRING(l_proc_level,

285: THEN
286: FND_LOG.STRING(l_proc_level,
287: l_module_prefix || '.' || l_proc_name || '.begin',
288: 'Enter procedure');
289: FND_LOG.STRING(l_proc_level,
290: l_module_prefix || '.' || l_proc_name || '.parameters',
291: 'p_le_id is ' || p_le_id);
292: FND_LOG.STRING(l_proc_level,
293: l_module_prefix || '.' || l_proc_name || '.parameters',

Line 292: FND_LOG.STRING(l_proc_level,

288: 'Enter procedure');
289: FND_LOG.STRING(l_proc_level,
290: l_module_prefix || '.' || l_proc_name || '.parameters',
291: 'p_le_id is ' || p_le_id);
292: FND_LOG.STRING(l_proc_level,
293: l_module_prefix || '.' || l_proc_name || '.parameters',
294: 'p_fiscal_year is ' || p_fiscal_year);
295: END IF; --(l_proc_level >= l_dbg_level)
296:

Line 320: FND_LOG.STRING(l_proc_level,

316: */
317: --log for debug
318: IF (l_proc_level >= l_dbg_level)
319: THEN
320: FND_LOG.STRING(l_proc_level,
321: l_module_prefix || '.' || l_proc_name || '.end',
322: 'Exit procedure');
323: END IF; --( l_proc_level >= l_dbg_level )
324:

Line 329: FND_LOG.STRING(l_proc_level,

325: EXCEPTION
326: WHEN OTHERS THEN
327: IF (l_proc_level >= l_dbg_level)
328: THEN
329: FND_LOG.STRING(l_proc_level,
330: l_module_prefix || '.' || l_proc_name ||
331: '. Other_Exception ',
332: SQLCODE || ':' || SQLERRM);
333: END IF; --(l_proc_level >= l_dbg_level)

Line 376: l_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;

372: p_Dest_Charset IN VARCHAR2,
373: p_Separator IN VARCHAR2,
374: p_File_Name IN VARCHAR2) IS
375:
376: l_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
377: l_Proc_Level NUMBER := Fnd_Log.Level_Procedure;
378: l_Proc_Name VARCHAR2(100) := 'EAB_Export_Wrapper';
379:
380: l_Reqid NUMBER(15); -- Request id for the 'EAB export'

Line 377: l_Proc_Level NUMBER := Fnd_Log.Level_Procedure;

373: p_Separator IN VARCHAR2,
374: p_File_Name IN VARCHAR2) IS
375:
376: l_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
377: l_Proc_Level NUMBER := Fnd_Log.Level_Procedure;
378: l_Proc_Name VARCHAR2(100) := 'EAB_Export_Wrapper';
379:
380: l_Reqid NUMBER(15); -- Request id for the 'EAB export'
381: l_Chr_Reqid NUMBER(15); -- Request id for the 'Charset Convert'

Line 397: Fnd_Log.STRING(l_Proc_Level,

393:
394: BEGIN
395: --log for debug
396: IF (l_Proc_Level >= l_Dbg_Level) THEN
397: Fnd_Log.STRING(l_Proc_Level,
398: l_Module_Prefix || '.' || l_Proc_Name || '.begin',
399: 'Enter procedure');
400: END IF; --(l_proc_level >= l_dbg_level)
401:

Line 413: Fnd_Log.STRING(l_Proc_Level,

409: COMMIT;
410:
411: --log for debug
412: IF (l_Proc_Level >= l_Dbg_Level) THEN
413: Fnd_Log.STRING(l_Proc_Level,
414: l_Module_Prefix || '.' || l_Proc_Name,
415: 'submit EAB export CP');
416: END IF; --( g_stmt_level >= g_dbg_level)
417:

Line 473: Fnd_Log.STRING(l_Proc_Level,

469: END IF; --FND_CONCURRENT.Wait_For_Request
470: END IF; --l_reqid <> 0
471:
472: IF (l_Proc_Level >= l_Dbg_Level) THEN
473: Fnd_Log.STRING(l_Proc_Level,
474: l_Module_Prefix || '.' || l_Proc_Name || '.end',
475: 'Exit procedure');
476: END IF;
477:

Line 481: Fnd_Log.STRING(l_Proc_Level,

477:
478: EXCEPTION
479: WHEN OTHERS THEN
480: IF (l_Proc_Level >= l_Dbg_Level) THEN
481: Fnd_Log.STRING(l_Proc_Level,
482: l_Module_Prefix || '.' || l_Proc_Name ||
483: '. Other_Exception ',
484: SQLCODE || ':' || SQLERRM);
485: END IF; --(l_proc_level >= l_dbg_level)

Line 529: l_dbg_level NUMBER := FND_LOG.G_Current_Runtime_Level;

525: P_ACCOUNT_TYPE IN VARCHAR2,
526: P_XML_TEMPLATE_LANGUAGE IN VARCHAR2 default 'zh',
527: P_XML_TEMPLATE_TERRITORY IN VARCHAR2 default '00',
528: P_XML_OUTPUT_FORMAT IN VARCHAR2 default 'RTF') IS
529: l_dbg_level NUMBER := FND_LOG.G_Current_Runtime_Level;
530: l_proc_level NUMBER := FND_LOG.Level_Procedure;
531: l_proc_name VARCHAR2(100) := 'Export_Coa';
532:
533: JA_CN_MISSING_BOOK_INFO exception;

Line 530: l_proc_level NUMBER := FND_LOG.Level_Procedure;

526: P_XML_TEMPLATE_LANGUAGE IN VARCHAR2 default 'zh',
527: P_XML_TEMPLATE_TERRITORY IN VARCHAR2 default '00',
528: P_XML_OUTPUT_FORMAT IN VARCHAR2 default 'RTF') IS
529: l_dbg_level NUMBER := FND_LOG.G_Current_Runtime_Level;
530: l_proc_level NUMBER := FND_LOG.Level_Procedure;
531: l_proc_name VARCHAR2(100) := 'Export_Coa';
532:
533: JA_CN_MISSING_BOOK_INFO exception;
534: l_msg_miss_book_info varchar2(2000);

Line 568: FND_LOG.String(l_proc_level,

564:
565: BEGIN
566: --log for debug
567: IF (l_proc_level >= l_dbg_level) THEN
568: FND_LOG.String(l_proc_level,
569: l_module_prefix || '.' || l_proc_name || '.begin',
570: 'Enter procedure');
571: FND_LOG.String(l_proc_level,
572: l_module_prefix || '.' || l_proc_name || '.parameters',

Line 571: FND_LOG.String(l_proc_level,

567: IF (l_proc_level >= l_dbg_level) THEN
568: FND_LOG.String(l_proc_level,
569: l_module_prefix || '.' || l_proc_name || '.begin',
570: 'Enter procedure');
571: FND_LOG.String(l_proc_level,
572: l_module_prefix || '.' || l_proc_name || '.parameters',
573: 'P_LE_ID ' || P_LE_ID);
574: FND_LOG.String(l_proc_level,
575: l_module_prefix || '.' || l_proc_name || '.parameters',

Line 574: FND_LOG.String(l_proc_level,

570: 'Enter procedure');
571: FND_LOG.String(l_proc_level,
572: l_module_prefix || '.' || l_proc_name || '.parameters',
573: 'P_LE_ID ' || P_LE_ID);
574: FND_LOG.String(l_proc_level,
575: l_module_prefix || '.' || l_proc_name || '.parameters',
576: 'P_ACCOUNT_TYPE ' || P_ACCOUNT_TYPE);
577: END IF; --(l_proc_level >= l_dbg_level)
578:

Line 637: FND_LOG.String(l_proc_level,

633:
634:
635: --log for debug
636: IF (l_proc_level >= l_dbg_level) THEN
637: FND_LOG.String(l_proc_level,
638: l_module_prefix || '.' || l_proc_name || '.end',
639: 'Exit procedure');
640: END IF; --(l_proc_level >= l_dbg_level)
641:

Line 650: FND_LOG.String(l_proc_level,

646: l_msg_miss_book_info := FND_MESSAGE.Get;
647:
648: FND_FILE.put_line(FND_FILE.output, l_msg_miss_book_info);
649: IF (l_proc_level >= l_dbg_level) THEN
650: FND_LOG.String(l_proc_level,
651: l_module_prefix || '.' || l_proc_name ||
652: '.JA_CN_MISSING_BOOK_INFO ',
653: l_msg_miss_book_info);
654: END IF;

Line 659: FND_LOG.String(l_proc_level,

655: retcode := 1;
656: errbuf := l_msg_miss_book_info;
657: WHEN OTHERS THEN
658: IF (l_proc_level >= l_dbg_level) THEN
659: FND_LOG.String(l_proc_level,
660: l_module_prefix || '.' || l_proc_name ||
661: '.Other_Exception ',
662: SQLCODE || ':' || SQLERRM);
663: END IF; --(l_proc_level >= l_dbg_level)