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 2406: fnd_message.set_name('OTA', 'OTA_443358_SRCH_LO_TIME');

2402: Else
2403: l_formatted_sec := l_Seconds;
2404: End If;
2405:
2406: fnd_message.set_name('OTA', 'OTA_443358_SRCH_LO_TIME');
2407: fnd_message.set_token ('HOUR', l_formatted_hour);
2408: fnd_message.set_token ('MIN', l_formatted_min);
2409: fnd_message.set_token ('SEC', l_formatted_sec);
2410: l_formatted_time := fnd_message.get();

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

2403: l_formatted_sec := l_Seconds;
2404: End If;
2405:
2406: fnd_message.set_name('OTA', 'OTA_443358_SRCH_LO_TIME');
2407: fnd_message.set_token ('HOUR', l_formatted_hour);
2408: fnd_message.set_token ('MIN', l_formatted_min);
2409: fnd_message.set_token ('SEC', l_formatted_sec);
2410: l_formatted_time := fnd_message.get();
2411:

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

2404: End If;
2405:
2406: fnd_message.set_name('OTA', 'OTA_443358_SRCH_LO_TIME');
2407: fnd_message.set_token ('HOUR', l_formatted_hour);
2408: fnd_message.set_token ('MIN', l_formatted_min);
2409: fnd_message.set_token ('SEC', l_formatted_sec);
2410: l_formatted_time := fnd_message.get();
2411:
2412: if p_active_cert_flag = 'Y' then

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

2405:
2406: fnd_message.set_name('OTA', 'OTA_443358_SRCH_LO_TIME');
2407: fnd_message.set_token ('HOUR', l_formatted_hour);
2408: fnd_message.set_token ('MIN', l_formatted_min);
2409: fnd_message.set_token ('SEC', l_formatted_sec);
2410: l_formatted_time := fnd_message.get();
2411:
2412: if p_active_cert_flag = 'Y' then
2413: fnd_message.set_name('OTA', 'OTA_443968_SRCH_TREE_TITLE3');

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

2406: fnd_message.set_name('OTA', 'OTA_443358_SRCH_LO_TIME');
2407: fnd_message.set_token ('HOUR', l_formatted_hour);
2408: fnd_message.set_token ('MIN', l_formatted_min);
2409: fnd_message.set_token ('SEC', l_formatted_sec);
2410: l_formatted_time := fnd_message.get();
2411:
2412: if p_active_cert_flag = 'Y' then
2413: fnd_message.set_name('OTA', 'OTA_443968_SRCH_TREE_TITLE3');
2414: elsif ((l_lo_score is null) or (l_lo_score < 0)) Then

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

2409: fnd_message.set_token ('SEC', l_formatted_sec);
2410: l_formatted_time := fnd_message.get();
2411:
2412: if p_active_cert_flag = 'Y' then
2413: fnd_message.set_name('OTA', 'OTA_443968_SRCH_TREE_TITLE3');
2414: elsif ((l_lo_score is null) or (l_lo_score < 0)) Then
2415: fnd_message.set_name('OTA', 'OTA_443453_SRCH_TREE_TITLE2');
2416: Else
2417: --Added for bug 3550407

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

2411:
2412: if p_active_cert_flag = 'Y' then
2413: fnd_message.set_name('OTA', 'OTA_443968_SRCH_TREE_TITLE3');
2414: elsif ((l_lo_score is null) or (l_lo_score < 0)) Then
2415: fnd_message.set_name('OTA', 'OTA_443453_SRCH_TREE_TITLE2');
2416: Else
2417: --Added for bug 3550407
2418: IF ( l_tst_grade_flag = 'P' ) THEN
2419: l_var_score := l_lo_score||'%';

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

2420: ELSE
2421: l_var_score := l_lo_score;
2422: END IF;
2423:
2424: fnd_message.set_name('OTA', 'OTA_443357_SRCH_TREE_TITLE');
2425: fnd_message.set_token ('SCORE', l_var_score);
2426: End If;
2427:
2428: If ( (l_lo_lesson_status = 'C' or l_lo_lesson_status = 'P')

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

2421: l_var_score := l_lo_score;
2422: END IF;
2423:
2424: fnd_message.set_name('OTA', 'OTA_443357_SRCH_TREE_TITLE');
2425: fnd_message.set_token ('SCORE', l_var_score);
2426: End If;
2427:
2428: If ( (l_lo_lesson_status = 'C' or l_lo_lesson_status = 'P')
2429: and l_lo_completed_date is not null ) Then

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

2432: End If;
2433:
2434: --if this is part of active cert prd, return status as "Not Applicable"
2435: if p_active_cert_flag = 'Y' then
2436: fnd_message.set_token ('LO_NAME', l_lo_name);
2437: fnd_message.set_token ('STATUS', hr_general_utilities.get_lookup_meaning('OTA_CONTENT_PLAYER_STATUS','D'));
2438: else
2439: fnd_message.set_token ('LO_NAME', l_lo_name);
2440: fnd_message.set_token ('STATUS', l_lo_status);

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

2433:
2434: --if this is part of active cert prd, return status as "Not Applicable"
2435: if p_active_cert_flag = 'Y' then
2436: fnd_message.set_token ('LO_NAME', l_lo_name);
2437: fnd_message.set_token ('STATUS', hr_general_utilities.get_lookup_meaning('OTA_CONTENT_PLAYER_STATUS','D'));
2438: else
2439: fnd_message.set_token ('LO_NAME', l_lo_name);
2440: fnd_message.set_token ('STATUS', l_lo_status);
2441: fnd_message.set_token ('TIME', l_formatted_time);

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

2435: if p_active_cert_flag = 'Y' then
2436: fnd_message.set_token ('LO_NAME', l_lo_name);
2437: fnd_message.set_token ('STATUS', hr_general_utilities.get_lookup_meaning('OTA_CONTENT_PLAYER_STATUS','D'));
2438: else
2439: fnd_message.set_token ('LO_NAME', l_lo_name);
2440: fnd_message.set_token ('STATUS', l_lo_status);
2441: fnd_message.set_token ('TIME', l_formatted_time);
2442: end if;
2443:

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

2436: fnd_message.set_token ('LO_NAME', l_lo_name);
2437: fnd_message.set_token ('STATUS', hr_general_utilities.get_lookup_meaning('OTA_CONTENT_PLAYER_STATUS','D'));
2438: else
2439: fnd_message.set_token ('LO_NAME', l_lo_name);
2440: fnd_message.set_token ('STATUS', l_lo_status);
2441: fnd_message.set_token ('TIME', l_formatted_time);
2442: end if;
2443:
2444: l_return_tree_title := fnd_message.get();

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

2437: fnd_message.set_token ('STATUS', hr_general_utilities.get_lookup_meaning('OTA_CONTENT_PLAYER_STATUS','D'));
2438: else
2439: fnd_message.set_token ('LO_NAME', l_lo_name);
2440: fnd_message.set_token ('STATUS', l_lo_status);
2441: fnd_message.set_token ('TIME', l_formatted_time);
2442: end if;
2443:
2444: l_return_tree_title := fnd_message.get();
2445: Else

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

2440: fnd_message.set_token ('STATUS', l_lo_status);
2441: fnd_message.set_token ('TIME', l_formatted_time);
2442: end if;
2443:
2444: l_return_tree_title := fnd_message.get();
2445: Else
2446: --if this is part of active cert prd, return icon empty circle used for "Not Attempted"
2447: if p_active_cert_flag = 'Y' then
2448: l_return_tree_title := 'player_status_n.gif';

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

2974: wait_dur_time := substr(v_wait_duration, length(v_wait_duration)-7);
2975: 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');
2976:
2977: if v_wait_duration is not null then
2978: fnd_message.set_name('OTA', 'OTA_443502_TEST_WAIT_DRTN_TEXT');
2979: fnd_message.set_token('DATETIME', v_wait_duration);
2980: return fnd_message.get();
2981: else
2982: return null;

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

2975: 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');
2976:
2977: if v_wait_duration is not null then
2978: fnd_message.set_name('OTA', 'OTA_443502_TEST_WAIT_DRTN_TEXT');
2979: fnd_message.set_token('DATETIME', v_wait_duration);
2980: return fnd_message.get();
2981: else
2982: return null;
2983: end if;

Line 2980: return fnd_message.get();

2976:
2977: if v_wait_duration is not null then
2978: fnd_message.set_name('OTA', 'OTA_443502_TEST_WAIT_DRTN_TEXT');
2979: fnd_message.set_token('DATETIME', v_wait_duration);
2980: return fnd_message.get();
2981: else
2982: return null;
2983: end if;
2984: end get_wait_duration_for_test;

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

4338: Else
4339: l_formatted_sec := l_Seconds;
4340: End If;
4341:
4342: fnd_message.set_name('OTA', 'OTA_443358_SRCH_LO_TIME');
4343: fnd_message.set_token ('HOUR', l_formatted_hour);
4344: fnd_message.set_token ('MIN', l_formatted_min);
4345: fnd_message.set_token ('SEC', l_formatted_sec);
4346: l_formatted_time := fnd_message.get();

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

4339: l_formatted_sec := l_Seconds;
4340: End If;
4341:
4342: fnd_message.set_name('OTA', 'OTA_443358_SRCH_LO_TIME');
4343: fnd_message.set_token ('HOUR', l_formatted_hour);
4344: fnd_message.set_token ('MIN', l_formatted_min);
4345: fnd_message.set_token ('SEC', l_formatted_sec);
4346: l_formatted_time := fnd_message.get();
4347:

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

4340: End If;
4341:
4342: fnd_message.set_name('OTA', 'OTA_443358_SRCH_LO_TIME');
4343: fnd_message.set_token ('HOUR', l_formatted_hour);
4344: fnd_message.set_token ('MIN', l_formatted_min);
4345: fnd_message.set_token ('SEC', l_formatted_sec);
4346: l_formatted_time := fnd_message.get();
4347:
4348: If ((l_lo_score is null) or (l_lo_score < 0)) Then

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

4341:
4342: fnd_message.set_name('OTA', 'OTA_443358_SRCH_LO_TIME');
4343: fnd_message.set_token ('HOUR', l_formatted_hour);
4344: fnd_message.set_token ('MIN', l_formatted_min);
4345: fnd_message.set_token ('SEC', l_formatted_sec);
4346: l_formatted_time := fnd_message.get();
4347:
4348: If ((l_lo_score is null) or (l_lo_score < 0)) Then
4349: fnd_message.set_name('OTA', 'OTA_443453_SRCH_TREE_TITLE2');

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

4342: fnd_message.set_name('OTA', 'OTA_443358_SRCH_LO_TIME');
4343: fnd_message.set_token ('HOUR', l_formatted_hour);
4344: fnd_message.set_token ('MIN', l_formatted_min);
4345: fnd_message.set_token ('SEC', l_formatted_sec);
4346: l_formatted_time := fnd_message.get();
4347:
4348: If ((l_lo_score is null) or (l_lo_score < 0)) Then
4349: fnd_message.set_name('OTA', 'OTA_443453_SRCH_TREE_TITLE2');
4350: Else

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

4345: fnd_message.set_token ('SEC', l_formatted_sec);
4346: l_formatted_time := fnd_message.get();
4347:
4348: If ((l_lo_score is null) or (l_lo_score < 0)) Then
4349: fnd_message.set_name('OTA', 'OTA_443453_SRCH_TREE_TITLE2');
4350: Else
4351: --Added for bug 3550407
4352: IF ( l_tst_grade_flag = 'P' ) THEN
4353: l_var_score := l_lo_score||'%';

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

4354: ELSE
4355: l_var_score := l_lo_score;
4356: END IF;
4357:
4358: fnd_message.set_name('OTA', 'OTA_443357_SRCH_TREE_TITLE');
4359: fnd_message.set_token ('SCORE', l_var_score);
4360: End If;
4361:
4362: If ( (l_lo_lesson_status = 'C' or l_lo_lesson_status = 'P')

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

4355: l_var_score := l_lo_score;
4356: END IF;
4357:
4358: fnd_message.set_name('OTA', 'OTA_443357_SRCH_TREE_TITLE');
4359: fnd_message.set_token ('SCORE', l_var_score);
4360: End If;
4361:
4362: If ( (l_lo_lesson_status = 'C' or l_lo_lesson_status = 'P')
4363: and l_lo_completed_date is not null ) Then

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

4364: -- l_lo_status := l_lo_status || ' ' || l_lo_completed_date_tz; Modified for iCal Bug 12696284
4365: l_lo_status := l_lo_status || ' ' || fnd_date.date_to_displaydate(l_lo_completion_date_tz,2);
4366: End If;
4367:
4368: fnd_message.set_token ('LO_NAME', l_lo_name);
4369: fnd_message.set_token ('STATUS', l_lo_status);
4370: fnd_message.set_token ('TIME', l_formatted_time);
4371:
4372: l_return_tree_title := fnd_message.get();

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

4365: l_lo_status := l_lo_status || ' ' || fnd_date.date_to_displaydate(l_lo_completion_date_tz,2);
4366: End If;
4367:
4368: fnd_message.set_token ('LO_NAME', l_lo_name);
4369: fnd_message.set_token ('STATUS', l_lo_status);
4370: fnd_message.set_token ('TIME', l_formatted_time);
4371:
4372: l_return_tree_title := fnd_message.get();
4373: Else

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

4366: End If;
4367:
4368: fnd_message.set_token ('LO_NAME', l_lo_name);
4369: fnd_message.set_token ('STATUS', l_lo_status);
4370: fnd_message.set_token ('TIME', l_formatted_time);
4371:
4372: l_return_tree_title := fnd_message.get();
4373: Else
4374: l_return_tree_title := l_lo_status_icon;

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

4368: fnd_message.set_token ('LO_NAME', l_lo_name);
4369: fnd_message.set_token ('STATUS', l_lo_status);
4370: fnd_message.set_token ('TIME', l_formatted_time);
4371:
4372: l_return_tree_title := fnd_message.get();
4373: Else
4374: l_return_tree_title := l_lo_status_icon;
4375: End If;
4376:

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

4995: Else
4996: l_formatted_sec := l_Seconds;
4997: End If;
4998:
4999: fnd_message.set_name('OTA', 'OTA_443358_SRCH_LO_TIME');
5000: fnd_message.set_token ('HOUR', l_formatted_hour);
5001: fnd_message.set_token ('MIN', l_formatted_min);
5002: fnd_message.set_token ('SEC', l_formatted_sec);
5003: l_formatted_time := fnd_message.get();

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

4996: l_formatted_sec := l_Seconds;
4997: End If;
4998:
4999: fnd_message.set_name('OTA', 'OTA_443358_SRCH_LO_TIME');
5000: fnd_message.set_token ('HOUR', l_formatted_hour);
5001: fnd_message.set_token ('MIN', l_formatted_min);
5002: fnd_message.set_token ('SEC', l_formatted_sec);
5003: l_formatted_time := fnd_message.get();
5004: return l_formatted_time;

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

4997: End If;
4998:
4999: fnd_message.set_name('OTA', 'OTA_443358_SRCH_LO_TIME');
5000: fnd_message.set_token ('HOUR', l_formatted_hour);
5001: fnd_message.set_token ('MIN', l_formatted_min);
5002: fnd_message.set_token ('SEC', l_formatted_sec);
5003: l_formatted_time := fnd_message.get();
5004: return l_formatted_time;
5005: End format_lo_time;

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

4998:
4999: fnd_message.set_name('OTA', 'OTA_443358_SRCH_LO_TIME');
5000: fnd_message.set_token ('HOUR', l_formatted_hour);
5001: fnd_message.set_token ('MIN', l_formatted_min);
5002: fnd_message.set_token ('SEC', l_formatted_sec);
5003: l_formatted_time := fnd_message.get();
5004: return l_formatted_time;
5005: End format_lo_time;
5006:

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

4999: fnd_message.set_name('OTA', 'OTA_443358_SRCH_LO_TIME');
5000: fnd_message.set_token ('HOUR', l_formatted_hour);
5001: fnd_message.set_token ('MIN', l_formatted_min);
5002: fnd_message.set_token ('SEC', l_formatted_sec);
5003: l_formatted_time := fnd_message.get();
5004: return l_formatted_time;
5005: End format_lo_time;
5006:
5007: