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;
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;
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);
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);
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);
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);
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;
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;
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