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

Line 144: pv_return_code := jai_constants.successful;

140: G_MODULE_NAME || lv_api_name,
141: G_PACKAGE_NAME || ':' || lv_api_name || '.BEGIN()+');
142: END IF;
143:
144: pv_return_code := jai_constants.successful;
145: v_header_id := pr_new.customer_trx_id;
146: v_inventory_item_id := pr_new.inventory_item_id;
147: v_line_amount := nvl(NVL(pr_new.quantity_credited,
148: pr_new.quantity_invoiced) *

Line 264: lv_action := JAI_CONSTANTS.INSERTING;

260: FETCH c_jai_ar_trx_lines
261: INTO t_jai_line_rec_new;
262: CLOSE c_jai_ar_trx_lines;
263:
264: lv_action := JAI_CONSTANTS.INSERTING;
265: JAI_AR_TAX_LINES_PKG.POPULATE_TAX_LINES_WRAPPER(pr_old => t_jai_line_rec_old,
266: pr_new => t_jai_line_rec_new,
267: pv_action => lv_action,
268: pv_return_code => lv_return_code,

Line 270: IF PV_RETURN_CODE <> JAI_CONSTANTS.successful THEN

266: pr_new => t_jai_line_rec_new,
267: pv_action => lv_action,
268: pv_return_code => lv_return_code,
269: pv_return_message => lv_return_message);
270: IF PV_RETURN_CODE <> JAI_CONSTANTS.successful THEN
271: RAISE le_error;
272: END IF;
273:
274: Update JAI_AR_TRXS

Line 359: lv_action := JAI_CONSTANTS.UPDATING;

355: OPEN c_jai_ar_trx_lines(v_link_to_cust_id);
356: FETCH c_jai_ar_trx_lines
357: INTO t_jai_line_rec_new;
358: CLOSE c_jai_ar_trx_lines;
359: lv_action := JAI_CONSTANTS.UPDATING;
360: IF (((t_jai_line_rec_new.AUTO_INVOICE_FLAG <> 'Y' AND
361: t_jai_line_rec_old.AUTO_INVOICE_FLAG <> 'Y') AND
362: (t_jai_line_rec_new.Excise_Invoice_No IS NULL) AND
363: (t_jai_line_rec_new.payment_Register IS NULL) AND

Line 373: IF lv_return_code <> jai_constants.successful then

369: pv_action => lv_action,
370: pv_return_code => lv_return_code,
371: pv_return_message => lv_return_message);
372:
373: IF lv_return_code <> jai_constants.successful then
374: RAISE le_error;
375: END IF;
376: END IF;
377: END LOOP;

Line 386: Pv_return_code := jai_constants.unexpected_error;

382: G_PACKAGE_NAME || ':' || lv_api_name || '.END()-');
383: END IF;
384: EXCEPTION
385: WHEN OTHERS THEN
386: Pv_return_code := jai_constants.unexpected_error;
387: Pv_return_message := 'Encountered an error in ' || G_PACKAGE_NAME || '.' ||
388: lv_api_name || ' ' || substr(sqlerrm, 1, 1900);
389: IF G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL THEN
390: FND_LOG.STRING(G_LEVEL_UNEXPECTED,

Line 474: and account_class = jai_constants.account_class_rec

470: cursor c_gl_dist_date(cp_customer_trx_id ra_customer_trx_all.customer_trx_id%type) is
471: select gl_date
472: from ra_cust_trx_line_gl_dist_all
473: where customer_trx_id = cp_customer_trx_id
474: and account_class = jai_constants.account_class_rec
475: and latest_rec_flag = jai_constants.yes;
476:
477: CURSOR GC_GET_REGIME_ID(CP_REGIME_CODE JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE) IS
478: SELECT REGIME_ID

Line 475: and latest_rec_flag = jai_constants.yes;

471: select gl_date
472: from ra_cust_trx_line_gl_dist_all
473: where customer_trx_id = cp_customer_trx_id
474: and account_class = jai_constants.account_class_rec
475: and latest_rec_flag = jai_constants.yes;
476:
477: CURSOR GC_GET_REGIME_ID(CP_REGIME_CODE JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE) IS
478: SELECT REGIME_ID
479: FROM JAI_RGM_DEFINITIONS

Line 596: pv_return_code := jai_constants.successful;

592: G_MODULE_NAME || lv_api_name,
593: G_PACKAGE_NAME || ':' || lv_api_name || '.BEGIN()+');
594: END IF;
595:
596: pv_return_code := jai_constants.successful;
597: v_header_id := pr_new.customer_trx_id;
598: v_inventory_item_id := pr_new.inventory_item_id;
599: v_item_class := 'N';
600: v_uom_code := pr_new.uom_code;

Line 734: open gc_chk_rgm_tax_exists(cp_regime_code => jai_constants.tcs_regime,

730: v_inventory_item_id,
731: v_tax_category_id);
732: END IF;
733:
734: open gc_chk_rgm_tax_exists(cp_regime_code => jai_constants.tcs_regime,
735: cp_rgm_tax_type => jai_constants.tax_type_tcs,
736: cp_tax_category_id => v_tax_category_id);
737: fetch gc_chk_rgm_tax_exists
738: into ln_tcs_exists;

Line 735: cp_rgm_tax_type => jai_constants.tax_type_tcs,

731: v_tax_category_id);
732: END IF;
733:
734: open gc_chk_rgm_tax_exists(cp_regime_code => jai_constants.tcs_regime,
735: cp_rgm_tax_type => jai_constants.tax_type_tcs,
736: cp_tax_category_id => v_tax_category_id);
737: fetch gc_chk_rgm_tax_exists
738: into ln_tcs_exists;
739: close gc_chk_rgm_tax_exists;

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

789: c_conversion_rate);
790: v_line_tax_amount := nvl(v_line_amount, 0);
791:
792: If v_num_check = 1 then
793: open gc_get_regime_id(cp_regime_code => jai_constants.tcs_regime);
794: fetch gc_get_regime_id
795: into ln_tcs_regime_id;
796: close gc_get_regime_id;
797:

Line 800: p_party_type => jai_constants.party_type_customer,

796: close gc_get_regime_id;
797:
798: jai_rgm_thhold_proc_pkg.get_threshold_slab_id(p_regime_id => ln_tcs_regime_id,
799: p_organization_id => v_organization_id,
800: p_party_type => jai_constants.party_type_customer,
801: p_party_id => v_customer_id,
802: p_org_id => v_org_id,
803: p_source_trx_date => ld_trx_date,
804: p_threshold_slab_id => ln_threshold_slab_id,

Line 808: if lv_process_flag <> jai_constants.successful then

804: p_threshold_slab_id => ln_threshold_slab_id,
805: p_process_flag => lv_process_flag,
806: p_process_message => lv_process_message);
807:
808: if lv_process_flag <> jai_constants.successful then
809: app_exception.raise_exception(exception_type => 'APP',
810: exception_code => -20275,
811: exception_text => lv_process_message);
812: end if;

Line 820: if lv_process_flag <> jai_constants.successful then

816: p_org_id => v_org_id,
817: p_threshold_tax_cat_id => ln_threshold_tax_cat_id,
818: p_process_flag => lv_process_flag,
819: p_process_message => lv_process_message);
820: if lv_process_flag <> jai_constants.successful then
821: app_exception.raise_exception(exception_type => 'APP',
822: exception_code => -20275,
823: exception_text => lv_process_message);
824: end if;

Line 847: p_thhold_cat_base_tax_typ => jai_constants.tax_type_tcs,

843: v_last_updated_by,
844: v_last_update_login,
845: NULL,
846: ln_vat_assessable_value,
847: p_thhold_cat_base_tax_typ => jai_constants.tax_type_tcs,
848: p_threshold_tax_cat_id => ln_threshold_tax_cat_id,
849: p_source_trx_type => null,
850: p_source_table_name => null,
851: p_action => jai_constants.default_taxes);

Line 851: p_action => jai_constants.default_taxes);

847: p_thhold_cat_base_tax_typ => jai_constants.tax_type_tcs,
848: p_threshold_tax_cat_id => ln_threshold_tax_cat_id,
849: p_source_trx_type => null,
850: p_source_table_name => null,
851: p_action => jai_constants.default_taxes);
852: END IF;
853: v_excise := 0;
854: v_additional := 0;
855: v_other := 0;

Line 945: lv_action := JAI_CONSTANTS.INSERTING;

941: FETCH c_jai_ar_trx_lines
942: INTO t_jai_line_rec_new;
943: CLOSE c_jai_ar_trx_lines;
944:
945: lv_action := JAI_CONSTANTS.INSERTING;
946: JAI_AR_TAX_LINES_PKG.POPULATE_TAX_LINES_WRAPPER(pr_old => t_jai_line_rec_old,
947: pr_new => t_jai_line_rec_new,
948: pv_action => lv_action,
949: pv_return_code => lv_return_code,

Line 951: IF PV_RETURN_CODE <> JAI_CONSTANTS.successful THEN

947: pr_new => t_jai_line_rec_new,
948: pv_action => lv_action,
949: pv_return_code => lv_return_code,
950: pv_return_message => lv_return_message);
951: IF PV_RETURN_CODE <> JAI_CONSTANTS.successful THEN
952: RAISE le_error;
953: END IF;
954: END IF;
955:

Line 963: Pv_return_code := jai_constants.unexpected_error;

959: G_PACKAGE_NAME || ':' || lv_api_name || '.END()-');
960: END IF;
961: EXCEPTION
962: WHEN OTHERS THEN
963: Pv_return_code := jai_constants.unexpected_error;
964: Pv_return_message := SUBSTR('Encountered an error in ' ||
965: G_PACKAGE_NAME || '.' || lv_api_name || ' ' ||
966: sqlerrm,
967: 1,

Line 1012: IF pv_party_type = jai_constants.party_type_customer THEN

1008: ||passed as parameters.
1009: */
1010:
1011: BEGIN
1012: IF pv_party_type = jai_constants.party_type_customer THEN
1013:
1014: OPEN c_get_address;
1015: FETCH c_get_address
1016: INTO ln_address_id;

Line 1033: ELSIF pv_party_type = jai_constants.party_type_vendor THEN

1029: CLOSE cur_get_ser_type_customer;
1030:
1031: END IF;
1032:
1033: ELSIF pv_party_type = jai_constants.party_type_vendor THEN
1034:
1035: OPEN cur_get_ser_type_vendor(pn_party_id, pn_party_site_id);
1036: FETCH cur_get_ser_type_vendor
1037: INTO v_service_type;

Line 1169: pv_return_code := jai_constants.successful;

1165: G_MODULE_NAME || lv_api_name,
1166: G_PACKAGE_NAME || ':' || lv_api_name || '.BEGIN()+');
1167: END IF;
1168:
1169: pv_return_code := jai_constants.successful;
1170:
1171: v_header_id := pr_old.customer_trx_id;
1172: v_inventory_item_id := pr_new.inventory_item_id;
1173: v_item_class := 'N';

Line 1344: lv_action := JAI_CONSTANTS.UPDATING;

1340: OPEN c_jai_ar_trx_lines(pr_old.customer_trx_line_id);
1341: FETCH c_jai_ar_trx_lines
1342: INTO t_jai_line_rec_new;
1343: CLOSE c_jai_ar_trx_lines;
1344: lv_action := JAI_CONSTANTS.UPDATING;
1345: IF (((t_jai_line_rec_new.AUTO_INVOICE_FLAG <> 'Y' AND
1346: t_jai_line_rec_old.AUTO_INVOICE_FLAG <> 'Y') AND
1347: (t_jai_line_rec_new.Excise_Invoice_No IS NULL) AND
1348: (t_jai_line_rec_new.payment_Register IS NULL) AND

Line 1358: IF lv_return_code <> jai_constants.successful then

1354: pv_action => lv_action,
1355: pv_return_code => lv_return_code,
1356: pv_return_message => lv_return_message);
1357:
1358: IF lv_return_code <> jai_constants.successful then
1359: RAISE le_error;
1360: END IF;
1361: END IF;
1362: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1369: Pv_return_code := jai_constants.unexpected_error;

1365: G_PACKAGE_NAME || ':' || lv_api_name || '.END()-');
1366: END IF;
1367: EXCEPTION
1368: WHEN OTHERS THEN
1369: Pv_return_code := jai_constants.unexpected_error;
1370: Pv_return_message := 'Encountered an error in ' || G_MODULE_NAME || '.' ||
1371: lv_api_name || substr(sqlerrm, 1, 1900);
1372: END RECALCULATE_TAX_FOR_DM;
1373:

Line 1526: pv_return_code := jai_constants.successful;

1522: G_MODULE_NAME || lv_api_name,
1523: G_PACKAGE_NAME || ':' || lv_api_name || '.BEGIN()+');
1524: END IF;
1525:
1526: pv_return_code := jai_constants.successful;
1527: v_header_id := pr_old.customer_trx_id;
1528: v_inventory_item_id := pr_new.inventory_item_id;
1529: v_item_class := 'N';
1530: v_uom_code := pr_new.uom_code;

Line 1741: lv_action := JAI_CONSTANTS.UPDATING;

1737: OPEN c_jai_ar_trx_lines(pr_old.customer_trx_line_id);
1738: FETCH c_jai_ar_trx_lines
1739: INTO t_jai_line_rec_new;
1740: CLOSE c_jai_ar_trx_lines;
1741: lv_action := JAI_CONSTANTS.UPDATING;
1742: IF (((t_jai_line_rec_new.AUTO_INVOICE_FLAG <> 'Y' AND
1743: t_jai_line_rec_old.AUTO_INVOICE_FLAG <> 'Y') AND
1744: (t_jai_line_rec_new.Excise_Invoice_No IS NULL) AND
1745: (t_jai_line_rec_new.payment_Register IS NULL) AND

Line 1756: IF lv_return_code <> jai_constants.successful then

1752: pv_action => lv_action,
1753: pv_return_code => lv_return_code,
1754: pv_return_message => lv_return_message);
1755:
1756: IF lv_return_code <> jai_constants.successful then
1757: RAISE le_error;
1758: END IF;
1759: END IF;
1760: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1767: Pv_return_code := jai_constants.unexpected_error;

1763: G_PACKAGE_NAME || ':' || lv_api_name || '.END()-');
1764: END IF;
1765: EXCEPTION
1766: WHEN OTHERS THEN
1767: Pv_return_code := jai_constants.unexpected_error;
1768: Pv_return_message := 'Encountered an error in ' || G_MODULE_NAME || '.' ||
1769: lv_api_name || substr(sqlerrm, 1, 1900);
1770: END RECALCULATE_TAX_FOR_INV_CM;
1771:

Line 1818: pv_return_code := jai_constants.successful;

1814: FND_LOG.STRING(G_LEVEL_PROCEDURE,
1815: G_MODULE_NAME || lv_api_name,
1816: G_PACKAGE_NAME || ':' || lv_api_name || '.BEGIN()+');
1817: END IF;
1818: pv_return_code := jai_constants.successful;
1819: v_customer_trx_line_id := pr_old.CUSTOMER_TRX_LINE_ID;
1820: v_customer_trx_id := pr_old.CUSTOMER_TRX_ID;
1821:
1822: FOR excise_cal_rec in excise_cal_cur LOOP

Line 1871: Pv_return_code := jai_constants.unexpected_error;

1867: G_PACKAGE_NAME || ':' || lv_api_name || '.END()-');
1868: END IF;
1869: EXCEPTION
1870: WHEN OTHERS THEN
1871: Pv_return_code := jai_constants.unexpected_error;
1872: Pv_return_message := 'Encountered an error in ' || G_MODULE_NAME || '.' ||
1873: lv_api_name || ':' || substr(sqlerrm, 1, 1900);
1874:
1875: END DELETE_AR_TRX_LINES;