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_ETCS_PKG dependencies on JAI_CONSTANTS

Line 23: constants jai_constants.ar_cash_tax_confirmed and jai_constants.trx_type_inv_comp

19: Column name org_tan_num is renamed to org_tan_no. So the change is propogated into this
20: package.
21: File name changed to jai_ar_etcs_prc.plb
22: Removed the Hard Coded values and replaced them with the
23: constants jai_constants.ar_cash_tax_confirmed and jai_constants.trx_type_inv_comp
24: 2. 14/05/2007 bduvarag for bug#5631784. File Version 120.1
25: Removed local_fnd_global
26:
27: 3. 26.06.2007 sacsethi for bug 6153881 file version 120.2

Line 48: 5. In File jai_constants.pls - Two variable is used pan_no , accounting_information to Avoid Hard coding of these information.

44:
45: Problem - Table used under this cursor has been obsuleted in R12
46: we should not use ap_check_all , ap_bank_branches etc.
47:
48: 5. In File jai_constants.pls - Two variable is used pan_no , accounting_information to Avoid Hard coding of these information.
49:
50: 4. 03/07/2007 sacsethi for bug 6157120 File version 120.6
51:
52: R12RUP03-ST1:ETCS REPORT RUNS INTO ERROR

Line 1927: and source_document_type IN (jai_constants.ar_cash_tax_confirmed , jai_constants.trx_type_inv_comp)

1923: is
1924: select source_document_type
1925: from jai_rgm_refs_all
1926: where source_document_id = cp_source_ref_id
1927: and source_document_type IN (jai_constants.ar_cash_tax_confirmed , jai_constants.trx_type_inv_comp)
1928: and rownum = 1 ;
1929:
1930: Cursor c_inv_date(cp_inv_id number)
1931: is

Line 2053: open c_tax_amount(jai_constants.tax_type_tcs,rec.source_document_id, rec.tcs_check_id ) ;

2049: open c_line_amt(rec.source_document_id, rec.tcs_check_id) ;
2050: fetch c_line_amt into ln_line_amt ;
2051: close c_line_amt ;
2052:
2053: open c_tax_amount(jai_constants.tax_type_tcs,rec.source_document_id, rec.tcs_check_id ) ;
2054: fetch c_tax_amount into ln_tcs_amount ;
2055: close c_tax_amount ;
2056:
2057: open c_tax_amount(jai_constants.tax_type_tcs_surcharge, rec.source_document_id, rec.tcs_check_id ) ;

Line 2057: open c_tax_amount(jai_constants.tax_type_tcs_surcharge, rec.source_document_id, rec.tcs_check_id ) ;

2053: open c_tax_amount(jai_constants.tax_type_tcs,rec.source_document_id, rec.tcs_check_id ) ;
2054: fetch c_tax_amount into ln_tcs_amount ;
2055: close c_tax_amount ;
2056:
2057: open c_tax_amount(jai_constants.tax_type_tcs_surcharge, rec.source_document_id, rec.tcs_check_id ) ;
2058: fetch c_tax_amount into ln_surcharge_amount ;
2059: close c_tax_amount ;
2060:
2061: open c_tax_amount(jai_constants.tax_type_tcs_cess, rec.source_document_id, rec.tcs_check_id ) ;

Line 2061: open c_tax_amount(jai_constants.tax_type_tcs_cess, rec.source_document_id, rec.tcs_check_id ) ;

2057: open c_tax_amount(jai_constants.tax_type_tcs_surcharge, rec.source_document_id, rec.tcs_check_id ) ;
2058: fetch c_tax_amount into ln_surcharge_amount ;
2059: close c_tax_amount ;
2060:
2061: open c_tax_amount(jai_constants.tax_type_tcs_cess, rec.source_document_id, rec.tcs_check_id ) ;
2062: fetch c_tax_amount into ln_tcs_cess_amount ;
2063: close c_tax_amount ;
2064:
2065: open c_tax_amount(jai_constants.tax_type_tcs_surcharge_cess, rec.source_document_id, rec.tcs_check_id ) ;

Line 2065: open c_tax_amount(jai_constants.tax_type_tcs_surcharge_cess, rec.source_document_id, rec.tcs_check_id ) ;

2061: open c_tax_amount(jai_constants.tax_type_tcs_cess, rec.source_document_id, rec.tcs_check_id ) ;
2062: fetch c_tax_amount into ln_tcs_cess_amount ;
2063: close c_tax_amount ;
2064:
2065: open c_tax_amount(jai_constants.tax_type_tcs_surcharge_cess, rec.source_document_id, rec.tcs_check_id ) ;
2066: fetch c_tax_amount into ln_sur_cess_amount ;
2067: close c_tax_amount ;
2068:
2069: -- Date 03/07/2007 by sacsethi for bug 6157120

Line 2071: open c_tax_amount(jai_constants.tax_type_sh_tcs_edu_cess, rec.source_document_id, rec.tcs_check_id ) ;

2067: close c_tax_amount ;
2068:
2069: -- Date 03/07/2007 by sacsethi for bug 6157120
2070:
2071: open c_tax_amount(jai_constants.tax_type_sh_tcs_edu_cess, rec.source_document_id, rec.tcs_check_id ) ;
2072: fetch c_tax_amount into ln_tcs_sh_cess_amount ;
2073: close c_tax_amount ;
2074:
2075: ln_cess_amount := ln_tcs_cess_amount + ln_sur_cess_amount + ln_tcs_sh_cess_amount ; -- Date 03/07/2007 by sacsethi for bug 6157120

Line 2093: IF lv_source_ref_type = jai_constants.trx_type_inv_comp THEN

2089: close c_source_ref_type ;
2090:
2091: lv_source_ref_type := substr(lv_source_ref_type, 1,50);
2092:
2093: IF lv_source_ref_type = jai_constants.trx_type_inv_comp THEN
2094: open c_inv_date(rec.source_document_id) ;
2095: fetch c_inv_date into lv_doc_date ;
2096: close c_inv_date ;
2097: ELSIF lv_source_ref_type = jai_constants.ar_cash_tax_confirmed THEN

Line 2097: ELSIF lv_source_ref_type = jai_constants.ar_cash_tax_confirmed THEN

2093: IF lv_source_ref_type = jai_constants.trx_type_inv_comp THEN
2094: open c_inv_date(rec.source_document_id) ;
2095: fetch c_inv_date into lv_doc_date ;
2096: close c_inv_date ;
2097: ELSIF lv_source_ref_type = jai_constants.ar_cash_tax_confirmed THEN
2098: open c_rcpt_date(rec.source_document_id) ;
2099: fetch c_rcpt_date into lv_doc_date ;
2100: close c_rcpt_date ;
2101: END IF ;

Line 2173: where jrorv.attribute_code = jai_constants.pan_no AND

2169:
2170: CURSOR c_pan_number(p_organization_id IN NUMBER) IS
2171: Select ATTRIBUTE_VALUE
2172: from jai_rgm_org_regns_v jrorv ,HR_ORGANIZATION_INFORMATION hrou
2173: where jrorv.attribute_code = jai_constants.pan_no AND
2174: hrou.org_information_context= jai_constants.accounting_information and
2175: hrou.organization_id = p_organization_id and
2176: jrorv.ORGANIZATION_ID = hrou.org_information3 AND
2177: jrorv.REGIME_CODE = jai_constants.tds_regime ;

Line 2174: hrou.org_information_context= jai_constants.accounting_information and

2170: CURSOR c_pan_number(p_organization_id IN NUMBER) IS
2171: Select ATTRIBUTE_VALUE
2172: from jai_rgm_org_regns_v jrorv ,HR_ORGANIZATION_INFORMATION hrou
2173: where jrorv.attribute_code = jai_constants.pan_no AND
2174: hrou.org_information_context= jai_constants.accounting_information and
2175: hrou.organization_id = p_organization_id and
2176: jrorv.ORGANIZATION_ID = hrou.org_information3 AND
2177: jrorv.REGIME_CODE = jai_constants.tds_regime ;
2178: /*

Line 2177: jrorv.REGIME_CODE = jai_constants.tds_regime ;

2173: where jrorv.attribute_code = jai_constants.pan_no AND
2174: hrou.org_information_context= jai_constants.accounting_information and
2175: hrou.organization_id = p_organization_id and
2176: jrorv.ORGANIZATION_ID = hrou.org_information3 AND
2177: jrorv.REGIME_CODE = jai_constants.tds_regime ;
2178: /*
2179: SELECT attribute2
2180: FROM hr_all_organization_units
2181: WHERE organization_id = p_organization_id;*/

Line 2611: p_ret_code := jai_constants.request_error ;

2607: INSERT INTO jai_ap_etds_errors_t
2608: (batch_id, record_type, reference_id, error_message) VALUES
2609: ( ln_batch_id,'DD', v_line_number, p_return_message ) ;
2610: ELSE
2611: p_ret_code := jai_constants.request_error ;
2612: p_err_buf := p_return_message ;
2613: RETURN ;
2614: END IF ;
2615: END IF ;

Line 2868: p_ret_code := jai_constants.request_error ;

2864: INSERT INTO jai_ap_etds_errors_t
2865: (batch_id, record_type, error_message) values
2866: ( ln_batch_id, 'FH', p_return_message ) ;
2867: ELSE
2868: p_ret_code := jai_constants.request_error ;
2869: p_err_buf := p_return_message ;
2870: RETURN ;
2871: END IF ;
2872: END IF ;

Line 3024: p_ret_code := jai_constants.request_error ;

3020: IF lv_action = 'V' THEN
3021: insert into jai_ap_etds_errors_t(batch_id, record_type, error_message) values
3022: ( ln_batch_id, 'BH', p_return_message ) ;
3023: ELSE
3024: p_ret_code := jai_constants.request_error ;
3025: p_err_buf := p_return_message ;
3026: RETURN ;
3027: END IF ;
3028: END IF ;

Line 3227: p_ret_code := jai_constants.request_error ;

3223: insert into jai_ap_etds_errors_t
3224: (batch_id, record_type, reference_id, error_message) values
3225: ( ln_batch_id, 'CD', v_line_number, p_return_message ) ;
3226: ELSE
3227: p_ret_code := jai_constants.request_error ;
3228: p_err_buf := p_return_message ;
3229: RETURN ;
3230: END IF ;
3231: END IF ;