388:
393:
558: f_level := level;
559: f_module := module;
560:
561: if(start_date is not null) then
562: f_start_date := fnd_date.canonical_to_date(start_date);
563: else
564: f_start_date := null;
565: end if;
566:
564: f_start_date := null;
565: end if;
566:
567: if(end_date is not null) then
568: f_end_date := fnd_date.canonical_to_date(end_date);
569: else
570: f_end_date := null;
571: end if;
572:
885: elsif(f_level = 6) then
886: htp.p('
Level: Unexpected');
887: end if;
888: htp.p('
Module: '||nvl(f_module, '(None Specified)'));
889: htp.p('
Start Date: '||nvl(fnd_date.date_to_canonical(f_start_date),
890: '(None Specified)'));
891: htp.p('
End Date: '||nvl(fnd_date.date_to_canonical(f_end_date),
892: '(None Specified)'));
893: htp.p('
Session ID: '||nvl(to_char(f_session_id), '(None Specified)'));
887: end if;
888: htp.p('
Module: '||nvl(f_module, '(None Specified)'));
889: htp.p('
Start Date: '||nvl(fnd_date.date_to_canonical(f_start_date),
890: '(None Specified)'));
891: htp.p('
End Date: '||nvl(fnd_date.date_to_canonical(f_end_date),
892: '(None Specified)'));
893: htp.p('
Session ID: '||nvl(to_char(f_session_id), '(None Specified)'));
894: htp.p('
User ID: '||nvl(to_char(f_user_id), '(None Specified)'));
895: htp.p('
928: elsif(l_level = 6) then
929: log_level_name := 'Unexpected';
930: end if;
931:
932: timestamp_str := fnd_date.date_to_canonical(l_timestamp);
933:
934: if(l_user_id is not null) then /* Simple username cache for speed*/
935: if(l_user_id = last_userid) then
936: found_username := last_username;