eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JA_CN_SI_EXPORT_PROG dependencies on JA_CN_UTILITY

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

94: 'pn_coa_id=' || pn_coa_id);
95:
96: -- export the header
97: -- here need to change
98: FND_FILE.put_line(FND_FILE.output,'');
99: lv_gl_element := '<' || Ja_Cn_Utility.Get_XML_Tag('SHARED_INFORMATION')
100: || ' xsi:schemaLocation="http://sxbw.audit.gov.cn/AccountingSoftwareDataInterfaceStandard/2010/SOE/XMLSchema '
101: || Ja_Cn_Utility.Get_XML_Tag('SHARED_INFORMATION')
102: || '.xsd" xmlns:'

Line 99: lv_gl_element := '<' || Ja_Cn_Utility.Get_XML_Tag('SHARED_INFORMATION')

95:
96: -- export the header
97: -- here need to change
98: FND_FILE.put_line(FND_FILE.output,'');
99: lv_gl_element := '<' || Ja_Cn_Utility.Get_XML_Tag('SHARED_INFORMATION')
100: || ' xsi:schemaLocation="http://sxbw.audit.gov.cn/AccountingSoftwareDataInterfaceStandard/2010/SOE/XMLSchema '
101: || Ja_Cn_Utility.Get_XML_Tag('SHARED_INFORMATION')
102: || '.xsd" xmlns:'
103: || Ja_Cn_Utility.Get_XML_Tag('SOE')

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

97: -- here need to change
98: FND_FILE.put_line(FND_FILE.output,'');
99: lv_gl_element := '<' || Ja_Cn_Utility.Get_XML_Tag('SHARED_INFORMATION')
100: || ' xsi:schemaLocation="http://sxbw.audit.gov.cn/AccountingSoftwareDataInterfaceStandard/2010/SOE/XMLSchema '
101: || Ja_Cn_Utility.Get_XML_Tag('SHARED_INFORMATION')
102: || '.xsd" xmlns:'
103: || Ja_Cn_Utility.Get_XML_Tag('SOE')
104: || '="http://sxbw.audit.gov.cn/AccountingSoftwareDataInterfaceStandard/2010/SOE/XMLSchema"
105: xmlns="http://sxbw.audit.gov.cn/AccountingSoftwareDataInterfaceStandard/2010/SOE/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">';

Line 103: || Ja_Cn_Utility.Get_XML_Tag('SOE')

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

Line 109: Ja_Cn_Utility.Print_Concurrent_Steps_For_Log( pv_step_number => '2.1'

105: xmlns="http://sxbw.audit.gov.cn/AccountingSoftwareDataInterfaceStandard/2010/SOE/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">';
106: FND_FILE.put_line(FND_FILE.output, lv_gl_element);
107:
108: -- call the procedures to export the reports seperately here begin
109: Ja_Cn_Utility.Print_Concurrent_Steps_For_Log( pv_step_number => '2.1'
110: , pv_report_name => 'ELECTRONIC_ACCOUNTING_BOOK');
111: JA_CN_GL_EAB_EXPORT_PKG.Add_Electronic_Accounting_Book( pn_legal_entity_id => pn_legal_entity_id
112: , pn_ledger_id => pn_ledger_id
113: , pn_accounting_year => TO_NUMBER(pv_accounting_year)

Line 115: Ja_Cn_Utility.Print_Concurrent_Steps_For_Log( pv_step_number => '2.2'

111: JA_CN_GL_EAB_EXPORT_PKG.Add_Electronic_Accounting_Book( pn_legal_entity_id => pn_legal_entity_id
112: , pn_ledger_id => pn_ledger_id
113: , pn_accounting_year => TO_NUMBER(pv_accounting_year)
114: );
115: Ja_Cn_Utility.Print_Concurrent_Steps_For_Log( pv_step_number => '2.2'
116: , pv_report_name => 'ACCOUNTING_PERIOD');
117: JA_CN_ACP_EXPORT_PKG.Add_Accounting_Periods( pn_legal_entity_id => pn_legal_entity_id
118: , pn_ledger_id => pn_ledger_id
119: , pn_accounting_year => TO_NUMBER(pv_accounting_year)

Line 121: Ja_Cn_Utility.Print_Concurrent_Steps_For_Log( pv_step_number => '2.3'

117: JA_CN_ACP_EXPORT_PKG.Add_Accounting_Periods( pn_legal_entity_id => pn_legal_entity_id
118: , pn_ledger_id => pn_ledger_id
119: , pn_accounting_year => TO_NUMBER(pv_accounting_year)
120: );
121: Ja_Cn_Utility.Print_Concurrent_Steps_For_Log( pv_step_number => '2.3'
122: , pv_report_name => 'JOURNAL_CATEGORY');
123: JA_CN_JC_EXPORT_PKG.Add_Journal_Categories( pn_legal_entity_id => pn_legal_entity_id
124: , pn_ledger_id => pn_ledger_id
125: , pn_accounting_year => TO_NUMBER(pv_accounting_year)

Line 127: Ja_Cn_Utility.Print_Concurrent_Steps_For_Log( pv_step_number => '2.4'

123: JA_CN_JC_EXPORT_PKG.Add_Journal_Categories( pn_legal_entity_id => pn_legal_entity_id
124: , pn_ledger_id => pn_ledger_id
125: , pn_accounting_year => TO_NUMBER(pv_accounting_year)
126: );
127: Ja_Cn_Utility.Print_Concurrent_Steps_For_Log( pv_step_number => '2.4'
128: , pv_report_name => 'EXCHANGE_RATE_TYPE');
129: JA_CN_ERT_EXPORT_PKG.Add_Exchange_Rate_Types( pn_legal_entity_id => pn_legal_entity_id
130: , pn_ledger_id => pn_ledger_id
131: , pn_accounting_year => TO_NUMBER(pv_accounting_year)

Line 133: Ja_Cn_Utility.Print_Concurrent_Steps_For_Log( pv_step_number => '2.5'

129: JA_CN_ERT_EXPORT_PKG.Add_Exchange_Rate_Types( pn_legal_entity_id => pn_legal_entity_id
130: , pn_ledger_id => pn_ledger_id
131: , pn_accounting_year => TO_NUMBER(pv_accounting_year)
132: );
133: Ja_Cn_Utility.Print_Concurrent_Steps_For_Log( pv_step_number => '2.5'
134: , pv_report_name => 'CURRENCY');
135: JA_CN_CUR_EXPORT_PKG.Add_Currencies( pn_legal_entity_id => pn_legal_entity_id
136: , pn_ledger_id => pn_ledger_id
137: , pn_accounting_year => TO_NUMBER(pv_accounting_year)

Line 139: Ja_Cn_Utility.Print_Concurrent_Steps_For_Log( pv_step_number => '2.6'

135: JA_CN_CUR_EXPORT_PKG.Add_Currencies( pn_legal_entity_id => pn_legal_entity_id
136: , pn_ledger_id => pn_ledger_id
137: , pn_accounting_year => TO_NUMBER(pv_accounting_year)
138: );
139: Ja_Cn_Utility.Print_Concurrent_Steps_For_Log( pv_step_number => '2.6'
140: , pv_report_name => 'SETTLEMENT_METHOD');
141: JA_CN_SM_EXPORT_PKG.Add_Settlement_Method( pn_ledger_id => pn_ledger_id
142: , pn_legal_entity_id => pn_legal_entity_id
143: , pv_accounting_year => pv_accounting_year

Line 145: Ja_Cn_Utility.Print_Concurrent_Steps_For_Log( pv_step_number => '2.7'

141: JA_CN_SM_EXPORT_PKG.Add_Settlement_Method( pn_ledger_id => pn_ledger_id
142: , pn_legal_entity_id => pn_legal_entity_id
143: , pv_accounting_year => pv_accounting_year
144: );
145: Ja_Cn_Utility.Print_Concurrent_Steps_For_Log( pv_step_number => '2.7'
146: , pv_report_name => 'DEPARTMENT_RECORDS');
147: JA_CN_HRMS_EXPORT_PKG.Add_Department_Records( pn_legal_entity_id => pn_legal_entity_id
148: , pn_ledger_id => pn_ledger_id
149: , pv_accounting_year => pv_accounting_year

Line 151: Ja_Cn_Utility.Print_Concurrent_Steps_For_Log( pv_step_number => '2.8'

147: JA_CN_HRMS_EXPORT_PKG.Add_Department_Records( pn_legal_entity_id => pn_legal_entity_id
148: , pn_ledger_id => pn_ledger_id
149: , pv_accounting_year => pv_accounting_year
150: );
151: Ja_Cn_Utility.Print_Concurrent_Steps_For_Log( pv_step_number => '2.8'
152: , pv_report_name => 'EMPLOYEE_RECORDS');
153: JA_CN_HRMS_EXPORT_PKG.Add_Employee_Records( pn_legal_entity_id => pn_legal_entity_id
154: , pn_ledger_id => pn_ledger_id
155: , pv_accounting_year => pv_accounting_year

Line 157: Ja_Cn_Utility.Print_Concurrent_Steps_For_Log( pv_step_number => '2.9'

153: JA_CN_HRMS_EXPORT_PKG.Add_Employee_Records( pn_legal_entity_id => pn_legal_entity_id
154: , pn_ledger_id => pn_ledger_id
155: , pv_accounting_year => pv_accounting_year
156: );
157: Ja_Cn_Utility.Print_Concurrent_Steps_For_Log( pv_step_number => '2.9'
158: , pv_report_name => 'SUPPLIER_RECORD');
159: JA_CN_SR_EXPORT_PKG.Add_Supplier( pn_legal_entity_id => pn_legal_entity_id
160: , pv_accounting_year => pv_accounting_year
161: );

Line 162: Ja_Cn_Utility.Print_Concurrent_Steps_For_Log( pv_step_number => '2.10'

158: , pv_report_name => 'SUPPLIER_RECORD');
159: JA_CN_SR_EXPORT_PKG.Add_Supplier( pn_legal_entity_id => pn_legal_entity_id
160: , pv_accounting_year => pv_accounting_year
161: );
162: Ja_Cn_Utility.Print_Concurrent_Steps_For_Log( pv_step_number => '2.10'
163: , pv_report_name => 'CUSTOMER_RECORD');
164: JA_CN_CR_EXPORT_PKG.Add_Customer(pn_legal_entity_id => pn_legal_entity_id
165: ,pv_accounting_year => pv_accounting_year);
166: Ja_Cn_Utility.Print_Concurrent_Steps_For_Log( pv_step_number => '2.11'

Line 166: Ja_Cn_Utility.Print_Concurrent_Steps_For_Log( pv_step_number => '2.11'

162: Ja_Cn_Utility.Print_Concurrent_Steps_For_Log( pv_step_number => '2.10'
163: , pv_report_name => 'CUSTOMER_RECORD');
164: JA_CN_CR_EXPORT_PKG.Add_Customer(pn_legal_entity_id => pn_legal_entity_id
165: ,pv_accounting_year => pv_accounting_year);
166: Ja_Cn_Utility.Print_Concurrent_Steps_For_Log( pv_step_number => '2.11'
167: , pv_report_name => 'USER_DEFINED_RECORDS');
168: JA_CN_UDR_EXPORT.Add_User_Defined_Records( pn_coa_id => pn_coa_id
169: , pn_le_id => pn_legal_entity_id
170: , pn_ledger_id => pn_ledger_id

Line 173: Ja_Cn_Utility.Print_Concurrent_Steps_For_Log( pv_step_number => '2.12'

169: , pn_le_id => pn_legal_entity_id
170: , pn_ledger_id => pn_ledger_id
171: , pv_accounting_year => pv_accounting_year
172: );
173: Ja_Cn_Utility.Print_Concurrent_Steps_For_Log( pv_step_number => '2.12'
174: , pv_report_name => 'USER_DEFINED_RECORD_VALUE');
175: JA_CN_UDRV_EXPORT.Add_User_Defined_Record_Value( pn_coa_id => pn_coa_id
176: , pn_le_id => pn_legal_entity_id
177: , pn_ledger_id => pn_ledger_id

Line 183: , Ja_Cn_Utility.Get_XML_Tag('SHARED_INFORMATION', Ja_Cn_Utility.GV_TAG_TYPE_END));

179: );
180: -- call the procedures to export the reports seperately here end
181:
182: FND_FILE.put_line( FND_FILE.output
183: , Ja_Cn_Utility.Get_XML_Tag('SHARED_INFORMATION', Ja_Cn_Utility.GV_TAG_TYPE_END));
184:
185: --logging for debug
186: IF (ln_proc_level >= ln_dbg_level)
187: THEN

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

300: 'pn_coa_id=' || pn_coa_id);
301:
302: --Step1: Check system option
303: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Step 1: Check System Option');
304: IF NOT(Ja_Cn_Utility.Check_System_Option(pn_legal_entity_id))
305: THEN
306: pv_retcode := 1;
307: pv_errbuf := '';
308: RETURN;

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

305: THEN
306: pv_retcode := 1;
307: pv_errbuf := '';
308: RETURN;
309: END IF; --(Ja_Cn_Utility.Check_System_Option(pn_legal_entity_id))
310:
311: --Step2: Submit SI Export program
312: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Step 2: Submit SI Export program');
313: ln_reqid_gle:=FND_REQUEST.Submit_Request( application => 'JA'

Line 357: Ja_Cn_Utility.Submit_XML_Charset_Conversion( p_xml_request_id => ln_reqid_gle

353:
354: --Step3: Submit characrter set conversion program
355: --to convert charaterset of output file
356: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Step 3: Submit Characrter Set Conversion program');
357: Ja_Cn_Utility.Submit_XML_Charset_Conversion( p_xml_request_id => ln_reqid_gle
358: , p_source_charset => JA_CN_UTILITY.Get_XML_Encoding
359: , p_destination_charset => pv_dest_char_set
360: , p_source_separator => NULL
361: , x_charset_request_id => ln_reqid_cvt

Line 358: , p_source_charset => JA_CN_UTILITY.Get_XML_Encoding

354: --Step3: Submit characrter set conversion program
355: --to convert charaterset of output file
356: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Step 3: Submit Characrter Set Conversion program');
357: Ja_Cn_Utility.Submit_XML_Charset_Conversion( p_xml_request_id => ln_reqid_gle
358: , p_source_charset => JA_CN_UTILITY.Get_XML_Encoding
359: , p_destination_charset => pv_dest_char_set
360: , p_source_separator => NULL
361: , x_charset_request_id => ln_reqid_cvt
362: , x_result_flag => lv_cvt_req_status

Line 369: lv_output_file_name := Ja_Cn_Utility.Generate_File_name( pv_module_name => 'SI'

365: THEN
366: --Step4: Submit "Change File Name" concurrent program
367: --to change name of output file
368: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Step 4: Submit File Name Renaming program');
369: lv_output_file_name := Ja_Cn_Utility.Generate_File_name( pv_module_name => 'SI'
370: , pv_accounting_year => pv_accounting_year
371: , pv_ledger_id => pn_ledger_id
372: , pv_from_period => null
373: , pv_to_period => null

Line 386: JA_CN_UTILITY.Change_Output_Filename( p_xml_request_id => ln_reqid_gle

382: FND_FILE.put_line(FND_FILE.log, lv_procedure_name ||
383: '.variable:' ||
384: 'lv_output_file_name =' || lv_output_file_name);
385:
386: JA_CN_UTILITY.Change_Output_Filename( p_xml_request_id => ln_reqid_gle
387: , p_destination_charset => pv_dest_char_set
388: , p_destination_filename => lv_output_file_name
389: , x_filename_request_id => ln_reqid_chg
390: , x_result_flag => lv_chg_req_status