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

Line 480: and jrlt.tax_type not in (jai_constants.tax_type_tds,jai_constants.tax_type_modvat_recovery) --'TDS', 'Modvat Recovery')

476: )
477: )
478: and jrt.third_party_flag = 'N'
479: )
480: and jrlt.tax_type not in (jai_constants.tax_type_tds,jai_constants.tax_type_modvat_recovery) --'TDS', 'Modvat Recovery')
481: and jrlt.vendor_id > 0
482: and jrlt.tax_amount <> 0
483: and jrlt.tax_amount <> 0
484: and jrlt.vendor_id <> p_po_vendor_id;

Line 513: and jrlt.tax_type not in (jai_constants.tax_type_tds,jai_constants.tax_type_modvat_recovery) --'TDS', 'Modvat Recovery')

509: )
510: )
511: and jrt.third_party_flag = 'N'
512: )
513: and jrlt.tax_type not in (jai_constants.tax_type_tds,jai_constants.tax_type_modvat_recovery) --'TDS', 'Modvat Recovery')
514: and jrlt.vendor_id > 0
515: and jrlt.tax_amount <> 0
516: and jrlt.vendor_id <> p_po_vendor_id
517: and jrlt.vendor_site_id is null;

Line 547: and jrlt.tax_type not in (jai_constants.tax_type_tds,jai_constants.tax_type_modvat_recovery) --'TDS', 'Modvat Recovery')

543: )
544: )
545: and jrt.third_party_flag = 'N'
546: )
547: and jrlt.tax_type not in (jai_constants.tax_type_tds,jai_constants.tax_type_modvat_recovery) --'TDS', 'Modvat Recovery')
548: and jrlt.vendor_id > 0
549: and jrlt.tax_amount <> 0
550: and jrlt.vendor_id <> p_po_vendor_id
551: and jrlt.vendor_site_id is not null

Line 726: and jrtv.tax_type not in (jai_constants.tax_type_tds,jai_constants.tax_type_modvat_recovery) --'TDS', 'Modvat Recovery')

722: )
723: and third_party_flag = 'N'
724:
725: )
726: and jrtv.tax_type not in (jai_constants.tax_type_tds,jai_constants.tax_type_modvat_recovery) --'TDS', 'Modvat Recovery')
727: and jrtv.vendor_id > 0
728: and nvl(jrtv.tax_amount, 0) is not null
729: and jrtv.shipment_header_id = pn_shipment_header_id
730: and jrtv.tax_id = jcta.tax_id

Line 937: and jrtv.tax_type not in (jai_constants.tax_type_tds,jai_constants.tax_type_modvat_recovery) --'TDS', 'Modvat Recovery')

933: )
934: and third_party_flag = 'N'
935:
936: )
937: and jrtv.tax_type not in (jai_constants.tax_type_tds,jai_constants.tax_type_modvat_recovery) --'TDS', 'Modvat Recovery')
938: and jrtv.vendor_id > 0
939: and nvl(jrtv.tax_amount, 0) is not null
940: and jrtv.vendor_id <> r_rcv_transactions.vendor_id /* bug#3957167 */
941: and jrtv.shipment_header_id = p_shipment_header_id

Line 1110: AND jrlt.tax_type NOT IN (jai_constants.tax_type_tds,jai_constants.tax_type_modvat_recovery)

1106: AND jrt.shipment_line_id = jrlt.shipment_line_id
1107: AND jrt.shipment_header_id = p_shipment_header_id
1108: AND ( jrt.transaction_type = lv_ttype_receive OR (jrt.transaction_type = lv_ttype_correct AND jrt.parent_transaction_type = lv_ttype_receive ) )
1109: AND jrt.third_party_flag = 'N'
1110: AND jrlt.tax_type NOT IN (jai_constants.tax_type_tds,jai_constants.tax_type_modvat_recovery)
1111: AND jrlt.vendor_id > 0
1112: AND NVL(jrlt.tax_amount, 0) IS NOT NULL
1113: AND jrlt.vendor_id <> r_rcv_transactions.vendor_id
1114: AND jrlt.vendor_id = c_thirdparty_tax_rec.vendor_id

Line 1408: AND jrlt.tax_type NOT IN (jai_constants.tax_type_tds,jai_constants.tax_type_modvat_recovery) --'TDS', 'Modvat Recovery')

1404: )
1405: )
1406: AND jrt.third_party_flag = 'N'
1407: )
1408: AND jrlt.tax_type NOT IN (jai_constants.tax_type_tds,jai_constants.tax_type_modvat_recovery) --'TDS', 'Modvat Recovery')
1409: AND jrlt.vendor_id > 0
1410: AND nvl(jrlt.tax_amount, 0) IS NOT NULL
1411: AND jrlt.vendor_id <> r_rcv_transactions.vendor_id
1412: AND jrlt.vendor_id = c_thirdparty_tax_rec.vendor_id

Line 1545: OPEN c_jai_regimes(jai_constants.service_regime); /* SERVICE */

1541: OPEN c_trx_dtls(Tax_rec.transaction_id);
1542: FETCH c_trx_dtls INTO r_trx_dtls;
1543: CLOSE c_trx_dtls;
1544:
1545: OPEN c_jai_regimes(jai_constants.service_regime); /* SERVICE */
1546: FETCH c_jai_regimes INTO ln_regime_id;
1547: CLOSE c_jai_regimes;
1548:
1549: ln_accrue_on_receipt_flag := jai_rcv_trx_processing_pkg.get_accrue_on_receipt

Line 1560: p_organization_type => jai_constants.orgn_type_io,

1556:
1557: ln_accrual_account := jai_cmn_rgm_recording_pkg.get_account
1558: (
1559: p_regime_id => ln_regime_id,
1560: p_organization_type => jai_constants.orgn_type_io,
1561: p_organization_id => r_trx_dtls.ship_to_organization_id,
1562: p_location_id => r_trx_dtls.ship_to_location_id,
1563: p_tax_type => tax_rec.tax_type,
1564: p_account_name => jai_constants.recovery_interim

Line 1564: p_account_name => jai_constants.recovery_interim

1560: p_organization_type => jai_constants.orgn_type_io,
1561: p_organization_id => r_trx_dtls.ship_to_organization_id,
1562: p_location_id => r_trx_dtls.ship_to_location_id,
1563: p_tax_type => tax_rec.tax_type,
1564: p_account_name => jai_constants.recovery_interim
1565: );
1566:
1567: Fnd_File.put_line(Fnd_File.LOG, 'Interim Acct CCID for the Transaction id ' || Tax_rec.transaction_id ||' is: '||ln_accrual_account);
1568: END IF;

Line 1666: p_process_flag := jai_constants.successful;

1662: WHERE invoice_num = p_invoice_num
1663: AND vendor_id = p_vendor_id
1664: AND vendor_site_id = p_vendor_site_id;
1665:
1666: p_process_flag := jai_constants.successful;
1667:
1668: EXCEPTION
1669: WHEN OTHERS THEN
1670: p_process_flag := jai_constants.unexpected_error;

Line 1670: p_process_flag := jai_constants.unexpected_error;

1666: p_process_flag := jai_constants.successful;
1667:
1668: EXCEPTION
1669: WHEN OTHERS THEN
1670: p_process_flag := jai_constants.unexpected_error;
1671: p_process_message := substr(sqlerrm,1,1000);
1672:
1673: END;
1674: