DBA Data[Home] [Help]

APPS.MWA_UTL_SM_PKG dependencies on FND_GLOBAL

Line 25: request_string := request_string || 'USERS' || fnd_global.local_chr(13);

21:
22: begin
23: request_string := 'http://' || server_host || ':' || server_port || '/';
24: request_string := request_string || user_name || ',' || password || ',_,';
25: request_string := request_string || 'USERS' || fnd_global.local_chr(13);
26: users := utl_http.request(request_string, proxy_host);
27:
28: curtIndex := instr(users, 'FAIL');
29: -- dbms_output.put_line('curtIndex of string FAIL is ' || curtIndex);

Line 42: if (users = fnd_global.local_chr(10)) then

38: done := false;
39:
40: while (NOT done) LOOP
41: -- string comparison uses '='
42: if (users = fnd_global.local_chr(10)) then
43: -- dbms_output.put_line('No more users....done!');
44: done := true;
45: status := 'S';
46: else

Line 47: curtIndex := instr(users, fnd_global.local_chr(10));

43: -- dbms_output.put_line('No more users....done!');
44: done := true;
45: status := 'S';
46: else
47: curtIndex := instr(users, fnd_global.local_chr(10));
48: -- dbms_output.put_line('curtIndex is ' || curtIndex);
49: tempString := substr(users, 0, curtIndex-1);
50: -- dbms_output.put_line('tempString is ' || tempString);
51: users := substr(users, curtIndex+1);

Line 80: request_string := request_string || message || fnd_global.local_chr(13);

76: begin
77: request_string := 'http://' || server_host || ':' || server_port || '/';
78: request_string := request_string || user_name || ',' || password || ',_,';
79: request_string := request_string || 'MESSAGE ' || recipient || ' ';
80: request_string := request_string || message || fnd_global.local_chr(13);
81: result := utl_http.request(request_string, proxy_host);
82: -- dbms_output.put_line('output of Send_Message is ' || result);
83: curtIndex := instr(result, 'FAIL');
84: -- dbms_output.put_line('curtIndex of string FAIL is ' || curtIndex);