DBA Data[Home] [Help]

APPS.AZW_PROC dependencies on FND_MESSAGE

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

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

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

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;

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

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;

Line 75: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.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:

Line 76: fnd_message.set_token('AZW_ERROR_STMT','select group_id from az_groups');

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:

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

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

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

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;

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

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;

Line 109: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.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:

Line 110: fnd_message.set_token('AZW_ERROR_STMT','NODE_ID :'|| node_id);

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:

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

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

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

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;

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

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;

Line 149: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.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:

Line 150: fnd_message.set_token('AZW_ERROR_STMT','select count(*) from az_processes');

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:

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

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

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

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;

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

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;

Line 203: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.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:

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

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:

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

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

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

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;

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

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;

Line 234: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.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:

Line 235: fnd_message.set_token('AZW_ERROR_STMT','NODE_ID:'|| node_id);

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:

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

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

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

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;

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

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;

Line 268: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.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:

Line 269: fnd_message.set_token('AZW_ERROR_STMT','NODE_ID:'|| node_id);

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: --

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

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

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

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;

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

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;

Line 300: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.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:

Line 301: fnd_message.set_token('AZW_ERROR_STMT','NODEID:'|| node_id);

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: --

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

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

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

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;

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

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;

Line 332: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.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:

Line 333: fnd_message.set_token('AZW_ERROR_STMT','NODE_ID:'||node_id);

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:

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

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

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

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;

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

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;

Line 366: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.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:

Line 367: fnd_message.set_token('AZW_ERROR_STMT','NODE_ID:'|| node_id);

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:

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

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

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

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;

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

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;

Line 408: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_group_color');

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:

Line 409: fnd_message.set_token('AZW_ERROR_STMT','select parent_id from az_processes');

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;

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

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

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

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;

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

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;

Line 434: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_group_color');

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

Line 435: fnd_message.set_token('AZW_ERROR_STMT','select color_code from az_groups');

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

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

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

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

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;

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

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;

Line 445: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.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:

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

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: --

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

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

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

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;

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

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;

Line 473: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.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:

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

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: --

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

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

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

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;

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

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:

Line 516: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_context_type');

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;

Line 517: fnd_message.set_token('AZW_ERROR_STMT','select text_default from wf_activity_attributes_vl');

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:

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

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

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

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;

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

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:

Line 567: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_opm_context_name');

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;

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

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:

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

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

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

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;

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

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;

Line 599: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_context_name');

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:

Line 600: fnd_message.set_token('AZW_ERROR_STMT','select name from per_business_groups');

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

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

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

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

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;

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

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;

Line 617: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_context_name');

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:

Line 618: fnd_message.set_token('AZW_ERROR_STMT','select name from org_organization_definitions');

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

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

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

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

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;

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

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;

Line 635: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_context_name');

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:

Line 636: fnd_message.set_token('AZW_ERROR_STMT','select name from hr_operating_units');

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

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

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

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

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;

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

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;

Line 650: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_context_name');

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:

Line 651: fnd_message.set_token('AZW_ERROR_STMT','select name from gl_sets_of_books');

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

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

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

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

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;

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

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;

Line 663: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_context_name');

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:

Line 664: fnd_message.set_token('AZW_ERROR_STMT','select name from sy_orgn_mst');

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;

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

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

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

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;

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

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;

Line 683: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.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:

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

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:

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

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

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

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;

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

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;

Line 720: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.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:

Line 721: fnd_message.set_token('AZW_ERROR_STMT','select application_name from fnd_application_vl');

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:

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

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

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

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;

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

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;

Line 758: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.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:

Line 759: fnd_message.set_token('AZW_ERROR_STMT','select meaning from fnd_lookups');

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:

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

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

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

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 ..

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

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

Line 788: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_hierarchy')

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;

Line 790: fnd_message.set_token('AZW_ERROR_STMT','select language_code ..

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;

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

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

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

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;

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

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;

Line 807: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.task_init');

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:

Line 808: fnd_message.set_token('AZW_ERROR_STMT','select into v_days');

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

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

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

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

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;

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

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;

Line 824: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.task_init');

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:

Line 825: fnd_message.set_token('AZW_ERROR_STMT','select into v_done');

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

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

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

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

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;

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

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;

Line 841: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.task_init');

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:

Line 842: fnd_message.set_token('AZW_ERROR_STMT','select into v_skip');

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;

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

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

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

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;

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

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;

Line 912: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_context');

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:

Line 913: fnd_message.set_token('AZW_ERROR_STMT','CURSOR bg_cursor');

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

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

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

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

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;

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

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;

Line 932: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_context');

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:

Line 933: fnd_message.set_token('AZW_ERROR_STMT','CURSOR io_cursor');

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

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

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

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

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;

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

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;

Line 952: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_context');

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:

Line 953: fnd_message.set_token('AZW_ERROR_STMT','CURSOR ou_cursor');

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

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

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

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

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;

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

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;

Line 972: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_context');

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:

Line 973: fnd_message.set_token('AZW_ERROR_STMT','CURSOR sob_cursor');

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

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

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

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

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;

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

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;

Line 1025: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_context');

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:

Line 1026: fnd_message.set_token('AZW_ERROR_STMT','CURSOR opm_cursor');

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;

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

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

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

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;

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

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:

Line 1040: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.get_context');

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;

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

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:

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

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

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

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;

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

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;

Line 1082: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.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:

Line 1083: fnd_message.set_token('AZW_ERROR_STMT','CURSOR 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:
1087:

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

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

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

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;

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

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;

Line 1123: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.insert_az_processes(param1, param2)');

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:

Line 1124: fnd_message.set_token('AZW_ERROR_STMT','insert into az_processes');

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

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

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

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

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;

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

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;

Line 1141: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.insert_az_processes(param1, param2)');

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;

Line 1142: fnd_message.set_token('AZW_ERROR_STMT','update az_processes');

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;

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

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

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

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;

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

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:

Line 1156: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.insert_az_processes(param1, param2)');

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;

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

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:

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

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

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

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;

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

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;

Line 1190: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.insert_az_processes(param1)');

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:

Line 1191: fnd_message.set_token('AZW_ERROR_STMT','insert into az_processes');

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;

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

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

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

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;

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

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:

Line 1210: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.insert_az_processes(param1)');

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;

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

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:

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

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

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

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;

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

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;

Line 1258: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.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:

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

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: --

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

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

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

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;

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

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:

Line 1301: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.disable_invalid_opm_processes');

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;

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

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:

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

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

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

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;

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

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 ;

Line 1395: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.disable_invalid_processes');

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:

Line 1396: fnd_message.set_token('AZW_ERROR_STMT','select count(*) from az_processes');

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

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

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

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

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;

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

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 ;

Line 1421: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.disable_invalid_processes');

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:

Line 1422: fnd_message.set_token('AZW_ERROR_STMT','CURSOR invalid_bg_processes_cursor');

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

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

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

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

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;

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

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 ;

Line 1446: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.disable_invalid_processes');

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:

Line 1447: fnd_message.set_token('AZW_ERROR_STMT','CURSOR invalid_io_processes_cursor');

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

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

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

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

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;

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

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 ;

Line 1471: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.disable_invalid_processes');

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:

Line 1472: fnd_message.set_token('AZW_ERROR_STMT','CURSOR invalid_ou_processes_cursor');

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;

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

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

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

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;

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

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:

Line 1486: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.disable_invalid_processes');

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:

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

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:

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

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

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

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;

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

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;

Line 1530: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.populate_az_processes');

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

Line 1531: fnd_message.set_token('AZW_ERROR_STMT','select language_code .. from fnd_languages');

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

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

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

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

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;

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

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:

Line 1579: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.populate_az_processes');

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;

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

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:

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

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

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

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;

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

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;

Line 1651: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.update_process_comments');

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:

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

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

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

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

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;

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

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;

Line 1664: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.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:

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

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:

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

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

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

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;

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

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;

Line 1699: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.update_groups_status');

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:

Line 1700: fnd_message.set_token('AZW_ERROR_STMT','select hierarchy_parent_id from az_groups');

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

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

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

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

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;

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

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;

Line 1717: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.update_groups_status');

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:

Line 1718: fnd_message.set_token('AZW_ERROR_STMT','select count(*) into v_total_kids from az_groups');

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

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

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

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

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;

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

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;

Line 1734: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.update_groups_status');

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:

Line 1735: fnd_message.set_token('AZW_ERROR_STMT','select count(*) into v_cnt from az_groups');

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

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

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

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

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;

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

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;

Line 1751: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.update_groups_status');

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:

Line 1752: fnd_message.set_token('AZW_ERROR_STMT','update az_groups set complete_flag = Y');

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

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

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

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

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;

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

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;

Line 1767: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.update_groups_status');

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:

Line 1768: fnd_message.set_token('AZW_ERROR_STMT','select hierarchy_parent_id from az_groups');

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

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

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

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

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;

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

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;

Line 1786: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.update_groups_status');

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:

Line 1787: fnd_message.set_token('AZW_ERROR_STMT','update az_groups set complete_flag = N');

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

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

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

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

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;

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

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;

Line 1802: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.update_groups_status');

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;

Line 1803: fnd_message.set_token('AZW_ERROR_STMT','select hierarchy_parent_id from az_groups');

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:

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

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

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

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;

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

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:

Line 1820: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.update_groups_status');

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;

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

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:

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

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

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

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;

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

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;

Line 1858: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.update_hierarchy_status');

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:

Line 1859: fnd_message.set_token('AZW_ERROR_STMT','select parent_id from az_processes');

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

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

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

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

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;

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

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;

Line 1878: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.update_hierarchy_status');

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:

Line 1879: fnd_message.set_token('AZW_ERROR_STMT','select count(*) from az_processes');

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

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

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

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

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;

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

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;

Line 1900: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.update_hierarchy_status');

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:

Line 1901: fnd_message.set_token('AZW_ERROR_STMT','update az_groups set complete_flag');

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

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

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

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

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;

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

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;

Line 1918: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.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:

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

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:

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

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

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

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;

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

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;

Line 1956: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.update_process_status');

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:

Line 1957: fnd_message.set_token('AZW_ERROR_STMT','select count(*) into v_count from wf_items,wf_item_attribute_values');

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

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

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

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

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;

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

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;

Line 1974: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.update_process_status');

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

Line 1975: fnd_message.set_token('AZW_ERROR_STMT','update az_processes set status_code = value');

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

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

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

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

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;

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

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;

Line 1992: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.update_process_status');

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

Line 1993: fnd_message.set_token('AZW_ERROR_STMT','update az_processes set status_code = A');

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

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

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

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

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;

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

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;

Line 2008: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.update_process_status');

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 */

Line 2009: fnd_message.set_token('AZW_ERROR_STMT','update az_processes set status_code = N');

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;

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

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

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

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;

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

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;

Line 2025: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.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:

Line 2026: fnd_message.set_token('AZW_ERROR_STMT','select into v_ctx_id');

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:

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

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

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

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;

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

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;

Line 2082: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.AIWStart');

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:

Line 2083: fnd_message.set_token('AZW_ERROR_STMT','BLOCK 1');

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

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

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

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

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;

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

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;

Line 2111: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.AIWStart');

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;

Line 2112: fnd_message.set_token('AZW_ERROR_STMT','BLOCK 2');

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:

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

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

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

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;

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

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:

Line 2126: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.AIWStart');

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;

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

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:

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

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

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

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;

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

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;

Line 2252: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.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:

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

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:

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

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

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

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;

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

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;

Line 2323: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.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:

Line 2324: fnd_message.set_token('AZW_ERROR_STMT','CURSOR az_task_display_cursor');

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:

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

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

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

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;

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

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;

Line 2369: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.az_start_task');

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:

Line 2370: fnd_message.set_token('AZW_ERROR_STMT','select organization_code from org_access_view');

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,

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

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

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

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;

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

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;

Line 2389: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.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:

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

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:

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

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

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

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;

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

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;

Line 2425: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.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:

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

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:

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

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

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

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;

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

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;

Line 2465: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.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:

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

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:

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

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

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

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;

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

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;

Line 2501: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.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:

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

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:

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

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

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

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;

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

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;

Line 2558: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.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:

Line 2559: fnd_message.set_token('AZW_ERROR_STMT','CURSOR az_task_status_cursor');

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:

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

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

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

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;

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

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;

Line 2614: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.populate_process_status');

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:

Line 2615: fnd_message.set_token('AZW_ERROR_STMT','CURSOR az_process_active_cursor');

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

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

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

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

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;

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

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;

Line 2630: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.parse_ctxt_id_task');

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:

Line 2631: fnd_message.set_token('AZW_ERROR_STMT','update az_processes status code C');

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

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

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

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

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;

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

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;

Line 2646: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.parse_ctxt_id_task');

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:

Line 2647: fnd_message.set_token('AZW_ERROR_STMT','update az_processes status code N');

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;

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

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

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

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;

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

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;

Line 2662: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.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:

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

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:

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

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

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

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;

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

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:

Line 2705: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.abort_running_tasks');

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;

Line 2706: fnd_message.set_token('AZW_ERROR_STMT','CURSOR 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:

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

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

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

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;

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

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;

Line 2756: fnd_message.set_token('AZW_ERROR_PROC','azw_proc.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:

Line 2757: fnd_message.set_token('AZW_ERROR_STMT','SELECT COUNT(*) FROM AZ_TASKS_V');

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: