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 1126: (jai_constants.tax_type_excise,jai_constants.tax_type_exc_additional,jai_constants.tax_type_exc_other)

1122: JAI_CMN_TAXES_ALL B,
1123: JAI_INV_ITM_SETUPS C
1124: WHERE link_to_cust_trx_line_id = p_line_id
1125: AND b.tax_type IN --('Excise','Addl. Excise','Other Excise') /* Modified by Ramananda for removal of SQL LITERALs */
1126: (jai_constants.tax_type_excise,jai_constants.tax_type_exc_additional,jai_constants.tax_type_exc_other)
1127: AND A.tax_id = b.tax_id
1128: AND c.inventory_item_id = p_inventory_item_id
1129: AND c.organization_id = p_org_id
1130: --AND c.item_class IN ('RMIN','RMEX','CGEX','CGIN','CCEX','CCIN','FGIN','FGEX') /* Modified by Ramananda for removal of SQL LITERALs */

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

1127: AND A.tax_id = b.tax_id
1128: AND c.inventory_item_id = p_inventory_item_id
1129: AND c.organization_id = p_org_id
1130: --AND c.item_class IN ('RMIN','RMEX','CGEX','CGIN','CCEX','CCIN','FGIN','FGEX') /* Modified by Ramananda for removal of SQL LITERALs */
1131: AND c.item_class IN ( jai_constants.item_class_rmin, jai_constants.item_class_rmex,
1132: jai_constants.item_class_cgex, jai_constants.item_class_cgin,
1133: jai_constants.item_class_ccex, jai_constants.item_class_ccin,
1134: jai_constants.item_class_fgin, jai_constants.item_class_fgex
1135: )

Line 1132: jai_constants.item_class_cgex, jai_constants.item_class_cgin,

1128: AND c.inventory_item_id = p_inventory_item_id
1129: AND c.organization_id = p_org_id
1130: --AND c.item_class IN ('RMIN','RMEX','CGEX','CGIN','CCEX','CCIN','FGIN','FGEX') /* Modified by Ramananda for removal of SQL LITERALs */
1131: AND c.item_class IN ( jai_constants.item_class_rmin, jai_constants.item_class_rmex,
1132: jai_constants.item_class_cgex, jai_constants.item_class_cgin,
1133: jai_constants.item_class_ccex, jai_constants.item_class_ccin,
1134: jai_constants.item_class_fgin, jai_constants.item_class_fgex
1135: )
1136: ORDER BY 1;

Line 1133: jai_constants.item_class_ccex, jai_constants.item_class_ccin,

1129: AND c.organization_id = p_org_id
1130: --AND c.item_class IN ('RMIN','RMEX','CGEX','CGIN','CCEX','CCIN','FGIN','FGEX') /* Modified by Ramananda for removal of SQL LITERALs */
1131: AND c.item_class IN ( jai_constants.item_class_rmin, jai_constants.item_class_rmex,
1132: jai_constants.item_class_cgex, jai_constants.item_class_cgin,
1133: jai_constants.item_class_ccex, jai_constants.item_class_ccin,
1134: jai_constants.item_class_fgin, jai_constants.item_class_fgex
1135: )
1136: ORDER BY 1;
1137:

Line 1134: jai_constants.item_class_fgin, jai_constants.item_class_fgex

1130: --AND c.item_class IN ('RMIN','RMEX','CGEX','CGIN','CCEX','CCIN','FGIN','FGEX') /* Modified by Ramananda for removal of SQL LITERALs */
1131: AND c.item_class IN ( jai_constants.item_class_rmin, jai_constants.item_class_rmex,
1132: jai_constants.item_class_cgex, jai_constants.item_class_cgin,
1133: jai_constants.item_class_ccex, jai_constants.item_class_ccin,
1134: jai_constants.item_class_fgin, jai_constants.item_class_fgex
1135: )
1136: ORDER BY 1;
1137:
1138: CURSOR ssi_unit_flag_cur(p_org_id IN NUMBER, p_loc_id IN NUMBER) IS

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

1201: SELECT A.tax_rate
1202: FROM JAI_AR_TRX_TAX_LINES A, JAI_CMN_TAXES_ALL b
1203: WHERE A.tax_id = b.tax_id
1204: AND A.link_to_cust_trx_line_id = p_cust_trx_line_id
1205: AND b.tax_type = jai_constants.tax_type_modvat_recovery ; --'Modvat Recovery';
1206:
1207: --added by GD
1208: v_start_number NUMBER;
1209: v_end_number NUMBER;

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

1239: AND jrtl.link_to_cust_trx_line_id = jtl.customer_trx_line_id
1240: AND jtl.inventory_item_id = jmtl.inventory_item_id
1241: AND jtrx.organization_id = jmtl.organization_id
1242: --AND jmtl.item_class in ('RMIN','RMEX','CGEX','CGIN','FGIN','FGEX','CCIN','CCEX') /* Modified by Ramananda for removal of SQL LITERALs */
1243: AND jmtl.item_class IN ( jai_constants.item_class_rmin, jai_constants.item_class_rmex,
1244: jai_constants.item_class_cgex, jai_constants.item_class_cgin,
1245: jai_constants.item_class_ccex, jai_constants.item_class_ccin,
1246: jai_constants.item_class_fgin, jai_constants.item_class_fgex
1247: )

Line 1244: jai_constants.item_class_cgex, jai_constants.item_class_cgin,

1240: AND jtl.inventory_item_id = jmtl.inventory_item_id
1241: AND jtrx.organization_id = jmtl.organization_id
1242: --AND jmtl.item_class in ('RMIN','RMEX','CGEX','CGIN','FGIN','FGEX','CCIN','CCEX') /* Modified by Ramananda for removal of SQL LITERALs */
1243: AND jmtl.item_class IN ( jai_constants.item_class_rmin, jai_constants.item_class_rmex,
1244: jai_constants.item_class_cgex, jai_constants.item_class_cgin,
1245: jai_constants.item_class_ccex, jai_constants.item_class_ccin,
1246: jai_constants.item_class_fgin, jai_constants.item_class_fgex
1247: )
1248: AND jtc.tax_type like '%Excise%'

Line 1245: jai_constants.item_class_ccex, jai_constants.item_class_ccin,

1241: AND jtrx.organization_id = jmtl.organization_id
1242: --AND jmtl.item_class in ('RMIN','RMEX','CGEX','CGIN','FGIN','FGEX','CCIN','CCEX') /* Modified by Ramananda for removal of SQL LITERALs */
1243: AND jmtl.item_class IN ( jai_constants.item_class_rmin, jai_constants.item_class_rmex,
1244: jai_constants.item_class_cgex, jai_constants.item_class_cgin,
1245: jai_constants.item_class_ccex, jai_constants.item_class_ccin,
1246: jai_constants.item_class_fgin, jai_constants.item_class_fgex
1247: )
1248: AND jtc.tax_type like '%Excise%'
1249: AND jtl.customer_trx_id = pr_new.customer_trx_id

Line 1246: jai_constants.item_class_fgin, jai_constants.item_class_fgex

1242: --AND jmtl.item_class in ('RMIN','RMEX','CGEX','CGIN','FGIN','FGEX','CCIN','CCEX') /* Modified by Ramananda for removal of SQL LITERALs */
1243: AND jmtl.item_class IN ( jai_constants.item_class_rmin, jai_constants.item_class_rmex,
1244: jai_constants.item_class_cgex, jai_constants.item_class_cgin,
1245: jai_constants.item_class_ccex, jai_constants.item_class_ccin,
1246: jai_constants.item_class_fgin, jai_constants.item_class_fgex
1247: )
1248: AND jtc.tax_type like '%Excise%'
1249: AND jtl.customer_trx_id = pr_new.customer_trx_id
1250: AND jtrx.customer_trx_id = pr_new.customer_trx_id;

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

1260: (SELECT customer_trx_line_id
1261: FROM JAI_AR_TRX_LINES
1262: WHERE customer_trx_id = pr_new.customer_trx_id
1263: )
1264: AND upper(jtc.tax_type) IN (upper(jai_constants.tax_type_cvd_edu_cess), upper(jai_constants.tax_type_exc_edu_cess));
1265:
1266: -- Start of bug 4185033
1267: /*
1268: || Cursor added by aiyer for the bug 4185033

Line 1305: regime_code = jai_constants.vat_regime AND

1301: jcttl.link_to_cust_trx_line_id = jctl.customer_trx_line_id AND
1302: jctl.customer_trx_id = pr_new.customer_trx_id AND
1303: jcttl.tax_id = jtc.tax_id AND
1304: jtc.tax_type = jrttv.tax_type AND
1305: regime_code = jai_constants.vat_regime AND
1306: jtc.org_id = pr_new.org_id ;
1307:
1308: /*
1309: || Added by kunkumar for bug#5645003

Line 1337: regime_code = jai_constants.vat_regime

1333: regime_id
1334: FROM
1335: jai_regime_tax_types_v
1336: WHERE
1337: regime_code = jai_constants.vat_regime
1338: AND rownum = 1 ;
1339:
1340: ln_vat_reversal_exists NUMBER ;
1341: lv_vat_reversal VARCHAR2(100);

Line 1355: regime_code = jai_constants.vat_regime AND

1351: nvl(attribute_value ,'N') attribute_value
1352: FROM
1353: JAI_RGM_ORG_REGNS_V
1354: WHERE
1355: regime_code = jai_constants.vat_regime AND
1356: attribute_type_code = jai_constants.regn_type_others AND /*'OTHERS' AND */
1357: attribute_code = jai_constants.attr_code_same_inv_no AND /*'SAME_INVOICE_NO' AND */
1358: organization_id = cp_organization_id AND
1359: location_id = cp_location_id;

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

1352: FROM
1353: JAI_RGM_ORG_REGNS_V
1354: WHERE
1355: regime_code = jai_constants.vat_regime AND
1356: attribute_type_code = jai_constants.regn_type_others AND /*'OTHERS' AND */
1357: attribute_code = jai_constants.attr_code_same_inv_no AND /*'SAME_INVOICE_NO' AND */
1358: organization_id = cp_organization_id AND
1359: location_id = cp_location_id;
1360:

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

1353: JAI_RGM_ORG_REGNS_V
1354: WHERE
1355: regime_code = jai_constants.vat_regime AND
1356: attribute_type_code = jai_constants.regn_type_others AND /*'OTHERS' AND */
1357: attribute_code = jai_constants.attr_code_same_inv_no AND /*'SAME_INVOICE_NO' AND */
1358: organization_id = cp_organization_id AND
1359: location_id = cp_location_id;
1360:
1361: CURSOR cur_get_exc_inv_no

Line 1406: pv_return_code := jai_constants.successful ;

1402: lv_doc_type_class varchar2(2); /* csahoo for seperate vat invoice num for unreg dealers - bug# 5233925*/
1403:
1404: /* CODE ADDED TILL TO INCORPORATE MASTER ORGANIZATION */
1405: BEGIN
1406: pv_return_code := jai_constants.successful ;
1407: /*------------------------------------------------------------------------------------------
1408: FILENAME: JA_IN_LOC_AR_HDR_UPDATE_TRG.sql
1409: CHANGE HISTORY:
1410: S.No Date Author and Details

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

1474: FETCH cur_chk_temp_lines_exist INTO ln_exists;
1475: IF CUR_CHK_TEMP_LINES_EXIST%FOUND THEN
1476: CLOSE cur_chk_temp_lines_exist;
1477: /* raise_application_error(-20121,'IL Tax not applied - Please wait for AR Tax and Freight Defaultation Concurrent Request to complete');
1478: */ 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 ;
1479: END IF ;
1480: CLOSE cur_chk_temp_lines_exist;
1481: END IF;
1482: -- End of bug 4185033

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

1637: v_exempt_bal := (NVL(v_exempt_bal, 0) + line_rec.quantity * line_rec.assessable_value * NVL(v_modvat_tax_rate,0))/100;
1638: IF v_exempt_bal > v_rg23a_bal THEN
1639: /* RAISE_APPLICATION_ERROR(-20120, 'Register RG23A PART II Balance -> '||
1640: TO_CHAR(v_rg23a_bal ) || ' IS less than the Modvat Amount ->' ||
1641: TO_CHAR(v_exempt_bal)); */ pv_return_code := jai_constants.expected_error ; pv_return_message := 'Register RG23A PART II Balance -> '||
1642: TO_CHAR(v_rg23a_bal ) || ' IS less than the Modvat Amount ->' ||
1643: TO_CHAR(v_exempt_bal) ; return ;
1644: END IF;
1645: END IF;

Line 1669: || ' ,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)

1665: AND -- added by sriram - bug # 3021588
1666: ( NVL(v_lou_flag,'N') = 'N') -- added by sriram - bug # 3021588
1667: THEN
1668: /* RAISE_APPLICATION_ERROR(-20120, 'Bonded Register Has Balance -> ' || TO_CHAR(v_register_balance)
1669: || ' ,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)
1670: || ' ,which IS less than Excisable Amount -> ' || TO_CHAR(v_bond_tax_amount) ; return ;
1671: END IF;
1672:
1673: IF (nvl(v_register_exp_date,sysdate) < Sysdate ) THEN

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

1671: END IF;
1672:
1673: IF (nvl(v_register_exp_date,sysdate) < Sysdate ) THEN
1674: /* RAISE_APPLICATION_ERROR(-20121, 'Validity Date of the Bond Register has expired');
1675: */ pv_return_code := jai_constants.expected_error ; pv_return_message := 'Validity Date of the Bond Register has expired' ; return ;
1676: END IF ;
1677: ELSIF v_reg_code IN ('23D_DOMESTIC_EXCISE','23D_EXPORT_EXCISE','23D_DOM_WITHOUT_EXCISE','23D_EXPORT_WITHOUT_EXCISE')
1678: THEN /*Bug#4601570 bduvarag start*/
1679: IF v_trading_flag = 'Y' AND

Line 1691: || ' , 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)

1687: IF NVL(v_matched_qty,0)<> NVL(line_rec.quantity,0)
1688: THEN
1689: /* RAISE_APPLICATION_ERROR(-20120, 'Matched Quantity -> ' || TO_CHAR(v_matched_qty)
1690: || ' , IS less than Invoiced Quantity -> ' || TO_CHAR(line_rec.quantity)
1691: || ' , 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)
1692: || ' , IS less than Invoiced Quantity -> ' || TO_CHAR(line_rec.quantity)
1693: || ' ,FOR line NUMBER -> ' || TO_CHAR(line_rec.line_number) ; return ;
1694: EXIT;
1695: END IF;

Line 1708: || ' ,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)

1704: IF NVL(v_rg23d_register_balance,0) < NVL(v_rg23d_tax_amount,0)
1705: and (NVL(v_lou_flag,'N') = 'N') -- added by sriram bug # 3021588
1706: THEN
1707: /* RAISE_APPLICATION_ERROR(-20120, 'RG23D Bonded Register Has Balance -> ' || TO_CHAR(v_rg23d_register_balance)
1708: || ' ,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)
1709: || ' ,which IS less than Excisable Amount -> ' || TO_CHAR(v_rg23d_tax_amount) ; return ;
1710: END IF;
1711:
1712: -- added by sriram - bug # 3021588

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

1711:
1712: -- added by sriram - bug # 3021588
1713: IF (v_register_exp_date > Sysdate ) THEN
1714: /* RAISE_APPLICATION_ERROR(-20121, 'Validity Date of the Bond Register has expired');
1715: */ pv_return_code := jai_constants.expected_error ; pv_return_message := 'Validity Date of the Bond Register has expired' ; return ;
1716: -- ends here additions by sriram - bug # 3021588
1717: END IF;
1718: END IF;
1719: END IF;/*Bug#4601570 bduvarag*/

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

1746:
1747: IF v_errbuf is not null THEN
1748: -- to raise an error when the excise invoice returns a value.
1749: /* raise_application_error(-20107,'Error During Excise Invoice Generation ! ' || v_errbuf);
1750: */ pv_return_code := jai_constants.expected_error ; pv_return_message := 'Error During Excise Invoice Generation ! ' || v_errbuf ; return ;
1751: END IF;
1752:
1753: IF NVL(v_item_class,'~') not in ('OTIN') THEN
1754:

Line 1788: if lv_process_flag <> jai_constants.successful then

1784: p_process_flag => lv_process_flag ,
1785: p_process_message => lv_process_message
1786: );
1787:
1788: if lv_process_flag <> jai_constants.successful then
1789: lv_rg23a_cess_avlbl := 'FALSE';
1790: else
1791: lv_rg23a_cess_avlbl := 'TRUE';
1792: end if;

Line 1805: if lv_process_flag <> jai_constants.successful then

1801: p_process_flag => lv_process_flag ,
1802: p_process_message => lv_process_message
1803: );
1804:
1805: if lv_process_flag <> jai_constants.successful then
1806: lv_rg23c_cess_avlbl := 'FALSE';
1807: else
1808: lv_rg23c_cess_avlbl := 'TRUE';
1809: end if;

Line 1822: if lv_process_flag <> jai_constants.successful then

1818: p_process_flag => lv_process_flag ,
1819: p_process_message => lv_process_message
1820: );
1821:
1822: if lv_process_flag <> jai_constants.successful then
1823: lv_pla_cess_avlbl := 'FALSE';
1824: else
1825: lv_pla_cess_avlbl := 'TRUE';
1826: end if;

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

1947: END IF; -- pref 1 if condition's end if
1948:
1949: IF v_reg_type is null THEN
1950: /* raise_application_error(-20102,'None of the registers have enough balance for the excise duty -> ' || v_tax_amount || ' Or Cess amount => ' || ln_Cess_amount);
1951: */ 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 ;
1952: END IF;
1953: IF v_reg_type = 'PLA' and NVL(v_ssi_unit_flag,'N') <> 'Y' THEN
1954: IF v_tax_amount > reg_balance.pla_balance AND lv_pla_cess_avlbl = 'TRUE' THEN
1955: /* raise_application_error(-20102,'PLA Balance -> ' || reg_balance.pla_balance ||

Line 1956: ' 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 ||

1952: END IF;
1953: IF v_reg_type = 'PLA' and NVL(v_ssi_unit_flag,'N') <> 'Y' THEN
1954: IF v_tax_amount > reg_balance.pla_balance AND lv_pla_cess_avlbl = 'TRUE' THEN
1955: /* raise_application_error(-20102,'PLA Balance -> ' || reg_balance.pla_balance ||
1956: ' 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 ||
1957: ' is not enough for the excise duty -> ' || v_tax_amount ; return ;
1958: END IF;
1959: ELSIF v_reg_type = 'RG23A' THEN
1960: IF v_tax_amount > reg_balance.rg23a_balance AND lv_rg23a_cess_avlbl = 'TRUE' THEN

Line 1962: ' 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 ||

1958: END IF;
1959: ELSIF v_reg_type = 'RG23A' THEN
1960: IF v_tax_amount > reg_balance.rg23a_balance AND lv_rg23a_cess_avlbl = 'TRUE' THEN
1961: /* raise_application_error(-20102,'RG23A Balance -> ' || reg_balance.rg23a_balance ||
1962: ' 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 ||
1963: ' is not enough for the excise duty -> ' || v_tax_amount ; return ;
1964: END IF;
1965: ELSIF v_reg_type = 'RG23C' THEN
1966: IF v_tax_amount > reg_balance.rg23c_balance AND lv_rg23c_cess_avlbl = 'TRUE' THEN

Line 1968: ' 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 ||

1964: END IF;
1965: ELSIF v_reg_type = 'RG23C' THEN
1966: IF v_tax_amount > reg_balance.rg23c_balance AND lv_rg23c_cess_avlbl = 'TRUE' THEN
1967: /* raise_application_error(-20102,'RG23C Balance -> ' || reg_balance.rg23c_balance ||
1968: ' 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 ||
1969: ' is not enough for the excise duty -> ' || v_tax_amount ; return ;
1970: END IF;
1971: END IF;
1972: END LOOP;

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

2000:
2001: Exception
2002: When Others Then
2003: /* RAISE_APPLICATION_ERROR(-10101,SQLERRM);
2004: */ pv_return_code := jai_constants.expected_error ; pv_return_message := SQLERRM ; return ;
2005: End ;
2006:
2007: /*
2008: Ends here

Line 2074: ' 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 ||

2070: --3661746
2071: IF v_reg_type = 'RG23A' THEN
2072: IF v_tax_amount > reg_balance.rg23a_balance AND lv_rg23a_cess_avlbl = 'TRUE' THEN
2073: /* raise_application_error(-20102,'RG23A Balance -> ' || reg_balance.rg23a_balance ||
2074: ' 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 ||
2075: ' is not enough for the excise duty -> ' || v_tax_amount ; return ;
2076: END IF;
2077: ELSIF v_reg_type = 'RG23C' THEN
2078: IF v_tax_amount > reg_balance.rg23c_balance AND lv_rg23c_cess_avlbl = 'TRUE' THEN

Line 2080: ' 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 ||

2076: END IF;
2077: ELSIF v_reg_type = 'RG23C' THEN
2078: IF v_tax_amount > reg_balance.rg23c_balance AND lv_rg23c_cess_avlbl = 'TRUE' THEN
2079: /* raise_application_error(-20102,'RG23C Balance -> ' || reg_balance.rg23c_balance ||
2080: ' 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 ||
2081: ' is not enough for the excise duty -> ' || v_tax_amount ; return ;
2082: END IF;
2083: END IF;
2084: --3661746

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

2115:
2116: Exception
2117: When Others Then
2118: /* RAISE_APPLICATION_ERROR(-10101,SQLERRM);
2119: */ pv_return_code := jai_constants.expected_error ; pv_return_message := SQLERRM ; return ;
2120: END;
2121: /*
2122: Ends here - Additions by Sriram
2123: */

Line 2225: ln_regime_code := jai_constants.vat_regime ;

2221: FETCH c_get_regime_id INTO ln_regime_id ;
2222: CLOSE c_get_regime_id ;
2223:
2224: IF ln_regime_id IS NOT NULL THEN
2225: ln_regime_code := jai_constants.vat_regime ;
2226: END IF ;
2227: END IF ;
2228: END IF ;
2229: --bug#5645003, ends

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

2227: END IF ;
2228: END IF ;
2229: --bug#5645003, ends
2230:
2231: IF UPPER(nvl(ln_regime_code,'####')) = jai_constants.vat_regime THEN
2232: /*
2233: || Check the VAT Regime setup for vat invoice no being same as excise invoice no.
2234: || If the attribute value is 'N' or this attribute code does not exist the generate the vat invoice number
2235: */

Line 2285: IF lv_process_flag = jai_constants.expected_error OR

2281: p_process_flag => lv_process_flag ,
2282: p_process_msg => lv_process_message
2283: );
2284:
2285: IF lv_process_flag = jai_constants.expected_error OR
2286: lv_process_flag = jai_constants.unexpected_error
2287: THEN
2288: CLOSE cur_vat_taxes_exist;
2289: /* raise_application_error(-20130,lv_process_message); */ pv_return_code := jai_constants.expected_error ; pv_return_message := lv_process_message ; return ;

Line 2286: lv_process_flag = jai_constants.unexpected_error

2282: p_process_msg => lv_process_message
2283: );
2284:
2285: IF lv_process_flag = jai_constants.expected_error OR
2286: lv_process_flag = jai_constants.unexpected_error
2287: THEN
2288: CLOSE cur_vat_taxes_exist;
2289: /* raise_application_error(-20130,lv_process_message); */ pv_return_code := jai_constants.expected_error ; pv_return_message := lv_process_message ; return ;
2290: /*

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

2285: IF lv_process_flag = jai_constants.expected_error OR
2286: lv_process_flag = jai_constants.unexpected_error
2287: THEN
2288: CLOSE cur_vat_taxes_exist;
2289: /* raise_application_error(-20130,lv_process_message); */ pv_return_code := jai_constants.expected_error ; pv_return_message := lv_process_message ; return ;
2290: /*
2291: app_exception.raise_exception( EXCEPTION_TYPE => 'APP',
2292: EXCEPTION_CODE => NULL ,
2293: EXCEPTION_TEXT => lv_process_message

Line 2311: p_source => jai_constants.source_ar ,

2307: || IF the VAT invoice Number has been successfully generated, then pass accounting entries
2308: */
2309: jai_cmn_rgm_vat_accnt_pkg.process_order_invoice (
2310: p_regime_id => ln_regime_id ,
2311: p_source => jai_constants.source_ar ,
2312: p_organization_id => v_org_id ,
2313: p_location_id => v_loc_id ,
2314: p_delivery_id => NULL ,
2315: p_customer_trx_id => pr_new.customer_trx_id ,

Line 2320: p_called_from => jai_constants.vat_repo_call_inv_comp ,

2316: p_transaction_type => v_trans_type ,
2317: p_vat_invoice_no => lv_vat_invoice_number ,
2318: p_default_invoice_date => nvl(ld_gl_date,pr_new.trx_date) ,
2319: p_batch_id => NULL ,
2320: p_called_from => jai_constants.vat_repo_call_inv_comp ,
2321: p_debug => jai_constants.no ,
2322: p_process_flag => lv_process_flag ,
2323: p_process_message => lv_process_message
2324: );

Line 2321: p_debug => jai_constants.no ,

2317: p_vat_invoice_no => lv_vat_invoice_number ,
2318: p_default_invoice_date => nvl(ld_gl_date,pr_new.trx_date) ,
2319: p_batch_id => NULL ,
2320: p_called_from => jai_constants.vat_repo_call_inv_comp ,
2321: p_debug => jai_constants.no ,
2322: p_process_flag => lv_process_flag ,
2323: p_process_message => lv_process_message
2324: );
2325:

Line 2326: IF lv_process_flag = jai_constants.expected_error OR

2322: p_process_flag => lv_process_flag ,
2323: p_process_message => lv_process_message
2324: );
2325:
2326: IF lv_process_flag = jai_constants.expected_error OR
2327: lv_process_flag = jai_constants.unexpected_error
2328: THEN
2329: CLOSE cur_vat_taxes_exist ;
2330: /* raise_application_error(-20130,lv_process_message); */ pv_return_code := jai_constants.expected_error ; pv_return_message := lv_process_message ; return ;

Line 2327: lv_process_flag = jai_constants.unexpected_error

2323: p_process_message => lv_process_message
2324: );
2325:
2326: IF lv_process_flag = jai_constants.expected_error OR
2327: lv_process_flag = jai_constants.unexpected_error
2328: THEN
2329: CLOSE cur_vat_taxes_exist ;
2330: /* raise_application_error(-20130,lv_process_message); */ pv_return_code := jai_constants.expected_error ; pv_return_message := lv_process_message ; return ;
2331: /*

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

2326: IF lv_process_flag = jai_constants.expected_error OR
2327: lv_process_flag = jai_constants.unexpected_error
2328: THEN
2329: CLOSE cur_vat_taxes_exist ;
2330: /* raise_application_error(-20130,lv_process_message); */ pv_return_code := jai_constants.expected_error ; pv_return_message := lv_process_message ; return ;
2331: /*
2332: app_exception.raise_exception( EXCEPTION_TYPE => 'APP',
2333: EXCEPTION_CODE => NULL ,
2334: EXCEPTION_TEXT => lv_process_message

Line 2360: Pv_return_code := jai_constants.unexpected_error;

2356: */
2357: /* Added an exception block by Ramananda for bug#4570303 */
2358: EXCEPTION
2359: WHEN OTHERS THEN
2360: Pv_return_code := jai_constants.unexpected_error;
2361: Pv_return_message := 'Encountered an error in JAI_AR_RCTA_TRIGGER_PKG.ARU_T4 ' || substr(sqlerrm,1,1900);
2362:
2363: END ARU_T4 ;
2364:

Line 2538: regime_code = jai_constants.vat_regime

2534: regime_id
2535: FROM
2536: jai_regime_tax_types_v
2537: WHERE
2538: regime_code = jai_constants.vat_regime
2539: AND rownum = 1 ;
2540:
2541:
2542:

Line 2556: pv_return_code := jai_constants.successful ;

2552:
2553: v_TRX_TAX_COUNT Number;
2554: v_trx_gl_dist_COUNT Number;
2555: BEGIN
2556: pv_return_code := jai_constants.successful ;
2557: /*------------------------------------------------------------------------------------------
2558: FILENAME: JA_IN_APPS_AR_LINES_INSERT_TRG.sql
2559: CHANGE HISTORY:
2560: 1. 10-Aug-2005 Aiyer bug 4545146 version 120.1

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

2603:
2604:
2605: IF v_TRX_TAX_COUNT <> v_trx_gl_dist_COUNT THEN
2606: /* RAISE_APPLICATION_ERROR(-20102,'Taxes are not consistent in the RA_CUSTOMER_TRX_LINES_ALL AND RA_CUST_TRX_LINE_GL_DIST_ALL Tables');
2607: */ 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 ;
2608: END IF ;
2609:
2610: FOR v_trx_rec in C_GET_TRX_DETAILS
2611:

Line 2668: pv_return_code := jai_constants.successful ;

2664: FETCH register_code_cur1 INTO v_register_code;
2665: CLOSE register_code_cur1;
2666: END IF;
2667: BEGIN
2668: pv_return_code := jai_constants.successful ;
2669: FOR TAX_TYPE_REC IN TAX_TYPE_CUR(v_trx_rec.customer_trx_line_id)
2670: LOOP
2671:
2672:

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

2748: WHEN OTHERS THEN
2749: v_err_mesg := SUBSTR(SQLERRM,1,240);
2750:
2751: /* RAISE_APPLICATION_ERROR(-20004,'error in processing the invoice ..' || v_trx_num || v_err_mesg);
2752: */ pv_return_code := jai_constants.expected_error ; pv_return_message := 'error in processing the invoice ..' || v_trx_num || v_err_mesg ; return ;
2753: END ;
2754:
2755: END LOOP;
2756: EXCEPTION

Line 2763: Pv_return_code := jai_constants.unexpected_error;

2759:
2760: --RAISE_APPLICATION_ERROR(-20003,'exception occured during processing invoice ..' || v_trx_num || v_err_mesg);
2761:
2762: /* Added an exception block by Ramananda for bug#4570303 */
2763: Pv_return_code := jai_constants.unexpected_error;
2764: Pv_return_message := 'Encountered an error in JAI_AR_RCTA_TRIGGER_PKG.ARU_T4. ' ||
2765: 'Exception occured during processing invoice ..' || v_trx_num || v_err_mesg ;
2766:
2767: END ARU_T5 ;

Line 2901: pv_return_code := jai_constants.successful ;

2897:
2898: --END 5631784
2899:
2900: BEGIN
2901: pv_return_code := jai_constants.successful ;
2902: /*------------------------------------------------------------------------------------------
2903: FILENAME: JA_IN_AR_HDR_UPDATE_TRG.sql
2904:
2905: CHANGE HISTORY:

Line 3118: ( CP_REGIME_CODE => JAI_CONSTANTS.TCS_REGIME

3114: /** sacseth, bug# 5631784 - TCS enhancement */
3115: /** Check if TCS type of taxes exists for v_tax_category_id */
3116:
3117: OPEN GC_CHK_RGM_TAX_EXISTS
3118: ( CP_REGIME_CODE => JAI_CONSTANTS.TCS_REGIME
3119: , CP_RGM_TAX_TYPE => JAI_CONSTANTS.TAX_TYPE_TCS
3120: , CP_TAX_CATEGORY_ID => V_TAX_CATEGORY_ID
3121: );
3122: FETCH GC_CHK_RGM_TAX_EXISTS INTO LN_TCS_EXISTS;

Line 3119: , CP_RGM_TAX_TYPE => JAI_CONSTANTS.TAX_TYPE_TCS

3115: /** Check if TCS type of taxes exists for v_tax_category_id */
3116:
3117: OPEN GC_CHK_RGM_TAX_EXISTS
3118: ( CP_REGIME_CODE => JAI_CONSTANTS.TCS_REGIME
3119: , CP_RGM_TAX_TYPE => JAI_CONSTANTS.TAX_TYPE_TCS
3120: , CP_TAX_CATEGORY_ID => V_TAX_CATEGORY_ID
3121: );
3122: FETCH GC_CHK_RGM_TAX_EXISTS INTO LN_TCS_EXISTS;
3123: CLOSE GC_CHK_RGM_TAX_EXISTS;

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

3123: CLOSE GC_CHK_RGM_TAX_EXISTS;
3124:
3125: IF LN_TCS_EXISTS IS NOT NULL THEN
3126: /** TCS type of tax(s) are present */
3127: OPEN GC_GET_REGIME_ID ( CP_REGIME_CODE => JAI_CONSTANTS.TCS_REGIME);
3128: FETCH GC_GET_REGIME_ID INTO LN_TCS_REGIME_ID;
3129: CLOSE GC_GET_REGIME_ID;
3130:
3131: /** Check current threshold slab. The following procedure returns null threshold_slab_id if threshold is not yet reached */

Line 3135: , p_party_type => jai_constants.party_type_customer

3131: /** Check current threshold slab. The following procedure returns null threshold_slab_id if threshold is not yet reached */
3132: jai_rgm_thhold_proc_pkg.get_threshold_slab_id
3133: ( p_regime_id => ln_tcs_regime_id
3134: , p_organization_id => v_organization_id
3135: , p_party_type => jai_constants.party_type_customer
3136: , p_party_id => v_customer_id
3137: , p_org_id => v_org_id
3138: , p_source_trx_date => v_trx_date
3139: , p_threshold_slab_id => ln_threshold_slab_id

Line 3143: if lv_process_flag <> jai_constants.successful then

3139: , p_threshold_slab_id => ln_threshold_slab_id
3140: , p_process_flag => lv_process_flag
3141: , p_process_message => lv_process_message
3142: );
3143: if lv_process_flag <> jai_constants.successful then
3144: app_exception.raise_exception
3145: (exception_type => 'APP'
3146: ,exception_code => -20275
3147: ,exception_text => lv_process_message

Line 3163: if lv_process_flag <> jai_constants.successful then

3159: , p_threshold_tax_cat_id => ln_threshold_tax_cat_id
3160: , p_process_flag => lv_process_flag
3161: , p_process_message => lv_process_message
3162: );
3163: if lv_process_flag <> jai_constants.successful then
3164: app_exception.raise_exception
3165: (exception_type => 'APP'
3166: ,exception_code => -20275
3167: ,exception_text => lv_process_message

Line 3180: , p_thhold_cat_base_tax_typ => jai_constants.tax_type_tcs

3176: v_last_update_date , v_last_updated_by , v_last_update_login
3177: , null --Add a default value by Jia for Bug#6859632
3178: , ln_vat_assessable_value
3179: -- Bug 6109941, Added by brathod for fwd porting bug 4742259
3180: , p_thhold_cat_base_tax_typ => jai_constants.tax_type_tcs
3181: , p_threshold_tax_cat_id => ln_threshold_tax_cat_id
3182: , p_source_trx_type => null
3183: , p_source_table_name => null
3184: , p_action => jai_constants.default_taxes

Line 3184: , p_action => jai_constants.default_taxes

3180: , p_thhold_cat_base_tax_typ => jai_constants.tax_type_tcs
3181: , p_threshold_tax_cat_id => ln_threshold_tax_cat_id
3182: , p_source_trx_type => null
3183: , p_source_table_name => null
3184: , p_action => jai_constants.default_taxes
3185:
3186: -- End 6109941
3187: );
3188:

Line 3208: Pv_return_code := jai_constants.unexpected_error;

3204: END LOOP;
3205: /* Added an exception block by Ramananda for bug#4570303 */
3206: EXCEPTION
3207: WHEN OTHERS THEN
3208: Pv_return_code := jai_constants.unexpected_error;
3209: Pv_return_message := 'Encountered an error in JAI_AR_RCTA_TRIGGER_PKG.ARI_T7 ' || substr(sqlerrm,1,1900);
3210:
3211: END ARU_T6 ;
3212: /*

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

3240:
3241: BEGIN
3242:
3243: V_HEADER_ID := PR_NEW.CUSTOMER_TRX_ID;
3244: IF NVL(PR_NEW.COMPLETE_FLAG,JAI_CONSTANTS.NO) = JAI_CONSTANTS.YES THEN
3245: /** Invoice is getting COMPLETED */
3246: LV_DOCUMENT_TYPE := JAI_CONSTANTS.TRX_TYPE_INV_COMP;
3247: /*********
3248: || When the invoice is getting completed for the very first time (once_complete_flag is still null or 'N') then pass the

Line 3246: LV_DOCUMENT_TYPE := JAI_CONSTANTS.TRX_TYPE_INV_COMP;

3242:
3243: V_HEADER_ID := PR_NEW.CUSTOMER_TRX_ID;
3244: IF NVL(PR_NEW.COMPLETE_FLAG,JAI_CONSTANTS.NO) = JAI_CONSTANTS.YES THEN
3245: /** Invoice is getting COMPLETED */
3246: LV_DOCUMENT_TYPE := JAI_CONSTANTS.TRX_TYPE_INV_COMP;
3247: /*********
3248: || When the invoice is getting completed for the very first time (once_complete_flag is still null or 'N') then pass the
3249: || final TCS accounting for the TCS type of taxes belonging to the manual invoice only
3250: || This is not applicable for the imported invoices.

Line 3258: lv_once_completed_flag = jai_constants.no

3254: FETCH ONCE_COMPLETE_FLAG_CUR INTO LV_ONCE_COMPLETED_FLAG;
3255: CLOSE ONCE_COMPLETE_FLAG_CUR;
3256:
3257: IF Pr_new.created_from <> 'RAXTRX' AND
3258: lv_once_completed_flag = jai_constants.no
3259: THEN
3260: -- jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'Calling -> jai_ar_tcs_rep_pkg.ar_accounting ');
3261: JAI_AR_TCS_REP_PKG.AR_ACCOUNTING ( P_RACT => PR_NEW ,
3262: P_PROCESS_FLAG => PV_RETURN_CODE ,

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

3265: -- JAI_CMN_DEBUG_CONTEXTS_PKG.PRINT ( PN_REG_ID => LN_REG_ID ,
3266: -- PV_LOG_MSG => 'RETURNED FROM JAI_AR_TCS_REP_PKG.AR_ACCOUNTING ' || CHR(10)
3267: -- ||'P_PROCESS_FLAG=' ||PV_ERR_FLG
3268: -- );
3269: -- IF PV_ERR_FLG <> JAI_CONSTANTS.SUCCESSFUL THEN
3270: -- jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
3271: -- pv_log_msg => 'Error during processing of jai_ar_tcs_rep_pkg.ar_accounting '||chr(10)
3272: -- ||'p_process_flag=' ||pv_err_flg||chr(10)
3273: -- ||'p_process_message='||pv_err_msg

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

3276: -- return;
3277: -- END IF;
3278: END IF;
3279:
3280: ELSIF NVL(PR_NEW.COMPLETE_FLAG,JAI_CONSTANTS.NO) = JAI_CONSTANTS.NO THEN
3281: /** INVOICE IS GETTING INCOMPLETED */
3282: LV_DOCUMENT_TYPE := JAI_CONSTANTS.TRX_TYPE_INV_INCOMP;
3283: END IF;
3284:

Line 3282: LV_DOCUMENT_TYPE := JAI_CONSTANTS.TRX_TYPE_INV_INCOMP;

3278: END IF;
3279:
3280: ELSIF NVL(PR_NEW.COMPLETE_FLAG,JAI_CONSTANTS.NO) = JAI_CONSTANTS.NO THEN
3281: /** INVOICE IS GETTING INCOMPLETED */
3282: LV_DOCUMENT_TYPE := JAI_CONSTANTS.TRX_TYPE_INV_INCOMP;
3283: END IF;
3284:
3285: -- jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'Calling -> JAI_AR_TCS_REP_PKG.PROCESS_TRANSACTIONS');
3286: JAI_AR_TCS_REP_PKG.PROCESS_TRANSACTIONS

Line 3288: , P_EVENT => JAI_CONSTANTS.TRX_EVENT_COMPLETION

3284:
3285: -- jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'Calling -> JAI_AR_TCS_REP_PKG.PROCESS_TRANSACTIONS');
3286: JAI_AR_TCS_REP_PKG.PROCESS_TRANSACTIONS
3287: ( P_RACT => PR_NEW
3288: , P_EVENT => JAI_CONSTANTS.TRX_EVENT_COMPLETION
3289: , P_PROCESS_FLAG => PV_RETURN_CODE
3290: , P_PROCESS_MESSAGE => PV_RETURN_MESSAGE
3291: );
3292: -- jai_cmn_debug_contexts_pkg.print (ln_reg_id

Line 3297: IF PV_RETURN_CODE <> JAI_CONSTANTS.SUCCESSFUL THEN

3293: -- , 'Process Result: ' || chr(10)
3294: -- ||'p_process_flag=' ||PV_RETURN_CODE||chr(10)
3295: -- ||'p_process_message='||PV_RETURN_MESSAGE||chr(10)
3296: -- );
3297: IF PV_RETURN_CODE <> JAI_CONSTANTS.SUCCESSFUL THEN
3298: RETURN;
3299: END IF;
3300:
3301: END ARU_T7;

Line 3412: pv_return_code := jai_constants.successful ;

3408: WHERE trx_number = p_recurred_from_trx_number
3409: AND NVL(batch_source_id,0) = p_batch_source_id;
3410:
3411: BEGIN
3412: pv_return_code := jai_constants.successful ;
3413:
3414: OPEN temp_fetch;
3415: FETCH temp_fetch INTO v_trx_number, v_header_id, v_recurred_from_trx_number, v_batch_source_id,
3416: v_created_from, v_creation_date, v_created_by,

Line 3546: pv_return_code := jai_constants.successful;

3542: DELETE JAI_AR_TRXS
3543: WHERE customer_trx_id = pr_old.customer_trx_id ;
3544:
3545: pv_return_message := '';
3546: pv_return_code := jai_constants.successful;
3547:
3548: EXCEPTION
3549: when others then
3550: pv_return_message := substr (sqlerrm,1,1999);

Line 3551: pv_return_code := jai_constants.unexpected_error;

3547:
3548: EXCEPTION
3549: when others then
3550: pv_return_message := substr (sqlerrm,1,1999);
3551: pv_return_code := jai_constants.unexpected_error;
3552: END ARD_T1;
3553:
3554: END JAI_AR_RCTA_TRIGGER_PKG ;