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

Line 117: pv_return_code := jai_constants.successful ;

113: FROM gl_sets_of_books
114: WHERE set_of_books_id = c_sob;
115: V_CURR CURR%ROWTYPE; --2002/03/11 Vijay
116: BEGIN
117: pv_return_code := jai_constants.successful ;
118: /*------------------------------------------------------------------------------------------
119: FILENAME: JA_IN_LOC_INFO_AR_HDR_TRG.sql
120:
121: CHANGE HISTORY:

Line 286: Pv_return_code := jai_constants.unexpected_error;

282: END IF;
283: /* Added an exception block by Ramananda for bug#4570303 */
284: EXCEPTION
285: WHEN OTHERS THEN
286: Pv_return_code := jai_constants.unexpected_error;
287: Pv_return_message := 'Encountered an error in JAI_AR_RCTA_TRIGGER_PKG.ARI_T1 ' || substr(sqlerrm,1,1900);
288: END ARI_T1 ;
289:
290: /*

Line 475: pv_return_code := jai_constants.successful ;

471: None
472: -----------------------------------------------------------------------------------------------------------------------------------------------------------------------*/
473:
474: BEGIN
475: pv_return_code := jai_constants.successful ;
476: Open C_VAT_INVOICE_CUR;
477: Fetch C_VAT_INVOICE_CUR into v_loc_vat_inv_no;
478: close C_VAT_INVOICE_CUR;
479:

Line 508: Pv_return_code := jai_constants.unexpected_error;

504: end if;
505: /* Added an exception block by Ramananda for bug#4570303 */
506: EXCEPTION
507: WHEN OTHERS THEN
508: Pv_return_code := jai_constants.unexpected_error;
509: Pv_return_message := 'Encountered an error in JAI_AR_RCTA_TRIGGER_PKG.ARU_T1 ' || substr(sqlerrm,1,1900);
510: END ARU_T1 ;
511:
512: /*

Line 535: pv_return_code := jai_constants.successful ;

531: And NVL(org_id,0) = NVL(pr_new.org_id,0);
532:
533: v_currency_code gl_sets_of_books.currency_code%type;
534: BEGIN
535: pv_return_code := jai_constants.successful ;
536: /*------------------------------------------------------------------------------------------
537: FILENAME:JA_IN_TRX_HDR_UPDATE_TRG.sql
538:
539: CHANGE HISTORY:

Line 620: Pv_return_code := jai_constants.unexpected_error;

616: END IF;
617: /* Added an exception block by Ramananda for bug#4570303 */
618: EXCEPTION
619: WHEN OTHERS THEN
620: Pv_return_code := jai_constants.unexpected_error;
621: Pv_return_message := 'Encountered an error in JAI_AR_RCTA_TRIGGER_PKG.ARU_T2 ' || substr(sqlerrm,1,1900);
622: END ARU_T2 ;
623:
624: /*

Line 695: regime_code = jai_constants.vat_regime AND

691: jcttl.link_to_cust_trx_line_id = jctl.customer_trx_line_id AND
692: jctl.customer_trx_id = pr_new.customer_trx_id AND
693: jcttl.tax_id = jtc.tax_id AND
694: jtc.tax_type = jrttv.tax_type AND
695: regime_code = jai_constants.vat_regime AND
696: jtc.org_id = pr_new.org_id ;
697:
698:
699: CURSOR cur_get_gl_date(cp_acct_class ra_cust_trx_line_gl_dist_all.account_class%type)

Line 751: regime_code = jai_constants.vat_regime

747: regime_id
748: FROM
749: jai_regime_tax_types_v
750: WHERE
751: regime_code = jai_constants.vat_regime
752: AND rownum = 1 ;
753: /******************************************************************************************************************
754: File name : ja_in_loc_ar_hdr_upd_trg_vat.sql
755: Change History :

Line 788: pv_return_code := jai_constants.successful ;

784:
785: -----------------------------------------------------------------------------------------------------------------------------------------------------------------------*/
786:
787: BEGIN
788: pv_return_code := jai_constants.successful ;
789:
790: /*
791: || Get the Organization and location info , vat_invoice_no, vat_invoice_date
792: */

Line 825: IF UPPER(nvl(ln_regime_code,'####')) <> UPPER(jai_constants.vat_regime) THEN

821: OPEN cur_vat_taxes_exist;
822: FETCH cur_vat_taxes_exist into ln_regime_id,ln_regime_code;
823: CLOSE cur_vat_taxes_exist;
824:
825: IF UPPER(nvl(ln_regime_code,'####')) <> UPPER(jai_constants.vat_regime) THEN
826: /*
827: || only vat type of taxes should be processed
828: */
829: return;

Line 850: ln_regime_code := jai_constants.vat_regime ;

846: FETCH c_get_regime_id INTO ln_regime_id ;
847: CLOSE c_get_regime_id ;
848:
849: IF ln_regime_id IS NOT NULL THEN
850: ln_regime_code := jai_constants.vat_regime ;
851: END IF ;
852: END IF ;
853: END IF ;
854: --bug#5645003, ends

Line 881: p_source => jai_constants.source_ar ,

877: || IF the VAT invoice Number has been successfully generated, then pass accounting entries
878: */
879: jai_cmn_rgm_vat_accnt_pkg.process_order_invoice (
880: p_regime_id => ln_regime_id ,
881: p_source => jai_constants.source_ar ,
882: p_organization_id => v_organization_id ,
883: p_location_id => v_loc_id ,
884: p_delivery_id => NULL ,
885: p_customer_trx_id => pr_new.customer_trx_id ,

Line 891: p_debug => jai_constants.no ,

887: p_vat_invoice_no => lv_vat_invoice_no ,
888: p_default_invoice_date => nvl(ld_gl_date,pr_new.trx_date) ,
889: p_batch_id => NULL ,
890: p_called_from => 'JA_IN_LOC_AR_HDR_UPD_TRG_VAT' , /* The string 'JA_IN_LOC_AR_HDR_UPD_TRG_VAT' is also being used in jai_cmn_rgm_vat_accnt_pkg.process_order_invoice*/
891: p_debug => jai_constants.no ,
892: p_process_flag => lv_process_flag ,
893: p_process_message => lv_process_message
894: );
895:

Line 896: IF lv_process_flag = jai_constants.expected_error OR

892: p_process_flag => lv_process_flag ,
893: p_process_message => lv_process_message
894: );
895:
896: IF lv_process_flag = jai_constants.expected_error OR
897: lv_process_flag = jai_constants.unexpected_error
898: THEN
899:
900: /* raise_application_error(-20130,lv_process_message); */ pv_return_code := jai_constants.expected_error ; pv_return_message := lv_process_message ; return ;

Line 897: lv_process_flag = jai_constants.unexpected_error

893: p_process_message => lv_process_message
894: );
895:
896: IF lv_process_flag = jai_constants.expected_error OR
897: lv_process_flag = jai_constants.unexpected_error
898: THEN
899:
900: /* raise_application_error(-20130,lv_process_message); */ pv_return_code := jai_constants.expected_error ; pv_return_message := lv_process_message ; return ;
901: /*

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

896: IF lv_process_flag = jai_constants.expected_error OR
897: lv_process_flag = jai_constants.unexpected_error
898: THEN
899:
900: /* raise_application_error(-20130,lv_process_message); */ pv_return_code := jai_constants.expected_error ; pv_return_message := lv_process_message ; return ;
901: /*
902: app_exception.raise_exception( EXCEPTION_TYPE => 'APP',
903: EXCEPTION_CODE => NULL ,
904: EXCEPTION_TEXT => lv_process_message

Line 921: Pv_return_code := jai_constants.unexpected_error;

917:
918: /* Added an exception block by Ramananda for bug#4570303 */
919: EXCEPTION
920: WHEN OTHERS THEN
921: Pv_return_code := jai_constants.unexpected_error;
922: Pv_return_message := 'Encountered an error in JAI_AR_RCTA_TRIGGER_PKG.ARU_T3 ' || substr(sqlerrm,1,1900);
923:
924: END ARU_T3 ;
925:

Line 1138: (jai_constants.tax_type_excise,jai_constants.tax_type_exc_additional,jai_constants.tax_type_exc_other)

1134: JAI_CMN_TAXES_ALL B,
1135: JAI_INV_ITM_SETUPS C
1136: WHERE link_to_cust_trx_line_id = p_line_id
1137: AND b.tax_type IN --('Excise','Addl. Excise','Other Excise') /* Modified by Ramananda for removal of SQL LITERALs */
1138: (jai_constants.tax_type_excise,jai_constants.tax_type_exc_additional,jai_constants.tax_type_exc_other)
1139: AND A.tax_id = b.tax_id
1140: AND c.inventory_item_id = p_inventory_item_id
1141: AND c.organization_id = p_org_id
1142: --AND c.item_class IN ('RMIN','RMEX','CGEX','CGIN','CCEX','CCIN','FGIN','FGEX') /* Modified by Ramananda for removal of SQL LITERALs */

Line 1143: AND c.item_class IN ( jai_constants.item_class_rmin, jai_constants.item_class_rmex,

1139: AND A.tax_id = b.tax_id
1140: AND c.inventory_item_id = p_inventory_item_id
1141: AND c.organization_id = p_org_id
1142: --AND c.item_class IN ('RMIN','RMEX','CGEX','CGIN','CCEX','CCIN','FGIN','FGEX') /* Modified by Ramananda for removal of SQL LITERALs */
1143: AND c.item_class IN ( jai_constants.item_class_rmin, jai_constants.item_class_rmex,
1144: jai_constants.item_class_cgex, jai_constants.item_class_cgin,
1145: jai_constants.item_class_ccex, jai_constants.item_class_ccin,
1146: jai_constants.item_class_fgin, jai_constants.item_class_fgex
1147: )

Line 1144: jai_constants.item_class_cgex, jai_constants.item_class_cgin,

1140: AND c.inventory_item_id = p_inventory_item_id
1141: AND c.organization_id = p_org_id
1142: --AND c.item_class IN ('RMIN','RMEX','CGEX','CGIN','CCEX','CCIN','FGIN','FGEX') /* Modified by Ramananda for removal of SQL LITERALs */
1143: AND c.item_class IN ( jai_constants.item_class_rmin, jai_constants.item_class_rmex,
1144: jai_constants.item_class_cgex, jai_constants.item_class_cgin,
1145: jai_constants.item_class_ccex, jai_constants.item_class_ccin,
1146: jai_constants.item_class_fgin, jai_constants.item_class_fgex
1147: )
1148: ORDER BY 1;

Line 1145: jai_constants.item_class_ccex, jai_constants.item_class_ccin,

1141: AND c.organization_id = p_org_id
1142: --AND c.item_class IN ('RMIN','RMEX','CGEX','CGIN','CCEX','CCIN','FGIN','FGEX') /* Modified by Ramananda for removal of SQL LITERALs */
1143: AND c.item_class IN ( jai_constants.item_class_rmin, jai_constants.item_class_rmex,
1144: jai_constants.item_class_cgex, jai_constants.item_class_cgin,
1145: jai_constants.item_class_ccex, jai_constants.item_class_ccin,
1146: jai_constants.item_class_fgin, jai_constants.item_class_fgex
1147: )
1148: ORDER BY 1;
1149:

Line 1146: jai_constants.item_class_fgin, jai_constants.item_class_fgex

1142: --AND c.item_class IN ('RMIN','RMEX','CGEX','CGIN','CCEX','CCIN','FGIN','FGEX') /* Modified by Ramananda for removal of SQL LITERALs */
1143: AND c.item_class IN ( jai_constants.item_class_rmin, jai_constants.item_class_rmex,
1144: jai_constants.item_class_cgex, jai_constants.item_class_cgin,
1145: jai_constants.item_class_ccex, jai_constants.item_class_ccin,
1146: jai_constants.item_class_fgin, jai_constants.item_class_fgex
1147: )
1148: ORDER BY 1;
1149:
1150: CURSOR ssi_unit_flag_cur(p_org_id IN NUMBER, p_loc_id IN NUMBER) IS

Line 1217: AND b.tax_type = jai_constants.tax_type_modvat_recovery ; --'Modvat Recovery';

1213: SELECT A.tax_rate
1214: FROM JAI_AR_TRX_TAX_LINES A, JAI_CMN_TAXES_ALL b
1215: WHERE A.tax_id = b.tax_id
1216: AND A.link_to_cust_trx_line_id = p_cust_trx_line_id
1217: AND b.tax_type = jai_constants.tax_type_modvat_recovery ; --'Modvat Recovery';
1218:
1219: --added by GD
1220: v_start_number NUMBER;
1221: v_end_number NUMBER;

Line 1255: AND jmtl.item_class IN ( jai_constants.item_class_rmin, jai_constants.item_class_rmex,

1251: AND jrtl.link_to_cust_trx_line_id = jtl.customer_trx_line_id
1252: AND jtl.inventory_item_id = jmtl.inventory_item_id
1253: AND jtrx.organization_id = jmtl.organization_id
1254: --AND jmtl.item_class in ('RMIN','RMEX','CGEX','CGIN','FGIN','FGEX','CCIN','CCEX') /* Modified by Ramananda for removal of SQL LITERALs */
1255: AND jmtl.item_class IN ( jai_constants.item_class_rmin, jai_constants.item_class_rmex,
1256: jai_constants.item_class_cgex, jai_constants.item_class_cgin,
1257: jai_constants.item_class_ccex, jai_constants.item_class_ccin,
1258: jai_constants.item_class_fgin, jai_constants.item_class_fgex
1259: )

Line 1256: jai_constants.item_class_cgex, jai_constants.item_class_cgin,

1252: AND jtl.inventory_item_id = jmtl.inventory_item_id
1253: AND jtrx.organization_id = jmtl.organization_id
1254: --AND jmtl.item_class in ('RMIN','RMEX','CGEX','CGIN','FGIN','FGEX','CCIN','CCEX') /* Modified by Ramananda for removal of SQL LITERALs */
1255: AND jmtl.item_class IN ( jai_constants.item_class_rmin, jai_constants.item_class_rmex,
1256: jai_constants.item_class_cgex, jai_constants.item_class_cgin,
1257: jai_constants.item_class_ccex, jai_constants.item_class_ccin,
1258: jai_constants.item_class_fgin, jai_constants.item_class_fgex
1259: )
1260: AND jtc.tax_type like '%Excise%'

Line 1257: jai_constants.item_class_ccex, jai_constants.item_class_ccin,

1253: AND jtrx.organization_id = jmtl.organization_id
1254: --AND jmtl.item_class in ('RMIN','RMEX','CGEX','CGIN','FGIN','FGEX','CCIN','CCEX') /* Modified by Ramananda for removal of SQL LITERALs */
1255: AND jmtl.item_class IN ( jai_constants.item_class_rmin, jai_constants.item_class_rmex,
1256: jai_constants.item_class_cgex, jai_constants.item_class_cgin,
1257: jai_constants.item_class_ccex, jai_constants.item_class_ccin,
1258: jai_constants.item_class_fgin, jai_constants.item_class_fgex
1259: )
1260: AND jtc.tax_type like '%Excise%'
1261: AND jtl.customer_trx_id = pr_new.customer_trx_id

Line 1258: jai_constants.item_class_fgin, jai_constants.item_class_fgex

1254: --AND jmtl.item_class in ('RMIN','RMEX','CGEX','CGIN','FGIN','FGEX','CCIN','CCEX') /* Modified by Ramananda for removal of SQL LITERALs */
1255: AND jmtl.item_class IN ( jai_constants.item_class_rmin, jai_constants.item_class_rmex,
1256: jai_constants.item_class_cgex, jai_constants.item_class_cgin,
1257: jai_constants.item_class_ccex, jai_constants.item_class_ccin,
1258: jai_constants.item_class_fgin, jai_constants.item_class_fgex
1259: )
1260: AND jtc.tax_type like '%Excise%'
1261: AND jtl.customer_trx_id = pr_new.customer_trx_id
1262: AND jtrx.customer_trx_id = pr_new.customer_trx_id;

Line 1276: AND upper(jtc.tax_type) IN (upper(jai_constants.tax_type_cvd_edu_cess), upper(jai_constants.tax_type_exc_edu_cess));

1272: (SELECT customer_trx_line_id
1273: FROM JAI_AR_TRX_LINES
1274: WHERE customer_trx_id = pr_new.customer_trx_id
1275: )
1276: AND upper(jtc.tax_type) IN (upper(jai_constants.tax_type_cvd_edu_cess), upper(jai_constants.tax_type_exc_edu_cess));
1277:
1278: -- Start of bug 4185033
1279: /*
1280: || Cursor added by aiyer for the bug 4185033

Line 1334: regime_code = jai_constants.vat_regime AND

1330: jcttl.link_to_cust_trx_line_id = jctl.customer_trx_line_id AND
1331: jctl.customer_trx_id = pr_new.customer_trx_id AND
1332: jcttl.tax_id = jtc.tax_id AND
1333: jtc.tax_type = jrttv.tax_type AND
1334: regime_code = jai_constants.vat_regime AND
1335: jtc.org_id = pr_new.org_id ;
1336:
1337: /*
1338: || Added by kunkumar for bug#5645003

Line 1366: regime_code = jai_constants.vat_regime

1362: regime_id
1363: FROM
1364: jai_regime_tax_types_v
1365: WHERE
1366: regime_code = jai_constants.vat_regime
1367: AND rownum = 1 ;
1368:
1369: ln_vat_reversal_exists NUMBER ;
1370: lv_vat_reversal VARCHAR2(100);

Line 1384: regime_code = jai_constants.vat_regime AND

1380: nvl(attribute_value ,'N') attribute_value
1381: FROM
1382: JAI_RGM_ORG_REGNS_V
1383: WHERE
1384: regime_code = jai_constants.vat_regime AND
1385: attribute_type_code = jai_constants.regn_type_others AND /*'OTHERS' AND */
1386: attribute_code = jai_constants.attr_code_same_inv_no AND /*'SAME_INVOICE_NO' AND */
1387: organization_id = cp_organization_id AND
1388: location_id = cp_location_id;

Line 1385: attribute_type_code = jai_constants.regn_type_others AND /'OTHERS' AND /

1381: FROM
1382: JAI_RGM_ORG_REGNS_V
1383: WHERE
1384: regime_code = jai_constants.vat_regime AND
1385: attribute_type_code = jai_constants.regn_type_others AND /*'OTHERS' AND */
1386: attribute_code = jai_constants.attr_code_same_inv_no AND /*'SAME_INVOICE_NO' AND */
1387: organization_id = cp_organization_id AND
1388: location_id = cp_location_id;
1389:

Line 1386: attribute_code = jai_constants.attr_code_same_inv_no AND /'SAME_INVOICE_NO' AND /

1382: JAI_RGM_ORG_REGNS_V
1383: WHERE
1384: regime_code = jai_constants.vat_regime AND
1385: attribute_type_code = jai_constants.regn_type_others AND /*'OTHERS' AND */
1386: attribute_code = jai_constants.attr_code_same_inv_no AND /*'SAME_INVOICE_NO' AND */
1387: organization_id = cp_organization_id AND
1388: location_id = cp_location_id;
1389:
1390: CURSOR cur_get_exc_inv_no

Line 1475: AND attribute_type_code = jai_constants.rgm_attr_type_code_primary

1471: attribute_value
1472: FROM JAI_RGM_ORG_REGNS_V orrg
1473: WHERE orrg.organization_id = cp_organization_id
1474: AND orrg.location_id = cp_location_id
1475: AND attribute_type_code = jai_constants.rgm_attr_type_code_primary
1476: AND attribute_code = jai_constants.attr_code_regn_no
1477: AND regime_code = cp_regime_code;
1478: --------------------------------------------------------------------------------------
1479: --Added by Bo Li for bug#10043656 End

Line 1476: AND attribute_code = jai_constants.attr_code_regn_no

1472: FROM JAI_RGM_ORG_REGNS_V orrg
1473: WHERE orrg.organization_id = cp_organization_id
1474: AND orrg.location_id = cp_location_id
1475: AND attribute_type_code = jai_constants.rgm_attr_type_code_primary
1476: AND attribute_code = jai_constants.attr_code_regn_no
1477: AND regime_code = cp_regime_code;
1478: --------------------------------------------------------------------------------------
1479: --Added by Bo Li for bug#10043656 End
1480: */

Line 1532: regime_code = jai_constants.service_regime AND

1528: jcttl.link_to_cust_trx_line_id = jctl.customer_trx_line_id AND
1529: jctl.customer_trx_id = pr_new.customer_trx_id AND
1530: jcttl.tax_id = jtc.tax_id AND
1531: jtc.tax_type = jrttv.tax_type AND
1532: regime_code = jai_constants.service_regime AND
1533: jtc.org_id = pr_new.org_id ;
1534: lv_st_inv_number jai_ar_trxs.st_inv_number%TYPE;
1535: /*Added by Qinglei for the Advanced Receipt for Service Tax enhancement Bug 13361952 End*/
1536: /*Added by Qinglei on 26-Dec-2011 for bug13531549 begin*/

Line 1559: pv_return_code := jai_constants.successful ;

1555: lv_excise_tax_flag VARCHAR2(2);
1556: /*Added by Qinglei on 26-Dec-2011 for bug13531549 end*/
1557: /* CODE ADDED TILL TO INCORPORATE MASTER ORGANIZATION */
1558: BEGIN
1559: pv_return_code := jai_constants.successful ;
1560: /*------------------------------------------------------------------------------------------
1561: FILENAME: JA_IN_LOC_AR_HDR_UPDATE_TRG.sql
1562: CHANGE HISTORY:
1563: S.No Date Author and Details

Line 1649: */ pv_return_code := jai_constants.expected_error ; pv_return_message := 'IL Tax not applied - Please wait for AR Tax and Freight Defaultation Concurrent Request to complete' ; return ;

1645: FETCH cur_chk_temp_lines_exist INTO ln_exists;
1646: IF CUR_CHK_TEMP_LINES_EXIST%FOUND THEN
1647: CLOSE cur_chk_temp_lines_exist;
1648: /* raise_application_error(-20121,'IL Tax not applied - Please wait for AR Tax and Freight Defaultation Concurrent Request to complete');
1649: */ pv_return_code := jai_constants.expected_error ; pv_return_message := 'IL Tax not applied - Please wait for AR Tax and Freight Defaultation Concurrent Request to complete' ; return ;
1650: END IF ;
1651: CLOSE cur_chk_temp_lines_exist;
1652: END IF;-- Added by Zhiwei for Open Interface ER bug#11683927.
1653: END IF;

Line 1851: TO_CHAR(v_exempt_bal)); */ pv_return_code := jai_constants.expected_error ; pv_return_message := 'Register RG23A PART II Balance -> '||

1847: v_exempt_bal := (NVL(v_exempt_bal, 0) + line_rec.quantity * line_rec.assessable_value * NVL(v_modvat_tax_rate,0))/100;
1848: IF v_exempt_bal > v_rg23a_bal THEN
1849: /* RAISE_APPLICATION_ERROR(-20120, 'Register RG23A PART II Balance -> '||
1850: TO_CHAR(v_rg23a_bal ) || ' IS less than the Modvat Amount ->' ||
1851: TO_CHAR(v_exempt_bal)); */ pv_return_code := jai_constants.expected_error ; pv_return_message := 'Register RG23A PART II Balance -> '||
1852: TO_CHAR(v_rg23a_bal ) || ' IS less than the Modvat Amount ->' ||
1853: TO_CHAR(v_exempt_bal) ; return ;
1854: END IF;
1855: END IF;

Line 1879: || ' ,which IS less than Excisable Amount -> ' || TO_CHAR(v_bond_tax_amount)); */ pv_return_code := jai_constants.expected_error ; pv_return_message := 'Bonded Register Has Balance -> ' || TO_CHAR(v_register_balance)

1875: AND -- added by sriram - bug # 3021588
1876: ( NVL(v_lou_flag,'N') = 'N') -- added by sriram - bug # 3021588
1877: THEN
1878: /* RAISE_APPLICATION_ERROR(-20120, 'Bonded Register Has Balance -> ' || TO_CHAR(v_register_balance)
1879: || ' ,which IS less than Excisable Amount -> ' || TO_CHAR(v_bond_tax_amount)); */ pv_return_code := jai_constants.expected_error ; pv_return_message := 'Bonded Register Has Balance -> ' || TO_CHAR(v_register_balance)
1880: || ' ,which IS less than Excisable Amount -> ' || TO_CHAR(v_bond_tax_amount) ; return ;
1881: END IF;
1882:
1883: IF (nvl(v_register_exp_date,sysdate) < Sysdate ) THEN

Line 1885: */ pv_return_code := jai_constants.expected_error ; pv_return_message := 'Validity Date of the Bond Register has expired' ; return ;

1881: END IF;
1882:
1883: IF (nvl(v_register_exp_date,sysdate) < Sysdate ) THEN
1884: /* RAISE_APPLICATION_ERROR(-20121, 'Validity Date of the Bond Register has expired');
1885: */ pv_return_code := jai_constants.expected_error ; pv_return_message := 'Validity Date of the Bond Register has expired' ; return ;
1886: END IF ;
1887: ELSIF v_reg_code IN ('23D_DOMESTIC_EXCISE','23D_EXPORT_EXCISE','23D_DOM_WITHOUT_EXCISE','23D_EXPORT_WITHOUT_EXCISE')
1888: THEN /*Bug#4601570 bduvarag start*/
1889: IF v_trading_flag = 'Y' AND

Line 1901: || ' , FOR line NUMBER -> ' || TO_CHAR(line_rec.line_number)); */ pv_return_code := jai_constants.expected_error ; pv_return_message := 'Matched Quantity -> ' || TO_CHAR(v_matched_qty)

1897: IF NVL(v_matched_qty,0)<> NVL(line_rec.quantity,0)
1898: THEN
1899: /* RAISE_APPLICATION_ERROR(-20120, 'Matched Quantity -> ' || TO_CHAR(v_matched_qty)
1900: || ' , IS less than Invoiced Quantity -> ' || TO_CHAR(line_rec.quantity)
1901: || ' , FOR line NUMBER -> ' || TO_CHAR(line_rec.line_number)); */ pv_return_code := jai_constants.expected_error ; pv_return_message := 'Matched Quantity -> ' || TO_CHAR(v_matched_qty)
1902: || ' , IS less than Invoiced Quantity -> ' || TO_CHAR(line_rec.quantity)
1903: || ' ,FOR line NUMBER -> ' || TO_CHAR(line_rec.line_number) ; return ;
1904: EXIT;
1905: END IF;

Line 1918: || ' ,which IS less than Excisable Amount -> ' || TO_CHAR(v_rg23d_tax_amount)); */ pv_return_code := jai_constants.expected_error ; pv_return_message := 'RG23D Bonded Register Has Balance -> ' || TO_CHAR(v_rg23d_register_balance)

1914: IF NVL(v_rg23d_register_balance,0) < NVL(v_rg23d_tax_amount,0)
1915: and (NVL(v_lou_flag,'N') = 'N') -- added by sriram bug # 3021588
1916: THEN
1917: /* RAISE_APPLICATION_ERROR(-20120, 'RG23D Bonded Register Has Balance -> ' || TO_CHAR(v_rg23d_register_balance)
1918: || ' ,which IS less than Excisable Amount -> ' || TO_CHAR(v_rg23d_tax_amount)); */ pv_return_code := jai_constants.expected_error ; pv_return_message := 'RG23D Bonded Register Has Balance -> ' || TO_CHAR(v_rg23d_register_balance)
1919: || ' ,which IS less than Excisable Amount -> ' || TO_CHAR(v_rg23d_tax_amount) ; return ;
1920: END IF;
1921:
1922: -- added by sriram - bug # 3021588

Line 1925: */ pv_return_code := jai_constants.expected_error ; pv_return_message := 'Validity Date of the Bond Register has expired' ; return ;

1921:
1922: -- added by sriram - bug # 3021588
1923: IF (v_register_exp_date > Sysdate ) THEN
1924: /* RAISE_APPLICATION_ERROR(-20121, 'Validity Date of the Bond Register has expired');
1925: */ pv_return_code := jai_constants.expected_error ; pv_return_message := 'Validity Date of the Bond Register has expired' ; return ;
1926: -- ends here additions by sriram - bug # 3021588
1927: END IF;
1928: END IF;
1929: END IF;/*Bug#4601570 bduvarag*/

Line 1977: */ pv_return_code := jai_constants.expected_error ; pv_return_message := 'Error During Excise Invoice Generation ! ' || v_errbuf ; return ;

1973:
1974: IF v_errbuf is not null THEN
1975: -- to raise an error when the excise invoice returns a value.
1976: /* raise_application_error(-20107,'Error During Excise Invoice Generation ! ' || v_errbuf);
1977: */ pv_return_code := jai_constants.expected_error ; pv_return_message := 'Error During Excise Invoice Generation ! ' || v_errbuf ; return ;
1978: END IF;
1979:
1980: IF NVL(v_item_class,'~') not in ('OTIN') THEN
1981:

Line 2016: if lv_process_flag <> jai_constants.successful then

2012: p_process_flag => lv_process_flag ,
2013: p_process_message => lv_process_message
2014: );
2015:
2016: if lv_process_flag <> jai_constants.successful then
2017: lv_rg23a_cess_avlbl := 'FALSE';
2018: else
2019: lv_rg23a_cess_avlbl := 'TRUE';
2020: end if;

Line 2033: if lv_process_flag <> jai_constants.successful then

2029: p_process_flag => lv_process_flag ,
2030: p_process_message => lv_process_message
2031: );
2032:
2033: if lv_process_flag <> jai_constants.successful then
2034: lv_rg23c_cess_avlbl := 'FALSE';
2035: else
2036: lv_rg23c_cess_avlbl := 'TRUE';
2037: end if;

Line 2050: if lv_process_flag <> jai_constants.successful then

2046: p_process_flag => lv_process_flag ,
2047: p_process_message => lv_process_message
2048: );
2049:
2050: if lv_process_flag <> jai_constants.successful then
2051: lv_pla_cess_avlbl := 'FALSE';
2052: else
2053: lv_pla_cess_avlbl := 'TRUE';
2054: end if;

Line 2179: */ pv_return_code := jai_constants.expected_error ; pv_return_message := 'None of the registers have enough balance for the excise duty -> ' || v_tax_amount || ' Or Cess amount => ' || ln_Cess_amount ; return ;

2175: END IF; -- pref 1 if condition's end if
2176:
2177: IF v_reg_type is null THEN
2178: /* raise_application_error(-20102,'None of the registers have enough balance for the excise duty -> ' || v_tax_amount || ' Or Cess amount => ' || ln_Cess_amount);
2179: */ pv_return_code := jai_constants.expected_error ; pv_return_message := 'None of the registers have enough balance for the excise duty -> ' || v_tax_amount || ' Or Cess amount => ' || ln_Cess_amount ; return ;
2180: END IF;
2181: IF v_reg_type = 'PLA' and NVL(v_ssi_unit_flag,'N') <> 'Y' THEN
2182: IF v_tax_amount > reg_balance.pla_balance AND lv_pla_cess_avlbl = 'TRUE' THEN
2183: /* raise_application_error(-20102,'PLA Balance -> ' || reg_balance.pla_balance ||

Line 2184: ' is not enough for the excise duty -> ' || v_tax_amount ); */ pv_return_code := jai_constants.expected_error ; pv_return_message := 'PLA Balance -> ' || reg_balance.pla_balance ||

2180: END IF;
2181: IF v_reg_type = 'PLA' and NVL(v_ssi_unit_flag,'N') <> 'Y' THEN
2182: IF v_tax_amount > reg_balance.pla_balance AND lv_pla_cess_avlbl = 'TRUE' THEN
2183: /* raise_application_error(-20102,'PLA Balance -> ' || reg_balance.pla_balance ||
2184: ' is not enough for the excise duty -> ' || v_tax_amount ); */ pv_return_code := jai_constants.expected_error ; pv_return_message := 'PLA Balance -> ' || reg_balance.pla_balance ||
2185: ' is not enough for the excise duty -> ' || v_tax_amount ; return ;
2186: END IF;
2187: ELSIF v_reg_type = 'RG23A' THEN
2188: IF v_tax_amount > reg_balance.rg23a_balance AND lv_rg23a_cess_avlbl = 'TRUE' THEN

Line 2190: ' is not enough for the excise duty -> ' || v_tax_amount ); */ pv_return_code := jai_constants.expected_error ; pv_return_message := 'RG23A Balance -> ' || reg_balance.rg23a_balance ||

2186: END IF;
2187: ELSIF v_reg_type = 'RG23A' THEN
2188: IF v_tax_amount > reg_balance.rg23a_balance AND lv_rg23a_cess_avlbl = 'TRUE' THEN
2189: /* raise_application_error(-20102,'RG23A Balance -> ' || reg_balance.rg23a_balance ||
2190: ' is not enough for the excise duty -> ' || v_tax_amount ); */ pv_return_code := jai_constants.expected_error ; pv_return_message := 'RG23A Balance -> ' || reg_balance.rg23a_balance ||
2191: ' is not enough for the excise duty -> ' || v_tax_amount ; return ;
2192: END IF;
2193: ELSIF v_reg_type = 'RG23C' THEN
2194: IF v_tax_amount > reg_balance.rg23c_balance AND lv_rg23c_cess_avlbl = 'TRUE' THEN

Line 2196: ' is not enough for the excise duty -> ' || v_tax_amount ); */ pv_return_code := jai_constants.expected_error ; pv_return_message := 'RG23C Balance -> ' || reg_balance.rg23c_balance ||

2192: END IF;
2193: ELSIF v_reg_type = 'RG23C' THEN
2194: IF v_tax_amount > reg_balance.rg23c_balance AND lv_rg23c_cess_avlbl = 'TRUE' THEN
2195: /* raise_application_error(-20102,'RG23C Balance -> ' || reg_balance.rg23c_balance ||
2196: ' is not enough for the excise duty -> ' || v_tax_amount ); */ pv_return_code := jai_constants.expected_error ; pv_return_message := 'RG23C Balance -> ' || reg_balance.rg23c_balance ||
2197: ' is not enough for the excise duty -> ' || v_tax_amount ; return ;
2198: END IF;
2199: END IF;
2200: END LOOP;

Line 2241: */ pv_return_code := jai_constants.expected_error ; pv_return_message := SQLERRM ; return ;

2237:
2238: Exception
2239: When Others Then
2240: /* RAISE_APPLICATION_ERROR(-10101,SQLERRM);
2241: */ pv_return_code := jai_constants.expected_error ; pv_return_message := SQLERRM ; return ;
2242: End ;
2243: END IF;--Added by Zhiwei for Open Interface ER bug#11683927.
2244: /*
2245: Ends here

Line 2311: ' is not enough for the excise duty -> ' || v_tax_amount ); */ pv_return_code := jai_constants.expected_error ; pv_return_message := 'RG23A Balance -> ' || reg_balance.rg23a_balance ||

2307: --3661746
2308: IF v_reg_type = 'RG23A' THEN
2309: IF v_tax_amount > reg_balance.rg23a_balance AND lv_rg23a_cess_avlbl = 'TRUE' THEN
2310: /* raise_application_error(-20102,'RG23A Balance -> ' || reg_balance.rg23a_balance ||
2311: ' is not enough for the excise duty -> ' || v_tax_amount ); */ pv_return_code := jai_constants.expected_error ; pv_return_message := 'RG23A Balance -> ' || reg_balance.rg23a_balance ||
2312: ' is not enough for the excise duty -> ' || v_tax_amount ; return ;
2313: END IF;
2314: ELSIF v_reg_type = 'RG23C' THEN
2315: IF v_tax_amount > reg_balance.rg23c_balance AND lv_rg23c_cess_avlbl = 'TRUE' THEN

Line 2317: ' is not enough for the excise duty -> ' || v_tax_amount ); */ pv_return_code := jai_constants.expected_error ; pv_return_message := 'RG23C Balance -> ' || reg_balance.rg23c_balance ||

2313: END IF;
2314: ELSIF v_reg_type = 'RG23C' THEN
2315: IF v_tax_amount > reg_balance.rg23c_balance AND lv_rg23c_cess_avlbl = 'TRUE' THEN
2316: /* raise_application_error(-20102,'RG23C Balance -> ' || reg_balance.rg23c_balance ||
2317: ' is not enough for the excise duty -> ' || v_tax_amount ); */ pv_return_code := jai_constants.expected_error ; pv_return_message := 'RG23C Balance -> ' || reg_balance.rg23c_balance ||
2318: ' is not enough for the excise duty -> ' || v_tax_amount ; return ;
2319: END IF;
2320: END IF;
2321: --3661746

Line 2366: */ pv_return_code := jai_constants.expected_error ; pv_return_message := SQLERRM ; return ;

2362:
2363: Exception
2364: When Others Then
2365: /* RAISE_APPLICATION_ERROR(-10101,SQLERRM);
2366: */ pv_return_code := jai_constants.expected_error ; pv_return_message := SQLERRM ; return ;
2367: END;
2368: END IF;--Added by Zhiwei for Open Interface ER bug#11683927.
2369: /*
2370: Ends here - Additions by Sriram

Line 2488: ln_regime_code := jai_constants.vat_regime ;

2484: FETCH c_get_regime_id INTO ln_regime_id ;
2485: CLOSE c_get_regime_id ;
2486:
2487: IF ln_regime_id IS NOT NULL THEN
2488: ln_regime_code := jai_constants.vat_regime ;
2489: END IF ;
2490: END IF ;
2491: END IF ;
2492: --bug#5645003, ends

Line 2494: IF UPPER(nvl(ln_regime_code,'####')) = jai_constants.vat_regime THEN

2490: END IF ;
2491: END IF ;
2492: --bug#5645003, ends
2493:
2494: IF UPPER(nvl(ln_regime_code,'####')) = jai_constants.vat_regime THEN
2495: --Add nvl by Xiao for bug#11936390 on 7-Apr-2011.
2496: IF nvl(ln_external_flag, 0) = 0 THEN --Added by Xiao for Open Interface ER bug#11683927 on 10-Feb-2011
2497: /*
2498: || Check the VAT Regime setup for vat invoice no being same as excise invoice no.

Line 2552: IF lv_process_flag = jai_constants.expected_error OR

2548: p_process_flag => lv_process_flag ,
2549: p_process_msg => lv_process_message
2550: );
2551:
2552: IF lv_process_flag = jai_constants.expected_error OR
2553: lv_process_flag = jai_constants.unexpected_error
2554: THEN
2555: CLOSE cur_vat_taxes_exist;
2556: /* raise_application_error(-20130,lv_process_message); */ pv_return_code := jai_constants.expected_error ; pv_return_message := lv_process_message ; return ;

Line 2553: lv_process_flag = jai_constants.unexpected_error

2549: p_process_msg => lv_process_message
2550: );
2551:
2552: IF lv_process_flag = jai_constants.expected_error OR
2553: lv_process_flag = jai_constants.unexpected_error
2554: THEN
2555: CLOSE cur_vat_taxes_exist;
2556: /* raise_application_error(-20130,lv_process_message); */ pv_return_code := jai_constants.expected_error ; pv_return_message := lv_process_message ; return ;
2557: /*

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

2552: IF lv_process_flag = jai_constants.expected_error OR
2553: lv_process_flag = jai_constants.unexpected_error
2554: THEN
2555: CLOSE cur_vat_taxes_exist;
2556: /* raise_application_error(-20130,lv_process_message); */ pv_return_code := jai_constants.expected_error ; pv_return_message := lv_process_message ; return ;
2557: /*
2558: app_exception.raise_exception( EXCEPTION_TYPE => 'APP',
2559: EXCEPTION_CODE => NULL ,
2560: EXCEPTION_TEXT => lv_process_message

Line 2597: p_source => jai_constants.source_ar ,

2593: || IF the VAT invoice Number has been successfully generated, then pass accounting entries
2594: */
2595: jai_cmn_rgm_vat_accnt_pkg.process_order_invoice (
2596: p_regime_id => ln_regime_id ,
2597: p_source => jai_constants.source_ar ,
2598: p_organization_id => v_org_id ,
2599: p_location_id => v_loc_id ,
2600: p_delivery_id => NULL ,
2601: p_customer_trx_id => pr_new.customer_trx_id ,

Line 2606: p_called_from => jai_constants.vat_repo_call_inv_comp ,

2602: p_transaction_type => v_trans_type ,
2603: p_vat_invoice_no => lv_vat_invoice_number ,
2604: p_default_invoice_date => nvl(ld_gl_date,pr_new.trx_date) ,
2605: p_batch_id => NULL ,
2606: p_called_from => jai_constants.vat_repo_call_inv_comp ,
2607: p_debug => jai_constants.no ,
2608: p_process_flag => lv_process_flag ,
2609: p_process_message => lv_process_message
2610: );

Line 2607: p_debug => jai_constants.no ,

2603: p_vat_invoice_no => lv_vat_invoice_number ,
2604: p_default_invoice_date => nvl(ld_gl_date,pr_new.trx_date) ,
2605: p_batch_id => NULL ,
2606: p_called_from => jai_constants.vat_repo_call_inv_comp ,
2607: p_debug => jai_constants.no ,
2608: p_process_flag => lv_process_flag ,
2609: p_process_message => lv_process_message
2610: );
2611:

Line 2612: IF lv_process_flag = jai_constants.expected_error OR

2608: p_process_flag => lv_process_flag ,
2609: p_process_message => lv_process_message
2610: );
2611:
2612: IF lv_process_flag = jai_constants.expected_error OR
2613: lv_process_flag = jai_constants.unexpected_error
2614: THEN
2615: CLOSE cur_vat_taxes_exist ;
2616: /* raise_application_error(-20130,lv_process_message); */ pv_return_code := jai_constants.expected_error ; pv_return_message := lv_process_message ; return ;

Line 2613: lv_process_flag = jai_constants.unexpected_error

2609: p_process_message => lv_process_message
2610: );
2611:
2612: IF lv_process_flag = jai_constants.expected_error OR
2613: lv_process_flag = jai_constants.unexpected_error
2614: THEN
2615: CLOSE cur_vat_taxes_exist ;
2616: /* raise_application_error(-20130,lv_process_message); */ pv_return_code := jai_constants.expected_error ; pv_return_message := lv_process_message ; return ;
2617: /*

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

2612: IF lv_process_flag = jai_constants.expected_error OR
2613: lv_process_flag = jai_constants.unexpected_error
2614: THEN
2615: CLOSE cur_vat_taxes_exist ;
2616: /* raise_application_error(-20130,lv_process_message); */ pv_return_code := jai_constants.expected_error ; pv_return_message := lv_process_message ; return ;
2617: /*
2618: app_exception.raise_exception( EXCEPTION_TYPE => 'APP',
2619: EXCEPTION_CODE => NULL ,
2620: EXCEPTION_TEXT => lv_process_message

Line 2658: IF UPPER(nvl(ln_regime_code,'####')) = jai_constants.service_regime THEN

2654: FETCH c_st_invoice_cur INTO lv_st_inv_number;
2655: CLOSE c_st_invoice_cur;
2656: /*Added by Qignlei on 31-dec-2011 for bug#13537078 end*/
2657:
2658: IF UPPER(nvl(ln_regime_code,'####')) = jai_constants.service_regime THEN
2659:
2660: IF nvl(ln_external_flag,0) = 0 AND lv_st_inv_number IS NULL THEN
2661:
2662: lv_doc_type_class := 'I';

Line 2676: IF lv_process_flag = jai_constants.expected_error OR

2672: p_process_flag => lv_process_flag ,
2673: p_process_msg => lv_process_message
2674: );
2675:
2676: IF lv_process_flag = jai_constants.expected_error OR
2677: lv_process_flag = jai_constants.unexpected_error
2678: THEN
2679: pv_return_code := jai_constants.expected_error ;
2680: pv_return_message := lv_process_message ;

Line 2677: lv_process_flag = jai_constants.unexpected_error

2673: p_process_msg => lv_process_message
2674: );
2675:
2676: IF lv_process_flag = jai_constants.expected_error OR
2677: lv_process_flag = jai_constants.unexpected_error
2678: THEN
2679: pv_return_code := jai_constants.expected_error ;
2680: pv_return_message := lv_process_message ;
2681: RETURN ;

Line 2679: pv_return_code := jai_constants.expected_error ;

2675:
2676: IF lv_process_flag = jai_constants.expected_error OR
2677: lv_process_flag = jai_constants.unexpected_error
2678: THEN
2679: pv_return_code := jai_constants.expected_error ;
2680: pv_return_message := lv_process_message ;
2681: RETURN ;
2682:
2683: END IF;

Line 2716: Pv_return_code := jai_constants.unexpected_error;

2712: */
2713: /* Added an exception block by Ramananda for bug#4570303 */
2714: EXCEPTION
2715: WHEN OTHERS THEN
2716: Pv_return_code := jai_constants.unexpected_error;
2717: Pv_return_message := 'Encountered an error in JAI_AR_RCTA_TRIGGER_PKG.ARU_T4 ' || substr(sqlerrm,1,1900);
2718: END ARU_T4 ;
2719:
2720: /*

Line 2968: regime_code = jai_constants.vat_regime

2964: regime_id
2965: FROM
2966: jai_regime_tax_types_v
2967: WHERE
2968: regime_code = jai_constants.vat_regime
2969: AND rownum = 1 ;
2970:
2971:
2972:

Line 2986: pv_return_code := jai_constants.successful ;

2982:
2983: v_TRX_TAX_COUNT Number;
2984: v_trx_gl_dist_COUNT Number;
2985: BEGIN
2986: pv_return_code := jai_constants.successful ;
2987: /*------------------------------------------------------------------------------------------
2988: FILENAME: JA_IN_APPS_AR_LINES_INSERT_TRG.sql
2989: CHANGE HISTORY:
2990: 1. 10-Aug-2005 Aiyer bug 4545146 version 120.1

Line 3037: */ pv_return_code := jai_constants.expected_error ; pv_return_message := 'Taxes are not consistent in the RA_CUSTOMER_TRX_LINES_ALL AND RA_CUST_TRX_LINE_GL_DIST_ALL Tables' ; return ;

3033:
3034:
3035: IF v_TRX_TAX_COUNT <> v_trx_gl_dist_COUNT THEN
3036: /* RAISE_APPLICATION_ERROR(-20102,'Taxes are not consistent in the RA_CUSTOMER_TRX_LINES_ALL AND RA_CUST_TRX_LINE_GL_DIST_ALL Tables');
3037: */ pv_return_code := jai_constants.expected_error ; pv_return_message := 'Taxes are not consistent in the RA_CUSTOMER_TRX_LINES_ALL AND RA_CUST_TRX_LINE_GL_DIST_ALL Tables' ; return ;
3038: END IF ;
3039:
3040: FOR v_trx_rec in C_GET_TRX_DETAILS
3041:

Line 3098: pv_return_code := jai_constants.successful ;

3094: FETCH register_code_cur1 INTO v_register_code;
3095: CLOSE register_code_cur1;
3096: END IF;
3097: BEGIN
3098: pv_return_code := jai_constants.successful ;
3099: FOR TAX_TYPE_REC IN TAX_TYPE_CUR(v_trx_rec.customer_trx_line_id)
3100: LOOP
3101:
3102:

Line 3130: IF UPPER(nvl(ln_regime_code,'####')) = jai_constants.service_regime THEN

3126: OPEN cur_chk_rgm (cp_tax_type => TAX_TYPE_REC.t_type);
3127: FETCH cur_chk_rgm INTO ln_regime_id, ln_regime_code ;
3128: CLOSE cur_chk_rgm ;
3129:
3130: IF UPPER(nvl(ln_regime_code,'####')) = jai_constants.service_regime THEN
3131:
3132: /*ER 11821537 - Service Tax must hit Liability instead of Interim Liability due to change in point of taxation to accural from cash*/
3133: -- OPEN c_get_st_accrual_date(ln_regime_id); --Comment by Chong.Lei for POT code port
3134: -- Added by Chong.Lei for POT code port begin

Line 3155: p_organization_type => jai_constants.service_tax_orgn_type ,

3151: -- IF pr_new.trx_date >= ld_st_accrual_date THEN --Comment by Chong.Lei for POT code port
3152: IF ld_trx_gl_date >= ld_st_accrual_date THEN --Modified by Xiao for POT changes, reg bug#12533434 --Added by Chong.Lei for POT code port
3153: v_ccid := jai_cmn_rgm_recording_pkg.get_account (
3154: p_regime_id => ln_regime_id ,
3155: p_organization_type => jai_constants.service_tax_orgn_type ,
3156: p_organization_id => v_organization_id ,
3157: p_location_id => v_location_id ,
3158: p_tax_type => TAX_TYPE_REC.t_type ,
3159: p_account_name => jai_constants.liability

Line 3159: p_account_name => jai_constants.liability

3155: p_organization_type => jai_constants.service_tax_orgn_type ,
3156: p_organization_id => v_organization_id ,
3157: p_location_id => v_location_id ,
3158: p_tax_type => TAX_TYPE_REC.t_type ,
3159: p_account_name => jai_constants.liability
3160: );
3161: ELSE
3162: v_ccid := jai_cmn_rgm_recording_pkg.get_account (
3163: p_regime_id => ln_regime_id ,

Line 3164: p_organization_type => jai_constants.service_tax_orgn_type ,

3160: );
3161: ELSE
3162: v_ccid := jai_cmn_rgm_recording_pkg.get_account (
3163: p_regime_id => ln_regime_id ,
3164: p_organization_type => jai_constants.service_tax_orgn_type ,
3165: p_organization_id => v_organization_id ,
3166: p_location_id => v_location_id ,
3167: p_tax_type => TAX_TYPE_REC.t_type ,
3168: p_account_name => jai_constants.liability_interim

Line 3168: p_account_name => jai_constants.liability_interim

3164: p_organization_type => jai_constants.service_tax_orgn_type ,
3165: p_organization_id => v_organization_id ,
3166: p_location_id => v_location_id ,
3167: p_tax_type => TAX_TYPE_REC.t_type ,
3168: p_account_name => jai_constants.liability_interim
3169: );
3170: END IF;
3171: /*ER 11821537 - End*/
3172:

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

3174: raise_application_error (-20150,'Regime Registration Incomplete. Please check the Service Tax - Tax Accounting Setup');
3175: END IF;
3176:
3177:
3178: ELSIF UPPER(nvl(ln_regime_code,'####')) = jai_constants.vat_regime THEN
3179:
3180: v_ccid := jai_cmn_rgm_recording_pkg.get_account (
3181: p_regime_id => ln_regime_id ,
3182: p_organization_type => jai_constants.orgn_type_io ,

Line 3182: p_organization_type => jai_constants.orgn_type_io ,

3178: ELSIF UPPER(nvl(ln_regime_code,'####')) = jai_constants.vat_regime THEN
3179:
3180: v_ccid := jai_cmn_rgm_recording_pkg.get_account (
3181: p_regime_id => ln_regime_id ,
3182: p_organization_type => jai_constants.orgn_type_io ,
3183: p_organization_id => v_organization_id ,
3184: p_location_id => v_location_id ,
3185: p_tax_type => TAX_TYPE_REC.t_type ,
3186: p_account_name => jai_constants.liability_interim

Line 3186: p_account_name => jai_constants.liability_interim

3182: p_organization_type => jai_constants.orgn_type_io ,
3183: p_organization_id => v_organization_id ,
3184: p_location_id => v_location_id ,
3185: p_tax_type => TAX_TYPE_REC.t_type ,
3186: p_account_name => jai_constants.liability_interim
3187: );
3188: IF v_ccid IS NULL THEN
3189: raise_application_error (-20150,'Regime Registration Incomplete. Please check the VAT Tax - Tax Accounting Setup');
3190: END IF;

Line 3193: ELSIF UPPER(nvl(ln_regime_code,'####')) = jai_constants.tcs_regime THEN

3189: raise_application_error (-20150,'Regime Registration Incomplete. Please check the VAT Tax - Tax Accounting Setup');
3190: END IF;
3191:
3192:
3193: ELSIF UPPER(nvl(ln_regime_code,'####')) = jai_constants.tcs_regime THEN
3194:
3195: v_ccid := jai_cmn_rgm_recording_pkg.get_account (
3196: p_regime_id => ln_regime_id ,
3197: p_organization_type => jai_constants.orgn_type_io ,

Line 3197: p_organization_type => jai_constants.orgn_type_io ,

3193: ELSIF UPPER(nvl(ln_regime_code,'####')) = jai_constants.tcs_regime THEN
3194:
3195: v_ccid := jai_cmn_rgm_recording_pkg.get_account (
3196: p_regime_id => ln_regime_id ,
3197: p_organization_type => jai_constants.orgn_type_io ,
3198: p_organization_id => v_organization_id ,
3199: p_location_id => v_location_id ,
3200: p_tax_type => TAX_TYPE_REC.t_type ,
3201: p_account_name => jai_constants.liability_interim

Line 3201: p_account_name => jai_constants.liability_interim

3197: p_organization_type => jai_constants.orgn_type_io ,
3198: p_organization_id => v_organization_id ,
3199: p_location_id => v_location_id ,
3200: p_tax_type => TAX_TYPE_REC.t_type ,
3201: p_account_name => jai_constants.liability_interim
3202: );
3203: IF v_ccid IS NULL THEN
3204: raise_application_error (-20150,'Regime Registration Incomplete. Please check the TCS Tax - Tax Accounting Setup');
3205: END IF;

Line 3277: */ pv_return_code := jai_constants.expected_error ; pv_return_message := 'error in processing the invoice ..' || v_trx_num || v_err_mesg ; return ;

3273: WHEN OTHERS THEN
3274: v_err_mesg := SUBSTR(SQLERRM,1,240);
3275:
3276: /* RAISE_APPLICATION_ERROR(-20004,'error in processing the invoice ..' || v_trx_num || v_err_mesg);
3277: */ pv_return_code := jai_constants.expected_error ; pv_return_message := 'error in processing the invoice ..' || v_trx_num || v_err_mesg ; return ;
3278: END ;
3279:
3280: END LOOP;
3281: EXCEPTION

Line 3288: Pv_return_code := jai_constants.unexpected_error;

3284:
3285: --RAISE_APPLICATION_ERROR(-20003,'exception occured during processing invoice ..' || v_trx_num || v_err_mesg);
3286:
3287: /* Added an exception block by Ramananda for bug#4570303 */
3288: Pv_return_code := jai_constants.unexpected_error;
3289: Pv_return_message := 'Encountered an error in JAI_AR_RCTA_TRIGGER_PKG.ARU_T4. ' ||
3290: 'Exception occured during processing invoice ..' || v_trx_num || v_err_mesg ;
3291:
3292: END ARU_T5 ;

Line 3430: pv_return_code := jai_constants.successful ;

3426:
3427: --END 5631784
3428:
3429: BEGIN
3430: pv_return_code := jai_constants.successful ;
3431: /*------------------------------------------------------------------------------------------
3432: FILENAME: JA_IN_AR_HDR_UPDATE_TRG.sql
3433:
3434: CHANGE HISTORY:

Line 3692: ( CP_REGIME_CODE => JAI_CONSTANTS.TCS_REGIME

3688: /** sacseth, bug# 5631784 - TCS enhancement */
3689: /** Check if TCS type of taxes exists for v_tax_category_id */
3690:
3691: OPEN GC_CHK_RGM_TAX_EXISTS
3692: ( CP_REGIME_CODE => JAI_CONSTANTS.TCS_REGIME
3693: , CP_RGM_TAX_TYPE => JAI_CONSTANTS.TAX_TYPE_TCS
3694: , CP_TAX_CATEGORY_ID => V_TAX_CATEGORY_ID
3695: );
3696: FETCH GC_CHK_RGM_TAX_EXISTS INTO LN_TCS_EXISTS;

Line 3693: , CP_RGM_TAX_TYPE => JAI_CONSTANTS.TAX_TYPE_TCS

3689: /** Check if TCS type of taxes exists for v_tax_category_id */
3690:
3691: OPEN GC_CHK_RGM_TAX_EXISTS
3692: ( CP_REGIME_CODE => JAI_CONSTANTS.TCS_REGIME
3693: , CP_RGM_TAX_TYPE => JAI_CONSTANTS.TAX_TYPE_TCS
3694: , CP_TAX_CATEGORY_ID => V_TAX_CATEGORY_ID
3695: );
3696: FETCH GC_CHK_RGM_TAX_EXISTS INTO LN_TCS_EXISTS;
3697: CLOSE GC_CHK_RGM_TAX_EXISTS;

Line 3701: OPEN GC_GET_REGIME_ID ( CP_REGIME_CODE => JAI_CONSTANTS.TCS_REGIME);

3697: CLOSE GC_CHK_RGM_TAX_EXISTS;
3698:
3699: IF LN_TCS_EXISTS IS NOT NULL THEN
3700: /** TCS type of tax(s) are present */
3701: OPEN GC_GET_REGIME_ID ( CP_REGIME_CODE => JAI_CONSTANTS.TCS_REGIME);
3702: FETCH GC_GET_REGIME_ID INTO LN_TCS_REGIME_ID;
3703: CLOSE GC_GET_REGIME_ID;
3704:
3705: /** Check current threshold slab. The following procedure returns null threshold_slab_id if threshold is not yet reached */

Line 3709: , p_party_type => jai_constants.party_type_customer

3705: /** Check current threshold slab. The following procedure returns null threshold_slab_id if threshold is not yet reached */
3706: jai_rgm_thhold_proc_pkg.get_threshold_slab_id
3707: ( p_regime_id => ln_tcs_regime_id
3708: , p_organization_id => v_organization_id
3709: , p_party_type => jai_constants.party_type_customer
3710: , p_party_id => v_customer_id
3711: , p_org_id => v_org_id
3712: , p_source_trx_date => v_trx_date
3713: , p_threshold_slab_id => ln_threshold_slab_id

Line 3717: if lv_process_flag <> jai_constants.successful then

3713: , p_threshold_slab_id => ln_threshold_slab_id
3714: , p_process_flag => lv_process_flag
3715: , p_process_message => lv_process_message
3716: );
3717: if lv_process_flag <> jai_constants.successful then
3718: app_exception.raise_exception
3719: (exception_type => 'APP'
3720: ,exception_code => -20275
3721: ,exception_text => lv_process_message

Line 3737: if lv_process_flag <> jai_constants.successful then

3733: , p_threshold_tax_cat_id => ln_threshold_tax_cat_id
3734: , p_process_flag => lv_process_flag
3735: , p_process_message => lv_process_message
3736: );
3737: if lv_process_flag <> jai_constants.successful then
3738: app_exception.raise_exception
3739: (exception_type => 'APP'
3740: ,exception_code => -20275
3741: ,exception_text => lv_process_message

Line 3754: , p_thhold_cat_base_tax_typ => jai_constants.tax_type_tcs

3750: v_last_update_date , v_last_updated_by , v_last_update_login
3751: , null --Add a default value by Jia for Bug#6859632
3752: , ln_vat_assessable_value
3753: -- Bug 6109941, Added by brathod for fwd porting bug 4742259
3754: , p_thhold_cat_base_tax_typ => jai_constants.tax_type_tcs
3755: , p_threshold_tax_cat_id => ln_threshold_tax_cat_id
3756: , p_source_trx_type => null
3757: , p_source_table_name => null
3758: , p_action => jai_constants.default_taxes

Line 3758: , p_action => jai_constants.default_taxes

3754: , p_thhold_cat_base_tax_typ => jai_constants.tax_type_tcs
3755: , p_threshold_tax_cat_id => ln_threshold_tax_cat_id
3756: , p_source_trx_type => null
3757: , p_source_table_name => null
3758: , p_action => jai_constants.default_taxes
3759: -- , pn_gst_assessable_value => ln_gst_assessable_value -- Added by Jia for GST Bug#10043656 on 2010/09/10
3760:
3761: -- End 6109941
3762: );

Line 3784: Pv_return_code := jai_constants.unexpected_error;

3780: END LOOP;
3781: /* Added an exception block by Ramananda for bug#4570303 */
3782: EXCEPTION
3783: WHEN OTHERS THEN
3784: Pv_return_code := jai_constants.unexpected_error;
3785: Pv_return_message := 'Encountered an error in JAI_AR_RCTA_TRIGGER_PKG.ARI_T7 ' || substr(sqlerrm,1,1900);
3786:
3787: END ARU_T6 ;
3788: /*

Line 3846: IF NVL(PR_NEW.COMPLETE_FLAG,JAI_CONSTANTS.NO) = JAI_CONSTANTS.YES THEN

3842:
3843: BEGIN
3844:
3845: V_HEADER_ID := PR_NEW.CUSTOMER_TRX_ID;
3846: IF NVL(PR_NEW.COMPLETE_FLAG,JAI_CONSTANTS.NO) = JAI_CONSTANTS.YES THEN
3847: /** Invoice is getting COMPLETED */
3848: LV_DOCUMENT_TYPE := JAI_CONSTANTS.TRX_TYPE_INV_COMP;
3849: /*********
3850: || When the invoice is getting completed for the very first time (once_complete_flag is still null or 'N') then pass the

Line 3848: LV_DOCUMENT_TYPE := JAI_CONSTANTS.TRX_TYPE_INV_COMP;

3844:
3845: V_HEADER_ID := PR_NEW.CUSTOMER_TRX_ID;
3846: IF NVL(PR_NEW.COMPLETE_FLAG,JAI_CONSTANTS.NO) = JAI_CONSTANTS.YES THEN
3847: /** Invoice is getting COMPLETED */
3848: LV_DOCUMENT_TYPE := JAI_CONSTANTS.TRX_TYPE_INV_COMP;
3849: /*********
3850: || When the invoice is getting completed for the very first time (once_complete_flag is still null or 'N') then pass the
3851: || final TCS accounting for the TCS type of taxes belonging to the manual invoice only
3852: || This is not applicable for the imported invoices.

Line 3860: lv_once_completed_flag = jai_constants.yes

3856: FETCH ONCE_COMPLETE_FLAG_CUR INTO LV_ONCE_COMPLETED_FLAG;
3857: CLOSE ONCE_COMPLETE_FLAG_CUR;
3858:
3859: IF Pr_new.created_from <> 'RAXTRX' AND
3860: lv_once_completed_flag = jai_constants.yes
3861: /*Bug 8463839 - Accounting must be done to set off Interim Liability
3862: Account when Transaction is completed*/
3863: THEN
3864: -- jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'Calling -> jai_ar_tcs_rep_pkg.ar_accounting ');

Line 3873: -- IF PV_ERR_FLG <> JAI_CONSTANTS.SUCCESSFUL THEN

3869: -- JAI_CMN_DEBUG_CONTEXTS_PKG.PRINT ( PN_REG_ID => LN_REG_ID ,
3870: -- PV_LOG_MSG => 'RETURNED FROM JAI_AR_TCS_REP_PKG.AR_ACCOUNTING ' || CHR(10)
3871: -- ||'P_PROCESS_FLAG=' ||PV_ERR_FLG
3872: -- );
3873: -- IF PV_ERR_FLG <> JAI_CONSTANTS.SUCCESSFUL THEN
3874: -- jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
3875: -- pv_log_msg => 'Error during processing of jai_ar_tcs_rep_pkg.ar_accounting '||chr(10)
3876: -- ||'p_process_flag=' ||pv_err_flg||chr(10)
3877: -- ||'p_process_message='||pv_err_msg

Line 3889: IF Pr_new.created_from = 'RAXTRX' AND lv_once_completed_flag = jai_constants.yes

3885: --Added by Zhiwei for Open Interface ER bug#11683927 on 10-Feb-2011, begin
3886: ------------------------------------------------------------------------------------
3887: --Process TCS Accounting for OFI Open Interface.
3888:
3889: IF Pr_new.created_from = 'RAXTRX' AND lv_once_completed_flag = jai_constants.yes
3890: THEN
3891: OPEN get_open_source_cur;
3892: FETCH get_open_source_cur INTO ln_open_source;
3893: CLOSE get_open_source_cur;

Line 3916: ELSIF NVL(PR_NEW.COMPLETE_FLAG,JAI_CONSTANTS.NO) = JAI_CONSTANTS.NO THEN

3912:
3913: -----------------------------------------------------------------------------------
3914: -- Added by Zhiwei for Open Interface ER bug#11683927 on 10-Feb-2011, end
3915:
3916: ELSIF NVL(PR_NEW.COMPLETE_FLAG,JAI_CONSTANTS.NO) = JAI_CONSTANTS.NO THEN
3917: /** INVOICE IS GETTING INCOMPLETED */
3918: LV_DOCUMENT_TYPE := JAI_CONSTANTS.TRX_TYPE_INV_INCOMP;
3919: END IF;
3920:

Line 3918: LV_DOCUMENT_TYPE := JAI_CONSTANTS.TRX_TYPE_INV_INCOMP;

3914: -- Added by Zhiwei for Open Interface ER bug#11683927 on 10-Feb-2011, end
3915:
3916: ELSIF NVL(PR_NEW.COMPLETE_FLAG,JAI_CONSTANTS.NO) = JAI_CONSTANTS.NO THEN
3917: /** INVOICE IS GETTING INCOMPLETED */
3918: LV_DOCUMENT_TYPE := JAI_CONSTANTS.TRX_TYPE_INV_INCOMP;
3919: END IF;
3920:
3921: --Added by zhiwei for Open Interface ER bug#11683927 begin
3922: ----------------------------------------------------------

Line 3936: , P_EVENT => JAI_CONSTANTS.TRX_EVENT_COMPLETION

3932:
3933: -- jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'Calling -> JAI_AR_TCS_REP_PKG.PROCESS_TRANSACTIONS');
3934: JAI_AR_TCS_REP_PKG.PROCESS_TRANSACTIONS
3935: ( P_RACT => PR_NEW
3936: , P_EVENT => JAI_CONSTANTS.TRX_EVENT_COMPLETION
3937: , P_PROCESS_FLAG => PV_RETURN_CODE
3938: , P_PROCESS_MESSAGE => PV_RETURN_MESSAGE
3939: );
3940: END IF;--Added by zhiwei for Open Interface ER bug#11683927

Line 3946: IF PV_RETURN_CODE <> JAI_CONSTANTS.SUCCESSFUL THEN

3942: -- , 'Process Result: ' || chr(10)
3943: -- ||'p_process_flag=' ||PV_RETURN_CODE||chr(10)
3944: -- ||'p_process_message='||PV_RETURN_MESSAGE||chr(10)
3945: -- );
3946: IF PV_RETURN_CODE <> JAI_CONSTANTS.SUCCESSFUL THEN
3947: RETURN;
3948: END IF;
3949:
3950: END ARU_T7;

Line 4084: AND regime_code = jai_constants.vat_regime

4080: WHERE jcttl.link_to_cust_trx_line_id = jctl.customer_trx_line_id
4081: AND jctl.customer_trx_id = pr_new.customer_trx_id
4082: AND jcttl.tax_id = jtc.tax_id
4083: AND jtc.tax_type = jrttv.tax_type
4084: AND regime_code = jai_constants.vat_regime
4085: AND jtc.org_id = pr_new.org_id ;
4086:
4087:
4088: CURSOR cur_get_gl_date(cp_acct_class ra_cust_trx_line_gl_dist_all.account_class%type)

Line 4127: WHERE regime_code = jai_constants.vat_regime

4123: CURSOR c_get_regime_id
4124: IS
4125: SELECT regime_id
4126: FROM jai_regime_tax_types_v
4127: WHERE regime_code = jai_constants.vat_regime
4128: AND rownum = 1 ;
4129:
4130: --Added by Bo Li for Bug9759668 on 2010-6-2 Begin
4131: -------------------------------------------------------------

Line 4176: WHERE jrttv1.regime_code = jai_constants.vat_regime

4172: JAI_CMN_TAXES_ALL jtc ,
4173: (
4174: SELECT jrttv1.tax_type tax_type
4175: FROM jai_regime_tax_types_v jrttv1
4176: WHERE jrttv1.regime_code = jai_constants.vat_regime
4177: UNION
4178: SELECT 'VAT REVERSAL' tax_type
4179: FROM DUAL
4180: ) jrttv

Line 4216: pv_return_code := jai_constants.successful ;

4212: --Added by Bo Li for Bug#9765108 on 09-JUL-2010 Begin
4213:
4214:
4215: BEGIN
4216: pv_return_code := jai_constants.successful ;
4217:
4218: /*
4219: || Get the Otransaction type of the document
4220: || Process only CM type of transaction's

Line 4260: IF upper(nvl(ln_regime_code,'####')) <> UPPER(jai_constants.vat_regime) THEN

4256: OPEN cur_vat_taxes_exist;
4257: FETCH cur_vat_taxes_exist into ln_regime_id,ln_regime_code;
4258: CLOSE cur_vat_taxes_exist;
4259:
4260: IF upper(nvl(ln_regime_code,'####')) <> UPPER(jai_constants.vat_regime) THEN
4261: /*
4262: || only vat type of taxes should be processed
4263: */
4264: RETURN;

Line 4285: ln_regime_code := jai_constants.vat_regime ;

4281: INTO ln_regime_id ;
4282: CLOSE c_get_regime_id ;
4283:
4284: IF ln_regime_id IS NOT NULL THEN
4285: ln_regime_code := jai_constants.vat_regime ;
4286: END IF ;
4287: END IF ;
4288: END IF ;
4289:

Line 4335: FOR rec_cur_get_man_ar_inv_taxes IN cur_get_man_ar_inv_taxes(upper(jai_constants.source_ar)

4331: IF ln_rma_flag >0 OR ln_nonship_rma_flag >0
4332: THEN
4333: --Added by Bo Li for Bug#9765108 on 09-JUL-2010 Begin
4334: ---------------------------------------------------------
4335: FOR rec_cur_get_man_ar_inv_taxes IN cur_get_man_ar_inv_taxes(upper(jai_constants.source_ar)
4336: ,jai_constants.source_ttype_man_ar_inv
4337: ,jai_constants.tname_cus_trx_lines
4338: ,get_order_and_item_id_rec.customer_trx_line_id
4339: ,v_organization_id

Line 4336: ,jai_constants.source_ttype_man_ar_inv

4332: THEN
4333: --Added by Bo Li for Bug#9765108 on 09-JUL-2010 Begin
4334: ---------------------------------------------------------
4335: FOR rec_cur_get_man_ar_inv_taxes IN cur_get_man_ar_inv_taxes(upper(jai_constants.source_ar)
4336: ,jai_constants.source_ttype_man_ar_inv
4337: ,jai_constants.tname_cus_trx_lines
4338: ,get_order_and_item_id_rec.customer_trx_line_id
4339: ,v_organization_id
4340: ,v_loc_id)

Line 4337: ,jai_constants.tname_cus_trx_lines

4333: --Added by Bo Li for Bug#9765108 on 09-JUL-2010 Begin
4334: ---------------------------------------------------------
4335: FOR rec_cur_get_man_ar_inv_taxes IN cur_get_man_ar_inv_taxes(upper(jai_constants.source_ar)
4336: ,jai_constants.source_ttype_man_ar_inv
4337: ,jai_constants.tname_cus_trx_lines
4338: ,get_order_and_item_id_rec.customer_trx_line_id
4339: ,v_organization_id
4340: ,v_loc_id)
4341: LOOP

Line 4361: p_organization_type => jai_constants.orgn_type_io ,

4357: ||for the "LIABILITY ACCOUNT"
4358: *******************************/
4359: ln_liab_acct_ccid := jai_cmn_rgm_recording_pkg.get_account(
4360: p_regime_id => ln_regime_id ,
4361: p_organization_type => jai_constants.orgn_type_io ,
4362: p_organization_id => v_organization_id ,
4363: p_location_id => v_loc_id ,
4364: p_tax_type => rec_cur_get_man_ar_inv_taxes.tax_type ,
4365: p_account_name => jai_constants.liability

Line 4365: p_account_name => jai_constants.liability

4361: p_organization_type => jai_constants.orgn_type_io ,
4362: p_organization_id => v_organization_id ,
4363: p_location_id => v_loc_id ,
4364: p_tax_type => rec_cur_get_man_ar_inv_taxes.tax_type ,
4365: p_account_name => jai_constants.liability
4366: ) ;
4367:
4368: /*******************************
4369: || Get the code combination id

Line 4374: p_organization_type => jai_constants.orgn_type_io ,

4370: || for the "INTERIM LIABILITY ACCOUNT"
4371: *******************************/
4372: ln_intliab_acct_ccid := jai_cmn_rgm_recording_pkg.get_account(
4373: p_regime_id => ln_regime_id ,
4374: p_organization_type => jai_constants.orgn_type_io ,
4375: p_organization_id => v_organization_id ,
4376: p_location_id => v_loc_id ,
4377: p_tax_type => rec_cur_get_man_ar_inv_taxes.tax_type ,
4378: p_account_name => jai_constants.liability_interim

Line 4378: p_account_name => jai_constants.liability_interim

4374: p_organization_type => jai_constants.orgn_type_io ,
4375: p_organization_id => v_organization_id ,
4376: p_location_id => v_loc_id ,
4377: p_tax_type => rec_cur_get_man_ar_inv_taxes.tax_type ,
4378: p_account_name => jai_constants.liability_interim
4379: ) ;
4380:
4381:
4382: /*

Line 4388: pv_return_code := jai_constants.expected_error;

4384: */
4385: IF ln_liab_acct_ccid IS NULL OR
4386: ln_intliab_acct_ccid IS NULL
4387: THEN
4388: pv_return_code := jai_constants.expected_error;
4389: pv_return_message := 'VAT receivable accouting entries cannot be passed.
4390: Please set up the Liability account and the Interim Liability account for the corresponding VAT regime';
4391: return;
4392: END IF;

Line 4400: lc_account_name := jai_constants.recovery ;

4396: ln_charge_ac_id := ln_intliab_acct_ccid ;
4397: ln_balancing_ac_id := ln_liab_acct_ccid ;
4398: ln_debit_amount := null ;
4399: ln_credit_amount := abs(rec_cur_get_man_ar_inv_taxes.func_tax_amount) ;
4400: lc_account_name := jai_constants.recovery ;
4401:
4402:
4403:
4404:

Line 4409: pv_organization_type => jai_constants.orgn_type_io ,

4405: jai_cmn_rgm_recording_pkg.insert_vat_repository_entry (
4406: pn_repository_id => ln_repository_id ,
4407: pn_regime_id => ln_regime_id ,
4408: pv_tax_type => rec_cur_get_man_ar_inv_taxes.tax_type ,
4409: pv_organization_type => jai_constants.orgn_type_io ,
4410: pn_organization_id => v_organization_id ,
4411: pn_location_id => v_loc_id ,
4412: pv_source => jai_constants.source_ar ,
4413: pv_source_trx_type => jai_constants.source_ttype_man_ar_inv ,

Line 4412: pv_source => jai_constants.source_ar ,

4408: pv_tax_type => rec_cur_get_man_ar_inv_taxes.tax_type ,
4409: pv_organization_type => jai_constants.orgn_type_io ,
4410: pn_organization_id => v_organization_id ,
4411: pn_location_id => v_loc_id ,
4412: pv_source => jai_constants.source_ar ,
4413: pv_source_trx_type => jai_constants.source_ttype_man_ar_inv ,
4414: pv_source_table_name => jai_constants.tname_cus_trx_lines ,
4415: pn_source_id => rec_cur_get_man_ar_inv_taxes.customer_trx_line_id ,
4416: pd_transaction_date => rec_cur_get_man_ar_inv_taxes.creation_date ,

Line 4413: pv_source_trx_type => jai_constants.source_ttype_man_ar_inv ,

4409: pv_organization_type => jai_constants.orgn_type_io ,
4410: pn_organization_id => v_organization_id ,
4411: pn_location_id => v_loc_id ,
4412: pv_source => jai_constants.source_ar ,
4413: pv_source_trx_type => jai_constants.source_ttype_man_ar_inv ,
4414: pv_source_table_name => jai_constants.tname_cus_trx_lines ,
4415: pn_source_id => rec_cur_get_man_ar_inv_taxes.customer_trx_line_id ,
4416: pd_transaction_date => rec_cur_get_man_ar_inv_taxes.creation_date ,
4417: pv_account_name => lc_account_name , --Date 14/06/2007 by sacsethi for bug 6072461

Line 4414: pv_source_table_name => jai_constants.tname_cus_trx_lines ,

4410: pn_organization_id => v_organization_id ,
4411: pn_location_id => v_loc_id ,
4412: pv_source => jai_constants.source_ar ,
4413: pv_source_trx_type => jai_constants.source_ttype_man_ar_inv ,
4414: pv_source_table_name => jai_constants.tname_cus_trx_lines ,
4415: pn_source_id => rec_cur_get_man_ar_inv_taxes.customer_trx_line_id ,
4416: pd_transaction_date => rec_cur_get_man_ar_inv_taxes.creation_date ,
4417: pv_account_name => lc_account_name , --Date 14/06/2007 by sacsethi for bug 6072461
4418: pn_charge_account_id => ln_charge_ac_id ,

Line 4429: pv_called_from => jai_constants.vat_repo_call_from_om_ar ,

4425: pn_batch_id => NULL ,
4426: pn_inv_organization_id => v_organization_id ,
4427: pv_invoice_no => lv_vat_invoice_no ,
4428: pd_invoice_date => nvl(nvl(ld_gl_date,pr_new.trx_date),rec_cur_get_man_ar_inv_taxes.creation_date) ,
4429: pv_called_from => jai_constants.vat_repo_call_from_om_ar ,
4430: pv_process_flag => lv_process_flag ,
4431: pv_process_message => lv_process_message ,
4432: pv_trx_reference_context => jai_constants.contxt_manual_ar ,
4433: pv_trx_reference1 => rec_cur_get_man_ar_inv_taxes.customer_trx_id ,

Line 4432: pv_trx_reference_context => jai_constants.contxt_manual_ar ,

4428: pd_invoice_date => nvl(nvl(ld_gl_date,pr_new.trx_date),rec_cur_get_man_ar_inv_taxes.creation_date) ,
4429: pv_called_from => jai_constants.vat_repo_call_from_om_ar ,
4430: pv_process_flag => lv_process_flag ,
4431: pv_process_message => lv_process_message ,
4432: pv_trx_reference_context => jai_constants.contxt_manual_ar ,
4433: pv_trx_reference1 => rec_cur_get_man_ar_inv_taxes.customer_trx_id ,
4434: pv_trx_reference2 => rec_cur_get_man_ar_inv_taxes.link_to_cust_trx_line_id ,
4435: pv_trx_reference3 => NULL ,
4436: pv_trx_reference4 => NULL ,

Line 4442: IF lv_process_flag = jai_constants.expected_error OR

4438: );
4439:
4440:
4441:
4442: IF lv_process_flag = jai_constants.expected_error OR
4443: lv_process_flag = jai_constants.unexpected_error
4444: THEN
4445: pv_return_code := lv_process_flag ;
4446: pv_return_code := lv_process_message ;

Line 4443: lv_process_flag = jai_constants.unexpected_error

4439:
4440:
4441:
4442: IF lv_process_flag = jai_constants.expected_error OR
4443: lv_process_flag = jai_constants.unexpected_error
4444: THEN
4445: pv_return_code := lv_process_flag ;
4446: pv_return_code := lv_process_message ;
4447: return;

Line 4467: Pv_return_code := jai_constants.unexpected_error;

4463: */
4464:
4465: EXCEPTION
4466: WHEN OTHERS THEN
4467: Pv_return_code := jai_constants.unexpected_error;
4468: Pv_return_message := 'Encountered an error in JAI_AR_RCTA_TRIGGER_PKG.ARU_T8 ' || substr(sqlerrm,1,1900);
4469:
4470: END ARU_T8 ;
4471:

Line 4581: pv_return_code := jai_constants.successful ;

4577: WHERE trx_number = p_recurred_from_trx_number
4578: AND NVL(batch_source_id,0) = p_batch_source_id;
4579:
4580: BEGIN
4581: pv_return_code := jai_constants.successful ;
4582:
4583: OPEN temp_fetch;
4584: FETCH temp_fetch INTO v_trx_number, v_header_id, v_recurred_from_trx_number, v_batch_source_id,
4585: v_created_from, v_creation_date, v_created_by,

Line 4715: pv_return_code := jai_constants.successful;

4711: DELETE JAI_AR_TRXS
4712: WHERE customer_trx_id = pr_old.customer_trx_id ;
4713:
4714: pv_return_message := '';
4715: pv_return_code := jai_constants.successful;
4716:
4717: EXCEPTION
4718: when others then
4719: pv_return_message := substr (sqlerrm,1,1999);

Line 4720: pv_return_code := jai_constants.unexpected_error;

4716:
4717: EXCEPTION
4718: when others then
4719: pv_return_message := substr (sqlerrm,1,1999);
4720: pv_return_code := jai_constants.unexpected_error;
4721: END ARD_T1;
4722:
4723: END JAI_AR_RCTA_TRIGGER_PKG ;