DBA Data[Home] [Help]

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 1057: if g_debug = true then fnd_file.put_line(fnd_file.log,'Calling JG_ZZ_COMMON_PKG.funct_curr_legal'); end if;

1053: BEGIN
1054:
1055: p_where_clause := ' AND 1 = 1 ';
1056:
1057: if g_debug = true then fnd_file.put_line(fnd_file.log,'Calling JG_ZZ_COMMON_PKG.funct_curr_legal'); end if;
1058: JG_ZZ_COMMON_PKG.funct_curr_legal(l_curr_code
1059: ,l_rep_entity_name
1060: ,l_legal_entity_id
1061: ,l_taxpayer_id

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

1061: ,l_taxpayer_id
1062: ,P_VAT_REPORTING_ENTITY_ID
1063: , pv_period_name => p_tax_calendar_period /* UT TEST addition */
1064: );
1065: if g_debug = true then fnd_file.put_line(fnd_file.log,'Calling JG_ZZ_COMMON_PKG.company_detail'); end if;
1066: JG_ZZ_COMMON_PKG.company_detail(x_company_name => l_company_name
1067: ,x_registration_number =>l_registration_number
1068: ,x_country => l_country
1069: ,x_address1 => l_address1

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

1079: ,x_vat_reg_num => l_vat_reg_num
1080: ,pn_legal_entity_id => l_legal_entity_id
1081: ,p_vat_reporting_entity_id => P_VAT_REPORTING_ENTITY_ID);
1082:
1083: if g_debug = true then fnd_file.put_line(fnd_file.log,'Calling jg_zz_common_pkg.tax_registration'); end if;
1084: jg_zz_common_pkg.tax_registration(x_tax_registration => l_tax_registration_num
1085: ,x_period_start_date => l_period_start_date
1086: ,x_period_end_date => l_period_end_date
1087: ,x_status => l_reporting_status

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

1171: ,l_period_start_date
1172: ,l_period_end_date
1173: --,l_reporting_status); Bug 12773668
1174: ,l_reporting_status_1); --Bug 12773668
1175: if g_debug = true then fnd_file.put_line(fnd_file.log,'Inserted Company Details in JG_ZZ_VAT_TRX_GT table'); end if;
1176:
1177: IF P_CALLING_REPORT IS NOT NULL THEN --A1
1178:
1179: /* commented during UT TEST

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

1186: if l_country_code is null then
1187: l_country_code := jg_zz_shared_pkg.GET_COUNTRY(mo_global.get_current_org_id);
1188: end if;
1189:
1190: if g_debug = true then fnd_file.put_line(fnd_file.log, 'l_country_code:'||l_country_code); end if;
1191:
1192: IF P_VAT_TRX_TYPE IS NOT NULL THEN
1193: BEGIN
1194: FOR c_lookup_type IN c_get_lookup_values(P_VAT_TRX_TYPE)

Line 1201: 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;

1197: G_VAT_TRX_TYPE_DESC := c_lookup_type.description;
1198: END LOOP;
1199: EXCEPTION
1200: WHEN OTHERS THEN
1201: 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;
1202: END;
1203: END IF;
1204:
1205: IF P_EX_VAT_TRX_TYPE IS NOT NULL THEN

Line 1214: 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;

1210: G_EX_VAT_TRX_TYPE_DESC := c_lookup_type_ex.description;
1211: END LOOP;
1212: EXCEPTION
1213: WHEN OTHERS THEN
1214: 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;
1215: END;
1216:
1217: END IF;
1218:

Line 1229: 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;

1225: END LOOP;
1226:
1227: EXCEPTION
1228: WHEN OTHERS THEN
1229: 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;
1230: END;
1231:
1232: /* Get Currency Precision */
1233:

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

1231:
1232: /* Get Currency Precision */
1233:
1234: BEGIN
1235: FND_FILE.PUT_LINE(FND_FILE.LOG,'Functional Currency Code :'||G_FUNCTIONAL_CURRENCY);
1236:
1237: SELECT precision
1238: INTO G_PRECISION
1239: FROM fnd_currencies

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

1238: INTO G_PRECISION
1239: FROM fnd_currencies
1240: WHERE currency_code = G_FUNCTIONAL_CURRENCY;
1241:
1242: FND_FILE.PUT_LINE(FND_FILE.LOG,'Functional Currency Precision :'||G_PRECISION);
1243:
1244: EXCEPTION
1245: WHEN OTHERS THEN
1246: FND_FILE.PUT_LINE(FND_FILE.LOG,'error in getting currency precision');

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

1242: FND_FILE.PUT_LINE(FND_FILE.LOG,'Functional Currency Precision :'||G_PRECISION);
1243:
1244: EXCEPTION
1245: WHEN OTHERS THEN
1246: FND_FILE.PUT_LINE(FND_FILE.LOG,'error in getting currency precision');
1247: END;
1248:
1249: -- Begin of code for Israeli reports
1250:

Line 1254: fnd_file.put_line(fnd_file.log,'Israeli VAT AP Detail Register Report concurrent is submitted');

1250:
1251: --Populated the data for VAT AP Detail Report
1252: IF ( P_CALLING_REPORT = 'JEILAPVR') THEN
1253: if g_debug = true then
1254: fnd_file.put_line(fnd_file.log,'Israeli VAT AP Detail Register Report concurrent is submitted');
1255: end if;
1256:
1257: -- IL VAT Reporting 2010 ER - Logic Changes
1258:

Line 1269: fnd_file.put_line(fnd_file.log,'Please declare the VAT limits for the tax period '||p_tax_calendar_period||' for calendar in the Israel VAT Limits Setup form.');

1265: l_calendar_name := cur_get_limits.period_set_name;
1266: END LOOP;
1267:
1268: IF l_calendar_name IS NULL THEN
1269: fnd_file.put_line(fnd_file.log,'Please declare the VAT limits for the tax period '||p_tax_calendar_period||' for calendar in the Israel VAT Limits Setup form.');
1270: raise_application_error(-20010,'Please declare the VAT limits for the tax period '||p_tax_calendar_period||' for calendar in the Israel VAT Limits Setup form.');
1271: END IF;
1272: if g_debug = true then
1273: fnd_file.put_line(fnd_file.log,'Percentage =' || TO_CHAR(l_percentage));

Line 1273: fnd_file.put_line(fnd_file.log,'Percentage =' || TO_CHAR(l_percentage));

1269: fnd_file.put_line(fnd_file.log,'Please declare the VAT limits for the tax period '||p_tax_calendar_period||' for calendar in the Israel VAT Limits Setup form.');
1270: raise_application_error(-20010,'Please declare the VAT limits for the tax period '||p_tax_calendar_period||' for calendar in the Israel VAT Limits Setup form.');
1271: END IF;
1272: if g_debug = true then
1273: fnd_file.put_line(fnd_file.log,'Percentage =' || TO_CHAR(l_percentage));
1274: fnd_file.put_line(fnd_file.log,'Max. Rec. Amount =' || TO_CHAR(l_max_rec_amt));
1275: fnd_file.put_line(fnd_file.log,'Min. Rec. Amount =' || TO_CHAR(l_min_rec_amt));
1276: fnd_file.put_line(fnd_file.log,'Tax Calendar Name =' || l_calendar_name);
1277: end if;

Line 1274: fnd_file.put_line(fnd_file.log,'Max. Rec. Amount =' || TO_CHAR(l_max_rec_amt));

1270: raise_application_error(-20010,'Please declare the VAT limits for the tax period '||p_tax_calendar_period||' for calendar in the Israel VAT Limits Setup form.');
1271: END IF;
1272: if g_debug = true then
1273: fnd_file.put_line(fnd_file.log,'Percentage =' || TO_CHAR(l_percentage));
1274: fnd_file.put_line(fnd_file.log,'Max. Rec. Amount =' || TO_CHAR(l_max_rec_amt));
1275: fnd_file.put_line(fnd_file.log,'Min. Rec. Amount =' || TO_CHAR(l_min_rec_amt));
1276: fnd_file.put_line(fnd_file.log,'Tax Calendar Name =' || l_calendar_name);
1277: end if;
1278:

Line 1275: fnd_file.put_line(fnd_file.log,'Min. Rec. Amount =' || TO_CHAR(l_min_rec_amt));

1271: END IF;
1272: if g_debug = true then
1273: fnd_file.put_line(fnd_file.log,'Percentage =' || TO_CHAR(l_percentage));
1274: fnd_file.put_line(fnd_file.log,'Max. Rec. Amount =' || TO_CHAR(l_max_rec_amt));
1275: fnd_file.put_line(fnd_file.log,'Min. Rec. Amount =' || TO_CHAR(l_min_rec_amt));
1276: fnd_file.put_line(fnd_file.log,'Tax Calendar Name =' || l_calendar_name);
1277: end if;
1278:
1279: -- Get the reporting status id

Line 1276: fnd_file.put_line(fnd_file.log,'Tax Calendar Name =' || l_calendar_name);

1272: if g_debug = true then
1273: fnd_file.put_line(fnd_file.log,'Percentage =' || TO_CHAR(l_percentage));
1274: fnd_file.put_line(fnd_file.log,'Max. Rec. Amount =' || TO_CHAR(l_max_rec_amt));
1275: fnd_file.put_line(fnd_file.log,'Min. Rec. Amount =' || TO_CHAR(l_min_rec_amt));
1276: fnd_file.put_line(fnd_file.log,'Tax Calendar Name =' || l_calendar_name);
1277: end if;
1278:
1279: -- Get the reporting status id
1280: FOR cur_get_rep_status_id IN il_get_rep_status_id

Line 1287: fnd_file.put_line(fnd_file.log,'Current Reporting Status ID = ' || TO_CHAR(l_rep_status_id));

1283: l_cur_period_end_date := cur_get_rep_status_id.period_end_date;
1284: END LOOP;
1285:
1286: if g_debug = true then
1287: fnd_file.put_line(fnd_file.log,'Current Reporting Status ID = ' || TO_CHAR(l_rep_status_id));
1288: end if;
1289:
1290: IF l_rep_status_id IS NULL THEN
1291: RETURN (FALSE);

Line 1303: fnd_file.put_line(fnd_file.log,'Total VAT Amount = ' || TO_CHAR(l_total_vat_amt));

1299: LOOP
1300: l_total_vat_amt := cur_get_total_vat_amt.TOTAL_VAT_AMT;
1301: END LOOP;
1302: if g_debug = true then
1303: fnd_file.put_line(fnd_file.log,'Total VAT Amount = ' || TO_CHAR(l_total_vat_amt));
1304: end if;
1305: -- Find the Maximum Recoverable Amount from Percentage.
1306: l_max_rec_amt := NVL(l_total_vat_amt,0) * l_percentage / 100;
1307: if g_debug = true then

Line 1308: fnd_file.put_line(fnd_file.log,'Max Recoverable Amount:'||to_char(l_max_rec_amt));

1304: end if;
1305: -- Find the Maximum Recoverable Amount from Percentage.
1306: l_max_rec_amt := NVL(l_total_vat_amt,0) * l_percentage / 100;
1307: if g_debug = true then
1308: fnd_file.put_line(fnd_file.log,'Max Recoverable Amount:'||to_char(l_max_rec_amt));
1309: end if;
1310: END IF;
1311:
1312: IF l_max_rec_amt IS NULL OR l_min_rec_amt IS NULL THEN

Line 1313: fnd_file.put_line(fnd_file.log,'Please declare the Minimum and/or Maximum Recoverable Amount limits for the tax period in the Israel VAT Limits Setup form.');

1309: end if;
1310: END IF;
1311:
1312: IF l_max_rec_amt IS NULL OR l_min_rec_amt IS NULL THEN
1313: fnd_file.put_line(fnd_file.log,'Please declare the Minimum and/or Maximum Recoverable Amount limits for the tax period in the Israel VAT Limits Setup form.');
1314: raise_application_error(-20010,'Please declare the Minimum and/or Maximum Recoverable Amount limits for the tax period in the Israel VAT Limits Setup form.');
1315: RETURN (FALSE);
1316: END IF;
1317:

Line 1324: fnd_file.put_line(fnd_file.log,'Total PETTY CASH Amount = ' || TO_CHAR(l_petty_cash_vat_amt));

1320: LOOP
1321: l_petty_cash_vat_amt := cur_get_petty_cash_vat_amt.TOTAL_PETTY_CASH_VAT_AMT;
1322: END LOOP;
1323: if g_debug = true then
1324: fnd_file.put_line(fnd_file.log,'Total PETTY CASH Amount = ' || TO_CHAR(l_petty_cash_vat_amt));
1325: end if;
1326:
1327: -- Find the Final VAT Amount
1328: IF l_max_rec_amt > l_min_rec_amt THEN

Line 1343: fnd_file.put_line(fnd_file.log,'Declared Amount = ' || TO_CHAR(l_declared_amount));

1339: END IF;
1340: END IF;
1341:
1342: if g_debug = true then
1343: fnd_file.put_line(fnd_file.log,'Declared Amount = ' || TO_CHAR(l_declared_amount));
1344: end if;
1345:
1346: -- Compare the petty cash trxs vat amt with limits.
1347: FOR cur_get_petty_cash_trxs IN il_get_petty_cash_trxs

Line 1378: fnd_file.put_line(fnd_file.log,' Failed while Updating IL_VAT_REP_STATUS_ID column in JG_ZZ_VAT_TRX_DETAILS table. Error : ' || SUBSTR(SQLERRM,1,200));

1374: AND TRX_DATE = trx_date_rec_tab(i_index);
1375: EXCEPTION
1376: WHEN OTHERS THEN
1377: if g_debug = true then
1378: fnd_file.put_line(fnd_file.log,' Failed while Updating IL_VAT_REP_STATUS_ID column in JG_ZZ_VAT_TRX_DETAILS table. Error : ' || SUBSTR(SQLERRM,1,200));
1379: end if;
1380: RETURN (FALSE);
1381: END;
1382: if g_debug = true then

Line 1383: fnd_file.put_line(fnd_file.log,'Stamped IL_VAT_REP_STATUS_ID column for petty cash trxs');

1379: end if;
1380: RETURN (FALSE);
1381: END;
1382: if g_debug = true then
1383: fnd_file.put_line(fnd_file.log,'Stamped IL_VAT_REP_STATUS_ID column for petty cash trxs');
1384: end if;
1385: END IF;
1386:
1387: -- IL VAT Reporting 2010 ER - Logic Changes

Line 1429: 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;

1425: ,cur_israel_new_details.mark_trx_flag);
1426: END LOOP;
1427: EXCEPTION
1428: WHEN OTHERS THEN
1429: 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;
1430: RETURN (FALSE);
1431: END;
1432:
1433: -- Code for Israel VAT Non-related to 835 report

Line 1438: fnd_file.put_line(fnd_file.log,'Israeli VAT-File Not Related 835 Report concurrent is submitted');

1434:
1435: ELSIF P_CALLING_REPORT = 'JEILN835' THEN
1436:
1437: if g_debug = true then
1438: fnd_file.put_line(fnd_file.log,'Israeli VAT-File Not Related 835 Report concurrent is submitted');
1439: end if;
1440:
1441: BEGIN
1442: --Populated the data for VAT-File Not Related 835 -Israel

Line 1493: 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;

1489: ,israel_inv_lines.class);
1490: END LOOP;
1491: EXCEPTION
1492: WHEN OTHERS THEN
1493: 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;
1494: END;
1495: -- End of code for Israeli reports
1496:
1497: -- Begin of code for ECE and Crotia reports.

Line 1592: 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;

1588:
1589: END LOOP;
1590: EXCEPTION
1591: WHEN OTHERS THEN
1592: 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;
1593: END;
1594:
1595: -- Populate data for the Summary by GL period
1596: BEGIN

Line 1681: 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;

1677:
1678: END LOOP;
1679: EXCEPTION
1680: WHEN OTHERS THEN
1681: 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;
1682: END;
1683:
1684: BEGIN
1685: FOR c_end_date IN c_period_end_date

Line 1692: 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;

1688: END LOOP;
1689:
1690: EXCEPTION
1691: WHEN OTHERS THEN
1692: 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;
1693: END;
1694:
1695: -- Implementing seq num ---------
1696: BEGIN

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

1730: END LOOP;
1731: END IF;
1732: EXCEPTION
1733: WHEN OTHERS THEN
1734: fnd_file.put_line(fnd_file.log,' Failed while Implementing seq num : ' || SUBSTR(SQLERRM,1,200));
1735: END;
1736: -- End of Implementing seq num ---------
1737:
1738: P_WHERE_CLAUSE := ' AND ';

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

1789: || ELSIF added by Ramananda.
1790: || Requirements of this report are satisfied with the ECE Payables Tax Report
1791: || No Filtering conditions are required for Croatia
1792: */
1793: if g_debug = true then fnd_file.put_line(fnd_file.log,'Croatian Supplier Invoice Tax Report concurrent is submitted' ); end if;
1794: NULL ;
1795: END IF;
1796:
1797: ELSE

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

1814: || ' AND trunc(checks.cleared_date) <= ''' ||l_end_date
1815: || ''' AND jg_info_v19 = ''Y'') AND (jg_info_n12 = 1 )) OR (jg_info_n12 = 0 ))';
1816:
1817: ELSIF (l_country_code = 'HR') THEN
1818: if g_debug = true then fnd_file.put_line(fnd_file.log,'Croatian Supplier Invoice Tax Report concurrent is submitted' ); end if;
1819: NULL ;
1820: END IF;
1821:
1822: END IF ;

Line 1907: 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;

1903: END LOOP;
1904:
1905: EXCEPTION
1906: WHEN OTHERS THEN
1907: 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;
1908: END;
1909:
1910: END IF;
1911:

Line 1915: 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;

1911:
1912:
1913: EXCEPTION
1914: WHEN OTHERS THEN
1915: 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;
1916: RETURN(FALSE);
1917: END;
1918:
1919: if g_debug = true then

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

1916: RETURN(FALSE);
1917: END;
1918:
1919: if g_debug = true then
1920: fnd_file.put_line(fnd_file.log,'P_WHERE_CLAUSE: ' ||P_WHERE_CLAUSE);
1921: end if;
1922:
1923: RETURN(TRUE);
1924:

Line 2013: 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;

2009: RETURN G_INC_PREPAYMENTS;
2010:
2011: EXCEPTION
2012: WHEN OTHERS THEN
2013: 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;
2014: RETURN NULL;
2015: END get_prepayments_meaning;
2016:
2017: /*

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

2078: RETURN l_trn;
2079: EXCEPTION
2080: WHEN OTHERS THEN
2081: if g_debug = true then
2082: fnd_file.put_line(fnd_file.log,' Failed while extracting the Tax Reginstration Number. Error : ' || SUBSTR(SQLERRM,1,200));
2083: end if;
2084: Return NULL;
2085: END get_trn;
2086: