APPS.WF_WL_RULES_PKG dependencies on WF_WL_RULES_PKG

Line 1: package body WF_WL_RULES_PKG as

1: package body WF_WL_RULES_PKG as
2: /* $Header: wfwlrulb.pls 120.0.12020000.5 2013/05/15 21:29:38 alsosa noship $ */
3:
4: function FIND_RULE_ID (X_KEY in VARCHAR2) return number is
5: l_rule_id number;

Line 13: raise_application_error (-20000, 'WF_WL_RULES_PKG.FIND_RULE_ID: unable to find rule key '||X_KEY);

9: where RULE_KEY=X_KEY;
10: return l_rule_id;
11: exception
12: when others then
13: raise_application_error (-20000, 'WF_WL_RULES_PKG.FIND_RULE_ID: unable to find rule key '||X_KEY);
14: end FIND_RULE_ID;
15:
16:
17: procedure INSERT_RULE_BY_KEY (X_RULE_KEY in VARCHAR2,

Line 95: raise_application_error (-20000, 'WF_WL_RULES_PKG.INSERT_RULE_BY_KEY: unable to create new rule '||X_RULE_KEY);

91: open c_newrow;
92: fetch c_newrow into l_rowid;
93: if (c_newrow%notfound) then
94: close c_newrow;
95: raise_application_error (-20000, 'WF_WL_RULES_PKG.INSERT_RULE_BY_KEY: unable to create new rule '||X_RULE_KEY);
96: end if;
97: close c_newrow;
98: end INSERT_RULE_BY_KEY;
99:

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

128: where B.RULE_ID = TL.RULE_ID and
129: TL.LANGUAGE = L.LANGUAGE_CODE);
130: exception
131: when others then
132: raise_application_error (-20000, 'WF_WL_RULES_PKG.ADD_LANGUAGE: unable to add '||userenv('LANG')||' translation due to error '||sqlcode);
133: end ADD_LANGUAGE;
134:
135: procedure TRANSLATE_RULE_BY_KEY (X_RULE_KEY in VARCHAR2,
136: X_RULE_NAME in VARCHAR2,

Line 152: raise_application_error (-20000, 'WF_WL_RULES_PKG.TRANSLATE_RULE_BY_KEY: unable to find rule '

148: TL.LAST_UPDATE_LOGIN = 0
149: WHERE RULE_ID = l_rule_id and
150: userenv('LANG') in (LANGUAGE,SOURCE_LANG);
151: IF (sql%rowcount=0) THEN
152: raise_application_error (-20000, 'WF_WL_RULES_PKG.TRANSLATE_RULE_BY_KEY: unable to find rule '
153: ||X_RULE_KEY||'. Ensure base language is uploaded first');
154: END IF;
155: end TRANSLATE_RULE_BY_KEY;
156:

Line 204: l_rule_id number := WF_WL_RULES_PKG.FIND_RULE_ID(X_RULE_KEY);

200: X_RULE_KEY in VARCHAR2,
201: X_OWNER IN VARCHAR2,
202: X_LAST_UPDATE_DATE IN VARCHAR2) is
203: l_region_id number := WF_WL_REGIONS_PKG.FIND_REGION_ID(X_REGION_KEY);
204: l_rule_id number := WF_WL_RULES_PKG.FIND_RULE_ID(X_RULE_KEY);
205: l_luby number := FND_LOAD_UTIL.OWNER_ID(X_OWNER);
206: l_ludate date := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
207: begin
208: begin

Line 229: raise_application_error (-20000, 'WF_WL_RULES_PKG.INSERT_REGION_RULE_BY_KEY: unable to create region rule '||X_REGION_KEY||'/'||X_RULE_KEY);

225: exception
226: when DUP_VAL_ON_INDEX then
227: null; --The combination already exists. Nothing else to do
228: when others then
229: raise_application_error (-20000, 'WF_WL_RULES_PKG.INSERT_REGION_RULE_BY_KEY: unable to create region rule '||X_REGION_KEY||'/'||X_RULE_KEY);
230: end;
231: end INSERT_REGION_RULE_BY_KEY;
232: end WF_WL_RULES_PKG;

Line 232: end WF_WL_RULES_PKG;

228: when others then
229: raise_application_error (-20000, 'WF_WL_RULES_PKG.INSERT_REGION_RULE_BY_KEY: unable to create region rule '||X_REGION_KEY||'/'||X_RULE_KEY);
230: end;
231: end INSERT_REGION_RULE_BY_KEY;
232: end WF_WL_RULES_PKG;