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 404: pv_return_code := jai_constants.successful ;

400: -- Added by zhiwei for GST get ccid by regime setup BUG#10233402 20101027 END
401: lv_trx_type ra_cust_trx_types_all.type%TYPE; --Added by Wenqiong for Bug 14253668
402:
403: BEGIN
404: pv_return_code := jai_constants.successful ;
405: /*------------------------------------------------------------------------------------------
406: FILENAME: JA_IN_APPS_AR_LINES_INSERT_TRG.sql
407: CHANGE HISTORY:
408: S.No Date Author and Details

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

863: /*commented for bug#10048317 as the functionality has been obsoleted as part of inclusive tax ER*
864: IF NVL(v_register_code,'N') IN ('23D_EXPORT_WITHOUT_EXCISE','23D_EXPORT_EXCISE',
865: '23D_DOMESTIC_EXCISE','23D_DOM_WITHOUT_EXCISE','BOND_REG')
866: THEN
867: -- jai_constants.tax_type_sh_exc_edu_cess,jai_constants.tax_type_sh_cvd_edu_cess added by csahoo for bug#6081806
868: 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
869: TAX_TYPE_REC.tax_amt := 0;
870: END IF;
871: END IF;

Line 868: 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

864: IF NVL(v_register_code,'N') IN ('23D_EXPORT_WITHOUT_EXCISE','23D_EXPORT_EXCISE',
865: '23D_DOMESTIC_EXCISE','23D_DOM_WITHOUT_EXCISE','BOND_REG')
866: THEN
867: -- jai_constants.tax_type_sh_exc_edu_cess,jai_constants.tax_type_sh_cvd_edu_cess added by csahoo for bug#6081806
868: 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
869: TAX_TYPE_REC.tax_amt := 0;
870: END IF;
871: END IF;
872: */

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

885: /*
886: || added by CSahoo - bug# 5390583 In case of bond reg , the excise taxes should not go to base AR tables.
887: */
888: IF NVL(v_register_code,'N') = 'BOND_REG' THEN
889: -- jai_constants.tax_type_sh_exc_edu_cess,jai_constants.tax_type_sh_cvd_edu_cess added by csahoo for bug#6081806
890: 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
891: TAX_TYPE_REC.tax_amt := 0;
892: END IF;
893: END IF;

Line 890: 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

886: || added by CSahoo - bug# 5390583 In case of bond reg , the excise taxes should not go to base AR tables.
887: */
888: IF NVL(v_register_code,'N') = 'BOND_REG' THEN
889: -- jai_constants.tax_type_sh_exc_edu_cess,jai_constants.tax_type_sh_cvd_edu_cess added by csahoo for bug#6081806
890: 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
891: TAX_TYPE_REC.tax_amt := 0;
892: END IF;
893: END IF;
894:

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

920: || The following code has been added by aiyer for the bug 4089440
921: || IF tax type is SERVICE or SERVICE-CESS then get the account info from regime setup
922: || IF no setup is found then raise an error and stop the transaction.
923: */
924: IF upper(tax_type_rec.t_type) = upper(jai_constants.tax_type_service) OR
925: upper(tax_type_rec.t_type) = upper(jai_constants.tax_type_service_edu_cess)
926: OR upper(tax_type_rec.t_type)= upper(jai_constants.tax_type_sh_service_edu_cess) --added by csahoo for bug#6081806
927: THEN -- Start of A1
928:

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

921: || IF tax type is SERVICE or SERVICE-CESS then get the account info from regime setup
922: || IF no setup is found then raise an error and stop the transaction.
923: */
924: IF upper(tax_type_rec.t_type) = upper(jai_constants.tax_type_service) OR
925: upper(tax_type_rec.t_type) = upper(jai_constants.tax_type_service_edu_cess)
926: OR upper(tax_type_rec.t_type)= upper(jai_constants.tax_type_sh_service_edu_cess) --added by csahoo for bug#6081806
927: THEN -- Start of A1
928:
929: /**********************************************************************************************************

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

922: || IF no setup is found then raise an error and stop the transaction.
923: */
924: IF upper(tax_type_rec.t_type) = upper(jai_constants.tax_type_service) OR
925: upper(tax_type_rec.t_type) = upper(jai_constants.tax_type_service_edu_cess)
926: OR upper(tax_type_rec.t_type)= upper(jai_constants.tax_type_sh_service_edu_cess) --added by csahoo for bug#6081806
927: THEN -- Start of A1
928:
929: /**********************************************************************************************************
930: || Get the regime id and also validate the Regime/Regime Registratiom Setup Information

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

929: /**********************************************************************************************************
930: || Get the regime id and also validate the Regime/Regime Registratiom Setup Information
931: ***********************************************************************************************************/
932:
933: jai_ar_rgm_processing_pkg.get_regime_info ( p_regime_code => jai_constants.service_regime ,
934: p_tax_type_code => tax_type_rec.t_type ,
935: p_regime_id => ln_regime_id ,
936: p_error_flag => lv_error_flag ,
937: p_error_message => lv_error_message

Line 940: IF lv_error_flag <> jai_constants.successful THEN

936: p_error_flag => lv_error_flag ,
937: p_error_message => lv_error_message
938: );
939:
940: IF lv_error_flag <> jai_constants.successful THEN
941: /*
942: || Encountered an error from the call to jai_ar_rgm_processing_pkg.get_regime_info
943: || Stop processing and thorw an error
944: */

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

942: || Encountered an error from the call to jai_ar_rgm_processing_pkg.get_regime_info
943: || Stop processing and thorw an error
944: */
945: /* raise_application_error (-20130,lv_error_message);
946: */ pv_return_code := jai_constants.expected_error ; pv_return_message := lv_error_message ; return ;
947: END IF ;
948: /**********************************************************************************************************
949: || Get Tax Account Info from the Regime Organization/Regime Registration setup
950: **********************************************************************************************************/

Line 977: IF nvl(lv_trx_type,'#') <> jai_constants.ar_invoice_type_cm THEN--Added by Wenqiong for Bug 14253668

973: -------------------------------------------
974: --Added by Wenqiong for Bug 14253668 end
975:
976: IF ld_trx_date >= ld_st_accrual_date THEN
977: IF nvl(lv_trx_type,'#') <> jai_constants.ar_invoice_type_cm THEN--Added by Wenqiong for Bug 14253668
978: v_ccid := jai_cmn_rgm_recording_pkg.get_account (
979: p_regime_id => ln_regime_id ,
980: p_organization_type => jai_constants.service_tax_orgn_type ,
981: p_organization_id => v_organization_id ,

Line 980: p_organization_type => jai_constants.service_tax_orgn_type ,

976: IF ld_trx_date >= ld_st_accrual_date THEN
977: IF nvl(lv_trx_type,'#') <> jai_constants.ar_invoice_type_cm THEN--Added by Wenqiong for Bug 14253668
978: v_ccid := jai_cmn_rgm_recording_pkg.get_account (
979: p_regime_id => ln_regime_id ,
980: p_organization_type => jai_constants.service_tax_orgn_type ,
981: p_organization_id => v_organization_id ,
982: p_location_id => v_location_id ,
983: p_tax_type => tax_type_rec.t_type ,
984: p_account_name => jai_constants.liability

Line 984: p_account_name => jai_constants.liability

980: p_organization_type => jai_constants.service_tax_orgn_type ,
981: p_organization_id => v_organization_id ,
982: p_location_id => v_location_id ,
983: p_tax_type => tax_type_rec.t_type ,
984: p_account_name => jai_constants.liability
985: );
986: --Added by Wenqiong for Bug 14253668 begin
987: ELSIF nvl(lv_trx_type,'#') = jai_constants.ar_invoice_type_cm THEN
988: v_ccid := jai_cmn_rgm_recording_pkg.get_account (

Line 987: ELSIF nvl(lv_trx_type,'#') = jai_constants.ar_invoice_type_cm THEN

983: p_tax_type => tax_type_rec.t_type ,
984: p_account_name => jai_constants.liability
985: );
986: --Added by Wenqiong for Bug 14253668 begin
987: ELSIF nvl(lv_trx_type,'#') = jai_constants.ar_invoice_type_cm THEN
988: v_ccid := jai_cmn_rgm_recording_pkg.get_account (
989: p_regime_id => ln_regime_id ,
990: p_organization_type => jai_constants.service_tax_orgn_type ,
991: p_organization_id => v_organization_id ,

Line 990: p_organization_type => jai_constants.service_tax_orgn_type ,

986: --Added by Wenqiong for Bug 14253668 begin
987: ELSIF nvl(lv_trx_type,'#') = jai_constants.ar_invoice_type_cm THEN
988: v_ccid := jai_cmn_rgm_recording_pkg.get_account (
989: p_regime_id => ln_regime_id ,
990: p_organization_type => jai_constants.service_tax_orgn_type ,
991: p_organization_id => v_organization_id ,
992: p_location_id => v_location_id ,
993: p_tax_type => tax_type_rec.t_type ,
994: p_account_name => jai_constants.recovery

Line 994: p_account_name => jai_constants.recovery

990: p_organization_type => jai_constants.service_tax_orgn_type ,
991: p_organization_id => v_organization_id ,
992: p_location_id => v_location_id ,
993: p_tax_type => tax_type_rec.t_type ,
994: p_account_name => jai_constants.recovery
995: );
996: END IF;
997: --Added by Wenqiong for Bug 14253668 end
998: ELSE

Line 999: IF nvl(lv_trx_type,'#') <> jai_constants.ar_invoice_type_cm THEN --Added by Wenqiong for Bug 14253668

995: );
996: END IF;
997: --Added by Wenqiong for Bug 14253668 end
998: ELSE
999: IF nvl(lv_trx_type,'#') <> jai_constants.ar_invoice_type_cm THEN --Added by Wenqiong for Bug 14253668
1000: v_ccid := jai_cmn_rgm_recording_pkg.get_account (
1001: p_regime_id => ln_regime_id ,
1002: p_organization_type => jai_constants.service_tax_orgn_type ,
1003: p_organization_id => v_organization_id ,

Line 1002: p_organization_type => jai_constants.service_tax_orgn_type ,

998: ELSE
999: IF nvl(lv_trx_type,'#') <> jai_constants.ar_invoice_type_cm THEN --Added by Wenqiong for Bug 14253668
1000: v_ccid := jai_cmn_rgm_recording_pkg.get_account (
1001: p_regime_id => ln_regime_id ,
1002: p_organization_type => jai_constants.service_tax_orgn_type ,
1003: p_organization_id => v_organization_id ,
1004: p_location_id => v_location_id ,
1005: p_tax_type => tax_type_rec.t_type ,
1006: p_account_name => jai_constants.liability_interim

Line 1006: p_account_name => jai_constants.liability_interim

1002: p_organization_type => jai_constants.service_tax_orgn_type ,
1003: p_organization_id => v_organization_id ,
1004: p_location_id => v_location_id ,
1005: p_tax_type => tax_type_rec.t_type ,
1006: p_account_name => jai_constants.liability_interim
1007: );
1008: --Added by Wenqiong for Bug 14253668 begin
1009: ELSIF nvl(lv_trx_type,'#') = jai_constants.ar_invoice_type_cm THEN
1010: v_ccid := jai_cmn_rgm_recording_pkg.get_account (

Line 1009: ELSIF nvl(lv_trx_type,'#') = jai_constants.ar_invoice_type_cm THEN

1005: p_tax_type => tax_type_rec.t_type ,
1006: p_account_name => jai_constants.liability_interim
1007: );
1008: --Added by Wenqiong for Bug 14253668 begin
1009: ELSIF nvl(lv_trx_type,'#') = jai_constants.ar_invoice_type_cm THEN
1010: v_ccid := jai_cmn_rgm_recording_pkg.get_account (
1011: p_regime_id => ln_regime_id ,
1012: p_organization_type => jai_constants.service_tax_orgn_type ,
1013: p_organization_id => v_organization_id ,

Line 1012: p_organization_type => jai_constants.service_tax_orgn_type ,

1008: --Added by Wenqiong for Bug 14253668 begin
1009: ELSIF nvl(lv_trx_type,'#') = jai_constants.ar_invoice_type_cm THEN
1010: v_ccid := jai_cmn_rgm_recording_pkg.get_account (
1011: p_regime_id => ln_regime_id ,
1012: p_organization_type => jai_constants.service_tax_orgn_type ,
1013: p_organization_id => v_organization_id ,
1014: p_location_id => v_location_id ,
1015: p_tax_type => tax_type_rec.t_type ,
1016: p_account_name => jai_constants.recovery_interim

Line 1016: p_account_name => jai_constants.recovery_interim

1012: p_organization_type => jai_constants.service_tax_orgn_type ,
1013: p_organization_id => v_organization_id ,
1014: p_location_id => v_location_id ,
1015: p_tax_type => tax_type_rec.t_type ,
1016: p_account_name => jai_constants.recovery_interim
1017: );
1018: END IF;
1019: --Added by Wenqiong for Bug 14253668 end
1020: END IF;

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

1025: || Code Combination id has been returned as null from the function jai_cmn_rgm_recording_pkg.get_account
1026: || This is an error condition and the current processing has to be stopped
1027: */
1028: /* raise_application_error (-20130,'Invalid Code combination ,please check the Service Tax - Tax Accounting Setup');
1029: */ pv_return_code := jai_constants.expected_error ; pv_return_message := 'Invalid Code combination ,please check the Service Tax - Tax Accounting Setup' ; return ;
1030: END IF;
1031: /*
1032: || Start of bug 4212816
1033: || Code modified by aiyer for the VAT Enhancement

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

1033: || Code modified by aiyer for the VAT Enhancement
1034: || Get the Tax accounting information from the vat regime setup when the taxes are as mentioned below taxes
1035: */
1036:
1037: ELSIF UPPER(nvl(ln_regime_code,'####')) = jai_constants.vat_regime THEN
1038:
1039: /*********************************************************************************************************
1040: || Validate whether the item attached is vatable or not
1041: *********************************************************************************************************/

Line 1047: p_attribute_code => jai_constants.rgm_attr_item_applicable ,

1043: jai_inv_items_pkg.jai_get_attrib (
1044: p_regime_code => ln_regime_code ,
1045: p_organization_id => v_organization_id ,
1046: p_inventory_item_id => pr_new.inventory_item_id ,
1047: p_attribute_code => jai_constants.rgm_attr_item_applicable ,
1048: p_attribute_value => lv_attr_value ,
1049: p_process_flag => lv_error_flag ,
1050: p_process_msg => lv_error_message
1051: ) ;

Line 1052: IF lv_error_flag <> jai_constants.successful THEN

1048: p_attribute_value => lv_attr_value ,
1049: p_process_flag => lv_error_flag ,
1050: p_process_msg => lv_error_message
1051: ) ;
1052: IF lv_error_flag <> jai_constants.successful THEN
1053: /*
1054: || Encountered an error from the call to jai_ar_rgm_processing_pkg.get_regime_info
1055: || Stop processing and thorw an error
1056: */

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

1053: /*
1054: || Encountered an error from the call to jai_ar_rgm_processing_pkg.get_regime_info
1055: || Stop processing and thorw an error
1056: */
1057: /* raise_application_error (-20130,lv_error_message); */ pv_return_code := jai_constants.expected_error ; pv_return_message := lv_error_message ; return ;
1058: /*
1059: app_exception.raise_exception( EXCEPTION_TYPE => 'APP',
1060: EXCEPTION_CODE => NULL ,
1061: EXCEPTION_TEXT => lv_error_message

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

1072: /* above if condition before the if added by ssumaith - bug# 6104491 */
1073: /*
1074: || Item is not vatable . Stop processing and throw an error
1075: */
1076: /* raise_application_error (-20130,'ITEM not vatable'); */ pv_return_code := jai_constants.expected_error ; pv_return_message := 'ITEM not vatable' ; return ;
1077: /* DO not delete this code, enable this code while doing the messageing project
1078: app_exception.raise_exception( EXCEPTION_TYPE => 'APP',
1079: EXCEPTION_CODE => NULL ,
1080: EXCEPTION_TEXT => 'Cannot attach VAT type of taxes to non vatable items.'

Line 1118: p_organization_type => jai_constants.orgn_type_io ,

1114: IF ln_rma_flag > 0 OR ln_nonship_rma_flag > 0
1115: THEN
1116: v_ccid := jai_cmn_rgm_recording_pkg.get_account (
1117: p_regime_id => ln_regime_id ,
1118: p_organization_type => jai_constants.orgn_type_io ,
1119: p_organization_id => v_organization_id ,
1120: p_location_id => v_location_id ,
1121: p_tax_type => tax_type_rec.t_type ,
1122: p_account_name => jai_constants.recovery

Line 1122: p_account_name => jai_constants.recovery

1118: p_organization_type => jai_constants.orgn_type_io ,
1119: p_organization_id => v_organization_id ,
1120: p_location_id => v_location_id ,
1121: p_tax_type => tax_type_rec.t_type ,
1122: p_account_name => jai_constants.recovery
1123: );
1124: ELSE
1125: ----------------------------------------------------------------------
1126: --Added by Bo Li for Bug 9705313 End

Line 1129: p_organization_type => jai_constants.orgn_type_io ,

1125: ----------------------------------------------------------------------
1126: --Added by Bo Li for Bug 9705313 End
1127: v_ccid := jai_cmn_rgm_recording_pkg.get_account (
1128: p_regime_id => ln_regime_id ,
1129: p_organization_type => jai_constants.orgn_type_io ,
1130: p_organization_id => v_organization_id ,
1131: p_location_id => v_location_id ,
1132: p_tax_type => tax_type_rec.t_type ,
1133: p_account_name => jai_constants.liability_interim

Line 1133: p_account_name => jai_constants.liability_interim

1129: p_organization_type => jai_constants.orgn_type_io ,
1130: p_organization_id => v_organization_id ,
1131: p_location_id => v_location_id ,
1132: p_tax_type => tax_type_rec.t_type ,
1133: p_account_name => jai_constants.liability_interim
1134: );
1135:
1136: End IF; -- Added by Bo Li for Bug 9705313
1137: IF v_ccid IS NULL THEN

Line 1143: pv_return_code := jai_constants.expected_error ;

1139: || Code Combination id has been returned as null from the function jai_cmn_rgm_recording_pkg.get_account
1140: || This is an error condition and the current processing has to be stopped
1141: **********************************************************************************************************/
1142: /* raise_application_error (-20130,'Invalid Code combination ,please check the VAT Tax - Tax Accounting Setup'); */
1143: pv_return_code := jai_constants.expected_error ;
1144: pv_return_message := 'Invalid Code combination ,please check the VAT Tax - Tax Accounting Setup ' ;
1145: return ;
1146: /*
1147: app_exception.raise_exception( EXCEPTION_TYPE => 'APP',

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

1155: || End of bug 4212816
1156: */
1157:
1158: /* Added by CSahoo for the TCS enhancements Bug# 5631784 */
1159: ELSIF UPPER(nvl(ln_regime_code,'####')) = jai_constants.tcs_regime THEN -- Start of A1
1160:
1161: /*********************************************************************************************************
1162: || Get the code combination id from the Organization/Regime Registration setup
1163: || by calling the function jai_rgm_trx_recording_pkg.get_account

Line 1169: p_organization_type => jai_constants.orgn_type_io ,

1165:
1166:
1167: v_ccid := jai_cmn_rgm_recording_pkg.get_account (
1168: p_regime_id => ln_regime_id ,
1169: p_organization_type => jai_constants.orgn_type_io ,
1170: p_organization_id => v_organization_id ,
1171: p_location_id => v_location_id ,
1172: p_tax_type => tax_type_rec.t_type ,
1173: p_account_name => jai_constants.liability_interim

Line 1173: p_account_name => jai_constants.liability_interim

1169: p_organization_type => jai_constants.orgn_type_io ,
1170: p_organization_id => v_organization_id ,
1171: p_location_id => v_location_id ,
1172: p_tax_type => tax_type_rec.t_type ,
1173: p_account_name => jai_constants.liability_interim
1174: );
1175: IF v_ccid IS NULL THEN
1176: /**********************************************************************************************************
1177: || Code Combination id has been returned as null from the function jai_rgm_trx_recording_pkg.get_account

Line 1260: */ 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

1256: EXCEPTION
1257: WHEN OTHERS THEN
1258: v_err_mesg := SQLERRM;
1259: /* RAISE_APPLICATION_ERROR(-20003,'error in processing the invoice ..' || v_trx_num || v_err_mesg);
1260: */ 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
1261: END;
1262: -- the following if added by Sriram / Pavan on 06-May-2002
1263: IF v_created_from = 'ARXTWMAI' AND v_tax_exists = 1 THEN --added condition of v_tax_exists by mmurtuza for bug 13042890
1264: result := fnd_request.set_mode(TRUE);

Line 1643: pv_return_code := jai_constants.successful ;

1639: return lv_hdr_ctx;
1640: END get_hdr_ctx;
1641:
1642: BEGIN
1643: pv_return_code := jai_constants.successful ;
1644: /*------------------------------------------------------------------------------------------
1645: FILENAME: JA_IN_APPS_AR_LINES_UPDATE_TRG.sql
1646: CHANGE HISTORY:
1647: S.No Date Author and Details

Line 1787: --jai_constants.tax_type_sh_exc_edu_cess,jai_constants.tax_type_sh_cvd_edu_ces

1783: ('23D_EXPORT_WITHOUT_EXCISE','23D_EXPORT_EXCISE',
1784:
1785: '23D_DOMESTIC_EXCISE','23D_DOM_WITHOUT_EXCISE','BOND_REG') THEN
1786:
1787: --jai_constants.tax_type_sh_exc_edu_cess,jai_constants.tax_type_sh_cvd_edu_ces
1788: s added by csahoo for bug#6081806
1789: IF Tax_Type_Rec.T_Type IN ('Excise','Addl. Excise','Other
1790: Excise','EXCISE_EDUCATION_CESS','CVD_EDUCATION_CESS',jai_constants.tax_type_sh
1791: _exc_edu_cess,jai_constants.tax_type_sh_cvd_edu_cess) THEN

Line 1790: Excise','EXCISE_EDUCATION_CESS','CVD_EDUCATION_CESS',jai_constants.tax_type_sh

1786:
1787: --jai_constants.tax_type_sh_exc_edu_cess,jai_constants.tax_type_sh_cvd_edu_ces
1788: s added by csahoo for bug#6081806
1789: IF Tax_Type_Rec.T_Type IN ('Excise','Addl. Excise','Other
1790: Excise','EXCISE_EDUCATION_CESS','CVD_EDUCATION_CESS',jai_constants.tax_type_sh
1791: _exc_edu_cess,jai_constants.tax_type_sh_cvd_edu_cess) THEN
1792: TAX_TYPE_REC.tax_amt := 0;
1793: END IF;
1794: END IF;

Line 1791: _exc_edu_cess,jai_constants.tax_type_sh_cvd_edu_cess) THEN

1787: --jai_constants.tax_type_sh_exc_edu_cess,jai_constants.tax_type_sh_cvd_edu_ces
1788: s added by csahoo for bug#6081806
1789: IF Tax_Type_Rec.T_Type IN ('Excise','Addl. Excise','Other
1790: Excise','EXCISE_EDUCATION_CESS','CVD_EDUCATION_CESS',jai_constants.tax_type_sh
1791: _exc_edu_cess,jai_constants.tax_type_sh_cvd_edu_cess) THEN
1792: TAX_TYPE_REC.tax_amt := 0;
1793: END IF;
1794: END IF;
1795:

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

2010: --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
2011: /*commented for bug#10048317 as the functionality has been obsoleted as part of inclusive tax ER*
2012: IF NVL(v_register_code,'N') IN ('23D_EXPORT_WITHOUT_EXCISE','23D_EXPORT_EXCISE',
2013: '23D_DOMESTIC_EXCISE','23D_DOM_WITHOUT_EXCISE','BOND_REG') THEN
2014: --jai_constants.tax_type_sh_exc_edu_cess,jai_constants.tax_type_sh_cvd_edu_cess added by csahoo for bug#6081806
2015: 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
2016: TAX_TYPE_REC.tax_amt := 0;
2017: END IF;
2018: END IF;

Line 2015: 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

2011: /*commented for bug#10048317 as the functionality has been obsoleted as part of inclusive tax ER*
2012: IF NVL(v_register_code,'N') IN ('23D_EXPORT_WITHOUT_EXCISE','23D_EXPORT_EXCISE',
2013: '23D_DOMESTIC_EXCISE','23D_DOM_WITHOUT_EXCISE','BOND_REG') THEN
2014: --jai_constants.tax_type_sh_exc_edu_cess,jai_constants.tax_type_sh_cvd_edu_cess added by csahoo for bug#6081806
2015: 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
2016: TAX_TYPE_REC.tax_amt := 0;
2017: END IF;
2018: END IF;
2019: */

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

2031: /*
2032: || added by CSahoo - bug# 5390583 In case of bond reg , the excise taxes should not go to base AR tables.
2033: */
2034: IF NVL(v_register_code,'N') = 'BOND_REG' THEN
2035: -- jai_constants.tax_type_sh_exc_edu_cess,jai_constants.tax_type_sh_cvd_edu_cess added by csahoo for bug#6081806
2036: 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
2037: TAX_TYPE_REC.tax_amt := 0;
2038: END IF;
2039: END IF;

Line 2036: 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

2032: || added by CSahoo - bug# 5390583 In case of bond reg , the excise taxes should not go to base AR tables.
2033: */
2034: IF NVL(v_register_code,'N') = 'BOND_REG' THEN
2035: -- jai_constants.tax_type_sh_exc_edu_cess,jai_constants.tax_type_sh_cvd_edu_cess added by csahoo for bug#6081806
2036: 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
2037: TAX_TYPE_REC.tax_amt := 0;
2038: END IF;
2039: END IF;
2040:

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

2110: || The following code has been added by aiyer for the bug 4089440
2111: || IF tax type is SERVICE or SERVICE-CESS then get the account info from regime setup
2112: || IF no setup is found then raise an error and stop the transaction.
2113: */
2114: IF upper(tax_type_rec.t_type) = upper(jai_constants.tax_type_service) OR
2115: upper(tax_type_rec.t_type) = upper(jai_constants.tax_type_service_edu_cess)
2116: OR upper(tax_type_rec.t_type)= upper(jai_constants.tax_type_sh_service_edu_cess) -- added by csahoo for bug#6081806
2117: THEN -- Start of A1
2118:

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

2111: || IF tax type is SERVICE or SERVICE-CESS then get the account info from regime setup
2112: || IF no setup is found then raise an error and stop the transaction.
2113: */
2114: IF upper(tax_type_rec.t_type) = upper(jai_constants.tax_type_service) OR
2115: upper(tax_type_rec.t_type) = upper(jai_constants.tax_type_service_edu_cess)
2116: OR upper(tax_type_rec.t_type)= upper(jai_constants.tax_type_sh_service_edu_cess) -- added by csahoo for bug#6081806
2117: THEN -- Start of A1
2118:
2119: /*################################################################################################################

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

2112: || IF no setup is found then raise an error and stop the transaction.
2113: */
2114: IF upper(tax_type_rec.t_type) = upper(jai_constants.tax_type_service) OR
2115: upper(tax_type_rec.t_type) = upper(jai_constants.tax_type_service_edu_cess)
2116: OR upper(tax_type_rec.t_type)= upper(jai_constants.tax_type_sh_service_edu_cess) -- added by csahoo for bug#6081806
2117: THEN -- Start of A1
2118:
2119: /*################################################################################################################
2120: || Get the regime id and also validate the Regime/Regime Registratiom Setup Information

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

2119: /*################################################################################################################
2120: || Get the regime id and also validate the Regime/Regime Registratiom Setup Information
2121: ################################################################################################################*/
2122:
2123: jai_ar_rgm_processing_pkg.get_regime_info ( p_regime_code => jai_constants.service_regime ,
2124: p_tax_type_code => tax_type_rec.t_type ,
2125: p_regime_id => ln_regime_id ,
2126: p_error_flag => lv_error_flag ,
2127: p_error_message => lv_error_message

Line 2130: IF lv_error_flag <> jai_constants.successful THEN

2126: p_error_flag => lv_error_flag ,
2127: p_error_message => lv_error_message
2128: );
2129:
2130: IF lv_error_flag <> jai_constants.successful THEN
2131: /*
2132: || Encountered an error from the call to jai_ar_rgm_processing_pkg.get_regime_info
2133: || Stop processing and thorw an error
2134: */

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

2131: /*
2132: || Encountered an error from the call to jai_ar_rgm_processing_pkg.get_regime_info
2133: || Stop processing and thorw an error
2134: */
2135: /* raise_application_error (-20130,lv_error_message); */ pv_return_code := jai_constants.expected_error ; pv_return_message := lv_error_message ; return ;
2136: /*
2137: app_exception.raise_exception( EXCEPTION_TYPE => 'APP',
2138: EXCEPTION_CODE => NULL ,
2139: EXCEPTION_TEXT => lv_error_message

Line 2174: IF nvl(lv_trx_type,'#') <> jai_constants.ar_invoice_type_cm THEN --Added by Wenqiong for Bug 14253668

2170: -------------------------------------------
2171: --Added by Wenqiong for Bug 14253668 end
2172:
2173: IF ld_trx_date >= ld_st_accrual_date THEN
2174: IF nvl(lv_trx_type,'#') <> jai_constants.ar_invoice_type_cm THEN --Added by Wenqiong for Bug 14253668
2175: v_ccid := jai_cmn_rgm_recording_pkg.get_account (
2176: p_regime_id => ln_regime_id ,
2177: p_organization_type => jai_constants.service_tax_orgn_type ,
2178: p_organization_id => v_organization_id ,

Line 2177: p_organization_type => jai_constants.service_tax_orgn_type ,

2173: IF ld_trx_date >= ld_st_accrual_date THEN
2174: IF nvl(lv_trx_type,'#') <> jai_constants.ar_invoice_type_cm THEN --Added by Wenqiong for Bug 14253668
2175: v_ccid := jai_cmn_rgm_recording_pkg.get_account (
2176: p_regime_id => ln_regime_id ,
2177: p_organization_type => jai_constants.service_tax_orgn_type ,
2178: p_organization_id => v_organization_id ,
2179: p_location_id => v_location_id ,
2180: p_tax_type => tax_type_rec.t_type ,
2181: p_account_name => jai_constants.liability

Line 2181: p_account_name => jai_constants.liability

2177: p_organization_type => jai_constants.service_tax_orgn_type ,
2178: p_organization_id => v_organization_id ,
2179: p_location_id => v_location_id ,
2180: p_tax_type => tax_type_rec.t_type ,
2181: p_account_name => jai_constants.liability
2182: );
2183: --Added by Wenqiong for Bug 14253668 begin
2184: ELSIF nvl(lv_trx_type,'#') = jai_constants.ar_invoice_type_cm THEN
2185: v_ccid := jai_cmn_rgm_recording_pkg.get_account (

Line 2184: ELSIF nvl(lv_trx_type,'#') = jai_constants.ar_invoice_type_cm THEN

2180: p_tax_type => tax_type_rec.t_type ,
2181: p_account_name => jai_constants.liability
2182: );
2183: --Added by Wenqiong for Bug 14253668 begin
2184: ELSIF nvl(lv_trx_type,'#') = jai_constants.ar_invoice_type_cm THEN
2185: v_ccid := jai_cmn_rgm_recording_pkg.get_account (
2186: p_regime_id => ln_regime_id ,
2187: p_organization_type => jai_constants.service_tax_orgn_type ,
2188: p_organization_id => v_organization_id ,

Line 2187: p_organization_type => jai_constants.service_tax_orgn_type ,

2183: --Added by Wenqiong for Bug 14253668 begin
2184: ELSIF nvl(lv_trx_type,'#') = jai_constants.ar_invoice_type_cm THEN
2185: v_ccid := jai_cmn_rgm_recording_pkg.get_account (
2186: p_regime_id => ln_regime_id ,
2187: p_organization_type => jai_constants.service_tax_orgn_type ,
2188: p_organization_id => v_organization_id ,
2189: p_location_id => v_location_id ,
2190: p_tax_type => tax_type_rec.t_type ,
2191: p_account_name => jai_constants.recovery

Line 2191: p_account_name => jai_constants.recovery

2187: p_organization_type => jai_constants.service_tax_orgn_type ,
2188: p_organization_id => v_organization_id ,
2189: p_location_id => v_location_id ,
2190: p_tax_type => tax_type_rec.t_type ,
2191: p_account_name => jai_constants.recovery
2192: );
2193:
2194:
2195: END IF;

Line 2198: IF nvl(lv_trx_type,'#') <> jai_constants.ar_invoice_type_cm THEN --Added by Wenqiong for Bug 14253668

2194:
2195: END IF;
2196: --Added by Wenqiong for Bug 14253668 end
2197: ELSE
2198: IF nvl(lv_trx_type,'#') <> jai_constants.ar_invoice_type_cm THEN --Added by Wenqiong for Bug 14253668
2199: v_ccid := jai_cmn_rgm_recording_pkg.get_account (
2200: p_regime_id => ln_regime_id ,
2201: p_organization_type => jai_constants.service_tax_orgn_type ,
2202: p_organization_id => v_organization_id ,

Line 2201: p_organization_type => jai_constants.service_tax_orgn_type ,

2197: ELSE
2198: IF nvl(lv_trx_type,'#') <> jai_constants.ar_invoice_type_cm THEN --Added by Wenqiong for Bug 14253668
2199: v_ccid := jai_cmn_rgm_recording_pkg.get_account (
2200: p_regime_id => ln_regime_id ,
2201: p_organization_type => jai_constants.service_tax_orgn_type ,
2202: p_organization_id => v_organization_id ,
2203: p_location_id => v_location_id ,
2204: p_tax_type => tax_type_rec.t_type ,
2205: p_account_name => jai_constants.liability_interim

Line 2205: p_account_name => jai_constants.liability_interim

2201: p_organization_type => jai_constants.service_tax_orgn_type ,
2202: p_organization_id => v_organization_id ,
2203: p_location_id => v_location_id ,
2204: p_tax_type => tax_type_rec.t_type ,
2205: p_account_name => jai_constants.liability_interim
2206: );
2207: --Added by Wenqiong for Bug 14253668 begin
2208: ELSIF nvl(lv_trx_type,'#') = jai_constants.ar_invoice_type_cm THEN
2209: v_ccid := jai_cmn_rgm_recording_pkg.get_account (

Line 2208: ELSIF nvl(lv_trx_type,'#') = jai_constants.ar_invoice_type_cm THEN

2204: p_tax_type => tax_type_rec.t_type ,
2205: p_account_name => jai_constants.liability_interim
2206: );
2207: --Added by Wenqiong for Bug 14253668 begin
2208: ELSIF nvl(lv_trx_type,'#') = jai_constants.ar_invoice_type_cm THEN
2209: v_ccid := jai_cmn_rgm_recording_pkg.get_account (
2210: p_regime_id => ln_regime_id ,
2211: p_organization_type => jai_constants.service_tax_orgn_type ,
2212: p_organization_id => v_organization_id ,

Line 2211: p_organization_type => jai_constants.service_tax_orgn_type ,

2207: --Added by Wenqiong for Bug 14253668 begin
2208: ELSIF nvl(lv_trx_type,'#') = jai_constants.ar_invoice_type_cm THEN
2209: v_ccid := jai_cmn_rgm_recording_pkg.get_account (
2210: p_regime_id => ln_regime_id ,
2211: p_organization_type => jai_constants.service_tax_orgn_type ,
2212: p_organization_id => v_organization_id ,
2213: p_location_id => v_location_id ,
2214: p_tax_type => tax_type_rec.t_type ,
2215: p_account_name => jai_constants.recovery_interim

Line 2215: p_account_name => jai_constants.recovery_interim

2211: p_organization_type => jai_constants.service_tax_orgn_type ,
2212: p_organization_id => v_organization_id ,
2213: p_location_id => v_location_id ,
2214: p_tax_type => tax_type_rec.t_type ,
2215: p_account_name => jai_constants.recovery_interim
2216: );
2217: END IF;
2218: --Added by Wenqiong for Bug 14253668 end
2219: END IF;

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

2224: || Code Combination id has been returned as null from the function jai_cmn_rgm_recording_pkg.get_account
2225: || This is an error condition and the current processing has to be stopped
2226: */
2227: /* raise_application_error (-20130,'Invalid Code combination, please check the Service Tax - Tax Accounting Setup'); */
2228: pv_return_code := jai_constants.expected_error ; pv_return_message := 'Invalid Code combination,please check the Service Tax - Tax Accounting Setup' ; return ;
2229: /*
2230: app_exception.raise_exception( EXCEPTION_TYPE => 'APP',
2231: EXCEPTION_CODE => NULL ,
2232: EXCEPTION_TEXT => 'Invalid Code combination, please check the Service Tax - Tax Type Accounting Setup'

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

2240: || Start of bug 4212816
2241: || Code modified by aiyer for the VAT Enhancement
2242: || Get the Tax accounting information from the vat regime setup when the taxes are as mentioned below taxes
2243: */
2244: ELSIF UPPER(nvl(ln_regime_code,'####')) = jai_constants.vat_regime THEN
2245:
2246: /*********************************************************************************************************
2247: || Validate whether the item attached is vatable or not
2248: *********************************************************************************************************/

Line 2254: p_attribute_code => jai_constants.rgm_attr_item_applicable ,

2250: jai_inv_items_pkg.jai_get_attrib (
2251: p_regime_code => ln_regime_code ,
2252: p_organization_id => v_organization_id ,
2253: p_inventory_item_id => pr_new.inventory_item_id ,
2254: p_attribute_code => jai_constants.rgm_attr_item_applicable ,
2255: p_attribute_value => lv_attr_value ,
2256: p_process_flag => lv_error_flag ,
2257: p_process_msg => lv_error_message
2258: ) ;

Line 2260: IF lv_error_flag <> jai_constants.successful THEN

2256: p_process_flag => lv_error_flag ,
2257: p_process_msg => lv_error_message
2258: ) ;
2259:
2260: IF lv_error_flag <> jai_constants.successful THEN
2261: /*
2262: || Encountered an error from the call to jai_ar_rgm_processing_pkg.get_regime_info
2263: || Stop processing and thorw an error
2264: */

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

2261: /*
2262: || Encountered an error from the call to jai_ar_rgm_processing_pkg.get_regime_info
2263: || Stop processing and thorw an error
2264: */
2265: /* raise_application_error (-20130,lv_error_message); */ pv_return_code := jai_constants.expected_error ; pv_return_message := lv_error_message ; return ;
2266: /*
2267: app_exception.raise_exception( EXCEPTION_TYPE => 'APP',
2268: EXCEPTION_CODE => NULL ,
2269: EXCEPTION_TEXT => lv_error_message

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

2280:
2281: /*
2282: || Item is not vatable . Stop processing and throw an error
2283: */
2284: /* raise_application_error (-20130,'ITEM not vatable'); */ pv_return_code := jai_constants.expected_error ; pv_return_message := 'ITEM not vatable' ; return ;
2285: /* DO not delete this code, enable this code while doing the messageing project
2286: app_exception.raise_exception( EXCEPTION_TYPE => 'APP',
2287: EXCEPTION_CODE => NULL ,
2288: EXCEPTION_TEXT => 'Cannot attach VAT type of taxes to non vatable items.'

Line 2306: p_organization_type => jai_constants.orgn_type_io ,

2302: */
2303:
2304: v_ccid := jai_cmn_rgm_recording_pkg.get_account (
2305: p_regime_id => ln_regime_id ,
2306: p_organization_type => jai_constants.orgn_type_io ,
2307: p_organization_id => v_organization_id ,
2308: p_location_id => v_location_id ,
2309: p_tax_type => tax_type_rec.t_type ,
2310: p_account_name => jai_constants.liability_interim

Line 2310: p_account_name => jai_constants.liability_interim

2306: p_organization_type => jai_constants.orgn_type_io ,
2307: p_organization_id => v_organization_id ,
2308: p_location_id => v_location_id ,
2309: p_tax_type => tax_type_rec.t_type ,
2310: p_account_name => jai_constants.liability_interim
2311: );
2312: IF v_ccid IS NULL THEN
2313: /*
2314: || Code Combination id has been returned as null from the function jai_cmn_rgm_recording_pkg.get_account

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

2314: || Code Combination id has been returned as null from the function jai_cmn_rgm_recording_pkg.get_account
2315: || This is an error condition and the current processing has to be stopped
2316: */
2317: /* raise_application_error (-20130,'Invalid Code combination ,please check the VAT Tax - Tax Accounting Setup'); */
2318: pv_return_code := jai_constants.expected_error ; pv_return_message := 'Invalid Code combination ,please check the VAT Tax - Tax Accounting Setup' ; return ;
2319: /*
2320: app_exception.raise_exception( EXCEPTION_TYPE => 'APP',
2321: EXCEPTION_CODE => NULL ,
2322: EXCEPTION_TEXT => 'Invalid Code combination ,please check the VAT Tax - Tax Type Accounting Setup'

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

2329: */
2330:
2331:
2332: /* Added by CSahoo for the TCS enhancements Bug# 5631784 */
2333: ELSIF UPPER(nvl(ln_regime_code,'####')) = jai_constants.tcs_regime THEN -- Start of A1
2334:
2335: /*********************************************************************************************************
2336: || Get the code combination id from the Organization/Regime Registration setup
2337: || by calling the function jai_rgm_trx_recording_pkg.get_account

Line 2343: p_organization_type => jai_constants.orgn_type_io ,

2339:
2340:
2341: v_ccid := jai_cmn_rgm_recording_pkg.get_account (
2342: p_regime_id => ln_regime_id ,
2343: p_organization_type => jai_constants.orgn_type_io ,
2344: p_organization_id => v_organization_id ,
2345: p_location_id => v_location_id ,
2346: p_tax_type => tax_type_rec.t_type ,
2347: p_account_name => jai_constants.liability_interim

Line 2347: p_account_name => jai_constants.liability_interim

2343: p_organization_type => jai_constants.orgn_type_io ,
2344: p_organization_id => v_organization_id ,
2345: p_location_id => v_location_id ,
2346: p_tax_type => tax_type_rec.t_type ,
2347: p_account_name => jai_constants.liability_interim
2348: );
2349: IF v_ccid IS NULL THEN
2350: /**********************************************************************************************************
2351: || Code Combination id has been returned as null from the function jai_rgm_trx_recording_pkg.get_account

Line 2450: AND jcta.tax_type = jai_constants.tax_type_tcs_surcharge

2446: SELECT max(jattl.tax_line_no) INTO l_tcs_sur_line_num
2447: FROM JAI_AR_TRX_TAX_LINES jattl, jai_cmn_taxes_all jcta
2448: WHERE jattl.link_to_cust_trx_line_id = pr_new.customer_trx_line_id
2449: AND jattl.tax_id = jcta.tax_id
2450: AND jcta.tax_type = jai_constants.tax_type_tcs_surcharge
2451: GROUP BY jcta.tax_type;
2452: EXCEPTION
2453: WHEN NO_DATA_FOUND THEN
2454: l_tcs_sur_line_num := 0;

Line 2491: AND jcta.tax_type = jai_constants.tax_type_tcs

2487: SELECT max(jattl.tax_line_no) INTO l_tcs_line_num
2488: FROM JAI_AR_TRX_TAX_LINES jattl, jai_cmn_taxes_all jcta
2489: WHERE jattl.link_to_cust_trx_line_id = pr_new.customer_trx_line_id
2490: AND jattl.tax_id = jcta.tax_id
2491: AND jcta.tax_type = jai_constants.tax_type_tcs
2492: GROUP BY jcta.tax_type;
2493: EXCEPTION
2494: WHEN NO_DATA_FOUND THEN
2495: RETURN;

Line 2500: open gc_get_regime_id ( cp_regime_code => jai_constants.tcs_regime);

2496: END;
2497:
2498: IF (l_tcs_line_num > 0) then
2499: /** TCS type of tax(s) are present */
2500: open gc_get_regime_id ( cp_regime_code => jai_constants.tcs_regime);
2501: fetch gc_get_regime_id into ln_tcs_regime_id;
2502: close gc_get_regime_id;
2503:
2504: open bind_cur;

Line 2515: , p_party_type => jai_constants.party_type_customer

2511:
2512: jai_rgm_thhold_proc_pkg.get_threshold_slab_id
2513: ( p_regime_id => ln_tcs_regime_id
2514: , p_organization_id => ln_organization_id
2515: , p_party_type => jai_constants.party_type_customer
2516: , p_party_id => l_bill_to_customer_id
2517: , p_org_id => l_org_id
2518: , p_source_trx_date => ln_trx_date /* ssumaith - bug# 6109941*/
2519: , p_threshold_slab_id => ln_threshold_slab_id

Line 2520: , p_called_from => jai_constants.tcs_event_surcharge --Added by mmurtuza for bug#16052256

2516: , p_party_id => l_bill_to_customer_id
2517: , p_org_id => l_org_id
2518: , p_source_trx_date => ln_trx_date /* ssumaith - bug# 6109941*/
2519: , p_threshold_slab_id => ln_threshold_slab_id
2520: , p_called_from => jai_constants.tcs_event_surcharge --Added by mmurtuza for bug#16052256
2521: , p_process_flag => lv_process_flag
2522: , p_process_message => lv_process_message
2523: );
2524:

Line 2525: if lv_process_flag <> jai_constants.successful then

2521: , p_process_flag => lv_process_flag
2522: , p_process_message => lv_process_message
2523: );
2524:
2525: if lv_process_flag <> jai_constants.successful then
2526: app_exception.raise_exception
2527: (exception_type => 'APP'
2528: ,exception_code => -20275
2529: ,exception_text => lv_process_message

Line 2544: if lv_process_flag <> jai_constants.successful then

2540: , p_threshold_tax_cat_id => ln_threshold_tax_cat_id
2541: , p_process_flag => lv_process_flag
2542: , p_process_message => lv_process_message
2543: );
2544: if lv_process_flag <> jai_constants.successful then
2545: app_exception.raise_exception
2546: (exception_type => 'APP'
2547: ,exception_code => -20275
2548: ,exception_text => lv_process_message

Line 2595: Pv_return_code := jai_constants.unexpected_error;

2591: END IF;
2592: /* Added an exception block by Ramananda for bug#4570303 */
2593: EXCEPTION
2594: WHEN OTHERS THEN
2595: Pv_return_code := jai_constants.unexpected_error;
2596: Pv_return_message := 'Encountered an error in JAI_JAR_TL_TRIGGER_PKG.ARU_T1 ' || substr(sqlerrm,1,1900);
2597:
2598: END ARU_T1 ;
2599: