95: -- Let's assume everything is OK --
96: ------------------------------------------------------------
97: --arp_standard.debug('JL_ZZ_INVOICE_CREATE.validate_gdff()+');
98: IF PG_DEBUG = 'Y' THEN
99: arp_util_tax.debug('JL_ZZ_INVOICE_CREATE.validate_gdff()+');
100: END IF;
101:
102: return_code := 1;
103: --bug 5562805
108:
109: --arp_standard.debug('-- Country Code: '||l_country_code);
110: --arp_standard.debug('-- Request Id: '||to_char(p_request_id));
111: IF PG_DEBUG = 'Y' THEN
112: arp_util_tax.debug('validate_gdff: ' || '-- Country Code: '||l_country_code);
113: arp_util_tax.debug('validate_gdff: ' || '-- Request Id: '||to_char(p_request_id));
114: END IF;
115:
116: ------------------------------------------------------------
109: --arp_standard.debug('-- Country Code: '||l_country_code);
110: --arp_standard.debug('-- Request Id: '||to_char(p_request_id));
111: IF PG_DEBUG = 'Y' THEN
112: arp_util_tax.debug('validate_gdff: ' || '-- Country Code: '||l_country_code);
113: arp_util_tax.debug('validate_gdff: ' || '-- Request Id: '||to_char(p_request_id));
114: END IF;
115:
116: ------------------------------------------------------------
117: -- Validate all the rows for this concurrent request --
174: l_tax_method := JL_ZZ_AR_TX_LIB_PKG.get_tax_method(l_org_id);
175:
176: --arp_standard.debug('-- Tax Method: '||l_tax_method);
177: IF PG_DEBUG = 'Y' THEN
178: arp_util_tax.debug('validate_gdff: ' || '-- Tax Method: '||l_tax_method);
179: END IF;
180:
181: IF l_tax_method = 'LTE' THEN
182: IF NOT JL_ZZ_AUTO_INVOICE.validate_tax_attributes (t_interface_line_tbl.interface_line_id(l_index)
192: , t_interface_line_tbl.warehouse_id(l_index)) THEN
193:
194: --arp_standard.debug('-- validate_tax_attributes routine failed');
195: IF PG_DEBUG = 'Y' THEN
196: arp_util_tax.debug('validate_gdff: ' || '-- validate_tax_attributes routine failed');
197: END IF;
198: return_code := 0;
199: END IF; -- Validate tax
200: END IF; -- l_tax_method check
213: , t_interface_line_tbl.header_gdf_attribute7(l_index)) THEN
214:
215: --arp_standard.debug('-- validate_interest_attributes routine failed');
216: IF PG_DEBUG = 'Y' THEN
217: arp_util_tax.debug('validate_gdff: ' || '-- validate_interest_attributes routine failed');
218: END IF;
219:
220: return_code := 0;
221: END IF; -- Validate interest
238: , t_interface_line_tbl.line_gdf_attribute7(l_index)) THEN
239:
240: --arp_standard.debug('-- validate_billing_attributes routine failed');
241: IF PG_DEBUG = 'Y' THEN
242: arp_util_tax.debug('validate_gdff: ' || '-- validate_billing_attributes routine failed');
243: END IF;
244:
245: return_code := 0;
246: END IF; -- Validate billing
261: ) THEN
262:
263: --arp_standard.debug('-- JL_AR_DOC_NUMBERING_PKG.'||'validate_interface_lines routine failed');
264: IF PG_DEBUG = 'Y' THEN
265: arp_util_tax.debug('validate_gdff: ' || '-- JL_AR_DOC_NUMBERING_PKG.'||'validate_interface_lines routine failed');
266: END IF;
267:
268: return_code := 0;
269: END IF; -- Validate interface lines
273:
274: --arp_standard.debug('-- Return Code: '||to_char(return_code));
275: --arp_standard.debug('JL_ZZ_INVOICE_CREATE.validate_gdff()-');
276: IF PG_DEBUG = 'Y' THEN
277: arp_util_tax.debug('validate_gdff: ' || '-- Return Code: '||to_char(return_code));
278: arp_util_tax.debug('JL_ZZ_INVOICE_CREATE.validate_gdff()-');
279: END IF;
280:
281: RETURN return_code;
274: --arp_standard.debug('-- Return Code: '||to_char(return_code));
275: --arp_standard.debug('JL_ZZ_INVOICE_CREATE.validate_gdff()-');
276: IF PG_DEBUG = 'Y' THEN
277: arp_util_tax.debug('validate_gdff: ' || '-- Return Code: '||to_char(return_code));
278: arp_util_tax.debug('JL_ZZ_INVOICE_CREATE.validate_gdff()-');
279: END IF;
280:
281: RETURN return_code;
282:
286: --arp_standard.debug('-- Return From Exception when others');
287: --arp_standard.debug('-- Return Code: 0');
288: --arp_standard.debug('JL_ZZ_INVOICE_CREATE.validate_gdff()-');
289: IF PG_DEBUG = 'Y' THEN
290: arp_util_tax.debug('validate_gdff: ' || '-- Return From Exception when others');
291: arp_util_tax.debug('validate_gdff: ' || '-- Return Code: 0');
292: arp_util_tax.debug('JL_ZZ_INVOICE_CREATE.validate_gdff()-');
293: END IF;
294:
287: --arp_standard.debug('-- Return Code: 0');
288: --arp_standard.debug('JL_ZZ_INVOICE_CREATE.validate_gdff()-');
289: IF PG_DEBUG = 'Y' THEN
290: arp_util_tax.debug('validate_gdff: ' || '-- Return From Exception when others');
291: arp_util_tax.debug('validate_gdff: ' || '-- Return Code: 0');
292: arp_util_tax.debug('JL_ZZ_INVOICE_CREATE.validate_gdff()-');
293: END IF;
294:
295: RETURN 0;
288: --arp_standard.debug('JL_ZZ_INVOICE_CREATE.validate_gdff()-');
289: IF PG_DEBUG = 'Y' THEN
290: arp_util_tax.debug('validate_gdff: ' || '-- Return From Exception when others');
291: arp_util_tax.debug('validate_gdff: ' || '-- Return Code: 0');
292: arp_util_tax.debug('JL_ZZ_INVOICE_CREATE.validate_gdff()-');
293: END IF;
294:
295: RETURN 0;
296: