APPS.GL_COA_SVIM_CONC_PKG dependencies on FND_NEW_MESSAGES

Line 60: l_n_msg_num fnd_new_messages.message_number%TYPE;

56: l_n_chld_cntr NUMBER(7);
57: l_c_return_status VARCHAR2(1);
58: l_n_msg_count NUMBER(10);
59: l_c_msg_data VARCHAR2(2000);
60: l_n_msg_num fnd_new_messages.message_number%TYPE;
61: l_c_msg_txt fnd_new_messages.message_text%TYPE;
62: l_c_msg_name fnd_new_messages.message_name%TYPE;
63: l_appl_name VARCHAR2(30);
64:

Line 61: l_c_msg_txt fnd_new_messages.message_text%TYPE;

57: l_c_return_status VARCHAR2(1);
58: l_n_msg_count NUMBER(10);
59: l_c_msg_data VARCHAR2(2000);
60: l_n_msg_num fnd_new_messages.message_number%TYPE;
61: l_c_msg_txt fnd_new_messages.message_text%TYPE;
62: l_c_msg_name fnd_new_messages.message_name%TYPE;
63: l_appl_name VARCHAR2(30);
64:
65:

Line 62: l_c_msg_name fnd_new_messages.message_name%TYPE;

58: l_n_msg_count NUMBER(10);
59: l_c_msg_data VARCHAR2(2000);
60: l_n_msg_num fnd_new_messages.message_number%TYPE;
61: l_c_msg_txt fnd_new_messages.message_text%TYPE;
62: l_c_msg_name fnd_new_messages.message_name%TYPE;
63: l_appl_name VARCHAR2(30);
64:
65:
66: l_n_request_id NUMBER(15,0);

Line 85: CURSOR c_msg(cp_c_msg_name fnd_new_messages.message_name%TYPE ) IS

81:
82: /* Procedure to get messages */
83: PROCEDURE get_message(p_c_msg_name VARCHAR2,p_n_msg_num OUT NOCOPY NUMBER,p_c_msg_txt OUT NOCOPY VARCHAR2) AS
84:
85: CURSOR c_msg(cp_c_msg_name fnd_new_messages.message_name%TYPE ) IS
86: SELECT
87: message_number,
88: message_text
89: FROM fnd_new_messages

Line 89: FROM fnd_new_messages

85: CURSOR c_msg(cp_c_msg_name fnd_new_messages.message_name%TYPE ) IS
86: SELECT
87: message_number,
88: message_text
89: FROM fnd_new_messages
90: WHERE application_id=101
91: AND language_code = USERENV('LANG')
92: AND message_name=cp_c_msg_name;
93:

Line 134: l_c_msg_name fnd_new_messages.message_name%TYPE;

130: /* Get message from Message Stack */
131:
132: FUNCTION get_msg_from_stack(l_n_msg_count NUMBER) RETURN VARCHAR2 AS
133: l_c_msg VARCHAR2(3000);
134: l_c_msg_name fnd_new_messages.message_name%TYPE;
135: BEGIN
136: l_c_msg := FND_MSG_PUB.GET(p_msg_index => l_n_msg_count, p_encoded => 'T');
137: FND_MESSAGE.SET_ENCODED (l_c_msg);
138: FND_MESSAGE.PARSE_ENCODED(FND_MESSAGE.GET_ENCODED,l_appl_name, l_c_msg_name);