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.GL_BIS_ALERTS_PKG dependencies on FND_MESSAGE

Line 470: FND_MESSAGE.set_name('SQLGL', 'GL_BIS_REVPMF_ABOVE_SUBJECT');

466: WHERE dl.dimension_level_short_name = c_gl_sm;
467: END IF;
468:
469: IF p_type = 'ABOVE' THEN
470: FND_MESSAGE.set_name('SQLGL', 'GL_BIS_REVPMF_ABOVE_SUBJECT');
471: FND_MESSAGE.set_token('PERIOD_NAME', g_period_name);
472: FND_MESSAGE.set_token('DIM1_NAME', l_dim1_name);
473: FND_MESSAGE.set_token('DIM2_NAME', l_dim2_name);
474: FND_MESSAGE.set_token('ACTUAL', abs(p_actual));

Line 471: FND_MESSAGE.set_token('PERIOD_NAME', g_period_name);

467: END IF;
468:
469: IF p_type = 'ABOVE' THEN
470: FND_MESSAGE.set_name('SQLGL', 'GL_BIS_REVPMF_ABOVE_SUBJECT');
471: FND_MESSAGE.set_token('PERIOD_NAME', g_period_name);
472: FND_MESSAGE.set_token('DIM1_NAME', l_dim1_name);
473: FND_MESSAGE.set_token('DIM2_NAME', l_dim2_name);
474: FND_MESSAGE.set_token('ACTUAL', abs(p_actual));
475: FND_MESSAGE.set_token('TARGET', abs(p_target));

Line 472: FND_MESSAGE.set_token('DIM1_NAME', l_dim1_name);

468:
469: IF p_type = 'ABOVE' THEN
470: FND_MESSAGE.set_name('SQLGL', 'GL_BIS_REVPMF_ABOVE_SUBJECT');
471: FND_MESSAGE.set_token('PERIOD_NAME', g_period_name);
472: FND_MESSAGE.set_token('DIM1_NAME', l_dim1_name);
473: FND_MESSAGE.set_token('DIM2_NAME', l_dim2_name);
474: FND_MESSAGE.set_token('ACTUAL', abs(p_actual));
475: FND_MESSAGE.set_token('TARGET', abs(p_target));
476: l_subject := FND_MESSAGE.get;

Line 473: FND_MESSAGE.set_token('DIM2_NAME', l_dim2_name);

469: IF p_type = 'ABOVE' THEN
470: FND_MESSAGE.set_name('SQLGL', 'GL_BIS_REVPMF_ABOVE_SUBJECT');
471: FND_MESSAGE.set_token('PERIOD_NAME', g_period_name);
472: FND_MESSAGE.set_token('DIM1_NAME', l_dim1_name);
473: FND_MESSAGE.set_token('DIM2_NAME', l_dim2_name);
474: FND_MESSAGE.set_token('ACTUAL', abs(p_actual));
475: FND_MESSAGE.set_token('TARGET', abs(p_target));
476: l_subject := FND_MESSAGE.get;
477: FND_MESSAGE.set_name('SQLGL', 'GL_BIS_REVPMF_ABOVE_MESSAGE');

Line 474: FND_MESSAGE.set_token('ACTUAL', abs(p_actual));

470: FND_MESSAGE.set_name('SQLGL', 'GL_BIS_REVPMF_ABOVE_SUBJECT');
471: FND_MESSAGE.set_token('PERIOD_NAME', g_period_name);
472: FND_MESSAGE.set_token('DIM1_NAME', l_dim1_name);
473: FND_MESSAGE.set_token('DIM2_NAME', l_dim2_name);
474: FND_MESSAGE.set_token('ACTUAL', abs(p_actual));
475: FND_MESSAGE.set_token('TARGET', abs(p_target));
476: l_subject := FND_MESSAGE.get;
477: FND_MESSAGE.set_name('SQLGL', 'GL_BIS_REVPMF_ABOVE_MESSAGE');
478:

Line 475: FND_MESSAGE.set_token('TARGET', abs(p_target));

471: FND_MESSAGE.set_token('PERIOD_NAME', g_period_name);
472: FND_MESSAGE.set_token('DIM1_NAME', l_dim1_name);
473: FND_MESSAGE.set_token('DIM2_NAME', l_dim2_name);
474: FND_MESSAGE.set_token('ACTUAL', abs(p_actual));
475: FND_MESSAGE.set_token('TARGET', abs(p_target));
476: l_subject := FND_MESSAGE.get;
477: FND_MESSAGE.set_name('SQLGL', 'GL_BIS_REVPMF_ABOVE_MESSAGE');
478:
479: ELSE

Line 476: l_subject := FND_MESSAGE.get;

472: FND_MESSAGE.set_token('DIM1_NAME', l_dim1_name);
473: FND_MESSAGE.set_token('DIM2_NAME', l_dim2_name);
474: FND_MESSAGE.set_token('ACTUAL', abs(p_actual));
475: FND_MESSAGE.set_token('TARGET', abs(p_target));
476: l_subject := FND_MESSAGE.get;
477: FND_MESSAGE.set_name('SQLGL', 'GL_BIS_REVPMF_ABOVE_MESSAGE');
478:
479: ELSE
480: FND_MESSAGE.set_name('SQLGL', 'GL_BIS_REVPMF_BELOW_SUBJECT');

Line 477: FND_MESSAGE.set_name('SQLGL', 'GL_BIS_REVPMF_ABOVE_MESSAGE');

473: FND_MESSAGE.set_token('DIM2_NAME', l_dim2_name);
474: FND_MESSAGE.set_token('ACTUAL', abs(p_actual));
475: FND_MESSAGE.set_token('TARGET', abs(p_target));
476: l_subject := FND_MESSAGE.get;
477: FND_MESSAGE.set_name('SQLGL', 'GL_BIS_REVPMF_ABOVE_MESSAGE');
478:
479: ELSE
480: FND_MESSAGE.set_name('SQLGL', 'GL_BIS_REVPMF_BELOW_SUBJECT');
481: FND_MESSAGE.set_token('PERIOD_NAME', g_period_name);

Line 480: FND_MESSAGE.set_name('SQLGL', 'GL_BIS_REVPMF_BELOW_SUBJECT');

476: l_subject := FND_MESSAGE.get;
477: FND_MESSAGE.set_name('SQLGL', 'GL_BIS_REVPMF_ABOVE_MESSAGE');
478:
479: ELSE
480: FND_MESSAGE.set_name('SQLGL', 'GL_BIS_REVPMF_BELOW_SUBJECT');
481: FND_MESSAGE.set_token('PERIOD_NAME', g_period_name);
482: FND_MESSAGE.set_token('DIM1_NAME', l_dim1_name);
483: FND_MESSAGE.set_token('DIM2_NAME', l_dim2_name);
484: FND_MESSAGE.set_token('ACTUAL', abs(p_actual));

Line 481: FND_MESSAGE.set_token('PERIOD_NAME', g_period_name);

477: FND_MESSAGE.set_name('SQLGL', 'GL_BIS_REVPMF_ABOVE_MESSAGE');
478:
479: ELSE
480: FND_MESSAGE.set_name('SQLGL', 'GL_BIS_REVPMF_BELOW_SUBJECT');
481: FND_MESSAGE.set_token('PERIOD_NAME', g_period_name);
482: FND_MESSAGE.set_token('DIM1_NAME', l_dim1_name);
483: FND_MESSAGE.set_token('DIM2_NAME', l_dim2_name);
484: FND_MESSAGE.set_token('ACTUAL', abs(p_actual));
485: FND_MESSAGE.set_token('TARGET', abs(p_target));

Line 482: FND_MESSAGE.set_token('DIM1_NAME', l_dim1_name);

478:
479: ELSE
480: FND_MESSAGE.set_name('SQLGL', 'GL_BIS_REVPMF_BELOW_SUBJECT');
481: FND_MESSAGE.set_token('PERIOD_NAME', g_period_name);
482: FND_MESSAGE.set_token('DIM1_NAME', l_dim1_name);
483: FND_MESSAGE.set_token('DIM2_NAME', l_dim2_name);
484: FND_MESSAGE.set_token('ACTUAL', abs(p_actual));
485: FND_MESSAGE.set_token('TARGET', abs(p_target));
486: l_subject := FND_MESSAGE.get;

Line 483: FND_MESSAGE.set_token('DIM2_NAME', l_dim2_name);

479: ELSE
480: FND_MESSAGE.set_name('SQLGL', 'GL_BIS_REVPMF_BELOW_SUBJECT');
481: FND_MESSAGE.set_token('PERIOD_NAME', g_period_name);
482: FND_MESSAGE.set_token('DIM1_NAME', l_dim1_name);
483: FND_MESSAGE.set_token('DIM2_NAME', l_dim2_name);
484: FND_MESSAGE.set_token('ACTUAL', abs(p_actual));
485: FND_MESSAGE.set_token('TARGET', abs(p_target));
486: l_subject := FND_MESSAGE.get;
487: FND_MESSAGE.set_name('SQLGL', 'GL_BIS_REVPMF_BELOW_MESSAGE');

Line 484: FND_MESSAGE.set_token('ACTUAL', abs(p_actual));

480: FND_MESSAGE.set_name('SQLGL', 'GL_BIS_REVPMF_BELOW_SUBJECT');
481: FND_MESSAGE.set_token('PERIOD_NAME', g_period_name);
482: FND_MESSAGE.set_token('DIM1_NAME', l_dim1_name);
483: FND_MESSAGE.set_token('DIM2_NAME', l_dim2_name);
484: FND_MESSAGE.set_token('ACTUAL', abs(p_actual));
485: FND_MESSAGE.set_token('TARGET', abs(p_target));
486: l_subject := FND_MESSAGE.get;
487: FND_MESSAGE.set_name('SQLGL', 'GL_BIS_REVPMF_BELOW_MESSAGE');
488: END IF;

Line 485: FND_MESSAGE.set_token('TARGET', abs(p_target));

481: FND_MESSAGE.set_token('PERIOD_NAME', g_period_name);
482: FND_MESSAGE.set_token('DIM1_NAME', l_dim1_name);
483: FND_MESSAGE.set_token('DIM2_NAME', l_dim2_name);
484: FND_MESSAGE.set_token('ACTUAL', abs(p_actual));
485: FND_MESSAGE.set_token('TARGET', abs(p_target));
486: l_subject := FND_MESSAGE.get;
487: FND_MESSAGE.set_name('SQLGL', 'GL_BIS_REVPMF_BELOW_MESSAGE');
488: END IF;
489:

Line 486: l_subject := FND_MESSAGE.get;

482: FND_MESSAGE.set_token('DIM1_NAME', l_dim1_name);
483: FND_MESSAGE.set_token('DIM2_NAME', l_dim2_name);
484: FND_MESSAGE.set_token('ACTUAL', abs(p_actual));
485: FND_MESSAGE.set_token('TARGET', abs(p_target));
486: l_subject := FND_MESSAGE.get;
487: FND_MESSAGE.set_name('SQLGL', 'GL_BIS_REVPMF_BELOW_MESSAGE');
488: END IF;
489:
490: FND_MESSAGE.set_token('SET_OF_BOOKS_NAME', p_sob_name);

Line 487: FND_MESSAGE.set_name('SQLGL', 'GL_BIS_REVPMF_BELOW_MESSAGE');

483: FND_MESSAGE.set_token('DIM2_NAME', l_dim2_name);
484: FND_MESSAGE.set_token('ACTUAL', abs(p_actual));
485: FND_MESSAGE.set_token('TARGET', abs(p_target));
486: l_subject := FND_MESSAGE.get;
487: FND_MESSAGE.set_name('SQLGL', 'GL_BIS_REVPMF_BELOW_MESSAGE');
488: END IF;
489:
490: FND_MESSAGE.set_token('SET_OF_BOOKS_NAME', p_sob_name);
491: FND_MESSAGE.set_token('PERIOD_NAME', g_period_name);

Line 490: FND_MESSAGE.set_token('SET_OF_BOOKS_NAME', p_sob_name);

486: l_subject := FND_MESSAGE.get;
487: FND_MESSAGE.set_name('SQLGL', 'GL_BIS_REVPMF_BELOW_MESSAGE');
488: END IF;
489:
490: FND_MESSAGE.set_token('SET_OF_BOOKS_NAME', p_sob_name);
491: FND_MESSAGE.set_token('PERIOD_NAME', g_period_name);
492: FND_MESSAGE.set_token('DIM1_VALUE', l_dim1_value);
493: FND_MESSAGE.set_token('DIM2_VALUE', l_dim2_value);
494: FND_MESSAGE.set_token('ACTUAL', abs(p_actual));

Line 491: FND_MESSAGE.set_token('PERIOD_NAME', g_period_name);

487: FND_MESSAGE.set_name('SQLGL', 'GL_BIS_REVPMF_BELOW_MESSAGE');
488: END IF;
489:
490: FND_MESSAGE.set_token('SET_OF_BOOKS_NAME', p_sob_name);
491: FND_MESSAGE.set_token('PERIOD_NAME', g_period_name);
492: FND_MESSAGE.set_token('DIM1_VALUE', l_dim1_value);
493: FND_MESSAGE.set_token('DIM2_VALUE', l_dim2_value);
494: FND_MESSAGE.set_token('ACTUAL', abs(p_actual));
495: FND_MESSAGE.set_token('TARGET', abs(p_target));

Line 492: FND_MESSAGE.set_token('DIM1_VALUE', l_dim1_value);

488: END IF;
489:
490: FND_MESSAGE.set_token('SET_OF_BOOKS_NAME', p_sob_name);
491: FND_MESSAGE.set_token('PERIOD_NAME', g_period_name);
492: FND_MESSAGE.set_token('DIM1_VALUE', l_dim1_value);
493: FND_MESSAGE.set_token('DIM2_VALUE', l_dim2_value);
494: FND_MESSAGE.set_token('ACTUAL', abs(p_actual));
495: FND_MESSAGE.set_token('TARGET', abs(p_target));
496: FND_MESSAGE.set_token('VARIANCE', (p_target - p_actual));

Line 493: FND_MESSAGE.set_token('DIM2_VALUE', l_dim2_value);

489:
490: FND_MESSAGE.set_token('SET_OF_BOOKS_NAME', p_sob_name);
491: FND_MESSAGE.set_token('PERIOD_NAME', g_period_name);
492: FND_MESSAGE.set_token('DIM1_VALUE', l_dim1_value);
493: FND_MESSAGE.set_token('DIM2_VALUE', l_dim2_value);
494: FND_MESSAGE.set_token('ACTUAL', abs(p_actual));
495: FND_MESSAGE.set_token('TARGET', abs(p_target));
496: FND_MESSAGE.set_token('VARIANCE', (p_target - p_actual));
497: FND_MESSAGE.set_token('VPERCENT', l_variance_percent);

Line 494: FND_MESSAGE.set_token('ACTUAL', abs(p_actual));

490: FND_MESSAGE.set_token('SET_OF_BOOKS_NAME', p_sob_name);
491: FND_MESSAGE.set_token('PERIOD_NAME', g_period_name);
492: FND_MESSAGE.set_token('DIM1_VALUE', l_dim1_value);
493: FND_MESSAGE.set_token('DIM2_VALUE', l_dim2_value);
494: FND_MESSAGE.set_token('ACTUAL', abs(p_actual));
495: FND_MESSAGE.set_token('TARGET', abs(p_target));
496: FND_MESSAGE.set_token('VARIANCE', (p_target - p_actual));
497: FND_MESSAGE.set_token('VPERCENT', l_variance_percent);
498: FND_MESSAGE.set_token('VRANGE_LOW', p_range_low);

Line 495: FND_MESSAGE.set_token('TARGET', abs(p_target));

491: FND_MESSAGE.set_token('PERIOD_NAME', g_period_name);
492: FND_MESSAGE.set_token('DIM1_VALUE', l_dim1_value);
493: FND_MESSAGE.set_token('DIM2_VALUE', l_dim2_value);
494: FND_MESSAGE.set_token('ACTUAL', abs(p_actual));
495: FND_MESSAGE.set_token('TARGET', abs(p_target));
496: FND_MESSAGE.set_token('VARIANCE', (p_target - p_actual));
497: FND_MESSAGE.set_token('VPERCENT', l_variance_percent);
498: FND_MESSAGE.set_token('VRANGE_LOW', p_range_low);
499: FND_MESSAGE.set_token('VRANGE_HIGH', p_range_high);

Line 496: FND_MESSAGE.set_token('VARIANCE', (p_target - p_actual));

492: FND_MESSAGE.set_token('DIM1_VALUE', l_dim1_value);
493: FND_MESSAGE.set_token('DIM2_VALUE', l_dim2_value);
494: FND_MESSAGE.set_token('ACTUAL', abs(p_actual));
495: FND_MESSAGE.set_token('TARGET', abs(p_target));
496: FND_MESSAGE.set_token('VARIANCE', (p_target - p_actual));
497: FND_MESSAGE.set_token('VPERCENT', l_variance_percent);
498: FND_MESSAGE.set_token('VRANGE_LOW', p_range_low);
499: FND_MESSAGE.set_token('VRANGE_HIGH', p_range_high);
500: l_message := FND_MESSAGE.get;

Line 497: FND_MESSAGE.set_token('VPERCENT', l_variance_percent);

493: FND_MESSAGE.set_token('DIM2_VALUE', l_dim2_value);
494: FND_MESSAGE.set_token('ACTUAL', abs(p_actual));
495: FND_MESSAGE.set_token('TARGET', abs(p_target));
496: FND_MESSAGE.set_token('VARIANCE', (p_target - p_actual));
497: FND_MESSAGE.set_token('VPERCENT', l_variance_percent);
498: FND_MESSAGE.set_token('VRANGE_LOW', p_range_low);
499: FND_MESSAGE.set_token('VRANGE_HIGH', p_range_high);
500: l_message := FND_MESSAGE.get;
501:

Line 498: FND_MESSAGE.set_token('VRANGE_LOW', p_range_low);

494: FND_MESSAGE.set_token('ACTUAL', abs(p_actual));
495: FND_MESSAGE.set_token('TARGET', abs(p_target));
496: FND_MESSAGE.set_token('VARIANCE', (p_target - p_actual));
497: FND_MESSAGE.set_token('VPERCENT', l_variance_percent);
498: FND_MESSAGE.set_token('VRANGE_LOW', p_range_low);
499: FND_MESSAGE.set_token('VRANGE_HIGH', p_range_high);
500: l_message := FND_MESSAGE.get;
501:
502: l_param := 'P_REPORT_ID=REVENUE*P_TARGET_PERIOD=' || g_period_name ||

Line 499: FND_MESSAGE.set_token('VRANGE_HIGH', p_range_high);

495: FND_MESSAGE.set_token('TARGET', abs(p_target));
496: FND_MESSAGE.set_token('VARIANCE', (p_target - p_actual));
497: FND_MESSAGE.set_token('VPERCENT', l_variance_percent);
498: FND_MESSAGE.set_token('VRANGE_LOW', p_range_low);
499: FND_MESSAGE.set_token('VRANGE_HIGH', p_range_high);
500: l_message := FND_MESSAGE.get;
501:
502: l_param := 'P_REPORT_ID=REVENUE*P_TARGET_PERIOD=' || g_period_name ||
503: '*P_DRILLDOWN_LEVEL=';

Line 500: l_message := FND_MESSAGE.get;

496: FND_MESSAGE.set_token('VARIANCE', (p_target - p_actual));
497: FND_MESSAGE.set_token('VPERCENT', l_variance_percent);
498: FND_MESSAGE.set_token('VRANGE_LOW', p_range_low);
499: FND_MESSAGE.set_token('VRANGE_HIGH', p_range_high);
500: l_message := FND_MESSAGE.get;
501:
502: l_param := 'P_REPORT_ID=REVENUE*P_TARGET_PERIOD=' || g_period_name ||
503: '*P_DRILLDOWN_LEVEL=';
504: IF p_dim1_id = '-1' THEN

Line 534: g_msg_buf := FND_MESSAGE.get_string('SQLGL','GL_BIS_REVPMF_MESSAGE_ERROR');

530: END IF;
531:
532: EXCEPTION
533: WHEN send_notification_error THEN
534: g_msg_buf := FND_MESSAGE.get_string('SQLGL','GL_BIS_REVPMF_MESSAGE_ERROR');
535: -- dbms_output.put_line(g_msg_buf);
536: WHEN OTHERS THEN
537: -- dbms_output.put_line(g_msg_buf);
538: null;

Line 577: g_msg_buf := FND_MESSAGE.get_string('SQLGL', 'GL_BIS_REVPMF_START');

573: -- BELOW - actual < target
574:
575: BEGIN
576:
577: g_msg_buf := FND_MESSAGE.get_string('SQLGL', 'GL_BIS_REVPMF_START');
578: -- dbms_output.put_line(g_msg_buf);
579:
580: g_old_org_id := '-1';
581: get_period_info(

Line 645: g_msg_buf := FND_MESSAGE.get_string('SQLGL',

641: ELSE
642: l_type := 'ABOVE';
643: END IF;
644: ELSE
645: g_msg_buf := FND_MESSAGE.get_string('SQLGL',
646: 'GL_BIS_REVPMF_NO_REVENUE');
647: --dbms_output.put_line(g_msg_buf);
648: END IF;
649:

Line 729: g_msg_buf := FND_MESSAGE.get_string('SQLGL', 'GL_BIS_REVPMF_SUCCESS');

725:
726: CLOSE c_target_rec;
727:
728: END LOOP; -- Loop through target levels
729: g_msg_buf := FND_MESSAGE.get_string('SQLGL', 'GL_BIS_REVPMF_SUCCESS');
730: -- dbms_output.put_line(g_msg_buf);
731:
732: EXCEPTION WHEN OTHERS THEN
733: /* dbms_output.put_line('Error!!! -> ' || substrb(SQLERRM, 1, 230));

Line 741: g_msg_buf := FND_MESSAGE.get_string('SQLGL', 'GL_BIS_REVPMF_EXCEPTION');

737: dbms_output.put_line(substrb(trg_select, 246, 245));
738: dbms_output.put_line(substrb(trg_select, 491, 245));
739: dbms_output.put_line('=========================='); */
740:
741: g_msg_buf := FND_MESSAGE.get_string('SQLGL', 'GL_BIS_REVPMF_EXCEPTION');
742: -- dbms_output.put_line(g_msg_buf);
743:
744: END check_revenue;
745: