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.74.12020000.18 2013/06/04 04:54:58 cholei 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.74.12020000.18 2013/06/04 04:54:58 cholei 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 244: G_PKG_NAME CONSTANT VARCHAR2(30) := 'JAI_AP_TDS_ETDS_PKG';

240:
241: 45. 10-Dec-2012 amandali for ER 15840480
242: Description:FVU3.6 Uptake
243: ---------------------------------------------------------------------------------------------------------*/
244: G_PKG_NAME CONSTANT VARCHAR2(30) := 'JAI_AP_TDS_ETDS_PKG';
245: G_MSG_UERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR;
246: G_MSG_ERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR;
247: G_MSG_SUCCESS CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_SUCCESS;
248: G_MSG_HIGH CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH;

Line 259: G_MODULE_NAME CONSTANT VARCHAR2(40) := 'JAI.PLSQL.JAI_AP_TDS_ETDS_PKG.';

255: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
256: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
257: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
258: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
259: G_MODULE_NAME CONSTANT VARCHAR2(40) := 'JAI.PLSQL.JAI_AP_TDS_ETDS_PKG.';
260: G_INVOICE_VALIDATE CONSTANT VARCHAR2(40) := 'INVOICE VALIDATE';
261: G_PREPAYMENT_APPLICATION CONSTANT VARCHAR2(40) := 'PREPAYMENT APPLICATION';
262: G_PREPAYMENT_UNAPPLICATION CONSTANT VARCHAR2(40) := 'PREPAYMENT UNAPPLICATION';
263: G_THRESHOLD_TRANSITION CONSTANT VARCHAR2(40) := 'THRESHOLD TRANSITION';

Line 1648: \* Bug 5721614. Code migration by Xiao Lv from jai_ap_tds_etds_pkg.sql with version 115.26.6307.8

1644: and c.tds_event like '%THRESHOLD%'
1645: ) ;
1646: -- end 5647248
1647: *\
1648: \* Bug 5721614. Code migration by Xiao Lv from jai_ap_tds_etds_pkg.sql with version 115.26.6307.8
1649: * Commented the above and added the below.
1650: * Updates records which are available in
1651: * jai_ap_tds_thhold_trxs *\
1652:

Line 2367: /* Bug 5721614. Code migration by Xiao Lv from jai_ap_tds_etds_pkg.sql with version 115.26.6307.8

2363: and c.tds_event like '%THRESHOLD%'
2364: ) ;
2365: -- end 5647248
2366: */
2367: /* Bug 5721614. Code migration by Xiao Lv from jai_ap_tds_etds_pkg.sql with version 115.26.6307.8
2368: * Commented the above and added the below.
2369: * Updates records which are available in
2370: * jai_ap_tds_thhold_trxs */
2371:

Line 5820: jai_ap_tds_etds_pkg.create_deductee_detail

5816: /*Bug 11896260 - End*/
5817: v_book_ent_oth := 'C';
5818:
5819: IF lv_etds_yearly_returns = 'Y' THEN -- Harshita for Bug 4525089
5820: jai_ap_tds_etds_pkg.create_deductee_detail
5821: (
5822: p_line_number => v_line_number,
5823: p_record_type => v_record_type,
5824: p_batch_number => v_batch_number,

Line 5867: jai_ap_tds_etds_pkg.validate_deductee_detail

5863:
5864: p_return_code := null ;
5865: p_return_message := null ;
5866:
5867: jai_ap_tds_etds_pkg.validate_deductee_detail
5868: ( p_line_number => v_line_number ,
5869: p_record_type => v_record_type ,
5870: p_batch_number => v_batch_number ,
5871: p_challan_line_num => dd.challan_line_num ,

Line 5921: jai_ap_tds_etds_pkg.create_quart_deductee_dtl

5917: ELSE
5918: ld_tds_inv_date := dd.tds_invoice_date;
5919: END IF;
5920: /*ER 13514846 - End*/
5921: jai_ap_tds_etds_pkg.create_quart_deductee_dtl
5922: (
5923: p_line_number => v_line_number,
5924: p_record_type => v_record_type,
5925: p_batch_number => v_batch_number,

Line 6082: jai_ap_tds_etds_pkg.create_deductee_detail(v_line_number, v_record_type,

6078:
6079: v_book_ent_oth := 'C';
6080:
6081: IF lv_etds_yearly_returns = 'Y' THEN
6082: jai_ap_tds_etds_pkg.create_deductee_detail(v_line_number, v_record_type,
6083: v_batch_number, v_deductee_slno, dd_t.tds_section, v_deductee_code,
6084: v_deductee_pan, v_vendor_name, v_site_dtls.addr1, v_site_dtls.addr2,
6085: v_site_dtls.addr3, v_site_dtls.addr4, v_site_dtls.city,
6086: v_deductee_state_code, v_site_dtls.zip, v_filler, dd_t.base_taxabale_amount,

Line 6116: jai_ap_tds_etds_pkg.create_quart_deductee_dtl

6112: ELSE
6113: ln_ded_tax_rate := dd_t.tds_tax_rate;
6114: END IF;
6115: /*Bug 11896260 - End*/
6116: jai_ap_tds_etds_pkg.create_quart_deductee_dtl
6117: (
6118: p_line_number => v_line_number,
6119: p_record_type => v_record_type,
6120: p_batch_number => v_batch_number,

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

6191:
6192: SlNo. DD/MM/YYYY Author and Details of Modifications
6193: ---------------------------------------------------------------------------------------------------------------------------------
6194: 1 22/03/2004 Vijay Shankar for Bug# 3463974, Version: 619.1
6195: This procedure is created for enhancement to generate eTDS Flat file by making calls to jai_ap_tds_etds_pkg package
6196:
6197: 2 13/04/2004 Vijay Shankar for Bug# 3603545 (also fixed 3567864), Version: 619.2
6198: Fixed the issues
6199: deductee state code - Using lookup codes in FND_COMMON_LOOKUPS with lookup_type = 'IN_STATE'

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

6256: Current Version Current Bug Dependent Files Version Author Date Remarks
6257: Of File On Bug/Patchset Dependent On
6258: jai_ap_rpt_apcr_pkg.compute_credit_balance.sql
6259: ----------------------------------------------------------------------------------------------------------------------------------------------------
6260: 115.1 3708878 IN60105D2+3603545 jai_ap_tds_etds_pkg.sql Apdas 25/06/2004
6261:
6262: ---------------------------------------------------------------------------------------------------------------------------------------------------
6263:
6264: ---------------------------------------------------------------------------------------------------------------------------------*/

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

6314: v_certificate_issue_date := DUMMY ;
6315: v_dh_recHash := DUMMY ;
6316: lv_action := p_action ;
6317:
6318: lv_object_name := 'jai_ap_tds_etds_pkg.generate_flat_file'; /* Added by Ramananda for bug#4407165 */
6319:
6320:
6321: v_upload_type := 'R' ;
6322: v_file_creation_date := SYSDATE ;

Line 6352: jai_ap_tds_etds_pkg.v_debug_pad_char := ' ';

6348: SELECT JAI_AP_ETDS_T_S.nextval INTO v_batch_id FROM DUAL;
6349:
6350: IF NVL(p_action,'X') <> 'V' THEN
6351: IF NVL(p_generate_headers,'X') = 'Y' or NVL(p_action,'X') = 'H' THEN
6352: jai_ap_tds_etds_pkg.v_debug_pad_char := ' ';
6353: jai_ap_tds_etds_pkg.v_generate_headers := TRUE;
6354: ELSE
6355: jai_ap_tds_etds_pkg.v_debug_pad_char := '';
6356: jai_ap_tds_etds_pkg.v_generate_headers := FALSE;

Line 6353: jai_ap_tds_etds_pkg.v_generate_headers := TRUE;

6349:
6350: IF NVL(p_action,'X') <> 'V' THEN
6351: IF NVL(p_generate_headers,'X') = 'Y' or NVL(p_action,'X') = 'H' THEN
6352: jai_ap_tds_etds_pkg.v_debug_pad_char := ' ';
6353: jai_ap_tds_etds_pkg.v_generate_headers := TRUE;
6354: ELSE
6355: jai_ap_tds_etds_pkg.v_debug_pad_char := '';
6356: jai_ap_tds_etds_pkg.v_generate_headers := FALSE;
6357: END IF;

Line 6355: jai_ap_tds_etds_pkg.v_debug_pad_char := '';

6351: IF NVL(p_generate_headers,'X') = 'Y' or NVL(p_action,'X') = 'H' THEN
6352: jai_ap_tds_etds_pkg.v_debug_pad_char := ' ';
6353: jai_ap_tds_etds_pkg.v_generate_headers := TRUE;
6354: ELSE
6355: jai_ap_tds_etds_pkg.v_debug_pad_char := '';
6356: jai_ap_tds_etds_pkg.v_generate_headers := FALSE;
6357: END IF;
6358: END IF;
6359:

Line 6356: jai_ap_tds_etds_pkg.v_generate_headers := FALSE;

6352: jai_ap_tds_etds_pkg.v_debug_pad_char := ' ';
6353: jai_ap_tds_etds_pkg.v_generate_headers := TRUE;
6354: ELSE
6355: jai_ap_tds_etds_pkg.v_debug_pad_char := '';
6356: jai_ap_tds_etds_pkg.v_generate_headers := FALSE;
6357: END IF;
6358: END IF;
6359:
6360:

Line 6519: jai_ap_tds_etds_pkg.populate_details(

6515: CLOSE c_location_linked_to_org;
6516:
6517: for org in c_organization_id(p_tan_number, p_organization_id)
6518: loop
6519: jai_ap_tds_etds_pkg.populate_details(
6520: v_batch_id,
6521: p_tan_number,
6522: p_tax_authority_id,
6523: p_tax_authority_site_id,

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

6553: END;
6554: -- End, Vijay Shankar for Bug#4057192
6555:
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);

Line 6577: jai_ap_tds_etds_pkg.create_fh(v_batch_id);

6573:
6574:
6575: IF lv_etds_yearly_returns = 'Y' THEN
6576: IF p_generate_headers = 'Y' THEN
6577: jai_ap_tds_etds_pkg.create_fh(v_batch_id);
6578: END IF;
6579:
6580: jai_ap_tds_etds_pkg.create_file_header(v_line_number, v_record_type, v_file_type, v_upload_type,
6581: v_file_creation_date, v_file_sequence_number, v_deductor_tan, v_number_of_batches);

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

6576: IF p_generate_headers = 'Y' THEN
6577: jai_ap_tds_etds_pkg.create_fh(v_batch_id);
6578: END IF;
6579:
6580: jai_ap_tds_etds_pkg.create_file_header(v_line_number, v_record_type, v_file_type, v_upload_type,
6581: v_file_creation_date, v_file_sequence_number, v_deductor_tan, v_number_of_batches);
6582: ELSE
6583: IF p_action = 'H' THEN
6584: jai_ap_tds_etds_pkg.create_quarterly_fh

Line 6584: jai_ap_tds_etds_pkg.create_quarterly_fh

6580: jai_ap_tds_etds_pkg.create_file_header(v_line_number, v_record_type, v_file_type, v_upload_type,
6581: v_file_creation_date, v_file_sequence_number, v_deductor_tan, v_number_of_batches);
6582: ELSE
6583: IF p_action = 'H' THEN
6584: jai_ap_tds_etds_pkg.create_quarterly_fh
6585: (v_batch_id,
6586: p_period,
6587: p_RespPers_flat_no, p_RespPers_prem_bldg, -- Bug 6030953
6588: p_RespPers_rd_st_lane, p_RespPers_area_loc, -- Bug 6030953

Line 6598: jai_ap_tds_etds_pkg.validate_file_header

6594:
6595: p_return_code := null ;
6596: p_return_message := null ;
6597:
6598: jai_ap_tds_etds_pkg.validate_file_header
6599: ( p_line_number => v_line_number ,
6600: p_record_type => v_record_type ,
6601: p_quartfile_type => v_quartfile_type,
6602: p_upload_type => v_upload_type,

Line 6638: jai_ap_tds_etds_pkg.create_quarterly_file_header

6634: ELSIF p_action = 'H' THEN
6635: lv_generate_headers := 'Y' ;
6636: END IF ;
6637:
6638: jai_ap_tds_etds_pkg.create_quarterly_file_header
6639: (
6640: p_line_number => v_line_number,
6641: p_record_type => v_record_type,
6642: p_file_type => v_quartfile_type,

Line 6721: jai_ap_tds_etds_pkg.create_bh;

6717:
6718: IF lv_etds_yearly_returns = 'Y' THEN
6719:
6720: IF p_generate_headers = 'Y' THEN
6721: jai_ap_tds_etds_pkg.create_bh;
6722: END IF;
6723:
6724: jai_ap_tds_etds_pkg.create_batch_header(v_line_number, v_record_type, v_batch_number,
6725: v_challan_cnt, v_deductee_cnt, v_form_number, v_rrr_number, v_rrr_date,

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

6720: IF p_generate_headers = 'Y' THEN
6721: jai_ap_tds_etds_pkg.create_bh;
6722: END IF;
6723:
6724: jai_ap_tds_etds_pkg.create_batch_header(v_line_number, v_record_type, v_batch_number,
6725: v_challan_cnt, v_deductee_cnt, v_form_number, v_rrr_number, v_rrr_date,
6726: v_deductor_tan, v_deductor_pan, v_assessment_year, v_financial_year, v_deductor_name,
6727: v_tan_address1, v_tan_address2, v_tan_address3, v_tan_address4, v_tan_address5,
6728: v_tan_state_code, v_tan_pin, v_addrChangedSinceLastReturn, v_deductor_type, /*Bug 8880543 - Modified Deductor Status to Deductor Type*/

Line 6735: jai_ap_tds_etds_pkg.create_quarterly_bh;

6731: );
6732:
6733: ELSE
6734: IF p_action = 'H' THEN
6735: jai_ap_tds_etds_pkg.create_quarterly_bh;
6736: END IF;
6737:
6738: p_return_code := null ;
6739: p_return_message := null ;

Line 6742: jai_ap_tds_etds_pkg.validate_batch_header

6738: p_return_code := null ;
6739: p_return_message := null ;
6740:
6741:
6742: jai_ap_tds_etds_pkg.validate_batch_header
6743: ( p_line_number => v_line_number ,
6744: p_record_type => v_record_type ,
6745: p_batch_number => v_batch_number ,
6746: p_challan_cnt => v_challan_cnt ,

Line 6812: jai_ap_tds_etds_pkg.create_quarterly_batch_header

6808: ELSIF p_action = 'H' THEN
6809: lv_generate_headers := 'Y' ;
6810: END IF ;
6811: --v_bh_unmatch_challan_cnt := 'NA';/*Bug-11781966*/
6812: jai_ap_tds_etds_pkg.create_quarterly_batch_header
6813: (
6814: p_line_number => v_line_number,
6815: p_record_type => v_record_type,
6816: p_batch_number => v_batch_number,

Line 6893: jai_ap_tds_etds_pkg.create_cd;

6889: -- Challan Details (60 Chars)
6890: v_record_type := 'CD';
6891: IF lv_etds_yearly_returns = 'Y' THEN
6892: IF p_generate_headers = 'Y' THEN
6893: jai_ap_tds_etds_pkg.create_cd;
6894: END IF;
6895: END IF;
6896:
6897: v_challan_dtl_slno := 0;

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

6909: IF cd.tds_vendor_classification is null THEN /*Bug 10315928 */
6910: v_check_number := 0;--cd.check_number;/* modified from cd.check_number to 0 for Bug 13323753 */
6911: v_nil_challan_indicator := 'N' ; /*10408793 - Nil Challan indicator is N is tax is present*/
6912: IF lv_etds_yearly_returns = 'Y' THEN -- Harshita for Bug 4525089
6913: jai_ap_tds_etds_pkg.create_challan_detail(v_line_number, v_record_type, v_batch_number, v_challan_dtl_slno,
6914: cd.tds_section, cd.tds_amount, cd.challan_num, cd.challan_date, cd.bank_branch_code
6915: );
6916: ELSE
6917: IF cd.challan_num = 'No Challan Number' THEN

Line 6942: jai_ap_tds_etds_pkg.create_quarterly_cd;

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 ;
6944:
6945: v_total_deposit := nvl(cd.amt_of_tds, 0) + nvl(cd.amt_of_surcharge, 0) + nvl(cd.amt_of_cess, 0);/*ETDS FVU3.1 Bug 11896260*/
6946: /* ER : 13514846 - Nil Challan Indicator to be marked 'Y' for Zero Rate Invoices

Line 6967: jai_ap_tds_etds_pkg.validate_challan_detail

6963: p_return_code := null ;
6964: p_return_message := null ;
6965:
6966:
6967: jai_ap_tds_etds_pkg.validate_challan_detail
6968: (
6969: p_line_number => v_line_number ,
6970: p_record_type => v_record_type ,
6971: p_batch_number => v_batch_number ,

Line 7030: jai_ap_tds_etds_pkg.create_quart_challan_dtl

7026: END IF;
7027: /*Bug 8880543 - Challan Number to be used only if deductor type is not A or S - End*/
7028:
7029:
7030: jai_ap_tds_etds_pkg.create_quart_challan_dtl
7031: (
7032: p_line_number => v_line_number,
7033: p_record_type => v_record_type,
7034: p_batch_number => v_batch_number,

Line 7110: jai_ap_tds_etds_pkg.create_quarterly_dd;

7106: v_record_type := 'DD';
7107: v_challan_line_num := v_line_number ;
7108:
7109: IF p_action = 'H' THEN
7110: jai_ap_tds_etds_pkg.create_quarterly_dd;
7111: END IF;
7112:
7113: v_deductee_slno := 0 ;
7114: process_deductee_records ; -- internal procedure call

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

7135: --Changed by Zhiwei for Bug#15840480 FVU3.6 end
7136:
7137: IF lv_etds_yearly_returns = 'Y' THEN
7138:
7139: jai_ap_tds_etds_pkg.create_challan_detail(v_line_number, v_record_type, v_batch_number, v_challan_dtl_slno,
7140: cd.tds_section, cd.tds_amount, cd.challan_num, cd.challan_date, cd.bank_branch_code
7141: );
7142:
7143: ELSE

Line 7166: jai_ap_tds_etds_pkg.create_quarterly_cd;

7162: CLOSE c_deductee_cnt_trans ;
7163:
7164:
7165: IF p_action = 'H' THEN
7166: jai_ap_tds_etds_pkg.create_quarterly_cd;
7167: END IF ;
7168:
7169: v_total_deposit := nvl(cd.amt_of_tds, 0) + nvl(cd.amt_of_surcharge, 0) + nvl(cd.amt_of_cess, 0);/*ETDS FVU3.1 Bug 11896260*/
7170:

Line 7179: jai_ap_tds_etds_pkg.validate_challan_detail

7175: END IF ;
7176: v_nil_challan_indicator := 'Y' ;/*Bug 10315928*/
7177: p_return_code := null ;
7178: p_return_message := null ;
7179: jai_ap_tds_etds_pkg.validate_challan_detail
7180: (
7181: p_line_number => v_line_number ,
7182: p_record_type => v_record_type ,
7183: p_batch_number => v_batch_number ,

Line 7241: jai_ap_tds_etds_pkg.create_quart_challan_dtl

7237: ld_challan_date := derive_challan_date;
7238: ELSE
7239: ld_challan_date := cd.challan_date;
7240: END IF;
7241: jai_ap_tds_etds_pkg.create_quart_challan_dtl
7242: (
7243: p_line_number => v_line_number,
7244: p_record_type => v_record_type,
7245: p_batch_number => v_batch_number,

Line 7319: jai_ap_tds_etds_pkg.create_quarterly_dd;

7315: v_record_type := 'DD';
7316: v_challan_line_num := v_line_number ;
7317:
7318: IF p_action = 'H' THEN
7319: jai_ap_tds_etds_pkg.create_quarterly_dd;
7320: END IF;
7321:
7322: v_deductee_slno := 0 ;
7323:

Line 7363: jai_ap_tds_etds_pkg.create_dd;

7359: v_deductee_slno := 0;
7360: END IF;
7361:
7362: IF p_generate_headers = 'Y' THEN
7363: jai_ap_tds_etds_pkg.create_dd;
7364: END IF;
7365:
7366: v_challan_line_num := null ;
7367: process_deductee_records ;

Line 7392: jai_ap_tds_etds_pkg.closeFile;

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;
7393:
7394: IF p_action <> 'V' THEN
7395: FND_FILE.put_line(FND_FILE.log, '~~~~~~~~~~~~~~~ End of eTDS File Creation ~~~~~~~~~~~~~~~~~~');
7396: END IF ;

Line 7459: END jai_ap_tds_etds_pkg;

7455:
7456: -- ended, Harshita for 5096787
7457:
7458:
7459: END jai_ap_tds_etds_pkg;