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 650: fnd_file.put_line(FND_FILE.LOG, ' consider for challan '|| ln_con_for_challan);

646: v_challan_date, ln_check_number;
647: -- Bug 5975168. Added by csahoo
648: IF c_check_dtls%NOTFOUND THEN
649: ln_con_for_challan := 0;
650: fnd_file.put_line(FND_FILE.LOG, ' consider for challan '|| ln_con_for_challan);
651: CLOSE c_check_dtls;
652: GOTO update_now;
653: END IF ;
654: -- End for bug 5975168

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

702: v_prepayment_amount_applied := nvl(v_prepayment_amount_applied,0);
703:
704: IF v_generate_headers THEN
705: IF NVL(lv_action,'X') <> 'V' THEN
706: FND_FILE.put_line(FND_FILE.log, 'lengths - inv_type:'||length(dtl.inv_type)
707: ||', ch_num:'||length(v_challan_num) ||', bank_brCode:'||length(v_bank_branch_code) ||', ch_err:'
708: ||', ded_err:'||length(v_deductee_err)
709: );
710: END IF ;

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

772:
773:
774: EXCEPTION
775: WHEN OTHERS THEN
776: FND_FILE.put_line(FND_FILE.log, 'Err->'||SQLERRM);
777: FND_FILE.put_line(FND_FILE.log, 'statement->'||v_statement_id
778: ||', tds_invid->'||v_debug_tds_invid||', base_invid->'||v_debug_base_invid);
779: RAISE;
780: END populate_details;

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

773:
774: EXCEPTION
775: WHEN OTHERS THEN
776: FND_FILE.put_line(FND_FILE.log, 'Err->'||SQLERRM);
777: FND_FILE.put_line(FND_FILE.log, 'statement->'||v_statement_id
778: ||', tds_invid->'||v_debug_tds_invid||', base_invid->'||v_debug_base_invid);
779: RAISE;
780: END populate_details;
781:

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

1928: END IF;
1929:
1930: -- End for bug 6796765.
1931:
1932: -- fnd_file.put_line(FND_FILE.LOG,' tds section ' || p_tds_section);
1933: -- fnd_file.put_line(FND_FILE.LOG,'SEction code with header '||
1934: -- LPAD(getSectionCode(upper(p_tds_section),upper(lv_sec_string)), sq_len_3, v_quart_pad));
1935: -- fnd_file.put_line(FND_FILE.LOG,'SEction code with header '|| getSectionCode(upper(p_tds_section),
1936: -- upper(lv_sec_string)) );

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

1929:
1930: -- End for bug 6796765.
1931:
1932: -- fnd_file.put_line(FND_FILE.LOG,' tds section ' || p_tds_section);
1933: -- fnd_file.put_line(FND_FILE.LOG,'SEction code with header '||
1934: -- LPAD(getSectionCode(upper(p_tds_section),upper(lv_sec_string)), sq_len_3, v_quart_pad));
1935: -- fnd_file.put_line(FND_FILE.LOG,'SEction code with header '|| getSectionCode(upper(p_tds_section),
1936: -- upper(lv_sec_string)) );
1937:

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

1931:
1932: -- fnd_file.put_line(FND_FILE.LOG,' tds section ' || p_tds_section);
1933: -- fnd_file.put_line(FND_FILE.LOG,'SEction code with header '||
1934: -- LPAD(getSectionCode(upper(p_tds_section),upper(lv_sec_string)), sq_len_3, v_quart_pad));
1935: -- fnd_file.put_line(FND_FILE.LOG,'SEction code with header '|| getSectionCode(upper(p_tds_section),
1936: -- upper(lv_sec_string)) );
1937:
1938: IF p_generate_headers = 'N' THEN
1939:

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

2763: BEGIN
2764: ln_check_number := to_number( p_variable ) ;
2765: EXCEPTION
2766: WHEN OTHERS THEN
2767: FND_FILE.put_line(FND_FILE.log, 'sql code : ' || SQLCODE );
2768: FND_FILE.put_line(FND_FILE.log, 'Challan Detail Error - ' || '. ERROR : ' || p_err );
2769:
2770: -- Harshita for Bug 4640996
2771: IF p_action <> 'V' THEN

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

2764: ln_check_number := to_number( p_variable ) ;
2765: EXCEPTION
2766: WHEN OTHERS THEN
2767: FND_FILE.put_line(FND_FILE.log, 'sql code : ' || SQLCODE );
2768: FND_FILE.put_line(FND_FILE.log, 'Challan Detail Error - ' || '. ERROR : ' || p_err );
2769:
2770: -- Harshita for Bug 4640996
2771: IF p_action <> 'V' THEN
2772: raise_application_error(-20023, 'Challan Detail Error - ' || '. ERROR : ' || p_err );

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

3867:
3868:
3869: IF NVL(p_period,'XX') = 'XX' THEN
3870: lv_etds_yearly_returns := 'Y' ;
3871: FND_FILE.put_line(FND_FILE.log, '~~~~Ver:619.1~~~~ Start of eTDS File Creation for Yearly Returns Batch_id->'||v_batch_id
3872: ||', Creation Date->'||to_char(SYSDATE,'dd-mon-yyyy hh24:mi:ss')||' ~~~~~~~~~~~~~~~~~~');
3873: ELSE
3874: lv_etds_yearly_returns := 'N' ;
3875: FND_FILE.put_line(FND_FILE.log, '~~~~Ver:115.6~~~~ Start of eTDS File Creation for Quarterly returns

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

3871: FND_FILE.put_line(FND_FILE.log, '~~~~Ver:619.1~~~~ Start of eTDS File Creation for Yearly Returns Batch_id->'||v_batch_id
3872: ||', Creation Date->'||to_char(SYSDATE,'dd-mon-yyyy hh24:mi:ss')||' ~~~~~~~~~~~~~~~~~~');
3873: ELSE
3874: lv_etds_yearly_returns := 'N' ;
3875: FND_FILE.put_line(FND_FILE.log, '~~~~Ver:115.6~~~~ Start of eTDS File Creation for Quarterly returns
3876: Batch_id->'||v_batch_id || 'Period : ' || p_period
3877: ||', Creation Date->'||to_char(SYSDATE,'dd-mon-yyyy hh24:mi:ss')||' ~~~~~~~~~~~~~~~~~~');
3878: END IF ;
3879:

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

3877: ||', Creation Date->'||to_char(SYSDATE,'dd-mon-yyyy hh24:mi:ss')||' ~~~~~~~~~~~~~~~~~~');
3878: END IF ;
3879:
3880: IF length(p_tan_number) > 10 THEN
3881: FND_FILE.put_line(FND_FILE.log, 'Tan Number length is greater than 10 characters');
3882: RAISE_APPLICATION_ERROR(-20014, 'Tan Number length is greater than 10 characters', true);
3883: END IF;
3884:
3885: INSERT INTO JAI_AP_ETDS_REQUESTS(

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

3913:
3914: END LOOP;
3915:
3916: IF v_deductor_pan IS NULL THEN
3917: FND_FILE.put_line(FND_FILE.log, 'Pan Number cannot be retreived based on given TAN Number');
3918: RAISE_APPLICATION_ERROR(-20015, 'Pan Number cannot be retreived based on given TAN Number', true);
3919: END IF;
3920:
3921:

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

3934: FETCH c_fin_year INTO v_start_date, v_end_date;
3935: CLOSE c_fin_year;
3936:
3937: IF v_start_date IS NULL OR v_end_date IS NULL THEN
3938: FND_FILE.put_line(FND_FILE.log, 'Cannot get values for Financial Year and Assessment Year');
3939: RAISE_APPLICATION_ERROR( -20016, 'Cannot get values for Financial Year and Assessment Year');
3940: END IF;
3941:
3942: -- Fetching Location linked to Input Organization from where address details are captured

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

3980: BEGIN
3981: jai_ap_tds_etds_pkg.openFile(p_file_path, p_filename);
3982: EXCEPTION
3983: WHEN OTHERS THEN
3984: FND_FILE.put_line(FND_FILE.log, 'Error Occured during opening of file(1):'||SQLERRM);
3985: RAISE_APPLICATION_ERROR(-20016, 'Error Occured(1):'||SQLERRM, true);
3986: END;
3987:
3988: IF p_action <> 'V' THEN

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

3985: RAISE_APPLICATION_ERROR(-20016, 'Error Occured(1):'||SQLERRM, true);
3986: END;
3987:
3988: IF p_action <> 'V' THEN
3989: FND_FILE.put_line(FND_FILE.log, 'Start File Header');
3990: END IF ;
3991:
3992: -- File Header (42 Chars)
3993: v_line_number := v_line_number + 1;

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

4106: FROM JAI_AP_ETDS_T
4107: WHERE batch_id = v_batch_id AND consider_for_deductee=1;
4108:
4109: IF p_action <> 'V' THEN
4110: FND_FILE.put_line(FND_FILE.log, 'Batch Header');
4111: END IF ;
4112:
4113: v_ack_num_tan_app := NULL;
4114: v_pro_rcpt_num_org_ret := nvl(p_pro_rcpt_num_org_ret,0);

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

4255: END IF ;
4256:
4257:
4258: IF p_action <> 'V' THEN
4259: FND_FILE.put_line(FND_FILE.log, 'Challan Detail');
4260: END IF ;
4261:
4262: -- Challan Details (60 Chars)
4263: v_record_type := 'CD';

Line 4291: FND_FILE.put_line(FND_FILE.log, 'cd.tds_section: '||cd.tds_section||' cd.challan_num: '||cd.challan_num|| ' cd.challan_date :' || cd.challan_date || 'cd.bank_branch_code' || cd.bank_branch_code || 'cd.check_number' || cd.check_number);

4287: IF cd.challan_num = 'No Challan Number' THEN
4288: cd.challan_num := null ;
4289: END IF ;
4290:
4291: FND_FILE.put_line(FND_FILE.log, 'cd.tds_section: '||cd.tds_section||' cd.challan_num: '||cd.challan_num|| ' cd.challan_date :' || cd.challan_date || 'cd.bank_branch_code' || cd.bank_branch_code || 'cd.check_number' || cd.check_number);
4292:
4293:
4294: --MODIFIED BY CSAHOO FOR BUG#6158875
4295: OPEN c_deductee_cnt(v_batch_id, cd.check_number, cd.tds_section,

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

4296: cd.challan_num, cd.challan_date,cd.bank_branch_code);
4297: FETCH c_deductee_cnt INTO v_q_deductee_cnt ;
4298: CLOSE c_deductee_cnt ;
4299:
4300: FND_FILE.put_line(FND_FILE.log, 'v_batch_id: '||v_batch_id||' v_q_deductee_cnt: '||v_q_deductee_cnt);
4301:
4302: IF p_action = 'H' THEN
4303: jai_ap_tds_etds_pkg.create_quarterly_cd;
4304: END IF ;

Line 4353: FND_FILE.put_line(FND_FILE.log, 'after validate_challan_detail');

4349: RETURN ;
4350: END IF ;
4351: END IF ;
4352:
4353: FND_FILE.put_line(FND_FILE.log, 'after validate_challan_detail');
4354:
4355: lv_generate_headers := null ;
4356: IF p_action <> 'V' THEN
4357: IF p_action = 'F' THEN

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

4427: and (( bank_branch_code IS NULL AND cd.bank_branch_code IS NULL ) OR ( bank_branch_code = cd.bank_branch_code )) --nvl(bank_branch_code, 'No Bank Branch') = nvl(cd.bank_branch_code, 'No Bank Branch')
4428: and consider_for_challan=1;
4429:
4430: IF p_action <> 'V' THEN
4431: FND_FILE.put_line(FND_FILE.log, 'Challan Line:'||v_line_number
4432: ||', tdsSec:' || cd.tds_section || ', ChlNum:' || cd.challan_num
4433: ||', ChlDate:'||cd.challan_date||', bankBr:'||cd.bank_branch_code
4434: );
4435: END IF ;

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

4453:
4454: IF lv_etds_yearly_returns= 'Y' THEN
4455: v_record_type := 'DD';
4456: IF p_action <> 'V' THEN
4457: FND_FILE.put_line(FND_FILE.log, 'Deductee Detail');
4458: -- Dedectee Details (338 Chars)
4459: v_record_type := 'DD';
4460: v_deductee_slno := 0;
4461: END IF;

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

4469: END IF ;
4470:
4471: IF p_action = 'V' THEN
4472:
4473: FND_FILE.put_line(FND_FILE.log,' LISTING THE ERRORS IN THIS BATCH ' );
4474: FND_FILE.put_line(FND_FILE.log,'-------------------------------------------------------------------- ' );
4475:
4476: ln_errors_exist := 0;
4477:

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

4470:
4471: IF p_action = 'V' THEN
4472:
4473: FND_FILE.put_line(FND_FILE.log,' LISTING THE ERRORS IN THIS BATCH ' );
4474: FND_FILE.put_line(FND_FILE.log,'-------------------------------------------------------------------- ' );
4475:
4476: ln_errors_exist := 0;
4477:
4478: FOR rec_get_errors IN c_get_errors(ln_batch_id)

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

4477:
4478: FOR rec_get_errors IN c_get_errors(ln_batch_id)
4479: LOOP
4480: ln_errors_exist := 1 ;
4481: FND_FILE.put_line(FND_FILE.log, rec_get_errors.Error_Message );
4482: END LOOP ;
4483:
4484: IF ln_errors_exist = 0 THEN
4485: FND_FILE.put_line(FND_FILE.log,' File Validation Successful. No Errors Found !! ' );

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

4481: FND_FILE.put_line(FND_FILE.log, rec_get_errors.Error_Message );
4482: END LOOP ;
4483:
4484: IF ln_errors_exist = 0 THEN
4485: FND_FILE.put_line(FND_FILE.log,' File Validation Successful. No Errors Found !! ' );
4486: END IF ;
4487:
4488: FND_FILE.put_line(FND_FILE.log,'-------------------------------------------------------------------- ' );
4489: FND_FILE.put_line(FND_FILE.log,' END OF ERRORS IN THIS BATCH ' );

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

4484: IF ln_errors_exist = 0 THEN
4485: FND_FILE.put_line(FND_FILE.log,' File Validation Successful. No Errors Found !! ' );
4486: END IF ;
4487:
4488: FND_FILE.put_line(FND_FILE.log,'-------------------------------------------------------------------- ' );
4489: FND_FILE.put_line(FND_FILE.log,' END OF ERRORS IN THIS BATCH ' );
4490:
4491: END IF ;
4492:

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

4485: FND_FILE.put_line(FND_FILE.log,' File Validation Successful. No Errors Found !! ' );
4486: END IF ;
4487:
4488: FND_FILE.put_line(FND_FILE.log,'-------------------------------------------------------------------- ' );
4489: FND_FILE.put_line(FND_FILE.log,' END OF ERRORS IN THIS BATCH ' );
4490:
4491: END IF ;
4492:
4493: jai_ap_tds_etds_pkg.closeFile;

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

4492:
4493: jai_ap_tds_etds_pkg.closeFile;
4494:
4495: IF p_action <> 'V' THEN
4496: FND_FILE.put_line(FND_FILE.log, '~~~~~~~~~~~~~~~ End of eTDS File Creation ~~~~~~~~~~~~~~~~~~');
4497: END IF ;
4498:
4499: /* Added by Ramananda for bug#4407165 */
4500: EXCEPTION