DBA Data[Home] [Help]

APPS.CSP_PLANNING_UTILS_PKG dependencies on FND_MESSAGE

Line 152: FND_MESSAGE.RETRIEVE(L_MSG);

148: '','','','','','','','','','');
149: End If;
150:
151: --If l_req_id = 0 Then
152: FND_MESSAGE.RETRIEVE(L_MSG);
153: --End If;
154: open the_cursor FOR
155: select l_req_id,l_msg from DUAL;
156: RETURN the_cursor;

Line 202: FND_MESSAGE.RETRIEVE(l_msg);

198: P_ORG_ID => P_ORG_ID,
199: P_LANG_CODE => P_LANG_CODE,
200: P_ENCRYPTPARAMETERS => P_ENCRYPTPARAMETERS);
201: If v_return=null Then
202: FND_MESSAGE.RETRIEVE(l_msg);
203: End If;
204: open url_cur FOR
205: select v_Return,l_msg from DUAL;
206: RETURN url_cur;

Line 212: fnd_message.set_name(app_name, msg_name);

208: function get_message(app_name varchar2,msg_name varchar2,token1 varchar2,value1 varchar2, token2 varchar2, value2 varchar2, token3 varchar2, value3 varchar2,
209: token4 varchar2, value4 varchar2,token5 varchar2, value5 varchar2) return varchar2 as
210: l_msg varchar2(4000);
211: begin
212: fnd_message.set_name(app_name, msg_name);
213: if token1 <> null then
214: fnd_message.set_token(token1,value1, false);
215: elsif token2 <> null then
216: fnd_message.set_token(token2,value2, false);

Line 214: fnd_message.set_token(token1,value1, false);

210: l_msg varchar2(4000);
211: begin
212: fnd_message.set_name(app_name, msg_name);
213: if token1 <> null then
214: fnd_message.set_token(token1,value1, false);
215: elsif token2 <> null then
216: fnd_message.set_token(token2,value2, false);
217: elsif token3 <> null then
218: fnd_message.set_token(token3,value3, false);

Line 216: fnd_message.set_token(token2,value2, false);

212: fnd_message.set_name(app_name, msg_name);
213: if token1 <> null then
214: fnd_message.set_token(token1,value1, false);
215: elsif token2 <> null then
216: fnd_message.set_token(token2,value2, false);
217: elsif token3 <> null then
218: fnd_message.set_token(token3,value3, false);
219: elsif token4 <> null then
220: fnd_message.set_token(token4,value4, false);

Line 218: fnd_message.set_token(token3,value3, false);

214: fnd_message.set_token(token1,value1, false);
215: elsif token2 <> null then
216: fnd_message.set_token(token2,value2, false);
217: elsif token3 <> null then
218: fnd_message.set_token(token3,value3, false);
219: elsif token4 <> null then
220: fnd_message.set_token(token4,value4, false);
221: elsif token5 <> null then
222: fnd_message.set_token(token5,value5, false);

Line 220: fnd_message.set_token(token4,value4, false);

216: fnd_message.set_token(token2,value2, false);
217: elsif token3 <> null then
218: fnd_message.set_token(token3,value3, false);
219: elsif token4 <> null then
220: fnd_message.set_token(token4,value4, false);
221: elsif token5 <> null then
222: fnd_message.set_token(token5,value5, false);
223: end if;
224: l_msg := fnd_message.get;

Line 222: fnd_message.set_token(token5,value5, false);

218: fnd_message.set_token(token3,value3, false);
219: elsif token4 <> null then
220: fnd_message.set_token(token4,value4, false);
221: elsif token5 <> null then
222: fnd_message.set_token(token5,value5, false);
223: end if;
224: l_msg := fnd_message.get;
225: return l_msg;
226: END;

Line 224: l_msg := fnd_message.get;

220: fnd_message.set_token(token4,value4, false);
221: elsif token5 <> null then
222: fnd_message.set_token(token5,value5, false);
223: end if;
224: l_msg := fnd_message.get;
225: return l_msg;
226: END;
227: FUNCTION SET_CONTEXT (P_USER_ID IN VARCHAR2 ,P_RESP_ID IN VARCHAR2,P_RESP_APPL_ID IN VARCHAR2,
228: P_SECURITY_GROUP_ID IN NUMBER) RETURN VARCHAR2