DBA Data[Home] [Help]

APPS.JA_CN_SI_BANK_EXPORT_PKG dependencies on JA_CN_UTILITY

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

79: -- export the header
80: -- here need to change
81: FND_FILE.put_line(FND_FILE.output,
82: ' 83: JA_CN_UTILITY.Get_XML_Encoding || '"?>');
84: /*lv_gl_element := '<' || Ja_Cn_Utility.Get_XML_Tag('SHARED_INFORMATION') ||
85: ' xsi:schemaLocation="http://sxbw.audit.gov.cn/AccountingSoftwareDataInterfaceStandard/2010/SOE/XMLSchema ' ||
86: Ja_Cn_Utility.Get_XML_Tag('SHARED_INFORMATION') ||
87: '.xsd" xmlns:' || Ja_Cn_Utility.Get_XML_Tag('BANK') ||

Line 84: /*lv_gl_element := '<' || Ja_Cn_Utility.Get_XML_Tag('SHARED_INFORMATION') ||

80: -- here need to change
81: FND_FILE.put_line(FND_FILE.output,
82: ' 83: JA_CN_UTILITY.Get_XML_Encoding || '"?>');
84: /*lv_gl_element := '<' || Ja_Cn_Utility.Get_XML_Tag('SHARED_INFORMATION') ||
85: ' xsi:schemaLocation="http://sxbw.audit.gov.cn/AccountingSoftwareDataInterfaceStandard/2010/SOE/XMLSchema ' ||
86: Ja_Cn_Utility.Get_XML_Tag('SHARED_INFORMATION') ||
87: '.xsd" xmlns:' || Ja_Cn_Utility.Get_XML_Tag('BANK') ||
88: '="http://sxbw.audit.gov.cn/AccountingSoftwareDataInterfaceStandard/2010/SOE/XMLSchema"

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

82: ' 83: JA_CN_UTILITY.Get_XML_Encoding || '"?>');
84: /*lv_gl_element := '<' || Ja_Cn_Utility.Get_XML_Tag('SHARED_INFORMATION') ||
85: ' xsi:schemaLocation="http://sxbw.audit.gov.cn/AccountingSoftwareDataInterfaceStandard/2010/SOE/XMLSchema ' ||
86: Ja_Cn_Utility.Get_XML_Tag('SHARED_INFORMATION') ||
87: '.xsd" xmlns:' || Ja_Cn_Utility.Get_XML_Tag('BANK') ||
88: '="http://sxbw.audit.gov.cn/AccountingSoftwareDataInterfaceStandard/2010/SOE/XMLSchema"
89: xmlns="http://sxbw.audit.gov.cn/AccountingSoftwareDataInterfaceStandard/2010/SOE/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">';
90: */

Line 87: '.xsd" xmlns:' || Ja_Cn_Utility.Get_XML_Tag('BANK') ||

83: JA_CN_UTILITY.Get_XML_Encoding || '"?>');
84: /*lv_gl_element := '<' || Ja_Cn_Utility.Get_XML_Tag('SHARED_INFORMATION') ||
85: ' xsi:schemaLocation="http://sxbw.audit.gov.cn/AccountingSoftwareDataInterfaceStandard/2010/SOE/XMLSchema ' ||
86: Ja_Cn_Utility.Get_XML_Tag('SHARED_INFORMATION') ||
87: '.xsd" xmlns:' || Ja_Cn_Utility.Get_XML_Tag('BANK') ||
88: '="http://sxbw.audit.gov.cn/AccountingSoftwareDataInterfaceStandard/2010/SOE/XMLSchema"
89: xmlns="http://sxbw.audit.gov.cn/AccountingSoftwareDataInterfaceStandard/2010/SOE/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">';
90: */
91: --added by jar.wang for bug 16655327

Line 92: /* lv_gl_element := '<' || Ja_Cn_Utility.Get_XML_Tag('SHARED_INFORMATION') ||

88: '="http://sxbw.audit.gov.cn/AccountingSoftwareDataInterfaceStandard/2010/SOE/XMLSchema"
89: xmlns="http://sxbw.audit.gov.cn/AccountingSoftwareDataInterfaceStandard/2010/SOE/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">';
90: */
91: --added by jar.wang for bug 16655327
92: /* lv_gl_element := '<' || Ja_Cn_Utility.Get_XML_Tag('SHARED_INFORMATION') ||
93: ' xmlns="http://sxbw.audit.gov.cn/AccountingSoftwareDataInterfaceStandard/2010/Bank/XMLSchema"' ||
94: ' xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"'||
95: ' xmlns:'||Ja_Cn_Utility.Get_XML_Tag('BANK')||'="http://sxbw.audit.gov.cn/AccountingSoftwareDataInterfaceStandard/2010/Bank/XMLSchema"'||
96: ' xsi:schemaLocation="http://sxbw.audit.gov.cn/AccountingSoftwareDataInterfaceStandard/2010/Bank/XMLSchema '||

Line 95: ' xmlns:'||Ja_Cn_Utility.Get_XML_Tag('BANK')||'="http://sxbw.audit.gov.cn/AccountingSoftwareDataInterfaceStandard/2010/Bank/XMLSchema"'||

91: --added by jar.wang for bug 16655327
92: /* lv_gl_element := '<' || Ja_Cn_Utility.Get_XML_Tag('SHARED_INFORMATION') ||
93: ' xmlns="http://sxbw.audit.gov.cn/AccountingSoftwareDataInterfaceStandard/2010/Bank/XMLSchema"' ||
94: ' xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"'||
95: ' xmlns:'||Ja_Cn_Utility.Get_XML_Tag('BANK')||'="http://sxbw.audit.gov.cn/AccountingSoftwareDataInterfaceStandard/2010/Bank/XMLSchema"'||
96: ' xsi:schemaLocation="http://sxbw.audit.gov.cn/AccountingSoftwareDataInterfaceStandard/2010/Bank/XMLSchema '||
97: Ja_Cn_Utility.Get_XML_Tag('SHARED_INFORMATION') ||'.xsd">';*/
98: lv_gl_element := '<' || Ja_Cn_Utility.Get_XML_Tag('SHARED_INFORMATION') ||' xsi:schemaLocation="http://sxbw.audit.gov.cn/AccountingSoftwareDataInterfaceStandard/2010/Bank/XMLSchema '||
99: Ja_Cn_Utility.Get_XML_Tag('SHARED_INFORMATION') ||'.xsd"'||

Line 97: Ja_Cn_Utility.Get_XML_Tag('SHARED_INFORMATION') ||'.xsd">';*/

93: ' xmlns="http://sxbw.audit.gov.cn/AccountingSoftwareDataInterfaceStandard/2010/Bank/XMLSchema"' ||
94: ' xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"'||
95: ' xmlns:'||Ja_Cn_Utility.Get_XML_Tag('BANK')||'="http://sxbw.audit.gov.cn/AccountingSoftwareDataInterfaceStandard/2010/Bank/XMLSchema"'||
96: ' xsi:schemaLocation="http://sxbw.audit.gov.cn/AccountingSoftwareDataInterfaceStandard/2010/Bank/XMLSchema '||
97: Ja_Cn_Utility.Get_XML_Tag('SHARED_INFORMATION') ||'.xsd">';*/
98: lv_gl_element := '<' || Ja_Cn_Utility.Get_XML_Tag('SHARED_INFORMATION') ||' xsi:schemaLocation="http://sxbw.audit.gov.cn/AccountingSoftwareDataInterfaceStandard/2010/Bank/XMLSchema '||
99: Ja_Cn_Utility.Get_XML_Tag('SHARED_INFORMATION') ||'.xsd"'||
100: ' xmlns:'||Ja_Cn_Utility.Get_XML_Tag('BANK')||'="http://sxbw.audit.gov.cn/AccountingSoftwareDataInterfaceStandard/2010/Bank/XMLSchema"'||
101: ' xmlns="http://sxbw.audit.gov.cn/AccountingSoftwareDataInterfaceStandard/2010/Bank/XMLSchema"' ||

Line 98: lv_gl_element := '<' || Ja_Cn_Utility.Get_XML_Tag('SHARED_INFORMATION') ||' xsi:schemaLocation="http://sxbw.audit.gov.cn/AccountingSoftwareDataInterfaceStandard/2010/Bank/XMLSchema '||

94: ' xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"'||
95: ' xmlns:'||Ja_Cn_Utility.Get_XML_Tag('BANK')||'="http://sxbw.audit.gov.cn/AccountingSoftwareDataInterfaceStandard/2010/Bank/XMLSchema"'||
96: ' xsi:schemaLocation="http://sxbw.audit.gov.cn/AccountingSoftwareDataInterfaceStandard/2010/Bank/XMLSchema '||
97: Ja_Cn_Utility.Get_XML_Tag('SHARED_INFORMATION') ||'.xsd">';*/
98: lv_gl_element := '<' || Ja_Cn_Utility.Get_XML_Tag('SHARED_INFORMATION') ||' xsi:schemaLocation="http://sxbw.audit.gov.cn/AccountingSoftwareDataInterfaceStandard/2010/Bank/XMLSchema '||
99: Ja_Cn_Utility.Get_XML_Tag('SHARED_INFORMATION') ||'.xsd"'||
100: ' xmlns:'||Ja_Cn_Utility.Get_XML_Tag('BANK')||'="http://sxbw.audit.gov.cn/AccountingSoftwareDataInterfaceStandard/2010/Bank/XMLSchema"'||
101: ' xmlns="http://sxbw.audit.gov.cn/AccountingSoftwareDataInterfaceStandard/2010/Bank/XMLSchema"' ||
102: ' xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">';

Line 99: Ja_Cn_Utility.Get_XML_Tag('SHARED_INFORMATION') ||'.xsd"'||

95: ' xmlns:'||Ja_Cn_Utility.Get_XML_Tag('BANK')||'="http://sxbw.audit.gov.cn/AccountingSoftwareDataInterfaceStandard/2010/Bank/XMLSchema"'||
96: ' xsi:schemaLocation="http://sxbw.audit.gov.cn/AccountingSoftwareDataInterfaceStandard/2010/Bank/XMLSchema '||
97: Ja_Cn_Utility.Get_XML_Tag('SHARED_INFORMATION') ||'.xsd">';*/
98: lv_gl_element := '<' || Ja_Cn_Utility.Get_XML_Tag('SHARED_INFORMATION') ||' xsi:schemaLocation="http://sxbw.audit.gov.cn/AccountingSoftwareDataInterfaceStandard/2010/Bank/XMLSchema '||
99: Ja_Cn_Utility.Get_XML_Tag('SHARED_INFORMATION') ||'.xsd"'||
100: ' xmlns:'||Ja_Cn_Utility.Get_XML_Tag('BANK')||'="http://sxbw.audit.gov.cn/AccountingSoftwareDataInterfaceStandard/2010/Bank/XMLSchema"'||
101: ' xmlns="http://sxbw.audit.gov.cn/AccountingSoftwareDataInterfaceStandard/2010/Bank/XMLSchema"' ||
102: ' xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">';
103: FND_FILE.put_line(FND_FILE.output, lv_gl_element);

Line 100: ' xmlns:'||Ja_Cn_Utility.Get_XML_Tag('BANK')||'="http://sxbw.audit.gov.cn/AccountingSoftwareDataInterfaceStandard/2010/Bank/XMLSchema"'||

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

Line 106: Ja_Cn_Utility.Add_Sub_Root_Node('BASIC_INFO', Ja_Cn_Utility.GV_TAG_TYPE_START);

102: ' xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">';
103: FND_FILE.put_line(FND_FILE.output, lv_gl_element);
104:
105: --begin basic info
106: Ja_Cn_Utility.Add_Sub_Root_Node('BASIC_INFO', Ja_Cn_Utility.GV_TAG_TYPE_START);
107:
108: --Add banking base info
109: Ja_Cn_Utility.Add_Sub_Root_Node('ACC_UNIT_INFO_FILE', Ja_Cn_Utility.GV_TAG_TYPE_START);
110: JA_CN_SI_BANK_DET_PKG.Add_Parent_BSV(pn_legal_entity_id => pn_legal_entity_id,

Line 109: Ja_Cn_Utility.Add_Sub_Root_Node('ACC_UNIT_INFO_FILE', Ja_Cn_Utility.GV_TAG_TYPE_START);

105: --begin basic info
106: Ja_Cn_Utility.Add_Sub_Root_Node('BASIC_INFO', Ja_Cn_Utility.GV_TAG_TYPE_START);
107:
108: --Add banking base info
109: Ja_Cn_Utility.Add_Sub_Root_Node('ACC_UNIT_INFO_FILE', Ja_Cn_Utility.GV_TAG_TYPE_START);
110: JA_CN_SI_BANK_DET_PKG.Add_Parent_BSV(pn_legal_entity_id => pn_legal_entity_id,
111: pn_ledger_id => pn_ledger_id,
112: pv_bsv => pv_bsv,
113: pn_accounting_year => TO_NUMBER(pv_accounting_year),

Line 116: Ja_Cn_Utility.Add_Sub_Root_Node('ACC_UNIT_INFO_FILE', Ja_Cn_Utility.GV_TAG_TYPE_END);

112: pv_bsv => pv_bsv,
113: pn_accounting_year => TO_NUMBER(pv_accounting_year),
114: pn_branch =>1);
115:
116: Ja_Cn_Utility.Add_Sub_Root_Node('ACC_UNIT_INFO_FILE', Ja_Cn_Utility.GV_TAG_TYPE_END);
117:
118:
119: --Add merchant bank info
120: Ja_Cn_Utility.Add_Sub_Root_Node('COMMERCIAL_BANK_ORG_FILE', Ja_Cn_Utility.GV_TAG_TYPE_START);

Line 120: Ja_Cn_Utility.Add_Sub_Root_Node('COMMERCIAL_BANK_ORG_FILE', Ja_Cn_Utility.GV_TAG_TYPE_START);

116: Ja_Cn_Utility.Add_Sub_Root_Node('ACC_UNIT_INFO_FILE', Ja_Cn_Utility.GV_TAG_TYPE_END);
117:
118:
119: --Add merchant bank info
120: Ja_Cn_Utility.Add_Sub_Root_Node('COMMERCIAL_BANK_ORG_FILE', Ja_Cn_Utility.GV_TAG_TYPE_START);
121: JA_CN_SI_BANK_DET_PKG.Add_Parent_BSV(pn_legal_entity_id => pn_legal_entity_id,
122: pn_ledger_id => pn_ledger_id,
123: pv_bsv => pv_bsv,
124: pn_accounting_year => TO_NUMBER(pv_accounting_year),

Line 126: Ja_Cn_Utility.Add_Sub_Root_Node('COMMERCIAL_BANK_ORG_FILE', Ja_Cn_Utility.GV_TAG_TYPE_END);

122: pn_ledger_id => pn_ledger_id,
123: pv_bsv => pv_bsv,
124: pn_accounting_year => TO_NUMBER(pv_accounting_year),
125: pn_branch =>2);
126: Ja_Cn_Utility.Add_Sub_Root_Node('COMMERCIAL_BANK_ORG_FILE', Ja_Cn_Utility.GV_TAG_TYPE_END);
127: --Add currency
128: JA_CN_SI_BANK_DET_PKG.Add_Parent_BSV(pn_legal_entity_id => pn_legal_entity_id,
129: pn_ledger_id => pn_ledger_id,
130: pv_bsv => pv_bsv,

Line 136: Ja_Cn_Utility.Add_Sub_Root_Node('BASIC_INFO', Ja_Cn_Utility.GV_TAG_TYPE_END);

132: pn_branch =>3);
133: JA_CN_SI_BANK_DET_PKG.Add_Accounting_Currency;
134:
135: --end basic info
136: Ja_Cn_Utility.Add_Sub_Root_Node('BASIC_INFO', Ja_Cn_Utility.GV_TAG_TYPE_END);
137: Ja_Cn_Utility.Add_Sub_Root_Node('FINANCE_SYSTEM', Ja_Cn_Utility.GV_TAG_TYPE_START);
138: --Add period
139: JA_CN_SI_BANK_DET_PKG.Add_Accounting_Periods(pn_legal_entity_id => pn_legal_entity_id,
140: pn_ledger_id => pn_ledger_id,

Line 137: Ja_Cn_Utility.Add_Sub_Root_Node('FINANCE_SYSTEM', Ja_Cn_Utility.GV_TAG_TYPE_START);

133: JA_CN_SI_BANK_DET_PKG.Add_Accounting_Currency;
134:
135: --end basic info
136: Ja_Cn_Utility.Add_Sub_Root_Node('BASIC_INFO', Ja_Cn_Utility.GV_TAG_TYPE_END);
137: Ja_Cn_Utility.Add_Sub_Root_Node('FINANCE_SYSTEM', Ja_Cn_Utility.GV_TAG_TYPE_START);
138: --Add period
139: JA_CN_SI_BANK_DET_PKG.Add_Accounting_Periods(pn_legal_entity_id => pn_legal_entity_id,
140: pn_ledger_id => pn_ledger_id,
141: --pv_bsv => pv_bsv,

Line 161: Ja_Cn_Utility.Add_Sub_Root_Node('FINANCE_SYSTEM', Ja_Cn_Utility.GV_TAG_TYPE_END);

157: pn_ledger_id ,
158: pv_bsv ,
159: TO_NUMBER(pv_accounting_year) ) ;
160:
161: Ja_Cn_Utility.Add_Sub_Root_Node('FINANCE_SYSTEM', Ja_Cn_Utility.GV_TAG_TYPE_END);
162:
163: FND_FILE.put_line(FND_FILE.output, Ja_Cn_Utility.Get_XML_Tag('SHARED_INFORMATION', Ja_Cn_Utility.GV_TAG_TYPE_END));
164:
165: --logging for debug

Line 163: FND_FILE.put_line(FND_FILE.output, Ja_Cn_Utility.Get_XML_Tag('SHARED_INFORMATION', Ja_Cn_Utility.GV_TAG_TYPE_END));

159: TO_NUMBER(pv_accounting_year) ) ;
160:
161: Ja_Cn_Utility.Add_Sub_Root_Node('FINANCE_SYSTEM', Ja_Cn_Utility.GV_TAG_TYPE_END);
162:
163: FND_FILE.put_line(FND_FILE.output, Ja_Cn_Utility.Get_XML_Tag('SHARED_INFORMATION', Ja_Cn_Utility.GV_TAG_TYPE_END));
164:
165: --logging for debug
166: IF (ln_proc_level >= ln_dbg_level) THEN
167: FND_LOG.STRING(ln_proc_level,

Line 346: p_source_charset => JA_CN_UTILITY.Get_XML_Encoding,

342: --to convert charaterset of output file
343: FND_FILE.PUT_LINE(FND_FILE.LOG,
344: 'Step 3: Submit Characrter Set Conversion program');
345: JA_CN_SYSOPS_BANK_PKG.Submit_XML_Charset_Conversion(p_xml_request_id => ln_reqid_gle,
346: p_source_charset => JA_CN_UTILITY.Get_XML_Encoding,
347: p_destination_charset => pv_dest_char_set,
348: p_source_separator => NULL,
349: x_charset_request_id => ln_reqid_cvt,
350: x_result_flag => lv_cvt_req_status);

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

352: --Step4: Submit "Change File Name" concurrent program
353: --to change name of output file
354: FND_FILE.PUT_LINE(FND_FILE.LOG,
355: 'Step 4: Submit File Name Renaming program');
356: lv_output_file_name := Ja_Cn_Utility.Generate_File_name(pv_module_name => 'SI',
357: pv_accounting_year => pv_accounting_year,
358: pv_ledger_id => pn_ledger_id,
359: pv_from_period => null,
360: pv_to_period => null);

Line 372: JA_CN_UTILITY.Change_Output_Filename(p_xml_request_id => ln_reqid_gle,

368: lv_procedure_name || '.variable:' ||
369: 'lv_output_file_name =' ||
370: lv_output_file_name);
371:
372: JA_CN_UTILITY.Change_Output_Filename(p_xml_request_id => ln_reqid_gle,
373: p_destination_charset => pv_dest_char_set,
374: p_destination_filename => lv_output_file_name,
375: x_filename_request_id => ln_reqid_chg,
376: x_result_flag => lv_chg_req_status);