DBA Data[Home] [Help]

APPS.JA_CN_PS_SI_EXPORT_PKG dependencies on JA_CN_UTILITY

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

86:
87: --export the header
88: FND_FILE.put_line( FND_FILE.output
89: , ' 90: || JA_CN_UTILITY.Get_XML_Encoding || '"?>');
91: lv_si_element := '<' || Ja_Cn_Utility.Get_XML_Tag('SHARED_INFORMATION')
92: || ' xsi:schemaLocation="http://sxbw.audit.gov.cn'
93: || '/AccountingSoftwareDataInterfaceStandard/2010/PSGA/'
94: || 'XMLSchema '

Line 91: lv_si_element := '<' || Ja_Cn_Utility.Get_XML_Tag('SHARED_INFORMATION')

87: --export the header
88: FND_FILE.put_line( FND_FILE.output
89: , ' 90: || JA_CN_UTILITY.Get_XML_Encoding || '"?>');
91: lv_si_element := '<' || Ja_Cn_Utility.Get_XML_Tag('SHARED_INFORMATION')
92: || ' xsi:schemaLocation="http://sxbw.audit.gov.cn'
93: || '/AccountingSoftwareDataInterfaceStandard/2010/PSGA/'
94: || 'XMLSchema '
95: || Ja_Cn_Utility.Get_XML_Tag('SHARED_INFORMATION')

Line 95: || Ja_Cn_Utility.Get_XML_Tag('SHARED_INFORMATION')

91: lv_si_element := '<' || Ja_Cn_Utility.Get_XML_Tag('SHARED_INFORMATION')
92: || ' xsi:schemaLocation="http://sxbw.audit.gov.cn'
93: || '/AccountingSoftwareDataInterfaceStandard/2010/PSGA/'
94: || 'XMLSchema '
95: || Ja_Cn_Utility.Get_XML_Tag('SHARED_INFORMATION')
96: || '.xsd" xmlns:'
97: || Ja_Cn_Utility.Get_XML_Tag('PUBLIC_SECTOR')
98: || '="http://sxbw.audit.gov.cn/'
99: || 'AccountingSoftwareDataInterfaceStandard/'

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

93: || '/AccountingSoftwareDataInterfaceStandard/2010/PSGA/'
94: || 'XMLSchema '
95: || Ja_Cn_Utility.Get_XML_Tag('SHARED_INFORMATION')
96: || '.xsd" xmlns:'
97: || Ja_Cn_Utility.Get_XML_Tag('PUBLIC_SECTOR')
98: || '="http://sxbw.audit.gov.cn/'
99: || 'AccountingSoftwareDataInterfaceStandard/'
100: || '2010/PSGA/XMLSchema" '
101: || 'xmlns="http://sxbw.audit.gov.cn/'

Line 110: JA_CN_UTILITY.Print_Concurrent_Steps_For_Log

106: FND_FILE.put_line( FND_FILE.output
107: , lv_si_element);
108: --call the procedures to export the reports seperately here begin
109: --export Electronic Accounting Book
110: JA_CN_UTILITY.Print_Concurrent_Steps_For_Log
111: ( pv_step_number => '2.1'
112: , pv_report_name => 'ELECTRONIC_ACCOUNTING_BOOK'
113: );
114: JA_CN_PS_SI_EAB_EXPORT_PKG.Add_Electronic_Accounting_Book

Line 120: JA_CN_UTILITY.Print_Concurrent_Steps_For_Log

116: , pn_ledger_id
117: , pn_accounting_year
118: );
119: --export Accounting Periods Information
120: JA_CN_UTILITY.Print_Concurrent_Steps_For_Log
121: ( pv_step_number => '2.2'
122: , pv_report_name => 'ACCOUNTING_PERIOD'
123: );
124: JA_CN_ACP_EXPORT_PKG.Add_Accounting_Periods( pn_legal_entity_id

Line 129: JA_CN_UTILITY.Print_Concurrent_Steps_For_Log

125: , pn_ledger_id
126: , pn_accounting_year
127: );
128: --export Bank Account Information
129: JA_CN_UTILITY.Print_Concurrent_Steps_For_Log
130: ( pv_step_number => '2.3'
131: , pv_report_name => 'BANK_ACCOUNT_INFORMATION'
132: );
133: JA_CN_PS_SI_BAI_EXPORT_PKG.Add_Bank_Account_Information( pn_legal_entity_id

Line 137: JA_CN_UTILITY.Print_Concurrent_Steps_For_Log

133: JA_CN_PS_SI_BAI_EXPORT_PKG.Add_Bank_Account_Information( pn_legal_entity_id
134: , pn_accounting_year
135: );
136: --export Settlement method Information
137: JA_CN_UTILITY.Print_Concurrent_Steps_For_Log
138: ( pv_step_number => '2.4'
139: , pv_report_name => 'SETTLEMENT_METHOD'
140: );
141: JA_CN_PS_SI_SM_EXPORT_PKG.Add_Settlement_Method( pn_legal_entity_id

Line 146: JA_CN_UTILITY.Print_Concurrent_Steps_For_Log

142: , pn_ledger_id
143: , pn_accounting_year
144: );
145: --export internal organization
146: JA_CN_UTILITY.Print_Concurrent_Steps_For_Log
147: ( pv_step_number => '2.5'
148: , pv_report_name => 'INNER_ORGANIZATION_RECORDS'
149: );
150: JA_CN_PS_HRMS_EXPORT_PKG.Add_Department_Records( pn_legal_entity_id

Line 155: JA_CN_UTILITY.Print_Concurrent_Steps_For_Log

151: , pn_ledger_id
152: , TO_CHAR(pn_accounting_year)
153: );
154: --export employee category
155: JA_CN_UTILITY.Print_Concurrent_Steps_For_Log
156: ( pv_step_number => '2.6'
157: , pv_report_name => 'STAFF_CATEGORY'
158: );
159: JA_CN_PS_HRMS_EXPORT_PKG.Add_Employee_Category( pn_legal_entity_id

Line 164: JA_CN_UTILITY.Print_Concurrent_Steps_For_Log

160: , pn_ledger_id
161: , TO_CHAR(pn_accounting_year)
162: );
163: --export employee records
164: JA_CN_UTILITY.Print_Concurrent_Steps_For_Log
165: ( pv_step_number => '2.7'
166: , pv_report_name => 'STAFF_RECORDS'
167: );
168: JA_CN_PS_HRMS_EXPORT_PKG.Add_Employee_Records( pn_legal_entity_id

Line 173: JA_CN_UTILITY.Print_Concurrent_Steps_For_Log( pv_step_number => '2.8'

169: , pn_ledger_id
170: , TO_CHAR(pn_accounting_year)
171: );
172: --export Project Information
173: JA_CN_UTILITY.Print_Concurrent_Steps_For_Log( pv_step_number => '2.8'
174: , pv_report_name => 'PROJECT'
175: );
176: JA_CN_PS_SI_PRJ_EXPORT_PKG.Add_Project_Information( pn_coa_id
177: , pn_accounting_year

Line 180: JA_CN_UTILITY.Print_Concurrent_Steps_For_Log

176: JA_CN_PS_SI_PRJ_EXPORT_PKG.Add_Project_Information( pn_coa_id
177: , pn_accounting_year
178: );
179: --export User-defined Records Information
180: JA_CN_UTILITY.Print_Concurrent_Steps_For_Log
181: ( pv_step_number => '2.9'
182: , pv_report_name => 'USER_DEFINED_RECORDS'
183: );
184: JA_CN_UDR_EXPORT.Add_User_Defined_Records( pn_coa_id

Line 190: JA_CN_UTILITY.Print_Concurrent_Steps_For_Log

186: , pn_ledger_id
187: , pn_accounting_year
188: );
189: --export User-defined Record Values
190: JA_CN_UTILITY.Print_Concurrent_Steps_For_Log
191: ( pv_step_number => '2.10'
192: , pv_report_name => 'USER_DEFINED_RECORD_VALUE'
193: );
194: JA_CN_UDRV_EXPORT.Add_User_Defined_Record_Value( pn_coa_id

Line 200: JA_CN_UTILITY.Print_Concurrent_Steps_For_Log( pv_step_number => '2.11'

196: , pn_ledger_id
197: , pn_accounting_year
198: );
199: --export Currency
200: JA_CN_UTILITY.Print_Concurrent_Steps_For_Log( pv_step_number => '2.11'
201: , pv_report_name => 'CURRENCY'
202: );
203: JA_CN_CUR_EXPORT_PKG.Add_Currencies( pn_legal_entity_id
204: , pn_ledger_id

Line 208: JA_CN_UTILITY.Print_Concurrent_Steps_For_Log

204: , pn_ledger_id
205: , pn_accounting_year
206: );
207: --export Exchange Rate Type
208: JA_CN_UTILITY.Print_Concurrent_Steps_For_Log
209: ( pv_step_number => '2.12'
210: , pv_report_name => 'EXCHANGE_RATE_TYPE'
211: );
212: JA_CN_ERT_EXPORT_PKG.Add_Exchange_Rate_Types( pn_legal_entity_id

Line 219: , Ja_Cn_Utility.Get_XML_Tag( 'SHARED_INFORMATION'

215: );
216: -- call the procedures to export the reports seperately here end
217:
218: FND_FILE.put_line( FND_FILE.output
219: , Ja_Cn_Utility.Get_XML_Tag( 'SHARED_INFORMATION'
220: , Ja_Cn_Utility.GV_TAG_TYPE_END
221: ));
222: --logging for debug
223: IF (ln_proc_level >= ln_dbg_level)

Line 220: , Ja_Cn_Utility.GV_TAG_TYPE_END

216: -- call the procedures to export the reports seperately here end
217:
218: FND_FILE.put_line( FND_FILE.output
219: , Ja_Cn_Utility.Get_XML_Tag( 'SHARED_INFORMATION'
220: , Ja_Cn_Utility.GV_TAG_TYPE_END
221: ));
222: --logging for debug
223: IF (ln_proc_level >= ln_dbg_level)
224: THEN

Line 339: IF NOT(Ja_Cn_Utility.Check_System_Option(pn_legal_entity_id))

335: || 'pn_coa_id=' || pn_coa_id);
336: --Step1: Check system option
337: FND_FILE.PUT_LINE( FND_FILE.LOG
338: , 'Step 1: Check System Option');
339: IF NOT(Ja_Cn_Utility.Check_System_Option(pn_legal_entity_id))
340: THEN
341: pv_retcode := 1;
342: pv_errbuf := '';
343: RETURN;

Line 344: END IF; --(Ja_Cn_Utility.Check_System_Option(pn_legal_entity_id))

340: THEN
341: pv_retcode := 1;
342: pv_errbuf := '';
343: RETURN;
344: END IF; --(Ja_Cn_Utility.Check_System_Option(pn_legal_entity_id))
345: --Step2: Submit SI Export program
346: FND_FILE.PUT_LINE( FND_FILE.LOG
347: , 'Step 2: Submit SI Export program');
348: ln_reqid_gle:=FND_REQUEST.Submit_Request( application => 'JA'

Line 390: Ja_Cn_Utility.Submit_XML_Charset_Conversion

386: --Step3: Submit characrter set conversion program
387: --to convert charaterset of output file
388: FND_FILE.PUT_LINE( FND_FILE.LOG
389: , 'Step 3: Submit Characrter Set Conversion program');
390: Ja_Cn_Utility.Submit_XML_Charset_Conversion
391: ( p_xml_request_id => ln_reqid_gle
392: , p_source_charset => JA_CN_UTILITY.Get_XML_Encoding
393: , p_destination_charset => pv_dest_char_set
394: , p_source_separator => NULL

Line 392: , p_source_charset => JA_CN_UTILITY.Get_XML_Encoding

388: FND_FILE.PUT_LINE( FND_FILE.LOG
389: , 'Step 3: Submit Characrter Set Conversion program');
390: Ja_Cn_Utility.Submit_XML_Charset_Conversion
391: ( p_xml_request_id => ln_reqid_gle
392: , p_source_charset => JA_CN_UTILITY.Get_XML_Encoding
393: , p_destination_charset => pv_dest_char_set
394: , p_source_separator => NULL
395: , x_charset_request_id => ln_reqid_cvt
396: , x_result_flag => lv_cvt_req_status

Line 404: lv_output_file_name := Ja_Cn_Utility.Generate_File_name

400: --Step4: Submit "Change File Name" concurrent program
401: --to change name of output file
402: FND_FILE.PUT_LINE( FND_FILE.LOG
403: , 'Step 4: Submit File Name Renaming program');
404: lv_output_file_name := Ja_Cn_Utility.Generate_File_name
405: ( pv_module_name => 'SI'
406: , pv_accounting_year => pn_accounting_year
407: , pv_ledger_id => pn_ledger_id
408: , pv_from_period => null

Line 422: JA_CN_UTILITY.Change_Output_Filename

418: FND_FILE.put_line( FND_FILE.log
419: , lv_procedure_name || '.variable:'
420: || 'lv_output_file_name =' ||lv_output_file_name);
421:
422: JA_CN_UTILITY.Change_Output_Filename
423: ( p_xml_request_id => ln_reqid_gle
424: , p_destination_charset => pv_dest_char_set
425: , p_destination_filename => lv_output_file_name
426: , x_filename_request_id => ln_reqid_chg