DBA Data[Home] [Help]

APPS.OTA_UTILITY dependencies on FND_MESSAGE

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

54: Else
55: l_formatted_sec := l_Seconds;
56: End If;
57:
58: fnd_message.set_name('OTA', 'OTA_443358_SRCH_LO_TIME');
59: fnd_message.set_token ('HOUR', l_formatted_hour);
60: fnd_message.set_token ('MIN', l_formatted_min);
61: fnd_message.set_token ('SEC', l_formatted_sec);
62: l_formatted_time := fnd_message.get();

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

55: l_formatted_sec := l_Seconds;
56: End If;
57:
58: fnd_message.set_name('OTA', 'OTA_443358_SRCH_LO_TIME');
59: fnd_message.set_token ('HOUR', l_formatted_hour);
60: fnd_message.set_token ('MIN', l_formatted_min);
61: fnd_message.set_token ('SEC', l_formatted_sec);
62: l_formatted_time := fnd_message.get();
63:

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

56: End If;
57:
58: fnd_message.set_name('OTA', 'OTA_443358_SRCH_LO_TIME');
59: fnd_message.set_token ('HOUR', l_formatted_hour);
60: fnd_message.set_token ('MIN', l_formatted_min);
61: fnd_message.set_token ('SEC', l_formatted_sec);
62: l_formatted_time := fnd_message.get();
63:
64: return l_formatted_time;

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

57:
58: fnd_message.set_name('OTA', 'OTA_443358_SRCH_LO_TIME');
59: fnd_message.set_token ('HOUR', l_formatted_hour);
60: fnd_message.set_token ('MIN', l_formatted_min);
61: fnd_message.set_token ('SEC', l_formatted_sec);
62: l_formatted_time := fnd_message.get();
63:
64: return l_formatted_time;
65: end get_test_time;

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

58: fnd_message.set_name('OTA', 'OTA_443358_SRCH_LO_TIME');
59: fnd_message.set_token ('HOUR', l_formatted_hour);
60: fnd_message.set_token ('MIN', l_formatted_min);
61: fnd_message.set_token ('SEC', l_formatted_sec);
62: l_formatted_time := fnd_message.get();
63:
64: return l_formatted_time;
65: end get_test_time;
66:

Line 223: fnd_message.set_name('OTA','OTA_443973_SSN_COUNT');

219: open getcount;
220: fetch getcount into l_event_count;
221: close getcount;
222:
223: fnd_message.set_name('OTA','OTA_443973_SSN_COUNT');
224: fnd_message.set_token('COUNT', l_event_count);
225:
226: l_return_value := fnd_message.get();
227:

Line 224: fnd_message.set_token('COUNT', l_event_count);

220: fetch getcount into l_event_count;
221: close getcount;
222:
223: fnd_message.set_name('OTA','OTA_443973_SSN_COUNT');
224: fnd_message.set_token('COUNT', l_event_count);
225:
226: l_return_value := fnd_message.get();
227:
228: return l_return_value;

Line 226: l_return_value := fnd_message.get();

222:
223: fnd_message.set_name('OTA','OTA_443973_SSN_COUNT');
224: fnd_message.set_token('COUNT', l_event_count);
225:
226: l_return_value := fnd_message.get();
227:
228: return l_return_value;
229:
230: end get_session_count;

Line 254: fnd_message.set_name('OTA',l_message_name);

250: l_child_count := ota_utility.get_event_count(p_object_id);
251: END IF;
252: -- Modified for bug#5158213
253: -- IF l_child_count <> 0 THEN
254: fnd_message.set_name('OTA',l_message_name);
255: fnd_message.set_token('COUNT', l_child_count);
256:
257: l_return_value := fnd_message.get();
258: -- ELSE

Line 255: fnd_message.set_token('COUNT', l_child_count);

251: END IF;
252: -- Modified for bug#5158213
253: -- IF l_child_count <> 0 THEN
254: fnd_message.set_name('OTA',l_message_name);
255: fnd_message.set_token('COUNT', l_child_count);
256:
257: l_return_value := fnd_message.get();
258: -- ELSE
259: -- l_return_value := null;

Line 257: l_return_value := fnd_message.get();

253: -- IF l_child_count <> 0 THEN
254: fnd_message.set_name('OTA',l_message_name);
255: fnd_message.set_token('COUNT', l_child_count);
256:
257: l_return_value := fnd_message.get();
258: -- ELSE
259: -- l_return_value := null;
260: -- END IF;
261:

Line 1831: fnd_message.set_name(p_application_code, p_message_code);

1827: BEGIN
1828: --
1829: hr_utility.set_location('Entering :'||l_proc,5);
1830: --
1831: fnd_message.set_name(p_application_code, p_message_code);
1832: l_msg_text := fnd_message.get();
1833: --
1834: IF l_msg_text IS NULL THEN
1835: RAISE l_msg_not_found;

Line 1832: l_msg_text := fnd_message.get();

1828: --
1829: hr_utility.set_location('Entering :'||l_proc,5);
1830: --
1831: fnd_message.set_name(p_application_code, p_message_code);
1832: l_msg_text := fnd_message.get();
1833: --
1834: IF l_msg_text IS NULL THEN
1835: RAISE l_msg_not_found;
1836: END IF;

Line 3468: fnd_message.set_name('OTA', 'OTA_467151_LP_CLS_UNLIMITED');

3464: l_vacancies varchar2(30);
3465: begin
3466: l_vacancies := ota_evt_bus2.get_vacancies(p_event_id);
3467: if(l_vacancies is null) then
3468: fnd_message.set_name('OTA', 'OTA_467151_LP_CLS_UNLIMITED');
3469: l_vacancies := fnd_message.get;
3470: end if;
3471: return l_vacancies ;
3472: end get_class_available_seats;

Line 3469: l_vacancies := fnd_message.get;

3465: begin
3466: l_vacancies := ota_evt_bus2.get_vacancies(p_event_id);
3467: if(l_vacancies is null) then
3468: fnd_message.set_name('OTA', 'OTA_467151_LP_CLS_UNLIMITED');
3469: l_vacancies := fnd_message.get;
3470: end if;
3471: return l_vacancies ;
3472: end get_class_available_seats;
3473: