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_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 694: lv_appl_src JAI_CMN_ERRORS_T.APPLICATION_SOURCE%type;

690: ln_vat_invoice_no JAI_AR_TRXS.vat_invoice_no %TYPE ;
691: ln_vat_invoice_date JAI_AR_TRXS.vat_invoice_date%TYPE;
692: -- ended, Harshita for bug#4245062
693:
694: lv_appl_src JAI_CMN_ERRORS_T.APPLICATION_SOURCE%type;
695: lv_err_msg JAI_CMN_ERRORS_T.error_message%type;
696:
697: ln_legal_entity_id NUMBER ; /* rallamse bug#4510143 */
698:

Line 695: lv_err_msg JAI_CMN_ERRORS_T.error_message%type;

691: ln_vat_invoice_date JAI_AR_TRXS.vat_invoice_date%TYPE;
692: -- ended, Harshita for bug#4245062
693:
694: lv_appl_src JAI_CMN_ERRORS_T.APPLICATION_SOURCE%type;
695: lv_err_msg JAI_CMN_ERRORS_T.error_message%type;
696:
697: ln_legal_entity_id NUMBER ; /* rallamse bug#4510143 */
698:
699: v_service_type VARCHAR2(30); -- added by csahoo for bug#5879769

Line 1846: lv_appl_src JAI_CMN_ERRORS_T.APPLICATION_SOURCE%type;

1842: rec_so_lines JA_SO_LINES_INFO%rowtype;
1843: ln_inv_orgn_id number ;
1844: ln_default_locn_id number;
1845:
1846: lv_appl_src JAI_CMN_ERRORS_T.APPLICATION_SOURCE%type;
1847: lv_err_msg JAI_CMN_ERRORS_T.ERROR_MESSAGE%type;
1848: lv_addl_msg JAI_CMN_ERRORS_T.ADDITIONAL_ERROR_MESG%type;
1849:
1850: ln_legal_entity_id NUMBER ; /* rallamse bug#4510143 */

Line 1847: lv_err_msg JAI_CMN_ERRORS_T.ERROR_MESSAGE%type;

1843: ln_inv_orgn_id number ;
1844: ln_default_locn_id number;
1845:
1846: lv_appl_src JAI_CMN_ERRORS_T.APPLICATION_SOURCE%type;
1847: lv_err_msg JAI_CMN_ERRORS_T.ERROR_MESSAGE%type;
1848: lv_addl_msg JAI_CMN_ERRORS_T.ADDITIONAL_ERROR_MESG%type;
1849:
1850: ln_legal_entity_id NUMBER ; /* rallamse bug#4510143 */
1851: -- Date 26-feb-2006 added by sacsethi for bug 5631784

Line 1848: lv_addl_msg JAI_CMN_ERRORS_T.ADDITIONAL_ERROR_MESG%type;

1844: ln_default_locn_id number;
1845:
1846: lv_appl_src JAI_CMN_ERRORS_T.APPLICATION_SOURCE%type;
1847: lv_err_msg JAI_CMN_ERRORS_T.ERROR_MESSAGE%type;
1848: lv_addl_msg JAI_CMN_ERRORS_T.ADDITIONAL_ERROR_MESG%type;
1849:
1850: ln_legal_entity_id NUMBER ; /* rallamse bug#4510143 */
1851: -- Date 26-feb-2006 added by sacsethi for bug 5631784
1852: --start 5631784

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

1936:
1937: if ln_default_locn_id is null then
1938:
1939: /*
1940: if the default location setup is not done , log this as a message in the JAI_CMN_ERRORS_T table
1941: do not stop the processing.
1942: We could still update the organization and location id in the JAI_AR_TRXS table later on (as a datafix)
1943: */
1944: lv_appl_src := 'JA_IN_OE_AR_LINES_INSERT_TRG' ;

Line 1948: insert into JAI_CMN_ERRORS_T

1944: lv_appl_src := 'JA_IN_OE_AR_LINES_INSERT_TRG' ;
1945: lv_err_msg := 'Default Location is not setup for Inventory Organization ' || pr_new.warehouse_id ;
1946: lv_addl_msg := 'Please setup the Default Location in Organization Additional Information Screen for Trx id : ' || pr_new.customer_trx_id ;
1947:
1948: insert into JAI_CMN_ERRORS_T
1949: (
1950: APPLICATION_SOURCE ,
1951: ERROR_MESSAGE ,
1952: ADDITIONAL_ERROR_MESG ,

Line 4128: INSERT INTO JAI_CMN_ERRORS_T

4124:
4125: lv_appl_src := 'JA_IN_OE_AR_LINES_INSERT_TRG' ;
4126: lv_err_msg := 'EXCEPTION Occured' ;
4127:
4128: INSERT INTO JAI_CMN_ERRORS_T
4129: (
4130: APPLICATION_SOURCE ,
4131: error_message ,
4132: additional_error_mesg ,

Line 5041: lv_appl_src JAI_CMN_ERRORS_T.APPLICATION_SOURCE%type ;

5037:
5038: ln_vat_assessable_value JAI_AR_TRX_LINES.VAT_ASSESSABLE_VALUE%TYPE;
5039:
5040: /* Added by Ramananda as a part of removal of SQL LITERALs , start */
5041: lv_appl_src JAI_CMN_ERRORS_T.APPLICATION_SOURCE%type ;
5042: lv_add_err JAI_CMN_ERRORS_T.additional_error_mesg%type ;
5043: BEGIN
5044: pv_return_code := jai_constants.successful ;
5045: /* This Trigger fires , when you insert a record in RA_CUSTOMER_TRX_LINES_ALL */

Line 5042: lv_add_err JAI_CMN_ERRORS_T.additional_error_mesg%type ;

5038: ln_vat_assessable_value JAI_AR_TRX_LINES.VAT_ASSESSABLE_VALUE%TYPE;
5039:
5040: /* Added by Ramananda as a part of removal of SQL LITERALs , start */
5041: lv_appl_src JAI_CMN_ERRORS_T.APPLICATION_SOURCE%type ;
5042: lv_add_err JAI_CMN_ERRORS_T.additional_error_mesg%type ;
5043: BEGIN
5044: pv_return_code := jai_constants.successful ;
5045: /* This Trigger fires , when you insert a record in RA_CUSTOMER_TRX_LINES_ALL */
5046:

Line 5507: INSERT INTO JAI_CMN_ERRORS_T

5503:
5504: lv_appl_src := 'JA_IN_AR_LINES_INSERT_TRG';
5505: 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) ;
5506:
5507: INSERT INTO JAI_CMN_ERRORS_T
5508: ( APPLICATION_SOURCE,
5509: error_message,
5510: additional_error_mesg,
5511: creation_date,