APPS.WF_WL_LISTS_PKG dependencies on WF_WL_LISTS_PKG

Line 1: package body WF_WL_LISTS_PKG as

1: package body WF_WL_LISTS_PKG as
2: /* $Header: wfwllstb.pls 120.0.12020000.4 2013/05/15 21:26:41 alsosa noship $ */
3: function FIND_LIST_ID(p_list_key in VARCHAR2) return number is
4: l_list_id number;
5: begin

Line 28: raise_application_error (-20000, 'WF_WL_LISTS_PKG.FIND_USER_ID: unable to find user '||p_user_name);

24: end if;
25: return l_user_id;
26: exception
27: when others then
28: raise_application_error (-20000, 'WF_WL_LISTS_PKG.FIND_USER_ID: unable to find user '||p_user_name);
29: end FIND_USER_ID;
30:
31: procedure INSERT_LIST_BY_KEY (X_LIST_KEY in VARCHAR2,
32: X_USER_NAME in VARCHAR2,

Line 113: raise_application_error (-20000, 'WF_WL_LISTS_PKG.INSERT_LIST_BY_KEY: unable to create list '||X_LIST_KEY);

109: open c_newrow;
110: fetch c_newrow into X_ROWID;
111: if (c_newrow%notfound) then
112: close c_newrow;
113: raise_application_error (-20000, 'WF_WL_LISTS_PKG.INSERT_LIST_BY_KEY: unable to create list '||X_LIST_KEY);
114: end if;
115: close c_newrow;
116: end INSERT_LIST_BY_KEY;
117:

Line 205: raise_application_error (-20000, 'WF_WL_LISTS_PKG.ADD_LANGUAGE: unable to add '||userenv('LANG')||' translation due to error '||sqlcode);

201: where B.LIST_ID = TL.LIST_ID and
202: TL.LANGUAGE = L.LANGUAGE_CODE);
203: exception
204: when others then
205: raise_application_error (-20000, 'WF_WL_LISTS_PKG.ADD_LANGUAGE: unable to add '||userenv('LANG')||' translation due to error '||sqlcode);
206: end ADD_LANGUAGE;
207:
208: procedure TRANSLATE_LIST_BY_KEY (X_LIST_KEY in VARCHAR2,
209: X_LIST_NAME in VARCHAR2,

Line 227: raise_application_error (-20000, 'WF_WL_LISTS_PKG.TRANSLATE_LIST_BY_KEY: unable to translate list '||X_LIST_KEY||'. Ensure base language is uploaded first');

223: TL.LAST_UPDATE_LOGIN = 0
224: WHERE LIST_ID = l_list_id and
225: userenv('LANG') in (LANGUAGE,SOURCE_LANG);
226: IF (sql%rowcount=0) THEN
227: raise_application_error (-20000, 'WF_WL_LISTS_PKG.TRANSLATE_LIST_BY_KEY: unable to translate list '||X_LIST_KEY||'. Ensure base language is uploaded first');
228: END IF;
229: end TRANSLATE_LIST_BY_KEY;
230:
231: procedure INSERT_FAVORITE_BY_KEY (X_LIST_KEY in VARCHAR2,

Line 242: raise_application_error (-20000, 'WF_WL_LISTS_PKG.INSERT_FAVORITE_BY_KEY: null value(s) when creating favorite list '||X_LIST_KEY||' for user '||X_USER_NAME);

238: l_luby number := FND_LOAD_UTIL.OWNER_ID(X_OWNER);
239: l_ludate date := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
240: begin
241: if l_list_id is null or l_user_id is null then
242: raise_application_error (-20000, 'WF_WL_LISTS_PKG.INSERT_FAVORITE_BY_KEY: null value(s) when creating favorite list '||X_LIST_KEY||' for user '||X_USER_NAME);
243: end if;
244: insert into WF_WL_FAVORITE_LISTS (LIST_ID,
245: USER_ID,
246: SEQUENCE,

Line 264: raise_application_error (-20000, 'WF_WL_LISTS_PKG.INSERT_FAVORITE_BY_KEY: unable to create favorite list '||X_LIST_KEY||' for user '||X_USER_NAME||'. '||SQLCODE);

260: 0, --LAST_UPDATE_LOGIN,
261: FND_GLOBAL.SECURITY_GROUP_ID);
262: exception
263: when others then
264: raise_application_error (-20000, 'WF_WL_LISTS_PKG.INSERT_FAVORITE_BY_KEY: unable to create favorite list '||X_LIST_KEY||' for user '||X_USER_NAME||'. '||SQLCODE);
265: end INSERT_FAVORITE_BY_KEY;
266:
267: procedure UPDATE_FAVORITE_BY_KEY (X_LIST_KEY in VARCHAR2,
268: X_USER_NAME in VARCHAR2,

Line 293: raise_application_error (-20000, 'WF_WL_LISTS_PKG.UPDATE_FAVORITE_BY_KEY: unable to update favorite list '||X_LIST_KEY||' for user '||X_USER_NAME||'. '||SQLCODE);

289: X_LAST_UPDATE_DATE => UPDATE_FAVORITE_BY_KEY.X_LAST_UPDATE_DATE);
290: end if;
291: exception
292: when others then
293: raise_application_error (-20000, 'WF_WL_LISTS_PKG.UPDATE_FAVORITE_BY_KEY: unable to update favorite list '||X_LIST_KEY||' for user '||X_USER_NAME||'. '||SQLCODE);
294: end UPDATE_FAVORITE_BY_KEY;
295:
296: end WF_WL_LISTS_PKG;

Line 296: end WF_WL_LISTS_PKG;

292: when others then
293: raise_application_error (-20000, 'WF_WL_LISTS_PKG.UPDATE_FAVORITE_BY_KEY: unable to update favorite list '||X_LIST_KEY||' for user '||X_USER_NAME||'. '||SQLCODE);
294: end UPDATE_FAVORITE_BY_KEY;
295:
296: end WF_WL_LISTS_PKG;