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_PS_GL_EXPORT_PROG dependencies on JA_CN_UTILITY

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 104: lv_gl_element := '<' || Ja_Cn_Utility.Get_XML_Tag('GENERAL_LEDGER') || ' xsi:schemaLocation="http://sxbw.audit.gov.cn/AccountingSoftwareDataInterfaceStandard/2010/PSGA/XMLSchema ' ||

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">';
108:

Line 105: Ja_Cn_Utility.Get_XML_Tag('GENERAL_LEDGER') || '.xsd" xmlns:' ||

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">';
108:
109: FND_FILE.put_line(FND_FILE.output, lv_gl_element);

Line 106: Ja_Cn_Utility.Get_XML_Tag('PUBLIC_SECTOR') || '="http://sxbw.audit.gov.cn/AccountingSoftwareDataInterfaceStandard/2010/PSGA/XMLSchema"'||

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">';
108:
109: FND_FILE.put_line(FND_FILE.output, lv_gl_element);
110:

Line 112: Ja_Cn_Utility.Print_Concurrent_Steps_For_Log('2.1', 'GL_BASIC_INFORMATION');

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);
114:
115: --Step3: Export Journal Category
116: Ja_Cn_Utility.Print_Concurrent_Steps_For_Log('2.2','JOURNAL_CATEGORY');

Line 116: Ja_Cn_Utility.Print_Concurrent_Steps_For_Log('2.2','JOURNAL_CATEGORY');

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);
114:
115: --Step3: Export Journal Category
116: Ja_Cn_Utility.Print_Concurrent_Steps_For_Log('2.2','JOURNAL_CATEGORY');
117: JA_CN_JC_EXPORT_PKG.Add_Journal_Categories( 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: );

Line 123: Ja_Cn_Utility.Print_Concurrent_Steps_For_Log('2.3', 'CHART_OF_ACCOUNT');

119: , pn_accounting_year => TO_NUMBER(pv_accounting_year)
120: );
121:
122: --Step4: Export COA
123: Ja_Cn_Utility.Print_Concurrent_Steps_For_Log('2.3', 'CHART_OF_ACCOUNT');
124: JA_CN_COA_EXPORT_PKG.Add_COA(pn_coa_id => pn_chart_of_account_id
125: ,pn_ledger_id => pn_ledger_id
126: ,pn_le_id => pn_legal_entity_id
127: ,pv_xml_template_language => pv_xml_template_language

Line 133: Ja_Cn_Utility.Print_Concurrent_Steps_For_Log('2.4', 'SUBSIDIARY_ITEM_OF_ACCOUNT');

129: ,pv_xml_output_format => pv_xml_output_format
130: );
131:
132: --Step5: Export Subsidiary Item of Account
133: Ja_Cn_Utility.Print_Concurrent_Steps_For_Log('2.4', 'SUBSIDIARY_ITEM_OF_ACCOUNT');
134: JA_CN_SIOA_EXPORT_PKG.Add_Sub_Item_Of_Account(pn_ledger_id => pn_ledger_id
135: ,pn_legal_entity_id => pn_legal_entity_id
136: ,pn_chart_of_account_id => pn_chart_of_account_id
137: ,pv_accounting_year => pv_accounting_year

Line 141: Ja_Cn_Utility.Print_Concurrent_Steps_For_Log('2.5', 'ACC_PERIOD_AMOUNT_AND_BALANCE');

137: ,pv_accounting_year => pv_accounting_year
138: );
139:
140: --Step6: Export Accounting Period Amount and Balance
141: Ja_Cn_Utility.Print_Concurrent_Steps_For_Log('2.5', 'ACC_PERIOD_AMOUNT_AND_BALANCE');
142: JA_CN_APAB_EXPORT_PKG.Add_Account_Amount_Balance(pn_legal_entity_id => pn_legal_entity_id
143: ,pn_ledger_id => pn_ledger_id
144: ,pv_accounting_year => pv_accounting_year
145: ,pn_coa_id => pn_chart_of_account_id

Line 150: Ja_Cn_Utility.Print_Concurrent_Steps_For_Log('2.6', 'JOURNAL');

146: ,pv_period_from => pv_period_from
147: ,pv_period_to => pv_period_to
148: );
149: --Step7: Export Journal
150: Ja_Cn_Utility.Print_Concurrent_Steps_For_Log('2.6', 'JOURNAL');
151: JA_CN_JE_EXPORT_PKG.Add_Journal(pn_legal_entity_id => pn_legal_entity_id
152: ,pn_ledger_id => pn_ledger_id
153: ,pv_accounting_year => pv_accounting_year
154: ,pn_coa_id => pn_chart_of_account_id

Line 159: Ja_Cn_Utility.Print_Concurrent_Steps_For_Log('2.7', 'CURRENT_YEAR_BUDGET_TARGET');

155: ,pv_period_from => pv_period_from
156: ,pv_period_to => pv_period_to
157: );
158: --Step8: Export Current Year Budget
159: Ja_Cn_Utility.Print_Concurrent_Steps_For_Log('2.7', 'CURRENT_YEAR_BUDGET_TARGET');
160: JA_CN_PS_CYB_EXPORT_PKG.Add_Current_Year_Budget(pn_legal_entity_id => pn_legal_entity_id
161: ,pn_ledger_id => pn_ledger_id
162: ,pn_coa_id => pn_chart_of_account_id
163: ,pv_accounting_year => pv_accounting_year

Line 169: Ja_Cn_Utility.Print_Concurrent_Steps_For_Log('2.8', 'BUDGET_EXPENDITURE');

165: ,pv_period_to => pv_period_to
166: );
167:
168: --Step9: Export Budget Expenditure
169: Ja_Cn_Utility.Print_Concurrent_Steps_For_Log('2.8', 'BUDGET_EXPENDITURE');
170: JA_CN_PS_BE_EXPORT_PKG.Add_Budget_Expenditure(pn_legal_entity_id => pn_legal_entity_id
171: ,pn_ledger_id => pn_ledger_id
172: ,pn_coa_id => pn_chart_of_account_id
173: ,pv_accounting_year => pv_accounting_year

Line 178: Ja_Cn_Utility.Print_Concurrent_Steps_For_Log('2.9', 'BUDGET_INCOME');

174: ,pv_period_from => pv_period_from
175: ,pv_period_to => pv_period_to
176: );
177: --Step10: Export Budget Income
178: Ja_Cn_Utility.Print_Concurrent_Steps_For_Log('2.9', 'BUDGET_INCOME');
179: JA_CN_PS_BI_EXPORT_PKG.Add_Budget_Income(pn_legal_entity_id => pn_legal_entity_id
180: ,pn_ledger_id => pn_ledger_id
181: ,pn_coa_id => pn_chart_of_account_id
182: ,pv_accounting_year => pv_accounting_year

Line 188: ,Ja_Cn_Utility.Get_XML_Tag('GENERAL_LEDGER'

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

Line 189: ,Ja_Cn_Utility.GV_TAG_TYPE_END

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

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

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 := '';
407: RETURN;

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

404: THEN
405: pv_retcode := 1;
406: pv_errbuf := '';
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)

Line 412: IF NOT(JA_CN_UTILITY.Check_Profile)

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 := '';
416: RETURN;

Line 599: JA_CN_UTILITY.Submit_XML_Charset_Conversion(p_xml_request_id => ln_reqid_comb

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
603: ,x_charset_request_id => ln_reqid_cvt

Line 600: ,p_source_charset => JA_CN_UTILITY.Get_XML_Encoding

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
603: ,x_charset_request_id => ln_reqid_cvt
604: ,x_result_flag => lv_cvt_req_status

Line 611: lv_output_file_name := Ja_Cn_Utility.Generate_File_name(pv_module_name => 'GL'

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
615: ,pv_to_period => lv_period_to

Line 628: JA_CN_UTILITY.Change_Output_Filename(p_xml_request_id => ln_reqid_comb

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
629: ,p_destination_charset => pv_dest_char_set
630: ,p_destination_filename => lv_output_file_name
631: ,x_filename_request_id => ln_reqid_chg
632: ,x_result_flag => lv_chg_req_status