APPS.IGS_PS_LGCY_CONC_PKG dependencies on FND_NEW_MESSAGES

Line 250: l_n_msg_num fnd_new_messages.message_number%TYPE;

246: l_n_chld_cntr NUMBER(7);
247: l_c_return_status VARCHAR2(1);
248: l_n_msg_count NUMBER(10);
249: l_c_msg_data VARCHAR2(2000);
250: l_n_msg_num fnd_new_messages.message_number%TYPE;
251: l_c_msg_txt fnd_new_messages.message_text%TYPE;
252: l_c_msg_name fnd_new_messages.message_name%TYPE;
253: l_appl_name VARCHAR2(30);
254:

Line 251: l_c_msg_txt fnd_new_messages.message_text%TYPE;

247: l_c_return_status VARCHAR2(1);
248: l_n_msg_count NUMBER(10);
249: l_c_msg_data VARCHAR2(2000);
250: l_n_msg_num fnd_new_messages.message_number%TYPE;
251: l_c_msg_txt fnd_new_messages.message_text%TYPE;
252: l_c_msg_name fnd_new_messages.message_name%TYPE;
253: l_appl_name VARCHAR2(30);
254:
255: rec_c_unit_ver c_unit_ver%ROWTYPE;

Line 252: l_c_msg_name fnd_new_messages.message_name%TYPE;

248: l_n_msg_count NUMBER(10);
249: l_c_msg_data VARCHAR2(2000);
250: l_n_msg_num fnd_new_messages.message_number%TYPE;
251: l_c_msg_txt fnd_new_messages.message_text%TYPE;
252: l_c_msg_name fnd_new_messages.message_name%TYPE;
253: l_appl_name VARCHAR2(30);
254:
255: rec_c_unit_ver c_unit_ver%ROWTYPE;
256: l_unit_ver_rec igs_ps_generic_pub.unit_ver_rec_type;

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

280: /* Procedure to get messages */
281:
282: PROCEDURE get_message(p_c_msg_name VARCHAR2,p_n_msg_num OUT NOCOPY NUMBER,p_c_msg_txt OUT NOCOPY VARCHAR2) AS
283:
284: CURSOR c_msg(cp_c_msg_name fnd_new_messages.message_name%TYPE ) IS
285: SELECT
286: message_number,
287: message_text
288: FROM fnd_new_messages

Line 288: FROM fnd_new_messages

284: CURSOR c_msg(cp_c_msg_name fnd_new_messages.message_name%TYPE ) IS
285: SELECT
286: message_number,
287: message_text
288: FROM fnd_new_messages
289: WHERE application_id=8405
290: AND language_code = USERENV('LANG')
291: AND message_name=cp_c_msg_name;
292:

Line 333: l_c_msg_name fnd_new_messages.message_name%TYPE;

329: /* Get message from Message Stack */
330:
331: FUNCTION get_msg_from_stack(l_n_msg_count NUMBER) RETURN VARCHAR2 AS
332: l_c_msg VARCHAR2(3000);
333: l_c_msg_name fnd_new_messages.message_name%TYPE;
334: BEGIN
335: l_c_msg := FND_MSG_PUB.GET(p_msg_index => l_n_msg_count, p_encoded => 'T');
336: FND_MESSAGE.SET_ENCODED (l_c_msg);
337: FND_MESSAGE.PARSE_ENCODED(FND_MESSAGE.GET_ENCODED,l_appl_name, l_c_msg_name);