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_RGM_TAX_DIST_PKG dependencies on JAI_CONSTANTS

Line 240: AND register_type IN (jai_constants.reg_rg23a ,jai_constants.reg_rg23c)--rchandan for bug#4428980

236: CURSOR c_cess_balance (cp_org_unit_id number) is
237: SELECT SUM(balance)
238: FROM JAI_CMN_RG_OTH_BALANCES
239: WHERE org_unit_id = cp_org_unit_id
240: AND register_type IN (jai_constants.reg_rg23a ,jai_constants.reg_rg23c)--rchandan for bug#4428980
241: AND tax_type IN (jai_constants.tax_type_cvd_edu_cess,jai_constants.tax_type_exc_edu_cess);--rchandan for bug#4428980
242: ln_cess_balance number :=0;
243: /* Bug 4568078. Added by Lakshmi Gopalsami */
244:

Line 241: AND tax_type IN (jai_constants.tax_type_cvd_edu_cess,jai_constants.tax_type_exc_edu_cess);--rchandan for bug#4428980

237: SELECT SUM(balance)
238: FROM JAI_CMN_RG_OTH_BALANCES
239: WHERE org_unit_id = cp_org_unit_id
240: AND register_type IN (jai_constants.reg_rg23a ,jai_constants.reg_rg23c)--rchandan for bug#4428980
241: AND tax_type IN (jai_constants.tax_type_cvd_edu_cess,jai_constants.tax_type_exc_edu_cess);--rchandan for bug#4428980
242: ln_cess_balance number :=0;
243: /* Bug 4568078. Added by Lakshmi Gopalsami */
244:
245: CURSOR c_pla_cess_balance (cp_org_unit_id number) is

Line 249: AND register_type = jai_constants.reg_pla

245: CURSOR c_pla_cess_balance (cp_org_unit_id number) is
246: SELECT SUM(balance)
247: FROM JAI_CMN_RG_OTH_BALANCES
248: WHERE org_unit_id = cp_org_unit_id
249: AND register_type = jai_constants.reg_pla
250: AND tax_type IN (jai_constants.tax_type_cvd_edu_cess,jai_constants.tax_type_exc_edu_cess) ;
251:
252: --added by csahoo for bug#6109941, start
253: CURSOR c_sh_cess_balance (cp_org_unit_id number) is

Line 250: AND tax_type IN (jai_constants.tax_type_cvd_edu_cess,jai_constants.tax_type_exc_edu_cess) ;

246: SELECT SUM(balance)
247: FROM JAI_CMN_RG_OTH_BALANCES
248: WHERE org_unit_id = cp_org_unit_id
249: AND register_type = jai_constants.reg_pla
250: AND tax_type IN (jai_constants.tax_type_cvd_edu_cess,jai_constants.tax_type_exc_edu_cess) ;
251:
252: --added by csahoo for bug#6109941, start
253: CURSOR c_sh_cess_balance (cp_org_unit_id number) is
254: SELECT SUM(balance)

Line 257: AND register_type IN (jai_constants.reg_rg23a ,jai_constants.reg_rg23c)

253: CURSOR c_sh_cess_balance (cp_org_unit_id number) is
254: SELECT SUM(balance)
255: FROM JAI_CMN_RG_OTH_BALANCES
256: WHERE org_unit_id = cp_org_unit_id
257: AND register_type IN (jai_constants.reg_rg23a ,jai_constants.reg_rg23c)
258: AND tax_type IN (jai_constants.tax_type_sh_cvd_edu_cess,jai_constants.tax_type_sh_exc_edu_cess);
259:
260:
261:

Line 258: AND tax_type IN (jai_constants.tax_type_sh_cvd_edu_cess,jai_constants.tax_type_sh_exc_edu_cess);

254: SELECT SUM(balance)
255: FROM JAI_CMN_RG_OTH_BALANCES
256: WHERE org_unit_id = cp_org_unit_id
257: AND register_type IN (jai_constants.reg_rg23a ,jai_constants.reg_rg23c)
258: AND tax_type IN (jai_constants.tax_type_sh_cvd_edu_cess,jai_constants.tax_type_sh_exc_edu_cess);
259:
260:
261:
262: CURSOR c_sh_pla_cess_balance (cp_org_unit_id number) is

Line 266: AND register_type = jai_constants.reg_pla

262: CURSOR c_sh_pla_cess_balance (cp_org_unit_id number) is
263: SELECT SUM(balance)
264: FROM JAI_CMN_RG_OTH_BALANCES
265: WHERE org_unit_id = cp_org_unit_id
266: AND register_type = jai_constants.reg_pla
267: AND tax_type IN (jai_constants.tax_type_sh_cvd_edu_cess,jai_constants.tax_type_sh_exc_edu_cess) ;
268:
269: ln_sh_cess_balance number :=0;
270: ln_sh_pla_cess_balance NUMBER :=0;

Line 267: AND tax_type IN (jai_constants.tax_type_sh_cvd_edu_cess,jai_constants.tax_type_sh_exc_edu_cess) ;

263: SELECT SUM(balance)
264: FROM JAI_CMN_RG_OTH_BALANCES
265: WHERE org_unit_id = cp_org_unit_id
266: AND register_type = jai_constants.reg_pla
267: AND tax_type IN (jai_constants.tax_type_sh_cvd_edu_cess,jai_constants.tax_type_sh_exc_edu_cess) ;
268:
269: ln_sh_cess_balance number :=0;
270: ln_sh_pla_cess_balance NUMBER :=0;
271: ln_sh_debit_amt NUMBER :=0;

Line 452: ELSIF lv_regime = jai_constants.tcs_regime THEN

448: )
449: AND trunc(transaction_date) BETWEEN nvl(jai_cmn_rgm_settlement_pkg.get_last_settlement_date(p_regime_id,organization_id,location_id),g_start_date) AND p_balance_date
450: AND settlement_id IS NULL;
451:
452: ELSIF lv_regime = jai_constants.tcs_regime THEN
453: UPDATE JAI_RGM_REFS_ALL
454: SET SETTLEMENT_ID = P_SETTLEMENT_ID
455: WHERE ORG_TAN_NO = P_TAN_NO AND
456: ITEM_CLASSIFICATION = P_ITEM_CLASSIFICATION AND

Line 706: IF lv_regime_code = jai_constants.service_regime THEN

702: FETCH c_regime_code INTO lv_regime_code;
703: CLOSE c_regime_code;
704:
705: IF p_called_from = 'SETTLEMENT' THEN
706: IF lv_regime_code = jai_constants.service_regime THEN
707: lv_source_trx_type := 'Invoice Payment';--rchandan for bug#4428980
708: FOR delta_rec in
709: (
710: SELECT a.organization_id ,

Line 815: ELSIF lv_regime_code = jai_constants.vat_regime THEN /* 4245365*/

811: p_balance_date => p_balance_date,
812: p_location_id => p_location_id, /*Bug 5879769 bduvarag*/
813: p_org_id => p_org_id /*added by ssawant for bug 5662296*/
814: );
815: ELSIF lv_regime_code = jai_constants.vat_regime THEN /* 4245365*/
816: /*Even though VAT is for IO , balances are calculated similar to an OU. i.e from
817: jai_rgm_trx_records. hence the implementation is done in this procedure only*/
818: lv_source_trx_type := 'Invoice Payment';--rchandan for bug#4428980
819: FOR delta_rec in

Line 946: AND registration_type = jai_constants.regn_type_tax_types

942: FROM jai_rgm_org_regns_v
943: WHERE organization_id = p_org_id
944: AND location_id = p_location_id
945: AND organization_type = p_org_type
946: AND registration_type = jai_constants.regn_type_tax_types
947: AND regime_code = lv_regime_code
948: )
949: LOOP
950:

Line 1094: IF LV_REGIME_CODE = JAI_CONSTANTS.TCS_REGIME THEN

1090: OPEN C_REGIME_CODE;
1091: FETCH C_REGIME_CODE INTO LV_REGIME_CODE;
1092: CLOSE C_REGIME_CODE;
1093:
1094: IF LV_REGIME_CODE = JAI_CONSTANTS.TCS_REGIME THEN
1095: FOR DELTA_REC IN
1096: (
1097: SELECT SUM(DECODE(SIGN(JRT.TAX_AMT),-1,-1 * JRT.TAX_AMT,1,0)) CREDIT_AMOUNT,
1098: SUM(DECODE(SIGN(JRT.TAX_AMT),1,JRT.TAX_AMT,-1,0)) DEBIT_AMOUNT,

Line 1181: IF LV_REGIME_CODE = JAI_CONSTANTS.TCS_REGIME THEN

1177: -- CURSOR AND CALCULATE RGM BALANCES IS ADDED TO PROVIDE TCS FUNCTIONALITY
1178: OPEN CUR_REGIME_CODE( P_REGIME_ID);
1179: FETCH CUR_REGIME_CODE INTO LV_REGIME_CODE;
1180: CLOSE CUR_REGIME_CODE;
1181: IF LV_REGIME_CODE = JAI_CONSTANTS.TCS_REGIME THEN
1182: calculate_rgm_balances( p_regime_id => p_regime_id ,
1183: p_balance_date => p_balance_date ,
1184: p_request_id => p_request_id ,
1185: p_org_id => p_org_id ,

Line 1381: -- and tax_type in (lv_excise_cess,jai_constants.tax_type_service_edu_cess, jai_constants.tax_type_sh_service_edu_cess); --rchandan for bug#4428980

1377: CURSOR c_cess_amt(cp_transfer_dest_id number) IS
1378: SELECT transfer_amount
1379: FROM JAI_RGM_DIS_DES_TAXES
1380: WHERE transfer_destination_id = cp_transfer_dest_id
1381: -- and tax_type in (lv_excise_cess,jai_constants.tax_type_service_edu_cess, jai_constants.tax_type_sh_service_edu_cess); --rchandan for bug#4428980
1382: --commented the above and added the below by Sanjikum for Bug#6119459
1383: and tax_type in ('EXCISE-CESS','SERVICE_EDUCATION_CESS');
1384:
1385: --Added the below by kunkumar for bug#6127194

Line 1543: AND p_from_tax_type IN (jai_constants.tax_type_service, jai_constants.tax_type_service_edu_cess,

1539: /*Bug 5879769 bduvarag start*/
1540: IF p_from_party_type IN ( 'OU' )
1541: OR
1542: ( p_from_party_type = 'IO'
1543: AND p_from_tax_type IN (jai_constants.tax_type_service, jai_constants.tax_type_service_edu_cess,
1544: jai_constants.tax_type_sh_service_edu_cess)) THEN -- added, Harshita for Bug 5694855
1545: --Modified by kunkumar for Bug#6127194
1546: /*Bug 5879769 bduvarag end*/
1547:

Line 1544: jai_constants.tax_type_sh_service_edu_cess)) THEN -- added, Harshita for Bug 5694855

1540: IF p_from_party_type IN ( 'OU' )
1541: OR
1542: ( p_from_party_type = 'IO'
1543: AND p_from_tax_type IN (jai_constants.tax_type_service, jai_constants.tax_type_service_edu_cess,
1544: jai_constants.tax_type_sh_service_edu_cess)) THEN -- added, Harshita for Bug 5694855
1545: --Modified by kunkumar for Bug#6127194
1546: /*Bug 5879769 bduvarag end*/
1547:
1548: lv_acct_req_flag := jai_constants.YES;

Line 1548: lv_acct_req_flag := jai_constants.YES;

1544: jai_constants.tax_type_sh_service_edu_cess)) THEN -- added, Harshita for Bug 5694855
1545: --Modified by kunkumar for Bug#6127194
1546: /*Bug 5879769 bduvarag end*/
1547:
1548: lv_acct_req_flag := jai_constants.YES;
1549:
1550: IF p_source = 'SETTLEMENT' THEN
1551: lv_source := jai_constants.source_settle_out ;
1552: -- lv_balancing_entry := jai_constants.NO; --added by nprashar for bug # 7525691 commented for bug#6773684

Line 1551: lv_source := jai_constants.source_settle_out ;

1547:
1548: lv_acct_req_flag := jai_constants.YES;
1549:
1550: IF p_source = 'SETTLEMENT' THEN
1551: lv_source := jai_constants.source_settle_out ;
1552: -- lv_balancing_entry := jai_constants.NO; --added by nprashar for bug # 7525691 commented for bug#6773684
1553: ELSIF p_source = 'DISTRIBUTION' THEN
1554: lv_source := jai_constants.service_src_distribute_out;
1555: END IF;

Line 1552: -- lv_balancing_entry := jai_constants.NO; --added by nprashar for bug # 7525691 commented for bug#6773684

1548: lv_acct_req_flag := jai_constants.YES;
1549:
1550: IF p_source = 'SETTLEMENT' THEN
1551: lv_source := jai_constants.source_settle_out ;
1552: -- lv_balancing_entry := jai_constants.NO; --added by nprashar for bug # 7525691 commented for bug#6773684
1553: ELSIF p_source = 'DISTRIBUTION' THEN
1554: lv_source := jai_constants.service_src_distribute_out;
1555: END IF;
1556: IF p_to_party_type = 'IO' and upper(p_to_tax_type) IN (upper(jai_constants.tax_type_excise), 'EXCISE-CESS',jai_constants.tax_type_sh_exc_edu_cess)

Line 1554: lv_source := jai_constants.service_src_distribute_out;

1550: IF p_source = 'SETTLEMENT' THEN
1551: lv_source := jai_constants.source_settle_out ;
1552: -- lv_balancing_entry := jai_constants.NO; --added by nprashar for bug # 7525691 commented for bug#6773684
1553: ELSIF p_source = 'DISTRIBUTION' THEN
1554: lv_source := jai_constants.service_src_distribute_out;
1555: END IF;
1556: IF p_to_party_type = 'IO' and upper(p_to_tax_type) IN (upper(jai_constants.tax_type_excise), 'EXCISE-CESS',jai_constants.tax_type_sh_exc_edu_cess)
1557: THEN /*5694855*/
1558: /*

Line 1556: IF p_to_party_type = 'IO' and upper(p_to_tax_type) IN (upper(jai_constants.tax_type_excise), 'EXCISE-CESS',jai_constants.tax_type_sh_exc_edu_cess)

1552: -- lv_balancing_entry := jai_constants.NO; --added by nprashar for bug # 7525691 commented for bug#6773684
1553: ELSIF p_source = 'DISTRIBUTION' THEN
1554: lv_source := jai_constants.service_src_distribute_out;
1555: END IF;
1556: IF p_to_party_type = 'IO' and upper(p_to_tax_type) IN (upper(jai_constants.tax_type_excise), 'EXCISE-CESS',jai_constants.tax_type_sh_exc_edu_cess)
1557: THEN /*5694855*/
1558: /*
1559: ||Start of bug 5073553
1560: || Added by CSahoo

Line 1569: v_register_type := jai_constants.register_type_pla;

1565: p_from_party_type => p_from_party_type ,
1566: p_to_party_type => p_to_party_type
1567: ) = 'PLA'
1568: THEN
1569: v_register_type := jai_constants.register_type_pla;
1570: ELSE
1571: --v_register_type := jai_constants.REGISTER_TYPE_A; commented for bug#6773684
1572: v_register_type :='RG';--bug#6773684
1573: END IF;

Line 1571: --v_register_type := jai_constants.REGISTER_TYPE_A; commented for bug#6773684

1567: ) = 'PLA'
1568: THEN
1569: v_register_type := jai_constants.register_type_pla;
1570: ELSE
1571: --v_register_type := jai_constants.REGISTER_TYPE_A; commented for bug#6773684
1572: v_register_type :='RG';--bug#6773684
1573: END IF;
1574: /* End of bug 5073553 */
1575: /*Bug 5879769 bduvarag start*/

Line 1576: ELSIF ( p_source = 'SETTLEMENT' or p_from_tax_type IN (jai_constants.tax_type_service, jai_constants.tax_type_service_edu_cess, jai_constants.tax_type_sh_service_edu_cess) ) THEN --Added by kunkumar for Bug#6127194

1572: v_register_type :='RG';--bug#6773684
1573: END IF;
1574: /* End of bug 5073553 */
1575: /*Bug 5879769 bduvarag start*/
1576: ELSIF ( p_source = 'SETTLEMENT' or p_from_tax_type IN (jai_constants.tax_type_service, jai_constants.tax_type_service_edu_cess, jai_constants.tax_type_sh_service_edu_cess) ) THEN --Added by kunkumar for Bug#6127194
1577: lv_acct_req_flag := jai_constants.YES;
1578: v_register_type := NULL;
1579: /*Bug 5879769 bduvarag end*/
1580: ELSE

Line 1577: lv_acct_req_flag := jai_constants.YES;

1573: END IF;
1574: /* End of bug 5073553 */
1575: /*Bug 5879769 bduvarag start*/
1576: ELSIF ( p_source = 'SETTLEMENT' or p_from_tax_type IN (jai_constants.tax_type_service, jai_constants.tax_type_service_edu_cess, jai_constants.tax_type_sh_service_edu_cess) ) THEN --Added by kunkumar for Bug#6127194
1577: lv_acct_req_flag := jai_constants.YES;
1578: v_register_type := NULL;
1579: /*Bug 5879769 bduvarag end*/
1580: ELSE
1581: v_register_type := NULL;

Line 1590: lv_rep_register_type:=jai_constants.register_type_a;

1586:
1587: --start additions for bug#6773684
1588: if v_register_type='RG'
1589: then
1590: lv_rep_register_type:=jai_constants.register_type_a;
1591: end if;
1592: --end additions for bug#6773684
1593:
1594: jai_cmn_rgm_recording_pkg.insert_repository_entry

Line 1627: P_CURRENCY_CODE => jai_constants.func_curr , -- File.Sql.35 by Brathod

1623: P_BALANCING_ORGN_ID => p_to_party_id ,
1624: P_BALANCING_LOCATION_ID => p_to_locn_id ,
1625: P_BALANCING_TAX_TYPE => p_to_tax_type ,
1626: P_BALANCING_ACCNT_NAME => nvl(lv_rep_register_type,v_register_type) ,--added nvl(lv_rep_register_type for bug#6773684
1627: P_CURRENCY_CODE => jai_constants.func_curr , -- File.Sql.35 by Brathod
1628: p_service_type_code => p_from_service_type
1629: /*
1630: , /*Bug 5879769 bduvarag
1631: p_balancing_entry => lv_balancing_entry --added by nprashar for bug # 7525691

Line 1634: IF NVL(p_process_flag,'$') <> jai_constants.successful THEN

1630: , /*Bug 5879769 bduvarag
1631: p_balancing_entry => lv_balancing_entry --added by nprashar for bug # 7525691
1632: *//*commented for bug#6773684*/
1633: );
1634: IF NVL(p_process_flag,'$') <> jai_constants.successful THEN
1635: rollback;
1636: return;
1637: END IF;
1638: p_repository_id := ln_repository_id;

Line 1654: v_register_type := jai_constants.register_type_pla;

1650: p_from_party_type => p_from_party_type ,
1651: p_to_party_type => p_to_party_type
1652: ) = 'PLA'
1653: THEN
1654: v_register_type := jai_constants.register_type_pla;
1655: ELSE
1656: --v_register_type := jai_constants.REGISTER_TYPE_A;commented for bug#6773684
1657: v_register_type :='RG';--added for bug#6773684
1658: END IF;

Line 1656: --v_register_type := jai_constants.REGISTER_TYPE_A;commented for bug#6773684

1652: ) = 'PLA'
1653: THEN
1654: v_register_type := jai_constants.register_type_pla;
1655: ELSE
1656: --v_register_type := jai_constants.REGISTER_TYPE_A;commented for bug#6773684
1657: v_register_type :='RG';--added for bug#6773684
1658: END IF;
1659: --end additions for bug#6773684
1660:

Line 1710: P_REGISTER_TYPE => jai_constants.REGISTER_TYPE_A ,

1706: P_DR_ADDITIONAL_ED => NULL,
1707: P_DR_OTHER_ED => NULL,
1708: P_EXCISE_INVOICE_NO => NULL,
1709: P_EXCISE_INVOICE_DATE => NULL,
1710: P_REGISTER_TYPE => jai_constants.REGISTER_TYPE_A ,
1711: P_REMARKS => 'DISTRIBUTION - OUT',
1712: P_VENDOR_ID => NULL,
1713: P_VENDOR_SITE_ID => NULL ,
1714: P_CUSTOMER_ID => NULL,

Line 1783: IF nvl(p_process_flag,jai_constants.successful) <> jai_constants.successful THEN

1779: );
1780:
1781: /*jai_cmn_utils_pkg.print_log('dis.log','after call to from io process flag = ' || p_process_flag);
1782: jai_cmn_utils_pkg.print_log('dis.log','err messg is '||p_process_message );*/
1783: IF nvl(p_process_flag,jai_constants.successful) <> jai_constants.successful THEN
1784: rollback;
1785: return;
1786: END IF;
1787: END IF;

Line 1795: ( p_to_party_type = 'IO' AND p_to_tax_type IN (jai_constants.tax_type_service, jai_constants.tax_type_service_edu_cess, jai_constants.tax_type_sh_service_edu_cess )) THEN -- added, Harshita for Bug 5694855 --Modified by kunkumar for Bug#6127194

1791: */
1792: /*Bug 5879769 bduvarag*/
1793: IF p_to_party_type IN ('OU')
1794: OR
1795: ( p_to_party_type = 'IO' AND p_to_tax_type IN (jai_constants.tax_type_service, jai_constants.tax_type_service_edu_cess, jai_constants.tax_type_sh_service_edu_cess )) THEN -- added, Harshita for Bug 5694855 --Modified by kunkumar for Bug#6127194
1796: IF p_from_party_type = 'IO' AND upper(p_from_tax_type) IN (upper(jai_constants.tax_type_excise), 'EXCISE-CESS',upper(jai_constants.tax_type_sh_exc_edu_cess)) THEN/*Bug 5879769 bduvarag*/
1797: lv_acct_req_flag := jai_constants.YES;
1798: -- v_register_type := jai_constants.REGISTER_TYPE_A; commented for bug#6773684
1799:

Line 1796: IF p_from_party_type = 'IO' AND upper(p_from_tax_type) IN (upper(jai_constants.tax_type_excise), 'EXCISE-CESS',upper(jai_constants.tax_type_sh_exc_edu_cess)) THEN/Bug 5879769 bduvarag/

1792: /*Bug 5879769 bduvarag*/
1793: IF p_to_party_type IN ('OU')
1794: OR
1795: ( p_to_party_type = 'IO' AND p_to_tax_type IN (jai_constants.tax_type_service, jai_constants.tax_type_service_edu_cess, jai_constants.tax_type_sh_service_edu_cess )) THEN -- added, Harshita for Bug 5694855 --Modified by kunkumar for Bug#6127194
1796: IF p_from_party_type = 'IO' AND upper(p_from_tax_type) IN (upper(jai_constants.tax_type_excise), 'EXCISE-CESS',upper(jai_constants.tax_type_sh_exc_edu_cess)) THEN/*Bug 5879769 bduvarag*/
1797: lv_acct_req_flag := jai_constants.YES;
1798: -- v_register_type := jai_constants.REGISTER_TYPE_A; commented for bug#6773684
1799:
1800: --start additions for bug#6773684

Line 1797: lv_acct_req_flag := jai_constants.YES;

1793: IF p_to_party_type IN ('OU')
1794: OR
1795: ( p_to_party_type = 'IO' AND p_to_tax_type IN (jai_constants.tax_type_service, jai_constants.tax_type_service_edu_cess, jai_constants.tax_type_sh_service_edu_cess )) THEN -- added, Harshita for Bug 5694855 --Modified by kunkumar for Bug#6127194
1796: IF p_from_party_type = 'IO' AND upper(p_from_tax_type) IN (upper(jai_constants.tax_type_excise), 'EXCISE-CESS',upper(jai_constants.tax_type_sh_exc_edu_cess)) THEN/*Bug 5879769 bduvarag*/
1797: lv_acct_req_flag := jai_constants.YES;
1798: -- v_register_type := jai_constants.REGISTER_TYPE_A; commented for bug#6773684
1799:
1800: --start additions for bug#6773684
1801: IF f_get_io_register ( p_party_id => p_from_party_id ,

Line 1798: -- v_register_type := jai_constants.REGISTER_TYPE_A; commented for bug#6773684

1794: OR
1795: ( p_to_party_type = 'IO' AND p_to_tax_type IN (jai_constants.tax_type_service, jai_constants.tax_type_service_edu_cess, jai_constants.tax_type_sh_service_edu_cess )) THEN -- added, Harshita for Bug 5694855 --Modified by kunkumar for Bug#6127194
1796: IF p_from_party_type = 'IO' AND upper(p_from_tax_type) IN (upper(jai_constants.tax_type_excise), 'EXCISE-CESS',upper(jai_constants.tax_type_sh_exc_edu_cess)) THEN/*Bug 5879769 bduvarag*/
1797: lv_acct_req_flag := jai_constants.YES;
1798: -- v_register_type := jai_constants.REGISTER_TYPE_A; commented for bug#6773684
1799:
1800: --start additions for bug#6773684
1801: IF f_get_io_register ( p_party_id => p_from_party_id ,
1802: p_from_party_type => p_from_party_type ,

Line 1806: v_register_type := jai_constants.register_type_pla;

1802: p_from_party_type => p_from_party_type ,
1803: p_to_party_type => p_to_party_type
1804: ) = 'PLA'
1805: THEN
1806: v_register_type := jai_constants.register_type_pla;
1807: ELSE
1808: --v_register_type := jai_constants.REGISTER_TYPE_A;--commneted for bug#6773684
1809: v_register_type :='RG';--added for bug#6773684
1810: END IF;

Line 1808: --v_register_type := jai_constants.REGISTER_TYPE_A;--commneted for bug#6773684

1804: ) = 'PLA'
1805: THEN
1806: v_register_type := jai_constants.register_type_pla;
1807: ELSE
1808: --v_register_type := jai_constants.REGISTER_TYPE_A;--commneted for bug#6773684
1809: v_register_type :='RG';--added for bug#6773684
1810: END IF;
1811: --end additions for bug#6773684
1812:

Line 1815: ELSIF ( p_source = 'SETTLEMENT' or p_to_tax_type IN (jai_constants.tax_type_service, jai_constants.tax_type_service_edu_cess, jai_constants.tax_type_sh_service_edu_cess )) THEN --Added by kunkumar for Bug#6127194

1811: --end additions for bug#6773684
1812:
1813:
1814: /*Bug 5879769 bduvarag start*/
1815: ELSIF ( p_source = 'SETTLEMENT' or p_to_tax_type IN (jai_constants.tax_type_service, jai_constants.tax_type_service_edu_cess, jai_constants.tax_type_sh_service_edu_cess )) THEN --Added by kunkumar for Bug#6127194
1816: lv_acct_req_flag := jai_constants.YES;
1817: v_register_type := NULL;
1818: /*Bug 5879769 bduvarag end*/
1819: ELSE

Line 1816: lv_acct_req_flag := jai_constants.YES;

1812:
1813:
1814: /*Bug 5879769 bduvarag start*/
1815: ELSIF ( p_source = 'SETTLEMENT' or p_to_tax_type IN (jai_constants.tax_type_service, jai_constants.tax_type_service_edu_cess, jai_constants.tax_type_sh_service_edu_cess )) THEN --Added by kunkumar for Bug#6127194
1816: lv_acct_req_flag := jai_constants.YES;
1817: v_register_type := NULL;
1818: /*Bug 5879769 bduvarag end*/
1819: ELSE
1820: lv_acct_req_flag := jai_constants.NO;

Line 1820: lv_acct_req_flag := jai_constants.NO;

1816: lv_acct_req_flag := jai_constants.YES;
1817: v_register_type := NULL;
1818: /*Bug 5879769 bduvarag end*/
1819: ELSE
1820: lv_acct_req_flag := jai_constants.NO;
1821: v_register_type := NULL;
1822: END IF;
1823: IF p_source = 'SETTLEMENT' THEN
1824: lv_source := jai_constants.source_settle_in ;

Line 1824: lv_source := jai_constants.source_settle_in ;

1820: lv_acct_req_flag := jai_constants.NO;
1821: v_register_type := NULL;
1822: END IF;
1823: IF p_source = 'SETTLEMENT' THEN
1824: lv_source := jai_constants.source_settle_in ;
1825: -- lv_balancing_entry := jai_constants.NO; --added by nprashar for bug # 7525691 commented for bug#6773684
1826: ELSIF p_source = 'DISTRIBUTION' THEN
1827: lv_source := jai_constants.service_src_distribute_in;
1828: END IF;

Line 1825: -- lv_balancing_entry := jai_constants.NO; --added by nprashar for bug # 7525691 commented for bug#6773684

1821: v_register_type := NULL;
1822: END IF;
1823: IF p_source = 'SETTLEMENT' THEN
1824: lv_source := jai_constants.source_settle_in ;
1825: -- lv_balancing_entry := jai_constants.NO; --added by nprashar for bug # 7525691 commented for bug#6773684
1826: ELSIF p_source = 'DISTRIBUTION' THEN
1827: lv_source := jai_constants.service_src_distribute_in;
1828: END IF;
1829: /* jai_cmn_utils_pkg.print_log('dis.log',' p_to_trx_amount is :' || p_to_trx_amount); */

Line 1827: lv_source := jai_constants.service_src_distribute_in;

1823: IF p_source = 'SETTLEMENT' THEN
1824: lv_source := jai_constants.source_settle_in ;
1825: -- lv_balancing_entry := jai_constants.NO; --added by nprashar for bug # 7525691 commented for bug#6773684
1826: ELSIF p_source = 'DISTRIBUTION' THEN
1827: lv_source := jai_constants.service_src_distribute_in;
1828: END IF;
1829: /* jai_cmn_utils_pkg.print_log('dis.log',' p_to_trx_amount is :' || p_to_trx_amount); */
1830: IF p_called_from = 'DISTRIBUTION' THEN
1831: ln_transfer_id := p_reference_id;

Line 1836: lv_rep_register_type :=jai_constants.register_type_a;

1832: END IF;
1833: --start additions for bug#6773684
1834: if v_register_type='RG'
1835: then
1836: lv_rep_register_type :=jai_constants.register_type_a;
1837: end if;
1838: --end additions for bug#6773684
1839:
1840: jai_cmn_rgm_recording_pkg.insert_repository_entry

Line 1873: P_CURRENCY_CODE => jai_constants.func_curr , -- File.Sql.35 by Brathod

1869: P_BALANCING_ORGN_ID => p_from_party_id ,
1870: P_BALANCING_LOCATION_ID => p_from_locn_id ,
1871: P_BALANCING_TAX_TYPE => p_from_tax_type ,
1872: P_BALANCING_ACCNT_NAME => nvl(lv_rep_register_type,v_register_type) ,--added the nvl(lv_rep_register_type for bug#6773684
1873: P_CURRENCY_CODE => jai_constants.func_curr , -- File.Sql.35 by Brathod
1874: p_service_type_code => p_to_service_type
1875: /*, /*Bug 5879769 bduvarag
1876: p_balancing_entry => lv_balancing_entry --added by nprashar for bug # 7525691
1877: *//*commented for bug#6773684*/

Line 1879: IF nvl(p_process_flag,'$') <> jai_constants.successful THEN

1875: /*, /*Bug 5879769 bduvarag
1876: p_balancing_entry => lv_balancing_entry --added by nprashar for bug # 7525691
1877: *//*commented for bug#6773684*/
1878: );
1879: IF nvl(p_process_flag,'$') <> jai_constants.successful THEN
1880: rollback;
1881: return;
1882: END IF;
1883: p_repository_id := ln_repository_id;

Line 2010: IF nvl(p_process_flag,jai_constants.successful) <> jai_constants.successful THEN

2006: p_process_flag => p_process_flag ,
2007: p_process_message => p_process_message
2008: );
2009:
2010: IF nvl(p_process_flag,jai_constants.successful) <> jai_constants.successful THEN
2011: rollback;
2012: return;
2013: END IF;--p_process_flag
2014: END IF;-- p_to_tax_type

Line 2098: p_process_flag := jai_constants.successful;

2094: --Added the body of the procedure by kunkumar for bug#6127194
2095: /*
2096: ||Initialize the variables
2097: */
2098: p_process_flag := jai_constants.successful;
2099: ln_source_type := null ;
2100: lv_source_register := null ;
2101:
2102: IF p_tax_type = 'EXCISE' THEN

Line 2120: p_register_type => jai_constants.register_type_a ,

2116: p_dr_additional_ed => p_dr_additional_ed ,
2117: p_dr_other_ed => p_dr_other_ed ,
2118: p_excise_invoice_no => p_excise_invoice_no ,
2119: p_excise_invoice_date => p_excise_invoice_date ,
2120: p_register_type => jai_constants.register_type_a ,
2121: p_remarks => p_remarks ,
2122: p_vendor_id => p_vendor_id ,
2123: p_vendor_site_id => p_vendor_site_id ,
2124: p_customer_id => p_customer_id ,

Line 2185: IF nvl(p_process_flag,jai_constants.successful) <> jai_constants.successful THEN

2181: );
2182:
2183: END IF;
2184:
2185: IF nvl(p_process_flag,jai_constants.successful) <> jai_constants.successful THEN
2186: rollback;
2187: return;
2188: ELSE /* Pass cess entries in jai_rg_others table*/
2189: /* Update the cess amount in the ja_in_rg23_part_ii table*/

Line 2204: IF nvl(p_process_flag,jai_constants.successful) <> jai_constants.successful THEN

2200: p_process_flag => p_process_flag ,
2201: p_process_msg => p_process_message
2202: );
2203:
2204: IF nvl(p_process_flag,jai_constants.successful) <> jai_constants.successful THEN
2205:
2206: rollback;
2207: return;
2208: END IF;

Line 2225: IF nvl(p_process_flag,jai_constants.successful) <> jai_constants.successful THEN

2221: p_process_flag => p_process_flag ,
2222: p_process_msg => p_process_message
2223: );
2224:
2225: IF nvl(p_process_flag,jai_constants.successful) <> jai_constants.successful THEN
2226:
2227: rollback;
2228: return;
2229: END IF;