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_JOURNAL_AR_PKG dependencies on FND_FILE

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

89:
90: BEGIN
91:
92: IF p_report_name = 'JEITARSV' THEN
93: fnd_file.put_line(fnd_file.log,'**********************************************************');
94: fnd_file.put_line(fnd_file.log,'Italian Receivables Sales VAT Register');
95: fnd_file.put_line(fnd_file.log,'**********************************************************');
96: fnd_file.put_line(fnd_file.log,'');
97: fnd_file.put_line(fnd_file.log,'Report Parameters');

Line 94: fnd_file.put_line(fnd_file.log,'Italian Receivables Sales VAT Register');

90: BEGIN
91:
92: IF p_report_name = 'JEITARSV' THEN
93: fnd_file.put_line(fnd_file.log,'**********************************************************');
94: fnd_file.put_line(fnd_file.log,'Italian Receivables Sales VAT Register');
95: fnd_file.put_line(fnd_file.log,'**********************************************************');
96: fnd_file.put_line(fnd_file.log,'');
97: fnd_file.put_line(fnd_file.log,'Report Parameters');
98: fnd_file.put_line(fnd_file.log,'Tax Registraion Number : '||p_vat_rep_entity_id);

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

91:
92: IF p_report_name = 'JEITARSV' THEN
93: fnd_file.put_line(fnd_file.log,'**********************************************************');
94: fnd_file.put_line(fnd_file.log,'Italian Receivables Sales VAT Register');
95: fnd_file.put_line(fnd_file.log,'**********************************************************');
96: fnd_file.put_line(fnd_file.log,'');
97: fnd_file.put_line(fnd_file.log,'Report Parameters');
98: fnd_file.put_line(fnd_file.log,'Tax Registraion Number : '||p_vat_rep_entity_id);
99: fnd_file.put_line(fnd_file.log,'Tax Calendar Year : '||p_period);

Line 96: fnd_file.put_line(fnd_file.log,'');

92: IF p_report_name = 'JEITARSV' THEN
93: fnd_file.put_line(fnd_file.log,'**********************************************************');
94: fnd_file.put_line(fnd_file.log,'Italian Receivables Sales VAT Register');
95: fnd_file.put_line(fnd_file.log,'**********************************************************');
96: fnd_file.put_line(fnd_file.log,'');
97: fnd_file.put_line(fnd_file.log,'Report Parameters');
98: fnd_file.put_line(fnd_file.log,'Tax Registraion Number : '||p_vat_rep_entity_id);
99: fnd_file.put_line(fnd_file.log,'Tax Calendar Year : '||p_period);
100: fnd_file.put_line(fnd_file.log,'VAT Register Id : '||p_vat_register_id);

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

93: fnd_file.put_line(fnd_file.log,'**********************************************************');
94: fnd_file.put_line(fnd_file.log,'Italian Receivables Sales VAT Register');
95: fnd_file.put_line(fnd_file.log,'**********************************************************');
96: fnd_file.put_line(fnd_file.log,'');
97: fnd_file.put_line(fnd_file.log,'Report Parameters');
98: fnd_file.put_line(fnd_file.log,'Tax Registraion Number : '||p_vat_rep_entity_id);
99: fnd_file.put_line(fnd_file.log,'Tax Calendar Year : '||p_period);
100: fnd_file.put_line(fnd_file.log,'VAT Register Id : '||p_vat_register_id);
101: fnd_file.put_line(fnd_file.log,'**********************************************************');

Line 98: fnd_file.put_line(fnd_file.log,'Tax Registraion Number : '||p_vat_rep_entity_id);

94: fnd_file.put_line(fnd_file.log,'Italian Receivables Sales VAT Register');
95: fnd_file.put_line(fnd_file.log,'**********************************************************');
96: fnd_file.put_line(fnd_file.log,'');
97: fnd_file.put_line(fnd_file.log,'Report Parameters');
98: fnd_file.put_line(fnd_file.log,'Tax Registraion Number : '||p_vat_rep_entity_id);
99: fnd_file.put_line(fnd_file.log,'Tax Calendar Year : '||p_period);
100: fnd_file.put_line(fnd_file.log,'VAT Register Id : '||p_vat_register_id);
101: fnd_file.put_line(fnd_file.log,'**********************************************************');
102: fnd_file.put_line(fnd_file.log,'');

Line 99: fnd_file.put_line(fnd_file.log,'Tax Calendar Year : '||p_period);

95: fnd_file.put_line(fnd_file.log,'**********************************************************');
96: fnd_file.put_line(fnd_file.log,'');
97: fnd_file.put_line(fnd_file.log,'Report Parameters');
98: fnd_file.put_line(fnd_file.log,'Tax Registraion Number : '||p_vat_rep_entity_id);
99: fnd_file.put_line(fnd_file.log,'Tax Calendar Year : '||p_period);
100: fnd_file.put_line(fnd_file.log,'VAT Register Id : '||p_vat_register_id);
101: fnd_file.put_line(fnd_file.log,'**********************************************************');
102: fnd_file.put_line(fnd_file.log,'');
103: fnd_file.put_line(fnd_file.log,'');

Line 100: fnd_file.put_line(fnd_file.log,'VAT Register Id : '||p_vat_register_id);

96: fnd_file.put_line(fnd_file.log,'');
97: fnd_file.put_line(fnd_file.log,'Report Parameters');
98: fnd_file.put_line(fnd_file.log,'Tax Registraion Number : '||p_vat_rep_entity_id);
99: fnd_file.put_line(fnd_file.log,'Tax Calendar Year : '||p_period);
100: fnd_file.put_line(fnd_file.log,'VAT Register Id : '||p_vat_register_id);
101: fnd_file.put_line(fnd_file.log,'**********************************************************');
102: fnd_file.put_line(fnd_file.log,'');
103: fnd_file.put_line(fnd_file.log,'');
104:

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

97: fnd_file.put_line(fnd_file.log,'Report Parameters');
98: fnd_file.put_line(fnd_file.log,'Tax Registraion Number : '||p_vat_rep_entity_id);
99: fnd_file.put_line(fnd_file.log,'Tax Calendar Year : '||p_period);
100: fnd_file.put_line(fnd_file.log,'VAT Register Id : '||p_vat_register_id);
101: fnd_file.put_line(fnd_file.log,'**********************************************************');
102: fnd_file.put_line(fnd_file.log,'');
103: fnd_file.put_line(fnd_file.log,'');
104:
105: BEGIN

Line 102: fnd_file.put_line(fnd_file.log,'');

98: fnd_file.put_line(fnd_file.log,'Tax Registraion Number : '||p_vat_rep_entity_id);
99: fnd_file.put_line(fnd_file.log,'Tax Calendar Year : '||p_period);
100: fnd_file.put_line(fnd_file.log,'VAT Register Id : '||p_vat_register_id);
101: fnd_file.put_line(fnd_file.log,'**********************************************************');
102: fnd_file.put_line(fnd_file.log,'');
103: fnd_file.put_line(fnd_file.log,'');
104:
105: BEGIN
106:

Line 103: fnd_file.put_line(fnd_file.log,'');

99: fnd_file.put_line(fnd_file.log,'Tax Calendar Year : '||p_period);
100: fnd_file.put_line(fnd_file.log,'VAT Register Id : '||p_vat_register_id);
101: fnd_file.put_line(fnd_file.log,'**********************************************************');
102: fnd_file.put_line(fnd_file.log,'');
103: fnd_file.put_line(fnd_file.log,'');
104:
105: BEGIN
106:
107: SELECT register_name

Line 128: fnd_file.put_line(fnd_file.log,'An error occured in the before report trigger, while fetching the VAT Register name. Exception : ' || SUBSTR(SQLERRM,1,200) || SQLCODE);

124: AND jzvr.vat_register_id = p_vat_register_id
125: AND jzvr.register_type = 'SALES_VAT' ;
126: EXCEPTION
127: WHEN OTHERS THEN
128: fnd_file.put_line(fnd_file.log,'An error occured in the before report trigger, while fetching the VAT Register name. Exception : ' || SUBSTR(SQLERRM,1,200) || SQLCODE);
129: raise;
130: RETURN(FALSE);
131: END;
132:

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

132:
133: END IF;
134:
135: IF p_report_name = 'JEITRDVR' THEN
136: fnd_file.put_line(fnd_file.log,'**********************************************************');
137: fnd_file.put_line(fnd_file.log,'Italian Receivables Deferred VAT Register');
138: fnd_file.put_line(fnd_file.log,'**********************************************************');
139: fnd_file.put_line(fnd_file.log,'');
140: fnd_file.put_line(fnd_file.log,'Report Parameters');

Line 137: fnd_file.put_line(fnd_file.log,'Italian Receivables Deferred VAT Register');

133: END IF;
134:
135: IF p_report_name = 'JEITRDVR' THEN
136: fnd_file.put_line(fnd_file.log,'**********************************************************');
137: fnd_file.put_line(fnd_file.log,'Italian Receivables Deferred VAT Register');
138: fnd_file.put_line(fnd_file.log,'**********************************************************');
139: fnd_file.put_line(fnd_file.log,'');
140: fnd_file.put_line(fnd_file.log,'Report Parameters');
141: fnd_file.put_line(fnd_file.log,'Tax Registraion Number : '||p_vat_rep_entity_id);

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

134:
135: IF p_report_name = 'JEITRDVR' THEN
136: fnd_file.put_line(fnd_file.log,'**********************************************************');
137: fnd_file.put_line(fnd_file.log,'Italian Receivables Deferred VAT Register');
138: fnd_file.put_line(fnd_file.log,'**********************************************************');
139: fnd_file.put_line(fnd_file.log,'');
140: fnd_file.put_line(fnd_file.log,'Report Parameters');
141: fnd_file.put_line(fnd_file.log,'Tax Registraion Number : '||p_vat_rep_entity_id);
142: fnd_file.put_line(fnd_file.log,'Tax Calendar Year : '||p_period);

Line 139: fnd_file.put_line(fnd_file.log,'');

135: IF p_report_name = 'JEITRDVR' THEN
136: fnd_file.put_line(fnd_file.log,'**********************************************************');
137: fnd_file.put_line(fnd_file.log,'Italian Receivables Deferred VAT Register');
138: fnd_file.put_line(fnd_file.log,'**********************************************************');
139: fnd_file.put_line(fnd_file.log,'');
140: fnd_file.put_line(fnd_file.log,'Report Parameters');
141: fnd_file.put_line(fnd_file.log,'Tax Registraion Number : '||p_vat_rep_entity_id);
142: fnd_file.put_line(fnd_file.log,'Tax Calendar Year : '||p_period);
143: fnd_file.put_line(fnd_file.log,'VAT Register Id : '||p_vat_register_id);

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

136: fnd_file.put_line(fnd_file.log,'**********************************************************');
137: fnd_file.put_line(fnd_file.log,'Italian Receivables Deferred VAT Register');
138: fnd_file.put_line(fnd_file.log,'**********************************************************');
139: fnd_file.put_line(fnd_file.log,'');
140: fnd_file.put_line(fnd_file.log,'Report Parameters');
141: fnd_file.put_line(fnd_file.log,'Tax Registraion Number : '||p_vat_rep_entity_id);
142: fnd_file.put_line(fnd_file.log,'Tax Calendar Year : '||p_period);
143: fnd_file.put_line(fnd_file.log,'VAT Register Id : '||p_vat_register_id);
144: fnd_file.put_line(fnd_file.log,'**********************************************************');

Line 141: fnd_file.put_line(fnd_file.log,'Tax Registraion Number : '||p_vat_rep_entity_id);

137: fnd_file.put_line(fnd_file.log,'Italian Receivables Deferred VAT Register');
138: fnd_file.put_line(fnd_file.log,'**********************************************************');
139: fnd_file.put_line(fnd_file.log,'');
140: fnd_file.put_line(fnd_file.log,'Report Parameters');
141: fnd_file.put_line(fnd_file.log,'Tax Registraion Number : '||p_vat_rep_entity_id);
142: fnd_file.put_line(fnd_file.log,'Tax Calendar Year : '||p_period);
143: fnd_file.put_line(fnd_file.log,'VAT Register Id : '||p_vat_register_id);
144: fnd_file.put_line(fnd_file.log,'**********************************************************');
145: fnd_file.put_line(fnd_file.log,'');

Line 142: fnd_file.put_line(fnd_file.log,'Tax Calendar Year : '||p_period);

138: fnd_file.put_line(fnd_file.log,'**********************************************************');
139: fnd_file.put_line(fnd_file.log,'');
140: fnd_file.put_line(fnd_file.log,'Report Parameters');
141: fnd_file.put_line(fnd_file.log,'Tax Registraion Number : '||p_vat_rep_entity_id);
142: fnd_file.put_line(fnd_file.log,'Tax Calendar Year : '||p_period);
143: fnd_file.put_line(fnd_file.log,'VAT Register Id : '||p_vat_register_id);
144: fnd_file.put_line(fnd_file.log,'**********************************************************');
145: fnd_file.put_line(fnd_file.log,'');
146: fnd_file.put_line(fnd_file.log,'');

Line 143: fnd_file.put_line(fnd_file.log,'VAT Register Id : '||p_vat_register_id);

139: fnd_file.put_line(fnd_file.log,'');
140: fnd_file.put_line(fnd_file.log,'Report Parameters');
141: fnd_file.put_line(fnd_file.log,'Tax Registraion Number : '||p_vat_rep_entity_id);
142: fnd_file.put_line(fnd_file.log,'Tax Calendar Year : '||p_period);
143: fnd_file.put_line(fnd_file.log,'VAT Register Id : '||p_vat_register_id);
144: fnd_file.put_line(fnd_file.log,'**********************************************************');
145: fnd_file.put_line(fnd_file.log,'');
146: fnd_file.put_line(fnd_file.log,'');
147:

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

140: fnd_file.put_line(fnd_file.log,'Report Parameters');
141: fnd_file.put_line(fnd_file.log,'Tax Registraion Number : '||p_vat_rep_entity_id);
142: fnd_file.put_line(fnd_file.log,'Tax Calendar Year : '||p_period);
143: fnd_file.put_line(fnd_file.log,'VAT Register Id : '||p_vat_register_id);
144: fnd_file.put_line(fnd_file.log,'**********************************************************');
145: fnd_file.put_line(fnd_file.log,'');
146: fnd_file.put_line(fnd_file.log,'');
147:
148: BEGIN

Line 145: fnd_file.put_line(fnd_file.log,'');

141: fnd_file.put_line(fnd_file.log,'Tax Registraion Number : '||p_vat_rep_entity_id);
142: fnd_file.put_line(fnd_file.log,'Tax Calendar Year : '||p_period);
143: fnd_file.put_line(fnd_file.log,'VAT Register Id : '||p_vat_register_id);
144: fnd_file.put_line(fnd_file.log,'**********************************************************');
145: fnd_file.put_line(fnd_file.log,'');
146: fnd_file.put_line(fnd_file.log,'');
147:
148: BEGIN
149:

Line 146: fnd_file.put_line(fnd_file.log,'');

142: fnd_file.put_line(fnd_file.log,'Tax Calendar Year : '||p_period);
143: fnd_file.put_line(fnd_file.log,'VAT Register Id : '||p_vat_register_id);
144: fnd_file.put_line(fnd_file.log,'**********************************************************');
145: fnd_file.put_line(fnd_file.log,'');
146: fnd_file.put_line(fnd_file.log,'');
147:
148: BEGIN
149:
150: SELECT register_name

Line 172: fnd_file.put_line(fnd_file.log,'An error occured in the before report trigger, while fetching the VAT Register name. Exception : ' || SUBSTR(SQLERRM,1,200) || SQLCODE);

168: AND jzvr.register_type = 'DEFERRED_VAT';
169:
170: EXCEPTION
171: WHEN OTHERS THEN
172: fnd_file.put_line(fnd_file.log,'An error occured in the before report trigger, while fetching the VAT Register name. Exception : ' || SUBSTR(SQLERRM,1,200) || SQLCODE);
173: raise;
174: RETURN(FALSE);
175: END;
176:

Line 179: fnd_file.put_line(fnd_file.log,'before Report Trigger');

175: END;
176:
177: END IF;
178:
179: fnd_file.put_line(fnd_file.log,'before Report Trigger');
180: jg_zz_common_pkg.funct_curr_legal(x_func_curr_code => l_func_curr
181: ,x_rep_entity_name => l_legal_entity_name
182: ,x_legal_entity_id => l_legal_entity_id
183: ,x_taxpayer_id => l_tax_payer_id

Line 187: fnd_file.put_line(fnd_file.log,'Calling jg_zz_common_pkg.tax_registration');

183: ,x_taxpayer_id => l_tax_payer_id
184: ,pn_vat_rep_entity_id => p_vat_rep_entity_id
185: ,pv_period_name => p_period);
186:
187: fnd_file.put_line(fnd_file.log,'Calling jg_zz_common_pkg.tax_registration');
188: -- Bug8267272 Start
189: IF P_REPORT_NAME = 'JEESRRVR' THEN
190: jg_zz_common_pkg.tax_registration(x_tax_registration => l_tax_registration_num
191: ,x_period_start_date => l_period_start_date

Line 215: fnd_file.put_line(fnd_file.log,'Calling jg_zz_common_pkg.company_detail');

211: ,pv_source => 'ALL');
212: end if;
213: -- Bug8267272 End
214:
215: fnd_file.put_line(fnd_file.log,'Calling jg_zz_common_pkg.company_detail');
216: jg_zz_common_pkg.company_detail(x_company_name => l_company_name
217: ,x_registration_number => l_registration_num
218: ,x_country => l_country
219: ,x_address1 => l_address_line_1

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

267: ,pv_source => NULL
268: ,pv_report_name => p_report_name);
269: END IF;
270:
271: fnd_file.put_line(fnd_file.log,'P_REPORT_NAME :'||P_REPORT_NAME);
272: fnd_file.put_line(fnd_file.log,'P_SEQUENCE :'||P_SEQUENCE);
273: fnd_file.put_line(fnd_file.log,'l_period_start_date :'||l_period_start_date);
274: fnd_file.put_line(fnd_file.log,'l_period_end_date :'||l_period_end_date);
275:

Line 272: fnd_file.put_line(fnd_file.log,'P_SEQUENCE :'||P_SEQUENCE);

268: ,pv_report_name => p_report_name);
269: END IF;
270:
271: fnd_file.put_line(fnd_file.log,'P_REPORT_NAME :'||P_REPORT_NAME);
272: fnd_file.put_line(fnd_file.log,'P_SEQUENCE :'||P_SEQUENCE);
273: fnd_file.put_line(fnd_file.log,'l_period_start_date :'||l_period_start_date);
274: fnd_file.put_line(fnd_file.log,'l_period_end_date :'||l_period_end_date);
275:
276: IF P_REPORT_NAME = 'JEESRRVR' THEN

Line 273: fnd_file.put_line(fnd_file.log,'l_period_start_date :'||l_period_start_date);

269: END IF;
270:
271: fnd_file.put_line(fnd_file.log,'P_REPORT_NAME :'||P_REPORT_NAME);
272: fnd_file.put_line(fnd_file.log,'P_SEQUENCE :'||P_SEQUENCE);
273: fnd_file.put_line(fnd_file.log,'l_period_start_date :'||l_period_start_date);
274: fnd_file.put_line(fnd_file.log,'l_period_end_date :'||l_period_end_date);
275:
276: IF P_REPORT_NAME = 'JEESRRVR' THEN
277: IF P_SEQUENCE = 'Y' THEN

Line 274: fnd_file.put_line(fnd_file.log,'l_period_end_date :'||l_period_end_date);

270:
271: fnd_file.put_line(fnd_file.log,'P_REPORT_NAME :'||P_REPORT_NAME);
272: fnd_file.put_line(fnd_file.log,'P_SEQUENCE :'||P_SEQUENCE);
273: fnd_file.put_line(fnd_file.log,'l_period_start_date :'||l_period_start_date);
274: fnd_file.put_line(fnd_file.log,'l_period_end_date :'||l_period_end_date);
275:
276: IF P_REPORT_NAME = 'JEESRRVR' THEN
277: IF P_SEQUENCE = 'Y' THEN
278: BEGIN

Line 335: fnd_file.put_line(fnd_file.log,'l_sequence_start :'||l_sequence_start);

331: AND trunc(l_period_start_date,'YYYY') <= all
332: (select trx_date from jg_zz_vat_trx_details A
333: where A.trx_id = JZVTD.trx_id );
334:
335: fnd_file.put_line(fnd_file.log,'l_sequence_start :'||l_sequence_start);
336:
337: EXCEPTION
338: WHEN NO_DATA_FOUND THEN
339: l_sequence_start := 0;

Line 341: fnd_file.put_line(fnd_file.log,'An error occured while calculating the l_sequence_start. Exception : ' || SUBSTR(SQLERRM,1,200) || SQLCODE);

337: EXCEPTION
338: WHEN NO_DATA_FOUND THEN
339: l_sequence_start := 0;
340: WHEN OTHERS THEN
341: fnd_file.put_line(fnd_file.log,'An error occured while calculating the l_sequence_start. Exception : ' || SUBSTR(SQLERRM,1,200) || SQLCODE);
342: END;
343: ELSE
344: l_sequence_start := 0;
345: END IF;

Line 405: fnd_file.put_line(fnd_file.log,'Calling jebedv07');

401: ,l_vat_reg_num
402: );
403:
404: IF P_REPORT_NAME = 'JEBEDV07' THEN
405: fnd_file.put_line(fnd_file.log,'Calling jebedv07');
406: jebedv07(p_vat_rep_entity_id => p_vat_rep_entity_id
407: ,p_period => p_period
408: ,p_document_sequence_name_from => p_document_sequence_name_from
409: ,p_document_sequence_name_to => p_document_sequence_name_to

Line 414: fnd_file.put_line(fnd_file.log,'After Calling jebedv07');

410: ,p_customer_name_from => p_customer_name_from
411: ,p_customer_name_to => p_customer_name_to
412: ,p_detail_summary => p_detail_summary
413: ,x_err_msg => l_err_msg);
414: fnd_file.put_line(fnd_file.log,'After Calling jebedv07');
415: ELSIF P_REPORT_NAME = 'JEITARSV' THEN
416: fnd_file.put_line(fnd_file.log,'Calling jeitarsv');
417: jeitarsv(p_vat_rep_entity_id => p_vat_rep_entity_id
418: ,p_period => p_period

Line 416: fnd_file.put_line(fnd_file.log,'Calling jeitarsv');

412: ,p_detail_summary => p_detail_summary
413: ,x_err_msg => l_err_msg);
414: fnd_file.put_line(fnd_file.log,'After Calling jebedv07');
415: ELSIF P_REPORT_NAME = 'JEITARSV' THEN
416: fnd_file.put_line(fnd_file.log,'Calling jeitarsv');
417: jeitarsv(p_vat_rep_entity_id => p_vat_rep_entity_id
418: ,p_period => p_period
419: ,p_vat_register_id => p_vat_register_id
420: ,x_err_msg => l_err_msg);

Line 421: fnd_file.put_line(fnd_file.log,'After Calling jeitarsv');

417: jeitarsv(p_vat_rep_entity_id => p_vat_rep_entity_id
418: ,p_period => p_period
419: ,p_vat_register_id => p_vat_register_id
420: ,x_err_msg => l_err_msg);
421: fnd_file.put_line(fnd_file.log,'After Calling jeitarsv');
422: ELSIF P_REPORT_NAME = 'JEITRDVR' THEN
423: fnd_file.put_line(fnd_file.log,'Calling jeitrdvr');
424: jeitrdvr(p_vat_rep_entity_id => p_vat_rep_entity_id
425: ,p_period => p_period

Line 423: fnd_file.put_line(fnd_file.log,'Calling jeitrdvr');

419: ,p_vat_register_id => p_vat_register_id
420: ,x_err_msg => l_err_msg);
421: fnd_file.put_line(fnd_file.log,'After Calling jeitarsv');
422: ELSIF P_REPORT_NAME = 'JEITRDVR' THEN
423: fnd_file.put_line(fnd_file.log,'Calling jeitrdvr');
424: jeitrdvr(p_vat_rep_entity_id => p_vat_rep_entity_id
425: ,p_period => p_period
426: ,p_vat_register_id => p_vat_register_id
427: ,x_err_msg => l_err_msg);

Line 428: fnd_file.put_line(fnd_file.log,'After Calling jeitrdvr');

424: jeitrdvr(p_vat_rep_entity_id => p_vat_rep_entity_id
425: ,p_period => p_period
426: ,p_vat_register_id => p_vat_register_id
427: ,x_err_msg => l_err_msg);
428: fnd_file.put_line(fnd_file.log,'After Calling jeitrdvr');
429: ELSIF P_REPORT_NAME = 'JEESRRVR' THEN
430: fnd_file.put_line(fnd_file.log,'Calling jeesrrvr');
431: fnd_file.put_line(fnd_file.log,'--PARAMETERS--');
432: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID :'||P_VAT_REP_ENTITY_ID);

Line 430: fnd_file.put_line(fnd_file.log,'Calling jeesrrvr');

426: ,p_vat_register_id => p_vat_register_id
427: ,x_err_msg => l_err_msg);
428: fnd_file.put_line(fnd_file.log,'After Calling jeitrdvr');
429: ELSIF P_REPORT_NAME = 'JEESRRVR' THEN
430: fnd_file.put_line(fnd_file.log,'Calling jeesrrvr');
431: fnd_file.put_line(fnd_file.log,'--PARAMETERS--');
432: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID :'||P_VAT_REP_ENTITY_ID);
433: fnd_file.put_line(fnd_file.log,'P_PERIOD :'||P_PERIOD);
434: fnd_file.put_line(fnd_file.log,'P_TAX_TYPE :'||P_TAX_TYPE);

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

427: ,x_err_msg => l_err_msg);
428: fnd_file.put_line(fnd_file.log,'After Calling jeitrdvr');
429: ELSIF P_REPORT_NAME = 'JEESRRVR' THEN
430: fnd_file.put_line(fnd_file.log,'Calling jeesrrvr');
431: fnd_file.put_line(fnd_file.log,'--PARAMETERS--');
432: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID :'||P_VAT_REP_ENTITY_ID);
433: fnd_file.put_line(fnd_file.log,'P_PERIOD :'||P_PERIOD);
434: fnd_file.put_line(fnd_file.log,'P_TAX_TYPE :'||P_TAX_TYPE);
435: fnd_file.put_line(fnd_file.log,'P_TAX_REGISTER_TYPE :'||P_TAX_REGISTER_TYPE );

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

428: fnd_file.put_line(fnd_file.log,'After Calling jeitrdvr');
429: ELSIF P_REPORT_NAME = 'JEESRRVR' THEN
430: fnd_file.put_line(fnd_file.log,'Calling jeesrrvr');
431: fnd_file.put_line(fnd_file.log,'--PARAMETERS--');
432: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID :'||P_VAT_REP_ENTITY_ID);
433: fnd_file.put_line(fnd_file.log,'P_PERIOD :'||P_PERIOD);
434: fnd_file.put_line(fnd_file.log,'P_TAX_TYPE :'||P_TAX_TYPE);
435: fnd_file.put_line(fnd_file.log,'P_TAX_REGISTER_TYPE :'||P_TAX_REGISTER_TYPE );
436: fnd_file.put_line(fnd_file.log,'P_CHART_OF_ACCOUNT_ID :'||P_CHART_OF_ACCOUNT_ID);

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

429: ELSIF P_REPORT_NAME = 'JEESRRVR' THEN
430: fnd_file.put_line(fnd_file.log,'Calling jeesrrvr');
431: fnd_file.put_line(fnd_file.log,'--PARAMETERS--');
432: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID :'||P_VAT_REP_ENTITY_ID);
433: fnd_file.put_line(fnd_file.log,'P_PERIOD :'||P_PERIOD);
434: fnd_file.put_line(fnd_file.log,'P_TAX_TYPE :'||P_TAX_TYPE);
435: fnd_file.put_line(fnd_file.log,'P_TAX_REGISTER_TYPE :'||P_TAX_REGISTER_TYPE );
436: fnd_file.put_line(fnd_file.log,'P_CHART_OF_ACCOUNT_ID :'||P_CHART_OF_ACCOUNT_ID);
437: fnd_file.put_line(fnd_file.log,'P_BALANCING_SEGMENT :'||P_BALANCING_SEGMENT );

Line 434: fnd_file.put_line(fnd_file.log,'P_TAX_TYPE :'||P_TAX_TYPE);

430: fnd_file.put_line(fnd_file.log,'Calling jeesrrvr');
431: fnd_file.put_line(fnd_file.log,'--PARAMETERS--');
432: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID :'||P_VAT_REP_ENTITY_ID);
433: fnd_file.put_line(fnd_file.log,'P_PERIOD :'||P_PERIOD);
434: fnd_file.put_line(fnd_file.log,'P_TAX_TYPE :'||P_TAX_TYPE);
435: fnd_file.put_line(fnd_file.log,'P_TAX_REGISTER_TYPE :'||P_TAX_REGISTER_TYPE );
436: fnd_file.put_line(fnd_file.log,'P_CHART_OF_ACCOUNT_ID :'||P_CHART_OF_ACCOUNT_ID);
437: fnd_file.put_line(fnd_file.log,'P_BALANCING_SEGMENT :'||P_BALANCING_SEGMENT );
438: fnd_file.put_line(fnd_file.log,'P_SEQUENCE :'||P_SEQUENCE);

Line 435: fnd_file.put_line(fnd_file.log,'P_TAX_REGISTER_TYPE :'||P_TAX_REGISTER_TYPE );

431: fnd_file.put_line(fnd_file.log,'--PARAMETERS--');
432: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID :'||P_VAT_REP_ENTITY_ID);
433: fnd_file.put_line(fnd_file.log,'P_PERIOD :'||P_PERIOD);
434: fnd_file.put_line(fnd_file.log,'P_TAX_TYPE :'||P_TAX_TYPE);
435: fnd_file.put_line(fnd_file.log,'P_TAX_REGISTER_TYPE :'||P_TAX_REGISTER_TYPE );
436: fnd_file.put_line(fnd_file.log,'P_CHART_OF_ACCOUNT_ID :'||P_CHART_OF_ACCOUNT_ID);
437: fnd_file.put_line(fnd_file.log,'P_BALANCING_SEGMENT :'||P_BALANCING_SEGMENT );
438: fnd_file.put_line(fnd_file.log,'P_SEQUENCE :'||P_SEQUENCE);
439:

Line 436: fnd_file.put_line(fnd_file.log,'P_CHART_OF_ACCOUNT_ID :'||P_CHART_OF_ACCOUNT_ID);

432: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID :'||P_VAT_REP_ENTITY_ID);
433: fnd_file.put_line(fnd_file.log,'P_PERIOD :'||P_PERIOD);
434: fnd_file.put_line(fnd_file.log,'P_TAX_TYPE :'||P_TAX_TYPE);
435: fnd_file.put_line(fnd_file.log,'P_TAX_REGISTER_TYPE :'||P_TAX_REGISTER_TYPE );
436: fnd_file.put_line(fnd_file.log,'P_CHART_OF_ACCOUNT_ID :'||P_CHART_OF_ACCOUNT_ID);
437: fnd_file.put_line(fnd_file.log,'P_BALANCING_SEGMENT :'||P_BALANCING_SEGMENT );
438: fnd_file.put_line(fnd_file.log,'P_SEQUENCE :'||P_SEQUENCE);
439:
440: jeesrrvr(p_vat_rep_entity_id => p_vat_rep_entity_id

Line 437: fnd_file.put_line(fnd_file.log,'P_BALANCING_SEGMENT :'||P_BALANCING_SEGMENT );

433: fnd_file.put_line(fnd_file.log,'P_PERIOD :'||P_PERIOD);
434: fnd_file.put_line(fnd_file.log,'P_TAX_TYPE :'||P_TAX_TYPE);
435: fnd_file.put_line(fnd_file.log,'P_TAX_REGISTER_TYPE :'||P_TAX_REGISTER_TYPE );
436: fnd_file.put_line(fnd_file.log,'P_CHART_OF_ACCOUNT_ID :'||P_CHART_OF_ACCOUNT_ID);
437: fnd_file.put_line(fnd_file.log,'P_BALANCING_SEGMENT :'||P_BALANCING_SEGMENT );
438: fnd_file.put_line(fnd_file.log,'P_SEQUENCE :'||P_SEQUENCE);
439:
440: jeesrrvr(p_vat_rep_entity_id => p_vat_rep_entity_id
441: ,p_period => p_period

Line 438: fnd_file.put_line(fnd_file.log,'P_SEQUENCE :'||P_SEQUENCE);

434: fnd_file.put_line(fnd_file.log,'P_TAX_TYPE :'||P_TAX_TYPE);
435: fnd_file.put_line(fnd_file.log,'P_TAX_REGISTER_TYPE :'||P_TAX_REGISTER_TYPE );
436: fnd_file.put_line(fnd_file.log,'P_CHART_OF_ACCOUNT_ID :'||P_CHART_OF_ACCOUNT_ID);
437: fnd_file.put_line(fnd_file.log,'P_BALANCING_SEGMENT :'||P_BALANCING_SEGMENT );
438: fnd_file.put_line(fnd_file.log,'P_SEQUENCE :'||P_SEQUENCE);
439:
440: jeesrrvr(p_vat_rep_entity_id => p_vat_rep_entity_id
441: ,p_period => p_period
442: ,p_period_to => p_period_to -- Bug8267272

Line 447: fnd_file.put_line(fnd_file.log,'After Calling jeesrrvr');

443: ,p_tax_type => p_tax_type
444: ,p_tax_register_type => p_tax_register_type
445: ,p_sequence => p_sequence
446: ,x_err_msg => l_err_msg);
447: fnd_file.put_line(fnd_file.log,'After Calling jeesrrvr');
448: ELSIF (P_REPORT_NAME = 'JOURNAL-AR' OR P_REPORT_NAME IS NOT NULL) THEN
449: fnd_file.put_line(fnd_file.log,'Calling journal_ar');
450: NULL;
451: fnd_file.put_line(fnd_file.log,'After Calling journal_ar');

Line 449: fnd_file.put_line(fnd_file.log,'Calling journal_ar');

445: ,p_sequence => p_sequence
446: ,x_err_msg => l_err_msg);
447: fnd_file.put_line(fnd_file.log,'After Calling jeesrrvr');
448: ELSIF (P_REPORT_NAME = 'JOURNAL-AR' OR P_REPORT_NAME IS NOT NULL) THEN
449: fnd_file.put_line(fnd_file.log,'Calling journal_ar');
450: NULL;
451: fnd_file.put_line(fnd_file.log,'After Calling journal_ar');
452: END IF;
453: RETURN (TRUE);

Line 451: fnd_file.put_line(fnd_file.log,'After Calling journal_ar');

447: fnd_file.put_line(fnd_file.log,'After Calling jeesrrvr');
448: ELSIF (P_REPORT_NAME = 'JOURNAL-AR' OR P_REPORT_NAME IS NOT NULL) THEN
449: fnd_file.put_line(fnd_file.log,'Calling journal_ar');
450: NULL;
451: fnd_file.put_line(fnd_file.log,'After Calling journal_ar');
452: END IF;
453: RETURN (TRUE);
454: EXCEPTION
455: WHEN OTHERS THEN

Line 456: fnd_file.put_line(fnd_file.log,'An error occured in the before report trigger. Exception : ' || SUBSTR(SQLERRM,1,200) || SQLCODE);

452: END IF;
453: RETURN (TRUE);
454: EXCEPTION
455: WHEN OTHERS THEN
456: fnd_file.put_line(fnd_file.log,'An error occured in the before report trigger. Exception : ' || SUBSTR(SQLERRM,1,200) || SQLCODE);
457: raise;
458: RETURN(FALSE);
459: END beforeReport;
460:

Line 619: fnd_file.put_line(fnd_file.log,'An error occured in the Procedure JEBEDV07. Exception : ' || SUBSTR(SQLERRM,1,200) || SQLCODE);

615: END LOOP;
616:
617: EXCEPTION
618: WHEN OTHERS THEN
619: fnd_file.put_line(fnd_file.log,'An error occured in the Procedure JEBEDV07. Exception : ' || SUBSTR(SQLERRM,1,200) || SQLCODE);
620: END jebedv07;
621:
622: --
623: -- +======================================================================+

Line 791: fnd_file.put_line(fnd_file.log,'An error occured in the Procedure JEITARSV. Exception : ' || SUBSTR(SQLERRM,1,200) || SQLCODE);

787: END IF;
788:
789: EXCEPTION
790: WHEN OTHERS THEN
791: fnd_file.put_line(fnd_file.log,'An error occured in the Procedure JEITARSV. Exception : ' || SUBSTR(SQLERRM,1,200) || SQLCODE);
792: END jeitarsv;
793:
794:
795: --

Line 973: fnd_file.put_line(fnd_file.log,'An error occured in the Procedure JEITRDVR. Exception : ' || SUBSTR(SQLERRM,1,200) || SQLCODE);

969: END IF;
970:
971: EXCEPTION
972: WHEN OTHERS THEN
973: fnd_file.put_line(fnd_file.log,'An error occured in the Procedure JEITRDVR. Exception : ' || SUBSTR(SQLERRM,1,200) || SQLCODE);
974: END jeitrdvr;
975:
976:
977: --

Line 1106: fnd_file.put_line(fnd_file.log,'An error occured in the Procedure JEESRRVR. Exception : ' || SUBSTR(SQLERRM,1,200) || SQLCODE);

1102:
1103:
1104: EXCEPTION
1105: WHEN OTHERS THEN
1106: fnd_file.put_line(fnd_file.log,'An error occured in the Procedure JEESRRVR. Exception : ' || SUBSTR(SQLERRM,1,200) || SQLCODE);
1107: END jeesrrvr;
1108:
1109: FUNCTION get_sequence_number RETURN NUMBER IS
1110: l_start_seq NUMBER;