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 FND_FILE

Line 115: FND_FILE.put_line(FND_FILE.log, p_message);

111: PROCEDURE chk_err (p_err IN VARCHAR2,
112: p_message IN VARCHAR2) IS
113: BEGIN
114: IF (p_err = 'E') THEN
115: FND_FILE.put_line(FND_FILE.log, p_message);
116: RAISE_APPLICATION_ERROR(-20099, p_message, true);
117: ELSIF (p_err in ('N', 'S')) THEN
118: FND_FILE.put_line(FND_FILE.log, p_message);
119: END IF;

Line 118: FND_FILE.put_line(FND_FILE.log, p_message);

114: IF (p_err = 'E') THEN
115: FND_FILE.put_line(FND_FILE.log, p_message);
116: RAISE_APPLICATION_ERROR(-20099, p_message, true);
117: ELSIF (p_err in ('N', 'S')) THEN
118: FND_FILE.put_line(FND_FILE.log, p_message);
119: END IF;
120: END chk_err;
121:
122: -- code ported from BL12.1.3 by zhiwei.xin on 15-MAR-2013 begin

Line 1113: FND_FILE.put_line(FND_FILE.log,' p_return_message ' || p_return_message ) ;

1109: END IF ;
1110:
1111: <>
1112: IF p_return_message IS NOT NULL THEN
1113: FND_FILE.put_line(FND_FILE.log,' p_return_message ' || p_return_message ) ;
1114: p_return_code := 'E';
1115: p_return_message := 'File Header Error - ' || 'Line No : ' || p_line_number || '. ' || p_return_message ;
1116: END IF;
1117:

Line 2550: FND_FILE.put_line(FND_FILE.log, ' lv_customer_type : ' || lv_customer_type || 'lv_pan_no : ' || lv_pan_no || ' lv_doc_date : ' || lv_doc_date ||

2546:
2547: v_bank_branch_code := substr(v_bank_branch_code, 1,10);
2548: */
2549:
2550: FND_FILE.put_line(FND_FILE.log, ' lv_customer_type : ' || lv_customer_type || 'lv_pan_no : ' || lv_pan_no || ' lv_doc_date : ' || lv_doc_date ||
2551: ' v_bank_branch_code : ' || v_bank_branch_code ) ;
2552:
2553: update jai_ar_etcs_t
2554: set

Line 3202: FND_FILE.put_line(FND_FILE.log, 'Ver:115.0 Start of eTCS File Creation for Yearly Returns

3198:
3199:
3200: IF NVL(p_period,'XX') = 'XX' THEN
3201: lv_etcs_yearly_returns := 'Y' ;
3202: FND_FILE.put_line(FND_FILE.log, '~~~~Ver:115.0~~~~ Start of eTCS File Creation for Yearly Returns
3203: Batch_id->'||ln_batch_id ||', Creation Date->'||to_char(SYSDATE,'dd-mon-yyyy hh24:mi:ss')||' ~~~~~~~~~~~~~~~~~~');
3204: ELSE
3205: lv_etcs_yearly_returns := 'N' ;
3206: FND_FILE.put_line(FND_FILE.log, '~~~~Ver:115.0~~~~ Start of eTCS File Creation for Quarterly returns

Line 3206: FND_FILE.put_line(FND_FILE.log, 'Ver:115.0 Start of eTCS File Creation for Quarterly returns

3202: FND_FILE.put_line(FND_FILE.log, '~~~~Ver:115.0~~~~ Start of eTCS File Creation for Yearly Returns
3203: Batch_id->'||ln_batch_id ||', Creation Date->'||to_char(SYSDATE,'dd-mon-yyyy hh24:mi:ss')||' ~~~~~~~~~~~~~~~~~~');
3204: ELSE
3205: lv_etcs_yearly_returns := 'N' ;
3206: FND_FILE.put_line(FND_FILE.log, '~~~~Ver:115.0~~~~ Start of eTCS File Creation for Quarterly returns
3207: Batch_id->'||ln_batch_id || 'Period : ' || p_period ||', Creation Date->' ||
3208: to_char(SYSDATE,'dd-mon-yyyy hh24:mi:ss')||' ~~~~~~~~~~~~~~~~~~');
3209: END IF ;
3210:

Line 3222: FND_FILE.put_line(FND_FILE.log, 'Tan Number length is greater than 10 characters');

3218: END IF;
3219: END IF ;
3220:
3221: IF length(p_tan_number) > 10 THEN
3222: FND_FILE.put_line(FND_FILE.log, 'Tan Number length is greater than 10 characters');
3223: RAISE_APPLICATION_ERROR(-20014, 'Tan Number length is greater than 10 characters', true);
3224: END IF;
3225:
3226:

Line 3254: FND_FILE.put_line(FND_FILE.log, 'Pan Number cannot be retreived based on given TAN Number');

3250: FETCH c_pan_number INTO v_deductor_pan;
3251: CLOSE c_pan_number;
3252:
3253: IF v_deductor_pan IS NULL THEN
3254: FND_FILE.put_line(FND_FILE.log, 'Pan Number cannot be retreived based on given TAN Number');
3255: RAISE_APPLICATION_ERROR(-20015, 'Pan Number cannot be retreived based on given TAN Number', true);
3256: END IF;
3257:
3258: -- code ported from BL12.1.3 on 15-MAR-2013 by zhiwei.xin begin

Line 3274: FND_FILE.put_line(FND_FILE.log, 'Cannot get values for Financial Year and Assessment Year');

3270:
3271: -- code ported from BL12.1.3 on 15-MAR-2013 by zhiwei.xin end.
3272:
3273: IF v_start_date IS NULL OR v_end_date IS NULL THEN
3274: FND_FILE.put_line(FND_FILE.log, 'Cannot get values for Financial Year and Assessment Year');
3275: RAISE_APPLICATION_ERROR( -20016, 'Cannot get values for Financial Year and Assessment Year');
3276: END IF;
3277:
3278: -- Fetching Location linked to Input Organization from where address details are captured

Line 3317: FND_FILE.put_line(FND_FILE.log, 'Error Occured during opening of file(1):'||SQLERRM);

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);
3319: END;
3320:
3321: IF p_action <> 'V' THEN

Line 3322: FND_FILE.put_line(FND_FILE.log, 'Start File Header');

3318: RAISE_APPLICATION_ERROR(-20016, 'Error Occured(1):'||SQLERRM, true);
3319: END;
3320:
3321: IF p_action <> 'V' THEN
3322: FND_FILE.put_line(FND_FILE.log, 'Start File Header');
3323: END IF ;
3324:
3325: -- File Header (42 Chars)
3326: v_line_number := v_line_number + 1;

Line 3462: FND_FILE.put_line(FND_FILE.log, 'Batch Header');

3458:
3459: v_totTaxDeductedAsPerChallan := v_totTaxDeductedAsPerDeductee ;
3460:
3461: IF p_action <> 'V' THEN
3462: FND_FILE.put_line(FND_FILE.log, 'Batch Header');
3463: END IF ;
3464:
3465: v_ack_num_tan_app := NULL;
3466: v_pro_rcpt_num_org_ret := nvl(p_pro_rcpt_num_org_ret,0);

Line 3703: FND_FILE.put_line(FND_FILE.log, 'Challan Detail');

3699: END IF ;
3700: END IF ;
3701:
3702: IF p_action <> 'V' THEN
3703: FND_FILE.put_line(FND_FILE.log, 'Challan Detail');
3704: END IF ;
3705:
3706: v_record_type := 'CD';
3707:

Line 3776: FND_FILE.put_line(FND_FILE.log, 'create challan quarterly' );

3772: v_nil_challan_indicator := 'N' ;
3773:
3774: jai_ap_tds_etds_pkg.check_numeric(v_bank_branch_code, 'Check Number : ' || cd.check_number || ' Bank Branch Code is not a Numeric Value ', p_action);
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 ;

Line 3792: FND_FILE.put_line(FND_FILE.log, 'Validate Challan Detail' );

3788:
3789: p_return_code := null ;
3790: p_return_message := null ;
3791:
3792: FND_FILE.put_line(FND_FILE.log, 'Validate Challan Detail' );
3793:
3794: validate_challan_detail
3795: (
3796: p_line_number => v_line_number ,

Line 3919: FND_FILE.put_line(FND_FILE.log, 'Challan Line:'||v_line_number

3915: and nvl(bank_branch_code, 'No Bank Branch') = nvl(cd.bank_branch_code, 'No Bank Branch')
3916: and check_number = cd.check_number;
3917:
3918: IF p_action <> 'V' THEN
3919: FND_FILE.put_line(FND_FILE.log, 'Challan Line:'||v_line_number
3920: || ', ChlNum:' || cd.challan_no ||', ChlDate:'||cd.challan_date||', bankBr:'||cd.bank_branch_code
3921: );
3922: END IF ;
3923:

Line 3946: FND_FILE.put_line(FND_FILE.log, 'Deductee Detail');

3942:
3943: v_record_type := 'DD';
3944:
3945: IF p_action <> 'V' THEN
3946: FND_FILE.put_line(FND_FILE.log, 'Deductee Detail');
3947: END IF ;
3948:
3949: IF p_generate_headers = 'Y' THEN
3950: create_dd;

Line 3961: FND_FILE.put_line(FND_FILE.log,' LISTING THE ERRORS IN THIS BATCH ' );

3957: END IF ;
3958:
3959: IF p_action = 'V' THEN
3960:
3961: FND_FILE.put_line(FND_FILE.log,' LISTING THE ERRORS IN THIS BATCH ' );
3962: FND_FILE.put_line(FND_FILE.log,'-------------------------------------------------------------------- ' );
3963:
3964: ln_errors_exist := 0;
3965:

Line 3962: FND_FILE.put_line(FND_FILE.log,'-------------------------------------------------------------------- ' );

3958:
3959: IF p_action = 'V' THEN
3960:
3961: FND_FILE.put_line(FND_FILE.log,' LISTING THE ERRORS IN THIS BATCH ' );
3962: FND_FILE.put_line(FND_FILE.log,'-------------------------------------------------------------------- ' );
3963:
3964: ln_errors_exist := 0;
3965:
3966: FOR rec_get_errors IN c_get_errors(ln_batch_id)

Line 3969: FND_FILE.put_line(FND_FILE.log, rec_get_errors.Error_Message );

3965:
3966: FOR rec_get_errors IN c_get_errors(ln_batch_id)
3967: LOOP
3968: ln_errors_exist := 1 ;
3969: FND_FILE.put_line(FND_FILE.log, rec_get_errors.Error_Message );
3970: END LOOP ;
3971:
3972: IF ln_errors_exist = 0 THEN
3973: FND_FILE.put_line(FND_FILE.log,' File Validation Successful. No Errors Found !! ' );

Line 3973: FND_FILE.put_line(FND_FILE.log,' File Validation Successful. No Errors Found !! ' );

3969: FND_FILE.put_line(FND_FILE.log, rec_get_errors.Error_Message );
3970: END LOOP ;
3971:
3972: IF ln_errors_exist = 0 THEN
3973: FND_FILE.put_line(FND_FILE.log,' File Validation Successful. No Errors Found !! ' );
3974: END IF ;
3975:
3976: FND_FILE.put_line(FND_FILE.log,'-------------------------------------------------------------------- ' );
3977: FND_FILE.put_line(FND_FILE.log,' END OF ERRORS IN THIS BATCH ' );

Line 3976: FND_FILE.put_line(FND_FILE.log,'-------------------------------------------------------------------- ' );

3972: IF ln_errors_exist = 0 THEN
3973: FND_FILE.put_line(FND_FILE.log,' File Validation Successful. No Errors Found !! ' );
3974: END IF ;
3975:
3976: FND_FILE.put_line(FND_FILE.log,'-------------------------------------------------------------------- ' );
3977: FND_FILE.put_line(FND_FILE.log,' END OF ERRORS IN THIS BATCH ' );
3978:
3979: END IF ;
3980:

Line 3977: FND_FILE.put_line(FND_FILE.log,' END OF ERRORS IN THIS BATCH ' );

3973: FND_FILE.put_line(FND_FILE.log,' File Validation Successful. No Errors Found !! ' );
3974: END IF ;
3975:
3976: FND_FILE.put_line(FND_FILE.log,'-------------------------------------------------------------------- ' );
3977: FND_FILE.put_line(FND_FILE.log,' END OF ERRORS IN THIS BATCH ' );
3978:
3979: END IF ;
3980:
3981: jai_etcs_pkg.closeFile;

Line 3984: FND_FILE.put_line(FND_FILE.log, '~ End of eTCS File Creation ~~~~');

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 ;
3986: /*Bug 12597773 Start*/
3987: if (lv_etcs_yearly_returns='N') then
3988: open c_get_state_desc ;

Line 4056: FND_FILE.put_line( FND_FILE.log, 'Parameters : ' || fnd_global.local_chr(10)

4052: pv_end_date DATE DEFAULT fnd_date.canonical_to_date(p_end_date);
4053:
4054: BEGIN
4055:
4056: FND_FILE.put_line( FND_FILE.log, 'Parameters : ' || fnd_global.local_chr(10)
4057: ||' org_tan_number ->'||p_tan_number||fnd_global.local_chr(10)
4058: ||' Organization_id ->'||p_organization_id || fnd_global.local_chr(10)
4059: ||' financial_year ->'||p_fin_year||fnd_global.local_chr(10)
4060: ||' Collection Code ->'||p_collection_code||fnd_global.local_chr(10)

Line 4142: FND_FILE.put_line( FND_FILE.log, 'Parameters : ' || fnd_global.local_chr(10)

4138: pv_end_date DATE DEFAULT fnd_date.canonical_to_date(p_end_date);
4139:
4140: BEGIN
4141:
4142: FND_FILE.put_line( FND_FILE.log, 'Parameters : ' || fnd_global.local_chr(10)
4143: ||' org_tan_number ->'||p_tan_number||fnd_global.local_chr(10)
4144: ||' Organization_id ->'||p_organization_id || fnd_global.local_chr(10)
4145: ||' financial_year ->'||p_fin_year||fnd_global.local_chr(10)
4146: ||' Period ->'||p_period||fnd_global.local_chr(10)