68: WHEN app_exception.application_exception THEN
69: RAISE;
70: WHEN OTHERS THEN
71: --DBMS_OUTPUT.PUT_LINE('error: group_hierarchy_tree_not_found: ' || SQLERRM);
72: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
73: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
74: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
75: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_parent_group');
76: fnd_message.set_token('AZW_ERROR_STMT','select group_id from az_groups');
69: RAISE;
70: WHEN OTHERS THEN
71: --DBMS_OUTPUT.PUT_LINE('error: group_hierarchy_tree_not_found: ' || SQLERRM);
72: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
73: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
74: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
75: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_parent_group');
76: fnd_message.set_token('AZW_ERROR_STMT','select group_id from az_groups');
77: APP_EXCEPTION.RAISE_EXCEPTION;
70: WHEN OTHERS THEN
71: --DBMS_OUTPUT.PUT_LINE('error: group_hierarchy_tree_not_found: ' || SQLERRM);
72: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
73: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
74: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
75: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_parent_group');
76: fnd_message.set_token('AZW_ERROR_STMT','select group_id from az_groups');
77: APP_EXCEPTION.RAISE_EXCEPTION;
78: END get_parent_group;
71: --DBMS_OUTPUT.PUT_LINE('error: group_hierarchy_tree_not_found: ' || SQLERRM);
72: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
73: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
74: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
75: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_parent_group');
76: fnd_message.set_token('AZW_ERROR_STMT','select group_id from az_groups');
77: APP_EXCEPTION.RAISE_EXCEPTION;
78: END get_parent_group;
79:
72: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
73: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
74: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
75: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_parent_group');
76: fnd_message.set_token('AZW_ERROR_STMT','select group_id from az_groups');
77: APP_EXCEPTION.RAISE_EXCEPTION;
78: END get_parent_group;
79:
80:
102: EXCEPTION
103: WHEN app_exception.application_exception THEN
104: RAISE;
105: WHEN OTHERS THEN
106: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
107: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
108: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
109: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.parse_ctxt_id_task');
110: fnd_message.set_token('AZW_ERROR_STMT','NODE_ID :'|| node_id);
103: WHEN app_exception.application_exception THEN
104: RAISE;
105: WHEN OTHERS THEN
106: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
107: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
108: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
109: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.parse_ctxt_id_task');
110: fnd_message.set_token('AZW_ERROR_STMT','NODE_ID :'|| node_id);
111: APP_EXCEPTION.RAISE_EXCEPTION;
104: RAISE;
105: WHEN OTHERS THEN
106: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
107: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
108: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
109: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.parse_ctxt_id_task');
110: fnd_message.set_token('AZW_ERROR_STMT','NODE_ID :'|| node_id);
111: APP_EXCEPTION.RAISE_EXCEPTION;
112: END parse_ctxt_id_task;
105: WHEN OTHERS THEN
106: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
107: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
108: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
109: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.parse_ctxt_id_task');
110: fnd_message.set_token('AZW_ERROR_STMT','NODE_ID :'|| node_id);
111: APP_EXCEPTION.RAISE_EXCEPTION;
112: END parse_ctxt_id_task;
113:
106: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
107: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
108: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
109: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.parse_ctxt_id_task');
110: fnd_message.set_token('AZW_ERROR_STMT','NODE_ID :'|| node_id);
111: APP_EXCEPTION.RAISE_EXCEPTION;
112: END parse_ctxt_id_task;
113:
114:
142: EXCEPTION
143: WHEN app_exception.application_exception THEN
144: RAISE;
145: WHEN OTHERS THEN
146: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
147: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
148: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
149: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.process_not_found');
150: fnd_message.set_token('AZW_ERROR_STMT','select count(*) from az_processes');
143: WHEN app_exception.application_exception THEN
144: RAISE;
145: WHEN OTHERS THEN
146: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
147: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
148: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
149: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.process_not_found');
150: fnd_message.set_token('AZW_ERROR_STMT','select count(*) from az_processes');
151: APP_EXCEPTION.RAISE_EXCEPTION;
144: RAISE;
145: WHEN OTHERS THEN
146: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
147: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
148: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
149: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.process_not_found');
150: fnd_message.set_token('AZW_ERROR_STMT','select count(*) from az_processes');
151: APP_EXCEPTION.RAISE_EXCEPTION;
152: END process_not_found;
145: WHEN OTHERS THEN
146: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
147: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
148: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
149: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.process_not_found');
150: fnd_message.set_token('AZW_ERROR_STMT','select count(*) from az_processes');
151: APP_EXCEPTION.RAISE_EXCEPTION;
152: END process_not_found;
153:
146: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
147: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
148: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
149: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.process_not_found');
150: fnd_message.set_token('AZW_ERROR_STMT','select count(*) from az_processes');
151: APP_EXCEPTION.RAISE_EXCEPTION;
152: END process_not_found;
153:
154:
196: EXCEPTION
197: WHEN app_exception.application_exception THEN
198: APP_EXCEPTION.RAISE_EXCEPTION;
199: WHEN OTHERS THEN
200: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
201: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
202: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
203: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.parse_application_ids');
204: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
197: WHEN app_exception.application_exception THEN
198: APP_EXCEPTION.RAISE_EXCEPTION;
199: WHEN OTHERS THEN
200: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
201: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
202: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
203: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.parse_application_ids');
204: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
205: APP_EXCEPTION.RAISE_EXCEPTION;
198: APP_EXCEPTION.RAISE_EXCEPTION;
199: WHEN OTHERS THEN
200: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
201: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
202: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
203: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.parse_application_ids');
204: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
205: APP_EXCEPTION.RAISE_EXCEPTION;
206: END parse_application_ids;
199: WHEN OTHERS THEN
200: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
201: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
202: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
203: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.parse_application_ids');
204: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
205: APP_EXCEPTION.RAISE_EXCEPTION;
206: END parse_application_ids;
207:
200: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
201: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
202: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
203: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.parse_application_ids');
204: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
205: APP_EXCEPTION.RAISE_EXCEPTION;
206: END parse_application_ids;
207:
208:
227: EXCEPTION
228: WHEN app_exception.application_exception THEN
229: RAISE;
230: WHEN OTHERS THEN
231: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
232: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
233: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
234: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.parse_item_type');
235: fnd_message.set_token('AZW_ERROR_STMT','NODE_ID:'|| node_id);
228: WHEN app_exception.application_exception THEN
229: RAISE;
230: WHEN OTHERS THEN
231: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
232: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
233: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
234: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.parse_item_type');
235: fnd_message.set_token('AZW_ERROR_STMT','NODE_ID:'|| node_id);
236: APP_EXCEPTION.RAISE_EXCEPTION;
229: RAISE;
230: WHEN OTHERS THEN
231: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
232: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
233: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
234: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.parse_item_type');
235: fnd_message.set_token('AZW_ERROR_STMT','NODE_ID:'|| node_id);
236: APP_EXCEPTION.RAISE_EXCEPTION;
237: END parse_item_type;
230: WHEN OTHERS THEN
231: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
232: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
233: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
234: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.parse_item_type');
235: fnd_message.set_token('AZW_ERROR_STMT','NODE_ID:'|| node_id);
236: APP_EXCEPTION.RAISE_EXCEPTION;
237: END parse_item_type;
238:
231: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
232: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
233: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
234: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.parse_item_type');
235: fnd_message.set_token('AZW_ERROR_STMT','NODE_ID:'|| node_id);
236: APP_EXCEPTION.RAISE_EXCEPTION;
237: END parse_item_type;
238:
239:
261: EXCEPTION
262: WHEN app_exception.application_exception THEN
263: APP_EXCEPTION.RAISE_EXCEPTION;
264: WHEN OTHERS THEN
265: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
266: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
267: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
268: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.parse_process_name');
269: fnd_message.set_token('AZW_ERROR_STMT','NODE_ID:'|| node_id);
262: WHEN app_exception.application_exception THEN
263: APP_EXCEPTION.RAISE_EXCEPTION;
264: WHEN OTHERS THEN
265: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
266: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
267: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
268: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.parse_process_name');
269: fnd_message.set_token('AZW_ERROR_STMT','NODE_ID:'|| node_id);
270: APP_EXCEPTION.RAISE_EXCEPTION;
263: APP_EXCEPTION.RAISE_EXCEPTION;
264: WHEN OTHERS THEN
265: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
266: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
267: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
268: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.parse_process_name');
269: fnd_message.set_token('AZW_ERROR_STMT','NODE_ID:'|| node_id);
270: APP_EXCEPTION.RAISE_EXCEPTION;
271: END parse_process_name;
264: WHEN OTHERS THEN
265: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
266: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
267: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
268: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.parse_process_name');
269: fnd_message.set_token('AZW_ERROR_STMT','NODE_ID:'|| node_id);
270: APP_EXCEPTION.RAISE_EXCEPTION;
271: END parse_process_name;
272:
265: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
266: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
267: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
268: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.parse_process_name');
269: fnd_message.set_token('AZW_ERROR_STMT','NODE_ID:'|| node_id);
270: APP_EXCEPTION.RAISE_EXCEPTION;
271: END parse_process_name;
272:
273: --
293: EXCEPTION
294: WHEN app_exception.application_exception THEN
295: APP_EXCEPTION.RAISE_EXCEPTION;
296: WHEN OTHERS THEN
297: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
298: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
299: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
300: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.parse_process_name_task');
301: fnd_message.set_token('AZW_ERROR_STMT','NODEID:'|| node_id);
294: WHEN app_exception.application_exception THEN
295: APP_EXCEPTION.RAISE_EXCEPTION;
296: WHEN OTHERS THEN
297: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
298: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
299: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
300: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.parse_process_name_task');
301: fnd_message.set_token('AZW_ERROR_STMT','NODEID:'|| node_id);
302: APP_EXCEPTION.RAISE_EXCEPTION;
295: APP_EXCEPTION.RAISE_EXCEPTION;
296: WHEN OTHERS THEN
297: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
298: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
299: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
300: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.parse_process_name_task');
301: fnd_message.set_token('AZW_ERROR_STMT','NODEID:'|| node_id);
302: APP_EXCEPTION.RAISE_EXCEPTION;
303: END parse_process_name_task;
296: WHEN OTHERS THEN
297: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
298: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
299: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
300: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.parse_process_name_task');
301: fnd_message.set_token('AZW_ERROR_STMT','NODEID:'|| node_id);
302: APP_EXCEPTION.RAISE_EXCEPTION;
303: END parse_process_name_task;
304:
297: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
298: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
299: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
300: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.parse_process_name_task');
301: fnd_message.set_token('AZW_ERROR_STMT','NODEID:'|| node_id);
302: APP_EXCEPTION.RAISE_EXCEPTION;
303: END parse_process_name_task;
304:
305: --
325: EXCEPTION
326: WHEN app_exception.application_exception THEN
327: APP_EXCEPTION.RAISE_EXCEPTION;
328: WHEN OTHERS THEN
329: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
330: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
331: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
332: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.parse_context_id');
333: fnd_message.set_token('AZW_ERROR_STMT','NODE_ID:'||node_id);
326: WHEN app_exception.application_exception THEN
327: APP_EXCEPTION.RAISE_EXCEPTION;
328: WHEN OTHERS THEN
329: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
330: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
331: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
332: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.parse_context_id');
333: fnd_message.set_token('AZW_ERROR_STMT','NODE_ID:'||node_id);
334: APP_EXCEPTION.RAISE_EXCEPTION;
327: APP_EXCEPTION.RAISE_EXCEPTION;
328: WHEN OTHERS THEN
329: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
330: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
331: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
332: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.parse_context_id');
333: fnd_message.set_token('AZW_ERROR_STMT','NODE_ID:'||node_id);
334: APP_EXCEPTION.RAISE_EXCEPTION;
335: END parse_context_id;
328: WHEN OTHERS THEN
329: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
330: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
331: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
332: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.parse_context_id');
333: fnd_message.set_token('AZW_ERROR_STMT','NODE_ID:'||node_id);
334: APP_EXCEPTION.RAISE_EXCEPTION;
335: END parse_context_id;
336:
329: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
330: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
331: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
332: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.parse_context_id');
333: fnd_message.set_token('AZW_ERROR_STMT','NODE_ID:'||node_id);
334: APP_EXCEPTION.RAISE_EXCEPTION;
335: END parse_context_id;
336:
337:
359: EXCEPTION
360: WHEN app_exception.application_exception THEN
361: RAISE;
362: WHEN OTHERS THEN
363: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
364: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
365: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
366: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.parse_item_key');
367: fnd_message.set_token('AZW_ERROR_STMT','NODE_ID:'|| node_id);
360: WHEN app_exception.application_exception THEN
361: RAISE;
362: WHEN OTHERS THEN
363: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
364: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
365: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
366: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.parse_item_key');
367: fnd_message.set_token('AZW_ERROR_STMT','NODE_ID:'|| node_id);
368: APP_EXCEPTION.RAISE_EXCEPTION;
361: RAISE;
362: WHEN OTHERS THEN
363: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
364: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
365: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
366: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.parse_item_key');
367: fnd_message.set_token('AZW_ERROR_STMT','NODE_ID:'|| node_id);
368: APP_EXCEPTION.RAISE_EXCEPTION;
369: END parse_item_key;
362: WHEN OTHERS THEN
363: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
364: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
365: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
366: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.parse_item_key');
367: fnd_message.set_token('AZW_ERROR_STMT','NODE_ID:'|| node_id);
368: APP_EXCEPTION.RAISE_EXCEPTION;
369: END parse_item_key;
370:
363: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
364: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
365: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
366: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.parse_item_key');
367: fnd_message.set_token('AZW_ERROR_STMT','NODE_ID:'|| node_id);
368: APP_EXCEPTION.RAISE_EXCEPTION;
369: END parse_item_key;
370:
371:
401: AND process_name = v_process_name
402: AND context_id = v_process_ctxt_id;
403: EXCEPTION
404: WHEN OTHERS THEN
405: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
406: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
407: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
408: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_group_color');
409: fnd_message.set_token('AZW_ERROR_STMT','select parent_id from az_processes');
402: AND context_id = v_process_ctxt_id;
403: EXCEPTION
404: WHEN OTHERS THEN
405: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
406: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
407: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
408: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_group_color');
409: fnd_message.set_token('AZW_ERROR_STMT','select parent_id from az_processes');
410: APP_EXCEPTION.RAISE_EXCEPTION;
403: EXCEPTION
404: WHEN OTHERS THEN
405: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
406: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
407: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
408: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_group_color');
409: fnd_message.set_token('AZW_ERROR_STMT','select parent_id from az_processes');
410: APP_EXCEPTION.RAISE_EXCEPTION;
411: END;
404: WHEN OTHERS THEN
405: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
406: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
407: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
408: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_group_color');
409: fnd_message.set_token('AZW_ERROR_STMT','select parent_id from az_processes');
410: APP_EXCEPTION.RAISE_EXCEPTION;
411: END;
412:
405: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
406: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
407: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
408: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_group_color');
409: fnd_message.set_token('AZW_ERROR_STMT','select parent_id from az_processes');
410: APP_EXCEPTION.RAISE_EXCEPTION;
411: END;
412:
413: p_group_id := v_process_parent_id;
427: RETURN v_group_color;
428:
429: EXCEPTION
430: WHEN OTHERS THEN
431: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
432: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
433: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
434: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_group_color');
435: fnd_message.set_token('AZW_ERROR_STMT','select color_code from az_groups');
428:
429: EXCEPTION
430: WHEN OTHERS THEN
431: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
432: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
433: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
434: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_group_color');
435: fnd_message.set_token('AZW_ERROR_STMT','select color_code from az_groups');
436: APP_EXCEPTION.RAISE_EXCEPTION;
429: EXCEPTION
430: WHEN OTHERS THEN
431: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
432: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
433: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
434: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_group_color');
435: fnd_message.set_token('AZW_ERROR_STMT','select color_code from az_groups');
436: APP_EXCEPTION.RAISE_EXCEPTION;
437: END;
430: WHEN OTHERS THEN
431: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
432: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
433: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
434: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_group_color');
435: fnd_message.set_token('AZW_ERROR_STMT','select color_code from az_groups');
436: APP_EXCEPTION.RAISE_EXCEPTION;
437: END;
438: EXCEPTION
431: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
432: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
433: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
434: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_group_color');
435: fnd_message.set_token('AZW_ERROR_STMT','select color_code from az_groups');
436: APP_EXCEPTION.RAISE_EXCEPTION;
437: END;
438: EXCEPTION
439: WHEN app_exception.application_exception THEN
438: EXCEPTION
439: WHEN app_exception.application_exception THEN
440: APP_EXCEPTION.RAISE_EXCEPTION;
441: WHEN OTHERS THEN
442: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
443: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
444: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
445: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_group_color');
446: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
439: WHEN app_exception.application_exception THEN
440: APP_EXCEPTION.RAISE_EXCEPTION;
441: WHEN OTHERS THEN
442: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
443: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
444: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
445: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_group_color');
446: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
447: APP_EXCEPTION.RAISE_EXCEPTION;
440: APP_EXCEPTION.RAISE_EXCEPTION;
441: WHEN OTHERS THEN
442: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
443: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
444: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
445: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_group_color');
446: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
447: APP_EXCEPTION.RAISE_EXCEPTION;
448: END get_group_color;
441: WHEN OTHERS THEN
442: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
443: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
444: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
445: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_group_color');
446: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
447: APP_EXCEPTION.RAISE_EXCEPTION;
448: END get_group_color;
449:
442: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
443: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
444: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
445: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_group_color');
446: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
447: APP_EXCEPTION.RAISE_EXCEPTION;
448: END get_group_color;
449:
450: --
466: RETURN '???';
467:
468: EXCEPTION
469: WHEN OTHERS THEN
470: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
471: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
472: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
473: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_context_name');
474: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
467:
468: EXCEPTION
469: WHEN OTHERS THEN
470: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
471: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
472: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
473: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_context_name');
474: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
475: APP_EXCEPTION.RAISE_EXCEPTION;
468: EXCEPTION
469: WHEN OTHERS THEN
470: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
471: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
472: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
473: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_context_name');
474: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
475: APP_EXCEPTION.RAISE_EXCEPTION;
476: END get_context_name;
469: WHEN OTHERS THEN
470: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
471: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
472: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
473: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_context_name');
474: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
475: APP_EXCEPTION.RAISE_EXCEPTION;
476: END get_context_name;
477:
470: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
471: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
472: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
473: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_context_name');
474: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
475: APP_EXCEPTION.RAISE_EXCEPTION;
476: END get_context_name;
477:
478: --
509: RETURN v_ctxt_type;
510:
511: EXCEPTION
512: WHEN OTHERS THEN
513: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
514: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
515: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
516: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_context_type');
517: fnd_message.set_token('AZW_ERROR_STMT','select text_default from wf_activity_attributes_vl');
510:
511: EXCEPTION
512: WHEN OTHERS THEN
513: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
514: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
515: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
516: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_context_type');
517: fnd_message.set_token('AZW_ERROR_STMT','select text_default from wf_activity_attributes_vl');
518: APP_EXCEPTION.RAISE_EXCEPTION;
511: EXCEPTION
512: WHEN OTHERS THEN
513: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
514: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
515: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
516: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_context_type');
517: fnd_message.set_token('AZW_ERROR_STMT','select text_default from wf_activity_attributes_vl');
518: APP_EXCEPTION.RAISE_EXCEPTION;
519:
512: WHEN OTHERS THEN
513: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
514: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
515: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
516: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_context_type');
517: fnd_message.set_token('AZW_ERROR_STMT','select text_default from wf_activity_attributes_vl');
518: APP_EXCEPTION.RAISE_EXCEPTION;
519:
520: END get_context_type;
513: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
514: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
515: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
516: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_context_type');
517: fnd_message.set_token('AZW_ERROR_STMT','select text_default from wf_activity_attributes_vl');
518: APP_EXCEPTION.RAISE_EXCEPTION;
519:
520: END get_context_type;
521:
560: IF DBMS_SQL.IS_OPEN(curs) then
561: DBMS_SQL.CLOSE_CURSOR(curs);
562: END IF;
563:
564: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
565: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
566: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
567: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_opm_context_name');
568: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
561: DBMS_SQL.CLOSE_CURSOR(curs);
562: END IF;
563:
564: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
565: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
566: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
567: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_opm_context_name');
568: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
569: APP_EXCEPTION.RAISE_EXCEPTION;
562: END IF;
563:
564: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
565: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
566: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
567: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_opm_context_name');
568: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
569: APP_EXCEPTION.RAISE_EXCEPTION;
570:
563:
564: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
565: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
566: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
567: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_opm_context_name');
568: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
569: APP_EXCEPTION.RAISE_EXCEPTION;
570:
571: END get_opm_context_name;
564: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
565: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
566: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
567: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_opm_context_name');
568: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
569: APP_EXCEPTION.RAISE_EXCEPTION;
570:
571: END get_opm_context_name;
572:
592: OR date_to > SYSDATE)
593: AND organization_id = ctx_id;
594: EXCEPTION
595: WHEN OTHERS THEN
596: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
597: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
598: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
599: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_context_name');
600: fnd_message.set_token('AZW_ERROR_STMT','select name from per_business_groups');
593: AND organization_id = ctx_id;
594: EXCEPTION
595: WHEN OTHERS THEN
596: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
597: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
598: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
599: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_context_name');
600: fnd_message.set_token('AZW_ERROR_STMT','select name from per_business_groups');
601: APP_EXCEPTION.RAISE_EXCEPTION;
594: EXCEPTION
595: WHEN OTHERS THEN
596: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
597: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
598: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
599: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_context_name');
600: fnd_message.set_token('AZW_ERROR_STMT','select name from per_business_groups');
601: APP_EXCEPTION.RAISE_EXCEPTION;
602: END;
595: WHEN OTHERS THEN
596: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
597: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
598: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
599: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_context_name');
600: fnd_message.set_token('AZW_ERROR_STMT','select name from per_business_groups');
601: APP_EXCEPTION.RAISE_EXCEPTION;
602: END;
603:
596: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
597: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
598: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
599: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_context_name');
600: fnd_message.set_token('AZW_ERROR_STMT','select name from per_business_groups');
601: APP_EXCEPTION.RAISE_EXCEPTION;
602: END;
603:
604: ELSIF (ctx_type = 'IO') THEN
610: OR disable_date > SYSDATE)
611: AND organization_id = ctx_id;
612: EXCEPTION
613: WHEN OTHERS THEN
614: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
615: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
616: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
617: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_context_name');
618: fnd_message.set_token('AZW_ERROR_STMT','select name from org_organization_definitions');
611: AND organization_id = ctx_id;
612: EXCEPTION
613: WHEN OTHERS THEN
614: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
615: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
616: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
617: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_context_name');
618: fnd_message.set_token('AZW_ERROR_STMT','select name from org_organization_definitions');
619: APP_EXCEPTION.RAISE_EXCEPTION;
612: EXCEPTION
613: WHEN OTHERS THEN
614: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
615: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
616: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
617: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_context_name');
618: fnd_message.set_token('AZW_ERROR_STMT','select name from org_organization_definitions');
619: APP_EXCEPTION.RAISE_EXCEPTION;
620: END;
613: WHEN OTHERS THEN
614: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
615: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
616: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
617: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_context_name');
618: fnd_message.set_token('AZW_ERROR_STMT','select name from org_organization_definitions');
619: APP_EXCEPTION.RAISE_EXCEPTION;
620: END;
621:
614: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
615: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
616: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
617: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_context_name');
618: fnd_message.set_token('AZW_ERROR_STMT','select name from org_organization_definitions');
619: APP_EXCEPTION.RAISE_EXCEPTION;
620: END;
621:
622: ELSIF (ctx_type = 'OU') THEN
628: AND (date_to IS NULL
629: OR date_to > SYSDATE);
630: EXCEPTION
631: WHEN OTHERS THEN
632: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
633: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
634: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
635: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_context_name');
636: fnd_message.set_token('AZW_ERROR_STMT','select name from hr_operating_units');
629: OR date_to > SYSDATE);
630: EXCEPTION
631: WHEN OTHERS THEN
632: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
633: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
634: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
635: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_context_name');
636: fnd_message.set_token('AZW_ERROR_STMT','select name from hr_operating_units');
637: APP_EXCEPTION.RAISE_EXCEPTION;
630: EXCEPTION
631: WHEN OTHERS THEN
632: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
633: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
634: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
635: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_context_name');
636: fnd_message.set_token('AZW_ERROR_STMT','select name from hr_operating_units');
637: APP_EXCEPTION.RAISE_EXCEPTION;
638: END;
631: WHEN OTHERS THEN
632: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
633: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
634: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
635: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_context_name');
636: fnd_message.set_token('AZW_ERROR_STMT','select name from hr_operating_units');
637: APP_EXCEPTION.RAISE_EXCEPTION;
638: END;
639:
632: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
633: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
634: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
635: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_context_name');
636: fnd_message.set_token('AZW_ERROR_STMT','select name from hr_operating_units');
637: APP_EXCEPTION.RAISE_EXCEPTION;
638: END;
639:
640: ELSIF (ctx_type = 'SOB') THEN
643: FROM gl_sets_of_books
644: WHERE set_of_books_id = ctx_id;
645: EXCEPTION
646: WHEN OTHERS THEN
647: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
648: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
649: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
650: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_context_name');
651: fnd_message.set_token('AZW_ERROR_STMT','select name from gl_sets_of_books');
644: WHERE set_of_books_id = ctx_id;
645: EXCEPTION
646: WHEN OTHERS THEN
647: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
648: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
649: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
650: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_context_name');
651: fnd_message.set_token('AZW_ERROR_STMT','select name from gl_sets_of_books');
652: APP_EXCEPTION.RAISE_EXCEPTION;
645: EXCEPTION
646: WHEN OTHERS THEN
647: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
648: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
649: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
650: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_context_name');
651: fnd_message.set_token('AZW_ERROR_STMT','select name from gl_sets_of_books');
652: APP_EXCEPTION.RAISE_EXCEPTION;
653: END;
646: WHEN OTHERS THEN
647: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
648: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
649: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
650: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_context_name');
651: fnd_message.set_token('AZW_ERROR_STMT','select name from gl_sets_of_books');
652: APP_EXCEPTION.RAISE_EXCEPTION;
653: END;
654:
647: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
648: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
649: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
650: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_context_name');
651: fnd_message.set_token('AZW_ERROR_STMT','select name from gl_sets_of_books');
652: APP_EXCEPTION.RAISE_EXCEPTION;
653: END;
654:
655: ELSIF (ctx_type = 'OPMCOM' OR ctx_type = 'OPMORG') THEN
656: BEGIN
657: v_ctxt_name := get_opm_context_name(ctx_type, ctx_id);
658: EXCEPTION
659: WHEN OTHERS THEN
660: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
661: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
662: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
663: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_context_name');
664: fnd_message.set_token('AZW_ERROR_STMT','select name from sy_orgn_mst');
657: v_ctxt_name := get_opm_context_name(ctx_type, ctx_id);
658: EXCEPTION
659: WHEN OTHERS THEN
660: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
661: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
662: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
663: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_context_name');
664: fnd_message.set_token('AZW_ERROR_STMT','select name from sy_orgn_mst');
665: APP_EXCEPTION.RAISE_EXCEPTION;
658: EXCEPTION
659: WHEN OTHERS THEN
660: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
661: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
662: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
663: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_context_name');
664: fnd_message.set_token('AZW_ERROR_STMT','select name from sy_orgn_mst');
665: APP_EXCEPTION.RAISE_EXCEPTION;
666: END;
659: WHEN OTHERS THEN
660: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
661: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
662: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
663: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_context_name');
664: fnd_message.set_token('AZW_ERROR_STMT','select name from sy_orgn_mst');
665: APP_EXCEPTION.RAISE_EXCEPTION;
666: END;
667:
660: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
661: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
662: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
663: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_context_name');
664: fnd_message.set_token('AZW_ERROR_STMT','select name from sy_orgn_mst');
665: APP_EXCEPTION.RAISE_EXCEPTION;
666: END;
667:
668: END IF;
676: EXCEPTION
677: WHEN app_exception.application_exception THEN
678: RAISE;
679: WHEN OTHERS THEN
680: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
681: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
682: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
683: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_context_name');
684: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
677: WHEN app_exception.application_exception THEN
678: RAISE;
679: WHEN OTHERS THEN
680: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
681: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
682: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
683: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_context_name');
684: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
685: APP_EXCEPTION.RAISE_EXCEPTION;
678: RAISE;
679: WHEN OTHERS THEN
680: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
681: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
682: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
683: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_context_name');
684: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
685: APP_EXCEPTION.RAISE_EXCEPTION;
686: END get_context_name;
679: WHEN OTHERS THEN
680: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
681: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
682: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
683: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_context_name');
684: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
685: APP_EXCEPTION.RAISE_EXCEPTION;
686: END get_context_name;
687:
680: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
681: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
682: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
683: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_context_name');
684: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
685: APP_EXCEPTION.RAISE_EXCEPTION;
686: END get_context_name;
687:
688:
713: WHEN app_exception.application_exception THEN
714: APP_EXCEPTION.RAISE_EXCEPTION;
715: WHEN OTHERS THEN
716: -- DBMS_OUTPUT.PUT_LINE('error: get_application_name: ' || SQLERRM);
717: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
718: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
719: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
720: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_application_name');
721: fnd_message.set_token('AZW_ERROR_STMT','select application_name from fnd_application_vl');
714: APP_EXCEPTION.RAISE_EXCEPTION;
715: WHEN OTHERS THEN
716: -- DBMS_OUTPUT.PUT_LINE('error: get_application_name: ' || SQLERRM);
717: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
718: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
719: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
720: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_application_name');
721: fnd_message.set_token('AZW_ERROR_STMT','select application_name from fnd_application_vl');
722: APP_EXCEPTION.RAISE_EXCEPTION;
715: WHEN OTHERS THEN
716: -- DBMS_OUTPUT.PUT_LINE('error: get_application_name: ' || SQLERRM);
717: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
718: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
719: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
720: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_application_name');
721: fnd_message.set_token('AZW_ERROR_STMT','select application_name from fnd_application_vl');
722: APP_EXCEPTION.RAISE_EXCEPTION;
723: END get_application_name;
716: -- DBMS_OUTPUT.PUT_LINE('error: get_application_name: ' || SQLERRM);
717: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
718: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
719: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
720: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_application_name');
721: fnd_message.set_token('AZW_ERROR_STMT','select application_name from fnd_application_vl');
722: APP_EXCEPTION.RAISE_EXCEPTION;
723: END get_application_name;
724:
717: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
718: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
719: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
720: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_application_name');
721: fnd_message.set_token('AZW_ERROR_STMT','select application_name from fnd_application_vl');
722: APP_EXCEPTION.RAISE_EXCEPTION;
723: END get_application_name;
724:
725:
751: v_meaning := 'NONE';
752: RETURN v_meaning;
753: WHEN OTHERS THEN
754: -- DBMS_OUTPUT.PUT_LINE('error: get_lookup_meaning: ' || SQLERRM);
755: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
756: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
757: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
758: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_lookup_meaning');
759: fnd_message.set_token('AZW_ERROR_STMT','select meaning from fnd_lookups');
752: RETURN v_meaning;
753: WHEN OTHERS THEN
754: -- DBMS_OUTPUT.PUT_LINE('error: get_lookup_meaning: ' || SQLERRM);
755: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
756: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
757: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
758: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_lookup_meaning');
759: fnd_message.set_token('AZW_ERROR_STMT','select meaning from fnd_lookups');
760: APP_EXCEPTION.RAISE_EXCEPTION;
753: WHEN OTHERS THEN
754: -- DBMS_OUTPUT.PUT_LINE('error: get_lookup_meaning: ' || SQLERRM);
755: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
756: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
757: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
758: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_lookup_meaning');
759: fnd_message.set_token('AZW_ERROR_STMT','select meaning from fnd_lookups');
760: APP_EXCEPTION.RAISE_EXCEPTION;
761: END get_lookup_meaning;
754: -- DBMS_OUTPUT.PUT_LINE('error: get_lookup_meaning: ' || SQLERRM);
755: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
756: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
757: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
758: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_lookup_meaning');
759: fnd_message.set_token('AZW_ERROR_STMT','select meaning from fnd_lookups');
760: APP_EXCEPTION.RAISE_EXCEPTION;
761: END get_lookup_meaning;
762:
755: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
756: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
757: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
758: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_lookup_meaning');
759: fnd_message.set_token('AZW_ERROR_STMT','select meaning from fnd_lookups');
760: APP_EXCEPTION.RAISE_EXCEPTION;
761: END get_lookup_meaning;
762:
763:
781: EXCEPTION
782: WHEN app_exception.application_exception THEN
783: RAISE;
784: WHEN OTHERS THEN
785: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
786: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
787: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
788: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_hierarchy')
789: ;
782: WHEN app_exception.application_exception THEN
783: RAISE;
784: WHEN OTHERS THEN
785: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
786: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
787: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
788: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_hierarchy')
789: ;
790: fnd_message.set_token('AZW_ERROR_STMT','select language_code ..
783: RAISE;
784: WHEN OTHERS THEN
785: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
786: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
787: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
788: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_hierarchy')
789: ;
790: fnd_message.set_token('AZW_ERROR_STMT','select language_code ..
791: from fnd_languages');
784: WHEN OTHERS THEN
785: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
786: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
787: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
788: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_hierarchy')
789: ;
790: fnd_message.set_token('AZW_ERROR_STMT','select language_code ..
791: from fnd_languages');
792: APP_EXCEPTION.RAISE_EXCEPTION;
786: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
787: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
788: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_hierarchy')
789: ;
790: fnd_message.set_token('AZW_ERROR_STMT','select language_code ..
791: from fnd_languages');
792: APP_EXCEPTION.RAISE_EXCEPTION;
793: END;
794: END IF;
800: AND type = 'WFTKN'
801: AND name = 'DAYS';
802: EXCEPTION
803: WHEN OTHERS THEN
804: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
805: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
806: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
807: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.task_init');
808: fnd_message.set_token('AZW_ERROR_STMT','select into v_days');
801: AND name = 'DAYS';
802: EXCEPTION
803: WHEN OTHERS THEN
804: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
805: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
806: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
807: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.task_init');
808: fnd_message.set_token('AZW_ERROR_STMT','select into v_days');
809: APP_EXCEPTION.RAISE_EXCEPTION;
802: EXCEPTION
803: WHEN OTHERS THEN
804: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
805: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
806: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
807: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.task_init');
808: fnd_message.set_token('AZW_ERROR_STMT','select into v_days');
809: APP_EXCEPTION.RAISE_EXCEPTION;
810: END;
803: WHEN OTHERS THEN
804: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
805: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
806: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
807: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.task_init');
808: fnd_message.set_token('AZW_ERROR_STMT','select into v_days');
809: APP_EXCEPTION.RAISE_EXCEPTION;
810: END;
811:
804: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
805: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
806: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
807: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.task_init');
808: fnd_message.set_token('AZW_ERROR_STMT','select into v_days');
809: APP_EXCEPTION.RAISE_EXCEPTION;
810: END;
811:
812: BEGIN
817: AND type = 'WFTKN'
818: AND name = 'WFMON_DONE';
819: EXCEPTION
820: WHEN OTHERS THEN
821: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
822: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
823: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
824: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.task_init');
825: fnd_message.set_token('AZW_ERROR_STMT','select into v_done');
818: AND name = 'WFMON_DONE';
819: EXCEPTION
820: WHEN OTHERS THEN
821: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
822: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
823: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
824: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.task_init');
825: fnd_message.set_token('AZW_ERROR_STMT','select into v_done');
826: APP_EXCEPTION.RAISE_EXCEPTION;
819: EXCEPTION
820: WHEN OTHERS THEN
821: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
822: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
823: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
824: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.task_init');
825: fnd_message.set_token('AZW_ERROR_STMT','select into v_done');
826: APP_EXCEPTION.RAISE_EXCEPTION;
827: END;
820: WHEN OTHERS THEN
821: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
822: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
823: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
824: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.task_init');
825: fnd_message.set_token('AZW_ERROR_STMT','select into v_done');
826: APP_EXCEPTION.RAISE_EXCEPTION;
827: END;
828:
821: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
822: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
823: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
824: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.task_init');
825: fnd_message.set_token('AZW_ERROR_STMT','select into v_done');
826: APP_EXCEPTION.RAISE_EXCEPTION;
827: END;
828:
829: BEGIN
834: AND type = 'WFTKN'
835: AND name = 'WFMON_SKIP';
836: EXCEPTION
837: WHEN OTHERS THEN
838: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
839: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
840: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
841: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.task_init');
842: fnd_message.set_token('AZW_ERROR_STMT','select into v_skip');
835: AND name = 'WFMON_SKIP';
836: EXCEPTION
837: WHEN OTHERS THEN
838: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
839: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
840: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
841: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.task_init');
842: fnd_message.set_token('AZW_ERROR_STMT','select into v_skip');
843: APP_EXCEPTION.RAISE_EXCEPTION;
836: EXCEPTION
837: WHEN OTHERS THEN
838: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
839: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
840: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
841: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.task_init');
842: fnd_message.set_token('AZW_ERROR_STMT','select into v_skip');
843: APP_EXCEPTION.RAISE_EXCEPTION;
844: END;
837: WHEN OTHERS THEN
838: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
839: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
840: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
841: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.task_init');
842: fnd_message.set_token('AZW_ERROR_STMT','select into v_skip');
843: APP_EXCEPTION.RAISE_EXCEPTION;
844: END;
845:
838: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
839: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
840: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
841: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.task_init');
842: fnd_message.set_token('AZW_ERROR_STMT','select into v_skip');
843: APP_EXCEPTION.RAISE_EXCEPTION;
844: END;
845:
846: END task_init;
905: END LOOP;
906: CLOSE bg_cursor;
907: EXCEPTION
908: WHEN OTHERS THEN
909: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
910: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
911: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
912: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_context');
913: fnd_message.set_token('AZW_ERROR_STMT','CURSOR bg_cursor');
906: CLOSE bg_cursor;
907: EXCEPTION
908: WHEN OTHERS THEN
909: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
910: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
911: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
912: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_context');
913: fnd_message.set_token('AZW_ERROR_STMT','CURSOR bg_cursor');
914: APP_EXCEPTION.RAISE_EXCEPTION;
907: EXCEPTION
908: WHEN OTHERS THEN
909: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
910: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
911: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
912: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_context');
913: fnd_message.set_token('AZW_ERROR_STMT','CURSOR bg_cursor');
914: APP_EXCEPTION.RAISE_EXCEPTION;
915: END;
908: WHEN OTHERS THEN
909: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
910: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
911: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
912: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_context');
913: fnd_message.set_token('AZW_ERROR_STMT','CURSOR bg_cursor');
914: APP_EXCEPTION.RAISE_EXCEPTION;
915: END;
916:
909: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
910: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
911: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
912: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_context');
913: fnd_message.set_token('AZW_ERROR_STMT','CURSOR bg_cursor');
914: APP_EXCEPTION.RAISE_EXCEPTION;
915: END;
916:
917: ELSIF (ctx_type = 'IO') THEN
925: END LOOP;
926: CLOSE io_cursor;
927: EXCEPTION
928: WHEN OTHERS THEN
929: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
930: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
931: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
932: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_context');
933: fnd_message.set_token('AZW_ERROR_STMT','CURSOR io_cursor');
926: CLOSE io_cursor;
927: EXCEPTION
928: WHEN OTHERS THEN
929: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
930: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
931: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
932: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_context');
933: fnd_message.set_token('AZW_ERROR_STMT','CURSOR io_cursor');
934: APP_EXCEPTION.RAISE_EXCEPTION;
927: EXCEPTION
928: WHEN OTHERS THEN
929: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
930: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
931: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
932: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_context');
933: fnd_message.set_token('AZW_ERROR_STMT','CURSOR io_cursor');
934: APP_EXCEPTION.RAISE_EXCEPTION;
935: END;
928: WHEN OTHERS THEN
929: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
930: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
931: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
932: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_context');
933: fnd_message.set_token('AZW_ERROR_STMT','CURSOR io_cursor');
934: APP_EXCEPTION.RAISE_EXCEPTION;
935: END;
936:
929: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
930: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
931: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
932: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_context');
933: fnd_message.set_token('AZW_ERROR_STMT','CURSOR io_cursor');
934: APP_EXCEPTION.RAISE_EXCEPTION;
935: END;
936:
937: ELSIF (ctx_type = 'OU') THEN
945: END LOOP;
946: CLOSE ou_cursor;
947: EXCEPTION
948: WHEN OTHERS THEN
949: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
950: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
951: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
952: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_context');
953: fnd_message.set_token('AZW_ERROR_STMT','CURSOR ou_cursor');
946: CLOSE ou_cursor;
947: EXCEPTION
948: WHEN OTHERS THEN
949: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
950: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
951: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
952: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_context');
953: fnd_message.set_token('AZW_ERROR_STMT','CURSOR ou_cursor');
954: APP_EXCEPTION.RAISE_EXCEPTION;
947: EXCEPTION
948: WHEN OTHERS THEN
949: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
950: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
951: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
952: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_context');
953: fnd_message.set_token('AZW_ERROR_STMT','CURSOR ou_cursor');
954: APP_EXCEPTION.RAISE_EXCEPTION;
955: END;
948: WHEN OTHERS THEN
949: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
950: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
951: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
952: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_context');
953: fnd_message.set_token('AZW_ERROR_STMT','CURSOR ou_cursor');
954: APP_EXCEPTION.RAISE_EXCEPTION;
955: END;
956:
949: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
950: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
951: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
952: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_context');
953: fnd_message.set_token('AZW_ERROR_STMT','CURSOR ou_cursor');
954: APP_EXCEPTION.RAISE_EXCEPTION;
955: END;
956:
957: ELSIF (ctx_type = 'SOB') THEN
965: END LOOP;
966: CLOSE sob_cursor;
967: EXCEPTION
968: WHEN OTHERS THEN
969: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
970: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
971: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
972: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_context');
973: fnd_message.set_token('AZW_ERROR_STMT','CURSOR sob_cursor');
966: CLOSE sob_cursor;
967: EXCEPTION
968: WHEN OTHERS THEN
969: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
970: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
971: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
972: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_context');
973: fnd_message.set_token('AZW_ERROR_STMT','CURSOR sob_cursor');
974: APP_EXCEPTION.RAISE_EXCEPTION;
967: EXCEPTION
968: WHEN OTHERS THEN
969: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
970: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
971: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
972: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_context');
973: fnd_message.set_token('AZW_ERROR_STMT','CURSOR sob_cursor');
974: APP_EXCEPTION.RAISE_EXCEPTION;
975: END;
968: WHEN OTHERS THEN
969: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
970: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
971: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
972: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_context');
973: fnd_message.set_token('AZW_ERROR_STMT','CURSOR sob_cursor');
974: APP_EXCEPTION.RAISE_EXCEPTION;
975: END;
976:
969: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
970: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
971: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
972: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_context');
973: fnd_message.set_token('AZW_ERROR_STMT','CURSOR sob_cursor');
974: APP_EXCEPTION.RAISE_EXCEPTION;
975: END;
976:
977: ELSIF (ctx_type = 'OPMCOM' OR ctx_type = 'OPMORG') THEN
1018: if DBMS_SQL.IS_OPEN(curs) then
1019: DBMS_SQL.CLOSE_CURSOR(curs);
1020: end if;
1021:
1022: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1023: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1024: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1025: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_context');
1026: fnd_message.set_token('AZW_ERROR_STMT','CURSOR opm_cursor');
1019: DBMS_SQL.CLOSE_CURSOR(curs);
1020: end if;
1021:
1022: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1023: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1024: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1025: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_context');
1026: fnd_message.set_token('AZW_ERROR_STMT','CURSOR opm_cursor');
1027: APP_EXCEPTION.RAISE_EXCEPTION;
1020: end if;
1021:
1022: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1023: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1024: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1025: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_context');
1026: fnd_message.set_token('AZW_ERROR_STMT','CURSOR opm_cursor');
1027: APP_EXCEPTION.RAISE_EXCEPTION;
1028: END;
1021:
1022: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1023: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1024: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1025: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_context');
1026: fnd_message.set_token('AZW_ERROR_STMT','CURSOR opm_cursor');
1027: APP_EXCEPTION.RAISE_EXCEPTION;
1028: END;
1029:
1022: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1023: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1024: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1025: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_context');
1026: fnd_message.set_token('AZW_ERROR_STMT','CURSOR opm_cursor');
1027: APP_EXCEPTION.RAISE_EXCEPTION;
1028: END;
1029:
1030: END IF;
1033: WHEN app_exception.application_exception THEN
1034: RAISE;
1035: WHEN OTHERS THEN
1036: -- DBMS_OUTPUT.PUT_LINE('error: get_context: ' || SQLERRM);
1037: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1038: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1039: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1040: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_context');
1041: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
1034: RAISE;
1035: WHEN OTHERS THEN
1036: -- DBMS_OUTPUT.PUT_LINE('error: get_context: ' || SQLERRM);
1037: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1038: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1039: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1040: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_context');
1041: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
1042: APP_EXCEPTION.RAISE_EXCEPTION;
1035: WHEN OTHERS THEN
1036: -- DBMS_OUTPUT.PUT_LINE('error: get_context: ' || SQLERRM);
1037: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1038: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1039: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1040: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_context');
1041: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
1042: APP_EXCEPTION.RAISE_EXCEPTION;
1043:
1036: -- DBMS_OUTPUT.PUT_LINE('error: get_context: ' || SQLERRM);
1037: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1038: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1039: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1040: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_context');
1041: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
1042: APP_EXCEPTION.RAISE_EXCEPTION;
1043:
1044: END get_context;
1037: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1038: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1039: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1040: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_context');
1041: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
1042: APP_EXCEPTION.RAISE_EXCEPTION;
1043:
1044: END get_context;
1045:
1075:
1076: EXCEPTION
1077: WHEN OTHERS THEN
1078: CLOSE valid_processes_c;
1079: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1080: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1081: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1082: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_processes');
1083: fnd_message.set_token('AZW_ERROR_STMT','CURSOR valid_processes_c');
1076: EXCEPTION
1077: WHEN OTHERS THEN
1078: CLOSE valid_processes_c;
1079: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1080: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1081: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1082: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_processes');
1083: fnd_message.set_token('AZW_ERROR_STMT','CURSOR valid_processes_c');
1084: APP_EXCEPTION.RAISE_EXCEPTION;
1077: WHEN OTHERS THEN
1078: CLOSE valid_processes_c;
1079: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1080: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1081: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1082: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_processes');
1083: fnd_message.set_token('AZW_ERROR_STMT','CURSOR valid_processes_c');
1084: APP_EXCEPTION.RAISE_EXCEPTION;
1085: END get_processes;
1078: CLOSE valid_processes_c;
1079: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1080: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1081: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1082: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_processes');
1083: fnd_message.set_token('AZW_ERROR_STMT','CURSOR valid_processes_c');
1084: APP_EXCEPTION.RAISE_EXCEPTION;
1085: END get_processes;
1086:
1079: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1080: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1081: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1082: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_processes');
1083: fnd_message.set_token('AZW_ERROR_STMT','CURSOR valid_processes_c');
1084: APP_EXCEPTION.RAISE_EXCEPTION;
1085: END get_processes;
1086:
1087:
1116: group_status_tbl( group_status_index ).process_name := proc.process_name;
1117: group_status_tbl( group_status_index ).context_id := ctxts(j).context_id;
1118: EXCEPTION
1119: WHEN OTHERS THEN
1120: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1121: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1122: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1123: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.insert_az_processes(param1, param2)');
1124: fnd_message.set_token('AZW_ERROR_STMT','insert into az_processes');
1117: group_status_tbl( group_status_index ).context_id := ctxts(j).context_id;
1118: EXCEPTION
1119: WHEN OTHERS THEN
1120: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1121: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1122: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1123: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.insert_az_processes(param1, param2)');
1124: fnd_message.set_token('AZW_ERROR_STMT','insert into az_processes');
1125: APP_EXCEPTION.RAISE_EXCEPTION;
1118: EXCEPTION
1119: WHEN OTHERS THEN
1120: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1121: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1122: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1123: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.insert_az_processes(param1, param2)');
1124: fnd_message.set_token('AZW_ERROR_STMT','insert into az_processes');
1125: APP_EXCEPTION.RAISE_EXCEPTION;
1126: END;
1119: WHEN OTHERS THEN
1120: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1121: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1122: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1123: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.insert_az_processes(param1, param2)');
1124: fnd_message.set_token('AZW_ERROR_STMT','insert into az_processes');
1125: APP_EXCEPTION.RAISE_EXCEPTION;
1126: END;
1127:
1120: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1121: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1122: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1123: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.insert_az_processes(param1, param2)');
1124: fnd_message.set_token('AZW_ERROR_STMT','insert into az_processes');
1125: APP_EXCEPTION.RAISE_EXCEPTION;
1126: END;
1127:
1128: ELSE
1134: AND context_id = ctxts(j).context_id
1135: AND context_name <> ctxts(j).context_name;
1136: EXCEPTION
1137: WHEN OTHERS THEN
1138: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1139: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1140: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1141: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.insert_az_processes(param1, param2)');
1142: fnd_message.set_token('AZW_ERROR_STMT','update az_processes');
1135: AND context_name <> ctxts(j).context_name;
1136: EXCEPTION
1137: WHEN OTHERS THEN
1138: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1139: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1140: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1141: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.insert_az_processes(param1, param2)');
1142: fnd_message.set_token('AZW_ERROR_STMT','update az_processes');
1143: APP_EXCEPTION.RAISE_EXCEPTION;
1136: EXCEPTION
1137: WHEN OTHERS THEN
1138: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1139: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1140: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1141: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.insert_az_processes(param1, param2)');
1142: fnd_message.set_token('AZW_ERROR_STMT','update az_processes');
1143: APP_EXCEPTION.RAISE_EXCEPTION;
1144: END;
1137: WHEN OTHERS THEN
1138: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1139: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1140: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1141: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.insert_az_processes(param1, param2)');
1142: fnd_message.set_token('AZW_ERROR_STMT','update az_processes');
1143: APP_EXCEPTION.RAISE_EXCEPTION;
1144: END;
1145: END IF;
1138: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1139: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1140: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1141: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.insert_az_processes(param1, param2)');
1142: fnd_message.set_token('AZW_ERROR_STMT','update az_processes');
1143: APP_EXCEPTION.RAISE_EXCEPTION;
1144: END;
1145: END IF;
1146: END LOOP;
1149: WHEN app_exception.application_exception THEN
1150: RAISE;
1151: WHEN OTHERS THEN
1152: -- DBMS_OUTPUT.PUT_LINE('error: insert_az_processes(context): ' || SQLERRM);
1153: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1154: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1155: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1156: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.insert_az_processes(param1, param2)');
1157: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
1150: RAISE;
1151: WHEN OTHERS THEN
1152: -- DBMS_OUTPUT.PUT_LINE('error: insert_az_processes(context): ' || SQLERRM);
1153: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1154: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1155: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1156: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.insert_az_processes(param1, param2)');
1157: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
1158: APP_EXCEPTION.RAISE_EXCEPTION;
1151: WHEN OTHERS THEN
1152: -- DBMS_OUTPUT.PUT_LINE('error: insert_az_processes(context): ' || SQLERRM);
1153: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1154: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1155: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1156: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.insert_az_processes(param1, param2)');
1157: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
1158: APP_EXCEPTION.RAISE_EXCEPTION;
1159:
1152: -- DBMS_OUTPUT.PUT_LINE('error: insert_az_processes(context): ' || SQLERRM);
1153: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1154: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1155: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1156: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.insert_az_processes(param1, param2)');
1157: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
1158: APP_EXCEPTION.RAISE_EXCEPTION;
1159:
1160: END insert_az_processes;
1153: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1154: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1155: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1156: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.insert_az_processes(param1, param2)');
1157: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
1158: APP_EXCEPTION.RAISE_EXCEPTION;
1159:
1160: END insert_az_processes;
1161:
1183: 'NONE', NULL, NULL, proc.parent_id,
1184: 'N', proc.process_type);
1185: EXCEPTION
1186: WHEN OTHERS THEN
1187: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1188: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1189: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1190: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.insert_az_processes(param1)');
1191: fnd_message.set_token('AZW_ERROR_STMT','insert into az_processes');
1184: 'N', proc.process_type);
1185: EXCEPTION
1186: WHEN OTHERS THEN
1187: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1188: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1189: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1190: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.insert_az_processes(param1)');
1191: fnd_message.set_token('AZW_ERROR_STMT','insert into az_processes');
1192: APP_EXCEPTION.RAISE_EXCEPTION;
1185: EXCEPTION
1186: WHEN OTHERS THEN
1187: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1188: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1189: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1190: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.insert_az_processes(param1)');
1191: fnd_message.set_token('AZW_ERROR_STMT','insert into az_processes');
1192: APP_EXCEPTION.RAISE_EXCEPTION;
1193: END;
1186: WHEN OTHERS THEN
1187: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1188: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1189: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1190: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.insert_az_processes(param1)');
1191: fnd_message.set_token('AZW_ERROR_STMT','insert into az_processes');
1192: APP_EXCEPTION.RAISE_EXCEPTION;
1193: END;
1194:
1187: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1188: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1189: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1190: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.insert_az_processes(param1)');
1191: fnd_message.set_token('AZW_ERROR_STMT','insert into az_processes');
1192: APP_EXCEPTION.RAISE_EXCEPTION;
1193: END;
1194:
1195: group_status_index := group_status_index + 1;
1203: WHEN app_exception.application_exception THEN
1204: RAISE;
1205: WHEN OTHERS THEN
1206: -- DBMS_OUTPUT.PUT_LINE('error: insert_az_processes: ' || SQLERRM);
1207: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1208: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1209: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1210: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.insert_az_processes(param1)');
1211: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
1204: RAISE;
1205: WHEN OTHERS THEN
1206: -- DBMS_OUTPUT.PUT_LINE('error: insert_az_processes: ' || SQLERRM);
1207: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1208: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1209: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1210: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.insert_az_processes(param1)');
1211: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
1212: APP_EXCEPTION.RAISE_EXCEPTION;
1205: WHEN OTHERS THEN
1206: -- DBMS_OUTPUT.PUT_LINE('error: insert_az_processes: ' || SQLERRM);
1207: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1208: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1209: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1210: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.insert_az_processes(param1)');
1211: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
1212: APP_EXCEPTION.RAISE_EXCEPTION;
1213:
1206: -- DBMS_OUTPUT.PUT_LINE('error: insert_az_processes: ' || SQLERRM);
1207: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1208: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1209: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1210: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.insert_az_processes(param1)');
1211: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
1212: APP_EXCEPTION.RAISE_EXCEPTION;
1213:
1214: END insert_az_processes;
1207: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1208: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1209: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1210: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.insert_az_processes(param1)');
1211: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
1212: APP_EXCEPTION.RAISE_EXCEPTION;
1213:
1214: END insert_az_processes;
1215:
1251:
1252: EXCEPTION
1253: WHEN OTHERS THEN
1254: --DBMS_OUTPUT.PUT_LINE('error: populate_processes: ' || SQLERRM);
1255: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1256: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1257: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1258: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.populate_processes');
1259: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
1252: EXCEPTION
1253: WHEN OTHERS THEN
1254: --DBMS_OUTPUT.PUT_LINE('error: populate_processes: ' || SQLERRM);
1255: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1256: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1257: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1258: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.populate_processes');
1259: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
1260: APP_EXCEPTION.RAISE_EXCEPTION;
1253: WHEN OTHERS THEN
1254: --DBMS_OUTPUT.PUT_LINE('error: populate_processes: ' || SQLERRM);
1255: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1256: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1257: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1258: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.populate_processes');
1259: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
1260: APP_EXCEPTION.RAISE_EXCEPTION;
1261: END populate_processes;
1254: --DBMS_OUTPUT.PUT_LINE('error: populate_processes: ' || SQLERRM);
1255: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1256: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1257: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1258: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.populate_processes');
1259: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
1260: APP_EXCEPTION.RAISE_EXCEPTION;
1261: END populate_processes;
1262:
1255: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1256: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1257: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1258: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.populate_processes');
1259: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
1260: APP_EXCEPTION.RAISE_EXCEPTION;
1261: END populate_processes;
1262:
1263: --
1294: IF DBMS_SQL.IS_OPEN(curs) then
1295: DBMS_SQL.CLOSE_CURSOR(curs);
1296: END IF;
1297:
1298: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1299: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1300: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1301: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.disable_invalid_opm_processes');
1302: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
1295: DBMS_SQL.CLOSE_CURSOR(curs);
1296: END IF;
1297:
1298: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1299: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1300: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1301: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.disable_invalid_opm_processes');
1302: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
1303: APP_EXCEPTION.RAISE_EXCEPTION;
1296: END IF;
1297:
1298: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1299: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1300: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1301: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.disable_invalid_opm_processes');
1302: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
1303: APP_EXCEPTION.RAISE_EXCEPTION;
1304:
1297:
1298: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1299: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1300: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1301: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.disable_invalid_opm_processes');
1302: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
1303: APP_EXCEPTION.RAISE_EXCEPTION;
1304:
1305: END disable_invalid_opm_processes;
1298: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1299: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1300: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1301: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.disable_invalid_opm_processes');
1302: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
1303: APP_EXCEPTION.RAISE_EXCEPTION;
1304:
1305: END disable_invalid_opm_processes;
1306:
1388: INTO cnt
1389: FROM az_processes;
1390: EXCEPTION
1391: WHEN OTHERS THEN
1392: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1393: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1394: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1395: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.disable_invalid_processes');
1396: fnd_message.set_token('AZW_ERROR_STMT','select count(*) from az_processes');
1389: FROM az_processes;
1390: EXCEPTION
1391: WHEN OTHERS THEN
1392: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1393: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1394: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1395: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.disable_invalid_processes');
1396: fnd_message.set_token('AZW_ERROR_STMT','select count(*) from az_processes');
1397: APP_EXCEPTION.RAISE_EXCEPTION;
1390: EXCEPTION
1391: WHEN OTHERS THEN
1392: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1393: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1394: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1395: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.disable_invalid_processes');
1396: fnd_message.set_token('AZW_ERROR_STMT','select count(*) from az_processes');
1397: APP_EXCEPTION.RAISE_EXCEPTION;
1398: END ;
1391: WHEN OTHERS THEN
1392: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1393: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1394: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1395: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.disable_invalid_processes');
1396: fnd_message.set_token('AZW_ERROR_STMT','select count(*) from az_processes');
1397: APP_EXCEPTION.RAISE_EXCEPTION;
1398: END ;
1399:
1392: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1393: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1394: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1395: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.disable_invalid_processes');
1396: fnd_message.set_token('AZW_ERROR_STMT','select count(*) from az_processes');
1397: APP_EXCEPTION.RAISE_EXCEPTION;
1398: END ;
1399:
1400: IF (cnt <> 0) THEN
1414: COMMIT;
1415: EXCEPTION
1416: WHEN OTHERS THEN
1417: ROLLBACK;
1418: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1419: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1420: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1421: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.disable_invalid_processes');
1422: fnd_message.set_token('AZW_ERROR_STMT','CURSOR invalid_bg_processes_cursor');
1415: EXCEPTION
1416: WHEN OTHERS THEN
1417: ROLLBACK;
1418: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1419: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1420: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1421: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.disable_invalid_processes');
1422: fnd_message.set_token('AZW_ERROR_STMT','CURSOR invalid_bg_processes_cursor');
1423: APP_EXCEPTION.RAISE_EXCEPTION;
1416: WHEN OTHERS THEN
1417: ROLLBACK;
1418: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1419: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1420: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1421: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.disable_invalid_processes');
1422: fnd_message.set_token('AZW_ERROR_STMT','CURSOR invalid_bg_processes_cursor');
1423: APP_EXCEPTION.RAISE_EXCEPTION;
1424: END ;
1417: ROLLBACK;
1418: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1419: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1420: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1421: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.disable_invalid_processes');
1422: fnd_message.set_token('AZW_ERROR_STMT','CURSOR invalid_bg_processes_cursor');
1423: APP_EXCEPTION.RAISE_EXCEPTION;
1424: END ;
1425:
1418: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1419: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1420: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1421: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.disable_invalid_processes');
1422: fnd_message.set_token('AZW_ERROR_STMT','CURSOR invalid_bg_processes_cursor');
1423: APP_EXCEPTION.RAISE_EXCEPTION;
1424: END ;
1425:
1426: BEGIN
1439: COMMIT;
1440: EXCEPTION
1441: WHEN OTHERS THEN
1442: ROLLBACK;
1443: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1444: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1445: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1446: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.disable_invalid_processes');
1447: fnd_message.set_token('AZW_ERROR_STMT','CURSOR invalid_io_processes_cursor');
1440: EXCEPTION
1441: WHEN OTHERS THEN
1442: ROLLBACK;
1443: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1444: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1445: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1446: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.disable_invalid_processes');
1447: fnd_message.set_token('AZW_ERROR_STMT','CURSOR invalid_io_processes_cursor');
1448: APP_EXCEPTION.RAISE_EXCEPTION;
1441: WHEN OTHERS THEN
1442: ROLLBACK;
1443: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1444: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1445: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1446: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.disable_invalid_processes');
1447: fnd_message.set_token('AZW_ERROR_STMT','CURSOR invalid_io_processes_cursor');
1448: APP_EXCEPTION.RAISE_EXCEPTION;
1449: END ;
1442: ROLLBACK;
1443: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1444: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1445: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1446: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.disable_invalid_processes');
1447: fnd_message.set_token('AZW_ERROR_STMT','CURSOR invalid_io_processes_cursor');
1448: APP_EXCEPTION.RAISE_EXCEPTION;
1449: END ;
1450:
1443: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1444: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1445: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1446: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.disable_invalid_processes');
1447: fnd_message.set_token('AZW_ERROR_STMT','CURSOR invalid_io_processes_cursor');
1448: APP_EXCEPTION.RAISE_EXCEPTION;
1449: END ;
1450:
1451: BEGIN
1464: COMMIT;
1465: EXCEPTION
1466: WHEN OTHERS THEN
1467: ROLLBACK;
1468: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1469: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1470: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1471: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.disable_invalid_processes');
1472: fnd_message.set_token('AZW_ERROR_STMT','CURSOR invalid_ou_processes_cursor');
1465: EXCEPTION
1466: WHEN OTHERS THEN
1467: ROLLBACK;
1468: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1469: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1470: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1471: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.disable_invalid_processes');
1472: fnd_message.set_token('AZW_ERROR_STMT','CURSOR invalid_ou_processes_cursor');
1473: APP_EXCEPTION.RAISE_EXCEPTION;
1466: WHEN OTHERS THEN
1467: ROLLBACK;
1468: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1469: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1470: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1471: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.disable_invalid_processes');
1472: fnd_message.set_token('AZW_ERROR_STMT','CURSOR invalid_ou_processes_cursor');
1473: APP_EXCEPTION.RAISE_EXCEPTION;
1474: END ;
1467: ROLLBACK;
1468: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1469: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1470: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1471: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.disable_invalid_processes');
1472: fnd_message.set_token('AZW_ERROR_STMT','CURSOR invalid_ou_processes_cursor');
1473: APP_EXCEPTION.RAISE_EXCEPTION;
1474: END ;
1475:
1468: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1469: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1470: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1471: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.disable_invalid_processes');
1472: fnd_message.set_token('AZW_ERROR_STMT','CURSOR invalid_ou_processes_cursor');
1473: APP_EXCEPTION.RAISE_EXCEPTION;
1474: END ;
1475:
1476: END IF;
1479: WHEN app_exception.application_exception THEN
1480: RAISE;
1481: WHEN OTHERS THEN
1482: -- DBMS_OUTPUT.PUT_LINE('error: disable_invalid_processes: ' || SQLERRM);
1483: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1484: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1485: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1486: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.disable_invalid_processes');
1487: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
1480: RAISE;
1481: WHEN OTHERS THEN
1482: -- DBMS_OUTPUT.PUT_LINE('error: disable_invalid_processes: ' || SQLERRM);
1483: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1484: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1485: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1486: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.disable_invalid_processes');
1487: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
1488: APP_EXCEPTION.RAISE_EXCEPTION;
1481: WHEN OTHERS THEN
1482: -- DBMS_OUTPUT.PUT_LINE('error: disable_invalid_processes: ' || SQLERRM);
1483: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1484: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1485: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1486: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.disable_invalid_processes');
1487: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
1488: APP_EXCEPTION.RAISE_EXCEPTION;
1489:
1482: -- DBMS_OUTPUT.PUT_LINE('error: disable_invalid_processes: ' || SQLERRM);
1483: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1484: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1485: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1486: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.disable_invalid_processes');
1487: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
1488: APP_EXCEPTION.RAISE_EXCEPTION;
1489:
1490:
1483: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1484: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1485: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1486: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.disable_invalid_processes');
1487: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
1488: APP_EXCEPTION.RAISE_EXCEPTION;
1489:
1490:
1491:
1523: where NLS_LANGUAGE =
1524: SUBSTR(USERENV('LANGUAGE'), 1, INSTR(USERENV('LANGUAGE'), '_')-1);
1525: EXCEPTION
1526: WHEN OTHERS THEN
1527: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1528: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1529: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1530: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.populate_az_processes');
1531: fnd_message.set_token('AZW_ERROR_STMT','select language_code .. from fnd_languages');
1524: SUBSTR(USERENV('LANGUAGE'), 1, INSTR(USERENV('LANGUAGE'), '_')-1);
1525: EXCEPTION
1526: WHEN OTHERS THEN
1527: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1528: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1529: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1530: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.populate_az_processes');
1531: fnd_message.set_token('AZW_ERROR_STMT','select language_code .. from fnd_languages');
1532: APP_EXCEPTION.RAISE_EXCEPTION;
1525: EXCEPTION
1526: WHEN OTHERS THEN
1527: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1528: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1529: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1530: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.populate_az_processes');
1531: fnd_message.set_token('AZW_ERROR_STMT','select language_code .. from fnd_languages');
1532: APP_EXCEPTION.RAISE_EXCEPTION;
1533: END;
1526: WHEN OTHERS THEN
1527: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1528: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1529: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1530: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.populate_az_processes');
1531: fnd_message.set_token('AZW_ERROR_STMT','select language_code .. from fnd_languages');
1532: APP_EXCEPTION.RAISE_EXCEPTION;
1533: END;
1534: get_context('BG', bg_ctx);
1527: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1528: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1529: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1530: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.populate_az_processes');
1531: fnd_message.set_token('AZW_ERROR_STMT','select language_code .. from fnd_languages');
1532: APP_EXCEPTION.RAISE_EXCEPTION;
1533: END;
1534: get_context('BG', bg_ctx);
1535: get_context('IO', io_ctx);
1572: EXCEPTION
1573: WHEN app_exception.application_exception THEN
1574: RAISE;
1575: WHEN OTHERS THEN
1576: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1577: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1578: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1579: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.populate_az_processes');
1580: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
1573: WHEN app_exception.application_exception THEN
1574: RAISE;
1575: WHEN OTHERS THEN
1576: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1577: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1578: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1579: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.populate_az_processes');
1580: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
1581: APP_EXCEPTION.RAISE_EXCEPTION;
1574: RAISE;
1575: WHEN OTHERS THEN
1576: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1577: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1578: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1579: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.populate_az_processes');
1580: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
1581: APP_EXCEPTION.RAISE_EXCEPTION;
1582:
1575: WHEN OTHERS THEN
1576: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1577: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1578: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1579: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.populate_az_processes');
1580: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
1581: APP_EXCEPTION.RAISE_EXCEPTION;
1582:
1583: END populate_az_processes;
1576: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1577: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1578: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1579: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.populate_az_processes');
1580: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
1581: APP_EXCEPTION.RAISE_EXCEPTION;
1582:
1583: END populate_az_processes;
1584:
1644: COMMIT;
1645: EXCEPTION
1646: WHEN OTHERS THEN
1647: ROLLBACK;
1648: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1649: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1650: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1651: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.update_process_comments');
1652: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
1645: EXCEPTION
1646: WHEN OTHERS THEN
1647: ROLLBACK;
1648: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1649: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1650: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1651: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.update_process_comments');
1652: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
1653: APP_EXCEPTION.RAISE_EXCEPTION;
1646: WHEN OTHERS THEN
1647: ROLLBACK;
1648: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1649: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1650: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1651: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.update_process_comments');
1652: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
1653: APP_EXCEPTION.RAISE_EXCEPTION;
1654: END;
1647: ROLLBACK;
1648: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1649: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1650: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1651: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.update_process_comments');
1652: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
1653: APP_EXCEPTION.RAISE_EXCEPTION;
1654: END;
1655:
1648: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1649: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1650: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1651: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.update_process_comments');
1652: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
1653: APP_EXCEPTION.RAISE_EXCEPTION;
1654: END;
1655:
1656: EXCEPTION
1657: WHEN app_exception.application_exception THEN
1658: APP_EXCEPTION.RAISE_EXCEPTION;
1659: WHEN OTHERS THEN
1660: -- DBMS_OUTPUT.PUT_LINE('error: update_process_comments: ' || SQLERRM);
1661: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1662: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1663: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1664: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.update_process_comments');
1665: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
1658: APP_EXCEPTION.RAISE_EXCEPTION;
1659: WHEN OTHERS THEN
1660: -- DBMS_OUTPUT.PUT_LINE('error: update_process_comments: ' || SQLERRM);
1661: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1662: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1663: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1664: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.update_process_comments');
1665: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
1666: APP_EXCEPTION.RAISE_EXCEPTION;
1659: WHEN OTHERS THEN
1660: -- DBMS_OUTPUT.PUT_LINE('error: update_process_comments: ' || SQLERRM);
1661: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1662: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1663: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1664: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.update_process_comments');
1665: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
1666: APP_EXCEPTION.RAISE_EXCEPTION;
1667: END update_process_comments;
1660: -- DBMS_OUTPUT.PUT_LINE('error: update_process_comments: ' || SQLERRM);
1661: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1662: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1663: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1664: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.update_process_comments');
1665: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
1666: APP_EXCEPTION.RAISE_EXCEPTION;
1667: END update_process_comments;
1668:
1661: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1662: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1663: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1664: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.update_process_comments');
1665: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
1666: APP_EXCEPTION.RAISE_EXCEPTION;
1667: END update_process_comments;
1668:
1669:
1692: EXCEPTION
1693: WHEN NO_DATA_FOUND THEN
1694: v_parent_id := NULL;
1695: WHEN OTHERS THEN
1696: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1697: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1698: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1699: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.update_groups_status');
1700: fnd_message.set_token('AZW_ERROR_STMT','select hierarchy_parent_id from az_groups');
1693: WHEN NO_DATA_FOUND THEN
1694: v_parent_id := NULL;
1695: WHEN OTHERS THEN
1696: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1697: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1698: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1699: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.update_groups_status');
1700: fnd_message.set_token('AZW_ERROR_STMT','select hierarchy_parent_id from az_groups');
1701: APP_EXCEPTION.RAISE_EXCEPTION;
1694: v_parent_id := NULL;
1695: WHEN OTHERS THEN
1696: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1697: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1698: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1699: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.update_groups_status');
1700: fnd_message.set_token('AZW_ERROR_STMT','select hierarchy_parent_id from az_groups');
1701: APP_EXCEPTION.RAISE_EXCEPTION;
1702: END;
1695: WHEN OTHERS THEN
1696: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1697: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1698: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1699: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.update_groups_status');
1700: fnd_message.set_token('AZW_ERROR_STMT','select hierarchy_parent_id from az_groups');
1701: APP_EXCEPTION.RAISE_EXCEPTION;
1702: END;
1703:
1696: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1697: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1698: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1699: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.update_groups_status');
1700: fnd_message.set_token('AZW_ERROR_STMT','select hierarchy_parent_id from az_groups');
1701: APP_EXCEPTION.RAISE_EXCEPTION;
1702: END;
1703:
1704: WHILE (v_parent_id IS NOT NULL) LOOP
1710: WHERE ag.hierarchy_parent_id = v_parent_id
1711: AND ag.process_type = g_current_mode;
1712: EXCEPTION
1713: WHEN OTHERS THEN
1714: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1715: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1716: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1717: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.update_groups_status');
1718: fnd_message.set_token('AZW_ERROR_STMT','select count(*) into v_total_kids from az_groups');
1711: AND ag.process_type = g_current_mode;
1712: EXCEPTION
1713: WHEN OTHERS THEN
1714: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1715: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1716: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1717: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.update_groups_status');
1718: fnd_message.set_token('AZW_ERROR_STMT','select count(*) into v_total_kids from az_groups');
1719: APP_EXCEPTION.RAISE_EXCEPTION;
1712: EXCEPTION
1713: WHEN OTHERS THEN
1714: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1715: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1716: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1717: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.update_groups_status');
1718: fnd_message.set_token('AZW_ERROR_STMT','select count(*) into v_total_kids from az_groups');
1719: APP_EXCEPTION.RAISE_EXCEPTION;
1720: END;
1713: WHEN OTHERS THEN
1714: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1715: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1716: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1717: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.update_groups_status');
1718: fnd_message.set_token('AZW_ERROR_STMT','select count(*) into v_total_kids from az_groups');
1719: APP_EXCEPTION.RAISE_EXCEPTION;
1720: END;
1721:
1714: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1715: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1716: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1717: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.update_groups_status');
1718: fnd_message.set_token('AZW_ERROR_STMT','select count(*) into v_total_kids from az_groups');
1719: APP_EXCEPTION.RAISE_EXCEPTION;
1720: END;
1721:
1722: BEGIN
1727: AND ag.process_type = g_current_mode
1728: AND ag.complete_flag <> 'Y';
1729: EXCEPTION
1730: WHEN OTHERS THEN
1731: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1732: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1733: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1734: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.update_groups_status');
1735: fnd_message.set_token('AZW_ERROR_STMT','select count(*) into v_cnt from az_groups');
1728: AND ag.complete_flag <> 'Y';
1729: EXCEPTION
1730: WHEN OTHERS THEN
1731: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1732: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1733: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1734: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.update_groups_status');
1735: fnd_message.set_token('AZW_ERROR_STMT','select count(*) into v_cnt from az_groups');
1736: APP_EXCEPTION.RAISE_EXCEPTION;
1729: EXCEPTION
1730: WHEN OTHERS THEN
1731: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1732: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1733: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1734: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.update_groups_status');
1735: fnd_message.set_token('AZW_ERROR_STMT','select count(*) into v_cnt from az_groups');
1736: APP_EXCEPTION.RAISE_EXCEPTION;
1737: END;
1730: WHEN OTHERS THEN
1731: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1732: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1733: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1734: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.update_groups_status');
1735: fnd_message.set_token('AZW_ERROR_STMT','select count(*) into v_cnt from az_groups');
1736: APP_EXCEPTION.RAISE_EXCEPTION;
1737: END;
1738:
1731: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1732: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1733: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1734: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.update_groups_status');
1735: fnd_message.set_token('AZW_ERROR_STMT','select count(*) into v_cnt from az_groups');
1736: APP_EXCEPTION.RAISE_EXCEPTION;
1737: END;
1738:
1739: IF (v_total_kids <> 0 AND v_cnt = 0) THEN
1744: AND process_type = g_current_mode;
1745: COMMIT;
1746: EXCEPTION
1747: WHEN OTHERS THEN
1748: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1749: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1750: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1751: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.update_groups_status');
1752: fnd_message.set_token('AZW_ERROR_STMT','update az_groups set complete_flag = Y');
1745: COMMIT;
1746: EXCEPTION
1747: WHEN OTHERS THEN
1748: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1749: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1750: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1751: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.update_groups_status');
1752: fnd_message.set_token('AZW_ERROR_STMT','update az_groups set complete_flag = Y');
1753: APP_EXCEPTION.RAISE_EXCEPTION;
1746: EXCEPTION
1747: WHEN OTHERS THEN
1748: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1749: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1750: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1751: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.update_groups_status');
1752: fnd_message.set_token('AZW_ERROR_STMT','update az_groups set complete_flag = Y');
1753: APP_EXCEPTION.RAISE_EXCEPTION;
1754: END;
1747: WHEN OTHERS THEN
1748: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1749: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1750: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1751: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.update_groups_status');
1752: fnd_message.set_token('AZW_ERROR_STMT','update az_groups set complete_flag = Y');
1753: APP_EXCEPTION.RAISE_EXCEPTION;
1754: END;
1755:
1748: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1749: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1750: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1751: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.update_groups_status');
1752: fnd_message.set_token('AZW_ERROR_STMT','update az_groups set complete_flag = Y');
1753: APP_EXCEPTION.RAISE_EXCEPTION;
1754: END;
1755:
1756: BEGIN
1760: WHERE ag.group_id = v_parent_id
1761: AND ag.process_type = g_current_mode;
1762: EXCEPTION
1763: WHEN OTHERS THEN
1764: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1765: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1766: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1767: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.update_groups_status');
1768: fnd_message.set_token('AZW_ERROR_STMT','select hierarchy_parent_id from az_groups');
1761: AND ag.process_type = g_current_mode;
1762: EXCEPTION
1763: WHEN OTHERS THEN
1764: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1765: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1766: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1767: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.update_groups_status');
1768: fnd_message.set_token('AZW_ERROR_STMT','select hierarchy_parent_id from az_groups');
1769: APP_EXCEPTION.RAISE_EXCEPTION;
1762: EXCEPTION
1763: WHEN OTHERS THEN
1764: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1765: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1766: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1767: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.update_groups_status');
1768: fnd_message.set_token('AZW_ERROR_STMT','select hierarchy_parent_id from az_groups');
1769: APP_EXCEPTION.RAISE_EXCEPTION;
1770: END;
1763: WHEN OTHERS THEN
1764: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1765: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1766: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1767: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.update_groups_status');
1768: fnd_message.set_token('AZW_ERROR_STMT','select hierarchy_parent_id from az_groups');
1769: APP_EXCEPTION.RAISE_EXCEPTION;
1770: END;
1771:
1764: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1765: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1766: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1767: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.update_groups_status');
1768: fnd_message.set_token('AZW_ERROR_STMT','select hierarchy_parent_id from az_groups');
1769: APP_EXCEPTION.RAISE_EXCEPTION;
1770: END;
1771:
1772: ELSIF (v_total_kids <> 0 AND v_cnt <> 0) THEN
1779: AND process_type = g_current_mode;
1780: COMMIT;
1781: EXCEPTION
1782: WHEN OTHERS THEN
1783: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1784: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1785: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1786: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.update_groups_status');
1787: fnd_message.set_token('AZW_ERROR_STMT','update az_groups set complete_flag = N');
1780: COMMIT;
1781: EXCEPTION
1782: WHEN OTHERS THEN
1783: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1784: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1785: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1786: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.update_groups_status');
1787: fnd_message.set_token('AZW_ERROR_STMT','update az_groups set complete_flag = N');
1788: APP_EXCEPTION.RAISE_EXCEPTION;
1781: EXCEPTION
1782: WHEN OTHERS THEN
1783: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1784: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1785: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1786: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.update_groups_status');
1787: fnd_message.set_token('AZW_ERROR_STMT','update az_groups set complete_flag = N');
1788: APP_EXCEPTION.RAISE_EXCEPTION;
1789: END;
1782: WHEN OTHERS THEN
1783: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1784: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1785: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1786: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.update_groups_status');
1787: fnd_message.set_token('AZW_ERROR_STMT','update az_groups set complete_flag = N');
1788: APP_EXCEPTION.RAISE_EXCEPTION;
1789: END;
1790:
1783: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1784: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1785: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1786: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.update_groups_status');
1787: fnd_message.set_token('AZW_ERROR_STMT','update az_groups set complete_flag = N');
1788: APP_EXCEPTION.RAISE_EXCEPTION;
1789: END;
1790:
1791: BEGIN
1795: WHERE ag.group_id = v_parent_id
1796: AND ag.process_type = g_current_mode;
1797: EXCEPTION
1798: WHEN OTHERS THEN
1799: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1800: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1801: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1802: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.update_groups_status');
1803: fnd_message.set_token('AZW_ERROR_STMT','select hierarchy_parent_id from az_groups');
1796: AND ag.process_type = g_current_mode;
1797: EXCEPTION
1798: WHEN OTHERS THEN
1799: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1800: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1801: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1802: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.update_groups_status');
1803: fnd_message.set_token('AZW_ERROR_STMT','select hierarchy_parent_id from az_groups');
1804: APP_EXCEPTION.RAISE_EXCEPTION;
1797: EXCEPTION
1798: WHEN OTHERS THEN
1799: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1800: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1801: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1802: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.update_groups_status');
1803: fnd_message.set_token('AZW_ERROR_STMT','select hierarchy_parent_id from az_groups');
1804: APP_EXCEPTION.RAISE_EXCEPTION;
1805: END;
1798: WHEN OTHERS THEN
1799: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1800: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1801: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1802: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.update_groups_status');
1803: fnd_message.set_token('AZW_ERROR_STMT','select hierarchy_parent_id from az_groups');
1804: APP_EXCEPTION.RAISE_EXCEPTION;
1805: END;
1806: END LOOP;
1799: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1800: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1801: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1802: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.update_groups_status');
1803: fnd_message.set_token('AZW_ERROR_STMT','select hierarchy_parent_id from az_groups');
1804: APP_EXCEPTION.RAISE_EXCEPTION;
1805: END;
1806: END LOOP;
1807:
1813: WHEN app_exception.application_exception THEN
1814: RAISE ;
1815: WHEN OTHERS THEN
1816: -- DBMS_OUTPUT.PUT_LINE('error: update_groups_status ' || SQLERRM);
1817: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1818: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1819: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1820: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.update_groups_status');
1821: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
1814: RAISE ;
1815: WHEN OTHERS THEN
1816: -- DBMS_OUTPUT.PUT_LINE('error: update_groups_status ' || SQLERRM);
1817: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1818: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1819: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1820: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.update_groups_status');
1821: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
1822: APP_EXCEPTION.RAISE_EXCEPTION;
1815: WHEN OTHERS THEN
1816: -- DBMS_OUTPUT.PUT_LINE('error: update_groups_status ' || SQLERRM);
1817: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1818: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1819: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1820: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.update_groups_status');
1821: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
1822: APP_EXCEPTION.RAISE_EXCEPTION;
1823:
1816: -- DBMS_OUTPUT.PUT_LINE('error: update_groups_status ' || SQLERRM);
1817: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1818: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1819: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1820: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.update_groups_status');
1821: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
1822: APP_EXCEPTION.RAISE_EXCEPTION;
1823:
1824: END update_groups_status;
1817: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1818: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1819: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1820: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.update_groups_status');
1821: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
1822: APP_EXCEPTION.RAISE_EXCEPTION;
1823:
1824: END update_groups_status;
1825:
1851: EXCEPTION
1852: WHEN NO_DATA_FOUND THEN
1853: v_group_id := NULL;
1854: WHEN OTHERS THEN
1855: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1856: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1857: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1858: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.update_hierarchy_status');
1859: fnd_message.set_token('AZW_ERROR_STMT','select parent_id from az_processes');
1852: WHEN NO_DATA_FOUND THEN
1853: v_group_id := NULL;
1854: WHEN OTHERS THEN
1855: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1856: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1857: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1858: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.update_hierarchy_status');
1859: fnd_message.set_token('AZW_ERROR_STMT','select parent_id from az_processes');
1860: APP_EXCEPTION.RAISE_EXCEPTION;
1853: v_group_id := NULL;
1854: WHEN OTHERS THEN
1855: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1856: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1857: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1858: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.update_hierarchy_status');
1859: fnd_message.set_token('AZW_ERROR_STMT','select parent_id from az_processes');
1860: APP_EXCEPTION.RAISE_EXCEPTION;
1861: END;
1854: WHEN OTHERS THEN
1855: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1856: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1857: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1858: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.update_hierarchy_status');
1859: fnd_message.set_token('AZW_ERROR_STMT','select parent_id from az_processes');
1860: APP_EXCEPTION.RAISE_EXCEPTION;
1861: END;
1862:
1855: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1856: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1857: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1858: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.update_hierarchy_status');
1859: fnd_message.set_token('AZW_ERROR_STMT','select parent_id from az_processes');
1860: APP_EXCEPTION.RAISE_EXCEPTION;
1861: END;
1862:
1863: IF v_group_id is null THEN
1871: AND ap.process_type = g_current_mode
1872: AND ap.parent_id = v_group_id;
1873: EXCEPTION
1874: WHEN OTHERS THEN
1875: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1876: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1877: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1878: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.update_hierarchy_status');
1879: fnd_message.set_token('AZW_ERROR_STMT','select count(*) from az_processes');
1872: AND ap.parent_id = v_group_id;
1873: EXCEPTION
1874: WHEN OTHERS THEN
1875: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1876: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1877: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1878: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.update_hierarchy_status');
1879: fnd_message.set_token('AZW_ERROR_STMT','select count(*) from az_processes');
1880: APP_EXCEPTION.RAISE_EXCEPTION;
1873: EXCEPTION
1874: WHEN OTHERS THEN
1875: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1876: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1877: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1878: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.update_hierarchy_status');
1879: fnd_message.set_token('AZW_ERROR_STMT','select count(*) from az_processes');
1880: APP_EXCEPTION.RAISE_EXCEPTION;
1881: END;
1874: WHEN OTHERS THEN
1875: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1876: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1877: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1878: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.update_hierarchy_status');
1879: fnd_message.set_token('AZW_ERROR_STMT','select count(*) from az_processes');
1880: APP_EXCEPTION.RAISE_EXCEPTION;
1881: END;
1882:
1875: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1876: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1877: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1878: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.update_hierarchy_status');
1879: fnd_message.set_token('AZW_ERROR_STMT','select count(*) from az_processes');
1880: APP_EXCEPTION.RAISE_EXCEPTION;
1881: END;
1882:
1883: IF (v_cnt = 0) THEN
1893: AND ag.process_type = g_current_mode;
1894: COMMIT;
1895: EXCEPTION
1896: WHEN OTHERS THEN
1897: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1898: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1899: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1900: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.update_hierarchy_status');
1901: fnd_message.set_token('AZW_ERROR_STMT','update az_groups set complete_flag');
1894: COMMIT;
1895: EXCEPTION
1896: WHEN OTHERS THEN
1897: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1898: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1899: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1900: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.update_hierarchy_status');
1901: fnd_message.set_token('AZW_ERROR_STMT','update az_groups set complete_flag');
1902: APP_EXCEPTION.RAISE_EXCEPTION;
1895: EXCEPTION
1896: WHEN OTHERS THEN
1897: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1898: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1899: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1900: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.update_hierarchy_status');
1901: fnd_message.set_token('AZW_ERROR_STMT','update az_groups set complete_flag');
1902: APP_EXCEPTION.RAISE_EXCEPTION;
1903: END;
1896: WHEN OTHERS THEN
1897: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1898: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1899: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1900: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.update_hierarchy_status');
1901: fnd_message.set_token('AZW_ERROR_STMT','update az_groups set complete_flag');
1902: APP_EXCEPTION.RAISE_EXCEPTION;
1903: END;
1904:
1897: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1898: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1899: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1900: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.update_hierarchy_status');
1901: fnd_message.set_token('AZW_ERROR_STMT','update az_groups set complete_flag');
1902: APP_EXCEPTION.RAISE_EXCEPTION;
1903: END;
1904:
1905: -- update groups complete status, starting with the leaf group id
1911: WHEN app_exception.application_exception THEN
1912: RAISE;
1913: WHEN OTHERS THEN
1914: -- DBMS_OUTPUT.PUT_LINE('error: update_hierarchy_status ' || SQLERRM);
1915: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1916: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1917: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1918: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.update_hierarchy_status');
1919: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
1912: RAISE;
1913: WHEN OTHERS THEN
1914: -- DBMS_OUTPUT.PUT_LINE('error: update_hierarchy_status ' || SQLERRM);
1915: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1916: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1917: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1918: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.update_hierarchy_status');
1919: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
1920: APP_EXCEPTION.RAISE_EXCEPTION;
1913: WHEN OTHERS THEN
1914: -- DBMS_OUTPUT.PUT_LINE('error: update_hierarchy_status ' || SQLERRM);
1915: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1916: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1917: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1918: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.update_hierarchy_status');
1919: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
1920: APP_EXCEPTION.RAISE_EXCEPTION;
1921: END update_hierarchy_status;
1914: -- DBMS_OUTPUT.PUT_LINE('error: update_hierarchy_status ' || SQLERRM);
1915: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1916: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1917: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1918: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.update_hierarchy_status');
1919: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
1920: APP_EXCEPTION.RAISE_EXCEPTION;
1921: END update_hierarchy_status;
1922:
1915: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1916: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1917: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1918: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.update_hierarchy_status');
1919: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
1920: APP_EXCEPTION.RAISE_EXCEPTION;
1921: END update_hierarchy_status;
1922:
1923:
1949: AND wiav.name = 'AZW_IA_CTXT_ID'
1950: AND wiav.text_value = ctx_id;
1951: EXCEPTION
1952: WHEN OTHERS THEN
1953: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1954: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1955: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1956: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.update_process_status');
1957: fnd_message.set_token('AZW_ERROR_STMT','select count(*) into v_count from wf_items,wf_item_attribute_values');
1950: AND wiav.text_value = ctx_id;
1951: EXCEPTION
1952: WHEN OTHERS THEN
1953: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1954: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1955: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1956: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.update_process_status');
1957: fnd_message.set_token('AZW_ERROR_STMT','select count(*) into v_count from wf_items,wf_item_attribute_values');
1958: APP_EXCEPTION.RAISE_EXCEPTION;
1951: EXCEPTION
1952: WHEN OTHERS THEN
1953: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1954: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1955: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1956: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.update_process_status');
1957: fnd_message.set_token('AZW_ERROR_STMT','select count(*) into v_count from wf_items,wf_item_attribute_values');
1958: APP_EXCEPTION.RAISE_EXCEPTION;
1959: END;
1952: WHEN OTHERS THEN
1953: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1954: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1955: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1956: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.update_process_status');
1957: fnd_message.set_token('AZW_ERROR_STMT','select count(*) into v_count from wf_items,wf_item_attribute_values');
1958: APP_EXCEPTION.RAISE_EXCEPTION;
1959: END;
1960:
1953: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1954: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1955: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1956: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.update_process_status');
1957: fnd_message.set_token('AZW_ERROR_STMT','select count(*) into v_count from wf_items,wf_item_attribute_values');
1958: APP_EXCEPTION.RAISE_EXCEPTION;
1959: END;
1960:
1961: IF (value <> 'N') THEN
1967: AND ap.context_id = TO_NUMBER(ctx_id);
1968: COMMIT;
1969: EXCEPTION
1970: WHEN OTHERS THEN
1971: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1972: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1973: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1974: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.update_process_status');
1975: fnd_message.set_token('AZW_ERROR_STMT','update az_processes set status_code = value');
1968: COMMIT;
1969: EXCEPTION
1970: WHEN OTHERS THEN
1971: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1972: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1973: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1974: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.update_process_status');
1975: fnd_message.set_token('AZW_ERROR_STMT','update az_processes set status_code = value');
1976: APP_EXCEPTION.RAISE_EXCEPTION;
1969: EXCEPTION
1970: WHEN OTHERS THEN
1971: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1972: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1973: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1974: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.update_process_status');
1975: fnd_message.set_token('AZW_ERROR_STMT','update az_processes set status_code = value');
1976: APP_EXCEPTION.RAISE_EXCEPTION;
1977: END;
1970: WHEN OTHERS THEN
1971: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1972: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1973: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1974: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.update_process_status');
1975: fnd_message.set_token('AZW_ERROR_STMT','update az_processes set status_code = value');
1976: APP_EXCEPTION.RAISE_EXCEPTION;
1977: END;
1978: ELSE
1971: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1972: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1973: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1974: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.update_process_status');
1975: fnd_message.set_token('AZW_ERROR_STMT','update az_processes set status_code = value');
1976: APP_EXCEPTION.RAISE_EXCEPTION;
1977: END;
1978: ELSE
1979: IF (v_count <> 0) THEN
1985: AND ap.context_id = TO_NUMBER(ctx_id);
1986: COMMIT;
1987: EXCEPTION
1988: WHEN OTHERS THEN
1989: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1990: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1991: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1992: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.update_process_status');
1993: fnd_message.set_token('AZW_ERROR_STMT','update az_processes set status_code = A');
1986: COMMIT;
1987: EXCEPTION
1988: WHEN OTHERS THEN
1989: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1990: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1991: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1992: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.update_process_status');
1993: fnd_message.set_token('AZW_ERROR_STMT','update az_processes set status_code = A');
1994: APP_EXCEPTION.RAISE_EXCEPTION;
1987: EXCEPTION
1988: WHEN OTHERS THEN
1989: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1990: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1991: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1992: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.update_process_status');
1993: fnd_message.set_token('AZW_ERROR_STMT','update az_processes set status_code = A');
1994: APP_EXCEPTION.RAISE_EXCEPTION;
1995: END;
1988: WHEN OTHERS THEN
1989: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1990: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1991: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1992: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.update_process_status');
1993: fnd_message.set_token('AZW_ERROR_STMT','update az_processes set status_code = A');
1994: APP_EXCEPTION.RAISE_EXCEPTION;
1995: END;
1996: ELSE
1989: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1990: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1991: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1992: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.update_process_status');
1993: fnd_message.set_token('AZW_ERROR_STMT','update az_processes set status_code = A');
1994: APP_EXCEPTION.RAISE_EXCEPTION;
1995: END;
1996: ELSE
1997: BEGIN
2001: AND ap.process_name = p_name
2002: AND ap.context_id = TO_NUMBER(ctx_id);
2003: EXCEPTION
2004: WHEN OTHERS THEN
2005: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
2006: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
2007: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
2008: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.update_process_status');
2009: fnd_message.set_token('AZW_ERROR_STMT','update az_processes set status_code = N');
2002: AND ap.context_id = TO_NUMBER(ctx_id);
2003: EXCEPTION
2004: WHEN OTHERS THEN
2005: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
2006: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
2007: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
2008: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.update_process_status');
2009: fnd_message.set_token('AZW_ERROR_STMT','update az_processes set status_code = N');
2010: APP_EXCEPTION.RAISE_EXCEPTION;
2003: EXCEPTION
2004: WHEN OTHERS THEN
2005: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
2006: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
2007: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
2008: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.update_process_status');
2009: fnd_message.set_token('AZW_ERROR_STMT','update az_processes set status_code = N');
2010: APP_EXCEPTION.RAISE_EXCEPTION;
2011: END;
2004: WHEN OTHERS THEN
2005: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
2006: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
2007: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
2008: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.update_process_status');
2009: fnd_message.set_token('AZW_ERROR_STMT','update az_processes set status_code = N');
2010: APP_EXCEPTION.RAISE_EXCEPTION;
2011: END;
2012: END IF; /* for process complete unchecked */
2005: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
2006: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
2007: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
2008: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.update_process_status');
2009: fnd_message.set_token('AZW_ERROR_STMT','update az_processes set status_code = N');
2010: APP_EXCEPTION.RAISE_EXCEPTION;
2011: END;
2012: END IF; /* for process complete unchecked */
2013: END IF;
2018: WHEN app_exception.application_exception THEN
2019: APP_EXCEPTION.RAISE_EXCEPTION;
2020: WHEN OTHERS THEN
2021: -- DBMS_OUTPUT.PUT_LINE('error: complete_process_status: ' || SQLERRM);
2022: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
2023: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
2024: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
2025: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.update_process_status');
2026: fnd_message.set_token('AZW_ERROR_STMT','select into v_ctx_id');
2019: APP_EXCEPTION.RAISE_EXCEPTION;
2020: WHEN OTHERS THEN
2021: -- DBMS_OUTPUT.PUT_LINE('error: complete_process_status: ' || SQLERRM);
2022: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
2023: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
2024: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
2025: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.update_process_status');
2026: fnd_message.set_token('AZW_ERROR_STMT','select into v_ctx_id');
2027: APP_EXCEPTION.RAISE_EXCEPTION;
2020: WHEN OTHERS THEN
2021: -- DBMS_OUTPUT.PUT_LINE('error: complete_process_status: ' || SQLERRM);
2022: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
2023: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
2024: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
2025: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.update_process_status');
2026: fnd_message.set_token('AZW_ERROR_STMT','select into v_ctx_id');
2027: APP_EXCEPTION.RAISE_EXCEPTION;
2028: END update_process_status;
2021: -- DBMS_OUTPUT.PUT_LINE('error: complete_process_status: ' || SQLERRM);
2022: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
2023: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
2024: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
2025: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.update_process_status');
2026: fnd_message.set_token('AZW_ERROR_STMT','select into v_ctx_id');
2027: APP_EXCEPTION.RAISE_EXCEPTION;
2028: END update_process_status;
2029:
2022: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
2023: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
2024: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
2025: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.update_process_status');
2026: fnd_message.set_token('AZW_ERROR_STMT','select into v_ctx_id');
2027: APP_EXCEPTION.RAISE_EXCEPTION;
2028: END update_process_status;
2029:
2030:
2075: EXCEPTION
2076: WHEN app_exception.application_exception THEN
2077: APP_EXCEPTION.RAISE_EXCEPTION;
2078: WHEN OTHERS THEN
2079: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
2080: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
2081: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
2082: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.AIWStart');
2083: fnd_message.set_token('AZW_ERROR_STMT','BLOCK 1');
2076: WHEN app_exception.application_exception THEN
2077: APP_EXCEPTION.RAISE_EXCEPTION;
2078: WHEN OTHERS THEN
2079: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
2080: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
2081: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
2082: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.AIWStart');
2083: fnd_message.set_token('AZW_ERROR_STMT','BLOCK 1');
2084: APP_EXCEPTION.RAISE_EXCEPTION;
2077: APP_EXCEPTION.RAISE_EXCEPTION;
2078: WHEN OTHERS THEN
2079: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
2080: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
2081: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
2082: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.AIWStart');
2083: fnd_message.set_token('AZW_ERROR_STMT','BLOCK 1');
2084: APP_EXCEPTION.RAISE_EXCEPTION;
2085: END;
2078: WHEN OTHERS THEN
2079: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
2080: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
2081: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
2082: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.AIWStart');
2083: fnd_message.set_token('AZW_ERROR_STMT','BLOCK 1');
2084: APP_EXCEPTION.RAISE_EXCEPTION;
2085: END;
2086:
2079: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
2080: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
2081: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
2082: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.AIWStart');
2083: fnd_message.set_token('AZW_ERROR_STMT','BLOCK 1');
2084: APP_EXCEPTION.RAISE_EXCEPTION;
2085: END;
2086:
2087: BEGIN
2104: EXCEPTION
2105: WHEN app_exception.application_exception THEN
2106: APP_EXCEPTION.RAISE_EXCEPTION;
2107: WHEN OTHERS THEN
2108: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
2109: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
2110: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
2111: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.AIWStart');
2112: fnd_message.set_token('AZW_ERROR_STMT','BLOCK 2');
2105: WHEN app_exception.application_exception THEN
2106: APP_EXCEPTION.RAISE_EXCEPTION;
2107: WHEN OTHERS THEN
2108: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
2109: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
2110: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
2111: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.AIWStart');
2112: fnd_message.set_token('AZW_ERROR_STMT','BLOCK 2');
2113: APP_EXCEPTION.RAISE_EXCEPTION;
2106: APP_EXCEPTION.RAISE_EXCEPTION;
2107: WHEN OTHERS THEN
2108: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
2109: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
2110: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
2111: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.AIWStart');
2112: fnd_message.set_token('AZW_ERROR_STMT','BLOCK 2');
2113: APP_EXCEPTION.RAISE_EXCEPTION;
2114: END;
2107: WHEN OTHERS THEN
2108: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
2109: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
2110: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
2111: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.AIWStart');
2112: fnd_message.set_token('AZW_ERROR_STMT','BLOCK 2');
2113: APP_EXCEPTION.RAISE_EXCEPTION;
2114: END;
2115: end if;
2108: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
2109: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
2110: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
2111: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.AIWStart');
2112: fnd_message.set_token('AZW_ERROR_STMT','BLOCK 2');
2113: APP_EXCEPTION.RAISE_EXCEPTION;
2114: END;
2115: end if;
2116:
2119: EXCEPTION
2120: WHEN app_exception.application_exception THEN
2121: APP_EXCEPTION.RAISE_EXCEPTION;
2122: WHEN OTHERS THEN
2123: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
2124: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
2125: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
2126: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.AIWStart');
2127: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
2120: WHEN app_exception.application_exception THEN
2121: APP_EXCEPTION.RAISE_EXCEPTION;
2122: WHEN OTHERS THEN
2123: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
2124: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
2125: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
2126: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.AIWStart');
2127: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
2128: APP_EXCEPTION.RAISE_EXCEPTION;
2121: APP_EXCEPTION.RAISE_EXCEPTION;
2122: WHEN OTHERS THEN
2123: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
2124: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
2125: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
2126: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.AIWStart');
2127: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
2128: APP_EXCEPTION.RAISE_EXCEPTION;
2129:
2122: WHEN OTHERS THEN
2123: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
2124: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
2125: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
2126: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.AIWStart');
2127: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
2128: APP_EXCEPTION.RAISE_EXCEPTION;
2129:
2130: END AIWStart;
2123: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
2124: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
2125: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
2126: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.AIWStart');
2127: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
2128: APP_EXCEPTION.RAISE_EXCEPTION;
2129:
2130: END AIWStart;
2131:
2245: EXCEPTION
2246: WHEN app_exception.application_exception THEN
2247: RAISE;
2248: WHEN OTHERS THEN
2249: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
2250: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
2251: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
2252: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_old_task_label');
2253: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
2246: WHEN app_exception.application_exception THEN
2247: RAISE;
2248: WHEN OTHERS THEN
2249: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
2250: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
2251: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
2252: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_old_task_label');
2253: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
2254: APP_EXCEPTION.RAISE_EXCEPTION;
2247: RAISE;
2248: WHEN OTHERS THEN
2249: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
2250: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
2251: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
2252: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_old_task_label');
2253: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
2254: APP_EXCEPTION.RAISE_EXCEPTION;
2255: END get_old_task_label;
2248: WHEN OTHERS THEN
2249: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
2250: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
2251: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
2252: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_old_task_label');
2253: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
2254: APP_EXCEPTION.RAISE_EXCEPTION;
2255: END get_old_task_label;
2256:
2249: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
2250: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
2251: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
2252: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_old_task_label');
2253: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
2254: APP_EXCEPTION.RAISE_EXCEPTION;
2255: END get_old_task_label;
2256:
2257:
2316: EXCEPTION
2317: WHEN app_exception.application_exception THEN
2318: RAISE;
2319: WHEN OTHERS THEN
2320: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
2321: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
2322: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
2323: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_new_task_mesg');
2324: fnd_message.set_token('AZW_ERROR_STMT','CURSOR az_task_display_cursor');
2317: WHEN app_exception.application_exception THEN
2318: RAISE;
2319: WHEN OTHERS THEN
2320: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
2321: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
2322: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
2323: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_new_task_mesg');
2324: fnd_message.set_token('AZW_ERROR_STMT','CURSOR az_task_display_cursor');
2325: APP_EXCEPTION.RAISE_EXCEPTION;
2318: RAISE;
2319: WHEN OTHERS THEN
2320: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
2321: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
2322: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
2323: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_new_task_mesg');
2324: fnd_message.set_token('AZW_ERROR_STMT','CURSOR az_task_display_cursor');
2325: APP_EXCEPTION.RAISE_EXCEPTION;
2326: END get_new_task_mesg;
2319: WHEN OTHERS THEN
2320: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
2321: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
2322: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
2323: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_new_task_mesg');
2324: fnd_message.set_token('AZW_ERROR_STMT','CURSOR az_task_display_cursor');
2325: APP_EXCEPTION.RAISE_EXCEPTION;
2326: END get_new_task_mesg;
2327:
2320: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
2321: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
2322: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
2323: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_new_task_mesg');
2324: fnd_message.set_token('AZW_ERROR_STMT','CURSOR az_task_display_cursor');
2325: APP_EXCEPTION.RAISE_EXCEPTION;
2326: END get_new_task_mesg;
2327:
2328:
2362: WHERE organization_id = ctx_id;
2363: END IF;
2364: EXCEPTION
2365: WHEN OTHERS THEN
2366: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
2367: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
2368: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
2369: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.az_start_task');
2370: fnd_message.set_token('AZW_ERROR_STMT','select organization_code from org_access_view');
2363: END IF;
2364: EXCEPTION
2365: WHEN OTHERS THEN
2366: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
2367: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
2368: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
2369: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.az_start_task');
2370: fnd_message.set_token('AZW_ERROR_STMT','select organization_code from org_access_view');
2371: APP_EXCEPTION.RAISE_EXCEPTION;
2364: EXCEPTION
2365: WHEN OTHERS THEN
2366: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
2367: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
2368: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
2369: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.az_start_task');
2370: fnd_message.set_token('AZW_ERROR_STMT','select organization_code from org_access_view');
2371: APP_EXCEPTION.RAISE_EXCEPTION;
2372: END;
2365: WHEN OTHERS THEN
2366: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
2367: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
2368: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
2369: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.az_start_task');
2370: fnd_message.set_token('AZW_ERROR_STMT','select organization_code from org_access_view');
2371: APP_EXCEPTION.RAISE_EXCEPTION;
2372: END;
2373:
2366: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
2367: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
2368: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
2369: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.az_start_task');
2370: fnd_message.set_token('AZW_ERROR_STMT','select organization_code from org_access_view');
2371: APP_EXCEPTION.RAISE_EXCEPTION;
2372: END;
2373:
2374: AIWStart(p_type, p_name, ctx_name, p_role ,ctx_type, ctx_id, org_code,
2382: WHEN app_exception.application_exception THEN
2383: APP_EXCEPTION.RAISE_EXCEPTION;
2384: WHEN OTHERS THEN
2385: ROLLBACK;
2386: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
2387: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
2388: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
2389: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.az_start_task');
2390: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
2383: APP_EXCEPTION.RAISE_EXCEPTION;
2384: WHEN OTHERS THEN
2385: ROLLBACK;
2386: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
2387: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
2388: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
2389: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.az_start_task');
2390: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
2391: APP_EXCEPTION.RAISE_EXCEPTION;
2384: WHEN OTHERS THEN
2385: ROLLBACK;
2386: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
2387: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
2388: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
2389: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.az_start_task');
2390: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
2391: APP_EXCEPTION.RAISE_EXCEPTION;
2392: END az_start_task;
2385: ROLLBACK;
2386: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
2387: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
2388: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
2389: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.az_start_task');
2390: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
2391: APP_EXCEPTION.RAISE_EXCEPTION;
2392: END az_start_task;
2393:
2386: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
2387: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
2388: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
2389: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.az_start_task');
2390: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
2391: APP_EXCEPTION.RAISE_EXCEPTION;
2392: END az_start_task;
2393:
2394:
2418: EXCEPTION
2419: WHEN app_exception.application_exception THEN
2420: APP_EXCEPTION.RAISE_EXCEPTION;
2421: WHEN OTHERS THEN
2422: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
2423: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
2424: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
2425: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.az_reassign_task');
2426: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
2419: WHEN app_exception.application_exception THEN
2420: APP_EXCEPTION.RAISE_EXCEPTION;
2421: WHEN OTHERS THEN
2422: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
2423: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
2424: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
2425: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.az_reassign_task');
2426: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
2427: APP_EXCEPTION.RAISE_EXCEPTION;
2420: APP_EXCEPTION.RAISE_EXCEPTION;
2421: WHEN OTHERS THEN
2422: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
2423: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
2424: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
2425: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.az_reassign_task');
2426: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
2427: APP_EXCEPTION.RAISE_EXCEPTION;
2428: END az_reassign_task;
2421: WHEN OTHERS THEN
2422: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
2423: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
2424: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
2425: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.az_reassign_task');
2426: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
2427: APP_EXCEPTION.RAISE_EXCEPTION;
2428: END az_reassign_task;
2429:
2422: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
2423: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
2424: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
2425: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.az_reassign_task');
2426: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
2427: APP_EXCEPTION.RAISE_EXCEPTION;
2428: END az_reassign_task;
2429:
2430:
2458: EXCEPTION
2459: WHEN app_exception.application_exception THEN
2460: APP_EXCEPTION.RAISE_EXCEPTION;
2461: WHEN OTHERS THEN
2462: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
2463: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
2464: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
2465: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.az_abort_task');
2466: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
2459: WHEN app_exception.application_exception THEN
2460: APP_EXCEPTION.RAISE_EXCEPTION;
2461: WHEN OTHERS THEN
2462: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
2463: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
2464: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
2465: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.az_abort_task');
2466: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
2467: APP_EXCEPTION.RAISE_EXCEPTION;
2460: APP_EXCEPTION.RAISE_EXCEPTION;
2461: WHEN OTHERS THEN
2462: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
2463: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
2464: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
2465: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.az_abort_task');
2466: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
2467: APP_EXCEPTION.RAISE_EXCEPTION;
2468: END az_abort_task;
2461: WHEN OTHERS THEN
2462: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
2463: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
2464: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
2465: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.az_abort_task');
2466: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
2467: APP_EXCEPTION.RAISE_EXCEPTION;
2468: END az_abort_task;
2469:
2462: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
2463: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
2464: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
2465: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.az_abort_task');
2466: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
2467: APP_EXCEPTION.RAISE_EXCEPTION;
2468: END az_abort_task;
2469:
2470:
2494: EXCEPTION
2495: WHEN app_exception.application_exception THEN
2496: APP_EXCEPTION.RAISE_EXCEPTION;
2497: WHEN OTHERS THEN
2498: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
2499: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
2500: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
2501: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_task_label');
2502: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
2495: WHEN app_exception.application_exception THEN
2496: APP_EXCEPTION.RAISE_EXCEPTION;
2497: WHEN OTHERS THEN
2498: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
2499: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
2500: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
2501: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_task_label');
2502: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
2503: APP_EXCEPTION.RAISE_EXCEPTION;
2496: APP_EXCEPTION.RAISE_EXCEPTION;
2497: WHEN OTHERS THEN
2498: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
2499: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
2500: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
2501: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_task_label');
2502: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
2503: APP_EXCEPTION.RAISE_EXCEPTION;
2504: END get_task_label;
2497: WHEN OTHERS THEN
2498: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
2499: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
2500: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
2501: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_task_label');
2502: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
2503: APP_EXCEPTION.RAISE_EXCEPTION;
2504: END get_task_label;
2505:
2498: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
2499: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
2500: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
2501: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_task_label');
2502: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
2503: APP_EXCEPTION.RAISE_EXCEPTION;
2504: END get_task_label;
2505:
2506:
2551: EXCEPTION
2552: WHEN app_exception.application_exception THEN
2553: APP_EXCEPTION.RAISE_EXCEPTION;
2554: WHEN OTHERS THEN
2555: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
2556: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
2557: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
2558: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_task_status');
2559: fnd_message.set_token('AZW_ERROR_STMT','CURSOR az_task_status_cursor');
2552: WHEN app_exception.application_exception THEN
2553: APP_EXCEPTION.RAISE_EXCEPTION;
2554: WHEN OTHERS THEN
2555: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
2556: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
2557: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
2558: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_task_status');
2559: fnd_message.set_token('AZW_ERROR_STMT','CURSOR az_task_status_cursor');
2560: APP_EXCEPTION.RAISE_EXCEPTION;
2553: APP_EXCEPTION.RAISE_EXCEPTION;
2554: WHEN OTHERS THEN
2555: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
2556: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
2557: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
2558: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_task_status');
2559: fnd_message.set_token('AZW_ERROR_STMT','CURSOR az_task_status_cursor');
2560: APP_EXCEPTION.RAISE_EXCEPTION;
2561: END get_task_status;
2554: WHEN OTHERS THEN
2555: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
2556: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
2557: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
2558: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_task_status');
2559: fnd_message.set_token('AZW_ERROR_STMT','CURSOR az_task_status_cursor');
2560: APP_EXCEPTION.RAISE_EXCEPTION;
2561: END get_task_status;
2562:
2555: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
2556: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
2557: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
2558: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_task_status');
2559: fnd_message.set_token('AZW_ERROR_STMT','CURSOR az_task_status_cursor');
2560: APP_EXCEPTION.RAISE_EXCEPTION;
2561: END get_task_status;
2562:
2563:
2607:
2608: CLOSE az_process_active_cursor;
2609: EXCEPTION
2610: WHEN OTHERS THEN
2611: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
2612: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
2613: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
2614: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.populate_process_status');
2615: fnd_message.set_token('AZW_ERROR_STMT','CURSOR az_process_active_cursor');
2608: CLOSE az_process_active_cursor;
2609: EXCEPTION
2610: WHEN OTHERS THEN
2611: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
2612: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
2613: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
2614: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.populate_process_status');
2615: fnd_message.set_token('AZW_ERROR_STMT','CURSOR az_process_active_cursor');
2616: APP_EXCEPTION.RAISE_EXCEPTION;
2609: EXCEPTION
2610: WHEN OTHERS THEN
2611: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
2612: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
2613: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
2614: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.populate_process_status');
2615: fnd_message.set_token('AZW_ERROR_STMT','CURSOR az_process_active_cursor');
2616: APP_EXCEPTION.RAISE_EXCEPTION;
2617: END;
2610: WHEN OTHERS THEN
2611: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
2612: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
2613: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
2614: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.populate_process_status');
2615: fnd_message.set_token('AZW_ERROR_STMT','CURSOR az_process_active_cursor');
2616: APP_EXCEPTION.RAISE_EXCEPTION;
2617: END;
2618:
2611: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
2612: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
2613: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
2614: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.populate_process_status');
2615: fnd_message.set_token('AZW_ERROR_STMT','CURSOR az_process_active_cursor');
2616: APP_EXCEPTION.RAISE_EXCEPTION;
2617: END;
2618:
2619: BEGIN
2623: SET status_code = 'C'
2624: WHERE complete_flag = 'Y';
2625: EXCEPTION
2626: WHEN OTHERS THEN
2627: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
2628: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
2629: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
2630: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.parse_ctxt_id_task');
2631: fnd_message.set_token('AZW_ERROR_STMT','update az_processes status code C');
2624: WHERE complete_flag = 'Y';
2625: EXCEPTION
2626: WHEN OTHERS THEN
2627: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
2628: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
2629: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
2630: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.parse_ctxt_id_task');
2631: fnd_message.set_token('AZW_ERROR_STMT','update az_processes status code C');
2632: APP_EXCEPTION.RAISE_EXCEPTION;
2625: EXCEPTION
2626: WHEN OTHERS THEN
2627: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
2628: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
2629: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
2630: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.parse_ctxt_id_task');
2631: fnd_message.set_token('AZW_ERROR_STMT','update az_processes status code C');
2632: APP_EXCEPTION.RAISE_EXCEPTION;
2633: END;
2626: WHEN OTHERS THEN
2627: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
2628: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
2629: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
2630: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.parse_ctxt_id_task');
2631: fnd_message.set_token('AZW_ERROR_STMT','update az_processes status code C');
2632: APP_EXCEPTION.RAISE_EXCEPTION;
2633: END;
2634:
2627: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
2628: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
2629: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
2630: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.parse_ctxt_id_task');
2631: fnd_message.set_token('AZW_ERROR_STMT','update az_processes status code C');
2632: APP_EXCEPTION.RAISE_EXCEPTION;
2633: END;
2634:
2635: BEGIN
2639: SET status_code = 'N'
2640: WHERE status_code NOT IN ('A', 'C');
2641: EXCEPTION
2642: WHEN OTHERS THEN
2643: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
2644: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
2645: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
2646: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.parse_ctxt_id_task');
2647: fnd_message.set_token('AZW_ERROR_STMT','update az_processes status code N');
2640: WHERE status_code NOT IN ('A', 'C');
2641: EXCEPTION
2642: WHEN OTHERS THEN
2643: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
2644: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
2645: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
2646: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.parse_ctxt_id_task');
2647: fnd_message.set_token('AZW_ERROR_STMT','update az_processes status code N');
2648: APP_EXCEPTION.RAISE_EXCEPTION;
2641: EXCEPTION
2642: WHEN OTHERS THEN
2643: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
2644: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
2645: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
2646: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.parse_ctxt_id_task');
2647: fnd_message.set_token('AZW_ERROR_STMT','update az_processes status code N');
2648: APP_EXCEPTION.RAISE_EXCEPTION;
2649: END;
2642: WHEN OTHERS THEN
2643: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
2644: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
2645: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
2646: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.parse_ctxt_id_task');
2647: fnd_message.set_token('AZW_ERROR_STMT','update az_processes status code N');
2648: APP_EXCEPTION.RAISE_EXCEPTION;
2649: END;
2650:
2643: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
2644: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
2645: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
2646: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.parse_ctxt_id_task');
2647: fnd_message.set_token('AZW_ERROR_STMT','update az_processes status code N');
2648: APP_EXCEPTION.RAISE_EXCEPTION;
2649: END;
2650:
2651: COMMIT;
2655: RAISE;
2656: WHEN OTHERS THEN
2657: -- DBMS_OUTPUT.PUT_LINE('error: populate_process_status: ' || SQLERRM);
2658: ROLLBACK;
2659: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
2660: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
2661: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
2662: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.populate_process_status');
2663: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
2656: WHEN OTHERS THEN
2657: -- DBMS_OUTPUT.PUT_LINE('error: populate_process_status: ' || SQLERRM);
2658: ROLLBACK;
2659: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
2660: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
2661: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
2662: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.populate_process_status');
2663: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
2664: APP_EXCEPTION.RAISE_EXCEPTION;
2657: -- DBMS_OUTPUT.PUT_LINE('error: populate_process_status: ' || SQLERRM);
2658: ROLLBACK;
2659: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
2660: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
2661: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
2662: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.populate_process_status');
2663: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
2664: APP_EXCEPTION.RAISE_EXCEPTION;
2665: END populate_process_status;
2658: ROLLBACK;
2659: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
2660: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
2661: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
2662: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.populate_process_status');
2663: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
2664: APP_EXCEPTION.RAISE_EXCEPTION;
2665: END populate_process_status;
2666:
2659: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
2660: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
2661: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
2662: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.populate_process_status');
2663: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
2664: APP_EXCEPTION.RAISE_EXCEPTION;
2665: END populate_process_status;
2666:
2667:
2698: END LOOP;
2699: CLOSE running_tasks;
2700: EXCEPTION
2701: WHEN OTHERS THEN
2702: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
2703: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
2704: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
2705: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.abort_running_tasks');
2706: fnd_message.set_token('AZW_ERROR_STMT','CURSOR running_tasks');
2699: CLOSE running_tasks;
2700: EXCEPTION
2701: WHEN OTHERS THEN
2702: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
2703: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
2704: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
2705: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.abort_running_tasks');
2706: fnd_message.set_token('AZW_ERROR_STMT','CURSOR running_tasks');
2707: APP_EXCEPTION.RAISE_EXCEPTION;
2700: EXCEPTION
2701: WHEN OTHERS THEN
2702: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
2703: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
2704: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
2705: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.abort_running_tasks');
2706: fnd_message.set_token('AZW_ERROR_STMT','CURSOR running_tasks');
2707: APP_EXCEPTION.RAISE_EXCEPTION;
2708:
2701: WHEN OTHERS THEN
2702: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
2703: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
2704: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
2705: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.abort_running_tasks');
2706: fnd_message.set_token('AZW_ERROR_STMT','CURSOR running_tasks');
2707: APP_EXCEPTION.RAISE_EXCEPTION;
2708:
2709: END abort_running_tasks;
2702: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
2703: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
2704: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
2705: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.abort_running_tasks');
2706: fnd_message.set_token('AZW_ERROR_STMT','CURSOR running_tasks');
2707: APP_EXCEPTION.RAISE_EXCEPTION;
2708:
2709: END abort_running_tasks;
2710:
2749: END IF;
2750:
2751: EXCEPTION
2752: WHEN OTHERS THEN
2753: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
2754: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
2755: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
2756: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.process_has_active_tasks');
2757: fnd_message.set_token('AZW_ERROR_STMT','SELECT COUNT(*) FROM AZ_TASKS_V');
2750:
2751: EXCEPTION
2752: WHEN OTHERS THEN
2753: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
2754: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
2755: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
2756: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.process_has_active_tasks');
2757: fnd_message.set_token('AZW_ERROR_STMT','SELECT COUNT(*) FROM AZ_TASKS_V');
2758: APP_EXCEPTION.RAISE_EXCEPTION;
2751: EXCEPTION
2752: WHEN OTHERS THEN
2753: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
2754: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
2755: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
2756: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.process_has_active_tasks');
2757: fnd_message.set_token('AZW_ERROR_STMT','SELECT COUNT(*) FROM AZ_TASKS_V');
2758: APP_EXCEPTION.RAISE_EXCEPTION;
2759: END process_has_active_tasks;
2752: WHEN OTHERS THEN
2753: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
2754: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
2755: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
2756: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.process_has_active_tasks');
2757: fnd_message.set_token('AZW_ERROR_STMT','SELECT COUNT(*) FROM AZ_TASKS_V');
2758: APP_EXCEPTION.RAISE_EXCEPTION;
2759: END process_has_active_tasks;
2760:
2753: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
2754: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
2755: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
2756: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.process_has_active_tasks');
2757: fnd_message.set_token('AZW_ERROR_STMT','SELECT COUNT(*) FROM AZ_TASKS_V');
2758: APP_EXCEPTION.RAISE_EXCEPTION;
2759: END process_has_active_tasks;
2760:
2761: