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_CONSTANTS

Line 50: pv_return_code := jai_constants.successful ;

46:
47: ln_exists NUMBER;
48:
49: BEGIN
50: pv_return_code := jai_constants.successful ;
51: OPEN cur_get_temp_row;
52: FETCH cur_get_temp_row INTO ln_exists;
53: IF cur_get_temp_row%FOUND THEN
54: /*

Line 60: pv_return_code := jai_constants.expected_error ;

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 ;
64: CLOSE cur_get_temp_row;

Line 68: Pv_return_code := jai_constants.unexpected_error;

64: CLOSE cur_get_temp_row;
65: /* Added an exception block by Ramananda for bug#4570303 */
66: EXCEPTION
67: WHEN OTHERS THEN
68: Pv_return_code := jai_constants.unexpected_error;
69: Pv_return_message := 'Encountered an error in JAI_AR_GLDIST_TRIGGER_PKG.BRI_T1 ' || substr(sqlerrm,1,1900);
70: END BRI_T1 ;
71:
72: /********************************************************************************************************************************

Line 273: IF (ln_regime_code =jai_constants.service_regime)

269: OPEN c_get_org_loc;
270: FETCH c_get_org_loc INTO r_get_org_loc;
271: CLOSE c_get_org_loc;
272:
273: IF (ln_regime_code =jai_constants.service_regime)
274: THEN
275: OPEN cur_get_st_accrual_date(ln_regime_id, r_get_org_loc.organization_id, r_get_org_loc.location_id);
276: FETCH cur_get_st_accrual_date
277: INTO ld_st_accrual_date;

Line 291: IF lv_ar_trx_type <> jai_constants.ar_invoice_type_cm THEN

287:
288: /*Bug 14121914 - GL date can be NULL if Revenue Recognition is not run. Accrual Accounting to be used*/
289: IF (pr_new.gl_date>= ld_st_accrual_date OR pr_new.gl_date IS NULL)
290: THEN
291: IF lv_ar_trx_type <> jai_constants.ar_invoice_type_cm THEN
292: ln_ccid := jai_cmn_rgm_recording_pkg.get_account
293: ( p_regime_id => ln_regime_id
294: , p_organization_type => jai_constants.service_tax_orgn_type
295: , p_organization_id => ln_organization_id

Line 294: , p_organization_type => jai_constants.service_tax_orgn_type

290: THEN
291: IF lv_ar_trx_type <> jai_constants.ar_invoice_type_cm THEN
292: ln_ccid := jai_cmn_rgm_recording_pkg.get_account
293: ( p_regime_id => ln_regime_id
294: , p_organization_type => jai_constants.service_tax_orgn_type
295: , p_organization_id => ln_organization_id
296: , p_location_id => ln_location_id
297: , p_tax_type => tax_type_rec.t_type
298: , p_account_name => jai_constants.liability

Line 298: , p_account_name => jai_constants.liability

294: , p_organization_type => jai_constants.service_tax_orgn_type
295: , p_organization_id => ln_organization_id
296: , p_location_id => ln_location_id
297: , p_tax_type => tax_type_rec.t_type
298: , p_account_name => jai_constants.liability
299: );
300: ELSE
301: ln_ccid := jai_cmn_rgm_recording_pkg.get_account
302: ( p_regime_id => ln_regime_id

Line 303: , p_organization_type => jai_constants.service_tax_orgn_type

299: );
300: ELSE
301: ln_ccid := jai_cmn_rgm_recording_pkg.get_account
302: ( p_regime_id => ln_regime_id
303: , p_organization_type => jai_constants.service_tax_orgn_type
304: , p_organization_id => ln_organization_id
305: , p_location_id => ln_location_id
306: , p_tax_type => tax_type_rec.t_type
307: , p_account_name => jai_constants.recovery

Line 307: , p_account_name => jai_constants.recovery

303: , p_organization_type => jai_constants.service_tax_orgn_type
304: , p_organization_id => ln_organization_id
305: , p_location_id => ln_location_id
306: , p_tax_type => tax_type_rec.t_type
307: , p_account_name => jai_constants.recovery
308: );
309: END IF;
310: ELSE
311: IF lv_ar_trx_type <> jai_constants.ar_invoice_type_cm THEN

Line 311: IF lv_ar_trx_type <> jai_constants.ar_invoice_type_cm THEN

307: , p_account_name => jai_constants.recovery
308: );
309: END IF;
310: ELSE
311: IF lv_ar_trx_type <> jai_constants.ar_invoice_type_cm THEN
312: ln_ccid := jai_cmn_rgm_recording_pkg.get_account
313: ( p_regime_id => ln_regime_id
314: , p_organization_type => jai_constants.service_tax_orgn_type
315: , p_organization_id => ln_organization_id

Line 314: , p_organization_type => jai_constants.service_tax_orgn_type

310: ELSE
311: IF lv_ar_trx_type <> jai_constants.ar_invoice_type_cm THEN
312: ln_ccid := jai_cmn_rgm_recording_pkg.get_account
313: ( p_regime_id => ln_regime_id
314: , p_organization_type => jai_constants.service_tax_orgn_type
315: , p_organization_id => ln_organization_id
316: , p_location_id => ln_location_id
317: , p_tax_type => tax_type_rec.t_type
318: , p_account_name => jai_constants.liability_interim

Line 318: , p_account_name => jai_constants.liability_interim

314: , p_organization_type => jai_constants.service_tax_orgn_type
315: , p_organization_id => ln_organization_id
316: , p_location_id => ln_location_id
317: , p_tax_type => tax_type_rec.t_type
318: , p_account_name => jai_constants.liability_interim
319: );
320: ELSE
321: ln_ccid := jai_cmn_rgm_recording_pkg.get_account
322: ( p_regime_id => ln_regime_id

Line 323: , p_organization_type => jai_constants.service_tax_orgn_type

319: );
320: ELSE
321: ln_ccid := jai_cmn_rgm_recording_pkg.get_account
322: ( p_regime_id => ln_regime_id
323: , p_organization_type => jai_constants.service_tax_orgn_type
324: , p_organization_id => ln_organization_id
325: , p_location_id => ln_location_id
326: , p_tax_type => tax_type_rec.t_type
327: , p_account_name => jai_constants.recovery_interim

Line 327: , p_account_name => jai_constants.recovery_interim

323: , p_organization_type => jai_constants.service_tax_orgn_type
324: , p_organization_id => ln_organization_id
325: , p_location_id => ln_location_id
326: , p_tax_type => tax_type_rec.t_type
327: , p_account_name => jai_constants.recovery_interim
328: );
329: END IF;
330: END IF;-- ld_st_accrual_date < pr_new.gl_date
331:

Line 342: pv_return_code := jai_constants.expected_error ;

338: /*Bug 12792354 - It is not required to error out if no records are updated*/
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)

Line 346: END IF; --(ln_regime_code =jai_constants.service_regime)

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
348: END IF; /*Added IF pr_new.account_class = 'REV' THEN for Bug 14121914*/
349: END IF;
350: CLOSE c_temp_record_exists;

Line 367: IF (ln_regime_code =jai_constants.service_regime)

363: OPEN c_get_org_loc;
364: FETCH c_get_org_loc INTO r_get_org_loc;
365: CLOSE c_get_org_loc;
366:
367: IF (ln_regime_code =jai_constants.service_regime)
368: THEN
369: OPEN cur_get_st_accrual_date(ln_regime_id, r_get_org_loc.organization_id, r_get_org_loc.location_id);
370: FETCH cur_get_st_accrual_date
371: INTO ld_st_accrual_date;

Line 386: IF lv_ar_trx_type <> jai_constants.ar_invoice_type_cm THEN--Added by Wenqiong for Bug 14253668

382: get_rev_gl_date(ld_gl_date);
383:
384: IF (ld_gl_date >= ld_st_accrual_date OR ld_gl_date IS NULL)
385: THEN
386: IF lv_ar_trx_type <> jai_constants.ar_invoice_type_cm THEN--Added by Wenqiong for Bug 14253668
387: ln_ccid := jai_cmn_rgm_recording_pkg.get_account
388: ( p_regime_id => ln_regime_id
389: , p_organization_type => jai_constants.service_tax_orgn_type
390: , p_organization_id => ln_organization_id

Line 389: , p_organization_type => jai_constants.service_tax_orgn_type

385: THEN
386: IF lv_ar_trx_type <> jai_constants.ar_invoice_type_cm THEN--Added by Wenqiong for Bug 14253668
387: ln_ccid := jai_cmn_rgm_recording_pkg.get_account
388: ( p_regime_id => ln_regime_id
389: , p_organization_type => jai_constants.service_tax_orgn_type
390: , p_organization_id => ln_organization_id
391: , p_location_id => ln_location_id
392: , p_tax_type => tax_type_rec.t_type
393: , p_account_name => jai_constants.liability

Line 393: , p_account_name => jai_constants.liability

389: , p_organization_type => jai_constants.service_tax_orgn_type
390: , p_organization_id => ln_organization_id
391: , p_location_id => ln_location_id
392: , p_tax_type => tax_type_rec.t_type
393: , p_account_name => jai_constants.liability
394: );
395: --Added by Wenqiong for Bug 14253668 begin
396: ELSE
397: ln_ccid := jai_cmn_rgm_recording_pkg.get_account

Line 399: , p_organization_type => jai_constants.service_tax_orgn_type

395: --Added by Wenqiong for Bug 14253668 begin
396: ELSE
397: ln_ccid := jai_cmn_rgm_recording_pkg.get_account
398: ( p_regime_id => ln_regime_id
399: , p_organization_type => jai_constants.service_tax_orgn_type
400: , p_organization_id => ln_organization_id
401: , p_location_id => ln_location_id
402: , p_tax_type => tax_type_rec.t_type
403: , p_account_name => jai_constants.recovery

Line 403: , p_account_name => jai_constants.recovery

399: , p_organization_type => jai_constants.service_tax_orgn_type
400: , p_organization_id => ln_organization_id
401: , p_location_id => ln_location_id
402: , p_tax_type => tax_type_rec.t_type
403: , p_account_name => jai_constants.recovery
404: );
405: END IF;
406: --Added by Wenqiong for Bug 14253668 end
407: ELSE

Line 408: IF lv_ar_trx_type <> jai_constants.ar_invoice_type_cm THEN--Added by Wenqiong for Bug 14253668

404: );
405: END IF;
406: --Added by Wenqiong for Bug 14253668 end
407: ELSE
408: IF lv_ar_trx_type <> jai_constants.ar_invoice_type_cm THEN--Added by Wenqiong for Bug 14253668
409: ln_ccid := jai_cmn_rgm_recording_pkg.get_account
410: ( p_regime_id => ln_regime_id
411: , p_organization_type => jai_constants.service_tax_orgn_type
412: , p_organization_id => ln_organization_id

Line 411: , p_organization_type => jai_constants.service_tax_orgn_type

407: ELSE
408: IF lv_ar_trx_type <> jai_constants.ar_invoice_type_cm THEN--Added by Wenqiong for Bug 14253668
409: ln_ccid := jai_cmn_rgm_recording_pkg.get_account
410: ( p_regime_id => ln_regime_id
411: , p_organization_type => jai_constants.service_tax_orgn_type
412: , p_organization_id => ln_organization_id
413: , p_location_id => ln_location_id
414: , p_tax_type => tax_type_rec.t_type
415: , p_account_name => jai_constants.liability_interim

Line 415: , p_account_name => jai_constants.liability_interim

411: , p_organization_type => jai_constants.service_tax_orgn_type
412: , p_organization_id => ln_organization_id
413: , p_location_id => ln_location_id
414: , p_tax_type => tax_type_rec.t_type
415: , p_account_name => jai_constants.liability_interim
416: );
417: --Added by Wenqiong for Bug 14253668 begin
418: ELSE
419: ln_ccid := jai_cmn_rgm_recording_pkg.get_account

Line 421: , p_organization_type => jai_constants.service_tax_orgn_type

417: --Added by Wenqiong for Bug 14253668 begin
418: ELSE
419: ln_ccid := jai_cmn_rgm_recording_pkg.get_account
420: ( p_regime_id => ln_regime_id
421: , p_organization_type => jai_constants.service_tax_orgn_type
422: , p_organization_id => ln_organization_id
423: , p_location_id => ln_location_id
424: , p_tax_type => tax_type_rec.t_type
425: , p_account_name => jai_constants.recovery_interim

Line 425: , p_account_name => jai_constants.recovery_interim

421: , p_organization_type => jai_constants.service_tax_orgn_type
422: , p_organization_id => ln_organization_id
423: , p_location_id => ln_location_id
424: , p_tax_type => tax_type_rec.t_type
425: , p_account_name => jai_constants.recovery_interim
426: );
427: END IF;
428: --Added by Wenqiong for Bug 14253668 end
429: END IF;

Line 433: END IF; --(ln_regime_code =jai_constants.service_regime)

429: END IF;
430:
431: pn_ccid := ln_ccid;
432:
433: END IF; --(ln_regime_code =jai_constants.service_regime)
434: END LOOP;--TAX_TYPE_REC IN cur_get_tax_row
435: END IF;
436: /*Bug 14121914 - Update CCID of the Tax Lines - End*/
437:

Line 441: Pv_return_code := jai_constants.unexpected_error;

437:
438: EXCEPTION
439: WHEN OTHERS
440: THEN
441: Pv_return_code := jai_constants.unexpected_error;
442: Pv_return_message := 'Encountered an error in JAI_AR_GLDIST_TRIGGER_PKG.BRI_T2 ' || substr(sqlerrm,1,1900);
443: END BRI_T2;
444: END JAI_AR_GLDIST_TRIGGER_PKG ;