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_CMN_RG_TRANSFER_PKG dependencies on JAI_CMN_UTILS_PKG

Line 440: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Inside jai_cmn_rg_others');

436: v_source_type NUMBER(1);
437: v_slno NUMBER;
438:
439: BEGIN
440: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Inside jai_cmn_rg_others');
441:
442:
443:
444: FOR i in 1..4 LOOP/*Bug 5989740 bduvarag*/

Line 451: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of v_tax_type '||v_tax_type);

447: IF i = 1 AND p_excise_cess_amount is not null THEN /*Added not null condition for bug # 13547511*/
448:
449: v_tax_type := jai_constants.tax_type_exc_edu_cess;
450: v_cess_amount := p_excise_cess_amount;
451: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of v_tax_type '||v_tax_type);
452: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of v_cess_amount '||v_cess_amount);
453:
454: ELSIF i = 2 AND p_cvd_cess_amount is not null THEN /*Added not null condition for bug # 13547511*/
455:

Line 452: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of v_cess_amount '||v_cess_amount);

448:
449: v_tax_type := jai_constants.tax_type_exc_edu_cess;
450: v_cess_amount := p_excise_cess_amount;
451: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of v_tax_type '||v_tax_type);
452: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of v_cess_amount '||v_cess_amount);
453:
454: ELSIF i = 2 AND p_cvd_cess_amount is not null THEN /*Added not null condition for bug # 13547511*/
455:
456: v_tax_type := jai_constants.tax_type_cvd_edu_cess;

Line 458: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of v_tax_type '||v_tax_type);

454: ELSIF i = 2 AND p_cvd_cess_amount is not null THEN /*Added not null condition for bug # 13547511*/
455:
456: v_tax_type := jai_constants.tax_type_cvd_edu_cess;
457: v_cess_amount := p_cvd_cess_amount;
458: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of v_tax_type '||v_tax_type);
459: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of v_cess_amount '||v_cess_amount);
460: /*Bug 5989740 bduvarag start*/
461: ELSIF i = 3 AND p_sh_exc_cess_amount is not null THEN /*Added not null condition for bug # 13547511*/
462:

Line 459: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of v_cess_amount '||v_cess_amount);

455:
456: v_tax_type := jai_constants.tax_type_cvd_edu_cess;
457: v_cess_amount := p_cvd_cess_amount;
458: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of v_tax_type '||v_tax_type);
459: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of v_cess_amount '||v_cess_amount);
460: /*Bug 5989740 bduvarag start*/
461: ELSIF i = 3 AND p_sh_exc_cess_amount is not null THEN /*Added not null condition for bug # 13547511*/
462:
463: v_tax_type := jai_constants.tax_type_sh_exc_edu_cess;

Line 465: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of v_tax_type '||v_tax_type);

461: ELSIF i = 3 AND p_sh_exc_cess_amount is not null THEN /*Added not null condition for bug # 13547511*/
462:
463: v_tax_type := jai_constants.tax_type_sh_exc_edu_cess;
464: v_cess_amount := p_sh_exc_cess_amount;
465: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of v_tax_type '||v_tax_type);
466: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of v_cess_amount '||v_cess_amount);
467:
468: ELSIF i = 4 AND p_sh_cvd_cess_amount is not null THEN /*Added not null condition for bug # 13547511*/
469: v_tax_type := jai_constants.tax_type_sh_cvd_edu_cess;

Line 466: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of v_cess_amount '||v_cess_amount);

462:
463: v_tax_type := jai_constants.tax_type_sh_exc_edu_cess;
464: v_cess_amount := p_sh_exc_cess_amount;
465: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of v_tax_type '||v_tax_type);
466: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of v_cess_amount '||v_cess_amount);
467:
468: ELSIF i = 4 AND p_sh_cvd_cess_amount is not null THEN /*Added not null condition for bug # 13547511*/
469: v_tax_type := jai_constants.tax_type_sh_cvd_edu_cess;
470: v_cess_amount := p_sh_cvd_cess_amount;

Line 471: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of v_tax_type '||v_tax_type);

467:
468: ELSIF i = 4 AND p_sh_cvd_cess_amount is not null THEN /*Added not null condition for bug # 13547511*/
469: v_tax_type := jai_constants.tax_type_sh_cvd_edu_cess;
470: v_cess_amount := p_sh_cvd_cess_amount;
471: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of v_tax_type '||v_tax_type);
472: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of v_cess_amount '||v_cess_amount);
473: /*Bug 5989740 bduvarag end*/
474: END IF;
475:

Line 472: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of v_cess_amount '||v_cess_amount);

468: ELSIF i = 4 AND p_sh_cvd_cess_amount is not null THEN /*Added not null condition for bug # 13547511*/
469: v_tax_type := jai_constants.tax_type_sh_cvd_edu_cess;
470: v_cess_amount := p_sh_cvd_cess_amount;
471: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of v_tax_type '||v_tax_type);
472: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of v_cess_amount '||v_cess_amount);
473: /*Bug 5989740 bduvarag end*/
474: END IF;
475:
476: IF v_cess_amount = 0 THEN

Line 526: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of v_cess_closing_balance '||v_cess_opening_balance);

522: v_source_type := 2;
523:
524: END IF;
525: v_cess_closing_balance := NVL(v_cess_closing_balance,0);/*Bug 5989740 bduvarag*/
526: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of v_cess_closing_balance '||v_cess_opening_balance);
527:
528: IF p_transfer_from_to = 'FROM' THEN
529: v_cess_closing_balance := v_cess_opening_balance - v_cess_amount;
530: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of v_cess_closing_balance '||v_cess_closing_balance);

Line 530: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of v_cess_closing_balance '||v_cess_closing_balance);

526: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of v_cess_closing_balance '||v_cess_opening_balance);
527:
528: IF p_transfer_from_to = 'FROM' THEN
529: v_cess_closing_balance := v_cess_opening_balance - v_cess_amount;
530: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of v_cess_closing_balance '||v_cess_closing_balance);
531:
532: ELSIF p_transfer_from_to = 'TO' THEN
533: v_cess_closing_balance := v_cess_opening_balance + v_cess_amount;
534: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of v_cess_closing_balance '||v_cess_closing_balance);

Line 534: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of v_cess_closing_balance '||v_cess_closing_balance);

530: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of v_cess_closing_balance '||v_cess_closing_balance);
531:
532: ELSIF p_transfer_from_to = 'TO' THEN
533: v_cess_closing_balance := v_cess_opening_balance + v_cess_amount;
534: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of v_cess_closing_balance '||v_cess_closing_balance);
535: END IF;
536:
537: lv_debit:=NULL; --Added for bug#7260552
538: lv_credit:=NULL; --Added for bug#7260552

Line 743: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Inside procedure balance transfer');

739: IF p_register NOT IN ('RG23A','RG23C','PLA') THEN
740: RAISE_APPLICATION_ERROR(-20120, 'Select a Register');
741: END IF;
742:
743: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Inside procedure balance transfer');
744: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of organization_id is '||p_organization_id);
745: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of location_id is '||p_location_id);
746: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of to_organization_id is '||p_to_organization_id);
747: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of to_location_id is '||p_to_location_id);

Line 744: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of organization_id is '||p_organization_id);

740: RAISE_APPLICATION_ERROR(-20120, 'Select a Register');
741: END IF;
742:
743: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Inside procedure balance transfer');
744: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of organization_id is '||p_organization_id);
745: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of location_id is '||p_location_id);
746: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of to_organization_id is '||p_to_organization_id);
747: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of to_location_id is '||p_to_location_id);
748: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of register is '||p_register);

Line 745: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of location_id is '||p_location_id);

741: END IF;
742:
743: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Inside procedure balance transfer');
744: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of organization_id is '||p_organization_id);
745: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of location_id is '||p_location_id);
746: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of to_organization_id is '||p_to_organization_id);
747: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of to_location_id is '||p_to_location_id);
748: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of register is '||p_register);
749: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of basic amount is '||p_amount);

Line 746: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of to_organization_id is '||p_to_organization_id);

742:
743: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Inside procedure balance transfer');
744: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of organization_id is '||p_organization_id);
745: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of location_id is '||p_location_id);
746: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of to_organization_id is '||p_to_organization_id);
747: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of to_location_id is '||p_to_location_id);
748: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of register is '||p_register);
749: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of basic amount is '||p_amount);
750: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of cess amount is '||p_cess_amount);

Line 747: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of to_location_id is '||p_to_location_id);

743: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Inside procedure balance transfer');
744: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of organization_id is '||p_organization_id);
745: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of location_id is '||p_location_id);
746: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of to_organization_id is '||p_to_organization_id);
747: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of to_location_id is '||p_to_location_id);
748: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of register is '||p_register);
749: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of basic amount is '||p_amount);
750: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of cess amount is '||p_cess_amount);
751: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of Shcess amount is '||p_sh_cess_amount);

Line 748: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of register is '||p_register);

744: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of organization_id is '||p_organization_id);
745: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of location_id is '||p_location_id);
746: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of to_organization_id is '||p_to_organization_id);
747: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of to_location_id is '||p_to_location_id);
748: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of register is '||p_register);
749: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of basic amount is '||p_amount);
750: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of cess amount is '||p_cess_amount);
751: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of Shcess amount is '||p_sh_cess_amount);
752:

Line 749: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of basic amount is '||p_amount);

745: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of location_id is '||p_location_id);
746: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of to_organization_id is '||p_to_organization_id);
747: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of to_location_id is '||p_to_location_id);
748: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of register is '||p_register);
749: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of basic amount is '||p_amount);
750: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of cess amount is '||p_cess_amount);
751: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of Shcess amount is '||p_sh_cess_amount);
752:
753:

Line 750: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of cess amount is '||p_cess_amount);

746: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of to_organization_id is '||p_to_organization_id);
747: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of to_location_id is '||p_to_location_id);
748: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of register is '||p_register);
749: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of basic amount is '||p_amount);
750: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of cess amount is '||p_cess_amount);
751: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of Shcess amount is '||p_sh_cess_amount);
752:
753:
754: OPEN c_rg_balances(p_organization_id, p_location_id);

Line 751: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of Shcess amount is '||p_sh_cess_amount);

747: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of to_location_id is '||p_to_location_id);
748: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of register is '||p_register);
749: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of basic amount is '||p_amount);
750: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of cess amount is '||p_cess_amount);
751: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of Shcess amount is '||p_sh_cess_amount);
752:
753:
754: OPEN c_rg_balances(p_organization_id, p_location_id);
755: FETCH c_rg_balances INTO v_rg23a_bal, v_rg23c_bal, v_pla_bal;

Line 758: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of Rg23A bal is '||v_rg23a_bal);

754: OPEN c_rg_balances(p_organization_id, p_location_id);
755: FETCH c_rg_balances INTO v_rg23a_bal, v_rg23c_bal, v_pla_bal;
756: CLOSE c_rg_balances;
757:
758: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of Rg23A bal is '||v_rg23a_bal);
759: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of Rg23c bal is '||v_rg23c_bal);
760: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of PLA bal is '||v_pla_bal);
761:
762:

Line 759: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of Rg23c bal is '||v_rg23c_bal);

755: FETCH c_rg_balances INTO v_rg23a_bal, v_rg23c_bal, v_pla_bal;
756: CLOSE c_rg_balances;
757:
758: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of Rg23A bal is '||v_rg23a_bal);
759: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of Rg23c bal is '||v_rg23c_bal);
760: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of PLA bal is '||v_pla_bal);
761:
762:
763: IF p_register = 'RG23A' THEN

Line 760: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of PLA bal is '||v_pla_bal);

756: CLOSE c_rg_balances;
757:
758: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of Rg23A bal is '||v_rg23a_bal);
759: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of Rg23c bal is '||v_rg23c_bal);
760: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of PLA bal is '||v_pla_bal);
761:
762:
763: IF p_register = 'RG23A' THEN
764: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Going inside conditiom of RG23A');

Line 764: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Going inside conditiom of RG23A');

760: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of PLA bal is '||v_pla_bal);
761:
762:
763: IF p_register = 'RG23A' THEN
764: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Going inside conditiom of RG23A');
765: v_rg23a_bal := nvl(v_rg23a_bal,0) - nvl(p_amount,0);
766: v_check_amount := v_rg23a_bal;
767: v_register := 'A';
768: v_source_register := jai_constants.reg_rg23a_2; --Added by Sanjikum for cess for Bug #4136939

Line 770: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Going inside conditiom of RG23C');

766: v_check_amount := v_rg23a_bal;
767: v_register := 'A';
768: v_source_register := jai_constants.reg_rg23a_2; --Added by Sanjikum for cess for Bug #4136939
769: ELSIF p_register = 'RG23C' THEN
770: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Going inside conditiom of RG23C');
771: v_rg23c_bal := nvl(v_rg23c_bal,0) - nvl(p_amount,0);
772: v_check_amount := v_rg23c_bal;
773: v_register := 'C';
774: v_source_register := jai_constants.reg_rg23c_2; --Added by Sanjikum for cess for Bug #4136939

Line 776: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Going inside conditiom of PLA');

772: v_check_amount := v_rg23c_bal;
773: v_register := 'C';
774: v_source_register := jai_constants.reg_rg23c_2; --Added by Sanjikum for cess for Bug #4136939
775: ELSIF p_register = 'PLA' THEN
776: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Going inside conditiom of PLA');
777: v_pla_bal := nvl(v_pla_bal,0) - nvl(p_amount,0);
778: v_check_amount := v_pla_bal;
779: v_source_register := jai_constants.reg_pla; --Added by Sanjikum for cess for Bug #4136939
780: END IF;

Line 782: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of v_check_amount is '||v_check_amount);

778: v_check_amount := v_pla_bal;
779: v_source_register := jai_constants.reg_pla; --Added by Sanjikum for cess for Bug #4136939
780: END IF;
781:
782: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of v_check_amount is '||v_check_amount);
783: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of v_source_register is '||v_source_register);
784:
785:
786: /* Code commented for bug # 13712605

Line 783: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of v_source_register is '||v_source_register);

779: v_source_register := jai_constants.reg_pla; --Added by Sanjikum for cess for Bug #4136939
780: END IF;
781:
782: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of v_check_amount is '||v_check_amount);
783: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of v_source_register is '||v_source_register);
784:
785:
786: /* Code commented for bug # 13712605
787: IF v_check_amount < 0 THEN

Line 797: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Fetching balnce of oth taxes');

793: --Start Added by Sanjikum for cess for Bug #4136939
794:
795: --Get the total balance, for all cess taxes
796:
797: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Fetching balnce of oth taxes');
798:
799: OPEN c_oth_balances(p_organization_id, p_location_id, p_register);
800: FETCH c_oth_balances INTO v_oth_balances;
801: CLOSE c_oth_balances;

Line 803: --jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Fetching balnce of othtax is'||v_oth_balances);

799: OPEN c_oth_balances(p_organization_id, p_location_id, p_register);
800: FETCH c_oth_balances INTO v_oth_balances;
801: CLOSE c_oth_balances;
802:
803: --jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Fetching balnce of othtax is'||v_oth_balances);
804:
805: /*Code commented for bug # 13712605
806: IF v_oth_balances.balance - NVL(p_cess_amount,0) < 0 THEN
807: RAISE_APPLICATION_ERROR(-20120, 'Amount that you want to transfer will turn your --> ' ||

Line 825: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of v_excise_cess_amount is '||v_excise_cess_amount);

821: v_excise_cess_amount := NVL(p_cess_amount,0);
822: v_cvd_cess_amount := 0;
823: END IF;
824:
825: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of v_excise_cess_amount is '||v_excise_cess_amount);
826: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of v_cvd_cess_amount is '||v_cvd_cess_amount);
827:
828:
829: --End Added by Sanjikum for cess for Bug #4136939

Line 826: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of v_cvd_cess_amount is '||v_cvd_cess_amount);

822: v_cvd_cess_amount := 0;
823: END IF;
824:
825: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of v_excise_cess_amount is '||v_excise_cess_amount);
826: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of v_cvd_cess_amount is '||v_cvd_cess_amount);
827:
828:
829: --End Added by Sanjikum for cess for Bug #4136939
830: /*Bug 5989740 bduvarag start*/

Line 835: --jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of OthSh balance is'||v_sh_oth_balances);

831: OPEN c_sh_oth_balances(p_organization_id, p_location_id, p_register);
832: FETCH c_sh_oth_balances INTO v_sh_oth_balances;
833: CLOSE c_sh_oth_balances;
834:
835: --jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of OthSh balance is'||v_sh_oth_balances);
836:
837:
838: /*Code commented for bug # 13712605
839: IF v_sh_oth_balances.balance - NVL(p_sh_cess_amount,0) < 0 THEN

Line 859: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of v_sh_excise_cess_amount is '||v_sh_excise_cess_amount);

855: v_sh_cvd_cess_amount := 0;
856: END IF;
857: /*Bug 5989740 bduvarag end*/
858:
859: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of v_sh_excise_cess_amount is '||v_sh_excise_cess_amount);
860: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of v_sh_cvd_cess_amount is '||v_sh_cvd_cess_amount);
861:
862:
863: OPEN balances_to_exist;

Line 860: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of v_sh_cvd_cess_amount is '||v_sh_cvd_cess_amount);

856: END IF;
857: /*Bug 5989740 bduvarag end*/
858:
859: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of v_sh_excise_cess_amount is '||v_sh_excise_cess_amount);
860: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of v_sh_cvd_cess_amount is '||v_sh_cvd_cess_amount);
861:
862:
863: OPEN balances_to_exist;
864: FETCH balances_to_exist INTO v_exist;

Line 877: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Checking the balances of the TO org');

873: FETCH c_rg_balances INTO v_to_rg23a_bal, v_to_rg23c_bal, v_to_pla_bal;
874: CLOSE c_rg_balances;
875: END IF;
876:
877: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Checking the balances of the TO org');
878: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of v_to_rg23a_bal'||v_to_rg23a_bal);
879: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of v_to_rg23c_bal'||v_to_rg23c_bal);
880: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of v_to_pla_bal'||v_to_pla_bal);
881:

Line 878: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of v_to_rg23a_bal'||v_to_rg23a_bal);

874: CLOSE c_rg_balances;
875: END IF;
876:
877: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Checking the balances of the TO org');
878: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of v_to_rg23a_bal'||v_to_rg23a_bal);
879: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of v_to_rg23c_bal'||v_to_rg23c_bal);
880: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of v_to_pla_bal'||v_to_pla_bal);
881:
882:

Line 879: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of v_to_rg23c_bal'||v_to_rg23c_bal);

875: END IF;
876:
877: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Checking the balances of the TO org');
878: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of v_to_rg23a_bal'||v_to_rg23a_bal);
879: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of v_to_rg23c_bal'||v_to_rg23c_bal);
880: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of v_to_pla_bal'||v_to_pla_bal);
881:
882:
883: IF p_register = 'RG23A' THEN

Line 880: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of v_to_pla_bal'||v_to_pla_bal);

876:
877: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Checking the balances of the TO org');
878: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of v_to_rg23a_bal'||v_to_rg23a_bal);
879: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of v_to_rg23c_bal'||v_to_rg23c_bal);
880: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of v_to_pla_bal'||v_to_pla_bal);
881:
882:
883: IF p_register = 'RG23A' THEN
884: v_to_rg23a_bal := nvl(v_to_rg23a_bal,0) + nvl(p_amount,0);

Line 908: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Updating the balances of the from org');

904: RAISE_APPLICATION_ERROR(-20119, 'Balances does not exist for From Organization:' ||
905: to_char(p_organization_id) || ' and location:' ||to_char(p_location_id));
906: END IF;
907:
908: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Updating the balances of the from org');
909: UPDATE JAI_CMN_RG_BALANCES
910: SET pla_balance = v_pla_bal,
911: rg23a_balance = v_rg23a_bal,
912: rg23c_balance = v_rg23c_bal

Line 916: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Updating the balances of the TO org');

912: rg23c_balance = v_rg23c_bal
913: WHERE organization_id = p_organization_id
914: and location_id = p_location_id;
915:
916: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Updating the balances of the TO org');
917:
918: UPDATE JAI_CMN_RG_BALANCES
919: SET pla_balance = v_to_pla_bal,
920: rg23a_balance = v_to_rg23a_bal,

Line 929: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Going inside condition of A and C');

925: --No Updates required for Cess balance as, this will be handled through a trigger
926:
927: --Updations for the From Organization
928: IF p_register IN ('RG23A','RG23C') THEN
929: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Going inside condition of A and C');
930: OPEN serial_no_cur(p_organization_id , p_location_id, v_fin_year, v_register);
931: FETCH serial_no_cur INTO v_previous_serial_no;
932: CLOSE serial_no_cur;
933:

Line 971: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Data inserted into JAI_CMN_RG_23AC_II_TRXS');

967: null, SYSDATE, v_user_id, SYSDATE, v_user_id, v_login_id, null, null,lv_reference_num,--rchandan for bug#4428980
968: p_cess_amount+ nvl(p_sh_cess_amount,0) --Added by Sanjikum for cess for Bug #4136939 --Added + nvl(p_sh_cess_amount,0) by JMEENA for bug#7260552
969: ) RETURNING register_id INTO v_from_register_id;
970:
971: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Data inserted into JAI_CMN_RG_23AC_II_TRXS');
972:
973: /*Bug 4543171 bduvarag start*/
974: IF p_register = 'RG23A' THEN
975:

Line 1061: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Calling procedure insert_rg_others for A and C');

1057: END IF;
1058:
1059: /*Bug 4543171 bduvarag end*/
1060: --Added by Sanjikum for cess for Bug #4136939
1061: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Calling procedure insert_rg_others for A and C');
1062: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of organization_id '||p_organization_id);
1063: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_location_id '||p_location_id);
1064: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_register_type '||v_register);
1065: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_excise_cess_amount '||v_excise_cess_amount);

Line 1062: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of organization_id '||p_organization_id);

1058:
1059: /*Bug 4543171 bduvarag end*/
1060: --Added by Sanjikum for cess for Bug #4136939
1061: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Calling procedure insert_rg_others for A and C');
1062: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of organization_id '||p_organization_id);
1063: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_location_id '||p_location_id);
1064: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_register_type '||v_register);
1065: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_excise_cess_amount '||v_excise_cess_amount);
1066: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_sh_exc_cess_amount '||v_sh_excise_cess_amount);

Line 1063: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_location_id '||p_location_id);

1059: /*Bug 4543171 bduvarag end*/
1060: --Added by Sanjikum for cess for Bug #4136939
1061: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Calling procedure insert_rg_others for A and C');
1062: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of organization_id '||p_organization_id);
1063: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_location_id '||p_location_id);
1064: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_register_type '||v_register);
1065: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_excise_cess_amount '||v_excise_cess_amount);
1066: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_sh_exc_cess_amount '||v_sh_excise_cess_amount);
1067: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_sh_cvd_cess_amount '||v_sh_cvd_cess_amount);

Line 1064: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_register_type '||v_register);

1060: --Added by Sanjikum for cess for Bug #4136939
1061: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Calling procedure insert_rg_others for A and C');
1062: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of organization_id '||p_organization_id);
1063: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_location_id '||p_location_id);
1064: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_register_type '||v_register);
1065: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_excise_cess_amount '||v_excise_cess_amount);
1066: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_sh_exc_cess_amount '||v_sh_excise_cess_amount);
1067: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_sh_cvd_cess_amount '||v_sh_cvd_cess_amount);
1068: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_cvd_cess_amount '||v_cvd_cess_amount);

Line 1065: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_excise_cess_amount '||v_excise_cess_amount);

1061: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Calling procedure insert_rg_others for A and C');
1062: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of organization_id '||p_organization_id);
1063: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_location_id '||p_location_id);
1064: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_register_type '||v_register);
1065: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_excise_cess_amount '||v_excise_cess_amount);
1066: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_sh_exc_cess_amount '||v_sh_excise_cess_amount);
1067: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_sh_cvd_cess_amount '||v_sh_cvd_cess_amount);
1068: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_cvd_cess_amount '||v_cvd_cess_amount);
1069: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of source is FROM');

Line 1066: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_sh_exc_cess_amount '||v_sh_excise_cess_amount);

1062: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of organization_id '||p_organization_id);
1063: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_location_id '||p_location_id);
1064: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_register_type '||v_register);
1065: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_excise_cess_amount '||v_excise_cess_amount);
1066: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_sh_exc_cess_amount '||v_sh_excise_cess_amount);
1067: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_sh_cvd_cess_amount '||v_sh_cvd_cess_amount);
1068: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_cvd_cess_amount '||v_cvd_cess_amount);
1069: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of source is FROM');
1070: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of register_id is '||v_from_register_id);

Line 1067: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_sh_cvd_cess_amount '||v_sh_cvd_cess_amount);

1063: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_location_id '||p_location_id);
1064: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_register_type '||v_register);
1065: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_excise_cess_amount '||v_excise_cess_amount);
1066: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_sh_exc_cess_amount '||v_sh_excise_cess_amount);
1067: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_sh_cvd_cess_amount '||v_sh_cvd_cess_amount);
1068: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_cvd_cess_amount '||v_cvd_cess_amount);
1069: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of source is FROM');
1070: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of register_id is '||v_from_register_id);
1071:

Line 1068: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_cvd_cess_amount '||v_cvd_cess_amount);

1064: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_register_type '||v_register);
1065: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_excise_cess_amount '||v_excise_cess_amount);
1066: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_sh_exc_cess_amount '||v_sh_excise_cess_amount);
1067: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_sh_cvd_cess_amount '||v_sh_cvd_cess_amount);
1068: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_cvd_cess_amount '||v_cvd_cess_amount);
1069: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of source is FROM');
1070: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of register_id is '||v_from_register_id);
1071:
1072: insert_rg_others( p_organization_id => p_organization_id,

Line 1069: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of source is FROM');

1065: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_excise_cess_amount '||v_excise_cess_amount);
1066: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_sh_exc_cess_amount '||v_sh_excise_cess_amount);
1067: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_sh_cvd_cess_amount '||v_sh_cvd_cess_amount);
1068: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_cvd_cess_amount '||v_cvd_cess_amount);
1069: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of source is FROM');
1070: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of register_id is '||v_from_register_id);
1071:
1072: insert_rg_others( p_organization_id => p_organization_id,
1073: p_location_id => p_location_id,

Line 1070: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of register_id is '||v_from_register_id);

1066: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_sh_exc_cess_amount '||v_sh_excise_cess_amount);
1067: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_sh_cvd_cess_amount '||v_sh_cvd_cess_amount);
1068: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_cvd_cess_amount '||v_cvd_cess_amount);
1069: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of source is FROM');
1070: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of register_id is '||v_from_register_id);
1071:
1072: insert_rg_others( p_organization_id => p_organization_id,
1073: p_location_id => p_location_id,
1074: p_register_type => v_register,

Line 1174: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Calling procedure insert_rg_others for PLA ');

1170:
1171: /*Bug 4543171 bduvarag end*/
1172: --Added by Sanjikum for cess for Bug #4136939
1173:
1174: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Calling procedure insert_rg_others for PLA ');
1175: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of organization_id '||p_organization_id);
1176: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_location_id '||p_location_id);
1177: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_register_type '||'PLA');
1178: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_excise_cess_amount '||v_excise_cess_amount);

Line 1175: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of organization_id '||p_organization_id);

1171: /*Bug 4543171 bduvarag end*/
1172: --Added by Sanjikum for cess for Bug #4136939
1173:
1174: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Calling procedure insert_rg_others for PLA ');
1175: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of organization_id '||p_organization_id);
1176: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_location_id '||p_location_id);
1177: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_register_type '||'PLA');
1178: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_excise_cess_amount '||v_excise_cess_amount);
1179: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_sh_exc_cess_amount '||v_sh_excise_cess_amount);

Line 1176: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_location_id '||p_location_id);

1172: --Added by Sanjikum for cess for Bug #4136939
1173:
1174: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Calling procedure insert_rg_others for PLA ');
1175: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of organization_id '||p_organization_id);
1176: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_location_id '||p_location_id);
1177: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_register_type '||'PLA');
1178: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_excise_cess_amount '||v_excise_cess_amount);
1179: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_sh_exc_cess_amount '||v_sh_excise_cess_amount);
1180: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_sh_cvd_cess_amount '||v_sh_cvd_cess_amount);

Line 1177: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_register_type '||'PLA');

1173:
1174: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Calling procedure insert_rg_others for PLA ');
1175: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of organization_id '||p_organization_id);
1176: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_location_id '||p_location_id);
1177: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_register_type '||'PLA');
1178: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_excise_cess_amount '||v_excise_cess_amount);
1179: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_sh_exc_cess_amount '||v_sh_excise_cess_amount);
1180: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_sh_cvd_cess_amount '||v_sh_cvd_cess_amount);
1181: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_cvd_cess_amount '||v_cvd_cess_amount);

Line 1178: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_excise_cess_amount '||v_excise_cess_amount);

1174: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Calling procedure insert_rg_others for PLA ');
1175: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of organization_id '||p_organization_id);
1176: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_location_id '||p_location_id);
1177: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_register_type '||'PLA');
1178: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_excise_cess_amount '||v_excise_cess_amount);
1179: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_sh_exc_cess_amount '||v_sh_excise_cess_amount);
1180: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_sh_cvd_cess_amount '||v_sh_cvd_cess_amount);
1181: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_cvd_cess_amount '||v_cvd_cess_amount);
1182: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of source is FROM');

Line 1179: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_sh_exc_cess_amount '||v_sh_excise_cess_amount);

1175: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of organization_id '||p_organization_id);
1176: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_location_id '||p_location_id);
1177: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_register_type '||'PLA');
1178: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_excise_cess_amount '||v_excise_cess_amount);
1179: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_sh_exc_cess_amount '||v_sh_excise_cess_amount);
1180: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_sh_cvd_cess_amount '||v_sh_cvd_cess_amount);
1181: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_cvd_cess_amount '||v_cvd_cess_amount);
1182: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of source is FROM');
1183: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of register_id is '||v_from_register_id);

Line 1180: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_sh_cvd_cess_amount '||v_sh_cvd_cess_amount);

1176: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_location_id '||p_location_id);
1177: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_register_type '||'PLA');
1178: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_excise_cess_amount '||v_excise_cess_amount);
1179: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_sh_exc_cess_amount '||v_sh_excise_cess_amount);
1180: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_sh_cvd_cess_amount '||v_sh_cvd_cess_amount);
1181: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_cvd_cess_amount '||v_cvd_cess_amount);
1182: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of source is FROM');
1183: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of register_id is '||v_from_register_id);
1184:

Line 1181: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_cvd_cess_amount '||v_cvd_cess_amount);

1177: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_register_type '||'PLA');
1178: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_excise_cess_amount '||v_excise_cess_amount);
1179: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_sh_exc_cess_amount '||v_sh_excise_cess_amount);
1180: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_sh_cvd_cess_amount '||v_sh_cvd_cess_amount);
1181: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_cvd_cess_amount '||v_cvd_cess_amount);
1182: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of source is FROM');
1183: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of register_id is '||v_from_register_id);
1184:
1185: insert_rg_others( p_organization_id => p_organization_id,

Line 1182: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of source is FROM');

1178: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_excise_cess_amount '||v_excise_cess_amount);
1179: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_sh_exc_cess_amount '||v_sh_excise_cess_amount);
1180: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_sh_cvd_cess_amount '||v_sh_cvd_cess_amount);
1181: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_cvd_cess_amount '||v_cvd_cess_amount);
1182: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of source is FROM');
1183: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of register_id is '||v_from_register_id);
1184:
1185: insert_rg_others( p_organization_id => p_organization_id,
1186: p_location_id => p_location_id,

Line 1183: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of register_id is '||v_from_register_id);

1179: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_sh_exc_cess_amount '||v_sh_excise_cess_amount);
1180: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_sh_cvd_cess_amount '||v_sh_cvd_cess_amount);
1181: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_cvd_cess_amount '||v_cvd_cess_amount);
1182: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of source is FROM');
1183: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of register_id is '||v_from_register_id);
1184:
1185: insert_rg_others( p_organization_id => p_organization_id,
1186: p_location_id => p_location_id,
1187: p_register_type => 'PLA',

Line 1206: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Updation of registers for the TO org');

1202: END IF;
1203:
1204: --- RG Register Updation starts here for TO Organization
1205:
1206: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Updation of registers for the TO org');
1207: IF p_register IN ('RG23A','RG23C') THEN
1208: OPEN c_rg23_fin_yr(p_to_organization_id , p_to_location_id, v_register);
1209: FETCH c_rg23_fin_yr INTO v_to_fin_year;
1210: CLOSE c_rg23_fin_yr;

Line 1378: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Calling procedure insert_rg_others for A and C');

1374: /*Bug 4543171 bduvarag end*/
1375:
1376: --Added by Sanjikum for cess for Bug #4136939
1377:
1378: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Calling procedure insert_rg_others for A and C');
1379: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of organization_id '||p_to_organization_id);
1380: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_location_id '||p_to_location_id);
1381: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_register_type '||v_register);
1382: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_excise_cess_amount '||v_excise_cess_amount);

Line 1379: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of organization_id '||p_to_organization_id);

1375:
1376: --Added by Sanjikum for cess for Bug #4136939
1377:
1378: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Calling procedure insert_rg_others for A and C');
1379: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of organization_id '||p_to_organization_id);
1380: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_location_id '||p_to_location_id);
1381: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_register_type '||v_register);
1382: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_excise_cess_amount '||v_excise_cess_amount);
1383: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_sh_exc_cess_amount '||v_sh_excise_cess_amount);

Line 1380: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_location_id '||p_to_location_id);

1376: --Added by Sanjikum for cess for Bug #4136939
1377:
1378: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Calling procedure insert_rg_others for A and C');
1379: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of organization_id '||p_to_organization_id);
1380: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_location_id '||p_to_location_id);
1381: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_register_type '||v_register);
1382: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_excise_cess_amount '||v_excise_cess_amount);
1383: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_sh_exc_cess_amount '||v_sh_excise_cess_amount);
1384: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_sh_cvd_cess_amount '||v_sh_cvd_cess_amount);

Line 1381: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_register_type '||v_register);

1377:
1378: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Calling procedure insert_rg_others for A and C');
1379: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of organization_id '||p_to_organization_id);
1380: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_location_id '||p_to_location_id);
1381: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_register_type '||v_register);
1382: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_excise_cess_amount '||v_excise_cess_amount);
1383: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_sh_exc_cess_amount '||v_sh_excise_cess_amount);
1384: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_sh_cvd_cess_amount '||v_sh_cvd_cess_amount);
1385: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_cvd_cess_amount '||v_cvd_cess_amount);

Line 1382: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_excise_cess_amount '||v_excise_cess_amount);

1378: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Calling procedure insert_rg_others for A and C');
1379: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of organization_id '||p_to_organization_id);
1380: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_location_id '||p_to_location_id);
1381: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_register_type '||v_register);
1382: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_excise_cess_amount '||v_excise_cess_amount);
1383: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_sh_exc_cess_amount '||v_sh_excise_cess_amount);
1384: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_sh_cvd_cess_amount '||v_sh_cvd_cess_amount);
1385: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_cvd_cess_amount '||v_cvd_cess_amount);
1386: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of source is TO');

Line 1383: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_sh_exc_cess_amount '||v_sh_excise_cess_amount);

1379: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of organization_id '||p_to_organization_id);
1380: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_location_id '||p_to_location_id);
1381: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_register_type '||v_register);
1382: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_excise_cess_amount '||v_excise_cess_amount);
1383: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_sh_exc_cess_amount '||v_sh_excise_cess_amount);
1384: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_sh_cvd_cess_amount '||v_sh_cvd_cess_amount);
1385: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_cvd_cess_amount '||v_cvd_cess_amount);
1386: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of source is TO');
1387: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of register_id is '||v_to_register_id);

Line 1384: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_sh_cvd_cess_amount '||v_sh_cvd_cess_amount);

1380: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_location_id '||p_to_location_id);
1381: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_register_type '||v_register);
1382: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_excise_cess_amount '||v_excise_cess_amount);
1383: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_sh_exc_cess_amount '||v_sh_excise_cess_amount);
1384: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_sh_cvd_cess_amount '||v_sh_cvd_cess_amount);
1385: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_cvd_cess_amount '||v_cvd_cess_amount);
1386: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of source is TO');
1387: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of register_id is '||v_to_register_id);
1388:

Line 1385: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_cvd_cess_amount '||v_cvd_cess_amount);

1381: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_register_type '||v_register);
1382: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_excise_cess_amount '||v_excise_cess_amount);
1383: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_sh_exc_cess_amount '||v_sh_excise_cess_amount);
1384: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_sh_cvd_cess_amount '||v_sh_cvd_cess_amount);
1385: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_cvd_cess_amount '||v_cvd_cess_amount);
1386: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of source is TO');
1387: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of register_id is '||v_to_register_id);
1388:
1389: insert_rg_others( p_organization_id => p_to_organization_id,

Line 1386: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of source is TO');

1382: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_excise_cess_amount '||v_excise_cess_amount);
1383: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_sh_exc_cess_amount '||v_sh_excise_cess_amount);
1384: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_sh_cvd_cess_amount '||v_sh_cvd_cess_amount);
1385: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_cvd_cess_amount '||v_cvd_cess_amount);
1386: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of source is TO');
1387: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of register_id is '||v_to_register_id);
1388:
1389: insert_rg_others( p_organization_id => p_to_organization_id,
1390: p_location_id => p_to_location_id,

Line 1387: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of register_id is '||v_to_register_id);

1383: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_sh_exc_cess_amount '||v_sh_excise_cess_amount);
1384: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_sh_cvd_cess_amount '||v_sh_cvd_cess_amount);
1385: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_cvd_cess_amount '||v_cvd_cess_amount);
1386: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of source is TO');
1387: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of register_id is '||v_to_register_id);
1388:
1389: insert_rg_others( p_organization_id => p_to_organization_id,
1390: p_location_id => p_to_location_id,
1391: p_register_type => v_register,

Line 1505: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Calling procedure insert_rg_others for PLA ');

1501: END IF ;
1502:
1503: /*Bug 4543171 bduvarag end*/
1504: --Added by Sanjikum for cess for Bug #4136939
1505: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Calling procedure insert_rg_others for PLA ');
1506: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of organization_id '||p_to_organization_id);
1507: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_location_id '||p_to_location_id);
1508: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_register_type '||'PLA');
1509: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_excise_cess_amount '||v_excise_cess_amount);

Line 1506: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of organization_id '||p_to_organization_id);

1502:
1503: /*Bug 4543171 bduvarag end*/
1504: --Added by Sanjikum for cess for Bug #4136939
1505: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Calling procedure insert_rg_others for PLA ');
1506: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of organization_id '||p_to_organization_id);
1507: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_location_id '||p_to_location_id);
1508: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_register_type '||'PLA');
1509: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_excise_cess_amount '||v_excise_cess_amount);
1510: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_sh_exc_cess_amount '||v_sh_excise_cess_amount);

Line 1507: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_location_id '||p_to_location_id);

1503: /*Bug 4543171 bduvarag end*/
1504: --Added by Sanjikum for cess for Bug #4136939
1505: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Calling procedure insert_rg_others for PLA ');
1506: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of organization_id '||p_to_organization_id);
1507: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_location_id '||p_to_location_id);
1508: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_register_type '||'PLA');
1509: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_excise_cess_amount '||v_excise_cess_amount);
1510: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_sh_exc_cess_amount '||v_sh_excise_cess_amount);
1511: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_sh_cvd_cess_amount '||v_sh_cvd_cess_amount);

Line 1508: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_register_type '||'PLA');

1504: --Added by Sanjikum for cess for Bug #4136939
1505: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Calling procedure insert_rg_others for PLA ');
1506: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of organization_id '||p_to_organization_id);
1507: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_location_id '||p_to_location_id);
1508: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_register_type '||'PLA');
1509: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_excise_cess_amount '||v_excise_cess_amount);
1510: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_sh_exc_cess_amount '||v_sh_excise_cess_amount);
1511: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_sh_cvd_cess_amount '||v_sh_cvd_cess_amount);
1512: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_cvd_cess_amount '||v_cvd_cess_amount);

Line 1509: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_excise_cess_amount '||v_excise_cess_amount);

1505: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Calling procedure insert_rg_others for PLA ');
1506: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of organization_id '||p_to_organization_id);
1507: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_location_id '||p_to_location_id);
1508: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_register_type '||'PLA');
1509: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_excise_cess_amount '||v_excise_cess_amount);
1510: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_sh_exc_cess_amount '||v_sh_excise_cess_amount);
1511: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_sh_cvd_cess_amount '||v_sh_cvd_cess_amount);
1512: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_cvd_cess_amount '||v_cvd_cess_amount);
1513: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of source is TO');

Line 1510: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_sh_exc_cess_amount '||v_sh_excise_cess_amount);

1506: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of organization_id '||p_to_organization_id);
1507: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_location_id '||p_to_location_id);
1508: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_register_type '||'PLA');
1509: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_excise_cess_amount '||v_excise_cess_amount);
1510: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_sh_exc_cess_amount '||v_sh_excise_cess_amount);
1511: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_sh_cvd_cess_amount '||v_sh_cvd_cess_amount);
1512: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_cvd_cess_amount '||v_cvd_cess_amount);
1513: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of source is TO');
1514: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of register_id is '||v_to_register_id);

Line 1511: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_sh_cvd_cess_amount '||v_sh_cvd_cess_amount);

1507: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_location_id '||p_to_location_id);
1508: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_register_type '||'PLA');
1509: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_excise_cess_amount '||v_excise_cess_amount);
1510: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_sh_exc_cess_amount '||v_sh_excise_cess_amount);
1511: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_sh_cvd_cess_amount '||v_sh_cvd_cess_amount);
1512: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_cvd_cess_amount '||v_cvd_cess_amount);
1513: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of source is TO');
1514: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of register_id is '||v_to_register_id);
1515:

Line 1512: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_cvd_cess_amount '||v_cvd_cess_amount);

1508: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_register_type '||'PLA');
1509: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_excise_cess_amount '||v_excise_cess_amount);
1510: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_sh_exc_cess_amount '||v_sh_excise_cess_amount);
1511: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_sh_cvd_cess_amount '||v_sh_cvd_cess_amount);
1512: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_cvd_cess_amount '||v_cvd_cess_amount);
1513: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of source is TO');
1514: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of register_id is '||v_to_register_id);
1515:
1516: insert_rg_others( p_organization_id => p_to_organization_id,

Line 1513: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of source is TO');

1509: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_excise_cess_amount '||v_excise_cess_amount);
1510: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_sh_exc_cess_amount '||v_sh_excise_cess_amount);
1511: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_sh_cvd_cess_amount '||v_sh_cvd_cess_amount);
1512: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_cvd_cess_amount '||v_cvd_cess_amount);
1513: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of source is TO');
1514: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of register_id is '||v_to_register_id);
1515:
1516: insert_rg_others( p_organization_id => p_to_organization_id,
1517: p_location_id => p_to_location_id,

Line 1514: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of register_id is '||v_to_register_id);

1510: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_sh_exc_cess_amount '||v_sh_excise_cess_amount);
1511: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_sh_cvd_cess_amount '||v_sh_cvd_cess_amount);
1512: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of p_cvd_cess_amount '||v_cvd_cess_amount);
1513: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of source is TO');
1514: jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Value of register_id is '||v_to_register_id);
1515:
1516: insert_rg_others( p_organization_id => p_to_organization_id,
1517: p_location_id => p_to_location_id,
1518: p_register_type => 'PLA',