37: ------------------------------------------------------------
38: BEGIN
39: PG_DEBUG := NVL(FND_PROFILE.value('MSC_ATP_DEBUG'), 'N');
40: IF PG_DEBUG in ('Y', 'C') THEN
41: arp_standard.debug('JE_ZZ_INVOICE_CREATE.validate_gdff()+');
42: END IF;
43:
44: return_code := 1;
45: l_country_code := fnd_profile.value ('JGZZ_COUNTRY_CODE');
44: return_code := 1;
45: l_country_code := fnd_profile.value ('JGZZ_COUNTRY_CODE');
46:
47: IF PG_DEBUG in ('Y', 'C') THEN
48: arp_standard.debug('validate_gdff: ' || '-- Country Code: '||l_country_code);
49: arp_standard.debug('validate_gdff: ' || '-- Request Id: '||to_char(p_request_id));
50: END IF;
51:
52: ------------------------------------------------------------
45: l_country_code := fnd_profile.value ('JGZZ_COUNTRY_CODE');
46:
47: IF PG_DEBUG in ('Y', 'C') THEN
48: arp_standard.debug('validate_gdff: ' || '-- Country Code: '||l_country_code);
49: arp_standard.debug('validate_gdff: ' || '-- Request Id: '||to_char(p_request_id));
50: END IF;
51:
52: ------------------------------------------------------------
53: -- Check for HU country code, if present then we want to --
57: IF l_country_code = 'HU' THEN
58:
59:
60: IF PG_DEBUG in ('Y', 'C') THEN
61: arp_standard.debug('validate_gdff: ' || '-- Inserting HU specific GDF data');
62: END IF;
63:
64: update ar_trx_header_gt
65: set GLOBAL_ATTRIBUTE_CATEGORY = 'JE.HU.ARXTWMAI.TAX_DATE'
75: ELSIF l_country_code = 'PL' THEN
76:
77:
78: IF PG_DEBUG in ('Y', 'C') THEN
79: arp_standard.debug('validate_gdff: ' || '-- Inserting PL specific GDF data');
80: END IF;
81:
82: update ar_trx_header_gt
83: set GLOBAL_ATTRIBUTE_CATEGORY = 'JE.PL.ARXTWMAI.TAX_DATE'
96:
97: ELSIF l_country_code = 'CZ' THEN
98:
99: IF PG_DEBUG in ('Y', 'C') THEN
100: arp_standard.debug('validate_gdff: ' || '-- Inserting CZ specific GDF data');
101: END IF;
102:
103: update ar_trx_header_gt
104: set GLOBAL_ATTRIBUTE_CATEGORY = 'JE.CZ.ARXTWMAI.TAX_DATE'
115: EXCEPTION
116: WHEN OTHERS THEN
117:
118: IF PG_DEBUG in ('Y', 'C') THEN
119: arp_standard.debug('validate_gdff: ' || '-- Return From Exception when others');
120: arp_standard.debug('validate_gdff: ' || '-- Return Code: 0');
121: arp_standard.debug('JE_ZZ_INVOICE_CREATE.validate_gdff()-');
122: END IF;
123:
116: WHEN OTHERS THEN
117:
118: IF PG_DEBUG in ('Y', 'C') THEN
119: arp_standard.debug('validate_gdff: ' || '-- Return From Exception when others');
120: arp_standard.debug('validate_gdff: ' || '-- Return Code: 0');
121: arp_standard.debug('JE_ZZ_INVOICE_CREATE.validate_gdff()-');
122: END IF;
123:
124: RETURN 0;
117:
118: IF PG_DEBUG in ('Y', 'C') THEN
119: arp_standard.debug('validate_gdff: ' || '-- Return From Exception when others');
120: arp_standard.debug('validate_gdff: ' || '-- Return Code: 0');
121: arp_standard.debug('JE_ZZ_INVOICE_CREATE.validate_gdff()-');
122: END IF;
123:
124: RETURN 0;
125: