APPS.WF_WL_REGIONS_PKG dependencies on WF_WL_REGIONS_PKG

Line 1: package body WF_WL_REGIONS_PKG as

1: package body WF_WL_REGIONS_PKG as
2: /* $Header: wfwlregb.pls 120.0.12020000.5 2013/05/15 21:23:22 alsosa noship $ */
3: g_mode varchar2(10);
4:
5: procedure LoaderSetMode(x_mode in varchar2) is

Line 53: raise_application_error (-20000, 'WF_WL_REGIONS_PKG.FIND_REGION_ID: unable to find region '||X_KEY);

49: where REGION_KEY=X_KEY;
50: return l_region_id;
51: exception
52: when others then
53: raise_application_error (-20000, 'WF_WL_REGIONS_PKG.FIND_REGION_ID: unable to find region '||X_KEY);
54: end FIND_REGION_ID;
55:
56: procedure INSERT_REGION_BY_KEY (X_REGION_KEY in VARCHAR2,
57: X_REGION in VARCHAR2,

Line 143: raise_application_error (-20000, 'WF_WL_REGIONS_PKG.INSERT_REGION_BY_KEY: unable to create region '||X_REGION_KEY);

139: open c_newrow;
140: fetch c_newrow into l_rowid;
141: if (c_newrow%notfound) then
142: close c_newrow;
143: raise_application_error (-20000, 'WF_WL_REGIONS_PKG.INSERT_REGION_BY_KEY: unable to create region '||X_REGION_KEY);
144: end if;
145: close c_newrow;
146: end INSERT_REGION_BY_KEY;
147:

Line 197: raise_application_error(-20000, 'WF_WL_REGIONS_PKG.UPDATE_REGION_BY_KEY unable to load region '||X_REGION_KEY||' due to customization');

193: if (sql%notfound) then
194: raise no_data_found;
195: end if;
196: else
197: raise_application_error(-20000, 'WF_WL_REGIONS_PKG.UPDATE_REGION_BY_KEY unable to load region '||X_REGION_KEY||' due to customization');
198: end if;
199: end if;
200: TRANSLATE_REGION_BY_KEY (X_REGION_KEY => UPDATE_REGION_BY_KEY.X_REGION_KEY,
201: X_TITLE => UPDATE_REGION_BY_KEY.X_TITLE,

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

252: where B.REGION_ID = TL.REGION_ID and
253: TL.LANGUAGE = L.LANGUAGE_CODE);
254: exception
255: when others then
256: raise_application_error (-20000, 'WF_WL_REGIONS_PKG.ADD_LANGUAGE: unable to add '||userenv('LANG')||' translation due to error '||sqlcode);
257: end ADD_LANGUAGE;
258:
259: procedure TRANSLATE_REGION_BY_KEY (X_REGION_KEY in VARCHAR2,
260: X_TITLE in VARCHAR2,

Line 277: raise_application_error(-20000, 'WF_WL_REGIONS_PKG.TRANSLATE_REGION_BY_KEY unable to find region '

273: TL.LAST_UPDATED_BY = l_luby
274: WHERE TL.REGION_ID = l_region_id and
275: userenv('LANG') in (TL.LANGUAGE, TL.SOURCE_LANG);
276: IF (sql%rowcount=0) THEN
277: raise_application_error(-20000, 'WF_WL_REGIONS_PKG.TRANSLATE_REGION_BY_KEY unable to find region '
278: ||X_REGION_KEY||'. Ensure base language is uploaded first');
279: END IF;
280:
281: end TRANSLATE_REGION_BY_KEY;

Line 282: end WF_WL_REGIONS_PKG;

278: ||X_REGION_KEY||'. Ensure base language is uploaded first');
279: END IF;
280:
281: end TRANSLATE_REGION_BY_KEY;
282: end WF_WL_REGIONS_PKG;