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

Line 2022: fnd_message.set_name('OTA', 'OTA_443358_SRCH_LO_TIME');

2018: Else
2019: l_formatted_sec := l_Seconds;
2020: End If;
2021:
2022: fnd_message.set_name('OTA', 'OTA_443358_SRCH_LO_TIME');
2023: fnd_message.set_token ('HOUR', l_formatted_hour);
2024: fnd_message.set_token ('MIN', l_formatted_min);
2025: fnd_message.set_token ('SEC', l_formatted_sec);
2026: l_formatted_time := fnd_message.get();

Line 2023: fnd_message.set_token ('HOUR', l_formatted_hour);

2019: l_formatted_sec := l_Seconds;
2020: End If;
2021:
2022: fnd_message.set_name('OTA', 'OTA_443358_SRCH_LO_TIME');
2023: fnd_message.set_token ('HOUR', l_formatted_hour);
2024: fnd_message.set_token ('MIN', l_formatted_min);
2025: fnd_message.set_token ('SEC', l_formatted_sec);
2026: l_formatted_time := fnd_message.get();
2027:

Line 2024: fnd_message.set_token ('MIN', l_formatted_min);

2020: End If;
2021:
2022: fnd_message.set_name('OTA', 'OTA_443358_SRCH_LO_TIME');
2023: fnd_message.set_token ('HOUR', l_formatted_hour);
2024: fnd_message.set_token ('MIN', l_formatted_min);
2025: fnd_message.set_token ('SEC', l_formatted_sec);
2026: l_formatted_time := fnd_message.get();
2027:
2028: if p_active_cert_flag = 'Y' then

Line 2025: fnd_message.set_token ('SEC', l_formatted_sec);

2021:
2022: fnd_message.set_name('OTA', 'OTA_443358_SRCH_LO_TIME');
2023: fnd_message.set_token ('HOUR', l_formatted_hour);
2024: fnd_message.set_token ('MIN', l_formatted_min);
2025: fnd_message.set_token ('SEC', l_formatted_sec);
2026: l_formatted_time := fnd_message.get();
2027:
2028: if p_active_cert_flag = 'Y' then
2029: fnd_message.set_name('OTA', 'OTA_443968_SRCH_TREE_TITLE3');

Line 2026: l_formatted_time := fnd_message.get();

2022: fnd_message.set_name('OTA', 'OTA_443358_SRCH_LO_TIME');
2023: fnd_message.set_token ('HOUR', l_formatted_hour);
2024: fnd_message.set_token ('MIN', l_formatted_min);
2025: fnd_message.set_token ('SEC', l_formatted_sec);
2026: l_formatted_time := fnd_message.get();
2027:
2028: if p_active_cert_flag = 'Y' then
2029: fnd_message.set_name('OTA', 'OTA_443968_SRCH_TREE_TITLE3');
2030: elsif ((l_lo_score is null) or (l_lo_score < 0)) Then

Line 2029: fnd_message.set_name('OTA', 'OTA_443968_SRCH_TREE_TITLE3');

2025: fnd_message.set_token ('SEC', l_formatted_sec);
2026: l_formatted_time := fnd_message.get();
2027:
2028: if p_active_cert_flag = 'Y' then
2029: fnd_message.set_name('OTA', 'OTA_443968_SRCH_TREE_TITLE3');
2030: elsif ((l_lo_score is null) or (l_lo_score < 0)) Then
2031: fnd_message.set_name('OTA', 'OTA_443453_SRCH_TREE_TITLE2');
2032: Else
2033: --Added for bug 3550407

Line 2031: fnd_message.set_name('OTA', 'OTA_443453_SRCH_TREE_TITLE2');

2027:
2028: if p_active_cert_flag = 'Y' then
2029: fnd_message.set_name('OTA', 'OTA_443968_SRCH_TREE_TITLE3');
2030: elsif ((l_lo_score is null) or (l_lo_score < 0)) Then
2031: fnd_message.set_name('OTA', 'OTA_443453_SRCH_TREE_TITLE2');
2032: Else
2033: --Added for bug 3550407
2034: IF ( l_tst_grade_flag = 'P' ) THEN
2035: l_var_score := l_lo_score||'%';

Line 2040: fnd_message.set_name('OTA', 'OTA_443357_SRCH_TREE_TITLE');

2036: ELSE
2037: l_var_score := l_lo_score;
2038: END IF;
2039:
2040: fnd_message.set_name('OTA', 'OTA_443357_SRCH_TREE_TITLE');
2041: fnd_message.set_token ('SCORE', l_var_score);
2042: End If;
2043:
2044: If ( (l_lo_lesson_status = 'C' or l_lo_lesson_status = 'P')

Line 2041: fnd_message.set_token ('SCORE', l_var_score);

2037: l_var_score := l_lo_score;
2038: END IF;
2039:
2040: fnd_message.set_name('OTA', 'OTA_443357_SRCH_TREE_TITLE');
2041: fnd_message.set_token ('SCORE', l_var_score);
2042: End If;
2043:
2044: If ( (l_lo_lesson_status = 'C' or l_lo_lesson_status = 'P')
2045: and l_lo_completed_date is not null ) Then

Line 2051: fnd_message.set_token ('LO_NAME', l_lo_name);

2047: End If;
2048:
2049: --if this is part of active cert prd, return status as "Not Applicable"
2050: if p_active_cert_flag = 'Y' then
2051: fnd_message.set_token ('LO_NAME', l_lo_name);
2052: fnd_message.set_token ('STATUS', hr_general_utilities.get_lookup_meaning('OTA_CONTENT_PLAYER_STATUS','D'));
2053: else
2054: fnd_message.set_token ('LO_NAME', l_lo_name);
2055: fnd_message.set_token ('STATUS', l_lo_status);

Line 2052: fnd_message.set_token ('STATUS', hr_general_utilities.get_lookup_meaning('OTA_CONTENT_PLAYER_STATUS','D'));

2048:
2049: --if this is part of active cert prd, return status as "Not Applicable"
2050: if p_active_cert_flag = 'Y' then
2051: fnd_message.set_token ('LO_NAME', l_lo_name);
2052: fnd_message.set_token ('STATUS', hr_general_utilities.get_lookup_meaning('OTA_CONTENT_PLAYER_STATUS','D'));
2053: else
2054: fnd_message.set_token ('LO_NAME', l_lo_name);
2055: fnd_message.set_token ('STATUS', l_lo_status);
2056: fnd_message.set_token ('TIME', l_formatted_time);

Line 2054: fnd_message.set_token ('LO_NAME', l_lo_name);

2050: if p_active_cert_flag = 'Y' then
2051: fnd_message.set_token ('LO_NAME', l_lo_name);
2052: fnd_message.set_token ('STATUS', hr_general_utilities.get_lookup_meaning('OTA_CONTENT_PLAYER_STATUS','D'));
2053: else
2054: fnd_message.set_token ('LO_NAME', l_lo_name);
2055: fnd_message.set_token ('STATUS', l_lo_status);
2056: fnd_message.set_token ('TIME', l_formatted_time);
2057: end if;
2058:

Line 2055: fnd_message.set_token ('STATUS', l_lo_status);

2051: fnd_message.set_token ('LO_NAME', l_lo_name);
2052: fnd_message.set_token ('STATUS', hr_general_utilities.get_lookup_meaning('OTA_CONTENT_PLAYER_STATUS','D'));
2053: else
2054: fnd_message.set_token ('LO_NAME', l_lo_name);
2055: fnd_message.set_token ('STATUS', l_lo_status);
2056: fnd_message.set_token ('TIME', l_formatted_time);
2057: end if;
2058:
2059: l_return_tree_title := fnd_message.get();

Line 2056: fnd_message.set_token ('TIME', l_formatted_time);

2052: fnd_message.set_token ('STATUS', hr_general_utilities.get_lookup_meaning('OTA_CONTENT_PLAYER_STATUS','D'));
2053: else
2054: fnd_message.set_token ('LO_NAME', l_lo_name);
2055: fnd_message.set_token ('STATUS', l_lo_status);
2056: fnd_message.set_token ('TIME', l_formatted_time);
2057: end if;
2058:
2059: l_return_tree_title := fnd_message.get();
2060: Else

Line 2059: l_return_tree_title := fnd_message.get();

2055: fnd_message.set_token ('STATUS', l_lo_status);
2056: fnd_message.set_token ('TIME', l_formatted_time);
2057: end if;
2058:
2059: l_return_tree_title := fnd_message.get();
2060: Else
2061: --if this is part of active cert prd, return icon empty circle used for "Not Attempted"
2062: if p_active_cert_flag = 'Y' then
2063: l_return_tree_title := 'player_status_n.gif';

Line 2613: fnd_message.set_name('OTA', 'OTA_443502_TEST_WAIT_DRTN_TEXT');

2609: wait_dur_time := substr(v_wait_duration, length(v_wait_duration)-7);
2610: v_wait_duration := ota_timezone_util.get_date_time(wait_dur_date, wait_dur_time, 'Y', ota_timezone_util.get_server_timezone_code, 'HH24:MI:SS');
2611:
2612: if v_wait_duration is not null then
2613: fnd_message.set_name('OTA', 'OTA_443502_TEST_WAIT_DRTN_TEXT');
2614: fnd_message.set_token('DATETIME', v_wait_duration);
2615: return fnd_message.get();
2616: else
2617: return null;

Line 2614: fnd_message.set_token('DATETIME', v_wait_duration);

2610: v_wait_duration := ota_timezone_util.get_date_time(wait_dur_date, wait_dur_time, 'Y', ota_timezone_util.get_server_timezone_code, 'HH24:MI:SS');
2611:
2612: if v_wait_duration is not null then
2613: fnd_message.set_name('OTA', 'OTA_443502_TEST_WAIT_DRTN_TEXT');
2614: fnd_message.set_token('DATETIME', v_wait_duration);
2615: return fnd_message.get();
2616: else
2617: return null;
2618: end if;

Line 2615: return fnd_message.get();

2611:
2612: if v_wait_duration is not null then
2613: fnd_message.set_name('OTA', 'OTA_443502_TEST_WAIT_DRTN_TEXT');
2614: fnd_message.set_token('DATETIME', v_wait_duration);
2615: return fnd_message.get();
2616: else
2617: return null;
2618: end if;
2619: end get_wait_duration_for_test;

Line 3767: fnd_message.set_name('OTA', 'OTA_443358_SRCH_LO_TIME');

3763: Else
3764: l_formatted_sec := l_Seconds;
3765: End If;
3766:
3767: fnd_message.set_name('OTA', 'OTA_443358_SRCH_LO_TIME');
3768: fnd_message.set_token ('HOUR', l_formatted_hour);
3769: fnd_message.set_token ('MIN', l_formatted_min);
3770: fnd_message.set_token ('SEC', l_formatted_sec);
3771: l_formatted_time := fnd_message.get();

Line 3768: fnd_message.set_token ('HOUR', l_formatted_hour);

3764: l_formatted_sec := l_Seconds;
3765: End If;
3766:
3767: fnd_message.set_name('OTA', 'OTA_443358_SRCH_LO_TIME');
3768: fnd_message.set_token ('HOUR', l_formatted_hour);
3769: fnd_message.set_token ('MIN', l_formatted_min);
3770: fnd_message.set_token ('SEC', l_formatted_sec);
3771: l_formatted_time := fnd_message.get();
3772:

Line 3769: fnd_message.set_token ('MIN', l_formatted_min);

3765: End If;
3766:
3767: fnd_message.set_name('OTA', 'OTA_443358_SRCH_LO_TIME');
3768: fnd_message.set_token ('HOUR', l_formatted_hour);
3769: fnd_message.set_token ('MIN', l_formatted_min);
3770: fnd_message.set_token ('SEC', l_formatted_sec);
3771: l_formatted_time := fnd_message.get();
3772:
3773: If ((l_lo_score is null) or (l_lo_score < 0)) Then

Line 3770: fnd_message.set_token ('SEC', l_formatted_sec);

3766:
3767: fnd_message.set_name('OTA', 'OTA_443358_SRCH_LO_TIME');
3768: fnd_message.set_token ('HOUR', l_formatted_hour);
3769: fnd_message.set_token ('MIN', l_formatted_min);
3770: fnd_message.set_token ('SEC', l_formatted_sec);
3771: l_formatted_time := fnd_message.get();
3772:
3773: If ((l_lo_score is null) or (l_lo_score < 0)) Then
3774: fnd_message.set_name('OTA', 'OTA_443453_SRCH_TREE_TITLE2');

Line 3771: l_formatted_time := fnd_message.get();

3767: fnd_message.set_name('OTA', 'OTA_443358_SRCH_LO_TIME');
3768: fnd_message.set_token ('HOUR', l_formatted_hour);
3769: fnd_message.set_token ('MIN', l_formatted_min);
3770: fnd_message.set_token ('SEC', l_formatted_sec);
3771: l_formatted_time := fnd_message.get();
3772:
3773: If ((l_lo_score is null) or (l_lo_score < 0)) Then
3774: fnd_message.set_name('OTA', 'OTA_443453_SRCH_TREE_TITLE2');
3775: Else

Line 3774: fnd_message.set_name('OTA', 'OTA_443453_SRCH_TREE_TITLE2');

3770: fnd_message.set_token ('SEC', l_formatted_sec);
3771: l_formatted_time := fnd_message.get();
3772:
3773: If ((l_lo_score is null) or (l_lo_score < 0)) Then
3774: fnd_message.set_name('OTA', 'OTA_443453_SRCH_TREE_TITLE2');
3775: Else
3776: --Added for bug 3550407
3777: IF ( l_tst_grade_flag = 'P' ) THEN
3778: l_var_score := l_lo_score||'%';

Line 3783: fnd_message.set_name('OTA', 'OTA_443357_SRCH_TREE_TITLE');

3779: ELSE
3780: l_var_score := l_lo_score;
3781: END IF;
3782:
3783: fnd_message.set_name('OTA', 'OTA_443357_SRCH_TREE_TITLE');
3784: fnd_message.set_token ('SCORE', l_var_score);
3785: End If;
3786:
3787: If ( (l_lo_lesson_status = 'C' or l_lo_lesson_status = 'P')

Line 3784: fnd_message.set_token ('SCORE', l_var_score);

3780: l_var_score := l_lo_score;
3781: END IF;
3782:
3783: fnd_message.set_name('OTA', 'OTA_443357_SRCH_TREE_TITLE');
3784: fnd_message.set_token ('SCORE', l_var_score);
3785: End If;
3786:
3787: If ( (l_lo_lesson_status = 'C' or l_lo_lesson_status = 'P')
3788: and l_lo_completed_date is not null ) Then

Line 3792: fnd_message.set_token ('LO_NAME', l_lo_name);

3788: and l_lo_completed_date is not null ) Then
3789: l_lo_status := l_lo_status || ' ' || l_lo_completed_date_tz;
3790: End If;
3791:
3792: fnd_message.set_token ('LO_NAME', l_lo_name);
3793: fnd_message.set_token ('STATUS', l_lo_status);
3794: fnd_message.set_token ('TIME', l_formatted_time);
3795:
3796: l_return_tree_title := fnd_message.get();

Line 3793: fnd_message.set_token ('STATUS', l_lo_status);

3789: l_lo_status := l_lo_status || ' ' || l_lo_completed_date_tz;
3790: End If;
3791:
3792: fnd_message.set_token ('LO_NAME', l_lo_name);
3793: fnd_message.set_token ('STATUS', l_lo_status);
3794: fnd_message.set_token ('TIME', l_formatted_time);
3795:
3796: l_return_tree_title := fnd_message.get();
3797: Else

Line 3794: fnd_message.set_token ('TIME', l_formatted_time);

3790: End If;
3791:
3792: fnd_message.set_token ('LO_NAME', l_lo_name);
3793: fnd_message.set_token ('STATUS', l_lo_status);
3794: fnd_message.set_token ('TIME', l_formatted_time);
3795:
3796: l_return_tree_title := fnd_message.get();
3797: Else
3798: l_return_tree_title := l_lo_status_icon;

Line 3796: l_return_tree_title := fnd_message.get();

3792: fnd_message.set_token ('LO_NAME', l_lo_name);
3793: fnd_message.set_token ('STATUS', l_lo_status);
3794: fnd_message.set_token ('TIME', l_formatted_time);
3795:
3796: l_return_tree_title := fnd_message.get();
3797: Else
3798: l_return_tree_title := l_lo_status_icon;
3799: End If;
3800:

Line 4423: fnd_message.set_name('OTA', 'OTA_443358_SRCH_LO_TIME');

4419: Else
4420: l_formatted_sec := l_Seconds;
4421: End If;
4422:
4423: fnd_message.set_name('OTA', 'OTA_443358_SRCH_LO_TIME');
4424: fnd_message.set_token ('HOUR', l_formatted_hour);
4425: fnd_message.set_token ('MIN', l_formatted_min);
4426: fnd_message.set_token ('SEC', l_formatted_sec);
4427: l_formatted_time := fnd_message.get();

Line 4424: fnd_message.set_token ('HOUR', l_formatted_hour);

4420: l_formatted_sec := l_Seconds;
4421: End If;
4422:
4423: fnd_message.set_name('OTA', 'OTA_443358_SRCH_LO_TIME');
4424: fnd_message.set_token ('HOUR', l_formatted_hour);
4425: fnd_message.set_token ('MIN', l_formatted_min);
4426: fnd_message.set_token ('SEC', l_formatted_sec);
4427: l_formatted_time := fnd_message.get();
4428: return l_formatted_time;

Line 4425: fnd_message.set_token ('MIN', l_formatted_min);

4421: End If;
4422:
4423: fnd_message.set_name('OTA', 'OTA_443358_SRCH_LO_TIME');
4424: fnd_message.set_token ('HOUR', l_formatted_hour);
4425: fnd_message.set_token ('MIN', l_formatted_min);
4426: fnd_message.set_token ('SEC', l_formatted_sec);
4427: l_formatted_time := fnd_message.get();
4428: return l_formatted_time;
4429: End format_lo_time;

Line 4426: fnd_message.set_token ('SEC', l_formatted_sec);

4422:
4423: fnd_message.set_name('OTA', 'OTA_443358_SRCH_LO_TIME');
4424: fnd_message.set_token ('HOUR', l_formatted_hour);
4425: fnd_message.set_token ('MIN', l_formatted_min);
4426: fnd_message.set_token ('SEC', l_formatted_sec);
4427: l_formatted_time := fnd_message.get();
4428: return l_formatted_time;
4429: End format_lo_time;
4430:

Line 4427: l_formatted_time := fnd_message.get();

4423: fnd_message.set_name('OTA', 'OTA_443358_SRCH_LO_TIME');
4424: fnd_message.set_token ('HOUR', l_formatted_hour);
4425: fnd_message.set_token ('MIN', l_formatted_min);
4426: fnd_message.set_token ('SEC', l_formatted_sec);
4427: l_formatted_time := fnd_message.get();
4428: return l_formatted_time;
4429: End format_lo_time;
4430:
4431: