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 JAI_CMN_RG_BALANCES

Line 759: UPDATE JAI_CMN_RG_BALANCES

755: IF p_tax_type IS NULL THEN
756:
757: IF p_register_type = 'A' THEN
758:
759: UPDATE JAI_CMN_RG_BALANCES
760: SET rg23a_balance = p_closing_balance
761: WHERE organization_id = p_organization_id
762: AND location_id = p_location_id
763: AND rg23a_balance <> p_closing_balance;

Line 768: UPDATE JAI_CMN_RG_BALANCES

764:
765:
766: ELSIF p_register_type = 'C' THEN
767:
768: UPDATE JAI_CMN_RG_BALANCES
769: SET rg23c_balance = p_closing_balance
770: WHERE organization_id = p_organization_id
771: AND location_id = p_location_id
772: AND rg23a_balance <> p_closing_balance;

Line 776: UPDATE JAI_CMN_RG_BALANCES

772: AND rg23a_balance <> p_closing_balance;
773:
774: ELSIF p_register_type = 'PLA' THEN
775:
776: UPDATE JAI_CMN_RG_BALANCES
777: SET pla_balance = p_closing_balance
778: WHERE organization_id = p_organization_id
779: AND location_id = p_location_id
780: AND rg23a_balance <> p_closing_balance;

Line 1387: UPDATE JAI_CMN_RG_BALANCES

1383: END LOOP;
1384:
1385: IF p_register_type = 'A' THEN
1386:
1387: UPDATE JAI_CMN_RG_BALANCES
1388: SET rg23a_balance = ln_prev_balance,
1389: last_updated_by = p_last_updated_by
1390: WHERE organization_id = p_organization_id
1391: AND location_id = p_location_id ;

Line 1401: UPDATE JAI_CMN_RG_BALANCES

1397: AND register_type = 'A' ;
1398:
1399: ELSIF p_register_type = 'C' THEN
1400:
1401: UPDATE JAI_CMN_RG_BALANCES
1402: SET rg23c_balance = ln_prev_balance
1403: WHERE organization_id = p_organization_id
1404: AND location_id = p_location_id ;
1405:

Line 1432: UPDATE JAI_CMN_RG_BALANCES

1428: ln_prev_balance := ln_closing_balance;
1429:
1430: END LOOP;
1431:
1432: UPDATE JAI_CMN_RG_BALANCES
1433: SET pla_balance = ln_prev_balance,
1434: last_updated_by = p_last_updated_by
1435: WHERE organization_id = p_organization_id
1436: AND location_id = p_location_id ;

Line 2206: from JAI_CMN_RG_BALANCES

2202: cp_location_id number,
2203: cp_register_type varchar2 )
2204: is
2205: select decode(cp_register_type, 'A', rg23a_balance, 'C', rg23c_balance, 'PLA', pla_balance)
2206: from JAI_CMN_RG_BALANCES
2207: where organization_id = cp_organization_id
2208: and location_id = cp_location_id ;
2209:
2210: Cursor c_pla_balance(cp_organization_id number,

Line 2561: proceed with the fix : JAI_CMN_RG_23AC_II_TRXS,JAI_CMN_RG_PLA_TRXS ,JAI_CMN_RG_BALANCES ,JAI_CMN_RG_SLNOS ,JAI_CMN_RG_OTHERS ,JAI_CMN_RG_OTH_BALANCES ,JAI_CMN_RG_PERIOD_BALS' ) ;

2557: gn_exists := null ;
2558:
2559: if p_action = 3 and nvl(p_backup,'N') = 'N' then
2560: raise_application_error(-20054, ' Pls take a backup of the following tables from JA before you
2561: proceed with the fix : JAI_CMN_RG_23AC_II_TRXS,JAI_CMN_RG_PLA_TRXS ,JAI_CMN_RG_BALANCES ,JAI_CMN_RG_SLNOS ,JAI_CMN_RG_OTHERS ,JAI_CMN_RG_OTH_BALANCES ,JAI_CMN_RG_PERIOD_BALS' ) ;
2562: end if ;
2563:
2564: open c_check_addl_cvd ;
2565: fetch c_check_addl_cvd into gn_exists ;

Line 2626: -- code to validate balance in JAI_CMN_RG_BALANCES

2622: open c_rg23_balance(rg23_bal_rec.organization_id,rg23_bal_rec.location_id, rg23_bal_rec.register_type) ;
2623: fetch c_rg23_balance into ln_rg23_balance,ln_rg23_slno ;
2624: close c_rg23_balance ;
2625:
2626: -- code to validate balance in JAI_CMN_RG_BALANCES
2627: ln_rg_balance := null ;
2628: open c_rg_balance(rg23_bal_rec.organization_id,rg23_bal_rec.location_id, rg23_bal_rec.register_type) ;
2629: fetch c_rg_balance into ln_rg_balance ;
2630: close c_rg_balance ;

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: