[Home] [Help]
40:
41: PG_DEBUG := NVL(FND_PROFILE.value('MSC_ATP_DEBUG'), 'N');
42:
43: IF PG_DEBUG in ('Y', 'C') THEN
44: arp_standard.debug('JE JE_ZZ_AUTO_INVOICE.validate_gdff()+');
45: END IF;
46:
47: l_org_id := arp_global.sysparam.org_id;
48:
49: return_code := 1;
50: l_country_code := JG_ZZ_SHARED_PKG.GET_COUNTRY(l_org_id);
51:
52: IF PG_DEBUG in ('Y', 'C') THEN
53: arp_standard.debug('validate_gdff: ' || '-- Country Code: '||l_country_code);
54: arp_standard.debug('validate_gdff: ' || '-- Request Id: '||to_char(p_request_id));
55: END IF;
56:
57: --bug#11891772
50: l_country_code := JG_ZZ_SHARED_PKG.GET_COUNTRY(l_org_id);
51:
52: IF PG_DEBUG in ('Y', 'C') THEN
53: arp_standard.debug('validate_gdff: ' || '-- Country Code: '||l_country_code);
54: arp_standard.debug('validate_gdff: ' || '-- Request Id: '||to_char(p_request_id));
55: END IF;
56:
57: --bug#11891772
58: IF l_country_code IN ('HU','PL','CZ','SK') THEN
56:
57: --bug#11891772
58: IF l_country_code IN ('HU','PL','CZ','SK') THEN
59:
60: arp_standard.debug('JG Updating Tax Invoice Date ');
61:
62: BEGIN
63:
64: UPDATE zx_lines_det_factors zxld
85:
86: EXCEPTION
87: WHEN OTHERS THEN
88:
89: arp_standard.debug('JG Error while updating the Tax Invoice Date');
90: arp_standard.debug('JG SQL Error : '||SQLERRM);
91:
92: END;
93:
86: EXCEPTION
87: WHEN OTHERS THEN
88:
89: arp_standard.debug('JG Error while updating the Tax Invoice Date');
90: arp_standard.debug('JG SQL Error : '||SQLERRM);
91:
92: END;
93:
94: END IF;
100: IF l_country_code = 'HU' THEN
101:
102:
103: IF PG_DEBUG in ('Y', 'C') THEN
104: arp_standard.debug('validate_gdff: ' || '-- Inserting HU specific GDF data');
105: END IF;
106:
107: update ra_interface_lines_gt
108: set HEADER_GDF_ATTR_CATEGORY = 'JE.HU.ARXTWMAI.TAX_DATE'
118: ELSIF l_country_code = 'PL' THEN
119:
120:
121: IF PG_DEBUG in ('Y', 'C') THEN
122: arp_standard.debug('validate_gdff: ' || '-- Inserting PL specific GDF data');
123: END IF;
124:
125: update ra_interface_lines_gt
126: set HEADER_GDF_ATTR_CATEGORY = 'JE.PL.ARXTWMAI.TAX_DATE'
142:
143: ELSIF l_country_code = 'CZ' THEN
144:
145: IF PG_DEBUG in ('Y', 'C') THEN
146: arp_standard.debug('validate_gdff: ' || '-- Inserting CZ specific GDF data');
147: END IF;
148:
149: update ra_interface_lines_gt
150: set HEADER_GDF_ATTR_CATEGORY = 'JE.CZ.ARXTWMAI.TAX_DATE'
161: EXCEPTION
162: WHEN OTHERS THEN
163:
164: IF PG_DEBUG in ('Y', 'C') THEN
165: arp_standard.debug('validate_gdff: ' || '-- Return From Exception when others');
166: arp_standard.debug('validate_gdff: ' || '-- Return Code: 0');
167: arp_standard.debug('JE_ZZ_AUTO_INVOICE.validate_gdff()-');
168: END IF;
169:
162: WHEN OTHERS THEN
163:
164: IF PG_DEBUG in ('Y', 'C') THEN
165: arp_standard.debug('validate_gdff: ' || '-- Return From Exception when others');
166: arp_standard.debug('validate_gdff: ' || '-- Return Code: 0');
167: arp_standard.debug('JE_ZZ_AUTO_INVOICE.validate_gdff()-');
168: END IF;
169:
170: RETURN 0;
163:
164: IF PG_DEBUG in ('Y', 'C') THEN
165: arp_standard.debug('validate_gdff: ' || '-- Return From Exception when others');
166: arp_standard.debug('validate_gdff: ' || '-- Return Code: 0');
167: arp_standard.debug('JE_ZZ_AUTO_INVOICE.validate_gdff()-');
168: END IF;
169:
170: RETURN 0;
171: