206: FUNCTION remove_whitespace (p_str IN VARCHAR2) RETURN VARCHAR2 IS
207: l_str VARCHAR2(32767);
208: BEGIN
209: l_str := p_str;
210: l_str := RTRIM(LTRIM(l_str, fnd_global.local_chr(13)),
211: fnd_global.local_chr(13));
212: l_str := RTRIM(LTRIM(l_str, fnd_global.local_chr(8)),
213: fnd_global.local_chr(8));
214: l_str := RTRIM(LTRIM(l_str, fnd_global.local_chr(10)),
207: l_str VARCHAR2(32767);
208: BEGIN
209: l_str := p_str;
210: l_str := RTRIM(LTRIM(l_str, fnd_global.local_chr(13)),
211: fnd_global.local_chr(13));
212: l_str := RTRIM(LTRIM(l_str, fnd_global.local_chr(8)),
213: fnd_global.local_chr(8));
214: l_str := RTRIM(LTRIM(l_str, fnd_global.local_chr(10)),
215: fnd_global.local_chr(10));
208: BEGIN
209: l_str := p_str;
210: l_str := RTRIM(LTRIM(l_str, fnd_global.local_chr(13)),
211: fnd_global.local_chr(13));
212: l_str := RTRIM(LTRIM(l_str, fnd_global.local_chr(8)),
213: fnd_global.local_chr(8));
214: l_str := RTRIM(LTRIM(l_str, fnd_global.local_chr(10)),
215: fnd_global.local_chr(10));
216: l_str := RTRIM(LTRIM(l_str, fnd_global.local_chr(0)),
209: l_str := p_str;
210: l_str := RTRIM(LTRIM(l_str, fnd_global.local_chr(13)),
211: fnd_global.local_chr(13));
212: l_str := RTRIM(LTRIM(l_str, fnd_global.local_chr(8)),
213: fnd_global.local_chr(8));
214: l_str := RTRIM(LTRIM(l_str, fnd_global.local_chr(10)),
215: fnd_global.local_chr(10));
216: l_str := RTRIM(LTRIM(l_str, fnd_global.local_chr(0)),
217: fnd_global.local_chr(0));
210: l_str := RTRIM(LTRIM(l_str, fnd_global.local_chr(13)),
211: fnd_global.local_chr(13));
212: l_str := RTRIM(LTRIM(l_str, fnd_global.local_chr(8)),
213: fnd_global.local_chr(8));
214: l_str := RTRIM(LTRIM(l_str, fnd_global.local_chr(10)),
215: fnd_global.local_chr(10));
216: l_str := RTRIM(LTRIM(l_str, fnd_global.local_chr(0)),
217: fnd_global.local_chr(0));
218: l_str := RTRIM(LTRIM(l_str));
211: fnd_global.local_chr(13));
212: l_str := RTRIM(LTRIM(l_str, fnd_global.local_chr(8)),
213: fnd_global.local_chr(8));
214: l_str := RTRIM(LTRIM(l_str, fnd_global.local_chr(10)),
215: fnd_global.local_chr(10));
216: l_str := RTRIM(LTRIM(l_str, fnd_global.local_chr(0)),
217: fnd_global.local_chr(0));
218: l_str := RTRIM(LTRIM(l_str));
219: RETURN l_str;
212: l_str := RTRIM(LTRIM(l_str, fnd_global.local_chr(8)),
213: fnd_global.local_chr(8));
214: l_str := RTRIM(LTRIM(l_str, fnd_global.local_chr(10)),
215: fnd_global.local_chr(10));
216: l_str := RTRIM(LTRIM(l_str, fnd_global.local_chr(0)),
217: fnd_global.local_chr(0));
218: l_str := RTRIM(LTRIM(l_str));
219: RETURN l_str;
220: END remove_whitespace;
213: fnd_global.local_chr(8));
214: l_str := RTRIM(LTRIM(l_str, fnd_global.local_chr(10)),
215: fnd_global.local_chr(10));
216: l_str := RTRIM(LTRIM(l_str, fnd_global.local_chr(0)),
217: fnd_global.local_chr(0));
218: l_str := RTRIM(LTRIM(l_str));
219: RETURN l_str;
220: END remove_whitespace;
221:
242: l_str := p_str;
243:
244: -- clean the string of reserved characters before returning
245: -- l_str := REPLACE(l_str, '&'); -- get rid of ampersands
246: l_str := REPLACE(l_str, fnd_global.local_chr(38)); -- get rid of ampersands
247: l_str := REPLACE(l_str, '<'); -- get rid of open brackets
248: l_str := REPLACE(l_str, '>'); -- get rid of close brackets
249: l_str := REPLACE(l_str, '"'); -- get rid of double quotes
250: l_str := REPLACE(l_str, ''''); -- get rid of double quotes
907: At_least_one:= 'N';
908: xml_request := '';
909: xml_request := 'xml_request=' ||
910: '
911: '
913: l_return_status := fnd_api.g_ret_sts_success;
914: l_loc_rec := p_loc_array(i);
915: l_form_us :=
947: -- '
948: '
949: l_form_us ||
950: '
951: '' || FND_GLOBAL.local_chr(10);
952: END IF;
953: END LOOP;
954: END IF;
955: