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 1108: if gv_debug then FND_FILE.PUT_LINE(FND_FILE.LOG,'funct_curr_legal'); end if;

1104: v_prev_vat_code VARCHAR2(240) :='';
1105: v_is_seq_updated VARCHAR2(1) := 'N';
1106: v_enable_report_sequence_flag VARCHAR2(1) := 'N';
1107: BEGIN
1108: if gv_debug then FND_FILE.PUT_LINE(FND_FILE.LOG,'funct_curr_legal'); end if;
1109: jg_zz_common_pkg.funct_curr_legal( x_func_curr_code => l_func_curr_code
1110: , x_rep_entity_name => l_rep_legal_entity
1111: , x_legal_entity_id => l_rep_legal_entity_id
1112: , x_taxpayer_id => l_taxpayer_id

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

1114: , pv_period_name => p_period
1115: , pn_period_year => l_period_year
1116: );
1117:
1118: if gv_debug then FND_FILE.PUT_LINE(FND_FILE.LOG,'2'); end if;
1119:
1120: jg_zz_common_pkg.tax_registration(x_tax_registration => l_trx_num
1121: , x_period_start_date => l_period_start_date
1122: , x_period_end_date => l_period_end_date

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

1133: pv_source => NULL,
1134: pv_report_name => P_CALLINGREPORT
1135: );
1136:
1137: if gv_debug then FND_FILE.PUT_LINE(FND_FILE.LOG,'3'); end if;
1138:
1139: /* jg_zz_common_pkg.company_detail(l_company_name
1140: ,l_registration_number
1141: ,l_country

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

1182: CLOSE get_tax_rate_code;
1183:
1184:
1185:
1186: if gv_debug then FND_FILE.PUT_LINE(FND_FILE.LOG,'INSERT INTO GLOBAL'); end if;
1187: InsertIntoGlobal(
1188: p_jg_info_v20 => l_entity_identifier -- entity_identifier
1189: ,p_jg_info_v21 => l_func_curr_code -- curr_code
1190: ,p_jg_info_v22 => l_company_name -- l_rep_legal_entity -- entity_name

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

1212: );
1213:
1214:
1215:
1216: if gv_debug then FND_FILE.PUT_LINE(FND_FILE.LOG,'5'); end if;
1217:
1218: IF P_CALLINGREPORT = 'JEDEDVOR' THEN
1219:
1220: /* validating the parameters */

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

1254: END IF;
1255:
1256: EXCEPTION
1257: WHEN INVALID_LEDGER THEN
1258: fnd_file.put_line(fnd_file.log,errbuf);
1259: END;
1260:
1261: FOR r_ger_receipt IN lcu_ger_receipt ( p_vat_rep_entity_id,
1262: p_period,

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

1270: p_gl_period_end_date
1271: )
1272: LOOP
1273:
1274: if gv_debug then FND_FILE.PUT_LINE(FND_FILE.LOG,'6'); end if;
1275:
1276: l_rd := rdformula(r_ger_receipt.rev_date,p_gl_period_start_date,p_gl_period_end_date);
1277:
1278: 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 1292: FND_FILE.PUT_LINE(FND_FILE.LOG,'7. CrId:'||r_ger_receipt.cash_receipt_id);

1288: l_new_reversal := new_reversalformula(r_ger_receipt.rev_date,p_gl_period_start_date,p_gl_period_end_date);
1289:
1290: l_zero := zeroformula;
1291: if gv_debug then
1292: FND_FILE.PUT_LINE(FND_FILE.LOG,'7. CrId:'||r_ger_receipt.cash_receipt_id);
1293: end if;
1294:
1295: l_receipt_application := 0;
1296:

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

1295: l_receipt_application := 0;
1296:
1297: FOR r_ger_appl IN lcu_ger_appl (r_ger_receipt.cash_receipt_id)
1298: LOOP
1299: if gv_debug then FND_FILE.PUT_LINE(FND_FILE.LOG,'in 2nd loop'); end if;
1300:
1301: 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 );
1302:
1303: 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 1316: if gv_debug then FND_FILE.PUT_LINE(FND_FILE.LOG,'insert into global'); end if;

1312:
1313: 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 );
1314:
1315: l_vat := vatformula(r_ger_appl.applied, l_app_vat, l_unapp_vat);
1316: if gv_debug then FND_FILE.PUT_LINE(FND_FILE.LOG,'insert into global'); end if;
1317: InsertIntoGlobal(
1318: p_jg_info_v1 => r_ger_receipt.receipt
1319: , p_jg_info_v2 => r_ger_receipt.status
1320: , p_jg_info_v3 => r_ger_receipt.tax_code

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

1410: ELSIF P_CALLINGREPORT = 'JGZZARVR' THEN
1411:
1412: BEGIN
1413:
1414: if gv_debug then FND_FILE.PUT_LINE(FND_FILE.LOG,'JGZZARVR - 1'); end if;
1415: FOR r_euar IN lcu_euar_vatreg (p_vat_rep_entity_id,p_period,p_vat_trx_type, p_ex_vat_trx_type)
1416: LOOP
1417:
1418: if gv_debug then FND_FILE.PUT_LINE(FND_FILE.LOG,'JGZZARVR - 2'); end if;

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

1414: if gv_debug then FND_FILE.PUT_LINE(FND_FILE.LOG,'JGZZARVR - 1'); end if;
1415: FOR r_euar IN lcu_euar_vatreg (p_vat_rep_entity_id,p_period,p_vat_trx_type, p_ex_vat_trx_type)
1416: LOOP
1417:
1418: if gv_debug then FND_FILE.PUT_LINE(FND_FILE.LOG,'JGZZARVR - 2'); end if;
1419:
1420: FND_FILE.PUT_LINE(FND_FILE.LOG,'v_count - '||v_count);
1421: FND_FILE.PUT_LINE(FND_FILE.LOG,'r_euar.vat_code - '||r_euar.vat_code);
1422: FND_FILE.PUT_LINE(FND_FILE.LOG,'v_prev_vat_code - '||v_prev_vat_code);

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

1416: LOOP
1417:
1418: if gv_debug then FND_FILE.PUT_LINE(FND_FILE.LOG,'JGZZARVR - 2'); end if;
1419:
1420: FND_FILE.PUT_LINE(FND_FILE.LOG,'v_count - '||v_count);
1421: FND_FILE.PUT_LINE(FND_FILE.LOG,'r_euar.vat_code - '||r_euar.vat_code);
1422: FND_FILE.PUT_LINE(FND_FILE.LOG,'v_prev_vat_code - '||v_prev_vat_code);
1423:
1424:

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

1417:
1418: if gv_debug then FND_FILE.PUT_LINE(FND_FILE.LOG,'JGZZARVR - 2'); end if;
1419:
1420: FND_FILE.PUT_LINE(FND_FILE.LOG,'v_count - '||v_count);
1421: FND_FILE.PUT_LINE(FND_FILE.LOG,'r_euar.vat_code - '||r_euar.vat_code);
1422: FND_FILE.PUT_LINE(FND_FILE.LOG,'v_prev_vat_code - '||v_prev_vat_code);
1423:
1424:
1425: InsertIntoGlobal(

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

1418: if gv_debug then FND_FILE.PUT_LINE(FND_FILE.LOG,'JGZZARVR - 2'); end if;
1419:
1420: FND_FILE.PUT_LINE(FND_FILE.LOG,'v_count - '||v_count);
1421: FND_FILE.PUT_LINE(FND_FILE.LOG,'r_euar.vat_code - '||r_euar.vat_code);
1422: FND_FILE.PUT_LINE(FND_FILE.LOG,'v_prev_vat_code - '||v_prev_vat_code);
1423:
1424:
1425: InsertIntoGlobal(
1426: p_jg_info_n1 => r_euar.seq_num

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

1453: );
1454: v_enable_report_sequence_flag := r_euar.enable_report_sequence_flag;
1455: END LOOP;
1456:
1457: if gv_debug then FND_FILE.PUT_LINE(FND_FILE.LOG,'JGZZARVR - 3'); end if;
1458: FOR r_euar_data_count IN lcu_euar_data_count ( p_ex_vat_trx_type)
1459: LOOP
1460: UPDATE jg_zz_vat_trx_gt
1461: SET jg_info_n20 = r_euar_data_count.c_no_data_count;

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

1459: LOOP
1460: UPDATE jg_zz_vat_trx_gt
1461: SET jg_info_n20 = r_euar_data_count.c_no_data_count;
1462: END LOOP;
1463: if gv_debug then FND_FILE.PUT_LINE(FND_FILE.LOG,'JGZZARVR - 4'); end if;
1464:
1465: -- Implement the report level seq number --
1466:
1467: IF v_enable_report_sequence_flag = 'Y' THEN

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

1541:
1542: RETURN (TRUE);
1543: EXCEPTION
1544: WHEN INVALID_ENTRY THEN
1545: fnd_file.put_line(fnd_file.log,LOG_MESSAGE);
1546: raise;
1547: RETURN (FALSE);
1548: WHEN OTHERS THEN
1549: FND_FILE.PUT_LINE(FND_FILE.LOG,'Unexpected error in JG_ZZ_SUMMARY_AR_PKG.beforeReport. Error-' ||SUBSTR(SQLERRM,1,200));

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

1545: fnd_file.put_line(fnd_file.log,LOG_MESSAGE);
1546: raise;
1547: RETURN (FALSE);
1548: WHEN OTHERS THEN
1549: FND_FILE.PUT_LINE(FND_FILE.LOG,'Unexpected error in JG_ZZ_SUMMARY_AR_PKG.beforeReport. Error-' ||SUBSTR(SQLERRM,1,200));
1550: raise;
1551: RETURN (FALSE);
1552: END beforeReport;
1553: