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

Line 145: fnd_file.put_line(fnd_file.log,' An error occured while calculating the unpaid amount. Error : ' || SUBSTR(SQLERRM,1,200));

141:
142: EXCEPTION
143: WHEN OTHERS THEN
144: if g_debug = true then
145: fnd_file.put_line(fnd_file.log,' An error occured while calculating the unpaid amount. Error : ' || SUBSTR(SQLERRM,1,200));
146: end if;
147: RETURN NULL;
148: END unpaid_amt;
149:

Line 653: if g_debug = true then fnd_file.put_line(fnd_file.log,'Calling JG_ZZ_COMMON_PKG.funct_curr_legal'); end if;

649: BEGIN
650:
651: p_where_clause := ' AND 1 = 1 ';
652:
653: if g_debug = true then fnd_file.put_line(fnd_file.log,'Calling JG_ZZ_COMMON_PKG.funct_curr_legal'); end if;
654: JG_ZZ_COMMON_PKG.funct_curr_legal(l_curr_code
655: ,l_rep_entity_name
656: ,l_legal_entity_id
657: ,l_taxpayer_id

Line 661: if g_debug = true then fnd_file.put_line(fnd_file.log,'Calling JG_ZZ_COMMON_PKG.company_detail'); end if;

657: ,l_taxpayer_id
658: ,P_VAT_REPORTING_ENTITY_ID
659: , pv_period_name => p_tax_calendar_period /* UT TEST addition */
660: );
661: if g_debug = true then fnd_file.put_line(fnd_file.log,'Calling JG_ZZ_COMMON_PKG.company_detail'); end if;
662: JG_ZZ_COMMON_PKG.company_detail(x_company_name => l_company_name
663: ,x_registration_number =>l_registration_number
664: ,x_country => l_country
665: ,x_address1 => l_address1

Line 679: if g_debug = true then fnd_file.put_line(fnd_file.log,'Calling jg_zz_common_pkg.tax_registration'); end if;

675: ,x_vat_reg_num => l_vat_reg_num
676: ,pn_legal_entity_id => l_legal_entity_id
677: ,p_vat_reporting_entity_id => P_VAT_REPORTING_ENTITY_ID);
678:
679: if g_debug = true then fnd_file.put_line(fnd_file.log,'Calling jg_zz_common_pkg.tax_registration'); end if;
680: jg_zz_common_pkg.tax_registration(x_tax_registration => l_tax_registration_num
681: ,x_period_start_date => l_period_start_date
682: ,x_period_end_date => l_period_end_date
683: ,x_status => l_reporting_status

Line 762: if g_debug = true then fnd_file.put_line(fnd_file.log,'Inserted Company Details in JG_ZZ_VAT_TRX_GT table'); end if;

758: ,l_tax_registration_num
759: ,l_period_start_date
760: ,l_period_end_date
761: ,l_reporting_status);
762: if g_debug = true then fnd_file.put_line(fnd_file.log,'Inserted Company Details in JG_ZZ_VAT_TRX_GT table'); end if;
763:
764: IF P_CALLING_REPORT IS NOT NULL THEN --A1
765:
766: /* commented during UT TEST

Line 777: if g_debug = true then fnd_file.put_line(fnd_file.log, 'l_country_code:'||l_country_code); end if;

773: if l_country_code is null then
774: l_country_code := jg_zz_shared_pkg.GET_COUNTRY(mo_global.get_current_org_id);
775: end if;
776:
777: if g_debug = true then fnd_file.put_line(fnd_file.log, 'l_country_code:'||l_country_code); end if;
778:
779: IF P_VAT_TRX_TYPE IS NOT NULL THEN
780: BEGIN
781: FOR c_lookup_type IN c_get_lookup_values(P_VAT_TRX_TYPE)

Line 788: if g_debug = true then fnd_file.put_line(fnd_file.log,' Failed while extracting the transaction type meaning. Error : ' || SUBSTR(SQLERRM,1,200)); end if;

784: G_VAT_TRX_TYPE_DESC := c_lookup_type.description;
785: END LOOP;
786: EXCEPTION
787: WHEN OTHERS THEN
788: if g_debug = true then fnd_file.put_line(fnd_file.log,' Failed while extracting the transaction type meaning. Error : ' || SUBSTR(SQLERRM,1,200)); end if;
789: END;
790: END IF;
791:
792: IF P_EX_VAT_TRX_TYPE IS NOT NULL THEN

Line 801: if g_debug = true then fnd_file.put_line(fnd_file.log,' Failed while extracting the exclude transaction type meaning. Error : ' || SUBSTR(SQLERRM,1,200)); end if;

797: G_EX_VAT_TRX_TYPE_DESC := c_lookup_type_ex.description;
798: END LOOP;
799: EXCEPTION
800: WHEN OTHERS THEN
801: if g_debug = true then fnd_file.put_line(fnd_file.log,' Failed while extracting the exclude transaction type meaning. Error : ' || SUBSTR(SQLERRM,1,200)); end if;
802: END;
803:
804: END IF;
805:

Line 816: if g_debug = true then fnd_file.put_line(fnd_file.log,' Failed while extracting the company name and the functional currency code. Error : ' || SUBSTR(SQLERRM,1,200)); end if;

812: END LOOP;
813:
814: EXCEPTION
815: WHEN OTHERS THEN
816: if g_debug = true then fnd_file.put_line(fnd_file.log,' Failed while extracting the company name and the functional currency code. Error : ' || SUBSTR(SQLERRM,1,200)); end if;
817: END;
818:
819: /* Get Currency Precision */
820:

Line 822: FND_FILE.PUT_LINE(FND_FILE.LOG,'Functional Currency Code :'||G_FUNCTIONAL_CURRENCY);

818:
819: /* Get Currency Precision */
820:
821: BEGIN
822: FND_FILE.PUT_LINE(FND_FILE.LOG,'Functional Currency Code :'||G_FUNCTIONAL_CURRENCY);
823:
824: SELECT precision
825: INTO G_PRECISION
826: FROM fnd_currencies

Line 829: FND_FILE.PUT_LINE(FND_FILE.LOG,'Functional Currency Precision :'||G_PRECISION);

825: INTO G_PRECISION
826: FROM fnd_currencies
827: WHERE currency_code = G_FUNCTIONAL_CURRENCY;
828:
829: FND_FILE.PUT_LINE(FND_FILE.LOG,'Functional Currency Precision :'||G_PRECISION);
830:
831: EXCEPTION
832: WHEN OTHERS THEN
833: FND_FILE.PUT_LINE(FND_FILE.LOG,'error in getting currency precision');

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

829: FND_FILE.PUT_LINE(FND_FILE.LOG,'Functional Currency Precision :'||G_PRECISION);
830:
831: EXCEPTION
832: WHEN OTHERS THEN
833: FND_FILE.PUT_LINE(FND_FILE.LOG,'error in getting currency precision');
834: END;
835:
836: -- Begin of code for Israeli reports
837:

Line 840: if g_debug = true then fnd_file.put_line(fnd_file.log,'Israeli VAT AP Detail Register Report concurrent is submitted'); end if;

836: -- Begin of code for Israeli reports
837:
838: --Populated the data for VAT AP Detail Report and VAT-File Not Related 835 -Israel
839: IF ( P_CALLING_REPORT = 'JEILAPVR' OR P_CALLING_REPORT = 'JEILN835' ) THEN
840: if g_debug = true then fnd_file.put_line(fnd_file.log,'Israeli VAT AP Detail Register Report concurrent is submitted'); end if;
841:
842: BEGIN
843: --Populated the data for VAT AP Detail Report and VAT-File Not Related 835 -Israel
844: FOR israel_inv_lines IN israel_details

Line 894: if g_debug = true then fnd_file.put_line(fnd_file.log,' Failed while Inserting the ISRAEL data into GTT. Error : ' || SUBSTR(SQLERRM,1,200)); end if;

890: ,israel_inv_lines.class);
891: END LOOP;
892: EXCEPTION
893: WHEN OTHERS THEN
894: if g_debug = true then fnd_file.put_line(fnd_file.log,' Failed while Inserting the ISRAEL data into GTT. Error : ' || SUBSTR(SQLERRM,1,200)); end if;
895: END;
896: -- End of code for Israeli reports
897:
898: -- Begin of code for ECE and Crotia reports.

Line 993: if g_debug = true then fnd_file.put_line(fnd_file.log,' Failed while populating the data into the global tmp table for c_new. Error : ' || SUBSTR(SQLERRM,1,200)); end if;

989:
990: END LOOP;
991: EXCEPTION
992: WHEN OTHERS THEN
993: if g_debug = true then fnd_file.put_line(fnd_file.log,' Failed while populating the data into the global tmp table for c_new. Error : ' || SUBSTR(SQLERRM,1,200)); end if;
994: END;
995:
996: -- Populate data for the Summary by GL period
997: BEGIN

Line 1082: if g_debug = true then fnd_file.put_line(fnd_file.log,' Failed while populating the data into the global tmp table for c_data. Error : ' || SUBSTR(SQLERRM,1,200)); end if;

1078:
1079: END LOOP;
1080: EXCEPTION
1081: WHEN OTHERS THEN
1082: if g_debug = true then fnd_file.put_line(fnd_file.log,' Failed while populating the data into the global tmp table for c_data. Error : ' || SUBSTR(SQLERRM,1,200)); end if;
1083: END;
1084:
1085: BEGIN
1086: FOR c_end_date IN c_period_end_date

Line 1093: if g_debug = true then fnd_file.put_line(fnd_file.log,' Failed while selecting the period end date. Error : ' || SUBSTR(SQLERRM,1,200)); end if;

1089: END LOOP;
1090:
1091: EXCEPTION
1092: WHEN OTHERS THEN
1093: if g_debug = true then fnd_file.put_line(fnd_file.log,' Failed while selecting the period end date. Error : ' || SUBSTR(SQLERRM,1,200)); end if;
1094: END;
1095:
1096: -- Implementing seq num ---------
1097: BEGIN

Line 1135: fnd_file.put_line(fnd_file.log,' Failed while Implementing seq num : ' || SUBSTR(SQLERRM,1,200));

1131: END LOOP;
1132: END IF;
1133: EXCEPTION
1134: WHEN OTHERS THEN
1135: fnd_file.put_line(fnd_file.log,' Failed while Implementing seq num : ' || SUBSTR(SQLERRM,1,200));
1136: END;
1137: -- End of Implementing seq num ---------
1138:
1139: P_WHERE_CLAUSE := ' AND ';

Line 1194: if g_debug = true then fnd_file.put_line(fnd_file.log,'Croatian Supplier Invoice Tax Report concurrent is submitted' ); end if;

1190: || ELSIF added by Ramananda.
1191: || Requirements of this report are satisfied with the ECE Payables Tax Report
1192: || No Filtering conditions are required for Croatia
1193: */
1194: if g_debug = true then fnd_file.put_line(fnd_file.log,'Croatian Supplier Invoice Tax Report concurrent is submitted' ); end if;
1195: NULL ;
1196: END IF;
1197:
1198: ELSE

Line 1219: if g_debug = true then fnd_file.put_line(fnd_file.log,'Croatian Supplier Invoice Tax Report concurrent is submitted' ); end if;

1215: || ' AND trunc(checks.cleared_date) <= ''' ||l_end_date
1216: || ''' AND jg_info_v19 = ''Y'') AND (jg_info_n12 = 1 )) OR (jg_info_n12 = 0 ))';
1217:
1218: ELSIF (l_country_code = 'HR') THEN
1219: if g_debug = true then fnd_file.put_line(fnd_file.log,'Croatian Supplier Invoice Tax Report concurrent is submitted' ); end if;
1220: NULL ;
1221: END IF;
1222:
1223: END IF ;

Line 1308: if g_debug = true then fnd_file.put_line(fnd_file.log,' Failed while populating data in the global tmp table for the generic cursor. Error : ' || SUBSTR(SQLERRM,1,200)); end if;

1304: END LOOP;
1305:
1306: EXCEPTION
1307: WHEN OTHERS THEN
1308: if g_debug = true then fnd_file.put_line(fnd_file.log,' Failed while populating data in the global tmp table for the generic cursor. Error : ' || SUBSTR(SQLERRM,1,200)); end if;
1309: END;
1310:
1311: END IF;
1312:

Line 1316: if g_debug = true then fnd_file.put_line(fnd_file.log,' An error occured in the before report trigger. Error : ' || SUBSTR(SQLERRM,1,200)); end if;

1312:
1313:
1314: EXCEPTION
1315: WHEN OTHERS THEN
1316: if g_debug = true then fnd_file.put_line(fnd_file.log,' An error occured in the before report trigger. Error : ' || SUBSTR(SQLERRM,1,200)); end if;
1317: RETURN(FALSE);
1318: END;
1319:
1320: if g_debug = true then

Line 1321: fnd_file.put_line(fnd_file.log,'P_WHERE_CLAUSE: ' ||P_WHERE_CLAUSE);

1317: RETURN(FALSE);
1318: END;
1319:
1320: if g_debug = true then
1321: fnd_file.put_line(fnd_file.log,'P_WHERE_CLAUSE: ' ||P_WHERE_CLAUSE);
1322: end if;
1323:
1324: RETURN(TRUE);
1325:

Line 1414: if g_debug = true then fnd_file.put_line(fnd_file.log,' Failed while extracting the prepayments meaning. Error : ' || SUBSTR(SQLERRM,1,200)); end if;

1410: RETURN G_INC_PREPAYMENTS;
1411:
1412: EXCEPTION
1413: WHEN OTHERS THEN
1414: if g_debug = true then fnd_file.put_line(fnd_file.log,' Failed while extracting the prepayments meaning. Error : ' || SUBSTR(SQLERRM,1,200)); end if;
1415: RETURN NULL;
1416: END get_prepayments_meaning;
1417:
1418: /*

Line 1483: fnd_file.put_line(fnd_file.log,' Failed while extracting the Tax Reginstration Number. Error : ' || SUBSTR(SQLERRM,1,200));

1479: RETURN l_trn;
1480: EXCEPTION
1481: WHEN OTHERS THEN
1482: if g_debug = true then
1483: fnd_file.put_line(fnd_file.log,' Failed while extracting the Tax Reginstration Number. Error : ' || SUBSTR(SQLERRM,1,200));
1484: end if;
1485: Return NULL;
1486: END get_trn;
1487: