16: v_cp_enabled NUMBER;
17: procedure write_output(p_text in varchar2) is
18: begin
19: /* remove occurences of null string and write to output */
20: fnd_file.put_line(fnd_file.output, replace(p_text, fnd_global.local_chr(0)));
21: /* dbms_output.put_line(p_text);
22: insert into msd_test values(p_text);*/
23: end write_output;
24:
270:
271: END;
272: END IF;
273: /* Get the User Information */
274: SELECT FND_GLOBAL.USER_NAME,
275: FND_GLOBAL.RESP_NAME,
276: FND_GLOBAL.APPLICATION_NAME
277: INTO v_user_name,
278: v_resp_name,
271: END;
272: END IF;
273: /* Get the User Information */
274: SELECT FND_GLOBAL.USER_NAME,
275: FND_GLOBAL.RESP_NAME,
276: FND_GLOBAL.APPLICATION_NAME
277: INTO v_user_name,
278: v_resp_name,
279: v_application_name
272: END IF;
273: /* Get the User Information */
274: SELECT FND_GLOBAL.USER_NAME,
275: FND_GLOBAL.RESP_NAME,
276: FND_GLOBAL.APPLICATION_NAME
277: INTO v_user_name,
278: v_resp_name,
279: v_application_name
280: FROM dual;