168: l_vat_reg_num VARCHAR2(50);
169:
170: BEGIN
171: IF p_debug_flag = 'Y' THEN
172: fnd_file.put_line(fnd_file.log,' *** Report Parameters *** ');
173: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID : ' || P_VAT_REP_ENTITY_ID ) ;
174: fnd_file.put_line(fnd_file.log,'P_PERIOD : ' || P_PERIOD ) ;
175: fnd_file.put_line(fnd_file.log,'P_VAT_BOX : ' || P_VAT_BOX ) ;
176: fnd_file.put_line(fnd_file.log,'P_VAT_TRX_TYPE_LOW : ' || P_VAT_TRX_TYPE_LOW ) ;
169:
170: BEGIN
171: IF p_debug_flag = 'Y' THEN
172: fnd_file.put_line(fnd_file.log,' *** Report Parameters *** ');
173: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID : ' || P_VAT_REP_ENTITY_ID ) ;
174: fnd_file.put_line(fnd_file.log,'P_PERIOD : ' || P_PERIOD ) ;
175: fnd_file.put_line(fnd_file.log,'P_VAT_BOX : ' || P_VAT_BOX ) ;
176: fnd_file.put_line(fnd_file.log,'P_VAT_TRX_TYPE_LOW : ' || P_VAT_TRX_TYPE_LOW ) ;
177: fnd_file.put_line(fnd_file.log,'P_VAT_TRX_TYPE_HIGH : ' || P_VAT_TRX_TYPE_HIGH ) ;
170: BEGIN
171: IF p_debug_flag = 'Y' THEN
172: fnd_file.put_line(fnd_file.log,' *** Report Parameters *** ');
173: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID : ' || P_VAT_REP_ENTITY_ID ) ;
174: fnd_file.put_line(fnd_file.log,'P_PERIOD : ' || P_PERIOD ) ;
175: fnd_file.put_line(fnd_file.log,'P_VAT_BOX : ' || P_VAT_BOX ) ;
176: fnd_file.put_line(fnd_file.log,'P_VAT_TRX_TYPE_LOW : ' || P_VAT_TRX_TYPE_LOW ) ;
177: fnd_file.put_line(fnd_file.log,'P_VAT_TRX_TYPE_HIGH : ' || P_VAT_TRX_TYPE_HIGH ) ;
178: fnd_file.put_line(fnd_file.log,'P_VAT_TRX_TYPE : ' || P_VAT_TRX_TYPE ) ;
171: IF p_debug_flag = 'Y' THEN
172: fnd_file.put_line(fnd_file.log,' *** Report Parameters *** ');
173: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID : ' || P_VAT_REP_ENTITY_ID ) ;
174: fnd_file.put_line(fnd_file.log,'P_PERIOD : ' || P_PERIOD ) ;
175: fnd_file.put_line(fnd_file.log,'P_VAT_BOX : ' || P_VAT_BOX ) ;
176: fnd_file.put_line(fnd_file.log,'P_VAT_TRX_TYPE_LOW : ' || P_VAT_TRX_TYPE_LOW ) ;
177: fnd_file.put_line(fnd_file.log,'P_VAT_TRX_TYPE_HIGH : ' || P_VAT_TRX_TYPE_HIGH ) ;
178: fnd_file.put_line(fnd_file.log,'P_VAT_TRX_TYPE : ' || P_VAT_TRX_TYPE ) ;
179: fnd_file.put_line(fnd_file.log,'P_REPORT_FORMAT : ' || P_REPORT_FORMAT ) ;
172: fnd_file.put_line(fnd_file.log,' *** Report Parameters *** ');
173: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID : ' || P_VAT_REP_ENTITY_ID ) ;
174: fnd_file.put_line(fnd_file.log,'P_PERIOD : ' || P_PERIOD ) ;
175: fnd_file.put_line(fnd_file.log,'P_VAT_BOX : ' || P_VAT_BOX ) ;
176: fnd_file.put_line(fnd_file.log,'P_VAT_TRX_TYPE_LOW : ' || P_VAT_TRX_TYPE_LOW ) ;
177: fnd_file.put_line(fnd_file.log,'P_VAT_TRX_TYPE_HIGH : ' || P_VAT_TRX_TYPE_HIGH ) ;
178: fnd_file.put_line(fnd_file.log,'P_VAT_TRX_TYPE : ' || P_VAT_TRX_TYPE ) ;
179: fnd_file.put_line(fnd_file.log,'P_REPORT_FORMAT : ' || P_REPORT_FORMAT ) ;
180: fnd_file.put_line(fnd_file.log,'P_BOX_FROM : ' || P_BOX_FROM ) ;
173: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID : ' || P_VAT_REP_ENTITY_ID ) ;
174: fnd_file.put_line(fnd_file.log,'P_PERIOD : ' || P_PERIOD ) ;
175: fnd_file.put_line(fnd_file.log,'P_VAT_BOX : ' || P_VAT_BOX ) ;
176: fnd_file.put_line(fnd_file.log,'P_VAT_TRX_TYPE_LOW : ' || P_VAT_TRX_TYPE_LOW ) ;
177: fnd_file.put_line(fnd_file.log,'P_VAT_TRX_TYPE_HIGH : ' || P_VAT_TRX_TYPE_HIGH ) ;
178: fnd_file.put_line(fnd_file.log,'P_VAT_TRX_TYPE : ' || P_VAT_TRX_TYPE ) ;
179: fnd_file.put_line(fnd_file.log,'P_REPORT_FORMAT : ' || P_REPORT_FORMAT ) ;
180: fnd_file.put_line(fnd_file.log,'P_BOX_FROM : ' || P_BOX_FROM ) ;
181: fnd_file.put_line(fnd_file.log,'P_BOX_TO : ' || P_BOX_TO ) ;
174: fnd_file.put_line(fnd_file.log,'P_PERIOD : ' || P_PERIOD ) ;
175: fnd_file.put_line(fnd_file.log,'P_VAT_BOX : ' || P_VAT_BOX ) ;
176: fnd_file.put_line(fnd_file.log,'P_VAT_TRX_TYPE_LOW : ' || P_VAT_TRX_TYPE_LOW ) ;
177: fnd_file.put_line(fnd_file.log,'P_VAT_TRX_TYPE_HIGH : ' || P_VAT_TRX_TYPE_HIGH ) ;
178: fnd_file.put_line(fnd_file.log,'P_VAT_TRX_TYPE : ' || P_VAT_TRX_TYPE ) ;
179: fnd_file.put_line(fnd_file.log,'P_REPORT_FORMAT : ' || P_REPORT_FORMAT ) ;
180: fnd_file.put_line(fnd_file.log,'P_BOX_FROM : ' || P_BOX_FROM ) ;
181: fnd_file.put_line(fnd_file.log,'P_BOX_TO : ' || P_BOX_TO ) ;
182: fnd_file.put_line(fnd_file.log,'P_SOURCE : ' || P_SOURCE ) ;
175: fnd_file.put_line(fnd_file.log,'P_VAT_BOX : ' || P_VAT_BOX ) ;
176: fnd_file.put_line(fnd_file.log,'P_VAT_TRX_TYPE_LOW : ' || P_VAT_TRX_TYPE_LOW ) ;
177: fnd_file.put_line(fnd_file.log,'P_VAT_TRX_TYPE_HIGH : ' || P_VAT_TRX_TYPE_HIGH ) ;
178: fnd_file.put_line(fnd_file.log,'P_VAT_TRX_TYPE : ' || P_VAT_TRX_TYPE ) ;
179: fnd_file.put_line(fnd_file.log,'P_REPORT_FORMAT : ' || P_REPORT_FORMAT ) ;
180: fnd_file.put_line(fnd_file.log,'P_BOX_FROM : ' || P_BOX_FROM ) ;
181: fnd_file.put_line(fnd_file.log,'P_BOX_TO : ' || P_BOX_TO ) ;
182: fnd_file.put_line(fnd_file.log,'P_SOURCE : ' || P_SOURCE ) ;
183: fnd_file.put_line(fnd_file.log,'P_DOC_NAME : ' || P_DOC_NAME ) ;
176: fnd_file.put_line(fnd_file.log,'P_VAT_TRX_TYPE_LOW : ' || P_VAT_TRX_TYPE_LOW ) ;
177: fnd_file.put_line(fnd_file.log,'P_VAT_TRX_TYPE_HIGH : ' || P_VAT_TRX_TYPE_HIGH ) ;
178: fnd_file.put_line(fnd_file.log,'P_VAT_TRX_TYPE : ' || P_VAT_TRX_TYPE ) ;
179: fnd_file.put_line(fnd_file.log,'P_REPORT_FORMAT : ' || P_REPORT_FORMAT ) ;
180: fnd_file.put_line(fnd_file.log,'P_BOX_FROM : ' || P_BOX_FROM ) ;
181: fnd_file.put_line(fnd_file.log,'P_BOX_TO : ' || P_BOX_TO ) ;
182: fnd_file.put_line(fnd_file.log,'P_SOURCE : ' || P_SOURCE ) ;
183: fnd_file.put_line(fnd_file.log,'P_DOC_NAME : ' || P_DOC_NAME ) ;
184: fnd_file.put_line(fnd_file.log,'P_DOC_SEQ_VALUE : ' || P_DOC_SEQ_VALUE ) ;
177: fnd_file.put_line(fnd_file.log,'P_VAT_TRX_TYPE_HIGH : ' || P_VAT_TRX_TYPE_HIGH ) ;
178: fnd_file.put_line(fnd_file.log,'P_VAT_TRX_TYPE : ' || P_VAT_TRX_TYPE ) ;
179: fnd_file.put_line(fnd_file.log,'P_REPORT_FORMAT : ' || P_REPORT_FORMAT ) ;
180: fnd_file.put_line(fnd_file.log,'P_BOX_FROM : ' || P_BOX_FROM ) ;
181: fnd_file.put_line(fnd_file.log,'P_BOX_TO : ' || P_BOX_TO ) ;
182: fnd_file.put_line(fnd_file.log,'P_SOURCE : ' || P_SOURCE ) ;
183: fnd_file.put_line(fnd_file.log,'P_DOC_NAME : ' || P_DOC_NAME ) ;
184: fnd_file.put_line(fnd_file.log,'P_DOC_SEQ_VALUE : ' || P_DOC_SEQ_VALUE ) ;
185: fnd_file.put_line(fnd_file.log,'P_REPORT_NAME : ' || P_REPORT_NAME ) ;
178: fnd_file.put_line(fnd_file.log,'P_VAT_TRX_TYPE : ' || P_VAT_TRX_TYPE ) ;
179: fnd_file.put_line(fnd_file.log,'P_REPORT_FORMAT : ' || P_REPORT_FORMAT ) ;
180: fnd_file.put_line(fnd_file.log,'P_BOX_FROM : ' || P_BOX_FROM ) ;
181: fnd_file.put_line(fnd_file.log,'P_BOX_TO : ' || P_BOX_TO ) ;
182: fnd_file.put_line(fnd_file.log,'P_SOURCE : ' || P_SOURCE ) ;
183: fnd_file.put_line(fnd_file.log,'P_DOC_NAME : ' || P_DOC_NAME ) ;
184: fnd_file.put_line(fnd_file.log,'P_DOC_SEQ_VALUE : ' || P_DOC_SEQ_VALUE ) ;
185: fnd_file.put_line(fnd_file.log,'P_REPORT_NAME : ' || P_REPORT_NAME ) ;
186: fnd_file.put_line(fnd_file.log,'P_VAR_ON_PURCHASES : ' || P_VAR_ON_PURCHASES ) ;
179: fnd_file.put_line(fnd_file.log,'P_REPORT_FORMAT : ' || P_REPORT_FORMAT ) ;
180: fnd_file.put_line(fnd_file.log,'P_BOX_FROM : ' || P_BOX_FROM ) ;
181: fnd_file.put_line(fnd_file.log,'P_BOX_TO : ' || P_BOX_TO ) ;
182: fnd_file.put_line(fnd_file.log,'P_SOURCE : ' || P_SOURCE ) ;
183: fnd_file.put_line(fnd_file.log,'P_DOC_NAME : ' || P_DOC_NAME ) ;
184: fnd_file.put_line(fnd_file.log,'P_DOC_SEQ_VALUE : ' || P_DOC_SEQ_VALUE ) ;
185: fnd_file.put_line(fnd_file.log,'P_REPORT_NAME : ' || P_REPORT_NAME ) ;
186: fnd_file.put_line(fnd_file.log,'P_VAR_ON_PURCHASES : ' || P_VAR_ON_PURCHASES ) ;
187: fnd_file.put_line(fnd_file.log,'P_VAR_ON_SALES : ' || P_VAR_ON_SALES ) ;
180: fnd_file.put_line(fnd_file.log,'P_BOX_FROM : ' || P_BOX_FROM ) ;
181: fnd_file.put_line(fnd_file.log,'P_BOX_TO : ' || P_BOX_TO ) ;
182: fnd_file.put_line(fnd_file.log,'P_SOURCE : ' || P_SOURCE ) ;
183: fnd_file.put_line(fnd_file.log,'P_DOC_NAME : ' || P_DOC_NAME ) ;
184: fnd_file.put_line(fnd_file.log,'P_DOC_SEQ_VALUE : ' || P_DOC_SEQ_VALUE ) ;
185: fnd_file.put_line(fnd_file.log,'P_REPORT_NAME : ' || P_REPORT_NAME ) ;
186: fnd_file.put_line(fnd_file.log,'P_VAR_ON_PURCHASES : ' || P_VAR_ON_PURCHASES ) ;
187: fnd_file.put_line(fnd_file.log,'P_VAR_ON_SALES : ' || P_VAR_ON_SALES ) ;
188: fnd_file.put_line(fnd_file.log,'P_LOCATION : ' || P_LOCATION ) ;
181: fnd_file.put_line(fnd_file.log,'P_BOX_TO : ' || P_BOX_TO ) ;
182: fnd_file.put_line(fnd_file.log,'P_SOURCE : ' || P_SOURCE ) ;
183: fnd_file.put_line(fnd_file.log,'P_DOC_NAME : ' || P_DOC_NAME ) ;
184: fnd_file.put_line(fnd_file.log,'P_DOC_SEQ_VALUE : ' || P_DOC_SEQ_VALUE ) ;
185: fnd_file.put_line(fnd_file.log,'P_REPORT_NAME : ' || P_REPORT_NAME ) ;
186: fnd_file.put_line(fnd_file.log,'P_VAR_ON_PURCHASES : ' || P_VAR_ON_PURCHASES ) ;
187: fnd_file.put_line(fnd_file.log,'P_VAR_ON_SALES : ' || P_VAR_ON_SALES ) ;
188: fnd_file.put_line(fnd_file.log,'P_LOCATION : ' || P_LOCATION ) ;
189: fnd_file.put_line(fnd_file.log,'P_LEGAL_ENTITY_NAME : ' || P_LEGAL_ENTITY_NAME ) ;
182: fnd_file.put_line(fnd_file.log,'P_SOURCE : ' || P_SOURCE ) ;
183: fnd_file.put_line(fnd_file.log,'P_DOC_NAME : ' || P_DOC_NAME ) ;
184: fnd_file.put_line(fnd_file.log,'P_DOC_SEQ_VALUE : ' || P_DOC_SEQ_VALUE ) ;
185: fnd_file.put_line(fnd_file.log,'P_REPORT_NAME : ' || P_REPORT_NAME ) ;
186: fnd_file.put_line(fnd_file.log,'P_VAR_ON_PURCHASES : ' || P_VAR_ON_PURCHASES ) ;
187: fnd_file.put_line(fnd_file.log,'P_VAR_ON_SALES : ' || P_VAR_ON_SALES ) ;
188: fnd_file.put_line(fnd_file.log,'P_LOCATION : ' || P_LOCATION ) ;
189: fnd_file.put_line(fnd_file.log,'P_LEGAL_ENTITY_NAME : ' || P_LEGAL_ENTITY_NAME ) ;
190: fnd_file.put_line(fnd_file.log,' *************************** ');
183: fnd_file.put_line(fnd_file.log,'P_DOC_NAME : ' || P_DOC_NAME ) ;
184: fnd_file.put_line(fnd_file.log,'P_DOC_SEQ_VALUE : ' || P_DOC_SEQ_VALUE ) ;
185: fnd_file.put_line(fnd_file.log,'P_REPORT_NAME : ' || P_REPORT_NAME ) ;
186: fnd_file.put_line(fnd_file.log,'P_VAR_ON_PURCHASES : ' || P_VAR_ON_PURCHASES ) ;
187: fnd_file.put_line(fnd_file.log,'P_VAR_ON_SALES : ' || P_VAR_ON_SALES ) ;
188: fnd_file.put_line(fnd_file.log,'P_LOCATION : ' || P_LOCATION ) ;
189: fnd_file.put_line(fnd_file.log,'P_LEGAL_ENTITY_NAME : ' || P_LEGAL_ENTITY_NAME ) ;
190: fnd_file.put_line(fnd_file.log,' *************************** ');
191: END IF;
184: fnd_file.put_line(fnd_file.log,'P_DOC_SEQ_VALUE : ' || P_DOC_SEQ_VALUE ) ;
185: fnd_file.put_line(fnd_file.log,'P_REPORT_NAME : ' || P_REPORT_NAME ) ;
186: fnd_file.put_line(fnd_file.log,'P_VAR_ON_PURCHASES : ' || P_VAR_ON_PURCHASES ) ;
187: fnd_file.put_line(fnd_file.log,'P_VAR_ON_SALES : ' || P_VAR_ON_SALES ) ;
188: fnd_file.put_line(fnd_file.log,'P_LOCATION : ' || P_LOCATION ) ;
189: fnd_file.put_line(fnd_file.log,'P_LEGAL_ENTITY_NAME : ' || P_LEGAL_ENTITY_NAME ) ;
190: fnd_file.put_line(fnd_file.log,' *************************** ');
191: END IF;
192:
185: fnd_file.put_line(fnd_file.log,'P_REPORT_NAME : ' || P_REPORT_NAME ) ;
186: fnd_file.put_line(fnd_file.log,'P_VAR_ON_PURCHASES : ' || P_VAR_ON_PURCHASES ) ;
187: fnd_file.put_line(fnd_file.log,'P_VAR_ON_SALES : ' || P_VAR_ON_SALES ) ;
188: fnd_file.put_line(fnd_file.log,'P_LOCATION : ' || P_LOCATION ) ;
189: fnd_file.put_line(fnd_file.log,'P_LEGAL_ENTITY_NAME : ' || P_LEGAL_ENTITY_NAME ) ;
190: fnd_file.put_line(fnd_file.log,' *************************** ');
191: END IF;
192:
193: BEGIN
186: fnd_file.put_line(fnd_file.log,'P_VAR_ON_PURCHASES : ' || P_VAR_ON_PURCHASES ) ;
187: fnd_file.put_line(fnd_file.log,'P_VAR_ON_SALES : ' || P_VAR_ON_SALES ) ;
188: fnd_file.put_line(fnd_file.log,'P_LOCATION : ' || P_LOCATION ) ;
189: fnd_file.put_line(fnd_file.log,'P_LEGAL_ENTITY_NAME : ' || P_LEGAL_ENTITY_NAME ) ;
190: fnd_file.put_line(fnd_file.log,' *************************** ');
191: END IF;
192:
193: BEGIN
194: IF p_report_name = 'JEPTAVAT' THEN --Only for annual report, period year is passed
211: p_legal_entity_id := l_legal_entity_id;
212: END IF ;
213: EXCEPTION
214: WHEN OTHERS THEN
215: fnd_file.put_line(fnd_file.log,'Executing jg_zz_common_pkg.funct_curr_legal: '||SUBSTR(SQLERRM,1,200));
216: END;
217:
218: BEGIN
219: IF p_report_name = 'JEPTAVAT' THEN
236: ,pv_source => 'ALL');
237: END IF;
238: EXCEPTION
239: WHEN OTHERS THEN
240: fnd_file.put_line(fnd_file.log,'Executing jg_zz_common_pkg.tax_registration: '||SUBSTR(SQLERRM,1,200));
241: END;
242:
243: BEGIN
244: if(P_REPORT_NAME <> 'JEPTAVAT' )then
262: end if;
263:
264: EXCEPTION
265: WHEN OTHERS THEN
266: fnd_file.put_line(fnd_file.log,'Executing jg_zz_common_pkg.tax_registration: '||SUBSTR(SQLERRM,1,200));
267: END;
268:
269: BEGIN
270: jg_zz_common_pkg.company_detail(x_company_name => l_company_name
284: ,pn_legal_entity_id => l_legal_entity_id
285: ,p_vat_reporting_entity_id => P_VAT_REP_ENTITY_ID);
286: EXCEPTION
287: WHEN OTHERS THEN
288: fnd_file.put_line(fnd_file.log,'Executing jg_zz_common_pkg.company_detail: '||SUBSTR(SQLERRM,1,200));
289: END;
290: BEGIN
291: SELECT activity_code
292: INTO l_activity_code
293: FROM xle_entity_profiles
294: WHERE legal_entity_id = l_legal_entity_id;
295: EXCEPTION
296: WHEN NO_DATA_FOUND THEN
297: fnd_file.put_line(fnd_file.log,'Cannot find Activity Code (Standard Inductry Classification Code for Legal Entity:'||l_legal_entity_id);
298: WHEN OTHERS THEN
299: fnd_file.put_line(fnd_file.log,'Error While retriving Activity Code for Legal Entity:'||l_legal_entity_id);
300: fnd_file.put_line(fnd_file.log,'Error Message :'||SUBSTR(SQLERRM,1,200));
301: END;
295: EXCEPTION
296: WHEN NO_DATA_FOUND THEN
297: fnd_file.put_line(fnd_file.log,'Cannot find Activity Code (Standard Inductry Classification Code for Legal Entity:'||l_legal_entity_id);
298: WHEN OTHERS THEN
299: fnd_file.put_line(fnd_file.log,'Error While retriving Activity Code for Legal Entity:'||l_legal_entity_id);
300: fnd_file.put_line(fnd_file.log,'Error Message :'||SUBSTR(SQLERRM,1,200));
301: END;
302:
303: BEGIN
296: WHEN NO_DATA_FOUND THEN
297: fnd_file.put_line(fnd_file.log,'Cannot find Activity Code (Standard Inductry Classification Code for Legal Entity:'||l_legal_entity_id);
298: WHEN OTHERS THEN
299: fnd_file.put_line(fnd_file.log,'Error While retriving Activity Code for Legal Entity:'||l_legal_entity_id);
300: fnd_file.put_line(fnd_file.log,'Error Message :'||SUBSTR(SQLERRM,1,200));
301: END;
302:
303: BEGIN
304:
309: CLOSE get_legal_auth_info;
310:
311: EXCEPTION
312: WHEN OTHERS THEN
313: fnd_file.put_line(fnd_file.log,'Error Message :'||SUBSTR(SQLERRM,1,200));
314: END;
315:
316:
317: /* Get Currency Precision */
316:
317: /* Get Currency Precision */
318:
319: BEGIN
320: FND_FILE.PUT_LINE(FND_FILE.LOG,'Functional Currency Code :'||l_func_curr);
321:
322: SELECT precision
323: INTO l_precision
324: FROM fnd_currencies
323: INTO l_precision
324: FROM fnd_currencies
325: WHERE currency_code = l_func_curr;
326:
327: FND_FILE.PUT_LINE(FND_FILE.LOG,'Functional Currency Precision :'||l_precision);
328:
329: EXCEPTION
330: WHEN OTHERS THEN
331: FND_FILE.PUT_LINE(FND_FILE.LOG,'error in getting currency precision');
327: FND_FILE.PUT_LINE(FND_FILE.LOG,'Functional Currency Precision :'||l_precision);
328:
329: EXCEPTION
330: WHEN OTHERS THEN
331: FND_FILE.PUT_LINE(FND_FILE.LOG,'error in getting currency precision');
332: END;
333:
334:
335: INSERT INTO jg_zz_vat_trx_gt
392: ,l_comm_num
393: ,l_vat_reg_num
394: );
395: IF p_debug_flag = 'Y' THEN
396: fnd_file.put_line(fnd_file.log,'Legal Entity ID => ' || l_legal_entity_id);
397: fnd_file.put_line(fnd_file.log,'Company Name => ' || l_company_name);
398: fnd_file.put_line(fnd_file.log,'Legal Entity Name => ' || l_company_name);
399: fnd_file.put_line(fnd_file.log,'Regiatration Number => ' || l_registration_num);
400: fnd_file.put_line(fnd_file.log,'Taxpayer ID => ' || l_registration_num);
393: ,l_vat_reg_num
394: );
395: IF p_debug_flag = 'Y' THEN
396: fnd_file.put_line(fnd_file.log,'Legal Entity ID => ' || l_legal_entity_id);
397: fnd_file.put_line(fnd_file.log,'Company Name => ' || l_company_name);
398: fnd_file.put_line(fnd_file.log,'Legal Entity Name => ' || l_company_name);
399: fnd_file.put_line(fnd_file.log,'Regiatration Number => ' || l_registration_num);
400: fnd_file.put_line(fnd_file.log,'Taxpayer ID => ' || l_registration_num);
401: fnd_file.put_line(fnd_file.log,'Contact Name => ' || l_contact_name);
394: );
395: IF p_debug_flag = 'Y' THEN
396: fnd_file.put_line(fnd_file.log,'Legal Entity ID => ' || l_legal_entity_id);
397: fnd_file.put_line(fnd_file.log,'Company Name => ' || l_company_name);
398: fnd_file.put_line(fnd_file.log,'Legal Entity Name => ' || l_company_name);
399: fnd_file.put_line(fnd_file.log,'Regiatration Number => ' || l_registration_num);
400: fnd_file.put_line(fnd_file.log,'Taxpayer ID => ' || l_registration_num);
401: fnd_file.put_line(fnd_file.log,'Contact Name => ' || l_contact_name);
402: fnd_file.put_line(fnd_file.log,'Address Line 1 => ' || l_address_line_1);
395: IF p_debug_flag = 'Y' THEN
396: fnd_file.put_line(fnd_file.log,'Legal Entity ID => ' || l_legal_entity_id);
397: fnd_file.put_line(fnd_file.log,'Company Name => ' || l_company_name);
398: fnd_file.put_line(fnd_file.log,'Legal Entity Name => ' || l_company_name);
399: fnd_file.put_line(fnd_file.log,'Regiatration Number => ' || l_registration_num);
400: fnd_file.put_line(fnd_file.log,'Taxpayer ID => ' || l_registration_num);
401: fnd_file.put_line(fnd_file.log,'Contact Name => ' || l_contact_name);
402: fnd_file.put_line(fnd_file.log,'Address Line 1 => ' || l_address_line_1);
403: fnd_file.put_line(fnd_file.log,'Address Line 2 => ' || l_address_line_2);
396: fnd_file.put_line(fnd_file.log,'Legal Entity ID => ' || l_legal_entity_id);
397: fnd_file.put_line(fnd_file.log,'Company Name => ' || l_company_name);
398: fnd_file.put_line(fnd_file.log,'Legal Entity Name => ' || l_company_name);
399: fnd_file.put_line(fnd_file.log,'Regiatration Number => ' || l_registration_num);
400: fnd_file.put_line(fnd_file.log,'Taxpayer ID => ' || l_registration_num);
401: fnd_file.put_line(fnd_file.log,'Contact Name => ' || l_contact_name);
402: fnd_file.put_line(fnd_file.log,'Address Line 1 => ' || l_address_line_1);
403: fnd_file.put_line(fnd_file.log,'Address Line 2 => ' || l_address_line_2);
404: fnd_file.put_line(fnd_file.log,'Address Line 3 => ' || l_address_line_3);
397: fnd_file.put_line(fnd_file.log,'Company Name => ' || l_company_name);
398: fnd_file.put_line(fnd_file.log,'Legal Entity Name => ' || l_company_name);
399: fnd_file.put_line(fnd_file.log,'Regiatration Number => ' || l_registration_num);
400: fnd_file.put_line(fnd_file.log,'Taxpayer ID => ' || l_registration_num);
401: fnd_file.put_line(fnd_file.log,'Contact Name => ' || l_contact_name);
402: fnd_file.put_line(fnd_file.log,'Address Line 1 => ' || l_address_line_1);
403: fnd_file.put_line(fnd_file.log,'Address Line 2 => ' || l_address_line_2);
404: fnd_file.put_line(fnd_file.log,'Address Line 3 => ' || l_address_line_3);
405: fnd_file.put_line(fnd_file.log,'Address Line 4 => ' || l_address_line_4);
398: fnd_file.put_line(fnd_file.log,'Legal Entity Name => ' || l_company_name);
399: fnd_file.put_line(fnd_file.log,'Regiatration Number => ' || l_registration_num);
400: fnd_file.put_line(fnd_file.log,'Taxpayer ID => ' || l_registration_num);
401: fnd_file.put_line(fnd_file.log,'Contact Name => ' || l_contact_name);
402: fnd_file.put_line(fnd_file.log,'Address Line 1 => ' || l_address_line_1);
403: fnd_file.put_line(fnd_file.log,'Address Line 2 => ' || l_address_line_2);
404: fnd_file.put_line(fnd_file.log,'Address Line 3 => ' || l_address_line_3);
405: fnd_file.put_line(fnd_file.log,'Address Line 4 => ' || l_address_line_4);
406: fnd_file.put_line(fnd_file.log,'City => ' || l_city);
399: fnd_file.put_line(fnd_file.log,'Regiatration Number => ' || l_registration_num);
400: fnd_file.put_line(fnd_file.log,'Taxpayer ID => ' || l_registration_num);
401: fnd_file.put_line(fnd_file.log,'Contact Name => ' || l_contact_name);
402: fnd_file.put_line(fnd_file.log,'Address Line 1 => ' || l_address_line_1);
403: fnd_file.put_line(fnd_file.log,'Address Line 2 => ' || l_address_line_2);
404: fnd_file.put_line(fnd_file.log,'Address Line 3 => ' || l_address_line_3);
405: fnd_file.put_line(fnd_file.log,'Address Line 4 => ' || l_address_line_4);
406: fnd_file.put_line(fnd_file.log,'City => ' || l_city);
407: fnd_file.put_line(fnd_file.log,'Country => ' || l_country);
400: fnd_file.put_line(fnd_file.log,'Taxpayer ID => ' || l_registration_num);
401: fnd_file.put_line(fnd_file.log,'Contact Name => ' || l_contact_name);
402: fnd_file.put_line(fnd_file.log,'Address Line 1 => ' || l_address_line_1);
403: fnd_file.put_line(fnd_file.log,'Address Line 2 => ' || l_address_line_2);
404: fnd_file.put_line(fnd_file.log,'Address Line 3 => ' || l_address_line_3);
405: fnd_file.put_line(fnd_file.log,'Address Line 4 => ' || l_address_line_4);
406: fnd_file.put_line(fnd_file.log,'City => ' || l_city);
407: fnd_file.put_line(fnd_file.log,'Country => ' || l_country);
408: fnd_file.put_line(fnd_file.log,'Telephone Number => ' || l_phone_number);
401: fnd_file.put_line(fnd_file.log,'Contact Name => ' || l_contact_name);
402: fnd_file.put_line(fnd_file.log,'Address Line 1 => ' || l_address_line_1);
403: fnd_file.put_line(fnd_file.log,'Address Line 2 => ' || l_address_line_2);
404: fnd_file.put_line(fnd_file.log,'Address Line 3 => ' || l_address_line_3);
405: fnd_file.put_line(fnd_file.log,'Address Line 4 => ' || l_address_line_4);
406: fnd_file.put_line(fnd_file.log,'City => ' || l_city);
407: fnd_file.put_line(fnd_file.log,'Country => ' || l_country);
408: fnd_file.put_line(fnd_file.log,'Telephone Number => ' || l_phone_number);
409: fnd_file.put_line(fnd_file.log,'Postal Code => ' || l_postal_code);
402: fnd_file.put_line(fnd_file.log,'Address Line 1 => ' || l_address_line_1);
403: fnd_file.put_line(fnd_file.log,'Address Line 2 => ' || l_address_line_2);
404: fnd_file.put_line(fnd_file.log,'Address Line 3 => ' || l_address_line_3);
405: fnd_file.put_line(fnd_file.log,'Address Line 4 => ' || l_address_line_4);
406: fnd_file.put_line(fnd_file.log,'City => ' || l_city);
407: fnd_file.put_line(fnd_file.log,'Country => ' || l_country);
408: fnd_file.put_line(fnd_file.log,'Telephone Number => ' || l_phone_number);
409: fnd_file.put_line(fnd_file.log,'Postal Code => ' || l_postal_code);
410: fnd_file.put_line(fnd_file.log,'Currency Code => ' || l_func_curr);
403: fnd_file.put_line(fnd_file.log,'Address Line 2 => ' || l_address_line_2);
404: fnd_file.put_line(fnd_file.log,'Address Line 3 => ' || l_address_line_3);
405: fnd_file.put_line(fnd_file.log,'Address Line 4 => ' || l_address_line_4);
406: fnd_file.put_line(fnd_file.log,'City => ' || l_city);
407: fnd_file.put_line(fnd_file.log,'Country => ' || l_country);
408: fnd_file.put_line(fnd_file.log,'Telephone Number => ' || l_phone_number);
409: fnd_file.put_line(fnd_file.log,'Postal Code => ' || l_postal_code);
410: fnd_file.put_line(fnd_file.log,'Currency Code => ' || l_func_curr);
411: fnd_file.put_line(fnd_file.log,'Reporting Status => ' || l_reporting_status);
404: fnd_file.put_line(fnd_file.log,'Address Line 3 => ' || l_address_line_3);
405: fnd_file.put_line(fnd_file.log,'Address Line 4 => ' || l_address_line_4);
406: fnd_file.put_line(fnd_file.log,'City => ' || l_city);
407: fnd_file.put_line(fnd_file.log,'Country => ' || l_country);
408: fnd_file.put_line(fnd_file.log,'Telephone Number => ' || l_phone_number);
409: fnd_file.put_line(fnd_file.log,'Postal Code => ' || l_postal_code);
410: fnd_file.put_line(fnd_file.log,'Currency Code => ' || l_func_curr);
411: fnd_file.put_line(fnd_file.log,'Reporting Status => ' || l_reporting_status);
412: fnd_file.put_line(fnd_file.log,'Period Start Date => ' || l_period_start_date);
405: fnd_file.put_line(fnd_file.log,'Address Line 4 => ' || l_address_line_4);
406: fnd_file.put_line(fnd_file.log,'City => ' || l_city);
407: fnd_file.put_line(fnd_file.log,'Country => ' || l_country);
408: fnd_file.put_line(fnd_file.log,'Telephone Number => ' || l_phone_number);
409: fnd_file.put_line(fnd_file.log,'Postal Code => ' || l_postal_code);
410: fnd_file.put_line(fnd_file.log,'Currency Code => ' || l_func_curr);
411: fnd_file.put_line(fnd_file.log,'Reporting Status => ' || l_reporting_status);
412: fnd_file.put_line(fnd_file.log,'Period Start Date => ' || l_period_start_date);
413: fnd_file.put_line(fnd_file.log,'Period End Date => ' || l_period_end_date);
406: fnd_file.put_line(fnd_file.log,'City => ' || l_city);
407: fnd_file.put_line(fnd_file.log,'Country => ' || l_country);
408: fnd_file.put_line(fnd_file.log,'Telephone Number => ' || l_phone_number);
409: fnd_file.put_line(fnd_file.log,'Postal Code => ' || l_postal_code);
410: fnd_file.put_line(fnd_file.log,'Currency Code => ' || l_func_curr);
411: fnd_file.put_line(fnd_file.log,'Reporting Status => ' || l_reporting_status);
412: fnd_file.put_line(fnd_file.log,'Period Start Date => ' || l_period_start_date);
413: fnd_file.put_line(fnd_file.log,'Period End Date => ' || l_period_end_date);
414: fnd_file.put_line(fnd_file.log,'l_tax_office_location => ' || l_tax_office_location);
407: fnd_file.put_line(fnd_file.log,'Country => ' || l_country);
408: fnd_file.put_line(fnd_file.log,'Telephone Number => ' || l_phone_number);
409: fnd_file.put_line(fnd_file.log,'Postal Code => ' || l_postal_code);
410: fnd_file.put_line(fnd_file.log,'Currency Code => ' || l_func_curr);
411: fnd_file.put_line(fnd_file.log,'Reporting Status => ' || l_reporting_status);
412: fnd_file.put_line(fnd_file.log,'Period Start Date => ' || l_period_start_date);
413: fnd_file.put_line(fnd_file.log,'Period End Date => ' || l_period_end_date);
414: fnd_file.put_line(fnd_file.log,'l_tax_office_location => ' || l_tax_office_location);
415: fnd_file.put_line(fnd_file.log,'l_tax_office_code => ' || l_tax_office_code);
408: fnd_file.put_line(fnd_file.log,'Telephone Number => ' || l_phone_number);
409: fnd_file.put_line(fnd_file.log,'Postal Code => ' || l_postal_code);
410: fnd_file.put_line(fnd_file.log,'Currency Code => ' || l_func_curr);
411: fnd_file.put_line(fnd_file.log,'Reporting Status => ' || l_reporting_status);
412: fnd_file.put_line(fnd_file.log,'Period Start Date => ' || l_period_start_date);
413: fnd_file.put_line(fnd_file.log,'Period End Date => ' || l_period_end_date);
414: fnd_file.put_line(fnd_file.log,'l_tax_office_location => ' || l_tax_office_location);
415: fnd_file.put_line(fnd_file.log,'l_tax_office_code => ' || l_tax_office_code);
416: END IF;
409: fnd_file.put_line(fnd_file.log,'Postal Code => ' || l_postal_code);
410: fnd_file.put_line(fnd_file.log,'Currency Code => ' || l_func_curr);
411: fnd_file.put_line(fnd_file.log,'Reporting Status => ' || l_reporting_status);
412: fnd_file.put_line(fnd_file.log,'Period Start Date => ' || l_period_start_date);
413: fnd_file.put_line(fnd_file.log,'Period End Date => ' || l_period_end_date);
414: fnd_file.put_line(fnd_file.log,'l_tax_office_location => ' || l_tax_office_location);
415: fnd_file.put_line(fnd_file.log,'l_tax_office_code => ' || l_tax_office_code);
416: END IF;
417: IF p_report_name = 'JEBEVA06' THEN
410: fnd_file.put_line(fnd_file.log,'Currency Code => ' || l_func_curr);
411: fnd_file.put_line(fnd_file.log,'Reporting Status => ' || l_reporting_status);
412: fnd_file.put_line(fnd_file.log,'Period Start Date => ' || l_period_start_date);
413: fnd_file.put_line(fnd_file.log,'Period End Date => ' || l_period_end_date);
414: fnd_file.put_line(fnd_file.log,'l_tax_office_location => ' || l_tax_office_location);
415: fnd_file.put_line(fnd_file.log,'l_tax_office_code => ' || l_tax_office_code);
416: END IF;
417: IF p_report_name = 'JEBEVA06' THEN
418: IF p_debug_flag = 'Y' THEN
411: fnd_file.put_line(fnd_file.log,'Reporting Status => ' || l_reporting_status);
412: fnd_file.put_line(fnd_file.log,'Period Start Date => ' || l_period_start_date);
413: fnd_file.put_line(fnd_file.log,'Period End Date => ' || l_period_end_date);
414: fnd_file.put_line(fnd_file.log,'l_tax_office_location => ' || l_tax_office_location);
415: fnd_file.put_line(fnd_file.log,'l_tax_office_code => ' || l_tax_office_code);
416: END IF;
417: IF p_report_name = 'JEBEVA06' THEN
418: IF p_debug_flag = 'Y' THEN
419: fnd_file.put_line(fnd_file.log,'Calling Procedure jgbeva06');
415: fnd_file.put_line(fnd_file.log,'l_tax_office_code => ' || l_tax_office_code);
416: END IF;
417: IF p_report_name = 'JEBEVA06' THEN
418: IF p_debug_flag = 'Y' THEN
419: fnd_file.put_line(fnd_file.log,'Calling Procedure jgbeva06');
420: END IF;
421: jebeva06(p_vat_rep_entity_id => p_vat_rep_entity_id
422: ,p_period => p_period
423: ,p_vat_box => p_vat_box
427: ,p_doc_name => p_doc_name
428: ,p_doc_seq_value => p_doc_seq_value
429: ,x_err_msg => l_err_msg);
430: IF p_debug_flag = 'Y' THEN
431: fnd_file.put_line(fnd_file.log,'Completed Call to Procedure jgbava06');
432: END IF;
433: ELSIF p_report_name = 'JEPTAVAT' THEN
434: IF p_debug_flag = 'Y' THEN
435: fnd_file.put_line(fnd_file.log,'Calling Procedure JEPTAVAT');
431: fnd_file.put_line(fnd_file.log,'Completed Call to Procedure jgbava06');
432: END IF;
433: ELSIF p_report_name = 'JEPTAVAT' THEN
434: IF p_debug_flag = 'Y' THEN
435: fnd_file.put_line(fnd_file.log,'Calling Procedure JEPTAVAT');
436: END IF;
437: jeptavat(p_vat_rep_entity_id => p_vat_rep_entity_id
438: ,p_period => p_period
439: ,p_location => p_location
438: ,p_period => p_period
439: ,p_location => p_location
440: ,x_err_msg => l_err_msg);
441: IF p_debug_flag = 'Y' THEN
442: fnd_file.put_line(fnd_file.log,'Completed Call to Procedure JEPTAVAT');
443: END IF;
444: ELSIF p_report_name = 'JEPTPVAT' THEN
445: IF p_debug_flag = 'Y' THEN
446: fnd_file.put_line(fnd_file.log,'Calling Procedure JEPTPVAT');
442: fnd_file.put_line(fnd_file.log,'Completed Call to Procedure JEPTAVAT');
443: END IF;
444: ELSIF p_report_name = 'JEPTPVAT' THEN
445: IF p_debug_flag = 'Y' THEN
446: fnd_file.put_line(fnd_file.log,'Calling Procedure JEPTPVAT');
447: END IF;
448: jeptpvat(p_vat_rep_entity_id => p_vat_rep_entity_id
449: ,p_period => p_period
450: ,p_location => p_location
449: ,p_period => p_period
450: ,p_location => p_location
451: ,x_err_msg => l_err_msg);
452: IF p_debug_flag = 'Y' THEN
453: fnd_file.put_line(fnd_file.log,'Completed Call to Procedure JEPTPVAT');
454: END IF;
455: ELSIF p_report_name = 'JEITPSSR' THEN
456: IF p_debug_flag = 'Y' THEN
457: fnd_file.put_line(fnd_file.log,'Calling Procedure JEITPSSR');
453: fnd_file.put_line(fnd_file.log,'Completed Call to Procedure JEPTPVAT');
454: END IF;
455: ELSIF p_report_name = 'JEITPSSR' THEN
456: IF p_debug_flag = 'Y' THEN
457: fnd_file.put_line(fnd_file.log,'Calling Procedure JEITPSSR');
458: END IF;
459: jeitpssr(p_vat_rep_entity_id => p_vat_rep_entity_id
460: ,p_period => p_period
461: ,p_var_on_purchases => p_var_on_purchases
461: ,p_var_on_purchases => p_var_on_purchases
462: ,p_var_on_sales => p_var_on_sales
463: ,x_err_msg => l_err_msg);
464: IF p_debug_flag = 'Y' THEN
465: fnd_file.put_line(fnd_file.log,'Completed Call to Procedure JEITPSSR');
466: END IF;
467: END IF;
468:
469: IF p_debug_flag = 'Y' THEN
466: END IF;
467: END IF;
468:
469: IF p_debug_flag = 'Y' THEN
470: fnd_file.put_line(fnd_file.log,'End of Before Report');
471: END IF;
472:
473: RETURN (TRUE);
474: EXCEPTION
474: EXCEPTION
475: WHEN NO_DATA_FOUND THEN
476: RETURN (TRUE);
477: WHEN OTHERS THEN
478: fnd_file.put_line(fnd_file.log,'Error in Before Report Trigger' || SQLCODE || SUBSTR(SQLERRM,1,200));
479: raise;
480: RETURN (FALSE);
481: END before_report;
482:
635: l_index NUMBER;
636: l_count NUMBER := 0 ;
637: BEGIN
638: IF p_debug_flag = 'Y' THEN
639: fnd_file.put_line(fnd_file.log,'Executing jg_zz_summary_all_pkg.jgbeva06');
640: fnd_file.put_line(fnd_file.log,'Open Cursor C_BELGIAN_VAT');
641: END IF;
642: OPEN c_belgian_vat;
643: FETCH c_belgian_vat BULK COLLECT INTO v_box_amount;
636: l_count NUMBER := 0 ;
637: BEGIN
638: IF p_debug_flag = 'Y' THEN
639: fnd_file.put_line(fnd_file.log,'Executing jg_zz_summary_all_pkg.jgbeva06');
640: fnd_file.put_line(fnd_file.log,'Open Cursor C_BELGIAN_VAT');
641: END IF;
642: OPEN c_belgian_vat;
643: FETCH c_belgian_vat BULK COLLECT INTO v_box_amount;
644: CLOSE c_belgian_vat;
707:
708: FOR i IN 1..l_box_amount_grouped.COUNT
709: LOOP
710: IF p_debug_flag = 'Y' THEN
711: fnd_file.put_line(fnd_file.log,'Period Year => ' || l_box_amount_grouped(i).period_year);
712: fnd_file.put_line(fnd_file.log,'Period Name => ' || l_box_amount_grouped(i).period_name);
713: fnd_file.put_line(fnd_file.log,'VAT Report Box => ' || l_box_amount_grouped(i).vat_report_box);
714: fnd_file.put_line(fnd_file.log,'Box Descriptionc => ' || l_box_amount_grouped(i).vat_box_description);
715: fnd_file.put_line(fnd_file.log,'Source => ' || l_box_amount_grouped(i).source);
708: FOR i IN 1..l_box_amount_grouped.COUNT
709: LOOP
710: IF p_debug_flag = 'Y' THEN
711: fnd_file.put_line(fnd_file.log,'Period Year => ' || l_box_amount_grouped(i).period_year);
712: fnd_file.put_line(fnd_file.log,'Period Name => ' || l_box_amount_grouped(i).period_name);
713: fnd_file.put_line(fnd_file.log,'VAT Report Box => ' || l_box_amount_grouped(i).vat_report_box);
714: fnd_file.put_line(fnd_file.log,'Box Descriptionc => ' || l_box_amount_grouped(i).vat_box_description);
715: fnd_file.put_line(fnd_file.log,'Source => ' || l_box_amount_grouped(i).source);
716: fnd_file.put_line(fnd_file.log,'Document Name => ' || l_box_amount_grouped(i).document_seq_name);
709: LOOP
710: IF p_debug_flag = 'Y' THEN
711: fnd_file.put_line(fnd_file.log,'Period Year => ' || l_box_amount_grouped(i).period_year);
712: fnd_file.put_line(fnd_file.log,'Period Name => ' || l_box_amount_grouped(i).period_name);
713: fnd_file.put_line(fnd_file.log,'VAT Report Box => ' || l_box_amount_grouped(i).vat_report_box);
714: fnd_file.put_line(fnd_file.log,'Box Descriptionc => ' || l_box_amount_grouped(i).vat_box_description);
715: fnd_file.put_line(fnd_file.log,'Source => ' || l_box_amount_grouped(i).source);
716: fnd_file.put_line(fnd_file.log,'Document Name => ' || l_box_amount_grouped(i).document_seq_name);
717: fnd_file.put_line(fnd_file.log,'Documemt Value => ' || l_box_amount_grouped(i).document_seq_value);
710: IF p_debug_flag = 'Y' THEN
711: fnd_file.put_line(fnd_file.log,'Period Year => ' || l_box_amount_grouped(i).period_year);
712: fnd_file.put_line(fnd_file.log,'Period Name => ' || l_box_amount_grouped(i).period_name);
713: fnd_file.put_line(fnd_file.log,'VAT Report Box => ' || l_box_amount_grouped(i).vat_report_box);
714: fnd_file.put_line(fnd_file.log,'Box Descriptionc => ' || l_box_amount_grouped(i).vat_box_description);
715: fnd_file.put_line(fnd_file.log,'Source => ' || l_box_amount_grouped(i).source);
716: fnd_file.put_line(fnd_file.log,'Document Name => ' || l_box_amount_grouped(i).document_seq_name);
717: fnd_file.put_line(fnd_file.log,'Documemt Value => ' || l_box_amount_grouped(i).document_seq_value);
718: fnd_file.put_line(fnd_file.log,'GL Date => ' || l_box_amount_grouped(i).gl_date);
711: fnd_file.put_line(fnd_file.log,'Period Year => ' || l_box_amount_grouped(i).period_year);
712: fnd_file.put_line(fnd_file.log,'Period Name => ' || l_box_amount_grouped(i).period_name);
713: fnd_file.put_line(fnd_file.log,'VAT Report Box => ' || l_box_amount_grouped(i).vat_report_box);
714: fnd_file.put_line(fnd_file.log,'Box Descriptionc => ' || l_box_amount_grouped(i).vat_box_description);
715: fnd_file.put_line(fnd_file.log,'Source => ' || l_box_amount_grouped(i).source);
716: fnd_file.put_line(fnd_file.log,'Document Name => ' || l_box_amount_grouped(i).document_seq_name);
717: fnd_file.put_line(fnd_file.log,'Documemt Value => ' || l_box_amount_grouped(i).document_seq_value);
718: fnd_file.put_line(fnd_file.log,'GL Date => ' || l_box_amount_grouped(i).gl_date);
719: fnd_file.put_line(fnd_file.log,'Vendor Number => ' || l_box_amount_grouped(i).trading_partner_number);
712: fnd_file.put_line(fnd_file.log,'Period Name => ' || l_box_amount_grouped(i).period_name);
713: fnd_file.put_line(fnd_file.log,'VAT Report Box => ' || l_box_amount_grouped(i).vat_report_box);
714: fnd_file.put_line(fnd_file.log,'Box Descriptionc => ' || l_box_amount_grouped(i).vat_box_description);
715: fnd_file.put_line(fnd_file.log,'Source => ' || l_box_amount_grouped(i).source);
716: fnd_file.put_line(fnd_file.log,'Document Name => ' || l_box_amount_grouped(i).document_seq_name);
717: fnd_file.put_line(fnd_file.log,'Documemt Value => ' || l_box_amount_grouped(i).document_seq_value);
718: fnd_file.put_line(fnd_file.log,'GL Date => ' || l_box_amount_grouped(i).gl_date);
719: fnd_file.put_line(fnd_file.log,'Vendor Number => ' || l_box_amount_grouped(i).trading_partner_number);
720: fnd_file.put_line(fnd_file.log,'Vendor_Name => ' || l_box_amount_grouped(i).trading_partner_name);
713: fnd_file.put_line(fnd_file.log,'VAT Report Box => ' || l_box_amount_grouped(i).vat_report_box);
714: fnd_file.put_line(fnd_file.log,'Box Descriptionc => ' || l_box_amount_grouped(i).vat_box_description);
715: fnd_file.put_line(fnd_file.log,'Source => ' || l_box_amount_grouped(i).source);
716: fnd_file.put_line(fnd_file.log,'Document Name => ' || l_box_amount_grouped(i).document_seq_name);
717: fnd_file.put_line(fnd_file.log,'Documemt Value => ' || l_box_amount_grouped(i).document_seq_value);
718: fnd_file.put_line(fnd_file.log,'GL Date => ' || l_box_amount_grouped(i).gl_date);
719: fnd_file.put_line(fnd_file.log,'Vendor Number => ' || l_box_amount_grouped(i).trading_partner_number);
720: fnd_file.put_line(fnd_file.log,'Vendor_Name => ' || l_box_amount_grouped(i).trading_partner_name);
721: fnd_file.put_line(fnd_file.log,'Invoice Number => ' || l_box_amount_grouped(i).invoice);
714: fnd_file.put_line(fnd_file.log,'Box Descriptionc => ' || l_box_amount_grouped(i).vat_box_description);
715: fnd_file.put_line(fnd_file.log,'Source => ' || l_box_amount_grouped(i).source);
716: fnd_file.put_line(fnd_file.log,'Document Name => ' || l_box_amount_grouped(i).document_seq_name);
717: fnd_file.put_line(fnd_file.log,'Documemt Value => ' || l_box_amount_grouped(i).document_seq_value);
718: fnd_file.put_line(fnd_file.log,'GL Date => ' || l_box_amount_grouped(i).gl_date);
719: fnd_file.put_line(fnd_file.log,'Vendor Number => ' || l_box_amount_grouped(i).trading_partner_number);
720: fnd_file.put_line(fnd_file.log,'Vendor_Name => ' || l_box_amount_grouped(i).trading_partner_name);
721: fnd_file.put_line(fnd_file.log,'Invoice Number => ' || l_box_amount_grouped(i).invoice);
722: fnd_file.put_line(fnd_file.log,'Line Number => ' || l_box_amount_grouped(i).line_number);
715: fnd_file.put_line(fnd_file.log,'Source => ' || l_box_amount_grouped(i).source);
716: fnd_file.put_line(fnd_file.log,'Document Name => ' || l_box_amount_grouped(i).document_seq_name);
717: fnd_file.put_line(fnd_file.log,'Documemt Value => ' || l_box_amount_grouped(i).document_seq_value);
718: fnd_file.put_line(fnd_file.log,'GL Date => ' || l_box_amount_grouped(i).gl_date);
719: fnd_file.put_line(fnd_file.log,'Vendor Number => ' || l_box_amount_grouped(i).trading_partner_number);
720: fnd_file.put_line(fnd_file.log,'Vendor_Name => ' || l_box_amount_grouped(i).trading_partner_name);
721: fnd_file.put_line(fnd_file.log,'Invoice Number => ' || l_box_amount_grouped(i).invoice);
722: fnd_file.put_line(fnd_file.log,'Line Number => ' || l_box_amount_grouped(i).line_number);
723: fnd_file.put_line(fnd_file.log,'VAT Code => ' || l_box_amount_grouped(i).vat_code);
716: fnd_file.put_line(fnd_file.log,'Document Name => ' || l_box_amount_grouped(i).document_seq_name);
717: fnd_file.put_line(fnd_file.log,'Documemt Value => ' || l_box_amount_grouped(i).document_seq_value);
718: fnd_file.put_line(fnd_file.log,'GL Date => ' || l_box_amount_grouped(i).gl_date);
719: fnd_file.put_line(fnd_file.log,'Vendor Number => ' || l_box_amount_grouped(i).trading_partner_number);
720: fnd_file.put_line(fnd_file.log,'Vendor_Name => ' || l_box_amount_grouped(i).trading_partner_name);
721: fnd_file.put_line(fnd_file.log,'Invoice Number => ' || l_box_amount_grouped(i).invoice);
722: fnd_file.put_line(fnd_file.log,'Line Number => ' || l_box_amount_grouped(i).line_number);
723: fnd_file.put_line(fnd_file.log,'VAT Code => ' || l_box_amount_grouped(i).vat_code);
724: fnd_file.put_line(fnd_file.log,'VAT Trans Type => ' || l_box_amount_grouped(i).vat_transaction_type);
717: fnd_file.put_line(fnd_file.log,'Documemt Value => ' || l_box_amount_grouped(i).document_seq_value);
718: fnd_file.put_line(fnd_file.log,'GL Date => ' || l_box_amount_grouped(i).gl_date);
719: fnd_file.put_line(fnd_file.log,'Vendor Number => ' || l_box_amount_grouped(i).trading_partner_number);
720: fnd_file.put_line(fnd_file.log,'Vendor_Name => ' || l_box_amount_grouped(i).trading_partner_name);
721: fnd_file.put_line(fnd_file.log,'Invoice Number => ' || l_box_amount_grouped(i).invoice);
722: fnd_file.put_line(fnd_file.log,'Line Number => ' || l_box_amount_grouped(i).line_number);
723: fnd_file.put_line(fnd_file.log,'VAT Code => ' || l_box_amount_grouped(i).vat_code);
724: fnd_file.put_line(fnd_file.log,'VAT Trans Type => ' || l_box_amount_grouped(i).vat_transaction_type);
725: fnd_file.put_line(fnd_file.log,'Taxable Amount => ' || l_box_amount_grouped(i).taxable_amount);
718: fnd_file.put_line(fnd_file.log,'GL Date => ' || l_box_amount_grouped(i).gl_date);
719: fnd_file.put_line(fnd_file.log,'Vendor Number => ' || l_box_amount_grouped(i).trading_partner_number);
720: fnd_file.put_line(fnd_file.log,'Vendor_Name => ' || l_box_amount_grouped(i).trading_partner_name);
721: fnd_file.put_line(fnd_file.log,'Invoice Number => ' || l_box_amount_grouped(i).invoice);
722: fnd_file.put_line(fnd_file.log,'Line Number => ' || l_box_amount_grouped(i).line_number);
723: fnd_file.put_line(fnd_file.log,'VAT Code => ' || l_box_amount_grouped(i).vat_code);
724: fnd_file.put_line(fnd_file.log,'VAT Trans Type => ' || l_box_amount_grouped(i).vat_transaction_type);
725: fnd_file.put_line(fnd_file.log,'Taxable Amount => ' || l_box_amount_grouped(i).taxable_amount);
726: fnd_file.put_line(fnd_file.log,'Tax Amount => ' || l_box_amount_grouped(i).tax_amount);
719: fnd_file.put_line(fnd_file.log,'Vendor Number => ' || l_box_amount_grouped(i).trading_partner_number);
720: fnd_file.put_line(fnd_file.log,'Vendor_Name => ' || l_box_amount_grouped(i).trading_partner_name);
721: fnd_file.put_line(fnd_file.log,'Invoice Number => ' || l_box_amount_grouped(i).invoice);
722: fnd_file.put_line(fnd_file.log,'Line Number => ' || l_box_amount_grouped(i).line_number);
723: fnd_file.put_line(fnd_file.log,'VAT Code => ' || l_box_amount_grouped(i).vat_code);
724: fnd_file.put_line(fnd_file.log,'VAT Trans Type => ' || l_box_amount_grouped(i).vat_transaction_type);
725: fnd_file.put_line(fnd_file.log,'Taxable Amount => ' || l_box_amount_grouped(i).taxable_amount);
726: fnd_file.put_line(fnd_file.log,'Tax Amount => ' || l_box_amount_grouped(i).tax_amount);
727: END IF;
720: fnd_file.put_line(fnd_file.log,'Vendor_Name => ' || l_box_amount_grouped(i).trading_partner_name);
721: fnd_file.put_line(fnd_file.log,'Invoice Number => ' || l_box_amount_grouped(i).invoice);
722: fnd_file.put_line(fnd_file.log,'Line Number => ' || l_box_amount_grouped(i).line_number);
723: fnd_file.put_line(fnd_file.log,'VAT Code => ' || l_box_amount_grouped(i).vat_code);
724: fnd_file.put_line(fnd_file.log,'VAT Trans Type => ' || l_box_amount_grouped(i).vat_transaction_type);
725: fnd_file.put_line(fnd_file.log,'Taxable Amount => ' || l_box_amount_grouped(i).taxable_amount);
726: fnd_file.put_line(fnd_file.log,'Tax Amount => ' || l_box_amount_grouped(i).tax_amount);
727: END IF;
728: INSERT INTO jg_zz_vat_trx_gt
721: fnd_file.put_line(fnd_file.log,'Invoice Number => ' || l_box_amount_grouped(i).invoice);
722: fnd_file.put_line(fnd_file.log,'Line Number => ' || l_box_amount_grouped(i).line_number);
723: fnd_file.put_line(fnd_file.log,'VAT Code => ' || l_box_amount_grouped(i).vat_code);
724: fnd_file.put_line(fnd_file.log,'VAT Trans Type => ' || l_box_amount_grouped(i).vat_transaction_type);
725: fnd_file.put_line(fnd_file.log,'Taxable Amount => ' || l_box_amount_grouped(i).taxable_amount);
726: fnd_file.put_line(fnd_file.log,'Tax Amount => ' || l_box_amount_grouped(i).tax_amount);
727: END IF;
728: INSERT INTO jg_zz_vat_trx_gt
729: (
722: fnd_file.put_line(fnd_file.log,'Line Number => ' || l_box_amount_grouped(i).line_number);
723: fnd_file.put_line(fnd_file.log,'VAT Code => ' || l_box_amount_grouped(i).vat_code);
724: fnd_file.put_line(fnd_file.log,'VAT Trans Type => ' || l_box_amount_grouped(i).vat_transaction_type);
725: fnd_file.put_line(fnd_file.log,'Taxable Amount => ' || l_box_amount_grouped(i).taxable_amount);
726: fnd_file.put_line(fnd_file.log,'Tax Amount => ' || l_box_amount_grouped(i).tax_amount);
727: END IF;
728: INSERT INTO jg_zz_vat_trx_gt
729: (
730: jg_info_n1
766: END LOOP;
767:
768: SELECT count(*) into l_count from jg_zz_vat_trx_gt ;
769: IF p_debug_flag = 'Y' THEN
770: fnd_file.put_line(fnd_file.log,'Number of records inserted into jg_zz_vat_trx_gt table: ' || l_count );
771: fnd_file.put_line(fnd_file.log,'Completed procedure jg_zz_summary_all_pkg.jgbeva06');
772: END IF;
773: EXCEPTION
774: WHEN OTHERS THEN
767:
768: SELECT count(*) into l_count from jg_zz_vat_trx_gt ;
769: IF p_debug_flag = 'Y' THEN
770: fnd_file.put_line(fnd_file.log,'Number of records inserted into jg_zz_vat_trx_gt table: ' || l_count );
771: fnd_file.put_line(fnd_file.log,'Completed procedure jg_zz_summary_all_pkg.jgbeva06');
772: END IF;
773: EXCEPTION
774: WHEN OTHERS THEN
775: fnd_file.put_line(fnd_file.log,'Error in Procedure jg_zz_summary_all_pkg.jebeva06 ' || SUBSTR(SQLERRM,1,200));
771: fnd_file.put_line(fnd_file.log,'Completed procedure jg_zz_summary_all_pkg.jgbeva06');
772: END IF;
773: EXCEPTION
774: WHEN OTHERS THEN
775: fnd_file.put_line(fnd_file.log,'Error in Procedure jg_zz_summary_all_pkg.jebeva06 ' || SUBSTR(SQLERRM,1,200));
776: RAISE;
777: END jebeva06;
778:
779: --
909: -- Set data flag to yes
910: l_data_found := 'Y';
911:
912: IF p_debug_flag = 'Y' then
913: fnd_file.put_line(fnd_file.log,'---- Trans Id ------ '||l_pt_avat.transaction_id||'-----');
914: fnd_file.put_line(fnd_file.log,'---- Trans Number--- '||l_pt_avat.trx_number||'-----');
915: fnd_file.put_line(fnd_file.log,'Tax class information: ' || l_pt_avat.tax_class);
916: fnd_file.put_line(fnd_file.log,'Tax Recovery Rate: ' ||l_pt_avat.tax_recv_rate);
917: fnd_file.put_line(fnd_file.log,'Tax Recoverable Flag : '||l_pt_avat.tax_recoverable_flag);
910: l_data_found := 'Y';
911:
912: IF p_debug_flag = 'Y' then
913: fnd_file.put_line(fnd_file.log,'---- Trans Id ------ '||l_pt_avat.transaction_id||'-----');
914: fnd_file.put_line(fnd_file.log,'---- Trans Number--- '||l_pt_avat.trx_number||'-----');
915: fnd_file.put_line(fnd_file.log,'Tax class information: ' || l_pt_avat.tax_class);
916: fnd_file.put_line(fnd_file.log,'Tax Recovery Rate: ' ||l_pt_avat.tax_recv_rate);
917: fnd_file.put_line(fnd_file.log,'Tax Recoverable Flag : '||l_pt_avat.tax_recoverable_flag);
918: fnd_file.put_line(fnd_file.log,'Taxable box: ' ||l_pt_avat.txbl_nrc_box);
911:
912: IF p_debug_flag = 'Y' then
913: fnd_file.put_line(fnd_file.log,'---- Trans Id ------ '||l_pt_avat.transaction_id||'-----');
914: fnd_file.put_line(fnd_file.log,'---- Trans Number--- '||l_pt_avat.trx_number||'-----');
915: fnd_file.put_line(fnd_file.log,'Tax class information: ' || l_pt_avat.tax_class);
916: fnd_file.put_line(fnd_file.log,'Tax Recovery Rate: ' ||l_pt_avat.tax_recv_rate);
917: fnd_file.put_line(fnd_file.log,'Tax Recoverable Flag : '||l_pt_avat.tax_recoverable_flag);
918: fnd_file.put_line(fnd_file.log,'Taxable box: ' ||l_pt_avat.txbl_nrc_box);
919: fnd_file.put_line(fnd_file.log,'Taxable amount: ' ||l_pt_avat.txbl_nrc_amount);
912: IF p_debug_flag = 'Y' then
913: fnd_file.put_line(fnd_file.log,'---- Trans Id ------ '||l_pt_avat.transaction_id||'-----');
914: fnd_file.put_line(fnd_file.log,'---- Trans Number--- '||l_pt_avat.trx_number||'-----');
915: fnd_file.put_line(fnd_file.log,'Tax class information: ' || l_pt_avat.tax_class);
916: fnd_file.put_line(fnd_file.log,'Tax Recovery Rate: ' ||l_pt_avat.tax_recv_rate);
917: fnd_file.put_line(fnd_file.log,'Tax Recoverable Flag : '||l_pt_avat.tax_recoverable_flag);
918: fnd_file.put_line(fnd_file.log,'Taxable box: ' ||l_pt_avat.txbl_nrc_box);
919: fnd_file.put_line(fnd_file.log,'Taxable amount: ' ||l_pt_avat.txbl_nrc_amount);
920: fnd_file.put_line(fnd_file.log,'Tax box: ' || l_pt_avat.tax_box);
913: fnd_file.put_line(fnd_file.log,'---- Trans Id ------ '||l_pt_avat.transaction_id||'-----');
914: fnd_file.put_line(fnd_file.log,'---- Trans Number--- '||l_pt_avat.trx_number||'-----');
915: fnd_file.put_line(fnd_file.log,'Tax class information: ' || l_pt_avat.tax_class);
916: fnd_file.put_line(fnd_file.log,'Tax Recovery Rate: ' ||l_pt_avat.tax_recv_rate);
917: fnd_file.put_line(fnd_file.log,'Tax Recoverable Flag : '||l_pt_avat.tax_recoverable_flag);
918: fnd_file.put_line(fnd_file.log,'Taxable box: ' ||l_pt_avat.txbl_nrc_box);
919: fnd_file.put_line(fnd_file.log,'Taxable amount: ' ||l_pt_avat.txbl_nrc_amount);
920: fnd_file.put_line(fnd_file.log,'Tax box: ' || l_pt_avat.tax_box);
921: fnd_file.put_line(fnd_file.log,'Tax Amount: '||l_pt_avat.tax_amount);
914: fnd_file.put_line(fnd_file.log,'---- Trans Number--- '||l_pt_avat.trx_number||'-----');
915: fnd_file.put_line(fnd_file.log,'Tax class information: ' || l_pt_avat.tax_class);
916: fnd_file.put_line(fnd_file.log,'Tax Recovery Rate: ' ||l_pt_avat.tax_recv_rate);
917: fnd_file.put_line(fnd_file.log,'Tax Recoverable Flag : '||l_pt_avat.tax_recoverable_flag);
918: fnd_file.put_line(fnd_file.log,'Taxable box: ' ||l_pt_avat.txbl_nrc_box);
919: fnd_file.put_line(fnd_file.log,'Taxable amount: ' ||l_pt_avat.txbl_nrc_amount);
920: fnd_file.put_line(fnd_file.log,'Tax box: ' || l_pt_avat.tax_box);
921: fnd_file.put_line(fnd_file.log,'Tax Amount: '||l_pt_avat.tax_amount);
922: fnd_file.put_line(fnd_file.log,'Total box: '|| l_pt_avat.total_box);
915: fnd_file.put_line(fnd_file.log,'Tax class information: ' || l_pt_avat.tax_class);
916: fnd_file.put_line(fnd_file.log,'Tax Recovery Rate: ' ||l_pt_avat.tax_recv_rate);
917: fnd_file.put_line(fnd_file.log,'Tax Recoverable Flag : '||l_pt_avat.tax_recoverable_flag);
918: fnd_file.put_line(fnd_file.log,'Taxable box: ' ||l_pt_avat.txbl_nrc_box);
919: fnd_file.put_line(fnd_file.log,'Taxable amount: ' ||l_pt_avat.txbl_nrc_amount);
920: fnd_file.put_line(fnd_file.log,'Tax box: ' || l_pt_avat.tax_box);
921: fnd_file.put_line(fnd_file.log,'Tax Amount: '||l_pt_avat.tax_amount);
922: fnd_file.put_line(fnd_file.log,'Total box: '|| l_pt_avat.total_box);
923: fnd_file.put_line(fnd_file.log,'Tax rate: ' || l_pt_avat.tax_rate);
916: fnd_file.put_line(fnd_file.log,'Tax Recovery Rate: ' ||l_pt_avat.tax_recv_rate);
917: fnd_file.put_line(fnd_file.log,'Tax Recoverable Flag : '||l_pt_avat.tax_recoverable_flag);
918: fnd_file.put_line(fnd_file.log,'Taxable box: ' ||l_pt_avat.txbl_nrc_box);
919: fnd_file.put_line(fnd_file.log,'Taxable amount: ' ||l_pt_avat.txbl_nrc_amount);
920: fnd_file.put_line(fnd_file.log,'Tax box: ' || l_pt_avat.tax_box);
921: fnd_file.put_line(fnd_file.log,'Tax Amount: '||l_pt_avat.tax_amount);
922: fnd_file.put_line(fnd_file.log,'Total box: '|| l_pt_avat.total_box);
923: fnd_file.put_line(fnd_file.log,'Tax rate: ' || l_pt_avat.tax_rate);
924: fnd_file.put_line(fnd_file.log,'Tax code: ' || l_pt_avat.tax_code_rate);
917: fnd_file.put_line(fnd_file.log,'Tax Recoverable Flag : '||l_pt_avat.tax_recoverable_flag);
918: fnd_file.put_line(fnd_file.log,'Taxable box: ' ||l_pt_avat.txbl_nrc_box);
919: fnd_file.put_line(fnd_file.log,'Taxable amount: ' ||l_pt_avat.txbl_nrc_amount);
920: fnd_file.put_line(fnd_file.log,'Tax box: ' || l_pt_avat.tax_box);
921: fnd_file.put_line(fnd_file.log,'Tax Amount: '||l_pt_avat.tax_amount);
922: fnd_file.put_line(fnd_file.log,'Total box: '|| l_pt_avat.total_box);
923: fnd_file.put_line(fnd_file.log,'Tax rate: ' || l_pt_avat.tax_rate);
924: fnd_file.put_line(fnd_file.log,'Tax code: ' || l_pt_avat.tax_code_rate);
925: fnd_file.put_line(fnd_file.log,'Extract Source Ledger: ' || l_pt_avat.extract_source_ledger);
918: fnd_file.put_line(fnd_file.log,'Taxable box: ' ||l_pt_avat.txbl_nrc_box);
919: fnd_file.put_line(fnd_file.log,'Taxable amount: ' ||l_pt_avat.txbl_nrc_amount);
920: fnd_file.put_line(fnd_file.log,'Tax box: ' || l_pt_avat.tax_box);
921: fnd_file.put_line(fnd_file.log,'Tax Amount: '||l_pt_avat.tax_amount);
922: fnd_file.put_line(fnd_file.log,'Total box: '|| l_pt_avat.total_box);
923: fnd_file.put_line(fnd_file.log,'Tax rate: ' || l_pt_avat.tax_rate);
924: fnd_file.put_line(fnd_file.log,'Tax code: ' || l_pt_avat.tax_code_rate);
925: fnd_file.put_line(fnd_file.log,'Extract Source Ledger: ' || l_pt_avat.extract_source_ledger);
926: fnd_file.put_line(fnd_file.log,'Allocation Rule ID: ' || l_pt_avat.allocation_rule_id);
919: fnd_file.put_line(fnd_file.log,'Taxable amount: ' ||l_pt_avat.txbl_nrc_amount);
920: fnd_file.put_line(fnd_file.log,'Tax box: ' || l_pt_avat.tax_box);
921: fnd_file.put_line(fnd_file.log,'Tax Amount: '||l_pt_avat.tax_amount);
922: fnd_file.put_line(fnd_file.log,'Total box: '|| l_pt_avat.total_box);
923: fnd_file.put_line(fnd_file.log,'Tax rate: ' || l_pt_avat.tax_rate);
924: fnd_file.put_line(fnd_file.log,'Tax code: ' || l_pt_avat.tax_code_rate);
925: fnd_file.put_line(fnd_file.log,'Extract Source Ledger: ' || l_pt_avat.extract_source_ledger);
926: fnd_file.put_line(fnd_file.log,'Allocation Rule ID: ' || l_pt_avat.allocation_rule_id);
927:
920: fnd_file.put_line(fnd_file.log,'Tax box: ' || l_pt_avat.tax_box);
921: fnd_file.put_line(fnd_file.log,'Tax Amount: '||l_pt_avat.tax_amount);
922: fnd_file.put_line(fnd_file.log,'Total box: '|| l_pt_avat.total_box);
923: fnd_file.put_line(fnd_file.log,'Tax rate: ' || l_pt_avat.tax_rate);
924: fnd_file.put_line(fnd_file.log,'Tax code: ' || l_pt_avat.tax_code_rate);
925: fnd_file.put_line(fnd_file.log,'Extract Source Ledger: ' || l_pt_avat.extract_source_ledger);
926: fnd_file.put_line(fnd_file.log,'Allocation Rule ID: ' || l_pt_avat.allocation_rule_id);
927:
928: END IF;
921: fnd_file.put_line(fnd_file.log,'Tax Amount: '||l_pt_avat.tax_amount);
922: fnd_file.put_line(fnd_file.log,'Total box: '|| l_pt_avat.total_box);
923: fnd_file.put_line(fnd_file.log,'Tax rate: ' || l_pt_avat.tax_rate);
924: fnd_file.put_line(fnd_file.log,'Tax code: ' || l_pt_avat.tax_code_rate);
925: fnd_file.put_line(fnd_file.log,'Extract Source Ledger: ' || l_pt_avat.extract_source_ledger);
926: fnd_file.put_line(fnd_file.log,'Allocation Rule ID: ' || l_pt_avat.allocation_rule_id);
927:
928: END IF;
929:
922: fnd_file.put_line(fnd_file.log,'Total box: '|| l_pt_avat.total_box);
923: fnd_file.put_line(fnd_file.log,'Tax rate: ' || l_pt_avat.tax_rate);
924: fnd_file.put_line(fnd_file.log,'Tax code: ' || l_pt_avat.tax_code_rate);
925: fnd_file.put_line(fnd_file.log,'Extract Source Ledger: ' || l_pt_avat.extract_source_ledger);
926: fnd_file.put_line(fnd_file.log,'Allocation Rule ID: ' || l_pt_avat.allocation_rule_id);
927:
928: END IF;
929:
930: END LOOP;
932: IF l_data_found = 'Y' THEN
933: FOR i in v_box_amounts.FIRST .. v_box_amounts.LAST LOOP
934:
935: IF p_debug_flag = 'Y' and v_box_amounts.EXISTS(i) and i <> 1000 THEN
936: fnd_file.put_line(fnd_file.log,'-----------------------------------');
937: IF i > 1000 THEN
938: fnd_file.put_line(fnd_file.log,' Box Num =>'||floor(i/10000));
939: ELSE
940: fnd_file.put_line(fnd_file.log,' Box Num =>'||i);
934:
935: IF p_debug_flag = 'Y' and v_box_amounts.EXISTS(i) and i <> 1000 THEN
936: fnd_file.put_line(fnd_file.log,'-----------------------------------');
937: IF i > 1000 THEN
938: fnd_file.put_line(fnd_file.log,' Box Num =>'||floor(i/10000));
939: ELSE
940: fnd_file.put_line(fnd_file.log,' Box Num =>'||i);
941: END IF;
942: fnd_file.put_line(fnd_file.log,' Taxable Amount =>'|| v_box_amounts(i).taxable_amount);
936: fnd_file.put_line(fnd_file.log,'-----------------------------------');
937: IF i > 1000 THEN
938: fnd_file.put_line(fnd_file.log,' Box Num =>'||floor(i/10000));
939: ELSE
940: fnd_file.put_line(fnd_file.log,' Box Num =>'||i);
941: END IF;
942: fnd_file.put_line(fnd_file.log,' Taxable Amount =>'|| v_box_amounts(i).taxable_amount);
943: fnd_file.put_line(fnd_file.log,' Tax Amount =>'|| v_box_amounts(i).tax_amount);
944: fnd_file.put_line(fnd_file.log,' Total Box Number =>'|| v_box_amounts(i).tot_box_num);
938: fnd_file.put_line(fnd_file.log,' Box Num =>'||floor(i/10000));
939: ELSE
940: fnd_file.put_line(fnd_file.log,' Box Num =>'||i);
941: END IF;
942: fnd_file.put_line(fnd_file.log,' Taxable Amount =>'|| v_box_amounts(i).taxable_amount);
943: fnd_file.put_line(fnd_file.log,' Tax Amount =>'|| v_box_amounts(i).tax_amount);
944: fnd_file.put_line(fnd_file.log,' Total Box Number =>'|| v_box_amounts(i).tot_box_num);
945: fnd_file.put_line(fnd_file.log,' Tax Rate =>'|| v_box_amounts(i).tax_rate);
946: fnd_file.put_line(fnd_file.log,'-----------------------------------');
939: ELSE
940: fnd_file.put_line(fnd_file.log,' Box Num =>'||i);
941: END IF;
942: fnd_file.put_line(fnd_file.log,' Taxable Amount =>'|| v_box_amounts(i).taxable_amount);
943: fnd_file.put_line(fnd_file.log,' Tax Amount =>'|| v_box_amounts(i).tax_amount);
944: fnd_file.put_line(fnd_file.log,' Total Box Number =>'|| v_box_amounts(i).tot_box_num);
945: fnd_file.put_line(fnd_file.log,' Tax Rate =>'|| v_box_amounts(i).tax_rate);
946: fnd_file.put_line(fnd_file.log,'-----------------------------------');
947: END IF;
940: fnd_file.put_line(fnd_file.log,' Box Num =>'||i);
941: END IF;
942: fnd_file.put_line(fnd_file.log,' Taxable Amount =>'|| v_box_amounts(i).taxable_amount);
943: fnd_file.put_line(fnd_file.log,' Tax Amount =>'|| v_box_amounts(i).tax_amount);
944: fnd_file.put_line(fnd_file.log,' Total Box Number =>'|| v_box_amounts(i).tot_box_num);
945: fnd_file.put_line(fnd_file.log,' Tax Rate =>'|| v_box_amounts(i).tax_rate);
946: fnd_file.put_line(fnd_file.log,'-----------------------------------');
947: END IF;
948:
941: END IF;
942: fnd_file.put_line(fnd_file.log,' Taxable Amount =>'|| v_box_amounts(i).taxable_amount);
943: fnd_file.put_line(fnd_file.log,' Tax Amount =>'|| v_box_amounts(i).tax_amount);
944: fnd_file.put_line(fnd_file.log,' Total Box Number =>'|| v_box_amounts(i).tot_box_num);
945: fnd_file.put_line(fnd_file.log,' Tax Rate =>'|| v_box_amounts(i).tax_rate);
946: fnd_file.put_line(fnd_file.log,'-----------------------------------');
947: END IF;
948:
949: IF v_box_amounts.EXISTS(i) and i <= 1000 THEN
942: fnd_file.put_line(fnd_file.log,' Taxable Amount =>'|| v_box_amounts(i).taxable_amount);
943: fnd_file.put_line(fnd_file.log,' Tax Amount =>'|| v_box_amounts(i).tax_amount);
944: fnd_file.put_line(fnd_file.log,' Total Box Number =>'|| v_box_amounts(i).tot_box_num);
945: fnd_file.put_line(fnd_file.log,' Tax Rate =>'|| v_box_amounts(i).tax_rate);
946: fnd_file.put_line(fnd_file.log,'-----------------------------------');
947: END IF;
948:
949: IF v_box_amounts.EXISTS(i) and i <= 1000 THEN
950: INSERT INTO jg_zz_vat_trx_gt ( jg_info_n1
979: END IF;
980:
981: select count(*) into l_count from jg_zz_vat_trx_gt ;
982: IF p_debug_flag = 'Y' THEN
983: fnd_file.put_line(fnd_file.log,'Number of records inserted into jg_zz_vat_trx_gt table :' || l_count );
984: END IF ;
985: EXCEPTION
986: WHEN OTHERS THEN
987: fnd_file.put_line(fnd_file.log,'Error in Procedure jg_zz_summary_all_pkg.jeptavat: ' || SUBSTR(SQLERRM,1,200));
983: fnd_file.put_line(fnd_file.log,'Number of records inserted into jg_zz_vat_trx_gt table :' || l_count );
984: END IF ;
985: EXCEPTION
986: WHEN OTHERS THEN
987: fnd_file.put_line(fnd_file.log,'Error in Procedure jg_zz_summary_all_pkg.jeptavat: ' || SUBSTR(SQLERRM,1,200));
988: fnd_file.put_line(fnd_file.log,'Error at statement: ' || ln_stat_no);
989: RAISE;
990: END jeptavat;
991:
984: END IF ;
985: EXCEPTION
986: WHEN OTHERS THEN
987: fnd_file.put_line(fnd_file.log,'Error in Procedure jg_zz_summary_all_pkg.jeptavat: ' || SUBSTR(SQLERRM,1,200));
988: fnd_file.put_line(fnd_file.log,'Error at statement: ' || ln_stat_no);
989: RAISE;
990: END jeptavat;
991:
992: --
1106: END IF;
1107: l_data_found := 'Y';
1108:
1109: IF p_debug_flag = 'Y' THEN
1110: fnd_file.put_line(fnd_file.log,'-----------------------------------');
1111: fnd_file.put_line(fnd_file.log,'---- Trans Id ' || l_pt_periodic_vat.trx_id || '-----');
1112: fnd_file.put_line(fnd_file.log,'---- Trans Number '||l_pt_periodic_vat.trx_number||'-----');
1113: fnd_file.put_line(fnd_file.log,' Tax class information => ' || l_pt_periodic_vat.tax_class);
1114: fnd_file.put_line(fnd_file.log,' Extract Source Ledger => ' ||l_pt_periodic_vat.extract_source_ledger);
1107: l_data_found := 'Y';
1108:
1109: IF p_debug_flag = 'Y' THEN
1110: fnd_file.put_line(fnd_file.log,'-----------------------------------');
1111: fnd_file.put_line(fnd_file.log,'---- Trans Id ' || l_pt_periodic_vat.trx_id || '-----');
1112: fnd_file.put_line(fnd_file.log,'---- Trans Number '||l_pt_periodic_vat.trx_number||'-----');
1113: fnd_file.put_line(fnd_file.log,' Tax class information => ' || l_pt_periodic_vat.tax_class);
1114: fnd_file.put_line(fnd_file.log,' Extract Source Ledger => ' ||l_pt_periodic_vat.extract_source_ledger);
1115: fnd_file.put_line(fnd_file.log,' trx_line_class => ' ||l_pt_periodic_vat.trx_line_class);
1108:
1109: IF p_debug_flag = 'Y' THEN
1110: fnd_file.put_line(fnd_file.log,'-----------------------------------');
1111: fnd_file.put_line(fnd_file.log,'---- Trans Id ' || l_pt_periodic_vat.trx_id || '-----');
1112: fnd_file.put_line(fnd_file.log,'---- Trans Number '||l_pt_periodic_vat.trx_number||'-----');
1113: fnd_file.put_line(fnd_file.log,' Tax class information => ' || l_pt_periodic_vat.tax_class);
1114: fnd_file.put_line(fnd_file.log,' Extract Source Ledger => ' ||l_pt_periodic_vat.extract_source_ledger);
1115: fnd_file.put_line(fnd_file.log,' trx_line_class => ' ||l_pt_periodic_vat.trx_line_class);
1116: fnd_file.put_line(fnd_file.log,' Reporting Code => ' ||l_pt_periodic_vat.reporting_code);
1109: IF p_debug_flag = 'Y' THEN
1110: fnd_file.put_line(fnd_file.log,'-----------------------------------');
1111: fnd_file.put_line(fnd_file.log,'---- Trans Id ' || l_pt_periodic_vat.trx_id || '-----');
1112: fnd_file.put_line(fnd_file.log,'---- Trans Number '||l_pt_periodic_vat.trx_number||'-----');
1113: fnd_file.put_line(fnd_file.log,' Tax class information => ' || l_pt_periodic_vat.tax_class);
1114: fnd_file.put_line(fnd_file.log,' Extract Source Ledger => ' ||l_pt_periodic_vat.extract_source_ledger);
1115: fnd_file.put_line(fnd_file.log,' trx_line_class => ' ||l_pt_periodic_vat.trx_line_class);
1116: fnd_file.put_line(fnd_file.log,' Reporting Code => ' ||l_pt_periodic_vat.reporting_code);
1117: fnd_file.put_line(fnd_file.log,' Trx Taxable Amount =>'|| l_pt_periodic_vat.taxable_amount);
1110: fnd_file.put_line(fnd_file.log,'-----------------------------------');
1111: fnd_file.put_line(fnd_file.log,'---- Trans Id ' || l_pt_periodic_vat.trx_id || '-----');
1112: fnd_file.put_line(fnd_file.log,'---- Trans Number '||l_pt_periodic_vat.trx_number||'-----');
1113: fnd_file.put_line(fnd_file.log,' Tax class information => ' || l_pt_periodic_vat.tax_class);
1114: fnd_file.put_line(fnd_file.log,' Extract Source Ledger => ' ||l_pt_periodic_vat.extract_source_ledger);
1115: fnd_file.put_line(fnd_file.log,' trx_line_class => ' ||l_pt_periodic_vat.trx_line_class);
1116: fnd_file.put_line(fnd_file.log,' Reporting Code => ' ||l_pt_periodic_vat.reporting_code);
1117: fnd_file.put_line(fnd_file.log,' Trx Taxable Amount =>'|| l_pt_periodic_vat.taxable_amount);
1118: fnd_file.put_line(fnd_file.log,' Trx Deduct Tax Amount=>'|| l_pt_periodic_vat.deduct_tax);
1111: fnd_file.put_line(fnd_file.log,'---- Trans Id ' || l_pt_periodic_vat.trx_id || '-----');
1112: fnd_file.put_line(fnd_file.log,'---- Trans Number '||l_pt_periodic_vat.trx_number||'-----');
1113: fnd_file.put_line(fnd_file.log,' Tax class information => ' || l_pt_periodic_vat.tax_class);
1114: fnd_file.put_line(fnd_file.log,' Extract Source Ledger => ' ||l_pt_periodic_vat.extract_source_ledger);
1115: fnd_file.put_line(fnd_file.log,' trx_line_class => ' ||l_pt_periodic_vat.trx_line_class);
1116: fnd_file.put_line(fnd_file.log,' Reporting Code => ' ||l_pt_periodic_vat.reporting_code);
1117: fnd_file.put_line(fnd_file.log,' Trx Taxable Amount =>'|| l_pt_periodic_vat.taxable_amount);
1118: fnd_file.put_line(fnd_file.log,' Trx Deduct Tax Amount=>'|| l_pt_periodic_vat.deduct_tax);
1119: fnd_file.put_line(fnd_file.log,' Trx Clear Tax Amount =>'|| l_pt_periodic_vat.clear_tax);
1112: fnd_file.put_line(fnd_file.log,'---- Trans Number '||l_pt_periodic_vat.trx_number||'-----');
1113: fnd_file.put_line(fnd_file.log,' Tax class information => ' || l_pt_periodic_vat.tax_class);
1114: fnd_file.put_line(fnd_file.log,' Extract Source Ledger => ' ||l_pt_periodic_vat.extract_source_ledger);
1115: fnd_file.put_line(fnd_file.log,' trx_line_class => ' ||l_pt_periodic_vat.trx_line_class);
1116: fnd_file.put_line(fnd_file.log,' Reporting Code => ' ||l_pt_periodic_vat.reporting_code);
1117: fnd_file.put_line(fnd_file.log,' Trx Taxable Amount =>'|| l_pt_periodic_vat.taxable_amount);
1118: fnd_file.put_line(fnd_file.log,' Trx Deduct Tax Amount=>'|| l_pt_periodic_vat.deduct_tax);
1119: fnd_file.put_line(fnd_file.log,' Trx Clear Tax Amount =>'|| l_pt_periodic_vat.clear_tax);
1120: fnd_file.put_line(fnd_file.log,' Taxable Box => '|| l_pt_periodic_vat.taxable_box);
1113: fnd_file.put_line(fnd_file.log,' Tax class information => ' || l_pt_periodic_vat.tax_class);
1114: fnd_file.put_line(fnd_file.log,' Extract Source Ledger => ' ||l_pt_periodic_vat.extract_source_ledger);
1115: fnd_file.put_line(fnd_file.log,' trx_line_class => ' ||l_pt_periodic_vat.trx_line_class);
1116: fnd_file.put_line(fnd_file.log,' Reporting Code => ' ||l_pt_periodic_vat.reporting_code);
1117: fnd_file.put_line(fnd_file.log,' Trx Taxable Amount =>'|| l_pt_periodic_vat.taxable_amount);
1118: fnd_file.put_line(fnd_file.log,' Trx Deduct Tax Amount=>'|| l_pt_periodic_vat.deduct_tax);
1119: fnd_file.put_line(fnd_file.log,' Trx Clear Tax Amount =>'|| l_pt_periodic_vat.clear_tax);
1120: fnd_file.put_line(fnd_file.log,' Taxable Box => '|| l_pt_periodic_vat.taxable_box);
1121: fnd_file.put_line(fnd_file.log,' Taxable Amt => ' ||v_box_amounts(l_pt_periodic_vat.taxable_box).taxable_amount);
1114: fnd_file.put_line(fnd_file.log,' Extract Source Ledger => ' ||l_pt_periodic_vat.extract_source_ledger);
1115: fnd_file.put_line(fnd_file.log,' trx_line_class => ' ||l_pt_periodic_vat.trx_line_class);
1116: fnd_file.put_line(fnd_file.log,' Reporting Code => ' ||l_pt_periodic_vat.reporting_code);
1117: fnd_file.put_line(fnd_file.log,' Trx Taxable Amount =>'|| l_pt_periodic_vat.taxable_amount);
1118: fnd_file.put_line(fnd_file.log,' Trx Deduct Tax Amount=>'|| l_pt_periodic_vat.deduct_tax);
1119: fnd_file.put_line(fnd_file.log,' Trx Clear Tax Amount =>'|| l_pt_periodic_vat.clear_tax);
1120: fnd_file.put_line(fnd_file.log,' Taxable Box => '|| l_pt_periodic_vat.taxable_box);
1121: fnd_file.put_line(fnd_file.log,' Taxable Amt => ' ||v_box_amounts(l_pt_periodic_vat.taxable_box).taxable_amount);
1122: fnd_file.put_line(fnd_file.log,' Tax Box => ' ||l_pt_periodic_vat.tax_box);
1115: fnd_file.put_line(fnd_file.log,' trx_line_class => ' ||l_pt_periodic_vat.trx_line_class);
1116: fnd_file.put_line(fnd_file.log,' Reporting Code => ' ||l_pt_periodic_vat.reporting_code);
1117: fnd_file.put_line(fnd_file.log,' Trx Taxable Amount =>'|| l_pt_periodic_vat.taxable_amount);
1118: fnd_file.put_line(fnd_file.log,' Trx Deduct Tax Amount=>'|| l_pt_periodic_vat.deduct_tax);
1119: fnd_file.put_line(fnd_file.log,' Trx Clear Tax Amount =>'|| l_pt_periodic_vat.clear_tax);
1120: fnd_file.put_line(fnd_file.log,' Taxable Box => '|| l_pt_periodic_vat.taxable_box);
1121: fnd_file.put_line(fnd_file.log,' Taxable Amt => ' ||v_box_amounts(l_pt_periodic_vat.taxable_box).taxable_amount);
1122: fnd_file.put_line(fnd_file.log,' Tax Box => ' ||l_pt_periodic_vat.tax_box);
1123: fnd_file.put_line(fnd_file.log,' Deduct Amt => ' ||v_box_amounts(l_pt_periodic_vat.tax_box).deduct_tax);
1116: fnd_file.put_line(fnd_file.log,' Reporting Code => ' ||l_pt_periodic_vat.reporting_code);
1117: fnd_file.put_line(fnd_file.log,' Trx Taxable Amount =>'|| l_pt_periodic_vat.taxable_amount);
1118: fnd_file.put_line(fnd_file.log,' Trx Deduct Tax Amount=>'|| l_pt_periodic_vat.deduct_tax);
1119: fnd_file.put_line(fnd_file.log,' Trx Clear Tax Amount =>'|| l_pt_periodic_vat.clear_tax);
1120: fnd_file.put_line(fnd_file.log,' Taxable Box => '|| l_pt_periodic_vat.taxable_box);
1121: fnd_file.put_line(fnd_file.log,' Taxable Amt => ' ||v_box_amounts(l_pt_periodic_vat.taxable_box).taxable_amount);
1122: fnd_file.put_line(fnd_file.log,' Tax Box => ' ||l_pt_periodic_vat.tax_box);
1123: fnd_file.put_line(fnd_file.log,' Deduct Amt => ' ||v_box_amounts(l_pt_periodic_vat.tax_box).deduct_tax);
1124: fnd_file.put_line(fnd_file.log,' Clear Amt => ' ||v_box_amounts(l_pt_periodic_vat.tax_box).clear_tax);
1117: fnd_file.put_line(fnd_file.log,' Trx Taxable Amount =>'|| l_pt_periodic_vat.taxable_amount);
1118: fnd_file.put_line(fnd_file.log,' Trx Deduct Tax Amount=>'|| l_pt_periodic_vat.deduct_tax);
1119: fnd_file.put_line(fnd_file.log,' Trx Clear Tax Amount =>'|| l_pt_periodic_vat.clear_tax);
1120: fnd_file.put_line(fnd_file.log,' Taxable Box => '|| l_pt_periodic_vat.taxable_box);
1121: fnd_file.put_line(fnd_file.log,' Taxable Amt => ' ||v_box_amounts(l_pt_periodic_vat.taxable_box).taxable_amount);
1122: fnd_file.put_line(fnd_file.log,' Tax Box => ' ||l_pt_periodic_vat.tax_box);
1123: fnd_file.put_line(fnd_file.log,' Deduct Amt => ' ||v_box_amounts(l_pt_periodic_vat.tax_box).deduct_tax);
1124: fnd_file.put_line(fnd_file.log,' Clear Amt => ' ||v_box_amounts(l_pt_periodic_vat.tax_box).clear_tax);
1125: fnd_file.put_line(fnd_file.log,' Tax Recoverable Flag => ' || l_pt_periodic_vat.tax_recoverable_flag);
1118: fnd_file.put_line(fnd_file.log,' Trx Deduct Tax Amount=>'|| l_pt_periodic_vat.deduct_tax);
1119: fnd_file.put_line(fnd_file.log,' Trx Clear Tax Amount =>'|| l_pt_periodic_vat.clear_tax);
1120: fnd_file.put_line(fnd_file.log,' Taxable Box => '|| l_pt_periodic_vat.taxable_box);
1121: fnd_file.put_line(fnd_file.log,' Taxable Amt => ' ||v_box_amounts(l_pt_periodic_vat.taxable_box).taxable_amount);
1122: fnd_file.put_line(fnd_file.log,' Tax Box => ' ||l_pt_periodic_vat.tax_box);
1123: fnd_file.put_line(fnd_file.log,' Deduct Amt => ' ||v_box_amounts(l_pt_periodic_vat.tax_box).deduct_tax);
1124: fnd_file.put_line(fnd_file.log,' Clear Amt => ' ||v_box_amounts(l_pt_periodic_vat.tax_box).clear_tax);
1125: fnd_file.put_line(fnd_file.log,' Tax Recoverable Flag => ' || l_pt_periodic_vat.tax_recoverable_flag);
1126: fnd_file.put_line(fnd_file.log,'-----------------------------------');
1119: fnd_file.put_line(fnd_file.log,' Trx Clear Tax Amount =>'|| l_pt_periodic_vat.clear_tax);
1120: fnd_file.put_line(fnd_file.log,' Taxable Box => '|| l_pt_periodic_vat.taxable_box);
1121: fnd_file.put_line(fnd_file.log,' Taxable Amt => ' ||v_box_amounts(l_pt_periodic_vat.taxable_box).taxable_amount);
1122: fnd_file.put_line(fnd_file.log,' Tax Box => ' ||l_pt_periodic_vat.tax_box);
1123: fnd_file.put_line(fnd_file.log,' Deduct Amt => ' ||v_box_amounts(l_pt_periodic_vat.tax_box).deduct_tax);
1124: fnd_file.put_line(fnd_file.log,' Clear Amt => ' ||v_box_amounts(l_pt_periodic_vat.tax_box).clear_tax);
1125: fnd_file.put_line(fnd_file.log,' Tax Recoverable Flag => ' || l_pt_periodic_vat.tax_recoverable_flag);
1126: fnd_file.put_line(fnd_file.log,'-----------------------------------');
1127: END IF;
1120: fnd_file.put_line(fnd_file.log,' Taxable Box => '|| l_pt_periodic_vat.taxable_box);
1121: fnd_file.put_line(fnd_file.log,' Taxable Amt => ' ||v_box_amounts(l_pt_periodic_vat.taxable_box).taxable_amount);
1122: fnd_file.put_line(fnd_file.log,' Tax Box => ' ||l_pt_periodic_vat.tax_box);
1123: fnd_file.put_line(fnd_file.log,' Deduct Amt => ' ||v_box_amounts(l_pt_periodic_vat.tax_box).deduct_tax);
1124: fnd_file.put_line(fnd_file.log,' Clear Amt => ' ||v_box_amounts(l_pt_periodic_vat.tax_box).clear_tax);
1125: fnd_file.put_line(fnd_file.log,' Tax Recoverable Flag => ' || l_pt_periodic_vat.tax_recoverable_flag);
1126: fnd_file.put_line(fnd_file.log,'-----------------------------------');
1127: END IF;
1128: END LOOP;
1121: fnd_file.put_line(fnd_file.log,' Taxable Amt => ' ||v_box_amounts(l_pt_periodic_vat.taxable_box).taxable_amount);
1122: fnd_file.put_line(fnd_file.log,' Tax Box => ' ||l_pt_periodic_vat.tax_box);
1123: fnd_file.put_line(fnd_file.log,' Deduct Amt => ' ||v_box_amounts(l_pt_periodic_vat.tax_box).deduct_tax);
1124: fnd_file.put_line(fnd_file.log,' Clear Amt => ' ||v_box_amounts(l_pt_periodic_vat.tax_box).clear_tax);
1125: fnd_file.put_line(fnd_file.log,' Tax Recoverable Flag => ' || l_pt_periodic_vat.tax_recoverable_flag);
1126: fnd_file.put_line(fnd_file.log,'-----------------------------------');
1127: END IF;
1128: END LOOP;
1129:
1122: fnd_file.put_line(fnd_file.log,' Tax Box => ' ||l_pt_periodic_vat.tax_box);
1123: fnd_file.put_line(fnd_file.log,' Deduct Amt => ' ||v_box_amounts(l_pt_periodic_vat.tax_box).deduct_tax);
1124: fnd_file.put_line(fnd_file.log,' Clear Amt => ' ||v_box_amounts(l_pt_periodic_vat.tax_box).clear_tax);
1125: fnd_file.put_line(fnd_file.log,' Tax Recoverable Flag => ' || l_pt_periodic_vat.tax_recoverable_flag);
1126: fnd_file.put_line(fnd_file.log,'-----------------------------------');
1127: END IF;
1128: END LOOP;
1129:
1130: IF l_data_found = 'Y' THEN
1150: END IF;
1151:
1152: SELECT count(*) into l_count from jg_zz_vat_trx_gt ;
1153: IF p_debug_flag = 'Y' THEN
1154: fnd_file.put_line(fnd_file.log,'Number of records inserted into jg_zz_vat_trx_gt table: ' || l_count );
1155: END IF ;
1156:
1157: EXCEPTION
1158: WHEN OTHERS THEN
1155: END IF ;
1156:
1157: EXCEPTION
1158: WHEN OTHERS THEN
1159: fnd_file.put_line(fnd_file.log,'Error in Procedure jg_zz_summary_all_pkg.jeptpvat ' || SUBSTR(SQLERRM,1,200));
1160: RAISE;
1161: END jeptpvat;
1162:
1163: --
1292: END LOOP;
1293:
1294: SELECT count(*) into l_count from jg_zz_vat_trx_gt ;
1295: IF p_debug_flag = 'Y' THEN
1296: fnd_file.put_line(fnd_file.log,'Number of records inserted into jg_zz_vat_trx_gt table: ' || l_count );
1297: END IF ;
1298:
1299: EXCEPTION
1300: WHEN OTHERS THEN
1297: END IF ;
1298:
1299: EXCEPTION
1300: WHEN OTHERS THEN
1301: fnd_file.put_line(fnd_file.log,'Error in Procedure jg_zz_summary_all_pkg.jeitpssr ' || SUBSTR(SQLERRM,1,200));
1302: RAISE;
1303: END jeitpssr;
1304:
1305: FUNCTION a_real_tax_amount(p_payment_amt IN NUMBER
1309: tax_amount NUMBER;
1310: l_total_invoice NUMBER;
1311: BEGIN
1312: IF p_debug_flag = 'Y' THEN
1313: fnd_file.put_line(fnd_file.log,' p_payment_amt =>'||p_payment_amt);
1314: END IF;
1315: IF p_payment_amt = 0 THEN
1316: /****************************************
1317: tax_amount := tax_amount;
1329: tax_amount := p_payment_amt*(p_tax_amount/nvl(l_total_invoice, 1));
1330: END IF;
1331: END IF;
1332: IF p_debug_flag = 'Y' THEN
1333: fnd_file.put_line(fnd_file.log,' tax_amount =>'||tax_amount);
1334: END IF;
1335: RETURN(tax_amount);
1336: EXCEPTION
1337: WHEN OTHERS THEN
1334: END IF;
1335: RETURN(tax_amount);
1336: EXCEPTION
1337: WHEN OTHERS THEN
1338: fnd_file.put_line(fnd_file.log,'Error in Procedure jg_zz_summary_all_pkg.a_real_tax_amount ' || SUBSTR(SQLERRM,1,200));
1339: RAISE;
1340: END a_real_tax_amount;
1341:
1342: FUNCTION a_real_invoice_amount(p_payment_amt IN NUMBER
1359: END IF;
1360: RETURN(invoice_amount);
1361: EXCEPTION
1362: WHEN OTHERS THEN
1363: fnd_file.put_line(fnd_file.log,'Error in Procedure jg_zz_summary_all_pkg.a_real_invoice_amount ' || SUBSTR(SQLERRM,1,200));
1364: RAISE;
1365: END a_real_invoice_amount;
1366:
1367: FUNCTION a_total_invoices(p_cust_trx_id IN NUMBER)
1387: END IF;
1388: RETURN(invoice_values);
1389: EXCEPTION
1390: WHEN OTHERS THEN
1391: fnd_file.put_line(fnd_file.log,'Error in Procedure jg_zz_summary_all_pkg.a_total_invoices ' || SUBSTR(SQLERRM,1,200));
1392: RAISE;
1393: END a_total_invoices;
1394:
1395: FUNCTION get_report_format
1408: RETURN NULL;
1409: END IF;
1410: EXCEPTION
1411: WHEN NO_DATA_FOUND then
1412: fnd_file.put_line(fnd_file.log,'Error while fetching Meaning for Lookup Type JEBE_REPORT_FORMAT' || SUBSTR(SQLERRM,1,200));
1413: l_detail_summary := P_REPORT_FORMAT;
1414: RETURN l_detail_summary;
1415: WHEN OTHERS then
1416: fnd_file.put_line(fnd_file.log,'Error while fetching Meaning for Lookup Type JEBE_REPORT_FORMAT' || SUBSTR(SQLERRM,1,200));
1412: fnd_file.put_line(fnd_file.log,'Error while fetching Meaning for Lookup Type JEBE_REPORT_FORMAT' || SUBSTR(SQLERRM,1,200));
1413: l_detail_summary := P_REPORT_FORMAT;
1414: RETURN l_detail_summary;
1415: WHEN OTHERS then
1416: fnd_file.put_line(fnd_file.log,'Error while fetching Meaning for Lookup Type JEBE_REPORT_FORMAT' || SUBSTR(SQLERRM,1,200));
1417: l_detail_summary := P_REPORT_FORMAT;
1418: RETURN l_detail_summary;
1419: END get_report_format;
1420:
1435: END IF;
1436: RETURN l_location_name;
1437: EXCEPTION
1438: WHEN NO_DATA_FOUND THEN
1439: fnd_file.put_line(fnd_file.log,'Location Name for Location Code ' || P_LOCATION || ' is not found');
1440: l_location_name := P_LOCATION;
1441: RETURN l_location_name;
1442: WHEN OTHERS THEN
1443: fnd_file.put_line(fnd_file.log,'Error while fetching Location Name' || SUBSTR(SQLERRM,1,200));
1439: fnd_file.put_line(fnd_file.log,'Location Name for Location Code ' || P_LOCATION || ' is not found');
1440: l_location_name := P_LOCATION;
1441: RETURN l_location_name;
1442: WHEN OTHERS THEN
1443: fnd_file.put_line(fnd_file.log,'Error while fetching Location Name' || SUBSTR(SQLERRM,1,200));
1444: l_location_name := P_LOCATION;
1445: RETURN l_location_name;
1446: END;
1447:
1459: AND JIY.month = fl.lookup_code
1460: AND JIY.year = to_char(P_PERIOD,'RRRR')
1461: AND JIY.month = to_char(P_PERIOD,'MM')
1462: AND JIY.legal_entity_id = P_LEGAL_ENTITY_ID ;
1463: fnd_file.put_line(fnd_file.log,'Starting Exemption Limit for Period => : '||l_starting_limit);
1464: RETURN l_starting_limit;
1465: EXCEPTION
1466: WHEN NO_DATA_FOUND THEN
1467: fnd_file.put_line(fnd_file.log,'Exeption Amount for beginning of Period not found' || SUBSTR(SQLERRM,1,200));
1463: fnd_file.put_line(fnd_file.log,'Starting Exemption Limit for Period => : '||l_starting_limit);
1464: RETURN l_starting_limit;
1465: EXCEPTION
1466: WHEN NO_DATA_FOUND THEN
1467: fnd_file.put_line(fnd_file.log,'Exeption Amount for beginning of Period not found' || SUBSTR(SQLERRM,1,200));
1468: RETURN 0;
1469: WHEN OTHERS THEN
1470: fnd_file.put_line(fnd_file.log,'Error while fetching Available Exemption at Beginning of Period ' || SUBSTR(SQLERRM,1,200));
1471: RETURN 0;
1466: WHEN NO_DATA_FOUND THEN
1467: fnd_file.put_line(fnd_file.log,'Exeption Amount for beginning of Period not found' || SUBSTR(SQLERRM,1,200));
1468: RETURN 0;
1469: WHEN OTHERS THEN
1470: fnd_file.put_line(fnd_file.log,'Error while fetching Available Exemption at Beginning of Period ' || SUBSTR(SQLERRM,1,200));
1471: RETURN 0;
1472: END get_start_exempt_limit;
1473:
1474: FUNCTION get_adjustment_exempt_limit
1482: FROM je_it_year_ex_limit JIY
1483: WHERE JIY.year = to_char(P_PERIOD,'RRRR')
1484: AND JIY.month = to_char(P_PERIOD,'MM')
1485: AND JIY.legal_entity_id = P_LEGAL_ENTITY_ID ;
1486: fnd_file.put_line(fnd_file.log,'Adjustment Amount =>: '||l_adjustment_limit);
1487: RETURN l_adjustment_limit;
1488: EXCEPTION
1489: WHEN NO_DATA_FOUND THEN
1490: fnd_file.put_line(fnd_file.log,'Adjustments Yearly Exemption Limit not found' || SUBSTR(SQLERRM,1,200));
1486: fnd_file.put_line(fnd_file.log,'Adjustment Amount =>: '||l_adjustment_limit);
1487: RETURN l_adjustment_limit;
1488: EXCEPTION
1489: WHEN NO_DATA_FOUND THEN
1490: fnd_file.put_line(fnd_file.log,'Adjustments Yearly Exemption Limit not found' || SUBSTR(SQLERRM,1,200));
1491: RETURN 0;
1492: WHEN OTHERS THEN
1493: fnd_file.put_line(fnd_file.log,'Error while getting Adjustment to Yearly Exemption Limit ' || SUBSTR(SQLERRM,1,200));
1494: RETURN 0;
1489: WHEN NO_DATA_FOUND THEN
1490: fnd_file.put_line(fnd_file.log,'Adjustments Yearly Exemption Limit not found' || SUBSTR(SQLERRM,1,200));
1491: RETURN 0;
1492: WHEN OTHERS THEN
1493: fnd_file.put_line(fnd_file.log,'Error while getting Adjustment to Yearly Exemption Limit ' || SUBSTR(SQLERRM,1,200));
1494: RETURN 0;
1495: END get_adjustment_exempt_limit;
1496:
1497: FUNCTION get_old_debit_vat
1502: -- This is used by the XML Element OLD_DEBIT_VAT
1503: RETURN 0;
1504: EXCEPTION
1505: WHEN OTHERS THEN
1506: fnd_file.put_line(fnd_file.log,'Error while getting Previous Period VAT Credit ' || SUBSTR(SQLERRM,1,200));
1507: RETURN 0;
1508: END get_old_debit_vat;
1509:
1510: FUNCTION JEITPSSR_AMOUNT_TO_PAY(A_TOT_TOT_TAX_AMT_SUM IN NUMBER,
1661: RETURN(AMOUNT_TO_PAY);
1662:
1663: EXCEPTION
1664: WHEN INVALID_CARRY_OVER THEN
1665: fnd_file.put_line(fnd_file.log,LOG_MESSAGE);
1666: raise_application_error(-20010,LOG_MESSAGE);
1667: WHEN OTHERS THEN
1668: fnd_file.put_line(fnd_file.log,'Error in Procedure jg_zz_summary_all_pkg.JEITPSSR_AMOUNT_TO_PAY ' || SUBSTR(SQLERRM,1,200));
1669: raise_application_error(-20011,'Error in Procedure jg_zz_summary_all_pkg.JEITPSSR_AMOUNT_TO_PAY ' || SUBSTR(SQLERRM,1,200));
1664: WHEN INVALID_CARRY_OVER THEN
1665: fnd_file.put_line(fnd_file.log,LOG_MESSAGE);
1666: raise_application_error(-20010,LOG_MESSAGE);
1667: WHEN OTHERS THEN
1668: fnd_file.put_line(fnd_file.log,'Error in Procedure jg_zz_summary_all_pkg.JEITPSSR_AMOUNT_TO_PAY ' || SUBSTR(SQLERRM,1,200));
1669: raise_application_error(-20011,'Error in Procedure jg_zz_summary_all_pkg.JEITPSSR_AMOUNT_TO_PAY ' || SUBSTR(SQLERRM,1,200));
1670: END JEITPSSR_AMOUNT_TO_PAY;
1671:
1672: /****Added below function JEITPSSR_AMOUNT_TO_PAY_UPDATE for bug 7633948***/
1709: END IF;
1710: RETURN (TRUE);
1711: EXCEPTION
1712: -- WHEN INVALID_CARRY_OVER THEN
1713: -- fnd_file.put_line(fnd_file.log,LOG_MESSAGE);
1714: WHEN OTHERS THEN
1715: fnd_file.put_line(fnd_file.log,'Error in Procedure jg_zz_summary_all_pkg.JEITPSSR_AMOUNT_TO_PAY_UPDATE ' || SUBSTR(SQLERRM,1,200));
1716: RETURN (FALSE);
1717: END JEITPSSR_AMOUNT_TO_PAY_UPDATE;
1711: EXCEPTION
1712: -- WHEN INVALID_CARRY_OVER THEN
1713: -- fnd_file.put_line(fnd_file.log,LOG_MESSAGE);
1714: WHEN OTHERS THEN
1715: fnd_file.put_line(fnd_file.log,'Error in Procedure jg_zz_summary_all_pkg.JEITPSSR_AMOUNT_TO_PAY_UPDATE ' || SUBSTR(SQLERRM,1,200));
1716: RETURN (FALSE);
1717: END JEITPSSR_AMOUNT_TO_PAY_UPDATE;
1718:
1719: /******Added the below function JEILR835 INV_NUM for Bug 7427956*********/