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_GL_BANK_EXP_REPORT_PKG dependencies on FND_FILE

Line 195: FND_FILE.put_line(FND_FILE.log,

191: 'pv_accounting_date=' || pv_accounting_date);
192:
193: END IF; --l_proc_level>=l_dbg_level
194:
195: FND_FILE.put_line(FND_FILE.log,
196: lv_procedure_name || '.parameters:' ||
197: 'pn_ledger_id=' || pn_ledger_id || ',' ||
198: 'pn_legal_entity_id=' || pn_legal_entity_id || ',' ||
199: 'pv_bsv=' || pv_bsv || ',' ||

Line 234: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Step 0,l_access_set='||l_access_set);

230: 'pn_owners_equity_num=' || pn_owners_equity_num || ',' ||
231: 'pv_accounting_date=' || pv_accounting_date);
232:
233: --Step0: Validate the bsv whether is assigned to the legal entity
234: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Step 0,l_access_set='||l_access_set);
235: l_bsv_le := ja_cn_sysops_bank_pkg.check_le_bsv(p_ledger => pn_ledger_id,
236: p_legal_entity => pn_legal_entity_id,
237: p_bsv => pv_bsv);
238: IF l_bsv_le <> true THEN

Line 241: FND_FILE.PUT_LINE(FND_FILE.LOG,l_mes);

237: p_bsv => pv_bsv);
238: IF l_bsv_le <> true THEN
239: FND_MESSAGE.SET_NAME('JA','JA_CN_BSV_VALIDATION') ;
240: l_mes := FND_MESSAGE.GET;
241: FND_FILE.PUT_LINE(FND_FILE.LOG,l_mes);
242: pv_retcode :=1;
243: RETURN;
244: ELSE
245: l_das_bsv :=ja_cn_sysops_bank_pkg.Check_DAS_BSV(p_ledger => pn_ledger_id,

Line 253: FND_FILE.PUT_LINE(FND_FILE.LOG,'Waring:'||l_mes);

249: IF l_das_bsv =-2 THEN
250: FND_MESSAGE.SET_NAME('FND','FLEX-EXCLUDED BY SEC. RULE') ;
251: FND_MESSAGE.SET_TOKEN ('MESSAGE',pv_bsv);
252: l_mes := FND_MESSAGE.GET;
253: FND_FILE.PUT_LINE(FND_FILE.LOG,'Waring:'||l_mes);
254: pv_retcode :=1;
255: RETURN;
256: ELSIF l_das_bsv =-1 THEN
257: FND_MESSAGE.SET_NAME('SQLGL','GLCORE_NO_ACCESS') ;

Line 259: FND_FILE.PUT_LINE(FND_FILE.LOG,'Waring:'||l_mes);

255: RETURN;
256: ELSIF l_das_bsv =-1 THEN
257: FND_MESSAGE.SET_NAME('SQLGL','GLCORE_NO_ACCESS') ;
258: l_mes := FND_MESSAGE.GET;
259: FND_FILE.PUT_LINE(FND_FILE.LOG,'Waring:'||l_mes);
260: pv_retcode :=1;
261: RETURN;
262: END IF;
263: END IF;

Line 268: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Step 1: Validate the period from and the period to');

264:
265:
266:
267: --Step 1: Validate the period from and the period to
268: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Step 1: Validate the period from and the period to');
269: --Handling period from and period to if any of them is null
270: IF lv_period_from IS NULL THEN
271: BEGIN
272: SELECT PERIOD_NAME

Line 315: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Step 2: Submit GL Non-FSG Export program');

311: END;
312: END IF;
313:
314: --Step2: Submit GL Non-FSG Export program
315: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Step 2: Submit GL Non-FSG Export program');
316: ln_reqid_gle := FND_REQUEST.Submit_Request(application => 'JA',
317: program => 'JACNGLBER',
318: argument1 => pn_chart_of_account_id,
319: argument2 => pn_ledger_id,

Line 359: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Step 3: Submit FSG report');

355:
356: --Completed with Normal
357: IF lv_gle_req_status_code = 'C' THEN
358: --Step3: submit FSG report
359: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Step 3: Submit FSG report');
360: --logging the variables
361: IF (ln_statement_level >= ln_dbg_level) THEN
362: FND_LOG.STRING(ln_statement_level,
363: lv_procedure_name,

Line 367: FND_FILE.put_line(FND_FILE.log,

363: lv_procedure_name,
364: 'lv_period_to:' || lv_period_to || ',' ||
365: 'lv_accounting_date:' || lv_accounting_date);
366: END IF; --(ln_statement_level >= ln_dbg_level)
367: FND_FILE.put_line(FND_FILE.log,
368: lv_procedure_name || '.variable:' ||
369: 'lv_period_to=' || lv_period_to || ',' ||
370: 'lv_accounting_date=' || lv_accounting_date);
371:

Line 405: FND_FILE.PUT_LINE(FND_FILE.LOG,

401: pn_convert_reqid => ln_convert_reqid);
402: IF ln_convert_reqid <> 0 THEN
403:
404: --Step4: Submit combination program
405: FND_FILE.PUT_LINE(FND_FILE.LOG,
406: 'Step 4: Submit Combination program');
407: ln_reqid_comb := FND_REQUEST.Submit_Request(application => 'JA',
408: program => 'JACNBFCP',
409: argument1 => ln_reqid_gle,

Line 441: FND_FILE.PUT_LINE(FND_FILE.LOG,

437: IF lv_comb_req_status_code = 'C' THEN
438:
439: --Step5: Submit characrter set conversion program
440: --to convert charaterset of output file
441: FND_FILE.PUT_LINE(FND_FILE.LOG,
442: 'Step 5: Submit Characrter Set Conversion program');
443: JA_CN_SYSOPS_BANK_PKG.Submit_XML_Charset_Conversion(p_xml_request_id => ln_reqid_comb,
444: p_source_charset => JA_CN_UTILITY.Get_XML_Encoding,
445: p_destination_charset => pv_dest_char_set,

Line 452: FND_FILE.PUT_LINE(FND_FILE.LOG,

448: x_result_flag => lv_cvt_req_status);
449: IF lv_cvt_req_status = 'Success' THEN
450: --Step6: Submit "Change File Name" concurrent program
451: --to change name of output file
452: FND_FILE.PUT_LINE(FND_FILE.LOG,
453: 'Step 6: Submit File Name Renaming program');
454: lv_output_file_name := Ja_Cn_Utility.Generate_File_name(pv_module_name => 'GL',
455: pv_accounting_year => pv_accounting_year,
456: pv_ledger_id => pn_ledger_id,

Line 466: FND_FILE.put_line(FND_FILE.log,

462: lv_procedure_name,
463: 'lv_output_file_name:' ||
464: lv_output_file_name);
465: END IF; --(ln_statement_level >= ln_dbg_level)
466: FND_FILE.put_line(FND_FILE.log,
467: lv_procedure_name || '.variable:' ||
468: 'lv_output_file_name=' ||
469: lv_output_file_name);
470:

Line 543: FND_FILE.put_line(FND_FILE.log,

539: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
540: '.Other_Exception ',
541: SQLCODE || SQLERRM);
542: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
543: FND_FILE.put_line(FND_FILE.log,
544: lv_procedure_name || SQLCODE || SQLERRM);
545: pv_retcode := 2;
546: RAISE;
547: END Submit_Request;