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:
883: At_least_one:= 'N';
884: xml_request := '';
885: xml_request := 'xml_request=' ||
886: '
887: '
889: l_return_status := fnd_api.g_ret_sts_success;
890: l_loc_rec := p_loc_array(i);
891: l_form_us :=
922: 'multimatch_number= "3" >' ||
923: '
924: l_form_us ||
925: '
926: '' || FND_GLOBAL.local_chr(10);
927: END IF;
928: END LOOP;
929: END IF;
930: