APPS.WF_WL_VIEWS_PKG dependencies on WF_WL_VIEWS_PKG

Line 1: package body WF_WL_VIEWS_PKG as

1: package body WF_WL_VIEWS_PKG as
2: /* $Header: wfwlvwsb.pls 120.0.12020000.4 2013/05/15 21:24:52 alsosa noship $ */
3: g_mode varchar2(10);
4:
5: procedure LoaderSetMode(x_mode in varchar2) is

Line 46: raise_application_error (-20000, 'WF_WL_VIEWS_PKG.FIND_VIEW_KEY: unable to find viewid '||l_view_key);

42: where VIEW_ID=x_view_id;
43: return l_view_key;
44: exception
45: when others then
46: raise_application_error (-20000, 'WF_WL_VIEWS_PKG.FIND_VIEW_KEY: unable to find viewid '||l_view_key);
47: end FIND_VIEW_KEY;
48:
49: function FIND_VIEW_ID(X_KEY in VARCHAR2) return number is
50: l_view_id number;

Line 58: raise_application_error (-20000, 'WF_WL_VIEWS_PKG.FIND_VIEW_ID: unable to find view '||X_KEY);

54: where VIEW_KEY=X_KEY;
55: return l_view_id;
56: exception
57: when others then
58: raise_application_error (-20000, 'WF_WL_VIEWS_PKG.FIND_VIEW_ID: unable to find view '||X_KEY);
59: end FIND_VIEW_ID;
60:
61: function fetch_custom_level (p_view_key in varchar2) return varchar2 is
62: l_custom_level varchar2(1);

Line 176: raise_application_error (-20000, 'WF_WL_VIEWS_PKG.INSERT_VIEW_BY_KEY: unable to create view '||X_VIEW_KEY);

172: open c_newrow;
173: fetch c_newrow into l_rowid ;
174: if (c_newrow%notfound) then
175: close c_newrow;
176: raise_application_error (-20000, 'WF_WL_VIEWS_PKG.INSERT_VIEW_BY_KEY: unable to create view '||X_VIEW_KEY);
177: end if;
178: close c_newrow;
179: end INSERT_VIEW_BY_KEY;
180:

Line 250: raise_application_error(-20000, 'WF_WL_VIEWS_PKG.UPDATE_VIEW_BY_KEY unable to update view '||X_VIEW_KEY||' due to customization');

246: if (sql%notfound) then
247: raise no_data_found;
248: end if;
249: else
250: raise_application_error(-20000, 'WF_WL_VIEWS_PKG.UPDATE_VIEW_BY_KEY unable to update view '||X_VIEW_KEY||' due to customization');
251: end if;
252: end if;
253:
254: TRANSLATE_VIEW_BY_KEY (X_VIEW_KEY => UPDATE_VIEW_BY_KEY.X_VIEW_KEY ,

Line 317: raise_application_error(-20000, 'WF_WL_VIEWS_PKG.ADD_VIEW_ATTR_LANGUAGE unable to add '||userenv('LANG')||' translation due to error '||sqlcode);

313: TL.ATTRIBUTE_NAME = B.ATTRIBUTE_NAME and
314: TL.LANGUAGE = L.LANGUAGE_CODE);
315: exception
316: when others then
317: raise_application_error(-20000, 'WF_WL_VIEWS_PKG.ADD_VIEW_ATTR_LANGUAGE unable to add '||userenv('LANG')||' translation due to error '||sqlcode);
318: end ADD_VIEW_ATTR_LANGUAGE;
319:
320: procedure ADD_LANGUAGE is
321: l_view_id WF_WL_VIEWS_TL.VIEW_ID%TYPE;

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

353: where B.VIEW_ID = T.VIEW_ID
354: and T.LANGUAGE = L.LANGUAGE_CODE);
355: exception
356: when others then
357: raise_application_error(-20000, 'WF_WL_VIEWS_PKG.ADD_LANGUAGE unable to add '||userenv('LANG')||' translation due to error '||sqlcode);
358: end;
359: ADD_VIEW_ATTR_LANGUAGE;
360: end ADD_LANGUAGE;
361:

Line 386: raise_application_error(-20000, 'WF_WL_VIEWS_PKG.TRANSLATE_VIEW_BY_KEY unable to translate view '||X_VIEW_KEY||'. Ensure base language is uploaded first');

382: WHERE TL.VIEW_ID = l_view_id and
383: userenv('LANG') in (TL.LANGUAGE, TL.SOURCE_LANG);
384:
385: IF (sql%rowcount=0) THEN
386: raise_application_error(-20000, 'WF_WL_VIEWS_PKG.TRANSLATE_VIEW_BY_KEY unable to translate view '||X_VIEW_KEY||'. Ensure base language is uploaded first');
387: END IF;
388:
389: end TRANSLATE_VIEW_BY_KEY;
390:

Line 474: raise_application_error(-20000, 'WF_WL_VIEWS_PKG.INSERT_VIEW_ATTR_BY_KEY unable to create attribute '||X_ATTRIBUTE_NAME||' for view '||X_VIEW_KEY);

470: open c_newrow;
471: fetch c_newrow into l_row_id;
472: if (c_newrow%notfound) then
473: close c_newrow;
474: raise_application_error(-20000, 'WF_WL_VIEWS_PKG.INSERT_VIEW_ATTR_BY_KEY unable to create attribute '||X_ATTRIBUTE_NAME||' for view '||X_VIEW_KEY);
475: end if;
476: close c_newrow;
477: end INSERT_VIEW_ATTR_BY_KEY;
478:

Line 558: raise_application_error(-20000, 'WF_WL_VIEWS_PKG.TRANSLATE_VIEW_ATTR_BY_KEY unable to translate attribute '

554: WHERE TL.VIEW_ID = l_view_id and
555: TL.ATTRIBUTE_NAME = X_ATTRIBUTE_NAME and
556: userenv('LANG') in (TL.LANGUAGE, TL.SOURCE_LANG);
557: IF (sql%rowcount=0) THEN
558: raise_application_error(-20000, 'WF_WL_VIEWS_PKG.TRANSLATE_VIEW_ATTR_BY_KEY unable to translate attribute '
559: ||X_ATTRIBUTE_NAME||' for view '||X_VIEW_KEY||'. Ensure base language is uploaded first');
560: END IF;
561: end TRANSLATE_VIEW_ATTR_BY_KEY;
562:

Line 611: raise_application_error(-20000, 'WF_WL_VIEWS_PKG.INSERT_VIEW_PARAM_BY_KEY unable to create parameter '||X_PARAMETER_NAME||' for view '||X_VIEW_KEY);

607: open c_newrow;
608: fetch c_newrow into l_row_id;
609: if (c_newrow%notfound) then
610: close c_newrow;
611: raise_application_error(-20000, 'WF_WL_VIEWS_PKG.INSERT_VIEW_PARAM_BY_KEY unable to create parameter '||X_PARAMETER_NAME||' for view '||X_VIEW_KEY);
612: end if;
613: close c_newrow;
614: end INSERT_VIEW_PARAM_BY_KEY;
615:

Line 687: raise_application_error(-20000, 'WF_WL_VIEWS_PKG.INSERT_REGION_VIEW_BY_KEY unable to create region view '||X_REGION_KEY||'/'||X_VIEW_KEY);

683: exception
684: when DUP_VAL_ON_INDEX then
685: null; --The combination already exists. Nothing else to do
686: when others then
687: raise_application_error(-20000, 'WF_WL_VIEWS_PKG.INSERT_REGION_VIEW_BY_KEY unable to create region view '||X_REGION_KEY||'/'||X_VIEW_KEY);
688: end INSERT_REGION_VIEW_BY_KEY;
689: end WF_WL_VIEWS_PKG;

Line 689: end WF_WL_VIEWS_PKG;

685: null; --The combination already exists. Nothing else to do
686: when others then
687: raise_application_error(-20000, 'WF_WL_VIEWS_PKG.INSERT_REGION_VIEW_BY_KEY unable to create region view '||X_REGION_KEY||'/'||X_VIEW_KEY);
688: end INSERT_REGION_VIEW_BY_KEY;
689: end WF_WL_VIEWS_PKG;