DBA Data[Home] [Help]

APPS.JA_CN_PS_FA_EXP_PKG dependencies on JA_CN_UTILITY

Line 96: lv_bsv_flag := JA_CN_UTILITY.Populate_Ledger_Le_Bsv_Gt(p_Ledger_Id => pn_ledger_id

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

Line 103: || JA_CN_UTILITY.Get_XML_Encoding || '"?>');

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)

Line 105: Ja_Cn_Utility.Get_XML_Tag( 'FIXED_ASSETS'

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/'

Line 106: , Ja_Cn_Utility.GV_REQUIRED_NO

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 '

Line 107: , Ja_Cn_Utility.GV_MODULE_FA)

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'

Line 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')

Line 112: , Ja_Cn_Utility.GV_REQUIRED_NO

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/'

Line 113: , Ja_Cn_Utility.GV_MODULE_FA)

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/'

Line 115: || Ja_Cn_Utility.Get_XML_Tag('PUBLIC_SECTOR')

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/'

Line 128: Ja_Cn_Utility.Print_Concurrent_Steps_For_Log

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: );

Line 131: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA

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

Line 140: Ja_Cn_Utility.Print_Concurrent_Steps_For_Log

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: );

Line 143: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA

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

Line 152: Ja_Cn_Utility.Print_Concurrent_Steps_For_Log

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: );

Line 155: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA

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

Line 164: Ja_Cn_Utility.Print_Concurrent_Steps_For_Log

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: );

Line 167: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA

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

Line 177: Ja_Cn_Utility.Print_Concurrent_Steps_For_Log

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: );

Line 180: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA

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

Line 190: Ja_Cn_Utility.Print_Concurrent_Steps_For_Log

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: );

Line 193: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA

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

Line 202: Ja_Cn_Utility.Print_Concurrent_Steps_For_Log

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: );

Line 205: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA

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

Line 214: Ja_Cn_Utility.Print_Concurrent_Steps_For_Log

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: );

Line 217: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA

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

Line 226: Ja_Cn_Utility.Print_Concurrent_Steps_For_Log

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: );

Line 229: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA

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

Line 239: Ja_Cn_Utility.Print_Concurrent_Steps_For_Log

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: );

Line 242: , pv_module_name => Ja_Cn_Utility.GV_MODULE_FA

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

Line 252: , Ja_Cn_Utility.Get_XML_Tag( 'FIXED_ASSETS'

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

Line 253: , Ja_Cn_Utility.GV_TAG_TYPE_END

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)

Line 254: , Ja_Cn_Utility.GV_MODULE_FA)

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

Line 379: IF NOT (Ja_Cn_Utility.Check_Profile())

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;

Line 384: END IF; --(Ja_Cn_Utility.Check_Profile())

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;

Line 495: Ja_Cn_Utility.Submit_XML_Charset_Conversion

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

Line 497: , p_source_charset => JA_CN_UTILITY.Get_XML_Encoding

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

Line 509: lv_output_file_name := Ja_Cn_Utility.Generate_File_name

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

Line 511: JA_CN_UTILITY.GV_MODULE_FA

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

Line 528: JA_CN_UTILITY.Change_Output_Filename

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