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

Line 207: pv_return_code := jai_constants.successful ;

203: */
204: l_func_curr_det jai_plsql_cache_pkg.func_curr_details;
205:
206: BEGIN
207: pv_return_code := jai_constants.successful ;
208: /*------------------------------------------------------------------------------------------
209: FILENAME: JA_IN_APPS_AR_LINES_INSERT_TRG.sql
210: CHANGE HISTORY:
211: S.No Date Author and Details

Line 504: -- jai_constants.tax_type_sh_exc_edu_cess,jai_constants.tax_type_sh_cvd_edu_cess added by csahoo for bug#6081806

500:
501: IF NVL(v_register_code,'N') IN ('23D_EXPORT_WITHOUT_EXCISE','23D_EXPORT_EXCISE',
502: '23D_DOMESTIC_EXCISE','23D_DOM_WITHOUT_EXCISE','BOND_REG')
503: THEN
504: -- jai_constants.tax_type_sh_exc_edu_cess,jai_constants.tax_type_sh_cvd_edu_cess added by csahoo for bug#6081806
505: IF Tax_Type_Rec.T_Type IN ('Excise','Addl. Excise','Other Excise','EXCISE_EDUCATION_CESS','CVD_EDUCATION_CESS',jai_constants.tax_type_sh_exc_edu_cess,jai_constants.tax_type_sh_cvd_edu_cess) THEN
506: TAX_TYPE_REC.tax_amt := 0;
507: END IF;
508: END IF;

Line 505: IF Tax_Type_Rec.T_Type IN ('Excise','Addl. Excise','Other Excise','EXCISE_EDUCATION_CESS','CVD_EDUCATION_CESS',jai_constants.tax_type_sh_exc_edu_cess,jai_constants.tax_type_sh_cvd_edu_cess) THEN

501: IF NVL(v_register_code,'N') IN ('23D_EXPORT_WITHOUT_EXCISE','23D_EXPORT_EXCISE',
502: '23D_DOMESTIC_EXCISE','23D_DOM_WITHOUT_EXCISE','BOND_REG')
503: THEN
504: -- jai_constants.tax_type_sh_exc_edu_cess,jai_constants.tax_type_sh_cvd_edu_cess added by csahoo for bug#6081806
505: IF Tax_Type_Rec.T_Type IN ('Excise','Addl. Excise','Other Excise','EXCISE_EDUCATION_CESS','CVD_EDUCATION_CESS',jai_constants.tax_type_sh_exc_edu_cess,jai_constants.tax_type_sh_cvd_edu_cess) THEN
506: TAX_TYPE_REC.tax_amt := 0;
507: END IF;
508: END IF;
509: -- END IF; -- Deleted by Jia Li for Tax inclusive Computations on 2007/11/22 ,TD18

Line 525: -- jai_constants.tax_type_sh_exc_edu_cess,jai_constants.tax_type_sh_cvd_edu_cess added by csahoo for bug#6081806

521: /*
522: || added by CSahoo - bug# 5390583 In case of bond reg , the excise taxes should not go to base AR tables.
523: */
524: IF NVL(v_register_code,'N') = 'BOND_REG' THEN
525: -- jai_constants.tax_type_sh_exc_edu_cess,jai_constants.tax_type_sh_cvd_edu_cess added by csahoo for bug#6081806
526: IF upper(Tax_Type_Rec.T_Type) IN ('EXCISE','ADDL. EXCISE','OTHER EXCISE','EXCISE_EDUCATION_CESS','CVD_EDUCATION_CESS',jai_constants.tax_type_sh_exc_edu_cess,jai_constants.tax_type_sh_cvd_edu_cess) THEN
527: TAX_TYPE_REC.tax_amt := 0;
528: END IF;
529: END IF;

Line 526: IF upper(Tax_Type_Rec.T_Type) IN ('EXCISE','ADDL. EXCISE','OTHER EXCISE','EXCISE_EDUCATION_CESS','CVD_EDUCATION_CESS',jai_constants.tax_type_sh_exc_edu_cess,jai_constants.tax_type_sh_cvd_edu_cess) THEN

522: || added by CSahoo - bug# 5390583 In case of bond reg , the excise taxes should not go to base AR tables.
523: */
524: IF NVL(v_register_code,'N') = 'BOND_REG' THEN
525: -- jai_constants.tax_type_sh_exc_edu_cess,jai_constants.tax_type_sh_cvd_edu_cess added by csahoo for bug#6081806
526: IF upper(Tax_Type_Rec.T_Type) IN ('EXCISE','ADDL. EXCISE','OTHER EXCISE','EXCISE_EDUCATION_CESS','CVD_EDUCATION_CESS',jai_constants.tax_type_sh_exc_edu_cess,jai_constants.tax_type_sh_cvd_edu_cess) THEN
527: TAX_TYPE_REC.tax_amt := 0;
528: END IF;
529: END IF;
530:

Line 560: IF upper(tax_type_rec.t_type) = upper(jai_constants.tax_type_service) OR

556: || The following code has been added by aiyer for the bug 4089440
557: || IF tax type is SERVICE or SERVICE-CESS then get the account info from regime setup
558: || IF no setup is found then raise an error and stop the transaction.
559: */
560: IF upper(tax_type_rec.t_type) = upper(jai_constants.tax_type_service) OR
561: upper(tax_type_rec.t_type) = upper(jai_constants.tax_type_service_edu_cess)
562: OR upper(tax_type_rec.t_type)= upper(jai_constants.tax_type_sh_service_edu_cess) --added by csahoo for bug#6081806
563: THEN -- Start of A1
564:

Line 561: upper(tax_type_rec.t_type) = upper(jai_constants.tax_type_service_edu_cess)

557: || IF tax type is SERVICE or SERVICE-CESS then get the account info from regime setup
558: || IF no setup is found then raise an error and stop the transaction.
559: */
560: IF upper(tax_type_rec.t_type) = upper(jai_constants.tax_type_service) OR
561: upper(tax_type_rec.t_type) = upper(jai_constants.tax_type_service_edu_cess)
562: OR upper(tax_type_rec.t_type)= upper(jai_constants.tax_type_sh_service_edu_cess) --added by csahoo for bug#6081806
563: THEN -- Start of A1
564:
565: /**********************************************************************************************************

Line 562: OR upper(tax_type_rec.t_type)= upper(jai_constants.tax_type_sh_service_edu_cess) --added by csahoo for bug#6081806

558: || IF no setup is found then raise an error and stop the transaction.
559: */
560: IF upper(tax_type_rec.t_type) = upper(jai_constants.tax_type_service) OR
561: upper(tax_type_rec.t_type) = upper(jai_constants.tax_type_service_edu_cess)
562: OR upper(tax_type_rec.t_type)= upper(jai_constants.tax_type_sh_service_edu_cess) --added by csahoo for bug#6081806
563: THEN -- Start of A1
564:
565: /**********************************************************************************************************
566: || Get the regime id and also validate the Regime/Regime Registratiom Setup Information

Line 569: jai_ar_rgm_processing_pkg.get_regime_info ( p_regime_code => jai_constants.service_regime ,

565: /**********************************************************************************************************
566: || Get the regime id and also validate the Regime/Regime Registratiom Setup Information
567: ***********************************************************************************************************/
568:
569: jai_ar_rgm_processing_pkg.get_regime_info ( p_regime_code => jai_constants.service_regime ,
570: p_tax_type_code => tax_type_rec.t_type ,
571: p_regime_id => ln_regime_id ,
572: p_error_flag => lv_error_flag ,
573: p_error_message => lv_error_message

Line 576: IF lv_error_flag <> jai_constants.successful THEN

572: p_error_flag => lv_error_flag ,
573: p_error_message => lv_error_message
574: );
575:
576: IF lv_error_flag <> jai_constants.successful THEN
577: /*
578: || Encountered an error from the call to jai_ar_rgm_processing_pkg.get_regime_info
579: || Stop processing and thorw an error
580: */

Line 582: */ pv_return_code := jai_constants.expected_error ; pv_return_message := lv_error_message ; return ;

578: || Encountered an error from the call to jai_ar_rgm_processing_pkg.get_regime_info
579: || Stop processing and thorw an error
580: */
581: /* raise_application_error (-20130,lv_error_message);
582: */ pv_return_code := jai_constants.expected_error ; pv_return_message := lv_error_message ; return ;
583: END IF ;
584: /**********************************************************************************************************
585: || Get Tax Account Info from the Regime Organization/Regime Registration setup
586: **********************************************************************************************************/

Line 595: p_organization_type => jai_constants.service_tax_orgn_type ,

591: */
592:
593: v_ccid := jai_cmn_rgm_recording_pkg.get_account (
594: p_regime_id => ln_regime_id ,
595: p_organization_type => jai_constants.service_tax_orgn_type ,
596: p_organization_id => v_organization_id ,
597: p_location_id => v_location_id ,
598: p_tax_type => tax_type_rec.t_type ,
599: p_account_name => jai_constants.liability_interim

Line 599: p_account_name => jai_constants.liability_interim

595: p_organization_type => jai_constants.service_tax_orgn_type ,
596: p_organization_id => v_organization_id ,
597: p_location_id => v_location_id ,
598: p_tax_type => tax_type_rec.t_type ,
599: p_account_name => jai_constants.liability_interim
600: );
601: IF v_ccid IS NULL THEN
602: /*
603: || Code Combination id has been returned as null from the function jai_cmn_rgm_recording_pkg.get_account

Line 607: */ pv_return_code := jai_constants.expected_error ; pv_return_message := 'Invalid Code combination ,please check the Service Tax - Tax Accounting Setup' ; return ;

603: || Code Combination id has been returned as null from the function jai_cmn_rgm_recording_pkg.get_account
604: || This is an error condition and the current processing has to be stopped
605: */
606: /* raise_application_error (-20130,'Invalid Code combination ,please check the Service Tax - Tax Accounting Setup');
607: */ pv_return_code := jai_constants.expected_error ; pv_return_message := 'Invalid Code combination ,please check the Service Tax - Tax Accounting Setup' ; return ;
608: END IF;
609: /*
610: || Start of bug 4212816
611: || Code modified by aiyer for the VAT Enhancement

Line 615: ELSIF UPPER(nvl(ln_regime_code,'####')) = jai_constants.vat_regime THEN

611: || Code modified by aiyer for the VAT Enhancement
612: || Get the Tax accounting information from the vat regime setup when the taxes are as mentioned below taxes
613: */
614:
615: ELSIF UPPER(nvl(ln_regime_code,'####')) = jai_constants.vat_regime THEN
616:
617: /*********************************************************************************************************
618: || Validate whether the item attached is vatable or not
619: *********************************************************************************************************/

Line 625: p_attribute_code => jai_constants.rgm_attr_item_applicable ,

621: jai_inv_items_pkg.jai_get_attrib (
622: p_regime_code => ln_regime_code ,
623: p_organization_id => v_organization_id ,
624: p_inventory_item_id => pr_new.inventory_item_id ,
625: p_attribute_code => jai_constants.rgm_attr_item_applicable ,
626: p_attribute_value => lv_attr_value ,
627: p_process_flag => lv_error_flag ,
628: p_process_msg => lv_error_message
629: ) ;

Line 630: IF lv_error_flag <> jai_constants.successful THEN

626: p_attribute_value => lv_attr_value ,
627: p_process_flag => lv_error_flag ,
628: p_process_msg => lv_error_message
629: ) ;
630: IF lv_error_flag <> jai_constants.successful THEN
631: /*
632: || Encountered an error from the call to jai_ar_rgm_processing_pkg.get_regime_info
633: || Stop processing and thorw an error
634: */

Line 635: /* raise_application_error (-20130,lv_error_message); */ pv_return_code := jai_constants.expected_error ; pv_return_message := lv_error_message ; return ;

631: /*
632: || Encountered an error from the call to jai_ar_rgm_processing_pkg.get_regime_info
633: || Stop processing and thorw an error
634: */
635: /* raise_application_error (-20130,lv_error_message); */ pv_return_code := jai_constants.expected_error ; pv_return_message := lv_error_message ; return ;
636: /*
637: app_exception.raise_exception( EXCEPTION_TYPE => 'APP',
638: EXCEPTION_CODE => NULL ,
639: EXCEPTION_TEXT => lv_error_message

Line 654: /* raise_application_error (-20130,'ITEM not vatable'); */ pv_return_code := jai_constants.expected_error ; pv_return_message := 'ITEM not vatable' ; return ;

650: /* above if condition before the if added by ssumaith - bug# 6104491 */
651: /*
652: || Item is not vatable . Stop processing and throw an error
653: */
654: /* raise_application_error (-20130,'ITEM not vatable'); */ pv_return_code := jai_constants.expected_error ; pv_return_message := 'ITEM not vatable' ; return ;
655: /* DO not delete this code, enable this code while doing the messageing project
656: app_exception.raise_exception( EXCEPTION_TYPE => 'APP',
657: EXCEPTION_CODE => NULL ,
658: EXCEPTION_TEXT => 'Cannot attach VAT type of taxes to non vatable items.'

Line 676: p_organization_type => jai_constants.orgn_type_io ,

672:
673:
674: v_ccid := jai_cmn_rgm_recording_pkg.get_account (
675: p_regime_id => ln_regime_id ,
676: p_organization_type => jai_constants.orgn_type_io ,
677: p_organization_id => v_organization_id ,
678: p_location_id => v_location_id ,
679: p_tax_type => tax_type_rec.t_type ,
680: p_account_name => jai_constants.liability_interim

Line 680: p_account_name => jai_constants.liability_interim

676: p_organization_type => jai_constants.orgn_type_io ,
677: p_organization_id => v_organization_id ,
678: p_location_id => v_location_id ,
679: p_tax_type => tax_type_rec.t_type ,
680: p_account_name => jai_constants.liability_interim
681: );
682: IF v_ccid IS NULL THEN
683: /**********************************************************************************************************
684: || Code Combination id has been returned as null from the function jai_cmn_rgm_recording_pkg.get_account

Line 688: pv_return_code := jai_constants.expected_error ;

684: || Code Combination id has been returned as null from the function jai_cmn_rgm_recording_pkg.get_account
685: || This is an error condition and the current processing has to be stopped
686: **********************************************************************************************************/
687: /* raise_application_error (-20130,'Invalid Code combination ,please check the VAT Tax - Tax Accounting Setup'); */
688: pv_return_code := jai_constants.expected_error ;
689: pv_return_message := 'Invalid Code combination ,please check the VAT Tax - Tax Accounting Setup ' ;
690: return ;
691: /*
692: app_exception.raise_exception( EXCEPTION_TYPE => 'APP',

Line 704: ELSIF UPPER(nvl(ln_regime_code,'####')) = jai_constants.tcs_regime THEN -- Start of A1

700: || End of bug 4212816
701: */
702:
703: /* Added by CSahoo for the TCS enhancements Bug# 5631784 */
704: ELSIF UPPER(nvl(ln_regime_code,'####')) = jai_constants.tcs_regime THEN -- Start of A1
705:
706: /*********************************************************************************************************
707: || Get the code combination id from the Organization/Regime Registration setup
708: || by calling the function jai_rgm_trx_recording_pkg.get_account

Line 714: p_organization_type => jai_constants.orgn_type_io ,

710:
711:
712: v_ccid := jai_cmn_rgm_recording_pkg.get_account (
713: p_regime_id => ln_regime_id ,
714: p_organization_type => jai_constants.orgn_type_io ,
715: p_organization_id => v_organization_id ,
716: p_location_id => v_location_id ,
717: p_tax_type => tax_type_rec.t_type ,
718: p_account_name => jai_constants.liability_interim

Line 718: p_account_name => jai_constants.liability_interim

714: p_organization_type => jai_constants.orgn_type_io ,
715: p_organization_id => v_organization_id ,
716: p_location_id => v_location_id ,
717: p_tax_type => tax_type_rec.t_type ,
718: p_account_name => jai_constants.liability_interim
719: );
720: IF v_ccid IS NULL THEN
721: /**********************************************************************************************************
722: || Code Combination id has been returned as null from the function jai_rgm_trx_recording_pkg.get_account

Line 802: */ pv_return_code := jai_constants.expected_error ; pv_return_message := 'error in processing the invoice ..' || v_trx_num || v_err_mesg ; return ; --19-MAR-2002

798: EXCEPTION
799: WHEN OTHERS THEN
800: v_err_mesg := SQLERRM;
801: /* RAISE_APPLICATION_ERROR(-20003,'error in processing the invoice ..' || v_trx_num || v_err_mesg);
802: */ pv_return_code := jai_constants.expected_error ; pv_return_message := 'error in processing the invoice ..' || v_trx_num || v_err_mesg ; return ; --19-MAR-2002
803: END;
804: -- the following if added by Sriram / Pavan on 06-May-2002
805: IF v_created_from = 'ARXTWMAI' THEN
806: result := fnd_request.set_mode(TRUE);

Line 1022: pv_return_code := jai_constants.successful ;

1018: FROM fnd_currencies
1019: WHERE currency_code = cp_currency_code;
1020:
1021: BEGIN
1022: pv_return_code := jai_constants.successful ;
1023: /*------------------------------------------------------------------------------------------
1024: FILENAME: JA_IN_APPS_AR_LINES_UPDATE_TRG.sql
1025: CHANGE HISTORY:
1026: S.No Date Author and Details

Line 1302: --jai_constants.tax_type_sh_exc_edu_cess,jai_constants.tax_type_sh_cvd_edu_cess added by csahoo for bug#6081806

1298: --IF nvl(v_ORDER_PRICE_EXCISE_INCLUSIVE,'N') = 'Y' then -- date 15/06/2007 sacsethi for bug 6131957 -- Deleted by Jia Li for Tax inclusive Computations on 2007/11/22, TD18
1299:
1300: IF NVL(v_register_code,'N') IN ('23D_EXPORT_WITHOUT_EXCISE','23D_EXPORT_EXCISE',
1301: '23D_DOMESTIC_EXCISE','23D_DOM_WITHOUT_EXCISE','BOND_REG') THEN
1302: --jai_constants.tax_type_sh_exc_edu_cess,jai_constants.tax_type_sh_cvd_edu_cess added by csahoo for bug#6081806
1303: IF Tax_Type_Rec.T_Type IN ('Excise','Addl. Excise','Other Excise','EXCISE_EDUCATION_CESS','CVD_EDUCATION_CESS',jai_constants.tax_type_sh_exc_edu_cess,jai_constants.tax_type_sh_cvd_edu_cess) THEN
1304: TAX_TYPE_REC.tax_amt := 0;
1305: END IF;
1306: END IF;

Line 1303: IF Tax_Type_Rec.T_Type IN ('Excise','Addl. Excise','Other Excise','EXCISE_EDUCATION_CESS','CVD_EDUCATION_CESS',jai_constants.tax_type_sh_exc_edu_cess,jai_constants.tax_type_sh_cvd_edu_cess) THEN

1299:
1300: IF NVL(v_register_code,'N') IN ('23D_EXPORT_WITHOUT_EXCISE','23D_EXPORT_EXCISE',
1301: '23D_DOMESTIC_EXCISE','23D_DOM_WITHOUT_EXCISE','BOND_REG') THEN
1302: --jai_constants.tax_type_sh_exc_edu_cess,jai_constants.tax_type_sh_cvd_edu_cess added by csahoo for bug#6081806
1303: IF Tax_Type_Rec.T_Type IN ('Excise','Addl. Excise','Other Excise','EXCISE_EDUCATION_CESS','CVD_EDUCATION_CESS',jai_constants.tax_type_sh_exc_edu_cess,jai_constants.tax_type_sh_cvd_edu_cess) THEN
1304: TAX_TYPE_REC.tax_amt := 0;
1305: END IF;
1306: END IF;
1307:

Line 1323: -- jai_constants.tax_type_sh_exc_edu_cess,jai_constants.tax_type_sh_cvd_edu_cess added by csahoo for bug#6081806

1319: /*
1320: || added by CSahoo - bug# 5390583 In case of bond reg , the excise taxes should not go to base AR tables.
1321: */
1322: IF NVL(v_register_code,'N') = 'BOND_REG' THEN
1323: -- jai_constants.tax_type_sh_exc_edu_cess,jai_constants.tax_type_sh_cvd_edu_cess added by csahoo for bug#6081806
1324: IF upper(Tax_Type_Rec.T_Type) IN ('EXCISE','ADDL. EXCISE','OTHER EXCISE','EXCISE_EDUCATION_CESS','CVD_EDUCATION_CESS',jai_constants.tax_type_sh_exc_edu_cess,jai_constants.tax_type_sh_cvd_edu_cess) THEN
1325: TAX_TYPE_REC.tax_amt := 0;
1326: END IF;
1327: END IF;

Line 1324: IF upper(Tax_Type_Rec.T_Type) IN ('EXCISE','ADDL. EXCISE','OTHER EXCISE','EXCISE_EDUCATION_CESS','CVD_EDUCATION_CESS',jai_constants.tax_type_sh_exc_edu_cess,jai_constants.tax_type_sh_cvd_edu_cess) THEN

1320: || added by CSahoo - bug# 5390583 In case of bond reg , the excise taxes should not go to base AR tables.
1321: */
1322: IF NVL(v_register_code,'N') = 'BOND_REG' THEN
1323: -- jai_constants.tax_type_sh_exc_edu_cess,jai_constants.tax_type_sh_cvd_edu_cess added by csahoo for bug#6081806
1324: IF upper(Tax_Type_Rec.T_Type) IN ('EXCISE','ADDL. EXCISE','OTHER EXCISE','EXCISE_EDUCATION_CESS','CVD_EDUCATION_CESS',jai_constants.tax_type_sh_exc_edu_cess,jai_constants.tax_type_sh_cvd_edu_cess) THEN
1325: TAX_TYPE_REC.tax_amt := 0;
1326: END IF;
1327: END IF;
1328:

Line 1367: IF upper(tax_type_rec.t_type) = upper(jai_constants.tax_type_service) OR

1363: || The following code has been added by aiyer for the bug 4089440
1364: || IF tax type is SERVICE or SERVICE-CESS then get the account info from regime setup
1365: || IF no setup is found then raise an error and stop the transaction.
1366: */
1367: IF upper(tax_type_rec.t_type) = upper(jai_constants.tax_type_service) OR
1368: upper(tax_type_rec.t_type) = upper(jai_constants.tax_type_service_edu_cess)
1369: OR upper(tax_type_rec.t_type)= upper(jai_constants.tax_type_sh_service_edu_cess) -- added by csahoo for bug#6081806
1370: THEN -- Start of A1
1371:

Line 1368: upper(tax_type_rec.t_type) = upper(jai_constants.tax_type_service_edu_cess)

1364: || IF tax type is SERVICE or SERVICE-CESS then get the account info from regime setup
1365: || IF no setup is found then raise an error and stop the transaction.
1366: */
1367: IF upper(tax_type_rec.t_type) = upper(jai_constants.tax_type_service) OR
1368: upper(tax_type_rec.t_type) = upper(jai_constants.tax_type_service_edu_cess)
1369: OR upper(tax_type_rec.t_type)= upper(jai_constants.tax_type_sh_service_edu_cess) -- added by csahoo for bug#6081806
1370: THEN -- Start of A1
1371:
1372: /*################################################################################################################

Line 1369: OR upper(tax_type_rec.t_type)= upper(jai_constants.tax_type_sh_service_edu_cess) -- added by csahoo for bug#6081806

1365: || IF no setup is found then raise an error and stop the transaction.
1366: */
1367: IF upper(tax_type_rec.t_type) = upper(jai_constants.tax_type_service) OR
1368: upper(tax_type_rec.t_type) = upper(jai_constants.tax_type_service_edu_cess)
1369: OR upper(tax_type_rec.t_type)= upper(jai_constants.tax_type_sh_service_edu_cess) -- added by csahoo for bug#6081806
1370: THEN -- Start of A1
1371:
1372: /*################################################################################################################
1373: || Get the regime id and also validate the Regime/Regime Registratiom Setup Information

Line 1376: jai_ar_rgm_processing_pkg.get_regime_info ( p_regime_code => jai_constants.service_regime ,

1372: /*################################################################################################################
1373: || Get the regime id and also validate the Regime/Regime Registratiom Setup Information
1374: ################################################################################################################*/
1375:
1376: jai_ar_rgm_processing_pkg.get_regime_info ( p_regime_code => jai_constants.service_regime ,
1377: p_tax_type_code => tax_type_rec.t_type ,
1378: p_regime_id => ln_regime_id ,
1379: p_error_flag => lv_error_flag ,
1380: p_error_message => lv_error_message

Line 1383: IF lv_error_flag <> jai_constants.successful THEN

1379: p_error_flag => lv_error_flag ,
1380: p_error_message => lv_error_message
1381: );
1382:
1383: IF lv_error_flag <> jai_constants.successful THEN
1384: /*
1385: || Encountered an error from the call to jai_ar_rgm_processing_pkg.get_regime_info
1386: || Stop processing and thorw an error
1387: */

Line 1388: /* raise_application_error (-20130,lv_error_message); */ pv_return_code := jai_constants.expected_error ; pv_return_message := lv_error_message ; return ;

1384: /*
1385: || Encountered an error from the call to jai_ar_rgm_processing_pkg.get_regime_info
1386: || Stop processing and thorw an error
1387: */
1388: /* raise_application_error (-20130,lv_error_message); */ pv_return_code := jai_constants.expected_error ; pv_return_message := lv_error_message ; return ;
1389: /*
1390: app_exception.raise_exception( EXCEPTION_TYPE => 'APP',
1391: EXCEPTION_CODE => NULL ,
1392: EXCEPTION_TEXT => lv_error_message

Line 1409: p_organization_type => jai_constants.service_tax_orgn_type ,

1405: */
1406:
1407: v_ccid := jai_cmn_rgm_recording_pkg.get_account (
1408: p_regime_id => ln_regime_id ,
1409: p_organization_type => jai_constants.service_tax_orgn_type ,
1410: p_organization_id => v_organization_id ,
1411: p_location_id => v_location_id ,
1412: p_tax_type => tax_type_rec.t_type ,
1413: p_account_name => jai_constants.liability_interim

Line 1413: p_account_name => jai_constants.liability_interim

1409: p_organization_type => jai_constants.service_tax_orgn_type ,
1410: p_organization_id => v_organization_id ,
1411: p_location_id => v_location_id ,
1412: p_tax_type => tax_type_rec.t_type ,
1413: p_account_name => jai_constants.liability_interim
1414: );
1415:
1416: IF v_ccid IS NULL THEN
1417: /*

Line 1422: pv_return_code := jai_constants.expected_error ; pv_return_message := 'Invalid Code combination,please check the Service Tax - Tax Accounting Setup' ; return ;

1418: || Code Combination id has been returned as null from the function jai_cmn_rgm_recording_pkg.get_account
1419: || This is an error condition and the current processing has to be stopped
1420: */
1421: /* raise_application_error (-20130,'Invalid Code combination, please check the Service Tax - Tax Accounting Setup'); */
1422: pv_return_code := jai_constants.expected_error ; pv_return_message := 'Invalid Code combination,please check the Service Tax - Tax Accounting Setup' ; return ;
1423: /*
1424: app_exception.raise_exception( EXCEPTION_TYPE => 'APP',
1425: EXCEPTION_CODE => NULL ,
1426: EXCEPTION_TEXT => 'Invalid Code combination, please check the Service Tax - Tax Type Accounting Setup'

Line 1438: ELSIF UPPER(nvl(ln_regime_code,'####')) = jai_constants.vat_regime THEN

1434: || Start of bug 4212816
1435: || Code modified by aiyer for the VAT Enhancement
1436: || Get the Tax accounting information from the vat regime setup when the taxes are as mentioned below taxes
1437: */
1438: ELSIF UPPER(nvl(ln_regime_code,'####')) = jai_constants.vat_regime THEN
1439:
1440: /*********************************************************************************************************
1441: || Validate whether the item attached is vatable or not
1442: *********************************************************************************************************/

Line 1448: p_attribute_code => jai_constants.rgm_attr_item_applicable ,

1444: jai_inv_items_pkg.jai_get_attrib (
1445: p_regime_code => ln_regime_code ,
1446: p_organization_id => v_organization_id ,
1447: p_inventory_item_id => pr_new.inventory_item_id ,
1448: p_attribute_code => jai_constants.rgm_attr_item_applicable ,
1449: p_attribute_value => lv_attr_value ,
1450: p_process_flag => lv_error_flag ,
1451: p_process_msg => lv_error_message
1452: ) ;

Line 1454: IF lv_error_flag <> jai_constants.successful THEN

1450: p_process_flag => lv_error_flag ,
1451: p_process_msg => lv_error_message
1452: ) ;
1453:
1454: IF lv_error_flag <> jai_constants.successful THEN
1455: /*
1456: || Encountered an error from the call to jai_ar_rgm_processing_pkg.get_regime_info
1457: || Stop processing and thorw an error
1458: */

Line 1459: /* raise_application_error (-20130,lv_error_message); */ pv_return_code := jai_constants.expected_error ; pv_return_message := lv_error_message ; return ;

1455: /*
1456: || Encountered an error from the call to jai_ar_rgm_processing_pkg.get_regime_info
1457: || Stop processing and thorw an error
1458: */
1459: /* raise_application_error (-20130,lv_error_message); */ pv_return_code := jai_constants.expected_error ; pv_return_message := lv_error_message ; return ;
1460: /*
1461: app_exception.raise_exception( EXCEPTION_TYPE => 'APP',
1462: EXCEPTION_CODE => NULL ,
1463: EXCEPTION_TEXT => lv_error_message

Line 1478: /* raise_application_error (-20130,'ITEM not vatable'); */ pv_return_code := jai_constants.expected_error ; pv_return_message := 'ITEM not vatable' ; return ;

1474:
1475: /*
1476: || Item is not vatable . Stop processing and throw an error
1477: */
1478: /* raise_application_error (-20130,'ITEM not vatable'); */ pv_return_code := jai_constants.expected_error ; pv_return_message := 'ITEM not vatable' ; return ;
1479: /* DO not delete this code, enable this code while doing the messageing project
1480: app_exception.raise_exception( EXCEPTION_TYPE => 'APP',
1481: EXCEPTION_CODE => NULL ,
1482: EXCEPTION_TEXT => 'Cannot attach VAT type of taxes to non vatable items.'

Line 1500: p_organization_type => jai_constants.orgn_type_io ,

1496: */
1497:
1498: v_ccid := jai_cmn_rgm_recording_pkg.get_account (
1499: p_regime_id => ln_regime_id ,
1500: p_organization_type => jai_constants.orgn_type_io ,
1501: p_organization_id => v_organization_id ,
1502: p_location_id => v_location_id ,
1503: p_tax_type => tax_type_rec.t_type ,
1504: p_account_name => jai_constants.liability_interim

Line 1504: p_account_name => jai_constants.liability_interim

1500: p_organization_type => jai_constants.orgn_type_io ,
1501: p_organization_id => v_organization_id ,
1502: p_location_id => v_location_id ,
1503: p_tax_type => tax_type_rec.t_type ,
1504: p_account_name => jai_constants.liability_interim
1505: );
1506: IF v_ccid IS NULL THEN
1507: /*
1508: || Code Combination id has been returned as null from the function jai_cmn_rgm_recording_pkg.get_account

Line 1512: pv_return_code := jai_constants.expected_error ; pv_return_message := 'Invalid Code combination ,please check the VAT Tax - Tax Accounting Setup' ; return ;

1508: || Code Combination id has been returned as null from the function jai_cmn_rgm_recording_pkg.get_account
1509: || This is an error condition and the current processing has to be stopped
1510: */
1511: /* raise_application_error (-20130,'Invalid Code combination ,please check the VAT Tax - Tax Accounting Setup'); */
1512: pv_return_code := jai_constants.expected_error ; pv_return_message := 'Invalid Code combination ,please check the VAT Tax - Tax Accounting Setup' ; return ;
1513: /*
1514: app_exception.raise_exception( EXCEPTION_TYPE => 'APP',
1515: EXCEPTION_CODE => NULL ,
1516: EXCEPTION_TEXT => 'Invalid Code combination ,please check the VAT Tax - Tax Type Accounting Setup'

Line 1527: ELSIF UPPER(nvl(ln_regime_code,'####')) = jai_constants.tcs_regime THEN -- Start of A1

1523: */
1524:
1525:
1526: /* Added by CSahoo for the TCS enhancements Bug# 5631784 */
1527: ELSIF UPPER(nvl(ln_regime_code,'####')) = jai_constants.tcs_regime THEN -- Start of A1
1528:
1529: /*********************************************************************************************************
1530: || Get the code combination id from the Organization/Regime Registration setup
1531: || by calling the function jai_rgm_trx_recording_pkg.get_account

Line 1537: p_organization_type => jai_constants.orgn_type_io ,

1533:
1534:
1535: v_ccid := jai_cmn_rgm_recording_pkg.get_account (
1536: p_regime_id => ln_regime_id ,
1537: p_organization_type => jai_constants.orgn_type_io ,
1538: p_organization_id => v_organization_id ,
1539: p_location_id => v_location_id ,
1540: p_tax_type => tax_type_rec.t_type ,
1541: p_account_name => jai_constants.liability_interim

Line 1541: p_account_name => jai_constants.liability_interim

1537: p_organization_type => jai_constants.orgn_type_io ,
1538: p_organization_id => v_organization_id ,
1539: p_location_id => v_location_id ,
1540: p_tax_type => tax_type_rec.t_type ,
1541: p_account_name => jai_constants.liability_interim
1542: );
1543: IF v_ccid IS NULL THEN
1544: /**********************************************************************************************************
1545: || Code Combination id has been returned as null from the function jai_rgm_trx_recording_pkg.get_account

Line 1639: Pv_return_code := jai_constants.unexpected_error;

1635: END IF;
1636: /* Added an exception block by Ramananda for bug#4570303 */
1637: EXCEPTION
1638: WHEN OTHERS THEN
1639: Pv_return_code := jai_constants.unexpected_error;
1640: Pv_return_message := 'Encountered an error in JAI_JAR_TL_TRIGGER_PKG.ARU_T1 ' || substr(sqlerrm,1,1900);
1641:
1642: END ARU_T1 ;
1643: