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_TURNOVER_AR_PKG dependencies on JG_ZZ_COMMON_PKG

Line 164: fnd_file.put_line(fnd_file.log,'Calling jg_zz_common_pkg.funct_curr_legal');

160: BEGIN
161: -- Call to Common Package
162: IF p_debug_flag = 'Y' THEN
163: fnd_file.put_line(fnd_file.log,'Executing jg_zz_turnover_ar_pkg.before_report');
164: fnd_file.put_line(fnd_file.log,'Calling jg_zz_common_pkg.funct_curr_legal');
165: END IF;
166: BEGIN
167: jg_zz_common_pkg.funct_curr_legal(x_func_curr_code => l_func_curr
168: ,x_rep_entity_name => l_legal_entity_name

Line 167: jg_zz_common_pkg.funct_curr_legal(x_func_curr_code => l_func_curr

163: fnd_file.put_line(fnd_file.log,'Executing jg_zz_turnover_ar_pkg.before_report');
164: fnd_file.put_line(fnd_file.log,'Calling jg_zz_common_pkg.funct_curr_legal');
165: END IF;
166: BEGIN
167: jg_zz_common_pkg.funct_curr_legal(x_func_curr_code => l_func_curr
168: ,x_rep_entity_name => l_legal_entity_name
169: ,x_legal_entity_id => l_legal_entity_id
170: ,x_taxpayer_id => l_tax_payer_id
171: ,pn_vat_rep_entity_id => p_vat_rep_entity_id

Line 175: fnd_file.put_line(fnd_file.log,'Executing jg_zz_common_pkg.funct_curr_legal failed with Error: '||SUBSTR(SQLERRM,1,200));

171: ,pn_vat_rep_entity_id => p_vat_rep_entity_id
172: ,pn_period_year => p_period);
173: EXCEPTION
174: WHEN OTHERS THEN
175: fnd_file.put_line(fnd_file.log,'Executing jg_zz_common_pkg.funct_curr_legal failed with Error: '||SUBSTR(SQLERRM,1,200));
176: END;
177: IF p_debug_flag = 'Y' THEN
178: fnd_file.put_line(fnd_file.log,'Calling jg_zz_common_pkg.tax_registration');
179: END IF;

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

174: WHEN OTHERS THEN
175: fnd_file.put_line(fnd_file.log,'Executing jg_zz_common_pkg.funct_curr_legal failed with Error: '||SUBSTR(SQLERRM,1,200));
176: END;
177: IF p_debug_flag = 'Y' THEN
178: fnd_file.put_line(fnd_file.log,'Calling jg_zz_common_pkg.tax_registration');
179: END IF;
180: BEGIN
181: jg_zz_common_pkg.tax_registration(x_tax_registration => l_tax_registration_num
182: ,x_period_start_date => l_period_start_date

Line 181: jg_zz_common_pkg.tax_registration(x_tax_registration => l_tax_registration_num

177: IF p_debug_flag = 'Y' THEN
178: fnd_file.put_line(fnd_file.log,'Calling jg_zz_common_pkg.tax_registration');
179: END IF;
180: BEGIN
181: jg_zz_common_pkg.tax_registration(x_tax_registration => l_tax_registration_num
182: ,x_period_start_date => l_period_start_date
183: ,x_period_end_date => l_period_end_date
184: ,x_status => l_reporting_status
185: ,pn_vat_rep_entity_id => p_vat_rep_entity_id

Line 191: fnd_file.put_line(fnd_file.log,'Executing jg_zz_common_pkg.tax_registration failed with Error: '||SUBSTR(SQLERRM,1,200));

187: ,pn_period_year => p_period /*5223170*/
188: ,pv_source => 'ALL');
189: EXCEPTION
190: WHEN OTHERS THEN
191: fnd_file.put_line(fnd_file.log,'Executing jg_zz_common_pkg.tax_registration failed with Error: '||SUBSTR(SQLERRM,1,200));
192: END;
193:
194:
195: IF p_debug_flag = 'Y' THEN

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

209: fnd_file.put_line(fnd_file.log,'Executing jg_zz_vat_rep_utility.get_report_status failed with Error: '||SUBSTR(SQLERRM,1,200));
210: END;
211:
212: IF p_debug_flag = 'Y' THEN
213: fnd_file.put_line(fnd_file.log,'Calling jg_zz_common_pkg.company_detail');
214: END IF;
215: BEGIN
216: jg_zz_common_pkg.company_detail(x_company_name => l_company_name
217: ,x_registration_number => l_registration_num

Line 216: jg_zz_common_pkg.company_detail(x_company_name => l_company_name

212: IF p_debug_flag = 'Y' THEN
213: fnd_file.put_line(fnd_file.log,'Calling jg_zz_common_pkg.company_detail');
214: END IF;
215: BEGIN
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
220: ,x_address2 => l_address_line_2

Line 235: fnd_file.put_line(fnd_file.log,'Executing jg_zz_common_pkg.company_detail failed with Error: '||SUBSTR(SQLERRM,1,200));

231: ,p_vat_reporting_entity_id => p_vat_rep_entity_id);
232:
233: EXCEPTION
234: WHEN OTHERS THEN
235: fnd_file.put_line(fnd_file.log,'Executing jg_zz_common_pkg.company_detail failed with Error: '||SUBSTR(SQLERRM,1,200));
236: END;
237: BEGIN
238: SELECT activity_code
239: INTO l_activity_code