371: l_recipient2 VARCHAR2(32767);
372: l_recipient3 VARCHAR2(32767);
373: l_temp_message VARCHAR2(32767);
374: L_NDX VARCHAR2(1);
375: crlf CONSTANT VARCHAR2 (2) := fnd_global.local_chr(13) || fnd_global.local_chr(10);
376:
377: CURSOR c_user_info(p_user_id IN NUMBER) IS
378: SELECT user_name, email_address
379: FROM fnd_user
421: OPEN c_env;
422: FETCH c_env INTO g_env;
423: CLOSE c_env;
424: END IF;
425: l_conc_request_id := fnd_global.conc_request_id;
426: if (l_conc_request_id=0) then
427: l_conc_request_id := NULL;
428: end if;
429: IF l_debug_on THEN