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.JAI_AP_TDS_ETDS_PKG dependencies on FND_FILE

Line 304: FND_FILE.put_line(FND_FILE.log, p_message);

300: PROCEDURE chk_err (p_err IN VARCHAR2,
301: p_message IN VARCHAR2) IS
302: BEGIN
303: IF (p_err = 'E') THEN
304: FND_FILE.put_line(FND_FILE.log, p_message);
305: RAISE_APPLICATION_ERROR(-20099, p_message, true);
306: ELSIF (p_err in ('N', 'S')) THEN
307: FND_FILE.put_line(FND_FILE.log, p_message);
308: END IF;

Line 307: FND_FILE.put_line(FND_FILE.log, p_message);

303: IF (p_err = 'E') THEN
304: FND_FILE.put_line(FND_FILE.log, p_message);
305: RAISE_APPLICATION_ERROR(-20099, p_message, true);
306: ELSIF (p_err in ('N', 'S')) THEN
307: FND_FILE.put_line(FND_FILE.log, p_message);
308: END IF;
309: END chk_err;
310:
311: PROCEDURE get_attr_value (p_org_id IN NUMBER,

Line 1388: fnd_file.put_line(FND_FILE.LOG, 'c_update_amount.base_invoice_id: ' || c_update_amount.base_invoice_id);

1384: ln_remain_amt := 0;
1385: SELECT invoice_amount - NVL(amount_paid, 0) INTO ln_calculated_inv_amt
1386: FROM ap_invoices_all
1387: WHERE invoice_id = c_update_amount.base_invoice_id;
1388: fnd_file.put_line(FND_FILE.LOG, 'c_update_amount.base_invoice_id: ' || c_update_amount.base_invoice_id);
1389: fnd_file.put_line(FND_FILE.LOG, 'ln_calculated_inv_amt: ' || ln_calculated_inv_amt);
1390: IF c_update_amount.base_invoice_type_lookup_code = 'STANDARD' THEN
1391: OPEN c_get_pp_apply_amt(c_update_amount.base_invoice_id);
1392: FETCH c_get_pp_apply_amt INTO ln_pp_apply_amt;

Line 1389: fnd_file.put_line(FND_FILE.LOG, 'ln_calculated_inv_amt: ' || ln_calculated_inv_amt);

1385: SELECT invoice_amount - NVL(amount_paid, 0) INTO ln_calculated_inv_amt
1386: FROM ap_invoices_all
1387: WHERE invoice_id = c_update_amount.base_invoice_id;
1388: fnd_file.put_line(FND_FILE.LOG, 'c_update_amount.base_invoice_id: ' || c_update_amount.base_invoice_id);
1389: fnd_file.put_line(FND_FILE.LOG, 'ln_calculated_inv_amt: ' || ln_calculated_inv_amt);
1390: IF c_update_amount.base_invoice_type_lookup_code = 'STANDARD' THEN
1391: OPEN c_get_pp_apply_amt(c_update_amount.base_invoice_id);
1392: FETCH c_get_pp_apply_amt INTO ln_pp_apply_amt;
1393: CLOSE c_get_pp_apply_amt;

Line 1394: fnd_file.put_line(FND_FILE.LOG, 'STD ln_pp_apply_amt: ' || ln_pp_apply_amt);

1390: IF c_update_amount.base_invoice_type_lookup_code = 'STANDARD' THEN
1391: OPEN c_get_pp_apply_amt(c_update_amount.base_invoice_id);
1392: FETCH c_get_pp_apply_amt INTO ln_pp_apply_amt;
1393: CLOSE c_get_pp_apply_amt;
1394: fnd_file.put_line(FND_FILE.LOG, 'STD ln_pp_apply_amt: ' || ln_pp_apply_amt);
1395: ln_calculated_inv_amt := ln_calculated_inv_amt + nvl(ln_pp_apply_amt, 0);
1396: ELSIF c_update_amount.base_invoice_type_lookup_code = 'PREPAYMENT' THEN
1397: OPEN c_get_applied_amt(c_update_amount.base_invoice_id);
1398: FETCH c_get_applied_amt INTO ln_pp_apply_amt;

Line 1400: fnd_file.put_line(FND_FILE.LOG, 'PP ln_pp_apply_amt: ' || ln_pp_apply_amt);

1396: ELSIF c_update_amount.base_invoice_type_lookup_code = 'PREPAYMENT' THEN
1397: OPEN c_get_applied_amt(c_update_amount.base_invoice_id);
1398: FETCH c_get_applied_amt INTO ln_pp_apply_amt;
1399: CLOSE c_get_applied_amt;
1400: fnd_file.put_line(FND_FILE.LOG, 'PP ln_pp_apply_amt: ' || ln_pp_apply_amt);
1401: ln_calculated_inv_amt := ln_calculated_inv_amt + nvl(ln_pp_apply_amt, 0);
1402: OPEN c_get_remaining_amt(c_update_amount.base_invoice_id);
1403: FETCH c_get_remaining_amt INTO ln_remain_amt;
1404: CLOSE c_get_remaining_amt;

Line 1405: fnd_file.put_line(FND_FILE.LOG, 'PP ln_remain_amt: ' || ln_remain_amt);

1401: ln_calculated_inv_amt := ln_calculated_inv_amt + nvl(ln_pp_apply_amt, 0);
1402: OPEN c_get_remaining_amt(c_update_amount.base_invoice_id);
1403: FETCH c_get_remaining_amt INTO ln_remain_amt;
1404: CLOSE c_get_remaining_amt;
1405: fnd_file.put_line(FND_FILE.LOG, 'PP ln_remain_amt: ' || ln_remain_amt);
1406: ln_calculated_inv_amt := ln_calculated_inv_amt + nvl(ln_remain_amt, 0);
1407: END IF; \*IF c_update_amount.base_invoice_type_lookup_code = 'STANDARD' THEN*\
1408: fnd_file.put_line(FND_FILE.LOG, 'ln_calculated_inv_amt: ' || ln_calculated_inv_amt);
1409: UPDATE JAI_AP_ETDS_T

Line 1408: fnd_file.put_line(FND_FILE.LOG, 'ln_calculated_inv_amt: ' || ln_calculated_inv_amt);

1404: CLOSE c_get_remaining_amt;
1405: fnd_file.put_line(FND_FILE.LOG, 'PP ln_remain_amt: ' || ln_remain_amt);
1406: ln_calculated_inv_amt := ln_calculated_inv_amt + nvl(ln_remain_amt, 0);
1407: END IF; \*IF c_update_amount.base_invoice_type_lookup_code = 'STANDARD' THEN*\
1408: fnd_file.put_line(FND_FILE.LOG, 'ln_calculated_inv_amt: ' || ln_calculated_inv_amt);
1409: UPDATE JAI_AP_ETDS_T
1410: SET base_taxabale_amount = ln_calculated_inv_amt,
1411: tds_invoice_id = -9999,
1412: amt_of_tds = ((amt_of_tds*ln_calculated_inv_amt)/base_taxabale_amount),

Line 1513: fnd_file.put_line(FND_FILE.LOG, ' consider for challan '|| ln_con_for_challan);

1509: END IF;
1510:
1511: IF ln_check_number IS NULL THEN
1512: ln_con_for_challan := 0;
1513: fnd_file.put_line(FND_FILE.LOG, ' consider for challan '|| ln_con_for_challan);
1514: GOTO update_now;
1515: END IF ;
1516:
1517: IF v_tds_check_id IS NULL THEN

Line 1565: FND_FILE.put_line(FND_FILE.log, 'lengths - inv_type:'||length(dtl.inv_type)

1561: v_prepayment_amount_applied := nvl(v_prepayment_amount_applied,0);
1562:
1563: IF v_generate_headers THEN
1564: IF NVL(lv_action,'X') <> 'V' THEN
1565: FND_FILE.put_line(FND_FILE.log, 'lengths - inv_type:'||length(dtl.inv_type)
1566: ||', ch_num:'||length(v_challan_num) ||', bank_brCode:'||length(v_bank_branch_code) ||', ch_err:'
1567: ||', ded_err:'||length(v_deductee_err)
1568: );
1569: END IF ;

Line 1683: FND_FILE.put_line(FND_FILE.log, 'Err->'||SQLERRM);

1679:
1680:
1681: EXCEPTION
1682: WHEN OTHERS THEN
1683: FND_FILE.put_line(FND_FILE.log, 'Err->'||SQLERRM);
1684: FND_FILE.put_line(FND_FILE.log, 'statement->'||v_statement_id
1685: ||', tds_invid->'||v_debug_tds_invid||', base_invid->'||v_debug_base_invid);
1686: RAISE;
1687: END populate_details;

Line 1684: FND_FILE.put_line(FND_FILE.log, 'statement->'||v_statement_id

1680:
1681: EXCEPTION
1682: WHEN OTHERS THEN
1683: FND_FILE.put_line(FND_FILE.log, 'Err->'||SQLERRM);
1684: FND_FILE.put_line(FND_FILE.log, 'statement->'||v_statement_id
1685: ||', tds_invid->'||v_debug_tds_invid||', base_invid->'||v_debug_base_invid);
1686: RAISE;
1687: END populate_details;
1688: */ --Commented by Chong for eTDS ER bug#16414088 End

Line 2215: fnd_file.put_line(FND_FILE.LOG, ' consider for challan '|| ln_con_for_challan);

2211: END IF;
2212:
2213: IF ln_check_number IS NULL THEN
2214: ln_con_for_challan := 0;
2215: fnd_file.put_line(FND_FILE.LOG, ' consider for challan '|| ln_con_for_challan);
2216: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name,' consider for challan '|| ln_con_for_challan);
2217: GOTO update_now;
2218: END IF ;
2219:

Line 2270: FND_FILE.put_line(FND_FILE.log, 'lengths - inv_type:'||length(dtl.inv_type)

2266: v_prepayment_amount_applied := nvl(v_prepayment_amount_applied,0);
2267:
2268: IF v_generate_headers THEN
2269: IF NVL(lv_action,'X') <> 'V' THEN
2270: FND_FILE.put_line(FND_FILE.log, 'lengths - inv_type:'||length(dtl.inv_type)
2271: ||', ch_num:'||length(v_challan_num) ||', bank_brCode:'||length(v_bank_branch_code) ||', ch_err:'
2272: ||', ded_err:'||length(v_deductee_err)
2273: );
2274: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, G_MODULE_NAME||l_api_name, 'lengths - inv_type:' || length(dtl.inv_type)

Line 2408: FND_FILE.put_line(FND_FILE.log, 'Err->'||SQLERRM);

2404: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE
2405: ,G_MODULE_NAME||l_api_name||'. Other_Exception'
2406: ,'statement->'||v_statement_id
2407: ||', tds_invid->'||v_debug_tds_invid||', base_invid->'||v_debug_base_invid);
2408: FND_FILE.put_line(FND_FILE.log, 'Err->'||SQLERRM);
2409: FND_FILE.put_line(FND_FILE.log, 'statement->'||v_statement_id
2410: ||', tds_invid->'||v_debug_tds_invid||', base_invid->'||v_debug_base_invid);
2411: RAISE;
2412: END populate_details;

Line 2409: FND_FILE.put_line(FND_FILE.log, 'statement->'||v_statement_id

2405: ,G_MODULE_NAME||l_api_name||'. Other_Exception'
2406: ,'statement->'||v_statement_id
2407: ||', tds_invid->'||v_debug_tds_invid||', base_invid->'||v_debug_base_invid);
2408: FND_FILE.put_line(FND_FILE.log, 'Err->'||SQLERRM);
2409: FND_FILE.put_line(FND_FILE.log, 'statement->'||v_statement_id
2410: ||', tds_invid->'||v_debug_tds_invid||', base_invid->'||v_debug_base_invid);
2411: RAISE;
2412: END populate_details;
2413: --Added by Chong for eTDS ER bug#16414088 End

Line 3683: -- fnd_file.put_line(FND_FILE.LOG,' tds section ' || p_tds_section);

3679:
3680:
3681: -- End for bug 6796765.
3682:
3683: -- fnd_file.put_line(FND_FILE.LOG,' tds section ' || p_tds_section);
3684: -- fnd_file.put_line(FND_FILE.LOG,'SEction code with header '||
3685: -- LPAD(getSectionCode(upper(p_tds_section),upper(lv_sec_string)), sq_len_3, v_quart_pad));
3686: -- fnd_file.put_line(FND_FILE.LOG,'SEction code with header '|| getSectionCode(upper(p_tds_section),
3687: -- upper(lv_sec_string)) );

Line 3684: -- fnd_file.put_line(FND_FILE.LOG,'SEction code with header '||

3680:
3681: -- End for bug 6796765.
3682:
3683: -- fnd_file.put_line(FND_FILE.LOG,' tds section ' || p_tds_section);
3684: -- fnd_file.put_line(FND_FILE.LOG,'SEction code with header '||
3685: -- LPAD(getSectionCode(upper(p_tds_section),upper(lv_sec_string)), sq_len_3, v_quart_pad));
3686: -- fnd_file.put_line(FND_FILE.LOG,'SEction code with header '|| getSectionCode(upper(p_tds_section),
3687: -- upper(lv_sec_string)) );
3688:

Line 3686: -- fnd_file.put_line(FND_FILE.LOG,'SEction code with header '|| getSectionCode(upper(p_tds_section),

3682:
3683: -- fnd_file.put_line(FND_FILE.LOG,' tds section ' || p_tds_section);
3684: -- fnd_file.put_line(FND_FILE.LOG,'SEction code with header '||
3685: -- LPAD(getSectionCode(upper(p_tds_section),upper(lv_sec_string)), sq_len_3, v_quart_pad));
3686: -- fnd_file.put_line(FND_FILE.LOG,'SEction code with header '|| getSectionCode(upper(p_tds_section),
3687: -- upper(lv_sec_string)) );
3688:
3689: IF p_generate_headers = 'N' THEN
3690:

Line 4630: FND_FILE.put_line(FND_FILE.log, 'sql code : ' || SQLCODE );

4626: BEGIN
4627: ln_check_number := to_number( p_variable ) ;
4628: EXCEPTION
4629: WHEN OTHERS THEN
4630: FND_FILE.put_line(FND_FILE.log, 'sql code : ' || SQLCODE );
4631: FND_FILE.put_line(FND_FILE.log, 'Challan Detail Error - ' || '. ERROR : ' || p_err );
4632:
4633: -- Harshita for Bug 4640996
4634: IF p_action <> 'V' THEN

Line 4631: FND_FILE.put_line(FND_FILE.log, 'Challan Detail Error - ' || '. ERROR : ' || p_err );

4627: ln_check_number := to_number( p_variable ) ;
4628: EXCEPTION
4629: WHEN OTHERS THEN
4630: FND_FILE.put_line(FND_FILE.log, 'sql code : ' || SQLCODE );
4631: FND_FILE.put_line(FND_FILE.log, 'Challan Detail Error - ' || '. ERROR : ' || p_err );
4632:
4633: -- Harshita for Bug 4640996
4634: IF p_action <> 'V' THEN
4635: raise_application_error(-20023, 'Challan Detail Error - ' || '. ERROR : ' || p_err );

Line 6364: FND_FILE.put_line(FND_FILE.log, 'Ver:619.1 Start of eTDS File Creation for Yearly Returns Batch_id->'||v_batch_id

6360:
6361: IF NVL(p_period,'XX') = 'XX' THEN
6362: /*Commented out by Chong for eTDS, remove Yearly returns 20130330
6363: lv_etds_yearly_returns := 'Y' ;
6364: FND_FILE.put_line(FND_FILE.log, '~~~~Ver:619.1~~~~ Start of eTDS File Creation for Yearly Returns Batch_id->'||v_batch_id
6365: ||', Creation Date->'||to_char(SYSDATE,'dd-mon-yyyy hh24:mi:ss')||' ~~~~~~~~~~~~~~~~~~');
6366: */
6367: NULL;
6368: ELSE

Line 6370: FND_FILE.put_line(FND_FILE.log, 'Ver:115.6 Start of eTDS File Creation for Quarterly returns

6366: */
6367: NULL;
6368: ELSE
6369: lv_etds_yearly_returns := 'N' ;
6370: FND_FILE.put_line(FND_FILE.log, '~~~~Ver:115.6~~~~ Start of eTDS File Creation for Quarterly returns
6371: Batch_id->'||v_batch_id || 'Period : ' || p_period
6372: ||', Creation Date->'||to_char(SYSDATE,'dd-mon-yyyy hh24:mi:ss')||' ~~~~~~~~~~~~~~~~~~');
6373: END IF ;
6374:

Line 6376: FND_FILE.put_line(FND_FILE.log, 'Tan Number length is greater than 10 characters');

6372: ||', Creation Date->'||to_char(SYSDATE,'dd-mon-yyyy hh24:mi:ss')||' ~~~~~~~~~~~~~~~~~~');
6373: END IF ;
6374:
6375: IF length(p_tan_number) > 10 THEN
6376: FND_FILE.put_line(FND_FILE.log, 'Tan Number length is greater than 10 characters');
6377: RAISE_APPLICATION_ERROR(-20014, 'Tan Number length is greater than 10 characters', true);
6378: END IF;
6379: /*ETDS FVU3.1 Bug 11896260 Start*/
6380: if(p_organization_id is null and p_deductor_addr_org_id is null) then

Line 6381: FND_FILE.put_line(FND_FILE.log, 'Deductor Address must be selected as the report is being submitted for TAN Number');

6377: RAISE_APPLICATION_ERROR(-20014, 'Tan Number length is greater than 10 characters', true);
6378: END IF;
6379: /*ETDS FVU3.1 Bug 11896260 Start*/
6380: if(p_organization_id is null and p_deductor_addr_org_id is null) then
6381: FND_FILE.put_line(FND_FILE.log, 'Deductor Address must be selected as the report is being submitted for TAN Number');
6382: RAISE_APPLICATION_ERROR(-20018, 'Deductor Address must be selected as the report is being submitted for TAN Number', true);
6383: END IF;
6384:
6385: if (p_organization_id is null) then

Line 6398: FND_FILE.put_line(FND_FILE.log, 'Regime setup is not same for all OUs for the provided TAN number');

6394: and jrp.organization_id in (select distinct organization_id from jai_ap_tds_org_tan_v where org_tan_num = p_tan_number)
6395: and jrr.registration_id = jrpr.registration_id;
6396:
6397: if (v_regime_override > 0) then
6398: FND_FILE.put_line(FND_FILE.log, 'Regime setup is not same for all OUs for the provided TAN number');
6399: RAISE_APPLICATION_ERROR(-20014, 'For the selected TAN number attributes must be same across the OUs', true);
6400: end if;
6401: end if;
6402:

Line 6489: FND_FILE.put_line(FND_FILE.log, 'Pan Number cannot be retreived based on given TAN Number');

6485:
6486: END LOOP;
6487:
6488: IF v_deductor_pan IS NULL THEN
6489: FND_FILE.put_line(FND_FILE.log, 'Pan Number cannot be retreived based on given TAN Number');
6490: RAISE_APPLICATION_ERROR(-20015, 'Pan Number cannot be retreived based on given TAN Number', true);
6491: END IF;
6492:
6493: v_financial_year := p_fin_year;

Line 6508: FND_FILE.put_line(FND_FILE.log, 'Cannot get values for Financial Year and Assessment Year');

6504: FETCH c_fin_year INTO v_start_date, v_end_date;
6505: CLOSE c_fin_year;
6506:
6507: IF v_start_date IS NULL OR v_end_date IS NULL THEN
6508: FND_FILE.put_line(FND_FILE.log, 'Cannot get values for Financial Year and Assessment Year');
6509: RAISE_APPLICATION_ERROR( -20016, 'Cannot get values for Financial Year and Assessment Year');
6510: END IF;
6511:
6512: -- Fetching Location linked to Input Organization from where address details are captured

Line 6560: FND_FILE.put_line(FND_FILE.log, 'Error Occured during opening of file(1):'||SQLERRM);

6556: BEGIN
6557: jai_ap_tds_etds_pkg.openFile(p_file_path, p_filename);
6558: EXCEPTION
6559: WHEN OTHERS THEN
6560: FND_FILE.put_line(FND_FILE.log, 'Error Occured during opening of file(1):'||SQLERRM);
6561: RAISE_APPLICATION_ERROR(-20016, 'Error Occured(1):'||SQLERRM, true);
6562: END;
6563:
6564: IF p_action <> 'V' THEN

Line 6565: FND_FILE.put_line(FND_FILE.log, 'Start File Header');

6561: RAISE_APPLICATION_ERROR(-20016, 'Error Occured(1):'||SQLERRM, true);
6562: END;
6563:
6564: IF p_action <> 'V' THEN
6565: FND_FILE.put_line(FND_FILE.log, 'Start File Header');
6566: END IF ;
6567:
6568: -- File Header (42 Chars)
6569: v_line_number := v_line_number + 1;

Line 6701: FND_FILE.put_line(FND_FILE.log, 'Batch Header');

6697: ))); /*Bug 11896260*/
6698:
6699:
6700: IF p_action <> 'V' THEN
6701: FND_FILE.put_line(FND_FILE.log, 'Batch Header');
6702: END IF ;
6703:
6704: v_ack_num_tan_app := NULL;
6705: v_pro_rcpt_num_org_ret := nvl(p_pro_rcpt_num_org_ret,0);

Line 6886: FND_FILE.put_line(FND_FILE.log, 'Challan Detail');

6882: END IF ;
6883: END IF ;
6884:
6885: IF p_action <> 'V' THEN
6886: FND_FILE.put_line(FND_FILE.log, 'Challan Detail');
6887: END IF ;
6888:
6889: -- Challan Details (60 Chars)
6890: v_record_type := 'CD';

Line 6921: FND_FILE.put_line(FND_FILE.log, 'cd.tds_section: '||cd.tds_section||' cd.challan_num: '||cd.challan_num||

6917: IF cd.challan_num = 'No Challan Number' THEN
6918: cd.challan_num := null ;
6919: END IF ;
6920:
6921: FND_FILE.put_line(FND_FILE.log, 'cd.tds_section: '||cd.tds_section||' cd.challan_num: '||cd.challan_num||
6922: ' cd.challan_date :' || cd.challan_date || 'cd.bank_branch_code' || cd.bank_branch_code /*|| 'cd.check_number' || cd.check_number- Bug 13323753*/);
6923:
6924:
6925: --MODIFIED BY CSAHOO FOR BUG#6158875

Line 6939: FND_FILE.put_line(FND_FILE.log, 'v_batch_id: '||v_batch_id||' v_q_deductee_cnt: '||v_q_deductee_cnt);

6935: CLOSE c_deductee_cnt_bt ;
6936:
6937: v_q_deductee_cnt := nvl(v_q_deductee_cnt,0) + nvl(v_bt_deductee_cnt, 0);
6938:
6939: FND_FILE.put_line(FND_FILE.log, 'v_batch_id: '||v_batch_id||' v_q_deductee_cnt: '||v_q_deductee_cnt);
6940:
6941: IF p_action = 'H' THEN
6942: jai_ap_tds_etds_pkg.create_quarterly_cd;
6943: END IF ;

Line 7098: FND_FILE.put_line(FND_FILE.log, 'Challan Line:'||v_line_number

7094: and consider_for_challan=1
7095: and tds_vendor_classification is null; /* Avanija for FVU3.6 */
7096:
7097: IF p_action <> 'V' THEN
7098: FND_FILE.put_line(FND_FILE.log, 'Challan Line:'||v_line_number
7099: ||', tdsSec:' || cd.tds_section || ', ChlNum:' || cd.challan_num
7100: ||', ChlDate:'||cd.challan_date||', bankBr:'||cd.bank_branch_code
7101: );
7102: END IF ;

Line 7132: --FND_FILE.put_line(FND_FILE.log, 'Starting Transporter');

7128:
7129: ----------------------------------------------------------------------
7130: --Changed by Zhhou for bug#15962641 20121205 end
7131:
7132: --FND_FILE.put_line(FND_FILE.log, 'Starting Transporter');
7133: FND_FILE.put_line(FND_FILE.log,'Starting '||cd.tds_vendor_classification||'s');
7134: ---------------------------------------------------------
7135: --Changed by Zhiwei for Bug#15840480 FVU3.6 end
7136:

Line 7133: FND_FILE.put_line(FND_FILE.log,'Starting '||cd.tds_vendor_classification||'s');

7129: ----------------------------------------------------------------------
7130: --Changed by Zhhou for bug#15962641 20121205 end
7131:
7132: --FND_FILE.put_line(FND_FILE.log, 'Starting Transporter');
7133: FND_FILE.put_line(FND_FILE.log,'Starting '||cd.tds_vendor_classification||'s');
7134: ---------------------------------------------------------
7135: --Changed by Zhiwei for Bug#15840480 FVU3.6 end
7136:
7137: IF lv_etds_yearly_returns = 'Y' THEN

Line 7307: FND_FILE.put_line(FND_FILE.log, 'Challan Line Trans:'||v_line_number

7303: --and tds_vendor_classification in ( 'Transporter','Software');/* commented by Avanija for FVU3.6 */
7304: -----------------------------------------------------------------------
7305: --Added by Zhhou for bug#15962641 20121205 end
7306: IF p_action <> 'V' THEN
7307: FND_FILE.put_line(FND_FILE.log, 'Challan Line Trans:'||v_line_number
7308: ||', tdsSec:' || cd.tds_section || ', ChlNum Trans:' || cd.challan_num
7309: ||', ChlDate:'||cd.challan_date||', bankBr Trans:'||cd.bank_branch_code
7310: );
7311: END IF ;

Line 7326: --FND_FILE.put_line(FND_FILE.log, 'Calling process_deductee_records_trans');

7322: v_deductee_slno := 0 ;
7323:
7324: --Changed by Zhiwei for Bug#15840480 FVU3.6 begin
7325: ---------------------------------------------------------
7326: --FND_FILE.put_line(FND_FILE.log, 'Calling process_deductee_records_trans');
7327: --FND_FILE.put_line(FND_FILE.log, 'Calling process_deductee_records_trans for '|| cd.tds_vendor_classification);--Commented by Zhhou for bug#15962641 20121205
7328: --process_deductee_records_trans ; -- internal procedure call
7329: --process_deductee_records_trans(cd.tds_vendor_classification);--Commented by Zhhou for bug#15962641 20121205
7330: ---------------------------------------------------------

Line 7327: --FND_FILE.put_line(FND_FILE.log, 'Calling process_deductee_records_trans for '|| cd.tds_vendor_classification);--Commented by Zhhou for bug#15962641 20121205

7323:
7324: --Changed by Zhiwei for Bug#15840480 FVU3.6 begin
7325: ---------------------------------------------------------
7326: --FND_FILE.put_line(FND_FILE.log, 'Calling process_deductee_records_trans');
7327: --FND_FILE.put_line(FND_FILE.log, 'Calling process_deductee_records_trans for '|| cd.tds_vendor_classification);--Commented by Zhhou for bug#15962641 20121205
7328: --process_deductee_records_trans ; -- internal procedure call
7329: --process_deductee_records_trans(cd.tds_vendor_classification);--Commented by Zhhou for bug#15962641 20121205
7330: ---------------------------------------------------------
7331: --Changed by Zhiwei for Bug#15840480 FVU3.6 end

Line 7335: FND_FILE.put_line(FND_FILE.log, 'Calling process_deductee_records_trans for Transporter');

7331: --Changed by Zhiwei for Bug#15840480 FVU3.6 end
7332: --Added by Zhhou for bug#15962641 20121205 begin
7333: ---------------------------------------------------------
7334:
7335: FND_FILE.put_line(FND_FILE.log, 'Calling process_deductee_records_trans for Transporter');
7336: --process_deductee_records_trans('Transporter');/*Avanija for FVU3.6 */
7337: FND_FILE.put_line(FND_FILE.log, 'Calling process_deductee_records_trans for Software');
7338: --process_deductee_records_trans('Software'); /*Avanija for FVU3.6 */
7339: process_deductee_records_trans(cd.tds_vendor_classification); /*Avanija for FVU3.6 */

Line 7337: FND_FILE.put_line(FND_FILE.log, 'Calling process_deductee_records_trans for Software');

7333: ---------------------------------------------------------
7334:
7335: FND_FILE.put_line(FND_FILE.log, 'Calling process_deductee_records_trans for Transporter');
7336: --process_deductee_records_trans('Transporter');/*Avanija for FVU3.6 */
7337: FND_FILE.put_line(FND_FILE.log, 'Calling process_deductee_records_trans for Software');
7338: --process_deductee_records_trans('Software'); /*Avanija for FVU3.6 */
7339: process_deductee_records_trans(cd.tds_vendor_classification); /*Avanija for FVU3.6 */
7340: ---------------------------------------------------------
7341: --Added by Zhhou for bug#15962641 20121205 end

Line 7356: FND_FILE.put_line(FND_FILE.log, 'Deductee Detail');

7352:
7353: IF lv_etds_yearly_returns= 'Y' THEN
7354: v_record_type := 'DD';
7355: IF p_action <> 'V' THEN
7356: FND_FILE.put_line(FND_FILE.log, 'Deductee Detail');
7357: -- Dedectee Details (338 Chars)
7358: v_record_type := 'DD';
7359: v_deductee_slno := 0;
7360: END IF;

Line 7372: FND_FILE.put_line(FND_FILE.log,' LISTING THE ERRORS IN THIS BATCH ' );

7368: END IF ;
7369:
7370: IF p_action = 'V' THEN
7371:
7372: FND_FILE.put_line(FND_FILE.log,' LISTING THE ERRORS IN THIS BATCH ' );
7373: FND_FILE.put_line(FND_FILE.log,'-------------------------------------------------------------------- ' );
7374:
7375: ln_errors_exist := 0;
7376:

Line 7373: FND_FILE.put_line(FND_FILE.log,'-------------------------------------------------------------------- ' );

7369:
7370: IF p_action = 'V' THEN
7371:
7372: FND_FILE.put_line(FND_FILE.log,' LISTING THE ERRORS IN THIS BATCH ' );
7373: FND_FILE.put_line(FND_FILE.log,'-------------------------------------------------------------------- ' );
7374:
7375: ln_errors_exist := 0;
7376:
7377: FOR rec_get_errors IN c_get_errors(v_batch_id) /*Bug 8880543 - Modified ln_batch_id to v_batch_id*/

Line 7380: FND_FILE.put_line(FND_FILE.log, rec_get_errors.Error_Message );

7376:
7377: FOR rec_get_errors IN c_get_errors(v_batch_id) /*Bug 8880543 - Modified ln_batch_id to v_batch_id*/
7378: LOOP
7379: ln_errors_exist := 1 ;
7380: FND_FILE.put_line(FND_FILE.log, rec_get_errors.Error_Message );
7381: END LOOP ;
7382:
7383: IF ln_errors_exist = 0 THEN
7384: FND_FILE.put_line(FND_FILE.log,' File Validation Successful. No Errors Found !! ' );

Line 7384: FND_FILE.put_line(FND_FILE.log,' File Validation Successful. No Errors Found !! ' );

7380: FND_FILE.put_line(FND_FILE.log, rec_get_errors.Error_Message );
7381: END LOOP ;
7382:
7383: IF ln_errors_exist = 0 THEN
7384: FND_FILE.put_line(FND_FILE.log,' File Validation Successful. No Errors Found !! ' );
7385: END IF ;
7386:
7387: FND_FILE.put_line(FND_FILE.log,'-------------------------------------------------------------------- ' );
7388: FND_FILE.put_line(FND_FILE.log,' END OF ERRORS IN THIS BATCH ' );

Line 7387: FND_FILE.put_line(FND_FILE.log,'-------------------------------------------------------------------- ' );

7383: IF ln_errors_exist = 0 THEN
7384: FND_FILE.put_line(FND_FILE.log,' File Validation Successful. No Errors Found !! ' );
7385: END IF ;
7386:
7387: FND_FILE.put_line(FND_FILE.log,'-------------------------------------------------------------------- ' );
7388: FND_FILE.put_line(FND_FILE.log,' END OF ERRORS IN THIS BATCH ' );
7389:
7390: END IF ;
7391:

Line 7388: FND_FILE.put_line(FND_FILE.log,' END OF ERRORS IN THIS BATCH ' );

7384: FND_FILE.put_line(FND_FILE.log,' File Validation Successful. No Errors Found !! ' );
7385: END IF ;
7386:
7387: FND_FILE.put_line(FND_FILE.log,'-------------------------------------------------------------------- ' );
7388: FND_FILE.put_line(FND_FILE.log,' END OF ERRORS IN THIS BATCH ' );
7389:
7390: END IF ;
7391:
7392: jai_ap_tds_etds_pkg.closeFile;

Line 7395: FND_FILE.put_line(FND_FILE.log, '~ End of eTDS File Creation ~~~~');

7391:
7392: jai_ap_tds_etds_pkg.closeFile;
7393:
7394: IF p_action <> 'V' THEN
7395: FND_FILE.put_line(FND_FILE.log, '~~~~~~~~~~~~~~~ End of eTDS File Creation ~~~~~~~~~~~~~~~~~~');
7396: END IF ;
7397: /*ETDS FVU3.1 Bug 11896260*/
7398: if (lv_etds_yearly_returns='N') then
7399: open c_get_state_desc ;