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 842: FND_FILE.put_line(FND_FILE.log,' p_return_message ' || p_return_message ) ;

838: END IF ;
839:
840: <>
841: IF p_return_message IS NOT NULL THEN
842: FND_FILE.put_line(FND_FILE.log,' p_return_message ' || p_return_message ) ;
843: p_return_code := 'E';
844: p_return_message := 'File Header Error - ' || 'Line No : ' || p_line_number || '. ' || p_return_message ;
845: END IF;
846:

Line 2118: 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 ||

2114:
2115: v_bank_branch_code := substr(v_bank_branch_code, 1,10);
2116: */
2117:
2118: 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 ||
2119: ' v_bank_branch_code : ' || v_bank_branch_code ) ;
2120:
2121: update jai_ar_etcs_t
2122: set

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

2692:
2693:
2694: IF NVL(p_period,'XX') = 'XX' THEN
2695: lv_etcs_yearly_returns := 'Y' ;
2696: FND_FILE.put_line(FND_FILE.log, '~~~~Ver:115.0~~~~ Start of eTCS File Creation for Yearly Returns
2697: Batch_id->'||ln_batch_id ||', Creation Date->'||to_char(SYSDATE,'dd-mon-yyyy hh24:mi:ss')||' ~~~~~~~~~~~~~~~~~~');
2698: ELSE
2699: lv_etcs_yearly_returns := 'N' ;
2700: FND_FILE.put_line(FND_FILE.log, '~~~~Ver:115.0~~~~ Start of eTCS File Creation for Quarterly returns

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

2696: FND_FILE.put_line(FND_FILE.log, '~~~~Ver:115.0~~~~ Start of eTCS File Creation for Yearly Returns
2697: Batch_id->'||ln_batch_id ||', Creation Date->'||to_char(SYSDATE,'dd-mon-yyyy hh24:mi:ss')||' ~~~~~~~~~~~~~~~~~~');
2698: ELSE
2699: lv_etcs_yearly_returns := 'N' ;
2700: FND_FILE.put_line(FND_FILE.log, '~~~~Ver:115.0~~~~ Start of eTCS File Creation for Quarterly returns
2701: Batch_id->'||ln_batch_id || 'Period : ' || p_period ||', Creation Date->' ||
2702: to_char(SYSDATE,'dd-mon-yyyy hh24:mi:ss')||' ~~~~~~~~~~~~~~~~~~');
2703: END IF ;
2704:

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

2712: END IF;
2713: END IF ;
2714:
2715: IF length(p_tan_number) > 10 THEN
2716: FND_FILE.put_line(FND_FILE.log, 'Tan Number length is greater than 10 characters');
2717: RAISE_APPLICATION_ERROR(-20014, 'Tan Number length is greater than 10 characters', true);
2718: END IF;
2719:
2720:

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

2742: FETCH c_pan_number INTO v_deductor_pan;
2743: CLOSE c_pan_number;
2744:
2745: IF v_deductor_pan IS NULL THEN
2746: FND_FILE.put_line(FND_FILE.log, 'Pan Number cannot be retreived based on given TAN Number');
2747: RAISE_APPLICATION_ERROR(-20015, 'Pan Number cannot be retreived based on given TAN Number', true);
2748: END IF;
2749:
2750: -- Fetching Start Date and End date of given Financial Year

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

2752: FETCH c_fin_year INTO v_start_date, v_end_date;
2753: CLOSE c_fin_year;
2754:
2755: IF v_start_date IS NULL OR v_end_date IS NULL THEN
2756: FND_FILE.put_line(FND_FILE.log, 'Cannot get values for Financial Year and Assessment Year');
2757: RAISE_APPLICATION_ERROR( -20016, 'Cannot get values for Financial Year and Assessment Year');
2758: END IF;
2759:
2760: -- Fetching Location linked to Input Organization from where address details are captured

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

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);
2801: END;
2802:
2803: IF p_action <> 'V' THEN

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

2800: RAISE_APPLICATION_ERROR(-20016, 'Error Occured(1):'||SQLERRM, true);
2801: END;
2802:
2803: IF p_action <> 'V' THEN
2804: FND_FILE.put_line(FND_FILE.log, 'Start File Header');
2805: END IF ;
2806:
2807: -- File Header (42 Chars)
2808: v_line_number := v_line_number + 1;

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

2932:
2933: v_totTaxDeductedAsPerChallan := v_totTaxDeductedAsPerDeductee ;
2934:
2935: IF p_action <> 'V' THEN
2936: FND_FILE.put_line(FND_FILE.log, 'Batch Header');
2937: END IF ;
2938:
2939: v_ack_num_tan_app := NULL;
2940: v_pro_rcpt_num_org_ret := nvl(p_pro_rcpt_num_org_ret,0);

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

3096: END IF ;
3097: END IF ;
3098:
3099: IF p_action <> 'V' THEN
3100: FND_FILE.put_line(FND_FILE.log, 'Challan Detail');
3101: END IF ;
3102:
3103: v_record_type := 'CD';
3104:

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

3168: v_nil_challan_indicator := 'N' ;
3169:
3170: 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);
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 ;

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

3184:
3185: p_return_code := null ;
3186: p_return_message := null ;
3187:
3188: FND_FILE.put_line(FND_FILE.log, 'Validate Challan Detail' );
3189:
3190: validate_challan_detail
3191: (
3192: p_line_number => v_line_number ,

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

3295: and nvl(bank_branch_code, 'No Bank Branch') = nvl(cd.bank_branch_code, 'No Bank Branch')
3296: and check_number = cd.check_number;
3297:
3298: IF p_action <> 'V' THEN
3299: FND_FILE.put_line(FND_FILE.log, 'Challan Line:'||v_line_number
3300: || ', ChlNum:' || cd.challan_no ||', ChlDate:'||cd.challan_date||', bankBr:'||cd.bank_branch_code
3301: );
3302: END IF ;
3303:

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

3322:
3323: v_record_type := 'DD';
3324:
3325: IF p_action <> 'V' THEN
3326: FND_FILE.put_line(FND_FILE.log, 'Deductee Detail');
3327: END IF ;
3328:
3329: IF p_generate_headers = 'Y' THEN
3330: create_dd;

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

3337: END IF ;
3338:
3339: IF p_action = 'V' THEN
3340:
3341: FND_FILE.put_line(FND_FILE.log,' LISTING THE ERRORS IN THIS BATCH ' );
3342: FND_FILE.put_line(FND_FILE.log,'-------------------------------------------------------------------- ' );
3343:
3344: ln_errors_exist := 0;
3345:

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

3338:
3339: IF p_action = 'V' THEN
3340:
3341: FND_FILE.put_line(FND_FILE.log,' LISTING THE ERRORS IN THIS BATCH ' );
3342: FND_FILE.put_line(FND_FILE.log,'-------------------------------------------------------------------- ' );
3343:
3344: ln_errors_exist := 0;
3345:
3346: FOR rec_get_errors IN c_get_errors(ln_batch_id)

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

3345:
3346: FOR rec_get_errors IN c_get_errors(ln_batch_id)
3347: LOOP
3348: ln_errors_exist := 1 ;
3349: FND_FILE.put_line(FND_FILE.log, rec_get_errors.Error_Message );
3350: END LOOP ;
3351:
3352: IF ln_errors_exist = 0 THEN
3353: FND_FILE.put_line(FND_FILE.log,' File Validation Successful. No Errors Found !! ' );

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

3349: FND_FILE.put_line(FND_FILE.log, rec_get_errors.Error_Message );
3350: END LOOP ;
3351:
3352: IF ln_errors_exist = 0 THEN
3353: FND_FILE.put_line(FND_FILE.log,' File Validation Successful. No Errors Found !! ' );
3354: END IF ;
3355:
3356: FND_FILE.put_line(FND_FILE.log,'-------------------------------------------------------------------- ' );
3357: FND_FILE.put_line(FND_FILE.log,' END OF ERRORS IN THIS BATCH ' );

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

3352: IF ln_errors_exist = 0 THEN
3353: FND_FILE.put_line(FND_FILE.log,' File Validation Successful. No Errors Found !! ' );
3354: END IF ;
3355:
3356: FND_FILE.put_line(FND_FILE.log,'-------------------------------------------------------------------- ' );
3357: FND_FILE.put_line(FND_FILE.log,' END OF ERRORS IN THIS BATCH ' );
3358:
3359: END IF ;
3360:

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

3353: FND_FILE.put_line(FND_FILE.log,' File Validation Successful. No Errors Found !! ' );
3354: END IF ;
3355:
3356: FND_FILE.put_line(FND_FILE.log,'-------------------------------------------------------------------- ' );
3357: FND_FILE.put_line(FND_FILE.log,' END OF ERRORS IN THIS BATCH ' );
3358:
3359: END IF ;
3360:
3361: jai_etcs_pkg.closeFile;

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

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 ;
3366:
3367: END generate_etcs_returns;
3368:

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

3393: pv_end_date DATE DEFAULT fnd_date.canonical_to_date(p_end_date);
3394:
3395: BEGIN
3396:
3397: FND_FILE.put_line( FND_FILE.log, 'Parameters : ' || fnd_global.local_chr(10)
3398: ||' org_tan_number ->'||p_tan_number||fnd_global.local_chr(10)
3399: ||' Organization_id ->'||p_organization_id || fnd_global.local_chr(10)
3400: ||' financial_year ->'||p_fin_year||fnd_global.local_chr(10)
3401: ||' Collection Code ->'||p_collection_code||fnd_global.local_chr(10)

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

3472: pv_end_date DATE DEFAULT fnd_date.canonical_to_date(p_end_date);
3473:
3474: BEGIN
3475:
3476: FND_FILE.put_line( FND_FILE.log, 'Parameters : ' || fnd_global.local_chr(10)
3477: ||' org_tan_number ->'||p_tan_number||fnd_global.local_chr(10)
3478: ||' Organization_id ->'||p_organization_id || fnd_global.local_chr(10)
3479: ||' financial_year ->'||p_fin_year||fnd_global.local_chr(10)
3480: ||' Period ->'||p_period||fnd_global.local_chr(10)