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 JAI_AP_TDS_ETDS_PKG

Line 1: PACKAGE BODY jai_ap_tds_etds_pkg AS

1: PACKAGE BODY jai_ap_tds_etds_pkg AS
2: /* $Header: jai_ap_tds_etds.plb 120.15.12010000.8 2008/11/20 09:12:41 bgowrava ship $ */
3:
4: /*---------------------------------------------------------------------------------------------------------
5: change history for jai_ap_tds_etds_pkg.sql

Line 5: change history for jai_ap_tds_etds_pkg.sql

1: PACKAGE BODY jai_ap_tds_etds_pkg AS
2: /* $Header: jai_ap_tds_etds.plb 120.15.12010000.8 2008/11/20 09:12:41 bgowrava ship $ */
3:
4: /*---------------------------------------------------------------------------------------------------------
5: change history for jai_ap_tds_etds_pkg.sql
6:
7: SlNo. DD/MM/YYYY Author and Details of Modifications
8: ----------------------------------------------------------------------------------------------------------
9: 1 22/03/2004 Vijay Shankar for Bug# 3463974, Version: 619.1

Line 3555: jai_ap_tds_etds_pkg.create_deductee_detail

3551:
3552: v_book_ent_oth := 'C';
3553:
3554: IF lv_etds_yearly_returns = 'Y' THEN -- Harshita for Bug 4525089
3555: jai_ap_tds_etds_pkg.create_deductee_detail
3556: (
3557: p_line_number => v_line_number,
3558: p_record_type => v_record_type,
3559: p_batch_number => v_batch_number,

Line 3601: jai_ap_tds_etds_pkg.validate_deductee_detail

3597:
3598: p_return_code := null ;
3599: p_return_message := null ;
3600:
3601: jai_ap_tds_etds_pkg.validate_deductee_detail
3602: ( p_line_number => v_line_number ,
3603: p_record_type => v_record_type ,
3604: p_batch_number => v_batch_number ,
3605: p_challan_line_num => dd.challan_line_num ,

Line 3640: jai_ap_tds_etds_pkg.create_quart_deductee_dtl

3636: ELSIF p_action = 'H' THEN
3637: lv_generate_headers := 'Y' ;
3638: END IF ;
3639:
3640: jai_ap_tds_etds_pkg.create_quart_deductee_dtl
3641: (
3642: p_line_number => v_line_number,
3643: p_record_type => v_record_type,
3644: p_batch_number => v_batch_number,

Line 3711: This procedure is created for enhancement to generate eTDS Flat file by making calls to jai_ap_tds_etds_pkg package

3707:
3708: SlNo. DD/MM/YYYY Author and Details of Modifications
3709: ---------------------------------------------------------------------------------------------------------------------------------
3710: 1 22/03/2004 Vijay Shankar for Bug# 3463974, Version: 619.1
3711: This procedure is created for enhancement to generate eTDS Flat file by making calls to jai_ap_tds_etds_pkg package
3712:
3713: 2 13/04/2004 Vijay Shankar for Bug# 3603545 (also fixed 3567864), Version: 619.2
3714: Fixed the issues
3715: deductee state code - Using lookup codes in FND_COMMON_LOOKUPS with lookup_type = 'IN_STATE'

Line 3776: 115.1 3708878 IN60105D2+3603545 jai_ap_tds_etds_pkg.sql Apdas 25/06/2004

3772: Current Version Current Bug Dependent Files Version Author Date Remarks
3773: Of File On Bug/Patchset Dependent On
3774: jai_ap_rpt_apcr_pkg.compute_credit_balance.sql
3775: ----------------------------------------------------------------------------------------------------------------------------------------------------
3776: 115.1 3708878 IN60105D2+3603545 jai_ap_tds_etds_pkg.sql Apdas 25/06/2004
3777:
3778: ---------------------------------------------------------------------------------------------------------------------------------------------------
3779:
3780: ---------------------------------------------------------------------------------------------------------------------------------*/

Line 3825: lv_object_name := 'jai_ap_tds_etds_pkg.generate_flat_file'; /* Added by Ramananda for bug#4407165 */

3821: v_certificate_issue_date := DUMMY ;
3822: v_dh_recHash := DUMMY ;
3823: lv_action := p_action ;
3824:
3825: lv_object_name := 'jai_ap_tds_etds_pkg.generate_flat_file'; /* Added by Ramananda for bug#4407165 */
3826:
3827:
3828: v_upload_type := 'R' ;
3829: v_file_creation_date := SYSDATE ;

Line 3860: jai_ap_tds_etds_pkg.v_debug_pad_char := ' ';

3856: SELECT JAI_AP_ETDS_T_S.nextval INTO v_batch_id FROM DUAL;
3857:
3858: IF NVL(p_action,'X') <> 'V' THEN
3859: IF NVL(p_generate_headers,'X') = 'Y' or NVL(p_action,'X') = 'H' THEN
3860: jai_ap_tds_etds_pkg.v_debug_pad_char := ' ';
3861: jai_ap_tds_etds_pkg.v_generate_headers := TRUE;
3862: ELSE
3863: jai_ap_tds_etds_pkg.v_debug_pad_char := '';
3864: jai_ap_tds_etds_pkg.v_generate_headers := FALSE;

Line 3861: jai_ap_tds_etds_pkg.v_generate_headers := TRUE;

3857:
3858: IF NVL(p_action,'X') <> 'V' THEN
3859: IF NVL(p_generate_headers,'X') = 'Y' or NVL(p_action,'X') = 'H' THEN
3860: jai_ap_tds_etds_pkg.v_debug_pad_char := ' ';
3861: jai_ap_tds_etds_pkg.v_generate_headers := TRUE;
3862: ELSE
3863: jai_ap_tds_etds_pkg.v_debug_pad_char := '';
3864: jai_ap_tds_etds_pkg.v_generate_headers := FALSE;
3865: END IF;

Line 3863: jai_ap_tds_etds_pkg.v_debug_pad_char := '';

3859: IF NVL(p_generate_headers,'X') = 'Y' or NVL(p_action,'X') = 'H' THEN
3860: jai_ap_tds_etds_pkg.v_debug_pad_char := ' ';
3861: jai_ap_tds_etds_pkg.v_generate_headers := TRUE;
3862: ELSE
3863: jai_ap_tds_etds_pkg.v_debug_pad_char := '';
3864: jai_ap_tds_etds_pkg.v_generate_headers := FALSE;
3865: END IF;
3866: END IF;
3867:

Line 3864: jai_ap_tds_etds_pkg.v_generate_headers := FALSE;

3860: jai_ap_tds_etds_pkg.v_debug_pad_char := ' ';
3861: jai_ap_tds_etds_pkg.v_generate_headers := TRUE;
3862: ELSE
3863: jai_ap_tds_etds_pkg.v_debug_pad_char := '';
3864: jai_ap_tds_etds_pkg.v_generate_headers := FALSE;
3865: END IF;
3866: END IF;
3867:
3868:

Line 3947: jai_ap_tds_etds_pkg.populate_details(

3943: OPEN c_location_linked_to_org(p_organization_id);
3944: FETCH c_location_linked_to_org INTO v_location_id;
3945: CLOSE c_location_linked_to_org;
3946:
3947: jai_ap_tds_etds_pkg.populate_details(
3948: v_batch_id,
3949: --p_legal_entity_id, -- Harshita for Bug 4889272
3950: p_tan_number,
3951: p_tax_authority_id,

Line 3981: jai_ap_tds_etds_pkg.openFile(p_file_path, p_filename);

3977: END;
3978: -- End, Vijay Shankar for Bug#4057192
3979:
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);

Line 3999: jai_ap_tds_etds_pkg.create_fh(v_batch_id);

3995: v_file_sequence_number := 1;
3996:
3997: IF lv_etds_yearly_returns = 'Y' THEN
3998: IF p_generate_headers = 'Y' THEN
3999: jai_ap_tds_etds_pkg.create_fh(v_batch_id);
4000: END IF;
4001:
4002: jai_ap_tds_etds_pkg.create_file_header(v_line_number, v_record_type, v_file_type, v_upload_type,
4003: v_file_creation_date, v_file_sequence_number, v_deductor_tan, v_number_of_batches);

Line 4002: jai_ap_tds_etds_pkg.create_file_header(v_line_number, v_record_type, v_file_type, v_upload_type,

3998: IF p_generate_headers = 'Y' THEN
3999: jai_ap_tds_etds_pkg.create_fh(v_batch_id);
4000: END IF;
4001:
4002: jai_ap_tds_etds_pkg.create_file_header(v_line_number, v_record_type, v_file_type, v_upload_type,
4003: v_file_creation_date, v_file_sequence_number, v_deductor_tan, v_number_of_batches);
4004: ELSE
4005: IF p_action = 'H' THEN
4006: jai_ap_tds_etds_pkg.create_quarterly_fh

Line 4006: jai_ap_tds_etds_pkg.create_quarterly_fh

4002: jai_ap_tds_etds_pkg.create_file_header(v_line_number, v_record_type, v_file_type, v_upload_type,
4003: v_file_creation_date, v_file_sequence_number, v_deductor_tan, v_number_of_batches);
4004: ELSE
4005: IF p_action = 'H' THEN
4006: jai_ap_tds_etds_pkg.create_quarterly_fh
4007: (v_batch_id,
4008: p_period,
4009: p_RespPers_flat_no, p_RespPers_prem_bldg, -- Bug 6030953
4010: p_RespPers_rd_st_lane, p_RespPers_area_loc, -- Bug 6030953

Line 4020: jai_ap_tds_etds_pkg.validate_file_header

4016:
4017: p_return_code := null ;
4018: p_return_message := null ;
4019:
4020: jai_ap_tds_etds_pkg.validate_file_header
4021: ( p_line_number => v_line_number ,
4022: p_record_type => v_record_type ,
4023: p_quartfile_type => v_quartfile_type,
4024: p_upload_type => v_upload_type,

Line 4059: jai_ap_tds_etds_pkg.create_quarterly_file_header

4055: ELSIF p_action = 'H' THEN
4056: lv_generate_headers := 'Y' ;
4057: END IF ;
4058:
4059: jai_ap_tds_etds_pkg.create_quarterly_file_header
4060: (
4061: p_line_number => v_line_number,
4062: p_record_type => v_record_type,
4063: p_file_type => v_quartfile_type,

Line 4119: jai_ap_tds_etds_pkg.create_bh;

4115:
4116: IF lv_etds_yearly_returns = 'Y' THEN
4117:
4118: IF p_generate_headers = 'Y' THEN
4119: jai_ap_tds_etds_pkg.create_bh;
4120: END IF;
4121:
4122: jai_ap_tds_etds_pkg.create_batch_header(v_line_number, v_record_type, v_batch_number,
4123: v_challan_cnt, v_deductee_cnt, v_form_number, v_rrr_number, v_rrr_date,

Line 4122: jai_ap_tds_etds_pkg.create_batch_header(v_line_number, v_record_type, v_batch_number,

4118: IF p_generate_headers = 'Y' THEN
4119: jai_ap_tds_etds_pkg.create_bh;
4120: END IF;
4121:
4122: jai_ap_tds_etds_pkg.create_batch_header(v_line_number, v_record_type, v_batch_number,
4123: v_challan_cnt, v_deductee_cnt, v_form_number, v_rrr_number, v_rrr_date,
4124: v_deductor_tan, v_deductor_pan, v_assessment_year, v_financial_year, v_deductor_name,
4125: v_tan_address1, v_tan_address2, v_tan_address3, v_tan_address4, v_tan_address5,
4126: v_tan_state_code, v_tan_pin, v_addrChangedSinceLastReturn, v_deductor_status,

Line 4133: jai_ap_tds_etds_pkg.create_quarterly_bh;

4129: );
4130:
4131: ELSE
4132: IF p_action = 'H' THEN
4133: jai_ap_tds_etds_pkg.create_quarterly_bh;
4134: END IF;
4135:
4136: p_return_code := null ;
4137: p_return_message := null ;

Line 4139: jai_ap_tds_etds_pkg.validate_batch_header

4135:
4136: p_return_code := null ;
4137: p_return_message := null ;
4138:
4139: jai_ap_tds_etds_pkg.validate_batch_header
4140: ( p_line_number => v_line_number ,
4141: p_record_type => v_record_type ,
4142: p_batch_number => v_batch_number ,
4143: p_challan_cnt => v_challan_cnt ,

Line 4197: jai_ap_tds_etds_pkg.create_quarterly_batch_header

4193: ELSIF p_action = 'H' THEN
4194: lv_generate_headers := 'Y' ;
4195: END IF ;
4196:
4197: jai_ap_tds_etds_pkg.create_quarterly_batch_header
4198: (
4199: p_line_number => v_line_number,
4200: p_record_type => v_record_type,
4201: p_batch_number => v_batch_number,

Line 4266: jai_ap_tds_etds_pkg.create_cd;

4262: -- Challan Details (60 Chars)
4263: v_record_type := 'CD';
4264: IF lv_etds_yearly_returns = 'Y' THEN
4265: IF p_generate_headers = 'Y' THEN
4266: jai_ap_tds_etds_pkg.create_cd;
4267: END IF;
4268: END IF;
4269:
4270: v_challan_dtl_slno := 0;

Line 4283: jai_ap_tds_etds_pkg.create_challan_detail(v_line_number, v_record_type, v_batch_number, v_challan_dtl_slno,

4279: cd.challan_date := to_date(null) ;
4280: END IF ;
4281:
4282: IF lv_etds_yearly_returns = 'Y' THEN -- Harshita for Bug 4525089
4283: jai_ap_tds_etds_pkg.create_challan_detail(v_line_number, v_record_type, v_batch_number, v_challan_dtl_slno,
4284: cd.tds_section, cd.tds_amount, cd.challan_num, cd.challan_date, cd.bank_branch_code
4285: );
4286: ELSE
4287: IF cd.challan_num = 'No Challan Number' THEN

Line 4303: jai_ap_tds_etds_pkg.create_quarterly_cd;

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 ;
4305:
4306: v_total_deposit := cd.amt_of_tds + cd.amt_of_surcharge + cd.amt_of_cess;
4307:

Line 4317: jai_ap_tds_etds_pkg.validate_challan_detail

4313:
4314: p_return_code := null ;
4315: p_return_message := null ;
4316:
4317: jai_ap_tds_etds_pkg.validate_challan_detail
4318: (
4319: p_line_number => v_line_number ,
4320: p_record_type => v_record_type ,
4321: p_batch_number => v_batch_number ,

Line 4365: jai_ap_tds_etds_pkg.create_quart_challan_dtl

4361: END IF ;
4362:
4363: ln_amt_of_tds := cd.tds_amount - round(cd.amt_of_surcharge) - round(cd.amt_of_cess) - round(ln_amt_of_oth) - round(ln_amt_of_oth) ;
4364:
4365: jai_ap_tds_etds_pkg.create_quart_challan_dtl
4366: (
4367: p_line_number => v_line_number,
4368: p_record_type => v_record_type,
4369: p_batch_number => v_batch_number,

Line 4443: jai_ap_tds_etds_pkg.create_quarterly_dd;

4439: v_record_type := 'DD';
4440: v_challan_line_num := v_line_number ;
4441:
4442: IF p_action = 'H' THEN
4443: jai_ap_tds_etds_pkg.create_quarterly_dd;
4444: END IF;
4445:
4446: v_deductee_slno := 0 ;
4447: process_deductee_records ; -- internal procedure call

Line 4464: jai_ap_tds_etds_pkg.create_dd;

4460: v_deductee_slno := 0;
4461: END IF;
4462:
4463: IF p_generate_headers = 'Y' THEN
4464: jai_ap_tds_etds_pkg.create_dd;
4465: END IF;
4466:
4467: v_challan_line_num := null ;
4468: process_deductee_records ;

Line 4493: jai_ap_tds_etds_pkg.closeFile;

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;
4494:
4495: IF p_action <> 'V' THEN
4496: FND_FILE.put_line(FND_FILE.log, '~~~~~~~~~~~~~~~ End of eTDS File Creation ~~~~~~~~~~~~~~~~~~');
4497: END IF ;

Line 4513: END jai_ap_tds_etds_pkg;

4509:
4510: -- ended, Harshita for 5096787
4511:
4512:
4513: END jai_ap_tds_etds_pkg;