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

Line 100: IF ja_cn_utility.populate_ledger_le_bsv_gt(pn_ledger_id, pn_legal_entity_id) <> 'S' THEN

96: --Step0: Populate balancing segment values to table ja_cn_ledger_le_bsv_gt
97: DELETE
98: FROM JA_CN_LEDGER_LE_BSV_GT;
99: COMMIT ;
100: IF ja_cn_utility.populate_ledger_le_bsv_gt(pn_ledger_id, pn_legal_entity_id) <> 'S' THEN
101: RETURN;
102: END IF;
103:
104: --Step1: Generate XML header part

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

101: RETURN;
102: END IF;
103:
104: --Step1: Generate XML header part
105: FND_FILE.put_line(FND_FILE.output,'');
106: lv_gl_element := '<' || Ja_Cn_Utility.Get_XML_Tag('RECEIVABLE_PAYABLE',Ja_Cn_Utility.GV_REQUIRED_NO,Ja_Cn_Utility.GV_MODULE_APAR) ||
107: ' xsi:schemaLocation="http://sxbw.audit.gov.cn/AccountingSoftwareDataInterfaceStandard/2010/SOE/XMLSchema ' ||
108: Ja_Cn_Utility.Get_XML_Tag('RECEIVABLE_PAYABLE',Ja_Cn_Utility.GV_REQUIRED_NO,Ja_Cn_Utility.GV_MODULE_APAR) ||
109: '.xsd" xmlns:' ||

Line 106: lv_gl_element := '<' || Ja_Cn_Utility.Get_XML_Tag('RECEIVABLE_PAYABLE',Ja_Cn_Utility.GV_REQUIRED_NO,Ja_Cn_Utility.GV_MODULE_APAR) ||

102: END IF;
103:
104: --Step1: Generate XML header part
105: FND_FILE.put_line(FND_FILE.output,'');
106: lv_gl_element := '<' || Ja_Cn_Utility.Get_XML_Tag('RECEIVABLE_PAYABLE',Ja_Cn_Utility.GV_REQUIRED_NO,Ja_Cn_Utility.GV_MODULE_APAR) ||
107: ' xsi:schemaLocation="http://sxbw.audit.gov.cn/AccountingSoftwareDataInterfaceStandard/2010/SOE/XMLSchema ' ||
108: Ja_Cn_Utility.Get_XML_Tag('RECEIVABLE_PAYABLE',Ja_Cn_Utility.GV_REQUIRED_NO,Ja_Cn_Utility.GV_MODULE_APAR) ||
109: '.xsd" xmlns:' ||
110: Ja_Cn_Utility.Get_XML_Tag('SOE') || '="http://sxbw.audit.gov.cn/AccountingSoftwareDataInterfaceStandard/2010/SOE/XMLSchema"'||

Line 108: Ja_Cn_Utility.Get_XML_Tag('RECEIVABLE_PAYABLE',Ja_Cn_Utility.GV_REQUIRED_NO,Ja_Cn_Utility.GV_MODULE_APAR) ||

104: --Step1: Generate XML header part
105: FND_FILE.put_line(FND_FILE.output,'');
106: lv_gl_element := '<' || Ja_Cn_Utility.Get_XML_Tag('RECEIVABLE_PAYABLE',Ja_Cn_Utility.GV_REQUIRED_NO,Ja_Cn_Utility.GV_MODULE_APAR) ||
107: ' xsi:schemaLocation="http://sxbw.audit.gov.cn/AccountingSoftwareDataInterfaceStandard/2010/SOE/XMLSchema ' ||
108: Ja_Cn_Utility.Get_XML_Tag('RECEIVABLE_PAYABLE',Ja_Cn_Utility.GV_REQUIRED_NO,Ja_Cn_Utility.GV_MODULE_APAR) ||
109: '.xsd" xmlns:' ||
110: Ja_Cn_Utility.Get_XML_Tag('SOE') || '="http://sxbw.audit.gov.cn/AccountingSoftwareDataInterfaceStandard/2010/SOE/XMLSchema"'||
111: ' xmlns="http://sxbw.audit.gov.cn/AccountingSoftwareDataInterfaceStandard/2010/SOE/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">';
112:

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

106: lv_gl_element := '<' || Ja_Cn_Utility.Get_XML_Tag('RECEIVABLE_PAYABLE',Ja_Cn_Utility.GV_REQUIRED_NO,Ja_Cn_Utility.GV_MODULE_APAR) ||
107: ' xsi:schemaLocation="http://sxbw.audit.gov.cn/AccountingSoftwareDataInterfaceStandard/2010/SOE/XMLSchema ' ||
108: Ja_Cn_Utility.Get_XML_Tag('RECEIVABLE_PAYABLE',Ja_Cn_Utility.GV_REQUIRED_NO,Ja_Cn_Utility.GV_MODULE_APAR) ||
109: '.xsd" xmlns:' ||
110: Ja_Cn_Utility.Get_XML_Tag('SOE') || '="http://sxbw.audit.gov.cn/AccountingSoftwareDataInterfaceStandard/2010/SOE/XMLSchema"'||
111: ' xmlns="http://sxbw.audit.gov.cn/AccountingSoftwareDataInterfaceStandard/2010/SOE/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">';
112:
113: FND_FILE.put_line(FND_FILE.output, lv_gl_element);
114:

Line 116: Ja_Cn_Utility.Print_Concurrent_Steps_For_Log('1.1'

112:
113: FND_FILE.put_line(FND_FILE.output, lv_gl_element);
114:
115: --Step2: Export Document Type
116: Ja_Cn_Utility.Print_Concurrent_Steps_For_Log('1.1'
117: ,'DOCUMENT_TYPE'
118: ,Ja_Cn_Utility.GV_MODULE_APAR);
119: JA_CN_APAR_COMMON_PKG.Add_Document_Type;
120:

Line 118: ,Ja_Cn_Utility.GV_MODULE_APAR);

114:
115: --Step2: Export Document Type
116: Ja_Cn_Utility.Print_Concurrent_Steps_For_Log('1.1'
117: ,'DOCUMENT_TYPE'
118: ,Ja_Cn_Utility.GV_MODULE_APAR);
119: JA_CN_APAR_COMMON_PKG.Add_Document_Type;
120:
121: --Step3: Export Transaction Type
122: Ja_Cn_Utility.Print_Concurrent_Steps_For_Log('1.2'

Line 122: Ja_Cn_Utility.Print_Concurrent_Steps_For_Log('1.2'

118: ,Ja_Cn_Utility.GV_MODULE_APAR);
119: JA_CN_APAR_COMMON_PKG.Add_Document_Type;
120:
121: --Step3: Export Transaction Type
122: Ja_Cn_Utility.Print_Concurrent_Steps_For_Log('1.2'
123: ,'TRANSACTION_TYPE'
124: ,Ja_Cn_Utility.GV_MODULE_APAR);
125: JA_CN_APAR_COMMON_PKG.Add_Transaction_Type(pn_legal_entity_id => pn_legal_entity_id
126: ,pn_ledger_id => pn_ledger_id

Line 124: ,Ja_Cn_Utility.GV_MODULE_APAR);

120:
121: --Step3: Export Transaction Type
122: Ja_Cn_Utility.Print_Concurrent_Steps_For_Log('1.2'
123: ,'TRANSACTION_TYPE'
124: ,Ja_Cn_Utility.GV_MODULE_APAR);
125: JA_CN_APAR_COMMON_PKG.Add_Transaction_Type(pn_legal_entity_id => pn_legal_entity_id
126: ,pn_ledger_id => pn_ledger_id
127: ,pv_accounting_year => pv_accounting_year
128: );

Line 130: Ja_Cn_Utility.Print_Concurrent_Steps_For_Log('1.3'

126: ,pn_ledger_id => pn_ledger_id
127: ,pv_accounting_year => pv_accounting_year
128: );
129: --Step4: Receivable balance detail export
130: Ja_Cn_Utility.Print_Concurrent_Steps_For_Log('1.3'
131: ,'RECEIVABLE_DETAIL_REPORT'
132: ,Ja_Cn_Utility.GV_MODULE_APAR);
133: JA_CN_AR_RBD_EXPORT_PKG.Add_Receivables_Balance_Detail(pn_legal_entity_id => pn_legal_entity_id
134: ,pn_ledger_id => pn_ledger_id

Line 132: ,Ja_Cn_Utility.GV_MODULE_APAR);

128: );
129: --Step4: Receivable balance detail export
130: Ja_Cn_Utility.Print_Concurrent_Steps_For_Log('1.3'
131: ,'RECEIVABLE_DETAIL_REPORT'
132: ,Ja_Cn_Utility.GV_MODULE_APAR);
133: JA_CN_AR_RBD_EXPORT_PKG.Add_Receivables_Balance_Detail(pn_legal_entity_id => pn_legal_entity_id
134: ,pn_ledger_id => pn_ledger_id
135: ,pn_coa_id => pn_coa_id
136: ,pv_accounting_year => pv_accounting_year

Line 141: Ja_Cn_Utility.Print_Concurrent_Steps_For_Log('1.4'

137: ,pv_period_from => pv_period_from
138: ,pv_period_to => pv_period_to
139: );
140: --Step5: Payable balance detail export
141: Ja_Cn_Utility.Print_Concurrent_Steps_For_Log('1.4'
142: ,'PAYABLE_DETAIL_REPORT'
143: ,Ja_Cn_Utility.GV_MODULE_APAR);
144: JA_CN_AP_PBD_EXPORT_PKG.Add_Payables_Balance_Detail(pn_legal_entity_id => pn_legal_entity_id
145: ,pn_ledger_id => pn_ledger_id

Line 143: ,Ja_Cn_Utility.GV_MODULE_APAR);

139: );
140: --Step5: Payable balance detail export
141: Ja_Cn_Utility.Print_Concurrent_Steps_For_Log('1.4'
142: ,'PAYABLE_DETAIL_REPORT'
143: ,Ja_Cn_Utility.GV_MODULE_APAR);
144: JA_CN_AP_PBD_EXPORT_PKG.Add_Payables_Balance_Detail(pn_legal_entity_id => pn_legal_entity_id
145: ,pn_ledger_id => pn_ledger_id
146: ,pn_coa_id => pn_coa_id
147: ,pv_accounting_year => pv_accounting_year

Line 153: ,Ja_Cn_Utility.Get_XML_Tag('RECEIVABLE_PAYABLE'

149: ,pv_period_to => pv_period_to
150: );
151:
152: FND_FILE.put_line(FND_FILE.output
153: ,Ja_Cn_Utility.Get_XML_Tag('RECEIVABLE_PAYABLE'
154: ,Ja_Cn_Utility.GV_TAG_TYPE_END
155: ,Ja_Cn_Utility.GV_MODULE_APAR
156: )
157: );

Line 154: ,Ja_Cn_Utility.GV_TAG_TYPE_END

150: );
151:
152: FND_FILE.put_line(FND_FILE.output
153: ,Ja_Cn_Utility.Get_XML_Tag('RECEIVABLE_PAYABLE'
154: ,Ja_Cn_Utility.GV_TAG_TYPE_END
155: ,Ja_Cn_Utility.GV_MODULE_APAR
156: )
157: );
158:

Line 155: ,Ja_Cn_Utility.GV_MODULE_APAR

151:
152: FND_FILE.put_line(FND_FILE.output
153: ,Ja_Cn_Utility.Get_XML_Tag('RECEIVABLE_PAYABLE'
154: ,Ja_Cn_Utility.GV_TAG_TYPE_END
155: ,Ja_Cn_Utility.GV_MODULE_APAR
156: )
157: );
158:
159: --logging for debug

Line 302: IF NOT(JA_CN_UTILITY.Check_Profile)

298: 'pv_template_territory=' || pv_template_territory || ',' ||
299: 'pv_output_format=' || pv_output_format);
300:
301: --Step1: Check profile
302: IF NOT(JA_CN_UTILITY.Check_Profile)
303: THEN
304: pv_retcode := 1;
305: pv_errbuf := '';
306: RETURN;

Line 397: JA_CN_UTILITY.Submit_XML_Charset_Conversion(p_xml_request_id => ln_reqid_pre

393: THEN
394: --Submit characrter set conversion program
395: --to convert charaterset of output file
396: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Step 2: Submit Character Set Conversion program');
397: JA_CN_UTILITY.Submit_XML_Charset_Conversion(p_xml_request_id => ln_reqid_pre
398: ,p_source_charset => JA_CN_UTILITY.Get_XML_Encoding
399: ,p_destination_charset => pv_dest_char_set
400: ,p_source_separator => NULL
401: ,x_charset_request_id => ln_reqid_cvt

Line 398: ,p_source_charset => JA_CN_UTILITY.Get_XML_Encoding

394: --Submit characrter set conversion program
395: --to convert charaterset of output file
396: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Step 2: Submit Character Set Conversion program');
397: JA_CN_UTILITY.Submit_XML_Charset_Conversion(p_xml_request_id => ln_reqid_pre
398: ,p_source_charset => JA_CN_UTILITY.Get_XML_Encoding
399: ,p_destination_charset => pv_dest_char_set
400: ,p_source_separator => NULL
401: ,x_charset_request_id => ln_reqid_cvt
402: ,x_result_flag => lv_cvt_req_status

Line 409: lv_output_file_name := Ja_Cn_Utility.Generate_File_name(pv_module_name => 'APAR'

405: THEN
406: --Submit "Change File Name" concurrent program
407: --to change name of output file
408: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Step 3: Submit File Name Renaming program');
409: lv_output_file_name := Ja_Cn_Utility.Generate_File_name(pv_module_name => 'APAR'
410: ,pv_accounting_year => pv_accounting_year
411: ,pv_ledger_id => pn_ledger_id
412: ,pv_from_period => lv_period_from
413: ,pv_to_period => lv_period_to

Line 415: JA_CN_UTILITY.Change_Output_Filename(p_xml_request_id => ln_reqid_pre

411: ,pv_ledger_id => pn_ledger_id
412: ,pv_from_period => lv_period_from
413: ,pv_to_period => lv_period_to
414: );
415: JA_CN_UTILITY.Change_Output_Filename(p_xml_request_id => ln_reqid_pre
416: ,p_destination_charset => pv_dest_char_set
417: ,p_destination_filename => lv_output_file_name
418: ,x_filename_request_id => ln_reqid_chg
419: ,x_result_flag => lv_chg_req_status