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 171: fnd_file.put_line(fnd_file.log,'Calling jg_zz_common_pkg.funct_curr_legal');

167: BEGIN
168: -- Call to Common Package
169: IF p_debug_flag = 'Y' THEN
170: fnd_file.put_line(fnd_file.log,'Executing jg_zz_turnover_ar_pkg.before_report');
171: fnd_file.put_line(fnd_file.log,'Calling jg_zz_common_pkg.funct_curr_legal');
172: END IF;
173: BEGIN
174: jg_zz_common_pkg.funct_curr_legal(x_func_curr_code => l_func_curr
175: ,x_rep_entity_name => l_legal_entity_name

Line 174: jg_zz_common_pkg.funct_curr_legal(x_func_curr_code => l_func_curr

170: fnd_file.put_line(fnd_file.log,'Executing jg_zz_turnover_ar_pkg.before_report');
171: fnd_file.put_line(fnd_file.log,'Calling jg_zz_common_pkg.funct_curr_legal');
172: END IF;
173: BEGIN
174: jg_zz_common_pkg.funct_curr_legal(x_func_curr_code => l_func_curr
175: ,x_rep_entity_name => l_legal_entity_name
176: ,x_legal_entity_id => l_legal_entity_id
177: ,x_taxpayer_id => l_tax_payer_id
178: ,pn_vat_rep_entity_id => p_vat_rep_entity_id

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

178: ,pn_vat_rep_entity_id => p_vat_rep_entity_id
179: ,pn_period_year => p_period);
180: EXCEPTION
181: WHEN OTHERS THEN
182: fnd_file.put_line(fnd_file.log,'Executing jg_zz_common_pkg.funct_curr_legal failed with Error: '||SUBSTR(SQLERRM,1,200));
183: END;
184: IF p_debug_flag = 'Y' THEN
185: fnd_file.put_line(fnd_file.log,'Calling jg_zz_common_pkg.tax_registration');
186: END IF;

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

181: WHEN OTHERS THEN
182: fnd_file.put_line(fnd_file.log,'Executing jg_zz_common_pkg.funct_curr_legal failed with Error: '||SUBSTR(SQLERRM,1,200));
183: END;
184: IF p_debug_flag = 'Y' THEN
185: fnd_file.put_line(fnd_file.log,'Calling jg_zz_common_pkg.tax_registration');
186: END IF;
187: BEGIN
188: jg_zz_common_pkg.tax_registration(x_tax_registration => l_tax_registration_num
189: ,x_period_start_date => l_period_start_date

Line 188: jg_zz_common_pkg.tax_registration(x_tax_registration => l_tax_registration_num

184: IF p_debug_flag = 'Y' THEN
185: fnd_file.put_line(fnd_file.log,'Calling jg_zz_common_pkg.tax_registration');
186: END IF;
187: BEGIN
188: jg_zz_common_pkg.tax_registration(x_tax_registration => l_tax_registration_num
189: ,x_period_start_date => l_period_start_date
190: ,x_period_end_date => l_period_end_date
191: ,x_status => l_reporting_status
192: ,pn_vat_rep_entity_id => p_vat_rep_entity_id

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

194: ,pn_period_year => p_period /*5223170*/
195: ,pv_source => 'ALL');
196: EXCEPTION
197: WHEN OTHERS THEN
198: fnd_file.put_line(fnd_file.log,'Executing jg_zz_common_pkg.tax_registration failed with Error: '||SUBSTR(SQLERRM,1,200));
199: END;
200:
201:
202: IF p_debug_flag = 'Y' THEN

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

216: fnd_file.put_line(fnd_file.log,'Executing jg_zz_vat_rep_utility.get_report_status failed with Error: '||SUBSTR(SQLERRM,1,200));
217: END;
218:
219: IF p_debug_flag = 'Y' THEN
220: fnd_file.put_line(fnd_file.log,'Calling jg_zz_common_pkg.company_detail');
221: END IF;
222: BEGIN
223: jg_zz_common_pkg.company_detail(x_company_name => l_company_name
224: ,x_registration_number => l_registration_num

Line 223: jg_zz_common_pkg.company_detail(x_company_name => l_company_name

219: IF p_debug_flag = 'Y' THEN
220: fnd_file.put_line(fnd_file.log,'Calling jg_zz_common_pkg.company_detail');
221: END IF;
222: BEGIN
223: jg_zz_common_pkg.company_detail(x_company_name => l_company_name
224: ,x_registration_number => l_registration_num
225: ,x_country => l_country
226: ,x_address1 => l_address_line_1
227: ,x_address2 => l_address_line_2

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

238: ,p_vat_reporting_entity_id => p_vat_rep_entity_id);
239:
240: EXCEPTION
241: WHEN OTHERS THEN
242: fnd_file.put_line(fnd_file.log,'Executing jg_zz_common_pkg.company_detail failed with Error: '||SUBSTR(SQLERRM,1,200));
243: END;
244: BEGIN
245: SELECT activity_code
246: INTO l_activity_code