APPS.JAI_AR_GLDIST_TRIGGER_PKG dependencies on JAI_AR_TRX_INS_LINES_T

Line 26: Purpose : Stop the Ar Posting To GL (General Ledger Transfer Program) from posting if data for the invoice exists in JAI_AR_TRX_INS_LINES_T.

22: Created Date: 11-Nov-2005
23:
24: Bug : 4727534
25:
26: Purpose : Stop the Ar Posting To GL (General Ledger Transfer Program) from posting if data for the invoice exists in JAI_AR_TRX_INS_LINES_T.
27: indicating that user did not/forgot to run the India Local Concurrent Program.
28: Here data is being posted from ra_cust_trx_line_gl_dist_all to gl_interface.
29:
30: ********************************************************************************************************************************/

Line 42: JAI_AR_TRX_INS_LINES_T

38: IS
39: SELECT
40: 1
41: FROM
42: JAI_AR_TRX_INS_LINES_T
43: WHERE
44: customer_trx_id = pr_new.customer_trx_id
45: AND error_flag <> 'D'; /* Modified by Ramananda for removal of SQL LITERALs */
46:

Line 55: ||Data found in JAI_AR_TRX_INS_LINES_T , India Local concurrent has not been run for this invoice.

51: OPEN cur_get_temp_row;
52: FETCH cur_get_temp_row INTO ln_exists;
53: IF cur_get_temp_row%FOUND THEN
54: /*
55: ||Data found in JAI_AR_TRX_INS_LINES_T , India Local concurrent has not been run for this invoice.
56: ||Stop the posting to gl_interface
57: */
58: CLOSE cur_get_temp_row;
59: /* raise_application_error (-20131,'IL Taxes found in JAI_AR_TRX_INS_LINES_T table. Please run the India Local Concurrent Program and then post the record into GL');*/

Line 59: /* raise_application_error (-20131,'IL Taxes found in JAI_AR_TRX_INS_LINES_T table. Please run the India Local Concurrent Program and then post the record into GL');*/

55: ||Data found in JAI_AR_TRX_INS_LINES_T , India Local concurrent has not been run for this invoice.
56: ||Stop the posting to gl_interface
57: */
58: CLOSE cur_get_temp_row;
59: /* raise_application_error (-20131,'IL Taxes found in JAI_AR_TRX_INS_LINES_T table. Please run the India Local Concurrent Program and then post the record into GL');*/
60: pv_return_code := jai_constants.expected_error ;
61: pv_return_message := 'IL Taxes found in JAI_AR_TRX_INS_LINES_T table. Please run the India Local Concurrent Program and then post the record into GL' ;
62: return ;
63: END IF ;

Line 61: pv_return_message := 'IL Taxes found in JAI_AR_TRX_INS_LINES_T table. Please run the India Local Concurrent Program and then post the record into GL' ;

57: */
58: CLOSE cur_get_temp_row;
59: /* raise_application_error (-20131,'IL Taxes found in JAI_AR_TRX_INS_LINES_T table. Please run the India Local Concurrent Program and then post the record into GL');*/
60: pv_return_code := jai_constants.expected_error ;
61: pv_return_message := 'IL Taxes found in JAI_AR_TRX_INS_LINES_T table. Please run the India Local Concurrent Program and then post the record into GL' ;
62: return ;
63: END IF ;
64: CLOSE cur_get_temp_row;
65: /* Added an exception block by Ramananda for bug#4570303 */