DBA Data[Home] [Help]

APPS.JTS_SETUP_FLOW_HIEARCHY_PKG dependencies on APP_EXCEPTION

Line 23: APP_EXCEPTION.RAISE_EXCEPTION;

19:
20: return (l_flow_id);
21: EXCEPTION
22: WHEN OTHERS THEN
23: APP_EXCEPTION.RAISE_EXCEPTION;
24: END GET_NEXT_FLOW_ID;
25:
26: FUNCTION GET_FLOW_ID(p_code IN VARCHAR2) RETURN NUMBER IS
27: l_flow_id JTS_SETUP_FLOWS_B.flow_id%TYPE := NULL;

Line 38: APP_EXCEPTION.RAISE_EXCEPTION;

34: EXCEPTION
35: WHEN NO_DATA_FOUND THEN
36: return NULL;
37: WHEN OTHERS THEN
38: APP_EXCEPTION.RAISE_EXCEPTION;
39: END GET_FLOW_ID;
40:
41: -------------------------------------------------
42: -- This is for seeding the Flow hiearchy.

Line 142: APP_EXCEPTION.RAISE_EXCEPTION;

138: and T.LANGUAGE = L.LANGUAGE_CODE);
139:
140: EXCEPTION
141: WHEN OTHERS THEN
142: APP_EXCEPTION.RAISE_EXCEPTION;
143:
144: END INSERT_ROW;
145:
146: -------------------------------------------------

Line 160: APP_EXCEPTION.RAISE_EXCEPTION;

156: WHERE flow_code = p_flow_code;
157:
158: EXCEPTION
159: WHEN OTHERS THEN
160: APP_EXCEPTION.RAISE_EXCEPTION;
161:
162: END DELETE_ROW;
163:
164: -------------------------------------------------

Line 178: APP_EXCEPTION.RAISE_EXCEPTION;

174: WHERE flow_id = p_flow_id;
175:
176: EXCEPTION
177: WHEN OTHERS THEN
178: APP_EXCEPTION.RAISE_EXCEPTION;
179:
180: END DELETE_ROW;
181:
182: -------------------------------------------------

Line 243: APP_EXCEPTION.RAISE_EXCEPTION;

239: raise no_data_found;
240: end if;
241: EXCEPTION
242: WHEN OTHERS THEN
243: APP_EXCEPTION.RAISE_EXCEPTION;
244: end UPDATE_ROW;
245:
246: -------------------------------------------------
247: -- This is for seeding the Flow hiearchy.

Line 269: APP_EXCEPTION.RAISE_EXCEPTION;

265: and userenv('LANG') in (language, source_lang);
266:
267: EXCEPTION
268: WHEN OTHERS THEN
269: APP_EXCEPTION.RAISE_EXCEPTION;
270: END TRANSLATE_ROW;
271:
272: -------------------------------------------------
273: -- This is for seeding the Flow hiearchy.

Line 350: APP_EXCEPTION.RAISE_EXCEPTION;

346: );
347: end if;
348: EXCEPTION
349: WHEN OTHERS THEN
350: APP_EXCEPTION.RAISE_EXCEPTION;
351: END LOAD_ROW;
352:
353:
354: procedure LOCK_ROW (

Line 402: app_exception.raise_exception;

398: fetch c into recinfo;
399: if (c%notfound) then
400: close c;
401: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
402: app_exception.raise_exception;
403: end if;
404: close c;
405: if ( ((recinfo.FLOW_TYPE = X_FLOW_TYPE)
406: OR ((recinfo.FLOW_TYPE is null) AND (X_FLOW_TYPE is null)))

Line 429: app_exception.raise_exception;

425: ) then
426: null;
427: else
428: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
429: app_exception.raise_exception;
430: end if;
431:
432: for tlinfo in c1 loop
433: if (tlinfo.BASELANG = 'Y') then

Line 439: app_exception.raise_exception;

435: ) then
436: null;
437: else
438: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
439: app_exception.raise_exception;
440: end if;
441: end if;
442: end loop;
443: return;