APPS.JAI_ETCS_PKG dependencies on JAI_ETCS_PKG

Line 1: PACKAGE BODY jai_etcs_pkg AS

1: PACKAGE BODY jai_etcs_pkg AS
2: /* $Header: jai_ar_etcs_prc.plb 120.18.12020000.3 2013/03/18 06:00:42 zxin ship $ */
3:
4:
5:

Line 189: jai_cmn_utils_pkg.WRITE_FND_LOG(FND_LOG.LEVEL_STATEMENT, 'JAI.PLSQL.jai_etcs_pkg.get_start_end_date'

185: OPEN c_get_start_end_date(lv_gl_calendar_id, cp_fin_year);
186: FETCH c_get_start_end_date INTO cp_start_date, cp_end_date;
187: CLOSE c_get_start_end_date;
188:
189: jai_cmn_utils_pkg.WRITE_FND_LOG(FND_LOG.LEVEL_STATEMENT, 'JAI.PLSQL.jai_etcs_pkg.get_start_end_date'
190: ,'Get ' || cp_rgm_code || ' Finanical year Start:' || cp_start_date || ' End:' || cp_end_date);
191:
192: EXCEPTION
193: WHEN OTHERS THEN

Line 194: jai_cmn_utils_pkg.WRITE_FND_LOG(FND_LOG.LEVEL_UNEXPECTED, 'JAI.PLSQL.jai_etcs_pkg.get_start_end_date.Other_Exception '

190: ,'Get ' || cp_rgm_code || ' Finanical year Start:' || cp_start_date || ' End:' || cp_end_date);
191:
192: EXCEPTION
193: WHEN OTHERS THEN
194: jai_cmn_utils_pkg.WRITE_FND_LOG(FND_LOG.LEVEL_UNEXPECTED, 'JAI.PLSQL.jai_etcs_pkg.get_start_end_date.Other_Exception '
195: , SQLCODE || ':' || SQLERRM
196: );
197:
198: END get_start_end_date;

Line 3087: jai_etcs_pkg.validate_party_detail

3083: p_return_code := null ;
3084: p_return_message := null ;
3085: v_dh_mode :='O';
3086:
3087: jai_etcs_pkg.validate_party_detail
3088: ( p_line_number => v_line_number ,
3089: p_record_type => v_record_type ,
3090: p_batch_number => v_batch_number ,
3091: p_challan_line_num => dd.challan_line_num ,

Line 3131: jai_etcs_pkg.create_quart_party_dtl

3127: ELSIF p_action = 'H' THEN
3128: lv_generate_headers := 'Y' ;
3129: END IF ;
3130:
3131: jai_etcs_pkg.create_quart_party_dtl
3132: (
3133: p_line_number => v_line_number,
3134: p_record_type => v_record_type,
3135: p_batch_number => v_batch_number,

Line 3314: jai_etcs_pkg.openFile(p_file_path, p_filename);

3310: );
3311:
3312:
3313: BEGIN
3314: jai_etcs_pkg.openFile(p_file_path, p_filename);
3315: EXCEPTION
3316: WHEN OTHERS THEN
3317: FND_FILE.put_line(FND_FILE.log, 'Error Occured during opening of file(1):'||SQLERRM);
3318: RAISE_APPLICATION_ERROR(-20016, 'Error Occured(1):'||SQLERRM, true);

Line 3342: jai_etcs_pkg.create_fh(ln_batch_id);

3338: chk_err(v_err, v_return_message);
3339:
3340: IF lv_etcs_yearly_returns = 'Y' THEN
3341: IF p_generate_headers = 'Y' THEN
3342: jai_etcs_pkg.create_fh(ln_batch_id);
3343: END IF;
3344:
3345: create_file_header
3346: (

Line 3359: jai_etcs_pkg.create_quarterly_fh(ln_batch_id, p_period,/* Added the below 5 parameters for bug 12597773*/p_RespPers_flat_no, p_RespPers_prem_bldg,

3355: );
3356:
3357: ELSE
3358: IF p_action = 'H' THEN
3359: jai_etcs_pkg.create_quarterly_fh(ln_batch_id, p_period,/* Added the below 5 parameters for bug 12597773*/p_RespPers_flat_no, p_RespPers_prem_bldg,
3360: p_RespPers_rd_st_lane, p_RespPers_area_loc,
3361: p_RespPers_tn_cty_dt, /*p_RespPersAddress,*/ p_RespPersState, p_RespPersPin, p_RespPersAddrChange );
3362: END IF;
3363:

Line 3367: jai_etcs_pkg.validate_file_header

3363:
3364: p_return_code := null ;
3365: p_return_message := null ;
3366:
3367: jai_etcs_pkg.validate_file_header
3368: ( p_line_number => v_line_number ,
3369: p_record_type => v_record_type ,
3370: p_quartfile_type => v_quartfile_type,
3371: p_upload_type => v_upload_type,

Line 3406: jai_etcs_pkg.create_quarterly_file_header

3402: ELSIF p_action = 'H' THEN
3403: lv_generate_headers := 'Y' ;
3404: END IF ;
3405:
3406: jai_etcs_pkg.create_quarterly_file_header
3407: (
3408: p_line_number => v_line_number,
3409: p_record_type => v_record_type,
3410: p_file_type => v_quartfile_type,

Line 3556: jai_etcs_pkg.create_quarterly_bh;

3552: );
3553:
3554: ELSE
3555: IF p_action = 'H' THEN
3556: jai_etcs_pkg.create_quarterly_bh;
3557: END IF;
3558:
3559: p_return_code := null ;
3560: p_return_message := null ;

Line 3631: jai_etcs_pkg.create_quarterly_batch_header

3627: ELSIF p_action = 'H' THEN
3628: lv_generate_headers := 'Y' ;
3629: END IF ;
3630:
3631: jai_etcs_pkg.create_quarterly_batch_header
3632: (
3633: p_line_number => v_line_number,
3634: p_record_type => v_record_type,
3635: p_batch_number => v_batch_number,

Line 3779: jai_etcs_pkg.create_quarterly_cd;

3775:
3776: FND_FILE.put_line(FND_FILE.log, 'create challan quarterly' );
3777:
3778: IF p_action = 'H' THEN
3779: jai_etcs_pkg.create_quarterly_cd;
3780: END IF ;
3781:
3782: IF cd.challan_no IS NULL THEN
3783: v_bank_branch_code := null ;

Line 3981: jai_etcs_pkg.closeFile;

3977: FND_FILE.put_line(FND_FILE.log,' END OF ERRORS IN THIS BATCH ' );
3978:
3979: END IF ;
3980:
3981: jai_etcs_pkg.closeFile;
3982:
3983: IF p_action <> 'V' THEN
3984: FND_FILE.put_line(FND_FILE.log, '~~~~~~~~~~~~~~~ End of eTCS File Creation ~~~~~~~~~~~~~~~~~~');
3985: END IF ;

Line 4212: END jai_etcs_pkg;

4208: ) ;
4209: END quarterly_returns;
4210:
4211:
4212: END jai_etcs_pkg;