DBA Data[Home] [Help]

APPS.JA_CN_SI_BANK_EXPORT_PKG dependencies on FND_FILE

Line 71: FND_FILE.put_line(FND_FILE.log,

67: 'pv_accounting_year=' || pv_accounting_year || ',' ||
68: 'pn_coa_id=' || pn_coa_id);
69: END IF; --l_proc_level>=l_dbg_level
70:
71: FND_FILE.put_line(FND_FILE.log,
72: lv_procedure_name || '.parameters:' ||
73: 'pn_ledger_id=' || pn_ledger_id || ',' ||
74: 'pn_legal_entity_id=' || pn_legal_entity_id || ',' ||
75: 'pv_bsv=' || pv_bsv || ',' ||

Line 81: FND_FILE.put_line(FND_FILE.output,

77: 'pn_coa_id=' || pn_coa_id);
78:
79: -- export the header
80: -- here need to change
81: FND_FILE.put_line(FND_FILE.output,
82: ' 83: JA_CN_UTILITY.Get_XML_Encoding || '"?>');
84: /*lv_gl_element := '<' || Ja_Cn_Utility.Get_XML_Tag('SHARED_INFORMATION') ||
85: ' xsi:schemaLocation="http://sxbw.audit.gov.cn/AccountingSoftwareDataInterfaceStandard/2010/SOE/XMLSchema ' ||

Line 103: FND_FILE.put_line(FND_FILE.output, lv_gl_element);

99: Ja_Cn_Utility.Get_XML_Tag('SHARED_INFORMATION') ||'.xsd"'||
100: ' xmlns:'||Ja_Cn_Utility.Get_XML_Tag('BANK')||'="http://sxbw.audit.gov.cn/AccountingSoftwareDataInterfaceStandard/2010/Bank/XMLSchema"'||
101: ' xmlns="http://sxbw.audit.gov.cn/AccountingSoftwareDataInterfaceStandard/2010/Bank/XMLSchema"' ||
102: ' xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">';
103: FND_FILE.put_line(FND_FILE.output, lv_gl_element);
104:
105: --begin basic info
106: Ja_Cn_Utility.Add_Sub_Root_Node('BASIC_INFO', Ja_Cn_Utility.GV_TAG_TYPE_START);
107:

Line 163: FND_FILE.put_line(FND_FILE.output, Ja_Cn_Utility.Get_XML_Tag('SHARED_INFORMATION', Ja_Cn_Utility.GV_TAG_TYPE_END));

159: TO_NUMBER(pv_accounting_year) ) ;
160:
161: Ja_Cn_Utility.Add_Sub_Root_Node('FINANCE_SYSTEM', Ja_Cn_Utility.GV_TAG_TYPE_END);
162:
163: FND_FILE.put_line(FND_FILE.output, Ja_Cn_Utility.Get_XML_Tag('SHARED_INFORMATION', Ja_Cn_Utility.GV_TAG_TYPE_END));
164:
165: --logging for debug
166: IF (ln_proc_level >= ln_dbg_level) THEN
167: FND_LOG.STRING(ln_proc_level,

Line 179: FND_FILE.put_line(FND_FILE.log,

175: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
176: '.Other_Exception ',
177: SQLCODE || SQLERRM);
178: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
179: FND_FILE.put_line(FND_FILE.log,
180: lv_procedure_name || SQLCODE || SQLERRM);
181: pv_retcode := 2;
182: raise;
183: END Export_Shared_Information;

Line 263: FND_FILE.put_line(FND_FILE.log,

259: 'pv_dest_char_set=' || pv_dest_char_set || ',' ||
260: 'pn_coa_id=' || pn_coa_id);
261: END IF; --l_proc_level>=l_dbg_level
262:
263: FND_FILE.put_line(FND_FILE.log,
264: lv_procedure_name || '.parameters:' ||
265: 'pn_ledger_id=' || pn_ledger_id || ',' ||
266: 'pn_legal_entity_id=' || pn_legal_entity_id || ',' ||
267: 'pv_bsv=' || pv_bsv || ',' ||

Line 281: FND_FILE.PUT_LINE(FND_FILE.LOG,GV_MODULE_PREFIX || '.' || lv_procedure_name||':'||l_mes);

277: IF l_bsv_le <> true THEN
278: pv_retcode :=1;
279: FND_MESSAGE.SET_NAME('JA','JA_CN_BSV_VALIDATION') ;
280: l_mes := FND_MESSAGE.GET;
281: FND_FILE.PUT_LINE(FND_FILE.LOG,GV_MODULE_PREFIX || '.' || lv_procedure_name||':'||l_mes);
282: --APP_EXCEPTION.RAISE_EXCEPTION ;
283: RETURN;
284: ELSE
285: l_das_bsv :=ja_cn_sysops_bank_pkg.Check_DAS_BSV(p_ledger => pn_ledger_id,

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

289: IF l_das_bsv =-2 THEN
290: FND_MESSAGE.SET_NAME('FND','FLEX-EXCLUDED BY SEC. RULE') ;
291: FND_MESSAGE.SET_TOKEN ('MESSAGE',pv_bsv);
292: l_mes := FND_MESSAGE.GET;
293: FND_FILE.PUT_LINE(FND_FILE.LOG,'Waring:'||l_mes);
294: pv_retcode :=1;
295: RETURN;
296: ELSIF l_das_bsv =-1 THEN
297: FND_MESSAGE.SET_NAME('SQLGL','GLCORE_NO_ACCESS') ;

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

295: RETURN;
296: ELSIF l_das_bsv =-1 THEN
297: FND_MESSAGE.SET_NAME('SQLGL','GLCORE_NO_ACCESS') ;
298: l_mes := FND_MESSAGE.GET;
299: FND_FILE.PUT_LINE(FND_FILE.LOG,'Waring:'||l_mes);
300: pv_retcode :=1;
301: RETURN;
302: END IF;
303: END IF;

Line 306: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Step 2: Submit SI Export program');

302: END IF;
303: END IF;
304:
305: --Step2: Submit SI Export program
306: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Step 2: Submit SI Export program');
307: ln_reqid_gle := FND_REQUEST.Submit_Request(application => 'JA',
308: program => 'JACNSIBGP',
309: argument1 => pn_coa_id,
310: argument2 => pn_ledger_id,

Line 343: FND_FILE.PUT_LINE(FND_FILE.LOG,

339: IF lv_gle_req_status_code = 'C' THEN
340:
341: --Step3: Submit characrter set conversion program
342: --to convert charaterset of output file
343: FND_FILE.PUT_LINE(FND_FILE.LOG,
344: 'Step 3: Submit Characrter Set Conversion program');
345: JA_CN_SYSOPS_BANK_PKG.Submit_XML_Charset_Conversion(p_xml_request_id => ln_reqid_gle,
346: p_source_charset => JA_CN_UTILITY.Get_XML_Encoding,
347: p_destination_charset => pv_dest_char_set,

Line 354: FND_FILE.PUT_LINE(FND_FILE.LOG,

350: x_result_flag => lv_cvt_req_status);
351: IF lv_cvt_req_status = 'Success' THEN
352: --Step4: Submit "Change File Name" concurrent program
353: --to change name of output file
354: FND_FILE.PUT_LINE(FND_FILE.LOG,
355: 'Step 4: Submit File Name Renaming program');
356: lv_output_file_name := Ja_Cn_Utility.Generate_File_name(pv_module_name => 'SI',
357: pv_accounting_year => pv_accounting_year,
358: pv_ledger_id => pn_ledger_id,

Line 367: FND_FILE.put_line(FND_FILE.log,

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

Line 431: FND_FILE.put_line(FND_FILE.log,

427: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
428: '.Other_Exception ',
429: SQLCODE || SQLERRM);
430: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
431: FND_FILE.put_line(FND_FILE.log,
432: lv_procedure_name || SQLCODE || SQLERRM);
433: IF pv_retcode IS NULL THEN
434: pv_retcode := 2;
435: END IF;