DBA Data[Home] [Help]

APPS.JA_CN_PS_GL_EXPORT_PROG dependencies on FND_FILE

Line 93: FND_FILE.put_line(FND_FILE.log, lv_procedure_name ||

89: 'pv_accounting_year=' || pv_accounting_year || ',' ||
90: 'pv_period_from=' || pv_period_from || ',' ||
91: 'pv_period_to=' || pv_period_to);
92: END IF; --l_proc_level>=l_dbg_level
93: FND_FILE.put_line(FND_FILE.log, lv_procedure_name ||
94: '.parameters:'||
95: 'pn_legal_entity_id=' || pn_legal_entity_id || ',' ||
96: 'pn_chart_of_account_id=' || pn_chart_of_account_id || ',' ||
97: 'pn_ledger_id=' || pn_ledger_id || ',' ||

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

99: 'pv_period_from=' || pv_period_from || ',' ||
100: 'pv_period_to=' || pv_period_to);
101:
102: --Step1: Generate XML header part
103: FND_FILE.put_line(FND_FILE.output,'');
104: lv_gl_element := '<' || Ja_Cn_Utility.Get_XML_Tag('GENERAL_LEDGER') || ' xsi:schemaLocation="http://sxbw.audit.gov.cn/AccountingSoftwareDataInterfaceStandard/2010/PSGA/XMLSchema ' ||
105: Ja_Cn_Utility.Get_XML_Tag('GENERAL_LEDGER') || '.xsd" xmlns:' ||
106: Ja_Cn_Utility.Get_XML_Tag('PUBLIC_SECTOR') || '="http://sxbw.audit.gov.cn/AccountingSoftwareDataInterfaceStandard/2010/PSGA/XMLSchema"'||
107: ' xmlns="http://sxbw.audit.gov.cn/AccountingSoftwareDataInterfaceStandard/2010/PSGA/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">';

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

105: Ja_Cn_Utility.Get_XML_Tag('GENERAL_LEDGER') || '.xsd" xmlns:' ||
106: Ja_Cn_Utility.Get_XML_Tag('PUBLIC_SECTOR') || '="http://sxbw.audit.gov.cn/AccountingSoftwareDataInterfaceStandard/2010/PSGA/XMLSchema"'||
107: ' xmlns="http://sxbw.audit.gov.cn/AccountingSoftwareDataInterfaceStandard/2010/PSGA/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">';
108:
109: FND_FILE.put_line(FND_FILE.output, lv_gl_element);
110:
111: --Step2: Export GL Basic Information
112: Ja_Cn_Utility.Print_Concurrent_Steps_For_Log('2.1', 'GL_BASIC_INFORMATION');
113: JA_CN_PS_GBI_EXPORT_PKG.Add_GL_Basic_Info(pn_coa_id => pn_chart_of_account_id);

Line 187: FND_FILE.put_line(FND_FILE.output

183: ,pv_period_from => pv_period_from
184: ,pv_period_to => pv_period_to
185: );
186:
187: FND_FILE.put_line(FND_FILE.output
188: ,Ja_Cn_Utility.Get_XML_Tag('GENERAL_LEDGER'
189: ,Ja_Cn_Utility.GV_TAG_TYPE_END
190: )
191: );

Line 213: FND_FILE.put_line(FND_FILE.log, lv_procedure_name || SQLCODE || SQLERRM);

209: SQLCODE || SQLERRM);
210: END IF;
211: pv_retcode := '2';
212: pv_errbuf := SQLCODE || SQLERRM;
213: FND_FILE.put_line(FND_FILE.log, lv_procedure_name || SQLCODE || SQLERRM);
214:
215: END Export_GL;
216:
217: --==========================================================================

Line 372: FND_FILE.put_line(FND_FILE.log, lv_procedure_name ||

368: 'pn_exp_detail_num=' || pn_exp_detail_num);
369:
370: END IF; --l_proc_level>=l_dbg_level
371:
372: FND_FILE.put_line(FND_FILE.log, lv_procedure_name ||
373: '.parameters:' ||
374: 'pn_legal_entity_id=' || pn_legal_entity_id || ',' ||
375: 'pn_ledger_id=' || pn_ledger_id || ',' ||
376: 'pv_adhoc_prefix=' || pv_adhoc_prefix || ',' ||

Line 402: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Step 0: Check System Option');

398: 'pn_revenue_exp_num=' || pn_revenue_exp_num || ',' ||
399: 'pn_exp_detail_num=' || pn_exp_detail_num);
400:
401: --Step0: Check system option
402: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Step 0: Check System Option');
403: IF NOT(Ja_Cn_Utility.Check_System_Option(pn_legal_entity_id))
404: THEN
405: pv_retcode := 1;
406: pv_errbuf := '';

Line 411: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Step 1: Check Profile');

407: RETURN;
408: END IF; --(Ja_Cn_Utility.Check_System_Option(pn_legal_entity_id))
409:
410: --Step1: Check profile
411: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Step 1: Check Profile');
412: IF NOT(JA_CN_UTILITY.Check_Profile)
413: THEN
414: pv_retcode := 1;
415: pv_errbuf := '';

Line 474: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Step 2: Submit GL Non-FSG Export Program (Public Sector)');

470: NULL;
471: END;
472:
473: --Step2: Submit GL Non-FSG Export program
474: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Step 2: Submit GL Non-FSG Export Program (Public Sector)');
475: ln_reqid_gle:=FND_REQUEST.Submit_Request(application => 'JA'
476: ,program => 'JACNPGLE'
477: ,argument1 => pn_legal_entity_id
478: ,argument2 => pn_coa_id

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

518: --Completed with Normal
519: IF lv_gle_req_status_code='C'
520: THEN
521: --Step3: submit FSG report
522: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Step 3: Submit FSG report');
523:
524: ja_cn_ps_fsg_xml_submit_prog.Submit_FSG_Report(pn_data_access_set_id => pn_data_access_set_id
525: ,pn_coa_id => pn_coa_id
526: ,pv_adhoc_prefix => pv_adhoc_prefix

Line 555: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Step 4: Submit Combination program');

551: IF ln_convert_reqid<>0
552: THEN
553:
554: --Step4: Submit combination program
555: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Step 4: Submit Combination program');
556: ln_reqid_comb:=FND_REQUEST.Submit_Request(application => 'JA'
557: ,program => 'JACNPCCP'
558: ,argument1 => ln_reqid_gle
559: ,argument2 => ln_convert_reqid

Line 598: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Step 5: Submit Characrter Set Conversion program');

594: THEN
595:
596: --Step5: Submit characrter set conversion program
597: --to convert charaterset of output file
598: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Step 5: Submit Characrter Set Conversion program');
599: JA_CN_UTILITY.Submit_XML_Charset_Conversion(p_xml_request_id => ln_reqid_comb
600: ,p_source_charset => JA_CN_UTILITY.Get_XML_Encoding
601: ,p_destination_charset => pv_dest_char_set
602: ,p_source_separator => NULL

Line 610: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Step 6: Submit File Name Renaming program');

606: IF lv_cvt_req_status='Success'
607: THEN
608: --Step6: Submit "Change File Name" concurrent program
609: --to change name of output file
610: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Step 6: Submit File Name Renaming program');
611: lv_output_file_name := Ja_Cn_Utility.Generate_File_name(pv_module_name => 'GL'
612: ,pv_accounting_year => pv_accounting_year
613: ,pv_ledger_id => pn_ledger_id
614: ,pv_from_period => lv_period_from

Line 624: FND_FILE.put_line(FND_FILE.log, lv_procedure_name ||

620: FND_LOG.STRING(ln_statement_level,
621: lv_procedure_name,
622: 'lv_output_file_name:' || lv_output_file_name);
623: END IF; --(ln_statement_level >= ln_dbg_level)
624: FND_FILE.put_line(FND_FILE.log, lv_procedure_name ||
625: '.variable:' ||
626: 'lv_output_file_name=' || lv_output_file_name);
627:
628: JA_CN_UTILITY.Change_Output_Filename(p_xml_request_id => ln_reqid_comb

Line 717: FND_FILE.put_line(FND_FILE.log, lv_procedure_name || SQLCODE || SQLERRM);

713: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
714: '.Other_Exception ',
715: SQLCODE || SQLERRM);
716: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
717: FND_FILE.put_line(FND_FILE.log, lv_procedure_name || SQLCODE || SQLERRM);
718:
719: END Submit_Request;
720:
721: END JA_CN_PS_GL_EXPORT_PROG;