DBA Data[Home] [Help]

APPS.AZW_FLOW dependencies on FND_MESSAGE

Line 34: fnd_message.set_name('AZ','AZW_PLSQL_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');
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');

Line 35: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);

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');
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;

Line 36: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);

32: WHEN OTHERS THEN
33: --DBMS_OUTPUT.PUT_LINE('error: process_not_found: ' || SQLERRM);
34: fnd_message.set_name('AZ','AZW_PLSQL_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;

Line 37: fnd_message.set_token('AZW_ERROR_PROC','azw_flow.application_not_found');

33: --DBMS_OUTPUT.PUT_LINE('error: process_not_found: ' || SQLERRM);
34: fnd_message.set_name('AZ','AZW_PLSQL_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:

Line 38: fnd_message.set_token('AZW_ERROR_STMT','select count(*) from az_product_phases');

34: fnd_message.set_name('AZ','AZW_PLSQL_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:

Line 180: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');

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);
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');

Line 181: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);

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);
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;

Line 182: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);

178: RAISE;
179: WHEN OTHERS THEN
180: fnd_message.set_name('AZ','AZW_PLSQL_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;

Line 183: fnd_message.set_token('AZW_ERROR_PROC','azw_flow.populate_product_flows');

179: WHEN OTHERS THEN
180: fnd_message.set_name('AZ','AZW_PLSQL_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:

Line 184: fnd_message.set_token('AZW_ERROR_STMT','CURSOR applications_cursor');

180: fnd_message.set_name('AZ','AZW_PLSQL_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:

Line 236: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');

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);
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');

Line 237: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);

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);
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;

Line 238: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);

234: RAISE;
235: WHEN OTHERS THEN
236: fnd_message.set_name('AZ','AZW_PLSQL_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;

Line 239: fnd_message.set_token('AZW_ERROR_PROC','azw_flow.populate_product_flows');

235: WHEN OTHERS THEN
236: fnd_message.set_name('AZ','AZW_PLSQL_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:

Line 240: fnd_message.set_token('AZW_ERROR_STMT','CURSOR processes_cursor');

236: fnd_message.set_name('AZ','AZW_PLSQL_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

Line 258: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');

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);
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');

Line 259: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);

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);
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;

Line 260: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);

256: RAISE;
257: WHEN OTHERS THEN
258: fnd_message.set_name('AZ','AZW_PLSQL_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;

Line 261: fnd_message.set_token('AZW_ERROR_PROC','azw_flow.populate_product_flows');

257: WHEN OTHERS THEN
258: fnd_message.set_name('AZ','AZW_PLSQL_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:

Line 262: fnd_message.set_token('AZW_ERROR_STMT','delete from az_processes');

258: fnd_message.set_name('AZ','AZW_PLSQL_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;

Line 272: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');

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);
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');

Line 273: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);

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);
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;

Line 274: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);

270: RAISE;
271: WHEN OTHERS THEN
272: fnd_message.set_name('AZ','AZW_PLSQL_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;

Line 275: fnd_message.set_token('AZW_ERROR_PROC','azw_flow.populate_product_flows');

271: WHEN OTHERS THEN
272: fnd_message.set_name('AZ','AZW_PLSQL_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:

Line 276: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');

272: fnd_message.set_name('AZ','AZW_PLSQL_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;