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

Line 762: fnd_file.put_line(fnd_file.log,' No record was returned for the GL_Balancing segment. Error : ' || SUBSTR(SQLERRM,1,200));

758: RETURN (bal_segment_value);
759:
760: EXCEPTION
761: WHEN NO_DATA_FOUND THEN
762: fnd_file.put_line(fnd_file.log,' No record was returned for the GL_Balancing segment. Error : ' || SUBSTR(SQLERRM,1,200));
763: RETURN NULL;
764:
765: END get_bsv;
766:

Line 1139: if gv_debug then FND_FILE.PUT_LINE(FND_FILE.LOG,'funct_curr_legal'); end if;

1135: v_enable_report_sequence_flag VARCHAR2(1) := 'N';
1136: l_precision NUMBER;
1137:
1138: BEGIN
1139: if gv_debug then FND_FILE.PUT_LINE(FND_FILE.LOG,'funct_curr_legal'); end if;
1140: jg_zz_common_pkg.funct_curr_legal( x_func_curr_code => l_func_curr_code
1141: , x_rep_entity_name => l_rep_legal_entity
1142: , x_legal_entity_id => l_rep_legal_entity_id
1143: , x_taxpayer_id => l_taxpayer_id

Line 1149: if gv_debug then FND_FILE.PUT_LINE(FND_FILE.LOG,'2'); end if;

1145: , pv_period_name => p_period
1146: , pn_period_year => l_period_year
1147: );
1148:
1149: if gv_debug then FND_FILE.PUT_LINE(FND_FILE.LOG,'2'); end if;
1150:
1151: jg_zz_common_pkg.tax_registration(x_tax_registration => l_trx_num
1152: , x_period_start_date => l_period_start_date
1153: , x_period_end_date => l_period_end_date

Line 1176: if gv_debug then FND_FILE.PUT_LINE(FND_FILE.LOG,'3'); end if;

1172: from fnd_lookups
1173: where lookup_type = 'JGZZ_REPORT_TYPE'
1174: and lookup_code = decode(l_reporting_mode, 'COPY', 'R','FINAL','F','P');
1175:
1176: if gv_debug then FND_FILE.PUT_LINE(FND_FILE.LOG,'3'); end if;
1177:
1178: /* jg_zz_common_pkg.company_detail(l_company_name
1179: ,l_registration_number
1180: ,l_country

Line 1226: FND_FILE.PUT_LINE(FND_FILE.LOG,'Functional Currency Code :'||l_func_curr_code);

1222:
1223: /* Get Currency Precision */
1224:
1225: BEGIN
1226: FND_FILE.PUT_LINE(FND_FILE.LOG,'Functional Currency Code :'||l_func_curr_code);
1227:
1228: SELECT precision
1229: INTO l_precision
1230: FROM fnd_currencies

Line 1233: FND_FILE.PUT_LINE(FND_FILE.LOG,'Functional Currency Precision :'||l_precision);

1229: INTO l_precision
1230: FROM fnd_currencies
1231: WHERE currency_code = l_func_curr_code;
1232:
1233: FND_FILE.PUT_LINE(FND_FILE.LOG,'Functional Currency Precision :'||l_precision);
1234:
1235: EXCEPTION
1236: WHEN OTHERS THEN
1237: FND_FILE.PUT_LINE(FND_FILE.LOG,'error in getting currency precision');

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

1233: FND_FILE.PUT_LINE(FND_FILE.LOG,'Functional Currency Precision :'||l_precision);
1234:
1235: EXCEPTION
1236: WHEN OTHERS THEN
1237: FND_FILE.PUT_LINE(FND_FILE.LOG,'error in getting currency precision');
1238: END;
1239:
1240:
1241:

Line 1242: if gv_debug then FND_FILE.PUT_LINE(FND_FILE.LOG,'INSERT INTO GLOBAL'); end if;

1238: END;
1239:
1240:
1241:
1242: if gv_debug then FND_FILE.PUT_LINE(FND_FILE.LOG,'INSERT INTO GLOBAL'); end if;
1243: InsertIntoGlobal(
1244: p_jg_info_v20 => l_entity_identifier -- entity_identifier
1245: ,p_jg_info_v21 => l_func_curr_code -- curr_code
1246: ,p_jg_info_v22 => l_company_name -- l_rep_legal_entity -- entity_name

Line 1273: if gv_debug then FND_FILE.PUT_LINE(FND_FILE.LOG,'5'); end if;

1269: );
1270:
1271:
1272:
1273: if gv_debug then FND_FILE.PUT_LINE(FND_FILE.LOG,'5'); end if;
1274:
1275: IF P_CALLINGREPORT = 'JEDEDVOR' THEN
1276:
1277: /* validating the parameters */

Line 1315: fnd_file.put_line(fnd_file.log,errbuf);

1311: END IF;
1312:
1313: EXCEPTION
1314: WHEN INVALID_LEDGER THEN
1315: fnd_file.put_line(fnd_file.log,errbuf);
1316: END;
1317:
1318: FOR r_ger_receipt IN lcu_ger_receipt ( p_vat_rep_entity_id,
1319: p_period,

Line 1331: if gv_debug then FND_FILE.PUT_LINE(FND_FILE.LOG,'6'); end if;

1327: p_gl_period_end_date
1328: )
1329: LOOP
1330:
1331: if gv_debug then FND_FILE.PUT_LINE(FND_FILE.LOG,'6'); end if;
1332:
1333: l_rd := rdformula(r_ger_receipt.rev_date,p_gl_period_start_date,p_gl_period_end_date);
1334:
1335: l_new_r_tax := new_r_taxformula(r_ger_receipt.r_date , r_ger_receipt.r_tax ,p_gl_period_start_date,p_gl_period_end_date);

Line 1349: FND_FILE.PUT_LINE(FND_FILE.LOG,'7. CrId:'||r_ger_receipt.cash_receipt_id);

1345: l_new_reversal := new_reversalformula(r_ger_receipt.rev_date,p_gl_period_start_date,p_gl_period_end_date);
1346:
1347: l_zero := zeroformula;
1348: if gv_debug then
1349: FND_FILE.PUT_LINE(FND_FILE.LOG,'7. CrId:'||r_ger_receipt.cash_receipt_id);
1350: end if;
1351:
1352: l_receipt_application := 0;
1353:

Line 1356: if gv_debug then FND_FILE.PUT_LINE(FND_FILE.LOG,'in 2nd loop'); end if;

1352: l_receipt_application := 0;
1353:
1354: FOR r_ger_appl IN lcu_ger_appl (r_ger_receipt.cash_receipt_id)
1355: LOOP
1356: if gv_debug then FND_FILE.PUT_LINE(FND_FILE.LOG,'in 2nd loop'); end if;
1357:
1358: l_new_au := new_auformula(r_ger_appl.a_date , r_ger_appl.applied , r_ger_appl.amount_applied,p_gl_period_start_date,p_gl_period_end_date );
1359:
1360: l_new_aa := new_aaformula(r_ger_appl.a_date , r_ger_appl.applied , r_ger_appl.amount_applied,p_gl_period_start_date,p_gl_period_end_date);

Line 1373: if gv_debug then FND_FILE.PUT_LINE(FND_FILE.LOG,'insert into global'); end if;

1369:
1370: l_new_unapp_vat := new_unapp_vatformula(r_ger_appl.a_date , l_unapp_vat,p_gl_period_start_date,p_gl_period_end_date );
1371:
1372: l_vat := vatformula(r_ger_appl.applied, l_app_vat, l_unapp_vat);
1373: if gv_debug then FND_FILE.PUT_LINE(FND_FILE.LOG,'insert into global'); end if;
1374: InsertIntoGlobal(
1375: p_jg_info_v1 => r_ger_receipt.receipt
1376: , p_jg_info_v2 => r_ger_receipt.status
1377: , p_jg_info_v3 => r_ger_receipt.tax_code

Line 1471: if gv_debug then FND_FILE.PUT_LINE(FND_FILE.LOG,'JGZZARVR - 1'); end if;

1467: ELSIF P_CALLINGREPORT = 'JGZZARVR' THEN
1468:
1469: BEGIN
1470:
1471: if gv_debug then FND_FILE.PUT_LINE(FND_FILE.LOG,'JGZZARVR - 1'); end if;
1472: FOR r_euar IN lcu_euar_vatreg (p_vat_rep_entity_id,p_period,p_vat_trx_type, p_ex_vat_trx_type)
1473: LOOP
1474:
1475: if gv_debug then FND_FILE.PUT_LINE(FND_FILE.LOG,'JGZZARVR - 2'); end if;

Line 1475: if gv_debug then FND_FILE.PUT_LINE(FND_FILE.LOG,'JGZZARVR - 2'); end if;

1471: if gv_debug then FND_FILE.PUT_LINE(FND_FILE.LOG,'JGZZARVR - 1'); end if;
1472: FOR r_euar IN lcu_euar_vatreg (p_vat_rep_entity_id,p_period,p_vat_trx_type, p_ex_vat_trx_type)
1473: LOOP
1474:
1475: if gv_debug then FND_FILE.PUT_LINE(FND_FILE.LOG,'JGZZARVR - 2'); end if;
1476:
1477: FND_FILE.PUT_LINE(FND_FILE.LOG,'v_count - '||v_count);
1478: FND_FILE.PUT_LINE(FND_FILE.LOG,'r_euar.vat_code - '||r_euar.vat_code);
1479: FND_FILE.PUT_LINE(FND_FILE.LOG,'v_prev_vat_code - '||v_prev_vat_code);

Line 1477: FND_FILE.PUT_LINE(FND_FILE.LOG,'v_count - '||v_count);

1473: LOOP
1474:
1475: if gv_debug then FND_FILE.PUT_LINE(FND_FILE.LOG,'JGZZARVR - 2'); end if;
1476:
1477: FND_FILE.PUT_LINE(FND_FILE.LOG,'v_count - '||v_count);
1478: FND_FILE.PUT_LINE(FND_FILE.LOG,'r_euar.vat_code - '||r_euar.vat_code);
1479: FND_FILE.PUT_LINE(FND_FILE.LOG,'v_prev_vat_code - '||v_prev_vat_code);
1480:
1481:

Line 1478: FND_FILE.PUT_LINE(FND_FILE.LOG,'r_euar.vat_code - '||r_euar.vat_code);

1474:
1475: if gv_debug then FND_FILE.PUT_LINE(FND_FILE.LOG,'JGZZARVR - 2'); end if;
1476:
1477: FND_FILE.PUT_LINE(FND_FILE.LOG,'v_count - '||v_count);
1478: FND_FILE.PUT_LINE(FND_FILE.LOG,'r_euar.vat_code - '||r_euar.vat_code);
1479: FND_FILE.PUT_LINE(FND_FILE.LOG,'v_prev_vat_code - '||v_prev_vat_code);
1480:
1481:
1482: InsertIntoGlobal(

Line 1479: FND_FILE.PUT_LINE(FND_FILE.LOG,'v_prev_vat_code - '||v_prev_vat_code);

1475: if gv_debug then FND_FILE.PUT_LINE(FND_FILE.LOG,'JGZZARVR - 2'); end if;
1476:
1477: FND_FILE.PUT_LINE(FND_FILE.LOG,'v_count - '||v_count);
1478: FND_FILE.PUT_LINE(FND_FILE.LOG,'r_euar.vat_code - '||r_euar.vat_code);
1479: FND_FILE.PUT_LINE(FND_FILE.LOG,'v_prev_vat_code - '||v_prev_vat_code);
1480:
1481:
1482: InsertIntoGlobal(
1483: p_jg_info_n1 => r_euar.seq_num

Line 1514: if gv_debug then FND_FILE.PUT_LINE(FND_FILE.LOG,'JGZZARVR - 3'); end if;

1510: );
1511: v_enable_report_sequence_flag := r_euar.enable_report_sequence_flag;
1512: END LOOP;
1513:
1514: if gv_debug then FND_FILE.PUT_LINE(FND_FILE.LOG,'JGZZARVR - 3'); end if;
1515: FOR r_euar_data_count IN lcu_euar_data_count ( p_ex_vat_trx_type)
1516: LOOP
1517: UPDATE jg_zz_vat_trx_gt
1518: SET jg_info_n20 = r_euar_data_count.c_no_data_count;

Line 1520: if gv_debug then FND_FILE.PUT_LINE(FND_FILE.LOG,'JGZZARVR - 4'); end if;

1516: LOOP
1517: UPDATE jg_zz_vat_trx_gt
1518: SET jg_info_n20 = r_euar_data_count.c_no_data_count;
1519: END LOOP;
1520: if gv_debug then FND_FILE.PUT_LINE(FND_FILE.LOG,'JGZZARVR - 4'); end if;
1521:
1522: -- Implement the report level seq number --
1523:
1524: IF v_enable_report_sequence_flag = 'Y' THEN

Line 1566: FND_FILE.PUT_LINE(FND_FILE.LOG,'Report name :'||'JEILARDR');

1562: || ELSIF added by Ramananda
1563: || Logic for this report is handled in the DataTemplate.
1564: */
1565: --IL VAT 2010 ER Start
1566: FND_FILE.PUT_LINE(FND_FILE.LOG,'Report name :'||'JEILARDR');
1567: BEGIN
1568: SELECT jivl.vat_aggregate_limit_amt
1569: INTO g_vat_agg_limit
1570: FROM je_il_vat_limits jivl,

Line 1580: fnd_file.put_line(fnd_file.log,'Please declare the VAT Aggregation Limit Amount for the tax period:'||p_period ||' for Calendar in the Israel VAT Limits Setup form.');

1576: AND rownum = 1;
1577:
1578: EXCEPTION
1579: WHEN NO_DATA_FOUND THEN
1580: fnd_file.put_line(fnd_file.log,'Please declare the VAT Aggregation Limit Amount for the tax period:'||p_period ||' for Calendar in the Israel VAT Limits Setup form.');
1581: raise_application_error(-20010,'Please declare the VAT Aggregation Limit Amount for the tax period:'||p_period ||' in the Israel VAT Limits Setup form.');
1582: RETURN (FALSE);
1583: END;
1584:

Line 1586: FND_FILE.PUT_LINE(FND_FILE.LOG,'VAT Aggregation Limit :'||g_vat_agg_limit);

1582: RETURN (FALSE);
1583: END;
1584:
1585: g_precision := l_precision;
1586: FND_FILE.PUT_LINE(FND_FILE.LOG,'VAT Aggregation Limit :'||g_vat_agg_limit);
1587: FND_FILE.PUT_LINE(FND_FILE.LOG,'G_PRECISION :'||g_precision);
1588: --IL VAT 2010 ER End
1589: ELSIF P_CALLINGREPORT = 'JEHRCITR' THEN
1590: /*

Line 1587: FND_FILE.PUT_LINE(FND_FILE.LOG,'G_PRECISION :'||g_precision);

1583: END;
1584:
1585: g_precision := l_precision;
1586: FND_FILE.PUT_LINE(FND_FILE.LOG,'VAT Aggregation Limit :'||g_vat_agg_limit);
1587: FND_FILE.PUT_LINE(FND_FILE.LOG,'G_PRECISION :'||g_precision);
1588: --IL VAT 2010 ER End
1589: ELSIF P_CALLINGREPORT = 'JEHRCITR' THEN
1590: /*
1591: || Customer Invoice Tax Report, Croatia

Line 1624: fnd_file.put_line(fnd_file.log,LOG_MESSAGE);

1620:
1621: RETURN (TRUE);
1622: EXCEPTION
1623: WHEN INVALID_ENTRY THEN
1624: fnd_file.put_line(fnd_file.log,LOG_MESSAGE);
1625: raise;
1626: RETURN (FALSE);
1627: WHEN OTHERS THEN
1628: FND_FILE.PUT_LINE(FND_FILE.LOG,'Unexpected error in JG_ZZ_SUMMARY_AR_PKG.beforeReport. Error-' ||SUBSTR(SQLERRM,1,200));

Line 1628: FND_FILE.PUT_LINE(FND_FILE.LOG,'Unexpected error in JG_ZZ_SUMMARY_AR_PKG.beforeReport. Error-' ||SUBSTR(SQLERRM,1,200));

1624: fnd_file.put_line(fnd_file.log,LOG_MESSAGE);
1625: raise;
1626: RETURN (FALSE);
1627: WHEN OTHERS THEN
1628: FND_FILE.PUT_LINE(FND_FILE.LOG,'Unexpected error in JG_ZZ_SUMMARY_AR_PKG.beforeReport. Error-' ||SUBSTR(SQLERRM,1,200));
1629: raise;
1630: RETURN (FALSE);
1631: END beforeReport;
1632: