APPS.AZW_FLOW dependencies on APP_EXCEPTION

Line 30: WHEN app_exception.application_exception THEN

26: END IF;
27: RETURN ret;
28:
29: EXCEPTION
30: WHEN app_exception.application_exception THEN
31: RAISE;
32: WHEN OTHERS THEN
33: --DBMS_OUTPUT.PUT_LINE('error: process_not_found: ' || SQLERRM);
34: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');

Line 39: APP_EXCEPTION.RAISE_EXCEPTION;

35: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
36: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
37: fnd_message.set_token('AZW_ERROR_PROC','azw_flow.application_not_found');
38: fnd_message.set_token('AZW_ERROR_STMT','select count(*) from az_product_phases');
39: APP_EXCEPTION.RAISE_EXCEPTION;
40: END application_not_found;
41:
42:
43: --

Line 177: WHEN app_exception.application_exception THEN

173: FETCH applications_cursor INTO v_installed_prod_id;
174: END LOOP;
175: CLOSE applications_cursor;
176: EXCEPTION
177: WHEN app_exception.application_exception THEN
178: RAISE;
179: WHEN OTHERS THEN
180: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
181: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);

Line 185: APP_EXCEPTION.RAISE_EXCEPTION;

181: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
182: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
183: fnd_message.set_token('AZW_ERROR_PROC','azw_flow.populate_product_flows');
184: fnd_message.set_token('AZW_ERROR_STMT','CURSOR applications_cursor');
185: APP_EXCEPTION.RAISE_EXCEPTION;
186: END;
187:
188:
189: BEGIN

Line 233: WHEN app_exception.application_exception THEN

229:
230: CLOSE processes_cursor;
231:
232: EXCEPTION
233: WHEN app_exception.application_exception THEN
234: RAISE;
235: WHEN OTHERS THEN
236: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
237: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);

Line 241: APP_EXCEPTION.RAISE_EXCEPTION;

237: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
238: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
239: fnd_message.set_token('AZW_ERROR_PROC','azw_flow.populate_product_flows');
240: fnd_message.set_token('AZW_ERROR_STMT','CURSOR processes_cursor');
241: APP_EXCEPTION.RAISE_EXCEPTION;
242: END;
243:
244: --Do a clean-up of AZ_PROCESSES for processes not in AZ_PRODUCT_FLOWS
245:

Line 255: WHEN app_exception.application_exception THEN

251: OR not exists
252: (SELECT process_name from AZ_PRODUCT_FLOWS apf
253: where apf.process_name = ap.process_name);
254: EXCEPTION
255: WHEN app_exception.application_exception THEN
256: RAISE;
257: WHEN OTHERS THEN
258: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
259: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);

Line 263: APP_EXCEPTION.RAISE_EXCEPTION;

259: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
260: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
261: fnd_message.set_token('AZW_ERROR_PROC','azw_flow.populate_product_flows');
262: fnd_message.set_token('AZW_ERROR_STMT','delete from az_processes');
263: APP_EXCEPTION.RAISE_EXCEPTION;
264: END;
265:
266: COMMIT;
267:

Line 269: WHEN app_exception.application_exception THEN

265:
266: COMMIT;
267:
268: EXCEPTION
269: WHEN app_exception.application_exception THEN
270: RAISE;
271: WHEN OTHERS THEN
272: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
273: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);

Line 277: APP_EXCEPTION.RAISE_EXCEPTION;

273: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
274: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
275: fnd_message.set_token('AZW_ERROR_PROC','azw_flow.populate_product_flows');
276: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
277: APP_EXCEPTION.RAISE_EXCEPTION;
278: END populate_product_flows;
279:
280: END AZW_FLOW;