[Home] [Help]
546: iby_debug_pub.add(debug_msg => 'Before XML query ',
547: debug_level => G_LEVEL_STATEMENT,
548: module => l_Debug_Module);
549: END IF;
550: CEP_STANDARD.init_security;
551: OPEN l_ece_csr(p_payment_instruction_id);
552: FETCH l_ece_csr INTO l_ele_channel;
553: CLOSE l_ece_csr;
554: IF l_ele_channel = 'ECE' AND G_Extract_Run_Mode = G_EXTRACT_MODE_PMT THEN
676: iby_debug_pub.add(debug_msg => 'Before XML query ',
677: debug_level => G_LEVEL_STATEMENT,
678: module => l_Debug_Module);
679: END IF;
680: CEP_STANDARD.init_security;
681:
682: SELECT XMLType.getClobVal(payment_process_request)
683: INTO x_extract_doc
684: FROM iby_xml_fd_ppr_1_0_v
750: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
751: iby_debug_pub.add(debug_msg => 'Before XML query ',debug_level => G_LEVEL_STATEMENT,module => l_Debug_Module);
752: END IF;
753:
754: CEP_STANDARD.init_security;
755:
756: IF p_payment_instruction_id <> -99 THEN
757: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
758: iby_debug_pub.add(debug_msg => 'payment instruction id is supplied ',debug_level => G_LEVEL_STATEMENT,module => l_Debug_Module);
1101:
1102:
1103:
1104: Validate_and_Set_Syskey(p_sys_key);
1105: CEP_STANDARD.init_security;
1106:
1107:
1108: --parameter editing
1109: l_from_date := p_from_date;
1712: SELECT pvs.vendor_site_code,
1713: pv.num_1099,
1714: pv.global_attribute2,
1715: pv.global_attribute3,
1716: pv.standard_industry_class,
1717: pvs.address_line1,
1718: pvs.address_line2,
1719: pvs.address_line3,
1720: pvs.city,
1734: SELECT decode(pvs.country,'ES',pv.vendor_name,'GR',pvs.vendor_site_code),
1735: pv.num_1099,
1736: pv.global_attribute2,
1737: pv.global_attribute3,
1738: pv.standard_industry_class,
1739: pvs.address_line1,
1740: pvs.address_line2,
1741: pvs.address_line3,
1742: pvs.city,
1757:
1758: x_msg_count := NULL;
1759: x_msg_data := NULL;
1760:
1761: -- Standard Start of API savepoint
1762: SAVEPOINT Get_LegalInformation;
1763:
1764: -- Standard call to check for call compatibility.
1765: IF NOT FND_API.Compatible_API_Call ( l_api_version,
1760:
1761: -- Standard Start of API savepoint
1762: SAVEPOINT Get_LegalInformation;
1763:
1764: -- Standard call to check for call compatibility.
1765: IF NOT FND_API.Compatible_API_Call ( l_api_version,
1766: p_api_version,
1767: l_api_name,
1768: G_PKG_NAME ) THEN
2865: WHERE
2866: xml_pmt_lvl.payment_instruction_id = p_payment_instruction_id
2867: AND ins.payment_instruction_id = xml_pmt_lvl.payment_instruction_id
2868: AND ((xml_pmt_lvl.payment_status in ('INSTRUCTION_CREATED',
2869: 'VOID_BY_SETUP', 'VOID_BY_OVERFLOW') AND ins.process_type = 'STANDARD') OR
2870: ins.process_type = 'IMMEDIATE');
2871:
2872: -- for payment format: reprint individual and ranges
2873: CURSOR l_payerinstr_reprt_csr (p_payment_instruction_id IN NUMBER) IS
2878: WHERE
2879: xml_pmt_lvl.payment_instruction_id = p_payment_instruction_id
2880: AND ins.payment_instruction_id = xml_pmt_lvl.payment_instruction_id
2881: AND ((xml_pmt_lvl.payment_status in ('READY_TO_REPRINT',
2882: 'VOID_BY_SETUP_REPRINT', 'VOID_BY_OVERFLOW_REPRINT') AND ins.process_type = 'STANDARD') OR
2883: ins.process_type = 'IMMEDIATE');
2884:
2885: -- for payment instruction register
2886: -- we are extract payments in all statuses
4278: WHERE payment_id = p_payment_id;
4279:
4280: --Changing for bug 9686312.
4281: --Adding fnd_languages table to fetch language country in
4282: --ISO standard.
4283: CURSOR l_lang_territory_csr (p_payment_id IN NUMBER) IS
4284: SELECT fl.language_code , loc.country
4285: FROM hz_party_sites ps, hz_locations loc, iby_payments_all pmt
4286: , fnd_languages fl