92: || 'pv_period_from=' || pv_period_from || ','
93: || 'pv_period_to=' || pv_period_to || ','
94: || 'pn_coa_id=' || pn_coa_id );
95: --populate the bsv values
96: lv_bsv_flag := JA_CN_UTILITY.Populate_Ledger_Le_Bsv_Gt(p_Ledger_Id => pn_ledger_id
97: ,p_Legal_Entity_Id => pn_legal_entity_id
98: );
99:
100: -- Export the XML header tag
99:
100: -- Export the XML header tag
101: FND_FILE.put_line( FND_FILE.output
102: , '
103: || JA_CN_UTILITY.Get_XML_Encoding || '"?>');
104: lv_fa_element := '<' ||
105: Ja_Cn_Utility.Get_XML_Tag( 'FIXED_ASSETS'
106: , Ja_Cn_Utility.GV_REQUIRED_NO
107: , Ja_Cn_Utility.GV_MODULE_FA)
101: FND_FILE.put_line( FND_FILE.output
102: , '
103: || JA_CN_UTILITY.Get_XML_Encoding || '"?>');
104: lv_fa_element := '<' ||
105: Ja_Cn_Utility.Get_XML_Tag( 'FIXED_ASSETS'
106: , Ja_Cn_Utility.GV_REQUIRED_NO
107: , Ja_Cn_Utility.GV_MODULE_FA)
108: || ' xsi:schemaLocation="http://sxbw.audit.gov.cn/'
109: || 'AccountingSoftwareDataInterfaceStandard/'
102: , '
103: || JA_CN_UTILITY.Get_XML_Encoding || '"?>');
104: lv_fa_element := '<' ||
105: Ja_Cn_Utility.Get_XML_Tag( 'FIXED_ASSETS'
106: , Ja_Cn_Utility.GV_REQUIRED_NO
107: , Ja_Cn_Utility.GV_MODULE_FA)
108: || ' xsi:schemaLocation="http://sxbw.audit.gov.cn/'
109: || 'AccountingSoftwareDataInterfaceStandard/'
110: || '2010/PSGA/XMLSchema '
103: || JA_CN_UTILITY.Get_XML_Encoding || '"?>');
104: lv_fa_element := '<' ||
105: Ja_Cn_Utility.Get_XML_Tag( 'FIXED_ASSETS'
106: , Ja_Cn_Utility.GV_REQUIRED_NO
107: , Ja_Cn_Utility.GV_MODULE_FA)
108: || ' xsi:schemaLocation="http://sxbw.audit.gov.cn/'
109: || 'AccountingSoftwareDataInterfaceStandard/'
110: || '2010/PSGA/XMLSchema '
111: || Ja_Cn_Utility.Get_XML_Tag( 'FIXED_ASSETS'
107: , Ja_Cn_Utility.GV_MODULE_FA)
108: || ' xsi:schemaLocation="http://sxbw.audit.gov.cn/'
109: || 'AccountingSoftwareDataInterfaceStandard/'
110: || '2010/PSGA/XMLSchema '
111: || Ja_Cn_Utility.Get_XML_Tag( 'FIXED_ASSETS'
112: , Ja_Cn_Utility.GV_REQUIRED_NO
113: , Ja_Cn_Utility.GV_MODULE_FA)
114: || '.xsd" xmlns:'
115: || Ja_Cn_Utility.Get_XML_Tag('PUBLIC_SECTOR')
108: || ' xsi:schemaLocation="http://sxbw.audit.gov.cn/'
109: || 'AccountingSoftwareDataInterfaceStandard/'
110: || '2010/PSGA/XMLSchema '
111: || Ja_Cn_Utility.Get_XML_Tag( 'FIXED_ASSETS'
112: , Ja_Cn_Utility.GV_REQUIRED_NO
113: , Ja_Cn_Utility.GV_MODULE_FA)
114: || '.xsd" xmlns:'
115: || Ja_Cn_Utility.Get_XML_Tag('PUBLIC_SECTOR')
116: || '="http://sxbw.audit.gov.cn/'
109: || 'AccountingSoftwareDataInterfaceStandard/'
110: || '2010/PSGA/XMLSchema '
111: || Ja_Cn_Utility.Get_XML_Tag( 'FIXED_ASSETS'
112: , Ja_Cn_Utility.GV_REQUIRED_NO
113: , Ja_Cn_Utility.GV_MODULE_FA)
114: || '.xsd" xmlns:'
115: || Ja_Cn_Utility.Get_XML_Tag('PUBLIC_SECTOR')
116: || '="http://sxbw.audit.gov.cn/'
117: || 'AccountingSoftwareDataInterfaceStandard/'
111: || Ja_Cn_Utility.Get_XML_Tag( 'FIXED_ASSETS'
112: , Ja_Cn_Utility.GV_REQUIRED_NO
113: , Ja_Cn_Utility.GV_MODULE_FA)
114: || '.xsd" xmlns:'
115: || Ja_Cn_Utility.Get_XML_Tag('PUBLIC_SECTOR')
116: || '="http://sxbw.audit.gov.cn/'
117: || 'AccountingSoftwareDataInterfaceStandard/'
118: || '2010/PSGA/XMLSchema" '
119: || 'xmlns="http://sxbw.audit.gov.cn/'
124: FND_FILE.put_line( FND_FILE.output
125: , lv_fa_element);
126: -- call the procedures to export the reports seperately here begin
127: -- Export Basic Information of FA
128: Ja_Cn_Utility.Print_Concurrent_Steps_For_Log
129: ( pv_step_number => '2.1'
130: , pv_report_name => 'BASIC_INFO_OF_FIXED_ASSET'
131: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
132: );
127: -- Export Basic Information of FA
128: Ja_Cn_Utility.Print_Concurrent_Steps_For_Log
129: ( pv_step_number => '2.1'
130: , pv_report_name => 'BASIC_INFO_OF_FIXED_ASSET'
131: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
132: );
133: JA_CN_PS_FA_BI_EXP_PKG.Add_Basic_Information( pn_legal_entity_id
134: , pn_ledger_id
135: , pv_accounting_year
136: , pv_period_from
137: , pv_period_to
138: );
139: -- Export Asset Category Setting
140: Ja_Cn_Utility.Print_Concurrent_Steps_For_Log
141: ( pv_step_number => '2.2'
142: , pv_report_name => 'FIXED_ASSET_CATEGORY_SETTING'
143: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
144: );
139: -- Export Asset Category Setting
140: Ja_Cn_Utility.Print_Concurrent_Steps_For_Log
141: ( pv_step_number => '2.2'
142: , pv_report_name => 'FIXED_ASSET_CATEGORY_SETTING'
143: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
144: );
145: JA_CN_FA_ACS_EXPORT_PKG.Add_Asset_Category( pn_legal_entity_id
146: , pn_ledger_id
147: , pv_accounting_year
148: , pv_period_from
149: , pv_period_to
150: );
151: -- Export FA Modification Method
152: Ja_Cn_Utility.Print_Concurrent_Steps_For_Log
153: ( pv_step_number => '2.3'
154: , pv_report_name => 'MODIFICATION_METHOD'
155: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
156: );
151: -- Export FA Modification Method
152: Ja_Cn_Utility.Print_Concurrent_Steps_For_Log
153: ( pv_step_number => '2.3'
154: , pv_report_name => 'MODIFICATION_METHOD'
155: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
156: );
157: JA_CN_FA_MM_EXPORT_PKG.Add_FA_Modification_Method( pn_legal_entity_id
158: , pn_ledger_id
159: , pv_accounting_year
160: , pv_period_from
161: , pv_period_to
162: );
163: -- Export FA Usage (usage status)
164: Ja_Cn_Utility.Print_Concurrent_Steps_For_Log
165: ( pv_step_number => '2.4'
166: , pv_report_name => 'ASSET_USAGE'
167: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
168: );
163: -- Export FA Usage (usage status)
164: Ja_Cn_Utility.Print_Concurrent_Steps_For_Log
165: ( pv_step_number => '2.4'
166: , pv_report_name => 'ASSET_USAGE'
167: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
168: );
169: JA_CN_FA_AU_EXPORT_PKG.Add_FA_Usage( pn_legal_entity_id
170: , pn_ledger_id
171: , pv_accounting_year
173: , pv_period_to
174: , pn_coa_id
175: );
176: -- Export FA Asset Card information
177: Ja_Cn_Utility.Print_Concurrent_Steps_For_Log
178: ( pv_step_number => '2.6'
179: , pv_report_name => 'FIXED_ASSET_CARD'
180: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
181: );
176: -- Export FA Asset Card information
177: Ja_Cn_Utility.Print_Concurrent_Steps_For_Log
178: ( pv_step_number => '2.6'
179: , pv_report_name => 'FIXED_ASSET_CARD'
180: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
181: );
182: JA_CN_PS_FA_AC_EXP_PKG.Add_FA_Asset_Card( pn_legal_entity_id
183: , pn_ledger_id
184: , pv_accounting_year
186: , pv_period_to
187: , pn_coa_id
188: );
189: -- Export FA Asset Card --Real Asset Information
190: Ja_Cn_Utility.Print_Concurrent_Steps_For_Log
191: ( pv_step_number => '2.7'
192: , pv_report_name => 'FIXED_ASSET_CARD-REAL_ASE_INFO'
193: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
194: );
189: -- Export FA Asset Card --Real Asset Information
190: Ja_Cn_Utility.Print_Concurrent_Steps_For_Log
191: ( pv_step_number => '2.7'
192: , pv_report_name => 'FIXED_ASSET_CARD-REAL_ASE_INFO'
193: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
194: );
195: JA_CN_FA_RAI_EXPORT_PKG.Add_FA_Real_Asset_Info( pn_legal_entity_id
196: , pn_ledger_id
197: , pv_accounting_year
198: , pv_period_from
199: , pv_period_to
200: );
201: -- Export FA Asset Card Usage Information
202: Ja_Cn_Utility.Print_Concurrent_Steps_For_Log
203: ( pv_step_number => '2.8'
204: , pv_report_name => 'FIXED_ASSET_CARD_USAGE_INFO'
205: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
206: );
201: -- Export FA Asset Card Usage Information
202: Ja_Cn_Utility.Print_Concurrent_Steps_For_Log
203: ( pv_step_number => '2.8'
204: , pv_report_name => 'FIXED_ASSET_CARD_USAGE_INFO'
205: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
206: );
207: JA_CN_PS_FA_ACUI_EXP_PKG.Add_FA_Usage_Info( pn_legal_entity_id
208: , pn_ledger_id
209: , pv_accounting_year
210: , pv_period_from
211: , pv_period_to
212: );
213: -- Export FA Decrease Information
214: Ja_Cn_Utility.Print_Concurrent_Steps_For_Log
215: ( pv_step_number => '2.9'
216: , pv_report_name => 'FIXED_ASSET_DECREASE_INFO'
217: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
218: );
213: -- Export FA Decrease Information
214: Ja_Cn_Utility.Print_Concurrent_Steps_For_Log
215: ( pv_step_number => '2.9'
216: , pv_report_name => 'FIXED_ASSET_DECREASE_INFO'
217: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
218: );
219: JA_CN_FA_ADI_EXPORT_PKG.Add_Asset_Decreasing_Info( pn_legal_entity_id
220: , pn_ledger_id
221: , pv_accounting_year
222: , pv_period_from
223: , pv_period_to
224: );
225: -- Export FA Decrease Information -- Real Asset Information
226: Ja_Cn_Utility.Print_Concurrent_Steps_For_Log
227: ( pv_step_number => '2.10'
228: , pv_report_name => 'FIXED_ASSET_DECR_INFO-REAL_ASE'
229: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
230: );
225: -- Export FA Decrease Information -- Real Asset Information
226: Ja_Cn_Utility.Print_Concurrent_Steps_For_Log
227: ( pv_step_number => '2.10'
228: , pv_report_name => 'FIXED_ASSET_DECR_INFO-REAL_ASE'
229: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
230: );
231: JA_CN_FA_ADIRA_EXPORT_PKG.Add_Asset_Decreasing_Real_Info
232: ( pn_legal_entity_id
233: , pn_ledger_id
235: , pv_period_from
236: , pv_period_to
237: );
238: -- Export FA Modification Information
239: Ja_Cn_Utility.Print_Concurrent_Steps_For_Log
240: ( pv_step_number => '2.11'
241: , pv_report_name => 'FIXED_ASSET_MODIFICATION_INFO'
242: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
243: );
238: -- Export FA Modification Information
239: Ja_Cn_Utility.Print_Concurrent_Steps_For_Log
240: ( pv_step_number => '2.11'
241: , pv_report_name => 'FIXED_ASSET_MODIFICATION_INFO'
242: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA
243: );
244: JA_CN_PS_FA_MI_EXP_PKG.Add_Asset_Modification_Info( pn_legal_entity_id
245: , pn_ledger_id
246: , pv_accounting_year
248: , pv_period_to
249: );
250: -- Export the XML tail tag
251: FND_FILE.put_line( FND_FILE.output
252: , Ja_Cn_Utility.Get_XML_Tag( 'FIXED_ASSETS'
253: , Ja_Cn_Utility.GV_TAG_TYPE_END
254: , Ja_Cn_Utility.GV_MODULE_FA)
255: );
256: --logging for debug
249: );
250: -- Export the XML tail tag
251: FND_FILE.put_line( FND_FILE.output
252: , Ja_Cn_Utility.Get_XML_Tag( 'FIXED_ASSETS'
253: , Ja_Cn_Utility.GV_TAG_TYPE_END
254: , Ja_Cn_Utility.GV_MODULE_FA)
255: );
256: --logging for debug
257: IF (ln_proc_level >= ln_dbg_level)
250: -- Export the XML tail tag
251: FND_FILE.put_line( FND_FILE.output
252: , Ja_Cn_Utility.Get_XML_Tag( 'FIXED_ASSETS'
253: , Ja_Cn_Utility.GV_TAG_TYPE_END
254: , Ja_Cn_Utility.GV_MODULE_FA)
255: );
256: --logging for debug
257: IF (ln_proc_level >= ln_dbg_level)
258: THEN
375:
376: --Step1: Check system option
377: FND_FILE.PUT_LINE( FND_FILE.LOG
378: , 'Step 1: Check System Option');
379: IF NOT (Ja_Cn_Utility.Check_Profile())
380: THEN
381: pv_retcode := 1;
382: pv_errbuf := '';
383: RETURN;
380: THEN
381: pv_retcode := 1;
382: pv_errbuf := '';
383: RETURN;
384: END IF; --(Ja_Cn_Utility.Check_Profile())
385:
386: IF NOT (Check_kff(pn_coa_id))
387: THEN
388: pv_retcode := 1;
491: --to convert charaterset of output file
492: FND_FILE.PUT_LINE( FND_FILE.LOG
493: , 'Step 3: Submit Characrter Set Conversion program
494: ');
495: Ja_Cn_Utility.Submit_XML_Charset_Conversion
496: ( p_xml_request_id => ln_reqid_gle
497: , p_source_charset => JA_CN_UTILITY.Get_XML_Encoding
498: , p_destination_charset => pv_dest_char_set
499: , p_source_separator => NULL
493: , 'Step 3: Submit Characrter Set Conversion program
494: ');
495: Ja_Cn_Utility.Submit_XML_Charset_Conversion
496: ( p_xml_request_id => ln_reqid_gle
497: , p_source_charset => JA_CN_UTILITY.Get_XML_Encoding
498: , p_destination_charset => pv_dest_char_set
499: , p_source_separator => NULL
500: , x_charset_request_id => ln_reqid_cvt
501: , x_result_flag => lv_cvt_req_status
505: --Step4: Submit "Change File Name" concurrent program
506: --to change name of output file
507: FND_FILE.PUT_LINE( FND_FILE.LOG
508: , 'Step 4: Submit File Name Renaming program');
509: lv_output_file_name := Ja_Cn_Utility.Generate_File_name
510: ( pv_module_name =>
511: JA_CN_UTILITY.GV_MODULE_FA
512: , pv_accounting_year => pv_accounting_year
513: , pv_ledger_id => pn_ledger_id
507: FND_FILE.PUT_LINE( FND_FILE.LOG
508: , 'Step 4: Submit File Name Renaming program');
509: lv_output_file_name := Ja_Cn_Utility.Generate_File_name
510: ( pv_module_name =>
511: JA_CN_UTILITY.GV_MODULE_FA
512: , pv_accounting_year => pv_accounting_year
513: , pv_ledger_id => pn_ledger_id
514: , pv_from_period => pv_period_from
515: , pv_to_period => pv_period_to
524: FND_FILE.put_line( FND_FILE.log
525: , lv_procedure_name || '.variable:'
526: || 'lv_output_file_name ='
527: || lv_output_file_name);
528: JA_CN_UTILITY.Change_Output_Filename
529: ( p_xml_request_id => ln_reqid_gle
530: , p_destination_charset => pv_dest_char_set
531: , p_destination_filename => lv_output_file_name
532: , x_filename_request_id => ln_reqid_chg