DBA Data[Home] [Help]

APPS.XNP_PIPE dependencies on DBMS_PIPE

Line 20: l_msg_status := dbms_pipe.receive_message(p_pipe_name, p_timeout) ;

16:
17: x_error_code := 0 ;
18: x_error_message := 'No Errors' ;
19:
20: l_msg_status := dbms_pipe.receive_message(p_pipe_name, p_timeout) ;
21:
22: if (l_msg_status = 0) then
23: dbms_pipe.unpack_message(x_msg_text) ;
24: elsif (l_msg_status = 1) then

Line 23: dbms_pipe.unpack_message(x_msg_text) ;

19:
20: l_msg_status := dbms_pipe.receive_message(p_pipe_name, p_timeout) ;
21:
22: if (l_msg_status = 0) then
23: dbms_pipe.unpack_message(x_msg_text) ;
24: elsif (l_msg_status = 1) then
25: x_error_code := xnp_errors.g_no_msg_in_pipe ;
26: x_error_message := 'No message in pipe - timedout' ;
27: --We donot use this message for anything - fnd_message.get is a DB call!!

Line 61: dbms_pipe.purge(p_pipe_name) ;

57:
58: x_error_code := 0 ;
59: x_error_message := 'No Errors' ;
60:
61: dbms_pipe.purge(p_pipe_name) ;
62:
63: dbms_pipe.pack_message(p_msg_text) ;
64:
65: l_status := dbms_pipe.send_message(p_pipe_name, p_timeout) ;

Line 63: dbms_pipe.pack_message(p_msg_text) ;

59: x_error_message := 'No Errors' ;
60:
61: dbms_pipe.purge(p_pipe_name) ;
62:
63: dbms_pipe.pack_message(p_msg_text) ;
64:
65: l_status := dbms_pipe.send_message(p_pipe_name, p_timeout) ;
66:
67: if (l_status <> 0) then

Line 65: l_status := dbms_pipe.send_message(p_pipe_name, p_timeout) ;

61: dbms_pipe.purge(p_pipe_name) ;
62:
63: dbms_pipe.pack_message(p_msg_text) ;
64:
65: l_status := dbms_pipe.send_message(p_pipe_name, p_timeout) ;
66:
67: if (l_status <> 0) then
68: x_error_code := xnp_errors.g_pipe_write_failure ;
69: x_error_message := 'Failed to write to the specified pipe';