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();
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:
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;
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;
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:
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:
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;
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;
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
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;
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:
1763: BEGIN
1764: --
1765: hr_utility.set_location('Entering :'||l_proc,5);
1766: --
1767: fnd_message.set_name(p_application_code, p_message_code);
1768: l_msg_text := fnd_message.get();
1769: --
1770: IF l_msg_text IS NULL THEN
1771: RAISE l_msg_not_found;
1764: --
1765: hr_utility.set_location('Entering :'||l_proc,5);
1766: --
1767: fnd_message.set_name(p_application_code, p_message_code);
1768: l_msg_text := fnd_message.get();
1769: --
1770: IF l_msg_text IS NULL THEN
1771: RAISE l_msg_not_found;
1772: END IF;