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

Line 123: pv_return_code := jai_constants.successful;

119: G_MODULE_NAME || lv_api_name,
120: G_PACKAGE_NAME || ':' || lv_api_name || '.BEGIN()+');
121: END IF;
122:
123: pv_return_code := jai_constants.successful;
124: v_update_rg := 'Y';
125: v_update_rg23d_flag := 'Y';
126: v_org_id := -1;
127: v_parent_trx_number := pr_new.recurred_from_trx_number;

Line 343: Pv_return_code := jai_constants.unexpected_error;

339: G_PACKAGE_NAME || ':' || lv_api_name || '.END()-');
340: END IF;
341: EXCEPTION
342: WHEN OTHERS THEN
343: Pv_return_code := jai_constants.unexpected_error;
344: Pv_return_message := 'Encountered an error in JAI_AR_TRX_HEADERS_PKG.POPULATE_AR_TRXS. ' ||
345: substr(SQLERRM, 1, 1900);
346: IF G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL THEN
347: FND_LOG.STRING(G_LEVEL_UNEXPECTED,

Line 502: pv_return_code := jai_constants.successful;

498: G_MODULE_NAME || lv_api_name,
499: G_PACKAGE_NAME || ':' || lv_api_name || '.BEGIN()+');
500: END IF;
501:
502: pv_return_code := jai_constants.successful;
503:
504: OPEN temp_fetch;
505: FETCH temp_fetch
506: INTO v_trx_number,

Line 641: lv_action := JAI_CONSTANTS.INSERTING;

637: FETCH c_jai_ar_trx_lines
638: INTO t_jai_line_rec_new;
639: CLOSE c_jai_ar_trx_lines;
640:
641: lv_action := JAI_CONSTANTS.INSERTING;
642: JAI_AR_TAX_LINES_PKG.POPULATE_TAX_LINES_WRAPPER(pr_old => t_jai_line_rec_old,
643: pr_new => t_jai_line_rec_new,
644: pv_action => lv_action,
645: pv_return_code => lv_return_code,

Line 647: IF PV_RETURN_CODE <> JAI_CONSTANTS.successful THEN

643: pr_new => t_jai_line_rec_new,
644: pv_action => lv_action,
645: pv_return_code => lv_return_code,
646: pv_return_message => lv_return_message);
647: IF PV_RETURN_CODE <> JAI_CONSTANTS.successful THEN
648: RAISE le_error;
649: END IF;
650:
651: FOR rec1 in TAX_INFO_CUR(rec.customer_trx_line_id) LOOP

Line 736: lv_action := JAI_CONSTANTS.UPDATING;

732: OPEN c_jai_ar_trx_lines(v_customer_trx_line_id);
733: FETCH c_jai_ar_trx_lines
734: INTO t_jai_line_rec_new;
735: CLOSE c_jai_ar_trx_lines;
736: lv_action := JAI_CONSTANTS.UPDATING;
737: IF (((t_jai_line_rec_new.AUTO_INVOICE_FLAG <> 'Y' AND
738: t_jai_line_rec_old.AUTO_INVOICE_FLAG <> 'Y') AND
739: (t_jai_line_rec_new.Excise_Invoice_No IS NULL) AND
740: (t_jai_line_rec_new.payment_Register IS NULL) AND

Line 750: IF lv_return_code <> jai_constants.successful then

746: pv_action => lv_action,
747: pv_return_code => lv_return_code,
748: pv_return_message => lv_return_message);
749:
750: IF lv_return_code <> jai_constants.successful then
751: RAISE le_error;
752: END IF;
753: END IF;
754:

Line 771: Pv_return_code := jai_constants.unexpected_error;

767: G_PACKAGE_NAME || ':' || lv_api_name || '.END()-');
768: END IF;
769: EXCEPTION
770: WHEN OTHERS THEN
771: Pv_return_code := jai_constants.unexpected_error;
772: Pv_return_message := 'Encountered an error in JAI_AR_TRX_HEADERS_PKG.POPULATE_COPIED_TRANSACTIONS. ' ||
773: substr(SQLERRM, 1, 1900);
774: IF G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL THEN
775: FND_LOG.STRING(G_LEVEL_UNEXPECTED,

Line 818: pv_return_code := jai_constants.successful;

814: FND_LOG.STRING(G_LEVEL_PROCEDURE,
815: G_MODULE_NAME || lv_api_name,
816: G_PACKAGE_NAME || ':' || lv_api_name || '.BEGIN()+');
817: END IF;
818: pv_return_code := jai_constants.successful;
819: v_trx_number := pr_new.Trx_Number;
820: v_ref_line_id := pr_new.interface_header_attribute7;
821:
822: IF pr_new.created_from = 'RAXTRX' THEN

Line 848: lv_action := JAI_CONSTANTS.UPDATING;

844: OPEN c_jai_ar_trx_lines(c_jai_ar_trx_lines_rec.customer_trx_line_id);
845: FETCH c_jai_ar_trx_lines
846: INTO t_jai_line_rec_new;
847: CLOSE c_jai_ar_trx_lines;
848: lv_action := JAI_CONSTANTS.UPDATING;
849: IF (((t_jai_line_rec_new.AUTO_INVOICE_FLAG <> 'Y' AND
850: t_jai_line_rec_old.AUTO_INVOICE_FLAG <> 'Y') AND
851: (t_jai_line_rec_new.Excise_Invoice_No IS NULL) AND
852: (t_jai_line_rec_new.payment_Register IS NULL) AND

Line 862: IF lv_return_code <> jai_constants.successful then

858: pv_action => lv_action,
859: pv_return_code => lv_return_code,
860: pv_return_message => lv_return_message);
861:
862: IF lv_return_code <> jai_constants.successful then
863: RAISE le_error;
864: END IF;
865: END IF;
866: END LOOP;

Line 904: Pv_return_code := jai_constants.unexpected_error;

900: G_PACKAGE_NAME || ':' || lv_api_name || '.END()-');
901: END IF;
902: EXCEPTION
903: WHEN OTHERS THEN
904: Pv_return_code := jai_constants.unexpected_error;
905: Pv_return_message := 'Encountered an error in ' || G_PACKAGE_NAME || '.' ||
906: lv_api_name || substr(sqlerrm, 1, 1900);
907: END UPDATE_TRX_NUMBER;
908:

Line 1040: pv_return_code := jai_constants.successful;

1036: FND_LOG.STRING(G_LEVEL_PROCEDURE,
1037: G_MODULE_NAME || lv_api_name,
1038: G_PACKAGE_NAME || ':' || lv_api_name || '.BEGIN()+');
1039: END IF;
1040: pv_return_code := jai_constants.successful;
1041: v_customer_id := pr_new.Ship_To_Customer_ID;
1042: v_org_id := NVL(pr_new.Org_ID, 0);
1043: v_header_id := pr_new.customer_trx_id;
1044: v_ship_to_site_use_id := NVL(pr_new.Ship_To_Site_Use_ID, 0);

Line 1203: OPEN GC_CHK_RGM_TAX_EXISTS(CP_REGIME_CODE => JAI_CONSTANTS.TCS_REGIME,

1199: v_price_list := rec.unit_selling_price;
1200: v_price_list_val := rec.unit_selling_price * rec.quantity;
1201: END IF;
1202:
1203: OPEN GC_CHK_RGM_TAX_EXISTS(CP_REGIME_CODE => JAI_CONSTANTS.TCS_REGIME,
1204: CP_RGM_TAX_TYPE => JAI_CONSTANTS.TAX_TYPE_TCS,
1205: CP_TAX_CATEGORY_ID => V_TAX_CATEGORY_ID);
1206: FETCH GC_CHK_RGM_TAX_EXISTS
1207: INTO LN_TCS_EXISTS;

Line 1204: CP_RGM_TAX_TYPE => JAI_CONSTANTS.TAX_TYPE_TCS,

1200: v_price_list_val := rec.unit_selling_price * rec.quantity;
1201: END IF;
1202:
1203: OPEN GC_CHK_RGM_TAX_EXISTS(CP_REGIME_CODE => JAI_CONSTANTS.TCS_REGIME,
1204: CP_RGM_TAX_TYPE => JAI_CONSTANTS.TAX_TYPE_TCS,
1205: CP_TAX_CATEGORY_ID => V_TAX_CATEGORY_ID);
1206: FETCH GC_CHK_RGM_TAX_EXISTS
1207: INTO LN_TCS_EXISTS;
1208: CLOSE GC_CHK_RGM_TAX_EXISTS;

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

1207: INTO LN_TCS_EXISTS;
1208: CLOSE GC_CHK_RGM_TAX_EXISTS;
1209:
1210: IF LN_TCS_EXISTS IS NOT NULL THEN
1211: OPEN GC_GET_REGIME_ID(CP_REGIME_CODE => JAI_CONSTANTS.TCS_REGIME);
1212: FETCH GC_GET_REGIME_ID
1213: INTO LN_TCS_REGIME_ID;
1214: CLOSE GC_GET_REGIME_ID;
1215:

Line 1218: p_party_type => jai_constants.party_type_customer,

1214: CLOSE GC_GET_REGIME_ID;
1215:
1216: jai_rgm_thhold_proc_pkg.get_threshold_slab_id(p_regime_id => ln_tcs_regime_id,
1217: p_organization_id => v_organization_id,
1218: p_party_type => jai_constants.party_type_customer,
1219: p_party_id => v_customer_id,
1220: p_org_id => v_org_id,
1221: p_source_trx_date => v_trx_date,
1222: p_threshold_slab_id => ln_threshold_slab_id,

Line 1225: if lv_process_flag <> jai_constants.successful then

1221: p_source_trx_date => v_trx_date,
1222: p_threshold_slab_id => ln_threshold_slab_id,
1223: p_process_flag => lv_process_flag,
1224: p_process_message => lv_process_message);
1225: if lv_process_flag <> jai_constants.successful then
1226: app_exception.raise_exception(exception_type => 'APP',
1227: exception_code => -20275,
1228: exception_text => lv_process_message);
1229: end if;

Line 1238: if lv_process_flag <> jai_constants.successful then

1234: p_org_id => v_org_id,
1235: p_threshold_tax_cat_id => ln_threshold_tax_cat_id,
1236: p_process_flag => lv_process_flag,
1237: p_process_message => lv_process_message);
1238: if lv_process_flag <> jai_constants.successful then
1239: app_exception.raise_exception(exception_type => 'APP',
1240: exception_code => -20275,
1241: exception_text => lv_process_message);
1242: end if;

Line 1266: p_thhold_cat_base_tax_typ => jai_constants.tax_type_tcs,

1262: v_last_updated_by,
1263: v_last_update_login,
1264: null,
1265: ln_vat_assessable_value,
1266: p_thhold_cat_base_tax_typ => jai_constants.tax_type_tcs,
1267: p_threshold_tax_cat_id => ln_threshold_tax_cat_id,
1268: p_source_trx_type => null,
1269: p_source_table_name => null,
1270: p_action => jai_constants.default_taxes);

Line 1270: p_action => jai_constants.default_taxes);

1266: p_thhold_cat_base_tax_typ => jai_constants.tax_type_tcs,
1267: p_threshold_tax_cat_id => ln_threshold_tax_cat_id,
1268: p_source_trx_type => null,
1269: p_source_table_name => null,
1270: p_action => jai_constants.default_taxes);
1271:
1272: END IF;
1273:
1274: v_service_type := JAI_AR_RCTLA_TRIGGER_PKG.get_service_type(v_customer_id,

Line 1299: lv_action := JAI_CONSTANTS.UPDATING;

1295: OPEN c_jai_ar_trx_lines(rec.customer_trx_line_id);
1296: FETCH c_jai_ar_trx_lines
1297: INTO t_jai_line_rec_new;
1298: CLOSE c_jai_ar_trx_lines;
1299: lv_action := JAI_CONSTANTS.UPDATING;
1300: IF (((t_jai_line_rec_new.AUTO_INVOICE_FLAG <> 'Y' AND
1301: t_jai_line_rec_old.AUTO_INVOICE_FLAG <> 'Y') AND
1302: (t_jai_line_rec_new.Excise_Invoice_No IS NULL) AND
1303: (t_jai_line_rec_new.payment_Register IS NULL) AND

Line 1313: IF lv_return_code <> jai_constants.successful then

1309: pv_action => lv_action,
1310: pv_return_code => lv_return_code,
1311: pv_return_message => lv_return_message);
1312:
1313: IF lv_return_code <> jai_constants.successful then
1314: RAISE le_error;
1315: END IF;
1316: END IF;
1317: END LOOP;

Line 1325: Pv_return_code := jai_constants.unexpected_error;

1321: G_PACKAGE_NAME || ':' || lv_api_name || '.END()-');
1322: END IF;
1323: EXCEPTION
1324: WHEN OTHERS THEN
1325: Pv_return_code := jai_constants.unexpected_error;
1326: Pv_return_message := 'Encountered an error in JAI_AR_RCTA_TRIGGER_PKG.ARI_T7 ' ||
1327: substr(sqlerrm, 1, 1900);
1328:
1329: END RECALCULATE_TAX;

Line 1346: pv_return_code := jai_constants.successful;

1342: END IF;
1343: DELETE JAI_AR_TRXS WHERE customer_trx_id = pr_old.customer_trx_id;
1344:
1345: pv_return_message := '';
1346: pv_return_code := jai_constants.successful;
1347: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1348: FND_LOG.STRING(G_LEVEL_PROCEDURE,
1349: G_MODULE_NAME || lv_api_name,
1350: G_PACKAGE_NAME || ':' || lv_api_name || '.END()-');

Line 1356: pv_return_code := jai_constants.unexpected_error;

1352: EXCEPTION
1353: when others then
1354: Pv_return_message := 'Encountered an error in ' || G_MODULE_NAME || '.' ||
1355: lv_api_name || ':' || substr(sqlerrm, 1, 1900);
1356: pv_return_code := jai_constants.unexpected_error;
1357: END DELETE_AR_TRXS;
1358:
1359: --COMPLETING
1360: PROCEDURE GENERATE_VAT_INVOICE_NUMBER(pr_old t_jai_rec%type,

Line 1487: lv_action := jai_constants.updating;

1483: close c_get_rec;
1484:
1485: if (t_rec_new.once_completed_flag = 'Y') then
1486:
1487: lv_action := jai_constants.updating;
1488:
1489: JAI_AR_TRXS_PKG.UPDATE_EXCISE_REGISTERS(pr_old => t_rec_old,
1490: pr_new => t_rec_new,
1491: pv_action => lv_action,

Line 1495: IF lv_return_code <> jai_constants.successful then

1491: pv_action => lv_action,
1492: pv_return_code => lv_return_code,
1493: pv_return_message => lv_return_message);
1494:
1495: IF lv_return_code <> jai_constants.successful then
1496: RAISE le_error;
1497: END IF;
1498:
1499: end if;

Line 1517: pv_return_code := jai_constants.successful;

1513: FND_LOG.STRING(G_LEVEL_PROCEDURE,
1514: G_MODULE_NAME || lv_api_name,
1515: G_PACKAGE_NAME || ':' || lv_api_name || '.BEGIN()+');
1516: END IF;
1517: pv_return_code := jai_constants.successful;
1518: Open C_VAT_INVOICE_CUR;
1519: Fetch C_VAT_INVOICE_CUR
1520: into v_loc_vat_inv_no;
1521: close C_VAT_INVOICE_CUR;

Line 1556: Pv_return_code := jai_constants.unexpected_error;

1552: G_PACKAGE_NAME || ':' || lv_api_name || '.END()-');
1553: END IF;
1554: EXCEPTION
1555: WHEN OTHERS THEN
1556: Pv_return_code := jai_constants.unexpected_error;
1557: Pv_return_message := 'Encountered an error in JAI_AR_RCTA_TRIGGER_PKG.ARU_T1 ' ||
1558: substr(sqlerrm, 1, 1900);
1559:
1560: END GENERATE_VAT_INVOICE_NUMBER;

Line 1601: AND regime_code = jai_constants.vat_regime

1597: WHERE jcttl.link_to_cust_trx_line_id = jctl.customer_trx_line_id
1598: AND jctl.customer_trx_id = pr_new.customer_trx_id
1599: AND jcttl.tax_id = jtc.tax_id
1600: AND jtc.tax_type = jrttv.tax_type
1601: AND regime_code = jai_constants.vat_regime
1602: AND jtc.org_id = pr_new.org_id;
1603:
1604: CURSOR cur_get_gl_date(cp_acct_class ra_cust_trx_line_gl_dist_all.account_class%type) IS
1605: SELECT gl_date

Line 1633: WHERE regime_code = jai_constants.vat_regime

1629:
1630: CURSOR c_get_regime_id IS
1631: SELECT regime_id
1632: FROM jai_regime_tax_types_v
1633: WHERE regime_code = jai_constants.vat_regime
1634: AND rownum = 1;
1635: cursor c_get_rec(cn_customer_trx_id number) is
1636: select * from jai_ar_trxs where customer_trx_id = cn_customer_trx_id;
1637:

Line 1650: pv_return_code := jai_constants.successful;

1646: FND_LOG.STRING(G_LEVEL_PROCEDURE,
1647: G_MODULE_NAME || lv_api_name,
1648: G_PACKAGE_NAME || ':' || lv_api_name || '.BEGIN()+');
1649: END IF;
1650: pv_return_code := jai_constants.successful;
1651:
1652: OPEN organization_cur;
1653: FETCH organization_cur
1654: INTO v_organization_id,

Line 1678: UPPER(jai_constants.vat_regime) THEN

1674: into ln_regime_id, ln_regime_code;
1675: CLOSE cur_vat_taxes_exist;
1676:
1677: IF UPPER(nvl(ln_regime_code, '####')) <>
1678: UPPER(jai_constants.vat_regime) THEN
1679: return;
1680: END IF;
1681: IF ln_regime_id IS NULL THEN
1682: lv_vat_reversal := 'VAT REVERSAL';

Line 1695: ln_regime_code := jai_constants.vat_regime;

1691: INTO ln_regime_id;
1692: CLOSE c_get_regime_id;
1693:
1694: IF ln_regime_id IS NOT NULL THEN
1695: ln_regime_code := jai_constants.vat_regime;
1696: END IF;
1697: END IF;
1698: END IF;
1699:

Line 1713: p_source => jai_constants.source_ar,

1709: INTO ld_gl_date;
1710: CLOSE cur_get_gl_date;
1711:
1712: jai_cmn_rgm_vat_accnt_pkg.process_order_invoice(p_regime_id => ln_regime_id,
1713: p_source => jai_constants.source_ar,
1714: p_organization_id => v_organization_id,
1715: p_location_id => v_loc_id,
1716: p_delivery_id => NULL,
1717: p_customer_trx_id => pr_new.customer_trx_id,

Line 1724: p_debug => jai_constants.no,

1720: p_default_invoice_date => nvl(ld_gl_date,
1721: pr_new.trx_date),
1722: p_batch_id => NULL,
1723: 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*/
1724: p_debug => jai_constants.no,
1725: p_process_flag => lv_process_flag,
1726: p_process_message => lv_process_message);
1727:
1728: IF lv_process_flag = jai_constants.expected_error OR

Line 1728: IF lv_process_flag = jai_constants.expected_error OR

1724: p_debug => jai_constants.no,
1725: p_process_flag => lv_process_flag,
1726: p_process_message => lv_process_message);
1727:
1728: IF lv_process_flag = jai_constants.expected_error OR
1729: lv_process_flag = jai_constants.unexpected_error THEN
1730:
1731: pv_return_code := jai_constants.expected_error;
1732: pv_return_message := lv_process_message;

Line 1729: lv_process_flag = jai_constants.unexpected_error THEN

1725: p_process_flag => lv_process_flag,
1726: p_process_message => lv_process_message);
1727:
1728: IF lv_process_flag = jai_constants.expected_error OR
1729: lv_process_flag = jai_constants.unexpected_error THEN
1730:
1731: pv_return_code := jai_constants.expected_error;
1732: pv_return_message := lv_process_message;
1733: return;

Line 1731: pv_return_code := jai_constants.expected_error;

1727:
1728: IF lv_process_flag = jai_constants.expected_error OR
1729: lv_process_flag = jai_constants.unexpected_error THEN
1730:
1731: pv_return_code := jai_constants.expected_error;
1732: pv_return_message := lv_process_message;
1733: return;
1734:
1735: END IF;

Line 1760: lv_action := jai_constants.updating;

1756: close c_get_rec;
1757:
1758: if (t_rec_new.once_completed_flag = 'Y') then
1759:
1760: lv_action := jai_constants.updating;
1761:
1762: JAI_AR_TRXS_PKG.UPDATE_EXCISE_REGISTERS(pr_old => t_rec_old,
1763: pr_new => t_rec_new,
1764: pv_action => lv_action,

Line 1768: IF lv_return_code <> jai_constants.successful then

1764: pv_action => lv_action,
1765: pv_return_code => lv_return_code,
1766: pv_return_message => lv_return_message);
1767:
1768: IF lv_return_code <> jai_constants.successful then
1769: RAISE le_error;
1770: END IF;
1771:
1772: end if;

Line 1782: Pv_return_code := jai_constants.unexpected_error;

1778: G_PACKAGE_NAME || ':' || lv_api_name || '.END()-');
1779: END IF;
1780: EXCEPTION
1781: WHEN OTHERS THEN
1782: Pv_return_code := jai_constants.unexpected_error;
1783: Pv_return_message := 'Encountered an error in JAI_AR_RCTA_TRIGGER_PKG.ARU_T3 ' ||
1784: substr(sqlerrm, 1, 1900);
1785: END VAT_ACCOUNTING;
1786:

Line 1967: AND b.tax_type IN (jai_constants.tax_type_excise,

1963: FROM JAI_AR_TRX_TAX_LINES A,
1964: JAI_CMN_TAXES_ALL B,
1965: JAI_INV_ITM_SETUPS C
1966: WHERE link_to_cust_trx_line_id = p_line_id
1967: AND b.tax_type IN (jai_constants.tax_type_excise,
1968: jai_constants.tax_type_exc_additional,
1969: jai_constants.tax_type_exc_other)
1970: AND A.tax_id = b.tax_id
1971: AND c.inventory_item_id = p_inventory_item_id

Line 1968: jai_constants.tax_type_exc_additional,

1964: JAI_CMN_TAXES_ALL B,
1965: JAI_INV_ITM_SETUPS C
1966: WHERE link_to_cust_trx_line_id = p_line_id
1967: AND b.tax_type IN (jai_constants.tax_type_excise,
1968: jai_constants.tax_type_exc_additional,
1969: jai_constants.tax_type_exc_other)
1970: AND A.tax_id = b.tax_id
1971: AND c.inventory_item_id = p_inventory_item_id
1972: AND c.organization_id = p_org_id

Line 1969: jai_constants.tax_type_exc_other)

1965: JAI_INV_ITM_SETUPS C
1966: WHERE link_to_cust_trx_line_id = p_line_id
1967: AND b.tax_type IN (jai_constants.tax_type_excise,
1968: jai_constants.tax_type_exc_additional,
1969: jai_constants.tax_type_exc_other)
1970: AND A.tax_id = b.tax_id
1971: AND c.inventory_item_id = p_inventory_item_id
1972: AND c.organization_id = p_org_id
1973: AND c.item_class IN

Line 1974: (jai_constants.item_class_rmin,

1970: AND A.tax_id = b.tax_id
1971: AND c.inventory_item_id = p_inventory_item_id
1972: AND c.organization_id = p_org_id
1973: AND c.item_class IN
1974: (jai_constants.item_class_rmin,
1975: jai_constants.item_class_rmex,
1976: jai_constants.item_class_cgex,
1977: jai_constants.item_class_cgin,
1978: jai_constants.item_class_ccex,

Line 1975: jai_constants.item_class_rmex,

1971: AND c.inventory_item_id = p_inventory_item_id
1972: AND c.organization_id = p_org_id
1973: AND c.item_class IN
1974: (jai_constants.item_class_rmin,
1975: jai_constants.item_class_rmex,
1976: jai_constants.item_class_cgex,
1977: jai_constants.item_class_cgin,
1978: jai_constants.item_class_ccex,
1979: jai_constants.item_class_ccin,

Line 1976: jai_constants.item_class_cgex,

1972: AND c.organization_id = p_org_id
1973: AND c.item_class IN
1974: (jai_constants.item_class_rmin,
1975: jai_constants.item_class_rmex,
1976: jai_constants.item_class_cgex,
1977: jai_constants.item_class_cgin,
1978: jai_constants.item_class_ccex,
1979: jai_constants.item_class_ccin,
1980: jai_constants.item_class_fgin,

Line 1977: jai_constants.item_class_cgin,

1973: AND c.item_class IN
1974: (jai_constants.item_class_rmin,
1975: jai_constants.item_class_rmex,
1976: jai_constants.item_class_cgex,
1977: jai_constants.item_class_cgin,
1978: jai_constants.item_class_ccex,
1979: jai_constants.item_class_ccin,
1980: jai_constants.item_class_fgin,
1981: jai_constants.item_class_fgex)

Line 1978: jai_constants.item_class_ccex,

1974: (jai_constants.item_class_rmin,
1975: jai_constants.item_class_rmex,
1976: jai_constants.item_class_cgex,
1977: jai_constants.item_class_cgin,
1978: jai_constants.item_class_ccex,
1979: jai_constants.item_class_ccin,
1980: jai_constants.item_class_fgin,
1981: jai_constants.item_class_fgex)
1982: ORDER BY 1;

Line 1979: jai_constants.item_class_ccin,

1975: jai_constants.item_class_rmex,
1976: jai_constants.item_class_cgex,
1977: jai_constants.item_class_cgin,
1978: jai_constants.item_class_ccex,
1979: jai_constants.item_class_ccin,
1980: jai_constants.item_class_fgin,
1981: jai_constants.item_class_fgex)
1982: ORDER BY 1;
1983:

Line 1980: jai_constants.item_class_fgin,

1976: jai_constants.item_class_cgex,
1977: jai_constants.item_class_cgin,
1978: jai_constants.item_class_ccex,
1979: jai_constants.item_class_ccin,
1980: jai_constants.item_class_fgin,
1981: jai_constants.item_class_fgex)
1982: ORDER BY 1;
1983:
1984: CURSOR ssi_unit_flag_cur(p_org_id IN NUMBER, p_loc_id IN NUMBER) IS

Line 1981: jai_constants.item_class_fgex)

1977: jai_constants.item_class_cgin,
1978: jai_constants.item_class_ccex,
1979: jai_constants.item_class_ccin,
1980: jai_constants.item_class_fgin,
1981: jai_constants.item_class_fgex)
1982: ORDER BY 1;
1983:
1984: CURSOR ssi_unit_flag_cur(p_org_id IN NUMBER, p_loc_id IN NUMBER) IS
1985: SELECT ssi_unit_flag, nvl(trading, 'N')

Line 2046: AND b.tax_type = jai_constants.tax_type_modvat_recovery;

2042: SELECT A.tax_rate
2043: FROM JAI_AR_TRX_TAX_LINES A, JAI_CMN_TAXES_ALL b
2044: WHERE A.tax_id = b.tax_id
2045: AND A.link_to_cust_trx_line_id = p_cust_trx_line_id
2046: AND b.tax_type = jai_constants.tax_type_modvat_recovery;
2047:
2048: v_start_number NUMBER;
2049: v_end_number NUMBER;
2050: v_jump_by NUMBER;

Line 2078: (jai_constants.item_class_rmin,

2074: AND jrtl.link_to_cust_trx_line_id = jtl.customer_trx_line_id
2075: AND jtl.inventory_item_id = jmtl.inventory_item_id
2076: AND jtrx.organization_id = jmtl.organization_id
2077: AND jmtl.item_class IN
2078: (jai_constants.item_class_rmin,
2079: jai_constants.item_class_rmex,
2080: jai_constants.item_class_cgex,
2081: jai_constants.item_class_cgin,
2082: jai_constants.item_class_ccex,

Line 2079: jai_constants.item_class_rmex,

2075: AND jtl.inventory_item_id = jmtl.inventory_item_id
2076: AND jtrx.organization_id = jmtl.organization_id
2077: AND jmtl.item_class IN
2078: (jai_constants.item_class_rmin,
2079: jai_constants.item_class_rmex,
2080: jai_constants.item_class_cgex,
2081: jai_constants.item_class_cgin,
2082: jai_constants.item_class_ccex,
2083: jai_constants.item_class_ccin,

Line 2080: jai_constants.item_class_cgex,

2076: AND jtrx.organization_id = jmtl.organization_id
2077: AND jmtl.item_class IN
2078: (jai_constants.item_class_rmin,
2079: jai_constants.item_class_rmex,
2080: jai_constants.item_class_cgex,
2081: jai_constants.item_class_cgin,
2082: jai_constants.item_class_ccex,
2083: jai_constants.item_class_ccin,
2084: jai_constants.item_class_fgin,

Line 2081: jai_constants.item_class_cgin,

2077: AND jmtl.item_class IN
2078: (jai_constants.item_class_rmin,
2079: jai_constants.item_class_rmex,
2080: jai_constants.item_class_cgex,
2081: jai_constants.item_class_cgin,
2082: jai_constants.item_class_ccex,
2083: jai_constants.item_class_ccin,
2084: jai_constants.item_class_fgin,
2085: jai_constants.item_class_fgex)

Line 2082: jai_constants.item_class_ccex,

2078: (jai_constants.item_class_rmin,
2079: jai_constants.item_class_rmex,
2080: jai_constants.item_class_cgex,
2081: jai_constants.item_class_cgin,
2082: jai_constants.item_class_ccex,
2083: jai_constants.item_class_ccin,
2084: jai_constants.item_class_fgin,
2085: jai_constants.item_class_fgex)
2086: AND jtc.tax_type like '%Excise%'

Line 2083: jai_constants.item_class_ccin,

2079: jai_constants.item_class_rmex,
2080: jai_constants.item_class_cgex,
2081: jai_constants.item_class_cgin,
2082: jai_constants.item_class_ccex,
2083: jai_constants.item_class_ccin,
2084: jai_constants.item_class_fgin,
2085: jai_constants.item_class_fgex)
2086: AND jtc.tax_type like '%Excise%'
2087: AND jtl.customer_trx_id = pr_new.customer_trx_id

Line 2084: jai_constants.item_class_fgin,

2080: jai_constants.item_class_cgex,
2081: jai_constants.item_class_cgin,
2082: jai_constants.item_class_ccex,
2083: jai_constants.item_class_ccin,
2084: jai_constants.item_class_fgin,
2085: jai_constants.item_class_fgex)
2086: AND jtc.tax_type like '%Excise%'
2087: AND jtl.customer_trx_id = pr_new.customer_trx_id
2088: AND jtrx.customer_trx_id = pr_new.customer_trx_id;

Line 2085: jai_constants.item_class_fgex)

2081: jai_constants.item_class_cgin,
2082: jai_constants.item_class_ccex,
2083: jai_constants.item_class_ccin,
2084: jai_constants.item_class_fgin,
2085: jai_constants.item_class_fgex)
2086: AND jtc.tax_type like '%Excise%'
2087: AND jtl.customer_trx_id = pr_new.customer_trx_id
2088: AND jtrx.customer_trx_id = pr_new.customer_trx_id;
2089:

Line 2101: (upper(jai_constants.tax_type_cvd_edu_cess),

2097: (SELECT customer_trx_line_id
2098: FROM JAI_AR_TRX_LINES
2099: WHERE customer_trx_id = pr_new.customer_trx_id)
2100: AND upper(jtc.tax_type) IN
2101: (upper(jai_constants.tax_type_cvd_edu_cess),
2102: upper(jai_constants.tax_type_exc_edu_cess));
2103:
2104: CURSOR cur_chk_temp_lines_exist(cp_customer_trx_id JAI_AR_TRXS.CUSTOMER_TRX_ID%TYPE) IS
2105:

Line 2102: upper(jai_constants.tax_type_exc_edu_cess));

2098: FROM JAI_AR_TRX_LINES
2099: WHERE customer_trx_id = pr_new.customer_trx_id)
2100: AND upper(jtc.tax_type) IN
2101: (upper(jai_constants.tax_type_cvd_edu_cess),
2102: upper(jai_constants.tax_type_exc_edu_cess));
2103:
2104: CURSOR cur_chk_temp_lines_exist(cp_customer_trx_id JAI_AR_TRXS.CUSTOMER_TRX_ID%TYPE) IS
2105:
2106: SELECT '1'

Line 2138: AND regime_code = jai_constants.vat_regime

2134: WHERE jcttl.link_to_cust_trx_line_id = jctl.customer_trx_line_id
2135: AND jctl.customer_trx_id = pr_new.customer_trx_id
2136: AND jcttl.tax_id = jtc.tax_id
2137: AND jtc.tax_type = jrttv.tax_type
2138: AND regime_code = jai_constants.vat_regime
2139: AND jtc.org_id = pr_new.org_id;
2140:
2141: CURSOR c_chk_vat_reversal(cp_tax_type jai_cmn_taxes_all.tax_type%TYPE) IS
2142: SELECT 1

Line 2155: WHERE regime_code = jai_constants.vat_regime

2151:
2152: CURSOR c_get_regime_id IS
2153: SELECT regime_id
2154: FROM jai_regime_tax_types_v
2155: WHERE regime_code = jai_constants.vat_regime
2156: AND rownum = 1;
2157:
2158: ln_vat_reversal_exists NUMBER;
2159: lv_vat_reversal VARCHAR2(100);

Line 2165: WHERE regime_code = jai_constants.vat_regime

2161: CURSOR cur_get_same_inv_no(cp_organization_id JAI_AR_TRXS.ORGANIZATION_ID%TYPE,
2162: cp_location_id JAI_AR_TRXS.LOCATION_ID%TYPE) IS
2163: SELECT nvl(attribute_value, 'N') attribute_value
2164: FROM JAI_RGM_ORG_REGNS_V
2165: WHERE regime_code = jai_constants.vat_regime
2166: AND attribute_type_code = jai_constants.regn_type_others
2167: AND attribute_code = jai_constants.attr_code_same_inv_no
2168: AND organization_id = cp_organization_id
2169: AND location_id = cp_location_id;

Line 2166: AND attribute_type_code = jai_constants.regn_type_others

2162: cp_location_id JAI_AR_TRXS.LOCATION_ID%TYPE) IS
2163: SELECT nvl(attribute_value, 'N') attribute_value
2164: FROM JAI_RGM_ORG_REGNS_V
2165: WHERE regime_code = jai_constants.vat_regime
2166: AND attribute_type_code = jai_constants.regn_type_others
2167: AND attribute_code = jai_constants.attr_code_same_inv_no
2168: AND organization_id = cp_organization_id
2169: AND location_id = cp_location_id;
2170:

Line 2167: AND attribute_code = jai_constants.attr_code_same_inv_no

2163: SELECT nvl(attribute_value, 'N') attribute_value
2164: FROM JAI_RGM_ORG_REGNS_V
2165: WHERE regime_code = jai_constants.vat_regime
2166: AND attribute_type_code = jai_constants.regn_type_others
2167: AND attribute_code = jai_constants.attr_code_same_inv_no
2168: AND organization_id = cp_organization_id
2169: AND location_id = cp_location_id;
2170:
2171: CURSOR cur_get_exc_inv_no IS

Line 2220: pv_return_code := jai_constants.successful;

2216: FND_LOG.STRING(G_LEVEL_PROCEDURE,
2217: G_MODULE_NAME || lv_api_name,
2218: G_PACKAGE_NAME || ':' || lv_api_name || '.BEGIN()+');
2219: END IF;
2220: pv_return_code := jai_constants.successful;
2221: v_complete_flag := 'N';
2222: v_rg_flag := 'N';
2223: v_update_rg_flag := 'N';
2224: v_item_class := 'N';

Line 2242: pv_return_code := jai_constants.expected_error;

2238: INTO ln_exists;
2239: IF CUR_CHK_TEMP_LINES_EXIST%FOUND THEN
2240: CLOSE cur_chk_temp_lines_exist;
2241:
2242: pv_return_code := jai_constants.expected_error;
2243: pv_return_message := 'IL Tax not applied - Please wait for AR Tax and Freight Defaultation Concurrent Request to complete';
2244: return;
2245: END IF;
2246: CLOSE cur_chk_temp_lines_exist;

Line 2294: lv_action := jai_constants.updating;

2290: close c_get_rec;
2291:
2292: if (t_rec_new.once_completed_flag = 'Y') then
2293:
2294: lv_action := jai_constants.updating;
2295:
2296: JAI_AR_TRXS_PKG.UPDATE_EXCISE_REGISTERS(pr_old => t_rec_old,
2297: pr_new => t_rec_new,
2298: pv_action => lv_action,

Line 2302: IF lv_return_code <> jai_constants.successful then

2298: pv_action => lv_action,
2299: pv_return_code => lv_return_code,
2300: pv_return_message => lv_return_message);
2301:
2302: IF lv_return_code <> jai_constants.successful then
2303: RAISE le_error;
2304: END IF;
2305:
2306: end if;

Line 2334: lv_action := jai_constants.updating;

2330: close c_get_rec;
2331:
2332: if (t_rec_new.once_completed_flag = 'Y') then
2333:
2334: lv_action := jai_constants.updating;
2335:
2336: JAI_AR_TRXS_PKG.UPDATE_EXCISE_REGISTERS(pr_old => t_rec_old,
2337: pr_new => t_rec_new,
2338: pv_action => lv_action,

Line 2342: IF lv_return_code <> jai_constants.successful then

2338: pv_action => lv_action,
2339: pv_return_code => lv_return_code,
2340: pv_return_message => lv_return_message);
2341:
2342: IF lv_return_code <> jai_constants.successful then
2343: RAISE le_error;
2344: END IF;
2345:
2346: end if;

Line 2480: pv_return_code := jai_constants.expected_error;

2476: line_rec.assessable_value *
2477: NVL(v_modvat_tax_rate, 0)) / 100;
2478: IF v_exempt_bal > v_rg23a_bal THEN
2479:
2480: pv_return_code := jai_constants.expected_error;
2481: pv_return_message := 'Register RG23A PART II Balance -> ' ||
2482: TO_CHAR(v_rg23a_bal) ||
2483: ' IS less than the Modvat Amount ->' ||
2484: TO_CHAR(v_exempt_bal);

Line 2508: pv_return_code := jai_constants.expected_error;

2504:
2505: IF (v_register_balance < v_bond_tax_amount) AND
2506: (NVL(v_lou_flag, 'N') = 'N') THEN
2507:
2508: pv_return_code := jai_constants.expected_error;
2509: pv_return_message := 'Bonded Register Has Balance -> ' ||
2510: TO_CHAR(v_register_balance) ||
2511: ' ,which IS less than Excisable Amount -> ' ||
2512: TO_CHAR(v_bond_tax_amount);

Line 2518: pv_return_code := jai_constants.expected_error;

2514: END IF;
2515:
2516: IF (nvl(v_register_exp_date, sysdate) < Sysdate) THEN
2517:
2518: pv_return_code := jai_constants.expected_error;
2519: pv_return_message := 'Validity Date of the Bond Register has expired';
2520: return;
2521: END IF;
2522: ELSIF v_reg_code IN ('23D_DOMESTIC_EXCISE',

Line 2536: pv_return_code := jai_constants.expected_error;

2532: INTO v_matched_qty;
2533: CLOSE matched_qty_cur;
2534: IF NVL(v_matched_qty, 0) <> NVL(line_rec.quantity, 0) THEN
2535:
2536: pv_return_code := jai_constants.expected_error;
2537: pv_return_message := 'Matched Quantity -> ' ||
2538: TO_CHAR(v_matched_qty) ||
2539: ' , IS less than Invoiced Quantity -> ' ||
2540: TO_CHAR(line_rec.quantity) ||

Line 2555: pv_return_code := jai_constants.expected_error;

2551: IF NVL(v_rg23d_register_balance, 0) <
2552: NVL(v_rg23d_tax_amount, 0) and
2553: (NVL(v_lou_flag, 'N') = 'N') THEN
2554:
2555: pv_return_code := jai_constants.expected_error;
2556: pv_return_message := 'RG23D Bonded Register Has Balance -> ' ||
2557: TO_CHAR(v_rg23d_register_balance) ||
2558: ' ,which IS less than Excisable Amount -> ' ||
2559: TO_CHAR(v_rg23d_tax_amount);

Line 2565: pv_return_code := jai_constants.expected_error;

2561: END IF;
2562:
2563: IF (v_register_exp_date > Sysdate) THEN
2564:
2565: pv_return_code := jai_constants.expected_error;
2566: pv_return_message := 'Validity Date of the Bond Register has expired';
2567: return;
2568:
2569: END IF;

Line 2603: pv_return_code := jai_constants.expected_error;

2599: END IF;
2600:
2601: IF v_errbuf is not null THEN
2602:
2603: pv_return_code := jai_constants.expected_error;
2604: pv_return_message := 'Error During Excise Invoice Generation ! ' ||
2605: v_errbuf;
2606: return;
2607: END IF;

Line 2639: if lv_process_flag <> jai_constants.successful then

2635: p_trx_amount => ln_cess_amount,
2636: p_process_flag => lv_process_flag,
2637: p_process_message => lv_process_message);
2638:
2639: if lv_process_flag <> jai_constants.successful then
2640: lv_rg23a_cess_avlbl := 'FALSE';
2641: else
2642: lv_rg23a_cess_avlbl := 'TRUE';
2643: end if;

Line 2653: if lv_process_flag <> jai_constants.successful then

2649: p_trx_amount => ln_cess_amount,
2650: p_process_flag => lv_process_flag,
2651: p_process_message => lv_process_message);
2652:
2653: if lv_process_flag <> jai_constants.successful then
2654: lv_rg23c_cess_avlbl := 'FALSE';
2655: else
2656: lv_rg23c_cess_avlbl := 'TRUE';
2657: end if;

Line 2667: if lv_process_flag <> jai_constants.successful then

2663: p_trx_amount => ln_cess_amount,
2664: p_process_flag => lv_process_flag,
2665: p_process_message => lv_process_message);
2666:
2667: if lv_process_flag <> jai_constants.successful then
2668: lv_pla_cess_avlbl := 'FALSE';
2669: else
2670: lv_pla_cess_avlbl := 'TRUE';
2671: end if;

Line 2828: pv_return_code := jai_constants.expected_error;

2824: END IF;
2825:
2826: IF v_reg_type is null THEN
2827:
2828: pv_return_code := jai_constants.expected_error;
2829: pv_return_message := 'None of the registers have enough balance for the excise duty -> ' ||
2830: v_tax_amount ||
2831: ' Or Cess amount => ' ||
2832: ln_Cess_amount;

Line 2840: pv_return_code := jai_constants.expected_error;

2836: NVL(v_ssi_unit_flag, 'N') <> 'Y' THEN
2837: IF v_tax_amount > reg_balance.pla_balance AND
2838: lv_pla_cess_avlbl = 'TRUE' THEN
2839:
2840: pv_return_code := jai_constants.expected_error;
2841: pv_return_message := 'PLA Balance -> ' ||
2842: reg_balance.pla_balance ||
2843: ' is not enough for the excise duty -> ' ||
2844: v_tax_amount;

Line 2851: pv_return_code := jai_constants.expected_error;

2847: ELSIF v_reg_type = 'RG23A' THEN
2848: IF v_tax_amount > reg_balance.rg23a_balance AND
2849: lv_rg23a_cess_avlbl = 'TRUE' THEN
2850:
2851: pv_return_code := jai_constants.expected_error;
2852: pv_return_message := 'RG23A Balance -> ' ||
2853: reg_balance.rg23a_balance ||
2854: ' is not enough for the excise duty -> ' ||
2855: v_tax_amount;

Line 2862: pv_return_code := jai_constants.expected_error;

2858: ELSIF v_reg_type = 'RG23C' THEN
2859: IF v_tax_amount > reg_balance.rg23c_balance AND
2860: lv_rg23c_cess_avlbl = 'TRUE' THEN
2861:
2862: pv_return_code := jai_constants.expected_error;
2863: pv_return_message := 'RG23C Balance -> ' ||
2864: reg_balance.rg23c_balance ||
2865: ' is not enough for the excise duty -> ' ||
2866: v_tax_amount;

Line 2899: pv_return_code := jai_constants.expected_error;

2895:
2896: Exception
2897: When Others Then
2898:
2899: pv_return_code := jai_constants.expected_error;
2900: pv_return_message := SQLERRM;
2901: return;
2902: End;
2903:

Line 2980: pv_return_code := jai_constants.expected_error;

2976: IF v_reg_type = 'RG23A' THEN
2977: IF v_tax_amount > reg_balance.rg23a_balance AND
2978: lv_rg23a_cess_avlbl = 'TRUE' THEN
2979:
2980: pv_return_code := jai_constants.expected_error;
2981: pv_return_message := 'RG23A Balance -> ' ||
2982: reg_balance.rg23a_balance ||
2983: ' is not enough for the excise duty -> ' ||
2984: v_tax_amount;

Line 2991: pv_return_code := jai_constants.expected_error;

2987: ELSIF v_reg_type = 'RG23C' THEN
2988: IF v_tax_amount > reg_balance.rg23c_balance AND
2989: lv_rg23c_cess_avlbl = 'TRUE' THEN
2990:
2991: pv_return_code := jai_constants.expected_error;
2992: pv_return_message := 'RG23C Balance -> ' ||
2993: reg_balance.rg23c_balance ||
2994: ' is not enough for the excise duty -> ' ||
2995: v_tax_amount;

Line 3030: pv_return_code := jai_constants.expected_error;

3026:
3027: Exception
3028: When Others Then
3029:
3030: pv_return_code := jai_constants.expected_error;
3031: pv_return_message := SQLERRM;
3032: return;
3033: END;
3034:

Line 3104: lv_action := jai_constants.updating;

3100: close c_get_rec;
3101:
3102: if (t_rec_new.once_completed_flag = 'Y') then
3103:
3104: lv_action := jai_constants.updating;
3105:
3106: JAI_AR_TRXS_PKG.UPDATE_EXCISE_REGISTERS(pr_old => t_rec_old,
3107: pr_new => t_rec_new,
3108: pv_action => lv_action,

Line 3112: IF lv_return_code <> jai_constants.successful then

3108: pv_action => lv_action,
3109: pv_return_code => lv_return_code,
3110: pv_return_message => lv_return_message);
3111:
3112: IF lv_return_code <> jai_constants.successful then
3113: RAISE le_error;
3114: END IF;
3115:
3116: end if;

Line 3155: ln_regime_code := jai_constants.vat_regime;

3151: INTO ln_regime_id;
3152: CLOSE c_get_regime_id;
3153:
3154: IF ln_regime_id IS NOT NULL THEN
3155: ln_regime_code := jai_constants.vat_regime;
3156: END IF;
3157: END IF;
3158: END IF;
3159:

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

3156: END IF;
3157: END IF;
3158: END IF;
3159:
3160: IF UPPER(nvl(ln_regime_code, '####')) = jai_constants.vat_regime THEN
3161:
3162: OPEN cur_get_same_inv_no(cp_organization_id => v_org_id,
3163: cp_location_id => v_loc_id);
3164: FETCH cur_get_same_inv_no

Line 3197: IF lv_process_flag = jai_constants.expected_error OR

3193: p_invoice_number => lv_vat_invoice_number,
3194: p_process_flag => lv_process_flag,
3195: p_process_msg => lv_process_message);
3196:
3197: IF lv_process_flag = jai_constants.expected_error OR
3198: lv_process_flag = jai_constants.unexpected_error THEN
3199: CLOSE cur_vat_taxes_exist;
3200:
3201: pv_return_code := jai_constants.expected_error;

Line 3198: lv_process_flag = jai_constants.unexpected_error THEN

3194: p_process_flag => lv_process_flag,
3195: p_process_msg => lv_process_message);
3196:
3197: IF lv_process_flag = jai_constants.expected_error OR
3198: lv_process_flag = jai_constants.unexpected_error THEN
3199: CLOSE cur_vat_taxes_exist;
3200:
3201: pv_return_code := jai_constants.expected_error;
3202: pv_return_message := lv_process_message;

Line 3201: pv_return_code := jai_constants.expected_error;

3197: IF lv_process_flag = jai_constants.expected_error OR
3198: lv_process_flag = jai_constants.unexpected_error THEN
3199: CLOSE cur_vat_taxes_exist;
3200:
3201: pv_return_code := jai_constants.expected_error;
3202: pv_return_message := lv_process_message;
3203: return;
3204:
3205: END IF;

Line 3214: p_source => jai_constants.source_ar,

3210: INTO ld_gl_date;
3211: CLOSE cur_get_gl_date;
3212:
3213: jai_cmn_rgm_vat_accnt_pkg.process_order_invoice(p_regime_id => ln_regime_id,
3214: p_source => jai_constants.source_ar,
3215: p_organization_id => v_org_id,
3216: p_location_id => v_loc_id,
3217: p_delivery_id => NULL,
3218: p_customer_trx_id => pr_new.customer_trx_id,

Line 3224: p_called_from => jai_constants.vat_repo_call_inv_comp,

3220: p_vat_invoice_no => lv_vat_invoice_number,
3221: p_default_invoice_date => nvl(ld_gl_date,
3222: pr_new.trx_date),
3223: p_batch_id => NULL,
3224: p_called_from => jai_constants.vat_repo_call_inv_comp,
3225: p_debug => jai_constants.no,
3226: p_process_flag => lv_process_flag,
3227: p_process_message => lv_process_message);
3228:

Line 3225: p_debug => jai_constants.no,

3221: p_default_invoice_date => nvl(ld_gl_date,
3222: pr_new.trx_date),
3223: p_batch_id => NULL,
3224: p_called_from => jai_constants.vat_repo_call_inv_comp,
3225: p_debug => jai_constants.no,
3226: p_process_flag => lv_process_flag,
3227: p_process_message => lv_process_message);
3228:
3229: IF lv_process_flag = jai_constants.expected_error OR

Line 3229: IF lv_process_flag = jai_constants.expected_error OR

3225: p_debug => jai_constants.no,
3226: p_process_flag => lv_process_flag,
3227: p_process_message => lv_process_message);
3228:
3229: IF lv_process_flag = jai_constants.expected_error OR
3230: lv_process_flag = jai_constants.unexpected_error THEN
3231: CLOSE cur_vat_taxes_exist;
3232:
3233: pv_return_code := jai_constants.expected_error;

Line 3230: lv_process_flag = jai_constants.unexpected_error THEN

3226: p_process_flag => lv_process_flag,
3227: p_process_message => lv_process_message);
3228:
3229: IF lv_process_flag = jai_constants.expected_error OR
3230: lv_process_flag = jai_constants.unexpected_error THEN
3231: CLOSE cur_vat_taxes_exist;
3232:
3233: pv_return_code := jai_constants.expected_error;
3234: pv_return_message := lv_process_message;

Line 3233: pv_return_code := jai_constants.expected_error;

3229: IF lv_process_flag = jai_constants.expected_error OR
3230: lv_process_flag = jai_constants.unexpected_error THEN
3231: CLOSE cur_vat_taxes_exist;
3232:
3233: pv_return_code := jai_constants.expected_error;
3234: pv_return_message := lv_process_message;
3235: return;
3236:
3237: END IF;

Line 3262: lv_action := jai_constants.updating;

3258: close c_get_rec;
3259:
3260: if (t_rec_new.once_completed_flag = 'Y') then
3261:
3262: lv_action := jai_constants.updating;
3263:
3264: JAI_AR_TRXS_PKG.UPDATE_EXCISE_REGISTERS(pr_old => t_rec_old,
3265: pr_new => t_rec_new,
3266: pv_action => lv_action,

Line 3270: IF lv_return_code <> jai_constants.successful then

3266: pv_action => lv_action,
3267: pv_return_code => lv_return_code,
3268: pv_return_message => lv_return_message);
3269:
3270: IF lv_return_code <> jai_constants.successful then
3271: RAISE le_error;
3272: END IF;
3273:
3274: end if;

Line 3290: Pv_return_code := jai_constants.unexpected_error;

3286: G_PACKAGE_NAME || ':' || lv_api_name || '.END()-');
3287: END IF;
3288: EXCEPTION
3289: WHEN OTHERS THEN
3290: Pv_return_code := jai_constants.unexpected_error;
3291: Pv_return_message := 'Encountered an error in ' || G_PACKAGE_NAME || '.' ||
3292: lv_api_name || ' ' || substr(sqlerrm, 1, 1900);
3293:
3294: END PROCESS_EXCISE_TAXES;

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

3316: G_MODULE_NAME || lv_api_name,
3317: G_PACKAGE_NAME || ':' || lv_api_name || '.BEGIN()+');
3318: END IF;
3319: V_HEADER_ID := PR_NEW.CUSTOMER_TRX_ID;
3320: IF NVL(PR_NEW.COMPLETE_FLAG, JAI_CONSTANTS.NO) = JAI_CONSTANTS.YES THEN
3321: LV_DOCUMENT_TYPE := JAI_CONSTANTS.TRX_TYPE_INV_COMP;
3322:
3323: OPEN ONCE_COMPLETE_FLAG_CUR;
3324: FETCH ONCE_COMPLETE_FLAG_CUR

Line 3321: LV_DOCUMENT_TYPE := JAI_CONSTANTS.TRX_TYPE_INV_COMP;

3317: G_PACKAGE_NAME || ':' || lv_api_name || '.BEGIN()+');
3318: END IF;
3319: V_HEADER_ID := PR_NEW.CUSTOMER_TRX_ID;
3320: IF NVL(PR_NEW.COMPLETE_FLAG, JAI_CONSTANTS.NO) = JAI_CONSTANTS.YES THEN
3321: LV_DOCUMENT_TYPE := JAI_CONSTANTS.TRX_TYPE_INV_COMP;
3322:
3323: OPEN ONCE_COMPLETE_FLAG_CUR;
3324: FETCH ONCE_COMPLETE_FLAG_CUR
3325: INTO LV_ONCE_COMPLETED_FLAG;

Line 3329: lv_once_completed_flag = jai_constants.yes THEN

3325: INTO LV_ONCE_COMPLETED_FLAG;
3326: CLOSE ONCE_COMPLETE_FLAG_CUR;
3327:
3328: IF Pr_new.created_from <> 'RAXTRX' AND
3329: lv_once_completed_flag = jai_constants.yes THEN
3330:
3331: JAI_AR_TCS_REP_PKG.AR_ACCOUNTING(P_RACT => PR_NEW,
3332: P_PROCESS_FLAG => PV_RETURN_CODE,
3333: P_PROCESS_MESSAGE => PV_RETURN_MESSAGE);

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

3333: P_PROCESS_MESSAGE => PV_RETURN_MESSAGE);
3334:
3335: END IF;
3336:
3337: ELSIF NVL(PR_NEW.COMPLETE_FLAG, JAI_CONSTANTS.NO) = JAI_CONSTANTS.NO THEN
3338: LV_DOCUMENT_TYPE := JAI_CONSTANTS.TRX_TYPE_INV_INCOMP;
3339: END IF;
3340:
3341: JAI_AR_TCS_REP_PKG.PROCESS_TRANSACTIONS(P_RACT => PR_NEW,

Line 3338: LV_DOCUMENT_TYPE := JAI_CONSTANTS.TRX_TYPE_INV_INCOMP;

3334:
3335: END IF;
3336:
3337: ELSIF NVL(PR_NEW.COMPLETE_FLAG, JAI_CONSTANTS.NO) = JAI_CONSTANTS.NO THEN
3338: LV_DOCUMENT_TYPE := JAI_CONSTANTS.TRX_TYPE_INV_INCOMP;
3339: END IF;
3340:
3341: JAI_AR_TCS_REP_PKG.PROCESS_TRANSACTIONS(P_RACT => PR_NEW,
3342: P_EVENT => JAI_CONSTANTS.TRX_EVENT_COMPLETION,

Line 3342: P_EVENT => JAI_CONSTANTS.TRX_EVENT_COMPLETION,

3338: LV_DOCUMENT_TYPE := JAI_CONSTANTS.TRX_TYPE_INV_INCOMP;
3339: END IF;
3340:
3341: JAI_AR_TCS_REP_PKG.PROCESS_TRANSACTIONS(P_RACT => PR_NEW,
3342: P_EVENT => JAI_CONSTANTS.TRX_EVENT_COMPLETION,
3343: P_PROCESS_FLAG => PV_RETURN_CODE,
3344: P_PROCESS_MESSAGE => PV_RETURN_MESSAGE);
3345:
3346: IF PV_RETURN_CODE <> JAI_CONSTANTS.SUCCESSFUL THEN

Line 3346: IF PV_RETURN_CODE <> JAI_CONSTANTS.SUCCESSFUL THEN

3342: P_EVENT => JAI_CONSTANTS.TRX_EVENT_COMPLETION,
3343: P_PROCESS_FLAG => PV_RETURN_CODE,
3344: P_PROCESS_MESSAGE => PV_RETURN_MESSAGE);
3345:
3346: IF PV_RETURN_CODE <> JAI_CONSTANTS.SUCCESSFUL THEN
3347: RETURN;
3348: END IF;
3349: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3350: FND_LOG.STRING(G_LEVEL_PROCEDURE,

Line 3356: Pv_return_code := jai_constants.unexpected_error;

3352: G_PACKAGE_NAME || ':' || lv_api_name || '.END()-');
3353: END IF;
3354: EXCEPTION
3355: WHEN OTHERS THEN
3356: Pv_return_code := jai_constants.unexpected_error;
3357: Pv_return_message := 'Encountered an error in ' || G_PACKAGE_NAME || '.' ||
3358: lv_api_name || ' ' || substr(sqlerrm, 1, 1900);
3359: END PROCESS_TCS_TAXES;
3360: END JAI_AR_TRX_HEADERS_PKG;