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.

[Home] [Help]

APPS.JAI_AR_RCTLA_TRIGGER_PKG dependencies on JAI_CMN_ERRORS_T

Line 18: added the who columns in the insert of JAI_CMN_ERRORS_T

14:
15: S.No. Description
16:
17: 1 07/12/2005 Hjujjuru for the bug 4866533 File version 120.1
18: added the who columns in the insert of JAI_CMN_ERRORS_T
19: Dependencies Due to this bug:-
20: None
21:
22: 2 24/04/1005 cbabu for bug#6012570 (5876390) Version: 120.11

Line 724: lv_appl_src JAI_CMN_ERRORS_T.APPLICATION_SOURCE%type;

720: ln_vat_invoice_no JAI_AR_TRXS.vat_invoice_no %TYPE ;
721: ln_vat_invoice_date JAI_AR_TRXS.vat_invoice_date%TYPE;
722: -- ended, Harshita for bug#4245062
723:
724: lv_appl_src JAI_CMN_ERRORS_T.APPLICATION_SOURCE%type;
725: lv_err_msg JAI_CMN_ERRORS_T.error_message%type;
726:
727: ln_legal_entity_id NUMBER ; /* rallamse bug#4510143 */
728:

Line 725: lv_err_msg JAI_CMN_ERRORS_T.error_message%type;

721: ln_vat_invoice_date JAI_AR_TRXS.vat_invoice_date%TYPE;
722: -- ended, Harshita for bug#4245062
723:
724: lv_appl_src JAI_CMN_ERRORS_T.APPLICATION_SOURCE%type;
725: lv_err_msg JAI_CMN_ERRORS_T.error_message%type;
726:
727: ln_legal_entity_id NUMBER ; /* rallamse bug#4510143 */
728:
729: v_service_type VARCHAR2(30); -- added by csahoo for bug#5879769

Line 2056: lv_appl_src JAI_CMN_ERRORS_T.APPLICATION_SOURCE%type;

2052: rec_so_lines JA_SO_LINES_INFO%rowtype;
2053: ln_inv_orgn_id number ;
2054: ln_default_locn_id number;
2055:
2056: lv_appl_src JAI_CMN_ERRORS_T.APPLICATION_SOURCE%type;
2057: lv_err_msg JAI_CMN_ERRORS_T.ERROR_MESSAGE%type;
2058: lv_addl_msg JAI_CMN_ERRORS_T.ADDITIONAL_ERROR_MESG%type;
2059:
2060: ln_legal_entity_id NUMBER ; /* rallamse bug#4510143 */

Line 2057: lv_err_msg JAI_CMN_ERRORS_T.ERROR_MESSAGE%type;

2053: ln_inv_orgn_id number ;
2054: ln_default_locn_id number;
2055:
2056: lv_appl_src JAI_CMN_ERRORS_T.APPLICATION_SOURCE%type;
2057: lv_err_msg JAI_CMN_ERRORS_T.ERROR_MESSAGE%type;
2058: lv_addl_msg JAI_CMN_ERRORS_T.ADDITIONAL_ERROR_MESG%type;
2059:
2060: ln_legal_entity_id NUMBER ; /* rallamse bug#4510143 */
2061: -- Date 26-feb-2006 added by sacsethi for bug 5631784

Line 2058: lv_addl_msg JAI_CMN_ERRORS_T.ADDITIONAL_ERROR_MESG%type;

2054: ln_default_locn_id number;
2055:
2056: lv_appl_src JAI_CMN_ERRORS_T.APPLICATION_SOURCE%type;
2057: lv_err_msg JAI_CMN_ERRORS_T.ERROR_MESSAGE%type;
2058: lv_addl_msg JAI_CMN_ERRORS_T.ADDITIONAL_ERROR_MESG%type;
2059:
2060: ln_legal_entity_id NUMBER ; /* rallamse bug#4510143 */
2061: -- Date 26-feb-2006 added by sacsethi for bug 5631784
2062: --start 5631784

Line 2150: if the default location setup is not done , log this as a message in the JAI_CMN_ERRORS_T table

2146:
2147: if ln_default_locn_id is null then
2148:
2149: /*
2150: if the default location setup is not done , log this as a message in the JAI_CMN_ERRORS_T table
2151: do not stop the processing.
2152: We could still update the organization and location id in the JAI_AR_TRXS table later on (as a datafix)
2153: */
2154: lv_appl_src := 'JA_IN_OE_AR_LINES_INSERT_TRG' ;

Line 2158: insert into JAI_CMN_ERRORS_T

2154: lv_appl_src := 'JA_IN_OE_AR_LINES_INSERT_TRG' ;
2155: lv_err_msg := 'Default Location is not setup for Inventory Organization ' || pr_new.warehouse_id ;
2156: lv_addl_msg := 'Please setup the Default Location in Organization Additional Information Screen for Trx id : ' || pr_new.customer_trx_id ;
2157:
2158: insert into JAI_CMN_ERRORS_T
2159: (
2160: APPLICATION_SOURCE ,
2161: ERROR_MESSAGE ,
2162: ADDITIONAL_ERROR_MESG ,

Line 4459: INSERT INTO JAI_CMN_ERRORS_T

4455:
4456: lv_appl_src := 'JA_IN_OE_AR_LINES_INSERT_TRG' ;
4457: lv_err_msg := 'EXCEPTION Occured' ;
4458:
4459: INSERT INTO JAI_CMN_ERRORS_T
4460: (
4461: APPLICATION_SOURCE ,
4462: error_message ,
4463: additional_error_mesg ,

Line 4788: lv_appl_src JAI_CMN_ERRORS_T.APPLICATION_SOURCE%type;

4784: rec_so_taxes SO_RMA_TAX_LINES_INFO%rowtype;
4785: ln_inv_orgn_id number ;
4786: ln_default_locn_id number;
4787:
4788: lv_appl_src JAI_CMN_ERRORS_T.APPLICATION_SOURCE%type;
4789: lv_err_msg JAI_CMN_ERRORS_T.ERROR_MESSAGE%type;
4790: lv_addl_msg JAI_CMN_ERRORS_T.ADDITIONAL_ERROR_MESG%type;
4791:
4792: ln_legal_entity_id NUMBER;

Line 4789: lv_err_msg JAI_CMN_ERRORS_T.ERROR_MESSAGE%type;

4785: ln_inv_orgn_id number ;
4786: ln_default_locn_id number;
4787:
4788: lv_appl_src JAI_CMN_ERRORS_T.APPLICATION_SOURCE%type;
4789: lv_err_msg JAI_CMN_ERRORS_T.ERROR_MESSAGE%type;
4790: lv_addl_msg JAI_CMN_ERRORS_T.ADDITIONAL_ERROR_MESG%type;
4791:
4792: ln_legal_entity_id NUMBER;
4793: ln_tcs_exists number;

Line 4790: lv_addl_msg JAI_CMN_ERRORS_T.ADDITIONAL_ERROR_MESG%type;

4786: ln_default_locn_id number;
4787:
4788: lv_appl_src JAI_CMN_ERRORS_T.APPLICATION_SOURCE%type;
4789: lv_err_msg JAI_CMN_ERRORS_T.ERROR_MESSAGE%type;
4790: lv_addl_msg JAI_CMN_ERRORS_T.ADDITIONAL_ERROR_MESG%type;
4791:
4792: ln_legal_entity_id NUMBER;
4793: ln_tcs_exists number;
4794: ln_tcs_regime_id JAI_RGM_DEFINITIONS.regime_id%type;

Line 4878: if the default location setup is not done , log this as a message in the JAI_CMN_ERRORS_T table

4874:
4875: if ln_default_locn_id is null then
4876:
4877: /*
4878: if the default location setup is not done , log this as a message in the JAI_CMN_ERRORS_T table
4879: do not stop the processing.
4880: We could still update the organization and location id in the JAI_AR_TRXS table later on (as a datafix)
4881: */
4882: lv_appl_src := 'JA_IN_OE_AR_LINES_INSERT_TRG' ;

Line 4886: insert into JAI_CMN_ERRORS_T

4882: lv_appl_src := 'JA_IN_OE_AR_LINES_INSERT_TRG' ;
4883: lv_err_msg := 'Default Location is not setup for Inventory Organization ' || pr_new.warehouse_id ;
4884: lv_addl_msg := 'Please setup the Default Location in Organization Additional Information Screen for Trx id : ' || pr_new.customer_trx_id ;
4885:
4886: insert into JAI_CMN_ERRORS_T
4887: (
4888: APPLICATION_SOURCE ,
4889: ERROR_MESSAGE ,
4890: ADDITIONAL_ERROR_MESG ,

Line 6422: lv_appl_src JAI_CMN_ERRORS_T.APPLICATION_SOURCE%type ;

6418: ln_vat_assessable_value JAI_AR_TRX_LINES.VAT_ASSESSABLE_VALUE%TYPE;
6419: --ln_gst_assessable_value JAI_AR_TRX_LINES.GST_ASSESSABLE_VALUE%TYPE;--Added by Xiao Lv for bug 10091373
6420:
6421: /* Added by Ramananda as a part of removal of SQL LITERALs , start */
6422: lv_appl_src JAI_CMN_ERRORS_T.APPLICATION_SOURCE%type ;
6423: lv_add_err JAI_CMN_ERRORS_T.additional_error_mesg%type ;
6424: BEGIN
6425: pv_return_code := jai_constants.successful ;
6426: /* This Trigger fires , when you insert a record in RA_CUSTOMER_TRX_LINES_ALL */

Line 6423: lv_add_err JAI_CMN_ERRORS_T.additional_error_mesg%type ;

6419: --ln_gst_assessable_value JAI_AR_TRX_LINES.GST_ASSESSABLE_VALUE%TYPE;--Added by Xiao Lv for bug 10091373
6420:
6421: /* Added by Ramananda as a part of removal of SQL LITERALs , start */
6422: lv_appl_src JAI_CMN_ERRORS_T.APPLICATION_SOURCE%type ;
6423: lv_add_err JAI_CMN_ERRORS_T.additional_error_mesg%type ;
6424: BEGIN
6425: pv_return_code := jai_constants.successful ;
6426: /* This Trigger fires , when you insert a record in RA_CUSTOMER_TRX_LINES_ALL */
6427:

Line 6963: INSERT INTO JAI_CMN_ERRORS_T

6959:
6960: lv_appl_src := 'JA_IN_AR_LINES_INSERT_TRG';
6961: lv_add_err := 'CUSTOMER_TRX_ID = ' || TO_CHAR(pr_new.CUSTOMER_TRX_ID) || ' CUSTOMER_TRX_LINE_ID = ' || TO_CHAR(pr_new.CUSTOMER_TRX_LINE_ID) ;
6962:
6963: INSERT INTO JAI_CMN_ERRORS_T
6964: ( APPLICATION_SOURCE,
6965: error_message,
6966: additional_error_mesg,
6967: creation_date,