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.6.12000000.1 2007/07/24 06:55:31 rallamse noship $ */
3:
4:
5:

Line 2581: jai_etcs_pkg.validate_party_detail

2577: p_return_code := null ;
2578: p_return_message := null ;
2579: v_dh_mode :='O';
2580:
2581: jai_etcs_pkg.validate_party_detail
2582: ( p_line_number => v_line_number ,
2583: p_record_type => v_record_type ,
2584: p_batch_number => v_batch_number ,
2585: p_challan_line_num => dd.challan_line_num ,

Line 2625: jai_etcs_pkg.create_quart_party_dtl

2621: ELSIF p_action = 'H' THEN
2622: lv_generate_headers := 'Y' ;
2623: END IF ;
2624:
2625: jai_etcs_pkg.create_quart_party_dtl
2626: (
2627: p_line_number => v_line_number,
2628: p_record_type => v_record_type,
2629: p_batch_number => v_batch_number,

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

2792: );
2793:
2794:
2795: BEGIN
2796: jai_etcs_pkg.openFile(p_file_path, p_filename);
2797: EXCEPTION
2798: WHEN OTHERS THEN
2799: FND_FILE.put_line(FND_FILE.log, 'Error Occured during opening of file(1):'||SQLERRM);
2800: RAISE_APPLICATION_ERROR(-20016, 'Error Occured(1):'||SQLERRM, true);

Line 2821: jai_etcs_pkg.create_fh(ln_batch_id);

2817: v_uploader_type :='D';
2818:
2819: IF lv_etcs_yearly_returns = 'Y' THEN
2820: IF p_generate_headers = 'Y' THEN
2821: jai_etcs_pkg.create_fh(ln_batch_id);
2822: END IF;
2823:
2824: create_file_header
2825: (

Line 2838: jai_etcs_pkg.create_quarterly_fh(ln_batch_id, p_period,p_RespPersAddress, p_RespPersState, p_RespPersPin, p_RespPersAddrChange );

2834: );
2835:
2836: ELSE
2837: IF p_action = 'H' THEN
2838: jai_etcs_pkg.create_quarterly_fh(ln_batch_id, p_period,p_RespPersAddress, p_RespPersState, p_RespPersPin, p_RespPersAddrChange );
2839: END IF;
2840:
2841: p_return_code := null ;
2842: p_return_message := null ;

Line 2844: jai_etcs_pkg.validate_file_header

2840:
2841: p_return_code := null ;
2842: p_return_message := null ;
2843:
2844: jai_etcs_pkg.validate_file_header
2845: ( p_line_number => v_line_number ,
2846: p_record_type => v_record_type ,
2847: p_quartfile_type => v_quartfile_type,
2848: p_upload_type => v_upload_type,

Line 2882: jai_etcs_pkg.create_quarterly_file_header

2878: ELSIF p_action = 'H' THEN
2879: lv_generate_headers := 'Y' ;
2880: END IF ;
2881:
2882: jai_etcs_pkg.create_quarterly_file_header
2883: (
2884: p_line_number => v_line_number,
2885: p_record_type => v_record_type,
2886: p_file_type => v_quartfile_type,

Line 2985: jai_etcs_pkg.create_quarterly_bh;

2981: );
2982:
2983: ELSE
2984: IF p_action = 'H' THEN
2985: jai_etcs_pkg.create_quarterly_bh;
2986: END IF;
2987:
2988: p_return_code := null ;
2989: p_return_message := null ;

Line 3039: jai_etcs_pkg.create_quarterly_batch_header

3035: ELSIF p_action = 'H' THEN
3036: lv_generate_headers := 'Y' ;
3037: END IF ;
3038:
3039: jai_etcs_pkg.create_quarterly_batch_header
3040: (
3041: p_line_number => v_line_number,
3042: p_record_type => v_record_type,
3043: p_batch_number => v_batch_number,

Line 3175: jai_etcs_pkg.create_quarterly_cd;

3171:
3172: FND_FILE.put_line(FND_FILE.log, 'create challan quarterly' );
3173:
3174: IF p_action = 'H' THEN
3175: jai_etcs_pkg.create_quarterly_cd;
3176: END IF ;
3177:
3178: IF cd.challan_no IS NULL THEN
3179: v_bank_branch_code := null ;

Line 3361: jai_etcs_pkg.closeFile;

3357: FND_FILE.put_line(FND_FILE.log,' END OF ERRORS IN THIS BATCH ' );
3358:
3359: END IF ;
3360:
3361: jai_etcs_pkg.closeFile;
3362:
3363: IF p_action <> 'V' THEN
3364: FND_FILE.put_line(FND_FILE.log, '~~~~~~~~~~~~~~~ End of eTCS File Creation ~~~~~~~~~~~~~~~~~~');
3365: END IF ;

Line 3534: END jai_etcs_pkg;

3530: ) ;
3531: END quarterly_returns;
3532:
3533:
3534: END jai_etcs_pkg;