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

Line 328: pv_return_code := jai_constants.successful;

324: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
325: lv_debug_info := 'JAI_AR_TAX_LINES_PKG.POPULATE_TAX_LINES_TEMP.BEGIN';
326: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME || lv_api_name,lv_debug_info);
327: END IF;
328: pv_return_code := jai_constants.successful;
329: /*------------------------------------------------------------------------------------------
330: FILENAME: jai_ar_tax_lines.plb
331: CHANGE HISTORY:
332: S.No Date Author and Details

Line 513: jai_constants.tax_type_sh_exc_edu_cess,

509: 'ADDL. EXCISE',
510: 'OTHER EXCISE',
511: 'EXCISE_EDUCATION_CESS',
512: 'CVD_EDUCATION_CESS',
513: jai_constants.tax_type_sh_exc_edu_cess,
514: jai_constants.tax_type_sh_cvd_edu_cess) THEN
515: TAX_TYPE_REC.tax_amt := 0;
516: END IF;
517: END IF;

Line 514: jai_constants.tax_type_sh_cvd_edu_cess) THEN

510: 'OTHER EXCISE',
511: 'EXCISE_EDUCATION_CESS',
512: 'CVD_EDUCATION_CESS',
513: jai_constants.tax_type_sh_exc_edu_cess,
514: jai_constants.tax_type_sh_cvd_edu_cess) THEN
515: TAX_TYPE_REC.tax_amt := 0;
516: END IF;
517: END IF;
518:

Line 534: upper(jai_constants.tax_type_service) OR

530: INTO ln_regime_id, ln_regime_code;
531: CLOSE cur_chk_rgm;
532:
533: IF upper(tax_type_rec.t_type) =
534: upper(jai_constants.tax_type_service) OR
535: upper(tax_type_rec.t_type) =
536: upper(jai_constants.tax_type_service_edu_cess) OR
537: upper(tax_type_rec.t_type) =
538: upper(jai_constants.tax_type_sh_service_edu_cess) THEN

Line 536: upper(jai_constants.tax_type_service_edu_cess) OR

532:
533: IF upper(tax_type_rec.t_type) =
534: upper(jai_constants.tax_type_service) OR
535: upper(tax_type_rec.t_type) =
536: upper(jai_constants.tax_type_service_edu_cess) OR
537: upper(tax_type_rec.t_type) =
538: upper(jai_constants.tax_type_sh_service_edu_cess) THEN
539:
540: jai_ar_rgm_processing_pkg.get_regime_info(p_regime_code => jai_constants.service_regime,

Line 538: upper(jai_constants.tax_type_sh_service_edu_cess) THEN

534: upper(jai_constants.tax_type_service) OR
535: upper(tax_type_rec.t_type) =
536: upper(jai_constants.tax_type_service_edu_cess) OR
537: upper(tax_type_rec.t_type) =
538: upper(jai_constants.tax_type_sh_service_edu_cess) THEN
539:
540: jai_ar_rgm_processing_pkg.get_regime_info(p_regime_code => jai_constants.service_regime,
541: p_tax_type_code => tax_type_rec.t_type,
542: p_regime_id => ln_regime_id,

Line 540: jai_ar_rgm_processing_pkg.get_regime_info(p_regime_code => jai_constants.service_regime,

536: upper(jai_constants.tax_type_service_edu_cess) OR
537: upper(tax_type_rec.t_type) =
538: upper(jai_constants.tax_type_sh_service_edu_cess) THEN
539:
540: jai_ar_rgm_processing_pkg.get_regime_info(p_regime_code => jai_constants.service_regime,
541: p_tax_type_code => tax_type_rec.t_type,
542: p_regime_id => ln_regime_id,
543: p_error_flag => lv_error_flag,
544: p_error_message => lv_error_message);

Line 546: IF lv_error_flag <> jai_constants.successful THEN

542: p_regime_id => ln_regime_id,
543: p_error_flag => lv_error_flag,
544: p_error_message => lv_error_message);
545:
546: IF lv_error_flag <> jai_constants.successful THEN
547:
548: pv_return_code := jai_constants.expected_error;
549: pv_return_message := lv_error_message;
550: return;

Line 548: pv_return_code := jai_constants.expected_error;

544: p_error_message => lv_error_message);
545:
546: IF lv_error_flag <> jai_constants.successful THEN
547:
548: pv_return_code := jai_constants.expected_error;
549: pv_return_message := lv_error_message;
550: return;
551: END IF;
552:

Line 581: IF nvl(lv_trx_type,'#') <> jai_constants.ar_invoice_type_cm THEN--Added by Wenqiong for Bug 14253668

577: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME || lv_api_name,'v_customer_trx_id = ');
578: END IF;
579:
580: IF lb_is_accrual_basis THEN
581: IF nvl(lv_trx_type,'#') <> jai_constants.ar_invoice_type_cm THEN--Added by Wenqiong for Bug 14253668
582: v_ccid := jai_cmn_rgm_recording_pkg.get_account(p_regime_id => ln_regime_id,
583: p_organization_type => jai_constants.service_tax_orgn_type,
584: p_organization_id => v_organization_id,
585: p_location_id => v_location_id,

Line 583: p_organization_type => jai_constants.service_tax_orgn_type,

579:
580: IF lb_is_accrual_basis THEN
581: IF nvl(lv_trx_type,'#') <> jai_constants.ar_invoice_type_cm THEN--Added by Wenqiong for Bug 14253668
582: v_ccid := jai_cmn_rgm_recording_pkg.get_account(p_regime_id => ln_regime_id,
583: p_organization_type => jai_constants.service_tax_orgn_type,
584: p_organization_id => v_organization_id,
585: p_location_id => v_location_id,
586: p_tax_type => tax_type_rec.t_type,
587: p_account_name => jai_constants.liability);

Line 587: p_account_name => jai_constants.liability);

583: p_organization_type => jai_constants.service_tax_orgn_type,
584: p_organization_id => v_organization_id,
585: p_location_id => v_location_id,
586: p_tax_type => tax_type_rec.t_type,
587: p_account_name => jai_constants.liability);
588: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
589: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME || lv_api_name,'Get accrual basis account for service tax, liability account ccid is '|| v_ccid);
590: END IF;
591: --Added by Wenqiong for Bug 14253668 begin

Line 592: ELSIF nvl(lv_trx_type,'#') = jai_constants.ar_invoice_type_cm THEN

588: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
589: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME || lv_api_name,'Get accrual basis account for service tax, liability account ccid is '|| v_ccid);
590: END IF;
591: --Added by Wenqiong for Bug 14253668 begin
592: ELSIF nvl(lv_trx_type,'#') = jai_constants.ar_invoice_type_cm THEN
593: v_ccid := jai_cmn_rgm_recording_pkg.get_account (
594: p_regime_id => ln_regime_id ,
595: p_organization_type => jai_constants.service_tax_orgn_type ,
596: p_organization_id => v_organization_id ,

Line 595: p_organization_type => jai_constants.service_tax_orgn_type ,

591: --Added by Wenqiong for Bug 14253668 begin
592: ELSIF nvl(lv_trx_type,'#') = jai_constants.ar_invoice_type_cm THEN
593: v_ccid := jai_cmn_rgm_recording_pkg.get_account (
594: p_regime_id => ln_regime_id ,
595: p_organization_type => jai_constants.service_tax_orgn_type ,
596: p_organization_id => v_organization_id ,
597: p_location_id => v_location_id ,
598: p_tax_type => tax_type_rec.t_type ,
599: p_account_name => jai_constants.recovery

Line 599: p_account_name => jai_constants.recovery

595: p_organization_type => jai_constants.service_tax_orgn_type ,
596: p_organization_id => v_organization_id ,
597: p_location_id => v_location_id ,
598: p_tax_type => tax_type_rec.t_type ,
599: p_account_name => jai_constants.recovery
600: );
601: END IF;
602: --Added by Wenqiong for Bug 14253668 end
603: ELSE

Line 604: IF nvl(lv_trx_type,'#') <> jai_constants.ar_invoice_type_cm THEN --Added by Wenqiong for Bug 14253668

600: );
601: END IF;
602: --Added by Wenqiong for Bug 14253668 end
603: ELSE
604: IF nvl(lv_trx_type,'#') <> jai_constants.ar_invoice_type_cm THEN --Added by Wenqiong for Bug 14253668
605: v_ccid := jai_cmn_rgm_recording_pkg.get_account(p_regime_id => ln_regime_id,
606: p_organization_type => jai_constants.service_tax_orgn_type,
607: p_organization_id => v_organization_id,
608: p_location_id => v_location_id,

Line 606: p_organization_type => jai_constants.service_tax_orgn_type,

602: --Added by Wenqiong for Bug 14253668 end
603: ELSE
604: IF nvl(lv_trx_type,'#') <> jai_constants.ar_invoice_type_cm THEN --Added by Wenqiong for Bug 14253668
605: v_ccid := jai_cmn_rgm_recording_pkg.get_account(p_regime_id => ln_regime_id,
606: p_organization_type => jai_constants.service_tax_orgn_type,
607: p_organization_id => v_organization_id,
608: p_location_id => v_location_id,
609: p_tax_type => tax_type_rec.t_type,
610: p_account_name => jai_constants.liability_interim);

Line 610: p_account_name => jai_constants.liability_interim);

606: p_organization_type => jai_constants.service_tax_orgn_type,
607: p_organization_id => v_organization_id,
608: p_location_id => v_location_id,
609: p_tax_type => tax_type_rec.t_type,
610: p_account_name => jai_constants.liability_interim);
611: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
612: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME || lv_api_name,'Get cash basis account for service tax, liability interim account ccid is '|| v_ccid);
613: END IF;
614: --Added by Wenqiong for Bug 14253668 begin

Line 615: ELSIF nvl(lv_trx_type,'#') = jai_constants.ar_invoice_type_cm THEN

611: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
612: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME || lv_api_name,'Get cash basis account for service tax, liability interim account ccid is '|| v_ccid);
613: END IF;
614: --Added by Wenqiong for Bug 14253668 begin
615: ELSIF nvl(lv_trx_type,'#') = jai_constants.ar_invoice_type_cm THEN
616: v_ccid := jai_cmn_rgm_recording_pkg.get_account (
617: p_regime_id => ln_regime_id ,
618: p_organization_type => jai_constants.service_tax_orgn_type ,
619: p_organization_id => v_organization_id ,

Line 618: p_organization_type => jai_constants.service_tax_orgn_type ,

614: --Added by Wenqiong for Bug 14253668 begin
615: ELSIF nvl(lv_trx_type,'#') = jai_constants.ar_invoice_type_cm THEN
616: v_ccid := jai_cmn_rgm_recording_pkg.get_account (
617: p_regime_id => ln_regime_id ,
618: p_organization_type => jai_constants.service_tax_orgn_type ,
619: p_organization_id => v_organization_id ,
620: p_location_id => v_location_id ,
621: p_tax_type => tax_type_rec.t_type ,
622: p_account_name => jai_constants.recovery_interim

Line 622: p_account_name => jai_constants.recovery_interim

618: p_organization_type => jai_constants.service_tax_orgn_type ,
619: p_organization_id => v_organization_id ,
620: p_location_id => v_location_id ,
621: p_tax_type => tax_type_rec.t_type ,
622: p_account_name => jai_constants.recovery_interim
623: );
624: END IF;
625: --Added by Wenqiong for Bug 14253668 end
626: END IF;

Line 629: pv_return_code := jai_constants.expected_error;

625: --Added by Wenqiong for Bug 14253668 end
626: END IF;
627:
628: IF v_ccid IS NULL THEN
629: pv_return_code := jai_constants.expected_error;
630: pv_return_message := 'Invalid Code combination ,please check the Service Tax - Tax Accounting Setup';
631: return;
632: END IF;
633:

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

630: pv_return_message := 'Invalid Code combination ,please check the Service Tax - Tax Accounting Setup';
631: return;
632: END IF;
633:
634: ELSIF UPPER(nvl(ln_regime_code, '####')) = jai_constants.vat_regime THEN
635:
636: if pr_new.inventory_item_id is not null then
637: jai_inv_items_pkg.jai_get_attrib(p_regime_code => ln_regime_code,
638: p_organization_id => v_organization_id,

Line 640: p_attribute_code => jai_constants.rgm_attr_item_applicable,

636: if pr_new.inventory_item_id is not null then
637: jai_inv_items_pkg.jai_get_attrib(p_regime_code => ln_regime_code,
638: p_organization_id => v_organization_id,
639: p_inventory_item_id => pr_new.inventory_item_id,
640: p_attribute_code => jai_constants.rgm_attr_item_applicable,
641: p_attribute_value => lv_attr_value,
642: p_process_flag => lv_error_flag,
643: p_process_msg => lv_error_message);
644: IF lv_error_flag <> jai_constants.successful THEN

Line 644: IF lv_error_flag <> jai_constants.successful THEN

640: p_attribute_code => jai_constants.rgm_attr_item_applicable,
641: p_attribute_value => lv_attr_value,
642: p_process_flag => lv_error_flag,
643: p_process_msg => lv_error_message);
644: IF lv_error_flag <> jai_constants.successful THEN
645: pv_return_code := jai_constants.expected_error;
646: pv_return_message := lv_error_message;
647: return;
648: END IF;

Line 645: pv_return_code := jai_constants.expected_error;

641: p_attribute_value => lv_attr_value,
642: p_process_flag => lv_error_flag,
643: p_process_msg => lv_error_message);
644: IF lv_error_flag <> jai_constants.successful THEN
645: pv_return_code := jai_constants.expected_error;
646: pv_return_message := lv_error_message;
647: return;
648: END IF;
649: end if;

Line 652: pv_return_code := jai_constants.expected_error;

648: END IF;
649: end if;
650: if pr_new.inventory_item_id is not null and
651: nvl(lv_attr_value, 'N') = 'N' THEN
652: pv_return_code := jai_constants.expected_error;
653: pv_return_message := 'ITEM not vatable';
654: return;
655:
656: END IF;

Line 675: p_organization_type => jai_constants.orgn_type_io,

671: end if;
672:
673: IF ln_rma_flag > 0 OR ln_nonship_rma_flag > 0 THEN
674: v_ccid := jai_cmn_rgm_recording_pkg.get_account(p_regime_id => ln_regime_id,
675: p_organization_type => jai_constants.orgn_type_io,
676: p_organization_id => v_organization_id,
677: p_location_id => v_location_id,
678: p_tax_type => tax_type_rec.t_type,
679: p_account_name => jai_constants.recovery);

Line 679: p_account_name => jai_constants.recovery);

675: p_organization_type => jai_constants.orgn_type_io,
676: p_organization_id => v_organization_id,
677: p_location_id => v_location_id,
678: p_tax_type => tax_type_rec.t_type,
679: p_account_name => jai_constants.recovery);
680: ELSE
681:
682: v_ccid := jai_cmn_rgm_recording_pkg.get_account(p_regime_id => ln_regime_id,
683: p_organization_type => jai_constants.orgn_type_io,

Line 683: p_organization_type => jai_constants.orgn_type_io,

679: p_account_name => jai_constants.recovery);
680: ELSE
681:
682: v_ccid := jai_cmn_rgm_recording_pkg.get_account(p_regime_id => ln_regime_id,
683: p_organization_type => jai_constants.orgn_type_io,
684: p_organization_id => v_organization_id,
685: p_location_id => v_location_id,
686: p_tax_type => tax_type_rec.t_type,
687: p_account_name => jai_constants.liability_interim);

Line 687: p_account_name => jai_constants.liability_interim);

683: p_organization_type => jai_constants.orgn_type_io,
684: p_organization_id => v_organization_id,
685: p_location_id => v_location_id,
686: p_tax_type => tax_type_rec.t_type,
687: p_account_name => jai_constants.liability_interim);
688:
689: End IF;
690: IF v_ccid IS NULL THEN
691:

Line 692: pv_return_code := jai_constants.expected_error;

688:
689: End IF;
690: IF v_ccid IS NULL THEN
691:
692: pv_return_code := jai_constants.expected_error;
693: pv_return_message := 'Invalid Code combination ,please check the VAT Tax - Tax Accounting Setup ';
694: return;
695:
696: END IF;

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

694: return;
695:
696: END IF;
697:
698: ELSIF UPPER(nvl(ln_regime_code, '####')) = jai_constants.tcs_regime THEN
699: v_ccid := jai_cmn_rgm_recording_pkg.get_account(p_regime_id => ln_regime_id,
700: p_organization_type => jai_constants.orgn_type_io,
701: p_organization_id => v_organization_id,
702: p_location_id => v_location_id,

Line 700: p_organization_type => jai_constants.orgn_type_io,

696: END IF;
697:
698: ELSIF UPPER(nvl(ln_regime_code, '####')) = jai_constants.tcs_regime THEN
699: v_ccid := jai_cmn_rgm_recording_pkg.get_account(p_regime_id => ln_regime_id,
700: p_organization_type => jai_constants.orgn_type_io,
701: p_organization_id => v_organization_id,
702: p_location_id => v_location_id,
703: p_tax_type => tax_type_rec.t_type,
704: p_account_name => jai_constants.liability_interim);

Line 704: p_account_name => jai_constants.liability_interim);

700: p_organization_type => jai_constants.orgn_type_io,
701: p_organization_id => v_organization_id,
702: p_location_id => v_location_id,
703: p_tax_type => tax_type_rec.t_type,
704: p_account_name => jai_constants.liability_interim);
705: IF v_ccid IS NULL THEN
706:
707: raise_application_error(-20130,
708: 'Invalid Code combination ,please check the TCS Tax - Tax Accounting Setup');

Line 752: ELSIF (v_counter > 0 AND pv_action = JAI_CONSTANTS.updating) THEN

748: pv_source => v_created_from,
749: pn_org_id => v_org_id,
750: pn_line_number => tax_type_rec.tax_line_no);
751:
752: ELSIF (v_counter > 0 AND pv_action = JAI_CONSTANTS.updating) THEN
753: UPDATE JAI_AR_TRX_INS_LINES_T
754: SET extended_amount = TAX_TYPE_REC.tax_amt,
755: set_of_books_id = v_books_id,
756: line_type = v_line_type,

Line 776: pv_return_code := jai_constants.expected_error;

772:
773: EXCEPTION
774: WHEN OTHERS THEN
775: v_err_mesg := SQLERRM;
776: pv_return_code := jai_constants.expected_error;
777: pv_return_message := 'error in processing the invoice ..' ||
778: v_trx_num || v_err_mesg;
779: return;
780: END;

Line 792: IF pv_action = JAI_CONSTANTS.updating THEN

788:
789:
790: END IF;*/
791: --Commented by Qinglei for JAI Trigger Elimination 11-May-2012 end
792: IF pv_action = JAI_CONSTANTS.updating THEN
793: IF v_created_from = 'ARXTWMAI' AND v_tax_exists = 1 THEN
794: BEGIN
795: SELECT max(jattl.tax_line_no)
796: INTO l_tcs_sur_line_num

Line 801: AND jcta.tax_type = jai_constants.tax_type_tcs_surcharge

797: FROM JAI_AR_TRX_TAX_LINES jattl, jai_cmn_taxes_all jcta
798: WHERE jattl.link_to_cust_trx_line_id =
799: pr_new.customer_trx_line_id
800: AND jattl.tax_id = jcta.tax_id
801: AND jcta.tax_type = jai_constants.tax_type_tcs_surcharge
802: GROUP BY jcta.tax_type;
803: EXCEPTION
804: WHEN NO_DATA_FOUND THEN
805: l_tcs_sur_line_num := 0;

Line 853: AND jcta.tax_type = jai_constants.tax_type_tcs

849: FROM JAI_AR_TRX_TAX_LINES jattl, jai_cmn_taxes_all jcta
850: WHERE jattl.link_to_cust_trx_line_id =
851: pr_new.customer_trx_line_id
852: AND jattl.tax_id = jcta.tax_id
853: AND jcta.tax_type = jai_constants.tax_type_tcs
854: GROUP BY jcta.tax_type;
855: EXCEPTION
856: WHEN NO_DATA_FOUND THEN
857: RETURN;

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

857: RETURN;
858: END;
859:
860: IF (l_tcs_line_num > 0) then
861: open gc_get_regime_id(cp_regime_code => jai_constants.tcs_regime);
862: fetch gc_get_regime_id
863: into ln_tcs_regime_id;
864: close gc_get_regime_id;
865:

Line 881: p_party_type => jai_constants.party_type_customer,

877: WHERE customer_trx_id = pr_new.customer_trx_id;
878:
879: jai_rgm_thhold_proc_pkg.get_threshold_slab_id(p_regime_id => ln_tcs_regime_id,
880: p_organization_id => ln_organization_id,
881: p_party_type => jai_constants.party_type_customer,
882: p_party_id => l_bill_to_customer_id,
883: p_org_id => l_org_id,
884: p_source_trx_date => ln_trx_date,
885: p_threshold_slab_id => ln_threshold_slab_id,

Line 889: if lv_process_flag <> jai_constants.successful then

885: p_threshold_slab_id => ln_threshold_slab_id,
886: p_process_flag => lv_process_flag,
887: p_process_message => lv_process_message);
888:
889: if lv_process_flag <> jai_constants.successful then
890: app_exception.raise_exception(exception_type => 'APP',
891: exception_code => -20275,
892: exception_text => lv_process_message);
893: end if;

Line 901: if lv_process_flag <> jai_constants.successful then

897: p_org_id => l_org_id,
898: p_threshold_tax_cat_id => ln_threshold_tax_cat_id,
899: p_process_flag => lv_process_flag,
900: p_process_message => lv_process_message);
901: if lv_process_flag <> jai_constants.successful then
902: app_exception.raise_exception(exception_type => 'APP',
903: exception_code => -20275,
904: exception_text => lv_process_message);
905: end if;

Line 1011: IF lv_return_code = JAI_CONSTANTS.SUCCESSFUL AND

1007: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1008: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME || lv_api_name,lv_debug_info);
1009: END IF;
1010:
1011: IF lv_return_code = JAI_CONSTANTS.SUCCESSFUL AND
1012: lv_created_from = 'ARXTWMAI' AND ln_tax_exists = 1 THEN
1013: JAI_AR_MATCH_TAX_PKG.PROCESS_MANUAL_INVOICE(lv_errbuf,
1014: lv_retcode,
1015: ln_customer_trx_id,