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_EXCISE_SCRIPTS_PKG dependencies on FND_FILE

Line 676: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Error : No previous record exists. Need to fix Manually');

672: p_bal => ln_prev_balance);
673:
674: IF ln_prev_slno IS NULL THEN
675:
676: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Error : No previous record exists. Need to fix Manually');
677: RETURN;
678:
679: END IF;
680:

Line 1359: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Error : No previous record exists. Need to fix Manually');

1355: p_bal => ln_prev_balance);
1356:
1357: IF ln_prev_slno IS NULL THEN
1358:
1359: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Error : No previous record exists. Need to fix Manually');
1360: RETURN;
1361:
1362: END IF;
1363:

Line 2543: FND_FILE.put_line( FND_FILE.log, ' Process RG Trx Inputs. Organization Id:' || p_organization_id ||

2539: pv_date DATE DEFAULT fnd_date.canonical_to_date(p_date);
2540:
2541: BEGIN
2542:
2543: FND_FILE.put_line( FND_FILE.log, ' Process RG Trx Inputs. Organization Id:' || p_organization_id ||
2544: ' Location Id : ' || p_location_id ||
2545: ' Register Type : ' || NVL(p_register_type,'ALL') ||
2546: ' p_date : ' || pv_date ||
2547: ' p_action : ' || p_action ||

Line 2551: FND_FILE.put_line( FND_FILE.log, '' ) ;

2547: ' p_action : ' || p_action ||
2548: ' p_debug : ' || p_debug ||
2549: ' p_backup : ' || p_backup ) ;
2550:
2551: FND_FILE.put_line( FND_FILE.log, '' ) ;
2552: FND_FILE.put_line( FND_FILE.log, '' ) ;
2553:
2554: retcode := 0 ;
2555: gd_date := to_date(pv_date,'DD/MM/RRRR') ;

Line 2552: FND_FILE.put_line( FND_FILE.log, '' ) ;

2548: ' p_debug : ' || p_debug ||
2549: ' p_backup : ' || p_backup ) ;
2550:
2551: FND_FILE.put_line( FND_FILE.log, '' ) ;
2552: FND_FILE.put_line( FND_FILE.log, '' ) ;
2553:
2554: retcode := 0 ;
2555: gd_date := to_date(pv_date,'DD/MM/RRRR') ;
2556: gn_action := p_action ;

Line 2914: FND_FILE.PUT_LINE(FND_FILE.LOG, '| Organization Id |' || ' Location Id |' || ' Register Type |' || ' Tax Type |

2910: then
2911:
2912: ln_header := 1 ;
2913:
2914: FND_FILE.PUT_LINE(FND_FILE.LOG, '| Organization Id |' || ' Location Id |' || ' Register Type |' || ' Tax Type |
2915: ' || ' Data State |'|| ' Opening Balance |' || 'Credit Amount |' || ' Debit Amount |' || ' Closing Bal(RG) |' || ' Closing Bal(RG Slno) |' || ' Closing Bal(Register) |' ) ;
2916: FND_FILE.PUT_LINE(FND_FILE.LOG, '| --------------- |' || ' ----------- |' || ' ------------- |' || ' -------------------- |
2917: ' || ' ------ |'|| ' --------------- |' || '------------- |' || ' ------------ |' || ' --------------- |' || ' -------------------- |' || ' --------------------- |' ) ;
2918:

Line 2916: FND_FILE.PUT_LINE(FND_FILE.LOG, '| --------------- |' || ' ----------- |' || ' ------------- |' || ' -------------------- |

2912: ln_header := 1 ;
2913:
2914: FND_FILE.PUT_LINE(FND_FILE.LOG, '| Organization Id |' || ' Location Id |' || ' Register Type |' || ' Tax Type |
2915: ' || ' Data State |'|| ' Opening Balance |' || 'Credit Amount |' || ' Debit Amount |' || ' Closing Bal(RG) |' || ' Closing Bal(RG Slno) |' || ' Closing Bal(Register) |' ) ;
2916: FND_FILE.PUT_LINE(FND_FILE.LOG, '| --------------- |' || ' ----------- |' || ' ------------- |' || ' -------------------- |
2917: ' || ' ------ |'|| ' --------------- |' || '------------- |' || ' ------------ |' || ' --------------- |' || ' -------------------- |' || ' --------------------- |' ) ;
2918:
2919: for rg23_log_rec in ( select
2920: distinct organization_id, location_id, register_type

Line 3222: FND_FILE.PUT_LINE(FND_FILE.LOG, '|' || RPAD(rg23_log_rec.organization_id, 17, ' ')|| '|' || RPAD(rg23_log_rec.location_id, 13, ' ') ||

3218: lv_cvd_cess_status := 'CONSISTENT';
3219: lv_sh_exc_cess_status := 'CONSISTENT';
3220: lv_sh_cvd_cess_status := 'CONSISTENT';
3221: end if ;
3222: FND_FILE.PUT_LINE(FND_FILE.LOG, '|' || RPAD(rg23_log_rec.organization_id, 17, ' ')|| '|' || RPAD(rg23_log_rec.location_id, 13, ' ') ||
3223: '|' || RPAD(rg23_log_rec.register_type, 15, ' ') || '|' || 'Excise |'|| RPAD(lv_status, 12, ' ') || '|'|| RPAD(nvl(ln_open_bal,0), 17, ' ') || '|' || RPAD(nvl(ln_credit_amount,0), 14, ' ') || '|'
3224: || RPAD(nvl(ln_debit_amount,0), 14, ' ') || '|' || RPAD(nvl(ln_rg_balance,0), 17, ' ') || '|' || RPAD(nvl(ln_slno_bal,0), 22, ' ') || '|' || RPAD(nvl(ln_rg23_balance,0), 23, ' ') || '|' ) ;
3225: FND_FILE.PUT_LINE(FND_FILE.LOG, '|' || RPAD(rg23_log_rec.organization_id, 17, ' ')|| '|' || RPAD(rg23_log_rec.location_id, 13, ' ') ||
3226: '|' || RPAD(rg23_log_rec.register_type, 15, ' ') || '|' || 'EXCISE_EDUCATION_CESS |'|| RPAD(lv_exc_cess_status, 12, ' ') || '|'||

Line 3225: FND_FILE.PUT_LINE(FND_FILE.LOG, '|' || RPAD(rg23_log_rec.organization_id, 17, ' ')|| '|' || RPAD(rg23_log_rec.location_id, 13, ' ') ||

3221: end if ;
3222: FND_FILE.PUT_LINE(FND_FILE.LOG, '|' || RPAD(rg23_log_rec.organization_id, 17, ' ')|| '|' || RPAD(rg23_log_rec.location_id, 13, ' ') ||
3223: '|' || RPAD(rg23_log_rec.register_type, 15, ' ') || '|' || 'Excise |'|| RPAD(lv_status, 12, ' ') || '|'|| RPAD(nvl(ln_open_bal,0), 17, ' ') || '|' || RPAD(nvl(ln_credit_amount,0), 14, ' ') || '|'
3224: || RPAD(nvl(ln_debit_amount,0), 14, ' ') || '|' || RPAD(nvl(ln_rg_balance,0), 17, ' ') || '|' || RPAD(nvl(ln_slno_bal,0), 22, ' ') || '|' || RPAD(nvl(ln_rg23_balance,0), 23, ' ') || '|' ) ;
3225: FND_FILE.PUT_LINE(FND_FILE.LOG, '|' || RPAD(rg23_log_rec.organization_id, 17, ' ')|| '|' || RPAD(rg23_log_rec.location_id, 13, ' ') ||
3226: '|' || RPAD(rg23_log_rec.register_type, 15, ' ') || '|' || 'EXCISE_EDUCATION_CESS |'|| RPAD(lv_exc_cess_status, 12, ' ') || '|'||
3227: RPAD(nvl(ln_exc_cess_rg23,0), 17, ' ') || '|' || RPAD(nvl(ln_exc_cess_rg23_cr,0), 14, ' ') || '|' || RPAD(nvl(ln_exc_cess_rg23_dr,0), 14, ' ') ||
3228: '|' || RPAD(nvl(ln_exc_cess_rg23_final,0), 17, ' ') || '|' || ' ' || '|' || ' ' || '|' ) ;
3229: FND_FILE.PUT_LINE(FND_FILE.LOG, '|' || RPAD(rg23_log_rec.organization_id, 17, ' ')|| '|' || RPAD(rg23_log_rec.location_id, 13, ' ') || '|'

Line 3229: FND_FILE.PUT_LINE(FND_FILE.LOG, '|' || RPAD(rg23_log_rec.organization_id, 17, ' ')|| '|' || RPAD(rg23_log_rec.location_id, 13, ' ') || '|'

3225: FND_FILE.PUT_LINE(FND_FILE.LOG, '|' || RPAD(rg23_log_rec.organization_id, 17, ' ')|| '|' || RPAD(rg23_log_rec.location_id, 13, ' ') ||
3226: '|' || RPAD(rg23_log_rec.register_type, 15, ' ') || '|' || 'EXCISE_EDUCATION_CESS |'|| RPAD(lv_exc_cess_status, 12, ' ') || '|'||
3227: RPAD(nvl(ln_exc_cess_rg23,0), 17, ' ') || '|' || RPAD(nvl(ln_exc_cess_rg23_cr,0), 14, ' ') || '|' || RPAD(nvl(ln_exc_cess_rg23_dr,0), 14, ' ') ||
3228: '|' || RPAD(nvl(ln_exc_cess_rg23_final,0), 17, ' ') || '|' || ' ' || '|' || ' ' || '|' ) ;
3229: FND_FILE.PUT_LINE(FND_FILE.LOG, '|' || RPAD(rg23_log_rec.organization_id, 17, ' ')|| '|' || RPAD(rg23_log_rec.location_id, 13, ' ') || '|'
3230: || RPAD(rg23_log_rec.register_type, 15, ' ') || '|' || 'CVD_EDUCATION_CESS |'|| RPAD(lv_cvd_cess_status, 12, ' ') || '|'|| RPAD(nvl(ln_cvd_cess_rg23,0), 17, ' ') || '|'
3231: || RPAD(nvl(ln_cvd_cess_rg23_cr,0), 14, ' ') || '|' || RPAD(nvl(ln_cvd_cess_rg23_dr,0), 14, ' ') || '|' || RPAD(nvl(ln_cvd_cess_rg23_final,0), 17, ' ') || '|'
3232: || ' ' || '|' || ' ' || '|' ) ;
3233: FND_FILE.PUT_LINE(FND_FILE.LOG, '|' || RPAD(rg23_log_rec.organization_id, 17, ' ')|| '|'

Line 3233: FND_FILE.PUT_LINE(FND_FILE.LOG, '|' || RPAD(rg23_log_rec.organization_id, 17, ' ')|| '|'

3229: FND_FILE.PUT_LINE(FND_FILE.LOG, '|' || RPAD(rg23_log_rec.organization_id, 17, ' ')|| '|' || RPAD(rg23_log_rec.location_id, 13, ' ') || '|'
3230: || RPAD(rg23_log_rec.register_type, 15, ' ') || '|' || 'CVD_EDUCATION_CESS |'|| RPAD(lv_cvd_cess_status, 12, ' ') || '|'|| RPAD(nvl(ln_cvd_cess_rg23,0), 17, ' ') || '|'
3231: || RPAD(nvl(ln_cvd_cess_rg23_cr,0), 14, ' ') || '|' || RPAD(nvl(ln_cvd_cess_rg23_dr,0), 14, ' ') || '|' || RPAD(nvl(ln_cvd_cess_rg23_final,0), 17, ' ') || '|'
3232: || ' ' || '|' || ' ' || '|' ) ;
3233: FND_FILE.PUT_LINE(FND_FILE.LOG, '|' || RPAD(rg23_log_rec.organization_id, 17, ' ')|| '|'
3234: || RPAD(rg23_log_rec.location_id, 13, ' ') || '|' || RPAD(rg23_log_rec.register_type, 15, ' ') || '|' || 'EXCISE_SH_EDU_CESS |'
3235: || RPAD(lv_sh_exc_cess_status, 12, ' ') || '|'|| RPAD(nvl(ln_sh_exc_cess_rg23,0), 17, ' ') || '|' || RPAD(nvl(ln_sh_exc_cess_rg23_cr,0), 14, ' ') || '|' || RPAD(nvl(ln_sh_exc_cess_rg23_dr,0), 14, ' ') || '|'
3236: || RPAD(nvl(ln_sh_exc_cess_rg23_final,0), 17, ' ') || '|' || ' ' || '|' || ' ' || '|' ) ;
3237: FND_FILE.PUT_LINE(FND_FILE.LOG, '|' || RPAD(rg23_log_rec.organization_id, 17, ' ')|| '|' || RPAD(rg23_log_rec.location_id, 13, ' ') || '|' || RPAD(rg23_log_rec.register_type, 15, ' ')

Line 3237: FND_FILE.PUT_LINE(FND_FILE.LOG, '|' || RPAD(rg23_log_rec.organization_id, 17, ' ')|| '|' || RPAD(rg23_log_rec.location_id, 13, ' ') || '|' || RPAD(rg23_log_rec.register_type, 15, ' ')

3233: FND_FILE.PUT_LINE(FND_FILE.LOG, '|' || RPAD(rg23_log_rec.organization_id, 17, ' ')|| '|'
3234: || RPAD(rg23_log_rec.location_id, 13, ' ') || '|' || RPAD(rg23_log_rec.register_type, 15, ' ') || '|' || 'EXCISE_SH_EDU_CESS |'
3235: || RPAD(lv_sh_exc_cess_status, 12, ' ') || '|'|| RPAD(nvl(ln_sh_exc_cess_rg23,0), 17, ' ') || '|' || RPAD(nvl(ln_sh_exc_cess_rg23_cr,0), 14, ' ') || '|' || RPAD(nvl(ln_sh_exc_cess_rg23_dr,0), 14, ' ') || '|'
3236: || RPAD(nvl(ln_sh_exc_cess_rg23_final,0), 17, ' ') || '|' || ' ' || '|' || ' ' || '|' ) ;
3237: FND_FILE.PUT_LINE(FND_FILE.LOG, '|' || RPAD(rg23_log_rec.organization_id, 17, ' ')|| '|' || RPAD(rg23_log_rec.location_id, 13, ' ') || '|' || RPAD(rg23_log_rec.register_type, 15, ' ')
3238: || '|' || 'CVD_SH_EDU_CESS |'|| RPAD(lv_sh_cvd_cess_status, 12, ' ') || '|'|| RPAD(nvl(ln_sh_cvd_cess_rg23,0), 17, ' ') || '|' || RPAD(nvl(ln_sh_cvd_cess_rg23_cr,0), 14, ' ') || '|'
3239: || RPAD(nvl(ln_sh_cvd_cess_rg23_dr,0), 14, ' ') || '|' || RPAD(nvl(ln_sh_cvd_cess_rg23_final,0), 17, ' ') || '|' || ' ' || '|'
3240: || ' ' || '|' ) ;
3241: FND_FILE.PUT_LINE(FND_FILE.LOG, '----------------------------------------------------------------------

Line 3241: FND_FILE.PUT_LINE(FND_FILE.LOG, '----------------------------------------------------------------------

3237: FND_FILE.PUT_LINE(FND_FILE.LOG, '|' || RPAD(rg23_log_rec.organization_id, 17, ' ')|| '|' || RPAD(rg23_log_rec.location_id, 13, ' ') || '|' || RPAD(rg23_log_rec.register_type, 15, ' ')
3238: || '|' || 'CVD_SH_EDU_CESS |'|| RPAD(lv_sh_cvd_cess_status, 12, ' ') || '|'|| RPAD(nvl(ln_sh_cvd_cess_rg23,0), 17, ' ') || '|' || RPAD(nvl(ln_sh_cvd_cess_rg23_cr,0), 14, ' ') || '|'
3239: || RPAD(nvl(ln_sh_cvd_cess_rg23_dr,0), 14, ' ') || '|' || RPAD(nvl(ln_sh_cvd_cess_rg23_final,0), 17, ' ') || '|' || ' ' || '|'
3240: || ' ' || '|' ) ;
3241: FND_FILE.PUT_LINE(FND_FILE.LOG, '----------------------------------------------------------------------
3242: -----------------------------------------------------------------------------------------
3243: -------------------------------------------------' ) ;
3244: end loop ;
3245:

Line 3252: FND_FILE.PUT_LINE(FND_FILE.LOG, '| Organization Id |' || ' Location Id |' || ' Register Type |' || ' Tax Type |'|| ' Data State |'|| ' Opening Balance |'

3248: if (p_register_type is null ) or (p_register_type = 'PLA')
3249: then
3250:
3251: if nvl(ln_header,0) = 0 then
3252: FND_FILE.PUT_LINE(FND_FILE.LOG, '| Organization Id |' || ' Location Id |' || ' Register Type |' || ' Tax Type |'|| ' Data State |'|| ' Opening Balance |'
3253: || 'Credit Amount |' || ' Debit Amount |' || ' Closing Bal(RG) |' || ' Closing Bal(RG Slno) |' || ' Closing Bal(Register) |' ) ;
3254: FND_FILE.PUT_LINE(FND_FILE.LOG, '| --------------- |' || ' ----------- |' || ' ------------- |' || ' --------------------|'|| ' ------ |'|| ' --------------- |'
3255: || '------------- |' || ' ------------ |' || ' --------------- |' || ' -------------------- |' || ' --------------------- |' ) ;
3256: end if ;

Line 3254: FND_FILE.PUT_LINE(FND_FILE.LOG, '| --------------- |' || ' ----------- |' || ' ------------- |' || ' --------------------|'|| ' ------ |'|| ' --------------- |'

3250:
3251: if nvl(ln_header,0) = 0 then
3252: FND_FILE.PUT_LINE(FND_FILE.LOG, '| Organization Id |' || ' Location Id |' || ' Register Type |' || ' Tax Type |'|| ' Data State |'|| ' Opening Balance |'
3253: || 'Credit Amount |' || ' Debit Amount |' || ' Closing Bal(RG) |' || ' Closing Bal(RG Slno) |' || ' Closing Bal(Register) |' ) ;
3254: FND_FILE.PUT_LINE(FND_FILE.LOG, '| --------------- |' || ' ----------- |' || ' ------------- |' || ' --------------------|'|| ' ------ |'|| ' --------------- |'
3255: || '------------- |' || ' ------------ |' || ' --------------- |' || ' -------------------- |' || ' --------------------- |' ) ;
3256: end if ;
3257:
3258: for pla_log_rec in ( select

Line 3553: FND_FILE.PUT_LINE(FND_FILE.LOG, '|' || RPAD(pla_log_rec.organization_id, 17, ' ')|| '|' || RPAD(pla_log_rec.location_id, 13, ' ') || '|' || RPAD('PLA', 15, ' ') || '|' || 'Excise |'

3549:
3550: end if ;
3551:
3552:
3553: FND_FILE.PUT_LINE(FND_FILE.LOG, '|' || RPAD(pla_log_rec.organization_id, 17, ' ')|| '|' || RPAD(pla_log_rec.location_id, 13, ' ') || '|' || RPAD('PLA', 15, ' ') || '|' || 'Excise |'
3554: || RPAD(lv_status, 12, ' ') || '|' || RPAD(nvl(ln_open_bal,0), 17, ' ') || '|' || RPAD(nvl(ln_credit_amount,0), 14, ' ') || '|' || RPAD(nvl(ln_debit_amount,0), 14, ' ') || '|' || RPAD(nvl(ln_rg_balance,0), 17, ' ') || '|'
3555: || RPAD(nvl(ln_slno_bal,0), 22, ' ') || '|' || RPAD(nvl(ln_pla_balance,0) , 23, ' ') || '|' ) ;
3556: FND_FILE.PUT_LINE(FND_FILE.LOG, '|' || RPAD(pla_log_rec.organization_id, 17, ' ')|| '|' || RPAD(pla_log_rec.location_id, 13, ' ') || '|' || RPAD('PLA', 15, ' ') || '|' || 'EXCISE_EDUCATION_CESS |'
3557: || RPAD(lv_exc_cess_status, 12, ' ') || '|'|| RPAD(nvl(ln_exc_cess_pla,0), 17, ' ') || '|' || RPAD(nvl(ln_exc_cess_pla_cr,0), 14, ' ') || '|' || RPAD(nvl(ln_exc_cess_pla_dr,0), 14, ' ') || '|'

Line 3556: FND_FILE.PUT_LINE(FND_FILE.LOG, '|' || RPAD(pla_log_rec.organization_id, 17, ' ')|| '|' || RPAD(pla_log_rec.location_id, 13, ' ') || '|' || RPAD('PLA', 15, ' ') || '|' || 'EXCISE_EDUCATION_CESS |'

3552:
3553: FND_FILE.PUT_LINE(FND_FILE.LOG, '|' || RPAD(pla_log_rec.organization_id, 17, ' ')|| '|' || RPAD(pla_log_rec.location_id, 13, ' ') || '|' || RPAD('PLA', 15, ' ') || '|' || 'Excise |'
3554: || RPAD(lv_status, 12, ' ') || '|' || RPAD(nvl(ln_open_bal,0), 17, ' ') || '|' || RPAD(nvl(ln_credit_amount,0), 14, ' ') || '|' || RPAD(nvl(ln_debit_amount,0), 14, ' ') || '|' || RPAD(nvl(ln_rg_balance,0), 17, ' ') || '|'
3555: || RPAD(nvl(ln_slno_bal,0), 22, ' ') || '|' || RPAD(nvl(ln_pla_balance,0) , 23, ' ') || '|' ) ;
3556: FND_FILE.PUT_LINE(FND_FILE.LOG, '|' || RPAD(pla_log_rec.organization_id, 17, ' ')|| '|' || RPAD(pla_log_rec.location_id, 13, ' ') || '|' || RPAD('PLA', 15, ' ') || '|' || 'EXCISE_EDUCATION_CESS |'
3557: || RPAD(lv_exc_cess_status, 12, ' ') || '|'|| RPAD(nvl(ln_exc_cess_pla,0), 17, ' ') || '|' || RPAD(nvl(ln_exc_cess_pla_cr,0), 14, ' ') || '|' || RPAD(nvl(ln_exc_cess_pla_dr,0), 14, ' ') || '|'
3558: || RPAD(nvl(ln_exc_cess_pla_final,0), 17, ' ') || '|' || ' ' || '|' || ' ' || '|' ) ;
3559: FND_FILE.PUT_LINE(FND_FILE.LOG, '|' || RPAD(pla_log_rec.organization_id, 17, ' ')
3560: || '|' || RPAD(pla_log_rec.location_id, 13, ' ') || '|' || RPAD('PLA', 15, ' ')

Line 3559: FND_FILE.PUT_LINE(FND_FILE.LOG, '|' || RPAD(pla_log_rec.organization_id, 17, ' ')

3555: || RPAD(nvl(ln_slno_bal,0), 22, ' ') || '|' || RPAD(nvl(ln_pla_balance,0) , 23, ' ') || '|' ) ;
3556: FND_FILE.PUT_LINE(FND_FILE.LOG, '|' || RPAD(pla_log_rec.organization_id, 17, ' ')|| '|' || RPAD(pla_log_rec.location_id, 13, ' ') || '|' || RPAD('PLA', 15, ' ') || '|' || 'EXCISE_EDUCATION_CESS |'
3557: || RPAD(lv_exc_cess_status, 12, ' ') || '|'|| RPAD(nvl(ln_exc_cess_pla,0), 17, ' ') || '|' || RPAD(nvl(ln_exc_cess_pla_cr,0), 14, ' ') || '|' || RPAD(nvl(ln_exc_cess_pla_dr,0), 14, ' ') || '|'
3558: || RPAD(nvl(ln_exc_cess_pla_final,0), 17, ' ') || '|' || ' ' || '|' || ' ' || '|' ) ;
3559: FND_FILE.PUT_LINE(FND_FILE.LOG, '|' || RPAD(pla_log_rec.organization_id, 17, ' ')
3560: || '|' || RPAD(pla_log_rec.location_id, 13, ' ') || '|' || RPAD('PLA', 15, ' ')
3561: || '|' || 'CVD_EDUCATION_CESS |'|| RPAD(lv_cvd_cess_status, 12, ' ') || '|'
3562: || RPAD(nvl(ln_cvd_cess_pla,0), 17, ' ') || '|'
3563: || RPAD(nvl(ln_cvd_cess_pla_cr,0), 14, ' ') ||

Line 3565: FND_FILE.PUT_LINE(FND_FILE.LOG, '|' || RPAD(pla_log_rec.organization_id, 17, ' ')|| '|'

3561: || '|' || 'CVD_EDUCATION_CESS |'|| RPAD(lv_cvd_cess_status, 12, ' ') || '|'
3562: || RPAD(nvl(ln_cvd_cess_pla,0), 17, ' ') || '|'
3563: || RPAD(nvl(ln_cvd_cess_pla_cr,0), 14, ' ') ||
3564: '|' || RPAD(nvl(ln_cvd_cess_pla_dr,0), 14, ' ') || '|' || RPAD(nvl(ln_cvd_cess_pla_final,0), 17, ' ') || '|' || ' ' || '|' || ' ' || '|' ) ;
3565: FND_FILE.PUT_LINE(FND_FILE.LOG, '|' || RPAD(pla_log_rec.organization_id, 17, ' ')|| '|'
3566: || RPAD(pla_log_rec.location_id, 13, ' ') || '|' || RPAD('PLA', 15, ' ') || '|' || 'EXCISE_SH_EDU_CESS |'|| RPAD(lv_sh_exc_cess_status, 12, ' ') || '|'
3567: || RPAD(nvl(ln_sh_exc_cess_pla,0), 17, ' ') || '|' || RPAD(nvl(ln_sh_exc_cess_pla_cr,0), 14, ' ') || '|' || RPAD(nvl(ln_sh_exc_cess_pla_dr,0), 14, ' ') ||
3568: '|' || RPAD(nvl(ln_sh_exc_cess_pla_final,0), 17, ' ') || '|' || ' ' || '|' || ' ' || '|' ) ;
3569: FND_FILE.PUT_LINE(FND_FILE.LOG, '|' || RPAD(pla_log_rec.organization_id, 17, ' ')|| '|'

Line 3569: FND_FILE.PUT_LINE(FND_FILE.LOG, '|' || RPAD(pla_log_rec.organization_id, 17, ' ')|| '|'

3565: FND_FILE.PUT_LINE(FND_FILE.LOG, '|' || RPAD(pla_log_rec.organization_id, 17, ' ')|| '|'
3566: || RPAD(pla_log_rec.location_id, 13, ' ') || '|' || RPAD('PLA', 15, ' ') || '|' || 'EXCISE_SH_EDU_CESS |'|| RPAD(lv_sh_exc_cess_status, 12, ' ') || '|'
3567: || RPAD(nvl(ln_sh_exc_cess_pla,0), 17, ' ') || '|' || RPAD(nvl(ln_sh_exc_cess_pla_cr,0), 14, ' ') || '|' || RPAD(nvl(ln_sh_exc_cess_pla_dr,0), 14, ' ') ||
3568: '|' || RPAD(nvl(ln_sh_exc_cess_pla_final,0), 17, ' ') || '|' || ' ' || '|' || ' ' || '|' ) ;
3569: FND_FILE.PUT_LINE(FND_FILE.LOG, '|' || RPAD(pla_log_rec.organization_id, 17, ' ')|| '|'
3570: || RPAD(pla_log_rec.location_id, 13, ' ') || '|' || RPAD('PLA', 15, ' ') || '|' || 'CVD_SH_EDU_CESS |'|| RPAD(lv_sh_cvd_cess_status, 12, ' ') || '|'|| RPAD(nvl(ln_sh_cvd_cess_pla,0), 17, ' ') || '|'
3571: || RPAD(nvl(ln_sh_cvd_cess_pla_cr,0), 14, ' ') || '|' || RPAD(nvl(ln_sh_cvd_cess_pla_dr,0), 14, ' ') || '|' ||
3572: RPAD(nvl(ln_sh_cvd_cess_pla_final,0), 17, ' ') || '|' || ' ' || '|' || ' ' || '|' ) ;
3573: FND_FILE.PUT_LINE(FND_FILE.LOG, '------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------' ) ;

Line 3573: FND_FILE.PUT_LINE(FND_FILE.LOG, '------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------' ) ;

3569: FND_FILE.PUT_LINE(FND_FILE.LOG, '|' || RPAD(pla_log_rec.organization_id, 17, ' ')|| '|'
3570: || RPAD(pla_log_rec.location_id, 13, ' ') || '|' || RPAD('PLA', 15, ' ') || '|' || 'CVD_SH_EDU_CESS |'|| RPAD(lv_sh_cvd_cess_status, 12, ' ') || '|'|| RPAD(nvl(ln_sh_cvd_cess_pla,0), 17, ' ') || '|'
3571: || RPAD(nvl(ln_sh_cvd_cess_pla_cr,0), 14, ' ') || '|' || RPAD(nvl(ln_sh_cvd_cess_pla_dr,0), 14, ' ') || '|' ||
3572: RPAD(nvl(ln_sh_cvd_cess_pla_final,0), 17, ' ') || '|' || ' ' || '|' || ' ' || '|' ) ;
3573: FND_FILE.PUT_LINE(FND_FILE.LOG, '------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------' ) ;
3574:
3575: end loop ;
3576:
3577: end if ;

Line 3582: FND_FILE.PUT_LINE(FND_FILE.LOG, '') ;

3578:
3579: if NVL(p_debug, 'N') = 'Y'
3580: then
3581:
3582: FND_FILE.PUT_LINE(FND_FILE.LOG, '') ;
3583: FND_FILE.PUT_LINE(FND_FILE.LOG, '') ;
3584:
3585: FND_FILE.PUT_LINE(FND_FILE.LOG, '| Organization Id |' || ' Location Id |' || ' Register Type |' || ' Fin Year |' || 'Error |' || ' Slno |' || ' Register Id |'
3586: || ' RowCount |' || ' Tax Type |' || ' Date |' || ' Month ' || ' Year ' ) ;

Line 3583: FND_FILE.PUT_LINE(FND_FILE.LOG, '') ;

3579: if NVL(p_debug, 'N') = 'Y'
3580: then
3581:
3582: FND_FILE.PUT_LINE(FND_FILE.LOG, '') ;
3583: FND_FILE.PUT_LINE(FND_FILE.LOG, '') ;
3584:
3585: FND_FILE.PUT_LINE(FND_FILE.LOG, '| Organization Id |' || ' Location Id |' || ' Register Type |' || ' Fin Year |' || 'Error |' || ' Slno |' || ' Register Id |'
3586: || ' RowCount |' || ' Tax Type |' || ' Date |' || ' Month ' || ' Year ' ) ;
3587: FND_FILE.PUT_LINE(FND_FILE.LOG, '| --------------- |' || ' ----------- |' || ' ------------- |' || ' -------- |' || '----- |' || ' ------ |' || ' ----------- |'

Line 3585: FND_FILE.PUT_LINE(FND_FILE.LOG, '| Organization Id |' || ' Location Id |' || ' Register Type |' || ' Fin Year |' || 'Error |' || ' Slno |' || ' Register Id |'

3581:
3582: FND_FILE.PUT_LINE(FND_FILE.LOG, '') ;
3583: FND_FILE.PUT_LINE(FND_FILE.LOG, '') ;
3584:
3585: FND_FILE.PUT_LINE(FND_FILE.LOG, '| Organization Id |' || ' Location Id |' || ' Register Type |' || ' Fin Year |' || 'Error |' || ' Slno |' || ' Register Id |'
3586: || ' RowCount |' || ' Tax Type |' || ' Date |' || ' Month ' || ' Year ' ) ;
3587: FND_FILE.PUT_LINE(FND_FILE.LOG, '| --------------- |' || ' ----------- |' || ' ------------- |' || ' -------- |' || '----- |' || ' ------ |' || ' ----------- |'
3588: || ' -------- |' || ' -------- |' || ' -------- |' || ' ----- ' || ' ---- ' ) ;
3589:

Line 3587: FND_FILE.PUT_LINE(FND_FILE.LOG, '| --------------- |' || ' ----------- |' || ' ------------- |' || ' -------- |' || '----- |' || ' ------ |' || ' ----------- |'

3583: FND_FILE.PUT_LINE(FND_FILE.LOG, '') ;
3584:
3585: FND_FILE.PUT_LINE(FND_FILE.LOG, '| Organization Id |' || ' Location Id |' || ' Register Type |' || ' Fin Year |' || 'Error |' || ' Slno |' || ' Register Id |'
3586: || ' RowCount |' || ' Tax Type |' || ' Date |' || ' Month ' || ' Year ' ) ;
3587: FND_FILE.PUT_LINE(FND_FILE.LOG, '| --------------- |' || ' ----------- |' || ' ------------- |' || ' -------- |' || '----- |' || ' ------ |' || ' ----------- |'
3588: || ' -------- |' || ' -------- |' || ' -------- |' || ' ----- ' || ' ---- ' ) ;
3589:
3590:
3591: for rec in ( select * from JAI_TRX_GT)

Line 3594: FND_FILE.PUT_LINE(FND_FILE.LOG, '|' || RPAD(nvl(to_char(rec.JAI_INFO_N1),' '), 17, ' ')|| '|' || RPAD(nvl(to_char(rec.JAI_INFO_N2),' '), 13, ' ') || '|'

3590:
3591: for rec in ( select * from JAI_TRX_GT)
3592: loop
3593:
3594: FND_FILE.PUT_LINE(FND_FILE.LOG, '|' || RPAD(nvl(to_char(rec.JAI_INFO_N1),' '), 17, ' ')|| '|' || RPAD(nvl(to_char(rec.JAI_INFO_N2),' '), 13, ' ') || '|'
3595: || RPAD(nvl(rec.JAI_INFO_V1,' '), 15, ' ') || '|' || RPAD(nvl(to_char(rec.JAI_INFO_N3),' '), 10, ' ') || '|' || RPAD(nvl(rec.JAI_INFO_V3,' '), 6, ' ') || '|' || RPAD(nvl(to_char(rec.JAI_INFO_N8),' '), 8, ' ')
3596: || '|' || RPAD(nvl(to_char(rec.JAI_INFO_N9),' '), 13, ' ') || '|' || RPAD(nvl(to_char(rec.JAI_INFO_N10),' '), 10, ' ') || '|'
3597: || RPAD(nvl(rec.JAI_INFO_V4,' '), 23, ' ') || '|' || RPAD(nvl(to_char(rec.JAI_INFO_D1),' '), 10, ' ') || '|' || RPAD(nvl(rec.JAI_INFO_V5,' '), 7, ' ') || '|'
3598: || RPAD(nvl(to_char(rec.JAI_INFO_N11),' '), 6, ' ') ) ;

Line 3602: FND_FILE.PUT_LINE(FND_FILE.LOG, '') ;

3598: || RPAD(nvl(to_char(rec.JAI_INFO_N11),' '), 6, ' ') ) ;
3599:
3600: end loop ;
3601:
3602: FND_FILE.PUT_LINE(FND_FILE.LOG, '') ;
3603: FND_FILE.PUT_LINE(FND_FILE.LOG, '') ;
3604:
3605: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Error Code Information ' ) ;
3606: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ---------------------- ' ) ;

Line 3603: FND_FILE.PUT_LINE(FND_FILE.LOG, '') ;

3599:
3600: end loop ;
3601:
3602: FND_FILE.PUT_LINE(FND_FILE.LOG, '') ;
3603: FND_FILE.PUT_LINE(FND_FILE.LOG, '') ;
3604:
3605: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Error Code Information ' ) ;
3606: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ---------------------- ' ) ;
3607:

Line 3605: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Error Code Information ' ) ;

3601:
3602: FND_FILE.PUT_LINE(FND_FILE.LOG, '') ;
3603: FND_FILE.PUT_LINE(FND_FILE.LOG, '') ;
3604:
3605: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Error Code Information ' ) ;
3606: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ---------------------- ' ) ;
3607:
3608:
3609: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E01 : Total transaction amount does not equal the Period balance for the MON and Year ' ) ;

Line 3606: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ---------------------- ' ) ;

3602: FND_FILE.PUT_LINE(FND_FILE.LOG, '') ;
3603: FND_FILE.PUT_LINE(FND_FILE.LOG, '') ;
3604:
3605: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Error Code Information ' ) ;
3606: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ---------------------- ' ) ;
3607:
3608:
3609: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E01 : Total transaction amount does not equal the Period balance for the MON and Year ' ) ;
3610:

Line 3609: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E01 : Total transaction amount does not equal the Period balance for the MON and Year ' ) ;

3605: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Error Code Information ' ) ;
3606: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ---------------------- ' ) ;
3607:
3608:
3609: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E01 : Total transaction amount does not equal the Period balance for the MON and Year ' ) ;
3610:
3611: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E02 : RG23 Opening Balance is not equal to closing balance of previous record ' ) ;
3612:
3613: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E03 : RG23 Closing Balance is not equal to opening balance + Transaction Amount ' ) ;

Line 3611: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E02 : RG23 Opening Balance is not equal to closing balance of previous record ' ) ;

3607:
3608:
3609: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E01 : Total transaction amount does not equal the Period balance for the MON and Year ' ) ;
3610:
3611: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E02 : RG23 Opening Balance is not equal to closing balance of previous record ' ) ;
3612:
3613: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E03 : RG23 Closing Balance is not equal to opening balance + Transaction Amount ' ) ;
3614:
3615: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E04 : PLA Opening Balance is not equal to closing balance of previous record ' ) ;

Line 3613: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E03 : RG23 Closing Balance is not equal to opening balance + Transaction Amount ' ) ;

3609: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E01 : Total transaction amount does not equal the Period balance for the MON and Year ' ) ;
3610:
3611: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E02 : RG23 Opening Balance is not equal to closing balance of previous record ' ) ;
3612:
3613: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E03 : RG23 Closing Balance is not equal to opening balance + Transaction Amount ' ) ;
3614:
3615: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E04 : PLA Opening Balance is not equal to closing balance of previous record ' ) ;
3616:
3617: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E05 : PLA Closing Balance is not equal to opening balance + Transaction Amount ' ) ;

Line 3615: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E04 : PLA Opening Balance is not equal to closing balance of previous record ' ) ;

3611: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E02 : RG23 Opening Balance is not equal to closing balance of previous record ' ) ;
3612:
3613: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E03 : RG23 Closing Balance is not equal to opening balance + Transaction Amount ' ) ;
3614:
3615: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E04 : PLA Opening Balance is not equal to closing balance of previous record ' ) ;
3616:
3617: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E05 : PLA Closing Balance is not equal to opening balance + Transaction Amount ' ) ;
3618:
3619: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E06 : Final balance in JAI_RG_OTH_BALANCE is not equal to Closing Balance of the last record ' ) ;

Line 3617: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E05 : PLA Closing Balance is not equal to opening balance + Transaction Amount ' ) ;

3613: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E03 : RG23 Closing Balance is not equal to opening balance + Transaction Amount ' ) ;
3614:
3615: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E04 : PLA Opening Balance is not equal to closing balance of previous record ' ) ;
3616:
3617: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E05 : PLA Closing Balance is not equal to opening balance + Transaction Amount ' ) ;
3618:
3619: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E06 : Final balance in JAI_RG_OTH_BALANCE is not equal to Closing Balance of the last record ' ) ;
3620:
3621: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E07 : PLA Duplicate Slno ' ) ;

Line 3619: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E06 : Final balance in JAI_RG_OTH_BALANCE is not equal to Closing Balance of the last record ' ) ;

3615: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E04 : PLA Opening Balance is not equal to closing balance of previous record ' ) ;
3616:
3617: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E05 : PLA Closing Balance is not equal to opening balance + Transaction Amount ' ) ;
3618:
3619: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E06 : Final balance in JAI_RG_OTH_BALANCE is not equal to Closing Balance of the last record ' ) ;
3620:
3621: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E07 : PLA Duplicate Slno ' ) ;
3622:
3623: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E08 : JAI_CMN_RG_OTHERS Closing Balance is not equal to Opening Balance + Transaction Amount ' ) ;

Line 3621: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E07 : PLA Duplicate Slno ' ) ;

3617: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E05 : PLA Closing Balance is not equal to opening balance + Transaction Amount ' ) ;
3618:
3619: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E06 : Final balance in JAI_RG_OTH_BALANCE is not equal to Closing Balance of the last record ' ) ;
3620:
3621: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E07 : PLA Duplicate Slno ' ) ;
3622:
3623: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E08 : JAI_CMN_RG_OTHERS Closing Balance is not equal to Opening Balance + Transaction Amount ' ) ;
3624:
3625: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E09 : RG23 Other Tax Credit/Debit is not equal to the sum of credit/debit in JAI_CMN_RG_OTHERS ' ) ;

Line 3623: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E08 : JAI_CMN_RG_OTHERS Closing Balance is not equal to Opening Balance + Transaction Amount ' ) ;

3619: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E06 : Final balance in JAI_RG_OTH_BALANCE is not equal to Closing Balance of the last record ' ) ;
3620:
3621: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E07 : PLA Duplicate Slno ' ) ;
3622:
3623: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E08 : JAI_CMN_RG_OTHERS Closing Balance is not equal to Opening Balance + Transaction Amount ' ) ;
3624:
3625: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E09 : RG23 Other Tax Credit/Debit is not equal to the sum of credit/debit in JAI_CMN_RG_OTHERS ' ) ;
3626:
3627: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E10 : PLA Other Tax Credit/Debit is not equal to the sum of credit/debit in JAI_CMN_RG_OTHERS ' ) ;

Line 3625: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E09 : RG23 Other Tax Credit/Debit is not equal to the sum of credit/debit in JAI_CMN_RG_OTHERS ' ) ;

3621: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E07 : PLA Duplicate Slno ' ) ;
3622:
3623: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E08 : JAI_CMN_RG_OTHERS Closing Balance is not equal to Opening Balance + Transaction Amount ' ) ;
3624:
3625: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E09 : RG23 Other Tax Credit/Debit is not equal to the sum of credit/debit in JAI_CMN_RG_OTHERS ' ) ;
3626:
3627: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E10 : PLA Other Tax Credit/Debit is not equal to the sum of credit/debit in JAI_CMN_RG_OTHERS ' ) ;
3628:
3629: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E11 : RG23 Balance, Slno do not match with JAI_CMN_RG_SLNOS Balance,Slno ' ) ;

Line 3627: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E10 : PLA Other Tax Credit/Debit is not equal to the sum of credit/debit in JAI_CMN_RG_OTHERS ' ) ;

3623: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E08 : JAI_CMN_RG_OTHERS Closing Balance is not equal to Opening Balance + Transaction Amount ' ) ;
3624:
3625: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E09 : RG23 Other Tax Credit/Debit is not equal to the sum of credit/debit in JAI_CMN_RG_OTHERS ' ) ;
3626:
3627: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E10 : PLA Other Tax Credit/Debit is not equal to the sum of credit/debit in JAI_CMN_RG_OTHERS ' ) ;
3628:
3629: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E11 : RG23 Balance, Slno do not match with JAI_CMN_RG_SLNOS Balance,Slno ' ) ;
3630:
3631: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E12 : PLA Balance, Slno do not match with JAI_CMN_RG_SLNOS Balance,Slno ' ) ;

Line 3629: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E11 : RG23 Balance, Slno do not match with JAI_CMN_RG_SLNOS Balance,Slno ' ) ;

3625: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E09 : RG23 Other Tax Credit/Debit is not equal to the sum of credit/debit in JAI_CMN_RG_OTHERS ' ) ;
3626:
3627: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E10 : PLA Other Tax Credit/Debit is not equal to the sum of credit/debit in JAI_CMN_RG_OTHERS ' ) ;
3628:
3629: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E11 : RG23 Balance, Slno do not match with JAI_CMN_RG_SLNOS Balance,Slno ' ) ;
3630:
3631: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E12 : PLA Balance, Slno do not match with JAI_CMN_RG_SLNOS Balance,Slno ' ) ;
3632:
3633: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E13 : RG23 Last record Balance does not match with the balance in JAI_CMN_RG_BALANCES ' ) ;

Line 3631: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E12 : PLA Balance, Slno do not match with JAI_CMN_RG_SLNOS Balance,Slno ' ) ;

3627: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E10 : PLA Other Tax Credit/Debit is not equal to the sum of credit/debit in JAI_CMN_RG_OTHERS ' ) ;
3628:
3629: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E11 : RG23 Balance, Slno do not match with JAI_CMN_RG_SLNOS Balance,Slno ' ) ;
3630:
3631: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E12 : PLA Balance, Slno do not match with JAI_CMN_RG_SLNOS Balance,Slno ' ) ;
3632:
3633: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E13 : RG23 Last record Balance does not match with the balance in JAI_CMN_RG_BALANCES ' ) ;
3634:
3635: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E14 : PLA Last record Balance does not match with the balance in JAI_CMN_RG_BALANCES ' ) ;

Line 3633: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E13 : RG23 Last record Balance does not match with the balance in JAI_CMN_RG_BALANCES ' ) ;

3629: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E11 : RG23 Balance, Slno do not match with JAI_CMN_RG_SLNOS Balance,Slno ' ) ;
3630:
3631: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E12 : PLA Balance, Slno do not match with JAI_CMN_RG_SLNOS Balance,Slno ' ) ;
3632:
3633: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E13 : RG23 Last record Balance does not match with the balance in JAI_CMN_RG_BALANCES ' ) ;
3634:
3635: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E14 : PLA Last record Balance does not match with the balance in JAI_CMN_RG_BALANCES ' ) ;
3636:
3637: if gn_action = 1 then

Line 3635: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E14 : PLA Last record Balance does not match with the balance in JAI_CMN_RG_BALANCES ' ) ;

3631: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E12 : PLA Balance, Slno do not match with JAI_CMN_RG_SLNOS Balance,Slno ' ) ;
3632:
3633: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E13 : RG23 Last record Balance does not match with the balance in JAI_CMN_RG_BALANCES ' ) ;
3634:
3635: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E14 : PLA Last record Balance does not match with the balance in JAI_CMN_RG_BALANCES ' ) ;
3636:
3637: if gn_action = 1 then
3638: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E15 : PLA Total Transaction amount does not match with the balance in JAI_CMN_RG_BALANCES ' ) ;
3639: elsif gn_action = 3 then

Line 3638: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E15 : PLA Total Transaction amount does not match with the balance in JAI_CMN_RG_BALANCES ' ) ;

3634:
3635: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E14 : PLA Last record Balance does not match with the balance in JAI_CMN_RG_BALANCES ' ) ;
3636:
3637: if gn_action = 1 then
3638: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E15 : PLA Total Transaction amount does not match with the balance in JAI_CMN_RG_BALANCES ' ) ;
3639: elsif gn_action = 3 then
3640: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E15 : PLA Total Transaction amount does not match with the balance in JAI_CMN_RG_BALANCES. Manual Intervention is required. ' ) ;
3641: end if ;
3642:

Line 3640: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E15 : PLA Total Transaction amount does not match with the balance in JAI_CMN_RG_BALANCES. Manual Intervention is required. ' ) ;

3636:
3637: if gn_action = 1 then
3638: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E15 : PLA Total Transaction amount does not match with the balance in JAI_CMN_RG_BALANCES ' ) ;
3639: elsif gn_action = 3 then
3640: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E15 : PLA Total Transaction amount does not match with the balance in JAI_CMN_RG_BALANCES. Manual Intervention is required. ' ) ;
3641: end if ;
3642:
3643: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E16 : The Consolidation Amount for rg23 and pla do not match ' ) ;
3644:

Line 3643: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E16 : The Consolidation Amount for rg23 and pla do not match ' ) ;

3639: elsif gn_action = 3 then
3640: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E15 : PLA Total Transaction amount does not match with the balance in JAI_CMN_RG_BALANCES. Manual Intervention is required. ' ) ;
3641: end if ;
3642:
3643: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E16 : The Consolidation Amount for rg23 and pla do not match ' ) ;
3644:
3645: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E17 : The Other Tax Consolidation Amount for rg23 and pla do not match ' ) ;
3646:
3647: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E18 : RG23 Duplicate Slno ' ) ;

Line 3645: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E17 : The Other Tax Consolidation Amount for rg23 and pla do not match ' ) ;

3641: end if ;
3642:
3643: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E16 : The Consolidation Amount for rg23 and pla do not match ' ) ;
3644:
3645: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E17 : The Other Tax Consolidation Amount for rg23 and pla do not match ' ) ;
3646:
3647: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E18 : RG23 Duplicate Slno ' ) ;
3648:
3649: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E19 : JAI_CMN_RG_OTHERS Opening Balance is not equal to the closing balance of the previous record ' ) ;

Line 3647: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E18 : RG23 Duplicate Slno ' ) ;

3643: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E16 : The Consolidation Amount for rg23 and pla do not match ' ) ;
3644:
3645: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E17 : The Other Tax Consolidation Amount for rg23 and pla do not match ' ) ;
3646:
3647: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E18 : RG23 Duplicate Slno ' ) ;
3648:
3649: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E19 : JAI_CMN_RG_OTHERS Opening Balance is not equal to the closing balance of the previous record ' ) ;
3650:
3651: end if ;

Line 3649: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E19 : JAI_CMN_RG_OTHERS Opening Balance is not equal to the closing balance of the previous record ' ) ;

3645: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E17 : The Other Tax Consolidation Amount for rg23 and pla do not match ' ) ;
3646:
3647: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E18 : RG23 Duplicate Slno ' ) ;
3648:
3649: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E19 : JAI_CMN_RG_OTHERS Opening Balance is not equal to the closing balance of the previous record ' ) ;
3650:
3651: end if ;
3652:
3653: exception

Line 3655: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error : ' || SQLERRM ) ;

3651: end if ;
3652:
3653: exception
3654: when others then
3655: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error : ' || SQLERRM ) ;
3656: retcode := 2 ;
3657:
3658: END process_rg_trx;
3659: -----------------------------------------PROCESS_RG_TRX--------------------------------