APPS.GL_DRM_INTEGRATION_PKG dependencies on FND_NEW_MESSAGES

Line 105: l_n_msg_num fnd_new_messages.message_number%TYPE;

101: * vnetan 08/30/2010 Created
102: * +=======================================================================+*/
103: PROCEDURE list_gl_api_errors
104: AS
105: l_n_msg_num fnd_new_messages.message_number%TYPE;
106: l_s_msg_txt fnd_new_messages.message_text%TYPE;
107: l_s_msg_name fnd_new_messages.message_name%TYPE;
108: --
109: -- Function to get message from Message Stack

Line 106: l_s_msg_txt fnd_new_messages.message_text%TYPE;

102: * +=======================================================================+*/
103: PROCEDURE list_gl_api_errors
104: AS
105: l_n_msg_num fnd_new_messages.message_number%TYPE;
106: l_s_msg_txt fnd_new_messages.message_text%TYPE;
107: l_s_msg_name fnd_new_messages.message_name%TYPE;
108: --
109: -- Function to get message from Message Stack
110: --

Line 107: l_s_msg_name fnd_new_messages.message_name%TYPE;

103: PROCEDURE list_gl_api_errors
104: AS
105: l_n_msg_num fnd_new_messages.message_number%TYPE;
106: l_s_msg_txt fnd_new_messages.message_text%TYPE;
107: l_s_msg_name fnd_new_messages.message_name%TYPE;
108: --
109: -- Function to get message from Message Stack
110: --
111: FUNCTION get_msg_from_stack(l_n_msg_count NUMBER)

Line 114: l_s_msg_name fnd_new_messages.message_name%TYPE;

110: --
111: FUNCTION get_msg_from_stack(l_n_msg_count NUMBER)
112: RETURN VARCHAR2 AS
113: l_c_msg VARCHAR2(3000);
114: l_s_msg_name fnd_new_messages.message_name%TYPE;
115: l_appl_name VARCHAR2(30);
116: BEGIN
117: l_c_msg := FND_MSG_PUB.GET(p_msg_index => l_n_msg_count, p_encoded => 'T');
118: FND_MESSAGE.SET_ENCODED (l_c_msg);

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

128: p_n_msg_num OUT NOCOPY NUMBER,
129: p_c_msg_txt OUT NOCOPY VARCHAR2)
130: AS
131:
132: CURSOR c_msg(cp_c_msg_name fnd_new_messages.message_name%TYPE ) IS
133: SELECT
134: message_number,
135: message_text
136: FROM fnd_new_messages

Line 136: FROM fnd_new_messages

132: CURSOR c_msg(cp_c_msg_name fnd_new_messages.message_name%TYPE ) IS
133: SELECT
134: message_number,
135: message_text
136: FROM fnd_new_messages
137: WHERE application_id=101
138: AND language_code = UserEnv('LANG')
139: AND message_name=cp_c_msg_name;
140:

Line 561: l_rec_err FND_NEW_MESSAGES.message_text%TYPE;

557: l_val_valid BOOLEAN;
558: l_val_attr_valid BOOLEAN;
559: l_valid_hier BOOLEAN;
560: l_rec_valid BOOLEAN;
561: l_rec_err FND_NEW_MESSAGES.message_text%TYPE;
562:
563: -- variables for output
564: l_open_tag VARCHAR2(20);
565:

Line 931: l_c_msg_name fnd_new_messages.message_name%TYPE;

927: l_retcode VARCHAR2(10);
928: l_c_return_status VARCHAR2(1);
929: l_n_msg_count NUMBER(10);
930: l_s_msg_data VARCHAR2(2000);
931: l_c_msg_name fnd_new_messages.message_name%TYPE;
932: l_c_msg VARCHAR2(3000);
933: l_appl_name VARCHAR2(30);
934: l_gl_flex_values_status VARCHAR2(1);
935: l_gl_flex_values_nh_status VARCHAR2(1);

Line 1049: l_message_text FND_NEW_MESSAGES.message_text%TYPE;

1045: p_message_name IN VARCHAR2,
1046: p_message_token IN VARCHAR2 DEFAULT NULL,
1047: x_message_text OUT NOCOPY VARCHAR2)
1048: AS
1049: l_message_text FND_NEW_MESSAGES.message_text%TYPE;
1050: BEGIN
1051: FND_MESSAGE.set_name('SQLGL', p_message_name);
1052: IF p_message_token IS NOT NULL THEN
1053: FND_MESSAGE.set_token('TOKEN_VALUE', p_message_token);