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_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 */

Line 203: FROM JAI_AR_TRX_INS_LINES_T

199: /*Bug 12792354*/
200: CURSOR c_temp_record_exists
201: IS
202: SELECT 1
203: FROM JAI_AR_TRX_INS_LINES_T
204: WHERE customer_trx_id = pr_new.customer_trx_id;
205:
206: ln_regime_id JAI_RGM_DEFINITIONS.REGIME_ID%TYPE ;
207: ln_regime_code JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE ;

Line 255: /Bug 12792354 - Check if data exists in JAI_AR_TRX_INS_LINES_T before proceeding to update CCID/

251: INTO ln_organization_id
252: , ln_location_id;
253: CLOSE cur_get_ar_hdr_info;
254:
255: /*Bug 12792354 - Check if data exists in JAI_AR_TRX_INS_LINES_T before proceeding to update CCID*/
256: OPEN c_temp_record_exists;
257: FETCH c_temp_record_exists INTO ln_exists;
258: IF c_temp_record_exists%FOUND THEN
259: IF pr_new.account_class = 'REV' THEN /*Bug 14121914*/

Line 332: UPDATE JAI_AR_TRX_INS_LINES_T

328: );
329: END IF;
330: END IF;-- ld_st_accrual_date < pr_new.gl_date
331:
332: UPDATE JAI_AR_TRX_INS_LINES_T
333: SET CODE_COMBINATION_ID = ln_ccid
334: WHERE customer_trx_id = pr_new.customer_trx_id
335: AND customer_trx_line_id = TAX_TYPE_REC.LINE_ID
336: AND link_to_cust_trx_line_id = pr_new.customer_trx_line_id;

Line 343: pv_return_message := 'Error found in the JAI_AR_TRX_INS_LINES_T, please check the table' ;

339: /*
340: IF SQL%ROWCOUNT <>1
341: THEN
342: pv_return_code := jai_constants.expected_error ;
343: pv_return_message := 'Error found in the JAI_AR_TRX_INS_LINES_T, please check the table' ;
344: END IF;
345: */
346: END IF; --(ln_regime_code =jai_constants.service_regime)
347: END LOOP;--TAX_TYPE_REC IN TAX_TYPE_CUR