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

Line 130: replaced RG Register Data Entry by jai_constants.je_category_rg_entry

126: 29 17/06/2007 ssumaith - bug# 6131804 - bond register is not gettnig hit in INR for foreign currency trxs.
127: Code changes are done in this package for handling the cess amount.
128:
129: 30. 28/06/2007 CSahoo - BUG#6155839, File Version 120.16
130: replaced RG Register Data Entry by jai_constants.je_category_rg_entry
131: 31. 02/07/2007 vkaranam - BUG#6159579, File Version 120.17
132: 1.In Procedure ja_in_cess_entries while calling ja_in_om_cess_register_entries p_delivery_detail_id parameter is not passed.
133:
134: 32. 05/07/2007 kunkumar for Bug#5745729 file version 120.18

Line 240: and upper(b.tax_type) in (jai_constants.TAX_TYPE_CVD_EDU_CESS,jai_constants.TAX_TYPE_EXC_EDU_CESS);

236: from JAI_OM_WSH_LINES_ALL
237: where delivery_id = cp_delivery_id
238: )
239: and a.tax_id = b.tax_id
240: and upper(b.tax_type) in (jai_constants.TAX_TYPE_CVD_EDU_CESS,jai_constants.TAX_TYPE_EXC_EDU_CESS);
241:
242:
243: /*Bug 5989740 bduvarag start*/
244: cursor c_sh_cess_amount(cp_delivery_id number) is

Line 253: and upper(b.tax_type) in (JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS,JAI_CONSTANTS.TAX_TYPE_SH_EXC_EDU_CESS);

249: from JAI_OM_WSH_LINES_ALL
250: where delivery_id = cp_delivery_id
251: )
252: and a.tax_id = b.tax_id
253: and upper(b.tax_type) in (JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS,JAI_CONSTANTS.TAX_TYPE_SH_EXC_EDU_CESS);
254:
255: /*Bug 5989740 bduvarag end*/
256: cursor c_fetch_cess_account(cp_organization_id number , cp_location_id number) is
257: select cess_paid_payable_account_id

Line 664: AND (( upper(jtc.tax_type) IN (jai_constants.tax_type_cvd_edu_cess,JAI_CONSTANTS.TAX_TYPE_EXC_EDU_CESS) and p_cess_type = 'EXC') --Date 12/03/2007 by SACSETHI for bug#5907436

660: JAI_CMN_TAXES_ALL jtc
661: WHERE jtc.tax_id = jsptl.tax_id
662: --Modified for bug5747126
663: AND delivery_detail_id = p_delivery_detail_id
664: AND (( upper(jtc.tax_type) IN (jai_constants.tax_type_cvd_edu_cess,JAI_CONSTANTS.TAX_TYPE_EXC_EDU_CESS) and p_cess_type = 'EXC') --Date 12/03/2007 by SACSETHI for bug#5907436
665: OR
666: ( upper(jtc.tax_type) IN (jai_constants.tax_type_sh_cvd_edu_cess,JAI_CONSTANTS.TAX_TYPE_sh_EXC_EDU_CESS) and p_cess_type = 'SH') )
667: GROUP BY jtc.tax_type
668: HAVING SUM(jsptl.func_tax_amount) <> 0;

Line 666: ( upper(jtc.tax_type) IN (jai_constants.tax_type_sh_cvd_edu_cess,JAI_CONSTANTS.TAX_TYPE_sh_EXC_EDU_CESS) and p_cess_type = 'SH') )

662: --Modified for bug5747126
663: AND delivery_detail_id = p_delivery_detail_id
664: AND (( upper(jtc.tax_type) IN (jai_constants.tax_type_cvd_edu_cess,JAI_CONSTANTS.TAX_TYPE_EXC_EDU_CESS) and p_cess_type = 'EXC') --Date 12/03/2007 by SACSETHI for bug#5907436
665: OR
666: ( upper(jtc.tax_type) IN (jai_constants.tax_type_sh_cvd_edu_cess,JAI_CONSTANTS.TAX_TYPE_sh_EXC_EDU_CESS) and p_cess_type = 'SH') )
667: GROUP BY jtc.tax_type
668: HAVING SUM(jsptl.func_tax_amount) <> 0;
669: -- added, Harshita for Bug 4714518
670: /*AND

Line 694: AND (( upper(jtc.tax_type) IN (jai_constants.tax_type_cvd_edu_cess,JAI_CONSTANTS.TAX_TYPE_EXC_EDU_CESS) and p_cess_type = 'EXC') --Date 12/03/2007 by SACSETHI for bug#5907436

690: JAI_INV_ITM_SETUPS jmsi /* Added by Ramananda for bug#5912620*/
691: WHERE jtc.tax_id = jsptl.tax_id
692: AND jspl.delivery_id = p_delivery_id
693: AND jspl.delivery_detail_id = jsptl.delivery_detail_id
694: AND (( upper(jtc.tax_type) IN (jai_constants.tax_type_cvd_edu_cess,JAI_CONSTANTS.TAX_TYPE_EXC_EDU_CESS) and p_cess_type = 'EXC') --Date 12/03/2007 by SACSETHI for bug#5907436
695: OR
696: ( upper(jtc.tax_type) IN (jai_constants.tax_type_sh_cvd_edu_cess,JAI_CONSTANTS.TAX_TYPE_sh_EXC_EDU_CESS) and p_cess_type = 'SH') )
697: /* Added for bug#5912620, Starts */
698: AND jmsi.inventory_item_id = jspl.inventory_item_id

Line 696: ( upper(jtc.tax_type) IN (jai_constants.tax_type_sh_cvd_edu_cess,JAI_CONSTANTS.TAX_TYPE_sh_EXC_EDU_CESS) and p_cess_type = 'SH') )

692: AND jspl.delivery_id = p_delivery_id
693: AND jspl.delivery_detail_id = jsptl.delivery_detail_id
694: AND (( upper(jtc.tax_type) IN (jai_constants.tax_type_cvd_edu_cess,JAI_CONSTANTS.TAX_TYPE_EXC_EDU_CESS) and p_cess_type = 'EXC') --Date 12/03/2007 by SACSETHI for bug#5907436
695: OR
696: ( upper(jtc.tax_type) IN (jai_constants.tax_type_sh_cvd_edu_cess,JAI_CONSTANTS.TAX_TYPE_sh_EXC_EDU_CESS) and p_cess_type = 'SH') )
697: /* Added for bug#5912620, Starts */
698: AND jmsi.inventory_item_id = jspl.inventory_item_id
699: AND jmsi.organization_id = jspl.organization_id
700: AND jmsi.excise_flag = 'Y'

Line 734: IF lv_process_flag <> jai_constants.successful THEN

730: );
731:
732: Fnd_File.PUT_LINE(Fnd_File.LOG, 'after calling jai_Rg_others_pkg.insert_row with P_PROCESS_FLAG => ' || lv_process_flag);
733: Fnd_File.PUT_LINE(Fnd_File.LOG, 'after calling jai_Rg_others_pkg.insert_row with P_PROCESS_MSG => ' || lv_process_msg);
734: IF lv_process_flag <> jai_constants.successful THEN
735: Fnd_File.PUT_LINE(Fnd_File.LOG, 'Error Encountered is ' ||lv_process_msg); --Added for bug#7172215
736: raise_application_error(-20110,'Error Encountered is ' || lv_process_msg);
737: END IF;
738:

Line 768: IF lv_process_flag <> jai_constants.successful THEN

764: );
765:
766: Fnd_File.PUT_LINE(Fnd_File.LOG, 'after calling jai_Rg_others_pkg.insert_row with P_PROCESS_FLAG => ' || lv_process_flag);
767: Fnd_File.PUT_LINE(Fnd_File.LOG, 'after calling jai_Rg_others_pkg.insert_row with P_PROCESS_MSG => ' || lv_process_msg);
768: IF lv_process_flag <> jai_constants.successful THEN
769: Fnd_File.PUT_LINE(Fnd_File.LOG, 'Error Encountered is ' ||lv_process_msg); --Added for bug#7172215
770: raise_application_error(-20110,'Error Encountered is ' || lv_process_msg);
771: END IF;
772:

Line 827: AND (( upper(jtc.tax_type) IN (jai_constants.tax_type_cvd_edu_cess,JAI_CONSTANTS.TAX_TYPE_EXC_EDU_CESS) and p_cess_type = 'EXC')

823: FROM JAI_AR_TRX_TAX_LINES jrctl ,
824: JAI_CMN_TAXES_ALL jtc
825: WHERE jtc.tax_id = jrctl.tax_id
826: AND link_to_cust_trx_line_id = p_customer_trx_id -- added, aiyer for Bug 4541303 /*Bug 5989740 bduvarag*/
827: AND (( upper(jtc.tax_type) IN (jai_constants.tax_type_cvd_edu_cess,JAI_CONSTANTS.TAX_TYPE_EXC_EDU_CESS) and p_cess_type = 'EXC')
828: OR
829: ( upper(jtc.tax_type) IN (jai_constants.tax_type_sh_cvd_edu_cess,JAI_CONSTANTS.TAX_TYPE_sh_EXC_EDU_CESS) and p_cess_type = 'SH') )
830:
831:

Line 829: ( upper(jtc.tax_type) IN (jai_constants.tax_type_sh_cvd_edu_cess,JAI_CONSTANTS.TAX_TYPE_sh_EXC_EDU_CESS) and p_cess_type = 'SH') )

825: WHERE jtc.tax_id = jrctl.tax_id
826: AND link_to_cust_trx_line_id = p_customer_trx_id -- added, aiyer for Bug 4541303 /*Bug 5989740 bduvarag*/
827: AND (( upper(jtc.tax_type) IN (jai_constants.tax_type_cvd_edu_cess,JAI_CONSTANTS.TAX_TYPE_EXC_EDU_CESS) and p_cess_type = 'EXC')
828: OR
829: ( upper(jtc.tax_type) IN (jai_constants.tax_type_sh_cvd_edu_cess,JAI_CONSTANTS.TAX_TYPE_sh_EXC_EDU_CESS) and p_cess_type = 'SH') )
830:
831:
832: GROUP BY jtc.tax_type
833: HAVING SUM(jrctl.func_tax_amount) <> 0;

Line 981: elsif p_je_source_name = 'Receivables India' and p_je_category_name = jai_constants.je_category_rg_entry then --replaced RG Register Data Entry, csahoo for bug#6155839

977: p_cess_type => p_cess_type /*Bug 5989740 bduvarag*/
978: );
979:
980:
981: elsif p_je_source_name = 'Receivables India' and p_je_category_name = jai_constants.je_category_rg_entry then --replaced RG Register Data Entry, csahoo for bug#6155839
982: /*
983: Do all things needed to populate records into the register table , picking up taxes from the ja_in_customer_trx_tax_lines table
984: */
985: ln_header_id := ln_customer_trx_id;

Line 1213: AND upper(b.tax_type) in (jai_constants.TAX_TYPE_CVD_EDU_CESS,jai_constants.TAX_TYPE_EXC_EDU_CESS);

1209: FROM JAI_OM_WSH_LINES_ALL
1210: WHERE delivery_id = cp_delivery_id
1211: )
1212: AND a.tax_id = b.tax_id
1213: AND upper(b.tax_type) in (jai_constants.TAX_TYPE_CVD_EDU_CESS,jai_constants.TAX_TYPE_EXC_EDU_CESS);
1214:
1215:
1216:
1217: ln_to_location_id PO_REQUISITION_LINES_ALL.DELIVER_TO_LOCATION_ID%TYPE;

Line 3530: AND upper(b.tax_type) in (jai_constants.TAX_TYPE_CVD_EDU_CESS,jai_constants.TAX_TYPE_EXC_EDU_CESS);

3526: SELECT sum(a.tax_amount)
3527: FROM JAI_OM_WSH_LINE_TAXES a, JAI_CMN_TAXES_ALL b
3528: WHERE delivery_detail_id = p_reference_line_id
3529: AND a.tax_id = b.tax_id
3530: AND upper(b.tax_type) in (jai_constants.TAX_TYPE_CVD_EDU_CESS,jai_constants.TAX_TYPE_EXC_EDU_CESS);
3531: /*Bug 5989740 bduvarag*/
3532: CURSOR c_sh_cess_amount IS
3533: SELECT sum(a.tax_amount)
3534: FROM JAI_OM_WSH_LINE_TAXES a, JAI_CMN_TAXES_ALL b

Line 3537: AND upper(b.tax_type) in (JAI_CONSTANTS.tax_type_sh_cvd_edu_cess,JAI_CONSTANTS.tax_type_sh_exc_edu_cess);

3533: SELECT sum(a.tax_amount)
3534: FROM JAI_OM_WSH_LINE_TAXES a, JAI_CMN_TAXES_ALL b
3535: WHERE delivery_detail_id = p_reference_line_id
3536: AND a.tax_id = b.tax_id
3537: AND upper(b.tax_type) in (JAI_CONSTANTS.tax_type_sh_cvd_edu_cess,JAI_CONSTANTS.tax_type_sh_exc_edu_cess);
3538:
3539:
3540:
3541: /*

Line 3988: and upper(jtc.tax_type) in (jai_constants.TAX_TYPE_CVD_EDU_CESS,jai_constants.TAX_TYPE_EXC_EDU_CESS);

3984: (select delivery_detail_id
3985: from JAI_OM_WSH_LINES_ALL
3986: where delivery_id = cp_delivery_id
3987: )
3988: and upper(jtc.tax_type) in (jai_constants.TAX_TYPE_CVD_EDU_CESS,jai_constants.TAX_TYPE_EXC_EDU_CESS);
3989: /*Bug 5989740 bduvarag*/
3990: cursor c_get_om_sh_cess_amount(cp_delivery_id number) is
3991: select NVL(sum(jsptl.func_tax_amount),0) tax_amount
3992: from JAI_OM_WSH_LINE_TAXES jsptl ,

Line 4000: and upper(jtc.tax_type) in (JAI_CONSTANTS.tax_type_sh_cvd_edu_cess,JAI_CONSTANTS.tax_type_sh_exc_edu_cess);

3996: (select delivery_detail_id
3997: from JAI_OM_WSH_LINES_ALL
3998: where delivery_id = cp_delivery_id
3999: )
4000: and upper(jtc.tax_type) in (JAI_CONSTANTS.tax_type_sh_cvd_edu_cess,JAI_CONSTANTS.tax_type_sh_exc_edu_cess);
4001:
4002:
4003: cursor c_get_ar_cess_amount(cp_customer_trx_id number) is
4004: select nvl(sum(jrctl.func_tax_amount),0) tax_amount

Line 4013: and upper(jtc.tax_type) in (jai_constants.TAX_TYPE_CVD_EDU_CESS,jai_constants.TAX_TYPE_EXC_EDU_CESS) ;

4009: (select customer_trx_line_id
4010: from JAI_AR_TRX_LINES
4011: where customer_trx_id = cp_customer_trx_id
4012: )
4013: and upper(jtc.tax_type) in (jai_constants.TAX_TYPE_CVD_EDU_CESS,jai_constants.TAX_TYPE_EXC_EDU_CESS) ;
4014: /*Bug 5989740 bduvarag*/
4015: cursor c_get_ar_sh_cess_amount(cp_customer_trx_id number) is
4016: select nvl(sum(jrctl.func_tax_amount),0) tax_amount
4017: from JAI_AR_TRX_TAX_LINES jrctl ,

Line 4025: and upper(jtc.tax_type) in (JAI_CONSTANTS.tax_type_sh_cvd_edu_cess,JAI_CONSTANTS.tax_type_sh_exc_edu_cess) ;

4021: (select customer_trx_line_id
4022: from JAI_AR_TRX_LINES
4023: where customer_trx_id = cp_customer_trx_id
4024: )
4025: and upper(jtc.tax_type) in (JAI_CONSTANTS.tax_type_sh_cvd_edu_cess,JAI_CONSTANTS.tax_type_sh_exc_edu_cess) ;
4026:
4027: cursor c_ar_cess_ctr(cp_customer_trx_id number) is
4028: select count(1)
4029: from JAI_AR_TRX_TAX_LINES jrctl ,

Line 4037: and upper(jtc.tax_type) in (jai_constants.TAX_TYPE_CVD_EDU_CESS,jai_constants.TAX_TYPE_EXC_EDU_CESS) ;

4033: (select customer_trx_line_id
4034: from JAI_AR_TRX_LINES
4035: where customer_trx_id = cp_customer_trx_id
4036: )
4037: and upper(jtc.tax_type) in (jai_constants.TAX_TYPE_CVD_EDU_CESS,jai_constants.TAX_TYPE_EXC_EDU_CESS) ;
4038: /*Bug 5989740 bduvarag*/
4039: cursor c_ar_sh_cess_ctr(cp_customer_trx_id number) is
4040: select count(1)
4041: from JAI_AR_TRX_TAX_LINES jrctl ,

Line 4049: and upper(jtc.tax_type) in (JAI_CONSTANTS.tax_type_sh_cvd_edu_cess,JAI_CONSTANTS.tax_type_sh_exc_edu_cess) ;

4045: (select customer_trx_line_id
4046: from JAI_AR_TRX_LINES
4047: where customer_trx_id = cp_customer_trx_id
4048: )
4049: and upper(jtc.tax_type) in (JAI_CONSTANTS.tax_type_sh_cvd_edu_cess,JAI_CONSTANTS.tax_type_sh_exc_edu_cess) ;
4050:
4051: v_reg_expiry_date JAI_OM_OE_BOND_REG_HDRS.BOND_EXPIRY_DATE%type;
4052: v_lou_flag JAI_OM_OE_BOND_REG_HDRS.LOU_FLAG%TYPE;
4053: v_asst_register_id JAI_OM_OE_BOND_REG_HDRS.register_id%type;

Line 4142: and jtc.tax_type in (jai_constants.TAX_TYPE_CVD_EDU_CESS,jai_constants.TAX_TYPE_EXC_EDU_CESS)

4138: from JAI_AR_TRX_TAX_LINES jrctl ,
4139: JAI_CMN_TAXES_ALL jtc
4140: where link_to_cust_trx_line_id = line_rec.customer_trx_line_id
4141: and jtc.tax_id = jrctl.tax_id
4142: and jtc.tax_type in (jai_constants.TAX_TYPE_CVD_EDU_CESS,jai_constants.TAX_TYPE_EXC_EDU_CESS)
4143: )
4144: Loop
4145: for cess_amt_rec in
4146: (

Line 4207: and jtc.tax_type in (JAI_CONSTANTS.tax_type_sh_cvd_edu_cess,JAI_CONSTANTS.tax_type_sh_exc_edu_cess)

4203: from JAI_AR_TRX_TAX_LINES jrctl ,
4204: JAI_CMN_TAXES_ALL jtc
4205: where link_to_cust_trx_line_id = line_rec.customer_trx_line_id
4206: and jtc.tax_id = jrctl.tax_id
4207: and jtc.tax_type in (JAI_CONSTANTS.tax_type_sh_cvd_edu_cess,JAI_CONSTANTS.tax_type_sh_exc_edu_cess)
4208: )
4209: Loop
4210: for cess_amt_rec in
4211: (