eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JG_ZZ_SUMMARY_ALL_PKG dependencies on FND_FILE

Line 231: fnd_file.put_line(fnd_file.log,' * Report Parameters * ');

227:
228: BEGIN
229: EXECUTE IMMEDIATE 'alter session set optimizer_features_enable=''10.1.0.5'''; ----Bug 12359827
230: IF p_debug_flag = 'Y' THEN
231: fnd_file.put_line(fnd_file.log,' *** Report Parameters *** ');
232: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID : ' || P_VAT_REP_ENTITY_ID ) ;
233: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID2 : ' || P_VAT_REP_ENTITY_ID2 ) ;
234: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID3 : ' || P_VAT_REP_ENTITY_ID3 ) ;
235: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID4 : ' || P_VAT_REP_ENTITY_ID4 ) ;

Line 232: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID : ' || P_VAT_REP_ENTITY_ID ) ;

228: BEGIN
229: EXECUTE IMMEDIATE 'alter session set optimizer_features_enable=''10.1.0.5'''; ----Bug 12359827
230: IF p_debug_flag = 'Y' THEN
231: fnd_file.put_line(fnd_file.log,' *** Report Parameters *** ');
232: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID : ' || P_VAT_REP_ENTITY_ID ) ;
233: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID2 : ' || P_VAT_REP_ENTITY_ID2 ) ;
234: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID3 : ' || P_VAT_REP_ENTITY_ID3 ) ;
235: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID4 : ' || P_VAT_REP_ENTITY_ID4 ) ;
236: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID6 : ' || P_VAT_REP_ENTITY_ID5 ) ;

Line 233: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID2 : ' || P_VAT_REP_ENTITY_ID2 ) ;

229: EXECUTE IMMEDIATE 'alter session set optimizer_features_enable=''10.1.0.5'''; ----Bug 12359827
230: IF p_debug_flag = 'Y' THEN
231: fnd_file.put_line(fnd_file.log,' *** Report Parameters *** ');
232: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID : ' || P_VAT_REP_ENTITY_ID ) ;
233: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID2 : ' || P_VAT_REP_ENTITY_ID2 ) ;
234: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID3 : ' || P_VAT_REP_ENTITY_ID3 ) ;
235: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID4 : ' || P_VAT_REP_ENTITY_ID4 ) ;
236: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID6 : ' || P_VAT_REP_ENTITY_ID5 ) ;
237: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID6 : ' || P_VAT_REP_ENTITY_ID6 ) ;

Line 234: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID3 : ' || P_VAT_REP_ENTITY_ID3 ) ;

230: IF p_debug_flag = 'Y' THEN
231: fnd_file.put_line(fnd_file.log,' *** Report Parameters *** ');
232: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID : ' || P_VAT_REP_ENTITY_ID ) ;
233: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID2 : ' || P_VAT_REP_ENTITY_ID2 ) ;
234: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID3 : ' || P_VAT_REP_ENTITY_ID3 ) ;
235: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID4 : ' || P_VAT_REP_ENTITY_ID4 ) ;
236: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID6 : ' || P_VAT_REP_ENTITY_ID5 ) ;
237: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID6 : ' || P_VAT_REP_ENTITY_ID6 ) ;
238: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID7 : ' || P_VAT_REP_ENTITY_ID7 ) ;

Line 235: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID4 : ' || P_VAT_REP_ENTITY_ID4 ) ;

231: fnd_file.put_line(fnd_file.log,' *** Report Parameters *** ');
232: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID : ' || P_VAT_REP_ENTITY_ID ) ;
233: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID2 : ' || P_VAT_REP_ENTITY_ID2 ) ;
234: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID3 : ' || P_VAT_REP_ENTITY_ID3 ) ;
235: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID4 : ' || P_VAT_REP_ENTITY_ID4 ) ;
236: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID6 : ' || P_VAT_REP_ENTITY_ID5 ) ;
237: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID6 : ' || P_VAT_REP_ENTITY_ID6 ) ;
238: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID7 : ' || P_VAT_REP_ENTITY_ID7 ) ;
239: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID8 : ' || P_VAT_REP_ENTITY_ID8 ) ;

Line 236: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID6 : ' || P_VAT_REP_ENTITY_ID5 ) ;

232: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID : ' || P_VAT_REP_ENTITY_ID ) ;
233: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID2 : ' || P_VAT_REP_ENTITY_ID2 ) ;
234: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID3 : ' || P_VAT_REP_ENTITY_ID3 ) ;
235: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID4 : ' || P_VAT_REP_ENTITY_ID4 ) ;
236: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID6 : ' || P_VAT_REP_ENTITY_ID5 ) ;
237: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID6 : ' || P_VAT_REP_ENTITY_ID6 ) ;
238: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID7 : ' || P_VAT_REP_ENTITY_ID7 ) ;
239: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID8 : ' || P_VAT_REP_ENTITY_ID8 ) ;
240: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID9 : ' || P_VAT_REP_ENTITY_ID9 ) ;

Line 237: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID6 : ' || P_VAT_REP_ENTITY_ID6 ) ;

233: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID2 : ' || P_VAT_REP_ENTITY_ID2 ) ;
234: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID3 : ' || P_VAT_REP_ENTITY_ID3 ) ;
235: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID4 : ' || P_VAT_REP_ENTITY_ID4 ) ;
236: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID6 : ' || P_VAT_REP_ENTITY_ID5 ) ;
237: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID6 : ' || P_VAT_REP_ENTITY_ID6 ) ;
238: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID7 : ' || P_VAT_REP_ENTITY_ID7 ) ;
239: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID8 : ' || P_VAT_REP_ENTITY_ID8 ) ;
240: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID9 : ' || P_VAT_REP_ENTITY_ID9 ) ;
241: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID10 : ' || P_VAT_REP_ENTITY_ID10 ) ;

Line 238: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID7 : ' || P_VAT_REP_ENTITY_ID7 ) ;

234: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID3 : ' || P_VAT_REP_ENTITY_ID3 ) ;
235: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID4 : ' || P_VAT_REP_ENTITY_ID4 ) ;
236: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID6 : ' || P_VAT_REP_ENTITY_ID5 ) ;
237: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID6 : ' || P_VAT_REP_ENTITY_ID6 ) ;
238: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID7 : ' || P_VAT_REP_ENTITY_ID7 ) ;
239: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID8 : ' || P_VAT_REP_ENTITY_ID8 ) ;
240: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID9 : ' || P_VAT_REP_ENTITY_ID9 ) ;
241: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID10 : ' || P_VAT_REP_ENTITY_ID10 ) ;
242: fnd_file.put_line(fnd_file.log,'P_ICHUD_OSKIM_NUM : ' || P_ICHUD_OSKIM_NUM ) ;

Line 239: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID8 : ' || P_VAT_REP_ENTITY_ID8 ) ;

235: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID4 : ' || P_VAT_REP_ENTITY_ID4 ) ;
236: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID6 : ' || P_VAT_REP_ENTITY_ID5 ) ;
237: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID6 : ' || P_VAT_REP_ENTITY_ID6 ) ;
238: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID7 : ' || P_VAT_REP_ENTITY_ID7 ) ;
239: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID8 : ' || P_VAT_REP_ENTITY_ID8 ) ;
240: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID9 : ' || P_VAT_REP_ENTITY_ID9 ) ;
241: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID10 : ' || P_VAT_REP_ENTITY_ID10 ) ;
242: fnd_file.put_line(fnd_file.log,'P_ICHUD_OSKIM_NUM : ' || P_ICHUD_OSKIM_NUM ) ;
243: fnd_file.put_line(fnd_file.log,'P_PERIOD : ' || P_PERIOD ) ;

Line 240: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID9 : ' || P_VAT_REP_ENTITY_ID9 ) ;

236: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID6 : ' || P_VAT_REP_ENTITY_ID5 ) ;
237: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID6 : ' || P_VAT_REP_ENTITY_ID6 ) ;
238: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID7 : ' || P_VAT_REP_ENTITY_ID7 ) ;
239: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID8 : ' || P_VAT_REP_ENTITY_ID8 ) ;
240: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID9 : ' || P_VAT_REP_ENTITY_ID9 ) ;
241: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID10 : ' || P_VAT_REP_ENTITY_ID10 ) ;
242: fnd_file.put_line(fnd_file.log,'P_ICHUD_OSKIM_NUM : ' || P_ICHUD_OSKIM_NUM ) ;
243: fnd_file.put_line(fnd_file.log,'P_PERIOD : ' || P_PERIOD ) ;
244: fnd_file.put_line(fnd_file.log,'P_VAT_BOX : ' || P_VAT_BOX ) ;

Line 241: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID10 : ' || P_VAT_REP_ENTITY_ID10 ) ;

237: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID6 : ' || P_VAT_REP_ENTITY_ID6 ) ;
238: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID7 : ' || P_VAT_REP_ENTITY_ID7 ) ;
239: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID8 : ' || P_VAT_REP_ENTITY_ID8 ) ;
240: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID9 : ' || P_VAT_REP_ENTITY_ID9 ) ;
241: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID10 : ' || P_VAT_REP_ENTITY_ID10 ) ;
242: fnd_file.put_line(fnd_file.log,'P_ICHUD_OSKIM_NUM : ' || P_ICHUD_OSKIM_NUM ) ;
243: fnd_file.put_line(fnd_file.log,'P_PERIOD : ' || P_PERIOD ) ;
244: fnd_file.put_line(fnd_file.log,'P_VAT_BOX : ' || P_VAT_BOX ) ;
245: fnd_file.put_line(fnd_file.log,'P_VAT_TRX_TYPE_LOW : ' || P_VAT_TRX_TYPE_LOW ) ;

Line 242: fnd_file.put_line(fnd_file.log,'P_ICHUD_OSKIM_NUM : ' || P_ICHUD_OSKIM_NUM ) ;

238: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID7 : ' || P_VAT_REP_ENTITY_ID7 ) ;
239: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID8 : ' || P_VAT_REP_ENTITY_ID8 ) ;
240: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID9 : ' || P_VAT_REP_ENTITY_ID9 ) ;
241: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID10 : ' || P_VAT_REP_ENTITY_ID10 ) ;
242: fnd_file.put_line(fnd_file.log,'P_ICHUD_OSKIM_NUM : ' || P_ICHUD_OSKIM_NUM ) ;
243: fnd_file.put_line(fnd_file.log,'P_PERIOD : ' || P_PERIOD ) ;
244: fnd_file.put_line(fnd_file.log,'P_VAT_BOX : ' || P_VAT_BOX ) ;
245: fnd_file.put_line(fnd_file.log,'P_VAT_TRX_TYPE_LOW : ' || P_VAT_TRX_TYPE_LOW ) ;
246: fnd_file.put_line(fnd_file.log,'P_VAT_TRX_TYPE_HIGH : ' || P_VAT_TRX_TYPE_HIGH ) ;

Line 243: fnd_file.put_line(fnd_file.log,'P_PERIOD : ' || P_PERIOD ) ;

239: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID8 : ' || P_VAT_REP_ENTITY_ID8 ) ;
240: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID9 : ' || P_VAT_REP_ENTITY_ID9 ) ;
241: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID10 : ' || P_VAT_REP_ENTITY_ID10 ) ;
242: fnd_file.put_line(fnd_file.log,'P_ICHUD_OSKIM_NUM : ' || P_ICHUD_OSKIM_NUM ) ;
243: fnd_file.put_line(fnd_file.log,'P_PERIOD : ' || P_PERIOD ) ;
244: fnd_file.put_line(fnd_file.log,'P_VAT_BOX : ' || P_VAT_BOX ) ;
245: fnd_file.put_line(fnd_file.log,'P_VAT_TRX_TYPE_LOW : ' || P_VAT_TRX_TYPE_LOW ) ;
246: fnd_file.put_line(fnd_file.log,'P_VAT_TRX_TYPE_HIGH : ' || P_VAT_TRX_TYPE_HIGH ) ;
247: fnd_file.put_line(fnd_file.log,'P_VAT_TRX_TYPE : ' || P_VAT_TRX_TYPE ) ;

Line 244: fnd_file.put_line(fnd_file.log,'P_VAT_BOX : ' || P_VAT_BOX ) ;

240: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID9 : ' || P_VAT_REP_ENTITY_ID9 ) ;
241: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID10 : ' || P_VAT_REP_ENTITY_ID10 ) ;
242: fnd_file.put_line(fnd_file.log,'P_ICHUD_OSKIM_NUM : ' || P_ICHUD_OSKIM_NUM ) ;
243: fnd_file.put_line(fnd_file.log,'P_PERIOD : ' || P_PERIOD ) ;
244: fnd_file.put_line(fnd_file.log,'P_VAT_BOX : ' || P_VAT_BOX ) ;
245: fnd_file.put_line(fnd_file.log,'P_VAT_TRX_TYPE_LOW : ' || P_VAT_TRX_TYPE_LOW ) ;
246: fnd_file.put_line(fnd_file.log,'P_VAT_TRX_TYPE_HIGH : ' || P_VAT_TRX_TYPE_HIGH ) ;
247: fnd_file.put_line(fnd_file.log,'P_VAT_TRX_TYPE : ' || P_VAT_TRX_TYPE ) ;
248: fnd_file.put_line(fnd_file.log,'P_REPORT_FORMAT : ' || P_REPORT_FORMAT ) ;

Line 245: fnd_file.put_line(fnd_file.log,'P_VAT_TRX_TYPE_LOW : ' || P_VAT_TRX_TYPE_LOW ) ;

241: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID10 : ' || P_VAT_REP_ENTITY_ID10 ) ;
242: fnd_file.put_line(fnd_file.log,'P_ICHUD_OSKIM_NUM : ' || P_ICHUD_OSKIM_NUM ) ;
243: fnd_file.put_line(fnd_file.log,'P_PERIOD : ' || P_PERIOD ) ;
244: fnd_file.put_line(fnd_file.log,'P_VAT_BOX : ' || P_VAT_BOX ) ;
245: fnd_file.put_line(fnd_file.log,'P_VAT_TRX_TYPE_LOW : ' || P_VAT_TRX_TYPE_LOW ) ;
246: fnd_file.put_line(fnd_file.log,'P_VAT_TRX_TYPE_HIGH : ' || P_VAT_TRX_TYPE_HIGH ) ;
247: fnd_file.put_line(fnd_file.log,'P_VAT_TRX_TYPE : ' || P_VAT_TRX_TYPE ) ;
248: fnd_file.put_line(fnd_file.log,'P_REPORT_FORMAT : ' || P_REPORT_FORMAT ) ;
249: fnd_file.put_line(fnd_file.log,'P_BOX_FROM : ' || P_BOX_FROM ) ;

Line 246: fnd_file.put_line(fnd_file.log,'P_VAT_TRX_TYPE_HIGH : ' || P_VAT_TRX_TYPE_HIGH ) ;

242: fnd_file.put_line(fnd_file.log,'P_ICHUD_OSKIM_NUM : ' || P_ICHUD_OSKIM_NUM ) ;
243: fnd_file.put_line(fnd_file.log,'P_PERIOD : ' || P_PERIOD ) ;
244: fnd_file.put_line(fnd_file.log,'P_VAT_BOX : ' || P_VAT_BOX ) ;
245: fnd_file.put_line(fnd_file.log,'P_VAT_TRX_TYPE_LOW : ' || P_VAT_TRX_TYPE_LOW ) ;
246: fnd_file.put_line(fnd_file.log,'P_VAT_TRX_TYPE_HIGH : ' || P_VAT_TRX_TYPE_HIGH ) ;
247: fnd_file.put_line(fnd_file.log,'P_VAT_TRX_TYPE : ' || P_VAT_TRX_TYPE ) ;
248: fnd_file.put_line(fnd_file.log,'P_REPORT_FORMAT : ' || P_REPORT_FORMAT ) ;
249: fnd_file.put_line(fnd_file.log,'P_BOX_FROM : ' || P_BOX_FROM ) ;
250: fnd_file.put_line(fnd_file.log,'P_BOX_TO : ' || P_BOX_TO ) ;

Line 247: fnd_file.put_line(fnd_file.log,'P_VAT_TRX_TYPE : ' || P_VAT_TRX_TYPE ) ;

243: fnd_file.put_line(fnd_file.log,'P_PERIOD : ' || P_PERIOD ) ;
244: fnd_file.put_line(fnd_file.log,'P_VAT_BOX : ' || P_VAT_BOX ) ;
245: fnd_file.put_line(fnd_file.log,'P_VAT_TRX_TYPE_LOW : ' || P_VAT_TRX_TYPE_LOW ) ;
246: fnd_file.put_line(fnd_file.log,'P_VAT_TRX_TYPE_HIGH : ' || P_VAT_TRX_TYPE_HIGH ) ;
247: fnd_file.put_line(fnd_file.log,'P_VAT_TRX_TYPE : ' || P_VAT_TRX_TYPE ) ;
248: fnd_file.put_line(fnd_file.log,'P_REPORT_FORMAT : ' || P_REPORT_FORMAT ) ;
249: fnd_file.put_line(fnd_file.log,'P_BOX_FROM : ' || P_BOX_FROM ) ;
250: fnd_file.put_line(fnd_file.log,'P_BOX_TO : ' || P_BOX_TO ) ;
251: fnd_file.put_line(fnd_file.log,'P_SOURCE : ' || P_SOURCE ) ;

Line 248: fnd_file.put_line(fnd_file.log,'P_REPORT_FORMAT : ' || P_REPORT_FORMAT ) ;

244: fnd_file.put_line(fnd_file.log,'P_VAT_BOX : ' || P_VAT_BOX ) ;
245: fnd_file.put_line(fnd_file.log,'P_VAT_TRX_TYPE_LOW : ' || P_VAT_TRX_TYPE_LOW ) ;
246: fnd_file.put_line(fnd_file.log,'P_VAT_TRX_TYPE_HIGH : ' || P_VAT_TRX_TYPE_HIGH ) ;
247: fnd_file.put_line(fnd_file.log,'P_VAT_TRX_TYPE : ' || P_VAT_TRX_TYPE ) ;
248: fnd_file.put_line(fnd_file.log,'P_REPORT_FORMAT : ' || P_REPORT_FORMAT ) ;
249: fnd_file.put_line(fnd_file.log,'P_BOX_FROM : ' || P_BOX_FROM ) ;
250: fnd_file.put_line(fnd_file.log,'P_BOX_TO : ' || P_BOX_TO ) ;
251: fnd_file.put_line(fnd_file.log,'P_SOURCE : ' || P_SOURCE ) ;
252: fnd_file.put_line(fnd_file.log,'P_DOC_NAME : ' || P_DOC_NAME ) ;

Line 249: fnd_file.put_line(fnd_file.log,'P_BOX_FROM : ' || P_BOX_FROM ) ;

245: fnd_file.put_line(fnd_file.log,'P_VAT_TRX_TYPE_LOW : ' || P_VAT_TRX_TYPE_LOW ) ;
246: fnd_file.put_line(fnd_file.log,'P_VAT_TRX_TYPE_HIGH : ' || P_VAT_TRX_TYPE_HIGH ) ;
247: fnd_file.put_line(fnd_file.log,'P_VAT_TRX_TYPE : ' || P_VAT_TRX_TYPE ) ;
248: fnd_file.put_line(fnd_file.log,'P_REPORT_FORMAT : ' || P_REPORT_FORMAT ) ;
249: fnd_file.put_line(fnd_file.log,'P_BOX_FROM : ' || P_BOX_FROM ) ;
250: fnd_file.put_line(fnd_file.log,'P_BOX_TO : ' || P_BOX_TO ) ;
251: fnd_file.put_line(fnd_file.log,'P_SOURCE : ' || P_SOURCE ) ;
252: fnd_file.put_line(fnd_file.log,'P_DOC_NAME : ' || P_DOC_NAME ) ;
253: fnd_file.put_line(fnd_file.log,'P_DOC_SEQ_VALUE : ' || P_DOC_SEQ_VALUE ) ;

Line 250: fnd_file.put_line(fnd_file.log,'P_BOX_TO : ' || P_BOX_TO ) ;

246: fnd_file.put_line(fnd_file.log,'P_VAT_TRX_TYPE_HIGH : ' || P_VAT_TRX_TYPE_HIGH ) ;
247: fnd_file.put_line(fnd_file.log,'P_VAT_TRX_TYPE : ' || P_VAT_TRX_TYPE ) ;
248: fnd_file.put_line(fnd_file.log,'P_REPORT_FORMAT : ' || P_REPORT_FORMAT ) ;
249: fnd_file.put_line(fnd_file.log,'P_BOX_FROM : ' || P_BOX_FROM ) ;
250: fnd_file.put_line(fnd_file.log,'P_BOX_TO : ' || P_BOX_TO ) ;
251: fnd_file.put_line(fnd_file.log,'P_SOURCE : ' || P_SOURCE ) ;
252: fnd_file.put_line(fnd_file.log,'P_DOC_NAME : ' || P_DOC_NAME ) ;
253: fnd_file.put_line(fnd_file.log,'P_DOC_SEQ_VALUE : ' || P_DOC_SEQ_VALUE ) ;
254: fnd_file.put_line(fnd_file.log,'P_REPORT_NAME : ' || P_REPORT_NAME ) ;

Line 251: fnd_file.put_line(fnd_file.log,'P_SOURCE : ' || P_SOURCE ) ;

247: fnd_file.put_line(fnd_file.log,'P_VAT_TRX_TYPE : ' || P_VAT_TRX_TYPE ) ;
248: fnd_file.put_line(fnd_file.log,'P_REPORT_FORMAT : ' || P_REPORT_FORMAT ) ;
249: fnd_file.put_line(fnd_file.log,'P_BOX_FROM : ' || P_BOX_FROM ) ;
250: fnd_file.put_line(fnd_file.log,'P_BOX_TO : ' || P_BOX_TO ) ;
251: fnd_file.put_line(fnd_file.log,'P_SOURCE : ' || P_SOURCE ) ;
252: fnd_file.put_line(fnd_file.log,'P_DOC_NAME : ' || P_DOC_NAME ) ;
253: fnd_file.put_line(fnd_file.log,'P_DOC_SEQ_VALUE : ' || P_DOC_SEQ_VALUE ) ;
254: fnd_file.put_line(fnd_file.log,'P_REPORT_NAME : ' || P_REPORT_NAME ) ;
255: fnd_file.put_line(fnd_file.log,'P_VAR_ON_PURCHASES : ' || P_VAR_ON_PURCHASES ) ;

Line 252: fnd_file.put_line(fnd_file.log,'P_DOC_NAME : ' || P_DOC_NAME ) ;

248: fnd_file.put_line(fnd_file.log,'P_REPORT_FORMAT : ' || P_REPORT_FORMAT ) ;
249: fnd_file.put_line(fnd_file.log,'P_BOX_FROM : ' || P_BOX_FROM ) ;
250: fnd_file.put_line(fnd_file.log,'P_BOX_TO : ' || P_BOX_TO ) ;
251: fnd_file.put_line(fnd_file.log,'P_SOURCE : ' || P_SOURCE ) ;
252: fnd_file.put_line(fnd_file.log,'P_DOC_NAME : ' || P_DOC_NAME ) ;
253: fnd_file.put_line(fnd_file.log,'P_DOC_SEQ_VALUE : ' || P_DOC_SEQ_VALUE ) ;
254: fnd_file.put_line(fnd_file.log,'P_REPORT_NAME : ' || P_REPORT_NAME ) ;
255: fnd_file.put_line(fnd_file.log,'P_VAR_ON_PURCHASES : ' || P_VAR_ON_PURCHASES ) ;
256: fnd_file.put_line(fnd_file.log,'P_VAR_ON_SALES : ' || P_VAR_ON_SALES ) ;

Line 253: fnd_file.put_line(fnd_file.log,'P_DOC_SEQ_VALUE : ' || P_DOC_SEQ_VALUE ) ;

249: fnd_file.put_line(fnd_file.log,'P_BOX_FROM : ' || P_BOX_FROM ) ;
250: fnd_file.put_line(fnd_file.log,'P_BOX_TO : ' || P_BOX_TO ) ;
251: fnd_file.put_line(fnd_file.log,'P_SOURCE : ' || P_SOURCE ) ;
252: fnd_file.put_line(fnd_file.log,'P_DOC_NAME : ' || P_DOC_NAME ) ;
253: fnd_file.put_line(fnd_file.log,'P_DOC_SEQ_VALUE : ' || P_DOC_SEQ_VALUE ) ;
254: fnd_file.put_line(fnd_file.log,'P_REPORT_NAME : ' || P_REPORT_NAME ) ;
255: fnd_file.put_line(fnd_file.log,'P_VAR_ON_PURCHASES : ' || P_VAR_ON_PURCHASES ) ;
256: fnd_file.put_line(fnd_file.log,'P_VAR_ON_SALES : ' || P_VAR_ON_SALES ) ;
257: fnd_file.put_line(fnd_file.log,'P_LOCATION : ' || P_LOCATION ) ;

Line 254: fnd_file.put_line(fnd_file.log,'P_REPORT_NAME : ' || P_REPORT_NAME ) ;

250: fnd_file.put_line(fnd_file.log,'P_BOX_TO : ' || P_BOX_TO ) ;
251: fnd_file.put_line(fnd_file.log,'P_SOURCE : ' || P_SOURCE ) ;
252: fnd_file.put_line(fnd_file.log,'P_DOC_NAME : ' || P_DOC_NAME ) ;
253: fnd_file.put_line(fnd_file.log,'P_DOC_SEQ_VALUE : ' || P_DOC_SEQ_VALUE ) ;
254: fnd_file.put_line(fnd_file.log,'P_REPORT_NAME : ' || P_REPORT_NAME ) ;
255: fnd_file.put_line(fnd_file.log,'P_VAR_ON_PURCHASES : ' || P_VAR_ON_PURCHASES ) ;
256: fnd_file.put_line(fnd_file.log,'P_VAR_ON_SALES : ' || P_VAR_ON_SALES ) ;
257: fnd_file.put_line(fnd_file.log,'P_LOCATION : ' || P_LOCATION ) ;
258: fnd_file.put_line(fnd_file.log,'P_LEGAL_ENTITY_NAME : ' || P_LEGAL_ENTITY_NAME ) ;

Line 255: fnd_file.put_line(fnd_file.log,'P_VAR_ON_PURCHASES : ' || P_VAR_ON_PURCHASES ) ;

251: fnd_file.put_line(fnd_file.log,'P_SOURCE : ' || P_SOURCE ) ;
252: fnd_file.put_line(fnd_file.log,'P_DOC_NAME : ' || P_DOC_NAME ) ;
253: fnd_file.put_line(fnd_file.log,'P_DOC_SEQ_VALUE : ' || P_DOC_SEQ_VALUE ) ;
254: fnd_file.put_line(fnd_file.log,'P_REPORT_NAME : ' || P_REPORT_NAME ) ;
255: fnd_file.put_line(fnd_file.log,'P_VAR_ON_PURCHASES : ' || P_VAR_ON_PURCHASES ) ;
256: fnd_file.put_line(fnd_file.log,'P_VAR_ON_SALES : ' || P_VAR_ON_SALES ) ;
257: fnd_file.put_line(fnd_file.log,'P_LOCATION : ' || P_LOCATION ) ;
258: fnd_file.put_line(fnd_file.log,'P_LEGAL_ENTITY_NAME : ' || P_LEGAL_ENTITY_NAME ) ;
259: fnd_file.put_line(fnd_file.log,' *************************** ');

Line 256: fnd_file.put_line(fnd_file.log,'P_VAR_ON_SALES : ' || P_VAR_ON_SALES ) ;

252: fnd_file.put_line(fnd_file.log,'P_DOC_NAME : ' || P_DOC_NAME ) ;
253: fnd_file.put_line(fnd_file.log,'P_DOC_SEQ_VALUE : ' || P_DOC_SEQ_VALUE ) ;
254: fnd_file.put_line(fnd_file.log,'P_REPORT_NAME : ' || P_REPORT_NAME ) ;
255: fnd_file.put_line(fnd_file.log,'P_VAR_ON_PURCHASES : ' || P_VAR_ON_PURCHASES ) ;
256: fnd_file.put_line(fnd_file.log,'P_VAR_ON_SALES : ' || P_VAR_ON_SALES ) ;
257: fnd_file.put_line(fnd_file.log,'P_LOCATION : ' || P_LOCATION ) ;
258: fnd_file.put_line(fnd_file.log,'P_LEGAL_ENTITY_NAME : ' || P_LEGAL_ENTITY_NAME ) ;
259: fnd_file.put_line(fnd_file.log,' *************************** ');
260: END IF;

Line 257: fnd_file.put_line(fnd_file.log,'P_LOCATION : ' || P_LOCATION ) ;

253: fnd_file.put_line(fnd_file.log,'P_DOC_SEQ_VALUE : ' || P_DOC_SEQ_VALUE ) ;
254: fnd_file.put_line(fnd_file.log,'P_REPORT_NAME : ' || P_REPORT_NAME ) ;
255: fnd_file.put_line(fnd_file.log,'P_VAR_ON_PURCHASES : ' || P_VAR_ON_PURCHASES ) ;
256: fnd_file.put_line(fnd_file.log,'P_VAR_ON_SALES : ' || P_VAR_ON_SALES ) ;
257: fnd_file.put_line(fnd_file.log,'P_LOCATION : ' || P_LOCATION ) ;
258: fnd_file.put_line(fnd_file.log,'P_LEGAL_ENTITY_NAME : ' || P_LEGAL_ENTITY_NAME ) ;
259: fnd_file.put_line(fnd_file.log,' *************************** ');
260: END IF;
261:

Line 258: fnd_file.put_line(fnd_file.log,'P_LEGAL_ENTITY_NAME : ' || P_LEGAL_ENTITY_NAME ) ;

254: fnd_file.put_line(fnd_file.log,'P_REPORT_NAME : ' || P_REPORT_NAME ) ;
255: fnd_file.put_line(fnd_file.log,'P_VAR_ON_PURCHASES : ' || P_VAR_ON_PURCHASES ) ;
256: fnd_file.put_line(fnd_file.log,'P_VAR_ON_SALES : ' || P_VAR_ON_SALES ) ;
257: fnd_file.put_line(fnd_file.log,'P_LOCATION : ' || P_LOCATION ) ;
258: fnd_file.put_line(fnd_file.log,'P_LEGAL_ENTITY_NAME : ' || P_LEGAL_ENTITY_NAME ) ;
259: fnd_file.put_line(fnd_file.log,' *************************** ');
260: END IF;
261:
262: BEGIN

Line 259: fnd_file.put_line(fnd_file.log,' *************************** ');

255: fnd_file.put_line(fnd_file.log,'P_VAR_ON_PURCHASES : ' || P_VAR_ON_PURCHASES ) ;
256: fnd_file.put_line(fnd_file.log,'P_VAR_ON_SALES : ' || P_VAR_ON_SALES ) ;
257: fnd_file.put_line(fnd_file.log,'P_LOCATION : ' || P_LOCATION ) ;
258: fnd_file.put_line(fnd_file.log,'P_LEGAL_ENTITY_NAME : ' || P_LEGAL_ENTITY_NAME ) ;
259: fnd_file.put_line(fnd_file.log,' *************************** ');
260: END IF;
261:
262: BEGIN
263: IF p_report_name = 'JEPTAVAT' THEN --Only for annual report, period year is passed

Line 284: fnd_file.put_line(fnd_file.log,'Executing jg_zz_common_pkg.funct_curr_legal: '||SUBSTR(SQLERRM,1,200));

280: p_legal_entity_id := l_legal_entity_id;
281: END IF ;
282: EXCEPTION
283: WHEN OTHERS THEN
284: fnd_file.put_line(fnd_file.log,'Executing jg_zz_common_pkg.funct_curr_legal: '||SUBSTR(SQLERRM,1,200));
285: END;
286:
287: BEGIN
288: IF p_report_name = 'JEPTAVAT' THEN

Line 309: fnd_file.put_line(fnd_file.log,'Executing jg_zz_common_pkg.tax_registration: '||SUBSTR(SQLERRM,1,200));

305: ,pv_source => 'ALL');
306: END IF;
307: EXCEPTION
308: WHEN OTHERS THEN
309: fnd_file.put_line(fnd_file.log,'Executing jg_zz_common_pkg.tax_registration: '||SUBSTR(SQLERRM,1,200));
310: END;
311:
312: BEGIN
313: if(P_REPORT_NAME <> 'JEPTAVAT' )then

Line 335: fnd_file.put_line(fnd_file.log,'Executing jg_zz_common_pkg.tax_registration: '||SUBSTR(SQLERRM,1,200));

331: end if;
332:
333: EXCEPTION
334: WHEN OTHERS THEN
335: fnd_file.put_line(fnd_file.log,'Executing jg_zz_common_pkg.tax_registration: '||SUBSTR(SQLERRM,1,200));
336: END;
337:
338: BEGIN
339: jg_zz_common_pkg.company_detail(x_company_name => l_company_name

Line 357: fnd_file.put_line(fnd_file.log,'Executing jg_zz_common_pkg.company_detail: '||SUBSTR(SQLERRM,1,200));

353: ,pn_legal_entity_id => l_legal_entity_id
354: ,p_vat_reporting_entity_id => P_VAT_REP_ENTITY_ID);
355: EXCEPTION
356: WHEN OTHERS THEN
357: fnd_file.put_line(fnd_file.log,'Executing jg_zz_common_pkg.company_detail: '||SUBSTR(SQLERRM,1,200));
358: END;
359: BEGIN
360: SELECT activity_code
361: INTO l_activity_code

Line 366: fnd_file.put_line(fnd_file.log,'Cannot find Activity Code (Standard Inductry Classification Code for Legal Entity:'||l_legal_entity_id);

362: FROM xle_entity_profiles
363: WHERE legal_entity_id = l_legal_entity_id;
364: EXCEPTION
365: WHEN NO_DATA_FOUND THEN
366: fnd_file.put_line(fnd_file.log,'Cannot find Activity Code (Standard Inductry Classification Code for Legal Entity:'||l_legal_entity_id);
367: WHEN OTHERS THEN
368: fnd_file.put_line(fnd_file.log,'Error While retriving Activity Code for Legal Entity:'||l_legal_entity_id);
369: fnd_file.put_line(fnd_file.log,'Error Message :'||SUBSTR(SQLERRM,1,200));
370: END;

Line 368: fnd_file.put_line(fnd_file.log,'Error While retriving Activity Code for Legal Entity:'||l_legal_entity_id);

364: EXCEPTION
365: WHEN NO_DATA_FOUND THEN
366: fnd_file.put_line(fnd_file.log,'Cannot find Activity Code (Standard Inductry Classification Code for Legal Entity:'||l_legal_entity_id);
367: WHEN OTHERS THEN
368: fnd_file.put_line(fnd_file.log,'Error While retriving Activity Code for Legal Entity:'||l_legal_entity_id);
369: fnd_file.put_line(fnd_file.log,'Error Message :'||SUBSTR(SQLERRM,1,200));
370: END;
371:
372: BEGIN

Line 369: fnd_file.put_line(fnd_file.log,'Error Message :'||SUBSTR(SQLERRM,1,200));

365: WHEN NO_DATA_FOUND THEN
366: fnd_file.put_line(fnd_file.log,'Cannot find Activity Code (Standard Inductry Classification Code for Legal Entity:'||l_legal_entity_id);
367: WHEN OTHERS THEN
368: fnd_file.put_line(fnd_file.log,'Error While retriving Activity Code for Legal Entity:'||l_legal_entity_id);
369: fnd_file.put_line(fnd_file.log,'Error Message :'||SUBSTR(SQLERRM,1,200));
370: END;
371:
372: BEGIN
373:

Line 382: fnd_file.put_line(fnd_file.log,'Error Message :'||SUBSTR(SQLERRM,1,200));

378: CLOSE get_legal_auth_info;
379:
380: EXCEPTION
381: WHEN OTHERS THEN
382: fnd_file.put_line(fnd_file.log,'Error Message :'||SUBSTR(SQLERRM,1,200));
383: END;
384:
385:
386: /* Get Currency Precision */

Line 389: FND_FILE.PUT_LINE(FND_FILE.LOG,'Functional Currency Code :'||l_func_curr);

385:
386: /* Get Currency Precision */
387:
388: BEGIN
389: FND_FILE.PUT_LINE(FND_FILE.LOG,'Functional Currency Code :'||l_func_curr);
390:
391: SELECT precision
392: INTO l_precision
393: FROM fnd_currencies

Line 396: FND_FILE.PUT_LINE(FND_FILE.LOG,'Functional Currency Precision :'||l_precision);

392: INTO l_precision
393: FROM fnd_currencies
394: WHERE currency_code = l_func_curr;
395:
396: FND_FILE.PUT_LINE(FND_FILE.LOG,'Functional Currency Precision :'||l_precision);
397:
398: EXCEPTION
399: WHEN OTHERS THEN
400: FND_FILE.PUT_LINE(FND_FILE.LOG,'error in getting currency precision');

Line 400: FND_FILE.PUT_LINE(FND_FILE.LOG,'error in getting currency precision');

396: FND_FILE.PUT_LINE(FND_FILE.LOG,'Functional Currency Precision :'||l_precision);
397:
398: EXCEPTION
399: WHEN OTHERS THEN
400: FND_FILE.PUT_LINE(FND_FILE.LOG,'error in getting currency precision');
401: END;
402:
403:
404: INSERT INTO jg_zz_vat_trx_gt

Line 465: fnd_file.put_line(fnd_file.log,'Legal Entity ID => ' || l_legal_entity_id);

461: ,l_comm_num
462: ,l_vat_reg_num
463: );
464: IF p_debug_flag = 'Y' THEN
465: fnd_file.put_line(fnd_file.log,'Legal Entity ID => ' || l_legal_entity_id);
466: fnd_file.put_line(fnd_file.log,'Company Name => ' || l_company_name);
467: fnd_file.put_line(fnd_file.log,'Legal Entity Name => ' || l_company_name);
468: fnd_file.put_line(fnd_file.log,'Regiatration Number => ' || l_registration_num);
469: fnd_file.put_line(fnd_file.log,'Taxpayer ID => ' || l_registration_num);

Line 466: fnd_file.put_line(fnd_file.log,'Company Name => ' || l_company_name);

462: ,l_vat_reg_num
463: );
464: IF p_debug_flag = 'Y' THEN
465: fnd_file.put_line(fnd_file.log,'Legal Entity ID => ' || l_legal_entity_id);
466: fnd_file.put_line(fnd_file.log,'Company Name => ' || l_company_name);
467: fnd_file.put_line(fnd_file.log,'Legal Entity Name => ' || l_company_name);
468: fnd_file.put_line(fnd_file.log,'Regiatration Number => ' || l_registration_num);
469: fnd_file.put_line(fnd_file.log,'Taxpayer ID => ' || l_registration_num);
470: fnd_file.put_line(fnd_file.log,'Contact Name => ' || l_contact_name);

Line 467: fnd_file.put_line(fnd_file.log,'Legal Entity Name => ' || l_company_name);

463: );
464: IF p_debug_flag = 'Y' THEN
465: fnd_file.put_line(fnd_file.log,'Legal Entity ID => ' || l_legal_entity_id);
466: fnd_file.put_line(fnd_file.log,'Company Name => ' || l_company_name);
467: fnd_file.put_line(fnd_file.log,'Legal Entity Name => ' || l_company_name);
468: fnd_file.put_line(fnd_file.log,'Regiatration Number => ' || l_registration_num);
469: fnd_file.put_line(fnd_file.log,'Taxpayer ID => ' || l_registration_num);
470: fnd_file.put_line(fnd_file.log,'Contact Name => ' || l_contact_name);
471: fnd_file.put_line(fnd_file.log,'Address Line 1 => ' || l_address_line_1);

Line 468: fnd_file.put_line(fnd_file.log,'Regiatration Number => ' || l_registration_num);

464: IF p_debug_flag = 'Y' THEN
465: fnd_file.put_line(fnd_file.log,'Legal Entity ID => ' || l_legal_entity_id);
466: fnd_file.put_line(fnd_file.log,'Company Name => ' || l_company_name);
467: fnd_file.put_line(fnd_file.log,'Legal Entity Name => ' || l_company_name);
468: fnd_file.put_line(fnd_file.log,'Regiatration Number => ' || l_registration_num);
469: fnd_file.put_line(fnd_file.log,'Taxpayer ID => ' || l_registration_num);
470: fnd_file.put_line(fnd_file.log,'Contact Name => ' || l_contact_name);
471: fnd_file.put_line(fnd_file.log,'Address Line 1 => ' || l_address_line_1);
472: fnd_file.put_line(fnd_file.log,'Address Line 2 => ' || l_address_line_2);

Line 469: fnd_file.put_line(fnd_file.log,'Taxpayer ID => ' || l_registration_num);

465: fnd_file.put_line(fnd_file.log,'Legal Entity ID => ' || l_legal_entity_id);
466: fnd_file.put_line(fnd_file.log,'Company Name => ' || l_company_name);
467: fnd_file.put_line(fnd_file.log,'Legal Entity Name => ' || l_company_name);
468: fnd_file.put_line(fnd_file.log,'Regiatration Number => ' || l_registration_num);
469: fnd_file.put_line(fnd_file.log,'Taxpayer ID => ' || l_registration_num);
470: fnd_file.put_line(fnd_file.log,'Contact Name => ' || l_contact_name);
471: fnd_file.put_line(fnd_file.log,'Address Line 1 => ' || l_address_line_1);
472: fnd_file.put_line(fnd_file.log,'Address Line 2 => ' || l_address_line_2);
473: fnd_file.put_line(fnd_file.log,'Address Line 3 => ' || l_address_line_3);

Line 470: fnd_file.put_line(fnd_file.log,'Contact Name => ' || l_contact_name);

466: fnd_file.put_line(fnd_file.log,'Company Name => ' || l_company_name);
467: fnd_file.put_line(fnd_file.log,'Legal Entity Name => ' || l_company_name);
468: fnd_file.put_line(fnd_file.log,'Regiatration Number => ' || l_registration_num);
469: fnd_file.put_line(fnd_file.log,'Taxpayer ID => ' || l_registration_num);
470: fnd_file.put_line(fnd_file.log,'Contact Name => ' || l_contact_name);
471: fnd_file.put_line(fnd_file.log,'Address Line 1 => ' || l_address_line_1);
472: fnd_file.put_line(fnd_file.log,'Address Line 2 => ' || l_address_line_2);
473: fnd_file.put_line(fnd_file.log,'Address Line 3 => ' || l_address_line_3);
474: fnd_file.put_line(fnd_file.log,'Address Line 4 => ' || l_address_line_4);

Line 471: fnd_file.put_line(fnd_file.log,'Address Line 1 => ' || l_address_line_1);

467: fnd_file.put_line(fnd_file.log,'Legal Entity Name => ' || l_company_name);
468: fnd_file.put_line(fnd_file.log,'Regiatration Number => ' || l_registration_num);
469: fnd_file.put_line(fnd_file.log,'Taxpayer ID => ' || l_registration_num);
470: fnd_file.put_line(fnd_file.log,'Contact Name => ' || l_contact_name);
471: fnd_file.put_line(fnd_file.log,'Address Line 1 => ' || l_address_line_1);
472: fnd_file.put_line(fnd_file.log,'Address Line 2 => ' || l_address_line_2);
473: fnd_file.put_line(fnd_file.log,'Address Line 3 => ' || l_address_line_3);
474: fnd_file.put_line(fnd_file.log,'Address Line 4 => ' || l_address_line_4);
475: fnd_file.put_line(fnd_file.log,'City => ' || l_city);

Line 472: fnd_file.put_line(fnd_file.log,'Address Line 2 => ' || l_address_line_2);

468: fnd_file.put_line(fnd_file.log,'Regiatration Number => ' || l_registration_num);
469: fnd_file.put_line(fnd_file.log,'Taxpayer ID => ' || l_registration_num);
470: fnd_file.put_line(fnd_file.log,'Contact Name => ' || l_contact_name);
471: fnd_file.put_line(fnd_file.log,'Address Line 1 => ' || l_address_line_1);
472: fnd_file.put_line(fnd_file.log,'Address Line 2 => ' || l_address_line_2);
473: fnd_file.put_line(fnd_file.log,'Address Line 3 => ' || l_address_line_3);
474: fnd_file.put_line(fnd_file.log,'Address Line 4 => ' || l_address_line_4);
475: fnd_file.put_line(fnd_file.log,'City => ' || l_city);
476: fnd_file.put_line(fnd_file.log,'Country => ' || l_country);

Line 473: fnd_file.put_line(fnd_file.log,'Address Line 3 => ' || l_address_line_3);

469: fnd_file.put_line(fnd_file.log,'Taxpayer ID => ' || l_registration_num);
470: fnd_file.put_line(fnd_file.log,'Contact Name => ' || l_contact_name);
471: fnd_file.put_line(fnd_file.log,'Address Line 1 => ' || l_address_line_1);
472: fnd_file.put_line(fnd_file.log,'Address Line 2 => ' || l_address_line_2);
473: fnd_file.put_line(fnd_file.log,'Address Line 3 => ' || l_address_line_3);
474: fnd_file.put_line(fnd_file.log,'Address Line 4 => ' || l_address_line_4);
475: fnd_file.put_line(fnd_file.log,'City => ' || l_city);
476: fnd_file.put_line(fnd_file.log,'Country => ' || l_country);
477: fnd_file.put_line(fnd_file.log,'Telephone Number => ' || l_phone_number);

Line 474: fnd_file.put_line(fnd_file.log,'Address Line 4 => ' || l_address_line_4);

470: fnd_file.put_line(fnd_file.log,'Contact Name => ' || l_contact_name);
471: fnd_file.put_line(fnd_file.log,'Address Line 1 => ' || l_address_line_1);
472: fnd_file.put_line(fnd_file.log,'Address Line 2 => ' || l_address_line_2);
473: fnd_file.put_line(fnd_file.log,'Address Line 3 => ' || l_address_line_3);
474: fnd_file.put_line(fnd_file.log,'Address Line 4 => ' || l_address_line_4);
475: fnd_file.put_line(fnd_file.log,'City => ' || l_city);
476: fnd_file.put_line(fnd_file.log,'Country => ' || l_country);
477: fnd_file.put_line(fnd_file.log,'Telephone Number => ' || l_phone_number);
478: fnd_file.put_line(fnd_file.log,'Postal Code => ' || l_postal_code);

Line 475: fnd_file.put_line(fnd_file.log,'City => ' || l_city);

471: fnd_file.put_line(fnd_file.log,'Address Line 1 => ' || l_address_line_1);
472: fnd_file.put_line(fnd_file.log,'Address Line 2 => ' || l_address_line_2);
473: fnd_file.put_line(fnd_file.log,'Address Line 3 => ' || l_address_line_3);
474: fnd_file.put_line(fnd_file.log,'Address Line 4 => ' || l_address_line_4);
475: fnd_file.put_line(fnd_file.log,'City => ' || l_city);
476: fnd_file.put_line(fnd_file.log,'Country => ' || l_country);
477: fnd_file.put_line(fnd_file.log,'Telephone Number => ' || l_phone_number);
478: fnd_file.put_line(fnd_file.log,'Postal Code => ' || l_postal_code);
479: fnd_file.put_line(fnd_file.log,'Currency Code => ' || l_func_curr);

Line 476: fnd_file.put_line(fnd_file.log,'Country => ' || l_country);

472: fnd_file.put_line(fnd_file.log,'Address Line 2 => ' || l_address_line_2);
473: fnd_file.put_line(fnd_file.log,'Address Line 3 => ' || l_address_line_3);
474: fnd_file.put_line(fnd_file.log,'Address Line 4 => ' || l_address_line_4);
475: fnd_file.put_line(fnd_file.log,'City => ' || l_city);
476: fnd_file.put_line(fnd_file.log,'Country => ' || l_country);
477: fnd_file.put_line(fnd_file.log,'Telephone Number => ' || l_phone_number);
478: fnd_file.put_line(fnd_file.log,'Postal Code => ' || l_postal_code);
479: fnd_file.put_line(fnd_file.log,'Currency Code => ' || l_func_curr);
480: fnd_file.put_line(fnd_file.log,'Reporting Status => ' || l_reporting_status);

Line 477: fnd_file.put_line(fnd_file.log,'Telephone Number => ' || l_phone_number);

473: fnd_file.put_line(fnd_file.log,'Address Line 3 => ' || l_address_line_3);
474: fnd_file.put_line(fnd_file.log,'Address Line 4 => ' || l_address_line_4);
475: fnd_file.put_line(fnd_file.log,'City => ' || l_city);
476: fnd_file.put_line(fnd_file.log,'Country => ' || l_country);
477: fnd_file.put_line(fnd_file.log,'Telephone Number => ' || l_phone_number);
478: fnd_file.put_line(fnd_file.log,'Postal Code => ' || l_postal_code);
479: fnd_file.put_line(fnd_file.log,'Currency Code => ' || l_func_curr);
480: fnd_file.put_line(fnd_file.log,'Reporting Status => ' || l_reporting_status);
481: fnd_file.put_line(fnd_file.log,'Period Start Date => ' || l_period_start_date);

Line 478: fnd_file.put_line(fnd_file.log,'Postal Code => ' || l_postal_code);

474: fnd_file.put_line(fnd_file.log,'Address Line 4 => ' || l_address_line_4);
475: fnd_file.put_line(fnd_file.log,'City => ' || l_city);
476: fnd_file.put_line(fnd_file.log,'Country => ' || l_country);
477: fnd_file.put_line(fnd_file.log,'Telephone Number => ' || l_phone_number);
478: fnd_file.put_line(fnd_file.log,'Postal Code => ' || l_postal_code);
479: fnd_file.put_line(fnd_file.log,'Currency Code => ' || l_func_curr);
480: fnd_file.put_line(fnd_file.log,'Reporting Status => ' || l_reporting_status);
481: fnd_file.put_line(fnd_file.log,'Period Start Date => ' || l_period_start_date);
482: fnd_file.put_line(fnd_file.log,'Period End Date => ' || l_period_end_date);

Line 479: fnd_file.put_line(fnd_file.log,'Currency Code => ' || l_func_curr);

475: fnd_file.put_line(fnd_file.log,'City => ' || l_city);
476: fnd_file.put_line(fnd_file.log,'Country => ' || l_country);
477: fnd_file.put_line(fnd_file.log,'Telephone Number => ' || l_phone_number);
478: fnd_file.put_line(fnd_file.log,'Postal Code => ' || l_postal_code);
479: fnd_file.put_line(fnd_file.log,'Currency Code => ' || l_func_curr);
480: fnd_file.put_line(fnd_file.log,'Reporting Status => ' || l_reporting_status);
481: fnd_file.put_line(fnd_file.log,'Period Start Date => ' || l_period_start_date);
482: fnd_file.put_line(fnd_file.log,'Period End Date => ' || l_period_end_date);
483: fnd_file.put_line(fnd_file.log,'l_tax_office_location => ' || l_tax_office_location);

Line 480: fnd_file.put_line(fnd_file.log,'Reporting Status => ' || l_reporting_status);

476: fnd_file.put_line(fnd_file.log,'Country => ' || l_country);
477: fnd_file.put_line(fnd_file.log,'Telephone Number => ' || l_phone_number);
478: fnd_file.put_line(fnd_file.log,'Postal Code => ' || l_postal_code);
479: fnd_file.put_line(fnd_file.log,'Currency Code => ' || l_func_curr);
480: fnd_file.put_line(fnd_file.log,'Reporting Status => ' || l_reporting_status);
481: fnd_file.put_line(fnd_file.log,'Period Start Date => ' || l_period_start_date);
482: fnd_file.put_line(fnd_file.log,'Period End Date => ' || l_period_end_date);
483: fnd_file.put_line(fnd_file.log,'l_tax_office_location => ' || l_tax_office_location);
484: fnd_file.put_line(fnd_file.log,'l_tax_office_code => ' || l_tax_office_code);

Line 481: fnd_file.put_line(fnd_file.log,'Period Start Date => ' || l_period_start_date);

477: fnd_file.put_line(fnd_file.log,'Telephone Number => ' || l_phone_number);
478: fnd_file.put_line(fnd_file.log,'Postal Code => ' || l_postal_code);
479: fnd_file.put_line(fnd_file.log,'Currency Code => ' || l_func_curr);
480: fnd_file.put_line(fnd_file.log,'Reporting Status => ' || l_reporting_status);
481: fnd_file.put_line(fnd_file.log,'Period Start Date => ' || l_period_start_date);
482: fnd_file.put_line(fnd_file.log,'Period End Date => ' || l_period_end_date);
483: fnd_file.put_line(fnd_file.log,'l_tax_office_location => ' || l_tax_office_location);
484: fnd_file.put_line(fnd_file.log,'l_tax_office_code => ' || l_tax_office_code);
485: END IF;

Line 482: fnd_file.put_line(fnd_file.log,'Period End Date => ' || l_period_end_date);

478: fnd_file.put_line(fnd_file.log,'Postal Code => ' || l_postal_code);
479: fnd_file.put_line(fnd_file.log,'Currency Code => ' || l_func_curr);
480: fnd_file.put_line(fnd_file.log,'Reporting Status => ' || l_reporting_status);
481: fnd_file.put_line(fnd_file.log,'Period Start Date => ' || l_period_start_date);
482: fnd_file.put_line(fnd_file.log,'Period End Date => ' || l_period_end_date);
483: fnd_file.put_line(fnd_file.log,'l_tax_office_location => ' || l_tax_office_location);
484: fnd_file.put_line(fnd_file.log,'l_tax_office_code => ' || l_tax_office_code);
485: END IF;
486:

Line 483: fnd_file.put_line(fnd_file.log,'l_tax_office_location => ' || l_tax_office_location);

479: fnd_file.put_line(fnd_file.log,'Currency Code => ' || l_func_curr);
480: fnd_file.put_line(fnd_file.log,'Reporting Status => ' || l_reporting_status);
481: fnd_file.put_line(fnd_file.log,'Period Start Date => ' || l_period_start_date);
482: fnd_file.put_line(fnd_file.log,'Period End Date => ' || l_period_end_date);
483: fnd_file.put_line(fnd_file.log,'l_tax_office_location => ' || l_tax_office_location);
484: fnd_file.put_line(fnd_file.log,'l_tax_office_code => ' || l_tax_office_code);
485: END IF;
486:
487:

Line 484: fnd_file.put_line(fnd_file.log,'l_tax_office_code => ' || l_tax_office_code);

480: fnd_file.put_line(fnd_file.log,'Reporting Status => ' || l_reporting_status);
481: fnd_file.put_line(fnd_file.log,'Period Start Date => ' || l_period_start_date);
482: fnd_file.put_line(fnd_file.log,'Period End Date => ' || l_period_end_date);
483: fnd_file.put_line(fnd_file.log,'l_tax_office_location => ' || l_tax_office_location);
484: fnd_file.put_line(fnd_file.log,'l_tax_office_code => ' || l_tax_office_code);
485: END IF;
486:
487:
488: -- Israel VAT Reporting 2010 - ER

Line 504: fnd_file.put_line(fnd_file.log,'Error Message :'||SUBSTR(SQLERRM,1,200));

500: l_vat_aggregation_limit_amt := cur_get_vat_aggregate_limit.VAT_AGGREGATE_LIMIT_AMT;
501: END LOOP;
502: EXCEPTION
503: WHEN OTHERS THEN
504: fnd_file.put_line(fnd_file.log,'Error Message :'||SUBSTR(SQLERRM,1,200));
505: END;
506:
507: BEGIN
508: select distinct nvl(jzvre.ledger_id,0)

Line 538: fnd_file.put_line(fnd_file.log,LOG_MESSAGE_MAIN);

534: IF l_vat_aggregation_limit_amt IS NULL THEN
535: fnd_message.set_name('JE', 'JE_IL_VAT_LIM_NOT_SET');
536: fnd_message.set_token('P_PERIOD', P_PERIOD);
537: LOG_MESSAGE_MAIN := fnd_message.get;
538: fnd_file.put_line(fnd_file.log,LOG_MESSAGE_MAIN);
539: raise_application_error(-20010,LOG_MESSAGE_MAIN);
540: END IF;
541: IF p_report_name = 'JEILR835' THEN null; --moved logic to jeilr835 procedure
542: ELSIF l_vat_rep_status_id IS NULL THEN

Line 546: fnd_file.put_line(fnd_file.log,LOG_MESSAGE_MAIN);

542: ELSIF l_vat_rep_status_id IS NULL THEN
543: fnd_message.set_name('JE', 'JE_IL_VAT_REP_NOT_RUN');
544: fnd_message.set_token('P_PERIOD', P_PERIOD);
545: LOG_MESSAGE_MAIN := fnd_message.get;
546: fnd_file.put_line(fnd_file.log,LOG_MESSAGE_MAIN);
547: select ENTITY_IDENTIFIER
548: into l_ent_name_main
549: from jg_zz_vat_rep_entities
550: where VAT_REPORTING_ENTITY_ID = P_VAT_REP_ENTITY_ID;

Line 551: fnd_file.put_line(fnd_file.log,'>>>>>'||l_ent_name_main);

547: select ENTITY_IDENTIFIER
548: into l_ent_name_main
549: from jg_zz_vat_rep_entities
550: where VAT_REPORTING_ENTITY_ID = P_VAT_REP_ENTITY_ID;
551: fnd_file.put_line(fnd_file.log,'>>>>>'||l_ent_name_main);
552: raise_application_error(-20010,LOG_MESSAGE_MAIN);
553: END IF;
554:
555: --Set the precision

Line 559: fnd_file.put_line(fnd_file.log,'VAT Aggregate Limit Amount '||to_char(l_vat_aggregation_limit_amt));

555: --Set the precision
556: g_precision := l_precision;
557:
558: IF p_debug_flag = 'Y' THEN
559: fnd_file.put_line(fnd_file.log,'VAT Aggregate Limit Amount '||to_char(l_vat_aggregation_limit_amt));
560: END IF;
561: IF p_debug_flag = 'Y' THEN
562: fnd_file.put_line(fnd_file.log,'Get Reporting Status ID '||to_char(l_vat_rep_status_id));
563: END IF;

Line 562: fnd_file.put_line(fnd_file.log,'Get Reporting Status ID '||to_char(l_vat_rep_status_id));

558: IF p_debug_flag = 'Y' THEN
559: fnd_file.put_line(fnd_file.log,'VAT Aggregate Limit Amount '||to_char(l_vat_aggregation_limit_amt));
560: END IF;
561: IF p_debug_flag = 'Y' THEN
562: fnd_file.put_line(fnd_file.log,'Get Reporting Status ID '||to_char(l_vat_rep_status_id));
563: END IF;
564:
565: -- Start ER 9155483 (Ichud Oskim)
566: IF p_report_name = 'JEILR835' THEN

Line 568: fnd_file.put_line(fnd_file.log,'Calling Procedure jeilr835');

564:
565: -- Start ER 9155483 (Ichud Oskim)
566: IF p_report_name = 'JEILR835' THEN
567: IF p_debug_flag = 'Y' THEN
568: fnd_file.put_line(fnd_file.log,'Calling Procedure jeilr835');
569: END IF;
570: jeilr835(p_vat_rep_entity_id => p_vat_rep_entity_id
571: ,p_vat_rep_entity_id2 => p_vat_rep_entity_id2
572: ,p_vat_rep_entity_id3 => p_vat_rep_entity_id3

Line 587: fnd_file.put_line(fnd_file.log,'Completed Call to Procedure jeilr835');

583: ,p_report_name => p_report_name
584: ,p_operation_code => p_operation_code
585: ,x_err_msg => l_err_msg);
586: IF p_debug_flag = 'Y' THEN
587: fnd_file.put_line(fnd_file.log,'Completed Call to Procedure jeilr835');
588: END IF;
589:
590: END IF;
591: -- End ER 9155483 (Ichud Oskim)

Line 595: fnd_file.put_line(fnd_file.log,'Calling Procedure jgbeva06');

591: -- End ER 9155483 (Ichud Oskim)
592:
593: ELSIF p_report_name = 'JEBEVA06' THEN
594: IF p_debug_flag = 'Y' THEN
595: fnd_file.put_line(fnd_file.log,'Calling Procedure jgbeva06');
596: END IF;
597: jebeva06(p_vat_rep_entity_id => p_vat_rep_entity_id
598: ,p_period => p_period
599: ,p_vat_box => p_vat_box

Line 607: fnd_file.put_line(fnd_file.log,'Completed Call to Procedure jgbava06');

603: ,p_doc_name => p_doc_name
604: ,p_doc_seq_value => p_doc_seq_value
605: ,x_err_msg => l_err_msg);
606: IF p_debug_flag = 'Y' THEN
607: fnd_file.put_line(fnd_file.log,'Completed Call to Procedure jgbava06');
608: END IF;
609: ELSIF p_report_name = 'JEPTAVAT' THEN
610: IF p_debug_flag = 'Y' THEN
611: fnd_file.put_line(fnd_file.log,'Calling Procedure JEPTAVAT');

Line 611: fnd_file.put_line(fnd_file.log,'Calling Procedure JEPTAVAT');

607: fnd_file.put_line(fnd_file.log,'Completed Call to Procedure jgbava06');
608: END IF;
609: ELSIF p_report_name = 'JEPTAVAT' THEN
610: IF p_debug_flag = 'Y' THEN
611: fnd_file.put_line(fnd_file.log,'Calling Procedure JEPTAVAT');
612: END IF;
613: jeptavat(p_vat_rep_entity_id => p_vat_rep_entity_id
614: ,p_period => p_period
615: ,p_location => p_location

Line 618: fnd_file.put_line(fnd_file.log,'Completed Call to Procedure JEPTAVAT');

614: ,p_period => p_period
615: ,p_location => p_location
616: ,x_err_msg => l_err_msg);
617: IF p_debug_flag = 'Y' THEN
618: fnd_file.put_line(fnd_file.log,'Completed Call to Procedure JEPTAVAT');
619: END IF;
620: ELSIF p_report_name = 'JEPTPVAT' THEN
621: IF p_debug_flag = 'Y' THEN
622: fnd_file.put_line(fnd_file.log,'Calling Procedure JEPTPVAT');

Line 622: fnd_file.put_line(fnd_file.log,'Calling Procedure JEPTPVAT');

618: fnd_file.put_line(fnd_file.log,'Completed Call to Procedure JEPTAVAT');
619: END IF;
620: ELSIF p_report_name = 'JEPTPVAT' THEN
621: IF p_debug_flag = 'Y' THEN
622: fnd_file.put_line(fnd_file.log,'Calling Procedure JEPTPVAT');
623: END IF;
624: jeptpvat(p_vat_rep_entity_id => p_vat_rep_entity_id
625: ,p_period => p_period
626: ,p_location => p_location

Line 629: fnd_file.put_line(fnd_file.log,'Completed Call to Procedure JEPTPVAT');

625: ,p_period => p_period
626: ,p_location => p_location
627: ,x_err_msg => l_err_msg);
628: IF p_debug_flag = 'Y' THEN
629: fnd_file.put_line(fnd_file.log,'Completed Call to Procedure JEPTPVAT');
630: END IF;
631: ELSIF p_report_name = 'JEITPSSR' THEN
632: IF p_debug_flag = 'Y' THEN
633: fnd_file.put_line(fnd_file.log,'Calling Procedure JEITPSSR');

Line 633: fnd_file.put_line(fnd_file.log,'Calling Procedure JEITPSSR');

629: fnd_file.put_line(fnd_file.log,'Completed Call to Procedure JEPTPVAT');
630: END IF;
631: ELSIF p_report_name = 'JEITPSSR' THEN
632: IF p_debug_flag = 'Y' THEN
633: fnd_file.put_line(fnd_file.log,'Calling Procedure JEITPSSR');
634: END IF;
635: jeitpssr(p_vat_rep_entity_id => p_vat_rep_entity_id
636: ,p_period => p_period
637: ,p_var_on_purchases => p_var_on_purchases

Line 641: fnd_file.put_line(fnd_file.log,'Completed Call to Procedure JEITPSSR');

637: ,p_var_on_purchases => p_var_on_purchases
638: ,p_var_on_sales => p_var_on_sales
639: ,x_err_msg => l_err_msg);
640: IF p_debug_flag = 'Y' THEN
641: fnd_file.put_line(fnd_file.log,'Completed Call to Procedure JEITPSSR');
642: END IF;
643: END IF;
644:
645: IF p_debug_flag = 'Y' THEN

Line 646: fnd_file.put_line(fnd_file.log,'End of Before Report');

642: END IF;
643: END IF;
644:
645: IF p_debug_flag = 'Y' THEN
646: fnd_file.put_line(fnd_file.log,'End of Before Report');
647: END IF;
648:
649: RETURN (TRUE);
650: EXCEPTION

Line 654: fnd_file.put_line(fnd_file.log,'Error in Before Report Trigger' || SQLCODE || SUBSTR(SQLERRM,1,200));

650: EXCEPTION
651: WHEN NO_DATA_FOUND THEN
652: RETURN (TRUE);
653: WHEN OTHERS THEN
654: fnd_file.put_line(fnd_file.log,'Error in Before Report Trigger' || SQLCODE || SUBSTR(SQLERRM,1,200));
655: raise;
656: RETURN (FALSE);
657: END before_report;
658:

Line 847: fnd_file.put_line(fnd_file.log,'Executing jg_zz_summary_all_pkg.jgbeva06');

843: t_invoice_amt NUMBER := 0.00000000000001;
844:
845: BEGIN
846: IF p_debug_flag = 'Y' THEN
847: fnd_file.put_line(fnd_file.log,'Executing jg_zz_summary_all_pkg.jgbeva06');
848: fnd_file.put_line(fnd_file.log,'Open Cursor C_BELGIAN_VAT');
849: END IF;
850: OPEN c_belgian_vat;
851: FETCH c_belgian_vat BULK COLLECT INTO v_box_amount;

Line 848: fnd_file.put_line(fnd_file.log,'Open Cursor C_BELGIAN_VAT');

844:
845: BEGIN
846: IF p_debug_flag = 'Y' THEN
847: fnd_file.put_line(fnd_file.log,'Executing jg_zz_summary_all_pkg.jgbeva06');
848: fnd_file.put_line(fnd_file.log,'Open Cursor C_BELGIAN_VAT');
849: END IF;
850: OPEN c_belgian_vat;
851: FETCH c_belgian_vat BULK COLLECT INTO v_box_amount;
852: CLOSE c_belgian_vat;

Line 972: fnd_file.put_line(fnd_file.log,'Period Year => ' || l_box_amount_grouped(i).period_year);

968:
969: FOR i IN 1..l_box_amount_grouped.COUNT
970: LOOP
971: IF p_debug_flag = 'Y' THEN
972: fnd_file.put_line(fnd_file.log,'Period Year => ' || l_box_amount_grouped(i).period_year);
973: fnd_file.put_line(fnd_file.log,'Period Name => ' || l_box_amount_grouped(i).period_name);
974: fnd_file.put_line(fnd_file.log,'VAT Report Box => ' || l_box_amount_grouped(i).vat_report_box);
975: fnd_file.put_line(fnd_file.log,'Box Descriptionc => ' || l_box_amount_grouped(i).vat_box_description);
976: fnd_file.put_line(fnd_file.log,'Source => ' || l_box_amount_grouped(i).source);

Line 973: fnd_file.put_line(fnd_file.log,'Period Name => ' || l_box_amount_grouped(i).period_name);

969: FOR i IN 1..l_box_amount_grouped.COUNT
970: LOOP
971: IF p_debug_flag = 'Y' THEN
972: fnd_file.put_line(fnd_file.log,'Period Year => ' || l_box_amount_grouped(i).period_year);
973: fnd_file.put_line(fnd_file.log,'Period Name => ' || l_box_amount_grouped(i).period_name);
974: fnd_file.put_line(fnd_file.log,'VAT Report Box => ' || l_box_amount_grouped(i).vat_report_box);
975: fnd_file.put_line(fnd_file.log,'Box Descriptionc => ' || l_box_amount_grouped(i).vat_box_description);
976: fnd_file.put_line(fnd_file.log,'Source => ' || l_box_amount_grouped(i).source);
977: fnd_file.put_line(fnd_file.log,'Document Name => ' || l_box_amount_grouped(i).document_seq_name);

Line 974: fnd_file.put_line(fnd_file.log,'VAT Report Box => ' || l_box_amount_grouped(i).vat_report_box);

970: LOOP
971: IF p_debug_flag = 'Y' THEN
972: fnd_file.put_line(fnd_file.log,'Period Year => ' || l_box_amount_grouped(i).period_year);
973: fnd_file.put_line(fnd_file.log,'Period Name => ' || l_box_amount_grouped(i).period_name);
974: fnd_file.put_line(fnd_file.log,'VAT Report Box => ' || l_box_amount_grouped(i).vat_report_box);
975: fnd_file.put_line(fnd_file.log,'Box Descriptionc => ' || l_box_amount_grouped(i).vat_box_description);
976: fnd_file.put_line(fnd_file.log,'Source => ' || l_box_amount_grouped(i).source);
977: fnd_file.put_line(fnd_file.log,'Document Name => ' || l_box_amount_grouped(i).document_seq_name);
978: fnd_file.put_line(fnd_file.log,'Documemt Value => ' || l_box_amount_grouped(i).document_seq_value);

Line 975: fnd_file.put_line(fnd_file.log,'Box Descriptionc => ' || l_box_amount_grouped(i).vat_box_description);

971: IF p_debug_flag = 'Y' THEN
972: fnd_file.put_line(fnd_file.log,'Period Year => ' || l_box_amount_grouped(i).period_year);
973: fnd_file.put_line(fnd_file.log,'Period Name => ' || l_box_amount_grouped(i).period_name);
974: fnd_file.put_line(fnd_file.log,'VAT Report Box => ' || l_box_amount_grouped(i).vat_report_box);
975: fnd_file.put_line(fnd_file.log,'Box Descriptionc => ' || l_box_amount_grouped(i).vat_box_description);
976: fnd_file.put_line(fnd_file.log,'Source => ' || l_box_amount_grouped(i).source);
977: fnd_file.put_line(fnd_file.log,'Document Name => ' || l_box_amount_grouped(i).document_seq_name);
978: fnd_file.put_line(fnd_file.log,'Documemt Value => ' || l_box_amount_grouped(i).document_seq_value);
979: fnd_file.put_line(fnd_file.log,'GL Date => ' || l_box_amount_grouped(i).gl_date);

Line 976: fnd_file.put_line(fnd_file.log,'Source => ' || l_box_amount_grouped(i).source);

972: fnd_file.put_line(fnd_file.log,'Period Year => ' || l_box_amount_grouped(i).period_year);
973: fnd_file.put_line(fnd_file.log,'Period Name => ' || l_box_amount_grouped(i).period_name);
974: fnd_file.put_line(fnd_file.log,'VAT Report Box => ' || l_box_amount_grouped(i).vat_report_box);
975: fnd_file.put_line(fnd_file.log,'Box Descriptionc => ' || l_box_amount_grouped(i).vat_box_description);
976: fnd_file.put_line(fnd_file.log,'Source => ' || l_box_amount_grouped(i).source);
977: fnd_file.put_line(fnd_file.log,'Document Name => ' || l_box_amount_grouped(i).document_seq_name);
978: fnd_file.put_line(fnd_file.log,'Documemt Value => ' || l_box_amount_grouped(i).document_seq_value);
979: fnd_file.put_line(fnd_file.log,'GL Date => ' || l_box_amount_grouped(i).gl_date);
980: fnd_file.put_line(fnd_file.log,'Vendor Number => ' || l_box_amount_grouped(i).trading_partner_number);

Line 977: fnd_file.put_line(fnd_file.log,'Document Name => ' || l_box_amount_grouped(i).document_seq_name);

973: fnd_file.put_line(fnd_file.log,'Period Name => ' || l_box_amount_grouped(i).period_name);
974: fnd_file.put_line(fnd_file.log,'VAT Report Box => ' || l_box_amount_grouped(i).vat_report_box);
975: fnd_file.put_line(fnd_file.log,'Box Descriptionc => ' || l_box_amount_grouped(i).vat_box_description);
976: fnd_file.put_line(fnd_file.log,'Source => ' || l_box_amount_grouped(i).source);
977: fnd_file.put_line(fnd_file.log,'Document Name => ' || l_box_amount_grouped(i).document_seq_name);
978: fnd_file.put_line(fnd_file.log,'Documemt Value => ' || l_box_amount_grouped(i).document_seq_value);
979: fnd_file.put_line(fnd_file.log,'GL Date => ' || l_box_amount_grouped(i).gl_date);
980: fnd_file.put_line(fnd_file.log,'Vendor Number => ' || l_box_amount_grouped(i).trading_partner_number);
981: fnd_file.put_line(fnd_file.log,'Vendor_Name => ' || l_box_amount_grouped(i).trading_partner_name);

Line 978: fnd_file.put_line(fnd_file.log,'Documemt Value => ' || l_box_amount_grouped(i).document_seq_value);

974: fnd_file.put_line(fnd_file.log,'VAT Report Box => ' || l_box_amount_grouped(i).vat_report_box);
975: fnd_file.put_line(fnd_file.log,'Box Descriptionc => ' || l_box_amount_grouped(i).vat_box_description);
976: fnd_file.put_line(fnd_file.log,'Source => ' || l_box_amount_grouped(i).source);
977: fnd_file.put_line(fnd_file.log,'Document Name => ' || l_box_amount_grouped(i).document_seq_name);
978: fnd_file.put_line(fnd_file.log,'Documemt Value => ' || l_box_amount_grouped(i).document_seq_value);
979: fnd_file.put_line(fnd_file.log,'GL Date => ' || l_box_amount_grouped(i).gl_date);
980: fnd_file.put_line(fnd_file.log,'Vendor Number => ' || l_box_amount_grouped(i).trading_partner_number);
981: fnd_file.put_line(fnd_file.log,'Vendor_Name => ' || l_box_amount_grouped(i).trading_partner_name);
982: fnd_file.put_line(fnd_file.log,'Invoice Number => ' || l_box_amount_grouped(i).invoice);

Line 979: fnd_file.put_line(fnd_file.log,'GL Date => ' || l_box_amount_grouped(i).gl_date);

975: fnd_file.put_line(fnd_file.log,'Box Descriptionc => ' || l_box_amount_grouped(i).vat_box_description);
976: fnd_file.put_line(fnd_file.log,'Source => ' || l_box_amount_grouped(i).source);
977: fnd_file.put_line(fnd_file.log,'Document Name => ' || l_box_amount_grouped(i).document_seq_name);
978: fnd_file.put_line(fnd_file.log,'Documemt Value => ' || l_box_amount_grouped(i).document_seq_value);
979: fnd_file.put_line(fnd_file.log,'GL Date => ' || l_box_amount_grouped(i).gl_date);
980: fnd_file.put_line(fnd_file.log,'Vendor Number => ' || l_box_amount_grouped(i).trading_partner_number);
981: fnd_file.put_line(fnd_file.log,'Vendor_Name => ' || l_box_amount_grouped(i).trading_partner_name);
982: fnd_file.put_line(fnd_file.log,'Invoice Number => ' || l_box_amount_grouped(i).invoice);
983: fnd_file.put_line(fnd_file.log,'Line Number => ' || l_box_amount_grouped(i).line_number);

Line 980: fnd_file.put_line(fnd_file.log,'Vendor Number => ' || l_box_amount_grouped(i).trading_partner_number);

976: fnd_file.put_line(fnd_file.log,'Source => ' || l_box_amount_grouped(i).source);
977: fnd_file.put_line(fnd_file.log,'Document Name => ' || l_box_amount_grouped(i).document_seq_name);
978: fnd_file.put_line(fnd_file.log,'Documemt Value => ' || l_box_amount_grouped(i).document_seq_value);
979: fnd_file.put_line(fnd_file.log,'GL Date => ' || l_box_amount_grouped(i).gl_date);
980: fnd_file.put_line(fnd_file.log,'Vendor Number => ' || l_box_amount_grouped(i).trading_partner_number);
981: fnd_file.put_line(fnd_file.log,'Vendor_Name => ' || l_box_amount_grouped(i).trading_partner_name);
982: fnd_file.put_line(fnd_file.log,'Invoice Number => ' || l_box_amount_grouped(i).invoice);
983: fnd_file.put_line(fnd_file.log,'Line Number => ' || l_box_amount_grouped(i).line_number);
984: fnd_file.put_line(fnd_file.log,'VAT Code => ' || l_box_amount_grouped(i).vat_code);

Line 981: fnd_file.put_line(fnd_file.log,'Vendor_Name => ' || l_box_amount_grouped(i).trading_partner_name);

977: fnd_file.put_line(fnd_file.log,'Document Name => ' || l_box_amount_grouped(i).document_seq_name);
978: fnd_file.put_line(fnd_file.log,'Documemt Value => ' || l_box_amount_grouped(i).document_seq_value);
979: fnd_file.put_line(fnd_file.log,'GL Date => ' || l_box_amount_grouped(i).gl_date);
980: fnd_file.put_line(fnd_file.log,'Vendor Number => ' || l_box_amount_grouped(i).trading_partner_number);
981: fnd_file.put_line(fnd_file.log,'Vendor_Name => ' || l_box_amount_grouped(i).trading_partner_name);
982: fnd_file.put_line(fnd_file.log,'Invoice Number => ' || l_box_amount_grouped(i).invoice);
983: fnd_file.put_line(fnd_file.log,'Line Number => ' || l_box_amount_grouped(i).line_number);
984: fnd_file.put_line(fnd_file.log,'VAT Code => ' || l_box_amount_grouped(i).vat_code);
985: fnd_file.put_line(fnd_file.log,'VAT Trans Type => ' || l_box_amount_grouped(i).vat_transaction_type);

Line 982: fnd_file.put_line(fnd_file.log,'Invoice Number => ' || l_box_amount_grouped(i).invoice);

978: fnd_file.put_line(fnd_file.log,'Documemt Value => ' || l_box_amount_grouped(i).document_seq_value);
979: fnd_file.put_line(fnd_file.log,'GL Date => ' || l_box_amount_grouped(i).gl_date);
980: fnd_file.put_line(fnd_file.log,'Vendor Number => ' || l_box_amount_grouped(i).trading_partner_number);
981: fnd_file.put_line(fnd_file.log,'Vendor_Name => ' || l_box_amount_grouped(i).trading_partner_name);
982: fnd_file.put_line(fnd_file.log,'Invoice Number => ' || l_box_amount_grouped(i).invoice);
983: fnd_file.put_line(fnd_file.log,'Line Number => ' || l_box_amount_grouped(i).line_number);
984: fnd_file.put_line(fnd_file.log,'VAT Code => ' || l_box_amount_grouped(i).vat_code);
985: fnd_file.put_line(fnd_file.log,'VAT Trans Type => ' || l_box_amount_grouped(i).vat_transaction_type);
986: fnd_file.put_line(fnd_file.log,'Taxable Amount => ' || l_box_amount_grouped(i).taxable_amount);

Line 983: fnd_file.put_line(fnd_file.log,'Line Number => ' || l_box_amount_grouped(i).line_number);

979: fnd_file.put_line(fnd_file.log,'GL Date => ' || l_box_amount_grouped(i).gl_date);
980: fnd_file.put_line(fnd_file.log,'Vendor Number => ' || l_box_amount_grouped(i).trading_partner_number);
981: fnd_file.put_line(fnd_file.log,'Vendor_Name => ' || l_box_amount_grouped(i).trading_partner_name);
982: fnd_file.put_line(fnd_file.log,'Invoice Number => ' || l_box_amount_grouped(i).invoice);
983: fnd_file.put_line(fnd_file.log,'Line Number => ' || l_box_amount_grouped(i).line_number);
984: fnd_file.put_line(fnd_file.log,'VAT Code => ' || l_box_amount_grouped(i).vat_code);
985: fnd_file.put_line(fnd_file.log,'VAT Trans Type => ' || l_box_amount_grouped(i).vat_transaction_type);
986: fnd_file.put_line(fnd_file.log,'Taxable Amount => ' || l_box_amount_grouped(i).taxable_amount);
987: fnd_file.put_line(fnd_file.log,'Tax Amount => ' || l_box_amount_grouped(i).tax_amount);

Line 984: fnd_file.put_line(fnd_file.log,'VAT Code => ' || l_box_amount_grouped(i).vat_code);

980: fnd_file.put_line(fnd_file.log,'Vendor Number => ' || l_box_amount_grouped(i).trading_partner_number);
981: fnd_file.put_line(fnd_file.log,'Vendor_Name => ' || l_box_amount_grouped(i).trading_partner_name);
982: fnd_file.put_line(fnd_file.log,'Invoice Number => ' || l_box_amount_grouped(i).invoice);
983: fnd_file.put_line(fnd_file.log,'Line Number => ' || l_box_amount_grouped(i).line_number);
984: fnd_file.put_line(fnd_file.log,'VAT Code => ' || l_box_amount_grouped(i).vat_code);
985: fnd_file.put_line(fnd_file.log,'VAT Trans Type => ' || l_box_amount_grouped(i).vat_transaction_type);
986: fnd_file.put_line(fnd_file.log,'Taxable Amount => ' || l_box_amount_grouped(i).taxable_amount);
987: fnd_file.put_line(fnd_file.log,'Tax Amount => ' || l_box_amount_grouped(i).tax_amount);
988: END IF;

Line 985: fnd_file.put_line(fnd_file.log,'VAT Trans Type => ' || l_box_amount_grouped(i).vat_transaction_type);

981: fnd_file.put_line(fnd_file.log,'Vendor_Name => ' || l_box_amount_grouped(i).trading_partner_name);
982: fnd_file.put_line(fnd_file.log,'Invoice Number => ' || l_box_amount_grouped(i).invoice);
983: fnd_file.put_line(fnd_file.log,'Line Number => ' || l_box_amount_grouped(i).line_number);
984: fnd_file.put_line(fnd_file.log,'VAT Code => ' || l_box_amount_grouped(i).vat_code);
985: fnd_file.put_line(fnd_file.log,'VAT Trans Type => ' || l_box_amount_grouped(i).vat_transaction_type);
986: fnd_file.put_line(fnd_file.log,'Taxable Amount => ' || l_box_amount_grouped(i).taxable_amount);
987: fnd_file.put_line(fnd_file.log,'Tax Amount => ' || l_box_amount_grouped(i).tax_amount);
988: END IF;
989:

Line 986: fnd_file.put_line(fnd_file.log,'Taxable Amount => ' || l_box_amount_grouped(i).taxable_amount);

982: fnd_file.put_line(fnd_file.log,'Invoice Number => ' || l_box_amount_grouped(i).invoice);
983: fnd_file.put_line(fnd_file.log,'Line Number => ' || l_box_amount_grouped(i).line_number);
984: fnd_file.put_line(fnd_file.log,'VAT Code => ' || l_box_amount_grouped(i).vat_code);
985: fnd_file.put_line(fnd_file.log,'VAT Trans Type => ' || l_box_amount_grouped(i).vat_transaction_type);
986: fnd_file.put_line(fnd_file.log,'Taxable Amount => ' || l_box_amount_grouped(i).taxable_amount);
987: fnd_file.put_line(fnd_file.log,'Tax Amount => ' || l_box_amount_grouped(i).tax_amount);
988: END IF;
989:
990: IF l_box_amount_grouped(i).taxable_amount IS NOT NULL OR

Line 987: fnd_file.put_line(fnd_file.log,'Tax Amount => ' || l_box_amount_grouped(i).tax_amount);

983: fnd_file.put_line(fnd_file.log,'Line Number => ' || l_box_amount_grouped(i).line_number);
984: fnd_file.put_line(fnd_file.log,'VAT Code => ' || l_box_amount_grouped(i).vat_code);
985: fnd_file.put_line(fnd_file.log,'VAT Trans Type => ' || l_box_amount_grouped(i).vat_transaction_type);
986: fnd_file.put_line(fnd_file.log,'Taxable Amount => ' || l_box_amount_grouped(i).taxable_amount);
987: fnd_file.put_line(fnd_file.log,'Tax Amount => ' || l_box_amount_grouped(i).tax_amount);
988: END IF;
989:
990: IF l_box_amount_grouped(i).taxable_amount IS NOT NULL OR
991: l_box_amount_grouped(i).tax_amount IS NOT NULL THEN

Line 1037: fnd_file.put_line(fnd_file.log,'Number of records inserted into jg_zz_vat_trx_gt table: ' || l_count );

1033: END LOOP;
1034:
1035: SELECT count(*) into l_count from jg_zz_vat_trx_gt ;
1036: IF p_debug_flag = 'Y' THEN
1037: fnd_file.put_line(fnd_file.log,'Number of records inserted into jg_zz_vat_trx_gt table: ' || l_count );
1038: fnd_file.put_line(fnd_file.log,'Completed procedure jg_zz_summary_all_pkg.jgbeva06');
1039: END IF;
1040: EXCEPTION
1041: WHEN OTHERS THEN

Line 1038: fnd_file.put_line(fnd_file.log,'Completed procedure jg_zz_summary_all_pkg.jgbeva06');

1034:
1035: SELECT count(*) into l_count from jg_zz_vat_trx_gt ;
1036: IF p_debug_flag = 'Y' THEN
1037: fnd_file.put_line(fnd_file.log,'Number of records inserted into jg_zz_vat_trx_gt table: ' || l_count );
1038: fnd_file.put_line(fnd_file.log,'Completed procedure jg_zz_summary_all_pkg.jgbeva06');
1039: END IF;
1040: EXCEPTION
1041: WHEN OTHERS THEN
1042: fnd_file.put_line(fnd_file.log,'Error in Procedure jg_zz_summary_all_pkg.jebeva06 ' || SUBSTR(SQLERRM,1,200));

Line 1042: fnd_file.put_line(fnd_file.log,'Error in Procedure jg_zz_summary_all_pkg.jebeva06 ' || SUBSTR(SQLERRM,1,200));

1038: fnd_file.put_line(fnd_file.log,'Completed procedure jg_zz_summary_all_pkg.jgbeva06');
1039: END IF;
1040: EXCEPTION
1041: WHEN OTHERS THEN
1042: fnd_file.put_line(fnd_file.log,'Error in Procedure jg_zz_summary_all_pkg.jebeva06 ' || SUBSTR(SQLERRM,1,200));
1043: RAISE;
1044: END jebeva06;
1045:
1046: --

Line 1180: fnd_file.put_line(fnd_file.log,'---- Trans Id ------ '||l_pt_avat.transaction_id||'-----');

1176: -- Set data flag to yes
1177: l_data_found := 'Y';
1178:
1179: IF p_debug_flag = 'Y' then
1180: fnd_file.put_line(fnd_file.log,'---- Trans Id ------ '||l_pt_avat.transaction_id||'-----');
1181: fnd_file.put_line(fnd_file.log,'---- Trans Number--- '||l_pt_avat.trx_number||'-----');
1182: fnd_file.put_line(fnd_file.log,'Tax class information: ' || l_pt_avat.tax_class);
1183: fnd_file.put_line(fnd_file.log,'Tax Recovery Rate: ' ||l_pt_avat.tax_recv_rate);
1184: fnd_file.put_line(fnd_file.log,'Tax Recoverable Flag : '||l_pt_avat.tax_recoverable_flag);

Line 1181: fnd_file.put_line(fnd_file.log,'---- Trans Number--- '||l_pt_avat.trx_number||'-----');

1177: l_data_found := 'Y';
1178:
1179: IF p_debug_flag = 'Y' then
1180: fnd_file.put_line(fnd_file.log,'---- Trans Id ------ '||l_pt_avat.transaction_id||'-----');
1181: fnd_file.put_line(fnd_file.log,'---- Trans Number--- '||l_pt_avat.trx_number||'-----');
1182: fnd_file.put_line(fnd_file.log,'Tax class information: ' || l_pt_avat.tax_class);
1183: fnd_file.put_line(fnd_file.log,'Tax Recovery Rate: ' ||l_pt_avat.tax_recv_rate);
1184: fnd_file.put_line(fnd_file.log,'Tax Recoverable Flag : '||l_pt_avat.tax_recoverable_flag);
1185: fnd_file.put_line(fnd_file.log,'Taxable box: ' ||l_pt_avat.txbl_nrc_box);

Line 1182: fnd_file.put_line(fnd_file.log,'Tax class information: ' || l_pt_avat.tax_class);

1178:
1179: IF p_debug_flag = 'Y' then
1180: fnd_file.put_line(fnd_file.log,'---- Trans Id ------ '||l_pt_avat.transaction_id||'-----');
1181: fnd_file.put_line(fnd_file.log,'---- Trans Number--- '||l_pt_avat.trx_number||'-----');
1182: fnd_file.put_line(fnd_file.log,'Tax class information: ' || l_pt_avat.tax_class);
1183: fnd_file.put_line(fnd_file.log,'Tax Recovery Rate: ' ||l_pt_avat.tax_recv_rate);
1184: fnd_file.put_line(fnd_file.log,'Tax Recoverable Flag : '||l_pt_avat.tax_recoverable_flag);
1185: fnd_file.put_line(fnd_file.log,'Taxable box: ' ||l_pt_avat.txbl_nrc_box);
1186: fnd_file.put_line(fnd_file.log,'Taxable amount: ' ||l_pt_avat.txbl_nrc_amount);

Line 1183: fnd_file.put_line(fnd_file.log,'Tax Recovery Rate: ' ||l_pt_avat.tax_recv_rate);

1179: IF p_debug_flag = 'Y' then
1180: fnd_file.put_line(fnd_file.log,'---- Trans Id ------ '||l_pt_avat.transaction_id||'-----');
1181: fnd_file.put_line(fnd_file.log,'---- Trans Number--- '||l_pt_avat.trx_number||'-----');
1182: fnd_file.put_line(fnd_file.log,'Tax class information: ' || l_pt_avat.tax_class);
1183: fnd_file.put_line(fnd_file.log,'Tax Recovery Rate: ' ||l_pt_avat.tax_recv_rate);
1184: fnd_file.put_line(fnd_file.log,'Tax Recoverable Flag : '||l_pt_avat.tax_recoverable_flag);
1185: fnd_file.put_line(fnd_file.log,'Taxable box: ' ||l_pt_avat.txbl_nrc_box);
1186: fnd_file.put_line(fnd_file.log,'Taxable amount: ' ||l_pt_avat.txbl_nrc_amount);
1187: fnd_file.put_line(fnd_file.log,'Tax box: ' || l_pt_avat.tax_box);

Line 1184: fnd_file.put_line(fnd_file.log,'Tax Recoverable Flag : '||l_pt_avat.tax_recoverable_flag);

1180: fnd_file.put_line(fnd_file.log,'---- Trans Id ------ '||l_pt_avat.transaction_id||'-----');
1181: fnd_file.put_line(fnd_file.log,'---- Trans Number--- '||l_pt_avat.trx_number||'-----');
1182: fnd_file.put_line(fnd_file.log,'Tax class information: ' || l_pt_avat.tax_class);
1183: fnd_file.put_line(fnd_file.log,'Tax Recovery Rate: ' ||l_pt_avat.tax_recv_rate);
1184: fnd_file.put_line(fnd_file.log,'Tax Recoverable Flag : '||l_pt_avat.tax_recoverable_flag);
1185: fnd_file.put_line(fnd_file.log,'Taxable box: ' ||l_pt_avat.txbl_nrc_box);
1186: fnd_file.put_line(fnd_file.log,'Taxable amount: ' ||l_pt_avat.txbl_nrc_amount);
1187: fnd_file.put_line(fnd_file.log,'Tax box: ' || l_pt_avat.tax_box);
1188: fnd_file.put_line(fnd_file.log,'Tax Amount: '||l_pt_avat.tax_amount);

Line 1185: fnd_file.put_line(fnd_file.log,'Taxable box: ' ||l_pt_avat.txbl_nrc_box);

1181: fnd_file.put_line(fnd_file.log,'---- Trans Number--- '||l_pt_avat.trx_number||'-----');
1182: fnd_file.put_line(fnd_file.log,'Tax class information: ' || l_pt_avat.tax_class);
1183: fnd_file.put_line(fnd_file.log,'Tax Recovery Rate: ' ||l_pt_avat.tax_recv_rate);
1184: fnd_file.put_line(fnd_file.log,'Tax Recoverable Flag : '||l_pt_avat.tax_recoverable_flag);
1185: fnd_file.put_line(fnd_file.log,'Taxable box: ' ||l_pt_avat.txbl_nrc_box);
1186: fnd_file.put_line(fnd_file.log,'Taxable amount: ' ||l_pt_avat.txbl_nrc_amount);
1187: fnd_file.put_line(fnd_file.log,'Tax box: ' || l_pt_avat.tax_box);
1188: fnd_file.put_line(fnd_file.log,'Tax Amount: '||l_pt_avat.tax_amount);
1189: fnd_file.put_line(fnd_file.log,'Total box: '|| l_pt_avat.total_box);

Line 1186: fnd_file.put_line(fnd_file.log,'Taxable amount: ' ||l_pt_avat.txbl_nrc_amount);

1182: fnd_file.put_line(fnd_file.log,'Tax class information: ' || l_pt_avat.tax_class);
1183: fnd_file.put_line(fnd_file.log,'Tax Recovery Rate: ' ||l_pt_avat.tax_recv_rate);
1184: fnd_file.put_line(fnd_file.log,'Tax Recoverable Flag : '||l_pt_avat.tax_recoverable_flag);
1185: fnd_file.put_line(fnd_file.log,'Taxable box: ' ||l_pt_avat.txbl_nrc_box);
1186: fnd_file.put_line(fnd_file.log,'Taxable amount: ' ||l_pt_avat.txbl_nrc_amount);
1187: fnd_file.put_line(fnd_file.log,'Tax box: ' || l_pt_avat.tax_box);
1188: fnd_file.put_line(fnd_file.log,'Tax Amount: '||l_pt_avat.tax_amount);
1189: fnd_file.put_line(fnd_file.log,'Total box: '|| l_pt_avat.total_box);
1190: fnd_file.put_line(fnd_file.log,'Tax rate: ' || l_pt_avat.tax_rate);

Line 1187: fnd_file.put_line(fnd_file.log,'Tax box: ' || l_pt_avat.tax_box);

1183: fnd_file.put_line(fnd_file.log,'Tax Recovery Rate: ' ||l_pt_avat.tax_recv_rate);
1184: fnd_file.put_line(fnd_file.log,'Tax Recoverable Flag : '||l_pt_avat.tax_recoverable_flag);
1185: fnd_file.put_line(fnd_file.log,'Taxable box: ' ||l_pt_avat.txbl_nrc_box);
1186: fnd_file.put_line(fnd_file.log,'Taxable amount: ' ||l_pt_avat.txbl_nrc_amount);
1187: fnd_file.put_line(fnd_file.log,'Tax box: ' || l_pt_avat.tax_box);
1188: fnd_file.put_line(fnd_file.log,'Tax Amount: '||l_pt_avat.tax_amount);
1189: fnd_file.put_line(fnd_file.log,'Total box: '|| l_pt_avat.total_box);
1190: fnd_file.put_line(fnd_file.log,'Tax rate: ' || l_pt_avat.tax_rate);
1191: fnd_file.put_line(fnd_file.log,'Tax code: ' || l_pt_avat.tax_code_rate);

Line 1188: fnd_file.put_line(fnd_file.log,'Tax Amount: '||l_pt_avat.tax_amount);

1184: fnd_file.put_line(fnd_file.log,'Tax Recoverable Flag : '||l_pt_avat.tax_recoverable_flag);
1185: fnd_file.put_line(fnd_file.log,'Taxable box: ' ||l_pt_avat.txbl_nrc_box);
1186: fnd_file.put_line(fnd_file.log,'Taxable amount: ' ||l_pt_avat.txbl_nrc_amount);
1187: fnd_file.put_line(fnd_file.log,'Tax box: ' || l_pt_avat.tax_box);
1188: fnd_file.put_line(fnd_file.log,'Tax Amount: '||l_pt_avat.tax_amount);
1189: fnd_file.put_line(fnd_file.log,'Total box: '|| l_pt_avat.total_box);
1190: fnd_file.put_line(fnd_file.log,'Tax rate: ' || l_pt_avat.tax_rate);
1191: fnd_file.put_line(fnd_file.log,'Tax code: ' || l_pt_avat.tax_code_rate);
1192: fnd_file.put_line(fnd_file.log,'Extract Source Ledger: ' || l_pt_avat.extract_source_ledger);

Line 1189: fnd_file.put_line(fnd_file.log,'Total box: '|| l_pt_avat.total_box);

1185: fnd_file.put_line(fnd_file.log,'Taxable box: ' ||l_pt_avat.txbl_nrc_box);
1186: fnd_file.put_line(fnd_file.log,'Taxable amount: ' ||l_pt_avat.txbl_nrc_amount);
1187: fnd_file.put_line(fnd_file.log,'Tax box: ' || l_pt_avat.tax_box);
1188: fnd_file.put_line(fnd_file.log,'Tax Amount: '||l_pt_avat.tax_amount);
1189: fnd_file.put_line(fnd_file.log,'Total box: '|| l_pt_avat.total_box);
1190: fnd_file.put_line(fnd_file.log,'Tax rate: ' || l_pt_avat.tax_rate);
1191: fnd_file.put_line(fnd_file.log,'Tax code: ' || l_pt_avat.tax_code_rate);
1192: fnd_file.put_line(fnd_file.log,'Extract Source Ledger: ' || l_pt_avat.extract_source_ledger);
1193: fnd_file.put_line(fnd_file.log,'Allocation Rule ID: ' || l_pt_avat.allocation_rule_id);

Line 1190: fnd_file.put_line(fnd_file.log,'Tax rate: ' || l_pt_avat.tax_rate);

1186: fnd_file.put_line(fnd_file.log,'Taxable amount: ' ||l_pt_avat.txbl_nrc_amount);
1187: fnd_file.put_line(fnd_file.log,'Tax box: ' || l_pt_avat.tax_box);
1188: fnd_file.put_line(fnd_file.log,'Tax Amount: '||l_pt_avat.tax_amount);
1189: fnd_file.put_line(fnd_file.log,'Total box: '|| l_pt_avat.total_box);
1190: fnd_file.put_line(fnd_file.log,'Tax rate: ' || l_pt_avat.tax_rate);
1191: fnd_file.put_line(fnd_file.log,'Tax code: ' || l_pt_avat.tax_code_rate);
1192: fnd_file.put_line(fnd_file.log,'Extract Source Ledger: ' || l_pt_avat.extract_source_ledger);
1193: fnd_file.put_line(fnd_file.log,'Allocation Rule ID: ' || l_pt_avat.allocation_rule_id);
1194:

Line 1191: fnd_file.put_line(fnd_file.log,'Tax code: ' || l_pt_avat.tax_code_rate);

1187: fnd_file.put_line(fnd_file.log,'Tax box: ' || l_pt_avat.tax_box);
1188: fnd_file.put_line(fnd_file.log,'Tax Amount: '||l_pt_avat.tax_amount);
1189: fnd_file.put_line(fnd_file.log,'Total box: '|| l_pt_avat.total_box);
1190: fnd_file.put_line(fnd_file.log,'Tax rate: ' || l_pt_avat.tax_rate);
1191: fnd_file.put_line(fnd_file.log,'Tax code: ' || l_pt_avat.tax_code_rate);
1192: fnd_file.put_line(fnd_file.log,'Extract Source Ledger: ' || l_pt_avat.extract_source_ledger);
1193: fnd_file.put_line(fnd_file.log,'Allocation Rule ID: ' || l_pt_avat.allocation_rule_id);
1194:
1195: END IF;

Line 1192: fnd_file.put_line(fnd_file.log,'Extract Source Ledger: ' || l_pt_avat.extract_source_ledger);

1188: fnd_file.put_line(fnd_file.log,'Tax Amount: '||l_pt_avat.tax_amount);
1189: fnd_file.put_line(fnd_file.log,'Total box: '|| l_pt_avat.total_box);
1190: fnd_file.put_line(fnd_file.log,'Tax rate: ' || l_pt_avat.tax_rate);
1191: fnd_file.put_line(fnd_file.log,'Tax code: ' || l_pt_avat.tax_code_rate);
1192: fnd_file.put_line(fnd_file.log,'Extract Source Ledger: ' || l_pt_avat.extract_source_ledger);
1193: fnd_file.put_line(fnd_file.log,'Allocation Rule ID: ' || l_pt_avat.allocation_rule_id);
1194:
1195: END IF;
1196:

Line 1193: fnd_file.put_line(fnd_file.log,'Allocation Rule ID: ' || l_pt_avat.allocation_rule_id);

1189: fnd_file.put_line(fnd_file.log,'Total box: '|| l_pt_avat.total_box);
1190: fnd_file.put_line(fnd_file.log,'Tax rate: ' || l_pt_avat.tax_rate);
1191: fnd_file.put_line(fnd_file.log,'Tax code: ' || l_pt_avat.tax_code_rate);
1192: fnd_file.put_line(fnd_file.log,'Extract Source Ledger: ' || l_pt_avat.extract_source_ledger);
1193: fnd_file.put_line(fnd_file.log,'Allocation Rule ID: ' || l_pt_avat.allocation_rule_id);
1194:
1195: END IF;
1196:
1197: END LOOP;

Line 1203: fnd_file.put_line(fnd_file.log,'-----------------------------------');

1199: IF l_data_found = 'Y' THEN
1200: FOR i in v_box_amounts.FIRST .. v_box_amounts.LAST LOOP
1201:
1202: IF p_debug_flag = 'Y' and v_box_amounts.EXISTS(i) and i <> 1000 THEN
1203: fnd_file.put_line(fnd_file.log,'-----------------------------------');
1204: IF i > 1000 THEN
1205: fnd_file.put_line(fnd_file.log,' Box Num =>'||floor(i/10000));
1206: ELSE
1207: fnd_file.put_line(fnd_file.log,' Box Num =>'||i);

Line 1205: fnd_file.put_line(fnd_file.log,' Box Num =>'||floor(i/10000));

1201:
1202: IF p_debug_flag = 'Y' and v_box_amounts.EXISTS(i) and i <> 1000 THEN
1203: fnd_file.put_line(fnd_file.log,'-----------------------------------');
1204: IF i > 1000 THEN
1205: fnd_file.put_line(fnd_file.log,' Box Num =>'||floor(i/10000));
1206: ELSE
1207: fnd_file.put_line(fnd_file.log,' Box Num =>'||i);
1208: END IF;
1209: fnd_file.put_line(fnd_file.log,' Taxable Amount =>'|| v_box_amounts(i).taxable_amount);

Line 1207: fnd_file.put_line(fnd_file.log,' Box Num =>'||i);

1203: fnd_file.put_line(fnd_file.log,'-----------------------------------');
1204: IF i > 1000 THEN
1205: fnd_file.put_line(fnd_file.log,' Box Num =>'||floor(i/10000));
1206: ELSE
1207: fnd_file.put_line(fnd_file.log,' Box Num =>'||i);
1208: END IF;
1209: fnd_file.put_line(fnd_file.log,' Taxable Amount =>'|| v_box_amounts(i).taxable_amount);
1210: fnd_file.put_line(fnd_file.log,' Tax Amount =>'|| v_box_amounts(i).tax_amount);
1211: fnd_file.put_line(fnd_file.log,' Total Box Number =>'|| v_box_amounts(i).tot_box_num);

Line 1209: fnd_file.put_line(fnd_file.log,' Taxable Amount =>'|| v_box_amounts(i).taxable_amount);

1205: fnd_file.put_line(fnd_file.log,' Box Num =>'||floor(i/10000));
1206: ELSE
1207: fnd_file.put_line(fnd_file.log,' Box Num =>'||i);
1208: END IF;
1209: fnd_file.put_line(fnd_file.log,' Taxable Amount =>'|| v_box_amounts(i).taxable_amount);
1210: fnd_file.put_line(fnd_file.log,' Tax Amount =>'|| v_box_amounts(i).tax_amount);
1211: fnd_file.put_line(fnd_file.log,' Total Box Number =>'|| v_box_amounts(i).tot_box_num);
1212: fnd_file.put_line(fnd_file.log,' Tax Rate =>'|| v_box_amounts(i).tax_rate);
1213: fnd_file.put_line(fnd_file.log,'-----------------------------------');

Line 1210: fnd_file.put_line(fnd_file.log,' Tax Amount =>'|| v_box_amounts(i).tax_amount);

1206: ELSE
1207: fnd_file.put_line(fnd_file.log,' Box Num =>'||i);
1208: END IF;
1209: fnd_file.put_line(fnd_file.log,' Taxable Amount =>'|| v_box_amounts(i).taxable_amount);
1210: fnd_file.put_line(fnd_file.log,' Tax Amount =>'|| v_box_amounts(i).tax_amount);
1211: fnd_file.put_line(fnd_file.log,' Total Box Number =>'|| v_box_amounts(i).tot_box_num);
1212: fnd_file.put_line(fnd_file.log,' Tax Rate =>'|| v_box_amounts(i).tax_rate);
1213: fnd_file.put_line(fnd_file.log,'-----------------------------------');
1214: END IF;

Line 1211: fnd_file.put_line(fnd_file.log,' Total Box Number =>'|| v_box_amounts(i).tot_box_num);

1207: fnd_file.put_line(fnd_file.log,' Box Num =>'||i);
1208: END IF;
1209: fnd_file.put_line(fnd_file.log,' Taxable Amount =>'|| v_box_amounts(i).taxable_amount);
1210: fnd_file.put_line(fnd_file.log,' Tax Amount =>'|| v_box_amounts(i).tax_amount);
1211: fnd_file.put_line(fnd_file.log,' Total Box Number =>'|| v_box_amounts(i).tot_box_num);
1212: fnd_file.put_line(fnd_file.log,' Tax Rate =>'|| v_box_amounts(i).tax_rate);
1213: fnd_file.put_line(fnd_file.log,'-----------------------------------');
1214: END IF;
1215:

Line 1212: fnd_file.put_line(fnd_file.log,' Tax Rate =>'|| v_box_amounts(i).tax_rate);

1208: END IF;
1209: fnd_file.put_line(fnd_file.log,' Taxable Amount =>'|| v_box_amounts(i).taxable_amount);
1210: fnd_file.put_line(fnd_file.log,' Tax Amount =>'|| v_box_amounts(i).tax_amount);
1211: fnd_file.put_line(fnd_file.log,' Total Box Number =>'|| v_box_amounts(i).tot_box_num);
1212: fnd_file.put_line(fnd_file.log,' Tax Rate =>'|| v_box_amounts(i).tax_rate);
1213: fnd_file.put_line(fnd_file.log,'-----------------------------------');
1214: END IF;
1215:
1216: IF v_box_amounts.EXISTS(i) and i <= 1000 THEN

Line 1213: fnd_file.put_line(fnd_file.log,'-----------------------------------');

1209: fnd_file.put_line(fnd_file.log,' Taxable Amount =>'|| v_box_amounts(i).taxable_amount);
1210: fnd_file.put_line(fnd_file.log,' Tax Amount =>'|| v_box_amounts(i).tax_amount);
1211: fnd_file.put_line(fnd_file.log,' Total Box Number =>'|| v_box_amounts(i).tot_box_num);
1212: fnd_file.put_line(fnd_file.log,' Tax Rate =>'|| v_box_amounts(i).tax_rate);
1213: fnd_file.put_line(fnd_file.log,'-----------------------------------');
1214: END IF;
1215:
1216: IF v_box_amounts.EXISTS(i) and i <= 1000 THEN
1217: INSERT INTO jg_zz_vat_trx_gt ( jg_info_n1

Line 1250: fnd_file.put_line(fnd_file.log,'Number of records inserted into jg_zz_vat_trx_gt table :' || l_count );

1246: END IF;
1247:
1248: select count(*) into l_count from jg_zz_vat_trx_gt ;
1249: IF p_debug_flag = 'Y' THEN
1250: fnd_file.put_line(fnd_file.log,'Number of records inserted into jg_zz_vat_trx_gt table :' || l_count );
1251: END IF ;
1252: EXCEPTION
1253: WHEN OTHERS THEN
1254: fnd_file.put_line(fnd_file.log,'Error in Procedure jg_zz_summary_all_pkg.jeptavat: ' || SUBSTR(SQLERRM,1,200));

Line 1254: fnd_file.put_line(fnd_file.log,'Error in Procedure jg_zz_summary_all_pkg.jeptavat: ' || SUBSTR(SQLERRM,1,200));

1250: fnd_file.put_line(fnd_file.log,'Number of records inserted into jg_zz_vat_trx_gt table :' || l_count );
1251: END IF ;
1252: EXCEPTION
1253: WHEN OTHERS THEN
1254: fnd_file.put_line(fnd_file.log,'Error in Procedure jg_zz_summary_all_pkg.jeptavat: ' || SUBSTR(SQLERRM,1,200));
1255: fnd_file.put_line(fnd_file.log,'Error at statement: ' || ln_stat_no);
1256: RAISE;
1257: END jeptavat;
1258:

Line 1255: fnd_file.put_line(fnd_file.log,'Error at statement: ' || ln_stat_no);

1251: END IF ;
1252: EXCEPTION
1253: WHEN OTHERS THEN
1254: fnd_file.put_line(fnd_file.log,'Error in Procedure jg_zz_summary_all_pkg.jeptavat: ' || SUBSTR(SQLERRM,1,200));
1255: fnd_file.put_line(fnd_file.log,'Error at statement: ' || ln_stat_no);
1256: RAISE;
1257: END jeptavat;
1258:
1259: --

Line 1377: fnd_file.put_line(fnd_file.log,'-----------------------------------');

1373: END IF;
1374: l_data_found := 'Y';
1375:
1376: IF p_debug_flag = 'Y' THEN
1377: fnd_file.put_line(fnd_file.log,'-----------------------------------');
1378: fnd_file.put_line(fnd_file.log,'---- Trans Id ' || l_pt_periodic_vat.trx_id || '-----');
1379: fnd_file.put_line(fnd_file.log,'---- Trans Number '||l_pt_periodic_vat.trx_number||'-----');
1380: fnd_file.put_line(fnd_file.log,' Tax class information => ' || l_pt_periodic_vat.tax_class);
1381: fnd_file.put_line(fnd_file.log,' Extract Source Ledger => ' ||l_pt_periodic_vat.extract_source_ledger);

Line 1378: fnd_file.put_line(fnd_file.log,'---- Trans Id ' || l_pt_periodic_vat.trx_id || '-----');

1374: l_data_found := 'Y';
1375:
1376: IF p_debug_flag = 'Y' THEN
1377: fnd_file.put_line(fnd_file.log,'-----------------------------------');
1378: fnd_file.put_line(fnd_file.log,'---- Trans Id ' || l_pt_periodic_vat.trx_id || '-----');
1379: fnd_file.put_line(fnd_file.log,'---- Trans Number '||l_pt_periodic_vat.trx_number||'-----');
1380: fnd_file.put_line(fnd_file.log,' Tax class information => ' || l_pt_periodic_vat.tax_class);
1381: fnd_file.put_line(fnd_file.log,' Extract Source Ledger => ' ||l_pt_periodic_vat.extract_source_ledger);
1382: fnd_file.put_line(fnd_file.log,' trx_line_class => ' ||l_pt_periodic_vat.trx_line_class);

Line 1379: fnd_file.put_line(fnd_file.log,'---- Trans Number '||l_pt_periodic_vat.trx_number||'-----');

1375:
1376: IF p_debug_flag = 'Y' THEN
1377: fnd_file.put_line(fnd_file.log,'-----------------------------------');
1378: fnd_file.put_line(fnd_file.log,'---- Trans Id ' || l_pt_periodic_vat.trx_id || '-----');
1379: fnd_file.put_line(fnd_file.log,'---- Trans Number '||l_pt_periodic_vat.trx_number||'-----');
1380: fnd_file.put_line(fnd_file.log,' Tax class information => ' || l_pt_periodic_vat.tax_class);
1381: fnd_file.put_line(fnd_file.log,' Extract Source Ledger => ' ||l_pt_periodic_vat.extract_source_ledger);
1382: fnd_file.put_line(fnd_file.log,' trx_line_class => ' ||l_pt_periodic_vat.trx_line_class);
1383: fnd_file.put_line(fnd_file.log,' Reporting Code => ' ||l_pt_periodic_vat.reporting_code);

Line 1380: fnd_file.put_line(fnd_file.log,' Tax class information => ' || l_pt_periodic_vat.tax_class);

1376: IF p_debug_flag = 'Y' THEN
1377: fnd_file.put_line(fnd_file.log,'-----------------------------------');
1378: fnd_file.put_line(fnd_file.log,'---- Trans Id ' || l_pt_periodic_vat.trx_id || '-----');
1379: fnd_file.put_line(fnd_file.log,'---- Trans Number '||l_pt_periodic_vat.trx_number||'-----');
1380: fnd_file.put_line(fnd_file.log,' Tax class information => ' || l_pt_periodic_vat.tax_class);
1381: fnd_file.put_line(fnd_file.log,' Extract Source Ledger => ' ||l_pt_periodic_vat.extract_source_ledger);
1382: fnd_file.put_line(fnd_file.log,' trx_line_class => ' ||l_pt_periodic_vat.trx_line_class);
1383: fnd_file.put_line(fnd_file.log,' Reporting Code => ' ||l_pt_periodic_vat.reporting_code);
1384: fnd_file.put_line(fnd_file.log,' Trx Taxable Amount =>'|| l_pt_periodic_vat.taxable_amount);

Line 1381: fnd_file.put_line(fnd_file.log,' Extract Source Ledger => ' ||l_pt_periodic_vat.extract_source_ledger);

1377: fnd_file.put_line(fnd_file.log,'-----------------------------------');
1378: fnd_file.put_line(fnd_file.log,'---- Trans Id ' || l_pt_periodic_vat.trx_id || '-----');
1379: fnd_file.put_line(fnd_file.log,'---- Trans Number '||l_pt_periodic_vat.trx_number||'-----');
1380: fnd_file.put_line(fnd_file.log,' Tax class information => ' || l_pt_periodic_vat.tax_class);
1381: fnd_file.put_line(fnd_file.log,' Extract Source Ledger => ' ||l_pt_periodic_vat.extract_source_ledger);
1382: fnd_file.put_line(fnd_file.log,' trx_line_class => ' ||l_pt_periodic_vat.trx_line_class);
1383: fnd_file.put_line(fnd_file.log,' Reporting Code => ' ||l_pt_periodic_vat.reporting_code);
1384: fnd_file.put_line(fnd_file.log,' Trx Taxable Amount =>'|| l_pt_periodic_vat.taxable_amount);
1385: fnd_file.put_line(fnd_file.log,' Trx Deduct Tax Amount=>'|| l_pt_periodic_vat.deduct_tax);

Line 1382: fnd_file.put_line(fnd_file.log,' trx_line_class => ' ||l_pt_periodic_vat.trx_line_class);

1378: fnd_file.put_line(fnd_file.log,'---- Trans Id ' || l_pt_periodic_vat.trx_id || '-----');
1379: fnd_file.put_line(fnd_file.log,'---- Trans Number '||l_pt_periodic_vat.trx_number||'-----');
1380: fnd_file.put_line(fnd_file.log,' Tax class information => ' || l_pt_periodic_vat.tax_class);
1381: fnd_file.put_line(fnd_file.log,' Extract Source Ledger => ' ||l_pt_periodic_vat.extract_source_ledger);
1382: fnd_file.put_line(fnd_file.log,' trx_line_class => ' ||l_pt_periodic_vat.trx_line_class);
1383: fnd_file.put_line(fnd_file.log,' Reporting Code => ' ||l_pt_periodic_vat.reporting_code);
1384: fnd_file.put_line(fnd_file.log,' Trx Taxable Amount =>'|| l_pt_periodic_vat.taxable_amount);
1385: fnd_file.put_line(fnd_file.log,' Trx Deduct Tax Amount=>'|| l_pt_periodic_vat.deduct_tax);
1386: fnd_file.put_line(fnd_file.log,' Trx Clear Tax Amount =>'|| l_pt_periodic_vat.clear_tax);

Line 1383: fnd_file.put_line(fnd_file.log,' Reporting Code => ' ||l_pt_periodic_vat.reporting_code);

1379: fnd_file.put_line(fnd_file.log,'---- Trans Number '||l_pt_periodic_vat.trx_number||'-----');
1380: fnd_file.put_line(fnd_file.log,' Tax class information => ' || l_pt_periodic_vat.tax_class);
1381: fnd_file.put_line(fnd_file.log,' Extract Source Ledger => ' ||l_pt_periodic_vat.extract_source_ledger);
1382: fnd_file.put_line(fnd_file.log,' trx_line_class => ' ||l_pt_periodic_vat.trx_line_class);
1383: fnd_file.put_line(fnd_file.log,' Reporting Code => ' ||l_pt_periodic_vat.reporting_code);
1384: fnd_file.put_line(fnd_file.log,' Trx Taxable Amount =>'|| l_pt_periodic_vat.taxable_amount);
1385: fnd_file.put_line(fnd_file.log,' Trx Deduct Tax Amount=>'|| l_pt_periodic_vat.deduct_tax);
1386: fnd_file.put_line(fnd_file.log,' Trx Clear Tax Amount =>'|| l_pt_periodic_vat.clear_tax);
1387: fnd_file.put_line(fnd_file.log,' Taxable Box => '|| l_pt_periodic_vat.taxable_box);

Line 1384: fnd_file.put_line(fnd_file.log,' Trx Taxable Amount =>'|| l_pt_periodic_vat.taxable_amount);

1380: fnd_file.put_line(fnd_file.log,' Tax class information => ' || l_pt_periodic_vat.tax_class);
1381: fnd_file.put_line(fnd_file.log,' Extract Source Ledger => ' ||l_pt_periodic_vat.extract_source_ledger);
1382: fnd_file.put_line(fnd_file.log,' trx_line_class => ' ||l_pt_periodic_vat.trx_line_class);
1383: fnd_file.put_line(fnd_file.log,' Reporting Code => ' ||l_pt_periodic_vat.reporting_code);
1384: fnd_file.put_line(fnd_file.log,' Trx Taxable Amount =>'|| l_pt_periodic_vat.taxable_amount);
1385: fnd_file.put_line(fnd_file.log,' Trx Deduct Tax Amount=>'|| l_pt_periodic_vat.deduct_tax);
1386: fnd_file.put_line(fnd_file.log,' Trx Clear Tax Amount =>'|| l_pt_periodic_vat.clear_tax);
1387: fnd_file.put_line(fnd_file.log,' Taxable Box => '|| l_pt_periodic_vat.taxable_box);
1388: fnd_file.put_line(fnd_file.log,' Taxable Amt => ' ||v_box_amounts(l_pt_periodic_vat.taxable_box).taxable_amount);

Line 1385: fnd_file.put_line(fnd_file.log,' Trx Deduct Tax Amount=>'|| l_pt_periodic_vat.deduct_tax);

1381: fnd_file.put_line(fnd_file.log,' Extract Source Ledger => ' ||l_pt_periodic_vat.extract_source_ledger);
1382: fnd_file.put_line(fnd_file.log,' trx_line_class => ' ||l_pt_periodic_vat.trx_line_class);
1383: fnd_file.put_line(fnd_file.log,' Reporting Code => ' ||l_pt_periodic_vat.reporting_code);
1384: fnd_file.put_line(fnd_file.log,' Trx Taxable Amount =>'|| l_pt_periodic_vat.taxable_amount);
1385: fnd_file.put_line(fnd_file.log,' Trx Deduct Tax Amount=>'|| l_pt_periodic_vat.deduct_tax);
1386: fnd_file.put_line(fnd_file.log,' Trx Clear Tax Amount =>'|| l_pt_periodic_vat.clear_tax);
1387: fnd_file.put_line(fnd_file.log,' Taxable Box => '|| l_pt_periodic_vat.taxable_box);
1388: fnd_file.put_line(fnd_file.log,' Taxable Amt => ' ||v_box_amounts(l_pt_periodic_vat.taxable_box).taxable_amount);
1389: fnd_file.put_line(fnd_file.log,' Tax Box => ' ||l_pt_periodic_vat.tax_box);

Line 1386: fnd_file.put_line(fnd_file.log,' Trx Clear Tax Amount =>'|| l_pt_periodic_vat.clear_tax);

1382: fnd_file.put_line(fnd_file.log,' trx_line_class => ' ||l_pt_periodic_vat.trx_line_class);
1383: fnd_file.put_line(fnd_file.log,' Reporting Code => ' ||l_pt_periodic_vat.reporting_code);
1384: fnd_file.put_line(fnd_file.log,' Trx Taxable Amount =>'|| l_pt_periodic_vat.taxable_amount);
1385: fnd_file.put_line(fnd_file.log,' Trx Deduct Tax Amount=>'|| l_pt_periodic_vat.deduct_tax);
1386: fnd_file.put_line(fnd_file.log,' Trx Clear Tax Amount =>'|| l_pt_periodic_vat.clear_tax);
1387: fnd_file.put_line(fnd_file.log,' Taxable Box => '|| l_pt_periodic_vat.taxable_box);
1388: fnd_file.put_line(fnd_file.log,' Taxable Amt => ' ||v_box_amounts(l_pt_periodic_vat.taxable_box).taxable_amount);
1389: fnd_file.put_line(fnd_file.log,' Tax Box => ' ||l_pt_periodic_vat.tax_box);
1390: fnd_file.put_line(fnd_file.log,' Deduct Amt => ' ||v_box_amounts(l_pt_periodic_vat.tax_box).deduct_tax);

Line 1387: fnd_file.put_line(fnd_file.log,' Taxable Box => '|| l_pt_periodic_vat.taxable_box);

1383: fnd_file.put_line(fnd_file.log,' Reporting Code => ' ||l_pt_periodic_vat.reporting_code);
1384: fnd_file.put_line(fnd_file.log,' Trx Taxable Amount =>'|| l_pt_periodic_vat.taxable_amount);
1385: fnd_file.put_line(fnd_file.log,' Trx Deduct Tax Amount=>'|| l_pt_periodic_vat.deduct_tax);
1386: fnd_file.put_line(fnd_file.log,' Trx Clear Tax Amount =>'|| l_pt_periodic_vat.clear_tax);
1387: fnd_file.put_line(fnd_file.log,' Taxable Box => '|| l_pt_periodic_vat.taxable_box);
1388: fnd_file.put_line(fnd_file.log,' Taxable Amt => ' ||v_box_amounts(l_pt_periodic_vat.taxable_box).taxable_amount);
1389: fnd_file.put_line(fnd_file.log,' Tax Box => ' ||l_pt_periodic_vat.tax_box);
1390: fnd_file.put_line(fnd_file.log,' Deduct Amt => ' ||v_box_amounts(l_pt_periodic_vat.tax_box).deduct_tax);
1391: fnd_file.put_line(fnd_file.log,' Clear Amt => ' ||v_box_amounts(l_pt_periodic_vat.tax_box).clear_tax);

Line 1388: fnd_file.put_line(fnd_file.log,' Taxable Amt => ' ||v_box_amounts(l_pt_periodic_vat.taxable_box).taxable_amount);

1384: fnd_file.put_line(fnd_file.log,' Trx Taxable Amount =>'|| l_pt_periodic_vat.taxable_amount);
1385: fnd_file.put_line(fnd_file.log,' Trx Deduct Tax Amount=>'|| l_pt_periodic_vat.deduct_tax);
1386: fnd_file.put_line(fnd_file.log,' Trx Clear Tax Amount =>'|| l_pt_periodic_vat.clear_tax);
1387: fnd_file.put_line(fnd_file.log,' Taxable Box => '|| l_pt_periodic_vat.taxable_box);
1388: fnd_file.put_line(fnd_file.log,' Taxable Amt => ' ||v_box_amounts(l_pt_periodic_vat.taxable_box).taxable_amount);
1389: fnd_file.put_line(fnd_file.log,' Tax Box => ' ||l_pt_periodic_vat.tax_box);
1390: fnd_file.put_line(fnd_file.log,' Deduct Amt => ' ||v_box_amounts(l_pt_periodic_vat.tax_box).deduct_tax);
1391: fnd_file.put_line(fnd_file.log,' Clear Amt => ' ||v_box_amounts(l_pt_periodic_vat.tax_box).clear_tax);
1392: fnd_file.put_line(fnd_file.log,' Tax Recoverable Flag => ' || l_pt_periodic_vat.tax_recoverable_flag);

Line 1389: fnd_file.put_line(fnd_file.log,' Tax Box => ' ||l_pt_periodic_vat.tax_box);

1385: fnd_file.put_line(fnd_file.log,' Trx Deduct Tax Amount=>'|| l_pt_periodic_vat.deduct_tax);
1386: fnd_file.put_line(fnd_file.log,' Trx Clear Tax Amount =>'|| l_pt_periodic_vat.clear_tax);
1387: fnd_file.put_line(fnd_file.log,' Taxable Box => '|| l_pt_periodic_vat.taxable_box);
1388: fnd_file.put_line(fnd_file.log,' Taxable Amt => ' ||v_box_amounts(l_pt_periodic_vat.taxable_box).taxable_amount);
1389: fnd_file.put_line(fnd_file.log,' Tax Box => ' ||l_pt_periodic_vat.tax_box);
1390: fnd_file.put_line(fnd_file.log,' Deduct Amt => ' ||v_box_amounts(l_pt_periodic_vat.tax_box).deduct_tax);
1391: fnd_file.put_line(fnd_file.log,' Clear Amt => ' ||v_box_amounts(l_pt_periodic_vat.tax_box).clear_tax);
1392: fnd_file.put_line(fnd_file.log,' Tax Recoverable Flag => ' || l_pt_periodic_vat.tax_recoverable_flag);
1393: fnd_file.put_line(fnd_file.log,'-----------------------------------');

Line 1390: fnd_file.put_line(fnd_file.log,' Deduct Amt => ' ||v_box_amounts(l_pt_periodic_vat.tax_box).deduct_tax);

1386: fnd_file.put_line(fnd_file.log,' Trx Clear Tax Amount =>'|| l_pt_periodic_vat.clear_tax);
1387: fnd_file.put_line(fnd_file.log,' Taxable Box => '|| l_pt_periodic_vat.taxable_box);
1388: fnd_file.put_line(fnd_file.log,' Taxable Amt => ' ||v_box_amounts(l_pt_periodic_vat.taxable_box).taxable_amount);
1389: fnd_file.put_line(fnd_file.log,' Tax Box => ' ||l_pt_periodic_vat.tax_box);
1390: fnd_file.put_line(fnd_file.log,' Deduct Amt => ' ||v_box_amounts(l_pt_periodic_vat.tax_box).deduct_tax);
1391: fnd_file.put_line(fnd_file.log,' Clear Amt => ' ||v_box_amounts(l_pt_periodic_vat.tax_box).clear_tax);
1392: fnd_file.put_line(fnd_file.log,' Tax Recoverable Flag => ' || l_pt_periodic_vat.tax_recoverable_flag);
1393: fnd_file.put_line(fnd_file.log,'-----------------------------------');
1394: END IF;

Line 1391: fnd_file.put_line(fnd_file.log,' Clear Amt => ' ||v_box_amounts(l_pt_periodic_vat.tax_box).clear_tax);

1387: fnd_file.put_line(fnd_file.log,' Taxable Box => '|| l_pt_periodic_vat.taxable_box);
1388: fnd_file.put_line(fnd_file.log,' Taxable Amt => ' ||v_box_amounts(l_pt_periodic_vat.taxable_box).taxable_amount);
1389: fnd_file.put_line(fnd_file.log,' Tax Box => ' ||l_pt_periodic_vat.tax_box);
1390: fnd_file.put_line(fnd_file.log,' Deduct Amt => ' ||v_box_amounts(l_pt_periodic_vat.tax_box).deduct_tax);
1391: fnd_file.put_line(fnd_file.log,' Clear Amt => ' ||v_box_amounts(l_pt_periodic_vat.tax_box).clear_tax);
1392: fnd_file.put_line(fnd_file.log,' Tax Recoverable Flag => ' || l_pt_periodic_vat.tax_recoverable_flag);
1393: fnd_file.put_line(fnd_file.log,'-----------------------------------');
1394: END IF;
1395: END LOOP;

Line 1392: fnd_file.put_line(fnd_file.log,' Tax Recoverable Flag => ' || l_pt_periodic_vat.tax_recoverable_flag);

1388: fnd_file.put_line(fnd_file.log,' Taxable Amt => ' ||v_box_amounts(l_pt_periodic_vat.taxable_box).taxable_amount);
1389: fnd_file.put_line(fnd_file.log,' Tax Box => ' ||l_pt_periodic_vat.tax_box);
1390: fnd_file.put_line(fnd_file.log,' Deduct Amt => ' ||v_box_amounts(l_pt_periodic_vat.tax_box).deduct_tax);
1391: fnd_file.put_line(fnd_file.log,' Clear Amt => ' ||v_box_amounts(l_pt_periodic_vat.tax_box).clear_tax);
1392: fnd_file.put_line(fnd_file.log,' Tax Recoverable Flag => ' || l_pt_periodic_vat.tax_recoverable_flag);
1393: fnd_file.put_line(fnd_file.log,'-----------------------------------');
1394: END IF;
1395: END LOOP;
1396:

Line 1393: fnd_file.put_line(fnd_file.log,'-----------------------------------');

1389: fnd_file.put_line(fnd_file.log,' Tax Box => ' ||l_pt_periodic_vat.tax_box);
1390: fnd_file.put_line(fnd_file.log,' Deduct Amt => ' ||v_box_amounts(l_pt_periodic_vat.tax_box).deduct_tax);
1391: fnd_file.put_line(fnd_file.log,' Clear Amt => ' ||v_box_amounts(l_pt_periodic_vat.tax_box).clear_tax);
1392: fnd_file.put_line(fnd_file.log,' Tax Recoverable Flag => ' || l_pt_periodic_vat.tax_recoverable_flag);
1393: fnd_file.put_line(fnd_file.log,'-----------------------------------');
1394: END IF;
1395: END LOOP;
1396:
1397: IF l_data_found = 'Y' THEN

Line 1421: fnd_file.put_line(fnd_file.log,'Number of records inserted into jg_zz_vat_trx_gt table: ' || l_count );

1417: END IF;
1418:
1419: SELECT count(*) into l_count from jg_zz_vat_trx_gt ;
1420: IF p_debug_flag = 'Y' THEN
1421: fnd_file.put_line(fnd_file.log,'Number of records inserted into jg_zz_vat_trx_gt table: ' || l_count );
1422: END IF ;
1423:
1424: EXCEPTION
1425: WHEN OTHERS THEN

Line 1426: fnd_file.put_line(fnd_file.log,'Error in Procedure jg_zz_summary_all_pkg.jeptpvat ' || SUBSTR(SQLERRM,1,200));

1422: END IF ;
1423:
1424: EXCEPTION
1425: WHEN OTHERS THEN
1426: fnd_file.put_line(fnd_file.log,'Error in Procedure jg_zz_summary_all_pkg.jeptpvat ' || SUBSTR(SQLERRM,1,200));
1427: RAISE;
1428: END jeptpvat;
1429:
1430: --

Line 1623: fnd_file.put_line(fnd_file.log,'Number of records inserted into jg_zz_vat_trx_gt table: ' || l_count );

1619: --BUG8347134 end
1620:
1621: SELECT count(*) into l_count from jg_zz_vat_trx_gt ;
1622: IF p_debug_flag = 'Y' THEN
1623: fnd_file.put_line(fnd_file.log,'Number of records inserted into jg_zz_vat_trx_gt table: ' || l_count );
1624: END IF ;
1625:
1626: EXCEPTION
1627: WHEN OTHERS THEN

Line 1628: fnd_file.put_line(fnd_file.log,'Error in Procedure jg_zz_summary_all_pkg.jeitpssr ' || SUBSTR(SQLERRM,1,200));

1624: END IF ;
1625:
1626: EXCEPTION
1627: WHEN OTHERS THEN
1628: fnd_file.put_line(fnd_file.log,'Error in Procedure jg_zz_summary_all_pkg.jeitpssr ' || SUBSTR(SQLERRM,1,200));
1629: RAISE;
1630: END jeitpssr;
1631:
1632: -- ER 9155483

Line 2519: fnd_file.put_line(fnd_file.log,LOG_MESSAGE_835);

2515: WHEN VAT_REP_NOT_RUN THEN
2516: fnd_message.set_name('JE', 'JE_IL_VAT_REP_NOT_RUN');
2517: fnd_message.set_token('P_PERIOD', P_PERIOD);
2518: LOG_MESSAGE_835 := fnd_message.get;
2519: fnd_file.put_line(fnd_file.log,LOG_MESSAGE_835);
2520: FOR i IN 1..l_ent_index-1 LOOP
2521: select ENTITY_IDENTIFIER
2522: into l_ent_name
2523: from jg_zz_vat_rep_entities

Line 2525: fnd_file.put_line(fnd_file.log,'>>>>>'||l_ent_name);

2521: select ENTITY_IDENTIFIER
2522: into l_ent_name
2523: from jg_zz_vat_rep_entities
2524: where VAT_REPORTING_ENTITY_ID = l_ent_list(i).ent_id;
2525: fnd_file.put_line(fnd_file.log,'>>>>>'||l_ent_name);
2526: END LOOP;
2527: raise_application_error(-20010,LOG_MESSAGE_835);
2528: WHEN OTHERS THEN
2529: fnd_file.put_line(fnd_file.log,'Error in Procedure JG_ZZ_SUMMARY_ALL_PKG.jeilr835 ' || SUBSTR(SQLERRM,1,200));

Line 2529: fnd_file.put_line(fnd_file.log,'Error in Procedure JG_ZZ_SUMMARY_ALL_PKG.jeilr835 ' || SUBSTR(SQLERRM,1,200));

2525: fnd_file.put_line(fnd_file.log,'>>>>>'||l_ent_name);
2526: END LOOP;
2527: raise_application_error(-20010,LOG_MESSAGE_835);
2528: WHEN OTHERS THEN
2529: fnd_file.put_line(fnd_file.log,'Error in Procedure JG_ZZ_SUMMARY_ALL_PKG.jeilr835 ' || SUBSTR(SQLERRM,1,200));
2530: RAISE;
2531: END jeilr835;
2532:
2533: FUNCTION a_real_tax_amount(p_payment_amt IN NUMBER

Line 2541: fnd_file.put_line(fnd_file.log,' p_payment_amt =>'||p_payment_amt);

2537: tax_amount NUMBER;
2538: l_total_invoice NUMBER;
2539: BEGIN
2540: IF p_debug_flag = 'Y' THEN
2541: fnd_file.put_line(fnd_file.log,' p_payment_amt =>'||p_payment_amt);
2542: END IF;
2543: IF p_payment_amt = 0 THEN
2544: /****************************************
2545: tax_amount := tax_amount;

Line 2561: fnd_file.put_line(fnd_file.log,' tax_amount =>'||tax_amount);

2557: tax_amount := p_payment_amt*(p_tax_amount/nvl(l_total_invoice, 1));
2558: END IF;
2559: END IF;
2560: IF p_debug_flag = 'Y' THEN
2561: fnd_file.put_line(fnd_file.log,' tax_amount =>'||tax_amount);
2562: END IF;
2563: RETURN(tax_amount);
2564: EXCEPTION
2565: WHEN OTHERS THEN

Line 2566: fnd_file.put_line(fnd_file.log,'Error in Procedure jg_zz_summary_all_pkg.a_real_tax_amount ' || SUBSTR(SQLERRM,1,200));

2562: END IF;
2563: RETURN(tax_amount);
2564: EXCEPTION
2565: WHEN OTHERS THEN
2566: fnd_file.put_line(fnd_file.log,'Error in Procedure jg_zz_summary_all_pkg.a_real_tax_amount ' || SUBSTR(SQLERRM,1,200));
2567: RAISE;
2568: END a_real_tax_amount;
2569:
2570: FUNCTION a_real_invoice_amount(p_payment_amt IN NUMBER

Line 2591: fnd_file.put_line(fnd_file.log,'Error in Procedure jg_zz_summary_all_pkg.a_real_invoice_amount ' || SUBSTR(SQLERRM,1,200));

2587: END IF;
2588: RETURN(invoice_amount);
2589: EXCEPTION
2590: WHEN OTHERS THEN
2591: fnd_file.put_line(fnd_file.log,'Error in Procedure jg_zz_summary_all_pkg.a_real_invoice_amount ' || SUBSTR(SQLERRM,1,200));
2592: RAISE;
2593: END a_real_invoice_amount;
2594:
2595: FUNCTION a_total_invoices(p_cust_trx_id IN NUMBER)

Line 2619: fnd_file.put_line(fnd_file.log,'Error in Procedure jg_zz_summary_all_pkg.a_total_invoices ' || SUBSTR(SQLERRM,1,200));

2615: END IF;
2616: RETURN(invoice_values);
2617: EXCEPTION
2618: WHEN OTHERS THEN
2619: fnd_file.put_line(fnd_file.log,'Error in Procedure jg_zz_summary_all_pkg.a_total_invoices ' || SUBSTR(SQLERRM,1,200));
2620: RAISE;
2621: END a_total_invoices;
2622:
2623: FUNCTION get_report_format

Line 2640: fnd_file.put_line(fnd_file.log,'Error while fetching Meaning for Lookup Type JEBE_REPORT_FORMAT' || SUBSTR(SQLERRM,1,200));

2636: RETURN NULL;
2637: END IF;
2638: EXCEPTION
2639: WHEN NO_DATA_FOUND then
2640: fnd_file.put_line(fnd_file.log,'Error while fetching Meaning for Lookup Type JEBE_REPORT_FORMAT' || SUBSTR(SQLERRM,1,200));
2641: l_detail_summary := P_REPORT_FORMAT;
2642: RETURN l_detail_summary;
2643: WHEN OTHERS then
2644: fnd_file.put_line(fnd_file.log,'Error while fetching Meaning for Lookup Type JEBE_REPORT_FORMAT' || SUBSTR(SQLERRM,1,200));

Line 2644: fnd_file.put_line(fnd_file.log,'Error while fetching Meaning for Lookup Type JEBE_REPORT_FORMAT' || SUBSTR(SQLERRM,1,200));

2640: fnd_file.put_line(fnd_file.log,'Error while fetching Meaning for Lookup Type JEBE_REPORT_FORMAT' || SUBSTR(SQLERRM,1,200));
2641: l_detail_summary := P_REPORT_FORMAT;
2642: RETURN l_detail_summary;
2643: WHEN OTHERS then
2644: fnd_file.put_line(fnd_file.log,'Error while fetching Meaning for Lookup Type JEBE_REPORT_FORMAT' || SUBSTR(SQLERRM,1,200));
2645: l_detail_summary := P_REPORT_FORMAT;
2646: RETURN l_detail_summary;
2647: END get_report_format;
2648:

Line 2667: fnd_file.put_line(fnd_file.log,'Location Name for Location Code ' || P_LOCATION || ' is not found');

2663: END IF;
2664: RETURN l_location_name;
2665: EXCEPTION
2666: WHEN NO_DATA_FOUND THEN
2667: fnd_file.put_line(fnd_file.log,'Location Name for Location Code ' || P_LOCATION || ' is not found');
2668: l_location_name := P_LOCATION;
2669: RETURN l_location_name;
2670: WHEN OTHERS THEN
2671: fnd_file.put_line(fnd_file.log,'Error while fetching Location Name' || SUBSTR(SQLERRM,1,200));

Line 2671: fnd_file.put_line(fnd_file.log,'Error while fetching Location Name' || SUBSTR(SQLERRM,1,200));

2667: fnd_file.put_line(fnd_file.log,'Location Name for Location Code ' || P_LOCATION || ' is not found');
2668: l_location_name := P_LOCATION;
2669: RETURN l_location_name;
2670: WHEN OTHERS THEN
2671: fnd_file.put_line(fnd_file.log,'Error while fetching Location Name' || SUBSTR(SQLERRM,1,200));
2672: l_location_name := P_LOCATION;
2673: RETURN l_location_name;
2674: END;
2675:

Line 2699: fnd_file.put_line(fnd_file.log,'Starting Exemption Limit for Period => : '||l_starting_limit);

2695: AND JIY.month = fl.lookup_code
2696: AND JIY.year = to_char(l_period_date,'RRRR')
2697: AND JIY.month = to_char(l_period_date,'MM')
2698: AND JIY.legal_entity_id = P_LEGAL_ENTITY_ID ;
2699: fnd_file.put_line(fnd_file.log,'Starting Exemption Limit for Period => : '||l_starting_limit);
2700: RETURN l_starting_limit;
2701: EXCEPTION
2702: WHEN NO_DATA_FOUND THEN
2703: fnd_file.put_line(fnd_file.log,'Exeption Amount for beginning of Period not found' || SUBSTR(SQLERRM,1,200));

Line 2703: fnd_file.put_line(fnd_file.log,'Exeption Amount for beginning of Period not found' || SUBSTR(SQLERRM,1,200));

2699: fnd_file.put_line(fnd_file.log,'Starting Exemption Limit for Period => : '||l_starting_limit);
2700: RETURN l_starting_limit;
2701: EXCEPTION
2702: WHEN NO_DATA_FOUND THEN
2703: fnd_file.put_line(fnd_file.log,'Exeption Amount for beginning of Period not found' || SUBSTR(SQLERRM,1,200));
2704: RETURN 0;
2705: WHEN OTHERS THEN
2706: fnd_file.put_line(fnd_file.log,'Error while fetching Available Exemption at Beginning of Period ' || SUBSTR(SQLERRM,1,200));
2707: RETURN 0;

Line 2706: fnd_file.put_line(fnd_file.log,'Error while fetching Available Exemption at Beginning of Period ' || SUBSTR(SQLERRM,1,200));

2702: WHEN NO_DATA_FOUND THEN
2703: fnd_file.put_line(fnd_file.log,'Exeption Amount for beginning of Period not found' || SUBSTR(SQLERRM,1,200));
2704: RETURN 0;
2705: WHEN OTHERS THEN
2706: fnd_file.put_line(fnd_file.log,'Error while fetching Available Exemption at Beginning of Period ' || SUBSTR(SQLERRM,1,200));
2707: RETURN 0;
2708: END get_start_exempt_limit;
2709:
2710: FUNCTION get_adjustment_exempt_limit

Line 2730: fnd_file.put_line(fnd_file.log,'Adjustment Amount =>: '||l_adjustment_limit);

2726: FROM je_it_year_ex_limit JIY
2727: WHERE JIY.year = to_char(l_period_date,'RRRR')
2728: AND JIY.month = to_char(l_period_date,'MM')
2729: AND JIY.legal_entity_id = P_LEGAL_ENTITY_ID ;
2730: fnd_file.put_line(fnd_file.log,'Adjustment Amount =>: '||l_adjustment_limit);
2731: RETURN l_adjustment_limit;
2732: EXCEPTION
2733: WHEN NO_DATA_FOUND THEN
2734: fnd_file.put_line(fnd_file.log,'Adjustments Yearly Exemption Limit not found' || SUBSTR(SQLERRM,1,200));

Line 2734: fnd_file.put_line(fnd_file.log,'Adjustments Yearly Exemption Limit not found' || SUBSTR(SQLERRM,1,200));

2730: fnd_file.put_line(fnd_file.log,'Adjustment Amount =>: '||l_adjustment_limit);
2731: RETURN l_adjustment_limit;
2732: EXCEPTION
2733: WHEN NO_DATA_FOUND THEN
2734: fnd_file.put_line(fnd_file.log,'Adjustments Yearly Exemption Limit not found' || SUBSTR(SQLERRM,1,200));
2735: RETURN 0;
2736: WHEN OTHERS THEN
2737: fnd_file.put_line(fnd_file.log,'Error while getting Adjustment to Yearly Exemption Limit ' || SUBSTR(SQLERRM,1,200));
2738: RETURN 0;

Line 2737: fnd_file.put_line(fnd_file.log,'Error while getting Adjustment to Yearly Exemption Limit ' || SUBSTR(SQLERRM,1,200));

2733: WHEN NO_DATA_FOUND THEN
2734: fnd_file.put_line(fnd_file.log,'Adjustments Yearly Exemption Limit not found' || SUBSTR(SQLERRM,1,200));
2735: RETURN 0;
2736: WHEN OTHERS THEN
2737: fnd_file.put_line(fnd_file.log,'Error while getting Adjustment to Yearly Exemption Limit ' || SUBSTR(SQLERRM,1,200));
2738: RETURN 0;
2739: END get_adjustment_exempt_limit;
2740:
2741: FUNCTION get_old_debit_vat

Line 2750: fnd_file.put_line(fnd_file.log,'Error while getting Previous Period VAT Credit ' || SUBSTR(SQLERRM,1,200));

2746: -- This is used by the XML Element OLD_DEBIT_VAT
2747: RETURN 0;
2748: EXCEPTION
2749: WHEN OTHERS THEN
2750: fnd_file.put_line(fnd_file.log,'Error while getting Previous Period VAT Credit ' || SUBSTR(SQLERRM,1,200));
2751: RETURN 0;
2752: END get_old_debit_vat;
2753:
2754: FUNCTION JEITPSSR_AMOUNT_TO_PAY(A_TOT_TOT_TAX_AMT_SUM IN NUMBER,

Line 2855: fnd_file.put_line(fnd_file.log,'In jg_zz_summary_all_pkg.JEITPSSR_AMOUNT_TO_PAY ..FINAL_FLAG:'||FINAL_FLAG);

2851: OPEN c_get_period_start_date;
2852: FETCH c_get_period_start_date INTO l_period_start_date;
2853: CLOSE c_get_period_start_date;
2854:
2855: fnd_file.put_line(fnd_file.log,'In jg_zz_summary_all_pkg.JEITPSSR_AMOUNT_TO_PAY ..FINAL_FLAG:'||FINAL_FLAG);
2856: fnd_file.put_line(fnd_file.log,'In jg_zz_summary_all_pkg.JEITPSSR_AMOUNT_TO_PAY ..CARRY_OVER :'||TO_CHAR(CARRY_OVER));
2857: fnd_file.put_line(fnd_file.log,'In jg_zz_summary_all_pkg.JEITPSSR_AMOUNT_TO_PAY ..LAST_PROCESS_DATE :'||TO_CHAR(LAST_PROCESS_DATE));
2858:
2859: IF FINAL_FLAG = 'S' THEN

Line 2856: fnd_file.put_line(fnd_file.log,'In jg_zz_summary_all_pkg.JEITPSSR_AMOUNT_TO_PAY ..CARRY_OVER :'||TO_CHAR(CARRY_OVER));

2852: FETCH c_get_period_start_date INTO l_period_start_date;
2853: CLOSE c_get_period_start_date;
2854:
2855: fnd_file.put_line(fnd_file.log,'In jg_zz_summary_all_pkg.JEITPSSR_AMOUNT_TO_PAY ..FINAL_FLAG:'||FINAL_FLAG);
2856: fnd_file.put_line(fnd_file.log,'In jg_zz_summary_all_pkg.JEITPSSR_AMOUNT_TO_PAY ..CARRY_OVER :'||TO_CHAR(CARRY_OVER));
2857: fnd_file.put_line(fnd_file.log,'In jg_zz_summary_all_pkg.JEITPSSR_AMOUNT_TO_PAY ..LAST_PROCESS_DATE :'||TO_CHAR(LAST_PROCESS_DATE));
2858:
2859: IF FINAL_FLAG = 'S' THEN
2860: IF CARRY_OVER IS NULL THEN

Line 2857: fnd_file.put_line(fnd_file.log,'In jg_zz_summary_all_pkg.JEITPSSR_AMOUNT_TO_PAY ..LAST_PROCESS_DATE :'||TO_CHAR(LAST_PROCESS_DATE));

2853: CLOSE c_get_period_start_date;
2854:
2855: fnd_file.put_line(fnd_file.log,'In jg_zz_summary_all_pkg.JEITPSSR_AMOUNT_TO_PAY ..FINAL_FLAG:'||FINAL_FLAG);
2856: fnd_file.put_line(fnd_file.log,'In jg_zz_summary_all_pkg.JEITPSSR_AMOUNT_TO_PAY ..CARRY_OVER :'||TO_CHAR(CARRY_OVER));
2857: fnd_file.put_line(fnd_file.log,'In jg_zz_summary_all_pkg.JEITPSSR_AMOUNT_TO_PAY ..LAST_PROCESS_DATE :'||TO_CHAR(LAST_PROCESS_DATE));
2858:
2859: IF FINAL_FLAG = 'S' THEN
2860: IF CARRY_OVER IS NULL THEN
2861: IF LAST_PROCESS_DATE IS NULL THEN

Line 2907: fnd_file.put_line(fnd_file.log,'In jg_zz_summary_all_pkg.JEITPSSR_AMOUNT_TO_PAY ' || to_char(AMOUNT_TO_PAY));

2903:
2904: END IF;
2905:
2906: END IF;for bug 7633948*/
2907: fnd_file.put_line(fnd_file.log,'In jg_zz_summary_all_pkg.JEITPSSR_AMOUNT_TO_PAY ' || to_char(AMOUNT_TO_PAY));
2908: RETURN(AMOUNT_TO_PAY);
2909:
2910: EXCEPTION
2911: WHEN INVALID_CARRY_OVER THEN

Line 2912: fnd_file.put_line(fnd_file.log,LOG_MESSAGE);

2908: RETURN(AMOUNT_TO_PAY);
2909:
2910: EXCEPTION
2911: WHEN INVALID_CARRY_OVER THEN
2912: fnd_file.put_line(fnd_file.log,LOG_MESSAGE);
2913: raise_application_error(-20010,LOG_MESSAGE);
2914: WHEN OTHERS THEN
2915: fnd_file.put_line(fnd_file.log,'Error in Procedure jg_zz_summary_all_pkg.JEITPSSR_AMOUNT_TO_PAY ' || SUBSTR(SQLERRM,1,200));
2916: raise_application_error(-20011,'Error in Procedure jg_zz_summary_all_pkg.JEITPSSR_AMOUNT_TO_PAY ' || SUBSTR(SQLERRM,1,200));

Line 2915: fnd_file.put_line(fnd_file.log,'Error in Procedure jg_zz_summary_all_pkg.JEITPSSR_AMOUNT_TO_PAY ' || SUBSTR(SQLERRM,1,200));

2911: WHEN INVALID_CARRY_OVER THEN
2912: fnd_file.put_line(fnd_file.log,LOG_MESSAGE);
2913: raise_application_error(-20010,LOG_MESSAGE);
2914: WHEN OTHERS THEN
2915: fnd_file.put_line(fnd_file.log,'Error in Procedure jg_zz_summary_all_pkg.JEITPSSR_AMOUNT_TO_PAY ' || SUBSTR(SQLERRM,1,200));
2916: raise_application_error(-20011,'Error in Procedure jg_zz_summary_all_pkg.JEITPSSR_AMOUNT_TO_PAY ' || SUBSTR(SQLERRM,1,200));
2917: END JEITPSSR_AMOUNT_TO_PAY;
2918:
2919: /****Added below function JEITPSSR_AMOUNT_TO_PAY_UPDATE for bug 7633948***/

Line 2936: fnd_file.put_line(fnd_file.log,'Called JEITPSSR_AMOUNT_TO_PAY_UPDATE function');

2932: AND JZVRS.tax_calendar_period = p_period
2933: AND ROWNUM = 1;
2934: BEGIN
2935: IF p_report_name = 'JEITPSSR' THEN
2936: fnd_file.put_line(fnd_file.log,'Called JEITPSSR_AMOUNT_TO_PAY_UPDATE function');
2937: OPEN c_get_details;
2938: FETCH c_get_details INTO FINAL_FLAG;
2939: CLOSE c_get_details;
2940: fnd_file.put_line(fnd_file.log,'In JEITPSSR_AMOUNT_TO_PAY_UPDATE FINAL_FLAG:'||FINAL_FLAG);

Line 2940: fnd_file.put_line(fnd_file.log,'In JEITPSSR_AMOUNT_TO_PAY_UPDATE FINAL_FLAG:'||FINAL_FLAG);

2936: fnd_file.put_line(fnd_file.log,'Called JEITPSSR_AMOUNT_TO_PAY_UPDATE function');
2937: OPEN c_get_details;
2938: FETCH c_get_details INTO FINAL_FLAG;
2939: CLOSE c_get_details;
2940: fnd_file.put_line(fnd_file.log,'In JEITPSSR_AMOUNT_TO_PAY_UPDATE FINAL_FLAG:'||FINAL_FLAG);
2941: IF FINAL_FLAG='S' THEN
2942:
2943: IF AMOUNT_TO_PAY >= 0 THEN
2944: CARRY_OVER := 0;

Line 2948: fnd_file.put_line(fnd_file.log,'In JEITPSSR_AMOUNT_TO_PAY_UPDATE TEMP_FLAG:'||TO_CHAR(TEMP_FLAG));

2944: CARRY_OVER := 0;
2945: ELSE
2946: CARRY_OVER := AMOUNT_TO_PAY;
2947: END IF;
2948: fnd_file.put_line(fnd_file.log,'In JEITPSSR_AMOUNT_TO_PAY_UPDATE TEMP_FLAG:'||TO_CHAR(TEMP_FLAG));
2949: fnd_file.put_line(fnd_file.log,'In JEITPSSR_AMOUNT_TO_PAY_UPDATE AMOUNT_TO_PAY:'||TO_CHAR(AMOUNT_TO_PAY));
2950: fnd_file.put_line(fnd_file.log,'In JEITPSSR_AMOUNT_TO_PAY_UPDATE CARRY_OVER:'||TO_CHAR(CARRY_OVER));
2951:
2952: IF TEMP_FLAG = 0 THEN

Line 2949: fnd_file.put_line(fnd_file.log,'In JEITPSSR_AMOUNT_TO_PAY_UPDATE AMOUNT_TO_PAY:'||TO_CHAR(AMOUNT_TO_PAY));

2945: ELSE
2946: CARRY_OVER := AMOUNT_TO_PAY;
2947: END IF;
2948: fnd_file.put_line(fnd_file.log,'In JEITPSSR_AMOUNT_TO_PAY_UPDATE TEMP_FLAG:'||TO_CHAR(TEMP_FLAG));
2949: fnd_file.put_line(fnd_file.log,'In JEITPSSR_AMOUNT_TO_PAY_UPDATE AMOUNT_TO_PAY:'||TO_CHAR(AMOUNT_TO_PAY));
2950: fnd_file.put_line(fnd_file.log,'In JEITPSSR_AMOUNT_TO_PAY_UPDATE CARRY_OVER:'||TO_CHAR(CARRY_OVER));
2951:
2952: IF TEMP_FLAG = 0 THEN
2953:

Line 2950: fnd_file.put_line(fnd_file.log,'In JEITPSSR_AMOUNT_TO_PAY_UPDATE CARRY_OVER:'||TO_CHAR(CARRY_OVER));

2946: CARRY_OVER := AMOUNT_TO_PAY;
2947: END IF;
2948: fnd_file.put_line(fnd_file.log,'In JEITPSSR_AMOUNT_TO_PAY_UPDATE TEMP_FLAG:'||TO_CHAR(TEMP_FLAG));
2949: fnd_file.put_line(fnd_file.log,'In JEITPSSR_AMOUNT_TO_PAY_UPDATE AMOUNT_TO_PAY:'||TO_CHAR(AMOUNT_TO_PAY));
2950: fnd_file.put_line(fnd_file.log,'In JEITPSSR_AMOUNT_TO_PAY_UPDATE CARRY_OVER:'||TO_CHAR(CARRY_OVER));
2951:
2952: IF TEMP_FLAG = 0 THEN
2953:
2954: UPDATE jg_zz_vat_rep_status SET CREDIT_BALANCE_AMT=CARRY_OVER

Line 2965: -- fnd_file.put_line(fnd_file.log,LOG_MESSAGE);

2961: END IF;
2962: RETURN (TRUE);
2963: EXCEPTION
2964: -- WHEN INVALID_CARRY_OVER THEN
2965: -- fnd_file.put_line(fnd_file.log,LOG_MESSAGE);
2966: WHEN OTHERS THEN
2967: fnd_file.put_line(fnd_file.log,'Error in Procedure jg_zz_summary_all_pkg.JEITPSSR_AMOUNT_TO_PAY_UPDATE ' || SUBSTR(SQLERRM,1,200));
2968: RETURN (FALSE);
2969: END JEITPSSR_AMOUNT_TO_PAY_UPDATE;

Line 2967: fnd_file.put_line(fnd_file.log,'Error in Procedure jg_zz_summary_all_pkg.JEITPSSR_AMOUNT_TO_PAY_UPDATE ' || SUBSTR(SQLERRM,1,200));

2963: EXCEPTION
2964: -- WHEN INVALID_CARRY_OVER THEN
2965: -- fnd_file.put_line(fnd_file.log,LOG_MESSAGE);
2966: WHEN OTHERS THEN
2967: fnd_file.put_line(fnd_file.log,'Error in Procedure jg_zz_summary_all_pkg.JEITPSSR_AMOUNT_TO_PAY_UPDATE ' || SUBSTR(SQLERRM,1,200));
2968: RETURN (FALSE);
2969: END JEITPSSR_AMOUNT_TO_PAY_UPDATE;
2970:
2971: /******Added the below function JEILR835 INV_NUM for Bug 7427956*********/